GET https://cliniquechampel.w-ap.dev/fr/%C3%A9quipe

Query Metrics

58 Database Queries
8 Different statements
2.66 ms Query time
0 Invalid entities
73 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.23 ms
(46.13%)
37
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\Category"
]
0.38 ms
(14.14%)
12
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›­¡[•zð…¦§\x04¯‡Œà"
]
0.33 ms
(12.43%)
1
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_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.linkedin_profile AS linkedin_profile_14, p0_.picture_id AS picture_id_15, p0_.metadata_id AS metadata_id_16 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' ORDER BY p0_.last_name ASC
Parameters:
[]
0.21 ms
(8.07%)
1
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_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.linkedin_profile AS linkedin_profile_14, p0_.picture_id AS picture_id_15, p0_.metadata_id AS metadata_id_16 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' ORDER BY p0_.last_name ASC
Parameters:
[]
0.21 ms
(7.74%)
1
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"
]
0.15 ms
(5.73%)
4
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:
[
  5
]
0.08 ms
(2.89%)
1
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_.name AS name_7, c1_.slug AS slug_8, c1_.created_at AS created_at_9, c1_.updated_at AS updated_at_10, s0_.category_id AS category_id_11, s0_.metadata_id AS metadata_id_12, c1_.metadata_id AS metadata_id_13 FROM surgery s0_ LEFT JOIN category c1_ ON s0_.category_id = c1_.id
Parameters:
[]
0.08 ms
(2.86%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.metadata_id AS metadata_id_6 FROM category t0
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\Practitioner 18
App\Entity\StaticMediaObject 18
App\Entity\PageMetadata 18
App\Entity\Surgery 15
App\Entity\Category 4