GET https://sw6stagingbehropur.behr-labor.eu/checkout/cart

Response
200 OK
IP
216.73.216.62
Profiled on
Token
aac198

Query Metrics

55 Database Queries
45 Different statements
127.55 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
10.69 ms
(8.38%) 		1 
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`.`technical_name` as `payment_method.technicalName`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `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.appPaymentMethod.app`.`id` as `payment_method.appPaymentMethod.app.id`, `payment_method.appPaymentMethod.app`.`name` as `payment_method.appPaymentMethod.app.name`, `payment_method.appPaymentMethod.app`.`path` as `payment_method.appPaymentMethod.app.path`, `payment_method.appPaymentMethod.app`.`author` as `payment_method.appPaymentMethod.app.author`, `payment_method.appPaymentMethod.app`.`copyright` as `payment_method.appPaymentMethod.app.copyright`, `payment_method.appPaymentMethod.app`.`license` as `payment_method.appPaymentMethod.app.license`, `payment_method.appPaymentMethod.app`.`active` as `payment_method.appPaymentMethod.app.active`, `payment_method.appPaymentMethod.app`.`configurable` as `payment_method.appPaymentMethod.app.configurable`, `payment_method.appPaymentMethod.app`.`privacy` as `payment_method.appPaymentMethod.app.privacy`, `payment_method.appPaymentMethod.app`.`version` as `payment_method.appPaymentMethod.app.version`, `payment_method.appPaymentMethod.app`.`icon` as `payment_method.appPaymentMethod.app.iconRaw`, `payment_method.appPaymentMethod.app`.`app_secret` as `payment_method.appPaymentMethod.app.appSecret`, `payment_method.appPaymentMethod.app`.`modules` as `payment_method.appPaymentMethod.app.modules`, `payment_method.appPaymentMethod.app`.`main_module` as `payment_method.appPaymentMethod.app.mainModule`, `payment_method.appPaymentMethod.app`.`cookies` as `payment_method.appPaymentMethod.app.cookies`, `payment_method.appPaymentMethod.app`.`allow_disable` as `payment_method.appPaymentMethod.app.allowDisable`, `payment_method.appPaymentMethod.app`.`base_app_url` as `payment_method.appPaymentMethod.app.baseAppUrl`, `payment_method.appPaymentMethod.app`.`allowed_hosts` as `payment_method.appPaymentMethod.app.allowedHosts`, `payment_method.appPaymentMethod.app`.`template_load_priority` as `payment_method.appPaymentMethod.app.templateLoadPriority`, `payment_method.appPaymentMethod.app`.`checkout_gateway_url` as `payment_method.appPaymentMethod.app.checkoutGatewayUrl`, `payment_method.appPaymentMethod.app`.`context_gateway_url` as `payment_method.appPaymentMethod.app.contextGatewayUrl`, `payment_method.appPaymentMethod.app`.`in_app_purchases_gateway_url` as `payment_method.appPaymentMethod.app.inAppPurchasesGatewayUrl`, `payment_method.appPaymentMethod.app`.`source_type` as `payment_method.appPaymentMethod.app.sourceType`, `payment_method.appPaymentMethod.app`.`source_config` as `payment_method.appPaymentMethod.app.sourceConfig`, `payment_method.appPaymentMethod.app`.`self_managed` as `payment_method.appPaymentMethod.app.selfManaged`, `payment_method.appPaymentMethod.app`.`requested_privileges` as `payment_method.appPaymentMethod.app.requestedPrivileges`, `payment_method.appPaymentMethod.app`.`integration_id` as `payment_method.appPaymentMethod.app.integrationId`, `payment_method.appPaymentMethod.app.integration`.`id` as `payment_method.appPaymentMethod.app.integration.id`, `payment_method.appPaymentMethod.app.integration`.`label` as `payment_method.appPaymentMethod.app.integration.label`, `payment_method.appPaymentMethod.app.integration`.`access_key` as `payment_method.appPaymentMethod.app.integration.accessKey`, `payment_method.appPaymentMethod.app.integration`.`secret_access_key` as `payment_method.appPaymentMethod.app.integration.secretAccessKey`, `payment_method.appPaymentMethod.app.integration`.`last_usage_at` as `payment_method.appPaymentMethod.app.integration.lastUsageAt`, `payment_method.appPaymentMethod.app.integration`.`admin` as `payment_method.appPaymentMethod.app.integration.admin`, `payment_method.appPaymentMethod.app.integration`.`custom_fields` as `payment_method.appPaymentMethod.app.integration.customFields`, `payment_method.appPaymentMethod.app.integration`.`deleted_at` as `payment_method.appPaymentMethod.app.integration.deletedAt`, `payment_method.appPaymentMethod.app.integration`.`created_at` as `payment_method.appPaymentMethod.app.integration.createdAt`, `payment_method.appPaymentMethod.app.integration`.`updated_at` as `payment_method.appPaymentMethod.app.integration.updatedAt`, `payment_method.appPaymentMethod.app`.`acl_role_id` as `payment_method.appPaymentMethod.app.aclRoleId`, `payment_method.appPaymentMethod.app.aclRole`.`id` as `payment_method.appPaymentMethod.app.aclRole.id`, `payment_method.appPaymentMethod.app.aclRole`.`name` as `payment_method.appPaymentMethod.app.aclRole.name`, `payment_method.appPaymentMethod.app.aclRole`.`description` as `payment_method.appPaymentMethod.app.aclRole.description`, `payment_method.appPaymentMethod.app.aclRole`.`privileges` as `payment_method.appPaymentMethod.app.aclRole.privileges`, `payment_method.appPaymentMethod.app.aclRole`.`deleted_at` as `payment_method.appPaymentMethod.app.aclRole.deletedAt`, `payment_method.appPaymentMethod.app.aclRole`.`created_at` as `payment_method.appPaymentMethod.app.aclRole.createdAt`, `payment_method.appPaymentMethod.app.aclRole`.`updated_at` as `payment_method.appPaymentMethod.app.aclRole.updatedAt`, `payment_method.appPaymentMethod.app`.`created_at` as `payment_method.appPaymentMethod.app.createdAt`, `payment_method.appPaymentMethod.app`.`updated_at` as `payment_method.appPaymentMethod.app.updatedAt`, `payment_method.appPaymentMethod.app.translation.label`, `payment_method.appPaymentMethod.app.translation.label` as `payment_method.appPaymentMethod.app.label`, `payment_method.appPaymentMethod.app.translation.description`, `payment_method.appPaymentMethod.app.translation.description` as `payment_method.appPaymentMethod.app.description`, `payment_method.appPaymentMethod.app.translation.privacyPolicyExtensions`, `payment_method.appPaymentMethod.app.translation.privacyPolicyExtensions` as `payment_method.appPaymentMethod.app.privacyPolicyExtensions`, `payment_method.appPaymentMethod.app.translation.customFields`, `payment_method.appPaymentMethod.app.translation.customFields` as `payment_method.appPaymentMethod.app.customFields`, `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`.`file_hash` as `payment_method.media.fileHash`, `payment_method.media`.`created_at` as `payment_method.media.createdAt`, `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`, `payment_method.media.translation.title`, `payment_method.media.translation.title` as `payment_method.media.title`, `payment_method.media.translation.alt`, `payment_method.media.translation.alt` as `payment_method.media.alt`, `payment_method.media.translation.customFields`, `payment_method.media.translation.customFields` as `payment_method.media.customFields`, `payment_method.translation.name`, `payment_method.translation.name` as `payment_method.name`, `payment_method.translation.distinguishableName`, `payment_method.translation.distinguishableName` as `payment_method.distinguishableName`, `payment_method.translation.description`, `payment_method.translation.description` as `payment_method.description`, `payment_method.translation.customFields`, `payment_method.translation.customFields` as `payment_method.customFields` FROM `payment_method` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.translation`.`payment_method_id`, `payment_method.translation`.`name` as `payment_method.translation.name`, `payment_method.translation`.`distinguishable_name` as `payment_method.translation.distinguishableName`, `payment_method.translation`.`description` as `payment_method.translation.description`, `payment_method.translation`.`custom_fields` as `payment_method.translation.customFields` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.`language_id` = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN `app` `payment_method.appPaymentMethod.app` ON `payment_method.appPaymentMethod`.`app_id` = `payment_method.appPaymentMethod.app`.`id` LEFT JOIN `integration` `payment_method.appPaymentMethod.app.integration` ON `payment_method.appPaymentMethod.app`.`integration_id` = `payment_method.appPaymentMethod.app.integration`.`id` LEFT JOIN `acl_role` `payment_method.appPaymentMethod.app.aclRole` ON `payment_method.appPaymentMethod.app`.`acl_role_id` = `payment_method.appPaymentMethod.app.aclRole`.`id` LEFT JOIN (SELECT `payment_method.appPaymentMethod.app.translation`.`app_id`, `payment_method.appPaymentMethod.app.translation`.`label` as `payment_method.appPaymentMethod.app.translation.label`, `payment_method.appPaymentMethod.app.translation`.`description` as `payment_method.appPaymentMethod.app.translation.description`, `payment_method.appPaymentMethod.app.translation`.`privacy_policy_extensions` as `payment_method.appPaymentMethod.app.translation.privacyPolicyExtensions`, `payment_method.appPaymentMethod.app.translation`.`custom_fields` as `payment_method.appPaymentMethod.app.translation.customFields` FROM `app_translation` `payment_method.appPaymentMethod.app.translation` WHERE `payment_method.appPaymentMethod.app.translation`.`language_id` = ?) `payment_method.appPaymentMethod.app.app_translation` ON `payment_method.appPaymentMethod.app.app_translation`.`app_id` = `payment_method.appPaymentMethod.app`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.`media_id`, `payment_method.media.translation`.`alt` as `payment_method.media.translation.alt`, `payment_method.media.translation`.`title` as `payment_method.media.translation.title`, `payment_method.media.translation`.`custom_fields` as `payment_method.media.translation.customFields` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation`.`language_id` = ?) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ų{i¼'IZ‹¡”V&\x08é"
  b"1Å&÷ý=Dĵ´HV|7;)"
]
View formatted query    View runnable query    Explain query    View query backtrace
10.41 ms
(8.16%) 		1 
SELECT LOWER(HEX(`category`.`parent_id`)) as `category-ids.key`, COUNT(`category`.`id`) as `category-ids.count`, COUNT(DISTINCT `category`.`id`) as `visible-children-count` FROM `category` WHERE (`category`.`version_id` = ?) AND ((`category`.`path` LIKE ? AND `category`.`level` = ? AND `category`.`active` = ? AND `category`.`visible` = ?)) GROUP BY `category`.`parent_id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  "%|06dd89c0e0964699bb1ec20b4748bb7e|%"
  4
  true
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
9.91 ms
(7.77%) 		1 
# header::navigation::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category`.`cms_navigation_page_id` as `category.cmsNavigationPageId`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`file_hash` as `category.media.fileHash`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, `category.media.translation.title` as `category.media.title`, `category.media.translation.alt`, `category.media.translation.alt` as `category.media.alt`, `category.media.translation.customFields`, `category.media.translation.customFields` as `category.media.customFields`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.`language_id` = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (((`category`.`id` = ? OR (`category`.`path` LIKE ? AND (`category`.`level` > ? AND `category`.`level` <= ?)))))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x06݉Àà–F™»\x1EÂ\vGH»~"
  "%|06dd89c0e0964699bb1ec20b4748bb7e|%"
  1
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
9.67 ms
(7.58%) 		4 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"*\Ù\x12V,Jë»Òî,Ÿ=\x14»"
  "ul1nZJTgG32EhMlGaOHa5iDWwLguf4hh"
]
View formatted query    View runnable query    Explain query    View query backtrace
9.14 ms
(7.16%) 		1 
SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`technical_name` as `shipping_method.technicalName`, `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`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `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.appShippingMethod.app`.`id` as `shipping_method.appShippingMethod.app.id`, `shipping_method.appShippingMethod.app`.`name` as `shipping_method.appShippingMethod.app.name`, `shipping_method.appShippingMethod.app`.`path` as `shipping_method.appShippingMethod.app.path`, `shipping_method.appShippingMethod.app`.`author` as `shipping_method.appShippingMethod.app.author`, `shipping_method.appShippingMethod.app`.`copyright` as `shipping_method.appShippingMethod.app.copyright`, `shipping_method.appShippingMethod.app`.`license` as `shipping_method.appShippingMethod.app.license`, `shipping_method.appShippingMethod.app`.`active` as `shipping_method.appShippingMethod.app.active`, `shipping_method.appShippingMethod.app`.`configurable` as `shipping_method.appShippingMethod.app.configurable`, `shipping_method.appShippingMethod.app`.`privacy` as `shipping_method.appShippingMethod.app.privacy`, `shipping_method.appShippingMethod.app`.`version` as `shipping_method.appShippingMethod.app.version`, `shipping_method.appShippingMethod.app`.`icon` as `shipping_method.appShippingMethod.app.iconRaw`, `shipping_method.appShippingMethod.app`.`app_secret` as `shipping_method.appShippingMethod.app.appSecret`, `shipping_method.appShippingMethod.app`.`modules` as `shipping_method.appShippingMethod.app.modules`, `shipping_method.appShippingMethod.app`.`main_module` as `shipping_method.appShippingMethod.app.mainModule`, `shipping_method.appShippingMethod.app`.`cookies` as `shipping_method.appShippingMethod.app.cookies`, `shipping_method.appShippingMethod.app`.`allow_disable` as `shipping_method.appShippingMethod.app.allowDisable`, `shipping_method.appShippingMethod.app`.`base_app_url` as `shipping_method.appShippingMethod.app.baseAppUrl`, `shipping_method.appShippingMethod.app`.`allowed_hosts` as `shipping_method.appShippingMethod.app.allowedHosts`, `shipping_method.appShippingMethod.app`.`template_load_priority` as `shipping_method.appShippingMethod.app.templateLoadPriority`, `shipping_method.appShippingMethod.app`.`checkout_gateway_url` as `shipping_method.appShippingMethod.app.checkoutGatewayUrl`, `shipping_method.appShippingMethod.app`.`context_gateway_url` as `shipping_method.appShippingMethod.app.contextGatewayUrl`, `shipping_method.appShippingMethod.app`.`in_app_purchases_gateway_url` as `shipping_method.appShippingMethod.app.inAppPurchasesGatewayUrl`, `shipping_method.appShippingMethod.app`.`source_type` as `shipping_method.appShippingMethod.app.sourceType`, `shipping_method.appShippingMethod.app`.`source_config` as `shipping_method.appShippingMethod.app.sourceConfig`, `shipping_method.appShippingMethod.app`.`self_managed` as `shipping_method.appShippingMethod.app.selfManaged`, `shipping_method.appShippingMethod.app`.`requested_privileges` as `shipping_method.appShippingMethod.app.requestedPrivileges`, `shipping_method.appShippingMethod.app`.`integration_id` as `shipping_method.appShippingMethod.app.integrationId`, `shipping_method.appShippingMethod.app.integration`.`id` as `shipping_method.appShippingMethod.app.integration.id`, `shipping_method.appShippingMethod.app.integration`.`label` as `shipping_method.appShippingMethod.app.integration.label`, `shipping_method.appShippingMethod.app.integration`.`access_key` as `shipping_method.appShippingMethod.app.integration.accessKey`, `shipping_method.appShippingMethod.app.integration`.`secret_access_key` as `shipping_method.appShippingMethod.app.integration.secretAccessKey`, `shipping_method.appShippingMethod.app.integration`.`last_usage_at` as `shipping_method.appShippingMethod.app.integration.lastUsageAt`, `shipping_method.appShippingMethod.app.integration`.`admin` as `shipping_method.appShippingMethod.app.integration.admin`, `shipping_method.appShippingMethod.app.integration`.`custom_fields` as `shipping_method.appShippingMethod.app.integration.customFields`, `shipping_method.appShippingMethod.app.integration`.`deleted_at` as `shipping_method.appShippingMethod.app.integration.deletedAt`, `shipping_method.appShippingMethod.app.integration`.`created_at` as `shipping_method.appShippingMethod.app.integration.createdAt`, `shipping_method.appShippingMethod.app.integration`.`updated_at` as `shipping_method.appShippingMethod.app.integration.updatedAt`, `shipping_method.appShippingMethod.app`.`acl_role_id` as `shipping_method.appShippingMethod.app.aclRoleId`, `shipping_method.appShippingMethod.app.aclRole`.`id` as `shipping_method.appShippingMethod.app.aclRole.id`, `shipping_method.appShippingMethod.app.aclRole`.`name` as `shipping_method.appShippingMethod.app.aclRole.name`, `shipping_method.appShippingMethod.app.aclRole`.`description` as `shipping_method.appShippingMethod.app.aclRole.description`, `shipping_method.appShippingMethod.app.aclRole`.`privileges` as `shipping_method.appShippingMethod.app.aclRole.privileges`, `shipping_method.appShippingMethod.app.aclRole`.`deleted_at` as `shipping_method.appShippingMethod.app.aclRole.deletedAt`, `shipping_method.appShippingMethod.app.aclRole`.`created_at` as `shipping_method.appShippingMethod.app.aclRole.createdAt`, `shipping_method.appShippingMethod.app.aclRole`.`updated_at` as `shipping_method.appShippingMethod.app.aclRole.updatedAt`, `shipping_method.appShippingMethod.app`.`created_at` as `shipping_method.appShippingMethod.app.createdAt`, `shipping_method.appShippingMethod.app`.`updated_at` as `shipping_method.appShippingMethod.app.updatedAt`, `shipping_method.appShippingMethod.app.translation.label`, `shipping_method.appShippingMethod.app.translation.label` as `shipping_method.appShippingMethod.app.label`, `shipping_method.appShippingMethod.app.translation.description`, `shipping_method.appShippingMethod.app.translation.description` as `shipping_method.appShippingMethod.app.description`, `shipping_method.appShippingMethod.app.translation.privacyPolicyExtensions`, `shipping_method.appShippingMethod.app.translation.privacyPolicyExtensions` as `shipping_method.appShippingMethod.app.privacyPolicyExtensions`, `shipping_method.appShippingMethod.app.translation.customFields`, `shipping_method.appShippingMethod.app.translation.customFields` as `shipping_method.appShippingMethod.app.customFields`, `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`.`file_hash` as `shipping_method.media.fileHash`, `shipping_method.media`.`created_at` as `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`, `shipping_method.media.translation.title`, `shipping_method.media.translation.title` as `shipping_method.media.title`, `shipping_method.media.translation.alt`, `shipping_method.media.translation.alt` as `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, `shipping_method.media.translation.customFields` as `shipping_method.media.customFields`, `shipping_method.translation.name`, `shipping_method.translation.name` as `shipping_method.name`, `shipping_method.translation.description`, `shipping_method.translation.description` as `shipping_method.description`, `shipping_method.translation.trackingUrl`, `shipping_method.translation.trackingUrl` as `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, `shipping_method.translation.customFields` as `shipping_method.customFields` FROM `shipping_method` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method`.`id` = `shipping_method.appShippingMethod`.`shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name`, `shipping_method.translation`.`custom_fields` as `shipping_method.translation.customFields`, `shipping_method.translation`.`description` as `shipping_method.translation.description`, `shipping_method.translation`.`tracking_url` as `shipping_method.translation.trackingUrl` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `app` `shipping_method.appShippingMethod.app` ON `shipping_method.appShippingMethod`.`app_id` = `shipping_method.appShippingMethod.app`.`id` LEFT JOIN `integration` `shipping_method.appShippingMethod.app.integration` ON `shipping_method.appShippingMethod.app`.`integration_id` = `shipping_method.appShippingMethod.app.integration`.`id` LEFT JOIN `acl_role` `shipping_method.appShippingMethod.app.aclRole` ON `shipping_method.appShippingMethod.app`.`acl_role_id` = `shipping_method.appShippingMethod.app.aclRole`.`id` LEFT JOIN (SELECT `shipping_method.appShippingMethod.app.translation`.`app_id`, `shipping_method.appShippingMethod.app.translation`.`label` as `shipping_method.appShippingMethod.app.translation.label`, `shipping_method.appShippingMethod.app.translation`.`description` as `shipping_method.appShippingMethod.app.translation.description`, `shipping_method.appShippingMethod.app.translation`.`privacy_policy_extensions` as `shipping_method.appShippingMethod.app.translation.privacyPolicyExtensions`, `shipping_method.appShippingMethod.app.translation`.`custom_fields` as `shipping_method.appShippingMethod.app.translation.customFields` FROM `app_translation` `shipping_method.appShippingMethod.app.translation` WHERE `shipping_method.appShippingMethod.app.translation`.`language_id` = ?) `shipping_method.appShippingMethod.app.app_translation` ON `shipping_method.appShippingMethod.app.app_translation`.`app_id` = `shipping_method.appShippingMethod.app`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.`media_id`, `shipping_method.media.translation`.`alt` as `shipping_method.media.translation.alt`, `shipping_method.media.translation`.`title` as `shipping_method.media.translation.title`, `shipping_method.media.translation`.`custom_fields` as `shipping_method.media.translation.customFields` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation`.`language_id` = ?) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"""
    ÿ%ù™XËI\n
    Ž+L(‹§Ö8
    """
  b"]×1%,ÇN¬¥+/Jç¹>÷"
]
View formatted query    View runnable query    Explain query    View query backtrace
8.41 ms
(6.59%) 		3 
# 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"*\Ù\x12V,Jë»Òî,Ÿ=\x14»"
  "/checkout/cart"
]
View formatted query    View runnable query    Explain query    View query backtrace
8.39 ms
(6.58%) 		1 
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`checkout_gateway_url` as `app.checkoutGatewayUrl`, `app`.`context_gateway_url` as `app.contextGatewayUrl`, `app`.`in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl`, `app`.`source_type` as `app.sourceType`, `app`.`source_config` as `app.sourceConfig`, `app`.`self_managed` as `app.selfManaged`, `app`.`requested_privileges` as `app.requestedPrivileges`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, `app.translation.label` as `app.label`, `app.translation.description`, `app.translation.description` as `app.description`, `app.translation.privacyPolicyExtensions`, `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`, `app.translation.customFields`, `app.translation.customFields` as `app.customFields` FROM `app` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` LEFT JOIN (SELECT `app.translation`.`app_id`, `app.translation`.`label` as `app.translation.label`, `app.translation`.`description` as `app.translation.description`, `app.translation`.`privacy_policy_extensions` as `app.translation.privacyPolicyExtensions`, `app.translation`.`custom_fields` as `app.translation.customFields` FROM `app_translation` `app.translation` WHERE `app.translation`.`language_id` = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` WHERE (`app`.`active` = ? AND NOT (`app`.`checkout_gateway_url` <=> ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
8.16 ms
(6.40%) 		1 
# country-route::read
SELECT `country`.`id` as `country.id`, `country`.`iso` as `country.iso`, `country`.`position` as `country.position`, `country`.`active` as `country.active`, `country`.`shipping_available` as `country.shippingAvailable`, `country`.`iso3` as `country.iso3`, `country`.`display_state_in_registration` as `country.displayStateInRegistration`, `country`.`force_state_in_registration` as `country.forceStateInRegistration`, `country`.`check_vat_id_pattern` as `country.checkVatIdPattern`, `country`.`vat_id_required` as `country.vatIdRequired`, `country`.`vat_id_pattern` as `country.vatIdPattern`, `country`.`customer_tax` as `country.customerTax`, `country`.`company_tax` as `country.companyTax`, `country`.`postal_code_required` as `country.postalCodeRequired`, `country`.`check_postal_code_pattern` as `country.checkPostalCodePattern`, `country`.`check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern`, `country`.`advanced_postal_code_pattern` as `country.advancedPostalCodePattern`, `country`.`default_postal_code_pattern` as `country.defaultPostalCodePattern`, `country`.`is_eu` as `country.isEu`, `country`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, `country.translation.name`, `country.translation.name` as `country.name`, `country.translation.addressFormat`, `country.translation.addressFormat` as `country.addressFormat`, `country.translation.customFields`, `country.translation.customFields` as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation`.`country_id`, `country.translation`.`name` as `country.translation.name`, `country.translation`.`custom_fields` as `country.translation.customFields`, `country.translation`.`address_format` as `country.translation.addressFormat` FROM `country_translation` `country.translation` WHERE `country.translation`.`language_id` = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/NñAš(Bû©tûÓëE:{"
  b"• dS¡€N÷°ŽÂ|\x1A\x04À´"
]
View formatted query    View runnable query    Explain query    View query backtrace
8.02 ms
(6.29%) 		1 
SELECT `shipping_method`.`id` FROM `shipping_method` LEFT JOIN `sales_channel_shipping_method` `shipping_method.salesChannels.mapping` ON `shipping_method`.`id` = `shipping_method.salesChannels.mapping`.`shipping_method_id`  LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name` 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 `sales_channel` `shipping_method.salesChannels` ON `shipping_method.salesChannels.mapping`.`sales_channel_id` = `shipping_method.salesChannels`.`id`  WHERE (`shipping_method`.`active` = ? AND `shipping_method.salesChannels`.`id` = ?) GROUP BY `shipping_method`.`id` ORDER BY MIN(`shipping_method`.`position`) ASC, MIN(COALESCE(`shipping_method.translation.name`)) ASC
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  b"*\Ù\x12V,Jë»Òî,Ÿ=\x14»"
]
View formatted query    View runnable query    Explain query    View query backtrace
7.69 ms
(6.03%) 		1 
SELECT `handler_identifier`, LOWER(HEX(`id`)) FROM `payment_method`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
7.69 ms
(6.03%) 		1 
SELECT `language`.`id` FROM `language` WHERE `language`.`id` IN (?) LIMIT 1
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
7.54 ms
(5.91%) 		1 
SELECT url FROM sales_channel_domain
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.87 ms
(1.47%) 		3 
# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND ((seo_path_info = ? OR seo_path_info = ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"*\Ù\x12V,Jë»Òî,Ÿ=\x14»"
  "checkout/cart"
  "checkout/cart/"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.71 ms
(1.34%) 		3 
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"\t,¿}{¸Eχ\x1F‹ÃXG\x02\x1A"
  b",õ˜–¯fGX–슽\x03¬&¶"
  b"8X•p\x16dMä®HÀP\vóÌÈ"
  b"""
    <}’kjGþŽJâ\r\n
    ™4$
    """
  b"iàé\vÔMFY‰ˆyvu.ýü"
  b"á7Ž·€ŠG‘ž\rt\r]l\x1A"
  b"é+6oàÎI{›^+L*,°ö"
  b"úŸë8R\eLPŠù\x1Aúüøžª"
  b"&×\x15wãeIÈ‹pK¹ç÷9\x18"
  b"(Ê®u¥bO\r˜Z½\x0E³*¡`"
  b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-"
  b"q\x01,<[öA=ƒ¹bAä{ÙÝ"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.63 ms
(1.28%) 		1 
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category`.`cms_navigation_page_id` as `category.cmsNavigationPageId`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"ë ×ã‡-@\x12€öˆj“¢\x1D"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.37 ms
(1.07%) 		1 
# seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (seo_url.language_id = ?) AND (seo_url.sales_channel_id = ? OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0)
Parameters: 
[
  "/navigation/948ecdef9a2543569901be3b4dd32540"
  "/navigation/29e706676f4b48c1a15287358a8d4a97"
  "/navigation/2ba56e5e6d5940e685f663e687f477de"
  "/navigation/9e34369cb1284171a730027eb4b9a457"
  "/navigation/ab1008b4e49d43908e52745f206c8547"
  "/navigation/b153243b95f04a94a2e7ec1d6feb893b"
  "/navigation/26648727b593450d8b4da854fb029695"
  "/navigation/c861ae346d4c4ef895e703b56eb2d4d0"
  "/navigation/1ecce1ea3b374659a0b7398908fc1127"
  "/navigation/549d10c58e3a48a1b3160d928f9fe35e"
  "/navigation/2fc2d97827de4a3585270a04440bbc3a"
  "/navigation/4fbba004b3764bc89bc0254a258c5741"
  "/navigation/c6d175c1c4e1431abb0b9ec4ca79a75d"
  "/navigation/d3f6bcfaf4344f699f5bfb5badba6651"
  "/navigation/78d5822449bb4bc5bb0b1e39853fc8cf"
  "/navigation/c39e18a2b870414fb1b59746d7bd2fcd"
  "/navigation/7a4cf9a4f2ca43999a1b01551b988a6f"
  "/navigation/9d7eaa344a584cfaa41c0ef1e49279eb"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"*\Ù\x12V,Jë»Òî,Ÿ=\x14»"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.00 ms
(0.78%) 		1 
# theme-service::resolve-media::read
SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`file_hash` as `media.fileHash`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, `media.translation.title` as `media.title`, `media.translation.alt`, `media.translation.alt` as `media.alt`, `media.translation.customFields`, `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.`media_id`, `media.translation`.`alt` as `media.translation.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation`.`custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation`.`language_id` = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  false
  true
  "product_download"
  b"\x01š\x07GgÔq\e–\r\x13évùcE"
  b"\x01š\x07GinrZƒk¸ãžÞD"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.94 ms
(0.74%) 		1 
# footer-pagelet::shipping-methods::read
SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`technical_name` as `shipping_method.technicalName`, `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`.`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`.`file_hash` as `shipping_method.media.fileHash`, `shipping_method.media`.`created_at` as `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`, `shipping_method.media.translation.title`, `shipping_method.media.translation.title` as `shipping_method.media.title`, `shipping_method.media.translation.alt`, `shipping_method.media.translation.alt` as `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, `shipping_method.media.translation.customFields` as `shipping_method.media.customFields`, `shipping_method.translation.name`, `shipping_method.translation.name` as `shipping_method.name`, `shipping_method.translation.description`, `shipping_method.translation.description` as `shipping_method.description`, `shipping_method.translation.trackingUrl`, `shipping_method.translation.trackingUrl` as `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, `shipping_method.translation.customFields` as `shipping_method.customFields` FROM `shipping_method` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name`, `shipping_method.translation`.`custom_fields` as `shipping_method.translation.customFields`, `shipping_method.translation`.`description` as `shipping_method.translation.description`, `shipping_method.translation`.`tracking_url` as `shipping_method.translation.trackingUrl` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.`media_id`, `shipping_method.media.translation`.`alt` as `shipping_method.media.translation.alt`, `shipping_method.media.translation`.`title` as `shipping_method.media.translation.title`, `shipping_method.media.translation`.`custom_fields` as `shipping_method.media.translation.customFields` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation`.`language_id` = ?) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"""
    ÿ%ù™XËI\n
    Ž+L(‹§Ö8
    """
  b"]×1%,ÇN¬¥+/Jç¹>÷"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.87 ms
(0.68%) 		1 
# seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN (?, ?, ?, ?, ?)) AND (seo_url.language_id = ?) AND (seo_url.sales_channel_id = ? OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0)
Parameters: 
[
  "/navigation/6aa79dbff2c244a2820eb998e8fb9578"
  "/navigation/2eef757856864365b2687b489612cee7"
  "/navigation/044fd197dc434f1aa12d6e5de2bda014"
  "/navigation/e8fa3f28c4604fbd854bebb97be01b9b"
  "/navigation/fe84235e874241f487e0e95865e07ee7"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"*\Ù\x12V,Jë»Òî,Ÿ=\x14»"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.87 ms
(0.68%) 		1 
# country-route::search-ids
SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id`  LEFT JOIN (SELECT `country.translation`.`country_id`, `country.translation`.`name` as `country.translation.name` FROM `country_translation` `country.translation` WHERE `country.translation`.`language_id` = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id`  WHERE (`country`.`active` = ? AND `country.salesChannels`.`id` = ?) GROUP BY `country`.`id` ORDER BY MIN(`country`.`position`) ASC, MIN(COALESCE(`country.translation.name`)) ASC
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  b"*\Ù\x12V,Jë»Òî,Ÿ=\x14»"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.84 ms
(0.66%) 		1 
# header::languages::search-ids
SELECT `language`.`id` FROM `language` LEFT JOIN `sales_channel_domain` `language.salesChannelDomains` ON `language`.`id` = `language.salesChannelDomains`.`language_id` LEFT JOIN `sales_channel_language` `language.salesChannels.mapping` ON `language`.`id` = `language.salesChannels.mapping`.`language_id`  LEFT JOIN `sales_channel` `language.salesChannels` ON `language.salesChannels.mapping`.`sales_channel_id` = `language.salesChannels`.`id`  WHERE (`language.salesChannelDomains`.`sales_channel_id` = ? AND `language.salesChannels`.`id` = ?) GROUP BY `language`.`id` ORDER BY MIN(`language`.`name`) ASC
Parameters: 
[
  b"*\Ù\x12V,Jë»Òî,Ÿ=\x14»"
  b"*\Ù\x12V,Jë»Òî,Ÿ=\x14»"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.82 ms
(0.64%) 		2 
# navigation-route::meta-information
            SELECT LOWER(HEX(`id`)), `path`, `level`
            FROM `category`
            WHERE `id` = ? OR `id` = ?
Parameters: 
[
  b"ë ×ã‡-@\x12€öˆj“¢\x1D"
  b"ë ×ã‡-@\x12€öˆj“¢\x1D"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.74 ms
(0.58%) 		1 
# footer-pagelet::payment-methods::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`.`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`.`file_hash` as `payment_method.media.fileHash`, `payment_method.media`.`created_at` as `payment_method.media.createdAt`, `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`, `payment_method.media.translation.title`, `payment_method.media.translation.title` as `payment_method.media.title`, `payment_method.media.translation.alt`, `payment_method.media.translation.alt` as `payment_method.media.alt`, `payment_method.media.translation.customFields`, `payment_method.media.translation.customFields` as `payment_method.media.customFields`, `payment_method.translation.name`, `payment_method.translation.name` as `payment_method.name`, `payment_method.translation.distinguishableName`, `payment_method.translation.distinguishableName` as `payment_method.distinguishableName`, `payment_method.translation.description`, `payment_method.translation.description` as `payment_method.description`, `payment_method.translation.customFields`, `payment_method.translation.customFields` as `payment_method.customFields` FROM `payment_method` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.translation`.`payment_method_id`, `payment_method.translation`.`name` as `payment_method.translation.name`, `payment_method.translation`.`distinguishable_name` as `payment_method.translation.distinguishableName`, `payment_method.translation`.`description` as `payment_method.translation.description`, `payment_method.translation`.`custom_fields` as `payment_method.translation.customFields` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.`language_id` = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.`media_id`, `payment_method.media.translation`.`alt` as `payment_method.media.translation.alt`, `payment_method.media.translation`.`title` as `payment_method.media.translation.title`, `payment_method.media.translation`.`custom_fields` as `payment_method.media.translation.customFields` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation`.`language_id` = ?) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ų{i¼'IZ‹¡”V&\x08é"
  b"1Å&÷ý=Dĵ´HV|7;)"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.62 ms
(0.49%) 		1 
# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.58 ms
(0.46%) 		1 
SELECT path FROM category WHERE id = ?
Parameters: 
[
  b"ë ×ã‡-@\x12€öˆj“¢\x1D"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(0.45%) 		1 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.53 ms
(0.41%) 		1 
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `swag_dynamic_access_category_rule` `category.swagDynamicAccessRules.mapping` ON `category`.`id` = `category.swagDynamicAccessRules.mapping`.`category_id`  AND `category`.`version_id` = `category.swagDynamicAccessRules.mapping`.`category_version_id` LEFT JOIN `rule` `category.swagDynamicAccessRules` ON `category.swagDynamicAccessRules.mapping`.`rule_id` = `category.swagDynamicAccessRules`.`id`  WHERE (`category`.`version_id` = ?) AND ((((`category.swagDynamicAccessRules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) OR `category.swagDynamicAccessRules`.`id` <=> ?))) AND (`category`.`id` IN (?)) GROUP BY `category`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\t,¿}{¸Eχ\x1F‹ÃXG\x02\x1A"
  b",õ˜–¯fGX–슽\x03¬&¶"
  b"8X•p\x16dMä®HÀP\vóÌÈ"
  b"""
    <}’kjGþŽJâ\r\n
    ™4$
    """
  b"iàé\vÔMFY‰ˆyvu.ýü"
  b"á7Ž·€ŠG‘ž\rt\r]l\x1A"
  b"é+6oàÎI{›^+L*,°ö"
  b"úŸë8R\eLPŠù\x1Aúüøžª"
  b"&×\x15wãeIÈ‹pK¹ç÷9\x18"
  b"(Ê®u¥bO\r˜Z½\x0E³*¡`"
  b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-"
  b"q\x01,<[öA=ƒ¹bAä{ÙÝ"
  null
  b"ë ×ã‡-@\x12€öˆj“¢\x1D"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.51 ms
(0.40%) 		1 
SELECT `payment_method`.`id` FROM `payment_method` LEFT JOIN `sales_channel_payment_method` `payment_method.salesChannels.mapping` ON `payment_method`.`id` = `payment_method.salesChannels.mapping`.`payment_method_id`  LEFT JOIN `sales_channel` `payment_method.salesChannels` ON `payment_method.salesChannels.mapping`.`sales_channel_id` = `payment_method.salesChannels`.`id`  WHERE (`payment_method`.`active` = ? AND `payment_method.salesChannels`.`id` = ?) GROUP BY `payment_method`.`id` ORDER BY MIN(`payment_method`.`position`) ASC
Parameters: 
[
  true
  b"*\Ù\x12V,Jë»Òî,Ÿ=\x14»"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.51 ms
(0.40%) 		1 
SELECT `app`.`name`, `app`.`version`, `app`.`template_load_priority`
             FROM `app`
             INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id`
             WHERE `app`.`active` = 1 AND `app_template`.`active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.49 ms
(0.39%) 		1 
# footer-pagelet::shipping-methods::search-ids
SELECT `shipping_method`.`id` FROM `shipping_method` LEFT JOIN `sales_channel_shipping_method` `shipping_method.salesChannels.mapping` ON `shipping_method`.`id` = `shipping_method.salesChannels.mapping`.`shipping_method_id`  LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name` 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 `sales_channel` `shipping_method.salesChannels` ON `shipping_method.salesChannels.mapping`.`sales_channel_id` = `shipping_method.salesChannels`.`id`  WHERE (`shipping_method`.`active` = ? AND `shipping_method.salesChannels`.`id` = ?) GROUP BY `shipping_method`.`id` ORDER BY MIN(`shipping_method`.`position`) ASC, MIN(COALESCE(`shipping_method.translation.name`)) ASC
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  b"*\Ù\x12V,Jë»Òî,Ÿ=\x14»"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.49 ms
(0.38%) 		1 
SELECT `sales_channel_country`.`sales_channel_id`, `sales_channel_country`.`country_id` FROM `sales_channel_country` WHERE (`sales_channel_country`.`sales_channel_id` = ? AND `sales_channel_country`.`country_id` = ?)
Parameters: 
[
  b"*\Ù\x12V,Jë»Òî,Ÿ=\x14»"
  b"/NñAš(Bû©tûÓëE:{"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.47 ms
(0.37%) 		1 
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `swag_dynamic_access_category_rule` `category.swagDynamicAccessRules.mapping` ON `category`.`id` = `category.swagDynamicAccessRules.mapping`.`category_id`  AND `category`.`version_id` = `category.swagDynamicAccessRules.mapping`.`category_version_id` LEFT JOIN `rule` `category.swagDynamicAccessRules` ON `category.swagDynamicAccessRules.mapping`.`rule_id` = `category.swagDynamicAccessRules`.`id`  WHERE (`category`.`version_id` = ?) AND ((((`category.swagDynamicAccessRules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) OR `category.swagDynamicAccessRules`.`id` <=> ?))) AND (`category`.`id` IN (?, ?, ?, ?, ?, ?)) GROUP BY `category`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\t,¿}{¸Eχ\x1F‹ÃXG\x02\x1A"
  b",õ˜–¯fGX–슽\x03¬&¶"
  b"8X•p\x16dMä®HÀP\vóÌÈ"
  b"""
    <}’kjGþŽJâ\r\n
    ™4$
    """
  b"iàé\vÔMFY‰ˆyvu.ýü"
  b"á7Ž·€ŠG‘ž\rt\r]l\x1A"
  b"é+6oàÎI{›^+L*,°ö"
  b"úŸë8R\eLPŠù\x1Aúüøžª"
  b"&×\x15wãeIÈ‹pK¹ç÷9\x18"
  b"(Ê®u¥bO\r˜Z½\x0E³*¡`"
  b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-"
  b"q\x01,<[öA=ƒ¹bAä{ÙÝ"
  null
  b"\x04OÑ—ÜCO\x1A¡-n]â½ \x14"
  b".ïuxV†Ce²h{H–\x12Îç"
  b"j§¿òÂD¢‚\x0E¹˜èû•x"
  b"èú?(Ä`O½…Kë¹{à\e›"
  b"þ„#^‡BAô‡àéXeà~ç"
  b"\x06݉Àà–F™»\x1EÂ\vGH»~"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.45 ms
(0.35%) 		1 
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`active` as `language.active`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.name`, `language.locale.translation.name` as `language.locale.name`, `language.locale.translation.territory`, `language.locale.translation.territory` as `language.locale.territory`, `language.locale.translation.customFields`, `language.locale.translation.customFields` as `language.locale.customFields` FROM `language` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.locale.translation`.`locale_id`, `language.locale.translation`.`name` as `language.locale.translation.name`, `language.locale.translation`.`territory` as `language.locale.translation.territory`, `language.locale.translation`.`custom_fields` as `language.locale.translation.customFields` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation`.`language_id` = ?) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE `language`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.44 ms
(0.35%) 		1 
SELECT `name`, `path`, `author`, `self_managed`
                FROM `app`
                WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.44 ms
(0.34%) 		1 
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters: 
[
  "de-DE"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.42 ms
(0.33%) 		1 
# header::languages::read
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`active` as `language.active`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.translationCode`.`id` as `language.translationCode.id`, `language.translationCode`.`code` as `language.translationCode.code`, `language.translationCode`.`created_at` as `language.translationCode.createdAt`, `language.translationCode`.`updated_at` as `language.translationCode.updatedAt`, `language.translationCode.translation.name`, `language.translationCode.translation.name` as `language.translationCode.name`, `language.translationCode.translation.territory`, `language.translationCode.translation.territory` as `language.translationCode.territory`, `language.translationCode.translation.customFields`, `language.translationCode.translation.customFields` as `language.translationCode.customFields` FROM `language` LEFT JOIN `locale` `language.translationCode` ON `language`.`translation_code_id` = `language.translationCode`.`id` LEFT JOIN (SELECT `language.translationCode.translation`.`locale_id`, `language.translationCode.translation`.`name` as `language.translationCode.translation.name`, `language.translationCode.translation`.`territory` as `language.translationCode.translation.territory`, `language.translationCode.translation`.`custom_fields` as `language.translationCode.translation.customFields` FROM `locale_translation` `language.translationCode.translation` WHERE `language.translationCode.translation`.`language_id` = ?) `language.translationCode.locale_translation` ON `language.translationCode.locale_translation`.`locale_id` = `language.translationCode`.`id` WHERE `language`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.40 ms
(0.32%) 		1 
SELECT LOWER(HEX(assoc.`sales_channel_id`))
                FROM `sales_channel_payment_method` AS assoc
                    LEFT JOIN `payment_method` AS pm
                        ON pm.`id` = assoc.`payment_method_id`
                WHERE
                    assoc.`payment_method_id` = ? AND
                    pm.`active` = 1
Parameters: 
[
  b"ç\x05CL6@J\x11©§*Ù,vÛÔ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.38 ms
(0.30%) 		1 
# header::currencies::read
SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.shortName`, `currency.translation.shortName` as `currency.shortName`, `currency.translation.name`, `currency.translation.name` as `currency.name`, `currency.translation.customFields`, `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation`.`currency_id`, `currency.translation`.`short_name` as `currency.translation.shortName`, `currency.translation`.`name` as `currency.translation.name`, `currency.translation`.`custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.`language_id` = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.38 ms
(0.30%) 		1 
# footer-pagelet::payment-methods::search-ids
SELECT `payment_method`.`id` FROM `payment_method` LEFT JOIN `sales_channel_payment_method` `payment_method.salesChannels.mapping` ON `payment_method`.`id` = `payment_method.salesChannels.mapping`.`payment_method_id`  LEFT JOIN `sales_channel` `payment_method.salesChannels` ON `payment_method.salesChannels.mapping`.`sales_channel_id` = `payment_method.salesChannels`.`id`  WHERE (`payment_method`.`active` = ? AND `payment_method.salesChannels`.`id` = ?) GROUP BY `payment_method`.`id` ORDER BY MIN(`payment_method`.`position`) ASC
Parameters: 
[
  true
  b"*\Ù\x12V,Jë»Òî,Ÿ=\x14»"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.26%) 		1 
SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(0.21%) 		1 
SELECT DISTINCT `technical_name`
    FROM `theme_runtime_config`
    WHERE `technical_name` IS NOT NULL
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(0.21%) 		1 
# header::currencies::search-ids
SELECT `currency`.`id` FROM `currency` LEFT JOIN `sales_channel_currency` `currency.salesChannels.mapping` ON `currency`.`id` = `currency.salesChannels.mapping`.`currency_id`  LEFT JOIN `sales_channel` `currency.salesChannels` ON `currency.salesChannels.mapping`.`sales_channel_id` = `currency.salesChannels`.`id`  WHERE (`currency.salesChannels`.`id` = ?) GROUP BY `currency`.`id`
Parameters: 
[
  b"*\Ù\x12V,Jë»Òî,Ÿ=\x14»"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(0.20%) 		1 
SELECT
    `theme_id`,
    `technical_name`,
    `resolved_config`,
    `view_inheritance`,
    `script_files`,
    `icon_sets`,
    `updated_at`
    FROM `theme_runtime_config`
    WHERE `technical_name` = ?
Parameters: 
[
  "Storefront"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(0.16%) 		1 
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x06݉Àà–F™»\x1EÂ\vGH»~"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.16 ms
(0.13%) 		1 
SELECT `min_search_length` FROM `product_search_config` WHERE `language_id` = ?
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.