Symfony Profiler

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

SELECT
  t0.components AS components_1,
  t0.extraUrlsegments AS extraUrlsegments_2,
  t0.htmlblocks AS htmlblocks_3,
  t0.slug AS slug_4,
  t0.id AS id_5,
  t0.navtitle AS navtitle_6,
  t0.url AS url_7,
  t0.viewable_from AS viewable_from_8,
  t0.content2 AS content2_9,
  t0.kicker AS kicker_10,
  t0.title AS title_11,
  t0.content AS content_12,
  t0.subtitle AS subtitle_13,
  t0.meta_title AS meta_title_14,
  t0.meta_description AS meta_description_15,
  t0.ogImageAlt AS ogImageAlt_16,
  t0.ogImage AS ogImage_17,
  t0.active AS active_18,
  t0.deleted AS deleted_19,
  t0.image AS image_20,
  t0.image2 AS image2_21,
  t0.image3 AS image3_22,
  t0.file AS file_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.update_by AS update_by_26,
  t0.parent AS parent_27,
  t0.template_id AS template_id_28,
  t0.gallery_id AS gallery_id_29
FROM
  page t0
WHERE
  t0.slug = ?
  AND t0.deleted = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.components AS components_1, t0.extraUrlsegments AS extraUrlsegments_2, t0.htmlblocks AS htmlblocks_3, t0.slug AS slug_4, t0.id AS id_5, t0.navtitle AS navtitle_6, t0.url AS url_7, t0.viewable_from AS viewable_from_8, t0.content2 AS content2_9, t0.kicker AS kicker_10, t0.title AS title_11, t0.content AS content_12, t0.subtitle AS subtitle_13, t0.meta_title AS meta_title_14, t0.meta_description AS meta_description_15, t0.ogImageAlt AS ogImageAlt_16, t0.ogImage AS ogImage_17, t0.active AS active_18, t0.deleted AS deleted_19, t0.image AS image_20, t0.image2 AS image2_21, t0.image3 AS image3_22, t0.file AS file_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.update_by AS update_by_26, t0.parent AS parent_27, t0.template_id AS template_id_28, t0.gallery_id AS gallery_id_29 FROM page t0 WHERE t0.slug = 'expertise/new-builds' AND t0.deleted = 0 AND t0.active = 1 LIMIT 1;

SELECT
  t0.components AS components_1,
  t0.extraUrlsegments AS extraUrlsegments_2,
  t0.htmlblocks AS htmlblocks_3,
  t0.slug AS slug_4,
  t0.id AS id_5,
  t0.navtitle AS navtitle_6,
  t0.url AS url_7,
  t0.viewable_from AS viewable_from_8,
  t0.content2 AS content2_9,
  t0.kicker AS kicker_10,
  t0.title AS title_11,
  t0.content AS content_12,
  t0.subtitle AS subtitle_13,
  t0.meta_title AS meta_title_14,
  t0.meta_description AS meta_description_15,
  t0.ogImageAlt AS ogImageAlt_16,
  t0.ogImage AS ogImage_17,
  t0.active AS active_18,
  t0.deleted AS deleted_19,
  t0.image AS image_20,
  t0.image2 AS image2_21,
  t0.image3 AS image3_22,
  t0.file AS file_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.update_by AS update_by_26,
  t0.parent AS parent_27,
  t0.template_id AS template_id_28,
  t0.gallery_id AS gallery_id_29
FROM
  page t0

SELECT t0.components AS components_1, t0.extraUrlsegments AS extraUrlsegments_2, t0.htmlblocks AS htmlblocks_3, t0.slug AS slug_4, t0.id AS id_5, t0.navtitle AS navtitle_6, t0.url AS url_7, t0.viewable_from AS viewable_from_8, t0.content2 AS content2_9, t0.kicker AS kicker_10, t0.title AS title_11, t0.content AS content_12, t0.subtitle AS subtitle_13, t0.meta_title AS meta_title_14, t0.meta_description AS meta_description_15, t0.ogImageAlt AS ogImageAlt_16, t0.ogImage AS ogImage_17, t0.active AS active_18, t0.deleted AS deleted_19, t0.image AS image_20, t0.image2 AS image2_21, t0.image3 AS image3_22, t0.file AS file_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.update_by AS update_by_26, t0.parent AS parent_27, t0.template_id AS template_id_28, t0.gallery_id AS gallery_id_29 FROM page t0;

SELECT
  t0.id AS id_1,
  t0.icon AS icon_2,
  t0.kicker AS kicker_3,
  t0.content2 AS content2_4,
  t0.content3 AS content3_5,
  t0.content4 AS content4_6,
  t0.title AS title_7,
  t0.content AS content_8,
  t0.subtitle AS subtitle_9,
  t0.image AS image_10,
  t0.image2 AS image2_11,
  t0.image3 AS image3_12,
  t0.image4 AS image4_13,
  t0.sort_order AS sort_order_14,
  t0.active AS active_15,
  t0.deleted AS deleted_16,
  t0.slug AS slug_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19,
  t0.ogImageAlt AS ogImageAlt_20,
  t0.ogImage AS ogImage_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.gallery_id AS gallery_id_24
FROM
  sectors t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.icon AS icon_2, t0.kicker AS kicker_3, t0.content2 AS content2_4, t0.content3 AS content3_5, t0.content4 AS content4_6, t0.title AS title_7, t0.content AS content_8, t0.subtitle AS subtitle_9, t0.image AS image_10, t0.image2 AS image2_11, t0.image3 AS image3_12, t0.image4 AS image4_13, t0.sort_order AS sort_order_14, t0.active AS active_15, t0.deleted AS deleted_16, t0.slug AS slug_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.ogImageAlt AS ogImageAlt_20, t0.ogImage AS ogImage_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.gallery_id AS gallery_id_24 FROM sectors t0 WHERE t0.slug = 'new-builds' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.icon AS icon_1,
  s0_.kicker AS kicker_2,
  s0_.content2 AS content2_3,
  s0_.content3 AS content3_4,
  s0_.content4 AS content4_5,
  s0_.title AS title_6,
  s0_.content AS content_7,
  s0_.subtitle AS subtitle_8,
  s0_.image AS image_9,
  s0_.image2 AS image2_10,
  s0_.image3 AS image3_11,
  s0_.image4 AS image4_12,
  s0_.sort_order AS sort_order_13,
  s0_.active AS active_14,
  s0_.deleted AS deleted_15,
  s0_.slug AS slug_16,
  s0_.meta_title AS meta_title_17,
  s0_.meta_description AS meta_description_18,
  s0_.ogImageAlt AS ogImageAlt_19,
  s0_.ogImage AS ogImage_20,
  s0_.created_at AS created_at_21,
  s0_.updated_at AS updated_at_22,
  g1_.id AS id_23,
  g1_.title AS title_24,
  g1_.content AS content_25,
  g1_.active AS active_26,
  g1_.deleted AS deleted_27,
  g1_.created_at AS created_at_28,
  g1_.updated_at AS updated_at_29,
  g2_.id AS id_30,
  g2_.title AS title_31,
  g2_.content AS content_32,
  g2_.image AS image_33,
  g2_.file AS file_34,
  g2_.sort_order AS sort_order_35,
  g2_.active AS active_36,
  g2_.deleted AS deleted_37,
  g2_.created_at AS created_at_38,
  g2_.updated_at AS updated_at_39,
  s0_.gallery_id AS gallery_id_40,
  g2_.gallery_id AS gallery_id_41
FROM
  sectors s0_
  LEFT JOIN gallery g1_ ON s0_.gallery_id = g1_.id
  AND (
    g1_.active = 1
    AND g1_.deleted = 0
  )
  LEFT JOIN gallery_image g2_ ON g1_.id = g2_.gallery_id
  AND (
    g2_.active = 1
    AND g2_.deleted = 0
  )
WHERE
  s0_.slug = ?
  AND (
    s0_.active = 1
    AND s0_.deleted = 0
  )
ORDER BY
  g2_.sort_order ASC

SELECT s0_.id AS id_0, s0_.icon AS icon_1, s0_.kicker AS kicker_2, s0_.content2 AS content2_3, s0_.content3 AS content3_4, s0_.content4 AS content4_5, s0_.title AS title_6, s0_.content AS content_7, s0_.subtitle AS subtitle_8, s0_.image AS image_9, s0_.image2 AS image2_10, s0_.image3 AS image3_11, s0_.image4 AS image4_12, s0_.sort_order AS sort_order_13, s0_.active AS active_14, s0_.deleted AS deleted_15, s0_.slug AS slug_16, s0_.meta_title AS meta_title_17, s0_.meta_description AS meta_description_18, s0_.ogImageAlt AS ogImageAlt_19, s0_.ogImage AS ogImage_20, s0_.created_at AS created_at_21, s0_.updated_at AS updated_at_22, g1_.id AS id_23, g1_.title AS title_24, g1_.content AS content_25, g1_.active AS active_26, g1_.deleted AS deleted_27, g1_.created_at AS created_at_28, g1_.updated_at AS updated_at_29, g2_.id AS id_30, g2_.title AS title_31, g2_.content AS content_32, g2_.image AS image_33, g2_.file AS file_34, g2_.sort_order AS sort_order_35, g2_.active AS active_36, g2_.deleted AS deleted_37, g2_.created_at AS created_at_38, g2_.updated_at AS updated_at_39, s0_.gallery_id AS gallery_id_40, g2_.gallery_id AS gallery_id_41 FROM sectors s0_ LEFT JOIN gallery g1_ ON s0_.gallery_id = g1_.id AND (g1_.active = 1 AND g1_.deleted = 0) LEFT JOIN gallery_image g2_ ON g1_.id = g2_.gallery_id AND (g2_.active = 1 AND g2_.deleted = 0) WHERE s0_.slug = 'new-builds' AND (s0_.active = 1 AND s0_.deleted = 0) ORDER BY g2_.sort_order ASC;

SELECT
  t0.id AS id_1,
  t0.icon AS icon_2,
  t0.kicker AS kicker_3,
  t0.content2 AS content2_4,
  t0.content3 AS content3_5,
  t0.content4 AS content4_6,
  t0.title AS title_7,
  t0.content AS content_8,
  t0.subtitle AS subtitle_9,
  t0.image AS image_10,
  t0.image2 AS image2_11,
  t0.image3 AS image3_12,
  t0.image4 AS image4_13,
  t0.sort_order AS sort_order_14,
  t0.active AS active_15,
  t0.deleted AS deleted_16,
  t0.slug AS slug_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19,
  t0.ogImageAlt AS ogImageAlt_20,
  t0.ogImage AS ogImage_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.gallery_id AS gallery_id_24
FROM
  sectors t0
WHERE
  t0.active = ?
  AND t0.deleted = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.icon AS icon_2, t0.kicker AS kicker_3, t0.content2 AS content2_4, t0.content3 AS content3_5, t0.content4 AS content4_6, t0.title AS title_7, t0.content AS content_8, t0.subtitle AS subtitle_9, t0.image AS image_10, t0.image2 AS image2_11, t0.image3 AS image3_12, t0.image4 AS image4_13, t0.sort_order AS sort_order_14, t0.active AS active_15, t0.deleted AS deleted_16, t0.slug AS slug_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.ogImageAlt AS ogImageAlt_20, t0.ogImage AS ogImage_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.gallery_id AS gallery_id_24 FROM sectors t0 WHERE t0.active = 1 AND t0.deleted = 0 ORDER BY t0.sort_order ASC;

SELECT
  t0.id AS id_1,
  t0.html AS html_2,
  t0.title AS title_3,
  t0.content AS content_4,
  t0.slug AS slug_5,
  t0.active AS active_6,
  t0.deleted AS deleted_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  html_blocks t0
WHERE
  t0.title = ?
  AND t0.deleted = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.html AS html_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.active AS active_6, t0.deleted AS deleted_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM html_blocks t0 WHERE t0.title = 'Form Text' AND t0.deleted = 0 AND t0.active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.image AS image_4,
  t0.sort_order AS sort_order_5,
  t0.active AS active_6,
  t0.deleted AS deleted_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  logo t0
WHERE
  t0.active = ?
  AND t0.deleted = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.image AS image_4, t0.sort_order AS sort_order_5, t0.active AS active_6, t0.deleted AS deleted_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM logo t0 WHERE t0.active = 1 AND t0.deleted = 0 ORDER BY t0.sort_order ASC;

SELECT
  t0.id AS id_1,
  t0.html AS html_2,
  t0.title AS title_3,
  t0.content AS content_4,
  t0.slug AS slug_5,
  t0.active AS active_6,
  t0.deleted AS deleted_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  html_blocks t0
WHERE
  t0.deleted = ?

SELECT t0.id AS id_1, t0.html AS html_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.active AS active_6, t0.deleted AS deleted_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM html_blocks t0 WHERE t0.deleted = 0;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.templatefile AS templatefile_3,
  t0.number_of_html AS number_of_html_4,
  t0.number_of_components AS number_of_components_5,
  t0.inherited_bundle_name AS inherited_bundle_name_6,
  t0.title AS title_7,
  t0.content AS content_8,
  t0.active AS active_9,
  t0.deleted AS deleted_10,
  t0.image AS image_11
FROM
  templates t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.templatefile AS templatefile_3, t0.number_of_html AS number_of_html_4, t0.number_of_components AS number_of_components_5, t0.inherited_bundle_name AS inherited_bundle_name_6, t0.title AS title_7, t0.content AS content_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.image AS image_11 FROM templates t0 WHERE t0.id = 6;

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.content AS content_2,
  s0_.active AS active_3,
  s0_.deleted AS deleted_4,
  s0_.created_at AS created_at_5,
  s0_.updated_at AS updated_at_6,
  s0_.image AS image_7,
  s0_.file AS file_8
FROM
  setting s0_
WHERE
  s0_.id = ?
  AND s0_.active = 1
  AND s0_.deleted = 0

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.content AS content_2, s0_.active AS active_3, s0_.deleted AS deleted_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.image AS image_7, s0_.file AS file_8 FROM setting s0_ WHERE s0_.id = 2 AND s0_.active = 1 AND s0_.deleted = 0;

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.content AS content_2,
  s0_.active AS active_3,
  s0_.deleted AS deleted_4,
  s0_.created_at AS created_at_5,
  s0_.updated_at AS updated_at_6,
  s0_.image AS image_7,
  s0_.file AS file_8
FROM
  setting s0_
WHERE
  s0_.id = ?
  AND s0_.active = 1
  AND s0_.deleted = 0

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.content AS content_2, s0_.active AS active_3, s0_.deleted AS deleted_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.image AS image_7, s0_.file AS file_8 FROM setting s0_ WHERE s0_.id = 2 AND s0_.active = 1 AND s0_.deleted = 0;

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.content AS content_2,
  s0_.active AS active_3,
  s0_.deleted AS deleted_4,
  s0_.created_at AS created_at_5,
  s0_.updated_at AS updated_at_6,
  s0_.image AS image_7,
  s0_.file AS file_8
FROM
  setting s0_
WHERE
  s0_.id = ?
  AND s0_.active = 1
  AND s0_.deleted = 0

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.content AS content_2, s0_.active AS active_3, s0_.deleted AS deleted_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.image AS image_7, s0_.file AS file_8 FROM setting s0_ WHERE s0_.id = 3 AND s0_.active = 1 AND s0_.deleted = 0;

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.content AS content_2,
  s0_.active AS active_3,
  s0_.deleted AS deleted_4,
  s0_.created_at AS created_at_5,
  s0_.updated_at AS updated_at_6,
  s0_.image AS image_7,
  s0_.file AS file_8
FROM
  setting s0_
WHERE
  s0_.id = ?
  AND s0_.active = 1
  AND s0_.deleted = 0

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.content AS content_2, s0_.active AS active_3, s0_.deleted AS deleted_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.image AS image_7, s0_.file AS file_8 FROM setting s0_ WHERE s0_.id = 3 AND s0_.active = 1 AND s0_.deleted = 0;

SELECT
  t0.id AS id_1,
  t0.identifier AS identifier_2,
  t0.active AS active_3,
  t0.deleted AS deleted_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_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.active AS active_3, t0.deleted AS deleted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.update_by AS update_by_7 FROM menus t0 WHERE t0.identifier = 'Top' LIMIT 1;

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.newwindow AS newwindow_6,
  t0.isdynamic AS isdynamic_7,
  t0.dynamicentity AS dynamicentity_8,
  t0.active AS active_9,
  t0.deleted AS deleted_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_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.newwindow AS newwindow_6, t0.isdynamic AS isdynamic_7, t0.dynamicentity AS dynamicentity_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menuId AS menuId_13, t0.pageId AS pageId_14 FROM menuitems t0 WHERE t0.menuId = 1;

SELECT
  t0.id AS id_1,
  t0.icon AS icon_2,
  t0.kicker AS kicker_3,
  t0.content2 AS content2_4,
  t0.content3 AS content3_5,
  t0.content4 AS content4_6,
  t0.title AS title_7,
  t0.content AS content_8,
  t0.subtitle AS subtitle_9,
  t0.image AS image_10,
  t0.image2 AS image2_11,
  t0.image3 AS image3_12,
  t0.image4 AS image4_13,
  t0.sort_order AS sort_order_14,
  t0.active AS active_15,
  t0.deleted AS deleted_16,
  t0.slug AS slug_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19,
  t0.ogImageAlt AS ogImageAlt_20,
  t0.ogImage AS ogImage_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.gallery_id AS gallery_id_24
FROM
  sectors t0
WHERE
  t0.active = ?
  AND t0.deleted = ?

SELECT t0.id AS id_1, t0.icon AS icon_2, t0.kicker AS kicker_3, t0.content2 AS content2_4, t0.content3 AS content3_5, t0.content4 AS content4_6, t0.title AS title_7, t0.content AS content_8, t0.subtitle AS subtitle_9, t0.image AS image_10, t0.image2 AS image2_11, t0.image3 AS image3_12, t0.image4 AS image4_13, t0.sort_order AS sort_order_14, t0.active AS active_15, t0.deleted AS deleted_16, t0.slug AS slug_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.ogImageAlt AS ogImageAlt_20, t0.ogImage AS ogImage_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.gallery_id AS gallery_id_24 FROM sectors t0 WHERE t0.active = 1 AND t0.deleted = 0;