Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.label AS label_3,
  t0.logo AS logo_4,
  t0.domain AS domain_5,
  t0.matomo_id AS matomo_id_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t9.id AS id_10,
  t9.title_edito AS title_edito_11,
  t9.subtitle_edito AS subtitle_edito_12,
  t9.picture_edito AS picture_edito_13,
  t9.content_edito AS content_edito_14,
  t9.button_edito AS button_edito_15,
  t9.link_button_edito AS link_button_edito_16,
  t9.title_highlight AS title_highlight_17,
  t9.subtitle_highlight AS subtitle_highlight_18,
  t9.picture_highlight AS picture_highlight_19,
  t9.content_highlight AS content_highlight_20,
  t9.button_highlight AS button_highlight_21,
  t9.link_button_highlight AS link_button_highlight_22,
  t9.created_at AS created_at_23,
  t9.updated_at AS updated_at_24,
  t9.box_id AS box_id_25,
  t26.id AS id_27,
  t26.title_menu AS title_menu_28,
  t26.slug AS slug_29,
  t26.title AS title_30,
  t26.subtitle AS subtitle_31,
  t26.picture_introduction AS picture_introduction_32,
  t26.introduction AS introduction_33,
  t26.content AS content_34,
  t26.created_at AS created_at_35,
  t26.updated_at AS updated_at_36,
  t26.box_id AS box_id_37,
  t38.id AS id_39,
  t38.title_menu AS title_menu_40,
  t38.slug AS slug_41,
  t38.title AS title_42,
  t38.subtitle AS subtitle_43,
  t38.picture_introduction AS picture_introduction_44,
  t38.introduction AS introduction_45,
  t38.content AS content_46,
  t38.created_at AS created_at_47,
  t38.updated_at AS updated_at_48,
  t38.box_id AS box_id_49,
  t50.id AS id_51,
  t50.title_menu AS title_menu_52,
  t50.title AS title_53,
  t50.subtitle AS subtitle_54,
  t50.picture_introduction AS picture_introduction_55,
  t50.introduction AS introduction_56,
  t50.content AS content_57,
  t50.created_at AS created_at_58,
  t50.updated_at AS updated_at_59,
  t50.box_id AS box_id_60,
  t61.id AS id_62,
  t61.title_menu AS title_menu_63,
  t61.title AS title_64,
  t61.subtitle AS subtitle_65,
  t61.picture_introduction AS picture_introduction_66,
  t61.introduction AS introduction_67,
  t61.content AS content_68,
  t61.created_at AS created_at_69,
  t61.updated_at AS updated_at_70,
  t61.box_id AS box_id_71,
  t72.id AS id_73,
  t72.title_menu AS title_menu_74,
  t72.title AS title_75,
  t72.subtitle AS subtitle_76,
  t72.picture_introduction AS picture_introduction_77,
  t72.introduction AS introduction_78,
  t72.content AS content_79,
  t72.created_at AS created_at_80,
  t72.updated_at AS updated_at_81,
  t72.box_id AS box_id_82
FROM
  box__box t0
  LEFT JOIN box__home t9 ON t9.box_id = t0.id
  LEFT JOIN box__custom t26 ON t26.box_id = t0.id
  LEFT JOIN box__custom_2 t38 ON t38.box_id = t0.id
  LEFT JOIN box__team t50 ON t50.box_id = t0.id
  LEFT JOIN box__who_are_we t61 ON t61.box_id = t0.id
  LEFT JOIN box__why_join t72 ON t72.box_id = t0.id
WHERE
  t0.domain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.logo AS logo_4, t0.domain AS domain_5, t0.matomo_id AS matomo_id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t9.id AS id_10, t9.title_edito AS title_edito_11, t9.subtitle_edito AS subtitle_edito_12, t9.picture_edito AS picture_edito_13, t9.content_edito AS content_edito_14, t9.button_edito AS button_edito_15, t9.link_button_edito AS link_button_edito_16, t9.title_highlight AS title_highlight_17, t9.subtitle_highlight AS subtitle_highlight_18, t9.picture_highlight AS picture_highlight_19, t9.content_highlight AS content_highlight_20, t9.button_highlight AS button_highlight_21, t9.link_button_highlight AS link_button_highlight_22, t9.created_at AS created_at_23, t9.updated_at AS updated_at_24, t9.box_id AS box_id_25, t26.id AS id_27, t26.title_menu AS title_menu_28, t26.slug AS slug_29, t26.title AS title_30, t26.subtitle AS subtitle_31, t26.picture_introduction AS picture_introduction_32, t26.introduction AS introduction_33, t26.content AS content_34, t26.created_at AS created_at_35, t26.updated_at AS updated_at_36, t26.box_id AS box_id_37, t38.id AS id_39, t38.title_menu AS title_menu_40, t38.slug AS slug_41, t38.title AS title_42, t38.subtitle AS subtitle_43, t38.picture_introduction AS picture_introduction_44, t38.introduction AS introduction_45, t38.content AS content_46, t38.created_at AS created_at_47, t38.updated_at AS updated_at_48, t38.box_id AS box_id_49, t50.id AS id_51, t50.title_menu AS title_menu_52, t50.title AS title_53, t50.subtitle AS subtitle_54, t50.picture_introduction AS picture_introduction_55, t50.introduction AS introduction_56, t50.content AS content_57, t50.created_at AS created_at_58, t50.updated_at AS updated_at_59, t50.box_id AS box_id_60, t61.id AS id_62, t61.title_menu AS title_menu_63, t61.title AS title_64, t61.subtitle AS subtitle_65, t61.picture_introduction AS picture_introduction_66, t61.introduction AS introduction_67, t61.content AS content_68, t61.created_at AS created_at_69, t61.updated_at AS updated_at_70, t61.box_id AS box_id_71, t72.id AS id_73, t72.title_menu AS title_menu_74, t72.title AS title_75, t72.subtitle AS subtitle_76, t72.picture_introduction AS picture_introduction_77, t72.introduction AS introduction_78, t72.content AS content_79, t72.created_at AS created_at_80, t72.updated_at AS updated_at_81, t72.box_id AS box_id_82 FROM box__box t0 LEFT JOIN box__home t9 ON t9.box_id = t0.id LEFT JOIN box__custom t26 ON t26.box_id = t0.id LEFT JOIN box__custom_2 t38 ON t38.box_id = t0.id LEFT JOIN box__team t50 ON t50.box_id = t0.id LEFT JOIN box__who_are_we t61 ON t61.box_id = t0.id LEFT JOIN box__why_join t72 ON t72.box_id = t0.id WHERE t0.domain = 'cce53.webetdesign.com' LIMIT 1;

SELECT
  d0_.id AS id_0,
  d0_.title AS title_1,
  d0_.created_at AS created_at_2,
  d0_.updated_at AS updated_at_3
FROM
  document__category d0_
ORDER BY
  d0_.title ASC

SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.created_at AS created_at_2, d0_.updated_at AS updated_at_3 FROM document__category d0_ ORDER BY d0_.title ASC;

SELECT
  d0_.id AS id_0,
  d0_.title AS title_1,
  d0_.created_at AS created_at_2,
  d0_.updated_at AS updated_at_3
FROM
  document__theme d0_
ORDER BY
  d0_.title ASC

SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.created_at AS created_at_2, d0_.updated_at AS updated_at_3 FROM document__theme d0_ ORDER BY d0_.title ASC;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      sclr_15
    FROM
      (
        SELECT
          d0_.id AS id_0,
          d0_.title AS title_1,
          d0_.link AS link_2,
          d0_.description AS description_3,
          d0_.reserved AS reserved_4,
          d0_.doc AS doc_5,
          d0_.old_id AS old_id_6,
          d0_.resume AS resume_7,
          d0_.publish AS publish_8,
          d0_.last_update AS last_update_9,
          d0_.notified_at AS notified_at_10,
          d0_.pay AS pay_11,
          d0_.import_member_column AS import_member_column_12,
          d0_.created_at AS created_at_13,
          d0_.updated_at AS updated_at_14,
          CASE WHEN d0_.last_update IS NULL THEN
            d0_.created_at
          ELSE
            d0_.last_update
          END AS sclr_15
        FROM
          document__document d0_
        WHERE
          d0_.box_id = ?
          AND (
            d0_.publish = ?
            OR d0_.publish IS NULL
          )
      ) dctrn_result_inner
    ORDER BY
      sclr_15 DESC
  ) dctrn_result
LIMIT
  14

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sclr_15 FROM (SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.link AS link_2, d0_.description AS description_3, d0_.reserved AS reserved_4, d0_.doc AS doc_5, d0_.old_id AS old_id_6, d0_.resume AS resume_7, d0_.publish AS publish_8, d0_.last_update AS last_update_9, d0_.notified_at AS notified_at_10, d0_.pay AS pay_11, d0_.import_member_column AS import_member_column_12, d0_.created_at AS created_at_13, d0_.updated_at AS updated_at_14, CASE WHEN d0_.last_update IS NULL THEN d0_.created_at ELSE d0_.last_update END AS sclr_15 FROM document__document d0_ WHERE d0_.box_id = 2 AND (d0_.publish = 1 OR d0_.publish IS NULL)) dctrn_result_inner ORDER BY sclr_15 DESC) dctrn_result LIMIT 14;

SELECT
  d0_.id AS id_0,
  d0_.title AS title_1,
  d0_.link AS link_2,
  d0_.description AS description_3,
  d0_.reserved AS reserved_4,
  d0_.doc AS doc_5,
  d0_.old_id AS old_id_6,
  d0_.resume AS resume_7,
  d0_.publish AS publish_8,
  d0_.last_update AS last_update_9,
  d0_.notified_at AS notified_at_10,
  d0_.pay AS pay_11,
  d0_.import_member_column AS import_member_column_12,
  d0_.created_at AS created_at_13,
  d0_.updated_at AS updated_at_14,
  CASE WHEN d0_.last_update IS NULL THEN
    d0_.created_at
  ELSE
    d0_.last_update
  END AS sclr_15,
  d0_.box_id AS box_id_16
FROM
  document__document d0_
WHERE
  d0_.box_id = ?
  AND (
    d0_.publish = ?
    OR d0_.publish IS NULL
  )
  AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  sclr_15 DESC

SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.link AS link_2, d0_.description AS description_3, d0_.reserved AS reserved_4, d0_.doc AS doc_5, d0_.old_id AS old_id_6, d0_.resume AS resume_7, d0_.publish AS publish_8, d0_.last_update AS last_update_9, d0_.notified_at AS notified_at_10, d0_.pay AS pay_11, d0_.import_member_column AS import_member_column_12, d0_.created_at AS created_at_13, d0_.updated_at AS updated_at_14, CASE WHEN d0_.last_update IS NULL THEN d0_.created_at ELSE d0_.last_update END AS sclr_15, d0_.box_id AS box_id_16 FROM document__document d0_ WHERE d0_.box_id = 2 AND (d0_.publish = 1 OR d0_.publish IS NULL) AND d0_.id IN (4617, 2627, 2918, 2630, 2836, 2722, 2706, 2683, 2653, 2652, 2629, 2628, 2626, 2625) ORDER BY sclr_15 DESC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          d0_.id AS id_0,
          d0_.title AS title_1,
          d0_.link AS link_2,
          d0_.description AS description_3,
          d0_.reserved AS reserved_4,
          d0_.doc AS doc_5,
          d0_.old_id AS old_id_6,
          d0_.resume AS resume_7,
          d0_.publish AS publish_8,
          d0_.last_update AS last_update_9,
          d0_.notified_at AS notified_at_10,
          d0_.pay AS pay_11,
          d0_.import_member_column AS import_member_column_12,
          d0_.created_at AS created_at_13,
          d0_.updated_at AS updated_at_14,
          CASE WHEN d0_.last_update IS NULL THEN
            d0_.created_at
          ELSE
            d0_.last_update
          END AS sclr_15
        FROM
          document__document d0_
        WHERE
          d0_.box_id = ?
          AND (
            d0_.publish = ?
            OR d0_.publish IS NULL
          )
        ORDER BY
          sclr_15 DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.link AS link_2, d0_.description AS description_3, d0_.reserved AS reserved_4, d0_.doc AS doc_5, d0_.old_id AS old_id_6, d0_.resume AS resume_7, d0_.publish AS publish_8, d0_.last_update AS last_update_9, d0_.notified_at AS notified_at_10, d0_.pay AS pay_11, d0_.import_member_column AS import_member_column_12, d0_.created_at AS created_at_13, d0_.updated_at AS updated_at_14, CASE WHEN d0_.last_update IS NULL THEN d0_.created_at ELSE d0_.last_update END AS sclr_15 FROM document__document d0_ WHERE d0_.box_id = 2 AND (d0_.publish = 1 OR d0_.publish IS NULL) ORDER BY sclr_15 DESC) dctrn_result) dctrn_table;