Query Metrics
2
Database Queries
2
Different statements
3.12 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.83 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.editor_id AS editor_id_9 FROM calendar t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"calendrier-de-l-avent"
]
|
||||||||||||||||||||||||||||
| 2 | 1.29 ms |
SELECT d0_.id AS id_0, d0_.date AS date_1, d0_.is_available AS is_available_2, p1_.id AS id_3, p1_.name AS name_4, p1_.description AS description_5, p1_.image_name AS image_name_6, p1_.image_size AS image_size_7, p1_.value AS value_8, p1_.created_at AS created_at_9, p1_.updated_at AS updated_at_10, q2_.id AS id_11, q2_.question AS question_12, q2_.answers AS answers_13, q2_.correct_answer AS correct_answer_14, q2_.created_at AS created_at_15, q2_.updated_at AS updated_at_16, d0_.calendar_id AS calendar_id_17, d0_.quiz_id AS quiz_id_18, d0_.prize_id AS prize_id_19, p1_.editor_id AS editor_id_20, q2_.editor_id AS editor_id_21 FROM day d0_ LEFT JOIN prize p1_ ON d0_.prize_id = p1_.id LEFT JOIN quiz q2_ ON d0_.quiz_id = q2_.id WHERE d0_.calendar_id = ? ORDER BY d0_.date ASC
Parameters:
[
6
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Calendar | No errors. |
| App\Entity\Editor | No errors. |
| App\Entity\Day | No errors. |
| App\Entity\Prize | No errors. |
| App\Entity\Quiz | No errors. |
| App\Entity\Participation | No errors. |