GET https://cliniquechampel.w-ap.dev/fr/%C3%A9quipe?letter=Z

Query Metrics

22 Database Queries
9 Different statements
2.46 ms Query time
0 Invalid entities
16 Managed entities

Queries

Group similar statements

# Time Info
1 0.69 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.first_name AS first_name_2, p0_.last_name AS last_name_3, p0_.slug AS slug_4, p0_.degrees AS degrees_5, p0_.certifications AS certifications_6, p0_.office_phone AS office_phone_7, p0_.office_address AS office_address_8, p0_.email AS email_9, p0_.vip_level AS vip_level_10, p0_.position AS position_11, p0_.start_at AS start_at_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p0_.linkedin_profile AS linkedin_profile_15, p0_.picture_id AS picture_id_16, p0_.metadata_id AS metadata_id_17 FROM practitioner p0_ INNER JOIN practitioner_category p2_ ON p0_.id = p2_.practitioner_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.slug <> 'anesthesiology' AND p0_.start_at IS NOT NULL AND p0_.start_at <= ? AND p0_.last_name LIKE ? ORDER BY p0_.last_name ASC
Parameters:
[
  "2026-04-04 00:00:00"
  "Z%"
]
2 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.page_title AS page_title_5, t0.og_title AS og_title_6, t0.og_description AS og_description_7, t0.keywords AS keywords_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail_id AS thumbnail_id_11 FROM page_metadata t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "team-page"
]
3 0.34 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.first_name AS first_name_2, p0_.last_name AS last_name_3, p0_.slug AS slug_4, p0_.degrees AS degrees_5, p0_.certifications AS certifications_6, p0_.office_phone AS office_phone_7, p0_.office_address AS office_address_8, p0_.email AS email_9, p0_.vip_level AS vip_level_10, p0_.position AS position_11, p0_.start_at AS start_at_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p0_.linkedin_profile AS linkedin_profile_15, p0_.picture_id AS picture_id_16, p0_.metadata_id AS metadata_id_17 FROM practitioner p0_ INNER JOIN practitioner_category p2_ ON p0_.id = p2_.practitioner_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.slug = 'anesthesiology' AND p0_.start_at IS NOT NULL AND p0_.start_at <= ? ORDER BY p0_.last_name ASC
Parameters:
[
  "2026-04-04 00:00:00"
]
4 0.11 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "1"
  "fr"
  "App\Entity\Practitioner"
]
5 0.05 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "4"
  "fr"
  "App\Entity\Practitioner"
]
6 0.03 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "2"
  "fr"
  "App\Entity\Practitioner"
]
7 0.08 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.weight AS weight_3, s0_.editor_state AS editor_state_4, s0_.html_content AS html_content_5, c1_.id AS id_6, c1_.position AS position_7, c1_.name AS name_8, c1_.slug AS slug_9, c1_.start_at AS start_at_10, c1_.created_at AS created_at_11, c1_.updated_at AS updated_at_12, s0_.category_id AS category_id_13, s0_.metadata_id AS metadata_id_14, c1_.metadata_id AS metadata_id_15 FROM surgery s0_ LEFT JOIN category c1_ ON s0_.category_id = c1_.id
Parameters:
[]
8 0.09 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "1"
  "fr"
  "App\Entity\Surgery"
]
9 0.07 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "1"
  "fr"
  "App\Entity\Category"
]
10 0.06 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "2"
  "fr"
  "App\Entity\Surgery"
]
11 0.06 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "3"
  "fr"
  "App\Entity\Surgery"
]
12 0.05 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "4"
  "fr"
  "App\Entity\Surgery"
]
13 0.06 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "5"
  "fr"
  "App\Entity\Surgery"
]
14 0.10 ms
SELECT c0_.id AS id_0, c0_.position AS position_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.start_at AS start_at_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.metadata_id AS metadata_id_7 FROM category c0_ WHERE c0_.slug NOT LIKE ? AND (c0_.start_at IS NULL OR c0_.start_at <= ?) ORDER BY c0_.position ASC
Parameters:
[
  "anesthe%"
  "2026-04-04 00:00:00"
]
15 0.03 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "2"
  "fr"
  "App\Entity\Category"
]
16 0.08 ms
SELECT c0_.id AS id_0, c0_.position AS position_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.start_at AS start_at_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.metadata_id AS metadata_id_7 FROM category c0_ WHERE c0_.slug NOT LIKE ? AND (c0_.start_at IS NULL OR c0_.start_at <= ?) ORDER BY c0_.position ASC
Parameters:
[
  "anesthe%"
  "2026-04-04 00:00:00"
]
17 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.weight AS weight_4, t0.editor_state AS editor_state_5, t0.html_content AS html_content_6, t0.category_id AS category_id_7, t0.metadata_id AS metadata_id_8 FROM surgery t0 WHERE t0.category_id = ?
Parameters:
[
  1
]
18 0.06 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.weight AS weight_4, t0.editor_state AS editor_state_5, t0.html_content AS html_content_6, t0.category_id AS category_id_7, t0.metadata_id AS metadata_id_8 FROM surgery t0 WHERE t0.category_id = ?
Parameters:
[
  2
]
19 0.09 ms
SELECT t0.file_path AS file_path_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM static_media_object t0 WHERE t0.id = ?
Parameters:
[
  b"\x01œº¤\x16¢ta‚jc(_\x06±á"
]
20 0.09 ms
SELECT t0.file_path AS file_path_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM static_media_object t0 WHERE t0.id = ?
Parameters:
[
  b"\x01œº¤\x17\x01pǐ©—©XÕu-"
]
21 0.06 ms
SELECT t0.file_path AS file_path_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM static_media_object t0 WHERE t0.id = ?
Parameters:
[
  b"\x01œº¤\x16Ôt\x15¨m©îØœù^"
]
22 0.09 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.weight AS weight_3, s0_.editor_state AS editor_state_4, s0_.html_content AS html_content_5, s0_.category_id AS category_id_6, s0_.metadata_id AS metadata_id_7 FROM surgery s0_ ORDER BY s0_.weight DESC
Parameters:
[]

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\Surgery 5
App\Entity\Practitioner 3
App\Entity\StaticMediaObject 3
App\Entity\PageMetadata 3
App\Entity\Category 2