Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.is_actif AS is_actif_4,
  t0.is_default AS is_default_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8
FROM
  languages t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_actif AS is_actif_4, t0.is_default AS is_default_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8 FROM languages t0 WHERE t0.code = 'fr' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.is_actif AS is_actif_4,
  t0.is_default AS is_default_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8
FROM
  languages t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_actif AS is_actif_4, t0.is_default AS is_default_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8 FROM languages t0 WHERE t0.code = 'fr' LIMIT 1;

SELECT
  p0_.slug AS slug_0,
  p0_.page_category_id AS sclr_1
FROM
  page_category_lang p0_
WHERE
  p0_.language_id = ?
  AND p0_.page_category_id IN (?)

SELECT p0_.slug AS slug_0, p0_.page_category_id AS sclr_1 FROM page_category_lang p0_ WHERE p0_.language_id = 1 AND p0_.page_category_id IN ('1');

SELECT
  p0_.slug AS slug_0,
  p0_.page_id AS sclr_1
FROM
  page_lang p0_
WHERE
  p0_.language_id = ?
  AND p0_.page_id IN (?, ?, ?, ?, ?, ?, ?, ?)

SELECT p0_.slug AS slug_0, p0_.page_id AS sclr_1 FROM page_lang p0_ WHERE p0_.language_id = 1 AND p0_.page_id IN ('4', '5', '8', '10', '9', '21', '32', '43');

SELECT
  p0_.slug AS slug_0,
  p0_.page_id AS sclr_1
FROM
  page_lang p0_
WHERE
  p0_.language_id = ?
  AND p0_.page_id IN (?, ?)

SELECT p0_.slug AS slug_0, p0_.page_id AS sclr_1 FROM page_lang p0_ WHERE p0_.language_id = 1 AND p0_.page_id IN ('21', '22');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.is_actif AS is_actif_4,
  t0.is_default AS is_default_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8
FROM
  languages t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_actif AS is_actif_4, t0.is_default AS is_default_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8 FROM languages t0 WHERE t0.code = 'fr' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.description AS description_3,
  t0.name AS name_4,
  t0.language_id AS language_id_5,
  t0.page_category_id AS page_category_id_6
FROM
  page_category_lang t0
WHERE
  t0.language_id = ?
  AND t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.description AS description_3, t0.name AS name_4, t0.language_id AS language_id_5, t0.page_category_id AS page_category_id_6 FROM page_category_lang t0 WHERE t0.language_id = 1 AND t0.slug = 'references' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.origin AS origin_2,
  t0.id_origin AS id_origin_3,
  t0.file AS file_4,
  t0.extension AS extension_5,
  t0.taille AS taille_6,
  t0.path AS path_7,
  t0.title AS title_8,
  t0.position AS position_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.deleted_at AS deleted_at_12,
  t0.type AS type_13,
  t0.language_id AS language_id_14
FROM
  media t0
WHERE
  t0.id_origin = ?
  AND t0.origin = ?
  AND t0.deleted_at IS NULL

SELECT t0.id AS id_1, t0.origin AS origin_2, t0.id_origin AS id_origin_3, t0.file AS file_4, t0.extension AS extension_5, t0.taille AS taille_6, t0.path AS path_7, t0.title AS title_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.type AS type_13, t0.language_id AS language_id_14 FROM media t0 WHERE t0.id_origin = 1 AND t0.origin = 'Proxies\\__CG__\\App\\Entity\\Pages\\PageCategory' AND t0.deleted_at IS NULL;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.is_enable AS is_enable_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6
FROM
  page_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.is_enable AS is_enable_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6 FROM page_category t0 WHERE t0.id = 1;

SELECT
  p0_.id AS id_0,
  p0_.created_at AS created_at_1,
  p0_.is_enable AS is_enable_2,
  p1_.name AS name_3,
  p1_.slug AS slug_4,
  p1_.description AS description_5,
  p2_.name AS name_6,
  p3_.id AS id_7,
  p2_.slug AS slug_8
FROM
  page_sous_category p0_
  LEFT JOIN page_sous_category_lang p1_ ON p0_.id = p1_.pagesouscategory_id
  AND (p1_.language_id = ?)
  LEFT JOIN page_category p3_ ON p0_.category_id = p3_.id
  LEFT JOIN page_category_lang p2_ ON p3_.id = p2_.page_category_id
  AND (p2_.language_id = ?)
WHERE
  p0_.deleted_at IS NULL
  AND p0_.is_enable = ?
  AND p3_.deleted_at IS NULL
  AND p3_.is_enable = 1
  AND p3_.id = (?)
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.is_enable AS is_enable_2, p1_.name AS name_3, p1_.slug AS slug_4, p1_.description AS description_5, p2_.name AS name_6, p3_.id AS id_7, p2_.slug AS slug_8 FROM page_sous_category p0_ LEFT JOIN page_sous_category_lang p1_ ON p0_.id = p1_.pagesouscategory_id AND (p1_.language_id = 1) LEFT JOIN page_category p3_ ON p0_.category_id = p3_.id LEFT JOIN page_category_lang p2_ ON p3_.id = p2_.page_category_id AND (p2_.language_id = 1) WHERE p0_.deleted_at IS NULL AND p0_.is_enable = 1 AND p3_.deleted_at IS NULL AND p3_.is_enable = 1 AND p3_.id = (1) ORDER BY p0_.id ASC;

SELECT
  p0_.id AS id_0,
  p0_.created_at AS created_at_1,
  p0_.is_enable AS is_enable_2,
  p0_.is_contact AS is_contact_3,
  p1_.name AS name_4,
  p1_.slug AS slug_5,
  p1_.description AS description_6,
  p0_.classe_titre_contact AS classe_titre_contact_7,
  p0_.link_visiter_site AS link_visiter_site_8,
  p0_.classe_body_page AS classe_body_page_9,
  p0_.is_demo AS is_demo_10,
  p2_.id AS id_11,
  p2_.type AS type_12,
  p3_.is_enable AS is_enable_13,
  m4_.id AS id_14,
  m4_.file AS file_15,
  m4_.path AS path_16,
  m4_.type AS type_17
FROM
  page p0_
  LEFT JOIN page_lang p1_ ON p0_.id = p1_.page_id
  AND (p1_.language_id = ?)
  LEFT JOIN media m4_ ON (
    m4_.id_origin = p0_.id
    AND m4_.origin = ?
    AND m4_.language_id = ?
  )
  LEFT JOIN page_sous_category p3_ ON p0_.page_sous_category_id = p3_.id
  LEFT JOIN page_category p2_ ON p3_.category_id = p2_.id
  LEFT JOIN page_sous_category_lang p5_ ON p3_.id = p5_.pagesouscategory_id
  AND (p5_.language_id = ?)
  LEFT JOIN page_category_lang p6_ ON p2_.id = p6_.page_category_id
  AND (p6_.language_id = ?)
WHERE
  (
    p0_.deleted_at IS NULL
    AND p0_.is_enable = 1
  )
  AND p0_.is_enable = ?
  AND (
    p3_.deleted_at IS NULL
    AND p3_.is_enable = 1
  )
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.is_enable AS is_enable_2, p0_.is_contact AS is_contact_3, p1_.name AS name_4, p1_.slug AS slug_5, p1_.description AS description_6, p0_.classe_titre_contact AS classe_titre_contact_7, p0_.link_visiter_site AS link_visiter_site_8, p0_.classe_body_page AS classe_body_page_9, p0_.is_demo AS is_demo_10, p2_.id AS id_11, p2_.type AS type_12, p3_.is_enable AS is_enable_13, m4_.id AS id_14, m4_.file AS file_15, m4_.path AS path_16, m4_.type AS type_17 FROM page p0_ LEFT JOIN page_lang p1_ ON p0_.id = p1_.page_id AND (p1_.language_id = 1) LEFT JOIN media m4_ ON (m4_.id_origin = p0_.id AND m4_.origin = 'App\\Entity\\Pages\\Page' AND m4_.language_id = 1) LEFT JOIN page_sous_category p3_ ON p0_.page_sous_category_id = p3_.id LEFT JOIN page_category p2_ ON p3_.category_id = p2_.id LEFT JOIN page_sous_category_lang p5_ ON p3_.id = p5_.pagesouscategory_id AND (p5_.language_id = 1) LEFT JOIN page_category_lang p6_ ON p2_.id = p6_.page_category_id AND (p6_.language_id = 1) WHERE (p0_.deleted_at IS NULL AND p0_.is_enable = 1) AND p0_.is_enable = 1 AND (p3_.deleted_at IS NULL AND p3_.is_enable = 1) ORDER BY p0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.origin AS origin_2,
  t0.id_origin AS id_origin_3,
  t0.value AS value_4
FROM
  palette_color t0
WHERE
  t0.origin = ?
  AND t0.id_origin = ?

SELECT t0.id AS id_1, t0.origin AS origin_2, t0.id_origin AS id_origin_3, t0.value AS value_4 FROM palette_color t0 WHERE t0.origin = 'App\\Entity\\Pages\\PageCategory' AND t0.id_origin = 1;

SELECT
  b0_.id AS id_0,
  b0_.position AS position_1,
  b0_.is_fix_title AS is_fix_title_2,
  b0_.type AS type_3,
  b0_.classe AS classe_4,
  b0_.id_origin AS id_origin_5,
  b0_.id_type AS id_type_6,
  b0_.origin AS origin_7,
  b0_.first_position AS first_position_8,
  b0_.second_position AS second_position_9,
  b0_.is_show_title AS is_show_title_10,
  b0_.position_image AS position_image_11,
  b0_.position_video AS position_video_12,
  b0_.col_txt AS col_txt_13,
  b0_.col_image AS col_image_14,
  b0_.col_card AS col_card_15,
  b0_.alignement_texte AS alignement_texte_16,
  b0_.istitre_principale_bloc AS istitre_principale_bloc_17,
  b0_.is_btn AS is_btn_18,
  b0_.titre_principale_bloc AS titre_principale_bloc_19,
  b0_.classe_titre_principale_bloc AS classe_titre_principale_bloc_20,
  b1_.title AS title_21,
  b1_.description AS description_22,
  m2_.id AS id_23,
  m2_.file AS file_24,
  m2_.path AS path_25,
  m2_.extension AS extension_26,
  m2_.title AS title_27,
  m2_.type AS type_28,
  c3_.id AS id_29,
  c3_.is_enable AS is_enable_30,
  c4_.title_top AS title_top_31,
  c4_.title AS title_32,
  c4_.description AS description_33,
  c3_.link AS link_34,
  c3_.classe AS classe_35,
  m5_.id AS id_36,
  m5_.origin AS origin_37,
  m5_.file AS file_38,
  m5_.path AS path_39,
  m5_.extension AS extension_40,
  c6_.id AS id_41,
  c7_.title_top AS title_top_42,
  c6_.is_enable AS is_enable_43,
  c7_.title AS title_44,
  c7_.description AS description_45,
  c6_.link AS link_46,
  c6_.classe AS classe_47,
  m8_.id AS id_48,
  m8_.origin AS origin_49,
  m8_.file AS file_50,
  m8_.path AS path_51,
  m8_.extension AS extension_52
FROM
  bloc b0_
  LEFT JOIN bloc_lang b1_ ON b0_.id = b1_.bloc_id
  AND (b1_.language_id = ?)
  LEFT JOIN media m2_ ON (
    m2_.id_origin = b0_.id
    AND m2_.origin = ?
    AND m2_.language_id = ?
  )
  LEFT JOIN client_bloc c6_ ON b0_.client_right_id = c6_.id
  LEFT JOIN client_bloc_lang c7_ ON c6_.id = c7_.client_bloc_lang_id
  AND (c7_.language_id = ?)
  LEFT JOIN media m8_ ON (
    m8_.origin = ?
    AND m8_.id_origin = c6_.id
    AND m8_.language_id = ?
  )
  LEFT JOIN client_bloc c3_ ON b0_.client_left_id = c3_.id
  LEFT JOIN client_bloc_lang c4_ ON c3_.id = c4_.client_bloc_lang_id
  AND (c4_.language_id = ?)
  LEFT JOIN media m5_ ON (
    m5_.origin = ?
    AND m5_.id_origin = c3_.id
    AND m5_.language_id = ?
  )
WHERE
  b0_.origin = ?
  AND b0_.id_origin = ?
  AND m2_.deleted_at IS NULL
  AND m8_.deleted_at IS NULL
  AND m5_.deleted_at IS NULL
ORDER BY
  b0_.position ASC

SELECT b0_.id AS id_0, b0_.position AS position_1, b0_.is_fix_title AS is_fix_title_2, b0_.type AS type_3, b0_.classe AS classe_4, b0_.id_origin AS id_origin_5, b0_.id_type AS id_type_6, b0_.origin AS origin_7, b0_.first_position AS first_position_8, b0_.second_position AS second_position_9, b0_.is_show_title AS is_show_title_10, b0_.position_image AS position_image_11, b0_.position_video AS position_video_12, b0_.col_txt AS col_txt_13, b0_.col_image AS col_image_14, b0_.col_card AS col_card_15, b0_.alignement_texte AS alignement_texte_16, b0_.istitre_principale_bloc AS istitre_principale_bloc_17, b0_.is_btn AS is_btn_18, b0_.titre_principale_bloc AS titre_principale_bloc_19, b0_.classe_titre_principale_bloc AS classe_titre_principale_bloc_20, b1_.title AS title_21, b1_.description AS description_22, m2_.id AS id_23, m2_.file AS file_24, m2_.path AS path_25, m2_.extension AS extension_26, m2_.title AS title_27, m2_.type AS type_28, c3_.id AS id_29, c3_.is_enable AS is_enable_30, c4_.title_top AS title_top_31, c4_.title AS title_32, c4_.description AS description_33, c3_.link AS link_34, c3_.classe AS classe_35, m5_.id AS id_36, m5_.origin AS origin_37, m5_.file AS file_38, m5_.path AS path_39, m5_.extension AS extension_40, c6_.id AS id_41, c7_.title_top AS title_top_42, c6_.is_enable AS is_enable_43, c7_.title AS title_44, c7_.description AS description_45, c6_.link AS link_46, c6_.classe AS classe_47, m8_.id AS id_48, m8_.origin AS origin_49, m8_.file AS file_50, m8_.path AS path_51, m8_.extension AS extension_52 FROM bloc b0_ LEFT JOIN bloc_lang b1_ ON b0_.id = b1_.bloc_id AND (b1_.language_id = 1) LEFT JOIN media m2_ ON (m2_.id_origin = b0_.id AND m2_.origin = 'App\\Entity\\Blocs\\Bloc' AND m2_.language_id = 1) LEFT JOIN client_bloc c6_ ON b0_.client_right_id = c6_.id LEFT JOIN client_bloc_lang c7_ ON c6_.id = c7_.client_bloc_lang_id AND (c7_.language_id = 1) LEFT JOIN media m8_ ON (m8_.origin = 'App\\Entity\\ClientBlocs\\ClientBloc' AND m8_.id_origin = c6_.id AND m8_.language_id = 1) LEFT JOIN client_bloc c3_ ON b0_.client_left_id = c3_.id LEFT JOIN client_bloc_lang c4_ ON c3_.id = c4_.client_bloc_lang_id AND (c4_.language_id = 1) LEFT JOIN media m5_ ON (m5_.origin = 'App\\Entity\\ClientBlocs\\ClientBloc' AND m5_.id_origin = c3_.id AND m5_.language_id = 1) WHERE b0_.origin = 'App\\Entity\\Pages\\PageCategory' AND b0_.id_origin = 1 AND m2_.deleted_at IS NULL AND m8_.deleted_at IS NULL AND m5_.deleted_at IS NULL ORDER BY b0_.position ASC;

SELECT
  l0_.id AS id_0,
  l0_.created_at AS created_at_1,
  l0_.is_enable AS is_enable_2,
  l0_.classe AS classe_3,
  l1_.name AS name_4,
  l1_.description AS description_5,
  l2_.id AS id_6,
  l2_.link AS link_7,
  l3_.second_title AS second_title_8,
  l3_.name AS name_9,
  l2_.is_show_title_labels AS is_show_title_labels_10,
  l3_.description AS description_11,
  l2_.classe AS classe_12,
  l2_.col_bloc_label_slide AS col_bloc_label_slide_13,
  m4_.id AS id_14,
  m4_.file AS file_15,
  m4_.path AS path_16,
  m4_.title AS title_17
FROM
  label_bloc l0_
  LEFT JOIN label_bloc_lang l1_ ON l0_.id = l1_.label_bloc_id
  AND (l1_.language_id = ?)
  LEFT JOIN label_slider l2_ ON l0_.id = l2_.label_bloc_id
  LEFT JOIN label_slider_lang l3_ ON l2_.id = l3_.label_slider_id
  AND (l3_.language_id = ?)
  LEFT JOIN media m4_ ON (
    m4_.id_origin = l2_.id
    AND m4_.origin = ?
    AND m4_.language_id = ?
  )
WHERE
  l0_.deleted_at IS NULL
  AND l0_.is_enable = ?
  AND (
    l2_.deleted_at IS NULL
    AND l2_.is_enable = 1
  )
  AND m4_.deleted_at IS NULL
ORDER BY
  l0_.id DESC

SELECT l0_.id AS id_0, l0_.created_at AS created_at_1, l0_.is_enable AS is_enable_2, l0_.classe AS classe_3, l1_.name AS name_4, l1_.description AS description_5, l2_.id AS id_6, l2_.link AS link_7, l3_.second_title AS second_title_8, l3_.name AS name_9, l2_.is_show_title_labels AS is_show_title_labels_10, l3_.description AS description_11, l2_.classe AS classe_12, l2_.col_bloc_label_slide AS col_bloc_label_slide_13, m4_.id AS id_14, m4_.file AS file_15, m4_.path AS path_16, m4_.title AS title_17 FROM label_bloc l0_ LEFT JOIN label_bloc_lang l1_ ON l0_.id = l1_.label_bloc_id AND (l1_.language_id = 1) LEFT JOIN label_slider l2_ ON l0_.id = l2_.label_bloc_id LEFT JOIN label_slider_lang l3_ ON l2_.id = l3_.label_slider_id AND (l3_.language_id = 1) LEFT JOIN media m4_ ON (m4_.id_origin = l2_.id AND m4_.origin = 'App\\Entity\\Labels\\LabelSlider' AND m4_.language_id = 1) WHERE l0_.deleted_at IS NULL AND l0_.is_enable = 1 AND (l2_.deleted_at IS NULL AND l2_.is_enable = 1) AND m4_.deleted_at IS NULL ORDER BY l0_.id DESC;

SELECT
  c0_.id AS id_0,
  c0_.created_at AS created_at_1,
  c0_.is_enable AS is_enable_2,
  c1_.name AS name_3,
  c0_.class AS class_4,
  c2_.id AS id_5,
  c3_.name AS name_6,
  c3_.description AS description_7,
  c3_.title_mobile AS title_mobile_8,
  c2_.is_enable AS is_enable_9,
  c2_.background_color AS background_color_10,
  m4_.id AS id_11,
  m4_.file AS file_12,
  m4_.path AS path_13,
  m4_.extension AS extension_14
FROM
  carrousel c0_
  LEFT JOIN carrousel_lang c1_ ON c0_.id = c1_.carrousel_id
  AND (c1_.language_id = ?)
  LEFT JOIN carrousel_items c2_ ON c0_.id = c2_.carrousel_id
  LEFT JOIN carrousel_items_lang c3_ ON c2_.id = c3_.carousel_items_id
  AND (c3_.language_id = ?)
  LEFT JOIN media m4_ ON (
    m4_.id_origin = c2_.id
    AND m4_.origin = ?
    AND m4_.language_id = ?
  )
WHERE
  c0_.deleted_at IS NULL
  AND (
    c2_.deleted_at IS NULL
    AND c2_.is_enable = 1
  )
  AND m4_.deleted_at IS NULL
ORDER BY
  c0_.id DESC,
  c2_.id ASC

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.is_enable AS is_enable_2, c1_.name AS name_3, c0_.class AS class_4, c2_.id AS id_5, c3_.name AS name_6, c3_.description AS description_7, c3_.title_mobile AS title_mobile_8, c2_.is_enable AS is_enable_9, c2_.background_color AS background_color_10, m4_.id AS id_11, m4_.file AS file_12, m4_.path AS path_13, m4_.extension AS extension_14 FROM carrousel c0_ LEFT JOIN carrousel_lang c1_ ON c0_.id = c1_.carrousel_id AND (c1_.language_id = 1) LEFT JOIN carrousel_items c2_ ON c0_.id = c2_.carrousel_id LEFT JOIN carrousel_items_lang c3_ ON c2_.id = c3_.carousel_items_id AND (c3_.language_id = 1) LEFT JOIN media m4_ ON (m4_.id_origin = c2_.id AND m4_.origin = 'App\\Entity\\Carrousel\\carrouselItems' AND m4_.language_id = 1) WHERE c0_.deleted_at IS NULL AND (c2_.deleted_at IS NULL AND c2_.is_enable = 1) AND m4_.deleted_at IS NULL ORDER BY c0_.id DESC, c2_.id ASC;

SELECT
  b0_.id AS id_0,
  b0_.created_at AS created_at_1,
  b0_.is_enable AS is_enable_2,
  b1_.name AS name_3,
  b1_.description AS description_4,
  b2_.id AS id_5,
  b2_.classe AS classe_6,
  b3_.name AS name_7,
  b3_.description AS description_8,
  b2_.col_benefice_items AS col_benefice_items_9,
  b2_.cards_links AS cards_links_10,
  b3_.link AS link_11,
  m4_.id AS id_12,
  m4_.file AS file_13,
  m4_.path AS path_14,
  m4_.title AS title_15
FROM
  benefice b0_
  LEFT JOIN benefice_lang b1_ ON b0_.id = b1_.benefice_bloc_id
  AND (b1_.language_id = ?)
  LEFT JOIN benefice_items b2_ ON b0_.id = b2_.benefice_id
  LEFT JOIN benefice_items_lang b3_ ON b2_.id = b3_.benefice_items_id
  AND (b3_.language_id = ?)
  LEFT JOIN media m4_ ON (
    m4_.id_origin = b2_.id
    AND m4_.origin = ?
    AND m4_.language_id = ?
  )
WHERE
  b0_.deleted_at IS NULL
  AND b0_.is_enable = ?
  AND (
    b2_.deleted_at IS NULL
    AND b2_.is_enable = 1
  )
  AND m4_.deleted_at IS NULL
ORDER BY
  b0_.id DESC

SELECT b0_.id AS id_0, b0_.created_at AS created_at_1, b0_.is_enable AS is_enable_2, b1_.name AS name_3, b1_.description AS description_4, b2_.id AS id_5, b2_.classe AS classe_6, b3_.name AS name_7, b3_.description AS description_8, b2_.col_benefice_items AS col_benefice_items_9, b2_.cards_links AS cards_links_10, b3_.link AS link_11, m4_.id AS id_12, m4_.file AS file_13, m4_.path AS path_14, m4_.title AS title_15 FROM benefice b0_ LEFT JOIN benefice_lang b1_ ON b0_.id = b1_.benefice_bloc_id AND (b1_.language_id = 1) LEFT JOIN benefice_items b2_ ON b0_.id = b2_.benefice_id LEFT JOIN benefice_items_lang b3_ ON b2_.id = b3_.benefice_items_id AND (b3_.language_id = 1) LEFT JOIN media m4_ ON (m4_.id_origin = b2_.id AND m4_.origin = 'App\\Entity\\Benefice\\BeneficeItems' AND m4_.language_id = 1) WHERE b0_.deleted_at IS NULL AND b0_.is_enable = 1 AND (b2_.deleted_at IS NULL AND b2_.is_enable = 1) AND m4_.deleted_at IS NULL ORDER BY b0_.id DESC;

SELECT
  b0_.id AS id_0,
  b1_.id AS id_1,
  i2_.id AS id_2,
  i3_.description AS description_3,
  i2_.classe AS classe_4,
  m4_.id AS id_5,
  m4_.file AS file_6,
  m4_.path AS path_7,
  m4_.title AS title_8
FROM
  bloc_solution b0_
  LEFT JOIN bloc b1_ ON b0_.bloc_id = b1_.id
  LEFT JOIN bloc_lang b5_ ON b1_.id = b5_.bloc_id
  AND (b5_.language_id = ?)
  LEFT JOIN items_solution i2_ ON b0_.item_solution_id = i2_.id
  LEFT JOIN media m4_ ON (
    m4_.id_origin = i2_.id
    AND m4_.origin = ?
    AND m4_.language_id = ?
  )
  LEFT JOIN items_solution_lang i3_ ON i2_.id = i3_.item_solution_id
  AND (i3_.language_id = ?)
WHERE
  i2_.deleted_at IS NULL
  AND b0_.bloc_id IN (?)
ORDER BY
  b0_.position ASC

SELECT b0_.id AS id_0, b1_.id AS id_1, i2_.id AS id_2, i3_.description AS description_3, i2_.classe AS classe_4, m4_.id AS id_5, m4_.file AS file_6, m4_.path AS path_7, m4_.title AS title_8 FROM bloc_solution b0_ LEFT JOIN bloc b1_ ON b0_.bloc_id = b1_.id LEFT JOIN bloc_lang b5_ ON b1_.id = b5_.bloc_id AND (b5_.language_id = 1) LEFT JOIN items_solution i2_ ON b0_.item_solution_id = i2_.id LEFT JOIN media m4_ ON (m4_.id_origin = i2_.id AND m4_.origin = 'App\\Entity\\ItemsSolution\\ItemsSolution' AND m4_.language_id = 1) LEFT JOIN items_solution_lang i3_ ON i2_.id = i3_.item_solution_id AND (i3_.language_id = 1) WHERE i2_.deleted_at IS NULL AND b0_.bloc_id IN (100) ORDER BY b0_.position ASC;

SELECT
  p0_.id AS id_0,
  p0_.created_at AS created_at_1,
  p0_.is_enable AS is_enable_2,
  p1_.name AS name_3,
  p1_.slug AS slug_4,
  p1_.description AS description_5
FROM
  page_category p0_
  LEFT JOIN page_category_lang p1_ ON p0_.id = p1_.page_category_id
  AND (p1_.language_id = ?)
WHERE
  p0_.deleted_at IS NULL
  AND p0_.id = ?
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.is_enable AS is_enable_2, p1_.name AS name_3, p1_.slug AS slug_4, p1_.description AS description_5 FROM page_category p0_ LEFT JOIN page_category_lang p1_ ON p0_.id = p1_.page_category_id AND (p1_.language_id = 1) WHERE p0_.deleted_at IS NULL AND p0_.id = 1 ORDER BY p0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.route AS route_2,
  t0.parameter AS parameter_3
FROM
  seo t0
WHERE
  t0.route = ?
  AND t0.parameter = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.route AS route_2, t0.parameter AS parameter_3 FROM seo t0 WHERE t0.route = 'front_page_category_show' AND t0.parameter = 'references' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.language_id AS language_id_5,
  t0.seo_id AS seo_id_6
FROM
  seo_lang t0
WHERE
  t0.seo_id = ?
  AND t0.language_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.language_id AS language_id_5, t0.seo_id AS seo_id_6 FROM seo_lang t0 WHERE t0.seo_id = 6 AND t0.language_id = 1 LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.created_at AS created_at_1,
  p0_.is_enable AS is_enable_2,
  p0_.is_contact AS is_contact_3,
  p1_.name AS name_4,
  p1_.slug AS slug_5,
  p1_.description AS description_6,
  p0_.classe_titre_contact AS classe_titre_contact_7,
  p0_.link_visiter_site AS link_visiter_site_8,
  p0_.classe_body_page AS classe_body_page_9,
  p0_.is_demo AS is_demo_10
FROM
  page p0_
  LEFT JOIN page_lang p1_ ON p0_.id = p1_.page_id
  AND (p1_.language_id = ?)
WHERE
  (
    p0_.deleted_at IS NULL
    AND p0_.is_enable = 1
  )
  AND p0_.id IN (?, ?, ?, ?)
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.is_enable AS is_enable_2, p0_.is_contact AS is_contact_3, p1_.name AS name_4, p1_.slug AS slug_5, p1_.description AS description_6, p0_.classe_titre_contact AS classe_titre_contact_7, p0_.link_visiter_site AS link_visiter_site_8, p0_.classe_body_page AS classe_body_page_9, p0_.is_demo AS is_demo_10 FROM page p0_ LEFT JOIN page_lang p1_ ON p0_.id = p1_.page_id AND (p1_.language_id = 1) WHERE (p0_.deleted_at IS NULL AND p0_.is_enable = 1) AND p0_.id IN ('10', '8', '5', '4') ORDER BY p0_.id ASC;