Query Metrics
7
Database Queries
7
Different statements
10.00 ms
Query time
3
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
2.61 ms (26.06%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_published AS is_published_3, t0.theme AS theme_4, t0.theme_color AS theme_color_5, t0.modules AS modules_6, t0.header_logo AS header_logo_7, t0.footer_logo AS footer_logo_8, t0.facebook_url AS facebook_url_9, t0.facebook_id AS facebook_id_10, t0.twitter_url AS twitter_url_11, t0.twitter_username AS twitter_username_12, t0.linkedin_url AS linkedin_url_13, t0.youtube_url AS youtube_url_14, t0.pinterest_url AS pinterest_url_15, t0.google_analytics_id AS google_analytics_id_16, t0.google_site_verification AS google_site_verification_17, t0.bing_site_verification AS bing_site_verification_18, t0.pinterest_site_verification AS pinterest_site_verification_19, t0.is_boxed_layout AS is_boxed_layout_20, t0.background_color AS background_color_21, t0.background AS background_22, t0.specials_background AS specials_background_23, t0.icon AS icon_24, t0.favicon AS favicon_25, t0.icon_tile_background AS icon_tile_background_26, t0.texts AS texts_27, t0.callback_background AS callback_background_28, t0.livechat AS livechat_29, t0.livechat_badge_image AS livechat_badge_image_30, t0.livechat_operator_avatar AS livechat_operator_avatar_31, t0.email_logo AS email_logo_32, t0.covered_areas_image AS covered_areas_image_33, t0.place_name AS place_name_34, t0.company_id AS company_id_35, t36.id AS id_37, t36.page_heading AS page_heading_38, t36.page_breadcrumb AS page_breadcrumb_39, t36.page_title AS page_title_40, t36.social_title AS social_title_41, t36.social_description AS social_description_42, t36.meta_description AS meta_description_43, t36.meta_keywords AS meta_keywords_44, t36.meta_robots AS meta_robots_45, t36.content AS content_46, t36.images AS images_47, t36.carousel_setting AS carousel_setting_48, t36.carousel_background AS carousel_background_49, t36.carousel_slides AS carousel_slides_50, t36.editor_note AS editor_note_51, t36.domain_id AS domain_id_52, t53.id AS id_54, t53.address_label AS address_label_55, t53.postcode AS postcode_56, t53.town AS town_57, t53.county AS county_58, t53.street_1 AS street_1_59, t53.street_2 AS street_2_60, t53.latitude AS latitude_61, t53.longitude AS longitude_62, t53.map_zoom AS map_zoom_63, t53.phone_1 AS phone_1_64, t53.phone_1_label AS phone_1_label_65, t53.phone_1_in_header AS phone_1_in_header_66, t53.phone_2 AS phone_2_67, t53.phone_2_label AS phone_2_label_68, t53.phone_2_in_header AS phone_2_in_header_69, t53.fax AS fax_70, t53.fax_label AS fax_label_71, t53.email AS email_72, t53.email_label AS email_label_73, t53.working_hours AS working_hours_74, t53.content AS content_75, t53.image AS image_76, t53.is_published AS is_published_77, t53.sort AS sort_78, t53.editor_note AS editor_note_79, t53.domain_id AS domain_id_80, t81.id AS id_82, t81.page_heading AS page_heading_83, t81.page_breadcrumb AS page_breadcrumb_84, t81.social_title AS social_title_85, t81.social_description AS social_description_86, t81.meta_description AS meta_description_87, t81.meta_robots AS meta_robots_88, t81.content AS content_89, t81.images AS images_90, t81.carousel_settings AS carousel_settings_91, t81.carousel_background AS carousel_background_92, t81.carousel_slides AS carousel_slides_93, t81.editor_note AS editor_note_94, t81.page_title AS page_title_95, t81.domain_id AS domain_id_96, t97.id AS id_98, t97.page_heading AS page_heading_99, t97.page_breadcrumb AS page_breadcrumb_100, t97.page_title AS page_title_101, t97.social_title AS social_title_102, t97.social_description AS social_description_103, t97.meta_description AS meta_description_104, t97.meta_keyword AS meta_keyword_105, t97.meta_robots AS meta_robots_106, t97.content AS content_107, t97.images AS images_108, t97.carousel_settings AS carousel_settings_109, t97.carousel_background AS carousel_background_110, t97.carousel_slides AS carousel_slides_111, t97.editor_note AS editor_note_112, t97.domain_id AS domain_id_113, t114.id AS id_115, t114.page_heading AS page_heading_116, t114.page_subheading AS page_subheading_117, t114.page_title AS page_title_118, t114.social_title AS social_title_119, t114.social_description AS social_description_120, t114.meta_description AS meta_description_121, t114.meta_keywords AS meta_keywords_122, t114.content AS content_123, t114.thumbnail AS thumbnail_124, t114.images AS images_125, t114.carousel_settings AS carousel_settings_126, t114.carousel_background AS carousel_background_127, t114.carousel_slides AS carousel_slides_128, t114.texts AS texts_129, t114.created_at AS created_at_130, t114.editor_note AS editor_note_131, t114.domain_id AS domain_id_132 FROM domain t0 LEFT JOIN about t36 ON t36.domain_id = t0.id LEFT JOIN contact t53 ON t53.domain_id = t0.id LEFT JOIN privacy_cookies t81 ON t81.domain_id = t0.id LEFT JOIN privacy_terms t97 ON t97.domain_id = t0.id LEFT JOIN homepage t114 ON t114.domain_id = t0.id WHERE t0.name = ? LIMIT 1
Parameters:
[
"barnetfloorsanding.co.uk"
]
|
|
2.17 ms (21.67%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_published AS is_published_3, t0.theme AS theme_4, t0.theme_color AS theme_color_5, t0.modules AS modules_6, t0.header_logo AS header_logo_7, t0.footer_logo AS footer_logo_8, t0.facebook_url AS facebook_url_9, t0.facebook_id AS facebook_id_10, t0.twitter_url AS twitter_url_11, t0.twitter_username AS twitter_username_12, t0.linkedin_url AS linkedin_url_13, t0.youtube_url AS youtube_url_14, t0.pinterest_url AS pinterest_url_15, t0.google_analytics_id AS google_analytics_id_16, t0.google_site_verification AS google_site_verification_17, t0.bing_site_verification AS bing_site_verification_18, t0.pinterest_site_verification AS pinterest_site_verification_19, t0.is_boxed_layout AS is_boxed_layout_20, t0.background_color AS background_color_21, t0.background AS background_22, t0.specials_background AS specials_background_23, t0.icon AS icon_24, t0.favicon AS favicon_25, t0.icon_tile_background AS icon_tile_background_26, t0.texts AS texts_27, t0.callback_background AS callback_background_28, t0.livechat AS livechat_29, t0.livechat_badge_image AS livechat_badge_image_30, t0.livechat_operator_avatar AS livechat_operator_avatar_31, t0.email_logo AS email_logo_32, t0.covered_areas_image AS covered_areas_image_33, t0.place_name AS place_name_34, t0.company_id AS company_id_35, t36.id AS id_37, t36.page_heading AS page_heading_38, t36.page_breadcrumb AS page_breadcrumb_39, t36.page_title AS page_title_40, t36.social_title AS social_title_41, t36.social_description AS social_description_42, t36.meta_description AS meta_description_43, t36.meta_keywords AS meta_keywords_44, t36.meta_robots AS meta_robots_45, t36.content AS content_46, t36.images AS images_47, t36.carousel_setting AS carousel_setting_48, t36.carousel_background AS carousel_background_49, t36.carousel_slides AS carousel_slides_50, t36.editor_note AS editor_note_51, t36.domain_id AS domain_id_52, t53.id AS id_54, t53.address_label AS address_label_55, t53.postcode AS postcode_56, t53.town AS town_57, t53.county AS county_58, t53.street_1 AS street_1_59, t53.street_2 AS street_2_60, t53.latitude AS latitude_61, t53.longitude AS longitude_62, t53.map_zoom AS map_zoom_63, t53.phone_1 AS phone_1_64, t53.phone_1_label AS phone_1_label_65, t53.phone_1_in_header AS phone_1_in_header_66, t53.phone_2 AS phone_2_67, t53.phone_2_label AS phone_2_label_68, t53.phone_2_in_header AS phone_2_in_header_69, t53.fax AS fax_70, t53.fax_label AS fax_label_71, t53.email AS email_72, t53.email_label AS email_label_73, t53.working_hours AS working_hours_74, t53.content AS content_75, t53.image AS image_76, t53.is_published AS is_published_77, t53.sort AS sort_78, t53.editor_note AS editor_note_79, t53.domain_id AS domain_id_80, t81.id AS id_82, t81.page_heading AS page_heading_83, t81.page_breadcrumb AS page_breadcrumb_84, t81.social_title AS social_title_85, t81.social_description AS social_description_86, t81.meta_description AS meta_description_87, t81.meta_robots AS meta_robots_88, t81.content AS content_89, t81.images AS images_90, t81.carousel_settings AS carousel_settings_91, t81.carousel_background AS carousel_background_92, t81.carousel_slides AS carousel_slides_93, t81.editor_note AS editor_note_94, t81.page_title AS page_title_95, t81.domain_id AS domain_id_96, t97.id AS id_98, t97.page_heading AS page_heading_99, t97.page_breadcrumb AS page_breadcrumb_100, t97.page_title AS page_title_101, t97.social_title AS social_title_102, t97.social_description AS social_description_103, t97.meta_description AS meta_description_104, t97.meta_keyword AS meta_keyword_105, t97.meta_robots AS meta_robots_106, t97.content AS content_107, t97.images AS images_108, t97.carousel_settings AS carousel_settings_109, t97.carousel_background AS carousel_background_110, t97.carousel_slides AS carousel_slides_111, t97.editor_note AS editor_note_112, t97.domain_id AS domain_id_113, t114.id AS id_115, t114.page_heading AS page_heading_116, t114.page_subheading AS page_subheading_117, t114.page_title AS page_title_118, t114.social_title AS social_title_119, t114.social_description AS social_description_120, t114.meta_description AS meta_description_121, t114.meta_keywords AS meta_keywords_122, t114.content AS content_123, t114.thumbnail AS thumbnail_124, t114.images AS images_125, t114.carousel_settings AS carousel_settings_126, t114.carousel_background AS carousel_background_127, t114.carousel_slides AS carousel_slides_128, t114.texts AS texts_129, t114.created_at AS created_at_130, t114.editor_note AS editor_note_131, t114.domain_id AS domain_id_132 FROM domain t0 LEFT JOIN about t36 ON t36.domain_id = t0.id LEFT JOIN contact t53 ON t53.domain_id = t0.id LEFT JOIN privacy_cookies t81 ON t81.domain_id = t0.id LEFT JOIN privacy_terms t97 ON t97.domain_id = t0.id LEFT JOIN homepage t114 ON t114.domain_id = t0.id WHERE t0.id = ?
Parameters:
[
"2"
]
|
|
1.36 ms (13.62%) |
1 |
SELECT t0.id AS id_1, t0.page_url AS page_url_2, t0.page_heading AS page_heading_3, t0.page_breadcrumb AS page_breadcrumb_4, t0.page_title AS page_title_5, t0.social_title AS social_title_6, t0.social_description AS social_description_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.meta_robots AS meta_robots_10, t0.name AS name_11, t0.content AS content_12, t0.in_index AS in_index_13, t0.summary AS summary_14, t0.thumbnail AS thumbnail_15, t0.images AS images_16, t0.carousel_settings AS carousel_settings_17, t0.carousel_background AS carousel_background_18, t0.carousel_slides AS carousel_slides_19, t0.is_published AS is_published_20, t0.created_at AS created_at_21, t0.sort AS sort_22, t0.editor_note AS editor_note_23, t0.domain_id AS domain_id_24, t0.parent_id AS parent_id_25 FROM service t0 WHERE t0.domain_id = ?
Parameters:
[
22
]
|
|
1.02 ms (10.23%) |
1 |
SELECT t0.id AS id_1, t0.heading AS heading_2, t0.client_name AS client_name_3, t0.location AS location_4, t0.content AS content_5, t0.thumbnail AS thumbnail_6, t0.services AS services_7, t0.images AS images_8, t0.is_published AS is_published_9, t0.created_at AS created_at_10, t0.sort AS sort_11, t0.editor_note AS editor_note_12, t0.domain_id AS domain_id_13 FROM portfolio t0 WHERE t0.domain_id = ?
Parameters:
[
22
]
|
|
1.00 ms (10.02%) |
1 |
SELECT t0.id AS id_1, t0.page_url AS page_url_2, t0.page_heading AS page_heading_3, t0.page_breadcrumb AS page_breadcrumb_4, t0.page_title AS page_title_5, t0.social_title AS social_title_6, t0.social_description AS social_description_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.meta_robots AS meta_robots_10, t0.summary AS summary_11, t0.content AS content_12, t0.thumbnail AS thumbnail_13, t0.images AS images_14, t0.is_shared AS is_shared_15, t0.is_published AS is_published_16, t0.auto_publish_on AS auto_publish_on_17, t0.sort AS sort_18, t0.editor_note AS editor_note_19, t0.domain_id AS domain_id_20 FROM brand t0 WHERE t0.domain_id = ?
Parameters:
[
22
]
|
|
0.99 ms (9.90%) |
1 |
SELECT t0.id AS id_1, t0.services AS services_2, t0.name AS name_3, t0.email AS email_4, t0.heading AS heading_5, t0.content AS content_6, t0.rating AS rating_7, t0.source AS source_8, t0.location AS location_9, t0.job AS job_10, t0.photo AS photo_11, t0.is_shared AS is_shared_12, t0.created_at AS created_at_13, t0.auto_publish_on AS auto_publish_on_14, t0.published_on AS published_on_15, t0.editor_note AS editor_note_16, t0.domain_id AS domain_id_17 FROM review t0 WHERE t0.domain_id = ?
Parameters:
[
22
]
|
|
0.85 ms (8.50%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_long AS name_long_3, t0.email AS email_4, t0.phone AS phone_5 FROM company t0 WHERE t0.id = ?
Parameters:
[
176
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| old_database | doctrine.dbal.old_database_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\Domain |
|
| App\Entity\Company | No errors. |
| App\Entity\About | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\PrivacyCookies | No errors. |
| App\Entity\PrivacyTerms | No errors. |
| App\Entity\Homepage | No errors. |
| App\Entity\Article |
|
| App\Entity\ArticlesCategory | No errors. |
| App\Entity\AskExpert | No errors. |
| App\Entity\Brand |
|
| App\Entity\FAQ | No errors. |
| App\Entity\Offer | No errors. |
| App\Entity\Portfolio | No errors. |
| App\Entity\Price | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Review | No errors. |
| App\Entity\Service | No errors. |