http://my-advalorem.fr/suivi/public/ops/commande Return to referer URL

Query Metrics

8 Database Queries
6 Different statements
3376.32 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.