GET https://devel.mplusm.de/navigation/32956a3d7fe040349e0589460051bb2a

Response
200 OK
Browse referrer URL
IP
216.73.216.213
Profiled on
Token
556727

Query Metrics

663 Database Queries
69 Different statements
442.99 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
102.81 ms
(23.21%) 		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/32956a3d7fe040349e0589460051bb2a"
  "/navigation/4912bdd9d4c042098b5e9e7478cd9dd6"
  "/navigation/c80366c5226f45ac82449e3a3f0b8554"
  "/navigation/018a986c0c4a723b83d5960ccff667f5"
  "/navigation/5823b6e8cb914633acc74170f3c77f02"
  "/navigation/dd140f7d0b994c06b023ee7cde2201a4"
  "/navigation/76b109f7f2d44034a0c0447f671a4503"
  "/navigation/3bddd8e8619e40cf91ff1518c797d4bf"
  "/navigation/dc41fb6b09814c76b08c03e40fe5eb0a"
  "/navigation/5c48d65e3c4e4e27b4df712e66aed602"
  "/navigation/1ac4c3cf38f44ae39135cd3e4567d36a"
  "/navigation/385ba29df28849b088bb29f6d9dce9c5"
  "/navigation/444fabf3549f413ba0fdf72cc4b885c9"
  "/navigation/4b854ba426344e1b9ff3da51fa8ecf23"
  "/navigation/7dd915fb41ee4ff2a21378afb1b6ce37"
  "/navigation/cb9ff02bc6e14c4c989c21af04a3786a"
  "/navigation/61fe82c5fb5b4e2cb5299f1e987d20d4"
  "/navigation/cf8b7678f7854fcdbb9d97123f07e8dd"
  "/navigation/d3e0eb6222134422b7281c6751c1fc6c"
  "/navigation/b82de77f91e74a0c98811854bc0b3a7c"
  "/navigation/ee45615539294876a9c21bdbd866c7f4"
  "/navigation/dd6902bc5e0245899ab4837358e372d3"
  "/navigation/019cae10fe3c7485baa1c77e9db41fde"
  "/navigation/0077b6e61bb34418affe5490289418ab"
  "/navigation/01931f4d0e4e762a9e2371e1d626d12c"
  "/navigation/019897dd94a27c8ea23dff42540848c8"
  "/navigation/04e5f5b673f847a089cbed532321dfc4"
  "/navigation/086b89f81e8c4a05a59b1068210db735"
  "/navigation/13fc36da34a1482f87f736af8cc0ef60"
  "/navigation/25171e8aa3114ccf8f010554b0386ee5"
  "/navigation/26e7ffd6ef8244ba90a8555f68683eb5"
  "/navigation/2c3253cb458b4dd9916196a5891b4dd9"
  "/navigation/338d19185ae342f3acdfec0f23ebb4fb"
  "/navigation/4af44b3637fe437087030cf990ce693d"
  "/navigation/ad3da067904c461baba07391c0f023e5"
  "/navigation/ca4dbd63d30c4ffcb1ea5d633f597978"
  "/navigation/cc931fdc54534d9aba33b7529a7d30a0"
  "/navigation/e541a725803d41708f7dc129d567739f"
  "/navigation/e56ce6de4c1b44e38c56a9c59d0ca812"
  "/navigation/f89c121dd216458a81922f507aa24edf"
  "/navigation/fd0eb548ccda4b46b25c0a17e1b2696f"
  "/navigation/62cfdd15304b46d9ae9c9ddac4a24536"
  "/navigation/018d1bebfedc7b65a267aa983ff97e69"
  "/navigation/3e15316a11a94370a995f2cd5d906449"
  "/navigation/6f1984108a3c4d939aa38fb4985f6844"
  "/navigation/61497408e8d2444ea1e756bcf10f19f1"
  "/navigation/018b5c1848fb7eb584c55d0d9e9fc96f"
  "/navigation/0196aae9606a7de49157ac37aeadc4b0"
  "/navigation/0196aae9b4ce7b5dbd1a833d5295318c"
  "/navigation/02e9b55b435045949d3849cfcdc5b316"
  "/navigation/122090eb5ba3469d8858204a6a2998c1"
  "/navigation/e374de9754e647d7973a7b36d0057814"
  "/navigation/5e1e94f100ea4a44b82b49cf0c9ee9cc"
  "/navigation/d97162e581be45f29254cbcf0d86b3a4"
  "/navigation/0191313c8ec57587b0a40b74c992c61f"
  "/navigation/dfbea89f5a7d4503a32b24d1457dfd3e"
  "/navigation/0198c7ccf1eb784986c8aac35e3b4de0"
  "/navigation/ef83486861004b3e98f011cb75a2c524"
  "/navigation/f03cb2fe004740b3904490014117d170"
  "/detail/018fb9c572f9713ba6d96d9cec03d21f"
  "/detail/0191bcb0fb6271bb8162589a8258df2e"
  "/detail/018fba2795b070bc88e0e6a27667bb5d"
  "/detail/018fba847d7c7135822e2e89db430f52"
  "/detail/018b2330f84e70a289e3f738ca591e54"
  "/detail/cf27a15551e84406954fed686cb1827a"
  "/detail/018b84a1488a737e927749e5d2009b21"
  "/detail/018c006ba4cb72adb6134c76758199e9"
  "/detail/018c006810427065ad5cce0ff20114d1"
  "/detail/7a337debf28e46d7aed299f8bb41ff5f"
  "/detail/019271aba5ad714493f1301cdcc52ef8"
  "/detail/0192715dabe5727f85701e811b10535b"
  "/detail/0199106b5ab271fdb849eda6481f0586"
  "/detail/01946eb160517036ab73dc8be8b02267"
  "/detail/019913f02ccf72ad9a48429c007185f2"
  "/detail/0199145b93837390bef01cbafc10a26b"
  "/detail/01995bf0cdb27068a7fc0f52384409d4"
  "/detail/0e76693b74664898bf2afbeb8cfb4a13"
  "/detail/018ad054ec157056bb5f8abfeee4134b"
  "/detail/018ad043c19873a2b34697ac50e8bf24"
  "/detail/019029fae5f3701fbd03ffa6e47902fb"
  "/detail/018ab19fcc90739290221bbaa71a18b0"
  "/detail/018ab15a99ac734ebdb97319339cae5a"
  "/detail/018acdeee17570808121409ba3f9d1b1"
  "/detail/018ad1b3977671d89649e54f83f73807"
  "/detail/018acdf2bedf7148ba8bd04c8ed40dca"
  "/detail/018c73794b94701fb460a761656639a0"
  "/detail/018c3f1c6bc070f392dc206454ae8789"
  "/detail/018a840e2dc7720fa3bd3f72f644f54c"
  "/detail/ff67577d19564e89bf8f92aad0187e9a"
  "/detail/664ca2e0a2ad4742b82920329ba601f2"
  "/detail/018a84f7161271a0acf099dec545d564"
  "/detail/018aecb0e52e728a8586b82d6b2f134b"
  "/detail/0191d2d50e1b70b9a8d2d39050b70908"
  "/detail/27cd60b3b3d94a1a90f7a5f5a381a16a"
  "/detail/996b4228e4b746dd815988bc9d8879d7"
  "/detail/5e19e6f38486455aac05eb910c263333"
  "/detail/6f3c70fa52be4136a0c48c86a23cdcf2"
  "/detail/0191eac2bbe97179abd20de42515ab43"
  "/detail/018ace00ff347341bdac2801d63f9824"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"i„öTY#Hê­h€Ã_MPÂ"
]
View formatted query    View runnable query    Explain query    View query backtrace
94.18 ms
(21.26%) 		540 
SELECT icon_class FROM property_group_translation
                WHERE property_group_id = ?
                AND language_id = ?
Parameters: 
[
  b"»ÈëjõtL°¤êÐÓÄ)}–"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
81.14 ms
(18.32%) 		39 
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`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  false
  true
  "product_download"
  false
  true
  "product_download"
  b"(º¡ÞÔÅEõ»ºÖû<¶ñË"
]
View formatted query    View runnable query    Explain query    View query backtrace
17.90 ms
(4.04%) 		1 
-- product-listing-route::loading::search-ids
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment`, `product.swpaPosition`.swpa_sorting as swpa_sorting FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `product_category_tree` `product.swpaPosition` ON `product`.`id` = `product.swpaPosition`.`product_id` AND `product.swpaPosition`.category_id=? LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?))) GROUP BY `product`.`display_group` ORDER BY MIN(`product.swpaPosition`.`swpa_sorting`) ASC, MIN(`product`.`id`) ASC LIMIT 81
Parameters: 
[
  b"2•j=\x7Fà@4ž\x05‰F\x00Q»*"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"i„öTY#Hê­h€Ã_MPÂ"
  true
  b"2•j=\x7Fà@4ž\x05‰F\x00Q»*"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
15.23 ms
(3.44%) 		1 
-- product-listing-route::loading::association::properties::read
SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group`.`icon_media_id` as `property_group_option.group.iconMediaId`, `property_group_option.group.iconMedia`.`id` as `property_group_option.group.iconMedia.id`, `property_group_option.group.iconMedia`.`user_id` as `property_group_option.group.iconMedia.userId`, `property_group_option.group.iconMedia`.`media_folder_id` as `property_group_option.group.iconMedia.mediaFolderId`, `property_group_option.group.iconMedia`.`mime_type` as `property_group_option.group.iconMedia.mimeType`, `property_group_option.group.iconMedia`.`file_extension` as `property_group_option.group.iconMedia.fileExtension`, `property_group_option.group.iconMedia`.`uploaded_at` as `property_group_option.group.iconMedia.uploadedAt`, `property_group_option.group.iconMedia`.`file_name` as `property_group_option.group.iconMedia.fileName`, `property_group_option.group.iconMedia`.`file_size` as `property_group_option.group.iconMedia.fileSize`, `property_group_option.group.iconMedia`.`media_type` as `property_group_option.group.iconMedia.mediaTypeRaw`, `property_group_option.group.iconMedia`.`meta_data` as `property_group_option.group.iconMedia.metaData`, `property_group_option.group.iconMedia`.`config` as `property_group_option.group.iconMedia.config`, `property_group_option.group.iconMedia`.`path` as `property_group_option.group.iconMedia.path`, `property_group_option.group.iconMedia`.`private` as `property_group_option.group.iconMedia.private`, `property_group_option.group.iconMedia`.`thumbnails_ro` as `property_group_option.group.iconMedia.thumbnailsRo`, `property_group_option.group.iconMedia`.`file_hash` as `property_group_option.group.iconMedia.fileHash`, `property_group_option.group.iconMedia`.`created_at` as `property_group_option.group.iconMedia.createdAt`, `property_group_option.group.iconMedia`.`updated_at` as `property_group_option.group.iconMedia.updatedAt`, `property_group_option.group.iconMedia.translation.title`, `property_group_option.group.iconMedia.translation.title` as `property_group_option.group.iconMedia.title`, `property_group_option.group.iconMedia.translation.alt`, `property_group_option.group.iconMedia.translation.alt` as `property_group_option.group.iconMedia.alt`, `property_group_option.group.iconMedia.translation.customFields`, `property_group_option.group.iconMedia.translation.customFields` as `property_group_option.group.iconMedia.customFields`, `property_group_option.group.translation.name`, `property_group_option.group.translation.name` as `property_group_option.group.name`, `property_group_option.group.translation.description`, `property_group_option.group.translation.description` as `property_group_option.group.description`, `property_group_option.group.translation.position`, `property_group_option.group.translation.position` as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, `property_group_option.group.translation.customFields` as `property_group_option.group.customFields`, `property_group_option.translation.name`, `property_group_option.translation.name` as `property_group_option.name`, `property_group_option.translation.position`, `property_group_option.translation.position` as `property_group_option.position`, `property_group_option.translation.customFields`, `property_group_option.translation.customFields` as `property_group_option.customFields` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.translation`.`property_group_option_id`, `property_group_option.translation`.`name` as `property_group_option.translation.name`, `property_group_option.translation`.`position` as `property_group_option.translation.position`, `property_group_option.translation`.`custom_fields` as `property_group_option.translation.customFields` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.`language_id` = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN `media` `property_group_option.group.iconMedia` ON `property_group_option.group`.`icon_media_id` = `property_group_option.group.iconMedia`.`id` LEFT JOIN (SELECT `property_group_option.group.translation`.`property_group_id`, `property_group_option.group.translation`.`name` as `property_group_option.group.translation.name`, `property_group_option.group.translation`.`description` as `property_group_option.group.translation.description`, `property_group_option.group.translation`.`position` as `property_group_option.group.translation.position`, `property_group_option.group.translation`.`custom_fields` as `property_group_option.group.translation.customFields` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.`language_id` = ?) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.group.iconMedia.translation`.`media_id`, `property_group_option.group.iconMedia.translation`.`alt` as `property_group_option.group.iconMedia.translation.alt`, `property_group_option.group.iconMedia.translation`.`title` as `property_group_option.group.iconMedia.translation.title`, `property_group_option.group.iconMedia.translation`.`custom_fields` as `property_group_option.group.iconMedia.translation.customFields` FROM `media_translation` `property_group_option.group.iconMedia.translation` WHERE `property_group_option.group.iconMedia.translation`.`language_id` = ?) `property_group_option.group.iconMedia.media_translation` ON `property_group_option.group.iconMedia.media_translation`.`media_id` = `property_group_option.group.iconMedia`.`id` WHERE `property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01klŠ\x1DƒD½‡KJs÷O\x19U"
  b"\x01Ž<‹Î”ró¯¢ú¹ë†Âè"
  b"&\x1FJ9ôC¸ˆUn‡Ú¿ %"
  b".çX¤¨\x04N+ŒóL‰ÔZ0\x03"
  b"0ÒœñA1A%–l\x14\x00³ØuÏ"
  b"q¸MìîøE«‰ÉTŽ\x08‘7Q"
  b"—\x01¡]Ù›DÕ«;P3ë|Mw"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"êÑÇ\fž¬A]°ÓZÙõ+ë†"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x01Œ\x15wëúuñ—ÔY\x08Ño{†"
  b"\x01Œ\x15xeUzK¿Áã9\f\x01Wô"
  b"\x01Œ\x15â"}p‡e4Î\x02Úå"
  b"\x01ŽÖ\x17{\x7F\x06‚˜’Â} ç\x0E"
  b"\x01X©²ûzŽž\x03‘µàDÐä"
  b"\x1AÉk…uÊO¯´OçA$\x14óé"
  b"8Çt\x150ÜG]…F`„\x111\x1Fk"
  b"=\x05 sH\x0EJB¦»[ ¬sëº"
  b"Fx‰ÏªžJ\x07¢i~ä\x16‡öÊ"
  b"M,ÇkúhNˆ‰®‚\x13V=óö"
  b"Zõ°\x1FK8I\§-FܪÄ$±"
  b"v\x07\x01kŠ‡CŶâF&t‰\x1Cø"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x01‹û”w¦~g‡‹ò1Èßmr"
  b"\x01‹ûÛoêsg_®¥f¾6\v"
  b"\x02e°\x14‡SD_±¨i‘WBëK"
  b"\x15\KxÆ"J1“š\f\¹\x00Oë"
  b"Ü`4UîULp·#c\x14w¥2å"
  b"\x01‹û”w¦~g‡‹ò1Èßmr"
  b"\x01‹ûÛoêsg_®¥f¾6\v"
  b"\x15\KxÆ"J1“š\f\¹\x00Oë"
  b"¢Ê”^]NŽ¢\eITx(Ž"
  b"Ü`4UîULp·#c\x14w¥2å"
  b"\x01‹û”\x18üx\x1E•ïäëD–fÏ"
  b"\x01‹ûÝ\x06ñxñÖ,# ó€®"
  b"\x15\KxÆ"J1“š\f\¹\x00Oë"
  b"Ü`4UîULp·#c\x14w¥2å"
  b"\x01‹û”\x18üx\x1E•ïäëD–fÏ"
  b"\x01‹ûÜž¥yÊ«z\x7F—ûL9Q"
  b"\x15\KxÆ"J1“š\f\¹\x00Oë"
  b"8Çt\x150ÜG]…F`„\x111\x1Fk"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"=\x05 sH\x0EJB¦»[ ¬sëº"
  b"v\x07\x01kŠ‡CŶâF&t‰\x1Cø"
  b"¢Ê”^]NŽ¢\eITx(Ž"
  b"Ü`4UîULp·#c\x14w¥2å"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"ÿM8ã\x0FoNë¤\x0EEU\x08œ£¤"
  b"\x01Œ\x15xeUzK¿Áã9\f\x01Wô"
  b"8Çt\x150ÜG]…F`„\x111\x1Fk"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"=\x05 sH\x0EJB¦»[ ¬sëº"
  b"ŽV¾c\x15¡Hüˆuæ\x1D…C~ô"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x01Ž‡á|#y‰­ÞŒAª\x08–õ"
  b"\x1AÉk…uÊO¯´OçA$\x14óé"
  b"\x1F8†ûV\x11E’‹lö(n5«É"
  b"8Çt\x150ÜG]…F`„\x111\x1Fk"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"CíÕnN®Bð¡@\x17\x17(ŠQü"
  b"iÕ¹r\x1DÉMRŽcˆÆ‹#-\x01"
  b"™uD܁H^³\x19Ò„­ÂQÖ"
  b"¾·)æ‘åH€ók’¸˜Ð¸"
  b"À\rö\eg…O6žûQÞ¹øª"
  b"Õ–¤nä\x06L¯…õ\e3\x0F\x05\x01Å"
  b"õµä"\x16cH:®Ó\x1AU‰½Dˆ"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"ÿM8ã\x0FoNë¤\x0EEU\x08œ£¤"
  b"\x01‹\x03êäì}z’B\x00ä¶Ä÷¼"
  b"\x01Ž‡á|#y‰­ÞŒAª\x08–õ"
  b"\x1F8†ûV\x11E’‹lö(n5«É"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"CíÕnN®Bð¡@\x17\x17(ŠQü"
  b"™uD܁H^³\x19Ò„­ÂQÖ"
  b"Õ–¤nä\x06L¯…õ\e3\x0F\x05\x01Å"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x01Œ\x15‚\x0Fr~¾·U\x00ï\x16$|"
  b"\x01Žù\x10Ôõy°©Ñc\x11˜\x1CâZ"
  b"\x01Žù\x17bÀq“‹+¥Œæj\x1F<"
  b"\x15\KxÆ"J1“š\f\¹\x00Oë"
  b"=\x05 sH\x0EJB¦»[ ¬sëº"
  b"rî¹6™œO©²\x18~qèÚ6\x1A"
  b"ÿM8ã\x0FoNë¤\x0EEU\x08œ£¤"
  b"\x01‹\x1E1\x08iph•™ÜT\x08šI"
  b"\x01‹B\em}$²ÓñÒCñÞn"
  b"\x01Že›¢AzѦUW\x10‘z{"
  b"\x07Ðà˜g½Oh£ðeX\e¾ñ¨"
  b"8Çt\x150ÜG]…F`„\x111\x1Fk"
  b"9+ý”ä-N6†êc@½àÄõ"
  b";iY‡m\x1AFϝSgf~z K"
  b"""
    ZbW\n
    yÏ@ˆœ9­ŽãÓ6E
    """
  b"iÕ¹r\x1DÉMRŽcˆÆ‹#-\x01"
  b"™uD܁H^³\x19Ò„­ÂQÖ"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"¾·)æ‘åH€ók’¸˜Ð¸"
  b"êÂ\x08nòÉF¨ƒ\x0FE²â}+Ö"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"=\x05 sH\x0EJB¦»[ ¬sëº"
  b"À\rö\eg…O6žûQÞ¹øª"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x01‹\x03êäì}z’B\x00ä¶Ä÷¼"
  b"G$q¬û…N¥µìb—ðy!»"
  b"Õ–¤nä\x06L¯…õ\e3\x0F\x05\x01Å"
  b"ÿ\x04)Ú.¿Gü±\x129?\x7F5ÑÕ"
  b"\x01‹\x03êäì}z’B\x00ä¶Ä÷¼"
  b"\x0E:|^UIOP¢¼Œi–•e;"
  b"G$q¬û…N¥µìb—ðy!»"
  b"Õ–¤nä\x06L¯…õ\e3\x0F\x05\x01Å"
  b"\x01Œ\x15xeUzK¿Áã9\f\x01Wô"
  b"\x01Œ\x15‚\x0Fr~¾·U\x00ï\x16$|"
  b"\x01Ž\x17΁ó|Ü‹E¬\vYÛ„@"
  b".çX¤¨\x04N+ŒóL‰ÔZ0\x03"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"=\x05 sH\x0EJB¦»[ ¬sëº"
  b"M,ÇkúhNˆ‰®‚\x13V=óö"
  b"Z5dÐj}EÉ‘M¤²S1¹ƒ"
  b"iÕ¹r\x1DÉMRŽcˆÆ‹#-\x01"
  b"—\x01¡]Ù›DÕ«;P3ë|Mw"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"Úëè‚Ï`C½™\x06Ê‹\x18aêÛ"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x01Œ\x15‚\x0Fr~¾·U\x00ï\x16$|"
  b"\x08Íãw-6Mž•Âí\v\x102\fH"
  b"\x1AÉk…uÊO¯´OçA$\x14óé"
  b"#\x15Ñýˆ\x03C†²/1FEA¶î"
  b"8Çt\x150ÜG]…F`„\x111\x1Fk"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"iÕ¹r\x1DÉMRŽcˆÆ‹#-\x01"
  b"‘ùŒ)±GÕˆ\x1E\GÃ\x08ò"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"Úëè‚Ï`C½™\x06Ê‹\x18aêÛ"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x01‹\x03êäì}z’B\x00ä¶Ä÷¼"
  b"\x01Œ\x15xeUzK¿Áã9\f\x01Wô"
  b"\x01Œ\x15xÔËrY¼\x00\x0E.Qp\x1Dh"
  b"\x01Œ\x15‚\x0Fr~¾·U\x00ï\x16$|"
  b"\x1D5ŠIxvF¾¯“þ¯ØÊ¥v"
  b"=\x05 sH\x0EJB¦»[ ¬sëº"
  b"CíÕnN®Bð¡@\x17\x17(ŠQü"
  b"M,ÇkúhNˆ‰®‚\x13V=óö"
  b"""
    TËh•À­L\x1A›jÐXÇ\n
    ÈÃ
    """
  b"UƆ{'•@\x1A…<ñtÈ0N|"
  b"À\rö\eg…O6žûQÞ¹øª"
  b"ð¿Ç·\x15D\x18šI©€'DÍû"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x01‹\x03êäì}z’B\x00ä¶Ä÷¼"
  b"\x01Œ\x15xeUzK¿Áã9\f\x01Wô"
  b"\x01Œ\x15xÔËrY¼\x00\x0E.Qp\x1Dh"
  b"\x01Œ\x15‚\x0Fr~¾·U\x00ï\x16$|"
  b"=\x05 sH\x0EJB¦»[ ¬sëº"
  b"CíÕnN®Bð¡@\x17\x17(ŠQü"
  b"M,ÇkúhNˆ‰®‚\x13V=óö"
  b"ð¿Ç·\x15D\x18šI©€'DÍû"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x01Œ\x15xeUzK¿Áã9\f\x01Wô"
  b"\x01Œ\x15xÔËrY¼\x00\x0E.Qp\x1Dh"
  b"\x01Œ\x15‚\x0Fr~¾·U\x00ï\x16$|"
  b"=\x05 sH\x0EJB¦»[ ¬sëº"
  b"CíÕnN®Bð¡@\x17\x17(ŠQü"
  b"M,ÇkúhNˆ‰®‚\x13V=óö"
  b"À\rö\eg…O6žûQÞ¹øª"
  b"ð¿Ç·\x15D\x18šI©€'DÍû"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x01‹\x03êäì}z’B\x00ä¶Ä÷¼"
  b"\x01Že›¢AzѦUW\x10‘z{"
  b"\x15\KxÆ"J1“š\f\¹\x00Oë"
  b"=\x05 sH\x0EJB¦»[ ¬sëº"
  b"CíÕnN®Bð¡@\x17\x17(ŠQü"
  b"M,ÇkúhNˆ‰®‚\x13V=óö"
  b"Õ3#Mñ}Iܶ×9qbóŸ\n"
  b"êÂ\x08nòÉF¨ƒ\x0FE²â}+Ö"
  b"\x01‹\x03êäì}z’B\x00ä¶Ä÷¼"
  b"\x01Œ\x15‚\x0Fr~¾·U\x00ï\x16$|"
  b"\x01ŽÆ]¶*~HŒ´M’n…³;"
  b"\x01Ó+Á\x1Et\x01¹Ì¹1ôJ~÷"
  b"\x1D5ŠIxvF¾¯“þ¯ØÊ¥v"
  b"8Çt\x150ÜG]…F`„\x111\x1Fk"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"=\x05 sH\x0EJB¦»[ ¬sëº"
  b"CíÕnN®Bð¡@\x17\x17(ŠQü"
  b"KaÆYásI!ˆ:⟣jý¡"
  b"M,ÇkúhNˆ‰®‚\x13V=óö"
  b"pq7\v[}Aš›Ùtí‚p#/"
  b"ŽV¾c\x15¡Hüˆuæ\x1D…C~ô"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x01Že›¢AzѦUW\x10‘z{"
  b"\x1D5ŠIxvF¾¯“þ¯ØÊ¥v"
  b"#\x15Ñýˆ\x03C†²/1FEA¶î"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"=\x05 sH\x0EJB¦»[ ¬sëº"
  b"_\r\x7FŽ¯{EP h†+ÌÀºk"
  b"iÕ¹r\x1DÉMRŽcˆÆ‹#-\x01"
  b"tTñvã¿JА\x14\x17eá¬%ä"
  b"ŽÔ\x0F¶j˜AñŠ>\x02¶F\x1C¨ˆ"
  b"’\x1A/¡?@U©Û\x12Wä\x1EÁé"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"Ý\x05O\x12fºEt’\x08UJMþ\x0F"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x01‹û”w¦~g‡‹ò1Èßmr"
  b"\x01Že›¢AzѦUW\x10‘z{"
  b"\x01ýæÝ´v7¦\x06ðumL”€"
  b"\x15\KxÆ"J1“š\f\¹\x00Oë"
  b"=\x05 sH\x0EJB¦»[ ¬sëº"
  b"CíÕnN®Bð¡@\x17\x17(ŠQü"
  b"žUðh\x01ÏI扄8d:´\x04b"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"êÂ\x08nòÉF¨ƒ\x0FE²â}+Ö"
  b"\x01Že›¢AzѦUW\x10‘z{"
  b"=\x05 sH\x0EJB¦»[ ¬sëº"
  b"KaÆYásI!ˆ:⟣jý¡"
  b"—\x01¡]Ù›DÕ«;P3ë|Mw"
  b"™uD܁H^³\x19Ò„­ÂQÖ"
  b"êÂ\x08nòÉF¨ƒ\x0FE²â}+Ö"
  b"\x01Že›¢AzѦUW\x10‘z{"
  b"\x1D5ŠIxvF¾¯“þ¯ØÊ¥v"
  b"=\x05 sH\x0EJB¦»[ ¬sëº"
  b"KaÆYásI!ˆ:⟣jý¡"
  b"—\x01¡]Ù›DÕ«;P3ë|Mw"
  b"™uD܁H^³\x19Ò„­ÂQÖ"
  b"êÂ\x08nòÉF¨ƒ\x0FE²â}+Ö"
  b"\x01‹û”w¦~g‡‹ò1Èßmr"
  b"\x01‹ûÝ\x06ñxñÖ,# ó€®"
  b"\x15\KxÆ"J1“š\f\¹\x00Oë"
  b"¢Ê”^]NŽ¢\eITx(Ž"
  b"Ü`4UîULp·#c\x14w¥2å"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x01Ž‡á|#y‰­ÞŒAª\x08–õ"
  b"\x01Že›¢AzѦUW\x10‘z{"
  b"\x1D5ŠIxvF¾¯“þ¯ØÊ¥v"
  b"\x1F8†ûV\x11E’‹lö(n5«É"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"CíÕnN®Bð¡@\x17\x17(ŠQü"
  b"v\x07\x01kŠ‡CŶâF&t‰\x1Cø"
  b"™uD܁H^³\x19Ò„­ÂQÖ"
  b"š9\x7F䤮F̤³Ôe‡º\x07¸"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"À\rö\eg…O6žûQÞ¹øª"
  b"Õ–¤nä\x06L¯…õ\e3\x0F\x05\x01Å"
  b"êÑÇ\fž¬A]°ÓZÙõ+ë†"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"ÿM8ã\x0FoNë¤\x0EEU\x08œ£¤"
  b"\x01Ž‡á|#y‰­ÞŒAª\x08–õ"
  b"\x01Že›¢AzѦUW\x10‘z{"
  b"\x07Ðà˜g½Oh£ðeX\e¾ñ¨"
  b"\x1D5ŠIxvF¾¯“þ¯ØÊ¥v"
  b"\x1F8†ûV\x11E’‹lö(n5«É"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"v\x07\x01kŠ‡CŶâF&t‰\x1Cø"
  b"™uD܁H^³\x19Ò„­ÂQÖ"
  b"š9\x7F䤮F̤³Ôe‡º\x07¸"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"Õ–¤nä\x06L¯…õ\e3\x0F\x05\x01Å"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"ÿM8ã\x0FoNë¤\x0EEU\x08œ£¤"
  b"\x01Ž‡á|#y‰­ÞŒAª\x08–õ"
  b"\x01Že›¢AzѦUW\x10‘z{"
  b"\x1AÉk…uÊO¯´OçA$\x14óé"
  b"\x1D5ŠIxvF¾¯“þ¯ØÊ¥v"
  b"\x1F8†ûV\x11E’‹lö(n5«É"
  b"8Çt\x150ÜG]…F`„\x111\x1Fk"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"™uD܁H^³\x19Ò„­ÂQÖ"
  b"š9\x7F䤮F̤³Ôe‡º\x07¸"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"Õ–¤nä\x06L¯…õ\e3\x0F\x05\x01Å"
  b"êÑÇ\fž¬A]°ÓZÙõ+ë†"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x16ŸUW\K\x1A½X\x0F\x02Û™\x16¥"
  b"=\x05 sH\x0EJB¦»[ ¬sëº"
  b"UƆ{'•@\x1A…<ñtÈ0N|"
  b"""
    j÷•>;ºIZ…ÀŒx\n
    :\x18ß
    """
  b"ð¿Ç·\x15D\x18šI©€'DÍû"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x01Œ\x15xeUzK¿Áã9\f\x01Wô"
  b"\x01Œ\x15‚\x0Fr~¾·U\x00ï\x16$|"
  b"=\x05 sH\x0EJB¦»[ ¬sëº"
  b"ŽV¾c\x15¡Hüˆuæ\x1D…C~ô"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x15\KxÆ"J1“š\f\¹\x00Oë"
  b"Õ–¤nä\x06L¯…õ\e3\x0F\x05\x01Å"
  b"\x01‹¸êÕ4{@›måyþwçm"
  b"\x01Ž‡á|#y‰­ÞŒAª\x08–õ"
  b"Õ–¤nä\x06L¯…õ\e3\x0F\x05\x01Å"
  b"\x01‹\x03êäì}z’B\x00ä¶Ä÷¼"
  b"\x01‹Î ‘Ùr¹ü“¬2\}Ó"
  b"\x1AÉk…uÊO¯´OçA$\x14óé"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"CíÕnN®Bð¡@\x17\x17(ŠQü"
  b"p…Ò}î4Bï¨Ç¢#X+µ\r"
  b"î³_‘\x1DAè¨C*þÆ,ÅÝ"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"Fx‰ÏªžJ\x07¢i~ä\x16‡öÊ"
  b"Õ–¤nä\x06L¯…õ\e3\x0F\x05\x01Å"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x01‹\x03êäì}z’B\x00ä¶Ä÷¼"
  b"G$q¬û…N¥µìb—ðy!»"
  b"Õ–¤nä\x06L¯…õ\e3\x0F\x05\x01Å"
  b"ï0{“£áM"°òí\x1E8L;b"
  b"\x01Œ\x15xÔËrY¼\x00\x0E.Qp\x1Dh"
  b"\x01v;@^z²¢‚­7¬Œ*Ø"
  b";iY‡m\x1AFϝSgf~z K"
  b"=\x05 sH\x0EJB¦»[ ¬sëº"
  b"CíÕnN®Bð¡@\x17\x17(ŠQü"
  b"M,ÇkúhNˆ‰®‚\x13V=óö"
  b"›òàÌ£…O_¤¢\x04$þ\eë\x04"
  b"À\rö\eg…O6žûQÞ¹øª"
]
View formatted query    View runnable query    Explain query    View query backtrace
12.30 ms
(2.78%) 		1 
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`type` as `product.type`, `product`.`states` as `product.states`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_option` `product.options.mapping`
                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, `product.cover`.`id` as `product.cover.id`, `product.cover`.`version_id` as `product.cover.versionId`, `product.cover`.`product_id` as `product.cover.productId`, `product.cover`.`product_version_id` as `product.cover.productVersionId`, `product.cover`.`media_id` as `product.cover.mediaId`, `product.cover`.`position` as `product.cover.position`, `product.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`meta_description` as `product.translation.metaDescription`, `product.translation`.`name` as `product.translation.name`, `product.translation`.`keywords` as `product.translation.keywords`, `product.translation`.`description` as `product.translation.description`, `product.translation`.`meta_title` as `product.translation.metaTitle`, `product.translation`.`pack_unit` as `product.translation.packUnit`, `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`, `product.translation`.`custom_fields` as `product.translation.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`meta_description` as `product.parent.translation.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (((`product`.`parent_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01‡F-qqH•QÜÊ\x02I)("
  b"\x01‘¼¯\x03Êtý‹^Ô'šI0ö"
  b"\x01‡a¬kqD¿Y×Gò5w¿"
  b"\x01‡rŽÅx¼°\x1CDnuD¯"
  b"_WHbç6D'¯.RßJ\x1Eж"
  b"ÆÞ‚ö_{FMŠ \x18Ä!\x1Ejô"
  b"\x01’qY.\x07s¯¦\x1AÞ\x16º\x7FÒy"
  b"\x01’qYó…q\x1C’ÂOã&­Ös"
  b"\x01™\tkÍëq" \x19C!Ää¢\x1E"
  b"\x01”n¦ŠäpêŽàÒ…ô\x01àU"
  b"\x01™\x13ëÄlp¢ºÐùyÈg'D"
  b"\x01™\x14[ƒEs\r••H§Xi@÷"
  b"\x01™[ðÄ\x1Cq¿Ž•Ž]YŽR,"
  b"†Vu>\x7F"E;›•¨i—™–"
  b"Îèª\x16žãHȶwéÖLåiQ"
  b"7cXÇ\x1CäDZ¤ys?UrºG"
  b"\x01Š±–U\x1CqˆuaÐjäì\t"
  b"úšÿ=•³C7¡£xh@peâ"
  b"Îw[E¡¶G¦¸3\x17Üa¸\x1EQ"
  b"ž‰~™îàG_²¢ÈÓüZPr"
  b"˜\x04\v\x12­÷@_¼à°ä7—sï"
  b"»c)Š\tKAy¦\x15¤±Nw!r"
  b"\x1Co(\x05!ýM!»¾\x10J‡gµ\x19"
  b"6À–E\x16èNA¤B®ïŽ'È~"
  b"e\x00¾+¦EN¼´f9ìÙu#k"
  b"±lqë~ÿMr¶I\x01\x16\x10,¢±"
  b"cÊ“\f\x1A_I牐Î\x12q\x03€"
  b"ª\x05iæa>B\x18¬ýf(y¥¶°"
  b"\x0FäÁŽ¶¨H•¹n‰ó\x11"}c"
  b"nÛÎîsU@?‡ºóÏ@Î{€"
  b"jó\x12\›kNÕ¿´µ?ëEëc"
  b"ßûÌÐCŒNžj;VßkÓF"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
10.50 ms
(2.37%) 		1 
-- product-listing-route::loading::read
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`type` as `product.type`, `product`.`states` as `product.states`, `product.parent`.`cheapest_price` as `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.manufacturer`.`id` as `product.manufacturer.id`, `product.manufacturer`.`version_id` as `product.manufacturer.versionId`, `product.manufacturer`.`media_id` as `product.manufacturer.mediaId`, `product.manufacturer`.`created_at` as `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` as `product.manufacturer.updatedAt`, `product.manufacturer.translation.name`, `product.manufacturer.translation.name` as `product.manufacturer.name`, `product.manufacturer.translation.link`, `product.manufacturer.translation.link` as `product.manufacturer.link`, `product.manufacturer.translation.description`, `product.manufacturer.translation.description` as `product.manufacturer.description`, `product.manufacturer.translation.customFields`, `product.manufacturer.translation.customFields` as `product.manufacturer.customFields`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_option` `product.options.mapping`
                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, (SELECT GROUP_CONCAT(HEX(`product.properties.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_property` `product.properties.mapping`
                  WHERE `product.properties.mapping`.`product_id` = `product`.`properties` ) as `product.properties.id_mapping`, `product.unit`.`id` as `product.unit.id`, `product.unit`.`created_at` as `product.unit.createdAt`, `product.unit`.`updated_at` as `product.unit.updatedAt`, `product.unit.translation.shortCode`, `product.unit.translation.shortCode` as `product.unit.shortCode`, `product.unit.translation.name`, `product.unit.translation.name` as `product.unit.name`, `product.unit.translation.customFields`, `product.unit.translation.customFields` as `product.unit.customFields`, `product.deliveryTime`.`id` as `product.deliveryTime.id`, `product.deliveryTime`.`min` as `product.deliveryTime.min`, `product.deliveryTime`.`max` as `product.deliveryTime.max`, `product.deliveryTime`.`unit` as `product.deliveryTime.unit`, `product.deliveryTime`.`created_at` as `product.deliveryTime.createdAt`, `product.deliveryTime`.`updated_at` as `product.deliveryTime.updatedAt`, `product.deliveryTime.translation.name`, `product.deliveryTime.translation.name` as `product.deliveryTime.name`, `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation.customFields` as `product.deliveryTime.customFields`, `product.cover`.`id` as `product.cover.id`, `product.cover`.`version_id` as `product.cover.versionId`, `product.cover`.`product_id` as `product.cover.productId`, `product.cover`.`product_version_id` as `product.cover.productVersionId`, `product.cover`.`media_id` as `product.cover.mediaId`, `product.cover`.`position` as `product.cover.position`, `product.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, `product.cover.media`.`id` as `product.cover.media.id`, `product.cover.media`.`user_id` as `product.cover.media.userId`, `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` as `product.cover.media.fileName`, `product.cover.media`.`file_size` as `product.cover.media.fileSize`, `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` as `product.cover.media.metaData`, `product.cover.media`.`config` as `product.cover.media.config`, `product.cover.media`.`path` as `product.cover.media.path`, `product.cover.media`.`private` as `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, `product.cover.media`.`file_hash` as `product.cover.media.fileHash`, `product.cover.media`.`created_at` as `product.cover.media.createdAt`, `product.cover.media`.`updated_at` as `product.cover.media.updatedAt`, `product.cover.media.translation.title`, `product.cover.media.translation.title` as `product.cover.media.title`, `product.cover.media.translation.alt`, `product.cover.media.translation.alt` as `product.cover.media.alt`, `product.cover.media.translation.customFields`, `product.cover.media.translation.customFields` as `product.cover.media.customFields`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`meta_description` as `product.translation.metaDescription`, `product.translation`.`name` as `product.translation.name`, `product.translation`.`keywords` as `product.translation.keywords`, `product.translation`.`description` as `product.translation.description`, `product.translation`.`meta_title` as `product.translation.metaTitle`, `product.translation`.`pack_unit` as `product.translation.packUnit`, `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`, `product.translation`.`custom_fields` as `product.translation.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`meta_description` as `product.parent.translation.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.manufacturer.translation`.`product_manufacturer_id`, `product.manufacturer.translation`.`product_manufacturer_version_id`, `product.manufacturer.translation`.`link` as `product.manufacturer.translation.link`, `product.manufacturer.translation`.`name` as `product.manufacturer.translation.name`, `product.manufacturer.translation`.`description` as `product.manufacturer.translation.description`, `product.manufacturer.translation`.`custom_fields` as `product.manufacturer.translation.customFields` FROM `product_manufacturer_translation` `product.manufacturer.translation` WHERE `product.manufacturer.translation`.`language_id` = ?) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_version_id` = `product.manufacturer`.`version_id` LEFT JOIN (SELECT `product.unit.translation`.`unit_id`, `product.unit.translation`.`short_code` as `product.unit.translation.shortCode`, `product.unit.translation`.`name` as `product.unit.translation.name`, `product.unit.translation`.`custom_fields` as `product.unit.translation.customFields` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation`.`language_id` = ?) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id` LEFT JOIN (SELECT `product.deliveryTime.translation`.`delivery_time_id`, `product.deliveryTime.translation`.`name` as `product.deliveryTime.translation.name`, `product.deliveryTime.translation`.`custom_fields` as `product.deliveryTime.translation.customFields` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation`.`language_id` = ?) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id` LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.cover.media.translation`.`media_id`, `product.cover.media.translation`.`alt` as `product.cover.media.translation.alt`, `product.cover.media.translation`.`title` as `product.cover.media.translation.title`, `product.cover.media.translation`.`custom_fields` as `product.cover.media.translation.customFields` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation`.`language_id` = ?) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01¹Årùq;¦Ùmœì\x03Ò\x1F"
  b"\x01‘¼°ûbq»bXš‚Xß."
  b"\x01º'•°p¼ˆàæ¢vg»]"
  b"\x01º„}|q5‚..‰ÛC\x0FR"
  b"\x01‹#0øNp¢‰ã÷8ÊY\x1ET"
  b"Ï'¡UQèD\x06•Oíhl±‚z"
  b"\x01‹„¡HŠs~’wIåÒ\x00›!"
  b"\x01Œ\x00k¤Ër­¶\x13Lvu™é"
  b"\x01Œ\x00h\x10Bpe­\Î\x0Fò\x01\x14Ñ"
  b"z3}ëòŽF×®Ò™ø»Aÿ_"
  b"\x01’q«¥­qD“ñ0\x1CÜÅ.ø"
  b"\x01’q]«år\x7F…p\x1E\e\x10S["
  b"\x01™\x10kZ²qý¸Ií¦H\x1F\x05†"
  b"\x01”n±`Qp6«sÜ‹è°"g"
  b"\x01™\x13ð,Ïr­šHBœ\x00q…ò"
  b"\x01™\x14[“ƒs¾ð\x1Cºü\x10¢k"
  b"\x01™[ðͲph§ü\x0FR8D\tÔ"
  b"\x0Evi;tfH˜¿*ûëŒûJ\x13"
  b"\x01ŠÐTì\x15pV»_Š¿îä\x13K"
  b"\x01ŠÐCÁ˜s¢³F—¬Pè¿$"
  b"\x01)úåóp\x1F½\x03ÿ¦äy\x02û"
  b"\x01Š±ŸÌs’"\eº§\x1A\x18°"
  b"\x01Š±Z™¬sN½¹s\x193œ®Z"
  b"\x01ŠÍîáup€!@›£ùѱ"
  b"\x01ŠÑ³—vqØ–IåOƒ÷8\x07"
  b"\x01ŠÍò¾ßqHº‹ÐLŽÔ\rÊ"
  b"\x01ŒsyK”p\x1F´`§aef9 "
  b"\x01Œ?\x1CkÀpó’Ü dT®‡‰"
  b"\x01Š„\x0E-Çr\x0F£½?röDõL"
  b"ÿgW}\x19VN‰¿’ªÐ\x18~š"
  b"fL¢à¢­GB¸) 2›¦\x01ò"
  b"\x01Š„÷\x16\x12q ¬ð™ÞÅEÕd"
  b"\x01Šì°å.rŠ…†¸-k/\x13K"
  b"\x01‘ÒÕ\x0E\ep¹¨ÒӐP·\t\x08"
  b"'Í`³³ÙJ\x1A÷¥õ£¡j"
  b"™kB(ä·F݁Yˆ¼ˆy×"
  b"^\x19æó„†EZ¬\x05ë‘\f&33"
  b"o<púR¾A6 ÄŒ†¢<Üò"
  b"\x01‘ê»éqy«Ò\rä%\x15«C"
  b"\x01ŠÎ\x00ÿ4sA½¬(\x01Ö?˜$"
]
View formatted query    View runnable query    Explain query    View query backtrace
9.37 ms
(2.12%) 		1 
-- product-listing::property-filter::read
SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.media`.`id` as `property_group_option.media.id`, `property_group_option.media`.`user_id` as `property_group_option.media.userId`, `property_group_option.media`.`media_folder_id` as `property_group_option.media.mediaFolderId`, `property_group_option.media`.`mime_type` as `property_group_option.media.mimeType`, `property_group_option.media`.`file_extension` as `property_group_option.media.fileExtension`, `property_group_option.media`.`uploaded_at` as `property_group_option.media.uploadedAt`, `property_group_option.media`.`file_name` as `property_group_option.media.fileName`, `property_group_option.media`.`file_size` as `property_group_option.media.fileSize`, `property_group_option.media`.`media_type` as `property_group_option.media.mediaTypeRaw`, `property_group_option.media`.`meta_data` as `property_group_option.media.metaData`, `property_group_option.media`.`config` as `property_group_option.media.config`, `property_group_option.media`.`path` as `property_group_option.media.path`, `property_group_option.media`.`private` as `property_group_option.media.private`, `property_group_option.media`.`thumbnails_ro` as `property_group_option.media.thumbnailsRo`, `property_group_option.media`.`file_hash` as `property_group_option.media.fileHash`, `property_group_option.media`.`created_at` as `property_group_option.media.createdAt`, `property_group_option.media`.`updated_at` as `property_group_option.media.updatedAt`, `property_group_option.media.translation.title`, `property_group_option.media.translation.title` as `property_group_option.media.title`, `property_group_option.media.translation.alt`, `property_group_option.media.translation.alt` as `property_group_option.media.alt`, `property_group_option.media.translation.customFields`, `property_group_option.media.translation.customFields` as `property_group_option.media.customFields`, `property_group_option.translation.name`, `property_group_option.translation.name` as `property_group_option.name`, `property_group_option.translation.position`, `property_group_option.translation.position` as `property_group_option.position`, `property_group_option.translation.customFields`, `property_group_option.translation.customFields` as `property_group_option.customFields` FROM `property_group_option` LEFT JOIN `media` `property_group_option.media` ON `property_group_option`.`media_id` = `property_group_option.media`.`id` LEFT JOIN (SELECT `property_group_option.translation`.`property_group_option_id`, `property_group_option.translation`.`name` as `property_group_option.translation.name`, `property_group_option.translation`.`position` as `property_group_option.translation.position`, `property_group_option.translation`.`custom_fields` as `property_group_option.translation.customFields` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.`language_id` = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN (SELECT `property_group_option.media.translation`.`media_id`, `property_group_option.media.translation`.`alt` as `property_group_option.media.translation.alt`, `property_group_option.media.translation`.`title` as `property_group_option.media.translation.title`, `property_group_option.media.translation`.`custom_fields` as `property_group_option.media.translation.customFields` FROM `media_translation` `property_group_option.media.translation` WHERE `property_group_option.media.translation`.`language_id` = ?) `property_group_option.media.media_translation` ON `property_group_option.media.media_translation`.`media_id` = `property_group_option.media`.`id` WHERE `property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x1AÉk…uÊO¯´OçA$\x14óé"
  b"8Çt\x150ÜG]…F`„\x111\x1Fk"
  b"v\x07\x01kŠ‡CŶâF&t‰\x1Cø"
  b"""
    \x01\x0EÝ?Øn@^³\n
    ìT¬& 
    """
  b"9+ý”ä-N6†êc@½àÄõ"
  b"\x01Šjf“Ç~Ó~ËêY~¶z"
  b"\x01Šnó¬dq`­ÿòþÌ?×Þ"
  b"iÕ¹r\x1DÉMRŽcˆÆ‹#-\x01"
  b"¾·)æ‘åH€ók’¸˜Ð¸"
  b"Õ3#Mñ}Iܶ×9qbóŸ\n"
  b"KaÆYásI!ˆ:⟣jý¡"
  b"žUðh\x01ÏI扄8d:´\x04b"
  b"ÿM8ã\x0FoNë¤\x0EEU\x08œ£¤"
  b"õµä"\x16cH:®Ó\x1AU‰½Dˆ"
  b"+Xšöâ\x15Fe§7C?\x07Ï‹e"
  b"}ÓöZj¬Lº¨B\x16\x00U=r "
  b"›òàÌ£…O_¤¢\x04$þ\eë\x04"
  b";iY‡m\x1AFϝSgf~z K"
  b".çX¤¨\x04N+ŒóL‰ÔZ0\x03"
  b"0ÒœñA1A%–l\x14\x00³ØuÏ"
  b"\x01Œ\x15â"}p‡e4Î\x02Úå"
  b"=\x05 sH\x0EJB¦»[ ¬sëº"
  b"M,ÇkúhNˆ‰®‚\x13V=óö"
  b"Zõ°\x1FK8I\§-FܪÄ$±"
  b"Ü`4UîULp·#c\x14w¥2å"
  b"CíÕnN®Bð¡@\x17\x17(ŠQü"
  b"êÂ\x08nòÉF¨ƒ\x0FE²â}+Ö"
  b"\x1F8†ûV\x11E’‹lö(n5«É"
  b"Õ–¤nä\x06L¯…õ\e3\x0F\x05\x01Å"
  b"\x01Œ\x15‚\x0Fr~¾·U\x00ï\x16$|"
  b"rî¹6™œO©²\x18~qèÚ6\x1A"
  b"\x01‹\x1E1\x08iph•™ÜT\x08šI"
  b"#\x15Ñýˆ\x03C†²/1FEA¶î"
  b"ŽÔ\x0F¶j˜AñŠ>\x02¶F\x1C¨ˆ"
  b"’\x1A/¡?@U©Û\x12Wä\x1EÁé"
  b"""
    ZbW\n
    yÏ@ˆœ9­ŽãÓ6E
    """
  b"""
    j÷•>;ºIZ…ÀŒx\n
    :\x18ß
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
7.70 ms
(1.74%) 		1 
-- product-price-calculator::units::read
SELECT `unit`.`id` as `unit.id`, `unit`.`created_at` as `unit.createdAt`, `unit`.`updated_at` as `unit.updatedAt`, `unit.translation.shortCode`, `unit.translation.shortCode` as `unit.shortCode`, `unit.translation.name`, `unit.translation.name` as `unit.name`, `unit.translation.customFields`, `unit.translation.customFields` as `unit.customFields` FROM `unit` LEFT JOIN (SELECT `unit.translation`.`unit_id`, `unit.translation`.`short_code` as `unit.translation.shortCode`, `unit.translation`.`name` as `unit.translation.name`, `unit.translation`.`custom_fields` as `unit.translation.customFields` FROM `unit_translation` `unit.translation` WHERE `unit.translation`.`language_id` = ?) `unit.unit_translation` ON `unit.unit_translation`.`unit_id` = `unit`.`id`
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
7.01 ms
(1.58%) 		1 
SELECT `dreisc_seo_redirect`.`id` as `dreisc_seo_redirect.id`, `dreisc_seo_redirect`.`active` as `dreisc_seo_redirect.active`, `dreisc_seo_redirect`.`redirect_http_status_code` as `dreisc_seo_redirect.redirectHttpStatusCode`, `dreisc_seo_redirect`.`source_type` as `dreisc_seo_redirect.sourceType`, `dreisc_seo_redirect`.`has_source_sales_channel_domain_restriction` as `dreisc_seo_redirect.hasSourceSalesChannelDomainRestriction`, `dreisc_seo_redirect`.`source_sales_channel_domain_restriction_ids` as `dreisc_seo_redirect.sourceSalesChannelDomainRestrictionIds`, `dreisc_seo_redirect`.`source_sales_channel_domain_id` as `dreisc_seo_redirect.sourceSalesChannelDomainId`, `dreisc_seo_redirect`.`source_path` as `dreisc_seo_redirect.sourcePath`, `dreisc_seo_redirect`.`source_product_id` as `dreisc_seo_redirect.sourceProductId`, `dreisc_seo_redirect`.`source_product_version_id` as `dreisc_seo_redirect.sourceProductVersionId`, `dreisc_seo_redirect`.`source_category_id` as `dreisc_seo_redirect.sourceCategoryId`, `dreisc_seo_redirect`.`source_category_version_id` as `dreisc_seo_redirect.sourceCategoryVersionId`, `dreisc_seo_redirect`.`redirect_type` as `dreisc_seo_redirect.redirectType`, `dreisc_seo_redirect`.`redirect_url` as `dreisc_seo_redirect.redirectUrl`, `dreisc_seo_redirect`.`redirect_sales_channel_domain_id` as `dreisc_seo_redirect.redirectSalesChannelDomainId`, `dreisc_seo_redirect`.`redirect_path` as `dreisc_seo_redirect.redirectPath`, `dreisc_seo_redirect`.`redirect_product_id` as `dreisc_seo_redirect.redirectProductId`, `dreisc_seo_redirect`.`redirect_product_version_id` as `dreisc_seo_redirect.redirectProductVersionId`, `dreisc_seo_redirect`.`redirect_category_id` as `dreisc_seo_redirect.redirectCategoryId`, `dreisc_seo_redirect`.`redirect_category_version_id` as `dreisc_seo_redirect.redirectCategoryVersionId`, `dreisc_seo_redirect`.`has_deviating_redirect_sales_channel_domain` as `dreisc_seo_redirect.hasDeviatingRedirectSalesChannelDomain`, `dreisc_seo_redirect`.`deviating_redirect_sales_channel_domain_id` as `dreisc_seo_redirect.deviatingRedirectSalesChannelDomainId`, `dreisc_seo_redirect`.`parameter_forwarding` as `dreisc_seo_redirect.parameterForwarding`, `dreisc_seo_redirect`.`created_at` as `dreisc_seo_redirect.createdAt`, `dreisc_seo_redirect`.`updated_at` as `dreisc_seo_redirect.updatedAt` FROM `dreisc_seo_redirect` WHERE ((`dreisc_seo_redirect`.`active` = ? AND `dreisc_seo_redirect`.`source_type` = ? AND `dreisc_seo_redirect`.`source_sales_channel_domain_id` = ? AND `dreisc_seo_redirect`.`source_path` = ?))
Parameters: 
[
  true
  "url"
  b"k:ßè\r+I宝öÂ\x7Fˆ°×"
  "t/home-office/"
]
View formatted query    View runnable query    Explain query    View query backtrace
6.98 ms
(1.58%) 		1 
-- product-listing-route::loading::association::prices::read
SELECT `product_price`.`id` as `product_price.id`, `product_price`.`version_id` as `product_price.versionId`, `product_price`.`product_id` as `product_price.productId`, `product_price`.`product_version_id` as `product_price.productVersionId`, `product_price`.`rule_id` as `product_price.ruleId`, `product_price`.`price` as `product_price.price`, `product_price`.`quantity_start` as `product_price.quantityStart`, `product_price`.`quantity_end` as `product_price.quantityEnd`, `product_price`.`custom_fields` as `product_price.customFields`, `product_price`.`created_at` as `product_price.createdAt`, `product_price`.`updated_at` as `product_price.updatedAt` FROM `product_price` WHERE (`product_price`.`version_id` = ?) AND (((`product_price`.`product_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01Š„\x0E-Çr\x0F£½?röDõL"
  b"\x01Š„÷\x16\x12q ¬ð™ÞÅEÕd"
  b"\x01Š±Z™¬sN½¹s\x193œ®Z"
  b"\x01Š±ŸÌs’"\eº§\x1A\x18°"
  b"\x01ŠÍîáup€!@›£ùѱ"
  b"\x01ŠÍò¾ßqHº‹ÐLŽÔ\rÊ"
  b"\x01ŠÎ\x00ÿ4sA½¬(\x01Ö?˜$"
  b"\x01ŠÐCÁ˜s¢³F—¬Pè¿$"
  b"\x01ŠÐTì\x15pV»_Š¿îä\x13K"
  b"\x01ŠÑ³—vqØ–IåOƒ÷8\x07"
  b"\x01Šì°å.rŠ…†¸-k/\x13K"
  b"\x01‹#0øNp¢‰ã÷8ÊY\x1ET"
  b"\x01‹„¡HŠs~’wIåÒ\x00›!"
  b"\x01Œ\x00h\x10Bpe­\Î\x0Fò\x01\x14Ñ"
  b"\x01Œ\x00k¤Ër­¶\x13Lvu™é"
  b"\x01Œ?\x1CkÀpó’Ü dT®‡‰"
  b"\x01ŒsyK”p\x1F´`§aef9 "
  b"\x01¹Årùq;¦Ùmœì\x03Ò\x1F"
  b"\x01º'•°p¼ˆàæ¢vg»]"
  b"\x01º„}|q5‚..‰ÛC\x0FR"
  b"\x01)úåóp\x1F½\x03ÿ¦äy\x02û"
  b"\x01‘¼°ûbq»bXš‚Xß."
  b"\x01‘ÒÕ\x0E\ep¹¨ÒӐP·\t\x08"
  b"\x01‘ê»éqy«Ò\rä%\x15«C"
  b"\x01’q]«år\x7F…p\x1E\e\x10S["
  b"\x01’q«¥­qD“ñ0\x1CÜÅ.ø"
  b"\x01”n±`Qp6«sÜ‹è°"g"
  b"\x01™\x10kZ²qý¸Ií¦H\x1F\x05†"
  b"\x01™\x13ð,Ïr­šHBœ\x00q…ò"
  b"\x01™\x14[“ƒs¾ð\x1Cºü\x10¢k"
  b"\x01™[ðͲph§ü\x0FR8D\tÔ"
  b"\x0Evi;tfH˜¿*ûëŒûJ\x13"
  b"'Í`³³ÙJ\x1A÷¥õ£¡j"
  b"^\x19æó„†EZ¬\x05ë‘\f&33"
  b"fL¢à¢­GB¸) 2›¦\x01ò"
  b"o<púR¾A6 ÄŒ†¢<Üò"
  b"z3}ëòŽF×®Ò™ø»Aÿ_"
  b"™kB(ä·F݁Yˆ¼ˆy×"
  b"Ï'¡UQèD\x06•Oíhl±‚z"
  b"ÿgW}\x19VN‰¿’ªÐ\x18~š"
  b"6À–E\x16èNA¤B®ïŽ'È~"
  b"cÊ“\f\x1A_I牐Î\x12q\x03€"
  b"úšÿ=•³C7¡£xh@peâ"
  b"\x01Š±–U\x1CqˆuaÐjäì\t"
  b"Îw[E¡¶G¦¸3\x17Üa¸\x1EQ"
  b"˜\x04\v\x12­÷@_¼à°ä7—sï"
  b"ßûÌÐCŒNžj;VßkÓF"
  b"Îèª\x16žãHȶwéÖLåiQ"
  b"†Vu>\x7F"E;›•¨i—™–"
  b"ž‰~™îàG_²¢ÈÓüZPr"
  b"ª\x05iæa>B\x18¬ýf(y¥¶°"
  b"_WHbç6D'¯.RßJ\x1Eж"
  b"ÆÞ‚ö_{FMŠ \x18Ä!\x1Ejô"
  b"\x1Co(\x05!ýM!»¾\x10J‡gµ\x19"
  b"»c)Š\tKAy¦\x15¤±Nw!r"
  b"\x01‡F-qqH•QÜÊ\x02I)("
  b"\x01‡a¬kqD¿Y×Gò5w¿"
  b"\x01‡rŽÅx¼°\x1CDnuD¯"
  b"7cXÇ\x1CäDZ¤ys?UrºG"
  b"\x01‘¼¯\x03Êtý‹^Ô'šI0ö"
  b"\x0FäÁŽ¶¨H•¹n‰ó\x11"}c"
  b"jó\x12\›kNÕ¿´µ?ëEëc"
  b"\x01’qYó…q\x1C’ÂOã&­Ös"
  b"\x01’qY.\x07s¯¦\x1AÞ\x16º\x7FÒy"
  b"\x01”n¦ŠäpêŽàÒ…ô\x01àU"
  b"\x01™\tkÍëq" \x19C!Ää¢\x1E"
  b"\x01™\x13ëÄlp¢ºÐùyÈg'D"
  b"\x01™\x14[ƒEs\r••H§Xi@÷"
  b"\x01™[ðÄ\x1Cq¿Ž•Ž]YŽR,"
  b"±lqë~ÿMr¶I\x01\x16\x10,¢±"
  b"nÛÎîsU@?‡ºóÏ@Î{€"
  b"e\x00¾+¦EN¼´f9ìÙu#k"
]
View formatted query    View runnable query    Explain query    View query backtrace
6.22 ms
(1.40%) 		1 
-- product-listing-route::loading::aggregation::properties-filter
SELECT LOWER(HEX(`product.properties`.`id`)) as `properties.key`, COUNT(`product`.`id`) as `properties.count` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `product_property` `product.properties.mapping` ON `product`.`properties` = `product.properties.mapping`.`product_id`  AND `product`.`version_id` = `product.properties.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` LEFT JOIN `property_group_option` `product.properties` ON `product.properties.mapping`.`property_group_option_id` = `product.properties`.`id`  WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?))) AND (((`product.properties`.`property_group_id` IN (?, ?, ?, ?, ?)))) GROUP BY `product.properties`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"i„öTY#Hê­h€Ã_MPÂ"
  true
  b"2•j=\x7Fà@4ž\x05‰F\x00Q»*"
  null
  b"’'CÙX|Iõ•DºŽ\x05èàÈ"
  b"Õœ\vÏ\x06àMn‹)â&ç\x19€¼"
  b"»ÈëjõtL°¤êÐÓÄ)}–"
  b"–ŒèŒ\x0FrC–¹ÂCÛx¶¯"
  b"ÃÆÛ©[oD6ŠO$eÕ¥Ö¤"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.38 ms
(0.99%) 		1 
SELECT `product_configurator_setting`.`id` as `product_configurator_setting.id`, `product_configurator_setting`.`version_id` as `product_configurator_setting.versionId`, `product_configurator_setting`.`product_id` as `product_configurator_setting.productId`, `product_configurator_setting`.`product_version_id` as `product_configurator_setting.productVersionId`, `product_configurator_setting`.`media_id` as `product_configurator_setting.mediaId`, `product_configurator_setting`.`property_group_option_id` as `product_configurator_setting.optionId`, `product_configurator_setting`.`price` as `product_configurator_setting.price`, `product_configurator_setting`.`position` as `product_configurator_setting.position`, `product_configurator_setting`.`custom_fields` as `product_configurator_setting.customFields`, `product_configurator_setting`.`created_at` as `product_configurator_setting.createdAt`, `product_configurator_setting`.`updated_at` as `product_configurator_setting.updatedAt`, `product_configurator_setting.option`.`id` as `product_configurator_setting.option.id`, `product_configurator_setting.option`.`property_group_id` as `product_configurator_setting.option.groupId`, `product_configurator_setting.option`.`color_hex_code` as `product_configurator_setting.option.colorHexCode`, `product_configurator_setting.option`.`media_id` as `product_configurator_setting.option.mediaId`, `product_configurator_setting.option`.`created_at` as `product_configurator_setting.option.createdAt`, `product_configurator_setting.option`.`updated_at` as `product_configurator_setting.option.updatedAt`, `product_configurator_setting.option.group`.`id` as `product_configurator_setting.option.group.id`, `product_configurator_setting.option.group`.`display_type` as `product_configurator_setting.option.group.displayType`, `product_configurator_setting.option.group`.`sorting_type` as `product_configurator_setting.option.group.sortingType`, `product_configurator_setting.option.group`.`filterable` as `product_configurator_setting.option.group.filterable`, `product_configurator_setting.option.group`.`visible_on_product_detail_page` as `product_configurator_setting.option.group.visibleOnProductDetailPage`, `product_configurator_setting.option.group`.`created_at` as `product_configurator_setting.option.group.createdAt`, `product_configurator_setting.option.group`.`updated_at` as `product_configurator_setting.option.group.updatedAt`, `product_configurator_setting.option.group`.`icon_media_id` as `product_configurator_setting.option.group.iconMediaId`, `product_configurator_setting.option.group.translation.name`, `product_configurator_setting.option.group.translation.name` as `product_configurator_setting.option.group.name`, `product_configurator_setting.option.group.translation.description`, `product_configurator_setting.option.group.translation.description` as `product_configurator_setting.option.group.description`, `product_configurator_setting.option.group.translation.position`, `product_configurator_setting.option.group.translation.position` as `product_configurator_setting.option.group.position`, `product_configurator_setting.option.group.translation.customFields`, `product_configurator_setting.option.group.translation.customFields` as `product_configurator_setting.option.group.customFields`, `product_configurator_setting.option.media`.`id` as `product_configurator_setting.option.media.id`, `product_configurator_setting.option.media`.`user_id` as `product_configurator_setting.option.media.userId`, `product_configurator_setting.option.media`.`media_folder_id` as `product_configurator_setting.option.media.mediaFolderId`, `product_configurator_setting.option.media`.`mime_type` as `product_configurator_setting.option.media.mimeType`, `product_configurator_setting.option.media`.`file_extension` as `product_configurator_setting.option.media.fileExtension`, `product_configurator_setting.option.media`.`uploaded_at` as `product_configurator_setting.option.media.uploadedAt`, `product_configurator_setting.option.media`.`file_name` as `product_configurator_setting.option.media.fileName`, `product_configurator_setting.option.media`.`file_size` as `product_configurator_setting.option.media.fileSize`, `product_configurator_setting.option.media`.`media_type` as `product_configurator_setting.option.media.mediaTypeRaw`, `product_configurator_setting.option.media`.`meta_data` as `product_configurator_setting.option.media.metaData`, `product_configurator_setting.option.media`.`config` as `product_configurator_setting.option.media.config`, `product_configurator_setting.option.media`.`path` as `product_configurator_setting.option.media.path`, `product_configurator_setting.option.media`.`private` as `product_configurator_setting.option.media.private`, `product_configurator_setting.option.media`.`thumbnails_ro` as `product_configurator_setting.option.media.thumbnailsRo`, `product_configurator_setting.option.media`.`file_hash` as `product_configurator_setting.option.media.fileHash`, `product_configurator_setting.option.media`.`created_at` as `product_configurator_setting.option.media.createdAt`, `product_configurator_setting.option.media`.`updated_at` as `product_configurator_setting.option.media.updatedAt`, `product_configurator_setting.option.media.translation.title`, `product_configurator_setting.option.media.translation.title` as `product_configurator_setting.option.media.title`, `product_configurator_setting.option.media.translation.alt`, `product_configurator_setting.option.media.translation.alt` as `product_configurator_setting.option.media.alt`, `product_configurator_setting.option.media.translation.customFields`, `product_configurator_setting.option.media.translation.customFields` as `product_configurator_setting.option.media.customFields`, `product_configurator_setting.option.translation.name`, `product_configurator_setting.option.translation.name` as `product_configurator_setting.option.name`, `product_configurator_setting.option.translation.position`, `product_configurator_setting.option.translation.position` as `product_configurator_setting.option.position`, `product_configurator_setting.option.translation.customFields`, `product_configurator_setting.option.translation.customFields` as `product_configurator_setting.option.customFields`, `product_configurator_setting.media`.`id` as `product_configurator_setting.media.id`, `product_configurator_setting.media`.`user_id` as `product_configurator_setting.media.userId`, `product_configurator_setting.media`.`media_folder_id` as `product_configurator_setting.media.mediaFolderId`, `product_configurator_setting.media`.`mime_type` as `product_configurator_setting.media.mimeType`, `product_configurator_setting.media`.`file_extension` as `product_configurator_setting.media.fileExtension`, `product_configurator_setting.media`.`uploaded_at` as `product_configurator_setting.media.uploadedAt`, `product_configurator_setting.media`.`file_name` as `product_configurator_setting.media.fileName`, `product_configurator_setting.media`.`file_size` as `product_configurator_setting.media.fileSize`, `product_configurator_setting.media`.`media_type` as `product_configurator_setting.media.mediaTypeRaw`, `product_configurator_setting.media`.`meta_data` as `product_configurator_setting.media.metaData`, `product_configurator_setting.media`.`config` as `product_configurator_setting.media.config`, `product_configurator_setting.media`.`path` as `product_configurator_setting.media.path`, `product_configurator_setting.media`.`private` as `product_configurator_setting.media.private`, `product_configurator_setting.media`.`thumbnails_ro` as `product_configurator_setting.media.thumbnailsRo`, `product_configurator_setting.media`.`file_hash` as `product_configurator_setting.media.fileHash`, `product_configurator_setting.media`.`created_at` as `product_configurator_setting.media.createdAt`, `product_configurator_setting.media`.`updated_at` as `product_configurator_setting.media.updatedAt`, `product_configurator_setting.media.translation.title`, `product_configurator_setting.media.translation.title` as `product_configurator_setting.media.title`, `product_configurator_setting.media.translation.alt`, `product_configurator_setting.media.translation.alt` as `product_configurator_setting.media.alt`, `product_configurator_setting.media.translation.customFields`, `product_configurator_setting.media.translation.customFields` as `product_configurator_setting.media.customFields` FROM `product_configurator_setting` LEFT JOIN `property_group_option` `product_configurator_setting.option` ON `product_configurator_setting`.`property_group_option_id` = `product_configurator_setting.option`.`id` LEFT JOIN `media` `product_configurator_setting.media` ON `product_configurator_setting`.`media_id` = `product_configurator_setting.media`.`id` LEFT JOIN `property_group` `product_configurator_setting.option.group` ON `product_configurator_setting.option`.`property_group_id` = `product_configurator_setting.option.group`.`id` LEFT JOIN `media` `product_configurator_setting.option.media` ON `product_configurator_setting.option`.`media_id` = `product_configurator_setting.option.media`.`id` LEFT JOIN (SELECT `product_configurator_setting.option.translation`.`property_group_option_id`, `product_configurator_setting.option.translation`.`name` as `product_configurator_setting.option.translation.name`, `product_configurator_setting.option.translation`.`position` as `product_configurator_setting.option.translation.position`, `product_configurator_setting.option.translation`.`custom_fields` as `product_configurator_setting.option.translation.customFields` FROM `property_group_option_translation` `product_configurator_setting.option.translation` WHERE `product_configurator_setting.option.translation`.`language_id` = ?) `product_configurator_setting.option.property_group_option_translation` ON `product_configurator_setting.option.property_group_option_translation`.`property_group_option_id` = `product_configurator_setting.option`.`id` LEFT JOIN (SELECT `product_configurator_setting.option.group.translation`.`property_group_id`, `product_configurator_setting.option.group.translation`.`name` as `product_configurator_setting.option.group.translation.name`, `product_configurator_setting.option.group.translation`.`description` as `product_configurator_setting.option.group.translation.description`, `product_configurator_setting.option.group.translation`.`position` as `product_configurator_setting.option.group.translation.position`, `product_configurator_setting.option.group.translation`.`custom_fields` as `product_configurator_setting.option.group.translation.customFields` FROM `property_group_translation` `product_configurator_setting.option.group.translation` WHERE `product_configurator_setting.option.group.translation`.`language_id` = ?) `product_configurator_setting.option.group.property_group_translation` ON `product_configurator_setting.option.group.property_group_translation`.`property_group_id` = `product_configurator_setting.option.group`.`id` LEFT JOIN (SELECT `product_configurator_setting.option.media.translation`.`media_id`, `product_configurator_setting.option.media.translation`.`alt` as `product_configurator_setting.option.media.translation.alt`, `product_configurator_setting.option.media.translation`.`title` as `product_configurator_setting.option.media.translation.title`, `product_configurator_setting.option.media.translation`.`custom_fields` as `product_configurator_setting.option.media.translation.customFields` FROM `media_translation` `product_configurator_setting.option.media.translation` WHERE `product_configurator_setting.option.media.translation`.`language_id` = ?) `product_configurator_setting.option.media.media_translation` ON `product_configurator_setting.option.media.media_translation`.`media_id` = `product_configurator_setting.option.media`.`id` LEFT JOIN (SELECT `product_configurator_setting.media.translation`.`media_id`, `product_configurator_setting.media.translation`.`alt` as `product_configurator_setting.media.translation.alt`, `product_configurator_setting.media.translation`.`title` as `product_configurator_setting.media.translation.title`, `product_configurator_setting.media.translation`.`custom_fields` as `product_configurator_setting.media.translation.customFields` FROM `media_translation` `product_configurator_setting.media.translation` WHERE `product_configurator_setting.media.translation`.`language_id` = ?) `product_configurator_setting.media.media_translation` ON `product_configurator_setting.media.media_translation`.`media_id` = `product_configurator_setting.media`.`id` WHERE (`product_configurator_setting`.`version_id` = ?) AND (((`product_configurator_setting`.`product_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01‡F-qqH•QÜÊ\x02I)("
  b"\x01‘¼¯\x03Êtý‹^Ô'šI0ö"
  b"\x01‡a¬kqD¿Y×Gò5w¿"
  b"\x01‡rŽÅx¼°\x1CDnuD¯"
  b"_WHbç6D'¯.RßJ\x1Eж"
  b"Ï'¡UQèD\x06•Oíhl±‚z"
  b"ÆÞ‚ö_{FMŠ \x18Ä!\x1Ejô"
  b"\x01Œ\x00k¤Ër­¶\x13Lvu™é"
  b"\x01Œ\x00h\x10Bpe­\Î\x0Fò\x01\x14Ñ"
  b"z3}ëòŽF×®Ò™ø»Aÿ_"
  b"\x01’qY.\x07s¯¦\x1AÞ\x16º\x7FÒy"
  b"\x01’qYó…q\x1C’ÂOã&­Ös"
  b"\x01™\tkÍëq" \x19C!Ää¢\x1E"
  b"\x01”n¦ŠäpêŽàÒ…ô\x01àU"
  b"\x01™\x13ëÄlp¢ºÐùyÈg'D"
  b"\x01™\x14[ƒEs\r••H§Xi@÷"
  b"\x01™[ðÄ\x1Cq¿Ž•Ž]YŽR,"
  b"\x0Evi;tfH˜¿*ûëŒûJ\x13"
  b"†Vu>\x7F"E;›•¨i—™–"
  b"Îèª\x16žãHȶwéÖLåiQ"
  b"7cXÇ\x1CäDZ¤ys?UrºG"
  b"\x01Š±–U\x1CqˆuaÐjäì\t"
  b"úšÿ=•³C7¡£xh@peâ"
  b"Îw[E¡¶G¦¸3\x17Üa¸\x1EQ"
  b"ž‰~™îàG_²¢ÈÓüZPr"
  b"˜\x04\v\x12­÷@_¼à°ä7—sï"
  b"»c)Š\tKAy¦\x15¤±Nw!r"
  b"\x1Co(\x05!ýM!»¾\x10J‡gµ\x19"
  b"6À–E\x16èNA¤B®ïŽ'È~"
  b"e\x00¾+¦EN¼´f9ìÙu#k"
  b"±lqë~ÿMr¶I\x01\x16\x10,¢±"
  b"cÊ“\f\x1A_I牐Î\x12q\x03€"
  b"ª\x05iæa>B\x18¬ýf(y¥¶°"
  b"\x0FäÁŽ¶¨H•¹n‰ó\x11"}c"
  b"'Í`³³ÙJ\x1A÷¥õ£¡j"
  b"™kB(ä·F݁Yˆ¼ˆy×"
  b"^\x19æó„†EZ¬\x05ë‘\f&33"
  b"nÛÎîsU@?‡ºóÏ@Î{€"
  b"jó\x12\›kNÕ¿´µ?ëEëc"
  b"ßûÌÐCŒNžj;VßkÓF"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.33 ms
(0.98%) 		1 
SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group`.`icon_media_id` as `property_group_option.group.iconMediaId`, `property_group_option.group.translation.name`, `property_group_option.group.translation.name` as `property_group_option.group.name`, `property_group_option.group.translation.description`, `property_group_option.group.translation.description` as `property_group_option.group.description`, `property_group_option.group.translation.position`, `property_group_option.group.translation.position` as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, `property_group_option.group.translation.customFields` as `property_group_option.group.customFields`, `property_group_option.media`.`id` as `property_group_option.media.id`, `property_group_option.media`.`user_id` as `property_group_option.media.userId`, `property_group_option.media`.`media_folder_id` as `property_group_option.media.mediaFolderId`, `property_group_option.media`.`mime_type` as `property_group_option.media.mimeType`, `property_group_option.media`.`file_extension` as `property_group_option.media.fileExtension`, `property_group_option.media`.`uploaded_at` as `property_group_option.media.uploadedAt`, `property_group_option.media`.`file_name` as `property_group_option.media.fileName`, `property_group_option.media`.`file_size` as `property_group_option.media.fileSize`, `property_group_option.media`.`media_type` as `property_group_option.media.mediaTypeRaw`, `property_group_option.media`.`meta_data` as `property_group_option.media.metaData`, `property_group_option.media`.`config` as `property_group_option.media.config`, `property_group_option.media`.`path` as `property_group_option.media.path`, `property_group_option.media`.`private` as `property_group_option.media.private`, `property_group_option.media`.`thumbnails_ro` as `property_group_option.media.thumbnailsRo`, `property_group_option.media`.`file_hash` as `property_group_option.media.fileHash`, `property_group_option.media`.`created_at` as `property_group_option.media.createdAt`, `property_group_option.media`.`updated_at` as `property_group_option.media.updatedAt`, `property_group_option.media.translation.title`, `property_group_option.media.translation.title` as `property_group_option.media.title`, `property_group_option.media.translation.alt`, `property_group_option.media.translation.alt` as `property_group_option.media.alt`, `property_group_option.media.translation.customFields`, `property_group_option.media.translation.customFields` as `property_group_option.media.customFields`, `property_group_option.translation.name`, `property_group_option.translation.name` as `property_group_option.name`, `property_group_option.translation.position`, `property_group_option.translation.position` as `property_group_option.position`, `property_group_option.translation.customFields`, `property_group_option.translation.customFields` as `property_group_option.customFields` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN `media` `property_group_option.media` ON `property_group_option`.`media_id` = `property_group_option.media`.`id` LEFT JOIN (SELECT `property_group_option.translation`.`property_group_option_id`, `property_group_option.translation`.`name` as `property_group_option.translation.name`, `property_group_option.translation`.`position` as `property_group_option.translation.position`, `property_group_option.translation`.`custom_fields` as `property_group_option.translation.customFields` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.`language_id` = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN (SELECT `property_group_option.group.translation`.`property_group_id`, `property_group_option.group.translation`.`name` as `property_group_option.group.translation.name`, `property_group_option.group.translation`.`description` as `property_group_option.group.translation.description`, `property_group_option.group.translation`.`position` as `property_group_option.group.translation.position`, `property_group_option.group.translation`.`custom_fields` as `property_group_option.group.translation.customFields` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.`language_id` = ?) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.media.translation`.`media_id`, `property_group_option.media.translation`.`alt` as `property_group_option.media.translation.alt`, `property_group_option.media.translation`.`title` as `property_group_option.media.translation.title`, `property_group_option.media.translation`.`custom_fields` as `property_group_option.media.translation.customFields` FROM `media_translation` `property_group_option.media.translation` WHERE `property_group_option.media.translation`.`language_id` = ?) `property_group_option.media.media_translation` ON `property_group_option.media.media_translation`.`media_id` = `property_group_option.media`.`id` WHERE `property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"""
    \x01\x0EÝ?Øn@^³\n
    ìT¬& 
    """
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"KaÆYásI!ˆ:⟣jý¡"
  b"8Çt\x150ÜG]…F`„\x111\x1Fk"
  b"KaÆYásI!ˆ:⟣jý¡"
  b"KaÆYásI!ˆ:⟣jý¡"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x01Šjf“Ç~Ó~ËêY~¶z"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"\x01Šnó¬dq`­ÿòþÌ?×Þ"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"iÕ¹r\x1DÉMRŽcˆÆ‹#-\x01"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"8Çt\x150ÜG]…F`„\x111\x1Fk"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"+Xšöâ\x15Fe§7C?\x07Ï‹e"
  b"}ÓöZj¬Lº¨B\x16\x00U=r "
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"8Çt\x150ÜG]…F`„\x111\x1Fk"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"\x1AÉk…uÊO¯´OçA$\x14óé"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"iÕ¹r\x1DÉMRŽcˆÆ‹#-\x01"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"ÿM8ã\x0FoNë¤\x0EEU\x08œ£¤"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"Õ3#Mñ}Iܶ×9qbóŸ\n"
  b"8Çt\x150ÜG]…F`„\x111\x1Fk"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"iÕ¹r\x1DÉMRŽcˆÆ‹#-\x01"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"¾·)æ‘åH€ók’¸˜Ð¸"
  b"Õ3#Mñ}Iܶ×9qbóŸ\n"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x1AÉk…uÊO¯´OçA$\x14óé"
  b"8Çt\x150ÜG]…F`„\x111\x1Fk"
  b"v\x07\x01kŠ‡CŶâF&t‰\x1Cø"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"›òàÌ£…O_¤¢\x04$þ\eë\x04"
  b";iY‡m\x1AFϝSgf~z K"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"žUðh\x01ÏI扄8d:´\x04b"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"iÕ¹r\x1DÉMRŽcˆÆ‹#-\x01"
  b"Õ3#Mñ}Iܶ×9qbóŸ\n"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"\x01Šjf“Ç~Ó~ËêY~¶z"
  b"\x01Šnó¬dq`­ÿòþÌ?×Þ"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x1AÉk…uÊO¯´OçA$\x14óé"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"v\x07\x01kŠ‡CŶâF&t‰\x1Cø"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x1AÉk…uÊO¯´OçA$\x14óé"
  b"\x1AÉk…uÊO¯´OçA$\x14óé"
  b"8Çt\x150ÜG]…F`„\x111\x1Fk"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"iÕ¹r\x1DÉMRŽcˆÆ‹#-\x01"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"8Çt\x150ÜG]…F`„\x111\x1Fk"
  b"8Çt\x150ÜG]…F`„\x111\x1Fk"
  b"\x1AÉk…uÊO¯´OçA$\x14óé"
  b"8Çt\x150ÜG]…F`„\x111\x1Fk"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"ÿM8ã\x0FoNë¤\x0EEU\x08œ£¤"
  b"iÕ¹r\x1DÉMRŽcˆÆ‹#-\x01"
  b"¾·)æ‘åH€ók’¸˜Ð¸"
  b"õµä"\x16cH:®Ó\x1AU‰½Dˆ"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"8Çt\x150ÜG]…F`„\x111\x1Fk"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"""
    \x01\x0EÝ?Øn@^³\n
    ìT¬& 
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
4.23 ms
(0.96%) 		1 
-- product-listing-route::loading::aggregation::price
SELECT MIN(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)))) as `price.min`, MAX(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)))) as `price.max` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?)))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"i„öTY#Hê­h€Ã_MPÂ"
  true
  b"2•j=\x7Fà@4ž\x05‰F\x00Q»*"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
4.12 ms
(0.93%) 		5 
SELECT `seo_url`.`id` as `seo_url.id`, `seo_url`.`sales_channel_id` as `seo_url.salesChannelId`, `seo_url`.`language_id` as `seo_url.languageId`, `seo_url`.`foreign_key` as `seo_url.foreignKey`, `seo_url`.`route_name` as `seo_url.routeName`, `seo_url`.`path_info` as `seo_url.pathInfo`, `seo_url`.`seo_path_info` as `seo_url.seoPathInfo`, `seo_url`.`is_canonical` as `seo_url.isCanonical`, `seo_url`.`is_modified` as `seo_url.isModified`, `seo_url`.`is_deleted` as `seo_url.isDeleted`, `seo_url`.`custom_fields` as `seo_url.customFields`, `seo_url`.`created_at` as `seo_url.createdAt`, `seo_url`.`updated_at` as `seo_url.updatedAt` FROM `seo_url` WHERE (`seo_url`.`language_id` = ? AND `seo_url`.`sales_channel_id` <=> ? AND `seo_url`.`route_name` = ? AND `seo_url`.`foreign_key` = ? AND `seo_url`.`is_canonical` = ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  null
  "frontend.navigation.page"
  b"2•j=\x7Fà@4ž\x05‰F\x00Q»*"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
3.91 ms
(0.88%) 		1 
-- product-listing-route::loading::association::seoUrls::read
SELECT `seo_url`.`id` as `seo_url.id`, `seo_url`.`sales_channel_id` as `seo_url.salesChannelId`, `seo_url`.`language_id` as `seo_url.languageId`, `seo_url`.`foreign_key` as `seo_url.foreignKey`, `seo_url`.`route_name` as `seo_url.routeName`, `seo_url`.`path_info` as `seo_url.pathInfo`, `seo_url`.`seo_path_info` as `seo_url.seoPathInfo`, `seo_url`.`is_canonical` as `seo_url.isCanonical`, `seo_url`.`is_modified` as `seo_url.isModified`, `seo_url`.`is_deleted` as `seo_url.isDeleted`, `seo_url`.`custom_fields` as `seo_url.customFields`, `seo_url`.`created_at` as `seo_url.createdAt`, `seo_url`.`updated_at` as `seo_url.updatedAt` FROM `seo_url` WHERE (`seo_url`.`language_id` = ? AND (`seo_url`.`sales_channel_id` = ? OR `seo_url`.`sales_channel_id` <=> ?) AND `seo_url`.`is_canonical` = ? AND `seo_url`.`is_deleted` = ? AND (`seo_url`.`foreign_key` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"i„öTY#Hê­h€Ã_MPÂ"
  null
  true
  false
  b"\x01Š„\x0E-Çr\x0F£½?röDõL"
  b"\x01Š„÷\x16\x12q ¬ð™ÞÅEÕd"
  b"\x01Š±Z™¬sN½¹s\x193œ®Z"
  b"\x01Š±ŸÌs’"\eº§\x1A\x18°"
  b"\x01ŠÍîáup€!@›£ùѱ"
  b"\x01ŠÍò¾ßqHº‹ÐLŽÔ\rÊ"
  b"\x01ŠÎ\x00ÿ4sA½¬(\x01Ö?˜$"
  b"\x01ŠÐCÁ˜s¢³F—¬Pè¿$"
  b"\x01ŠÐTì\x15pV»_Š¿îä\x13K"
  b"\x01ŠÑ³—vqØ–IåOƒ÷8\x07"
  b"\x01Šì°å.rŠ…†¸-k/\x13K"
  b"\x01‹#0øNp¢‰ã÷8ÊY\x1ET"
  b"\x01‹„¡HŠs~’wIåÒ\x00›!"
  b"\x01Œ\x00h\x10Bpe­\Î\x0Fò\x01\x14Ñ"
  b"\x01Œ\x00k¤Ër­¶\x13Lvu™é"
  b"\x01Œ?\x1CkÀpó’Ü dT®‡‰"
  b"\x01ŒsyK”p\x1F´`§aef9 "
  b"\x01¹Årùq;¦Ùmœì\x03Ò\x1F"
  b"\x01º'•°p¼ˆàæ¢vg»]"
  b"\x01º„}|q5‚..‰ÛC\x0FR"
  b"\x01)úåóp\x1F½\x03ÿ¦äy\x02û"
  b"\x01‘¼°ûbq»bXš‚Xß."
  b"\x01‘ÒÕ\x0E\ep¹¨ÒӐP·\t\x08"
  b"\x01‘ê»éqy«Ò\rä%\x15«C"
  b"\x01’q]«år\x7F…p\x1E\e\x10S["
  b"\x01’q«¥­qD“ñ0\x1CÜÅ.ø"
  b"\x01”n±`Qp6«sÜ‹è°"g"
  b"\x01™\x10kZ²qý¸Ií¦H\x1F\x05†"
  b"\x01™\x13ð,Ïr­šHBœ\x00q…ò"
  b"\x01™\x14[“ƒs¾ð\x1Cºü\x10¢k"
  b"\x01™[ðͲph§ü\x0FR8D\tÔ"
  b"\x0Evi;tfH˜¿*ûëŒûJ\x13"
  b"'Í`³³ÙJ\x1A÷¥õ£¡j"
  b"^\x19æó„†EZ¬\x05ë‘\f&33"
  b"fL¢à¢­GB¸) 2›¦\x01ò"
  b"o<púR¾A6 ÄŒ†¢<Üò"
  b"z3}ëòŽF×®Ò™ø»Aÿ_"
  b"™kB(ä·F݁Yˆ¼ˆy×"
  b"Ï'¡UQèD\x06•Oíhl±‚z"
  b"ÿgW}\x19VN‰¿’ªÐ\x18~š"
  b"6À–E\x16èNA¤B®ïŽ'È~"
  b"cÊ“\f\x1A_I牐Î\x12q\x03€"
  b"úšÿ=•³C7¡£xh@peâ"
  b"\x01Š±–U\x1CqˆuaÐjäì\t"
  b"Îw[E¡¶G¦¸3\x17Üa¸\x1EQ"
  b"˜\x04\v\x12­÷@_¼à°ä7—sï"
  b"ßûÌÐCŒNžj;VßkÓF"
  b"Îèª\x16žãHȶwéÖLåiQ"
  b"†Vu>\x7F"E;›•¨i—™–"
  b"ž‰~™îàG_²¢ÈÓüZPr"
  b"ª\x05iæa>B\x18¬ýf(y¥¶°"
  b"_WHbç6D'¯.RßJ\x1Eж"
  b"ÆÞ‚ö_{FMŠ \x18Ä!\x1Ejô"
  b"\x1Co(\x05!ýM!»¾\x10J‡gµ\x19"
  b"»c)Š\tKAy¦\x15¤±Nw!r"
  b"\x01‡F-qqH•QÜÊ\x02I)("
  b"\x01‡a¬kqD¿Y×Gò5w¿"
  b"\x01‡rŽÅx¼°\x1CDnuD¯"
  b"7cXÇ\x1CäDZ¤ys?UrºG"
  b"\x01‘¼¯\x03Êtý‹^Ô'šI0ö"
  b"\x0FäÁŽ¶¨H•¹n‰ó\x11"}c"
  b"jó\x12\›kNÕ¿´µ?ëEëc"
  b"\x01’qYó…q\x1C’ÂOã&­Ös"
  b"\x01’qY.\x07s¯¦\x1AÞ\x16º\x7FÒy"
  b"\x01”n¦ŠäpêŽàÒ…ô\x01àU"
  b"\x01™\tkÍëq" \x19C!Ää¢\x1E"
  b"\x01™\x13ëÄlp¢ºÐùyÈg'D"
  b"\x01™\x14[ƒEs\r••H§Xi@÷"
  b"\x01™[ðÄ\x1Cq¿Ž•Ž]YŽR,"
  b"±lqë~ÿMr¶I\x01\x16\x10,¢±"
  b"nÛÎîsU@?‡ºóÏ@Î{€"
  b"e\x00¾+¦EN¼´f9ìÙu#k"
]
View formatted query    View runnable query    Explain query    View query backtrace
3.82 ms
(0.86%) 		1 
SELECT COUNT(*) FROM (-- product-listing-route::loading::search-ids
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment`, `product.swpaPosition`.swpa_sorting as swpa_sorting FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `product_category_tree` `product.swpaPosition` ON `product`.`id` = `product.swpaPosition`.`product_id` AND `product.swpaPosition`.category_id=? LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?))) GROUP BY `product`.`display_group`) total
Parameters: 
[
  b"2•j=\x7Fà@4ž\x05‰F\x00Q»*"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"i„öTY#Hê­h€Ã_MPÂ"
  true
  b"2•j=\x7Fà@4ž\x05‰F\x00Q»*"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
2.99 ms
(0.68%) 		1 
-- product-listing-route::loading::aggregation::manufacturer
SELECT LOWER(HEX(IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`))) as `manufacturer` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?))) GROUP BY IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`)
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"i„öTY#Hê­h€Ã_MPÂ"
  true
  b"2•j=\x7Fà@4ž\x05‰F\x00Q»*"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
2.93 ms
(0.66%) 		3 
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.translation.override_1.name`, `category.translation.name`, COALESCE(`category.translation.override_1.name`,`category.translation.name`) as `category.name`, `category.translation.override_1.breadcrumb`, `category.translation.breadcrumb`, COALESCE(`category.translation.override_1.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.override_1.slotConfig`, `category.translation.slotConfig`, COALESCE(`category.translation.override_1.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.override_1.linkType`, `category.translation.linkType`, COALESCE(`category.translation.override_1.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.override_1.internalLink`, `category.translation.internalLink`, COALESCE(`category.translation.override_1.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.override_1.externalLink`, `category.translation.externalLink`, COALESCE(`category.translation.override_1.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.override_1.linkNewTab`, `category.translation.linkNewTab`, COALESCE(`category.translation.override_1.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.override_1.description`, `category.translation.description`, COALESCE(`category.translation.override_1.description`,`category.translation.description`) as `category.description`, `category.translation.override_1.metaTitle`, `category.translation.metaTitle`, COALESCE(`category.translation.override_1.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.override_1.metaDescription`, `category.translation.metaDescription`, COALESCE(`category.translation.override_1.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.override_1.keywords`, `category.translation.keywords`, COALESCE(`category.translation.override_1.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.override_1.customFields`, `category.translation.customFields`, COALESCE(`category.translation.override_1.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.override_1`.`breadcrumb` as `category.translation.override_1.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation.override_1`.`name` as `category.translation.override_1.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation.override_1`.`custom_fields` as `category.translation.override_1.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation.override_1`.`slot_config` as `category.translation.override_1.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation.override_1`.`link_type` as `category.translation.override_1.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation.override_1`.`internal_link` as `category.translation.override_1.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation.override_1`.`external_link` as `category.translation.override_1.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation.override_1`.`link_new_tab` as `category.translation.override_1.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation.override_1`.`description` as `category.translation.override_1.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation.override_1`.`meta_title` as `category.translation.override_1.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation.override_1`.`meta_description` as `category.translation.override_1.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords`, `category.translation.override_1`.`keywords` as `category.translation.override_1.keywords` FROM `category_translation` `category.translation` LEFT JOIN `category_translation` `category.translation.override_1` ON `category.translation`.`category_id` = `category.translation.override_1`.`category_id` AND `category.translation.override_1`.`language_id` = ? AND `category.translation`.`category_version_id` = `category.translation.override_1`.`category_version_id` 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"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"2•j=\x7Fà@4ž\x05‰F\x00Q»*"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.87 ms
(0.65%) 		1 
-- product-listing-route::loading::aggregation::options-filter
SELECT LOWER(HEX(`product.options`.`id`)) as `options.key`, COUNT(`product`.`id`) as `options.count` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `product_option` `product.options.mapping` ON `product`.`id` = `product.options.mapping`.`product_id`  AND `product`.`version_id` = `product.options.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` LEFT JOIN `property_group_option` `product.options` ON `product.options.mapping`.`property_group_option_id` = `product.options`.`id`  WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?))) AND (((`product.options`.`property_group_id` IN (?, ?, ?, ?, ?)))) GROUP BY `product.options`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"i„öTY#Hê­h€Ã_MPÂ"
  true
  b"2•j=\x7Fà@4ž\x05‰F\x00Q»*"
  null
  b"’'CÙX|Iõ•DºŽ\x05èàÈ"
  b"Õœ\vÏ\x06àMn‹)â&ç\x19€¼"
  b"»ÈëjõtL°¤êÐÓÄ)}–"
  b"–ŒèŒ\x0FrC–¹ÂCÛx¶¯"
  b"ÃÆÛ©[oD6ŠO$eÕ¥Ö¤"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.85 ms
(0.64%) 		1 
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
2.43 ms
(0.55%) 		1 
SELECT LOWER(HEX(product.id)), LOWER(HEX(product.parent_id)) as parent_id, product.option_ids as options, product.product_number as productNumber, product.available FROM product LEFT JOIN product parent ON product.parent_id = parent.id WHERE (product.parent_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (product.version_id = ?) AND (IFNULL(product.active, parent.active) = ?) AND (product.option_ids IS NOT NULL)
Parameters: 
[
  b"\x01‡F-qqH•QÜÊ\x02I)("
  b"\x01‘¼¯\x03Êtý‹^Ô'šI0ö"
  b"\x01‡a¬kqD¿Y×Gò5w¿"
  b"\x01‡rŽÅx¼°\x1CDnuD¯"
  b"_WHbç6D'¯.RßJ\x1Eж"
  b"Ï'¡UQèD\x06•Oíhl±‚z"
  b"ÆÞ‚ö_{FMŠ \x18Ä!\x1Ejô"
  b"\x01Œ\x00k¤Ër­¶\x13Lvu™é"
  b"\x01Œ\x00h\x10Bpe­\Î\x0Fò\x01\x14Ñ"
  b"z3}ëòŽF×®Ò™ø»Aÿ_"
  b"\x01’qY.\x07s¯¦\x1AÞ\x16º\x7FÒy"
  b"\x01’qYó…q\x1C’ÂOã&­Ös"
  b"\x01™\tkÍëq" \x19C!Ää¢\x1E"
  b"\x01”n¦ŠäpêŽàÒ…ô\x01àU"
  b"\x01™\x13ëÄlp¢ºÐùyÈg'D"
  b"\x01™\x14[ƒEs\r••H§Xi@÷"
  b"\x01™[ðÄ\x1Cq¿Ž•Ž]YŽR,"
  b"\x0Evi;tfH˜¿*ûëŒûJ\x13"
  b"†Vu>\x7F"E;›•¨i—™–"
  b"Îèª\x16žãHȶwéÖLåiQ"
  b"7cXÇ\x1CäDZ¤ys?UrºG"
  b"\x01Š±–U\x1CqˆuaÐjäì\t"
  b"úšÿ=•³C7¡£xh@peâ"
  b"Îw[E¡¶G¦¸3\x17Üa¸\x1EQ"
  b"ž‰~™îàG_²¢ÈÓüZPr"
  b"˜\x04\v\x12­÷@_¼à°ä7—sï"
  b"»c)Š\tKAy¦\x15¤±Nw!r"
  b"\x1Co(\x05!ýM!»¾\x10J‡gµ\x19"
  b"6À–E\x16èNA¤B®ïŽ'È~"
  b"e\x00¾+¦EN¼´f9ìÙu#k"
  b"±lqë~ÿMr¶I\x01\x16\x10,¢±"
  b"cÊ“\f\x1A_I牐Î\x12q\x03€"
  b"ª\x05iæa>B\x18¬ýf(y¥¶°"
  b"\x0FäÁŽ¶¨H•¹n‰ó\x11"}c"
  b"'Í`³³ÙJ\x1A÷¥õ£¡j"
  b"™kB(ä·F݁Yˆ¼ˆy×"
  b"^\x19æó„†EZ¬\x05ë‘\f&33"
  b"nÛÎîsU@?‡ºóÏ@Î{€"
  b"jó\x12\›kNÕ¿´µ?ëEëc"
  b"ßûÌÐCŒNžj;VßkÓF"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
2.28 ms
(0.51%) 		5 
SELECT `dreisc_seo_setting`.`id` as `dreisc_seo_setting.id`, `dreisc_seo_setting`.`key` as `dreisc_seo_setting.key`, `dreisc_seo_setting`.`value` as `dreisc_seo_setting.value`, `dreisc_seo_setting`.`sales_channel_id` as `dreisc_seo_setting.salesChannelId`, `dreisc_seo_setting`.`created_at` as `dreisc_seo_setting.createdAt`, `dreisc_seo_setting`.`updated_at` as `dreisc_seo_setting.updatedAt` FROM `dreisc_seo_setting` WHERE (`dreisc_seo_setting`.`sales_channel_id` <=> ?)
Parameters: 
[
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
1.84 ms
(0.42%) 		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.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"2•j=\x7Fà@4ž\x05‰F\x00Q»*"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.75 ms
(0.39%) 		2 
-- 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.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"»\x07"‘NÈGŸ±g3nruº^"
  b"2•j=\x7Fà@4ž\x05‰F\x00Q»*"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.59 ms
(0.36%) 		1 
-- product-listing-route::loading::search-ids
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?))) AND (`product`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY `product`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  10
  b"i„öTY#Hê­h€Ã_MPÂ"
  true
  b"\x01¹Årùq;¦Ùmœì\x03Ò\x1F"
  b"\x01‘¼°ûbq»bXš‚Xß."
  b"\x01º'•°p¼ˆàæ¢vg»]"
  b"\x01º„}|q5‚..‰ÛC\x0FR"
  b"\x01‹#0øNp¢‰ã÷8ÊY\x1ET"
  b"Ï'¡UQèD\x06•Oíhl±‚z"
  b"\x01‹„¡HŠs~’wIåÒ\x00›!"
  b"\x01Œ\x00k¤Ër­¶\x13Lvu™é"
  b"\x01Œ\x00h\x10Bpe­\Î\x0Fò\x01\x14Ñ"
  b"z3}ëòŽF×®Ò™ø»Aÿ_"
  b"\x01’q«¥­qD“ñ0\x1CÜÅ.ø"
  b"\x01’q]«år\x7F…p\x1E\e\x10S["
  b"\x01™\x10kZ²qý¸Ií¦H\x1F\x05†"
  b"\x01”n±`Qp6«sÜ‹è°"g"
  b"\x01™\x13ð,Ïr­šHBœ\x00q…ò"
  b"\x01™\x14[“ƒs¾ð\x1Cºü\x10¢k"
  b"\x01™[ðͲph§ü\x0FR8D\tÔ"
  b"\x0Evi;tfH˜¿*ûëŒûJ\x13"
  b"\x01ŠÐTì\x15pV»_Š¿îä\x13K"
  b"\x01ŠÐCÁ˜s¢³F—¬Pè¿$"
  b"\x01)úåóp\x1F½\x03ÿ¦äy\x02û"
  b"\x01Š±ŸÌs’"\eº§\x1A\x18°"
  b"\x01Š±Z™¬sN½¹s\x193œ®Z"
  b"\x01ŠÍîáup€!@›£ùѱ"
  b"\x01ŠÑ³—vqØ–IåOƒ÷8\x07"
  b"\x01ŠÍò¾ßqHº‹ÐLŽÔ\rÊ"
  b"\x01ŒsyK”p\x1F´`§aef9 "
  b"\x01Œ?\x1CkÀpó’Ü dT®‡‰"
  b"\x01Š„\x0E-Çr\x0F£½?röDõL"
  b"ÿgW}\x19VN‰¿’ªÐ\x18~š"
  b"fL¢à¢­GB¸) 2›¦\x01ò"
  b"\x01Š„÷\x16\x12q ¬ð™ÞÅEÕd"
  b"\x01Šì°å.rŠ…†¸-k/\x13K"
  b"\x01‘ÒÕ\x0E\ep¹¨ÒӐP·\t\x08"
  b"'Í`³³ÙJ\x1A÷¥õ£¡j"
  b"™kB(ä·F݁Yˆ¼ˆy×"
  b"^\x19æó„†EZ¬\x05ë‘\f&33"
  b"o<púR¾A6 ÄŒ†¢<Üò"
  b"\x01‘ê»éqy«Ò\rä%\x15«C"
  b"\x01ŠÎ\x00ÿ4sA½¬(\x01Ö?˜$"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.48 ms
(0.33%) 		3 
SELECT `dreisc_seo_setting`.`id` as `dreisc_seo_setting.id`, `dreisc_seo_setting`.`key` as `dreisc_seo_setting.key`, `dreisc_seo_setting`.`value` as `dreisc_seo_setting.value`, `dreisc_seo_setting`.`sales_channel_id` as `dreisc_seo_setting.salesChannelId`, `dreisc_seo_setting`.`created_at` as `dreisc_seo_setting.createdAt`, `dreisc_seo_setting`.`updated_at` as `dreisc_seo_setting.updatedAt` FROM `dreisc_seo_setting` WHERE (`dreisc_seo_setting`.`sales_channel_id` = ?)
Parameters: 
[
  b"i„öTY#Hê­h€Ã_MPÂ"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.47 ms
(0.33%) 		1 
SELECT LOWER(HEX(entries.id)) as id, IF(trans1.keyword IS NOT NULL, trans1.keyword, trans2.keyword) as keyword, IF(trans1.description IS NOT NULL, trans1.description, trans2.description) as description, seoUrls.seo_path_info as seoUrl FROM `cbax_lexicon_entry` entries LEFT JOIN `cbax_lexicon_entry_translation` trans1 ON trans1.cbax_lexicon_entry_id = entries.id AND trans1.language_id = ? LEFT JOIN `cbax_lexicon_entry_translation` trans2 ON trans2.cbax_lexicon_entry_id = entries.id AND trans2.language_id = ? INNER JOIN `cbax_lexicon_sales_channel` salesChannels ON entries.id = salesChannels.cbax_lexicon_entry_id AND salesChannels.sales_channel_id = ? LEFT JOIN `seo_url` seoUrls ON entries.id = seoUrls.foreign_key AND
                seoUrls.route_name = "frontend.cbax.lexicon.detail" AND
                seoUrls.language_id = ? AND
                seoUrls.sales_channel_id = ? AND
                seoUrls.is_canonical = 1 AND
                seoUrls.is_deleted = 0 WHERE entries.date <= ?
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"i„öTY#Hê­h€Ã_MPÂ"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"i„öTY#Hê­h€Ã_MPÂ"
  "2026-04-03 05:09:06"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.40 ms
(0.32%) 		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.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"2•j=\x7Fà@4ž\x05‰F\x00Q»*"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.23 ms
(0.28%) 		1 
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?))) AND (`product`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY `product`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"i„öTY#Hê­h€Ã_MPÂ"
  true
  b"\x01Š„\x0E-Çr\x0F£½?röDõL"
  b"\x01Š„÷\x16\x12q ¬ð™ÞÅEÕd"
  b"\x01Š±Z™¬sN½¹s\x193œ®Z"
  b"\x01Š±ŸÌs’"\eº§\x1A\x18°"
  b"\x01ŠÍîáup€!@›£ùѱ"
  b"\x01ŠÎ\x00ÿ4sA½¬(\x01Ö?˜$"
  b"\x01‘ê»éqy«Ò\rä%\x15«C"
  b"\x01ŠÐCÁ˜s¢³F—¬Pè¿$"
  b"\x01ŠÐTì\x15pV»_Š¿îä\x13K"
  b"\x01ŠÑ³—vqØ–IåOƒ÷8\x07"
  b"\x01Šì°å.rŠ…†¸-k/\x13K"
  b"\x01‘ÒÕ\x0E\ep¹¨ÒӐP·\t\x08"
  b"\x01‹#0øNp¢‰ã÷8ÊY\x1ET"
  b"\x01‹„¡HŠs~’wIåÒ\x00›!"
  b"\x01Œ?\x1CkÀpó’Ü dT®‡‰"
  b"\x01ŒsyK”p\x1F´`§aef9 "
  b"\x01¹Årùq;¦Ùmœì\x03Ò\x1F"
  b"\x01º'•°p¼ˆàæ¢vg»]"
  b"\x01º„}|q5‚..‰ÛC\x0FR"
  b"\x01)úåóp\x1F½\x03ÿ¦äy\x02û"
  b"\x01‘¼°ûbq»bXš‚Xß."
  b"\x01’q]«år\x7F…p\x1E\e\x10S["
  b"\x01’q«¥­qD“ñ0\x1CÜÅ.ø"
  b"\x01”n±`Qp6«sÜ‹è°"g"
  b"o<púR¾A6 ÄŒ†¢<Üò"
  b"\x01™\x10kZ²qý¸Ií¦H\x1F\x05†"
  b"\x01™\x13ð,Ïr­šHBœ\x00q…ò"
  b"\x01™\x14[“ƒs¾ð\x1Cºü\x10¢k"
  b"\x01™[ðͲph§ü\x0FR8D\tÔ"
  b"fL¢à¢­GB¸) 2›¦\x01ò"
  b"ÿgW}\x19VN‰¿’ªÐ\x18~š"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.06 ms
(0.24%) 		1 
-- product-listing-route::loading::association::options::read
SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group`.`icon_media_id` as `property_group_option.group.iconMediaId`, `property_group_option.group.translation.name`, `property_group_option.group.translation.name` as `property_group_option.group.name`, `property_group_option.group.translation.description`, `property_group_option.group.translation.description` as `property_group_option.group.description`, `property_group_option.group.translation.position`, `property_group_option.group.translation.position` as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, `property_group_option.group.translation.customFields` as `property_group_option.group.customFields`, `property_group_option.translation.name`, `property_group_option.translation.name` as `property_group_option.name`, `property_group_option.translation.position`, `property_group_option.translation.position` as `property_group_option.position`, `property_group_option.translation.customFields`, `property_group_option.translation.customFields` as `property_group_option.customFields` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.translation`.`property_group_option_id`, `property_group_option.translation`.`name` as `property_group_option.translation.name`, `property_group_option.translation`.`position` as `property_group_option.translation.position`, `property_group_option.translation`.`custom_fields` as `property_group_option.translation.customFields` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.`language_id` = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN (SELECT `property_group_option.group.translation`.`property_group_id`, `property_group_option.group.translation`.`name` as `property_group_option.group.translation.name`, `property_group_option.group.translation`.`description` as `property_group_option.group.translation.description`, `property_group_option.group.translation`.`position` as `property_group_option.group.translation.position`, `property_group_option.group.translation`.`custom_fields` as `property_group_option.group.translation.customFields` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.`language_id` = ?) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` WHERE `property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x1AÉk…uÊO¯´OçA$\x14óé"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"""
    \x01\x0EÝ?Øn@^³\n
    ìT¬& 
    """
  b"8Çt\x150ÜG]…F`„\x111\x1Fk"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"\x1AÉk…uÊO¯´OçA$\x14óé"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"Õ3#Mñ}Iܶ×9qbóŸ\n"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"iÕ¹r\x1DÉMRŽcˆÆ‹#-\x01"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"Õ3#Mñ}Iܶ×9qbóŸ\n"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"žUðh\x01ÏI扄8d:´\x04b"
  b"KaÆYásI!ˆ:⟣jý¡"
  b"KaÆYásI!ˆ:⟣jý¡"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"9+ý”ä-N6†êc@½àÄõ"
  b"iÕ¹r\x1DÉMRŽcˆÆ‹#-\x01"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b"ú!ehŒ)I·Ÿ‰nÕ\x08{ï"
  b"\x1AÉk…uÊO¯´OçA$\x14óé"
  b"¯WS3OŒE§“øuÈá)ŠX"
  b";iY‡m\x1AFϝSgf~z K"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.04 ms
(0.23%) 		3 
SELECT LOWER(HEX(parent_id)) FROM language WHERE id = ?
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.03 ms
(0.23%) 		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.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 `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`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"4ò4\;6A˜¡\x0E˜4Ìñ\x06”"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.84 ms
(0.19%) 		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.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 (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` WHERE (`cms_page`.`version_id` = ?) AND (`cms_page`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x150¡ÌX‘N†£à\x1E/\x16‡£?"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.80 ms
(0.18%) 		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`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  false
  true
  "product_download"
  false
  true
  "product_download"
  b"R\x11È"J`A·¡BöáwhK{"
  b"\x7FLÕc:\x04JW¯¸|fŠÅo©"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.78 ms
(0.18%) 		1 
-- product-listing::property-group-filter::read
SELECT `property_group`.`id` as `property_group.id`, `property_group`.`display_type` as `property_group.displayType`, `property_group`.`sorting_type` as `property_group.sortingType`, `property_group`.`filterable` as `property_group.filterable`, `property_group`.`visible_on_product_detail_page` as `property_group.visibleOnProductDetailPage`, `property_group`.`created_at` as `property_group.createdAt`, `property_group`.`updated_at` as `property_group.updatedAt`, `property_group`.`icon_media_id` as `property_group.iconMediaId`, `property_group.translation.name`, `property_group.translation.name` as `property_group.name`, `property_group.translation.description`, `property_group.translation.description` as `property_group.description`, `property_group.translation.position`, `property_group.translation.position` as `property_group.position`, `property_group.translation.customFields`, `property_group.translation.customFields` as `property_group.customFields` FROM `property_group` LEFT JOIN (SELECT `property_group.translation`.`property_group_id`, `property_group.translation`.`name` as `property_group.translation.name`, `property_group.translation`.`description` as `property_group.translation.description`, `property_group.translation`.`position` as `property_group.translation.position`, `property_group.translation`.`custom_fields` as `property_group.translation.customFields` FROM `property_group_translation` `property_group.translation` WHERE `property_group.translation`.`language_id` = ?) `property_group.property_group_translation` ON `property_group.property_group_translation`.`property_group_id` = `property_group`.`id` WHERE ((`property_group`.`filterable` = ?)) AND (`property_group`.`id` IN (?, ?, ?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  b"»ÈëjõtL°¤êÐÓÄ)}–"
  b"’'CÙX|Iõ•DºŽ\x05èàÈ"
  b"–ŒèŒ\x0FrC–¹ÂCÛx¶¯"
  b"Õœ\vÏ\x06àMn‹)â&ç\x19€¼"
  b"ÃÆÛ©[oD6ŠO$eÕ¥Ö¤"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.77 ms
(0.17%) 		1 
# product-listing-loader::resolve-previews
            SELECT
                parent.variant_listing_config as variantListingConfig,
                LOWER(HEX(child.id)) as id,
                LOWER(HEX(parent.id)) as parentId
             FROM product as child
                INNER JOIN product as parent
                    ON parent.id = child.parent_id
                    AND parent.version_id = child.version_id
             WHERE child.version_id = ?
             AND child.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01¹Årùq;¦Ùmœì\x03Ò\x1F"
  b"\x01‘¼°ûbq»bXš‚Xß."
  b"\x01º'•°p¼ˆàæ¢vg»]"
  b"\x01º„}|q5‚..‰ÛC\x0FR"
  b"\x01‹#0øMrS‹»Ç_x\x13?“"
  b"Ï'¡UQèD\x06•Oíhl±‚z"
  b"\x01‹„¡H‰s˜¢ÂÛ"v~_¡"
  b"\x01Œ\x00k¤Ër­¶\x13Lvu™é"
  b"\x01Œ\x00h\x10Bpe­\Î\x0Fò\x01\x14Ñ"
  b"z3}ëòŽF×®Ò™ø»Aÿ_"
  b"\x01’q«¥­qD“ñ0\x1CÜÅ.ø"
  b"\x01’q]«år\x7F…p\x1E\e\x10S["
  b"\x01™\x10kZ²qý¸Ií¦G#Û˜"
  b"\x01”n±`Qp6«sÜ‹è°"g"
  b"\x01™\x13ð,Ïr­šHBœ\x00\x1D;q"
  b"\x01™\x14[“ƒs¾ð\x1Cºü\x10¢k"
  b"\x01™[ðͲph§ü\x0FR8D\tÔ"
  b"\x0Evi;tfH˜¿*ûëŒûJ\x13"
  b"\x01ŠÐTì\x13p\x15Š½Ö}n¶é3"
  b"\x01ŠÐCÁ˜s¢³F—¬OÞ@Î"
  b"\x01)úåóp\x1F½\x03ÿ¦äy\x02û"
  b"\x01Š±ŸÌs’"\eº§\x1A\x18°"
  b"\x01Š±Z™¬sN½¹s\x192\x04šI"
  b"\x01ŠÍîáup€!@›£ùѱ"
  b"\x01ŠÑ³—vqØ–IåOƒ÷8\x07"
  b"\x01ŠÍò¾ßqHº‹ÐLŽÔ\rÊ"
  b"\x01ŒsyK“r\x00¬#@Ì\vÀëâ"
  b"\x01Œ?\x1CkÀpó’Ü dS»_Ž"
  b"\x01Š„\x0E-Æpú¸OýE&úòÝ"
  b"""
    lÖË\x11èRH€¤aͶD\n
    Ùh
    """
  b"F\x10•Í³cO-†\f†&ÆŸP\x1F"
  b"\x01Š„÷\x16\x12q ¬ð™ÞÅEÕd"
  b"\x01Šì°å.rŠ…†¸-k/\x13K"
  b"\x01Šú;wòq|¯y1ŸèF3\n"
  b"'Í`³³ÙJ\x1A÷¥õ£¡j"
  b"™kB(ä·F݁Yˆ¼ˆy×"
  b"^\x19æó„†EZ¬\x05ë‘\f&33"
  b"\x01•®\x1EVÒs šêé¹çUà"
  b"\x01ŠÎ\x11bÊq†‰x,ŠwÎð3"
  b"\x01ŠÎ\x00ÿ4sA½¬(\x01Ö?˜$"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.74 ms
(0.17%) 		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.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 `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`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"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x150¡ÌX‘N†£à\x1E/\x16‡£?"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.71 ms
(0.16%) 		1 
-- 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"i„öTY#Hê­h€Ã_MPÂ"
  "t/home-office"
  "t/home-office/"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.67 ms
(0.15%) 		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.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 (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` WHERE (`cms_slot`.`version_id` = ?) AND (((`cms_slot`.`cms_block_id` IN (?, ?, ?, ?))))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01š\x00˜³´r$¶o/ƒL$BÈ"
  b"3\x11ÎbS\x1CL“Ž[l‹'.\x12¹"
  b"HAT¤\x0FgK±Œ$iÁp\x10jû"
  b"e\x18Nb,\x0FLq‚‰?Üòà%é"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.66 ms
(0.15%) 		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"i„öTY#Hê­h€Ã_MPÂ"
  b"æwŒ™’SLŸ˜K£«%¿æ7"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.63 ms
(0.14%) 		1 
-- manufacturer-aggregation::read
SELECT `product_manufacturer`.`id` as `product_manufacturer.id`, `product_manufacturer`.`version_id` as `product_manufacturer.versionId`, `product_manufacturer`.`media_id` as `product_manufacturer.mediaId`, `product_manufacturer`.`created_at` as `product_manufacturer.createdAt`, `product_manufacturer`.`updated_at` as `product_manufacturer.updatedAt`, `product_manufacturer.translation.name`, `product_manufacturer.translation.name` as `product_manufacturer.name`, `product_manufacturer.translation.link`, `product_manufacturer.translation.link` as `product_manufacturer.link`, `product_manufacturer.translation.description`, `product_manufacturer.translation.description` as `product_manufacturer.description`, `product_manufacturer.translation.customFields`, `product_manufacturer.translation.customFields` as `product_manufacturer.customFields` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.`product_manufacturer_id`, `product_manufacturer.translation`.`product_manufacturer_version_id`, `product_manufacturer.translation`.`link` as `product_manufacturer.translation.link`, `product_manufacturer.translation`.`name` as `product_manufacturer.translation.name`, `product_manufacturer.translation`.`description` as `product_manufacturer.translation.description`, `product_manufacturer.translation`.`custom_fields` as `product_manufacturer.translation.customFields` FROM `product_manufacturer_translation` `product_manufacturer.translation` WHERE `product_manufacturer.translation`.`language_id` = ?) `product_manufacturer.product_manufacturer_translation` ON `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product_manufacturer`.`id` AND `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_version_id` = `product_manufacturer`.`version_id` WHERE (`product_manufacturer`.`version_id` = ?) AND (`product_manufacturer`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"""
    sú\n
    ",íFž¯ÔþDšÔÁG
    """
  b"³¹\e“–V@Ø’ï¯3Án‹z"
  b"Z’f›Ÿ¦N\v¸V·ÐÊ\x03(¢"
  b"_z\x01›{KÓ±"}O2Ag\r"
  b"–½Zæ2¯IñƒÒ\x10,Aí¿º"
  b"r\x0FnÚÙpOƝŒ¹½{øð~"
  b"\x01”ÅÛNjr\x1E“EêÀË1’…"
  b">B>\x1FòÇFNšMåDföó)"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.60 ms
(0.14%) 		1 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.60 ms
(0.13%) 		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"\x01š\x01xþÙsُÙçÔÎgo^"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(0.13%) 		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þˆo¨r°°7\x03f6NîR"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.56 ms
(0.13%) 		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"2•j=\x7Fà@4ž\x05‰F\x00Q»*"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.55 ms
(0.12%) 		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.51 ms
(0.12%) 		1 
-- sales-channel::load-analytics::read
SELECT `sales_channel_analytics`.`id` as `sales_channel_analytics.id`, `sales_channel_analytics`.`tracking_id` as `sales_channel_analytics.trackingId`, `sales_channel_analytics`.`active` as `sales_channel_analytics.active`, `sales_channel_analytics`.`track_orders` as `sales_channel_analytics.trackOrders`, `sales_channel_analytics`.`anonymize_ip` as `sales_channel_analytics.anonymizeIp`, `sales_channel_analytics`.`track_offcanvas_cart` as `sales_channel_analytics.trackOffcanvasCart`, `sales_channel_analytics`.`created_at` as `sales_channel_analytics.createdAt`, `sales_channel_analytics`.`updated_at` as `sales_channel_analytics.updatedAt` FROM `sales_channel_analytics` WHERE `sales_channel_analytics`.`id` IN (?)
Parameters: 
[
  b"\x01Á:Wc|¸—º\x02\x19ª<Oé"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.50 ms
(0.11%) 		1 
SELECT HEX(id) as id, name FROM language
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.49 ms
(0.11%) 		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.48 ms
(0.11%) 		1 
SELECT `seo_url`.`id` as `seo_url.id`, `seo_url`.`sales_channel_id` as `seo_url.salesChannelId`, `seo_url`.`language_id` as `seo_url.languageId`, `seo_url`.`foreign_key` as `seo_url.foreignKey`, `seo_url`.`route_name` as `seo_url.routeName`, `seo_url`.`path_info` as `seo_url.pathInfo`, `seo_url`.`seo_path_info` as `seo_url.seoPathInfo`, `seo_url`.`is_canonical` as `seo_url.isCanonical`, `seo_url`.`is_modified` as `seo_url.isModified`, `seo_url`.`is_deleted` as `seo_url.isDeleted`, `seo_url`.`custom_fields` as `seo_url.customFields`, `seo_url`.`created_at` as `seo_url.createdAt`, `seo_url`.`updated_at` as `seo_url.updatedAt` FROM `seo_url` WHERE (`seo_url`.`language_id` = ? AND `seo_url`.`sales_channel_id` = ? AND `seo_url`.`route_name` = ? AND `seo_url`.`foreign_key` = ? AND `seo_url`.`is_canonical` = ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"i„öTY#Hê­h€Ã_MPÂ"
  "frontend.navigation.page"
  b"2•j=\x7Fà@4ž\x05‰F\x00Q»*"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.48 ms
(0.11%) 		1 
SELECT `dreisc_seo_redirect`.`id` as `dreisc_seo_redirect.id`, `dreisc_seo_redirect`.`active` as `dreisc_seo_redirect.active`, `dreisc_seo_redirect`.`redirect_http_status_code` as `dreisc_seo_redirect.redirectHttpStatusCode`, `dreisc_seo_redirect`.`source_type` as `dreisc_seo_redirect.sourceType`, `dreisc_seo_redirect`.`has_source_sales_channel_domain_restriction` as `dreisc_seo_redirect.hasSourceSalesChannelDomainRestriction`, `dreisc_seo_redirect`.`source_sales_channel_domain_restriction_ids` as `dreisc_seo_redirect.sourceSalesChannelDomainRestrictionIds`, `dreisc_seo_redirect`.`source_sales_channel_domain_id` as `dreisc_seo_redirect.sourceSalesChannelDomainId`, `dreisc_seo_redirect`.`source_path` as `dreisc_seo_redirect.sourcePath`, `dreisc_seo_redirect`.`source_product_id` as `dreisc_seo_redirect.sourceProductId`, `dreisc_seo_redirect`.`source_product_version_id` as `dreisc_seo_redirect.sourceProductVersionId`, `dreisc_seo_redirect`.`source_category_id` as `dreisc_seo_redirect.sourceCategoryId`, `dreisc_seo_redirect`.`source_category_version_id` as `dreisc_seo_redirect.sourceCategoryVersionId`, `dreisc_seo_redirect`.`redirect_type` as `dreisc_seo_redirect.redirectType`, `dreisc_seo_redirect`.`redirect_url` as `dreisc_seo_redirect.redirectUrl`, `dreisc_seo_redirect`.`redirect_sales_channel_domain_id` as `dreisc_seo_redirect.redirectSalesChannelDomainId`, `dreisc_seo_redirect`.`redirect_path` as `dreisc_seo_redirect.redirectPath`, `dreisc_seo_redirect`.`redirect_product_id` as `dreisc_seo_redirect.redirectProductId`, `dreisc_seo_redirect`.`redirect_product_version_id` as `dreisc_seo_redirect.redirectProductVersionId`, `dreisc_seo_redirect`.`redirect_category_id` as `dreisc_seo_redirect.redirectCategoryId`, `dreisc_seo_redirect`.`redirect_category_version_id` as `dreisc_seo_redirect.redirectCategoryVersionId`, `dreisc_seo_redirect`.`has_deviating_redirect_sales_channel_domain` as `dreisc_seo_redirect.hasDeviatingRedirectSalesChannelDomain`, `dreisc_seo_redirect`.`deviating_redirect_sales_channel_domain_id` as `dreisc_seo_redirect.deviatingRedirectSalesChannelDomainId`, `dreisc_seo_redirect`.`parameter_forwarding` as `dreisc_seo_redirect.parameterForwarding`, `dreisc_seo_redirect`.`created_at` as `dreisc_seo_redirect.createdAt`, `dreisc_seo_redirect`.`updated_at` as `dreisc_seo_redirect.updatedAt` FROM `dreisc_seo_redirect` WHERE ((`dreisc_seo_redirect`.`active` = ? AND `dreisc_seo_redirect`.`source_type` = ? AND `dreisc_seo_redirect`.`source_category_id` = ?))
Parameters: 
[
  true
  "category"
  b"2•j=\x7Fà@4ž\x05‰F\x00Q»*"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.48 ms
(0.11%) 		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"2•j=\x7Fà@4ž\x05‰F\x00Q»*"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.47 ms
(0.11%) 		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.45 ms
(0.10%) 		1 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.43 ms
(0.10%) 		1 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  b"i„öTY#Hê­h€Ã_MPÂ"
  "Sendinblue.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(0.07%) 		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"\x01š\x01xþÙsُÙçÔÎgo^"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(0.07%) 		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.28 ms
(0.06%) 		1 
SELECT
    `theme_id`,
    `technical_name`,
    `resolved_config`,
    `view_inheritance`,
    `script_files`,
    `icon_sets`,
    `updated_at`
    FROM `theme_runtime_config`
    WHERE `technical_name` = ?
Parameters: 
[
  "NetzhautMPlusM"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(0.06%) 		1 
-- product-listing::load-sortings::search-ids
SELECT `product_sorting`.`id` FROM `product_sorting` WHERE ((`product_sorting`.`id` IN (?)) AND `product_sorting`.`active` = ?) ORDER BY `product_sorting`.`priority` DESC
Parameters: 
[
  b"\x01š\x01xþÙsُÙçÔÎgo^"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.25 ms
(0.06%) 		1 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"i„öTY#Hê­h€Ã_MPÂ"
  "GSfxcjcxSCm2Hymhk39La9aLCRiQKl5t"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.25 ms
(0.06%) 		1 
# navigation-route::meta-information
            SELECT LOWER(HEX(`id`)), `path`, `level`
            FROM `category`
            WHERE `id` = ? OR `id` = ?
Parameters: 
[
  b"\x0FŘD¦{BɼfËo\v;N‡"
  b"\x0FŘD¦{BɼfËo\v;N‡"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(0.05%) 		2 
SELECT url FROM sales_channel_domain
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(0.05%) 		1 
SELECT path FROM category WHERE id = ?
Parameters: 
[
  b"2•j=\x7Fà@4ž\x05‰F\x00Q»*"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(0.04%) 		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"2•j=\x7Fà@4ž\x05‰F\x00Q»*"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.19 ms
(0.04%) 		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.19 ms
(0.04%) 		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.14 ms
(0.03%) 		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.