Symfony Profiler

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 = '/favoris' 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.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;

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;

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;

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 = '/favoris';

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-25 21:28:19' ORDER BY s0_.date_debut 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 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;

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 = '/favoris';

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);

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;

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 = '/favoris' ORDER BY s0_.id DESC;

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;

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;

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;

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;

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;

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;