Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.modified AS modified_4,
  t0.label AS label_5,
  t0.url AS url_6,
  t0.auto_update AS auto_update_7,
  t0.open_new_window AS open_new_window_8,
  t0.display_order AS display_order_9,
  t0.type AS type_10,
  t0.menu_id AS menu_id_11,
  t0.page_id AS page_id_12,
  t0.parent_id AS parent_id_13
FROM
  content_menus_menuitem t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.display_order ASC

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.modified AS modified_4, t0.label AS label_5, t0.url AS url_6, t0.auto_update AS auto_update_7, t0.open_new_window AS open_new_window_8, t0.display_order AS display_order_9, t0.type AS type_10, t0.menu_id AS menu_id_11, t0.page_id AS page_id_12, t0.parent_id AS parent_id_13 FROM content_menus_menuitem t0 WHERE t0.parent_id = 17 ORDER BY t0.display_order ASC;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.name AS name_4,
  t0.content AS content_5,
  t0.slug AS slug_6,
  t0.path AS path_7,
  t0.primary_image AS primary_image_8,
  t0.seo_page_title AS seo_page_title_9,
  t0.seo_description AS seo_description_10,
  t0.seo_keywords AS seo_keywords_11,
  t0.html_head AS html_head_12,
  t0.display_order AS display_order_13,
  t0.parent_id AS parent_id_14,
  t0.region_id AS region_id_15,
  t0.trainer_id AS trainer_id_16
FROM
  content_pages_page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.content AS content_5, t0.slug AS slug_6, t0.path AS path_7, t0.primary_image AS primary_image_8, t0.seo_page_title AS seo_page_title_9, t0.seo_description AS seo_description_10, t0.seo_keywords AS seo_keywords_11, t0.html_head AS html_head_12, t0.display_order AS display_order_13, t0.parent_id AS parent_id_14, t0.region_id AS region_id_15, t0.trainer_id AS trainer_id_16 FROM content_pages_page t0 WHERE t0.id = 4;

SELECT
  c0_.id AS id_0,
  c0_.uuid AS uuid_1,
  c0_.created AS created_2,
  c0_.modified AS modified_3,
  c0_.identifier AS identifier_4,
  c0_.name AS name_5,
  c0_.is_locked AS is_locked_6,
  c0_.disable_child_items AS disable_child_items_7
FROM
  content_menus_menu c0_
WHERE
  c0_.identifier = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.modified AS modified_3, c0_.identifier AS identifier_4, c0_.name AS name_5, c0_.is_locked AS is_locked_6, c0_.disable_child_items AS disable_child_items_7 FROM content_menus_menu c0_ WHERE c0_.identifier = 'primary' LIMIT 1;

SELECT
  r0_.id AS id_0,
  r0_.uuid AS uuid_1,
  r0_.created AS created_2,
  r0_.enabled AS enabled_3,
  r0_.name AS name_4,
  r0_.image AS image_5,
  r0_.heading AS heading_6,
  r0_.slug AS slug_7,
  r0_.for_sale_slug AS for_sale_slug_8,
  r0_.path AS path_9,
  r0_.description AS description_10,
  r0_.schema_description AS schema_description_11,
  r0_.for_sale_description AS for_sale_description_12,
  r0_.for_sale_seo_page_title AS for_sale_seo_page_title_13,
  r0_.for_sale_seo_page_description AS for_sale_seo_page_description_14,
  r0_.for_sale_seo_page_keywords AS for_sale_seo_page_keywords_15,
  r0_.for_sale_html_head AS for_sale_html_head_16,
  r0_.seo_page_title AS seo_page_title_17,
  r0_.seo_page_description AS seo_page_description_18,
  r0_.seo_page_keywords AS seo_page_keywords_19,
  r0_.html_head AS html_head_20,
  r0_.parent_id AS parent_id_21,
  r0_.trainer_id AS trainer_id_22,
  r0_.website_enquiry_booking_centre_id AS website_enquiry_booking_centre_id_23
FROM
  regions_region r0_
  LEFT JOIN trainers_trainerregion t1_ ON r0_.id = t1_.region_id
WHERE
  r0_.slug = ?
  AND r0_.enabled = ?
LIMIT
  1

SELECT r0_.id AS id_0, r0_.uuid AS uuid_1, r0_.created AS created_2, r0_.enabled AS enabled_3, r0_.name AS name_4, r0_.image AS image_5, r0_.heading AS heading_6, r0_.slug AS slug_7, r0_.for_sale_slug AS for_sale_slug_8, r0_.path AS path_9, r0_.description AS description_10, r0_.schema_description AS schema_description_11, r0_.for_sale_description AS for_sale_description_12, r0_.for_sale_seo_page_title AS for_sale_seo_page_title_13, r0_.for_sale_seo_page_description AS for_sale_seo_page_description_14, r0_.for_sale_seo_page_keywords AS for_sale_seo_page_keywords_15, r0_.for_sale_html_head AS for_sale_html_head_16, r0_.seo_page_title AS seo_page_title_17, r0_.seo_page_description AS seo_page_description_18, r0_.seo_page_keywords AS seo_page_keywords_19, r0_.html_head AS html_head_20, r0_.parent_id AS parent_id_21, r0_.trainer_id AS trainer_id_22, r0_.website_enquiry_booking_centre_id AS website_enquiry_booking_centre_id_23 FROM regions_region r0_ LEFT JOIN trainers_trainerregion t1_ ON r0_.id = t1_.region_id WHERE r0_.slug = 'dog-breed/chihuahua' AND r0_.enabled = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.modified AS modified_4,
  t0.label AS label_5,
  t0.url AS url_6,
  t0.auto_update AS auto_update_7,
  t0.open_new_window AS open_new_window_8,
  t0.display_order AS display_order_9,
  t0.type AS type_10,
  t0.menu_id AS menu_id_11,
  t0.page_id AS page_id_12,
  t0.parent_id AS parent_id_13
FROM
  content_menus_menuitem t0
WHERE
  t0.menu_id = ?
ORDER BY
  t0.display_order ASC

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.modified AS modified_4, t0.label AS label_5, t0.url AS url_6, t0.auto_update AS auto_update_7, t0.open_new_window AS open_new_window_8, t0.display_order AS display_order_9, t0.type AS type_10, t0.menu_id AS menu_id_11, t0.page_id AS page_id_12, t0.parent_id AS parent_id_13 FROM content_menus_menuitem t0 WHERE t0.menu_id = 5 ORDER BY t0.display_order ASC;

SELECT
  d0_.id AS id_0,
  d0_.uuid AS uuid_1,
  d0_.created AS created_2,
  d0_.name AS name_3,
  d0_.slug AS slug_4,
  d0_.featured_item_id AS featured_item_id_5
FROM
  dynamiccontent_type d0_
WHERE
  d0_.slug = ?
LIMIT
  1

SELECT d0_.id AS id_0, d0_.uuid AS uuid_1, d0_.created AS created_2, d0_.name AS name_3, d0_.slug AS slug_4, d0_.featured_item_id AS featured_item_id_5 FROM dynamiccontent_type d0_ WHERE d0_.slug = 'dog-breed' LIMIT 1;

SELECT
  d0_.id AS id_0,
  d0_.uuid AS uuid_1,
  d0_.created AS created_2,
  d0_.title AS title_3,
  d0_.content AS content_4,
  d0_.image AS image_5,
  d0_.display_order AS display_order_6,
  d0_.item_id AS item_id_7
FROM
  dynamiccontent_section d0_
WHERE
  d0_.item_id = ?
ORDER BY
  d0_.display_order ASC

SELECT d0_.id AS id_0, d0_.uuid AS uuid_1, d0_.created AS created_2, d0_.title AS title_3, d0_.content AS content_4, d0_.image AS image_5, d0_.display_order AS display_order_6, d0_.item_id AS item_id_7 FROM dynamiccontent_section d0_ WHERE d0_.item_id = 13 ORDER BY d0_.display_order ASC;

SELECT
  c0_.id AS id_0,
  c0_.uuid AS uuid_1,
  c0_.created AS created_2,
  c0_.name AS name_3,
  c0_.content AS content_4,
  c0_.slug AS slug_5,
  c0_.path AS path_6,
  c0_.primary_image AS primary_image_7,
  c0_.seo_page_title AS seo_page_title_8,
  c0_.seo_description AS seo_description_9,
  c0_.seo_keywords AS seo_keywords_10,
  c0_.html_head AS html_head_11,
  c0_.display_order AS display_order_12,
  c0_.parent_id AS parent_id_13,
  c0_.region_id AS region_id_14,
  c0_.trainer_id AS trainer_id_15
FROM
  content_pages_page c0_
WHERE
  c0_.path = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.name AS name_3, c0_.content AS content_4, c0_.slug AS slug_5, c0_.path AS path_6, c0_.primary_image AS primary_image_7, c0_.seo_page_title AS seo_page_title_8, c0_.seo_description AS seo_description_9, c0_.seo_keywords AS seo_keywords_10, c0_.html_head AS html_head_11, c0_.display_order AS display_order_12, c0_.parent_id AS parent_id_13, c0_.region_id AS region_id_14, c0_.trainer_id AS trainer_id_15 FROM content_pages_page c0_ WHERE c0_.path = 'dog-breed/chihuahua' LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.uuid AS uuid_1,
  t0_.created AS created_2,
  t0_.name AS name_3,
  t0_.contact_name AS contact_name_4,
  t0_.image AS image_5,
  t0_.banner_image AS banner_image_6,
  t0_.banner AS banner_7,
  t0_.description AS description_8,
  t0_.schema_description AS schema_description_9,
  t0_.statement AS statement_10,
  t0_.freephone_notes AS freephone_notes_11,
  t0_.slug AS slug_12,
  t0_.email AS email_13,
  t0_.phone_number AS phone_number_14,
  t0_.seo_page_title AS seo_page_title_15,
  t0_.seo_page_description AS seo_page_description_16,
  t0_.seo_page_keywords AS seo_page_keywords_17,
  t0_.html_head AS html_head_18,
  t0_.trust_pilot_profile_code AS trust_pilot_profile_code_19,
  t0_.average_rating AS average_rating_20,
  t0_.high_score_ratings AS high_score_ratings_21,
  t0_.dog_responded_ratings AS dog_responded_ratings_22,
  t0_.recommended_ratings AS recommended_ratings_23,
  t0_.review_count AS review_count_24,
  t0_.accepts_credit_cards AS accepts_credit_cards_25,
  t0_.intrexx_user_id AS intrexx_user_id_26,
  t0_.first_aider AS first_aider_27,
  t0_.quiz_email_text AS quiz_email_text_28,
  t0_.google_place_id AS google_place_id_29,
  t0_.booking_centre_id AS booking_centre_id_30
FROM
  trainers_trainer t0_
  LEFT JOIN trainers_trainerregion t1_ ON t0_.id = t1_.trainer_id
WHERE
  t0_.slug = ?
LIMIT
  1

SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.created AS created_2, t0_.name AS name_3, t0_.contact_name AS contact_name_4, t0_.image AS image_5, t0_.banner_image AS banner_image_6, t0_.banner AS banner_7, t0_.description AS description_8, t0_.schema_description AS schema_description_9, t0_.statement AS statement_10, t0_.freephone_notes AS freephone_notes_11, t0_.slug AS slug_12, t0_.email AS email_13, t0_.phone_number AS phone_number_14, t0_.seo_page_title AS seo_page_title_15, t0_.seo_page_description AS seo_page_description_16, t0_.seo_page_keywords AS seo_page_keywords_17, t0_.html_head AS html_head_18, t0_.trust_pilot_profile_code AS trust_pilot_profile_code_19, t0_.average_rating AS average_rating_20, t0_.high_score_ratings AS high_score_ratings_21, t0_.dog_responded_ratings AS dog_responded_ratings_22, t0_.recommended_ratings AS recommended_ratings_23, t0_.review_count AS review_count_24, t0_.accepts_credit_cards AS accepts_credit_cards_25, t0_.intrexx_user_id AS intrexx_user_id_26, t0_.first_aider AS first_aider_27, t0_.quiz_email_text AS quiz_email_text_28, t0_.google_place_id AS google_place_id_29, t0_.booking_centre_id AS booking_centre_id_30 FROM trainers_trainer t0_ LEFT JOIN trainers_trainerregion t1_ ON t0_.id = t1_.trainer_id WHERE t0_.slug = 'dog-breed/chihuahua' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.`key` AS key_4,
  t0.value AS value_5
FROM
  system_config t0

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.`key` AS key_4, t0.value AS value_5 FROM system_config t0;

SELECT
  d0_.id AS id_0,
  d0_.uuid AS uuid_1,
  d0_.created AS created_2,
  d0_.title AS title_3,
  d0_.description AS description_4,
  d0_.image AS image_5,
  d0_.slug AS slug_6,
  d0_.display_order AS display_order_7,
  d0_.seo_page_title AS seo_page_title_8,
  d0_.seo_page_description AS seo_page_description_9,
  d0_.seo_page_keywords AS seo_page_keywords_10,
  d0_.html_head AS html_head_11,
  d0_.schema_description AS schema_description_12,
  d0_.date AS date_13,
  d0_.type_id AS type_id_14
FROM
  dynamiccontent_item d0_
WHERE
  d0_.type_id = ?
  AND d0_.slug = ?
LIMIT
  1

SELECT d0_.id AS id_0, d0_.uuid AS uuid_1, d0_.created AS created_2, d0_.title AS title_3, d0_.description AS description_4, d0_.image AS image_5, d0_.slug AS slug_6, d0_.display_order AS display_order_7, d0_.seo_page_title AS seo_page_title_8, d0_.seo_page_description AS seo_page_description_9, d0_.seo_page_keywords AS seo_page_keywords_10, d0_.html_head AS html_head_11, d0_.schema_description AS schema_description_12, d0_.date AS date_13, d0_.type_id AS type_id_14 FROM dynamiccontent_item d0_ WHERE d0_.type_id = 1 AND d0_.slug = 'chihuahua' LIMIT 1;

SELECT
  d0_.id AS id_0,
  d0_.uuid AS uuid_1,
  d0_.created AS created_2,
  d0_.title AS title_3,
  d0_.description AS description_4,
  d0_.image AS image_5,
  d0_.slug AS slug_6,
  d0_.display_order AS display_order_7,
  d0_.seo_page_title AS seo_page_title_8,
  d0_.seo_page_description AS seo_page_description_9,
  d0_.seo_page_keywords AS seo_page_keywords_10,
  d0_.html_head AS html_head_11,
  d0_.schema_description AS schema_description_12,
  d0_.date AS date_13,
  d0_.type_id AS type_id_14
FROM
  dynamiccontent_item d0_
WHERE
  d0_.slug = ?
LIMIT
  1

SELECT d0_.id AS id_0, d0_.uuid AS uuid_1, d0_.created AS created_2, d0_.title AS title_3, d0_.description AS description_4, d0_.image AS image_5, d0_.slug AS slug_6, d0_.display_order AS display_order_7, d0_.seo_page_title AS seo_page_title_8, d0_.seo_page_description AS seo_page_description_9, d0_.seo_page_keywords AS seo_page_keywords_10, d0_.html_head AS html_head_11, d0_.schema_description AS schema_description_12, d0_.date AS date_13, d0_.type_id AS type_id_14 FROM dynamiccontent_item d0_ WHERE d0_.slug = 'chihuahua' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.uuid AS uuid_1,
  s0_.created AS created_2,
  s0_.name AS name_3,
  s0_.description AS description_4,
  s0_.slug AS slug_5,
  s0_.image AS image_6,
  s0_.seo_page_title AS seo_page_title_7,
  s0_.seo_page_description AS seo_page_description_8,
  s0_.seo_page_keywords AS seo_page_keywords_9,
  s0_.html_head AS html_head_10
FROM
  services_service s0_
WHERE
  s0_.slug = ?
LIMIT
  1

SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.created AS created_2, s0_.name AS name_3, s0_.description AS description_4, s0_.slug AS slug_5, s0_.image AS image_6, s0_.seo_page_title AS seo_page_title_7, s0_.seo_page_description AS seo_page_description_8, s0_.seo_page_keywords AS seo_page_keywords_9, s0_.html_head AS html_head_10 FROM services_service s0_ WHERE s0_.slug = 'dog-breed/chihuahua' LIMIT 1;