6
0.43 ms
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
9
1.12 ms
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 08:01:58.868 "
null
"2026-08-13 08:01:58.868 "
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 08:01:58.868' ) OR `prems_discount_category_base` . `valid_from` < = > NULL ) AND ((`prems_discount_category_base` . `valid_until` > = '2026-08-13 08:01:58.868' ) OR `prems_discount_category_base` . `valid_until` < = > NULL ) AND `prems_discount_category_base` . `active` = 1 );
Copy