Query Metrics
5
Database Queries
5
Different statements
1.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.39 ms (23.84%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.lock_menu AS lock_menu_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.style_button AS style_button_8, t0.first_connexion AS first_connexion_9, t0.dark AS dark_10, t0.enable AS enable_11, t0.display_my_intervention AS display_my_intervention_12, t0.number_element_per_page AS number_element_per_page_13, t0.initials AS initials_14, t0.last_start_import_date AS last_start_import_date_15, t0.last_end_import_date AS last_end_import_date_16, t0.category_id AS category_id_17 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
55
]
|
|
0.37 ms (22.39%) |
1 |
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.lock_menu AS lock_menu_4, u0_.firstname AS firstname_5, u0_.lastname AS lastname_6, u0_.style_button AS style_button_7, u0_.first_connexion AS first_connexion_8, u0_.dark AS dark_9, u0_.enable AS enable_10, u0_.display_my_intervention AS display_my_intervention_11, u0_.number_element_per_page AS number_element_per_page_12, u0_.initials AS initials_13, u0_.last_start_import_date AS last_start_import_date_14, u0_.last_end_import_date AS last_end_import_date_15, u0_.id AS id_16, u0_.username AS username_17, u0_.roles AS roles_18, u0_.password AS password_19, u0_.lock_menu AS lock_menu_20, u0_.firstname AS firstname_21, u0_.lastname AS lastname_22, u0_.style_button AS style_button_23, u0_.first_connexion AS first_connexion_24, u0_.dark AS dark_25, u0_.enable AS enable_26, u0_.display_my_intervention AS display_my_intervention_27, u0_.number_element_per_page AS number_element_per_page_28, u0_.initials AS initials_29, u0_.last_start_import_date AS last_start_import_date_30, u0_.last_end_import_date AS last_end_import_date_31 FROM `user` u0_ LEFT JOIN category c1_ ON u0_.category_id = c1_.id ORDER BY u0_.enable DESC, u0_.firstname ASC, u0_.lastname ASC
Parameters:
[] |
|
0.36 ms (21.66%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.phone AS phone_2, c0_.principal_contact AS principal_contact_3, c0_.priority AS priority_4, c0_.town AS town_5, c0_.postal_code AS postal_code_6, c0_.address AS address_7, c0_.address2 AS address2_8, c0_.activity_sector AS activity_sector_9, c0_.picture AS picture_10, c0_.enable AS enable_11, c0_.siret AS siret_12, c0_.created_at AS created_at_13, c0_.number_poste AS number_poste_14 FROM customer c0_ ORDER BY c0_.name ASC
Parameters:
[] |
|
0.27 ms (16.24%) |
1 |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.display AS display_2 FROM type_ticket t0_ WHERE t0_.display = 1 ORDER BY t0_.name ASC
Parameters:
[] |
|
0.26 ms (15.88%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.display AS display_2, c0_.color AS color_3 FROM category c0_ WHERE c0_.display = 1 ORDER BY c0_.name ASC
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Intervention | No errors. |
| App\Entity\Customer | No errors. |
| App\Entity\TypeTicket | No errors. |