Query Metrics
62
Database Queries
49
Different statements
23.45 ms
Query time
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
3.10 ms (13.21%) |
1 |
# product-listing-route::loading::aggregation::price SELECT MIN(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018e51b22aa5719390ed244d87294aa4.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018baf20c96c70e58b36d5f137ec36e4.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule06e6f9f85f884d10a134dc6ad94e4997.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule2fd64796b30d4d9fade975a1ce787b24.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule37dd08aa9cb7459ab81232f3925e0b23.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018baf353a657c08aa31052a1c121f38.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bb3154e5772a18ca4f532ece650c4.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule0198d088d61471b989837d25331f8798.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule10dc58682d0e455c83b3027e34dfd582.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`, "$.rule018e51b22aa5719390ed244d87294aa4.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018baf20c96c70e58b36d5f137ec36e4.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule06e6f9f85f884d10a134dc6ad94e4997.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule2fd64796b30d4d9fade975a1ce787b24.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule37dd08aa9cb7459ab81232f3925e0b23.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018baf353a657c08aa31052a1c121f38.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bb3154e5772a18ca4f532ece650c4.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule0198d088d61471b989837d25331f8798.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule10dc58682d0e455c83b3027e34dfd582.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`, "$.rule018e51b22aa5719390ed244d87294aa4.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018baf20c96c70e58b36d5f137ec36e4.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule06e6f9f85f884d10a134dc6ad94e4997.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule2fd64796b30d4d9fade975a1ce787b24.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule37dd08aa9cb7459ab81232f3925e0b23.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018baf353a657c08aa31052a1c121f38.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bb3154e5772a18ca4f532ece650c4.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule0198d088d61471b989837d25331f8798.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule10dc58682d0e455c83b3027e34dfd582.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`, "$.rule018e51b22aa5719390ed244d87294aa4.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018baf20c96c70e58b36d5f137ec36e4.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule06e6f9f85f884d10a134dc6ad94e4997.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule2fd64796b30d4d9fade975a1ce787b24.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule37dd08aa9cb7459ab81232f3925e0b23.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018baf353a657c08aa31052a1c121f38.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bb3154e5772a18ca4f532ece650c4.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule0198d088d61471b989837d25331f8798.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule10dc58682d0e455c83b3027e34dfd582.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)))) as `price.max` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id` AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id` AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?)))
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" 30 b"+O‘œsýLö¦Å¦‹š˜\x173" true b"\x01èe\v║5s2ù\x15kAü9}." null true false ] |
||||||||||||||||||
|
1.50 ms (6.40%) |
6 |
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`write_access` as `app.integration.writeAccess`, `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`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE `app`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x01ôb╔\x02ïs└Ç\x18*╦üõÝ!" ] |
||||||||||||||||||
|
1.27 ms (5.42%) |
1 |
# product-listing-route::loading::aggregation::properties SELECT LOWER(HEX(`product.properties`.`id`)) as `properties.key`, COUNT(`product`.`id`) as `properties.count` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id` AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `product_property` `product.properties.mapping` ON `product`.`properties` = `product.properties.mapping`.`product_id` AND `product`.`version_id` = `product.properties.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id` AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` LEFT JOIN `property_group_option` `product.properties` ON `product.properties.mapping`.`property_group_option_id` = `product.properties`.`id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product.properties`.`id`
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" 30 b"+O‘œsýLö¦Å¦‹š˜\x173" true b"\x01èe\v║5s2ù\x15kAü9}." null true false ] |
||||||||||||||||||
|
1.06 ms (4.54%) |
1 |
# product-listing-route::loading::aggregation::rating-exists SELECT MAX(IFNULL(`product`.`rating_average`, `product.parent`.`rating_average`)) as `rating` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id` AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id` AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) AND (((IFNULL(`product`.`rating_average`, `product.parent`.`rating_average`) >= ?)))
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" 30 b"+O‘œsýLö¦Å¦‹š˜\x173" true b"\x01èe\v║5s2ù\x15kAü9}." null true false 0 ] |
||||||||||||||||||
|
0.96 ms (4.08%) |
1 |
# product-listing-route::loading::aggregation::manufacturer SELECT LOWER(HEX(IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`))) as `manufacturer` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id` AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id` AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`)
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" 30 b"+O‘œsýLö¦Å¦‹š˜\x173" true b"\x01èe\v║5s2ù\x15kAü9}." null true false ] |
||||||||||||||||||
|
0.93 ms (3.97%) |
1 |
# product-listing::property-filter::read SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group.translation.name`, COALESCE(`property_group_option.group.translation.name`,`property_group_option.group.translation.name`) as `property_group_option.group.name`, `property_group_option.group.translation.description`, COALESCE(`property_group_option.group.translation.description`,`property_group_option.group.translation.description`) as `property_group_option.group.description`, `property_group_option.group.translation.position`, COALESCE(`property_group_option.group.translation.position`,`property_group_option.group.translation.position`) as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, COALESCE(`property_group_option.group.translation.customFields`,`property_group_option.group.translation.customFields`) as `property_group_option.group.customFields`, `property_group_option.group.translation.createdAt`, `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation.languageId`, `property_group_option.media`.`id` as `property_group_option.media.id`, `property_group_option.media`.`user_id` as `property_group_option.media.userId`, `property_group_option.media`.`media_folder_id` as `property_group_option.media.mediaFolderId`, `property_group_option.media`.`mime_type` as `property_group_option.media.mimeType`, `property_group_option.media`.`file_extension` as `property_group_option.media.fileExtension`, `property_group_option.media`.`uploaded_at` as `property_group_option.media.uploadedAt`, `property_group_option.media`.`file_name` as `property_group_option.media.fileName`, `property_group_option.media`.`file_size` as `property_group_option.media.fileSize`, `property_group_option.media`.`media_type` as `property_group_option.media.mediaTypeRaw`, `property_group_option.media`.`meta_data` as `property_group_option.media.metaData`, `property_group_option.media`.`config` as `property_group_option.media.config`, `property_group_option.media`.`path` as `property_group_option.media.path`, `property_group_option.media`.`private` as `property_group_option.media.private`, `property_group_option.media`.`thumbnails_ro` as `property_group_option.media.thumbnailsRo`, `property_group_option.media`.`created_at` as `property_group_option.media.createdAt`, `property_group_option.media`.`updated_at` as `property_group_option.media.updatedAt`, `property_group_option.media.translation.title`, COALESCE(`property_group_option.media.translation.title`,`property_group_option.media.translation.title`) as `property_group_option.media.title`, `property_group_option.media.translation.alt`, COALESCE(`property_group_option.media.translation.alt`,`property_group_option.media.translation.alt`) as `property_group_option.media.alt`, `property_group_option.media.translation.customFields`, COALESCE(`property_group_option.media.translation.customFields`,`property_group_option.media.translation.customFields`) as `property_group_option.media.customFields`, `property_group_option.media.translation.createdAt`, `property_group_option.media.translation.updatedAt`, `property_group_option.media.translation.mediaId`, `property_group_option.media.translation.languageId`, `property_group_option.translation.name`, COALESCE(`property_group_option.translation.name`,`property_group_option.translation.name`) as `property_group_option.name`, `property_group_option.translation.position`, COALESCE(`property_group_option.translation.position`,`property_group_option.translation.position`) as `property_group_option.position`, `property_group_option.translation.customFields`, COALESCE(`property_group_option.translation.customFields`,`property_group_option.translation.customFields`) as `property_group_option.customFields`, `property_group_option.translation.createdAt`, `property_group_option.translation.updatedAt`, `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation.languageId` FROM `property_group_option` LEFT JOIN (SELECT `property_group_option.translation`.property_group_option_id, `property_group_option.translation`.name as `property_group_option.translation.name`, `property_group_option.translation`.position as `property_group_option.translation.position`, `property_group_option.translation`.custom_fields as `property_group_option.translation.customFields`, `property_group_option.translation`.created_at as `property_group_option.translation.createdAt`, `property_group_option.translation`.updated_at as `property_group_option.translation.updatedAt`, `property_group_option.translation`.property_group_option_id as `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation`.language_id as `property_group_option.translation.languageId` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.language_id = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN `media` `property_group_option.media` ON `property_group_option`.`media_id` = `property_group_option.media`.`id` LEFT JOIN (SELECT `property_group_option.group.translation`.property_group_id, `property_group_option.group.translation`.name as `property_group_option.group.translation.name`, `property_group_option.group.translation`.description as `property_group_option.group.translation.description`, `property_group_option.group.translation`.position as `property_group_option.group.translation.position`, `property_group_option.group.translation`.custom_fields as `property_group_option.group.translation.customFields`, `property_group_option.group.translation`.created_at as `property_group_option.group.translation.createdAt`, `property_group_option.group.translation`.updated_at as `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation`.property_group_id as `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation`.language_id as `property_group_option.group.translation.languageId` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.language_id = ?) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.media.translation`.media_id, `property_group_option.media.translation`.title as `property_group_option.media.translation.title`, `property_group_option.media.translation`.alt as `property_group_option.media.translation.alt`, `property_group_option.media.translation`.custom_fields as `property_group_option.media.translation.customFields`, `property_group_option.media.translation`.created_at as `property_group_option.media.translation.createdAt`, `property_group_option.media.translation`.updated_at as `property_group_option.media.translation.updatedAt`, `property_group_option.media.translation`.media_id as `property_group_option.media.translation.mediaId`, `property_group_option.media.translation`.language_id as `property_group_option.media.translation.languageId` FROM `media_translation` `property_group_option.media.translation` WHERE `property_group_option.media.translation`.language_id = ?) `property_group_option.media.media_translation` ON `property_group_option.media.media_translation`.`media_id` = `property_group_option.media`.`id` WHERE `property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01èe\x10ü¨p/Ä~Ý\rSö ª" b"\x01Še\x10‚\x02pë½üÀdÕ¬“\x1C" b"\x01èe\x10é#püöÍ\x18▀Ó´\x07&" b"\x01Še\x10‚@r\x02‚Ü~†\x02Ü\x1A-" b"\x01Še\x10‚Kpm•Rý²ôbàù" b"\x01Še\x10‚Qpd»gÅû‚,&½" b"\x01Še\x10‚]s˜ MÉ‘âLôš" b"\x01Še\x10‚iq;¥AÍp7 ûX" b"\x01Še\x10‚~s\f‹ö¿÷êyrŠ" b"\x01Še\x10‚ˆsS¬$Twж6" b"\x01Še\x10‚šrI’J#ôŽyÄ’" b"\x01èe\x10é×pÝü\x06\x7F.=îg²" b"\x01èe\x10éªr╦½Y║É©» D" b"\x01Še\x10‚³rߊi\x13^de¯Ì" b"\x01èe\x10ë6qRÇÀÆ'4\x1DÏÉ" b"\x01èe\x10ëFq»ìv+ sJ■×" b"\x01Še\x10‰aq}†sÅ8™Šÿþ" b"\x01Še\x10‰ŸrB‹–²ÐrI$Û" b"\x01èe\x10ëúp,üe\rûX?▀," b"\x01èe\x10ë┤pÚü─Q¥>ËÜR" b"\x01Še\x10‰ñq\x10…zFÚçÓ\x10\x1E" b"\x01Še\x10‰üqBŸ¢‡Ó\x13iJä" b"\x01Še\x10Šar¸¾Xê+Ëñ:0" b"\x01Še\x10Šys¹€I;ÝøÖº" b"\x01Še\x10‘\vpð‰3•ÝxÉ0ƒ" b"\x01Še\x10‘2q)Š¿ï÷ᨛõ" b""" \x01Še\x10‘FrE¹\n /#j*Šq """ b"\x01Še\x10‘SrC„€ÿDU¨üG" b"\x01èe\x10æ║p■ñ'µus;éÅ" b"\x01Še\x10‘Ìpz±Ñ\x0EÛ‚6Zš" b"\x01Še\x10’\es*¢½Ýû\x00³R\x14" b"\x01èe\x10Æ!sZÁ\x1F¬®Pü¢¦" b"\x01Še\x10’Wpâ´\x04$hLÔ…\x0E" b"\x01Še\x10™¢rö±`\r—\x1E\x16í±" b"\x01Še\x10™åp¨£HÚ\x1D2sv\x10" b"\x01èe\x10ÜAs^ɨQ\x1E┤^," b"\x01Še\x10š„pÅ£\fŸdV\x13©R" b"\x01Še\x10šßqÖ˜ÒÞ»•3Ì\x00" b"\x01Še\x10šåp´\x1EfA4MSÅ" b"\x01Še\x10šës½Šî\x07<\x01º|>" b"\x01Še\x10šõp½‚0\eX½»™ý" b"\x01èe\x10ø\x06r╠×▒¤Øø¹h\x18" b"\x01Še\x10›\x0FsèªIcÛâVAð" b"\x01Še\x10›\x1Ep¾±QxàŒ\x00PI" b"\x01Še\x10›)q+ªðggî*)ž" b"\x01Še\x10›-sû”Áf–#Â*¬" b"\x01èe\x10ø6rìèıë<G0Gg" b"\x01Še\x10›Ks\x07¿ì¥o}>ø\x08" b"\x01Še\x10£ys,·M`nkÙe\x12" b"\x01Še\x10£Öpà¡\t\x15G}\x0EN\x1C" b"\x01èe\x10ú÷r*üKHê\x11¯ãR" b"\x01Še\x10¤\x14s]”4÷ncÿ%\x1E" b"\x01Še\x10¤2p\x0F›¬¨0èðwá" b"\x01Še\x10¤CrUŠJÈ[\x04d¸Ç" b"\x01Še\x10¤hrߌaÏ·vä\x13’" b"\x01èe\x10ñçpì½Z÷┐b^0\x1E" b"\x01èe\x10ñùsùü╦]\x11!ÜÓù" b"\x01Še\x10¤ sîŒ+Úv\x08ARL" b"\x01Še\x10¤¨s\x19¬ë×.í¸Ãr" b"\x01Še\x10¤³p›…C:©á\x1C\x04ú" b"\x01èe\x10ªDqBÅ╬ä\x1Cxù¿=" b"\x01èe\x10ªTp£ÁìÅu\eú\eç" b"\x01èe\x10ª┐s┐ÀhØþKµ┴" b"\x01Še\x10¦Ãs\x1E°¶‘þ{Dîd" b"\x01Še\x10®£r3¨]É\x18u©â%" b"\x01Še\x10®ÆpÁ•4WÍ¢\x12´\x17" b"\x01èe\x10»ÃpÒ¿æe¬¦üæ°" b"\x01Še\x10¯ûsñ»_\rº\x19I\x07:" b"\x01Še\x10°-rþ‚*'áYß±°" b"\x01Še\x10°Dr-¹1\x1CߊKb9" b"\x01Še\x10°Qsú°Ài^\x06\x11‰:" b"\x01Še\x10°Ur&¸\x1DÞ¡æ·…h" b"\x01Še\x10°br¶»sD1ѸH#" b"\x01Še\x10°þr¼›Ï¿ä|Äf•" b"\x01Še\x10±\x01p„‘Ö©ÙúZ>ð" b"\x01èe\x10╣Ës═æ¤T6\x1C2Ø»" b"\x01Še\x10ºVr ‡)ŒÄ2d8í" b"\x01èe\x10║▓sÚ¡┘Øá\x01 AO" b"\x01Še\x10ºÏp\x08®´”ð*+%Ç" b"\x01Še\x10»\x18q\tŒz&8ñM̈" b"\x01Še\x10½‡p\x05¦\x16\x00Ç\x13g\x19˜" b"\x01Še\x10½Œs\x04²Š;Ƴ‚òÖ" b"\x01Še\x10½¹rÔ¤·{\x0FÆr²\v" b"\x01Še\x10½¾pa˜Wãæ\x10àqì" b"\x01Še\x10½ór –5ҪŒ;ª" b"\x01Še\x10¾\x03s³”\x01Ïy‹å#]" b"\x01Še\x10¾\x08pl¸ð2P¡i\x05£" b"\x01Še\x10¾7p\x1E…Éå\x06–\x1AeM" b"\x01Še\x10¾˜q~¾)›uüŠ€{" b"\x01Še\x10¾Ïs\x17“µ;\rš$àÛ" b"\x01èe\x10╚·rYØ█"\x08\x7Fµêo" b"\x01Še\x10ÉÞqå¤2dzL\x11U2" b"\x01Še\x10Éäs©ŒÔÈ-\x03žMV" b"\x01Še\x10Êîslj\x11ýÏ·<]ð" b"\x01Še\x10Ì-p„ŒfgÐb\x06"4" b"\x01Œh„¡=xi«‚¿Ìx÷ÄÆ" b"\x01ÆÉÏ\v¨z\x14åw¬¿\x14в9" b"\x01žmâØou-™|ÇÛê2Åå" b"ÿ±38:│J\x07º─\ØI\x06Áª" ] |
||||||||||||||||||
|
0.90 ms (3.83%) |
1 |
# product-listing-route::loading::aggregation::shipping-free-filter SELECT MAX(IFNULL(`product`.`shipping_free`, `product.parent`.`shipping_free`)) as `shipping-free` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id` AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id` AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) AND ((IFNULL(`product`.`shipping_free`, `product.parent`.`shipping_free`) = ?))
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" 30 b"+O‘œsýLö¦Å¦‹š˜\x173" true b"\x01èe\v║5s2ù\x15kAü9}." null true false true ] |
||||||||||||||||||
|
0.85 ms (3.62%) |
1 |
# product-listing-route::loading::aggregation::options SELECT LOWER(HEX(`product.options`.`id`)) as `options.key`, COUNT(`product`.`id`) as `options.count` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id` AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `product_option` `product.options.mapping` ON `product`.`id` = `product.options.mapping`.`product_id` AND `product`.`version_id` = `product.options.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id` AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` LEFT JOIN `property_group_option` `product.options` ON `product.options.mapping`.`property_group_option_id` = `product.options`.`id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product.options`.`id`
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" 30 b"+O‘œsýLö¦Å¦‹š˜\x173" true b"\x01èe\v║5s2ù\x15kAü9}." null true false ] |
||||||||||||||||||
|
0.67 ms (2.87%) |
1 |
# product-listing::property-filter::search-ids SELECT `property_group_option`.`id` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` WHERE ((`property_group_option.group`.`filterable` = ?)) AND (`property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY `property_group_option`.`id` ASC LIMIT 500
Parameters:
[ true b"\x01Še\x10‚iq;¥AÍp7 ûX" b"\x01Še\x10‚ˆsS¬$Twж6" b"\x01Še\x10‚³rߊi\x13^de¯Ì" b"\x01Še\x10‰üqBŸ¢‡Ó\x13iJä" b"\x01Še\x10‘\vpð‰3•ÝxÉ0ƒ" b"\x01èe\x10Æ!sZÁ\x1F¬®Pü¢¦" b"\x01Še\x10š„pÅ£\fŸdV\x13©R" b"\x01Še\x10šåp´\x1EfA4MSÅ" b"\x01Še\x10šõp½‚0\eX½»™ý" b"\x01Še\x10›Ks\x07¿ì¥o}>ø\x08" b"\x01èe\x10ú÷r*üKHê\x11¯ãR" b"\x01Še\x10¤\x14s]”4÷ncÿ%\x1E" b"\x01Še\x10¤hrߌaÏ·vä\x13’" b"\x01èe\x10ñçpì½Z÷┐b^0\x1E" b"\x01Še\x10¤¨s\x19¬ë×.í¸Ãr" b"\x01Še\x10¤³p›…C:©á\x1C\x04ú" b"\x01èe\x10ªDqBÅ╬ä\x1Cxù¿=" b"\x01Še\x10¯ûsñ»_\rº\x19I\x07:" b"\x01Še\x10°Qsú°Ài^\x06\x11‰:" b"\x01Še\x10°þr¼›Ï¿ä|Äf•" b"\x01Še\x10ºÏp\x08®´”ð*+%Ç" b"\x01Še\x10½ór –5ҪŒ;ª" b"ÿ±38:│J\x07º─\ØI\x06Áª" b"\x01èe\x10ëFq»ìv+ sJ■×" b"\x01Še\x10’\es*¢½Ýû\x00³R\x14" b"\x01èe\x10ÜAs^ɨQ\x1E┤^," b"\x01Še\x10¦Ãs\x1E°¶‘þ{Dîd" b"\x01Še\x10Ì-p„ŒfgÐb\x06"4" b"\x01Še\x10‚]s˜ MÉ‘âLôš" b"\x01Še\x10‚~s\f‹ö¿÷êyrŠ" b"\x01èe\x10ëúp,üe\rûX?▀," b"\x01èe\x10æ║p■ñ'µus;éÅ" b"\x01Še\x10™åp¨£HÚ\x1D2sv\x10" b"\x01Še\x10šßqÖ˜ÒÞ»•3Ì\x00" b"\x01Še\x10£ys,·M`nkÙe\x12" b"\x01Še\x10£Öpà¡\t\x15G}\x0EN\x1C" b"\x01èe\x10ª┐s┐ÀhØþKµ┴" b"\x01Še\x10±\x01p„‘Ö©ÙúZ>ð" b"\x01èe\x10ë6qRÇÀÆ'4\x1DÏÉ" b"\x01Še\x10Šar¸¾Xê+Ëñ:0" b"\x01Še\x10‰ŸrB‹–²ÐrI$Û" b"\x01Še\x10¤ sîŒ+Úv\x08ARL" b"\x01èe\x10»ÃpÒ¿æe¬¦üæ°" b"\x01Še\x10°-rþ‚*'áYß±°" b"\x01Še\x10°Dr-¹1\x1CߊKb9" b"\x01Še\x10°Ur&¸\x1DÞ¡æ·…h" b"\x01Še\x10¾\x08pl¸ð2P¡i\x05£" b"\x01Œh„¡=xi«‚¿Ìx÷ÄÆ" b"\x01ÆÉÏ\v¨z\x14åw¬¿\x14в9" b"\x01Še\x10‘2q)Š¿ï÷ᨛõ" b""" \x01Še\x10‘FrE¹\n /#j*Šq """ b"\x01Še\x10›)q+ªðggî*)ž" b"\x01Še\x10›-sû”Áf–#Â*¬" b"\x01Še\x10®ÆpÁ•4WÍ¢\x12´\x17" b"\x01Še\x10¾˜q~¾)›uüŠ€{" b"\x01Še\x10‰aq}†sÅ8™Šÿþ" b"\x01èe\x10ü¨p/Ä~Ý\rSö ª" b"\x01Še\x10‚\x02pë½üÀdÕ¬“\x1C" b"\x01èe\x10é#püöÍ\x18▀Ó´\x07&" b"\x01Še\x10‚Qpd»gÅû‚,&½" b"\x01Še\x10‚šrI’J#ôŽyÄ’" b"\x01èe\x10é×pÝü\x06\x7F.=îg²" b"\x01Še\x10Šys¹€I;ÝøÖº" b"\x01Še\x10‘SrC„€ÿDU¨üG" b"\x01Še\x10’Wpâ´\x04$hLÔ…\x0E" b"\x01Še\x10™¢rö±`\r—\x1E\x16í±" b"\x01Še\x10šës½Šî\x07<\x01º|>" b"\x01èe\x10ø\x06r╠×▒¤Øø¹h\x18" b"\x01Še\x10›\x0FsèªIcÛâVAð" b"\x01Še\x10»\x18q\tŒz&8ñM̈" b"\x01èe\x10╚·rYØ█"\x08\x7Fµêo" b"\x01èe\x10ø6rìèıë<G0Gg" b"\x01èe\x10║▓sÚ¡┘Øá\x01 AO" b"\x01Še\x10¾7p\x1E…Éå\x06–\x1AeM" b"\x01èe\x10éªr╦½Y║É©» D" b"\x01Še\x10¤CrUŠJÈ[\x04d¸Ç" b"\x01Še\x10‘Ìpz±Ñ\x0EÛ‚6Zš" b"\x01Še\x10®£r3¨]É\x18u©â%" b"\x01Še\x10‚@r\x02‚Ü~†\x02Ü\x1A-" b"\x01žmâØou-™|ÇÛê2Åå" b"\x01èe\x10ªTp£ÁìÅu\eú\eç" b"\x01Še\x10‚Kpm•Rý²ôbàù" b"\x01Še\x10¤2p\x0F›¬¨0èðwá" b"\x01Še\x10ºVr ‡)ŒÄ2d8í" b"\x01Še\x10½Œs\x04²Š;Ƴ‚òÖ" b"\x01Še\x10½¹rÔ¤·{\x0FÆr²\v" b"\x01Še\x10½¾pa˜Wãæ\x10àqì" b"\x01Še\x10¾\x03s³”\x01Ïy‹å#]" b"\x01Še\x10¾Ïs\x17“µ;\rš$àÛ" b"\x01Še\x10ÉÞqå¤2dzL\x11U2" b"\x01Še\x10Éäs©ŒÔÈ-\x03žMV" b"\x01Še\x10Êîslj\x11ýÏ·<]ð" b"\x01Še\x10›\x1Ep¾±QxàŒ\x00PI" b"\x01Še\x10°br¶»sD1ѸH#" b"\x01Še\x10½‡p\x05¦\x16\x00Ç\x13g\x19˜" b"\x01èe\x10ë┤pÚü─Q¥>ËÜR" b"\x01Še\x10‰ñq\x10…zFÚçÓ\x10\x1E" b"\x01èe\x10ñùsùü╦]\x11!ÜÓù" b"\x01èe\x10╣Ës═æ¤T6\x1C2Ø»" ] |
||||||||||||||||||
|
0.66 ms (2.83%) |
2 |
# app-scripts::refresh::read SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`write_access` as `app.integration.writeAccess`, `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`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" true ] |
||||||||||||||||||
|
0.65 ms (2.77%) |
6 |
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ôb╔\x02ïs└Ç\x18*╦üõÝ!"
]
|
||||||||||||||||||
|
0.59 ms (2.53%) |
1 |
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE ?
Parameters:
[
"payload"
]
|
||||||||||||||||||
|
0.54 ms (2.30%) |
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:
[]
|
||||||||||||||||||
|
0.53 ms (2.26%) |
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`, COALESCE(`shipping_method.deliveryTime.translation.name`,`shipping_method.deliveryTime.translation.name`) as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.customFields`,`shipping_method.deliveryTime.translation.customFields`) as `shipping_method.deliveryTime.customFields`, `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation.languageId`, `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`, COALESCE(`shipping_method.media.translation.title`,`shipping_method.media.translation.title`) as `shipping_method.media.title`, `shipping_method.media.translation.alt`, COALESCE(`shipping_method.media.translation.alt`,`shipping_method.media.translation.alt`) as `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, COALESCE(`shipping_method.media.translation.customFields`,`shipping_method.media.translation.customFields`) as `shipping_method.media.customFields`, `shipping_method.media.translation.createdAt`, `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation.mediaId`, `shipping_method.media.translation.languageId`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.name`,`shipping_method.translation.name`) as `shipping_method.name`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.description`,`shipping_method.translation.description`) as `shipping_method.description`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.trackingUrl`,`shipping_method.translation.trackingUrl`) as `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.customFields`,`shipping_method.translation.customFields`) as `shipping_method.customFields`, `shipping_method.translation.createdAt`, `shipping_method.translation.updatedAt`, `shipping_method.translation.shippingMethodId`, `shipping_method.translation.languageId` FROM `shipping_method` LEFT JOIN (SELECT `shipping_method.translation`.shipping_method_id, `shipping_method.translation`.name as `shipping_method.translation.name`, `shipping_method.translation`.description as `shipping_method.translation.description`, `shipping_method.translation`.tracking_url as `shipping_method.translation.trackingUrl`, `shipping_method.translation`.custom_fields as `shipping_method.translation.customFields`, `shipping_method.translation`.created_at as `shipping_method.translation.createdAt`, `shipping_method.translation`.updated_at as `shipping_method.translation.updatedAt`, `shipping_method.translation`.shipping_method_id as `shipping_method.translation.shippingMethodId`, `shipping_method.translation`.language_id as `shipping_method.translation.languageId` 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 `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.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`, `shipping_method.deliveryTime.translation`.created_at as `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation`.updated_at as `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation`.delivery_time_id as `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation`.language_id as `shipping_method.deliveryTime.translation.languageId` 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`.title as `shipping_method.media.translation.title`, `shipping_method.media.translation`.alt as `shipping_method.media.translation.alt`, `shipping_method.media.translation`.custom_fields as `shipping_method.media.translation.customFields`, `shipping_method.media.translation`.created_at as `shipping_method.media.translation.createdAt`, `shipping_method.media.translation`.updated_at as `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation`.media_id as `shipping_method.media.translation.mediaId`, `shipping_method.media.translation`.language_id as `shipping_method.media.translation.languageId` 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"ùýóÊî8IïØAR(¶┤§\e" ] |
||||||||||||||||||
|
0.50 ms (2.15%) |
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"
]
|
||||||||||||||||||
|
0.48 ms (2.04%) |
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"\x01Še\x10‚iq;¥AÍp7 ûX" b"\x01Še\x10‚ˆsS¬$Twж6" b"\x01Še\x10‚³rߊi\x13^de¯Ì" b"\x01Še\x10‰üqBŸ¢‡Ó\x13iJä" b"\x01Še\x10‘\vpð‰3•ÝxÉ0ƒ" b"\x01èe\x10Æ!sZÁ\x1F¬®Pü¢¦" b"\x01Še\x10š„pÅ£\fŸdV\x13©R" b"\x01Še\x10šåp´\x1EfA4MSÅ" b"\x01Še\x10šõp½‚0\eX½»™ý" b"\x01Še\x10›Ks\x07¿ì¥o}>ø\x08" b"\x01èe\x10ú÷r*üKHê\x11¯ãR" b"\x01Še\x10¤\x14s]”4÷ncÿ%\x1E" b"\x01Še\x10¤hrߌaÏ·vä\x13’" b"\x01èe\x10ñçpì½Z÷┐b^0\x1E" b"\x01Še\x10¤¨s\x19¬ë×.í¸Ãr" b"\x01Še\x10¤³p›…C:©á\x1C\x04ú" b"\x01èe\x10ªDqBÅ╬ä\x1Cxù¿=" b"\x01Še\x10¯ûsñ»_\rº\x19I\x07:" b"\x01Še\x10°Qsú°Ài^\x06\x11‰:" b"\x01Še\x10°þr¼›Ï¿ä|Äf•" b"\x01Še\x10ºÏp\x08®´”ð*+%Ç" b"\x01Še\x10½ór –5ҪŒ;ª" b"ÿ±38:│J\x07º─\ØI\x06Áª" b"\x01èe\x10ëFq»ìv+ sJ■×" b"\x01Še\x10’\es*¢½Ýû\x00³R\x14" b"\x01èe\x10ÜAs^ɨQ\x1E┤^," b"\x01Še\x10¦Ãs\x1E°¶‘þ{Dîd" b"\x01Še\x10Ì-p„ŒfgÐb\x06"4" b"\x01Še\x10‚]s˜ MÉ‘âLôš" b"\x01Še\x10‚~s\f‹ö¿÷êyrŠ" b"\x01èe\x10ëúp,üe\rûX?▀," b"\x01èe\x10æ║p■ñ'µus;éÅ" b"\x01Še\x10™åp¨£HÚ\x1D2sv\x10" b"\x01Še\x10šßqÖ˜ÒÞ»•3Ì\x00" b"\x01Še\x10£ys,·M`nkÙe\x12" b"\x01Še\x10£Öpà¡\t\x15G}\x0EN\x1C" b"\x01èe\x10ª┐s┐ÀhØþKµ┴" b"\x01Še\x10±\x01p„‘Ö©ÙúZ>ð" b"\x01èe\x10ë6qRÇÀÆ'4\x1DÏÉ" b"\x01Še\x10Šar¸¾Xê+Ëñ:0" b"\x01Še\x10‰ŸrB‹–²ÐrI$Û" b"\x01Še\x10¤ sîŒ+Úv\x08ARL" b"\x01èe\x10»ÃpÒ¿æe¬¦üæ°" b"\x01Še\x10°-rþ‚*'áYß±°" b"\x01Še\x10°Dr-¹1\x1CߊKb9" b"\x01Še\x10°Ur&¸\x1DÞ¡æ·…h" b"\x01Še\x10¾\x08pl¸ð2P¡i\x05£" b"\x01Œh„¡=xi«‚¿Ìx÷ÄÆ" b"\x01ÆÉÏ\v¨z\x14åw¬¿\x14в9" b"\x01Še\x10‘2q)Š¿ï÷ᨛõ" b""" \x01Še\x10‘FrE¹\n /#j*Šq """ b"\x01Še\x10›)q+ªðggî*)ž" b"\x01Še\x10›-sû”Áf–#Â*¬" b"\x01Še\x10®ÆpÁ•4WÍ¢\x12´\x17" b"\x01Še\x10¾˜q~¾)›uüŠ€{" b"\x01Še\x10‰aq}†sÅ8™Šÿþ" b"\x01èe\x10ü¨p/Ä~Ý\rSö ª" b"\x01Še\x10‚\x02pë½üÀdÕ¬“\x1C" b"\x01èe\x10é#püöÍ\x18▀Ó´\x07&" b"\x01Še\x10‚Qpd»gÅû‚,&½" b"\x01Še\x10‚šrI’J#ôŽyÄ’" b"\x01èe\x10é×pÝü\x06\x7F.=îg²" b"\x01Še\x10Šys¹€I;ÝøÖº" b"\x01Še\x10‘SrC„€ÿDU¨üG" b"\x01Še\x10’Wpâ´\x04$hLÔ…\x0E" b"\x01Še\x10™¢rö±`\r—\x1E\x16í±" b"\x01Še\x10šës½Šî\x07<\x01º|>" b"\x01èe\x10ø\x06r╠×▒¤Øø¹h\x18" b"\x01Še\x10›\x0FsèªIcÛâVAð" b"\x01Še\x10»\x18q\tŒz&8ñM̈" b"\x01èe\x10╚·rYØ█"\x08\x7Fµêo" b"\x01èe\x10ø6rìèıë<G0Gg" b"\x01èe\x10║▓sÚ¡┘Øá\x01 AO" b"\x01Še\x10¾7p\x1E…Éå\x06–\x1AeM" b"\x01èe\x10éªr╦½Y║É©» D" b"\x01Še\x10¤CrUŠJÈ[\x04d¸Ç" b"\x01Še\x10‘Ìpz±Ñ\x0EÛ‚6Zš" b"\x01Še\x10®£r3¨]É\x18u©â%" b"\x01Še\x10‚@r\x02‚Ü~†\x02Ü\x1A-" b"\x01žmâØou-™|ÇÛê2Åå" b"\x01èe\x10ªTp£ÁìÅu\eú\eç" b"\x01Še\x10‚Kpm•Rý²ôbàù" b"\x01Še\x10¤2p\x0F›¬¨0èðwá" b"\x01Še\x10ºVr ‡)ŒÄ2d8í" b"\x01Še\x10½Œs\x04²Š;Ƴ‚òÖ" b"\x01Še\x10½¹rÔ¤·{\x0FÆr²\v" b"\x01Še\x10½¾pa˜Wãæ\x10àqì" b"\x01Še\x10¾\x03s³”\x01Ïy‹å#]" b"\x01Še\x10¾Ïs\x17“µ;\rš$àÛ" b"\x01Še\x10ÉÞqå¤2dzL\x11U2" b"\x01Še\x10Éäs©ŒÔÈ-\x03žMV" b"\x01Še\x10Êîslj\x11ýÏ·<]ð" b"\x01Še\x10›\x1Ep¾±QxàŒ\x00PI" b"\x01Še\x10°br¶»sD1ѸH#" b"\x01Še\x10½‡p\x05¦\x16\x00Ç\x13g\x19˜" b"\x01èe\x10ë┤pÚü─Q¥>ËÜR" b"\x01Še\x10‰ñq\x10…zFÚçÓ\x10\x1E" b"\x01èe\x10ñùsùü╦]\x11!ÜÓù" b"\x01èe\x10╣Ës═æ¤T6\x1C2Ø»" ] |
||||||||||||||||||
|
0.47 ms (2.00%) |
1 |
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"\x01ÄQ▓*ÑqôÉÝ$Mç)Jñ" b"\x01‹¯ Élpå‹6Õñ7ì6ä" b"\x06æùø_ˆM\x10¡4ÜjÙNI—" b"/ÖG–³\rMŸéu¡Îx{$" b"7Ý\x08ªœ·Eš¸\x122ó’^\v#" b"\x01‹¯5:e|\x08ª1\x05*\x1C\x12\x1F8" b"\x01‹³\x15NWr¡Œ¤õ2ìæPÄ" b"\x01˜ÐˆÖ\x14q¹‰ƒ}%3\x1F‡˜" b"äNg‚ÆBG·–¸‘Ï%®8÷" b"\x10ÜXh-\x0EE\ƒ³\x02~4ßÕ‚" ] |
||||||||||||||||||
|
0.45 ms (1.91%) |
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.analytics`.`id` as `sales_channel.analytics.id`, `sales_channel.analytics`.`tracking_id` as `sales_channel.analytics.trackingId`, `sales_channel.analytics`.`active` as `sales_channel.analytics.active`, `sales_channel.analytics`.`track_orders` as `sales_channel.analytics.trackOrders`, `sales_channel.analytics`.`anonymize_ip` as `sales_channel.analytics.anonymizeIp`, `sales_channel.analytics`.`created_at` as `sales_channel.analytics.createdAt`, `sales_channel.analytics`.`updated_at` as `sales_channel.analytics.updatedAt`, `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`, COALESCE(`sales_channel.currency.translation.shortName`,`sales_channel.currency.translation.shortName`) as `sales_channel.currency.shortName`, `sales_channel.currency.translation.name`, COALESCE(`sales_channel.currency.translation.name`,`sales_channel.currency.translation.name`) as `sales_channel.currency.name`, `sales_channel.currency.translation.customFields`, COALESCE(`sales_channel.currency.translation.customFields`,`sales_channel.currency.translation.customFields`) as `sales_channel.currency.customFields`, `sales_channel.currency.translation.createdAt`, `sales_channel.currency.translation.updatedAt`, `sales_channel.currency.translation.currencyId`, `sales_channel.currency.translation.languageId`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.name`,`sales_channel.translation.name`) as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) as `sales_channel.customFields`, `sales_channel.translation.createdAt`, `sales_channel.translation.updatedAt`, `sales_channel.translation.salesChannelId`, `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name as `sales_channel.translation.name`, `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`, `sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`, `sales_channel.translation`.created_at as `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id as `sales_channel.translation.languageId` 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 `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel`.`analytics_id` = `sales_channel.analytics`.`id` LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel`.`currency_id` = `sales_channel.currency`.`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`, `sales_channel.currency.translation`.created_at as `sales_channel.currency.translation.createdAt`, `sales_channel.currency.translation`.updated_at as `sales_channel.currency.translation.updatedAt`, `sales_channel.currency.translation`.currency_id as `sales_channel.currency.translation.currencyId`, `sales_channel.currency.translation`.language_id as `sales_channel.currency.translation.languageId` 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"+O‘œsýLö¦Å¦‹š˜\x173" ] |
||||||||||||||||||
|
0.43 ms (1.85%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[] |
||||||||||||||||||
|
0.43 ms (1.82%) |
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:
[]
|
||||||||||||||||||
|
0.41 ms (1.74%) |
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`, COALESCE(`payment_method.media.translation.title`,`payment_method.media.translation.title`) as `payment_method.media.title`, `payment_method.media.translation.alt`, COALESCE(`payment_method.media.translation.alt`,`payment_method.media.translation.alt`) as `payment_method.media.alt`, `payment_method.media.translation.customFields`, COALESCE(`payment_method.media.translation.customFields`,`payment_method.media.translation.customFields`) as `payment_method.media.customFields`, `payment_method.media.translation.createdAt`, `payment_method.media.translation.updatedAt`, `payment_method.media.translation.mediaId`, `payment_method.media.translation.languageId`, `payment_method.translation.name`, COALESCE(`payment_method.translation.name`,`payment_method.translation.name`) as `payment_method.name`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableName`) as `payment_method.distinguishableName`, `payment_method.translation.description`, COALESCE(`payment_method.translation.description`,`payment_method.translation.description`) as `payment_method.description`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.customFields`,`payment_method.translation.customFields`) as `payment_method.customFields`, `payment_method.translation.createdAt`, `payment_method.translation.updatedAt`, `payment_method.translation.paymentMethodId`, `payment_method.translation.languageId` FROM `payment_method` 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`, `payment_method.translation`.created_at as `payment_method.translation.createdAt`, `payment_method.translation`.updated_at as `payment_method.translation.updatedAt`, `payment_method.translation`.payment_method_id as `payment_method.translation.paymentMethodId`, `payment_method.translation`.language_id as `payment_method.translation.languageId` 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 `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.media.translation`.media_id, `payment_method.media.translation`.title as `payment_method.media.translation.title`, `payment_method.media.translation`.alt as `payment_method.media.translation.alt`, `payment_method.media.translation`.custom_fields as `payment_method.media.translation.customFields`, `payment_method.media.translation`.created_at as `payment_method.media.translation.createdAt`, `payment_method.media.translation`.updated_at as `payment_method.media.translation.updatedAt`, `payment_method.media.translation`.media_id as `payment_method.media.translation.mediaId`, `payment_method.media.translation`.language_id as `payment_method.media.translation.languageId` 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"\x1F\x07Wˆ\x16£L\x16™fV‚µ\x04^ý" ] |
||||||||||||||||||
|
0.40 ms (1.70%) |
1 |
# manufacturer-aggregation::read SELECT `product_manufacturer`.`id` as `product_manufacturer.id`, `product_manufacturer`.`version_id` as `product_manufacturer.versionId`, `product_manufacturer`.`media_id` as `product_manufacturer.mediaId`, `product_manufacturer`.`link` as `product_manufacturer.link`, `product_manufacturer`.`created_at` as `product_manufacturer.createdAt`, `product_manufacturer`.`updated_at` as `product_manufacturer.updatedAt`, `product_manufacturer.translation.name`, COALESCE(`product_manufacturer.translation.name`,`product_manufacturer.translation.name`) as `product_manufacturer.name`, `product_manufacturer.translation.description`, COALESCE(`product_manufacturer.translation.description`,`product_manufacturer.translation.description`) as `product_manufacturer.description`, `product_manufacturer.translation.customFields`, COALESCE(`product_manufacturer.translation.customFields`,`product_manufacturer.translation.customFields`) as `product_manufacturer.customFields`, `product_manufacturer.translation.createdAt`, `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation.languageId`, `product_manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.product_manufacturer_id, `product_manufacturer.translation`.product_manufacturer_version_id, `product_manufacturer.translation`.name as `product_manufacturer.translation.name`, `product_manufacturer.translation`.description as `product_manufacturer.translation.description`, `product_manufacturer.translation`.custom_fields as `product_manufacturer.translation.customFields`, `product_manufacturer.translation`.created_at as `product_manufacturer.translation.createdAt`, `product_manufacturer.translation`.updated_at as `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation`.product_manufacturer_id as `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation`.language_id as `product_manufacturer.translation.languageId`, `product_manufacturer.translation`.product_manufacturer_version_id as `product_manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer_translation` `product_manufacturer.translation` WHERE `product_manufacturer.translation`.language_id = ?) `product_manufacturer.product_manufacturer_translation` ON `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product_manufacturer`.`id` AND `product_manufacturer.product_manufacturer_translation`.product_manufacturer_version_id = `product_manufacturer`.version_id WHERE (`product_manufacturer`.`version_id` = ?) AND (`product_manufacturer`.`id` IN (?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"Ô‚\x11P•\x0EIÝ‘*\x06°_ϼ" b"o¾[!‡MBuƒ\x11I$ÿ\x00‹¼" b"\x01î9\x7FÞ\fz<ü°\x17ô"êð\x05" ] |
||||||||||||||||||
|
0.37 ms (1.60%) |
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"+O‘œsýLö¦Å¦‹š˜\x173"
]
|
||||||||||||||||||
|
0.37 ms (1.57%) |
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.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`, COALESCE(`tax_rule.type.translation.typeName`,`tax_rule.type.translation.typeName`) as `tax_rule.type.typeName`, `tax_rule.type.translation.createdAt`, `tax_rule.type.translation.updatedAt`, `tax_rule.type.translation.taxRuleTypeId`, `tax_rule.type.translation.languageId`, `tax_rule`.`created_at` as `tax_rule.createdAt`, `tax_rule`.`updated_at` as `tax_rule.updatedAt` 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`, `tax_rule.type.translation`.created_at as `tax_rule.type.translation.createdAt`, `tax_rule.type.translation`.updated_at as `tax_rule.type.translation.updatedAt`, `tax_rule.type.translation`.tax_rule_type_id as `tax_rule.type.translation.taxRuleTypeId`, `tax_rule.type.translation`.language_id as `tax_rule.type.translation.languageId` 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"\x04‹ÕÚæ:LU›Ù\x0EC\x15.æS" b"\r64ºjHÖØýç\x00´°ƒ¸" b""" C¥¡°ýÒNª•÷@\n ªêé8 """ ] |
||||||||||||||||||
|
0.35 ms (1.49%) |
2 |
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`, `script`.`name` AS scriptName, `script`.`script` AS script, `script`.`hook` AS hook, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, `app`.`version` AS appVersion, `script`.`active` AS active FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` != 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters:
[] |
||||||||||||||||||
|
0.32 ms (1.38%) |
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`, COALESCE(`currency.translation.shortName`,`currency.translation.shortName`) as `currency.shortName`, `currency.translation.name`, COALESCE(`currency.translation.name`,`currency.translation.name`) as `currency.name`, `currency.translation.customFields`, COALESCE(`currency.translation.customFields`,`currency.translation.customFields`) as `currency.customFields`, `currency.translation.createdAt`, `currency.translation.updatedAt`, `currency.translation.currencyId`, `currency.translation.languageId` 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`, `currency.translation`.created_at as `currency.translation.createdAt`, `currency.translation`.updated_at as `currency.translation.updatedAt`, `currency.translation`.currency_id as `currency.translation.currencyId`, `currency.translation`.language_id as `currency.translation.languageId` 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Í‚ó¬›ÑÀßÊ" ] |
||||||||||||||||||
|
0.29 ms (1.26%) |
1 |
# seo-url::resolve SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND (seo_path_info = ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"+O‘œsýLö¦Å¦‹š˜\x173" "widgets/cms/navigation/018a650bba35733297156b4181397d2e/filter" ] |
||||||||||||||||||
|
0.29 ms (1.24%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters:
[ b"+O‘œsýLö¦Å¦‹š˜\x173" "EasyCreditRatenkauf.config.%" ] |
||||||||||||||||||
|
0.28 ms (1.19%) |
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"+O‘œsýLö¦Å¦‹š˜\x173"
]
|
||||||||||||||||||
|
0.26 ms (1.11%) |
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`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, `country.translation.name`, COALESCE(`country.translation.name`,`country.translation.name`) as `country.name`, `country.translation.addressFormat`, COALESCE(`country.translation.addressFormat`,`country.translation.addressFormat`) as `country.addressFormat`, `country.translation.customFields`, COALESCE(`country.translation.customFields`,`country.translation.customFields`) as `country.customFields`, `country.translation.createdAt`, `country.translation.updatedAt`, `country.translation.countryId`, `country.translation.languageId` FROM `country` LEFT JOIN (SELECT `country.translation`.country_id, `country.translation`.name as `country.translation.name`, `country.translation`.address_format as `country.translation.addressFormat`, `country.translation`.custom_fields as `country.translation.customFields`, `country.translation`.created_at as `country.translation.createdAt`, `country.translation`.updated_at as `country.translation.updatedAt`, `country.translation`.country_id as `country.translation.countryId`, `country.translation`.language_id as `country.translation.languageId` 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"ý¸j░C"@ÅØ-Ú^╬@te" ] |
||||||||||||||||||
|
0.26 ms (1.11%) |
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"ý¸j░C"@ÅØ-Ú^╬@te" ] |
||||||||||||||||||
|
0.24 ms (1.04%) |
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.translation.name`, COALESCE(`customer_group.translation.name`,`customer_group.translation.name`) as `customer_group.name`, `customer_group.translation.registrationTitle`, COALESCE(`customer_group.translation.registrationTitle`,`customer_group.translation.registrationTitle`) as `customer_group.registrationTitle`, `customer_group.translation.registrationIntroduction`, COALESCE(`customer_group.translation.registrationIntroduction`,`customer_group.translation.registrationIntroduction`) as `customer_group.registrationIntroduction`, `customer_group.translation.registrationOnlyCompanyRegistration`, COALESCE(`customer_group.translation.registrationOnlyCompanyRegistration`,`customer_group.translation.registrationOnlyCompanyRegistration`) as `customer_group.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationSeoMetaDescription`, COALESCE(`customer_group.translation.registrationSeoMetaDescription`,`customer_group.translation.registrationSeoMetaDescription`) as `customer_group.registrationSeoMetaDescription`, `customer_group.translation.customFields`, COALESCE(`customer_group.translation.customFields`,`customer_group.translation.customFields`) as `customer_group.customFields`, `customer_group.translation.createdAt`, `customer_group.translation.updatedAt`, `customer_group.translation.customerGroupId`, `customer_group.translation.languageId` FROM `customer_group` LEFT JOIN (SELECT `customer_group.translation`.customer_group_id, `customer_group.translation`.name as `customer_group.translation.name`, `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`, `customer_group.translation`.custom_fields as `customer_group.translation.customFields`, `customer_group.translation`.created_at as `customer_group.translation.createdAt`, `customer_group.translation`.updated_at as `customer_group.translation.updatedAt`, `customer_group.translation`.customer_group_id as `customer_group.translation.customerGroupId`, `customer_group.translation`.language_id as `customer_group.translation.languageId` 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` WHERE `customer_group`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"$õ|éïÆB\t ÷§\x1A\x14ùDU" ] |
||||||||||||||||||
|
0.24 ms (1.03%) |
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"+O‘œsýLö¦Å¦‹š˜\x173"
]
|
||||||||||||||||||
|
0.24 ms (1.03%) |
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"+O‘œsýLö¦Å¦‹š˜\x173" "/widgets/cms/navigation/018a650bba35733297156b4181397d2e/filter" ] |
||||||||||||||||||
|
0.24 ms (1.01%) |
1 |
SELECT `easycredit_payment_state`.`token` as `easycredit_payment_state.token`, `easycredit_payment_state`.`payload` as `easycredit_payment_state.payload`, `easycredit_payment_state`.`created_at` as `easycredit_payment_state.createdAt`, `easycredit_payment_state`.`updated_at` as `easycredit_payment_state.updatedAt` FROM `easycredit_payment_state` WHERE `easycredit_payment_state`.`token` IN (?)
Parameters:
[
"GrZMu8siIcqpkEXHR2JSOyqSLvG6kZ6v"
]
|
||||||||||||||||||
|
0.22 ms (0.95%) |
2 |
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`, `script`.`name` AS name, `script`.`script` AS script, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` = 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters:
[] |
||||||||||||||||||
|
0.18 ms (0.75%) |
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:
[]
|
||||||||||||||||||
|
0.17 ms (0.74%) |
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:
[] |
||||||||||||||||||
|
0.16 ms (0.67%) |
1 |
SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`type` as `cms_slot.type`, `cms_slot`.`slot` as `cms_slot.slot`, `cms_slot`.`locked` as `cms_slot.locked`, `cms_slot`.`cms_block_id` as `cms_slot.blockId`, `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.translation.config`, COALESCE(`cms_slot.translation.config`,`cms_slot.translation.config`) as `cms_slot.config`, `cms_slot.translation.customFields`, COALESCE(`cms_slot.translation.customFields`,`cms_slot.translation.customFields`) as `cms_slot.customFields`, `cms_slot.translation.createdAt`, `cms_slot.translation.updatedAt`, `cms_slot.translation.cmsSlotId`, `cms_slot.translation.languageId`, `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation`.cms_slot_id, `cms_slot.translation`.cms_slot_version_id, `cms_slot.translation`.config as `cms_slot.translation.config`, `cms_slot.translation`.custom_fields as `cms_slot.translation.customFields`, `cms_slot.translation`.created_at as `cms_slot.translation.createdAt`, `cms_slot.translation`.updated_at as `cms_slot.translation.updatedAt`, `cms_slot.translation`.cms_slot_id as `cms_slot.translation.cmsSlotId`, `cms_slot.translation`.language_id as `cms_slot.translation.languageId`, `cms_slot.translation`.cms_slot_version_id as `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation`.language_id = ?) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` AND `cms_slot.cms_slot_translation`.cms_slot_version_id = `cms_slot`.version_id WHERE (`cms_slot`.`version_id` = ?) AND (`cms_slot`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"ÅÒ\x19>’€Hà¾ãÆÄšUHW" ] |
||||||||||||||||||
|
0.16 ms (0.67%) |
1 |
# product-listing::load-sortings::read SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.translation.label`, COALESCE(`product_sorting.translation.label`,`product_sorting.translation.label`) as `product_sorting.label`, `product_sorting.translation.createdAt`, `product_sorting.translation.updatedAt`, `product_sorting.translation.productSortingId`, `product_sorting.translation.languageId` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.product_sorting_id, `product_sorting.translation`.label as `product_sorting.translation.label`, `product_sorting.translation`.created_at as `product_sorting.translation.createdAt`, `product_sorting.translation`.updated_at as `product_sorting.translation.updatedAt`, `product_sorting.translation`.product_sorting_id as `product_sorting.translation.productSortingId`, `product_sorting.translation`.language_id as `product_sorting.translation.languageId` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.language_id = ?) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"äe-\û\x1DL7¤¤iY×Qß*" b"üšg¸ó¬NMƒAg¸¸_ÿc" b"÷vJÈ\x05‰@˳Bò-\x05à*‘" b"\x01ïųv\x1Dz\x07ܹG=G▄ºâ" b"àÛq█¼5J\f║▄@rWc*ü" b"¨ÐäçS\fEZˆv²7ÝêÑÊ" b"╬$|ØÂ║F÷ÉSsbI4MÑ" ] |
||||||||||||||||||
|
0.16 ms (0.67%) |
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Œ4Ö/'|ú³\x7Fô·=;+X" b"\x01É9└|2pü¢km─<Ñ\x1A┌" b"\x01ÄQ▓*ÑqôÉÝ$Mç)Jñ" b"ë^‡´\x0EGGܵ,\x11ý4ÈÌÿ" b"\x01ï»\x1F±ƒpí▓╦‗█Ø^\vD" b"\x01‹¯ Élpå‹6Õñ7ì6ä" b"\x01ŒCŒ\x0Evq•©\x10{š'\x15A–" b"\x01Ž\x1Dî´>x\’9²¼Èš8†" b"\x01ŽQ¥¾˜w(¶Rò\x12 ìõ." b"\x01Å|\x10±ùq,åÊ\x02R¯ƒÓ¢" b"\x01×mؼ5sö╣8´\x10;í\x10╔" b"\x06æùø_ˆM\x10¡4ÜjÙNI—" b"/ÖG–³\rMŸéu¡Îx{$" b"7Ý\x08ªœ·Eš¸\x122ó’^\v#" b"—ôWT¯¹K\x7Fª„Ⱥ\x15Y@\x05" b"\x13Ã\x1D%┤ÖNÀÁÜ\x12─Å\x07Ö¡" b"\x01‹¯5:e|\x08ª1\x05*\x1C\x12\x1F8" b"\x01‹³\x15NWr¡Œ¤õ2ìæPÄ" b"\x01˜ÐˆÖ\x14q¹‰ƒ}%3\x1F‡˜" b"žN;$¿\x14J±–DÇ\tÔ ¥Ï" b"¾\x0F{’o¬Gj€\x12ð”7¶ñ9" b"äNg‚ÆBG·–¸‘Ï%®8÷" b"\x01Še\võæs—ºˆ¤4\x05‹’m" b"\x01Še\f\x0ERpr¤$\x19<Â×›ƒ" b"\x10ÜXh-\x0EE\ƒ³\x02~4ßÕ‚" b"Ãü\r¨ï`Gtá°¼FJYER" ] |
||||||||||||||||||
|
0.16 ms (0.67%) |
1 |
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[ b"+O‘œsýLö¦Å¦‹š˜\x173" "GrZMu8siIcqpkEXHR2JSOyqSLvG6kZ6v" ] |
||||||||||||||||||
|
0.14 ms (0.60%) |
1 |
#cart-persister::load SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters:
[
"GrZMu8siIcqpkEXHR2JSOyqSLvG6kZ6v"
]
|
||||||||||||||||||
|
0.11 ms (0.48%) |
1 |
SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id` WHERE ((`country.salesChannels`.`id` = ?)) AND (`country`.`id` IN (?)) GROUP BY `country`.`id`
Parameters:
[ b"+O‘œsýLö¦Å¦‹š˜\x173" b"ý¸j░C"@ÅØ-Ú^╬@te" ] |
||||||||||||||||||
|
0.10 ms (0.43%) |
1 |
SELECT `cms_slot`.`id` FROM `cms_slot` WHERE (`cms_slot`.`version_id` = ?) AND (`cms_slot`.`id` IN (?)) LIMIT 1
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" b"ÅÒ\x19>’€Hà¾ãÆÄšUHW" ] |
||||||||||||||||||
|
0.10 ms (0.41%) |
1 |
# product-listing-route::category-loading::search-ids SELECT `category`.`id`, `category`.`auto_increment` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?)) LIMIT 1
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01èe\v║5s2ù\x15kAü9}." ] |
||||||||||||||||||
|
0.09 ms (0.40%) |
1 |
# cart-rule-loader::load-rules::search-ids SELECT `rule`.`id` FROM `rule` ORDER BY `rule`.`priority` DESC, `rule`.`id` ASC LIMIT 500
Parameters:
[] |
||||||||||||||||||
|
0.09 ms (0.38%) |
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
]
|
||||||||||||||||||
|
0.06 ms (0.25%) |
1 |
# product-listing-route::category-loading::read SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`product_stream_id` as `category.productStreamId` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01èe\v║5s2ù\x15kAü9}." ] |
Database Connections
| Name | Service |
|---|---|
| 0 | default |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.