Query Metrics
98
Database Queries
20
Different statements
46.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
14.94 ms (32.21%) |
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.44 ms (22.51%) |
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.14 ms (4.62%) |
3 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.enabled AS enabled_4, t0.name AS name_5, t0.image AS image_6, t0.heading AS heading_7, t0.slug AS slug_8, t0.for_sale_slug AS for_sale_slug_9, t0.path AS path_10, t0.description AS description_11, t0.schema_description AS schema_description_12, t0.for_sale_description AS for_sale_description_13, t0.for_sale_seo_page_title AS for_sale_seo_page_title_14, t0.for_sale_seo_page_description AS for_sale_seo_page_description_15, t0.for_sale_seo_page_keywords AS for_sale_seo_page_keywords_16, t0.for_sale_html_head AS for_sale_html_head_17, t0.seo_page_title AS seo_page_title_18, t0.seo_page_description AS seo_page_description_19, t0.seo_page_keywords AS seo_page_keywords_20, t0.html_head AS html_head_21, t0.parent_id AS parent_id_22, t0.trainer_id AS trainer_id_23, t0.website_enquiry_booking_centre_id AS website_enquiry_booking_centre_id_24, t25.id AS id_26, t25.uuid AS uuid_27, t25.created AS created_28, t25.name AS name_29, t25.content AS content_30, t25.slug AS slug_31, t25.path AS path_32, t25.primary_image AS primary_image_33, t25.seo_page_title AS seo_page_title_34, t25.seo_description AS seo_description_35, t25.seo_keywords AS seo_keywords_36, t25.html_head AS html_head_37, t25.display_order AS display_order_38, t25.parent_id AS parent_id_39, t25.region_id AS region_id_40, t25.trainer_id AS trainer_id_41 FROM regions_region t0 LEFT JOIN content_pages_page t25 ON t25.region_id = t0.id WHERE t0.id = ?
Parameters:
[
161
]
|
|
2.08 ms (4.49%) |
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
Parameters:
[ "gina-williams" 1 ] |
|
1.99 ms (4.30%) |
1 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"bbuk"
]
|
|
1.86 ms (4.00%) |
5 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4 FROM reviews_issue t0 INNER JOIN review_issue ON t0.id = review_issue.issue_id WHERE review_issue.review_id = ?
Parameters:
[
19507
]
|
|
1.84 ms (3.97%) |
1 |
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_.trainer_id = ? AND r0_.opt_post_to_website = ? AND r0_.status = ? AND r0_.featured IS NOT NULL ORDER BY r0_.created DESC LIMIT 5
Parameters:
[ 84 1 3 ] |
|
1.67 ms (3.61%) |
2 |
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:
[
"gina-williams"
]
|
|
1.47 ms (3.17%) |
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.39 ms (3.00%) |
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.38 ms (2.97%) |
5 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.file AS file_4, t0.review_id AS review_id_5 FROM reviews_image t0 WHERE t0.review_id = ?
Parameters:
[
19507
]
|
|
0.96 ms (2.08%) |
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
Parameters:
[
"gina-williams"
]
|
|
0.83 ms (1.79%) |
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.60 ms (1.30%) |
1 |
SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.created AS created_2, t0_.trainer_id AS trainer_id_3, t0_.region_id AS region_id_4 FROM trainers_trainerregion t0_ LEFT JOIN regions_region r1_ ON t0_.region_id = r1_.id WHERE t0_.trainer_id = ? ORDER BY r1_.name ASC
Parameters:
[
84
]
|
|
0.58 ms (1.25%) |
1 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.email AS email_5, t0.phone AS phone_6 FROM trainers_bookingcentre t0 WHERE t0.id = ?
Parameters:
[
902
]
|
|
0.54 ms (1.16%) |
1 |
SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.created AS created_2, t0_.thumbnail AS thumbnail_3, t0_.filename AS filename_4, t0_.type AS type_5, t0_.trainer_id AS trainer_id_6 FROM trainers_media t0_ WHERE t0_.trainer_id = ? ORDER BY t0_.created ASC
Parameters:
[
84
]
|
|
0.50 ms (1.09%) |
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:
[
84
]
|
|
0.41 ms (0.89%) |
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_.trainer_id = ? LIMIT 1
Parameters:
[
84
]
|
|
0.38 ms (0.83%) |
1 |
SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.created AS created_2, t0_.trainer_id AS trainer_id_3, t0_.service_id AS service_id_4 FROM trainers_trainerservice t0_ WHERE t0_.trainer_id = ?
Parameters:
[
84
]
|
|
0.35 ms (0.76%) |
2 |
SELECT DATABASE()
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\System\Config | No errors. |
| App\Entity\Content\Pages\Page | No errors. |
| App\Entity\Regions\Region | No errors. |
| App\Entity\Trainers\Trainer | No errors. |
| App\Entity\Trainers\TrainerRegion | No errors. |
| App\Entity\Trainers\BookingCentre | No errors. |
| App\Entity\Trainers\Media | No errors. |
| App\Entity\Trainers\TrainerService | No errors. |
| App\Entity\Reviews\Review | No errors. |
| App\Entity\PreLessonQuestionnaire\Question | No errors. |
| App\Entity\PreLessonQuestionnaire\Response | No errors. |
| App\Entity\Quiz\Response | No errors. |
| App\Entity\Services\Service | No errors. |
| App\Entity\Reviews\Issue | No errors. |
| App\Entity\Reviews\Image | No errors. |
| App\Entity\Regions\Postcode | No errors. |
| App\Entity\Regions\Town | No errors. |
| App\Entity\Content\Menus\Menu | No errors. |
| App\Entity\Content\Menus\MenuItem | No errors. |
| App\Entity\Content\Pages\Block | No errors. |
| App\Entity\PreLessonQuestionnaire\Answer | No errors. |