2.05 ms
3
SELECT `app` . `id` as `app.id` , `app` . `name` as `app.name` , `app` . `path` as `app.path` , `app` . `author` as `app.author` , `app` . `copyright` as `app.copyright` , `app` . `license` as `app.license` , `app` . `active` as `app.active` , `app` . `configurable` as `app.configurable` , `app` . `privacy` as `app.privacy` , `app` . `version` as `app.version` , `app` . `icon` as `app.iconRaw` , `app` . `app_secret` as `app.appSecret` , `app` . `modules` as `app.modules` , `app` . `main_module` as `app.mainModule` , `app` . `cookies` as `app.cookies` , `app` . `allow_disable` as `app.allowDisable` , `app` . `base_app_url` as `app.baseAppUrl` , `app` . `allowed_hosts` as `app.allowedHosts` , `app` . `template_load_priority` as `app.templateLoadPriority` , `app` . `checkout_gateway_url` as `app.checkoutGatewayUrl` , `app` . `in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl` , `app` . `source_type` as `app.sourceType` , `app` . `source_config` as `app.sourceConfig` , `app` . `self_managed` as `app.selfManaged` , `app` . `integration_id` as `app.integrationId` , `app.integration` . `id` as `app.integration.id` , `app.integration` . `label` as `app.integration.label` , `app.integration` . `access_key` as `app.integration.accessKey` , `app.integration` . `secret_access_key` as `app.integration.secretAccessKey` , `app.integration` . `last_usage_at` as `app.integration.lastUsageAt` , `app.integration` . `admin` as `app.integration.admin` , `app.integration` . `custom_fields` as `app.integration.customFields` , `app.integration` . `deleted_at` as `app.integration.deletedAt` , `app.integration` . `created_at` as `app.integration.createdAt` , `app.integration` . `updated_at` as `app.integration.updatedAt` , `app` . `acl_role_id` as `app.aclRoleId` , `app.aclRole` . `id` as `app.aclRole.id` , `app.aclRole` . `name` as `app.aclRole.name` , `app.aclRole` . `description` as `app.aclRole.description` , `app.aclRole` . `privileges` as `app.aclRole.privileges` , `app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` , `app.aclRole` . `created_at` as `app.aclRole.createdAt` , `app.aclRole` . `updated_at` as `app.aclRole.updatedAt` , `app` . `created_at` as `app.createdAt` , `app` . `updated_at` as `app.updatedAt` , `app.translation.label` , `app.translation.label` as `app.label` , `app.translation.description` , `app.translation.description` as `app.description` , `app.translation.privacyPolicyExtensions` , `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions` , `app.translation.customFields` , `app.translation.customFields` as `app.customFields` FROM `app` LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id` LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id` LEFT JOIN (SELECT `app.translation` . `app_id` , `app.translation` . `label` as `app.translation.label` , `app.translation` . `description` as `app.translation.description` , `app.translation` . `privacy_policy_extensions` as `app.translation.privacyPolicyExtensions` , `app.translation` . `custom_fields` as `app.translation.customFields` FROM `app_translation` `app.translation` WHERE `app.translation` . `language_id` = ? ) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id` WHERE `app` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 ‹®u*\x01 rå¸\x06 @h%Ze1 ]
SELECT
`app` . `id` as `app.id` ,
`app` . `name` as `app.name` ,
`app` . `path` as `app.path` ,
`app` . `author` as `app.author` ,
`app` . `copyright` as `app.copyright` ,
`app` . `license` as `app.license` ,
`app` . `active` as `app.active` ,
`app` . `configurable` as `app.configurable` ,
`app` . `privacy` as `app.privacy` ,
`app` . `version` as `app.version` ,
`app` . `icon` as `app.iconRaw` ,
`app` . `app_secret` as `app.appSecret` ,
`app` . `modules` as `app.modules` ,
`app` . `main_module` as `app.mainModule` ,
`app` . `cookies` as `app.cookies` ,
`app` . `allow_disable` as `app.allowDisable` ,
`app` . `base_app_url` as `app.baseAppUrl` ,
`app` . `allowed_hosts` as `app.allowedHosts` ,
`app` . `template_load_priority` as `app.templateLoadPriority` ,
`app` . `checkout_gateway_url` as `app.checkoutGatewayUrl` ,
`app` . `in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl` ,
`app` . `source_type` as `app.sourceType` ,
`app` . `source_config` as `app.sourceConfig` ,
`app` . `self_managed` as `app.selfManaged` ,
`app` . `integration_id` as `app.integrationId` ,
`app.integration` . `id` as `app.integration.id` ,
`app.integration` . `label` as `app.integration.label` ,
`app.integration` . `access_key` as `app.integration.accessKey` ,
`app.integration` . `secret_access_key` as `app.integration.secretAccessKey` ,
`app.integration` . `last_usage_at` as `app.integration.lastUsageAt` ,
`app.integration` . `admin` as `app.integration.admin` ,
`app.integration` . `custom_fields` as `app.integration.customFields` ,
`app.integration` . `deleted_at` as `app.integration.deletedAt` ,
`app.integration` . `created_at` as `app.integration.createdAt` ,
`app.integration` . `updated_at` as `app.integration.updatedAt` ,
`app` . `acl_role_id` as `app.aclRoleId` ,
`app.aclRole` . `id` as `app.aclRole.id` ,
`app.aclRole` . `name` as `app.aclRole.name` ,
`app.aclRole` . `description` as `app.aclRole.description` ,
`app.aclRole` . `privileges` as `app.aclRole.privileges` ,
`app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` ,
`app.aclRole` . `created_at` as `app.aclRole.createdAt` ,
`app.aclRole` . `updated_at` as `app.aclRole.updatedAt` ,
`app` . `created_at` as `app.createdAt` ,
`app` . `updated_at` as `app.updatedAt` ,
`app.translation.label` ,
`app.translation.label` as `app.label` ,
`app.translation.description` ,
`app.translation.description` as `app.description` ,
`app.translation.privacyPolicyExtensions` ,
`app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions` ,
`app.translation.customFields` ,
`app.translation.customFields` as `app.customFields`
FROM
`app`
LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id`
LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id`
LEFT JOIN (
SELECT
`app.translation` . `app_id` ,
`app.translation` . `label` as `app.translation.label` ,
`app.translation` . `description` as `app.translation.description` ,
`app.translation` . `privacy_policy_extensions` as `app.translation.privacyPolicyExtensions` ,
`app.translation` . `custom_fields` as `app.translation.customFields`
FROM
`app_translation` `app.translation`
WHERE
`app.translation` . `language_id` = ?
) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id`
WHERE
`app` . `id` IN (? )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` . `in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl` , `app` . `source_type` as `app.sourceType` , `app` . `source_config` as `app.sourceConfig` , `app` . `self_managed` as `app.selfManaged` , `app` . `integration_id` as `app.integrationId` , `app.integration` . `id` as `app.integration.id` , `app.integration` . `label` as `app.integration.label` , `app.integration` . `access_key` as `app.integration.accessKey` , `app.integration` . `secret_access_key` as `app.integration.secretAccessKey` , `app.integration` . `last_usage_at` as `app.integration.lastUsageAt` , `app.integration` . `admin` as `app.integration.admin` , `app.integration` . `custom_fields` as `app.integration.customFields` , `app.integration` . `deleted_at` as `app.integration.deletedAt` , `app.integration` . `created_at` as `app.integration.createdAt` , `app.integration` . `updated_at` as `app.integration.updatedAt` , `app` . `acl_role_id` as `app.aclRoleId` , `app.aclRole` . `id` as `app.aclRole.id` , `app.aclRole` . `name` as `app.aclRole.name` , `app.aclRole` . `description` as `app.aclRole.description` , `app.aclRole` . `privileges` as `app.aclRole.privileges` , `app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` , `app.aclRole` . `created_at` as `app.aclRole.createdAt` , `app.aclRole` . `updated_at` as `app.aclRole.updatedAt` , `app` . `created_at` as `app.createdAt` , `app` . `updated_at` as `app.updatedAt` , `app.translation.label` , `app.translation.label` as `app.label` , `app.translation.description` , `app.translation.description` as `app.description` , `app.translation.privacyPolicyExtensions` , `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions` , `app.translation.customFields` , `app.translation.customFields` as `app.customFields` FROM `app` LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id` LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id` LEFT JOIN (SELECT `app.translation` . `app_id` , `app.translation` . `label` as `app.translation.label` , `app.translation` . `description` as `app.translation.description` , `app.translation` . `privacy_policy_extensions` as `app.translation.privacyPolicyExtensions` , `app.translation` . `custom_fields` as `app.translation.customFields` FROM `app_translation` `app.translation` WHERE `app.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id` WHERE `app` . `id` IN (0x018BAE752A0172E5B8064068255A6531 ); Copy
1.73 ms
1
SELECT `id` , `old_url` , `new_url` , `old_url_regex` , `search_url_by` , `temporary` , ? REGEXP `old_url_regex` as regex0 , ? REGEXP `old_url_regex` as regex2 , ? REGEXP `old_url_regex` as regex3 FROM `acris_seo_redirect` WHERE `active` = ? AND ((NOT (`search_url_by` = ? ) AND ((`old_url` = ? OR `old_url` = ? OR `old_url` = ? ))) OR (`search_url_by` = ? AND ((? REGEXP `old_url_regex` OR ? REGEXP `old_url_regex` OR ? REGEXP `old_url_regex` )))) LIMIT 6 ;
Parameters :
[
"/garage "
"https://dev2.bartek.426.agency/garage "
"dev2.bartek.426.agency/garage "
1
"regex "
"/garage "
"https://dev2.bartek.426.agency/garage "
"dev2.bartek.426.agency/garage "
"regex "
"/garage "
"https://dev2.bartek.426.agency/garage "
"dev2.bartek.426.agency/garage "
]
SELECT `id` , `old_url` , `new_url` , `old_url_regex` , `search_url_by` , `temporary` , '/garage' REGEXP `old_url_regex` as regex0 , 'https://dev2.bartek.426.agency/garage' REGEXP `old_url_regex` as regex2 , 'dev2.bartek.426.agency/garage' REGEXP `old_url_regex` as regex3 FROM `acris_seo_redirect` WHERE `active` = 1 AND ((NOT (`search_url_by` = 'regex' ) AND ((`old_url` = '/garage' OR `old_url` = 'https://dev2.bartek.426.agency/garage' OR `old_url` = 'dev2.bartek.426.agency/garage' ))) OR (`search_url_by` = 'regex' AND (('/garage' REGEXP `old_url_regex` OR 'https://dev2.bartek.426.agency/garage' REGEXP `old_url_regex` OR 'dev2.bartek.426.agency/garage' REGEXP `old_url_regex` )))) LIMIT 6 ; ; Copy
1.61 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.media` . `id` as `payment_method.media.id` , `payment_method.media` . `user_id` as `payment_method.media.userId` , `payment_method.media` . `media_folder_id` as `payment_method.media.mediaFolderId` , `payment_method.media` . `mime_type` as `payment_method.media.mimeType` , `payment_method.media` . `file_extension` as `payment_method.media.fileExtension` , `payment_method.media` . `uploaded_at` as `payment_method.media.uploadedAt` , `payment_method.media` . `file_name` as `payment_method.media.fileName` , `payment_method.media` . `file_size` as `payment_method.media.fileSize` , `payment_method.media` . `media_type` as `payment_method.media.mediaTypeRaw` , `payment_method.media` . `meta_data` as `payment_method.media.metaData` , `payment_method.media` . `config` as `payment_method.media.config` , `payment_method.media` . `path` as `payment_method.media.path` , `payment_method.media` . `private` as `payment_method.media.private` , `payment_method.media` . `thumbnails_ro` as `payment_method.media.thumbnailsRo` , `payment_method.media` . `created_at` as `payment_method.media.createdAt` , `payment_method.media` . `updated_at` as `payment_method.media.updatedAt` , `payment_method.media.translation.override_1.title` , `payment_method.media.translation.title` , COALESCE (`payment_method.media.translation.override_1.title` , `payment_method.media.translation.title` ) as `payment_method.media.title` , `payment_method.media.translation.override_1.alt` , `payment_method.media.translation.alt` , COALESCE (`payment_method.media.translation.override_1.alt` , `payment_method.media.translation.alt` ) as `payment_method.media.alt` , `payment_method.media.translation.override_1.customFields` , `payment_method.media.translation.customFields` , COALESCE (`payment_method.media.translation.override_1.customFields` , `payment_method.media.translation.customFields` ) as `payment_method.media.customFields` , `payment_method.translation.override_1.name` , `payment_method.translation.name` , COALESCE (`payment_method.translation.override_1.name` , `payment_method.translation.name` ) as `payment_method.name` , `payment_method.translation.override_1.distinguishableName` , `payment_method.translation.distinguishableName` , COALESCE (`payment_method.translation.override_1.distinguishableName` , `payment_method.translation.distinguishableName` ) as `payment_method.distinguishableName` , `payment_method.translation.override_1.description` , `payment_method.translation.description` , COALESCE (`payment_method.translation.override_1.description` , `payment_method.translation.description` ) as `payment_method.description` , `payment_method.translation.override_1.customFields` , `payment_method.translation.customFields` , COALESCE (`payment_method.translation.override_1.customFields` , `payment_method.translation.customFields` ) as `payment_method.customFields` FROM `payment_method` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method` . `id` = `payment_method.appPaymentMethod` . `payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method` . `media_id` = `payment_method.media` . `id` LEFT JOIN (SELECT `payment_method.translation` . `payment_method_id` , `payment_method.translation` . `name` as `payment_method.translation.name` , `payment_method.translation.override_1` . `name` as `payment_method.translation.override_1.name` , `payment_method.translation` . `distinguishable_name` as `payment_method.translation.distinguishableName` , `payment_method.translation.override_1` . `distinguishable_name` as `payment_method.translation.override_1.distinguishableName` , `payment_method.translation` . `description` as `payment_method.translation.description` , `payment_method.translation.override_1` . `description` as `payment_method.translation.override_1.description` , `payment_method.translation` . `custom_fields` as `payment_method.translation.customFields` , `payment_method.translation.override_1` . `custom_fields` as `payment_method.translation.override_1.customFields` FROM `payment_method_translation` `payment_method.translation` LEFT JOIN `payment_method_translation` `payment_method.translation.override_1` ON `payment_method.translation` . `payment_method_id` = `payment_method.translation.override_1` . `payment_method_id` AND `payment_method.translation.override_1` . `language_id` = ? WHERE `payment_method.translation` . `language_id` = ? ) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation` . `payment_method_id` = `payment_method` . `id` LEFT JOIN (SELECT `payment_method.media.translation` . `media_id` , `payment_method.media.translation` . `alt` as `payment_method.media.translation.alt` , `payment_method.media.translation.override_1` . `alt` as `payment_method.media.translation.override_1.alt` , `payment_method.media.translation` . `title` as `payment_method.media.translation.title` , `payment_method.media.translation.override_1` . `title` as `payment_method.media.translation.override_1.title` , `payment_method.media.translation` . `custom_fields` as `payment_method.media.translation.customFields` , `payment_method.media.translation.override_1` . `custom_fields` as `payment_method.media.translation.override_1.customFields` FROM `media_translation` `payment_method.media.translation` LEFT JOIN `media_translation` `payment_method.media.translation.override_1` ON `payment_method.media.translation` . `media_id` = `payment_method.media.translation.override_1` . `media_id` AND `payment_method.media.translation.override_1` . `language_id` = ? WHERE `payment_method.media.translation` . `language_id` = ? ) `payment_method.media.media_translation` ON `payment_method.media.media_translation` . `media_id` = `payment_method.media` . `id` WHERE `payment_method` . `id` IN (? )
Parameters :
[
b"ÞDW\x1D ÜNM\x00 •À\x1A öî)“Q "
b"/»_ââšMpªXTÎ|ãâ\v "
b"ÞDW\x1D ÜNM\x00 •À\x1A öî)“Q "
b"/»_ââšMpªXTÎ|ãâ\v "
b"¦■\x19 6%\H▀À\x06\x1C ╬TTÕÉ "
]
SELECT
`payment_method` . `id` as `payment_method.id` ,
`payment_method` . `plugin_id` as `payment_method.pluginId` ,
`payment_method` . `handler_identifier` as `payment_method.handlerIdentifier` ,
`payment_method` . `position` as `payment_method.position` ,
`payment_method` . `active` as `payment_method.active` ,
`payment_method` . `after_order_enabled` as `payment_method.afterOrderEnabled` ,
`payment_method` . `availability_rule_id` as `payment_method.availabilityRuleId` ,
`payment_method` . `media_id` as `payment_method.mediaId` ,
`payment_method.appPaymentMethod` . `id` as `payment_method.appPaymentMethod.id` ,
`payment_method.appPaymentMethod` . `app_name` as `payment_method.appPaymentMethod.appName` ,
`payment_method.appPaymentMethod` . `identifier` as `payment_method.appPaymentMethod.identifier` ,
`payment_method.appPaymentMethod` . `pay_url` as `payment_method.appPaymentMethod.payUrl` ,
`payment_method.appPaymentMethod` . `finalize_url` as `payment_method.appPaymentMethod.finalizeUrl` ,
`payment_method.appPaymentMethod` . `validate_url` as `payment_method.appPaymentMethod.validateUrl` ,
`payment_method.appPaymentMethod` . `capture_url` as `payment_method.appPaymentMethod.captureUrl` ,
`payment_method.appPaymentMethod` . `refund_url` as `payment_method.appPaymentMethod.refundUrl` ,
`payment_method.appPaymentMethod` . `recurring_url` as `payment_method.appPaymentMethod.recurringUrl` ,
`payment_method.appPaymentMethod` . `app_id` as `payment_method.appPaymentMethod.appId` ,
`payment_method.appPaymentMethod` . `original_media_id` as `payment_method.appPaymentMethod.originalMediaId` ,
`payment_method.appPaymentMethod` . `payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId` ,
`payment_method.appPaymentMethod` . `created_at` as `payment_method.appPaymentMethod.createdAt` ,
`payment_method.appPaymentMethod` . `updated_at` as `payment_method.appPaymentMethod.updatedAt` ,
`payment_method` . `technical_name` as `payment_method.technicalName` ,
`payment_method` . `created_at` as `payment_method.createdAt` ,
`payment_method` . `updated_at` as `payment_method.updatedAt` ,
`payment_method.media` . `id` as `payment_method.media.id` ,
`payment_method.media` . `user_id` as `payment_method.media.userId` ,
`payment_method.media` . `media_folder_id` as `payment_method.media.mediaFolderId` ,
`payment_method.media` . `mime_type` as `payment_method.media.mimeType` ,
`payment_method.media` . `file_extension` as `payment_method.media.fileExtension` ,
`payment_method.media` . `uploaded_at` as `payment_method.media.uploadedAt` ,
`payment_method.media` . `file_name` as `payment_method.media.fileName` ,
`payment_method.media` . `file_size` as `payment_method.media.fileSize` ,
`payment_method.media` . `media_type` as `payment_method.media.mediaTypeRaw` ,
`payment_method.media` . `meta_data` as `payment_method.media.metaData` ,
`payment_method.media` . `config` as `payment_method.media.config` ,
`payment_method.media` . `path` as `payment_method.media.path` ,
`payment_method.media` . `private` as `payment_method.media.private` ,
`payment_method.media` . `thumbnails_ro` as `payment_method.media.thumbnailsRo` ,
`payment_method.media` . `created_at` as `payment_method.media.createdAt` ,
`payment_method.media` . `updated_at` as `payment_method.media.updatedAt` ,
`payment_method.media.translation.override_1.title` ,
`payment_method.media.translation.title` ,
COALESCE (
`payment_method.media.translation.override_1.title` ,
`payment_method.media.translation.title`
) as `payment_method.media.title` ,
`payment_method.media.translation.override_1.alt` ,
`payment_method.media.translation.alt` ,
COALESCE (
`payment_method.media.translation.override_1.alt` ,
`payment_method.media.translation.alt`
) as `payment_method.media.alt` ,
`payment_method.media.translation.override_1.customFields` ,
`payment_method.media.translation.customFields` ,
COALESCE (
`payment_method.media.translation.override_1.customFields` ,
`payment_method.media.translation.customFields`
) as `payment_method.media.customFields` ,
`payment_method.translation.override_1.name` ,
`payment_method.translation.name` ,
COALESCE (
`payment_method.translation.override_1.name` ,
`payment_method.translation.name`
) as `payment_method.name` ,
`payment_method.translation.override_1.distinguishableName` ,
`payment_method.translation.distinguishableName` ,
COALESCE (
`payment_method.translation.override_1.distinguishableName` ,
`payment_method.translation.distinguishableName`
) as `payment_method.distinguishableName` ,
`payment_method.translation.override_1.description` ,
`payment_method.translation.description` ,
COALESCE (
`payment_method.translation.override_1.description` ,
`payment_method.translation.description`
) as `payment_method.description` ,
`payment_method.translation.override_1.customFields` ,
`payment_method.translation.customFields` ,
COALESCE (
`payment_method.translation.override_1.customFields` ,
`payment_method.translation.customFields`
) as `payment_method.customFields`
FROM
`payment_method`
LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method` . `id` = `payment_method.appPaymentMethod` . `payment_method_id`
LEFT JOIN `media` `payment_method.media` ON `payment_method` . `media_id` = `payment_method.media` . `id`
LEFT JOIN (
SELECT
`payment_method.translation` . `payment_method_id` ,
`payment_method.translation` . `name` as `payment_method.translation.name` ,
`payment_method.translation.override_1` . `name` as `payment_method.translation.override_1.name` ,
`payment_method.translation` . `distinguishable_name` as `payment_method.translation.distinguishableName` ,
`payment_method.translation.override_1` . `distinguishable_name` as `payment_method.translation.override_1.distinguishableName` ,
`payment_method.translation` . `description` as `payment_method.translation.description` ,
`payment_method.translation.override_1` . `description` as `payment_method.translation.override_1.description` ,
`payment_method.translation` . `custom_fields` as `payment_method.translation.customFields` ,
`payment_method.translation.override_1` . `custom_fields` as `payment_method.translation.override_1.customFields`
FROM
`payment_method_translation` `payment_method.translation`
LEFT JOIN `payment_method_translation` `payment_method.translation.override_1` ON `payment_method.translation` . `payment_method_id` = `payment_method.translation.override_1` . `payment_method_id`
AND `payment_method.translation.override_1` . `language_id` = ?
WHERE
`payment_method.translation` . `language_id` = ?
) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation` . `payment_method_id` = `payment_method` . `id`
LEFT JOIN (
SELECT
`payment_method.media.translation` . `media_id` ,
`payment_method.media.translation` . `alt` as `payment_method.media.translation.alt` ,
`payment_method.media.translation.override_1` . `alt` as `payment_method.media.translation.override_1.alt` ,
`payment_method.media.translation` . `title` as `payment_method.media.translation.title` ,
`payment_method.media.translation.override_1` . `title` as `payment_method.media.translation.override_1.title` ,
`payment_method.media.translation` . `custom_fields` as `payment_method.media.translation.customFields` ,
`payment_method.media.translation.override_1` . `custom_fields` as `payment_method.media.translation.override_1.customFields`
FROM
`media_translation` `payment_method.media.translation`
LEFT JOIN `media_translation` `payment_method.media.translation.override_1` ON `payment_method.media.translation` . `media_id` = `payment_method.media.translation.override_1` . `media_id`
AND `payment_method.media.translation.override_1` . `language_id` = ?
WHERE
`payment_method.media.translation` . `language_id` = ?
) `payment_method.media.media_translation` ON `payment_method.media.media_translation` . `media_id` = `payment_method.media` . `id`
WHERE
`payment_method` . `id` IN (? )
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.media` . `id` as `payment_method.media.id` , `payment_method.media` . `user_id` as `payment_method.media.userId` , `payment_method.media` . `media_folder_id` as `payment_method.media.mediaFolderId` , `payment_method.media` . `mime_type` as `payment_method.media.mimeType` , `payment_method.media` . `file_extension` as `payment_method.media.fileExtension` , `payment_method.media` . `uploaded_at` as `payment_method.media.uploadedAt` , `payment_method.media` . `file_name` as `payment_method.media.fileName` , `payment_method.media` . `file_size` as `payment_method.media.fileSize` , `payment_method.media` . `media_type` as `payment_method.media.mediaTypeRaw` , `payment_method.media` . `meta_data` as `payment_method.media.metaData` , `payment_method.media` . `config` as `payment_method.media.config` , `payment_method.media` . `path` as `payment_method.media.path` , `payment_method.media` . `private` as `payment_method.media.private` , `payment_method.media` . `thumbnails_ro` as `payment_method.media.thumbnailsRo` , `payment_method.media` . `created_at` as `payment_method.media.createdAt` , `payment_method.media` . `updated_at` as `payment_method.media.updatedAt` , `payment_method.media.translation.override_1.title` , `payment_method.media.translation.title` , COALESCE (`payment_method.media.translation.override_1.title` , `payment_method.media.translation.title` ) as `payment_method.media.title` , `payment_method.media.translation.override_1.alt` , `payment_method.media.translation.alt` , COALESCE (`payment_method.media.translation.override_1.alt` , `payment_method.media.translation.alt` ) as `payment_method.media.alt` , `payment_method.media.translation.override_1.customFields` , `payment_method.media.translation.customFields` , COALESCE (`payment_method.media.translation.override_1.customFields` , `payment_method.media.translation.customFields` ) as `payment_method.media.customFields` , `payment_method.translation.override_1.name` , `payment_method.translation.name` , COALESCE (`payment_method.translation.override_1.name` , `payment_method.translation.name` ) as `payment_method.name` , `payment_method.translation.override_1.distinguishableName` , `payment_method.translation.distinguishableName` , COALESCE (`payment_method.translation.override_1.distinguishableName` , `payment_method.translation.distinguishableName` ) as `payment_method.distinguishableName` , `payment_method.translation.override_1.description` , `payment_method.translation.description` , COALESCE (`payment_method.translation.override_1.description` , `payment_method.translation.description` ) as `payment_method.description` , `payment_method.translation.override_1.customFields` , `payment_method.translation.customFields` , COALESCE (`payment_method.translation.override_1.customFields` , `payment_method.translation.customFields` ) as `payment_method.customFields` FROM `payment_method` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method` . `id` = `payment_method.appPaymentMethod` . `payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method` . `media_id` = `payment_method.media` . `id` LEFT JOIN (SELECT `payment_method.translation` . `payment_method_id` , `payment_method.translation` . `name` as `payment_method.translation.name` , `payment_method.translation.override_1` . `name` as `payment_method.translation.override_1.name` , `payment_method.translation` . `distinguishable_name` as `payment_method.translation.distinguishableName` , `payment_method.translation.override_1` . `distinguishable_name` as `payment_method.translation.override_1.distinguishableName` , `payment_method.translation` . `description` as `payment_method.translation.description` , `payment_method.translation.override_1` . `description` as `payment_method.translation.override_1.description` , `payment_method.translation` . `custom_fields` as `payment_method.translation.customFields` , `payment_method.translation.override_1` . `custom_fields` as `payment_method.translation.override_1.customFields` FROM `payment_method_translation` `payment_method.translation` LEFT JOIN `payment_method_translation` `payment_method.translation.override_1` ON `payment_method.translation` . `payment_method_id` = `payment_method.translation.override_1` . `payment_method_id` AND `payment_method.translation.override_1` . `language_id` = 0xDE44571DDC4E4D0095C01AF6EE299351 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.media.translation` . `media_id` , `payment_method.media.translation` . `alt` as `payment_method.media.translation.alt` , `payment_method.media.translation.override_1` . `alt` as `payment_method.media.translation.override_1.alt` , `payment_method.media.translation` . `title` as `payment_method.media.translation.title` , `payment_method.media.translation.override_1` . `title` as `payment_method.media.translation.override_1.title` , `payment_method.media.translation` . `custom_fields` as `payment_method.media.translation.customFields` , `payment_method.media.translation.override_1` . `custom_fields` as `payment_method.media.translation.override_1.customFields` FROM `media_translation` `payment_method.media.translation` LEFT JOIN `media_translation` `payment_method.media.translation.override_1` ON `payment_method.media.translation` . `media_id` = `payment_method.media.translation.override_1` . `media_id` AND `payment_method.media.translation.override_1` . `language_id` = 0xDE44571DDC4E4D0095C01AF6EE299351 WHERE `payment_method.media.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `payment_method.media.media_translation` ON `payment_method.media.media_translation` . `media_id` = `payment_method.media` . `id` WHERE `payment_method` . `id` IN (0xDDFE1936255C48DFB7061CCE5454E590 );
Copy
1.39 ms
1
SELECT configuration_key , configuration_value FROM system_config WHERE sales_channel_id = ? OR system_config . sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters :
[
b"¼\x03 ±/ÊnDl›¾sZáôÐÎ "
]
SELECT configuration_key , configuration_value FROM system_config WHERE sales_channel_id = 0xBC03B12FCA6E446C9BBE735AE1F4D0CE OR system_config . sales_channel_id IS NULL ORDER BY sales_channel_id ASC ; Copy
1.37 ms
1
SELECT configuration_key , configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
SELECT configuration_key , configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC ; Copy
1.37 ms
1
SELECT `shipping_method` . `id` as `shipping_method.id` , `shipping_method` . `active` as `shipping_method.active` , `shipping_method` . `position` as `shipping_method.position` , `shipping_method` . `availability_rule_id` as `shipping_method.availabilityRuleId` , `shipping_method` . `media_id` as `shipping_method.mediaId` , `shipping_method` . `delivery_time_id` as `shipping_method.deliveryTimeId` , `shipping_method` . `tax_type` as `shipping_method.taxType` , `shipping_method` . `tax_id` as `shipping_method.taxId` , `shipping_method.deliveryTime` . `id` as `shipping_method.deliveryTime.id` , `shipping_method.deliveryTime` . `min` as `shipping_method.deliveryTime.min` , `shipping_method.deliveryTime` . `max` as `shipping_method.deliveryTime.max` , `shipping_method.deliveryTime` . `unit` as `shipping_method.deliveryTime.unit` , `shipping_method.deliveryTime` . `created_at` as `shipping_method.deliveryTime.createdAt` , `shipping_method.deliveryTime` . `updated_at` as `shipping_method.deliveryTime.updatedAt` , `shipping_method.deliveryTime.translation.override_1.name` , `shipping_method.deliveryTime.translation.name` , COALESCE (`shipping_method.deliveryTime.translation.override_1.name` , `shipping_method.deliveryTime.translation.name` ) as `shipping_method.deliveryTime.name` , `shipping_method.deliveryTime.translation.override_1.customFields` , `shipping_method.deliveryTime.translation.customFields` , COALESCE (`shipping_method.deliveryTime.translation.override_1.customFields` , `shipping_method.deliveryTime.translation.customFields` ) as `shipping_method.deliveryTime.customFields` , `shipping_method.appShippingMethod` . `id` as `shipping_method.appShippingMethod.id` , `shipping_method.appShippingMethod` . `app_name` as `shipping_method.appShippingMethod.appName` , `shipping_method.appShippingMethod` . `identifier` as `shipping_method.appShippingMethod.identifier` , `shipping_method.appShippingMethod` . `app_id` as `shipping_method.appShippingMethod.appId` , `shipping_method.appShippingMethod` . `shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId` , `shipping_method.appShippingMethod` . `original_media_id` as `shipping_method.appShippingMethod.originalMediaId` , `shipping_method.appShippingMethod` . `created_at` as `shipping_method.appShippingMethod.createdAt` , `shipping_method.appShippingMethod` . `updated_at` as `shipping_method.appShippingMethod.updatedAt` , `shipping_method` . `technical_name` as `shipping_method.technicalName` , `shipping_method` . `created_at` as `shipping_method.createdAt` , `shipping_method` . `updated_at` as `shipping_method.updatedAt` , `shipping_method.media` . `id` as `shipping_method.media.id` , `shipping_method.media` . `user_id` as `shipping_method.media.userId` , `shipping_method.media` . `media_folder_id` as `shipping_method.media.mediaFolderId` , `shipping_method.media` . `mime_type` as `shipping_method.media.mimeType` , `shipping_method.media` . `file_extension` as `shipping_method.media.fileExtension` , `shipping_method.media` . `uploaded_at` as `shipping_method.media.uploadedAt` , `shipping_method.media` . `file_name` as `shipping_method.media.fileName` , `shipping_method.media` . `file_size` as `shipping_method.media.fileSize` , `shipping_method.media` . `media_type` as `shipping_method.media.mediaTypeRaw` , `shipping_method.media` . `meta_data` as `shipping_method.media.metaData` , `shipping_method.media` . `config` as `shipping_method.media.config` , `shipping_method.media` . `path` as `shipping_method.media.path` , `shipping_method.media` . `private` as `shipping_method.media.private` , `shipping_method.media` . `thumbnails_ro` as `shipping_method.media.thumbnailsRo` , `shipping_method.media` . `created_at` as `shipping_method.media.createdAt` , `shipping_method.media` . `updated_at` as `shipping_method.media.updatedAt` , `shipping_method.media.translation.override_1.title` , `shipping_method.media.translation.title` , COALESCE (`shipping_method.media.translation.override_1.title` , `shipping_method.media.translation.title` ) as `shipping_method.media.title` , `shipping_method.media.translation.override_1.alt` , `shipping_method.media.translation.alt` , COALESCE (`shipping_method.media.translation.override_1.alt` , `shipping_method.media.translation.alt` ) as `shipping_method.media.alt` , `shipping_method.media.translation.override_1.customFields` , `shipping_method.media.translation.customFields` , COALESCE (`shipping_method.media.translation.override_1.customFields` , `shipping_method.media.translation.customFields` ) as `shipping_method.media.customFields` , `shipping_method.translation.override_1.name` , `shipping_method.translation.name` , COALESCE (`shipping_method.translation.override_1.name` , `shipping_method.translation.name` ) as `shipping_method.name` , `shipping_method.translation.override_1.description` , `shipping_method.translation.description` , COALESCE (`shipping_method.translation.override_1.description` , `shipping_method.translation.description` ) as `shipping_method.description` , `shipping_method.translation.override_1.trackingUrl` , `shipping_method.translation.trackingUrl` , COALESCE (`shipping_method.translation.override_1.trackingUrl` , `shipping_method.translation.trackingUrl` ) as `shipping_method.trackingUrl` , `shipping_method.translation.override_1.customFields` , `shipping_method.translation.customFields` , COALESCE (`shipping_method.translation.override_1.customFields` , `shipping_method.translation.customFields` ) as `shipping_method.customFields` FROM `shipping_method` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method` . `delivery_time_id` = `shipping_method.deliveryTime` . `id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method` . `id` = `shipping_method.appShippingMethod` . `shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method` . `media_id` = `shipping_method.media` . `id` LEFT JOIN (SELECT `shipping_method.translation` . `shipping_method_id` , `shipping_method.translation` . `name` as `shipping_method.translation.name` , `shipping_method.translation.override_1` . `name` as `shipping_method.translation.override_1.name` , `shipping_method.translation` . `custom_fields` as `shipping_method.translation.customFields` , `shipping_method.translation.override_1` . `custom_fields` as `shipping_method.translation.override_1.customFields` , `shipping_method.translation` . `description` as `shipping_method.translation.description` , `shipping_method.translation.override_1` . `description` as `shipping_method.translation.override_1.description` , `shipping_method.translation` . `tracking_url` as `shipping_method.translation.trackingUrl` , `shipping_method.translation.override_1` . `tracking_url` as `shipping_method.translation.override_1.trackingUrl` FROM `shipping_method_translation` `shipping_method.translation` LEFT JOIN `shipping_method_translation` `shipping_method.translation.override_1` ON `shipping_method.translation` . `shipping_method_id` = `shipping_method.translation.override_1` . `shipping_method_id` AND `shipping_method.translation.override_1` . `language_id` = ? WHERE `shipping_method.translation` . `language_id` = ? ) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation` . `shipping_method_id` = `shipping_method` . `id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation` . `delivery_time_id` , `shipping_method.deliveryTime.translation` . `name` as `shipping_method.deliveryTime.translation.name` , `shipping_method.deliveryTime.translation.override_1` . `name` as `shipping_method.deliveryTime.translation.override_1.name` , `shipping_method.deliveryTime.translation` . `custom_fields` as `shipping_method.deliveryTime.translation.customFields` , `shipping_method.deliveryTime.translation.override_1` . `custom_fields` as `shipping_method.deliveryTime.translation.override_1.customFields` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` LEFT JOIN `delivery_time_translation` `shipping_method.deliveryTime.translation.override_1` ON `shipping_method.deliveryTime.translation` . `delivery_time_id` = `shipping_method.deliveryTime.translation.override_1` . `delivery_time_id` AND `shipping_method.deliveryTime.translation.override_1` . `language_id` = ? WHERE `shipping_method.deliveryTime.translation` . `language_id` = ? ) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation` . `delivery_time_id` = `shipping_method.deliveryTime` . `id` LEFT JOIN (SELECT `shipping_method.media.translation` . `media_id` , `shipping_method.media.translation` . `alt` as `shipping_method.media.translation.alt` , `shipping_method.media.translation.override_1` . `alt` as `shipping_method.media.translation.override_1.alt` , `shipping_method.media.translation` . `title` as `shipping_method.media.translation.title` , `shipping_method.media.translation.override_1` . `title` as `shipping_method.media.translation.override_1.title` , `shipping_method.media.translation` . `custom_fields` as `shipping_method.media.translation.customFields` , `shipping_method.media.translation.override_1` . `custom_fields` as `shipping_method.media.translation.override_1.customFields` FROM `media_translation` `shipping_method.media.translation` LEFT JOIN `media_translation` `shipping_method.media.translation.override_1` ON `shipping_method.media.translation` . `media_id` = `shipping_method.media.translation.override_1` . `media_id` AND `shipping_method.media.translation.override_1` . `language_id` = ? WHERE `shipping_method.media.translation` . `language_id` = ? ) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation` . `media_id` = `shipping_method.media` . `id` WHERE `shipping_method` . `id` IN (? )
Parameters :
[
b"ÞDW\x1D ÜNM\x00 •À\x1A öî)“Q "
b"/»_ââšMpªXTÎ|ãâ\v "
b"ÞDW\x1D ÜNM\x00 •À\x1A öî)“Q "
b"/»_ââšMpªXTÎ|ãâ\v "
b"ÞDW\x1D ÜNM\x00 •À\x1A öî)“Q "
b"/»_ââšMpªXTÎ|ãâ\v "
b"""
ñü—f=ÜE¦B\n
{±•
"""
]
SELECT
`shipping_method` . `id` as `shipping_method.id` ,
`shipping_method` . `active` as `shipping_method.active` ,
`shipping_method` . `position` as `shipping_method.position` ,
`shipping_method` . `availability_rule_id` as `shipping_method.availabilityRuleId` ,
`shipping_method` . `media_id` as `shipping_method.mediaId` ,
`shipping_method` . `delivery_time_id` as `shipping_method.deliveryTimeId` ,
`shipping_method` . `tax_type` as `shipping_method.taxType` ,
`shipping_method` . `tax_id` as `shipping_method.taxId` ,
`shipping_method.deliveryTime` . `id` as `shipping_method.deliveryTime.id` ,
`shipping_method.deliveryTime` . `min` as `shipping_method.deliveryTime.min` ,
`shipping_method.deliveryTime` . `max` as `shipping_method.deliveryTime.max` ,
`shipping_method.deliveryTime` . `unit` as `shipping_method.deliveryTime.unit` ,
`shipping_method.deliveryTime` . `created_at` as `shipping_method.deliveryTime.createdAt` ,
`shipping_method.deliveryTime` . `updated_at` as `shipping_method.deliveryTime.updatedAt` ,
`shipping_method.deliveryTime.translation.override_1.name` ,
`shipping_method.deliveryTime.translation.name` ,
COALESCE (
`shipping_method.deliveryTime.translation.override_1.name` ,
`shipping_method.deliveryTime.translation.name`
) as `shipping_method.deliveryTime.name` ,
`shipping_method.deliveryTime.translation.override_1.customFields` ,
`shipping_method.deliveryTime.translation.customFields` ,
COALESCE (
`shipping_method.deliveryTime.translation.override_1.customFields` ,
`shipping_method.deliveryTime.translation.customFields`
) as `shipping_method.deliveryTime.customFields` ,
`shipping_method.appShippingMethod` . `id` as `shipping_method.appShippingMethod.id` ,
`shipping_method.appShippingMethod` . `app_name` as `shipping_method.appShippingMethod.appName` ,
`shipping_method.appShippingMethod` . `identifier` as `shipping_method.appShippingMethod.identifier` ,
`shipping_method.appShippingMethod` . `app_id` as `shipping_method.appShippingMethod.appId` ,
`shipping_method.appShippingMethod` . `shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId` ,
`shipping_method.appShippingMethod` . `original_media_id` as `shipping_method.appShippingMethod.originalMediaId` ,
`shipping_method.appShippingMethod` . `created_at` as `shipping_method.appShippingMethod.createdAt` ,
`shipping_method.appShippingMethod` . `updated_at` as `shipping_method.appShippingMethod.updatedAt` ,
`shipping_method` . `technical_name` as `shipping_method.technicalName` ,
`shipping_method` . `created_at` as `shipping_method.createdAt` ,
`shipping_method` . `updated_at` as `shipping_method.updatedAt` ,
`shipping_method.media` . `id` as `shipping_method.media.id` ,
`shipping_method.media` . `user_id` as `shipping_method.media.userId` ,
`shipping_method.media` . `media_folder_id` as `shipping_method.media.mediaFolderId` ,
`shipping_method.media` . `mime_type` as `shipping_method.media.mimeType` ,
`shipping_method.media` . `file_extension` as `shipping_method.media.fileExtension` ,
`shipping_method.media` . `uploaded_at` as `shipping_method.media.uploadedAt` ,
`shipping_method.media` . `file_name` as `shipping_method.media.fileName` ,
`shipping_method.media` . `file_size` as `shipping_method.media.fileSize` ,
`shipping_method.media` . `media_type` as `shipping_method.media.mediaTypeRaw` ,
`shipping_method.media` . `meta_data` as `shipping_method.media.metaData` ,
`shipping_method.media` . `config` as `shipping_method.media.config` ,
`shipping_method.media` . `path` as `shipping_method.media.path` ,
`shipping_method.media` . `private` as `shipping_method.media.private` ,
`shipping_method.media` . `thumbnails_ro` as `shipping_method.media.thumbnailsRo` ,
`shipping_method.media` . `created_at` as `shipping_method.media.createdAt` ,
`shipping_method.media` . `updated_at` as `shipping_method.media.updatedAt` ,
`shipping_method.media.translation.override_1.title` ,
`shipping_method.media.translation.title` ,
COALESCE (
`shipping_method.media.translation.override_1.title` ,
`shipping_method.media.translation.title`
) as `shipping_method.media.title` ,
`shipping_method.media.translation.override_1.alt` ,
`shipping_method.media.translation.alt` ,
COALESCE (
`shipping_method.media.translation.override_1.alt` ,
`shipping_method.media.translation.alt`
) as `shipping_method.media.alt` ,
`shipping_method.media.translation.override_1.customFields` ,
`shipping_method.media.translation.customFields` ,
COALESCE (
`shipping_method.media.translation.override_1.customFields` ,
`shipping_method.media.translation.customFields`
) as `shipping_method.media.customFields` ,
`shipping_method.translation.override_1.name` ,
`shipping_method.translation.name` ,
COALESCE (
`shipping_method.translation.override_1.name` ,
`shipping_method.translation.name`
) as `shipping_method.name` ,
`shipping_method.translation.override_1.description` ,
`shipping_method.translation.description` ,
COALESCE (
`shipping_method.translation.override_1.description` ,
`shipping_method.translation.description`
) as `shipping_method.description` ,
`shipping_method.translation.override_1.trackingUrl` ,
`shipping_method.translation.trackingUrl` ,
COALESCE (
`shipping_method.translation.override_1.trackingUrl` ,
`shipping_method.translation.trackingUrl`
) as `shipping_method.trackingUrl` ,
`shipping_method.translation.override_1.customFields` ,
`shipping_method.translation.customFields` ,
COALESCE (
`shipping_method.translation.override_1.customFields` ,
`shipping_method.translation.customFields`
) as `shipping_method.customFields`
FROM
`shipping_method`
LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method` . `delivery_time_id` = `shipping_method.deliveryTime` . `id`
LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method` . `id` = `shipping_method.appShippingMethod` . `shipping_method_id`
LEFT JOIN `media` `shipping_method.media` ON `shipping_method` . `media_id` = `shipping_method.media` . `id`
LEFT JOIN (
SELECT
`shipping_method.translation` . `shipping_method_id` ,
`shipping_method.translation` . `name` as `shipping_method.translation.name` ,
`shipping_method.translation.override_1` . `name` as `shipping_method.translation.override_1.name` ,
`shipping_method.translation` . `custom_fields` as `shipping_method.translation.customFields` ,
`shipping_method.translation.override_1` . `custom_fields` as `shipping_method.translation.override_1.customFields` ,
`shipping_method.translation` . `description` as `shipping_method.translation.description` ,
`shipping_method.translation.override_1` . `description` as `shipping_method.translation.override_1.description` ,
`shipping_method.translation` . `tracking_url` as `shipping_method.translation.trackingUrl` ,
`shipping_method.translation.override_1` . `tracking_url` as `shipping_method.translation.override_1.trackingUrl`
FROM
`shipping_method_translation` `shipping_method.translation`
LEFT JOIN `shipping_method_translation` `shipping_method.translation.override_1` ON `shipping_method.translation` . `shipping_method_id` = `shipping_method.translation.override_1` . `shipping_method_id`
AND `shipping_method.translation.override_1` . `language_id` = ?
WHERE
`shipping_method.translation` . `language_id` = ?
) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation` . `shipping_method_id` = `shipping_method` . `id`
LEFT JOIN (
SELECT
`shipping_method.deliveryTime.translation` . `delivery_time_id` ,
`shipping_method.deliveryTime.translation` . `name` as `shipping_method.deliveryTime.translation.name` ,
`shipping_method.deliveryTime.translation.override_1` . `name` as `shipping_method.deliveryTime.translation.override_1.name` ,
`shipping_method.deliveryTime.translation` . `custom_fields` as `shipping_method.deliveryTime.translation.customFields` ,
`shipping_method.deliveryTime.translation.override_1` . `custom_fields` as `shipping_method.deliveryTime.translation.override_1.customFields`
FROM
`delivery_time_translation` `shipping_method.deliveryTime.translation`
LEFT JOIN `delivery_time_translation` `shipping_method.deliveryTime.translation.override_1` ON `shipping_method.deliveryTime.translation` . `delivery_time_id` = `shipping_method.deliveryTime.translation.override_1` . `delivery_time_id`
AND `shipping_method.deliveryTime.translation.override_1` . `language_id` = ?
WHERE
`shipping_method.deliveryTime.translation` . `language_id` = ?
) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation` . `delivery_time_id` = `shipping_method.deliveryTime` . `id`
LEFT JOIN (
SELECT
`shipping_method.media.translation` . `media_id` ,
`shipping_method.media.translation` . `alt` as `shipping_method.media.translation.alt` ,
`shipping_method.media.translation.override_1` . `alt` as `shipping_method.media.translation.override_1.alt` ,
`shipping_method.media.translation` . `title` as `shipping_method.media.translation.title` ,
`shipping_method.media.translation.override_1` . `title` as `shipping_method.media.translation.override_1.title` ,
`shipping_method.media.translation` . `custom_fields` as `shipping_method.media.translation.customFields` ,
`shipping_method.media.translation.override_1` . `custom_fields` as `shipping_method.media.translation.override_1.customFields`
FROM
`media_translation` `shipping_method.media.translation`
LEFT JOIN `media_translation` `shipping_method.media.translation.override_1` ON `shipping_method.media.translation` . `media_id` = `shipping_method.media.translation.override_1` . `media_id`
AND `shipping_method.media.translation.override_1` . `language_id` = ?
WHERE
`shipping_method.media.translation` . `language_id` = ?
) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation` . `media_id` = `shipping_method.media` . `id`
WHERE
`shipping_method` . `id` IN (? )
Copy
SELECT `shipping_method` . `id` as `shipping_method.id` , `shipping_method` . `active` as `shipping_method.active` , `shipping_method` . `position` as `shipping_method.position` , `shipping_method` . `availability_rule_id` as `shipping_method.availabilityRuleId` , `shipping_method` . `media_id` as `shipping_method.mediaId` , `shipping_method` . `delivery_time_id` as `shipping_method.deliveryTimeId` , `shipping_method` . `tax_type` as `shipping_method.taxType` , `shipping_method` . `tax_id` as `shipping_method.taxId` , `shipping_method.deliveryTime` . `id` as `shipping_method.deliveryTime.id` , `shipping_method.deliveryTime` . `min` as `shipping_method.deliveryTime.min` , `shipping_method.deliveryTime` . `max` as `shipping_method.deliveryTime.max` , `shipping_method.deliveryTime` . `unit` as `shipping_method.deliveryTime.unit` , `shipping_method.deliveryTime` . `created_at` as `shipping_method.deliveryTime.createdAt` , `shipping_method.deliveryTime` . `updated_at` as `shipping_method.deliveryTime.updatedAt` , `shipping_method.deliveryTime.translation.override_1.name` , `shipping_method.deliveryTime.translation.name` , COALESCE (`shipping_method.deliveryTime.translation.override_1.name` , `shipping_method.deliveryTime.translation.name` ) as `shipping_method.deliveryTime.name` , `shipping_method.deliveryTime.translation.override_1.customFields` , `shipping_method.deliveryTime.translation.customFields` , COALESCE (`shipping_method.deliveryTime.translation.override_1.customFields` , `shipping_method.deliveryTime.translation.customFields` ) as `shipping_method.deliveryTime.customFields` , `shipping_method.appShippingMethod` . `id` as `shipping_method.appShippingMethod.id` , `shipping_method.appShippingMethod` . `app_name` as `shipping_method.appShippingMethod.appName` , `shipping_method.appShippingMethod` . `identifier` as `shipping_method.appShippingMethod.identifier` , `shipping_method.appShippingMethod` . `app_id` as `shipping_method.appShippingMethod.appId` , `shipping_method.appShippingMethod` . `shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId` , `shipping_method.appShippingMethod` . `original_media_id` as `shipping_method.appShippingMethod.originalMediaId` , `shipping_method.appShippingMethod` . `created_at` as `shipping_method.appShippingMethod.createdAt` , `shipping_method.appShippingMethod` . `updated_at` as `shipping_method.appShippingMethod.updatedAt` , `shipping_method` . `technical_name` as `shipping_method.technicalName` , `shipping_method` . `created_at` as `shipping_method.createdAt` , `shipping_method` . `updated_at` as `shipping_method.updatedAt` , `shipping_method.media` . `id` as `shipping_method.media.id` , `shipping_method.media` . `user_id` as `shipping_method.media.userId` , `shipping_method.media` . `media_folder_id` as `shipping_method.media.mediaFolderId` , `shipping_method.media` . `mime_type` as `shipping_method.media.mimeType` , `shipping_method.media` . `file_extension` as `shipping_method.media.fileExtension` , `shipping_method.media` . `uploaded_at` as `shipping_method.media.uploadedAt` , `shipping_method.media` . `file_name` as `shipping_method.media.fileName` , `shipping_method.media` . `file_size` as `shipping_method.media.fileSize` , `shipping_method.media` . `media_type` as `shipping_method.media.mediaTypeRaw` , `shipping_method.media` . `meta_data` as `shipping_method.media.metaData` , `shipping_method.media` . `config` as `shipping_method.media.config` , `shipping_method.media` . `path` as `shipping_method.media.path` , `shipping_method.media` . `private` as `shipping_method.media.private` , `shipping_method.media` . `thumbnails_ro` as `shipping_method.media.thumbnailsRo` , `shipping_method.media` . `created_at` as `shipping_method.media.createdAt` , `shipping_method.media` . `updated_at` as `shipping_method.media.updatedAt` , `shipping_method.media.translation.override_1.title` , `shipping_method.media.translation.title` , COALESCE (`shipping_method.media.translation.override_1.title` , `shipping_method.media.translation.title` ) as `shipping_method.media.title` , `shipping_method.media.translation.override_1.alt` , `shipping_method.media.translation.alt` , COALESCE (`shipping_method.media.translation.override_1.alt` , `shipping_method.media.translation.alt` ) as `shipping_method.media.alt` , `shipping_method.media.translation.override_1.customFields` , `shipping_method.media.translation.customFields` , COALESCE (`shipping_method.media.translation.override_1.customFields` , `shipping_method.media.translation.customFields` ) as `shipping_method.media.customFields` , `shipping_method.translation.override_1.name` , `shipping_method.translation.name` , COALESCE (`shipping_method.translation.override_1.name` , `shipping_method.translation.name` ) as `shipping_method.name` , `shipping_method.translation.override_1.description` , `shipping_method.translation.description` , COALESCE (`shipping_method.translation.override_1.description` , `shipping_method.translation.description` ) as `shipping_method.description` , `shipping_method.translation.override_1.trackingUrl` , `shipping_method.translation.trackingUrl` , COALESCE (`shipping_method.translation.override_1.trackingUrl` , `shipping_method.translation.trackingUrl` ) as `shipping_method.trackingUrl` , `shipping_method.translation.override_1.customFields` , `shipping_method.translation.customFields` , COALESCE (`shipping_method.translation.override_1.customFields` , `shipping_method.translation.customFields` ) as `shipping_method.customFields` FROM `shipping_method` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method` . `delivery_time_id` = `shipping_method.deliveryTime` . `id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method` . `id` = `shipping_method.appShippingMethod` . `shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method` . `media_id` = `shipping_method.media` . `id` LEFT JOIN (SELECT `shipping_method.translation` . `shipping_method_id` , `shipping_method.translation` . `name` as `shipping_method.translation.name` , `shipping_method.translation.override_1` . `name` as `shipping_method.translation.override_1.name` , `shipping_method.translation` . `custom_fields` as `shipping_method.translation.customFields` , `shipping_method.translation.override_1` . `custom_fields` as `shipping_method.translation.override_1.customFields` , `shipping_method.translation` . `description` as `shipping_method.translation.description` , `shipping_method.translation.override_1` . `description` as `shipping_method.translation.override_1.description` , `shipping_method.translation` . `tracking_url` as `shipping_method.translation.trackingUrl` , `shipping_method.translation.override_1` . `tracking_url` as `shipping_method.translation.override_1.trackingUrl` FROM `shipping_method_translation` `shipping_method.translation` LEFT JOIN `shipping_method_translation` `shipping_method.translation.override_1` ON `shipping_method.translation` . `shipping_method_id` = `shipping_method.translation.override_1` . `shipping_method_id` AND `shipping_method.translation.override_1` . `language_id` = 0xDE44571DDC4E4D0095C01AF6EE299351 WHERE `shipping_method.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation` . `shipping_method_id` = `shipping_method` . `id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation` . `delivery_time_id` , `shipping_method.deliveryTime.translation` . `name` as `shipping_method.deliveryTime.translation.name` , `shipping_method.deliveryTime.translation.override_1` . `name` as `shipping_method.deliveryTime.translation.override_1.name` , `shipping_method.deliveryTime.translation` . `custom_fields` as `shipping_method.deliveryTime.translation.customFields` , `shipping_method.deliveryTime.translation.override_1` . `custom_fields` as `shipping_method.deliveryTime.translation.override_1.customFields` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` LEFT JOIN `delivery_time_translation` `shipping_method.deliveryTime.translation.override_1` ON `shipping_method.deliveryTime.translation` . `delivery_time_id` = `shipping_method.deliveryTime.translation.override_1` . `delivery_time_id` AND `shipping_method.deliveryTime.translation.override_1` . `language_id` = 0xDE44571DDC4E4D0095C01AF6EE299351 WHERE `shipping_method.deliveryTime.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation` . `delivery_time_id` = `shipping_method.deliveryTime` . `id` LEFT JOIN (SELECT `shipping_method.media.translation` . `media_id` , `shipping_method.media.translation` . `alt` as `shipping_method.media.translation.alt` , `shipping_method.media.translation.override_1` . `alt` as `shipping_method.media.translation.override_1.alt` , `shipping_method.media.translation` . `title` as `shipping_method.media.translation.title` , `shipping_method.media.translation.override_1` . `title` as `shipping_method.media.translation.override_1.title` , `shipping_method.media.translation` . `custom_fields` as `shipping_method.media.translation.customFields` , `shipping_method.media.translation.override_1` . `custom_fields` as `shipping_method.media.translation.override_1.customFields` FROM `media_translation` `shipping_method.media.translation` LEFT JOIN `media_translation` `shipping_method.media.translation.override_1` ON `shipping_method.media.translation` . `media_id` = `shipping_method.media.translation.override_1` . `media_id` AND `shipping_method.media.translation.override_1` . `language_id` = 0xDE44571DDC4E4D0095C01AF6EE299351 WHERE `shipping_method.media.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation` . `media_id` = `shipping_method.media` . `id` WHERE `shipping_method` . `id` IN (0xF1FC97663DDC45C382C2A6420A7BB195 );
Copy
1.15 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"N¦B\x06 ˜^@H‚i¦\x16 fž_C "
b"Èÿ└#@┴Lü╝¨\v ╦`^â" "
b"ËÅ}ØÆÂCbØ`▄DÑ╝\x16\x18 "
b"\x01 ì;\x03 K\x19 p*ø.cÇØ_Å\x16 \x01 ì;\x03 K1q\x11 ╝J\e\x13 ªVZÔ\x01 ôÈÒìêvߣÄÂ9\x01 Î█\x01 ò\x14 äÍ´s┴ìº\x16 ðâ‗Í■\x02 <\x04\f fºBn¤ê¡+Þüyg\x1C š©ø‰I2žlÖd·‡Õ\x16 -’Ã1`QJߧ <ô¡\v ‚¦ "
b"0xÙ\x12 Ol@m¾¦úd1¸ŸË "
b"EáÏÒÓŠCô‹=÷6ˆÄm¥ "
b"L%lœ9=O2’z0VV=ûD "
b"NåˆsU˜CÄŠŽŽ‰ðØžõ "
b"SîHÕR I\x1E ’Ç|{nkŠ\x1A "
b"Y\x02\e õfREY¨\x1C %RØèf# "
b"\Cèñð²C·™Š g&>ƒ# "
b"]\x07 –~b)Gø”\x1D É.êÛZL "
b"_¨/ÎàüG`ŠçgËM)\x12 = "
b"eÿ▒ÒVÕD¼íAÉ6ƒT\x1A ² "
b"nnñ\r zÌE\r ¾×\x11 ñˆÂ\x1F ^ "
b"oÅPO‡hGó \x14\x1E "äÂjP "
b"àı{\x12\x07 _FóÉ\x02 ä\x01 8sÊ¿ "
b"“G§\x12 Ñ\v CB€Lp¡M\x7F =. "
b"œß˜w˜\x08 JÙ².([QžZV "
b"""
¸S¸g\x0F !FŒ¶\n
ê*‘ÕZ]
"""
b"©j\f â«!MÅÀ_öè¢ò\x05 U "
b"¼¼Y—@kFÍ‹\x1F »aõŠcç "
b"└A/├ú±C▓ìDïÀ\x15 £\x00 ô "
b"═À5þË\x13 D6©õÉ?ö\x0F ░╚ "
b"¤\x14 :ã^oDöÜØQg\x19 Cð├ "
b"ÜŠ¿êá!O‚“Ö\x1D `“yŒë "
b"Þ”+T“ãKrŽ£õZ=Q.¼ "
b"æ\x12 æÊWYNó›˜gö%¸§? "
b"꣟SndKÚ3¼+ôðþ‡ "
b"\x01 •\x14\x7F ‹ªs\x03 Ž÷di Ks#\x01 ò)OV¤\x7F ░âÅ,àÙ╬\x00 Û\x01 Œ+æ‚!z'š2Œnø¿xÁ\x01 Œ3þ—×q–…;¶’Å‹?*\x01 Œ3ÿU\x01 qq’m\t lÎz\x1E k\x01 Œ3ÿÕïp¦‹\x13 Zì±\x01\x13 ¥\x01 ’²Ù9åv€†ê 7=4Ã"\x01 Æ▓ß·ßqßü\x1E ╝Fxè\n Ò
"""
b"¿‗PìÉÅB®À|6Ã\x0E @Oã "
b"\x01 ”AjÈqò†Îûx"„þ3\x01 •)R\x10 î}U«éz¥žÁÓ§f¡«Ø}\x15 @\x13 ┐Ã~¿:²-Ç "
b"\x01 ŒÔ¨©?yÍ‚#PNéU\x05 ù\x01 ŒÔ©ü«v»ŠSÁF¦±ÛÂ\x01 ŒÔ«¤ª~槾U7¸×%q\x01 ŒÔ¬!Wp¯³‚h\x1F\x15 ˆ¤\x19 \x01 ŒÔ¬´âr®¸Åxm\x14 _|%\x01 ŒÔ³g\pL´ZÂ1ÏDz/\x01 ŒÔ´QFu¯›UC9®¶ÓÎ\x01 îÈÁ»w~\x07 ÆÈ\x1D 5┐Å>Y\x01 ŒÔ¶Jys<ª"3÷‡·Æ[\x01 ŒÔ·>#t\t ‰,ÞÎQ7ËÕ\t Úéáø5N\x12 ®Ë{B¸ÈÃâ\x1C ›0.KaH¬®÷\x1C ò3Y¥“=‘\x14\x05 ÞTN\x02 ‡ä¤ôþ‹\x04 â "
b"J8\x00 RhO@É©┤\t ¾¬ÈÉ· "
b"V±¸_PEó┤nN┬Ø┐5┤ "
b"™Ó^™l®Eœ½Ï¬\x08\x11\x00 Ú¡ "
b"´Ú§³_[E\x14 •t\x16 Z‡Ëï… "
b"ή<ıí╣Oɼ¾D\t ╗;z» "
b"°i÷V┌^KóØÜ\x05 búi╚% "
b"\x01 Œ>¸$EsÏ«¤ùªÎ\x15 ob\x01 \e ÈwÉ▒3©Eâ┌]Þ\x01 ìT╣\x1D\f {së9'siT▄▒\x01 ìÛé&\x15 r±éÀkl\n b?·
"""
b"\x01 Å÷2é╦zøØ└\x04 ÒGr╗,\x01 É6\e ┤Hsué¦÷~W¬¯á\x01 ɲÚÝí}YÑ═├\x06 |9¤Ä\x01 ‘0Ò«æ|›š¥cËHJ\e\x07 \x01 æÀ\x1D Å]qǪàÍܶ\x14 m&\x01 ’l\r n\x05 w9˜ñ\x1E ã˜k&\t \x01 “$»¹_qÔ³C¬sºlTö\x01 “q —V\x7F G‘Œi\x19 r\e à¡\x01 ö¿ÉÅß}╠©»míBÑ6z\x01 ”ÿ\x1C Ú\x0E\x7F žp\x16 7\r ‚ª\x01 –ImìÒqF£Å\x13 I¢\e Ñ…\x18 ‚üm<LJ׌ÖäHǽE\f \e ×\x02 ^\x18 OF\x1D «™0èuQ\x00 §\x1C ß ƒL[E¸¤0ä\x16 ©\x16 Q#º3\x02 v¼B¿®\x01 µÜ󤆚 "
b"-\x03 óê┤LÖû·+q³ì?▓ "
b"0`æûÜñE\x12 üþ®ímH§Ä "
b"9Ú>Ï‘r@d¦^luHð9 "
b"Dì\x02 z└\x07 @╔ö╬¸îä\x1A @b "
b"l|<Ƹ\x1D KÍ£p‡V<‡óƒ "
b"w³õŒ\x7F PAt‰?´íàe¥Î "
b"z\x02 Þá{@LÍ•ÚóÝF\t Sß "
b"“eb*1]K¦±•‚î^\x11 `· "
b"˜²\x05 ¾&Q@ô¯aüÆwŸ¡Ã "
b"¡\x16 µi\Ú@Ú¥)žãÂgkÆ "
b"±œ¢çç±HΓúS9ü×,\x06 "
b"├Ó=╗8^Crû╔üàë/└ø "
b"Í\x07 û\x7F ”ÉEιƒ\x12 >€ü "
b"éÓŒÜýÆLœ˜0¸§a[ìê "
b"ó!c\x07 6%Oä“o\x11 E\f\x19 {~ "
b"\x03 *GªÜ~CQ’ýG¡2-\x0F 6\x04\x15 è€üˆHŒŒîú±ñíð!\n X8\v aC6†ÀóB!iŒW
"""
b"\x0F ÷ıØÆJI¹äCÚb#2{ô\x16 âQ@¾üK╝áÇÚZfüóå\x19 ãgL`-B\x11 Ž{†øµéÑø#¬.鮓Ir’%\n
Èí\x1E D\x06
"""
b"-Õ\e (NƒD£ú╔É1³:½¯ "
b"0u=\f\x1A ÿMIì÷´█®╩\x01 ╔ "
b"0•ép²u@û‰J\x10 ˜\x06 ð` "
b"5Ç:ɧ\x1D L^¦e “¦iñÞ "
b"8S^╚ÔäAØÀöòa\x1C ò\x02 ' "
b"L*\x16 ▒\x11 M¥ü:G×A\x17 ä» "
b"P T+ü\x04 M\x0E ¼·\x04\x08 ºÜ╣× "
b"Q\v ³ÓO'Oò¢Ü\x04\x15 n\x0F\x13 ˆ "
b"UHîÜtáD\v ª§\(ž«îÆ "
b"_\x06 ┤u═ÿ@âül§}d»1V "
b"_ç¶!¯^H¼n×\x1C 6˜°f "
b"`¹+Üþ╚NåÅ\x08 R2m¼*< "
b"açäm\x08 íN\v ¥³í°½L\x03\x17 "
b"em\x1D ÇWtHž›\x00 ÞÃ\x08 k[¯ "
b"lÌ\t üÓ3@*¾C\x07\x7F ~Ž\x00 ÷ "
b"nõ¶Åv░I¸╝¶\x05 +TÀV\x10 "
b"sä!þN2@WÉpßSµIë\x19 "
b"{&4\x08 ›3Kh¦Z±ø\x04 Œ^f "
b"{ñ/ÝTûHÚ£i\x1A QbõØš "
b"}1Õq¾\x0F H´ 9SU)\x06 ôú "
b"\x7F\x1C\x13\x1E Ý#AÓ¡¾ºÑ\x11 ÝÚÎ\x7F 3ß┤0ÇNÅû‗쨬\x1F <Ëëø\x14 ¢─ìCâíÊ>Dq~y\x05 "
b"Š©2UâsK.“«–qõ\x01\x03\x1E "
b"ìÅPI[ûIÇ▒║£\x1C [\x02 Ѩ "
b"Å\x03 ▒4YtCþíÌZtômr "
b"’\x01 €\x17 7OJ\x0E ™\v 2œÎ†Õ³ "
b"ô÷ßíÜ╔DÔï´ZÙ·¼ìn "
b"û╝6ð~üIñÜÆ\x00 î6:¯> "
b"š!êý“àL@”Æ™éº\x04 Ú\x05 "
b"ØT\e È\x06 XD┼ÆóÖsùïil "
b"ŸÖní”þJÕ‚~–œ[¦N÷ "
b"áHãƬ)O\x7F Øô{Lï\t tì "
b"""
¥/i\x17\x12\x16 F1‡\n
ñ:\x03 C¾w
"""
b"°q¹!\t EH§YjüB½IY "
b"²!_þÎeJ#°\x02\f µ\x03 Âó\x16 "
b"´‚\x04 8z‰Lh¶Ê çt|H± "
b"╝yëÉúàK2║\x1A h■Øø]H "
b"¢\x0E <¢d\x14 H┐èy[ùü5\x1D ╦ "
b"Ã4ž36)Kë’%°97Ð"‡ "
b"È|ȉÿ§Dô«žvØŒr\x0F à "
b"ÈÜo‘Ò’HÒ«Ù8®ÀgU2 "
b"Í\x00 ¡\x15 6óI~™4S½“\x07 [\x0E "
b"Ëol7#×N║üÚê»ÞE\x05 \n "
b"Ïô ë\x05 ,Bw£5{Ø▄¢Ñ] "
b"õª×╩7¤J²ÅÇK¼]O┼▒ "
b"ìÉîØ1êMé‹®‡/²È`â "
]
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 (0x4EA64206985E40488269A616669E5F43 , 0xD498C02340C14C81BCF90BCB605E8322 , 0xD38F7D9D92B643629D60DC44A5BC1618 , 0x018D3B034B19702A9B2E63809D5F8F16 , 0x018D3B034B317111BC4A1B13A6565AE2 , 0x0193D4E38D8876E19C8EB639F001D7DB , 0x01951484D6EF73C18DA716D083F2D6FE , 0x023C040C66BA426EA4EAA12BDEFC7967 , 0x1CC29AA9F88949329E6CD664B787D516 , 0x2D92C33160514ADFA7A03CF4A10B82A6 , 0x3078D9124F6C406DBEA6FA6431B89FCB , 0x45E1CFD2D38A43F48B3DF73688C46DA5 , 0x4C256C9C393D4F32927A3056563DFB44 , 0x4EE58873559843C48A8E8E89F0D89EF5 , 0x53EE48D55220491E92C77C7B6E6B8A1A , 0x59021BF566524559A81C2552D8E86623 , 0x5C43E8F1F0B243B7998AA067263E8323 , 0x5D07967E622947F8941DC92EEADB5A4C , 0x5FA82FCEE0FC47608AE767CB4D29123D , 0x6598B1E356E544ACA14190369F541AFD , 0x6E6EF10D7ACC450DBED711F188C21F5E , 0x6FC5504F876847F3A0141E22E4C26A50 , 0x85D57B12075F46A2900284013873D2A8 , 0x9347A712D10B4342804C70A14D7F3D2E , 0x9CDF987798084AD9B22E285B519E5A56 , 0xB853B8670F21468CB60AEA2A91D55A5D , 0xB86A0C83AE214D8FB75F948ABD950555 , 0xBCBC5997406B46CD8B1FBB61F58A63E7 , 0xC0412FC3A3F143B28D448BB7159C0093 , 0xCDB735E7D3134436B8E4903F940FB0C8 , 0xCF143AC65E6F44949A9D51671943D0C3 , 0xDC8ABFEAE1214F8293D61D6093798CEB , 0xDE942B5493E34B728EA3F55A3D512EBC , 0xE612E6CA57594EF39B9867F625B8A73F , 0xEAA39F536E644BDAAD33BC2BF4F0FE87 , 0x0195147F8BAA73038EF76469204B7323 , 0x0195294F56CF7FB0838F2C85EBCE00EA , 0x018C2BE682217A279A328C6EF8BF78C1 , 0x018C33FE97D77196853BB692C58B3F2A , 0x018C33FF55017171926D096CCE7A1E6B , 0x018C33FFD5EF70A68B135AECB10113A5 , 0x0192B2D939E5768086EA20373D34C322 , 0x0192B2E1FAE171E1811EBC46788A0AE3 , 0xA8F2508D908F42A9B77C36C70E404FC6 , 0x0194416AC38871F286CEFB782284FE33 , 0x0195295210EE7D55ABE97AA59EC1D3A7 , 0x66ADAE9D7D154013BFC77EA83AFD2D80 , 0x018CD4A8A93F79CD8223504EE95505F9 , 0x018CD4A9FCAB76BB8A53C146A6B1DBC2 , 0x018CD4ABA4AA7EE6A7BE5537B8D72571 , 0x018CD4AC215770AFB382681F1588A419 , 0x018CD4ACB4E272AEB8C5786D145F7C25 , 0x018CD4B3675C704CB45AC231CFC7B22F , 0x018CD4B4514675AF9B554339AEB6D3CE , 0x018CD4B5AF777E0792D41D35BF8F3E59 , 0x018CD4B64A79733CAA2233F787B7C65B , 0x018CD4B73E237409892CDECE5137CBD5 , 0x09DAE9E1F8354E12AECB7B42B8C8C3E2 , 0x1C9B302E4B6148ACAEF71CF23359A593 , 0x3D911405DE544E0287E4A4F4FE8B04E2 , 0x4A380052684F4090B8B409F3AAD490FA , 0x56F1F7F05F5045A2B46E4EC29DBF35B4 , 0x99D35E996CAE459CBDCFAC081100DAA1 , 0xB4DAA7B35F5B45149574165A87CBEF85 , 0xD7A93CD5A1B94F90ACF34409BB3B7AAF , 0xF869F656DA5E4BA29D9A0562A369C825 , 0x018C3EB8244573CFABA4F9AACE156F62 , 0x018CF7EE1BD47790B133B84583DA5DE8 , 0x018D54B91D0C7B73893927736954DCB1 , 0x018DEA82261572F182B76B6C0A623FFA , 0x018FF63282CB7A9B9DC004E34772BB2C , 0x0190361BB448737582DDF67E57AAEEA0 , 0x0190FDE9EDA17D59A5CDC3067C39CF8E , 0x019130D2ABE67C9B9AA563CB484A1B07 , 0x0191B71D8F5D7180A685D69AF4146D26 , 0x01926C0D6E05773998F11EE3986B2609 , 0x019324BBB95F71D4B343AC73BA6C54F6 , 0x019371A097567F47918C6919721BE0A1 , 0x0194A8908FE17DCCB8AF6DA142A5367A , 0x0194FF1CDA0E7FAD9E7016A0370D82AA , 0x0196496DECD27146A3C51349A21BD185 , 0x1882FC6D3C4C4AD78CD6E448C7BD450C , 0x1BD7025E184F461DAB9930E8755100A7 , 0x1CDF20834C5B45B8A430E416C2A91651 , 0x23BA330276BC42BFAE01B5DCF3A4869A , 0x2D03A2C7A6B44C9996FA2B71FC8D3FB2 , 0x306091969AA4451281E7A9A16D48F58E , 0x39DA3ECF91724064A65E6CAD7548F039 , 0x448D027AC00740C994CEF78C841A4062 , 0x6C7C3CC6B81D4BCDA37087563C87F383 , 0x77B3F58C7F504174893FB4EDE065A5CE , 0x7A02DEE17B404CCD95DAF3DD460953DF , 0x9365622A315D4BA6B19582EE5E1160B7 , 0x98B205BE265140F4AF61FCC6779FA1C3 , 0xA116B5695CDA40DAA5299EE3C2676BC6 , 0xB19CA2E7E7B148CE93FA5339FCD72C06 , 0xC3E03DBB385E437296C98185892FC09B , 0xCD07FB7F94C945CEB983123E80FCA020 , 0xE9D38CDCFDC64C9C9830B8A7615BECEA , 0xF321630736254FE4936F11450C197B7E , 0x032A47AADC7E435192FD47A1322D0F36 , 0x0415E880FC88488C8CEEFAB1F1EDF021 , 0x0A58380B61AD433686C0F34221698C57 , 0x0FF6D59D924A49FB8443E96223327B93 , 0x16835140F3814BBCA080E95A6681A286 , 0x19E3674C602D42118E7B86F8B5E9D1F8 , 0x23AC2EE9AE93497292250AC8ED1E4406 , 0x2DE51B284E9F449CA3C99031FC3AABEE , 0x30753D0C1A984D498DF6EFDBA9CA01C9 , 0x3095E970B27540C3BB894A109806F060 , 0x35C73AC9A71D4C5EA665A093A669F1DE , 0x38535EC8E284419DB79495611C950227 , 0x4C2A16B111204DBE813A479E411784AF , 0x5020542B81044D0EACFA0408A79AB99E , 0x510BB3D34F274FF2A2DC04156E0F1388 , 0x5548EEDC74E1440BAAA75C289EABEEC6 , 0x5F06B475CD984083816CF57D64AF3156 , 0x5FE7B621AF5E48ADBC6ED71C3698B066 , 0x60FB2B9AE7C84E868F0852326DAC2A3C , 0x61E7E46D08ED4E0BA5B3EDB0BD4C0317 , 0x656D1DC75774489E9B00DEC3086B5BAF , 0x6CCC09FCD333402ABE43077F7E8E00F7 , 0x6EE4F48F76B049F7BCF4052B54B75610 , 0x738421E74E3240579070E153E6498919 , 0x7B2634089B334B68A65AB1F8048C5E66 , 0x7BF12FDD54FB48DAA3691A5162F5D89A , 0x7D31D571BE0F48B4A03953552906F4FA , 0x7F1C131EDD2341D3A1BEBAD111DDDACE , 0x7F33E1B430804E8F96F28DF9AA1F3CD3 , 0x899B14BDC48D4383A1D23E44717E7905 , 0x8AA93255E2734B2E93AB9671F501031E , 0x8D8F50495B964980B1BA9C1C5B02A5F9 , 0x8F03B134597443E7A1DE5A74936DF072 , 0x92018017374F4A0E990B329CCE86D5B3 , 0x93F6E1A19AC944E28BEF5AEBFAAC8D6E , 0x96BC36D07E8149A49A92008C363AEE3E , 0x9A21EAFD93E04C4094C699E9BA04DA05 , 0x9D541BD4065844C592A29973978B696C , 0x9FD66EED94FE4AD5827E969C5BA64EF7 , 0xA048C692AA294F7F9D937B4C8B09748D , 0xA52F691712164631870AF13A0343BE77 , 0xB071B9AD21094548A7596AFC42BD4959 , 0xB2215FFECE654A23B0020CB503C2F316 , 0xB48204387A894C68B6CAA0E7747C48B1 , 0xBC798990A3854B32BA1A68FE9D9B5D48 , 0xBD0E3CBD641448BF8A795B9781351DCB , 0xC3349E3336294BEB9225B03937D02287 , 0xC87CC889FFA744F4AB9E76D88C720FC3 , 0xC8DC6F91D29248D2ABD938AEC0675532 , 0xCD00A11536F3497E993453BD93075B0E , 0xD36F6C37239E4EBA81E988AFE845050A , 0xD8932089052C42779C357B9DDCBDA55D , 0xE4A69ECA37CF4AFD8F804BAC5D4FC5B1 , 0xECC9EED831EA4DE98BAE872FB2C860E2 );
Copy
1.02 ms
2
SELECT `key` , `value` FROM `app_config`
SELECT `key` , `value` FROM `app_config` ; Copy
0.97 ms
1
SELECT `sales_channel` . `id` as `sales_channel.id` , `sales_channel` . `type_id` as `sales_channel.typeId` , `sales_channel` . `language_id` as `sales_channel.languageId` , `sales_channel` . `customer_group_id` as `sales_channel.customerGroupId` , `sales_channel` . `currency_id` as `sales_channel.currencyId` , `sales_channel` . `payment_method_id` as `sales_channel.paymentMethodId` , `sales_channel` . `shipping_method_id` as `sales_channel.shippingMethodId` , `sales_channel` . `country_id` as `sales_channel.countryId` , `sales_channel` . `analytics_id` as `sales_channel.analyticsId` , `sales_channel` . `navigation_category_id` as `sales_channel.navigationCategoryId` , `sales_channel` . `navigation_category_version_id` as `sales_channel.navigationCategoryVersionId` , `sales_channel` . `navigation_category_depth` as `sales_channel.navigationCategoryDepth` , `sales_channel` . `footer_category_id` as `sales_channel.footerCategoryId` , `sales_channel` . `footer_category_version_id` as `sales_channel.footerCategoryVersionId` , `sales_channel` . `service_category_id` as `sales_channel.serviceCategoryId` , `sales_channel` . `service_category_version_id` as `sales_channel.serviceCategoryVersionId` , `sales_channel` . `mail_header_footer_id` as `sales_channel.mailHeaderFooterId` , `sales_channel` . `hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId` , `sales_channel` . `short_name` as `sales_channel.shortName` , `sales_channel` . `tax_calculation_type` as `sales_channel.taxCalculationType` , `sales_channel` . `access_key` as `sales_channel.accessKey` , `sales_channel` . `configuration` as `sales_channel.configuration` , `sales_channel` . `active` as `sales_channel.active` , `sales_channel` . `hreflang_active` as `sales_channel.hreflangActive` , `sales_channel` . `maintenance` as `sales_channel.maintenance` , `sales_channel` . `maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist` , `sales_channel` . `payment_method_ids` as `sales_channel.paymentMethodIds` , `sales_channel` . `home_cms_page_id` as `sales_channel.homeCmsPageId` , `sales_channel` . `home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId` , `sales_channel` . `created_at` as `sales_channel.createdAt` , `sales_channel` . `updated_at` as `sales_channel.updatedAt` , `sales_channel.currency` . `id` as `sales_channel.currency.id` , `sales_channel.currency` . `factor` as `sales_channel.currency.factor` , `sales_channel.currency` . `symbol` as `sales_channel.currency.symbol` , `sales_channel.currency` . `iso_code` as `sales_channel.currency.isoCode` , `sales_channel.currency` . `position` as `sales_channel.currency.position` , `sales_channel.currency` . `tax_free_from` as `sales_channel.currency.taxFreeFrom` , `sales_channel.currency` . `item_rounding` as `sales_channel.currency.itemRounding` , `sales_channel.currency` . `total_rounding` as `sales_channel.currency.totalRounding` , `sales_channel.currency` . `created_at` as `sales_channel.currency.createdAt` , `sales_channel.currency` . `updated_at` as `sales_channel.currency.updatedAt` , `sales_channel.currency.translation.override_1.shortName` , `sales_channel.currency.translation.shortName` , COALESCE (`sales_channel.currency.translation.override_1.shortName` , `sales_channel.currency.translation.shortName` ) as `sales_channel.currency.shortName` , `sales_channel.currency.translation.override_1.name` , `sales_channel.currency.translation.name` , COALESCE (`sales_channel.currency.translation.override_1.name` , `sales_channel.currency.translation.name` ) as `sales_channel.currency.name` , `sales_channel.currency.translation.override_1.customFields` , `sales_channel.currency.translation.customFields` , COALESCE (`sales_channel.currency.translation.override_1.customFields` , `sales_channel.currency.translation.customFields` ) as `sales_channel.currency.customFields` , `sales_channel.translation.override_1.name` , `sales_channel.translation.name` , COALESCE (`sales_channel.translation.override_1.name` , `sales_channel.translation.name` ) as `sales_channel.name` , `sales_channel.translation.override_1.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` , COALESCE (`sales_channel.translation.override_1.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` ) as `sales_channel.homeSlotConfig` , `sales_channel.translation.override_1.homeEnabled` , `sales_channel.translation.homeEnabled` , COALESCE (`sales_channel.translation.override_1.homeEnabled` , `sales_channel.translation.homeEnabled` ) as `sales_channel.homeEnabled` , `sales_channel.translation.override_1.homeName` , `sales_channel.translation.homeName` , COALESCE (`sales_channel.translation.override_1.homeName` , `sales_channel.translation.homeName` ) as `sales_channel.homeName` , `sales_channel.translation.override_1.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` , COALESCE (`sales_channel.translation.override_1.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` ) as `sales_channel.homeMetaTitle` , `sales_channel.translation.override_1.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` , COALESCE (`sales_channel.translation.override_1.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` ) as `sales_channel.homeMetaDescription` , `sales_channel.translation.override_1.homeKeywords` , `sales_channel.translation.homeKeywords` , COALESCE (`sales_channel.translation.override_1.homeKeywords` , `sales_channel.translation.homeKeywords` ) as `sales_channel.homeKeywords` , `sales_channel.translation.override_1.customFields` , `sales_channel.translation.customFields` , COALESCE (`sales_channel.translation.override_1.customFields` , `sales_channel.translation.customFields` ) as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel` . `currency_id` = `sales_channel.currency` . `id` LEFT JOIN (SELECT `sales_channel.translation` . `sales_channel_id` , `sales_channel.translation` . `name` as `sales_channel.translation.name` , `sales_channel.translation.override_1` . `name` as `sales_channel.translation.override_1.name` , `sales_channel.translation` . `custom_fields` as `sales_channel.translation.customFields` , `sales_channel.translation.override_1` . `custom_fields` as `sales_channel.translation.override_1.customFields` , `sales_channel.translation` . `home_slot_config` as `sales_channel.translation.homeSlotConfig` , `sales_channel.translation.override_1` . `home_slot_config` as `sales_channel.translation.override_1.homeSlotConfig` , `sales_channel.translation` . `home_enabled` as `sales_channel.translation.homeEnabled` , `sales_channel.translation.override_1` . `home_enabled` as `sales_channel.translation.override_1.homeEnabled` , `sales_channel.translation` . `home_name` as `sales_channel.translation.homeName` , `sales_channel.translation.override_1` . `home_name` as `sales_channel.translation.override_1.homeName` , `sales_channel.translation` . `home_meta_title` as `sales_channel.translation.homeMetaTitle` , `sales_channel.translation.override_1` . `home_meta_title` as `sales_channel.translation.override_1.homeMetaTitle` , `sales_channel.translation` . `home_meta_description` as `sales_channel.translation.homeMetaDescription` , `sales_channel.translation.override_1` . `home_meta_description` as `sales_channel.translation.override_1.homeMetaDescription` , `sales_channel.translation` . `home_keywords` as `sales_channel.translation.homeKeywords` , `sales_channel.translation.override_1` . `home_keywords` as `sales_channel.translation.override_1.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` LEFT JOIN `sales_channel_translation` `sales_channel.translation.override_1` ON `sales_channel.translation` . `sales_channel_id` = `sales_channel.translation.override_1` . `sales_channel_id` AND `sales_channel.translation.override_1` . `language_id` = ? WHERE `sales_channel.translation` . `language_id` = ? ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id` LEFT JOIN (SELECT `sales_channel.currency.translation` . `currency_id` , `sales_channel.currency.translation` . `short_name` as `sales_channel.currency.translation.shortName` , `sales_channel.currency.translation.override_1` . `short_name` as `sales_channel.currency.translation.override_1.shortName` , `sales_channel.currency.translation` . `name` as `sales_channel.currency.translation.name` , `sales_channel.currency.translation.override_1` . `name` as `sales_channel.currency.translation.override_1.name` , `sales_channel.currency.translation` . `custom_fields` as `sales_channel.currency.translation.customFields` , `sales_channel.currency.translation.override_1` . `custom_fields` as `sales_channel.currency.translation.override_1.customFields` FROM `currency_translation` `sales_channel.currency.translation` LEFT JOIN `currency_translation` `sales_channel.currency.translation.override_1` ON `sales_channel.currency.translation` . `currency_id` = `sales_channel.currency.translation.override_1` . `currency_id` AND `sales_channel.currency.translation.override_1` . `language_id` = ? WHERE `sales_channel.currency.translation` . `language_id` = ? ) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation` . `currency_id` = `sales_channel.currency` . `id` WHERE `sales_channel` . `id` IN (? )
Parameters :
[
b"ÞDW\x1D ÜNM\x00 •À\x1A öî)“Q "
b"/»_ââšMpªXTÎ|ãâ\v "
b"ÞDW\x1D ÜNM\x00 •À\x1A öî)“Q "
b"/»_ââšMpªXTÎ|ãâ\v "
b"¼\x03 ±/ÊnDl›¾sZáôÐÎ "
]
SELECT
`sales_channel` . `id` as `sales_channel.id` ,
`sales_channel` . `type_id` as `sales_channel.typeId` ,
`sales_channel` . `language_id` as `sales_channel.languageId` ,
`sales_channel` . `customer_group_id` as `sales_channel.customerGroupId` ,
`sales_channel` . `currency_id` as `sales_channel.currencyId` ,
`sales_channel` . `payment_method_id` as `sales_channel.paymentMethodId` ,
`sales_channel` . `shipping_method_id` as `sales_channel.shippingMethodId` ,
`sales_channel` . `country_id` as `sales_channel.countryId` ,
`sales_channel` . `analytics_id` as `sales_channel.analyticsId` ,
`sales_channel` . `navigation_category_id` as `sales_channel.navigationCategoryId` ,
`sales_channel` . `navigation_category_version_id` as `sales_channel.navigationCategoryVersionId` ,
`sales_channel` . `navigation_category_depth` as `sales_channel.navigationCategoryDepth` ,
`sales_channel` . `footer_category_id` as `sales_channel.footerCategoryId` ,
`sales_channel` . `footer_category_version_id` as `sales_channel.footerCategoryVersionId` ,
`sales_channel` . `service_category_id` as `sales_channel.serviceCategoryId` ,
`sales_channel` . `service_category_version_id` as `sales_channel.serviceCategoryVersionId` ,
`sales_channel` . `mail_header_footer_id` as `sales_channel.mailHeaderFooterId` ,
`sales_channel` . `hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId` ,
`sales_channel` . `short_name` as `sales_channel.shortName` ,
`sales_channel` . `tax_calculation_type` as `sales_channel.taxCalculationType` ,
`sales_channel` . `access_key` as `sales_channel.accessKey` ,
`sales_channel` . `configuration` as `sales_channel.configuration` ,
`sales_channel` . `active` as `sales_channel.active` ,
`sales_channel` . `hreflang_active` as `sales_channel.hreflangActive` ,
`sales_channel` . `maintenance` as `sales_channel.maintenance` ,
`sales_channel` . `maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist` ,
`sales_channel` . `payment_method_ids` as `sales_channel.paymentMethodIds` ,
`sales_channel` . `home_cms_page_id` as `sales_channel.homeCmsPageId` ,
`sales_channel` . `home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId` ,
`sales_channel` . `created_at` as `sales_channel.createdAt` ,
`sales_channel` . `updated_at` as `sales_channel.updatedAt` ,
`sales_channel.currency` . `id` as `sales_channel.currency.id` ,
`sales_channel.currency` . `factor` as `sales_channel.currency.factor` ,
`sales_channel.currency` . `symbol` as `sales_channel.currency.symbol` ,
`sales_channel.currency` . `iso_code` as `sales_channel.currency.isoCode` ,
`sales_channel.currency` . `position` as `sales_channel.currency.position` ,
`sales_channel.currency` . `tax_free_from` as `sales_channel.currency.taxFreeFrom` ,
`sales_channel.currency` . `item_rounding` as `sales_channel.currency.itemRounding` ,
`sales_channel.currency` . `total_rounding` as `sales_channel.currency.totalRounding` ,
`sales_channel.currency` . `created_at` as `sales_channel.currency.createdAt` ,
`sales_channel.currency` . `updated_at` as `sales_channel.currency.updatedAt` ,
`sales_channel.currency.translation.override_1.shortName` ,
`sales_channel.currency.translation.shortName` ,
COALESCE (
`sales_channel.currency.translation.override_1.shortName` ,
`sales_channel.currency.translation.shortName`
) as `sales_channel.currency.shortName` ,
`sales_channel.currency.translation.override_1.name` ,
`sales_channel.currency.translation.name` ,
COALESCE (
`sales_channel.currency.translation.override_1.name` ,
`sales_channel.currency.translation.name`
) as `sales_channel.currency.name` ,
`sales_channel.currency.translation.override_1.customFields` ,
`sales_channel.currency.translation.customFields` ,
COALESCE (
`sales_channel.currency.translation.override_1.customFields` ,
`sales_channel.currency.translation.customFields`
) as `sales_channel.currency.customFields` ,
`sales_channel.translation.override_1.name` ,
`sales_channel.translation.name` ,
COALESCE (
`sales_channel.translation.override_1.name` ,
`sales_channel.translation.name`
) as `sales_channel.name` ,
`sales_channel.translation.override_1.homeSlotConfig` ,
`sales_channel.translation.homeSlotConfig` ,
COALESCE (
`sales_channel.translation.override_1.homeSlotConfig` ,
`sales_channel.translation.homeSlotConfig`
) as `sales_channel.homeSlotConfig` ,
`sales_channel.translation.override_1.homeEnabled` ,
`sales_channel.translation.homeEnabled` ,
COALESCE (
`sales_channel.translation.override_1.homeEnabled` ,
`sales_channel.translation.homeEnabled`
) as `sales_channel.homeEnabled` ,
`sales_channel.translation.override_1.homeName` ,
`sales_channel.translation.homeName` ,
COALESCE (
`sales_channel.translation.override_1.homeName` ,
`sales_channel.translation.homeName`
) as `sales_channel.homeName` ,
`sales_channel.translation.override_1.homeMetaTitle` ,
`sales_channel.translation.homeMetaTitle` ,
COALESCE (
`sales_channel.translation.override_1.homeMetaTitle` ,
`sales_channel.translation.homeMetaTitle`
) as `sales_channel.homeMetaTitle` ,
`sales_channel.translation.override_1.homeMetaDescription` ,
`sales_channel.translation.homeMetaDescription` ,
COALESCE (
`sales_channel.translation.override_1.homeMetaDescription` ,
`sales_channel.translation.homeMetaDescription`
) as `sales_channel.homeMetaDescription` ,
`sales_channel.translation.override_1.homeKeywords` ,
`sales_channel.translation.homeKeywords` ,
COALESCE (
`sales_channel.translation.override_1.homeKeywords` ,
`sales_channel.translation.homeKeywords`
) as `sales_channel.homeKeywords` ,
`sales_channel.translation.override_1.customFields` ,
`sales_channel.translation.customFields` ,
COALESCE (
`sales_channel.translation.override_1.customFields` ,
`sales_channel.translation.customFields`
) as `sales_channel.customFields`
FROM
`sales_channel`
LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel` . `currency_id` = `sales_channel.currency` . `id`
LEFT JOIN (
SELECT
`sales_channel.translation` . `sales_channel_id` ,
`sales_channel.translation` . `name` as `sales_channel.translation.name` ,
`sales_channel.translation.override_1` . `name` as `sales_channel.translation.override_1.name` ,
`sales_channel.translation` . `custom_fields` as `sales_channel.translation.customFields` ,
`sales_channel.translation.override_1` . `custom_fields` as `sales_channel.translation.override_1.customFields` ,
`sales_channel.translation` . `home_slot_config` as `sales_channel.translation.homeSlotConfig` ,
`sales_channel.translation.override_1` . `home_slot_config` as `sales_channel.translation.override_1.homeSlotConfig` ,
`sales_channel.translation` . `home_enabled` as `sales_channel.translation.homeEnabled` ,
`sales_channel.translation.override_1` . `home_enabled` as `sales_channel.translation.override_1.homeEnabled` ,
`sales_channel.translation` . `home_name` as `sales_channel.translation.homeName` ,
`sales_channel.translation.override_1` . `home_name` as `sales_channel.translation.override_1.homeName` ,
`sales_channel.translation` . `home_meta_title` as `sales_channel.translation.homeMetaTitle` ,
`sales_channel.translation.override_1` . `home_meta_title` as `sales_channel.translation.override_1.homeMetaTitle` ,
`sales_channel.translation` . `home_meta_description` as `sales_channel.translation.homeMetaDescription` ,
`sales_channel.translation.override_1` . `home_meta_description` as `sales_channel.translation.override_1.homeMetaDescription` ,
`sales_channel.translation` . `home_keywords` as `sales_channel.translation.homeKeywords` ,
`sales_channel.translation.override_1` . `home_keywords` as `sales_channel.translation.override_1.homeKeywords`
FROM
`sales_channel_translation` `sales_channel.translation`
LEFT JOIN `sales_channel_translation` `sales_channel.translation.override_1` ON `sales_channel.translation` . `sales_channel_id` = `sales_channel.translation.override_1` . `sales_channel_id`
AND `sales_channel.translation.override_1` . `language_id` = ?
WHERE
`sales_channel.translation` . `language_id` = ?
) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id`
LEFT JOIN (
SELECT
`sales_channel.currency.translation` . `currency_id` ,
`sales_channel.currency.translation` . `short_name` as `sales_channel.currency.translation.shortName` ,
`sales_channel.currency.translation.override_1` . `short_name` as `sales_channel.currency.translation.override_1.shortName` ,
`sales_channel.currency.translation` . `name` as `sales_channel.currency.translation.name` ,
`sales_channel.currency.translation.override_1` . `name` as `sales_channel.currency.translation.override_1.name` ,
`sales_channel.currency.translation` . `custom_fields` as `sales_channel.currency.translation.customFields` ,
`sales_channel.currency.translation.override_1` . `custom_fields` as `sales_channel.currency.translation.override_1.customFields`
FROM
`currency_translation` `sales_channel.currency.translation`
LEFT JOIN `currency_translation` `sales_channel.currency.translation.override_1` ON `sales_channel.currency.translation` . `currency_id` = `sales_channel.currency.translation.override_1` . `currency_id`
AND `sales_channel.currency.translation.override_1` . `language_id` = ?
WHERE
`sales_channel.currency.translation` . `language_id` = ?
) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation` . `currency_id` = `sales_channel.currency` . `id`
WHERE
`sales_channel` . `id` IN (? )
Copy
SELECT `sales_channel` . `id` as `sales_channel.id` , `sales_channel` . `type_id` as `sales_channel.typeId` , `sales_channel` . `language_id` as `sales_channel.languageId` , `sales_channel` . `customer_group_id` as `sales_channel.customerGroupId` , `sales_channel` . `currency_id` as `sales_channel.currencyId` , `sales_channel` . `payment_method_id` as `sales_channel.paymentMethodId` , `sales_channel` . `shipping_method_id` as `sales_channel.shippingMethodId` , `sales_channel` . `country_id` as `sales_channel.countryId` , `sales_channel` . `analytics_id` as `sales_channel.analyticsId` , `sales_channel` . `navigation_category_id` as `sales_channel.navigationCategoryId` , `sales_channel` . `navigation_category_version_id` as `sales_channel.navigationCategoryVersionId` , `sales_channel` . `navigation_category_depth` as `sales_channel.navigationCategoryDepth` , `sales_channel` . `footer_category_id` as `sales_channel.footerCategoryId` , `sales_channel` . `footer_category_version_id` as `sales_channel.footerCategoryVersionId` , `sales_channel` . `service_category_id` as `sales_channel.serviceCategoryId` , `sales_channel` . `service_category_version_id` as `sales_channel.serviceCategoryVersionId` , `sales_channel` . `mail_header_footer_id` as `sales_channel.mailHeaderFooterId` , `sales_channel` . `hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId` , `sales_channel` . `short_name` as `sales_channel.shortName` , `sales_channel` . `tax_calculation_type` as `sales_channel.taxCalculationType` , `sales_channel` . `access_key` as `sales_channel.accessKey` , `sales_channel` . `configuration` as `sales_channel.configuration` , `sales_channel` . `active` as `sales_channel.active` , `sales_channel` . `hreflang_active` as `sales_channel.hreflangActive` , `sales_channel` . `maintenance` as `sales_channel.maintenance` , `sales_channel` . `maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist` , `sales_channel` . `payment_method_ids` as `sales_channel.paymentMethodIds` , `sales_channel` . `home_cms_page_id` as `sales_channel.homeCmsPageId` , `sales_channel` . `home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId` , `sales_channel` . `created_at` as `sales_channel.createdAt` , `sales_channel` . `updated_at` as `sales_channel.updatedAt` , `sales_channel.currency` . `id` as `sales_channel.currency.id` , `sales_channel.currency` . `factor` as `sales_channel.currency.factor` , `sales_channel.currency` . `symbol` as `sales_channel.currency.symbol` , `sales_channel.currency` . `iso_code` as `sales_channel.currency.isoCode` , `sales_channel.currency` . `position` as `sales_channel.currency.position` , `sales_channel.currency` . `tax_free_from` as `sales_channel.currency.taxFreeFrom` , `sales_channel.currency` . `item_rounding` as `sales_channel.currency.itemRounding` , `sales_channel.currency` . `total_rounding` as `sales_channel.currency.totalRounding` , `sales_channel.currency` . `created_at` as `sales_channel.currency.createdAt` , `sales_channel.currency` . `updated_at` as `sales_channel.currency.updatedAt` , `sales_channel.currency.translation.override_1.shortName` , `sales_channel.currency.translation.shortName` , COALESCE (`sales_channel.currency.translation.override_1.shortName` , `sales_channel.currency.translation.shortName` ) as `sales_channel.currency.shortName` , `sales_channel.currency.translation.override_1.name` , `sales_channel.currency.translation.name` , COALESCE (`sales_channel.currency.translation.override_1.name` , `sales_channel.currency.translation.name` ) as `sales_channel.currency.name` , `sales_channel.currency.translation.override_1.customFields` , `sales_channel.currency.translation.customFields` , COALESCE (`sales_channel.currency.translation.override_1.customFields` , `sales_channel.currency.translation.customFields` ) as `sales_channel.currency.customFields` , `sales_channel.translation.override_1.name` , `sales_channel.translation.name` , COALESCE (`sales_channel.translation.override_1.name` , `sales_channel.translation.name` ) as `sales_channel.name` , `sales_channel.translation.override_1.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` , COALESCE (`sales_channel.translation.override_1.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` ) as `sales_channel.homeSlotConfig` , `sales_channel.translation.override_1.homeEnabled` , `sales_channel.translation.homeEnabled` , COALESCE (`sales_channel.translation.override_1.homeEnabled` , `sales_channel.translation.homeEnabled` ) as `sales_channel.homeEnabled` , `sales_channel.translation.override_1.homeName` , `sales_channel.translation.homeName` , COALESCE (`sales_channel.translation.override_1.homeName` , `sales_channel.translation.homeName` ) as `sales_channel.homeName` , `sales_channel.translation.override_1.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` , COALESCE (`sales_channel.translation.override_1.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` ) as `sales_channel.homeMetaTitle` , `sales_channel.translation.override_1.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` , COALESCE (`sales_channel.translation.override_1.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` ) as `sales_channel.homeMetaDescription` , `sales_channel.translation.override_1.homeKeywords` , `sales_channel.translation.homeKeywords` , COALESCE (`sales_channel.translation.override_1.homeKeywords` , `sales_channel.translation.homeKeywords` ) as `sales_channel.homeKeywords` , `sales_channel.translation.override_1.customFields` , `sales_channel.translation.customFields` , COALESCE (`sales_channel.translation.override_1.customFields` , `sales_channel.translation.customFields` ) as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel` . `currency_id` = `sales_channel.currency` . `id` LEFT JOIN (SELECT `sales_channel.translation` . `sales_channel_id` , `sales_channel.translation` . `name` as `sales_channel.translation.name` , `sales_channel.translation.override_1` . `name` as `sales_channel.translation.override_1.name` , `sales_channel.translation` . `custom_fields` as `sales_channel.translation.customFields` , `sales_channel.translation.override_1` . `custom_fields` as `sales_channel.translation.override_1.customFields` , `sales_channel.translation` . `home_slot_config` as `sales_channel.translation.homeSlotConfig` , `sales_channel.translation.override_1` . `home_slot_config` as `sales_channel.translation.override_1.homeSlotConfig` , `sales_channel.translation` . `home_enabled` as `sales_channel.translation.homeEnabled` , `sales_channel.translation.override_1` . `home_enabled` as `sales_channel.translation.override_1.homeEnabled` , `sales_channel.translation` . `home_name` as `sales_channel.translation.homeName` , `sales_channel.translation.override_1` . `home_name` as `sales_channel.translation.override_1.homeName` , `sales_channel.translation` . `home_meta_title` as `sales_channel.translation.homeMetaTitle` , `sales_channel.translation.override_1` . `home_meta_title` as `sales_channel.translation.override_1.homeMetaTitle` , `sales_channel.translation` . `home_meta_description` as `sales_channel.translation.homeMetaDescription` , `sales_channel.translation.override_1` . `home_meta_description` as `sales_channel.translation.override_1.homeMetaDescription` , `sales_channel.translation` . `home_keywords` as `sales_channel.translation.homeKeywords` , `sales_channel.translation.override_1` . `home_keywords` as `sales_channel.translation.override_1.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` LEFT JOIN `sales_channel_translation` `sales_channel.translation.override_1` ON `sales_channel.translation` . `sales_channel_id` = `sales_channel.translation.override_1` . `sales_channel_id` AND `sales_channel.translation.override_1` . `language_id` = 0xDE44571DDC4E4D0095C01AF6EE299351 WHERE `sales_channel.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id` LEFT JOIN (SELECT `sales_channel.currency.translation` . `currency_id` , `sales_channel.currency.translation` . `short_name` as `sales_channel.currency.translation.shortName` , `sales_channel.currency.translation.override_1` . `short_name` as `sales_channel.currency.translation.override_1.shortName` , `sales_channel.currency.translation` . `name` as `sales_channel.currency.translation.name` , `sales_channel.currency.translation.override_1` . `name` as `sales_channel.currency.translation.override_1.name` , `sales_channel.currency.translation` . `custom_fields` as `sales_channel.currency.translation.customFields` , `sales_channel.currency.translation.override_1` . `custom_fields` as `sales_channel.currency.translation.override_1.customFields` FROM `currency_translation` `sales_channel.currency.translation` LEFT JOIN `currency_translation` `sales_channel.currency.translation.override_1` ON `sales_channel.currency.translation` . `currency_id` = `sales_channel.currency.translation.override_1` . `currency_id` AND `sales_channel.currency.translation.override_1` . `language_id` = 0xDE44571DDC4E4D0095C01AF6EE299351 WHERE `sales_channel.currency.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation` . `currency_id` = `sales_channel.currency` . `id` WHERE `sales_channel` . `id` IN (0xBC03B12FCA6E446C9BBE735AE1F4D0CE );
Copy
0.96 ms
2
SELECT seo_path_info FROM seo_url WHERE (language_id = ? ) AND ((sales_channel_id = ? OR sales_channel_id IS NULL )) AND (seo_path_info = ? ) AND (is_canonical = ? ) AND (is_deleted = ? ) ORDER BY seo_path_info ASC , sales_channel_id IS NULL ASC LIMIT 1
Parameters :
[
b"ÞDW\x1D ÜNM\x00 •À\x1A öî)“Q "
b"¼\x03 ±/ÊnDl›¾sZáôÐÎ "
"garage "
1
0
]
SELECT seo_path_info FROM seo_url WHERE (language_id = 0xDE44571DDC4E4D0095C01AF6EE299351 ) AND ((sales_channel_id = 0xBC03B12FCA6E446C9BBE735AE1F4D0CE OR sales_channel_id IS NULL )) AND (seo_path_info = 'garage' ) AND (is_canonical = 1 ) AND (is_deleted = 0 ) ORDER BY seo_path_info ASC , sales_channel_id IS NULL ASC LIMIT 1 ; Copy
0.75 ms
1
SELECT CONCAT (TRIM (TRAILING '/' FROM domain . url ), '/' ) `key` , CONCAT (TRIM (TRAILING '/' FROM domain . url ), '/' ) url , LOWER (HEX (domain . id )) id , LOWER (HEX (sales_channel . id )) salesChannelId , LOWER (HEX (sales_channel . type_id )) typeId , LOWER (HEX (domain . snippet_set_id )) snippetSetId , LOWER (HEX (domain . currency_id )) currencyId , LOWER (HEX (domain . language_id )) languageId , LOWER (HEX (theme . id )) themeId , sales_channel . maintenance maintenance , sales_channel . maintenance_ip_whitelist maintenanceIpWhitelist , snippet_set . iso as locale , theme . technical_name as themeName , parentTheme . technical_name as parentThemeName FROM sales_channel INNER JOIN sales_channel_domain domain ON domain . sales_channel_id = sales_channel . id LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel . id = theme_sales_channel . sales_channel_id INNER JOIN snippet_set snippet_set ON snippet_set . id = domain . snippet_set_id LEFT JOIN theme theme ON theme_sales_channel . theme_id = theme . id LEFT JOIN theme parentTheme ON theme . parent_theme_id = parentTheme . id WHERE (sales_channel . type_id = UNHEX (? )) AND (sales_channel . active )
Parameters :
[
"8a243080f92e4c719546314b577cf82b "
]
SELECT CONCAT (TRIM (TRAILING '/' FROM domain . url ), '/' ) `key` , CONCAT (TRIM (TRAILING '/' FROM domain . url ), '/' ) url , LOWER (HEX (domain . id )) id , LOWER (HEX (sales_channel . id )) salesChannelId , LOWER (HEX (sales_channel . type_id )) typeId , LOWER (HEX (domain . snippet_set_id )) snippetSetId , LOWER (HEX (domain . currency_id )) currencyId , LOWER (HEX (domain . language_id )) languageId , LOWER (HEX (theme . id )) themeId , sales_channel . maintenance maintenance , sales_channel . maintenance_ip_whitelist maintenanceIpWhitelist , snippet_set . iso as locale , theme . technical_name as themeName , parentTheme . technical_name as parentThemeName FROM sales_channel INNER JOIN sales_channel_domain domain ON domain . sales_channel_id = sales_channel . id LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel . id = theme_sales_channel . sales_channel_id INNER JOIN snippet_set snippet_set ON snippet_set . id = domain . snippet_set_id LEFT JOIN theme theme ON theme_sales_channel . theme_id = theme . id LEFT JOIN theme parentTheme ON theme . parent_theme_id = parentTheme . id WHERE (sales_channel . type_id = UNHEX ('8a243080f92e4c719546314b577cf82b' )) AND (sales_channel . active ); Copy
0.74 ms
3
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 ‹®u*\x01 rå¸\x06 @h%Ze1 ]
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 (0x018BAE752A0172E5B8064068255A6531 )); Copy
0.70 ms
1
SELECT `tax_rule` . `id` as `tax_rule.id` , `tax_rule` . `tax_rule_type_id` as `tax_rule.taxRuleTypeId` , `tax_rule` . `country_id` as `tax_rule.countryId` , `tax_rule` . `tax_rate` as `tax_rule.taxRate` , `tax_rule` . `data` as `tax_rule.data` , `tax_rule` . `tax_id` as `tax_rule.taxId` , `tax_rule` . `active_from` as `tax_rule.activeFrom` , `tax_rule` . `created_at` as `tax_rule.createdAt` , `tax_rule` . `updated_at` as `tax_rule.updatedAt` , `tax_rule.type` . `id` as `tax_rule.type.id` , `tax_rule.type` . `technical_name` as `tax_rule.type.technicalName` , `tax_rule.type` . `position` as `tax_rule.type.position` , `tax_rule.type` . `created_at` as `tax_rule.type.createdAt` , `tax_rule.type` . `updated_at` as `tax_rule.type.updatedAt` , `tax_rule.type.translation.override_1.typeName` , `tax_rule.type.translation.typeName` , COALESCE (`tax_rule.type.translation.override_1.typeName` , `tax_rule.type.translation.typeName` ) as `tax_rule.type.typeName` FROM `tax_rule` LEFT JOIN `tax_rule_type` `tax_rule.type` ON `tax_rule` . `tax_rule_type_id` = `tax_rule.type` . `id` LEFT JOIN (SELECT `tax_rule.type.translation` . `tax_rule_type_id` , `tax_rule.type.translation` . `type_name` as `tax_rule.type.translation.typeName` , `tax_rule.type.translation.override_1` . `type_name` as `tax_rule.type.translation.override_1.typeName` FROM `tax_rule_type_translation` `tax_rule.type.translation` LEFT JOIN `tax_rule_type_translation` `tax_rule.type.translation.override_1` ON `tax_rule.type.translation` . `tax_rule_type_id` = `tax_rule.type.translation.override_1` . `tax_rule_type_id` AND `tax_rule.type.translation.override_1` . `language_id` = ? WHERE `tax_rule.type.translation` . `language_id` = ? ) `tax_rule.type.tax_rule_type_translation` ON `tax_rule.type.tax_rule_type_translation` . `tax_rule_type_id` = `tax_rule.type` . `id` WHERE (`tax_rule` . `tax_id` IN (? , ? , ? ))
Parameters :
[
b"ÞDW\x1D ÜNM\x00 •À\x1A öî)“Q "
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x07 £Ü\x01 ‡fI£¤\x15 ºß-ÝH˜bbºù\x@êÉî¥ò©G▄û "
b"¯nïÕ•™B\x1E ß÷@“Ã\x1E ½ "
]
SELECT `tax_rule` . `id` as `tax_rule.id` , `tax_rule` . `tax_rule_type_id` as `tax_rule.taxRuleTypeId` , `tax_rule` . `country_id` as `tax_rule.countryId` , `tax_rule` . `tax_rate` as `tax_rule.taxRate` , `tax_rule` . `data` as `tax_rule.data` , `tax_rule` . `tax_id` as `tax_rule.taxId` , `tax_rule` . `active_from` as `tax_rule.activeFrom` , `tax_rule` . `created_at` as `tax_rule.createdAt` , `tax_rule` . `updated_at` as `tax_rule.updatedAt` , `tax_rule.type` . `id` as `tax_rule.type.id` , `tax_rule.type` . `technical_name` as `tax_rule.type.technicalName` , `tax_rule.type` . `position` as `tax_rule.type.position` , `tax_rule.type` . `created_at` as `tax_rule.type.createdAt` , `tax_rule.type` . `updated_at` as `tax_rule.type.updatedAt` , `tax_rule.type.translation.override_1.typeName` , `tax_rule.type.translation.typeName` , COALESCE (`tax_rule.type.translation.override_1.typeName` , `tax_rule.type.translation.typeName` ) as `tax_rule.type.typeName` FROM `tax_rule` LEFT JOIN `tax_rule_type` `tax_rule.type` ON `tax_rule` . `tax_rule_type_id` = `tax_rule.type` . `id` LEFT JOIN (SELECT `tax_rule.type.translation` . `tax_rule_type_id` , `tax_rule.type.translation` . `type_name` as `tax_rule.type.translation.typeName` , `tax_rule.type.translation.override_1` . `type_name` as `tax_rule.type.translation.override_1.typeName` FROM `tax_rule_type_translation` `tax_rule.type.translation` LEFT JOIN `tax_rule_type_translation` `tax_rule.type.translation.override_1` ON `tax_rule.type.translation` . `tax_rule_type_id` = `tax_rule.type.translation.override_1` . `tax_rule_type_id` AND `tax_rule.type.translation.override_1` . `language_id` = 0xDE44571DDC4E4D0095C01AF6EE299351 WHERE `tax_rule.type.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `tax_rule.type.tax_rule_type_translation` ON `tax_rule.type.tax_rule_type_translation` . `tax_rule_type_id` = `tax_rule.type` . `id` WHERE (`tax_rule` . `tax_id` IN (0x07A3DC01876649A3A415BADF2DDD4898 , 0x6262A7975C784088908CBE95B847DC96 , 0xAF6EEFD59599421EA0DFF74093C31EBD ));
Copy
0.62 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.50 ms
1
SELECT `dreisc_seo_redirect` . `id` as `dreisc_seo_redirect.id` , `dreisc_seo_redirect` . `active` as `dreisc_seo_redirect.active` , `dreisc_seo_redirect` . `redirect_http_status_code` as `dreisc_seo_redirect.redirectHttpStatusCode` , `dreisc_seo_redirect` . `source_type` as `dreisc_seo_redirect.sourceType` , `dreisc_seo_redirect` . `has_source_sales_channel_domain_restriction` as `dreisc_seo_redirect.hasSourceSalesChannelDomainRestriction` , `dreisc_seo_redirect` . `source_sales_channel_domain_restriction_ids` as `dreisc_seo_redirect.sourceSalesChannelDomainRestrictionIds` , `dreisc_seo_redirect` . `source_sales_channel_domain_id` as `dreisc_seo_redirect.sourceSalesChannelDomainId` , `dreisc_seo_redirect` . `source_path` as `dreisc_seo_redirect.sourcePath` , `dreisc_seo_redirect` . `source_product_id` as `dreisc_seo_redirect.sourceProductId` , `dreisc_seo_redirect` . `source_product_version_id` as `dreisc_seo_redirect.sourceProductVersionId` , `dreisc_seo_redirect` . `source_category_id` as `dreisc_seo_redirect.sourceCategoryId` , `dreisc_seo_redirect` . `source_category_version_id` as `dreisc_seo_redirect.sourceCategoryVersionId` , `dreisc_seo_redirect` . `redirect_type` as `dreisc_seo_redirect.redirectType` , `dreisc_seo_redirect` . `redirect_url` as `dreisc_seo_redirect.redirectUrl` , `dreisc_seo_redirect` . `redirect_sales_channel_domain_id` as `dreisc_seo_redirect.redirectSalesChannelDomainId` , `dreisc_seo_redirect` . `redirect_path` as `dreisc_seo_redirect.redirectPath` , `dreisc_seo_redirect` . `redirect_product_id` as `dreisc_seo_redirect.redirectProductId` , `dreisc_seo_redirect` . `redirect_product_version_id` as `dreisc_seo_redirect.redirectProductVersionId` , `dreisc_seo_redirect` . `redirect_category_id` as `dreisc_seo_redirect.redirectCategoryId` , `dreisc_seo_redirect` . `redirect_category_version_id` as `dreisc_seo_redirect.redirectCategoryVersionId` , `dreisc_seo_redirect` . `has_deviating_redirect_sales_channel_domain` as `dreisc_seo_redirect.hasDeviatingRedirectSalesChannelDomain` , `dreisc_seo_redirect` . `deviating_redirect_sales_channel_domain_id` as `dreisc_seo_redirect.deviatingRedirectSalesChannelDomainId` , `dreisc_seo_redirect` . `parameter_forwarding` as `dreisc_seo_redirect.parameterForwarding` , `dreisc_seo_redirect` . `created_at` as `dreisc_seo_redirect.createdAt` , `dreisc_seo_redirect` . `updated_at` as `dreisc_seo_redirect.updatedAt` FROM `dreisc_seo_redirect` WHERE ((`dreisc_seo_redirect` . `active` = ? AND `dreisc_seo_redirect` . `source_type` = ? AND `dreisc_seo_redirect` . `source_sales_channel_domain_id` = ? AND `dreisc_seo_redirect` . `source_path` = ? ))
Parameters :
[
true
"url "
b"\x01 ìT;Ü\vg▒░\e\f K£]ègarage "
]
SELECT `dreisc_seo_redirect` . `id` as `dreisc_seo_redirect.id` , `dreisc_seo_redirect` . `active` as `dreisc_seo_redirect.active` , `dreisc_seo_redirect` . `redirect_http_status_code` as `dreisc_seo_redirect.redirectHttpStatusCode` , `dreisc_seo_redirect` . `source_type` as `dreisc_seo_redirect.sourceType` , `dreisc_seo_redirect` . `has_source_sales_channel_domain_restriction` as `dreisc_seo_redirect.hasSourceSalesChannelDomainRestriction` , `dreisc_seo_redirect` . `source_sales_channel_domain_restriction_ids` as `dreisc_seo_redirect.sourceSalesChannelDomainRestrictionIds` , `dreisc_seo_redirect` . `source_sales_channel_domain_id` as `dreisc_seo_redirect.sourceSalesChannelDomainId` , `dreisc_seo_redirect` . `source_path` as `dreisc_seo_redirect.sourcePath` , `dreisc_seo_redirect` . `source_product_id` as `dreisc_seo_redirect.sourceProductId` , `dreisc_seo_redirect` . `source_product_version_id` as `dreisc_seo_redirect.sourceProductVersionId` , `dreisc_seo_redirect` . `source_category_id` as `dreisc_seo_redirect.sourceCategoryId` , `dreisc_seo_redirect` . `source_category_version_id` as `dreisc_seo_redirect.sourceCategoryVersionId` , `dreisc_seo_redirect` . `redirect_type` as `dreisc_seo_redirect.redirectType` , `dreisc_seo_redirect` . `redirect_url` as `dreisc_seo_redirect.redirectUrl` , `dreisc_seo_redirect` . `redirect_sales_channel_domain_id` as `dreisc_seo_redirect.redirectSalesChannelDomainId` , `dreisc_seo_redirect` . `redirect_path` as `dreisc_seo_redirect.redirectPath` , `dreisc_seo_redirect` . `redirect_product_id` as `dreisc_seo_redirect.redirectProductId` , `dreisc_seo_redirect` . `redirect_product_version_id` as `dreisc_seo_redirect.redirectProductVersionId` , `dreisc_seo_redirect` . `redirect_category_id` as `dreisc_seo_redirect.redirectCategoryId` , `dreisc_seo_redirect` . `redirect_category_version_id` as `dreisc_seo_redirect.redirectCategoryVersionId` , `dreisc_seo_redirect` . `has_deviating_redirect_sales_channel_domain` as `dreisc_seo_redirect.hasDeviatingRedirectSalesChannelDomain` , `dreisc_seo_redirect` . `deviating_redirect_sales_channel_domain_id` as `dreisc_seo_redirect.deviatingRedirectSalesChannelDomainId` , `dreisc_seo_redirect` . `parameter_forwarding` as `dreisc_seo_redirect.parameterForwarding` , `dreisc_seo_redirect` . `created_at` as `dreisc_seo_redirect.createdAt` , `dreisc_seo_redirect` . `updated_at` as `dreisc_seo_redirect.updatedAt` FROM `dreisc_seo_redirect` WHERE ((`dreisc_seo_redirect` . `active` = 1 AND `dreisc_seo_redirect` . `source_type` = 'url' AND `dreisc_seo_redirect` . `source_sales_channel_domain_id` = 0x018D543B9A5C7667B1B01B0C4B9C5D8A AND `dreisc_seo_redirect` . `source_path` = 'garage' )); Copy
0.50 ms
1
SELECT `app` . `id` FROM `app` WHERE (`app` . `active` = ? )
SELECT `app` . `id` FROM `app` WHERE (`app` . `active` = 1 );
Copy
0.48 ms
1
SELECT `customer_group` . `id` as `customer_group.id` , `customer_group` . `display_gross` as `customer_group.displayGross` , `customer_group` . `registration_active` as `customer_group.registrationActive` , `customer_group` . `created_at` as `customer_group.createdAt` , `customer_group` . `updated_at` as `customer_group.updatedAt` , `customer_group.translation.override_1.name` , `customer_group.translation.name` , COALESCE (`customer_group.translation.override_1.name` , `customer_group.translation.name` ) as `customer_group.name` , `customer_group.translation.override_1.registrationTitle` , `customer_group.translation.registrationTitle` , COALESCE (`customer_group.translation.override_1.registrationTitle` , `customer_group.translation.registrationTitle` ) as `customer_group.registrationTitle` , `customer_group.translation.override_1.registrationIntroduction` , `customer_group.translation.registrationIntroduction` , COALESCE (`customer_group.translation.override_1.registrationIntroduction` , `customer_group.translation.registrationIntroduction` ) as `customer_group.registrationIntroduction` , `customer_group.translation.override_1.registrationOnlyCompanyRegistration` , `customer_group.translation.registrationOnlyCompanyRegistration` , COALESCE (`customer_group.translation.override_1.registrationOnlyCompanyRegistration` , `customer_group.translation.registrationOnlyCompanyRegistration` ) as `customer_group.registrationOnlyCompanyRegistration` , `customer_group.translation.override_1.registrationSeoMetaDescription` , `customer_group.translation.registrationSeoMetaDescription` , COALESCE (`customer_group.translation.override_1.registrationSeoMetaDescription` , `customer_group.translation.registrationSeoMetaDescription` ) as `customer_group.registrationSeoMetaDescription` , `customer_group.translation.override_1.customFields` , `customer_group.translation.customFields` , COALESCE (`customer_group.translation.override_1.customFields` , `customer_group.translation.customFields` ) as `customer_group.customFields` FROM `customer_group` LEFT JOIN (SELECT `customer_group.translation` . `customer_group_id` , `customer_group.translation` . `name` as `customer_group.translation.name` , `customer_group.translation.override_1` . `name` as `customer_group.translation.override_1.name` , `customer_group.translation` . `custom_fields` as `customer_group.translation.customFields` , `customer_group.translation.override_1` . `custom_fields` as `customer_group.translation.override_1.customFields` , `customer_group.translation` . `registration_title` as `customer_group.translation.registrationTitle` , `customer_group.translation.override_1` . `registration_title` as `customer_group.translation.override_1.registrationTitle` , `customer_group.translation` . `registration_introduction` as `customer_group.translation.registrationIntroduction` , `customer_group.translation.override_1` . `registration_introduction` as `customer_group.translation.override_1.registrationIntroduction` , `customer_group.translation` . `registration_only_company_registration` as `customer_group.translation.registrationOnlyCompanyRegistration` , `customer_group.translation.override_1` . `registration_only_company_registration` as `customer_group.translation.override_1.registrationOnlyCompanyRegistration` , `customer_group.translation` . `registration_seo_meta_description` as `customer_group.translation.registrationSeoMetaDescription` , `customer_group.translation.override_1` . `registration_seo_meta_description` as `customer_group.translation.override_1.registrationSeoMetaDescription` FROM `customer_group_translation` `customer_group.translation` LEFT JOIN `customer_group_translation` `customer_group.translation.override_1` ON `customer_group.translation` . `customer_group_id` = `customer_group.translation.override_1` . `customer_group_id` AND `customer_group.translation.override_1` . `language_id` = ? WHERE `customer_group.translation` . `language_id` = ? ) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation` . `customer_group_id` = `customer_group` . `id` WHERE `customer_group` . `id` IN (? )
Parameters :
[
b"ÞDW\x1D ÜNM\x00 •À\x1A öî)“Q "
b"/»_ââšMpªXTÎ|ãâ\v "
b"""
\n ®áª\x03 DG%£Õc4 0ºÅ
"""
]
SELECT
`customer_group` . `id` as `customer_group.id` ,
`customer_group` . `display_gross` as `customer_group.displayGross` ,
`customer_group` . `registration_active` as `customer_group.registrationActive` ,
`customer_group` . `created_at` as `customer_group.createdAt` ,
`customer_group` . `updated_at` as `customer_group.updatedAt` ,
`customer_group.translation.override_1.name` ,
`customer_group.translation.name` ,
COALESCE (
`customer_group.translation.override_1.name` ,
`customer_group.translation.name`
) as `customer_group.name` ,
`customer_group.translation.override_1.registrationTitle` ,
`customer_group.translation.registrationTitle` ,
COALESCE (
`customer_group.translation.override_1.registrationTitle` ,
`customer_group.translation.registrationTitle`
) as `customer_group.registrationTitle` ,
`customer_group.translation.override_1.registrationIntroduction` ,
`customer_group.translation.registrationIntroduction` ,
COALESCE (
`customer_group.translation.override_1.registrationIntroduction` ,
`customer_group.translation.registrationIntroduction`
) as `customer_group.registrationIntroduction` ,
`customer_group.translation.override_1.registrationOnlyCompanyRegistration` ,
`customer_group.translation.registrationOnlyCompanyRegistration` ,
COALESCE (
`customer_group.translation.override_1.registrationOnlyCompanyRegistration` ,
`customer_group.translation.registrationOnlyCompanyRegistration`
) as `customer_group.registrationOnlyCompanyRegistration` ,
`customer_group.translation.override_1.registrationSeoMetaDescription` ,
`customer_group.translation.registrationSeoMetaDescription` ,
COALESCE (
`customer_group.translation.override_1.registrationSeoMetaDescription` ,
`customer_group.translation.registrationSeoMetaDescription`
) as `customer_group.registrationSeoMetaDescription` ,
`customer_group.translation.override_1.customFields` ,
`customer_group.translation.customFields` ,
COALESCE (
`customer_group.translation.override_1.customFields` ,
`customer_group.translation.customFields`
) as `customer_group.customFields`
FROM
`customer_group`
LEFT JOIN (
SELECT
`customer_group.translation` . `customer_group_id` ,
`customer_group.translation` . `name` as `customer_group.translation.name` ,
`customer_group.translation.override_1` . `name` as `customer_group.translation.override_1.name` ,
`customer_group.translation` . `custom_fields` as `customer_group.translation.customFields` ,
`customer_group.translation.override_1` . `custom_fields` as `customer_group.translation.override_1.customFields` ,
`customer_group.translation` . `registration_title` as `customer_group.translation.registrationTitle` ,
`customer_group.translation.override_1` . `registration_title` as `customer_group.translation.override_1.registrationTitle` ,
`customer_group.translation` . `registration_introduction` as `customer_group.translation.registrationIntroduction` ,
`customer_group.translation.override_1` . `registration_introduction` as `customer_group.translation.override_1.registrationIntroduction` ,
`customer_group.translation` . `registration_only_company_registration` as `customer_group.translation.registrationOnlyCompanyRegistration` ,
`customer_group.translation.override_1` . `registration_only_company_registration` as `customer_group.translation.override_1.registrationOnlyCompanyRegistration` ,
`customer_group.translation` . `registration_seo_meta_description` as `customer_group.translation.registrationSeoMetaDescription` ,
`customer_group.translation.override_1` . `registration_seo_meta_description` as `customer_group.translation.override_1.registrationSeoMetaDescription`
FROM
`customer_group_translation` `customer_group.translation`
LEFT JOIN `customer_group_translation` `customer_group.translation.override_1` ON `customer_group.translation` . `customer_group_id` = `customer_group.translation.override_1` . `customer_group_id`
AND `customer_group.translation.override_1` . `language_id` = ?
WHERE
`customer_group.translation` . `language_id` = ?
) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation` . `customer_group_id` = `customer_group` . `id`
WHERE
`customer_group` . `id` IN (? )
Copy
SELECT `customer_group` . `id` as `customer_group.id` , `customer_group` . `display_gross` as `customer_group.displayGross` , `customer_group` . `registration_active` as `customer_group.registrationActive` , `customer_group` . `created_at` as `customer_group.createdAt` , `customer_group` . `updated_at` as `customer_group.updatedAt` , `customer_group.translation.override_1.name` , `customer_group.translation.name` , COALESCE (`customer_group.translation.override_1.name` , `customer_group.translation.name` ) as `customer_group.name` , `customer_group.translation.override_1.registrationTitle` , `customer_group.translation.registrationTitle` , COALESCE (`customer_group.translation.override_1.registrationTitle` , `customer_group.translation.registrationTitle` ) as `customer_group.registrationTitle` , `customer_group.translation.override_1.registrationIntroduction` , `customer_group.translation.registrationIntroduction` , COALESCE (`customer_group.translation.override_1.registrationIntroduction` , `customer_group.translation.registrationIntroduction` ) as `customer_group.registrationIntroduction` , `customer_group.translation.override_1.registrationOnlyCompanyRegistration` , `customer_group.translation.registrationOnlyCompanyRegistration` , COALESCE (`customer_group.translation.override_1.registrationOnlyCompanyRegistration` , `customer_group.translation.registrationOnlyCompanyRegistration` ) as `customer_group.registrationOnlyCompanyRegistration` , `customer_group.translation.override_1.registrationSeoMetaDescription` , `customer_group.translation.registrationSeoMetaDescription` , COALESCE (`customer_group.translation.override_1.registrationSeoMetaDescription` , `customer_group.translation.registrationSeoMetaDescription` ) as `customer_group.registrationSeoMetaDescription` , `customer_group.translation.override_1.customFields` , `customer_group.translation.customFields` , COALESCE (`customer_group.translation.override_1.customFields` , `customer_group.translation.customFields` ) as `customer_group.customFields` FROM `customer_group` LEFT JOIN (SELECT `customer_group.translation` . `customer_group_id` , `customer_group.translation` . `name` as `customer_group.translation.name` , `customer_group.translation.override_1` . `name` as `customer_group.translation.override_1.name` , `customer_group.translation` . `custom_fields` as `customer_group.translation.customFields` , `customer_group.translation.override_1` . `custom_fields` as `customer_group.translation.override_1.customFields` , `customer_group.translation` . `registration_title` as `customer_group.translation.registrationTitle` , `customer_group.translation.override_1` . `registration_title` as `customer_group.translation.override_1.registrationTitle` , `customer_group.translation` . `registration_introduction` as `customer_group.translation.registrationIntroduction` , `customer_group.translation.override_1` . `registration_introduction` as `customer_group.translation.override_1.registrationIntroduction` , `customer_group.translation` . `registration_only_company_registration` as `customer_group.translation.registrationOnlyCompanyRegistration` , `customer_group.translation.override_1` . `registration_only_company_registration` as `customer_group.translation.override_1.registrationOnlyCompanyRegistration` , `customer_group.translation` . `registration_seo_meta_description` as `customer_group.translation.registrationSeoMetaDescription` , `customer_group.translation.override_1` . `registration_seo_meta_description` as `customer_group.translation.override_1.registrationSeoMetaDescription` FROM `customer_group_translation` `customer_group.translation` LEFT JOIN `customer_group_translation` `customer_group.translation.override_1` ON `customer_group.translation` . `customer_group_id` = `customer_group.translation.override_1` . `customer_group_id` AND `customer_group.translation.override_1` . `language_id` = 0xDE44571DDC4E4D0095C01AF6EE299351 WHERE `customer_group.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation` . `customer_group_id` = `customer_group` . `id` WHERE `customer_group` . `id` IN (0x0AAEE1AA03444725A3D563342030BAC5 );
Copy
0.47 ms
1
SELECT
sales_channel . id as sales_channel_id ,
sales_channel . language_id as sales_channel_default_language_id ,
sales_channel . currency_id as sales_channel_currency_id ,
currency . factor as sales_channel_currency_factor ,
GROUP_CONCAT (LOWER (HEX (sales_channel_language . language_id ))) as sales_channel_language_ids
FROM sales_channel
INNER JOIN currency
ON sales_channel . currency_id = currency . id
LEFT JOIN sales_channel_language
ON sales_channel_language . sales_channel_id = sales_channel . id
WHERE sales_channel . id = ?
GROUP BY sales_channel . id , sales_channel . language_id , sales_channel . currency_id , currency . factor
Parameters :
[
b"¼\x03 ±/ÊnDl›¾sZáôÐÎ "
]
SELECT
sales_channel . id as sales_channel_id ,
sales_channel . language_id as sales_channel_default_language_id ,
sales_channel . currency_id as sales_channel_currency_id ,
currency . factor as sales_channel_currency_factor ,
GROUP_CONCAT (LOWER (HEX (sales_channel_language . language_id ))) as sales_channel_language_ids
FROM sales_channel
INNER JOIN currency
ON sales_channel . currency_id = currency . id
LEFT JOIN sales_channel_language
ON sales_channel_language . sales_channel_id = sales_channel . id
WHERE sales_channel . id = 0xBC03B12FCA6E446C9BBE735AE1F4D0CE
GROUP BY sales_channel . id , sales_channel . language_id , sales_channel . currency_id , currency . factor ;
Copy
0.47 ms
1
SELECT LOWER (HEX (`script` . `app_id` )) as `app_id` ,
`script` . `name` AS scriptName ,
`script` . `script` AS script ,
`script` . `hook` AS hook ,
IFNULL (`script` . `updated_at` , `script` . `created_at` ) AS lastModified ,
`app` . `name` AS appName ,
LOWER (HEX (`app` . `integration_id` )) AS integrationId ,
`app` . `version` AS appVersion ,
`script` . `active` AS active
FROM `script`
LEFT JOIN `app` ON `script` . `app_id` = `app` . `id`
WHERE `script` . `hook` ! = 'include'
ORDER BY `app` . `created_at` , `app` . `id` , `script` . `name`
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
0.47 ms
1
SELECT `rule` . `id` FROM `rule` WHERE (`rule` . `invalid` = ? ) ORDER BY `rule` . `priority` DESC , `rule` . `id` ASC LIMIT 500
SELECT `rule` . `id` FROM `rule` WHERE (`rule` . `invalid` = 0 ) ORDER BY `rule` . `priority` DESC , `rule` . `id` ASC LIMIT 500 ;
Copy
0.44 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.override_1.shortName` , `currency.translation.shortName` , COALESCE (`currency.translation.override_1.shortName` , `currency.translation.shortName` ) as `currency.shortName` , `currency.translation.override_1.name` , `currency.translation.name` , COALESCE (`currency.translation.override_1.name` , `currency.translation.name` ) as `currency.name` , `currency.translation.override_1.customFields` , `currency.translation.customFields` , COALESCE (`currency.translation.override_1.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.override_1` . `short_name` as `currency.translation.override_1.shortName` , `currency.translation` . `name` as `currency.translation.name` , `currency.translation.override_1` . `name` as `currency.translation.override_1.name` , `currency.translation` . `custom_fields` as `currency.translation.customFields` , `currency.translation.override_1` . `custom_fields` as `currency.translation.override_1.customFields` FROM `currency_translation` `currency.translation` LEFT JOIN `currency_translation` `currency.translation.override_1` ON `currency.translation` . `currency_id` = `currency.translation.override_1` . `currency_id` AND `currency.translation.override_1` . `language_id` = ? WHERE `currency.translation` . `language_id` = ? ) `currency.currency_translation` ON `currency.currency_translation` . `currency_id` = `currency` . `id` WHERE `currency` . `id` IN (? )
Parameters :
[
b"ÞDW\x1D ÜNM\x00 •À\x1A öî)“Q "
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.override_1.shortName` , `currency.translation.shortName` , COALESCE (`currency.translation.override_1.shortName` , `currency.translation.shortName` ) as `currency.shortName` , `currency.translation.override_1.name` , `currency.translation.name` , COALESCE (`currency.translation.override_1.name` , `currency.translation.name` ) as `currency.name` , `currency.translation.override_1.customFields` , `currency.translation.customFields` , COALESCE (`currency.translation.override_1.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.override_1` . `short_name` as `currency.translation.override_1.shortName` , `currency.translation` . `name` as `currency.translation.name` , `currency.translation.override_1` . `name` as `currency.translation.override_1.name` , `currency.translation` . `custom_fields` as `currency.translation.customFields` , `currency.translation.override_1` . `custom_fields` as `currency.translation.override_1.customFields` FROM `currency_translation` `currency.translation` LEFT JOIN `currency_translation` `currency.translation.override_1` ON `currency.translation` . `currency_id` = `currency.translation.override_1` . `currency_id` AND `currency.translation.override_1` . `language_id` = 0xDE44571DDC4E4D0095C01AF6EE299351 WHERE `currency.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `currency.currency_translation` ON `currency.currency_translation` . `currency_id` = `currency` . `id` WHERE `currency` . `id` IN (0xB7D2554B0CE847CD82F3AC9BD1C0DFCA );
Copy
0.43 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.43 ms
1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1 ; Copy
0.42 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.override_1.name` , `country.translation.name` , COALESCE (`country.translation.override_1.name` , `country.translation.name` ) as `country.name` , `country.translation.override_1.addressFormat` , `country.translation.addressFormat` , COALESCE (`country.translation.override_1.addressFormat` , `country.translation.addressFormat` ) as `country.addressFormat` , `country.translation.override_1.customFields` , `country.translation.customFields` , COALESCE (`country.translation.override_1.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.override_1` . `name` as `country.translation.override_1.name` , `country.translation` . `custom_fields` as `country.translation.customFields` , `country.translation.override_1` . `custom_fields` as `country.translation.override_1.customFields` , `country.translation` . `address_format` as `country.translation.addressFormat` , `country.translation.override_1` . `address_format` as `country.translation.override_1.addressFormat` FROM `country_translation` `country.translation` LEFT JOIN `country_translation` `country.translation.override_1` ON `country.translation` . `country_id` = `country.translation.override_1` . `country_id` AND `country.translation.override_1` . `language_id` = ? WHERE `country.translation` . `language_id` = ? ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` WHERE `country` . `id` IN (? )
Parameters :
[
b"ÞDW\x1D ÜNM\x00 •À\x1A öî)“Q "
b"/»_ââšMpªXTÎ|ãâ\v "
b"_•ŸcÈ1MšƒË\x17 ‘’\x03 ‹Ý "
]
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.override_1.name` , `country.translation.name` , COALESCE (`country.translation.override_1.name` , `country.translation.name` ) as `country.name` , `country.translation.override_1.addressFormat` , `country.translation.addressFormat` , COALESCE (`country.translation.override_1.addressFormat` , `country.translation.addressFormat` ) as `country.addressFormat` , `country.translation.override_1.customFields` , `country.translation.customFields` , COALESCE (`country.translation.override_1.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.override_1` . `name` as `country.translation.override_1.name` , `country.translation` . `custom_fields` as `country.translation.customFields` , `country.translation.override_1` . `custom_fields` as `country.translation.override_1.customFields` , `country.translation` . `address_format` as `country.translation.addressFormat` , `country.translation.override_1` . `address_format` as `country.translation.override_1.addressFormat` FROM `country_translation` `country.translation` LEFT JOIN `country_translation` `country.translation.override_1` ON `country.translation` . `country_id` = `country.translation.override_1` . `country_id` AND `country.translation.override_1` . `language_id` = 0xDE44571DDC4E4D0095C01AF6EE299351 WHERE `country.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` WHERE `country` . `id` IN (0x5F959F63C8314D9A83CB179192038BDD );
Copy
0.37 ms
1
SELECT id , path_info pathInfo , is_canonical isCanonical , sales_channel_id salesChannelId , is_deleted isDeleted 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"ÞDW\x1D ÜNM\x00 •À\x1A öî)“Q "
b"¼\x03 ±/ÊnDl›¾sZáôÐÎ "
"garage "
"garage/ "
]
SELECT id , path_info pathInfo , is_canonical isCanonical , sales_channel_id salesChannelId , is_deleted isDeleted FROM seo_url WHERE (language_id = 0xDE44571DDC4E4D0095C01AF6EE299351 ) AND ((sales_channel_id = 0xBC03B12FCA6E446C9BBE735AE1F4D0CE OR sales_channel_id IS NULL )) AND ((seo_path_info = 'garage' OR seo_path_info = 'garage/' ));
Copy
0.35 ms
1
SELECT `currency_country_rounding` . `id` FROM `currency_country_rounding` WHERE (`currency_country_rounding` . `currency_id` = ? AND `currency_country_rounding` . `country_id` = ? ) LIMIT 1
Parameters :
[
b"·ÒUK\f èGÍ‚ó¬›ÑÀßÊ "
b"_•ŸcÈ1MšƒË\x17 ‘’\x03 ‹Ý "
]
SELECT `currency_country_rounding` . `id` FROM `currency_country_rounding` WHERE (`currency_country_rounding` . `currency_id` = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA AND `currency_country_rounding` . `country_id` = 0x5F959F63C8314D9A83CB179192038BDD ) LIMIT 1 ;
Copy
0.33 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"ÞDW\x1D ÜNM\x00 •À\x1A öî)“Q "
b"¼\x03 ±/ÊnDl›¾sZáôÐÎ "
"/garage "
]
SELECT path_info pathInfo , seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0xDE44571DDC4E4D0095C01AF6EE299351 ) AND (sales_channel_id = 0xBC03B12FCA6E446C9BBE735AE1F4D0CE ) AND (path_info = '/garage' ) AND (is_canonical = 1 ) LIMIT 1 ;
Copy
0.33 ms
1
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ? ) AND (token = ? ) LIMIT 1
Parameters :
[
b"¼\x03 ±/ÊnDl›¾sZáôÐÎ "
"pxeEnT8H9u4QHn4v3bYadDrJxVfQ3KRG "
]
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0xBC03B12FCA6E446C9BBE735AE1F4D0CE ) AND (token = 'pxeEnT8H9u4QHn4v3bYadDrJxVfQ3KRG' ) LIMIT 1 ; Copy
0.33 ms
1
SELECT `sales_channel_domain` . `id` as `sales_channel_domain.id` , `sales_channel_domain` . `url` as `sales_channel_domain.url` , `sales_channel_domain` . `sales_channel_id` as `sales_channel_domain.salesChannelId` , `sales_channel_domain` . `language_id` as `sales_channel_domain.languageId` , `sales_channel_domain` . `currency_id` as `sales_channel_domain.currencyId` , `sales_channel_domain` . `snippet_set_id` as `sales_channel_domain.snippetSetId` , `sales_channel_domain` . `hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale` , `sales_channel_domain` . `custom_fields` as `sales_channel_domain.customFields` , `sales_channel_domain` . `created_at` as `sales_channel_domain.createdAt` , `sales_channel_domain` . `updated_at` as `sales_channel_domain.updatedAt` FROM `sales_channel_domain` WHERE (`sales_channel_domain` . `sales_channel_id` IN (? ))
Parameters :
[
b"¼\x03 ±/ÊnDl›¾sZáôÐÎ "
]
SELECT `sales_channel_domain` . `id` as `sales_channel_domain.id` , `sales_channel_domain` . `url` as `sales_channel_domain.url` , `sales_channel_domain` . `sales_channel_id` as `sales_channel_domain.salesChannelId` , `sales_channel_domain` . `language_id` as `sales_channel_domain.languageId` , `sales_channel_domain` . `currency_id` as `sales_channel_domain.currencyId` , `sales_channel_domain` . `snippet_set_id` as `sales_channel_domain.snippetSetId` , `sales_channel_domain` . `hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale` , `sales_channel_domain` . `custom_fields` as `sales_channel_domain.customFields` , `sales_channel_domain` . `created_at` as `sales_channel_domain.createdAt` , `sales_channel_domain` . `updated_at` as `sales_channel_domain.updatedAt` FROM `sales_channel_domain` WHERE (`sales_channel_domain` . `sales_channel_id` IN (0xBC03B12FCA6E446C9BBE735AE1F4D0CE ));
Copy
0.32 ms
1
SELECT `name` , `path` , `author`
FROM `app`
WHERE `active` = 1
SELECT `name` , `path` , `author`
FROM `app`
WHERE `active` = 1
; Copy
0.25 ms
1
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = ?
Parameters :
[
"pxeEnT8H9u4QHn4v3bYadDrJxVfQ3KRG "
]
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = 'pxeEnT8H9u4QHn4v3bYadDrJxVfQ3KRG' ;
Copy
0.22 ms
1
SELECT LOWER (HEX (`script` . `app_id` )) as `app_id` ,
`script` . `name` AS name ,
`script` . `script` AS script ,
`app` . `name` AS appName ,
LOWER (HEX (`app` . `integration_id` )) AS integrationId ,
IFNULL (`script` . `updated_at` , `script` . `created_at` ) AS lastModified
FROM `script`
LEFT JOIN `app` ON `script` . `app_id` = `app` . `id`
WHERE `script` . `hook` = 'include'
ORDER BY `app` . `created_at` , `app` . `id` , `script` . `name`
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
0.18 ms
1
SELECT `tax` . `id` as `tax.id` , `tax` . `tax_rate` as `tax.taxRate` , `tax` . `name` as `tax.name` , `tax` . `position` as `tax.position` , `tax` . `custom_fields` as `tax.customFields` , `tax` . `created_at` as `tax.createdAt` , `tax` . `updated_at` as `tax.updatedAt` FROM `tax`
SELECT `tax` . `id` as `tax.id` , `tax` . `tax_rate` as `tax.taxRate` , `tax` . `name` as `tax.name` , `tax` . `position` as `tax.position` , `tax` . `custom_fields` as `tax.customFields` , `tax` . `created_at` as `tax.createdAt` , `tax` . `updated_at` as `tax.updatedAt` FROM `tax` ;
Copy
0.16 ms
1
SELECT LOWER (HEX (language . parent_id )) FROM language WHERE language . id = ?
Parameters :
[
b"ÞDW\x1D ÜNM\x00 •À\x1A öî)“Q "
]
SELECT LOWER (HEX (language . parent_id )) FROM language WHERE language . id = 0xDE44571DDC4E4D0095C01AF6EE299351 ; Copy
0.16 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"¼\x03 ±/ÊnDl›¾sZáôÐÎ "
b"_•ŸcÈ1MšƒË\x17 ‘’\x03 ‹Ý "
]
SELECT `sales_channel_country` . `sales_channel_id` , `sales_channel_country` . `country_id` FROM `sales_channel_country` WHERE (`sales_channel_country` . `sales_channel_id` = 0xBC03B12FCA6E446C9BBE735AE1F4D0CE AND `sales_channel_country` . `country_id` = 0x5F959F63C8314D9A83CB179192038BDD ); Copy
0.12 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