GET https://tinbe.generationshop.dev/widgets/cms/navigation/d416353931ff4c7c92ae748318d19bc7/filter?only-aggregations=1&reduce-aggregations=1&slots=4a5d399cb7814d6a…

Response
200 OK
Browse referrer URL
IP
18.189.170.45
Profiled on
Token
7b69a7

Query Metrics

60 Database Queries
33 Different statements
211.34 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
62.71 ms
(29.67%) 		1 
# product-listing-route::loading::aggregation::properties
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 NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product.properties`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  true
  b"Ô\x16591ÿL|’®tƒ\x18Ñ›Ç"
  null
  true
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
46.50 ms
(22.00%) 		1 
# product-listing-route::loading::aggregation::price
SELECT MIN(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule526d6930b1dd49d5ba77f629a6a477f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleadc7f28258b64f9aa877d237b34088ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulec54c7c670e27454cb613c9d6d1e9e78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule6c9bee2e47084fe09edf500180c8e9ba.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule7e2febe0d564402da0eb0a0f425dfcb8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulea5b6366f102b41f7924cdaaf2b8bbf2e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleaec7d06af7734675a1ae0dd498a34e3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleca8324c3095543f6a69f923050786657.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulede2455bf8ca24b9a847c9e397e407269.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulef0c63ac906df419090fc07780145dd6b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018f51dc2dd875768a2eec716b420000.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018f51e2f49d7319b04105d4f9cdff56.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruled40cf9900bd049508b93b3e9c880f8f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule526d6930b1dd49d5ba77f629a6a477f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleadc7f28258b64f9aa877d237b34088ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulec54c7c670e27454cb613c9d6d1e9e78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule6c9bee2e47084fe09edf500180c8e9ba.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule7e2febe0d564402da0eb0a0f425dfcb8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulea5b6366f102b41f7924cdaaf2b8bbf2e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleaec7d06af7734675a1ae0dd498a34e3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleca8324c3095543f6a69f923050786657.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulede2455bf8ca24b9a847c9e397e407269.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulef0c63ac906df419090fc07780145dd6b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018f51dc2dd875768a2eec716b420000.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018f51e2f49d7319b04105d4f9cdff56.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruled40cf9900bd049508b93b3e9c880f8f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 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`, "$.rule526d6930b1dd49d5ba77f629a6a477f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleadc7f28258b64f9aa877d237b34088ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulec54c7c670e27454cb613c9d6d1e9e78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule6c9bee2e47084fe09edf500180c8e9ba.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule7e2febe0d564402da0eb0a0f425dfcb8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulea5b6366f102b41f7924cdaaf2b8bbf2e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleaec7d06af7734675a1ae0dd498a34e3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleca8324c3095543f6a69f923050786657.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulede2455bf8ca24b9a847c9e397e407269.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulef0c63ac906df419090fc07780145dd6b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018f51dc2dd875768a2eec716b420000.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018f51e2f49d7319b04105d4f9cdff56.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruled40cf9900bd049508b93b3e9c880f8f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule526d6930b1dd49d5ba77f629a6a477f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleadc7f28258b64f9aa877d237b34088ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulec54c7c670e27454cb613c9d6d1e9e78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule6c9bee2e47084fe09edf500180c8e9ba.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule7e2febe0d564402da0eb0a0f425dfcb8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulea5b6366f102b41f7924cdaaf2b8bbf2e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleaec7d06af7734675a1ae0dd498a34e3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleca8324c3095543f6a69f923050786657.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulede2455bf8ca24b9a847c9e397e407269.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulef0c63ac906df419090fc07780145dd6b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018f51dc2dd875768a2eec716b420000.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018f51e2f49d7319b04105d4f9cdff56.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruled40cf9900bd049508b93b3e9c880f8f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 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` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?)))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  true
  b"Ô\x16591ÿL|’®tƒ\x18Ñ›Ç"
  null
  true
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
18.65 ms
(8.83%) 		1 
# product-listing-route::loading::aggregation::shipping-free-filter
SELECT MAX(IFNULL(`product`.`shipping_free`, `product.parent`.`shipping_free`)) as `shipping-free` 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` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) AND ((IFNULL(`product`.`shipping_free`, `product.parent`.`shipping_free`) = ?))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  true
  b"Ô\x16591ÿL|’®tƒ\x18Ñ›Ç"
  null
  true
  false
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
16.64 ms
(7.87%) 		1 
# product-listing-route::loading::aggregation::options
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 NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product.options`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  true
  b"Ô\x16591ÿL|’®tƒ\x18Ñ›Ç"
  null
  true
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
14.11 ms
(6.68%) 		1 
# product-listing-route::loading::aggregation::rating-exists
SELECT MAX(IFNULL(`product`.`rating_average`, `product.parent`.`rating_average`)) as `rating` 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` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) AND (((IFNULL(`product`.`rating_average`, `product.parent`.`rating_average`) >= ?)))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  true
  b"Ô\x16591ÿL|’®tƒ\x18Ñ›Ç"
  null
  true
  false
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
6.30 ms
(2.98%) 		10 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  null
  "MolliePayments.config.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
6.12 ms
(2.89%) 		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` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`)
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  true
  b"Ô\x16591ÿL|’®tƒ\x18Ñ›Ç"
  null
  true
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
5.37 ms
(2.54%) 		1 
# product-listing::property-filter::search-ids
SELECT `property_group_option`.`id` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` WHERE ((`property_group_option.group`.`filterable` = ?)) AND (`property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY `property_group_option`.`id` ASC LIMIT 500 OFFSET 500
Parameters: 
[
  true
  b"b\x1DB{ž~O„†<.ºªÛ\x13N"
  b"žÉƒRUÑC$¿»a\x7F\v»î«"
  b"F'vûZÏ@s‹léqgÁl\x06"
  b"r>\x0EQ\x07\x08FŽ°\iã¼–R0"
  b"ž©’d 4GV®~ÈÔ\x1E\x14PG"
  b"Ø'³9┴@┌Ü@ÖÏ-¨Á\x0F"
  b"ÁcïGzãN[œÚn±÷lØÊ"
  b"""
    \x7Flƒ%æÛJ2«\\n
    ÊIßE\x13
    """
  b"\x0F•é{\x1D<G6·Rš)€Ü"S"
  b"╔$\x00\x04ØTFë┤gçe\x17 Øy"
  b"èþVd|’CY«è^±ûø´a"
  b"úV}7ðæL¦—†Å)¯7éb"
  b"│╔ù ─]J#ìIRh\x18Æ\x13u"
  b"`êJî:ÍK‚Œòˆ²œ_mi"
  b"›Ð\e\x07„FI%³.X÷Gf\f¯"
  b"2÷åé\x1F6HWˆ"\x08³\x0F»¾\"
  b")»W\x14¾¥@¹¬{Ðwâ±Ùo"
  b"5)ƒ\x06\x1F=ON”—(¦_ï›ø"
  b"WvÜx¿cAZ´\x1E“\x11ûŠ‹Œ"
  b"«ÔáìÉü@y’ˆ)\x06jÏN8"
  b"ÞG\x16¤‰0F3¤÷œÉ£%<ì"
  b"{P àÿrB÷¦)]µu/û€"
  b"’Ñrò\x16~H½ ©2Ó\x1CE{\x1A"
  b"…ù#O]×L3œrþX*Õ’Á"
  b"¹„)‘êCBì©©QNb–€N"
  b"#°o($ÄGĪºi`t¯&ñ"
  b"\x0Fájò¾®BìªIQ6\x1DÏ\x12Ú"
  b"\x1C¯ÅW|àM³‰Ræ2méVA"
  b"^ƒùÂÈ«MV»ÐôÏ´ñG/"
  b"5\x1C¡g\x0FTJ©üòÅ\x13ÔlÆö"
  b"žð“jM\x1CJ@½ÕQ°q{IL"
  b"\f³¥œá*@VªSzÍö’‘5"
  b"žm\x05P2¡M‰’˜G®õ`ûÞ"
  b"Ðñ*ð2£C═üB)U<\x006U"
  b"Ê\x13Ñ└\x14hC┼ÅkÄä<7¶F"
  b"?Ä+€øëN„¡Bï\x14•B¿°"
  b"\x12»<\x1D‹‚E\e¯d<_ï/•R"
  b"á wÕY¬Ig­Ò\x07Õ²CÞ–"
  b"qÉ_Gì╝CÞóÐ!ZC┴ûP"
  b"«á*CìºM\x06çs´├Íؾ\x1E"
  b"µÌ!dñFAT¼k\x16ÚútÔp"
  b"ë\x0F\x1A†²‚H~µù¥Å×}î'"
  b"Å\x1EíŸz\x1AEµ’„KŠò²¦È"
  b"RK(Ù²¾Mf³Ëz'JÊÆÿ"
  b"á\tNö¹\x02JUž?¡®g\x1C÷È"
  b"\x19²æ|;¤BÛ¾\x1Aâ\x02ß™…¥"
  b"\x11e\x14ëì\x1CKîç¤Å┴À\x15\x08§"
  b"å\x05rò\x17âDÛÁ\x04$.¼v9Å"
  b"Ò3”ƒÛ}F\x14”®Â·V–\x1Fz"
  b"_v3┼9╚A#åØ6÷±cÙy"
  b"[|…ý±³O&¬\x11œ¦\x006ëÝ"
  b"ÐÀšMÏKNĈj,±€ÒtÏ"
  b"╗ ùk\x16¬EBƒ#x+'ÅgY"
  b"G\x10átî$J!‡´kD\vÔ×\x00"
  b"†\x06©\v¥;Nø³jHõú"
  b"nœYô¼¥@~´‘–w»õ\x12ì"
  b"-9¬\n}ÑF´€ß\x00\v/¦Y˜"
  b"œ±õ·Âz@n¥®…m#â8k"
  b"•Jý\x043öJ\x05¾\x08ƨM@\x06Ä"
  b"\├«l‗ K┌│ù70Ø\t\x19Î"
  b")&¨K®{GU ÛqjoÅš¨"
  b"âFóø@aMn¿¾ÊaVú¾,"
  b"ìÚÄ\rÚ¸OCîÀß╦Þ³óf"
  b"ÍØ\x00é\x12ÅG\x1C«\x04Íl¸>­y"
  b".[·loÛH`‹/fm\x041´¼"
  b"¼g\x18ÿ\f\vFȲ.0y×ͱz"
  b"U¸¶ºâ\x7FE\x7F²¡YÔa˜Ž\x0F"
  b"3¿È\x02oüKÏ :x¸p"\x01 "
  b"}ÊØ”ðPK\x06¼\x1F\x03{uj\x1Dó"
  b"•µ*дyCñ¿©u?wGÌ\x08"
  b"˜\x1E_rÀœNñµðå#W8~W"
  b"È£åŽÍJF¼¡Ã\x7FæSe\x14"
  b"ú¼í7a\fHPÉSæÞ\x18\x13bû"
  b"É┬\v\x04\x1DýC±ïáıÐl©\v┤"
  b"KKlı¿3Gq×?wìK┬ݸ"
  b"ãy\x06$pêOÅùî\x1D┼Xºû|"
  b"àä\x0EçÎUA9¨µfÍ­Ž÷¬"
  b"¢‘3f·hGj£%‰®Qs¥Æ"
  b"cÆ0ñ?Ë@´„…ºIŸAõï"
  b"""
    þµ\n
    hõÈMv–¿©~8n…W
    """
  b"ì*vùÉ\x08@\x16‡\x0Ecä\x13\x15Ƶ"
  b"ïÞá·P\x1AH\x07ž.S[ØX)\x1E"
  b"ix\x7F¨ìÓBÂ░L:"¯v■º"
  b"bx£øïãMÂ¿àŽ§2²\x06i"
  b"\táÅH\x10èJ-ůe;┘p±\x13"
  b"Ñ3\x14^.-Mx“5É£Ò’\x07Ç"
  b"Sñf]a®CìÖÊ¿:to­¦"
  b"iPû▄\x04"JJú£µÃÅPñI"
  b"\x14Þ.ËÙøLKª\x06ï\rÁ¤=Þ"
  b"\x19”\x13”HEJH‹ùG¥Øï=Í"
  b"!\x02<\x11\x11áAò¢3™5?3“Š"
  b"+ø{ü]>Géñ¾£-á©k:"
  b",·ªkÿ\rNæª\x1FGœ_Ò×s"
  b"7cÇÔögBîØ═\SHf┤\x07"
  b"T¸¦ùq§Cθ\x1Fœ `ønµ"
  b"ZÜÞjÎ&J+œìf–›ÅõÁ"
  b"[œwÖ¢ïCg¹mEÏþ»c\"
  b"jsó•“<A\x04¥æ+3\fSÀ$"
  b"k©–IMºC\x04¢ìŠ\x10\x12ôã½"
  b"o}\VM”I_€îÇ®óéáP"
  b"x\f\x14(<ûMá–`þ×L‰¶\x0F"
  b"}f¨LT×D¸†×cR\x11É°\e"
  b"èü\tÄã\eAÕ¿\x001C║ß┤Z"
  b"“6¤o"ðIx„SâÝñéœè"
  b"░'\x1E.é\x1EL÷ì‗\v«ûa¸\x0F"
  b"""
    Á´oºÔŒFiŽ:X\v\n
    ×Ûì
    """
  b"Åå©o\r'G·ˆfž¥õ\v^j"
  b"Í▄Ë·§\x1D@RɬÂ┘É1¯\x18"
  b"à.;I¤ùK§ \x13ˆ…n ˜\x14"
  b"òp\x1E¯ «D\x00ˆJƒ\x039±X`"
  b"ü[[àä¿M‘–J—ÍÝäØ"
  b"\x00‘«„hTD†œêêó/;\x07ü"
  b"\x05ÌNTœåJ¯ž¸„¬\x15לÒ"
  b"P™‹Ù2\tJtµÖ\x13@6%\x0F¿"
  b"V…û½\x04ÄG%”¹Ì@\x07}MC"
  b"""
    W╝┐ËÌ`CѼóØ#\x02\n
    sn
    """
  b"\¥P\x13ÎÜK¾ž¬\x00jŽ¢~¢"
  b"j¢ãê¯oG*°„97ÍôË "
  b"vW9œ8ØC\x0F®ã«\x12¯~6k"
  b"“\x08êõ÷\rIÓ»%h<G\rH‡"
  b"ÃÞ\x04ÃÍùAÀ¦¶\x0EÁš´\x06`"
  b"ÿ·Ré\x04ŽDµ†½¾°Wó• "
  b"á~Ä.Ç<L£ Ã\x043…âKÕ"
  b"\x19WŠÉˆôEù¸EÏ]‚\t>À"
  b"$Ú»x–!D\x07“<’‚\tJ±W"
  b"j¹sjÊ)@p¹¦»“ϼqù"
  b"ùyƒÍ\rùJÌü´¥µç║ƒ¬"
  b"""
    í╣åç2ª@┴óØ\n
    ╠øÊ╚È
    """
  b"¥ás%™©I\x13€’\t\x1CQ\x01[Ñ"
  b"°—lâ\x04FGn¦‡l©z1µê"
  b"""
    ¼)®ôââ@t—R2\x08œu\n
    ø
    """
  b"ÖI|\tå\x01M\x1D¦Zú¥F®žü"
  b"▄^J$Û`N&ç\x1E╬╩¹Ïü¦"
  b"""
    ç²ÄyÚ$@î—7ÙL\n
    Õ?Å
    """
  b"ö@Š¥3CCú¬I\x0E\x15Ìÿ\x17©"
  b"\x07\x08š²–ÂA\x19¿\x1E¯‰=Òb\x12"
  b"\x1F\x05K\r„VAE€Ìݪ…ûbÑ"
  b"%Çâ0/³NÞ’§¬ë3»\x06ˆ"
  b"Q0);­\rO\x19¿zj}€Š\e."
  b"░9\x07R*ÍCu£¼Ø\x03╠\x02▓╬"
  b"ܶŒÙƒ…KÌ¢q\v\x06…ÅŸÍ"
  b"\x16L’\x00£ôN¢®­Þþ(˜6¦"
  b"\x1EÁP[┐D@¬óûËþnð\x1CÉ"
  b"$²$\x00`qEü·\x04,\t½R;\x1E"
  b"]v’Ç9qG0‹ÖN˜Ý £^"
  b"ê/Q¢┬╠N\x0EªÕ▓4#]\x1Cü"
  b"Ü█ÉònõOÚâà\x12t4OÓ3"
  b"¹\x11h┘óhA2à\x1F»Ó╝þ\rÉ"
  b"7Mîu“LЮVzךm„K"
  b"â┐e\x04d½NÑùÛd>Þü_\n"
  b"´*ÓSå¹O£’]‹-=×'ï"
  b"\t„&\x05|\x04E\x0Fš”ÐЖAçŒ"
  b"\x13bë:\x08äNQ„õ§IeI“e"
  b"ECc╚\t4N÷Ø3µ®\fæ²Ë"
  b"®e¢óu“BJŠÏºÊí\x07•Ÿ"
  b"þ╬┬Åèz@'░}ÌÚó$┼█"
  b"îÖl\f\x19éGi§Ïê³%!|X"
  b"%\ "[„Nã ›\vÔÄÆúø"
  b"D\x13Æ€yûJ@œ©)x\x00Ég+"
  b"ü\x05C#&çH¿à\x17\x07{H+"&"
  b"ÜئâghB\x03ûêFÉÓ└╠D"
  b"ÜÕìöþ`O┐ÂaÒ¬S@╔\e"
  b"Ÿ”\t’4\x12Oá…\x15\x04\x12ï2Sl"
  b"ÂM\v\eHóK»»w\x0FŽô³\x03s"
  b"Èú©┘SûJyÅÒk;\x1Ex<─"
  b"▀\x1F\x14╣kACÅûMò¥ÈÕɳ"
  b"QÏ\x17©1{CíÅ│.\x1DÌ╬┴Â"
  b"„—wi¶ÉB”‚NU{Šžïç"
  b"\x1D}\rÞy«O1´¤À¥Ø6i~"
  b"!ëÑ17…@ü–µ;\x0EŸ5Ö•"
  b"K2h”6ÜGÉ™è(šáúÈv"
  b"sd£}vbL¦ªhƆnY\x04w"
  b"╝Ñ\x04L\x16ØB½©║õ³\x08*\x1F╚"
  b"fþéºÃgOû¨\v¯\x02ÒMxä"
  b"áÇÄ\vÅõB\x15²»öcz\x11Ÿ›"
  b"\x01ì┼ı\x15QvGÄO\x19╠▄ïê\x11"
  b"<"Wí¢fNMž£LÍ%õȯ"
  b"odâÈ"ÐK6§RÔ˜ËÎWÝ"
  b"Œc\v¡I»Gà‘V½NþE¿J"
  b")÷ÜK~TB¨‹\x11\x1Di”S…b"
  b"•ò\x1E h\x19C½¦Ð˜ê¦ÝÞ\x00"
  b"¶¹\x00\x01ú KFÉ\t¬_▒õ±h"
  b"•†‚­L$L\x15º´¥l[\†\x1F"
  b"¨y\x16\t\žLX‘vPÆ\x1F’2Û"
  b"ËüíÇ·▀B©©\x07‗}"M\x07\x02"
  b"·)=É¢fD`ÆÎÕ©â®7S"
  b"€äxòÀžA(ƒ(\x13Ø)’£©"
  b"®ÚMn.ÐA\¸ìþ®ÅÖ\x1CŽ"
  b"Ö5L¯óEL´âçƒÉÇ©Hr"
  b"$÷ú¦┴²KËÉ=║UÍN´º"
  b"\^R▓×ÆCmÁØ(\x7Fý\x01┌@"
  b"c$>\x02ØSI¡›\x07¥Â3„¢H"
  b"¥ìxì¢\x15H™¦Nú\x052ߪ\x03"
  b"Ѫ]E˜ÊG&‰¦\x0FœÜ_î¡"
  b"ùzÑ&í\x01GLƒ :‰õ·";"
  b"‰—\x1A¡½èM·–žfQ`õJ’"
  b"¥ºa4Î\x06J®µx\x08@4ýq§"
  b"uUË\x04Ë\x1FFŸºŠÞ\x0F\x12c’^"
  b"wxÊ‘læGωæ]ᢾ8\e"
  b"-Z/1e\tH©ìPC°M_ô¶"
  b"É-JõóöGìñ?hå\x17O\x1FÄ"
  b"¯¢šŠû\x01Dï¼å¦í-6ô8"
  b"óÕyŽ¯‘@ižãƒ ™SP¢"
  b"'U”\x02NHK‚@\x0FÍŠ¨-Ò"
  b"PŸô8\x03ÕO%®ÁÙÀ4Á6X"
  b"è¬þÂ:Z@źTçıÅ$É5"
  b"ÁW\x00Þ\x01\x13H€€\x1ARHÂÄaá"
  b"À\rq%JïNÍ°B¨:TX¢Ä"
  b"þ±Ñ&|yB¿“ñè\x12w•\x1E\x10"
  b"T”oãH“Gð›»\x1EÊ\x11Xÿu"
  b"ϸϻ©\x7FA7öR¹╩ôéØÁ"
  b"»Û\x19\x0F\x1A¢HÉ«I╣4\\x10Fh"
  b"\f~b\x0EIVH‗åç\x03┐>Lüù"
  b"5═\x01┼·?IóÅ8\x0F\\x02ß╠°"
  b"¨ä╝)#BK[üý\t\x0FR\x16ÙL"
  b"\x01ïÏ;î■~┼øùÇÅ\x1DEwÞ"
  b"G\x02Å#2PL\x0E¹~Èqùfì\x1A"
  b"H¨Eâ²áOä­ÊØ[œÆäP"
  b"§\x02ભ\eA¦¼“xÂÆIÙ("
  b"±E†Þ1lMu–Æ.܃du3"
]
View formatted query    View runnable query    Explain query    View query backtrace
5.37 ms
(2.54%) 		1 
SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `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`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.swagCmsExtensionsForm`.`id` as `cms_slot.swagCmsExtensionsForm.id`, `cms_slot.swagCmsExtensionsForm`.`cms_slot_id` as `cms_slot.swagCmsExtensionsForm.cmsSlotId`, `cms_slot.swagCmsExtensionsForm`.`cms_slot_version_id` as `cms_slot.swagCmsExtensionsForm.cmsSlotVersionId`, `cms_slot.swagCmsExtensionsForm`.`is_template` as `cms_slot.swagCmsExtensionsForm.isTemplate`, `cms_slot.swagCmsExtensionsForm`.`technical_name` as `cms_slot.swagCmsExtensionsForm.technicalName`, `cms_slot.swagCmsExtensionsForm`.`mail_template_id` as `cms_slot.swagCmsExtensionsForm.mailTemplateId`, `cms_slot.swagCmsExtensionsForm`.`created_at` as `cms_slot.swagCmsExtensionsForm.createdAt`, `cms_slot.swagCmsExtensionsForm`.`updated_at` as `cms_slot.swagCmsExtensionsForm.updatedAt`, `cms_slot.swagCmsExtensionsForm.translation.title`, COALESCE(`cms_slot.swagCmsExtensionsForm.translation.title`,`cms_slot.swagCmsExtensionsForm.translation.title`) as `cms_slot.swagCmsExtensionsForm.title`, `cms_slot.swagCmsExtensionsForm.translation.successMessage`, COALESCE(`cms_slot.swagCmsExtensionsForm.translation.successMessage`,`cms_slot.swagCmsExtensionsForm.translation.successMessage`) as `cms_slot.swagCmsExtensionsForm.successMessage`, `cms_slot.swagCmsExtensionsForm.translation.receivers`, COALESCE(`cms_slot.swagCmsExtensionsForm.translation.receivers`,`cms_slot.swagCmsExtensionsForm.translation.receivers`) as `cms_slot.swagCmsExtensionsForm.receivers`, `cms_slot.swagCmsExtensionsForm.translation.createdAt`, `cms_slot.swagCmsExtensionsForm.translation.updatedAt`, `cms_slot.swagCmsExtensionsForm.translation.swagCmsExtensionsFormId`, `cms_slot.swagCmsExtensionsForm.translation.languageId`, `cms_slot.translation.config`, COALESCE(`cms_slot.translation.config`,`cms_slot.translation.config`) as `cms_slot.config`, `cms_slot.translation.customFields`, COALESCE(`cms_slot.translation.customFields`,`cms_slot.translation.customFields`) as `cms_slot.customFields`, `cms_slot.translation.createdAt`, `cms_slot.translation.updatedAt`, `cms_slot.translation.cmsSlotId`, `cms_slot.translation.languageId`, `cms_slot.translation.cmsSlotVersionId` 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`, `cms_slot.translation`.created_at as `cms_slot.translation.createdAt`, `cms_slot.translation`.updated_at as `cms_slot.translation.updatedAt`, `cms_slot.translation`.cms_slot_id as `cms_slot.translation.cmsSlotId`, `cms_slot.translation`.language_id as `cms_slot.translation.languageId`, `cms_slot.translation`.cms_slot_version_id as `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation`.language_id = ?) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` AND `cms_slot.cms_slot_translation`.cms_slot_version_id = `cms_slot`.version_id LEFT JOIN `swag_cms_extensions_form` `cms_slot.swagCmsExtensionsForm` ON `cms_slot`.`id` = `cms_slot.swagCmsExtensionsForm`.`cms_slot_id` LEFT JOIN (SELECT `cms_slot.swagCmsExtensionsForm.translation`.swag_cms_extensions_form_id, `cms_slot.swagCmsExtensionsForm.translation`.title as `cms_slot.swagCmsExtensionsForm.translation.title`, `cms_slot.swagCmsExtensionsForm.translation`.success_message as `cms_slot.swagCmsExtensionsForm.translation.successMessage`, `cms_slot.swagCmsExtensionsForm.translation`.receivers as `cms_slot.swagCmsExtensionsForm.translation.receivers`, `cms_slot.swagCmsExtensionsForm.translation`.created_at as `cms_slot.swagCmsExtensionsForm.translation.createdAt`, `cms_slot.swagCmsExtensionsForm.translation`.updated_at as `cms_slot.swagCmsExtensionsForm.translation.updatedAt`, `cms_slot.swagCmsExtensionsForm.translation`.swag_cms_extensions_form_id as `cms_slot.swagCmsExtensionsForm.translation.swagCmsExtensionsFormId`, `cms_slot.swagCmsExtensionsForm.translation`.language_id as `cms_slot.swagCmsExtensionsForm.translation.languageId` FROM `swag_cms_extensions_form_translation` `cms_slot.swagCmsExtensionsForm.translation` WHERE `cms_slot.swagCmsExtensionsForm.translation`.language_id = ?) `cms_slot.swagCmsExtensionsForm.swag_cms_extensions_form_translation` ON `cms_slot.swagCmsExtensionsForm.swag_cms_extensions_form_translation`.`swag_cms_extensions_form_id` = `cms_slot.swagCmsExtensionsForm`.`id` WHERE (`cms_slot`.`version_id` = ?) AND (`cms_slot`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"J]9£ÀüMj░4Èl:\vñ¶"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.63 ms
(2.19%) 		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`.`link` as `product_manufacturer.link`, `product_manufacturer`.`created_at` as `product_manufacturer.createdAt`, `product_manufacturer`.`updated_at` as `product_manufacturer.updatedAt`, `product_manufacturer.translation.name`, COALESCE(`product_manufacturer.translation.name`,`product_manufacturer.translation.name`) as `product_manufacturer.name`, `product_manufacturer.translation.description`, COALESCE(`product_manufacturer.translation.description`,`product_manufacturer.translation.description`) as `product_manufacturer.description`, `product_manufacturer.translation.customFields`, COALESCE(`product_manufacturer.translation.customFields`,`product_manufacturer.translation.customFields`) as `product_manufacturer.customFields`, `product_manufacturer.translation.createdAt`, `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation.languageId`, `product_manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.product_manufacturer_id, `product_manufacturer.translation`.product_manufacturer_version_id, `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`, `product_manufacturer.translation`.created_at as `product_manufacturer.translation.createdAt`, `product_manufacturer.translation`.updated_at as `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation`.product_manufacturer_id as `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation`.language_id as `product_manufacturer.translation.languageId`, `product_manufacturer.translation`.product_manufacturer_version_id as `product_manufacturer.translation.productManufacturerVersionId` 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"_ÀsIgGM¢½t\x10…’S@O"
  b"ºåõ{_vA׃‰íp¼é1‚"
  b"þò\x18N~°NͺÏ(Ç3\x10 ë"
  b"\x00Ãk\x18Ýi@A•ÿ\x0F»÷iÆþ"
  b"Ü\x1FèÙÇ~J`¨\x0E\x1CM\x0Eë\x14Í"
  b"\e\x02ñÆ–ØGÖšÕ¿|HÉ·ž"
  b"çäbE„\x10D+”žfóí ¹õ"
  b":þ\x114Ž”H#»Y\rmeC&‚"
  b")k ¦".E~ì­c¯.Ò▓N"
  b"Êð¼Ø\x1C5LA‚¼Ëü©Ø­Ø"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.38 ms
(2.07%) 		6 
# app-scripts::refresh::read
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
3.56 ms
(1.69%) 		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
3.22 ms
(1.52%) 		2 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  "QPPuO64v6ZEsXxxP2lf6Udw2GzyT256P"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.42 ms
(1.14%) 		2 
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE ?
Parameters: 
[
  "payload"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.30 ms
(1.09%) 		6 
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.42 ms
(0.67%) 		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.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.translation.name`, COALESCE(`property_group_option.group.translation.name`,`property_group_option.group.translation.name`) as `property_group_option.group.name`, `property_group_option.group.translation.description`, COALESCE(`property_group_option.group.translation.description`,`property_group_option.group.translation.description`) as `property_group_option.group.description`, `property_group_option.group.translation.position`, COALESCE(`property_group_option.group.translation.position`,`property_group_option.group.translation.position`) as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, COALESCE(`property_group_option.group.translation.customFields`,`property_group_option.group.translation.customFields`) as `property_group_option.group.customFields`, `property_group_option.group.translation.createdAt`, `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation.languageId`, `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`.`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`, COALESCE(`property_group_option.media.translation.title`,`property_group_option.media.translation.title`) as `property_group_option.media.title`, `property_group_option.media.translation.alt`, COALESCE(`property_group_option.media.translation.alt`,`property_group_option.media.translation.alt`) as `property_group_option.media.alt`, `property_group_option.media.translation.customFields`, COALESCE(`property_group_option.media.translation.customFields`,`property_group_option.media.translation.customFields`) as `property_group_option.media.customFields`, `property_group_option.media.translation.createdAt`, `property_group_option.media.translation.updatedAt`, `property_group_option.media.translation.mediaId`, `property_group_option.media.translation.languageId`, `property_group_option.translation.name`, COALESCE(`property_group_option.translation.name`,`property_group_option.translation.name`) as `property_group_option.name`, `property_group_option.translation.position`, COALESCE(`property_group_option.translation.position`,`property_group_option.translation.position`) as `property_group_option.position`, `property_group_option.translation.customFields`, COALESCE(`property_group_option.translation.customFields`,`property_group_option.translation.customFields`) as `property_group_option.customFields`, `property_group_option.translation.createdAt`, `property_group_option.translation.updatedAt`, `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation.languageId` FROM `property_group_option` 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`, `property_group_option.translation`.created_at as `property_group_option.translation.createdAt`, `property_group_option.translation`.updated_at as `property_group_option.translation.updatedAt`, `property_group_option.translation`.property_group_option_id as `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation`.language_id as `property_group_option.translation.languageId` 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 `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.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`, `property_group_option.group.translation`.created_at as `property_group_option.group.translation.createdAt`, `property_group_option.group.translation`.updated_at as `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation`.property_group_id as `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation`.language_id as `property_group_option.group.translation.languageId` 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`.title as `property_group_option.media.translation.title`, `property_group_option.media.translation`.alt as `property_group_option.media.translation.alt`, `property_group_option.media.translation`.custom_fields as `property_group_option.media.translation.customFields`, `property_group_option.media.translation`.created_at as `property_group_option.media.translation.createdAt`, `property_group_option.media.translation`.updated_at as `property_group_option.media.translation.updatedAt`, `property_group_option.media.translation`.media_id as `property_group_option.media.translation.mediaId`, `property_group_option.media.translation`.language_id as `property_group_option.media.translation.languageId` 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"\x00‘«„hTD†œêêó/;\x07ü"
  b"\x01ïÏ;î■~┼øùÇÅ\x1DEwÞ"
  b"\x05ÌNTœåJ¯ž¸„¬\x15לÒ"
  b"\x0F•é{\x1D<G6·Rš)€Ü"S"
  b"\x0Fájò¾®BìªIQ6\x1DÏ\x12Ú"
  b"\x14Þ.ËÙøLKª\x06ï\rÁ¤=Þ"
  b"\x19”\x13”HEJH‹ùG¥Øï=Í"
  b"\x19²æ|;¤BÛ¾\x1Aâ\x02ß™…¥"
  b"\x1F\x05K\r„VAE€Ìݪ…ûbÑ"
  b"!\x02<\x11\x11áAò¢3™5?3“Š"
  b"#°o($ÄGĪºi`t¯&ñ"
  b")»W\x14¾¥@¹¬{Ðwâ±Ùo"
  b"+ø{ü]>Géñ¾£-á©k:"
  b"7cÇÔögBîØ═\SHf┤\x07"
  b"D\x13Æ€yûJ@œ©)x\x00Ég+"
  b"F'vûZÏ@s‹léqgÁl\x06"
  b"G\x02Å#2PL\x0E¹~Èqùfì\x1A"
  b"Q0);­\rO\x19¿zj}€Š\e."
  b"T¸¦ùq§Cθ\x1Fœ `ønµ"
  b"V…û½\x04ÄG%”¹Ì@\x07}MC"
  b"""
    W╝┐ËÌ`CѼóØ#\x02\n
    sn
    """
  b"ZÜÞjÎ&J+œìf–›ÅõÁ"
  b"[œwÖ¢ïCg¹mEÏþ»c\"
  b"\¥P\x13ÎÜK¾ž¬\x00jŽ¢~¢"
  b"`êJî:ÍK‚Œòˆ²œ_mi"
  b"c$>\x02ØSI¡›\x07¥Â3„¢H"
  b"fþéºÃgOû¨\v¯\x02ÒMxä"
  b"jsó•“<A\x04¥æ+3\fSÀ$"
  b"j¢ãê¯oG*°„97ÍôË "
  b"odâÈ"ÐK6§RÔ˜ËÎWÝ"
  b"o}\VM”I_€îÇ®óéáP"
  b"r>\x0EQ\x07\x08FŽ°\iã¼–R0"
  b"sd£}vbL¦ªhƆnY\x04w"
  b"vW9œ8ØC\x0F®ã«\x12¯~6k"
  b"x\f\x14(<ûMá–`þ×L‰¶\x0F"
  b"}f¨LT×D¸†×cR\x11É°\e"
  b"}ÊØ”ðPK\x06¼\x1F\x03{uj\x1Dó"
  b"""
    \x7Flƒ%æÛJ2«\\n
    ÊIßE\x13
    """
  b"€äxòÀžA(ƒ(\x13Ø)’£©"
  b"â┐e\x04d½NÑùÛd>Þü_\n"
  b"…ù#O]×L3œrþX*Õ’Á"
  b"ê/Q¢┬╠N\x0EªÕ▓4#]\x1Cü"
  b"‰—\x1A¡½èM·–žfQ`õJ’"
  b"èü\tÄã\eAÕ¿\x001C║ß┤Z"
  b"“6¤o"ðIx„SâÝñéœè"
  b"•ò\x1E h\x19C½¦Ð˜ê¦ÝÞ\x00"
  b"ùyƒÍ\rùJÌü´¥µç║ƒ¬"
  b"ÜئâghB\x03ûêFÉÓ└╠D"
  b"Ü█ÉònõOÚâà\x12t4OÓ3"
  b"ÜÕìöþ`O┐ÂaÒ¬S@╔\e"
  b"Ø'³9┴@┌Ü@ÖÏ-¨Á\x0F"
  b"ž©’d 4GV®~ÈÔ\x1E\x14PG"
  b"žÉƒRUÑC$¿»a\x7F\v»î«"
  b"Ÿ”\t’4\x12Oá…\x15\x04\x12ï2Sl"
  b"ú¼í7a\fHPÉSæÞ\x18\x13bû"
  b"¥ºa4Î\x06J®µx\x08@4ýq§"
  b"░'\x1E.é\x1EL÷ì‗\v«ûa¸\x0F"
  b"°—lâ\x04FGn¦‡l©z1µê"
  b"│╔ù ─]J#ìIRh\x18Æ\x13u"
  b"´*ÓSå¹O£’]‹-=×'ï"
  b"¹„)‘êCBì©©QNb–€N"
  b"ÁcïGzãN[œÚn±÷lØÊ"
  b"""
    Á´oºÔŒFiŽ:X\v\n
    ×Ûì
    """
  b"ÂM\v\eHóK»»w\x0FŽô³\x03s"
  b"Ðñ*ð2£C═üB)U<\x006U"
  b"ËüíÇ·▀B©©\x07‗}"M\x07\x02"
  b"Èú©┘SûJyÅÒk;\x1Ex<─"
  b"Í▄Ë·§\x1D@RɬÂ┘É1¯\x18"
  b"ϸϻ©\x7FA7öR¹╩ôéØÁ"
  b"ܶŒÙƒ…KÌ¢q\v\x06…ÅŸÍ"
  b"ÞG\x16¤‰0F3¤÷œÉ£%<ì"
  b"▀\x1F\x14╣kACÅûMò¥ÈÕɳ"
  b"à.;I¤ùK§ \x13ˆ…n ˜\x14"
  b"þ╬┬Åèz@'░}ÌÚó$┼█"
  b"îÖl\f\x19éGi§Ïê³%!|X"
  b"ö@Š¥3CCú¬I\x0E\x15Ìÿ\x17©"
  b"ùzÑ&í\x01GLƒ :‰õ·";"
  b"·)=É¢fD`ÆÎÕ©â®7S"
  b"úV}7ðæL¦—†Å)¯7éb"
  b"ü[[àä¿M‘–J—ÍÝäØ"
  b"ÿ·Ré\x04ŽDµ†½¾°Wó• "
]
View formatted query    View runnable query    Explain query    View query backtrace
1.25 ms
(0.59%) 		1 
# product-listing::property-filter::search-ids
SELECT `property_group_option`.`id` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` WHERE ((`property_group_option.group`.`filterable` = ?)) AND (`property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY `property_group_option`.`id` ASC LIMIT 500
Parameters: 
[
  true
  b"b\x1DB{ž~O„†<.ºªÛ\x13N"
  b"žÉƒRUÑC$¿»a\x7F\v»î«"
  b"F'vûZÏ@s‹léqgÁl\x06"
  b"r>\x0EQ\x07\x08FŽ°\iã¼–R0"
  b"ž©’d 4GV®~ÈÔ\x1E\x14PG"
  b"Ø'³9┴@┌Ü@ÖÏ-¨Á\x0F"
  b"ÁcïGzãN[œÚn±÷lØÊ"
  b"""
    \x7Flƒ%æÛJ2«\\n
    ÊIßE\x13
    """
  b"\x0F•é{\x1D<G6·Rš)€Ü"S"
  b"╔$\x00\x04ØTFë┤gçe\x17 Øy"
  b"èþVd|’CY«è^±ûø´a"
  b"úV}7ðæL¦—†Å)¯7éb"
  b"│╔ù ─]J#ìIRh\x18Æ\x13u"
  b"`êJî:ÍK‚Œòˆ²œ_mi"
  b"›Ð\e\x07„FI%³.X÷Gf\f¯"
  b"2÷åé\x1F6HWˆ"\x08³\x0F»¾\"
  b")»W\x14¾¥@¹¬{Ðwâ±Ùo"
  b"5)ƒ\x06\x1F=ON”—(¦_ï›ø"
  b"WvÜx¿cAZ´\x1E“\x11ûŠ‹Œ"
  b"«ÔáìÉü@y’ˆ)\x06jÏN8"
  b"ÞG\x16¤‰0F3¤÷œÉ£%<ì"
  b"{P àÿrB÷¦)]µu/û€"
  b"’Ñrò\x16~H½ ©2Ó\x1CE{\x1A"
  b"…ù#O]×L3œrþX*Õ’Á"
  b"¹„)‘êCBì©©QNb–€N"
  b"#°o($ÄGĪºi`t¯&ñ"
  b"\x0Fájò¾®BìªIQ6\x1DÏ\x12Ú"
  b"\x1C¯ÅW|àM³‰Ræ2méVA"
  b"^ƒùÂÈ«MV»ÐôÏ´ñG/"
  b"5\x1C¡g\x0FTJ©üòÅ\x13ÔlÆö"
  b"žð“jM\x1CJ@½ÕQ°q{IL"
  b"\f³¥œá*@VªSzÍö’‘5"
  b"žm\x05P2¡M‰’˜G®õ`ûÞ"
  b"Ðñ*ð2£C═üB)U<\x006U"
  b"Ê\x13Ñ└\x14hC┼ÅkÄä<7¶F"
  b"?Ä+€øëN„¡Bï\x14•B¿°"
  b"\x12»<\x1D‹‚E\e¯d<_ï/•R"
  b"á wÕY¬Ig­Ò\x07Õ²CÞ–"
  b"qÉ_Gì╝CÞóÐ!ZC┴ûP"
  b"«á*CìºM\x06çs´├Íؾ\x1E"
  b"µÌ!dñFAT¼k\x16ÚútÔp"
  b"ë\x0F\x1A†²‚H~µù¥Å×}î'"
  b"Å\x1EíŸz\x1AEµ’„KŠò²¦È"
  b"RK(Ù²¾Mf³Ëz'JÊÆÿ"
  b"á\tNö¹\x02JUž?¡®g\x1C÷È"
  b"\x19²æ|;¤BÛ¾\x1Aâ\x02ß™…¥"
  b"\x11e\x14ëì\x1CKîç¤Å┴À\x15\x08§"
  b"å\x05rò\x17âDÛÁ\x04$.¼v9Å"
  b"Ò3”ƒÛ}F\x14”®Â·V–\x1Fz"
  b"_v3┼9╚A#åØ6÷±cÙy"
  b"[|…ý±³O&¬\x11œ¦\x006ëÝ"
  b"ÐÀšMÏKNĈj,±€ÒtÏ"
  b"╗ ùk\x16¬EBƒ#x+'ÅgY"
  b"G\x10átî$J!‡´kD\vÔ×\x00"
  b"†\x06©\v¥;Nø³jHõú"
  b"nœYô¼¥@~´‘–w»õ\x12ì"
  b"-9¬\n}ÑF´€ß\x00\v/¦Y˜"
  b"œ±õ·Âz@n¥®…m#â8k"
  b"•Jý\x043öJ\x05¾\x08ƨM@\x06Ä"
  b"\├«l‗ K┌│ù70Ø\t\x19Î"
  b")&¨K®{GU ÛqjoÅš¨"
  b"âFóø@aMn¿¾ÊaVú¾,"
  b"ìÚÄ\rÚ¸OCîÀß╦Þ³óf"
  b"ÍØ\x00é\x12ÅG\x1C«\x04Íl¸>­y"
  b".[·loÛH`‹/fm\x041´¼"
  b"¼g\x18ÿ\f\vFȲ.0y×ͱz"
  b"U¸¶ºâ\x7FE\x7F²¡YÔa˜Ž\x0F"
  b"3¿È\x02oüKÏ :x¸p"\x01 "
  b"}ÊØ”ðPK\x06¼\x1F\x03{uj\x1Dó"
  b"•µ*дyCñ¿©u?wGÌ\x08"
  b"˜\x1E_rÀœNñµðå#W8~W"
  b"È£åŽÍJF¼¡Ã\x7FæSe\x14"
  b"ú¼í7a\fHPÉSæÞ\x18\x13bû"
  b"É┬\v\x04\x1DýC±ïáıÐl©\v┤"
  b"KKlı¿3Gq×?wìK┬ݸ"
  b"ãy\x06$pêOÅùî\x1D┼Xºû|"
  b"àä\x0EçÎUA9¨µfÍ­Ž÷¬"
  b"¢‘3f·hGj£%‰®Qs¥Æ"
  b"cÆ0ñ?Ë@´„…ºIŸAõï"
  b"""
    þµ\n
    hõÈMv–¿©~8n…W
    """
  b"ì*vùÉ\x08@\x16‡\x0Ecä\x13\x15Ƶ"
  b"ïÞá·P\x1AH\x07ž.S[ØX)\x1E"
  b"ix\x7F¨ìÓBÂ░L:"¯v■º"
  b"bx£øïãMÂ¿àŽ§2²\x06i"
  b"\táÅH\x10èJ-ůe;┘p±\x13"
  b"Ñ3\x14^.-Mx“5É£Ò’\x07Ç"
  b"Sñf]a®CìÖÊ¿:to­¦"
  b"iPû▄\x04"JJú£µÃÅPñI"
  b"\x14Þ.ËÙøLKª\x06ï\rÁ¤=Þ"
  b"\x19”\x13”HEJH‹ùG¥Øï=Í"
  b"!\x02<\x11\x11áAò¢3™5?3“Š"
  b"+ø{ü]>Géñ¾£-á©k:"
  b",·ªkÿ\rNæª\x1FGœ_Ò×s"
  b"7cÇÔögBîØ═\SHf┤\x07"
  b"T¸¦ùq§Cθ\x1Fœ `ønµ"
  b"ZÜÞjÎ&J+œìf–›ÅõÁ"
  b"[œwÖ¢ïCg¹mEÏþ»c\"
  b"jsó•“<A\x04¥æ+3\fSÀ$"
  b"k©–IMºC\x04¢ìŠ\x10\x12ôã½"
  b"o}\VM”I_€îÇ®óéáP"
  b"x\f\x14(<ûMá–`þ×L‰¶\x0F"
  b"}f¨LT×D¸†×cR\x11É°\e"
  b"èü\tÄã\eAÕ¿\x001C║ß┤Z"
  b"“6¤o"ðIx„SâÝñéœè"
  b"░'\x1E.é\x1EL÷ì‗\v«ûa¸\x0F"
  b"""
    Á´oºÔŒFiŽ:X\v\n
    ×Ûì
    """
  b"Åå©o\r'G·ˆfž¥õ\v^j"
  b"Í▄Ë·§\x1D@RɬÂ┘É1¯\x18"
  b"à.;I¤ùK§ \x13ˆ…n ˜\x14"
  b"òp\x1E¯ «D\x00ˆJƒ\x039±X`"
  b"ü[[àä¿M‘–J—ÍÝäØ"
  b"\x00‘«„hTD†œêêó/;\x07ü"
  b"\x05ÌNTœåJ¯ž¸„¬\x15לÒ"
  b"P™‹Ù2\tJtµÖ\x13@6%\x0F¿"
  b"V…û½\x04ÄG%”¹Ì@\x07}MC"
  b"""
    W╝┐ËÌ`CѼóØ#\x02\n
    sn
    """
  b"\¥P\x13ÎÜK¾ž¬\x00jŽ¢~¢"
  b"j¢ãê¯oG*°„97ÍôË "
  b"vW9œ8ØC\x0F®ã«\x12¯~6k"
  b"“\x08êõ÷\rIÓ»%h<G\rH‡"
  b"ÃÞ\x04ÃÍùAÀ¦¶\x0EÁš´\x06`"
  b"ÿ·Ré\x04ŽDµ†½¾°Wó• "
  b"á~Ä.Ç<L£ Ã\x043…âKÕ"
  b"\x19WŠÉˆôEù¸EÏ]‚\t>À"
  b"$Ú»x–!D\x07“<’‚\tJ±W"
  b"j¹sjÊ)@p¹¦»“ϼqù"
  b"ùyƒÍ\rùJÌü´¥µç║ƒ¬"
  b"""
    í╣åç2ª@┴óØ\n
    ╠øÊ╚È
    """
  b"¥ás%™©I\x13€’\t\x1CQ\x01[Ñ"
  b"°—lâ\x04FGn¦‡l©z1µê"
  b"""
    ¼)®ôââ@t—R2\x08œu\n
    ø
    """
  b"ÖI|\tå\x01M\x1D¦Zú¥F®žü"
  b"▄^J$Û`N&ç\x1E╬╩¹Ïü¦"
  b"""
    ç²ÄyÚ$@î—7ÙL\n
    Õ?Å
    """
  b"ö@Š¥3CCú¬I\x0E\x15Ìÿ\x17©"
  b"\x07\x08š²–ÂA\x19¿\x1E¯‰=Òb\x12"
  b"\x1F\x05K\r„VAE€Ìݪ…ûbÑ"
  b"%Çâ0/³NÞ’§¬ë3»\x06ˆ"
  b"Q0);­\rO\x19¿zj}€Š\e."
  b"░9\x07R*ÍCu£¼Ø\x03╠\x02▓╬"
  b"ܶŒÙƒ…KÌ¢q\v\x06…ÅŸÍ"
  b"\x16L’\x00£ôN¢®­Þþ(˜6¦"
  b"\x1EÁP[┐D@¬óûËþnð\x1CÉ"
  b"$²$\x00`qEü·\x04,\t½R;\x1E"
  b"]v’Ç9qG0‹ÖN˜Ý £^"
  b"ê/Q¢┬╠N\x0EªÕ▓4#]\x1Cü"
  b"Ü█ÉònõOÚâà\x12t4OÓ3"
  b"¹\x11h┘óhA2à\x1F»Ó╝þ\rÉ"
  b"7Mîu“LЮVzךm„K"
  b"â┐e\x04d½NÑùÛd>Þü_\n"
  b"´*ÓSå¹O£’]‹-=×'ï"
  b"\t„&\x05|\x04E\x0Fš”ÐЖAçŒ"
  b"\x13bë:\x08äNQ„õ§IeI“e"
  b"ECc╚\t4N÷Ø3µ®\fæ²Ë"
  b"®e¢óu“BJŠÏºÊí\x07•Ÿ"
  b"þ╬┬Åèz@'░}ÌÚó$┼█"
  b"îÖl\f\x19éGi§Ïê³%!|X"
  b"%\ "[„Nã ›\vÔÄÆúø"
  b"D\x13Æ€yûJ@œ©)x\x00Ég+"
  b"ü\x05C#&çH¿à\x17\x07{H+"&"
  b"ÜئâghB\x03ûêFÉÓ└╠D"
  b"ÜÕìöþ`O┐ÂaÒ¬S@╔\e"
  b"Ÿ”\t’4\x12Oá…\x15\x04\x12ï2Sl"
  b"ÂM\v\eHóK»»w\x0FŽô³\x03s"
  b"Èú©┘SûJyÅÒk;\x1Ex<─"
  b"▀\x1F\x14╣kACÅûMò¥ÈÕɳ"
  b"QÏ\x17©1{CíÅ│.\x1DÌ╬┴Â"
  b"„—wi¶ÉB”‚NU{Šžïç"
  b"\x1D}\rÞy«O1´¤À¥Ø6i~"
  b"!ëÑ17…@ü–µ;\x0EŸ5Ö•"
  b"K2h”6ÜGÉ™è(šáúÈv"
  b"sd£}vbL¦ªhƆnY\x04w"
  b"╝Ñ\x04L\x16ØB½©║õ³\x08*\x1F╚"
  b"fþéºÃgOû¨\v¯\x02ÒMxä"
  b"áÇÄ\vÅõB\x15²»öcz\x11Ÿ›"
  b"\x01ì┼ı\x15QvGÄO\x19╠▄ïê\x11"
  b"<"Wí¢fNMž£LÍ%õȯ"
  b"odâÈ"ÐK6§RÔ˜ËÎWÝ"
  b"Œc\v¡I»Gà‘V½NþE¿J"
  b")÷ÜK~TB¨‹\x11\x1Di”S…b"
  b"•ò\x1E h\x19C½¦Ð˜ê¦ÝÞ\x00"
  b"¶¹\x00\x01ú KFÉ\t¬_▒õ±h"
  b"•†‚­L$L\x15º´¥l[\†\x1F"
  b"¨y\x16\t\žLX‘vPÆ\x1F’2Û"
  b"ËüíÇ·▀B©©\x07‗}"M\x07\x02"
  b"·)=É¢fD`ÆÎÕ©â®7S"
  b"€äxòÀžA(ƒ(\x13Ø)’£©"
  b"®ÚMn.ÐA\¸ìþ®ÅÖ\x1CŽ"
  b"Ö5L¯óEL´âçƒÉÇ©Hr"
  b"$÷ú¦┴²KËÉ=║UÍN´º"
  b"\^R▓×ÆCmÁØ(\x7Fý\x01┌@"
  b"c$>\x02ØSI¡›\x07¥Â3„¢H"
  b"¥ìxì¢\x15H™¦Nú\x052ߪ\x03"
  b"Ѫ]E˜ÊG&‰¦\x0FœÜ_î¡"
  b"ùzÑ&í\x01GLƒ :‰õ·";"
  b"‰—\x1A¡½èM·–žfQ`õJ’"
  b"¥ºa4Î\x06J®µx\x08@4ýq§"
  b"uUË\x04Ë\x1FFŸºŠÞ\x0F\x12c’^"
  b"wxÊ‘læGωæ]ᢾ8\e"
  b"-Z/1e\tH©ìPC°M_ô¶"
  b"É-JõóöGìñ?hå\x17O\x1FÄ"
  b"¯¢šŠû\x01Dï¼å¦í-6ô8"
  b"óÕyŽ¯‘@ižãƒ ™SP¢"
  b"'U”\x02NHK‚@\x0FÍŠ¨-Ò"
  b"PŸô8\x03ÕO%®ÁÙÀ4Á6X"
  b"è¬þÂ:Z@źTçıÅ$É5"
  b"ÁW\x00Þ\x01\x13H€€\x1ARHÂÄaá"
  b"À\rq%JïNÍ°B¨:TX¢Ä"
  b"þ±Ñ&|yB¿“ñè\x12w•\x1E\x10"
  b"T”oãH“Gð›»\x1EÊ\x11Xÿu"
  b"ϸϻ©\x7FA7öR¹╩ôéØÁ"
  b"»Û\x19\x0F\x1A¢HÉ«I╣4\\x10Fh"
  b"\f~b\x0EIVH‗åç\x03┐>Lüù"
  b"5═\x01┼·?IóÅ8\x0F\\x02ß╠°"
  b"¨ä╝)#BK[üý\t\x0FR\x16ÙL"
  b"\x01ïÏ;î■~┼øùÇÅ\x1DEwÞ"
  b"G\x02Å#2PL\x0E¹~Èqùfì\x1A"
  b"H¨Eâ²áOä­ÊØ[œÆäP"
  b"§\x02ભ\eA¦¼“xÂÆIÙ("
  b"±E†Þ1lMu–Æ.܃du3"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.04 ms
(0.49%) 		6 
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.80 ms
(0.38%) 		1 
SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.47 ms
(0.22%) 		1 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.46 ms
(0.22%) 		1 
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"Rmi0±ÝIÕºwö)¦¤w÷"
  b"­Çò‚X¶Oš¨wÒ7³@ˆ®"
  b"ÅL|g\x0E'EL¶\x13ÉÖÑéç‹"
  b"l›î.G\x08OàžßP\x01€Èéº"
  b"""
    ~/ëàÕd@- ë\n
    \x0FB]ü¸
    """
  b"¥¶6o\x10+A÷’LÚ¯+‹¿."
  b"®ÇÐj÷sFu¡®\rÔ˜£N="
  b"ʃ$Ã\tUCö¦Ÿ’0PxfW"
  b"Þ$U¿Œ¢Kš„|ž9~@ri"
  b"­ã:╔\x06▀AÉɳ\x07x\x01E¦k"
  b"\x01ÅQ▄-Ïuvè.ýqkB\x00\x00"
  b"\x01ÅQÔ¶Øs\x19░A\x05Ȩ═ V"
  b"È\f¨É\vðIPïô│Ú╚Ç°÷"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.45 ms
(0.21%) 		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`, COALESCE(`product_sorting.translation.label`,`product_sorting.translation.label`) as `product_sorting.label`, `product_sorting.translation.createdAt`, `product_sorting.translation.updatedAt`, `product_sorting.translation.productSortingId`, `product_sorting.translation.languageId` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.product_sorting_id, `product_sorting.translation`.label as `product_sorting.translation.label`, `product_sorting.translation`.created_at as `product_sorting.translation.createdAt`, `product_sorting.translation`.updated_at as `product_sorting.translation.updatedAt`, `product_sorting.translation`.product_sorting_id as `product_sorting.translation.productSortingId`, `product_sorting.translation`.language_id as `product_sorting.translation.languageId` 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"¸\¤\x12)ÅM\x10âÍ°þè¹s\x10"
  b"Ö4{š4?JÙ—A\x1Aó,\x0Eëã"
  b"•õ3XÌÏH$†‹þ«j\:¯"
  b"vÌ\x18—•\tI@‚åˆÖ‡8•O"
  b"S'‚wYëFߣ\x01‘åå€îQ"
  b"ÅÜÍ▄ß┘EÀ¿vÇ╣U\v╚░"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.43 ms
(0.20%) 		1 
SELECT seo_path_info FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND (seo_path_info = ?) AND (is_canonical = ?) ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  "widgets/cms/navigation/d416353931ff4c7c92ae748318d19bc7/filter/"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.38 ms
(0.18%) 		1 
SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id`  LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id`  WHERE ((`country.salesChannels`.`id` = ?)) AND (`country`.`id` IN (?)) GROUP BY `country`.`id`
Parameters: 
[
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  b"CÕL P»L\x07Ÿ3|-'i’\x16"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(0.17%) 		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.36 ms
(0.17%) 		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 = ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  "widgets/cms/navigation/d416353931ff4c7c92ae748318d19bc7/filter"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(0.17%) 		1 
# product-listing::load-sortings::search-ids
SELECT `product_sorting`.`id` FROM `product_sorting` WHERE (`product_sorting`.`active` = ?) ORDER BY `product_sorting`.`priority` DESC
Parameters: 
[
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.34 ms
(0.16%) 		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"Ô\x16591ÿL|’®tƒ\x18Ñ›Ç"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(0.12%) 		2 
#cart-persister::load
                SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters: 
[
  "QPPuO64v6ZEsXxxP2lf6Udw2GzyT256P"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.22 ms
(0.11%) 		1 
# seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (path_info = ?) AND (is_canonical = 1) LIMIT 1
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  "/widgets/cms/navigation/d416353931ff4c7c92ae748318d19bc7/filter"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.19 ms
(0.09%) 		1 
SELECT `cms_slot`.`id` FROM `cms_slot` WHERE (`cms_slot`.`version_id` = ?) AND (`cms_slot`.`id` IN (?)) LIMIT 1
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"J]9£ÀüMj░4Èl:\vñ¶"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.16 ms
(0.08%) 		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"Ô\x16591ÿL|’®tƒ\x18Ñ›Ç"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.11 ms
(0.05%) 		1 
SELECT module.module, module.response FROM wbm_data_layer_modules module
Parameters: 
[]
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.