GET https://complexehotelierlabonte.com/order/cart/add/PA0000055

Response
302 Found
IP
3.147.27.154
Profiled on
Token
c63ed7

Query Metrics

296 Database Queries
9 Different statements
45.85 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
18.60 ms
(40.58%) 		97 
SELECT t0.NumFacture AS NumFacture_1, t0.DateFacture AS DateFacture_2, t0.TotalHT AS TotalHT_3, t0.TotalTTC AS TotalTTC_4, t0.IDAdresseFacturation AS IDAdresseFacturation_5, t0.TotalTVA AS TotalTVA_6, t0.Acquittee AS Acquittee_7, t0.Remise AS Remise_8, t0.SaisiPar AS SaisiPar_9, t0.SaisiLe AS SaisiLe_10, t0.Observations AS Observations_11, t0.NumCommande AS NumCommande_12, t0.TotalFraisPort AS TotalFraisPort_13, t0.numOrdreFacture AS numOrdreFacture_14, t0.tauxRemise AS tauxRemise_15, t0.IDBordereau AS IDBordereau_16, t0.reffacture AS reffacture_17, t0.tauxAIB AS tauxAIB_18, t0.IDAdresseLivraison AS IDAdresseLivraison_19, t0.MontantAIB AS MontantAIB_20, t0.adresseLivraison AS adresseLivraison_21, t0.adresseFacturation AS adresseFacturation_22, t0.echeancierEtabli AS echeancierEtabli_23, t0.date AS date_24, t0.tvaEtat AS tvaEtat_25, t0.txtvaEtat AS txtvaEtat_26, t0.NumAgent AS NumAgent_27, t0.loginUtilisateur AS loginUtilisateur_28, t0.IDSOCIETE AS IDSOCIETE_29, t0.IDAnnee AS IDAnnee_30, t0.IDTYPEFACTURE AS IDTYPEFACTURE_31, t0.Compteur AS Compteur_32, t0.Compteur_tot AS Compteur_tot_33, t0.Signature AS Signature_34, t0.DateMCF AS DateMCF_35, t0.MCFNum AS MCFNum_36, t0.NetApayer AS NetApayer_37, t0.estPaye AS estPaye_38, t0.estCommander AS estCommander_39, t0.normalisee AS normalisee_40, t0.MontantPercu AS MontantPercu_41, t0.referenceTicket AS referenceTicket_42, t0.Annulee AS Annulee_43, t0.IDModeReglement AS IDModeReglement_44, t0.ModifierPar AS ModifierPar_45, t0.IDBANQUE AS IDBANQUE_46, t0.IDSource AS IDSource_47, t0.Code AS Code_48, t0.NomClient AS NomClient_49, t0.NumBordereau AS NumBordereau_50, t0.statut AS statut_51, t0.NumClient AS NumClient_52, t0.IDtable AS IDtable_53 FROM facture t0 WHERE t0.reffacture = ? LIMIT 1
Parameters: 
[
  "RFA00000001"
]
View formatted query    View runnable query    Explain query    View query backtrace
16.84 ms
(36.72%) 		97 
SELECT t0.Quantite AS Quantite_1, t0.tauxRemise AS tauxRemise_2, t0.IDLigneFac AS IDLigneFac_3, t0.TauxTVA AS TauxTVA_4, t0.Reference AS Reference_5, t0.PrixVente AS PrixVente_6, t0.NumFacture AS NumFacture_7, t0.IDLigneCde AS IDLigneCde_8, t0.LibProd AS LibProd_9, t0.OrdreAffichage AS OrdreAffichage_10, t0.montantLigneAIB AS montantLigneAIB_11, t0.tauxAIB AS tauxAIB_12, t0.montantLigne AS montantLigne_13, t0.MontantLigneTVA AS MontantLigneTVA_14, t0.IDSOCIETE AS IDSOCIETE_15, t0.IDAnnee AS IDAnnee_16, t0.AffTVA AS AffTVA_17, t0.montantRemise AS montantRemise_18, t0.ttcHorsRemise AS ttcHorsRemise_19, t0.ttcAvecRemise AS ttcAvecRemise_20, t0.htAvecRemise AS htAvecRemise_21, t0.ligneTTC AS ligneTTC_22, t0.ID AS ID_23, t0.Description AS Description_24, t0.PuHT AS PuHT_25, t0.date AS date_26, t0.Codefamille AS Codefamille_27, t0.depart AS depart_28, t0.destination AS destination_29, t0.motifvoyage AS motifvoyage_30, t0.nbEnfant AS nbEnfant_31, t0.allanta AS allanta_32, t0.Venantde AS Venantde_33, t0.IDPiece AS IDPiece_34, t0.numeropiece AS numeropiece_35, t0.DateEntree AS DateEntree_36, t0.DateSortie AS DateSortie_37, t0.nbrejoure AS nbrejoure_38, t0.caution AS caution_39, t0.IDservice AS IDservice_40, t0.estLivrer AS estLivrer_41, t0.designationprod AS designationprod_42, t0.assujjeti AS assujjeti_43, t0.IDtable AS IDtable_44, t0.Codeprix_applique AS Codeprix_applique_45, t0.reffacture AS reffacture_46 FROM LigneFac t0 WHERE t0.IDLigneFac = ? LIMIT 1
Parameters: 
[
  "LF00000001"
]
View formatted query    View runnable query    Explain query    View query backtrace
9.04 ms
(19.72%) 		96 
UPDATE facture SET IDAdresseLivraison = ?, NumAgent = ?, referenceTicket = ?, IDModeReglement = ?, IDBANQUE = ?, IDSource = ?, Code = ? WHERE reffacture = ?
Parameters: 
[
  0
  0
  0
  0
  0
  0
  0
  "RFA00000001"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.50 ms
(1.09%) 		1 
SELECT t0.codeprix_applique AS codeprix_applique_1, t0.codeservices AS codeservices_2, t0.prix AS prix_3, t0.stock AS stock_4, t0.qteVendu AS qteVendu_5, t0.qteapprovisionne AS qteapprovisionne_6, t0.qteretourne AS qteretourne_7, t0.ID AS ID_8, t0.codeservices AS codeservices_9 FROM Prix_A_Appliquer t0 WHERE t0.codeprix_applique = ? LIMIT 1
Parameters: 
[
  "PA0000055"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(0.57%) 		1 
INSERT INTO facture (NumFacture, DateFacture, TotalHT, TotalTTC, IDAdresseFacturation, TotalTVA, Acquittee, Remise, SaisiPar, SaisiLe, Observations, NumCommande, TotalFraisPort, numOrdreFacture, tauxRemise, IDBordereau, reffacture, tauxAIB, IDAdresseLivraison, MontantAIB, adresseLivraison, adresseFacturation, echeancierEtabli, date, tvaEtat, txtvaEtat, NumAgent, loginUtilisateur, IDSOCIETE, IDAnnee, IDTYPEFACTURE, Compteur, Compteur_tot, Signature, DateMCF, MCFNum, NetApayer, estPaye, estCommander, normalisee, MontantPercu, referenceTicket, Annulee, IDModeReglement, ModifierPar, IDBANQUE, IDSource, Code, NomClient, NumBordereau, statut, NumClient, IDtable) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  null
  "2024-12-23"
  null
  null
  null
  null
  0
  null
  null
  null
  null
  null
  "0.000000"
  null
  0
  null
  "RFA00000097"
  0.0
  0
  0
  null
  null
  0
  null
  0.0
  0
  0
  null
  null
  null
  null
  0
  0
  null
  null
  null
  0
  0
  1
  0
  0
  0
  0
  0
  null
  0
  0
  0
  null
  null
  "EN LIGNE"
  null
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(0.50%) 		1 
SELECT t0.photo AS photo_1, t0.PrixHT AS PrixHT_2, t0.QteReappro AS QteReappro_3, t0.QteMini AS QteMini_4, t0.TauxTVA AS TauxTVA_5, t0.GenCode AS GenCode_6, t0.CodeBarre AS CodeBarre_7, t0.SaisiPar AS SaisiPar_8, t0.SaisiLe AS SaisiLe_9, t0.Observations AS Observations_10, t0.AIB AS AIB_11, t0.stockActuel AS stockActuel_12, t0.ID AS ID_13, t0.proFamille AS proFamille_14, t0.LibProd AS LibProd_15, t0.Description AS Description_16, t0.assujettiTVA AS assujettiTVA_17, t0.assujettiAIB AS assujettiAIB_18, t0.IDSOCIETE AS IDSOCIETE_19, t0.IDAnnee AS IDAnnee_20, t0.referenceInexistante AS referenceInexistante_21, t0.codebare AS codebare_22, t0.QTEAPPRO AS QTEAPPRO_23, t0.QteVente AS QteVente_24, t0.QteRebus AS QteRebus_25, t0.LibFamille AS LibFamille_26, t0.LibProdV AS LibProdV_27, t0.PrixRevient AS PrixRevient_28, t0.Marge AS Marge_29, t0.NIM_Facture_Preuve AS NIM_Facture_Preuve_30, t0.Signature_Facure_Preuve AS Signature_Facure_Preuve_31, t0.PTVA_Marge AS PTVA_Marge_32, t0.PTVA_HT AS PTVA_HT_33, t0.estMatieresPremiere AS estMatieresPremiere_34, t0.estStockable AS estStockable_35, t0.estdisponible AS estdisponible_36, t0.Reference AS Reference_37, t0.feat AS feat_38, t0.CodeFamille AS CodeFamille_39 FROM produit t0 WHERE t0.ID = ?
Parameters: 
[
  "P0000029"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(0.44%) 		1 
INSERT INTO LigneFac (Quantite, tauxRemise, IDLigneFac, TauxTVA, Reference, PrixVente, NumFacture, IDLigneCde, LibProd, OrdreAffichage, montantLigneAIB, tauxAIB, montantLigne, MontantLigneTVA, IDSOCIETE, IDAnnee, AffTVA, montantRemise, ttcHorsRemise, ttcAvecRemise, htAvecRemise, ligneTTC, ID, Description, PuHT, date, Codefamille, depart, destination, motifvoyage, nbEnfant, allanta, Venantde, IDPiece, numeropiece, DateEntree, DateSortie, nbrejoure, caution, IDservice, estLivrer, designationprod, assujjeti, IDtable, Codeprix_applique, reffacture) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  1.0
  0.0
  "LF00000097"
  null
  null
  "600"
  null
  null
  "Croissant ordinaire"
  0
  0
  0.0
  0
  0
  null
  null
  0
  0
  0
  0
  0
  0.0
  null
  null
  600
  null
  null
  null
  null
  null
  0
  null
  null
  null
  null
  null
  null
  0
  0
  0
  0
  null
  0
  null
  "PA0000055"
  "RFA00000097"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.09 ms
(0.20%) 		1 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.08 ms
(0.18%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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\PrixAAppliquer No errors.
App\Entity\Produit No errors.
App\Entity\Services
  • The association App\Entity\Services#tables refers to the owning side field App\Entity\Table#codeservices which is not defined as association, but as field.
  • The association App\Entity\Services#tables refers to the owning side field App\Entity\Table#codeservices which does not exist.
App\Entity\LigneFac No errors.
App\Entity\Facture No errors.
App\Entity\Client No errors.
App\Entity\Table
  • The field 'App\Entity\Table#codeservices' has the property type 'App\Entity\Services' that differs from the metadata field type 'string' returned by the 'string' DBAL type.
App\Entity\Famille No errors.
App\Entity\ImagesProduits No errors.