GET http://staging.pgdis.com/fiches-recrutement/1

Query Metrics

7 Database Queries
6 Different statements
6.74 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.03 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.fonctions AS fonctions_3, t0.missions AS missions_4, t0.skills AS skills_5, t0.abilities AS abilities_6, t0.candidacy AS candidacy_7, t0.created_at AS created_at_8, t0.start_at AS start_at_9, t0.contrat_type AS contrat_type_10, t0.experience AS experience_11, t0.salary AS salary_12, t0.program AS program_13, t0.advantage AS advantage_14, t0.image_path AS image_path_15, t0.is_active AS is_active_16, t0.service_id AS service_id_17, t0.location_id AS location_id_18 FROM staffing t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.49 ms
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.fonctions AS fonctions_2, s0_.missions AS missions_3, s0_.skills AS skills_4, s0_.abilities AS abilities_5, s0_.candidacy AS candidacy_6, s0_.created_at AS created_at_7, s0_.start_at AS start_at_8, s0_.contrat_type AS contrat_type_9, s0_.experience AS experience_10, s0_.salary AS salary_11, s0_.program AS program_12, s0_.advantage AS advantage_13, s0_.image_path AS image_path_14, s0_.is_active AS is_active_15, s0_.service_id AS service_id_16, s0_.location_id AS location_id_17 FROM staffing s0_ WHERE s0_.id <> ?
Parameters:
[
  1
]
3 1.27 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.displayed_order AS displayed_order_2, c0_.is_in_footer AS is_in_footer_3, c0_.slug AS slug_4, c1_.id AS id_5, c1_.name AS name_6, c1_.displayed_order AS displayed_order_7, c1_.is_in_footer AS is_in_footer_8, c1_.slug AS slug_9, c2_.id AS id_10, c2_.name AS name_11, c2_.displayed_order AS displayed_order_12, c2_.is_in_footer AS is_in_footer_13, c2_.slug AS slug_14, c0_.category_parent_id AS category_parent_id_15, c1_.category_parent_id AS category_parent_id_16, c2_.category_parent_id AS category_parent_id_17 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.category_parent_id LEFT JOIN category c2_ ON c1_.id = c2_.category_parent_id WHERE c0_.category_parent_id IS NULL
Parameters:
[]
4 1.38 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM staffing_location t0 WHERE t0.id = ?
Parameters:
[
  1
]
5 0.98 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM staffing_service t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM staffing_service t0 WHERE t0.id = ?
Parameters:
[
  2
]
7 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.is_in_footer = ?
Parameters:
[
  1
]

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.

Entities Mapping