Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

34 Database Queries

19 Different statements

165.59 ms Query time

6 Invalid entities

Queries

Group similar statements


SELECT t0.id AS id_1, t0.nbconnx AS nbconnx_2, t0.username AS username_3, t0.adresse AS adresse_4, t0.fonction AS fonction_5, t0.etablisment AS etablisment_6, t0.numMobile AS numMobile_7, t0.logourl AS logourl_8, t0.Datedepart AS Datedepart_9, t0.dateFlagDepot AS dateFlagDepot_10, t0.flagDepot AS flagDepot_11, t0.nom AS nom_12, t0.prenom AS prenom_13, t0.roles AS roles_14, t0.email AS email_15, t0.password AS password_16, t0.salt AS salt_17, t0.date_creation AS date_creation_18, t0.nometablisment AS nometablisment_19, t0.randomnotice AS randomnotice_20, t0.infocomple AS infocomple_21, t0.reponseemail AS reponseemail_22, t0.password_non_cripted AS password_non_cripted_23, t0.cnxparent AS cnxparent_24, t0.accompaplus AS accompaplus_25, t0.activatemail AS activatemail_26, t0.Jeton AS Jeton_27, t0.showpubprod AS showpubprod_28, t0.showdetailsalbum AS showdetailsalbum_29, t0.showdetailslivre AS showdetailslivre_30, t0.showdetailsphotos AS showdetailsphotos_31, t0.showdetailsretros AS showdetailsretros_32, t0.showdetailscal AS showdetailscal_33, t0.cnxpartenaire AS cnxpartenaire_34, t0.smsnotif AS smsnotif_35, t0.mailnotif AS mailnotif_36, t0.AccoPlusToPartenaire AS AccoPlusToPartenaire_37, t0.jetonAccoPlusSejourGratuit AS jetonAccoPlusSejourGratuit_38, t0.adresslivraison AS adresslivraison_39, t0.adressfactoration AS adressfactoration_40, t0.statut AS statut_41, t0.usersecondaire AS usersecondaire_42, t0.comptebanque AS comptebanque_43, t0.idFonction_id AS idFonction_id_44 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code_sejour AS code_sejour_2, t0.date_creation_code AS date_creation_code_3, t0.date_fin_code AS date_fin_code_4, t0.them_sejour AS them_sejour_5, t0.adresse_sejour AS adresse_sejour_6, t0.pays AS pays_7, t0.ville AS ville_8, t0.code_postal AS code_postal_9, t0.date_debut_sejour AS date_debut_sejour_10, t0.date_fin_sejour AS date_fin_sejour_11, t0.nb_photo_diposer AS nb_photo_diposer_12, t0.paym AS paym_13, t0.albumgratuie AS albumgratuie_14, t0.nb_message AS nb_message_15, t0.etat_acomp_Album AS etat_acomp_Album_16, t0.etat_adresse_carte AS etat_adresse_carte_17, t0.nbenfan AS nbenfan_18, t0.nbenfantencours AS nbenfantencours_19, t0.cd AS cd_20, t0.prixcnxparent AS prixcnxparent_21, t0.prixcnxpartenaire AS prixcnxpartenaire_22, t0.reversecnxpart AS reversecnxpart_23, t0.reverseventepart AS reverseventepart_24, t0.Referenc AS Referenc_25, t0.cp AS cp_26, t0.id_etablisment AS id_etablisment_27, t0.Id_acommp AS Id_acommp_28, t0.id_partenaire AS id_partenaire_29, t0.statut AS statut_30, t0.age_group AS age_group_31 FROM sejour t0 WHERE t0.code_sejour = ? LIMIT 1
SELECT t0.id AS id_1, t0.code_sejour AS code_sejour_2, t0.date_creation_code AS date_creation_code_3, t0.date_fin_code AS date_fin_code_4, t0.them_sejour AS them_sejour_5, t0.adresse_sejour AS adresse_sejour_6, t0.pays AS pays_7, t0.ville AS ville_8, t0.code_postal AS code_postal_9, t0.date_debut_sejour AS date_debut_sejour_10, t0.date_fin_sejour AS date_fin_sejour_11, t0.nb_photo_diposer AS nb_photo_diposer_12, t0.paym AS paym_13, t0.albumgratuie AS albumgratuie_14, t0.nb_message AS nb_message_15, t0.etat_acomp_Album AS etat_acomp_Album_16, t0.etat_adresse_carte AS etat_adresse_carte_17, t0.nbenfan AS nbenfan_18, t0.nbenfantencours AS nbenfantencours_19, t0.cd AS cd_20, t0.prixcnxparent AS prixcnxparent_21, t0.prixcnxpartenaire AS prixcnxpartenaire_22, t0.reversecnxpart AS reversecnxpart_23, t0.reverseventepart AS reverseventepart_24, t0.Referenc AS Referenc_25, t0.cp AS cp_26, t0.id_etablisment AS id_etablisment_27, t0.Id_acommp AS Id_acommp_28, t0.id_partenaire AS id_partenaire_29, t0.statut AS statut_30, t0.age_group AS age_group_31 FROM sejour t0 WHERE t0.code_sejour = ? LIMIT 1
SELECT l0_.date AS date_0, l0_.etat AS etat_1, l0_.id AS id_2, l0_.id_sejour AS id_sejour_3, l0_.id_sejour_attchment AS id_sejour_attchment_4, l0_.id_produit AS id_produit_5, l0_.id_user AS id_user_6 FROM likephoto l0_ WHERE l0_.id_user = ? AND l0_.id_sejour = ?
SELECT t0.id AS id_1, t0.code_sejour AS code_sejour_2, t0.date_creation_code AS date_creation_code_3, t0.date_fin_code AS date_fin_code_4, t0.them_sejour AS them_sejour_5, t0.adresse_sejour AS adresse_sejour_6, t0.pays AS pays_7, t0.ville AS ville_8, t0.code_postal AS code_postal_9, t0.date_debut_sejour AS date_debut_sejour_10, t0.date_fin_sejour AS date_fin_sejour_11, t0.nb_photo_diposer AS nb_photo_diposer_12, t0.paym AS paym_13, t0.albumgratuie AS albumgratuie_14, t0.nb_message AS nb_message_15, t0.etat_acomp_Album AS etat_acomp_Album_16, t0.etat_adresse_carte AS etat_adresse_carte_17, t0.nbenfan AS nbenfan_18, t0.nbenfantencours AS nbenfantencours_19, t0.cd AS cd_20, t0.prixcnxparent AS prixcnxparent_21, t0.prixcnxpartenaire AS prixcnxpartenaire_22, t0.reversecnxpart AS reversecnxpart_23, t0.reverseventepart AS reverseventepart_24, t0.Referenc AS Referenc_25, t0.cp AS cp_26, t0.id_etablisment AS id_etablisment_27, t0.Id_acommp AS Id_acommp_28, t0.id_partenaire AS id_partenaire_29, t0.statut AS statut_30, t0.age_group AS age_group_31 FROM sejour t0 WHERE t0.id = ? LIMIT 1
SELECT s0_.id AS id_0, s0_.date_depot_attachement AS date_depot_attachement_1, s0_.etat AS etat_2, s0_.nbconsomateurattch AS nbconsomateurattch_3, s0_.nbpartenaireattch AS nbpartenaireattch_4, s0_.nbecoleattch AS nbecoleattch_5, s0_.statut AS statut_6, a1_.id AS id_7, a1_.path AS path_8, a1_.date AS date_9, a1_.idblog AS idblog_10, a1_.descreption AS descreption_11, r2_.id AS id_12, r2_.libiller AS libiller_13, r2_.code AS code_14, s0_.id_attchment AS id_attchment_15, s0_.id_sejour AS id_sejour_16, s0_.idParent_id AS idParent_id_17, a1_.idposition AS idposition_18, a1_.idref AS idref_19, a1_.iduser AS iduser_20, r2_.typeref AS typeref_21 FROM sejour_attachment s0_ INNER JOIN attachment a1_ ON s0_.id_attchment = a1_.id INNER JOIN ref r2_ ON a1_.idref = r2_.id WHERE s0_.id_sejour = ? AND r2_.libiller IN (?)
SELECT s0_.id AS id_0, s0_.date_depot_attachement AS date_depot_attachement_1, s0_.etat AS etat_2, s0_.nbconsomateurattch AS nbconsomateurattch_3, s0_.nbpartenaireattch AS nbpartenaireattch_4, s0_.nbecoleattch AS nbecoleattch_5, s0_.statut AS statut_6, a1_.id AS id_7, a1_.path AS path_8, a1_.date AS date_9, a1_.idblog AS idblog_10, a1_.descreption AS descreption_11, r2_.id AS id_12, r2_.libiller AS libiller_13, r2_.code AS code_14, s0_.id_attchment AS id_attchment_15, s0_.id_sejour AS id_sejour_16, s0_.idParent_id AS idParent_id_17, a1_.idposition AS idposition_18, a1_.idref AS idref_19, a1_.iduser AS iduser_20, r2_.typeref AS typeref_21 FROM sejour_attachment s0_ INNER JOIN attachment a1_ ON s0_.id_attchment = a1_.id INNER JOIN ref r2_ ON a1_.idref = r2_.id WHERE s0_.id_sejour = ? AND s0_.statut = ? AND r2_.libiller IN (?, ?)
SELECT l0_.date AS date_0, l0_.etat AS etat_1, l0_.id AS id_2, l0_.id_sejour AS id_sejour_3, l0_.id_sejour_attchment AS id_sejour_attchment_4, l0_.id_produit AS id_produit_5, l0_.id_user AS id_user_6 FROM likephoto l0_ WHERE l0_.id_user = ? AND l0_.id_sejour = ?
SELECT s0_.id AS id_0, s0_.date_depot_attachement AS date_depot_attachement_1, s0_.etat AS etat_2, s0_.nbconsomateurattch AS nbconsomateurattch_3, s0_.nbpartenaireattch AS nbpartenaireattch_4, s0_.nbecoleattch AS nbecoleattch_5, s0_.statut AS statut_6, a1_.id AS id_7, a1_.path AS path_8, a1_.date AS date_9, a1_.idblog AS idblog_10, a1_.descreption AS descreption_11, r2_.id AS id_12, r2_.libiller AS libiller_13, r2_.code AS code_14, s0_.id_attchment AS id_attchment_15, s0_.id_sejour AS id_sejour_16, s0_.idParent_id AS idParent_id_17, a1_.idposition AS idposition_18, a1_.idref AS idref_19, a1_.iduser AS iduser_20, r2_.typeref AS typeref_21 FROM sejour_attachment s0_ INNER JOIN attachment a1_ ON s0_.id_attchment = a1_.id INNER JOIN ref r2_ ON a1_.idref = r2_.id WHERE s0_.id_sejour = ? AND r2_.libiller IN (?)
SELECT *
        FROM position AS p, cart AS c, sejour AS s
        WHERE p.idcart = c.id
        AND c.idsejour= s.id
        AND s.id = 17771
SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = ? AND t0.iduser = ? AND t0.statut = ? ORDER BY t0.id DESC LIMIT 1
SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.iduser = ? AND t0.statut = ? AND t0.idsjour = ? LIMIT 1
SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = ? AND t0.iduser = ? AND t0.statut = ? ORDER BY t0.id DESC LIMIT 1
SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = ? AND t0.iduser = ? AND t0.statut = ? ORDER BY t0.id DESC LIMIT 1
SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.iduser = ? AND t0.statut = ? AND t0.idsjour = ? LIMIT 1
SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.statut = ? AND t0.idsjour = ? AND t0.labele = ? AND t0.version = ? LIMIT 1
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.date_modification AS date_modification_3, t0.payment AS payment_4, t0.smsnotif AS smsnotif_5, t0.mailnotif AS mailnotif_6, t0.traiter AS traiter_7, t0.rev AS rev_8, t0.fact AS fact_9, t0.flagPrix AS flagPrix_10, t0.id_parent AS id_parent_11, t0.Id_sejour AS Id_sejour_12 FROM parent_sejour t0 WHERE t0.id_parent = ? AND t0.Id_sejour = ? LIMIT 1
SELECT t0_.id AS id_0, t0_.montantHT AS montantHT_1, t0_.montantTTC AS montantTTC_2, t0_.TVA AS TVA_3, t0_.poidsContenant AS poidsContenant_4, t0_.poidsProduit AS poidsProduit_5, t0_.poidsTotal AS poidsTotal_6, t0_.pochetteEnvoi AS pochetteEnvoi_7, t0_.descriptionCommande AS descriptionCommande_8, t0_.type AS type_9, t0_.sousTitre AS sousTitre_10, t0_.orderprod AS orderprod_11, t0_.idTypeProduit_id AS idTypeProduit_id_12 FROM typeproduitconditionnement t0_ INNER JOIN typeproduit t1_ ON t0_.idTypeProduit_id = t1_.id WHERE t1_.statut = ? ORDER BY t0_.orderprod ASC
SELECT t0.id AS id_1, t0.labeleType AS labeleType_2, t0.caracteristiques AS caracteristiques_3, t0.delais AS delais_4, t0.tarifs AS tarifs_5, t0.traif AS traif_6, t0.fraisDePort AS fraisDePort_7, t0.date AS date_8, t0.description AS description_9, t0.plusDescription AS plusDescription_10, t0.MontantHt AS MontantHt_11, t0.MontantTTC AS MontantTTC_12, t0.PoindsEnGrContenant AS PoindsEnGrContenant_13, t0.PoidsEnGrProduit AS PoidsEnGrProduit_14, t0.PoidsTotalEnGrHorsPochette AS PoidsTotalEnGrHorsPochette_15, t0.PochetteEnvoi AS PochetteEnvoi_16, t0.statut AS statut_17, t0.reversement AS reversement_18, t0.iduser AS iduser_19 FROM typeproduit t0 WHERE t0.statut = ?
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_sejour = ? AND t0.id_user = ?
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.date_modification AS date_modification_3, t0.payment AS payment_4, t0.smsnotif AS smsnotif_5, t0.mailnotif AS mailnotif_6, t0.traiter AS traiter_7, t0.rev AS rev_8, t0.fact AS fact_9, t0.flagPrix AS flagPrix_10, t0.id_parent AS id_parent_11, t0.Id_sejour AS Id_sejour_12 FROM parent_sejour t0 WHERE t0.Id_sejour = ? AND t0.id_parent = ? LIMIT 1
SELECT *
        FROM attachment AS A, sejour_attachment AS sa, sejour AS s, ref As r
        WHERE A.id = sa.id_attchment
        AND A.idref= r.id
        AND r.libiller like ?
        AND sa.id_sejour= s.id
        AND s.id = 17771
SELECT l0_.date AS date_0, l0_.etat AS etat_1, l0_.id AS id_2, l0_.id_sejour AS id_sejour_3, l0_.id_sejour_attchment AS id_sejour_attchment_4, l0_.id_produit AS id_produit_5, l0_.id_user AS id_user_6 FROM likephoto l0_ WHERE l0_.id_user = ? AND l0_.id_sejour = ?
SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = ? AND t0.iduser = ? AND t0.statut = ? LIMIT 1
SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = ? AND t0.iduser = ? AND t0.statut = ? LIMIT 1
SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.iduser = ? AND t0.statut = ? AND t0.idsjour = ? LIMIT 1
SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.statut = ? AND t0.idsjour = ? AND t0.labele = ? AND t0.version = ? LIMIT 1
SELECT t0.id AS id_1, t0.nbconnx AS nbconnx_2, t0.username AS username_3, t0.adresse AS adresse_4, t0.fonction AS fonction_5, t0.etablisment AS etablisment_6, t0.numMobile AS numMobile_7, t0.logourl AS logourl_8, t0.Datedepart AS Datedepart_9, t0.dateFlagDepot AS dateFlagDepot_10, t0.flagDepot AS flagDepot_11, t0.nom AS nom_12, t0.prenom AS prenom_13, t0.roles AS roles_14, t0.email AS email_15, t0.password AS password_16, t0.salt AS salt_17, t0.date_creation AS date_creation_18, t0.nometablisment AS nometablisment_19, t0.randomnotice AS randomnotice_20, t0.infocomple AS infocomple_21, t0.reponseemail AS reponseemail_22, t0.password_non_cripted AS password_non_cripted_23, t0.cnxparent AS cnxparent_24, t0.accompaplus AS accompaplus_25, t0.activatemail AS activatemail_26, t0.Jeton AS Jeton_27, t0.showpubprod AS showpubprod_28, t0.showdetailsalbum AS showdetailsalbum_29, t0.showdetailslivre AS showdetailslivre_30, t0.showdetailsphotos AS showdetailsphotos_31, t0.showdetailsretros AS showdetailsretros_32, t0.showdetailscal AS showdetailscal_33, t0.cnxpartenaire AS cnxpartenaire_34, t0.smsnotif AS smsnotif_35, t0.mailnotif AS mailnotif_36, t0.AccoPlusToPartenaire AS AccoPlusToPartenaire_37, t0.jetonAccoPlusSejourGratuit AS jetonAccoPlusSejourGratuit_38, t0.adresslivraison AS adresslivraison_39, t0.adressfactoration AS adressfactoration_40, t0.statut AS statut_41, t0.usersecondaire AS usersecondaire_42, t0.comptebanque AS comptebanque_43, t0.idFonction_id AS idFonction_id_44 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.description AS description_2, t0.datejourphoto AS datejourphoto_3, t0.idsejour AS idsejour_4 FROM jourdescripdate t0 WHERE t0.idsejour = ?
SELECT t0.id AS id_1, t0.labeleType AS labeleType_2, t0.caracteristiques AS caracteristiques_3, t0.delais AS delais_4, t0.tarifs AS tarifs_5, t0.traif AS traif_6, t0.fraisDePort AS fraisDePort_7, t0.date AS date_8, t0.description AS description_9, t0.plusDescription AS plusDescription_10, t0.MontantHt AS MontantHt_11, t0.MontantTTC AS MontantTTC_12, t0.PoindsEnGrContenant AS PoindsEnGrContenant_13, t0.PoidsEnGrProduit AS PoidsEnGrProduit_14, t0.PoidsTotalEnGrHorsPochette AS PoidsTotalEnGrHorsPochette_15, t0.PochetteEnvoi AS PochetteEnvoi_16, t0.statut AS statut_17, t0.reversement AS reversement_18, t0.iduser AS iduser_19 FROM typeproduit t0 WHERE t0.statut = ?
SELECT l0_.date AS date_0, l0_.etat AS etat_1, l0_.id AS id_2, l0_.id_sejour AS id_sejour_3, l0_.id_sejour_attchment AS id_sejour_attchment_4, l0_.id_produit AS id_produit_5, l0_.id_user AS id_user_6 FROM likephoto l0_ WHERE l0_.id_user = ? AND l0_.id_sejour = ?
SELECT *
        FROM attachment AS A, sejour_attachment AS sa, sejour AS s, ref As r
        WHERE A.id = sa.id_attchment
        AND A.idref= r.id
        AND r.libiller like ? 
        AND sa.id_sejour= s.id
        AND sa.statut like ? 
        AND s.id = 17771
SELECT *
        FROM attachment AS A, sejour_attachment AS sa, sejour AS s, ref As r
        WHERE A.id = sa.id_attchment
        AND A.idref= r.id
        AND r.libiller like ?
        AND sa.id_sejour= s.id
        AND s.id = 17771
SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = ? AND t0.iduser = ? AND t0.statut = ? ORDER BY t0.id DESC LIMIT 1

#▲	Time	Info
1	2.94 ms	SELECT t0.id AS id_1, t0.nbconnx AS nbconnx_2, t0.username AS username_3, t0.adresse AS adresse_4, t0.fonction AS fonction_5, t0.etablisment AS etablisment_6, t0.numMobile AS numMobile_7, t0.logourl AS logourl_8, t0.Datedepart AS Datedepart_9, t0.dateFlagDepot AS dateFlagDepot_10, t0.flagDepot AS flagDepot_11, t0.nom AS nom_12, t0.prenom AS prenom_13, t0.roles AS roles_14, t0.email AS email_15, t0.password AS password_16, t0.salt AS salt_17, t0.date_creation AS date_creation_18, t0.nometablisment AS nometablisment_19, t0.randomnotice AS randomnotice_20, t0.infocomple AS infocomple_21, t0.reponseemail AS reponseemail_22, t0.password_non_cripted AS password_non_cripted_23, t0.cnxparent AS cnxparent_24, t0.accompaplus AS accompaplus_25, t0.activatemail AS activatemail_26, t0.Jeton AS Jeton_27, t0.showpubprod AS showpubprod_28, t0.showdetailsalbum AS showdetailsalbum_29, t0.showdetailslivre AS showdetailslivre_30, t0.showdetailsphotos AS showdetailsphotos_31, t0.showdetailsretros AS showdetailsretros_32, t0.showdetailscal AS showdetailscal_33, t0.cnxpartenaire AS cnxpartenaire_34, t0.smsnotif AS smsnotif_35, t0.mailnotif AS mailnotif_36, t0.AccoPlusToPartenaire AS AccoPlusToPartenaire_37, t0.jetonAccoPlusSejourGratuit AS jetonAccoPlusSejourGratuit_38, t0.adresslivraison AS adresslivraison_39, t0.adressfactoration AS adressfactoration_40, t0.statut AS statut_41, t0.usersecondaire AS usersecondaire_42, t0.comptebanque AS comptebanque_43, t0.idFonction_id AS idFonction_id_44 FROM user t0 WHERE t0.id = ? Parameters: [`63581`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nbconnx AS nbconnx_2, t0.username AS username_3, t0.adresse AS adresse_4, t0.fonction AS fonction_5, t0.etablisment AS etablisment_6, t0.numMobile AS numMobile_7, t0.logourl AS logourl_8, t0.Datedepart AS Datedepart_9, t0.dateFlagDepot AS dateFlagDepot_10, t0.flagDepot AS flagDepot_11, t0.nom AS nom_12, t0.prenom AS prenom_13, t0.roles AS roles_14, t0.email AS email_15, t0.password AS password_16, t0.salt AS salt_17, t0.date_creation AS date_creation_18, t0.nometablisment AS nometablisment_19, t0.randomnotice AS randomnotice_20, t0.infocomple AS infocomple_21, t0.reponseemail AS reponseemail_22, t0.password_non_cripted AS password_non_cripted_23, t0.cnxparent AS cnxparent_24, t0.accompaplus AS accompaplus_25, t0.activatemail AS activatemail_26, t0.Jeton AS Jeton_27, t0.showpubprod AS showpubprod_28, t0.showdetailsalbum AS showdetailsalbum_29, t0.showdetailslivre AS showdetailslivre_30, t0.showdetailsphotos AS showdetailsphotos_31, t0.showdetailsretros AS showdetailsretros_32, t0.showdetailscal AS showdetailscal_33, t0.cnxpartenaire AS cnxpartenaire_34, t0.smsnotif AS smsnotif_35, t0.mailnotif AS mailnotif_36, t0.AccoPlusToPartenaire AS AccoPlusToPartenaire_37, t0.jetonAccoPlusSejourGratuit AS jetonAccoPlusSejourGratuit_38, t0.adresslivraison AS adresslivraison_39, t0.adressfactoration AS adressfactoration_40, t0.statut AS statut_41, t0.usersecondaire AS usersecondaire_42, t0.comptebanque AS comptebanque_43, t0.idFonction_id AS idFonction_id_44 FROM user t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.nbconnx AS nbconnx_2, t0.username AS username_3, t0.adresse AS adresse_4, t0.fonction AS fonction_5, t0.etablisment AS etablisment_6, t0.numMobile AS numMobile_7, t0.logourl AS logourl_8, t0.Datedepart AS Datedepart_9, t0.dateFlagDepot AS dateFlagDepot_10, t0.flagDepot AS flagDepot_11, t0.nom AS nom_12, t0.prenom AS prenom_13, t0.roles AS roles_14, t0.email AS email_15, t0.password AS password_16, t0.salt AS salt_17, t0.date_creation AS date_creation_18, t0.nometablisment AS nometablisment_19, t0.randomnotice AS randomnotice_20, t0.infocomple AS infocomple_21, t0.reponseemail AS reponseemail_22, t0.password_non_cripted AS password_non_cripted_23, t0.cnxparent AS cnxparent_24, t0.accompaplus AS accompaplus_25, t0.activatemail AS activatemail_26, t0.Jeton AS Jeton_27, t0.showpubprod AS showpubprod_28, t0.showdetailsalbum AS showdetailsalbum_29, t0.showdetailslivre AS showdetailslivre_30, t0.showdetailsphotos AS showdetailsphotos_31, t0.showdetailsretros AS showdetailsretros_32, t0.showdetailscal AS showdetailscal_33, t0.cnxpartenaire AS cnxpartenaire_34, t0.smsnotif AS smsnotif_35, t0.mailnotif AS mailnotif_36, t0.AccoPlusToPartenaire AS AccoPlusToPartenaire_37, t0.jetonAccoPlusSejourGratuit AS jetonAccoPlusSejourGratuit_38, t0.adresslivraison AS adresslivraison_39, t0.adressfactoration AS adressfactoration_40, t0.statut AS statut_41, t0.usersecondaire AS usersecondaire_42, t0.comptebanque AS comptebanque_43, t0.idFonction_id AS idFonction_id_44 FROM user t0 WHERE t0.id = 63581;
2	43.61 ms	SELECT t0.id AS id_1, t0.code_sejour AS code_sejour_2, t0.date_creation_code AS date_creation_code_3, t0.date_fin_code AS date_fin_code_4, t0.them_sejour AS them_sejour_5, t0.adresse_sejour AS adresse_sejour_6, t0.pays AS pays_7, t0.ville AS ville_8, t0.code_postal AS code_postal_9, t0.date_debut_sejour AS date_debut_sejour_10, t0.date_fin_sejour AS date_fin_sejour_11, t0.nb_photo_diposer AS nb_photo_diposer_12, t0.paym AS paym_13, t0.albumgratuie AS albumgratuie_14, t0.nb_message AS nb_message_15, t0.etat_acomp_Album AS etat_acomp_Album_16, t0.etat_adresse_carte AS etat_adresse_carte_17, t0.nbenfan AS nbenfan_18, t0.nbenfantencours AS nbenfantencours_19, t0.cd AS cd_20, t0.prixcnxparent AS prixcnxparent_21, t0.prixcnxpartenaire AS prixcnxpartenaire_22, t0.reversecnxpart AS reversecnxpart_23, t0.reverseventepart AS reverseventepart_24, t0.Referenc AS Referenc_25, t0.cp AS cp_26, t0.id_etablisment AS id_etablisment_27, t0.Id_acommp AS Id_acommp_28, t0.id_partenaire AS id_partenaire_29, t0.statut AS statut_30, t0.age_group AS age_group_31 FROM sejour t0 WHERE t0.code_sejour = ? LIMIT 1 Parameters: [`"EF865747"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code_sejour AS code_sejour_2, t0.date_creation_code AS date_creation_code_3, t0.date_fin_code AS date_fin_code_4, t0.them_sejour AS them_sejour_5, t0.adresse_sejour AS adresse_sejour_6, t0.pays AS pays_7, t0.ville AS ville_8, t0.code_postal AS code_postal_9, t0.date_debut_sejour AS date_debut_sejour_10, t0.date_fin_sejour AS date_fin_sejour_11, t0.nb_photo_diposer AS nb_photo_diposer_12, t0.paym AS paym_13, t0.albumgratuie AS albumgratuie_14, t0.nb_message AS nb_message_15, t0.etat_acomp_Album AS etat_acomp_Album_16, t0.etat_adresse_carte AS etat_adresse_carte_17, t0.nbenfan AS nbenfan_18, t0.nbenfantencours AS nbenfantencours_19, t0.cd AS cd_20, t0.prixcnxparent AS prixcnxparent_21, t0.prixcnxpartenaire AS prixcnxpartenaire_22, t0.reversecnxpart AS reversecnxpart_23, t0.reverseventepart AS reverseventepart_24, t0.Referenc AS Referenc_25, t0.cp AS cp_26, t0.id_etablisment AS id_etablisment_27, t0.Id_acommp AS Id_acommp_28, t0.id_partenaire AS id_partenaire_29, t0.statut AS statut_30, t0.age_group AS age_group_31 FROM sejour t0 WHERE t0.code_sejour = ? LIMIT 1 SELECT t0.id AS id_1, t0.code_sejour AS code_sejour_2, t0.date_creation_code AS date_creation_code_3, t0.date_fin_code AS date_fin_code_4, t0.them_sejour AS them_sejour_5, t0.adresse_sejour AS adresse_sejour_6, t0.pays AS pays_7, t0.ville AS ville_8, t0.code_postal AS code_postal_9, t0.date_debut_sejour AS date_debut_sejour_10, t0.date_fin_sejour AS date_fin_sejour_11, t0.nb_photo_diposer AS nb_photo_diposer_12, t0.paym AS paym_13, t0.albumgratuie AS albumgratuie_14, t0.nb_message AS nb_message_15, t0.etat_acomp_Album AS etat_acomp_Album_16, t0.etat_adresse_carte AS etat_adresse_carte_17, t0.nbenfan AS nbenfan_18, t0.nbenfantencours AS nbenfantencours_19, t0.cd AS cd_20, t0.prixcnxparent AS prixcnxparent_21, t0.prixcnxpartenaire AS prixcnxpartenaire_22, t0.reversecnxpart AS reversecnxpart_23, t0.reverseventepart AS reverseventepart_24, t0.Referenc AS Referenc_25, t0.cp AS cp_26, t0.id_etablisment AS id_etablisment_27, t0.Id_acommp AS Id_acommp_28, t0.id_partenaire AS id_partenaire_29, t0.statut AS statut_30, t0.age_group AS age_group_31 FROM sejour t0 WHERE t0.code_sejour = 'EF865747' LIMIT 1;
3	27.27 ms	SELECT t0.id AS id_1, t0.code_sejour AS code_sejour_2, t0.date_creation_code AS date_creation_code_3, t0.date_fin_code AS date_fin_code_4, t0.them_sejour AS them_sejour_5, t0.adresse_sejour AS adresse_sejour_6, t0.pays AS pays_7, t0.ville AS ville_8, t0.code_postal AS code_postal_9, t0.date_debut_sejour AS date_debut_sejour_10, t0.date_fin_sejour AS date_fin_sejour_11, t0.nb_photo_diposer AS nb_photo_diposer_12, t0.paym AS paym_13, t0.albumgratuie AS albumgratuie_14, t0.nb_message AS nb_message_15, t0.etat_acomp_Album AS etat_acomp_Album_16, t0.etat_adresse_carte AS etat_adresse_carte_17, t0.nbenfan AS nbenfan_18, t0.nbenfantencours AS nbenfantencours_19, t0.cd AS cd_20, t0.prixcnxparent AS prixcnxparent_21, t0.prixcnxpartenaire AS prixcnxpartenaire_22, t0.reversecnxpart AS reversecnxpart_23, t0.reverseventepart AS reverseventepart_24, t0.Referenc AS Referenc_25, t0.cp AS cp_26, t0.id_etablisment AS id_etablisment_27, t0.Id_acommp AS Id_acommp_28, t0.id_partenaire AS id_partenaire_29, t0.statut AS statut_30, t0.age_group AS age_group_31 FROM sejour t0 WHERE t0.code_sejour = ? LIMIT 1 Parameters: [`"EF865747"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code_sejour AS code_sejour_2, t0.date_creation_code AS date_creation_code_3, t0.date_fin_code AS date_fin_code_4, t0.them_sejour AS them_sejour_5, t0.adresse_sejour AS adresse_sejour_6, t0.pays AS pays_7, t0.ville AS ville_8, t0.code_postal AS code_postal_9, t0.date_debut_sejour AS date_debut_sejour_10, t0.date_fin_sejour AS date_fin_sejour_11, t0.nb_photo_diposer AS nb_photo_diposer_12, t0.paym AS paym_13, t0.albumgratuie AS albumgratuie_14, t0.nb_message AS nb_message_15, t0.etat_acomp_Album AS etat_acomp_Album_16, t0.etat_adresse_carte AS etat_adresse_carte_17, t0.nbenfan AS nbenfan_18, t0.nbenfantencours AS nbenfantencours_19, t0.cd AS cd_20, t0.prixcnxparent AS prixcnxparent_21, t0.prixcnxpartenaire AS prixcnxpartenaire_22, t0.reversecnxpart AS reversecnxpart_23, t0.reverseventepart AS reverseventepart_24, t0.Referenc AS Referenc_25, t0.cp AS cp_26, t0.id_etablisment AS id_etablisment_27, t0.Id_acommp AS Id_acommp_28, t0.id_partenaire AS id_partenaire_29, t0.statut AS statut_30, t0.age_group AS age_group_31 FROM sejour t0 WHERE t0.code_sejour = ? LIMIT 1 SELECT t0.id AS id_1, t0.code_sejour AS code_sejour_2, t0.date_creation_code AS date_creation_code_3, t0.date_fin_code AS date_fin_code_4, t0.them_sejour AS them_sejour_5, t0.adresse_sejour AS adresse_sejour_6, t0.pays AS pays_7, t0.ville AS ville_8, t0.code_postal AS code_postal_9, t0.date_debut_sejour AS date_debut_sejour_10, t0.date_fin_sejour AS date_fin_sejour_11, t0.nb_photo_diposer AS nb_photo_diposer_12, t0.paym AS paym_13, t0.albumgratuie AS albumgratuie_14, t0.nb_message AS nb_message_15, t0.etat_acomp_Album AS etat_acomp_Album_16, t0.etat_adresse_carte AS etat_adresse_carte_17, t0.nbenfan AS nbenfan_18, t0.nbenfantencours AS nbenfantencours_19, t0.cd AS cd_20, t0.prixcnxparent AS prixcnxparent_21, t0.prixcnxpartenaire AS prixcnxpartenaire_22, t0.reversecnxpart AS reversecnxpart_23, t0.reverseventepart AS reverseventepart_24, t0.Referenc AS Referenc_25, t0.cp AS cp_26, t0.id_etablisment AS id_etablisment_27, t0.Id_acommp AS Id_acommp_28, t0.id_partenaire AS id_partenaire_29, t0.statut AS statut_30, t0.age_group AS age_group_31 FROM sejour t0 WHERE t0.code_sejour = 'EF865747' LIMIT 1;
4	4.22 ms	SELECT l0_.date AS date_0, l0_.etat AS etat_1, l0_.id AS id_2, l0_.id_sejour AS id_sejour_3, l0_.id_sejour_attchment AS id_sejour_attchment_4, l0_.id_produit AS id_produit_5, l0_.id_user AS id_user_6 FROM likephoto l0_ WHERE l0_.id_user = ? AND l0_.id_sejour = ? Parameters: [`63581 17771`] View formatted query View runnable query Explain query SELECT l0_.date AS date_0, l0_.etat AS etat_1, l0_.id AS id_2, l0_.id_sejour AS id_sejour_3, l0_.id_sejour_attchment AS id_sejour_attchment_4, l0_.id_produit AS id_produit_5, l0_.id_user AS id_user_6 FROM likephoto l0_ WHERE l0_.id_user = ? AND l0_.id_sejour = ? SELECT l0_.date AS date_0, l0_.etat AS etat_1, l0_.id AS id_2, l0_.id_sejour AS id_sejour_3, l0_.id_sejour_attchment AS id_sejour_attchment_4, l0_.id_produit AS id_produit_5, l0_.id_user AS id_user_6 FROM likephoto l0_ WHERE l0_.id_user = 63581 AND l0_.id_sejour = 17771;
5	2.53 ms	SELECT t0.id AS id_1, t0.code_sejour AS code_sejour_2, t0.date_creation_code AS date_creation_code_3, t0.date_fin_code AS date_fin_code_4, t0.them_sejour AS them_sejour_5, t0.adresse_sejour AS adresse_sejour_6, t0.pays AS pays_7, t0.ville AS ville_8, t0.code_postal AS code_postal_9, t0.date_debut_sejour AS date_debut_sejour_10, t0.date_fin_sejour AS date_fin_sejour_11, t0.nb_photo_diposer AS nb_photo_diposer_12, t0.paym AS paym_13, t0.albumgratuie AS albumgratuie_14, t0.nb_message AS nb_message_15, t0.etat_acomp_Album AS etat_acomp_Album_16, t0.etat_adresse_carte AS etat_adresse_carte_17, t0.nbenfan AS nbenfan_18, t0.nbenfantencours AS nbenfantencours_19, t0.cd AS cd_20, t0.prixcnxparent AS prixcnxparent_21, t0.prixcnxpartenaire AS prixcnxpartenaire_22, t0.reversecnxpart AS reversecnxpart_23, t0.reverseventepart AS reverseventepart_24, t0.Referenc AS Referenc_25, t0.cp AS cp_26, t0.id_etablisment AS id_etablisment_27, t0.Id_acommp AS Id_acommp_28, t0.id_partenaire AS id_partenaire_29, t0.statut AS statut_30, t0.age_group AS age_group_31 FROM sejour t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"17771"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code_sejour AS code_sejour_2, t0.date_creation_code AS date_creation_code_3, t0.date_fin_code AS date_fin_code_4, t0.them_sejour AS them_sejour_5, t0.adresse_sejour AS adresse_sejour_6, t0.pays AS pays_7, t0.ville AS ville_8, t0.code_postal AS code_postal_9, t0.date_debut_sejour AS date_debut_sejour_10, t0.date_fin_sejour AS date_fin_sejour_11, t0.nb_photo_diposer AS nb_photo_diposer_12, t0.paym AS paym_13, t0.albumgratuie AS albumgratuie_14, t0.nb_message AS nb_message_15, t0.etat_acomp_Album AS etat_acomp_Album_16, t0.etat_adresse_carte AS etat_adresse_carte_17, t0.nbenfan AS nbenfan_18, t0.nbenfantencours AS nbenfantencours_19, t0.cd AS cd_20, t0.prixcnxparent AS prixcnxparent_21, t0.prixcnxpartenaire AS prixcnxpartenaire_22, t0.reversecnxpart AS reversecnxpart_23, t0.reverseventepart AS reverseventepart_24, t0.Referenc AS Referenc_25, t0.cp AS cp_26, t0.id_etablisment AS id_etablisment_27, t0.Id_acommp AS Id_acommp_28, t0.id_partenaire AS id_partenaire_29, t0.statut AS statut_30, t0.age_group AS age_group_31 FROM sejour t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1, t0.code_sejour AS code_sejour_2, t0.date_creation_code AS date_creation_code_3, t0.date_fin_code AS date_fin_code_4, t0.them_sejour AS them_sejour_5, t0.adresse_sejour AS adresse_sejour_6, t0.pays AS pays_7, t0.ville AS ville_8, t0.code_postal AS code_postal_9, t0.date_debut_sejour AS date_debut_sejour_10, t0.date_fin_sejour AS date_fin_sejour_11, t0.nb_photo_diposer AS nb_photo_diposer_12, t0.paym AS paym_13, t0.albumgratuie AS albumgratuie_14, t0.nb_message AS nb_message_15, t0.etat_acomp_Album AS etat_acomp_Album_16, t0.etat_adresse_carte AS etat_adresse_carte_17, t0.nbenfan AS nbenfan_18, t0.nbenfantencours AS nbenfantencours_19, t0.cd AS cd_20, t0.prixcnxparent AS prixcnxparent_21, t0.prixcnxpartenaire AS prixcnxpartenaire_22, t0.reversecnxpart AS reversecnxpart_23, t0.reverseventepart AS reverseventepart_24, t0.Referenc AS Referenc_25, t0.cp AS cp_26, t0.id_etablisment AS id_etablisment_27, t0.Id_acommp AS Id_acommp_28, t0.id_partenaire AS id_partenaire_29, t0.statut AS statut_30, t0.age_group AS age_group_31 FROM sejour t0 WHERE t0.id = '17771' LIMIT 1;
6	3.76 ms	SELECT s0_.id AS id_0, s0_.date_depot_attachement AS date_depot_attachement_1, s0_.etat AS etat_2, s0_.nbconsomateurattch AS nbconsomateurattch_3, s0_.nbpartenaireattch AS nbpartenaireattch_4, s0_.nbecoleattch AS nbecoleattch_5, s0_.statut AS statut_6, a1_.id AS id_7, a1_.path AS path_8, a1_.date AS date_9, a1_.idblog AS idblog_10, a1_.descreption AS descreption_11, r2_.id AS id_12, r2_.libiller AS libiller_13, r2_.code AS code_14, s0_.id_attchment AS id_attchment_15, s0_.id_sejour AS id_sejour_16, s0_.idParent_id AS idParent_id_17, a1_.idposition AS idposition_18, a1_.idref AS idref_19, a1_.iduser AS iduser_20, r2_.typeref AS typeref_21 FROM sejour_attachment s0_ INNER JOIN attachment a1_ ON s0_.id_attchment = a1_.id INNER JOIN ref r2_ ON a1_.idref = r2_.id WHERE s0_.id_sejour = ? AND r2_.libiller IN (?) Parameters: [`"17771" "message"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.date_depot_attachement AS date_depot_attachement_1, s0_.etat AS etat_2, s0_.nbconsomateurattch AS nbconsomateurattch_3, s0_.nbpartenaireattch AS nbpartenaireattch_4, s0_.nbecoleattch AS nbecoleattch_5, s0_.statut AS statut_6, a1_.id AS id_7, a1_.path AS path_8, a1_.date AS date_9, a1_.idblog AS idblog_10, a1_.descreption AS descreption_11, r2_.id AS id_12, r2_.libiller AS libiller_13, r2_.code AS code_14, s0_.id_attchment AS id_attchment_15, s0_.id_sejour AS id_sejour_16, s0_.idParent_id AS idParent_id_17, a1_.idposition AS idposition_18, a1_.idref AS idref_19, a1_.iduser AS iduser_20, r2_.typeref AS typeref_21 FROM sejour_attachment s0_ INNER JOIN attachment a1_ ON s0_.id_attchment = a1_.id INNER JOIN ref r2_ ON a1_.idref = r2_.id WHERE s0_.id_sejour = ? AND r2_.libiller IN (?) SELECT s0_.id AS id_0, s0_.date_depot_attachement AS date_depot_attachement_1, s0_.etat AS etat_2, s0_.nbconsomateurattch AS nbconsomateurattch_3, s0_.nbpartenaireattch AS nbpartenaireattch_4, s0_.nbecoleattch AS nbecoleattch_5, s0_.statut AS statut_6, a1_.id AS id_7, a1_.path AS path_8, a1_.date AS date_9, a1_.idblog AS idblog_10, a1_.descreption AS descreption_11, r2_.id AS id_12, r2_.libiller AS libiller_13, r2_.code AS code_14, s0_.id_attchment AS id_attchment_15, s0_.id_sejour AS id_sejour_16, s0_.idParent_id AS idParent_id_17, a1_.idposition AS idposition_18, a1_.idref AS idref_19, a1_.iduser AS iduser_20, r2_.typeref AS typeref_21 FROM sejour_attachment s0_ INNER JOIN attachment a1_ ON s0_.id_attchment = a1_.id INNER JOIN ref r2_ ON a1_.idref = r2_.id WHERE s0_.id_sejour = '17771' AND r2_.libiller IN ('message');
7	2.69 ms	SELECT s0_.id AS id_0, s0_.date_depot_attachement AS date_depot_attachement_1, s0_.etat AS etat_2, s0_.nbconsomateurattch AS nbconsomateurattch_3, s0_.nbpartenaireattch AS nbpartenaireattch_4, s0_.nbecoleattch AS nbecoleattch_5, s0_.statut AS statut_6, a1_.id AS id_7, a1_.path AS path_8, a1_.date AS date_9, a1_.idblog AS idblog_10, a1_.descreption AS descreption_11, r2_.id AS id_12, r2_.libiller AS libiller_13, r2_.code AS code_14, s0_.id_attchment AS id_attchment_15, s0_.id_sejour AS id_sejour_16, s0_.idParent_id AS idParent_id_17, a1_.idposition AS idposition_18, a1_.idref AS idref_19, a1_.iduser AS iduser_20, r2_.typeref AS typeref_21 FROM sejour_attachment s0_ INNER JOIN attachment a1_ ON s0_.id_attchment = a1_.id INNER JOIN ref r2_ ON a1_.idref = r2_.id WHERE s0_.id_sejour = ? AND s0_.statut = ? AND r2_.libiller IN (?, ?) Parameters: [`"17771" "public" "photo" "video"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.date_depot_attachement AS date_depot_attachement_1, s0_.etat AS etat_2, s0_.nbconsomateurattch AS nbconsomateurattch_3, s0_.nbpartenaireattch AS nbpartenaireattch_4, s0_.nbecoleattch AS nbecoleattch_5, s0_.statut AS statut_6, a1_.id AS id_7, a1_.path AS path_8, a1_.date AS date_9, a1_.idblog AS idblog_10, a1_.descreption AS descreption_11, r2_.id AS id_12, r2_.libiller AS libiller_13, r2_.code AS code_14, s0_.id_attchment AS id_attchment_15, s0_.id_sejour AS id_sejour_16, s0_.idParent_id AS idParent_id_17, a1_.idposition AS idposition_18, a1_.idref AS idref_19, a1_.iduser AS iduser_20, r2_.typeref AS typeref_21 FROM sejour_attachment s0_ INNER JOIN attachment a1_ ON s0_.id_attchment = a1_.id INNER JOIN ref r2_ ON a1_.idref = r2_.id WHERE s0_.id_sejour = ? AND s0_.statut = ? AND r2_.libiller IN (?, ?) SELECT s0_.id AS id_0, s0_.date_depot_attachement AS date_depot_attachement_1, s0_.etat AS etat_2, s0_.nbconsomateurattch AS nbconsomateurattch_3, s0_.nbpartenaireattch AS nbpartenaireattch_4, s0_.nbecoleattch AS nbecoleattch_5, s0_.statut AS statut_6, a1_.id AS id_7, a1_.path AS path_8, a1_.date AS date_9, a1_.idblog AS idblog_10, a1_.descreption AS descreption_11, r2_.id AS id_12, r2_.libiller AS libiller_13, r2_.code AS code_14, s0_.id_attchment AS id_attchment_15, s0_.id_sejour AS id_sejour_16, s0_.idParent_id AS idParent_id_17, a1_.idposition AS idposition_18, a1_.idref AS idref_19, a1_.iduser AS iduser_20, r2_.typeref AS typeref_21 FROM sejour_attachment s0_ INNER JOIN attachment a1_ ON s0_.id_attchment = a1_.id INNER JOIN ref r2_ ON a1_.idref = r2_.id WHERE s0_.id_sejour = '17771' AND s0_.statut = 'public' AND r2_.libiller IN ('photo', 'video');
8	3.13 ms	SELECT l0_.date AS date_0, l0_.etat AS etat_1, l0_.id AS id_2, l0_.id_sejour AS id_sejour_3, l0_.id_sejour_attchment AS id_sejour_attchment_4, l0_.id_produit AS id_produit_5, l0_.id_user AS id_user_6 FROM likephoto l0_ WHERE l0_.id_user = ? AND l0_.id_sejour = ? Parameters: [`63581 "17771"`] View formatted query View runnable query Explain query SELECT l0_.date AS date_0, l0_.etat AS etat_1, l0_.id AS id_2, l0_.id_sejour AS id_sejour_3, l0_.id_sejour_attchment AS id_sejour_attchment_4, l0_.id_produit AS id_produit_5, l0_.id_user AS id_user_6 FROM likephoto l0_ WHERE l0_.id_user = ? AND l0_.id_sejour = ? SELECT l0_.date AS date_0, l0_.etat AS etat_1, l0_.id AS id_2, l0_.id_sejour AS id_sejour_3, l0_.id_sejour_attchment AS id_sejour_attchment_4, l0_.id_produit AS id_produit_5, l0_.id_user AS id_user_6 FROM likephoto l0_ WHERE l0_.id_user = 63581 AND l0_.id_sejour = '17771';
9	2.62 ms	SELECT s0_.id AS id_0, s0_.date_depot_attachement AS date_depot_attachement_1, s0_.etat AS etat_2, s0_.nbconsomateurattch AS nbconsomateurattch_3, s0_.nbpartenaireattch AS nbpartenaireattch_4, s0_.nbecoleattch AS nbecoleattch_5, s0_.statut AS statut_6, a1_.id AS id_7, a1_.path AS path_8, a1_.date AS date_9, a1_.idblog AS idblog_10, a1_.descreption AS descreption_11, r2_.id AS id_12, r2_.libiller AS libiller_13, r2_.code AS code_14, s0_.id_attchment AS id_attchment_15, s0_.id_sejour AS id_sejour_16, s0_.idParent_id AS idParent_id_17, a1_.idposition AS idposition_18, a1_.idref AS idref_19, a1_.iduser AS iduser_20, r2_.typeref AS typeref_21 FROM sejour_attachment s0_ INNER JOIN attachment a1_ ON s0_.id_attchment = a1_.id INNER JOIN ref r2_ ON a1_.idref = r2_.id WHERE s0_.id_sejour = ? AND r2_.libiller IN (?) Parameters: [`"17771" "message"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.date_depot_attachement AS date_depot_attachement_1, s0_.etat AS etat_2, s0_.nbconsomateurattch AS nbconsomateurattch_3, s0_.nbpartenaireattch AS nbpartenaireattch_4, s0_.nbecoleattch AS nbecoleattch_5, s0_.statut AS statut_6, a1_.id AS id_7, a1_.path AS path_8, a1_.date AS date_9, a1_.idblog AS idblog_10, a1_.descreption AS descreption_11, r2_.id AS id_12, r2_.libiller AS libiller_13, r2_.code AS code_14, s0_.id_attchment AS id_attchment_15, s0_.id_sejour AS id_sejour_16, s0_.idParent_id AS idParent_id_17, a1_.idposition AS idposition_18, a1_.idref AS idref_19, a1_.iduser AS iduser_20, r2_.typeref AS typeref_21 FROM sejour_attachment s0_ INNER JOIN attachment a1_ ON s0_.id_attchment = a1_.id INNER JOIN ref r2_ ON a1_.idref = r2_.id WHERE s0_.id_sejour = ? AND r2_.libiller IN (?) SELECT s0_.id AS id_0, s0_.date_depot_attachement AS date_depot_attachement_1, s0_.etat AS etat_2, s0_.nbconsomateurattch AS nbconsomateurattch_3, s0_.nbpartenaireattch AS nbpartenaireattch_4, s0_.nbecoleattch AS nbecoleattch_5, s0_.statut AS statut_6, a1_.id AS id_7, a1_.path AS path_8, a1_.date AS date_9, a1_.idblog AS idblog_10, a1_.descreption AS descreption_11, r2_.id AS id_12, r2_.libiller AS libiller_13, r2_.code AS code_14, s0_.id_attchment AS id_attchment_15, s0_.id_sejour AS id_sejour_16, s0_.idParent_id AS idParent_id_17, a1_.idposition AS idposition_18, a1_.idref AS idref_19, a1_.iduser AS iduser_20, r2_.typeref AS typeref_21 FROM sejour_attachment s0_ INNER JOIN attachment a1_ ON s0_.id_attchment = a1_.id INNER JOIN ref r2_ ON a1_.idref = r2_.id WHERE s0_.id_sejour = '17771' AND r2_.libiller IN ('message');
10	2.57 ms	SELECT * FROM position AS p, cart AS c, sejour AS s WHERE p.idcart = c.id AND c.idsejour= s.id AND s.id = 17771 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM position AS p, cart AS c, sejour AS s WHERE p.idcart = c.id AND c.idsejour = s.id AND s.id = 17771 SELECT * FROM position AS p, cart AS c, sejour AS s WHERE p.idcart = c.id AND c.idsejour= s.id AND s.id = 17771;
11	2.96 ms	SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = ? AND t0.iduser = ? AND t0.statut = ? ORDER BY t0.id DESC LIMIT 1 Parameters: [`17771 116971 "saved"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = ? AND t0.iduser = ? AND t0.statut = ? ORDER BY t0.id DESC LIMIT 1 SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = 17771 AND t0.iduser = 116971 AND t0.statut = 'saved' ORDER BY t0.id DESC LIMIT 1;
12	2.69 ms	SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.iduser = ? AND t0.statut = ? AND t0.idsjour = ? LIMIT 1 Parameters: [`1 "Album_sejour" 17771`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.iduser = ? AND t0.statut = ? AND t0.idsjour = ? LIMIT 1 SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.iduser = 1 AND t0.statut = 'Album_sejour' AND t0.idsjour = 17771 LIMIT 1;
13	2.53 ms	SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = ? AND t0.iduser = ? AND t0.statut = ? ORDER BY t0.id DESC LIMIT 1 Parameters: [`17771 116971 "saved"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = ? AND t0.iduser = ? AND t0.statut = ? ORDER BY t0.id DESC LIMIT 1 SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = 17771 AND t0.iduser = 116971 AND t0.statut = 'saved' ORDER BY t0.id DESC LIMIT 1;
14	2.56 ms	SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = ? AND t0.iduser = ? AND t0.statut = ? ORDER BY t0.id DESC LIMIT 1 Parameters: [`17771 116971 "saved"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = ? AND t0.iduser = ? AND t0.statut = ? ORDER BY t0.id DESC LIMIT 1 SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = 17771 AND t0.iduser = 116971 AND t0.statut = 'saved' ORDER BY t0.id DESC LIMIT 1;
15	2.59 ms	SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.iduser = ? AND t0.statut = ? AND t0.idsjour = ? LIMIT 1 Parameters: [`1 "Album_sejour" 17771`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.iduser = ? AND t0.statut = ? AND t0.idsjour = ? LIMIT 1 SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.iduser = 1 AND t0.statut = 'Album_sejour' AND t0.idsjour = 17771 LIMIT 1;
16	2.70 ms	SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.statut = ? AND t0.idsjour = ? AND t0.labele = ? AND t0.version = ? LIMIT 1 Parameters: [`"Livre_sejour" 17771 "Livre_sejourEF865747" "Livre_Admin"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.statut = ? AND t0.idsjour = ? AND t0.labele = ? AND t0.version = ? LIMIT 1 SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.statut = 'Livre_sejour' AND t0.idsjour = 17771 AND t0.labele = 'Livre_sejourEF865747' AND t0.version = 'Livre_Admin' LIMIT 1;
17	3.51 ms	SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.date_modification AS date_modification_3, t0.payment AS payment_4, t0.smsnotif AS smsnotif_5, t0.mailnotif AS mailnotif_6, t0.traiter AS traiter_7, t0.rev AS rev_8, t0.fact AS fact_9, t0.flagPrix AS flagPrix_10, t0.id_parent AS id_parent_11, t0.Id_sejour AS Id_sejour_12 FROM parent_sejour t0 WHERE t0.id_parent = ? AND t0.Id_sejour = ? LIMIT 1 Parameters: [`63581 17771`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.date_modification AS date_modification_3, t0.payment AS payment_4, t0.smsnotif AS smsnotif_5, t0.mailnotif AS mailnotif_6, t0.traiter AS traiter_7, t0.rev AS rev_8, t0.fact AS fact_9, t0.flagPrix AS flagPrix_10, t0.id_parent AS id_parent_11, t0.Id_sejour AS Id_sejour_12 FROM parent_sejour t0 WHERE t0.id_parent = ? AND t0.Id_sejour = ? LIMIT 1 SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.date_modification AS date_modification_3, t0.payment AS payment_4, t0.smsnotif AS smsnotif_5, t0.mailnotif AS mailnotif_6, t0.traiter AS traiter_7, t0.rev AS rev_8, t0.fact AS fact_9, t0.flagPrix AS flagPrix_10, t0.id_parent AS id_parent_11, t0.Id_sejour AS Id_sejour_12 FROM parent_sejour t0 WHERE t0.id_parent = 63581 AND t0.Id_sejour = 17771 LIMIT 1;
18	3.18 ms	SELECT t0_.id AS id_0, t0_.montantHT AS montantHT_1, t0_.montantTTC AS montantTTC_2, t0_.TVA AS TVA_3, t0_.poidsContenant AS poidsContenant_4, t0_.poidsProduit AS poidsProduit_5, t0_.poidsTotal AS poidsTotal_6, t0_.pochetteEnvoi AS pochetteEnvoi_7, t0_.descriptionCommande AS descriptionCommande_8, t0_.type AS type_9, t0_.sousTitre AS sousTitre_10, t0_.orderprod AS orderprod_11, t0_.idTypeProduit_id AS idTypeProduit_id_12 FROM typeproduitconditionnement t0_ INNER JOIN typeproduit t1_ ON t0_.idTypeProduit_id = t1_.id WHERE t1_.statut = ? ORDER BY t0_.orderprod ASC Parameters: [`"publier"`] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.montantHT AS montantHT_1, t0_.montantTTC AS montantTTC_2, t0_.TVA AS TVA_3, t0_.poidsContenant AS poidsContenant_4, t0_.poidsProduit AS poidsProduit_5, t0_.poidsTotal AS poidsTotal_6, t0_.pochetteEnvoi AS pochetteEnvoi_7, t0_.descriptionCommande AS descriptionCommande_8, t0_.type AS type_9, t0_.sousTitre AS sousTitre_10, t0_.orderprod AS orderprod_11, t0_.idTypeProduit_id AS idTypeProduit_id_12 FROM typeproduitconditionnement t0_ INNER JOIN typeproduit t1_ ON t0_.idTypeProduit_id = t1_.id WHERE t1_.statut = ? ORDER BY t0_.orderprod ASC SELECT t0_.id AS id_0, t0_.montantHT AS montantHT_1, t0_.montantTTC AS montantTTC_2, t0_.TVA AS TVA_3, t0_.poidsContenant AS poidsContenant_4, t0_.poidsProduit AS poidsProduit_5, t0_.poidsTotal AS poidsTotal_6, t0_.pochetteEnvoi AS pochetteEnvoi_7, t0_.descriptionCommande AS descriptionCommande_8, t0_.type AS type_9, t0_.sousTitre AS sousTitre_10, t0_.orderprod AS orderprod_11, t0_.idTypeProduit_id AS idTypeProduit_id_12 FROM typeproduitconditionnement t0_ INNER JOIN typeproduit t1_ ON t0_.idTypeProduit_id = t1_.id WHERE t1_.statut = 'publier' ORDER BY t0_.orderprod ASC;
19	2.90 ms	SELECT t0.id AS id_1, t0.labeleType AS labeleType_2, t0.caracteristiques AS caracteristiques_3, t0.delais AS delais_4, t0.tarifs AS tarifs_5, t0.traif AS traif_6, t0.fraisDePort AS fraisDePort_7, t0.date AS date_8, t0.description AS description_9, t0.plusDescription AS plusDescription_10, t0.MontantHt AS MontantHt_11, t0.MontantTTC AS MontantTTC_12, t0.PoindsEnGrContenant AS PoindsEnGrContenant_13, t0.PoidsEnGrProduit AS PoidsEnGrProduit_14, t0.PoidsTotalEnGrHorsPochette AS PoidsTotalEnGrHorsPochette_15, t0.PochetteEnvoi AS PochetteEnvoi_16, t0.statut AS statut_17, t0.reversement AS reversement_18, t0.iduser AS iduser_19 FROM typeproduit t0 WHERE t0.statut = ? Parameters: [`"publier"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.labeleType AS labeleType_2, t0.caracteristiques AS caracteristiques_3, t0.delais AS delais_4, t0.tarifs AS tarifs_5, t0.traif AS traif_6, t0.fraisDePort AS fraisDePort_7, t0.date AS date_8, t0.description AS description_9, t0.plusDescription AS plusDescription_10, t0.MontantHt AS MontantHt_11, t0.MontantTTC AS MontantTTC_12, t0.PoindsEnGrContenant AS PoindsEnGrContenant_13, t0.PoidsEnGrProduit AS PoidsEnGrProduit_14, t0.PoidsTotalEnGrHorsPochette AS PoidsTotalEnGrHorsPochette_15, t0.PochetteEnvoi AS PochetteEnvoi_16, t0.statut AS statut_17, t0.reversement AS reversement_18, t0.iduser AS iduser_19 FROM typeproduit t0 WHERE t0.statut = ? SELECT t0.id AS id_1, t0.labeleType AS labeleType_2, t0.caracteristiques AS caracteristiques_3, t0.delais AS delais_4, t0.tarifs AS tarifs_5, t0.traif AS traif_6, t0.fraisDePort AS fraisDePort_7, t0.date AS date_8, t0.description AS description_9, t0.plusDescription AS plusDescription_10, t0.MontantHt AS MontantHt_11, t0.MontantTTC AS MontantTTC_12, t0.PoindsEnGrContenant AS PoindsEnGrContenant_13, t0.PoidsEnGrProduit AS PoidsEnGrProduit_14, t0.PoidsTotalEnGrHorsPochette AS PoidsTotalEnGrHorsPochette_15, t0.PochetteEnvoi AS PochetteEnvoi_16, t0.statut AS statut_17, t0.reversement AS reversement_18, t0.iduser AS iduser_19 FROM typeproduit t0 WHERE t0.statut = 'publier';
20	3.57 ms	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_sejour = ? AND t0.id_user = ? Parameters: [`17771 63581`] 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_sejour = ? AND t0.id_user = ? 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_sejour = 17771 AND t0.id_user = 63581;
21	2.60 ms	SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.date_modification AS date_modification_3, t0.payment AS payment_4, t0.smsnotif AS smsnotif_5, t0.mailnotif AS mailnotif_6, t0.traiter AS traiter_7, t0.rev AS rev_8, t0.fact AS fact_9, t0.flagPrix AS flagPrix_10, t0.id_parent AS id_parent_11, t0.Id_sejour AS Id_sejour_12 FROM parent_sejour t0 WHERE t0.Id_sejour = ? AND t0.id_parent = ? LIMIT 1 Parameters: [`17771 63581`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.date_modification AS date_modification_3, t0.payment AS payment_4, t0.smsnotif AS smsnotif_5, t0.mailnotif AS mailnotif_6, t0.traiter AS traiter_7, t0.rev AS rev_8, t0.fact AS fact_9, t0.flagPrix AS flagPrix_10, t0.id_parent AS id_parent_11, t0.Id_sejour AS Id_sejour_12 FROM parent_sejour t0 WHERE t0.Id_sejour = ? AND t0.id_parent = ? LIMIT 1 SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.date_modification AS date_modification_3, t0.payment AS payment_4, t0.smsnotif AS smsnotif_5, t0.mailnotif AS mailnotif_6, t0.traiter AS traiter_7, t0.rev AS rev_8, t0.fact AS fact_9, t0.flagPrix AS flagPrix_10, t0.id_parent AS id_parent_11, t0.Id_sejour AS Id_sejour_12 FROM parent_sejour t0 WHERE t0.Id_sejour = 17771 AND t0.id_parent = 63581 LIMIT 1;
22	2.96 ms	SELECT * FROM attachment AS A, sejour_attachment AS sa, sejour AS s, ref As r WHERE A.id = sa.id_attchment AND A.idref= r.id AND r.libiller like ? AND sa.id_sejour= s.id AND s.id = 17771 Parameters: [`"%message%"`] View formatted query View runnable query Explain query SELECT * FROM attachment AS A, sejour_attachment AS sa, sejour AS s, ref As r WHERE A.id = sa.id_attchment AND A.idref = r.id AND r.libiller like ? AND sa.id_sejour = s.id AND s.id = 17771 SELECT * FROM attachment AS A, sejour_attachment AS sa, sejour AS s, ref As r WHERE A.id = sa.id_attchment AND A.idref= r.id AND r.libiller like '%message%' AND sa.id_sejour= s.id AND s.id = 17771;
23	3.93 ms	SELECT l0_.date AS date_0, l0_.etat AS etat_1, l0_.id AS id_2, l0_.id_sejour AS id_sejour_3, l0_.id_sejour_attchment AS id_sejour_attchment_4, l0_.id_produit AS id_produit_5, l0_.id_user AS id_user_6 FROM likephoto l0_ WHERE l0_.id_user = ? AND l0_.id_sejour = ? Parameters: [`63581 17771`] View formatted query View runnable query Explain query SELECT l0_.date AS date_0, l0_.etat AS etat_1, l0_.id AS id_2, l0_.id_sejour AS id_sejour_3, l0_.id_sejour_attchment AS id_sejour_attchment_4, l0_.id_produit AS id_produit_5, l0_.id_user AS id_user_6 FROM likephoto l0_ WHERE l0_.id_user = ? AND l0_.id_sejour = ? SELECT l0_.date AS date_0, l0_.etat AS etat_1, l0_.id AS id_2, l0_.id_sejour AS id_sejour_3, l0_.id_sejour_attchment AS id_sejour_attchment_4, l0_.id_produit AS id_produit_5, l0_.id_user AS id_user_6 FROM likephoto l0_ WHERE l0_.id_user = 63581 AND l0_.id_sejour = 17771;
24	2.58 ms	SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = ? AND t0.iduser = ? AND t0.statut = ? LIMIT 1 Parameters: [`17771 116971 "Album_sejour"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = ? AND t0.iduser = ? AND t0.statut = ? LIMIT 1 SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = 17771 AND t0.iduser = 116971 AND t0.statut = 'Album_sejour' LIMIT 1;
25	2.62 ms	SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = ? AND t0.iduser = ? AND t0.statut = ? LIMIT 1 Parameters: [`17771 116971 "Livre_sejour"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = ? AND t0.iduser = ? AND t0.statut = ? LIMIT 1 SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = 17771 AND t0.iduser = 116971 AND t0.statut = 'Livre_sejour' LIMIT 1;
26	2.55 ms	SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.iduser = ? AND t0.statut = ? AND t0.idsjour = ? LIMIT 1 Parameters: [`1 "Album_sejour" 17771`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.iduser = ? AND t0.statut = ? AND t0.idsjour = ? LIMIT 1 SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.iduser = 1 AND t0.statut = 'Album_sejour' AND t0.idsjour = 17771 LIMIT 1;
27	2.51 ms	SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.statut = ? AND t0.idsjour = ? AND t0.labele = ? AND t0.version = ? LIMIT 1 Parameters: [`"Livre_sejour" 17771 "Livre_sejourEF865747" "Livre_Admin"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.statut = ? AND t0.idsjour = ? AND t0.labele = ? AND t0.version = ? LIMIT 1 SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.statut = 'Livre_sejour' AND t0.idsjour = 17771 AND t0.labele = 'Livre_sejourEF865747' AND t0.version = 'Livre_Admin' LIMIT 1;
28	3.25 ms	SELECT t0.id AS id_1, t0.nbconnx AS nbconnx_2, t0.username AS username_3, t0.adresse AS adresse_4, t0.fonction AS fonction_5, t0.etablisment AS etablisment_6, t0.numMobile AS numMobile_7, t0.logourl AS logourl_8, t0.Datedepart AS Datedepart_9, t0.dateFlagDepot AS dateFlagDepot_10, t0.flagDepot AS flagDepot_11, t0.nom AS nom_12, t0.prenom AS prenom_13, t0.roles AS roles_14, t0.email AS email_15, t0.password AS password_16, t0.salt AS salt_17, t0.date_creation AS date_creation_18, t0.nometablisment AS nometablisment_19, t0.randomnotice AS randomnotice_20, t0.infocomple AS infocomple_21, t0.reponseemail AS reponseemail_22, t0.password_non_cripted AS password_non_cripted_23, t0.cnxparent AS cnxparent_24, t0.accompaplus AS accompaplus_25, t0.activatemail AS activatemail_26, t0.Jeton AS Jeton_27, t0.showpubprod AS showpubprod_28, t0.showdetailsalbum AS showdetailsalbum_29, t0.showdetailslivre AS showdetailslivre_30, t0.showdetailsphotos AS showdetailsphotos_31, t0.showdetailsretros AS showdetailsretros_32, t0.showdetailscal AS showdetailscal_33, t0.cnxpartenaire AS cnxpartenaire_34, t0.smsnotif AS smsnotif_35, t0.mailnotif AS mailnotif_36, t0.AccoPlusToPartenaire AS AccoPlusToPartenaire_37, t0.jetonAccoPlusSejourGratuit AS jetonAccoPlusSejourGratuit_38, t0.adresslivraison AS adresslivraison_39, t0.adressfactoration AS adressfactoration_40, t0.statut AS statut_41, t0.usersecondaire AS usersecondaire_42, t0.comptebanque AS comptebanque_43, t0.idFonction_id AS idFonction_id_44 FROM user t0 WHERE t0.id = ? Parameters: [`116972`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nbconnx AS nbconnx_2, t0.username AS username_3, t0.adresse AS adresse_4, t0.fonction AS fonction_5, t0.etablisment AS etablisment_6, t0.numMobile AS numMobile_7, t0.logourl AS logourl_8, t0.Datedepart AS Datedepart_9, t0.dateFlagDepot AS dateFlagDepot_10, t0.flagDepot AS flagDepot_11, t0.nom AS nom_12, t0.prenom AS prenom_13, t0.roles AS roles_14, t0.email AS email_15, t0.password AS password_16, t0.salt AS salt_17, t0.date_creation AS date_creation_18, t0.nometablisment AS nometablisment_19, t0.randomnotice AS randomnotice_20, t0.infocomple AS infocomple_21, t0.reponseemail AS reponseemail_22, t0.password_non_cripted AS password_non_cripted_23, t0.cnxparent AS cnxparent_24, t0.accompaplus AS accompaplus_25, t0.activatemail AS activatemail_26, t0.Jeton AS Jeton_27, t0.showpubprod AS showpubprod_28, t0.showdetailsalbum AS showdetailsalbum_29, t0.showdetailslivre AS showdetailslivre_30, t0.showdetailsphotos AS showdetailsphotos_31, t0.showdetailsretros AS showdetailsretros_32, t0.showdetailscal AS showdetailscal_33, t0.cnxpartenaire AS cnxpartenaire_34, t0.smsnotif AS smsnotif_35, t0.mailnotif AS mailnotif_36, t0.AccoPlusToPartenaire AS AccoPlusToPartenaire_37, t0.jetonAccoPlusSejourGratuit AS jetonAccoPlusSejourGratuit_38, t0.adresslivraison AS adresslivraison_39, t0.adressfactoration AS adressfactoration_40, t0.statut AS statut_41, t0.usersecondaire AS usersecondaire_42, t0.comptebanque AS comptebanque_43, t0.idFonction_id AS idFonction_id_44 FROM user t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.nbconnx AS nbconnx_2, t0.username AS username_3, t0.adresse AS adresse_4, t0.fonction AS fonction_5, t0.etablisment AS etablisment_6, t0.numMobile AS numMobile_7, t0.logourl AS logourl_8, t0.Datedepart AS Datedepart_9, t0.dateFlagDepot AS dateFlagDepot_10, t0.flagDepot AS flagDepot_11, t0.nom AS nom_12, t0.prenom AS prenom_13, t0.roles AS roles_14, t0.email AS email_15, t0.password AS password_16, t0.salt AS salt_17, t0.date_creation AS date_creation_18, t0.nometablisment AS nometablisment_19, t0.randomnotice AS randomnotice_20, t0.infocomple AS infocomple_21, t0.reponseemail AS reponseemail_22, t0.password_non_cripted AS password_non_cripted_23, t0.cnxparent AS cnxparent_24, t0.accompaplus AS accompaplus_25, t0.activatemail AS activatemail_26, t0.Jeton AS Jeton_27, t0.showpubprod AS showpubprod_28, t0.showdetailsalbum AS showdetailsalbum_29, t0.showdetailslivre AS showdetailslivre_30, t0.showdetailsphotos AS showdetailsphotos_31, t0.showdetailsretros AS showdetailsretros_32, t0.showdetailscal AS showdetailscal_33, t0.cnxpartenaire AS cnxpartenaire_34, t0.smsnotif AS smsnotif_35, t0.mailnotif AS mailnotif_36, t0.AccoPlusToPartenaire AS AccoPlusToPartenaire_37, t0.jetonAccoPlusSejourGratuit AS jetonAccoPlusSejourGratuit_38, t0.adresslivraison AS adresslivraison_39, t0.adressfactoration AS adressfactoration_40, t0.statut AS statut_41, t0.usersecondaire AS usersecondaire_42, t0.comptebanque AS comptebanque_43, t0.idFonction_id AS idFonction_id_44 FROM user t0 WHERE t0.id = 116972;
29	3.19 ms	SELECT t0.id AS id_1, t0.description AS description_2, t0.datejourphoto AS datejourphoto_3, t0.idsejour AS idsejour_4 FROM jourdescripdate t0 WHERE t0.idsejour = ? Parameters: [`17771`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.description AS description_2, t0.datejourphoto AS datejourphoto_3, t0.idsejour AS idsejour_4 FROM jourdescripdate t0 WHERE t0.idsejour = ? SELECT t0.id AS id_1, t0.description AS description_2, t0.datejourphoto AS datejourphoto_3, t0.idsejour AS idsejour_4 FROM jourdescripdate t0 WHERE t0.idsejour = 17771;
30	2.72 ms	SELECT t0.id AS id_1, t0.labeleType AS labeleType_2, t0.caracteristiques AS caracteristiques_3, t0.delais AS delais_4, t0.tarifs AS tarifs_5, t0.traif AS traif_6, t0.fraisDePort AS fraisDePort_7, t0.date AS date_8, t0.description AS description_9, t0.plusDescription AS plusDescription_10, t0.MontantHt AS MontantHt_11, t0.MontantTTC AS MontantTTC_12, t0.PoindsEnGrContenant AS PoindsEnGrContenant_13, t0.PoidsEnGrProduit AS PoidsEnGrProduit_14, t0.PoidsTotalEnGrHorsPochette AS PoidsTotalEnGrHorsPochette_15, t0.PochetteEnvoi AS PochetteEnvoi_16, t0.statut AS statut_17, t0.reversement AS reversement_18, t0.iduser AS iduser_19 FROM typeproduit t0 WHERE t0.statut = ? Parameters: [`"publier"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.labeleType AS labeleType_2, t0.caracteristiques AS caracteristiques_3, t0.delais AS delais_4, t0.tarifs AS tarifs_5, t0.traif AS traif_6, t0.fraisDePort AS fraisDePort_7, t0.date AS date_8, t0.description AS description_9, t0.plusDescription AS plusDescription_10, t0.MontantHt AS MontantHt_11, t0.MontantTTC AS MontantTTC_12, t0.PoindsEnGrContenant AS PoindsEnGrContenant_13, t0.PoidsEnGrProduit AS PoidsEnGrProduit_14, t0.PoidsTotalEnGrHorsPochette AS PoidsTotalEnGrHorsPochette_15, t0.PochetteEnvoi AS PochetteEnvoi_16, t0.statut AS statut_17, t0.reversement AS reversement_18, t0.iduser AS iduser_19 FROM typeproduit t0 WHERE t0.statut = ? SELECT t0.id AS id_1, t0.labeleType AS labeleType_2, t0.caracteristiques AS caracteristiques_3, t0.delais AS delais_4, t0.tarifs AS tarifs_5, t0.traif AS traif_6, t0.fraisDePort AS fraisDePort_7, t0.date AS date_8, t0.description AS description_9, t0.plusDescription AS plusDescription_10, t0.MontantHt AS MontantHt_11, t0.MontantTTC AS MontantTTC_12, t0.PoindsEnGrContenant AS PoindsEnGrContenant_13, t0.PoidsEnGrProduit AS PoidsEnGrProduit_14, t0.PoidsTotalEnGrHorsPochette AS PoidsTotalEnGrHorsPochette_15, t0.PochetteEnvoi AS PochetteEnvoi_16, t0.statut AS statut_17, t0.reversement AS reversement_18, t0.iduser AS iduser_19 FROM typeproduit t0 WHERE t0.statut = 'publier';
31	3.60 ms	SELECT l0_.date AS date_0, l0_.etat AS etat_1, l0_.id AS id_2, l0_.id_sejour AS id_sejour_3, l0_.id_sejour_attchment AS id_sejour_attchment_4, l0_.id_produit AS id_produit_5, l0_.id_user AS id_user_6 FROM likephoto l0_ WHERE l0_.id_user = ? AND l0_.id_sejour = ? Parameters: [`63581 17771`] View formatted query View runnable query Explain query SELECT l0_.date AS date_0, l0_.etat AS etat_1, l0_.id AS id_2, l0_.id_sejour AS id_sejour_3, l0_.id_sejour_attchment AS id_sejour_attchment_4, l0_.id_produit AS id_produit_5, l0_.id_user AS id_user_6 FROM likephoto l0_ WHERE l0_.id_user = ? AND l0_.id_sejour = ? SELECT l0_.date AS date_0, l0_.etat AS etat_1, l0_.id AS id_2, l0_.id_sejour AS id_sejour_3, l0_.id_sejour_attchment AS id_sejour_attchment_4, l0_.id_produit AS id_produit_5, l0_.id_user AS id_user_6 FROM likephoto l0_ WHERE l0_.id_user = 63581 AND l0_.id_sejour = 17771;
32	3.28 ms	SELECT * FROM attachment AS A, sejour_attachment AS sa, sejour AS s, ref As r WHERE A.id = sa.id_attchment AND A.idref= r.id AND r.libiller like ? AND sa.id_sejour= s.id AND sa.statut like ? AND s.id = 17771 Parameters: [`"%photo%" "%public%"`] View formatted query View runnable query Explain query SELECT * FROM attachment AS A, sejour_attachment AS sa, sejour AS s, ref As r WHERE A.id = sa.id_attchment AND A.idref = r.id AND r.libiller like ? AND sa.id_sejour = s.id AND sa.statut like ? AND s.id = 17771 SELECT * FROM attachment AS A, sejour_attachment AS sa, sejour AS s, ref As r WHERE A.id = sa.id_attchment AND A.idref= r.id AND r.libiller like '%photo%' AND sa.id_sejour= s.id AND sa.statut like '%public%' AND s.id = 17771;
33	2.83 ms	SELECT * FROM attachment AS A, sejour_attachment AS sa, sejour AS s, ref As r WHERE A.id = sa.id_attchment AND A.idref= r.id AND r.libiller like ? AND sa.id_sejour= s.id AND s.id = 17771 Parameters: [`"%message%"`] View formatted query View runnable query Explain query SELECT * FROM attachment AS A, sejour_attachment AS sa, sejour AS s, ref As r WHERE A.id = sa.id_attchment AND A.idref = r.id AND r.libiller like ? AND sa.id_sejour = s.id AND s.id = 17771 SELECT * FROM attachment AS A, sejour_attachment AS sa, sejour AS s, ref As r WHERE A.id = sa.id_attchment AND A.idref= r.id AND r.libiller like '%message%' AND sa.id_sejour= s.id AND s.id = 17771;
34	2.47 ms	SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = ? AND t0.iduser = ? AND t0.statut = ? ORDER BY t0.id DESC LIMIT 1 Parameters: [`17771 116971 "saved"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = ? AND t0.iduser = ? AND t0.statut = ? ORDER BY t0.id DESC LIMIT 1 SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = 17771 AND t0.iduser = 116971 AND t0.statut = 'saved' ORDER BY t0.id DESC 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\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\Adress	No errors.
App\Entity\Ref	No errors.
App\Entity\Comptebancaire	No errors.
App\Entity\Fonctions	No 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\Etablisment	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\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\SejourAttachment	No errors.
App\Entity\Panier	No errors.
App\Entity\Etiquette	No errors.
App\Entity\CommentaireEtiquette	No errors.
App\Entity\LogPromotions	No errors.
App\Entity\PromoParents	No errors.
App\Entity\Photonsumeriques	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\Jourdescripdate	No errors.
App\Entity\ParentSejour	No errors.
App\Entity\PromoSejour	No errors.
App\Entity\Likephoto	No errors.
App\Entity\Attachment	No errors.
App\Entity\Position	No errors.
App\Entity\Typeref	No errors.
App\Entity\Promotions	No errors.
App\Entity\Typeproduit	The field App\Entity\Typeproduit#attachements is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TypeProduitPhoto#idTypep does not contain the required 'inversedBy="attachements"' attribute. The field App\Entity\Typeproduit#reversment is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Reversement#idTypeproduit does not contain the required 'inversedBy="reversment"' attribute. The field App\Entity\Typeproduit#mesproduits is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Produit#type does not contain the required 'inversedBy="mesproduits"' attribute.
App\Entity\TypeProduitConditionnement	No errors.
App\Entity\TypeProduitPhoto	No errors.
App\Entity\ComandeProduit	No errors.
App\Entity\CommandeNumerique	No errors.
App\Entity\BlogAttachement	No errors.
App\Entity\PanierProduit	No errors.
App\Entity\AttachementEtiquette	No errors.
App\Entity\Reversement	No errors.

Symfony Profiler

https://futur.5sur5sejour.fr/Parent/AccueilParent Return to referer URL

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping