GET https://bb-uk.penguin-dev.co.uk/alex-fraser/submit_trainer_review

Query Metrics

74 Database Queries
8 Different statements
34.58 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
16.28 ms
(47.08%)
38
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
Parameters:
[
  17
]
10.17 ms
(29.42%)
24
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 = ?
Parameters:
[
  4
]
2.51 ms
(7.25%)
5
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
Parameters:
[
  "primary"
]
1.82 ms
(5.27%)
3
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
Parameters:
[
  5
]
1.47 ms
(4.24%)
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
Parameters:
[
  "alex-fraser"
]
1.04 ms
(3.01%)
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
Parameters:
[]
0.65 ms
(1.87%)
1
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.trainer_id = ?
Parameters:
[
  79
]
0.64 ms
(1.85%)
1
SELECT r0_.id AS id_0, r0_.uuid AS uuid_1, r0_.created AS created_2, r0_.name AS name_3 FROM reviews_issue r0_
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.