GET https://abb-dev.tech/widgets/cms/navigation/1ea2dba5b5474d10ac40cd4c962d8b8b/filter?only-aggregations=1&reduce-aggregations=1&slots=0192b5386af6738099637dd2eeb6…

Response
200 OK
Browse referrer URL
IP
66.249.66.33
Profiled on
Token
65d380

Query Metrics

40 Database Queries
34 Different statements
117.77 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
66.13 ms
(56.15%) 		1 
# product-listing-route::loading::aggregation::price
SELECT MIN(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule063b1ad4f7b2488a976ab21f670f2bbe.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule07fca9bbe46543d3ac345e41c3b38eff.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule160b35e830df4e2bb11608086b3f5100.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule1a70ce62d6884f76a08b9112ffa46829.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule237bde03a96740209c93a552bef26a15.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule275b92e8b48d4e048bd0b1d6acf59fca.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule27a96dd1f40d40dd9f092ff7910b0be1.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule2d5866c8047b4ffcaab41eeb21f54cbc.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule37a25eb8b9e44325a980aab691d89e12.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule3d03f77a584c4e3fa6537e772a777c8c.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule419a15f76e974efc82f246185aebb3c4.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule4d160d3746f2414aa35c6b48b10a74b9.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule625c13521246471da7e563ec37b93810.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule669cb8be3bc04b8b8e71ab54c1dede3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule767c3c153d2e44eaa1ca4af8353b9f64.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule77ae533b2f544526aa8a6783329004d6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule808955860a1e4048847024479b23320f.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule86f1bce1661248fe84d4d50b505f2d46.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule95d30dbb9e8846f5b09e4dd7b3df19a8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule95e9ddd8486240a38ec88be6ac971b2b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule96ec65f825b545bf97ef208b6c09e42b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleaa2e1a46df1a448a90941a9fa32b5a9e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleab2447b71ea74a4683872c9d5b308943.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleb7cc3c4c85fc4b50b20e67aa917b30ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulecc7ab9a9d041402591a1eb7747b4b484.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleda1cbca5772a4f97b6a1d38a6666d14b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleda49fe7802574471ae3eafff3b10b4fe.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulef3a5b8c34f484600a0b07b63c5463df0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule0192b538687e707bb6baea2c80710d61.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule0192b53868b67048a8abdb26e744d0c2.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule0192b53876b170338f0f567f690419fe.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule019320fdbd2f73cda3637e30b0093866.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulee44e6782c64247b796b891cf25ae38f7.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`, "$.rule063b1ad4f7b2488a976ab21f670f2bbe.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule07fca9bbe46543d3ac345e41c3b38eff.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule160b35e830df4e2bb11608086b3f5100.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule1a70ce62d6884f76a08b9112ffa46829.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule237bde03a96740209c93a552bef26a15.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule275b92e8b48d4e048bd0b1d6acf59fca.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule27a96dd1f40d40dd9f092ff7910b0be1.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule2d5866c8047b4ffcaab41eeb21f54cbc.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule37a25eb8b9e44325a980aab691d89e12.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule3d03f77a584c4e3fa6537e772a777c8c.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule419a15f76e974efc82f246185aebb3c4.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule4d160d3746f2414aa35c6b48b10a74b9.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule625c13521246471da7e563ec37b93810.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule669cb8be3bc04b8b8e71ab54c1dede3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule767c3c153d2e44eaa1ca4af8353b9f64.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule77ae533b2f544526aa8a6783329004d6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule808955860a1e4048847024479b23320f.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule86f1bce1661248fe84d4d50b505f2d46.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule95d30dbb9e8846f5b09e4dd7b3df19a8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule95e9ddd8486240a38ec88be6ac971b2b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule96ec65f825b545bf97ef208b6c09e42b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleaa2e1a46df1a448a90941a9fa32b5a9e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleab2447b71ea74a4683872c9d5b308943.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleb7cc3c4c85fc4b50b20e67aa917b30ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulecc7ab9a9d041402591a1eb7747b4b484.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleda1cbca5772a4f97b6a1d38a6666d14b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleda49fe7802574471ae3eafff3b10b4fe.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulef3a5b8c34f484600a0b07b63c5463df0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule0192b538687e707bb6baea2c80710d61.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule0192b53868b67048a8abdb26e744d0c2.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule0192b53876b170338f0f567f690419fe.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule019320fdbd2f73cda3637e30b0093866.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulee44e6782c64247b796b891cf25ae38f7.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`, "$.rule063b1ad4f7b2488a976ab21f670f2bbe.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule07fca9bbe46543d3ac345e41c3b38eff.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule160b35e830df4e2bb11608086b3f5100.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule1a70ce62d6884f76a08b9112ffa46829.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule237bde03a96740209c93a552bef26a15.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule275b92e8b48d4e048bd0b1d6acf59fca.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule27a96dd1f40d40dd9f092ff7910b0be1.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule2d5866c8047b4ffcaab41eeb21f54cbc.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule37a25eb8b9e44325a980aab691d89e12.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule3d03f77a584c4e3fa6537e772a777c8c.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule419a15f76e974efc82f246185aebb3c4.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule4d160d3746f2414aa35c6b48b10a74b9.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule625c13521246471da7e563ec37b93810.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule669cb8be3bc04b8b8e71ab54c1dede3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule767c3c153d2e44eaa1ca4af8353b9f64.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule77ae533b2f544526aa8a6783329004d6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule808955860a1e4048847024479b23320f.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule86f1bce1661248fe84d4d50b505f2d46.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule95d30dbb9e8846f5b09e4dd7b3df19a8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule95e9ddd8486240a38ec88be6ac971b2b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule96ec65f825b545bf97ef208b6c09e42b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleaa2e1a46df1a448a90941a9fa32b5a9e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleab2447b71ea74a4683872c9d5b308943.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleb7cc3c4c85fc4b50b20e67aa917b30ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulecc7ab9a9d041402591a1eb7747b4b484.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleda1cbca5772a4f97b6a1d38a6666d14b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleda49fe7802574471ae3eafff3b10b4fe.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulef3a5b8c34f484600a0b07b63c5463df0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule0192b538687e707bb6baea2c80710d61.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule0192b53868b67048a8abdb26e744d0c2.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule0192b53876b170338f0f567f690419fe.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule019320fdbd2f73cda3637e30b0093866.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulee44e6782c64247b796b891cf25ae38f7.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`, "$.rule063b1ad4f7b2488a976ab21f670f2bbe.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule07fca9bbe46543d3ac345e41c3b38eff.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule160b35e830df4e2bb11608086b3f5100.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule1a70ce62d6884f76a08b9112ffa46829.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule237bde03a96740209c93a552bef26a15.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule275b92e8b48d4e048bd0b1d6acf59fca.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule27a96dd1f40d40dd9f092ff7910b0be1.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule2d5866c8047b4ffcaab41eeb21f54cbc.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule37a25eb8b9e44325a980aab691d89e12.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule3d03f77a584c4e3fa6537e772a777c8c.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule419a15f76e974efc82f246185aebb3c4.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule4d160d3746f2414aa35c6b48b10a74b9.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule625c13521246471da7e563ec37b93810.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule669cb8be3bc04b8b8e71ab54c1dede3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule767c3c153d2e44eaa1ca4af8353b9f64.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule77ae533b2f544526aa8a6783329004d6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule808955860a1e4048847024479b23320f.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule86f1bce1661248fe84d4d50b505f2d46.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule95d30dbb9e8846f5b09e4dd7b3df19a8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule95e9ddd8486240a38ec88be6ac971b2b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule96ec65f825b545bf97ef208b6c09e42b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleaa2e1a46df1a448a90941a9fa32b5a9e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleab2447b71ea74a4683872c9d5b308943.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleb7cc3c4c85fc4b50b20e67aa917b30ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulecc7ab9a9d041402591a1eb7747b4b484.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleda1cbca5772a4f97b6a1d38a6666d14b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleda49fe7802574471ae3eafff3b10b4fe.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulef3a5b8c34f484600a0b07b63c5463df0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule0192b538687e707bb6baea2c80710d61.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule0192b53868b67048a8abdb26e744d0c2.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule0192b53876b170338f0f567f690419fe.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule019320fdbd2f73cda3637e30b0093866.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulee44e6782c64247b796b891cf25ae38f7.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` <=> ?)))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"\x01’µ8öEr²ªÍW«a$LH"
  true
  b"\x1E¢Û¥µGM\x10¬@ÍL–-‹‹"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
10.83 ms
(9.20%) 		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` <=> ?))) GROUP BY `product.properties`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"\x01’µ8öEr²ªÍW«a$LH"
  true
  b"\x1E¢Û¥µGM\x10¬@ÍL–-‹‹"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
4.91 ms
(4.17%) 		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`, `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`.`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"\x05\e\x1DÀP{IÊ¡8’\x06Îi\eö"
  b"\x05§3Pû¥L$‹0æÎ_©÷x"
  b"\x06Bü4òñCûÑ║À\x07wmÌð"
  b"\x07\x02─\x11ƒ¯M╬üF\x06\x04¿Ýï\x17"
  b"\x08Ç┬ı%\x08I│É::µ╝\v▄╬"
  b"\t\x0E¤ÖáåK>ØÙ#\x16*y¸i"
  b"\tª›Cù\x07Fm §\x04L‚\x00¼ä"
  b"\t»VÄ\x07╝NÈç±█ìùÝn¡"
  b"\vò=µµ!Kž¯\x12k\rõÏÆq"
  b"\fxe¥W¨IæšI”„m9\x1EÜ"
  b"\f¬ÊGQ'JL„\x19u`ÚÞÔ\x00"
  b"\r\fó┤╗ì@0Æ|Z\rèc\v░"
  b"\rì\x1EÒÜÏLôêîÉ?<«\x7FÙ"
  b"\x0E\x17ÀݯñA\x04‘\x0EÓq‹#\x16·"
  b"\x0EoùQAØC­öÃõ│Î╔À▓"
  b"\x0FÏ7\¤[KÂ¥F–9Ò\x1FÎ\x11"
  b"\x0FÊrQS>@áò└│O▓nì│"
  b"\x10\x08c4§–J¾´xi\x03¾ØéY"
  b"\x12\x05|GØCG1½y\rƒ9║r%"
  b"\x13†¦ƒf†G>‚b§©Ñ4\x07É"
  b"\x14ñ\tÊ1^F°‰7!^òo\x7Fo"
  b"\x14òír™\x1ACŒ®)LfÜ­96"
  b"\x150:éñ§K¥¥V âf\î€"
  b"\x17Zþu$!HÅ╗Ø<}¿C8Ç"
  b"\x17░µ}╝\rB$ƒÉæ\x1A~2cø"
  b"\x19\x192Á—TA ˆ\x11q>á4®/"
  b"\x19–”¤\x15¶O3‘å…\eZ\x123\x05"
  b"\x1C Á¢8óL]¡\f¡’‹¨áæ"
  b"\x1Dç<]"{N\x13¾Pç•Ö6&ñ"
  b"\x1D¨;ÿ┼áB╚╝L:ì\x11\x0Eêa"
  b"\x1E]²ß:°Kÿ│´!«Ê\x11ü>"
  b"\x1EŸšÏ‡(@© %µ!ZÄd>"
  b"\x1F\x01Ø╩sÔLdü°ç1cU}§"
  b"!2\fÝϤG\x1D¼Ø\x15ûí{r_"
  b""îÖ'çìE$Ä,ìï╝\x06aM"
  b"&3™Ò¨+IO•n/Ø”_3Ó"
  b"&lµdG½@\x08·Â\x03×üã]¸"
  b"&©Ž\t@„Aʼ¬/\x02kžw"
  b"""
    '╦┘Ir±Füéö\t\f\x13\n
    ·\x16
    """
  b"(‘Ùh`%@¤²—Ì\x03óxêþ"
  b"+úÃ\x12¿\x14K=šêN\x01~›=\x7F"
  b",\v†Ç'òK¬ž?a¥ž\t¤\x07"
  b",©¬)üYA╝Â%ðètTÔ¾"
  b".H—Ø•qBg”Iy\x1AÊS#À"
  b"/ìPt¶&HQÄúvÙ*Rj·"
  b"2\x05oá9\x16E\r®Y-œáDÿ\x19"
  b"2ñb‹¡ØG\rŠ}=åk{§Û"
  b"6rLK^\x07@˪+N\x00▓åìÎ"
  b"7ò®JbŒM¹¦TÉý`5î\x12"
  b"8\x1D0\x17ÝoE=€Lb®k\t\x10Þ"
  b"9┘Ø\x02Û\x14LDÄ¥ìêù/╦Õ"
  b":\x1D%ÝîÛC{░\x1FØ^ëï¯Î"
  b":à3\v®ÖCñŽœêcr\x1AK²"
  b";1ሔº@¡¸Ž'HsW\x16\x00"
  b";3«¬íz@›šä$FÅ[f+"
  b";žÄ…\x11pJE§IãK¤§Š'"
  b";»\x7FÛRÞJ\x1C¹7ÝöÅâÄË"
  b"<íìO­%G`®─7\x1F°3â▓"
  b">ün§T‘BA†ë×\x03)¾²Ü"
  b"@\x08µq\x02║D\x14ƒ┼Ø»Æ@¯W"
  b"@■}¤ûâG¶ê9èóÅüöù"
  b"AEÀì:7Kû±\x0EEº˜&ý½"
  b"AWß8ÛdENˆ®µ,vJ(Þ"
  b"CØ\x03ò\x02ÓOû¹ã·nàyQ!"
  b"Cä\x06êñ%BX‡ w5$Mv]"
  b"CþÝ–u\x1EDv·°W\x00ëîÞõ"
  b"DeL\t\x04,FƹzVÛÿ3–\x00"
  b"E+%ÒΦI3¡äÞîÀ_Žî"
  b"E¥É"i\tMâŸè\x02ƒœ…Э"
  b"EݬvŒ5OR£YhûS~å\x14"
  b"F +¹e\vA…„%ߪ2bôä"
  b"G\x1C}a=þM„›Ó\x1D\x17²©Û£"
  b"GúHÌ\x1CrCv¹Å\v'³hX›"
  b"KFwÀ─!I«Øõ8¦\x01Ü¡="
  b"Kê/\x1C’8Aö…ÅV\x03©\x12b¸"
  b"NCNåÜ/Aú–‘\x17¦Ñ’Æ·"
  b"N┴ôoı·Nî░üd½^×ZF"
  b"O}‹©à~B$¹e\fÑŒÄôw"
  b"P\t░1Å█Fƒ»énØ˯û;"
  b"Pµþ@]+IØ©Ÿ\x14:œ­ ""
  b"U[Œ7àëJÕ“Þnm@Ëì\x0E"
  b"""
    U^Ç╦C╬J\n
    ëw\x16§»Ú┴É
    """
  b"U{\x06½~$Dx│ƒFÿV\x07É>"
  b"Uàˆ6Ýf@5©\t”i\`Âñ"
  b"Vªˆ©\x01ÉG¬›—ÿf¿ˆhÚ"
  b"V▒}K¸ýAÒÉ*ù+;9Jn"
  b"Wçô•â¡GÅŠ±E\x0EUÝŠÝ"
  b"""
    ^\n
    š\x05yèI\f’ˆ\x12ˆNnáî
    """
  b"^*ô‘\x18á@ò©6ßè\x03é :"
  b"`³M¾ÄˆL' ÐR‰cTñ…"
  b"bh\x04Ãj¡Km—gîÁß\x03›o"
  b"cº¸üÙ2C\x07ú¹║QøǾö"
  b"dæ\x12´2÷M6°'/šÌd@f"
  b"euô­¹\x06D ©n!ÙÖ›Œ*"
  b"eÃÑ _oKù¸Î®1\x10¬Ï#"
  b"fã┬W©\x07B8íÀúÊÅ╩ı\x1C"
  b"h³òŽI{Hœ‡ÖB¨¼\róp"
  b"j┐╝iM\x00K\x13Æk\x1AßÅ×èy"
  b"kj¡®’±Aü¬]tø\x06;$é"
  b"""
    l%*Šÿ4B\n
    ŸwNƒ‘?\f÷
    """
  b"lÃ\x0FßTOL­¤ó\x11×b-×V"
  b"lâ¡mÜäC)“s,A%\x1Al¶"
  b"mê~KüEJ_ñ╠û~sØó×"
  b"mêÅ'\x01\x1CLø¿6oKZ¢mÁ"
  b"mï¿ì^­@<‹›î\x04†Pû|"
  b"""
    n=/\n
    ×ÿM\x0Fóò¨\x13AmØý
    """
  b"n╠\x19▒PqGIÜø\v5Åç\x1F="
  b"vôçìsFA$é/E>ÏZÜÎ"
  b"x56ÑShBššqH\x19Î1{\x17"
  b"xb8ötƒOu’¯{°ù»†§"
  b"yû\x1E\x18ıòA■▒}¹¾▒Uüƒ"
  b"yí¹ålyIn¢¿ž‹³‘î\x07"
  b"zi‹ÓK”H)½\x1C^¬Þ:>Ê"
  b"|C\x16¡â/AV“KIs¶?N+"
  b"\x7Fì└¥+\x13Iߣ╬Rß▄`yø"
  b"ü&¨\vö\x02I.É┤*K\x0F\x10 ý"
  b"êër*┼0N\x17«╚╔¥vP©ì"
  b"Š2G€œ¡H\x14‡»\x01ÙT9¡c"
  b"Šuv$\x00QG^†Ù\x12?«rúS"
  b"‹´'¶ûdE¥¬ôç žsƒê"
  b"‹÷T\x1E·\x13D\r­ÇîNi`\V"
  b"ì¿Ý\x03r╬MÊ»ý\x01þ¬£Óu"
  b"Ž\x08Ø‘>›K~Œ\x00\x03Iw\x19‘\x08"
  b"’öÊ%X&G=¡îIœDý†\e"
  b"ôðÏ¥×\x12M\x07│Årþ_\x7F×Ü"
  b"ö░PðË\x18A)ÉIåÓó=øx"
  b"–ºþ\tËmB#³ß\x01^4\x7FÁÃ"
  b"ù-Û#▒\x13JuîØÔDü¨Z\x04"
  b"œK\x1E´b“C5‰éiº\x08×qŒ"
  b"žÊ¿ê{¹Hœ‹.4o\x7F\r}°"
  b" Rm\x0FÞ’@jº\¦TL“{\x07"
  b" Æ¬\x14w+Aº‘Öm\x1Cm" Ô"
  b"¡ÚfÓ\x02ôIÁ€\x15*\x0FªéxÖ"
  b"£»UÿÑtD\fªk6ªå\x1Cѹ"
  b"ú ü¹\x0ES@d×\x03!Ô±\x0FBí"
  b"ª\x17ýrL\x17CRØ┬n.¼\x0E§Ø"
  b"¨®\x12Žþ\x19MÔŠ¹þZt0«g"
  b"""
    ª\n
    û%>LD"°»Û‹âÂËF
    """
  b"½\x18ÏÖÉ>C[Á\x1E═Löå\r9"
  b"¯ÝYø"~G`¿\x12 =±-k'"
  b"░F«BÚ\x17FhüÛò~åmç╣"
  b"░gy¦┼I@ É\tû\x17í«▓ï"
  b"▒6\x1DG░*H\x11┤┼Ä¿ØD▀y"
  b"²ÜmªdÐB\x19€\r€°sÜh."
  b"³˜ËF<1Iš\x1CüOÀ=¾X"
  b"´°EÉ°\x05H’½¥8°1˜Æø"
  b"µ•§dAïBJ¸\x14ÎUJï©á"
  b"·«\x08ë\e\x12K_‚éÔ\x0Ea~ëí"
  b"¹\x1D§éúéM\x12¤„æÈ–}w!"
  b"╣ù:r?ÊB\x0E¬ÑÏ\v§╦çÅ"
  b"║ªZ'¹G@/üà â^}þQ"
  b"½ŽËšÛ\x16Gì´\v\t\x17ßC>Í"
  b"¢╠¢\x05/ñDºì╦æ╦Í\x11« "
  b"¥\x04îõ\v\fFÎìÚ¥Ö¢qÔg"
  b"¥=qTþÈBÈä<ıüÃ╝ý-"
  b"┐\x0F¦lGFHX촃ѮۃÚ"
  b"¿\x7F3¢\x1D\x04DªŽDÞýcÈ¡³"
  b"À>Š©!æEy•\x07íl\vP–B"
  b"ÀteãFNGÖ¢ö–Ù\x11N¿P"
  b"└áo5²ØA0║¼U¯>t═\x1F"
  b"Ç‹6f-JMhµ>°ð;„JJ"
  b"É4ËøpµFU¿ù\x07¥æ»Õ\e"
  b"╩Bü\x08T%Ba¢ù­÷&#\x15\x07"
  b"═,nÁiüFâçp7L\x00ù­:"
  b"Íaî\x13ÆkI+€þK\x1F~"‰ù"
  b"═vC╚Â\x13DôüÌ╗DG■█¢"
  b"ÍùcóÔñKîˆ\Ug´\x16›N"
  b"ÏœØZÇzF~‡pæC\x03Ê´ì"
  b"ϳ¬$ÿ\vJè­E\x11øyƒçŒ"
  b"Ñl$Ö`3KÓ©\x7F¼¢â\x11ü"
  b"ÓGô3\x14™AÕ’×çèW™ýE"
  b"È█ÓA\x13"HØ®\x1Dz"O]Ä┤"
  b"ı~Õ~·cNìÿÝ░F═:1\x04"
  b"ı÷¨*┐çB®ºÉ¨╗d.ë""
  b"ÖÜ… *KBÈ´\x07\x11Òh»È…"
  b"×ì\v~\x08hE퇄^ãCÊ«‰"
  b"ÏDõù\RCɺ\x1Aå\x0Eª¹╩O"
  b"Ù\x044|\\x07L\x02†_\x14\x03Ê%O«"
  b"Û\x13,„ ÞF*³¼É#¦[\x10Æ"
  b"Ü?ȃ\x14,A°™\x19 Ø®¿Õ™"
  b"Ý9ÆÀçÛNâµh£¡NÚý‡"
  b"Þ(¥tƒèDY·¯–/Þ˜î'"
  b"ßoÒÕÏÑK\x03‘U£µtµ²ª"
  b"ßàŒ»Ð€Oº©–9à\x05·K\e"
  b"à\x05Ûør¶L©š‚\x1E)[\x17Þ¨"
  b"àî“m«GD]¯Ñ°Å¨ëR«"
  b"""
    áXZ\f'\x7FO\n
    ¢; s)f'—
    """
  b"â¹ÎÔú\J´½y2‡–ËjÜ"
  b"ã\x0E:'Ñ|@,©Ê¾Þø[A‹"
  b"ê\x15¡s‹OLAƒO×%z‰\va"
  b"ë²\x12™æ‹F\x07ºkÕp\x08Ø—/"
  b"ì\x1A77±–@åŒüqI­K_ö"
  b"ý7&ÈÕNE-üµÄÒÖî+»"
  b"ýyÇ\x10ÉeN\t╝áN╦²iÏ\r"
  b"í\x10Ê—O±@祾‚+^\x7FF2"
  b"íÛ‰ã€mO1®»ée¯\x07ŠA"
  b"ðWr!U¦N\x0EŠë|\x07\x13|Sü"
  b"‗>>YèpB7ÁÉ\x7FÝùË6>"
  b"ò@0\x1C\x05³@\x11¡\x7FoeÔ4Aa"
  b"‗¥À£ÈhGÜäKû\x08ØuMZ"
  b"ô•­\x15(yI*¿ “nn®1Á"
  b"õ\x1Dñ\x1EOŸ@2…»ª¼'yÀ¡"
  b"öǸÏ\x12MGZ˜1GÝž\5Ø"
  b"÷¦OÝ\x15üF\x1Aécv ö╔\x17´"
  b"øÄ \x01êùOñ›–Fn·³“g"
  b"úL²yNÚL\x19ºŸÌý\f–´‰"
  b"û;»g^QJ\x10“Z•öGŒÜ£"
  b"üj-ÜÕ¶GK’\x16w›˜MŽ\x07"
  b"²½h´øKOÝ¿ÉÌqÛ¡\e\x00"
  b"""
    þ2,¼\n
    ëC׬Û\x12ª=³ŠÐ
    """
  b"ÿkMcCÒHn¦ ûÒÛÑô×"
  b"""
    ÿ™—‘ä\x04MF«\x12oˆ—\n
    lº
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
4.56 ms
(3.87%) 		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"\t\x0E¤ÖáåK>ØÙ#\x16*y¸i"
  b"\x0EoùQAØC­öÃõ│Î╔À▓"
  b"\x10\x08c4§–J¾´xi\x03¾ØéY"
  b"\x13E\x12Ø~ëNMªÏüÒx=¾U"
  b"\x1Dç<]"{N\x13¾Pç•Ö6&ñ"
  b";3«¬íz@›šä$FÅ[f+"
  b"Dú\x14„7¯NoŒ{ãŠ2y\x06"
  b"yû\x1E\x18ıòA■▒}¹¾▒Uüƒ"
  b"ù-Û#▒\x13JuîØÔDü¨Z\x04"
  b"È█ÓA\x13"HØ®\x1Dz"O]Ä┤"
  b"Þ•8ÿ/ÐHž¹œì\x03I¼Ú–"
  b"\vò=µµ!Kž¯\x12k\rõÏÆq"
  b"H?\x1Eƒ4NKͪZ\x03\x15*\x11HÇ"
  b"UkM\vÜ›Lè¶\x00“‰r…E\x1A"
  b"^*ô‘\x18á@ò©6ßè\x03é :"
  b"kj¡®’±Aü¬]tø\x06;$é"
  b"n╠\x19▒PqGIÜø\v5Åç\x1F="
  b":à3\v®ÖCñŽœêcr\x1AK²"
  b"žÊ¿ê{¹Hœ‹.4o\x7F\r}°"
  b"╩\t┼ùUÝLA╗ü▒╬¨┼С"
  b"═vC╚Â\x13DôüÌ╗DG■█¢"
  b"ϳ¬$ÿ\vJè­E\x11øyƒçŒ"
  b"ò@0\x1C\x05³@\x11¡\x7FoeÔ4Aa"
  b"B˜?»‰¾Oà£6:ÎU\x7FúU"
  b"uh©·³ðD█â"═\x0FõW\x06Ø"
  b"ú ü¹\x0ES@d×\x03!Ô±\x0FBí"
  b"³˜ËF<1Iš\x1CüOÀ=¾X"
  b"ÏDõù\RCɺ\x1Aå\x0Eª¹╩O"
  b"û;»g^QJ\x10“Z•öGŒÜ£"
  b"ÿ7ßôBSAGžpxX'Ä\x1A@"
  b"&lµdG½@\x08·Â\x03×üã]¸"
  b"·«\x08ë\e\x12K_‚éÔ\x0Ea~ëí"
  b"\fxe¥W¨IæšI”„m9\x1EÜ"
  b"mêÅ'\x01\x1CLø¿6oKZ¢mÁ"
  b"üj¬fË=CŬ?╩1;\x00D╩"
  b"Š—õù\x07GFß±ŽRèeüB„"
  b"ÏœØZÇzF~‡pæC\x03Ê´ì"
  b"ý7&ÈÕNE-üµÄÒÖî+»"
  b"ÿkMcCÒHn¦ ûÒÛÑô×"
  b"\r\fó┤╗ì@0Æ|Z\rèc\v░"
  b"\x0E\x17ÀݯñA\x04‘\x0EÓq‹#\x16·"
  b"wÏ–®¹\x15EA‰acWþõrÈ"
  b"ö░PðË\x18A)ÉIåÓó=øx"
  b"\fÔül\x12¾HqŸtÜT̶`ô"
  b"\rì\x1EÒÜÏLôêîÉ?<«\x7FÙ"
  b"+úÃ\x12¿\x14K=šêN\x01~›=\x7F"
  b":\x1D%ÝîÛC{░\x1FØ^ëï¯Î"
  b"Œý‹½2oIº½¶[$ŠK:±"
  b"¥=qTþÈBÈä<ıüÃ╝ý-"
  b"Þù┴{\x0FdL¨©cd~¤Ø┘,"
  b"ˆôIÅóÑN·´¨SæµS\fÑ"
  b"═,nÁiüFâçp7L\x00ù­:"
  b"úL²yNÚL\x19ºŸÌý\f–´‰"
  b"²½h´øKOÝ¿ÉÌqÛ¡\e\x00"
  b"\x05\e\x1DÀP{IÊ¡8’\x06Îi\eö"
  b"\r|>|®V@ε½6èžâJ÷"
  b"\x0FÏ7\¤[KÂ¥F–9Ò\x1FÎ\x11"
  b"\x19–”¤\x15¶O3‘å…\eZ\x123\x05"
  b"&3™Ò¨+IO•n/Ø”_3Ó"
  b"dc§È\x1CËB –\x05Ÿ¸Ðx\e\x14"
  b"rN÷è,†NR«ø•ý7©,|"
  b"ü&¨\vö\x02I.É┤*K\x0F\x10 ý"
  b"""
    ž\×ß\n
    °A³¬ê'\x7Fª\x06LD
    """
  b"\x07\x02─\x11ƒ¯M╬üF\x06\x04¿Ýï\x17"
  b"\x1FÂ0vû\fJ_«\x1CdËÁø!_"
  b"lÃ\x0FßTOL­¤ó\x11×b-×V"
  b"""
    \x7Fì÷Ks·N\n
    ï³▄ã@[åÕ
    """
  b"░gy¦┼I@ É\tû\x17í«▓ï"
  b"""
    áXZ\f'\x7FO\n
    ¢; s)f'—
    """
  b"KFwÀ─!I«Øõ8¦\x01Ü¡="
  b"ú±*ñu¶FðÆ╩D░lÞôÉ"
  b"""
    ª\n
    û%>LD"°»Û‹âÂËF
    """
  b"\x1EÔ$GÇ\x0FJCž°;}\x05x95"
  b"/ìPt¶&HQÄúvÙ*Rj·"
  b"CþÝ–u\x1EDv·°W\x00ëîÞõ"
  b" Æ¬\x14w+Aº‘Öm\x1Cm" Ô"
  b"░F«BÚ\x17FhüÛò~åmç╣"
  b"öǸÏ\x12MGZ˜1GÝž\5Ø"
  b";»\x7FÛRÞJ\x1C¹7ÝöÅâÄË"
  b"""
    n=/\n
    ×ÿM\x0Fóò¨\x13AmØý
    """
  b"└áu▀¬\x0FAëÉ\x04óÐTsØÆ"
  b"ýyÇ\x10ÉeN\t╝áN╦²iÏ\r"
  b";1ሔº@¡¸Ž'HsW\x16\x00"
  b"bh\x04Ãj¡Km—gîÁß\x03›o"
  b"\x7FqÍš«ÞDà£H®W\‚KF"
  b"+a-Û`qIØ‘N—欦¦û"
  b"<íìO­%G`®─7\x1F°3â▓"
  b"eÃÑ _oKù¸Î®1\x10¬Ï#"
  b"k´à.2ŒN\f’Ò\x0E\x16#\x03\x7Fp"
  b"zi‹ÓK”H)½\x1C^¬Þ:>Ê"
  b"¨®\x12Žþ\x19MÔŠ¹þZt0«g"
  b"ê\x15¡s‹OLAƒO×%z‰\va"
  b"E+%ÒΦI3¡äÞîÀ_Žî"
  b"ãn\x0F\x03C‹Oµ”G”&Ç,\x05\v"
  b"éºþZ¨kAƒ‡±€DÀ*1/"
  b"\x14òír™\x1ACŒ®)LfÜ­96"
  b" Rm\x0FÞ’@jº\¦TL“{\x07"
  b"õ\x1Dñ\x1EOŸ@2…»ª¼'yÀ¡"
  b"\x150:éñ§K¥¥V âf\î€"
  b".H—Ø•qBg”Iy\x1AÊS#À"
  b"Ž\x08Ø‘>›K~Œ\x00\x03Iw\x19‘\x08"
  b"·└â\x13ıÞFãæ \x1EØ\x1AD²╬"
  b""îÖ'çìE$Ä,ìï╝\x06aM"
  b"6mär\ÞEt¹µ?-x³Ø°"
  b"e>ÆÄÅ(AÛ©ÏEó+▄v®"
  b"┘JR-\x0Eh@¥ó\x1479ìdei"
  b"ãtËÇ%tD¢¢â·<Ør\x1E="
  b"""
    l%*Šÿ4B\n
    ŸwNƒ‘?\f÷
    """
  b"ÖÜ… *KBÈ´\x07\x11Òh»È…"
  b"÷¦OÝ\x15üF\x1Aécv ö╔\x17´"
  b"\t´céò«Ežœ¡T!$¼Æ\x05"
  b",\v†Ç'òK¬ž?a¥ž\t¤\x07"
  b"œK\x1E´b“C5‰éiº\x08×qŒ"
  b"¤Þ\x16B³bGR™\x15K\œüm%"
  b"íÛ‰ã€mO1®»ée¯\x07ŠA"
  b"¨\x12─_ø‗LRáZ\x1Fa\x0EØgù"
  b"""
    /þèÉ~\tHÏ”\n
    ömÔdK)
    """
  b"\x0FÊrQS>@áò└│O▓nì│"
  b"1\fÓ\x19Áù@\x14ž9³Oïû}ì"
  b"8\x1D0\x17ÝoE=€Lb®k\t\x10Þ"
  b";žÄ…\x11pJE§IãK¤§Š'"
  b"[êÂËiÆBݽo”\x11F\tZ-"
  b"¢╠¢\x05/ñDºì╦æ╦Í\x11« "
  b"§Aæ¢└üCÌúmı█╠SJ¥"
  b"\x14m²˜)—L˜ˆcŽn `/†"
  b"!ñžÕöˆHʤFfß3\x03\tG"
  b"euô­¹\x06D ©n!ÙÖ›Œ*"
  b"Ô\x15#¶ì¶Eàä├a zØ▀¿"
  b"\x05§3Pû¥L$‹0æÎ_©÷x"
  b"Ls»j└-Hôü\x1F¿\ƒ-╗¥"
  b"j\x16CTƒKDpœœIŒÃqk²"
  b"Å─0┤\x05¡BiòÎå│N■ÓM"
  b"\x08Ç┬ı%\x08I│É::µ╝\v▄╬"
  b"""
    EžZŠB\n
    Oy™ÊËuH:ÙÀ
    """
  b"E¥É"i\tMâŸè\x02ƒœ…Э"
  b"NCNåÜ/Aú–‘\x17¦Ñ’Æ·"
  b"ÆïcÊÁ\x03@\x05┐\x01çü├ø\x1F$"
  b"Íaî\x13ÆkI+€þK\x1F~"‰ù"
  b"ð³Zš¦ÙH1ƒ0¤ƒ\v;Cš"
  b"!IÂ\Ù“A\x1A€çiÀ2\x7Fg\x04"
  b"""
    U^Ç╦C╬J\n
    ëw\x16§»Ú┴É
    """
  b"V▒}K¸ýAÒÉ*ù+;9Jn"
  b"îK\x12b'fE3▒oü»│±î\t"
  b"¾7½Œ ?LØ¢½h¾ðky["
  b"└áo5²ØA0║¼U¯>t═\x1F"
  b"vôçìsFA$é/E>ÏZÜÎ"
  b"‗¥À£ÈhGÜäKû\x08ØuMZ"
  b"\x19\x192Á—TA ˆ\x11q>á4®/"
  b"øáÜf\t(O@¥\x03½ì\x12£q{"
  b"0–Bb{…Gi¨6iœ4Yžl"
  b"S\x03hV6BO÷›Ï‘12\x0FA\x0F"
  b"@Ï\x07,ðñO¹µ1\x00­o£¨ö"
  b"ôðÏ¥×\x12M\x07│Årþ_\x7F×Ü"
  b"˜]\â¢>K\x13›A\x03ïsð\x10l"
  b"Ìáó\x17‘“B1³9 ­‚\x07P\x02"
  b"(‘Ùh`%@¤²—Ì\x03óxêþ"
  b"GúHÌ\x1CrCv¹Å\v'³hX›"
  b"ºšñ\x10™6Iúˆå¦Öa2AQ"
  b"""
    þ2,¼\n
    ëC׬Û\x12ª=³ŠÐ
    """
  b"j┐╝iM\x00K\x13Æk\x1AßÅ×èy"
  b"±Eë\x19EGFÞ£\x16Ù­§MÅr"
  b"¶y„'‹\x00Næ¾\x0Eº:.mÜJ"
  b"îM>€[`G‹ŒÑ¡"Õ•d˜"
  b"8o îúLLÃÅÌÏæýèëü"
  b"ô┤çL¼\x02KÈÉ‗ïô#ÊÄ~"
  b"à\x05Ûør¶L©š‚\x1E)[\x17Þ¨"
  b"O}‹©à~B$¹e\fÑŒÄôw"
  b"mï¿ì^­@<‹›î\x04†Pû|"
  b"ª\x17ýrL\x17CRØ┬n.¼\x0E§Ø"
  b"Ê+qÛ•QI¸—Z˜2°à\t{"
  b"ðWr!U¦N\x0EŠë|\x07\x13|Sü"
  b"øÄ \x01êùOñ›–Fn·³“g"
  b"6rLK^\x07@˪+N\x00▓åìÎ"
  b"!2\fÝϤG\x1D¼Ø\x15ûí{r_"
  b"ÎS¸}\x11qK½ˆ9\x17\x12ÙÁ©Í"
  b"Cmƒ\v"õBí£Š0<0ÝäÉ"
  b"x´ÄrΫHK╗üW\x11+R_+"
  b"\x7Fì└¥+\x13Iߣ╬Rß▄`yø"
  b"Û\x13,„ ÞF*³¼É#¦[\x10Æ"
  b"yÝ*x•mDµ£…Bx6W¥›"
  b"P\t░1Å█Fƒ»énØ˯û;"
  b"░=§Þ®¢O╝ÂÉ×ÏK\eø¡"
  b"²ÜmªdÐB\x19€\r€°sÜh."
  b"h³òŽI{Hœ‡ÖB¨¼\róp"
  b"šûcï\x07ÓOc¬DFÍc©AÄ"
  b"¬.I~_MLì¾¢þC2L$œ"
  b"¥\x04îõ\v\fFÎìÚ¥Ö¢qÔg"
  b"N┴ôoı·Nî░üd½^×ZF"
  b"mê~KüEJ_ñ╠û~sØó×"
  b"ô•­\x15(yI*¿ “nn®1Á"
  b"\f¬ÊGQ'JL„\x19u`ÚÞÔ\x00"
  b"'ÕZ6┴╩Es▓ÜÕ£¬ìzV"
  b"@\x08µq\x02║D\x14ƒ┼Ø»Æ@¯W"
  b"AEÀì:7Kû±\x0EEº˜&ý½"
  b"U[Œ7àëJÕ“Þnm@Ëì\x0E"
  b"ü\x1CÞà\x0F×LÞÀ3\x1C[\x11tH2"
  b"Š2G€œ¡H\x14‡»\x01ÙT9¡c"
  b"ÀteãFNGÖ¢ö–Ù\x11N¿P"
  b"Wçô•â¡GÅŠ±E\x0EUÝŠÝ"
  b"§õS\x00Ó.M1ü¶ └ø:4\x1A"
  b"\x10§‚oBeEÀ´\x06nš¯©fS"
  b"\x07S±al²DÀÅÜîJrq╠╔"
  b"DÄS:îÛIÕÄŹñ\x1FB&═"
  b"KÑ‘ìü\x16J—š¦\ÞÌ>Ñ "
  b"├¹╣ÆyæNÝí\x19├Êo■Éä"
  b"1[X¢¡XCƒ–\x1Fã{\x07§\t¡"
  b"Pyè\x1AÅ\x17K­˜/\x1E\x16WÂøM"
  b"\x13†¦ƒf†G>‚b§©Ñ4\x07É"
  b"\x1EŸšÏ‡(@© %µ!ZÄd>"
  b"ƒé\x10\x0F9úFQó½╗Æéy¶Å"
  b"É»\x1Fž[¡I\x06µåhø\x19bÃ4"
  b"\x1F\x01Ø╩sÔLdü°ç1cU}§"
  b"F +¹e\vA…„%ߪ2bôä"
  b"cº¸üÙ2C\x07ú¹║QøǾö"
  b"¨Š¤ßdrFT¥Þ!'ÙIÁ¬"
  b"ÓGô3\x14™AÕ’×çèW™ýE"
  b"\x18©\x0F\x0EUCCî”ØÍÛ1\x16ãx"
  b"2\x05oá9\x16E\r®Y-œáDÿ\x19"
  b".¹zæÅ#HÖš.æ“\x18–Ï¥"
  b"\× \x04¦îL®›$°–áVÏ\x1A"
  b"ÖÉ\r½×aGâî!(s\x00{¤Ø"
  b"pú¢;î¶N½„wógžk­t"
  b"|C\x16¡â/AV“KIs¶?N+"
  b"¿\x7F3¢\x1D\x04DªŽDÞýcÈ¡³"
  b"Pµþ@]+IØ©Ÿ\x14:œ­ ""
  b"µ•§dAïBJ¸\x14ÎUJï©á"
  b"åbqv¡ŠJч7aë6¾¶ä"
  b"""
    '╦┘Ir±Füéö\t\f\x13\n
    ·\x16
    """
  b"2ñb‹¡ØG\rŠ}=åk{§Û"
  b"™øŸ-~fMº¹\vl`/<—È"
  b"╣ù:r?ÊB\x0E¬ÑÏ\v§╦çÅ"
  b"À>Š©!æEy•\x07íl\vP–B"
  b"\vä~\x16n¤OFžŸô\x01Ž\eÁ’"
  b"║ªZ'¹G@/üà â^}þQ"
  b"ßoÒÕÏÑK\x03‘U£µtµ²ª"
  b"N2êQWõE\x01˜n¢\x14áRéÚ"
  b"^ªw\rÝ»M+•Ù%t¥\t*+"
  b"êër*┼0N\x17«╚╔¥vP©ì"
  b"ê╣@eVñI║ÜüÝ╚#Å¢▄"
  b"‹´'¶ûdE¥¬ôç žsƒê"
  b"\t»VÄ\x07╝NÈç±█ìùÝn¡"
  b"\x14ñ\tÊ1^F°‰7!^òo\x7Fo"
  b"ë²\x12™æ‹F\x07ºkÕp\x08Ø—/"
  b"‗>>YèpB7ÁÉ\x7FÝùË6>"
  b"&©Ž\t@„Aʼ¬/\x02kžw"
  b"▒6\x1DG░*H\x11┤┼Ä¿ØD▀y"
  b"Ù\x044|\\x07L\x02†_\x14\x03Ê%O«"
  b"\tª›Cù\x07Fm §\x04L‚\x00¼ä"
  b"Cä\x06êñ%BX‡ w5$Mv]"
  b"ì¿Ý\x03r╬MÊ»ý\x01þ¬£Óu"
  b"▓║¼─P¢J┬ä░│¨ÅHtÓ"
  b"""
    æ\n
    ä\x06²ÖFt…®\x03vh¿V&
    """
  b"ì\x1A77±–@åŒüqI­K_ö"
  b"x56ÑShBššqH\x19Î1{\x17"
  b"´°EÉ°\x05H’½¥8°1˜Æø"
  b"³t¦,Ñ»O\x00ö6'üßËÙn"
  b"\x1DT¢ýÝÿJk¡\x13i£ØÕ\x1E\x12"
  b"\x1D¨;ÿ┼áB╚╝L:ì\x11\x0Eêa"
  b"<‘ºŠq±K(ŸžÚë‰ú)ú"
  b">ün§T‘BA†ë×\x03)¾²Ü"
  b".\x17P·~]A5“ñàÔ`Û83"
  b":~a\ÍõJÚ±e|EÍ\x03§g"
  b">ƒ7PEÉITÂñt!╬▄ÒÂ"
  b"ı÷¨*┐çB®ºÉ¨╗d.ë""
  b"Ü?ȃ\x14,A°™\x19 Ø®¿Õ™"
  b"\x06Bü4òñCûÑ║À\x07wmÌð"
  b"jšx{!ÝC«´>\x00ÁºpZf"
  b"l|&[Y|D€†ÑHIŸÄª{"
  b"ÅÙh╗$ÐLÜ┐¿d=³v\e5"
  b"5\x19´ºhâFvÆÍ\x13┐¯ìo\x15"
  b"Kê/\x1C’8Aö…ÅV\x03©\x12b¸"
  b"šËd+öCJW¨%-\x18bl e"
  b"¨Õ\fpt›EÔ´\eCWób¬¥"
  b"ÛÈ@\x02àôBë³'<e\x03˜š‹"
  b"ÓgkÆ\x04\fN\e║Øn\;F ×"
  b"5ÒFrGW@U®¯ù4[L#Ô"
  b"½\x18ÏÖÉ>C[Á\x1E═Löå\r9"
  b"AWß8ÛdENˆ®µ,vJ(Þ"
  b"\x1C Á¢8óL]¡\f¡’‹¨áæ"
  b"Ûe\etu§EZü╬\x7F9XÒFÝ"
  b"\x12\x05|GØCG1½y\rƒ9║r%"
  b"xb8ötƒOu’¯{°ù»†§"
  b"Ñl$Ö`3KÓ©\x7F¼¢â\x11ü"
  b"ã\x0E:'Ñ|@,©Ê¾Þø[A‹"
  b"`³M¾ÄˆL' ÐR‰cTñ…"
  b"Ç‹6f-JMhµ>°ð;„JJ"
  b"0Éÿ¶\x1CYAÿé"\x01fpQ│4"
  b"@■}¤ûâG¶ê9èóÅüöù"
  b" Ÿ"°’‹C¹š;üŠ•†%c"
  b"\x1E]²ß:°Kÿ│´!«Ê\x11ü>"
  b"G\x1C}a=þM„›Ó\x1D\x17²©Û£"
  b"½ŽËšÛ\x16Gì´\v\t\x17ßC>Í"
  b"÷\x10™³Û\rB°ƒ>îÁÁ\x00ª&"
  b"$ÝæI`MF¬º==dÚ"\f½"
  b"àî“m«GD]¯Ñ°Å¨ëR«"
  b"7ò®JbŒM¹¦TÉý`5î\x12"
  b"EݬvŒ5OR£YhûS~å\x14"
  b"dæ\x12´2÷M6°'/šÌd@f"
  b"ùY—©jFMs¨¾·Œ#p\x06m"
  b"iÞj¬ðÉEÁ–\x1Fi`ˆ-\x01Î"
  b"ßàŒ»Ð€Oº©–9à\x05·K\e"
  b"´l\x1AÑg:Aòà\x11┬%Ï\x08ؼ"
  b"Uàˆ6Ýf@5©\t”i\`Âñ"
  b"Þ(¥tƒèDY·¯–/Þ˜î'"
  b"""
    ÿ™—‘ä\x04MF«\x12oˆ—\n
    lº
    """
  b"í\x10Ê—O±@祾‚+^\x7FF2"
  b"å└ܺ\vüOñú╣ô G±┘>"
  b"­¦{&\x12CBy–sèäp¸!q"
  b"lâ¡mÜäC)“s,A%\x1Al¶"
  b"""
    ¿-nF”sE1¼€«9o\n
    ^t
    """
  b"–ºþ\tËmB#³ß\x01^4\x7FÁÃ"
  b"Þ+–#÷¾BÝŸiüû\^>æ"
  b" wa£;\x08CO€¨Ím\x0Eúl”"
  b"yí¹ålyIn¢¿ž‹³‘î\x07"
  b"¹\x1D§éúéM\x12¤„æÈ–}w!"
  b"╩Bü\x08T%Ba¢ù­÷&#\x15\x07"
  b"Ý9ÆÀçÛNâµh£¡NÚý‡"
  b"\x11#\x11mvdF\x1F§¹ÊÕ"&\x1Cì"
  b"\x17Zþu$!HÅ╗Ø<}¿C8Ç"
  b"SÅø(|;Lè‚`f‹/Údé"
  b"`0á#QDBHÉÙS(À±¥¤"
  b"{(╚îÕôN\x7FÅ­r:ò\x07└g"
  b"Šuv$\x00QG^†Ù\x12?«rúS"
  b"×ì\v~\x08hE퇄^ãCÊ«‰"
  b"¯ÝYø"~G`¿\x12 =±-k'"
  b"\x1D’ŘφB\x19Œ€>öi›”D"
  b"\x17░µ}╝\rB$ƒÉæ\x1A~2cø"
  b"\x18ìų£ÊJ›‚ó×ýÒ£hÑ"
  b"äOéöq\vCÕ¤º,·éMG>"
  b"ı~Õ~·cNìÿÝ░F═:1\x04"
  b"üj-ÜÕ¶GK’\x16w›˜MŽ\x07"
  b"\x04C¹üšêF6„ÂÀÔ¡—/@"
  b"Vªˆ©\x01ÉG¬›—ÿf¿ˆhÚ"
  b"""
    ^\n
    š\x05yèI\f’ˆ\x12ˆNnáî
    """
  b"É4ËøpµFU¿ù\x07¥æ»Õ\e"
  b"â¹ÎÔú\J´½y2‡–ËjÜ"
  b"CØ\x03ò\x02ÓOû¹ã·nàyQ!"
  b"r|┼╔~ÇCjÄÅb²eG┬é"
  b"}\x18s\x16þÛCa—.œ\\x13nCÎ"
  b"¹\x06µê¡\x02DУ—I²ë3bÞ"
  b"h+²~à±E(µ\vL®;~\x07÷"
  b"‹÷T\x1E·\x13D\r­ÇîNi`\V"
  b"""
    /¹lôÖ\x02F¤‹Ÿ\n
    ]zõ\x18w
    """
  b"Cüó>_CHq˜\x01qV\x7FÖn’"
  b"fã┬W©\x07B8íÀúÊÅ╩ı\x1C"
  b"’öÊ%X&G=¡îIœDý†\e"
  b",©¬)üYA╝Â%ðètTÔ¾"
  b"Q…„lÇÈH\eŠLÃëŽÍ­4"
  b"9&S‗à8M!ÇðíhI├\x04Å"
  b"9┘Ø\x02Û\x14LDÄ¥ìêù/╦Õ"
  b"£»UÿÑtD\fªk6ªå\x1Cѹ"
  b"┐\x0F¦lGFHX촃ѮۃÚ"
  b"†…Á¿(ÆG·–ûX/Ï\v\x19Ï"
  b"DeL\t\x04,FƹzVÛÿ3–\x00"
  b"U{\x06½~$Dx│ƒFÿV\x07É>"
  b"ÍùcóÔñKîˆ\Ug´\x16›N"
  b"¡ÚfÓ\x02ôIÁ€\x15*\x0FªéxÖ"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.39 ms
(3.73%) 		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"\t\x0E¤ÖáåK>ØÙ#\x16*y¸i"
  b"\x0EoùQAØC­öÃõ│Î╔À▓"
  b"\x10\x08c4§–J¾´xi\x03¾ØéY"
  b"\x13E\x12Ø~ëNMªÏüÒx=¾U"
  b"\x1Dç<]"{N\x13¾Pç•Ö6&ñ"
  b";3«¬íz@›šä$FÅ[f+"
  b"Dú\x14„7¯NoŒ{ãŠ2y\x06"
  b"yû\x1E\x18ıòA■▒}¹¾▒Uüƒ"
  b"ù-Û#▒\x13JuîØÔDü¨Z\x04"
  b"È█ÓA\x13"HØ®\x1Dz"O]Ä┤"
  b"Þ•8ÿ/ÐHž¹œì\x03I¼Ú–"
  b"\vò=µµ!Kž¯\x12k\rõÏÆq"
  b"H?\x1Eƒ4NKͪZ\x03\x15*\x11HÇ"
  b"UkM\vÜ›Lè¶\x00“‰r…E\x1A"
  b"^*ô‘\x18á@ò©6ßè\x03é :"
  b"kj¡®’±Aü¬]tø\x06;$é"
  b"n╠\x19▒PqGIÜø\v5Åç\x1F="
  b":à3\v®ÖCñŽœêcr\x1AK²"
  b"žÊ¿ê{¹Hœ‹.4o\x7F\r}°"
  b"╩\t┼ùUÝLA╗ü▒╬¨┼С"
  b"═vC╚Â\x13DôüÌ╗DG■█¢"
  b"ϳ¬$ÿ\vJè­E\x11øyƒçŒ"
  b"ò@0\x1C\x05³@\x11¡\x7FoeÔ4Aa"
  b"B˜?»‰¾Oà£6:ÎU\x7FúU"
  b"uh©·³ðD█â"═\x0FõW\x06Ø"
  b"ú ü¹\x0ES@d×\x03!Ô±\x0FBí"
  b"³˜ËF<1Iš\x1CüOÀ=¾X"
  b"ÏDõù\RCɺ\x1Aå\x0Eª¹╩O"
  b"û;»g^QJ\x10“Z•öGŒÜ£"
  b"ÿ7ßôBSAGžpxX'Ä\x1A@"
  b"&lµdG½@\x08·Â\x03×üã]¸"
  b"·«\x08ë\e\x12K_‚éÔ\x0Ea~ëí"
  b"\fxe¥W¨IæšI”„m9\x1EÜ"
  b"mêÅ'\x01\x1CLø¿6oKZ¢mÁ"
  b"üj¬fË=CŬ?╩1;\x00D╩"
  b"Š—õù\x07GFß±ŽRèeüB„"
  b"ÏœØZÇzF~‡pæC\x03Ê´ì"
  b"ý7&ÈÕNE-üµÄÒÖî+»"
  b"ÿkMcCÒHn¦ ûÒÛÑô×"
  b"\r\fó┤╗ì@0Æ|Z\rèc\v░"
  b"\x0E\x17ÀݯñA\x04‘\x0EÓq‹#\x16·"
  b"wÏ–®¹\x15EA‰acWþõrÈ"
  b"ö░PðË\x18A)ÉIåÓó=øx"
  b"\fÔül\x12¾HqŸtÜT̶`ô"
  b"\rì\x1EÒÜÏLôêîÉ?<«\x7FÙ"
  b"+úÃ\x12¿\x14K=šêN\x01~›=\x7F"
  b":\x1D%ÝîÛC{░\x1FØ^ëï¯Î"
  b"Œý‹½2oIº½¶[$ŠK:±"
  b"¥=qTþÈBÈä<ıüÃ╝ý-"
  b"Þù┴{\x0FdL¨©cd~¤Ø┘,"
  b"ˆôIÅóÑN·´¨SæµS\fÑ"
  b"═,nÁiüFâçp7L\x00ù­:"
  b"úL²yNÚL\x19ºŸÌý\f–´‰"
  b"²½h´øKOÝ¿ÉÌqÛ¡\e\x00"
  b"\x05\e\x1DÀP{IÊ¡8’\x06Îi\eö"
  b"\r|>|®V@ε½6èžâJ÷"
  b"\x0FÏ7\¤[KÂ¥F–9Ò\x1FÎ\x11"
  b"\x19–”¤\x15¶O3‘å…\eZ\x123\x05"
  b"&3™Ò¨+IO•n/Ø”_3Ó"
  b"dc§È\x1CËB –\x05Ÿ¸Ðx\e\x14"
  b"rN÷è,†NR«ø•ý7©,|"
  b"ü&¨\vö\x02I.É┤*K\x0F\x10 ý"
  b"""
    ž\×ß\n
    °A³¬ê'\x7Fª\x06LD
    """
  b"\x07\x02─\x11ƒ¯M╬üF\x06\x04¿Ýï\x17"
  b"\x1FÂ0vû\fJ_«\x1CdËÁø!_"
  b"lÃ\x0FßTOL­¤ó\x11×b-×V"
  b"""
    \x7Fì÷Ks·N\n
    ï³▄ã@[åÕ
    """
  b"░gy¦┼I@ É\tû\x17í«▓ï"
  b"""
    áXZ\f'\x7FO\n
    ¢; s)f'—
    """
  b"KFwÀ─!I«Øõ8¦\x01Ü¡="
  b"ú±*ñu¶FðÆ╩D░lÞôÉ"
  b"""
    ª\n
    û%>LD"°»Û‹âÂËF
    """
  b"\x1EÔ$GÇ\x0FJCž°;}\x05x95"
  b"/ìPt¶&HQÄúvÙ*Rj·"
  b"CþÝ–u\x1EDv·°W\x00ëîÞõ"
  b" Æ¬\x14w+Aº‘Öm\x1Cm" Ô"
  b"░F«BÚ\x17FhüÛò~åmç╣"
  b"öǸÏ\x12MGZ˜1GÝž\5Ø"
  b";»\x7FÛRÞJ\x1C¹7ÝöÅâÄË"
  b"""
    n=/\n
    ×ÿM\x0Fóò¨\x13AmØý
    """
  b"└áu▀¬\x0FAëÉ\x04óÐTsØÆ"
  b"ýyÇ\x10ÉeN\t╝áN╦²iÏ\r"
  b";1ሔº@¡¸Ž'HsW\x16\x00"
  b"bh\x04Ãj¡Km—gîÁß\x03›o"
  b"\x7FqÍš«ÞDà£H®W\‚KF"
  b"+a-Û`qIØ‘N—欦¦û"
  b"<íìO­%G`®─7\x1F°3â▓"
  b"eÃÑ _oKù¸Î®1\x10¬Ï#"
  b"k´à.2ŒN\f’Ò\x0E\x16#\x03\x7Fp"
  b"zi‹ÓK”H)½\x1C^¬Þ:>Ê"
  b"¨®\x12Žþ\x19MÔŠ¹þZt0«g"
  b"ê\x15¡s‹OLAƒO×%z‰\va"
  b"E+%ÒΦI3¡äÞîÀ_Žî"
  b"ãn\x0F\x03C‹Oµ”G”&Ç,\x05\v"
  b"éºþZ¨kAƒ‡±€DÀ*1/"
  b"\x14òír™\x1ACŒ®)LfÜ­96"
  b" Rm\x0FÞ’@jº\¦TL“{\x07"
  b"õ\x1Dñ\x1EOŸ@2…»ª¼'yÀ¡"
  b"\x150:éñ§K¥¥V âf\î€"
  b".H—Ø•qBg”Iy\x1AÊS#À"
  b"Ž\x08Ø‘>›K~Œ\x00\x03Iw\x19‘\x08"
  b"·└â\x13ıÞFãæ \x1EØ\x1AD²╬"
  b""îÖ'çìE$Ä,ìï╝\x06aM"
  b"6mär\ÞEt¹µ?-x³Ø°"
  b"e>ÆÄÅ(AÛ©ÏEó+▄v®"
  b"┘JR-\x0Eh@¥ó\x1479ìdei"
  b"ãtËÇ%tD¢¢â·<Ør\x1E="
  b"""
    l%*Šÿ4B\n
    ŸwNƒ‘?\f÷
    """
  b"ÖÜ… *KBÈ´\x07\x11Òh»È…"
  b"÷¦OÝ\x15üF\x1Aécv ö╔\x17´"
  b"\t´céò«Ežœ¡T!$¼Æ\x05"
  b",\v†Ç'òK¬ž?a¥ž\t¤\x07"
  b"œK\x1E´b“C5‰éiº\x08×qŒ"
  b"¤Þ\x16B³bGR™\x15K\œüm%"
  b"íÛ‰ã€mO1®»ée¯\x07ŠA"
  b"¨\x12─_ø‗LRáZ\x1Fa\x0EØgù"
  b"""
    /þèÉ~\tHÏ”\n
    ömÔdK)
    """
  b"\x0FÊrQS>@áò└│O▓nì│"
  b"1\fÓ\x19Áù@\x14ž9³Oïû}ì"
  b"8\x1D0\x17ÝoE=€Lb®k\t\x10Þ"
  b";žÄ…\x11pJE§IãK¤§Š'"
  b"[êÂËiÆBݽo”\x11F\tZ-"
  b"¢╠¢\x05/ñDºì╦æ╦Í\x11« "
  b"§Aæ¢└üCÌúmı█╠SJ¥"
  b"\x14m²˜)—L˜ˆcŽn `/†"
  b"!ñžÕöˆHʤFfß3\x03\tG"
  b"euô­¹\x06D ©n!ÙÖ›Œ*"
  b"Ô\x15#¶ì¶Eàä├a zØ▀¿"
  b"\x05§3Pû¥L$‹0æÎ_©÷x"
  b"Ls»j└-Hôü\x1F¿\ƒ-╗¥"
  b"j\x16CTƒKDpœœIŒÃqk²"
  b"Å─0┤\x05¡BiòÎå│N■ÓM"
  b"\x08Ç┬ı%\x08I│É::µ╝\v▄╬"
  b"""
    EžZŠB\n
    Oy™ÊËuH:ÙÀ
    """
  b"E¥É"i\tMâŸè\x02ƒœ…Э"
  b"NCNåÜ/Aú–‘\x17¦Ñ’Æ·"
  b"ÆïcÊÁ\x03@\x05┐\x01çü├ø\x1F$"
  b"Íaî\x13ÆkI+€þK\x1F~"‰ù"
  b"ð³Zš¦ÙH1ƒ0¤ƒ\v;Cš"
  b"!IÂ\Ù“A\x1A€çiÀ2\x7Fg\x04"
  b"""
    U^Ç╦C╬J\n
    ëw\x16§»Ú┴É
    """
  b"V▒}K¸ýAÒÉ*ù+;9Jn"
  b"îK\x12b'fE3▒oü»│±î\t"
  b"¾7½Œ ?LØ¢½h¾ðky["
  b"└áo5²ØA0║¼U¯>t═\x1F"
  b"vôçìsFA$é/E>ÏZÜÎ"
  b"‗¥À£ÈhGÜäKû\x08ØuMZ"
  b"\x19\x192Á—TA ˆ\x11q>á4®/"
  b"øáÜf\t(O@¥\x03½ì\x12£q{"
  b"0–Bb{…Gi¨6iœ4Yžl"
  b"S\x03hV6BO÷›Ï‘12\x0FA\x0F"
  b"@Ï\x07,ðñO¹µ1\x00­o£¨ö"
  b"ôðÏ¥×\x12M\x07│Årþ_\x7F×Ü"
  b"˜]\â¢>K\x13›A\x03ïsð\x10l"
  b"Ìáó\x17‘“B1³9 ­‚\x07P\x02"
  b"(‘Ùh`%@¤²—Ì\x03óxêþ"
  b"GúHÌ\x1CrCv¹Å\v'³hX›"
  b"ºšñ\x10™6Iúˆå¦Öa2AQ"
  b"""
    þ2,¼\n
    ëC׬Û\x12ª=³ŠÐ
    """
  b"j┐╝iM\x00K\x13Æk\x1AßÅ×èy"
  b"±Eë\x19EGFÞ£\x16Ù­§MÅr"
  b"¶y„'‹\x00Næ¾\x0Eº:.mÜJ"
  b"îM>€[`G‹ŒÑ¡"Õ•d˜"
  b"8o îúLLÃÅÌÏæýèëü"
  b"ô┤çL¼\x02KÈÉ‗ïô#ÊÄ~"
  b"à\x05Ûør¶L©š‚\x1E)[\x17Þ¨"
  b"O}‹©à~B$¹e\fÑŒÄôw"
  b"mï¿ì^­@<‹›î\x04†Pû|"
  b"ª\x17ýrL\x17CRØ┬n.¼\x0E§Ø"
  b"Ê+qÛ•QI¸—Z˜2°à\t{"
  b"ðWr!U¦N\x0EŠë|\x07\x13|Sü"
  b"øÄ \x01êùOñ›–Fn·³“g"
  b"6rLK^\x07@˪+N\x00▓åìÎ"
  b"!2\fÝϤG\x1D¼Ø\x15ûí{r_"
  b"ÎS¸}\x11qK½ˆ9\x17\x12ÙÁ©Í"
  b"Cmƒ\v"õBí£Š0<0ÝäÉ"
  b"x´ÄrΫHK╗üW\x11+R_+"
  b"\x7Fì└¥+\x13Iߣ╬Rß▄`yø"
  b"Û\x13,„ ÞF*³¼É#¦[\x10Æ"
  b"yÝ*x•mDµ£…Bx6W¥›"
  b"P\t░1Å█Fƒ»énØ˯û;"
  b"░=§Þ®¢O╝ÂÉ×ÏK\eø¡"
  b"²ÜmªdÐB\x19€\r€°sÜh."
  b"h³òŽI{Hœ‡ÖB¨¼\róp"
  b"šûcï\x07ÓOc¬DFÍc©AÄ"
  b"¬.I~_MLì¾¢þC2L$œ"
  b"¥\x04îõ\v\fFÎìÚ¥Ö¢qÔg"
  b"N┴ôoı·Nî░üd½^×ZF"
  b"mê~KüEJ_ñ╠û~sØó×"
  b"ô•­\x15(yI*¿ “nn®1Á"
  b"\f¬ÊGQ'JL„\x19u`ÚÞÔ\x00"
  b"'ÕZ6┴╩Es▓ÜÕ£¬ìzV"
  b"@\x08µq\x02║D\x14ƒ┼Ø»Æ@¯W"
  b"AEÀì:7Kû±\x0EEº˜&ý½"
  b"U[Œ7àëJÕ“Þnm@Ëì\x0E"
  b"ü\x1CÞà\x0F×LÞÀ3\x1C[\x11tH2"
  b"Š2G€œ¡H\x14‡»\x01ÙT9¡c"
  b"ÀteãFNGÖ¢ö–Ù\x11N¿P"
  b"Wçô•â¡GÅŠ±E\x0EUÝŠÝ"
  b"§õS\x00Ó.M1ü¶ └ø:4\x1A"
  b"\x10§‚oBeEÀ´\x06nš¯©fS"
  b"\x07S±al²DÀÅÜîJrq╠╔"
  b"DÄS:îÛIÕÄŹñ\x1FB&═"
  b"KÑ‘ìü\x16J—š¦\ÞÌ>Ñ "
  b"├¹╣ÆyæNÝí\x19├Êo■Éä"
  b"1[X¢¡XCƒ–\x1Fã{\x07§\t¡"
  b"Pyè\x1AÅ\x17K­˜/\x1E\x16WÂøM"
  b"\x13†¦ƒf†G>‚b§©Ñ4\x07É"
  b"\x1EŸšÏ‡(@© %µ!ZÄd>"
  b"ƒé\x10\x0F9úFQó½╗Æéy¶Å"
  b"É»\x1Fž[¡I\x06µåhø\x19bÃ4"
  b"\x1F\x01Ø╩sÔLdü°ç1cU}§"
  b"F +¹e\vA…„%ߪ2bôä"
  b"cº¸üÙ2C\x07ú¹║QøǾö"
  b"¨Š¤ßdrFT¥Þ!'ÙIÁ¬"
  b"ÓGô3\x14™AÕ’×çèW™ýE"
  b"\x18©\x0F\x0EUCCî”ØÍÛ1\x16ãx"
  b"2\x05oá9\x16E\r®Y-œáDÿ\x19"
  b".¹zæÅ#HÖš.æ“\x18–Ï¥"
  b"\× \x04¦îL®›$°–áVÏ\x1A"
  b"ÖÉ\r½×aGâî!(s\x00{¤Ø"
  b"pú¢;î¶N½„wógžk­t"
  b"|C\x16¡â/AV“KIs¶?N+"
  b"¿\x7F3¢\x1D\x04DªŽDÞýcÈ¡³"
  b"Pµþ@]+IØ©Ÿ\x14:œ­ ""
  b"µ•§dAïBJ¸\x14ÎUJï©á"
  b"åbqv¡ŠJч7aë6¾¶ä"
  b"""
    '╦┘Ir±Füéö\t\f\x13\n
    ·\x16
    """
  b"2ñb‹¡ØG\rŠ}=åk{§Û"
  b"™øŸ-~fMº¹\vl`/<—È"
  b"╣ù:r?ÊB\x0E¬ÑÏ\v§╦çÅ"
  b"À>Š©!æEy•\x07íl\vP–B"
  b"\vä~\x16n¤OFžŸô\x01Ž\eÁ’"
  b"║ªZ'¹G@/üà â^}þQ"
  b"ßoÒÕÏÑK\x03‘U£µtµ²ª"
  b"N2êQWõE\x01˜n¢\x14áRéÚ"
  b"^ªw\rÝ»M+•Ù%t¥\t*+"
  b"êër*┼0N\x17«╚╔¥vP©ì"
  b"ê╣@eVñI║ÜüÝ╚#Å¢▄"
  b"‹´'¶ûdE¥¬ôç žsƒê"
  b"\t»VÄ\x07╝NÈç±█ìùÝn¡"
  b"\x14ñ\tÊ1^F°‰7!^òo\x7Fo"
  b"ë²\x12™æ‹F\x07ºkÕp\x08Ø—/"
  b"‗>>YèpB7ÁÉ\x7FÝùË6>"
  b"&©Ž\t@„Aʼ¬/\x02kžw"
  b"▒6\x1DG░*H\x11┤┼Ä¿ØD▀y"
  b"Ù\x044|\\x07L\x02†_\x14\x03Ê%O«"
  b"\tª›Cù\x07Fm §\x04L‚\x00¼ä"
  b"Cä\x06êñ%BX‡ w5$Mv]"
  b"ì¿Ý\x03r╬MÊ»ý\x01þ¬£Óu"
  b"▓║¼─P¢J┬ä░│¨ÅHtÓ"
  b"""
    æ\n
    ä\x06²ÖFt…®\x03vh¿V&
    """
  b"ì\x1A77±–@åŒüqI­K_ö"
  b"x56ÑShBššqH\x19Î1{\x17"
  b"´°EÉ°\x05H’½¥8°1˜Æø"
  b"³t¦,Ñ»O\x00ö6'üßËÙn"
  b"\x1DT¢ýÝÿJk¡\x13i£ØÕ\x1E\x12"
  b"\x1D¨;ÿ┼áB╚╝L:ì\x11\x0Eêa"
  b"<‘ºŠq±K(ŸžÚë‰ú)ú"
  b">ün§T‘BA†ë×\x03)¾²Ü"
  b".\x17P·~]A5“ñàÔ`Û83"
  b":~a\ÍõJÚ±e|EÍ\x03§g"
  b">ƒ7PEÉITÂñt!╬▄ÒÂ"
  b"ı÷¨*┐çB®ºÉ¨╗d.ë""
  b"Ü?ȃ\x14,A°™\x19 Ø®¿Õ™"
  b"\x06Bü4òñCûÑ║À\x07wmÌð"
  b"jšx{!ÝC«´>\x00ÁºpZf"
  b"l|&[Y|D€†ÑHIŸÄª{"
  b"ÅÙh╗$ÐLÜ┐¿d=³v\e5"
  b"5\x19´ºhâFvÆÍ\x13┐¯ìo\x15"
  b"Kê/\x1C’8Aö…ÅV\x03©\x12b¸"
  b"šËd+öCJW¨%-\x18bl e"
  b"¨Õ\fpt›EÔ´\eCWób¬¥"
  b"ÛÈ@\x02àôBë³'<e\x03˜š‹"
  b"ÓgkÆ\x04\fN\e║Øn\;F ×"
  b"5ÒFrGW@U®¯ù4[L#Ô"
  b"½\x18ÏÖÉ>C[Á\x1E═Löå\r9"
  b"AWß8ÛdENˆ®µ,vJ(Þ"
  b"\x1C Á¢8óL]¡\f¡’‹¨áæ"
  b"Ûe\etu§EZü╬\x7F9XÒFÝ"
  b"\x12\x05|GØCG1½y\rƒ9║r%"
  b"xb8ötƒOu’¯{°ù»†§"
  b"Ñl$Ö`3KÓ©\x7F¼¢â\x11ü"
  b"ã\x0E:'Ñ|@,©Ê¾Þø[A‹"
  b"`³M¾ÄˆL' ÐR‰cTñ…"
  b"Ç‹6f-JMhµ>°ð;„JJ"
  b"0Éÿ¶\x1CYAÿé"\x01fpQ│4"
  b"@■}¤ûâG¶ê9èóÅüöù"
  b" Ÿ"°’‹C¹š;üŠ•†%c"
  b"\x1E]²ß:°Kÿ│´!«Ê\x11ü>"
  b"G\x1C}a=þM„›Ó\x1D\x17²©Û£"
  b"½ŽËšÛ\x16Gì´\v\t\x17ßC>Í"
  b"÷\x10™³Û\rB°ƒ>îÁÁ\x00ª&"
  b"$ÝæI`MF¬º==dÚ"\f½"
  b"àî“m«GD]¯Ñ°Å¨ëR«"
  b"7ò®JbŒM¹¦TÉý`5î\x12"
  b"EݬvŒ5OR£YhûS~å\x14"
  b"dæ\x12´2÷M6°'/šÌd@f"
  b"ùY—©jFMs¨¾·Œ#p\x06m"
  b"iÞj¬ðÉEÁ–\x1Fi`ˆ-\x01Î"
  b"ßàŒ»Ð€Oº©–9à\x05·K\e"
  b"´l\x1AÑg:Aòà\x11┬%Ï\x08ؼ"
  b"Uàˆ6Ýf@5©\t”i\`Âñ"
  b"Þ(¥tƒèDY·¯–/Þ˜î'"
  b"""
    ÿ™—‘ä\x04MF«\x12oˆ—\n
    lº
    """
  b"í\x10Ê—O±@祾‚+^\x7FF2"
  b"å└ܺ\vüOñú╣ô G±┘>"
  b"­¦{&\x12CBy–sèäp¸!q"
  b"lâ¡mÜäC)“s,A%\x1Al¶"
  b"""
    ¿-nF”sE1¼€«9o\n
    ^t
    """
  b"–ºþ\tËmB#³ß\x01^4\x7FÁÃ"
  b"Þ+–#÷¾BÝŸiüû\^>æ"
  b" wa£;\x08CO€¨Ím\x0Eúl”"
  b"yí¹ålyIn¢¿ž‹³‘î\x07"
  b"¹\x1D§éúéM\x12¤„æÈ–}w!"
  b"╩Bü\x08T%Ba¢ù­÷&#\x15\x07"
  b"Ý9ÆÀçÛNâµh£¡NÚý‡"
  b"\x11#\x11mvdF\x1F§¹ÊÕ"&\x1Cì"
  b"\x17Zþu$!HÅ╗Ø<}¿C8Ç"
  b"SÅø(|;Lè‚`f‹/Údé"
  b"`0á#QDBHÉÙS(À±¥¤"
  b"{(╚îÕôN\x7FÅ­r:ò\x07└g"
  b"Šuv$\x00QG^†Ù\x12?«rúS"
  b"×ì\v~\x08hE퇄^ãCÊ«‰"
  b"¯ÝYø"~G`¿\x12 =±-k'"
  b"\x1D’ŘφB\x19Œ€>öi›”D"
  b"\x17░µ}╝\rB$ƒÉæ\x1A~2cø"
  b"\x18ìų£ÊJ›‚ó×ýÒ£hÑ"
  b"äOéöq\vCÕ¤º,·éMG>"
  b"ı~Õ~·cNìÿÝ░F═:1\x04"
  b"üj-ÜÕ¶GK’\x16w›˜MŽ\x07"
  b"\x04C¹üšêF6„ÂÀÔ¡—/@"
  b"Vªˆ©\x01ÉG¬›—ÿf¿ˆhÚ"
  b"""
    ^\n
    š\x05yèI\f’ˆ\x12ˆNnáî
    """
  b"É4ËøpµFU¿ù\x07¥æ»Õ\e"
  b"â¹ÎÔú\J´½y2‡–ËjÜ"
  b"CØ\x03ò\x02ÓOû¹ã·nàyQ!"
  b"r|┼╔~ÇCjÄÅb²eG┬é"
  b"}\x18s\x16þÛCa—.œ\\x13nCÎ"
  b"¹\x06µê¡\x02DУ—I²ë3bÞ"
  b"h+²~à±E(µ\vL®;~\x07÷"
  b"‹÷T\x1E·\x13D\r­ÇîNi`\V"
  b"""
    /¹lôÖ\x02F¤‹Ÿ\n
    ]zõ\x18w
    """
  b"Cüó>_CHq˜\x01qV\x7FÖn’"
  b"fã┬W©\x07B8íÀúÊÅ╩ı\x1C"
  b"’öÊ%X&G=¡îIœDý†\e"
  b",©¬)üYA╝Â%ðètTÔ¾"
  b"Q…„lÇÈH\eŠLÃëŽÍ­4"
  b"9&S‗à8M!ÇðíhI├\x04Å"
  b"9┘Ø\x02Û\x14LDÄ¥ìêù/╦Õ"
  b"£»UÿÑtD\fªk6ªå\x1Cѹ"
  b"┐\x0F¦lGFHX촃ѮۃÚ"
  b"†…Á¿(ÆG·–ûX/Ï\v\x19Ï"
  b"DeL\t\x04,FƹzVÛÿ3–\x00"
  b"U{\x06½~$Dx│ƒFÿV\x07É>"
  b"ÍùcóÔñKîˆ\Ug´\x16›N"
  b"¡ÚfÓ\x02ôIÁ€\x15*\x0FªéxÖ"
]
View formatted query    View runnable query    Explain query    View query backtrace
3.89 ms
(3.31%) 		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` <=> ?))) GROUP BY `product.options`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"\x01’µ8öEr²ªÍW«a$LH"
  true
  b"\x1E¢Û¥µGM\x10¬@ÍL–-‹‹"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
2.78 ms
(2.36%) 		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"\x01’µ8öEr²ªÍW«a$LH"
  true
  b"\x1E¢Û¥µGM\x10¬@ÍL–-‹‹"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
1.80 ms
(1.53%) 		2 
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`checkout_gateway_url` as `app.checkoutGatewayUrl`, `app`.`source_type` as `app.sourceType`, `app`.`source_config` as `app.sourceConfig`, `app`.`self_managed` as `app.selfManaged`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, `app.translation.label` as `app.label`, `app.translation.description`, `app.translation.description` as `app.description`, `app.translation.privacyPolicyExtensions`, `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`, `app.translation.customFields`, `app.translation.customFields` as `app.customFields` FROM `app` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` LEFT JOIN (SELECT `app.translation`.`app_id`, `app.translation`.`label` as `app.translation.label`, `app.translation`.`description` as `app.translation.description`, `app.translation`.`privacy_policy_extensions` as `app.translation.privacyPolicyExtensions`, `app.translation`.`custom_fields` as `app.translation.customFields` FROM `app_translation` `app.translation` WHERE `app.translation`.`language_id` = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` WHERE `app`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01“?ÐËçrÅ€\x04ÜWË0Ë\x1E"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.74 ms
(1.48%) 		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 ((IFNULL(`product`.`shipping_free`, `product.parent`.`shipping_free`) = ?))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"\x01’µ8öEr²ªÍW«a$LH"
  true
  b"\x1E¢Û¥µGM\x10¬@ÍL–-‹‹"
  null
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
1.63 ms
(1.38%) 		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 (((IFNULL(`product`.`rating_average`, `product.parent`.`rating_average`) >= ?)))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"\x01’µ8öEr²ªÍW«a$LH"
  true
  b"\x1E¢Û¥µGM\x10¬@ÍL–-‹‹"
  null
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
1.01 ms
(0.86%) 		1 
# cart-rule-loader::load-rules::read
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"\x06;\x1AÔ÷²HŠ—j²\x1Fg\x0F+¾"
  b"\x07ü©»äeCÓ¬4^AóŽÿ"
  b"\x16\v5è0ßN+±\x16\x08\x08k?Q\x00"
  b"\x1ApÎbÖˆOv ‹‘\x12ÿ¤h)"
  b"#{Þ\x03©g@ œ“¥R¾òj\x15"
  b"'[ÆÞ┤ìN\x04ïð▒ͼ§ƒ╩"
  b"'©mÑô\r@ÝŸ\t/÷‘\v\vá"
  b"-XfÈ\x04{Oüª´\x1Eë!õL¼"
  b"7¢^¸¹äC%©€ª¶‘Øž\x12"
  b"=\x03÷zXLN?¦S~w*w|Œ"
  b"Aš\x15÷n—Nü‚òF\x18Zë³Ä"
  b"""
    M\x16\r7FòAJ£\kH±\n
    t¹
    """
  b"W«aÛ\t\x12Kê¸å\x01ž½ë·ä"
  b"b\\x13R\x12FG\x1D§åcì7¹8\x10"
  b"fœ¸¾;ÀK‹Žq«TÁÞÞ="
  b"v|<\x15=.Dê¡ÊJø5;Ÿd"
  b"w«S;/TE&¬ègâ2É\x04Í"
  b"xí^©Í)A¸š9âD\x02Z!Ž"
  b"""
    €‰U†\n
    \x1E@H„p$G›#2\x0F
    """
  b"†ñ¼áf\x12Hþ„ÔÕ\vP_-F"
  b"•Ó\r»žˆFõ°žM׳ß\x19¨"
  b"•éÝØHb@£ŽÈ‹æ¬—\e+"
  b"–ìeø%µE¿—ï ‹l\tä+"
  b"¬.\x1AF▀\x1ADèÉö\x1Aƒú+Z×"
  b"½$GÀ\x1EºJFâç,Ø[0ëC"
  b"·Ì<L…üKP²\x0Egª‘{0®"
  b"Ìz¹©ÐA@%‘¡ëwG´´„"
  b"Ú\x1C¼¥w*O—¶¡ÓŠffÑK"
  b"ÚIþx\x02WDq®>¯ÿ;\x10´þ"
  b"ó¥¸ÃOHF\x00 °{cÅF=ð"
  b"\x01’µ8h~p{¶ºê,€q\ra"
  b"\x01’µ8h¶pH¨«Û&çDÐÂ"
  b"\x01’µ8i)rS”ì50\f™€;"
  b"\x01ÆÁ8v▒p3Å\x0FV\x7Fi\x04\x19■"
  b"\x01’µ8i%ry£†Õ\x13³Ä-À"
  b"\x01’µ8i's€¼²uY NˆÑ"
  b"\x01ÆÁ8øÇq╠ñ<É{¶c4\x03"
  b"\x01“ ý½/sÍ£c~0°\t8f"
  b"äNg‚ÆBG·–¸‘Ï%®8÷"
  b"\x01ô\f6BÏv×Ø\x18ü\x12Î50\x00"
  b"\x01“\f8Cy}*‘ÿõ¨›‘#_"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.00 ms
(0.85%) 		2 
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
0.96 ms
(0.81%) 		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"\x06;\x1AÔ÷²HŠ—j²\x1Fg\x0F+¾"
  b"\x07ü©»äeCÓ¬4^AóŽÿ"
  b"\x16\v5è0ßN+±\x16\x08\x08k?Q\x00"
  b"\x1ApÎbÖˆOv ‹‘\x12ÿ¤h)"
  b"#{Þ\x03©g@ œ“¥R¾òj\x15"
  b"'[ÆÞ┤ìN\x04ïð▒ͼ§ƒ╩"
  b"'©mÑô\r@ÝŸ\t/÷‘\v\vá"
  b"-XfÈ\x04{Oüª´\x1Eë!õL¼"
  b"7¢^¸¹äC%©€ª¶‘Øž\x12"
  b"=\x03÷zXLN?¦S~w*w|Œ"
  b"Aš\x15÷n—Nü‚òF\x18Zë³Ä"
  b"""
    M\x16\r7FòAJ£\kH±\n
    t¹
    """
  b"b\\x13R\x12FG\x1D§åcì7¹8\x10"
  b"fœ¸¾;ÀK‹Žq«TÁÞÞ="
  b"v|<\x15=.Dê¡ÊJø5;Ÿd"
  b"w«S;/TE&¬ègâ2É\x04Í"
  b"""
    €‰U†\n
    \x1E@H„p$G›#2\x0F
    """
  b"†ñ¼áf\x12Hþ„ÔÕ\vP_-F"
  b"•Ó\r»žˆFõ°žM׳ß\x19¨"
  b"•éÝØHb@£ŽÈ‹æ¬—\e+"
  b"–ìeø%µE¿—ï ‹l\tä+"
  b"¬.\x1AF▀\x1ADèÉö\x1Aƒú+Z×"
  b"½$GÀ\x1EºJFâç,Ø[0ëC"
  b"·Ì<L…üKP²\x0Egª‘{0®"
  b"Ìz¹©ÐA@%‘¡ëwG´´„"
  b"Ú\x1C¼¥w*O—¶¡ÓŠffÑK"
  b"ÚIþx\x02WDq®>¯ÿ;\x10´þ"
  b"ó¥¸ÃOHF\x00 °{cÅF=ð"
  b"\x01’µ8h~p{¶ºê,€q\ra"
  b"\x01’µ8h¶pH¨«Û&çDÐÂ"
  b"\x01ÆÁ8v▒p3Å\x0FV\x7Fi\x04\x19■"
  b"\x01“ ý½/sÍ£c~0°\t8f"
  b"äNg‚ÆBG·–¸‘Ï%®8÷"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.91 ms
(0.77%) 		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"\x01’µ8öEr²ªÍW«a$LH"
  "widgets/cms/navigation/1ea2dba5b5474d10ac40cd4c962d8b8b/filter"
  "widgets/cms/navigation/1ea2dba5b5474d10ac40cd4c962d8b8b/filter/"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.85 ms
(0.73%) 		2 
# app-scripts::refresh::search-ids
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ?)
Parameters: 
[
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.82 ms
(0.70%) 		2 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.78 ms
(0.66%) 		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`, `product_manufacturer.translation.name` as `product_manufacturer.name`, `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`.`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"‘ÒÄCÜ`A³‚D–;=úrŸ"
  b"_O╔êIªN×¥┼y½|SÞÅ"
  b"\x10„€™¡T@ù«‘íe½'hÎ"
  b"XÁôϦ±Ct¾¢¯\x04_ŒMB"
  b"qx¦Ö“gHå¥t‡Íp¹ëS"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.77 ms
(0.65%) 		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ÆÁ8üÜpÊó($ªãÿ$¾"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.66 ms
(0.56%) 		2 
SELECT `script`.`id` as `script.id`, `script`.`script` as `script.script`, `script`.`hook` as `script.hook`, `script`.`name` as `script.name`, `script`.`active` as `script.active`, `script`.`app_id` as `script.appId`, `script`.`created_at` as `script.createdAt`, `script`.`updated_at` as `script.updatedAt` FROM `script` WHERE (`script`.`app_id` IN (?))
Parameters: 
[
  b"\x01“?ÐËçrÅ€\x04ÜWË0Ë\x1E"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.65 ms
(0.56%) 		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ÆÁ8üÜpÊó($ªãÿ$¾"
  b"\x01ÆÁ8üÜpÊó($ªÃ<¶}"
  b"\x01ÆÁ8üÜpÊó($ªÃ╔│¨"
  b"\x01ÆÁ8üÜpÊó($ª╚hhî"
  b"\x01ÆÁ8üÜpÊó($ª╔H4┼"
  b"\x01’µ8ƒÞq\r®tDzo²;Æ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.65 ms
(0.55%) 		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"\x1E¢Û¥µGM\x10¬@ÍL–-‹‹"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.63 ms
(0.54%) 		1 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"\x01’µ8öEr²ªÍW«a$LH"
  "FSfpSSBYXDjIQol4y8qItRpdF1xQqnXS"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.62 ms
(0.53%) 		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.59 ms
(0.50%) 		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.56 ms
(0.47%) 		1 
# cart-rule-loader::load-rules::search-ids
SELECT `rule`.`id` FROM `rule` WHERE (`rule`.`invalid` = ?) ORDER BY `rule`.`priority` DESC, `rule`.`id` ASC LIMIT 500
Parameters: 
[
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
0.55 ms
(0.47%) 		2 
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.50 ms
(0.42%) 		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.48 ms
(0.40%) 		1 
SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.44 ms
(0.38%) 		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"\x1E¢Û¥µGM\x10¬@ÍL–-‹‹"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.41 ms
(0.34%) 		1 
#cart-persister::load
            SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters: 
[
  "FSfpSSBYXDjIQol4y8qItRpdF1xQqnXS"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(0.33%) 		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"\x01’µ8öEr²ªÍW«a$LH"
  "/widgets/cms/navigation/1ea2dba5b5474d10ac40cd4c962d8b8b/filter"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.28%) 		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"\x01’µ8öEr²ªÍW«a$LH"
  b"\x01’µ8gIsúŸ’ÇM\x1F\x7Fa¡"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.28%) 		1 
DELETE FROM `cart` WHERE `token` = :token
Parameters: 
[
  "token" => "FSfpSSBYXDjIQol4y8qItRpdF1xQqnXS"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.18 ms
(0.15%) 		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

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.