Symfony Profiler

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 = 10 AND t0.deleted = 0 AND t0.active = 1 LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.identifier AS identifier_1,
  s0_.title AS title_2,
  s0_.content AS content_3,
  s0_.slug AS slug_4,
  s0_.meta_title AS meta_title_5,
  s0_.meta_description AS meta_description_6,
  s0_.active AS active_7,
  s0_.deleted AS deleted_8,
  s0_.created_at AS created_at_9,
  s0_.updated_at AS updated_at_10,
  s1_.id AS id_11,
  s1_.html AS html_12,
  s1_.position AS position_13,
  s1_.link AS link_14,
  s1_.buttontext AS buttontext_15,
  s1_.icon AS icon_16,
  s1_.title AS title_17,
  s1_.content AS content_18,
  s1_.slug AS slug_19,
  s1_.meta_title AS meta_title_20,
  s1_.meta_description AS meta_description_21,
  s1_.active AS active_22,
  s1_.deleted AS deleted_23,
  s1_.image AS image_24,
  s1_.created_at AS created_at_25,
  s1_.updated_at AS updated_at_26,
  s1_.slider_id AS slider_id_27
FROM
  slider s0_
  INNER JOIN slider_page s3_ ON s0_.id = s3_.slider_id
  INNER JOIN page p2_ ON p2_.id = s3_.page_id
  AND (
    p2_.id IN (1)
  )
  LEFT JOIN slider_images s1_ ON s0_.id = s1_.slider_id
WHERE
  s1_.deleted = 0
  AND s1_.active = 1
ORDER BY
  s1_.position ASC

SELECT s0_.id AS id_0, s0_.identifier AS identifier_1, s0_.title AS title_2, s0_.content AS content_3, s0_.slug AS slug_4, s0_.meta_title AS meta_title_5, s0_.meta_description AS meta_description_6, s0_.active AS active_7, s0_.deleted AS deleted_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10, s1_.id AS id_11, s1_.html AS html_12, s1_.position AS position_13, s1_.link AS link_14, s1_.buttontext AS buttontext_15, s1_.icon AS icon_16, s1_.title AS title_17, s1_.content AS content_18, s1_.slug AS slug_19, s1_.meta_title AS meta_title_20, s1_.meta_description AS meta_description_21, s1_.active AS active_22, s1_.deleted AS deleted_23, s1_.image AS image_24, s1_.created_at AS created_at_25, s1_.updated_at AS updated_at_26, s1_.slider_id AS slider_id_27 FROM slider s0_ INNER JOIN slider_page s3_ ON s0_.id = s3_.slider_id INNER JOIN page p2_ ON p2_.id = s3_.page_id AND (p2_.id IN (1)) LEFT JOIN slider_images s1_ ON s0_.id = s1_.slider_id WHERE s1_.deleted = 0 AND s1_.active = 1 ORDER BY s1_.position ASC;

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  accreditation a0_
WHERE
  a0_.deleted = 0
  AND a0_.active = 1
  AND a0_.featured = 1

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM accreditation a0_ WHERE a0_.deleted = 0 AND a0_.active = 1 AND a0_.featured = 1;

SELECT
  t0.id AS id_1,
  t0.author AS author_2,
  t0.company AS company_3,
  t0.featured AS featured_4,
  t0.title AS title_5,
  t0.content AS content_6,
  t0.active AS active_7,
  t0.deleted AS deleted_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.subtitle AS subtitle_11,
  t0.image AS image_12,
  t0.file AS file_13,
  t0.sort_order AS sort_order_14
FROM
  testimonial t0
WHERE
  t0.featured = ?

SELECT t0.id AS id_1, t0.author AS author_2, t0.company AS company_3, t0.featured AS featured_4, t0.title AS title_5, t0.content AS content_6, t0.active AS active_7, t0.deleted AS deleted_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.subtitle AS subtitle_11, t0.image AS image_12, t0.file AS file_13, t0.sort_order AS sort_order_14 FROM testimonial t0 WHERE t0.featured = 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 = ?
  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 = 'home' AND t0.deleted = 0 AND t0.active = 1 LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.position AS position_1,
  m0_.linkedin_url AS linkedin_url_2,
  m0_.email AS email_3,
  m0_.post_nominal AS post_nominal_4,
  m0_.featured AS featured_5,
  m0_.cta_text AS cta_text_6,
  m0_.cta_link AS cta_link_7,
  m0_.slug AS slug_8,
  m0_.title AS title_9,
  m0_.content AS content_10,
  m0_.meta_title AS meta_title_11,
  m0_.meta_description AS meta_description_12,
  m0_.active AS active_13,
  m0_.deleted AS deleted_14,
  m0_.image AS image_15,
  m0_.created_at AS created_at_16,
  m0_.updated_at AS updated_at_17,
  m0_.sort_order AS sort_order_18,
  m0_.testimonial_id AS testimonial_id_19
FROM
  meettheteam m0_
WHERE
  m0_.deleted = 0
  AND m0_.active = 1
  AND m0_.featured = 1
ORDER BY
  m0_.sort_order ASC

SELECT m0_.id AS id_0, m0_.position AS position_1, m0_.linkedin_url AS linkedin_url_2, m0_.email AS email_3, m0_.post_nominal AS post_nominal_4, m0_.featured AS featured_5, m0_.cta_text AS cta_text_6, m0_.cta_link AS cta_link_7, m0_.slug AS slug_8, m0_.title AS title_9, m0_.content AS content_10, m0_.meta_title AS meta_title_11, m0_.meta_description AS meta_description_12, m0_.active AS active_13, m0_.deleted AS deleted_14, m0_.image AS image_15, m0_.created_at AS created_at_16, m0_.updated_at AS updated_at_17, m0_.sort_order AS sort_order_18, m0_.testimonial_id AS testimonial_id_19 FROM meettheteam m0_ WHERE m0_.deleted = 0 AND m0_.active = 1 AND m0_.featured = 1 ORDER BY m0_.sort_order ASC;

SELECT
  a0_.id AS id_0,
  a0_.featured AS featured_1,
  a0_.link AS link_2,
  a0_.title AS title_3,
  a0_.content AS content_4,
  a0_.image AS image_5,
  a0_.sort_order AS sort_order_6,
  a0_.active AS active_7,
  a0_.deleted AS deleted_8,
  a0_.created_at AS created_at_9,
  a0_.updated_at AS updated_at_10
FROM
  accreditation a0_
WHERE
  a0_.deleted = 0
  AND a0_.active = 1
  AND a0_.featured = 1
  AND a0_.id IN (?, ?, ?)
ORDER BY
  a0_.sort_order ASC

SELECT a0_.id AS id_0, a0_.featured AS featured_1, a0_.link AS link_2, a0_.title AS title_3, a0_.content AS content_4, a0_.image AS image_5, a0_.sort_order AS sort_order_6, a0_.active AS active_7, a0_.deleted AS deleted_8, a0_.created_at AS created_at_9, a0_.updated_at AS updated_at_10 FROM accreditation a0_ WHERE a0_.deleted = 0 AND a0_.active = 1 AND a0_.featured = 1 AND a0_.id IN (1, 2, 3) ORDER BY a0_.sort_order ASC;

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.sort_order AS sort_order_1
FROM
  accreditation a0_
WHERE
  a0_.deleted = 0
  AND a0_.active = 1
  AND a0_.featured = 1
ORDER BY
  a0_.sort_order ASC
LIMIT
  10

SELECT DISTINCT a0_.id AS id_0, a0_.sort_order AS sort_order_1 FROM accreditation a0_ WHERE a0_.deleted = 0 AND a0_.active = 1 AND a0_.featured = 1 ORDER BY a0_.sort_order ASC LIMIT 10;

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