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,
  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_.deleted = 0
  AND c0_.active = 1
  AND c0_.id IN (?)

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_.deleted = 0 AND c0_.active = 1 AND c0_.id IN (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' AND t0.deleted = 0 AND t0.active = 1 LIMIT 1;

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  casestudies c0_
WHERE
  c0_.deleted = 0
  AND c0_.active = 1

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM casestudies c0_ WHERE c0_.deleted = 0 AND c0_.active = 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_;

SELECT
  DISTINCT c0_.id AS id_0
FROM
  casestudies c0_
WHERE
  c0_.deleted = 0
  AND c0_.active = 1
LIMIT
  12

SELECT DISTINCT c0_.id AS id_0 FROM casestudies c0_ WHERE c0_.deleted = 0 AND c0_.active = 1 LIMIT 12;