GET https://agenda-dev.toutpoitiers.com/agenda/pony-pony-run-run-1

Query Metrics

5 Database Queries
5 Different statements
9.05 ms Query time
0 Invalid entities
7 Managed entities

Queries

Group similar statements

# Time Info
1 5.37 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, e0_.scrapper_event_id AS scrapper_event_id_20, e0_.created_by_id AS created_by_id_21, e0_.festival_id AS festival_id_22 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 LEFT JOIN event_scrapper e3_ ON e0_.scrapper_event_id = e3_.id WHERE e0_.slug = ? AND e0_.visible = ?
Parameters:
[
  "pony-pony-run-run-1"
  1
]
2 0.83 ms
SELECT t0.id AS id_1, t0.role AS role_2, t0.event_id AS event_id_3, t0.place_id AS place_id_4 FROM event_place_link t0 WHERE t0.event_id = ?
Parameters:
[
  1739
]
3 1.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.adresse AS adresse_3, t0.slug AS slug_4, t0.ville AS ville_5, t0.codepostal AS codepostal_6, t0.description AS description_7, t0.telephone AS telephone_8, t0.email AS email_9, t0.url AS url_10, t0.proprietaire_id AS proprietaire_id_11 FROM place t0 WHERE t0.id = ?
Parameters:
[
  7
]
4 0.84 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM event_category t0 INNER JOIN event_event_category ON t0.id = event_event_category.event_category_id WHERE event_event_category.event_id = ?
Parameters:
[
  1739
]
5 0.69 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url_website AS url_website_3, t0.url_to_scan AS url_to_scan_4, t0.last_scan AS last_scan_5, t0.code AS code_6, t0.is_with_scrap_child AS is_with_scrap_child_7, t0.default_location_id AS default_location_id_8, t0.default_organizer_id AS default_organizer_id_9, t0.default_category_id AS default_category_id_10 FROM event_scrapper t0 WHERE t0.id = ?
Parameters:
[
  10
]

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\EventPlace 2
App\Entity\Event 1
App\Entity\EventScrapper 1
App\Entity\User 1
App\Entity\Place 1
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\EventPlace No errors.
App\Entity\Place No errors.
App\Entity\Horaires No errors.
App\Entity\CategoryMapper No errors.