GET https://staging.promoshirt.ch/widgets/cms/navigation/d34158c3ecd346b69cd5c0c7a50cd4b0/filter?only-aggregations=1&reduce-aggregations=1&slots=019b0859e29b718b9af…

Response
200 OK
IP
57.141.20.51
Profiled on
Token
7e44bb

Query Metrics

27 Database Queries
27 Different statements
561.56 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
201.99 ms
(35.97%) 		1 
-- product-listing-route::loading::aggregation::price
SELECT MIN(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018ce8800e1a72978e4ccac8d4f8c839.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule309e77e4c2434af4befc08fcf504a1c1.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule9918a5eb724743c3ac108ba0004b57b3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruled9b7aac2db4a42b9902019fcf679d0fd.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule5c5dc2192fb145d8ae0cbb93f6c78070.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleca049b689cbe42869840ef12b55d43f8.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`, "$.rule018ce8800e1a72978e4ccac8d4f8c839.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule309e77e4c2434af4befc08fcf504a1c1.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule9918a5eb724743c3ac108ba0004b57b3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruled9b7aac2db4a42b9902019fcf679d0fd.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule5c5dc2192fb145d8ae0cbb93f6c78070.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleca049b689cbe42869840ef12b55d43f8.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`, "$.rule018ce8800e1a72978e4ccac8d4f8c839.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule309e77e4c2434af4befc08fcf504a1c1.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule9918a5eb724743c3ac108ba0004b57b3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruled9b7aac2db4a42b9902019fcf679d0fd.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule5c5dc2192fb145d8ae0cbb93f6c78070.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleca049b689cbe42869840ef12b55d43f8.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`, "$.rule018ce8800e1a72978e4ccac8d4f8c839.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule309e77e4c2434af4befc08fcf504a1c1.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule9918a5eb724743c3ac108ba0004b57b3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruled9b7aac2db4a42b9902019fcf679d0fd.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule5c5dc2192fb145d8ae0cbb93f6c78070.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleca049b689cbe42869840ef12b55d43f8.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"Zˆ\§³@`ŽË¿•w;ö?"
  true
  b"ÓAXÃìÓF¶œÕÀÇ¥\fÔ°"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
94.86 ms
(16.89%) 		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"Zˆ\§³@`ŽË¿•w;ö?"
  true
  b"ÓAXÃìÓF¶œÕÀÇ¥\fÔ°"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
81.84 ms
(14.57%) 		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"Zˆ\§³@`ŽË¿•w;ö?"
  true
  b"ÓAXÃìÓF¶œÕÀÇ¥\fÔ°"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
55.97 ms
(9.97%) 		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"Zˆ\§³@`ŽË¿•w;ö?"
  true
  b"ÓAXÃìÓF¶œÕÀÇ¥\fÔ°"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
51.88 ms
(9.24%) 		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"Zˆ\§³@`ŽË¿•w;ö?"
  true
  b"ÓAXÃìÓF¶œÕÀÇ¥\fÔ°"
  null
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
50.78 ms
(9.04%) 		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"Zˆ\§³@`ŽË¿•w;ö?"
  true
  b"ÓAXÃìÓF¶œÕÀÇ¥\fÔ°"
  null
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
12.35 ms
(2.20%) 		1 
-- product-listing::property-filter::read
SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.media`.`id` as `property_group_option.media.id`, `property_group_option.media`.`user_id` as `property_group_option.media.userId`, `property_group_option.media`.`media_folder_id` as `property_group_option.media.mediaFolderId`, `property_group_option.media`.`mime_type` as `property_group_option.media.mimeType`, `property_group_option.media`.`file_extension` as `property_group_option.media.fileExtension`, `property_group_option.media`.`uploaded_at` as `property_group_option.media.uploadedAt`, `property_group_option.media`.`file_name` as `property_group_option.media.fileName`, `property_group_option.media`.`file_size` as `property_group_option.media.fileSize`, `property_group_option.media`.`media_type` as `property_group_option.media.mediaTypeRaw`, `property_group_option.media`.`meta_data` as `property_group_option.media.metaData`, `property_group_option.media`.`config` as `property_group_option.media.config`, `property_group_option.media`.`path` as `property_group_option.media.path`, `property_group_option.media`.`private` as `property_group_option.media.private`, `property_group_option.media`.`thumbnails_ro` as `property_group_option.media.thumbnailsRo`, `property_group_option.media`.`file_hash` as `property_group_option.media.fileHash`, `property_group_option.media`.`created_at` as `property_group_option.media.createdAt`, `property_group_option.media`.`updated_at` as `property_group_option.media.updatedAt`, `property_group_option.media.translation.override_1.title`, `property_group_option.media.translation.title`, COALESCE(`property_group_option.media.translation.override_1.title`,`property_group_option.media.translation.title`) as `property_group_option.media.title`, `property_group_option.media.translation.override_1.alt`, `property_group_option.media.translation.alt`, COALESCE(`property_group_option.media.translation.override_1.alt`,`property_group_option.media.translation.alt`) as `property_group_option.media.alt`, `property_group_option.media.translation.override_1.customFields`, `property_group_option.media.translation.customFields`, COALESCE(`property_group_option.media.translation.override_1.customFields`,`property_group_option.media.translation.customFields`) as `property_group_option.media.customFields`, `property_group_option.translation.override_1.name`, `property_group_option.translation.name`, COALESCE(`property_group_option.translation.override_1.name`,`property_group_option.translation.name`) as `property_group_option.name`, `property_group_option.translation.override_1.position`, `property_group_option.translation.position`, COALESCE(`property_group_option.translation.override_1.position`,`property_group_option.translation.position`) as `property_group_option.position`, `property_group_option.translation.override_1.customFields`, `property_group_option.translation.customFields`, COALESCE(`property_group_option.translation.override_1.customFields`,`property_group_option.translation.customFields`) as `property_group_option.customFields` FROM `property_group_option` LEFT JOIN `media` `property_group_option.media` ON `property_group_option`.`media_id` = `property_group_option.media`.`id` LEFT JOIN (SELECT `property_group_option.translation`.`property_group_option_id`, `property_group_option.translation`.`name` as `property_group_option.translation.name`, `property_group_option.translation.override_1`.`name` as `property_group_option.translation.override_1.name`, `property_group_option.translation`.`position` as `property_group_option.translation.position`, `property_group_option.translation.override_1`.`position` as `property_group_option.translation.override_1.position`, `property_group_option.translation`.`custom_fields` as `property_group_option.translation.customFields`, `property_group_option.translation.override_1`.`custom_fields` as `property_group_option.translation.override_1.customFields` FROM `property_group_option_translation` `property_group_option.translation` LEFT JOIN `property_group_option_translation` `property_group_option.translation.override_1` ON `property_group_option.translation`.`property_group_option_id` = `property_group_option.translation.override_1`.`property_group_option_id` AND `property_group_option.translation.override_1`.`language_id` = ? WHERE `property_group_option.translation`.`language_id` = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN (SELECT `property_group_option.media.translation`.`media_id`, `property_group_option.media.translation`.`alt` as `property_group_option.media.translation.alt`, `property_group_option.media.translation.override_1`.`alt` as `property_group_option.media.translation.override_1.alt`, `property_group_option.media.translation`.`title` as `property_group_option.media.translation.title`, `property_group_option.media.translation.override_1`.`title` as `property_group_option.media.translation.override_1.title`, `property_group_option.media.translation`.`custom_fields` as `property_group_option.media.translation.customFields`, `property_group_option.media.translation.override_1`.`custom_fields` as `property_group_option.media.translation.override_1.customFields` FROM `media_translation` `property_group_option.media.translation` LEFT JOIN `media_translation` `property_group_option.media.translation.override_1` ON `property_group_option.media.translation`.`media_id` = `property_group_option.media.translation.override_1`.`media_id` AND `property_group_option.media.translation.override_1`.`language_id` = ? 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"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01‹Ô@I/zé—TÏ8\x15»Kú"
  b"\x01‹Ô@­PrUžKý­<\x076{"
  b"\x01Œß6ÐÌvÆ©Æ%\x11¦S\x1D\t"
  b"\x01Ž„¾jav©‡ïg\x1DÊ0‡­"
  b"\x01Ž˜ÂŠlx!›<\v8‘\x15ì“"
  b"\x01Ž˜ÂÄ3|\rŒ¸…\x00÷ÛìÜ"
  b"\x01Ž˜Âó¸}䘎‹ú\x16\x1F#\x05"
  b"\x01Ž˜Ã\x1Af~;¡çí™h™h:"
  b"\x01Ž˜ÃGar\±¥ù\x19Ü£qH"
  b"\x01Ž¬R\KwLº Œ_\x0F¯\x12‡"
  b"\x01Ž¬R¯‹s}ŸA¹ú\x00Ú÷e"
  b"\x01\x14\x08\x17ÂrXªÝÏJ 4w5"
  b"\x01\x14\x08ZHqsà×S¨M'Ó"
  b"\x01\x14\x08›òuÍ‘Öÿ:2Í÷„"
  b"\x01‘n[.¨wP¥\x06u“nÏÎ<"
  b"\x01‘n[ûØ{A¬@Ë´wši"
  b"\x01‘n^9_p)¤Ûqx,™ø\x05"
  b"\x01‘n^­€x¤ŸÄê;À×vX"
  b"\x01‘n^Óàv9½7*»Ä@Ñ<"
  b"\x01‘n_\rØ}¡±›mÇ+Ъî"
  b"\x01‘n_´Pw·´Wñ}ǝ7["
  b"\x01‘n_á¸y®˜¦¹8\x15ßï"
  b"\x01‘n`5¨{•¦oÃN¢ ì"
  b"\x01‘naø¨pl`§_\v\x15{c"
  b"\x01‘sœZ;xD€[™«ë_\x01m"
  b"\x01‘sœŒò{„ï|Y\x08n|ª"
  b"\x01‘sœ½ó}\x05˜\x01RÅÅ<q´"
  b"\x01‘s±pdr—u\x1E±\x17ï\x1Aæ"
  b"\x01‘s´i|{+‘žg¡dr\x15R"
  b"\x01’wÆ\x00¥z吏¤Ä~Þ|O"
  b"\x01’wÆQÂ\x7F\x1AŸb-9‹Íôõ"
  b"\x01’wÆŸŒz\x0E£,\vü” \x17Ä"
  b"\x01’wÇ\x11=ty‘ûT{Ìcâî"
  b"\x01”’W–÷|Õ•¤$kë\f ·"
  b"\x01”’Wä-t\x07‡\x18À\e±\x08"›"
  b"\x01”’X-Óp9‚w…ûÖB~þ"
  b"\x01”’iDD\x7F$”Zý?vŽ×—"
  b"\x01”’i}á{Œ¸îßæ\eó"
  b"\x01”±!nðz>˜<\x12·"È¿Ÿ"
  b"\x01”±!Ârxz†­¥©*wßs"
  b"\x01”±"\tY~F†Ç±\x7F€~“F"
  b"\x01”±":€vŽŸü\x13¹é¿\x13÷"
  b"\x01”±"nKx¯”AŠ\x01¨ù\x1C\x17"
  b"\x01”±"Äâwˆ»œ:%\x181oü"
  b"\x01”±"þÏsߺP“bè2&¯"
  b"\x01”×ÔÏ1tñ’ñcxQC e"
  b"\x01•ÈnLÒu—¯Æ#z¯\x11ý\x11"
  b"\x01•Èn£yv+¸ušè‘ŒÕú"
  b"\x01•ÈnæQtY•ƒäüÚÞw\x7F"
  b"\x01•ÈoS‘sÕ†Íܶ\x1D¿\x07þ"
  b"\x01–Y¡r{À>ď¸;É¡"
  b"\x01–YÃ$#p؃\x03‡*¼¾Ž“"
  b"\x01—nøñ™y4°”UfD5oô"
  b"\x01—o\x07˜§p\x01†÷Á‡”\x0FD¥"
  b"\x01—o\x07í\x1C\x7F\x07Œ\x18\x1AZ\x15¨ýŠ"
  b"\x01šüÓ\rLq\x12²D›ü¾Ý‡\x10"
  b"\x01šüÓ]ä}\v½n”?Ú]tz"
  b"\x01šüÓ½l\x7FNŽ&ðR(áã\x1A"
  b"\x01šüÔ_ÃyÚ¹1â,Fÿâ”"
  b"\x01›Nü\x12Nu³¸‚ìñÎ\x07Ÿe"
  b"\x01œš\x12©Bu6«ê8\x03##¦"
  b"\x01œš\x13\x0EÉuj´C§î> 0ä"
  b"\x01œš\x13P*zè¬\x03øS̉\x04Ç"
  b"\x01œš\x13ˆJqs„÷w>\x1C\x1A‘Ó"
  b"\x01œš\x13ÈrxA·\vÕ—¬ŽÊ5"
  b"\x01œš\x14$âx\x17¨@KðQ@\e;"
  b"\x01œš\x14bªy¿¯\x02yˆq\x15½\x15"
  b"\x01œš\x14©ŠwY¥úh\x00ž\v\L"
  b"\x01œš\x14ïÂu8µ\x15Í\x08›Eèý"
  b"\x01œš\x15Btˆ‰Æ{¤2O*â"
  b"\x01œš\x15…¢}J¢ÊÚ\t\x18\x05\x17å"
  b"\x01œš\x15Áª\x7F­…ÿ©\x01TÎT\x01"
  b"\x01œš\x16iñuªŒÂ\x06Ä B¢°"
  b"\x01œš\x16ÊÚ\x7F“¾¦[šT Ýˆ"
  b"\x01œš\x19ë<t¢©‰)A‚û¼\"
  b"\x01œ³0ºÙuÞ¼\x10?Ðï\x012Ã"
  b"\x01œ³0ð©v ²I\x08\x16Ͻ¿ê"
  b"\x01œ³1(‰uΣJ@‡¤ÞÒ\x00"
  b"\x01œ³9—ÏyB‚ïŠÀ\v\x17E;"
  b"\x03\x1DwùmôC*Š”«<­\x12æT"
  b"\x031”—AÙJÆ€_ñV|λ«"
  b"\x03B¾,Ù G¡¾/ð¯–\x16NÀ"
  b"\x03cùîѧJ\x08ŒÆ¾D‘†ø˜"
  b"""
    \x04/-\n
    S™OÌ—¥â›*\x12¸»
    """
  b"\x05lR\rѲL.½}\/\x13Ç?"
  b"\x05~±EöyAȬi\x19[{&XB"
  b"\x06‘‰„\x06ÝC­ŸrÀ|"‘Nd"
  b"\x077t\x16ãþJ\x19´@[\x04SÑ<ý"
  b"\x07Üwn¯íJصE9:KF.û"
  b"\x07í—\x0EAF\t£e\x18Ž,äG8"
  b"\x08.¦\x06\vôL-ˆ‰œæK!\x10œ"
  b"""
    \n
    „¨\x1Eñ¼GŒ•¯ÿµ°øR5
    """
  b"""
    \n
    ¥S)jS@œ¯Ðx{G¤ý\x05
    """
  b"""
    \n
    º\x190>x@±èP^„Ž\x13ù
    """
  b"\nâ½Ã\x1F—D̶ԟÆU\x00ú."
  b"\vFÎ6“‹E-®Bæp¡Ô½ß"
  b"\fv-1¿\x1DG&€¿»SÒ\x13¬\x12"
  b"\x0E\x19µƒÐuLl°çZRQýìÂ"
  b"\x0F–{ìò¤@‹fZD“\t£á"
  b"\x11¨\x05ea%KR¦Â\e\t73ŽÝ"
  b"\x11Ãü°%,DB§ëCh]v\x05b"
  b"\x12\x07\x02c€NK÷žŸ{ƒßñÛ"
  b"\x12Ø{2HÂOE¾,¸©0\ŽT"
  b"\x13\x0E•Õ`RB" Ÿ@OæÀ\x17ú"
  b"\x15&MY11OL¡Ý¢éŒÕ†¾"
  b"\x15~Ÿ³øÈE¹›\x1C×p'â\tÍ"
  b"\x16H§ÔðãBþ’F!\x05Ÿ³\x06M"
  b"\x18=\x03îÛÇAZ¾º¯R~Å=}"
  b"\x19O\x06ÙWjMͪt£Â†¬¾“"
  b"\x1A¼\x0E&çïC„¿‘uɺ["
  b"\eÝy„\x14WL%”ŽÀ\x12†„•"
  b"\x1C¸œ…º\x15J$©²åGÙ\x08ëç"
  b"\x1DÑìðÎ\x14K9³à\x12`Ì\flI"
  b"""
    \x1F?Øy\x10\n
    @Ö¸>3ÜÞ+\fç
    """
  b"\x1FX¨¾¬\x0FD¶¶øOi9hjè"
  b" mðaÿPKfÓ’qÓv\rŠ"
  b"""
     ¬"lÍÒO~‡h\x12,…7\n
    Z
    """
  b" àa6’!B‹Ÿ’ˆi\x1F"
  b"!F&Qû¾M\x03–_šÓÈcFê"
  b"!U\x04M\t'N…ºúGw_òõõ"
  b""¢ÿ\x00å‰GNˆû\x08üª‚8W"
  b"#WÌ<g¹Méµ\x10Œä°EÏû"
  b"$êE­f\x00C>ŸgŒä{Ùs;"
  b"&\x02Òt‚>Cš‹Êf6É8@{"
  b"'m¬ø÷þN•–š\x18ª’\x05óŒ"
  b"'œùa±Ð@© \x0FdÓ£Ñû\x1D"
  b"'·šÇ\x0FdM'ˆ”\x19±°ürØ"
  b")ê\x17õ\tAM‡×Ž—®\rõ\f"
  b"*Ľš8ŽLóŽ\¾J™“ˆ-"
  b"*åz¡PBO恒\x05Ò\x06Jéû"
  b"+«\ÖŒxEF¼™\x02ÓìCdM"
  b",}W°vWC\x1Fº\x1CÕINÍ\x15K"
  b",ó:IFÓN ®^&<ªÒ\x03F"
  b"-YÆR3ªGÆŠ¸%‡F6\ra"
  b"-øÈióKCÓ’ÛÛ\x11ÿTœƒ"
  b".\x06Z*)\vIvšó4b\x13îòK"
  b"/¢â\x14´´Gj¼Â†KRX®I"
  b"/ês˜"êEá¢ø Ï\x11rý%"
  b"0\x12cþÄjAä›&Åû‰½.$"
  b"0ÙsÇF O\x1A•V\šÒ¦…Q"
  b"2ºö=ïÿNMUºï-NþŸ"
  b"2öF‡vßN䶱©ºw¥ª""
  b"4\x1E¶Î\x19 AŽ’Ç\x0E6Á¬»Ù"
  b"4[*1b&Jr»—ÿNŒ¬"
  b"5í¯6É:J¡¦\x139(«Ñt-"
  b"6\x1EQ\x1C¸\x02HVk´û\x0F~ŽT"
  b"67£*r›DFºèœöûԝ}"
  b"6Ve\x15àÄI¬«·<¥‹¯/*"
  b"""
    6^Sf[\x1FE\n
    ¬\n
    ×Ï\rp\x17H
    """
  b"8 mYQÖE\e‰3þÿåÖ"
  b"82h/bTDL½˜\x08‰Ñ‰_/"
  b"9¨ùàµcLÇ«;ÔÉ!Öb\x12"
  b":ÇŸÅ£³Lw¯„³ ÷x~‹"
  b";ëÐc–\x06HµfÌâcúœž"
  b">hó°°¼Kn“\x10_φ8îo"
  b"? Ó\x16íBF€§»Q\x1AÅB½"
  b"?¤h1\x1D`F\x1F‹4VšwXQ""
  b"@\x06rló‚H\r¤\x03ô\x04FŒA"
  b"@¼-)\v[BǶ+LþÁoMT"
  b"""
    A¬Yã'éA\e¸Gš\©\n
    m…
    """
  b"BZä)\e×Gÿ©N\x00Zh\x13\x1D«"
  b"DÌ\x19NŽuM}˜u\x04ÀþÖ7y"
  b"DÞF'÷ØI\x06ŒT…°¹\x02n"
  b"Eêü!ŽÂDh¯Ž¶‡9™üP"
  b"F»ŽíÃ\x12Kd‡¨\rò¶„Ô="
  b"GäÕè<yB±‘Öü¸è„(\n"
  b"Hrf*¿¾@\x00›öÖpi0«×"
  b"Häü?N®F\x05‰\x1Aìê†äp&"
  b"I7vÆXñLi¼"E†\x0Fj\x19"
  b"JÔdÏŠîEÿ¿B«ÉZ?Z"
  b"Jü§éÄG˜©…7\x08²\x08\x12¼"
  b"K-]\x0F9|N\x13ŽgÏ~`4±Ú"
  b"L"rç.éCä¿\fu|®Öô\x06"
  b"Lú\x15ªºëOè‰zL\x7F>LÛ\x03"
  b"M3¶³€\x15J\±ºûËx¿\eä"
  b"OLl›¹\x1DCXŽ,U?v}\x18ö"
  b"Q\x08q÷RàB\x13¯Dðp2\x021ˆ"
  b"Q‘GDlØJ~››6o?,ž$"
  b"Q¥ð§åŸD,­à\x14Ñ9ö'9"
  b"Rˆwoœ—O#×ÓÅä›-ê"
  b"SkéüBB\x07“\x08„\x1DN—\x10˜"
  b"SûScËïDÜŽOÙâv ~~"
  b"U'ŠˆÓÛDl»_³\x07~C]Q"
  b"Uþ\x19ÁóYAQ›q~\x0F¸"è"
  b"V”\t›8DÕº¿\vG¶\x0F>"
  b"VˆKΦMÙ¥ICaÃPg‡"
  b"VËñ\x14ïªHë\x1F\x17[ˆ•ãœ"
  b"X´<\x198¥G'“j˜ò·´}ª"
  b"Y›¿@rLG,¡Š«\rP\x00û\x12"
  b"ZAº„MüHR™\x07}Þcöƒb"
  b"Z߈\t\rOMÒ¢1o2úÖ\x1F‰"
  b"[Ç(ïCJ+›^\x18¶d*Œ!"
  b"^\x0FðÜÅ\x1FLï—W¤ÿ~VóM"
  b"^h…ìßWOl¡Ô´úôSþ\x04"
  b"_Òµ7üÐNh€‹à¬.> {"
  b"`›[ÃøN4‰‡]wÕŸEð"
  b"až‹DD˜HÛµyÁ0÷ö6}"
  b"cvÝ€}!DÔª@ýÈ*T""
  b"cw‰„:ÍC“¸Ã}•Oò©ú"
  b"d8ß(\x10ÃD-¶äPôÏ/ø\x03"
  b"eA#bÈsGÍ·ùñ¯ "\x18q"
  b"fM\tl‚gL¸¼3…Ù"$Æ8"
  b"h¸_ììÀEé½ 2<\x080œ`"
  b"hóôÈ©1@o§\x19NÏÐb\x0E\x15"
  b"i/\x11‹¢IB=¥‰Û!\rŽ¬Ç"
  b"i\x03<ÑÊN;Š‘\x1E¡a\x05^"
  b"lþ£¯õ±Ar¶"¹1Hí\x04“"
  b"m\x7FÛk6ÂF\x18„Êþ{ –œ‘"
  b"nþ;,ìÆN•³RÞM\x07´\x14r"
  b"""
    oÒäÏ\n
    kO>µ÷Oz*ìE\x17
    """
  b"p\x1A\x00 =¹N­¦?\x05o¸’NO"
  b"p"³9d}J\x10‰£˜\x16v‚<x"
  b"q Á4\x05òMy±\x1EÁ7ºÃn‹"
  b"qw¼‚RRG9„´? Yôõ·"
  b"qÒ·¡FŒNˆˆ¾«­"‚ót"
  b"r‰(šÈ"C›§ýp§Ã£Z¨"
  b"srÌ\x1E\x1DBDH®VFVLï³"
  b"u\x05lrŠLG}«zµÕ×3:a"
  b"un‡.b[Gšµ—ßÏ\x08á7Õ"
  b"u˜#ÜH\x04B5›g÷!¿¼¼±"
  b"x›ùMwøN³¼ÖE] Aöþ"
  b"""
    y,›«»WBÖŒšHÜ\e\n
    )g
    """
  b"y±šÃû+K?‹)¦‡Âý#."
  b"yénáÏYDtA7#Ï?V$"
  b"z8ŽW\x7F0K\x03“í§Ví뾿"
  b"|‰[)šÅH±•Js€Žá~U"
  b"}qnL[DBEœ\x062üÐj "
  b"}„õNäI…Ÿ\x18bh\føW$"
  b"}®+ÄHOðŽ\x03 \x14ïƒÁU"
  b"}½GMN‰M&–G²ö+vw'"
  b"~/UJQÇEœ ¥uÕý$½"
  b"\x7FÀ/þF‹NKµÇZ{¾¥¸\x18"
  b"\x17ý\x10˜¬MI¡ =qÖ\x1A¢Q"
  b"fPû» Já”E¹Ý\fèÕ\x05"
  b"ìcçÃ2@\x1C‹O²Kе2\x08"
  b"‚`ÈùpÃIK…\x08lI—\e®Ž"
  b"‚k\tS5J@Ó‡¶8˜¡ó\x10w"
  b"…ïÈ ~™@zž(“~\x18r\x19t"
  b"†®Ï\x05­òK…¡B}õM\x182ï"
  b"†Âi¤¢F¶‚\x1Dª\x1EùŸ&ê"
  b"‡]ó”äJMZ­@ÿ+wˆ"
  b"‡‹ýh(±JÍ ¼uÛG¢‚ö"
  b"‰ì‡r—\x11L[¸nÒ\x08ÔX¬†"
  b"Šmò\x01\x17ÿNá—ÑKïž0ôÇ"
  b"‹\x12¥\x19K:Fq¬.‚\x13ô?´º"
  b"‹É˜\x7FÏ8E#´"U69I^Ã"
  b"‹ÖUc-ØDh\x15ìŸ\x06dHK"
  b"""
    Ží>3_=JR©ÑT¯\x1Cw\n
    \n
    """
  b"yŽÆA{J¢•ƒôkej‰\x7F"
  b"È„–­5KÛ·á\x06c#ãØý"
  b"\x1D_cS(Ob±ôçCPNn"
  b"‘6}IÖKn•°ÈáRÿÛ˜"
  b"’9—?ù“O\x14ˆþû›è£ž|"
  b"’´Šš<„@j>‹Ùs²Åµ"
  b"’»ÿR;#Jð‰§, F~¼"
  b"“AÔY"\x16L\x18¯\x7Fo\x05øá\x1F"
  b"“{@ðF+LúžÉÂ!Üe®"
  b"“Þ_QV=Jº“gKGJí\x1C"
  b"•DuÈ\x19~Ow¾ýïDZ!¾f"
  b"•‚æmèJOi‹vXLÝ# "
  b"•Åßì6øHï¶\x04Z´€\x16ïL"
  b"–¹¶ b9FЊܤä8"›2"
  b"—ƒ!\x18\vUF"Ž.öÞεBl"
  b"—îpÄR²G@²µ'w\v–ôJ"
  b"™6ùw¸\x1FJ\v¬LèE\x1A2)"
  b"škÕ­$‹M* mÎ\x1F\x07©²Ö"
  b"›_’v™šGX§^y²)y?ú"
  b"›Ëˆ©4¨E§ƒ\x13þA\x1A\x14jö"
  b"Ÿ\x0F\x1FIÜ€LÖ›\x02=\x018_2,"
  b"Ÿ\x14x!\x17ÏHè¥ô“\x11B+‘Î"
  b" \x16ˆö\x16©E÷‰åo3bõO0"
  b" Ä)7‡tM\x1CŽš\rk º(Y"
  b"¢DTß'<BÑž}ÔÍ#\x01NÉ"
  b"¢¨îM–ôF\x01Š¾àH]5Œ£"
  b"¢¶¢*ÝÓM\x00‘åx¼ˆTmR"
  b"¢÷\t±pýJߥÕ\x04\x7F®\x1FÉá"
  b"£í[h\x08¦G^œÕò¿¥u"
  b"¤8ŠfºÝF\x0F—åt\x05êJ¬\x11"
  b"¥Çm“ï¯DV¾àÂ\x1C\x11„”_"
  b"©b\x05Ý»DI„·ç?\x0E)»‡„"
  b"©öö\x1A\x10ŠG.·86ó[恛"
  b"ªRœ”·@L\x02‡\x04¥ß"\x143Æ"
  b"ªä8\x18R\x17FÆ©ØŠ‹2nÀ%"
  b"¬k\x08\x00XÝ@\x17‘ßÒ\x18Øyþ"
  b"­\x00§‡‡÷Mç£s^<Š©¿Ê"
  b"®E´À\x1D·GF½ Jkš“\x0Fú"
  b"¯\x04«gvÏIî·ø”¤§\x03"
  b"¯R¹º60LzŽ\v[¡ÉiZ4"
  b"°¥\x03ÑùÚOÙˆí\x19J]]Å5"
  b"°»”M\x16ãE@žD‰¢¶\x11È\n"
  b"°ðú$¸ÄCSžŒ¿Þ\x1F£²v"
  b"±Jsv¹£E> <¢*à½ßŒ"
  b"²\x16X\x7Fþ%G¯„\x04Ôpà¿/6"
  b"³\x13€è0F\x1AšO£Á*j˜Ê"
  b"µ(t‡l\tC–¸:\x1DF\»]\x03"
  b"µL;|ÕzNŠ|µ^”\r\r~"
  b"¶AGu…ðM©“]Ê\x02ª‡å""
  b"¶^zá¤kH÷”HœSˆ\x06ý0"
  b"¶‘\x08€ÊÎHv¡OÛ·üO¦}"
  b"¶ ‹Þö G¡™\x17œh¸¾àq"
  b"¶õjN}TC_©nóÈøIÌ\x12"
  b"¹­ é5\x7FLg—^çŸ³ºJ"
  b"º5ü.ô©H€…Í\x13»Ú‚z•"
  b"º28+ª@eˆE/IBÂ5"
  b"º‘×z¹\x10DŸ¬„‘\x0Eêкú"
  b"º§\r\x0F›;M^¢Æê!TÐÝM"
  b"¼U(\x07\x1F\x7FE2¢€ÖV#>Ä7"
  b"¿…ïïX·AoAcà\x0EdÁü"
  b"À\x0E’_uîB.ž÷´î¬KìÛ"
  b"Àîv€3¯Hà¡è{2ƒ\x11^g"
  b"Áqö™aâCp¬©¬Ï\x01›e\x19"
  b"Á‹\x16Ö\x1E‡K\x0EªäKÎÝXC8"
  b"Ävñv»I\x1F£wo¹ ×4Û"
  b"Å[°\x17©nJ©¥ÆoõRiã!"
  b"ÉîñU„âGgŽ'\x1FþäÔ9Æ"
  b"Ê¢FØ&ÄCâ™pÅ»×vž:"
  b"Í,?g¨dGÇ®ŒÓ88ÊN"
  b"ÍÜ¢ô<ŸB=Œ›]êŸiûÞ"
  b"ÎÅ\x08¥7%HL+\x1A{\x11$ñÙ"
  b"ÎÝ\x11Ä ºKô˜»;‘à eÙ"
  b"ÏŒG\x11³OA£‚\x07E$\x00\x0Fõ""
  b"ЇS˜ï×Ip¸9Ã@7\fJ2"
  b"Ñ,ÏU?òF¹¹îc\x12j\e”&"
  b"Ñ”!Ž9vNG©ÐJ\eµc9\x05"
  b"Ò\rm­šKB”//Ö®Rª\x04"
  b"Òá,ž J[ùO°Æñµ\x1E"
  b"""
    Òð8\r·5C\n
    ®\x06|?°ÌØÎ
    """
  b"Ó¬%1ÕºHCŽÄ;ˆñŽëT"
  b"ÔHyt%èM´›KûÉ\x16[³"
  b"ÔWdn_>MSŠ¬\x11`Ž\x02Wû"
  b"Ô„ z©[L½·?*=Ðl\x0F"
  b"Ôöz0ÙZJ›˜ßÏÖ¶KÄQ"
  b"Õ\`þþ{O®Ÿî\x18xï³\x17ò"
  b"Õ^QžKMï¸BÑê/ý\x1F–"
  b"ÖQÃH(†A‹¹C=³\x0FØ_c"
  b"Ö_úR8HK\x1E¨Ê¤ÆÏËÎd"
  b"×|ÿ˜Q¤D~˜Õ¹@r×\x1Ax"
  b"Ø/ø©¨JN掕\x18Ñ}5ʸ"
  b"Øä5à.\x1EJz´ÛŽ¦V±Ìß"
  b"Ù‘ðãz¶D>–:í“ì\x00¬ª"
  b"Ú4«±/&E)Ÿ$ÍЫ¿\x7FÆ"
  b"ÚŽÐÑ\x03äBg¥võ;ôœr£"
  b"ÚÎ3·Æ^Bùˆ\v\x10jÿBj"
  b"Û\x1AúPo=B$½õç\x1Cµ4µ"
  b"Ým\x13{×ÃFVŽÁèºÚ˜ñç"
  b"ÝúzqûáA\x01º\x02_F@­J"
  b"ßßâÆ\e\x1CG,Ÿ\x15\x1E˜·°\x14\x06"
  b"๠‡<GC˜í¸‡Ô\x05æ"
  b"àðGÂÝ"NÝ£¨«0&¡pÿ"
  b"ᐢÛ7\x08C÷­¶«Ö\x19.‚Ÿ"
  b"áí\x08ýîA݇\x7FÈ~e:@Š"
  b"â¡Ý1q(M¬X]¸*\x05‚\x0F"
  b"""
    ã5Ö9|xOf‰\n
    è¤Àç„m
    """
  b"æR2\x02`\x1FKM°ƒ\x02;T\vmå"
  b"æÓ8,õÍKõ¢\x1D*–Ô¾Š$"
  b"çšÍrdáFìšÐ>YOà2¬"
  b"é6ÓÜöôDé ³|?b÷Ä"
  b"éb*ÑQýM}„\x08J0Üø\x00¢"
  b"ëȱ\x1D\x1EœN™–Ÿ–\x1CHK<¯"
  b"ëÔ(}¾âG;¿@+w\x06õÚd"
  b"í\x0FþíÄ‚B¿¦~»÷‚ëû\t"
  b"ï\x06V¥/ŸH¡µ}\x16Ô•d"
  b"ïp:wžöO\x17›¶u\x1E¨\x17"Ç"
  b"ïvý@._D¿¾q:71ë@\n"
  b"òÄÎó\f\fI\x16Ž¤4\tÇ,Fê"
  b"õ¡ÎâC|‡\x1A¯*‚“ö?"
  b"öw‰ý}ðC\x1C·å{ª\x17$Íî"
  b"öûP€`ÓKn¬G9æÅÓ¾y"
  b"÷\t‰—´2@¤ˆz›©\x03Þ¯ï"
  b"ù\x1Ej\x03Ç)C"ƒ\x1C­\x16:Ÿw›"
  b"ù=dF\x1C\x1AL\x00®Þ\x06ص\x08·z"
  b"ùÒÇk¯\rH<ŠwRÍSFx\x18"
  b"ùôXûC:G8±\x15\x07¢Âw‰ý"
  b"ú\x08øTCqB°•¸m#È·Øü"
  b"úTØkçdH\x18ž¤oY\x01ˆ®€"
  b"ü\x11味QL\x01ŸbŽ²\x11-jh"
  b"ü!í\x01›~Na·ÝÿmÿæWf"
  b"üQ‡ì»ÇF\x18Œ¯Ì¿’\f²ò"
  b"ý\x00üh£-NÊŸ¡\x05“E»\x02o"
  b"ýŽà<“H´µS\x16y`\x04¼1"
  b"ý©\x0FCê¾Mºµ\v\eÁ7\x0EþŠ"
  b"ý¾\x7Fغ@H“דּ¿jó\x15"
  b"þÊn\fí@3‡1\x7FÛ|…Ãy"
  b"""
    ÿ\x05;\x11\x0E\n
    Mo’\x1A ª.Õko
    """
  b"ÿ”Nº8¢HÈ \x02ˆ?…;·‡"
  b"ÿ¤\x02{ßàM`¾-«\x14Tªx°"
  b"ÿ¾÷õŸ\x12Bҩ߳࠷­ö"
  b"ÿæè\‰\x02K– ö\x1FÊ–\x1CÔ×"
  b"ÿúÄ\x14‹íB/µLØó›¸\x16©"
  b"\x01•®\x0FÚ‚{]°K0’ \x05<T"
  b"\x025G¢ˆ¨Hjä¤\x1AgµŽ/"
  b"CÛÇ4ÈhM,žE/\x17\x16’\x12"
  b"UT\x1Aýr»J”¦\x04#4…A%"
  b"f½Ö˜’ìHšŽ×Z\x19}÷ƒº"
  b"ÉÃð#SµM¬’d\x13HH\x03\e"
  b"ÝØ"oƒìAOŒþø9Å\x1CÆÏ"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.31 ms
(0.23%) 		1 
-- product-listing::property-group-filter::read
SELECT `property_group`.`id` as `property_group.id`, `property_group`.`display_type` as `property_group.displayType`, `property_group`.`sorting_type` as `property_group.sortingType`, `property_group`.`filterable` as `property_group.filterable`, `property_group`.`visible_on_product_detail_page` as `property_group.visibleOnProductDetailPage`, `property_group`.`created_at` as `property_group.createdAt`, `property_group`.`updated_at` as `property_group.updatedAt`, `property_group.translation.override_1.name`, `property_group.translation.name`, COALESCE(`property_group.translation.override_1.name`,`property_group.translation.name`) as `property_group.name`, `property_group.translation.override_1.description`, `property_group.translation.description`, COALESCE(`property_group.translation.override_1.description`,`property_group.translation.description`) as `property_group.description`, `property_group.translation.override_1.position`, `property_group.translation.position`, COALESCE(`property_group.translation.override_1.position`,`property_group.translation.position`) as `property_group.position`, `property_group.translation.override_1.customFields`, `property_group.translation.customFields`, COALESCE(`property_group.translation.override_1.customFields`,`property_group.translation.customFields`) as `property_group.customFields` FROM `property_group` LEFT JOIN (SELECT `property_group.translation`.`property_group_id`, `property_group.translation`.`name` as `property_group.translation.name`, `property_group.translation.override_1`.`name` as `property_group.translation.override_1.name`, `property_group.translation`.`description` as `property_group.translation.description`, `property_group.translation.override_1`.`description` as `property_group.translation.override_1.description`, `property_group.translation`.`position` as `property_group.translation.position`, `property_group.translation.override_1`.`position` as `property_group.translation.override_1.position`, `property_group.translation`.`custom_fields` as `property_group.translation.customFields`, `property_group.translation.override_1`.`custom_fields` as `property_group.translation.override_1.customFields` FROM `property_group_translation` `property_group.translation` LEFT JOIN `property_group_translation` `property_group.translation.override_1` ON `property_group.translation`.`property_group_id` = `property_group.translation.override_1`.`property_group_id` AND `property_group.translation.override_1`.`language_id` = ? WHERE `property_group.translation`.`language_id` = ?) `property_group.property_group_translation` ON `property_group.property_group_translation`.`property_group_id` = `property_group`.`id` WHERE ((`property_group`.`filterable` = ?)) AND (`property_group`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters: 
[
  b"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  b"2¨2\x06¼wM夬Žûl\x1CÌ="
  b"Nò<1}|H­„óÓôªAÛY"
  b"¢Ï··zVI\x01³ŽdÂê\x1FH´"
  b"I\x13ùÐ”L²€÷Îg\x04›%‹"
  b"""
    Gðª\x03^\n
    E¶€3›ÌR\x1DÕ
    """
  b"6Õߤ%ÛG=¡Öo“ÆIáé"
  b"\x01‘nZªô}6·¤äV}©ò\t"
  b"Ϥ\x18î,G¤˜\x04\x11wôÐÿ|"
  b"ü=‹¼ AA©¥ïüÒÂ7™<"
  b"ldG"³ŽEÜ‹Ë\x019i\x07Üè"
  b"\x1A€Zï|3C\x15‡þ†¿Í\x18\x1Fê"
  b"\x01œš\x12\x07±zž´\x1F\x14RŠŽ¸ˆ"
  b"ßýÿ´HFC©•\x7F®ìP£6¶"
  b"""
    1\x16\n
    ¬\x15\x10Cu»\x01ªÏƒ~MÍ
    """
  b"e¢ß\x7F‰ÍG\x1D‘‡û/iòùë"
  b"·¨ô:Q*Do›`\x00Ýâ™äŸ"
  b"éiƒr£¨GÄ’o—†µ\x18y\x04"
  b"\x1Dþ\x07Ã\x14·Lqº¬×þz\x11Ú"
  b"„•u\x12ldOÝ‹;÷ËëòÍ}"
  b"\x15«½‘=\rD]²\x04Á\x14Lèê "
  b"eZŽ\x7F: C±—¤høS/\x1E\x17"
  b"ürÌMk¥L\x0F¤¶ä)V9\x129"
  b"""
    —/á…æ\n
    C\f¦ßwË• ýÊ
    """
  b",ÚÏä\x1E¿C«¼\rX‹MKÂâ"
  b"QϹ’¥¯GŃXwTšn+/"
  b"\x7Fï0~ïSIÝ…ãòJ—ôS\x12"
  b"èÆ\x06±!¾E\x16¨L·ý \r&L"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.29 ms
(0.23%) 		1 
SELECT `acris_price_on_request`.`id` as `acris_price_on_request.id`, `acris_price_on_request`.`version_id` as `acris_price_on_request.versionId`, `acris_price_on_request`.`cms_page_id` as `acris_price_on_request.cmsPageId`, `acris_price_on_request`.`cms_page_version_id` as `acris_price_on_request.cmsPageVersionId`, `acris_price_on_request`.`active` as `acris_price_on_request.active`, `acris_price_on_request`.`priority` as `acris_price_on_request.priority`, `acris_price_on_request`.`default_type` as `acris_price_on_request.defaultType`, `acris_price_on_request`.`price_display` as `acris_price_on_request.priceDisplay`, `acris_price_on_request`.`cart_functionality` as `acris_price_on_request.cartFunctionality`, `acris_price_on_request`.`delivery_display` as `acris_price_on_request.deliveryDisplay`, `acris_price_on_request`.`price_meta_data` as `acris_price_on_request.priceMetaData`, `acris_price_on_request`.`bot_price_display` as `acris_price_on_request.botPriceDisplay`, `acris_price_on_request`.`info_text_position` as `acris_price_on_request.infoTextPosition`, `acris_price_on_request`.`request_button_type` as `acris_price_on_request.requestButtonType`, `acris_price_on_request`.`login_button_type` as `acris_price_on_request.loginButtonType`, `acris_price_on_request`.`use_for` as `acris_price_on_request.useFor`, `acris_price_on_request`.`request_form_position` as `acris_price_on_request.requestFormPosition`, `acris_price_on_request`.`request_cart_button_type` as `acris_price_on_request.requestCartButtonType`, `acris_price_on_request`.`request_cart_display_position` as `acris_price_on_request.requestCartDisplayPosition`, `acris_price_on_request`.`request_cart_icon` as `acris_price_on_request.requestCartIcon`, `acris_price_on_request`.`request_cart_icon_media_id` as `acris_price_on_request.requestCartIconMediaId`, `acris_price_on_request`.`icon_width` as `acris_price_on_request.iconWidth`, `acris_price_on_request`.`created_at` as `acris_price_on_request.createdAt`, `acris_price_on_request`.`updated_at` as `acris_price_on_request.updatedAt`, `acris_price_on_request.requestCartIconMedia`.`id` as `acris_price_on_request.requestCartIconMedia.id`, `acris_price_on_request.requestCartIconMedia`.`user_id` as `acris_price_on_request.requestCartIconMedia.userId`, `acris_price_on_request.requestCartIconMedia`.`media_folder_id` as `acris_price_on_request.requestCartIconMedia.mediaFolderId`, `acris_price_on_request.requestCartIconMedia`.`mime_type` as `acris_price_on_request.requestCartIconMedia.mimeType`, `acris_price_on_request.requestCartIconMedia`.`file_extension` as `acris_price_on_request.requestCartIconMedia.fileExtension`, `acris_price_on_request.requestCartIconMedia`.`uploaded_at` as `acris_price_on_request.requestCartIconMedia.uploadedAt`, `acris_price_on_request.requestCartIconMedia`.`file_name` as `acris_price_on_request.requestCartIconMedia.fileName`, `acris_price_on_request.requestCartIconMedia`.`file_size` as `acris_price_on_request.requestCartIconMedia.fileSize`, `acris_price_on_request.requestCartIconMedia`.`media_type` as `acris_price_on_request.requestCartIconMedia.mediaTypeRaw`, `acris_price_on_request.requestCartIconMedia`.`meta_data` as `acris_price_on_request.requestCartIconMedia.metaData`, `acris_price_on_request.requestCartIconMedia`.`config` as `acris_price_on_request.requestCartIconMedia.config`, `acris_price_on_request.requestCartIconMedia`.`path` as `acris_price_on_request.requestCartIconMedia.path`, `acris_price_on_request.requestCartIconMedia`.`private` as `acris_price_on_request.requestCartIconMedia.private`, `acris_price_on_request.requestCartIconMedia`.`thumbnails_ro` as `acris_price_on_request.requestCartIconMedia.thumbnailsRo`, `acris_price_on_request.requestCartIconMedia`.`file_hash` as `acris_price_on_request.requestCartIconMedia.fileHash`, `acris_price_on_request.requestCartIconMedia`.`created_at` as `acris_price_on_request.requestCartIconMedia.createdAt`, `acris_price_on_request.requestCartIconMedia`.`updated_at` as `acris_price_on_request.requestCartIconMedia.updatedAt`, `acris_price_on_request.requestCartIconMedia.translation.override_1.title`, `acris_price_on_request.requestCartIconMedia.translation.title`, COALESCE(`acris_price_on_request.requestCartIconMedia.translation.override_1.title`,`acris_price_on_request.requestCartIconMedia.translation.title`) as `acris_price_on_request.requestCartIconMedia.title`, `acris_price_on_request.requestCartIconMedia.translation.override_1.alt`, `acris_price_on_request.requestCartIconMedia.translation.alt`, COALESCE(`acris_price_on_request.requestCartIconMedia.translation.override_1.alt`,`acris_price_on_request.requestCartIconMedia.translation.alt`) as `acris_price_on_request.requestCartIconMedia.alt`, `acris_price_on_request.requestCartIconMedia.translation.override_1.customFields`, `acris_price_on_request.requestCartIconMedia.translation.customFields`, COALESCE(`acris_price_on_request.requestCartIconMedia.translation.override_1.customFields`,`acris_price_on_request.requestCartIconMedia.translation.customFields`) as `acris_price_on_request.requestCartIconMedia.customFields`, (SELECT GROUP_CONCAT(HEX(`acris_price_on_request.productStreams.mapping`.`product_stream_id`) SEPARATOR '||')
                  FROM `acris_price_on_request_product_stream` `acris_price_on_request.productStreams.mapping`
                  WHERE `acris_price_on_request.productStreams.mapping`.`price_on_request_id` = `acris_price_on_request`.`id` ) as `acris_price_on_request.productStreams.id_mapping`, `acris_price_on_request.translation.override_1.loginButtonText`, `acris_price_on_request.translation.loginButtonText`, COALESCE(`acris_price_on_request.translation.override_1.loginButtonText`,`acris_price_on_request.translation.loginButtonText`) as `acris_price_on_request.loginButtonText`, `acris_price_on_request.translation.override_1.formButtonText`, `acris_price_on_request.translation.formButtonText`, COALESCE(`acris_price_on_request.translation.override_1.formButtonText`,`acris_price_on_request.translation.formButtonText`) as `acris_price_on_request.formButtonText`, `acris_price_on_request.translation.override_1.requestCartButtonText`, `acris_price_on_request.translation.requestCartButtonText`, COALESCE(`acris_price_on_request.translation.override_1.requestCartButtonText`,`acris_price_on_request.translation.requestCartButtonText`) as `acris_price_on_request.requestCartButtonText`, `acris_price_on_request.translation.override_1.internalName`, `acris_price_on_request.translation.internalName`, COALESCE(`acris_price_on_request.translation.override_1.internalName`,`acris_price_on_request.translation.internalName`) as `acris_price_on_request.internalName`, `acris_price_on_request.translation.override_1.infoText`, `acris_price_on_request.translation.infoText`, COALESCE(`acris_price_on_request.translation.override_1.infoText`,`acris_price_on_request.translation.infoText`) as `acris_price_on_request.infoText`, `acris_price_on_request.translation.override_1.infoTextBefore`, `acris_price_on_request.translation.infoTextBefore`, COALESCE(`acris_price_on_request.translation.override_1.infoTextBefore`,`acris_price_on_request.translation.infoTextBefore`) as `acris_price_on_request.infoTextBefore`, `acris_price_on_request.translation.override_1.infoTextAfter`, `acris_price_on_request.translation.infoTextAfter`, COALESCE(`acris_price_on_request.translation.override_1.infoTextAfter`,`acris_price_on_request.translation.infoTextAfter`) as `acris_price_on_request.infoTextAfter`, `acris_price_on_request.translation.override_1.productBoxTextBefore`, `acris_price_on_request.translation.productBoxTextBefore`, COALESCE(`acris_price_on_request.translation.override_1.productBoxTextBefore`,`acris_price_on_request.translation.productBoxTextBefore`) as `acris_price_on_request.productBoxTextBefore`, `acris_price_on_request.translation.override_1.productBoxTextAfter`, `acris_price_on_request.translation.productBoxTextAfter`, COALESCE(`acris_price_on_request.translation.override_1.productBoxTextAfter`,`acris_price_on_request.translation.productBoxTextAfter`) as `acris_price_on_request.productBoxTextAfter`, `acris_price_on_request.translation.override_1.slotConfig`, `acris_price_on_request.translation.slotConfig`, COALESCE(`acris_price_on_request.translation.override_1.slotConfig`,`acris_price_on_request.translation.slotConfig`) as `acris_price_on_request.slotConfig`, `acris_price_on_request.translation.override_1.priceText`, `acris_price_on_request.translation.priceText`, COALESCE(`acris_price_on_request.translation.override_1.priceText`,`acris_price_on_request.translation.priceText`) as `acris_price_on_request.priceText` FROM `acris_price_on_request` LEFT JOIN `media` `acris_price_on_request.requestCartIconMedia` ON `acris_price_on_request`.`request_cart_icon_media_id` = `acris_price_on_request.requestCartIconMedia`.`id` LEFT JOIN (SELECT `acris_price_on_request.translation`.`acris_price_on_request_id`, `acris_price_on_request.translation`.`acris_price_on_request_version_id`, `acris_price_on_request.translation`.`internal_name` as `acris_price_on_request.translation.internalName`, `acris_price_on_request.translation.override_1`.`internal_name` as `acris_price_on_request.translation.override_1.internalName`, `acris_price_on_request.translation`.`login_button_text` as `acris_price_on_request.translation.loginButtonText`, `acris_price_on_request.translation.override_1`.`login_button_text` as `acris_price_on_request.translation.override_1.loginButtonText`, `acris_price_on_request.translation`.`form_button_text` as `acris_price_on_request.translation.formButtonText`, `acris_price_on_request.translation.override_1`.`form_button_text` as `acris_price_on_request.translation.override_1.formButtonText`, `acris_price_on_request.translation`.`request_cart_button_text` as `acris_price_on_request.translation.requestCartButtonText`, `acris_price_on_request.translation.override_1`.`request_cart_button_text` as `acris_price_on_request.translation.override_1.requestCartButtonText`, `acris_price_on_request.translation`.`slot_config` as `acris_price_on_request.translation.slotConfig`, `acris_price_on_request.translation.override_1`.`slot_config` as `acris_price_on_request.translation.override_1.slotConfig`, `acris_price_on_request.translation`.`info_text` as `acris_price_on_request.translation.infoText`, `acris_price_on_request.translation.override_1`.`info_text` as `acris_price_on_request.translation.override_1.infoText`, `acris_price_on_request.translation`.`info_text_before` as `acris_price_on_request.translation.infoTextBefore`, `acris_price_on_request.translation.override_1`.`info_text_before` as `acris_price_on_request.translation.override_1.infoTextBefore`, `acris_price_on_request.translation`.`info_text_after` as `acris_price_on_request.translation.infoTextAfter`, `acris_price_on_request.translation.override_1`.`info_text_after` as `acris_price_on_request.translation.override_1.infoTextAfter`, `acris_price_on_request.translation`.`product_box_text_before` as `acris_price_on_request.translation.productBoxTextBefore`, `acris_price_on_request.translation.override_1`.`product_box_text_before` as `acris_price_on_request.translation.override_1.productBoxTextBefore`, `acris_price_on_request.translation`.`product_box_text_after` as `acris_price_on_request.translation.productBoxTextAfter`, `acris_price_on_request.translation.override_1`.`product_box_text_after` as `acris_price_on_request.translation.override_1.productBoxTextAfter`, `acris_price_on_request.translation`.`price_text` as `acris_price_on_request.translation.priceText`, `acris_price_on_request.translation.override_1`.`price_text` as `acris_price_on_request.translation.override_1.priceText` FROM `acris_price_on_request_translation` `acris_price_on_request.translation` LEFT JOIN `acris_price_on_request_translation` `acris_price_on_request.translation.override_1` ON `acris_price_on_request.translation`.`acris_price_on_request_id` = `acris_price_on_request.translation.override_1`.`acris_price_on_request_id` AND `acris_price_on_request.translation.override_1`.`language_id` = ? AND `acris_price_on_request.translation`.`acris_price_on_request_version_id` = `acris_price_on_request.translation.override_1`.`acris_price_on_request_version_id` WHERE `acris_price_on_request.translation`.`language_id` = ?) `acris_price_on_request.acris_price_on_request_translation` ON `acris_price_on_request.acris_price_on_request_translation`.`acris_price_on_request_id` = `acris_price_on_request`.`id` AND `acris_price_on_request.acris_price_on_request_translation`.`acris_price_on_request_version_id` = `acris_price_on_request`.`version_id` LEFT JOIN (SELECT `acris_price_on_request.requestCartIconMedia.translation`.`media_id`, `acris_price_on_request.requestCartIconMedia.translation`.`alt` as `acris_price_on_request.requestCartIconMedia.translation.alt`, `acris_price_on_request.requestCartIconMedia.translation.override_1`.`alt` as `acris_price_on_request.requestCartIconMedia.translation.override_1.alt`, `acris_price_on_request.requestCartIconMedia.translation`.`title` as `acris_price_on_request.requestCartIconMedia.translation.title`, `acris_price_on_request.requestCartIconMedia.translation.override_1`.`title` as `acris_price_on_request.requestCartIconMedia.translation.override_1.title`, `acris_price_on_request.requestCartIconMedia.translation`.`custom_fields` as `acris_price_on_request.requestCartIconMedia.translation.customFields`, `acris_price_on_request.requestCartIconMedia.translation.override_1`.`custom_fields` as `acris_price_on_request.requestCartIconMedia.translation.override_1.customFields` FROM `media_translation` `acris_price_on_request.requestCartIconMedia.translation` LEFT JOIN `media_translation` `acris_price_on_request.requestCartIconMedia.translation.override_1` ON `acris_price_on_request.requestCartIconMedia.translation`.`media_id` = `acris_price_on_request.requestCartIconMedia.translation.override_1`.`media_id` AND `acris_price_on_request.requestCartIconMedia.translation.override_1`.`language_id` = ? WHERE `acris_price_on_request.requestCartIconMedia.translation`.`language_id` = ?) `acris_price_on_request.requestCartIconMedia.media_translation` ON `acris_price_on_request.requestCartIconMedia.media_translation`.`media_id` = `acris_price_on_request.requestCartIconMedia`.`id` WHERE (`acris_price_on_request`.`version_id` = ?) AND (`acris_price_on_request`.`id` IN (?))
Parameters: 
[
  b"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01Œè‚¯ç{TƒÔaò¹w\x11Õ"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.26 ms
(0.22%) 		1 
-- manufacturer-aggregation::read
SELECT `product_manufacturer`.`id` as `product_manufacturer.id`, `product_manufacturer`.`version_id` as `product_manufacturer.versionId`, `product_manufacturer`.`media_id` as `product_manufacturer.mediaId`, `product_manufacturer`.`created_at` as `product_manufacturer.createdAt`, `product_manufacturer`.`updated_at` as `product_manufacturer.updatedAt`, `product_manufacturer.translation.override_1.name`, `product_manufacturer.translation.name`, COALESCE(`product_manufacturer.translation.override_1.name`,`product_manufacturer.translation.name`) as `product_manufacturer.name`, `product_manufacturer.translation.override_1.link`, `product_manufacturer.translation.link`, COALESCE(`product_manufacturer.translation.override_1.link`,`product_manufacturer.translation.link`) as `product_manufacturer.link`, `product_manufacturer.translation.override_1.description`, `product_manufacturer.translation.description`, COALESCE(`product_manufacturer.translation.override_1.description`,`product_manufacturer.translation.description`) as `product_manufacturer.description`, `product_manufacturer.translation.override_1.customFields`, `product_manufacturer.translation.customFields`, COALESCE(`product_manufacturer.translation.override_1.customFields`,`product_manufacturer.translation.customFields`) as `product_manufacturer.customFields` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.`product_manufacturer_id`, `product_manufacturer.translation`.`product_manufacturer_version_id`, `product_manufacturer.translation`.`link` as `product_manufacturer.translation.link`, `product_manufacturer.translation.override_1`.`link` as `product_manufacturer.translation.override_1.link`, `product_manufacturer.translation`.`name` as `product_manufacturer.translation.name`, `product_manufacturer.translation.override_1`.`name` as `product_manufacturer.translation.override_1.name`, `product_manufacturer.translation`.`description` as `product_manufacturer.translation.description`, `product_manufacturer.translation.override_1`.`description` as `product_manufacturer.translation.override_1.description`, `product_manufacturer.translation`.`custom_fields` as `product_manufacturer.translation.customFields`, `product_manufacturer.translation.override_1`.`custom_fields` as `product_manufacturer.translation.override_1.customFields` FROM `product_manufacturer_translation` `product_manufacturer.translation` LEFT JOIN `product_manufacturer_translation` `product_manufacturer.translation.override_1` ON `product_manufacturer.translation`.`product_manufacturer_id` = `product_manufacturer.translation.override_1`.`product_manufacturer_id` AND `product_manufacturer.translation.override_1`.`language_id` = ? AND `product_manufacturer.translation`.`product_manufacturer_version_id` = `product_manufacturer.translation.override_1`.`product_manufacturer_version_id` 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"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01‘nL1´{Q‚ \x18†0\x028^"
  b"\x01œš\x0EÅ\x06s\x15¢vý*(]×í"
  b"\x028\x07NJQJ]œ"|\x00ž¾"é"
  b"\x05ÑwÁäaJŽ³§9Ž¡õ÷\x7F"
  b"\x08s\x17O¸+L¿‹üîÞÉeŸV"
  b"\x14qfÏ\x08îE§³]+Ý@»"
  b"\x1D÷¯àXMK~„‰Æíx\\x0F"
  b"1\x1AἿ¶F\x15˜$ÿxþ„ÐÆ"
  b"<nëì4\x01K0¥ˆôÚ­]Šf"
  b"=ë™f>òCª\x17Ø>Ší´ê"
  b">\x05\x15W\x1E¼@›ƒù/WmÞFJ"
  b"G‰¹\x00qìAóžfÞõ´²<ì"
  b"W¯¶)(~O\x04¡k/Q~ä€Ä"
  b"“âµàœBG¦¼\x12\x19\x0EXXŸ"
  b"”qS±Q=N\x19–q\x0F†E*-‰"
  b"•/ž`C¦C˵ù/áFâÕM"
  b"–\x1FÿÎuENc„ŽÏï·lÅ"
  b"£~ÐÄ—ÂFÌ¡ŸR¹©<ø¤"
  b"¤J)Cp³Kqµè\x05\fýñ#~"
  b"¬„RUš MJ‰hJ\tûã®õ"
  b"°\x1C·v’EGë³+mº%çYë"
  b"""
    ß´•MÑ®C­„{\x0EjN\n
    Ý
    """
  b"åD@Ž–»F\x11°\x10™{¯Ž?ý"
  b"ò•ÓÀEÝG0¸w\x13AGVVw"
  b"ôTßyÆjLæ·ÏøË\x7F†µ”"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.91 ms
(0.16%) 		1 
-- seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND ((seo_path_info = ? OR seo_path_info = ?))
Parameters: 
[
  b"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"Zˆ\§³@`ŽË¿•w;ö?"
  "widgets/cms/navigation/d34158c3ecd346b69cd5c0c7a50cd4b0/filter"
  "widgets/cms/navigation/d34158c3ecd346b69cd5c0c7a50cd4b0/filter/"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.75 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.override_1.label`, `product_sorting.translation.label`, COALESCE(`product_sorting.translation.override_1.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`, `product_sorting.translation.override_1`.`label` as `product_sorting.translation.override_1.label` FROM `product_sorting_translation` `product_sorting.translation` LEFT JOIN `product_sorting_translation` `product_sorting.translation.override_1` ON `product_sorting.translation`.`product_sorting_id` = `product_sorting.translation.override_1`.`product_sorting_id` AND `product_sorting.translation.override_1`.`language_id` = ? 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"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"r+Ü"ÍŽI=„=pX\x10CRí"
  b"\v—™\x12ôÔE³PgˆÃÏ"
  b"ÑrýV\x08âA-(Ž£†"\x1Eå"
  b""dô?ǪG,­\x01\x1EA:Q§¨"
  b"\x10¶ã‡/†FnŒZå¤\x05øÏé"
  b"wióS\x00\x07IF­\f,~A_ØÑ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.67 ms
(0.12%) 		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"\x01Œè€\x0E\x1Ar—ŽLÊÈÔøÈ9"
  b"0žwäÂCJô¾ü\x08üõ\x04¡Á"
  b"™\x18¥ërGCì\x10‹ \x00KW³"
  b"Ù·ªÂÛJB¹ \x19üöyÐý"
  b"\]Â\x19/±EØ®\f»“öÇ€p"
  b"Ê\x04›hœ¾B†˜@ï\x12µ]Cø"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.64 ms
(0.11%) 		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.override_1.label`, `product_sorting.translation.label`, COALESCE(`product_sorting.translation.override_1.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`, `product_sorting.translation.override_1`.`label` as `product_sorting.translation.override_1.label` FROM `product_sorting_translation` `product_sorting.translation` LEFT JOIN `product_sorting_translation` `product_sorting.translation.override_1` ON `product_sorting.translation`.`product_sorting_id` = `product_sorting.translation.override_1`.`product_sorting_id` AND `product_sorting.translation.override_1`.`language_id` = ? 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"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x10¶ã‡/†FnŒZå¤\x05øÏé"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.53 ms
(0.09%) 		1 
SELECT 1 FROM `acris_price_on_request` WHERE `active` = 1 AND `bot_price_display` = ? LIMIT 1
Parameters: 
[
  "show"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.52 ms
(0.09%) 		1 
SELECT `acris_price_on_request`.`id` FROM `acris_price_on_request` LEFT JOIN `acris_price_on_request_rule` `acris_price_on_request.rules.mapping` ON `acris_price_on_request`.`id` = `acris_price_on_request.rules.mapping`.`price_on_request_id`  LEFT JOIN `rule` `acris_price_on_request.rules` ON `acris_price_on_request.rules.mapping`.`rule_id` = `acris_price_on_request.rules`.`id`  WHERE (`acris_price_on_request`.`version_id` = ?) AND (((`acris_price_on_request`.`active` = ? AND (`acris_price_on_request.rules`.`id` <=> ? OR (`acris_price_on_request.rules`.`id` IN (?, ?, ?, ?, ?, ?)))))) GROUP BY `acris_price_on_request`.`id` ORDER BY LENGTH(`acris_price_on_request`.`priority`) DESC, MAX(`acris_price_on_request`.`priority`) DESC
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  true
  null
  b"\x01Œè€\x0E\x1Ar—ŽLÊÈÔøÈ9"
  b"0žwäÂCJô¾ü\x08üõ\x04¡Á"
  b"™\x18¥ërGCì\x10‹ \x00KW³"
  b"Ù·ªÂÛJB¹ \x19üöyÐý"
  b"\]Â\x19/±EØ®\f»“öÇ€p"
  b"Ê\x04›hœ¾B†˜@ï\x12µ]Cø"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.47 ms
(0.08%) 		1 
SELECT `acris_price_on_request_request_cart`.`id`, `acris_price_on_request_request_cart`.`auto_increment`, `acris_price_on_request_request_cart`.`request_number` FROM `acris_price_on_request_request_cart` WHERE ((`acris_price_on_request_request_cart`.`customer_id` <=> ? AND `acris_price_on_request_request_cart`.`sales_channel_id` = ? AND (`acris_price_on_request_request_cart`.`status` IN (?))))
Parameters: 
[
  null
  b"Zˆ\§³@`ŽË¿•w;ö?"
  "draft"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.47 ms
(0.08%) 		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.44 ms
(0.08%) 		1 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"Zˆ\§³@`ŽË¿•w;ö?"
  "b6fGep5l7wHqUY2RuatNJN9IJuweUFuc"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.44 ms
(0.08%) 		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"Zˆ\§³@`ŽË¿•w;ö?"
  b"""
    iB­\n
    à\x07D\x17´z\x19(Íxé]
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.43 ms
(0.08%) 		1 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.34 ms
(0.06%) 		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"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"Zˆ\§³@`ŽË¿•w;ö?"
  "/widgets/cms/navigation/d34158c3ecd346b69cd5c0c7a50cd4b0/filter"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.34 ms
(0.06%) 		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"ÓAXÃìÓF¶œÕÀÇ¥\fÔ°"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.06%) 		1 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(0.05%) 		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.26 ms
(0.05%) 		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.22 ms
(0.04%) 		1 
-- product-listing-route::category-loading::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`product_stream_id` as `category.productStreamId` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"ÓAXÃìÓF¶œÕÀÇ¥\fÔ°"
]
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.