Query Metrics
48
Database Queries
9
Different statements
32.65 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.12 ms |
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:
[] |
| 2 | 7.16 ms |
SELECT p0_.id AS id_0, p0_.uuid AS uuid_1, p0_.created AS created_2, p0_.modified AS modified_3, p0_.listing_type AS listing_type_4, p0_.reference AS reference_5, p0_.date_available AS date_available_6, p0_.name_number AS name_number_7, p0_.address2 AS address2_8, p0_.address3 AS address3_9, p0_.address4 AS address4_10, p0_.town AS town_11, p0_.postcode AS postcode_12, p0_.latitude AS latitude_13, p0_.longitude AS longitude_14, p0_.rental_price AS rental_price_15, p0_.monthly_rental_price AS monthly_rental_price_16, p0_.rent_frequency AS rent_frequency_17, p0_.sale_price AS sale_price_18, p0_.corner_banner AS corner_banner_19, p0_.summary AS summary_20, p0_.description AS description_21, p0_.bedrooms AS bedrooms_22, p0_.bathrooms AS bathrooms_23, p0_.reception_rooms AS reception_rooms_24, p0_.epc_url AS epc_url_25, p0_.show_on_website AS show_on_website_26, p0_.show_on_right_move AS show_on_right_move_27, p0_.right_move_status AS right_move_status_28, p0_.right_move_last_updated AS right_move_last_updated_29, p0_.right_move_listing_url AS right_move_listing_url_30, p0_.show_on_zoopla AS show_on_zoopla_31, p0_.zoopla_status AS zoopla_status_32, p0_.zoopla_last_updated AS zoopla_last_updated_33, p0_.zoopla_listing_url AS zoopla_listing_url_34, p0_.billable_monthly_rent AS billable_monthly_rent_35, p0_.landlord_id AS landlord_id_36, p0_.type_id AS type_id_37, p0_.area_id AS area_id_38, p0_.featured_image_id AS featured_image_id_39 FROM properties_property p0_ WHERE p0_.show_on_website = ? LIMIT 20
Parameters:
[
1
]
|
| 3 | 0.84 ms |
SELECT p0_.id AS id_0, p0_.uuid AS uuid_1, p0_.created AS created_2, p0_.name AS name_3, p0_.right_move_identifier AS right_move_identifier_4, p0_.zoopla_identifier AS zoopla_identifier_5 FROM properties_type p0_
Parameters:
[] |
| 4 | 0.73 ms |
SELECT p0_.id AS id_0, p0_.uuid AS uuid_1, p0_.created AS created_2, p0_.name AS name_3 FROM properties_area p0_
Parameters:
[] |
| 5 | 0.79 ms |
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.identifier AS identifier_3, c0_.name AS name_4, c0_.is_locked AS is_locked_5, c0_.disable_child_items AS disable_child_items_6 FROM content_menus_menu c0_ WHERE c0_.identifier = ? LIMIT 1
Parameters:
[
"primary"
]
|
| 6 | 3.00 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.label AS label_4, t0.url AS url_5, t0.auto_update AS auto_update_6, t0.open_new_window AS open_new_window_7, t0.display_order AS display_order_8, t0.type AS type_9, t0.menu_id AS menu_id_10, t0.page_id AS page_id_11, t0.parent_id AS parent_id_12 FROM content_menus_menuitem t0 WHERE t0.menu_id = ? ORDER BY t0.display_order ASC
Parameters:
[
1
]
|
| 7 | 1.76 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.label AS label_4, t0.url AS url_5, t0.auto_update AS auto_update_6, t0.open_new_window AS open_new_window_7, t0.display_order AS display_order_8, t0.type AS type_9, t0.menu_id AS menu_id_10, t0.page_id AS page_id_11, t0.parent_id AS parent_id_12 FROM content_menus_menuitem t0 WHERE t0.parent_id = ? ORDER BY t0.display_order ASC
Parameters:
[
4
]
|
| 8 | 0.50 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.label AS label_4, t0.url AS url_5, t0.auto_update AS auto_update_6, t0.open_new_window AS open_new_window_7, t0.display_order AS display_order_8, t0.type AS type_9, t0.menu_id AS menu_id_10, t0.page_id AS page_id_11, t0.parent_id AS parent_id_12 FROM content_menus_menuitem t0 WHERE t0.parent_id = ? ORDER BY t0.display_order ASC
Parameters:
[
5
]
|
| 9 | 0.52 ms |
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.display_order AS display_order_12, t0.parent_id AS parent_id_13 FROM content_pages_page t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 10 | 0.51 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.label AS label_4, t0.url AS url_5, t0.auto_update AS auto_update_6, t0.open_new_window AS open_new_window_7, t0.display_order AS display_order_8, t0.type AS type_9, t0.menu_id AS menu_id_10, t0.page_id AS page_id_11, t0.parent_id AS parent_id_12 FROM content_menus_menuitem t0 WHERE t0.parent_id = ? ORDER BY t0.display_order ASC
Parameters:
[
1
]
|
| 11 | 0.41 ms |
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.display_order AS display_order_12, t0.parent_id AS parent_id_13 FROM content_pages_page t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 12 | 0.46 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.label AS label_4, t0.url AS url_5, t0.auto_update AS auto_update_6, t0.open_new_window AS open_new_window_7, t0.display_order AS display_order_8, t0.type AS type_9, t0.menu_id AS menu_id_10, t0.page_id AS page_id_11, t0.parent_id AS parent_id_12 FROM content_menus_menuitem t0 WHERE t0.parent_id = ? ORDER BY t0.display_order ASC
Parameters:
[
2
]
|
| 13 | 0.41 ms |
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.display_order AS display_order_12, t0.parent_id AS parent_id_13 FROM content_pages_page t0 WHERE t0.id = ?
Parameters:
[
9
]
|
| 14 | 0.48 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.label AS label_4, t0.url AS url_5, t0.auto_update AS auto_update_6, t0.open_new_window AS open_new_window_7, t0.display_order AS display_order_8, t0.type AS type_9, t0.menu_id AS menu_id_10, t0.page_id AS page_id_11, t0.parent_id AS parent_id_12 FROM content_menus_menuitem t0 WHERE t0.parent_id = ? ORDER BY t0.display_order ASC
Parameters:
[
17
]
|
| 15 | 0.42 ms |
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.display_order AS display_order_12, t0.parent_id AS parent_id_13 FROM content_pages_page t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 16 | 0.43 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.label AS label_4, t0.url AS url_5, t0.auto_update AS auto_update_6, t0.open_new_window AS open_new_window_7, t0.display_order AS display_order_8, t0.type AS type_9, t0.menu_id AS menu_id_10, t0.page_id AS page_id_11, t0.parent_id AS parent_id_12 FROM content_menus_menuitem t0 WHERE t0.parent_id = ? ORDER BY t0.display_order ASC
Parameters:
[
3
]
|
| 17 | 0.91 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.filename AS filename_4, t0.display_order AS display_order_5, t0.property_id AS property_id_6 FROM properties_image t0 WHERE t0.id = ?
Parameters:
[
766
]
|
| 18 | 0.61 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.filename AS filename_4, t0.display_order AS display_order_5, t0.property_id AS property_id_6 FROM properties_image t0 WHERE t0.id = ?
Parameters:
[
9082
]
|
| 19 | 0.53 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.filename AS filename_4, t0.display_order AS display_order_5, t0.property_id AS property_id_6 FROM properties_image t0 WHERE t0.id = ?
Parameters:
[
1061
]
|
| 20 | 0.49 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.filename AS filename_4, t0.display_order AS display_order_5, t0.property_id AS property_id_6 FROM properties_image t0 WHERE t0.id = ?
Parameters:
[
20793
]
|
| 21 | 0.48 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.filename AS filename_4, t0.display_order AS display_order_5, t0.property_id AS property_id_6 FROM properties_image t0 WHERE t0.id = ?
Parameters:
[
12756
]
|
| 22 | 0.42 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.filename AS filename_4, t0.display_order AS display_order_5, t0.property_id AS property_id_6 FROM properties_image t0 WHERE t0.id = ?
Parameters:
[
1433
]
|
| 23 | 0.37 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.filename AS filename_4, t0.display_order AS display_order_5, t0.property_id AS property_id_6 FROM properties_image t0 WHERE t0.id = ?
Parameters:
[
1488
]
|
| 24 | 0.49 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.filename AS filename_4, t0.display_order AS display_order_5, t0.property_id AS property_id_6 FROM properties_image t0 WHERE t0.id = ?
Parameters:
[
1848
]
|
| 25 | 0.44 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.filename AS filename_4, t0.display_order AS display_order_5, t0.property_id AS property_id_6 FROM properties_image t0 WHERE t0.id = ?
Parameters:
[
9860
]
|
| 26 | 0.48 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.filename AS filename_4, t0.display_order AS display_order_5, t0.property_id AS property_id_6 FROM properties_image t0 WHERE t0.id = ?
Parameters:
[
11046
]
|
| 27 | 0.43 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.filename AS filename_4, t0.display_order AS display_order_5, t0.property_id AS property_id_6 FROM properties_image t0 WHERE t0.id = ?
Parameters:
[
2170
]
|
| 28 | 0.34 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.filename AS filename_4, t0.display_order AS display_order_5, t0.property_id AS property_id_6 FROM properties_image t0 WHERE t0.id = ?
Parameters:
[
2201
]
|
| 29 | 0.30 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.filename AS filename_4, t0.display_order AS display_order_5, t0.property_id AS property_id_6 FROM properties_image t0 WHERE t0.id = ?
Parameters:
[
2234
]
|
| 30 | 0.42 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.filename AS filename_4, t0.display_order AS display_order_5, t0.property_id AS property_id_6 FROM properties_image t0 WHERE t0.id = ?
Parameters:
[
2260
]
|
| 31 | 0.33 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.filename AS filename_4, t0.display_order AS display_order_5, t0.property_id AS property_id_6 FROM properties_image t0 WHERE t0.id = ?
Parameters:
[
8872
]
|
| 32 | 0.38 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.filename AS filename_4, t0.display_order AS display_order_5, t0.property_id AS property_id_6 FROM properties_image t0 WHERE t0.id = ?
Parameters:
[
2446
]
|
| 33 | 0.32 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.filename AS filename_4, t0.display_order AS display_order_5, t0.property_id AS property_id_6 FROM properties_image t0 WHERE t0.id = ?
Parameters:
[
2474
]
|
| 34 | 0.42 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.filename AS filename_4, t0.display_order AS display_order_5, t0.property_id AS property_id_6 FROM properties_image t0 WHERE t0.id = ?
Parameters:
[
14788
]
|
| 35 | 0.36 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.filename AS filename_4, t0.display_order AS display_order_5, t0.property_id AS property_id_6 FROM properties_image t0 WHERE t0.id = ?
Parameters:
[
14972
]
|
| 36 | 0.36 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.filename AS filename_4, t0.display_order AS display_order_5, t0.property_id AS property_id_6 FROM properties_image t0 WHERE t0.id = ?
Parameters:
[
2780
]
|
| 37 | 0.36 ms |
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.identifier AS identifier_3, c0_.name AS name_4, c0_.is_locked AS is_locked_5, c0_.disable_child_items AS disable_child_items_6 FROM content_menus_menu c0_ WHERE c0_.identifier = ? LIMIT 1
Parameters:
[
"footer_1"
]
|
| 38 | 0.32 ms |
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.identifier AS identifier_3, c0_.name AS name_4, c0_.is_locked AS is_locked_5, c0_.disable_child_items AS disable_child_items_6 FROM content_menus_menu c0_ WHERE c0_.identifier = ? LIMIT 1
Parameters:
[
"footer_1"
]
|
| 39 | 0.47 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.label AS label_4, t0.url AS url_5, t0.auto_update AS auto_update_6, t0.open_new_window AS open_new_window_7, t0.display_order AS display_order_8, t0.type AS type_9, t0.menu_id AS menu_id_10, t0.page_id AS page_id_11, t0.parent_id AS parent_id_12 FROM content_menus_menuitem t0 WHERE t0.menu_id = ? ORDER BY t0.display_order ASC
Parameters:
[
2
]
|
| 40 | 0.34 ms |
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.display_order AS display_order_12, t0.parent_id AS parent_id_13 FROM content_pages_page t0 WHERE t0.id = ?
Parameters:
[
7
]
|
| 41 | 0.33 ms |
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.identifier AS identifier_3, c0_.name AS name_4, c0_.is_locked AS is_locked_5, c0_.disable_child_items AS disable_child_items_6 FROM content_menus_menu c0_ WHERE c0_.identifier = ? LIMIT 1
Parameters:
[
"footer_2"
]
|
| 42 | 0.33 ms |
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.identifier AS identifier_3, c0_.name AS name_4, c0_.is_locked AS is_locked_5, c0_.disable_child_items AS disable_child_items_6 FROM content_menus_menu c0_ WHERE c0_.identifier = ? LIMIT 1
Parameters:
[
"footer_2"
]
|
| 43 | 0.38 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.label AS label_4, t0.url AS url_5, t0.auto_update AS auto_update_6, t0.open_new_window AS open_new_window_7, t0.display_order AS display_order_8, t0.type AS type_9, t0.menu_id AS menu_id_10, t0.page_id AS page_id_11, t0.parent_id AS parent_id_12 FROM content_menus_menuitem t0 WHERE t0.menu_id = ? ORDER BY t0.display_order ASC
Parameters:
[
3
]
|
| 44 | 0.39 ms |
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.display_order AS display_order_12, t0.parent_id AS parent_id_13 FROM content_pages_page t0 WHERE t0.id = ?
Parameters:
[
8
]
|
| 45 | 0.35 ms |
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.display_order AS display_order_12, t0.parent_id AS parent_id_13 FROM content_pages_page t0 WHERE t0.id = ?
Parameters:
[
15
]
|
| 46 | 0.29 ms |
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.identifier AS identifier_3, c0_.name AS name_4, c0_.is_locked AS is_locked_5, c0_.disable_child_items AS disable_child_items_6 FROM content_menus_menu c0_ WHERE c0_.identifier = ? LIMIT 1
Parameters:
[
"footer_3"
]
|
| 47 | 0.29 ms |
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.identifier AS identifier_3, c0_.name AS name_4, c0_.is_locked AS is_locked_5, c0_.disable_child_items AS disable_child_items_6 FROM content_menus_menu c0_ WHERE c0_.identifier = ? LIMIT 1
Parameters:
[
"footer_3"
]
|
| 48 | 0.35 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.label AS label_4, t0.url AS url_5, t0.auto_update AS auto_update_6, t0.open_new_window AS open_new_window_7, t0.display_order AS display_order_8, t0.type AS type_9, t0.menu_id AS menu_id_10, t0.page_id AS page_id_11, t0.parent_id AS parent_id_12 FROM content_menus_menuitem t0 WHERE t0.menu_id = ? ORDER BY t0.display_order ASC
Parameters:
[
4
]
|
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\Properties\Property | No errors. |
| App\Entity\Landlords\Landlord | No errors. |
| App\Entity\Properties\Type | No errors. |
| App\Entity\Properties\Area | No errors. |
| App\Entity\Properties\Image | No errors. |
| App\Entity\Maintenance\Maintenance | No errors. |
| App\Entity\Statements\Item | No errors. |
| App\Entity\Properties\PropertyFeature | No errors. |
| App\Entity\Content\Menus\Menu | No errors. |
| App\Entity\Content\Menus\MenuItem | No errors. |
| App\Entity\Content\Pages\Page | No errors. |
| App\Entity\Content\Pages\Block | No errors. |