4.00 ms (10.56%)
5
SELECT `language` . `id` as `language.id` , `language` . `parent_id` as `language.parentId` , `language` . `locale_id` as `language.localeId` , `language` . `translation_code_id` as `language.translationCodeId` , `language` . `name` as `language.name` , `language` . `active` as `language.active` , `language` . `custom_fields` as `language.customFields` , `language` . `created_at` as `language.createdAt` , `language` . `updated_at` as `language.updatedAt` , `language.locale` . `id` as `language.locale.id` , `language.locale` . `code` as `language.locale.code` , `language.locale` . `created_at` as `language.locale.createdAt` , `language.locale` . `updated_at` as `language.locale.updatedAt` , `language.locale.translation.name` , `language.locale.translation.name` as `language.locale.name` , `language.locale.translation.territory` , `language.locale.translation.territory` as `language.locale.territory` , `language.locale.translation.customFields` , `language.locale.translation.customFields` as `language.locale.customFields` FROM `language` LEFT JOIN `locale` `language.locale` ON `language` . `locale_id` = `language.locale` . `id` LEFT JOIN (SELECT `language.locale.translation` . `locale_id` , `language.locale.translation` . `name` as `language.locale.translation.name` , `language.locale.translation` . `territory` as `language.locale.translation.territory` , `language.locale.translation` . `custom_fields` as `language.locale.translation.customFields` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation` . `language_id` = ? ) `language.locale.locale_translation` ON `language.locale.locale_translation` . `locale_id` = `language.locale` . `id` WHERE `language` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `language` . `id` as `language.id` , `language` . `parent_id` as `language.parentId` , `language` . `locale_id` as `language.localeId` , `language` . `translation_code_id` as `language.translationCodeId` , `language` . `name` as `language.name` , `language` . `active` as `language.active` , `language` . `custom_fields` as `language.customFields` , `language` . `created_at` as `language.createdAt` , `language` . `updated_at` as `language.updatedAt` , `language.locale` . `id` as `language.locale.id` , `language.locale` . `code` as `language.locale.code` , `language.locale` . `created_at` as `language.locale.createdAt` , `language.locale` . `updated_at` as `language.locale.updatedAt` , `language.locale.translation.name` , `language.locale.translation.name` as `language.locale.name` , `language.locale.translation.territory` , `language.locale.translation.territory` as `language.locale.territory` , `language.locale.translation.customFields` , `language.locale.translation.customFields` as `language.locale.customFields` FROM `language` LEFT JOIN `locale` `language.locale` ON `language` . `locale_id` = `language.locale` . `id` LEFT JOIN (SELECT `language.locale.translation` . `locale_id` , `language.locale.translation` . `name` as `language.locale.translation.name` , `language.locale.translation` . `territory` as `language.locale.translation.territory` , `language.locale.translation` . `custom_fields` as `language.locale.translation.customFields` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `language.locale.locale_translation` ON `language.locale.locale_translation` . `locale_id` = `language.locale` . `id` WHERE `language` . `id` IN (0x2FBB5FE2E29A4D70AA5854CE7CE3E20B );
Copy
3.42 ms (9.03%)
1
SELECT LOWER (HEX (ct . category_id ))
FROM category_translation ct
WHERE ct . link_type = ?
AND ct . internal_link = ?
LIMIT 1
Parameters :
[
"landing_page "
b"\x01 ŽPæ:*~'»¿X€eÏ¾Ý "
]
SELECT LOWER (HEX (ct . category_id ))
FROM category_translation ct
WHERE ct . link_type = 'landing_page'
AND ct . internal_link = 0x018E50E63A2A7E27BBBF588065CFBEDD
LIMIT 1 ;
Copy
1.88 ms (4.97%)
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
1.72 ms (4.54%)
1
SELECT `prems_discount_category_base` . `id` as `prems_discount_category_base.id` , `prems_discount_category_base` . `discount` as `prems_discount_category_base.discount` , `prems_discount_category_base` . `active` as `prems_discount_category_base.active` , `prems_discount_category_base` . `is_upprice` as `prems_discount_category_base.isUpprice` , `prems_discount_category_base` . `valid_from` as `prems_discount_category_base.validFrom` , `prems_discount_category_base` . `valid_until` as `prems_discount_category_base.validUntil` , `prems_discount_category_base` . `valid_until_visibility` as `prems_discount_category_base.validUntilVisibility` , `prems_discount_category_base` . `priority` as `prems_discount_category_base.priority` , `prems_discount_category_base` . `type` as `prems_discount_category_base.type` , `prems_discount_category_base` . `price_rounding` as `prems_discount_category_base.priceRounding` , `prems_discount_category_base` . `number_of_orders` as `prems_discount_category_base.numberOfOrders` , `prems_discount_category_base` . `display_type_discount_on_detail_page` as `prems_discount_category_base.displayTypeDiscountOnDetailPage` , `prems_discount_category_base` . `display_type_discount_on_listing_page` as `prems_discount_category_base.displayTypeDiscountOnListingPage` , `prems_discount_category_base` . `discount_product_stream_id` as `prems_discount_category_base.discountProductStreamId` , `prems_discount_category_base` . `discount_category_ids` as `prems_discount_category_base.discountCategoryIds` , `prems_discount_category_base` . `category_ids_mode` as `prems_discount_category_base.categoryIdsMode` , `prems_discount_category_base` . `show_discount_badge_in_listing` as `prems_discount_category_base.showDiscountBadgeInListing` , `prems_discount_category_base` . `listing_badge_text_color` as `prems_discount_category_base.listingBadgeTextColor` , `prems_discount_category_base` . `listing_badge_background_color` as `prems_discount_category_base.listingBadgeBackgroundColor` , `prems_discount_category_base` . `show_discount_infobox_in_listing` as `prems_discount_category_base.showDiscountInfoboxInListing` , `prems_discount_category_base` . `listing_infobox_icon` as `prems_discount_category_base.listingInfoboxIcon` , `prems_discount_category_base` . `listing_infobox_text_color` as `prems_discount_category_base.listingInfoboxTextColor` , `prems_discount_category_base` . `listing_infobox_background_color` as `prems_discount_category_base.listingInfoboxBackgroundColor` , `prems_discount_category_base` . `show_discount_infobox_on_detailpage` as `prems_discount_category_base.showDiscountInfoboxOnDetailpage` , `prems_discount_category_base` . `detailpage_infobox_icon` as `prems_discount_category_base.detailpageInfoboxIcon` , `prems_discount_category_base` . `detailpage_infobox_text_color` as `prems_discount_category_base.detailpageInfoboxTextColor` , `prems_discount_category_base` . `detailpage_infobox_background_color` as `prems_discount_category_base.detailpageInfoboxBackgroundColor` , `prems_discount_category_base` . `required_cookie_name` as `prems_discount_category_base.requiredCookieName` , `prems_discount_category_base` . `required_cookie_value` as `prems_discount_category_base.requiredCookieValue` , `prems_discount_category_base` . `required_url_parameter_name` as `prems_discount_category_base.requiredUrlParameterName` , `prems_discount_category_base` . `required_url_parameter_value` as `prems_discount_category_base.requiredUrlParameterValue` , `prems_discount_category_base` . `discount_customer_group_ids` as `prems_discount_category_base.discountCustomerGroupIds` , `prems_discount_category_base` . `discount_customer_ids` as `prems_discount_category_base.discountCustomerIds` , `prems_discount_category_base` . `discount_sales_channel_ids` as `prems_discount_category_base.discountSalesChannelIds` , `prems_discount_category_base` . `discount_promotions_ids` as `prems_discount_category_base.discountPromotionIds` , `prems_discount_category_base` . `block_all_other_promotions` as `prems_discount_category_base.blockAllOtherPromotions` , `prems_discount_category_base` . `created_at` as `prems_discount_category_base.createdAt` , `prems_discount_category_base` . `updated_at` as `prems_discount_category_base.updatedAt` , `prems_discount_category_base.translation.name` , `prems_discount_category_base.translation.name` as `prems_discount_category_base.name` , `prems_discount_category_base.translation.listingBadgeTitle` , `prems_discount_category_base.translation.listingBadgeTitle` as `prems_discount_category_base.listingBadgeTitle` , `prems_discount_category_base.translation.listingInfoboxTitle` , `prems_discount_category_base.translation.listingInfoboxTitle` as `prems_discount_category_base.listingInfoboxTitle` , `prems_discount_category_base.translation.listingInfoboxText` , `prems_discount_category_base.translation.listingInfoboxText` as `prems_discount_category_base.listingInfoboxText` , `prems_discount_category_base.translation.detailpageInfoboxTitle` , `prems_discount_category_base.translation.detailpageInfoboxTitle` as `prems_discount_category_base.detailpageInfoboxTitle` , `prems_discount_category_base.translation.detailpageInfoboxText` , `prems_discount_category_base.translation.detailpageInfoboxText` as `prems_discount_category_base.detailpageInfoboxText` FROM `prems_discount_category_base` LEFT JOIN (SELECT `prems_discount_category_base.translation` . `prems_discount_category_base_id` , `prems_discount_category_base.translation` . `name` as `prems_discount_category_base.translation.name` , `prems_discount_category_base.translation` . `listing_badge_title` as `prems_discount_category_base.translation.listingBadgeTitle` , `prems_discount_category_base.translation` . `listing_infobox_title` as `prems_discount_category_base.translation.listingInfoboxTitle` , `prems_discount_category_base.translation` . `listing_infobox_text` as `prems_discount_category_base.translation.listingInfoboxText` , `prems_discount_category_base.translation` . `detailpage_infobox_title` as `prems_discount_category_base.translation.detailpageInfoboxTitle` , `prems_discount_category_base.translation` . `detailpage_infobox_text` as `prems_discount_category_base.translation.detailpageInfoboxText` FROM `prems_discount_category_base_translation` `prems_discount_category_base.translation` WHERE `prems_discount_category_base.translation` . `language_id` = ? ) `prems_discount_category_base.prems_discount_category_base_translation` ON `prems_discount_category_base.prems_discount_category_base_translation` . `prems_discount_category_base_id` = `prems_discount_category_base` . `id` WHERE (((`prems_discount_category_base` . `valid_from` < = ? ) OR `prems_discount_category_base` . `valid_from` < = > ? ) AND ((`prems_discount_category_base` . `valid_until` > = ? ) OR `prems_discount_category_base` . `valid_until` < = > ? ) AND `prems_discount_category_base` . `active` = ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
"2026-08-13 05:38:58.072 "
null
"2026-08-13 05:38:58.072 "
null
true
]
SELECT
`prems_discount_category_base` . `id` as `prems_discount_category_base.id` ,
`prems_discount_category_base` . `discount` as `prems_discount_category_base.discount` ,
`prems_discount_category_base` . `active` as `prems_discount_category_base.active` ,
`prems_discount_category_base` . `is_upprice` as `prems_discount_category_base.isUpprice` ,
`prems_discount_category_base` . `valid_from` as `prems_discount_category_base.validFrom` ,
`prems_discount_category_base` . `valid_until` as `prems_discount_category_base.validUntil` ,
`prems_discount_category_base` . `valid_until_visibility` as `prems_discount_category_base.validUntilVisibility` ,
`prems_discount_category_base` . `priority` as `prems_discount_category_base.priority` ,
`prems_discount_category_base` . `type` as `prems_discount_category_base.type` ,
`prems_discount_category_base` . `price_rounding` as `prems_discount_category_base.priceRounding` ,
`prems_discount_category_base` . `number_of_orders` as `prems_discount_category_base.numberOfOrders` ,
`prems_discount_category_base` . `display_type_discount_on_detail_page` as `prems_discount_category_base.displayTypeDiscountOnDetailPage` ,
`prems_discount_category_base` . `display_type_discount_on_listing_page` as `prems_discount_category_base.displayTypeDiscountOnListingPage` ,
`prems_discount_category_base` . `discount_product_stream_id` as `prems_discount_category_base.discountProductStreamId` ,
`prems_discount_category_base` . `discount_category_ids` as `prems_discount_category_base.discountCategoryIds` ,
`prems_discount_category_base` . `category_ids_mode` as `prems_discount_category_base.categoryIdsMode` ,
`prems_discount_category_base` . `show_discount_badge_in_listing` as `prems_discount_category_base.showDiscountBadgeInListing` ,
`prems_discount_category_base` . `listing_badge_text_color` as `prems_discount_category_base.listingBadgeTextColor` ,
`prems_discount_category_base` . `listing_badge_background_color` as `prems_discount_category_base.listingBadgeBackgroundColor` ,
`prems_discount_category_base` . `show_discount_infobox_in_listing` as `prems_discount_category_base.showDiscountInfoboxInListing` ,
`prems_discount_category_base` . `listing_infobox_icon` as `prems_discount_category_base.listingInfoboxIcon` ,
`prems_discount_category_base` . `listing_infobox_text_color` as `prems_discount_category_base.listingInfoboxTextColor` ,
`prems_discount_category_base` . `listing_infobox_background_color` as `prems_discount_category_base.listingInfoboxBackgroundColor` ,
`prems_discount_category_base` . `show_discount_infobox_on_detailpage` as `prems_discount_category_base.showDiscountInfoboxOnDetailpage` ,
`prems_discount_category_base` . `detailpage_infobox_icon` as `prems_discount_category_base.detailpageInfoboxIcon` ,
`prems_discount_category_base` . `detailpage_infobox_text_color` as `prems_discount_category_base.detailpageInfoboxTextColor` ,
`prems_discount_category_base` . `detailpage_infobox_background_color` as `prems_discount_category_base.detailpageInfoboxBackgroundColor` ,
`prems_discount_category_base` . `required_cookie_name` as `prems_discount_category_base.requiredCookieName` ,
`prems_discount_category_base` . `required_cookie_value` as `prems_discount_category_base.requiredCookieValue` ,
`prems_discount_category_base` . `required_url_parameter_name` as `prems_discount_category_base.requiredUrlParameterName` ,
`prems_discount_category_base` . `required_url_parameter_value` as `prems_discount_category_base.requiredUrlParameterValue` ,
`prems_discount_category_base` . `discount_customer_group_ids` as `prems_discount_category_base.discountCustomerGroupIds` ,
`prems_discount_category_base` . `discount_customer_ids` as `prems_discount_category_base.discountCustomerIds` ,
`prems_discount_category_base` . `discount_sales_channel_ids` as `prems_discount_category_base.discountSalesChannelIds` ,
`prems_discount_category_base` . `discount_promotions_ids` as `prems_discount_category_base.discountPromotionIds` ,
`prems_discount_category_base` . `block_all_other_promotions` as `prems_discount_category_base.blockAllOtherPromotions` ,
`prems_discount_category_base` . `created_at` as `prems_discount_category_base.createdAt` ,
`prems_discount_category_base` . `updated_at` as `prems_discount_category_base.updatedAt` ,
`prems_discount_category_base.translation.name` ,
`prems_discount_category_base.translation.name` as `prems_discount_category_base.name` ,
`prems_discount_category_base.translation.listingBadgeTitle` ,
`prems_discount_category_base.translation.listingBadgeTitle` as `prems_discount_category_base.listingBadgeTitle` ,
`prems_discount_category_base.translation.listingInfoboxTitle` ,
`prems_discount_category_base.translation.listingInfoboxTitle` as `prems_discount_category_base.listingInfoboxTitle` ,
`prems_discount_category_base.translation.listingInfoboxText` ,
`prems_discount_category_base.translation.listingInfoboxText` as `prems_discount_category_base.listingInfoboxText` ,
`prems_discount_category_base.translation.detailpageInfoboxTitle` ,
`prems_discount_category_base.translation.detailpageInfoboxTitle` as `prems_discount_category_base.detailpageInfoboxTitle` ,
`prems_discount_category_base.translation.detailpageInfoboxText` ,
`prems_discount_category_base.translation.detailpageInfoboxText` as `prems_discount_category_base.detailpageInfoboxText`
FROM
`prems_discount_category_base`
LEFT JOIN (
SELECT
`prems_discount_category_base.translation` . `prems_discount_category_base_id` ,
`prems_discount_category_base.translation` . `name` as `prems_discount_category_base.translation.name` ,
`prems_discount_category_base.translation` . `listing_badge_title` as `prems_discount_category_base.translation.listingBadgeTitle` ,
`prems_discount_category_base.translation` . `listing_infobox_title` as `prems_discount_category_base.translation.listingInfoboxTitle` ,
`prems_discount_category_base.translation` . `listing_infobox_text` as `prems_discount_category_base.translation.listingInfoboxText` ,
`prems_discount_category_base.translation` . `detailpage_infobox_title` as `prems_discount_category_base.translation.detailpageInfoboxTitle` ,
`prems_discount_category_base.translation` . `detailpage_infobox_text` as `prems_discount_category_base.translation.detailpageInfoboxText`
FROM
`prems_discount_category_base_translation` `prems_discount_category_base.translation`
WHERE
`prems_discount_category_base.translation` . `language_id` = ?
) `prems_discount_category_base.prems_discount_category_base_translation` ON `prems_discount_category_base.prems_discount_category_base_translation` . `prems_discount_category_base_id` = `prems_discount_category_base` . `id`
WHERE
(
(
(
`prems_discount_category_base` . `valid_from` < = ?
)
OR `prems_discount_category_base` . `valid_from` < = > ?
)
AND (
(
`prems_discount_category_base` . `valid_until` > = ?
)
OR `prems_discount_category_base` . `valid_until` < = > ?
)
AND `prems_discount_category_base` . `active` = ?
)
Copy
SELECT `prems_discount_category_base` . `id` as `prems_discount_category_base.id` , `prems_discount_category_base` . `discount` as `prems_discount_category_base.discount` , `prems_discount_category_base` . `active` as `prems_discount_category_base.active` , `prems_discount_category_base` . `is_upprice` as `prems_discount_category_base.isUpprice` , `prems_discount_category_base` . `valid_from` as `prems_discount_category_base.validFrom` , `prems_discount_category_base` . `valid_until` as `prems_discount_category_base.validUntil` , `prems_discount_category_base` . `valid_until_visibility` as `prems_discount_category_base.validUntilVisibility` , `prems_discount_category_base` . `priority` as `prems_discount_category_base.priority` , `prems_discount_category_base` . `type` as `prems_discount_category_base.type` , `prems_discount_category_base` . `price_rounding` as `prems_discount_category_base.priceRounding` , `prems_discount_category_base` . `number_of_orders` as `prems_discount_category_base.numberOfOrders` , `prems_discount_category_base` . `display_type_discount_on_detail_page` as `prems_discount_category_base.displayTypeDiscountOnDetailPage` , `prems_discount_category_base` . `display_type_discount_on_listing_page` as `prems_discount_category_base.displayTypeDiscountOnListingPage` , `prems_discount_category_base` . `discount_product_stream_id` as `prems_discount_category_base.discountProductStreamId` , `prems_discount_category_base` . `discount_category_ids` as `prems_discount_category_base.discountCategoryIds` , `prems_discount_category_base` . `category_ids_mode` as `prems_discount_category_base.categoryIdsMode` , `prems_discount_category_base` . `show_discount_badge_in_listing` as `prems_discount_category_base.showDiscountBadgeInListing` , `prems_discount_category_base` . `listing_badge_text_color` as `prems_discount_category_base.listingBadgeTextColor` , `prems_discount_category_base` . `listing_badge_background_color` as `prems_discount_category_base.listingBadgeBackgroundColor` , `prems_discount_category_base` . `show_discount_infobox_in_listing` as `prems_discount_category_base.showDiscountInfoboxInListing` , `prems_discount_category_base` . `listing_infobox_icon` as `prems_discount_category_base.listingInfoboxIcon` , `prems_discount_category_base` . `listing_infobox_text_color` as `prems_discount_category_base.listingInfoboxTextColor` , `prems_discount_category_base` . `listing_infobox_background_color` as `prems_discount_category_base.listingInfoboxBackgroundColor` , `prems_discount_category_base` . `show_discount_infobox_on_detailpage` as `prems_discount_category_base.showDiscountInfoboxOnDetailpage` , `prems_discount_category_base` . `detailpage_infobox_icon` as `prems_discount_category_base.detailpageInfoboxIcon` , `prems_discount_category_base` . `detailpage_infobox_text_color` as `prems_discount_category_base.detailpageInfoboxTextColor` , `prems_discount_category_base` . `detailpage_infobox_background_color` as `prems_discount_category_base.detailpageInfoboxBackgroundColor` , `prems_discount_category_base` . `required_cookie_name` as `prems_discount_category_base.requiredCookieName` , `prems_discount_category_base` . `required_cookie_value` as `prems_discount_category_base.requiredCookieValue` , `prems_discount_category_base` . `required_url_parameter_name` as `prems_discount_category_base.requiredUrlParameterName` , `prems_discount_category_base` . `required_url_parameter_value` as `prems_discount_category_base.requiredUrlParameterValue` , `prems_discount_category_base` . `discount_customer_group_ids` as `prems_discount_category_base.discountCustomerGroupIds` , `prems_discount_category_base` . `discount_customer_ids` as `prems_discount_category_base.discountCustomerIds` , `prems_discount_category_base` . `discount_sales_channel_ids` as `prems_discount_category_base.discountSalesChannelIds` , `prems_discount_category_base` . `discount_promotions_ids` as `prems_discount_category_base.discountPromotionIds` , `prems_discount_category_base` . `block_all_other_promotions` as `prems_discount_category_base.blockAllOtherPromotions` , `prems_discount_category_base` . `created_at` as `prems_discount_category_base.createdAt` , `prems_discount_category_base` . `updated_at` as `prems_discount_category_base.updatedAt` , `prems_discount_category_base.translation.name` , `prems_discount_category_base.translation.name` as `prems_discount_category_base.name` , `prems_discount_category_base.translation.listingBadgeTitle` , `prems_discount_category_base.translation.listingBadgeTitle` as `prems_discount_category_base.listingBadgeTitle` , `prems_discount_category_base.translation.listingInfoboxTitle` , `prems_discount_category_base.translation.listingInfoboxTitle` as `prems_discount_category_base.listingInfoboxTitle` , `prems_discount_category_base.translation.listingInfoboxText` , `prems_discount_category_base.translation.listingInfoboxText` as `prems_discount_category_base.listingInfoboxText` , `prems_discount_category_base.translation.detailpageInfoboxTitle` , `prems_discount_category_base.translation.detailpageInfoboxTitle` as `prems_discount_category_base.detailpageInfoboxTitle` , `prems_discount_category_base.translation.detailpageInfoboxText` , `prems_discount_category_base.translation.detailpageInfoboxText` as `prems_discount_category_base.detailpageInfoboxText` FROM `prems_discount_category_base` LEFT JOIN (SELECT `prems_discount_category_base.translation` . `prems_discount_category_base_id` , `prems_discount_category_base.translation` . `name` as `prems_discount_category_base.translation.name` , `prems_discount_category_base.translation` . `listing_badge_title` as `prems_discount_category_base.translation.listingBadgeTitle` , `prems_discount_category_base.translation` . `listing_infobox_title` as `prems_discount_category_base.translation.listingInfoboxTitle` , `prems_discount_category_base.translation` . `listing_infobox_text` as `prems_discount_category_base.translation.listingInfoboxText` , `prems_discount_category_base.translation` . `detailpage_infobox_title` as `prems_discount_category_base.translation.detailpageInfoboxTitle` , `prems_discount_category_base.translation` . `detailpage_infobox_text` as `prems_discount_category_base.translation.detailpageInfoboxText` FROM `prems_discount_category_base_translation` `prems_discount_category_base.translation` WHERE `prems_discount_category_base.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `prems_discount_category_base.prems_discount_category_base_translation` ON `prems_discount_category_base.prems_discount_category_base_translation` . `prems_discount_category_base_id` = `prems_discount_category_base` . `id` WHERE (((`prems_discount_category_base` . `valid_from` < = '2026-08-13 05:38:58.072' ) OR `prems_discount_category_base` . `valid_from` < = > NULL ) AND ((`prems_discount_category_base` . `valid_until` > = '2026-08-13 05:38:58.072' ) OR `prems_discount_category_base` . `valid_until` < = > NULL ) AND `prems_discount_category_base` . `active` = 1 );
Copy
1.66 ms (4.39%)
1
SELECT `landing_page` . `id` FROM `landing_page` LEFT JOIN `swag_dynamic_access_landing_page_rule` `landing_page.swagDynamicAccessRules.mapping` ON `landing_page` . `id` = `landing_page.swagDynamicAccessRules.mapping` . `landing_page_id` AND `landing_page` . `version_id` = `landing_page.swagDynamicAccessRules.mapping` . `landing_page_version_id` LEFT JOIN `landing_page_sales_channel` `landing_page.salesChannels.mapping` ON `landing_page` . `id` = `landing_page.salesChannels.mapping` . `landing_page_id` AND `landing_page` . `version_id` = `landing_page.salesChannels.mapping` . `landing_page_version_id` LEFT JOIN `rule` `landing_page.swagDynamicAccessRules` ON `landing_page.swagDynamicAccessRules.mapping` . `rule_id` = `landing_page.swagDynamicAccessRules` . `id` LEFT JOIN `sales_channel` `landing_page.salesChannels` ON `landing_page.salesChannels.mapping` . `sales_channel_id` = `landing_page.salesChannels` . `id` WHERE (`landing_page` . `version_id` = ? ) AND ((`landing_page` . `active` = ? AND `landing_page.salesChannels` . `id` = ? AND ((`landing_page.swagDynamicAccessRules` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )) OR `landing_page.swagDynamicAccessRules` . `id` < = > ? ))) AND (`landing_page` . `id` IN (? )) GROUP BY `landing_page` . `id`
Parameters :
[
b"\x0F ©\x1C ãéjK¾KÙÎu,4% "
true
b"\x01 šÄ\x18 ÉsK–ß¾«~—ç$ "
b"\x01 ‰‘t@\t r®Œ:æÐä°Äù "
b"\x01 ‰‘t@\x16 pN¬`– ÂÈ/ "
b"\x01 ‰‘tŽ’râ¥ßŽáZ¿^R "
b"\x01 a11åv\x19 ³\x0F M''Ú… "
b"\x01 ‰‘t@9p\x1D ¯4½¡¬\v ƒ\x1D "
b"\x01 ¤ß4Â~ã›\r Qg\f ÚB' "
b"\x01 šÌ 2sè¸:1¥#7j\ "
b"\x01 šÌ 8s{¬ä¨ÑÕX¢‹ "
b"\x01 šÌ >q7½æ¹6ê?1¶ "
b"\x01 šÌ EpN‚ÿÍW\x07 »€\x14 "
b"\x01 šÌ Ls\f Žœâ°~>>; "
b"\x01 šÌ Qq!©lqx~Q\x05\x06 "
b"\x01 šÌ Wq”£X%¤ÈŠ\x19\x10 "
b"\x01 šÌ ds[ºj¿–GylÞ "
b"\x01 šÌ-¯qk·³ú©—Âþ\x01 "
b"\x01 šÌM„rÆ”Ù\x0E «]g¤’ "
b"\x01 šÌf\x0E r¾»ð…L÷‚ñ› "
b"\x01 šÌfs‡ª/1\x0F Q®\x1D " "
b"\x01 šÌf‡sF¼ÄV4\x1F Ë\v\x02 "
b"\x01 šÌi€sáŠ{^RÑ%\x1A ˆ "
null
b"\x01 ŽPæ:*~'»¿X€eÏ¾Ý "
]
SELECT `landing_page` . `id` FROM `landing_page` LEFT JOIN `swag_dynamic_access_landing_page_rule` `landing_page.swagDynamicAccessRules.mapping` ON `landing_page` . `id` = `landing_page.swagDynamicAccessRules.mapping` . `landing_page_id` AND `landing_page` . `version_id` = `landing_page.swagDynamicAccessRules.mapping` . `landing_page_version_id` LEFT JOIN `landing_page_sales_channel` `landing_page.salesChannels.mapping` ON `landing_page` . `id` = `landing_page.salesChannels.mapping` . `landing_page_id` AND `landing_page` . `version_id` = `landing_page.salesChannels.mapping` . `landing_page_version_id` LEFT JOIN `rule` `landing_page.swagDynamicAccessRules` ON `landing_page.swagDynamicAccessRules.mapping` . `rule_id` = `landing_page.swagDynamicAccessRules` . `id` LEFT JOIN `sales_channel` `landing_page.salesChannels` ON `landing_page.salesChannels.mapping` . `sales_channel_id` = `landing_page.salesChannels` . `id` WHERE (`landing_page` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND ((`landing_page` . `active` = 1 AND `landing_page.salesChannels` . `id` = 0x018F9AC418C9734B96DFBEAB7E97E724 AND ((`landing_page.swagDynamicAccessRules` . `id` IN (0x01899174400972AE8C3AE6D0E4B0C4F9 , 0x018991744016704EAC609620C28FC82F , 0x018991748E9272E2A5DF8EE15ABF5E52 , 0x018E613131E57619B30F4D2727DA8F85 , 0x018991744039701DAF34BDA1AC0B831D , 0x018FA4DF34C27EE39B0D51670CDA4227 , 0x018F9ACC203273E8B83A31A523376A5C , 0x018F9ACC2038737BACE4A8D1D558A28B , 0x018F9ACC203E7137BDE6B936EA3F31B6 , 0x018F9ACC2045704E82FFCD5707BB8014 , 0x018F9ACC204C730C8D9CE2B07E3E3E3B , 0x018F9ACC20517121A96C71787E510506 , 0x018F9ACC20577194A35825A4C88A1910 , 0x018F9ACC2064735BBA6ABF9647796CDE , 0x018F9ACC2DAF716BB7B3FAA997C2FE01 , 0x018F9ACC4D8472C694D90EAB5D67A492 , 0x018F9ACC660E72BEBBF0854CF782F19B , 0x018F9ACC66817387AA2F310F51AE1D22 , 0x018F9ACC66877346BCC456341FCB0B02 , 0x018F9ACC698073E18A7B5E52D1251A88 )) OR `landing_page.swagDynamicAccessRules` . `id` < = > NULL ))) AND (`landing_page` . `id` IN (0x018E50E63A2A7E27BBBF588065CFBEDD )) GROUP BY `landing_page` . `id` ;
Copy
1.45 ms (3.84%)
1
SELECT
`theme_id` ,
`technical_name` ,
`resolved_config` ,
`view_inheritance` ,
`script_files` ,
`icon_sets` ,
`updated_at`
FROM `theme_runtime_config`
WHERE `technical_name` = ?
Parameters :
[
"CustomStorefront "
]
SELECT
`theme_id` ,
`technical_name` ,
`resolved_config` ,
`view_inheritance` ,
`script_files` ,
`icon_sets` ,
`updated_at`
FROM `theme_runtime_config`
WHERE `technical_name` = 'CustomStorefront' ;
Copy
1.40 ms (3.71%)
1
SELECT `media` . `id` as `media.id` , `media` . `user_id` as `media.userId` , `media` . `media_folder_id` as `media.mediaFolderId` , `media` . `mime_type` as `media.mimeType` , `media` . `file_extension` as `media.fileExtension` , `media` . `uploaded_at` as `media.uploadedAt` , `media` . `file_name` as `media.fileName` , `media` . `file_size` as `media.fileSize` , `media` . `media_type` as `media.mediaTypeRaw` , `media` . `meta_data` as `media.metaData` , `media` . `config` as `media.config` , `media` . `path` as `media.path` , `media` . `private` as `media.private` , `media` . `thumbnails_ro` as `media.thumbnailsRo` , `media` . `file_hash` as `media.fileHash` , `media` . `created_at` as `media.createdAt` , `media` . `updated_at` as `media.updatedAt` , `media.translation.title` , `media.translation.title` as `media.title` , `media.translation.alt` , `media.translation.alt` as `media.alt` , `media.translation.customFields` , `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media` . `media_folder_id` = `media.mediaFolder` . `id` LEFT JOIN (SELECT `media.translation` . `media_id` , `media.translation` . `alt` as `media.translation.alt` , `media.translation` . `title` as `media.translation.title` , `media.translation` . `custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation` . `language_id` = ? ) `media.media_translation` ON `media.media_translation` . `media_id` = `media` . `id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder` . `default_folder_id` = `media.mediaFolder.defaultFolder` . `id` WHERE (((`media` . `private` = ? OR (`media` . `private` = ? AND `media.mediaFolder.defaultFolder` . `entity` = ? )))) AND (`media` . `id` IN (? , ? , ? , ? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
false
true
"product_download "
b"\x01 ’$Cú`\x7F Þ¢q›ç±@tÏ "
b"\x01 ’$iê$qJ™©<Öª0ci "
b"\x01 ’¸U²žqi£uL]vøø "
b"\x01 ’$H=rq¸¼\x10 nk\x1C LW› "
]
SELECT `media` . `id` as `media.id` , `media` . `user_id` as `media.userId` , `media` . `media_folder_id` as `media.mediaFolderId` , `media` . `mime_type` as `media.mimeType` , `media` . `file_extension` as `media.fileExtension` , `media` . `uploaded_at` as `media.uploadedAt` , `media` . `file_name` as `media.fileName` , `media` . `file_size` as `media.fileSize` , `media` . `media_type` as `media.mediaTypeRaw` , `media` . `meta_data` as `media.metaData` , `media` . `config` as `media.config` , `media` . `path` as `media.path` , `media` . `private` as `media.private` , `media` . `thumbnails_ro` as `media.thumbnailsRo` , `media` . `file_hash` as `media.fileHash` , `media` . `created_at` as `media.createdAt` , `media` . `updated_at` as `media.updatedAt` , `media.translation.title` , `media.translation.title` as `media.title` , `media.translation.alt` , `media.translation.alt` as `media.alt` , `media.translation.customFields` , `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media` . `media_folder_id` = `media.mediaFolder` . `id` LEFT JOIN (SELECT `media.translation` . `media_id` , `media.translation` . `alt` as `media.translation.alt` , `media.translation` . `title` as `media.translation.title` , `media.translation` . `custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `media.media_translation` ON `media.media_translation` . `media_id` = `media` . `id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder` . `default_folder_id` = `media.mediaFolder.defaultFolder` . `id` WHERE (((`media` . `private` = 0 OR (`media` . `private` = 1 AND `media.mediaFolder.defaultFolder` . `entity` = 'product_download' )))) AND (`media` . `id` IN (0x01922443FA607FDEA2719BE7B14074CF , 0x01922469EA24714A99A93CD6AA306369 , 0x0192B855B29E7169A3754C5D76F8F8A0 , 0x019224483D7271B8BC106E6B1C4C579B ));
Copy
1.25 ms (3.30%)
1
SELECT id , path_info pathInfo , is_canonical isCanonical , sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ? ) AND ((sales_channel_id = ? OR sales_channel_id IS NULL )) AND ((seo_path_info = ? OR seo_path_info = ? )) AND (seo_url . is_deleted = 0 )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 šÄ\x18 ÉsK–ß¾«~—ç$ "
"werksverkauf "
"werksverkauf/ "
]
SELECT id , path_info pathInfo , is_canonical isCanonical , sales_channel_id salesChannelId FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND ((sales_channel_id = 0x018F9AC418C9734B96DFBEAB7E97E724 OR sales_channel_id IS NULL )) AND ((seo_path_info = 'werksverkauf' OR seo_path_info = 'werksverkauf/' )) AND (seo_url . is_deleted = 0 );
Copy
1.06 ms (2.81%)
1
SELECT `cms_section` . `id` as `cms_section.id` , `cms_section` . `version_id` as `cms_section.versionId` , `cms_section` . `cms_page_version_id` as `cms_section.cmsPageVersionId` , `cms_section` . `position` as `cms_section.position` , `cms_section` . `type` as `cms_section.type` , `cms_section` . `locked` as `cms_section.locked` , `cms_section` . `name` as `cms_section.name` , `cms_section` . `sizing_mode` as `cms_section.sizingMode` , `cms_section` . `mobile_behavior` as `cms_section.mobileBehavior` , `cms_section` . `background_color` as `cms_section.backgroundColor` , `cms_section` . `background_media_id` as `cms_section.backgroundMediaId` , `cms_section` . `background_media_mode` as `cms_section.backgroundMediaMode` , `cms_section` . `css_class` as `cms_section.cssClass` , `cms_section` . `cms_page_id` as `cms_section.pageId` , `cms_section` . `visibility` as `cms_section.visibility` , `cms_section` . `custom_fields` as `cms_section.customFields` , `cms_section` . `created_at` as `cms_section.createdAt` , `cms_section` . `updated_at` as `cms_section.updatedAt` , `cms_section.backgroundMedia` . `id` as `cms_section.backgroundMedia.id` , `cms_section.backgroundMedia` . `user_id` as `cms_section.backgroundMedia.userId` , `cms_section.backgroundMedia` . `media_folder_id` as `cms_section.backgroundMedia.mediaFolderId` , `cms_section.backgroundMedia` . `mime_type` as `cms_section.backgroundMedia.mimeType` , `cms_section.backgroundMedia` . `file_extension` as `cms_section.backgroundMedia.fileExtension` , `cms_section.backgroundMedia` . `uploaded_at` as `cms_section.backgroundMedia.uploadedAt` , `cms_section.backgroundMedia` . `file_name` as `cms_section.backgroundMedia.fileName` , `cms_section.backgroundMedia` . `file_size` as `cms_section.backgroundMedia.fileSize` , `cms_section.backgroundMedia` . `media_type` as `cms_section.backgroundMedia.mediaTypeRaw` , `cms_section.backgroundMedia` . `meta_data` as `cms_section.backgroundMedia.metaData` , `cms_section.backgroundMedia` . `config` as `cms_section.backgroundMedia.config` , `cms_section.backgroundMedia` . `path` as `cms_section.backgroundMedia.path` , `cms_section.backgroundMedia` . `private` as `cms_section.backgroundMedia.private` , `cms_section.backgroundMedia` . `thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo` , `cms_section.backgroundMedia` . `file_hash` as `cms_section.backgroundMedia.fileHash` , `cms_section.backgroundMedia` . `created_at` as `cms_section.backgroundMedia.createdAt` , `cms_section.backgroundMedia` . `updated_at` as `cms_section.backgroundMedia.updatedAt` , `cms_section.backgroundMedia.translation.title` , `cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title` , `cms_section.backgroundMedia.translation.alt` , `cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt` , `cms_section.backgroundMedia.translation.customFields` , `cms_section.backgroundMedia.translation.customFields` as `cms_section.backgroundMedia.customFields` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section` . `background_media_id` = `cms_section.backgroundMedia` . `id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation` . `media_id` , `cms_section.backgroundMedia.translation` . `alt` as `cms_section.backgroundMedia.translation.alt` , `cms_section.backgroundMedia.translation` . `title` as `cms_section.backgroundMedia.translation.title` , `cms_section.backgroundMedia.translation` . `custom_fields` as `cms_section.backgroundMedia.translation.customFields` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation` . `language_id` = ? ) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation` . `media_id` = `cms_section.backgroundMedia` . `id` WHERE (`cms_section` . `version_id` = ? ) AND (((`cms_section` . `cms_page_id` IN (? ))))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4% "
b"\x01 Q~Êr\r ³\x1C hƒ°{"q "
]
SELECT
`cms_section` . `id` as `cms_section.id` ,
`cms_section` . `version_id` as `cms_section.versionId` ,
`cms_section` . `cms_page_version_id` as `cms_section.cmsPageVersionId` ,
`cms_section` . `position` as `cms_section.position` ,
`cms_section` . `type` as `cms_section.type` ,
`cms_section` . `locked` as `cms_section.locked` ,
`cms_section` . `name` as `cms_section.name` ,
`cms_section` . `sizing_mode` as `cms_section.sizingMode` ,
`cms_section` . `mobile_behavior` as `cms_section.mobileBehavior` ,
`cms_section` . `background_color` as `cms_section.backgroundColor` ,
`cms_section` . `background_media_id` as `cms_section.backgroundMediaId` ,
`cms_section` . `background_media_mode` as `cms_section.backgroundMediaMode` ,
`cms_section` . `css_class` as `cms_section.cssClass` ,
`cms_section` . `cms_page_id` as `cms_section.pageId` ,
`cms_section` . `visibility` as `cms_section.visibility` ,
`cms_section` . `custom_fields` as `cms_section.customFields` ,
`cms_section` . `created_at` as `cms_section.createdAt` ,
`cms_section` . `updated_at` as `cms_section.updatedAt` ,
`cms_section.backgroundMedia` . `id` as `cms_section.backgroundMedia.id` ,
`cms_section.backgroundMedia` . `user_id` as `cms_section.backgroundMedia.userId` ,
`cms_section.backgroundMedia` . `media_folder_id` as `cms_section.backgroundMedia.mediaFolderId` ,
`cms_section.backgroundMedia` . `mime_type` as `cms_section.backgroundMedia.mimeType` ,
`cms_section.backgroundMedia` . `file_extension` as `cms_section.backgroundMedia.fileExtension` ,
`cms_section.backgroundMedia` . `uploaded_at` as `cms_section.backgroundMedia.uploadedAt` ,
`cms_section.backgroundMedia` . `file_name` as `cms_section.backgroundMedia.fileName` ,
`cms_section.backgroundMedia` . `file_size` as `cms_section.backgroundMedia.fileSize` ,
`cms_section.backgroundMedia` . `media_type` as `cms_section.backgroundMedia.mediaTypeRaw` ,
`cms_section.backgroundMedia` . `meta_data` as `cms_section.backgroundMedia.metaData` ,
`cms_section.backgroundMedia` . `config` as `cms_section.backgroundMedia.config` ,
`cms_section.backgroundMedia` . `path` as `cms_section.backgroundMedia.path` ,
`cms_section.backgroundMedia` . `private` as `cms_section.backgroundMedia.private` ,
`cms_section.backgroundMedia` . `thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo` ,
`cms_section.backgroundMedia` . `file_hash` as `cms_section.backgroundMedia.fileHash` ,
`cms_section.backgroundMedia` . `created_at` as `cms_section.backgroundMedia.createdAt` ,
`cms_section.backgroundMedia` . `updated_at` as `cms_section.backgroundMedia.updatedAt` ,
`cms_section.backgroundMedia.translation.title` ,
`cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title` ,
`cms_section.backgroundMedia.translation.alt` ,
`cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt` ,
`cms_section.backgroundMedia.translation.customFields` ,
`cms_section.backgroundMedia.translation.customFields` as `cms_section.backgroundMedia.customFields`
FROM
`cms_section`
LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section` . `background_media_id` = `cms_section.backgroundMedia` . `id`
LEFT JOIN (
SELECT
`cms_section.backgroundMedia.translation` . `media_id` ,
`cms_section.backgroundMedia.translation` . `alt` as `cms_section.backgroundMedia.translation.alt` ,
`cms_section.backgroundMedia.translation` . `title` as `cms_section.backgroundMedia.translation.title` ,
`cms_section.backgroundMedia.translation` . `custom_fields` as `cms_section.backgroundMedia.translation.customFields`
FROM
`media_translation` `cms_section.backgroundMedia.translation`
WHERE
`cms_section.backgroundMedia.translation` . `language_id` = ?
) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation` . `media_id` = `cms_section.backgroundMedia` . `id`
WHERE
(`cms_section` . `version_id` = ? )
AND (
(
(
`cms_section` . `cms_page_id` IN (? )
)
)
)
Copy
SELECT `cms_section` . `id` as `cms_section.id` , `cms_section` . `version_id` as `cms_section.versionId` , `cms_section` . `cms_page_version_id` as `cms_section.cmsPageVersionId` , `cms_section` . `position` as `cms_section.position` , `cms_section` . `type` as `cms_section.type` , `cms_section` . `locked` as `cms_section.locked` , `cms_section` . `name` as `cms_section.name` , `cms_section` . `sizing_mode` as `cms_section.sizingMode` , `cms_section` . `mobile_behavior` as `cms_section.mobileBehavior` , `cms_section` . `background_color` as `cms_section.backgroundColor` , `cms_section` . `background_media_id` as `cms_section.backgroundMediaId` , `cms_section` . `background_media_mode` as `cms_section.backgroundMediaMode` , `cms_section` . `css_class` as `cms_section.cssClass` , `cms_section` . `cms_page_id` as `cms_section.pageId` , `cms_section` . `visibility` as `cms_section.visibility` , `cms_section` . `custom_fields` as `cms_section.customFields` , `cms_section` . `created_at` as `cms_section.createdAt` , `cms_section` . `updated_at` as `cms_section.updatedAt` , `cms_section.backgroundMedia` . `id` as `cms_section.backgroundMedia.id` , `cms_section.backgroundMedia` . `user_id` as `cms_section.backgroundMedia.userId` , `cms_section.backgroundMedia` . `media_folder_id` as `cms_section.backgroundMedia.mediaFolderId` , `cms_section.backgroundMedia` . `mime_type` as `cms_section.backgroundMedia.mimeType` , `cms_section.backgroundMedia` . `file_extension` as `cms_section.backgroundMedia.fileExtension` , `cms_section.backgroundMedia` . `uploaded_at` as `cms_section.backgroundMedia.uploadedAt` , `cms_section.backgroundMedia` . `file_name` as `cms_section.backgroundMedia.fileName` , `cms_section.backgroundMedia` . `file_size` as `cms_section.backgroundMedia.fileSize` , `cms_section.backgroundMedia` . `media_type` as `cms_section.backgroundMedia.mediaTypeRaw` , `cms_section.backgroundMedia` . `meta_data` as `cms_section.backgroundMedia.metaData` , `cms_section.backgroundMedia` . `config` as `cms_section.backgroundMedia.config` , `cms_section.backgroundMedia` . `path` as `cms_section.backgroundMedia.path` , `cms_section.backgroundMedia` . `private` as `cms_section.backgroundMedia.private` , `cms_section.backgroundMedia` . `thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo` , `cms_section.backgroundMedia` . `file_hash` as `cms_section.backgroundMedia.fileHash` , `cms_section.backgroundMedia` . `created_at` as `cms_section.backgroundMedia.createdAt` , `cms_section.backgroundMedia` . `updated_at` as `cms_section.backgroundMedia.updatedAt` , `cms_section.backgroundMedia.translation.title` , `cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title` , `cms_section.backgroundMedia.translation.alt` , `cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt` , `cms_section.backgroundMedia.translation.customFields` , `cms_section.backgroundMedia.translation.customFields` as `cms_section.backgroundMedia.customFields` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section` . `background_media_id` = `cms_section.backgroundMedia` . `id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation` . `media_id` , `cms_section.backgroundMedia.translation` . `alt` as `cms_section.backgroundMedia.translation.alt` , `cms_section.backgroundMedia.translation` . `title` as `cms_section.backgroundMedia.translation.title` , `cms_section.backgroundMedia.translation` . `custom_fields` as `cms_section.backgroundMedia.translation.customFields` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation` . `media_id` = `cms_section.backgroundMedia` . `id` WHERE (`cms_section` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (((`cms_section` . `cms_page_id` IN (0x018E517E81CA720DB31C6883B07B2271 ))));
Copy
1.03 ms (2.74%)
1
SELECT COUNT (* ) FROM `wallee_transaction` LIMIT 1
SELECT COUNT (* ) FROM `wallee_transaction` LIMIT 1 ;
Copy
0.99 ms (2.63%)
1
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.translation.name` , `category.translation.name` as `category.name` , `category.translation.breadcrumb` , `category.translation.breadcrumb` as `category.breadcrumb` , `category.translation.slotConfig` , `category.translation.slotConfig` as `category.slotConfig` , `category.translation.linkType` , `category.translation.linkType` as `category.linkType` , `category.translation.internalLink` , `category.translation.internalLink` as `category.internalLink` , `category.translation.externalLink` , `category.translation.externalLink` as `category.externalLink` , `category.translation.linkNewTab` , `category.translation.linkNewTab` as `category.linkNewTab` , `category.translation.description` , `category.translation.description` as `category.description` , `category.translation.metaTitle` , `category.translation.metaTitle` as `category.metaTitle` , `category.translation.metaDescription` , `category.translation.metaDescription` as `category.metaDescription` , `category.translation.keywords` , `category.translation.keywords` as `category.keywords` , `category.translation.customFields` , `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation` . `category_id` , `category.translation` . `category_version_id` , `category.translation` . `breadcrumb` as `category.translation.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation` . `slot_config` as `category.translation.slotConfig` , `category.translation` . `link_type` as `category.translation.linkType` , `category.translation` . `internal_link` as `category.translation.internalLink` , `category.translation` . `external_link` as `category.translation.externalLink` , `category.translation` . `link_new_tab` as `category.translation.linkNewTab` , `category.translation` . `description` as `category.translation.description` , `category.translation` . `meta_title` as `category.translation.metaTitle` , `category.translation` . `meta_description` as `category.translation.metaDescription` , `category.translation` . `keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation` . `language_id` = ? ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . `category_version_id` = `category` . `version_id` WHERE (`category` . `version_id` = ? ) AND (`category` . `id` IN (? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4% "
b"""
\x01 šÄ\x12 :rŽœ\x16 \n
©3…Je
"""
]
SELECT
`category` . `id` as `category.id` ,
`category` . `version_id` as `category.versionId` ,
`category` . `parent_id` as `category.parentId` ,
`category` . `parent_version_id` as `category.parentVersionId` ,
`category` . `after_category_id` as `category.afterCategoryId` ,
`category` . `after_category_version_id` as `category.afterCategoryVersionId` ,
`category` . `media_id` as `category.mediaId` ,
`category` . `display_nested_products` as `category.displayNestedProducts` ,
`category` . `auto_increment` as `category.autoIncrement` ,
`category` . `level` as `category.level` ,
`category` . `path` as `category.path` ,
`category` . `child_count` as `category.childCount` ,
`category` . `type` as `category.type` ,
`category` . `product_assignment_type` as `category.productAssignmentType` ,
`category` . `visible` as `category.visible` ,
`category` . `active` as `category.active` ,
`category` . `cms_page_id` as `category.cmsPageId` ,
`category` . `cms_page_version_id` as `category.cmsPageVersionId` ,
`category` . `product_stream_id` as `category.productStreamId` ,
`category` . `custom_entity_type_id` as `category.customEntityTypeId` ,
`category` . `created_at` as `category.createdAt` ,
`category` . `updated_at` as `category.updatedAt` ,
`category.translation.name` ,
`category.translation.name` as `category.name` ,
`category.translation.breadcrumb` ,
`category.translation.breadcrumb` as `category.breadcrumb` ,
`category.translation.slotConfig` ,
`category.translation.slotConfig` as `category.slotConfig` ,
`category.translation.linkType` ,
`category.translation.linkType` as `category.linkType` ,
`category.translation.internalLink` ,
`category.translation.internalLink` as `category.internalLink` ,
`category.translation.externalLink` ,
`category.translation.externalLink` as `category.externalLink` ,
`category.translation.linkNewTab` ,
`category.translation.linkNewTab` as `category.linkNewTab` ,
`category.translation.description` ,
`category.translation.description` as `category.description` ,
`category.translation.metaTitle` ,
`category.translation.metaTitle` as `category.metaTitle` ,
`category.translation.metaDescription` ,
`category.translation.metaDescription` as `category.metaDescription` ,
`category.translation.keywords` ,
`category.translation.keywords` as `category.keywords` ,
`category.translation.customFields` ,
`category.translation.customFields` as `category.customFields`
FROM
`category`
LEFT JOIN (
SELECT
`category.translation` . `category_id` ,
`category.translation` . `category_version_id` ,
`category.translation` . `breadcrumb` as `category.translation.breadcrumb` ,
`category.translation` . `name` as `category.translation.name` ,
`category.translation` . `custom_fields` as `category.translation.customFields` ,
`category.translation` . `slot_config` as `category.translation.slotConfig` ,
`category.translation` . `link_type` as `category.translation.linkType` ,
`category.translation` . `internal_link` as `category.translation.internalLink` ,
`category.translation` . `external_link` as `category.translation.externalLink` ,
`category.translation` . `link_new_tab` as `category.translation.linkNewTab` ,
`category.translation` . `description` as `category.translation.description` ,
`category.translation` . `meta_title` as `category.translation.metaTitle` ,
`category.translation` . `meta_description` as `category.translation.metaDescription` ,
`category.translation` . `keywords` as `category.translation.keywords`
FROM
`category_translation` `category.translation`
WHERE
`category.translation` . `language_id` = ?
) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id`
AND `category.category_translation` . `category_version_id` = `category` . `version_id`
WHERE
(`category` . `version_id` = ? )
AND (
`category` . `id` IN (? )
)
Copy
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.translation.name` , `category.translation.name` as `category.name` , `category.translation.breadcrumb` , `category.translation.breadcrumb` as `category.breadcrumb` , `category.translation.slotConfig` , `category.translation.slotConfig` as `category.slotConfig` , `category.translation.linkType` , `category.translation.linkType` as `category.linkType` , `category.translation.internalLink` , `category.translation.internalLink` as `category.internalLink` , `category.translation.externalLink` , `category.translation.externalLink` as `category.externalLink` , `category.translation.linkNewTab` , `category.translation.linkNewTab` as `category.linkNewTab` , `category.translation.description` , `category.translation.description` as `category.description` , `category.translation.metaTitle` , `category.translation.metaTitle` as `category.metaTitle` , `category.translation.metaDescription` , `category.translation.metaDescription` as `category.metaDescription` , `category.translation.keywords` , `category.translation.keywords` as `category.keywords` , `category.translation.customFields` , `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation` . `category_id` , `category.translation` . `category_version_id` , `category.translation` . `breadcrumb` as `category.translation.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation` . `slot_config` as `category.translation.slotConfig` , `category.translation` . `link_type` as `category.translation.linkType` , `category.translation` . `internal_link` as `category.translation.internalLink` , `category.translation` . `external_link` as `category.translation.externalLink` , `category.translation` . `link_new_tab` as `category.translation.linkNewTab` , `category.translation` . `description` as `category.translation.description` , `category.translation` . `meta_title` as `category.translation.metaTitle` , `category.translation` . `meta_description` as `category.translation.metaDescription` , `category.translation` . `keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . `category_version_id` = `category` . `version_id` WHERE (`category` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (`category` . `id` IN (0x018F9AC4123A728D9C160AA933854A65 ));
Copy
0.96 ms (2.53%)
2
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = ?
Parameters :
[
"nwuqIXqlYL1jUGZMg4FRxsOh8Azruv1B "
]
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = 'nwuqIXqlYL1jUGZMg4FRxsOh8Azruv1B' ;
Copy
0.92 ms (2.44%)
1
SELECT `landing_page` . `id` as `landing_page.id` , `landing_page` . `version_id` as `landing_page.versionId` , `landing_page` . `active` as `landing_page.active` , `landing_page` . `cms_page_id` as `landing_page.cmsPageId` , `landing_page` . `cms_page_version_id` as `landing_page.cmsPageVersionId` , `landing_page` . `created_at` as `landing_page.createdAt` , `landing_page` . `updated_at` as `landing_page.updatedAt` , `landing_page.translation.name` , `landing_page.translation.name` as `landing_page.name` , `landing_page.translation.url` , `landing_page.translation.url` as `landing_page.url` , `landing_page.translation.slotConfig` , `landing_page.translation.slotConfig` as `landing_page.slotConfig` , `landing_page.translation.metaTitle` , `landing_page.translation.metaTitle` as `landing_page.metaTitle` , `landing_page.translation.metaDescription` , `landing_page.translation.metaDescription` as `landing_page.metaDescription` , `landing_page.translation.keywords` , `landing_page.translation.keywords` as `landing_page.keywords` , `landing_page.translation.customFields` , `landing_page.translation.customFields` as `landing_page.customFields` FROM `landing_page` LEFT JOIN (SELECT `landing_page.translation` . `landing_page_id` , `landing_page.translation` . `landing_page_version_id` , `landing_page.translation` . `name` as `landing_page.translation.name` , `landing_page.translation` . `custom_fields` as `landing_page.translation.customFields` , `landing_page.translation` . `slot_config` as `landing_page.translation.slotConfig` , `landing_page.translation` . `meta_title` as `landing_page.translation.metaTitle` , `landing_page.translation` . `meta_description` as `landing_page.translation.metaDescription` , `landing_page.translation` . `keywords` as `landing_page.translation.keywords` , `landing_page.translation` . `url` as `landing_page.translation.url` FROM `landing_page_translation` `landing_page.translation` WHERE `landing_page.translation` . `language_id` = ? ) `landing_page.landing_page_translation` ON `landing_page.landing_page_translation` . `landing_page_id` = `landing_page` . `id` AND `landing_page.landing_page_translation` . `landing_page_version_id` = `landing_page` . `version_id` WHERE (`landing_page` . `version_id` = ? ) AND (`landing_page` . `id` IN (? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4% "
b"\x01 ŽPæ:*~'»¿X€eÏ¾Ý "
]
SELECT `landing_page` . `id` as `landing_page.id` , `landing_page` . `version_id` as `landing_page.versionId` , `landing_page` . `active` as `landing_page.active` , `landing_page` . `cms_page_id` as `landing_page.cmsPageId` , `landing_page` . `cms_page_version_id` as `landing_page.cmsPageVersionId` , `landing_page` . `created_at` as `landing_page.createdAt` , `landing_page` . `updated_at` as `landing_page.updatedAt` , `landing_page.translation.name` , `landing_page.translation.name` as `landing_page.name` , `landing_page.translation.url` , `landing_page.translation.url` as `landing_page.url` , `landing_page.translation.slotConfig` , `landing_page.translation.slotConfig` as `landing_page.slotConfig` , `landing_page.translation.metaTitle` , `landing_page.translation.metaTitle` as `landing_page.metaTitle` , `landing_page.translation.metaDescription` , `landing_page.translation.metaDescription` as `landing_page.metaDescription` , `landing_page.translation.keywords` , `landing_page.translation.keywords` as `landing_page.keywords` , `landing_page.translation.customFields` , `landing_page.translation.customFields` as `landing_page.customFields` FROM `landing_page` LEFT JOIN (SELECT `landing_page.translation` . `landing_page_id` , `landing_page.translation` . `landing_page_version_id` , `landing_page.translation` . `name` as `landing_page.translation.name` , `landing_page.translation` . `custom_fields` as `landing_page.translation.customFields` , `landing_page.translation` . `slot_config` as `landing_page.translation.slotConfig` , `landing_page.translation` . `meta_title` as `landing_page.translation.metaTitle` , `landing_page.translation` . `meta_description` as `landing_page.translation.metaDescription` , `landing_page.translation` . `keywords` as `landing_page.translation.keywords` , `landing_page.translation` . `url` as `landing_page.translation.url` FROM `landing_page_translation` `landing_page.translation` WHERE `landing_page.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `landing_page.landing_page_translation` ON `landing_page.landing_page_translation` . `landing_page_id` = `landing_page` . `id` AND `landing_page.landing_page_translation` . `landing_page_version_id` = `landing_page` . `version_id` WHERE (`landing_page` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (`landing_page` . `id` IN (0x018E50E63A2A7E27BBBF588065CFBEDD ));
Copy
0.89 ms (2.35%)
1
SELECT `cms_block` . `id` as `cms_block.id` , `cms_block` . `version_id` as `cms_block.versionId` , `cms_block` . `cms_section_version_id` as `cms_block.cmsSectionVersionId` , `cms_block` . `position` as `cms_block.position` , `cms_block` . `type` as `cms_block.type` , `cms_block` . `locked` as `cms_block.locked` , `cms_block` . `name` as `cms_block.name` , `cms_block` . `section_position` as `cms_block.sectionPosition` , `cms_block` . `margin_top` as `cms_block.marginTop` , `cms_block` . `margin_bottom` as `cms_block.marginBottom` , `cms_block` . `margin_left` as `cms_block.marginLeft` , `cms_block` . `margin_right` as `cms_block.marginRight` , `cms_block` . `background_color` as `cms_block.backgroundColor` , `cms_block` . `background_media_id` as `cms_block.backgroundMediaId` , `cms_block` . `background_media_mode` as `cms_block.backgroundMediaMode` , `cms_block` . `css_class` as `cms_block.cssClass` , `cms_block` . `visibility` as `cms_block.visibility` , `cms_block` . `cms_section_id` as `cms_block.sectionId` , `cms_block` . `custom_fields` as `cms_block.customFields` , `cms_block` . `created_at` as `cms_block.createdAt` , `cms_block` . `updated_at` as `cms_block.updatedAt` , `cms_block.backgroundMedia` . `id` as `cms_block.backgroundMedia.id` , `cms_block.backgroundMedia` . `user_id` as `cms_block.backgroundMedia.userId` , `cms_block.backgroundMedia` . `media_folder_id` as `cms_block.backgroundMedia.mediaFolderId` , `cms_block.backgroundMedia` . `mime_type` as `cms_block.backgroundMedia.mimeType` , `cms_block.backgroundMedia` . `file_extension` as `cms_block.backgroundMedia.fileExtension` , `cms_block.backgroundMedia` . `uploaded_at` as `cms_block.backgroundMedia.uploadedAt` , `cms_block.backgroundMedia` . `file_name` as `cms_block.backgroundMedia.fileName` , `cms_block.backgroundMedia` . `file_size` as `cms_block.backgroundMedia.fileSize` , `cms_block.backgroundMedia` . `media_type` as `cms_block.backgroundMedia.mediaTypeRaw` , `cms_block.backgroundMedia` . `meta_data` as `cms_block.backgroundMedia.metaData` , `cms_block.backgroundMedia` . `config` as `cms_block.backgroundMedia.config` , `cms_block.backgroundMedia` . `path` as `cms_block.backgroundMedia.path` , `cms_block.backgroundMedia` . `private` as `cms_block.backgroundMedia.private` , `cms_block.backgroundMedia` . `thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo` , `cms_block.backgroundMedia` . `file_hash` as `cms_block.backgroundMedia.fileHash` , `cms_block.backgroundMedia` . `created_at` as `cms_block.backgroundMedia.createdAt` , `cms_block.backgroundMedia` . `updated_at` as `cms_block.backgroundMedia.updatedAt` , `cms_block.backgroundMedia.translation.title` , `cms_block.backgroundMedia.translation.title` as `cms_block.backgroundMedia.title` , `cms_block.backgroundMedia.translation.alt` , `cms_block.backgroundMedia.translation.alt` as `cms_block.backgroundMedia.alt` , `cms_block.backgroundMedia.translation.customFields` , `cms_block.backgroundMedia.translation.customFields` as `cms_block.backgroundMedia.customFields` FROM `cms_block` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block` . `background_media_id` = `cms_block.backgroundMedia` . `id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation` . `media_id` , `cms_block.backgroundMedia.translation` . `alt` as `cms_block.backgroundMedia.translation.alt` , `cms_block.backgroundMedia.translation` . `title` as `cms_block.backgroundMedia.translation.title` , `cms_block.backgroundMedia.translation` . `custom_fields` as `cms_block.backgroundMedia.translation.customFields` FROM `media_translation` `cms_block.backgroundMedia.translation` WHERE `cms_block.backgroundMedia.translation` . `language_id` = ? ) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation` . `media_id` = `cms_block.backgroundMedia` . `id` WHERE (`cms_block` . `version_id` = ? ) AND (((`cms_block` . `cms_section_id` IN (? ))))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4% "
b"\x01 ŽQ~Œ3\x7F 4³Nàƒ‡ü? "
]
SELECT
`cms_block` . `id` as `cms_block.id` ,
`cms_block` . `version_id` as `cms_block.versionId` ,
`cms_block` . `cms_section_version_id` as `cms_block.cmsSectionVersionId` ,
`cms_block` . `position` as `cms_block.position` ,
`cms_block` . `type` as `cms_block.type` ,
`cms_block` . `locked` as `cms_block.locked` ,
`cms_block` . `name` as `cms_block.name` ,
`cms_block` . `section_position` as `cms_block.sectionPosition` ,
`cms_block` . `margin_top` as `cms_block.marginTop` ,
`cms_block` . `margin_bottom` as `cms_block.marginBottom` ,
`cms_block` . `margin_left` as `cms_block.marginLeft` ,
`cms_block` . `margin_right` as `cms_block.marginRight` ,
`cms_block` . `background_color` as `cms_block.backgroundColor` ,
`cms_block` . `background_media_id` as `cms_block.backgroundMediaId` ,
`cms_block` . `background_media_mode` as `cms_block.backgroundMediaMode` ,
`cms_block` . `css_class` as `cms_block.cssClass` ,
`cms_block` . `visibility` as `cms_block.visibility` ,
`cms_block` . `cms_section_id` as `cms_block.sectionId` ,
`cms_block` . `custom_fields` as `cms_block.customFields` ,
`cms_block` . `created_at` as `cms_block.createdAt` ,
`cms_block` . `updated_at` as `cms_block.updatedAt` ,
`cms_block.backgroundMedia` . `id` as `cms_block.backgroundMedia.id` ,
`cms_block.backgroundMedia` . `user_id` as `cms_block.backgroundMedia.userId` ,
`cms_block.backgroundMedia` . `media_folder_id` as `cms_block.backgroundMedia.mediaFolderId` ,
`cms_block.backgroundMedia` . `mime_type` as `cms_block.backgroundMedia.mimeType` ,
`cms_block.backgroundMedia` . `file_extension` as `cms_block.backgroundMedia.fileExtension` ,
`cms_block.backgroundMedia` . `uploaded_at` as `cms_block.backgroundMedia.uploadedAt` ,
`cms_block.backgroundMedia` . `file_name` as `cms_block.backgroundMedia.fileName` ,
`cms_block.backgroundMedia` . `file_size` as `cms_block.backgroundMedia.fileSize` ,
`cms_block.backgroundMedia` . `media_type` as `cms_block.backgroundMedia.mediaTypeRaw` ,
`cms_block.backgroundMedia` . `meta_data` as `cms_block.backgroundMedia.metaData` ,
`cms_block.backgroundMedia` . `config` as `cms_block.backgroundMedia.config` ,
`cms_block.backgroundMedia` . `path` as `cms_block.backgroundMedia.path` ,
`cms_block.backgroundMedia` . `private` as `cms_block.backgroundMedia.private` ,
`cms_block.backgroundMedia` . `thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo` ,
`cms_block.backgroundMedia` . `file_hash` as `cms_block.backgroundMedia.fileHash` ,
`cms_block.backgroundMedia` . `created_at` as `cms_block.backgroundMedia.createdAt` ,
`cms_block.backgroundMedia` . `updated_at` as `cms_block.backgroundMedia.updatedAt` ,
`cms_block.backgroundMedia.translation.title` ,
`cms_block.backgroundMedia.translation.title` as `cms_block.backgroundMedia.title` ,
`cms_block.backgroundMedia.translation.alt` ,
`cms_block.backgroundMedia.translation.alt` as `cms_block.backgroundMedia.alt` ,
`cms_block.backgroundMedia.translation.customFields` ,
`cms_block.backgroundMedia.translation.customFields` as `cms_block.backgroundMedia.customFields`
FROM
`cms_block`
LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block` . `background_media_id` = `cms_block.backgroundMedia` . `id`
LEFT JOIN (
SELECT
`cms_block.backgroundMedia.translation` . `media_id` ,
`cms_block.backgroundMedia.translation` . `alt` as `cms_block.backgroundMedia.translation.alt` ,
`cms_block.backgroundMedia.translation` . `title` as `cms_block.backgroundMedia.translation.title` ,
`cms_block.backgroundMedia.translation` . `custom_fields` as `cms_block.backgroundMedia.translation.customFields`
FROM
`media_translation` `cms_block.backgroundMedia.translation`
WHERE
`cms_block.backgroundMedia.translation` . `language_id` = ?
) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation` . `media_id` = `cms_block.backgroundMedia` . `id`
WHERE
(`cms_block` . `version_id` = ? )
AND (
(
(
`cms_block` . `cms_section_id` IN (? )
)
)
)
Copy
SELECT `cms_block` . `id` as `cms_block.id` , `cms_block` . `version_id` as `cms_block.versionId` , `cms_block` . `cms_section_version_id` as `cms_block.cmsSectionVersionId` , `cms_block` . `position` as `cms_block.position` , `cms_block` . `type` as `cms_block.type` , `cms_block` . `locked` as `cms_block.locked` , `cms_block` . `name` as `cms_block.name` , `cms_block` . `section_position` as `cms_block.sectionPosition` , `cms_block` . `margin_top` as `cms_block.marginTop` , `cms_block` . `margin_bottom` as `cms_block.marginBottom` , `cms_block` . `margin_left` as `cms_block.marginLeft` , `cms_block` . `margin_right` as `cms_block.marginRight` , `cms_block` . `background_color` as `cms_block.backgroundColor` , `cms_block` . `background_media_id` as `cms_block.backgroundMediaId` , `cms_block` . `background_media_mode` as `cms_block.backgroundMediaMode` , `cms_block` . `css_class` as `cms_block.cssClass` , `cms_block` . `visibility` as `cms_block.visibility` , `cms_block` . `cms_section_id` as `cms_block.sectionId` , `cms_block` . `custom_fields` as `cms_block.customFields` , `cms_block` . `created_at` as `cms_block.createdAt` , `cms_block` . `updated_at` as `cms_block.updatedAt` , `cms_block.backgroundMedia` . `id` as `cms_block.backgroundMedia.id` , `cms_block.backgroundMedia` . `user_id` as `cms_block.backgroundMedia.userId` , `cms_block.backgroundMedia` . `media_folder_id` as `cms_block.backgroundMedia.mediaFolderId` , `cms_block.backgroundMedia` . `mime_type` as `cms_block.backgroundMedia.mimeType` , `cms_block.backgroundMedia` . `file_extension` as `cms_block.backgroundMedia.fileExtension` , `cms_block.backgroundMedia` . `uploaded_at` as `cms_block.backgroundMedia.uploadedAt` , `cms_block.backgroundMedia` . `file_name` as `cms_block.backgroundMedia.fileName` , `cms_block.backgroundMedia` . `file_size` as `cms_block.backgroundMedia.fileSize` , `cms_block.backgroundMedia` . `media_type` as `cms_block.backgroundMedia.mediaTypeRaw` , `cms_block.backgroundMedia` . `meta_data` as `cms_block.backgroundMedia.metaData` , `cms_block.backgroundMedia` . `config` as `cms_block.backgroundMedia.config` , `cms_block.backgroundMedia` . `path` as `cms_block.backgroundMedia.path` , `cms_block.backgroundMedia` . `private` as `cms_block.backgroundMedia.private` , `cms_block.backgroundMedia` . `thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo` , `cms_block.backgroundMedia` . `file_hash` as `cms_block.backgroundMedia.fileHash` , `cms_block.backgroundMedia` . `created_at` as `cms_block.backgroundMedia.createdAt` , `cms_block.backgroundMedia` . `updated_at` as `cms_block.backgroundMedia.updatedAt` , `cms_block.backgroundMedia.translation.title` , `cms_block.backgroundMedia.translation.title` as `cms_block.backgroundMedia.title` , `cms_block.backgroundMedia.translation.alt` , `cms_block.backgroundMedia.translation.alt` as `cms_block.backgroundMedia.alt` , `cms_block.backgroundMedia.translation.customFields` , `cms_block.backgroundMedia.translation.customFields` as `cms_block.backgroundMedia.customFields` FROM `cms_block` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block` . `background_media_id` = `cms_block.backgroundMedia` . `id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation` . `media_id` , `cms_block.backgroundMedia.translation` . `alt` as `cms_block.backgroundMedia.translation.alt` , `cms_block.backgroundMedia.translation` . `title` as `cms_block.backgroundMedia.translation.title` , `cms_block.backgroundMedia.translation` . `custom_fields` as `cms_block.backgroundMedia.translation.customFields` FROM `media_translation` `cms_block.backgroundMedia.translation` WHERE `cms_block.backgroundMedia.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation` . `media_id` = `cms_block.backgroundMedia` . `id` WHERE (`cms_block` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (((`cms_block` . `cms_section_id` IN (0x018E517E8C337F34B34EE0AD8387FC3F ))));
Copy
0.83 ms (2.18%)
1
INSERT INTO `pickware_license_bundle_plugin_installation` (
`id` ,
`installation_id` ,
`created_at`
) VALUES (
? ,
UNHEX (CONCAT (
LPAD (HEX (FLOOR (RAND () * 0xffff )), 4 , "0" ),
LPAD (HEX (FLOOR (RAND () * 0xffff )), 4 , "0" ),
LPAD (HEX (FLOOR (RAND () * 0xffff )), 4 , "0" ),
"4" ,
LPAD (HEX (FLOOR (RAND () * 0x0fff )), 3 , "0" ),
HEX (FLOOR (RAND () * 4 + 8 )),
LPAD (HEX (FLOOR (RAND () * 0x0fff )), 3 , "0" ),
LPAD (HEX (FLOOR (RAND () * 0xffff )), 4 , "0" ),
LPAD (HEX (FLOOR (RAND () * 0xffff )), 4 , "0" ),
LPAD (HEX (FLOOR (RAND () * 0xffff )), 4 , "0" )
)),
UTC_TIMESTAMP (3 )
) ON DUPLICATE KEY UPDATE `id` = `id`
Parameters :
[
b"¸Ts\x01\x16\x07 AQˆc(Ì9)£i "
]
INSERT INTO `pickware_license_bundle_plugin_installation` (
`id` ,
`installation_id` ,
`created_at`
) VALUES (
0xB854730116074151886328CC3929A369 ,
UNHEX (CONCAT (
LPAD (HEX (FLOOR (RAND () * 0xffff )), 4 , "0" ),
LPAD (HEX (FLOOR (RAND () * 0xffff )), 4 , "0" ),
LPAD (HEX (FLOOR (RAND () * 0xffff )), 4 , "0" ),
"4" ,
LPAD (HEX (FLOOR (RAND () * 0x0fff )), 3 , "0" ),
HEX (FLOOR (RAND () * 4 + 8 )),
LPAD (HEX (FLOOR (RAND () * 0x0fff )), 3 , "0" ),
LPAD (HEX (FLOOR (RAND () * 0xffff )), 4 , "0" ),
LPAD (HEX (FLOOR (RAND () * 0xffff )), 4 , "0" ),
LPAD (HEX (FLOOR (RAND () * 0xffff )), 4 , "0" )
)),
UTC_TIMESTAMP (3 )
) ON DUPLICATE KEY UPDATE `id` = `id` ;
Copy
0.81 ms (2.14%)
1
SELECT `cms_slot` . `id` as `cms_slot.id` , `cms_slot` . `version_id` as `cms_slot.versionId` , `cms_slot` . `cms_block_version_id` as `cms_slot.cmsBlockVersionId` , `cms_slot` . `type` as `cms_slot.type` , `cms_slot` . `slot` as `cms_slot.slot` , `cms_slot` . `locked` as `cms_slot.locked` , `cms_slot` . `cms_block_id` as `cms_slot.blockId` , `cms_slot` . `created_at` as `cms_slot.createdAt` , `cms_slot` . `updated_at` as `cms_slot.updatedAt` , `cms_slot.translation.config` , `cms_slot.translation.config` as `cms_slot.config` , `cms_slot.translation.customFields` , `cms_slot.translation.customFields` as `cms_slot.customFields` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation` . `cms_slot_id` , `cms_slot.translation` . `cms_slot_version_id` , `cms_slot.translation` . `config` as `cms_slot.translation.config` , `cms_slot.translation` . `custom_fields` as `cms_slot.translation.customFields` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation` . `language_id` = ? ) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation` . `cms_slot_id` = `cms_slot` . `id` AND `cms_slot.cms_slot_translation` . `cms_slot_version_id` = `cms_slot` . `version_id` WHERE (`cms_slot` . `version_id` = ? ) AND (((`cms_slot` . `cms_block_id` IN (? , ? , ? ))))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4% "
b"\x01 Q€\x17\x7F\x0F §¤´èH*Á\x18 "
b"\x01 ŽQ‚‰Ž|=‰v|<.+N' "
b"\x01 Q…À.s,»\x19 —EÞ‡Žq "
]
SELECT `cms_slot` . `id` as `cms_slot.id` , `cms_slot` . `version_id` as `cms_slot.versionId` , `cms_slot` . `cms_block_version_id` as `cms_slot.cmsBlockVersionId` , `cms_slot` . `type` as `cms_slot.type` , `cms_slot` . `slot` as `cms_slot.slot` , `cms_slot` . `locked` as `cms_slot.locked` , `cms_slot` . `cms_block_id` as `cms_slot.blockId` , `cms_slot` . `created_at` as `cms_slot.createdAt` , `cms_slot` . `updated_at` as `cms_slot.updatedAt` , `cms_slot.translation.config` , `cms_slot.translation.config` as `cms_slot.config` , `cms_slot.translation.customFields` , `cms_slot.translation.customFields` as `cms_slot.customFields` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation` . `cms_slot_id` , `cms_slot.translation` . `cms_slot_version_id` , `cms_slot.translation` . `config` as `cms_slot.translation.config` , `cms_slot.translation` . `custom_fields` as `cms_slot.translation.customFields` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation` . `cms_slot_id` = `cms_slot` . `id` AND `cms_slot.cms_slot_translation` . `cms_slot_version_id` = `cms_slot` . `version_id` WHERE (`cms_slot` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (((`cms_slot` . `cms_block_id` IN (0x018E518081177F0FA7A4B4E8482AC118 , 0x018E5182898E7C3D89767C3C2E2B4E27 , 0x018E5185C02E732CBB199745DE878D71 ))));
Copy
0.80 ms (2.10%)
1
SELECT DISTINCT LOWER (HEX (discount_product_stream_id )) as discount_product_stream_id
FROM prems_discount_category_base
WHERE id IN (NULL )
SELECT DISTINCT LOWER (HEX (discount_product_stream_id )) as discount_product_stream_id
FROM prems_discount_category_base
WHERE id IN (NULL );
Copy
0.79 ms (2.08%)
1
SELECT configuration_key , configuration_value FROM system_config WHERE (sales_channel_id = ? ) AND (configuration_key LIKE ? ) ORDER BY sales_channel_id ASC
Parameters :
[
b"\x01 šÄ\x18 ÉsK–ß¾«~—ç$ "
"Sendinblue.% "
]
SELECT configuration_key , configuration_value FROM system_config WHERE (sales_channel_id = 0x018F9AC418C9734B96DFBEAB7E97E724 ) AND (configuration_key LIKE 'Sendinblue.%' ) ORDER BY sales_channel_id ASC ;
Copy
0.76 ms (2.00%)
1
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ? ) AND (token = ? ) LIMIT 1
Parameters :
[
b"\x01 šÄ\x18 ÉsK–ß¾«~—ç$ "
"nwuqIXqlYL1jUGZMg4FRxsOh8Azruv1B "
]
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0x018F9AC418C9734B96DFBEAB7E97E724 ) AND (token = 'nwuqIXqlYL1jUGZMg4FRxsOh8Azruv1B' ) LIMIT 1 ;
Copy
0.73 ms (1.94%)
1
SELECT `cms_page` . `id` as `cms_page.id` , `cms_page` . `version_id` as `cms_page.versionId` , `cms_page` . `type` as `cms_page.type` , `cms_page` . `entity` as `cms_page.entity` , `cms_page` . `css_class` as `cms_page.cssClass` , `cms_page` . `config` as `cms_page.config` , `cms_page` . `preview_media_id` as `cms_page.previewMediaId` , `cms_page` . `locked` as `cms_page.locked` , `cms_page` . `created_at` as `cms_page.createdAt` , `cms_page` . `updated_at` as `cms_page.updatedAt` , `cms_page.translation.name` , `cms_page.translation.name` as `cms_page.name` , `cms_page.translation.customFields` , `cms_page.translation.customFields` as `cms_page.customFields` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation` . `cms_page_id` , `cms_page.translation` . `cms_page_version_id` , `cms_page.translation` . `name` as `cms_page.translation.name` , `cms_page.translation` . `custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation` . `language_id` = ? ) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation` . `cms_page_id` = `cms_page` . `id` AND `cms_page.cms_page_translation` . `cms_page_version_id` = `cms_page` . `version_id` WHERE (`cms_page` . `version_id` = ? ) AND (`cms_page` . `id` IN (? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4% "
b"\x01 Q~Êr\r ³\x1C hƒ°{"q "
]
SELECT `cms_page` . `id` as `cms_page.id` , `cms_page` . `version_id` as `cms_page.versionId` , `cms_page` . `type` as `cms_page.type` , `cms_page` . `entity` as `cms_page.entity` , `cms_page` . `css_class` as `cms_page.cssClass` , `cms_page` . `config` as `cms_page.config` , `cms_page` . `preview_media_id` as `cms_page.previewMediaId` , `cms_page` . `locked` as `cms_page.locked` , `cms_page` . `created_at` as `cms_page.createdAt` , `cms_page` . `updated_at` as `cms_page.updatedAt` , `cms_page.translation.name` , `cms_page.translation.name` as `cms_page.name` , `cms_page.translation.customFields` , `cms_page.translation.customFields` as `cms_page.customFields` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation` . `cms_page_id` , `cms_page.translation` . `cms_page_version_id` , `cms_page.translation` . `name` as `cms_page.translation.name` , `cms_page.translation` . `custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation` . `cms_page_id` = `cms_page` . `id` AND `cms_page.cms_page_translation` . `cms_page_version_id` = `cms_page` . `version_id` WHERE (`cms_page` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (`cms_page` . `id` IN (0x018E517E81CA720DB31C6883B07B2271 ));
Copy
0.73 ms (1.94%)
1
SELECT pm . `handler_identifier` , LOWER (HEX (sc_pm . `payment_method_id` ))
FROM `sales_channel_payment_method` AS sc_pm
LEFT JOIN `payment_method` AS pm ON pm . `id` = sc_pm . `payment_method_id`
WHERE sc_pm . `sales_channel_id` = ? AND pm . `active` = 1
Parameters :
[
b"\x01 šÄ\x18 ÉsK–ß¾«~—ç$ "
]
SELECT pm . `handler_identifier` , LOWER (HEX (sc_pm . `payment_method_id` ))
FROM `sales_channel_payment_method` AS sc_pm
LEFT JOIN `payment_method` AS pm ON pm . `id` = sc_pm . `payment_method_id`
WHERE sc_pm . `sales_channel_id` = 0x018F9AC418C9734B96DFBEAB7E97E724 AND pm . `active` = 1 ;
Copy
0.71 ms (1.86%)
1
SELECT `rule` . `id` as `rule.id` , `rule` . `name` as `rule.name` , `rule` . `priority` as `rule.priority` , `rule` . `description` as `rule.description` , `rule` . `payload` as `rule.payload` , `rule` . `invalid` as `rule.invalid` , `rule` . `areas` as `rule.areas` , `rule` . `custom_fields` as `rule.customFields` , `rule` . `module_types` as `rule.moduleTypes` , `rule` . `created_at` as `rule.createdAt` , `rule` . `updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"\x01 ‰‘t@\t r®Œ:æÐä°Äù "
b"\x01 ‰‘t@\x16 pN¬`– ÂÈ/ "
b"\x01 ‰‘tŽ’râ¥ßŽáZ¿^R "
b"\x01 a11åv\x19 ³\x0F M''Ú… "
b"\x01 ‰‘t@9p\x1D ¯4½¡¬\v ƒ\x1D "
b"\x01 ¤ß4Â~ã›\r Qg\f ÚB' "
b"\x01 šÌ 2sè¸:1¥#7j\ "
b"\x01 šÌ 8s{¬ä¨ÑÕX¢‹ "
b"\x01 šÌ >q7½æ¹6ê?1¶ "
b"\x01 šÌ EpN‚ÿÍW\x07 »€\x14 "
b"\x01 šÌ Ls\f Žœâ°~>>; "
b"\x01 šÌ Qq!©lqx~Q\x05\x06 "
b"\x01 šÌ Wq”£X%¤ÈŠ\x19\x10 "
b"\x01 šÌ ds[ºj¿–GylÞ "
b"\x01 šÌ-¯qk·³ú©—Âþ\x01 "
b"\x01 šÌM„rÆ”Ù\x0E «]g¤’ "
b"\x01 šÌf\x0E r¾»ð…L÷‚ñ› "
b"\x01 šÌfs‡ª/1\x0F Q®\x1D " "
b"\x01 šÌf‡sF¼ÄV4\x1F Ë\v\x02 "
b"\x01 šÌi€sáŠ{^RÑ%\x1A ˆ "
]
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 (0x01899174400972AE8C3AE6D0E4B0C4F9 , 0x018991744016704EAC609620C28FC82F , 0x018991748E9272E2A5DF8EE15ABF5E52 , 0x018E613131E57619B30F4D2727DA8F85 , 0x018991744039701DAF34BDA1AC0B831D , 0x018FA4DF34C27EE39B0D51670CDA4227 , 0x018F9ACC203273E8B83A31A523376A5C , 0x018F9ACC2038737BACE4A8D1D558A28B , 0x018F9ACC203E7137BDE6B936EA3F31B6 , 0x018F9ACC2045704E82FFCD5707BB8014 , 0x018F9ACC204C730C8D9CE2B07E3E3E3B , 0x018F9ACC20517121A96C71787E510506 , 0x018F9ACC20577194A35825A4C88A1910 , 0x018F9ACC2064735BBA6ABF9647796CDE , 0x018F9ACC2DAF716BB7B3FAA997C2FE01 , 0x018F9ACC4D8472C694D90EAB5D67A492 , 0x018F9ACC660E72BEBBF0854CF782F19B , 0x018F9ACC66817387AA2F310F51AE1D22 , 0x018F9ACC66877346BCC456341FCB0B02 , 0x018F9ACC698073E18A7B5E52D1251A88 );
Copy
0.68 ms (1.81%)
1
SELECT `sales_channel_country` . `sales_channel_id` , `sales_channel_country` . `country_id` FROM `sales_channel_country` WHERE (`sales_channel_country` . `sales_channel_id` = ? AND `sales_channel_country` . `country_id` = ? )
Parameters :
[
b"\x01 šÄ\x18 ÉsK–ß¾«~—ç$ "
b"\x01 ‰‘t?xpgJƒ©c² "
]
SELECT `sales_channel_country` . `sales_channel_id` , `sales_channel_country` . `country_id` FROM `sales_channel_country` WHERE (`sales_channel_country` . `sales_channel_id` = 0x018F9AC418C9734B96DFBEAB7E97E724 AND `sales_channel_country` . `country_id` = 0x018991743F7870678F8F4A83ADA963B2 );
Copy
0.68 ms (1.79%)
1
SELECT `pickware_license_bundle_plugin_installation` . `id` as `pickware_license_bundle_plugin_installation.id` , `pickware_license_bundle_plugin_installation` . `installation_id` as `pickware_license_bundle_plugin_installation.installationId` , `pickware_license_bundle_plugin_installation` . `installation_uuid` as `pickware_license_bundle_plugin_installation.installationUuid` , `pickware_license_bundle_plugin_installation` . `pickware_account_access_token` as `pickware_license_bundle_plugin_installation.pickwareAccountAccessToken` , `pickware_license_bundle_plugin_installation` . `pickware_license` as `pickware_license_bundle_plugin_installation.pickwareLicense` , `pickware_license_bundle_plugin_installation` . `pickware_license_lease` as `pickware_license_bundle_plugin_installation.pickwareLicenseLease` , `pickware_license_bundle_plugin_installation` . `latest_pickware_license_lease_refresh_error` as `pickware_license_bundle_plugin_installation.latestPickwareLicenseLeaseRefreshError` , `pickware_license_bundle_plugin_installation` . `latest_pickware_license_refresh_error` as `pickware_license_bundle_plugin_installation.latestPickwareLicenseRefreshError` , `pickware_license_bundle_plugin_installation` . `latest_usage_report_error` as `pickware_license_bundle_plugin_installation.latestUsageReportError` , `pickware_license_bundle_plugin_installation` . `last_pickware_license_lease_refreshed_at` as `pickware_license_bundle_plugin_installation.lastPickwareLicenseLeaseRefreshedAt` , `pickware_license_bundle_plugin_installation` . `created_at` as `pickware_license_bundle_plugin_installation.createdAt` , `pickware_license_bundle_plugin_installation` . `updated_at` as `pickware_license_bundle_plugin_installation.updatedAt` FROM `pickware_license_bundle_plugin_installation` WHERE `pickware_license_bundle_plugin_installation` . `id` IN (? )
Parameters :
[
b"¸Ts\x01\x16\x07 AQˆc(Ì9)£i "
]
SELECT `pickware_license_bundle_plugin_installation` . `id` as `pickware_license_bundle_plugin_installation.id` , `pickware_license_bundle_plugin_installation` . `installation_id` as `pickware_license_bundle_plugin_installation.installationId` , `pickware_license_bundle_plugin_installation` . `installation_uuid` as `pickware_license_bundle_plugin_installation.installationUuid` , `pickware_license_bundle_plugin_installation` . `pickware_account_access_token` as `pickware_license_bundle_plugin_installation.pickwareAccountAccessToken` , `pickware_license_bundle_plugin_installation` . `pickware_license` as `pickware_license_bundle_plugin_installation.pickwareLicense` , `pickware_license_bundle_plugin_installation` . `pickware_license_lease` as `pickware_license_bundle_plugin_installation.pickwareLicenseLease` , `pickware_license_bundle_plugin_installation` . `latest_pickware_license_lease_refresh_error` as `pickware_license_bundle_plugin_installation.latestPickwareLicenseLeaseRefreshError` , `pickware_license_bundle_plugin_installation` . `latest_pickware_license_refresh_error` as `pickware_license_bundle_plugin_installation.latestPickwareLicenseRefreshError` , `pickware_license_bundle_plugin_installation` . `latest_usage_report_error` as `pickware_license_bundle_plugin_installation.latestUsageReportError` , `pickware_license_bundle_plugin_installation` . `last_pickware_license_lease_refreshed_at` as `pickware_license_bundle_plugin_installation.lastPickwareLicenseLeaseRefreshedAt` , `pickware_license_bundle_plugin_installation` . `created_at` as `pickware_license_bundle_plugin_installation.createdAt` , `pickware_license_bundle_plugin_installation` . `updated_at` as `pickware_license_bundle_plugin_installation.updatedAt` FROM `pickware_license_bundle_plugin_installation` WHERE `pickware_license_bundle_plugin_installation` . `id` IN (0xB854730116074151886328CC3929A369 );
Copy
0.62 ms (1.63%)
1
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = ?
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = 'de-DE' ;
Copy
0.59 ms (1.55%)
1
SELECT `category` . `id` , `category` . `auto_increment` FROM `category` LEFT JOIN `swag_dynamic_access_category_rule` `category.swagDynamicAccessRules.mapping` ON `category` . `id` = `category.swagDynamicAccessRules.mapping` . `category_id` AND `category` . `version_id` = `category.swagDynamicAccessRules.mapping` . `category_version_id` LEFT JOIN `rule` `category.swagDynamicAccessRules` ON `category.swagDynamicAccessRules.mapping` . `rule_id` = `category.swagDynamicAccessRules` . `id` WHERE (`category` . `version_id` = ? ) AND ((((`category.swagDynamicAccessRules` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )) OR `category.swagDynamicAccessRules` . `id` < = > ? ))) AND (`category` . `id` IN (? )) GROUP BY `category` . `id`
Parameters :
[
b"\x0F ©\x1C ãéjK¾KÙÎu,4% "
b"\x01 ‰‘t@\t r®Œ:æÐä°Äù "
b"\x01 ‰‘t@\x16 pN¬`– ÂÈ/ "
b"\x01 ‰‘tŽ’râ¥ßŽáZ¿^R "
b"\x01 a11åv\x19 ³\x0F M''Ú… "
b"\x01 ‰‘t@9p\x1D ¯4½¡¬\v ƒ\x1D "
b"\x01 ¤ß4Â~ã›\r Qg\f ÚB' "
b"\x01 šÌ 2sè¸:1¥#7j\ "
b"\x01 šÌ 8s{¬ä¨ÑÕX¢‹ "
b"\x01 šÌ >q7½æ¹6ê?1¶ "
b"\x01 šÌ EpN‚ÿÍW\x07 »€\x14 "
b"\x01 šÌ Ls\f Žœâ°~>>; "
b"\x01 šÌ Qq!©lqx~Q\x05\x06 "
b"\x01 šÌ Wq”£X%¤ÈŠ\x19\x10 "
b"\x01 šÌ ds[ºj¿–GylÞ "
b"\x01 šÌ-¯qk·³ú©—Âþ\x01 "
b"\x01 šÌM„rÆ”Ù\x0E «]g¤’ "
b"\x01 šÌf\x0E r¾»ð…L÷‚ñ› "
b"\x01 šÌfs‡ª/1\x0F Q®\x1D " "
b"\x01 šÌf‡sF¼ÄV4\x1F Ë\v\x02 "
b"\x01 šÌi€sáŠ{^RÑ%\x1A ˆ "
null
b"""
\x01 šÄ\x12 :rŽœ\x16 \n
©3…Je
"""
]
SELECT `category` . `id` , `category` . `auto_increment` FROM `category` LEFT JOIN `swag_dynamic_access_category_rule` `category.swagDynamicAccessRules.mapping` ON `category` . `id` = `category.swagDynamicAccessRules.mapping` . `category_id` AND `category` . `version_id` = `category.swagDynamicAccessRules.mapping` . `category_version_id` LEFT JOIN `rule` `category.swagDynamicAccessRules` ON `category.swagDynamicAccessRules.mapping` . `rule_id` = `category.swagDynamicAccessRules` . `id` WHERE (`category` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND ((((`category.swagDynamicAccessRules` . `id` IN (0x01899174400972AE8C3AE6D0E4B0C4F9 , 0x018991744016704EAC609620C28FC82F , 0x018991748E9272E2A5DF8EE15ABF5E52 , 0x018E613131E57619B30F4D2727DA8F85 , 0x018991744039701DAF34BDA1AC0B831D , 0x018FA4DF34C27EE39B0D51670CDA4227 , 0x018F9ACC203273E8B83A31A523376A5C , 0x018F9ACC2038737BACE4A8D1D558A28B , 0x018F9ACC203E7137BDE6B936EA3F31B6 , 0x018F9ACC2045704E82FFCD5707BB8014 , 0x018F9ACC204C730C8D9CE2B07E3E3E3B , 0x018F9ACC20517121A96C71787E510506 , 0x018F9ACC20577194A35825A4C88A1910 , 0x018F9ACC2064735BBA6ABF9647796CDE , 0x018F9ACC2DAF716BB7B3FAA997C2FE01 , 0x018F9ACC4D8472C694D90EAB5D67A492 , 0x018F9ACC660E72BEBBF0854CF782F19B , 0x018F9ACC66817387AA2F310F51AE1D22 , 0x018F9ACC66877346BCC456341FCB0B02 , 0x018F9ACC698073E18A7B5E52D1251A88 )) OR `category.swagDynamicAccessRules` . `id` < = > NULL ))) AND (`category` . `id` IN (0x018F9AC4123A728D9C160AA933854A65 )) GROUP BY `category` . `id` ;
Copy
0.57 ms (1.50%)
1
SELECT `key` , `value` FROM `app_config`
SELECT `key` , `value` FROM `app_config` ;
Copy
0.54 ms (1.43%)
1
SELECT `app` . `name` , `app` . `version` , `app` . `template_load_priority`
FROM `app`
INNER JOIN `app_template` ON `app_template` . `app_id` = `app` . `id`
WHERE `app` . `active` = 1 AND `app_template` . `active` = 1
SELECT `app` . `name` , `app` . `version` , `app` . `template_load_priority`
FROM `app`
INNER JOIN `app_template` ON `app_template` . `app_id` = `app` . `id`
WHERE `app` . `active` = 1 AND `app_template` . `active` = 1 ;
Copy
0.54 ms (1.43%)
1
SELECT LOWER (HEX (language . parent_id )) FROM language WHERE language . id = ?
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT LOWER (HEX (language . parent_id )) FROM language WHERE language . id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ;
Copy
0.50 ms (1.31%)
2
SELECT url FROM sales_channel_domain
SELECT url FROM sales_channel_domain ;
Copy
0.49 ms (1.29%)
1
SELECT `landing_page_translation` . `name` as `landing_page_translation.name` , `landing_page_translation` . `url` as `landing_page_translation.url` , `landing_page_translation` . `slot_config` as `landing_page_translation.slotConfig` , `landing_page_translation` . `meta_title` as `landing_page_translation.metaTitle` , `landing_page_translation` . `meta_description` as `landing_page_translation.metaDescription` , `landing_page_translation` . `keywords` as `landing_page_translation.keywords` , `landing_page_translation` . `custom_fields` as `landing_page_translation.customFields` , `landing_page_translation` . `created_at` as `landing_page_translation.createdAt` , `landing_page_translation` . `updated_at` as `landing_page_translation.updatedAt` , `landing_page_translation` . `landing_page_id` as `landing_page_translation.landingPageId` , `landing_page_translation` . `language_id` as `landing_page_translation.languageId` , `landing_page_translation` . `landing_page_version_id` as `landing_page_translation.landingPageVersionId` FROM `landing_page_translation` WHERE (`landing_page_translation` . `landing_page_version_id` = ? ) AND (((`landing_page_translation` . `landing_page_id` IN (? ))))
Parameters :
[
b"\x0F ©\x1C ãéjK¾KÙÎu,4% "
b"\x01 ŽPæ:*~'»¿X€eÏ¾Ý "
]
SELECT `landing_page_translation` . `name` as `landing_page_translation.name` , `landing_page_translation` . `url` as `landing_page_translation.url` , `landing_page_translation` . `slot_config` as `landing_page_translation.slotConfig` , `landing_page_translation` . `meta_title` as `landing_page_translation.metaTitle` , `landing_page_translation` . `meta_description` as `landing_page_translation.metaDescription` , `landing_page_translation` . `keywords` as `landing_page_translation.keywords` , `landing_page_translation` . `custom_fields` as `landing_page_translation.customFields` , `landing_page_translation` . `created_at` as `landing_page_translation.createdAt` , `landing_page_translation` . `updated_at` as `landing_page_translation.updatedAt` , `landing_page_translation` . `landing_page_id` as `landing_page_translation.landingPageId` , `landing_page_translation` . `language_id` as `landing_page_translation.languageId` , `landing_page_translation` . `landing_page_version_id` as `landing_page_translation.landingPageVersionId` FROM `landing_page_translation` WHERE (`landing_page_translation` . `landing_page_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (((`landing_page_translation` . `landing_page_id` IN (0x018E50E63A2A7E27BBBF588065CFBEDD ))));
Copy
0.48 ms (1.28%)
1
SELECT id FROM `pickware_erp_return_order_line_item` LIMIT 1
SELECT id FROM `pickware_erp_return_order_line_item` LIMIT 1 ;
Copy
0.45 ms (1.18%)
1
SELECT `name` , `path` , `author` , `self_managed`
FROM `app`
WHERE `active` = 1
SELECT `name` , `path` , `author` , `self_managed`
FROM `app`
WHERE `active` = 1
;
Copy
0.40 ms (1.06%)
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.40 ms (1.04%)
1
SELECT `version` FROM `plugin` WHERE `base_class` = ? LIMIT 1
Parameters :
[
"Klaviyo\Integration\klavi_overd "
]
SELECT `version` FROM `plugin` WHERE `base_class` = 'Klaviyo\\Integration\\klavi_overd' LIMIT 1 ;
Copy
0.38 ms (1.00%)
1
SELECT path FROM category WHERE id = ?
Parameters :
[
b"""
\x01 šÄ\x12 :rŽœ\x16 \n
©3…Je
"""
]
SELECT path FROM category WHERE id = 0x018F9AC4123A728D9C160AA933854A65 ;
Copy
0.34 ms (0.89%)
1
SELECT `language` . `id` FROM `language` WHERE `language` . `id` IN (? ) LIMIT 1
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `language` . `id` FROM `language` WHERE `language` . `id` IN (0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) LIMIT 1 ;
Copy
0.32 ms (0.85%)
1
SELECT DISTINCT `technical_name`
FROM `theme_runtime_config`
WHERE `technical_name` IS NOT NULL
SELECT DISTINCT `technical_name`
FROM `theme_runtime_config`
WHERE `technical_name` IS NOT NULL ;
Copy
0.32 ms (0.84%)
1
SELECT `pickware_shipping_sales_channel_api_context` . `sales_channel_context_token` as `pickware_shipping_sales_channel_api_context.salesChannelContextToken` , `pickware_shipping_sales_channel_api_context` . `payload` as `pickware_shipping_sales_channel_api_context.payload` , `pickware_shipping_sales_channel_api_context` . `created_at` as `pickware_shipping_sales_channel_api_context.createdAt` , `pickware_shipping_sales_channel_api_context` . `updated_at` as `pickware_shipping_sales_channel_api_context.updatedAt` FROM `pickware_shipping_sales_channel_api_context` WHERE `pickware_shipping_sales_channel_api_context` . `sales_channel_context_token` IN (? )
Parameters :
[
"nwuqIXqlYL1jUGZMg4FRxsOh8Azruv1B "
]
SELECT `pickware_shipping_sales_channel_api_context` . `sales_channel_context_token` as `pickware_shipping_sales_channel_api_context.salesChannelContextToken` , `pickware_shipping_sales_channel_api_context` . `payload` as `pickware_shipping_sales_channel_api_context.payload` , `pickware_shipping_sales_channel_api_context` . `created_at` as `pickware_shipping_sales_channel_api_context.createdAt` , `pickware_shipping_sales_channel_api_context` . `updated_at` as `pickware_shipping_sales_channel_api_context.updatedAt` FROM `pickware_shipping_sales_channel_api_context` WHERE `pickware_shipping_sales_channel_api_context` . `sales_channel_context_token` IN ('nwuqIXqlYL1jUGZMg4FRxsOh8Azruv1B' );
Copy
0.28 ms (0.74%)
1
SELECT shipping_costs FROM `pickware_erp_return_order` LIMIT 1
SELECT shipping_costs FROM `pickware_erp_return_order` LIMIT 1 ;
Copy
0.26 ms (0.68%)
1
SELECT id FROM `order_return` LIMIT 1
SELECT id FROM `order_return` LIMIT 1 ;
Copy
0.23 ms (0.62%)
1
SELECT `min_search_length` FROM `product_search_config` WHERE `language_id` = ?
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `min_search_length` FROM `product_search_config` WHERE `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ;
Copy