Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.locale AS locale_1,
  c0_.field AS field_2,
  c0_.content AS content_3,
  c0_.object_id AS object_id_4
FROM
  cms_page_translation c0_
  LEFT JOIN cms_page c1_ ON c0_.object_id = c1_.id
WHERE
  c0_.locale = ?
  AND c0_.field = ?
  AND c0_.content = ?
  AND c1_.page_type = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.locale AS locale_1, c0_.field AS field_2, c0_.content AS content_3, c0_.object_id AS object_id_4 FROM cms_page_translation c0_ LEFT JOIN cms_page c1_ ON c0_.object_id = c1_.id WHERE c0_.locale = 'en' AND c0_.field = 'seo_slug' AND c0_.content = 'getting-to-residence-la-cigale' AND c1_.page_type = 'residence' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  cms_page_translation t0
WHERE
  t0.object_id = ?
  AND t0.field = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cms_page_translation t0 WHERE t0.object_id = 81 AND t0.field = 'actif' AND t0.locale = 'en' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  cms_page_translation t0
WHERE
  t0.object_id = ?
  AND t0.field = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cms_page_translation t0 WHERE t0.object_id = 81 AND t0.field = 'seo_slug';

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  cms_page_translation t0
WHERE
  t0.object_id = ?
  AND t0.field = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cms_page_translation t0 WHERE t0.object_id = 81 AND t0.field = 'actif' AND t0.locale = 'fr' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  cms_page_translation t0
WHERE
  t0.object_id = ?
  AND t0.field = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cms_page_translation t0 WHERE t0.object_id = 81 AND t0.field = 'actif' AND t0.locale = 'en' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom_page AS nom_page_2,
  t0.position AS position_3,
  t0.seo_slug AS seo_slug_4,
  t0.seo_meta_title AS seo_meta_title_5,
  t0.seo_meta_description AS seo_meta_description_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.header_sur_titre AS header_sur_titre_9,
  t0.header_titre AS header_titre_10,
  t0.alt_header_img AS alt_header_img_11,
  t0.actif AS actif_12,
  t0.id_video AS id_video_13,
  t0.page_type AS page_type_14,
  t0.header_video AS header_video_15,
  t0.date_fin AS date_fin_16,
  t0.cms_template_id AS cms_template_id_17,
  t0.header_image_id AS header_image_id_18,
  t0.produit_thalasso_id AS produit_thalasso_id_19,
  t0.produit_chambre_id AS produit_chambre_id_20,
  t0.parent_id AS parent_id_21
FROM
  cms_page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom_page AS nom_page_2, t0.position AS position_3, t0.seo_slug AS seo_slug_4, t0.seo_meta_title AS seo_meta_title_5, t0.seo_meta_description AS seo_meta_description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.header_sur_titre AS header_sur_titre_9, t0.header_titre AS header_titre_10, t0.alt_header_img AS alt_header_img_11, t0.actif AS actif_12, t0.id_video AS id_video_13, t0.page_type AS page_type_14, t0.header_video AS header_video_15, t0.date_fin AS date_fin_16, t0.cms_template_id AS cms_template_id_17, t0.header_image_id AS header_image_id_18, t0.produit_thalasso_id AS produit_thalasso_id_19, t0.produit_chambre_id AS produit_chambre_id_20, t0.parent_id AS parent_id_21 FROM cms_page t0 WHERE t0.id = 81;

SELECT
  c0_.content AS content_0,
  c0_.field AS field_1
FROM
  cms_page_translation c0_
WHERE
  c0_.locale = ?
  AND c0_.object_id = ?

SELECT c0_.content AS content_0, c0_.field AS field_1 FROM cms_page_translation c0_ WHERE c0_.locale = 'en' AND c0_.object_id = 81;

SELECT
  t0.id AS id_1,
  t0.nom_technique_template AS nom_technique_template_2,
  t0.nom_template AS nom_template_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.is_residence AS is_residence_6
FROM
  cms_template t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom_technique_template AS nom_technique_template_2, t0.nom_template AS nom_template_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.is_residence AS is_residence_6 FROM cms_template t0 WHERE t0.id = 30;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.surtitre AS surtitre_3,
  t0.titre_principal AS titre_principal_4,
  t0.soustitre AS soustitre_5,
  t0.description AS description_6,
  t0.label_prix_apartir AS label_prix_apartir_7,
  t0.prix_apartir AS prix_apartir_8,
  t0.label_prix_au_lieu_de AS label_prix_au_lieu_de_9,
  t0.prix_au_lieu_de AS prix_au_lieu_de_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.label_lien_principal AS label_lien_principal_13,
  t0.url_lien_principal AS url_lien_principal_14,
  t0.label_lien_secondaire AS label_lien_secondaire_15,
  t0.url_lien_secondaire AS url_lien_secondaire_16,
  t0.sens_affichage AS sens_affichage_17,
  t0.tel AS tel_18,
  t0.email AS email_19,
  t0.adresse AS adresse_20,
  t0.intro_description AS intro_description_21,
  t0.intro_description_secondaire AS intro_description_secondaire_22,
  t0.quote AS quote_23,
  t0.description_secondaire AS description_secondaire_24,
  t0.vue_chambre AS vue_chambre_25,
  t0.capacite_chambre AS capacite_chambre_26,
  t0.superficie_chambre AS superficie_chambre_27,
  t0.emplacement_chambre AS emplacement_chambre_28,
  t0.legende AS legende_29,
  t0.titre_principal_rich AS titre_principal_rich_30,
  t0.video_youtube AS video_youtube_31,
  t0.masquer AS masquer_32,
  t0.horaire AS horaire_33,
  t0.age_limitation AS age_limitation_34,
  t0.longitude AS longitude_35,
  t0.latitude AS latitude_36,
  t0.alt_p AS alt_p_37,
  t0.alt_s AS alt_s_38,
  t0.duration AS duration_39,
  t0.discount_text AS discount_text_40,
  t0.prix_apartir_riche AS prix_apartir_riche_41,
  t0.question AS question_42,
  t0.answer AS answer_43,
  t0.information AS information_44,
  t0.mandatory AS mandatory_45,
  t0.name AS name_46,
  t0.status AS status_47,
  t0.maxdays AS maxdays_48,
  t0.mindays AS mindays_49,
  t0.price_without_accommodation AS price_without_accommodation_50,
  t0.price_with_accommodation AS price_with_accommodation_51,
  t0.totalcare AS totalcare_52,
  t0.manque_precision AS manque_precision_53,
  t0.price_detail AS price_detail_54,
  t0.text_with_acoomodation AS text_with_acoomodation_55,
  t0.text_without_acoomodation AS text_without_acoomodation_56,
  t0.schedule_text AS schedule_text_57,
  t0.age_limitation_text AS age_limitation_text_58,
  t0.chambre AS chambre_59,
  t0.salle_de_bain AS salle_de_bain_60,
  t0.image_principal_id AS image_principal_id_61,
  t0.cms_page_id AS cms_page_id_62,
  t0.cms_composant_id AS cms_composant_id_63,
  t0.image_secondaire_id AS image_secondaire_id_64,
  t0.fichier_upload_principal_id AS fichier_upload_principal_id_65,
  t0.fichier_upload_secondaire_id AS fichier_upload_secondaire_id_66,
  t0.formulaire_id AS formulaire_id_67,
  t0.url_lien_principal_page_id AS url_lien_principal_page_id_68,
  t0.fichier_upload_principal_en_id AS fichier_upload_principal_en_id_69,
  t0.fichier_upload_secondaire_en_id AS fichier_upload_secondaire_en_id_70,
  t0.url_lien_secondaire_page_id AS url_lien_secondaire_page_id_71,
  t0.produit_thalasso_cadeau_id AS produit_thalasso_cadeau_id_72,
  t0.produit_thalasso_id AS produit_thalasso_id_73
FROM
  cms_page_block_composant t0
WHERE
  t0.cms_page_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.surtitre AS surtitre_3, t0.titre_principal AS titre_principal_4, t0.soustitre AS soustitre_5, t0.description AS description_6, t0.label_prix_apartir AS label_prix_apartir_7, t0.prix_apartir AS prix_apartir_8, t0.label_prix_au_lieu_de AS label_prix_au_lieu_de_9, t0.prix_au_lieu_de AS prix_au_lieu_de_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.label_lien_principal AS label_lien_principal_13, t0.url_lien_principal AS url_lien_principal_14, t0.label_lien_secondaire AS label_lien_secondaire_15, t0.url_lien_secondaire AS url_lien_secondaire_16, t0.sens_affichage AS sens_affichage_17, t0.tel AS tel_18, t0.email AS email_19, t0.adresse AS adresse_20, t0.intro_description AS intro_description_21, t0.intro_description_secondaire AS intro_description_secondaire_22, t0.quote AS quote_23, t0.description_secondaire AS description_secondaire_24, t0.vue_chambre AS vue_chambre_25, t0.capacite_chambre AS capacite_chambre_26, t0.superficie_chambre AS superficie_chambre_27, t0.emplacement_chambre AS emplacement_chambre_28, t0.legende AS legende_29, t0.titre_principal_rich AS titre_principal_rich_30, t0.video_youtube AS video_youtube_31, t0.masquer AS masquer_32, t0.horaire AS horaire_33, t0.age_limitation AS age_limitation_34, t0.longitude AS longitude_35, t0.latitude AS latitude_36, t0.alt_p AS alt_p_37, t0.alt_s AS alt_s_38, t0.duration AS duration_39, t0.discount_text AS discount_text_40, t0.prix_apartir_riche AS prix_apartir_riche_41, t0.question AS question_42, t0.answer AS answer_43, t0.information AS information_44, t0.mandatory AS mandatory_45, t0.name AS name_46, t0.status AS status_47, t0.maxdays AS maxdays_48, t0.mindays AS mindays_49, t0.price_without_accommodation AS price_without_accommodation_50, t0.price_with_accommodation AS price_with_accommodation_51, t0.totalcare AS totalcare_52, t0.manque_precision AS manque_precision_53, t0.price_detail AS price_detail_54, t0.text_with_acoomodation AS text_with_acoomodation_55, t0.text_without_acoomodation AS text_without_acoomodation_56, t0.schedule_text AS schedule_text_57, t0.age_limitation_text AS age_limitation_text_58, t0.chambre AS chambre_59, t0.salle_de_bain AS salle_de_bain_60, t0.image_principal_id AS image_principal_id_61, t0.cms_page_id AS cms_page_id_62, t0.cms_composant_id AS cms_composant_id_63, t0.image_secondaire_id AS image_secondaire_id_64, t0.fichier_upload_principal_id AS fichier_upload_principal_id_65, t0.fichier_upload_secondaire_id AS fichier_upload_secondaire_id_66, t0.formulaire_id AS formulaire_id_67, t0.url_lien_principal_page_id AS url_lien_principal_page_id_68, t0.fichier_upload_principal_en_id AS fichier_upload_principal_en_id_69, t0.fichier_upload_secondaire_en_id AS fichier_upload_secondaire_en_id_70, t0.url_lien_secondaire_page_id AS url_lien_secondaire_page_id_71, t0.produit_thalasso_cadeau_id AS produit_thalasso_cadeau_id_72, t0.produit_thalasso_id AS produit_thalasso_id_73 FROM cms_page_block_composant t0 WHERE t0.cms_page_id = 81 ORDER BY t0.position ASC;

SELECT
  c0_.content AS content_0,
  c0_.field AS field_1
FROM
  cms_page_block_composant_translation c0_
WHERE
  c0_.locale = ?
  AND c0_.object_id = ?

SELECT c0_.content AS content_0, c0_.field AS field_1 FROM cms_page_block_composant_translation c0_ WHERE c0_.locale = 'en' AND c0_.object_id = 537;

SELECT
  c0_.content AS content_0,
  c0_.field AS field_1
FROM
  cms_page_block_composant_translation c0_
WHERE
  c0_.locale = ?
  AND c0_.object_id = ?

SELECT c0_.content AS content_0, c0_.field AS field_1 FROM cms_page_block_composant_translation c0_ WHERE c0_.locale = 'en' AND c0_.object_id = 538;

SELECT
  c0_.content AS content_0,
  c0_.field AS field_1
FROM
  cms_page_block_composant_translation c0_
WHERE
  c0_.locale = ?
  AND c0_.object_id = ?

SELECT c0_.content AS content_0, c0_.field AS field_1 FROM cms_page_block_composant_translation c0_ WHERE c0_.locale = 'en' AND c0_.object_id = 539;

SELECT
  c0_.content AS content_0,
  c0_.field AS field_1
FROM
  cms_page_block_composant_translation c0_
WHERE
  c0_.locale = ?
  AND c0_.object_id = ?

SELECT c0_.content AS content_0, c0_.field AS field_1 FROM cms_page_block_composant_translation c0_ WHERE c0_.locale = 'en' AND c0_.object_id = 540;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  cms_page_translation t0
WHERE
  t0.object_id = ?
  AND t0.field = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cms_page_translation t0 WHERE t0.object_id = 81 AND t0.field = 'seo_meta_title' AND t0.locale = 'en' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  cms_page_translation t0
WHERE
  t0.object_id = ?
  AND t0.field = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cms_page_translation t0 WHERE t0.object_id = 81 AND t0.field = 'seo_meta_description' AND t0.locale = 'en' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  cms_page_translation t0
WHERE
  t0.object_id = ?
  AND t0.field = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cms_page_translation t0 WHERE t0.object_id = 81 AND t0.field = 'seo_meta_title' AND t0.locale = 'en' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  cms_page_translation t0
WHERE
  t0.object_id = ?
  AND t0.field = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cms_page_translation t0 WHERE t0.object_id = 71 AND t0.field = 'seo_slug' AND t0.locale = 'en' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  cms_page_translation t0
WHERE
  t0.object_id = ?
  AND t0.field = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cms_page_translation t0 WHERE t0.object_id = 71 AND t0.field = 'header_titre' AND t0.locale = 'en' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.nom_page AS nom_page_1,
  c0_.position AS position_2,
  c0_.seo_slug AS seo_slug_3,
  c0_.seo_meta_title AS seo_meta_title_4,
  c0_.seo_meta_description AS seo_meta_description_5,
  c0_.created_at AS created_at_6,
  c0_.updated_at AS updated_at_7,
  c0_.header_sur_titre AS header_sur_titre_8,
  c0_.header_titre AS header_titre_9,
  c0_.alt_header_img AS alt_header_img_10,
  c0_.actif AS actif_11,
  c0_.id_video AS id_video_12,
  c0_.page_type AS page_type_13,
  c0_.header_video AS header_video_14,
  c0_.date_fin AS date_fin_15,
  c0_.cms_template_id AS cms_template_id_16,
  c0_.header_image_id AS header_image_id_17,
  c0_.produit_thalasso_id AS produit_thalasso_id_18,
  c0_.produit_chambre_id AS produit_chambre_id_19,
  c0_.parent_id AS parent_id_20
FROM
  cms_page c0_
  LEFT JOIN cms_template c1_ ON c0_.cms_template_id = c1_.id
WHERE
  c1_.nom_technique_template = ?
  AND c1_.id = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.nom_page AS nom_page_1, c0_.position AS position_2, c0_.seo_slug AS seo_slug_3, c0_.seo_meta_title AS seo_meta_title_4, c0_.seo_meta_description AS seo_meta_description_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.header_sur_titre AS header_sur_titre_8, c0_.header_titre AS header_titre_9, c0_.alt_header_img AS alt_header_img_10, c0_.actif AS actif_11, c0_.id_video AS id_video_12, c0_.page_type AS page_type_13, c0_.header_video AS header_video_14, c0_.date_fin AS date_fin_15, c0_.cms_template_id AS cms_template_id_16, c0_.header_image_id AS header_image_id_17, c0_.produit_thalasso_id AS produit_thalasso_id_18, c0_.produit_chambre_id AS produit_chambre_id_19, c0_.parent_id AS parent_id_20 FROM cms_page c0_ LEFT JOIN cms_template c1_ ON c0_.cms_template_id = c1_.id WHERE c1_.nom_technique_template = 'index.html.twig' AND c1_.id = 22 LIMIT 1;

SELECT
  c0_.content AS content_0,
  c0_.field AS field_1
FROM
  cms_page_translation c0_
WHERE
  c0_.locale = ?
  AND c0_.object_id = ?

SELECT c0_.content AS content_0, c0_.field AS field_1 FROM cms_page_translation c0_ WHERE c0_.locale = 'en' AND c0_.object_id = 71;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  cms_page_translation t0
WHERE
  t0.object_id = ?
  AND t0.field = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cms_page_translation t0 WHERE t0.object_id = 71 AND t0.field = 'seo_slug' AND t0.locale = 'en' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  cms_page_translation t0
WHERE
  t0.object_id = ?
  AND t0.field = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cms_page_translation t0 WHERE t0.object_id = 71 AND t0.field = 'header_titre' AND t0.locale = 'en' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  cms_page_translation t0
WHERE
  t0.object_id = ?
  AND t0.field = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cms_page_translation t0 WHERE t0.object_id = 81 AND t0.field = 'seo_slug' AND t0.locale = 'en' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.nom_page AS nom_page_1,
  c0_.position AS position_2,
  c0_.seo_slug AS seo_slug_3,
  c0_.seo_meta_title AS seo_meta_title_4,
  c0_.seo_meta_description AS seo_meta_description_5,
  c0_.created_at AS created_at_6,
  c0_.updated_at AS updated_at_7,
  c0_.header_sur_titre AS header_sur_titre_8,
  c0_.header_titre AS header_titre_9,
  c0_.alt_header_img AS alt_header_img_10,
  c0_.actif AS actif_11,
  c0_.id_video AS id_video_12,
  c0_.page_type AS page_type_13,
  c0_.header_video AS header_video_14,
  c0_.date_fin AS date_fin_15,
  c0_.cms_template_id AS cms_template_id_16,
  c0_.header_image_id AS header_image_id_17,
  c0_.produit_thalasso_id AS produit_thalasso_id_18,
  c0_.produit_chambre_id AS produit_chambre_id_19,
  c0_.parent_id AS parent_id_20
FROM
  cms_page c0_
  LEFT JOIN cms_template c1_ ON c0_.cms_template_id = c1_.id
WHERE
  c1_.nom_technique_template = ?
  AND c1_.id = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.nom_page AS nom_page_1, c0_.position AS position_2, c0_.seo_slug AS seo_slug_3, c0_.seo_meta_title AS seo_meta_title_4, c0_.seo_meta_description AS seo_meta_description_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.header_sur_titre AS header_sur_titre_8, c0_.header_titre AS header_titre_9, c0_.alt_header_img AS alt_header_img_10, c0_.actif AS actif_11, c0_.id_video AS id_video_12, c0_.page_type AS page_type_13, c0_.header_video AS header_video_14, c0_.date_fin AS date_fin_15, c0_.cms_template_id AS cms_template_id_16, c0_.header_image_id AS header_image_id_17, c0_.produit_thalasso_id AS produit_thalasso_id_18, c0_.produit_chambre_id AS produit_chambre_id_19, c0_.parent_id AS parent_id_20 FROM cms_page c0_ LEFT JOIN cms_template c1_ ON c0_.cms_template_id = c1_.id WHERE c1_.nom_technique_template = 'index.html.twig' AND c1_.id = 22 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  cms_page_translation t0
WHERE
  t0.object_id = ?
  AND t0.field = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cms_page_translation t0 WHERE t0.object_id = 71 AND t0.field = 'seo_slug' AND t0.locale = 'en' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  cms_page_translation t0
WHERE
  t0.object_id = ?
  AND t0.field = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cms_page_translation t0 WHERE t0.object_id = 71 AND t0.field = 'header_titre' AND t0.locale = 'en' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.nom_page AS nom_page_1,
  c0_.position AS position_2,
  c0_.seo_slug AS seo_slug_3,
  c0_.seo_meta_title AS seo_meta_title_4,
  c0_.seo_meta_description AS seo_meta_description_5,
  c0_.created_at AS created_at_6,
  c0_.updated_at AS updated_at_7,
  c0_.header_sur_titre AS header_sur_titre_8,
  c0_.header_titre AS header_titre_9,
  c0_.alt_header_img AS alt_header_img_10,
  c0_.actif AS actif_11,
  c0_.id_video AS id_video_12,
  c0_.page_type AS page_type_13,
  c0_.header_video AS header_video_14,
  c0_.date_fin AS date_fin_15,
  c0_.cms_template_id AS cms_template_id_16,
  c0_.header_image_id AS header_image_id_17,
  c0_.produit_thalasso_id AS produit_thalasso_id_18,
  c0_.produit_chambre_id AS produit_chambre_id_19,
  c0_.parent_id AS parent_id_20
FROM
  cms_page c0_
  LEFT JOIN cms_template c1_ ON c0_.cms_template_id = c1_.id
WHERE
  c1_.nom_technique_template = ?
  AND c1_.id = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.nom_page AS nom_page_1, c0_.position AS position_2, c0_.seo_slug AS seo_slug_3, c0_.seo_meta_title AS seo_meta_title_4, c0_.seo_meta_description AS seo_meta_description_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.header_sur_titre AS header_sur_titre_8, c0_.header_titre AS header_titre_9, c0_.alt_header_img AS alt_header_img_10, c0_.actif AS actif_11, c0_.id_video AS id_video_12, c0_.page_type AS page_type_13, c0_.header_video AS header_video_14, c0_.date_fin AS date_fin_15, c0_.cms_template_id AS cms_template_id_16, c0_.header_image_id AS header_image_id_17, c0_.produit_thalasso_id AS produit_thalasso_id_18, c0_.produit_chambre_id AS produit_chambre_id_19, c0_.parent_id AS parent_id_20 FROM cms_page c0_ LEFT JOIN cms_template c1_ ON c0_.cms_template_id = c1_.id WHERE c1_.nom_technique_template = 'index.html.twig' AND c1_.id = 22 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  cms_page_translation t0
WHERE
  t0.object_id = ?
  AND t0.field = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cms_page_translation t0 WHERE t0.object_id = 71 AND t0.field = 'seo_slug' AND t0.locale = 'en' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  cms_page_translation t0
WHERE
  t0.object_id = ?
  AND t0.field = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cms_page_translation t0 WHERE t0.object_id = 71 AND t0.field = 'header_titre' AND t0.locale = 'en' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  cms_page_translation t0
WHERE
  t0.object_id = ?
  AND t0.field = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cms_page_translation t0 WHERE t0.object_id = 81 AND t0.field = 'header_titre' AND t0.locale = 'en' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.first_menu AS first_menu_1,
  c0_.second_menu AS second_menu_2,
  c0_.date AS date_3,
  c0_.lang AS lang_4,
  c0_.type AS type_5
FROM
  cache_menu c0_
WHERE
  c0_.lang = ?
  AND c0_.type = ?
ORDER BY
  c0_.date DESC

SELECT c0_.id AS id_0, c0_.first_menu AS first_menu_1, c0_.second_menu AS second_menu_2, c0_.date AS date_3, c0_.lang AS lang_4, c0_.type AS type_5 FROM cache_menu c0_ WHERE c0_.lang = 'en' AND c0_.type = 'residence' ORDER BY c0_.date DESC;

SELECT
  c0_.id AS id_0,
  c0_.first_menu AS first_menu_1,
  c0_.second_menu AS second_menu_2,
  c0_.date AS date_3,
  c0_.lang AS lang_4,
  c0_.type AS type_5
FROM
  cache_menu c0_
WHERE
  c0_.lang = ?
  AND c0_.type = ?
ORDER BY
  c0_.date DESC

SELECT c0_.id AS id_0, c0_.first_menu AS first_menu_1, c0_.second_menu AS second_menu_2, c0_.date AS date_3, c0_.lang AS lang_4, c0_.type AS type_5 FROM cache_menu c0_ WHERE c0_.lang = 'en' AND c0_.type = 'residence' ORDER BY c0_.date DESC;