Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.thumbnail AS thumbnail_3,
  t0.seo_title AS seo_title_4,
  t0.slug AS slug_5,
  t0.brief AS brief_6,
  t0.content AS content_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  page t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.thumbnail AS thumbnail_3, t0.seo_title AS seo_title_4, t0.slug AS slug_5, t0.brief AS brief_6, t0.content AS content_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM page t0 WHERE t0.slug = 'home' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.postal_code AS postal_code_4,
  t0.client_photo AS client_photo_5,
  t0.before_work_photo AS before_work_photo_6,
  t0.after_work_photo AS after_work_photo_7,
  t0.work_types AS work_types_8,
  t0.google_review_online AS google_review_online_9,
  t0.agency_concerned AS agency_concerned_10,
  t0.rating AS rating_11,
  t0.review_source AS review_source_12,
  t0.publish_online AS publish_online_13,
  t0.month AS month_14,
  t0.position AS position_15,
  t0.created_at AS created_at_16,
  t0.location_id AS location_id_17
FROM
  client t0
WHERE
  t0.publish_online = ?
ORDER BY
  t0.created_at DESC
LIMIT
  10

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.postal_code AS postal_code_4, t0.client_photo AS client_photo_5, t0.before_work_photo AS before_work_photo_6, t0.after_work_photo AS after_work_photo_7, t0.work_types AS work_types_8, t0.google_review_online AS google_review_online_9, t0.agency_concerned AS agency_concerned_10, t0.rating AS rating_11, t0.review_source AS review_source_12, t0.publish_online AS publish_online_13, t0.month AS month_14, t0.position AS position_15, t0.created_at AS created_at_16, t0.location_id AS location_id_17 FROM client t0 WHERE t0.publish_online = 1 ORDER BY t0.created_at DESC LIMIT 10;

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.position AS position_2,
  b0_.slug AS slug_3,
  b0_.photo AS photo_4,
  b0_.banner AS banner_5,
  b0_.brief AS brief_6,
  b0_.content AS content_7,
  b0_.seo_title AS seo_title_8,
  b0_.seo_desc AS seo_desc_9,
  b0_.bgbanner AS bgbanner_10,
  b0_.published AS published_11
FROM
  business b0_
WHERE
  b0_.published = 1
ORDER BY
  b0_.position ASC
LIMIT
  5

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.position AS position_2, b0_.slug AS slug_3, b0_.photo AS photo_4, b0_.banner AS banner_5, b0_.brief AS brief_6, b0_.content AS content_7, b0_.seo_title AS seo_title_8, b0_.seo_desc AS seo_desc_9, b0_.bgbanner AS bgbanner_10, b0_.published AS published_11 FROM business b0_ WHERE b0_.published = 1 ORDER BY b0_.position ASC LIMIT 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.section AS section_4,
  t0.type AS type_5
FROM
  setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.section AS section_4, t0.type AS type_5 FROM setting t0 WHERE t0.name = 'website_name' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.section AS section_4,
  t0.type AS type_5
FROM
  setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.section AS section_4, t0.type AS type_5 FROM setting t0 WHERE t0.name = 'google_analytic_embed' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.section AS section_4,
  t0.type AS type_5
FROM
  setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.section AS section_4, t0.type AS type_5 FROM setting t0 WHERE t0.name = 'tagline_text' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.section AS section_4,
  t0.type AS type_5
FROM
  setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.section AS section_4, t0.type AS type_5 FROM setting t0 WHERE t0.name = 'tagline' LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m1_.id AS id_2,
  m1_.name AS name_3,
  m1_.position AS position_4,
  m1_.url AS url_5,
  m2_.id AS id_6,
  m2_.name AS name_7,
  m2_.position AS position_8,
  m2_.url AS url_9,
  p3_.id AS id_10,
  p3_.title AS title_11,
  p3_.thumbnail AS thumbnail_12,
  p3_.seo_title AS seo_title_13,
  p3_.slug AS slug_14,
  p3_.brief AS brief_15,
  p3_.content AS content_16,
  p3_.created_at AS created_at_17,
  p3_.updated_at AS updated_at_18,
  p4_.id AS id_19,
  p4_.title AS title_20,
  p4_.thumbnail AS thumbnail_21,
  p4_.seo_title AS seo_title_22,
  p4_.slug AS slug_23,
  p4_.brief AS brief_24,
  p4_.content AS content_25,
  p4_.created_at AS created_at_26,
  p4_.updated_at AS updated_at_27,
  m1_.menu_id AS menu_id_28,
  m1_.parent_id AS parent_id_29,
  m1_.page_id AS page_id_30,
  m2_.menu_id AS menu_id_31,
  m2_.parent_id AS parent_id_32,
  m2_.page_id AS page_id_33
FROM
  menu m0_
  LEFT JOIN menu_item m1_ ON m0_.id = m1_.menu_id
  LEFT JOIN menu_item m2_ ON m1_.id = m2_.parent_id
  LEFT JOIN page p3_ ON m1_.page_id = p3_.id
  LEFT JOIN page p4_ ON m2_.page_id = p4_.id
WHERE
  m0_.name = ?
ORDER BY
  m1_.position ASC,
  m2_.position ASC

SELECT m0_.id AS id_0, m0_.name AS name_1, m1_.id AS id_2, m1_.name AS name_3, m1_.position AS position_4, m1_.url AS url_5, m2_.id AS id_6, m2_.name AS name_7, m2_.position AS position_8, m2_.url AS url_9, p3_.id AS id_10, p3_.title AS title_11, p3_.thumbnail AS thumbnail_12, p3_.seo_title AS seo_title_13, p3_.slug AS slug_14, p3_.brief AS brief_15, p3_.content AS content_16, p3_.created_at AS created_at_17, p3_.updated_at AS updated_at_18, p4_.id AS id_19, p4_.title AS title_20, p4_.thumbnail AS thumbnail_21, p4_.seo_title AS seo_title_22, p4_.slug AS slug_23, p4_.brief AS brief_24, p4_.content AS content_25, p4_.created_at AS created_at_26, p4_.updated_at AS updated_at_27, m1_.menu_id AS menu_id_28, m1_.parent_id AS parent_id_29, m1_.page_id AS page_id_30, m2_.menu_id AS menu_id_31, m2_.parent_id AS parent_id_32, m2_.page_id AS page_id_33 FROM menu m0_ LEFT JOIN menu_item m1_ ON m0_.id = m1_.menu_id LEFT JOIN menu_item m2_ ON m1_.id = m2_.parent_id LEFT JOIN page p3_ ON m1_.page_id = p3_.id LEFT JOIN page p4_ ON m2_.page_id = p4_.id WHERE m0_.name = 'Header' ORDER BY m1_.position ASC, m2_.position ASC;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.data AS data_3,
  t0.position AS position_4,
  t0.page_id AS page_id_5
FROM
  section t0
WHERE
  t0.page_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.data AS data_3, t0.position AS position_4, t0.page_id AS page_id_5 FROM section t0 WHERE t0.page_id = 8 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.country_name AS country_name_5,
  t0.zip_code AS zip_code_6,
  t0.phone AS phone_7,
  t0.email AS email_8,
  t0.address AS address_9,
  t0.published AS published_10
FROM
  location t0
WHERE
  t0.published = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.country_name AS country_name_5, t0.zip_code AS zip_code_6, t0.phone AS phone_7, t0.email AS email_8, t0.address AS address_9, t0.published AS published_10 FROM location t0 WHERE t0.published = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.country_name AS country_name_5,
  t0.zip_code AS zip_code_6,
  t0.phone AS phone_7,
  t0.email AS email_8,
  t0.address AS address_9,
  t0.published AS published_10
FROM
  location t0
WHERE
  t0.published = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.country_name AS country_name_5, t0.zip_code AS zip_code_6, t0.phone AS phone_7, t0.email AS email_8, t0.address AS address_9, t0.published AS published_10 FROM location t0 WHERE t0.published = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.basic_info AS basic_info_3,
  t0.position AS position_4,
  t0.image AS image_5,
  t0.created_at AS created_at_6,
  t0.published AS published_7
FROM
  team_member t0
WHERE
  t0.published = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.basic_info AS basic_info_3, t0.position AS position_4, t0.image AS image_5, t0.created_at AS created_at_6, t0.published AS published_7 FROM team_member t0 WHERE t0.published = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.logo AS logo_4,
  t0.website AS website_5,
  t0.email AS email_6,
  t0.created_at AS created_at_7,
  t0.published AS published_8
FROM
  partner t0
WHERE
  t0.published = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.logo AS logo_4, t0.website AS website_5, t0.email AS email_6, t0.created_at AS created_at_7, t0.published AS published_8 FROM partner t0 WHERE t0.published = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.section AS section_4,
  t0.type AS type_5
FROM
  setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.section AS section_4, t0.type AS type_5 FROM setting t0 WHERE t0.name = 'business_footer_photo' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.section AS section_4,
  t0.type AS type_5
FROM
  setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.section AS section_4, t0.type AS type_5 FROM setting t0 WHERE t0.name = 'business_footer_title' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.section AS section_4,
  t0.type AS type_5
FROM
  setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.section AS section_4, t0.type AS type_5 FROM setting t0 WHERE t0.name = 'business_footer_description' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.section AS section_4,
  t0.type AS type_5
FROM
  setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.section AS section_4, t0.type AS type_5 FROM setting t0 WHERE t0.name = 'calculate_my_financial_aid_text' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.section AS section_4,
  t0.type AS type_5
FROM
  setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.section AS section_4, t0.type AS type_5 FROM setting t0 WHERE t0.name = 'simulate_the_impact_on_my_DPE_text' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.section AS section_4,
  t0.type AS type_5
FROM
  setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.section AS section_4, t0.type AS type_5 FROM setting t0 WHERE t0.name = 'calculate_my_financial_aid' LIMIT 1;