| 1 |
0.20 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = 2;
|
| 2 |
0.84 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.resume AS resume_4, t0.accroche AS accroche_5, t0.code_sejour AS code_sejour_6, t0.nb_jours AS nb_jours_7, t0.nb_nuits AS nb_nuits_8, t0.nb_jours_activite AS nb_jours_activite_9, t0.vignette AS vignette_10, t0.img_principale AS img_principale_11, t0.fiche_technique_pdf AS fiche_technique_pdf_12, t0.mise_en_avant AS mise_en_avant_13, t0.publie AS publie_14, t0.prix_default AS prix_default_15, t0.montant_acompte AS montant_acompte_16, t0.pourcentage_acompte AS pourcentage_acompte_17, t0.stock_default AS stock_default_18, t0.coord_depart AS coord_depart_19, t0.coord_arrivee AS coord_arrivee_20, t0.niveau_id AS niveau_id_21 FROM sejour__sejour t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.resume AS resume_4, t0.accroche AS accroche_5, t0.code_sejour AS code_sejour_6, t0.nb_jours AS nb_jours_7, t0.nb_nuits AS nb_nuits_8, t0.nb_jours_activite AS nb_jours_activite_9, t0.vignette AS vignette_10, t0.img_principale AS img_principale_11, t0.fiche_technique_pdf AS fiche_technique_pdf_12, t0.mise_en_avant AS mise_en_avant_13, t0.publie AS publie_14, t0.prix_default AS prix_default_15, t0.montant_acompte AS montant_acompte_16, t0.pourcentage_acompte AS pourcentage_acompte_17, t0.stock_default AS stock_default_18, t0.coord_depart AS coord_depart_19, t0.coord_arrivee AS coord_arrivee_20, t0.niveau_id AS niveau_id_21 FROM sejour__sejour t0 WHERE t0.id = '34';
|
| 3 |
0.34 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.type AS type_3, t0.options AS options_4 FROM sejour__champ t0
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.type AS type_3, t0.options AS options_4 FROM sejour__champ t0;
|
| 4 |
0.34 ms |
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.sejour_id AS sejour_id_3, t0.champ_id AS champ_id_4 FROM sejour__champ_valeur t0 WHERE t0.sejour_id = ?
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.sejour_id AS sejour_id_3, t0.champ_id AS champ_id_4 FROM sejour__champ_valeur t0 WHERE t0.sejour_id = 34;
|
| 5 |
0.38 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__categorie t0 INNER JOIN sejour__sejour_categorie ON t0.id = sejour__sejour_categorie.categorie_id WHERE sejour__sejour_categorie.sejour_id = ?
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__categorie t0 INNER JOIN sejour__sejour_categorie ON t0.id = sejour__sejour_categorie.categorie_id WHERE sejour__sejour_categorie.sejour_id = 34;
|
| 6 |
0.35 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__activite t0 INNER JOIN sejour__sejour_activite ON t0.id = sejour__sejour_activite.activite_id WHERE sejour__sejour_activite.sejour_id = ?
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__activite t0 INNER JOIN sejour__sejour_activite ON t0.id = sejour__sejour_activite.activite_id WHERE sejour__sejour_activite.sejour_id = 34;
|
| 7 |
0.27 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__destination t0 INNER JOIN sejour__sejour_destination ON t0.id = sejour__sejour_destination.destination_id WHERE sejour__sejour_destination.sejour_id = ?
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__destination t0 INNER JOIN sejour__sejour_destination ON t0.id = sejour__sejour_destination.destination_id WHERE sejour__sejour_destination.sejour_id = 34;
|
| 8 |
0.28 ms |
SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.date_fin AS date_fin_3, t0.commentaire AS commentaire_4, t0.prix AS prix_5, t0.stock_initial AS stock_initial_6, t0.stock AS stock_7, t0.effectif_mini AS effectif_mini_8, t0.statut AS statut_9, t0.sejour_id AS sejour_id_10 FROM sejour__session t0 WHERE t0.sejour_id = ? ORDER BY t0.date_debut ASC
SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.date_fin AS date_fin_3, t0.commentaire AS commentaire_4, t0.prix AS prix_5, t0.stock_initial AS stock_initial_6, t0.stock AS stock_7, t0.effectif_mini AS effectif_mini_8, t0.statut AS statut_9, t0.sejour_id AS sejour_id_10 FROM sejour__session t0 WHERE t0.sejour_id = 34 ORDER BY t0.date_debut ASC;
|
| 9 |
0.25 ms |
SELECT s0_.id AS id_0, s0_.libelle AS libelle_1 FROM sejour__categorie s0_ ORDER BY s0_.libelle ASC
SELECT s0_.id AS id_0, s0_.libelle AS libelle_1 FROM sejour__categorie s0_ ORDER BY s0_.libelle ASC;
|
| 10 |
0.24 ms |
SELECT s0_.id AS id_0, s0_.libelle AS libelle_1 FROM sejour__niveau s0_ ORDER BY s0_.libelle ASC
SELECT s0_.id AS id_0, s0_.libelle AS libelle_1 FROM sejour__niveau s0_ ORDER BY s0_.libelle ASC;
|
| 11 |
0.12 ms |
SELECT s0_.id AS id_0, s0_.libelle AS libelle_1 FROM sejour__activite s0_ ORDER BY s0_.libelle ASC
SELECT s0_.id AS id_0, s0_.libelle AS libelle_1 FROM sejour__activite s0_ ORDER BY s0_.libelle ASC;
|
| 12 |
0.12 ms |
SELECT s0_.id AS id_0, s0_.libelle AS libelle_1 FROM sejour__destination s0_ ORDER BY s0_.libelle ASC
SELECT s0_.id AS id_0, s0_.libelle AS libelle_1 FROM sejour__destination s0_ ORDER BY s0_.libelle ASC;
|
| 13 |
1.41 ms |
SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.description AS description_2, s0_.resume AS resume_3, s0_.accroche AS accroche_4, s0_.code_sejour AS code_sejour_5, s0_.nb_jours AS nb_jours_6, s0_.nb_nuits AS nb_nuits_7, s0_.nb_jours_activite AS nb_jours_activite_8, s0_.vignette AS vignette_9, s0_.img_principale AS img_principale_10, s0_.fiche_technique_pdf AS fiche_technique_pdf_11, s0_.mise_en_avant AS mise_en_avant_12, s0_.publie AS publie_13, s0_.prix_default AS prix_default_14, s0_.montant_acompte AS montant_acompte_15, s0_.pourcentage_acompte AS pourcentage_acompte_16, s0_.stock_default AS stock_default_17, s0_.coord_depart AS coord_depart_18, s0_.coord_arrivee AS coord_arrivee_19, s0_.niveau_id AS niveau_id_20 FROM sejour__sejour s0_ ORDER BY s0_.nom ASC
SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.description AS description_2, s0_.resume AS resume_3, s0_.accroche AS accroche_4, s0_.code_sejour AS code_sejour_5, s0_.nb_jours AS nb_jours_6, s0_.nb_nuits AS nb_nuits_7, s0_.nb_jours_activite AS nb_jours_activite_8, s0_.vignette AS vignette_9, s0_.img_principale AS img_principale_10, s0_.fiche_technique_pdf AS fiche_technique_pdf_11, s0_.mise_en_avant AS mise_en_avant_12, s0_.publie AS publie_13, s0_.prix_default AS prix_default_14, s0_.montant_acompte AS montant_acompte_15, s0_.pourcentage_acompte AS pourcentage_acompte_16, s0_.stock_default AS stock_default_17, s0_.coord_depart AS coord_depart_18, s0_.coord_arrivee AS coord_arrivee_19, s0_.niveau_id AS niveau_id_20 FROM sejour__sejour s0_ ORDER BY s0_.nom ASC;
|
| 14 |
0.28 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.type AS type_4, t0.path AS path_5, t0.sejour_id AS sejour_id_6 FROM sejour__media t0 WHERE t0.sejour_id = ?
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.type AS type_4, t0.path AS path_5, t0.sejour_id AS sejour_id_6 FROM sejour__media t0 WHERE t0.sejour_id = 34;
|