Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

3.04 ms Query time

5 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
3.04 ms (100.00%)	1	SELECT t0.num_comande AS num_comande_1, t0.montantHt AS montantHt_2, t0.montanenv AS montanenv_3, t0.montantRth AS montantRth_4, t0.traiter AS traiter_5, t0.moantantTtcregl AS moantantTtcregl_6, t0.tva AS tva_7, t0.date_create_commande AS date_create_commande_8, t0.date_facture AS date_facture_9, t0.Jeton AS Jeton_10, t0.payement_type AS payement_type_11, t0.periode AS periode_12, t0.dupligetStatut AS dupligetStatut_13, t0.id AS id_14, t0.revesmentpart AS revesmentpart_15, t0.remisecodepromo AS remisecodepromo_16, t0.totalBlackFriday AS totalBlackFriday_17, t0.nbconnx AS nbconnx_18, t0.rev AS rev_19, t0.NumSuivi AS NumSuivi_20, t0.dateLivraison AS dateLivraison_21, t0.dateExpidition AS dateExpidition_22, t0.lettreSuivi AS lettreSuivi_23, t0.addresseLivraison AS addresseLivraison_24, t0.nbenfantencours AS nbenfantencours_25, t0.numfacture AS numfacture_26, t0.id_sejour AS id_sejour_27, t0.id_user AS id_user_28, t0.statut AS statut_29, t0.adresslivraison AS adresslivraison_30, t0.adressfactoration AS adressfactoration_31, t0.idPanier_id AS idPanier_id_32, t0.idPromotion_id AS idPromotion_id_33, t0.logPromo_id AS logPromo_id_34 FROM commande t0 WHERE t0.id IS NULL LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT t0.num_comande AS num_comande_1, t0.montantHt AS montantHt_2, t0.montanenv AS montanenv_3, t0.montantRth AS montantRth_4, t0.traiter AS traiter_5, t0.moantantTtcregl AS moantantTtcregl_6, t0.tva AS tva_7, t0.date_create_commande AS date_create_commande_8, t0.date_facture AS date_facture_9, t0.Jeton AS Jeton_10, t0.payement_type AS payement_type_11, t0.periode AS periode_12, t0.dupligetStatut AS dupligetStatut_13, t0.id AS id_14, t0.revesmentpart AS revesmentpart_15, t0.remisecodepromo AS remisecodepromo_16, t0.totalBlackFriday AS totalBlackFriday_17, t0.nbconnx AS nbconnx_18, t0.rev AS rev_19, t0.NumSuivi AS NumSuivi_20, t0.dateLivraison AS dateLivraison_21, t0.dateExpidition AS dateExpidition_22, t0.lettreSuivi AS lettreSuivi_23, t0.addresseLivraison AS addresseLivraison_24, t0.nbenfantencours AS nbenfantencours_25, t0.numfacture AS numfacture_26, t0.id_sejour AS id_sejour_27, t0.id_user AS id_user_28, t0.statut AS statut_29, t0.adresslivraison AS adresslivraison_30, t0.adressfactoration AS adressfactoration_31, t0.idPanier_id AS idPanier_id_32, t0.idPromotion_id AS idPromotion_id_33, t0.logPromo_id AS logPromo_id_34 FROM commande t0 WHERE t0.id IS NULL LIMIT 1 SELECT t0.num_comande AS num_comande_1, t0.montantHt AS montantHt_2, t0.montanenv AS montanenv_3, t0.montantRth AS montantRth_4, t0.traiter AS traiter_5, t0.moantantTtcregl AS moantantTtcregl_6, t0.tva AS tva_7, t0.date_create_commande AS date_create_commande_8, t0.date_facture AS date_facture_9, t0.Jeton AS Jeton_10, t0.payement_type AS payement_type_11, t0.periode AS periode_12, t0.dupligetStatut AS dupligetStatut_13, t0.id AS id_14, t0.revesmentpart AS revesmentpart_15, t0.remisecodepromo AS remisecodepromo_16, t0.totalBlackFriday AS totalBlackFriday_17, t0.nbconnx AS nbconnx_18, t0.rev AS rev_19, t0.NumSuivi AS NumSuivi_20, t0.dateLivraison AS dateLivraison_21, t0.dateExpidition AS dateExpidition_22, t0.lettreSuivi AS lettreSuivi_23, t0.addresseLivraison AS addresseLivraison_24, t0.nbenfantencours AS nbenfantencours_25, t0.numfacture AS numfacture_26, t0.id_sejour AS id_sejour_27, t0.id_user AS id_user_28, t0.statut AS statut_29, t0.adresslivraison AS adresslivraison_30, t0.adressfactoration AS adressfactoration_31, t0.idPanier_id AS idPanier_id_32, t0.idPromotion_id AS idPromotion_id_33, t0.logPromo_id AS logPromo_id_34 FROM commande t0 WHERE t0.id IS NULL LIMIT 1;

Time▼

Count

Info

3.04 ms
(100.00%)

SELECT t0.num_comande AS num_comande_1, t0.montantHt AS montantHt_2, t0.montanenv AS montanenv_3, t0.montantRth AS montantRth_4, t0.traiter AS traiter_5, t0.moantantTtcregl AS moantantTtcregl_6, t0.tva AS tva_7, t0.date_create_commande AS date_create_commande_8, t0.date_facture AS date_facture_9, t0.Jeton AS Jeton_10, t0.payement_type AS payement_type_11, t0.periode AS periode_12, t0.dupligetStatut AS dupligetStatut_13, t0.id AS id_14, t0.revesmentpart AS revesmentpart_15, t0.remisecodepromo AS remisecodepromo_16, t0.totalBlackFriday AS totalBlackFriday_17, t0.nbconnx AS nbconnx_18, t0.rev AS rev_19, t0.NumSuivi AS NumSuivi_20, t0.dateLivraison AS dateLivraison_21, t0.dateExpidition AS dateExpidition_22, t0.lettreSuivi AS lettreSuivi_23, t0.addresseLivraison AS addresseLivraison_24, t0.nbenfantencours AS nbenfantencours_25, t0.numfacture AS numfacture_26, t0.id_sejour AS id_sejour_27, t0.id_user AS id_user_28, t0.statut AS statut_29, t0.adresslivraison AS adresslivraison_30, t0.adressfactoration AS adressfactoration_31, t0.idPanier_id AS idPanier_id_32, t0.idPromotion_id AS idPromotion_id_33, t0.logPromo_id AS logPromo_id_34 FROM commande t0 WHERE t0.id IS NULL LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.num_comande AS num_comande_1,
  t0.montantHt AS montantHt_2,
  t0.montanenv AS montanenv_3,
  t0.montantRth AS montantRth_4,
  t0.traiter AS traiter_5,
  t0.moantantTtcregl AS moantantTtcregl_6,
  t0.tva AS tva_7,
  t0.date_create_commande AS date_create_commande_8,
  t0.date_facture AS date_facture_9,
  t0.Jeton AS Jeton_10,
  t0.payement_type AS payement_type_11,
  t0.periode AS periode_12,
  t0.dupligetStatut AS dupligetStatut_13,
  t0.id AS id_14,
  t0.revesmentpart AS revesmentpart_15,
  t0.remisecodepromo AS remisecodepromo_16,
  t0.totalBlackFriday AS totalBlackFriday_17,
  t0.nbconnx AS nbconnx_18,
  t0.rev AS rev_19,
  t0.NumSuivi AS NumSuivi_20,
  t0.dateLivraison AS dateLivraison_21,
  t0.dateExpidition AS dateExpidition_22,
  t0.lettreSuivi AS lettreSuivi_23,
  t0.addresseLivraison AS addresseLivraison_24,
  t0.nbenfantencours AS nbenfantencours_25,
  t0.numfacture AS numfacture_26,
  t0.id_sejour AS id_sejour_27,
  t0.id_user AS id_user_28,
  t0.statut AS statut_29,
  t0.adresslivraison AS adresslivraison_30,
  t0.adressfactoration AS adressfactoration_31,
  t0.idPanier_id AS idPanier_id_32,
  t0.idPromotion_id AS idPromotion_id_33,
  t0.logPromo_id AS logPromo_id_34
FROM
  commande t0
WHERE
  t0.id IS NULL
LIMIT
  1

SELECT t0.num_comande AS num_comande_1, t0.montantHt AS montantHt_2, t0.montanenv AS montanenv_3, t0.montantRth AS montantRth_4, t0.traiter AS traiter_5, t0.moantantTtcregl AS moantantTtcregl_6, t0.tva AS tva_7, t0.date_create_commande AS date_create_commande_8, t0.date_facture AS date_facture_9, t0.Jeton AS Jeton_10, t0.payement_type AS payement_type_11, t0.periode AS periode_12, t0.dupligetStatut AS dupligetStatut_13, t0.id AS id_14, t0.revesmentpart AS revesmentpart_15, t0.remisecodepromo AS remisecodepromo_16, t0.totalBlackFriday AS totalBlackFriday_17, t0.nbconnx AS nbconnx_18, t0.rev AS rev_19, t0.NumSuivi AS NumSuivi_20, t0.dateLivraison AS dateLivraison_21, t0.dateExpidition AS dateExpidition_22, t0.lettreSuivi AS lettreSuivi_23, t0.addresseLivraison AS addresseLivraison_24, t0.nbenfantencours AS nbenfantencours_25, t0.numfacture AS numfacture_26, t0.id_sejour AS id_sejour_27, t0.id_user AS id_user_28, t0.statut AS statut_29, t0.adresslivraison AS adresslivraison_30, t0.adressfactoration AS adressfactoration_31, t0.idPanier_id AS idPanier_id_32, t0.idPromotion_id AS idPromotion_id_33, t0.logPromo_id AS logPromo_id_34 FROM commande t0 WHERE t0.id IS NULL LIMIT 1;

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\Commande	The field App\Entity\Commande#commandesProduits is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ComandeProduit#idComande does not contain the required 'inversedBy="commandesProduits"' attribute.
App\Entity\Sejour	The field App\Entity\Sejour#produits is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Produit#idsjour does not contain the required 'inversedBy="produits"' attribute. The field App\Entity\Sejour#commandes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Commande#idSejour does not contain the required 'inversedBy="commandes"' attribute. The field App\Entity\Sejour#cartes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Cart#idsejour does not contain the required 'inversedBy="cartes"' attribute. The field App\Entity\Sejour#attachements is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SejourAttachment#idSejour does not contain the required 'inversedBy="attachements"' attribute. The field App\Entity\Sejour#jourdescripdate is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Jourdescripdate#idsejour does not contain the required 'inversedBy="jourdescripdate"' attribute. The field App\Entity\Sejour#parentSejour is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ParentSejour#idSejour does not contain the required 'inversedBy="parentSejour"' attribute.
App\Entity\User	The field App\Entity\User#mescommandes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Commande#idUser does not contain the required 'inversedBy="mescommandes"' attribute. The field App\Entity\User#etablismentuser is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Etablisment#user does not contain the required 'inversedBy="etablismentuser"' attribute. The field App\Entity\User#mesblogs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Blog#iduser does not contain the required 'inversedBy="mesblogs"' attribute. The field App\Entity\User#mesSejourAcc is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sejour#idAcommp does not contain the required 'inversedBy="mesSejourAcc"' attribute. The field App\Entity\User#mesSejourPart is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sejour#idPartenaire does not contain the required 'inversedBy="mesSejourPart"' attribute.
App\Entity\Ref	No errors.
App\Entity\Adress	No errors.
App\Entity\Panier	No errors.
App\Entity\Promotions	No errors.
App\Entity\LogPromotions	No errors.
App\Entity\ComandeProduit	No errors.
App\Entity\CommandeNumerique	No errors.
App\Entity\Etablisment	No errors.
App\Entity\Produit	No errors.
App\Entity\Cart	The field App\Entity\Cart#positions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Position#idcart does not contain the required 'inversedBy="positions"' attribute.
App\Entity\SejourAttachment	No errors.
App\Entity\Jourdescripdate	No errors.
App\Entity\ParentSejour	No errors.
App\Entity\PromoSejour	No errors.
App\Entity\Photonsumeriques	No errors.
App\Entity\Blog	The field App\Entity\Blog#mesattachments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\BlogAttachement#idblog does not contain the required 'inversedBy="mesattachments"' attribute.
App\Entity\Comptebancaire	No errors.
App\Entity\Etiquette	No errors.
App\Entity\CommentaireEtiquette	No errors.
App\Entity\Fonctions	No errors.
App\Entity\PromoParents	No errors.
App\Entity\Typeref	No errors.
App\Entity\PanierProduit	No errors.

Symfony Profiler

https://futur.5sur5sejour.fr/Payement/chargement_form_up2pay

Configuration Settings

Theme