Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.featured AS featured_1,
  c0_.client_name AS client_name_2,
  c0_.client_testimonial AS client_testimonial_3,
  c0_.client_testimonial_attestant AS client_testimonial_attestant_4,
  c0_.client_testimonial_attestant_job_title AS client_testimonial_attestant_job_title_5,
  c0_.project_name AS project_name_6,
  c0_.project_start_date AS project_start_date_7,
  c0_.project_duration AS project_duration_8,
  c0_.project_budget AS project_budget_9,
  c0_.project_location AS project_location_10,
  c0_.detail_subtitle AS detail_subtitle_11,
  c0_.detail_content AS detail_content_12,
  c0_.challenges_subtitle AS challenges_subtitle_13,
  c0_.challenges_content AS challenges_content_14,
  c0_.solution_subtitle AS solution_subtitle_15,
  c0_.solution_content AS solution_content_16,
  c0_.kicker AS kicker_17,
  c0_.title AS title_18,
  c0_.content AS content_19,
  c0_.slug AS slug_20,
  c0_.meta_title AS meta_title_21,
  c0_.meta_description AS meta_description_22,
  c0_.ogImageAlt AS ogImageAlt_23,
  c0_.ogImage AS ogImage_24,
  c0_.active AS active_25,
  c0_.deleted AS deleted_26,
  c0_.image AS image_27,
  c0_.image2 AS image2_28,
  c0_.image3 AS image3_29,
  c0_.image4 AS image4_30,
  c0_.image5 AS image5_31,
  c0_.created_at AS created_at_32,
  c0_.updated_at AS updated_at_33,
  g1_.id AS id_34,
  g1_.title AS title_35,
  g1_.content AS content_36,
  g1_.active AS active_37,
  g1_.deleted AS deleted_38,
  g1_.created_at AS created_at_39,
  g1_.updated_at AS updated_at_40,
  g2_.id AS id_41,
  g2_.title AS title_42,
  g2_.content AS content_43,
  g2_.image AS image_44,
  g2_.file AS file_45,
  g2_.sort_order AS sort_order_46,
  g2_.active AS active_47,
  g2_.deleted AS deleted_48,
  g2_.created_at AS created_at_49,
  g2_.updated_at AS updated_at_50,
  c0_.project_type_id AS project_type_id_51,
  c0_.gallery_id AS gallery_id_52,
  c0_.testimonial_id AS testimonial_id_53,
  g2_.gallery_id AS gallery_id_54
FROM
  casestudies c0_
  LEFT JOIN gallery g1_ ON c0_.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
  c0_.slug = ?
  AND (
    c0_.active = 1
    AND c0_.deleted = 0
  )
ORDER BY
  g2_.sort_order ASC

SELECT c0_.id AS id_0, c0_.featured AS featured_1, c0_.client_name AS client_name_2, c0_.client_testimonial AS client_testimonial_3, c0_.client_testimonial_attestant AS client_testimonial_attestant_4, c0_.client_testimonial_attestant_job_title AS client_testimonial_attestant_job_title_5, c0_.project_name AS project_name_6, c0_.project_start_date AS project_start_date_7, c0_.project_duration AS project_duration_8, c0_.project_budget AS project_budget_9, c0_.project_location AS project_location_10, c0_.detail_subtitle AS detail_subtitle_11, c0_.detail_content AS detail_content_12, c0_.challenges_subtitle AS challenges_subtitle_13, c0_.challenges_content AS challenges_content_14, c0_.solution_subtitle AS solution_subtitle_15, c0_.solution_content AS solution_content_16, c0_.kicker AS kicker_17, c0_.title AS title_18, c0_.content AS content_19, c0_.slug AS slug_20, c0_.meta_title AS meta_title_21, c0_.meta_description AS meta_description_22, c0_.ogImageAlt AS ogImageAlt_23, c0_.ogImage AS ogImage_24, c0_.active AS active_25, c0_.deleted AS deleted_26, c0_.image AS image_27, c0_.image2 AS image2_28, c0_.image3 AS image3_29, c0_.image4 AS image4_30, c0_.image5 AS image5_31, c0_.created_at AS created_at_32, c0_.updated_at AS updated_at_33, g1_.id AS id_34, g1_.title AS title_35, g1_.content AS content_36, g1_.active AS active_37, g1_.deleted AS deleted_38, g1_.created_at AS created_at_39, g1_.updated_at AS updated_at_40, g2_.id AS id_41, g2_.title AS title_42, g2_.content AS content_43, g2_.image AS image_44, g2_.file AS file_45, g2_.sort_order AS sort_order_46, g2_.active AS active_47, g2_.deleted AS deleted_48, g2_.created_at AS created_at_49, g2_.updated_at AS updated_at_50, c0_.project_type_id AS project_type_id_51, c0_.gallery_id AS gallery_id_52, c0_.testimonial_id AS testimonial_id_53, g2_.gallery_id AS gallery_id_54 FROM casestudies c0_ LEFT JOIN gallery g1_ ON c0_.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 c0_.slug = 'bensham-lane-oakwood' AND (c0_.active = 1 AND c0_.deleted = 0) ORDER BY g2_.sort_order ASC;

SELECT
  t0.id AS id_1,
  t0.featured AS featured_2,
  t0.client_name AS client_name_3,
  t0.client_testimonial AS client_testimonial_4,
  t0.client_testimonial_attestant AS client_testimonial_attestant_5,
  t0.client_testimonial_attestant_job_title AS client_testimonial_attestant_job_title_6,
  t0.project_name AS project_name_7,
  t0.project_start_date AS project_start_date_8,
  t0.project_duration AS project_duration_9,
  t0.project_budget AS project_budget_10,
  t0.project_location AS project_location_11,
  t0.detail_subtitle AS detail_subtitle_12,
  t0.detail_content AS detail_content_13,
  t0.challenges_subtitle AS challenges_subtitle_14,
  t0.challenges_content AS challenges_content_15,
  t0.solution_subtitle AS solution_subtitle_16,
  t0.solution_content AS solution_content_17,
  t0.kicker AS kicker_18,
  t0.title AS title_19,
  t0.content AS content_20,
  t0.slug AS slug_21,
  t0.meta_title AS meta_title_22,
  t0.meta_description AS meta_description_23,
  t0.ogImageAlt AS ogImageAlt_24,
  t0.ogImage AS ogImage_25,
  t0.active AS active_26,
  t0.deleted AS deleted_27,
  t0.image AS image_28,
  t0.image2 AS image2_29,
  t0.image3 AS image3_30,
  t0.image4 AS image4_31,
  t0.image5 AS image5_32,
  t0.created_at AS created_at_33,
  t0.updated_at AS updated_at_34,
  t0.project_type_id AS project_type_id_35,
  t0.gallery_id AS gallery_id_36,
  t0.testimonial_id AS testimonial_id_37
FROM
  casestudies t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.featured AS featured_2, t0.client_name AS client_name_3, t0.client_testimonial AS client_testimonial_4, t0.client_testimonial_attestant AS client_testimonial_attestant_5, t0.client_testimonial_attestant_job_title AS client_testimonial_attestant_job_title_6, t0.project_name AS project_name_7, t0.project_start_date AS project_start_date_8, t0.project_duration AS project_duration_9, t0.project_budget AS project_budget_10, t0.project_location AS project_location_11, t0.detail_subtitle AS detail_subtitle_12, t0.detail_content AS detail_content_13, t0.challenges_subtitle AS challenges_subtitle_14, t0.challenges_content AS challenges_content_15, t0.solution_subtitle AS solution_subtitle_16, t0.solution_content AS solution_content_17, t0.kicker AS kicker_18, t0.title AS title_19, t0.content AS content_20, t0.slug AS slug_21, t0.meta_title AS meta_title_22, t0.meta_description AS meta_description_23, t0.ogImageAlt AS ogImageAlt_24, t0.ogImage AS ogImage_25, t0.active AS active_26, t0.deleted AS deleted_27, t0.image AS image_28, t0.image2 AS image2_29, t0.image3 AS image3_30, t0.image4 AS image4_31, t0.image5 AS image5_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.project_type_id AS project_type_id_35, t0.gallery_id AS gallery_id_36, t0.testimonial_id AS testimonial_id_37 FROM casestudies t0 WHERE t0.slug = 'bensham-lane-oakwood' 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.id = ?

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.id = 10;

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.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 = 'case-studies/bensham-lane-oakwood' AND t0.deleted = 0 AND t0.active = 1 LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.featured AS featured_1,
  c0_.client_name AS client_name_2,
  c0_.client_testimonial AS client_testimonial_3,
  c0_.client_testimonial_attestant AS client_testimonial_attestant_4,
  c0_.client_testimonial_attestant_job_title AS client_testimonial_attestant_job_title_5,
  c0_.project_name AS project_name_6,
  c0_.project_start_date AS project_start_date_7,
  c0_.project_duration AS project_duration_8,
  c0_.project_budget AS project_budget_9,
  c0_.project_location AS project_location_10,
  c0_.detail_subtitle AS detail_subtitle_11,
  c0_.detail_content AS detail_content_12,
  c0_.challenges_subtitle AS challenges_subtitle_13,
  c0_.challenges_content AS challenges_content_14,
  c0_.solution_subtitle AS solution_subtitle_15,
  c0_.solution_content AS solution_content_16,
  c0_.kicker AS kicker_17,
  c0_.title AS title_18,
  c0_.content AS content_19,
  c0_.slug AS slug_20,
  c0_.meta_title AS meta_title_21,
  c0_.meta_description AS meta_description_22,
  c0_.ogImageAlt AS ogImageAlt_23,
  c0_.ogImage AS ogImage_24,
  c0_.active AS active_25,
  c0_.deleted AS deleted_26,
  c0_.image AS image_27,
  c0_.image2 AS image2_28,
  c0_.image3 AS image3_29,
  c0_.image4 AS image4_30,
  c0_.image5 AS image5_31,
  c0_.created_at AS created_at_32,
  c0_.updated_at AS updated_at_33,
  c0_.project_type_id AS project_type_id_34,
  c0_.gallery_id AS gallery_id_35,
  c0_.testimonial_id AS testimonial_id_36
FROM
  casestudies c0_
WHERE
  (
    c0_.active = 1
    AND c0_.deleted = 0
  )
  AND c0_.id > ?
ORDER BY
  c0_.id ASC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.featured AS featured_1, c0_.client_name AS client_name_2, c0_.client_testimonial AS client_testimonial_3, c0_.client_testimonial_attestant AS client_testimonial_attestant_4, c0_.client_testimonial_attestant_job_title AS client_testimonial_attestant_job_title_5, c0_.project_name AS project_name_6, c0_.project_start_date AS project_start_date_7, c0_.project_duration AS project_duration_8, c0_.project_budget AS project_budget_9, c0_.project_location AS project_location_10, c0_.detail_subtitle AS detail_subtitle_11, c0_.detail_content AS detail_content_12, c0_.challenges_subtitle AS challenges_subtitle_13, c0_.challenges_content AS challenges_content_14, c0_.solution_subtitle AS solution_subtitle_15, c0_.solution_content AS solution_content_16, c0_.kicker AS kicker_17, c0_.title AS title_18, c0_.content AS content_19, c0_.slug AS slug_20, c0_.meta_title AS meta_title_21, c0_.meta_description AS meta_description_22, c0_.ogImageAlt AS ogImageAlt_23, c0_.ogImage AS ogImage_24, c0_.active AS active_25, c0_.deleted AS deleted_26, c0_.image AS image_27, c0_.image2 AS image2_28, c0_.image3 AS image3_29, c0_.image4 AS image4_30, c0_.image5 AS image5_31, c0_.created_at AS created_at_32, c0_.updated_at AS updated_at_33, c0_.project_type_id AS project_type_id_34, c0_.gallery_id AS gallery_id_35, c0_.testimonial_id AS testimonial_id_36 FROM casestudies c0_ WHERE (c0_.active = 1 AND c0_.deleted = 0) AND c0_.id > 1 ORDER BY c0_.id ASC 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
  c0_.id AS id_0,
  c0_.featured AS featured_1,
  c0_.client_name AS client_name_2,
  c0_.client_testimonial AS client_testimonial_3,
  c0_.client_testimonial_attestant AS client_testimonial_attestant_4,
  c0_.client_testimonial_attestant_job_title AS client_testimonial_attestant_job_title_5,
  c0_.project_name AS project_name_6,
  c0_.project_start_date AS project_start_date_7,
  c0_.project_duration AS project_duration_8,
  c0_.project_budget AS project_budget_9,
  c0_.project_location AS project_location_10,
  c0_.detail_subtitle AS detail_subtitle_11,
  c0_.detail_content AS detail_content_12,
  c0_.challenges_subtitle AS challenges_subtitle_13,
  c0_.challenges_content AS challenges_content_14,
  c0_.solution_subtitle AS solution_subtitle_15,
  c0_.solution_content AS solution_content_16,
  c0_.kicker AS kicker_17,
  c0_.title AS title_18,
  c0_.content AS content_19,
  c0_.slug AS slug_20,
  c0_.meta_title AS meta_title_21,
  c0_.meta_description AS meta_description_22,
  c0_.ogImageAlt AS ogImageAlt_23,
  c0_.ogImage AS ogImage_24,
  c0_.active AS active_25,
  c0_.deleted AS deleted_26,
  c0_.image AS image_27,
  c0_.image2 AS image2_28,
  c0_.image3 AS image3_29,
  c0_.image4 AS image4_30,
  c0_.image5 AS image5_31,
  c0_.created_at AS created_at_32,
  c0_.updated_at AS updated_at_33,
  c0_.project_type_id AS project_type_id_34,
  c0_.gallery_id AS gallery_id_35,
  c0_.testimonial_id AS testimonial_id_36
FROM
  casestudies c0_
WHERE
  (
    c0_.active = 1
    AND c0_.deleted = 0
  )
  AND c0_.id < ?
ORDER BY
  c0_.id DESC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.featured AS featured_1, c0_.client_name AS client_name_2, c0_.client_testimonial AS client_testimonial_3, c0_.client_testimonial_attestant AS client_testimonial_attestant_4, c0_.client_testimonial_attestant_job_title AS client_testimonial_attestant_job_title_5, c0_.project_name AS project_name_6, c0_.project_start_date AS project_start_date_7, c0_.project_duration AS project_duration_8, c0_.project_budget AS project_budget_9, c0_.project_location AS project_location_10, c0_.detail_subtitle AS detail_subtitle_11, c0_.detail_content AS detail_content_12, c0_.challenges_subtitle AS challenges_subtitle_13, c0_.challenges_content AS challenges_content_14, c0_.solution_subtitle AS solution_subtitle_15, c0_.solution_content AS solution_content_16, c0_.kicker AS kicker_17, c0_.title AS title_18, c0_.content AS content_19, c0_.slug AS slug_20, c0_.meta_title AS meta_title_21, c0_.meta_description AS meta_description_22, c0_.ogImageAlt AS ogImageAlt_23, c0_.ogImage AS ogImage_24, c0_.active AS active_25, c0_.deleted AS deleted_26, c0_.image AS image_27, c0_.image2 AS image2_28, c0_.image3 AS image3_29, c0_.image4 AS image4_30, c0_.image5 AS image5_31, c0_.created_at AS created_at_32, c0_.updated_at AS updated_at_33, c0_.project_type_id AS project_type_id_34, c0_.gallery_id AS gallery_id_35, c0_.testimonial_id AS testimonial_id_36 FROM casestudies c0_ WHERE (c0_.active = 1 AND c0_.deleted = 0) AND c0_.id < 1 ORDER BY c0_.id DESC 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
  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_;