Query Metrics
7
Database Queries
6
Different statements
6.74 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.03 ms (30.05%) |
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 WHERE t0.id = ?
Parameters:
[
1
]
|
1.38 ms (20.48%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM staffing_location t0 WHERE t0.id = ?
Parameters:
[
1
]
|
1.27 ms (18.77%) |
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.20 ms (17.78%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM staffing_service t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.49 ms (7.22%) |
1 |
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
]
|
0.38 ms (5.70%) |
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. |