Symfony Profiler

SELECT
  t0.title AS title_1,
  t0.browser_title AS browser_title_2,
  t0.meta_description AS meta_description_3,
  t0.meta_keywords AS meta_keywords_4,
  t0.slug AS slug_5,
  t0.canonical_url AS canonical_url_6,
  t0.html_content AS html_content_7,
  t0.id AS id_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.created AS created_11,
  t0.updated AS updated_12,
  t0.channel_id AS channel_id_13,
  t0.locale_id AS locale_id_14,
  t0.page_id AS page_id_15,
  t0.discriminator
FROM
  page_content t0
WHERE
  t0.page_id = ?
  AND t0.discriminator IN ('basepagecontent')

SELECT t0.title AS title_1, t0.browser_title AS browser_title_2, t0.meta_description AS meta_description_3, t0.meta_keywords AS meta_keywords_4, t0.slug AS slug_5, t0.canonical_url AS canonical_url_6, t0.html_content AS html_content_7, t0.id AS id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.created AS created_11, t0.updated AS updated_12, t0.channel_id AS channel_id_13, t0.locale_id AS locale_id_14, t0.page_id AS page_id_15, t0.discriminator FROM page_content t0 WHERE t0.page_id = 10 AND t0.discriminator IN ('basepagecontent');

SELECT
  d0_.host AS host_0,
  d0_.identifier AS identifier_1,
  d0_.id AS id_2,
  c1_.title AS title_3,
  c1_.main AS main_4,
  c1_.id AS id_5,
  d2_.host AS host_6,
  d2_.identifier AS identifier_7,
  d2_.id AS id_8,
  l3_.code AS code_9,
  l3_.language_code AS language_code_10,
  l3_.country_code AS country_code_11,
  l3_.id AS id_12,
  d0_.discriminator AS discriminator_13,
  d0_.channel_id AS channel_id_14,
  c1_.discriminator AS discriminator_15,
  c1_.locale_id AS locale_id_16,
  d2_.discriminator AS discriminator_17,
  d2_.channel_id AS channel_id_18,
  l3_.discriminator AS discriminator_19
FROM
  domain d0_
  LEFT JOIN channel c1_ ON d0_.channel_id = c1_.id
  AND c1_.discriminator IN ('basechannel')
  LEFT JOIN domain d2_ ON c1_.id = d2_.channel_id
  AND d2_.discriminator IN ('basedomain')
  LEFT JOIN domain_locale d4_ ON d2_.id = d4_.domain_id
  LEFT JOIN locale l3_ ON l3_.id = d4_.locale_id
  AND l3_.discriminator IN ('baselocale')
WHERE
  (d0_.host = ?)
  AND d0_.discriminator IN ('basedomain')

SELECT d0_.host AS host_0, d0_.identifier AS identifier_1, d0_.id AS id_2, c1_.title AS title_3, c1_.main AS main_4, c1_.id AS id_5, d2_.host AS host_6, d2_.identifier AS identifier_7, d2_.id AS id_8, l3_.code AS code_9, l3_.language_code AS language_code_10, l3_.country_code AS country_code_11, l3_.id AS id_12, d0_.discriminator AS discriminator_13, d0_.channel_id AS channel_id_14, c1_.discriminator AS discriminator_15, c1_.locale_id AS locale_id_16, d2_.discriminator AS discriminator_17, d2_.channel_id AS channel_id_18, l3_.discriminator AS discriminator_19 FROM domain d0_ LEFT JOIN channel c1_ ON d0_.channel_id = c1_.id AND c1_.discriminator IN ('basechannel') LEFT JOIN domain d2_ ON c1_.id = d2_.channel_id AND d2_.discriminator IN ('basedomain') LEFT JOIN domain_locale d4_ ON d2_.id = d4_.domain_id LEFT JOIN locale l3_ ON l3_.id = d4_.locale_id AND l3_.discriminator IN ('baselocale') WHERE (d0_.host = 'zuidema.dapprgemaakt.nl') AND d0_.discriminator IN ('basedomain');

SELECT
  DISTINCT id_11
FROM
  (
    SELECT
      DISTINCT id_11,
      publication_date_1
    FROM
      (
        SELECT
          n0_.title AS title_0,
          n0_.publication_date AS publication_date_1,
          n0_.unpublication_date AS unpublication_date_2,
          n0_.layout AS layout_3,
          n0_.published AS published_4,
          n0_.intro_html_content AS intro_html_content_5,
          n0_.html_content AS html_content_6,
          n0_.source AS source_7,
          n0_.author AS author_8,
          n0_.created_by AS created_by_9,
          n0_.updated_by AS updated_by_10,
          n0_.id AS id_11,
          n0_.image_title AS image_title_12,
          n0_.image_alt AS image_alt_13,
          n0_.browser_title AS browser_title_14,
          n0_.meta_description AS meta_description_15,
          n0_.meta_keywords AS meta_keywords_16,
          n0_.indexable AS indexable_17,
          n0_.slug AS slug_18,
          n0_.created AS created_19,
          n0_.updated AS updated_20,
          n0_.discriminator AS discriminator_21
        FROM
          news n0_
        WHERE
          (
            n0_.published = 1
            AND (
              n0_.unpublication_date >= '2026-02-16 15:36:33'
              OR n0_.unpublication_date IS NULL
            )
            AND n0_.publication_date <= '2026-02-16 15:36:33'
          )
          AND n0_.discriminator IN ('basenews', 'news')
        GROUP BY
          n0_.id
      ) dctrn_result_inner
    ORDER BY
      publication_date_1 DESC
  ) dctrn_result
LIMIT
  3

SELECT DISTINCT id_11 FROM (SELECT DISTINCT id_11, publication_date_1 FROM (SELECT n0_.title AS title_0, n0_.publication_date AS publication_date_1, n0_.unpublication_date AS unpublication_date_2, n0_.layout AS layout_3, n0_.published AS published_4, n0_.intro_html_content AS intro_html_content_5, n0_.html_content AS html_content_6, n0_.source AS source_7, n0_.author AS author_8, n0_.created_by AS created_by_9, n0_.updated_by AS updated_by_10, n0_.id AS id_11, n0_.image_title AS image_title_12, n0_.image_alt AS image_alt_13, n0_.browser_title AS browser_title_14, n0_.meta_description AS meta_description_15, n0_.meta_keywords AS meta_keywords_16, n0_.indexable AS indexable_17, n0_.slug AS slug_18, n0_.created AS created_19, n0_.updated AS updated_20, n0_.discriminator AS discriminator_21 FROM news n0_ WHERE (n0_.published = 1 AND (n0_.unpublication_date >= '2026-02-16 15:36:33' OR n0_.unpublication_date IS NULL) AND n0_.publication_date <= '2026-02-16 15:36:33') AND n0_.discriminator IN ('basenews', 'news') GROUP BY n0_.id) dctrn_result_inner ORDER BY publication_date_1 DESC) dctrn_result LIMIT 3;

SELECT
  t0.filename AS filename_1,
  t0.mime_type AS mime_type_2,
  t0.extension AS extension_3,
  t0.created_by AS created_by_4,
  t0.updated_by AS updated_by_5,
  t0.id AS id_6,
  t0.order_id AS order_id_7,
  t0.created AS created_8,
  t0.updated AS updated_9,
  t0.folder_id AS folder_id_10,
  t0.discriminator
FROM
  upload t0
WHERE
  t0.id = ?
  AND t0.discriminator IN ('baseupload')

SELECT t0.filename AS filename_1, t0.mime_type AS mime_type_2, t0.extension AS extension_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.id AS id_6, t0.order_id AS order_id_7, t0.created AS created_8, t0.updated AS updated_9, t0.folder_id AS folder_id_10, t0.discriminator FROM upload t0 WHERE t0.id = 666 AND t0.discriminator IN ('baseupload');

SELECT
  r0_.name AS name_0,
  r0_.url AS url_1,
  r0_.active AS active_2,
  r0_.controller AS controller_3,
  r0_.parameters AS parameters_4,
  r0_.entity_key AS entity_key_5,
  r0_.created_by AS created_by_6,
  r0_.updated_by AS updated_by_7,
  r0_.id AS id_8,
  r0_.created AS created_9,
  r0_.updated AS updated_10,
  r0_.discriminator AS discriminator_11,
  r0_.channel_id AS channel_id_12,
  r0_.locale_id AS locale_id_13
FROM
  route r0_
WHERE
  (
    r0_.url = '/nieuws/bouwvak-bbq-2025/'
    AND r0_.active = 1
  )
  AND r0_.discriminator IN ('baseroute')
GROUP BY
  r0_.id

SELECT r0_.name AS name_0, r0_.url AS url_1, r0_.active AS active_2, r0_.controller AS controller_3, r0_.parameters AS parameters_4, r0_.entity_key AS entity_key_5, r0_.created_by AS created_by_6, r0_.updated_by AS updated_by_7, r0_.id AS id_8, r0_.created AS created_9, r0_.updated AS updated_10, r0_.discriminator AS discriminator_11, r0_.channel_id AS channel_id_12, r0_.locale_id AS locale_id_13 FROM route r0_ WHERE (r0_.url = '/nieuws/bouwvak-bbq-2025/' AND r0_.active = 1) AND r0_.discriminator IN ('baseroute') GROUP BY r0_.id;

SELECT
  t0.title AS title_1,
  t0.published AS published_2,
  t0.factory AS factory_3,
  t0.link AS link_4,
  t0.target_blank AS target_blank_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7,
  t0.id AS id_8,
  t0.order_id AS order_id_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.menu_id AS menu_id_12,
  t0.parent_id AS parent_id_13,
  t0.discriminator
FROM
  menu_item t0
WHERE
  t0.menu_id = ?
  AND t0.discriminator IN ('basemenuitem')
ORDER BY
  t0.order_id ASC

SELECT t0.title AS title_1, t0.published AS published_2, t0.factory AS factory_3, t0.link AS link_4, t0.target_blank AS target_blank_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.id AS id_8, t0.order_id AS order_id_9, t0.created AS created_10, t0.updated AS updated_11, t0.menu_id AS menu_id_12, t0.parent_id AS parent_id_13, t0.discriminator FROM menu_item t0 WHERE t0.menu_id = 1 AND t0.discriminator IN ('basemenuitem') ORDER BY t0.order_id ASC;

SELECT
  n0_.title AS title_0,
  n0_.publication_date AS publication_date_1,
  n0_.unpublication_date AS unpublication_date_2,
  n0_.layout AS layout_3,
  n0_.published AS published_4,
  n0_.intro_html_content AS intro_html_content_5,
  n0_.html_content AS html_content_6,
  n0_.source AS source_7,
  n0_.author AS author_8,
  n0_.created_by AS created_by_9,
  n0_.updated_by AS updated_by_10,
  n0_.id AS id_11,
  n0_.image_title AS image_title_12,
  n0_.image_alt AS image_alt_13,
  n0_.browser_title AS browser_title_14,
  n0_.meta_description AS meta_description_15,
  n0_.meta_keywords AS meta_keywords_16,
  n0_.indexable AS indexable_17,
  n0_.slug AS slug_18,
  n0_.created AS created_19,
  n0_.updated AS updated_20,
  n0_.discriminator AS discriminator_21,
  n0_.upload_id AS upload_id_22,
  n0_.employee_id AS employee_id_23
FROM
  news n0_
WHERE
  (
    n0_.published = 1
    AND (
      n0_.unpublication_date >= '2026-02-16 15:36:33'
      OR n0_.unpublication_date IS NULL
    )
    AND n0_.publication_date <= '2026-02-16 15:36:33'
    AND n0_.id IN (?, ?)
  )
  AND n0_.discriminator IN ('basenews', 'news')
GROUP BY
  n0_.id
ORDER BY
  n0_.publication_date DESC

SELECT n0_.title AS title_0, n0_.publication_date AS publication_date_1, n0_.unpublication_date AS unpublication_date_2, n0_.layout AS layout_3, n0_.published AS published_4, n0_.intro_html_content AS intro_html_content_5, n0_.html_content AS html_content_6, n0_.source AS source_7, n0_.author AS author_8, n0_.created_by AS created_by_9, n0_.updated_by AS updated_by_10, n0_.id AS id_11, n0_.image_title AS image_title_12, n0_.image_alt AS image_alt_13, n0_.browser_title AS browser_title_14, n0_.meta_description AS meta_description_15, n0_.meta_keywords AS meta_keywords_16, n0_.indexable AS indexable_17, n0_.slug AS slug_18, n0_.created AS created_19, n0_.updated AS updated_20, n0_.discriminator AS discriminator_21, n0_.upload_id AS upload_id_22, n0_.employee_id AS employee_id_23 FROM news n0_ WHERE (n0_.published = 1 AND (n0_.unpublication_date >= '2026-02-16 151413' OR n0_.unpublication_date IS NULL) AND n0_.publication_date <= '2026-02-16 15:36:33' AND n0_.id IN (?, ?)) AND n0_.discriminator IN ('basenews', 'news') GROUP BY n0_.id ORDER BY n0_.publication_date DESC;

SELECT
  r0_.type AS type_0,
  r0_.url_from AS url_from_1,
  r0_.url_to AS url_to_2,
  r0_.active AS active_3,
  r0_.auto_generated AS auto_generated_4,
  r0_.created_by AS created_by_5,
  r0_.updated_by AS updated_by_6,
  r0_.id AS id_7,
  r0_.created AS created_8,
  r0_.updated AS updated_9,
  r0_.discriminator AS discriminator_10,
  r0_.channel_id AS channel_id_11,
  r0_.locale_id AS locale_id_12
FROM
  redirect r0_
WHERE
  (
    r0_.url_from = '/nieuws/bouwvak-bbq-2025/'
    AND r0_.active = 1
  )
  AND r0_.discriminator IN ('baseredirect')
GROUP BY
  r0_.id

SELECT r0_.type AS type_0, r0_.url_from AS url_from_1, r0_.url_to AS url_to_2, r0_.active AS active_3, r0_.auto_generated AS auto_generated_4, r0_.created_by AS created_by_5, r0_.updated_by AS updated_by_6, r0_.id AS id_7, r0_.created AS created_8, r0_.updated AS updated_9, r0_.discriminator AS discriminator_10, r0_.channel_id AS channel_id_11, r0_.locale_id AS locale_id_12 FROM redirect r0_ WHERE (r0_.url_from = '/nieuws/bouwvak-bbq-2025/' AND r0_.active = 1) AND r0_.discriminator IN ('baseredirect') GROUP BY r0_.id;

SELECT
  n0_.title AS title_0,
  n0_.publication_date AS publication_date_1,
  n0_.unpublication_date AS unpublication_date_2,
  n0_.layout AS layout_3,
  n0_.published AS published_4,
  n0_.intro_html_content AS intro_html_content_5,
  n0_.html_content AS html_content_6,
  n0_.source AS source_7,
  n0_.author AS author_8,
  n0_.created_by AS created_by_9,
  n0_.updated_by AS updated_by_10,
  n0_.id AS id_11,
  n0_.image_title AS image_title_12,
  n0_.image_alt AS image_alt_13,
  n0_.browser_title AS browser_title_14,
  n0_.meta_description AS meta_description_15,
  n0_.meta_keywords AS meta_keywords_16,
  n0_.indexable AS indexable_17,
  n0_.slug AS slug_18,
  n0_.created AS created_19,
  n0_.updated AS updated_20,
  n0_.discriminator AS discriminator_21,
  n0_.upload_id AS upload_id_22,
  n0_.employee_id AS employee_id_23
FROM
  news n0_
WHERE
  (
    n0_.slug = 'bouwvak-bbq-2025'
    AND n0_.published = 1
    AND (
      n0_.unpublication_date >= '2026-02-16 15:36:33'
      OR n0_.unpublication_date IS NULL
    )
    AND n0_.publication_date <= '2026-02-16 15:36:33'
  )
  AND n0_.discriminator IN ('basenews', 'news')
GROUP BY
  n0_.id

SELECT n0_.title AS title_0, n0_.publication_date AS publication_date_1, n0_.unpublication_date AS unpublication_date_2, n0_.layout AS layout_3, n0_.published AS published_4, n0_.intro_html_content AS intro_html_content_5, n0_.html_content AS html_content_6, n0_.source AS source_7, n0_.author AS author_8, n0_.created_by AS created_by_9, n0_.updated_by AS updated_by_10, n0_.id AS id_11, n0_.image_title AS image_title_12, n0_.image_alt AS image_alt_13, n0_.browser_title AS browser_title_14, n0_.meta_description AS meta_description_15, n0_.meta_keywords AS meta_keywords_16, n0_.indexable AS indexable_17, n0_.slug AS slug_18, n0_.created AS created_19, n0_.updated AS updated_20, n0_.discriminator AS discriminator_21, n0_.upload_id AS upload_id_22, n0_.employee_id AS employee_id_23 FROM news n0_ WHERE (n0_.slug = 'bouwvak-bbq-2025' AND n0_.published = 1 AND (n0_.unpublication_date >= '2026-02-16 15:36:33' OR n0_.unpublication_date IS NULL) AND n0_.publication_date <= '2026-02-16 15:36:33') AND n0_.discriminator IN ('basenews', 'news') GROUP BY n0_.id;

SELECT
  n0_.title AS title_0,
  n0_.publication_date AS publication_date_1,
  n0_.unpublication_date AS unpublication_date_2,
  n0_.layout AS layout_3,
  n0_.published AS published_4,
  n0_.intro_html_content AS intro_html_content_5,
  n0_.html_content AS html_content_6,
  n0_.source AS source_7,
  n0_.author AS author_8,
  n0_.created_by AS created_by_9,
  n0_.updated_by AS updated_by_10,
  n0_.id AS id_11,
  n0_.image_title AS image_title_12,
  n0_.image_alt AS image_alt_13,
  n0_.browser_title AS browser_title_14,
  n0_.meta_description AS meta_description_15,
  n0_.meta_keywords AS meta_keywords_16,
  n0_.indexable AS indexable_17,
  n0_.slug AS slug_18,
  n0_.created AS created_19,
  n0_.updated AS updated_20,
  n0_.discriminator AS discriminator_21,
  n0_.upload_id AS upload_id_22,
  n0_.employee_id AS employee_id_23
FROM
  news n0_
WHERE
  (n0_.slug = 'bouwvak-bbq-2025')
  AND n0_.discriminator IN ('basenews', 'news')
GROUP BY
  n0_.id

SELECT n0_.title AS title_0, n0_.publication_date AS publication_date_1, n0_.unpublication_date AS unpublication_date_2, n0_.layout AS layout_3, n0_.published AS published_4, n0_.intro_html_content AS intro_html_content_5, n0_.html_content AS html_content_6, n0_.source AS source_7, n0_.author AS author_8, n0_.created_by AS created_by_9, n0_.updated_by AS updated_by_10, n0_.id AS id_11, n0_.image_title AS image_title_12, n0_.image_alt AS image_alt_13, n0_.browser_title AS browser_title_14, n0_.meta_description AS meta_description_15, n0_.meta_keywords AS meta_keywords_16, n0_.indexable AS indexable_17, n0_.slug AS slug_18, n0_.created AS created_19, n0_.updated AS updated_20, n0_.discriminator AS discriminator_21, n0_.upload_id AS upload_id_22, n0_.employee_id AS employee_id_23 FROM news n0_ WHERE (n0_.slug = 'bouwvak-bbq-2025') AND n0_.discriminator IN ('basenews', 'news') GROUP BY n0_.id;

SELECT
  p0_.published AS published_0,
  p0_.indexable AS indexable_1,
  p0_.layout AS layout_2,
  p0_.system_page AS system_page_3,
  p0_.components AS components_4,
  p0_.created_by AS created_by_5,
  p0_.updated_by AS updated_by_6,
  p0_.id AS id_7,
  p0_.order_id AS order_id_8,
  p0_.created AS created_9,
  p0_.updated AS updated_10,
  p0_.expertise AS expertise_11,
  p0_.expertise_icon AS expertise_icon_12,
  p0_.mvo_reference AS mvo_reference_13,
  p0_.kam_reference AS kam_reference_14,
  p0_.sponsor_reference AS sponsor_reference_15,
  p0_.discriminator AS discriminator_16,
  p0_.parent_id AS parent_id_17,
  p0_.project_category_id AS project_category_id_18,
  p0_.employee_id AS employee_id_19,
  p0_.photo_album_id AS photo_album_id_20
FROM
  page p0_
  LEFT JOIN page_content p1_ ON p0_.id = p1_.page_id
  AND p1_.discriminator IN ('basepagecontent')
WHERE
  (
    p0_.id = '38'
    AND p0_.published = 1
  )
  AND p0_.discriminator IN ('page')
GROUP BY
  p0_.id

SELECT p0_.published AS published_0, p0_.indexable AS indexable_1, p0_.layout AS layout_2, p0_.system_page AS system_page_3, p0_.components AS components_4, p0_.created_by AS created_by_5, p0_.updated_by AS updated_by_6, p0_.id AS id_7, p0_.order_id AS order_id_8, p0_.created AS created_9, p0_.updated AS updated_10, p0_.expertise AS expertise_11, p0_.expertise_icon AS expertise_icon_12, p0_.mvo_reference AS mvo_reference_13, p0_.kam_reference AS kam_reference_14, p0_.sponsor_reference AS sponsor_reference_15, p0_.discriminator AS discriminator_16, p0_.parent_id AS parent_id_17, p0_.project_category_id AS project_category_id_18, p0_.employee_id AS employee_id_19, p0_.photo_album_id AS photo_album_id_20 FROM page p0_ LEFT JOIN page_content p1_ ON p0_.id = p1_.page_id AND p1_.discriminator IN ('basepagecontent') WHERE (p0_.id = '38' AND p0_.published = 1) AND p0_.discriminator IN ('page') GROUP BY p0_.id;

SELECT
  p0_.published AS published_0,
  p0_.indexable AS indexable_1,
  p0_.layout AS layout_2,
  p0_.system_page AS system_page_3,
  p0_.components AS components_4,
  p0_.created_by AS created_by_5,
  p0_.updated_by AS updated_by_6,
  p0_.id AS id_7,
  p0_.order_id AS order_id_8,
  p0_.created AS created_9,
  p0_.updated AS updated_10,
  p0_.expertise AS expertise_11,
  p0_.expertise_icon AS expertise_icon_12,
  p0_.mvo_reference AS mvo_reference_13,
  p0_.kam_reference AS kam_reference_14,
  p0_.sponsor_reference AS sponsor_reference_15,
  p0_.discriminator AS discriminator_16,
  p0_.parent_id AS parent_id_17,
  p0_.project_category_id AS project_category_id_18,
  p0_.employee_id AS employee_id_19,
  p0_.photo_album_id AS photo_album_id_20
FROM
  page p0_
  LEFT JOIN page_content p1_ ON p0_.id = p1_.page_id
  AND p1_.discriminator IN ('basepagecontent')
WHERE
  (
    p0_.id = '10'
    AND p0_.published = 1
  )
  AND p0_.discriminator IN ('page')
GROUP BY
  p0_.id

SELECT p0_.published AS published_0, p0_.indexable AS indexable_1, p0_.layout AS layout_2, p0_.system_page AS system_page_3, p0_.components AS components_4, p0_.created_by AS created_by_5, p0_.updated_by AS updated_by_6, p0_.id AS id_7, p0_.order_id AS order_id_8, p0_.created AS created_9, p0_.updated AS updated_10, p0_.expertise AS expertise_11, p0_.expertise_icon AS expertise_icon_12, p0_.mvo_reference AS mvo_reference_13, p0_.kam_reference AS kam_reference_14, p0_.sponsor_reference AS sponsor_reference_15, p0_.discriminator AS discriminator_16, p0_.parent_id AS parent_id_17, p0_.project_category_id AS project_category_id_18, p0_.employee_id AS employee_id_19, p0_.photo_album_id AS photo_album_id_20 FROM page p0_ LEFT JOIN page_content p1_ ON p0_.id = p1_.page_id AND p1_.discriminator IN ('basepagecontent') WHERE (p0_.id = '10' AND p0_.published = 1) AND p0_.discriminator IN ('page') GROUP BY p0_.id;

SELECT
  p0_.published AS published_0,
  p0_.indexable AS indexable_1,
  p0_.layout AS layout_2,
  p0_.system_page AS system_page_3,
  p0_.components AS components_4,
  p0_.created_by AS created_by_5,
  p0_.updated_by AS updated_by_6,
  p0_.id AS id_7,
  p0_.order_id AS order_id_8,
  p0_.created AS created_9,
  p0_.updated AS updated_10,
  p0_.expertise AS expertise_11,
  p0_.expertise_icon AS expertise_icon_12,
  p0_.mvo_reference AS mvo_reference_13,
  p0_.kam_reference AS kam_reference_14,
  p0_.sponsor_reference AS sponsor_reference_15,
  p0_.discriminator AS discriminator_16,
  p0_.parent_id AS parent_id_17,
  p0_.project_category_id AS project_category_id_18,
  p0_.employee_id AS employee_id_19,
  p0_.photo_album_id AS photo_album_id_20
FROM
  page p0_
  LEFT JOIN page_content p1_ ON p0_.id = p1_.page_id
  AND p1_.discriminator IN ('basepagecontent')
WHERE
  (
    p0_.id = '22'
    AND p0_.published = 1
  )
  AND p0_.discriminator IN ('page')
GROUP BY
  p0_.id

SELECT p0_.published AS published_0, p0_.indexable AS indexable_1, p0_.layout AS layout_2, p0_.system_page AS system_page_3, p0_.components AS components_4, p0_.created_by AS created_by_5, p0_.updated_by AS updated_by_6, p0_.id AS id_7, p0_.order_id AS order_id_8, p0_.created AS created_9, p0_.updated AS updated_10, p0_.expertise AS expertise_11, p0_.expertise_icon AS expertise_icon_12, p0_.mvo_reference AS mvo_reference_13, p0_.kam_reference AS kam_reference_14, p0_.sponsor_reference AS sponsor_reference_15, p0_.discriminator AS discriminator_16, p0_.parent_id AS parent_id_17, p0_.project_category_id AS project_category_id_18, p0_.employee_id AS employee_id_19, p0_.photo_album_id AS photo_album_id_20 FROM page p0_ LEFT JOIN page_content p1_ ON p0_.id = p1_.page_id AND p1_.discriminator IN ('basepagecontent') WHERE (p0_.id = '22' AND p0_.published = 1) AND p0_.discriminator IN ('page') GROUP BY p0_.id;

SELECT
  p0_.published AS published_0,
  p0_.indexable AS indexable_1,
  p0_.layout AS layout_2,
  p0_.system_page AS system_page_3,
  p0_.components AS components_4,
  p0_.created_by AS created_by_5,
  p0_.updated_by AS updated_by_6,
  p0_.id AS id_7,
  p0_.order_id AS order_id_8,
  p0_.created AS created_9,
  p0_.updated AS updated_10,
  p0_.expertise AS expertise_11,
  p0_.expertise_icon AS expertise_icon_12,
  p0_.mvo_reference AS mvo_reference_13,
  p0_.kam_reference AS kam_reference_14,
  p0_.sponsor_reference AS sponsor_reference_15,
  p0_.discriminator AS discriminator_16,
  p0_.parent_id AS parent_id_17,
  p0_.project_category_id AS project_category_id_18,
  p0_.employee_id AS employee_id_19,
  p0_.photo_album_id AS photo_album_id_20
FROM
  page p0_
  LEFT JOIN page_content p1_ ON p0_.id = p1_.page_id
  AND p1_.discriminator IN ('basepagecontent')
WHERE
  (
    p0_.id = '37'
    AND p0_.published = 1
  )
  AND p0_.discriminator IN ('page')
GROUP BY
  p0_.id

SELECT p0_.published AS published_0, p0_.indexable AS indexable_1, p0_.layout AS layout_2, p0_.system_page AS system_page_3, p0_.components AS components_4, p0_.created_by AS created_by_5, p0_.updated_by AS updated_by_6, p0_.id AS id_7, p0_.order_id AS order_id_8, p0_.created AS created_9, p0_.updated AS updated_10, p0_.expertise AS expertise_11, p0_.expertise_icon AS expertise_icon_12, p0_.mvo_reference AS mvo_reference_13, p0_.kam_reference AS kam_reference_14, p0_.sponsor_reference AS sponsor_reference_15, p0_.discriminator AS discriminator_16, p0_.parent_id AS parent_id_17, p0_.project_category_id AS project_category_id_18, p0_.employee_id AS employee_id_19, p0_.photo_album_id AS photo_album_id_20 FROM page p0_ LEFT JOIN page_content p1_ ON p0_.id = p1_.page_id AND p1_.discriminator IN ('basepagecontent') WHERE (p0_.id = '37' AND p0_.published = 1) AND p0_.discriminator IN ('page') GROUP BY p0_.id;

SELECT
  m0_.title AS title_0,
  m0_.reference AS reference_1,
  m0_.created_by AS created_by_2,
  m0_.updated_by AS updated_by_3,
  m0_.id AS id_4,
  m0_.order_id AS order_id_5,
  m0_.created AS created_6,
  m0_.updated AS updated_7,
  c1_.title AS title_8,
  c1_.main AS main_9,
  c1_.id AS id_10,
  m0_.discriminator AS discriminator_11,
  c1_.discriminator AS discriminator_12,
  c1_.locale_id AS locale_id_13
FROM
  menu m0_
  LEFT JOIN menu_channel m2_ ON m0_.id = m2_.menu_id
  LEFT JOIN channel c1_ ON c1_.id = m2_.channel_id
  AND c1_.discriminator IN ('basechannel')
WHERE
  (
    m0_.reference = 'main'
    AND c1_.id = 1
  )
  AND m0_.discriminator IN ('basemenu')
GROUP BY
  m0_.id

SELECT m0_.title AS title_0, m0_.reference AS reference_1, m0_.created_by AS created_by_2, m0_.updated_by AS updated_by_3, m0_.id AS id_4, m0_.order_id AS order_id_5, m0_.created AS created_6, m0_.updated AS updated_7, c1_.title AS title_8, c1_.main AS main_9, c1_.id AS id_10, m0_.discriminator AS discriminator_11, c1_.discriminator AS discriminator_12, c1_.locale_id AS locale_id_13 FROM menu m0_ LEFT JOIN menu_channel m2_ ON m0_.id = m2_.menu_id LEFT JOIN channel c1_ ON c1_.id = m2_.channel_id AND c1_.discriminator IN ('basechannel') WHERE (m0_.reference = 'main' AND c1_.id = 1) AND m0_.discriminator IN ('basemenu') GROUP BY m0_.id;

SELECT
  p0_.published AS published_0,
  p0_.indexable AS indexable_1,
  p0_.layout AS layout_2,
  p0_.system_page AS system_page_3,
  p0_.components AS components_4,
  p0_.created_by AS created_by_5,
  p0_.updated_by AS updated_by_6,
  p0_.id AS id_7,
  p0_.order_id AS order_id_8,
  p0_.created AS created_9,
  p0_.updated AS updated_10,
  p0_.expertise AS expertise_11,
  p0_.expertise_icon AS expertise_icon_12,
  p0_.mvo_reference AS mvo_reference_13,
  p0_.kam_reference AS kam_reference_14,
  p0_.sponsor_reference AS sponsor_reference_15,
  p0_.discriminator AS discriminator_16,
  p0_.parent_id AS parent_id_17,
  p0_.project_category_id AS project_category_id_18,
  p0_.employee_id AS employee_id_19,
  p0_.photo_album_id AS photo_album_id_20
FROM
  page p0_
  LEFT JOIN page_content p1_ ON p0_.id = p1_.page_id
  AND p1_.discriminator IN ('basepagecontent')
WHERE
  (
    p0_.id = '5'
    AND p0_.published = 1
  )
  AND p0_.discriminator IN ('page')
GROUP BY
  p0_.id

SELECT p0_.published AS published_0, p0_.indexable AS indexable_1, p0_.layout AS layout_2, p0_.system_page AS system_page_3, p0_.components AS components_4, p0_.created_by AS created_by_5, p0_.updated_by AS updated_by_6, p0_.id AS id_7, p0_.order_id AS order_id_8, p0_.created AS created_9, p0_.updated AS updated_10, p0_.expertise AS expertise_11, p0_.expertise_icon AS expertise_icon_12, p0_.mvo_reference AS mvo_reference_13, p0_.kam_reference AS kam_reference_14, p0_.sponsor_reference AS sponsor_reference_15, p0_.discriminator AS discriminator_16, p0_.parent_id AS parent_id_17, p0_.project_category_id AS project_category_id_18, p0_.employee_id AS employee_id_19, p0_.photo_album_id AS photo_album_id_20 FROM page p0_ LEFT JOIN page_content p1_ ON p0_.id = p1_.page_id AND p1_.discriminator IN ('basepagecontent') WHERE (p0_.id = '5' AND p0_.published = 1) AND p0_.discriminator IN ('page') GROUP BY p0_.id;