GET https://ernstesdesign.de/widgets/dvsn/seller/is-seller

Query Metrics

75 Database Queries
65 Different statements
32.02 ms Query time

Queries

Group similar statements

# Time Info
1 0.60 ms
# dbal-plugin-loader
        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`;
Parameters:
[]
2 0.36 ms
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
3 0.48 ms
SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
Parameters:
[]
4 0.12 ms
SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
Parameters:
[]
5 0.68 ms
SELECT CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') `key`, CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') url, LOWER(HEX(domain.id)) id, LOWER(HEX(sales_channel.id)) salesChannelId, LOWER(HEX(sales_channel.type_id)) typeId, LOWER(HEX(domain.snippet_set_id)) snippetSetId, LOWER(HEX(domain.currency_id)) currencyId, LOWER(HEX(domain.language_id)) languageId, LOWER(HEX(theme.id)) themeId, sales_channel.maintenance maintenance, sales_channel.maintenance_ip_whitelist maintenanceIpWhitelist, snippet_set.iso as locale, theme.technical_name as themeName, parentTheme.technical_name as parentThemeName FROM sales_channel INNER JOIN sales_channel_domain domain ON domain.sales_channel_id = sales_channel.id LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id INNER JOIN snippet_set snippet_set ON snippet_set.id = domain.snippet_set_id LEFT JOIN theme theme ON theme_sales_channel.theme_id = theme.id LEFT JOIN theme parentTheme ON theme.parent_theme_id = parentTheme.id WHERE (sales_channel.type_id = UNHEX(?)) AND (sales_channel.active)
Parameters:
[
  "8a243080f92e4c719546314b577cf82b"
]
6 0.31 ms
# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND ((seo_path_info = ? OR seo_path_info = ?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  "widgets/dvsn/seller/is-seller"
  "widgets/dvsn/seller/is-seller/"
]
7 0.18 ms
# seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (path_info = ?) AND (is_canonical = 1) LIMIT 1
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  "/widgets/dvsn/seller/is-seller"
]
8 1.06 ms
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[]
9 0.14 ms
SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
Parameters:
[]
10 0.30 ms
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  "ltQoKGxpTGEgp2YH6HBuBxKQab5FV6eq"
]
11 0.30 ms
# context-factory::base-context

        SELECT
          sales_channel.id as sales_channel_id,
          sales_channel.language_id as sales_channel_default_language_id,
          sales_channel.currency_id as sales_channel_currency_id,
          currency.factor as sales_channel_currency_factor,
          GROUP_CONCAT(LOWER(HEX(sales_channel_language.language_id))) as sales_channel_language_ids
        FROM sales_channel
            INNER JOIN currency
                ON sales_channel.currency_id = currency.id
            LEFT JOIN sales_channel_language
                ON sales_channel_language.sales_channel_id = sales_channel.id
        WHERE sales_channel.id = ?
        GROUP BY sales_channel.id, sales_channel.language_id, sales_channel.currency_id, currency.factor
Parameters:
[
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
]
12 0.54 ms
# base-context-factory::sales-channel::read
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.currency`.`id` as `sales_channel.currency.id`, `sales_channel.currency`.`factor` as `sales_channel.currency.factor`, `sales_channel.currency`.`symbol` as `sales_channel.currency.symbol`, `sales_channel.currency`.`iso_code` as `sales_channel.currency.isoCode`, `sales_channel.currency`.`position` as `sales_channel.currency.position`, `sales_channel.currency`.`tax_free_from` as `sales_channel.currency.taxFreeFrom`, `sales_channel.currency`.`item_rounding` as `sales_channel.currency.itemRounding`, `sales_channel.currency`.`total_rounding` as `sales_channel.currency.totalRounding`, `sales_channel.currency`.`created_at` as `sales_channel.currency.createdAt`, `sales_channel.currency`.`updated_at` as `sales_channel.currency.updatedAt`, `sales_channel.currency.translation.shortName`, `sales_channel.currency.translation.shortName` as `sales_channel.currency.shortName`, `sales_channel.currency.translation.name`, `sales_channel.currency.translation.name` as `sales_channel.currency.name`, `sales_channel.currency.translation.customFields`, `sales_channel.currency.translation.customFields` as `sales_channel.currency.customFields`, `sales_channel.translation.name`, `sales_channel.translation.name` as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, `sales_channel.translation.homeName` as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, `sales_channel.translation.customFields` as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel`.`currency_id` = `sales_channel.currency`.`id` LEFT JOIN (SELECT `sales_channel.translation`.`sales_channel_id`, `sales_channel.translation`.`name` as `sales_channel.translation.name`, `sales_channel.translation`.`custom_fields` as `sales_channel.translation.customFields`, `sales_channel.translation`.`home_slot_config` as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.`home_enabled` as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.`home_name` as `sales_channel.translation.homeName`, `sales_channel.translation`.`home_meta_title` as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.`home_meta_description` as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.`home_keywords` as `sales_channel.translation.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.`language_id` = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` LEFT JOIN (SELECT `sales_channel.currency.translation`.`currency_id`, `sales_channel.currency.translation`.`short_name` as `sales_channel.currency.translation.shortName`, `sales_channel.currency.translation`.`name` as `sales_channel.currency.translation.name`, `sales_channel.currency.translation`.`custom_fields` as `sales_channel.currency.translation.customFields` FROM `currency_translation` `sales_channel.currency.translation` WHERE `sales_channel.currency.translation`.`language_id` = ?) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation`.`currency_id` = `sales_channel.currency`.`id` WHERE `sales_channel`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
]
13 0.25 ms
# base-context-factory::sales-channel::association::domains::read
SELECT `sales_channel_domain`.`id` as `sales_channel_domain.id`, `sales_channel_domain`.`url` as `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt` FROM `sales_channel_domain` WHERE (`sales_channel_domain`.`sales_channel_id` IN (?))
Parameters:
[
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
]
14 0.26 ms
# base-context-factory::currency::read
SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.shortName`, `currency.translation.shortName` as `currency.shortName`, `currency.translation.name`, `currency.translation.name` as `currency.name`, `currency.translation.customFields`, `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation`.`currency_id`, `currency.translation`.`short_name` as `currency.translation.shortName`, `currency.translation`.`name` as `currency.translation.name`, `currency.translation`.`custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.`language_id` = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
15 0.36 ms
# base-context-factory::country::read
SELECT `country`.`id` as `country.id`, `country`.`iso` as `country.iso`, `country`.`position` as `country.position`, `country`.`active` as `country.active`, `country`.`shipping_available` as `country.shippingAvailable`, `country`.`iso3` as `country.iso3`, `country`.`display_state_in_registration` as `country.displayStateInRegistration`, `country`.`force_state_in_registration` as `country.forceStateInRegistration`, `country`.`check_vat_id_pattern` as `country.checkVatIdPattern`, `country`.`vat_id_required` as `country.vatIdRequired`, `country`.`vat_id_pattern` as `country.vatIdPattern`, `country`.`customer_tax` as `country.customerTax`, `country`.`company_tax` as `country.companyTax`, `country`.`postal_code_required` as `country.postalCodeRequired`, `country`.`check_postal_code_pattern` as `country.checkPostalCodePattern`, `country`.`check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern`, `country`.`advanced_postal_code_pattern` as `country.advancedPostalCodePattern`, `country`.`default_postal_code_pattern` as `country.defaultPostalCodePattern`, `country`.`is_eu` as `country.isEu`, `country`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, `country.translation.name`, `country.translation.name` as `country.name`, `country.translation.addressFormat`, `country.translation.addressFormat` as `country.addressFormat`, `country.translation.customFields`, `country.translation.customFields` as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation`.`country_id`, `country.translation`.`name` as `country.translation.name`, `country.translation`.`custom_fields` as `country.translation.customFields`, `country.translation`.`address_format` as `country.translation.addressFormat` FROM `country_translation` `country.translation` WHERE `country.translation`.`language_id` = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"=Í¿PnVGÖ±è€\rŒ¬\r{"
]
16 0.37 ms
# base-context-factory::customer-group::read
SELECT `customer_group`.`id` as `customer_group.id`, `customer_group`.`display_gross` as `customer_group.displayGross`, `customer_group`.`registration_active` as `customer_group.registrationActive`, `customer_group`.`created_at` as `customer_group.createdAt`, `customer_group`.`updated_at` as `customer_group.updatedAt`, `customer_group.evpPriceSettings`.`id` as `customer_group.evpPriceSettings.id`, `customer_group.evpPriceSettings`.`customer_group_id` as `customer_group.evpPriceSettings.customerGroupId`, `customer_group.evpPriceSettings`.`reference_price_customer_group_id` as `customer_group.evpPriceSettings.referencePriceCustomerGroupId`, `customer_group.evpPriceSettings`.`reference_price_rule_id` as `customer_group.evpPriceSettings.referencePriceRuleId`, `customer_group.evpPriceSettings`.`show_net_price` as `customer_group.evpPriceSettings.showNetPrice`, `customer_group.evpPriceSettings`.`use_pseudo_price` as `customer_group.evpPriceSettings.usePseudoPrice`, `customer_group.evpPriceSettings`.`display_on_detail` as `customer_group.evpPriceSettings.displayOnDetail`, `customer_group.evpPriceSettings`.`display_in_cart` as `customer_group.evpPriceSettings.displayInCart`, `customer_group.evpPriceSettings`.`display_in_listing` as `customer_group.evpPriceSettings.displayInListing`, `customer_group.evpPriceSettings`.`active` as `customer_group.evpPriceSettings.active`, `customer_group.evpPriceSettings.referencePriceRule`.`id` as `customer_group.evpPriceSettings.referencePriceRule.id`, `customer_group.evpPriceSettings.referencePriceRule`.`name` as `customer_group.evpPriceSettings.referencePriceRule.name`, `customer_group.evpPriceSettings.referencePriceRule`.`priority` as `customer_group.evpPriceSettings.referencePriceRule.priority`, `customer_group.evpPriceSettings.referencePriceRule`.`description` as `customer_group.evpPriceSettings.referencePriceRule.description`, `customer_group.evpPriceSettings.referencePriceRule`.`payload` as `customer_group.evpPriceSettings.referencePriceRule.payload`, `customer_group.evpPriceSettings.referencePriceRule`.`invalid` as `customer_group.evpPriceSettings.referencePriceRule.invalid`, `customer_group.evpPriceSettings.referencePriceRule`.`areas` as `customer_group.evpPriceSettings.referencePriceRule.areas`, `customer_group.evpPriceSettings.referencePriceRule`.`custom_fields` as `customer_group.evpPriceSettings.referencePriceRule.customFields`, `customer_group.evpPriceSettings.referencePriceRule`.`module_types` as `customer_group.evpPriceSettings.referencePriceRule.moduleTypes`, `customer_group.evpPriceSettings.referencePriceRule`.`created_at` as `customer_group.evpPriceSettings.referencePriceRule.createdAt`, `customer_group.evpPriceSettings.referencePriceRule`.`updated_at` as `customer_group.evpPriceSettings.referencePriceRule.updatedAt`, `customer_group.evpPriceSettings`.`created_at` as `customer_group.evpPriceSettings.createdAt`, `customer_group.evpPriceSettings`.`updated_at` as `customer_group.evpPriceSettings.updatedAt`, `customer_group.translation.name`, `customer_group.translation.name` as `customer_group.name`, `customer_group.translation.registrationTitle`, `customer_group.translation.registrationTitle` as `customer_group.registrationTitle`, `customer_group.translation.registrationIntroduction`, `customer_group.translation.registrationIntroduction` as `customer_group.registrationIntroduction`, `customer_group.translation.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationOnlyCompanyRegistration` as `customer_group.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationSeoMetaDescription`, `customer_group.translation.registrationSeoMetaDescription` as `customer_group.registrationSeoMetaDescription`, `customer_group.translation.customFields`, `customer_group.translation.customFields` as `customer_group.customFields` FROM `customer_group` LEFT JOIN `coe_evp_price_customer_group_setting` `customer_group.evpPriceSettings` ON `customer_group`.`id` = `customer_group.evpPriceSettings`.`customer_group_id` LEFT JOIN (SELECT `customer_group.translation`.`customer_group_id`, `customer_group.translation`.`name` as `customer_group.translation.name`, `customer_group.translation`.`custom_fields` as `customer_group.translation.customFields`, `customer_group.translation`.`registration_title` as `customer_group.translation.registrationTitle`, `customer_group.translation`.`registration_introduction` as `customer_group.translation.registrationIntroduction`, `customer_group.translation`.`registration_only_company_registration` as `customer_group.translation.registrationOnlyCompanyRegistration`, `customer_group.translation`.`registration_seo_meta_description` as `customer_group.translation.registrationSeoMetaDescription` FROM `customer_group_translation` `customer_group.translation` WHERE `customer_group.translation`.`language_id` = ?) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation`.`customer_group_id` = `customer_group`.`id` LEFT JOIN `rule` `customer_group.evpPriceSettings.referencePriceRule` ON `customer_group.evpPriceSettings`.`reference_price_rule_id` = `customer_group.evpPriceSettings.referencePriceRule`.`id` WHERE `customer_group`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"¤¢P\x18ËìAÏ¡╩\x10┘O╚¢Í"
]
17 0.11 ms
# base-context-factory::taxes::read
SELECT `tax`.`id` as `tax.id`, `tax`.`tax_rate` as `tax.taxRate`, `tax`.`name` as `tax.name`, `tax`.`position` as `tax.position`, `tax`.`custom_fields` as `tax.customFields`, `tax`.`created_at` as `tax.createdAt`, `tax`.`updated_at` as `tax.updatedAt` FROM `tax`
Parameters:
[]
18 0.37 ms
# base-context-factory::taxes::association::rules::read
SELECT `tax_rule`.`id` as `tax_rule.id`, `tax_rule`.`tax_rule_type_id` as `tax_rule.taxRuleTypeId`, `tax_rule`.`country_id` as `tax_rule.countryId`, `tax_rule`.`tax_rate` as `tax_rule.taxRate`, `tax_rule`.`data` as `tax_rule.data`, `tax_rule`.`tax_id` as `tax_rule.taxId`, `tax_rule`.`active_from` as `tax_rule.activeFrom`, `tax_rule`.`created_at` as `tax_rule.createdAt`, `tax_rule`.`updated_at` as `tax_rule.updatedAt`, `tax_rule.type`.`id` as `tax_rule.type.id`, `tax_rule.type`.`technical_name` as `tax_rule.type.technicalName`, `tax_rule.type`.`position` as `tax_rule.type.position`, `tax_rule.type`.`created_at` as `tax_rule.type.createdAt`, `tax_rule.type`.`updated_at` as `tax_rule.type.updatedAt`, `tax_rule.type.translation.typeName`, `tax_rule.type.translation.typeName` as `tax_rule.type.typeName` FROM `tax_rule` LEFT JOIN `tax_rule_type` `tax_rule.type` ON `tax_rule`.`tax_rule_type_id` = `tax_rule.type`.`id` LEFT JOIN (SELECT `tax_rule.type.translation`.`tax_rule_type_id`, `tax_rule.type.translation`.`type_name` as `tax_rule.type.translation.typeName` FROM `tax_rule_type_translation` `tax_rule.type.translation` WHERE `tax_rule.type.translation`.`language_id` = ?) `tax_rule.type.tax_rule_type_translation` ON `tax_rule.type.tax_rule_type_translation`.`tax_rule_type_id` = `tax_rule.type`.`id` WHERE (`tax_rule`.`tax_id` IN (?, ?, ?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"?‹Rk•iCá‡w¸Ê@k|)"
  b"r”;psœH™šýI²·@Ç#"
  b"w▄¹\r!»D=ÿµ\x05'ÿüv¢"
]
19 0.49 ms
# base-context-factory::payment-method::read
SELECT `payment_method`.`id` as `payment_method.id`, `payment_method`.`plugin_id` as `payment_method.pluginId`, `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`, `payment_method`.`position` as `payment_method.position`, `payment_method`.`active` as `payment_method.active`, `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`, `payment_method`.`media_id` as `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` as `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` as `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` as `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`recurring_url` as `payment_method.appPaymentMethod.recurringUrl`, `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`, `payment_method`.`technical_name` as `payment_method.technicalName`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `payment_method.media`.`id` as `payment_method.media.id`, `payment_method.media`.`user_id` as `payment_method.media.userId`, `payment_method.media`.`media_folder_id` as `payment_method.media.mediaFolderId`, `payment_method.media`.`mime_type` as `payment_method.media.mimeType`, `payment_method.media`.`file_extension` as `payment_method.media.fileExtension`, `payment_method.media`.`uploaded_at` as `payment_method.media.uploadedAt`, `payment_method.media`.`file_name` as `payment_method.media.fileName`, `payment_method.media`.`file_size` as `payment_method.media.fileSize`, `payment_method.media`.`media_type` as `payment_method.media.mediaTypeRaw`, `payment_method.media`.`meta_data` as `payment_method.media.metaData`, `payment_method.media`.`config` as `payment_method.media.config`, `payment_method.media`.`path` as `payment_method.media.path`, `payment_method.media`.`private` as `payment_method.media.private`, `payment_method.media`.`thumbnails_ro` as `payment_method.media.thumbnailsRo`, `payment_method.media`.`created_at` as `payment_method.media.createdAt`, `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`, `payment_method.media.translation.title`, `payment_method.media.translation.title` as `payment_method.media.title`, `payment_method.media.translation.alt`, `payment_method.media.translation.alt` as `payment_method.media.alt`, `payment_method.media.translation.customFields`, `payment_method.media.translation.customFields` as `payment_method.media.customFields`, `payment_method.translation.name`, `payment_method.translation.name` as `payment_method.name`, `payment_method.translation.distinguishableName`, `payment_method.translation.distinguishableName` as `payment_method.distinguishableName`, `payment_method.translation.description`, `payment_method.translation.description` as `payment_method.description`, `payment_method.translation.customFields`, `payment_method.translation.customFields` as `payment_method.customFields` FROM `payment_method` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.translation`.`payment_method_id`, `payment_method.translation`.`name` as `payment_method.translation.name`, `payment_method.translation`.`distinguishable_name` as `payment_method.translation.distinguishableName`, `payment_method.translation`.`description` as `payment_method.translation.description`, `payment_method.translation`.`custom_fields` as `payment_method.translation.customFields` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.`language_id` = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.`media_id`, `payment_method.media.translation`.`alt` as `payment_method.media.translation.alt`, `payment_method.media.translation`.`title` as `payment_method.media.translation.title`, `payment_method.media.translation`.`custom_fields` as `payment_method.media.translation.customFields` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation`.`language_id` = ?) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"î╦·:\x170NÛÉðØÂ■gÝ="
]
20 0.67 ms
# base-context-factory::shipping-method::read
SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`active` as `shipping_method.active`, `shipping_method`.`position` as `shipping_method.position`, `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` as `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` as `shipping_method.taxType`, `shipping_method`.`tax_id` as `shipping_method.taxId`, `shipping_method.deliveryTime`.`id` as `shipping_method.deliveryTime.id`, `shipping_method.deliveryTime`.`min` as `shipping_method.deliveryTime.min`, `shipping_method.deliveryTime`.`max` as `shipping_method.deliveryTime.max`, `shipping_method.deliveryTime`.`unit` as `shipping_method.deliveryTime.unit`, `shipping_method.deliveryTime`.`created_at` as `shipping_method.deliveryTime.createdAt`, `shipping_method.deliveryTime`.`updated_at` as `shipping_method.deliveryTime.updatedAt`, `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation.name` as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation.customFields` as `shipping_method.deliveryTime.customFields`, `shipping_method.appShippingMethod`.`id` as `shipping_method.appShippingMethod.id`, `shipping_method.appShippingMethod`.`app_name` as `shipping_method.appShippingMethod.appName`, `shipping_method.appShippingMethod`.`identifier` as `shipping_method.appShippingMethod.identifier`, `shipping_method.appShippingMethod`.`app_id` as `shipping_method.appShippingMethod.appId`, `shipping_method.appShippingMethod`.`shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId`, `shipping_method.appShippingMethod`.`original_media_id` as `shipping_method.appShippingMethod.originalMediaId`, `shipping_method.appShippingMethod`.`created_at` as `shipping_method.appShippingMethod.createdAt`, `shipping_method.appShippingMethod`.`updated_at` as `shipping_method.appShippingMethod.updatedAt`, `shipping_method`.`technical_name` as `shipping_method.technicalName`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.media`.`id` as `shipping_method.media.id`, `shipping_method.media`.`user_id` as `shipping_method.media.userId`, `shipping_method.media`.`media_folder_id` as `shipping_method.media.mediaFolderId`, `shipping_method.media`.`mime_type` as `shipping_method.media.mimeType`, `shipping_method.media`.`file_extension` as `shipping_method.media.fileExtension`, `shipping_method.media`.`uploaded_at` as `shipping_method.media.uploadedAt`, `shipping_method.media`.`file_name` as `shipping_method.media.fileName`, `shipping_method.media`.`file_size` as `shipping_method.media.fileSize`, `shipping_method.media`.`media_type` as `shipping_method.media.mediaTypeRaw`, `shipping_method.media`.`meta_data` as `shipping_method.media.metaData`, `shipping_method.media`.`config` as `shipping_method.media.config`, `shipping_method.media`.`path` as `shipping_method.media.path`, `shipping_method.media`.`private` as `shipping_method.media.private`, `shipping_method.media`.`thumbnails_ro` as `shipping_method.media.thumbnailsRo`, `shipping_method.media`.`created_at` as `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`, `shipping_method.media.translation.title`, `shipping_method.media.translation.title` as `shipping_method.media.title`, `shipping_method.media.translation.alt`, `shipping_method.media.translation.alt` as `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, `shipping_method.media.translation.customFields` as `shipping_method.media.customFields`, `shipping_method.translation.name`, `shipping_method.translation.name` as `shipping_method.name`, `shipping_method.translation.description`, `shipping_method.translation.description` as `shipping_method.description`, `shipping_method.translation.trackingUrl`, `shipping_method.translation.trackingUrl` as `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, `shipping_method.translation.customFields` as `shipping_method.customFields` FROM `shipping_method` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method`.`id` = `shipping_method.appShippingMethod`.`shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name`, `shipping_method.translation`.`custom_fields` as `shipping_method.translation.customFields`, `shipping_method.translation`.`description` as `shipping_method.translation.description`, `shipping_method.translation`.`tracking_url` as `shipping_method.translation.trackingUrl` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation`.`delivery_time_id`, `shipping_method.deliveryTime.translation`.`name` as `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation`.`custom_fields` as `shipping_method.deliveryTime.translation.customFields` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation`.`language_id` = ?) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.`media_id`, `shipping_method.media.translation`.`alt` as `shipping_method.media.translation.alt`, `shipping_method.media.translation`.`title` as `shipping_method.media.translation.title`, `shipping_method.media.translation`.`custom_fields` as `shipping_method.media.translation.customFields` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation`.`language_id` = ?) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"L8>;;aLÀ°)´$¾ÌYM"
]
21 0.13 ms
# base-context-factory::cash-rounding::search-ids
SELECT `currency_country_rounding`.`id` FROM `currency_country_rounding` WHERE (`currency_country_rounding`.`currency_id` = ? AND `currency_country_rounding`.`country_id` = ?) LIMIT 1
Parameters:
[
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
  b"=Í¿PnVGÖ±è€\rŒ¬\r{"
]
22 0.64 ms
# context-factory::customer::read
SELECT `customer`.`id` as `customer.id`, `customer`.`customer_group_id` as `customer.groupId`, `customer`.`sales_channel_id` as `customer.salesChannelId`, `customer`.`language_id` as `customer.languageId`, `customer`.`last_payment_method_id` as `customer.lastPaymentMethodId`, `customer`.`default_billing_address_id` as `customer.defaultBillingAddressId`, `customer`.`default_shipping_address_id` as `customer.defaultShippingAddressId`, `customer`.`auto_increment` as `customer.autoIncrement`, `customer`.`customer_number` as `customer.customerNumber`, `customer`.`salutation_id` as `customer.salutationId`, `customer`.`first_name` as `customer.firstName`, `customer`.`last_name` as `customer.lastName`, `customer`.`company` as `customer.company`, `customer`.`password` as `customer.password`, `customer`.`email` as `customer.email`, `customer`.`title` as `customer.title`, `customer`.`vat_ids` as `customer.vatIds`, `customer`.`affiliate_code` as `customer.affiliateCode`, `customer`.`campaign_code` as `customer.campaignCode`, `customer`.`active` as `customer.active`, `customer`.`double_opt_in_registration` as `customer.doubleOptInRegistration`, `customer`.`double_opt_in_email_sent_date` as `customer.doubleOptInEmailSentDate`, `customer`.`double_opt_in_confirm_date` as `customer.doubleOptInConfirmDate`, `customer`.`hash` as `customer.hash`, `customer`.`guest` as `customer.guest`, `customer`.`first_login` as `customer.firstLogin`, `customer`.`last_login` as `customer.lastLogin`, `customer`.`newsletter_sales_channel_ids` as `customer.newsletterSalesChannelIds`, `customer`.`birthday` as `customer.birthday`, `customer`.`last_order_date` as `customer.lastOrderDate`, `customer`.`order_count` as `customer.orderCount`, `customer`.`order_total_amount` as `customer.orderTotalAmount`, `customer`.`review_count` as `customer.reviewCount`, `customer`.`custom_fields` as `customer.customFields`, `customer`.`legacy_password` as `customer.legacyPassword`, `customer`.`legacy_encoder` as `customer.legacyEncoder`, `customer`.`remote_address` as `customer.remoteAddress`, `customer`.`tag_ids` as `customer.tagIds`, `customer`.`requested_customer_group_id` as `customer.requestedGroupId`, `customer`.`bound_sales_channel_id` as `customer.boundSalesChannelId`, `customer`.`account_type` as `customer.accountType`, `customer`.`created_by_id` as `customer.createdById`, `customer`.`updated_by_id` as `customer.updatedById`, `customer`.`default_payment_method_id` as `customer.defaultPaymentMethodId`, `customer`.`created_at` as `customer.createdAt`, `customer`.`updated_at` as `customer.updatedAt`, `customer.salutation`.`id` as `customer.salutation.id`, `customer.salutation`.`salutation_key` as `customer.salutation.salutationKey`, `customer.salutation`.`created_at` as `customer.salutation.createdAt`, `customer.salutation`.`updated_at` as `customer.salutation.updatedAt`, `customer.salutation.translation.displayName`, `customer.salutation.translation.displayName` as `customer.salutation.displayName`, `customer.salutation.translation.letterName`, `customer.salutation.translation.letterName` as `customer.salutation.letterName`, `customer.salutation.translation.customFields`, `customer.salutation.translation.customFields` as `customer.salutation.customFields`, `customer.defaultPaymentMethod`.`id` as `customer.defaultPaymentMethod.id`, `customer.defaultPaymentMethod`.`plugin_id` as `customer.defaultPaymentMethod.pluginId`, `customer.defaultPaymentMethod`.`handler_identifier` as `customer.defaultPaymentMethod.handlerIdentifier`, `customer.defaultPaymentMethod`.`position` as `customer.defaultPaymentMethod.position`, `customer.defaultPaymentMethod`.`active` as `customer.defaultPaymentMethod.active`, `customer.defaultPaymentMethod`.`after_order_enabled` as `customer.defaultPaymentMethod.afterOrderEnabled`, `customer.defaultPaymentMethod`.`availability_rule_id` as `customer.defaultPaymentMethod.availabilityRuleId`, `customer.defaultPaymentMethod`.`media_id` as `customer.defaultPaymentMethod.mediaId`, `customer.defaultPaymentMethod.appPaymentMethod`.`id` as `customer.defaultPaymentMethod.appPaymentMethod.id`, `customer.defaultPaymentMethod.appPaymentMethod`.`app_name` as `customer.defaultPaymentMethod.appPaymentMethod.appName`, `customer.defaultPaymentMethod.appPaymentMethod`.`identifier` as `customer.defaultPaymentMethod.appPaymentMethod.identifier`, `customer.defaultPaymentMethod.appPaymentMethod`.`pay_url` as `customer.defaultPaymentMethod.appPaymentMethod.payUrl`, `customer.defaultPaymentMethod.appPaymentMethod`.`finalize_url` as `customer.defaultPaymentMethod.appPaymentMethod.finalizeUrl`, `customer.defaultPaymentMethod.appPaymentMethod`.`validate_url` as `customer.defaultPaymentMethod.appPaymentMethod.validateUrl`, `customer.defaultPaymentMethod.appPaymentMethod`.`capture_url` as `customer.defaultPaymentMethod.appPaymentMethod.captureUrl`, `customer.defaultPaymentMethod.appPaymentMethod`.`refund_url` as `customer.defaultPaymentMethod.appPaymentMethod.refundUrl`, `customer.defaultPaymentMethod.appPaymentMethod`.`recurring_url` as `customer.defaultPaymentMethod.appPaymentMethod.recurringUrl`, `customer.defaultPaymentMethod.appPaymentMethod`.`app_id` as `customer.defaultPaymentMethod.appPaymentMethod.appId`, `customer.defaultPaymentMethod.appPaymentMethod`.`original_media_id` as `customer.defaultPaymentMethod.appPaymentMethod.originalMediaId`, `customer.defaultPaymentMethod.appPaymentMethod`.`payment_method_id` as `customer.defaultPaymentMethod.appPaymentMethod.paymentMethodId`, `customer.defaultPaymentMethod.appPaymentMethod`.`created_at` as `customer.defaultPaymentMethod.appPaymentMethod.createdAt`, `customer.defaultPaymentMethod.appPaymentMethod`.`updated_at` as `customer.defaultPaymentMethod.appPaymentMethod.updatedAt`, `customer.defaultPaymentMethod`.`technical_name` as `customer.defaultPaymentMethod.technicalName`, `customer.defaultPaymentMethod`.`created_at` as `customer.defaultPaymentMethod.createdAt`, `customer.defaultPaymentMethod`.`updated_at` as `customer.defaultPaymentMethod.updatedAt`, `customer.defaultPaymentMethod.translation.name`, `customer.defaultPaymentMethod.translation.name` as `customer.defaultPaymentMethod.name`, `customer.defaultPaymentMethod.translation.distinguishableName`, `customer.defaultPaymentMethod.translation.distinguishableName` as `customer.defaultPaymentMethod.distinguishableName`, `customer.defaultPaymentMethod.translation.description`, `customer.defaultPaymentMethod.translation.description` as `customer.defaultPaymentMethod.description`, `customer.defaultPaymentMethod.translation.customFields`, `customer.defaultPaymentMethod.translation.customFields` as `customer.defaultPaymentMethod.customFields` FROM `customer` LEFT JOIN `salutation` `customer.salutation` ON `customer`.`salutation_id` = `customer.salutation`.`id` LEFT JOIN `payment_method` `customer.defaultPaymentMethod` ON `customer`.`default_payment_method_id` = `customer.defaultPaymentMethod`.`id` LEFT JOIN (SELECT `customer.salutation.translation`.`salutation_id`, `customer.salutation.translation`.`display_name` as `customer.salutation.translation.displayName`, `customer.salutation.translation`.`letter_name` as `customer.salutation.translation.letterName`, `customer.salutation.translation`.`custom_fields` as `customer.salutation.translation.customFields` FROM `salutation_translation` `customer.salutation.translation` WHERE `customer.salutation.translation`.`language_id` = ?) `customer.salutation.salutation_translation` ON `customer.salutation.salutation_translation`.`salutation_id` = `customer.salutation`.`id` LEFT JOIN `app_payment_method` `customer.defaultPaymentMethod.appPaymentMethod` ON `customer.defaultPaymentMethod`.`id` = `customer.defaultPaymentMethod.appPaymentMethod`.`payment_method_id` LEFT JOIN (SELECT `customer.defaultPaymentMethod.translation`.`payment_method_id`, `customer.defaultPaymentMethod.translation`.`name` as `customer.defaultPaymentMethod.translation.name`, `customer.defaultPaymentMethod.translation`.`distinguishable_name` as `customer.defaultPaymentMethod.translation.distinguishableName`, `customer.defaultPaymentMethod.translation`.`description` as `customer.defaultPaymentMethod.translation.description`, `customer.defaultPaymentMethod.translation`.`custom_fields` as `customer.defaultPaymentMethod.translation.customFields` FROM `payment_method_translation` `customer.defaultPaymentMethod.translation` WHERE `customer.defaultPaymentMethod.translation`.`language_id` = ?) `customer.defaultPaymentMethod.payment_method_translation` ON `customer.defaultPaymentMethod.payment_method_translation`.`payment_method_id` = `customer.defaultPaymentMethod`.`id` WHERE (((`customer`.`bound_sales_channel_id` <=> ? OR `customer`.`bound_sales_channel_id` = ?))) AND (`customer`.`id` IN (?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  null
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  b"\x01“ôþ\x11¿ri¤]ÚO²!Ê<"
]
23 0.57 ms
# context-factory::addresses::read
SELECT `customer_address`.`id` as `customer_address.id`, `customer_address`.`customer_id` as `customer_address.customerId`, `customer_address`.`country_id` as `customer_address.countryId`, `customer_address`.`country_state_id` as `customer_address.countryStateId`, `customer_address`.`salutation_id` as `customer_address.salutationId`, `customer_address`.`first_name` as `customer_address.firstName`, `customer_address`.`last_name` as `customer_address.lastName`, `customer_address`.`zipcode` as `customer_address.zipcode`, `customer_address`.`city` as `customer_address.city`, `customer_address`.`company` as `customer_address.company`, `customer_address`.`street` as `customer_address.street`, `customer_address`.`department` as `customer_address.department`, `customer_address`.`title` as `customer_address.title`, `customer_address`.`phone_number` as `customer_address.phoneNumber`, `customer_address`.`additional_address_line1` as `customer_address.additionalAddressLine1`, `customer_address`.`additional_address_line2` as `customer_address.additionalAddressLine2`, `customer_address`.`custom_fields` as `customer_address.customFields`, `customer_address`.`created_at` as `customer_address.createdAt`, `customer_address`.`updated_at` as `customer_address.updatedAt`, `customer_address.salutation`.`id` as `customer_address.salutation.id`, `customer_address.salutation`.`salutation_key` as `customer_address.salutation.salutationKey`, `customer_address.salutation`.`created_at` as `customer_address.salutation.createdAt`, `customer_address.salutation`.`updated_at` as `customer_address.salutation.updatedAt`, `customer_address.salutation.translation.displayName`, `customer_address.salutation.translation.displayName` as `customer_address.salutation.displayName`, `customer_address.salutation.translation.letterName`, `customer_address.salutation.translation.letterName` as `customer_address.salutation.letterName`, `customer_address.salutation.translation.customFields`, `customer_address.salutation.translation.customFields` as `customer_address.salutation.customFields`, `customer_address.country`.`id` as `customer_address.country.id`, `customer_address.country`.`iso` as `customer_address.country.iso`, `customer_address.country`.`position` as `customer_address.country.position`, `customer_address.country`.`active` as `customer_address.country.active`, `customer_address.country`.`shipping_available` as `customer_address.country.shippingAvailable`, `customer_address.country`.`iso3` as `customer_address.country.iso3`, `customer_address.country`.`display_state_in_registration` as `customer_address.country.displayStateInRegistration`, `customer_address.country`.`force_state_in_registration` as `customer_address.country.forceStateInRegistration`, `customer_address.country`.`check_vat_id_pattern` as `customer_address.country.checkVatIdPattern`, `customer_address.country`.`vat_id_required` as `customer_address.country.vatIdRequired`, `customer_address.country`.`vat_id_pattern` as `customer_address.country.vatIdPattern`, `customer_address.country`.`customer_tax` as `customer_address.country.customerTax`, `customer_address.country`.`company_tax` as `customer_address.country.companyTax`, `customer_address.country`.`postal_code_required` as `customer_address.country.postalCodeRequired`, `customer_address.country`.`check_postal_code_pattern` as `customer_address.country.checkPostalCodePattern`, `customer_address.country`.`check_advanced_postal_code_pattern` as `customer_address.country.checkAdvancedPostalCodePattern`, `customer_address.country`.`advanced_postal_code_pattern` as `customer_address.country.advancedPostalCodePattern`, `customer_address.country`.`default_postal_code_pattern` as `customer_address.country.defaultPostalCodePattern`, `customer_address.country`.`is_eu` as `customer_address.country.isEu`, `customer_address.country`.`created_at` as `customer_address.country.createdAt`, `customer_address.country`.`updated_at` as `customer_address.country.updatedAt`, `customer_address.country.translation.name`, `customer_address.country.translation.name` as `customer_address.country.name`, `customer_address.country.translation.addressFormat`, `customer_address.country.translation.addressFormat` as `customer_address.country.addressFormat`, `customer_address.country.translation.customFields`, `customer_address.country.translation.customFields` as `customer_address.country.customFields`, `customer_address.countryState`.`id` as `customer_address.countryState.id`, `customer_address.countryState`.`country_id` as `customer_address.countryState.countryId`, `customer_address.countryState`.`short_code` as `customer_address.countryState.shortCode`, `customer_address.countryState`.`position` as `customer_address.countryState.position`, `customer_address.countryState`.`active` as `customer_address.countryState.active`, `customer_address.countryState`.`created_at` as `customer_address.countryState.createdAt`, `customer_address.countryState`.`updated_at` as `customer_address.countryState.updatedAt`, `customer_address.countryState.translation.name`, `customer_address.countryState.translation.name` as `customer_address.countryState.name`, `customer_address.countryState.translation.customFields`, `customer_address.countryState.translation.customFields` as `customer_address.countryState.customFields` FROM `customer_address` LEFT JOIN `salutation` `customer_address.salutation` ON `customer_address`.`salutation_id` = `customer_address.salutation`.`id` LEFT JOIN `country` `customer_address.country` ON `customer_address`.`country_id` = `customer_address.country`.`id` LEFT JOIN `country_state` `customer_address.countryState` ON `customer_address`.`country_state_id` = `customer_address.countryState`.`id` LEFT JOIN (SELECT `customer_address.salutation.translation`.`salutation_id`, `customer_address.salutation.translation`.`display_name` as `customer_address.salutation.translation.displayName`, `customer_address.salutation.translation`.`letter_name` as `customer_address.salutation.translation.letterName`, `customer_address.salutation.translation`.`custom_fields` as `customer_address.salutation.translation.customFields` FROM `salutation_translation` `customer_address.salutation.translation` WHERE `customer_address.salutation.translation`.`language_id` = ?) `customer_address.salutation.salutation_translation` ON `customer_address.salutation.salutation_translation`.`salutation_id` = `customer_address.salutation`.`id` LEFT JOIN (SELECT `customer_address.country.translation`.`country_id`, `customer_address.country.translation`.`name` as `customer_address.country.translation.name`, `customer_address.country.translation`.`custom_fields` as `customer_address.country.translation.customFields`, `customer_address.country.translation`.`address_format` as `customer_address.country.translation.addressFormat` FROM `country_translation` `customer_address.country.translation` WHERE `customer_address.country.translation`.`language_id` = ?) `customer_address.country.country_translation` ON `customer_address.country.country_translation`.`country_id` = `customer_address.country`.`id` LEFT JOIN (SELECT `customer_address.countryState.translation`.`country_state_id`, `customer_address.countryState.translation`.`name` as `customer_address.countryState.translation.name`, `customer_address.countryState.translation`.`custom_fields` as `customer_address.countryState.translation.customFields` FROM `country_state_translation` `customer_address.countryState.translation` WHERE `customer_address.countryState.translation`.`language_id` = ?) `customer_address.countryState.country_state_translation` ON `customer_address.countryState.country_state_translation`.`country_state_id` = `customer_address.countryState`.`id` WHERE `customer_address`.`id` IN (?, ?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01“ôþ\x11¿ri¤]ÚO²i…å"
  b"\x01“ôþ\x11Ás–¨)n\x02R\x0F\K"
]
24 0.12 ms
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters:
[]
25 0.39 ms
# context-factory::customer-group::read
SELECT `customer_group`.`id` as `customer_group.id`, `customer_group`.`display_gross` as `customer_group.displayGross`, `customer_group`.`registration_active` as `customer_group.registrationActive`, `customer_group`.`created_at` as `customer_group.createdAt`, `customer_group`.`updated_at` as `customer_group.updatedAt`, `customer_group.evpPriceSettings`.`id` as `customer_group.evpPriceSettings.id`, `customer_group.evpPriceSettings`.`customer_group_id` as `customer_group.evpPriceSettings.customerGroupId`, `customer_group.evpPriceSettings`.`reference_price_customer_group_id` as `customer_group.evpPriceSettings.referencePriceCustomerGroupId`, `customer_group.evpPriceSettings`.`reference_price_rule_id` as `customer_group.evpPriceSettings.referencePriceRuleId`, `customer_group.evpPriceSettings`.`show_net_price` as `customer_group.evpPriceSettings.showNetPrice`, `customer_group.evpPriceSettings`.`use_pseudo_price` as `customer_group.evpPriceSettings.usePseudoPrice`, `customer_group.evpPriceSettings`.`display_on_detail` as `customer_group.evpPriceSettings.displayOnDetail`, `customer_group.evpPriceSettings`.`display_in_cart` as `customer_group.evpPriceSettings.displayInCart`, `customer_group.evpPriceSettings`.`display_in_listing` as `customer_group.evpPriceSettings.displayInListing`, `customer_group.evpPriceSettings`.`active` as `customer_group.evpPriceSettings.active`, `customer_group.evpPriceSettings.referencePriceRule`.`id` as `customer_group.evpPriceSettings.referencePriceRule.id`, `customer_group.evpPriceSettings.referencePriceRule`.`name` as `customer_group.evpPriceSettings.referencePriceRule.name`, `customer_group.evpPriceSettings.referencePriceRule`.`priority` as `customer_group.evpPriceSettings.referencePriceRule.priority`, `customer_group.evpPriceSettings.referencePriceRule`.`description` as `customer_group.evpPriceSettings.referencePriceRule.description`, `customer_group.evpPriceSettings.referencePriceRule`.`payload` as `customer_group.evpPriceSettings.referencePriceRule.payload`, `customer_group.evpPriceSettings.referencePriceRule`.`invalid` as `customer_group.evpPriceSettings.referencePriceRule.invalid`, `customer_group.evpPriceSettings.referencePriceRule`.`areas` as `customer_group.evpPriceSettings.referencePriceRule.areas`, `customer_group.evpPriceSettings.referencePriceRule`.`custom_fields` as `customer_group.evpPriceSettings.referencePriceRule.customFields`, `customer_group.evpPriceSettings.referencePriceRule`.`module_types` as `customer_group.evpPriceSettings.referencePriceRule.moduleTypes`, `customer_group.evpPriceSettings.referencePriceRule`.`created_at` as `customer_group.evpPriceSettings.referencePriceRule.createdAt`, `customer_group.evpPriceSettings.referencePriceRule`.`updated_at` as `customer_group.evpPriceSettings.referencePriceRule.updatedAt`, `customer_group.evpPriceSettings`.`created_at` as `customer_group.evpPriceSettings.createdAt`, `customer_group.evpPriceSettings`.`updated_at` as `customer_group.evpPriceSettings.updatedAt`, `customer_group.translation.name`, `customer_group.translation.name` as `customer_group.name`, `customer_group.translation.registrationTitle`, `customer_group.translation.registrationTitle` as `customer_group.registrationTitle`, `customer_group.translation.registrationIntroduction`, `customer_group.translation.registrationIntroduction` as `customer_group.registrationIntroduction`, `customer_group.translation.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationOnlyCompanyRegistration` as `customer_group.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationSeoMetaDescription`, `customer_group.translation.registrationSeoMetaDescription` as `customer_group.registrationSeoMetaDescription`, `customer_group.translation.customFields`, `customer_group.translation.customFields` as `customer_group.customFields` FROM `customer_group` LEFT JOIN `coe_evp_price_customer_group_setting` `customer_group.evpPriceSettings` ON `customer_group`.`id` = `customer_group.evpPriceSettings`.`customer_group_id` LEFT JOIN (SELECT `customer_group.translation`.`customer_group_id`, `customer_group.translation`.`name` as `customer_group.translation.name`, `customer_group.translation`.`custom_fields` as `customer_group.translation.customFields`, `customer_group.translation`.`registration_title` as `customer_group.translation.registrationTitle`, `customer_group.translation`.`registration_introduction` as `customer_group.translation.registrationIntroduction`, `customer_group.translation`.`registration_only_company_registration` as `customer_group.translation.registrationOnlyCompanyRegistration`, `customer_group.translation`.`registration_seo_meta_description` as `customer_group.translation.registrationSeoMetaDescription` FROM `customer_group_translation` `customer_group.translation` WHERE `customer_group.translation`.`language_id` = ?) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation`.`customer_group_id` = `customer_group`.`id` LEFT JOIN `rule` `customer_group.evpPriceSettings.referencePriceRule` ON `customer_group.evpPriceSettings`.`reference_price_rule_id` = `customer_group.evpPriceSettings.referencePriceRule`.`id` WHERE `customer_group`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"¤¢P\x18ËìAÏ¡╩\x10┘O╚¢Í"
]
26 0.16 ms
#cart-persister::load
            SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters:
[
  "ltQoKGxpTGEgp2YH6HBuBxKQab5FV6eq"
]
27 0.17 ms
# cart-rule-loader::load-rules::search-ids
SELECT `rule`.`id` FROM `rule` WHERE (`rule`.`invalid` = ?) ORDER BY `rule`.`priority` DESC, `rule`.`id` ASC LIMIT 500
Parameters:
[
  false
]
28 0.28 ms
# cart-rule-loader::load-rules::read
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“h\x0EÇ_~í‚.@>œîC%"
  b"\x01“h\r\x02d\x7F ¾òFä‘€\x16\x07"
  b"\x01“h\rÝÙp\x11›³˜&\x15¤\tP"
  b"""
    \n
    ä*ñ\x19B\x12¤\v\x0F‘¡wXº
    """
  b"™†H“•Ø@†ºENX³û\fÓ"
  b"Ó+îûréCÜž×&Ì÷{\x03¢"
  b"õ8/óùgL╣ìé▄)┤Q╔\x19"
  b"\rÿƒ+GãK\x08šqK\v\x0FÓÖÊ"
  b"ßl\x14\f8>J…’Ž45˜¢¨‚"
  b"\x01\x18£ù1yu·À•«E\x1AUw"
  b"\x04¿­N═9JZü╔J¾\tmÇð"
  b"\x12ìÂCµŠLq‰ó“ÐØ\x0E–â"
  b"+”\x15\x07#rHÒ—>E\fI?N4"
  b"6F¿x…¯Cvƒy™ß;%ÃÍ"
  b"\x16_LÉGƒ·\x0F¢ƒåþI\x03"
  b"^±░═╚ðK'ä¹\t=ü‗)¬"
  b"_\x10 &x,Cp¥ØÁȪœ/ë"
  b"d╔rl¨YG'ƒ\x03\fü ô«¢"
  b"jlrla8J©º_S\x102\x07o\r"
  b"""
    p\x15\n
    J¦\LÐÅ­!Ùâv\x01\x1E
    """
  b"|VK¢Æ£O9²ýtO>†®K"
  b"ˆa£À¡8LÙ¨ìlg\x12‹ä1"
  b"Äü*\x1AÅ\tG£Äé^J╦÷å╝"
  b"’w” :ÜJ\x07ž\x03þÖÖS\x14"
  b"ž\x07°Ž\x0F\x14F)†\x08¿\e¸\x07Å\x11"
  b"žôÆêöKK~¼©“ú\x13rC\x12"
  b"ŸP¾¢õ\x08@ö¢8üÂô}iÅ"
  b"áÆLÚ/ÿLO»┼´╠§¹óØ"
  b"¡vš»´n@tªa@‚Ócñ\x1C"
  b"ó¡Î³È@@)òÛ©\e▄ÍÐØ"
  b"º{"âRîCßÅàP.╣n\vı"
  b"§î\x05`ÈùNPœÝî­*(\x00è"
  b"¡\rÅ{▒┘F\x11ñ¶\vLH\x04"
  b"Á†ÐŠÑìDŪ,\x02ˆ›$]\x1D"
  b"Ç\x1Cb5\x17yLíºAnõq\x1AzR"
  b"Љ˜\x1A%\rBè“֗ЀÄA8"
  b"ÒMm'ýÍFŲÄ\x14jà²r"
  b"Ù\x00#,öžOÔ•BD礪¥ˆ"
  b"Ú:Å »ŽFW§Ž›˜õeoÕ"
  b"█ª!Ø ³H¸ÄýQ²┤Ìd\x03"
]
29 0.27 ms
SELECT DISTINCT LOWER(HEX(psm.product_id)) as productId, LOWER(HEX(psm.product_stream_id)) as productStreamId, LOWER(HEX(lolicg.id)) as lenzOrderLineItemCommentGroupId FROM product_stream_mapping psm INNER JOIN lenz_order_line_item_comment_group lolicg ON lolicg.product_stream_id = psm.product_stream_id AND lolicg.mode = ? WHERE product_id IN (?) GROUP BY productId
Parameters:
[
  "product_stream"
  b"®\x00½y§DGäƒ2ª\x06Ú1\x07;"
]
30 0.91 ms
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, (SELECT GROUP_CONCAT(HEX(`product.lenzOrderLineItemCommentGroups.mapping`.`order_line_item_group_id`) SEPARATOR '||')
                  FROM `lenz_order_line_item_comment_group_product` `product.lenzOrderLineItemCommentGroups.mapping`
                  WHERE `product.lenzOrderLineItemCommentGroups.mapping`.`product_id` = `product`.`lenzOrderLineItemCommentGroups` ) as `product.lenzOrderLineItemCommentGroups.id_mapping`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`meta_description` as `product.translation.metaDescription`, `product.translation`.`name` as `product.translation.name`, `product.translation`.`keywords` as `product.translation.keywords`, `product.translation`.`description` as `product.translation.description`, `product.translation`.`meta_title` as `product.translation.metaTitle`, `product.translation`.`pack_unit` as `product.translation.packUnit`, `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`, `product.translation`.`custom_fields` as `product.translation.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`meta_description` as `product.parent.translation.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"®\x00½y§DGäƒ2ª\x06Ú1\x07;"
]
31 0.14 ms
SELECT `lenz_order_line_item_comment_group`.`id` FROM `lenz_order_line_item_comment_group` WHERE ((`lenz_order_line_item_comment_group`.`mode` = ? OR (`lenz_order_line_item_comment_group`.`mode` = ? AND `lenz_order_line_item_comment_group`.`product_stream_id` IN (NULL)))) ORDER BY `lenz_order_line_item_comment_group`.`position` ASC
Parameters:
[
  "all"
  "product_stream"
]
32 0.29 ms
SELECT `lenz_order_line_item_comment_group`.`id` as `lenz_order_line_item_comment_group.id`, `lenz_order_line_item_comment_group`.`position` as `lenz_order_line_item_comment_group.position`, `lenz_order_line_item_comment_group`.`mode` as `lenz_order_line_item_comment_group.mode`, `lenz_order_line_item_comment_group`.`type` as `lenz_order_line_item_comment_group.type`, `lenz_order_line_item_comment_group`.`product_stream_id` as `lenz_order_line_item_comment_group.productStreamId`, `lenz_order_line_item_comment_group`.`created_at` as `lenz_order_line_item_comment_group.createdAt`, `lenz_order_line_item_comment_group`.`updated_at` as `lenz_order_line_item_comment_group.updatedAt`, (SELECT GROUP_CONCAT(HEX(`lenz_order_line_item_comment_group.salesChannels.mapping`.`sales_channel_id`) SEPARATOR '||')
                  FROM `lenz_order_line_item_comment_group_sales_channel` `lenz_order_line_item_comment_group.salesChannels.mapping`
                  WHERE `lenz_order_line_item_comment_group.salesChannels.mapping`.`order_line_item_group_id` = `lenz_order_line_item_comment_group`.`id` ) as `lenz_order_line_item_comment_group.salesChannels.id_mapping`, `lenz_order_line_item_comment_group.translation.name`, `lenz_order_line_item_comment_group.translation.name` as `lenz_order_line_item_comment_group.name`, `lenz_order_line_item_comment_group.translation.description`, `lenz_order_line_item_comment_group.translation.description` as `lenz_order_line_item_comment_group.description` FROM `lenz_order_line_item_comment_group` LEFT JOIN (SELECT `lenz_order_line_item_comment_group.translation`.`lenz_order_line_item_comment_group_id`, `lenz_order_line_item_comment_group.translation`.`name` as `lenz_order_line_item_comment_group.translation.name`, `lenz_order_line_item_comment_group.translation`.`description` as `lenz_order_line_item_comment_group.translation.description` FROM `lenz_order_line_item_comment_group_translation` `lenz_order_line_item_comment_group.translation` WHERE `lenz_order_line_item_comment_group.translation`.`language_id` = ?) `lenz_order_line_item_comment_group.lenz_order_line_item_comment_group_translation` ON `lenz_order_line_item_comment_group.lenz_order_line_item_comment_group_translation`.`lenz_order_line_item_comment_group_id` = `lenz_order_line_item_comment_group`.`id` WHERE `lenz_order_line_item_comment_group`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"æ±ÄW¾\x1FEm¿mk¤\fŽÂ¡"
]
33 0.28 ms
SELECT `lenz_order_line_item_comment_field`.`id` as `lenz_order_line_item_comment_field.id`, `lenz_order_line_item_comment_field`.`type` as `lenz_order_line_item_comment_field.type`, `lenz_order_line_item_comment_field`.`pattern` as `lenz_order_line_item_comment_field.pattern`, `lenz_order_line_item_comment_field`.`step` as `lenz_order_line_item_comment_field.step`, `lenz_order_line_item_comment_field`.`position` as `lenz_order_line_item_comment_field.position`, `lenz_order_line_item_comment_field`.`min_length` as `lenz_order_line_item_comment_field.minLength`, `lenz_order_line_item_comment_field`.`max_length` as `lenz_order_line_item_comment_field.maxLength`, `lenz_order_line_item_comment_field`.`required` as `lenz_order_line_item_comment_field.required`, `lenz_order_line_item_comment_field`.`configurator_price` as `lenz_order_line_item_comment_field.configuratorPrice`, `lenz_order_line_item_comment_field`.`configurator_product_number` as `lenz_order_line_item_comment_field.configuratorProductNumber`, `lenz_order_line_item_comment_field`.`line_item_comment_group_id` as `lenz_order_line_item_comment_field.lineItemCommentGroupId`, `lenz_order_line_item_comment_field`.`created_at` as `lenz_order_line_item_comment_field.createdAt`, `lenz_order_line_item_comment_field`.`updated_at` as `lenz_order_line_item_comment_field.updatedAt`, `lenz_order_line_item_comment_field.translation.name`, `lenz_order_line_item_comment_field.translation.name` as `lenz_order_line_item_comment_field.name`, `lenz_order_line_item_comment_field.translation.placeholder`, `lenz_order_line_item_comment_field.translation.placeholder` as `lenz_order_line_item_comment_field.placeholder`, `lenz_order_line_item_comment_field.translation.description`, `lenz_order_line_item_comment_field.translation.description` as `lenz_order_line_item_comment_field.description` FROM `lenz_order_line_item_comment_field` LEFT JOIN (SELECT `lenz_order_line_item_comment_field.translation`.`lenz_order_line_item_comment_field_id`, `lenz_order_line_item_comment_field.translation`.`name` as `lenz_order_line_item_comment_field.translation.name`, `lenz_order_line_item_comment_field.translation`.`placeholder` as `lenz_order_line_item_comment_field.translation.placeholder`, `lenz_order_line_item_comment_field.translation`.`description` as `lenz_order_line_item_comment_field.translation.description` FROM `lenz_order_line_item_comment_field_translation` `lenz_order_line_item_comment_field.translation` WHERE `lenz_order_line_item_comment_field.translation`.`language_id` = ?) `lenz_order_line_item_comment_field.lenz_order_line_item_comment_field_translation` ON `lenz_order_line_item_comment_field.lenz_order_line_item_comment_field_translation`.`lenz_order_line_item_comment_field_id` = `lenz_order_line_item_comment_field`.`id` WHERE (`lenz_order_line_item_comment_field`.`line_item_comment_group_id` IN (?)) ORDER BY `lenz_order_line_item_comment_field`.`position` ASC
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"æ±ÄW¾\x1FEm¿mk¤\fŽÂ¡"
]
34 0.22 ms
SELECT `lenz_order_line_item_comment_field_option`.`id` as `lenz_order_line_item_comment_field_option.id`, `lenz_order_line_item_comment_field_option`.`position` as `lenz_order_line_item_comment_field_option.position`, `lenz_order_line_item_comment_field_option`.`value` as `lenz_order_line_item_comment_field_option.value`, `lenz_order_line_item_comment_field_option`.`configurator_price` as `lenz_order_line_item_comment_field_option.configuratorPrice`, `lenz_order_line_item_comment_field_option`.`configurator_product_number` as `lenz_order_line_item_comment_field_option.configuratorProductNumber`, `lenz_order_line_item_comment_field_option`.`field_id` as `lenz_order_line_item_comment_field_option.fieldId`, `lenz_order_line_item_comment_field_option`.`created_at` as `lenz_order_line_item_comment_field_option.createdAt`, `lenz_order_line_item_comment_field_option`.`updated_at` as `lenz_order_line_item_comment_field_option.updatedAt`, `lenz_order_line_item_comment_field_option.translation.label`, `lenz_order_line_item_comment_field_option.translation.label` as `lenz_order_line_item_comment_field_option.label` FROM `lenz_order_line_item_comment_field_option` LEFT JOIN (SELECT `lenz_order_line_item_comment_field_option.translation`.`lenz_order_line_item_comment_field_option_id`, `lenz_order_line_item_comment_field_option.translation`.`label` as `lenz_order_line_item_comment_field_option.translation.label` FROM `lenz_order_line_item_comment_field_option_translation` `lenz_order_line_item_comment_field_option.translation` WHERE `lenz_order_line_item_comment_field_option.translation`.`language_id` = ?) `lenz_order_line_item_comment_field_option.lenz_order_line_item_comment_field_option_translation` ON `lenz_order_line_item_comment_field_option.lenz_order_line_item_comment_field_option_translation`.`lenz_order_line_item_comment_field_option_id` = `lenz_order_line_item_comment_field_option`.`id` WHERE (`lenz_order_line_item_comment_field_option`.`field_id` IN (?)) ORDER BY `lenz_order_line_item_comment_field_option`.`position` ASC
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"¶]:ô‗HFÀºÉÆ¥}\x1A\x1CÉ"
]
35 0.35 ms
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.translation.name`, `sales_channel.translation.name` as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, `sales_channel.translation.homeName` as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, `sales_channel.translation.customFields` as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.`sales_channel_id`, `sales_channel.translation`.`name` as `sales_channel.translation.name`, `sales_channel.translation`.`custom_fields` as `sales_channel.translation.customFields`, `sales_channel.translation`.`home_slot_config` as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.`home_enabled` as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.`home_name` as `sales_channel.translation.homeName`, `sales_channel.translation`.`home_meta_title` as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.`home_meta_description` as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.`home_keywords` as `sales_channel.translation.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.`language_id` = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` WHERE `sales_channel`.`id` IN (?, ?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  b"ɦõ¿\t‚D±±&xÃjí,Q"
]
36 0.13 ms
SELECT LOWER(HEX(id)) as id, updated_at FROM product WHERE id IN (?) AND version_id = ?
Parameters:
[
  b"®\x00½y§DGäƒ2ª\x06Ú1\x07;"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
]
37 0.22 ms
# cart::products::search-ids
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?))) AND (`product`.`id` IN (?)) GROUP BY `product`.`id`
Parameters:
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  10
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  true
  b"®\x00½y§DGäƒ2ª\x06Ú1\x07;"
]
38 1.54 ms
# cart::products::read
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product.parent`.`cheapest_price` as `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.cover`.`id` as `product.cover.id`, `product.cover`.`version_id` as `product.cover.versionId`, `product.cover`.`product_id` as `product.cover.productId`, `product.cover`.`product_version_id` as `product.cover.productVersionId`, `product.cover`.`media_id` as `product.cover.mediaId`, `product.cover`.`position` as `product.cover.position`, `product.cover.media`.`id` as `product.cover.media.id`, `product.cover.media`.`user_id` as `product.cover.media.userId`, `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` as `product.cover.media.fileName`, `product.cover.media`.`file_size` as `product.cover.media.fileSize`, `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` as `product.cover.media.metaData`, `product.cover.media`.`config` as `product.cover.media.config`, `product.cover.media`.`path` as `product.cover.media.path`, `product.cover.media`.`private` as `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, `product.cover.media`.`created_at` as `product.cover.media.createdAt`, `product.cover.media`.`updated_at` as `product.cover.media.updatedAt`, `product.cover.media.translation.title`, `product.cover.media.translation.title` as `product.cover.media.title`, `product.cover.media.translation.alt`, `product.cover.media.translation.alt` as `product.cover.media.alt`, `product.cover.media.translation.customFields`, `product.cover.media.translation.customFields` as `product.cover.media.customFields`, `product.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_option` `product.options.mapping`
                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, `product.featureSet`.`id` as `product.featureSet.id`, `product.featureSet`.`features` as `product.featureSet.features`, `product.featureSet`.`created_at` as `product.featureSet.createdAt`, `product.featureSet`.`updated_at` as `product.featureSet.updatedAt`, `product.featureSet.translation.name`, `product.featureSet.translation.name` as `product.featureSet.name`, `product.featureSet.translation.description`, `product.featureSet.translation.description` as `product.featureSet.description`, (SELECT GROUP_CONCAT(HEX(`product.properties.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_property` `product.properties.mapping`
                  WHERE `product.properties.mapping`.`product_id` = `product`.`properties` ) as `product.properties.id_mapping`, `product.unit`.`id` as `product.unit.id`, `product.unit`.`created_at` as `product.unit.createdAt`, `product.unit`.`updated_at` as `product.unit.updatedAt`, `product.unit.translation.shortCode`, `product.unit.translation.shortCode` as `product.unit.shortCode`, `product.unit.translation.name`, `product.unit.translation.name` as `product.unit.name`, `product.unit.translation.customFields`, `product.unit.translation.customFields` as `product.unit.customFields`, `product.deliveryTime`.`id` as `product.deliveryTime.id`, `product.deliveryTime`.`min` as `product.deliveryTime.min`, `product.deliveryTime`.`max` as `product.deliveryTime.max`, `product.deliveryTime`.`unit` as `product.deliveryTime.unit`, `product.deliveryTime`.`created_at` as `product.deliveryTime.createdAt`, `product.deliveryTime`.`updated_at` as `product.deliveryTime.updatedAt`, `product.deliveryTime.translation.name`, `product.deliveryTime.translation.name` as `product.deliveryTime.name`, `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation.customFields` as `product.deliveryTime.customFields`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN `product_feature_set` `product.featureSet` ON `product`.`featureSet` = `product.featureSet`.`id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`meta_description` as `product.translation.metaDescription`, `product.translation`.`name` as `product.translation.name`, `product.translation`.`keywords` as `product.translation.keywords`, `product.translation`.`description` as `product.translation.description`, `product.translation`.`meta_title` as `product.translation.metaTitle`, `product.translation`.`pack_unit` as `product.translation.packUnit`, `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`, `product.translation`.`custom_fields` as `product.translation.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`meta_description` as `product.parent.translation.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.cover.media.translation`.`media_id`, `product.cover.media.translation`.`alt` as `product.cover.media.translation.alt`, `product.cover.media.translation`.`title` as `product.cover.media.translation.title`, `product.cover.media.translation`.`custom_fields` as `product.cover.media.translation.customFields` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation`.`language_id` = ?) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.featureSet.translation`.`product_feature_set_id`, `product.featureSet.translation`.`name` as `product.featureSet.translation.name`, `product.featureSet.translation`.`description` as `product.featureSet.translation.description` FROM `product_feature_set_translation` `product.featureSet.translation` WHERE `product.featureSet.translation`.`language_id` = ?) `product.featureSet.product_feature_set_translation` ON `product.featureSet.product_feature_set_translation`.`product_feature_set_id` = `product.featureSet`.`id` LEFT JOIN (SELECT `product.unit.translation`.`unit_id`, `product.unit.translation`.`short_code` as `product.unit.translation.shortCode`, `product.unit.translation`.`name` as `product.unit.translation.name`, `product.unit.translation`.`custom_fields` as `product.unit.translation.customFields` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation`.`language_id` = ?) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id` LEFT JOIN (SELECT `product.deliveryTime.translation`.`delivery_time_id`, `product.deliveryTime.translation`.`name` as `product.deliveryTime.translation.name`, `product.deliveryTime.translation`.`custom_fields` as `product.deliveryTime.translation.customFields` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation`.`language_id` = ?) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"®\x00½y§DGäƒ2ª\x06Ú1\x07;"
]
39 0.36 ms
# cart::products::association::options::read
SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group.translation.name`, `property_group_option.group.translation.name` as `property_group_option.group.name`, `property_group_option.group.translation.description`, `property_group_option.group.translation.description` as `property_group_option.group.description`, `property_group_option.group.translation.position`, `property_group_option.group.translation.position` as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, `property_group_option.group.translation.customFields` as `property_group_option.group.customFields`, `property_group_option.translation.name`, `property_group_option.translation.name` as `property_group_option.name`, `property_group_option.translation.position`, `property_group_option.translation.position` as `property_group_option.position`, `property_group_option.translation.customFields`, `property_group_option.translation.customFields` as `property_group_option.customFields` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.translation`.`property_group_option_id`, `property_group_option.translation`.`name` as `property_group_option.translation.name`, `property_group_option.translation`.`position` as `property_group_option.translation.position`, `property_group_option.translation`.`custom_fields` as `property_group_option.translation.customFields` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.`language_id` = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN (SELECT `property_group_option.group.translation`.`property_group_id`, `property_group_option.group.translation`.`name` as `property_group_option.group.translation.name`, `property_group_option.group.translation`.`description` as `property_group_option.group.translation.description`, `property_group_option.group.translation`.`position` as `property_group_option.group.translation.position`, `property_group_option.group.translation`.`custom_fields` as `property_group_option.group.translation.customFields` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.`language_id` = ?) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` WHERE `property_group_option`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x10Šè\x05õÝB逸Iƒ\x0E'jN"
]
40 0.42 ms
# cart::products::association::properties::read
SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group.translation.name`, `property_group_option.group.translation.name` as `property_group_option.group.name`, `property_group_option.group.translation.description`, `property_group_option.group.translation.description` as `property_group_option.group.description`, `property_group_option.group.translation.position`, `property_group_option.group.translation.position` as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, `property_group_option.group.translation.customFields` as `property_group_option.group.customFields`, `property_group_option.translation.name`, `property_group_option.translation.name` as `property_group_option.name`, `property_group_option.translation.position`, `property_group_option.translation.position` as `property_group_option.position`, `property_group_option.translation.customFields`, `property_group_option.translation.customFields` as `property_group_option.customFields` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.translation`.`property_group_option_id`, `property_group_option.translation`.`name` as `property_group_option.translation.name`, `property_group_option.translation`.`position` as `property_group_option.translation.position`, `property_group_option.translation`.`custom_fields` as `property_group_option.translation.customFields` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.`language_id` = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN (SELECT `property_group_option.group.translation`.`property_group_id`, `property_group_option.group.translation`.`name` as `property_group_option.group.translation.name`, `property_group_option.group.translation`.`description` as `property_group_option.group.translation.description`, `property_group_option.group.translation`.`position` as `property_group_option.group.translation.position`, `property_group_option.group.translation`.`custom_fields` as `property_group_option.group.translation.customFields` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.`language_id` = ?) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` WHERE `property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x02—ì\x11J*K—€âuýüóJb"
  b"\x10Šè\x05õÝB逸Iƒ\x0E'jN"
  b"ll\x138Žü@™’‘\tœ´æ\x18§"
  b"|¦IrüòNÓç\x15e0\x13©╝\x00"
  b"}÷Å}¨╗O=¬½ôfô>f×"
  b"Š˜¥ÄwdL9½2M"1ddÊ"
  b"×SØJPiF\x05£╗┼n²f7\x10"
  b"à·–‰¿ÿGô§\x14&…V_Ö¼"
  b"ð]£åSúNs·ŠŸÑW\x03¡j"
  b"ú\x08´þ¤jCwœ"T7Îi§n"
]
41 0.20 ms
# cart::products::association::prices::read
SELECT `product_price`.`id` as `product_price.id`, `product_price`.`version_id` as `product_price.versionId`, `product_price`.`product_id` as `product_price.productId`, `product_price`.`product_version_id` as `product_price.productVersionId`, `product_price`.`rule_id` as `product_price.ruleId`, `product_price`.`price` as `product_price.price`, `product_price`.`quantity_start` as `product_price.quantityStart`, `product_price`.`quantity_end` as `product_price.quantityEnd`, `product_price`.`custom_fields` as `product_price.customFields`, `product_price`.`created_at` as `product_price.createdAt`, `product_price`.`updated_at` as `product_price.updatedAt` FROM `product_price` WHERE (`product_price`.`version_id` = ?) AND ((`product_price`.`product_id` IN (?, ?)))
Parameters:
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"®\x00½y§DGäƒ2ª\x06Ú1\x07;"
  b"¨#b´\x19$GÖ»Øgµ▀╣┬Ý"
]
42 1.17 ms
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id = ? OR system_config.sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
]
43 0.24 ms
# product-price-calculator::units::read
SELECT `unit`.`id` as `unit.id`, `unit`.`created_at` as `unit.createdAt`, `unit`.`updated_at` as `unit.updatedAt`, `unit.translation.shortCode`, `unit.translation.shortCode` as `unit.shortCode`, `unit.translation.name`, `unit.translation.name` as `unit.name`, `unit.translation.customFields`, `unit.translation.customFields` as `unit.customFields` FROM `unit` LEFT JOIN (SELECT `unit.translation`.`unit_id`, `unit.translation`.`short_code` as `unit.translation.shortCode`, `unit.translation`.`name` as `unit.translation.name`, `unit.translation`.`custom_fields` as `unit.translation.customFields` FROM `unit_translation` `unit.translation` WHERE `unit.translation`.`language_id` = ?) `unit.unit_translation` ON `unit.unit_translation`.`unit_id` = `unit`.`id`
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
44 0.12 ms
# app-scripts::refresh::search-ids
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ?)
Parameters:
[
  true
]
45 0.37 ms
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`checkout_gateway_url` as `app.checkoutGatewayUrl`, `app`.`in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl`, `app`.`source_type` as `app.sourceType`, `app`.`source_config` as `app.sourceConfig`, `app`.`self_managed` as `app.selfManaged`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, `app.translation.label` as `app.label`, `app.translation.description`, `app.translation.description` as `app.description`, `app.translation.privacyPolicyExtensions`, `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`, `app.translation.customFields`, `app.translation.customFields` as `app.customFields` FROM `app` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` LEFT JOIN (SELECT `app.translation`.`app_id`, `app.translation`.`label` as `app.translation.label`, `app.translation`.`description` as `app.translation.description`, `app.translation`.`privacy_policy_extensions` as `app.translation.privacyPolicyExtensions`, `app.translation`.`custom_fields` as `app.translation.customFields` FROM `app_translation` `app.translation` WHERE `app.translation`.`language_id` = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` WHERE `app`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01‰vç¸=q‡ ‡†¬\•\x03X"
]
46 0.14 ms
SELECT `script`.`id` as `script.id`, `script`.`script` as `script.script`, `script`.`hook` as `script.hook`, `script`.`name` as `script.name`, `script`.`active` as `script.active`, `script`.`app_id` as `script.appId`, `script`.`created_at` as `script.createdAt`, `script`.`updated_at` as `script.updatedAt` FROM `script` WHERE (`script`.`app_id` IN (?))
Parameters:
[
  b"\x01‰vç¸=q‡ ‡†¬\•\x03X"
]
47 0.35 ms
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`checkout_gateway_url` as `app.checkoutGatewayUrl`, `app`.`in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl`, `app`.`source_type` as `app.sourceType`, `app`.`source_config` as `app.sourceConfig`, `app`.`self_managed` as `app.selfManaged`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, `app.translation.label` as `app.label`, `app.translation.description`, `app.translation.description` as `app.description`, `app.translation.privacyPolicyExtensions`, `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`, `app.translation.customFields`, `app.translation.customFields` as `app.customFields` FROM `app` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` LEFT JOIN (SELECT `app.translation`.`app_id`, `app.translation`.`label` as `app.translation.label`, `app.translation`.`description` as `app.translation.description`, `app.translation`.`privacy_policy_extensions` as `app.translation.privacyPolicyExtensions`, `app.translation`.`custom_fields` as `app.translation.customFields` FROM `app_translation` `app.translation` WHERE `app.translation`.`language_id` = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` WHERE `app`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01“³‘âÈrC¿'À ªrÆ“"
]
48 0.13 ms
SELECT `script`.`id` as `script.id`, `script`.`script` as `script.script`, `script`.`hook` as `script.hook`, `script`.`name` as `script.name`, `script`.`active` as `script.active`, `script`.`app_id` as `script.appId`, `script`.`created_at` as `script.createdAt`, `script`.`updated_at` as `script.updatedAt` FROM `script` WHERE (`script`.`app_id` IN (?))
Parameters:
[
  b"\x01“³‘âÈrC¿'À ªrÆ“"
]
49 0.45 ms
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters:
[]
50 0.34 ms
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters:
[]
51 0.20 ms
SELECT DISTINCT LOWER(HEX(psm.product_id)) as productId, LOWER(HEX(psm.product_stream_id)) as productStreamId, LOWER(HEX(lolicg.id)) as lenzOrderLineItemCommentGroupId FROM product_stream_mapping psm INNER JOIN lenz_order_line_item_comment_group lolicg ON lolicg.product_stream_id = psm.product_stream_id AND lolicg.mode = ? WHERE product_id IN (?) GROUP BY productId
Parameters:
[
  "product_stream"
  b"®\x00½y§DGäƒ2ª\x06Ú1\x07;"
]
52 0.92 ms
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, (SELECT GROUP_CONCAT(HEX(`product.lenzOrderLineItemCommentGroups.mapping`.`order_line_item_group_id`) SEPARATOR '||')
                  FROM `lenz_order_line_item_comment_group_product` `product.lenzOrderLineItemCommentGroups.mapping`
                  WHERE `product.lenzOrderLineItemCommentGroups.mapping`.`product_id` = `product`.`lenzOrderLineItemCommentGroups` ) as `product.lenzOrderLineItemCommentGroups.id_mapping`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`meta_description` as `product.translation.metaDescription`, `product.translation`.`name` as `product.translation.name`, `product.translation`.`keywords` as `product.translation.keywords`, `product.translation`.`description` as `product.translation.description`, `product.translation`.`meta_title` as `product.translation.metaTitle`, `product.translation`.`pack_unit` as `product.translation.packUnit`, `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`, `product.translation`.`custom_fields` as `product.translation.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`meta_description` as `product.parent.translation.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"®\x00½y§DGäƒ2ª\x06Ú1\x07;"
]
53 0.14 ms
SELECT `lenz_order_line_item_comment_group`.`id` FROM `lenz_order_line_item_comment_group` WHERE ((`lenz_order_line_item_comment_group`.`mode` = ? OR (`lenz_order_line_item_comment_group`.`mode` = ? AND `lenz_order_line_item_comment_group`.`product_stream_id` IN (NULL)))) ORDER BY `lenz_order_line_item_comment_group`.`position` ASC
Parameters:
[
  "all"
  "product_stream"
]
54 0.28 ms
SELECT `lenz_order_line_item_comment_group`.`id` as `lenz_order_line_item_comment_group.id`, `lenz_order_line_item_comment_group`.`position` as `lenz_order_line_item_comment_group.position`, `lenz_order_line_item_comment_group`.`mode` as `lenz_order_line_item_comment_group.mode`, `lenz_order_line_item_comment_group`.`type` as `lenz_order_line_item_comment_group.type`, `lenz_order_line_item_comment_group`.`product_stream_id` as `lenz_order_line_item_comment_group.productStreamId`, `lenz_order_line_item_comment_group`.`created_at` as `lenz_order_line_item_comment_group.createdAt`, `lenz_order_line_item_comment_group`.`updated_at` as `lenz_order_line_item_comment_group.updatedAt`, (SELECT GROUP_CONCAT(HEX(`lenz_order_line_item_comment_group.salesChannels.mapping`.`sales_channel_id`) SEPARATOR '||')
                  FROM `lenz_order_line_item_comment_group_sales_channel` `lenz_order_line_item_comment_group.salesChannels.mapping`
                  WHERE `lenz_order_line_item_comment_group.salesChannels.mapping`.`order_line_item_group_id` = `lenz_order_line_item_comment_group`.`id` ) as `lenz_order_line_item_comment_group.salesChannels.id_mapping`, `lenz_order_line_item_comment_group.translation.name`, `lenz_order_line_item_comment_group.translation.name` as `lenz_order_line_item_comment_group.name`, `lenz_order_line_item_comment_group.translation.description`, `lenz_order_line_item_comment_group.translation.description` as `lenz_order_line_item_comment_group.description` FROM `lenz_order_line_item_comment_group` LEFT JOIN (SELECT `lenz_order_line_item_comment_group.translation`.`lenz_order_line_item_comment_group_id`, `lenz_order_line_item_comment_group.translation`.`name` as `lenz_order_line_item_comment_group.translation.name`, `lenz_order_line_item_comment_group.translation`.`description` as `lenz_order_line_item_comment_group.translation.description` FROM `lenz_order_line_item_comment_group_translation` `lenz_order_line_item_comment_group.translation` WHERE `lenz_order_line_item_comment_group.translation`.`language_id` = ?) `lenz_order_line_item_comment_group.lenz_order_line_item_comment_group_translation` ON `lenz_order_line_item_comment_group.lenz_order_line_item_comment_group_translation`.`lenz_order_line_item_comment_group_id` = `lenz_order_line_item_comment_group`.`id` WHERE `lenz_order_line_item_comment_group`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"æ±ÄW¾\x1FEm¿mk¤\fŽÂ¡"
]
55 0.28 ms
SELECT `lenz_order_line_item_comment_field`.`id` as `lenz_order_line_item_comment_field.id`, `lenz_order_line_item_comment_field`.`type` as `lenz_order_line_item_comment_field.type`, `lenz_order_line_item_comment_field`.`pattern` as `lenz_order_line_item_comment_field.pattern`, `lenz_order_line_item_comment_field`.`step` as `lenz_order_line_item_comment_field.step`, `lenz_order_line_item_comment_field`.`position` as `lenz_order_line_item_comment_field.position`, `lenz_order_line_item_comment_field`.`min_length` as `lenz_order_line_item_comment_field.minLength`, `lenz_order_line_item_comment_field`.`max_length` as `lenz_order_line_item_comment_field.maxLength`, `lenz_order_line_item_comment_field`.`required` as `lenz_order_line_item_comment_field.required`, `lenz_order_line_item_comment_field`.`configurator_price` as `lenz_order_line_item_comment_field.configuratorPrice`, `lenz_order_line_item_comment_field`.`configurator_product_number` as `lenz_order_line_item_comment_field.configuratorProductNumber`, `lenz_order_line_item_comment_field`.`line_item_comment_group_id` as `lenz_order_line_item_comment_field.lineItemCommentGroupId`, `lenz_order_line_item_comment_field`.`created_at` as `lenz_order_line_item_comment_field.createdAt`, `lenz_order_line_item_comment_field`.`updated_at` as `lenz_order_line_item_comment_field.updatedAt`, `lenz_order_line_item_comment_field.translation.name`, `lenz_order_line_item_comment_field.translation.name` as `lenz_order_line_item_comment_field.name`, `lenz_order_line_item_comment_field.translation.placeholder`, `lenz_order_line_item_comment_field.translation.placeholder` as `lenz_order_line_item_comment_field.placeholder`, `lenz_order_line_item_comment_field.translation.description`, `lenz_order_line_item_comment_field.translation.description` as `lenz_order_line_item_comment_field.description` FROM `lenz_order_line_item_comment_field` LEFT JOIN (SELECT `lenz_order_line_item_comment_field.translation`.`lenz_order_line_item_comment_field_id`, `lenz_order_line_item_comment_field.translation`.`name` as `lenz_order_line_item_comment_field.translation.name`, `lenz_order_line_item_comment_field.translation`.`placeholder` as `lenz_order_line_item_comment_field.translation.placeholder`, `lenz_order_line_item_comment_field.translation`.`description` as `lenz_order_line_item_comment_field.translation.description` FROM `lenz_order_line_item_comment_field_translation` `lenz_order_line_item_comment_field.translation` WHERE `lenz_order_line_item_comment_field.translation`.`language_id` = ?) `lenz_order_line_item_comment_field.lenz_order_line_item_comment_field_translation` ON `lenz_order_line_item_comment_field.lenz_order_line_item_comment_field_translation`.`lenz_order_line_item_comment_field_id` = `lenz_order_line_item_comment_field`.`id` WHERE (`lenz_order_line_item_comment_field`.`line_item_comment_group_id` IN (?)) ORDER BY `lenz_order_line_item_comment_field`.`position` ASC
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"æ±ÄW¾\x1FEm¿mk¤\fŽÂ¡"
]
56 0.24 ms
SELECT `lenz_order_line_item_comment_field_option`.`id` as `lenz_order_line_item_comment_field_option.id`, `lenz_order_line_item_comment_field_option`.`position` as `lenz_order_line_item_comment_field_option.position`, `lenz_order_line_item_comment_field_option`.`value` as `lenz_order_line_item_comment_field_option.value`, `lenz_order_line_item_comment_field_option`.`configurator_price` as `lenz_order_line_item_comment_field_option.configuratorPrice`, `lenz_order_line_item_comment_field_option`.`configurator_product_number` as `lenz_order_line_item_comment_field_option.configuratorProductNumber`, `lenz_order_line_item_comment_field_option`.`field_id` as `lenz_order_line_item_comment_field_option.fieldId`, `lenz_order_line_item_comment_field_option`.`created_at` as `lenz_order_line_item_comment_field_option.createdAt`, `lenz_order_line_item_comment_field_option`.`updated_at` as `lenz_order_line_item_comment_field_option.updatedAt`, `lenz_order_line_item_comment_field_option.translation.label`, `lenz_order_line_item_comment_field_option.translation.label` as `lenz_order_line_item_comment_field_option.label` FROM `lenz_order_line_item_comment_field_option` LEFT JOIN (SELECT `lenz_order_line_item_comment_field_option.translation`.`lenz_order_line_item_comment_field_option_id`, `lenz_order_line_item_comment_field_option.translation`.`label` as `lenz_order_line_item_comment_field_option.translation.label` FROM `lenz_order_line_item_comment_field_option_translation` `lenz_order_line_item_comment_field_option.translation` WHERE `lenz_order_line_item_comment_field_option.translation`.`language_id` = ?) `lenz_order_line_item_comment_field_option.lenz_order_line_item_comment_field_option_translation` ON `lenz_order_line_item_comment_field_option.lenz_order_line_item_comment_field_option_translation`.`lenz_order_line_item_comment_field_option_id` = `lenz_order_line_item_comment_field_option`.`id` WHERE (`lenz_order_line_item_comment_field_option`.`field_id` IN (?)) ORDER BY `lenz_order_line_item_comment_field_option`.`position` ASC
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"¶]:ô‗HFÀºÉÆ¥}\x1A\x1CÉ"
]
57 0.38 ms
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.translation.name`, `sales_channel.translation.name` as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, `sales_channel.translation.homeName` as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, `sales_channel.translation.customFields` as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.`sales_channel_id`, `sales_channel.translation`.`name` as `sales_channel.translation.name`, `sales_channel.translation`.`custom_fields` as `sales_channel.translation.customFields`, `sales_channel.translation`.`home_slot_config` as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.`home_enabled` as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.`home_name` as `sales_channel.translation.homeName`, `sales_channel.translation`.`home_meta_title` as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.`home_meta_description` as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.`home_keywords` as `sales_channel.translation.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.`language_id` = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` WHERE `sales_channel`.`id` IN (?, ?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  b"ɦõ¿\t‚D±±&xÃjí,Q"
]
58 0.76 ms
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`meta_description` as `product.translation.metaDescription`, `product.translation`.`name` as `product.translation.name`, `product.translation`.`keywords` as `product.translation.keywords`, `product.translation`.`description` as `product.translation.description`, `product.translation`.`meta_title` as `product.translation.metaTitle`, `product.translation`.`pack_unit` as `product.translation.packUnit`, `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`, `product.translation`.`custom_fields` as `product.translation.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`meta_description` as `product.parent.translation.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND ((`product`.`id` = ?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"¨#b´\x19$GÖ»Øgµ▀╣┬Ý"
]
59 0.15 ms
SELECT `handler_identifier`, LOWER(HEX(`id`)) FROM `payment_method`
Parameters:
[]
60 0.13 ms
SELECT LOWER(HEX(assoc.`sales_channel_id`))
                FROM `sales_channel_payment_method` AS assoc
                    LEFT JOIN `payment_method` AS pm
                        ON pm.`id` = assoc.`payment_method_id`
                WHERE
                    assoc.`payment_method_id` = ? AND
                    pm.`active` = 1
Parameters:
[
  b"î╦·:\x170NÛÉðØÂ■gÝ="
]
61 0.30 ms
# cart::promotion::search-ids
SELECT `promotion`.`id` FROM `promotion` LEFT JOIN `promotion_sales_channel` `promotion.salesChannels` ON `promotion`.`id` = `promotion.salesChannels`.`promotion_id` WHERE ((`promotion`.`active` = ? AND `promotion.salesChannels`.`sales_channel_id` = ? AND ((`promotion`.`valid_from` <=> ? AND `promotion`.`valid_until` <=> ?) OR (`promotion`.`valid_from` <=> ? AND (`promotion`.`valid_until` > ?)) OR ((`promotion`.`valid_from` <= ?) AND `promotion`.`valid_until` <=> ?) OR ((`promotion`.`valid_from` <= ?) AND (`promotion`.`valid_until` > ?))) AND `promotion`.`use_codes` = ?)) GROUP BY `promotion`.`id` ORDER BY MAX(`promotion`.`priority`) DESC
Parameters:
[
  true
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  null
  null
  null
  "2024-12-23 19:29:43"
  "2024-12-23 19:29:43"
  null
  "2024-12-23 19:29:43"
  "2024-12-23 19:29:43"
  false
]
62 0.45 ms
# cart::shipping-methods::read
SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`active` as `shipping_method.active`, `shipping_method`.`position` as `shipping_method.position`, `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` as `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` as `shipping_method.taxType`, `shipping_method`.`tax_id` as `shipping_method.taxId`, `shipping_method.deliveryTime`.`id` as `shipping_method.deliveryTime.id`, `shipping_method.deliveryTime`.`min` as `shipping_method.deliveryTime.min`, `shipping_method.deliveryTime`.`max` as `shipping_method.deliveryTime.max`, `shipping_method.deliveryTime`.`unit` as `shipping_method.deliveryTime.unit`, `shipping_method.deliveryTime`.`created_at` as `shipping_method.deliveryTime.createdAt`, `shipping_method.deliveryTime`.`updated_at` as `shipping_method.deliveryTime.updatedAt`, `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation.name` as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation.customFields` as `shipping_method.deliveryTime.customFields`, `shipping_method.appShippingMethod`.`id` as `shipping_method.appShippingMethod.id`, `shipping_method.appShippingMethod`.`app_name` as `shipping_method.appShippingMethod.appName`, `shipping_method.appShippingMethod`.`identifier` as `shipping_method.appShippingMethod.identifier`, `shipping_method.appShippingMethod`.`app_id` as `shipping_method.appShippingMethod.appId`, `shipping_method.appShippingMethod`.`shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId`, `shipping_method.appShippingMethod`.`original_media_id` as `shipping_method.appShippingMethod.originalMediaId`, `shipping_method.appShippingMethod`.`created_at` as `shipping_method.appShippingMethod.createdAt`, `shipping_method.appShippingMethod`.`updated_at` as `shipping_method.appShippingMethod.updatedAt`, `shipping_method`.`technical_name` as `shipping_method.technicalName`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.tax`.`id` as `shipping_method.tax.id`, `shipping_method.tax`.`tax_rate` as `shipping_method.tax.taxRate`, `shipping_method.tax`.`name` as `shipping_method.tax.name`, `shipping_method.tax`.`position` as `shipping_method.tax.position`, `shipping_method.tax`.`custom_fields` as `shipping_method.tax.customFields`, `shipping_method.tax`.`created_at` as `shipping_method.tax.createdAt`, `shipping_method.tax`.`updated_at` as `shipping_method.tax.updatedAt`, `shipping_method.translation.name`, `shipping_method.translation.name` as `shipping_method.name`, `shipping_method.translation.description`, `shipping_method.translation.description` as `shipping_method.description`, `shipping_method.translation.trackingUrl`, `shipping_method.translation.trackingUrl` as `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, `shipping_method.translation.customFields` as `shipping_method.customFields` FROM `shipping_method` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method`.`id` = `shipping_method.appShippingMethod`.`shipping_method_id` LEFT JOIN `tax` `shipping_method.tax` ON `shipping_method`.`tax_id` = `shipping_method.tax`.`id` LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name`, `shipping_method.translation`.`custom_fields` as `shipping_method.translation.customFields`, `shipping_method.translation`.`description` as `shipping_method.translation.description`, `shipping_method.translation`.`tracking_url` as `shipping_method.translation.trackingUrl` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation`.`delivery_time_id`, `shipping_method.deliveryTime.translation`.`name` as `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation`.`custom_fields` as `shipping_method.deliveryTime.translation.customFields` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation`.`language_id` = ?) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` WHERE `shipping_method`.`id` IN (?, ?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"L8>;;aLÀ°)´$¾ÌYM"
  b"L8>;;aLÀ°)´$¾ÌYM"
]
63 0.17 ms
# cart::shipping-methods::association::prices::read
SELECT `shipping_method_price`.`id` as `shipping_method_price.id`, `shipping_method_price`.`shipping_method_id` as `shipping_method_price.shippingMethodId`, `shipping_method_price`.`rule_id` as `shipping_method_price.ruleId`, `shipping_method_price`.`calculation` as `shipping_method_price.calculation`, `shipping_method_price`.`calculation_rule_id` as `shipping_method_price.calculationRuleId`, `shipping_method_price`.`quantity_start` as `shipping_method_price.quantityStart`, `shipping_method_price`.`quantity_end` as `shipping_method_price.quantityEnd`, `shipping_method_price`.`currency_price` as `shipping_method_price.currencyPrice`, `shipping_method_price`.`custom_fields` as `shipping_method_price.customFields`, `shipping_method_price`.`created_at` as `shipping_method_price.createdAt`, `shipping_method_price`.`updated_at` as `shipping_method_price.updatedAt` FROM `shipping_method_price` WHERE (`shipping_method_price`.`shipping_method_id` IN (?))
Parameters:
[
  b"L8>;;aLÀ°)´$¾ÌYM"
]
64 0.26 ms
SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, parentLocale.code AS parentCode, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id LEFT JOIN language parentLanguage ON language.parent_id = parentLanguage.id LEFT JOIN locale parentLocale ON parentLanguage.translation_code_id = parentLocale.id
Parameters:
[]
65 0.14 ms
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
  "de-DE"
]
66 0.09 ms
SELECT iso FROM snippet_set WHERE id = ?
Parameters:
[
  b"‚?•(…iK~…OÕ‰_'o8"
]
67 0.15 ms
SELECT LOWER(HEX(theme.id)) themeId, theme.technical_name as themeName, parentTheme.technical_name as parentThemeName, LOWER(HEX(parentTheme.parent_theme_id)) as grandParentThemeId
            FROM sales_channel
                LEFT JOIN theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id
                LEFT JOIN theme ON theme_sales_channel.theme_id = theme.id
                LEFT JOIN theme AS parentTheme ON parentTheme.id = theme.parent_theme_id
            WHERE sales_channel.id = ?
Parameters:
[
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
]
68 0.46 ms
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`checkout_gateway_url` as `app.checkoutGatewayUrl`, `app`.`in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl`, `app`.`source_type` as `app.sourceType`, `app`.`source_config` as `app.sourceConfig`, `app`.`self_managed` as `app.selfManaged`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, `app.translation.label` as `app.label`, `app.translation.description`, `app.translation.description` as `app.description`, `app.translation.privacyPolicyExtensions`, `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`, `app.translation.customFields`, `app.translation.customFields` as `app.customFields` FROM `app` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` LEFT JOIN (SELECT `app.translation`.`app_id`, `app.translation`.`label` as `app.translation.label`, `app.translation`.`description` as `app.translation.description`, `app.translation`.`privacy_policy_extensions` as `app.translation.privacyPolicyExtensions`, `app.translation`.`custom_fields` as `app.translation.customFields` FROM `app_translation` `app.translation` WHERE `app.translation`.`language_id` = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` WHERE (`app`.`name` = ?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  "TonurPackstationApp"
]
69 0.35 ms
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`checkout_gateway_url` as `app.checkoutGatewayUrl`, `app`.`in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl`, `app`.`source_type` as `app.sourceType`, `app`.`source_config` as `app.sourceConfig`, `app`.`self_managed` as `app.selfManaged`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, `app.translation.label` as `app.label`, `app.translation.description`, `app.translation.description` as `app.description`, `app.translation.privacyPolicyExtensions`, `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`, `app.translation.customFields`, `app.translation.customFields` as `app.customFields` FROM `app` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` LEFT JOIN (SELECT `app.translation`.`app_id`, `app.translation`.`label` as `app.translation.label`, `app.translation`.`description` as `app.translation.description`, `app.translation`.`privacy_policy_extensions` as `app.translation.privacyPolicyExtensions`, `app.translation`.`custom_fields` as `app.translation.customFields` FROM `app_translation` `app.translation` WHERE `app.translation`.`language_id` = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` WHERE (`app`.`name` = ?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  "SwagInsiderPreviews"
]
70 0.15 ms
SELECT `base_class` AS `baseClass`, `author`
                FROM `plugin`
Parameters:
[]
71 0.38 ms
SELECT translation_key, value FROM snippet WHERE snippet_set_id = ?
Parameters:
[
  b"‚?•(…iK~…OÕ‰_'o8"
]
72 0.15 ms
SELECT `sales_channel_country`.`sales_channel_id`, `sales_channel_country`.`country_id` FROM `sales_channel_country` WHERE (`sales_channel_country`.`sales_channel_id` = ? AND `sales_channel_country`.`country_id` = ?)
Parameters:
[
  b"Éy{\x19bKC9«±€k¼ÃVÄ"
  b"=Í¿PnVGÖ±è€\rŒ¬\r{"
]
73 0.13 ms
SELECT `name` FROM `custom_field` WHERE `allow_cart_expose` = 1;
Parameters:
[]
74 5.91 ms
INSERT INTO `cart` (`token`, `payload`, `rule_ids`, `compressed`, `created_at`)
    VALUES (:token, :payload, :rule_ids, :compressed, :now)
    ON DUPLICATE KEY UPDATE `payload` = :payload, `compressed` = :compressed, `rule_ids` = :rule_ids, `created_at` = :now;
Parameters:
[
  "token" => "ltQoKGxpTGEgp2YH6HBuBxKQab5FV6eq"
  "payload" => "O:32:"Shopware\Core\Checkout\Cart\Cart":18:{s:13:"\x00*\x00extensions";a:1:{s:15:"cart-promotions";O:61:"Shopware\Core\Checkout\Promotion\Cart\Extension\CartExtension":3:{s:13:"\x00*\x00extensions";a:0:{}s:13:"\x00*\x00addedCodes";a:0:{}s:22:"\x00*\x00blockedPromotionIds";a:0:{}}}s:8:"\x00*\x00price";O:50:"Shopware\Core\Checkout\Cart\Price\Struct\CartPrice":8:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00netPrice";d:108.4;s:13:"\x00*\x00totalPrice";d:129;s:18:"\x00*\x00calculatedTaxes";O:62:"Shopware\Core\Checkout\Cart\Tax\Struct\CalculatedTaxCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{i:19;O:52:"Shopware\Core\Checkout\Cart\Tax\Struct\CalculatedTax":4:{s:13:"\x00*\x00extensions";a:0:{}s:6:"\x00*\x00tax";d:20.6;s:10:"\x00*\x00taxRate";d:19;s:8:"\x00*\x00price";d:129;}}}s:11:"\x00*\x00taxRules";O:56:"Shopware\Core\Checkout\Cart\Tax\Struct\TaxRuleCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{i:19;O:46:"Shopware\Core\Checkout\Cart\Tax\Struct\TaxRule":3:{s:13:"\x00*\x00extensions";a:0:{}s:10:"\x00*\x00taxRate";d:19;s:13:"\x00*\x00percentage";d:100;}}}s:16:"\x00*\x00positionPrice";d:129;s:12:"\x00*\x00taxStatus";s:5:"gross";s:11:"\x00*\x00rawTotal";d:129;}s:12:"\x00*\x00lineItems";O:55:"Shopware\Core\Checkout\Cart\LineItem\LineItemCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{s:32:"0193f4fb55987389b362b86a008041c6";O:45:"Shopware\Core\Checkout\Cart\LineItem\LineItem":26:{s:13:"\x00*\x00extensions";a:1:{s:28:"lenz-order-line-item-comment";O:42:"Shopware\Core\Framework\Struct\ArrayEntity":10:{s:13:"\x00*\x00extensions";a:0:{}s:20:"\x00*\x00_uniqueIdentifier";N;s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:0:{}s:12:"\x00*\x00createdAt";N;s:12:"\x00*\x00updatedAt";N;s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";N;s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";N;s:14:"\x00*\x00_entityName";s:12:"array-entity";s:7:"\x00*\x00data";a:0:{}}}s:10:"\x00*\x00payload";a:19:{s:10:"isCloseout";b:0;s:12:"customFields";a:0:{}s:9:"createdAt";s:23:"2022-09-21 16:23:27.036";s:11:"releaseDate";N;s:5:"isNew";b:0;s:15:"markAsTopseller";N;s:14:"purchasePrices";s:155:"{"extensions":[],"currencyId":"b7d2554b0ce847cd82f3ac9bd1c0dfca","net":0,"gross":0,"linked":true,"listPrice":null,"percentage":null,"regulationPrice":null}";s:13:"productNumber";s:7:"R722.54";s:14:"manufacturerId";s:32:"7bf787ab99cf4d339d86798f75444d32";s:5:"taxId";s:32:"72943b70739c48999afd49b2b740c723";s:6:"tagIds";N;s:11:"categoryIds";a:33:{i:0;s:32:"bfe523fe77ae41b4b4ffeba070794032";i:1;s:32:"019348ece72e726bb3fa9e1c0d986e07";i:2;s:32:"1907e9e73a6140d48c10e82b8986f46a";i:3;s:32:"42da0fb4a6b94513b7324449d2f8d38e";i:4;s:32:"ba7ed83336394da8930566d49b4de149";i:5;s:32:"dd136371ff8a415dbf93d6b67d755154";i:6;s:32:"fcf59ed5613142729c2fd6768e07a08b";i:7;s:32:"118f588ee1ca4166b28245ef6b365994";i:8;s:32:"43649894d5014f2f8bdb57bc51b85d17";i:9;s:32:"c1d9a37345a042938c0b318c1b1c7603";i:10;s:32:"1f2a1232cddd49dfa559b8bd24df44f8";i:11;s:32:"05c8c55fe903479a87662295a58c4ead";i:12;s:32:"595443089bf944398b8568193c218803";i:13;s:32:"8e1bba960e8c4be2ad164acc9fb07a13";i:14;s:32:"fa3e69fe19e94cc89f113f0aff04a505";i:15;s:32:"d5c1e7cd6ad440aa91122cb57eaeb69e";i:16;s:32:"49ae35f71f794a149ba089f5d4466713";i:17;s:32:"1cceb80a0b3e45399e90094933e08d72";i:18;s:32:"31929c4aca794860a2b9492cfb1cdf06";i:19;s:32:"1dd286b3438c4faca2b7e2b494b36b75";i:20;s:32:"0193490b4bf671158b78c02cca40097d";i:21;s:32:"048c04a37c044b458c4b53e1639ac684";i:22;s:32:"1d4688f3b37646b68623248e645ed963";i:23;s:32:"3005ecc96fd5419dbbd41975c91f06b6";i:24;s:32:"537fd57254854488a70bf045a1ff7c46";i:25;s:32:"563faaf412d640aba6cdd6617c797ed6";i:26;s:32:"62e12dca076d486f89b69989712d82c7";i:27;s:32:"8c2332b671474fc8b2e13e44c0f0190a";i:28;s:32:"b6d5f38073bf4228a0d8bea55380b993";i:29;s:32:"b7d1509d27634c86ba2e8e464d3c9ecc";i:30;s:32:"d6bcff8f4f2641c8839f610f30a3048a";i:31;s:32:"e47d435eea744852a1a539dc21a67bc2";i:32;s:32:"e8a448eaace94cc19066f425aed4e5a1";}s:11:"propertyIds";a:10:{i:0;s:32:"0297ec114a2a4b9780e275fdfcf34a62";i:1;s:32:"108ae805f5dd42efa9a749830e276a4e";i:2;s:32:"6c6c13388efc40999291099cb4e618a7";i:3;s:32:"7cdd497281954ee08715653013b8bc00";i:4;s:32:"7df68f7df9bb4f3daaab9366933e669e";i:5;s:32:"8a98a5c477644c39bd324d22316464ca";i:6;s:32:"9e539d4a506946059cbbc56efd663710";i:7;s:32:"e0b79689bfff47f4a7142685565fd6bc";i:8;s:32:"f05da3e553fa4e73b78a9fd15703a16a";i:9;s:32:"fa08b4fea46a43779c225437ce69a76e";}s:9:"optionIds";a:1:{i:0;s:32:"108ae805f5dd42efa9a749830e276a4e";}s:7:"options";a:1:{i:0;a:2:{s:5:"group";s:11:"Ringgröße";s:6:"option";s:2:"54";}}s:9:"streamIds";a:10:{i:0;s:32:"018d8340138a7385aeeaff401ea3c8b1";i:1;s:32:"09e4d565e8fe453597b55d44b118d4e6";i:2;s:32:"7adbc9495e2a4658a3ed9d17e3c0e908";i:3;s:32:"7d2206bcaae64e3bba8e357d30721be1";i:4;s:32:"90a5eaa6d39f44e79793991c5193832b";i:5;s:32:"9a208c03cfc74e8b87dc868e876006f7";i:6;s:32:"9d539d7e703b4f33b5ff5c9def5822de";i:7;s:32:"ad9dc2ec132b4434a4098e3984c2ca1a";i:8;s:32:"d69a2a3fd9df43859abf6868db31a021";i:9;s:32:"e387a81bf5d943ea998b22f6cd9892f0";}s:8:"parentId";s:32:"f92362ef19244799af9d67e6dfb9c2ed";s:5:"stock";i:-13;s:8:"features";a:0:{}}s:8:"\x00*\x00label";s:7:"R722.54";s:11:"\x00*\x00quantity";i:1;s:18:"\x00*\x00priceDefinition";O:64:"Shopware\Core\Checkout\Cart\Price\Struct\QuantityPriceDefinition":8:{s:13:"\x00*\x00extensions";a:0:{}s:8:"\x00*\x00price";d:129;s:11:"\x00*\x00taxRules";O:56:"Shopware\Core\Checkout\Cart\Tax\Struct\TaxRuleCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{i:19;r:22;}}s:11:"\x00*\x00quantity";i:1;s:15:"\x00*\x00isCalculated";b:1;s:27:"\x00*\x00referencePriceDefinition";N;s:12:"\x00*\x00listPrice";N;s:18:"\x00*\x00regulationPrice";N;}s:8:"\x00*\x00price";O:56:"Shopware\Core\Checkout\Cart\Price\Struct\CalculatedPrice":9:{s:13:"\x00*\x00extensions";a:0:{}s:12:"\x00*\x00unitPrice";d:129;s:11:"\x00*\x00quantity";i:1;s:13:"\x00*\x00totalPrice";d:129;s:18:"\x00*\x00calculatedTaxes";O:62:"Shopware\Core\Checkout\Cart\Tax\Struct\CalculatedTaxCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{i:19;O:52:"Shopware\Core\Checkout\Cart\Tax\Struct\CalculatedTax":4:{s:13:"\x00*\x00extensions";a:0:{}s:6:"\x00*\x00tax";d:20.6;s:10:"\x00*\x00taxRate";d:19;s:8:"\x00*\x00price";d:129;}}}s:11:"\x00*\x00taxRules";r:127;s:17:"\x00*\x00referencePrice";N;s:12:"\x00*\x00listPrice";N;s:18:"\x00*\x00regulationPrice";N;}s:7:"\x00*\x00good";b:1;s:14:"\x00*\x00description";N;s:8:"\x00*\x00cover";O:39:"Shopware\Core\Content\Media\MediaEntity":53:{s:13:"\x00*\x00extensions";a:2:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:28:"media_foreign_keys_extension";}s:24:"internal_mapping_storage";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";N;}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"df99d91f426d4e1a89e5a6b8ee718312";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:3:{s:3:"alt";s:4:"R722";s:5:"title";s:4:"R722";s:12:"customFields";a:0:{}}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-10-07 11:18:38.018000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-10-07 11:18:39.984000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:5:"media";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";O:60:"Shopware\Core\Framework\DataAbstractionLayer\FieldVisibility":1:{s:80:"\x00Shopware\Core\Framework\DataAbstractionLayer\FieldVisibility\x00internalProperties";a:2:{i:0;s:12:"mediaTypeRaw";i:1;s:12:"thumbnailsRo";}}s:9:"\x00*\x00userId";N;s:11:"\x00*\x00mimeType";s:10:"image/jpeg";s:16:"\x00*\x00fileExtension";s:3:"jpg";s:11:"\x00*\x00fileSize";i:610883;s:8:"\x00*\x00title";s:4:"R722";s:14:"\x00*\x00metaDataRaw";N;s:15:"\x00*\x00mediaTypeRaw";s:133:"O:47:"Shopware\Core\Content\Media\MediaType\ImageType":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00name";s:5:"IMAGE";s:8:"\x00*\x00flags";a:0:{}}";s:11:"\x00*\x00metaData";a:4:{s:5:"width";i:1700;s:6:"height";i:1700;s:4:"type";i:2;s:4:"hash";s:32:"46c54d0907d0d82cd7c0b748e6269c70";}s:12:"\x00*\x00mediaType";O:47:"Shopware\Core\Content\Media\MediaType\ImageType":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00name";s:5:"IMAGE";s:8:"\x00*\x00flags";a:0:{}}s:13:"\x00*\x00uploadedAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-10-07 11:18:39.981000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:6:"\x00*\x00alt";s:4:"R722";s:6:"\x00*\x00url";s:73:"https://ernstesdesign.de/media/85/fb/6a/1728299919/R722.jpg?ts=1728299919";s:11:"\x00*\x00fileName";s:4:"R722";s:7:"\x00*\x00user";N;s:15:"\x00*\x00translations";N;s:13:"\x00*\x00categories";N;s:23:"\x00*\x00productManufacturers";N;s:15:"\x00*\x00productMedia";N;s:14:"\x00*\x00avatarUsers";N;s:13:"\x00*\x00thumbnails";O:77:"Shopware\Core\Content\Media\Aggregate\MediaThumbnail\MediaThumbnailCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:4:{s:32:"019266b3eb2371a5bbf0149bdd0bca54";O:73:"Shopware\Core\Content\Media\Aggregate\MediaThumbnail\MediaThumbnailEntity":16:{s:13:"\x00*\x00extensions";a:1:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:38:"media_thumbnail_foreign_keys_extension";}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"019266b3eb2371a5bbf0149bdd0bca54";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:0:{}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-10-07 11:18:40.165000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";N;s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:15:"media_thumbnail";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";O:60:"Shopware\Core\Framework\DataAbstractionLayer\FieldVisibility":1:{s:80:"\x00Shopware\Core\Framework\DataAbstractionLayer\FieldVisibility\x00internalProperties";a:0:{}}s:7:"\x00*\x00path";s:46:"thumbnail/85/fb/6a/1728299919/R722_280x280.jpg";s:8:"\x00*\x00width";i:280;s:9:"\x00*\x00height";i:280;s:6:"\x00*\x00url";s:85:"https://ernstesdesign.de/thumbnail/85/fb/6a/1728299919/R722_280x280.jpg?ts=1728299920";s:10:"\x00*\x00mediaId";s:32:"df99d91f426d4e1a89e5a6b8ee718312";s:8:"\x00*\x00media";N;s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"019266b3eb2371a5bbf0149bdd0bca54";}s:32:"019266b3eb2371a5bbf0149bdd256733";O:73:"Shopware\Core\Content\Media\Aggregate\MediaThumbnail\MediaThumbnailEntity":16:{s:13:"\x00*\x00extensions";a:1:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:38:"media_thumbnail_foreign_keys_extension";}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"019266b3eb2371a5bbf0149bdd256733";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:0:{}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-10-07 11:18:40.165000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";N;s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:15:"media_thumbnail";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";r:231;s:7:"\x00*\x00path";s:46:"thumbnail/85/fb/6a/1728299919/R722_400x400.jpg";s:8:"\x00*\x00width";i:400;s:9:"\x00*\x00height";i:400;s:6:"\x00*\x00url";s:85:"https://ernstesdesign.de/thumbnail/85/fb/6a/1728299919/R722_400x400.jpg?ts=1728299920";s:10:"\x00*\x00mediaId";s:32:"df99d91f426d4e1a89e5a6b8ee718312";s:8:"\x00*\x00media";N;s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"019266b3eb2371a5bbf0149bdd256733";}s:32:"019266b3eb2371a5bbf0149bddf47ac6";O:73:"Shopware\Core\Content\Media\Aggregate\MediaThumbnail\MediaThumbnailEntity":16:{s:13:"\x00*\x00extensions";a:1:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:38:"media_thumbnail_foreign_keys_extension";}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"019266b3eb2371a5bbf0149bddf47ac6";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:0:{}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-10-07 11:18:40.165000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";N;s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:15:"media_thumbnail";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";r:231;s:7:"\x00*\x00path";s:46:"thumbnail/85/fb/6a/1728299919/R722_800x800.jpg";s:8:"\x00*\x00width";i:800;s:9:"\x00*\x00height";i:800;s:6:"\x00*\x00url";s:85:"https://ernstesdesign.de/thumbnail/85/fb/6a/1728299919/R722_800x800.jpg?ts=1728299920";s:10:"\x00*\x00mediaId";s:32:"df99d91f426d4e1a89e5a6b8ee718312";s:8:"\x00*\x00media";N;s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"019266b3eb2371a5bbf0149bddf47ac6";}s:32:"019266b3eb2371a5bbf0149bdec9a2d8";O:73:"Shopware\Core\Content\Media\Aggregate\MediaThumbnail\MediaThumbnailEntity":16:{s:13:"\x00*\x00extensions";a:1:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:38:"media_thumbnail_foreign_keys_extension";}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"019266b3eb2371a5bbf0149bdec9a2d8";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:0:{}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-10-07 11:18:40.165000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";N;s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:15:"media_thumbnail";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";r:231;s:7:"\x00*\x00path";s:48:"thumbnail/85/fb/6a/1728299919/R722_1920x1920.jpg";s:8:"\x00*\x00width";i:1920;s:9:"\x00*\x00height";i:1920;s:6:"\x00*\x00url";s:87:"https://ernstesdesign.de/thumbnail/85/fb/6a/1728299919/R722_1920x1920.jpg?ts=1728299920";s:10:"\x00*\x00mediaId";s:32:"df99d91f426d4e1a89e5a6b8ee718312";s:8:"\x00*\x00media";N;s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"019266b3eb2371a5bbf0149bdec9a2d8";}}}s:16:"\x00*\x00mediaFolderId";s:32:"5437cb9374b04709a4da0f6f202b40da";s:14:"\x00*\x00mediaFolder";N;s:10:"\x00*\x00hasFile";b:0;s:10:"\x00*\x00private";b:0;s:23:"\x00*\x00propertyGroupOptions";N;s:20:"\x00*\x00mailTemplateMedia";N;s:7:"\x00*\x00tags";N;s:15:"\x00*\x00thumbnailsRo";s:0:"";s:7:"\x00*\x00path";s:34:"media/85/fb/6a/1728299919/R722.jpg";s:22:"\x00*\x00documentBaseConfigs";N;s:18:"\x00*\x00shippingMethods";N;s:17:"\x00*\x00paymentMethods";N;s:30:"\x00*\x00productConfiguratorSettings";N;s:17:"\x00*\x00orderLineItems";N;s:12:"\x00*\x00cmsBlocks";N;s:14:"\x00*\x00cmsSections";N;s:11:"\x00*\x00cmsPages";N;s:12:"\x00*\x00documents";N;s:20:"\x00*\x00appPaymentMethods";N;s:21:"\x00*\x00appShippingMethods";N;s:19:"\x00*\x00productDownloads";N;s:25:"\x00*\x00orderLineItemDownloads";N;s:9:"\x00*\x00config";N;s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"df99d91f426d4e1a89e5a6b8ee718312";}s:22:"\x00*\x00deliveryInformation";O:63:"Shopware\Core\Checkout\Cart\Delivery\Struct\DeliveryInformation":9:{s:13:"\x00*\x00extensions";a:0:{}s:8:"\x00*\x00stock";i:-13;s:9:"\x00*\x00weight";d:0;s:15:"\x00*\x00freeDelivery";b:0;s:14:"\x00*\x00restockTime";i:5;s:15:"\x00*\x00deliveryTime";N;s:9:"\x00*\x00height";d:0;s:8:"\x00*\x00width";d:0;s:9:"\x00*\x00length";d:0;}s:11:"\x00*\x00children";O:55:"Shopware\Core\Checkout\Cart\LineItem\LineItemCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:0:{}}s:14:"\x00*\x00requirement";N;s:12:"\x00*\x00removable";b:1;s:12:"\x00*\x00stackable";b:1;s:22:"\x00*\x00quantityInformation";O:56:"Shopware\Core\Checkout\Cart\LineItem\QuantityInformation":4:{s:13:"\x00*\x00extensions";a:0:{}s:14:"\x00*\x00minPurchase";i:1;s:14:"\x00*\x00maxPurchase";i:100;s:16:"\x00*\x00purchaseSteps";i:1;}s:11:"\x00*\x00modified";b:0;s:20:"\x00*\x00shippingCostAware";b:1;s:16:"\x00*\x00dataTimestamp";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-12-23 19:29:43.756191";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:18:"\x00*\x00dataContextHash";s:32:"54296bb68b18bee86f20d51b18f3d82d";s:19:"\x00*\x00uniqueIdentifier";s:32:"0193f4fb56217398baa5d276479abb65";s:9:"\x00*\x00states";a:1:{i:0;s:11:"is-physical";}s:16:"\x00*\x00modifiedByApp";b:0;s:64:"\x00Shopware\Core\Checkout\Cart\LineItem\LineItem\x00payloadProtection";a:2:{s:14:"purchasePrices";b:1;s:12:"customFields";b:0;}s:5:"\x00*\x00id";s:32:"0193f4fb55987389b362b86a008041c6";s:7:"\x00*\x00type";s:7:"product";s:15:"\x00*\x00referencedId";s:32:"ae00bd79a74447e48332aa06da31073b";}}}s:9:"\x00*\x00errors";O:49:"Shopware\Core\Checkout\Cart\Error\ErrorCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:0:{}}s:13:"\x00*\x00deliveries";O:62:"Shopware\Core\Checkout\Cart\Delivery\Struct\DeliveryCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{i:0;O:52:"Shopware\Core\Checkout\Cart\Delivery\Struct\Delivery":6:{s:13:"\x00*\x00extensions";a:0:{}s:12:"\x00*\x00positions";O:70:"Shopware\Core\Checkout\Cart\Delivery\Struct\DeliveryPositionCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{s:32:"0193f4fb55987389b362b86a008041c6";O:60:"Shopware\Core\Checkout\Cart\Delivery\Struct\DeliveryPosition":6:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00lineItem";O:45:"Shopware\Core\Checkout\Cart\LineItem\LineItem":26:{s:13:"\x00*\x00extensions";a:1:{s:28:"lenz-order-line-item-comment";O:42:"Shopware\Core\Framework\Struct\ArrayEntity":10:{s:13:"\x00*\x00extensions";a:0:{}s:20:"\x00*\x00_uniqueIdentifier";N;s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:0:{}s:12:"\x00*\x00createdAt";N;s:12:"\x00*\x00updatedAt";N;s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";N;s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";N;s:14:"\x00*\x00_entityName";s:12:"array-entity";s:7:"\x00*\x00data";a:0:{}}}s:10:"\x00*\x00payload";a:19:{s:10:"isCloseout";b:0;s:12:"customFields";a:0:{}s:9:"createdAt";s:23:"2022-09-21 16:23:27.036";s:11:"releaseDate";N;s:5:"isNew";b:0;s:15:"markAsTopseller";N;s:14:"purchasePrices";s:155:"{"extensions":[],"currencyId":"b7d2554b0ce847cd82f3ac9bd1c0dfca","net":0,"gross":0,"linked":true,"listPrice":null,"percentage":null,"regulationPrice":null}";s:13:"productNumber";s:7:"R722.54";s:14:"manufacturerId";s:32:"7bf787ab99cf4d339d86798f75444d32";s:5:"taxId";s:32:"72943b70739c48999afd49b2b740c723";s:6:"tagIds";N;s:11:"categoryIds";a:33:{i:0;s:32:"bfe523fe77ae41b4b4ffeba070794032";i:1;s:32:"019348ece72e726bb3fa9e1c0d986e07";i:2;s:32:"1907e9e73a6140d48c10e82b8986f46a";i:3;s:32:"42da0fb4a6b94513b7324449d2f8d38e";i:4;s:32:"ba7ed83336394da8930566d49b4de149";i:5;s:32:"dd136371ff8a415dbf93d6b67d755154";i:6;s:32:"fcf59ed5613142729c2fd6768e07a08b";i:7;s:32:"118f588ee1ca4166b28245ef6b365994";i:8;s:32:"43649894d5014f2f8bdb57bc51b85d17";i:9;s:32:"c1d9a37345a042938c0b318c1b1c7603";i:10;s:32:"1f2a1232cddd49dfa559b8bd24df44f8";i:11;s:32:"05c8c55fe903479a87662295a58c4ead";i:12;s:32:"595443089bf944398b8568193c218803";i:13;s:32:"8e1bba960e8c4be2ad164acc9fb07a13";i:14;s:32:"fa3e69fe19e94cc89f113f0aff04a505";i:15;s:32:"d5c1e7cd6ad440aa91122cb57eaeb69e";i:16;s:32:"49ae35f71f794a149ba089f5d4466713";i:17;s:32:"1cceb80a0b3e45399e90094933e08d72";i:18;s:32:"31929c4aca794860a2b9492cfb1cdf06";i:19;s:32:"1dd286b3438c4faca2b7e2b494b36b75";i:20;s:32:"0193490b4bf671158b78c02cca40097d";i:21;s:32:"048c04a37c044b458c4b53e1639ac684";i:22;s:32:"1d4688f3b37646b68623248e645ed963";i:23;s:32:"3005ecc96fd5419dbbd41975c91f06b6";i:24;s:32:"537fd57254854488a70bf045a1ff7c46";i:25;s:32:"563faaf412d640aba6cdd6617c797ed6";i:26;s:32:"62e12dca076d486f89b69989712d82c7";i:27;s:32:"8c2332b671474fc8b2e13e44c0f0190a";i:28;s:32:"b6d5f38073bf4228a0d8bea55380b993";i:29;s:32:"b7d1509d27634c86ba2e8e464d3c9ecc";i:30;s:32:"d6bcff8f4f2641c8839f610f30a3048a";i:31;s:32:"e47d435eea744852a1a539dc21a67bc2";i:32;s:32:"e8a448eaace94cc19066f425aed4e5a1";}s:11:"propertyIds";a:10:{i:0;s:32:"0297ec114a2a4b9780e275fdfcf34a62";i:1;s:32:"108ae805f5dd42efa9a749830e276a4e";i:2;s:32:"6c6c13388efc40999291099cb4e618a7";i:3;s:32:"7cdd497281954ee08715653013b8bc00";i:4;s:32:"7df68f7df9bb4f3daaab9366933e669e";i:5;s:32:"8a98a5c477644c39bd324d22316464ca";i:6;s:32:"9e539d4a506946059cbbc56efd663710";i:7;s:32:"e0b79689bfff47f4a7142685565fd6bc";i:8;s:32:"f05da3e553fa4e73b78a9fd15703a16a";i:9;s:32:"fa08b4fea46a43779c225437ce69a76e";}s:9:"optionIds";a:1:{i:0;s:32:"108ae805f5dd42efa9a749830e276a4e";}s:7:"options";a:1:{i:0;a:2:{s:5:"group";s:11:"Ringgröße";s:6:"option";s:2:"54";}}s:9:"streamIds";a:10:{i:0;s:32:"018d8340138a7385aeeaff401ea3c8b1";i:1;s:32:"09e4d565e8fe453597b55d44b118d4e6";i:2;s:32:"7adbc9495e2a4658a3ed9d17e3c0e908";i:3;s:32:"7d2206bcaae64e3bba8e357d30721be1";i:4;s:32:"90a5eaa6d39f44e79793991c5193832b";i:5;s:32:"9a208c03cfc74e8b87dc868e876006f7";i:6;s:32:"9d539d7e703b4f33b5ff5c9def5822de";i:7;s:32:"ad9dc2ec132b4434a4098e3984c2ca1a";i:8;s:32:"d69a2a3fd9df43859abf6868db31a021";i:9;s:32:"e387a81bf5d943ea998b22f6cd9892f0";}s:8:"parentId";s:32:"f92362ef19244799af9d67e6dfb9c2ed";s:5:"stock";i:-13;s:8:"features";a:0:{}}s:8:"\x00*\x00label";s:7:"R722.54";s:11:"\x00*\x00quantity";i:1;s:18:"\x00*\x00priceDefinition";O:64:"Shopware\Core\Checkout\Cart\Price\Struct\QuantityPriceDefinition":8:{s:13:"\x00*\x00extensions";a:0:{}s:8:"\x00*\x00price";d:129;s:11:"\x00*\x00taxRules";O:56:"Shopware\Core\Checkout\Cart\Tax\Struct\TaxRuleCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{i:19;O:46:"Shopware\Core\Checkout\Cart\Tax\Struct\TaxRule":3:{s:13:"\x00*\x00extensions";a:0:{}s:10:"\x00*\x00taxRate";d:19;s:13:"\x00*\x00percentage";d:100;}}}s:11:"\x00*\x00quantity";i:1;s:15:"\x00*\x00isCalculated";b:1;s:27:"\x00*\x00referencePriceDefinition";N;s:12:"\x00*\x00listPrice";N;s:18:"\x00*\x00regulationPrice";N;}s:8:"\x00*\x00price";O:56:"Shopware\Core\Checkout\Cart\Price\Struct\CalculatedPrice":9:{s:13:"\x00*\x00extensions";a:0:{}s:12:"\x00*\x00unitPrice";d:129;s:11:"\x00*\x00quantity";i:1;s:13:"\x00*\x00totalPrice";d:129;s:18:"\x00*\x00calculatedTaxes";O:62:"Shopware\Core\Checkout\Cart\Tax\Struct\CalculatedTaxCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{i:19;O:52:"Shopware\Core\Checkout\Cart\Tax\Struct\CalculatedTax":4:{s:13:"\x00*\x00extensions";a:0:{}s:6:"\x00*\x00tax";d:20.6;s:10:"\x00*\x00taxRate";d:19;s:8:"\x00*\x00price";d:129;}}}s:11:"\x00*\x00taxRules";O:56:"Shopware\Core\Checkout\Cart\Tax\Struct\TaxRuleCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{i:19;O:46:"Shopware\Core\Checkout\Cart\Tax\Struct\TaxRule":3:{s:13:"\x00*\x00extensions";a:0:{}s:10:"\x00*\x00taxRate";d:19;s:13:"\x00*\x00percentage";d:100;}}}s:17:"\x00*\x00referencePrice";N;s:12:"\x00*\x00listPrice";N;s:18:"\x00*\x00regulationPrice";N;}s:7:"\x00*\x00good";b:1;s:14:"\x00*\x00description";N;s:8:"\x00*\x00cover";O:39:"Shopware\Core\Content\Media\MediaEntity":53:{s:13:"\x00*\x00extensions";a:2:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:28:"media_foreign_keys_extension";}s:24:"internal_mapping_storage";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";N;}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"df99d91f426d4e1a89e5a6b8ee718312";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:3:{s:3:"alt";s:4:"R722";s:5:"title";s:4:"R722";s:12:"customFields";a:0:{}}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-10-07 11:18:38.018000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-10-07 11:18:39.984000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:5:"media";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";r:180;s:9:"\x00*\x00userId";N;s:11:"\x00*\x00mimeType";s:10:"image/jpeg";s:16:"\x00*\x00fileExtension";s:3:"jpg";s:11:"\x00*\x00fileSize";i:610883;s:8:"\x00*\x00title";s:4:"R722";s:14:"\x00*\x00metaDataRaw";N;s:15:"\x00*\x00mediaTypeRaw";s:133:"O:47:"Shopware\Core\Content\Media\MediaType\ImageType":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00name";s:5:"IMAGE";s:8:"\x00*\x00flags";a:0:{}}";s:11:"\x00*\x00metaData";a:4:{s:5:"width";i:1700;s:6:"height";i:1700;s:4:"type";i:2;s:4:"hash";s:32:"46c54d0907d0d82cd7c0b748e6269c70";}s:12:"\x00*\x00mediaType";O:47:"Shopware\Core\Content\Media\MediaType\ImageType":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00name";s:5:"IMAGE";s:8:"\x00*\x00flags";a:0:{}}s:13:"\x00*\x00uploadedAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-10-07 11:18:39.981000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:6:"\x00*\x00alt";s:4:"R722";s:6:"\x00*\x00url";s:73:"https://ernstesdesign.de/media/85/fb/6a/1728299919/R722.jpg?ts=1728299919";s:11:"\x00*\x00fileName";s:4:"R722";s:7:"\x00*\x00user";N;s:15:"\x00*\x00translations";N;s:13:"\x00*\x00categories";N;s:23:"\x00*\x00productManufacturers";N;s:15:"\x00*\x00productMedia";N;s:14:"\x00*\x00avatarUsers";N;s:13:"\x00*\x00thumbnails";O:77:"Shopware\Core\Content\Media\Aggregate\MediaThumbnail\MediaThumbnailCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:4:{s:32:"019266b3eb2371a5bbf0149bdd0bca54";O:73:"Shopware\Core\Content\Media\Aggregate\MediaThumbnail\MediaThumbnailEntity":16:{s:13:"\x00*\x00extensions";a:1:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:38:"media_thumbnail_foreign_keys_extension";}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"019266b3eb2371a5bbf0149bdd0bca54";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:0:{}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-10-07 11:18:40.165000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";N;s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:15:"media_thumbnail";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";r:231;s:7:"\x00*\x00path";s:46:"thumbnail/85/fb/6a/1728299919/R722_280x280.jpg";s:8:"\x00*\x00width";i:280;s:9:"\x00*\x00height";i:280;s:6:"\x00*\x00url";s:85:"https://ernstesdesign.de/thumbnail/85/fb/6a/1728299919/R722_280x280.jpg?ts=1728299920";s:10:"\x00*\x00mediaId";s:32:"df99d91f426d4e1a89e5a6b8ee718312";s:8:"\x00*\x00media";N;s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"019266b3eb2371a5bbf0149bdd0bca54";}s:32:"019266b3eb2371a5bbf0149bdd256733";O:73:"Shopware\Core\Content\Media\Aggregate\MediaThumbnail\MediaThumbnailEntity":16:{s:13:"\x00*\x00extensions";a:1:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:38:"media_thumbnail_foreign_keys_extension";}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"019266b3eb2371a5bbf0149bdd256733";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:0:{}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-10-07 11:18:40.165000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";N;s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:15:"media_thumbnail";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";r:231;s:7:"\x00*\x00path";s:46:"thumbnail/85/fb/6a/1728299919/R722_400x400.jpg";s:8:"\x00*\x00width";i:400;s:9:"\x00*\x00height";i:400;s:6:"\x00*\x00url";s:85:"https://ernstesdesign.de/thumbnail/85/fb/6a/1728299919/R722_400x400.jpg?ts=1728299920";s:10:"\x00*\x00mediaId";s:32:"df99d91f426d4e1a89e5a6b8ee718312";s:8:"\x00*\x00media";N;s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"019266b3eb2371a5bbf0149bdd256733";}s:32:"019266b3eb2371a5bbf0149bddf47ac6";O:73:"Shopware\Core\Content\Media\Aggregate\MediaThumbnail\MediaThumbnailEntity":16:{s:13:"\x00*\x00extensions";a:1:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:38:"media_thumbnail_foreign_keys_extension";}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"019266b3eb2371a5bbf0149bddf47ac6";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:0:{}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-10-07 11:18:40.165000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";N;s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:15:"media_thumbnail";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";r:231;s:7:"\x00*\x00path";s:46:"thumbnail/85/fb/6a/1728299919/R722_800x800.jpg";s:8:"\x00*\x00width";i:800;s:9:"\x00*\x00height";i:800;s:6:"\x00*\x00url";s:85:"https://ernstesdesign.de/thumbnail/85/fb/6a/1728299919/R722_800x800.jpg?ts=1728299920";s:10:"\x00*\x00mediaId";s:32:"df99d91f426d4e1a89e5a6b8ee718312";s:8:"\x00*\x00media";N;s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"019266b3eb2371a5bbf0149bddf47ac6";}s:32:"019266b3eb2371a5bbf0149bdec9a2d8";O:73:"Shopware\Core\Content\Media\Aggregate\MediaThumbnail\MediaThumbnailEntity":16:{s:13:"\x00*\x00extensions";a:1:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:38:"media_thumbnail_foreign_keys_extension";}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"019266b3eb2371a5bbf0149bdec9a2d8";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:0:{}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-10-07 11:18:40.165000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";N;s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:15:"media_thumbnail";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";r:231;s:7:"\x00*\x00path";s:48:"thumbnail/85/fb/6a/1728299919/R722_1920x1920.jpg";s:8:"\x00*\x00width";i:1920;s:9:"\x00*\x00height";i:1920;s:6:"\x00*\x00url";s:87:"https://ernstesdesign.de/thumbnail/85/fb/6a/1728299919/R722_1920x1920.jpg?ts=1728299920";s:10:"\x00*\x00mediaId";s:32:"df99d91f426d4e1a89e5a6b8ee718312";s:8:"\x00*\x00media";N;s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"019266b3eb2371a5bbf0149bdec9a2d8";}}}s:16:"\x00*\x00mediaFolderId";s:32:"5437cb9374b04709a4da0f6f202b40da";s:14:"\x00*\x00mediaFolder";N;s:10:"\x00*\x00hasFile";b:0;s:10:"\x00*\x00private";b:0;s:23:"\x00*\x00propertyGroupOptions";N;s:20:"\x00*\x00mailTemplateMedia";N;s:7:"\x00*\x00tags";N;s:15:"\x00*\x00thumbnailsRo";s:0:"";s:7:"\x00*\x00path";s:34:"media/85/fb/6a/1728299919/R722.jpg";s:22:"\x00*\x00documentBaseConfigs";N;s:18:"\x00*\x00shippingMethods";N;s:17:"\x00*\x00paymentMethods";N;s:30:"\x00*\x00productConfiguratorSettings";N;s:17:"\x00*\x00orderLineItems";N;s:12:"\x00*\x00cmsBlocks";N;s:14:"\x00*\x00cmsSections";N;s:11:"\x00*\x00cmsPages";N;s:12:"\x00*\x00documents";N;s:20:"\x00*\x00appPaymentMethods";N;s:21:"\x00*\x00appShippingMethods";N;s:19:"\x00*\x00productDownloads";N;s:25:"\x00*\x00orderLineItemDownloads";N;s:9:"\x00*\x00config";N;s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"df99d91f426d4e1a89e5a6b8ee718312";}s:22:"\x00*\x00deliveryInformation";O:63:"Shopware\Core\Checkout\Cart\Delivery\Struct\DeliveryInformation":9:{s:13:"\x00*\x00extensions";a:0:{}s:8:"\x00*\x00stock";i:-13;s:9:"\x00*\x00weight";d:0;s:15:"\x00*\x00freeDelivery";b:0;s:14:"\x00*\x00restockTime";i:5;s:15:"\x00*\x00deliveryTime";N;s:9:"\x00*\x00height";d:0;s:8:"\x00*\x00width";d:0;s:9:"\x00*\x00length";d:0;}s:11:"\x00*\x00children";O:55:"Shopware\Core\Checkout\Cart\LineItem\LineItemCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:0:{}}s:14:"\x00*\x00requirement";N;s:12:"\x00*\x00removable";b:1;s:12:"\x00*\x00stackable";b:1;s:22:"\x00*\x00quantityInformation";O:56:"Shopware\Core\Checkout\Cart\LineItem\QuantityInformation":4:{s:13:"\x00*\x00extensions";a:0:{}s:14:"\x00*\x00minPurchase";i:1;s:14:"\x00*\x00maxPurchase";i:100;s:16:"\x00*\x00purchaseSteps";i:1;}s:11:"\x00*\x00modified";b:0;s:20:"\x00*\x00shippingCostAware";b:1;s:16:"\x00*\x00dataTimestamp";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-12-23 19:29:43.756191";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:18:"\x00*\x00dataContextHash";s:32:"54296bb68b18bee86f20d51b18f3d82d";s:19:"\x00*\x00uniqueIdentifier";s:32:"0193f4fb56217398baa5d276479abb65";s:9:"\x00*\x00states";a:1:{i:0;s:11:"is-physical";}s:16:"\x00*\x00modifiedByApp";b:0;s:64:"\x00Shopware\Core\Checkout\Cart\LineItem\LineItem\x00payloadProtection";a:2:{s:14:"purchasePrices";b:1;s:12:"customFields";b:0;}s:5:"\x00*\x00id";s:32:"0193f4fb55987389b362b86a008041c6";s:7:"\x00*\x00type";s:7:"product";s:15:"\x00*\x00referencedId";s:32:"ae00bd79a74447e48332aa06da31073b";}s:11:"\x00*\x00quantity";i:1;s:8:"\x00*\x00price";O:56:"Shopware\Core\Checkout\Cart\Price\Struct\CalculatedPrice":9:{s:13:"\x00*\x00extensions";a:0:{}s:12:"\x00*\x00unitPrice";d:129;s:11:"\x00*\x00quantity";i:1;s:13:"\x00*\x00totalPrice";d:129;s:18:"\x00*\x00calculatedTaxes";O:62:"Shopware\Core\Checkout\Cart\Tax\Struct\CalculatedTaxCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{i:19;O:52:"Shopware\Core\Checkout\Cart\Tax\Struct\CalculatedTax":4:{s:13:"\x00*\x00extensions";a:0:{}s:6:"\x00*\x00tax";d:20.6;s:10:"\x00*\x00taxRate";d:19;s:8:"\x00*\x00price";d:129;}}}s:11:"\x00*\x00taxRules";O:56:"Shopware\Core\Checkout\Cart\Tax\Struct\TaxRuleCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{i:19;O:46:"Shopware\Core\Checkout\Cart\Tax\Struct\TaxRule":3:{s:13:"\x00*\x00extensions";a:0:{}s:10:"\x00*\x00taxRate";d:19;s:13:"\x00*\x00percentage";d:100;}}}s:17:"\x00*\x00referencePrice";N;s:12:"\x00*\x00listPrice";N;s:18:"\x00*\x00regulationPrice";N;}s:13:"\x00*\x00identifier";s:32:"0193f4fb55987389b362b86a008041c6";s:15:"\x00*\x00deliveryDate";O:56:"Shopware\Core\Checkout\Cart\Delivery\Struct\DeliveryDate":3:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00earliest";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-12-30 16:00:00.000000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:9:"\x00*\x00latest";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2025-01-01 16:00:00.000000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}}}}}s:11:"\x00*\x00location";O:60:"Shopware\Core\Checkout\Cart\Delivery\Struct\ShippingLocation":4:{s:13:"\x00*\x00extensions";a:0:{}s:10:"\x00*\x00country";O:42:"Shopware\Core\System\Country\CountryEntity":38:{s:13:"\x00*\x00extensions";a:2:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:30:"country_foreign_keys_extension";}s:24:"internal_mapping_storage";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";N;}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"3dcdbf506e5647d6b1e8800d8cac0d7b";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:3:{s:4:"name";s:11:"Deutschland";s:12:"customFields";a:0:{}s:13:"addressFormat";a:5:{i:0;a:3:{i:0;s:15:"address/company";i:1;s:11:"symbol/dash";i:2;s:18:"address/department";}i:1;a:2:{i:0;s:18:"address/first_name";i:1;s:17:"address/last_name";}i:2;a:1:{i:0;s:14:"address/street";}i:3;a:2:{i:0;s:15:"address/zipcode";i:1;s:12:"address/city";}i:4;a:1:{i:0;s:15:"address/country";}}}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2021-02-26 10:13:42.217000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-10-01 06:20:54.987000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:7:"country";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";O:60:"Shopware\Core\Framework\DataAbstractionLayer\FieldVisibility":1:{s:80:"\x00Shopware\Core\Framework\DataAbstractionLayer\FieldVisibility\x00internalProperties";a:0:{}}s:7:"\x00*\x00name";s:11:"Deutschland";s:6:"\x00*\x00iso";s:2:"DE";s:11:"\x00*\x00position";i:1;s:9:"\x00*\x00active";b:1;s:20:"\x00*\x00shippingAvailable";b:1;s:7:"\x00*\x00iso3";s:3:"DEU";s:29:"\x00*\x00displayStateInRegistration";b:0;s:27:"\x00*\x00forceStateInRegistration";b:0;s:20:"\x00*\x00checkVatIdPattern";b:0;s:15:"\x00*\x00vatIdPattern";s:7:"DE\d{9}";s:16:"\x00*\x00vatIdRequired";b:0;s:14:"\x00*\x00customerTax";O:58:"Shopware\Core\Framework\DataAbstractionLayer\TaxFreeConfig":4:{s:13:"\x00*\x00extensions";a:0:{}s:10:"\x00*\x00enabled";b:0;s:13:"\x00*\x00currencyId";s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";s:9:"\x00*\x00amount";d:0;}s:13:"\x00*\x00companyTax";O:58:"Shopware\Core\Framework\DataAbstractionLayer\TaxFreeConfig":4:{s:13:"\x00*\x00extensions";a:0:{}s:10:"\x00*\x00enabled";b:0;s:13:"\x00*\x00currencyId";s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";s:9:"\x00*\x00amount";d:0;}s:9:"\x00*\x00states";N;s:15:"\x00*\x00translations";N;s:17:"\x00*\x00orderAddresses";N;s:20:"\x00*\x00customerAddresses";N;s:33:"\x00*\x00salesChannelDefaultAssignments";N;s:16:"\x00*\x00salesChannels";N;s:11:"\x00*\x00taxRules";N;s:27:"\x00*\x00currencyCountryRoundings";N;s:21:"\x00*\x00postalCodeRequired";b:1;s:7:"\x00*\x00isEu";b:1;s:25:"\x00*\x00checkPostalCodePattern";b:1;s:33:"\x00*\x00checkAdvancedPostalCodePattern";b:0;s:28:"\x00*\x00advancedPostalCodePattern";N;s:27:"\x00*\x00defaultPostalCodePattern";s:5:"\d{5}";s:16:"\x00*\x00addressFormat";a:5:{i:0;a:3:{i:0;s:15:"address/company";i:1;s:11:"symbol/dash";i:2;s:18:"address/department";}i:1;a:2:{i:0;s:18:"address/first_name";i:1;s:17:"address/last_name";}i:2;a:1:{i:0;s:14:"address/street";}i:3;a:2:{i:0;s:15:"address/zipcode";i:1;s:12:"address/city";}i:4;a:1:{i:0;s:15:"address/country";}}s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"3dcdbf506e5647d6b1e8800d8cac0d7b";}s:8:"\x00*\x00state";N;s:10:"\x00*\x00address";O:79:"Shopware\Core\Checkout\Customer\Aggregate\CustomerAddress\CustomerAddressEntity":29:{s:13:"\x00*\x00extensions";a:1:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:39:"customer_address_foreign_keys_extension";}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"0193f4fe11c17396a8296e02520f5c4b";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:0:{}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-12-23 19:28:31.687000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";N;s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:16:"customer_address";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";O:60:"Shopware\Core\Framework\DataAbstractionLayer\FieldVisibility":1:{s:80:"\x00Shopware\Core\Framework\DataAbstractionLayer\FieldVisibility\x00internalProperties";a:0:{}}s:13:"\x00*\x00customerId";s:32:"0193f4fe11bf7269a45dda4fb221ca3c";s:12:"\x00*\x00countryId";s:32:"3dcdbf506e5647d6b1e8800d8cac0d7b";s:17:"\x00*\x00countryStateId";N;s:15:"\x00*\x00salutationId";s:32:"0c50ff2fb4274842b07d9f12c21871ff";s:12:"\x00*\x00firstName";s:15:"Karin Stefanie ";s:11:"\x00*\x00lastName";s:7:"Schmidt";s:10:"\x00*\x00zipcode";s:5:"64569";s:7:"\x00*\x00city";s:8:"Nauheim ";s:10:"\x00*\x00company";N;s:13:"\x00*\x00department";N;s:8:"\x00*\x00title";N;s:9:"\x00*\x00street";s:12:"Im Teich 106";s:14:"\x00*\x00phoneNumber";N;s:25:"\x00*\x00additionalAddressLine1";N;s:25:"\x00*\x00additionalAddressLine2";N;s:10:"\x00*\x00country";r:775;s:15:"\x00*\x00countryState";N;s:13:"\x00*\x00salutation";O:48:"Shopware\Core\System\Salutation\SalutationEntity":19:{s:13:"\x00*\x00extensions";a:2:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:33:"salutation_foreign_keys_extension";}s:24:"internal_mapping_storage";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";N;}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"0c50ff2fb4274842b07d9f12c21871ff";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:3:{s:11:"displayName";s:4:"Frau";s:10:"letterName";s:17:"Sehr geehrte Frau";s:12:"customFields";a:0:{}}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2021-02-26 10:13:42.213000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2023-08-11 08:42:07.881000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:10:"salutation";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";O:60:"Shopware\Core\Framework\DataAbstractionLayer\FieldVisibility":1:{s:80:"\x00Shopware\Core\Framework\DataAbstractionLayer\FieldVisibility\x00internalProperties";a:0:{}}s:16:"\x00*\x00salutationKey";s:3:"mrs";s:14:"\x00*\x00displayName";s:4:"Frau";s:13:"\x00*\x00letterName";s:17:"Sehr geehrte Frau";s:15:"\x00*\x00translations";N;s:12:"\x00*\x00customers";N;s:20:"\x00*\x00customerAddresses";N;s:17:"\x00*\x00orderCustomers";N;s:17:"\x00*\x00orderAddresses";N;s:23:"\x00*\x00newsletterRecipients";N;s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"0c50ff2fb4274842b07d9f12c21871ff";}s:11:"\x00*\x00customer";N;s:15:"\x00*\x00customFields";a:3:{s:25:"repertus_packstation_type";N;s:31:"repertus_packstation_postnumber";N;s:27:"repertus_packstation_number";N;}s:5:"\x00*\x00id";s:32:"0193f4fe11c17396a8296e02520f5c4b";}}s:15:"\x00*\x00deliveryDate";O:56:"Shopware\Core\Checkout\Cart\Delivery\Struct\DeliveryDate":3:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00earliest";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-12-30 16:00:00.000000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:9:"\x00*\x00latest";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2025-01-01 16:00:00.000000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}}s:17:"\x00*\x00shippingMethod";O:52:"Shopware\Core\Checkout\Shipping\ShippingMethodEntity":32:{s:13:"\x00*\x00extensions";a:1:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:38:"shipping_method_foreign_keys_extension";}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"4c383e3b3b614cc0b029b424becc594d";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:4:{s:4:"name";s:8:"Standard";s:12:"customFields";a:0:{}s:11:"description";N;s:11:"trackingUrl";N;}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2021-02-26 10:13:42.797000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-12-05 09:20:20.616000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:15:"shipping_method";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";O:60:"Shopware\Core\Framework\DataAbstractionLayer\FieldVisibility":1:{s:80:"\x00Shopware\Core\Framework\DataAbstractionLayer\FieldVisibility\x00internalProperties";a:0:{}}s:7:"\x00*\x00name";s:8:"Standard";s:9:"\x00*\x00active";b:1;s:11:"\x00*\x00position";i:1;s:14:"\x00*\x00description";N;s:14:"\x00*\x00trackingUrl";N;s:17:"\x00*\x00deliveryTimeId";s:32:"d0291a3410294c55aee760566cc08dd4";s:15:"\x00*\x00deliveryTime";O:52:"Shopware\Core\System\DeliveryTime\DeliveryTimeEntity":17:{s:13:"\x00*\x00extensions";a:2:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:36:"delivery_time_foreign_keys_extension";}s:24:"internal_mapping_storage";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";N;}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"d0291a3410294c55aee760566cc08dd4";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:2:{s:4:"name";s:14:"2 - 4 Werktage";s:12:"customFields";a:0:{}}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2023-02-01 13:03:33.645000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2023-08-11 08:42:15.255000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:13:"delivery_time";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";O:60:"Shopware\Core\Framework\DataAbstractionLayer\FieldVisibility":1:{s:80:"\x00Shopware\Core\Framework\DataAbstractionLayer\FieldVisibility\x00internalProperties";a:0:{}}s:7:"\x00*\x00name";s:14:"2 - 4 Werktage";s:6:"\x00*\x00min";i:2;s:6:"\x00*\x00max";i:4;s:7:"\x00*\x00unit";s:3:"day";s:18:"\x00*\x00shippingMethods";N;s:15:"\x00*\x00translations";N;s:11:"\x00*\x00products";N;s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"d0291a3410294c55aee760566cc08dd4";}s:15:"\x00*\x00translations";N;s:18:"\x00*\x00orderDeliveries";N;s:33:"\x00*\x00salesChannelDefaultAssignments";N;s:16:"\x00*\x00salesChannels";N;s:19:"\x00*\x00availabilityRule";N;s:21:"\x00*\x00availabilityRuleId";s:32:"da3ac5a0bb8e4657a78e9b98f5656fd5";s:9:"\x00*\x00prices";O:91:"Shopware\Core\Checkout\Shipping\Aggregate\ShippingMethodPrice\ShippingMethodPriceCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:11:{s:32:"01936810d5797ff1b3b5d08dbc9cdbbe";O:87:"Shopware\Core\Checkout\Shipping\Aggregate\ShippingMethodPrice\ShippingMethodPriceEntity":20:{s:13:"\x00*\x00extensions";a:1:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:44:"shipping_method_price_foreign_keys_extension";}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"01936810d5797ff1b3b5d08dbc9cdbbe";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:0:{}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-11-26 10:43:51.653000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";N;s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:21:"shipping_method_price";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";O:60:"Shopware\Core\Framework\DataAbstractionLayer\FieldVisibility":1:{s:80:"\x00Shopware\Core\Framework\DataAbstractionLayer\FieldVisibility\x00internalProperties";a:0:{}}s:19:"\x00*\x00shippingMethodId";s:32:"4c383e3b3b614cc0b029b424becc594d";s:9:"\x00*\x00ruleId";s:32:"0193680dddd970119bb3982615a40950";s:14:"\x00*\x00calculation";i:2;s:16:"\x00*\x00quantityStart";d:1;s:14:"\x00*\x00quantityEnd";d:39.99;s:17:"\x00*\x00shippingMethod";N;s:7:"\x00*\x00rule";N;s:20:"\x00*\x00calculationRuleId";N;s:18:"\x00*\x00calculationRule";N;s:16:"\x00*\x00currencyPrice";O:68:"Shopware\Core\Framework\DataAbstractionLayer\Pricing\PriceCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";O:58:"Shopware\Core\Framework\DataAbstractionLayer\Pricing\Price":8:{s:13:"\x00*\x00extensions";a:0:{}s:13:"\x00*\x00currencyId";s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";s:6:"\x00*\x00net";d:0;s:8:"\x00*\x00gross";d:15;s:9:"\x00*\x00linked";b:0;s:12:"\x00*\x00listPrice";N;s:13:"\x00*\x00percentage";N;s:18:"\x00*\x00regulationPrice";N;}}}s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"01936810d5797ff1b3b5d08dbc9cdbbe";}s:32:"019368111e3d7a74b8ef084a164ba7f7";O:87:"Shopware\Core\Checkout\Shipping\Aggregate\ShippingMethodPrice\ShippingMethodPriceEntity":20:{s:13:"\x00*\x00extensions";a:1:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:44:"shipping_method_price_foreign_keys_extension";}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"019368111e3d7a74b8ef084a164ba7f7";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:0:{}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-11-26 10:43:51.653000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-12-05 09:20:20.616000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:21:"shipping_method_price";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";r:1046;s:19:"\x00*\x00shippingMethodId";s:32:"4c383e3b3b614cc0b029b424becc594d";s:9:"\x00*\x00ruleId";s:32:"0193680dddd970119bb3982615a40950";s:14:"\x00*\x00calculation";i:2;s:16:"\x00*\x00quantityStart";d:90;s:14:"\x00*\x00quantityEnd";N;s:17:"\x00*\x00shippingMethod";N;s:7:"\x00*\x00rule";N;s:20:"\x00*\x00calculationRuleId";N;s:18:"\x00*\x00calculationRule";N;s:16:"\x00*\x00currencyPrice";O:68:"Shopware\Core\Framework\DataAbstractionLayer\Pricing\PriceCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";O:58:"Shopware\Core\Framework\DataAbstractionLayer\Pricing\Price":8:{s:13:"\x00*\x00extensions";a:0:{}s:13:"\x00*\x00currencyId";s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";s:6:"\x00*\x00net";d:0;s:8:"\x00*\x00gross";d:0;s:9:"\x00*\x00linked";b:0;s:12:"\x00*\x00listPrice";N;s:13:"\x00*\x00percentage";N;s:18:"\x00*\x00regulationPrice";N;}}}s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"019368111e3d7a74b8ef084a164ba7f7";}s:32:"01936811367671eca2e9c886ebbb0d31";O:87:"Shopware\Core\Checkout\Shipping\Aggregate\ShippingMethodPrice\ShippingMethodPriceEntity":20:{s:13:"\x00*\x00extensions";a:1:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:44:"shipping_method_price_foreign_keys_extension";}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"01936811367671eca2e9c886ebbb0d31";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:0:{}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-11-26 10:43:51.653000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";N;s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:21:"shipping_method_price";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";r:1046;s:19:"\x00*\x00shippingMethodId";s:32:"4c383e3b3b614cc0b029b424becc594d";s:9:"\x00*\x00ruleId";s:32:"0193680ec75f7eed822e403e9cee4325";s:14:"\x00*\x00calculation";i:2;s:16:"\x00*\x00quantityStart";d:1;s:14:"\x00*\x00quantityEnd";d:39.99;s:17:"\x00*\x00shippingMethod";N;s:7:"\x00*\x00rule";N;s:20:"\x00*\x00calculationRuleId";N;s:18:"\x00*\x00calculationRule";N;s:16:"\x00*\x00currencyPrice";O:68:"Shopware\Core\Framework\DataAbstractionLayer\Pricing\PriceCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";O:58:"Shopware\Core\Framework\DataAbstractionLayer\Pricing\Price":8:{s:13:"\x00*\x00extensions";a:0:{}s:13:"\x00*\x00currencyId";s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";s:6:"\x00*\x00net";d:0;s:8:"\x00*\x00gross";d:15;s:9:"\x00*\x00linked";b:0;s:12:"\x00*\x00listPrice";N;s:13:"\x00*\x00percentage";N;s:18:"\x00*\x00regulationPrice";N;}}}s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"01936811367671eca2e9c886ebbb0d31";}s:32:"01936811977f79059b45f1a4b5d51fca";O:87:"Shopware\Core\Checkout\Shipping\Aggregate\ShippingMethodPrice\ShippingMethodPriceEntity":20:{s:13:"\x00*\x00extensions";a:1:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:44:"shipping_method_price_foreign_keys_extension";}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"01936811977f79059b45f1a4b5d51fca";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:0:{}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-11-26 10:43:51.653000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-12-05 09:20:20.616000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:21:"shipping_method_price";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";r:1046;s:19:"\x00*\x00shippingMethodId";s:32:"4c383e3b3b614cc0b029b424becc594d";s:9:"\x00*\x00ruleId";s:32:"0193680ec75f7eed822e403e9cee4325";s:14:"\x00*\x00calculation";i:2;s:16:"\x00*\x00quantityStart";d:90;s:14:"\x00*\x00quantityEnd";N;s:17:"\x00*\x00shippingMethod";N;s:7:"\x00*\x00rule";N;s:20:"\x00*\x00calculationRuleId";N;s:18:"\x00*\x00calculationRule";N;s:16:"\x00*\x00currencyPrice";O:68:"Shopware\Core\Framework\DataAbstractionLayer\Pricing\PriceCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";O:58:"Shopware\Core\Framework\DataAbstractionLayer\Pricing\Price":8:{s:13:"\x00*\x00extensions";a:0:{}s:13:"\x00*\x00currencyId";s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";s:6:"\x00*\x00net";d:0;s:8:"\x00*\x00gross";d:0;s:9:"\x00*\x00linked";b:0;s:12:"\x00*\x00listPrice";N;s:13:"\x00*\x00percentage";N;s:18:"\x00*\x00regulationPrice";N;}}}s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"01936811977f79059b45f1a4b5d51fca";}s:32:"01936811ab4a786ea4193b2b046e8a70";O:87:"Shopware\Core\Checkout\Shipping\Aggregate\ShippingMethodPrice\ShippingMethodPriceEntity":20:{s:13:"\x00*\x00extensions";a:1:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:44:"shipping_method_price_foreign_keys_extension";}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"01936811ab4a786ea4193b2b046e8a70";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:0:{}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-11-26 10:43:51.653000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";N;s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:21:"shipping_method_price";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";r:1046;s:19:"\x00*\x00shippingMethodId";s:32:"4c383e3b3b614cc0b029b424becc594d";s:9:"\x00*\x00ruleId";s:32:"0193680d02647f20bef246e491801607";s:14:"\x00*\x00calculation";i:2;s:16:"\x00*\x00quantityStart";d:1;s:14:"\x00*\x00quantityEnd";d:39.99;s:17:"\x00*\x00shippingMethod";N;s:7:"\x00*\x00rule";N;s:20:"\x00*\x00calculationRuleId";N;s:18:"\x00*\x00calculationRule";N;s:16:"\x00*\x00currencyPrice";O:68:"Shopware\Core\Framework\DataAbstractionLayer\Pricing\PriceCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";O:58:"Shopware\Core\Framework\DataAbstractionLayer\Pricing\Price":8:{s:13:"\x00*\x00extensions";a:0:{}s:13:"\x00*\x00currencyId";s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";s:6:"\x00*\x00net";d:0;s:8:"\x00*\x00gross";d:15;s:9:"\x00*\x00linked";b:0;s:12:"\x00*\x00listPrice";N;s:13:"\x00*\x00percentage";N;s:18:"\x00*\x00regulationPrice";N;}}}s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"01936811ab4a786ea4193b2b046e8a70";}s:32:"01936811e3417efc9b677d5972647ab3";O:87:"Shopware\Core\Checkout\Shipping\Aggregate\ShippingMethodPrice\ShippingMethodPriceEntity":20:{s:13:"\x00*\x00extensions";a:1:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:44:"shipping_method_price_foreign_keys_extension";}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"01936811e3417efc9b677d5972647ab3";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:0:{}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-11-26 10:43:51.654000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-12-05 09:20:20.616000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:21:"shipping_method_price";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";r:1046;s:19:"\x00*\x00shippingMethodId";s:32:"4c383e3b3b614cc0b029b424becc594d";s:9:"\x00*\x00ruleId";s:32:"0193680d02647f20bef246e491801607";s:14:"\x00*\x00calculation";i:2;s:16:"\x00*\x00quantityStart";d:90;s:14:"\x00*\x00quantityEnd";N;s:17:"\x00*\x00shippingMethod";N;s:7:"\x00*\x00rule";N;s:20:"\x00*\x00calculationRuleId";N;s:18:"\x00*\x00calculationRule";N;s:16:"\x00*\x00currencyPrice";O:68:"Shopware\Core\Framework\DataAbstractionLayer\Pricing\PriceCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";O:58:"Shopware\Core\Framework\DataAbstractionLayer\Pricing\Price":8:{s:13:"\x00*\x00extensions";a:0:{}s:13:"\x00*\x00currencyId";s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";s:6:"\x00*\x00net";d:0;s:8:"\x00*\x00gross";d:0;s:9:"\x00*\x00linked";b:0;s:12:"\x00*\x00listPrice";N;s:13:"\x00*\x00percentage";N;s:18:"\x00*\x00regulationPrice";N;}}}s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"01936811e3417efc9b677d5972647ab3";}s:32:"5eb870e9f0c1428e92ad69aa8c27c457";O:87:"Shopware\Core\Checkout\Shipping\Aggregate\ShippingMethodPrice\ShippingMethodPriceEntity":20:{s:13:"\x00*\x00extensions";a:1:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:44:"shipping_method_price_foreign_keys_extension";}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"5eb870e9f0c1428e92ad69aa8c27c457";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:0:{}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2023-02-02 19:49:35.152000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2024-12-05 09:20:20.616000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:21:"shipping_method_price";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";r:1046;s:19:"\x00*\x00shippingMethodId";s:32:"4c383e3b3b614cc0b029b424becc594d";s:9:"\x00*\x00ruleId";s:32:"927794203adc4a079e03fed6d6531484";s:14:"\x00*\x00calculation";i:2;s:16:"\x00*\x00quantityStart";d:90;s:14:"\x00*\x00quantityEnd";N;s:17:"\x00*\x00shippingMethod";N;s:7:"\x00*\x00rule";N;s:20:"\x00*\x00calculationRuleId";N;s:18:"\x00*\x00calculationRule";N;s:16:"\x00*\x00currencyPrice";O:68:"Shopware\Core\Framework\DataAbstractionLayer\Pricing\PriceCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";O:58:"Shopware\Core\Framework\DataAbstractionLayer\Pricing\Price":8:{s:13:"\x00*\x00extensions";a:0:{}s:13:"\x00*\x00currencyId";s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";s:6:"\x00*\x00net";d:0;s:8:"\x00*\x00gross";d:0;s:9:"\x00*\x00linked";b:0;s:12:"\x00*\x00listPrice";N;s:13:"\x00*\x00percentage";N;s:18:"\x00*\x00regulationPrice";N;}}}s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"5eb870e9f0c1428e92ad69aa8c27c457";}s:32:"ad73f7a7ad6949439acab0b56f7a03ec";O:87:"Shopware\Core\Checkout\Shipping\Aggregate\ShippingMethodPrice\ShippingMethodPriceEntity":20:{s:13:"\x00*\x00extensions";a:1:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:44:"shipping_method_price_foreign_keys_extension";}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"ad73f7a7ad6949439acab0b56f7a03ec";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:0:{}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2023-02-02 19:49:35.152000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2023-08-11 08:42:16.058000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:21:"shipping_method_price";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";r:1046;s:19:"\x00*\x00shippingMethodId";s:32:"4c383e3b3b614cc0b029b424becc594d";s:9:"\x00*\x00ruleId";s:32:"927794203adc4a079e03fed6d6531484";s:14:"\x00*\x00calculation";i:2;s:16:"\x00*\x00quantityStart";d:1;s:14:"\x00*\x00quantityEnd";d:39.99;s:17:"\x00*\x00shippingMethod";N;s:7:"\x00*\x00rule";N;s:20:"\x00*\x00calculationRuleId";N;s:18:"\x00*\x00calculationRule";N;s:16:"\x00*\x00currencyPrice";O:68:"Shopware\Core\Framework\DataAbstractionLayer\Pricing\PriceCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";O:58:"Shopware\Core\Framework\DataAbstractionLayer\Pricing\Price":8:{s:13:"\x00*\x00extensions";a:0:{}s:13:"\x00*\x00currencyId";s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";s:6:"\x00*\x00net";d:12.61;s:8:"\x00*\x00gross";d:15;s:9:"\x00*\x00linked";b:0;s:12:"\x00*\x00listPrice";N;s:13:"\x00*\x00percentage";N;s:18:"\x00*\x00regulationPrice";N;}}}s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"ad73f7a7ad6949439acab0b56f7a03ec";}s:32:"c9471d27bec54ac7a4413086c1ec9cb2";O:87:"Shopware\Core\Checkout\Shipping\Aggregate\ShippingMethodPrice\ShippingMethodPriceEntity":20:{s:13:"\x00*\x00extensions";a:1:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:44:"shipping_method_price_foreign_keys_extension";}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"c9471d27bec54ac7a4413086c1ec9cb2";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:0:{}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2021-02-26 10:13:42.801000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2023-08-11 08:42:16.058000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:21:"shipping_method_price";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";r:1046;s:19:"\x00*\x00shippingMethodId";s:32:"4c383e3b3b614cc0b029b424becc594d";s:9:"\x00*\x00ruleId";s:32:"a7ee0560c8f94e509cddeead2a2800e8";s:14:"\x00*\x00calculation";i:1;s:16:"\x00*\x00quantityStart";d:0;s:14:"\x00*\x00quantityEnd";N;s:17:"\x00*\x00shippingMethod";N;s:7:"\x00*\x00rule";N;s:20:"\x00*\x00calculationRuleId";N;s:18:"\x00*\x00calculationRule";N;s:16:"\x00*\x00currencyPrice";O:68:"Shopware\Core\Framework\DataAbstractionLayer\Pricing\PriceCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";O:58:"Shopware\Core\Framework\DataAbstractionLayer\Pricing\Price":8:{s:13:"\x00*\x00extensions";a:0:{}s:13:"\x00*\x00currencyId";s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";s:6:"\x00*\x00net";d:0;s:8:"\x00*\x00gross";d:0;s:9:"\x00*\x00linked";b:0;s:12:"\x00*\x00listPrice";N;s:13:"\x00*\x00percentage";N;s:18:"\x00*\x00regulationPrice";N;}}}s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"c9471d27bec54ac7a4413086c1ec9cb2";}s:32:"d8887e7631464fc6a37377f66aa6ba8c";O:87:"Shopware\Core\Checkout\Shipping\Aggregate\ShippingMethodPrice\ShippingMethodPriceEntity":20:{s:13:"\x00*\x00extensions";a:1:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:44:"shipping_method_price_foreign_keys_extension";}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"d8887e7631464fc6a37377f66aa6ba8c";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:0:{}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2023-02-02 19:49:35.151000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2023-08-11 08:42:16.058000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:21:"shipping_method_price";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";r:1046;s:19:"\x00*\x00shippingMethodId";s:32:"4c383e3b3b614cc0b029b424becc594d";s:9:"\x00*\x00ruleId";s:32:"9f50bea2f50840f6a238fcc2f47d69c5";s:14:"\x00*\x00calculation";i:2;s:16:"\x00*\x00quantityStart";d:1;s:14:"\x00*\x00quantityEnd";d:39.99;s:17:"\x00*\x00shippingMethod";N;s:7:"\x00*\x00rule";N;s:20:"\x00*\x00calculationRuleId";N;s:18:"\x00*\x00calculationRule";N;s:16:"\x00*\x00currencyPrice";O:68:"Shopware\Core\Framework\DataAbstractionLayer\Pricing\PriceCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";O:58:"Shopware\Core\Framework\DataAbstractionLayer\Pricing\Price":8:{s:13:"\x00*\x00extensions";a:0:{}s:13:"\x00*\x00currencyId";s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";s:6:"\x00*\x00net";d:5.04;s:8:"\x00*\x00gross";d:6;s:9:"\x00*\x00linked";b:0;s:12:"\x00*\x00listPrice";N;s:13:"\x00*\x00percentage";N;s:18:"\x00*\x00regulationPrice";N;}}}s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"d8887e7631464fc6a37377f66aa6ba8c";}s:32:"ff1081b90f1043c3b867941f0b5ba9cd";O:87:"Shopware\Core\Checkout\Shipping\Aggregate\ShippingMethodPrice\ShippingMethodPriceEntity":20:{s:13:"\x00*\x00extensions";a:1:{s:11:"foreignKeys";O:42:"Shopware\Core\Framework\Struct\ArrayStruct":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00data";a:0:{}s:11:"\x00*\x00apiAlias";s:44:"shipping_method_price_foreign_keys_extension";}}s:20:"\x00*\x00_uniqueIdentifier";s:32:"ff1081b90f1043c3b867941f0b5ba9cd";s:12:"\x00*\x00versionId";N;s:13:"\x00*\x00translated";a:0:{}s:12:"\x00*\x00createdAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2023-02-02 19:49:35.152000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:12:"\x00*\x00updatedAt";O:17:"DateTimeImmutable":3:{s:4:"date";s:26:"2023-08-11 08:42:16.058000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:64:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_entityName";s:21:"shipping_method_price";s:69:"\x00Shopware\Core\Framework\DataAbstractionLayer\Entity\x00_fieldVisibility";r:1046;s:19:"\x00*\x00shippingMethodId";s:32:"4c383e3b3b614cc0b029b424becc594d";s:9:"\x00*\x00ruleId";s:32:"9f50bea2f50840f6a238fcc2f47d69c5";s:14:"\x00*\x00calculation";i:2;s:16:"\x00*\x00quantityStart";d:40;s:14:"\x00*\x00quantityEnd";N;s:17:"\x00*\x00shippingMethod";N;s:7:"\x00*\x00rule";N;s:20:"\x00*\x00calculationRuleId";N;s:18:"\x00*\x00calculationRule";N;s:16:"\x00*\x00currencyPrice";O:68:"Shopware\Core\Framework\DataAbstractionLayer\Pricing\PriceCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";O:58:"Shopware\Core\Framework\DataAbstractionLayer\Pricing\Price":8:{s:13:"\x00*\x00extensions";a:0:{}s:13:"\x00*\x00currencyId";s:32:"b7d2554b0ce847cd82f3ac9bd1c0dfca";s:6:"\x00*\x00net";d:0;s:8:"\x00*\x00gross";d:0;s:9:"\x00*\x00linked";b:0;s:12:"\x00*\x00listPrice";N;s:13:"\x00*\x00percentage";N;s:18:"\x00*\x00regulationPrice";N;}}}s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"ff1081b90f1043c3b867941f0b5ba9cd";}}}s:10:"\x00*\x00mediaId";N;s:8:"\x00*\x00taxId";N;s:8:"\x00*\x00media";N;s:7:"\x00*\x00tags";N;s:10:"\x00*\x00taxType";s:4:"auto";s:16:"\x00*\x00technicalName";s:17:"shipping_standard";s:6:"\x00*\x00tax";N;s:20:"\x00*\x00appShippingMethod";N;s:15:"\x00*\x00customFields";N;s:5:"\x00*\x00id";s:32:"4c383e3b3b614cc0b029b424becc594d";}s:16:"\x00*\x00shippingCosts";O:56:"Shopware\Core\Checkout\Cart\Price\Struct\CalculatedPrice":9:{s:13:"\x00*\x00extensions";a:0:{}s:12:"\x00*\x00unitPrice";d:0;s:11:"\x00*\x00quantity";i:1;s:13:"\x00*\x00totalPrice";d:0;s:18:"\x00*\x00calculatedTaxes";O:62:"Shopware\Core\Checkout\Cart\Tax\Struct\CalculatedTaxCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{i:19;O:52:"Shopware\Core\Checkout\Cart\Tax\Struct\CalculatedTax":4:{s:13:"\x00*\x00extensions";a:0:{}s:6:"\x00*\x00tax";d:0;s:10:"\x00*\x00taxRate";d:19;s:8:"\x00*\x00price";d:0;}}}s:11:"\x00*\x00taxRules";O:56:"Shopware\Core\Checkout\Cart\Tax\Struct\TaxRuleCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{i:19;O:46:"Shopware\Core\Checkout\Cart\Tax\Struct\TaxRule":3:{s:13:"\x00*\x00extensions";a:0:{}s:10:"\x00*\x00taxRate";d:19;s:13:"\x00*\x00percentage";d:100;}}}s:17:"\x00*\x00referencePrice";N;s:12:"\x00*\x00listPrice";N;s:18:"\x00*\x00regulationPrice";N;}}}}s:15:"\x00*\x00transactions";O:68:"Shopware\Core\Checkout\Cart\Transaction\Struct\TransactionCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:1:{i:0;O:58:"Shopware\Core\Checkout\Cart\Transaction\Struct\Transaction":4:{s:13:"\x00*\x00extensions";a:0:{}s:9:"\x00*\x00amount";O:56:"Shopware\Core\Checkout\Cart\Price\Struct\CalculatedPrice":9:{s:13:"\x00*\x00extensions";a:0:{}s:12:"\x00*\x00unitPrice";d:129;s:11:"\x00*\x00quantity";i:1;s:13:"\x00*\x00totalPrice";d:129;s:18:"\x00*\x00calculatedTaxes";r:11;s:11:"\x00*\x00taxRules";r:19;s:17:"\x00*\x00referencePrice";N;s:12:"\x00*\x00listPrice";N;s:18:"\x00*\x00regulationPrice";N;}s:18:"\x00*\x00paymentMethodId";s:32:"8ccbfa3a17304eea90d09db6fe67ed3d";s:19:"\x00*\x00validationStruct";N;}}}s:11:"\x00*\x00modified";b:0;s:18:"\x00*\x00customerComment";N;s:16:"\x00*\x00affiliateCode";N;s:15:"\x00*\x00campaignCode";N;s:9:"\x00*\x00source";N;s:7:"\x00*\x00hash";N;s:12:"\x00*\x00errorHash";s:0:"";s:38:"\x00Shopware\Core\Checkout\Cart\Cart\x00data";N;s:41:"\x00Shopware\Core\Checkout\Cart\Cart\x00ruleIds";a:12:{i:0;s:32:"9986489395d84086ba454e58b3fb0cd3";i:1;s:32:"d32beefb72e943dc9ed726ccf77b03a2";i:2;s:32:"e4382fa297674cb98d82dc29b451c919";i:3;s:32:"0dff832b47e34b089a714b0b0fd3d6ca";i:4;s:32:"018b18a3f9317975b7c095ab451a5577";i:5;s:32:"2b941507237248d2973e450c493f4e34";i:6;s:32:"5ef1b0cdc8d04b2784fb093d81f229aa";i:7;s:32:"9e07b08e0f1446298608bf1bb807c511";i:8;s:32:"9f50bea2f50840f6a238fcc2f47d69c5";i:9;s:32:"a77b2283528c43e18f85502eb96e0bd5";i:10;s:32:"c71c623517794cedba416ef5711a7a52";i:11;s:32:"da3ac5a0bb8e4657a78e9b98f5656fd5";}s:42:"\x00Shopware\Core\Checkout\Cart\Cart\x00behavior";O:40:"Shopware\Core\Checkout\Cart\CartBehavior":4:{s:13:"\x00*\x00extensions";a:0:{}s:53:"\x00Shopware\Core\Checkout\Cart\CartBehavior\x00permissions";a:0:{}s:51:"\x00Shopware\Core\Checkout\Cart\CartBehavior\x00hookAware";b:1;s:57:"\x00Shopware\Core\Checkout\Cart\CartBehavior\x00isRecalculation";b:0;}s:8:"\x00*\x00token";s:32:"ltQoKGxpTGEgp2YH6HBuBxKQab5FV6eq";s:9:"\x00*\x00states";a:0:{}}"
  "rule_ids" => "["9986489395d84086ba454e58b3fb0cd3","d32beefb72e943dc9ed726ccf77b03a2","e4382fa297674cb98d82dc29b451c919","0dff832b47e34b089a714b0b0fd3d6ca","018b18a3f9317975b7c095ab451a5577","2b941507237248d2973e450c493f4e34","5ef1b0cdc8d04b2784fb093d81f229aa","9e07b08e0f1446298608bf1bb807c511","9f50bea2f50840f6a238fcc2f47d69c5","a77b2283528c43e18f85502eb96e0bd5","c71c623517794cedba416ef5711a7a52","da3ac5a0bb8e4657a78e9b98f5656fd5"]"
  "now" => "2024-12-23 19:29:43.847"
  "compressed" => 0
]
75 0.38 ms
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  b"™†H“•Ø@†ºENX³û\fÓ"
  b"Ó+îûréCÜž×&Ì÷{\x03¢"
  b"õ8/óùgL╣ìé▄)┤Q╔\x19"
  b"\rÿƒ+GãK\x08šqK\v\x0FÓÖÊ"
  b"\x01\x18£ù1yu·À•«E\x1AUw"
  b"+”\x15\x07#rHÒ—>E\fI?N4"
  b"^±░═╚ðK'ä¹\t=ü‗)¬"
  b"ž\x07°Ž\x0F\x14F)†\x08¿\e¸\x07Å\x11"
  b"ŸP¾¢õ\x08@ö¢8üÂô}iÅ"
  b"º{"âRîCßÅàP.╣n\vı"
  b"Ç\x1Cb5\x17yLíºAnõq\x1AzR"
  b"Ú:Å »ŽFW§Ž›˜õeoÕ"
]

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.