Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

71 Database Queries

34 Different statements

78.89 ms Query time

14 Invalid entities

Queries

Group similar statements


SELECT t0.id AS id_1, t0.role AS role_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.date AS date_5, t0.url AS url_6, t0.statut AS statut_7 FROM notification t0 WHERE t0.url = ? LIMIT 1
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.route AS route_3, s0_.argument AS argument_4, s0_.path AS path_5 FROM seo s0_ WHERE s0_.path = ? ORDER BY s0_.id DESC
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.activites AS activites_3, s0_.updated_date AS updated_date_4, s0_.hebergement AS hebergement_5, s0_.is_active AS is_active_6, s0_.is_bientot AS is_bientot_7, s0_.is_objectif_zero_co2 AS is_objectif_zero_co2_8, s0_.position AS position_9, s0_.age_min AS age_min_10, s0_.age_max AS age_max_11, s0_.is_sejour_location AS is_sejour_location_12, s0_.is_sejour_court AS is_sejour_court_13, s0_.notre_avis AS notre_avis_14, s0_.tarifs AS tarifs_15, s0_.places_count AS places_count_16, s0_.legacy_id AS legacy_id_17, s0_.intro AS intro_18, s0_.price AS price_19, s0_.duree AS duree_20, s0_.encadrement AS encadrement_21, s0_.nombre AS nombre_22, s0_.duree_integer AS duree_integer_23, s0_.tranport AS tranport_24, s0_.transport AS transport_25, s0_.compris AS compris_26, s0_.noncompris AS noncompris_27, s0_.information_complementaire AS information_complementaire_28, s0_.url AS url_29, s0_.sejour_type AS sejour_type_30, s0_.video_link AS video_link_31, s0_.activites_fiche_sejour AS activites_fiche_sejour_32, s0_.lien_youtube AS lien_youtube_33, s0_.location_id AS location_id_34, s0_.tranche_age1_id AS tranche_age1_id_35, s0_.tranche_age2_id AS tranche_age2_id_36 FROM sejour s0_ WHERE s0_.url = ?
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.text AS text_2, a0_.link_label AS link_label_3, a0_.link_url AS link_url_4, a0_.alt_attribute AS alt_attribute_5, a0_.creation_date AS creation_date_6, a0_.updated_date AS updated_date_7, a0_.is_active AS is_active_8, a0_.is_une AS is_une_9, a0_.img AS img_10, a0_.legacy_id AS legacy_id_11, a0_.is_blog AS is_blog_12, a0_.type AS type_13, a0_.path AS path_14 FROM article a0_ WHERE a0_.path = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 WHERE t0.is_active = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.bottom_description AS bottom_description_3, t0.top_description AS top_description_4, t0.slug AS slug_5, t0.age AS age_6, t0.is_active AS is_active_7 FROM age t0 WHERE t0.is_active = ? ORDER BY t0.age ASC
SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.slug AS slug_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.flag AS flag_9 FROM country t0 WHERE t0.is_active = ? ORDER BY t0.position ASC, t0.title ASC
SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.code_gen AS code_gen_2, s0_.date_debut AS date_debut_3, s0_.date_fin AS date_fin_4, s0_.prix AS prix_5, s0_.place_dispo AS place_dispo_6, s0_.media_statut AS media_statut_7, s0_.last_update AS last_update_8, s0_.legacy_id AS legacy_id_9, s0_.override_places_dispos AS override_places_dispos_10, s0_.sejour_id AS sejour_id_11 FROM sejour_session s0_ WHERE s0_.date_debut > ? ORDER BY s0_.date_debut ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.activites AS activites_4, t0.updated_date AS updated_date_5, t0.hebergement AS hebergement_6, t0.is_active AS is_active_7, t0.is_bientot AS is_bientot_8, t0.is_objectif_zero_co2 AS is_objectif_zero_co2_9, t0.position AS position_10, t0.age_min AS age_min_11, t0.age_max AS age_max_12, t0.is_sejour_location AS is_sejour_location_13, t0.is_sejour_court AS is_sejour_court_14, t0.notre_avis AS notre_avis_15, t0.tarifs AS tarifs_16, t0.places_count AS places_count_17, t0.legacy_id AS legacy_id_18, t0.intro AS intro_19, t0.price AS price_20, t0.duree AS duree_21, t0.encadrement AS encadrement_22, t0.nombre AS nombre_23, t0.duree_integer AS duree_integer_24, t0.tranport AS tranport_25, t0.transport AS transport_26, t0.compris AS compris_27, t0.noncompris AS noncompris_28, t0.information_complementaire AS information_complementaire_29, t0.url AS url_30, t0.sejour_type AS sejour_type_31, t0.video_link AS video_link_32, t0.activites_fiche_sejour AS activites_fiche_sejour_33, t0.lien_youtube AS lien_youtube_34, t0.location_id AS location_id_35, t0.tranche_age1_id AS tranche_age1_id_36, t0.tranche_age2_id AS tranche_age2_id_37 FROM sejour t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT t0.id AS id_1, t0.title AS title_2, t0.bottom_description AS bottom_description_3, t0.top_description AS top_description_4, t0.is_active AS is_active_5, t0.slug AS slug_6 FROM ville_desservie t0 WHERE t0.is_active = ? ORDER BY t0.title ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.allowed_format AS allowed_format_3, t0.type AS type_4, t0.is_mandatory AS is_mandatory_5, t0.is_editable_by_director AS is_editable_by_director_6, t0.has_fill_in_process AS has_fill_in_process_7, t0.has_to_be_returned AS has_to_be_returned_8, t0.has_prio AS has_prio_9, t0.published_in AS published_in_10, t0.modele AS modele_11, t0.fields AS fields_12, t0.is_unique AS is_unique_13, t0.is_deletable AS is_deletable_14, t0.is_espace_parent AS is_espace_parent_15, t0.is_espace_directeur AS is_espace_directeur_16, t0.is_private AS is_private_17, t0.is_factory AS is_factory_18, t0.is_in_admin AS is_in_admin_19, t0.modele_entity AS modele_entity_20, t0.has_to_be_validate_by_admin AS has_to_be_validate_by_admin_21, t0.referent AS referent_22, t0.interval AS interval_23, t0.interaction_template_id AS interaction_template_id_24 FROM media_categorie t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.file_path AS file_path_4, t0.attributes AS attributes_5, t0.alt_attribute AS alt_attribute_6, t0.is_standalone AS is_standalone_7, t0.is_migrated AS is_migrated_8, t0.position AS position_9, t0.updated_date AS updated_date_10, t0.legacy_id AS legacy_id_11, t0.is_validated AS is_validated_12, t0.rejected_reason AS rejected_reason_13, t0.media_categorie_id AS media_categorie_id_14, t15.id AS id_16, t15.name AS name_17, t15.allowed_format AS allowed_format_18, t15.type AS type_19, t15.is_mandatory AS is_mandatory_20, t15.is_editable_by_director AS is_editable_by_director_21, t15.has_fill_in_process AS has_fill_in_process_22, t15.has_to_be_returned AS has_to_be_returned_23, t15.has_prio AS has_prio_24, t15.published_in AS published_in_25, t15.modele AS modele_26, t15.fields AS fields_27, t15.is_unique AS is_unique_28, t15.is_deletable AS is_deletable_29, t15.is_espace_parent AS is_espace_parent_30, t15.is_espace_directeur AS is_espace_directeur_31, t15.is_private AS is_private_32, t15.is_factory AS is_factory_33, t15.is_in_admin AS is_in_admin_34, t15.modele_entity AS modele_entity_35, t15.has_to_be_validate_by_admin AS has_to_be_validate_by_admin_36, t15.referent AS referent_37, t15.interval AS interval_38, t15.interaction_template_id AS interaction_template_id_39, t0.media_parent_id AS media_parent_id_40, t41.id AS id_42, t41.name AS name_43, t41.description AS description_44, t41.file_path AS file_path_45, t41.attributes AS attributes_46, t41.alt_attribute AS alt_attribute_47, t41.is_standalone AS is_standalone_48, t41.is_migrated AS is_migrated_49, t41.position AS position_50, t41.updated_date AS updated_date_51, t41.legacy_id AS legacy_id_52, t41.is_validated AS is_validated_53, t41.rejected_reason AS rejected_reason_54, t41.media_categorie_id AS media_categorie_id_55, t41.media_parent_id AS media_parent_id_56, t41.sejour_id AS sejour_id_57, t41.candidature_id AS candidature_id_58, t41.contact_id AS contact_id_59, t41.sejour_session_id AS sejour_session_id_60, t41.inscription_id AS inscription_id_61, t41.saison_id AS saison_id_62, t0.sejour_id AS sejour_id_63, t0.candidature_id AS candidature_id_64, t0.contact_id AS contact_id_65, t0.sejour_session_id AS sejour_session_id_66, t0.inscription_id AS inscription_id_67, t0.saison_id AS saison_id_68 FROM media t0 INNER JOIN media_categorie t15 ON t0.media_categorie_id = t15.id LEFT JOIN media t41 ON t0.media_parent_id = t41.id WHERE t0.media_categorie_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.top_description AS top_description_3, t0.bottom_description AS bottom_description_4, t0.is_active AS is_active_5, t0.legacy_id AS legacy_id_6, t0.slug AS slug_7, t0.is_activite AS is_activite_8 FROM theme t0 WHERE t0.is_activite = ? AND t0.is_active = ? ORDER BY t0.title ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.top_description AS top_description_3, t0.bottom_description AS bottom_description_4, t0.is_active AS is_active_5, t0.legacy_id AS legacy_id_6, t0.slug AS slug_7, t0.is_activite AS is_activite_8 FROM theme t0 WHERE t0.is_activite = ? AND t0.is_active = ? ORDER BY t0.title ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.link_label AS link_label_4, t0.link_url AS link_url_5, t0.alt_attribute AS alt_attribute_6, t0.creation_date AS creation_date_7, t0.updated_date AS updated_date_8, t0.is_active AS is_active_9, t0.is_une AS is_une_10, t0.img AS img_11, t0.legacy_id AS legacy_id_12, t0.is_blog AS is_blog_13, t0.type AS type_14, t0.path AS path_15 FROM article t0 WHERE t0.is_une = ? ORDER BY t0.creation_date DESC LIMIT 1
SELECT t0.id AS id_1, t0.role AS role_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.date AS date_5, t0.url AS url_6, t0.statut AS statut_7 FROM notification t0 WHERE t0.statut = ? ORDER BY t0.date DESC LIMIT 10
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 WHERE t0.title IN (?) LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.top_description AS top_description_3, t0.bottom_description AS bottom_description_4, t0.is_active AS is_active_5, t0.legacy_id AS legacy_id_6, t0.slug AS slug_7, t0.is_activite AS is_activite_8 FROM theme t0 WHERE t0.slug IN (?) AND t0.is_activite = ? LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.top_description AS top_description_3, t0.bottom_description AS bottom_description_4, t0.is_active AS is_active_5, t0.legacy_id AS legacy_id_6, t0.slug AS slug_7, t0.is_activite AS is_activite_8 FROM theme t0 WHERE t0.slug IN (?) AND t0.is_activite = ? LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.bottom_description AS bottom_description_3, t0.top_description AS top_description_4, t0.slug AS slug_5, t0.age AS age_6, t0.is_active AS is_active_7 FROM age t0 WHERE t0.slug IN (?) LIMIT 1
SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.slug AS slug_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.flag AS flag_9 FROM country t0 WHERE t0.slug IN (?) LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.bottom_description AS bottom_description_3, t0.top_description AS top_description_4, t0.is_active AS is_active_5, t0.slug AS slug_6 FROM ville_desservie t0 WHERE t0.slug IN (?) AND t0.is_active = ? LIMIT 1
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM sejour s0_ INNER JOIN sejour_session s1_ ON s0_.id = s1_.sejour_id INNER JOIN sejour_theme s3_ ON s0_.id = s3_.sejour_id INNER JOIN theme t2_ ON t2_.id = s3_.theme_id INNER JOIN sejour_theme s5_ ON s0_.id = s5_.sejour_id INNER JOIN theme t4_ ON t4_.id = s5_.theme_id INNER JOIN sejour_saison s7_ ON s0_.id = s7_.sejour_id INNER JOIN saison s6_ ON s6_.id = s7_.saison_id WHERE s6_.id = ? AND s0_.is_active = ?
SELECT DISTINCT s0_.id AS id_0, s0_.is_bientot AS is_bientot_1 FROM sejour s0_ INNER JOIN sejour_session s1_ ON s0_.id = s1_.sejour_id INNER JOIN sejour_theme s3_ ON s0_.id = s3_.sejour_id INNER JOIN theme t2_ ON t2_.id = s3_.theme_id INNER JOIN sejour_theme s5_ ON s0_.id = s5_.sejour_id INNER JOIN theme t4_ ON t4_.id = s5_.theme_id INNER JOIN sejour_saison s7_ ON s0_.id = s7_.sejour_id INNER JOIN saison s6_ ON s6_.id = s7_.saison_id WHERE s6_.id = ? AND s0_.is_active = ? ORDER BY s0_.is_bientot ASC LIMIT 11
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.activites AS activites_3, s0_.updated_date AS updated_date_4, s0_.hebergement AS hebergement_5, s0_.is_active AS is_active_6, s0_.is_bientot AS is_bientot_7, s0_.is_objectif_zero_co2 AS is_objectif_zero_co2_8, s0_.position AS position_9, s0_.age_min AS age_min_10, s0_.age_max AS age_max_11, s0_.is_sejour_location AS is_sejour_location_12, s0_.is_sejour_court AS is_sejour_court_13, s0_.notre_avis AS notre_avis_14, s0_.tarifs AS tarifs_15, s0_.places_count AS places_count_16, s0_.legacy_id AS legacy_id_17, s0_.intro AS intro_18, s0_.price AS price_19, s0_.duree AS duree_20, s0_.encadrement AS encadrement_21, s0_.nombre AS nombre_22, s0_.duree_integer AS duree_integer_23, s0_.tranport AS tranport_24, s0_.transport AS transport_25, s0_.compris AS compris_26, s0_.noncompris AS noncompris_27, s0_.information_complementaire AS information_complementaire_28, s0_.url AS url_29, s0_.sejour_type AS sejour_type_30, s0_.video_link AS video_link_31, s0_.activites_fiche_sejour AS activites_fiche_sejour_32, s0_.lien_youtube AS lien_youtube_33, s0_.location_id AS location_id_34, s0_.tranche_age1_id AS tranche_age1_id_35, s0_.tranche_age2_id AS tranche_age2_id_36 FROM sejour s0_ INNER JOIN sejour_session s1_ ON s0_.id = s1_.sejour_id INNER JOIN sejour_theme s3_ ON s0_.id = s3_.sejour_id INNER JOIN theme t2_ ON t2_.id = s3_.theme_id INNER JOIN sejour_theme s5_ ON s0_.id = s5_.sejour_id INNER JOIN theme t4_ ON t4_.id = s5_.theme_id INNER JOIN sejour_saison s7_ ON s0_.id = s7_.sejour_id INNER JOIN saison s6_ ON s6_.id = s7_.saison_id WHERE s6_.id = ? AND s0_.is_active = ? AND s0_.id IN (?, ?, ?) ORDER BY s0_.is_bientot ASC
SELECT t0.id AS id_1, t0.code AS code_2, t0.code_gen AS code_gen_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.prix AS prix_6, t0.place_dispo AS place_dispo_7, t0.media_statut AS media_statut_8, t0.last_update AS last_update_9, t0.legacy_id AS legacy_id_10, t0.override_places_dispos AS override_places_dispos_11, t0.sejour_id AS sejour_id_12, t13.id AS id_14, t13.title AS title_15, t13.description AS description_16, t13.activites AS activites_17, t13.updated_date AS updated_date_18, t13.hebergement AS hebergement_19, t13.is_active AS is_active_20, t13.is_bientot AS is_bientot_21, t13.is_objectif_zero_co2 AS is_objectif_zero_co2_22, t13.position AS position_23, t13.age_min AS age_min_24, t13.age_max AS age_max_25, t13.is_sejour_location AS is_sejour_location_26, t13.is_sejour_court AS is_sejour_court_27, t13.notre_avis AS notre_avis_28, t13.tarifs AS tarifs_29, t13.places_count AS places_count_30, t13.legacy_id AS legacy_id_31, t13.intro AS intro_32, t13.price AS price_33, t13.duree AS duree_34, t13.encadrement AS encadrement_35, t13.nombre AS nombre_36, t13.duree_integer AS duree_integer_37, t13.tranport AS tranport_38, t13.transport AS transport_39, t13.compris AS compris_40, t13.noncompris AS noncompris_41, t13.information_complementaire AS information_complementaire_42, t13.url AS url_43, t13.sejour_type AS sejour_type_44, t13.video_link AS video_link_45, t13.activites_fiche_sejour AS activites_fiche_sejour_46, t13.lien_youtube AS lien_youtube_47, t13.location_id AS location_id_48, t13.tranche_age1_id AS tranche_age1_id_49, t13.tranche_age2_id AS tranche_age2_id_50 FROM sejour_session t0 INNER JOIN sejour t13 ON t0.sejour_id = t13.id WHERE t0.sejour_id = ? ORDER BY t0.date_debut ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.file_path AS file_path_4, t0.attributes AS attributes_5, t0.alt_attribute AS alt_attribute_6, t0.is_standalone AS is_standalone_7, t0.is_migrated AS is_migrated_8, t0.position AS position_9, t0.updated_date AS updated_date_10, t0.legacy_id AS legacy_id_11, t0.is_validated AS is_validated_12, t0.rejected_reason AS rejected_reason_13, t0.media_categorie_id AS media_categorie_id_14, t15.id AS id_16, t15.name AS name_17, t15.allowed_format AS allowed_format_18, t15.type AS type_19, t15.is_mandatory AS is_mandatory_20, t15.is_editable_by_director AS is_editable_by_director_21, t15.has_fill_in_process AS has_fill_in_process_22, t15.has_to_be_returned AS has_to_be_returned_23, t15.has_prio AS has_prio_24, t15.published_in AS published_in_25, t15.modele AS modele_26, t15.fields AS fields_27, t15.is_unique AS is_unique_28, t15.is_deletable AS is_deletable_29, t15.is_espace_parent AS is_espace_parent_30, t15.is_espace_directeur AS is_espace_directeur_31, t15.is_private AS is_private_32, t15.is_factory AS is_factory_33, t15.is_in_admin AS is_in_admin_34, t15.modele_entity AS modele_entity_35, t15.has_to_be_validate_by_admin AS has_to_be_validate_by_admin_36, t15.referent AS referent_37, t15.interval AS interval_38, t15.interaction_template_id AS interaction_template_id_39, t0.media_parent_id AS media_parent_id_40, t41.id AS id_42, t41.name AS name_43, t41.description AS description_44, t41.file_path AS file_path_45, t41.attributes AS attributes_46, t41.alt_attribute AS alt_attribute_47, t41.is_standalone AS is_standalone_48, t41.is_migrated AS is_migrated_49, t41.position AS position_50, t41.updated_date AS updated_date_51, t41.legacy_id AS legacy_id_52, t41.is_validated AS is_validated_53, t41.rejected_reason AS rejected_reason_54, t41.media_categorie_id AS media_categorie_id_55, t41.media_parent_id AS media_parent_id_56, t41.sejour_id AS sejour_id_57, t41.candidature_id AS candidature_id_58, t41.contact_id AS contact_id_59, t41.sejour_session_id AS sejour_session_id_60, t41.inscription_id AS inscription_id_61, t41.saison_id AS saison_id_62, t0.sejour_id AS sejour_id_63, t0.candidature_id AS candidature_id_64, t0.contact_id AS contact_id_65, t0.sejour_session_id AS sejour_session_id_66, t0.inscription_id AS inscription_id_67, t0.saison_id AS saison_id_68 FROM media t0 INNER JOIN media_categorie t15 ON t0.media_categorie_id = t15.id LEFT JOIN media t41 ON t0.media_parent_id = t41.id WHERE t0.sejour_id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.code_gen AS code_gen_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.prix AS prix_6, t0.place_dispo AS place_dispo_7, t0.media_statut AS media_statut_8, t0.last_update AS last_update_9, t0.legacy_id AS legacy_id_10, t0.override_places_dispos AS override_places_dispos_11, t0.sejour_id AS sejour_id_12, t13.id AS id_14, t13.title AS title_15, t13.description AS description_16, t13.activites AS activites_17, t13.updated_date AS updated_date_18, t13.hebergement AS hebergement_19, t13.is_active AS is_active_20, t13.is_bientot AS is_bientot_21, t13.is_objectif_zero_co2 AS is_objectif_zero_co2_22, t13.position AS position_23, t13.age_min AS age_min_24, t13.age_max AS age_max_25, t13.is_sejour_location AS is_sejour_location_26, t13.is_sejour_court AS is_sejour_court_27, t13.notre_avis AS notre_avis_28, t13.tarifs AS tarifs_29, t13.places_count AS places_count_30, t13.legacy_id AS legacy_id_31, t13.intro AS intro_32, t13.price AS price_33, t13.duree AS duree_34, t13.encadrement AS encadrement_35, t13.nombre AS nombre_36, t13.duree_integer AS duree_integer_37, t13.tranport AS tranport_38, t13.transport AS transport_39, t13.compris AS compris_40, t13.noncompris AS noncompris_41, t13.information_complementaire AS information_complementaire_42, t13.url AS url_43, t13.sejour_type AS sejour_type_44, t13.video_link AS video_link_45, t13.activites_fiche_sejour AS activites_fiche_sejour_46, t13.lien_youtube AS lien_youtube_47, t13.location_id AS location_id_48, t13.tranche_age1_id AS tranche_age1_id_49, t13.tranche_age2_id AS tranche_age2_id_50 FROM sejour_session t0 INNER JOIN sejour t13 ON t0.sejour_id = t13.id WHERE t0.sejour_id = ? ORDER BY t0.date_debut ASC
SELECT t0.id AS id_1, t0.code AS code_2, t0.code_gen AS code_gen_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.prix AS prix_6, t0.place_dispo AS place_dispo_7, t0.media_statut AS media_statut_8, t0.last_update AS last_update_9, t0.legacy_id AS legacy_id_10, t0.override_places_dispos AS override_places_dispos_11, t0.sejour_id AS sejour_id_12, t13.id AS id_14, t13.title AS title_15, t13.description AS description_16, t13.activites AS activites_17, t13.updated_date AS updated_date_18, t13.hebergement AS hebergement_19, t13.is_active AS is_active_20, t13.is_bientot AS is_bientot_21, t13.is_objectif_zero_co2 AS is_objectif_zero_co2_22, t13.position AS position_23, t13.age_min AS age_min_24, t13.age_max AS age_max_25, t13.is_sejour_location AS is_sejour_location_26, t13.is_sejour_court AS is_sejour_court_27, t13.notre_avis AS notre_avis_28, t13.tarifs AS tarifs_29, t13.places_count AS places_count_30, t13.legacy_id AS legacy_id_31, t13.intro AS intro_32, t13.price AS price_33, t13.duree AS duree_34, t13.encadrement AS encadrement_35, t13.nombre AS nombre_36, t13.duree_integer AS duree_integer_37, t13.tranport AS tranport_38, t13.transport AS transport_39, t13.compris AS compris_40, t13.noncompris AS noncompris_41, t13.information_complementaire AS information_complementaire_42, t13.url AS url_43, t13.sejour_type AS sejour_type_44, t13.video_link AS video_link_45, t13.activites_fiche_sejour AS activites_fiche_sejour_46, t13.lien_youtube AS lien_youtube_47, t13.location_id AS location_id_48, t13.tranche_age1_id AS tranche_age1_id_49, t13.tranche_age2_id AS tranche_age2_id_50 FROM sejour_session t0 INNER JOIN sejour t13 ON t0.sejour_id = t13.id WHERE t0.sejour_id = ? ORDER BY t0.date_debut ASC
SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ?
SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ?
SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ?
SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ?
SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ?
SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 INNER JOIN sejour_saison ON t0.id = sejour_saison.saison_id WHERE sejour_saison.sejour_id = ?
SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.slug AS slug_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.flag AS flag_9 FROM country t0 INNER JOIN sejour_country ON t0.id = sejour_country.country_id WHERE sejour_country.sejour_id = ?
SELECT t0.id AS id_1, t0.street AS street_2, t0.zip_code AS zip_code_3, t0.city AS city_4, t0.house_number AS house_number_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.country AS country_8, t0.title AS title_9, t0.telephone AS telephone_10, t11.id AS id_12, t11.title AS title_13, t11.description AS description_14, t11.activites AS activites_15, t11.updated_date AS updated_date_16, t11.hebergement AS hebergement_17, t11.is_active AS is_active_18, t11.is_bientot AS is_bientot_19, t11.is_objectif_zero_co2 AS is_objectif_zero_co2_20, t11.position AS position_21, t11.age_min AS age_min_22, t11.age_max AS age_max_23, t11.is_sejour_location AS is_sejour_location_24, t11.is_sejour_court AS is_sejour_court_25, t11.notre_avis AS notre_avis_26, t11.tarifs AS tarifs_27, t11.places_count AS places_count_28, t11.legacy_id AS legacy_id_29, t11.intro AS intro_30, t11.price AS price_31, t11.duree AS duree_32, t11.encadrement AS encadrement_33, t11.nombre AS nombre_34, t11.duree_integer AS duree_integer_35, t11.tranport AS tranport_36, t11.transport AS transport_37, t11.compris AS compris_38, t11.noncompris AS noncompris_39, t11.information_complementaire AS information_complementaire_40, t11.url AS url_41, t11.sejour_type AS sejour_type_42, t11.video_link AS video_link_43, t11.activites_fiche_sejour AS activites_fiche_sejour_44, t11.lien_youtube AS lien_youtube_45, t11.location_id AS location_id_46, t11.tranche_age1_id AS tranche_age1_id_47, t11.tranche_age2_id AS tranche_age2_id_48, t0.departement_id AS departement_id_49 FROM location t0 LEFT JOIN sejour t11 ON t11.location_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.country_id AS country_id_4, t0.media_id AS media_id_5 FROM departement t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.file_path AS file_path_4, t0.attributes AS attributes_5, t0.alt_attribute AS alt_attribute_6, t0.is_standalone AS is_standalone_7, t0.is_migrated AS is_migrated_8, t0.position AS position_9, t0.updated_date AS updated_date_10, t0.legacy_id AS legacy_id_11, t0.is_validated AS is_validated_12, t0.rejected_reason AS rejected_reason_13, t0.media_categorie_id AS media_categorie_id_14, t15.id AS id_16, t15.name AS name_17, t15.allowed_format AS allowed_format_18, t15.type AS type_19, t15.is_mandatory AS is_mandatory_20, t15.is_editable_by_director AS is_editable_by_director_21, t15.has_fill_in_process AS has_fill_in_process_22, t15.has_to_be_returned AS has_to_be_returned_23, t15.has_prio AS has_prio_24, t15.published_in AS published_in_25, t15.modele AS modele_26, t15.fields AS fields_27, t15.is_unique AS is_unique_28, t15.is_deletable AS is_deletable_29, t15.is_espace_parent AS is_espace_parent_30, t15.is_espace_directeur AS is_espace_directeur_31, t15.is_private AS is_private_32, t15.is_factory AS is_factory_33, t15.is_in_admin AS is_in_admin_34, t15.modele_entity AS modele_entity_35, t15.has_to_be_validate_by_admin AS has_to_be_validate_by_admin_36, t15.referent AS referent_37, t15.interval AS interval_38, t15.interaction_template_id AS interaction_template_id_39, t0.media_parent_id AS media_parent_id_40, t41.id AS id_42, t41.name AS name_43, t41.description AS description_44, t41.file_path AS file_path_45, t41.attributes AS attributes_46, t41.alt_attribute AS alt_attribute_47, t41.is_standalone AS is_standalone_48, t41.is_migrated AS is_migrated_49, t41.position AS position_50, t41.updated_date AS updated_date_51, t41.legacy_id AS legacy_id_52, t41.is_validated AS is_validated_53, t41.rejected_reason AS rejected_reason_54, t41.media_categorie_id AS media_categorie_id_55, t41.media_parent_id AS media_parent_id_56, t41.sejour_id AS sejour_id_57, t41.candidature_id AS candidature_id_58, t41.contact_id AS contact_id_59, t41.sejour_session_id AS sejour_session_id_60, t41.inscription_id AS inscription_id_61, t41.saison_id AS saison_id_62, t0.sejour_id AS sejour_id_63, t0.candidature_id AS candidature_id_64, t0.contact_id AS contact_id_65, t0.sejour_session_id AS sejour_session_id_66, t0.inscription_id AS inscription_id_67, t0.saison_id AS saison_id_68 FROM media t0 INNER JOIN media_categorie t15 ON t0.media_categorie_id = t15.id LEFT JOIN media t41 ON t0.media_parent_id = t41.id WHERE t0.sejour_id = ?
SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ?
SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ?
SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ?
SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ?
SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ?
SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 INNER JOIN sejour_saison ON t0.id = sejour_saison.saison_id WHERE sejour_saison.sejour_id = ?
SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.slug AS slug_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.flag AS flag_9 FROM country t0 INNER JOIN sejour_country ON t0.id = sejour_country.country_id WHERE sejour_country.sejour_id = ?
SELECT t0.id AS id_1, t0.street AS street_2, t0.zip_code AS zip_code_3, t0.city AS city_4, t0.house_number AS house_number_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.country AS country_8, t0.title AS title_9, t0.telephone AS telephone_10, t11.id AS id_12, t11.title AS title_13, t11.description AS description_14, t11.activites AS activites_15, t11.updated_date AS updated_date_16, t11.hebergement AS hebergement_17, t11.is_active AS is_active_18, t11.is_bientot AS is_bientot_19, t11.is_objectif_zero_co2 AS is_objectif_zero_co2_20, t11.position AS position_21, t11.age_min AS age_min_22, t11.age_max AS age_max_23, t11.is_sejour_location AS is_sejour_location_24, t11.is_sejour_court AS is_sejour_court_25, t11.notre_avis AS notre_avis_26, t11.tarifs AS tarifs_27, t11.places_count AS places_count_28, t11.legacy_id AS legacy_id_29, t11.intro AS intro_30, t11.price AS price_31, t11.duree AS duree_32, t11.encadrement AS encadrement_33, t11.nombre AS nombre_34, t11.duree_integer AS duree_integer_35, t11.tranport AS tranport_36, t11.transport AS transport_37, t11.compris AS compris_38, t11.noncompris AS noncompris_39, t11.information_complementaire AS information_complementaire_40, t11.url AS url_41, t11.sejour_type AS sejour_type_42, t11.video_link AS video_link_43, t11.activites_fiche_sejour AS activites_fiche_sejour_44, t11.lien_youtube AS lien_youtube_45, t11.location_id AS location_id_46, t11.tranche_age1_id AS tranche_age1_id_47, t11.tranche_age2_id AS tranche_age2_id_48, t0.departement_id AS departement_id_49 FROM location t0 LEFT JOIN sejour t11 ON t11.location_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.file_path AS file_path_4, t0.attributes AS attributes_5, t0.alt_attribute AS alt_attribute_6, t0.is_standalone AS is_standalone_7, t0.is_migrated AS is_migrated_8, t0.position AS position_9, t0.updated_date AS updated_date_10, t0.legacy_id AS legacy_id_11, t0.is_validated AS is_validated_12, t0.rejected_reason AS rejected_reason_13, t0.media_categorie_id AS media_categorie_id_14, t15.id AS id_16, t15.name AS name_17, t15.allowed_format AS allowed_format_18, t15.type AS type_19, t15.is_mandatory AS is_mandatory_20, t15.is_editable_by_director AS is_editable_by_director_21, t15.has_fill_in_process AS has_fill_in_process_22, t15.has_to_be_returned AS has_to_be_returned_23, t15.has_prio AS has_prio_24, t15.published_in AS published_in_25, t15.modele AS modele_26, t15.fields AS fields_27, t15.is_unique AS is_unique_28, t15.is_deletable AS is_deletable_29, t15.is_espace_parent AS is_espace_parent_30, t15.is_espace_directeur AS is_espace_directeur_31, t15.is_private AS is_private_32, t15.is_factory AS is_factory_33, t15.is_in_admin AS is_in_admin_34, t15.modele_entity AS modele_entity_35, t15.has_to_be_validate_by_admin AS has_to_be_validate_by_admin_36, t15.referent AS referent_37, t15.interval AS interval_38, t15.interaction_template_id AS interaction_template_id_39, t0.media_parent_id AS media_parent_id_40, t41.id AS id_42, t41.name AS name_43, t41.description AS description_44, t41.file_path AS file_path_45, t41.attributes AS attributes_46, t41.alt_attribute AS alt_attribute_47, t41.is_standalone AS is_standalone_48, t41.is_migrated AS is_migrated_49, t41.position AS position_50, t41.updated_date AS updated_date_51, t41.legacy_id AS legacy_id_52, t41.is_validated AS is_validated_53, t41.rejected_reason AS rejected_reason_54, t41.media_categorie_id AS media_categorie_id_55, t41.media_parent_id AS media_parent_id_56, t41.sejour_id AS sejour_id_57, t41.candidature_id AS candidature_id_58, t41.contact_id AS contact_id_59, t41.sejour_session_id AS sejour_session_id_60, t41.inscription_id AS inscription_id_61, t41.saison_id AS saison_id_62, t0.sejour_id AS sejour_id_63, t0.candidature_id AS candidature_id_64, t0.contact_id AS contact_id_65, t0.sejour_session_id AS sejour_session_id_66, t0.inscription_id AS inscription_id_67, t0.saison_id AS saison_id_68 FROM media t0 INNER JOIN media_categorie t15 ON t0.media_categorie_id = t15.id LEFT JOIN media t41 ON t0.media_parent_id = t41.id WHERE t0.sejour_id = ?
SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ?
SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ?
SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ?
SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ?
SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.enterprise_option_sejour_session_id = ?
SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ?
SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 INNER JOIN sejour_saison ON t0.id = sejour_saison.saison_id WHERE sejour_saison.sejour_id = ?
SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.slug AS slug_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.flag AS flag_9 FROM country t0 INNER JOIN sejour_country ON t0.id = sejour_country.country_id WHERE sejour_country.sejour_id = ?
SELECT t0.id AS id_1, t0.street AS street_2, t0.zip_code AS zip_code_3, t0.city AS city_4, t0.house_number AS house_number_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.country AS country_8, t0.title AS title_9, t0.telephone AS telephone_10, t11.id AS id_12, t11.title AS title_13, t11.description AS description_14, t11.activites AS activites_15, t11.updated_date AS updated_date_16, t11.hebergement AS hebergement_17, t11.is_active AS is_active_18, t11.is_bientot AS is_bientot_19, t11.is_objectif_zero_co2 AS is_objectif_zero_co2_20, t11.position AS position_21, t11.age_min AS age_min_22, t11.age_max AS age_max_23, t11.is_sejour_location AS is_sejour_location_24, t11.is_sejour_court AS is_sejour_court_25, t11.notre_avis AS notre_avis_26, t11.tarifs AS tarifs_27, t11.places_count AS places_count_28, t11.legacy_id AS legacy_id_29, t11.intro AS intro_30, t11.price AS price_31, t11.duree AS duree_32, t11.encadrement AS encadrement_33, t11.nombre AS nombre_34, t11.duree_integer AS duree_integer_35, t11.tranport AS tranport_36, t11.transport AS transport_37, t11.compris AS compris_38, t11.noncompris AS noncompris_39, t11.information_complementaire AS information_complementaire_40, t11.url AS url_41, t11.sejour_type AS sejour_type_42, t11.video_link AS video_link_43, t11.activites_fiche_sejour AS activites_fiche_sejour_44, t11.lien_youtube AS lien_youtube_45, t11.location_id AS location_id_46, t11.tranche_age1_id AS tranche_age1_id_47, t11.tranche_age2_id AS tranche_age2_id_48, t0.departement_id AS departement_id_49 FROM location t0 LEFT JOIN sejour t11 ON t11.location_id = t0.id WHERE t0.id = ?

#▲	Time	Info
1	11.43 ms	SELECT t0.id AS id_1, t0.role AS role_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.date AS date_5, t0.url AS url_6, t0.statut AS statut_7 FROM notification t0 WHERE t0.url = ? LIMIT 1 Parameters: [`"/colonie-de-vacances/hiver"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.role AS role_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.date AS date_5, t0.url AS url_6, t0.statut AS statut_7 FROM notification t0 WHERE t0.url = ? LIMIT 1 SELECT t0.id AS id_1, t0.role AS role_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.date AS date_5, t0.url AS url_6, t0.statut AS statut_7 FROM notification t0 WHERE t0.url = '/colonie-de-vacances/hiver' LIMIT 1;
2	0.78 ms	SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.route AS route_3, s0_.argument AS argument_4, s0_.path AS path_5 FROM seo s0_ WHERE s0_.path = ? ORDER BY s0_.id DESC Parameters: [`"/colonie-de-vacances/hiver"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.route AS route_3, s0_.argument AS argument_4, s0_.path AS path_5 FROM seo s0_ WHERE s0_.path = ? ORDER BY s0_.id DESC SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.route AS route_3, s0_.argument AS argument_4, s0_.path AS path_5 FROM seo s0_ WHERE s0_.path = '/colonie-de-vacances/hiver' ORDER BY s0_.id DESC;
3	1.11 ms	SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.activites AS activites_3, s0_.updated_date AS updated_date_4, s0_.hebergement AS hebergement_5, s0_.is_active AS is_active_6, s0_.is_bientot AS is_bientot_7, s0_.is_objectif_zero_co2 AS is_objectif_zero_co2_8, s0_.position AS position_9, s0_.age_min AS age_min_10, s0_.age_max AS age_max_11, s0_.is_sejour_location AS is_sejour_location_12, s0_.is_sejour_court AS is_sejour_court_13, s0_.notre_avis AS notre_avis_14, s0_.tarifs AS tarifs_15, s0_.places_count AS places_count_16, s0_.legacy_id AS legacy_id_17, s0_.intro AS intro_18, s0_.price AS price_19, s0_.duree AS duree_20, s0_.encadrement AS encadrement_21, s0_.nombre AS nombre_22, s0_.duree_integer AS duree_integer_23, s0_.tranport AS tranport_24, s0_.transport AS transport_25, s0_.compris AS compris_26, s0_.noncompris AS noncompris_27, s0_.information_complementaire AS information_complementaire_28, s0_.url AS url_29, s0_.sejour_type AS sejour_type_30, s0_.video_link AS video_link_31, s0_.activites_fiche_sejour AS activites_fiche_sejour_32, s0_.lien_youtube AS lien_youtube_33, s0_.location_id AS location_id_34, s0_.tranche_age1_id AS tranche_age1_id_35, s0_.tranche_age2_id AS tranche_age2_id_36 FROM sejour s0_ WHERE s0_.url = ? Parameters: [`"/colonie-de-vacances/hiver"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.activites AS activites_3, s0_.updated_date AS updated_date_4, s0_.hebergement AS hebergement_5, s0_.is_active AS is_active_6, s0_.is_bientot AS is_bientot_7, s0_.is_objectif_zero_co2 AS is_objectif_zero_co2_8, s0_.position AS position_9, s0_.age_min AS age_min_10, s0_.age_max AS age_max_11, s0_.is_sejour_location AS is_sejour_location_12, s0_.is_sejour_court AS is_sejour_court_13, s0_.notre_avis AS notre_avis_14, s0_.tarifs AS tarifs_15, s0_.places_count AS places_count_16, s0_.legacy_id AS legacy_id_17, s0_.intro AS intro_18, s0_.price AS price_19, s0_.duree AS duree_20, s0_.encadrement AS encadrement_21, s0_.nombre AS nombre_22, s0_.duree_integer AS duree_integer_23, s0_.tranport AS tranport_24, s0_.transport AS transport_25, s0_.compris AS compris_26, s0_.noncompris AS noncompris_27, s0_.information_complementaire AS information_complementaire_28, s0_.url AS url_29, s0_.sejour_type AS sejour_type_30, s0_.video_link AS video_link_31, s0_.activites_fiche_sejour AS activites_fiche_sejour_32, s0_.lien_youtube AS lien_youtube_33, s0_.location_id AS location_id_34, s0_.tranche_age1_id AS tranche_age1_id_35, s0_.tranche_age2_id AS tranche_age2_id_36 FROM sejour s0_ WHERE s0_.url = ? SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.activites AS activites_3, s0_.updated_date AS updated_date_4, s0_.hebergement AS hebergement_5, s0_.is_active AS is_active_6, s0_.is_bientot AS is_bientot_7, s0_.is_objectif_zero_co2 AS is_objectif_zero_co2_8, s0_.position AS position_9, s0_.age_min AS age_min_10, s0_.age_max AS age_max_11, s0_.is_sejour_location AS is_sejour_location_12, s0_.is_sejour_court AS is_sejour_court_13, s0_.notre_avis AS notre_avis_14, s0_.tarifs AS tarifs_15, s0_.places_count AS places_count_16, s0_.legacy_id AS legacy_id_17, s0_.intro AS intro_18, s0_.price AS price_19, s0_.duree AS duree_20, s0_.encadrement AS encadrement_21, s0_.nombre AS nombre_22, s0_.duree_integer AS duree_integer_23, s0_.tranport AS tranport_24, s0_.transport AS transport_25, s0_.compris AS compris_26, s0_.noncompris AS noncompris_27, s0_.information_complementaire AS information_complementaire_28, s0_.url AS url_29, s0_.sejour_type AS sejour_type_30, s0_.video_link AS video_link_31, s0_.activites_fiche_sejour AS activites_fiche_sejour_32, s0_.lien_youtube AS lien_youtube_33, s0_.location_id AS location_id_34, s0_.tranche_age1_id AS tranche_age1_id_35, s0_.tranche_age2_id AS tranche_age2_id_36 FROM sejour s0_ WHERE s0_.url = '/colonie-de-vacances/hiver';
4	1.88 ms	SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.text AS text_2, a0_.link_label AS link_label_3, a0_.link_url AS link_url_4, a0_.alt_attribute AS alt_attribute_5, a0_.creation_date AS creation_date_6, a0_.updated_date AS updated_date_7, a0_.is_active AS is_active_8, a0_.is_une AS is_une_9, a0_.img AS img_10, a0_.legacy_id AS legacy_id_11, a0_.is_blog AS is_blog_12, a0_.type AS type_13, a0_.path AS path_14 FROM article a0_ WHERE a0_.path = ? Parameters: [`"/colonie-de-vacances/hiver"`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.text AS text_2, a0_.link_label AS link_label_3, a0_.link_url AS link_url_4, a0_.alt_attribute AS alt_attribute_5, a0_.creation_date AS creation_date_6, a0_.updated_date AS updated_date_7, a0_.is_active AS is_active_8, a0_.is_une AS is_une_9, a0_.img AS img_10, a0_.legacy_id AS legacy_id_11, a0_.is_blog AS is_blog_12, a0_.type AS type_13, a0_.path AS path_14 FROM article a0_ WHERE a0_.path = ? SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.text AS text_2, a0_.link_label AS link_label_3, a0_.link_url AS link_url_4, a0_.alt_attribute AS alt_attribute_5, a0_.creation_date AS creation_date_6, a0_.updated_date AS updated_date_7, a0_.is_active AS is_active_8, a0_.is_une AS is_une_9, a0_.img AS img_10, a0_.legacy_id AS legacy_id_11, a0_.is_blog AS is_blog_12, a0_.type AS type_13, a0_.path AS path_14 FROM article a0_ WHERE a0_.path = '/colonie-de-vacances/hiver';
5	0.23 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"bannerOnline"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = 'bannerOnline' LIMIT 1;
6	0.32 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"banner"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = 'banner' LIMIT 1;
7	0.25 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 WHERE t0.is_active = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 WHERE t0.is_active = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 WHERE t0.is_active = 1;
8	0.29 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.bottom_description AS bottom_description_3, t0.top_description AS top_description_4, t0.slug AS slug_5, t0.age AS age_6, t0.is_active AS is_active_7 FROM age t0 WHERE t0.is_active = ? ORDER BY t0.age ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.bottom_description AS bottom_description_3, t0.top_description AS top_description_4, t0.slug AS slug_5, t0.age AS age_6, t0.is_active AS is_active_7 FROM age t0 WHERE t0.is_active = ? ORDER BY t0.age ASC SELECT t0.id AS id_1, t0.title AS title_2, t0.bottom_description AS bottom_description_3, t0.top_description AS top_description_4, t0.slug AS slug_5, t0.age AS age_6, t0.is_active AS is_active_7 FROM age t0 WHERE t0.is_active = 1 ORDER BY t0.age ASC;
9	0.98 ms	SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.slug AS slug_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.flag AS flag_9 FROM country t0 WHERE t0.is_active = ? ORDER BY t0.position ASC, t0.title ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.slug AS slug_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.flag AS flag_9 FROM country t0 WHERE t0.is_active = ? ORDER BY t0.position ASC, t0.title ASC SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.slug AS slug_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.flag AS flag_9 FROM country t0 WHERE t0.is_active = 1 ORDER BY t0.position ASC, t0.title ASC;
10	0.91 ms	SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.code_gen AS code_gen_2, s0_.date_debut AS date_debut_3, s0_.date_fin AS date_fin_4, s0_.prix AS prix_5, s0_.place_dispo AS place_dispo_6, s0_.media_statut AS media_statut_7, s0_.last_update AS last_update_8, s0_.legacy_id AS legacy_id_9, s0_.override_places_dispos AS override_places_dispos_10, s0_.sejour_id AS sejour_id_11 FROM sejour_session s0_ WHERE s0_.date_debut > ? ORDER BY s0_.date_debut ASC Parameters: [`"2025-10-26 07:56:52"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.code_gen AS code_gen_2, s0_.date_debut AS date_debut_3, s0_.date_fin AS date_fin_4, s0_.prix AS prix_5, s0_.place_dispo AS place_dispo_6, s0_.media_statut AS media_statut_7, s0_.last_update AS last_update_8, s0_.legacy_id AS legacy_id_9, s0_.override_places_dispos AS override_places_dispos_10, s0_.sejour_id AS sejour_id_11 FROM sejour_session s0_ WHERE s0_.date_debut > ? ORDER BY s0_.date_debut ASC SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.code_gen AS code_gen_2, s0_.date_debut AS date_debut_3, s0_.date_fin AS date_fin_4, s0_.prix AS prix_5, s0_.place_dispo AS place_dispo_6, s0_.media_statut AS media_statut_7, s0_.last_update AS last_update_8, s0_.legacy_id AS legacy_id_9, s0_.override_places_dispos AS override_places_dispos_10, s0_.sejour_id AS sejour_id_11 FROM sejour_session s0_ WHERE s0_.date_debut > '2025-10-26 07:56:52' ORDER BY s0_.date_debut ASC;
11	0.72 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.activites AS activites_4, t0.updated_date AS updated_date_5, t0.hebergement AS hebergement_6, t0.is_active AS is_active_7, t0.is_bientot AS is_bientot_8, t0.is_objectif_zero_co2 AS is_objectif_zero_co2_9, t0.position AS position_10, t0.age_min AS age_min_11, t0.age_max AS age_max_12, t0.is_sejour_location AS is_sejour_location_13, t0.is_sejour_court AS is_sejour_court_14, t0.notre_avis AS notre_avis_15, t0.tarifs AS tarifs_16, t0.places_count AS places_count_17, t0.legacy_id AS legacy_id_18, t0.intro AS intro_19, t0.price AS price_20, t0.duree AS duree_21, t0.encadrement AS encadrement_22, t0.nombre AS nombre_23, t0.duree_integer AS duree_integer_24, t0.tranport AS tranport_25, t0.transport AS transport_26, t0.compris AS compris_27, t0.noncompris AS noncompris_28, t0.information_complementaire AS information_complementaire_29, t0.url AS url_30, t0.sejour_type AS sejour_type_31, t0.video_link AS video_link_32, t0.activites_fiche_sejour AS activites_fiche_sejour_33, t0.lien_youtube AS lien_youtube_34, t0.location_id AS location_id_35, t0.tranche_age1_id AS tranche_age1_id_36, t0.tranche_age2_id AS tranche_age2_id_37 FROM sejour t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`68 136 137 280 279 8 11 278 220 215 272 209 273 217 275`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.activites AS activites_4, t0.updated_date AS updated_date_5, t0.hebergement AS hebergement_6, t0.is_active AS is_active_7, t0.is_bientot AS is_bientot_8, t0.is_objectif_zero_co2 AS is_objectif_zero_co2_9, t0.position AS position_10, t0.age_min AS age_min_11, t0.age_max AS age_max_12, t0.is_sejour_location AS is_sejour_location_13, t0.is_sejour_court AS is_sejour_court_14, t0.notre_avis AS notre_avis_15, t0.tarifs AS tarifs_16, t0.places_count AS places_count_17, t0.legacy_id AS legacy_id_18, t0.intro AS intro_19, t0.price AS price_20, t0.duree AS duree_21, t0.encadrement AS encadrement_22, t0.nombre AS nombre_23, t0.duree_integer AS duree_integer_24, t0.tranport AS tranport_25, t0.transport AS transport_26, t0.compris AS compris_27, t0.noncompris AS noncompris_28, t0.information_complementaire AS information_complementaire_29, t0.url AS url_30, t0.sejour_type AS sejour_type_31, t0.video_link AS video_link_32, t0.activites_fiche_sejour AS activites_fiche_sejour_33, t0.lien_youtube AS lien_youtube_34, t0.location_id AS location_id_35, t0.tranche_age1_id AS tranche_age1_id_36, t0.tranche_age2_id AS tranche_age2_id_37 FROM sejour t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.activites AS activites_4, t0.updated_date AS updated_date_5, t0.hebergement AS hebergement_6, t0.is_active AS is_active_7, t0.is_bientot AS is_bientot_8, t0.is_objectif_zero_co2 AS is_objectif_zero_co2_9, t0.position AS position_10, t0.age_min AS age_min_11, t0.age_max AS age_max_12, t0.is_sejour_location AS is_sejour_location_13, t0.is_sejour_court AS is_sejour_court_14, t0.notre_avis AS notre_avis_15, t0.tarifs AS tarifs_16, t0.places_count AS places_count_17, t0.legacy_id AS legacy_id_18, t0.intro AS intro_19, t0.price AS price_20, t0.duree AS duree_21, t0.encadrement AS encadrement_22, t0.nombre AS nombre_23, t0.duree_integer AS duree_integer_24, t0.tranport AS tranport_25, t0.transport AS transport_26, t0.compris AS compris_27, t0.noncompris AS noncompris_28, t0.information_complementaire AS information_complementaire_29, t0.url AS url_30, t0.sejour_type AS sejour_type_31, t0.video_link AS video_link_32, t0.activites_fiche_sejour AS activites_fiche_sejour_33, t0.lien_youtube AS lien_youtube_34, t0.location_id AS location_id_35, t0.tranche_age1_id AS tranche_age1_id_36, t0.tranche_age2_id AS tranche_age2_id_37 FROM sejour t0 WHERE t0.id IN (68, 136, 137, 280, 279, 8, 11, 278, 220, 215, 272, 209, 273, 217, 275);
12	0.46 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.bottom_description AS bottom_description_3, t0.top_description AS top_description_4, t0.is_active AS is_active_5, t0.slug AS slug_6 FROM ville_desservie t0 WHERE t0.is_active = ? ORDER BY t0.title ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.bottom_description AS bottom_description_3, t0.top_description AS top_description_4, t0.is_active AS is_active_5, t0.slug AS slug_6 FROM ville_desservie t0 WHERE t0.is_active = ? ORDER BY t0.title ASC SELECT t0.id AS id_1, t0.title AS title_2, t0.bottom_description AS bottom_description_3, t0.top_description AS top_description_4, t0.is_active AS is_active_5, t0.slug AS slug_6 FROM ville_desservie t0 WHERE t0.is_active = 1 ORDER BY t0.title ASC;
13	0.55 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.allowed_format AS allowed_format_3, t0.type AS type_4, t0.is_mandatory AS is_mandatory_5, t0.is_editable_by_director AS is_editable_by_director_6, t0.has_fill_in_process AS has_fill_in_process_7, t0.has_to_be_returned AS has_to_be_returned_8, t0.has_prio AS has_prio_9, t0.published_in AS published_in_10, t0.modele AS modele_11, t0.fields AS fields_12, t0.is_unique AS is_unique_13, t0.is_deletable AS is_deletable_14, t0.is_espace_parent AS is_espace_parent_15, t0.is_espace_directeur AS is_espace_directeur_16, t0.is_private AS is_private_17, t0.is_factory AS is_factory_18, t0.is_in_admin AS is_in_admin_19, t0.modele_entity AS modele_entity_20, t0.has_to_be_validate_by_admin AS has_to_be_validate_by_admin_21, t0.referent AS referent_22, t0.interval AS interval_23, t0.interaction_template_id AS interaction_template_id_24 FROM media_categorie t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"imageFond"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.allowed_format AS allowed_format_3, t0.type AS type_4, t0.is_mandatory AS is_mandatory_5, t0.is_editable_by_director AS is_editable_by_director_6, t0.has_fill_in_process AS has_fill_in_process_7, t0.has_to_be_returned AS has_to_be_returned_8, t0.has_prio AS has_prio_9, t0.published_in AS published_in_10, t0.modele AS modele_11, t0.fields AS fields_12, t0.is_unique AS is_unique_13, t0.is_deletable AS is_deletable_14, t0.is_espace_parent AS is_espace_parent_15, t0.is_espace_directeur AS is_espace_directeur_16, t0.is_private AS is_private_17, t0.is_factory AS is_factory_18, t0.is_in_admin AS is_in_admin_19, t0.modele_entity AS modele_entity_20, t0.has_to_be_validate_by_admin AS has_to_be_validate_by_admin_21, t0.referent AS referent_22, t0.interval AS interval_23, t0.interaction_template_id AS interaction_template_id_24 FROM media_categorie t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.allowed_format AS allowed_format_3, t0.type AS type_4, t0.is_mandatory AS is_mandatory_5, t0.is_editable_by_director AS is_editable_by_director_6, t0.has_fill_in_process AS has_fill_in_process_7, t0.has_to_be_returned AS has_to_be_returned_8, t0.has_prio AS has_prio_9, t0.published_in AS published_in_10, t0.modele AS modele_11, t0.fields AS fields_12, t0.is_unique AS is_unique_13, t0.is_deletable AS is_deletable_14, t0.is_espace_parent AS is_espace_parent_15, t0.is_espace_directeur AS is_espace_directeur_16, t0.is_private AS is_private_17, t0.is_factory AS is_factory_18, t0.is_in_admin AS is_in_admin_19, t0.modele_entity AS modele_entity_20, t0.has_to_be_validate_by_admin AS has_to_be_validate_by_admin_21, t0.referent AS referent_22, t0.interval AS interval_23, t0.interaction_template_id AS interaction_template_id_24 FROM media_categorie t0 WHERE t0.name = 'imageFond' LIMIT 1;
14	0.80 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.file_path AS file_path_4, t0.attributes AS attributes_5, t0.alt_attribute AS alt_attribute_6, t0.is_standalone AS is_standalone_7, t0.is_migrated AS is_migrated_8, t0.position AS position_9, t0.updated_date AS updated_date_10, t0.legacy_id AS legacy_id_11, t0.is_validated AS is_validated_12, t0.rejected_reason AS rejected_reason_13, t0.media_categorie_id AS media_categorie_id_14, t15.id AS id_16, t15.name AS name_17, t15.allowed_format AS allowed_format_18, t15.type AS type_19, t15.is_mandatory AS is_mandatory_20, t15.is_editable_by_director AS is_editable_by_director_21, t15.has_fill_in_process AS has_fill_in_process_22, t15.has_to_be_returned AS has_to_be_returned_23, t15.has_prio AS has_prio_24, t15.published_in AS published_in_25, t15.modele AS modele_26, t15.fields AS fields_27, t15.is_unique AS is_unique_28, t15.is_deletable AS is_deletable_29, t15.is_espace_parent AS is_espace_parent_30, t15.is_espace_directeur AS is_espace_directeur_31, t15.is_private AS is_private_32, t15.is_factory AS is_factory_33, t15.is_in_admin AS is_in_admin_34, t15.modele_entity AS modele_entity_35, t15.has_to_be_validate_by_admin AS has_to_be_validate_by_admin_36, t15.referent AS referent_37, t15.interval AS interval_38, t15.interaction_template_id AS interaction_template_id_39, t0.media_parent_id AS media_parent_id_40, t41.id AS id_42, t41.name AS name_43, t41.description AS description_44, t41.file_path AS file_path_45, t41.attributes AS attributes_46, t41.alt_attribute AS alt_attribute_47, t41.is_standalone AS is_standalone_48, t41.is_migrated AS is_migrated_49, t41.position AS position_50, t41.updated_date AS updated_date_51, t41.legacy_id AS legacy_id_52, t41.is_validated AS is_validated_53, t41.rejected_reason AS rejected_reason_54, t41.media_categorie_id AS media_categorie_id_55, t41.media_parent_id AS media_parent_id_56, t41.sejour_id AS sejour_id_57, t41.candidature_id AS candidature_id_58, t41.contact_id AS contact_id_59, t41.sejour_session_id AS sejour_session_id_60, t41.inscription_id AS inscription_id_61, t41.saison_id AS saison_id_62, t0.sejour_id AS sejour_id_63, t0.candidature_id AS candidature_id_64, t0.contact_id AS contact_id_65, t0.sejour_session_id AS sejour_session_id_66, t0.inscription_id AS inscription_id_67, t0.saison_id AS saison_id_68 FROM media t0 INNER JOIN media_categorie t15 ON t0.media_categorie_id = t15.id LEFT JOIN media t41 ON t0.media_parent_id = t41.id WHERE t0.media_categorie_id = ? Parameters: [`40`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.file_path AS file_path_4, t0.attributes AS attributes_5, t0.alt_attribute AS alt_attribute_6, t0.is_standalone AS is_standalone_7, t0.is_migrated AS is_migrated_8, t0.position AS position_9, t0.updated_date AS updated_date_10, t0.legacy_id AS legacy_id_11, t0.is_validated AS is_validated_12, t0.rejected_reason AS rejected_reason_13, t0.media_categorie_id AS media_categorie_id_14, t15.id AS id_16, t15.name AS name_17, t15.allowed_format AS allowed_format_18, t15.type AS type_19, t15.is_mandatory AS is_mandatory_20, t15.is_editable_by_director AS is_editable_by_director_21, t15.has_fill_in_process AS has_fill_in_process_22, t15.has_to_be_returned AS has_to_be_returned_23, t15.has_prio AS has_prio_24, t15.published_in AS published_in_25, t15.modele AS modele_26, t15.fields AS fields_27, t15.is_unique AS is_unique_28, t15.is_deletable AS is_deletable_29, t15.is_espace_parent AS is_espace_parent_30, t15.is_espace_directeur AS is_espace_directeur_31, t15.is_private AS is_private_32, t15.is_factory AS is_factory_33, t15.is_in_admin AS is_in_admin_34, t15.modele_entity AS modele_entity_35, t15.has_to_be_validate_by_admin AS has_to_be_validate_by_admin_36, t15.referent AS referent_37, t15.interval AS interval_38, t15.interaction_template_id AS interaction_template_id_39, t0.media_parent_id AS media_parent_id_40, t41.id AS id_42, t41.name AS name_43, t41.description AS description_44, t41.file_path AS file_path_45, t41.attributes AS attributes_46, t41.alt_attribute AS alt_attribute_47, t41.is_standalone AS is_standalone_48, t41.is_migrated AS is_migrated_49, t41.position AS position_50, t41.updated_date AS updated_date_51, t41.legacy_id AS legacy_id_52, t41.is_validated AS is_validated_53, t41.rejected_reason AS rejected_reason_54, t41.media_categorie_id AS media_categorie_id_55, t41.media_parent_id AS media_parent_id_56, t41.sejour_id AS sejour_id_57, t41.candidature_id AS candidature_id_58, t41.contact_id AS contact_id_59, t41.sejour_session_id AS sejour_session_id_60, t41.inscription_id AS inscription_id_61, t41.saison_id AS saison_id_62, t0.sejour_id AS sejour_id_63, t0.candidature_id AS candidature_id_64, t0.contact_id AS contact_id_65, t0.sejour_session_id AS sejour_session_id_66, t0.inscription_id AS inscription_id_67, t0.saison_id AS saison_id_68 FROM media t0 INNER JOIN media_categorie t15 ON t0.media_categorie_id = t15.id LEFT JOIN media t41 ON t0.media_parent_id = t41.id WHERE t0.media_categorie_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.file_path AS file_path_4, t0.attributes AS attributes_5, t0.alt_attribute AS alt_attribute_6, t0.is_standalone AS is_standalone_7, t0.is_migrated AS is_migrated_8, t0.position AS position_9, t0.updated_date AS updated_date_10, t0.legacy_id AS legacy_id_11, t0.is_validated AS is_validated_12, t0.rejected_reason AS rejected_reason_13, t0.media_categorie_id AS media_categorie_id_14, t15.id AS id_16, t15.name AS name_17, t15.allowed_format AS allowed_format_18, t15.type AS type_19, t15.is_mandatory AS is_mandatory_20, t15.is_editable_by_director AS is_editable_by_director_21, t15.has_fill_in_process AS has_fill_in_process_22, t15.has_to_be_returned AS has_to_be_returned_23, t15.has_prio AS has_prio_24, t15.published_in AS published_in_25, t15.modele AS modele_26, t15.fields AS fields_27, t15.is_unique AS is_unique_28, t15.is_deletable AS is_deletable_29, t15.is_espace_parent AS is_espace_parent_30, t15.is_espace_directeur AS is_espace_directeur_31, t15.is_private AS is_private_32, t15.is_factory AS is_factory_33, t15.is_in_admin AS is_in_admin_34, t15.modele_entity AS modele_entity_35, t15.has_to_be_validate_by_admin AS has_to_be_validate_by_admin_36, t15.referent AS referent_37, t15.interval AS interval_38, t15.interaction_template_id AS interaction_template_id_39, t0.media_parent_id AS media_parent_id_40, t41.id AS id_42, t41.name AS name_43, t41.description AS description_44, t41.file_path AS file_path_45, t41.attributes AS attributes_46, t41.alt_attribute AS alt_attribute_47, t41.is_standalone AS is_standalone_48, t41.is_migrated AS is_migrated_49, t41.position AS position_50, t41.updated_date AS updated_date_51, t41.legacy_id AS legacy_id_52, t41.is_validated AS is_validated_53, t41.rejected_reason AS rejected_reason_54, t41.media_categorie_id AS media_categorie_id_55, t41.media_parent_id AS media_parent_id_56, t41.sejour_id AS sejour_id_57, t41.candidature_id AS candidature_id_58, t41.contact_id AS contact_id_59, t41.sejour_session_id AS sejour_session_id_60, t41.inscription_id AS inscription_id_61, t41.saison_id AS saison_id_62, t0.sejour_id AS sejour_id_63, t0.candidature_id AS candidature_id_64, t0.contact_id AS contact_id_65, t0.sejour_session_id AS sejour_session_id_66, t0.inscription_id AS inscription_id_67, t0.saison_id AS saison_id_68 FROM media t0 INNER JOIN media_categorie t15 ON t0.media_categorie_id = t15.id LEFT JOIN media t41 ON t0.media_parent_id = t41.id WHERE t0.media_categorie_id = 40;
15	0.97 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.top_description AS top_description_3, t0.bottom_description AS bottom_description_4, t0.is_active AS is_active_5, t0.legacy_id AS legacy_id_6, t0.slug AS slug_7, t0.is_activite AS is_activite_8 FROM theme t0 WHERE t0.is_activite = ? AND t0.is_active = ? ORDER BY t0.title ASC Parameters: [`0 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.top_description AS top_description_3, t0.bottom_description AS bottom_description_4, t0.is_active AS is_active_5, t0.legacy_id AS legacy_id_6, t0.slug AS slug_7, t0.is_activite AS is_activite_8 FROM theme t0 WHERE t0.is_activite = ? AND t0.is_active = ? ORDER BY t0.title ASC SELECT t0.id AS id_1, t0.title AS title_2, t0.top_description AS top_description_3, t0.bottom_description AS bottom_description_4, t0.is_active AS is_active_5, t0.legacy_id AS legacy_id_6, t0.slug AS slug_7, t0.is_activite AS is_activite_8 FROM theme t0 WHERE t0.is_activite = 0 AND t0.is_active = 1 ORDER BY t0.title ASC;
16	0.68 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.top_description AS top_description_3, t0.bottom_description AS bottom_description_4, t0.is_active AS is_active_5, t0.legacy_id AS legacy_id_6, t0.slug AS slug_7, t0.is_activite AS is_activite_8 FROM theme t0 WHERE t0.is_activite = ? AND t0.is_active = ? ORDER BY t0.title ASC Parameters: [`1 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.top_description AS top_description_3, t0.bottom_description AS bottom_description_4, t0.is_active AS is_active_5, t0.legacy_id AS legacy_id_6, t0.slug AS slug_7, t0.is_activite AS is_activite_8 FROM theme t0 WHERE t0.is_activite = ? AND t0.is_active = ? ORDER BY t0.title ASC SELECT t0.id AS id_1, t0.title AS title_2, t0.top_description AS top_description_3, t0.bottom_description AS bottom_description_4, t0.is_active AS is_active_5, t0.legacy_id AS legacy_id_6, t0.slug AS slug_7, t0.is_activite AS is_activite_8 FROM theme t0 WHERE t0.is_activite = 1 AND t0.is_active = 1 ORDER BY t0.title ASC;
17	0.23 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"saisonActuelle"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = 'saisonActuelle' LIMIT 1;
18	0.22 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 WHERE t0.slug = ? LIMIT 1 Parameters: [`"ete"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 WHERE t0.slug = ? LIMIT 1 SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 WHERE t0.slug = 'ete' LIMIT 1;
19	0.20 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"animateurs"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = 'animateurs' LIMIT 1;
20	0.21 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"destinations"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = 'destinations' LIMIT 1;
21	0.20 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"themes"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = 'themes' LIMIT 1;
22	0.22 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"années"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = 'années' LIMIT 1;
23	0.19 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"enfants"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = 'enfants' LIMIT 1;
24	0.23 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"colonies"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = 'colonies' LIMIT 1;
25	0.28 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.link_label AS link_label_4, t0.link_url AS link_url_5, t0.alt_attribute AS alt_attribute_6, t0.creation_date AS creation_date_7, t0.updated_date AS updated_date_8, t0.is_active AS is_active_9, t0.is_une AS is_une_10, t0.img AS img_11, t0.legacy_id AS legacy_id_12, t0.is_blog AS is_blog_13, t0.type AS type_14, t0.path AS path_15 FROM article t0 WHERE t0.is_une = ? ORDER BY t0.creation_date DESC LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.link_label AS link_label_4, t0.link_url AS link_url_5, t0.alt_attribute AS alt_attribute_6, t0.creation_date AS creation_date_7, t0.updated_date AS updated_date_8, t0.is_active AS is_active_9, t0.is_une AS is_une_10, t0.img AS img_11, t0.legacy_id AS legacy_id_12, t0.is_blog AS is_blog_13, t0.type AS type_14, t0.path AS path_15 FROM article t0 WHERE t0.is_une = ? ORDER BY t0.creation_date DESC LIMIT 1 SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.link_label AS link_label_4, t0.link_url AS link_url_5, t0.alt_attribute AS alt_attribute_6, t0.creation_date AS creation_date_7, t0.updated_date AS updated_date_8, t0.is_active AS is_active_9, t0.is_une AS is_une_10, t0.img AS img_11, t0.legacy_id AS legacy_id_12, t0.is_blog AS is_blog_13, t0.type AS type_14, t0.path AS path_15 FROM article t0 WHERE t0.is_une = 1 ORDER BY t0.creation_date DESC LIMIT 1;
26	6.95 ms	SELECT t0.id AS id_1, t0.role AS role_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.date AS date_5, t0.url AS url_6, t0.statut AS statut_7 FROM notification t0 WHERE t0.statut = ? ORDER BY t0.date DESC LIMIT 10 Parameters: [`"open"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.role AS role_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.date AS date_5, t0.url AS url_6, t0.statut AS statut_7 FROM notification t0 WHERE t0.statut = ? ORDER BY t0.date DESC LIMIT 10 SELECT t0.id AS id_1, t0.role AS role_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.date AS date_5, t0.url AS url_6, t0.statut AS statut_7 FROM notification t0 WHERE t0.statut = 'open' ORDER BY t0.date DESC LIMIT 10;
27	0.29 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"anneGenerale"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = 'anneGenerale' LIMIT 1;
28	0.22 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 WHERE t0.title IN (?) LIMIT 1 Parameters: [`"hiver"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 WHERE t0.title IN (?) LIMIT 1 SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 WHERE t0.title IN ('hiver') LIMIT 1;
29	0.52 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.top_description AS top_description_3, t0.bottom_description AS bottom_description_4, t0.is_active AS is_active_5, t0.legacy_id AS legacy_id_6, t0.slug AS slug_7, t0.is_activite AS is_activite_8 FROM theme t0 WHERE t0.slug IN (?) AND t0.is_activite = ? LIMIT 1 Parameters: [`"hiver" 0`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.top_description AS top_description_3, t0.bottom_description AS bottom_description_4, t0.is_active AS is_active_5, t0.legacy_id AS legacy_id_6, t0.slug AS slug_7, t0.is_activite AS is_activite_8 FROM theme t0 WHERE t0.slug IN (?) AND t0.is_activite = ? LIMIT 1 SELECT t0.id AS id_1, t0.title AS title_2, t0.top_description AS top_description_3, t0.bottom_description AS bottom_description_4, t0.is_active AS is_active_5, t0.legacy_id AS legacy_id_6, t0.slug AS slug_7, t0.is_activite AS is_activite_8 FROM theme t0 WHERE t0.slug IN ('hiver') AND t0.is_activite = 0 LIMIT 1;
30	0.38 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.top_description AS top_description_3, t0.bottom_description AS bottom_description_4, t0.is_active AS is_active_5, t0.legacy_id AS legacy_id_6, t0.slug AS slug_7, t0.is_activite AS is_activite_8 FROM theme t0 WHERE t0.slug IN (?) AND t0.is_activite = ? LIMIT 1 Parameters: [`"hiver" 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.top_description AS top_description_3, t0.bottom_description AS bottom_description_4, t0.is_active AS is_active_5, t0.legacy_id AS legacy_id_6, t0.slug AS slug_7, t0.is_activite AS is_activite_8 FROM theme t0 WHERE t0.slug IN (?) AND t0.is_activite = ? LIMIT 1 SELECT t0.id AS id_1, t0.title AS title_2, t0.top_description AS top_description_3, t0.bottom_description AS bottom_description_4, t0.is_active AS is_active_5, t0.legacy_id AS legacy_id_6, t0.slug AS slug_7, t0.is_activite AS is_activite_8 FROM theme t0 WHERE t0.slug IN ('hiver') AND t0.is_activite = 1 LIMIT 1;
31	0.20 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.bottom_description AS bottom_description_3, t0.top_description AS top_description_4, t0.slug AS slug_5, t0.age AS age_6, t0.is_active AS is_active_7 FROM age t0 WHERE t0.slug IN (?) LIMIT 1 Parameters: [`"hiver"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.bottom_description AS bottom_description_3, t0.top_description AS top_description_4, t0.slug AS slug_5, t0.age AS age_6, t0.is_active AS is_active_7 FROM age t0 WHERE t0.slug IN (?) LIMIT 1 SELECT t0.id AS id_1, t0.title AS title_2, t0.bottom_description AS bottom_description_3, t0.top_description AS top_description_4, t0.slug AS slug_5, t0.age AS age_6, t0.is_active AS is_active_7 FROM age t0 WHERE t0.slug IN ('hiver') LIMIT 1;
32	0.28 ms	SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.slug AS slug_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.flag AS flag_9 FROM country t0 WHERE t0.slug IN (?) LIMIT 1 Parameters: [`"hiver"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.slug AS slug_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.flag AS flag_9 FROM country t0 WHERE t0.slug IN (?) LIMIT 1 SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.slug AS slug_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.flag AS flag_9 FROM country t0 WHERE t0.slug IN ('hiver') LIMIT 1;
33	0.20 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.bottom_description AS bottom_description_3, t0.top_description AS top_description_4, t0.is_active AS is_active_5, t0.slug AS slug_6 FROM ville_desservie t0 WHERE t0.slug IN (?) AND t0.is_active = ? LIMIT 1 Parameters: [`"hiver" 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.bottom_description AS bottom_description_3, t0.top_description AS top_description_4, t0.is_active AS is_active_5, t0.slug AS slug_6 FROM ville_desservie t0 WHERE t0.slug IN (?) AND t0.is_active = ? LIMIT 1 SELECT t0.id AS id_1, t0.title AS title_2, t0.bottom_description AS bottom_description_3, t0.top_description AS top_description_4, t0.is_active AS is_active_5, t0.slug AS slug_6 FROM ville_desservie t0 WHERE t0.slug IN ('hiver') AND t0.is_active = 1 LIMIT 1;
34	5.15 ms	SELECT count(DISTINCT s0_.id) AS sclr_0 FROM sejour s0_ INNER JOIN sejour_session s1_ ON s0_.id = s1_.sejour_id INNER JOIN sejour_theme s3_ ON s0_.id = s3_.sejour_id INNER JOIN theme t2_ ON t2_.id = s3_.theme_id INNER JOIN sejour_theme s5_ ON s0_.id = s5_.sejour_id INNER JOIN theme t4_ ON t4_.id = s5_.theme_id INNER JOIN sejour_saison s7_ ON s0_.id = s7_.sejour_id INNER JOIN saison s6_ ON s6_.id = s7_.saison_id WHERE s6_.id = ? AND s0_.is_active = ? Parameters: [`1 1`] View formatted query View runnable query Explain query SELECT count(DISTINCT s0_.id) AS sclr_0 FROM sejour s0_ INNER JOIN sejour_session s1_ ON s0_.id = s1_.sejour_id INNER JOIN sejour_theme s3_ ON s0_.id = s3_.sejour_id INNER JOIN theme t2_ ON t2_.id = s3_.theme_id INNER JOIN sejour_theme s5_ ON s0_.id = s5_.sejour_id INNER JOIN theme t4_ ON t4_.id = s5_.theme_id INNER JOIN sejour_saison s7_ ON s0_.id = s7_.sejour_id INNER JOIN saison s6_ ON s6_.id = s7_.saison_id WHERE s6_.id = ? AND s0_.is_active = ? SELECT count(DISTINCT s0_.id) AS sclr_0 FROM sejour s0_ INNER JOIN sejour_session s1_ ON s0_.id = s1_.sejour_id INNER JOIN sejour_theme s3_ ON s0_.id = s3_.sejour_id INNER JOIN theme t2_ ON t2_.id = s3_.theme_id INNER JOIN sejour_theme s5_ ON s0_.id = s5_.sejour_id INNER JOIN theme t4_ ON t4_.id = s5_.theme_id INNER JOIN sejour_saison s7_ ON s0_.id = s7_.sejour_id INNER JOIN saison s6_ ON s6_.id = s7_.saison_id WHERE s6_.id = 1 AND s0_.is_active = 1;
35	1.12 ms	SELECT DISTINCT s0_.id AS id_0, s0_.is_bientot AS is_bientot_1 FROM sejour s0_ INNER JOIN sejour_session s1_ ON s0_.id = s1_.sejour_id INNER JOIN sejour_theme s3_ ON s0_.id = s3_.sejour_id INNER JOIN theme t2_ ON t2_.id = s3_.theme_id INNER JOIN sejour_theme s5_ ON s0_.id = s5_.sejour_id INNER JOIN theme t4_ ON t4_.id = s5_.theme_id INNER JOIN sejour_saison s7_ ON s0_.id = s7_.sejour_id INNER JOIN saison s6_ ON s6_.id = s7_.saison_id WHERE s6_.id = ? AND s0_.is_active = ? ORDER BY s0_.is_bientot ASC LIMIT 11 Parameters: [`1 1`] View formatted query View runnable query Explain query SELECT DISTINCT s0_.id AS id_0, s0_.is_bientot AS is_bientot_1 FROM sejour s0_ INNER JOIN sejour_session s1_ ON s0_.id = s1_.sejour_id INNER JOIN sejour_theme s3_ ON s0_.id = s3_.sejour_id INNER JOIN theme t2_ ON t2_.id = s3_.theme_id INNER JOIN sejour_theme s5_ ON s0_.id = s5_.sejour_id INNER JOIN theme t4_ ON t4_.id = s5_.theme_id INNER JOIN sejour_saison s7_ ON s0_.id = s7_.sejour_id INNER JOIN saison s6_ ON s6_.id = s7_.saison_id WHERE s6_.id = ? AND s0_.is_active = ? ORDER BY s0_.is_bientot ASC LIMIT 11 SELECT DISTINCT s0_.id AS id_0, s0_.is_bientot AS is_bientot_1 FROM sejour s0_ INNER JOIN sejour_session s1_ ON s0_.id = s1_.sejour_id INNER JOIN sejour_theme s3_ ON s0_.id = s3_.sejour_id INNER JOIN theme t2_ ON t2_.id = s3_.theme_id INNER JOIN sejour_theme s5_ ON s0_.id = s5_.sejour_id INNER JOIN theme t4_ ON t4_.id = s5_.theme_id INNER JOIN sejour_saison s7_ ON s0_.id = s7_.sejour_id INNER JOIN saison s6_ ON s6_.id = s7_.saison_id WHERE s6_.id = 1 AND s0_.is_active = 1 ORDER BY s0_.is_bientot ASC LIMIT 11;
36	16.37 ms	SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.activites AS activites_3, s0_.updated_date AS updated_date_4, s0_.hebergement AS hebergement_5, s0_.is_active AS is_active_6, s0_.is_bientot AS is_bientot_7, s0_.is_objectif_zero_co2 AS is_objectif_zero_co2_8, s0_.position AS position_9, s0_.age_min AS age_min_10, s0_.age_max AS age_max_11, s0_.is_sejour_location AS is_sejour_location_12, s0_.is_sejour_court AS is_sejour_court_13, s0_.notre_avis AS notre_avis_14, s0_.tarifs AS tarifs_15, s0_.places_count AS places_count_16, s0_.legacy_id AS legacy_id_17, s0_.intro AS intro_18, s0_.price AS price_19, s0_.duree AS duree_20, s0_.encadrement AS encadrement_21, s0_.nombre AS nombre_22, s0_.duree_integer AS duree_integer_23, s0_.tranport AS tranport_24, s0_.transport AS transport_25, s0_.compris AS compris_26, s0_.noncompris AS noncompris_27, s0_.information_complementaire AS information_complementaire_28, s0_.url AS url_29, s0_.sejour_type AS sejour_type_30, s0_.video_link AS video_link_31, s0_.activites_fiche_sejour AS activites_fiche_sejour_32, s0_.lien_youtube AS lien_youtube_33, s0_.location_id AS location_id_34, s0_.tranche_age1_id AS tranche_age1_id_35, s0_.tranche_age2_id AS tranche_age2_id_36 FROM sejour s0_ INNER JOIN sejour_session s1_ ON s0_.id = s1_.sejour_id INNER JOIN sejour_theme s3_ ON s0_.id = s3_.sejour_id INNER JOIN theme t2_ ON t2_.id = s3_.theme_id INNER JOIN sejour_theme s5_ ON s0_.id = s5_.sejour_id INNER JOIN theme t4_ ON t4_.id = s5_.theme_id INNER JOIN sejour_saison s7_ ON s0_.id = s7_.sejour_id INNER JOIN saison s6_ ON s6_.id = s7_.saison_id WHERE s6_.id = ? AND s0_.is_active = ? AND s0_.id IN (?, ?, ?) ORDER BY s0_.is_bientot ASC Parameters: [`1 1 68 136 137`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.activites AS activites_3, s0_.updated_date AS updated_date_4, s0_.hebergement AS hebergement_5, s0_.is_active AS is_active_6, s0_.is_bientot AS is_bientot_7, s0_.is_objectif_zero_co2 AS is_objectif_zero_co2_8, s0_.position AS position_9, s0_.age_min AS age_min_10, s0_.age_max AS age_max_11, s0_.is_sejour_location AS is_sejour_location_12, s0_.is_sejour_court AS is_sejour_court_13, s0_.notre_avis AS notre_avis_14, s0_.tarifs AS tarifs_15, s0_.places_count AS places_count_16, s0_.legacy_id AS legacy_id_17, s0_.intro AS intro_18, s0_.price AS price_19, s0_.duree AS duree_20, s0_.encadrement AS encadrement_21, s0_.nombre AS nombre_22, s0_.duree_integer AS duree_integer_23, s0_.tranport AS tranport_24, s0_.transport AS transport_25, s0_.compris AS compris_26, s0_.noncompris AS noncompris_27, s0_.information_complementaire AS information_complementaire_28, s0_.url AS url_29, s0_.sejour_type AS sejour_type_30, s0_.video_link AS video_link_31, s0_.activites_fiche_sejour AS activites_fiche_sejour_32, s0_.lien_youtube AS lien_youtube_33, s0_.location_id AS location_id_34, s0_.tranche_age1_id AS tranche_age1_id_35, s0_.tranche_age2_id AS tranche_age2_id_36 FROM sejour s0_ INNER JOIN sejour_session s1_ ON s0_.id = s1_.sejour_id INNER JOIN sejour_theme s3_ ON s0_.id = s3_.sejour_id INNER JOIN theme t2_ ON t2_.id = s3_.theme_id INNER JOIN sejour_theme s5_ ON s0_.id = s5_.sejour_id INNER JOIN theme t4_ ON t4_.id = s5_.theme_id INNER JOIN sejour_saison s7_ ON s0_.id = s7_.sejour_id INNER JOIN saison s6_ ON s6_.id = s7_.saison_id WHERE s6_.id = ? AND s0_.is_active = ? AND s0_.id IN (?, ?, ?) ORDER BY s0_.is_bientot ASC SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.activites AS activites_3, s0_.updated_date AS updated_date_4, s0_.hebergement AS hebergement_5, s0_.is_active AS is_active_6, s0_.is_bientot AS is_bientot_7, s0_.is_objectif_zero_co2 AS is_objectif_zero_co2_8, s0_.position AS position_9, s0_.age_min AS age_min_10, s0_.age_max AS age_max_11, s0_.is_sejour_location AS is_sejour_location_12, s0_.is_sejour_court AS is_sejour_court_13, s0_.notre_avis AS notre_avis_14, s0_.tarifs AS tarifs_15, s0_.places_count AS places_count_16, s0_.legacy_id AS legacy_id_17, s0_.intro AS intro_18, s0_.price AS price_19, s0_.duree AS duree_20, s0_.encadrement AS encadrement_21, s0_.nombre AS nombre_22, s0_.duree_integer AS duree_integer_23, s0_.tranport AS tranport_24, s0_.transport AS transport_25, s0_.compris AS compris_26, s0_.noncompris AS noncompris_27, s0_.information_complementaire AS information_complementaire_28, s0_.url AS url_29, s0_.sejour_type AS sejour_type_30, s0_.video_link AS video_link_31, s0_.activites_fiche_sejour AS activites_fiche_sejour_32, s0_.lien_youtube AS lien_youtube_33, s0_.location_id AS location_id_34, s0_.tranche_age1_id AS tranche_age1_id_35, s0_.tranche_age2_id AS tranche_age2_id_36 FROM sejour s0_ INNER JOIN sejour_session s1_ ON s0_.id = s1_.sejour_id INNER JOIN sejour_theme s3_ ON s0_.id = s3_.sejour_id INNER JOIN theme t2_ ON t2_.id = s3_.theme_id INNER JOIN sejour_theme s5_ ON s0_.id = s5_.sejour_id INNER JOIN theme t4_ ON t4_.id = s5_.theme_id INNER JOIN sejour_saison s7_ ON s0_.id = s7_.sejour_id INNER JOIN saison s6_ ON s6_.id = s7_.saison_id WHERE s6_.id = 1 AND s0_.is_active = 1 AND s0_.id IN (68, 136, 137) ORDER BY s0_.is_bientot ASC;
37	1.03 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.code_gen AS code_gen_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.prix AS prix_6, t0.place_dispo AS place_dispo_7, t0.media_statut AS media_statut_8, t0.last_update AS last_update_9, t0.legacy_id AS legacy_id_10, t0.override_places_dispos AS override_places_dispos_11, t0.sejour_id AS sejour_id_12, t13.id AS id_14, t13.title AS title_15, t13.description AS description_16, t13.activites AS activites_17, t13.updated_date AS updated_date_18, t13.hebergement AS hebergement_19, t13.is_active AS is_active_20, t13.is_bientot AS is_bientot_21, t13.is_objectif_zero_co2 AS is_objectif_zero_co2_22, t13.position AS position_23, t13.age_min AS age_min_24, t13.age_max AS age_max_25, t13.is_sejour_location AS is_sejour_location_26, t13.is_sejour_court AS is_sejour_court_27, t13.notre_avis AS notre_avis_28, t13.tarifs AS tarifs_29, t13.places_count AS places_count_30, t13.legacy_id AS legacy_id_31, t13.intro AS intro_32, t13.price AS price_33, t13.duree AS duree_34, t13.encadrement AS encadrement_35, t13.nombre AS nombre_36, t13.duree_integer AS duree_integer_37, t13.tranport AS tranport_38, t13.transport AS transport_39, t13.compris AS compris_40, t13.noncompris AS noncompris_41, t13.information_complementaire AS information_complementaire_42, t13.url AS url_43, t13.sejour_type AS sejour_type_44, t13.video_link AS video_link_45, t13.activites_fiche_sejour AS activites_fiche_sejour_46, t13.lien_youtube AS lien_youtube_47, t13.location_id AS location_id_48, t13.tranche_age1_id AS tranche_age1_id_49, t13.tranche_age2_id AS tranche_age2_id_50 FROM sejour_session t0 INNER JOIN sejour t13 ON t0.sejour_id = t13.id WHERE t0.sejour_id = ? ORDER BY t0.date_debut ASC Parameters: [`68`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.code_gen AS code_gen_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.prix AS prix_6, t0.place_dispo AS place_dispo_7, t0.media_statut AS media_statut_8, t0.last_update AS last_update_9, t0.legacy_id AS legacy_id_10, t0.override_places_dispos AS override_places_dispos_11, t0.sejour_id AS sejour_id_12, t13.id AS id_14, t13.title AS title_15, t13.description AS description_16, t13.activites AS activites_17, t13.updated_date AS updated_date_18, t13.hebergement AS hebergement_19, t13.is_active AS is_active_20, t13.is_bientot AS is_bientot_21, t13.is_objectif_zero_co2 AS is_objectif_zero_co2_22, t13.position AS position_23, t13.age_min AS age_min_24, t13.age_max AS age_max_25, t13.is_sejour_location AS is_sejour_location_26, t13.is_sejour_court AS is_sejour_court_27, t13.notre_avis AS notre_avis_28, t13.tarifs AS tarifs_29, t13.places_count AS places_count_30, t13.legacy_id AS legacy_id_31, t13.intro AS intro_32, t13.price AS price_33, t13.duree AS duree_34, t13.encadrement AS encadrement_35, t13.nombre AS nombre_36, t13.duree_integer AS duree_integer_37, t13.tranport AS tranport_38, t13.transport AS transport_39, t13.compris AS compris_40, t13.noncompris AS noncompris_41, t13.information_complementaire AS information_complementaire_42, t13.url AS url_43, t13.sejour_type AS sejour_type_44, t13.video_link AS video_link_45, t13.activites_fiche_sejour AS activites_fiche_sejour_46, t13.lien_youtube AS lien_youtube_47, t13.location_id AS location_id_48, t13.tranche_age1_id AS tranche_age1_id_49, t13.tranche_age2_id AS tranche_age2_id_50 FROM sejour_session t0 INNER JOIN sejour t13 ON t0.sejour_id = t13.id WHERE t0.sejour_id = ? ORDER BY t0.date_debut ASC SELECT t0.id AS id_1, t0.code AS code_2, t0.code_gen AS code_gen_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.prix AS prix_6, t0.place_dispo AS place_dispo_7, t0.media_statut AS media_statut_8, t0.last_update AS last_update_9, t0.legacy_id AS legacy_id_10, t0.override_places_dispos AS override_places_dispos_11, t0.sejour_id AS sejour_id_12, t13.id AS id_14, t13.title AS title_15, t13.description AS description_16, t13.activites AS activites_17, t13.updated_date AS updated_date_18, t13.hebergement AS hebergement_19, t13.is_active AS is_active_20, t13.is_bientot AS is_bientot_21, t13.is_objectif_zero_co2 AS is_objectif_zero_co2_22, t13.position AS position_23, t13.age_min AS age_min_24, t13.age_max AS age_max_25, t13.is_sejour_location AS is_sejour_location_26, t13.is_sejour_court AS is_sejour_court_27, t13.notre_avis AS notre_avis_28, t13.tarifs AS tarifs_29, t13.places_count AS places_count_30, t13.legacy_id AS legacy_id_31, t13.intro AS intro_32, t13.price AS price_33, t13.duree AS duree_34, t13.encadrement AS encadrement_35, t13.nombre AS nombre_36, t13.duree_integer AS duree_integer_37, t13.tranport AS tranport_38, t13.transport AS transport_39, t13.compris AS compris_40, t13.noncompris AS noncompris_41, t13.information_complementaire AS information_complementaire_42, t13.url AS url_43, t13.sejour_type AS sejour_type_44, t13.video_link AS video_link_45, t13.activites_fiche_sejour AS activites_fiche_sejour_46, t13.lien_youtube AS lien_youtube_47, t13.location_id AS location_id_48, t13.tranche_age1_id AS tranche_age1_id_49, t13.tranche_age2_id AS tranche_age2_id_50 FROM sejour_session t0 INNER JOIN sejour t13 ON t0.sejour_id = t13.id WHERE t0.sejour_id = 68 ORDER BY t0.date_debut ASC;
38	1.20 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.file_path AS file_path_4, t0.attributes AS attributes_5, t0.alt_attribute AS alt_attribute_6, t0.is_standalone AS is_standalone_7, t0.is_migrated AS is_migrated_8, t0.position AS position_9, t0.updated_date AS updated_date_10, t0.legacy_id AS legacy_id_11, t0.is_validated AS is_validated_12, t0.rejected_reason AS rejected_reason_13, t0.media_categorie_id AS media_categorie_id_14, t15.id AS id_16, t15.name AS name_17, t15.allowed_format AS allowed_format_18, t15.type AS type_19, t15.is_mandatory AS is_mandatory_20, t15.is_editable_by_director AS is_editable_by_director_21, t15.has_fill_in_process AS has_fill_in_process_22, t15.has_to_be_returned AS has_to_be_returned_23, t15.has_prio AS has_prio_24, t15.published_in AS published_in_25, t15.modele AS modele_26, t15.fields AS fields_27, t15.is_unique AS is_unique_28, t15.is_deletable AS is_deletable_29, t15.is_espace_parent AS is_espace_parent_30, t15.is_espace_directeur AS is_espace_directeur_31, t15.is_private AS is_private_32, t15.is_factory AS is_factory_33, t15.is_in_admin AS is_in_admin_34, t15.modele_entity AS modele_entity_35, t15.has_to_be_validate_by_admin AS has_to_be_validate_by_admin_36, t15.referent AS referent_37, t15.interval AS interval_38, t15.interaction_template_id AS interaction_template_id_39, t0.media_parent_id AS media_parent_id_40, t41.id AS id_42, t41.name AS name_43, t41.description AS description_44, t41.file_path AS file_path_45, t41.attributes AS attributes_46, t41.alt_attribute AS alt_attribute_47, t41.is_standalone AS is_standalone_48, t41.is_migrated AS is_migrated_49, t41.position AS position_50, t41.updated_date AS updated_date_51, t41.legacy_id AS legacy_id_52, t41.is_validated AS is_validated_53, t41.rejected_reason AS rejected_reason_54, t41.media_categorie_id AS media_categorie_id_55, t41.media_parent_id AS media_parent_id_56, t41.sejour_id AS sejour_id_57, t41.candidature_id AS candidature_id_58, t41.contact_id AS contact_id_59, t41.sejour_session_id AS sejour_session_id_60, t41.inscription_id AS inscription_id_61, t41.saison_id AS saison_id_62, t0.sejour_id AS sejour_id_63, t0.candidature_id AS candidature_id_64, t0.contact_id AS contact_id_65, t0.sejour_session_id AS sejour_session_id_66, t0.inscription_id AS inscription_id_67, t0.saison_id AS saison_id_68 FROM media t0 INNER JOIN media_categorie t15 ON t0.media_categorie_id = t15.id LEFT JOIN media t41 ON t0.media_parent_id = t41.id WHERE t0.sejour_id = ? Parameters: [`68`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.file_path AS file_path_4, t0.attributes AS attributes_5, t0.alt_attribute AS alt_attribute_6, t0.is_standalone AS is_standalone_7, t0.is_migrated AS is_migrated_8, t0.position AS position_9, t0.updated_date AS updated_date_10, t0.legacy_id AS legacy_id_11, t0.is_validated AS is_validated_12, t0.rejected_reason AS rejected_reason_13, t0.media_categorie_id AS media_categorie_id_14, t15.id AS id_16, t15.name AS name_17, t15.allowed_format AS allowed_format_18, t15.type AS type_19, t15.is_mandatory AS is_mandatory_20, t15.is_editable_by_director AS is_editable_by_director_21, t15.has_fill_in_process AS has_fill_in_process_22, t15.has_to_be_returned AS has_to_be_returned_23, t15.has_prio AS has_prio_24, t15.published_in AS published_in_25, t15.modele AS modele_26, t15.fields AS fields_27, t15.is_unique AS is_unique_28, t15.is_deletable AS is_deletable_29, t15.is_espace_parent AS is_espace_parent_30, t15.is_espace_directeur AS is_espace_directeur_31, t15.is_private AS is_private_32, t15.is_factory AS is_factory_33, t15.is_in_admin AS is_in_admin_34, t15.modele_entity AS modele_entity_35, t15.has_to_be_validate_by_admin AS has_to_be_validate_by_admin_36, t15.referent AS referent_37, t15.interval AS interval_38, t15.interaction_template_id AS interaction_template_id_39, t0.media_parent_id AS media_parent_id_40, t41.id AS id_42, t41.name AS name_43, t41.description AS description_44, t41.file_path AS file_path_45, t41.attributes AS attributes_46, t41.alt_attribute AS alt_attribute_47, t41.is_standalone AS is_standalone_48, t41.is_migrated AS is_migrated_49, t41.position AS position_50, t41.updated_date AS updated_date_51, t41.legacy_id AS legacy_id_52, t41.is_validated AS is_validated_53, t41.rejected_reason AS rejected_reason_54, t41.media_categorie_id AS media_categorie_id_55, t41.media_parent_id AS media_parent_id_56, t41.sejour_id AS sejour_id_57, t41.candidature_id AS candidature_id_58, t41.contact_id AS contact_id_59, t41.sejour_session_id AS sejour_session_id_60, t41.inscription_id AS inscription_id_61, t41.saison_id AS saison_id_62, t0.sejour_id AS sejour_id_63, t0.candidature_id AS candidature_id_64, t0.contact_id AS contact_id_65, t0.sejour_session_id AS sejour_session_id_66, t0.inscription_id AS inscription_id_67, t0.saison_id AS saison_id_68 FROM media t0 INNER JOIN media_categorie t15 ON t0.media_categorie_id = t15.id LEFT JOIN media t41 ON t0.media_parent_id = t41.id WHERE t0.sejour_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.file_path AS file_path_4, t0.attributes AS attributes_5, t0.alt_attribute AS alt_attribute_6, t0.is_standalone AS is_standalone_7, t0.is_migrated AS is_migrated_8, t0.position AS position_9, t0.updated_date AS updated_date_10, t0.legacy_id AS legacy_id_11, t0.is_validated AS is_validated_12, t0.rejected_reason AS rejected_reason_13, t0.media_categorie_id AS media_categorie_id_14, t15.id AS id_16, t15.name AS name_17, t15.allowed_format AS allowed_format_18, t15.type AS type_19, t15.is_mandatory AS is_mandatory_20, t15.is_editable_by_director AS is_editable_by_director_21, t15.has_fill_in_process AS has_fill_in_process_22, t15.has_to_be_returned AS has_to_be_returned_23, t15.has_prio AS has_prio_24, t15.published_in AS published_in_25, t15.modele AS modele_26, t15.fields AS fields_27, t15.is_unique AS is_unique_28, t15.is_deletable AS is_deletable_29, t15.is_espace_parent AS is_espace_parent_30, t15.is_espace_directeur AS is_espace_directeur_31, t15.is_private AS is_private_32, t15.is_factory AS is_factory_33, t15.is_in_admin AS is_in_admin_34, t15.modele_entity AS modele_entity_35, t15.has_to_be_validate_by_admin AS has_to_be_validate_by_admin_36, t15.referent AS referent_37, t15.interval AS interval_38, t15.interaction_template_id AS interaction_template_id_39, t0.media_parent_id AS media_parent_id_40, t41.id AS id_42, t41.name AS name_43, t41.description AS description_44, t41.file_path AS file_path_45, t41.attributes AS attributes_46, t41.alt_attribute AS alt_attribute_47, t41.is_standalone AS is_standalone_48, t41.is_migrated AS is_migrated_49, t41.position AS position_50, t41.updated_date AS updated_date_51, t41.legacy_id AS legacy_id_52, t41.is_validated AS is_validated_53, t41.rejected_reason AS rejected_reason_54, t41.media_categorie_id AS media_categorie_id_55, t41.media_parent_id AS media_parent_id_56, t41.sejour_id AS sejour_id_57, t41.candidature_id AS candidature_id_58, t41.contact_id AS contact_id_59, t41.sejour_session_id AS sejour_session_id_60, t41.inscription_id AS inscription_id_61, t41.saison_id AS saison_id_62, t0.sejour_id AS sejour_id_63, t0.candidature_id AS candidature_id_64, t0.contact_id AS contact_id_65, t0.sejour_session_id AS sejour_session_id_66, t0.inscription_id AS inscription_id_67, t0.saison_id AS saison_id_68 FROM media t0 INNER JOIN media_categorie t15 ON t0.media_categorie_id = t15.id LEFT JOIN media t41 ON t0.media_parent_id = t41.id WHERE t0.sejour_id = 68;
39	0.62 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.code_gen AS code_gen_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.prix AS prix_6, t0.place_dispo AS place_dispo_7, t0.media_statut AS media_statut_8, t0.last_update AS last_update_9, t0.legacy_id AS legacy_id_10, t0.override_places_dispos AS override_places_dispos_11, t0.sejour_id AS sejour_id_12, t13.id AS id_14, t13.title AS title_15, t13.description AS description_16, t13.activites AS activites_17, t13.updated_date AS updated_date_18, t13.hebergement AS hebergement_19, t13.is_active AS is_active_20, t13.is_bientot AS is_bientot_21, t13.is_objectif_zero_co2 AS is_objectif_zero_co2_22, t13.position AS position_23, t13.age_min AS age_min_24, t13.age_max AS age_max_25, t13.is_sejour_location AS is_sejour_location_26, t13.is_sejour_court AS is_sejour_court_27, t13.notre_avis AS notre_avis_28, t13.tarifs AS tarifs_29, t13.places_count AS places_count_30, t13.legacy_id AS legacy_id_31, t13.intro AS intro_32, t13.price AS price_33, t13.duree AS duree_34, t13.encadrement AS encadrement_35, t13.nombre AS nombre_36, t13.duree_integer AS duree_integer_37, t13.tranport AS tranport_38, t13.transport AS transport_39, t13.compris AS compris_40, t13.noncompris AS noncompris_41, t13.information_complementaire AS information_complementaire_42, t13.url AS url_43, t13.sejour_type AS sejour_type_44, t13.video_link AS video_link_45, t13.activites_fiche_sejour AS activites_fiche_sejour_46, t13.lien_youtube AS lien_youtube_47, t13.location_id AS location_id_48, t13.tranche_age1_id AS tranche_age1_id_49, t13.tranche_age2_id AS tranche_age2_id_50 FROM sejour_session t0 INNER JOIN sejour t13 ON t0.sejour_id = t13.id WHERE t0.sejour_id = ? ORDER BY t0.date_debut ASC Parameters: [`136`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.code_gen AS code_gen_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.prix AS prix_6, t0.place_dispo AS place_dispo_7, t0.media_statut AS media_statut_8, t0.last_update AS last_update_9, t0.legacy_id AS legacy_id_10, t0.override_places_dispos AS override_places_dispos_11, t0.sejour_id AS sejour_id_12, t13.id AS id_14, t13.title AS title_15, t13.description AS description_16, t13.activites AS activites_17, t13.updated_date AS updated_date_18, t13.hebergement AS hebergement_19, t13.is_active AS is_active_20, t13.is_bientot AS is_bientot_21, t13.is_objectif_zero_co2 AS is_objectif_zero_co2_22, t13.position AS position_23, t13.age_min AS age_min_24, t13.age_max AS age_max_25, t13.is_sejour_location AS is_sejour_location_26, t13.is_sejour_court AS is_sejour_court_27, t13.notre_avis AS notre_avis_28, t13.tarifs AS tarifs_29, t13.places_count AS places_count_30, t13.legacy_id AS legacy_id_31, t13.intro AS intro_32, t13.price AS price_33, t13.duree AS duree_34, t13.encadrement AS encadrement_35, t13.nombre AS nombre_36, t13.duree_integer AS duree_integer_37, t13.tranport AS tranport_38, t13.transport AS transport_39, t13.compris AS compris_40, t13.noncompris AS noncompris_41, t13.information_complementaire AS information_complementaire_42, t13.url AS url_43, t13.sejour_type AS sejour_type_44, t13.video_link AS video_link_45, t13.activites_fiche_sejour AS activites_fiche_sejour_46, t13.lien_youtube AS lien_youtube_47, t13.location_id AS location_id_48, t13.tranche_age1_id AS tranche_age1_id_49, t13.tranche_age2_id AS tranche_age2_id_50 FROM sejour_session t0 INNER JOIN sejour t13 ON t0.sejour_id = t13.id WHERE t0.sejour_id = ? ORDER BY t0.date_debut ASC SELECT t0.id AS id_1, t0.code AS code_2, t0.code_gen AS code_gen_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.prix AS prix_6, t0.place_dispo AS place_dispo_7, t0.media_statut AS media_statut_8, t0.last_update AS last_update_9, t0.legacy_id AS legacy_id_10, t0.override_places_dispos AS override_places_dispos_11, t0.sejour_id AS sejour_id_12, t13.id AS id_14, t13.title AS title_15, t13.description AS description_16, t13.activites AS activites_17, t13.updated_date AS updated_date_18, t13.hebergement AS hebergement_19, t13.is_active AS is_active_20, t13.is_bientot AS is_bientot_21, t13.is_objectif_zero_co2 AS is_objectif_zero_co2_22, t13.position AS position_23, t13.age_min AS age_min_24, t13.age_max AS age_max_25, t13.is_sejour_location AS is_sejour_location_26, t13.is_sejour_court AS is_sejour_court_27, t13.notre_avis AS notre_avis_28, t13.tarifs AS tarifs_29, t13.places_count AS places_count_30, t13.legacy_id AS legacy_id_31, t13.intro AS intro_32, t13.price AS price_33, t13.duree AS duree_34, t13.encadrement AS encadrement_35, t13.nombre AS nombre_36, t13.duree_integer AS duree_integer_37, t13.tranport AS tranport_38, t13.transport AS transport_39, t13.compris AS compris_40, t13.noncompris AS noncompris_41, t13.information_complementaire AS information_complementaire_42, t13.url AS url_43, t13.sejour_type AS sejour_type_44, t13.video_link AS video_link_45, t13.activites_fiche_sejour AS activites_fiche_sejour_46, t13.lien_youtube AS lien_youtube_47, t13.location_id AS location_id_48, t13.tranche_age1_id AS tranche_age1_id_49, t13.tranche_age2_id AS tranche_age2_id_50 FROM sejour_session t0 INNER JOIN sejour t13 ON t0.sejour_id = t13.id WHERE t0.sejour_id = 136 ORDER BY t0.date_debut ASC;
40	2.03 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.code_gen AS code_gen_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.prix AS prix_6, t0.place_dispo AS place_dispo_7, t0.media_statut AS media_statut_8, t0.last_update AS last_update_9, t0.legacy_id AS legacy_id_10, t0.override_places_dispos AS override_places_dispos_11, t0.sejour_id AS sejour_id_12, t13.id AS id_14, t13.title AS title_15, t13.description AS description_16, t13.activites AS activites_17, t13.updated_date AS updated_date_18, t13.hebergement AS hebergement_19, t13.is_active AS is_active_20, t13.is_bientot AS is_bientot_21, t13.is_objectif_zero_co2 AS is_objectif_zero_co2_22, t13.position AS position_23, t13.age_min AS age_min_24, t13.age_max AS age_max_25, t13.is_sejour_location AS is_sejour_location_26, t13.is_sejour_court AS is_sejour_court_27, t13.notre_avis AS notre_avis_28, t13.tarifs AS tarifs_29, t13.places_count AS places_count_30, t13.legacy_id AS legacy_id_31, t13.intro AS intro_32, t13.price AS price_33, t13.duree AS duree_34, t13.encadrement AS encadrement_35, t13.nombre AS nombre_36, t13.duree_integer AS duree_integer_37, t13.tranport AS tranport_38, t13.transport AS transport_39, t13.compris AS compris_40, t13.noncompris AS noncompris_41, t13.information_complementaire AS information_complementaire_42, t13.url AS url_43, t13.sejour_type AS sejour_type_44, t13.video_link AS video_link_45, t13.activites_fiche_sejour AS activites_fiche_sejour_46, t13.lien_youtube AS lien_youtube_47, t13.location_id AS location_id_48, t13.tranche_age1_id AS tranche_age1_id_49, t13.tranche_age2_id AS tranche_age2_id_50 FROM sejour_session t0 INNER JOIN sejour t13 ON t0.sejour_id = t13.id WHERE t0.sejour_id = ? ORDER BY t0.date_debut ASC Parameters: [`137`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.code_gen AS code_gen_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.prix AS prix_6, t0.place_dispo AS place_dispo_7, t0.media_statut AS media_statut_8, t0.last_update AS last_update_9, t0.legacy_id AS legacy_id_10, t0.override_places_dispos AS override_places_dispos_11, t0.sejour_id AS sejour_id_12, t13.id AS id_14, t13.title AS title_15, t13.description AS description_16, t13.activites AS activites_17, t13.updated_date AS updated_date_18, t13.hebergement AS hebergement_19, t13.is_active AS is_active_20, t13.is_bientot AS is_bientot_21, t13.is_objectif_zero_co2 AS is_objectif_zero_co2_22, t13.position AS position_23, t13.age_min AS age_min_24, t13.age_max AS age_max_25, t13.is_sejour_location AS is_sejour_location_26, t13.is_sejour_court AS is_sejour_court_27, t13.notre_avis AS notre_avis_28, t13.tarifs AS tarifs_29, t13.places_count AS places_count_30, t13.legacy_id AS legacy_id_31, t13.intro AS intro_32, t13.price AS price_33, t13.duree AS duree_34, t13.encadrement AS encadrement_35, t13.nombre AS nombre_36, t13.duree_integer AS duree_integer_37, t13.tranport AS tranport_38, t13.transport AS transport_39, t13.compris AS compris_40, t13.noncompris AS noncompris_41, t13.information_complementaire AS information_complementaire_42, t13.url AS url_43, t13.sejour_type AS sejour_type_44, t13.video_link AS video_link_45, t13.activites_fiche_sejour AS activites_fiche_sejour_46, t13.lien_youtube AS lien_youtube_47, t13.location_id AS location_id_48, t13.tranche_age1_id AS tranche_age1_id_49, t13.tranche_age2_id AS tranche_age2_id_50 FROM sejour_session t0 INNER JOIN sejour t13 ON t0.sejour_id = t13.id WHERE t0.sejour_id = ? ORDER BY t0.date_debut ASC SELECT t0.id AS id_1, t0.code AS code_2, t0.code_gen AS code_gen_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.prix AS prix_6, t0.place_dispo AS place_dispo_7, t0.media_statut AS media_statut_8, t0.last_update AS last_update_9, t0.legacy_id AS legacy_id_10, t0.override_places_dispos AS override_places_dispos_11, t0.sejour_id AS sejour_id_12, t13.id AS id_14, t13.title AS title_15, t13.description AS description_16, t13.activites AS activites_17, t13.updated_date AS updated_date_18, t13.hebergement AS hebergement_19, t13.is_active AS is_active_20, t13.is_bientot AS is_bientot_21, t13.is_objectif_zero_co2 AS is_objectif_zero_co2_22, t13.position AS position_23, t13.age_min AS age_min_24, t13.age_max AS age_max_25, t13.is_sejour_location AS is_sejour_location_26, t13.is_sejour_court AS is_sejour_court_27, t13.notre_avis AS notre_avis_28, t13.tarifs AS tarifs_29, t13.places_count AS places_count_30, t13.legacy_id AS legacy_id_31, t13.intro AS intro_32, t13.price AS price_33, t13.duree AS duree_34, t13.encadrement AS encadrement_35, t13.nombre AS nombre_36, t13.duree_integer AS duree_integer_37, t13.tranport AS tranport_38, t13.transport AS transport_39, t13.compris AS compris_40, t13.noncompris AS noncompris_41, t13.information_complementaire AS information_complementaire_42, t13.url AS url_43, t13.sejour_type AS sejour_type_44, t13.video_link AS video_link_45, t13.activites_fiche_sejour AS activites_fiche_sejour_46, t13.lien_youtube AS lien_youtube_47, t13.location_id AS location_id_48, t13.tranche_age1_id AS tranche_age1_id_49, t13.tranche_age2_id AS tranche_age2_id_50 FROM sejour_session t0 INNER JOIN sejour t13 ON t0.sejour_id = t13.id WHERE t0.sejour_id = 137 ORDER BY t0.date_debut ASC;
41	2.64 ms	SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ? Parameters: [`1123`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ? SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = 1123;
42	0.37 ms	SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ? Parameters: [`1123`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ? SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = 1123;
43	0.66 ms	SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ? Parameters: [`1124`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ? SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = 1124;
44	0.30 ms	SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ? Parameters: [`1124`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ? SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = 1124;
45	0.46 ms	SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ? Parameters: [`1125`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ? SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = 1125;
46	0.21 ms	SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ? Parameters: [`1125`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ? SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = 1125;
47	0.25 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 INNER JOIN sejour_saison ON t0.id = sejour_saison.saison_id WHERE sejour_saison.sejour_id = ? Parameters: [`68`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 INNER JOIN sejour_saison ON t0.id = sejour_saison.saison_id WHERE sejour_saison.sejour_id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 INNER JOIN sejour_saison ON t0.id = sejour_saison.saison_id WHERE sejour_saison.sejour_id = 68;
48	0.30 ms	SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.slug AS slug_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.flag AS flag_9 FROM country t0 INNER JOIN sejour_country ON t0.id = sejour_country.country_id WHERE sejour_country.sejour_id = ? Parameters: [`68`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.slug AS slug_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.flag AS flag_9 FROM country t0 INNER JOIN sejour_country ON t0.id = sejour_country.country_id WHERE sejour_country.sejour_id = ? SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.slug AS slug_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.flag AS flag_9 FROM country t0 INNER JOIN sejour_country ON t0.id = sejour_country.country_id WHERE sejour_country.sejour_id = 68;
49	0.39 ms	SELECT t0.id AS id_1, t0.street AS street_2, t0.zip_code AS zip_code_3, t0.city AS city_4, t0.house_number AS house_number_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.country AS country_8, t0.title AS title_9, t0.telephone AS telephone_10, t11.id AS id_12, t11.title AS title_13, t11.description AS description_14, t11.activites AS activites_15, t11.updated_date AS updated_date_16, t11.hebergement AS hebergement_17, t11.is_active AS is_active_18, t11.is_bientot AS is_bientot_19, t11.is_objectif_zero_co2 AS is_objectif_zero_co2_20, t11.position AS position_21, t11.age_min AS age_min_22, t11.age_max AS age_max_23, t11.is_sejour_location AS is_sejour_location_24, t11.is_sejour_court AS is_sejour_court_25, t11.notre_avis AS notre_avis_26, t11.tarifs AS tarifs_27, t11.places_count AS places_count_28, t11.legacy_id AS legacy_id_29, t11.intro AS intro_30, t11.price AS price_31, t11.duree AS duree_32, t11.encadrement AS encadrement_33, t11.nombre AS nombre_34, t11.duree_integer AS duree_integer_35, t11.tranport AS tranport_36, t11.transport AS transport_37, t11.compris AS compris_38, t11.noncompris AS noncompris_39, t11.information_complementaire AS information_complementaire_40, t11.url AS url_41, t11.sejour_type AS sejour_type_42, t11.video_link AS video_link_43, t11.activites_fiche_sejour AS activites_fiche_sejour_44, t11.lien_youtube AS lien_youtube_45, t11.location_id AS location_id_46, t11.tranche_age1_id AS tranche_age1_id_47, t11.tranche_age2_id AS tranche_age2_id_48, t0.departement_id AS departement_id_49 FROM location t0 LEFT JOIN sejour t11 ON t11.location_id = t0.id WHERE t0.id = ? Parameters: [`4826`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.street AS street_2, t0.zip_code AS zip_code_3, t0.city AS city_4, t0.house_number AS house_number_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.country AS country_8, t0.title AS title_9, t0.telephone AS telephone_10, t11.id AS id_12, t11.title AS title_13, t11.description AS description_14, t11.activites AS activites_15, t11.updated_date AS updated_date_16, t11.hebergement AS hebergement_17, t11.is_active AS is_active_18, t11.is_bientot AS is_bientot_19, t11.is_objectif_zero_co2 AS is_objectif_zero_co2_20, t11.position AS position_21, t11.age_min AS age_min_22, t11.age_max AS age_max_23, t11.is_sejour_location AS is_sejour_location_24, t11.is_sejour_court AS is_sejour_court_25, t11.notre_avis AS notre_avis_26, t11.tarifs AS tarifs_27, t11.places_count AS places_count_28, t11.legacy_id AS legacy_id_29, t11.intro AS intro_30, t11.price AS price_31, t11.duree AS duree_32, t11.encadrement AS encadrement_33, t11.nombre AS nombre_34, t11.duree_integer AS duree_integer_35, t11.tranport AS tranport_36, t11.transport AS transport_37, t11.compris AS compris_38, t11.noncompris AS noncompris_39, t11.information_complementaire AS information_complementaire_40, t11.url AS url_41, t11.sejour_type AS sejour_type_42, t11.video_link AS video_link_43, t11.activites_fiche_sejour AS activites_fiche_sejour_44, t11.lien_youtube AS lien_youtube_45, t11.location_id AS location_id_46, t11.tranche_age1_id AS tranche_age1_id_47, t11.tranche_age2_id AS tranche_age2_id_48, t0.departement_id AS departement_id_49 FROM location t0 LEFT JOIN sejour t11 ON t11.location_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.street AS street_2, t0.zip_code AS zip_code_3, t0.city AS city_4, t0.house_number AS house_number_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.country AS country_8, t0.title AS title_9, t0.telephone AS telephone_10, t11.id AS id_12, t11.title AS title_13, t11.description AS description_14, t11.activites AS activites_15, t11.updated_date AS updated_date_16, t11.hebergement AS hebergement_17, t11.is_active AS is_active_18, t11.is_bientot AS is_bientot_19, t11.is_objectif_zero_co2 AS is_objectif_zero_co2_20, t11.position AS position_21, t11.age_min AS age_min_22, t11.age_max AS age_max_23, t11.is_sejour_location AS is_sejour_location_24, t11.is_sejour_court AS is_sejour_court_25, t11.notre_avis AS notre_avis_26, t11.tarifs AS tarifs_27, t11.places_count AS places_count_28, t11.legacy_id AS legacy_id_29, t11.intro AS intro_30, t11.price AS price_31, t11.duree AS duree_32, t11.encadrement AS encadrement_33, t11.nombre AS nombre_34, t11.duree_integer AS duree_integer_35, t11.tranport AS tranport_36, t11.transport AS transport_37, t11.compris AS compris_38, t11.noncompris AS noncompris_39, t11.information_complementaire AS information_complementaire_40, t11.url AS url_41, t11.sejour_type AS sejour_type_42, t11.video_link AS video_link_43, t11.activites_fiche_sejour AS activites_fiche_sejour_44, t11.lien_youtube AS lien_youtube_45, t11.location_id AS location_id_46, t11.tranche_age1_id AS tranche_age1_id_47, t11.tranche_age2_id AS tranche_age2_id_48, t0.departement_id AS departement_id_49 FROM location t0 LEFT JOIN sejour t11 ON t11.location_id = t0.id WHERE t0.id = 4826;
50	0.19 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.country_id AS country_id_4, t0.media_id AS media_id_5 FROM departement t0 WHERE t0.id = ? Parameters: [`75`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.country_id AS country_id_4, t0.media_id AS media_id_5 FROM departement t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.country_id AS country_id_4, t0.media_id AS media_id_5 FROM departement t0 WHERE t0.id = 75;
51	0.93 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.file_path AS file_path_4, t0.attributes AS attributes_5, t0.alt_attribute AS alt_attribute_6, t0.is_standalone AS is_standalone_7, t0.is_migrated AS is_migrated_8, t0.position AS position_9, t0.updated_date AS updated_date_10, t0.legacy_id AS legacy_id_11, t0.is_validated AS is_validated_12, t0.rejected_reason AS rejected_reason_13, t0.media_categorie_id AS media_categorie_id_14, t15.id AS id_16, t15.name AS name_17, t15.allowed_format AS allowed_format_18, t15.type AS type_19, t15.is_mandatory AS is_mandatory_20, t15.is_editable_by_director AS is_editable_by_director_21, t15.has_fill_in_process AS has_fill_in_process_22, t15.has_to_be_returned AS has_to_be_returned_23, t15.has_prio AS has_prio_24, t15.published_in AS published_in_25, t15.modele AS modele_26, t15.fields AS fields_27, t15.is_unique AS is_unique_28, t15.is_deletable AS is_deletable_29, t15.is_espace_parent AS is_espace_parent_30, t15.is_espace_directeur AS is_espace_directeur_31, t15.is_private AS is_private_32, t15.is_factory AS is_factory_33, t15.is_in_admin AS is_in_admin_34, t15.modele_entity AS modele_entity_35, t15.has_to_be_validate_by_admin AS has_to_be_validate_by_admin_36, t15.referent AS referent_37, t15.interval AS interval_38, t15.interaction_template_id AS interaction_template_id_39, t0.media_parent_id AS media_parent_id_40, t41.id AS id_42, t41.name AS name_43, t41.description AS description_44, t41.file_path AS file_path_45, t41.attributes AS attributes_46, t41.alt_attribute AS alt_attribute_47, t41.is_standalone AS is_standalone_48, t41.is_migrated AS is_migrated_49, t41.position AS position_50, t41.updated_date AS updated_date_51, t41.legacy_id AS legacy_id_52, t41.is_validated AS is_validated_53, t41.rejected_reason AS rejected_reason_54, t41.media_categorie_id AS media_categorie_id_55, t41.media_parent_id AS media_parent_id_56, t41.sejour_id AS sejour_id_57, t41.candidature_id AS candidature_id_58, t41.contact_id AS contact_id_59, t41.sejour_session_id AS sejour_session_id_60, t41.inscription_id AS inscription_id_61, t41.saison_id AS saison_id_62, t0.sejour_id AS sejour_id_63, t0.candidature_id AS candidature_id_64, t0.contact_id AS contact_id_65, t0.sejour_session_id AS sejour_session_id_66, t0.inscription_id AS inscription_id_67, t0.saison_id AS saison_id_68 FROM media t0 INNER JOIN media_categorie t15 ON t0.media_categorie_id = t15.id LEFT JOIN media t41 ON t0.media_parent_id = t41.id WHERE t0.sejour_id = ? Parameters: [`136`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.file_path AS file_path_4, t0.attributes AS attributes_5, t0.alt_attribute AS alt_attribute_6, t0.is_standalone AS is_standalone_7, t0.is_migrated AS is_migrated_8, t0.position AS position_9, t0.updated_date AS updated_date_10, t0.legacy_id AS legacy_id_11, t0.is_validated AS is_validated_12, t0.rejected_reason AS rejected_reason_13, t0.media_categorie_id AS media_categorie_id_14, t15.id AS id_16, t15.name AS name_17, t15.allowed_format AS allowed_format_18, t15.type AS type_19, t15.is_mandatory AS is_mandatory_20, t15.is_editable_by_director AS is_editable_by_director_21, t15.has_fill_in_process AS has_fill_in_process_22, t15.has_to_be_returned AS has_to_be_returned_23, t15.has_prio AS has_prio_24, t15.published_in AS published_in_25, t15.modele AS modele_26, t15.fields AS fields_27, t15.is_unique AS is_unique_28, t15.is_deletable AS is_deletable_29, t15.is_espace_parent AS is_espace_parent_30, t15.is_espace_directeur AS is_espace_directeur_31, t15.is_private AS is_private_32, t15.is_factory AS is_factory_33, t15.is_in_admin AS is_in_admin_34, t15.modele_entity AS modele_entity_35, t15.has_to_be_validate_by_admin AS has_to_be_validate_by_admin_36, t15.referent AS referent_37, t15.interval AS interval_38, t15.interaction_template_id AS interaction_template_id_39, t0.media_parent_id AS media_parent_id_40, t41.id AS id_42, t41.name AS name_43, t41.description AS description_44, t41.file_path AS file_path_45, t41.attributes AS attributes_46, t41.alt_attribute AS alt_attribute_47, t41.is_standalone AS is_standalone_48, t41.is_migrated AS is_migrated_49, t41.position AS position_50, t41.updated_date AS updated_date_51, t41.legacy_id AS legacy_id_52, t41.is_validated AS is_validated_53, t41.rejected_reason AS rejected_reason_54, t41.media_categorie_id AS media_categorie_id_55, t41.media_parent_id AS media_parent_id_56, t41.sejour_id AS sejour_id_57, t41.candidature_id AS candidature_id_58, t41.contact_id AS contact_id_59, t41.sejour_session_id AS sejour_session_id_60, t41.inscription_id AS inscription_id_61, t41.saison_id AS saison_id_62, t0.sejour_id AS sejour_id_63, t0.candidature_id AS candidature_id_64, t0.contact_id AS contact_id_65, t0.sejour_session_id AS sejour_session_id_66, t0.inscription_id AS inscription_id_67, t0.saison_id AS saison_id_68 FROM media t0 INNER JOIN media_categorie t15 ON t0.media_categorie_id = t15.id LEFT JOIN media t41 ON t0.media_parent_id = t41.id WHERE t0.sejour_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.file_path AS file_path_4, t0.attributes AS attributes_5, t0.alt_attribute AS alt_attribute_6, t0.is_standalone AS is_standalone_7, t0.is_migrated AS is_migrated_8, t0.position AS position_9, t0.updated_date AS updated_date_10, t0.legacy_id AS legacy_id_11, t0.is_validated AS is_validated_12, t0.rejected_reason AS rejected_reason_13, t0.media_categorie_id AS media_categorie_id_14, t15.id AS id_16, t15.name AS name_17, t15.allowed_format AS allowed_format_18, t15.type AS type_19, t15.is_mandatory AS is_mandatory_20, t15.is_editable_by_director AS is_editable_by_director_21, t15.has_fill_in_process AS has_fill_in_process_22, t15.has_to_be_returned AS has_to_be_returned_23, t15.has_prio AS has_prio_24, t15.published_in AS published_in_25, t15.modele AS modele_26, t15.fields AS fields_27, t15.is_unique AS is_unique_28, t15.is_deletable AS is_deletable_29, t15.is_espace_parent AS is_espace_parent_30, t15.is_espace_directeur AS is_espace_directeur_31, t15.is_private AS is_private_32, t15.is_factory AS is_factory_33, t15.is_in_admin AS is_in_admin_34, t15.modele_entity AS modele_entity_35, t15.has_to_be_validate_by_admin AS has_to_be_validate_by_admin_36, t15.referent AS referent_37, t15.interval AS interval_38, t15.interaction_template_id AS interaction_template_id_39, t0.media_parent_id AS media_parent_id_40, t41.id AS id_42, t41.name AS name_43, t41.description AS description_44, t41.file_path AS file_path_45, t41.attributes AS attributes_46, t41.alt_attribute AS alt_attribute_47, t41.is_standalone AS is_standalone_48, t41.is_migrated AS is_migrated_49, t41.position AS position_50, t41.updated_date AS updated_date_51, t41.legacy_id AS legacy_id_52, t41.is_validated AS is_validated_53, t41.rejected_reason AS rejected_reason_54, t41.media_categorie_id AS media_categorie_id_55, t41.media_parent_id AS media_parent_id_56, t41.sejour_id AS sejour_id_57, t41.candidature_id AS candidature_id_58, t41.contact_id AS contact_id_59, t41.sejour_session_id AS sejour_session_id_60, t41.inscription_id AS inscription_id_61, t41.saison_id AS saison_id_62, t0.sejour_id AS sejour_id_63, t0.candidature_id AS candidature_id_64, t0.contact_id AS contact_id_65, t0.sejour_session_id AS sejour_session_id_66, t0.inscription_id AS inscription_id_67, t0.saison_id AS saison_id_68 FROM media t0 INNER JOIN media_categorie t15 ON t0.media_categorie_id = t15.id LEFT JOIN media t41 ON t0.media_parent_id = t41.id WHERE t0.sejour_id = 136;
52	2.30 ms	SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ? Parameters: [`1129`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ? SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = 1129;
53	0.26 ms	SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ? Parameters: [`1129`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ? SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = 1129;
54	0.37 ms	SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ? Parameters: [`1130`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ? SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = 1130;
55	0.20 ms	SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ? Parameters: [`1130`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ? SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = 1130;
56	0.31 ms	SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ? Parameters: [`1131`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ? SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = 1131;
57	0.18 ms	SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ? Parameters: [`1131`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ? SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = 1131;
58	0.35 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 INNER JOIN sejour_saison ON t0.id = sejour_saison.saison_id WHERE sejour_saison.sejour_id = ? Parameters: [`136`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 INNER JOIN sejour_saison ON t0.id = sejour_saison.saison_id WHERE sejour_saison.sejour_id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 INNER JOIN sejour_saison ON t0.id = sejour_saison.saison_id WHERE sejour_saison.sejour_id = 136;
59	0.31 ms	SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.slug AS slug_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.flag AS flag_9 FROM country t0 INNER JOIN sejour_country ON t0.id = sejour_country.country_id WHERE sejour_country.sejour_id = ? Parameters: [`136`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.slug AS slug_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.flag AS flag_9 FROM country t0 INNER JOIN sejour_country ON t0.id = sejour_country.country_id WHERE sejour_country.sejour_id = ? SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.slug AS slug_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.flag AS flag_9 FROM country t0 INNER JOIN sejour_country ON t0.id = sejour_country.country_id WHERE sejour_country.sejour_id = 136;
60	0.37 ms	SELECT t0.id AS id_1, t0.street AS street_2, t0.zip_code AS zip_code_3, t0.city AS city_4, t0.house_number AS house_number_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.country AS country_8, t0.title AS title_9, t0.telephone AS telephone_10, t11.id AS id_12, t11.title AS title_13, t11.description AS description_14, t11.activites AS activites_15, t11.updated_date AS updated_date_16, t11.hebergement AS hebergement_17, t11.is_active AS is_active_18, t11.is_bientot AS is_bientot_19, t11.is_objectif_zero_co2 AS is_objectif_zero_co2_20, t11.position AS position_21, t11.age_min AS age_min_22, t11.age_max AS age_max_23, t11.is_sejour_location AS is_sejour_location_24, t11.is_sejour_court AS is_sejour_court_25, t11.notre_avis AS notre_avis_26, t11.tarifs AS tarifs_27, t11.places_count AS places_count_28, t11.legacy_id AS legacy_id_29, t11.intro AS intro_30, t11.price AS price_31, t11.duree AS duree_32, t11.encadrement AS encadrement_33, t11.nombre AS nombre_34, t11.duree_integer AS duree_integer_35, t11.tranport AS tranport_36, t11.transport AS transport_37, t11.compris AS compris_38, t11.noncompris AS noncompris_39, t11.information_complementaire AS information_complementaire_40, t11.url AS url_41, t11.sejour_type AS sejour_type_42, t11.video_link AS video_link_43, t11.activites_fiche_sejour AS activites_fiche_sejour_44, t11.lien_youtube AS lien_youtube_45, t11.location_id AS location_id_46, t11.tranche_age1_id AS tranche_age1_id_47, t11.tranche_age2_id AS tranche_age2_id_48, t0.departement_id AS departement_id_49 FROM location t0 LEFT JOIN sejour t11 ON t11.location_id = t0.id WHERE t0.id = ? Parameters: [`4894`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.street AS street_2, t0.zip_code AS zip_code_3, t0.city AS city_4, t0.house_number AS house_number_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.country AS country_8, t0.title AS title_9, t0.telephone AS telephone_10, t11.id AS id_12, t11.title AS title_13, t11.description AS description_14, t11.activites AS activites_15, t11.updated_date AS updated_date_16, t11.hebergement AS hebergement_17, t11.is_active AS is_active_18, t11.is_bientot AS is_bientot_19, t11.is_objectif_zero_co2 AS is_objectif_zero_co2_20, t11.position AS position_21, t11.age_min AS age_min_22, t11.age_max AS age_max_23, t11.is_sejour_location AS is_sejour_location_24, t11.is_sejour_court AS is_sejour_court_25, t11.notre_avis AS notre_avis_26, t11.tarifs AS tarifs_27, t11.places_count AS places_count_28, t11.legacy_id AS legacy_id_29, t11.intro AS intro_30, t11.price AS price_31, t11.duree AS duree_32, t11.encadrement AS encadrement_33, t11.nombre AS nombre_34, t11.duree_integer AS duree_integer_35, t11.tranport AS tranport_36, t11.transport AS transport_37, t11.compris AS compris_38, t11.noncompris AS noncompris_39, t11.information_complementaire AS information_complementaire_40, t11.url AS url_41, t11.sejour_type AS sejour_type_42, t11.video_link AS video_link_43, t11.activites_fiche_sejour AS activites_fiche_sejour_44, t11.lien_youtube AS lien_youtube_45, t11.location_id AS location_id_46, t11.tranche_age1_id AS tranche_age1_id_47, t11.tranche_age2_id AS tranche_age2_id_48, t0.departement_id AS departement_id_49 FROM location t0 LEFT JOIN sejour t11 ON t11.location_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.street AS street_2, t0.zip_code AS zip_code_3, t0.city AS city_4, t0.house_number AS house_number_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.country AS country_8, t0.title AS title_9, t0.telephone AS telephone_10, t11.id AS id_12, t11.title AS title_13, t11.description AS description_14, t11.activites AS activites_15, t11.updated_date AS updated_date_16, t11.hebergement AS hebergement_17, t11.is_active AS is_active_18, t11.is_bientot AS is_bientot_19, t11.is_objectif_zero_co2 AS is_objectif_zero_co2_20, t11.position AS position_21, t11.age_min AS age_min_22, t11.age_max AS age_max_23, t11.is_sejour_location AS is_sejour_location_24, t11.is_sejour_court AS is_sejour_court_25, t11.notre_avis AS notre_avis_26, t11.tarifs AS tarifs_27, t11.places_count AS places_count_28, t11.legacy_id AS legacy_id_29, t11.intro AS intro_30, t11.price AS price_31, t11.duree AS duree_32, t11.encadrement AS encadrement_33, t11.nombre AS nombre_34, t11.duree_integer AS duree_integer_35, t11.tranport AS tranport_36, t11.transport AS transport_37, t11.compris AS compris_38, t11.noncompris AS noncompris_39, t11.information_complementaire AS information_complementaire_40, t11.url AS url_41, t11.sejour_type AS sejour_type_42, t11.video_link AS video_link_43, t11.activites_fiche_sejour AS activites_fiche_sejour_44, t11.lien_youtube AS lien_youtube_45, t11.location_id AS location_id_46, t11.tranche_age1_id AS tranche_age1_id_47, t11.tranche_age2_id AS tranche_age2_id_48, t0.departement_id AS departement_id_49 FROM location t0 LEFT JOIN sejour t11 ON t11.location_id = t0.id WHERE t0.id = 4894;
61	0.79 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.file_path AS file_path_4, t0.attributes AS attributes_5, t0.alt_attribute AS alt_attribute_6, t0.is_standalone AS is_standalone_7, t0.is_migrated AS is_migrated_8, t0.position AS position_9, t0.updated_date AS updated_date_10, t0.legacy_id AS legacy_id_11, t0.is_validated AS is_validated_12, t0.rejected_reason AS rejected_reason_13, t0.media_categorie_id AS media_categorie_id_14, t15.id AS id_16, t15.name AS name_17, t15.allowed_format AS allowed_format_18, t15.type AS type_19, t15.is_mandatory AS is_mandatory_20, t15.is_editable_by_director AS is_editable_by_director_21, t15.has_fill_in_process AS has_fill_in_process_22, t15.has_to_be_returned AS has_to_be_returned_23, t15.has_prio AS has_prio_24, t15.published_in AS published_in_25, t15.modele AS modele_26, t15.fields AS fields_27, t15.is_unique AS is_unique_28, t15.is_deletable AS is_deletable_29, t15.is_espace_parent AS is_espace_parent_30, t15.is_espace_directeur AS is_espace_directeur_31, t15.is_private AS is_private_32, t15.is_factory AS is_factory_33, t15.is_in_admin AS is_in_admin_34, t15.modele_entity AS modele_entity_35, t15.has_to_be_validate_by_admin AS has_to_be_validate_by_admin_36, t15.referent AS referent_37, t15.interval AS interval_38, t15.interaction_template_id AS interaction_template_id_39, t0.media_parent_id AS media_parent_id_40, t41.id AS id_42, t41.name AS name_43, t41.description AS description_44, t41.file_path AS file_path_45, t41.attributes AS attributes_46, t41.alt_attribute AS alt_attribute_47, t41.is_standalone AS is_standalone_48, t41.is_migrated AS is_migrated_49, t41.position AS position_50, t41.updated_date AS updated_date_51, t41.legacy_id AS legacy_id_52, t41.is_validated AS is_validated_53, t41.rejected_reason AS rejected_reason_54, t41.media_categorie_id AS media_categorie_id_55, t41.media_parent_id AS media_parent_id_56, t41.sejour_id AS sejour_id_57, t41.candidature_id AS candidature_id_58, t41.contact_id AS contact_id_59, t41.sejour_session_id AS sejour_session_id_60, t41.inscription_id AS inscription_id_61, t41.saison_id AS saison_id_62, t0.sejour_id AS sejour_id_63, t0.candidature_id AS candidature_id_64, t0.contact_id AS contact_id_65, t0.sejour_session_id AS sejour_session_id_66, t0.inscription_id AS inscription_id_67, t0.saison_id AS saison_id_68 FROM media t0 INNER JOIN media_categorie t15 ON t0.media_categorie_id = t15.id LEFT JOIN media t41 ON t0.media_parent_id = t41.id WHERE t0.sejour_id = ? Parameters: [`137`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.file_path AS file_path_4, t0.attributes AS attributes_5, t0.alt_attribute AS alt_attribute_6, t0.is_standalone AS is_standalone_7, t0.is_migrated AS is_migrated_8, t0.position AS position_9, t0.updated_date AS updated_date_10, t0.legacy_id AS legacy_id_11, t0.is_validated AS is_validated_12, t0.rejected_reason AS rejected_reason_13, t0.media_categorie_id AS media_categorie_id_14, t15.id AS id_16, t15.name AS name_17, t15.allowed_format AS allowed_format_18, t15.type AS type_19, t15.is_mandatory AS is_mandatory_20, t15.is_editable_by_director AS is_editable_by_director_21, t15.has_fill_in_process AS has_fill_in_process_22, t15.has_to_be_returned AS has_to_be_returned_23, t15.has_prio AS has_prio_24, t15.published_in AS published_in_25, t15.modele AS modele_26, t15.fields AS fields_27, t15.is_unique AS is_unique_28, t15.is_deletable AS is_deletable_29, t15.is_espace_parent AS is_espace_parent_30, t15.is_espace_directeur AS is_espace_directeur_31, t15.is_private AS is_private_32, t15.is_factory AS is_factory_33, t15.is_in_admin AS is_in_admin_34, t15.modele_entity AS modele_entity_35, t15.has_to_be_validate_by_admin AS has_to_be_validate_by_admin_36, t15.referent AS referent_37, t15.interval AS interval_38, t15.interaction_template_id AS interaction_template_id_39, t0.media_parent_id AS media_parent_id_40, t41.id AS id_42, t41.name AS name_43, t41.description AS description_44, t41.file_path AS file_path_45, t41.attributes AS attributes_46, t41.alt_attribute AS alt_attribute_47, t41.is_standalone AS is_standalone_48, t41.is_migrated AS is_migrated_49, t41.position AS position_50, t41.updated_date AS updated_date_51, t41.legacy_id AS legacy_id_52, t41.is_validated AS is_validated_53, t41.rejected_reason AS rejected_reason_54, t41.media_categorie_id AS media_categorie_id_55, t41.media_parent_id AS media_parent_id_56, t41.sejour_id AS sejour_id_57, t41.candidature_id AS candidature_id_58, t41.contact_id AS contact_id_59, t41.sejour_session_id AS sejour_session_id_60, t41.inscription_id AS inscription_id_61, t41.saison_id AS saison_id_62, t0.sejour_id AS sejour_id_63, t0.candidature_id AS candidature_id_64, t0.contact_id AS contact_id_65, t0.sejour_session_id AS sejour_session_id_66, t0.inscription_id AS inscription_id_67, t0.saison_id AS saison_id_68 FROM media t0 INNER JOIN media_categorie t15 ON t0.media_categorie_id = t15.id LEFT JOIN media t41 ON t0.media_parent_id = t41.id WHERE t0.sejour_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.file_path AS file_path_4, t0.attributes AS attributes_5, t0.alt_attribute AS alt_attribute_6, t0.is_standalone AS is_standalone_7, t0.is_migrated AS is_migrated_8, t0.position AS position_9, t0.updated_date AS updated_date_10, t0.legacy_id AS legacy_id_11, t0.is_validated AS is_validated_12, t0.rejected_reason AS rejected_reason_13, t0.media_categorie_id AS media_categorie_id_14, t15.id AS id_16, t15.name AS name_17, t15.allowed_format AS allowed_format_18, t15.type AS type_19, t15.is_mandatory AS is_mandatory_20, t15.is_editable_by_director AS is_editable_by_director_21, t15.has_fill_in_process AS has_fill_in_process_22, t15.has_to_be_returned AS has_to_be_returned_23, t15.has_prio AS has_prio_24, t15.published_in AS published_in_25, t15.modele AS modele_26, t15.fields AS fields_27, t15.is_unique AS is_unique_28, t15.is_deletable AS is_deletable_29, t15.is_espace_parent AS is_espace_parent_30, t15.is_espace_directeur AS is_espace_directeur_31, t15.is_private AS is_private_32, t15.is_factory AS is_factory_33, t15.is_in_admin AS is_in_admin_34, t15.modele_entity AS modele_entity_35, t15.has_to_be_validate_by_admin AS has_to_be_validate_by_admin_36, t15.referent AS referent_37, t15.interval AS interval_38, t15.interaction_template_id AS interaction_template_id_39, t0.media_parent_id AS media_parent_id_40, t41.id AS id_42, t41.name AS name_43, t41.description AS description_44, t41.file_path AS file_path_45, t41.attributes AS attributes_46, t41.alt_attribute AS alt_attribute_47, t41.is_standalone AS is_standalone_48, t41.is_migrated AS is_migrated_49, t41.position AS position_50, t41.updated_date AS updated_date_51, t41.legacy_id AS legacy_id_52, t41.is_validated AS is_validated_53, t41.rejected_reason AS rejected_reason_54, t41.media_categorie_id AS media_categorie_id_55, t41.media_parent_id AS media_parent_id_56, t41.sejour_id AS sejour_id_57, t41.candidature_id AS candidature_id_58, t41.contact_id AS contact_id_59, t41.sejour_session_id AS sejour_session_id_60, t41.inscription_id AS inscription_id_61, t41.saison_id AS saison_id_62, t0.sejour_id AS sejour_id_63, t0.candidature_id AS candidature_id_64, t0.contact_id AS contact_id_65, t0.sejour_session_id AS sejour_session_id_66, t0.inscription_id AS inscription_id_67, t0.saison_id AS saison_id_68 FROM media t0 INNER JOIN media_categorie t15 ON t0.media_categorie_id = t15.id LEFT JOIN media t41 ON t0.media_parent_id = t41.id WHERE t0.sejour_id = 137;
62	2.41 ms	SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ? Parameters: [`1126`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ? SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = 1126;
63	0.29 ms	SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ? Parameters: [`1126`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ? SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = 1126;
64	0.59 ms	SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ? Parameters: [`1127`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ? SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = 1127;
65	0.34 ms	SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ? Parameters: [`1127`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ? SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = 1127;
66	0.45 ms	SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.enterprise_option_sejour_session_id = ? Parameters: [`4043`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.enterprise_option_sejour_session_id = ? SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.enterprise_option_sejour_session_id = 4043;
67	0.58 ms	SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ? Parameters: [`1128`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ? SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = 1128;
68	0.29 ms	SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ? Parameters: [`1128`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ? SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = 1128;
69	0.25 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 INNER JOIN sejour_saison ON t0.id = sejour_saison.saison_id WHERE sejour_saison.sejour_id = ? Parameters: [`137`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 INNER JOIN sejour_saison ON t0.id = sejour_saison.saison_id WHERE sejour_saison.sejour_id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 INNER JOIN sejour_saison ON t0.id = sejour_saison.saison_id WHERE sejour_saison.sejour_id = 137;
70	0.27 ms	SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.slug AS slug_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.flag AS flag_9 FROM country t0 INNER JOIN sejour_country ON t0.id = sejour_country.country_id WHERE sejour_country.sejour_id = ? Parameters: [`137`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.slug AS slug_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.flag AS flag_9 FROM country t0 INNER JOIN sejour_country ON t0.id = sejour_country.country_id WHERE sejour_country.sejour_id = ? SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.slug AS slug_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.flag AS flag_9 FROM country t0 INNER JOIN sejour_country ON t0.id = sejour_country.country_id WHERE sejour_country.sejour_id = 137;
71	0.38 ms	SELECT t0.id AS id_1, t0.street AS street_2, t0.zip_code AS zip_code_3, t0.city AS city_4, t0.house_number AS house_number_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.country AS country_8, t0.title AS title_9, t0.telephone AS telephone_10, t11.id AS id_12, t11.title AS title_13, t11.description AS description_14, t11.activites AS activites_15, t11.updated_date AS updated_date_16, t11.hebergement AS hebergement_17, t11.is_active AS is_active_18, t11.is_bientot AS is_bientot_19, t11.is_objectif_zero_co2 AS is_objectif_zero_co2_20, t11.position AS position_21, t11.age_min AS age_min_22, t11.age_max AS age_max_23, t11.is_sejour_location AS is_sejour_location_24, t11.is_sejour_court AS is_sejour_court_25, t11.notre_avis AS notre_avis_26, t11.tarifs AS tarifs_27, t11.places_count AS places_count_28, t11.legacy_id AS legacy_id_29, t11.intro AS intro_30, t11.price AS price_31, t11.duree AS duree_32, t11.encadrement AS encadrement_33, t11.nombre AS nombre_34, t11.duree_integer AS duree_integer_35, t11.tranport AS tranport_36, t11.transport AS transport_37, t11.compris AS compris_38, t11.noncompris AS noncompris_39, t11.information_complementaire AS information_complementaire_40, t11.url AS url_41, t11.sejour_type AS sejour_type_42, t11.video_link AS video_link_43, t11.activites_fiche_sejour AS activites_fiche_sejour_44, t11.lien_youtube AS lien_youtube_45, t11.location_id AS location_id_46, t11.tranche_age1_id AS tranche_age1_id_47, t11.tranche_age2_id AS tranche_age2_id_48, t0.departement_id AS departement_id_49 FROM location t0 LEFT JOIN sejour t11 ON t11.location_id = t0.id WHERE t0.id = ? Parameters: [`4895`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.street AS street_2, t0.zip_code AS zip_code_3, t0.city AS city_4, t0.house_number AS house_number_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.country AS country_8, t0.title AS title_9, t0.telephone AS telephone_10, t11.id AS id_12, t11.title AS title_13, t11.description AS description_14, t11.activites AS activites_15, t11.updated_date AS updated_date_16, t11.hebergement AS hebergement_17, t11.is_active AS is_active_18, t11.is_bientot AS is_bientot_19, t11.is_objectif_zero_co2 AS is_objectif_zero_co2_20, t11.position AS position_21, t11.age_min AS age_min_22, t11.age_max AS age_max_23, t11.is_sejour_location AS is_sejour_location_24, t11.is_sejour_court AS is_sejour_court_25, t11.notre_avis AS notre_avis_26, t11.tarifs AS tarifs_27, t11.places_count AS places_count_28, t11.legacy_id AS legacy_id_29, t11.intro AS intro_30, t11.price AS price_31, t11.duree AS duree_32, t11.encadrement AS encadrement_33, t11.nombre AS nombre_34, t11.duree_integer AS duree_integer_35, t11.tranport AS tranport_36, t11.transport AS transport_37, t11.compris AS compris_38, t11.noncompris AS noncompris_39, t11.information_complementaire AS information_complementaire_40, t11.url AS url_41, t11.sejour_type AS sejour_type_42, t11.video_link AS video_link_43, t11.activites_fiche_sejour AS activites_fiche_sejour_44, t11.lien_youtube AS lien_youtube_45, t11.location_id AS location_id_46, t11.tranche_age1_id AS tranche_age1_id_47, t11.tranche_age2_id AS tranche_age2_id_48, t0.departement_id AS departement_id_49 FROM location t0 LEFT JOIN sejour t11 ON t11.location_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.street AS street_2, t0.zip_code AS zip_code_3, t0.city AS city_4, t0.house_number AS house_number_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.country AS country_8, t0.title AS title_9, t0.telephone AS telephone_10, t11.id AS id_12, t11.title AS title_13, t11.description AS description_14, t11.activites AS activites_15, t11.updated_date AS updated_date_16, t11.hebergement AS hebergement_17, t11.is_active AS is_active_18, t11.is_bientot AS is_bientot_19, t11.is_objectif_zero_co2 AS is_objectif_zero_co2_20, t11.position AS position_21, t11.age_min AS age_min_22, t11.age_max AS age_max_23, t11.is_sejour_location AS is_sejour_location_24, t11.is_sejour_court AS is_sejour_court_25, t11.notre_avis AS notre_avis_26, t11.tarifs AS tarifs_27, t11.places_count AS places_count_28, t11.legacy_id AS legacy_id_29, t11.intro AS intro_30, t11.price AS price_31, t11.duree AS duree_32, t11.encadrement AS encadrement_33, t11.nombre AS nombre_34, t11.duree_integer AS duree_integer_35, t11.tranport AS tranport_36, t11.transport AS transport_37, t11.compris AS compris_38, t11.noncompris AS noncompris_39, t11.information_complementaire AS information_complementaire_40, t11.url AS url_41, t11.sejour_type AS sejour_type_42, t11.video_link AS video_link_43, t11.activites_fiche_sejour AS activites_fiche_sejour_44, t11.lien_youtube AS lien_youtube_45, t11.location_id AS location_id_46, t11.tranche_age1_id AS tranche_age1_id_47, t11.tranche_age2_id AS tranche_age2_id_48, t0.departement_id AS departement_id_49 FROM location t0 LEFT JOIN sejour t11 ON t11.location_id = t0.id WHERE t0.id = 4895;

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\Notification	No errors.
App\Entity\Seo	No errors.
App\Entity\Sejour	The mappings App\Entity\Sejour#countries and App\Entity\Country#sejours are inconsistent with each other. The association App\Entity\Sejour#trancheAges refers to the inverse side field App\Entity\TrancheAge#sejours which does not exist. The mappings App\Entity\Sejour#whitelists and App\Entity\SejourWhitelist#sejour are inconsistent with each other.
App\Entity\Location	The mappings App\Entity\Location#contactForFamilleAccueils and App\Entity\Contact#location are inconsistent with each other.
App\Entity\TrancheAge	No errors.
App\Entity\Article	No errors.
App\Entity\FrontOption	No errors.
App\Entity\Saison	No errors.
App\Entity\Media	The mappings App\Entity\Media#mediaChildren and App\Entity\Media#mediaParent are inconsistent with each other. The mappings App\Entity\Media#mediaCategorie and App\Entity\MediaCategorie#media are inconsistent with each other. The field App\Entity\Media#mediaParent is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Media#mediaParent does not contain the required 'mappedBy="mediaParent"' attribute. If association App\Entity\Media#mediaParent is many-to-one, then the inversed side App\Entity\Media#mediaParent has to be one-to-many.
App\Entity\Age	No errors.
App\Entity\Country	No errors.
App\Entity\Departement	No errors.
App\Entity\SejourSession	The mappings App\Entity\SejourSession#sejourSessionMajorationTransports and App\Entity\SejourSessionMajorationTransport#sejourSession are inconsistent with each other.
App\Entity\MessageParent	No errors.
App\Entity\Inscription	The mappings App\Entity\Inscription#responsable and App\Entity\Contact#inscriptionParents are inconsistent with each other. The mappings App\Entity\Inscription#tiersDeConfiance and App\Entity\TiersDeConfiance#inscription are inconsistent with each other.
App\Entity\Equipier	No errors.
App\Entity\SejourSessionEquipier	No errors.
App\Entity\SejourSessionMajorationTransport	The association App\Entity\SejourSessionMajorationTransport#sejourSession refers to the inverse side field App\Entity\SejourSession#SejourSessionMajorationTransport which does not exist. The association App\Entity\SejourSessionMajorationTransport#majorationTransport refers to the inverse side field App\Entity\MajorationTransport#sejourSessionMajorationTransport which does not exist.
App\Entity\MessageDirecteurAuxParents	No errors.
App\Entity\Temoignage	No errors.
App\Entity\EnterpriseOptionSejourSession	No errors.
App\Entity\SejourSessionPicture	The association App\Entity\SejourSessionPicture#userValid refers to the inverse side field App\Entity\User#medias which does not exist. The association App\Entity\SejourSessionPicture#userCreated refers to the inverse side field App\Entity\User#medias which does not exist.
App\Entity\Theme	No errors.
App\Entity\MajorationTransport	The mappings App\Entity\MajorationTransport#sejourSessionMajorationTransports and App\Entity\SejourSessionMajorationTransport#majorationTransport are inconsistent with each other.
App\Entity\SejourEquipier	No errors.
App\Entity\Property	No errors.
App\Entity\SejourWhitelist	The association App\Entity\SejourWhitelist#user refers to the inverse side field App\Entity\User#sejourwhitelist which does not exist. The association App\Entity\SejourWhitelist#sejour refers to the inverse side field App\Entity\Sejour#sejourwhitelist which does not exist.
App\Entity\VilleDesservie	No errors.
App\Entity\MediaCategorie	The association App\Entity\MediaCategorie#media refers to the owning side field App\Entity\Media#MediaCategorie which does not exist.
App\Entity\InteractionTemplate	No errors.
App\Entity\SejourSessionMediaCategorie	The association App\Entity\SejourSessionMediaCategorie#sejourSession refers to the inverse side field App\Entity\SejourSession#sejourSessionMediaCategories which does not exist.
App\Entity\ContactMediaCategorie	The association App\Entity\ContactMediaCategorie#contact refers to the inverse side field App\Entity\Contact#contactMediaCategories which does not exist.
App\Entity\ArticleMediaCategorie	The association App\Entity\ArticleMediaCategorie#article refers to the inverse side field App\Entity\Article#articleMediaCategories which does not exist.
App\Entity\Candidature	No errors.
App\Entity\Contact	No errors.
App\Entity\EmailInfo	No errors.
App\Entity\Commande	No errors.
App\Entity\Compta	No errors.
App\Entity\TiersDeConfiance	The association App\Entity\TiersDeConfiance#inscription refers to the inverse side field App\Entity\Inscription#tiersDeConfiances which does not exist.
App\Entity\ContactForFamilleAccueil	No errors.
App\Entity\Enterprise	No errors.
App\Entity\EnterpriseRequest	No errors.

Symfony Profiler

https://croqvacances.horai-software.com/colonie-de-vacances/hiver

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping