GET https://cliniquechampel.w-ap.dev/fr/offres-d-emploies/3/secretaire-medical-e

Query Metrics

18 Database Queries
8 Different statements
0.93 ms Query time
0 Invalid entities
9 Managed entities

Queries

Group similar statements

# Time Info
1 0.19 ms
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.editor_state AS editor_state_9, t0.html_content AS html_content_10, t0.contract_type_id AS contract_type_id_11 FROM job_offer t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "3"
]
2 0.12 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\JobOffer"
]
3 0.06 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:
[
  "job-page"
]
4 0.09 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"
]
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:
[
  "1"
  "fr"
  "App\Entity\Category"
]
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\Category"
]
7 0.03 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
Parameters:
[]
8 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:
[
  "1"
  "fr"
  "App\Entity\Surgery"
]
9 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\Surgery"
]
10 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:
[
  "3"
  "fr"
  "App\Entity\Surgery"
]
11 0.02 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"
]
12 0.02 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"
]
13 0.05 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"
]
14 0.04 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
]
15 0.03 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
]
16 0.03 ms
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
]
17 0.04 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\JobOfferContractType"
]
18 0.04 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\Category 2
App\Entity\JobOffer 1
App\Entity\JobOfferContractType 1