GET http://staging.pgdis.com/recrutement

Query Metrics

6 Database Queries
5 Different statements
6.80 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.18 ms
(32.11%)
1
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
Parameters:
[]
1.80 ms
(26.51%)
2
SELECT t0.id AS id_1, t0.name AS name_2 FROM staffing_service t0 WHERE t0.id = ?
Parameters:
[
  2
]
1.31 ms
(19.19%)
1
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:
[]
1.15 ms
(16.96%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM staffing_location t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.36 ms
(5.23%)
1
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