Query Metrics
2
Database Queries
2
Different statements
4.11 ms
Query time
0
Invalid entities
1
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 3.77 ms |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.creation_date AS creation_date_3, e0_.url AS url_4, e0_.slug AS slug_5, e0_.last_update AS last_update_6, e0_.visible AS visible_7, e0_.date_debut AS date_debut_8, e0_.date_fin AS date_fin_9, e0_.uuid_tmp AS uuid_tmp_10, e0_.image AS image_11, e0_.location_fallback AS location_fallback_12, e0_.organizers_fallback AS organizers_fallback_13, e0_.image_name AS image_name_14, e0_.image_size AS image_size_15, e0_.updated_at AS updated_at_16, e0_.price AS price_17, e0_.exclude_from_agenda AS exclude_from_agenda_18, e0_.horaires_du_lieu AS horaires_du_lieu_19, e1_.id AS id_20, e1_.name AS name_21, e1_.slug AS slug_22, e0_.scrapper_event_id AS scrapper_event_id_23, e0_.created_by_id AS created_by_id_24, e0_.festival_id AS festival_id_25 FROM event e0_ LEFT JOIN event_event_category e2_ ON e0_.id = e2_.event_id LEFT JOIN event_category e1_ ON e1_.id = e2_.event_category_id WHERE e0_.date_debut <= ? AND ((e0_.date_fin IS NULL AND e0_.date_debut >= ? AND e0_.date_debut < ?) OR (e0_.date_fin IS NOT NULL AND e0_.date_debut <= ? AND e0_.date_fin >= ?)) AND e0_.visible = ? AND (e0_.exclude_from_agenda = ? OR e0_.exclude_from_agenda IS NULL) AND e1_.slug = ? ORDER BY e0_.date_debut ASC
Parameters:
[ "2026-06-24 00:00:00" "2026-06-23 00:00:00" "2026-06-24 00:00:00" "2026-06-24 00:00:00" "2026-06-23 00:00:00" 1 0 "spectacle" ]
|
||||||||||||||||||||||||||||
| 2 | 0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM event_category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"spectacle"
]
|
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\EventCategory | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Event | No errors. |
| App\Entity\EventCategory | No errors. |
| App\Entity\EventScrapper | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Festival | No errors. |
| App\Entity\CategoryMapper | No errors. |