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 = 1 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
  t0.title AS title_1,
  t0.reference AS reference_2,
  t0.created_by AS created_by_3,
  t0.updated_by AS updated_by_4,
  t0.id AS id_5,
  t0.image_title AS image_title_6,
  t0.image_alt AS image_alt_7,
  t0.created AS created_8,
  t0.updated AS updated_9,
  t0.upload_id AS upload_id_10,
  t0.discriminator
FROM
  visual t0
  INNER JOIN page_visual_link ON t0.id = page_visual_link.visual_id
WHERE
  page_visual_link.page_id = ?
  AND t0.discriminator IN ('basevisual')

SELECT t0.title AS title_1, t0.reference AS reference_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.id AS id_5, t0.image_title AS image_title_6, t0.image_alt AS image_alt_7, t0.created AS created_8, t0.updated AS updated_9, t0.upload_id AS upload_id_10, t0.discriminator FROM visual t0 INNER JOIN page_visual_link ON t0.id = page_visual_link.visual_id WHERE page_visual_link.page_id = 1 AND t0.discriminator IN ('basevisual');

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')
  LEFT JOIN page_channel p3_ ON p0_.id = p3_.page_id
  LEFT JOIN channel c2_ ON c2_.id = p3_.channel_id
  AND c2_.discriminator IN ('basechannel')
WHERE
  (
    p1_.slug = 'home'
    AND c2_.id = 1
    AND p1_.channel_id = 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') LEFT JOIN page_channel p3_ ON p0_.id = p3_.page_id LEFT JOIN channel c2_ ON c2_.id = p3_.channel_id AND c2_.discriminator IN ('basechannel') WHERE (p1_.slug = 'home' AND c2_.id = 1 AND p1_.channel_id = 1) AND p0_.discriminator IN ('page') GROUP BY p0_.id;

SELECT
  DISTINCT id_7
FROM
  (
    SELECT
      DISTINCT id_7
    FROM
      (
        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
        FROM
          page p0_
          LEFT JOIN page_content p1_ ON p0_.id = p1_.page_id
          AND p1_.discriminator IN ('basepagecontent')
        WHERE
          (
            p0_.published = 1
            AND p0_.expertise = 1
          )
          AND p0_.discriminator IN ('page')
        GROUP BY
          p0_.id
      ) dctrn_result_inner
    ORDER BY
      id_7 ASC
  ) dctrn_result
LIMIT
  21

SELECT DISTINCT id_7 FROM (SELECT DISTINCT id_7 FROM (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 FROM page p0_ LEFT JOIN page_content p1_ ON p0_.id = p1_.page_id AND p1_.discriminator IN ('basepagecontent') WHERE (p0_.published = 1 AND p0_.expertise = 1) AND p0_.discriminator IN ('page') GROUP BY p0_.id) dctrn_result_inner ORDER BY id_7 ASC) dctrn_result LIMIT 21;

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 = 178 AND t0.discriminator IN ('baseupload');

SELECT
  c0_.reference AS reference_0,
  c0_.link AS link_1,
  c0_.created_by AS created_by_2,
  c0_.updated_by AS updated_by_3,
  c0_.id AS id_4,
  c0_.image_title AS image_title_5,
  c0_.image_alt AS image_alt_6,
  c0_.created AS created_7,
  c0_.updated AS updated_8,
  u1_.filename AS filename_9,
  u1_.mime_type AS mime_type_10,
  u1_.extension AS extension_11,
  u1_.created_by AS created_by_12,
  u1_.updated_by AS updated_by_13,
  u1_.id AS id_14,
  u1_.order_id AS order_id_15,
  u1_.created AS created_16,
  u1_.updated AS updated_17,
  c0_.discriminator AS discriminator_18,
  c0_.upload_id AS upload_id_19,
  u1_.discriminator AS discriminator_20,
  u1_.folder_id AS folder_id_21
FROM
  content_block c0_
  LEFT JOIN content_block_content c2_ ON c0_.id = c2_.content_block_id
  AND c2_.discriminator IN ('basecontentblockcontent')
  LEFT JOIN upload u1_ ON c0_.upload_id = u1_.id
  AND u1_.discriminator IN ('baseupload')
WHERE
  (c0_.reference = 'notification')
  AND c0_.discriminator IN ('basecontentblock')
GROUP BY
  c0_.id,
  u1_.filename,
  u1_.mime_type,
  u1_.extension,
  u1_.created_by,
  u1_.updated_by,
  u1_.id,
  u1_.order_id,
  u1_.created,
  u1_.updated,
  u1_.folder_id

SELECT c0_.reference AS reference_0, c0_.link AS link_1, c0_.created_by AS created_by_2, c0_.updated_by AS updated_by_3, c0_.id AS id_4, c0_.image_title AS image_title_5, c0_.image_alt AS image_alt_6, c0_.created AS created_7, c0_.updated AS updated_8, u1_.filename AS filename_9, u1_.mime_type AS mime_type_10, u1_.extension AS extension_11, u1_.created_by AS created_by_12, u1_.updated_by AS updated_by_13, u1_.id AS id_14, u1_.order_id AS order_id_15, u1_.created AS created_16, u1_.updated AS updated_17, c0_.discriminator AS discriminator_18, c0_.upload_id AS upload_id_19, u1_.discriminator AS discriminator_20, u1_.folder_id AS folder_id_21 FROM content_block c0_ LEFT JOIN content_block_content c2_ ON c0_.id = c2_.content_block_id AND c2_.discriminator IN ('basecontentblockcontent') LEFT JOIN upload u1_ ON c0_.upload_id = u1_.id AND u1_.discriminator IN ('baseupload') WHERE (c0_.reference = 'notification') AND c0_.discriminator IN ('basecontentblock') GROUP BY c0_.id, u1_.filename, u1_.mime_type, u1_.extension, u1_.created_by, u1_.updated_by, u1_.id, u1_.order_id, u1_.created, u1_.updated, u1_.folder_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
  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_.published = 1
    AND p0_.expertise = 1
    AND p0_.id IN (?, ?, ?, ?, ?)
  )
  AND p0_.discriminator IN ('page')
GROUP BY
  p0_.id
ORDER BY
  p0_.id ASC

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_.published = 1 AND p0_.expertise = 1 AND p0_.id IN (11, 12, 14, 15, 37)) AND p0_.discriminator IN ('page') GROUP BY p0_.id ORDER BY p0_.id ASC;

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 = '39'
    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 = '39' 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

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 = '14'
    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 = '14' AND p0_.published = 1) AND p0_.discriminator IN ('page') GROUP BY p0_.id;

SELECT
  s0_.name AS name_0,
  s0_.value AS value_1,
  s0_.reference AS reference_2,
  s0_.scope AS scope_3,
  s0_.permission AS permission_4,
  s0_.factory AS factory_5,
  s0_.id AS id_6,
  s0_.discriminator AS discriminator_7
FROM
  setting s0_
WHERE
  s0_.discriminator IN ('basesetting')
GROUP BY
  s0_.id

SELECT s0_.name AS name_0, s0_.value AS value_1, s0_.reference AS reference_2, s0_.scope AS scope_3, s0_.permission AS permission_4, s0_.factory AS factory_5, s0_.id AS id_6, s0_.discriminator AS discriminator_7 FROM setting s0_ WHERE s0_.discriminator IN ('basesetting') GROUP BY s0_.id;

SELECT
  t0.title AS title_1,
  t0.main AS main_2,
  t0.id AS id_3,
  t0.locale_id AS locale_id_4,
  t0.discriminator
FROM
  channel t0
  INNER JOIN menu_channel ON t0.id = menu_channel.channel_id
WHERE
  menu_channel.menu_id = ?
  AND t0.discriminator IN ('basechannel')

SELECT t0.title AS title_1, t0.main AS main_2, t0.id AS id_3, t0.locale_id AS locale_id_4, t0.discriminator FROM channel t0 INNER JOIN menu_channel ON t0.id = menu_channel.channel_id WHERE menu_channel.menu_id = 2 AND t0.discriminator IN ('basechannel');

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