GET https://speakersfira.asmtech.io/speaker?page=13&sort%5Bcharge_and_company%5D=ASC

Query Metrics

5 Database Queries
4 Different statements
10.04 ms Query time
0 Invalid entities
24 Managed entities

Queries

Group similar statements

# Time Info
1 1.04 ms
SELECT DISTINCT s0_.id AS id_0, s0_.charge_and_company AS charge_and_company_1 FROM speaker s0_ ORDER BY s0_.charge_and_company ASC LIMIT 20 OFFSET 240
Parameters:
[]
2 3.22 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.charge_and_company AS charge_and_company_2, s0_.bio AS bio_3, s0_.created_at AS created_at_4, s0_.download_id AS download_id_5, s0_.congress_id AS congress_id_6 FROM speaker s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.charge_and_company ASC
Parameters:
[
  193
  411
  322
  341
  157
  298
  37
  9
  236
  145
  178
  197
  208
  240
  118
  304
  359
  392
  244
  364
]
3 0.90 ms
SELECT count(*) AS sclr_0 FROM speaker s0_
Parameters:
[]
4 3.34 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.url AS url_4 FROM congress t0 WHERE t0.id = ?
Parameters:
[
  1
]
5 1.54 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.url AS url_4 FROM congress t0 WHERE t0.id = ?
Parameters:
[
  2
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Speaker 20
App\Entity\Download 2
App\Entity\Congress 2

Entities Mapping

Class Mapping errors
App\Entity\Speaker No errors.
App\Entity\Download No errors.
App\Entity\Congress No errors.