Symfony Profiler

SELECT
  t0.route AS route_1,
  t0.id AS id_2,
  t0.page_name AS page_name_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.h1_enabled AS h1_enabled_6,
  t0.h1 AS h1_7
FROM
  seopage t0
WHERE
  t0.route = ?
LIMIT
  1

SELECT t0.route AS route_1, t0.id AS id_2, t0.page_name AS page_name_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.h1_enabled AS h1_enabled_6, t0.h1 AS h1_7 FROM seopage t0 WHERE t0.route = 'app_search_index' LIMIT 1;

SELECT
  t0.rna AS rna_1,
  t0.id AS id_2,
  t0.phone AS phone_3,
  t0.email AS email_4,
  t0.address_street AS address_street_5,
  t0.zipcode AS zipcode_6,
  t0.city AS city_7,
  t0.legal_site_name AS legal_site_name_8,
  t0.legal_siret AS legal_siret_9,
  t0.legal_siren AS legal_siren_10,
  t0.legal_rcs AS legal_rcs_11,
  t0.legal_address AS legal_address_12,
  t0.legal_zipcode AS legal_zipcode_13,
  t0.legal_city AS legal_city_14,
  t0.legal_phone AS legal_phone_15,
  t0.legal_email AS legal_email_16,
  t0.legal_publication_owner AS legal_publication_owner_17,
  t0.legal_site_url AS legal_site_url_18,
  t0.default_title AS default_title_19,
  t0.default_meta_desc AS default_meta_desc_20
FROM
  site_settings t0

SELECT t0.rna AS rna_1, t0.id AS id_2, t0.phone AS phone_3, t0.email AS email_4, t0.address_street AS address_street_5, t0.zipcode AS zipcode_6, t0.city AS city_7, t0.legal_site_name AS legal_site_name_8, t0.legal_siret AS legal_siret_9, t0.legal_siren AS legal_siren_10, t0.legal_rcs AS legal_rcs_11, t0.legal_address AS legal_address_12, t0.legal_zipcode AS legal_zipcode_13, t0.legal_city AS legal_city_14, t0.legal_phone AS legal_phone_15, t0.legal_email AS legal_email_16, t0.legal_publication_owner AS legal_publication_owner_17, t0.legal_site_url AS legal_site_url_18, t0.default_title AS default_title_19, t0.default_meta_desc AS default_meta_desc_20 FROM site_settings t0;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.resume AS resume_2,
  a0_.illustration_name AS illustration_name_3,
  a0_.illustration_size AS illustration_size_4,
  a0_.illustration_updated_at AS illustration_updated_at_5,
  a0_.illustration_alt AS illustration_alt_6,
  a0_.activate AS activate_7,
  a0_.quote AS quote_8,
  a0_.created_at AS created_at_9,
  a0_.about_associate AS about_associate_10,
  a0_.composition_associate AS composition_associate_11,
  a0_.full_member_associate AS full_member_associate_12,
  a0_.departement_associate AS departement_associate_13,
  a0_.partner_associate AS partner_associate_14,
  a0_.publication_associate AS publication_associate_15,
  a0_.these_associate AS these_associate_16,
  a0_.actuality_associate AS actuality_associate_17,
  a0_.definition_associate AS definition_associate_18,
  a0_.manuel_associate AS manuel_associate_19,
  a0_.join_associate AS join_associate_20,
  a0_.old_id AS old_id_21,
  a0_.meta_title AS meta_title_22,
  a0_.meta_description AS meta_description_23,
  a0_.slug AS slug_24,
  s1_.id AS id_25,
  s1_.accordeon AS accordeon_26,
  s1_.title AS title_27,
  s1_.position AS position_28,
  p2_.id AS id_29,
  p2_.category AS category_30,
  p2_.sub_title AS sub_title_31,
  p2_.title AS title_32,
  p2_.text AS text_33,
  p2_.second_sub_title AS second_sub_title_34,
  p2_.second_title AS second_title_35,
  p2_.second_text AS second_text_36,
  p2_.illustration_name AS illustration_name_37,
  p2_.illustration_size AS illustration_size_38,
  p2_.illustration_updated_at AS illustration_updated_at_39,
  p2_.illustration_alt AS illustration_alt_40,
  p2_.youtube_url_original AS youtube_url_original_41,
  p2_.youtube_url_embed AS youtube_url_embed_42,
  p2_.cta_text AS cta_text_43,
  p2_.cta_link AS cta_link_44,
  p2_.cta_external AS cta_external_45,
  p2_.plain_background AS plain_background_46,
  p2_.second_cta_link AS second_cta_link_47,
  p2_.second_cta_text AS second_cta_text_48,
  p2_.second_cta_external AS second_cta_external_49,
  p2_.author AS author_50,
  p2_.pdf_name AS pdf_name_51,
  p2_.pdf_label AS pdf_label_52,
  p2_.pdf_size AS pdf_size_53,
  p2_.pdf_updated_at AS pdf_updated_at_54,
  p2_.pdf_alt AS pdf_alt_55,
  p2_.second_pdf_name AS second_pdf_name_56,
  p2_.second_pdf_label AS second_pdf_label_57,
  p2_.second_pdf_size AS second_pdf_size_58,
  p2_.second_pdf_updated_at AS second_pdf_updated_at_59,
  p2_.second_illustration_name AS second_illustration_name_60,
  p2_.second_illustration_size AS second_illustration_size_61,
  p2_.second_illustration_updated_at AS second_illustration_updated_at_62,
  p2_.second_illustration_alt AS second_illustration_alt_63,
  p2_.illustration_responsive AS illustration_responsive_64,
  p2_.position AS position_65,
  a0_.category_id AS category_id_66,
  a0_.actuality_id AS actuality_id_67,
  a0_.about_id AS about_id_68,
  a0_.composition_id AS composition_id_69,
  a0_.definition_page_id AS definition_page_id_70,
  a0_.departement_id AS departement_id_71,
  a0_.full_member_page_id AS full_member_page_id_72,
  a0_.join_page_id AS join_page_id_73,
  a0_.page_id AS page_id_74,
  a0_.partenaire_page_id AS partenaire_page_id_75,
  a0_.publication_id AS publication_id_76,
  a0_.publication_page_id AS publication_page_id_77,
  a0_.these_id AS these_id_78,
  a0_.these_page_id AS these_page_id_79,
  a0_.homepage_large_id AS homepage_large_id_80,
  a0_.homepage_little_id AS homepage_little_id_81,
  a0_.manuel_page_id AS manuel_page_id_82,
  s1_.about_id AS about_id_83,
  s1_.composition_id AS composition_id_84,
  s1_.full_member_page_id AS full_member_page_id_85,
  s1_.departement_id AS departement_id_86,
  s1_.partenaire_page_id AS partenaire_page_id_87,
  s1_.page_id AS page_id_88,
  s1_.publication_id AS publication_id_89,
  s1_.publication_page_id AS publication_page_id_90,
  s1_.these_id AS these_id_91,
  s1_.these_page_id AS these_page_id_92,
  s1_.definition_page_id AS definition_page_id_93,
  s1_.actuality_id AS actuality_id_94,
  s1_.join_page_id AS join_page_id_95,
  s1_.manuel_page_id AS manuel_page_id_96,
  p2_.section_id AS section_id_97
FROM
  actuality a0_
  LEFT JOIN section s1_ ON a0_.id = s1_.actuality_id
  LEFT JOIN paragraph p2_ ON s1_.id = p2_.section_id
WHERE
  (
    (
      a0_.title LIKE ?
      OR a0_.resume LIKE ?
    )
    AND a0_.activate = 1
  )
  OR s1_.title LIKE ?
  OR p2_.sub_title LIKE ?
  OR p2_.title LIKE ?
  OR p2_.text LIKE ?
  OR p2_.second_sub_title LIKE ?
  OR p2_.second_title LIKE ?
  OR p2_.second_text LIKE ?
ORDER BY
  s1_.position ASC,
  p2_.position ASC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.resume AS resume_2, a0_.illustration_name AS illustration_name_3, a0_.illustration_size AS illustration_size_4, a0_.illustration_updated_at AS illustration_updated_at_5, a0_.illustration_alt AS illustration_alt_6, a0_.activate AS activate_7, a0_.quote AS quote_8, a0_.created_at AS created_at_9, a0_.about_associate AS about_associate_10, a0_.composition_associate AS composition_associate_11, a0_.full_member_associate AS full_member_associate_12, a0_.departement_associate AS departement_associate_13, a0_.partner_associate AS partner_associate_14, a0_.publication_associate AS publication_associate_15, a0_.these_associate AS these_associate_16, a0_.actuality_associate AS actuality_associate_17, a0_.definition_associate AS definition_associate_18, a0_.manuel_associate AS manuel_associate_19, a0_.join_associate AS join_associate_20, a0_.old_id AS old_id_21, a0_.meta_title AS meta_title_22, a0_.meta_description AS meta_description_23, a0_.slug AS slug_24, s1_.id AS id_25, s1_.accordeon AS accordeon_26, s1_.title AS title_27, s1_.position AS position_28, p2_.id AS id_29, p2_.category AS category_30, p2_.sub_title AS sub_title_31, p2_.title AS title_32, p2_.text AS text_33, p2_.second_sub_title AS second_sub_title_34, p2_.second_title AS second_title_35, p2_.second_text AS second_text_36, p2_.illustration_name AS illustration_name_37, p2_.illustration_size AS illustration_size_38, p2_.illustration_updated_at AS illustration_updated_at_39, p2_.illustration_alt AS illustration_alt_40, p2_.youtube_url_original AS youtube_url_original_41, p2_.youtube_url_embed AS youtube_url_embed_42, p2_.cta_text AS cta_text_43, p2_.cta_link AS cta_link_44, p2_.cta_external AS cta_external_45, p2_.plain_background AS plain_background_46, p2_.second_cta_link AS second_cta_link_47, p2_.second_cta_text AS second_cta_text_48, p2_.second_cta_external AS second_cta_external_49, p2_.author AS author_50, p2_.pdf_name AS pdf_name_51, p2_.pdf_label AS pdf_label_52, p2_.pdf_size AS pdf_size_53, p2_.pdf_updated_at AS pdf_updated_at_54, p2_.pdf_alt AS pdf_alt_55, p2_.second_pdf_name AS second_pdf_name_56, p2_.second_pdf_label AS second_pdf_label_57, p2_.second_pdf_size AS second_pdf_size_58, p2_.second_pdf_updated_at AS second_pdf_updated_at_59, p2_.second_illustration_name AS second_illustration_name_60, p2_.second_illustration_size AS second_illustration_size_61, p2_.second_illustration_updated_at AS second_illustration_updated_at_62, p2_.second_illustration_alt AS second_illustration_alt_63, p2_.illustration_responsive AS illustration_responsive_64, p2_.position AS position_65, a0_.category_id AS category_id_66, a0_.actuality_id AS actuality_id_67, a0_.about_id AS about_id_68, a0_.composition_id AS composition_id_69, a0_.definition_page_id AS definition_page_id_70, a0_.departement_id AS departement_id_71, a0_.full_member_page_id AS full_member_page_id_72, a0_.join_page_id AS join_page_id_73, a0_.page_id AS page_id_74, a0_.partenaire_page_id AS partenaire_page_id_75, a0_.publication_id AS publication_id_76, a0_.publication_page_id AS publication_page_id_77, a0_.these_id AS these_id_78, a0_.these_page_id AS these_page_id_79, a0_.homepage_large_id AS homepage_large_id_80, a0_.homepage_little_id AS homepage_little_id_81, a0_.manuel_page_id AS manuel_page_id_82, s1_.about_id AS about_id_83, s1_.composition_id AS composition_id_84, s1_.full_member_page_id AS full_member_page_id_85, s1_.departement_id AS departement_id_86, s1_.partenaire_page_id AS partenaire_page_id_87, s1_.page_id AS page_id_88, s1_.publication_id AS publication_id_89, s1_.publication_page_id AS publication_page_id_90, s1_.these_id AS these_id_91, s1_.these_page_id AS these_page_id_92, s1_.definition_page_id AS definition_page_id_93, s1_.actuality_id AS actuality_id_94, s1_.join_page_id AS join_page_id_95, s1_.manuel_page_id AS manuel_page_id_96, p2_.section_id AS section_id_97 FROM actuality a0_ LEFT JOIN section s1_ ON a0_.id = s1_.actuality_id LEFT JOIN paragraph p2_ ON s1_.id = p2_.section_id WHERE ((a0_.title LIKE '%%' OR a0_.resume LIKE '%%') AND a0_.activate = 1) OR s1_.title LIKE '%%' OR p2_.sub_title LIKE '%%' OR p2_.title LIKE '%%' OR p2_.text LIKE '%%' OR p2_.second_sub_title LIKE '%%' OR p2_.second_title LIKE '%%' OR p2_.second_text LIKE '%%' ORDER BY s1_.position ASC, p2_.position ASC;

SELECT
  p0_.id AS id_0,
  p0_.theme_publication AS theme_publication_1,
  p0_.title AS title_2,
  p0_.icon_name AS icon_name_3,
  p0_.icon_size AS icon_size_4,
  p0_.icon_updated_at AS icon_updated_at_5,
  p0_.icon_alt AS icon_alt_6,
  p0_.quote AS quote_7,
  p0_.about_associate AS about_associate_8,
  p0_.composition_associate AS composition_associate_9,
  p0_.full_member_associate AS full_member_associate_10,
  p0_.departement_associate AS departement_associate_11,
  p0_.partner_associate AS partner_associate_12,
  p0_.publication_associate AS publication_associate_13,
  p0_.these_associate AS these_associate_14,
  p0_.actuality_associate AS actuality_associate_15,
  p0_.definition_associate AS definition_associate_16,
  p0_.manuel_associate AS manuel_associate_17,
  p0_.join_associate AS join_associate_18,
  p0_.activate AS activate_19,
  p0_.meta_title AS meta_title_20,
  p0_.meta_description AS meta_description_21,
  p0_.position AS position_22,
  p0_.slug AS slug_23,
  s1_.id AS id_24,
  s1_.accordeon AS accordeon_25,
  s1_.title AS title_26,
  s1_.position AS position_27,
  p2_.id AS id_28,
  p2_.category AS category_29,
  p2_.sub_title AS sub_title_30,
  p2_.title AS title_31,
  p2_.text AS text_32,
  p2_.second_sub_title AS second_sub_title_33,
  p2_.second_title AS second_title_34,
  p2_.second_text AS second_text_35,
  p2_.illustration_name AS illustration_name_36,
  p2_.illustration_size AS illustration_size_37,
  p2_.illustration_updated_at AS illustration_updated_at_38,
  p2_.illustration_alt AS illustration_alt_39,
  p2_.youtube_url_original AS youtube_url_original_40,
  p2_.youtube_url_embed AS youtube_url_embed_41,
  p2_.cta_text AS cta_text_42,
  p2_.cta_link AS cta_link_43,
  p2_.cta_external AS cta_external_44,
  p2_.plain_background AS plain_background_45,
  p2_.second_cta_link AS second_cta_link_46,
  p2_.second_cta_text AS second_cta_text_47,
  p2_.second_cta_external AS second_cta_external_48,
  p2_.author AS author_49,
  p2_.pdf_name AS pdf_name_50,
  p2_.pdf_label AS pdf_label_51,
  p2_.pdf_size AS pdf_size_52,
  p2_.pdf_updated_at AS pdf_updated_at_53,
  p2_.pdf_alt AS pdf_alt_54,
  p2_.second_pdf_name AS second_pdf_name_55,
  p2_.second_pdf_label AS second_pdf_label_56,
  p2_.second_pdf_size AS second_pdf_size_57,
  p2_.second_pdf_updated_at AS second_pdf_updated_at_58,
  p2_.second_illustration_name AS second_illustration_name_59,
  p2_.second_illustration_size AS second_illustration_size_60,
  p2_.second_illustration_updated_at AS second_illustration_updated_at_61,
  p2_.second_illustration_alt AS second_illustration_alt_62,
  p2_.illustration_responsive AS illustration_responsive_63,
  p2_.position AS position_64,
  p0_.theme_id AS theme_id_65,
  p0_.about_id AS about_id_66,
  p0_.actuality_id AS actuality_id_67,
  p0_.composition_id AS composition_id_68,
  p0_.definition_page_id AS definition_page_id_69,
  p0_.departement_id AS departement_id_70,
  p0_.full_member_page_id AS full_member_page_id_71,
  p0_.join_page_id AS join_page_id_72,
  p0_.page_id AS page_id_73,
  p0_.partenaire_page_id AS partenaire_page_id_74,
  p0_.publication_id AS publication_id_75,
  p0_.publication_page_id AS publication_page_id_76,
  p0_.these_id AS these_id_77,
  p0_.these_page_id AS these_page_id_78,
  p0_.manuel_page_id AS manuel_page_id_79,
  s1_.about_id AS about_id_80,
  s1_.composition_id AS composition_id_81,
  s1_.full_member_page_id AS full_member_page_id_82,
  s1_.departement_id AS departement_id_83,
  s1_.partenaire_page_id AS partenaire_page_id_84,
  s1_.page_id AS page_id_85,
  s1_.publication_id AS publication_id_86,
  s1_.publication_page_id AS publication_page_id_87,
  s1_.these_id AS these_id_88,
  s1_.these_page_id AS these_page_id_89,
  s1_.definition_page_id AS definition_page_id_90,
  s1_.actuality_id AS actuality_id_91,
  s1_.join_page_id AS join_page_id_92,
  s1_.manuel_page_id AS manuel_page_id_93,
  p2_.section_id AS section_id_94
FROM
  page p0_
  LEFT JOIN section s1_ ON p0_.id = s1_.page_id
  LEFT JOIN paragraph p2_ ON s1_.id = p2_.section_id
WHERE
  (
    p0_.title LIKE ?
    AND p0_.activate = 1
    AND (
      p0_.theme_id IS NOT NULL
      OR p0_.theme_publication = 1
    )
  )
  OR s1_.title LIKE ?
  OR p2_.sub_title LIKE ?
  OR p2_.title LIKE ?
  OR p2_.text LIKE ?
  OR p2_.second_sub_title LIKE ?
  OR p2_.second_title LIKE ?
  OR p2_.second_text LIKE ?
ORDER BY
  s1_.position ASC,
  p2_.position ASC

SELECT p0_.id AS id_0, p0_.theme_publication AS theme_publication_1, p0_.title AS title_2, p0_.icon_name AS icon_name_3, p0_.icon_size AS icon_size_4, p0_.icon_updated_at AS icon_updated_at_5, p0_.icon_alt AS icon_alt_6, p0_.quote AS quote_7, p0_.about_associate AS about_associate_8, p0_.composition_associate AS composition_associate_9, p0_.full_member_associate AS full_member_associate_10, p0_.departement_associate AS departement_associate_11, p0_.partner_associate AS partner_associate_12, p0_.publication_associate AS publication_associate_13, p0_.these_associate AS these_associate_14, p0_.actuality_associate AS actuality_associate_15, p0_.definition_associate AS definition_associate_16, p0_.manuel_associate AS manuel_associate_17, p0_.join_associate AS join_associate_18, p0_.activate AS activate_19, p0_.meta_title AS meta_title_20, p0_.meta_description AS meta_description_21, p0_.position AS position_22, p0_.slug AS slug_23, s1_.id AS id_24, s1_.accordeon AS accordeon_25, s1_.title AS title_26, s1_.position AS position_27, p2_.id AS id_28, p2_.category AS category_29, p2_.sub_title AS sub_title_30, p2_.title AS title_31, p2_.text AS text_32, p2_.second_sub_title AS second_sub_title_33, p2_.second_title AS second_title_34, p2_.second_text AS second_text_35, p2_.illustration_name AS illustration_name_36, p2_.illustration_size AS illustration_size_37, p2_.illustration_updated_at AS illustration_updated_at_38, p2_.illustration_alt AS illustration_alt_39, p2_.youtube_url_original AS youtube_url_original_40, p2_.youtube_url_embed AS youtube_url_embed_41, p2_.cta_text AS cta_text_42, p2_.cta_link AS cta_link_43, p2_.cta_external AS cta_external_44, p2_.plain_background AS plain_background_45, p2_.second_cta_link AS second_cta_link_46, p2_.second_cta_text AS second_cta_text_47, p2_.second_cta_external AS second_cta_external_48, p2_.author AS author_49, p2_.pdf_name AS pdf_name_50, p2_.pdf_label AS pdf_label_51, p2_.pdf_size AS pdf_size_52, p2_.pdf_updated_at AS pdf_updated_at_53, p2_.pdf_alt AS pdf_alt_54, p2_.second_pdf_name AS second_pdf_name_55, p2_.second_pdf_label AS second_pdf_label_56, p2_.second_pdf_size AS second_pdf_size_57, p2_.second_pdf_updated_at AS second_pdf_updated_at_58, p2_.second_illustration_name AS second_illustration_name_59, p2_.second_illustration_size AS second_illustration_size_60, p2_.second_illustration_updated_at AS second_illustration_updated_at_61, p2_.second_illustration_alt AS second_illustration_alt_62, p2_.illustration_responsive AS illustration_responsive_63, p2_.position AS position_64, p0_.theme_id AS theme_id_65, p0_.about_id AS about_id_66, p0_.actuality_id AS actuality_id_67, p0_.composition_id AS composition_id_68, p0_.definition_page_id AS definition_page_id_69, p0_.departement_id AS departement_id_70, p0_.full_member_page_id AS full_member_page_id_71, p0_.join_page_id AS join_page_id_72, p0_.page_id AS page_id_73, p0_.partenaire_page_id AS partenaire_page_id_74, p0_.publication_id AS publication_id_75, p0_.publication_page_id AS publication_page_id_76, p0_.these_id AS these_id_77, p0_.these_page_id AS these_page_id_78, p0_.manuel_page_id AS manuel_page_id_79, s1_.about_id AS about_id_80, s1_.composition_id AS composition_id_81, s1_.full_member_page_id AS full_member_page_id_82, s1_.departement_id AS departement_id_83, s1_.partenaire_page_id AS partenaire_page_id_84, s1_.page_id AS page_id_85, s1_.publication_id AS publication_id_86, s1_.publication_page_id AS publication_page_id_87, s1_.these_id AS these_id_88, s1_.these_page_id AS these_page_id_89, s1_.definition_page_id AS definition_page_id_90, s1_.actuality_id AS actuality_id_91, s1_.join_page_id AS join_page_id_92, s1_.manuel_page_id AS manuel_page_id_93, p2_.section_id AS section_id_94 FROM page p0_ LEFT JOIN section s1_ ON p0_.id = s1_.page_id LEFT JOIN paragraph p2_ ON s1_.id = p2_.section_id WHERE (p0_.title LIKE '%%' AND p0_.activate = 1 AND (p0_.theme_id IS NOT NULL OR p0_.theme_publication = 1)) OR s1_.title LIKE '%%' OR p2_.sub_title LIKE '%%' OR p2_.title LIKE '%%' OR p2_.text LIKE '%%' OR p2_.second_sub_title LIKE '%%' OR p2_.second_title LIKE '%%' OR p2_.second_text LIKE '%%' ORDER BY s1_.position ASC, p2_.position ASC;

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.author AS author_2,
  t0_.date AS date_3,
  t0_.sub_title AS sub_title_4,
  t0_.activate AS activate_5,
  t0_.quote AS quote_6,
  t0_.about_associate AS about_associate_7,
  t0_.composition_associate AS composition_associate_8,
  t0_.full_member_associate AS full_member_associate_9,
  t0_.departement_associate AS departement_associate_10,
  t0_.partner_associate AS partner_associate_11,
  t0_.publication_associate AS publication_associate_12,
  t0_.these_associate AS these_associate_13,
  t0_.actuality_associate AS actuality_associate_14,
  t0_.definition_associate AS definition_associate_15,
  t0_.manuel_associate AS manuel_associate_16,
  t0_.join_associate AS join_associate_17,
  t0_.old_id AS old_id_18,
  t0_.meta_title AS meta_title_19,
  t0_.meta_description AS meta_description_20,
  t0_.slug AS slug_21,
  s1_.id AS id_22,
  s1_.accordeon AS accordeon_23,
  s1_.title AS title_24,
  s1_.position AS position_25,
  p2_.id AS id_26,
  p2_.category AS category_27,
  p2_.sub_title AS sub_title_28,
  p2_.title AS title_29,
  p2_.text AS text_30,
  p2_.second_sub_title AS second_sub_title_31,
  p2_.second_title AS second_title_32,
  p2_.second_text AS second_text_33,
  p2_.illustration_name AS illustration_name_34,
  p2_.illustration_size AS illustration_size_35,
  p2_.illustration_updated_at AS illustration_updated_at_36,
  p2_.illustration_alt AS illustration_alt_37,
  p2_.youtube_url_original AS youtube_url_original_38,
  p2_.youtube_url_embed AS youtube_url_embed_39,
  p2_.cta_text AS cta_text_40,
  p2_.cta_link AS cta_link_41,
  p2_.cta_external AS cta_external_42,
  p2_.plain_background AS plain_background_43,
  p2_.second_cta_link AS second_cta_link_44,
  p2_.second_cta_text AS second_cta_text_45,
  p2_.second_cta_external AS second_cta_external_46,
  p2_.author AS author_47,
  p2_.pdf_name AS pdf_name_48,
  p2_.pdf_label AS pdf_label_49,
  p2_.pdf_size AS pdf_size_50,
  p2_.pdf_updated_at AS pdf_updated_at_51,
  p2_.pdf_alt AS pdf_alt_52,
  p2_.second_pdf_name AS second_pdf_name_53,
  p2_.second_pdf_label AS second_pdf_label_54,
  p2_.second_pdf_size AS second_pdf_size_55,
  p2_.second_pdf_updated_at AS second_pdf_updated_at_56,
  p2_.second_illustration_name AS second_illustration_name_57,
  p2_.second_illustration_size AS second_illustration_size_58,
  p2_.second_illustration_updated_at AS second_illustration_updated_at_59,
  p2_.second_illustration_alt AS second_illustration_alt_60,
  p2_.illustration_responsive AS illustration_responsive_61,
  p2_.position AS position_62,
  t0_.about_id AS about_id_63,
  t0_.actuality_id AS actuality_id_64,
  t0_.composition_id AS composition_id_65,
  t0_.definition_page_id AS definition_page_id_66,
  t0_.departement_id AS departement_id_67,
  t0_.full_member_page_id AS full_member_page_id_68,
  t0_.join_page_id AS join_page_id_69,
  t0_.page_id AS page_id_70,
  t0_.partenaire_page_id AS partenaire_page_id_71,
  t0_.publication_id AS publication_id_72,
  t0_.publication_page_id AS publication_page_id_73,
  t0_.these_id AS these_id_74,
  t0_.these_page_id AS these_page_id_75,
  t0_.manuel_page_id AS manuel_page_id_76,
  s1_.about_id AS about_id_77,
  s1_.composition_id AS composition_id_78,
  s1_.full_member_page_id AS full_member_page_id_79,
  s1_.departement_id AS departement_id_80,
  s1_.partenaire_page_id AS partenaire_page_id_81,
  s1_.page_id AS page_id_82,
  s1_.publication_id AS publication_id_83,
  s1_.publication_page_id AS publication_page_id_84,
  s1_.these_id AS these_id_85,
  s1_.these_page_id AS these_page_id_86,
  s1_.definition_page_id AS definition_page_id_87,
  s1_.actuality_id AS actuality_id_88,
  s1_.join_page_id AS join_page_id_89,
  s1_.manuel_page_id AS manuel_page_id_90,
  p2_.section_id AS section_id_91
FROM
  these t0_
  LEFT JOIN section s1_ ON t0_.id = s1_.these_id
  LEFT JOIN paragraph p2_ ON s1_.id = p2_.section_id
WHERE
  (
    (
      t0_.title LIKE ?
      OR t0_.author LIKE ?
    )
    AND t0_.activate = 1
  )
  OR s1_.title LIKE ?
  OR p2_.sub_title LIKE ?
  OR p2_.title LIKE ?
  OR p2_.text LIKE ?
  OR p2_.second_sub_title LIKE ?
  OR p2_.second_title LIKE ?
  OR p2_.second_text LIKE ?
ORDER BY
  s1_.position ASC,
  p2_.position ASC

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.author AS author_2, t0_.date AS date_3, t0_.sub_title AS sub_title_4, t0_.activate AS activate_5, t0_.quote AS quote_6, t0_.about_associate AS about_associate_7, t0_.composition_associate AS composition_associate_8, t0_.full_member_associate AS full_member_associate_9, t0_.departement_associate AS departement_associate_10, t0_.partner_associate AS partner_associate_11, t0_.publication_associate AS publication_associate_12, t0_.these_associate AS these_associate_13, t0_.actuality_associate AS actuality_associate_14, t0_.definition_associate AS definition_associate_15, t0_.manuel_associate AS manuel_associate_16, t0_.join_associate AS join_associate_17, t0_.old_id AS old_id_18, t0_.meta_title AS meta_title_19, t0_.meta_description AS meta_description_20, t0_.slug AS slug_21, s1_.id AS id_22, s1_.accordeon AS accordeon_23, s1_.title AS title_24, s1_.position AS position_25, p2_.id AS id_26, p2_.category AS category_27, p2_.sub_title AS sub_title_28, p2_.title AS title_29, p2_.text AS text_30, p2_.second_sub_title AS second_sub_title_31, p2_.second_title AS second_title_32, p2_.second_text AS second_text_33, p2_.illustration_name AS illustration_name_34, p2_.illustration_size AS illustration_size_35, p2_.illustration_updated_at AS illustration_updated_at_36, p2_.illustration_alt AS illustration_alt_37, p2_.youtube_url_original AS youtube_url_original_38, p2_.youtube_url_embed AS youtube_url_embed_39, p2_.cta_text AS cta_text_40, p2_.cta_link AS cta_link_41, p2_.cta_external AS cta_external_42, p2_.plain_background AS plain_background_43, p2_.second_cta_link AS second_cta_link_44, p2_.second_cta_text AS second_cta_text_45, p2_.second_cta_external AS second_cta_external_46, p2_.author AS author_47, p2_.pdf_name AS pdf_name_48, p2_.pdf_label AS pdf_label_49, p2_.pdf_size AS pdf_size_50, p2_.pdf_updated_at AS pdf_updated_at_51, p2_.pdf_alt AS pdf_alt_52, p2_.second_pdf_name AS second_pdf_name_53, p2_.second_pdf_label AS second_pdf_label_54, p2_.second_pdf_size AS second_pdf_size_55, p2_.second_pdf_updated_at AS second_pdf_updated_at_56, p2_.second_illustration_name AS second_illustration_name_57, p2_.second_illustration_size AS second_illustration_size_58, p2_.second_illustration_updated_at AS second_illustration_updated_at_59, p2_.second_illustration_alt AS second_illustration_alt_60, p2_.illustration_responsive AS illustration_responsive_61, p2_.position AS position_62, t0_.about_id AS about_id_63, t0_.actuality_id AS actuality_id_64, t0_.composition_id AS composition_id_65, t0_.definition_page_id AS definition_page_id_66, t0_.departement_id AS departement_id_67, t0_.full_member_page_id AS full_member_page_id_68, t0_.join_page_id AS join_page_id_69, t0_.page_id AS page_id_70, t0_.partenaire_page_id AS partenaire_page_id_71, t0_.publication_id AS publication_id_72, t0_.publication_page_id AS publication_page_id_73, t0_.these_id AS these_id_74, t0_.these_page_id AS these_page_id_75, t0_.manuel_page_id AS manuel_page_id_76, s1_.about_id AS about_id_77, s1_.composition_id AS composition_id_78, s1_.full_member_page_id AS full_member_page_id_79, s1_.departement_id AS departement_id_80, s1_.partenaire_page_id AS partenaire_page_id_81, s1_.page_id AS page_id_82, s1_.publication_id AS publication_id_83, s1_.publication_page_id AS publication_page_id_84, s1_.these_id AS these_id_85, s1_.these_page_id AS these_page_id_86, s1_.definition_page_id AS definition_page_id_87, s1_.actuality_id AS actuality_id_88, s1_.join_page_id AS join_page_id_89, s1_.manuel_page_id AS manuel_page_id_90, p2_.section_id AS section_id_91 FROM these t0_ LEFT JOIN section s1_ ON t0_.id = s1_.these_id LEFT JOIN paragraph p2_ ON s1_.id = p2_.section_id WHERE ((t0_.title LIKE '%%' OR t0_.author LIKE '%%') AND t0_.activate = 1) OR s1_.title LIKE '%%' OR p2_.sub_title LIKE '%%' OR p2_.title LIKE '%%' OR p2_.text LIKE '%%' OR p2_.second_sub_title LIKE '%%' OR p2_.second_title LIKE '%%' OR p2_.second_text LIKE '%%' ORDER BY s1_.position ASC, p2_.position ASC;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.author AS author_2,
  p0_.quote AS quote_3,
  p0_.date AS date_4,
  p0_.activate AS activate_5,
  p0_.about_associate AS about_associate_6,
  p0_.composition_associate AS composition_associate_7,
  p0_.full_member_associate AS full_member_associate_8,
  p0_.departement_associate AS departement_associate_9,
  p0_.partner_associate AS partner_associate_10,
  p0_.publication_associate AS publication_associate_11,
  p0_.these_associate AS these_associate_12,
  p0_.actuality_associate AS actuality_associate_13,
  p0_.definition_associate AS definition_associate_14,
  p0_.manuel_associate AS manuel_associate_15,
  p0_.join_associate AS join_associate_16,
  p0_.old_id AS old_id_17,
  p0_.meta_title AS meta_title_18,
  p0_.meta_description AS meta_description_19,
  p0_.slug AS slug_20,
  s1_.id AS id_21,
  s1_.accordeon AS accordeon_22,
  s1_.title AS title_23,
  s1_.position AS position_24,
  p2_.id AS id_25,
  p2_.category AS category_26,
  p2_.sub_title AS sub_title_27,
  p2_.title AS title_28,
  p2_.text AS text_29,
  p2_.second_sub_title AS second_sub_title_30,
  p2_.second_title AS second_title_31,
  p2_.second_text AS second_text_32,
  p2_.illustration_name AS illustration_name_33,
  p2_.illustration_size AS illustration_size_34,
  p2_.illustration_updated_at AS illustration_updated_at_35,
  p2_.illustration_alt AS illustration_alt_36,
  p2_.youtube_url_original AS youtube_url_original_37,
  p2_.youtube_url_embed AS youtube_url_embed_38,
  p2_.cta_text AS cta_text_39,
  p2_.cta_link AS cta_link_40,
  p2_.cta_external AS cta_external_41,
  p2_.plain_background AS plain_background_42,
  p2_.second_cta_link AS second_cta_link_43,
  p2_.second_cta_text AS second_cta_text_44,
  p2_.second_cta_external AS second_cta_external_45,
  p2_.author AS author_46,
  p2_.pdf_name AS pdf_name_47,
  p2_.pdf_label AS pdf_label_48,
  p2_.pdf_size AS pdf_size_49,
  p2_.pdf_updated_at AS pdf_updated_at_50,
  p2_.pdf_alt AS pdf_alt_51,
  p2_.second_pdf_name AS second_pdf_name_52,
  p2_.second_pdf_label AS second_pdf_label_53,
  p2_.second_pdf_size AS second_pdf_size_54,
  p2_.second_pdf_updated_at AS second_pdf_updated_at_55,
  p2_.second_illustration_name AS second_illustration_name_56,
  p2_.second_illustration_size AS second_illustration_size_57,
  p2_.second_illustration_updated_at AS second_illustration_updated_at_58,
  p2_.second_illustration_alt AS second_illustration_alt_59,
  p2_.illustration_responsive AS illustration_responsive_60,
  p2_.position AS position_61,
  p0_.about_id AS about_id_62,
  p0_.actuality_id AS actuality_id_63,
  p0_.composition_id AS composition_id_64,
  p0_.definition_page_id AS definition_page_id_65,
  p0_.departement_id AS departement_id_66,
  p0_.full_member_page_id AS full_member_page_id_67,
  p0_.join_page_id AS join_page_id_68,
  p0_.page_id AS page_id_69,
  p0_.partenaire_page_id AS partenaire_page_id_70,
  p0_.publication_id AS publication_id_71,
  p0_.publication_page_id AS publication_page_id_72,
  p0_.these_id AS these_id_73,
  p0_.these_page_id AS these_page_id_74,
  p0_.manuel_page_id AS manuel_page_id_75,
  s1_.about_id AS about_id_76,
  s1_.composition_id AS composition_id_77,
  s1_.full_member_page_id AS full_member_page_id_78,
  s1_.departement_id AS departement_id_79,
  s1_.partenaire_page_id AS partenaire_page_id_80,
  s1_.page_id AS page_id_81,
  s1_.publication_id AS publication_id_82,
  s1_.publication_page_id AS publication_page_id_83,
  s1_.these_id AS these_id_84,
  s1_.these_page_id AS these_page_id_85,
  s1_.definition_page_id AS definition_page_id_86,
  s1_.actuality_id AS actuality_id_87,
  s1_.join_page_id AS join_page_id_88,
  s1_.manuel_page_id AS manuel_page_id_89,
  p2_.section_id AS section_id_90
FROM
  publication p0_
  LEFT JOIN section s1_ ON p0_.id = s1_.publication_id
  LEFT JOIN paragraph p2_ ON s1_.id = p2_.section_id
WHERE
  (
    (
      p0_.title LIKE ?
      OR p0_.author LIKE ?
    )
    AND p0_.activate = 1
  )
  OR s1_.title LIKE ?
  OR p2_.sub_title LIKE ?
  OR p2_.title LIKE ?
  OR p2_.text LIKE ?
  OR p2_.second_sub_title LIKE ?
  OR p2_.second_title LIKE ?
  OR p2_.second_text LIKE ?
ORDER BY
  p2_.position ASC