POST https://lesvgpfaciles.com/Espace-Client/TraiteRapport

Query Metrics

23 Database Queries
17 Different statements
30.02 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 2.63 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:
[
  64
]
2 2.73 ms
SELECT t0.id AS id_1, t0.modele AS modele_2, t0.commentaire_modele AS commentaire_modele_3, t0.marque_id AS marque_id_4, t0.energie_id AS energie_id_5, t0.categorie_id AS categorie_id_6 FROM lesvgp_modele t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "145"
]
3 2.31 ms
SELECT t0.id AS id_1, t0.categorie AS categorie_2, t0.commentaire_categorie AS commentaire_categorie_3, t0.regle_id AS regle_id_4 FROM lesvgp_categorie t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "1"
]
4 2.25 ms
SELECT t0.id AS id_1, t0.societe AS societe_2, t0.adresse AS adresse_3, t0.code_postal AS code_postal_4, t0.ville AS ville_5, t0.email AS email_6, t0.telephone AS telephone_7, t0.user_id AS user_id_8 FROM lesvgp_clients t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "641"
]
5 2.73 ms
SELECT t0.id AS id_1, t0.clients_id AS clients_id_2, t0.modele_id AS modele_id_3, t0.categorie_id AS categorie_id_4, t0.user_id AS user_id_5 FROM lesvgp_matcli t0 WHERE t0.clients_id = ? AND t0.modele_id = ? AND t0.categorie_id = ? LIMIT 1
Parameters:
[
  641
  145
  1
]
6 0.38 ms
"START TRANSACTION"
Parameters:
[]
7 0.64 ms
INSERT INTO lesvgp_matcli (clients_id, modele_id, categorie_id, user_id) VALUES (?, ?, ?, ?)
Parameters:
[
  641
  145
  1
  64
]
8 1.36 ms
"COMMIT"
Parameters:
[]
9 1.84 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.donnees AS donnees_3, t0.duree AS duree_4, t0.levage AS levage_5, t0.questionnaire AS questionnaire_6, t0.commentaire_formulaire AS commentaire_formulaire_7, t0.categorie_id AS categorie_id_8, t0.regle_id AS regle_id_9 FROM lesvgp_formulaire t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "1"
]
10 2.18 ms
SELECT t0.id AS id_1, t0.rapport AS rapport_2, t0.relance AS relance_3, t0.donnees AS donnees_4, t0.tableau AS tableau_5, t0.procont AS procont_6, t0.avis AS avis_7, t0.synthese AS synthese_8, t0.resultat_essais AS resultat_essais_9, t0.resultat_etat AS resultat_etat_10, t0.resultat_lim AS resultat_lim_11, t0.numserie AS numserie_12, t0.dateverif AS dateverif_13, t0.controleur AS controleur_14, t0.defauts AS defauts_15, t0.nomimg AS nomimg_16, t0.textnomimg AS textnomimg_17, t0.suivi AS suivi_18, t0.decompte AS decompte_19, t0.relance_ok AS relance_ok_20, t0.matcli_id AS matcli_id_21, t0.formulaire_id AS formulaire_id_22, t0.user_id AS user_id_23 FROM lesvgp_vgp t0 WHERE t0.numserie = ? AND t0.matcli_id = ?
Parameters:
[
  "101150513891"
  3583
]
11 1.83 ms
SELECT t0.id AS id_1, t0.regle AS regle_2, t0.commentaire_regle AS commentaire_regle_3 FROM lesvgp_regle t0 WHERE t0.id = ?
Parameters:
[
  1
]
12 0.73 ms
SELECT t0.id AS id_1, t0.rapport AS rapport_2, t0.relance AS relance_3, t0.donnees AS donnees_4, t0.tableau AS tableau_5, t0.procont AS procont_6, t0.avis AS avis_7, t0.synthese AS synthese_8, t0.resultat_essais AS resultat_essais_9, t0.resultat_etat AS resultat_etat_10, t0.resultat_lim AS resultat_lim_11, t0.numserie AS numserie_12, t0.dateverif AS dateverif_13, t0.controleur AS controleur_14, t0.defauts AS defauts_15, t0.nomimg AS nomimg_16, t0.textnomimg AS textnomimg_17, t0.suivi AS suivi_18, t0.decompte AS decompte_19, t0.relance_ok AS relance_ok_20, t0.matcli_id AS matcli_id_21, t0.formulaire_id AS formulaire_id_22, t0.user_id AS user_id_23 FROM lesvgp_vgp t0 WHERE t0.rapport = ? LIMIT 1
Parameters:
[
  "2025042964-641100416-1-FTPA-R482"
]
13 0.26 ms
"START TRANSACTION"
Parameters:
[]
14 0.58 ms
INSERT INTO lesvgp_vgp (rapport, relance, donnees, tableau, procont, avis, synthese, resultat_essais, resultat_etat, resultat_lim, numserie, dateverif, controleur, defauts, nomimg, textnomimg, suivi, decompte, relance_ok, matcli_id, formulaire_id, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "2025042964-641100416-1-FTPA-R482"
  "2026-03-29 10:06:16"
  "{"commun":{"vgp":"1","lieu":"Andancette","accompagnant":"Patrick ","1":"2000","2":"Pas de compteur ","4":"oui","5":"2700","8":"oui","318":" "},"document":{"document":"non","Aucun":"on"}}"
  null
  "2026-04-29 10:06:16"
  null
  null
  null
  null
  null
  "101150513891"
  "2025-04-29 10:06:16"
  "GRANGER JEREMY"
  null
  null
  null
  null
  null
  null
  3583
  1
  64
]
15 1.35 ms
"COMMIT"
Parameters:
[]
16 1.66 ms
SELECT t0.id AS id_1, t0.vgp AS vgp_2, t0.abonnement AS abonnement_3, t0.created_at AS created_at_4, t0.relance AS relance_5, t0.validite AS validite_6, t0.user_id AS user_id_7 FROM lesvgp_compte_client t0 WHERE t0.user_id = ? LIMIT 1
Parameters:
[
  64
]
17 0.65 ms
SELECT t0.id AS id_1, t0.rapport AS rapport_2, t0.relance AS relance_3, t0.donnees AS donnees_4, t0.tableau AS tableau_5, t0.procont AS procont_6, t0.avis AS avis_7, t0.synthese AS synthese_8, t0.resultat_essais AS resultat_essais_9, t0.resultat_etat AS resultat_etat_10, t0.resultat_lim AS resultat_lim_11, t0.numserie AS numserie_12, t0.dateverif AS dateverif_13, t0.controleur AS controleur_14, t0.defauts AS defauts_15, t0.nomimg AS nomimg_16, t0.textnomimg AS textnomimg_17, t0.suivi AS suivi_18, t0.decompte AS decompte_19, t0.relance_ok AS relance_ok_20, t0.matcli_id AS matcli_id_21, t0.formulaire_id AS formulaire_id_22, t0.user_id AS user_id_23 FROM lesvgp_vgp t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  4642
]
18 0.24 ms
"START TRANSACTION"
Parameters:
[]
19 0.37 ms
UPDATE lesvgp_compte_client SET abonnement = ? WHERE id = ?
Parameters:
[
  92
  44
]
20 1.31 ms
"COMMIT"
Parameters:
[]
21 0.29 ms
"START TRANSACTION"
Parameters:
[]
22 0.37 ms
UPDATE lesvgp_vgp SET decompte = ? WHERE id = ?
Parameters:
[
  1
  4642
]
23 1.32 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\LesvgpMatcli No errors.
App\Entity\LesvgpCommandes No errors.
App\Entity\LesvgpQrcode No errors.
App\Entity\LesvgpVgp No errors.
App\Entity\LesvgpAnnuaire No errors.
App\Entity\LesvgpCompteClient No errors.
App\Entity\LesvgpOptions No errors.
App\Entity\LesvgpDonneesMembres No errors.
App\Entity\LesvgpAccesClients No errors.
App\Entity\LesvgpSupprimeUser No errors.
App\Entity\LesvgpClients No errors.
App\Entity\LesvgpModele
  • The association App\Entity\LesvgpModele#Categorie refers to the inverse side field App\Entity\LesvgpCategorie#lesvgpModeles which does not exist.
App\Entity\LesvgpMarque No errors.
App\Entity\LesvgpEnergie No errors.
App\Entity\LesvgpCategorie No errors.
App\Entity\LesvgpRegle No errors.
App\Entity\LesvgpFormulaire No errors.
App\Entity\LesvgpQuestionnaire No errors.
App\Entity\LesvgpQuestion No errors.
App\Entity\LesvgpProposition No errors.
App\Entity\LesvgpTarifs No errors.