Query Metrics
6
Database Queries
5
Different statements
6.80 ms
Query time
0
Invalid entities
Grouped Statements
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
Class | Mapping errors |
---|---|
App\Entity\Staffing\Staffing | No errors. |
App\Entity\Staffing\StaffingService | No errors. |
App\Entity\Staffing\StaffingLocation | No errors. |
App\Entity\Product\Category | No errors. |