Symfony Profiler

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
  l0_.code AS code_0,
  l0_.language_code AS language_code_1,
  l0_.country_code AS country_code_2,
  l0_.id AS id_3,
  l0_.discriminator AS discriminator_4
FROM
  locale l0_
WHERE
  (l0_.code = ?)
  AND l0_.discriminator IN ('baselocale')

SELECT l0_.code AS code_0, l0_.language_code AS language_code_1, l0_.country_code AS country_code_2, l0_.id AS id_3, l0_.discriminator AS discriminator_4 FROM locale l0_ WHERE (l0_.code = 'nl_NL') AND l0_.discriminator IN ('baselocale');

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
  c0_.title AS title_0,
  c0_.main AS main_1,
  c0_.id AS id_2,
  c0_.discriminator AS discriminator_3,
  c0_.locale_id AS locale_id_4
FROM
  channel c0_
WHERE
  c0_.discriminator IN ('basechannel')
GROUP BY
  c0_.id

SELECT c0_.title AS title_0, c0_.main AS main_1, c0_.id AS id_2, c0_.discriminator AS discriminator_3, c0_.locale_id AS locale_id_4 FROM channel c0_ WHERE c0_.discriminator IN ('basechannel') GROUP BY c0_.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 = '/project/1e-fase-voor-cascaderun-gereed./'
    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 = '/project/1e-fase-voor-cascaderun-gereed./' AND r0_.active = 1) AND r0_.discriminator IN ('baseroute') 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 = '/project/1e-fase-voor-cascaderun-gereed./'
    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 = '/project/1e-fase-voor-cascaderun-gereed./' AND r0_.active = 1) AND r0_.discriminator IN ('baseredirect') 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 = '/project/1e-fase-voor-cascaderun-gereed./'
    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 = '/project/1e-fase-voor-cascaderun-gereed./' AND r0_.active = 1) AND r0_.discriminator IN ('baseroute') 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 = '/project/1e-fase-voor-cascaderun-gereed./'
    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 = '/project/1e-fase-voor-cascaderun-gereed./' AND r0_.active = 1) AND r0_.discriminator IN ('baseredirect') GROUP BY r0_.id;

SELECT
  p0_.title AS title_0,
  p0_.html_content AS html_content_1,
  p0_.published AS published_2,
  p0_.layout AS layout_3,
  p0_.created_by AS created_by_4,
  p0_.updated_by AS updated_by_5,
  p0_.id AS id_6,
  p0_.browser_title AS browser_title_7,
  p0_.meta_description AS meta_description_8,
  p0_.meta_keywords AS meta_keywords_9,
  p0_.indexable AS indexable_10,
  p0_.slug AS slug_11,
  p0_.order_id AS order_id_12,
  p0_.created AS created_13,
  p0_.updated AS updated_14,
  p0_.start_date AS start_date_15,
  p0_.end_date AS end_date_16,
  p0_.city AS city_17,
  p0_.discriminator AS discriminator_18,
  p0_.employee_id AS employee_id_19
FROM
  project p0_
WHERE
  (
    p0_.slug = '1e-fase-voor-cascaderun-gereed.'
  )
  AND p0_.discriminator IN ('baseproject', 'project')
GROUP BY
  p0_.id

SELECT p0_.title AS title_0, p0_.html_content AS html_content_1, p0_.published AS published_2, p0_.layout AS layout_3, p0_.created_by AS created_by_4, p0_.updated_by AS updated_by_5, p0_.id AS id_6, p0_.browser_title AS browser_title_7, p0_.meta_description AS meta_description_8, p0_.meta_keywords AS meta_keywords_9, p0_.indexable AS indexable_10, p0_.slug AS slug_11, p0_.order_id AS order_id_12, p0_.created AS created_13, p0_.updated AS updated_14, p0_.start_date AS start_date_15, p0_.end_date AS end_date_16, p0_.city AS city_17, p0_.discriminator AS discriminator_18, p0_.employee_id AS employee_id_19 FROM project p0_ WHERE (p0_.slug = '1e-fase-voor-cascaderun-gereed.') AND p0_.discriminator IN ('baseproject', 'project') GROUP BY p0_.id;

SELECT
  p0_.title AS title_0,
  p0_.html_content AS html_content_1,
  p0_.published AS published_2,
  p0_.layout AS layout_3,
  p0_.created_by AS created_by_4,
  p0_.updated_by AS updated_by_5,
  p0_.id AS id_6,
  p0_.browser_title AS browser_title_7,
  p0_.meta_description AS meta_description_8,
  p0_.meta_keywords AS meta_keywords_9,
  p0_.indexable AS indexable_10,
  p0_.slug AS slug_11,
  p0_.order_id AS order_id_12,
  p0_.created AS created_13,
  p0_.updated AS updated_14,
  p0_.start_date AS start_date_15,
  p0_.end_date AS end_date_16,
  p0_.city AS city_17,
  p0_.discriminator AS discriminator_18,
  p0_.employee_id AS employee_id_19
FROM
  project p0_
WHERE
  (p0_.published = 1)
  AND p0_.discriminator IN ('baseproject', 'project')
GROUP BY
  p0_.id
ORDER BY
  p0_.id ASC

SELECT p0_.title AS title_0, p0_.html_content AS html_content_1, p0_.published AS published_2, p0_.layout AS layout_3, p0_.created_by AS created_by_4, p0_.updated_by AS updated_by_5, p0_.id AS id_6, p0_.browser_title AS browser_title_7, p0_.meta_description AS meta_description_8, p0_.meta_keywords AS meta_keywords_9, p0_.indexable AS indexable_10, p0_.slug AS slug_11, p0_.order_id AS order_id_12, p0_.created AS created_13, p0_.updated AS updated_14, p0_.start_date AS start_date_15, p0_.end_date AS end_date_16, p0_.city AS city_17, p0_.discriminator AS discriminator_18, p0_.employee_id AS employee_id_19 FROM project p0_ WHERE (p0_.published = 1) AND p0_.discriminator IN ('baseproject', 'project') GROUP BY p0_.id ORDER BY p0_.id ASC;

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
  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
  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
  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,
  m0_.discriminator AS discriminator_8
FROM
  menu m0_
WHERE
  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, m0_.discriminator AS discriminator_8 FROM menu m0_ WHERE m0_.discriminator IN ('basemenu') GROUP BY m0_.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
  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
  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 = 2 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_.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
  t0.published AS published_1,
  t0.indexable AS indexable_2,
  t0.layout AS layout_3,
  t0.system_page AS system_page_4,
  t0.components AS components_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.parent_id AS parent_id_12,
  t0.discriminator,
  t0.expertise AS expertise_13,
  t0.expertise_icon AS expertise_icon_14,
  t0.mvo_reference AS mvo_reference_15,
  t0.kam_reference AS kam_reference_16,
  t0.sponsor_reference AS sponsor_reference_17,
  t0.project_category_id AS project_category_id_18,
  t0.employee_id AS employee_id_19,
  t0.photo_album_id AS photo_album_id_20
FROM
  page t0
WHERE
  t0.id = ?
  AND t0.discriminator IN ('basepage', 'page')

SELECT t0.published AS published_1, t0.indexable AS indexable_2, t0.layout AS layout_3, t0.system_page AS system_page_4, t0.components AS components_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.parent_id AS parent_id_12, t0.discriminator, t0.expertise AS expertise_13, t0.expertise_icon AS expertise_icon_14, t0.mvo_reference AS mvo_reference_15, t0.kam_reference AS kam_reference_16, t0.sponsor_reference AS sponsor_reference_17, t0.project_category_id AS project_category_id_18, t0.employee_id AS employee_id_19, t0.photo_album_id AS photo_album_id_20 FROM page t0 WHERE t0.id = 10 AND t0.discriminator IN ('basepage', 'page');

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