GET https://ernstesdesign.de/widgets/search/filter?only-aggregations=1&reduce-aggregations=1&search=schwarz

Response
200 OK
Browse referrer URL
IP
188.61.92.216
Profiled on
Token
2b0911

Query Metrics

54 Database Queries
52 Different statements
174.56 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
108.03 ms
(61.89%) 		1 
# search::detect-keywords
SELECT keyword, IF (keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ?, 1, 0) as '0' FROM product_keyword_dictionary WHERE (language_id = ?) AND ((keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR keyword LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ? OR reversed LIKE ?)) ORDER BY keyword ASC
Parameters: 
[
  "shwarz%"
  "s_hwarz%"
  "s__hwarz%"
  "swarz%"
  "s_warz%"
  "s__warz%"
  "scharz%"
  "sch_arz%"
  "sch__arz%"
  "schrz%"
  "sch_rz%"
  "sch__rz%"
  "schwaz%"
  "schwa_z%"
  "schwa__z%"
  "schwa%"
  "schwa_%"
  "schwa__%"
  "zawhcs%"
  "z_awhcs%"
  "z__awhcs%"
  "zwhcs%"
  "z_whcs%"
  "z__whcs%"
  "zrahcs%"
  "zra_hcs%"
  "zra__hcs%"
  "zracs%"
  "zra_cs%"
  "zra__cs%"
  "zrawhs%"
  "zrawh_s%"
  "zrawh__s%"
  "zrawh%"
  "zrawh_%"
  "zrawh__%"
  b"/»_ââšMpªXTÎ|ãâ\v"
  "shwarz%"
  "s_hwarz%"
  "s__hwarz%"
  "swarz%"
  "s_warz%"
  "s__warz%"
  "scharz%"
  "sch_arz%"
  "sch__arz%"
  "schrz%"
  "sch_rz%"
  "sch__rz%"
  "schwaz%"
  "schwa_z%"
  "schwa__z%"
  "schwa%"
  "schwa_%"
  "schwa__%"
  "zawhcs%"
  "z_awhcs%"
  "z__awhcs%"
  "zwhcs%"
  "z_whcs%"
  "z__whcs%"
  "zrahcs%"
  "zra_hcs%"
  "zra__hcs%"
  "zracs%"
  "zra_cs%"
  "zra__cs%"
  "zrawhs%"
  "zrawh_s%"
  "zrawh__s%"
  "zrawh%"
  "zrawh_%"
  "zrawh__%"
]
View formatted query    View runnable query    Explain query    View query backtrace
13.20 ms
(7.56%) 		1 
# merchant-listing::aggregation::radius
SELECT COUNT(DISTINCT `moorl_merchant`.`active`) as `radius` FROM `moorl_merchant` LEFT JOIN `moorl_merchant_sales_channel` `moorl_merchant.salesChannels.mapping` ON `moorl_merchant`.`id` = `moorl_merchant.salesChannels.mapping`.`moorl_merchant_id`  LEFT JOIN `moorl_merchant_customer` `moorl_merchant.customers` ON `moorl_merchant`.`id` = `moorl_merchant.customers`.`moorl_merchant_id` INNER JOIN (SELECT SUM(IF(COALESCE(`moorl_merchant.translation.descriptionHtml`) = ? , '1', 0) + IF(COALESCE(`moorl_merchant.translation.descriptionHtml`) LIKE ? , '0.5', 0) + IF(COALESCE(`moorl_merchant.translation.seoUrl`) = ? , '1', 0) + IF(COALESCE(`moorl_merchant.translation.seoUrl`) LIKE ? , '0.5', 0) + IF(COALESCE(`moorl_merchant.translation.name`) = ? , '500', 0) + IF(COALESCE(`moorl_merchant.translation.name`) LIKE ? , '250', 0) + IF(COALESCE(`moorl_merchant.translation.teaser`) = ? , '1', 0) + IF(COALESCE(`moorl_merchant.translation.teaser`) LIKE ? , '0.5', 0) + IF(COALESCE(`moorl_merchant.translation.keywords`) = ? , '1', 0) + IF(COALESCE(`moorl_merchant.translation.keywords`) LIKE ? , '0.5', 0) + IF(COALESCE(`moorl_merchant.translation.description`) = ? , '1', 0) + IF(COALESCE(`moorl_merchant.translation.description`) LIKE ? , '0.5', 0) + IF(COALESCE(`moorl_merchant.translation.metaTitle`) = ? , '1', 0) + IF(COALESCE(`moorl_merchant.translation.metaTitle`) LIKE ? , '0.5', 0) + IF(COALESCE(`moorl_merchant.translation.metaDescription`) = ? , '1', 0) + IF(COALESCE(`moorl_merchant.translation.metaDescription`) LIKE ? , '0.5', 0) + IF(COALESCE(`moorl_merchant.translation.slotConfig`) = ? , '1', 0) + IF(COALESCE(`moorl_merchant.translation.slotConfig`) LIKE ? , '0.5', 0)) / COUNT(moorl_merchant.id) as _score, `moorl_merchant`.`id` FROM `moorl_merchant` LEFT JOIN `moorl_merchant_sales_channel` `moorl_merchant.salesChannels.mapping` ON `moorl_merchant`.`id` = `moorl_merchant.salesChannels.mapping`.`moorl_merchant_id`  LEFT JOIN `moorl_merchant_customer` `moorl_merchant.customers` ON `moorl_merchant`.`id` = `moorl_merchant.customers`.`moorl_merchant_id` LEFT JOIN (SELECT `moorl_merchant.translation`.`moorl_merchant_id`, `moorl_merchant.translation`.`description_html` as `moorl_merchant.translation.descriptionHtml`, `moorl_merchant.translation`.`seo_url` as `moorl_merchant.translation.seoUrl`, `moorl_merchant.translation`.`name` as `moorl_merchant.translation.name`, `moorl_merchant.translation`.`teaser` as `moorl_merchant.translation.teaser`, `moorl_merchant.translation`.`keywords` as `moorl_merchant.translation.keywords`, `moorl_merchant.translation`.`description` as `moorl_merchant.translation.description`, `moorl_merchant.translation`.`meta_title` as `moorl_merchant.translation.metaTitle`, `moorl_merchant.translation`.`meta_description` as `moorl_merchant.translation.metaDescription`, `moorl_merchant.translation`.`slot_config` as `moorl_merchant.translation.slotConfig` FROM `moorl_merchant_translation` `moorl_merchant.translation` WHERE `moorl_merchant.translation`.`language_id` = ?) `moorl_merchant.moorl_merchant_translation` ON `moorl_merchant.moorl_merchant_translation`.`moorl_merchant_id` = `moorl_merchant`.`id` LEFT JOIN `sales_channel` `moorl_merchant.salesChannels` ON `moorl_merchant.salesChannels.mapping`.`sales_channel_id` = `moorl_merchant.salesChannels`.`id`  WHERE (((`moorl_merchant`.`active` = ? AND (`moorl_merchant.salesChannels`.`id` <=> ? OR `moorl_merchant.salesChannels`.`id` = ?) AND `moorl_merchant.customers`.`customer_id` <=> ? AND `moorl_merchant`.`customer_group_id` <=> ?))) AND (COALESCE(`moorl_merchant.translation.descriptionHtml`) = ? OR COALESCE(`moorl_merchant.translation.descriptionHtml`) LIKE ? OR COALESCE(`moorl_merchant.translation.seoUrl`) = ? OR COALESCE(`moorl_merchant.translation.seoUrl`) LIKE ? OR COALESCE(`moorl_merchant.translation.name`) = ? OR COALESCE(`moorl_merchant.translation.name`) LIKE ? OR COALESCE(`moorl_merchant.translation.teaser`) = ? OR COALESCE(`moorl_merchant.translation.teaser`) LIKE ? OR COALESCE(`moorl_merchant.translation.keywords`) = ? OR COALESCE(`moorl_merchant.translation.keywords`) LIKE ? OR COALESCE(`moorl_merchant.translation.description`) = ? OR COALESCE(`moorl_merchant.translation.description`) LIKE ? OR COALESCE(`moorl_merchant.translation.metaTitle`) = ? OR COALESCE(`moorl_merchant.translation.metaTitle`) LIKE ? OR COALESCE(`moorl_merchant.translation.metaDescription`) = ? OR COALESCE(`moorl_merchant.translation.metaDescription`) LIKE ? OR COALESCE(`moorl_merchant.translation.slotConfig`) = ? OR COALESCE(`moorl_merchant.translation.slotConfig`) LIKE ?) GROUP BY id HAVING _score >= ? ORDER BY _score DESC) score_table ON score_table.`id` = `moorl_merchant`.`id`  LEFT JOIN `sales_channel` `moorl_merchant.salesChannels` ON `moorl_merchant.salesChannels.mapping`.`sales_channel_id` = `moorl_merchant.salesChannels`.`id`  WHERE ((`moorl_merchant`.`active` = ? AND (`moorl_merchant.salesChannels`.`id` <=> ? OR `moorl_merchant.salesChannels`.`id` = ?) AND `moorl_merchant.customers`.`customer_id` <=> ? AND `moorl_merchant`.`customer_group_id` <=> ?))
Parameters: 
[
  "schwarz"
  "%schwarz%"
  "schwarz"
  "%schwarz%"
  "schwarz"
  "%schwarz%"
  "schwarz"
  "%schwarz%"
  "schwarz"
  "%schwarz%"
  "schwarz"
  "%schwarz%"
  "schwarz"
  "%schwarz%"
  "schwarz"
  "%schwarz%"
  "schwarz"
  "%schwarz%"
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  null
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  null
  null
  "schwarz"
  "%schwarz%"
  "schwarz"
  "%schwarz%"
  "schwarz"
  "%schwarz%"
  "schwarz"
  "%schwarz%"
  "schwarz"
  "%schwarz%"
  "schwarz"
  "%schwarz%"
  "schwarz"
  "%schwarz%"
  "schwarz"
  "%schwarz%"
  "schwarz"
  "%schwarz%"
  0.5
  true
  null
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  null
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
7.81 ms
(4.48%) 		1 
# search-page::aggregation::price
SELECT MIN(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule9986489395d84086ba454e58b3fb0cd3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruled32beefb72e943dc9ed726ccf77b03a2.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulee4382fa297674cb98d82dc29b451c919.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule0dff832b47e34b089a714b0b0fd3d6ca.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule2b941507237248d2973e450c493f4e34.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule5ef1b0cdc8d04b2784fb093d81f229aa.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule9e07b08e0f1446298608bf1bb807c511.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule9f50bea2f50840f6a238fcc2f47d69c5.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulea77b2283528c43e18f85502eb96e0bd5.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulec71c623517794cedba416ef5711a7a52.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleda3ac5a0bb8e4657a78e9b98f5656fd5.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`, "$.rule9986489395d84086ba454e58b3fb0cd3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruled32beefb72e943dc9ed726ccf77b03a2.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulee4382fa297674cb98d82dc29b451c919.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule0dff832b47e34b089a714b0b0fd3d6ca.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule2b941507237248d2973e450c493f4e34.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule5ef1b0cdc8d04b2784fb093d81f229aa.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule9e07b08e0f1446298608bf1bb807c511.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule9f50bea2f50840f6a238fcc2f47d69c5.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulea77b2283528c43e18f85502eb96e0bd5.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulec71c623517794cedba416ef5711a7a52.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleda3ac5a0bb8e4657a78e9b98f5656fd5.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`, "$.rule9986489395d84086ba454e58b3fb0cd3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruled32beefb72e943dc9ed726ccf77b03a2.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulee4382fa297674cb98d82dc29b451c919.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule0dff832b47e34b089a714b0b0fd3d6ca.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule2b941507237248d2973e450c493f4e34.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule5ef1b0cdc8d04b2784fb093d81f229aa.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule9e07b08e0f1446298608bf1bb807c511.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule9f50bea2f50840f6a238fcc2f47d69c5.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulea77b2283528c43e18f85502eb96e0bd5.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulec71c623517794cedba416ef5711a7a52.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleda3ac5a0bb8e4657a78e9b98f5656fd5.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`, "$.rule9986489395d84086ba454e58b3fb0cd3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruled32beefb72e943dc9ed726ccf77b03a2.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulee4382fa297674cb98d82dc29b451c919.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule0dff832b47e34b089a714b0b0fd3d6ca.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule2b941507237248d2973e450c493f4e34.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule5ef1b0cdc8d04b2784fb093d81f229aa.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule9e07b08e0f1446298608bf1bb807c511.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule9f50bea2f50840f6a238fcc2f47d69c5.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulea77b2283528c43e18f85502eb96e0bd5.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulec71c623517794cedba416ef5711a7a52.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleda3ac5a0bb8e4657a78e9b98f5656fd5.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_search_keyword` `product.searchKeywords` ON `product`.`id` = `product.searchKeywords`.`product_id` AND `product`.version_id = `product.searchKeywords`.product_version_id INNER JOIN (SELECT SUM(IF(`product.searchKeywords`.`keyword` = ? , '0.9' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` LIKE ? , '1' * `product.searchKeywords`.`ranking`, 0)) / COUNT(product.id) as _score, `product`.`id`, `product`.`version_id` 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_search_keyword` `product.searchKeywords` ON `product`.`id` = `product.searchKeywords`.`product_id` AND `product`.version_id = `product.searchKeywords`.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.searchKeywords`.`language_id` = ? AND `product.searchKeywords`.`keyword` IN (?, ?, ?, ?, ?, ?)) AND NOT (`product`.`display_group` <=> ?))) AND (`product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` LIKE ?) GROUP BY id, version_id HAVING _score >= ? ORDER BY _score DESC) score_table ON score_table.`id` = `product`.`id` AND score_table.`version_id` = `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.searchKeywords`.`language_id` = ? AND `product.searchKeywords`.`keyword` IN (?, ?, ?, ?, ?, ?)) AND NOT (`product`.`display_group` <=> ?)))
Parameters: 
[
  "Schwarz"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "%schwarz%"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  20
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  true
  b"/»_ââšMpªXTÎ|ãâ\v"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "Schwarz"
  null
  "Schwarz"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "%schwarz%"
  0.5
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  20
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  true
  b"/»_ââšMpªXTÎ|ãâ\v"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "Schwarz"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
6.24 ms
(3.57%) 		1 
# search-page::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_search_keyword` `product.searchKeywords` ON `product`.`id` = `product.searchKeywords`.`product_id` AND `product`.version_id = `product.searchKeywords`.product_version_id INNER JOIN (SELECT SUM(IF(`product.searchKeywords`.`keyword` = ? , '0.9' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` LIKE ? , '1' * `product.searchKeywords`.`ranking`, 0)) / COUNT(product.id) as _score, `product`.`id`, `product`.`version_id` 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_search_keyword` `product.searchKeywords` ON `product`.`id` = `product.searchKeywords`.`product_id` AND `product`.version_id = `product.searchKeywords`.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.searchKeywords`.`language_id` = ? AND `product.searchKeywords`.`keyword` IN (?, ?, ?, ?, ?, ?)) AND NOT (`product`.`display_group` <=> ?))) AND (`product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` LIKE ?) GROUP BY id, version_id HAVING _score >= ? ORDER BY _score DESC) score_table ON score_table.`id` = `product`.`id` AND score_table.`version_id` = `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.searchKeywords`.`language_id` = ? AND `product.searchKeywords`.`keyword` IN (?, ?, ?, ?, ?, ?)) AND NOT (`product`.`display_group` <=> ?))) GROUP BY `product.properties`.`id`
Parameters: 
[
  "Schwarz"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "%schwarz%"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  20
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  true
  b"/»_ââšMpªXTÎ|ãâ\v"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "Schwarz"
  null
  "Schwarz"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "%schwarz%"
  0.5
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  20
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  true
  b"/»_ââšMpªXTÎ|ãâ\v"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "Schwarz"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
5.82 ms
(3.33%) 		1 
# search-page::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_search_keyword` `product.searchKeywords` ON `product`.`id` = `product.searchKeywords`.`product_id` AND `product`.version_id = `product.searchKeywords`.product_version_id INNER JOIN (SELECT SUM(IF(`product.searchKeywords`.`keyword` = ? , '0.9' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` LIKE ? , '1' * `product.searchKeywords`.`ranking`, 0)) / COUNT(product.id) as _score, `product`.`id`, `product`.`version_id` 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_search_keyword` `product.searchKeywords` ON `product`.`id` = `product.searchKeywords`.`product_id` AND `product`.version_id = `product.searchKeywords`.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.searchKeywords`.`language_id` = ? AND `product.searchKeywords`.`keyword` IN (?, ?, ?, ?, ?, ?)) AND NOT (`product`.`display_group` <=> ?))) AND (`product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` LIKE ?) GROUP BY id, version_id HAVING _score >= ? ORDER BY _score DESC) score_table ON score_table.`id` = `product`.`id` AND score_table.`version_id` = `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.searchKeywords`.`language_id` = ? AND `product.searchKeywords`.`keyword` IN (?, ?, ?, ?, ?, ?)) AND NOT (`product`.`display_group` <=> ?))) GROUP BY `product.options`.`id`
Parameters: 
[
  "Schwarz"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "%schwarz%"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  20
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  true
  b"/»_ââšMpªXTÎ|ãâ\v"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "Schwarz"
  null
  "Schwarz"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "%schwarz%"
  0.5
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  20
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  true
  b"/»_ââšMpªXTÎ|ãâ\v"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "Schwarz"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
5.61 ms
(3.22%) 		1 
# search-page::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_search_keyword` `product.searchKeywords` ON `product`.`id` = `product.searchKeywords`.`product_id` AND `product`.version_id = `product.searchKeywords`.product_version_id INNER JOIN (SELECT SUM(IF(`product.searchKeywords`.`keyword` = ? , '0.9' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` LIKE ? , '1' * `product.searchKeywords`.`ranking`, 0)) / COUNT(product.id) as _score, `product`.`id`, `product`.`version_id` 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_search_keyword` `product.searchKeywords` ON `product`.`id` = `product.searchKeywords`.`product_id` AND `product`.version_id = `product.searchKeywords`.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.searchKeywords`.`language_id` = ? AND `product.searchKeywords`.`keyword` IN (?, ?, ?, ?, ?, ?)) AND NOT (`product`.`display_group` <=> ?))) AND (`product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` LIKE ?) GROUP BY id, version_id HAVING _score >= ? ORDER BY _score DESC) score_table ON score_table.`id` = `product`.`id` AND score_table.`version_id` = `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.searchKeywords`.`language_id` = ? AND `product.searchKeywords`.`keyword` IN (?, ?, ?, ?, ?, ?)) AND NOT (`product`.`display_group` <=> ?))) GROUP BY IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`)
Parameters: 
[
  "Schwarz"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "%schwarz%"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  20
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  true
  b"/»_ââšMpªXTÎ|ãâ\v"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "Schwarz"
  null
  "Schwarz"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "%schwarz%"
  0.5
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  20
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  true
  b"/»_ââšMpªXTÎ|ãâ\v"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "Schwarz"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
5.00 ms
(2.86%) 		2 
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`checkout_gateway_url` as `app.checkoutGatewayUrl`, `app`.`in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl`, `app`.`source_type` as `app.sourceType`, `app`.`source_config` as `app.sourceConfig`, `app`.`self_managed` as `app.selfManaged`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, `app.translation.label` as `app.label`, `app.translation.description`, `app.translation.description` as `app.description`, `app.translation.privacyPolicyExtensions`, `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`, `app.translation.customFields`, `app.translation.customFields` as `app.customFields` FROM `app` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` LEFT JOIN (SELECT `app.translation`.`app_id`, `app.translation`.`label` as `app.translation.label`, `app.translation`.`description` as `app.translation.description`, `app.translation`.`privacy_policy_extensions` as `app.translation.privacyPolicyExtensions`, `app.translation`.`custom_fields` as `app.translation.customFields` FROM `app_translation` `app.translation` WHERE `app.translation`.`language_id` = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` WHERE `app`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01‰vç¸=q‡ ‡†¬\•\x03X"
]
View formatted query    View runnable query    Explain query    View query backtrace
3.07 ms
(1.76%) 		1 
# search-page::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_search_keyword` `product.searchKeywords` ON `product`.`id` = `product.searchKeywords`.`product_id` AND `product`.version_id = `product.searchKeywords`.product_version_id INNER JOIN (SELECT SUM(IF(`product.searchKeywords`.`keyword` = ? , '0.9' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` LIKE ? , '1' * `product.searchKeywords`.`ranking`, 0)) / COUNT(product.id) as _score, `product`.`id`, `product`.`version_id` 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_search_keyword` `product.searchKeywords` ON `product`.`id` = `product.searchKeywords`.`product_id` AND `product`.version_id = `product.searchKeywords`.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.searchKeywords`.`language_id` = ? AND `product.searchKeywords`.`keyword` IN (?, ?, ?, ?, ?, ?)) AND NOT (`product`.`display_group` <=> ?))) AND (`product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` LIKE ?) GROUP BY id, version_id HAVING _score >= ? ORDER BY _score DESC) score_table ON score_table.`id` = `product`.`id` AND score_table.`version_id` = `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.searchKeywords`.`language_id` = ? AND `product.searchKeywords`.`keyword` IN (?, ?, ?, ?, ?, ?)) AND NOT (`product`.`display_group` <=> ?))) AND (((IFNULL(`product`.`rating_average`, `product.parent`.`rating_average`) >= ?)))
Parameters: 
[
  "Schwarz"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "%schwarz%"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  20
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  true
  b"/»_ââšMpªXTÎ|ãâ\v"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "Schwarz"
  null
  "Schwarz"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "%schwarz%"
  0.5
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  20
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  true
  b"/»_ââšMpªXTÎ|ãâ\v"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "Schwarz"
  null
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
3.00 ms
(1.72%) 		1 
# search-page::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_search_keyword` `product.searchKeywords` ON `product`.`id` = `product.searchKeywords`.`product_id` AND `product`.version_id = `product.searchKeywords`.product_version_id INNER JOIN (SELECT SUM(IF(`product.searchKeywords`.`keyword` = ? , '0.9' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` = ? , '0.5' * `product.searchKeywords`.`ranking`, 0) + IF(`product.searchKeywords`.`keyword` LIKE ? , '1' * `product.searchKeywords`.`ranking`, 0)) / COUNT(product.id) as _score, `product`.`id`, `product`.`version_id` 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_search_keyword` `product.searchKeywords` ON `product`.`id` = `product.searchKeywords`.`product_id` AND `product`.version_id = `product.searchKeywords`.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.searchKeywords`.`language_id` = ? AND `product.searchKeywords`.`keyword` IN (?, ?, ?, ?, ?, ?)) AND NOT (`product`.`display_group` <=> ?))) AND (`product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` = ? OR `product.searchKeywords`.`keyword` LIKE ?) GROUP BY id, version_id HAVING _score >= ? ORDER BY _score DESC) score_table ON score_table.`id` = `product`.`id` AND score_table.`version_id` = `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.searchKeywords`.`language_id` = ? AND `product.searchKeywords`.`keyword` IN (?, ?, ?, ?, ?, ?)) AND NOT (`product`.`display_group` <=> ?))) AND ((IFNULL(`product`.`shipping_free`, `product.parent`.`shipping_free`) = ?))
Parameters: 
[
  "Schwarz"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "%schwarz%"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  20
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  true
  b"/»_ââšMpªXTÎ|ãâ\v"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "Schwarz"
  null
  "Schwarz"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "%schwarz%"
  0.5
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  20
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  true
  b"/»_ââšMpªXTÎ|ãâ\v"
  "Armreif, Keramikauflage schwarz"
  "Deko-Büste groß, schwarz"
  "Deko-Büste klein, schwarz"
  "Lederband, schwarz"
  "Lederkette, schwarz"
  "Schwarz"
  null
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
1.17 ms
(0.67%) 		1 
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id = ? OR system_config.sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters: 
[
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.10 ms
(0.63%) 		1 
# product-listing::property-filter::read
SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group.translation.name`, `property_group_option.group.translation.name` as `property_group_option.group.name`, `property_group_option.group.translation.description`, `property_group_option.group.translation.description` as `property_group_option.group.description`, `property_group_option.group.translation.position`, `property_group_option.group.translation.position` as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, `property_group_option.group.translation.customFields` as `property_group_option.group.customFields`, `property_group_option.media`.`id` as `property_group_option.media.id`, `property_group_option.media`.`user_id` as `property_group_option.media.userId`, `property_group_option.media`.`media_folder_id` as `property_group_option.media.mediaFolderId`, `property_group_option.media`.`mime_type` as `property_group_option.media.mimeType`, `property_group_option.media`.`file_extension` as `property_group_option.media.fileExtension`, `property_group_option.media`.`uploaded_at` as `property_group_option.media.uploadedAt`, `property_group_option.media`.`file_name` as `property_group_option.media.fileName`, `property_group_option.media`.`file_size` as `property_group_option.media.fileSize`, `property_group_option.media`.`media_type` as `property_group_option.media.mediaTypeRaw`, `property_group_option.media`.`meta_data` as `property_group_option.media.metaData`, `property_group_option.media`.`config` as `property_group_option.media.config`, `property_group_option.media`.`path` as `property_group_option.media.path`, `property_group_option.media`.`private` as `property_group_option.media.private`, `property_group_option.media`.`thumbnails_ro` as `property_group_option.media.thumbnailsRo`, `property_group_option.media`.`created_at` as `property_group_option.media.createdAt`, `property_group_option.media`.`updated_at` as `property_group_option.media.updatedAt`, `property_group_option.media.translation.title`, `property_group_option.media.translation.title` as `property_group_option.media.title`, `property_group_option.media.translation.alt`, `property_group_option.media.translation.alt` as `property_group_option.media.alt`, `property_group_option.media.translation.customFields`, `property_group_option.media.translation.customFields` as `property_group_option.media.customFields`, `property_group_option.translation.name`, `property_group_option.translation.name` as `property_group_option.name`, `property_group_option.translation.position`, `property_group_option.translation.position` as `property_group_option.position`, `property_group_option.translation.customFields`, `property_group_option.translation.customFields` as `property_group_option.customFields` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN `media` `property_group_option.media` ON `property_group_option`.`media_id` = `property_group_option.media`.`id` LEFT JOIN (SELECT `property_group_option.translation`.`property_group_option_id`, `property_group_option.translation`.`name` as `property_group_option.translation.name`, `property_group_option.translation`.`position` as `property_group_option.translation.position`, `property_group_option.translation`.`custom_fields` as `property_group_option.translation.customFields` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.`language_id` = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN (SELECT `property_group_option.group.translation`.`property_group_id`, `property_group_option.group.translation`.`name` as `property_group_option.group.translation.name`, `property_group_option.group.translation`.`description` as `property_group_option.group.translation.description`, `property_group_option.group.translation`.`position` as `property_group_option.group.translation.position`, `property_group_option.group.translation`.`custom_fields` as `property_group_option.group.translation.customFields` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.`language_id` = ?) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.media.translation`.`media_id`, `property_group_option.media.translation`.`alt` as `property_group_option.media.translation.alt`, `property_group_option.media.translation`.`title` as `property_group_option.media.translation.title`, `property_group_option.media.translation`.`custom_fields` as `property_group_option.media.translation.customFields` FROM `media_translation` `property_group_option.media.translation` WHERE `property_group_option.media.translation`.`language_id` = ?) `property_group_option.media.media_translation` ON `property_group_option.media.media_translation`.`media_id` = `property_group_option.media`.`id` WHERE `property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x05SR|ßgB┬»ØEmà³$¸"
  b"\x05£\x18)”ˆOwŒáû×\x13Ö\x16Ä"
  b"\x08¢K╩üYG\x12î■Ñéí·tþ"
  b"\fB=v,D@R¸jëy;®õ¶"
  b"\f¾®Æ3$DPŒ…í¤\x03\x10{O"
  b"\x13ªèÏ2qO]¼\rÔ\x03±7ŽE"
  b"\x14hê\x004ÅGµò;█HÕ]»ô"
  b"\x1D\x12úúDˆ@\e®Àü¦pM¯Û"
  b"\x1D9<\x1Fn³L—„û×úhÏu4"
  b"\x1E\x17·2QÎHɬT÷ÉU»ÍÊ"
  b"\x1Fð–ìç›F\x07•´\ejr÷:g"
  b"\x1F¾╦Oã‗B¼ü¼║»T\x19Ï\x10"
  b"$0)ˆqÌM›§æ=Lú\x033•"
  b"(\x05þƒšþMq”\x18g\x00fÀ¨×"
  b".9©`µ\x17Fý½éå±®þ\v#"
  b"5W(*;‰F6¡obUÅܼ‡"
  b"8Þäžì=K¿»x%÷\x00*§¢"
  b";ó­xì[@h…©¯Ú\x1C‚¼¶"
  b"=ÿ\x06Ê\x16ÀNõ†^©p×¾ýâ"
  b"E<ª$¼aOѱr8\x0FYöðœ"
  b"Lkë7╔$MJ«\x16Ë3ÅÏ£"
  b"V¡P„H¼I5¨³dè\e5Ð^"
  b"^ùoŒ¸lGÙ¸Ý#Œø¿Îö"
  b"c™\x7FÂ|\x04CѨá\x15_C»\x1CÈ"
  b"jìå>töL½¹bûZu„iÀ"
  b"kýr├mÅC¢ê²ó´6Î5\f"
  b"nÂ├\x1A\x03┘FÆØ0I(àGk\x12"
  b"o@T0\x19░O\x11àò╠©C¦nü"
  b"""
    s"Ð]Æ\n
    G\x18¡:t\¤«Kw
    """
  b"wýî»\f\vBJÅc|T\x1C/Vu"
  b"y1\x07˜0—F›¸fˆœçq‹Å"
  b"y\x7F‚\x15“ÆK«‚zeØ8c8›"
  b"}÷Å}¨╗O=¬½ôfô>f×"
  b"~\x17»lD±L\x7Fœ\x10%ïèqßÔ"
  b"€Gï¶\x02ÚO@…ÑÖìy4˜²"
  b"Çz\x1Aü{ÜBZÜà¢äWÒ¢`"
  b"ƒ'/Å\x0FˆDW«êRjŽf|º"
  b"ä\e▓▄´╣F┐Ñؽ╣6║│B"
  b"‘JN¼;ÃCø“>uµ\x06£g "
  b"’I\x03â\x1FzKq—u\rHŒ=¡‹"
  b"öÊFUݺI¢ÆÍØ¥┼»i\t"
  b"Ø\x00¢└é└HXåzÅ_N¤aÉ"
  b"Ø┬DNÓ°IÐ╝\x13\x19ZL4]$"
  b"×SØJPiF\x05£╗┼n²f7\x10"
  b"Ÿ•aŒ\x18¶Oé«V¸q¡T,Ú"
  b"Ÿ¼2ä¶ÊFÛ•ÃÛ÷žeâú"
  b"½\x14ßß■ÁI~É¡c;ÊÈò¥"
  b"½ã\v╣<ØFMÆ}\vÅ\x07µ¾ú"
  b"¬Œá/$úI\x08°wl­`åI)"
  b"©Éµ¯e‗Nã®╦â¶.ä³|"
  b"╣+.$ÔmNÕôZ┼┐ü|Ù«"
  b"øCÕ¶ýA¨‹j«\x11“%•ö"
  b"╚®\x01¬ìCMøÜX;\x197\x1Ce\x11"
  b"ÌÕ¨w¾èAv•<d¥†\vm\x08"
  b"Í÷Âé╣L(êEιØ‗ä\x04"
  b"""
    ã¢H\n
    \x17ŸC`±*öÁ"ó½Á
    """
  b"ÒÁ└Ñ3©F&ì÷#═é\x19½╦"
  b"é\x18ßÑrRBd…Û\e—ß8_×"
  b"ì¹\x18×å\x16O\v²ÿt§åñÑü"
  b"¯}sñø╔OÌÑJt▄Gqü\f"
  b"ó|Ñ·¹PN׆ú›:œ\x19²\x02"
  b"öA‰¾ó\x01Ai‹ÔEY†¹õ×"
  b"ú\x08´þ¤jCwœ"T7Îi§n"
  b"ú„\x13Í"øG'”\x13…½\x1C«±ú"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.05 ms
(0.60%) 		1 
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.89 ms
(0.51%) 		1 
SELECT `moorl_sorting`.`id` as `moorl_sorting.id`, `moorl_sorting`.`locked` as `moorl_sorting.locked`, `moorl_sorting`.`url_key` as `moorl_sorting.key`, `moorl_sorting`.`entity` as `moorl_sorting.entity`, `moorl_sorting`.`priority` as `moorl_sorting.priority`, `moorl_sorting`.`active` as `moorl_sorting.active`, `moorl_sorting`.`fields` as `moorl_sorting.fields`, `moorl_sorting`.`created_at` as `moorl_sorting.createdAt`, `moorl_sorting`.`updated_at` as `moorl_sorting.updatedAt`, `moorl_sorting.translation.label`, `moorl_sorting.translation.label` as `moorl_sorting.label` FROM `moorl_sorting` LEFT JOIN (SELECT `moorl_sorting.translation`.`moorl_sorting_id`, `moorl_sorting.translation`.`label` as `moorl_sorting.translation.label` FROM `moorl_sorting_translation` `moorl_sorting.translation` WHERE `moorl_sorting.translation`.`language_id` = ?) `moorl_sorting.moorl_sorting_translation` ON `moorl_sorting.moorl_sorting_translation`.`moorl_sorting_id` = `moorl_sorting`.`id` WHERE `moorl_sorting`.`id` IN (?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"'`´vwç*1¼[\x117\x00«¾ƒ"
  b"­\x13˜·Ñ¢ý@¶\x1A_e¡©vÕ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.79 ms
(0.45%) 		1 
SELECT `moorl_sorting`.`id` FROM `moorl_sorting` WHERE (`moorl_sorting`.`active` = ? AND `moorl_sorting`.`entity` = ?) ORDER BY `moorl_sorting`.`priority` DESC
Parameters: 
[
  true
  "moorl_merchant"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.63 ms
(0.36%) 		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.56 ms
(0.32%) 		1 
# base-context-factory::sales-channel::read
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.currency`.`id` as `sales_channel.currency.id`, `sales_channel.currency`.`factor` as `sales_channel.currency.factor`, `sales_channel.currency`.`symbol` as `sales_channel.currency.symbol`, `sales_channel.currency`.`iso_code` as `sales_channel.currency.isoCode`, `sales_channel.currency`.`position` as `sales_channel.currency.position`, `sales_channel.currency`.`tax_free_from` as `sales_channel.currency.taxFreeFrom`, `sales_channel.currency`.`item_rounding` as `sales_channel.currency.itemRounding`, `sales_channel.currency`.`total_rounding` as `sales_channel.currency.totalRounding`, `sales_channel.currency`.`created_at` as `sales_channel.currency.createdAt`, `sales_channel.currency`.`updated_at` as `sales_channel.currency.updatedAt`, `sales_channel.currency.translation.shortName`, `sales_channel.currency.translation.shortName` as `sales_channel.currency.shortName`, `sales_channel.currency.translation.name`, `sales_channel.currency.translation.name` as `sales_channel.currency.name`, `sales_channel.currency.translation.customFields`, `sales_channel.currency.translation.customFields` as `sales_channel.currency.customFields`, `sales_channel.translation.name`, `sales_channel.translation.name` as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, `sales_channel.translation.homeName` as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, `sales_channel.translation.customFields` as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel`.`currency_id` = `sales_channel.currency`.`id` LEFT JOIN (SELECT `sales_channel.translation`.`sales_channel_id`, `sales_channel.translation`.`name` as `sales_channel.translation.name`, `sales_channel.translation`.`custom_fields` as `sales_channel.translation.customFields`, `sales_channel.translation`.`home_slot_config` as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.`home_enabled` as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.`home_name` as `sales_channel.translation.homeName`, `sales_channel.translation`.`home_meta_title` as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.`home_meta_description` as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.`home_keywords` as `sales_channel.translation.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.`language_id` = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` LEFT JOIN (SELECT `sales_channel.currency.translation`.`currency_id`, `sales_channel.currency.translation`.`short_name` as `sales_channel.currency.translation.shortName`, `sales_channel.currency.translation`.`name` as `sales_channel.currency.translation.name`, `sales_channel.currency.translation`.`custom_fields` as `sales_channel.currency.translation.customFields` FROM `currency_translation` `sales_channel.currency.translation` WHERE `sales_channel.currency.translation`.`language_id` = ?) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation`.`currency_id` = `sales_channel.currency`.`id` WHERE `sales_channel`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.56 ms
(0.32%) 		1 
# base-context-factory::shipping-method::read
SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`active` as `shipping_method.active`, `shipping_method`.`position` as `shipping_method.position`, `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` as `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` as `shipping_method.taxType`, `shipping_method`.`tax_id` as `shipping_method.taxId`, `shipping_method.deliveryTime`.`id` as `shipping_method.deliveryTime.id`, `shipping_method.deliveryTime`.`min` as `shipping_method.deliveryTime.min`, `shipping_method.deliveryTime`.`max` as `shipping_method.deliveryTime.max`, `shipping_method.deliveryTime`.`unit` as `shipping_method.deliveryTime.unit`, `shipping_method.deliveryTime`.`created_at` as `shipping_method.deliveryTime.createdAt`, `shipping_method.deliveryTime`.`updated_at` as `shipping_method.deliveryTime.updatedAt`, `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation.name` as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation.customFields` as `shipping_method.deliveryTime.customFields`, `shipping_method.appShippingMethod`.`id` as `shipping_method.appShippingMethod.id`, `shipping_method.appShippingMethod`.`app_name` as `shipping_method.appShippingMethod.appName`, `shipping_method.appShippingMethod`.`identifier` as `shipping_method.appShippingMethod.identifier`, `shipping_method.appShippingMethod`.`app_id` as `shipping_method.appShippingMethod.appId`, `shipping_method.appShippingMethod`.`shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId`, `shipping_method.appShippingMethod`.`original_media_id` as `shipping_method.appShippingMethod.originalMediaId`, `shipping_method.appShippingMethod`.`created_at` as `shipping_method.appShippingMethod.createdAt`, `shipping_method.appShippingMethod`.`updated_at` as `shipping_method.appShippingMethod.updatedAt`, `shipping_method`.`technical_name` as `shipping_method.technicalName`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.media`.`id` as `shipping_method.media.id`, `shipping_method.media`.`user_id` as `shipping_method.media.userId`, `shipping_method.media`.`media_folder_id` as `shipping_method.media.mediaFolderId`, `shipping_method.media`.`mime_type` as `shipping_method.media.mimeType`, `shipping_method.media`.`file_extension` as `shipping_method.media.fileExtension`, `shipping_method.media`.`uploaded_at` as `shipping_method.media.uploadedAt`, `shipping_method.media`.`file_name` as `shipping_method.media.fileName`, `shipping_method.media`.`file_size` as `shipping_method.media.fileSize`, `shipping_method.media`.`media_type` as `shipping_method.media.mediaTypeRaw`, `shipping_method.media`.`meta_data` as `shipping_method.media.metaData`, `shipping_method.media`.`config` as `shipping_method.media.config`, `shipping_method.media`.`path` as `shipping_method.media.path`, `shipping_method.media`.`private` as `shipping_method.media.private`, `shipping_method.media`.`thumbnails_ro` as `shipping_method.media.thumbnailsRo`, `shipping_method.media`.`created_at` as `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`, `shipping_method.media.translation.title`, `shipping_method.media.translation.title` as `shipping_method.media.title`, `shipping_method.media.translation.alt`, `shipping_method.media.translation.alt` as `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, `shipping_method.media.translation.customFields` as `shipping_method.media.customFields`, `shipping_method.translation.name`, `shipping_method.translation.name` as `shipping_method.name`, `shipping_method.translation.description`, `shipping_method.translation.description` as `shipping_method.description`, `shipping_method.translation.trackingUrl`, `shipping_method.translation.trackingUrl` as `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, `shipping_method.translation.customFields` as `shipping_method.customFields` FROM `shipping_method` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method`.`id` = `shipping_method.appShippingMethod`.`shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name`, `shipping_method.translation`.`custom_fields` as `shipping_method.translation.customFields`, `shipping_method.translation`.`description` as `shipping_method.translation.description`, `shipping_method.translation`.`tracking_url` as `shipping_method.translation.trackingUrl` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation`.`delivery_time_id`, `shipping_method.deliveryTime.translation`.`name` as `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation`.`custom_fields` as `shipping_method.deliveryTime.translation.customFields` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation`.`language_id` = ?) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.`media_id`, `shipping_method.media.translation`.`alt` as `shipping_method.media.translation.alt`, `shipping_method.media.translation`.`title` as `shipping_method.media.translation.title`, `shipping_method.media.translation`.`custom_fields` as `shipping_method.media.translation.customFields` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation`.`language_id` = ?) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"L8>;;aLÀ°)´$¾ÌYM"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.51 ms
(0.29%) 		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"\x05£\x18)”ˆOwŒáû×\x13Ö\x16Ä"
  b"\x14hê\x004ÅGµò;█HÕ]»ô"
  b"\x1F¾╦Oã‗B¼ü¼║»T\x19Ï\x10"
  b";ó­xì[@h…©¯Ú\x1C‚¼¶"
  b"Lkë7╔$MJ«\x16Ë3ÅÏ£"
  b"V¡P„H¼I5¨³dè\e5Ð^"
  b"kýr├mÅC¢ê²ó´6Î5\f"
  b"o@T0\x19░O\x11àò╠©C¦nü"
  b"""
    s"Ð]Æ\n
    G\x18¡:t\¤«Kw
    """
  b"Çz\x1Aü{ÜBZÜà¢äWÒ¢`"
  b"ƒ'/Å\x0FˆDW«êRjŽf|º"
  b"‘JN¼;ÃCø“>uµ\x06£g "
  b"öÊFUݺI¢ÆÍØ¥┼»i\t"
  b"Ÿ•aŒ\x18¶Oé«V¸q¡T,Ú"
  b"©Éµ¯e‗Nã®╦â¶.ä³|"
  b"╚®\x01¬ìCMøÜX;\x197\x1Ce\x11"
  b"ó|Ñ·¹PN׆ú›:œ\x19²\x02"
  b"öA‰¾ó\x01Ai‹ÔEY†¹õ×"
  b"\x05SR|ßgB┬»ØEmà³$¸"
  b"\x08¢K╩üYG\x12î■Ñéí·tþ"
  b"\fB=v,D@R¸jëy;®õ¶"
  b"\f¾®Æ3$DPŒ…í¤\x03\x10{O"
  b"\x13ªèÏ2qO]¼\rÔ\x03±7ŽE"
  b"\x1D\x12úúDˆ@\e®Àü¦pM¯Û"
  b"\x1D9<\x1Fn³L—„û×úhÏu4"
  b"\x1E\x17·2QÎHɬT÷ÉU»ÍÊ"
  b"\x1Fð–ìç›F\x07•´\ejr÷:g"
  b"$0)ˆqÌM›§æ=Lú\x033•"
  b"(\x05þƒšþMq”\x18g\x00fÀ¨×"
  b".9©`µ\x17Fý½éå±®þ\v#"
  b"5W(*;‰F6¡obUÅܼ‡"
  b"8Þäžì=K¿»x%÷\x00*§¢"
  b"=ÿ\x06Ê\x16ÀNõ†^©p×¾ýâ"
  b"E<ª$¼aOѱr8\x0FYöðœ"
  b"^ùoŒ¸lGÙ¸Ý#Œø¿Îö"
  b"c™\x7FÂ|\x04CѨá\x15_C»\x1CÈ"
  b"jìå>töL½¹bûZu„iÀ"
  b"nÂ├\x1A\x03┘FÆØ0I(àGk\x12"
  b"wýî»\f\vBJÅc|T\x1C/Vu"
  b"y1\x07˜0—F›¸fˆœçq‹Å"
  b"y\x7F‚\x15“ÆK«‚zeØ8c8›"
  b"}÷Å}¨╗O=¬½ôfô>f×"
  b"~\x17»lD±L\x7Fœ\x10%ïèqßÔ"
  b"€Gï¶\x02ÚO@…ÑÖìy4˜²"
  b"ä\e▓▄´╣F┐Ñؽ╣6║│B"
  b"’I\x03â\x1FzKq—u\rHŒ=¡‹"
  b"œÜ\x7Fˆ­aD\x03«óÒ¦\x07â\f÷"
  b"Ø\x00¢└é└HXåzÅ_N¤aÉ"
  b"Ø┬DNÓ°IÐ╝\x13\x19ZL4]$"
  b"×SØJPiF\x05£╗┼n²f7\x10"
  b"Ÿ¼2ä¶ÊFÛ•ÃÛ÷žeâú"
  b"½\x14ßß■ÁI~É¡c;ÊÈò¥"
  b"½ã\v╣<ØFMÆ}\vÅ\x07µ¾ú"
  b"¬Œá/$úI\x08°wl­`åI)"
  b"╣+.$ÔmNÕôZ┼┐ü|Ù«"
  b"øCÕ¶ýA¨‹j«\x11“%•ö"
  b"ÌÕ¨w¾èAv•<d¥†\vm\x08"
  b"Í÷Âé╣L(êEιØ‗ä\x04"
  b"""
    ã¢H\n
    \x17ŸC`±*öÁ"ó½Á
    """
  b"ÒÁ└Ñ3©F&ì÷#═é\x19½╦"
  b"é\x18ßÑrRBd…Û\e—ß8_×"
  b"ì¹\x18×å\x16O\v²ÿt§åñÑü"
  b"¯}sñø╔OÌÑJt▄Gqü\f"
  b"ð]£åSúNs·ŠŸÑW\x03¡j"
  b"ú\x08´þ¤jCwœ"T7Îi§n"
  b"ú„\x13Í"øG'”\x13…½\x1C«±ú"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.50 ms
(0.29%) 		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"\x05£\x18)”ˆOwŒáû×\x13Ö\x16Ä"
  b"\x14hê\x004ÅGµò;█HÕ]»ô"
  b"\x1F¾╦Oã‗B¼ü¼║»T\x19Ï\x10"
  b";ó­xì[@h…©¯Ú\x1C‚¼¶"
  b"Lkë7╔$MJ«\x16Ë3ÅÏ£"
  b"V¡P„H¼I5¨³dè\e5Ð^"
  b"kýr├mÅC¢ê²ó´6Î5\f"
  b"o@T0\x19░O\x11àò╠©C¦nü"
  b"""
    s"Ð]Æ\n
    G\x18¡:t\¤«Kw
    """
  b"Çz\x1Aü{ÜBZÜà¢äWÒ¢`"
  b"ƒ'/Å\x0FˆDW«êRjŽf|º"
  b"‘JN¼;ÃCø“>uµ\x06£g "
  b"öÊFUݺI¢ÆÍØ¥┼»i\t"
  b"Ÿ•aŒ\x18¶Oé«V¸q¡T,Ú"
  b"©Éµ¯e‗Nã®╦â¶.ä³|"
  b"╚®\x01¬ìCMøÜX;\x197\x1Ce\x11"
  b"ó|Ñ·¹PN׆ú›:œ\x19²\x02"
  b"öA‰¾ó\x01Ai‹ÔEY†¹õ×"
  b"\x05SR|ßgB┬»ØEmà³$¸"
  b"\x08¢K╩üYG\x12î■Ñéí·tþ"
  b"\fB=v,D@R¸jëy;®õ¶"
  b"\f¾®Æ3$DPŒ…í¤\x03\x10{O"
  b"\x13ªèÏ2qO]¼\rÔ\x03±7ŽE"
  b"\x1D\x12úúDˆ@\e®Àü¦pM¯Û"
  b"\x1D9<\x1Fn³L—„û×úhÏu4"
  b"\x1E\x17·2QÎHɬT÷ÉU»ÍÊ"
  b"\x1Fð–ìç›F\x07•´\ejr÷:g"
  b"$0)ˆqÌM›§æ=Lú\x033•"
  b"(\x05þƒšþMq”\x18g\x00fÀ¨×"
  b".9©`µ\x17Fý½éå±®þ\v#"
  b"5W(*;‰F6¡obUÅܼ‡"
  b"8Þäžì=K¿»x%÷\x00*§¢"
  b"=ÿ\x06Ê\x16ÀNõ†^©p×¾ýâ"
  b"E<ª$¼aOѱr8\x0FYöðœ"
  b"^ùoŒ¸lGÙ¸Ý#Œø¿Îö"
  b"c™\x7FÂ|\x04CѨá\x15_C»\x1CÈ"
  b"jìå>töL½¹bûZu„iÀ"
  b"nÂ├\x1A\x03┘FÆØ0I(àGk\x12"
  b"wýî»\f\vBJÅc|T\x1C/Vu"
  b"y1\x07˜0—F›¸fˆœçq‹Å"
  b"y\x7F‚\x15“ÆK«‚zeØ8c8›"
  b"}÷Å}¨╗O=¬½ôfô>f×"
  b"~\x17»lD±L\x7Fœ\x10%ïèqßÔ"
  b"€Gï¶\x02ÚO@…ÑÖìy4˜²"
  b"ä\e▓▄´╣F┐Ñؽ╣6║│B"
  b"’I\x03â\x1FzKq—u\rHŒ=¡‹"
  b"œÜ\x7Fˆ­aD\x03«óÒ¦\x07â\f÷"
  b"Ø\x00¢└é└HXåzÅ_N¤aÉ"
  b"Ø┬DNÓ°IÐ╝\x13\x19ZL4]$"
  b"×SØJPiF\x05£╗┼n²f7\x10"
  b"Ÿ¼2ä¶ÊFÛ•ÃÛ÷žeâú"
  b"½\x14ßß■ÁI~É¡c;ÊÈò¥"
  b"½ã\v╣<ØFMÆ}\vÅ\x07µ¾ú"
  b"¬Œá/$úI\x08°wl­`åI)"
  b"╣+.$ÔmNÕôZ┼┐ü|Ù«"
  b"øCÕ¶ýA¨‹j«\x11“%•ö"
  b"ÌÕ¨w¾èAv•<d¥†\vm\x08"
  b"Í÷Âé╣L(êEιØ‗ä\x04"
  b"""
    ã¢H\n
    \x17ŸC`±*öÁ"ó½Á
    """
  b"ÒÁ└Ñ3©F&ì÷#═é\x19½╦"
  b"é\x18ßÑrRBd…Û\e—ß8_×"
  b"ì¹\x18×å\x16O\v²ÿt§åñÑü"
  b"¯}sñø╔OÌÑJt▄Gqü\f"
  b"ð]£åSúNs·ŠŸÑW\x03¡j"
  b"ú\x08´þ¤jCwœ"T7Îi§n"
  b"ú„\x13Í"øG'”\x13…½\x1C«±ú"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.50 ms
(0.29%) 		1 
SELECT CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') `key`, CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') url, LOWER(HEX(domain.id)) id, LOWER(HEX(sales_channel.id)) salesChannelId, LOWER(HEX(sales_channel.type_id)) typeId, LOWER(HEX(domain.snippet_set_id)) snippetSetId, LOWER(HEX(domain.currency_id)) currencyId, LOWER(HEX(domain.language_id)) languageId, LOWER(HEX(theme.id)) themeId, sales_channel.maintenance maintenance, sales_channel.maintenance_ip_whitelist maintenanceIpWhitelist, snippet_set.iso as locale, theme.technical_name as themeName, parentTheme.technical_name as parentThemeName FROM sales_channel INNER JOIN sales_channel_domain domain ON domain.sales_channel_id = sales_channel.id LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id INNER JOIN snippet_set snippet_set ON snippet_set.id = domain.snippet_set_id LEFT JOIN theme theme ON theme_sales_channel.theme_id = theme.id LEFT JOIN theme parentTheme ON theme.parent_theme_id = parentTheme.id WHERE (sales_channel.type_id = UNHEX(?)) AND (sales_channel.active)
Parameters: 
[
  "8a243080f92e4c719546314b577cf82b"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.50 ms
(0.29%) 		1 
# base-context-factory::payment-method::read
SELECT `payment_method`.`id` as `payment_method.id`, `payment_method`.`plugin_id` as `payment_method.pluginId`, `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`, `payment_method`.`position` as `payment_method.position`, `payment_method`.`active` as `payment_method.active`, `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`, `payment_method`.`media_id` as `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` as `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` as `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` as `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`recurring_url` as `payment_method.appPaymentMethod.recurringUrl`, `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`, `payment_method`.`technical_name` as `payment_method.technicalName`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `payment_method.media`.`id` as `payment_method.media.id`, `payment_method.media`.`user_id` as `payment_method.media.userId`, `payment_method.media`.`media_folder_id` as `payment_method.media.mediaFolderId`, `payment_method.media`.`mime_type` as `payment_method.media.mimeType`, `payment_method.media`.`file_extension` as `payment_method.media.fileExtension`, `payment_method.media`.`uploaded_at` as `payment_method.media.uploadedAt`, `payment_method.media`.`file_name` as `payment_method.media.fileName`, `payment_method.media`.`file_size` as `payment_method.media.fileSize`, `payment_method.media`.`media_type` as `payment_method.media.mediaTypeRaw`, `payment_method.media`.`meta_data` as `payment_method.media.metaData`, `payment_method.media`.`config` as `payment_method.media.config`, `payment_method.media`.`path` as `payment_method.media.path`, `payment_method.media`.`private` as `payment_method.media.private`, `payment_method.media`.`thumbnails_ro` as `payment_method.media.thumbnailsRo`, `payment_method.media`.`created_at` as `payment_method.media.createdAt`, `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`, `payment_method.media.translation.title`, `payment_method.media.translation.title` as `payment_method.media.title`, `payment_method.media.translation.alt`, `payment_method.media.translation.alt` as `payment_method.media.alt`, `payment_method.media.translation.customFields`, `payment_method.media.translation.customFields` as `payment_method.media.customFields`, `payment_method.translation.name`, `payment_method.translation.name` as `payment_method.name`, `payment_method.translation.distinguishableName`, `payment_method.translation.distinguishableName` as `payment_method.distinguishableName`, `payment_method.translation.description`, `payment_method.translation.description` as `payment_method.description`, `payment_method.translation.customFields`, `payment_method.translation.customFields` as `payment_method.customFields` FROM `payment_method` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.translation`.`payment_method_id`, `payment_method.translation`.`name` as `payment_method.translation.name`, `payment_method.translation`.`distinguishable_name` as `payment_method.translation.distinguishableName`, `payment_method.translation`.`description` as `payment_method.translation.description`, `payment_method.translation`.`custom_fields` as `payment_method.translation.customFields` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.`language_id` = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.`media_id`, `payment_method.media.translation`.`alt` as `payment_method.media.translation.alt`, `payment_method.media.translation`.`title` as `payment_method.media.translation.title`, `payment_method.media.translation`.`custom_fields` as `payment_method.media.translation.customFields` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation`.`language_id` = ?) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"î╦·:\x170NÛÉðØÂ■gÝ="
]
View formatted query    View runnable query    Explain query    View query backtrace
0.46 ms
(0.26%) 		1 
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.40 ms
(0.23%) 		1 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.40 ms
(0.23%) 		1 
# base-context-factory::customer-group::read
SELECT `customer_group`.`id` as `customer_group.id`, `customer_group`.`display_gross` as `customer_group.displayGross`, `customer_group`.`registration_active` as `customer_group.registrationActive`, `customer_group`.`created_at` as `customer_group.createdAt`, `customer_group`.`updated_at` as `customer_group.updatedAt`, `customer_group.evpPriceSettings`.`id` as `customer_group.evpPriceSettings.id`, `customer_group.evpPriceSettings`.`customer_group_id` as `customer_group.evpPriceSettings.customerGroupId`, `customer_group.evpPriceSettings`.`reference_price_customer_group_id` as `customer_group.evpPriceSettings.referencePriceCustomerGroupId`, `customer_group.evpPriceSettings`.`reference_price_rule_id` as `customer_group.evpPriceSettings.referencePriceRuleId`, `customer_group.evpPriceSettings`.`show_net_price` as `customer_group.evpPriceSettings.showNetPrice`, `customer_group.evpPriceSettings`.`use_pseudo_price` as `customer_group.evpPriceSettings.usePseudoPrice`, `customer_group.evpPriceSettings`.`display_on_detail` as `customer_group.evpPriceSettings.displayOnDetail`, `customer_group.evpPriceSettings`.`display_in_cart` as `customer_group.evpPriceSettings.displayInCart`, `customer_group.evpPriceSettings`.`display_in_listing` as `customer_group.evpPriceSettings.displayInListing`, `customer_group.evpPriceSettings`.`active` as `customer_group.evpPriceSettings.active`, `customer_group.evpPriceSettings.referencePriceRule`.`id` as `customer_group.evpPriceSettings.referencePriceRule.id`, `customer_group.evpPriceSettings.referencePriceRule`.`name` as `customer_group.evpPriceSettings.referencePriceRule.name`, `customer_group.evpPriceSettings.referencePriceRule`.`priority` as `customer_group.evpPriceSettings.referencePriceRule.priority`, `customer_group.evpPriceSettings.referencePriceRule`.`description` as `customer_group.evpPriceSettings.referencePriceRule.description`, `customer_group.evpPriceSettings.referencePriceRule`.`payload` as `customer_group.evpPriceSettings.referencePriceRule.payload`, `customer_group.evpPriceSettings.referencePriceRule`.`invalid` as `customer_group.evpPriceSettings.referencePriceRule.invalid`, `customer_group.evpPriceSettings.referencePriceRule`.`areas` as `customer_group.evpPriceSettings.referencePriceRule.areas`, `customer_group.evpPriceSettings.referencePriceRule`.`custom_fields` as `customer_group.evpPriceSettings.referencePriceRule.customFields`, `customer_group.evpPriceSettings.referencePriceRule`.`module_types` as `customer_group.evpPriceSettings.referencePriceRule.moduleTypes`, `customer_group.evpPriceSettings.referencePriceRule`.`created_at` as `customer_group.evpPriceSettings.referencePriceRule.createdAt`, `customer_group.evpPriceSettings.referencePriceRule`.`updated_at` as `customer_group.evpPriceSettings.referencePriceRule.updatedAt`, `customer_group.evpPriceSettings`.`created_at` as `customer_group.evpPriceSettings.createdAt`, `customer_group.evpPriceSettings`.`updated_at` as `customer_group.evpPriceSettings.updatedAt`, `customer_group.translation.name`, `customer_group.translation.name` as `customer_group.name`, `customer_group.translation.registrationTitle`, `customer_group.translation.registrationTitle` as `customer_group.registrationTitle`, `customer_group.translation.registrationIntroduction`, `customer_group.translation.registrationIntroduction` as `customer_group.registrationIntroduction`, `customer_group.translation.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationOnlyCompanyRegistration` as `customer_group.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationSeoMetaDescription`, `customer_group.translation.registrationSeoMetaDescription` as `customer_group.registrationSeoMetaDescription`, `customer_group.translation.customFields`, `customer_group.translation.customFields` as `customer_group.customFields` FROM `customer_group` LEFT JOIN `coe_evp_price_customer_group_setting` `customer_group.evpPriceSettings` ON `customer_group`.`id` = `customer_group.evpPriceSettings`.`customer_group_id` LEFT JOIN (SELECT `customer_group.translation`.`customer_group_id`, `customer_group.translation`.`name` as `customer_group.translation.name`, `customer_group.translation`.`custom_fields` as `customer_group.translation.customFields`, `customer_group.translation`.`registration_title` as `customer_group.translation.registrationTitle`, `customer_group.translation`.`registration_introduction` as `customer_group.translation.registrationIntroduction`, `customer_group.translation`.`registration_only_company_registration` as `customer_group.translation.registrationOnlyCompanyRegistration`, `customer_group.translation`.`registration_seo_meta_description` as `customer_group.translation.registrationSeoMetaDescription` FROM `customer_group_translation` `customer_group.translation` WHERE `customer_group.translation`.`language_id` = ?) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation`.`customer_group_id` = `customer_group`.`id` LEFT JOIN `rule` `customer_group.evpPriceSettings.referencePriceRule` ON `customer_group.evpPriceSettings`.`reference_price_rule_id` = `customer_group.evpPriceSettings.referencePriceRule`.`id` WHERE `customer_group`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"¤¢P\x18ËìAÏ¡╩\x10┘O╚¢Í"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.38 ms
(0.22%) 		1 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  "HDJm6ZAcjNWSciBokiS4Dcmhji7dkITv"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.34 ms
(0.20%) 		1 
# base-context-factory::taxes::association::rules::read
SELECT `tax_rule`.`id` as `tax_rule.id`, `tax_rule`.`tax_rule_type_id` as `tax_rule.taxRuleTypeId`, `tax_rule`.`country_id` as `tax_rule.countryId`, `tax_rule`.`tax_rate` as `tax_rule.taxRate`, `tax_rule`.`data` as `tax_rule.data`, `tax_rule`.`tax_id` as `tax_rule.taxId`, `tax_rule`.`active_from` as `tax_rule.activeFrom`, `tax_rule`.`created_at` as `tax_rule.createdAt`, `tax_rule`.`updated_at` as `tax_rule.updatedAt`, `tax_rule.type`.`id` as `tax_rule.type.id`, `tax_rule.type`.`technical_name` as `tax_rule.type.technicalName`, `tax_rule.type`.`position` as `tax_rule.type.position`, `tax_rule.type`.`created_at` as `tax_rule.type.createdAt`, `tax_rule.type`.`updated_at` as `tax_rule.type.updatedAt`, `tax_rule.type.translation.typeName`, `tax_rule.type.translation.typeName` as `tax_rule.type.typeName` FROM `tax_rule` LEFT JOIN `tax_rule_type` `tax_rule.type` ON `tax_rule`.`tax_rule_type_id` = `tax_rule.type`.`id` LEFT JOIN (SELECT `tax_rule.type.translation`.`tax_rule_type_id`, `tax_rule.type.translation`.`type_name` as `tax_rule.type.translation.typeName` FROM `tax_rule_type_translation` `tax_rule.type.translation` WHERE `tax_rule.type.translation`.`language_id` = ?) `tax_rule.type.tax_rule_type_translation` ON `tax_rule.type.tax_rule_type_translation`.`tax_rule_type_id` = `tax_rule.type`.`id` WHERE (`tax_rule`.`tax_id` IN (?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"?‹Rk•iCá‡w¸Ê@k|)"
  b"r”;psœH™šýI²·@Ç#"
  b"w▄¹\r!»D=ÿµ\x05'ÿüv¢"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.34 ms
(0.20%) 		1 
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 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"™†H“•Ø@†ºENX³û\fÓ"
  b"Ó+îûréCÜž×&Ì÷{\x03¢"
  b"õ8/óùgL╣ìé▄)┤Q╔\x19"
  b"\rÿƒ+GãK\x08šqK\v\x0FÓÖÊ"
  b"+”\x15\x07#rHÒ—>E\fI?N4"
  b"^±░═╚ðK'ä¹\t=ü‗)¬"
  b"ž\x07°Ž\x0F\x14F)†\x08¿\e¸\x07Å\x11"
  b"ŸP¾¢õ\x08@ö¢8üÂô}iÅ"
  b"º{"âRîCßÅàP.╣n\vı"
  b"Ç\x1Cb5\x17yLíºAnõq\x1AzR"
  b"Ú:Å »ŽFW§Ž›˜õeoÕ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.19%) 		1 
# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND ((seo_path_info = ? OR seo_path_info = ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  "widgets/search/filter"
  "widgets/search/filter/"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(0.18%) 		1 
# cart-rule-loader::load-rules::read
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x01“h\x0EÇ_~í‚.@>œîC%"
  b"\x01“h\r\x02d\x7F ¾òFä‘€\x16\x07"
  b"\x01“h\rÝÙp\x11›³˜&\x15¤\tP"
  b"""
    „\n
    ä*ñ\x19B\x12¤\v\x0F‘¡wXº
    """
  b"™†H“•Ø@†ºENX³û\fÓ"
  b"Ó+îûréCÜž×&Ì÷{\x03¢"
  b"õ8/óùgL╣ìé▄)┤Q╔\x19"
  b"\rÿƒ+GãK\x08šqK\v\x0FÓÖÊ"
  b"ßl\x14\f8>J…’Ž45˜¢¨‚"
  b"\x01‹\x18£ù1yu·À•«E\x1AUw"
  b"\x04¿­N═9JZü╔J¾\tmÇð"
  b"\x12ìÂCµŠLq‰ó“ÐØ\x0E–â"
  b"+”\x15\x07#rHÒ—>E\fI?N4"
  b"6F¿x…¯Cvƒy™ß;%ÃÍ"
  b";É\x16_LÉGƒ·\x0F¢ƒåþI\x03"
  b"^±░═╚ðK'ä¹\t=ü‗)¬"
  b"_\x10 &x,Cp¥ØÁȪœ/ë"
  b"d╔rl¨YG'ƒ\x03\fü ô«¢"
  b"jlrla8J©º_S\x102\x07o\r"
  b"""
    p\x15\n
    J¦\LÐÅ­!Ùâv\x01\x1E
    """
  b"|VK¢Æ£O9²ýtO>†®K"
  b"ˆa£À¡8LÙ¨ìlg\x12‹ä1"
  b"Äü*\x1AÅ\tG£Äé^J╦÷å╝"
  b"’w” :ÜJ\x07ž\x03þÖÖS\x14„"
  b"ž\x07°Ž\x0F\x14F)†\x08¿\e¸\x07Å\x11"
  b"žôÆêöKK~¼©“ú\x13rC\x12"
  b"ŸP¾¢õ\x08@ö¢8üÂô}iÅ"
  b"áÆLÚ/ÿLO»┼´╠§¹óØ"
  b"¡vš»´n@tªa@‚Ócñ\x1C"
  b"ó¡Î³È@@)òÛ©\e▄ÍÐØ"
  b"º{"âRîCßÅàP.╣n\vı"
  b"§î\x05`ÈùNPœÝî­*(\x00è"
  b"¡\rÅ{▒┘F\x11ñ¶\vLH\x04H§"
  b"Á†ÐŠÑìDŪ,\x02ˆ›$]\x1D"
  b"Ç\x1Cb5\x17yLíºAnõq\x1AzR"
  b"Љ˜\x1A%\rBè“֗ЀÄA8"
  b"ÒMm'ýÍFŲÄ\x14jà²r"
  b"Ù\x00#,öžOÔ•BD礪¥ˆ"
  b"Ú:Å »ŽFW§Ž›˜õeoÕ"
  b"█ª!Ø ³H¸ÄýQ²┤Ìd\x03"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(0.18%) 		1 
SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(0.18%) 		1 
# context-factory::base-context

        SELECT
          sales_channel.id as sales_channel_id,
          sales_channel.language_id as sales_channel_default_language_id,
          sales_channel.currency_id as sales_channel_currency_id,
          currency.factor as sales_channel_currency_factor,
          GROUP_CONCAT(LOWER(HEX(sales_channel_language.language_id))) as sales_channel_language_ids
        FROM sales_channel
            INNER JOIN currency
                ON sales_channel.currency_id = currency.id
            LEFT JOIN sales_channel_language
                ON sales_channel_language.sales_channel_id = sales_channel.id
        WHERE sales_channel.id = ?
        GROUP BY sales_channel.id, sales_channel.language_id, sales_channel.currency_id, currency.factor
Parameters: 
[
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.30 ms
(0.17%) 		1 
# manufacturer-aggregation::read
SELECT `product_manufacturer`.`id` as `product_manufacturer.id`, `product_manufacturer`.`version_id` as `product_manufacturer.versionId`, `product_manufacturer`.`media_id` as `product_manufacturer.mediaId`, `product_manufacturer`.`link` as `product_manufacturer.link`, `product_manufacturer`.`created_at` as `product_manufacturer.createdAt`, `product_manufacturer`.`updated_at` as `product_manufacturer.updatedAt`, `product_manufacturer.translation.name`, `product_manufacturer.translation.name` as `product_manufacturer.name`, `product_manufacturer.translation.description`, `product_manufacturer.translation.description` as `product_manufacturer.description`, `product_manufacturer.translation.customFields`, `product_manufacturer.translation.customFields` as `product_manufacturer.customFields` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.`product_manufacturer_id`, `product_manufacturer.translation`.`product_manufacturer_version_id`, `product_manufacturer.translation`.`name` as `product_manufacturer.translation.name`, `product_manufacturer.translation`.`description` as `product_manufacturer.translation.description`, `product_manufacturer.translation`.`custom_fields` as `product_manufacturer.translation.customFields` FROM `product_manufacturer_translation` `product_manufacturer.translation` WHERE `product_manufacturer.translation`.`language_id` = ?) `product_manufacturer.product_manufacturer_translation` ON `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product_manufacturer`.`id` AND `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_version_id` = `product_manufacturer`.`version_id` WHERE (`product_manufacturer`.`version_id` = ?) AND (`product_manufacturer`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"{¸ç½Ö¤M3ØåyÅuDM2"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(0.17%) 		2 
SELECT `script`.`id` as `script.id`, `script`.`script` as `script.script`, `script`.`hook` as `script.hook`, `script`.`name` as `script.name`, `script`.`active` as `script.active`, `script`.`app_id` as `script.appId`, `script`.`created_at` as `script.createdAt`, `script`.`updated_at` as `script.updatedAt` FROM `script` WHERE (`script`.`app_id` IN (?))
Parameters: 
[
  b"\x01‰vç¸=q‡ ‡†¬\•\x03X"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.28 ms
(0.16%) 		1 
# base-context-factory::country::read
SELECT `country`.`id` as `country.id`, `country`.`iso` as `country.iso`, `country`.`position` as `country.position`, `country`.`active` as `country.active`, `country`.`shipping_available` as `country.shippingAvailable`, `country`.`iso3` as `country.iso3`, `country`.`display_state_in_registration` as `country.displayStateInRegistration`, `country`.`force_state_in_registration` as `country.forceStateInRegistration`, `country`.`check_vat_id_pattern` as `country.checkVatIdPattern`, `country`.`vat_id_required` as `country.vatIdRequired`, `country`.`vat_id_pattern` as `country.vatIdPattern`, `country`.`customer_tax` as `country.customerTax`, `country`.`company_tax` as `country.companyTax`, `country`.`postal_code_required` as `country.postalCodeRequired`, `country`.`check_postal_code_pattern` as `country.checkPostalCodePattern`, `country`.`check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern`, `country`.`advanced_postal_code_pattern` as `country.advancedPostalCodePattern`, `country`.`default_postal_code_pattern` as `country.defaultPostalCodePattern`, `country`.`is_eu` as `country.isEu`, `country`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, `country.translation.name`, `country.translation.name` as `country.name`, `country.translation.addressFormat`, `country.translation.addressFormat` as `country.addressFormat`, `country.translation.customFields`, `country.translation.customFields` as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation`.`country_id`, `country.translation`.`name` as `country.translation.name`, `country.translation`.`custom_fields` as `country.translation.customFields`, `country.translation`.`address_format` as `country.translation.addressFormat` FROM `country_translation` `country.translation` WHERE `country.translation`.`language_id` = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"=Í¿PnVGÖ±è€\rŒ¬\r{"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(0.15%) 		1 
SELECT `and_logic`, `language_id` FROM `product_search_config` WHERE `language_id` IN (?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(0.15%) 		1 
# product-listing::load-sortings::read
SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.translation.label`, `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.`product_sorting_id`, `product_sorting.translation`.`label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.`language_id` = ?) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ù’ppÊ\vOãžÅH¤­’çþ"
  b"\x00Æwb´õF─âGÉ╝(\x1CP█"
  b"ÜÙã­nÞG\x0E§Ö\e\x1Cë@ëñ"
  b"su╦Éı╩C╝╗Eîë7Ï\x1A§"
  b"ò\eèüÏÍL\x05—"•Ì¯ñPž"
  b"7Ž]\x03h2L¢…–¿x‹'Ø3"
  b"ñæd\x0F½ŒL\x05¦‰\f\x19\x15­³†"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(0.15%) 		1 
# base-context-factory::currency::read
SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.shortName`, `currency.translation.shortName` as `currency.shortName`, `currency.translation.name`, `currency.translation.name` as `currency.name`, `currency.translation.customFields`, `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation`.`currency_id`, `currency.translation`.`short_name` as `currency.translation.shortName`, `currency.translation`.`name` as `currency.translation.name`, `currency.translation`.`custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.`language_id` = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.25 ms
(0.14%) 		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.24 ms
(0.14%) 		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.22 ms
(0.13%) 		1 
# cart-rule-loader::load-rules::search-ids
SELECT `rule`.`id` FROM `rule` WHERE (`rule`.`invalid` = ?) ORDER BY `rule`.`priority` DESC, `rule`.`id` ASC LIMIT 500
Parameters: 
[
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
0.22 ms
(0.13%) 		1 
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((IFNULL(`product`.`active`, `product.parent`.`active`) = ? AND `product.visibilities`.`sales_channel_id` = ? AND (`product`.`product_number` IN (?)))) GROUP BY `product`.`id` LIMIT 2
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  true
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  "schwarz"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.21 ms
(0.12%) 		1 
# base-context-factory::sales-channel::association::domains::read
SELECT `sales_channel_domain`.`id` as `sales_channel_domain.id`, `sales_channel_domain`.`url` as `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt` FROM `sales_channel_domain` WHERE (`sales_channel_domain`.`sales_channel_id` IN (?))
Parameters: 
[
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.19 ms
(0.11%) 		1 
# seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (path_info = ?) AND (is_canonical = 1) LIMIT 1
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  "/widgets/search/filter"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.18 ms
(0.10%) 		1 
# app-scripts::refresh::search-ids
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ?)
Parameters: 
[
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.16 ms
(0.09%) 		1 
# base-context-factory::cash-rounding::search-ids
SELECT `currency_country_rounding`.`id` FROM `currency_country_rounding` WHERE (`currency_country_rounding`.`currency_id` = ? AND `currency_country_rounding`.`country_id` = ?) LIMIT 1
Parameters: 
[
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
  b"=Í¿PnVGÖ±è€\rŒ¬\r{"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.16 ms
(0.09%) 		1 
#cart-persister::load
            SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters: 
[
  "HDJm6ZAcjNWSciBokiS4Dcmhji7dkITv"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.14 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"Éy{\x19bKC9«±€k¼ÃVÄ"
  b"=Í¿PnVGÖ±è€\rŒ¬\r{"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.07%) 		1 
# base-context-factory::taxes::read
SELECT `tax`.`id` as `tax.id`, `tax`.`tax_rate` as `tax.taxRate`, `tax`.`name` as `tax.name`, `tax`.`position` as `tax.position`, `tax`.`custom_fields` as `tax.customFields`, `tax`.`created_at` as `tax.createdAt`, `tax`.`updated_at` as `tax.updatedAt` FROM `tax`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.07%) 		1 
SELECT
                LOWER(`excluded_terms`) as `excluded_terms`,
                `min_search_length`
            FROM product_search_config
            WHERE language_id = ?
            LIMIT 1
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.07%) 		1 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.09 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.