GET https://sw6staging.behr-labor.eu/navigation/00000dc0787e7e7e7e7e7e7e7e7e0001

Response
200 OK
IP
216.73.216.62
Profiled on
Token
16eb7c

Query Metrics

77 Database Queries
63 Different statements
53.10 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
5.91 ms
(11.14%) 		1 
# seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (seo_url.language_id = ?) AND (seo_url.sales_channel_id = ? OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0)
Parameters: 
[
  "/navigation/13a65f0962e64be9ab3210a371a2f790"
  "/navigation/17a3e1082a41422486b5cd8312b85338"
  "/navigation/ce8d2ea829eb4f068922ce8d9928aaf8"
  "/navigation/00000186a07e7e7e7e7e7e7e7e7e0001"
  "/navigation/000003d0907e7e7e7e7e7e7e7e7e0001"
  "/navigation/000006ddd07e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000493e07e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000057e407e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000668a07e7e7e7e7e7e7e7e7e0001"
  "/navigation/4d689ea4e1ee4be7a7ff17c3d1c2a9fd"
  "/navigation/0d5c0178b61f43409317ecb7f0423217"
  "/navigation/9f316991c7b843988ba2d691af81e051"
  "/navigation/b5f029ae393e42019d3c84d1745747d9"
  "/navigation/87329892f04642a091cf97d76cf2e172"
  "/navigation/d0c3ec10ad7f43eab1566c1442929e7b"
  "/navigation/405d1cbfa9ac40988230b3550335457d"
  "/navigation/fc1ec1df1e6e4f1a8143c5ba27bf4971"
  "/navigation/73d86ffcbaf24d1ead280925070a92d7"
  "/navigation/830789a628d847209c38fd4dede151ef"
  "/navigation/604b2db8d0664366b6b22358d17f7a59"
  "/navigation/3effeb8dc90a440cade956cd15571d2e"
  "/navigation/6a9710cbd4ef455d882138cc36089aed"
  "/navigation/13f58cf7fb2d4fdc8090e2d111219483"
  "/navigation/413ab9571e424278a787f8a4381c0c9f"
  "/navigation/853c3c6b6ffe47e2866acbc815d7ef0d"
  "/navigation/37e42c1a596f44aaa610954f0a82095e"
  "/navigation/0a500eeb24b74c4eab8e1982232bf4f7"
  "/navigation/0799bf2edc454c3287d633d9afd8d680"
  "/navigation/92bb5f4d67e84697841c730082f2bbda"
  "/navigation/1756c757bedb444bbacec61fc6f0c159"
  "/navigation/eb040e19715440c08c9806233a73f42a"
  "/navigation/d5f98579fc6a4def8a173f3cd4eb0c1f"
  "/navigation/d67ef9c439bf46b9976fd4c577abecc9"
  "/navigation/9fc9bc9065d44af9984985664c242443"
  "/navigation/3b0c1d5504484565a8bdced3ab2d3665"
  "/navigation/b90f87fb1a1c4230af629184792d84e3"
  "/navigation/eb51729977f44659b74712aad3e7e7a3"
  "/navigation/e907e8f1668c4fb4afe752ffe417a63e"
  "/navigation/f1b52c4932dc4ad590c5ee6ff62c87b7"
  "/navigation/88435e53e98c4d08877d9e13a9607c2a"
  "/navigation/00000249f07e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024be47e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024bee7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024bf87e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024c027e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024c0c7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024c167e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024dd87e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024de27e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024dec7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024df67e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024fcc7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024fd67e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000251c07e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000251ca7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000251d47e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000251de7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000251e37e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000251e87e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000251ed7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000251f27e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000251fc7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000252887e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000252927e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000253b47e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000253be7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000253c87e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000253d27e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000253e67e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000253eb7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000253f07e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000255a87e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000255b27e7e7e7e7e7e7e7e7e0001"
  "/navigation/000002579c7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000257a17e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000257a37e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000257a47e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000257b07e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000257ba7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000259907e7e7e7e7e7e7e7e7e0001"
  "/navigation/000002599a7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000259a47e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000259ae7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000025b847e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000025b8e7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000025b987e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000025d787e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000025d827e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000025f6c7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000025f767e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000261607e7e7e7e7e7e7e7e7e0001"
  "/navigation/000002616a7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000261747e7e7e7e7e7e7e7e7e0001"
  "/navigation/000002617e7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000261887e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000261927e7e7e7e7e7e7e7e7e0001"
  "/navigation/000002619c7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030d407e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030f347e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030f487e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030f4d7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030f4f7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030f527e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030f537e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030f547e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030f577e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030f5c7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030f987e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030fa27e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030fa77e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030fac7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030fb67e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030ffc7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000310067e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000310107e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000310607e7e7e7e7e7e7e7e7e0001"
  "/navigation/000003106a7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000311287e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000311327e7e7e7e7e7e7e7e7e0001"
  "/navigation/000003113c7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000311467e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000311487e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000311507e7e7e7e7e7e7e7e7e0001"
  "/navigation/000003115a7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000311647e7e7e7e7e7e7e7e7e0001"
  "/navigation/000003131c7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000313267e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000313307e7e7e7e7e7e7e7e7e0001"
  "/navigation/000003133a7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000313447e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000313467e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000315107e7e7e7e7e7e7e7e7e0001"
  "/navigation/000003151a7e7e7e7e7e7e7e7e7e0001"
  "/navigation/000003151f7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000315247e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000317047e7e7e7e7e7e7e7e7e0001"
  "/navigation/000003170e7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000317227e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000318f87e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000319027e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000319047e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000319077e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000031aec7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000031af67e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000031ce07e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000031cea7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000031cf47e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000031cfe7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000031d087e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000320c87e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000320d27e7e7e7e7e7e7e7e7e0001"
  "/navigation/000008b1807e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbba07e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbc047e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbc0e7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbc187e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbc227e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbc687e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbc727e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbc7c7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbc867e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbccc7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbcd67e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd307e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd3a7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd3f7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd447e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd497e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd4e7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd537e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd587e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd5d7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd627e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd947e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd9e7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbda87e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbdf87e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbe027e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbe0c7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbe207e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbe2a7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbe5c7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbe667e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbe707e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbec07e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbeca7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbed47e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbede7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbf247e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbf2e7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbf387e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbf427e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbf4c7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbf567e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbfec7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dc0007e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dc0507e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dc05a7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dc0647e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dc06e7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dc0787e7e7e7e7e7e7e7e7e0001"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"UÌð^UqNG©\x00úP$Âqì"
]
View formatted query    View runnable query    Explain query    View query backtrace
3.24 ms
(6.10%) 		1 
# header::currencies::search-ids
SELECT `currency`.`id` FROM `currency` LEFT JOIN `sales_channel_currency` `currency.salesChannels.mapping` ON `currency`.`id` = `currency.salesChannels.mapping`.`currency_id`  LEFT JOIN `sales_channel` `currency.salesChannels` ON `currency.salesChannels.mapping`.`sales_channel_id` = `currency.salesChannels`.`id`  WHERE (`currency.salesChannels`.`id` = ?) GROUP BY `currency`.`id`
Parameters: 
[
  b"UÌð^UqNG©\x00úP$Âqì"
]
View formatted query    View runnable query    Explain query    View query backtrace
3.15 ms
(5.94%) 		1 
SELECT LOWER(HEX(`category`.`parent_id`)) as `category-ids.key`, COUNT(`category`.`id`) as `category-ids.count`, COUNT(DISTINCT `category`.`id`) as `visible-children-count` FROM `category` WHERE (`category`.`version_id` = ?) AND ((`category`.`path` LIKE ? AND `category`.`level` = ? AND `category`.`active` = ? AND `category`.`visible` = ?)) GROUP BY `category`.`parent_id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  "%|c7b4532d41104fd9a780deeb543b5f2c|%"
  4
  true
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
3.10 ms
(5.84%) 		3 
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `swag_dynamic_access_category_rule` `category.swagDynamicAccessRules.mapping` ON `category`.`id` = `category.swagDynamicAccessRules.mapping`.`category_id`  AND `category`.`version_id` = `category.swagDynamicAccessRules.mapping`.`category_version_id` LEFT JOIN `rule` `category.swagDynamicAccessRules` ON `category.swagDynamicAccessRules.mapping`.`rule_id` = `category.swagDynamicAccessRules`.`id`  WHERE (`category`.`version_id` = ?) AND ((((`category.swagDynamicAccessRules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) OR `category.swagDynamicAccessRules`.`id` <=> ?))) AND (`category`.`id` IN (?, ?, ?)) GROUP BY `category`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01œ-º³2v„¸ø„’«Ä³ß"
  b"\t,¿}{¸Eχ\x1F‹ÃXG\x02\x1A"
  b",õ˜–¯fGX–슽\x03¬&¶"
  b"8X•p\x16dMä®HÀP\vóÌÈ"
  b"""
    <}’kjGþŽJâ\r\n
    ™4$
    """
  b"iàé\vÔMFY‰ˆyvu.ýü"
  b"á7Ž·€ŠG‘ž\rt\r]l\x1A"
  b"é+6oàÎI{›^+L*,°ö"
  b"úŸë8R\eLPŠù\x1Aúüøžª"
  b"&×\x15wãeIÈ‹pK¹ç÷9\x18"
  b"(Ê®u¥bO\r˜Z½\x0E³*¡`"
  b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-"
  b"q\x01,<[öA=ƒ¹bAä{ÙÝ"
  null
  b"\x00\x00\r» ~~~~~~~~~\x00\x01"
  b"\x00\x00\rÀP~~~~~~~~~\x00\x01"
  b"\x00\x00\rÀx~~~~~~~~~\x00\x01"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.88 ms
(5.42%) 		1 
# header::navigation::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category`.`cms_navigation_page_id` as `category.cmsNavigationPageId`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`file_hash` as `category.media.fileHash`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, `category.media.translation.title` as `category.media.title`, `category.media.translation.alt`, `category.media.translation.alt` as `category.media.alt`, `category.media.translation.customFields`, `category.media.translation.customFields` as `category.media.customFields`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.`language_id` = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (((`category`.`id` = ? OR (`category`.`path` LIKE ? AND (`category`.`level` > ? AND `category`.`level` <= ?)))))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"Ç´S-A\x10OÙ§€ÞëT;_,"
  "%|c7b4532d41104fd9a780deeb543b5f2c|%"
  1
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
2.39 ms
(4.50%) 		2 
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category`.`cms_navigation_page_id` as `category.cmsNavigationPageId`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x00\x00\r» ~~~~~~~~~\x00\x01"
  b"\x00\x00\rÀP~~~~~~~~~\x00\x01"
  b"\x00\x00\rÀx~~~~~~~~~\x00\x01"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.28 ms
(4.29%) 		2 
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `swag_dynamic_access_category_rule` `category.swagDynamicAccessRules.mapping` ON `category`.`id` = `category.swagDynamicAccessRules.mapping`.`category_id`  AND `category`.`version_id` = `category.swagDynamicAccessRules.mapping`.`category_version_id` LEFT JOIN `rule` `category.swagDynamicAccessRules` ON `category.swagDynamicAccessRules.mapping`.`rule_id` = `category.swagDynamicAccessRules`.`id`  WHERE (`category`.`version_id` = ?) AND ((((`category.swagDynamicAccessRules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) OR `category.swagDynamicAccessRules`.`id` <=> ?))) AND (`category`.`id` IN (?)) GROUP BY `category`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01œ-º³2v„¸ø„’«Ä³ß"
  b"\t,¿}{¸Eχ\x1F‹ÃXG\x02\x1A"
  b",õ˜–¯fGX–슽\x03¬&¶"
  b"8X•p\x16dMä®HÀP\vóÌÈ"
  b"""
    <}’kjGþŽJâ\r\n
    ™4$
    """
  b"iàé\vÔMFY‰ˆyvu.ýü"
  b"á7Ž·€ŠG‘ž\rt\r]l\x1A"
  b"é+6oàÎI{›^+L*,°ö"
  b"úŸë8R\eLPŠù\x1Aúüøžª"
  b"&×\x15wãeIÈ‹pK¹ç÷9\x18"
  b"(Ê®u¥bO\r˜Z½\x0E³*¡`"
  b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-"
  b"q\x01,<[öA=ƒ¹bAä{ÙÝ"
  null
  b"\x00\x00\rÀx~~~~~~~~~\x00\x01"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.99 ms
(3.76%) 		3 
# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND ((seo_path_info = ? OR seo_path_info = ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"UÌð^UqNG©\x00úP$Âqì"
  "Reinraum/ESD-Produkte/ESD-Zubehoer"
  "Reinraum/ESD-Produkte/ESD-Zubehoer/"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.29 ms
(2.43%) 		3 
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x01œ-º³2v„¸ø„’«Ä³ß"
  b"\t,¿}{¸Eχ\x1F‹ÃXG\x02\x1A"
  b",õ˜–¯fGX–슽\x03¬&¶"
  b"8X•p\x16dMä®HÀP\vóÌÈ"
  b"""
    <}’kjGþŽJâ\r\n
    ™4$
    """
  b"iàé\vÔMFY‰ˆyvu.ýü"
  b"á7Ž·€ŠG‘ž\rt\r]l\x1A"
  b"é+6oàÎI{›^+L*,°ö"
  b"úŸë8R\eLPŠù\x1Aúüøžª"
  b"&×\x15wãeIÈ‹pK¹ç÷9\x18"
  b"(Ê®u¥bO\r˜Z½\x0E³*¡`"
  b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-"
  b"q\x01,<[öA=ƒ¹bAä{ÙÝ"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.18 ms
(2.23%) 		2 
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`checkout_gateway_url` as `app.checkoutGatewayUrl`, `app`.`context_gateway_url` as `app.contextGatewayUrl`, `app`.`in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl`, `app`.`source_type` as `app.sourceType`, `app`.`source_config` as `app.sourceConfig`, `app`.`self_managed` as `app.selfManaged`, `app`.`requested_privileges` as `app.requestedPrivileges`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, `app.translation.label` as `app.label`, `app.translation.description`, `app.translation.description` as `app.description`, `app.translation.privacyPolicyExtensions`, `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`, `app.translation.customFields`, `app.translation.customFields` as `app.customFields` FROM `app` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` LEFT JOIN (SELECT `app.translation`.`app_id`, `app.translation`.`label` as `app.translation.label`, `app.translation`.`description` as `app.translation.description`, `app.translation`.`privacy_policy_extensions` as `app.translation.privacyPolicyExtensions`, `app.translation`.`custom_fields` as `app.translation.customFields` FROM `app_translation` `app.translation` WHERE `app.translation`.`language_id` = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` WHERE (`app`.`name` = ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  "mailcShopware6MailchimpIntegration"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.06 ms
(2.00%) 		1 
# seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (seo_url.language_id = ?) AND (seo_url.sales_channel_id = ? OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0)
Parameters: 
[
  "/navigation/c5d71ffef8bc453ea4c8ab3623de4362"
  "/navigation/afe8cf6121644961842962f6a7ae36e0"
  "/navigation/14c9d4116b8941cabfca749a05e63978"
  "/navigation/ad80da660e2c4003a8cfdff97972a983"
  "/navigation/17a3e1082a41422486b5cd8312b85338"
  "/navigation/87329892f04642a091cf97d76cf2e172"
  "/navigation/13f58cf7fb2d4fdc8090e2d111219483"
  "/navigation/0799bf2edc454c3287d633d9afd8d680"
  "/navigation/d67ef9c439bf46b9976fd4c577abecc9"
  "/navigation/b90f87fb1a1c4230af629184792d84e3"
  "/navigation/111390a861714935a97e5d8259f1f61d"
  "/navigation/7fd58b6848ad4d169d17ba7ab2651a20"
  "/navigation/70423ec9267541f781e3d811667d54e1"
  "/navigation/6667589a4a9a491d939b69471f41c449"
  "/navigation/55459d7a2dad4ebca1f0404340f003c8"
  "/navigation/5442042ebdad49dda1cc04c5839d340f"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"UÌð^UqNG©\x00úP$Âqì"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.96 ms
(1.80%) 		1 
# category::data::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category`.`cms_navigation_page_id` as `category.cmsNavigationPageId`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`file_hash` as `category.media.fileHash`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, `category.media.translation.title` as `category.media.title`, `category.media.translation.alt`, `category.media.translation.alt` as `category.media.alt`, `category.media.translation.customFields`, `category.media.translation.customFields` as `category.media.customFields`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.`language_id` = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x00\x00\rÀx~~~~~~~~~\x00\x01"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.92 ms
(1.74%) 		1 
# category::cms-page::association::sections::read
SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`version_id` as `cms_section.versionId`, `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`, `cms_section`.`position` as `cms_section.position`, `cms_section`.`type` as `cms_section.type`, `cms_section`.`locked` as `cms_section.locked`, `cms_section`.`name` as `cms_section.name`, `cms_section`.`sizing_mode` as `cms_section.sizingMode`, `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`, `cms_section`.`background_color` as `cms_section.backgroundColor`, `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`, `cms_section`.`css_class` as `cms_section.cssClass`, `cms_section`.`cms_page_id` as `cms_section.pageId`, `cms_section`.`visibility` as `cms_section.visibility`, `cms_section`.`custom_fields` as `cms_section.customFields`, `cms_section`.`created_at` as `cms_section.createdAt`, `cms_section`.`updated_at` as `cms_section.updatedAt`, `cms_section.swagCmsExtensionsScrollNavigation`.`id` as `cms_section.swagCmsExtensionsScrollNavigation.id`, `cms_section.swagCmsExtensionsScrollNavigation`.`active` as `cms_section.swagCmsExtensionsScrollNavigation.active`, `cms_section.swagCmsExtensionsScrollNavigation`.`cms_section_version_id` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSectionVersionId`, `cms_section.swagCmsExtensionsScrollNavigation`.`cms_section_id` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSectionId`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`id` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.id`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`version_id` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.versionId`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`cms_page_version_id` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.cmsPageVersionId`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`position` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.position`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`type` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.type`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`locked` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.locked`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`name` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.name`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`sizing_mode` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.sizingMode`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`mobile_behavior` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.mobileBehavior`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`background_color` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.backgroundColor`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`background_media_id` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.backgroundMediaId`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`background_media_mode` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.backgroundMediaMode`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`css_class` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.cssClass`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`cms_page_id` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.pageId`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`visibility` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.visibility`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`custom_fields` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.customFields`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`created_at` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.createdAt`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`updated_at` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.updatedAt`, `cms_section.swagCmsExtensionsScrollNavigation`.`created_at` as `cms_section.swagCmsExtensionsScrollNavigation.createdAt`, `cms_section.swagCmsExtensionsScrollNavigation`.`updated_at` as `cms_section.swagCmsExtensionsScrollNavigation.updatedAt`, `cms_section.swagCmsExtensionsScrollNavigation.translation.displayName`, `cms_section.swagCmsExtensionsScrollNavigation.translation.displayName` as `cms_section.swagCmsExtensionsScrollNavigation.displayName`, `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`config` as `cms_section.backgroundMedia.config`, `cms_section.backgroundMedia`.`path` as `cms_section.backgroundMedia.path`, `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`file_hash` as `cms_section.backgroundMedia.fileHash`, `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title`, `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt`, `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation.customFields` as `cms_section.backgroundMedia.customFields` FROM `cms_section` LEFT JOIN `swag_cms_extensions_scroll_navigation` `cms_section.swagCmsExtensionsScrollNavigation` ON `cms_section`.`id` = `cms_section.swagCmsExtensionsScrollNavigation`.`id` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN `cms_section` `cms_section.swagCmsExtensionsScrollNavigation.cmsSection` ON `cms_section.swagCmsExtensionsScrollNavigation`.`cms_section_id` = `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`id` AND `cms_section.swagCmsExtensionsScrollNavigation`.`cms_section_version_id` = `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`version_id` LEFT JOIN (SELECT `cms_section.swagCmsExtensionsScrollNavigation.translation`.`swag_cms_extensions_scroll_navigation_id`, `cms_section.swagCmsExtensionsScrollNavigation.translation`.`display_name` as `cms_section.swagCmsExtensionsScrollNavigation.translation.displayName` FROM `swag_cms_extensions_scroll_navigation_translation` `cms_section.swagCmsExtensionsScrollNavigation.translation` WHERE `cms_section.swagCmsExtensionsScrollNavigation.translation`.`language_id` = ?) `cms_section.swagCmsExtensionsScrollNavigation.swag_cms_extensions_scroll_navigation_translation` ON `cms_section.swagCmsExtensionsScrollNavigation.swag_cms_extensions_scroll_navigation_translation`.`swag_cms_extensions_scroll_navigation_id` = `cms_section.swagCmsExtensionsScrollNavigation`.`id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation`.`media_id`, `cms_section.backgroundMedia.translation`.`alt` as `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation`.`title` as `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.`custom_fields` as `cms_section.backgroundMedia.translation.customFields` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation`.`language_id` = ?) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id` WHERE (`cms_section`.`version_id` = ?) AND (((`cms_section`.`cms_page_id` IN (?))))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"""
    \n
    b¥F:5EfŽ‰@´J\x7Fl
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.92 ms
(1.73%) 		1 
# category::cms-page::association::sections::association::blocks::read
SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`version_id` as `cms_block.versionId`, `cms_block`.`cms_section_version_id` as `cms_block.cmsSectionVersionId`, `cms_block`.`position` as `cms_block.position`, `cms_block`.`type` as `cms_block.type`, `cms_block`.`locked` as `cms_block.locked`, `cms_block`.`name` as `cms_block.name`, `cms_block`.`section_position` as `cms_block.sectionPosition`, `cms_block`.`margin_top` as `cms_block.marginTop`, `cms_block`.`margin_bottom` as `cms_block.marginBottom`, `cms_block`.`margin_left` as `cms_block.marginLeft`, `cms_block`.`margin_right` as `cms_block.marginRight`, `cms_block`.`background_color` as `cms_block.backgroundColor`, `cms_block`.`background_media_id` as `cms_block.backgroundMediaId`, `cms_block`.`background_media_mode` as `cms_block.backgroundMediaMode`, `cms_block`.`css_class` as `cms_block.cssClass`, `cms_block`.`visibility` as `cms_block.visibility`, `cms_block`.`cms_section_id` as `cms_block.sectionId`, `cms_block`.`custom_fields` as `cms_block.customFields`, `cms_block`.`created_at` as `cms_block.createdAt`, `cms_block`.`updated_at` as `cms_block.updatedAt`, `cms_block.swagCmsExtensionsBlockRule`.`id` as `cms_block.swagCmsExtensionsBlockRule.id`, `cms_block.swagCmsExtensionsBlockRule`.`inverted` as `cms_block.swagCmsExtensionsBlockRule.inverted`, `cms_block.swagCmsExtensionsBlockRule`.`visibility_rule_id` as `cms_block.swagCmsExtensionsBlockRule.visibilityRuleId`, `cms_block.swagCmsExtensionsBlockRule`.`cms_block_id` as `cms_block.swagCmsExtensionsBlockRule.cmsBlockId`, `cms_block.swagCmsExtensionsBlockRule`.`cms_block_version_id` as `cms_block.swagCmsExtensionsBlockRule.cmsBlockVersionId`, `cms_block.swagCmsExtensionsBlockRule`.`created_at` as `cms_block.swagCmsExtensionsBlockRule.createdAt`, `cms_block.swagCmsExtensionsBlockRule`.`updated_at` as `cms_block.swagCmsExtensionsBlockRule.updatedAt`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`id` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.id`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`name` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.name`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`priority` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.priority`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`description` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.description`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`payload` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.payload`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`invalid` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.invalid`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`areas` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.areas`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`custom_fields` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.customFields`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`module_types` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.moduleTypes`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`created_at` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.createdAt`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`updated_at` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.updatedAt`, `cms_block.swagCmsExtensionsQuickview`.`id` as `cms_block.swagCmsExtensionsQuickview.id`, `cms_block.swagCmsExtensionsQuickview`.`active` as `cms_block.swagCmsExtensionsQuickview.active`, `cms_block.swagCmsExtensionsQuickview`.`cms_block_id` as `cms_block.swagCmsExtensionsQuickview.cmsBlockId`, `cms_block.swagCmsExtensionsQuickview`.`cms_block_version_id` as `cms_block.swagCmsExtensionsQuickview.cmsBlockVersionId`, `cms_block.swagCmsExtensionsQuickview`.`created_at` as `cms_block.swagCmsExtensionsQuickview.createdAt`, `cms_block.swagCmsExtensionsQuickview`.`updated_at` as `cms_block.swagCmsExtensionsQuickview.updatedAt`, `cms_block.backgroundMedia`.`id` as `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` as `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` as `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` as `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` as `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` as `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` as `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` as `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` as `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` as `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`config` as `cms_block.backgroundMedia.config`, `cms_block.backgroundMedia`.`path` as `cms_block.backgroundMedia.path`, `cms_block.backgroundMedia`.`private` as `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`file_hash` as `cms_block.backgroundMedia.fileHash`, `cms_block.backgroundMedia`.`created_at` as `cms_block.backgroundMedia.createdAt`, `cms_block.backgroundMedia`.`updated_at` as `cms_block.backgroundMedia.updatedAt`, `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation.title` as `cms_block.backgroundMedia.title`, `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation.alt` as `cms_block.backgroundMedia.alt`, `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation.customFields` as `cms_block.backgroundMedia.customFields` FROM `cms_block` LEFT JOIN `swag_cms_extensions_block_rule` `cms_block.swagCmsExtensionsBlockRule` ON `cms_block`.`id` = `cms_block.swagCmsExtensionsBlockRule`.`cms_block_id` LEFT JOIN `swag_cms_extensions_quickview` `cms_block.swagCmsExtensionsQuickview` ON `cms_block`.`id` = `cms_block.swagCmsExtensionsQuickview`.`cms_block_id` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN `rule` `cms_block.swagCmsExtensionsBlockRule.visibilityRule` ON `cms_block.swagCmsExtensionsBlockRule`.`visibility_rule_id` = `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation`.`media_id`, `cms_block.backgroundMedia.translation`.`alt` as `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation`.`title` as `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.`custom_fields` as `cms_block.backgroundMedia.translation.customFields` FROM `media_translation` `cms_block.backgroundMedia.translation` WHERE `cms_block.backgroundMedia.translation`.`language_id` = ?) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation`.`media_id` = `cms_block.backgroundMedia`.`id` WHERE (`cms_block`.`version_id` = ?) AND (((`cms_block`.`cms_section_id` IN (?))))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"ÎÖ—–^µB\t=ƒjbÿo?"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.90 ms
(1.69%) 		2 
# navigation-route::meta-information
            SELECT LOWER(HEX(`id`)), `path`, `level`
            FROM `category`
            WHERE `id` = ? OR `id` = ?
Parameters: 
[
  b"|Ï—V\x050LÜ»l´+š“ì¤"
  b"|Ï—V\x050LÜ»l´+š“ì¤"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.85 ms
(1.60%) 		1 
# category::cms-page::read
SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`version_id` as `cms_page.versionId`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`css_class` as `cms_page.cssClass`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`id` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.id`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`active` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.active`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`duration` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.duration`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`easing` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.easing`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`bouncy` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.bouncy`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`easing_degree` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.easingDegree`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`native_scrolling` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.nativeScrolling`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`cms_page_id` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPageId`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`cms_page_version_id` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPageVersionId`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`id` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.id`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`version_id` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.versionId`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`type` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.type`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`entity` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.entity`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`css_class` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.cssClass`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`config` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.config`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`preview_media_id` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.previewMediaId`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`locked` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.locked`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`created_at` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.createdAt`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`updated_at` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.updatedAt`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation.name`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation.name` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.name`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation.customFields`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation.customFields` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.customFields`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`created_at` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.createdAt`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`updated_at` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.updatedAt`, `cms_page.translation.name`, `cms_page.translation.name` as `cms_page.name`, `cms_page.translation.customFields`, `cms_page.translation.customFields` as `cms_page.customFields` FROM `cms_page` LEFT JOIN `swag_cms_extensions_scroll_navigation_page_settings` `cms_page.swagCmsExtensionsScrollNavigationPageSettings` ON `cms_page`.`id` = `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`id` LEFT JOIN (SELECT `cms_page.translation`.`cms_page_id`, `cms_page.translation`.`cms_page_version_id`, `cms_page.translation`.`name` as `cms_page.translation.name`, `cms_page.translation`.`custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.`language_id` = ?) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.`cms_page_version_id` = `cms_page`.`version_id` LEFT JOIN `cms_page` `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage` ON `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`cms_page_id` = `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`id` AND `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`cms_page_version_id` = `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`version_id` LEFT JOIN (SELECT `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation`.`cms_page_id`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation`.`cms_page_version_id`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation`.`name` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation.name`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation`.`custom_fields` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation.customFields` FROM `cms_page_translation` `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation` WHERE `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation`.`language_id` = ?) `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.cms_page_translation` ON `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.cms_page_translation`.`cms_page_id` = `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`id` AND `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.cms_page_translation`.`cms_page_version_id` = `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`version_id` WHERE (`cms_page`.`version_id` = ?) AND (`cms_page`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"""
    \n
    b¥F:5EfŽ‰@´J\x7Fl
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.83 ms
(1.56%) 		1 
SELECT
    LOWER(HEX(advanced_search_config.id)) AS id,
    advanced_search_config.and_logic AS andLogic,
    advanced_search_config.min_search_length AS minSearchLength,
    advanced_search_config.es_enabled AS esEnabled,
    advanced_search_config.hit_count AS hitCount,
    CONCAT(
        '[',
        GROUP_CONCAT(DISTINCT
                JSON_OBJECT(
                    'field', advanced_search_config_field.field,
                    'entity', advanced_search_config_field.entity,
                    'tokenize', advanced_search_config_field.tokenize,
                    'searchable', advanced_search_config_field.searchable,
                    'ranking', advanced_search_config_field.ranking
                )
            ),
        ']'
    ) as searchableFields
    FROM advanced_search_config
    LEFT JOIN advanced_search_config_field ON advanced_search_config_field.config_id = advanced_search_config.id AND advanced_search_config_field.searchable = 1
    WHERE advanced_search_config.sales_channel_id = ?
    GROUP BY advanced_search_config.id
Parameters: 
[
  b"UÌð^UqNG©\x00úP$Âqì"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.80 ms
(1.52%) 		1 
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category`.`cms_navigation_page_id` as `category.cmsNavigationPageId`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x00\x00\rÀx~~~~~~~~~\x00\x01"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.80 ms
(1.51%) 		2 
# seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (path_info = ?) AND (is_canonical = 1) LIMIT 1
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"UÌð^UqNG©\x00úP$Âqì"
  "/_esi/global/header"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.78 ms
(1.47%) 		4 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"UÌð^UqNG©\x00úP$Âqì"
  "sMTzTg46uR8STRVQlSzZF4uopXF2aDY6"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.74 ms
(1.39%) 		1 
# header::languages::search-ids
SELECT `language`.`id` FROM `language` LEFT JOIN `sales_channel_domain` `language.salesChannelDomains` ON `language`.`id` = `language.salesChannelDomains`.`language_id` LEFT JOIN `sales_channel_language` `language.salesChannels.mapping` ON `language`.`id` = `language.salesChannels.mapping`.`language_id`  LEFT JOIN `sales_channel` `language.salesChannels` ON `language.salesChannels.mapping`.`sales_channel_id` = `language.salesChannels`.`id`  WHERE (`language.salesChannelDomains`.`sales_channel_id` = ? AND `language.salesChannels`.`id` = ?) GROUP BY `language`.`id` ORDER BY MIN(`language`.`name`) ASC
Parameters: 
[
  b"UÌð^UqNG©\x00úP$Âqì"
  b"UÌð^UqNG©\x00úP$Âqì"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.71 ms
(1.34%) 		1 
# footer-pagelet::shipping-methods::read
SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`technical_name` as `shipping_method.technicalName`, `shipping_method`.`active` as `shipping_method.active`, `shipping_method`.`position` as `shipping_method.position`, `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` as `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` as `shipping_method.taxType`, `shipping_method`.`tax_id` as `shipping_method.taxId`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.media`.`id` as `shipping_method.media.id`, `shipping_method.media`.`user_id` as `shipping_method.media.userId`, `shipping_method.media`.`media_folder_id` as `shipping_method.media.mediaFolderId`, `shipping_method.media`.`mime_type` as `shipping_method.media.mimeType`, `shipping_method.media`.`file_extension` as `shipping_method.media.fileExtension`, `shipping_method.media`.`uploaded_at` as `shipping_method.media.uploadedAt`, `shipping_method.media`.`file_name` as `shipping_method.media.fileName`, `shipping_method.media`.`file_size` as `shipping_method.media.fileSize`, `shipping_method.media`.`media_type` as `shipping_method.media.mediaTypeRaw`, `shipping_method.media`.`meta_data` as `shipping_method.media.metaData`, `shipping_method.media`.`config` as `shipping_method.media.config`, `shipping_method.media`.`path` as `shipping_method.media.path`, `shipping_method.media`.`private` as `shipping_method.media.private`, `shipping_method.media`.`thumbnails_ro` as `shipping_method.media.thumbnailsRo`, `shipping_method.media`.`file_hash` as `shipping_method.media.fileHash`, `shipping_method.media`.`created_at` as `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`, `shipping_method.media.translation.title`, `shipping_method.media.translation.title` as `shipping_method.media.title`, `shipping_method.media.translation.alt`, `shipping_method.media.translation.alt` as `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, `shipping_method.media.translation.customFields` as `shipping_method.media.customFields`, `shipping_method.translation.name`, `shipping_method.translation.name` as `shipping_method.name`, `shipping_method.translation.description`, `shipping_method.translation.description` as `shipping_method.description`, `shipping_method.translation.trackingUrl`, `shipping_method.translation.trackingUrl` as `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, `shipping_method.translation.customFields` as `shipping_method.customFields` FROM `shipping_method` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name`, `shipping_method.translation`.`custom_fields` as `shipping_method.translation.customFields`, `shipping_method.translation`.`description` as `shipping_method.translation.description`, `shipping_method.translation`.`tracking_url` as `shipping_method.translation.trackingUrl` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.`media_id`, `shipping_method.media.translation`.`alt` as `shipping_method.media.translation.alt`, `shipping_method.media.translation`.`title` as `shipping_method.media.translation.title`, `shipping_method.media.translation`.`custom_fields` as `shipping_method.media.translation.customFields` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation`.`language_id` = ?) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"""
    ÿ%ù™XËI\n
    Ž+L(‹§Ö8
    """
  b"ér½þbWI2¹¡íÔ\x1C—ýƒ"
  b"µ®êØ~@NJº~âê~r1Ê"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.68 ms
(1.28%) 		1 
# theme-service::resolve-media::read
SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`file_hash` as `media.fileHash`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, `media.translation.title` as `media.title`, `media.translation.alt`, `media.translation.alt` as `media.alt`, `media.translation.customFields`, `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.`media_id`, `media.translation`.`alt` as `media.translation.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation`.`custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation`.`language_id` = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  false
  true
  "product_download"
  b"Ëö\x19¢­oK·¤;ãC‚ûÎ4"
  b"‰w³•¢+G+—“kÒ0&\x07"
  b"–g\x00è•/O8¶+Ãö\x05\x10d"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.64 ms
(1.20%) 		1 
# footer-pagelet::payment-methods::read
SELECT `payment_method`.`id` as `payment_method.id`, `payment_method`.`plugin_id` as `payment_method.pluginId`, `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`, `payment_method`.`position` as `payment_method.position`, `payment_method`.`active` as `payment_method.active`, `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`, `payment_method`.`media_id` as `payment_method.mediaId`, `payment_method`.`technical_name` as `payment_method.technicalName`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `payment_method.media`.`id` as `payment_method.media.id`, `payment_method.media`.`user_id` as `payment_method.media.userId`, `payment_method.media`.`media_folder_id` as `payment_method.media.mediaFolderId`, `payment_method.media`.`mime_type` as `payment_method.media.mimeType`, `payment_method.media`.`file_extension` as `payment_method.media.fileExtension`, `payment_method.media`.`uploaded_at` as `payment_method.media.uploadedAt`, `payment_method.media`.`file_name` as `payment_method.media.fileName`, `payment_method.media`.`file_size` as `payment_method.media.fileSize`, `payment_method.media`.`media_type` as `payment_method.media.mediaTypeRaw`, `payment_method.media`.`meta_data` as `payment_method.media.metaData`, `payment_method.media`.`config` as `payment_method.media.config`, `payment_method.media`.`path` as `payment_method.media.path`, `payment_method.media`.`private` as `payment_method.media.private`, `payment_method.media`.`thumbnails_ro` as `payment_method.media.thumbnailsRo`, `payment_method.media`.`file_hash` as `payment_method.media.fileHash`, `payment_method.media`.`created_at` as `payment_method.media.createdAt`, `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`, `payment_method.media.translation.title`, `payment_method.media.translation.title` as `payment_method.media.title`, `payment_method.media.translation.alt`, `payment_method.media.translation.alt` as `payment_method.media.alt`, `payment_method.media.translation.customFields`, `payment_method.media.translation.customFields` as `payment_method.media.customFields`, `payment_method.translation.name`, `payment_method.translation.name` as `payment_method.name`, `payment_method.translation.distinguishableName`, `payment_method.translation.distinguishableName` as `payment_method.distinguishableName`, `payment_method.translation.description`, `payment_method.translation.description` as `payment_method.description`, `payment_method.translation.customFields`, `payment_method.translation.customFields` as `payment_method.customFields` FROM `payment_method` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.translation`.`payment_method_id`, `payment_method.translation`.`name` as `payment_method.translation.name`, `payment_method.translation`.`distinguishable_name` as `payment_method.translation.distinguishableName`, `payment_method.translation`.`description` as `payment_method.translation.description`, `payment_method.translation`.`custom_fields` as `payment_method.translation.customFields` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.`language_id` = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.`media_id`, `payment_method.media.translation`.`alt` as `payment_method.media.translation.alt`, `payment_method.media.translation`.`title` as `payment_method.media.translation.title`, `payment_method.media.translation`.`custom_fields` as `payment_method.media.translation.customFields` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation`.`language_id` = ?) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ç\x05CL6@J\x11©§*Ù,vÛÔ"
  b"Í\ræmÌZC‹›\x08î퇮Ç\x00"
  b"\x13=ÇWŽeI«¢yº)øìøZ"
  b"ų{i¼'IZ‹¡”V&\x08é"
  b"1Å&÷ý=Dĵ´HV|7;)"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.60 ms
(1.14%) 		1 
# footer-pagelet::shipping-methods::search-ids
SELECT `shipping_method`.`id` FROM `shipping_method` LEFT JOIN `sales_channel_shipping_method` `shipping_method.salesChannels.mapping` ON `shipping_method`.`id` = `shipping_method.salesChannels.mapping`.`shipping_method_id`  LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `sales_channel` `shipping_method.salesChannels` ON `shipping_method.salesChannels.mapping`.`sales_channel_id` = `shipping_method.salesChannels`.`id`  WHERE (`shipping_method`.`active` = ? AND `shipping_method.salesChannels`.`id` = ?) GROUP BY `shipping_method`.`id` ORDER BY MIN(`shipping_method`.`position`) ASC, MIN(COALESCE(`shipping_method.translation.name`)) ASC
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  b"UÌð^UqNG©\x00úP$Âqì"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.60 ms
(1.12%) 		1 
# category::cms-page::association::sections::association::blocks::association::slots::read
SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `cms_slot`.`type` as `cms_slot.type`, `cms_slot`.`slot` as `cms_slot.slot`, `cms_slot`.`locked` as `cms_slot.locked`, `cms_slot`.`cms_block_id` as `cms_slot.blockId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.swagCmsExtensionsForm`.`id` as `cms_slot.swagCmsExtensionsForm.id`, `cms_slot.swagCmsExtensionsForm`.`cms_slot_id` as `cms_slot.swagCmsExtensionsForm.cmsSlotId`, `cms_slot.swagCmsExtensionsForm`.`cms_slot_version_id` as `cms_slot.swagCmsExtensionsForm.cmsSlotVersionId`, `cms_slot.swagCmsExtensionsForm`.`is_template` as `cms_slot.swagCmsExtensionsForm.isTemplate`, `cms_slot.swagCmsExtensionsForm`.`technical_name` as `cms_slot.swagCmsExtensionsForm.technicalName`, `cms_slot.swagCmsExtensionsForm`.`mail_template_id` as `cms_slot.swagCmsExtensionsForm.mailTemplateId`, `cms_slot.swagCmsExtensionsForm`.`created_at` as `cms_slot.swagCmsExtensionsForm.createdAt`, `cms_slot.swagCmsExtensionsForm`.`updated_at` as `cms_slot.swagCmsExtensionsForm.updatedAt`, `cms_slot.swagCmsExtensionsForm.translation.title`, `cms_slot.swagCmsExtensionsForm.translation.title` as `cms_slot.swagCmsExtensionsForm.title`, `cms_slot.swagCmsExtensionsForm.translation.successMessage`, `cms_slot.swagCmsExtensionsForm.translation.successMessage` as `cms_slot.swagCmsExtensionsForm.successMessage`, `cms_slot.swagCmsExtensionsForm.translation.receivers`, `cms_slot.swagCmsExtensionsForm.translation.receivers` as `cms_slot.swagCmsExtensionsForm.receivers`, `cms_slot.translation.config`, `cms_slot.translation.config` as `cms_slot.config`, `cms_slot.translation.customFields`, `cms_slot.translation.customFields` as `cms_slot.customFields` FROM `cms_slot` LEFT JOIN `swag_cms_extensions_form` `cms_slot.swagCmsExtensionsForm` ON `cms_slot`.`id` = `cms_slot.swagCmsExtensionsForm`.`cms_slot_id` LEFT JOIN (SELECT `cms_slot.translation`.`cms_slot_id`, `cms_slot.translation`.`cms_slot_version_id`, `cms_slot.translation`.`config` as `cms_slot.translation.config`, `cms_slot.translation`.`custom_fields` as `cms_slot.translation.customFields` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation`.`language_id` = ?) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` AND `cms_slot.cms_slot_translation`.`cms_slot_version_id` = `cms_slot`.`version_id` LEFT JOIN (SELECT `cms_slot.swagCmsExtensionsForm.translation`.`swag_cms_extensions_form_id`, `cms_slot.swagCmsExtensionsForm.translation`.`title` as `cms_slot.swagCmsExtensionsForm.translation.title`, `cms_slot.swagCmsExtensionsForm.translation`.`success_message` as `cms_slot.swagCmsExtensionsForm.translation.successMessage`, `cms_slot.swagCmsExtensionsForm.translation`.`receivers` as `cms_slot.swagCmsExtensionsForm.translation.receivers` FROM `swag_cms_extensions_form_translation` `cms_slot.swagCmsExtensionsForm.translation` WHERE `cms_slot.swagCmsExtensionsForm.translation`.`language_id` = ?) `cms_slot.swagCmsExtensionsForm.swag_cms_extensions_form_translation` ON `cms_slot.swagCmsExtensionsForm.swag_cms_extensions_form_translation`.`swag_cms_extensions_form_id` = `cms_slot.swagCmsExtensionsForm`.`id` WHERE (`cms_slot`.`version_id` = ?) AND (((`cms_slot`.`cms_block_id` IN (?, ?))))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"sMVú\x08%L\x04„MU²²‰pÑ"
  b"¸Æ™”ŠðL\x07¸(⛁CMu"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.60 ms
(1.12%) 		1 
SELECT
    `theme_id`,
    `technical_name`,
    `resolved_config`,
    `view_inheritance`,
    `script_files`,
    `icon_sets`,
    `updated_at`
    FROM `theme_runtime_config`
    WHERE `theme_id` = ?
Parameters: 
[
  b"5™\x11í›\eDHÔºñÝĨç"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.59 ms
(1.11%) 		1 
# breadcrumb-extension::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category`.`cms_navigation_page_id` as `category.cmsNavigationPageId`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x00\x00\r» ~~~~~~~~~\x00\x01"
  b"\x00\x00\rÀP~~~~~~~~~\x00\x01"
  b"\x00\x00\rÀx~~~~~~~~~\x00\x01"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.59 ms
(1.11%) 		1 
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `swag_dynamic_access_category_rule` `category.swagDynamicAccessRules.mapping` ON `category`.`id` = `category.swagDynamicAccessRules.mapping`.`category_id`  AND `category`.`version_id` = `category.swagDynamicAccessRules.mapping`.`category_version_id` LEFT JOIN `rule` `category.swagDynamicAccessRules` ON `category.swagDynamicAccessRules.mapping`.`rule_id` = `category.swagDynamicAccessRules`.`id`  WHERE (`category`.`version_id` = ?) AND ((((`category.swagDynamicAccessRules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) OR `category.swagDynamicAccessRules`.`id` <=> ?))) AND (`category`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY `category`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01œ-º³2v„¸ø„’«Ä³ß"
  b"\t,¿}{¸Eχ\x1F‹ÃXG\x02\x1A"
  b",õ˜–¯fGX–슽\x03¬&¶"
  b"8X•p\x16dMä®HÀP\vóÌÈ"
  b"""
    <}’kjGþŽJâ\r\n
    ™4$
    """
  b"iàé\vÔMFY‰ˆyvu.ýü"
  b"á7Ž·€ŠG‘ž\rt\r]l\x1A"
  b"é+6oàÎI{›^+L*,°ö"
  b"úŸë8R\eLPŠù\x1Aúüøžª"
  b"&×\x15wãeIÈ‹pK¹ç÷9\x18"
  b"(Ê®u¥bO\r˜Z½\x0E³*¡`"
  b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-"
  b"q\x01,<[öA=ƒ¹bAä{ÙÝ"
  null
  b"\vgF‚Ï\x06G¡»A*×ófÄ’"
  b"\x1E(|\x15<ÒB[¨\x10\x1DUÛ£’œ"
  b"TB\x04.½­IÝ¡Ì\x04ѝ4\x0F"
  b"UEz-­N¼¡ð@C@ð\x03È"
  b"fgXšJšI\x1D“›iG\x1FAÄI"
  b"n#Â\fg\x1CI:€€e!±\x00¿©"
  b"pB>É&uA÷ãØ\x11f}Tá"
  b"zÌDJ|\x03Mè©Z\x07\x0FQ\x13ý-"
  b"\x7FÕ‹hH­M\x16\x17ºz²e\x1A "
  b"„\x0FfXHøFìƒ/KeW¿Zi"
  b"ˆÖþ?Æ·Nä½]æ±³÷ó"
  b"­€Úf\x0E,@\x03¨Ïßùyr©ƒ"
  b"Å×\x1Fþø¼E>¤È«6#ÞCb"
  b"Öx@\x08©[GK½‰D_ê\x17¤N"
  b"ÛζNkÞE%º†¢Pt.õ\x10"
  b"ìãeQÓ\x11NŽ·j;'P\x10"
  b"úä²6RÄN¾˜Ž‹\^X§#"
  b"Ç´S-A\x10OÙ§€ÞëT;_,"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(1.08%) 		1 
# seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN (?, ?, ?)) AND (seo_url.language_id = ?) AND (seo_url.sales_channel_id = ? OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0)
Parameters: 
[
  "/navigation/00000dc0787e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbba07e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dc0507e7e7e7e7e7e7e7e7e0001"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"UÌð^UqNG©\x00úP$Âqì"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.54 ms
(1.02%) 		1 
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`active` as `language.active`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.name`, `language.locale.translation.name` as `language.locale.name`, `language.locale.translation.territory`, `language.locale.translation.territory` as `language.locale.territory`, `language.locale.translation.customFields`, `language.locale.translation.customFields` as `language.locale.customFields` FROM `language` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.locale.translation`.`locale_id`, `language.locale.translation`.`name` as `language.locale.translation.name`, `language.locale.translation`.`territory` as `language.locale.translation.territory`, `language.locale.translation`.`custom_fields` as `language.locale.translation.customFields` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation`.`language_id` = ?) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE `language`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.53 ms
(1.00%) 		1 
SELECT `acris_search_product_pushing`.`id` as `acris_search_product_pushing.id`, `acris_search_product_pushing`.`name` as `acris_search_product_pushing.name`, `acris_search_product_pushing`.`active` as `acris_search_product_pushing.active`, `acris_search_product_pushing`.`type` as `acris_search_product_pushing.type`, `acris_search_product_pushing`.`search_term_matching` as `acris_search_product_pushing.searchTermMatching`, `acris_search_product_pushing`.`factor` as `acris_search_product_pushing.factor`, `acris_search_product_pushing`.`created_at` as `acris_search_product_pushing.createdAt`, `acris_search_product_pushing`.`updated_at` as `acris_search_product_pushing.updatedAt`, (SELECT GROUP_CONCAT(HEX(`acris_search_product_pushing.productStream.mapping`.`product_stream_id`) SEPARATOR '||')
                  FROM `acris_search_product_pushing_stream` `acris_search_product_pushing.productStream.mapping`
                  WHERE `acris_search_product_pushing.productStream.mapping`.`search_product_pushing_id` = `acris_search_product_pushing`.`id` ) as `acris_search_product_pushing.productStream.id_mapping` FROM `acris_search_product_pushing` WHERE `acris_search_product_pushing`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"+êJbu‡E¶OϽ§‘ëÿ"
  b"8êÊ•i×F~«\x14¥#\x0FÌmz"
  b"9¸2b\x0FŒB5†\x03ºC¿7·×"
  b"GhW½–¹N\x05¼¸`\x18@ÚBî"
  b"HIH&:ª@¬½ùQŽ~Öed"
  b"WO)ÆELZŽ¹îm\x11{ƒý"
  b"—“ìõ\x7F´Mk˜„ j?öéè"
  b"žÄm'!vOHµy4\x18pV]T"
  b"Èüû\x15\x02tOh£ê“fTÊ\fæ"
  b"Ïï§K‘ÜEd¦LbDŒ\x15"‚"
  b"áŸ0Üc©EŠ»€œ\x10ü'¹e"
  b"ù«e\x00P¾Hö“'xÅW6Æõ"
  b"úõ*dÒMDÅ•HÈ\vÉz~E"
  b"ÿ‘l©›¿H…³²PP\t\x06ò\x0E"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.50 ms
(0.93%) 		1 
# header::languages::read
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`active` as `language.active`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.translationCode`.`id` as `language.translationCode.id`, `language.translationCode`.`code` as `language.translationCode.code`, `language.translationCode`.`created_at` as `language.translationCode.createdAt`, `language.translationCode`.`updated_at` as `language.translationCode.updatedAt`, `language.translationCode.translation.name`, `language.translationCode.translation.name` as `language.translationCode.name`, `language.translationCode.translation.territory`, `language.translationCode.translation.territory` as `language.translationCode.territory`, `language.translationCode.translation.customFields`, `language.translationCode.translation.customFields` as `language.translationCode.customFields` FROM `language` LEFT JOIN `locale` `language.translationCode` ON `language`.`translation_code_id` = `language.translationCode`.`id` LEFT JOIN (SELECT `language.translationCode.translation`.`locale_id`, `language.translationCode.translation`.`name` as `language.translationCode.translation.name`, `language.translationCode.translation`.`territory` as `language.translationCode.translation.territory`, `language.translationCode.translation`.`custom_fields` as `language.translationCode.translation.customFields` FROM `locale_translation` `language.translationCode.translation` WHERE `language.translationCode.translation`.`language_id` = ?) `language.translationCode.locale_translation` ON `language.translationCode.locale_translation`.`locale_id` = `language.translationCode`.`id` WHERE `language`.`id` IN (?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"SC(\rúÚO\x13¸~¦m5¶ü."
  b"ü¯™I#2NT£ÒO\x16ÿÝ0K"
  b"í¦!§~bE8–³ÄVاý"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.49 ms
(0.93%) 		1 
# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.46 ms
(0.86%) 		1 
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters: 
[
  "de-DE"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.45 ms
(0.85%) 		1 
# header::currencies::read
SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.shortName`, `currency.translation.shortName` as `currency.shortName`, `currency.translation.name`, `currency.translation.name` as `currency.name`, `currency.translation.customFields`, `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation`.`currency_id`, `currency.translation`.`short_name` as `currency.translation.shortName`, `currency.translation`.`name` as `currency.translation.name`, `currency.translation`.`custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.`language_id` = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.43 ms
(0.82%) 		1 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.42 ms
(0.79%) 		1 
# footer-pagelet::payment-methods::search-ids
SELECT `payment_method`.`id` FROM `payment_method` LEFT JOIN `sales_channel_payment_method` `payment_method.salesChannels.mapping` ON `payment_method`.`id` = `payment_method.salesChannels.mapping`.`payment_method_id`  LEFT JOIN `sales_channel` `payment_method.salesChannels` ON `payment_method.salesChannels.mapping`.`sales_channel_id` = `payment_method.salesChannels`.`id`  WHERE (`payment_method`.`active` = ? AND `payment_method.salesChannels`.`id` = ?) GROUP BY `payment_method`.`id` ORDER BY MIN(`payment_method`.`position`) ASC
Parameters: 
[
  true
  b"UÌð^UqNG©\x00úP$Âqì"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.41 ms
(0.77%) 		1 
SELECT `product_stream`.`id` as `product_stream.id`, `product_stream`.`api_filter` as `product_stream.apiFilter`, `product_stream`.`invalid` as `product_stream.invalid`, `product_stream`.`created_at` as `product_stream.createdAt`, `product_stream`.`updated_at` as `product_stream.updatedAt`, `product_stream.translation.name`, `product_stream.translation.name` as `product_stream.name`, `product_stream.translation.description`, `product_stream.translation.description` as `product_stream.description`, `product_stream.translation.customFields`, `product_stream.translation.customFields` as `product_stream.customFields` FROM `product_stream` LEFT JOIN (SELECT `product_stream.translation`.`product_stream_id`, `product_stream.translation`.`name` as `product_stream.translation.name`, `product_stream.translation`.`description` as `product_stream.translation.description`, `product_stream.translation`.`custom_fields` as `product_stream.translation.customFields` FROM `product_stream_translation` `product_stream.translation` WHERE `product_stream.translation`.`language_id` = ?) `product_stream.product_stream_translation` ON `product_stream.product_stream_translation`.`product_stream_id` = `product_stream`.`id` WHERE `product_stream`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"rÖ"`qÝ@J±ðm‹]=JJ"
  b"""
    Ã\n
    BrJéL\x140[R\x05\x04­‰
    """
  b"\rAfÀ\x07N‡¼¨òz–g%Ž"
  b"Ô#n€uÂO\n¡O¼\x00å§ÒÏ"
  b"üo{#cóN°¬Lèȼ„œ€"
  b"KÀ«\eƒÑL{Šx2J¨\x16\\x19"
  b"""
    Ã\n
    BrJéL\x140[R\x05\x04­‰
    """
  b"$½žùzÏI«¼. f…@ý“"
  b"å";G¥pH\x04·©\e Ïv\x06´"
  b"IÍklç¤L ¿» ¥ŠZR"
  b"ZSÉ\x18fJf—U`‡\føˆÙ"
  b"ñÜoUä"EÅŽ¤"þ÷+\x02\v"
  b"ÙÑÓGmþI»¦\x02\x14—y\x7F\x13"
  b"ZqË4¼/Nœ„O‚{¬ýN^"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(0.74%) 		1 
SELECT `acris_search_product_restriction`.`id` FROM `acris_search_product_restriction` LEFT JOIN `acris_search_restriction_cat` `acris_search_product_restriction.categories.mapping` ON `acris_search_product_restriction`.`id` = `acris_search_product_restriction.categories.mapping`.`search_product_restriction_id`  LEFT JOIN `acris_search_restriction_rule` `acris_search_product_restriction.rules.mapping` ON `acris_search_product_restriction`.`id` = `acris_search_product_restriction.rules.mapping`.`search_product_restriction_id`  LEFT JOIN `category` `acris_search_product_restriction.categories` ON `acris_search_product_restriction.categories.mapping`.`category_id` = `acris_search_product_restriction.categories`.`id`  LEFT JOIN `rule` `acris_search_product_restriction.rules` ON `acris_search_product_restriction.rules.mapping`.`rule_id` = `acris_search_product_restriction.rules`.`id`  WHERE ((`acris_search_product_restriction`.`active` = ? AND (`acris_search_product_restriction`.`type` = ? OR `acris_search_product_restriction`.`type` = ?) AND (`acris_search_product_restriction.categories`.`id` <=> ? OR (`acris_search_product_restriction.categories`.`id` IN (?))) AND ((`acris_search_product_restriction.rules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) OR `acris_search_product_restriction.rules`.`id` <=> ?))) GROUP BY `acris_search_product_restriction`.`id`
Parameters: 
[
  true
  "all"
  "listing"
  null
  b"\x00\x00\rÀx~~~~~~~~~\x00\x01"
  b"\x01œ-º³2v„¸ø„’«Ä³ß"
  b"\t,¿}{¸Eχ\x1F‹ÃXG\x02\x1A"
  b",õ˜–¯fGX–슽\x03¬&¶"
  b"8X•p\x16dMä®HÀP\vóÌÈ"
  b"""
    <}’kjGþŽJâ\r\n
    ™4$
    """
  b"iàé\vÔMFY‰ˆyvu.ýü"
  b"á7Ž·€ŠG‘ž\rt\r]l\x1A"
  b"é+6oàÎI{›^+L*,°ö"
  b"úŸë8R\eLPŠù\x1Aúüøžª"
  b"&×\x15wãeIÈ‹pK¹ç÷9\x18"
  b"(Ê®u¥bO\r˜Z½\x0E³*¡`"
  b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-"
  b"q\x01,<[öA=ƒ¹bAä{ÙÝ"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(0.68%) 		1 
# category::data::association::translations::read
SELECT `category_translation`.`name` as `category_translation.name`, `category_translation`.`breadcrumb` as `category_translation.breadcrumb`, `category_translation`.`slot_config` as `category_translation.slotConfig`, `category_translation`.`link_type` as `category_translation.linkType`, `category_translation`.`internal_link` as `category_translation.internalLink`, `category_translation`.`external_link` as `category_translation.externalLink`, `category_translation`.`link_new_tab` as `category_translation.linkNewTab`, `category_translation`.`description` as `category_translation.description`, `category_translation`.`meta_title` as `category_translation.metaTitle`, `category_translation`.`meta_description` as `category_translation.metaDescription`, `category_translation`.`keywords` as `category_translation.keywords`, `category_translation`.`custom_fields` as `category_translation.customFields`, `category_translation`.`created_at` as `category_translation.createdAt`, `category_translation`.`updated_at` as `category_translation.updatedAt`, `category_translation`.`category_id` as `category_translation.categoryId`, `category_translation`.`language_id` as `category_translation.languageId`, `category_translation`.`category_version_id` as `category_translation.categoryVersionId` FROM `category_translation` WHERE (`category_translation`.`category_version_id` = ?) AND (((`category_translation`.`category_id` IN (?))))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x00\x00\rÀx~~~~~~~~~\x00\x01"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(0.68%) 		1 
SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.translation.label`, `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.`product_sorting_id`, `product_sorting.translation`.`label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.`language_id` = ?) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Ë›1 è¯Jx°\x0F¨¾=Ö\f1"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(0.68%) 		1 
SELECT `acris_search_product_pushing`.`id` FROM `acris_search_product_pushing` LEFT JOIN `acris_search_product_pushing_rule` `acris_search_product_pushing.rules.mapping` ON `acris_search_product_pushing`.`id` = `acris_search_product_pushing.rules.mapping`.`search_product_pushing_id`  LEFT JOIN `rule` `acris_search_product_pushing.rules` ON `acris_search_product_pushing.rules.mapping`.`rule_id` = `acris_search_product_pushing.rules`.`id`  WHERE ((`acris_search_product_pushing`.`active` = ? AND (`acris_search_product_pushing`.`type` = ? OR `acris_search_product_pushing`.`type` = ?) AND ((`acris_search_product_pushing.rules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) OR `acris_search_product_pushing.rules`.`id` <=> ?))) GROUP BY `acris_search_product_pushing`.`id`
Parameters: 
[
  true
  "all"
  "listing"
  b"\x01œ-º³2v„¸ø„’«Ä³ß"
  b"\t,¿}{¸Eχ\x1F‹ÃXG\x02\x1A"
  b",õ˜–¯fGX–슽\x03¬&¶"
  b"8X•p\x16dMä®HÀP\vóÌÈ"
  b"""
    <}’kjGþŽJâ\r\n
    ™4$
    """
  b"iàé\vÔMFY‰ˆyvu.ýü"
  b"á7Ž·€ŠG‘ž\rt\r]l\x1A"
  b"é+6oàÎI{›^+L*,°ö"
  b"úŸë8R\eLPŠù\x1Aúüøžª"
  b"&×\x15wãeIÈ‹pK¹ç÷9\x18"
  b"(Ê®u¥bO\r˜Z½\x0E³*¡`"
  b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-"
  b"q\x01,<[öA=ƒ¹bAä{ÙÝ"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
0.35 ms
(0.65%) 		1 
# product-listing::load-sortings::read
SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.translation.label`, `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.`product_sorting_id`, `product_sorting.translation`.`label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.`language_id` = ?) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Ë›1 è¯Jx°\x0F¨¾=Ö\f1"
  b"VO(U¢IMä¡vÿ\x1C\x00<C"
  b"aüÕ\f_\x07N“”\x05³c.\x13(y"
  b"¬a–˜\x10öJíµ?ËeþÊ[Ž"
  b"\x16 nÄý¼Fû¹"vÈm’\x00a"
  b" ”#л2CuŽ¯rç%•\e+"
  b"\x14\x1Eƒæ˜\fJô„@#yFS3\x12"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.34 ms
(0.65%) 		1 
SELECT `language`.`id` FROM `language` WHERE `language`.`id` IN (?) LIMIT 1
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.62%) 		1 
SELECT `sales_channel_country`.`sales_channel_id`, `sales_channel_country`.`country_id` FROM `sales_channel_country` WHERE (`sales_channel_country`.`sales_channel_id` = ? AND `sales_channel_country`.`country_id` = ?)
Parameters: 
[
  b"UÌð^UqNG©\x00úP$Âqì"
  b"/NñAš(Bû©tûÓëE:{"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(0.59%) 		1 
SELECT COUNT(DISTINCT `category`.`id`) as `categories` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x00\x00\r» ~~~~~~~~~\x00\x01"
  b"\x00\x00\rÀP~~~~~~~~~\x00\x01"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.28 ms
(0.53%) 		1 
SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(0.49%) 		1 
SELECT `app`.`name`, `app`.`version`, `app`.`template_load_priority`
             FROM `app`
             INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id`
             WHERE `app`.`active` = 1 AND `app_template`.`active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(0.48%) 		1 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.24 ms
(0.45%) 		1 
SELECT `acl_role`.`privileges` AS `privileges`
            FROM `acl_role`
            INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
            WHERE `app`.`id` = ?
Parameters: 
[
  b"\x01›\x12(`µpþƒG\x07\x0FˆŽÕE"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.24 ms
(0.44%) 		1 
SELECT path FROM category WHERE id = ?
Parameters: 
[
  b"\x00\x00\rÀx~~~~~~~~~\x00\x01"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(0.43%) 		1 
# product-listing::load-sortings::search-ids
SELECT `product_sorting`.`id` FROM `product_sorting` WHERE (`product_sorting`.`active` = ?) ORDER BY `product_sorting`.`priority` DESC
Parameters: 
[
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.22 ms
(0.42%) 		1 
# product-listing-route::category-loading::search-ids
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?)) LIMIT 1
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x00\x00\rÀx~~~~~~~~~\x00\x01"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.22 ms
(0.41%) 		1 
SELECT
    `theme_id`,
    `technical_name`,
    `resolved_config`,
    `view_inheritance`,
    `script_files`,
    `icon_sets`,
    `updated_at`
    FROM `theme_runtime_config`
    WHERE `technical_name` = ?
Parameters: 
[
  "BehrTheme"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.22 ms
(0.41%) 		1 
SELECT `handler_identifier`, LOWER(HEX(`id`)) FROM `payment_method`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.22 ms
(0.41%) 		1 
SELECT url FROM sales_channel_domain
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.21 ms
(0.39%) 		1 
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"Ç´S-A\x10OÙ§€ÞëT;_,"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(0.38%) 		1 
SELECT LOWER(HEX(assoc.`sales_channel_id`))
                FROM `sales_channel_payment_method` AS assoc
                    LEFT JOIN `payment_method` AS pm
                        ON pm.`id` = assoc.`payment_method_id`
                WHERE
                    assoc.`payment_method_id` = ? AND
                    pm.`active` = 1
Parameters: 
[
  b"ç\x05CL6@J\x11©§*Ù,vÛÔ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(0.37%) 		1 
SELECT DISTINCT `technical_name`
    FROM `theme_runtime_config`
    WHERE `technical_name` IS NOT NULL
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.18 ms
(0.34%) 		1 
# product-listing-route::category-loading::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`product_stream_id` as `category.productStreamId` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x00\x00\rÀx~~~~~~~~~\x00\x01"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.18 ms
(0.33%) 		1 
SELECT `name`, `path`, `author`, `self_managed`
                FROM `app`
                WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.25%) 		1 
SELECT `min_search_length` FROM `product_search_config` WHERE `language_id` = ?
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.