GET https://cliniquechampel.w-ap.dev/fr/offres-d-emploies

Query Metrics

26 Database Queries
8 Different statements
20.97 ms Query time
0 Invalid entities
16 Managed entities

Grouped Statements

Show all queries

Time Count Info
12.30 ms
(58.68%)
15
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"
]
1.94 ms
(9.27%)
2
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-08-12 00:00:00"
]
1.89 ms
(9.00%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM job_offer_contract_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.50 ms
(7.13%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.weight AS weight_4, t0.html_content AS html_content_5, t0.category_id AS category_id_6, t0.metadata_id AS metadata_id_7 FROM surgery t0 WHERE t0.category_id = ?
Parameters:
[
  1
]
0.87 ms
(4.17%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.weight AS weight_3, s0_.html_content AS html_content_4, c1_.id AS id_5, c1_.position AS position_6, c1_.name AS name_7, c1_.slug AS slug_8, c1_.start_at AS start_at_9, c1_.created_at AS created_at_10, c1_.updated_at AS updated_at_11, s0_.category_id AS category_id_12, s0_.metadata_id AS metadata_id_13, c1_.metadata_id AS metadata_id_14 FROM surgery s0_ LEFT JOIN category c1_ ON s0_.category_id = c1_.id
Parameters:
[]
0.87 ms
(4.13%)
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:
[
  "job-page"
]
0.82 ms
(3.92%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.weight AS weight_3, s0_.html_content AS html_content_4, s0_.category_id AS category_id_5, s0_.metadata_id AS metadata_id_6 FROM surgery s0_ ORDER BY s0_.weight DESC
Parameters:
[]
0.77 ms
(3.69%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.required_degrees AS required_degrees_4, t0.work_schedule AS work_schedule_5, t0.occupation_rate AS occupation_rate_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.html_content AS html_content_9, t0.contract_type_id AS contract_type_id_10 FROM job_offer 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\Surgery 5
App\Entity\JobOffer 5
App\Entity\JobOfferContractType 3
App\Entity\Category 2
App\Entity\PageMetadata 1