Query Metrics
32
Database Queries
6
Different statements
5.67 ms
Query time
7
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.34 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.prenom AS prenom_5, t0.nom AS nom_6, t0.initiales AS initiales_7, t0.matricule AS matricule_8, t0.actif AS actif_9, t0.carte_clef_rendu AS carte_clef_rendu_10, t0.rappel_sms AS rappel_sms_11, t0.telephone AS telephone_12, t0.telephone_pro AS telephone_pro_13, t0.ville_id AS ville_id_14, t0.ville_attache_id AS ville_attache_id_15, t0.systeme_client_id AS systeme_client_id_16 FROM user t0 WHERE t0.id = ?
Parameters:
[
14
]
|
| 2 | 0.40 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.prenom AS prenom_4, u0_.nom AS nom_5, u0_.initiales AS initiales_6, u0_.matricule AS matricule_7, u0_.actif AS actif_8, u0_.carte_clef_rendu AS carte_clef_rendu_9, u0_.rappel_sms AS rappel_sms_10, u0_.telephone AS telephone_11, u0_.telephone_pro AS telephone_pro_12, u0_.ville_id AS ville_id_13, u0_.ville_attache_id AS ville_attache_id_14, u0_.systeme_client_id AS systeme_client_id_15 FROM user u0_ WHERE u0_.roles LIKE ? AND u0_.systeme_client_id = ? AND u0_.actif = 1 ORDER BY u0_.prenom ASC
Parameters:
[ "%ROLE_CHAUFFEUR%" 1 ] |
| 3 | 0.54 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.date AS date_3, t0.text AS text_4, t0.valide AS valide_5, t0.vidange AS vidange_6, t0.filtre_huile AS filtre_huile_7, t0.filtre_air AS filtre_air_8, t0.filtre_go AS filtre_go_9, t0.courroie AS courroie_10, t0.prix AS prix_11, t0.heure_moteur AS heure_moteur_12, t0.created_at AS created_at_13, t0.sinistre AS sinistre_14, t0.camion_id AS camion_id_15, t0.remorque_id AS remorque_id_16, t0.divers_id AS divers_id_17 FROM facture t0 WHERE t0.valide = ?
Parameters:
[
0
]
|
| 4 | 0.19 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.actif AS actif_3, t0.numero AS numero_4, t0.marque AS marque_5, t0.genre AS genre_6, t0.cat AS cat_7, t0.reference_moteur AS reference_moteur_8, t0.date_immat AS date_immat_9, t0.duree_entretien AS duree_entretien_10, t0.nbr_essieux AS nbr_essieux_11, t0.fin_contrat_constructeur AS fin_contrat_constructeur_12, t0.systeme_client_id AS systeme_client_id_13, t0.constructeur_id AS constructeur_id_14 FROM remorque t0 WHERE t0.id = ?
Parameters:
[
"12"
]
|
| 5 | 0.41 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.date AS date_3, t0.text AS text_4, t0.valide AS valide_5, t0.vidange AS vidange_6, t0.filtre_huile AS filtre_huile_7, t0.filtre_air AS filtre_air_8, t0.filtre_go AS filtre_go_9, t0.courroie AS courroie_10, t0.prix AS prix_11, t0.heure_moteur AS heure_moteur_12, t0.created_at AS created_at_13, t0.sinistre AS sinistre_14, t0.camion_id AS camion_id_15, t0.remorque_id AS remorque_id_16, t0.divers_id AS divers_id_17 FROM facture t0 WHERE t0.remorque_id = ? ORDER BY t0.date DESC
Parameters:
[
12
]
|
| 6 | 0.19 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
1105
]
|
| 7 | 0.16 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
1178
]
|
| 8 | 0.18 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
1120
]
|
| 9 | 0.17 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
1072
]
|
| 10 | 0.16 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
1022
]
|
| 11 | 0.15 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
1014
]
|
| 12 | 0.14 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
1193
]
|
| 13 | 0.15 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
770
]
|
| 14 | 0.15 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
769
]
|
| 15 | 0.15 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
843
]
|
| 16 | 0.12 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
1148
]
|
| 17 | 0.11 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
642
]
|
| 18 | 0.15 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
920
]
|
| 19 | 0.12 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
468
]
|
| 20 | 0.12 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
412
]
|
| 21 | 0.12 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
317
]
|
| 22 | 0.15 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
548
]
|
| 23 | 0.12 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
316
]
|
| 24 | 0.12 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
258
]
|
| 25 | 0.15 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
106
]
|
| 26 | 0.13 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
79
]
|
| 27 | 0.16 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
170
]
|
| 28 | 0.13 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
44
]
|
| 29 | 0.12 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
75
]
|
| 30 | 0.12 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
74
]
|
| 31 | 0.12 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
72
]
|
| 32 | 0.12 ms |
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
73
]
|
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 |
|
| App\Entity\VilleFrance | No errors. |
| App\Entity\SystemeClient |
|
| App\Entity\Camion |
|
| App\Entity\CamionUser | No errors. |
| App\Entity\Documentation | No errors. |
| App\Entity\CartePaiement | No errors. |
| App\Entity\Absence | No errors. |
| App\Entity\PlanningReccurence | No errors. |
| App\Entity\InfoChauffeur | No errors. |
| App\Entity\InfoChauffeurDate | No errors. |
| App\Entity\PlanningUpdateDateTime | No errors. |
| App\Entity\HoraireExploit | No errors. |
| App\Entity\Facture |
|
| App\Entity\Remorque |
|
| App\Entity\Divers | No errors. |
| App\Entity\Constructeur |
|
| App\Entity\Maintenance |
|
| App\Entity\PlanningRemorque | No errors. |
| App\Entity\PneuVehicule | No errors. |
| App\Entity\FactureDocument | No errors. |