11.45 ms
11
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` . `source_type` as `app.sourceType` , `app` . `source_config` as `app.sourceConfig` , `app` . `self_managed` as `app.selfManaged` , `app` . `integration_id` as `app.integrationId` , `app.integration` . `id` as `app.integration.id` , `app.integration` . `label` as `app.integration.label` , `app.integration` . `access_key` as `app.integration.accessKey` , `app.integration` . `secret_access_key` as `app.integration.secretAccessKey` , `app.integration` . `last_usage_at` as `app.integration.lastUsageAt` , `app.integration` . `admin` as `app.integration.admin` , `app.integration` . `custom_fields` as `app.integration.customFields` , `app.integration` . `deleted_at` as `app.integration.deletedAt` , `app.integration` . `created_at` as `app.integration.createdAt` , `app.integration` . `updated_at` as `app.integration.updatedAt` , `app` . `acl_role_id` as `app.aclRoleId` , `app.aclRole` . `id` as `app.aclRole.id` , `app.aclRole` . `name` as `app.aclRole.name` , `app.aclRole` . `description` as `app.aclRole.description` , `app.aclRole` . `privileges` as `app.aclRole.privileges` , `app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` , `app.aclRole` . `created_at` as `app.aclRole.createdAt` , `app.aclRole` . `updated_at` as `app.aclRole.updatedAt` , `app` . `created_at` as `app.createdAt` , `app` . `updated_at` as `app.updatedAt` , `app.translation.label` , `app.translation.label` as `app.label` , `app.translation.description` , `app.translation.description` as `app.description` , `app.translation.privacyPolicyExtensions` , `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions` , `app.translation.customFields` , `app.translation.customFields` as `app.customFields` FROM `app` LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id` LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id` LEFT JOIN (SELECT `app.translation` . `app_id` , `app.translation` . `label` as `app.translation.label` , `app.translation` . `description` as `app.translation.description` , `app.translation` . `privacy_policy_extensions` as `app.translation.privacyPolicyExtensions` , `app.translation` . `custom_fields` as `app.translation.customFields` FROM `app_translation` `app.translation` WHERE `app.translation` . `language_id` = ? ) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id` WHERE `app` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 “?ÐËçrÅ€\x04 ÜWË0Ë\x1E ]
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` . `source_type` as `app.sourceType` ,
`app` . `source_config` as `app.sourceConfig` ,
`app` . `self_managed` as `app.selfManaged` ,
`app` . `integration_id` as `app.integrationId` ,
`app.integration` . `id` as `app.integration.id` ,
`app.integration` . `label` as `app.integration.label` ,
`app.integration` . `access_key` as `app.integration.accessKey` ,
`app.integration` . `secret_access_key` as `app.integration.secretAccessKey` ,
`app.integration` . `last_usage_at` as `app.integration.lastUsageAt` ,
`app.integration` . `admin` as `app.integration.admin` ,
`app.integration` . `custom_fields` as `app.integration.customFields` ,
`app.integration` . `deleted_at` as `app.integration.deletedAt` ,
`app.integration` . `created_at` as `app.integration.createdAt` ,
`app.integration` . `updated_at` as `app.integration.updatedAt` ,
`app` . `acl_role_id` as `app.aclRoleId` ,
`app.aclRole` . `id` as `app.aclRole.id` ,
`app.aclRole` . `name` as `app.aclRole.name` ,
`app.aclRole` . `description` as `app.aclRole.description` ,
`app.aclRole` . `privileges` as `app.aclRole.privileges` ,
`app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` ,
`app.aclRole` . `created_at` as `app.aclRole.createdAt` ,
`app.aclRole` . `updated_at` as `app.aclRole.updatedAt` ,
`app` . `created_at` as `app.createdAt` ,
`app` . `updated_at` as `app.updatedAt` ,
`app.translation.label` ,
`app.translation.label` as `app.label` ,
`app.translation.description` ,
`app.translation.description` as `app.description` ,
`app.translation.privacyPolicyExtensions` ,
`app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions` ,
`app.translation.customFields` ,
`app.translation.customFields` as `app.customFields`
FROM
`app`
LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id`
LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id`
LEFT JOIN (
SELECT
`app.translation` . `app_id` ,
`app.translation` . `label` as `app.translation.label` ,
`app.translation` . `description` as `app.translation.description` ,
`app.translation` . `privacy_policy_extensions` as `app.translation.privacyPolicyExtensions` ,
`app.translation` . `custom_fields` as `app.translation.customFields`
FROM
`app_translation` `app.translation`
WHERE
`app.translation` . `language_id` = ?
) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id`
WHERE
`app` . `id` IN (? )Copy
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` . `source_type` as `app.sourceType` , `app` . `source_config` as `app.sourceConfig` , `app` . `self_managed` as `app.selfManaged` , `app` . `integration_id` as `app.integrationId` , `app.integration` . `id` as `app.integration.id` , `app.integration` . `label` as `app.integration.label` , `app.integration` . `access_key` as `app.integration.accessKey` , `app.integration` . `secret_access_key` as `app.integration.secretAccessKey` , `app.integration` . `last_usage_at` as `app.integration.lastUsageAt` , `app.integration` . `admin` as `app.integration.admin` , `app.integration` . `custom_fields` as `app.integration.customFields` , `app.integration` . `deleted_at` as `app.integration.deletedAt` , `app.integration` . `created_at` as `app.integration.createdAt` , `app.integration` . `updated_at` as `app.integration.updatedAt` , `app` . `acl_role_id` as `app.aclRoleId` , `app.aclRole` . `id` as `app.aclRole.id` , `app.aclRole` . `name` as `app.aclRole.name` , `app.aclRole` . `description` as `app.aclRole.description` , `app.aclRole` . `privileges` as `app.aclRole.privileges` , `app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` , `app.aclRole` . `created_at` as `app.aclRole.createdAt` , `app.aclRole` . `updated_at` as `app.aclRole.updatedAt` , `app` . `created_at` as `app.createdAt` , `app` . `updated_at` as `app.updatedAt` , `app.translation.label` , `app.translation.label` as `app.label` , `app.translation.description` , `app.translation.description` as `app.description` , `app.translation.privacyPolicyExtensions` , `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions` , `app.translation.customFields` , `app.translation.customFields` as `app.customFields` FROM `app` LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id` LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id` LEFT JOIN (SELECT `app.translation` . `app_id` , `app.translation` . `label` as `app.translation.label` , `app.translation` . `description` as `app.translation.description` , `app.translation` . `privacy_policy_extensions` as `app.translation.privacyPolicyExtensions` , `app.translation` . `custom_fields` as `app.translation.customFields` FROM `app_translation` `app.translation` WHERE `app.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id` WHERE `app` . `id` IN (0x01933FD0CBE772C58004DC57CB30CB1E ); Copy
6.80 ms
11
SELECT LOWER (HEX (`script` . `app_id` )) as `app_id` ,
`script` . `name` AS scriptName ,
`script` . `script` AS script ,
`script` . `hook` AS hook ,
IFNULL (`script` . `updated_at` , `script` . `created_at` ) AS lastModified ,
`app` . `name` AS appName ,
LOWER (HEX (`app` . `integration_id` )) AS integrationId ,
`app` . `version` AS appVersion ,
`script` . `active` AS active
FROM `script`
LEFT JOIN `app` ON `script` . `app_id` = `app` . `id`
WHERE `script` . `hook` ! = 'include'
ORDER BY `app` . `created_at` , `app` . `id` , `script` . `name`
SELECT LOWER (HEX (`script` . `app_id` )) as `app_id` ,
`script` . `name` AS scriptName ,
`script` . `script` AS script ,
`script` . `hook` AS hook ,
IFNULL (`script` . `updated_at` , `script` . `created_at` ) AS lastModified ,
`app` . `name` AS appName ,
LOWER (HEX (`app` . `integration_id` )) AS integrationId ,
`app` . `version` AS appVersion ,
`script` . `active` AS active
FROM `script`
LEFT JOIN `app` ON `script` . `app_id` = `app` . `id`
WHERE `script` . `hook` ! = 'include'
ORDER BY `app` . `created_at` , `app` . `id` , `script` . `name`
; Copy
6.30 ms
2
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.NavEntity` . `id` as `category.NavEntity.id` , `category.NavEntity` . `category_id` as `category.NavEntity.category_id` , `category.NavEntity` . `profile_image` as `category.NavEntity.profile_image` , `category.NavEntity` . `category_video` as `category.NavEntity.category_video` , `category.NavEntity` . `middle_image` as `category.NavEntity.middle_image` , `category.NavEntity` . `created_at` as `category.NavEntity.createdAt` , `category.NavEntity` . `updated_at` as `category.NavEntity.updatedAt` , `category.NavEntity.translation.description_top` , `category.NavEntity.translation.description_top` as `category.NavEntity.description_top` , `category.NavEntity.translation.description_bottom` , `category.NavEntity.translation.description_bottom` as `category.NavEntity.description_bottom` , `category.batteriumCategorySvgUri` . `id` as `category.batteriumCategorySvgUri.id` , `category.batteriumCategorySvgUri` . `category_id` as `category.batteriumCategorySvgUri.category_id` , `category.batteriumCategorySvgUri` . `org_filename` as `category.batteriumCategorySvgUri.org_filename` , `category.batteriumCategorySvgUri` . `created_at` as `category.batteriumCategorySvgUri.createdAt` , `category.batteriumCategorySvgUri` . `updated_at` as `category.batteriumCategorySvgUri.updatedAt` , `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 `nav` `category.NavEntity` ON `category` . `id` = `category.NavEntity` . `category_id` LEFT JOIN `batterium_category_svg_uri` `category.batteriumCategorySvgUri` ON `category` . `id` = `category.batteriumCategorySvgUri` . `category_id` LEFT JOIN (SELECT `category.translation` . `category_id` , `category.translation` . `category_version_id` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation` . `breadcrumb` as `category.translation.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `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.NavEntity.translation` . `nav_id` , `category.NavEntity.translation` . `description_top` as `category.NavEntity.translation.description_top` , `category.NavEntity.translation` . `description_bottom` as `category.NavEntity.translation.description_bottom` FROM `nav_translation` `category.NavEntity.translation` WHERE `category.NavEntity.translation` . `language_id` = ? ) `category.NavEntity.nav_translation` ON `category.NavEntity.nav_translation` . `nav_id` = `category.NavEntity` . `id` WHERE (`category` . `version_id` = ? ) AND ((COALESCE (IF (JSON_TYPE (JSON_EXTRACT (`category.translation.customFields` , '$.nf_category_positioning_style' )) ! = "NULL" , CONVERT (JSON_UNQUOTE (JSON_EXTRACT (`category.translation.customFields` , '$.nf_category_positioning_style' )) USING "utf8mb4" ) COLLATE utf8mb4_unicode_ci , NULL )) = ? AND `category` . `visible` = ? AND `category` . `active` = ? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4%flyout "
true
true
]
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.NavEntity` . `id` as `category.NavEntity.id` ,
`category.NavEntity` . `category_id` as `category.NavEntity.category_id` ,
`category.NavEntity` . `profile_image` as `category.NavEntity.profile_image` ,
`category.NavEntity` . `category_video` as `category.NavEntity.category_video` ,
`category.NavEntity` . `middle_image` as `category.NavEntity.middle_image` ,
`category.NavEntity` . `created_at` as `category.NavEntity.createdAt` ,
`category.NavEntity` . `updated_at` as `category.NavEntity.updatedAt` ,
`category.NavEntity.translation.description_top` ,
`category.NavEntity.translation.description_top` as `category.NavEntity.description_top` ,
`category.NavEntity.translation.description_bottom` ,
`category.NavEntity.translation.description_bottom` as `category.NavEntity.description_bottom` ,
`category.batteriumCategorySvgUri` . `id` as `category.batteriumCategorySvgUri.id` ,
`category.batteriumCategorySvgUri` . `category_id` as `category.batteriumCategorySvgUri.category_id` ,
`category.batteriumCategorySvgUri` . `org_filename` as `category.batteriumCategorySvgUri.org_filename` ,
`category.batteriumCategorySvgUri` . `created_at` as `category.batteriumCategorySvgUri.createdAt` ,
`category.batteriumCategorySvgUri` . `updated_at` as `category.batteriumCategorySvgUri.updatedAt` ,
`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 `nav` `category.NavEntity` ON `category` . `id` = `category.NavEntity` . `category_id`
LEFT JOIN `batterium_category_svg_uri` `category.batteriumCategorySvgUri` ON `category` . `id` = `category.batteriumCategorySvgUri` . `category_id`
LEFT JOIN (
SELECT
`category.translation` . `category_id` ,
`category.translation` . `category_version_id` ,
`category.translation` . `custom_fields` as `category.translation.customFields` ,
`category.translation` . `breadcrumb` as `category.translation.breadcrumb` ,
`category.translation` . `name` as `category.translation.name` ,
`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.NavEntity.translation` . `nav_id` ,
`category.NavEntity.translation` . `description_top` as `category.NavEntity.translation.description_top` ,
`category.NavEntity.translation` . `description_bottom` as `category.NavEntity.translation.description_bottom`
FROM
`nav_translation` `category.NavEntity.translation`
WHERE
`category.NavEntity.translation` . `language_id` = ?
) `category.NavEntity.nav_translation` ON `category.NavEntity.nav_translation` . `nav_id` = `category.NavEntity` . `id`
WHERE
(`category` . `version_id` = ? )
AND (
(
COALESCE (
IF (
JSON_TYPE (
JSON_EXTRACT (
`category.translation.customFields` ,
'$.nf_category_positioning_style'
)
) ! = "NULL" ,
CONVERT (
JSON_UNQUOTE (
JSON_EXTRACT (
`category.translation.customFields` ,
'$.nf_category_positioning_style'
)
) USING "utf8mb4"
) COLLATE utf8mb4_unicode_ci ,
NULL
)
) = ?
AND `category` . `visible` = ?
AND `category` . `active` = ?
)
)Copy
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.NavEntity` . `id` as `category.NavEntity.id` , `category.NavEntity` . `category_id` as `category.NavEntity.category_id` , `category.NavEntity` . `profile_image` as `category.NavEntity.profile_image` , `category.NavEntity` . `category_video` as `category.NavEntity.category_video` , `category.NavEntity` . `middle_image` as `category.NavEntity.middle_image` , `category.NavEntity` . `created_at` as `category.NavEntity.createdAt` , `category.NavEntity` . `updated_at` as `category.NavEntity.updatedAt` , `category.NavEntity.translation.description_top` , `category.NavEntity.translation.description_top` as `category.NavEntity.description_top` , `category.NavEntity.translation.description_bottom` , `category.NavEntity.translation.description_bottom` as `category.NavEntity.description_bottom` , `category.batteriumCategorySvgUri` . `id` as `category.batteriumCategorySvgUri.id` , `category.batteriumCategorySvgUri` . `category_id` as `category.batteriumCategorySvgUri.category_id` , `category.batteriumCategorySvgUri` . `org_filename` as `category.batteriumCategorySvgUri.org_filename` , `category.batteriumCategorySvgUri` . `created_at` as `category.batteriumCategorySvgUri.createdAt` , `category.batteriumCategorySvgUri` . `updated_at` as `category.batteriumCategorySvgUri.updatedAt` , `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 `nav` `category.NavEntity` ON `category` . `id` = `category.NavEntity` . `category_id` LEFT JOIN `batterium_category_svg_uri` `category.batteriumCategorySvgUri` ON `category` . `id` = `category.batteriumCategorySvgUri` . `category_id` LEFT JOIN (SELECT `category.translation` . `category_id` , `category.translation` . `category_version_id` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation` . `breadcrumb` as `category.translation.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `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` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `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.NavEntity.translation` . `nav_id` , `category.NavEntity.translation` . `description_top` as `category.NavEntity.translation.description_top` , `category.NavEntity.translation` . `description_bottom` as `category.NavEntity.translation.description_bottom` FROM `nav_translation` `category.NavEntity.translation` WHERE `category.NavEntity.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `category.NavEntity.nav_translation` ON `category.NavEntity.nav_translation` . `nav_id` = `category.NavEntity` . `id` WHERE (`category` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND ((COALESCE (IF (JSON_TYPE (JSON_EXTRACT (`category.translation.customFields` , '$.nf_category_positioning_style' )) ! = "NULL" , CONVERT (JSON_UNQUOTE (JSON_EXTRACT (`category.translation.customFields` , '$.nf_category_positioning_style' )) USING "utf8mb4" ) COLLATE utf8mb4_unicode_ci , NULL )) = 'flyout' AND `category` . `visible` = 1 AND `category` . `active` = 1 )); Copy
5.68 ms
11
SELECT `app` . `id` FROM `app` WHERE (`app` . `active` = ? )
SELECT `app` . `id` FROM `app` WHERE (`app` . `active` = 1 );
Copy
5.56 ms
1
REPLACE INTO sales_channel_api_context (`token` , `payload` , `sales_channel_id` , `customer_id` , `updated_at` )
VALUES (? , ? , ? , ? , ? )
Parameters :
[
"hl3ZJDexNsPSaicgztkRiqfRx0cjOcSP "
"{"shippingMethodId":"0192b53868b67048a8abdb26e5babd8d","paymentMethodId":"0192b53868927307b0aca1959b522fc3"} "
b"\x01 ’µ8öEr²ªÍW«a$LHnull
"2025-01-22 16:53:31.129 "
]
REPLACE INTO sales_channel_api_context (`token` , `payload` , `sales_channel_id` , `customer_id` , `updated_at` )
VALUES ('hl3ZJDexNsPSaicgztkRiqfRx0cjOcSP' , '{\"shippingMethodId\":\"0192b53868b67048a8abdb26e5babd8d\",\"paymentMethodId\":\"0192b53868927307b0aca1959b522fc3\"}' , 0x0192B538F64572B2AACD57AB61244C48 , NULL , '2025-01-22 16:53:31.129' ); Copy
5.23 ms
11
SELECT `script` . `id` as `script.id` , `script` . `script` as `script.script` , `script` . `hook` as `script.hook` , `script` . `name` as `script.name` , `script` . `active` as `script.active` , `script` . `app_id` as `script.appId` , `script` . `created_at` as `script.createdAt` , `script` . `updated_at` as `script.updatedAt` FROM `script` WHERE (`script` . `app_id` IN (? ))
Parameters :
[
b"\x01 “?ÐËçrÅ€\x04 ÜWË0Ë\x1E ]
SELECT `script` . `id` as `script.id` , `script` . `script` as `script.script` , `script` . `hook` as `script.hook` , `script` . `name` as `script.name` , `script` . `active` as `script.active` , `script` . `app_id` as `script.appId` , `script` . `created_at` as `script.createdAt` , `script` . `updated_at` as `script.updatedAt` FROM `script` WHERE (`script` . `app_id` IN (0x01933FD0CBE772C58004DC57CB30CB1E )); Copy
4.38 ms
11
SELECT LOWER (HEX (`script` . `app_id` )) as `app_id` ,
`script` . `name` AS name ,
`script` . `script` AS script ,
`app` . `name` AS appName ,
LOWER (HEX (`app` . `integration_id` )) AS integrationId ,
IFNULL (`script` . `updated_at` , `script` . `created_at` ) AS lastModified
FROM `script`
LEFT JOIN `app` ON `script` . `app_id` = `app` . `id`
WHERE `script` . `hook` = 'include'
ORDER BY `app` . `created_at` , `app` . `id` , `script` . `name`
SELECT LOWER (HEX (`script` . `app_id` )) as `app_id` ,
`script` . `name` AS name ,
`script` . `script` AS script ,
`app` . `name` AS appName ,
LOWER (HEX (`app` . `integration_id` )) AS integrationId ,
IFNULL (`script` . `updated_at` , `script` . `created_at` ) AS lastModified
FROM `script`
LEFT JOIN `app` ON `script` . `app_id` = `app` . `id`
WHERE `script` . `hook` = 'include'
ORDER BY `app` . `created_at` , `app` . `id` , `script` . `name`
; Copy
3.39 ms
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`
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
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` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` ; Copy
3.19 ms
11
SELECT `link_item` . `id` FROM `link_item` WHERE (`link_item` . `group_id` = ? AND `link_item` . `active` = ? ) ORDER BY `link_item` . `order_number` ASC
Parameters :
[
b"\x01 ÆÂ\x17 b╚q\x1D êü&\x05\x16 1Jutrue
]
SELECT `link_item` . `id` FROM `link_item` WHERE (`link_item` . `group_id` = 0x0192B61762C8711D8881260516314A75 AND `link_item` . `active` = 1 ) ORDER BY `link_item` . `order_number` ASC ; Copy
1.71 ms
1
SELECT `country_state` . `id` as `country_state.id` , `country_state` . `country_id` as `country_state.countryId` , `country_state` . `short_code` as `country_state.shortCode` , `country_state` . `position` as `country_state.position` , `country_state` . `active` as `country_state.active` , `country_state` . `created_at` as `country_state.createdAt` , `country_state` . `updated_at` as `country_state.updatedAt` , `country_state.translation.name` , `country_state.translation.name` as `country_state.name` , `country_state.translation.customFields` , `country_state.translation.customFields` as `country_state.customFields` FROM `country_state` LEFT JOIN (SELECT `country_state.translation` . `country_state_id` , `country_state.translation` . `name` as `country_state.translation.name` , `country_state.translation` . `custom_fields` as `country_state.translation.customFields` FROM `country_state_translation` `country_state.translation` WHERE `country_state.translation` . `language_id` = ? ) `country_state.country_state_translation` ON `country_state.country_state_translation` . `country_state_id` = `country_state` . `id`
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `country_state` . `id` as `country_state.id` , `country_state` . `country_id` as `country_state.countryId` , `country_state` . `short_code` as `country_state.shortCode` , `country_state` . `position` as `country_state.position` , `country_state` . `active` as `country_state.active` , `country_state` . `created_at` as `country_state.createdAt` , `country_state` . `updated_at` as `country_state.updatedAt` , `country_state.translation.name` , `country_state.translation.name` as `country_state.name` , `country_state.translation.customFields` , `country_state.translation.customFields` as `country_state.customFields` FROM `country_state` LEFT JOIN (SELECT `country_state.translation` . `country_state_id` , `country_state.translation` . `name` as `country_state.translation.name` , `country_state.translation` . `custom_fields` as `country_state.translation.customFields` FROM `country_state_translation` `country_state.translation` WHERE `country_state.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `country_state.country_state_translation` ON `country_state.country_state_translation` . `country_state_id` = `country_state` . `id` ; Copy
1.61 ms
2
SELECT `plugin` . `id` as `plugin.id` , `plugin` . `base_class` as `plugin.baseClass` , `plugin` . `name` as `plugin.name` , `plugin` . `composer_name` as `plugin.composerName` , `plugin` . `autoload` as `plugin.autoload` , `plugin` . `active` as `plugin.active` , `plugin` . `managed_by_composer` as `plugin.managedByComposer` , `plugin` . `path` as `plugin.path` , `plugin` . `author` as `plugin.author` , `plugin` . `copyright` as `plugin.copyright` , `plugin` . `license` as `plugin.license` , `plugin` . `version` as `plugin.version` , `plugin` . `upgrade_version` as `plugin.upgradeVersion` , `plugin` . `installed_at` as `plugin.installedAt` , `plugin` . `upgraded_at` as `plugin.upgradedAt` , `plugin` . `icon` as `plugin.iconRaw` , `plugin` . `created_at` as `plugin.createdAt` , `plugin` . `updated_at` as `plugin.updatedAt` , `plugin.translation.label` , `plugin.translation.label` as `plugin.label` , `plugin.translation.description` , `plugin.translation.description` as `plugin.description` , `plugin.translation.manufacturerLink` , `plugin.translation.manufacturerLink` as `plugin.manufacturerLink` , `plugin.translation.supportLink` , `plugin.translation.supportLink` as `plugin.supportLink` , `plugin.translation.customFields` , `plugin.translation.customFields` as `plugin.customFields` FROM `plugin` LEFT JOIN (SELECT `plugin.translation` . `plugin_id` , `plugin.translation` . `label` as `plugin.translation.label` , `plugin.translation` . `description` as `plugin.translation.description` , `plugin.translation` . `manufacturer_link` as `plugin.translation.manufacturerLink` , `plugin.translation` . `support_link` as `plugin.translation.supportLink` , `plugin.translation` . `custom_fields` as `plugin.translation.customFields` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation` . `language_id` = ? ) `plugin.plugin_translation` ON `plugin.plugin_translation` . `plugin_id` = `plugin` . `id` WHERE (`plugin` . `name` = ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
"EnderecoShopware6ClientStore "
]
SELECT `plugin` . `id` as `plugin.id` , `plugin` . `base_class` as `plugin.baseClass` , `plugin` . `name` as `plugin.name` , `plugin` . `composer_name` as `plugin.composerName` , `plugin` . `autoload` as `plugin.autoload` , `plugin` . `active` as `plugin.active` , `plugin` . `managed_by_composer` as `plugin.managedByComposer` , `plugin` . `path` as `plugin.path` , `plugin` . `author` as `plugin.author` , `plugin` . `copyright` as `plugin.copyright` , `plugin` . `license` as `plugin.license` , `plugin` . `version` as `plugin.version` , `plugin` . `upgrade_version` as `plugin.upgradeVersion` , `plugin` . `installed_at` as `plugin.installedAt` , `plugin` . `upgraded_at` as `plugin.upgradedAt` , `plugin` . `icon` as `plugin.iconRaw` , `plugin` . `created_at` as `plugin.createdAt` , `plugin` . `updated_at` as `plugin.updatedAt` , `plugin.translation.label` , `plugin.translation.label` as `plugin.label` , `plugin.translation.description` , `plugin.translation.description` as `plugin.description` , `plugin.translation.manufacturerLink` , `plugin.translation.manufacturerLink` as `plugin.manufacturerLink` , `plugin.translation.supportLink` , `plugin.translation.supportLink` as `plugin.supportLink` , `plugin.translation.customFields` , `plugin.translation.customFields` as `plugin.customFields` FROM `plugin` LEFT JOIN (SELECT `plugin.translation` . `plugin_id` , `plugin.translation` . `label` as `plugin.translation.label` , `plugin.translation` . `description` as `plugin.translation.description` , `plugin.translation` . `manufacturer_link` as `plugin.translation.manufacturerLink` , `plugin.translation` . `support_link` as `plugin.translation.supportLink` , `plugin.translation` . `custom_fields` as `plugin.translation.customFields` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `plugin.plugin_translation` ON `plugin.plugin_translation` . `plugin_id` = `plugin` . `id` WHERE (`plugin` . `name` = 'EnderecoShopware6ClientStore' ); Copy
1.50 ms
2
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` . `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 "
]
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` . `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` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `language.locale.locale_translation` ON `language.locale.locale_translation` . `locale_id` = `language.locale` . `id` WHERE `language` . `id` IN (0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ); Copy
1.25 ms
2
SELECT `sales_channel` . `id` FROM `sales_channel` LEFT JOIN `sales_channel_payment_method` `sales_channel.paymentMethods.mapping` ON `sales_channel` . `id` = `sales_channel.paymentMethods.mapping` . `sales_channel_id` LEFT JOIN `payment_method` `sales_channel.paymentMethods` ON `sales_channel.paymentMethods.mapping` . `payment_method_id` = `sales_channel.paymentMethods` . `id` WHERE ((`sales_channel` . `id` = ? AND `sales_channel.paymentMethods` . `id` = ? AND `sales_channel.paymentMethods` . `active` = ? )) LIMIT 1
Parameters :
[
b"\x01 ’µ8öEr²ªÍW«a$LH¸©Å╔└\x10 G\x02 ®ofM½■&V "
true
]
SELECT `sales_channel` . `id` FROM `sales_channel` LEFT JOIN `sales_channel_payment_method` `sales_channel.paymentMethods.mapping` ON `sales_channel` . `id` = `sales_channel.paymentMethods.mapping` . `sales_channel_id` LEFT JOIN `payment_method` `sales_channel.paymentMethods` ON `sales_channel.paymentMethods.mapping` . `payment_method_id` = `sales_channel.paymentMethods` . `id` WHERE ((`sales_channel` . `id` = 0x0192B538F64572B2AACD57AB61244C48 AND `sales_channel.paymentMethods` . `id` = 0xF7B88FC9C0104702A96F664DABFE2656 AND `sales_channel.paymentMethods` . `active` = 1 )) LIMIT 1 ; Copy
1.14 ms
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` . `source_type` as `app.sourceType` , `app` . `source_config` as `app.sourceConfig` , `app` . `self_managed` as `app.selfManaged` , `app` . `integration_id` as `app.integrationId` , `app.integration` . `id` as `app.integration.id` , `app.integration` . `label` as `app.integration.label` , `app.integration` . `access_key` as `app.integration.accessKey` , `app.integration` . `secret_access_key` as `app.integration.secretAccessKey` , `app.integration` . `last_usage_at` as `app.integration.lastUsageAt` , `app.integration` . `admin` as `app.integration.admin` , `app.integration` . `custom_fields` as `app.integration.customFields` , `app.integration` . `deleted_at` as `app.integration.deletedAt` , `app.integration` . `created_at` as `app.integration.createdAt` , `app.integration` . `updated_at` as `app.integration.updatedAt` , `app` . `acl_role_id` as `app.aclRoleId` , `app.aclRole` . `id` as `app.aclRole.id` , `app.aclRole` . `name` as `app.aclRole.name` , `app.aclRole` . `description` as `app.aclRole.description` , `app.aclRole` . `privileges` as `app.aclRole.privileges` , `app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` , `app.aclRole` . `created_at` as `app.aclRole.createdAt` , `app.aclRole` . `updated_at` as `app.aclRole.updatedAt` , `app` . `created_at` as `app.createdAt` , `app` . `updated_at` as `app.updatedAt` , `app.translation.label` , `app.translation.label` as `app.label` , `app.translation.description` , `app.translation.description` as `app.description` , `app.translation.privacyPolicyExtensions` , `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions` , `app.translation.customFields` , `app.translation.customFields` as `app.customFields` FROM `app` LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id` LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id` LEFT JOIN (SELECT `app.translation` . `app_id` , `app.translation` . `label` as `app.translation.label` , `app.translation` . `description` as `app.translation.description` , `app.translation` . `privacy_policy_extensions` as `app.translation.privacyPolicyExtensions` , `app.translation` . `custom_fields` as `app.translation.customFields` FROM `app_translation` `app.translation` WHERE `app.translation` . `language_id` = ? ) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id` WHERE (`app` . `active` = ? AND NOT (`app` . `checkout_gateway_url` < = > ? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
true
null
]
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` . `source_type` as `app.sourceType` ,
`app` . `source_config` as `app.sourceConfig` ,
`app` . `self_managed` as `app.selfManaged` ,
`app` . `integration_id` as `app.integrationId` ,
`app.integration` . `id` as `app.integration.id` ,
`app.integration` . `label` as `app.integration.label` ,
`app.integration` . `access_key` as `app.integration.accessKey` ,
`app.integration` . `secret_access_key` as `app.integration.secretAccessKey` ,
`app.integration` . `last_usage_at` as `app.integration.lastUsageAt` ,
`app.integration` . `admin` as `app.integration.admin` ,
`app.integration` . `custom_fields` as `app.integration.customFields` ,
`app.integration` . `deleted_at` as `app.integration.deletedAt` ,
`app.integration` . `created_at` as `app.integration.createdAt` ,
`app.integration` . `updated_at` as `app.integration.updatedAt` ,
`app` . `acl_role_id` as `app.aclRoleId` ,
`app.aclRole` . `id` as `app.aclRole.id` ,
`app.aclRole` . `name` as `app.aclRole.name` ,
`app.aclRole` . `description` as `app.aclRole.description` ,
`app.aclRole` . `privileges` as `app.aclRole.privileges` ,
`app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` ,
`app.aclRole` . `created_at` as `app.aclRole.createdAt` ,
`app.aclRole` . `updated_at` as `app.aclRole.updatedAt` ,
`app` . `created_at` as `app.createdAt` ,
`app` . `updated_at` as `app.updatedAt` ,
`app.translation.label` ,
`app.translation.label` as `app.label` ,
`app.translation.description` ,
`app.translation.description` as `app.description` ,
`app.translation.privacyPolicyExtensions` ,
`app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions` ,
`app.translation.customFields` ,
`app.translation.customFields` as `app.customFields`
FROM
`app`
LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id`
LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id`
LEFT JOIN (
SELECT
`app.translation` . `app_id` ,
`app.translation` . `label` as `app.translation.label` ,
`app.translation` . `description` as `app.translation.description` ,
`app.translation` . `privacy_policy_extensions` as `app.translation.privacyPolicyExtensions` ,
`app.translation` . `custom_fields` as `app.translation.customFields`
FROM
`app_translation` `app.translation`
WHERE
`app.translation` . `language_id` = ?
) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id`
WHERE
(
`app` . `active` = ?
AND NOT (
`app` . `checkout_gateway_url` < = > ?
)
)Copy
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` . `source_type` as `app.sourceType` , `app` . `source_config` as `app.sourceConfig` , `app` . `self_managed` as `app.selfManaged` , `app` . `integration_id` as `app.integrationId` , `app.integration` . `id` as `app.integration.id` , `app.integration` . `label` as `app.integration.label` , `app.integration` . `access_key` as `app.integration.accessKey` , `app.integration` . `secret_access_key` as `app.integration.secretAccessKey` , `app.integration` . `last_usage_at` as `app.integration.lastUsageAt` , `app.integration` . `admin` as `app.integration.admin` , `app.integration` . `custom_fields` as `app.integration.customFields` , `app.integration` . `deleted_at` as `app.integration.deletedAt` , `app.integration` . `created_at` as `app.integration.createdAt` , `app.integration` . `updated_at` as `app.integration.updatedAt` , `app` . `acl_role_id` as `app.aclRoleId` , `app.aclRole` . `id` as `app.aclRole.id` , `app.aclRole` . `name` as `app.aclRole.name` , `app.aclRole` . `description` as `app.aclRole.description` , `app.aclRole` . `privileges` as `app.aclRole.privileges` , `app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` , `app.aclRole` . `created_at` as `app.aclRole.createdAt` , `app.aclRole` . `updated_at` as `app.aclRole.updatedAt` , `app` . `created_at` as `app.createdAt` , `app` . `updated_at` as `app.updatedAt` , `app.translation.label` , `app.translation.label` as `app.label` , `app.translation.description` , `app.translation.description` as `app.description` , `app.translation.privacyPolicyExtensions` , `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions` , `app.translation.customFields` , `app.translation.customFields` as `app.customFields` FROM `app` LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id` LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id` LEFT JOIN (SELECT `app.translation` . `app_id` , `app.translation` . `label` as `app.translation.label` , `app.translation` . `description` as `app.translation.description` , `app.translation` . `privacy_policy_extensions` as `app.translation.privacyPolicyExtensions` , `app.translation` . `custom_fields` as `app.translation.customFields` FROM `app_translation` `app.translation` WHERE `app.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id` WHERE (`app` . `active` = 1 AND NOT (`app` . `checkout_gateway_url` < = > NULL )); Copy
1.10 ms
3
DELETE FROM `cart` WHERE `token` = :token
Parameters :
[
"token " => "hl3ZJDexNsPSaicgztkRiqfRx0cjOcSP "
]
DELETE FROM `cart` WHERE `token` = 'hl3ZJDexNsPSaicgztkRiqfRx0cjOcSP' ; Copy
0.96 ms
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` . `technical_name` as `payment_method.technicalName` , `payment_method` . `created_at` as `payment_method.createdAt` , `payment_method` . `updated_at` as `payment_method.updatedAt` , `payment_method.plugin` . `id` as `payment_method.plugin.id` , `payment_method.plugin` . `base_class` as `payment_method.plugin.baseClass` , `payment_method.plugin` . `name` as `payment_method.plugin.name` , `payment_method.plugin` . `composer_name` as `payment_method.plugin.composerName` , `payment_method.plugin` . `autoload` as `payment_method.plugin.autoload` , `payment_method.plugin` . `active` as `payment_method.plugin.active` , `payment_method.plugin` . `managed_by_composer` as `payment_method.plugin.managedByComposer` , `payment_method.plugin` . `path` as `payment_method.plugin.path` , `payment_method.plugin` . `author` as `payment_method.plugin.author` , `payment_method.plugin` . `copyright` as `payment_method.plugin.copyright` , `payment_method.plugin` . `license` as `payment_method.plugin.license` , `payment_method.plugin` . `version` as `payment_method.plugin.version` , `payment_method.plugin` . `upgrade_version` as `payment_method.plugin.upgradeVersion` , `payment_method.plugin` . `installed_at` as `payment_method.plugin.installedAt` , `payment_method.plugin` . `upgraded_at` as `payment_method.plugin.upgradedAt` , `payment_method.plugin` . `icon` as `payment_method.plugin.iconRaw` , `payment_method.plugin` . `created_at` as `payment_method.plugin.createdAt` , `payment_method.plugin` . `updated_at` as `payment_method.plugin.updatedAt` , `payment_method.plugin.translation.label` , `payment_method.plugin.translation.label` as `payment_method.plugin.label` , `payment_method.plugin.translation.description` , `payment_method.plugin.translation.description` as `payment_method.plugin.description` , `payment_method.plugin.translation.manufacturerLink` , `payment_method.plugin.translation.manufacturerLink` as `payment_method.plugin.manufacturerLink` , `payment_method.plugin.translation.supportLink` , `payment_method.plugin.translation.supportLink` as `payment_method.plugin.supportLink` , `payment_method.plugin.translation.customFields` , `payment_method.plugin.translation.customFields` as `payment_method.plugin.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 `plugin` `payment_method.plugin` ON `payment_method` . `plugin_id` = `payment_method.plugin` . `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.plugin.translation` . `plugin_id` , `payment_method.plugin.translation` . `label` as `payment_method.plugin.translation.label` , `payment_method.plugin.translation` . `description` as `payment_method.plugin.translation.description` , `payment_method.plugin.translation` . `manufacturer_link` as `payment_method.plugin.translation.manufacturerLink` , `payment_method.plugin.translation` . `support_link` as `payment_method.plugin.translation.supportLink` , `payment_method.plugin.translation` . `custom_fields` as `payment_method.plugin.translation.customFields` FROM `plugin_translation` `payment_method.plugin.translation` WHERE `payment_method.plugin.translation` . `language_id` = ? ) `payment_method.plugin.plugin_translation` ON `payment_method.plugin.plugin_translation` . `plugin_id` = `payment_method.plugin` . `id` WHERE (`payment_method` . `id` = ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"¸©Å╔└\x10 G\x02 ®ofM½■&V "
]
SELECT
`payment_method` . `id` as `payment_method.id` ,
`payment_method` . `plugin_id` as `payment_method.pluginId` ,
`payment_method` . `handler_identifier` as `payment_method.handlerIdentifier` ,
`payment_method` . `position` as `payment_method.position` ,
`payment_method` . `active` as `payment_method.active` ,
`payment_method` . `after_order_enabled` as `payment_method.afterOrderEnabled` ,
`payment_method` . `availability_rule_id` as `payment_method.availabilityRuleId` ,
`payment_method` . `media_id` as `payment_method.mediaId` ,
`payment_method.appPaymentMethod` . `id` as `payment_method.appPaymentMethod.id` ,
`payment_method.appPaymentMethod` . `app_name` as `payment_method.appPaymentMethod.appName` ,
`payment_method.appPaymentMethod` . `identifier` as `payment_method.appPaymentMethod.identifier` ,
`payment_method.appPaymentMethod` . `pay_url` as `payment_method.appPaymentMethod.payUrl` ,
`payment_method.appPaymentMethod` . `finalize_url` as `payment_method.appPaymentMethod.finalizeUrl` ,
`payment_method.appPaymentMethod` . `validate_url` as `payment_method.appPaymentMethod.validateUrl` ,
`payment_method.appPaymentMethod` . `capture_url` as `payment_method.appPaymentMethod.captureUrl` ,
`payment_method.appPaymentMethod` . `refund_url` as `payment_method.appPaymentMethod.refundUrl` ,
`payment_method.appPaymentMethod` . `recurring_url` as `payment_method.appPaymentMethod.recurringUrl` ,
`payment_method.appPaymentMethod` . `app_id` as `payment_method.appPaymentMethod.appId` ,
`payment_method.appPaymentMethod` . `original_media_id` as `payment_method.appPaymentMethod.originalMediaId` ,
`payment_method.appPaymentMethod` . `payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId` ,
`payment_method.appPaymentMethod` . `created_at` as `payment_method.appPaymentMethod.createdAt` ,
`payment_method.appPaymentMethod` . `updated_at` as `payment_method.appPaymentMethod.updatedAt` ,
`payment_method` . `technical_name` as `payment_method.technicalName` ,
`payment_method` . `created_at` as `payment_method.createdAt` ,
`payment_method` . `updated_at` as `payment_method.updatedAt` ,
`payment_method.plugin` . `id` as `payment_method.plugin.id` ,
`payment_method.plugin` . `base_class` as `payment_method.plugin.baseClass` ,
`payment_method.plugin` . `name` as `payment_method.plugin.name` ,
`payment_method.plugin` . `composer_name` as `payment_method.plugin.composerName` ,
`payment_method.plugin` . `autoload` as `payment_method.plugin.autoload` ,
`payment_method.plugin` . `active` as `payment_method.plugin.active` ,
`payment_method.plugin` . `managed_by_composer` as `payment_method.plugin.managedByComposer` ,
`payment_method.plugin` . `path` as `payment_method.plugin.path` ,
`payment_method.plugin` . `author` as `payment_method.plugin.author` ,
`payment_method.plugin` . `copyright` as `payment_method.plugin.copyright` ,
`payment_method.plugin` . `license` as `payment_method.plugin.license` ,
`payment_method.plugin` . `version` as `payment_method.plugin.version` ,
`payment_method.plugin` . `upgrade_version` as `payment_method.plugin.upgradeVersion` ,
`payment_method.plugin` . `installed_at` as `payment_method.plugin.installedAt` ,
`payment_method.plugin` . `upgraded_at` as `payment_method.plugin.upgradedAt` ,
`payment_method.plugin` . `icon` as `payment_method.plugin.iconRaw` ,
`payment_method.plugin` . `created_at` as `payment_method.plugin.createdAt` ,
`payment_method.plugin` . `updated_at` as `payment_method.plugin.updatedAt` ,
`payment_method.plugin.translation.label` ,
`payment_method.plugin.translation.label` as `payment_method.plugin.label` ,
`payment_method.plugin.translation.description` ,
`payment_method.plugin.translation.description` as `payment_method.plugin.description` ,
`payment_method.plugin.translation.manufacturerLink` ,
`payment_method.plugin.translation.manufacturerLink` as `payment_method.plugin.manufacturerLink` ,
`payment_method.plugin.translation.supportLink` ,
`payment_method.plugin.translation.supportLink` as `payment_method.plugin.supportLink` ,
`payment_method.plugin.translation.customFields` ,
`payment_method.plugin.translation.customFields` as `payment_method.plugin.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 `plugin` `payment_method.plugin` ON `payment_method` . `plugin_id` = `payment_method.plugin` . `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.plugin.translation` . `plugin_id` ,
`payment_method.plugin.translation` . `label` as `payment_method.plugin.translation.label` ,
`payment_method.plugin.translation` . `description` as `payment_method.plugin.translation.description` ,
`payment_method.plugin.translation` . `manufacturer_link` as `payment_method.plugin.translation.manufacturerLink` ,
`payment_method.plugin.translation` . `support_link` as `payment_method.plugin.translation.supportLink` ,
`payment_method.plugin.translation` . `custom_fields` as `payment_method.plugin.translation.customFields`
FROM
`plugin_translation` `payment_method.plugin.translation`
WHERE
`payment_method.plugin.translation` . `language_id` = ?
) `payment_method.plugin.plugin_translation` ON `payment_method.plugin.plugin_translation` . `plugin_id` = `payment_method.plugin` . `id`
WHERE
(`payment_method` . `id` = ? )Copy
SELECT `payment_method` . `id` as `payment_method.id` , `payment_method` . `plugin_id` as `payment_method.pluginId` , `payment_method` . `handler_identifier` as `payment_method.handlerIdentifier` , `payment_method` . `position` as `payment_method.position` , `payment_method` . `active` as `payment_method.active` , `payment_method` . `after_order_enabled` as `payment_method.afterOrderEnabled` , `payment_method` . `availability_rule_id` as `payment_method.availabilityRuleId` , `payment_method` . `media_id` as `payment_method.mediaId` , `payment_method.appPaymentMethod` . `id` as `payment_method.appPaymentMethod.id` , `payment_method.appPaymentMethod` . `app_name` as `payment_method.appPaymentMethod.appName` , `payment_method.appPaymentMethod` . `identifier` as `payment_method.appPaymentMethod.identifier` , `payment_method.appPaymentMethod` . `pay_url` as `payment_method.appPaymentMethod.payUrl` , `payment_method.appPaymentMethod` . `finalize_url` as `payment_method.appPaymentMethod.finalizeUrl` , `payment_method.appPaymentMethod` . `validate_url` as `payment_method.appPaymentMethod.validateUrl` , `payment_method.appPaymentMethod` . `capture_url` as `payment_method.appPaymentMethod.captureUrl` , `payment_method.appPaymentMethod` . `refund_url` as `payment_method.appPaymentMethod.refundUrl` , `payment_method.appPaymentMethod` . `recurring_url` as `payment_method.appPaymentMethod.recurringUrl` , `payment_method.appPaymentMethod` . `app_id` as `payment_method.appPaymentMethod.appId` , `payment_method.appPaymentMethod` . `original_media_id` as `payment_method.appPaymentMethod.originalMediaId` , `payment_method.appPaymentMethod` . `payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId` , `payment_method.appPaymentMethod` . `created_at` as `payment_method.appPaymentMethod.createdAt` , `payment_method.appPaymentMethod` . `updated_at` as `payment_method.appPaymentMethod.updatedAt` , `payment_method` . `technical_name` as `payment_method.technicalName` , `payment_method` . `created_at` as `payment_method.createdAt` , `payment_method` . `updated_at` as `payment_method.updatedAt` , `payment_method.plugin` . `id` as `payment_method.plugin.id` , `payment_method.plugin` . `base_class` as `payment_method.plugin.baseClass` , `payment_method.plugin` . `name` as `payment_method.plugin.name` , `payment_method.plugin` . `composer_name` as `payment_method.plugin.composerName` , `payment_method.plugin` . `autoload` as `payment_method.plugin.autoload` , `payment_method.plugin` . `active` as `payment_method.plugin.active` , `payment_method.plugin` . `managed_by_composer` as `payment_method.plugin.managedByComposer` , `payment_method.plugin` . `path` as `payment_method.plugin.path` , `payment_method.plugin` . `author` as `payment_method.plugin.author` , `payment_method.plugin` . `copyright` as `payment_method.plugin.copyright` , `payment_method.plugin` . `license` as `payment_method.plugin.license` , `payment_method.plugin` . `version` as `payment_method.plugin.version` , `payment_method.plugin` . `upgrade_version` as `payment_method.plugin.upgradeVersion` , `payment_method.plugin` . `installed_at` as `payment_method.plugin.installedAt` , `payment_method.plugin` . `upgraded_at` as `payment_method.plugin.upgradedAt` , `payment_method.plugin` . `icon` as `payment_method.plugin.iconRaw` , `payment_method.plugin` . `created_at` as `payment_method.plugin.createdAt` , `payment_method.plugin` . `updated_at` as `payment_method.plugin.updatedAt` , `payment_method.plugin.translation.label` , `payment_method.plugin.translation.label` as `payment_method.plugin.label` , `payment_method.plugin.translation.description` , `payment_method.plugin.translation.description` as `payment_method.plugin.description` , `payment_method.plugin.translation.manufacturerLink` , `payment_method.plugin.translation.manufacturerLink` as `payment_method.plugin.manufacturerLink` , `payment_method.plugin.translation.supportLink` , `payment_method.plugin.translation.supportLink` as `payment_method.plugin.supportLink` , `payment_method.plugin.translation.customFields` , `payment_method.plugin.translation.customFields` as `payment_method.plugin.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 `plugin` `payment_method.plugin` ON `payment_method` . `plugin_id` = `payment_method.plugin` . `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` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation` . `payment_method_id` = `payment_method` . `id` LEFT JOIN (SELECT `payment_method.plugin.translation` . `plugin_id` , `payment_method.plugin.translation` . `label` as `payment_method.plugin.translation.label` , `payment_method.plugin.translation` . `description` as `payment_method.plugin.translation.description` , `payment_method.plugin.translation` . `manufacturer_link` as `payment_method.plugin.translation.manufacturerLink` , `payment_method.plugin.translation` . `support_link` as `payment_method.plugin.translation.supportLink` , `payment_method.plugin.translation` . `custom_fields` as `payment_method.plugin.translation.customFields` FROM `plugin_translation` `payment_method.plugin.translation` WHERE `payment_method.plugin.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `payment_method.plugin.plugin_translation` ON `payment_method.plugin.plugin_translation` . `plugin_id` = `payment_method.plugin` . `id` WHERE (`payment_method` . `id` = 0xF7B88FC9C0104702A96F664DABFE2656 ); Copy
0.95 ms
2
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ? ) AND (token = ? ) LIMIT 1
Parameters :
[
b"\x01 ’µ8öEr²ªÍW«a$LHhl3ZJDexNsPSaicgztkRiqfRx0cjOcSP "
]
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0x0192B538F64572B2AACD57AB61244C48 ) AND (token = 'hl3ZJDexNsPSaicgztkRiqfRx0cjOcSP' ) LIMIT 1 ; Copy
0.85 ms
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"\x06 ;\x1A Ô÷²HŠ—j²\x1F g\x0F +¾\x07 ü©»äeCÓ¬4^AóŽÿ\x16\v 5è0ßN+±\x16\x08\x08 k?Q\x00 \x1A pÎbÖˆOv ‹‘\x12 ÿ¤h)#{Þ\x03 ©g@ œ“¥R¾òj\x15 "
b"'[ÆÞ┤ìN\x04 ïð▒ͼ§ƒ╩ "
b"'©mÑô\r @ÝŸ\t /÷‘\v\v á "
b"-XfÈ\x04 {Oüª´\x1E ë!õL¼ "
b"7¢^¸¹äC%©€ª¶‘Øž\x12 "
b"=\x03 ÷zXLN?¦S~w*w|Œ "
b"Aš\x15 ÷n—Nü‚òF\x18 Zë³Ä "
b"""
M\x16 \r 7FòAJ£\kH±\n
t¹
"""
b"b\\x13 R\x12 FG\x1D §åcì7¹8\x10 "
b"fœ¸¾;ÀK‹Žq«TÁÞÞ= "
b"v|<\x15 =.Dê¡ÊJø5;Ÿd "
b"w«S;/TE&¬ègâ2É\x04 Í "
b"""
€‰U†\n
\x1E @H„p$G›#2\x0F †ñ¼áf\x12 Hþ„ÔÕ\v P_-F "
b"•Ó\r »žˆFõ°žM׳ß\x19 ¨ "
b"•éÝØHb@£ŽÈ‹æ¬—\e + "
b"–ìeø%µE¿—ï ‹l\t ä+ "
b"¬.\x1A F▀\x1A DèÉö\x1A ƒú+Z× "
b"½$GÀ\x1E ºJFâç,Ø[0ëC "
b"·Ì<L…üKP²\x0E gª‘{0® "
b"Ìz¹©ÐA@%‘¡ëwG´´„ "
b"Ú\x1C ¼¥w*O—¶¡ÓŠffÑK "
b"ÚIþx\x02 WDq®>¯ÿ;\x10 ´þ "
b"ó¥¸ÃOHF\x00 °{cÅF=ð "
b"\x01 ’µ8h~p{¶ºê,€q\r a\x01 ’µ8h¶pH¨«Û&çDÐÂ\x01 ÆÁ8v▒p3Å\x0F V\x7F i\x04\x19 ■\x01 “ ý½/sÍ£c~0°\t 8fäNg‚ÆBG·–¸‘Ï%®8÷ "
]
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 (
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ?
)Copy
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 (0x063B1AD4F7B2488A976AB21F670F2BBE , 0x07FCA9BBE46543D3AC345E41C3B38EFF , 0x160B35E830DF4E2BB11608086B3F5100 , 0x1A70CE62D6884F76A08B9112FFA46829 , 0x237BDE03A96740209C93A552BEF26A15 , 0x275B92E8B48D4E048BD0B1D6ACF59FCA , 0x27A96DD1F40D40DD9F092FF7910B0BE1 , 0x2D5866C8047B4FFCAAB41EEB21F54CBC , 0x37A25EB8B9E44325A980AAB691D89E12 , 0x3D03F77A584C4E3FA6537E772A777C8C , 0x419A15F76E974EFC82F246185AEBB3C4 , 0x4D160D3746F2414AA35C6B48B10A74B9 , 0x625C13521246471DA7E563EC37B93810 , 0x669CB8BE3BC04B8B8E71AB54C1DEDE3D , 0x767C3C153D2E44EAA1CA4AF8353B9F64 , 0x77AE533B2F544526AA8A6783329004D6 , 0x808955860A1E4048847024479B23320F , 0x86F1BCE1661248FE84D4D50B505F2D46 , 0x95D30DBB9E8846F5B09E4DD7B3DF19A8 , 0x95E9DDD8486240A38EC88BE6AC971B2B , 0x96EC65F825B545BF97EF208B6C09E42B , 0xAA2E1A46DF1A448A90941A9FA32B5A9E , 0xAB2447B71EA74A4683872C9D5B308943 , 0xB7CC3C4C85FC4B50B20E67AA917B30AE , 0xCC7AB9A9D041402591A1EB7747B4B484 , 0xDA1CBCA5772A4F97B6A1D38A6666D14B , 0xDA49FE7802574471AE3EAFFF3B10B4FE , 0xF3A5B8C34F484600A0B07B63C5463DF0 , 0x0192B538687E707BB6BAEA2C80710D61 , 0x0192B53868B67048A8ABDB26E744D0C2 , 0x0192B53876B170338F0F567F690419FE , 0x019320FDBD2F73CDA3637E30B0093866 , 0xE44E6782C64247B796B891CF25AE38F7 ); Copy
0.82 ms
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 ’µ8gIsúŸ’ÇM\x1F\x7F a¡ ]
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` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` WHERE `country` . `id` IN (0x0192B538674973FA9F92C74D1F7F61A1 ); Copy
0.80 ms
2
SELECT `key` , `value` FROM `app_config`
SELECT `key` , `value` FROM `app_config` ; Copy
0.79 ms
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` . `shipping_available` = ? AND `country.salesChannels` . `id` = ? ) GROUP BY `country` . `id`
Parameters :
[
true
b"\x01 ’µ8öEr²ªÍW«a$LH ]
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` . `shipping_available` = 1 AND `country.salesChannels` . `id` = 0x0192B538F64572B2AACD57AB61244C48 ) GROUP BY `country` . `id` ; Copy
0.75 ms
1
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 ’µ8öEr²ªÍW«a$LHcheckout/cart "
"checkout/cart/ "
]
SELECT id , path_info pathInfo , is_canonical isCanonical , sales_channel_id salesChannelId FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND ((sales_channel_id = 0x0192B538F64572B2AACD57AB61244C48 OR sales_channel_id IS NULL )) AND ((seo_path_info = 'checkout/cart' OR seo_path_info = 'checkout/cart/' ));
Copy
0.72 ms
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 ’µ8öEr²ªÍW«a$LH\x01 ’µ8gIsúŸ’ÇM\x1F\x7F a¡ ]
SELECT `sales_channel_country` . `sales_channel_id` , `sales_channel_country` . `country_id` FROM `sales_channel_country` WHERE (`sales_channel_country` . `sales_channel_id` = 0x0192B538F64572B2AACD57AB61244C48 AND `sales_channel_country` . `country_id` = 0x0192B538674973FA9F92C74D1F7F61A1 ); Copy
0.68 ms
1
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` ;
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` ; ;
Copy
0.65 ms
1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1 ; Copy
0.65 ms
1
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = ?
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = 'de-DE' ; Copy
0.64 ms
1
SELECT `handler_identifier` , LOWER (HEX (`id` )) FROM `payment_method`
SELECT `handler_identifier` , LOWER (HEX (`id` )) FROM `payment_method` ; Copy
0.56 ms
1
SELECT `link_item_group` . `id` as `link_item_group.id` , `link_item_group` . `name` as `link_item_group.name` , `link_item_group` . `style` as `link_item_group.style` , `link_item_group` . `active` as `link_item_group.active` , `link_item_group` . `custom_fields` as `link_item_group.customFields` , `link_item_group` . `created_at` as `link_item_group.createdAt` , `link_item_group` . `updated_at` as `link_item_group.updatedAt` FROM `link_item_group` WHERE (`link_item_group` . `active` = ? )
SELECT `link_item_group` . `id` as `link_item_group.id` , `link_item_group` . `name` as `link_item_group.name` , `link_item_group` . `style` as `link_item_group.style` , `link_item_group` . `active` as `link_item_group.active` , `link_item_group` . `custom_fields` as `link_item_group.customFields` , `link_item_group` . `created_at` as `link_item_group.createdAt` , `link_item_group` . `updated_at` as `link_item_group.updatedAt` FROM `link_item_group` WHERE (`link_item_group` . `active` = 1 ); Copy
0.55 ms
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 `sales_channel` `shipping_method.salesChannels` ON `shipping_method.salesChannels.mapping` . `sales_channel_id` = `shipping_method.salesChannels` . `id` WHERE (`shipping_method.salesChannels` . `id` = ? AND `shipping_method` . `id` = ? ) LIMIT 1
Parameters :
[
b"\x01 ’µ8öEr²ªÍW«a$LH\x01 ÆÁ8hÂpH¿½█&Õ║¢ì ]
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 `sales_channel` `shipping_method.salesChannels` ON `shipping_method.salesChannels.mapping` . `sales_channel_id` = `shipping_method.salesChannels` . `id` WHERE (`shipping_method.salesChannels` . `id` = 0x0192B538F64572B2AACD57AB61244C48 AND `shipping_method` . `id` = 0x0192B53868B67048A8ABDB26E5BABD8D ) LIMIT 1 ; Copy
0.55 ms
1
SELECT `salutation` . `id` as `salutation.id` , `salutation` . `salutation_key` as `salutation.salutationKey` , `salutation` . `created_at` as `salutation.createdAt` , `salutation` . `updated_at` as `salutation.updatedAt` , `salutation.translation.displayName` , `salutation.translation.displayName` as `salutation.displayName` , `salutation.translation.letterName` , `salutation.translation.letterName` as `salutation.letterName` , `salutation.translation.customFields` , `salutation.translation.customFields` as `salutation.customFields` FROM `salutation` LEFT JOIN (SELECT `salutation.translation` . `salutation_id` , `salutation.translation` . `display_name` as `salutation.translation.displayName` , `salutation.translation` . `letter_name` as `salutation.translation.letterName` , `salutation.translation` . `custom_fields` as `salutation.translation.customFields` FROM `salutation_translation` `salutation.translation` WHERE `salutation.translation` . `language_id` = ? ) `salutation.salutation_translation` ON `salutation.salutation_translation` . `salutation_id` = `salutation` . `id`
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `salutation` . `id` as `salutation.id` , `salutation` . `salutation_key` as `salutation.salutationKey` , `salutation` . `created_at` as `salutation.createdAt` , `salutation` . `updated_at` as `salutation.updatedAt` , `salutation.translation.displayName` , `salutation.translation.displayName` as `salutation.displayName` , `salutation.translation.letterName` , `salutation.translation.letterName` as `salutation.letterName` , `salutation.translation.customFields` , `salutation.translation.customFields` as `salutation.customFields` FROM `salutation` LEFT JOIN (SELECT `salutation.translation` . `salutation_id` , `salutation.translation` . `display_name` as `salutation.translation.displayName` , `salutation.translation` . `letter_name` as `salutation.translation.letterName` , `salutation.translation` . `custom_fields` as `salutation.translation.customFields` FROM `salutation_translation` `salutation.translation` WHERE `salutation.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `salutation.salutation_translation` ON `salutation.salutation_translation` . `salutation_id` = `salutation` . `id` ; Copy
0.49 ms
1
SELECT `name` , `path` , `author`
FROM `app`
WHERE `active` = 1
SELECT `name` , `path` , `author`
FROM `app`
WHERE `active` = 1
; Copy
0.45 ms
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 ;
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 ;
; Copy
0.45 ms
1
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Í‚ó¬›ÑÀßÊ "
]
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` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `currency.currency_translation` ON `currency.currency_translation` . `currency_id` = `currency` . `id` WHERE `currency` . `id` IN (0xB7D2554B0CE847CD82F3AC9BD1C0DFCA ); Copy
0.45 ms
1
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 ’µ8öEr²ªÍW«a$LH/checkout/cart "
]
SELECT path_info pathInfo , seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (sales_channel_id = 0x0192B538F64572B2AACD57AB61244C48 ) AND (path_info = '/checkout/cart' ) AND (is_canonical = 1 ) LIMIT 1 ;
Copy
0.42 ms
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"\x01 ’µ9"®s¦¡AÿÑmýsý ]
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` = 0x0192B53922AE73A6A141FFD16DFD73FD AND
pm . `active` = 1 ; Copy
0.41 ms
1
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = ?
Parameters :
[
"hl3ZJDexNsPSaicgztkRiqfRx0cjOcSP "
]
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = 'hl3ZJDexNsPSaicgztkRiqfRx0cjOcSP' ;
Copy
0.37 ms
1
SELECT `language` . `id` FROM `language` WHERE `language` . `id` IN (? ) LIMIT 1
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `language` . `id` FROM `language` WHERE `language` . `id` IN (0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) LIMIT 1 ; Copy
0.35 ms
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.salesChannels` . `id` = ? AND `payment_method` . `id` = ? ) LIMIT 1
Parameters :
[
b"\x01 ’µ8öEr²ªÍW«a$LH\x01 ’µ8h’s\x07 °¬¡•›R/à ]
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.salesChannels` . `id` = 0x0192B538F64572B2AACD57AB61244C48 AND `payment_method` . `id` = 0x0192B53868927307B0ACA1959B522FC3 ) LIMIT 1 ; Copy
0.17 ms
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' , '' ))
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' , '' )); Copy