GET https://agendalbp.netissedev.com/admin/event/event/edit/53

Query Metrics

17 Database Queries
17 Different statements
13.65 ms Query time
0 Invalid entities
30 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.47 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.branch AS branch_7, t0.is_sso AS is_sso_8, t0.societe AS societe_9, t0.code_branche AS code_branche_10, t0.code_regate AS code_regate_11, t0.poste_vlpuser AS poste_vlpuser_12, t0.poste_vlp_site AS poste_vlp_site_13, t0.deleted_at AS deleted_at_14, t0.reset_token AS reset_token_15, t0.password_requested_at AS password_requested_at_16, t0.code AS code_17, t0.push_notification_enabled AS push_notification_enabled_18, t0.email_notification_enabled AS email_notification_enabled_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.status_id AS status_id_22, t0.default_site_id AS default_site_id_23 FROM user t0 WHERE t0.id = ?
Parameters:
[
  3
]
2 1.23 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.organisator AS organisator_3, t0.date_from AS date_from_4, t0.date_to AS date_to_5, t0.url AS url_6, t0.description AS description_7, t0.is_publish AS is_publish_8, t0.address_distancing AS address_distancing_9, t0.address_face_to_face AS address_face_to_face_10, t0.max_inscription_distancing AS max_inscription_distancing_11, t0.min_likes_to_display AS min_likes_to_display_12, t0.max_inscription_face_to_face AS max_inscription_face_to_face_13, t0.url_distancing AS url_distancing_14, t0.deleted_at AS deleted_at_15, t0.is_interested AS is_interested_16, t0.is_practice AS is_practice_17, t0.url_externe AS url_externe_18, t0.address_externe AS address_externe_19, t0.max_inscription_externe AS max_inscription_externe_20, t0.count_inscription_distancing AS count_inscription_distancing_21, t0.count_inscription_face_to_face AS count_inscription_face_to_face_22, t0.count_inscription_externe AS count_inscription_externe_23, t0.restricted_to_site_staff AS restricted_to_site_staff_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.event_type_id AS event_type_id_27, t0.category_id AS category_id_28, t0.deleted_by_id AS deleted_by_id_29, t0.created_by_id AS created_by_id_30 FROM event t0 WHERE t0.id = ?
Parameters:
[
  "53"
]
3 0.93 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM event_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
4 1.81 ms
SELECT t0.id AS id_1, t0.file AS file_2, t0.title AS title_3, t0.extension AS extension_4, t0.size AS size_5, t0.path AS path_6, t0.origin AS origin_7, t0.origin_id AS origin_id_8, t0.type AS type_9, t0.position AS position_10, t0.deleted_at AS deleted_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.origin_id AS origin_id_14, t0.origin_id AS origin_id_15 FROM media t0 WHERE t0.origin = ? AND t0.origin_id = ? AND t0.type = ? AND t0.deleted_at IS NULL LIMIT 1
Parameters:
[
  "App\Entity\Event\Event"
  53
  "vignette_list"
]
5 1.05 ms
SELECT m0_.id AS id_0, m0_.file AS file_1, m0_.title AS title_2, m0_.extension AS extension_3, m0_.size AS size_4, m0_.path AS path_5, m0_.origin AS origin_6, m0_.origin_id AS origin_id_7, m0_.type AS type_8, m0_.position AS position_9, m0_.deleted_at AS deleted_at_10, m0_.created_at AS created_at_11, m0_.updated_at AS updated_at_12, m0_.origin_id AS origin_id_13, m0_.origin_id AS origin_id_14 FROM media m0_ WHERE m0_.origin = ? AND m0_.origin_id = ? AND m0_.deleted_at IS NULL ORDER BY m0_.position ASC
Parameters:
[
  "App\Entity\Event\Event"
  53
]
6 0.50 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4, t0.site_id AS site_id_5 FROM user_site t0 WHERE t0.user_id = ?
Parameters:
[
  3
]
7 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.deleted_at AS deleted_at_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM site t0 WHERE t0.id = ?
Parameters:
[
  6
]
8 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM profile t0 INNER JOIN event_profile ON t0.id = event_profile.profile_id WHERE event_profile.event_id = ?
Parameters:
[
  53
]
9 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.deleted_at AS deleted_at_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM site t0 INNER JOIN event_site ON t0.id = event_site.site_id WHERE event_site.event_id = ?
Parameters:
[
  53
]
10 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.color AS color_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM category t0 WHERE t0.id = ?
Parameters:
[
  4
]
11 0.27 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.deleted_at AS deleted_at_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4 FROM site s0_ WHERE s0_.deleted_at IS NULL
Parameters:
[]
12 0.25 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.value AS value_2, e0_.deleted_at AS deleted_at_3, e0_.created_at AS created_at_4, e0_.updated_at AS updated_at_5 FROM event_type e0_ WHERE e0_.deleted_at IS NULL
Parameters:
[]
13 0.27 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.value AS value_2, c0_.color AS color_3, c0_.deleted_at AS deleted_at_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6 FROM category c0_ WHERE c0_.deleted_at IS NULL
Parameters:
[]
14 0.22 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value AS value_2, p0_.deleted_at AS deleted_at_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5 FROM profile p0_ WHERE p0_.deleted_at IS NULL
Parameters:
[]
15 0.28 ms
SELECT MIN(YEAR(e0_.date_to)) AS sclr_0, YEAR(CURRENT_DATE) AS sclr_1 FROM event e0_
Parameters:
[]
16 0.55 ms
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.date_from AS date_from_2, e0_.date_to AS date_to_3, MONTH(e0_.date_to) AS sclr_4, YEAR(e0_.date_to) AS sclr_5 FROM event e0_ LEFT JOIN event_type e1_ ON e0_.event_type_id = e1_.id LEFT JOIN category c2_ ON e0_.category_id = c2_.id WHERE e0_.deleted_at IS NULL AND e0_.date_to < ? ORDER BY e0_.date_to ASC
Parameters:
[
  "2026-11-03 18:37:23"
]
17 3.43 ms
SELECT t0.id AS id_1, t0.send_at AS send_at_2, t0.sending_date AS sending_date_3, t0.sent_at AS sent_at_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.template_email_id AS template_email_id_8, t0.event_id AS event_id_9, t0.event_profile_id AS event_profile_id_10, t0.user_event_status_id AS user_event_status_id_11 FROM event_notification t0 WHERE t0.event_id = ?
Parameters:
[
  53
]

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\User\Site 15
App\Entity\Event\EventType 4
App\Entity\Event\Category 4
App\Entity\User\User 2
App\Entity\Event\Profile 2
App\Entity\User\UserStatus 1
App\Entity\Event\Event 1
App\Entity\User\UserSite 1