GET https://atozdrinks.cwd-mm.com/categories/gift-hampers

Query Metrics

30 Database Queries
13 Different statements
30.19 ms Query time
0 Invalid entities
106 Managed entities

Queries

Group similar statements

# Time Info
1 1.08 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.89 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 1.11 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:
[
  "gift-hampers"
]
4 0.93 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:
[
  277
]
5 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.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:
[
  278
]
6 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.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:
[
  279
]
7 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.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:
[
  280
]
8 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.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:
[
  281
]
9 4.63 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 (?)) OR EXISTS (SELECT 1 FROM product_category p2_ WHERE p2_.product_id = c1_.id AND p2_.category_id IN (?)) OR EXISTS (SELECT 1 FROM product_category p2_ WHERE p2_.product_id = c1_.id AND p2_.category_id IN (?)) OR EXISTS (SELECT 1 FROM product_category p2_ WHERE p2_.product_id = c1_.id AND p2_.category_id IN (?)) OR EXISTS (SELECT 1 FROM product_category p2_ WHERE p2_.product_id = c1_.id AND p2_.category_id IN (?)))
Parameters:
[
  1
  278
  279
  280
  281
  277
]
10 4.70 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 (?)) OR EXISTS (SELECT 1 FROM product_category p2_ WHERE p2_.product_id = c1_.id AND p2_.category_id IN (?)) OR EXISTS (SELECT 1 FROM product_category p2_ WHERE p2_.product_id = c1_.id AND p2_.category_id IN (?)) OR EXISTS (SELECT 1 FROM product_category p2_ WHERE p2_.product_id = c1_.id AND p2_.category_id IN (?)) OR EXISTS (SELECT 1 FROM product_category p2_ WHERE p2_.product_id = c1_.id AND p2_.category_id IN (?))) ORDER BY c0_.name ASC LIMIT 100
Parameters:
[
  1
  278
  279
  280
  281
  277
]
11 2.29 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 (?)) OR EXISTS (SELECT 1 FROM product_category p2_ WHERE p2_.product_id = c1_.id AND p2_.category_id IN (?)) OR EXISTS (SELECT 1 FROM product_category p2_ WHERE p2_.product_id = c1_.id AND p2_.category_id IN (?)) OR EXISTS (SELECT 1 FROM product_category p2_ WHERE p2_.product_id = c1_.id AND p2_.category_id IN (?)) OR 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
  278
  279
  280
  281
  277
  1140
  1141
  1143
  1161
  1163
  1165
  1167
  1145
  1147
  1149
  1151
  1153
  1155
  1157
  1159
  1162
  1164
  1166
  1144
  1146
  1148
  1150
  1152
  1154
  1156
  1158
  1160
  1142
]
12 0.74 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:
[]
13 0.68 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"
]
14 0.94 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
]
15 0.85 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
]
16 0.96 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:
[]
17 0.78 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
]
18 0.53 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
]
19 0.63 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:
[]
20 0.71 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"
]
21 0.73 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
]
22 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:
[
  6
]
23 0.57 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
]
24 0.58 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
]
25 0.62 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
]
26 0.56 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
]
27 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:
[
  9
]
28 0.49 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
]
29 0.51 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
]
30 0.57 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\Commerce\Products\Variant 28
App\Entity\Commerce\Products\Product 14
App\Entity\Commerce\Categories\Category 12
App\Entity\Content\Menus\MenuItem 10
App\Entity\Content\Pages\Page 7
App\Entity\Commerce\Products\QuantityType 2
App\Entity\Content\Menus\Menu 2
App\Entity\Commerce\Tax\Rate 1
App\Entity\Languages\Language 1