Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.nom_promotion AS nom_promotion_1,
  p0_.cumul_promo AS cumul_promo_2,
  p0_.cumul_early_booking AS cumul_early_booking_3,
  p0_.description_promo AS description_promo_4,
  p0_.min_achat AS min_achat_5,
  p0_.nbr_nuits_achetees AS nbr_nuits_achetees_6,
  p0_.nbr_produits_achetees AS nbr_produits_achetees_7,
  p0_.created_at AS created_at_8,
  p0_.updated_at AS updated_at_9,
  p0_.promotion_personalisee AS promotion_personalisee_10,
  p0_.actif AS actif_11,
  p0_.arrangement AS arrangement_12,
  p0_.pourcentage AS pourcentage_13,
  p0_.nbr_nuits_offertes AS nbr_nuits_offertes_14,
  p0_.description_prestation AS description_prestation_15,
  p0_.montant AS montant_16,
  p0_.titre_pdf AS titre_pdf_17,
  p0_.arrhes_100 AS arrhes_100_18,
  p0_.type_promotion_id AS type_promotion_id_19,
  p0_.type_chambre_id AS type_chambre_id_20,
  p0_.type_application_id AS type_application_id_21,
  p0_.type_prestation_id AS type_prestation_id_22,
  p0_.categorie_produit_thalasso_id AS categorie_produit_thalasso_id_23
FROM
  promotion p0_
  LEFT JOIN type_application t1_ ON p0_.type_application_id = t1_.id
  INNER JOIN promotion_thalasso p3_ ON p0_.id = p3_.promotion_id
  INNER JOIN produit_thalasso p2_ ON p2_.id = p3_.produit_thalasso_id
  INNER JOIN type_promotion t4_ ON p0_.type_promotion_id = t4_.id
  INNER JOIN promotion_affichage p5_ ON p0_.id = p5_.promotion_id
  INNER JOIN promotion_validite p6_ ON p0_.id = p6_.promotion_id
WHERE
  p0_.actif = 1
  AND p2_.id = ?
  AND t4_.id <> ?
  AND t4_.id <> ?
  AND t4_.id <> ?
  AND t4_.id <> ?
  AND t4_.id <> 5
  AND (
    ? BETWEEN p5_.date_debut_affichage
    AND p5_.date_fin_affichage
  )
  AND (
    ? BETWEEN p6_.date_debut_validite
    AND p6_.date_fin_validite
  )
LIMIT
  1

SELECT p0_.id AS id_0, p0_.nom_promotion AS nom_promotion_1, p0_.cumul_promo AS cumul_promo_2, p0_.cumul_early_booking AS cumul_early_booking_3, p0_.description_promo AS description_promo_4, p0_.min_achat AS min_achat_5, p0_.nbr_nuits_achetees AS nbr_nuits_achetees_6, p0_.nbr_produits_achetees AS nbr_produits_achetees_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.promotion_personalisee AS promotion_personalisee_10, p0_.actif AS actif_11, p0_.arrangement AS arrangement_12, p0_.pourcentage AS pourcentage_13, p0_.nbr_nuits_offertes AS nbr_nuits_offertes_14, p0_.description_prestation AS description_prestation_15, p0_.montant AS montant_16, p0_.titre_pdf AS titre_pdf_17, p0_.arrhes_100 AS arrhes_100_18, p0_.type_promotion_id AS type_promotion_id_19, p0_.type_chambre_id AS type_chambre_id_20, p0_.type_application_id AS type_application_id_21, p0_.type_prestation_id AS type_prestation_id_22, p0_.categorie_produit_thalasso_id AS categorie_produit_thalasso_id_23 FROM promotion p0_ LEFT JOIN type_application t1_ ON p0_.type_application_id = t1_.id INNER JOIN promotion_thalasso p3_ ON p0_.id = p3_.promotion_id INNER JOIN produit_thalasso p2_ ON p2_.id = p3_.produit_thalasso_id INNER JOIN type_promotion t4_ ON p0_.type_promotion_id = t4_.id INNER JOIN promotion_affichage p5_ ON p0_.id = p5_.promotion_id INNER JOIN promotion_validite p6_ ON p0_.id = p6_.promotion_id WHERE p0_.actif = 1 AND p2_.id = 27 AND t4_.id <> 2 AND t4_.id <> 3 AND t4_.id <> 9 AND t4_.id <> 10 AND t4_.id <> 5 AND ('2025-04-30' BETWEEN p5_.date_debut_affichage AND p5_.date_fin_affichage) AND ('2025-05-01 00:00:00' BETWEEN p6_.date_debut_validite AND p6_.date_fin_validite) LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.pourcentage AS pourcentage_1,
  p0_.cumul_promo AS cumul_promo_2,
  p0_.montant AS montant_3,
  GROUP_CONCAT(a1_.id) AS sclr_4
FROM
  promotion p0_
  INNER JOIN promotion_thalasso p3_ ON p0_.id = p3_.promotion_id
  INNER JOIN produit_thalasso p2_ ON p2_.id = p3_.produit_thalasso_id
  LEFT JOIN promotion_chambre p5_ ON p0_.id = p5_.promotion_id
  LEFT JOIN chambre c4_ ON c4_.id = p5_.chambre_id
  INNER JOIN type_promotion t6_ ON p0_.type_promotion_id = t6_.id
  LEFT JOIN promotion_application p7_ ON p0_.id = p7_.promotion_id
  LEFT JOIN application a1_ ON a1_.id = p7_.application_id
  INNER JOIN promotion_affichage p8_ ON p0_.id = p8_.promotion_id
  INNER JOIN promotion_validite p9_ ON p0_.id = p9_.promotion_id
WHERE
  p0_.actif = 1
  AND p2_.id = ?
  AND c4_.id IS NULL
  AND (
    t6_.id = ?
    OR t6_.id = ?
  )
  AND (
    ? >= p8_.date_debut_affichage
    AND ? < p8_.date_fin_affichage
  )
  AND (
    ? >= p9_.date_debut_validite
    AND ? < p9_.date_fin_validite
  )
GROUP BY
  p0_.id

SELECT p0_.id AS id_0, p0_.pourcentage AS pourcentage_1, p0_.cumul_promo AS cumul_promo_2, p0_.montant AS montant_3, GROUP_CONCAT(a1_.id) AS sclr_4 FROM promotion p0_ INNER JOIN promotion_thalasso p3_ ON p0_.id = p3_.promotion_id INNER JOIN produit_thalasso p2_ ON p2_.id = p3_.produit_thalasso_id LEFT JOIN promotion_chambre p5_ ON p0_.id = p5_.promotion_id LEFT JOIN chambre c4_ ON c4_.id = p5_.chambre_id INNER JOIN type_promotion t6_ ON p0_.type_promotion_id = t6_.id LEFT JOIN promotion_application p7_ ON p0_.id = p7_.promotion_id LEFT JOIN application a1_ ON a1_.id = p7_.application_id INNER JOIN promotion_affichage p8_ ON p0_.id = p8_.promotion_id INNER JOIN promotion_validite p9_ ON p0_.id = p9_.promotion_id WHERE p0_.actif = 1 AND p2_.id = 27 AND c4_.id IS NULL AND (t6_.id = 2 OR t6_.id = 3) AND ('2025-04-30' >= p8_.date_debut_affichage AND '2025-04-30' < p8_.date_fin_affichage) AND ('2025-05-01' >= p9_.date_debut_validite AND '2025-05-01' < p9_.date_fin_validite) GROUP BY p0_.id;

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 = 23 AND t0.field = 'url_lien_principal' AND t0.locale = 'en' LIMIT 1;

SELECT
  d0_.date_dispo AS date_dispo_0,
  d0_.stock_dispo AS stock_dispo_1,
  DATE_FORMAT(d0_.date_dispo, '%c/%Y') AS sclr_2,
  1 AS sclr_3,
  DATE_FORMAT(d0_.date_dispo, '%e/%c/%Y') AS sclr_4,
  'null' AS sclr_5,
  p1_.id AS id_6,
  n2_.id AS id_7,
  b3_.id AS id_8,
  p4_.prix_double AS prix_double_9,
  p4_.prix_individuelle AS prix_individuelle_10,
  p4_.prix_accompagnant AS prix_accompagnant_11,
  (p4_.val_prix) AS sclr_12
FROM
  dispo_produit d0_
  INNER JOIN produit_thalasso p1_ ON d0_.produit_thalasso_id = p1_.id
  INNER JOIN tarif_produit_thalasso t5_ ON p1_.id = t5_.produit_thalasso_id
  INNER JOIN prix p4_ ON t5_.prix_id = p4_.id
  INNER JOIN niveau_prix n2_ ON p4_.niveau_prix_id = n2_.id
  INNER JOIN bar b3_ ON p4_.bars_id = b3_.id
WHERE
  p1_.id = ?
  AND d0_.stock_dispo >= ?
  AND t5_.date_tarif = d0_.date_dispo
  AND (
    d0_.date_dispo BETWEEN ?
    AND ?
  )
  AND d0_.date_dispo <> ?
GROUP BY
  d0_.date_dispo
ORDER BY
  d0_.date_dispo ASC

SELECT d0_.date_dispo AS date_dispo_0, d0_.stock_dispo AS stock_dispo_1, DATE_FORMAT(d0_.date_dispo, '%c/%Y') AS sclr_2, 1 AS sclr_3, DATE_FORMAT(d0_.date_dispo, '%e/%c/%Y') AS sclr_4, 'null' AS sclr_5, p1_.id AS id_6, n2_.id AS id_7, b3_.id AS id_8, p4_.prix_double AS prix_double_9, p4_.prix_individuelle AS prix_individuelle_10, p4_.prix_accompagnant AS prix_accompagnant_11, (p4_.val_prix) AS sclr_12 FROM dispo_produit d0_ INNER JOIN produit_thalasso p1_ ON d0_.produit_thalasso_id = p1_.id INNER JOIN tarif_produit_thalasso t5_ ON p1_.id = t5_.produit_thalasso_id INNER JOIN prix p4_ ON t5_.prix_id = p4_.id INNER JOIN niveau_prix n2_ ON p4_.niveau_prix_id = n2_.id INNER JOIN bar b3_ ON p4_.bars_id = b3_.id WHERE p1_.id = 27 AND d0_.stock_dispo >= 1 AND t5_.date_tarif = d0_.date_dispo AND (d0_.date_dispo BETWEEN '2025-04-30' AND '2026-04-30') AND d0_.date_dispo <> '2025-04-30' GROUP BY d0_.date_dispo ORDER BY d0_.date_dispo ASC;

SELECT
  t0_.id AS id_0,
  t0_.date_tarif AS date_tarif_1,
  t0_.created_at AS created_at_2,
  t0_.updated_at AS updated_at_3,
  p1_.id AS id_4,
  c2_.id AS id_5
FROM
  tarif_produit_thalasso_chambre t0_
  INNER JOIN produit_thalasso p1_ ON t0_.produit_thalasso_id = p1_.id
  INNER JOIN chambre c2_ ON t0_.chambre_id = c2_.id
  INNER JOIN produit_thalasso_chambres p4_ ON c2_.id = p4_.chambre_id
  INNER JOIN produit_thalasso p3_ ON p3_.id = p4_.produit_thalasso_id
WHERE
  p1_.id = ?
  AND t0_.date_tarif > CURRENT_TIMESTAMP
  AND p3_.id = ?
ORDER BY
  c2_.position ASC
LIMIT
  1

SELECT t0_.id AS id_0, t0_.date_tarif AS date_tarif_1, t0_.created_at AS created_at_2, t0_.updated_at AS updated_at_3, p1_.id AS id_4, c2_.id AS id_5 FROM tarif_produit_thalasso_chambre t0_ INNER JOIN produit_thalasso p1_ ON t0_.produit_thalasso_id = p1_.id INNER JOIN chambre c2_ ON t0_.chambre_id = c2_.id INNER JOIN produit_thalasso_chambres p4_ ON c2_.id = p4_.chambre_id INNER JOIN produit_thalasso p3_ ON p3_.id = p4_.produit_thalasso_id WHERE p1_.id = 27 AND t0_.date_tarif > CURRENT_TIMESTAMP AND p3_.id = 27 ORDER BY c2_.position ASC LIMIT 1;

SELECT
  d0_.date_dispo AS date_dispo_0,
  d0_.stock_dispo AS stock_dispo_1,
  DATE_FORMAT(d0_.date_dispo, '%c/%Y') AS sclr_2,
  1 AS sclr_3,
  DATE_FORMAT(d0_.date_dispo, '%e/%c/%Y') AS sclr_4,
  'null' AS sclr_5,
  p1_.id AS id_6,
  n2_.id AS id_7,
  b3_.id AS id_8,
  p4_.prix_double AS prix_double_9,
  p4_.prix_individuelle AS prix_individuelle_10,
  p4_.prix_accompagnant AS prix_accompagnant_11,
  (p4_.val_prix) AS sclr_12
FROM
  dispo_produit d0_
  INNER JOIN produit_thalasso p1_ ON d0_.produit_thalasso_id = p1_.id
  INNER JOIN tarif_produit_thalasso t5_ ON p1_.id = t5_.produit_thalasso_id
  INNER JOIN prix p4_ ON t5_.prix_id = p4_.id
  INNER JOIN niveau_prix n2_ ON p4_.niveau_prix_id = n2_.id
  INNER JOIN bar b3_ ON p4_.bars_id = b3_.id
WHERE
  p1_.id = ?
  AND d0_.stock_dispo >= ?
  AND t5_.date_tarif = d0_.date_dispo
  AND (
    d0_.date_dispo BETWEEN ?
    AND ?
  )
GROUP BY
  d0_.date_dispo
ORDER BY
  d0_.date_dispo ASC

SELECT d0_.date_dispo AS date_dispo_0, d0_.stock_dispo AS stock_dispo_1, DATE_FORMAT(d0_.date_dispo, '%c/%Y') AS sclr_2, 1 AS sclr_3, DATE_FORMAT(d0_.date_dispo, '%e/%c/%Y') AS sclr_4, 'null' AS sclr_5, p1_.id AS id_6, n2_.id AS id_7, b3_.id AS id_8, p4_.prix_double AS prix_double_9, p4_.prix_individuelle AS prix_individuelle_10, p4_.prix_accompagnant AS prix_accompagnant_11, (p4_.val_prix) AS sclr_12 FROM dispo_produit d0_ INNER JOIN produit_thalasso p1_ ON d0_.produit_thalasso_id = p1_.id INNER JOIN tarif_produit_thalasso t5_ ON p1_.id = t5_.produit_thalasso_id INNER JOIN prix p4_ ON t5_.prix_id = p4_.id INNER JOIN niveau_prix n2_ ON p4_.niveau_prix_id = n2_.id INNER JOIN bar b3_ ON p4_.bars_id = b3_.id WHERE p1_.id = 191 AND d0_.stock_dispo >= 1 AND t5_.date_tarif = d0_.date_dispo AND (d0_.date_dispo BETWEEN '2025-04-30' AND '2026-04-30') GROUP BY d0_.date_dispo ORDER BY d0_.date_dispo ASC;

SELECT
  t0.id AS id_1,
  t0.lien_aquao AS lien_aquao_2,
  t0.nom_produit_thalasso AS nom_produit_thalasso_3,
  t0.directement_tunnel AS directement_tunnel_4,
  t0.departure AS departure_5,
  t0.arrival AS arrival_6,
  t0.date_arrivee_exigee AS date_arrivee_exigee_7,
  t0.duree_minute AS duree_minute_8,
  t0.duree_heure AS duree_heure_9,
  t0.duree_jours AS duree_jours_10,
  t0.duree_nuitee AS duree_nuitee_11,
  t0.nbr_participants_min AS nbr_participants_min_12,
  t0.hebergement AS hebergement_13,
  t0.vendable_bon_cadeau AS vendable_bon_cadeau_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.accroche AS accroche_17,
  t0.description AS description_18,
  t0.actif AS actif_19,
  t0.position_1 AS position_1_20,
  t0.position_2 AS position_2_21,
  t0.position_3 AS position_3_22,
  t0.position_4 AS position_4_23,
  t0.position_5 AS position_5_24,
  t0.dummy_position AS dummy_position_25,
  t0.description_2 AS description_2_26,
  t0.limitation_horaire AS limitation_horaire_27,
  t0.heure_limit AS heure_limit_28,
  t0.min_daylimit AS min_daylimit_29,
  t0.arrhes_100 AS arrhes_100_30,
  t0.nrr AS nrr_31,
  t0.categorie_thalasso_id AS categorie_thalasso_id_32,
  t33.id AS id_34,
  t33.nom_page AS nom_page_35,
  t33.position AS position_36,
  t33.seo_slug AS seo_slug_37,
  t33.seo_meta_title AS seo_meta_title_38,
  t33.seo_meta_description AS seo_meta_description_39,
  t33.created_at AS created_at_40,
  t33.updated_at AS updated_at_41,
  t33.header_sur_titre AS header_sur_titre_42,
  t33.header_titre AS header_titre_43,
  t33.alt_header_img AS alt_header_img_44,
  t33.actif AS actif_45,
  t33.id_video AS id_video_46,
  t33.page_type AS page_type_47,
  t33.header_video AS header_video_48,
  t33.date_fin AS date_fin_49,
  t33.cms_template_id AS cms_template_id_50,
  t33.header_image_id AS header_image_id_51,
  t33.produit_thalasso_id AS produit_thalasso_id_52,
  t33.produit_chambre_id AS produit_chambre_id_53,
  t33.parent_id AS parent_id_54
FROM
  produit_thalasso t0
  LEFT JOIN cms_page t33 ON t33.produit_thalasso_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.lien_aquao AS lien_aquao_2, t0.nom_produit_thalasso AS nom_produit_thalasso_3, t0.directement_tunnel AS directement_tunnel_4, t0.departure AS departure_5, t0.arrival AS arrival_6, t0.date_arrivee_exigee AS date_arrivee_exigee_7, t0.duree_minute AS duree_minute_8, t0.duree_heure AS duree_heure_9, t0.duree_jours AS duree_jours_10, t0.duree_nuitee AS duree_nuitee_11, t0.nbr_participants_min AS nbr_participants_min_12, t0.hebergement AS hebergement_13, t0.vendable_bon_cadeau AS vendable_bon_cadeau_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.accroche AS accroche_17, t0.description AS description_18, t0.actif AS actif_19, t0.position_1 AS position_1_20, t0.position_2 AS position_2_21, t0.position_3 AS position_3_22, t0.position_4 AS position_4_23, t0.position_5 AS position_5_24, t0.dummy_position AS dummy_position_25, t0.description_2 AS description_2_26, t0.limitation_horaire AS limitation_horaire_27, t0.heure_limit AS heure_limit_28, t0.min_daylimit AS min_daylimit_29, t0.arrhes_100 AS arrhes_100_30, t0.nrr AS nrr_31, t0.categorie_thalasso_id AS categorie_thalasso_id_32, t33.id AS id_34, t33.nom_page AS nom_page_35, t33.position AS position_36, t33.seo_slug AS seo_slug_37, t33.seo_meta_title AS seo_meta_title_38, t33.seo_meta_description AS seo_meta_description_39, t33.created_at AS created_at_40, t33.updated_at AS updated_at_41, t33.header_sur_titre AS header_sur_titre_42, t33.header_titre AS header_titre_43, t33.alt_header_img AS alt_header_img_44, t33.actif AS actif_45, t33.id_video AS id_video_46, t33.page_type AS page_type_47, t33.header_video AS header_video_48, t33.date_fin AS date_fin_49, t33.cms_template_id AS cms_template_id_50, t33.header_image_id AS header_image_id_51, t33.produit_thalasso_id AS produit_thalasso_id_52, t33.produit_chambre_id AS produit_chambre_id_53, t33.parent_id AS parent_id_54 FROM produit_thalasso t0 LEFT JOIN cms_page t33 ON t33.produit_thalasso_id = t0.id WHERE t0.id = 27;

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 = 7 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_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 = 69 AND t0.field = 'masquer' AND t0.locale = 'en' LIMIT 1;

SELECT
  p0_.content AS content_0,
  p0_.field AS field_1
FROM
  produit_thalasso_translation p0_
WHERE
  p0_.locale = ?
  AND p0_.object_id = ?

SELECT p0_.content AS content_0, p0_.field AS field_1 FROM produit_thalasso_translation p0_ WHERE p0_.locale = 'en' AND p0_.object_id = 27;

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

SELECT
  p0_.limitation_horaire AS limitation_horaire_0,
  p0_.heure_limit AS heure_limit_1,
  p0_.min_daylimit AS min_daylimit_2
FROM
  produit_thalasso p0_
WHERE
  p0_.id = ?

SELECT p0_.limitation_horaire AS limitation_horaire_0, p0_.heure_limit AS heure_limit_1, p0_.min_daylimit AS min_daylimit_2 FROM produit_thalasso p0_ WHERE p0_.id = 27;

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 = 'en' AND c0_.object_id = 23;

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

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

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 = 'thalasso-day-experiences' AND c1_.page_type = 'hotel' 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 = 2 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 = 7;