GET https://tinbe.generationshop.dev/widgets/cms/navigation/8919cfec1b134954a3b45e934861ba4f/filter?only-aggregations=1&reduce-aggregations=1&slots=018dc5e5c3c771c4…

Response
200 OK
Browse referrer URL
IP
185.119.3.237
Profiled on
Token
f7ba91

Query Metrics

61 Database Queries
34 Different statements
270.57 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
70.13 ms
(25.92%) 		1 
# product-listing-route::loading::aggregation::price
SELECT MIN(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule526d6930b1dd49d5ba77f629a6a477f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleadc7f28258b64f9aa877d237b34088ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulec54c7c670e27454cb613c9d6d1e9e78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule6c9bee2e47084fe09edf500180c8e9ba.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule7e2febe0d564402da0eb0a0f425dfcb8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulea5b6366f102b41f7924cdaaf2b8bbf2e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleaec7d06af7734675a1ae0dd498a34e3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleca8324c3095543f6a69f923050786657.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulede2455bf8ca24b9a847c9e397e407269.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulef0c63ac906df419090fc07780145dd6b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018f51dc2dd875768a2eec716b420000.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018f51e2f49d7319b04105d4f9cdff56.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruled40cf9900bd049508b93b3e9c880f8f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule526d6930b1dd49d5ba77f629a6a477f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleadc7f28258b64f9aa877d237b34088ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulec54c7c670e27454cb613c9d6d1e9e78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule6c9bee2e47084fe09edf500180c8e9ba.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule7e2febe0d564402da0eb0a0f425dfcb8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulea5b6366f102b41f7924cdaaf2b8bbf2e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleaec7d06af7734675a1ae0dd498a34e3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleca8324c3095543f6a69f923050786657.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulede2455bf8ca24b9a847c9e397e407269.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulef0c63ac906df419090fc07780145dd6b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018f51dc2dd875768a2eec716b420000.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018f51e2f49d7319b04105d4f9cdff56.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruled40cf9900bd049508b93b3e9c880f8f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)))) as `price.min`, MAX(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule526d6930b1dd49d5ba77f629a6a477f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleadc7f28258b64f9aa877d237b34088ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulec54c7c670e27454cb613c9d6d1e9e78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule6c9bee2e47084fe09edf500180c8e9ba.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule7e2febe0d564402da0eb0a0f425dfcb8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulea5b6366f102b41f7924cdaaf2b8bbf2e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleaec7d06af7734675a1ae0dd498a34e3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleca8324c3095543f6a69f923050786657.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulede2455bf8ca24b9a847c9e397e407269.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulef0c63ac906df419090fc07780145dd6b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018f51dc2dd875768a2eec716b420000.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018f51e2f49d7319b04105d4f9cdff56.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruled40cf9900bd049508b93b3e9c880f8f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule526d6930b1dd49d5ba77f629a6a477f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleadc7f28258b64f9aa877d237b34088ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulec54c7c670e27454cb613c9d6d1e9e78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule6c9bee2e47084fe09edf500180c8e9ba.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule7e2febe0d564402da0eb0a0f425dfcb8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulea5b6366f102b41f7924cdaaf2b8bbf2e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleaec7d06af7734675a1ae0dd498a34e3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleca8324c3095543f6a69f923050786657.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulede2455bf8ca24b9a847c9e397e407269.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulef0c63ac906df419090fc07780145dd6b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018f51dc2dd875768a2eec716b420000.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018f51e2f49d7319b04105d4f9cdff56.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruled40cf9900bd049508b93b3e9c880f8f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)))) as `price.max` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND ((`product.manufacturer`.`id` = ?)) AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?)))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  true
  b"wí\x06¦¨¡Lë▓béÉ\x15îı\e"
  null
  true
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
44.52 ms
(16.45%) 		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_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.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 `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.manufacturer`.`id` = ?)) AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product.properties`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  true
  b"wí\x06¦¨¡Lë▓béÉ\x15îı\e"
  null
  true
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
30.03 ms
(11.10%) 		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_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.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 `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.manufacturer`.`id` = ?)) AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product.options`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  true
  b"wí\x06¦¨¡Lë▓béÉ\x15îı\e"
  null
  true
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
28.44 ms
(10.51%) 		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_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND ((`product.manufacturer`.`id` = ?)) AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) AND (((IFNULL(`product`.`rating_average`, `product.parent`.`rating_average`) >= ?)))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  true
  b"wí\x06¦¨¡Lë▓béÉ\x15îı\e"
  null
  true
  false
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
27.79 ms
(10.27%) 		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_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND ((`product.manufacturer`.`id` = ?)) AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`)
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  true
  b"wí\x06¦¨¡Lë▓béÉ\x15îı\e"
  null
  true
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
17.10 ms
(6.32%) 		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_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND ((`product.manufacturer`.`id` = ?)) AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) AND ((IFNULL(`product`.`shipping_free`, `product.parent`.`shipping_free`) = ?))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  true
  b"wí\x06¦¨¡Lë▓béÉ\x15îı\e"
  null
  true
  false
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
11.15 ms
(4.12%) 		6 
# app-scripts::refresh::read
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
8.17 ms
(3.02%) 		10 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  null
  "MolliePayments.config.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
5.00 ms
(1.85%) 		1 
# manufacturer-aggregation::read
SELECT `product_manufacturer`.`id` as `product_manufacturer.id`, `product_manufacturer`.`version_id` as `product_manufacturer.versionId`, `product_manufacturer`.`media_id` as `product_manufacturer.mediaId`, `product_manufacturer`.`link` as `product_manufacturer.link`, `product_manufacturer`.`created_at` as `product_manufacturer.createdAt`, `product_manufacturer`.`updated_at` as `product_manufacturer.updatedAt`, `product_manufacturer.translation.name`, COALESCE(`product_manufacturer.translation.name`,`product_manufacturer.translation.name`) as `product_manufacturer.name`, `product_manufacturer.translation.description`, COALESCE(`product_manufacturer.translation.description`,`product_manufacturer.translation.description`) as `product_manufacturer.description`, `product_manufacturer.translation.customFields`, COALESCE(`product_manufacturer.translation.customFields`,`product_manufacturer.translation.customFields`) as `product_manufacturer.customFields`, `product_manufacturer.translation.createdAt`, `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation.languageId`, `product_manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.product_manufacturer_id, `product_manufacturer.translation`.product_manufacturer_version_id, `product_manufacturer.translation`.name as `product_manufacturer.translation.name`, `product_manufacturer.translation`.description as `product_manufacturer.translation.description`, `product_manufacturer.translation`.custom_fields as `product_manufacturer.translation.customFields`, `product_manufacturer.translation`.created_at as `product_manufacturer.translation.createdAt`, `product_manufacturer.translation`.updated_at as `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation`.product_manufacturer_id as `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation`.language_id as `product_manufacturer.translation.languageId`, `product_manufacturer.translation`.product_manufacturer_version_id as `product_manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer_translation` `product_manufacturer.translation` WHERE `product_manufacturer.translation`.language_id = ?) `product_manufacturer.product_manufacturer_translation` ON `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product_manufacturer`.`id` AND `product_manufacturer.product_manufacturer_translation`.product_manufacturer_version_id = `product_manufacturer`.version_id WHERE (`product_manufacturer`.`version_id` = ?) AND (`product_manufacturer`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"wí\x06¦¨¡Lë▓béÉ\x15îı\e"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.32 ms
(1.60%) 		6 
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3.84 ms
(1.42%) 		2 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  "cfVgWPv6awGggi5PF2v8gc0sRyxxdrsD"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.51 ms
(0.93%) 		2 
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE ?
Parameters: 
[
  "payload"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.90 ms
(0.70%) 		1 
SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id`  LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id`  WHERE ((`country.salesChannels`.`id` = ?)) AND (`country`.`id` IN (?)) GROUP BY `country`.`id`
Parameters: 
[
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  b"CÕL P»L\x07Ÿ3|-'i’\x16"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.82 ms
(0.67%) 		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"‰\x19Ïì\e\x13IT£´^“HaºO"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.69 ms
(0.62%) 		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"\x0F•é{\x1D<G6·Rš)€Ü"S"
  b"èþVd|’CY«è^±ûø´a"
  b"úV}7ðæL¦—†Å)¯7éb"
  b"†‚íF;ÓL$”8à¡D\x05uD"
  b":äGô\x14‚OÕžV]<—‰ÈW"
  b"""
    ÊÀ+öAÿL\x12ëk│\n
    ╩ÉnÑ
    """
  b"""
    \x7Flƒ%æÛJ2«\\n
    ÊIßE\x13
    """
  b"ææ╝Ë\x19ºM¯Å\vßú¿¨öì"
  b"`êJî:ÍK‚Œòˆ²œ_mi"
  b"\x08▀┌■ß\x7FB╔░NÃtì┴­w"
  b"9Z¥LàKOD„Â4\kw\x14ý"
  b"»\x11›¥¶ÇNé­&íËë\x062\e"
  b"³\x00\x0E¦ðÌC½¬vûÜ\x00ÈäN"
  b"ÔÞ×+d½Hø¡ÍLéØoIµ"
  b"Õ¯ÿl\x11\x11G{ü├¥û*┴┤█"
  b"“\x08êõ÷\rIÓ»%h<G\rH‡"
  b"/Üi1×°O3½|Üý×eˆü"
  b"î1Ä\x1DÿZOéô÷\x07v ╝Øl"
  b"Ì\x13-¦lúDø–g1\x00i"
  b"b^îvÞ‡E£™¾µ 9Œ™¼"
  b"""
    <Cq\n
    &8MŒ¿Âæ.Ù®J\e
    """
  b",\x15u±$½@î£É|ؾþæ^"
  b"#Â[ËÎK¢¡÷ö`î]\x07ì"
  b"│╔ù ─]J#ìIRh\x18Æ\x13u"
  b"N—·Ò\rGN¬„‰\x7Fe4«è\x1A"
  b"Ì>┘s;ÔD­¥L\x13Ø`ÒS▄"
  b"\x17Û\x1C╦^0JÅûÅR£▓Õå\x18"
  b"""
    \n
    \x07║Æ+\x10CÈ┐´þ╚M^É\x0E
    """
  b"F'vûZÏ@s‹léqgÁl\x06"
  b"┐8Á£¨=GBë‗░ÅÜz­µ"
  b":÷¦âW\vDi°Ž\x18\x12XU€\x1E"
  b"…ù#O]×L3œrþX*Õ’Á"
  b"ƒ¼Þ\x07òÑET€[|vÚ|pD"
  b"oìmÈ┼\x1EKzÅÖM \x1A╗Qö"
  b"ž©’d 4GV®~ÈÔ\x1E\x14PG"
  b"ÞG\x16¤‰0F3¤÷œÉ£%<ì"
  b"­b¶î©4GPš ‘Ô~!\x18Ç"
  b"0Öü\x0E<uIÕ▒n{¢╚î `"
  b"\x1A\t\x19¥âÉMb£ª\r╠+\x07¯y"
  b"RD\x15,~ÞNºƒŠ‡JJþ_Á"
  b"Émè¹1gBɉͼH¯\x13Dñ"
  b"t¦Sß›·D\x17¯×)×\x17y\x7F0"
  b"mH¡O▓âF#úY÷"`¦\x1AÉ"
  b"""
    É\n
    ŸÎw¥IÖ¹øNtVå·\x7F
    """
  b"ÒZF$Ê\x1DJŽ‚³x°¼BÌ\x17"
  b"ñrâÐM×H$²«Þ±\x18ÑW\x1A"
  b"\x030{iü^Oô▓╬/¨­AéE"
  b"êF+ŒfÝ@S—¹\x05Lõ»¾ù"
  b"""
    Oe¬¼øøE<œ)½\x06\x16 \n
    ¿
    """
  b"¶A\x13*\x02ÕF\x11“…}C¯\x19“è"
  b"£\x13þéÙ©C£¤VÓ#”z…Ð"
  b"▀\x08.Y®\x05M¢òÜÕ\x0Fì█\tG"
  b"ç4ëHlCGC¬üÁ▓\x1F└R¨"
  b"Ú░'OyKDÉÀìLsÇð┌D"
  b"øÜÞ\)ÇM\x01škþ­K\t§>"
  b"è\ry¢ÂXMq¦ÁBúJ‘€Y"
  b"À\x14!T›¾Cl…3Ý×t-ºv"
  b"ÝXÛ€LsBm¶X\x07x^½ÑÜ"
  b"˵á‰Ù\x04Jo»Nkö¬6áý"
  b"û╗Â]┴ñK­╣ü1¦┬)»╠"
  b"@†òÚ‹‹Oå­\r´ÖY,Æf"
  b"z¥”\x16QO@v¯+b’J t_"
  b"D‘\x1AJ&\x05M׎áž!-\fÕM"
  b"a·¤çç¢F!¦ÓO,WÅý\x1C"
  b".█/┐b┤D░ïìÚ]═ÛMê"
  b"¯•\x13ÏYhEW¤O8\x15R\x11e¹"
  b"«ƒ«§Ù^LÁŽÓÝöd^\x03¬"
  b"■T«në\vM\x04üº┐ï┴\v`|"
  b"=µùä¨ÕLp²<Å@éœÊf"
  b"sµ’½\x03(GÏ£i\v.yœtÅ"
  b"+!\x18└╚ØMâ╝\Q╦DM,ö"
  b"zKj\e╦>H¯ösÅæ░3:Ó"
  b"MLÉ¿‹rEŸ´I˜Éç;\x12z"
  b"/¥„¸áµG\x03†ìþ%…¸¨S"
  b"I™¾ÎX\x05A,¸j«\x17éíp·"
  b"\x05ÌNTœåJ¯ž¸„¬\x15לÒ"
  b"\x14Þ.ËÙøLKª\x06ï\rÁ¤=Þ"
  b"\x19”\x13”HEJH‹ùG¥Øï=Í"
  b"\x1D}\rÞy«O1´¤À¥Ø6i~"
  b"+ø{ü]>Géñ¾£-á©k:"
  b",·ªkÿ\rNæª\x1FGœ_Ò×s"
  b"1¸¸NI~E®É&Ç\x10(ÊÖ_"
  b"7cÇÔögBîØ═\SHf┤\x07"
  b"PŸô8\x03ÕO%®ÁÙÀ4Á6X"
  b"dzÉßÁÌK««\x7FèÚ`¿¯\x00"
  b"jsó•“<A\x04¥æ+3\fSÀ$"
  b"j¢ãê¯oG*°„97ÍôË "
  b"o}\VM”I_€îÇ®óéáP"
  b"â┐e\x04d½NÑùÛd>Þü_\n"
  b"èü\tÄã\eAÕ¿\x001C║ß┤Z"
  b"è¬þÂ:Z@źTçıÅ$É5"
  b"“6¤o"ðIx„SâÝñéœè"
  b"ùyƒÍ\rùJÌü´¥µç║ƒ¬"
  b"¬!\x0E°ªˆK§˜ÔÂ\x188įi"
  b"░'\x1E.é\x1EL÷ì‗\v«ûa¸\x0F"
  b"""
    ¼)®ôââ@t—R2\x08œu\n
    ø
    """
  b"""
    Á´oºÔŒFiŽ:X\v\n
    ×Ûì
    """
  b"Åå©o\r'G·ˆfž¥õ\v^j"
  b"òp\x1E¯ «D\x00ˆJƒ\x039±X`"
  b"·)=É¢fD`ÆÎÕ©â®7S"
  b"ü[[àä¿M‘–J—ÍÝäØ"
  b"\x16L’\x00£ôN¢®­Þþ(˜6¦"
  b")»W\x14¾¥@¹¬{Ðwâ±Ùo"
  b"T¸¦ùq§Cθ\x1Fœ `ønµ"
  b"[œwÖ¢ïCg¹mEÏþ»c\"
  b"wxÊ‘læGωæ]ᢾ8\e"
  b"x\f\x14(<ûMá–`þ×L‰¶\x0F"
  b"ê/Q¢┬╠N\x0EªÕ▓4#]\x1Cü"
  b"ì$Õ]:¸Ao¡P\x1Aø`ÿo─"
  b"ÜÕìöþ`O┐ÂaÒ¬S@╔\e"
  b"®e¢óu“BJŠÏºÊí\x07•Ÿ"
  b"ÂM\v\eHóK»»w\x0FŽô³\x03s"
  b"ÃÞ\x04ÃÍùAÀ¦¶\x0EÁš´\x06`"
  b"""
    α\x063w¶O±¿\n
    6IAÉ\x13N
    """
  b"¹\x11h┘óhA2à\x1F»Ó╝þ\rÉ"
  b"Q0);­\rO\x19¿zj}€Š\e."
  b"V…û½\x04ÄG%”¹Ì@\x07}MC"
  b"\¥P\x13ÎÜK¾ž¬\x00jŽ¢~¢"
  b"€E\x04ÎMOOÚƒ¡ðÅ™\x04,\x12"
  b"€äxòÀžA(ƒ(\x13Ø)’£©"
  b"§\x02ભ\eA¦¼“xÂÆIÙ("
  b"®m%`¯\f@\x1Aîì6gæFÔR"
  b"„—wi¶ÉB”‚NU{Šžïç"
  b"┤n÷╗▓GFºhmr¶\x10ź"
  b"\x1EÁP[┐D@¬óûËþnð\x1CÉ"
  b"$²$\x00`qEü·\x04,\t½R;\x1E"
  b"'U”\x02NHK‚@\x0FÍŠ¨-Ò"
  b"K2h”6ÜGÉ™è(šáúÈv"
  b"R\x0En§"UK,¦3O9GÞÅé"
  b"sd£}vbL¦ªhƆnY\x04w"
  b"╩*×cÃbD¦ì\x10âH■Âa\x1A"
  b"ÖI|\tå\x01M\x1D¦Zú¥F®žü"
  b"óÕyŽ¯‘@ižãƒ ™SP¢"
  b"ö@Š¥3CCú¬I\x0E\x15Ìÿ\x17©"
  b"\x16¾‹hÌÆC\x06˜\x19C”X\x15Ýa"
  b"5═\x01┼·?IóÅ8\x0F\\x02ß╠°"
  b"|ÙEMN┌HVØ╗ÿsÓ▀\x0FÉ"
  b"É-JõóöGìñ?hå\x17O\x1FÄ"
  b"Ü█ÉònõOÚâà\x12t4OÓ3"
  b"¯ìÍæ‘bMS”uð_ê¡)t"
  b"$Ú»x–!D\x07“<’‚\tJ±W"
  b"jü1Ž5rHןåÌ#a¦\x1EÀ"
  b"å®@(┤╬OôÉ▀¨ï±│Ê\x14"
  b"""
    í╣åç2ª@┴óØ\n
    ╠øÊ╚È
    """
  b"¥ás%™©I\x13€’\t\x1CQ\x01[Ñ"
  b"×¥**»ËH›ž‹,I~·Èx"
  b"¯D§ãW\x1DHûüD)Ð▓ÄV+"
  b"0Â<,—3Np«\x7FwùÎ× $"
  b"Cì4<\x10ýBñ—?sa^X*F"
  b"Ÿ”\t’4\x12Oá…\x15\x04\x12ï2Sl"
  b"°—lâ\x04FGn¦‡l©z1µê"
  b"@{║\x19▓\x00LÅÉ\x02^\x1D!!^A"
  b""r\r¹&▓O;àÅd▄¿3~ø"
  b"ª\e¬o(¤OP”pQSë9|‘"
  b"®ÚMn.ÐA\¸ìþ®ÅÖ\x1CŽ"
  b"▄^J$Û`N&ç\x1E╬╩¹Ïü¦"
  b"""
    ç²ÄyÚ$@î—7ÙL\n
    Õ?Å
    """
  b"\x13bë:\x08äNQ„õ§IeI“e"
  b"0\x1D\x0FDbÑB”î?ôºÇ\x000"
  b"L¼;\x1F½¡@·œUÆàd[†x"
  b"Òò~ük╝L)Ĭ*ߦFT¬"
  b"§Û\x1E§¸ÊM2©¤rÆyÔ6Ù"
  b"0ÝÚH,\x19KÍ¢Û…ý˃~©"
  b"D\x13Æ€yûJ@œ©)x\x00Ég+"
  b"%Çâ0/³NÞ’§¬ë3»\x06ˆ"
  b"ùzÑ&í\x01GLƒ :‰õ·";"
  b"╝Ñ\x04L\x16ØB½©║õ³\x08*\x1F╚"
  b"?▀ß└{±E¥ü\x194wÿ‗Ùñ"
  b"B\x14Þ=\x0F2Lß³³®öÈ~\x01$"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.48 ms
(0.55%) 		6 
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.32 ms
(0.49%) 		1 
SELECT `product_stream`.`id` as `product_stream.id`, `product_stream`.`api_filter` as `product_stream.apiFilter`, `product_stream`.`invalid` as `product_stream.invalid`, `product_stream`.`created_at` as `product_stream.createdAt`, `product_stream`.`updated_at` as `product_stream.updatedAt`, `product_stream.translation.name`, COALESCE(`product_stream.translation.name`,`product_stream.translation.name`) as `product_stream.name`, `product_stream.translation.description`, COALESCE(`product_stream.translation.description`,`product_stream.translation.description`) as `product_stream.description`, `product_stream.translation.customFields`, COALESCE(`product_stream.translation.customFields`,`product_stream.translation.customFields`) as `product_stream.customFields`, `product_stream.translation.createdAt`, `product_stream.translation.updatedAt`, `product_stream.translation.productStreamId`, `product_stream.translation.languageId` FROM `product_stream` LEFT JOIN (SELECT `product_stream.translation`.product_stream_id, `product_stream.translation`.name as `product_stream.translation.name`, `product_stream.translation`.description as `product_stream.translation.description`, `product_stream.translation`.custom_fields as `product_stream.translation.customFields`, `product_stream.translation`.created_at as `product_stream.translation.createdAt`, `product_stream.translation`.updated_at as `product_stream.translation.updatedAt`, `product_stream.translation`.product_stream_id as `product_stream.translation.productStreamId`, `product_stream.translation`.language_id as `product_stream.translation.languageId` FROM `product_stream_translation` `product_stream.translation` WHERE `product_stream.translation`.language_id = ?) `product_stream.product_stream_translation` ON `product_stream.product_stream_translation`.`product_stream_id` = `product_stream`.`id` WHERE `product_stream`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Êž>‡o€GÄš\x0E_æ”0”’"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.31 ms
(0.49%) 		1 
# product-listing::property-filter::read
SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group.translation.name`, COALESCE(`property_group_option.group.translation.name`,`property_group_option.group.translation.name`) as `property_group_option.group.name`, `property_group_option.group.translation.description`, COALESCE(`property_group_option.group.translation.description`,`property_group_option.group.translation.description`) as `property_group_option.group.description`, `property_group_option.group.translation.position`, COALESCE(`property_group_option.group.translation.position`,`property_group_option.group.translation.position`) as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, COALESCE(`property_group_option.group.translation.customFields`,`property_group_option.group.translation.customFields`) as `property_group_option.group.customFields`, `property_group_option.group.translation.createdAt`, `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation.languageId`, `property_group_option.media`.`id` as `property_group_option.media.id`, `property_group_option.media`.`user_id` as `property_group_option.media.userId`, `property_group_option.media`.`media_folder_id` as `property_group_option.media.mediaFolderId`, `property_group_option.media`.`mime_type` as `property_group_option.media.mimeType`, `property_group_option.media`.`file_extension` as `property_group_option.media.fileExtension`, `property_group_option.media`.`uploaded_at` as `property_group_option.media.uploadedAt`, `property_group_option.media`.`file_name` as `property_group_option.media.fileName`, `property_group_option.media`.`file_size` as `property_group_option.media.fileSize`, `property_group_option.media`.`media_type` as `property_group_option.media.mediaTypeRaw`, `property_group_option.media`.`meta_data` as `property_group_option.media.metaData`, `property_group_option.media`.`config` as `property_group_option.media.config`, `property_group_option.media`.`path` as `property_group_option.media.path`, `property_group_option.media`.`private` as `property_group_option.media.private`, `property_group_option.media`.`thumbnails_ro` as `property_group_option.media.thumbnailsRo`, `property_group_option.media`.`created_at` as `property_group_option.media.createdAt`, `property_group_option.media`.`updated_at` as `property_group_option.media.updatedAt`, `property_group_option.media.translation.title`, COALESCE(`property_group_option.media.translation.title`,`property_group_option.media.translation.title`) as `property_group_option.media.title`, `property_group_option.media.translation.alt`, COALESCE(`property_group_option.media.translation.alt`,`property_group_option.media.translation.alt`) as `property_group_option.media.alt`, `property_group_option.media.translation.customFields`, COALESCE(`property_group_option.media.translation.customFields`,`property_group_option.media.translation.customFields`) as `property_group_option.media.customFields`, `property_group_option.media.translation.createdAt`, `property_group_option.media.translation.updatedAt`, `property_group_option.media.translation.mediaId`, `property_group_option.media.translation.languageId`, `property_group_option.translation.name`, COALESCE(`property_group_option.translation.name`,`property_group_option.translation.name`) as `property_group_option.name`, `property_group_option.translation.position`, COALESCE(`property_group_option.translation.position`,`property_group_option.translation.position`) as `property_group_option.position`, `property_group_option.translation.customFields`, COALESCE(`property_group_option.translation.customFields`,`property_group_option.translation.customFields`) as `property_group_option.customFields`, `property_group_option.translation.createdAt`, `property_group_option.translation.updatedAt`, `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation.languageId` FROM `property_group_option` LEFT JOIN (SELECT `property_group_option.translation`.property_group_option_id, `property_group_option.translation`.name as `property_group_option.translation.name`, `property_group_option.translation`.position as `property_group_option.translation.position`, `property_group_option.translation`.custom_fields as `property_group_option.translation.customFields`, `property_group_option.translation`.created_at as `property_group_option.translation.createdAt`, `property_group_option.translation`.updated_at as `property_group_option.translation.updatedAt`, `property_group_option.translation`.property_group_option_id as `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation`.language_id as `property_group_option.translation.languageId` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.language_id = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN `media` `property_group_option.media` ON `property_group_option`.`media_id` = `property_group_option.media`.`id` LEFT JOIN (SELECT `property_group_option.group.translation`.property_group_id, `property_group_option.group.translation`.name as `property_group_option.group.translation.name`, `property_group_option.group.translation`.description as `property_group_option.group.translation.description`, `property_group_option.group.translation`.position as `property_group_option.group.translation.position`, `property_group_option.group.translation`.custom_fields as `property_group_option.group.translation.customFields`, `property_group_option.group.translation`.created_at as `property_group_option.group.translation.createdAt`, `property_group_option.group.translation`.updated_at as `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation`.property_group_id as `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation`.language_id as `property_group_option.group.translation.languageId` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.language_id = ?) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.media.translation`.media_id, `property_group_option.media.translation`.title as `property_group_option.media.translation.title`, `property_group_option.media.translation`.alt as `property_group_option.media.translation.alt`, `property_group_option.media.translation`.custom_fields as `property_group_option.media.translation.customFields`, `property_group_option.media.translation`.created_at as `property_group_option.media.translation.createdAt`, `property_group_option.media.translation`.updated_at as `property_group_option.media.translation.updatedAt`, `property_group_option.media.translation`.media_id as `property_group_option.media.translation.mediaId`, `property_group_option.media.translation`.language_id as `property_group_option.media.translation.languageId` FROM `media_translation` `property_group_option.media.translation` WHERE `property_group_option.media.translation`.language_id = ?) `property_group_option.media.media_translation` ON `property_group_option.media.media_translation`.`media_id` = `property_group_option.media`.`id` WHERE `property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x05ÌNTœåJ¯ž¸„¬\x15לÒ"
  b"\x0F•é{\x1D<G6·Rš)€Ü"S"
  b"\x14Þ.ËÙøLKª\x06ï\rÁ¤=Þ"
  b"\x16¾‹hÌÆC\x06˜\x19C”X\x15Ýa"
  b"\x19”\x13”HEJH‹ùG¥Øï=Í"
  b")»W\x14¾¥@¹¬{Ðwâ±Ùo"
  b"+ø{ü]>Géñ¾£-á©k:"
  b"0ÝÚH,\x19KÍ¢Û…ý˃~©"
  b"7cÇÔögBîØ═\SHf┤\x07"
  b"B\x14Þ=\x0F2Lß³³®öÈ~\x01$"
  b"Cì4<\x10ýBñ—?sa^X*F"
  b"D\x13Æ€yûJ@œ©)x\x00Ég+"
  b"F'vûZÏ@s‹léqgÁl\x06"
  b"L¼;\x1F½¡@·œUÆàd[†x"
  b"Q0);­\rO\x19¿zj}€Š\e."
  b"T¸¦ùq§Cθ\x1Fœ `ønµ"
  b"V…û½\x04ÄG%”¹Ì@\x07}MC"
  b"[œwÖ¢ïCg¹mEÏþ»c\"
  b"\¥P\x13ÎÜK¾ž¬\x00jŽ¢~¢"
  b"`êJî:ÍK‚Œòˆ²œ_mi"
  b"jsó•“<A\x04¥æ+3\fSÀ$"
  b"j¢ãê¯oG*°„97ÍôË "
  b"jü1Ž5rHןåÌ#a¦\x1EÀ"
  b"mH¡O▓âF#úY÷"`¦\x1AÉ"
  b"o}\VM”I_€îÇ®óéáP"
  b"sd£}vbL¦ªhƆnY\x04w"
  b"x\f\x14(<ûMá–`þ×L‰¶\x0F"
  b"""
    \x7Flƒ%æÛJ2«\\n
    ÊIßE\x13
    """
  b"€äxòÀžA(ƒ(\x13Ø)’£©"
  b"â┐e\x04d½NÑùÛd>Þü_\n"
  b"…ù#O]×L3œrþX*Õ’Á"
  b"ç4ëHlCGC¬üÁ▓\x1F└R¨"
  b"ê/Q¢┬╠N\x0EªÕ▓4#]\x1Cü"
  b"èü\tÄã\eAÕ¿\x001C║ß┤Z"
  b"î1Ä\x1DÿZOéô÷\x07v ╝Øl"
  b"“6¤o"ðIx„SâÝñéœè"
  b"ùyƒÍ\rùJÌü´¥µç║ƒ¬"
  b"Ü█ÉònõOÚâà\x12t4OÓ3"
  b"ÜÕìöþ`O┐ÂaÒ¬S@╔\e"
  b"ž©’d 4GV®~ÈÔ\x1E\x14PG"
  b"Ÿ”\t’4\x12Oá…\x15\x04\x12ï2Sl"
  b"§Û\x1E§¸ÊM2©¤rÆyÔ6Ù"
  b"®m%`¯\f@\x1Aîì6gæFÔR"
  b"¬!\x0E°ªˆK§˜ÔÂ\x188įi"
  b"¯ìÍæ‘bMS”uð_ê¡)t"
  b"░'\x1E.é\x1EL÷ì‗\v«ûa¸\x0F"
  b"°—lâ\x04FGn¦‡l©z1µê"
  b"│╔ù ─]J#ìIRh\x18Æ\x13u"
  b"┤n÷╗▓GFºhmr¶\x10ź"
  b"""
    Á´oºÔŒFiŽ:X\v\n
    ×Ûì
    """
  b"ÂM\v\eHóK»»w\x0FŽô³\x03s"
  b"""
    α\x063w¶O±¿\n
    6IAÉ\x13N
    """
  b"ÝXÛ€LsBm¶X\x07x^½ÑÜ"
  b"ÞG\x16¤‰0F3¤÷œÉ£%<ì"
  b"¯D§ãW\x1DHûüD)Ð▓ÄV+"
  b"ö@Š¥3CCú¬I\x0E\x15Ìÿ\x17©"
  b"ùzÑ&í\x01GLƒ :‰õ·";"
  b"·)=É¢fD`ÆÎÕ©â®7S"
  b"úV}7ðæL¦—†Å)¯7éb"
  b"ü[[àä¿M‘–J—ÍÝäØ"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.31 ms
(0.48%) 		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"‰\x19Ïì\e\x13IT£´^“HaºO"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.24 ms
(0.46%) 		1 
SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`type` as `cms_slot.type`, `cms_slot`.`slot` as `cms_slot.slot`, `cms_slot`.`locked` as `cms_slot.locked`, `cms_slot`.`cms_block_id` as `cms_slot.blockId`, `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.swagCmsExtensionsForm`.`id` as `cms_slot.swagCmsExtensionsForm.id`, `cms_slot.swagCmsExtensionsForm`.`cms_slot_id` as `cms_slot.swagCmsExtensionsForm.cmsSlotId`, `cms_slot.swagCmsExtensionsForm`.`cms_slot_version_id` as `cms_slot.swagCmsExtensionsForm.cmsSlotVersionId`, `cms_slot.swagCmsExtensionsForm`.`is_template` as `cms_slot.swagCmsExtensionsForm.isTemplate`, `cms_slot.swagCmsExtensionsForm`.`technical_name` as `cms_slot.swagCmsExtensionsForm.technicalName`, `cms_slot.swagCmsExtensionsForm`.`mail_template_id` as `cms_slot.swagCmsExtensionsForm.mailTemplateId`, `cms_slot.swagCmsExtensionsForm`.`created_at` as `cms_slot.swagCmsExtensionsForm.createdAt`, `cms_slot.swagCmsExtensionsForm`.`updated_at` as `cms_slot.swagCmsExtensionsForm.updatedAt`, `cms_slot.swagCmsExtensionsForm.translation.title`, COALESCE(`cms_slot.swagCmsExtensionsForm.translation.title`,`cms_slot.swagCmsExtensionsForm.translation.title`) as `cms_slot.swagCmsExtensionsForm.title`, `cms_slot.swagCmsExtensionsForm.translation.successMessage`, COALESCE(`cms_slot.swagCmsExtensionsForm.translation.successMessage`,`cms_slot.swagCmsExtensionsForm.translation.successMessage`) as `cms_slot.swagCmsExtensionsForm.successMessage`, `cms_slot.swagCmsExtensionsForm.translation.receivers`, COALESCE(`cms_slot.swagCmsExtensionsForm.translation.receivers`,`cms_slot.swagCmsExtensionsForm.translation.receivers`) as `cms_slot.swagCmsExtensionsForm.receivers`, `cms_slot.swagCmsExtensionsForm.translation.createdAt`, `cms_slot.swagCmsExtensionsForm.translation.updatedAt`, `cms_slot.swagCmsExtensionsForm.translation.swagCmsExtensionsFormId`, `cms_slot.swagCmsExtensionsForm.translation.languageId`, `cms_slot.translation.config`, COALESCE(`cms_slot.translation.config`,`cms_slot.translation.config`) as `cms_slot.config`, `cms_slot.translation.customFields`, COALESCE(`cms_slot.translation.customFields`,`cms_slot.translation.customFields`) as `cms_slot.customFields`, `cms_slot.translation.createdAt`, `cms_slot.translation.updatedAt`, `cms_slot.translation.cmsSlotId`, `cms_slot.translation.languageId`, `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation`.cms_slot_id, `cms_slot.translation`.cms_slot_version_id, `cms_slot.translation`.config as `cms_slot.translation.config`, `cms_slot.translation`.custom_fields as `cms_slot.translation.customFields`, `cms_slot.translation`.created_at as `cms_slot.translation.createdAt`, `cms_slot.translation`.updated_at as `cms_slot.translation.updatedAt`, `cms_slot.translation`.cms_slot_id as `cms_slot.translation.cmsSlotId`, `cms_slot.translation`.language_id as `cms_slot.translation.languageId`, `cms_slot.translation`.cms_slot_version_id as `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation`.language_id = ?) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` AND `cms_slot.cms_slot_translation`.cms_slot_version_id = `cms_slot`.version_id LEFT JOIN `swag_cms_extensions_form` `cms_slot.swagCmsExtensionsForm` ON `cms_slot`.`id` = `cms_slot.swagCmsExtensionsForm`.`cms_slot_id` LEFT JOIN (SELECT `cms_slot.swagCmsExtensionsForm.translation`.swag_cms_extensions_form_id, `cms_slot.swagCmsExtensionsForm.translation`.title as `cms_slot.swagCmsExtensionsForm.translation.title`, `cms_slot.swagCmsExtensionsForm.translation`.success_message as `cms_slot.swagCmsExtensionsForm.translation.successMessage`, `cms_slot.swagCmsExtensionsForm.translation`.receivers as `cms_slot.swagCmsExtensionsForm.translation.receivers`, `cms_slot.swagCmsExtensionsForm.translation`.created_at as `cms_slot.swagCmsExtensionsForm.translation.createdAt`, `cms_slot.swagCmsExtensionsForm.translation`.updated_at as `cms_slot.swagCmsExtensionsForm.translation.updatedAt`, `cms_slot.swagCmsExtensionsForm.translation`.swag_cms_extensions_form_id as `cms_slot.swagCmsExtensionsForm.translation.swagCmsExtensionsFormId`, `cms_slot.swagCmsExtensionsForm.translation`.language_id as `cms_slot.swagCmsExtensionsForm.translation.languageId` FROM `swag_cms_extensions_form_translation` `cms_slot.swagCmsExtensionsForm.translation` WHERE `cms_slot.swagCmsExtensionsForm.translation`.language_id = ?) `cms_slot.swagCmsExtensionsForm.swag_cms_extensions_form_translation` ON `cms_slot.swagCmsExtensionsForm.swag_cms_extensions_form_translation`.`swag_cms_extensions_form_id` = `cms_slot.swagCmsExtensionsForm`.`id` WHERE (`cms_slot`.`version_id` = ?) AND (`cms_slot`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01ì┼Õ├Ãq─│8)G»ñ\x03w"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.89 ms
(0.33%) 		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"\x0F•é{\x1D<G6·Rš)€Ü"S"
  b"èþVd|’CY«è^±ûø´a"
  b"úV}7ðæL¦—†Å)¯7éb"
  b"†‚íF;ÓL$”8à¡D\x05uD"
  b":äGô\x14‚OÕžV]<—‰ÈW"
  b"""
    ÊÀ+öAÿL\x12ëk│\n
    ╩ÉnÑ
    """
  b"""
    \x7Flƒ%æÛJ2«\\n
    ÊIßE\x13
    """
  b"ææ╝Ë\x19ºM¯Å\vßú¿¨öì"
  b"`êJî:ÍK‚Œòˆ²œ_mi"
  b"\x08▀┌■ß\x7FB╔░NÃtì┴­w"
  b"9Z¥LàKOD„Â4\kw\x14ý"
  b"»\x11›¥¶ÇNé­&íËë\x062\e"
  b"³\x00\x0E¦ðÌC½¬vûÜ\x00ÈäN"
  b"ÔÞ×+d½Hø¡ÍLéØoIµ"
  b"Õ¯ÿl\x11\x11G{ü├¥û*┴┤█"
  b"“\x08êõ÷\rIÓ»%h<G\rH‡"
  b"/Üi1×°O3½|Üý×eˆü"
  b"î1Ä\x1DÿZOéô÷\x07v ╝Øl"
  b"Ì\x13-¦lúDø–g1\x00i"
  b"b^îvÞ‡E£™¾µ 9Œ™¼"
  b"""
    <Cq\n
    &8MŒ¿Âæ.Ù®J\e
    """
  b",\x15u±$½@î£É|ؾþæ^"
  b"#Â[ËÎK¢¡÷ö`î]\x07ì"
  b"│╔ù ─]J#ìIRh\x18Æ\x13u"
  b"N—·Ò\rGN¬„‰\x7Fe4«è\x1A"
  b"Ì>┘s;ÔD­¥L\x13Ø`ÒS▄"
  b"\x17Û\x1C╦^0JÅûÅR£▓Õå\x18"
  b"""
    \n
    \x07║Æ+\x10CÈ┐´þ╚M^É\x0E
    """
  b"F'vûZÏ@s‹léqgÁl\x06"
  b"┐8Á£¨=GBë‗░ÅÜz­µ"
  b":÷¦âW\vDi°Ž\x18\x12XU€\x1E"
  b"…ù#O]×L3œrþX*Õ’Á"
  b"ƒ¼Þ\x07òÑET€[|vÚ|pD"
  b"oìmÈ┼\x1EKzÅÖM \x1A╗Qö"
  b"ž©’d 4GV®~ÈÔ\x1E\x14PG"
  b"ÞG\x16¤‰0F3¤÷œÉ£%<ì"
  b"­b¶î©4GPš ‘Ô~!\x18Ç"
  b"0Öü\x0E<uIÕ▒n{¢╚î `"
  b"\x1A\t\x19¥âÉMb£ª\r╠+\x07¯y"
  b"RD\x15,~ÞNºƒŠ‡JJþ_Á"
  b"Émè¹1gBɉͼH¯\x13Dñ"
  b"t¦Sß›·D\x17¯×)×\x17y\x7F0"
  b"mH¡O▓âF#úY÷"`¦\x1AÉ"
  b"""
    É\n
    ŸÎw¥IÖ¹øNtVå·\x7F
    """
  b"ÒZF$Ê\x1DJŽ‚³x°¼BÌ\x17"
  b"ñrâÐM×H$²«Þ±\x18ÑW\x1A"
  b"\x030{iü^Oô▓╬/¨­AéE"
  b"êF+ŒfÝ@S—¹\x05Lõ»¾ù"
  b"""
    Oe¬¼øøE<œ)½\x06\x16 \n
    ¿
    """
  b"¶A\x13*\x02ÕF\x11“…}C¯\x19“è"
  b"£\x13þéÙ©C£¤VÓ#”z…Ð"
  b"▀\x08.Y®\x05M¢òÜÕ\x0Fì█\tG"
  b"ç4ëHlCGC¬üÁ▓\x1F└R¨"
  b"Ú░'OyKDÉÀìLsÇð┌D"
  b"øÜÞ\)ÇM\x01škþ­K\t§>"
  b"è\ry¢ÂXMq¦ÁBúJ‘€Y"
  b"À\x14!T›¾Cl…3Ý×t-ºv"
  b"ÝXÛ€LsBm¶X\x07x^½ÑÜ"
  b"˵á‰Ù\x04Jo»Nkö¬6áý"
  b"û╗Â]┴ñK­╣ü1¦┬)»╠"
  b"@†òÚ‹‹Oå­\r´ÖY,Æf"
  b"z¥”\x16QO@v¯+b’J t_"
  b"D‘\x1AJ&\x05M׎áž!-\fÕM"
  b"a·¤çç¢F!¦ÓO,WÅý\x1C"
  b".█/┐b┤D░ïìÚ]═ÛMê"
  b"¯•\x13ÏYhEW¤O8\x15R\x11e¹"
  b"«ƒ«§Ù^LÁŽÓÝöd^\x03¬"
  b"■T«në\vM\x04üº┐ï┴\v`|"
  b"=µùä¨ÕLp²<Å@éœÊf"
  b"sµ’½\x03(GÏ£i\v.yœtÅ"
  b"+!\x18└╚ØMâ╝\Q╦DM,ö"
  b"zKj\e╦>H¯ösÅæ░3:Ó"
  b"MLÉ¿‹rEŸ´I˜Éç;\x12z"
  b"/¥„¸áµG\x03†ìþ%…¸¨S"
  b"I™¾ÎX\x05A,¸j«\x17éíp·"
  b"\x05ÌNTœåJ¯ž¸„¬\x15לÒ"
  b"\x14Þ.ËÙøLKª\x06ï\rÁ¤=Þ"
  b"\x19”\x13”HEJH‹ùG¥Øï=Í"
  b"\x1D}\rÞy«O1´¤À¥Ø6i~"
  b"+ø{ü]>Géñ¾£-á©k:"
  b",·ªkÿ\rNæª\x1FGœ_Ò×s"
  b"1¸¸NI~E®É&Ç\x10(ÊÖ_"
  b"7cÇÔögBîØ═\SHf┤\x07"
  b"PŸô8\x03ÕO%®ÁÙÀ4Á6X"
  b"dzÉßÁÌK««\x7FèÚ`¿¯\x00"
  b"jsó•“<A\x04¥æ+3\fSÀ$"
  b"j¢ãê¯oG*°„97ÍôË "
  b"o}\VM”I_€îÇ®óéáP"
  b"â┐e\x04d½NÑùÛd>Þü_\n"
  b"èü\tÄã\eAÕ¿\x001C║ß┤Z"
  b"è¬þÂ:Z@źTçıÅ$É5"
  b"“6¤o"ðIx„SâÝñéœè"
  b"ùyƒÍ\rùJÌü´¥µç║ƒ¬"
  b"¬!\x0E°ªˆK§˜ÔÂ\x188įi"
  b"░'\x1E.é\x1EL÷ì‗\v«ûa¸\x0F"
  b"""
    ¼)®ôââ@t—R2\x08œu\n
    ø
    """
  b"""
    Á´oºÔŒFiŽ:X\v\n
    ×Ûì
    """
  b"Åå©o\r'G·ˆfž¥õ\v^j"
  b"òp\x1E¯ «D\x00ˆJƒ\x039±X`"
  b"·)=É¢fD`ÆÎÕ©â®7S"
  b"ü[[àä¿M‘–J—ÍÝäØ"
  b"\x16L’\x00£ôN¢®­Þþ(˜6¦"
  b")»W\x14¾¥@¹¬{Ðwâ±Ùo"
  b"T¸¦ùq§Cθ\x1Fœ `ønµ"
  b"[œwÖ¢ïCg¹mEÏþ»c\"
  b"wxÊ‘læGωæ]ᢾ8\e"
  b"x\f\x14(<ûMá–`þ×L‰¶\x0F"
  b"ê/Q¢┬╠N\x0EªÕ▓4#]\x1Cü"
  b"ì$Õ]:¸Ao¡P\x1Aø`ÿo─"
  b"ÜÕìöþ`O┐ÂaÒ¬S@╔\e"
  b"®e¢óu“BJŠÏºÊí\x07•Ÿ"
  b"ÂM\v\eHóK»»w\x0FŽô³\x03s"
  b"ÃÞ\x04ÃÍùAÀ¦¶\x0EÁš´\x06`"
  b"""
    α\x063w¶O±¿\n
    6IAÉ\x13N
    """
  b"¹\x11h┘óhA2à\x1F»Ó╝þ\rÉ"
  b"Q0);­\rO\x19¿zj}€Š\e."
  b"V…û½\x04ÄG%”¹Ì@\x07}MC"
  b"\¥P\x13ÎÜK¾ž¬\x00jŽ¢~¢"
  b"€E\x04ÎMOOÚƒ¡ðÅ™\x04,\x12"
  b"€äxòÀžA(ƒ(\x13Ø)’£©"
  b"§\x02ભ\eA¦¼“xÂÆIÙ("
  b"®m%`¯\f@\x1Aîì6gæFÔR"
  b"„—wi¶ÉB”‚NU{Šžïç"
  b"┤n÷╗▓GFºhmr¶\x10ź"
  b"\x1EÁP[┐D@¬óûËþnð\x1CÉ"
  b"$²$\x00`qEü·\x04,\t½R;\x1E"
  b"'U”\x02NHK‚@\x0FÍŠ¨-Ò"
  b"K2h”6ÜGÉ™è(šáúÈv"
  b"R\x0En§"UK,¦3O9GÞÅé"
  b"sd£}vbL¦ªhƆnY\x04w"
  b"╩*×cÃbD¦ì\x10âH■Âa\x1A"
  b"ÖI|\tå\x01M\x1D¦Zú¥F®žü"
  b"óÕyŽ¯‘@ižãƒ ™SP¢"
  b"ö@Š¥3CCú¬I\x0E\x15Ìÿ\x17©"
  b"\x16¾‹hÌÆC\x06˜\x19C”X\x15Ýa"
  b"5═\x01┼·?IóÅ8\x0F\\x02ß╠°"
  b"|ÙEMN┌HVØ╗ÿsÓ▀\x0FÉ"
  b"É-JõóöGìñ?hå\x17O\x1FÄ"
  b"Ü█ÉònõOÚâà\x12t4OÓ3"
  b"¯ìÍæ‘bMS”uð_ê¡)t"
  b"$Ú»x–!D\x07“<’‚\tJ±W"
  b"jü1Ž5rHןåÌ#a¦\x1EÀ"
  b"å®@(┤╬OôÉ▀¨ï±│Ê\x14"
  b"""
    í╣åç2ª@┴óØ\n
    ╠øÊ╚È
    """
  b"¥ás%™©I\x13€’\t\x1CQ\x01[Ñ"
  b"×¥**»ËH›ž‹,I~·Èx"
  b"¯D§ãW\x1DHûüD)Ð▓ÄV+"
  b"0Â<,—3Np«\x7FwùÎ× $"
  b"Cì4<\x10ýBñ—?sa^X*F"
  b"Ÿ”\t’4\x12Oá…\x15\x04\x12ï2Sl"
  b"°—lâ\x04FGn¦‡l©z1µê"
  b"@{║\x19▓\x00LÅÉ\x02^\x1D!!^A"
  b""r\r¹&▓O;àÅd▄¿3~ø"
  b"ª\e¬o(¤OP”pQSë9|‘"
  b"®ÚMn.ÐA\¸ìþ®ÅÖ\x1CŽ"
  b"▄^J$Û`N&ç\x1E╬╩¹Ïü¦"
  b"""
    ç²ÄyÚ$@î—7ÙL\n
    Õ?Å
    """
  b"\x13bë:\x08äNQ„õ§IeI“e"
  b"0\x1D\x0FDbÑB”î?ôºÇ\x000"
  b"L¼;\x1F½¡@·œUÆàd[†x"
  b"Òò~ük╝L)Ĭ*ߦFT¬"
  b"§Û\x1E§¸ÊM2©¤rÆyÔ6Ù"
  b"0ÝÚH,\x19KÍ¢Û…ý˃~©"
  b"D\x13Æ€yûJ@œ©)x\x00Ég+"
  b"%Çâ0/³NÞ’§¬ë3»\x06ˆ"
  b"ùzÑ&í\x01GLƒ :‰õ·";"
  b"╝Ñ\x04L\x16ØB½©║õ³\x08*\x1F╚"
  b"?▀ß└{±E¥ü\x194wÿ‗Ùñ"
  b"B\x14Þ=\x0F2Lß³³®öÈ~\x01$"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.62 ms
(0.23%) 		1 
SELECT seo_path_info FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND (seo_path_info = ?) AND (is_canonical = ?) ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  "widgets/cms/navigation/8919cfec1b134954a3b45e934861ba4f/filter/"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.52 ms
(0.19%) 		1 
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"Rmi0±ÝIÕºwö)¦¤w÷"
  b"­Çò‚X¶Oš¨wÒ7³@ˆ®"
  b"ÅL|g\x0E'EL¶\x13ÉÖÑéç‹"
  b"l›î.G\x08OàžßP\x01€Èéº"
  b"""
    ~/ëàÕd@- ë\n
    \x0FB]ü¸
    """
  b"¥¶6o\x10+A÷’LÚ¯+‹¿."
  b"®ÇÐj÷sFu¡®\rÔ˜£N="
  b"ʃ$Ã\tUCö¦Ÿ’0PxfW"
  b"Þ$U¿Œ¢Kš„|ž9~@ri"
  b"­ã:╔\x06▀AÉɳ\x07x\x01E¦k"
  b"\x01ÅQ▄-Ïuvè.ýqkB\x00\x00"
  b"\x01ÅQÔ¶Øs\x19░A\x05Ȩ═ V"
  b"È\f¨É\vðIPïô│Ú╚Ç°÷"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.46 ms
(0.17%) 		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.45 ms
(0.17%) 		1 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.38 ms
(0.14%) 		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.37 ms
(0.14%) 		1 
# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND (seo_path_info = ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  "widgets/cms/navigation/8919cfec1b134954a3b45e934861ba4f/filter"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(0.13%) 		1 
# product-listing::load-sortings::read
SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.translation.label`, COALESCE(`product_sorting.translation.label`,`product_sorting.translation.label`) as `product_sorting.label`, `product_sorting.translation.createdAt`, `product_sorting.translation.updatedAt`, `product_sorting.translation.productSortingId`, `product_sorting.translation.languageId` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.product_sorting_id, `product_sorting.translation`.label as `product_sorting.translation.label`, `product_sorting.translation`.created_at as `product_sorting.translation.createdAt`, `product_sorting.translation`.updated_at as `product_sorting.translation.updatedAt`, `product_sorting.translation`.product_sorting_id as `product_sorting.translation.productSortingId`, `product_sorting.translation`.language_id as `product_sorting.translation.languageId` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.language_id = ?) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"¸\¤\x12)ÅM\x10âÍ°þè¹s\x10"
  b"Ö4{š4?JÙ—A\x1Aó,\x0Eëã"
  b"•õ3XÌÏH$†‹þ«j\:¯"
  b"vÌ\x18—•\tI@‚åˆÖ‡8•O"
  b"S'‚wYëFߣ\x01‘åå€îQ"
  b"ÅÜÍ▄ß┘EÀ¿vÇ╣U\v╚░"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(0.11%) 		2 
#cart-persister::load
                SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters: 
[
  "cfVgWPv6awGggi5PF2v8gc0sRyxxdrsD"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.28 ms
(0.10%) 		1 
# seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (path_info = ?) AND (is_canonical = 1) LIMIT 1
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  "/widgets/cms/navigation/8919cfec1b134954a3b45e934861ba4f/filter"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(0.10%) 		1 
SELECT module.module, module.response FROM wbm_data_layer_modules module
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(0.10%) 		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.23 ms
(0.09%) 		1 
SELECT `cms_slot`.`id` FROM `cms_slot` WHERE (`cms_slot`.`version_id` = ?) AND (`cms_slot`.`id` IN (?)) LIMIT 1
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01ì┼Õ├Ãq─│8)G»ñ\x03w"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.05%) 		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.