Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.navtitle AS navtitle_3,
  t0.viewable_from AS viewable_from_4,
  t0.url AS url_5,
  t0.slug AS slug_6,
  t0.content AS content_7,
  t0.content2 AS content2_8,
  t0.ctaButtonTitle AS ctaButtonTitle_9,
  t0.ctaButtonLink AS ctaButtonLink_10,
  t0.bannerText AS bannerText_11,
  t0.buttonTitle AS buttonTitle_12,
  t0.buttonLink AS buttonLink_13,
  t0.created AS created_14,
  t0.updated AS updated_15,
  t0.active AS active_16,
  t0.deleted AS deleted_17,
  t0.components AS components_18,
  t0.extraUrlsegments AS extraUrlsegments_19,
  t0.metatitle AS metatitle_20,
  t0.metadescription AS metadescription_21,
  t0.related_sectors AS related_sectors_22,
  t0.related_services AS related_services_23,
  t0.htmlblocks AS htmlblocks_24,
  t0.image AS image_25,
  t0.subtitle AS subtitle_26,
  t0.pageIntro AS pageIntro_27,
  t0.sub_image AS sub_image_28,
  t0.largeImage AS largeImage_29,
  t0.video AS video_30,
  t0.pagelinkBoxes AS pagelinkBoxes_31,
  t0.page_links_sort_order AS page_links_sort_order_32,
  t0.pagelinkText AS pagelinkText_33,
  t0.faq AS faq_34,
  t0.files AS files_35,
  t0.dont_show_image AS dont_show_image_36,
  t0.youtube_id AS youtube_id_37,
  t0.vimeo_id AS vimeo_id_38,
  t0.show_media_type AS show_media_type_39,
  t0.taggedin AS taggedin_40,
  t0.update_by AS update_by_41,
  t0.parent AS parent_42,
  t0.template_id AS template_id_43
FROM
  page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.navtitle AS navtitle_3, t0.viewable_from AS viewable_from_4, t0.url AS url_5, t0.slug AS slug_6, t0.content AS content_7, t0.content2 AS content2_8, t0.ctaButtonTitle AS ctaButtonTitle_9, t0.ctaButtonLink AS ctaButtonLink_10, t0.bannerText AS bannerText_11, t0.buttonTitle AS buttonTitle_12, t0.buttonLink AS buttonLink_13, t0.created AS created_14, t0.updated AS updated_15, t0.active AS active_16, t0.deleted AS deleted_17, t0.components AS components_18, t0.extraUrlsegments AS extraUrlsegments_19, t0.metatitle AS metatitle_20, t0.metadescription AS metadescription_21, t0.related_sectors AS related_sectors_22, t0.related_services AS related_services_23, t0.htmlblocks AS htmlblocks_24, t0.image AS image_25, t0.subtitle AS subtitle_26, t0.pageIntro AS pageIntro_27, t0.sub_image AS sub_image_28, t0.largeImage AS largeImage_29, t0.video AS video_30, t0.pagelinkBoxes AS pagelinkBoxes_31, t0.page_links_sort_order AS page_links_sort_order_32, t0.pagelinkText AS pagelinkText_33, t0.faq AS faq_34, t0.files AS files_35, t0.dont_show_image AS dont_show_image_36, t0.youtube_id AS youtube_id_37, t0.vimeo_id AS vimeo_id_38, t0.show_media_type AS show_media_type_39, t0.taggedin AS taggedin_40, t0.update_by AS update_by_41, t0.parent AS parent_42, t0.template_id AS template_id_43 FROM page t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.identifier AS identifier_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.active AS active_5,
  t0.deleted AS deleted_6,
  t0.update_by AS update_by_7
FROM
  menus t0
WHERE
  t0.identifier = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.active AS active_5, t0.deleted AS deleted_6, t0.update_by AS update_by_7 FROM menus t0 WHERE t0.identifier = 'Top' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.navtitle AS navtitle_3,
  t0.viewable_from AS viewable_from_4,
  t0.url AS url_5,
  t0.slug AS slug_6,
  t0.content AS content_7,
  t0.content2 AS content2_8,
  t0.ctaButtonTitle AS ctaButtonTitle_9,
  t0.ctaButtonLink AS ctaButtonLink_10,
  t0.bannerText AS bannerText_11,
  t0.buttonTitle AS buttonTitle_12,
  t0.buttonLink AS buttonLink_13,
  t0.created AS created_14,
  t0.updated AS updated_15,
  t0.active AS active_16,
  t0.deleted AS deleted_17,
  t0.components AS components_18,
  t0.extraUrlsegments AS extraUrlsegments_19,
  t0.metatitle AS metatitle_20,
  t0.metadescription AS metadescription_21,
  t0.related_sectors AS related_sectors_22,
  t0.related_services AS related_services_23,
  t0.htmlblocks AS htmlblocks_24,
  t0.image AS image_25,
  t0.subtitle AS subtitle_26,
  t0.pageIntro AS pageIntro_27,
  t0.sub_image AS sub_image_28,
  t0.largeImage AS largeImage_29,
  t0.video AS video_30,
  t0.pagelinkBoxes AS pagelinkBoxes_31,
  t0.page_links_sort_order AS page_links_sort_order_32,
  t0.pagelinkText AS pagelinkText_33,
  t0.faq AS faq_34,
  t0.files AS files_35,
  t0.dont_show_image AS dont_show_image_36,
  t0.youtube_id AS youtube_id_37,
  t0.vimeo_id AS vimeo_id_38,
  t0.show_media_type AS show_media_type_39,
  t0.taggedin AS taggedin_40,
  t0.update_by AS update_by_41,
  t0.parent AS parent_42,
  t0.template_id AS template_id_43
FROM
  page t0
WHERE
  t0.slug = ?
  AND t0.deleted = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.navtitle AS navtitle_3, t0.viewable_from AS viewable_from_4, t0.url AS url_5, t0.slug AS slug_6, t0.content AS content_7, t0.content2 AS content2_8, t0.ctaButtonTitle AS ctaButtonTitle_9, t0.ctaButtonLink AS ctaButtonLink_10, t0.bannerText AS bannerText_11, t0.buttonTitle AS buttonTitle_12, t0.buttonLink AS buttonLink_13, t0.created AS created_14, t0.updated AS updated_15, t0.active AS active_16, t0.deleted AS deleted_17, t0.components AS components_18, t0.extraUrlsegments AS extraUrlsegments_19, t0.metatitle AS metatitle_20, t0.metadescription AS metadescription_21, t0.related_sectors AS related_sectors_22, t0.related_services AS related_services_23, t0.htmlblocks AS htmlblocks_24, t0.image AS image_25, t0.subtitle AS subtitle_26, t0.pageIntro AS pageIntro_27, t0.sub_image AS sub_image_28, t0.largeImage AS largeImage_29, t0.video AS video_30, t0.pagelinkBoxes AS pagelinkBoxes_31, t0.page_links_sort_order AS page_links_sort_order_32, t0.pagelinkText AS pagelinkText_33, t0.faq AS faq_34, t0.files AS files_35, t0.dont_show_image AS dont_show_image_36, t0.youtube_id AS youtube_id_37, t0.vimeo_id AS vimeo_id_38, t0.show_media_type AS show_media_type_39, t0.taggedin AS taggedin_40, t0.update_by AS update_by_41, t0.parent AS parent_42, t0.template_id AS template_id_43 FROM page t0 WHERE t0.slug = 'the-degree-apprentice-of-the-year-award-2020' AND t0.deleted = 0 AND t0.active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.templatefile AS templatefile_4,
  t0.image AS image_5,
  t0.active AS active_6,
  t0.deleted AS deleted_7,
  t0.number_of_html AS number_of_html_8,
  t0.number_of_components AS number_of_components_9,
  t0.inherited_bundle_name AS inherited_bundle_name_10
FROM
  templates t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.templatefile AS templatefile_4, t0.image AS image_5, t0.active AS active_6, t0.deleted AS deleted_7, t0.number_of_html AS number_of_html_8, t0.number_of_components AS number_of_components_9, t0.inherited_bundle_name AS inherited_bundle_name_10 FROM templates t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name_override AS name_override_2,
  t0.url_override AS url_override_3,
  t0.menu_item_id AS menu_item_id_4,
  t0.menu_parent_id AS menu_parent_id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.active AS active_8,
  t0.deleted AS deleted_9,
  t0.newwindow AS newwindow_10,
  t0.isdynamic AS isdynamic_11,
  t0.dynamicentity AS dynamicentity_12,
  t0.menuId AS menuId_13,
  t0.pageId AS pageId_14
FROM
  menuitems t0
WHERE
  t0.menuId = ?

SELECT t0.id AS id_1, t0.name_override AS name_override_2, t0.url_override AS url_override_3, t0.menu_item_id AS menu_item_id_4, t0.menu_parent_id AS menu_parent_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.active AS active_8, t0.deleted AS deleted_9, t0.newwindow AS newwindow_10, t0.isdynamic AS isdynamic_11, t0.dynamicentity AS dynamicentity_12, t0.menuId AS menuId_13, t0.pageId AS pageId_14 FROM menuitems t0 WHERE t0.menuId = 1;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.navtitle AS navtitle_2,
  p0_.viewable_from AS viewable_from_3,
  p0_.url AS url_4,
  p0_.slug AS slug_5,
  p0_.content AS content_6,
  p0_.content2 AS content2_7,
  p0_.ctaButtonTitle AS ctaButtonTitle_8,
  p0_.ctaButtonLink AS ctaButtonLink_9,
  p0_.bannerText AS bannerText_10,
  p0_.buttonTitle AS buttonTitle_11,
  p0_.buttonLink AS buttonLink_12,
  p0_.created AS created_13,
  p0_.updated AS updated_14,
  p0_.active AS active_15,
  p0_.deleted AS deleted_16,
  p0_.components AS components_17,
  p0_.extraUrlsegments AS extraUrlsegments_18,
  p0_.metatitle AS metatitle_19,
  p0_.metadescription AS metadescription_20,
  p0_.related_sectors AS related_sectors_21,
  p0_.related_services AS related_services_22,
  p0_.htmlblocks AS htmlblocks_23,
  p0_.image AS image_24,
  p0_.subtitle AS subtitle_25,
  p0_.pageIntro AS pageIntro_26,
  p0_.sub_image AS sub_image_27,
  p0_.largeImage AS largeImage_28,
  p0_.video AS video_29,
  p0_.pagelinkBoxes AS pagelinkBoxes_30,
  p0_.page_links_sort_order AS page_links_sort_order_31,
  p0_.pagelinkText AS pagelinkText_32,
  p0_.faq AS faq_33,
  p0_.files AS files_34,
  p0_.dont_show_image AS dont_show_image_35,
  p0_.youtube_id AS youtube_id_36,
  p0_.vimeo_id AS vimeo_id_37,
  p0_.show_media_type AS show_media_type_38,
  p0_.taggedin AS taggedin_39,
  p0_.update_by AS update_by_40,
  p0_.parent AS parent_41,
  p0_.template_id AS template_id_42
FROM
  page p0_
WHERE
  p0_.slug NOT LIKE ?
  AND p0_.image IS NOT NULL
  AND (
    p0_.active = 1
    AND p0_.deleted = 0
  )
  AND p0_.id IN (NULL)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.navtitle AS navtitle_2, p0_.viewable_from AS viewable_from_3, p0_.url AS url_4, p0_.slug AS slug_5, p0_.content AS content_6, p0_.content2 AS content2_7, p0_.ctaButtonTitle AS ctaButtonTitle_8, p0_.ctaButtonLink AS ctaButtonLink_9, p0_.bannerText AS bannerText_10, p0_.buttonTitle AS buttonTitle_11, p0_.buttonLink AS buttonLink_12, p0_.created AS created_13, p0_.updated AS updated_14, p0_.active AS active_15, p0_.deleted AS deleted_16, p0_.components AS components_17, p0_.extraUrlsegments AS extraUrlsegments_18, p0_.metatitle AS metatitle_19, p0_.metadescription AS metadescription_20, p0_.related_sectors AS related_sectors_21, p0_.related_services AS related_services_22, p0_.htmlblocks AS htmlblocks_23, p0_.image AS image_24, p0_.subtitle AS subtitle_25, p0_.pageIntro AS pageIntro_26, p0_.sub_image AS sub_image_27, p0_.largeImage AS largeImage_28, p0_.video AS video_29, p0_.pagelinkBoxes AS pagelinkBoxes_30, p0_.page_links_sort_order AS page_links_sort_order_31, p0_.pagelinkText AS pagelinkText_32, p0_.faq AS faq_33, p0_.files AS files_34, p0_.dont_show_image AS dont_show_image_35, p0_.youtube_id AS youtube_id_36, p0_.vimeo_id AS vimeo_id_37, p0_.show_media_type AS show_media_type_38, p0_.taggedin AS taggedin_39, p0_.update_by AS update_by_40, p0_.parent AS parent_41, p0_.template_id AS template_id_42 FROM page p0_ WHERE p0_.slug NOT LIKE '{%' AND p0_.image IS NOT NULL AND (p0_.active = 1 AND p0_.deleted = 0) AND p0_.id IN (NULL);

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.html AS html_4,
  t0.active AS active_5,
  t0.deleted AS deleted_6
FROM
  html_blocks t0
WHERE
  t0.title = ?
  AND t0.deleted = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.html AS html_4, t0.active AS active_5, t0.deleted AS deleted_6 FROM html_blocks t0 WHERE t0.title = 'Header Announcement' AND t0.deleted = 0 AND t0.active = 1 LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.slug AS slug_1
FROM
  page p0_

SELECT p0_.id AS id_0, p0_.slug AS slug_1 FROM page p0_;