1
0.29 ms
SELECT `key` , `value` FROM `app_config`
SELECT `key` , `value` FROM `app_config` ; Copy
2
0.26 ms
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
3
0.23 ms
SELECT `key` , `value` FROM `app_config`
SELECT `key` , `value` FROM `app_config` ; Copy
4
0.29 ms
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
5
0.12 ms
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
6
0.57 ms
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
7
6.91 ms
SELECT id , path_info pathInfo , is_canonical isCanonical , sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ? ) AND ((sales_channel_id = ? OR sales_channel_id IS NULL )) AND ((seo_path_info = ? OR seo_path_info = ? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 “L€L{pü’£¶í¿Ñ^úaccount/order "
"account/order/ "
]
SELECT id , path_info pathInfo , is_canonical isCanonical , sales_channel_id salesChannelId FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND ((sales_channel_id = 0x01934C804C7B70FC92A3B6EDBFD15EFA OR sales_channel_id IS NULL )) AND ((seo_path_info = 'account/order' OR seo_path_info = 'account/order/' ));
Copy
8
6.49 ms
SELECT path_info pathInfo , seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ? ) AND (sales_channel_id = ? ) AND (path_info = ? ) AND (is_canonical = 1 ) LIMIT 1
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 “L€L{pü’£¶í¿Ñ^ú/account/order "
]
SELECT path_info pathInfo , seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (sales_channel_id = 0x01934C804C7B70FC92A3B6EDBFD15EFA ) AND (path_info = '/account/order' ) AND (is_canonical = 1 ) LIMIT 1 ;
Copy
9
0.42 ms
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
10
0.28 ms
SELECT `name` , `path` , `author`
FROM `app`
WHERE `active` = 1
SELECT `name` , `path` , `author`
FROM `app`
WHERE `active` = 1
; Copy
11
0.35 ms
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ? ) AND (token = ? ) LIMIT 1
Parameters :
[
b"\x01 “L€L{pü’£¶í¿Ñ^úTxLfMYWsE7JVWCWTRGqu1FzylwR8Htzd "
]
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0x01934C804C7B70FC92A3B6EDBFD15EFA ) AND (token = 'TxLfMYWsE7JVWCWTRGqu1FzylwR8Htzd' ) LIMIT 1 ; Copy
12
0.54 ms
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"\x01 “L€L{pü’£¶í¿Ñ^ú ]
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 = 0x01934C804C7B70FC92A3B6EDBFD15EFA
GROUP BY sales_channel . id , sales_channel . language_id , sales_channel . currency_id , currency . factor ;
Copy
13
0.72 ms
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.shortName` , `sales_channel.currency.translation.shortName` as `sales_channel.currency.shortName` , `sales_channel.currency.translation.name` , `sales_channel.currency.translation.name` as `sales_channel.currency.name` , `sales_channel.currency.translation.customFields` , `sales_channel.currency.translation.customFields` as `sales_channel.currency.customFields` , `sales_channel.translation.name` , `sales_channel.translation.name` as `sales_channel.name` , `sales_channel.translation.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig` , `sales_channel.translation.homeEnabled` , `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled` , `sales_channel.translation.homeName` , `sales_channel.translation.homeName` as `sales_channel.homeName` , `sales_channel.translation.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle` , `sales_channel.translation.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription` , `sales_channel.translation.homeKeywords` , `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords` , `sales_channel.translation.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` . `custom_fields` as `sales_channel.translation.customFields` , `sales_channel.translation` . `home_slot_config` as `sales_channel.translation.homeSlotConfig` , `sales_channel.translation` . `home_enabled` as `sales_channel.translation.homeEnabled` , `sales_channel.translation` . `home_name` as `sales_channel.translation.homeName` , `sales_channel.translation` . `home_meta_title` as `sales_channel.translation.homeMetaTitle` , `sales_channel.translation` . `home_meta_description` as `sales_channel.translation.homeMetaDescription` , `sales_channel.translation` . `home_keywords` as `sales_channel.translation.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation` . `language_id` = ? ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id` LEFT JOIN (SELECT `sales_channel.currency.translation` . `currency_id` , `sales_channel.currency.translation` . `short_name` as `sales_channel.currency.translation.shortName` , `sales_channel.currency.translation` . `name` as `sales_channel.currency.translation.name` , `sales_channel.currency.translation` . `custom_fields` as `sales_channel.currency.translation.customFields` FROM `currency_translation` `sales_channel.currency.translation` WHERE `sales_channel.currency.translation` . `language_id` = ? ) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation` . `currency_id` = `sales_channel.currency` . `id` WHERE `sales_channel` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 “L€L{pü’£¶í¿Ñ^ú ]
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.shortName` ,
`sales_channel.currency.translation.shortName` as `sales_channel.currency.shortName` ,
`sales_channel.currency.translation.name` ,
`sales_channel.currency.translation.name` as `sales_channel.currency.name` ,
`sales_channel.currency.translation.customFields` ,
`sales_channel.currency.translation.customFields` as `sales_channel.currency.customFields` ,
`sales_channel.translation.name` ,
`sales_channel.translation.name` as `sales_channel.name` ,
`sales_channel.translation.homeSlotConfig` ,
`sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig` ,
`sales_channel.translation.homeEnabled` ,
`sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled` ,
`sales_channel.translation.homeName` ,
`sales_channel.translation.homeName` as `sales_channel.homeName` ,
`sales_channel.translation.homeMetaTitle` ,
`sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle` ,
`sales_channel.translation.homeMetaDescription` ,
`sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription` ,
`sales_channel.translation.homeKeywords` ,
`sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords` ,
`sales_channel.translation.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` . `custom_fields` as `sales_channel.translation.customFields` ,
`sales_channel.translation` . `home_slot_config` as `sales_channel.translation.homeSlotConfig` ,
`sales_channel.translation` . `home_enabled` as `sales_channel.translation.homeEnabled` ,
`sales_channel.translation` . `home_name` as `sales_channel.translation.homeName` ,
`sales_channel.translation` . `home_meta_title` as `sales_channel.translation.homeMetaTitle` ,
`sales_channel.translation` . `home_meta_description` as `sales_channel.translation.homeMetaDescription` ,
`sales_channel.translation` . `home_keywords` as `sales_channel.translation.homeKeywords`
FROM
`sales_channel_translation` `sales_channel.translation`
WHERE
`sales_channel.translation` . `language_id` = ?
) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id`
LEFT JOIN (
SELECT
`sales_channel.currency.translation` . `currency_id` ,
`sales_channel.currency.translation` . `short_name` as `sales_channel.currency.translation.shortName` ,
`sales_channel.currency.translation` . `name` as `sales_channel.currency.translation.name` ,
`sales_channel.currency.translation` . `custom_fields` as `sales_channel.currency.translation.customFields`
FROM
`currency_translation` `sales_channel.currency.translation`
WHERE
`sales_channel.currency.translation` . `language_id` = ?
) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation` . `currency_id` = `sales_channel.currency` . `id`
WHERE
`sales_channel` . `id` IN (? )
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.shortName` , `sales_channel.currency.translation.shortName` as `sales_channel.currency.shortName` , `sales_channel.currency.translation.name` , `sales_channel.currency.translation.name` as `sales_channel.currency.name` , `sales_channel.currency.translation.customFields` , `sales_channel.currency.translation.customFields` as `sales_channel.currency.customFields` , `sales_channel.translation.name` , `sales_channel.translation.name` as `sales_channel.name` , `sales_channel.translation.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig` , `sales_channel.translation.homeEnabled` , `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled` , `sales_channel.translation.homeName` , `sales_channel.translation.homeName` as `sales_channel.homeName` , `sales_channel.translation.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle` , `sales_channel.translation.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription` , `sales_channel.translation.homeKeywords` , `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords` , `sales_channel.translation.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` . `custom_fields` as `sales_channel.translation.customFields` , `sales_channel.translation` . `home_slot_config` as `sales_channel.translation.homeSlotConfig` , `sales_channel.translation` . `home_enabled` as `sales_channel.translation.homeEnabled` , `sales_channel.translation` . `home_name` as `sales_channel.translation.homeName` , `sales_channel.translation` . `home_meta_title` as `sales_channel.translation.homeMetaTitle` , `sales_channel.translation` . `home_meta_description` as `sales_channel.translation.homeMetaDescription` , `sales_channel.translation` . `home_keywords` as `sales_channel.translation.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` 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` . `name` as `sales_channel.currency.translation.name` , `sales_channel.currency.translation` . `custom_fields` as `sales_channel.currency.translation.customFields` FROM `currency_translation` `sales_channel.currency.translation` 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 (0x01934C804C7B70FC92A3B6EDBFD15EFA );
Copy
14
0.27 ms
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"\x01 “L€L{pü’£¶í¿Ñ^ú ]
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 (0x01934C804C7B70FC92A3B6EDBFD15EFA ));
Copy
15
0.34 ms
SELECT `currency` . `id` as `currency.id` , `currency` . `factor` as `currency.factor` , `currency` . `symbol` as `currency.symbol` , `currency` . `iso_code` as `currency.isoCode` , `currency` . `position` as `currency.position` , `currency` . `tax_free_from` as `currency.taxFreeFrom` , `currency` . `item_rounding` as `currency.itemRounding` , `currency` . `total_rounding` as `currency.totalRounding` , `currency` . `created_at` as `currency.createdAt` , `currency` . `updated_at` as `currency.updatedAt` , `currency.translation.shortName` , `currency.translation.shortName` as `currency.shortName` , `currency.translation.name` , `currency.translation.name` as `currency.name` , `currency.translation.customFields` , `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation` . `currency_id` , `currency.translation` . `short_name` as `currency.translation.shortName` , `currency.translation` . `name` as `currency.translation.name` , `currency.translation` . `custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation` . `language_id` = ? ) `currency.currency_translation` ON `currency.currency_translation` . `currency_id` = `currency` . `id` WHERE `currency` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"·ÒUK\f èGÍ‚ó¬›ÑÀßÊ "
]
SELECT `currency` . `id` as `currency.id` , `currency` . `factor` as `currency.factor` , `currency` . `symbol` as `currency.symbol` , `currency` . `iso_code` as `currency.isoCode` , `currency` . `position` as `currency.position` , `currency` . `tax_free_from` as `currency.taxFreeFrom` , `currency` . `item_rounding` as `currency.itemRounding` , `currency` . `total_rounding` as `currency.totalRounding` , `currency` . `created_at` as `currency.createdAt` , `currency` . `updated_at` as `currency.updatedAt` , `currency.translation.shortName` , `currency.translation.shortName` as `currency.shortName` , `currency.translation.name` , `currency.translation.name` as `currency.name` , `currency.translation.customFields` , `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation` . `currency_id` , `currency.translation` . `short_name` as `currency.translation.shortName` , `currency.translation` . `name` as `currency.translation.name` , `currency.translation` . `custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `currency.currency_translation` ON `currency.currency_translation` . `currency_id` = `currency` . `id` WHERE `currency` . `id` IN (0xB7D2554B0CE847CD82F3AC9BD1C0DFCA );
Copy
16
0.39 ms
SELECT `country` . `id` as `country.id` , `country` . `iso` as `country.iso` , `country` . `position` as `country.position` , `country` . `active` as `country.active` , `country` . `shipping_available` as `country.shippingAvailable` , `country` . `iso3` as `country.iso3` , `country` . `display_state_in_registration` as `country.displayStateInRegistration` , `country` . `force_state_in_registration` as `country.forceStateInRegistration` , `country` . `check_vat_id_pattern` as `country.checkVatIdPattern` , `country` . `vat_id_required` as `country.vatIdRequired` , `country` . `vat_id_pattern` as `country.vatIdPattern` , `country` . `customer_tax` as `country.customerTax` , `country` . `company_tax` as `country.companyTax` , `country` . `postal_code_required` as `country.postalCodeRequired` , `country` . `check_postal_code_pattern` as `country.checkPostalCodePattern` , `country` . `check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern` , `country` . `advanced_postal_code_pattern` as `country.advancedPostalCodePattern` , `country` . `default_postal_code_pattern` as `country.defaultPostalCodePattern` , `country` . `is_eu` as `country.isEu` , `country` . `created_at` as `country.createdAt` , `country` . `updated_at` as `country.updatedAt` , `country.translation.name` , `country.translation.name` as `country.name` , `country.translation.addressFormat` , `country.translation.addressFormat` as `country.addressFormat` , `country.translation.customFields` , `country.translation.customFields` as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation` . `country_id` , `country.translation` . `name` as `country.translation.name` , `country.translation` . `custom_fields` as `country.translation.customFields` , `country.translation` . `address_format` as `country.translation.addressFormat` FROM `country_translation` `country.translation` WHERE `country.translation` . `language_id` = ? ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` WHERE `country` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 ôL\x7F ┤wsRÉÓ,¥5┬┌Ñ ]
SELECT `country` . `id` as `country.id` , `country` . `iso` as `country.iso` , `country` . `position` as `country.position` , `country` . `active` as `country.active` , `country` . `shipping_available` as `country.shippingAvailable` , `country` . `iso3` as `country.iso3` , `country` . `display_state_in_registration` as `country.displayStateInRegistration` , `country` . `force_state_in_registration` as `country.forceStateInRegistration` , `country` . `check_vat_id_pattern` as `country.checkVatIdPattern` , `country` . `vat_id_required` as `country.vatIdRequired` , `country` . `vat_id_pattern` as `country.vatIdPattern` , `country` . `customer_tax` as `country.customerTax` , `country` . `company_tax` as `country.companyTax` , `country` . `postal_code_required` as `country.postalCodeRequired` , `country` . `check_postal_code_pattern` as `country.checkPostalCodePattern` , `country` . `check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern` , `country` . `advanced_postal_code_pattern` as `country.advancedPostalCodePattern` , `country` . `default_postal_code_pattern` as `country.defaultPostalCodePattern` , `country` . `is_eu` as `country.isEu` , `country` . `created_at` as `country.createdAt` , `country` . `updated_at` as `country.updatedAt` , `country.translation.name` , `country.translation.name` as `country.name` , `country.translation.addressFormat` , `country.translation.addressFormat` as `country.addressFormat` , `country.translation.customFields` , `country.translation.customFields` as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation` . `country_id` , `country.translation` . `name` as `country.translation.name` , `country.translation` . `custom_fields` as `country.translation.customFields` , `country.translation` . `address_format` as `country.translation.addressFormat` FROM `country_translation` `country.translation` WHERE `country.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` WHERE `country` . `id` IN (0x01934C7FB477735290E02CBE35C2DAA5 );
Copy
17
0.33 ms
SELECT `customer_group` . `id` as `customer_group.id` , `customer_group` . `display_gross` as `customer_group.displayGross` , `customer_group` . `registration_active` as `customer_group.registrationActive` , `customer_group` . `created_at` as `customer_group.createdAt` , `customer_group` . `updated_at` as `customer_group.updatedAt` , `customer_group.translation.name` , `customer_group.translation.name` as `customer_group.name` , `customer_group.translation.registrationTitle` , `customer_group.translation.registrationTitle` as `customer_group.registrationTitle` , `customer_group.translation.registrationIntroduction` , `customer_group.translation.registrationIntroduction` as `customer_group.registrationIntroduction` , `customer_group.translation.registrationOnlyCompanyRegistration` , `customer_group.translation.registrationOnlyCompanyRegistration` as `customer_group.registrationOnlyCompanyRegistration` , `customer_group.translation.registrationSeoMetaDescription` , `customer_group.translation.registrationSeoMetaDescription` as `customer_group.registrationSeoMetaDescription` , `customer_group.translation.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` . `custom_fields` as `customer_group.translation.customFields` , `customer_group.translation` . `registration_title` as `customer_group.translation.registrationTitle` , `customer_group.translation` . `registration_introduction` as `customer_group.translation.registrationIntroduction` , `customer_group.translation` . `registration_only_company_registration` as `customer_group.translation.registrationOnlyCompanyRegistration` , `customer_group.translation` . `registration_seo_meta_description` as `customer_group.translation.registrationSeoMetaDescription` FROM `customer_group_translation` `customer_group.translation` WHERE `customer_group.translation` . `language_id` = ? ) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation` . `customer_group_id` = `customer_group` . `id` WHERE `customer_group` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"¤¢P\x18 ËìAÏ¡╩\x10 ┘O╚¢Í "
]
SELECT `customer_group` . `id` as `customer_group.id` , `customer_group` . `display_gross` as `customer_group.displayGross` , `customer_group` . `registration_active` as `customer_group.registrationActive` , `customer_group` . `created_at` as `customer_group.createdAt` , `customer_group` . `updated_at` as `customer_group.updatedAt` , `customer_group.translation.name` , `customer_group.translation.name` as `customer_group.name` , `customer_group.translation.registrationTitle` , `customer_group.translation.registrationTitle` as `customer_group.registrationTitle` , `customer_group.translation.registrationIntroduction` , `customer_group.translation.registrationIntroduction` as `customer_group.registrationIntroduction` , `customer_group.translation.registrationOnlyCompanyRegistration` , `customer_group.translation.registrationOnlyCompanyRegistration` as `customer_group.registrationOnlyCompanyRegistration` , `customer_group.translation.registrationSeoMetaDescription` , `customer_group.translation.registrationSeoMetaDescription` as `customer_group.registrationSeoMetaDescription` , `customer_group.translation.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` . `custom_fields` as `customer_group.translation.customFields` , `customer_group.translation` . `registration_title` as `customer_group.translation.registrationTitle` , `customer_group.translation` . `registration_introduction` as `customer_group.translation.registrationIntroduction` , `customer_group.translation` . `registration_only_company_registration` as `customer_group.translation.registrationOnlyCompanyRegistration` , `customer_group.translation` . `registration_seo_meta_description` as `customer_group.translation.registrationSeoMetaDescription` FROM `customer_group_translation` `customer_group.translation` 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 (0xCFBD5018D38D41D8ADCA10D94FC8BDD6 );
Copy
18
0.19 ms
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
19
0.55 ms
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.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` FROM `tax_rule_type_translation` `tax_rule.type.translation` WHERE `tax_rule.type.translation` . `language_id` = ? ) `tax_rule.type.tax_rule_type_translation` ON `tax_rule.type.tax_rule_type_translation` . `tax_rule_type_id` = `tax_rule.type` . `id` WHERE (`tax_rule` . `tax_id` IN (? , ? , ? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 “L\x7F ¹\e rà˜ä…P\x0F ¢O:\x01 “L\x7F ¹\e rà˜ä…P\x10 l\x1F (\x01 “L\x7F ×\x07 qd‹µH0úvHª ]
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.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` FROM `tax_rule_type_translation` `tax_rule.type.translation` 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 (0x01934C7FB91B72E098E485500FA24F3A , 0x01934C7FB91B72E098E48550106C1F28 , 0x01934C7FD70771648BB54830FA7648AA ));
Copy
20
0.65 ms
SELECT `payment_method` . `id` as `payment_method.id` , `payment_method` . `plugin_id` as `payment_method.pluginId` , `payment_method` . `handler_identifier` as `payment_method.handlerIdentifier` , `payment_method` . `position` as `payment_method.position` , `payment_method` . `active` as `payment_method.active` , `payment_method` . `after_order_enabled` as `payment_method.afterOrderEnabled` , `payment_method` . `availability_rule_id` as `payment_method.availabilityRuleId` , `payment_method` . `media_id` as `payment_method.mediaId` , `payment_method.appPaymentMethod` . `id` as `payment_method.appPaymentMethod.id` , `payment_method.appPaymentMethod` . `app_name` as `payment_method.appPaymentMethod.appName` , `payment_method.appPaymentMethod` . `identifier` as `payment_method.appPaymentMethod.identifier` , `payment_method.appPaymentMethod` . `pay_url` as `payment_method.appPaymentMethod.payUrl` , `payment_method.appPaymentMethod` . `finalize_url` as `payment_method.appPaymentMethod.finalizeUrl` , `payment_method.appPaymentMethod` . `validate_url` as `payment_method.appPaymentMethod.validateUrl` , `payment_method.appPaymentMethod` . `capture_url` as `payment_method.appPaymentMethod.captureUrl` , `payment_method.appPaymentMethod` . `refund_url` as `payment_method.appPaymentMethod.refundUrl` , `payment_method.appPaymentMethod` . `recurring_url` as `payment_method.appPaymentMethod.recurringUrl` , `payment_method.appPaymentMethod` . `app_id` as `payment_method.appPaymentMethod.appId` , `payment_method.appPaymentMethod` . `original_media_id` as `payment_method.appPaymentMethod.originalMediaId` , `payment_method.appPaymentMethod` . `payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId` , `payment_method.appPaymentMethod` . `created_at` as `payment_method.appPaymentMethod.createdAt` , `payment_method.appPaymentMethod` . `updated_at` as `payment_method.appPaymentMethod.updatedAt` , `payment_method` . `technical_name` as `payment_method.technicalName` , `payment_method` . `created_at` as `payment_method.createdAt` , `payment_method` . `updated_at` as `payment_method.updatedAt` , `payment_method.media` . `id` as `payment_method.media.id` , `payment_method.media` . `user_id` as `payment_method.media.userId` , `payment_method.media` . `media_folder_id` as `payment_method.media.mediaFolderId` , `payment_method.media` . `mime_type` as `payment_method.media.mimeType` , `payment_method.media` . `file_extension` as `payment_method.media.fileExtension` , `payment_method.media` . `uploaded_at` as `payment_method.media.uploadedAt` , `payment_method.media` . `file_name` as `payment_method.media.fileName` , `payment_method.media` . `file_size` as `payment_method.media.fileSize` , `payment_method.media` . `media_type` as `payment_method.media.mediaTypeRaw` , `payment_method.media` . `meta_data` as `payment_method.media.metaData` , `payment_method.media` . `config` as `payment_method.media.config` , `payment_method.media` . `path` as `payment_method.media.path` , `payment_method.media` . `private` as `payment_method.media.private` , `payment_method.media` . `thumbnails_ro` as `payment_method.media.thumbnailsRo` , `payment_method.media` . `created_at` as `payment_method.media.createdAt` , `payment_method.media` . `updated_at` as `payment_method.media.updatedAt` , `payment_method.media.translation.title` , `payment_method.media.translation.title` as `payment_method.media.title` , `payment_method.media.translation.alt` , `payment_method.media.translation.alt` as `payment_method.media.alt` , `payment_method.media.translation.customFields` , `payment_method.media.translation.customFields` as `payment_method.media.customFields` , `payment_method.translation.name` , `payment_method.translation.name` as `payment_method.name` , `payment_method.translation.distinguishableName` , `payment_method.translation.distinguishableName` as `payment_method.distinguishableName` , `payment_method.translation.description` , `payment_method.translation.description` as `payment_method.description` , `payment_method.translation.customFields` , `payment_method.translation.customFields` as `payment_method.customFields` FROM `payment_method` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method` . `id` = `payment_method.appPaymentMethod` . `payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method` . `media_id` = `payment_method.media` . `id` LEFT JOIN (SELECT `payment_method.translation` . `payment_method_id` , `payment_method.translation` . `name` as `payment_method.translation.name` , `payment_method.translation` . `distinguishable_name` as `payment_method.translation.distinguishableName` , `payment_method.translation` . `description` as `payment_method.translation.description` , `payment_method.translation` . `custom_fields` as `payment_method.translation.customFields` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation` . `language_id` = ? ) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation` . `payment_method_id` = `payment_method` . `id` LEFT JOIN (SELECT `payment_method.media.translation` . `media_id` , `payment_method.media.translation` . `alt` as `payment_method.media.translation.alt` , `payment_method.media.translation` . `title` as `payment_method.media.translation.title` , `payment_method.media.translation` . `custom_fields` as `payment_method.media.translation.customFields` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation` . `language_id` = ? ) `payment_method.media.media_translation` ON `payment_method.media.media_translation` . `media_id` = `payment_method.media` . `id` WHERE `payment_method` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 “L†%†st¢ŸZè›ãž5 ]
SELECT
`payment_method` . `id` as `payment_method.id` ,
`payment_method` . `plugin_id` as `payment_method.pluginId` ,
`payment_method` . `handler_identifier` as `payment_method.handlerIdentifier` ,
`payment_method` . `position` as `payment_method.position` ,
`payment_method` . `active` as `payment_method.active` ,
`payment_method` . `after_order_enabled` as `payment_method.afterOrderEnabled` ,
`payment_method` . `availability_rule_id` as `payment_method.availabilityRuleId` ,
`payment_method` . `media_id` as `payment_method.mediaId` ,
`payment_method.appPaymentMethod` . `id` as `payment_method.appPaymentMethod.id` ,
`payment_method.appPaymentMethod` . `app_name` as `payment_method.appPaymentMethod.appName` ,
`payment_method.appPaymentMethod` . `identifier` as `payment_method.appPaymentMethod.identifier` ,
`payment_method.appPaymentMethod` . `pay_url` as `payment_method.appPaymentMethod.payUrl` ,
`payment_method.appPaymentMethod` . `finalize_url` as `payment_method.appPaymentMethod.finalizeUrl` ,
`payment_method.appPaymentMethod` . `validate_url` as `payment_method.appPaymentMethod.validateUrl` ,
`payment_method.appPaymentMethod` . `capture_url` as `payment_method.appPaymentMethod.captureUrl` ,
`payment_method.appPaymentMethod` . `refund_url` as `payment_method.appPaymentMethod.refundUrl` ,
`payment_method.appPaymentMethod` . `recurring_url` as `payment_method.appPaymentMethod.recurringUrl` ,
`payment_method.appPaymentMethod` . `app_id` as `payment_method.appPaymentMethod.appId` ,
`payment_method.appPaymentMethod` . `original_media_id` as `payment_method.appPaymentMethod.originalMediaId` ,
`payment_method.appPaymentMethod` . `payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId` ,
`payment_method.appPaymentMethod` . `created_at` as `payment_method.appPaymentMethod.createdAt` ,
`payment_method.appPaymentMethod` . `updated_at` as `payment_method.appPaymentMethod.updatedAt` ,
`payment_method` . `technical_name` as `payment_method.technicalName` ,
`payment_method` . `created_at` as `payment_method.createdAt` ,
`payment_method` . `updated_at` as `payment_method.updatedAt` ,
`payment_method.media` . `id` as `payment_method.media.id` ,
`payment_method.media` . `user_id` as `payment_method.media.userId` ,
`payment_method.media` . `media_folder_id` as `payment_method.media.mediaFolderId` ,
`payment_method.media` . `mime_type` as `payment_method.media.mimeType` ,
`payment_method.media` . `file_extension` as `payment_method.media.fileExtension` ,
`payment_method.media` . `uploaded_at` as `payment_method.media.uploadedAt` ,
`payment_method.media` . `file_name` as `payment_method.media.fileName` ,
`payment_method.media` . `file_size` as `payment_method.media.fileSize` ,
`payment_method.media` . `media_type` as `payment_method.media.mediaTypeRaw` ,
`payment_method.media` . `meta_data` as `payment_method.media.metaData` ,
`payment_method.media` . `config` as `payment_method.media.config` ,
`payment_method.media` . `path` as `payment_method.media.path` ,
`payment_method.media` . `private` as `payment_method.media.private` ,
`payment_method.media` . `thumbnails_ro` as `payment_method.media.thumbnailsRo` ,
`payment_method.media` . `created_at` as `payment_method.media.createdAt` ,
`payment_method.media` . `updated_at` as `payment_method.media.updatedAt` ,
`payment_method.media.translation.title` ,
`payment_method.media.translation.title` as `payment_method.media.title` ,
`payment_method.media.translation.alt` ,
`payment_method.media.translation.alt` as `payment_method.media.alt` ,
`payment_method.media.translation.customFields` ,
`payment_method.media.translation.customFields` as `payment_method.media.customFields` ,
`payment_method.translation.name` ,
`payment_method.translation.name` as `payment_method.name` ,
`payment_method.translation.distinguishableName` ,
`payment_method.translation.distinguishableName` as `payment_method.distinguishableName` ,
`payment_method.translation.description` ,
`payment_method.translation.description` as `payment_method.description` ,
`payment_method.translation.customFields` ,
`payment_method.translation.customFields` as `payment_method.customFields`
FROM
`payment_method`
LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method` . `id` = `payment_method.appPaymentMethod` . `payment_method_id`
LEFT JOIN `media` `payment_method.media` ON `payment_method` . `media_id` = `payment_method.media` . `id`
LEFT JOIN (
SELECT
`payment_method.translation` . `payment_method_id` ,
`payment_method.translation` . `name` as `payment_method.translation.name` ,
`payment_method.translation` . `distinguishable_name` as `payment_method.translation.distinguishableName` ,
`payment_method.translation` . `description` as `payment_method.translation.description` ,
`payment_method.translation` . `custom_fields` as `payment_method.translation.customFields`
FROM
`payment_method_translation` `payment_method.translation`
WHERE
`payment_method.translation` . `language_id` = ?
) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation` . `payment_method_id` = `payment_method` . `id`
LEFT JOIN (
SELECT
`payment_method.media.translation` . `media_id` ,
`payment_method.media.translation` . `alt` as `payment_method.media.translation.alt` ,
`payment_method.media.translation` . `title` as `payment_method.media.translation.title` ,
`payment_method.media.translation` . `custom_fields` as `payment_method.media.translation.customFields`
FROM
`media_translation` `payment_method.media.translation`
WHERE
`payment_method.media.translation` . `language_id` = ?
) `payment_method.media.media_translation` ON `payment_method.media.media_translation` . `media_id` = `payment_method.media` . `id`
WHERE
`payment_method` . `id` IN (? )
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.title` , `payment_method.media.translation.title` as `payment_method.media.title` , `payment_method.media.translation.alt` , `payment_method.media.translation.alt` as `payment_method.media.alt` , `payment_method.media.translation.customFields` , `payment_method.media.translation.customFields` as `payment_method.media.customFields` , `payment_method.translation.name` , `payment_method.translation.name` as `payment_method.name` , `payment_method.translation.distinguishableName` , `payment_method.translation.distinguishableName` as `payment_method.distinguishableName` , `payment_method.translation.description` , `payment_method.translation.description` as `payment_method.description` , `payment_method.translation.customFields` , `payment_method.translation.customFields` as `payment_method.customFields` FROM `payment_method` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method` . `id` = `payment_method.appPaymentMethod` . `payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method` . `media_id` = `payment_method.media` . `id` LEFT JOIN (SELECT `payment_method.translation` . `payment_method_id` , `payment_method.translation` . `name` as `payment_method.translation.name` , `payment_method.translation` . `distinguishable_name` as `payment_method.translation.distinguishableName` , `payment_method.translation` . `description` as `payment_method.translation.description` , `payment_method.translation` . `custom_fields` as `payment_method.translation.customFields` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation` . `language_id` = 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` . `title` as `payment_method.media.translation.title` , `payment_method.media.translation` . `custom_fields` as `payment_method.media.translation.customFields` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `payment_method.media.media_translation` ON `payment_method.media.media_translation` . `media_id` = `payment_method.media` . `id` WHERE `payment_method` . `id` IN (0x01934C8625867374A29F5AE89BE39E35 );
Copy
21
0.62 ms
SELECT `shipping_method` . `id` as `shipping_method.id` , `shipping_method` . `active` as `shipping_method.active` , `shipping_method` . `position` as `shipping_method.position` , `shipping_method` . `availability_rule_id` as `shipping_method.availabilityRuleId` , `shipping_method` . `media_id` as `shipping_method.mediaId` , `shipping_method` . `delivery_time_id` as `shipping_method.deliveryTimeId` , `shipping_method` . `tax_type` as `shipping_method.taxType` , `shipping_method` . `tax_id` as `shipping_method.taxId` , `shipping_method.deliveryTime` . `id` as `shipping_method.deliveryTime.id` , `shipping_method.deliveryTime` . `min` as `shipping_method.deliveryTime.min` , `shipping_method.deliveryTime` . `max` as `shipping_method.deliveryTime.max` , `shipping_method.deliveryTime` . `unit` as `shipping_method.deliveryTime.unit` , `shipping_method.deliveryTime` . `created_at` as `shipping_method.deliveryTime.createdAt` , `shipping_method.deliveryTime` . `updated_at` as `shipping_method.deliveryTime.updatedAt` , `shipping_method.deliveryTime.translation.name` , `shipping_method.deliveryTime.translation.name` as `shipping_method.deliveryTime.name` , `shipping_method.deliveryTime.translation.customFields` , `shipping_method.deliveryTime.translation.customFields` as `shipping_method.deliveryTime.customFields` , `shipping_method.appShippingMethod` . `id` as `shipping_method.appShippingMethod.id` , `shipping_method.appShippingMethod` . `app_name` as `shipping_method.appShippingMethod.appName` , `shipping_method.appShippingMethod` . `identifier` as `shipping_method.appShippingMethod.identifier` , `shipping_method.appShippingMethod` . `app_id` as `shipping_method.appShippingMethod.appId` , `shipping_method.appShippingMethod` . `shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId` , `shipping_method.appShippingMethod` . `original_media_id` as `shipping_method.appShippingMethod.originalMediaId` , `shipping_method.appShippingMethod` . `created_at` as `shipping_method.appShippingMethod.createdAt` , `shipping_method.appShippingMethod` . `updated_at` as `shipping_method.appShippingMethod.updatedAt` , `shipping_method` . `technical_name` as `shipping_method.technicalName` , `shipping_method` . `created_at` as `shipping_method.createdAt` , `shipping_method` . `updated_at` as `shipping_method.updatedAt` , `shipping_method.media` . `id` as `shipping_method.media.id` , `shipping_method.media` . `user_id` as `shipping_method.media.userId` , `shipping_method.media` . `media_folder_id` as `shipping_method.media.mediaFolderId` , `shipping_method.media` . `mime_type` as `shipping_method.media.mimeType` , `shipping_method.media` . `file_extension` as `shipping_method.media.fileExtension` , `shipping_method.media` . `uploaded_at` as `shipping_method.media.uploadedAt` , `shipping_method.media` . `file_name` as `shipping_method.media.fileName` , `shipping_method.media` . `file_size` as `shipping_method.media.fileSize` , `shipping_method.media` . `media_type` as `shipping_method.media.mediaTypeRaw` , `shipping_method.media` . `meta_data` as `shipping_method.media.metaData` , `shipping_method.media` . `config` as `shipping_method.media.config` , `shipping_method.media` . `path` as `shipping_method.media.path` , `shipping_method.media` . `private` as `shipping_method.media.private` , `shipping_method.media` . `thumbnails_ro` as `shipping_method.media.thumbnailsRo` , `shipping_method.media` . `created_at` as `shipping_method.media.createdAt` , `shipping_method.media` . `updated_at` as `shipping_method.media.updatedAt` , `shipping_method.media.translation.title` , `shipping_method.media.translation.title` as `shipping_method.media.title` , `shipping_method.media.translation.alt` , `shipping_method.media.translation.alt` as `shipping_method.media.alt` , `shipping_method.media.translation.customFields` , `shipping_method.media.translation.customFields` as `shipping_method.media.customFields` , `shipping_method.translation.name` , `shipping_method.translation.name` as `shipping_method.name` , `shipping_method.translation.description` , `shipping_method.translation.description` as `shipping_method.description` , `shipping_method.translation.trackingUrl` , `shipping_method.translation.trackingUrl` as `shipping_method.trackingUrl` , `shipping_method.translation.customFields` , `shipping_method.translation.customFields` as `shipping_method.customFields` FROM `shipping_method` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method` . `delivery_time_id` = `shipping_method.deliveryTime` . `id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method` . `id` = `shipping_method.appShippingMethod` . `shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method` . `media_id` = `shipping_method.media` . `id` LEFT JOIN (SELECT `shipping_method.translation` . `shipping_method_id` , `shipping_method.translation` . `name` as `shipping_method.translation.name` , `shipping_method.translation` . `custom_fields` as `shipping_method.translation.customFields` , `shipping_method.translation` . `description` as `shipping_method.translation.description` , `shipping_method.translation` . `tracking_url` as `shipping_method.translation.trackingUrl` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation` . `language_id` = ? ) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation` . `shipping_method_id` = `shipping_method` . `id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation` . `delivery_time_id` , `shipping_method.deliveryTime.translation` . `name` as `shipping_method.deliveryTime.translation.name` , `shipping_method.deliveryTime.translation` . `custom_fields` as `shipping_method.deliveryTime.translation.customFields` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation` . `language_id` = ? ) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation` . `delivery_time_id` = `shipping_method.deliveryTime` . `id` LEFT JOIN (SELECT `shipping_method.media.translation` . `media_id` , `shipping_method.media.translation` . `alt` as `shipping_method.media.translation.alt` , `shipping_method.media.translation` . `title` as `shipping_method.media.translation.title` , `shipping_method.media.translation` . `custom_fields` as `shipping_method.media.translation.customFields` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation` . `language_id` = ? ) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation` . `media_id` = `shipping_method.media` . `id` WHERE `shipping_method` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"""
\x01 “L\x7F ¹\n q\x1E “\x04 ¢ÿÄŽ3Ð
"""
]
SELECT
`shipping_method` . `id` as `shipping_method.id` ,
`shipping_method` . `active` as `shipping_method.active` ,
`shipping_method` . `position` as `shipping_method.position` ,
`shipping_method` . `availability_rule_id` as `shipping_method.availabilityRuleId` ,
`shipping_method` . `media_id` as `shipping_method.mediaId` ,
`shipping_method` . `delivery_time_id` as `shipping_method.deliveryTimeId` ,
`shipping_method` . `tax_type` as `shipping_method.taxType` ,
`shipping_method` . `tax_id` as `shipping_method.taxId` ,
`shipping_method.deliveryTime` . `id` as `shipping_method.deliveryTime.id` ,
`shipping_method.deliveryTime` . `min` as `shipping_method.deliveryTime.min` ,
`shipping_method.deliveryTime` . `max` as `shipping_method.deliveryTime.max` ,
`shipping_method.deliveryTime` . `unit` as `shipping_method.deliveryTime.unit` ,
`shipping_method.deliveryTime` . `created_at` as `shipping_method.deliveryTime.createdAt` ,
`shipping_method.deliveryTime` . `updated_at` as `shipping_method.deliveryTime.updatedAt` ,
`shipping_method.deliveryTime.translation.name` ,
`shipping_method.deliveryTime.translation.name` as `shipping_method.deliveryTime.name` ,
`shipping_method.deliveryTime.translation.customFields` ,
`shipping_method.deliveryTime.translation.customFields` as `shipping_method.deliveryTime.customFields` ,
`shipping_method.appShippingMethod` . `id` as `shipping_method.appShippingMethod.id` ,
`shipping_method.appShippingMethod` . `app_name` as `shipping_method.appShippingMethod.appName` ,
`shipping_method.appShippingMethod` . `identifier` as `shipping_method.appShippingMethod.identifier` ,
`shipping_method.appShippingMethod` . `app_id` as `shipping_method.appShippingMethod.appId` ,
`shipping_method.appShippingMethod` . `shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId` ,
`shipping_method.appShippingMethod` . `original_media_id` as `shipping_method.appShippingMethod.originalMediaId` ,
`shipping_method.appShippingMethod` . `created_at` as `shipping_method.appShippingMethod.createdAt` ,
`shipping_method.appShippingMethod` . `updated_at` as `shipping_method.appShippingMethod.updatedAt` ,
`shipping_method` . `technical_name` as `shipping_method.technicalName` ,
`shipping_method` . `created_at` as `shipping_method.createdAt` ,
`shipping_method` . `updated_at` as `shipping_method.updatedAt` ,
`shipping_method.media` . `id` as `shipping_method.media.id` ,
`shipping_method.media` . `user_id` as `shipping_method.media.userId` ,
`shipping_method.media` . `media_folder_id` as `shipping_method.media.mediaFolderId` ,
`shipping_method.media` . `mime_type` as `shipping_method.media.mimeType` ,
`shipping_method.media` . `file_extension` as `shipping_method.media.fileExtension` ,
`shipping_method.media` . `uploaded_at` as `shipping_method.media.uploadedAt` ,
`shipping_method.media` . `file_name` as `shipping_method.media.fileName` ,
`shipping_method.media` . `file_size` as `shipping_method.media.fileSize` ,
`shipping_method.media` . `media_type` as `shipping_method.media.mediaTypeRaw` ,
`shipping_method.media` . `meta_data` as `shipping_method.media.metaData` ,
`shipping_method.media` . `config` as `shipping_method.media.config` ,
`shipping_method.media` . `path` as `shipping_method.media.path` ,
`shipping_method.media` . `private` as `shipping_method.media.private` ,
`shipping_method.media` . `thumbnails_ro` as `shipping_method.media.thumbnailsRo` ,
`shipping_method.media` . `created_at` as `shipping_method.media.createdAt` ,
`shipping_method.media` . `updated_at` as `shipping_method.media.updatedAt` ,
`shipping_method.media.translation.title` ,
`shipping_method.media.translation.title` as `shipping_method.media.title` ,
`shipping_method.media.translation.alt` ,
`shipping_method.media.translation.alt` as `shipping_method.media.alt` ,
`shipping_method.media.translation.customFields` ,
`shipping_method.media.translation.customFields` as `shipping_method.media.customFields` ,
`shipping_method.translation.name` ,
`shipping_method.translation.name` as `shipping_method.name` ,
`shipping_method.translation.description` ,
`shipping_method.translation.description` as `shipping_method.description` ,
`shipping_method.translation.trackingUrl` ,
`shipping_method.translation.trackingUrl` as `shipping_method.trackingUrl` ,
`shipping_method.translation.customFields` ,
`shipping_method.translation.customFields` as `shipping_method.customFields`
FROM
`shipping_method`
LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method` . `delivery_time_id` = `shipping_method.deliveryTime` . `id`
LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method` . `id` = `shipping_method.appShippingMethod` . `shipping_method_id`
LEFT JOIN `media` `shipping_method.media` ON `shipping_method` . `media_id` = `shipping_method.media` . `id`
LEFT JOIN (
SELECT
`shipping_method.translation` . `shipping_method_id` ,
`shipping_method.translation` . `name` as `shipping_method.translation.name` ,
`shipping_method.translation` . `custom_fields` as `shipping_method.translation.customFields` ,
`shipping_method.translation` . `description` as `shipping_method.translation.description` ,
`shipping_method.translation` . `tracking_url` as `shipping_method.translation.trackingUrl`
FROM
`shipping_method_translation` `shipping_method.translation`
WHERE
`shipping_method.translation` . `language_id` = ?
) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation` . `shipping_method_id` = `shipping_method` . `id`
LEFT JOIN (
SELECT
`shipping_method.deliveryTime.translation` . `delivery_time_id` ,
`shipping_method.deliveryTime.translation` . `name` as `shipping_method.deliveryTime.translation.name` ,
`shipping_method.deliveryTime.translation` . `custom_fields` as `shipping_method.deliveryTime.translation.customFields`
FROM
`delivery_time_translation` `shipping_method.deliveryTime.translation`
WHERE
`shipping_method.deliveryTime.translation` . `language_id` = ?
) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation` . `delivery_time_id` = `shipping_method.deliveryTime` . `id`
LEFT JOIN (
SELECT
`shipping_method.media.translation` . `media_id` ,
`shipping_method.media.translation` . `alt` as `shipping_method.media.translation.alt` ,
`shipping_method.media.translation` . `title` as `shipping_method.media.translation.title` ,
`shipping_method.media.translation` . `custom_fields` as `shipping_method.media.translation.customFields`
FROM
`media_translation` `shipping_method.media.translation`
WHERE
`shipping_method.media.translation` . `language_id` = ?
) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation` . `media_id` = `shipping_method.media` . `id`
WHERE
`shipping_method` . `id` IN (? )
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.name` , `shipping_method.deliveryTime.translation.name` as `shipping_method.deliveryTime.name` , `shipping_method.deliveryTime.translation.customFields` , `shipping_method.deliveryTime.translation.customFields` as `shipping_method.deliveryTime.customFields` , `shipping_method.appShippingMethod` . `id` as `shipping_method.appShippingMethod.id` , `shipping_method.appShippingMethod` . `app_name` as `shipping_method.appShippingMethod.appName` , `shipping_method.appShippingMethod` . `identifier` as `shipping_method.appShippingMethod.identifier` , `shipping_method.appShippingMethod` . `app_id` as `shipping_method.appShippingMethod.appId` , `shipping_method.appShippingMethod` . `shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId` , `shipping_method.appShippingMethod` . `original_media_id` as `shipping_method.appShippingMethod.originalMediaId` , `shipping_method.appShippingMethod` . `created_at` as `shipping_method.appShippingMethod.createdAt` , `shipping_method.appShippingMethod` . `updated_at` as `shipping_method.appShippingMethod.updatedAt` , `shipping_method` . `technical_name` as `shipping_method.technicalName` , `shipping_method` . `created_at` as `shipping_method.createdAt` , `shipping_method` . `updated_at` as `shipping_method.updatedAt` , `shipping_method.media` . `id` as `shipping_method.media.id` , `shipping_method.media` . `user_id` as `shipping_method.media.userId` , `shipping_method.media` . `media_folder_id` as `shipping_method.media.mediaFolderId` , `shipping_method.media` . `mime_type` as `shipping_method.media.mimeType` , `shipping_method.media` . `file_extension` as `shipping_method.media.fileExtension` , `shipping_method.media` . `uploaded_at` as `shipping_method.media.uploadedAt` , `shipping_method.media` . `file_name` as `shipping_method.media.fileName` , `shipping_method.media` . `file_size` as `shipping_method.media.fileSize` , `shipping_method.media` . `media_type` as `shipping_method.media.mediaTypeRaw` , `shipping_method.media` . `meta_data` as `shipping_method.media.metaData` , `shipping_method.media` . `config` as `shipping_method.media.config` , `shipping_method.media` . `path` as `shipping_method.media.path` , `shipping_method.media` . `private` as `shipping_method.media.private` , `shipping_method.media` . `thumbnails_ro` as `shipping_method.media.thumbnailsRo` , `shipping_method.media` . `created_at` as `shipping_method.media.createdAt` , `shipping_method.media` . `updated_at` as `shipping_method.media.updatedAt` , `shipping_method.media.translation.title` , `shipping_method.media.translation.title` as `shipping_method.media.title` , `shipping_method.media.translation.alt` , `shipping_method.media.translation.alt` as `shipping_method.media.alt` , `shipping_method.media.translation.customFields` , `shipping_method.media.translation.customFields` as `shipping_method.media.customFields` , `shipping_method.translation.name` , `shipping_method.translation.name` as `shipping_method.name` , `shipping_method.translation.description` , `shipping_method.translation.description` as `shipping_method.description` , `shipping_method.translation.trackingUrl` , `shipping_method.translation.trackingUrl` as `shipping_method.trackingUrl` , `shipping_method.translation.customFields` , `shipping_method.translation.customFields` as `shipping_method.customFields` FROM `shipping_method` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method` . `delivery_time_id` = `shipping_method.deliveryTime` . `id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method` . `id` = `shipping_method.appShippingMethod` . `shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method` . `media_id` = `shipping_method.media` . `id` LEFT JOIN (SELECT `shipping_method.translation` . `shipping_method_id` , `shipping_method.translation` . `name` as `shipping_method.translation.name` , `shipping_method.translation` . `custom_fields` as `shipping_method.translation.customFields` , `shipping_method.translation` . `description` as `shipping_method.translation.description` , `shipping_method.translation` . `tracking_url` as `shipping_method.translation.trackingUrl` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation` . `language_id` = 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` . `custom_fields` as `shipping_method.deliveryTime.translation.customFields` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` 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` . `title` as `shipping_method.media.translation.title` , `shipping_method.media.translation` . `custom_fields` as `shipping_method.media.translation.customFields` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation` . `media_id` = `shipping_method.media` . `id` WHERE `shipping_method` . `id` IN (0x01934C7FB90A711E9304A2FFC48E33D0 );
Copy
22
0.25 ms
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"\x01 ôL\x7F ┤wsRÉÓ,¥5┬┌Ñ ]
SELECT `currency_country_rounding` . `id` FROM `currency_country_rounding` WHERE (`currency_country_rounding` . `currency_id` = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA AND `currency_country_rounding` . `country_id` = 0x01934C7FB477735290E02CBE35C2DAA5 ) LIMIT 1 ;
Copy
23
0.26 ms
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = ?
Parameters :
[
"TxLfMYWsE7JVWCWTRGqu1FzylwR8Htzd "
]
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = 'TxLfMYWsE7JVWCWTRGqu1FzylwR8Htzd' ;
Copy
24
0.27 ms
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
25
0.35 ms
SELECT `rule` . `id` as `rule.id` , `rule` . `name` as `rule.name` , `rule` . `priority` as `rule.priority` , `rule` . `description` as `rule.description` , `rule` . `payload` as `rule.payload` , `rule` . `invalid` as `rule.invalid` , `rule` . `areas` as `rule.areas` , `rule` . `custom_fields` as `rule.customFields` , `rule` . `module_types` as `rule.moduleTypes` , `rule` . `created_at` as `rule.createdAt` , `rule` . `updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule` . `id` IN (? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"\x01 “L\x7F ¸Óp\x16 ³\x1D ¢GØk‘…\x01 “L\x7F ¹\n q\x1E “\x04 ¢ÿÅ+\e 0
"""
b"\x01 “L\x7F ¹os̤ñÏbÒ\x04 Õà\x01 “L\x7F Ìïs9‚\x1E 1öb\x7F „#\x01 “L\x7F ¹iqн¶¢Ó«½ƒá\x01 “L\x7F ¹lpHŽÍ~rwÍU§\x01 ôLÇ\x10 ösÒ¿«¾ØIñRv ]
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 (0x01934C7FB8D37016B31DA247D86B9185 , 0x01934C7FB90A711E9304A2FFC52B1B30 , 0x01934C7FB96F73CCA4F1CF62D204D5E0 , 0x01934C7FCCEF7339821E31F6627F8423 , 0x01934C7FB96971D0BDB6A2D3ABBD83E1 , 0x01934C7FB96C70488ECD7E7277CD55A7 , 0x01934C80109473E3A8AEF39D49A45276 );
Copy
26
0.47 ms
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
27
0.27 ms
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
28
0.25 ms
SELECT `sales_channel_country` . `sales_channel_id` , `sales_channel_country` . `country_id` FROM `sales_channel_country` WHERE (`sales_channel_country` . `sales_channel_id` = ? AND `sales_channel_country` . `country_id` = ? )
Parameters :
[
b"\x01 “L€L{pü’£¶í¿Ñ^ú\x01 ôL\x7F ┤wsRÉÓ,¥5┬┌Ñ ]
SELECT `sales_channel_country` . `sales_channel_id` , `sales_channel_country` . `country_id` FROM `sales_channel_country` WHERE (`sales_channel_country` . `sales_channel_id` = 0x01934C804C7B70FC92A3B6EDBFD15EFA AND `sales_channel_country` . `country_id` = 0x01934C7FB477735290E02CBE35C2DAA5 ); Copy
29
0.36 ms
SELECT `rule` . `id` as `rule.id` , `rule` . `name` as `rule.name` , `rule` . `priority` as `rule.priority` , `rule` . `description` as `rule.description` , `rule` . `payload` as `rule.payload` , `rule` . `invalid` as `rule.invalid` , `rule` . `areas` as `rule.areas` , `rule` . `custom_fields` as `rule.customFields` , `rule` . `module_types` as `rule.moduleTypes` , `rule` . `created_at` as `rule.createdAt` , `rule` . `updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule` . `id` IN (? , ? , ? , ? )
Parameters :
[
b"\x01 “L\x7F ¸Óp\x16 ³\x1D ¢GØk‘…\x01 “L\x7F ¹\n q\x1E “\x04 ¢ÿÅ+\e 0
"""
b"\x01 “L\x7F Ìïs9‚\x1E 1öb\x7F „#\x01 “L\x7F ¹lpHŽÍ~rwÍU§ ]
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 (0x01934C7FB8D37016B31DA247D86B9185 , 0x01934C7FB90A711E9304A2FFC52B1B30 , 0x01934C7FCCEF7339821E31F6627F8423 , 0x01934C7FB96C70488ECD7E7277CD55A7 ); Copy