GET https://speakersfira.asmtech.io/download?page=1&sort%5Bcongress%5D=DESC

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.39 ms
SELECT DISTINCT d0_.id AS id_0, d0_.congress_id AS sclr_1 FROM download d0_ LEFT JOIN congress c1_ ON d0_.congress_id = c1_.id ORDER BY d0_.congress_id DESC LIMIT 20
Parameters:
[]
2 0.50 ms
SELECT d0_.id AS id_0, d0_.created_at AS created_at_1, d0_.status AS status_2, d0_.congress_id AS congress_id_3 FROM download d0_ LEFT JOIN congress c1_ ON d0_.congress_id = c1_.id WHERE d0_.id IN (?, ?) ORDER BY d0_.congress_id DESC
Parameters:
[
  1
  2
]
3 0.37 ms
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM download d0_ LEFT JOIN congress c1_ ON d0_.congress_id = c1_.id
Parameters:
[]
4 0.28 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
]
5 0.27 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
]

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\Download 2
App\Entity\Congress 2

Entities Mapping

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