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.content3 AS content3_9,
  t0.cta_text AS cta_text_10,
  t0.cta_link AS cta_link_11,
  t0.landing_page_blocks AS landing_page_blocks_12,
  t0.title AS title_13,
  t0.content AS content_14,
  t0.subtitle AS subtitle_15,
  t0.meta_title AS meta_title_16,
  t0.meta_description AS meta_description_17,
  t0.active AS active_18,
  t0.deleted AS deleted_19,
  t0.image AS image_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.content2 AS content2_23,
  t0.update_by AS update_by_24,
  t0.parent AS parent_25,
  t0.template_id AS template_id_26,
  t0.testimonial_id AS testimonial_id_27,
  t28.id AS id_29,
  t28.title AS title_30,
  t28.content AS content_31,
  t28.active AS active_32,
  t28.deleted AS deleted_33,
  t28.created_at AS created_at_34,
  t28.updated_at AS updated_at_35,
  t28.sort_order AS sort_order_36,
  t28.page_id AS page_id_37
FROM
  page t0
  LEFT JOIN areas_we_cover t28 ON t28.page_id = t0.id
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.content3 AS content3_9, t0.cta_text AS cta_text_10, t0.cta_link AS cta_link_11, t0.landing_page_blocks AS landing_page_blocks_12, t0.title AS title_13, t0.content AS content_14, t0.subtitle AS subtitle_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.active AS active_18, t0.deleted AS deleted_19, t0.image AS image_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.content2 AS content2_23, t0.update_by AS update_by_24, t0.parent AS parent_25, t0.template_id AS template_id_26, t0.testimonial_id AS testimonial_id_27, t28.id AS id_29, t28.title AS title_30, t28.content AS content_31, t28.active AS active_32, t28.deleted AS deleted_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.sort_order AS sort_order_36, t28.page_id AS page_id_37 FROM page t0 LEFT JOIN areas_we_cover t28 ON t28.page_id = t0.id WHERE t0.slug = 'areas-of-expertise' AND t0.deleted = 0 AND t0.active = 1 LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.content2 AS content2_1,
  s0_.content3 AS content3_2,
  s0_.cta_text AS cta_text_3,
  s0_.cta_link AS cta_link_4,
  s0_.icon AS icon_5,
  s0_.title AS title_6,
  s0_.content AS content_7,
  s0_.subtitle AS subtitle_8,
  s0_.image AS image_9,
  s0_.sort_order AS sort_order_10,
  s0_.active AS active_11,
  s0_.slug AS slug_12,
  s0_.meta_title AS meta_title_13,
  s0_.meta_description AS meta_description_14,
  s0_.deleted AS deleted_15,
  s0_.created_at AS created_at_16,
  s0_.updated_at AS updated_at_17,
  s1_.id AS id_18,
  s1_.content2 AS content2_19,
  s1_.cta_text AS cta_text_20,
  s1_.cta_link AS cta_link_21,
  s1_.cta_text2 AS cta_text2_22,
  s1_.cta_link2 AS cta_link2_23,
  s1_.icon AS icon_24,
  s1_.employer_or_employee AS employer_or_employee_25,
  s1_.show_on_menu AS show_on_menu_26,
  s1_.slug AS slug_27,
  s1_.title AS title_28,
  s1_.content AS content_29,
  s1_.subtitle AS subtitle_30,
  s1_.image AS image_31,
  s1_.sort_order AS sort_order_32,
  s1_.active AS active_33,
  s1_.meta_title AS meta_title_34,
  s1_.meta_description AS meta_description_35,
  s1_.deleted AS deleted_36,
  s1_.created_at AS created_at_37,
  s1_.updated_at AS updated_at_38,
  t2_.id AS id_39,
  t2_.author AS author_40,
  t2_.company AS company_41,
  t2_.featured AS featured_42,
  t2_.title AS title_43,
  t2_.content AS content_44,
  t2_.active AS active_45,
  t2_.deleted AS deleted_46,
  t2_.created_at AS created_at_47,
  t2_.updated_at AS updated_at_48,
  t2_.subtitle AS subtitle_49,
  t2_.image AS image_50,
  t2_.file AS file_51,
  t2_.sort_order AS sort_order_52,
  s0_.testimonial_id AS testimonial_id_53,
  s1_.testimonial_id AS testimonial_id_54,
  s1_.category_id AS category_id_55
FROM
  service_category s0_
  LEFT JOIN service s1_ ON s0_.id = s1_.category_id
  AND (
    s1_.deleted = 0
    AND s1_.active = 1
  )
  LEFT JOIN testimonial t2_ ON s0_.testimonial_id = t2_.id
  AND (
    t2_.deleted = 0
    AND t2_.active = 1
  )
WHERE
  s0_.deleted = 0
  AND s0_.active = 1
ORDER BY
  s0_.sort_order ASC

SELECT s0_.id AS id_0, s0_.content2 AS content2_1, s0_.content3 AS content3_2, s0_.cta_text AS cta_text_3, s0_.cta_link AS cta_link_4, s0_.icon AS icon_5, s0_.title AS title_6, s0_.content AS content_7, s0_.subtitle AS subtitle_8, s0_.image AS image_9, s0_.sort_order AS sort_order_10, s0_.active AS active_11, s0_.slug AS slug_12, s0_.meta_title AS meta_title_13, s0_.meta_description AS meta_description_14, s0_.deleted AS deleted_15, s0_.created_at AS created_at_16, s0_.updated_at AS updated_at_17, s1_.id AS id_18, s1_.content2 AS content2_19, s1_.cta_text AS cta_text_20, s1_.cta_link AS cta_link_21, s1_.cta_text2 AS cta_text2_22, s1_.cta_link2 AS cta_link2_23, s1_.icon AS icon_24, s1_.employer_or_employee AS employer_or_employee_25, s1_.show_on_menu AS show_on_menu_26, s1_.slug AS slug_27, s1_.title AS title_28, s1_.content AS content_29, s1_.subtitle AS subtitle_30, s1_.image AS image_31, s1_.sort_order AS sort_order_32, s1_.active AS active_33, s1_.meta_title AS meta_title_34, s1_.meta_description AS meta_description_35, s1_.deleted AS deleted_36, s1_.created_at AS created_at_37, s1_.updated_at AS updated_at_38, t2_.id AS id_39, t2_.author AS author_40, t2_.company AS company_41, t2_.featured AS featured_42, t2_.title AS title_43, t2_.content AS content_44, t2_.active AS active_45, t2_.deleted AS deleted_46, t2_.created_at AS created_at_47, t2_.updated_at AS updated_at_48, t2_.subtitle AS subtitle_49, t2_.image AS image_50, t2_.file AS file_51, t2_.sort_order AS sort_order_52, s0_.testimonial_id AS testimonial_id_53, s1_.testimonial_id AS testimonial_id_54, s1_.category_id AS category_id_55 FROM service_category s0_ LEFT JOIN service s1_ ON s0_.id = s1_.category_id AND (s1_.deleted = 0 AND s1_.active = 1) LEFT JOIN testimonial t2_ ON s0_.testimonial_id = t2_.id AND (t2_.deleted = 0 AND t2_.active = 1) WHERE s0_.deleted = 0 AND s0_.active = 1 ORDER BY s0_.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.id = ?
  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.id = 1 AND t0.deleted = 0 AND t0.active = 1 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.id = ?
  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.id = 12 AND t0.deleted = 0 AND t0.active = 1 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.id = ?
  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.id = 9 AND t0.deleted = 0 AND t0.active = 1 LIMIT 1;