Query Metrics
29
Database Queries
9
Different statements
22.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.84 ms (17.16%) |
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:
[] |
|
3.76 ms (16.77%) |
6 |
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
]
|
|
3.61 ms (16.10%) |
4 |
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
]
|
|
3.60 ms (16.06%) |
7 |
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"
]
|
|
3.46 ms (15.45%) |
7 |
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
]
|
|
1.76 ms (7.85%) |
1 |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM properties_property p0_ WHERE p0_.listing_type = ? AND p0_.show_on_website = ?
Parameters:
[ "letting" 1 ] |
|
0.90 ms (4.04%) |
1 |
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:
[] |
|
0.83 ms (3.70%) |
1 |
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:
[] |
|
0.65 ms (2.88%) |
1 |
SELECT DISTINCT p0_.id AS id_0 FROM properties_property p0_ WHERE p0_.listing_type = ? AND p0_.show_on_website = ? LIMIT 16
Parameters:
[ "letting" 1 ] |
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\Properties\Type | No errors. |
| App\Entity\Properties\Area | 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. |