Query Metrics
8
Database Queries
6
Different statements
3376.32 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 3.68 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM [user] t0 WHERE t0.id = ?
Parameters:
[
9
]
|
2 | 3313.78 ms |
SELECT t0.id AS id_1, t0.numagence AS numagence_2, t0.numcompteur AS numcompteur_3, t0.numcolis AS numcolis_4, t0.numconsolidation AS numconsolidation_5, t0.opsjob AS opsjob_6, t0.refexp1 AS refexp1_7, t0.refexp2 AS refexp2_8, t0.refexp3 AS refexp3_9, t0.dateexpedition AS dateexpedition_10, t0.poids AS poids_11, t0.nomdestinataire AS nomdestinataire_12, t0.ruedestinataire AS ruedestinataire_13, t0.villedestinataire AS villedestinataire_14, t0.codepostaldestinataire AS codepostaldestinataire_15, t0.codepaysdestinataire AS codepaysdestinataire_16, t0.statut AS statut_17, t0.datestatut AS datestatut_18, t0.heurestatut AS heurestatut_19, t0.nomrecup AS nomrecup_20, t0.urltrace AS urltrace_21, t0.urlpod AS urlpod_22, t0.daterecu AS daterecu_23, t0.numinter AS numinter_24, t0.extentionstatut AS extentionstatut_25, t0.anomalie AS anomalie_26, t0.affecte AS affecte_27, t0.daterdv AS daterdv_28, t0.newdaterdv AS newdaterdv_29, t0.retour AS retour_30, t0.dateheure AS dateheure_31, t0.commande_id AS commande_id_32, t0.opsjob AS opsjob_33, t0.statut AS statut_34 FROM unl t0 WHERE t0.refexp1 = ?
Parameters:
[
"temp_886366468"
]
|
3 | 5.20 ms |
"START TRANSACTION"
Parameters:
[] |
4 | 6.12 ms |
INSERT INTO ops (numjobpf, compteclient, numcommandepf, statutfinal_id, numlabo, medeledescription, numcommandeclient, codechorus, quantite, numariteck, numbliteck, creele, majle, batenvoile, groupe, codelivraison, ldm) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "temp_886366468" "916380" "5722130" null null "BOURHIS" "LDL758EE /73445" null "50" null null "2024-11-21 17:27:48.067117" "2024-11-21 17:27:48.067124" "2024-11-21" 0 null "CLD47472" ] |
5 | 18.30 ms |
"COMMIT"
Parameters:
[] |
6 | 4.52 ms |
"START TRANSACTION"
Parameters:
[] |
7 | 7.85 ms |
INSERT INTO trace (user_id, email, partie, type, commentaire, ops_id, commande_id, datemaj) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 9 "isabelle.dupont@ld-medical.fr" "OPS" "Nouveau" " Compte client -> 916380 | Numéro commende PF -> 5722130 | Modele description -> BOURHIS | Quantite -> 50 | Numéro job PF -> temp_886366468 |" "temp_886366468" null "2024-11-21 17:27:51.435388" ] |
8 | 16.86 ms |
"COMMIT"
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\Specification | No errors. |
App\Entity\Trace | No errors. |
App\Entity\Unl | No errors. |
App\Entity\Ops | No errors. |
App\Entity\Historique | No errors. |
App\Entity\Statutfinal | No errors. |
App\Entity\Commande | No errors. |
App\Entity\Statut | No errors. |
App\Entity\Documentpdffile | No errors. |
App\Entity\Document | No errors. |
App\Entity\Order | No errors. |
App\Entity\Usercolis | No errors. |
App\Entity\Adresselivraison | No errors. |