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 = ?
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 = 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
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 = '145' LIMIT 1;
|
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
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 = '1' LIMIT 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
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 = '641' LIMIT 1;
|
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
]
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 = 641 AND t0.modele_id = 145 AND t0.categorie_id = 1 LIMIT 1;
|
6 |
0.38 ms |
"START TRANSACTION"
"START TRANSACTION";
|
7 |
0.64 ms |
INSERT INTO lesvgp_matcli (clients_id, modele_id, categorie_id, user_id) VALUES (?, ?, ?, ?)
Parameters: [
641
145
1
64
]
INSERT INTO lesvgp_matcli (clients_id, modele_id, categorie_id, user_id) VALUES (641, 145, 1, 64);
|
8 |
1.36 ms |
"COMMIT"
|
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
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 = '1' LIMIT 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
]
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 = '101150513891' AND t0.matcli_id = 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 = ?
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 = 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"
]
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 = '2025042964-641100416-1-FTPA-R482' LIMIT 1;
|
13 |
0.26 ms |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
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
(
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?
)
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 ('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"
|
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
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 = 64 LIMIT 1;
|
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
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 = 4642 LIMIT 1;
|
18 |
0.24 ms |
"START TRANSACTION"
"START TRANSACTION";
|
19 |
0.37 ms |
UPDATE lesvgp_compte_client SET abonnement = ? WHERE id = ?
UPDATE lesvgp_compte_client SET abonnement = 92 WHERE id = 44;
|
20 |
1.31 ms |
"COMMIT"
|
21 |
0.29 ms |
"START TRANSACTION"
"START TRANSACTION";
|
22 |
0.37 ms |
UPDATE lesvgp_vgp SET decompte = ? WHERE id = ?
UPDATE lesvgp_vgp SET decompte = 1 WHERE id = 4642;
|
23 |
1.32 ms |
"COMMIT"
|