Symfony Profiler

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_block_composant_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_block_composant_translation t0 WHERE t0.object_id = 470 AND t0.field = 'masquer' 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 = 71 AND t0.field = 'actif' AND t0.locale = 'fr' LIMIT 1;

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.enabled AS enabled_3,
  t0.provider_name AS provider_name_4,
  t0.provider_status AS provider_status_5,
  t0.provider_reference AS provider_reference_6,
  t0.provider_metadata AS provider_metadata_7,
  t0.width AS width_8,
  t0.height AS height_9,
  t0.length AS length_10,
  t0.content_type AS content_type_11,
  t0.content_size AS content_size_12,
  t0.copyright AS copyright_13,
  t0.author_name AS author_name_14,
  t0.context AS context_15,
  t0.cdn_is_flushable AS cdn_is_flushable_16,
  t0.cdn_flush_identifier AS cdn_flush_identifier_17,
  t0.cdn_flush_at AS cdn_flush_at_18,
  t0.cdn_status AS cdn_status_19,
  t0.updated_at AS updated_at_20,
  t0.created_at AS created_at_21,
  t0.id AS id_22
FROM
  media__media t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = 2055;

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_block_composant_item_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_block_composant_item_translation t0 WHERE t0.object_id = 335 AND t0.field = 'masquer' AND t0.locale = 'fr' LIMIT 1;

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 = 22;

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 = 'fr' AND c0_.object_id = 470;

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
  social_media_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 social_media_translation t0 WHERE t0.object_id = 2 AND t0.field = 'facebook' AND t0.locale = 'fr' LIMIT 1;

SELECT
  c0_.content AS content_0,
  c0_.field AS field_1
FROM
  cms_page_block_composant_item_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_item_translation c0_ WHERE c0_.locale = 'fr' AND c0_.object_id = 335;

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 = 'fr' AND c0_.field = 'seo_slug' AND c0_.content = 'residence-miramar-la-cigale-arzon' AND c1_.page_type = 'residence' LIMIT 1;

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.masquer AS masquer_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.label_prix_apartir AS label_prix_apartir_10,
  t0.prix_apartir AS prix_apartir_11,
  t0.label_prix_au_lieu_de AS label_prix_au_lieu_de_12,
  t0.description_secondaire AS description_secondaire_13,
  t0.prix_au_lieu_de AS prix_au_lieu_de_14,
  t0.label_lien_principal AS label_lien_principal_15,
  t0.url_lien_principal AS url_lien_principal_16,
  t0.label_lien_secondaire AS label_lien_secondaire_17,
  t0.url_lien_secondaire AS url_lien_secondaire_18,
  t0.intro_description AS intro_description_19,
  t0.tel AS tel_20,
  t0.email AS email_21,
  t0.intro_description_secondaire AS intro_description_secondaire_22,
  t0.category_produit AS category_produit_23,
  t0.duration AS duration_24,
  t0.label_image_principal AS label_image_principal_25,
  t0.vue_image AS vue_image_26,
  t0.capacite_chambre AS capacite_chambre_27,
  t0.superficie_chambre AS superficie_chambre_28,
  t0.emplacement_chambre AS emplacement_chambre_29,
  t0.titre_principal_rich AS titre_principal_rich_30,
  t0.adresse AS adresse_31,
  t0.longitude AS longitude_32,
  t0.latitude AS latitude_33,
  t0.horaire AS horaire_34,
  t0.age_limitation AS age_limitation_35,
  t0.alt_p AS alt_p_36,
  t0.discount_text AS discount_text_37,
  t0.prix_apartir_riche AS prix_apartir_riche_38,
  t0.question AS question_39,
  t0.answer AS answer_40,
  t0.information AS information_41,
  t0.mandatory AS mandatory_42,
  t0.name AS name_43,
  t0.status AS status_44,
  t0.maxdays AS maxdays_45,
  t0.mindays AS mindays_46,
  t0.price_without_accommodation AS price_without_accommodation_47,
  t0.price_with_accommodation AS price_with_accommodation_48,
  t0.totalcare AS totalcare_49,
  t0.manque_precision AS manque_precision_50,
  t0.price_detail AS price_detail_51,
  t0.text_with_acoomodation AS text_with_acoomodation_52,
  t0.text_without_acoomodation AS text_without_acoomodation_53,
  t0.schedule_text AS schedule_text_54,
  t0.age_limitation_text AS age_limitation_text_55,
  t0.cms_page_id AS cms_page_id_56,
  t0.image_principal_id AS image_principal_id_57,
  t0.cms_page_block_composant_id AS cms_page_block_composant_id_58,
  t0.fichier_upload_principal_id AS fichier_upload_principal_id_59,
  t0.fichier_upload_secondaire_id AS fichier_upload_secondaire_id_60,
  t0.produit_thalasso_id AS produit_thalasso_id_61,
  t0.produit_thalasso_cadeau_id AS produit_thalasso_cadeau_id_62,
  t0.url_lien_principal_page_id AS url_lien_principal_page_id_63,
  t0.fichier_upload_principal_en_id AS fichier_upload_principal_en_id_64,
  t0.fichier_upload_secondaire_en_id AS fichier_upload_secondaire_en_id_65,
  t0.url_lien_secondaire_page_id AS url_lien_secondaire_page_id_66,
  t0.chambre_id AS chambre_id_67
FROM
  cms_page_block_composant_items t0
WHERE
  t0.cms_page_block_composant_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.masquer AS masquer_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.label_prix_apartir AS label_prix_apartir_10, t0.prix_apartir AS prix_apartir_11, t0.label_prix_au_lieu_de AS label_prix_au_lieu_de_12, t0.description_secondaire AS description_secondaire_13, t0.prix_au_lieu_de AS prix_au_lieu_de_14, t0.label_lien_principal AS label_lien_principal_15, t0.url_lien_principal AS url_lien_principal_16, t0.label_lien_secondaire AS label_lien_secondaire_17, t0.url_lien_secondaire AS url_lien_secondaire_18, t0.intro_description AS intro_description_19, t0.tel AS tel_20, t0.email AS email_21, t0.intro_description_secondaire AS intro_description_secondaire_22, t0.category_produit AS category_produit_23, t0.duration AS duration_24, t0.label_image_principal AS label_image_principal_25, t0.vue_image AS vue_image_26, t0.capacite_chambre AS capacite_chambre_27, t0.superficie_chambre AS superficie_chambre_28, t0.emplacement_chambre AS emplacement_chambre_29, t0.titre_principal_rich AS titre_principal_rich_30, t0.adresse AS adresse_31, t0.longitude AS longitude_32, t0.latitude AS latitude_33, t0.horaire AS horaire_34, t0.age_limitation AS age_limitation_35, t0.alt_p AS alt_p_36, t0.discount_text AS discount_text_37, t0.prix_apartir_riche AS prix_apartir_riche_38, t0.question AS question_39, t0.answer AS answer_40, t0.information AS information_41, t0.mandatory AS mandatory_42, t0.name AS name_43, t0.status AS status_44, t0.maxdays AS maxdays_45, t0.mindays AS mindays_46, t0.price_without_accommodation AS price_without_accommodation_47, t0.price_with_accommodation AS price_with_accommodation_48, t0.totalcare AS totalcare_49, t0.manque_precision AS manque_precision_50, t0.price_detail AS price_detail_51, t0.text_with_acoomodation AS text_with_acoomodation_52, t0.text_without_acoomodation AS text_without_acoomodation_53, t0.schedule_text AS schedule_text_54, t0.age_limitation_text AS age_limitation_text_55, t0.cms_page_id AS cms_page_id_56, t0.image_principal_id AS image_principal_id_57, t0.cms_page_block_composant_id AS cms_page_block_composant_id_58, t0.fichier_upload_principal_id AS fichier_upload_principal_id_59, t0.fichier_upload_secondaire_id AS fichier_upload_secondaire_id_60, t0.produit_thalasso_id AS produit_thalasso_id_61, t0.produit_thalasso_cadeau_id AS produit_thalasso_cadeau_id_62, t0.url_lien_principal_page_id AS url_lien_principal_page_id_63, t0.fichier_upload_principal_en_id AS fichier_upload_principal_en_id_64, t0.fichier_upload_secondaire_en_id AS fichier_upload_secondaire_en_id_65, t0.url_lien_secondaire_page_id AS url_lien_secondaire_page_id_66, t0.chambre_id AS chambre_id_67 FROM cms_page_block_composant_items t0 WHERE t0.cms_page_block_composant_id = 472 ORDER BY t0.position ASC;

SELECT
  t0_.id AS id_0,
  t1_.content AS content_1
FROM
  tag t0_
  LEFT JOIN tag_translation t1_ ON t0_.id = t1_.object_id
  AND (
    t1_.locale = ?
    AND t1_.field = ?
  )
  INNER JOIN categorie_tag c2_ ON t0_.categorie_tag_id = c2_.id
WHERE
  c2_.id = ?
GROUP BY
  t0_.id

SELECT t0_.id AS id_0, t1_.content AS content_1 FROM tag t0_ LEFT JOIN tag_translation t1_ ON t0_.id = t1_.object_id AND (t1_.locale = 'fr' AND t1_.field = 'nom_tag') INNER JOIN categorie_tag c2_ ON t0_.categorie_tag_id = c2_.id WHERE c2_.id = 2 GROUP BY t0_.id;

SELECT
  t0.id AS id_1,
  t0.nom_composant AS nom_composant_2,
  t0.nom_technique_composant AS nom_technique_composant_3,
  t0.taille_img_p AS taille_img_p_4,
  t0.taille_img_s AS taille_img_s_5,
  t0.taille_img_item AS taille_img_item_6,
  t0.taille_img_item_slide AS taille_img_item_slide_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  cms_composant t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom_composant AS nom_composant_2, t0.nom_technique_composant AS nom_technique_composant_3, t0.taille_img_p AS taille_img_p_4, t0.taille_img_s AS taille_img_s_5, t0.taille_img_item AS taille_img_item_6, t0.taille_img_item_slide AS taille_img_item_slide_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM cms_composant t0 WHERE t0.id = 5;

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 = 71 ORDER BY t0.position ASC;

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 = 'fr' AND c0_.type = 'residence' ORDER BY c0_.date DESC;

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 = 71;

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 = ?

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

SELECT
  s0_.content AS content_0,
  s0_.field AS field_1
FROM
  social_media_translation s0_
WHERE
  s0_.locale = ?
  AND s0_.object_id = ?

SELECT s0_.content AS content_0, s0_.field AS field_1 FROM social_media_translation s0_ WHERE s0_.locale = 'fr' AND s0_.object_id = 2;

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 = 'fr' AND c0_.object_id = 71;

SELECT
  t0_.content AS content_0,
  t1_.id AS id_1
FROM
  type_bar t1_
  LEFT JOIN type_bar_translation t0_ ON t1_.id = t0_.object_id
  AND (
    t0_.locale = ?
    AND t0_.field = ?
  )

SELECT t0_.content AS content_0, t1_.id AS id_1 FROM type_bar t1_ LEFT JOIN type_bar_translation t0_ ON t1_.id = t0_.object_id AND (t0_.locale = 'fr' AND t0_.field = 'nom_type_bar');

SELECT
  c0_.id AS id_0,
  c0_.footer_bottom_links AS footer_bottom_links_1,
  c0_.brochures AS brochures_2,
  c0_.footer_form AS footer_form_3,
  c0_.date AS date_4,
  c0_.lang AS lang_5,
  c0_.type AS type_6
FROM
  cache_menu_footer c0_
WHERE
  c0_.lang = ?
  AND c0_.type = ?
ORDER BY
  c0_.date DESC

SELECT c0_.id AS id_0, c0_.footer_bottom_links AS footer_bottom_links_1, c0_.brochures AS brochures_2, c0_.footer_form AS footer_form_3, c0_.date AS date_4, c0_.lang AS lang_5, c0_.type AS type_6 FROM cache_menu_footer c0_ WHERE c0_.lang = 'fr' AND c0_.type = 'residence' ORDER BY c0_.date DESC;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.facebook AS facebook_3,
  t0.instagram AS instagram_4,
  t0.linkedin AS linkedin_5
FROM
  social_media t0
WHERE
  t0.type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.facebook AS facebook_3, t0.instagram AS instagram_4, t0.linkedin AS linkedin_5 FROM social_media t0 WHERE t0.type = 'residence' LIMIT 1;