Symfony Profiler

SELECT
  AVG(r0_.feedback_experience_rating) AS sclr_0
FROM
  reviews_review r0_
WHERE
  r0_.status IN (2, 3, 4)

SELECT AVG(r0_.feedback_experience_rating) AS sclr_0 FROM reviews_review r0_ WHERE r0_.status IN (2, 3, 4);

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
  r0_.id AS id_0,
  r0_.uuid AS uuid_1,
  r0_.created AS created_2,
  r0_.featured AS featured_3,
  r0_.first_names AS first_names_4,
  r0_.surname AS surname_5,
  r0_.town AS town_6,
  r0_.postcode AS postcode_7,
  r0_.county AS county_8,
  r0_.email AS email_9,
  r0_.dog_name AS dog_name_10,
  r0_.receipt_number AS receipt_number_11,
  r0_.first_lesson_date AS first_lesson_date_12,
  r0_.comments AS comments_13,
  r0_.trainer_comments AS trainer_comments_14,
  r0_.feedback_everything_explained AS feedback_everything_explained_15,
  r0_.feedback_problems_worked_on AS feedback_problems_worked_on_16,
  r0_.feedback_techniques_used AS feedback_techniques_used_17,
  r0_.feedback_dog_responded AS feedback_dog_responded_18,
  r0_.feedback_would_recommend AS feedback_would_recommend_19,
  r0_.feedback_experience_rating AS feedback_experience_rating_20,
  r0_.feedback_value_for_money_rating AS feedback_value_for_money_rating_21,
  r0_.opt_post_to_website AS opt_post_to_website_22,
  r0_.opt_forward_trustpilot AS opt_forward_trustpilot_23,
  r0_.opt_forward_vet AS opt_forward_vet_24,
  r0_.vet_name AS vet_name_25,
  r0_.vet_address AS vet_address_26,
  r0_.rescue_name AS rescue_name_27,
  r0_.rescue_address AS rescue_address_28,
  r0_.status AS status_29,
  r0_.customer_id AS customer_id_30,
  r0_.Processed AS Processed_31,
  r0_.trainer_id AS trainer_id_32
FROM
  reviews_review r0_
WHERE
  r0_.status = ?
  AND r0_.opt_post_to_website = ?
  AND r0_.feedback_experience_rating >= ?
ORDER BY
  r0_.created DESC
LIMIT
  20

SELECT r0_.id AS id_0, r0_.uuid AS uuid_1, r0_.created AS created_2, r0_.featured AS featured_3, r0_.first_names AS first_names_4, r0_.surname AS surname_5, r0_.town AS town_6, r0_.postcode AS postcode_7, r0_.county AS county_8, r0_.email AS email_9, r0_.dog_name AS dog_name_10, r0_.receipt_number AS receipt_number_11, r0_.first_lesson_date AS first_lesson_date_12, r0_.comments AS comments_13, r0_.trainer_comments AS trainer_comments_14, r0_.feedback_everything_explained AS feedback_everything_explained_15, r0_.feedback_problems_worked_on AS feedback_problems_worked_on_16, r0_.feedback_techniques_used AS feedback_techniques_used_17, r0_.feedback_dog_responded AS feedback_dog_responded_18, r0_.feedback_would_recommend AS feedback_would_recommend_19, r0_.feedback_experience_rating AS feedback_experience_rating_20, r0_.feedback_value_for_money_rating AS feedback_value_for_money_rating_21, r0_.opt_post_to_website AS opt_post_to_website_22, r0_.opt_forward_trustpilot AS opt_forward_trustpilot_23, r0_.opt_forward_vet AS opt_forward_vet_24, r0_.vet_name AS vet_name_25, r0_.vet_address AS vet_address_26, r0_.rescue_name AS rescue_name_27, r0_.rescue_address AS rescue_address_28, r0_.status AS status_29, r0_.customer_id AS customer_id_30, r0_.Processed AS Processed_31, r0_.trainer_id AS trainer_id_32 FROM reviews_review r0_ WHERE r0_.status = 3 AND r0_.opt_post_to_website = 1 AND r0_.feedback_experience_rating >= '4' ORDER BY r0_.created DESC LIMIT 20;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.name AS name_4,
  t0.contact_name AS contact_name_5,
  t0.image AS image_6,
  t0.banner_image AS banner_image_7,
  t0.banner AS banner_8,
  t0.description AS description_9,
  t0.schema_description AS schema_description_10,
  t0.statement AS statement_11,
  t0.freephone_notes AS freephone_notes_12,
  t0.slug AS slug_13,
  t0.email AS email_14,
  t0.phone_number AS phone_number_15,
  t0.seo_page_title AS seo_page_title_16,
  t0.seo_page_description AS seo_page_description_17,
  t0.seo_page_keywords AS seo_page_keywords_18,
  t0.html_head AS html_head_19,
  t0.trust_pilot_profile_code AS trust_pilot_profile_code_20,
  t0.average_rating AS average_rating_21,
  t0.high_score_ratings AS high_score_ratings_22,
  t0.dog_responded_ratings AS dog_responded_ratings_23,
  t0.recommended_ratings AS recommended_ratings_24,
  t0.review_count AS review_count_25,
  t0.accepts_credit_cards AS accepts_credit_cards_26,
  t0.intrexx_user_id AS intrexx_user_id_27,
  t0.first_aider AS first_aider_28,
  t0.quiz_email_text AS quiz_email_text_29,
  t0.google_place_id AS google_place_id_30,
  t0.booking_centre_id AS booking_centre_id_31,
  t32.id AS id_33,
  t32.uuid AS uuid_34,
  t32.created AS created_35,
  t32.name AS name_36,
  t32.content AS content_37,
  t32.slug AS slug_38,
  t32.path AS path_39,
  t32.primary_image AS primary_image_40,
  t32.seo_page_title AS seo_page_title_41,
  t32.seo_description AS seo_description_42,
  t32.seo_keywords AS seo_keywords_43,
  t32.html_head AS html_head_44,
  t32.display_order AS display_order_45,
  t32.parent_id AS parent_id_46,
  t32.region_id AS region_id_47,
  t32.trainer_id AS trainer_id_48
FROM
  trainers_trainer t0
  LEFT JOIN content_pages_page t32 ON t32.trainer_id = t0.id
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.contact_name AS contact_name_5, t0.image AS image_6, t0.banner_image AS banner_image_7, t0.banner AS banner_8, t0.description AS description_9, t0.schema_description AS schema_description_10, t0.statement AS statement_11, t0.freephone_notes AS freephone_notes_12, t0.slug AS slug_13, t0.email AS email_14, t0.phone_number AS phone_number_15, t0.seo_page_title AS seo_page_title_16, t0.seo_page_description AS seo_page_description_17, t0.seo_page_keywords AS seo_page_keywords_18, t0.html_head AS html_head_19, t0.trust_pilot_profile_code AS trust_pilot_profile_code_20, t0.average_rating AS average_rating_21, t0.high_score_ratings AS high_score_ratings_22, t0.dog_responded_ratings AS dog_responded_ratings_23, t0.recommended_ratings AS recommended_ratings_24, t0.review_count AS review_count_25, t0.accepts_credit_cards AS accepts_credit_cards_26, t0.intrexx_user_id AS intrexx_user_id_27, t0.first_aider AS first_aider_28, t0.quiz_email_text AS quiz_email_text_29, t0.google_place_id AS google_place_id_30, t0.booking_centre_id AS booking_centre_id_31, t32.id AS id_33, t32.uuid AS uuid_34, t32.created AS created_35, t32.name AS name_36, t32.content AS content_37, t32.slug AS slug_38, t32.path AS path_39, t32.primary_image AS primary_image_40, t32.seo_page_title AS seo_page_title_41, t32.seo_description AS seo_description_42, t32.seo_keywords AS seo_keywords_43, t32.html_head AS html_head_44, t32.display_order AS display_order_45, t32.parent_id AS parent_id_46, t32.region_id AS region_id_47, t32.trainer_id AS trainer_id_48 FROM trainers_trainer t0 LEFT JOIN content_pages_page t32 ON t32.trainer_id = t0.id WHERE t0.id = 79;

SELECT
  c0_.id AS id_0,
  c0_.uuid AS uuid_1,
  c0_.created AS created_2,
  c0_.block_name AS block_name_3,
  c0_.is_visible AS is_visible_4,
  c0_.data AS data_5,
  c0_.page_id AS page_id_6
FROM
  content_pages_block c0_
WHERE
  c0_.id = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.block_name AS block_name_3, c0_.is_visible AS is_visible_4, c0_.data AS data_5, c0_.page_id AS page_id_6 FROM content_pages_block c0_ WHERE c0_.id = 365 LIMIT 1;

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  reviews_review r0_
WHERE
  r0_.status IN (?, ?, ?)

SELECT COUNT(r0_.id) AS sclr_0 FROM reviews_review r0_ WHERE r0_.status IN (2, 3, 4);

SELECT
  c0_.id AS id_0,
  c0_.uuid AS uuid_1,
  c0_.created AS created_2,
  c0_.tag AS tag_3,
  c0_.replacement AS replacement_4
FROM
  content_tags_tag c0_

SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.tag AS tag_3, c0_.replacement AS replacement_4 FROM content_tags_tag c0_;

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
  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-training' 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
  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;