GET https://live.shopware-demo.amicaldo.dev/checkout/cart

Response
200 OK
IP
216.73.216.21
Profiled on
Token
51f7e3

Query Metrics

21 Database Queries
20 Different statements
97.42 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
30.48 ms
(31.28%) 		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.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`.`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`.`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`.`technical_name` as `payment_method.technicalName`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `payment_method.media`.`id` as `payment_method.media.id`, `payment_method.media`.`user_id` as `payment_method.media.userId`, `payment_method.media`.`media_folder_id` as `payment_method.media.mediaFolderId`, `payment_method.media`.`mime_type` as `payment_method.media.mimeType`, `payment_method.media`.`file_extension` as `payment_method.media.fileExtension`, `payment_method.media`.`uploaded_at` as `payment_method.media.uploadedAt`, `payment_method.media`.`file_name` as `payment_method.media.fileName`, `payment_method.media`.`file_size` as `payment_method.media.fileSize`, `payment_method.media`.`media_type` as `payment_method.media.mediaTypeRaw`, `payment_method.media`.`meta_data` as `payment_method.media.metaData`, `payment_method.media`.`config` as `payment_method.media.config`, `payment_method.media`.`path` as `payment_method.media.path`, `payment_method.media`.`private` as `payment_method.media.private`, `payment_method.media`.`thumbnails_ro` as `payment_method.media.thumbnailsRo`, `payment_method.media`.`created_at` as `payment_method.media.createdAt`, `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`, `payment_method.media.translation.title`, `payment_method.media.translation.title` as `payment_method.media.title`, `payment_method.media.translation.alt`, `payment_method.media.translation.alt` as `payment_method.media.alt`, `payment_method.media.translation.customFields`, `payment_method.media.translation.customFields` as `payment_method.media.customFields`, `payment_method.translation.name`, `payment_method.translation.name` as `payment_method.name`, `payment_method.translation.distinguishableName`, `payment_method.translation.distinguishableName` as `payment_method.distinguishableName`, `payment_method.translation.description`, `payment_method.translation.description` as `payment_method.description`, `payment_method.translation.customFields`, `payment_method.translation.customFields` as `payment_method.customFields` FROM `payment_method` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.translation`.`payment_method_id`, `payment_method.translation`.`name` as `payment_method.translation.name`, `payment_method.translation`.`distinguishable_name` as `payment_method.translation.distinguishableName`, `payment_method.translation`.`description` as `payment_method.translation.description`, `payment_method.translation`.`custom_fields` as `payment_method.translation.customFields` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.`language_id` = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN `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"\x01ô░+Ê¥rÅç½´6Æ«¶Ö"
  b"\x01“°+ÒÌrk¯ì¬†œ¤ñ\x10"
  b"\x01“°+Ò¯rŒœb¯Û\x15†ÆK"
]
View formatted query    View runnable query    Explain query    View query backtrace
22.56 ms
(23.16%) 		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"\x01ô░,¼lqhÀ Ø\x14╗\x1DÖ\x11"
]
View formatted query    View runnable query    Explain query    View query backtrace
12.04 ms
(12.36%) 		1 
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"\x01“°+ʃq ™aæ{+\x06mà"
  b"\x01“°+Ë\x01rˆ”'¦Z]7ƒ‚"
  b"\x01ô░+╦\x07r\fº)Z─\x05¿\x07Å"
  b"\x01“°+ÐwqÓ—`ê¥ÔBÝ]"
  b"\x01“°+Ð~qŠ¹\x03B$bKë<"
  b"\x01“°+Іsbž\x1CA¢ƒ\x05\x1D\x04"
  b"\x01ô░+ðîqcü×q¬─\x11÷W"
  b"\x01“°+Дpy«\x1A4¬'–”Š"
  b"\x01“°+Кqf½"ÊÑÔܺ!"
  b"\x01“°+Сq2‰s¶.tƒ¢Å"
  b"\x01“°+Шs±…h8i\x07u$ý"
  b"\x01“°+ЭqÌ‘@ÕÍ\âHz"
  b"\x01ô░+ð│pñ×‗╬ØûÅüÕ"
  b"\x01“°+кs^š¡òñvIÕ‹"
  b"\x01“°+ÐÀr•¶\r\x16ªØÖ§’"
  b"\x01“°+ÐÆr\x7F°'Ìšá)Dâ"
  b"\x01“°+ÐÍqÒ·R\x1CˆúÉ2U"
  b"\x01“°+ÐÔsB—®HáΕ2¤"
  b"\x01“°+Ñ÷q?•\x06\x03z\x02M 9"
  b"\x01ô░+Ê\x00r▄ØDq┐®UZP"
  b"\x01“°+Ò\x06s’¤=ÈË\x1E’¾9"
  b"\x01ô░+Ê\x0EqYüqõ?BhÈ╠"
  b"\x01“°+Ò\x16sÖ¹î`›V¬¦\x10"
  b"\x01“°+Ò\x1Dq\x07ž¯èò›¯É["
  b"\x01“°+Ò%q‹™þÿŸIdñá"
  b"\x01“°+Ò+r…£fç6§ü—§"
  b"""
    \x01“°+Ò3s#½\n
    )yK \x7FH
    """
  b"\x01“°+Ò;pÏ‘¬\tT)±ÕD"
  b"\x01“°+ÒGq¶¼‚—\v`<±N"
  b"\x01“°+ÒOpƯ\x1F \x07WT0Ë"
  b"\x01“°+ÒWpï³j¤„L™‘"
  b"\x01ô░+Ê_q!ØÖ^îݽ─└"
  b"\x01“°+Ògr&™’;\x07ð'E¨"
  b"\x01“°,\x02ÿqF”/Þ\x0FV‹¼["
  b"\x01“°,\x03\vsž—wz9À\x7F[ž"
  b"\x01ô░,\x03\x16s\x01ìHn!╣È}ü"
  b"\x01“°,\x03\x1Dr³ô'\x00yLµ\x0F"
  b"\x01“°,\x03$sÓ•o¸„ÏÓÜW"
  b"""
    \x01“°,\x03+s*²Y\n
    \v3,ÙÃ
    """
  b"\x01“°,\x032qZ¸Ò\x05Dt\x06:ï"
  b"\x01“°,\x039p®ŸÛY9"J¯\t"
  b"\x01“°,\x03AppŠ\x19â¦&µŸ±"
  b"\x01“°,\x03LqѦgcM\x10¦±4"
  b"\x01“°,\x03Up•”[wEG~çÑ"
  b"\x01“°,\x03]s\x13¦°(¸R<Í{"
  b"\x01“°,\x03dqÕ–È\r¨ÝJŒø"
  b"\x01“°,\x03jprœì|0WöÆö"
  b"\x01“°,\x03rr•ˆ¿¯¶„\x17@L"
  b"\x01“°,\x03zp\x02ƒó5\x14•Ü\x11í"
  b"\x01“°,\x03‚pP•æÍ\x0EMw^—"
  b"\x01“°,\x03Œph‡Sp9å"Zº"
  b"\x01“°,\x03•qè¡\x1E`Ë¡uR*"
  b"\x01ô░,\x03ØrèÄJ\x07ùª­SÜ"
  b"\x01“°,\x03¥pö°’®gŸ~¯\t"
  b"\x01“°,\x03®r’¾yi¼eí/\x19"
  b"\x01“°,\x03·r?ˆééõH\x10\`"
  b"\x01ô░,\x03└r0Éı@tı\x0Få¯"
  b"\x01“°,\x03ÈpR’&º\x1Ap·ú\x02"
  b"\x01“°,\x03ÑrǺ²»/dÒ<¾"
  b"\x01ô░,\x03┌sÉå­\x01l 1\x02Ø"
  b"\x01“°,\x03árš„\x1EŒ¶¡AÙ¦"
  b"\x01ô░,\x03þr┼Âı¼TÑÅË\x01"
  b"\x01“°,\x03îs5±œó#cŸÎ;"
  b"\x01“°,\x03÷rb‡êS*Ž Mt"
  b"\x01ô░,\x03 p▄»óoç-¨Éç"
  b"\x01“°,\x04\x06pš¦µA¿kè\x0FÜ"
  b"\x01“°,\x04\fr켉>„°(Þf"
  b"\x01ô░,\x04\x13q\x1CÑËõ\x03ì\x0FcÒ"
  b"\x01“°,\x04\esÞŒ¡\ÒŽ“0Õ"
  b"\x01ô░,\x04"p└ÿü_ƒË▀V1"
  b"\x01“°,\x04*q\x18¢(…—ôÙ\x16Æ"
  b"\x01“°,\x042sß·½üi_\r@t"
  b"\x01“°,\x04;r!ŽÑátêøê…"
  b"\x01ô░,\x04Cpì¥*Ò\t\x1F\x1C\x126"
  b"\x01“°,\x04MsýŠoR\x12UcA¢"
  b"\x01“°,\x04YrC…•\f†é±Ir"
  b"\x01ô░,\x04bq¥ì╦╗ƒ·d\ã"
  b"\x01“°,\x04ksº™Þ܆ýÓ0±"
  b"\x01ô░,\x04qqçüéϤ\x08Tƒ┬"
  b"\x01“°,\x04zqE®Ù¨#ÔËïp"
  b"\x01ô░,\x04üsƒ▓k\x01ÒÙU\x0FÊ"
  b"\x01“°,\x04ˆsŒ’Á*\x1Ax&ñÔ"
  b"\x01“°,\x04’qC„¼/`F·O""
  b"\x01“°,\x04œqv¿®óƒD÷`\x05"
  b"\x01“°,\x04¤s̉ï3ÈçZä'"
  b"\x01ô░,\x04¼q┼ê×É\x0F&Ë█ì"
  b"\x01“°,\x04µqàµ]j¢0V é"
  b"\x01ô░,\x04¥rÎüDiÏmòFu"
  b"\x01“°,\x04Æsî±E:Aç»Ã¦"
  b"\x01ô░,\x04╬r)Á<Ø&\x19³[é"
  b"\x01ô░,\x04ır<Éz¨■£«\x16P"
  b"\x01“°,\x04Ür0µA\r;÷`ì("
  b"\x01“°,\x04äp2†(\x12Ô%3¼×"
  b"\x01ô░,\x04Ùpìª.Ii­LÏ:"
  b"""
    \x01“°,\x04ùpÝ‘-¿\x1C\n
    L1½
    """
  b"\x01“°,\x05\x03pˆ‹vOóuÀiÁ"
  b"\x01“°,\x05\fp´…\x18³‰ß¦’m"
  b"\x01“°,\x05\x14pÓˆ—\x01ê÷Ó¢V"
  b"\x01“°,\x05\es墋GF\x07™7""
  b"\x01“°,\x05#r\t…°ÛƒÃ{Ö¿"
  b"\x01“°,\x05+r¬´ïa˜ï‹9t"
  b"\x01“°,\x055q\x01ª \x17\x18èíáÕ"
  b"""
    \x01“°,\x05?pF¦\n
    Hïrñ.J
    """
  b"\x01“°,\x05Hs7ˆ×"íþ»\x04'"
  b"\x01“°,\x05OrÛš3ÿ!]Ñ"}"
  b"\x01“°,\x05Xsǃ\x1C«Œ´Ù[D"
  b"\x01ô░,\x05bq▓▓┬═\ÿØìÀ"
  b"\x01ô░,\x05is\x18ºxrÑæ2\x02Å"
  b"\x01“°,\x05pq\x0FœkèÞ&(\x12æ"
  b"\x01“°,\x05yq\x14‘fã\x16-f.ä"
  b"\x01“°,\x05€q§…\x0F 6\x12\x0Eå¶"
  b"\x01“°,\x05‰p\tªE+5ŽoC/"
  b"\x01“°,\x05•pĹø\x13•L'wX"
  b"\x01“°,\x05ŸpÄ‘"Î_8Ä\x12ã"
  b"\x01“°,\x05¨pf’+ôÓC-ö…"
  b"\x01ô░,\x05░páû■JsücQæ"
  b"\x01“°,\x05·qÁ°²ÇkÏ|c\x03"
  b"\x01“°,\x05¾p»ŸˆÆnE»›s"
  b"\x01“°,\x05Çpp®\vêÆ0±«ß"
  b"""
    \x01“°,\x05Ðp9’~82À\n
    Ÿ@
    """
  b"\x01“°,\x05Øp,¤\x15ZìÑ.g†"
  b"\x01ô░,\x05▀sÐ▒\fØ\x11┐k┼§"
  b"\x01“°,\x05çsÔ¶ÛË0p\x04\x18H"
  b"\x01“°,\x05îrS„\x1E#@+v‚À"
  b"\x01“°,\x05øs2¨÷¥n\x0E…Ã;"
  b"\x01“°,\x06\x02rY¹ —=&YB3"
  b"\x01“°,\x06\fpù¹÷ÞY‘\x026."
  b"\x01“°,\x06\x16pmµº¹\x1CÌ\x03ru"
  b"\x01“°,\x06\x1Esу}îx\x1E\x04fK"
  b"\x01“°,\x06'rf­\x1E6ÍõœÃD"
  b"\x01“°,\x063r)ƒÏâ{\x13øý\x0E"
  b"\x01“°,\x06@rlˆ÷êä\r¼‚Ë"
  b"\x01“°,\x06IpB¬d†\x00´í™G"
  b"\x01“°,\x06Qr\x05‚»”×.}\x7Fù"
  b"\x01“°,\x06Zqþ’\t¦\x04â—tÚ"
  b"\x01“°,\x06cqi½´E÷éXÕO"
  b"\x01ô░,\x06kr\x10┤^¢É\x0EäG["
  b"\x01“°,\x06tp‡Š*®ÕKÛFJ"
  b"\x01ô░,\x06{q┬ÿsì\x02Ý└xö"
  b"\x01“°,\x06ƒq¥¿·Ú'ãÊôR"
  b"\x01“°,\x06Šr@‹6¡(‘%0“"
  b"\x01ô░,\x06öp\x15åÉ\x03Ô_í¡N"
  b"\x01“°,\x06¡pÛ®ìÁ‰É’ï\x02"
  b"\x01ô░,\x06│p▀ûu\e¢░Cúì"
  b"\x01“°,\x06¿sê‡"Ò¸4‰²á"
  b"\x01“°,\x06Ìsæ™òXÖ®\x0FÈ "
  b"\x01“°,\x06Øsÿ¨¿o:ß(/Ê"
  b"\x01“°,\x06àr\f¨¾ùä½(\x19ù"
  b"\x01“°,\x06ër‘»½c·¿¾£Ø"
  b"\x01“°,\x06õs–œ\x16\x04v(ÅVO"
  b"\x01“°,\x07\x01sW¢©#´ç}§-"
  b"\x01“°,\x07\x08r1Ž\\x12\x0Eæ97°"
  b"\x01“°,\x07\x10p»§{@¾öK\x07\x00"
  b"\x01ô░,\x07\x19r┴┤¿ÎIU\x02\x00Ø"
  b"\x01ô░,\x07 q░üB\x15Æ=Rx)"
  b"\x01ô░,\x07(qëíqçÖ4H¬ü"
  b"\x01ô░,\x070sæïü×ì°■┬a"
  b"\x01ô░,\x078r│ºï8ÉN─ú\x1E"
  b"\x01“°,\x07>r¬¿ÖÂdt\e\x05p"
  b"\x01“°,\x07Ds¥¤yŸ\x0F\x1Eò½T"
  b"\x01“°,\x07Jp\x1E’#Ì})v\x1DZ"
  b"\x01“°,\x07Qs\x10ª?èüŸó\x07D"
  b"\x01“°,\x07Zs\x15«\x011\x7F\x1Aô¸ð"
  b"\x01“°,\x07bqA‚ËÙ\x14Û\x0Ev5"
  b"\x01“°,\x07lpw„7q<l9ú\x7F"
  b"\x01“°,\x07trˆ¯då|TdŸë"
  b"\x01“°,\x07}s☬\x00ðÁñÅV"
  b"\x01“°,\x07‡sü‡¦\x12÷ã–¹ê"
  b"\x01“°,\x07Žpœƒ“­€rW$\x0E"
  b"\x01“°,\x07•pk“éç<x\x0EAG"
  b"\x01“°,\x07Ÿsî¶O7\x19I¾ÝD"
  b"\x01“°,\x07¨s€´`­\x1C¼ \x02¢"
  b"\x01“°,\x07²rƾ«FØÈÝ*ï"
  b"\x01“°,\x07½sa…Š\x03ùÜ‚Aì"
  b"\x01“°,\x07Çs‹–[øR\v)‹Ý"
  b"\x01ô░,\x07ÊräºÙØ\°3ç‗"
  b"\x01“°,\x07Üq5ž\x03d¸c!€ñ"
  b"\x01“°,\x07çr×€uH¾­fí`"
  b"\x01ô░,\x07±r╦ï┼±?w├É\x02"
  b"\x01“°,\x07úsʺÃJÎ<¾çÆ"
  b"\x01“°,\x08\x03r<€¸·r@§­\x15"
  b"""
    \x01“°,\x08\n
    pf¬:\x19O·4Ód
    """
  b"\x01“°,\x08\x10pX‚'Rͦn(&"
  b"\x01“°,\x08\x18p,¶>á?\x1Cð)n"
  b"\x01“°,\x08\x1Fq\v¥9\Ÿ¹K½\x7F"
  b"\x01ô░,\x08&qRù\x07Øä\x03ÔÞj"
  b"\x01ô░,\x08,qkñb%\x01ÉIYô"
  b"\x01ô░,\x083pì┐\x10‗à(\x01\x07\x1C"
  b"\x01“°,\x08<rT· 2y€B“ô"
  b"\x01ô░,\x08DqýØ┴R²!«ÕÙ"
  b"\x01“°,\x08Op<¿¶\x1A\tì\x12àì"
  b"\x01ô░,\x08Yq┌║ êKƒÉ─£"
  b"\x01ô░,\x08bs╠Ñ"jÿ\eì\x0Eü"
  b"\x01“°,\x08kp\x0E‹óEÝ&|\x18Í"
  b"\x01“°,\x08sqL†õ¶÷ô\x1Fí\x16"
  b"\x01ô░,\x08{q+ç\x14¨¼ıØz¸"
  b"\x01“°,\x08ƒp-¢\f…0#£Áv"
  b"\x01“°,\x08Œr\x19 \x0E¡ïÊUCî"
  b"\x01“°,\x08“s~‰V@•j\x1Côê"
  b"\x01“°,\x08œp\x00¼ý øþ\x10\e2"
  b"\x01“°,\x08£r)“ݞЭ2\v‘"
  b"\x01“°,\x08®rN¦ÇÖåêX\x18¯"
  b"""
    \x01“°,\x08¾qWŸ\n
    TèšAÙž
    """
  b"\x01“°,\x08Ïpn«Ù\x02\x02áÌSw"
  b"\x01“°,\x08áq:±\t!n1\x1D¬1"
  b"\x01“°,\x08ìq½±d’Ý>*/¦"
  b"\x01“°,\x08õq\x11¶Kz“4\Ú{"
  b"\x01“°,\x08þp1¿A‰,-ꥉ"
  b"""
    \x01“°,\t\n
    r€•„íZë¡ie
    """
  b"\x01ô░,\t\x17sOë\x16\eÿ4Åñ\x07"
  b"\x01“°,\t'q\x05ˆî¹øDOéå"
  b"\x01“°,\t3p¢¸V¿\x7FŸÏd\x03"
  b"\x01“°,\t?s¶¿œ#ÿ\tc\vÈ"
  b"\x01“°,\tIrl©µ\x16ÊKH0û"
  b"\x01“°,\tRr­´w±Œ››é'"
  b"\x01“°,\t\s+¶\v: c\x18mg"
  b"\x01“°,\thsA‰¿§v}:~\x08"
  b"\x01“°,\t}sÓ­òNZR%åö"
  b"\x01“°,\t‡p>¥£ÌˆX µ³"
  b"\x01ô░,\tÉs<│.;,█Ë.æ"
  b"\x01“°,\t›r²›ÅQ“-!ÝÎ"
  b"\x01“°,\t©r\tˆ\x08c5Áê\x1Dï"
  b"\x01ô░,\tÁs;©ù\x14@ùüà\x05"
  b"\x01“°,\tÃs÷«\x0E1d÷ÞÕ"
  b"\x01“°,\tÐrU¿âK•W\x13H·"
  b"\x01“°,\tÜpQµ\x0F›\x0E&ïwv"
  b"\x01“°,\tés7”\x1E\x01tÄ‚\x05&"
  b"\x01“°,\tôsM¾åå\rJCa€"
  b"\x01“°,\tÿsK†â —HôØ\x17"
  b"""
    \x01“°,\n
    \tpzš„öLÓQ«b
    """
  b"""
    \x01“°,\n
    \x13q€‡\x1FÙ™¯ºXÖ
    """
  b"""
    \x01“°,\n
    !s§™X¬'Üz\x1A4
    """
  b"\x01“°,\n/p¦ª\x00\nu*4+E"
  b"\x01“°,\n:qȧt Ž\x19Q\x00\x0E"
  b"""
    \x01“°,\n
    Erجïû¿â\x16æ*
    """
  b"""
    \x01“°,\n
    Op♣Wê\x10ãÔÈ
    """
  b"""
    \x01“°,\n
    Zs&¤¢ÔY\n
    „ \t
    """
  b"""
    \x01“°,\n
    dr»…\x0Feêï¾=·
    """
  b"""
    \x01ô░,\n
    lqlñ\x18┐ıÉO¤■
    """
  b"""
    \x01“°,\n
    ts9«Õ\x1Ca#\tX\x13
    """
  b"""
    \x01“°,\n
    |pIž\x01ŸÅkbìÌ
    """
  b"""
    \x01“°,\n
    …r‡ƒµ7zV;\x10I
    """
  b"""
    \x01“°,\n
    Žry‚õ)‡\x12e&§
    """
  b"""
    \x01“°,\n
    —q\tˆó¼.íè.”
    """
  b"""
    \x01“°,\n
    Ÿr6¢¸s—FBZ!
    """
  b"""
    \x01“°,\n
    ©p*¸\x7F_áõ\x05\x08\x04
    """
  b"""
    \x01“°,\n
    ·r\x11‚\x1F¶9\x17%RÄ
    """
  b"""
    \x01“°,\n
    ÁsoŒª}$a\x0F†Ã
    """
  b"""
    \x01“°,\n
    Ér\n
    ¾ŠS»Ô«-n
    """
  b"""
    \x01“°,\n
    ÑsﳱȈ’êE»
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
8.33 ms
(8.55%) 		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"\x01ô░,¼lqhÀ Ø\x14╗\x1DÖ\x11"
]
View formatted query    View runnable query    Explain query    View query backtrace
6.72 ms
(6.90%) 		1 
SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`active` as `shipping_method.active`, `shipping_method`.`position` as `shipping_method.position`, `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` as `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` as `shipping_method.taxType`, `shipping_method`.`tax_id` as `shipping_method.taxId`, `shipping_method.deliveryTime`.`id` as `shipping_method.deliveryTime.id`, `shipping_method.deliveryTime`.`min` as `shipping_method.deliveryTime.min`, `shipping_method.deliveryTime`.`max` as `shipping_method.deliveryTime.max`, `shipping_method.deliveryTime`.`unit` as `shipping_method.deliveryTime.unit`, `shipping_method.deliveryTime`.`created_at` as `shipping_method.deliveryTime.createdAt`, `shipping_method.deliveryTime`.`updated_at` as `shipping_method.deliveryTime.updatedAt`, `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation.name` as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation.customFields` as `shipping_method.deliveryTime.customFields`, `shipping_method.appShippingMethod`.`id` as `shipping_method.appShippingMethod.id`, `shipping_method.appShippingMethod`.`app_name` as `shipping_method.appShippingMethod.appName`, `shipping_method.appShippingMethod`.`identifier` as `shipping_method.appShippingMethod.identifier`, `shipping_method.appShippingMethod`.`app_id` as `shipping_method.appShippingMethod.appId`, `shipping_method.appShippingMethod`.`shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId`, `shipping_method.appShippingMethod`.`original_media_id` as `shipping_method.appShippingMethod.originalMediaId`, `shipping_method.appShippingMethod`.`created_at` as `shipping_method.appShippingMethod.createdAt`, `shipping_method.appShippingMethod`.`updated_at` as `shipping_method.appShippingMethod.updatedAt`, `shipping_method.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`.`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`.`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`.`technical_name` as `shipping_method.technicalName`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.media`.`id` as `shipping_method.media.id`, `shipping_method.media`.`user_id` as `shipping_method.media.userId`, `shipping_method.media`.`media_folder_id` as `shipping_method.media.mediaFolderId`, `shipping_method.media`.`mime_type` as `shipping_method.media.mimeType`, `shipping_method.media`.`file_extension` as `shipping_method.media.fileExtension`, `shipping_method.media`.`uploaded_at` as `shipping_method.media.uploadedAt`, `shipping_method.media`.`file_name` as `shipping_method.media.fileName`, `shipping_method.media`.`file_size` as `shipping_method.media.fileSize`, `shipping_method.media`.`media_type` as `shipping_method.media.mediaTypeRaw`, `shipping_method.media`.`meta_data` as `shipping_method.media.metaData`, `shipping_method.media`.`config` as `shipping_method.media.config`, `shipping_method.media`.`path` as `shipping_method.media.path`, `shipping_method.media`.`private` as `shipping_method.media.private`, `shipping_method.media`.`thumbnails_ro` as `shipping_method.media.thumbnailsRo`, `shipping_method.media`.`created_at` as `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`, `shipping_method.media.translation.title`, `shipping_method.media.translation.title` as `shipping_method.media.title`, `shipping_method.media.translation.alt`, `shipping_method.media.translation.alt` as `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, `shipping_method.media.translation.customFields` as `shipping_method.media.customFields`, `shipping_method.translation.name`, `shipping_method.translation.name` as `shipping_method.name`, `shipping_method.translation.description`, `shipping_method.translation.description` as `shipping_method.description`, `shipping_method.translation.trackingUrl`, `shipping_method.translation.trackingUrl` as `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, `shipping_method.translation.customFields` as `shipping_method.customFields` FROM `shipping_method` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method`.`id` = `shipping_method.appShippingMethod`.`shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name`, `shipping_method.translation`.`custom_fields` as `shipping_method.translation.customFields`, `shipping_method.translation`.`description` as `shipping_method.translation.description`, `shipping_method.translation`.`tracking_url` as `shipping_method.translation.trackingUrl` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation`.`delivery_time_id`, `shipping_method.deliveryTime.translation`.`name` as `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation`.`custom_fields` as `shipping_method.deliveryTime.translation.customFields` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation`.`language_id` = ?) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `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"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01“°+Ó\x04su¦Ž‘æ³­©‚"
  b"\x01“°+Ó\x04su¦Ž‘æ³\x1A‰+"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.52 ms
(4.64%) 		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`.`active` = ? AND `country.salesChannels`.`id` = ?) GROUP BY `country`.`id`
Parameters: 
[
  true
  b"\x01ô░,¼lqhÀ Ø\x14╗\x1DÖ\x11"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.69 ms
(1.73%) 		2 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.49 ms
(1.53%) 		1 
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters: 
[
  "de-DE"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.29 ms
(1.32%) 		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
1.01 ms
(1.04%) 		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
1.00 ms
(1.03%) 		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/0197a6bebf1771539a4f4920a57ca4a4"
  "/navigation/0197a6be30e97639bed5fa9f88895bf5"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01ô░,¼lqhÀ Ø\x14╗\x1DÖ\x11"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.90 ms
(0.93%) 		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.89 ms
(0.91%) 		1 
# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND ((seo_path_info = ? OR seo_path_info = ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01ô░,¼lqhÀ Ø\x14╗\x1DÖ\x11"
  "checkout/cart"
  "checkout/cart/"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.86 ms
(0.88%) 		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ô░+ÊòsìÀTï\e═\x05Ãû"
  b"\x01“°+Ó\x04su¦Ž‘æ³¹Yð"
  b"""
    \x01“°+úšrÝ»\n
    ÿ£„ö\x07\n
    """
  b"\x01“°+ÓÙpç‚‘'ñ.iïM"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.84 ms
(0.86%) 		1 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"\x01ô░,¼lqhÀ Ø\x14╗\x1DÖ\x11"
  "umRtjYz19jQEwvHJdL6IfY0gZVTPrmkv"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.73 ms
(0.75%) 		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"\x01ô░,¼lqhÀ Ø\x14╗\x1DÖ\x11"
  b"\x01“°+ʃq ™aæ{+\x06mà"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.73 ms
(0.75%) 		1 
#cart-persister::load
            SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters: 
[
  "umRtjYz19jQEwvHJdL6IfY0gZVTPrmkv"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.53 ms
(0.55%) 		1 
SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.45 ms
(0.46%) 		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"\x01ô░,¼lqhÀ Ø\x14╗\x1DÖ\x11"
  "/checkout/cart"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.38 ms
(0.39%) 		1 
SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.