GET https://atozdrinks.cwd-mm.com/products/deluxe-white-chocolate

Query Metrics

26 Database Queries
13 Different statements
14.41 ms Query time
0 Invalid entities
62 Managed entities

Grouped Statements

Show all queries

Time Count Info
3.62 ms
(25.14%)
7
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
]
2.49 ms
(17.31%)
5
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
]
1.38 ms
(9.61%)
2
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
]
1.05 ms
(7.31%)
2
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"
]
0.89 ms
(6.15%)
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:
[]
0.83 ms
(5.78%)
2
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:
[]
0.80 ms
(5.53%)
1
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_.enabled AS enabled_6, c0_.description AS description_7, c0_.seo_title AS seo_title_8, c0_.seo_keywords AS seo_keywords_9, c0_.seo_description AS seo_description_10, c0_.primary_image_id AS primary_image_id_11 FROM commerce_products_product c0_ WHERE c0_.path = ? LIMIT 1
Parameters:
[
  "deluxe-white-chocolate"
]
0.74 ms
(5.17%)
1
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 c0_.product_id = ?
Parameters:
[
  494
]
0.67 ms
(4.64%)
1
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:
[]
0.62 ms
(4.29%)
1
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:
[]
0.48 ms
(3.30%)
1
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.filename AS filename_3, c0_.product_id AS product_id_4, c0_.variant_id AS variant_id_5 FROM commerce_products_image c0_ WHERE c0_.product_id = ?
Parameters:
[
  494
]
0.45 ms
(3.14%)
1
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
]
0.38 ms
(2.64%)
1
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
]

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 8
App\Entity\Content\Pages\Page 7
App\Entity\Commerce\Products\Variant 2
App\Entity\Content\Menus\Menu 2
App\Entity\Commerce\Products\Product 1
App\Entity\Commerce\Products\QuantityType 1
App\Entity\Commerce\Tax\Rate 1
App\Entity\Languages\Language 1