https://interlet-group.cwd-jm.com/

Query Metrics

48 Database Queries
9 Different statements
32.65 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.