Query Metrics
35
Database Queries
17
Different statements
21.69 ms
Query time
0
Invalid entities
71
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.78 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 | 0.67 ms |
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.text AS text_3, c0_.url AS url_4, c0_.ignore_before AS ignore_before_5, c0_.ignore_after AS ignore_after_6 FROM content_autolinks_autolink c0_
Parameters:
[] |
| 3 | 0.76 ms |
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.name AS name_3, c0_.description AS description_4, c0_.slug AS slug_5, c0_.path AS path_6, c0_.image AS image_7, c0_.seo_title AS seo_title_8, c0_.seo_keywords AS seo_keywords_9, c0_.seo_description AS seo_description_10, c0_.parent_id AS parent_id_11 FROM commerce_categories_category c0_ WHERE c0_.path = ? LIMIT 1
Parameters:
[
"chocolates/milk-chocolate"
]
|
| 4 | 0.72 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.path AS path_7, t0.image AS image_8, t0.seo_title AS seo_title_9, t0.seo_keywords AS seo_keywords_10, t0.seo_description AS seo_description_11, t0.parent_id AS parent_id_12 FROM commerce_categories_category t0 WHERE t0.parent_id = ?
Parameters:
[
244
]
|
| 5 | 0.54 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.path AS path_7, t0.image AS image_8, t0.seo_title AS seo_title_9, t0.seo_keywords AS seo_keywords_10, t0.seo_description AS seo_description_11, t0.parent_id AS parent_id_12 FROM commerce_categories_category t0 WHERE t0.id = ?
Parameters:
[
242
]
|
| 6 | 1.11 ms |
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM commerce_products_variant c0_ INNER JOIN commerce_products_product c1_ ON c0_.product_id = c1_.id WHERE c1_.enabled = ? AND EXISTS (SELECT 1 FROM product_category p2_ WHERE p2_.product_id = c1_.id AND p2_.category_id IN (?))
Parameters:
[ 1 244 ] |
| 7 | 0.92 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.name AS name_1 FROM commerce_products_variant c0_ INNER JOIN commerce_products_product c1_ ON c0_.product_id = c1_.id WHERE c1_.enabled = ? AND EXISTS (SELECT 1 FROM product_category p2_ WHERE p2_.product_id = c1_.id AND p2_.category_id IN (?)) ORDER BY c0_.name ASC LIMIT 25
Parameters:
[ 1 244 ] |
| 8 | 1.10 ms |
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.name AS name_3, c0_.slug AS slug_4, c0_.path AS path_5, c0_.price AS price_6, c0_.weight AS weight_7, c0_.stock AS stock_8, c0_.tax_inclusive AS tax_inclusive_9, c0_.quantity_type_other AS quantity_type_other_10, c0_.product_id AS product_id_11, c0_.quantitytype_id AS quantitytype_id_12, c0_.taxrate_id AS taxrate_id_13 FROM commerce_products_variant c0_ INNER JOIN commerce_products_product c1_ ON c0_.product_id = c1_.id WHERE c1_.enabled = ? AND EXISTS (SELECT 1 FROM product_category p2_ WHERE p2_.product_id = c1_.id AND p2_.category_id IN (?)) AND c0_.id IN (?, ?, ?, ?, ?) ORDER BY c0_.name ASC
Parameters:
[ 1 244 949 953 951 952 950 ] |
| 9 | 0.65 ms |
SELECT l0_.id AS id_0, l0_.uuid AS uuid_1, l0_.created AS created_2, l0_.modified AS modified_3, l0_.locale AS locale_4, l0_.name AS name_5, l0_.icon AS icon_6, l0_.is_locked AS is_locked_7 FROM languages_language l0_
Parameters:
[] |
| 10 | 0.60 ms |
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, c0_.language_id AS language_id_8 FROM content_menus_menu c0_ WHERE c0_.identifier = ? LIMIT 1
Parameters:
[
"primary"
]
|
| 11 | 0.78 ms |
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:
[
3
]
|
| 12 | 0.69 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.version AS version_4, t0.name AS name_5, t0.content AS content_6, t0.slug AS slug_7, t0.path AS path_8, t0.enable_group_restrictions AS enable_group_restrictions_9, t0.enable_role_restrictions AS enable_role_restrictions_10, t0.status AS status_11, t0.primary_image AS primary_image_12, t0.seo_page_title AS seo_page_title_13, t0.seo_description AS seo_description_14, t0.seo_keywords AS seo_keywords_15, t0.display_order AS display_order_16, t0.parent_id AS parent_id_17, t0.language_id AS language_id_18 FROM content_pages_page t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 13 | 0.66 ms |
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.name AS name_3, c0_.description AS description_4, c0_.slug AS slug_5, c0_.path AS path_6, c0_.image AS image_7, c0_.seo_title AS seo_title_8, c0_.seo_keywords AS seo_keywords_9, c0_.seo_description AS seo_description_10, c0_.parent_id AS parent_id_11 FROM commerce_categories_category c0_ WHERE c0_.parent_id IS NULL
Parameters:
[] |
| 14 | 0.61 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.version AS version_4, t0.name AS name_5, t0.content AS content_6, t0.slug AS slug_7, t0.path AS path_8, t0.enable_group_restrictions AS enable_group_restrictions_9, t0.enable_role_restrictions AS enable_role_restrictions_10, t0.status AS status_11, t0.primary_image AS primary_image_12, t0.seo_page_title AS seo_page_title_13, t0.seo_description AS seo_description_14, t0.seo_keywords AS seo_keywords_15, t0.display_order AS display_order_16, t0.parent_id AS parent_id_17, t0.language_id AS language_id_18 FROM content_pages_page t0 WHERE t0.id = ?
Parameters:
[
8
]
|
| 15 | 0.56 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.version AS version_4, t0.name AS name_5, t0.content AS content_6, t0.slug AS slug_7, t0.path AS path_8, t0.enable_group_restrictions AS enable_group_restrictions_9, t0.enable_role_restrictions AS enable_role_restrictions_10, t0.status AS status_11, t0.primary_image AS primary_image_12, t0.seo_page_title AS seo_page_title_13, t0.seo_description AS seo_description_14, t0.seo_keywords AS seo_keywords_15, t0.display_order AS display_order_16, t0.parent_id AS parent_id_17, t0.language_id AS language_id_18 FROM content_pages_page t0 WHERE t0.id = ?
Parameters:
[
11
]
|
| 16 | 0.58 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.slug AS slug_5, t0.path AS path_6, t0.enabled AS enabled_7, t0.description AS description_8, t0.seo_title AS seo_title_9, t0.seo_keywords AS seo_keywords_10, t0.seo_description AS seo_description_11, t0.primary_image_id AS primary_image_id_12 FROM commerce_products_product t0 WHERE t0.id = ?
Parameters:
[
490
]
|
| 17 | 0.47 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.rate AS rate_5 FROM commerce_tax_rate t0 WHERE t0.id = ?
Parameters:
[
14
]
|
| 18 | 0.47 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4 FROM commerce_products_quantitytype t0 WHERE t0.id = ?
Parameters:
[
53
]
|
| 19 | 0.53 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.slug AS slug_5, t0.path AS path_6, t0.enabled AS enabled_7, t0.description AS description_8, t0.seo_title AS seo_title_9, t0.seo_keywords AS seo_keywords_10, t0.seo_description AS seo_description_11, t0.primary_image_id AS primary_image_id_12 FROM commerce_products_product t0 WHERE t0.id = ?
Parameters:
[
492
]
|
| 20 | 0.42 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4 FROM commerce_products_quantitytype t0 WHERE t0.id = ?
Parameters:
[
55
]
|
| 21 | 0.47 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.slug AS slug_5, t0.path AS path_6, t0.enabled AS enabled_7, t0.description AS description_8, t0.seo_title AS seo_title_9, t0.seo_keywords AS seo_keywords_10, t0.seo_description AS seo_description_11, t0.primary_image_id AS primary_image_id_12 FROM commerce_products_product t0 WHERE t0.id = ?
Parameters:
[
491
]
|
| 22 | 0.43 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4 FROM commerce_products_quantitytype t0 WHERE t0.id = ?
Parameters:
[
54
]
|
| 23 | 0.40 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4 FROM commerce_products_quantitytype t0 WHERE t0.id = ?
Parameters:
[
49
]
|
| 24 | 0.45 ms |
SELECT l0_.id AS id_0, l0_.uuid AS uuid_1, l0_.created AS created_2, l0_.modified AS modified_3, l0_.locale AS locale_4, l0_.name AS name_5, l0_.icon AS icon_6, l0_.is_locked AS is_locked_7 FROM languages_language l0_
Parameters:
[] |
| 25 | 0.52 ms |
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, c0_.language_id AS language_id_8 FROM content_menus_menu c0_ WHERE c0_.identifier = ? LIMIT 1
Parameters:
[
"footer"
]
|
| 26 | 0.69 ms |
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:
[
2
]
|
| 27 | 0.56 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.version AS version_4, t0.name AS name_5, t0.content AS content_6, t0.slug AS slug_7, t0.path AS path_8, t0.enable_group_restrictions AS enable_group_restrictions_9, t0.enable_role_restrictions AS enable_role_restrictions_10, t0.status AS status_11, t0.primary_image AS primary_image_12, t0.seo_page_title AS seo_page_title_13, t0.seo_description AS seo_description_14, t0.seo_keywords AS seo_keywords_15, t0.display_order AS display_order_16, t0.parent_id AS parent_id_17, t0.language_id AS language_id_18 FROM content_pages_page t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 28 | 0.76 ms |
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:
[
3
]
|
| 29 | 0.56 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.version AS version_4, t0.name AS name_5, t0.content AS content_6, t0.slug AS slug_7, t0.path AS path_8, t0.enable_group_restrictions AS enable_group_restrictions_9, t0.enable_role_restrictions AS enable_role_restrictions_10, t0.status AS status_11, t0.primary_image AS primary_image_12, t0.seo_page_title AS seo_page_title_13, t0.seo_description AS seo_description_14, t0.seo_keywords AS seo_keywords_15, t0.display_order AS display_order_16, t0.parent_id AS parent_id_17, t0.language_id AS language_id_18 FROM content_pages_page t0 WHERE t0.id = ?
Parameters:
[
7
]
|
| 30 | 0.55 ms |
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:
[
4
]
|
| 31 | 0.51 ms |
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:
[
5
]
|
| 32 | 0.56 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.version AS version_4, t0.name AS name_5, t0.content AS content_6, t0.slug AS slug_7, t0.path AS path_8, t0.enable_group_restrictions AS enable_group_restrictions_9, t0.enable_role_restrictions AS enable_role_restrictions_10, t0.status AS status_11, t0.primary_image AS primary_image_12, t0.seo_page_title AS seo_page_title_13, t0.seo_description AS seo_description_14, t0.seo_keywords AS seo_keywords_15, t0.display_order AS display_order_16, t0.parent_id AS parent_id_17, t0.language_id AS language_id_18 FROM content_pages_page t0 WHERE t0.id = ?
Parameters:
[
9
]
|
| 33 | 0.55 ms |
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:
[
6
]
|
| 34 | 0.54 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.version AS version_4, t0.name AS name_5, t0.content AS content_6, t0.slug AS slug_7, t0.path AS path_8, t0.enable_group_restrictions AS enable_group_restrictions_9, t0.enable_role_restrictions AS enable_role_restrictions_10, t0.status AS status_11, t0.primary_image AS primary_image_12, t0.seo_page_title AS seo_page_title_13, t0.seo_description AS seo_description_14, t0.seo_keywords AS seo_keywords_15, t0.display_order AS display_order_16, t0.parent_id AS parent_id_17, t0.language_id AS language_id_18 FROM content_pages_page t0 WHERE t0.id = ?
Parameters:
[
10
]
|
| 35 | 0.55 ms |
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:
[
7
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\System\Config | 29 |
| App\Entity\Content\Menus\MenuItem | 10 |
| App\Entity\Commerce\Categories\Category | 9 |
| App\Entity\Content\Pages\Page | 7 |
| App\Entity\Commerce\Products\Variant | 5 |
| App\Entity\Commerce\Products\QuantityType | 4 |
| App\Entity\Commerce\Products\Product | 3 |
| App\Entity\Content\Menus\Menu | 2 |
| App\Entity\Commerce\Tax\Rate | 1 |
| App\Entity\Languages\Language | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\System\Config | No errors. |
| App\Entity\Content\AutoLinks\AutoLink | No errors. |
| App\Entity\Commerce\Categories\Category | No errors. |
| App\Entity\Commerce\Products\Product | No errors. |
| App\Entity\Commerce\Products\Variant | No errors. |
| App\Entity\Commerce\Products\QuantityType | No errors. |
| App\Entity\Commerce\Tax\Rate | No errors. |
| App\Entity\Commerce\Products\Image | No errors. |
| App\Entity\Languages\Language | No errors. |
| App\Entity\Languages\Phrase | 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. |
| App\Entity\Users\Group | No errors. |
| App\Entity\Users\Role | No errors. |
| App\Entity\Content\Pages\Revision | No errors. |