GET https://dev.cas-technik.de/navigation/018f6e8823ec73e281019fb0a0c6ffc4?freeInput=MP-175-7

Response
200 OK
IP
216.73.216.31
Profiled on
Token
b749e3

Query Metrics

95 Database Queries
77 Different statements
226.14 ms Query time

Queries

Group similar statements

#▲ Time Info
1 0.45 ms 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2 1.00 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.40 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.33 ms 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.56 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
6 1.53 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"4U0/þõH÷—÷5’6\x1Cç¡"
  "navigation/informationen/produktfrage"
  "navigation/informationen/produktfrage/"
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.47 ms 
SELECT `name`, `path`, `author`, `self_managed`
                FROM `app`
                WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
8 54.77 ms 
SELECT `scop_platform_redirecter_redirect`.`id` FROM `scop_platform_redirecter_redirect` WHERE (`scop_platform_redirecter_redirect`.`sourceURL` IN (?, ?, ?, ?, ?, ?, ?) AND `scop_platform_redirecter_redirect`.`enabled` = ? AND (`scop_platform_redirecter_redirect`.`salesChannelId` = ? OR `scop_platform_redirecter_redirect`.`salesChannelId` <=> ?)) LIMIT 1
Parameters: 
[
  "//navigation/informationen/produktfrage?freeInput=MP-175-7"
  "/navigation/informationen/produktfrage?freeInput=MP-175-7"
  "https://dev.cas-technik.de/navigation/informationen/produktfrage?freeInput=MP-175-7"
  "https://dev.cas-technik.de//navigation/informationen/produktfrage?freeInput=MP-175-7"
  "/navigation/informationen/produktfrage?freeInput=MP-175-7"
  "//navigation/informationen/produktfrage?freeInput=MP-175-7"
  "navigation/informationen/produktfrage?freeInput=MP-175-7"
  true
  b"4U0/þõH÷—÷5’6\x1Cç¡"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
9 54.56 ms 
SELECT `scop_platform_redirecter_redirect`.`id` FROM `scop_platform_redirecter_redirect` WHERE (`scop_platform_redirecter_redirect`.`sourceURL` IN (?, ?, ?, ?, ?, ?, ?) AND `scop_platform_redirecter_redirect`.`enabled` = ? AND `scop_platform_redirecter_redirect`.`queryParamsHandling` IN (?, ?)) LIMIT 1
Parameters: 
[
  "//navigation/informationen/produktfrage"
  "/navigation/informationen/produktfrage"
  "https://dev.cas-technik.de/navigation/informationen/produktfrage"
  "https://dev.cas-technik.de//navigation/informationen/produktfrage"
  "/navigation/informationen/produktfrage"
  "//navigation/informationen/produktfrage"
  "navigation/informationen/produktfrage"
  true
  1
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.48 ms 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"4U0/þõH÷—÷5’6\x1Cç¡"
  "0VthiogIldSUzrUu1wjgUkVaggn3Nlvy"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.79 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"4U0/þõH÷—÷5’6\x1Cç¡"
]
View formatted query    View runnable query    Explain query    View query backtrace
12 1.42 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.netiCurrency`.`id` as `sales_channel.currency.netiCurrency.id`, `sales_channel.currency.netiCurrency`.`currency_id` as `sales_channel.currency.netiCurrency.currencyID`, `sales_channel.currency.netiCurrency`.`active` as `sales_channel.currency.netiCurrency.active`, `sales_channel.currency.netiCurrency`.`buffer` as `sales_channel.currency.netiCurrency.buffer`, `sales_channel.currency.netiCurrency`.`last_factor` as `sales_channel.currency.netiCurrency.lastFactor`, `sales_channel.currency.netiCurrency`.`last_update` as `sales_channel.currency.netiCurrency.lastUpdate`, `sales_channel.currency.netiCurrency`.`created_at` as `sales_channel.currency.netiCurrency.createdAt`, `sales_channel.currency.netiCurrency`.`updated_at` as `sales_channel.currency.netiCurrency.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 `neti_current_currencies_currency` `sales_channel.currency.netiCurrency` ON `sales_channel.currency`.`id` = `sales_channel.currency.netiCurrency`.`currency_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"4U0/þõH÷—÷5’6\x1Cç¡"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.51 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"4U0/þõH÷—÷5’6\x1Cç¡"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.53 ms 
SELECT LOWER(HEX(`language.salesChannels.mapping`.`sales_channel_id`)) as `key`, GROUP_CONCAT(LOWER(HEX(`language.salesChannels.mapping`.`language_id`)) ) as `value` FROM `language` LEFT JOIN `sales_channel_language` `language.salesChannels.mapping` ON `language.salesChannels.mapping`.`language_id` = `language`.id WHERE ((`language`.`id` = ?)) AND (`language.salesChannels.mapping`.`sales_channel_id` IN (?)) GROUP BY `language.salesChannels.mapping`.`sales_channel_id`
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"4U0/þõH÷—÷5’6\x1Cç¡"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 1.07 ms 
# base-context-factory::sales-channel::association::languages::read
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.translationCode`.`id` as `language.translationCode.id`, `language.translationCode`.`code` as `language.translationCode.code`, `language.translationCode`.`created_at` as `language.translationCode.createdAt`, `language.translationCode`.`updated_at` as `language.translationCode.updatedAt`, `language.translationCode.translation.name`, `language.translationCode.translation.name` as `language.translationCode.name`, `language.translationCode.translation.territory`, `language.translationCode.translation.territory` as `language.translationCode.territory`, `language.translationCode.translation.customFields`, `language.translationCode.translation.customFields` as `language.translationCode.customFields`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.name`, `language.locale.translation.name` as `language.locale.name`, `language.locale.translation.territory`, `language.locale.translation.territory` as `language.locale.territory`, `language.locale.translation.customFields`, `language.locale.translation.customFields` as `language.locale.customFields` FROM `language` LEFT JOIN `locale` `language.translationCode` ON `language`.`translation_code_id` = `language.translationCode`.`id` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.translationCode.translation`.`locale_id`, `language.translationCode.translation`.`name` as `language.translationCode.translation.name`, `language.translationCode.translation`.`territory` as `language.translationCode.translation.territory`, `language.translationCode.translation`.`custom_fields` as `language.translationCode.translation.customFields` FROM `locale_translation` `language.translationCode.translation` WHERE `language.translationCode.translation`.`language_id` = ?) `language.translationCode.locale_translation` ON `language.translationCode.locale_translation`.`locale_id` = `language.translationCode`.`id` LEFT JOIN (SELECT `language.locale.translation`.`locale_id`, `language.locale.translation`.`name` as `language.locale.translation.name`, `language.locale.translation`.`territory` as `language.locale.translation.territory`, `language.locale.translation`.`custom_fields` as `language.locale.translation.customFields` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation`.`language_id` = ?) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE ((`language`.`id` = ?)) AND (`language`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.83 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.netiCurrency`.`id` as `currency.netiCurrency.id`, `currency.netiCurrency`.`currency_id` as `currency.netiCurrency.currencyID`, `currency.netiCurrency`.`active` as `currency.netiCurrency.active`, `currency.netiCurrency`.`buffer` as `currency.netiCurrency.buffer`, `currency.netiCurrency`.`last_factor` as `currency.netiCurrency.lastFactor`, `currency.netiCurrency`.`last_update` as `currency.netiCurrency.lastUpdate`, `currency.netiCurrency`.`created_at` as `currency.netiCurrency.createdAt`, `currency.netiCurrency`.`updated_at` as `currency.netiCurrency.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 `neti_current_currencies_currency` `currency.netiCurrency` ON `currency`.`id` = `currency.netiCurrency`.`currency_id` 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Í‚ó¬›ÑÀßÊ"
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.76 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"Pß|Š¡>L™€´+\x1F\x04ã¬ò"
]
View formatted query    View runnable query    Explain query    View query backtrace
18 1.14 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.translation.name`, `customer_group.translation.name` as `customer_group.name`, `customer_group.translation.registrationTitle`, `customer_group.translation.registrationTitle` as `customer_group.registrationTitle`, `customer_group.translation.registrationIntroduction`, `customer_group.translation.registrationIntroduction` as `customer_group.registrationIntroduction`, `customer_group.translation.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationOnlyCompanyRegistration` as `customer_group.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationSeoMetaDescription`, `customer_group.translation.registrationSeoMetaDescription` as `customer_group.registrationSeoMetaDescription`, `customer_group.translation.customFields`, `customer_group.translation.customFields` as `customer_group.customFields` FROM `customer_group` LEFT JOIN (SELECT `customer_group.translation`.`customer_group_id`, `customer_group.translation`.`name` as `customer_group.translation.name`, `customer_group.translation`.`custom_fields` as `customer_group.translation.customFields`, `customer_group.translation`.`registration_title` as `customer_group.translation.registrationTitle`, `customer_group.translation`.`registration_introduction` as `customer_group.translation.registrationIntroduction`, `customer_group.translation`.`registration_only_company_registration` as `customer_group.translation.registrationOnlyCompanyRegistration`, `customer_group.translation`.`registration_seo_meta_description` as `customer_group.translation.registrationSeoMetaDescription` FROM `customer_group_translation` `customer_group.translation` WHERE `customer_group.translation`.`language_id` = ?) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation`.`customer_group_id` = `customer_group`.`id` WHERE `customer_group`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x11Õ9ÿT¡CWƒOÖ¥Ú+Óè"
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.44 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
20 1.05 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"\x05˜\x18!ñOGC…ÛHæ«\x17M_"
  b"\x07\x17Ô¯ø.M\ežj¥Ìö˜æÁ"
  b"5A£Ÿü3O'¿ÿÌ1\x1EbÝå"
]
View formatted query    View runnable query    Explain query    View query backtrace
21 1.20 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`.`file_hash` as `payment_method.media.fileHash`, `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"\x1F€¨bQ=B۝\x07ùWè\x01‹ž"
]
View formatted query    View runnable query    Explain query    View query backtrace
22 1.42 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`.`file_hash` as `shipping_method.media.fileHash`, `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"ÁŽÌ{%þO;“OÙ4Ë’î¢"
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.44 ms 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.56 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"Pß|Š¡>L™€´+\x1F\x04ã¬ò"
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.75 ms 
SELECT `acris_tax_switch`.`id` FROM `acris_tax_switch` WHERE (`acris_tax_switch`.`version_id` = ?) AND ((`acris_tax_switch`.`active` = ?)) ORDER BY LENGTH(`acris_tax_switch`.`priority`) DESC, `acris_tax_switch`.`priority` DESC
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
26 1.57 ms 
SELECT `acris_tax_switch`.`id` as `acris_tax_switch.id`, `acris_tax_switch`.`version_id` as `acris_tax_switch.versionId`, `acris_tax_switch`.`name` as `acris_tax_switch.name`, `acris_tax_switch`.`active` as `acris_tax_switch.active`, `acris_tax_switch`.`priority` as `acris_tax_switch.priority`, `acris_tax_switch`.`header` as `acris_tax_switch.header`, `acris_tax_switch`.`next_to_price` as `acris_tax_switch.nextToPrice`, `acris_tax_switch`.`modal` as `acris_tax_switch.modal`, `acris_tax_switch`.`gross_customer_group_id` as `acris_tax_switch.grossCustomerGroupId`, `acris_tax_switch`.`net_customer_group_id` as `acris_tax_switch.netCustomerGroupId`, `acris_tax_switch`.`i_am_preselect` as `acris_tax_switch.iAmPreselect`, `acris_tax_switch`.`gross_background_color` as `acris_tax_switch.grossBackgroundColor`, `acris_tax_switch`.`gross_color` as `acris_tax_switch.grossColor`, `acris_tax_switch`.`net_background_color` as `acris_tax_switch.netBackgroundColor`, `acris_tax_switch`.`net_color` as `acris_tax_switch.netColor`, `acris_tax_switch`.`created_at` as `acris_tax_switch.createdAt`, `acris_tax_switch`.`updated_at` as `acris_tax_switch.updatedAt`, (SELECT GROUP_CONCAT(HEX(`acris_tax_switch.rules.mapping`.`rule_id`) SEPARATOR '||')
                  FROM `acris_tax_switch_rule` `acris_tax_switch.rules.mapping`
                  WHERE `acris_tax_switch.rules.mapping`.`tax_switch_id` = `acris_tax_switch`.`id` ) as `acris_tax_switch.rules.id_mapping`, `acris_tax_switch.grossCustomerGroup`.`id` as `acris_tax_switch.grossCustomerGroup.id`, `acris_tax_switch.grossCustomerGroup`.`display_gross` as `acris_tax_switch.grossCustomerGroup.displayGross`, `acris_tax_switch.grossCustomerGroup`.`registration_active` as `acris_tax_switch.grossCustomerGroup.registrationActive`, `acris_tax_switch.grossCustomerGroup`.`created_at` as `acris_tax_switch.grossCustomerGroup.createdAt`, `acris_tax_switch.grossCustomerGroup`.`updated_at` as `acris_tax_switch.grossCustomerGroup.updatedAt`, `acris_tax_switch.grossCustomerGroup.translation.name`, `acris_tax_switch.grossCustomerGroup.translation.name` as `acris_tax_switch.grossCustomerGroup.name`, `acris_tax_switch.grossCustomerGroup.translation.registrationTitle`, `acris_tax_switch.grossCustomerGroup.translation.registrationTitle` as `acris_tax_switch.grossCustomerGroup.registrationTitle`, `acris_tax_switch.grossCustomerGroup.translation.registrationIntroduction`, `acris_tax_switch.grossCustomerGroup.translation.registrationIntroduction` as `acris_tax_switch.grossCustomerGroup.registrationIntroduction`, `acris_tax_switch.grossCustomerGroup.translation.registrationOnlyCompanyRegistration`, `acris_tax_switch.grossCustomerGroup.translation.registrationOnlyCompanyRegistration` as `acris_tax_switch.grossCustomerGroup.registrationOnlyCompanyRegistration`, `acris_tax_switch.grossCustomerGroup.translation.registrationSeoMetaDescription`, `acris_tax_switch.grossCustomerGroup.translation.registrationSeoMetaDescription` as `acris_tax_switch.grossCustomerGroup.registrationSeoMetaDescription`, `acris_tax_switch.grossCustomerGroup.translation.customFields`, `acris_tax_switch.grossCustomerGroup.translation.customFields` as `acris_tax_switch.grossCustomerGroup.customFields`, `acris_tax_switch.netCustomerGroup`.`id` as `acris_tax_switch.netCustomerGroup.id`, `acris_tax_switch.netCustomerGroup`.`display_gross` as `acris_tax_switch.netCustomerGroup.displayGross`, `acris_tax_switch.netCustomerGroup`.`registration_active` as `acris_tax_switch.netCustomerGroup.registrationActive`, `acris_tax_switch.netCustomerGroup`.`created_at` as `acris_tax_switch.netCustomerGroup.createdAt`, `acris_tax_switch.netCustomerGroup`.`updated_at` as `acris_tax_switch.netCustomerGroup.updatedAt`, `acris_tax_switch.netCustomerGroup.translation.name`, `acris_tax_switch.netCustomerGroup.translation.name` as `acris_tax_switch.netCustomerGroup.name`, `acris_tax_switch.netCustomerGroup.translation.registrationTitle`, `acris_tax_switch.netCustomerGroup.translation.registrationTitle` as `acris_tax_switch.netCustomerGroup.registrationTitle`, `acris_tax_switch.netCustomerGroup.translation.registrationIntroduction`, `acris_tax_switch.netCustomerGroup.translation.registrationIntroduction` as `acris_tax_switch.netCustomerGroup.registrationIntroduction`, `acris_tax_switch.netCustomerGroup.translation.registrationOnlyCompanyRegistration`, `acris_tax_switch.netCustomerGroup.translation.registrationOnlyCompanyRegistration` as `acris_tax_switch.netCustomerGroup.registrationOnlyCompanyRegistration`, `acris_tax_switch.netCustomerGroup.translation.registrationSeoMetaDescription`, `acris_tax_switch.netCustomerGroup.translation.registrationSeoMetaDescription` as `acris_tax_switch.netCustomerGroup.registrationSeoMetaDescription`, `acris_tax_switch.netCustomerGroup.translation.customFields`, `acris_tax_switch.netCustomerGroup.translation.customFields` as `acris_tax_switch.netCustomerGroup.customFields`, `acris_tax_switch.translation.modalTitleText`, `acris_tax_switch.translation.modalTitleText` as `acris_tax_switch.modalTitleText`, `acris_tax_switch.translation.modalContentText`, `acris_tax_switch.translation.modalContentText` as `acris_tax_switch.modalContentText`, `acris_tax_switch.translation.grossButtonText`, `acris_tax_switch.translation.grossButtonText` as `acris_tax_switch.grossButtonText`, `acris_tax_switch.translation.netButtonText`, `acris_tax_switch.translation.netButtonText` as `acris_tax_switch.netButtonText`, `acris_tax_switch.translation.topBarGrossText`, `acris_tax_switch.translation.topBarGrossText` as `acris_tax_switch.topBarGrossText`, `acris_tax_switch.translation.topBarNetText`, `acris_tax_switch.translation.topBarNetText` as `acris_tax_switch.topBarNetText`, `acris_tax_switch.translation.productDetailGrossText`, `acris_tax_switch.translation.productDetailGrossText` as `acris_tax_switch.productDetailGrossText`, `acris_tax_switch.translation.productDetailNetText`, `acris_tax_switch.translation.productDetailNetText` as `acris_tax_switch.productDetailNetText`, `acris_tax_switch.translation.customFields`, `acris_tax_switch.translation.customFields` as `acris_tax_switch.customFields` FROM `acris_tax_switch` LEFT JOIN `customer_group` `acris_tax_switch.grossCustomerGroup` ON `acris_tax_switch`.`gross_customer_group_id` = `acris_tax_switch.grossCustomerGroup`.`id` LEFT JOIN `customer_group` `acris_tax_switch.netCustomerGroup` ON `acris_tax_switch`.`net_customer_group_id` = `acris_tax_switch.netCustomerGroup`.`id` LEFT JOIN (SELECT `acris_tax_switch.translation`.`acris_tax_switch_id`, `acris_tax_switch.translation`.`acris_tax_switch_version_id`, `acris_tax_switch.translation`.`modal_title_text` as `acris_tax_switch.translation.modalTitleText`, `acris_tax_switch.translation`.`modal_content_text` as `acris_tax_switch.translation.modalContentText`, `acris_tax_switch.translation`.`gross_button_text` as `acris_tax_switch.translation.grossButtonText`, `acris_tax_switch.translation`.`net_button_text` as `acris_tax_switch.translation.netButtonText`, `acris_tax_switch.translation`.`top_bar_gross_text` as `acris_tax_switch.translation.topBarGrossText`, `acris_tax_switch.translation`.`top_bar_net_text` as `acris_tax_switch.translation.topBarNetText`, `acris_tax_switch.translation`.`product_detail_gross_text` as `acris_tax_switch.translation.productDetailGrossText`, `acris_tax_switch.translation`.`product_detail_net_text` as `acris_tax_switch.translation.productDetailNetText`, `acris_tax_switch.translation`.`custom_fields` as `acris_tax_switch.translation.customFields` FROM `acris_tax_switch_translation` `acris_tax_switch.translation` WHERE `acris_tax_switch.translation`.`language_id` = ?) `acris_tax_switch.acris_tax_switch_translation` ON `acris_tax_switch.acris_tax_switch_translation`.`acris_tax_switch_id` = `acris_tax_switch`.`id` AND `acris_tax_switch.acris_tax_switch_translation`.`acris_tax_switch_version_id` = `acris_tax_switch`.`version_id` LEFT JOIN (SELECT `acris_tax_switch.grossCustomerGroup.translation`.`customer_group_id`, `acris_tax_switch.grossCustomerGroup.translation`.`name` as `acris_tax_switch.grossCustomerGroup.translation.name`, `acris_tax_switch.grossCustomerGroup.translation`.`custom_fields` as `acris_tax_switch.grossCustomerGroup.translation.customFields`, `acris_tax_switch.grossCustomerGroup.translation`.`registration_title` as `acris_tax_switch.grossCustomerGroup.translation.registrationTitle`, `acris_tax_switch.grossCustomerGroup.translation`.`registration_introduction` as `acris_tax_switch.grossCustomerGroup.translation.registrationIntroduction`, `acris_tax_switch.grossCustomerGroup.translation`.`registration_only_company_registration` as `acris_tax_switch.grossCustomerGroup.translation.registrationOnlyCompanyRegistration`, `acris_tax_switch.grossCustomerGroup.translation`.`registration_seo_meta_description` as `acris_tax_switch.grossCustomerGroup.translation.registrationSeoMetaDescription` FROM `customer_group_translation` `acris_tax_switch.grossCustomerGroup.translation` WHERE `acris_tax_switch.grossCustomerGroup.translation`.`language_id` = ?) `acris_tax_switch.grossCustomerGroup.customer_group_translation` ON `acris_tax_switch.grossCustomerGroup.customer_group_translation`.`customer_group_id` = `acris_tax_switch.grossCustomerGroup`.`id` LEFT JOIN (SELECT `acris_tax_switch.netCustomerGroup.translation`.`customer_group_id`, `acris_tax_switch.netCustomerGroup.translation`.`name` as `acris_tax_switch.netCustomerGroup.translation.name`, `acris_tax_switch.netCustomerGroup.translation`.`custom_fields` as `acris_tax_switch.netCustomerGroup.translation.customFields`, `acris_tax_switch.netCustomerGroup.translation`.`registration_title` as `acris_tax_switch.netCustomerGroup.translation.registrationTitle`, `acris_tax_switch.netCustomerGroup.translation`.`registration_introduction` as `acris_tax_switch.netCustomerGroup.translation.registrationIntroduction`, `acris_tax_switch.netCustomerGroup.translation`.`registration_only_company_registration` as `acris_tax_switch.netCustomerGroup.translation.registrationOnlyCompanyRegistration`, `acris_tax_switch.netCustomerGroup.translation`.`registration_seo_meta_description` as `acris_tax_switch.netCustomerGroup.translation.registrationSeoMetaDescription` FROM `customer_group_translation` `acris_tax_switch.netCustomerGroup.translation` WHERE `acris_tax_switch.netCustomerGroup.translation`.`language_id` = ?) `acris_tax_switch.netCustomerGroup.customer_group_translation` ON `acris_tax_switch.netCustomerGroup.customer_group_translation`.`customer_group_id` = `acris_tax_switch.netCustomerGroup`.`id` WHERE (`acris_tax_switch`.`version_id` = ?) AND (`acris_tax_switch`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"""
    \x01Œ}CÃ{pÓ´q¼\n
    „m.±
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.41 ms 
#cart-persister::load
            SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters: 
[
  "0VthiogIldSUzrUu1wjgUkVaggn3Nlvy"
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.40 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
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.50 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Ž^ .Ôr^®Þe—ˆU\x180"
  b"\x01Ž^ .ÿrÈ¿ÇJC²§\eÅ"
  b"\x01Ž^ /\x08qW‚ö\x1E`ÝÄÞÀ"
  b"\x01Ž^ /\x0Er4Ÿh\x08ág°._"
  b"\x01Ž^ /\x18sᑁËÖÙ¬M"
  b"\x01Ž^ /)q†¿j¡æD¢%"
  b"\x01“>Vá³\x7FZ”\tD \x15D;}"
  b"\x01“>[”\x7Fx¸¾‡n\x02©þmK"
  b"\x01™¹Q¦VqÑ©P†uP\x10zG"
  b"\x08d¯\x107\F\x04§tOVS\x158G"
  b"jME~ÙMËŒ#—\x12¸õÑ\f"
  b"~lÝ\x0F`II.º,­%‚Ÿ~8"
  b"v†$ehJ\f¾T&4°+Wô"
  b"’\x03\x16F«RC‚«èQ\x00"ø…0"
  b"’EcMjVF: ŸIˆ^Wá""
  b"õÆ“è)“Fv¢Lïѳ€\x1C"
  b"7žhªàrK^¡ÁÙ"È?“\x08"
  b"Ò…ë)RÔBË»ywè\x1F5íä"
  b"×\x16³ŽbÛC:°\x1Fçdä\x7FŸk"
  b"\x01Ž=ºõ`\x7Fı‚Ô½‹’Ïñ"
  b"\x01Q®~\x14p¢ ²1vÞя\x04"
  b"\x01™ë±L){€®„b\x1EH\x19É="
  b"\x01š%¹†"xLªå5ª–c”\v"
  b"\x1AuÕů\tEP½†å¹G}…}"
  b"¿TRŸëó#ì}'%k\x17‚\x07õ"
  b"äNg‚ÆBG·–¸‘Ï%®8÷"
  b"ô¸ç\x17F¹M\e…6\x08\frñ\fi"
  b"""
    \n
    ¾oŽH‘Bʱ¾\x06[ý\x1D†Ž
    """
  b"""
    \x19Ûç\±qKæ£ý-Älñ\n
    "
    """
  b"f\x03C´DMG•¢òxEÑR†&"
  b"†Px\x07.ÒDì óþJ²Zòñ"
  b"ì&ŒÁb8CPªi\x02ù#ù5X"
  b"ÿ}ŽŽý¢Fæ‡\x0E<\x08L÷\x031"
]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.42 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"4U0/þõH÷—÷5’6\x1Cç¡"
  b"Pß|Š¡>L™€´+\x1F\x04ã¬ò"
]
View formatted query    View runnable query    Explain query    View query backtrace
31 2.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"4U0/þõH÷—÷5’6\x1Cç¡"
]
View formatted query    View runnable query    Explain query    View query backtrace
32 1.14 ms 
# navigation-route::meta-information
            SELECT LOWER(HEX(`id`)), `path`, `level`
            FROM `category`
            WHERE `id` = ? OR `parent_id` = ? OR `id` = ?
Parameters: 
[
  b"°¶½5§aG1¸¾'\tóX‹Ÿ"
  b"°¶½5§aG1¸¾'\tóX‹Ÿ"
  b"°¶½5§aG1¸¾'\tóX‹Ÿ"
]
View formatted query    View runnable query    Explain query    View query backtrace
33 15.66 ms 
# header::navigation::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`file_hash` as `category.media.fileHash`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, `category.media.translation.title` as `category.media.title`, `category.media.translation.alt`, `category.media.translation.alt` as `category.media.alt`, `category.media.translation.customFields`, `category.media.translation.customFields` as `category.media.customFields`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.`language_id` = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND ((`category`.`path` LIKE ? AND (`category`.`level` > ? AND `category`.`level` <= ?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  "%|b0b6bd35a7614731b8be2709f3588b9f|%"
  1
  12
]
View formatted query    View runnable query    Explain query    View query backtrace
34 8.99 ms 
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `swag_dynamic_access_category_rule` `category.swagDynamicAccessRules.mapping` ON `category`.`id` = `category.swagDynamicAccessRules.mapping`.`category_id`  AND `category`.`version_id` = `category.swagDynamicAccessRules.mapping`.`category_version_id` LEFT JOIN `rule` `category.swagDynamicAccessRules` ON `category.swagDynamicAccessRules.mapping`.`rule_id` = `category.swagDynamicAccessRules`.`id`  WHERE (`category`.`version_id` = ?) AND (((`category.swagDynamicAccessRules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?) OR `category.swagDynamicAccessRules`.`id` <=> ?))) AND (`category`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY `category`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01Ž^ /\x08qW‚ö\x1E`ÝÄÞÀ"
  b"\x08d¯\x107\F\x04§tOVS\x158G"
  b"jME~ÙMËŒ#—\x12¸õÑ\f"
  b"õÆ“è)“Fv¢Lïѳ€\x1C"
  b"7žhªàrK^¡ÁÙ"È?“\x08"
  b"\x01Ž=ºõ`\x7Fı‚Ô½‹’Ïñ"
  b"\x01Q®~\x14p¢ ²1vÞя\x04"
  b"äNg‚ÆBG·–¸‘Ï%®8÷"
  b"""
    \n
    ¾oŽH‘Bʱ¾\x06[ý\x1D†Ž
    """
  null
  b"\x00PU·H\x08¿÷¬@àu̸"
  b"\x00ÍOB6çI´¨›TH¥À~Š"
  b"\x01Š\x19‘»ÎLà³hà`˜X"
  b"\x01Ž\x11¸q\x17s)ª¿›Hêü8°"
  b"\x01Ž\x11¸q\x19p†ŠNÓ\x064'`R"
  b"\x01nˆ#ìsâ\x01Ÿ° ÆÿÄ"
  b"\x01š¦\x1FápÎ…Õ.\x14«ëU×"
  b"\x01¾7¾xs‹2t±6\x06nà"
  b"""
    \x01“\x03&\n
    Ë@8ƒÝÝÄ_A¾\x12
    """
  b"\x01•¯[Ã4p"²çŸÉnR¡i"
  b"\x01•¯[Å\x1Fs§¼\x18-¼„ïPÃ"
  b"\x01—éÔ÷:sé¿Íô\v¿d°A"
  b"\x01—éÔþ‡q`¤½1¿Ð…5""
  b"\x01—éÕ1ísƒ!›\x7F÷œ\x104"
  b"\x02\v÷-\iEfŒÚq\x02ó9” "
  b"\x02EU‡ÛçD\x1C³\vb\vÒ"¬;"
  b"\x02\»\x13Ä\x7FB–ƒ1L\x02YÞ\x0E"
  b"""
    \x03çE\n
    àBè¬lkò\x02=\x08o
    """
  b"\x04ŸÑ\x14S›C¢»Üq’Î\x19æ9"
  b"\x05\x1F¨u6²JÕˆŽä5.¶mÍ"
  b"\x06/\x14ùÉ H}°.®Z>šÛ\x11"
  b"\x07^èãþöD^”£G\x11@º¥þ"
  b"\x07ñÔ³8ùM:–?«~¤Å¼Ì"
  b"\x08ƒ9mo—F\x18±&VƒâΉô"
  b"\x08ŒÎG\x07RGàŽ:‡-Y\x16ص"
  b"\tuåA¯àA}•\tº†–\x16ÕÆ"
  b"\tÉl¾¦iG!¦AU~8™÷“"
  b"\té\x08vrHI-“:RË?Ÿ\x11{"
  b"""
    \n
    \x0F\x13Õ±\vFÔ›–Ð?÷Ž,ÿ
    """
  b"\v8Èu0æH ‰ÓäØ»\x1AÜð"
  b"\v¨~\x04¦øF|¬ñ}ö\x1E“Ð\v"
  b"\fJÝ\x7FûÙCó ­ñ`\x14\x05šZ"
  b"""
    \r\n
    -!¿ÁIo¾A9êªmï#
    """
  b"\rEì¶í=OÖ…¼/»Á >Ì"
  b"\rbBøApHx¼‚\x18yÝ\v&ü"
  b"\x0Eƒ{\r‚ÕCC¿\x02¥Œ0\x12\x11\x1C"
  b"\x0EŽ_5˜\x00LGˆŽïV÷l&Š"
  b"\x0Fè·}õ‹Fw’u)L”{Ù\x05"
  b"\x10:"Êâ+IŒžüp,<7€®"
  b"\x10_ÃõÈ=FwŽí›85]Û^"
  b"\x10xèÏî8C<“=F•D„›Ý"
  b"\x10}¾æ{FHl´èù¨\x19#\x03Í"
  b"\x10Âf)è\x13Fñ”þi{zuâ”"
  b"\x11šãÑ&DI_¦óaƒdË·'"
  b"\x11ªŠòå‘C7¸\x01Gû;A\x7F\x01"
  b"""
    \x11è\n
    eM3M®‹\n
    †R"‘H˜
    """
  b"\x12\x1F\eÃ>ÊEZ¥ËWÏ\x1C^îO"
  b"\x13’`\x1F3,BŠ½LÇ9\x07\x12Y"
  b"\x14A\x1D,¡YDOŒˆD\x03tÚ˜Î"
  b"\x14v°Ê\x15}AA’ÿ\x1Að\x1E ý“"
  b"\x15\x18ý·z¢K\r­\x08ýOåv\x05\x0F"
  b"\x15vCÀÿÝ@̹Â'H—•.\x0F"
  b"\x15ÙŶàMFF£\x05\x0FÃü/„ß"
  b"""
    \x16­W\x1D\x12„D„ŸÐˆ7\x18\n
    \x1Eð
    """
  b"\x16Ö‚\x06\x11„H\x18²\x1F\x02Û\x15_Uq"
  b"\x16àÓ1PAD\x16ˆ…Ňš«ù="
  b"\x16óÑmºÊG\t•vHn\x19\x04§ "
  b"\x17\x19Ú¾\x0EcG¬³!šwõɽï"
  b"\x182)ŠýíCкûOšßû\x7F{"
  b"\x18¤…\x00L&E…§Y\x1FÞóöH"
  b"\x19ï\x00<Q\x07MÁ•4R\x0E}\x1A`J"
  b"\x1A\r'wA–N+¶•7þ|ŸÿŽ"
  b"\x1A.U¤OäD-»˜†Î„Kv»"
  b"\x1AÎîò›CÔ„D\x10–ÃÎ\x033"
  b"\e;\x07°÷ñBJ»ÞL\x08?–Yp"
  b"\eåØÒ JOÁµ‰\x19{œZ´"
  b"\eü–c©ŽCî—j]r¡öùR"
  b"\x1CéZ]F+NÛ¯rä\v†„½"
  b"\x1E˜\x12¹*.DƶAìîT(­‡"
  b"\x1FH¡d­ÄBñ‘ýá\x0EÂ=~…"
  b"\x1FŸÕ¢þÖN\x17\x1EáDr\x0EÈ"
  b" O5€ç¨Dj¡&A\tZýgn"
  b"!anæ\x18NG\x06ŽK\x03Ú'Š\x10¥"
  b"!¿°&‡sC2\x10f逅º\x11"
  b"" \x17âT\x11M­œÈ.¾Ü)^"
  b"">\])Nœ£>I¡‡“\x01;"
  b"$µŸ¦å™B7´xŽN\e…ýB"
  b"$Òx‰#OO•ˆ‹HçùIS¼"
  b"%\x18Ô†\x15bK\x0F–ô\x02®é™%—"
  b"%1‰Š$QB3«Z\fïe\x10UŒ"
  b"%>s^§‡F“², \x12Ã\x19~{"
  b"%e\x06 \x1F\x18LƇže‹H=HÌ"
  b"""
    &à²\n
    Æ F\x16­@©†çMÿÔ
    """
  b"(†B¤S*JR!‚\\ŽC¬"
  b"*ߣ*fWJ@¶÷!âåHš2"
  b"+`¦JZGà£ý¿ŸmX÷è"
  b"+㑲¢šKþ±K\e™\x00Î("
  b",Æð­XÌA÷¡àþå¨Öšý"
  b"""
    -`;ч„H$©Ky\n
    £µÙå
    """
  b"-Ä(†ä¬J\x07›\x01Fo\x14“#$"
  b"/E\x11 ä O6ŠÃ–ųŽ‚~"
  b"/J£xË\x05B"»{[5Å-6Ø"
  b"/ýž\x00öK|§[¾\x1E,\x06\x1Fœ"
  b"0úšòZ³EÚ´]·ªÛ9þ´"
  b"2\x00'ù¡þC* š‚„’\x13É"
  b"2.ƒ¡è£Fù‹™J\r,Oƒ\"
  b"3¢Ôð5­D\x0E¹D\x11>´"?["
  b"3å§FQØO¢«ó—\x02g\x1AÅk"
  b"3üy’rƒK‚›\x08Bÿ$K\x17m"
  b"6\x14C§!bIÞ–’Ž=P\x04ôR"
  b"6GÄÕ¹†K——a;×@(]"
  b"7Þÿ1öYM¥©\x1D•årë5y"
  b"8ÊÚ«‘<Oˆ­~}´Rü\x12}"
  b"""
    8Ýy\x11\n
    ’J[¿Uc\x11÷Lõl
    """
  b"9é\x0E'vÔ@\x1D­Žƒí\f¼¬:"
  b"""
    :\‘:ÛwM™«\x02E¡s_\n
    —
    """
  b";±xÿD«N˽OOo¼™¬{"
  b"<\x13\x06"HêB®ŒœÌžaÖnÛ"
  b"=\x10\eµº€L8…óº\e˜\N—"
  b"=wšË\x07ƒG_‚!\x17V¸Wöš"
  b">‹Vb\x13/BG‘¹g eè "
  b"?L#Á5Aá™ÊÍÞ\x01Yçh"
  b"?djÊŸ(HQ·ÍtÈ\x11Ú¿"
  b"@*uËåÜJ\x0Eœyb\r¾á\x1A–"
  b"@£µ ®]@\x17¶îþ\x15ç^\x19€"
  b"BU\x05÷L\I¤‹õ_à³onú"
  b"Bá¾¥¾WCò€RÆwaªs"
  b"D\x00×\x1FF^L×´$+”\x12–ôr"
  b"""
    F\n
    ×\e\n
    K–®ÒTrs_Gw
    """
  b"FfG“l«@ӐM-1Ê,óæ"
  b"F“‘¨u¥I/¥¶<_\x1Eæ\x1Di"
  b"GÏѵ‚WBv™Fìayìo"
  b"GÙþ¬\x11ìMÔª,¢ŽöGH}"
  b"H+S®Ž\x03B°•™”Üý"ëï"
  b"IU\x1A|÷<E¨±›{çÑ@!\x04"
  b"""
    IÚõ\x10SÖLÕ·÷ÀQó\x11\n
    g
    """
  b"J4Ç£8îBՁ\x08—±ö2\="
  b"Kü~bÜ…EPª[gQþÃ\x10h"
  b"L¬\x06‰\x1E\x08KJ´ 48›æ†¦"
  b"LöV=¸±N(¸IΓ2×Uì"
  b"M\x01ü\x19\x1F—@\x14ŸÜa\x02q\x1Ch#"
  b"""
    M\x02Ûô\x12.@X¿ €\n
    DEZ
    """
  b"""
    M\x1F¸#cdJʹoŽ7\n
    L¹y
    """
  b"M"Û“#=@†¿î6ï;\x1F5ö"
  b"MÈÄäŸÙK ©ÚõàZ—IÉ"
  b"N\x15t\x15‰Gn­ýêK\x0E±÷¬"
  b"N4C;S6C\x7F É<\x028Ù\x12~"
  b"N=\x1A5Î\x05@߃\x1Eú¨Ú±þX"
  b"N‡õ\x05a/K&“\r¤©òŠY7"
  b"O¬~ö\x1FHA\e ?ãtÀq"
  b"OÅ·¹\x7FŽH(€_ß\x10Áá»ë"
  b"PY\x00p2\eI’±\\x05šÕœ¤"
  b"Qu¨GÐ4Mq¬k\x02ž\x15É8”"
  b"Q}[KàNH̺xÜ\x02z@H"
  b"R*½\x10\x11F\x11ƒˆÝŽ%,dJ"
  b"R”m«Þ³NOª€¼C¸uNH"
  b"R¡:\x08ncLáor¶7ã÷ç"
  b"R³\x1A\6£Dù4õ?“°4¯"
  b"RíñÉÙ\x0EI\x07£\r=œ\x12\x13Xë"
  b"S‰4ï©€OÊ C¡{\x1CÚ£Ø"
  b"T3¤¬E\v@mŠ\t”¹ì”êd"
  b"T®ÊIdVIùd©ðÐë@å"
  b"TÝ1\x08\fdM\x17¬„,zÄÄÐ\x1A"
  b"V?•\x7F"ŠHûžù^ûèñ­ƒ"
  b"VÏ\x7F\x11\x1EûKw®‰fRE‡Ýû"
  b"WZâ\x1D3ÊFo‹w,ŸOÖ°\x00"
  b"Wp^Ù<Á@¼µA\x7F(’Á”™"
  b"Wt\x02m\x08»Op„ý@f•€\â"
  b"W¢9\rúúL¼¢ã\x02\x12Ao6f"
  b"W¬ÒùE\x06D¼ž‘<¹èÏ´ë"
  b"Xœ–SʲD\v\x10\x0E’\x04$å-"
  b"Y-Æ \x03\x17Lr“Ÿœ’\x06»ŸÈ"
  b"YcÒj+PFl¼\x07+Pß-’K"
  b"Y±×UåöE\x01·yÑTc{¿µ"
  b"Y܃>WIé†Û3™Me?˜"
  b"Z6\)\x07üK’­heÊ\rÎ\x12Ô"
  b"Zlv\x1DŒ\x16Bc®VÅÆ\x05x\x1F"
  b"Z½Ô¨ŽCg™8„†s™ëÞ"
  b"""
    ZÚïm\n
    \x01I#µæ|scS+
    """
  b"[\x0F¦Õº~H­‹ù+ƒç—ߟ"
  b"[éGÒê\x1CCG¬Ù}‚ö/™P"
  b"^Ä\x0EaŠMNV¤ù0/)%Ž9"
  b"`'Õ$m­C\x03¹‡¨"\r)-¤"
  b"`»VÐA5O\x1E“žˆöf©Íe"
  b"`Ø´ ):IŠ™Wk\x18dàZ¨"
  b"aFÛ#ƒ\x19B\f¦êS\x01æJê¹"
  b"aOº~þª@€‹\x12õܐP\x17W"
  b"aÞ¸ŠVàN\x1C’„0V‘\x13¿º"
  b"b­-…¨PGùµêN\x7Fã’už"
  b"g\fÄ\v´\rG}¿Æ÷tºTªÈ"
  b"gñ˜9l”EañCXù1Âj"
  b"gýC;Ú$Kø´¯YÔ\x19\x0E\x03Ç"
  b"h\x05ŠþùáFϦ¬"¹ÝɲY"
  b"h„¼¹TvL1Ž\x000Œ7\x1C\x1Dö"
  b"h‡\x0F3–N}œ}ž Y³4K"
  b"if7Ek>Iy“Ê~­¿Ê]Ý"
  b"k\x17´\x11°‰D\x16»ì.aR’<U"
  b"k\x1F6ÓÃÇA\x06¡çœ6ô!;Ç"
  b"k>,ίøG(Œé‚\x18]>±Y"
  b"k—ÛÌðÝL†ªQR/£ØÊJ"
  b"lCÉ£&¶Fȵ2«Úö;KM"
  b"m\x17‚`\x0E\x15F÷®üŸ½äc6þ"
  b"ne\\x07Ò„D¤¦\x1Eù$¡g¾x"
  b"n•çæÐøL"º ßט\x15”Ë"
  b"pH¿\tASAMŽü\x02\x07†ý\x18G"
  b"p\]ñ~ÍMN‹fˇ\JĤ"
  b"pÖ®\x1Dz\rK9³ûÕ|b\x1E|Å"
  b"pß\x16LJ\x13D㝵bßÙ‚´\f"
  b"t*£Â\f_N6—\x7FÑ\x15Œ6‘j"
  b"t|Žï¼ÌE切]Á"kŽ\x1F"
  b"tµdt½E»ŒÌhW°Žy"
  b"tì‰ü\x15qC¸±åD\x04æ’z\v"
  b"u\x1Dè’ƺM\x14­~•B?J®o"
  b"u¤Ø:ÜœGaµXïyánƒÙ"
  b"u®‡wêËANžl‘\x1EÏdX"
  b"u·ýgœ&I‰‰%ìžlÐ\x08¦"
  b"""
    w\n
    ÚéeÏM*¡ÒA•-\x13ÿ\x03
    """
  b"wîý‘Åç@’³\x10ò®u>AL"
  b"x-×€ÄÿBÿˆ?Lc$H̺"
  b"x>Ô\rŸqFË°\x06²«G\ri\x1F"
  b"x‚3î0ýMÕ¼ÍñÌx0~q"
  b"xŽÑRè³Iˆ›¹Nw<–ƒ¬"
  b"z\x17\t¥\x14\x06O6„·ÅÕ\fBí"
  b"|ÀÐ÷-âO\x08š¯¢4>ŒÁê"
  b"}OÁ½ý’AC¹=B²Ö bš"
  b"}ic \x00“Iõ‹MJæ‰ú\x0E"
  b"}ƒ\eÄ$ùJË­íL\x19+«\x00"
  b"}Èø:ú¶O\fŽ¡ý\x02˜w\x17\x12"
  b"}ÝÇØÑ×Nòœ\x12âèªÆw"
  b"}ðŽ§—ŽBG\x0F’p\x10‹µ•"
  b"~Bz\fvZAV¾š=ÆñŸ.`"
  b"""
    ~Ø»\x18\x17\x13Aá±Í\x7F\n
    1Þ\À
    """
  b"\x7FO*o=8G ˆzȲ\x02úî¿"
  b"""
    €'_ìSÌD\x18±7Wx\r\n
    9\x1A
    """
  b"€éZ\e±ZI¿¥Ñ—&Ñ<Œ/"
  b"‚)EfÄ\x06F”¢]€\x1CèÄω"
  b"‚B²…Ý~I8„Äñ\x07\x7F;^"
  b"‚\>D\x19‹AôŽˆ\x1Er 3û›"
  b"‚˜–\x1AîëF„¬»m½hôöú"
  b"‚¢??\x12¿N2Hìï?Þ\x1Ds"
  b"‚³ÂZˆŠN¾µûf\x1EÀ\vŠ»"
  b"‚½Ñ“\x1ApJ\x07žœG6zà^"
  b"ƒ€ÂÀ).L+™_\x17¬–ü"\x1A"
  b"ƒÐ€Ÿ\x1A£I¬“d'“\x1E¦äê"
  b"„³¡^0èFOµÃ(=)é‚e"
  b"…DPšyŽF\x15¯[SKZ5õµ"
  b"…íK˜\eIž¸i¥ü\x03µÓo"
  b"†º°\x085€@6¥VkE\x10M¶;"
  b"‡\x03±ayJB†![ՁÑ#!"
  b"‡9å\x1C›rHÁ£oê°8f‡â"
  b"ˆ’\x03F¼›LݼPÓ\x05k\x1AÃ}"
  b"ˆ©(éÁ¾JxŸU—9F ^"
  b"Š¸j­iªFc–ù\x05Àö6@_"
  b"‹=?\x1Fn³G•¨O\rN©·/]"
  b"‹Õb;äÏH\x05·›\x1DÆ\esô©"
  b"Ž\x12m\x05\gMŽ“¬…ÑxõÚ#"
  b"Ž8¥ÿ\x1E’C¡†½!\x15ÿž­Â"
  b"Ž@ŽÄI]Oæ‚Òäî\x1C> O"
  b"Ž†\x10\x04°¡AX›'ýÆÿöC"
  b"Ž×ÅÈÎ B³ª\x14B„W¦Ò"
  b"áÍ\x1AøyGÈ–3\x7FÎV#mÕ"
  b"HO\x02•LH8“™\rÒV‘ØI"
  b"\x7F„ëqÐGIŒMJaÄLIx"
  b" Á\x13«ÏBÀ‹\x05ˆ´\v¾»n"
  b"’ S"\x14N{ŸVá¿Ì­?ù"
  b"’û+0kˆBÖ§\e2hWµËµ"
  b"“@,z—ùI –òMûfÖ/\x12"
  b"“Qf\x10:>I\x00•y\rLÌ1@†"
  b"“ò£¾GOKu®Ô²›’Tz\x03"
  b"”\x07x:øƒ@?šäfR=›©i"
  b"”¯ûÔü\x1CB\x1F¡õºi#GÆ?"
  b"”µÍ4f+GÞ˜¥Ê\x08¡SÕ@"
  b"”¾£\x17£{BØŠ¼Eç\x10qí"
  b"•4bùB«@‹½˜§áJЈW"
  b"•á\x19Ç\x07ûO\x10Šð\r«ÉŒ\eY"
  b"–+ßȘ\vD\‚ëy1ŒžÊÎ"
  b"—„ÓÖŸJ\x12Š\t\x02$ᧁ0"
  b"""
    —ܧsÇæJ\n
    “‚Æ,»<0’
    """
  b"™Š)‡)/@@¢\x0EIZXMÀ3"
  b"™¡\³"Dò¨‹J´î29"
  b"š\f\x19Éâ\x17Ipœ‹\x7F-¾ƒ>÷"
  b"""
    š|mûõ\n
    KR’}•…6au¨
    """
  b"š™”?M³E\x15…™s]ÿc\x00e"
  b"›\x10gGÏáA@œ\x03c\x10@\x02Yä"
  b"œ$íÍ_Mï¯æV³»‡ê´"
  b"œMªœ&\x08EŠ¨—dIT`²7"
  b"i\x16³l@™¹ãÃͺ6\eÂ"
  b"ßûÂ>¼HŸ—7ušKQβ"
  b"ž\x1F#I_Ô@¡¦àÚ§\x16†­y"
  b"žRQ³ë?J&‹Ê褣\x0F÷ò"
  b"ž¿6V†~F†šŸ×ãÆ^}["
  b"Ÿ3ÃŸÑ @궼‚P)Í~\x12"
  b"ŸlÙà©Œ@‚½Ò@XÁ¿\x13Í"
  b"ŸØ\x11€uYD\x06—mÕ)ˆÎR—"
  b"ŸçêŽ6àFG†LÎë®6œ?"
  b" :\x079\x13J÷“\x14ÇhË~(2"
  b" ¯>XÙlJb€ ø™˜½3"
  b"¡µ¦z<ºCf§…b¤n›-Ä"
  b"¢\\x08î* JõŸ^ú!ã\x00ô"
  b"¢uí3mDGS ZÜ™Ò\x19ç£"
  b"£\x05¿Ë\x0E˜C\f¤\x17([T\x1DŽ]"
  b"£2]Í—gD©·ò™\x07\x03$n÷"
  b"£¤v’ÁñL,Ž·\x1EìÎa\x1EÊ"
  b"£Ç\x1A ¯ÙLš¡þfì×w k"
  b"¤|bƒFN± \x0Fä1ì+5Ð"
  b"¦ÈaI#Aa»‹¸_W©ÞW"
  b"¨\x03þrÝýLz–?Ç®øŽ)‚"
  b"¨\x1EJ\x01ŽdBv²œÐ\x1Am7Z"
  b"©£\x1F4½…Hف\x1FFy\x16Üè"
  b"ª\x16bþ\x1A]B"³ÐCÝufë\x16"
  b"«q\x1F2F}At«{‚2ì¾i†"
  b"«Ð<R§·A¹ñ•Ø\x10=M"
  b"«Ùc\x1Fä›@æ¬\x10¡|Æ\x18\x1D÷"
  b"«äáMHæA=“ˆß@ËäO\x08"
  b"¬x.ô&×J4šŽ¡2ÚÇPú"
  b"­/A\eçzDi£ž\x00ªÄŸõ+"
  b"­FTQ\x01FH.®ÓÉü¹ƒ©V"
  b"®#œ¯"ˆH£‚Ž”2ˆ*¯"
  b"¯\x02[ÂÑFK˜´†”4³{ÞÙ"
  b"¯JëŸÿMI¸½VàŠçXX"
  b"¯xÕ‡ô\x12Jã‹‘Èö">Vø"
  b"¯Š)…>MÇ¿·¤´i\x0E;m"
  b"¯Ç\rLÄpB‚lí™@Ozr"
  b"¯áËt‡fGá©\r´lp¼Î½"
  b"°\x17€”ÖDb„\tÚ}dœÔ"
  b"°:,F<“Hn¬É?Ot.¡ò"
  b"°¢u)<\x00Jœˆ\x1CûUGP2Œ"
  b"°¢ìþŠ"EЬ€\x00\x1F5\e{\x11"
  b"³H:ºð^C#ºR\x01%Èçé—"
  b"³Lˆ\eu\x06Ad³S¼\x1DìjÆŽ"
  b"³ƒáÖPöFÍ Ñ\x0FR7b¨Å"
  b"""
    ´\n
    Ð(?±Gc–®\x12¢\x1F™“B
    """
  b"´*ä\x1DÊÇCÿ‘'\x07å˜4™¥"
  b"´ÂŒYé=BX¸êyãØÆ\x19ç"
  b"µ\x08óÅB0B»Ò\x17}ð`ä\x08"
  b"µ‰Ö\x1A/CG&¡‹Yvz•¹ž"
  b"¶$ú\x0Fcë@¦.ö\eÖ‰ÊÁ"
  b"""
    ¶E\n
    ŸeÖNÅ…²²Ï\fóÑk
    """
  b"¶o\f <\I¨©Ðl\x04è¤Á…"
  b"¶vÓÑ•ÐN¸¯Í²òAAµý"
  b"¶Ò\x01¦F*I‡ž\)ÛY°\x0FZ"
  b"·-–ç\x14­GN±ñ¤vlÝ:§"
  b"·2ñ©zND¾\x17ĝµT¨M"
  b"¹@\x1A\x02ùwLD™¹„\x17.TÙ"
  b"¹y\x00ŠÎ|@Å—"ÚoÐ\x13ÒH"
  b"ºM\x7Fq%àC²ŠónÇ“’YŽ"
  b"»\\x0F€¡'EY±6¾bbÍú"
  b"»_xúrG1¼y\ve„Ü\x01â"
  b"»€\x02Ì`0Me„‹Ã=@\x01fü"
  b"»„¶ûROM¶J‡1êÖ¼V"
  b"»Æù©{×Duƒw‡\x13…¿Û}"
  b"½\x01Y<wŽGÿš\x11‰bm¾ø"
  b"""
    ¾\n
    V=<\H¢¨…VÜ,ö‘ž
    """
  b"¾#ëXÝxA\x7F‡‡î\fn¾3\f"
  b"¾XV…þÁB/«ùUl[\x1DIU"
  b"À\x14\r3\e\x1DH\x02¦\rá\x06‘ü=_"
  b"ÀVÁ*¬ÎD)‡ÚÊ\x04\x1AÆ\x10("
  b"À›õ*³O\x18«o7eß\x1AS"
  b"Á)£sŸÑK¢†Á7ܘp\x05Ý"
  b"Á3…ÎêfC.¿œµ$\x12Eú"
  b"Â\x1AÖ¹¢gL›¼\x7Fȇ¨ôºø"
  b"ÂilN¹äKeŒ\x1C—‘õ'å4"
  b"ÂoáÜ×åOЫ}Xð­Q29"
  b"ÂÂ ¶G‚H˜’8À~$_Ê5"
  b"Âó°Mÿ&HF˜)úž/W\x05ù"
  b"Ã/¥Ò\x1Dê@R•¾Y%&'ƒ"
  b"ÃOiéß\x0EL—¢\x7Fš!qVRß"
  b"Ã]¥Ëb9D\x01»KŠ'ééäº"
  b"Ãã\ß¹\x0FA®“cǾ'÷Îs"
  b"""
    Ãç \x01N9E’­\n
    \x18¨Ï¯3r
    """
  b"Ãóùæ÷ÒLš»£±\z/º}"
  b"Ãù­BöŽHƒ•ä:†Á\x183e"
  b"Ä.~ÙlåO\x14‘ž‹Éɧâ–"
  b"Ä»L\r#™K£±Ì®%\x15Êr«"
  b"Äï\x06k\x1FþBþ¶ØkøŽ\x1Dð˜"
  b"ÅV2]\x1DÅ@6¬ÓÑ Á›\x074"
  b"Åœ\x19J±QO\x10±\vü÷\x05ç'¾"
  b"Å«*\x18a×J™&\x1D~]C’+"
  b"Ç\x11¬“›+En¸b‰:å\x11\x17Ð"
  b"Çx^é{1O=°>ÞãÙsyu"
  b"Çã(G©¶@\x03º¡î²ÐàÔN"
  b"É'÷¥×\x13Kr‹h÷\x08\x13\x03-2"
  b"ÉÉu†î¢K#•gX"þtŽè"
  b"ÊÂhëM§DFyãAœn/L"
  b"Ë,c±'1E¾ž3€Ñ£å\x05÷"
  b"Ë™&» .Cø®ªö.ΫxB"
  b"ÌÛÅä¸Ç@Ž¯LA\x01Y¸ÔÜ"
  b"ÍjŽ«æbAµ«\x00:`ç6pþ"
  b"͝Ky?cGW¬Ùcn:j³"
  b"""
    Î2g<-ýA†Ÿ²-µ\n
    \x04F:
    """
  b"Î̹ \t¥G¾€ç2Cd+àÌ"
  b"ÎîJŽë«GRœÊ,\x7F\x02\tÔá"
  b"ÎôE\x18ª\x17L\x05—?ÍÃMT"Æ"
  b"""
    Ï3à‰¾?E¡‚Ú"A~\n
    áw
    """
  b"Ïša½¥.Fe•ÿ*!?tŽÒ"
  b"ÏLJÖýúF©‰òù¬@^²Œ"
  b"Ïäuc\fLLG‘PÚþ\x03›\x1Eí"
  b"Ð+¼§’OސCQ%Ûý\x11_"
  b"е$K€>M†‰ðÏ)Ñx=i"
  b"зhh\x08ÃD9©tò\x17êç’ª"
  b"Ñð\eÏl_I¾±¿‘»_1¥A"
  b"Òv­-bÛCù¼¥KZ\Ž[¯"
  b"ÓXJ”‘äNå¿\x06\x19î…Zl"
  b"ÓæENú/I‰¯ÐÑÜèÂ=?"
  b"Ô.ˆ‹\–BÞ‘–.šâl”{"
  b"Ôz-¯V+G\x13Œ­u¯â(‘\e"
  b"Õœo¥?ÆO\x14®nä\x01)Žéì"
  b"Õ¾eYv¾BY·Ö¦È„6\t\v"
  b"ÖC•Ú”\fM$ ˆÙqo¼p­"
  b"ÖswylJ<¶\v\e•\fŸ™h"
  b"Öu\x1F<¼/J\x11%î©l˜Š""
  b"ØMˆ±Ê£K@®2ü‰¨&2ª"
  b"Ùa—þîóFꐾZD=q\x16J"
  b"Ù—~™vÐA\x11—Ì\x10Ö–,bt"
  b"ÚZw+r3D^µÇ\x07<\x1Ab\x15à"
  b"Ûaã\x15\x19[E|¾Ü¥x\x7F :Ú"
  b"Û|A\x1E\x11\x04Md¸þD‘ƒm\x14˜"
  b"ÛÞ®\x16#\x0FGD­*á”Óµõ\x05"
  b"""
    àd3C\x07îH\n
    ½fÔß8!Ç"
    """
  b"à±J’ÐV@þšª\x7FX8\x12;í"
  b"ábïæƒLL\x18£}‰ß$¨^é"
  b"᾿1Î\x18N±ª2ãš\x1C{Òƒ"
  b"â BÄŠ:@÷¹Ì¸„‚w4Q"
  b"âR\x15š\x06æ@Š¹ÕFÕ°³uí"
  b"âŸàõÒ°C˜­\ešU+À\&"
  b"â¥úÌyäM\x16Ÿ‰\x06°ðŒ|†"
  b"âäk»“O!Ž-Ég²Õ~\x1D"
  b"ãv\x0EÉ°>A®¼H§™êÞÚ"
  b"ä\x03”¾(\x1DNÍž£bé\e݁…"
  b"ähpä0·Gì²ÓIÄU&1A"
  b"åz\x7F%Ï7F¹„ouÓxL\x10Ë"
  b"å¸ËR+TO\x1C™6*Â3™N\x00"
  b"å΀äZ½A_Ž\x08•«‰àow"
  b"ç·-_ÌÁI<—\x1E̵&öÑ-"
  b"""
    èLÐa=JFҐ•5ð¬\n
    ª–
    """
  b"èƦ\x16Ó,H’™z‹†û¤ï"
  b"êu7,Ž(Hק‘'ò\_}8"
  b"êy]c\Ä@›ªü<\t\x1EPÕ]"
  b"ìp\x1EÌV¯F¯„74ý›l©}"
  b"""
    ì¥UÓx‚I²“cèRR\n
    p
    """
  b"í“ŽÂÝwOM¶\x00\x06‡\x1Cˆû,"
  b"í£Œr\x03]@‰ |Œr\x01éö]"
  b"î\x1F¹¿‡ñNÀ†ë#óâ{„Ð"
  b"î"±\x06trM°¹;¾û:S°\x00"
  b"îDnæÌ{@ò;ÒX‘¡ˆ"
  b"îxØi»üO7”\x17E\fÜÆËô"
  b"îÖüç´£F÷xÌÝís%º"
  b"îÙj(G·Iõ¾0.=ðì`ê"
  b"ï\x07óãñ"L»”ûç\ŠðŽl"
  b"ïO\x18yê\x15A+½Ök‹Åƒh¨"
  b"ïú£\tŒÌBZ•S«=\x06~Š:"
  b"ð/õ—§¹E£“b›Š.Uàk"
  b"ñ\x05óÄ<“Mñ¼îƒ›Ëƒ\x07w"
  b"ñn‘xKôK©€%¿mK–\x0Eÿ"
  b"""
    ñë×\n
    UÃB=‡ÏÃã¶Äz:
    """
  b"ò‚.ê”\x1EE\x11¢Ü\ªh•;Ó"
  b"òÖe¹CeNJu\x1A¦£0¯L"
  b"ô*Fpƒ°N8£Ž\x03r¶\x0Fb"
  b"ô¤E\x16ò+LÈ•K<²1\x00$\x11"
  b"ô·`;¯ÄD\x14«\x11|‹8ÏØx"
  b"ôù*NdôDˆ€'·Kœ\x11\x05š"
  b"""
    õ\e\x1F£Ò×Ir˜\x15\n
    ¦‹ãÕ\x08
    """
  b"÷Œxôï\x02@\tˆ_~.,3ÿO"
  b"÷î.rç\x7FFIƒùÏr{ïm2"
  b"ø@\x06\x03÷óJ±±jþ\x1EUù½‰"
  b"øJ\r)¸ÝK¸±¨ŸQ{\x7Fh2"
  b"ø^»Q°ƒN숀ˆáupá"
  b"øÅX¶Ž€I¹\eoq$+_\x15"
  b"øÌ…âõ±J9“ãcFš?×="
  b"øô¢[Õ‚Në·{£C®\e’Ì"
  b"øÿÿÓú˜CÑ•ßÄë-`Û"
  b"ù[BO\x04\x0EB\x02‘[Ëx<ʧ‡"
  b"úðþƒÉDa˜•·ó\fIEá"
  b"ûDÒ“‘RKÀ’ýòdc\x15D–"
  b"û”Ù÷{\x16H¥™ìüå1¶\x15y"
  b"û¼ƒÞ"fOy”ß9[*4\x06\x13"
  b"û䨘çñMû°Šýý´+c"
  b"ük»K]¶@:ƒKñ¬\x04$mù"
  b"""
    ý a ¼MJ˜•P:…\n
    K¼,
    """
  b"ýÌä\x16_JG\r¯\¸›F?ª"
  b"þ\x16«UUÊK[µkL<|ô4‡"
  b"þDj?!‘MŽ“OíOt%?"
  b"þFÌ~ÜUAG¸¹iÀxùBr"
  b"ÿ3>\x1D«ïLYƒ¯\x11"íyŽ>"
  b"ÿ«F)4ÓDm—\x13\x01Ú‰„Ê"
]
View formatted query    View runnable query    Explain query    View query backtrace
35 0.84 ms 
SELECT LOWER(HEX(`category`.`parent_id`)) as `category-ids.key`, COUNT(`category`.`id`) as `category-ids.count`, COUNT(DISTINCT `category`.`id`) as `visible-children-count` FROM `category` WHERE (`category`.`version_id` = ?) AND ((`category`.`path` LIKE ? AND `category`.`level` = ? AND `category`.`active` = ? AND `category`.`visible` = ?)) GROUP BY `category`.`parent_id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  "%|b0b6bd35a7614731b8be2709f3588b9f|%"
  12
  true
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
36 1.24 ms 
# header::navigation::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`file_hash` as `category.media.fileHash`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, `category.media.translation.title` as `category.media.title`, `category.media.translation.alt`, `category.media.translation.alt` as `category.media.alt`, `category.media.translation.customFields`, `category.media.translation.customFields` as `category.media.customFields`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.`language_id` = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"°¶½5§aG1¸¾'\tóX‹Ÿ"
]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.55 ms 
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `swag_dynamic_access_category_rule` `category.swagDynamicAccessRules.mapping` ON `category`.`id` = `category.swagDynamicAccessRules.mapping`.`category_id`  AND `category`.`version_id` = `category.swagDynamicAccessRules.mapping`.`category_version_id` LEFT JOIN `rule` `category.swagDynamicAccessRules` ON `category.swagDynamicAccessRules.mapping`.`rule_id` = `category.swagDynamicAccessRules`.`id`  WHERE (`category`.`version_id` = ?) AND (((`category.swagDynamicAccessRules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?) OR `category.swagDynamicAccessRules`.`id` <=> ?))) AND (`category`.`id` IN (?)) GROUP BY `category`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01Ž^ /\x08qW‚ö\x1E`ÝÄÞÀ"
  b"\x08d¯\x107\F\x04§tOVS\x158G"
  b"jME~ÙMËŒ#—\x12¸õÑ\f"
  b"õÆ“è)“Fv¢Lïѳ€\x1C"
  b"7žhªàrK^¡ÁÙ"È?“\x08"
  b"\x01Ž=ºõ`\x7Fı‚Ô½‹’Ïñ"
  b"\x01Q®~\x14p¢ ²1vÞя\x04"
  b"äNg‚ÆBG·–¸‘Ï%®8÷"
  b"""
    \n
    ¾oŽH‘Bʱ¾\x06[ý\x1D†Ž
    """
  null
  b"°¶½5§aG1¸¾'\tóX‹Ÿ"
]
View formatted query    View runnable query    Explain query    View query backtrace
38 1.23 ms 
# header::languages::search-ids
SELECT `language`.`id` FROM `language` LEFT JOIN `sales_channel_domain` `language.salesChannelDomains` ON `language`.`id` = `language.salesChannelDomains`.`language_id` LEFT JOIN `sales_channel_language` `language.salesChannels.mapping` ON `language`.`id` = `language.salesChannels.mapping`.`language_id`  LEFT JOIN `sales_channel` `language.salesChannels` ON `language.salesChannels.mapping`.`sales_channel_id` = `language.salesChannels`.`id`  WHERE (`language.salesChannelDomains`.`sales_channel_id` = ? AND `language.salesChannels`.`id` = ?) GROUP BY `language`.`id` ORDER BY MIN(`language`.`name`) ASC
Parameters: 
[
  b"4U0/þõH÷—÷5’6\x1Cç¡"
  b"4U0/þõH÷—÷5’6\x1Cç¡"
]
View formatted query    View runnable query    Explain query    View query backtrace
39 1.32 ms 
# header::languages::read
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.productSearchConfig`.`id` as `language.productSearchConfig.id`, `language.productSearchConfig`.`language_id` as `language.productSearchConfig.languageId`, `language.productSearchConfig`.`and_logic` as `language.productSearchConfig.andLogic`, `language.productSearchConfig`.`min_search_length` as `language.productSearchConfig.minSearchLength`, `language.productSearchConfig`.`excluded_terms` as `language.productSearchConfig.excludedTerms`, `language.productSearchConfig`.`created_at` as `language.productSearchConfig.createdAt`, `language.productSearchConfig`.`updated_at` as `language.productSearchConfig.updatedAt`, `language.translationCode`.`id` as `language.translationCode.id`, `language.translationCode`.`code` as `language.translationCode.code`, `language.translationCode`.`created_at` as `language.translationCode.createdAt`, `language.translationCode`.`updated_at` as `language.translationCode.updatedAt`, `language.translationCode.translation.name`, `language.translationCode.translation.name` as `language.translationCode.name`, `language.translationCode.translation.territory`, `language.translationCode.translation.territory` as `language.translationCode.territory`, `language.translationCode.translation.customFields`, `language.translationCode.translation.customFields` as `language.translationCode.customFields` FROM `language` LEFT JOIN `product_search_config` `language.productSearchConfig` ON `language`.`id` = `language.productSearchConfig`.`language_id` LEFT JOIN `locale` `language.translationCode` ON `language`.`translation_code_id` = `language.translationCode`.`id` LEFT JOIN (SELECT `language.translationCode.translation`.`locale_id`, `language.translationCode.translation`.`name` as `language.translationCode.translation.name`, `language.translationCode.translation`.`territory` as `language.translationCode.translation.territory`, `language.translationCode.translation`.`custom_fields` as `language.translationCode.translation.customFields` FROM `locale_translation` `language.translationCode.translation` WHERE `language.translationCode.translation`.`language_id` = ?) `language.translationCode.locale_translation` ON `language.translationCode.locale_translation`.`locale_id` = `language.translationCode`.`id` WHERE `language`.`id` IN (?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"–Hó8]aLU½|ÔÜhÓ\x01Ì"
]
View formatted query    View runnable query    Explain query    View query backtrace
40 1.22 ms 
# header::currencies::search-ids
SELECT `currency`.`id` FROM `currency` LEFT JOIN `sales_channel_currency` `currency.salesChannels.mapping` ON `currency`.`id` = `currency.salesChannels.mapping`.`currency_id`  LEFT JOIN `sales_channel` `currency.salesChannels` ON `currency.salesChannels.mapping`.`sales_channel_id` = `currency.salesChannels`.`id`  WHERE (`currency.salesChannels`.`id` = ?) GROUP BY `currency`.`id`
Parameters: 
[
  b"4U0/þõH÷—÷5’6\x1Cç¡"
]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.76 ms 
# header::currencies::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.netiCurrency`.`id` as `currency.netiCurrency.id`, `currency.netiCurrency`.`currency_id` as `currency.netiCurrency.currencyID`, `currency.netiCurrency`.`active` as `currency.netiCurrency.active`, `currency.netiCurrency`.`buffer` as `currency.netiCurrency.buffer`, `currency.netiCurrency`.`last_factor` as `currency.netiCurrency.lastFactor`, `currency.netiCurrency`.`last_update` as `currency.netiCurrency.lastUpdate`, `currency.netiCurrency`.`created_at` as `currency.netiCurrency.createdAt`, `currency.netiCurrency`.`updated_at` as `currency.netiCurrency.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 `neti_current_currencies_currency` `currency.netiCurrency` ON `currency`.`id` = `currency.netiCurrency`.`currency_id` 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Í‚ó¬›ÑÀßÊ"
]
View formatted query    View runnable query    Explain query    View query backtrace
42 0.69 ms 
# navigation-route::meta-information
            SELECT LOWER(HEX(`id`)), `path`, `level`
            FROM `category`
            WHERE `id` = ? OR `parent_id` = ? OR `id` = ?
Parameters: 
[
  b"Ä»L\r#™K£±Ì®%\x15Êr«"
  b"Ä»L\r#™K£±Ì®%\x15Êr«"
  b"Ä»L\r#™K£±Ì®%\x15Êr«"
]
View formatted query    View runnable query    Explain query    View query backtrace
43 2.74 ms 
# header::navigation::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`file_hash` as `category.media.fileHash`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, `category.media.translation.title` as `category.media.title`, `category.media.translation.alt`, `category.media.translation.alt` as `category.media.alt`, `category.media.translation.customFields`, `category.media.translation.customFields` as `category.media.customFields`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.`language_id` = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND ((`category`.`path` LIKE ? AND (`category`.`level` > ? AND `category`.`level` <= ?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  "%|c4bb4c0d23994ba3b1ccae2515ca72ab|%"
  3
  5
]
View formatted query    View runnable query    Explain query    View query backtrace
44 0.61 ms 
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `swag_dynamic_access_category_rule` `category.swagDynamicAccessRules.mapping` ON `category`.`id` = `category.swagDynamicAccessRules.mapping`.`category_id`  AND `category`.`version_id` = `category.swagDynamicAccessRules.mapping`.`category_version_id` LEFT JOIN `rule` `category.swagDynamicAccessRules` ON `category.swagDynamicAccessRules.mapping`.`rule_id` = `category.swagDynamicAccessRules`.`id`  WHERE (`category`.`version_id` = ?) AND (((`category.swagDynamicAccessRules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?) OR `category.swagDynamicAccessRules`.`id` <=> ?))) AND (`category`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY `category`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01Ž^ /\x08qW‚ö\x1E`ÝÄÞÀ"
  b"\x08d¯\x107\F\x04§tOVS\x158G"
  b"jME~ÙMËŒ#—\x12¸õÑ\f"
  b"õÆ“è)“Fv¢Lïѳ€\x1C"
  b"7žhªàrK^¡ÁÙ"È?“\x08"
  b"\x01Ž=ºõ`\x7Fı‚Ô½‹’Ïñ"
  b"\x01Q®~\x14p¢ ²1vÞя\x04"
  b"äNg‚ÆBG·–¸‘Ï%®8÷"
  b"""
    \n
    ¾oŽH‘Bʱ¾\x06[ý\x1D†Ž
    """
  null
  b"\x01nˆ#ìsâ\x01Ÿ° ÆÿÄ"
  b"\x01¾7¾xs‹2t±6\x06nà"
  b"\x08ŒÎG\x07RGàŽ:‡-Y\x16ص"
  b"*ߣ*fWJ@¶÷!âåHš2"
  b"aFÛ#ƒ\x19B\f¦êS\x01æJê¹"
  b"‚)EfÄ\x06F”¢]€\x1CèÄω"
  b"͝Ky?cGW¬Ùcn:j³"
  b"ÓæENú/I‰¯ÐÑÜèÂ=?"
  b"ø^»Q°ƒN숀ˆáupá"
  b"""
    ý a ¼MJ˜•P:…\n
    K¼,
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
45 0.43 ms 
SELECT LOWER(HEX(`category`.`parent_id`)) as `category-ids.key`, COUNT(`category`.`id`) as `category-ids.count`, COUNT(DISTINCT `category`.`id`) as `visible-children-count` FROM `category` WHERE (`category`.`version_id` = ?) AND ((`category`.`path` LIKE ? AND `category`.`level` = ? AND `category`.`active` = ? AND `category`.`visible` = ?)) GROUP BY `category`.`parent_id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  "%|c4bb4c0d23994ba3b1ccae2515ca72ab|%"
  5
  true
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
46 0.84 ms 
# header::navigation::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`file_hash` as `category.media.fileHash`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, `category.media.translation.title` as `category.media.title`, `category.media.translation.alt`, `category.media.translation.alt` as `category.media.alt`, `category.media.translation.customFields`, `category.media.translation.customFields` as `category.media.customFields`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.`language_id` = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"°¶½5§aG1¸¾'\tóX‹Ÿ"
  b"Ùa—þîóFꐾZD=q\x16J"
  b"Ä»L\r#™K£±Ì®%\x15Êr«"
]
View formatted query    View runnable query    Explain query    View query backtrace
47 0.42 ms 
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `swag_dynamic_access_category_rule` `category.swagDynamicAccessRules.mapping` ON `category`.`id` = `category.swagDynamicAccessRules.mapping`.`category_id`  AND `category`.`version_id` = `category.swagDynamicAccessRules.mapping`.`category_version_id` LEFT JOIN `rule` `category.swagDynamicAccessRules` ON `category.swagDynamicAccessRules.mapping`.`rule_id` = `category.swagDynamicAccessRules`.`id`  WHERE (`category`.`version_id` = ?) AND (((`category.swagDynamicAccessRules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?) OR `category.swagDynamicAccessRules`.`id` <=> ?))) AND (`category`.`id` IN (?, ?, ?)) GROUP BY `category`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01Ž^ /\x08qW‚ö\x1E`ÝÄÞÀ"
  b"\x08d¯\x107\F\x04§tOVS\x158G"
  b"jME~ÙMËŒ#—\x12¸õÑ\f"
  b"õÆ“è)“Fv¢Lïѳ€\x1C"
  b"7žhªàrK^¡ÁÙ"È?“\x08"
  b"\x01Ž=ºõ`\x7Fı‚Ô½‹’Ïñ"
  b"\x01Q®~\x14p¢ ²1vÞя\x04"
  b"äNg‚ÆBG·–¸‘Ï%®8÷"
  b"""
    \n
    ¾oŽH‘Bʱ¾\x06[ý\x1D†Ž
    """
  null
  b"°¶½5§aG1¸¾'\tóX‹Ÿ"
  b"Ùa—þîóFꐾZD=q\x16J"
  b"Ä»L\r#™K£±Ì®%\x15Êr«"
]
View formatted query    View runnable query    Explain query    View query backtrace
48 0.19 ms 
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"Ä»L\r#™K£±Ì®%\x15Êr«"
]
View formatted query    View runnable query    Explain query    View query backtrace
49 0.40 ms 
# navigation-route::meta-information
            SELECT LOWER(HEX(`id`)), `path`, `level`
            FROM `category`
            WHERE `id` = ? OR `parent_id` = ? OR `id` = ?
Parameters: 
[
  b"Ùa—þîóFꐾZD=q\x16J"
  b"Ùa—þîóFꐾZD=q\x16J"
  b"Ùa—þîóFꐾZD=q\x16J"
]
View formatted query    View runnable query    Explain query    View query backtrace
50 2.87 ms 
# header::navigation::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`file_hash` as `category.media.fileHash`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, `category.media.translation.title` as `category.media.title`, `category.media.translation.alt`, `category.media.translation.alt` as `category.media.alt`, `category.media.translation.customFields`, `category.media.translation.customFields` as `category.media.customFields`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.`language_id` = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND ((`category`.`path` LIKE ? AND (`category`.`level` > ? AND `category`.`level` <= ?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  "%|d96197feeef346ea90be5a443d71164a|%"
  2
  5
]
View formatted query    View runnable query    Explain query    View query backtrace
51 0.65 ms 
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `swag_dynamic_access_category_rule` `category.swagDynamicAccessRules.mapping` ON `category`.`id` = `category.swagDynamicAccessRules.mapping`.`category_id`  AND `category`.`version_id` = `category.swagDynamicAccessRules.mapping`.`category_version_id` LEFT JOIN `rule` `category.swagDynamicAccessRules` ON `category.swagDynamicAccessRules.mapping`.`rule_id` = `category.swagDynamicAccessRules`.`id`  WHERE (`category`.`version_id` = ?) AND (((`category.swagDynamicAccessRules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?) OR `category.swagDynamicAccessRules`.`id` <=> ?))) AND (`category`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY `category`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01Ž^ /\x08qW‚ö\x1E`ÝÄÞÀ"
  b"\x08d¯\x107\F\x04§tOVS\x158G"
  b"jME~ÙMËŒ#—\x12¸õÑ\f"
  b"õÆ“è)“Fv¢Lïѳ€\x1C"
  b"7žhªàrK^¡ÁÙ"È?“\x08"
  b"\x01Ž=ºõ`\x7Fı‚Ô½‹’Ïñ"
  b"\x01Q®~\x14p¢ ²1vÞя\x04"
  b"äNg‚ÆBG·–¸‘Ï%®8÷"
  b"""
    \n
    ¾oŽH‘Bʱ¾\x06[ý\x1D†Ž
    """
  null
  b"\x01nˆ#ìsâ\x01Ÿ° ÆÿÄ"
  b"\x01š¦\x1FápÎ…Õ.\x14«ëU×"
  b"\x01¾7¾xs‹2t±6\x06nà"
  b"\x08ŒÎG\x07RGàŽ:‡-Y\x16ص"
  b"\x14A\x1D,¡YDOŒˆD\x03tÚ˜Î"
  b"\x16Ö‚\x06\x11„H\x18²\x1F\x02Û\x15_Uq"
  b"*ߣ*fWJ@¶÷!âåHš2"
  b"aFÛ#ƒ\x19B\f¦êS\x01æJê¹"
  b"k>,ίøG(Œé‚\x18]>±Y"
  b"‚)EfÄ\x06F”¢]€\x1CèÄω"
  b"”\x07x:øƒ@?šäfR=›©i"
  b"¨\x03þrÝýLz–?Ç®øŽ)‚"
  b"Ä»L\r#™K£±Ì®%\x15Êr«"
  b"͝Ky?cGW¬Ùcn:j³"
  b"Ð+¼§’OސCQ%Ûý\x11_"
  b"ÓæENú/I‰¯ÐÑÜèÂ=?"
  b"ôù*NdôDˆ€'·Kœ\x11\x05š"
  b"ø^»Q°ƒN숀ˆáupá"
  b"øÿÿÓú˜CÑ•ßÄë-`Û"
  b"""
    ý a ¼MJ˜•P:…\n
    K¼,
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
52 0.39 ms 
SELECT LOWER(HEX(`category`.`parent_id`)) as `category-ids.key`, COUNT(`category`.`id`) as `category-ids.count`, COUNT(DISTINCT `category`.`id`) as `visible-children-count` FROM `category` WHERE (`category`.`version_id` = ?) AND ((`category`.`path` LIKE ? AND `category`.`level` = ? AND `category`.`active` = ? AND `category`.`visible` = ?)) GROUP BY `category`.`parent_id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  "%|d96197feeef346ea90be5a443d71164a|%"
  5
  true
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
53 0.83 ms 
# header::navigation::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`file_hash` as `category.media.fileHash`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, `category.media.translation.title` as `category.media.title`, `category.media.translation.alt`, `category.media.translation.alt` as `category.media.alt`, `category.media.translation.customFields`, `category.media.translation.customFields` as `category.media.customFields`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.`language_id` = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"°¶½5§aG1¸¾'\tóX‹Ÿ"
  b"Ùa—þîóFꐾZD=q\x16J"
]
View formatted query    View runnable query    Explain query    View query backtrace
54 0.47 ms 
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `swag_dynamic_access_category_rule` `category.swagDynamicAccessRules.mapping` ON `category`.`id` = `category.swagDynamicAccessRules.mapping`.`category_id`  AND `category`.`version_id` = `category.swagDynamicAccessRules.mapping`.`category_version_id` LEFT JOIN `rule` `category.swagDynamicAccessRules` ON `category.swagDynamicAccessRules.mapping`.`rule_id` = `category.swagDynamicAccessRules`.`id`  WHERE (`category`.`version_id` = ?) AND (((`category.swagDynamicAccessRules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?) OR `category.swagDynamicAccessRules`.`id` <=> ?))) AND (`category`.`id` IN (?, ?)) GROUP BY `category`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01Ž^ /\x08qW‚ö\x1E`ÝÄÞÀ"
  b"\x08d¯\x107\F\x04§tOVS\x158G"
  b"jME~ÙMËŒ#—\x12¸õÑ\f"
  b"õÆ“è)“Fv¢Lïѳ€\x1C"
  b"7žhªàrK^¡ÁÙ"È?“\x08"
  b"\x01Ž=ºõ`\x7Fı‚Ô½‹’Ïñ"
  b"\x01Q®~\x14p¢ ²1vÞя\x04"
  b"äNg‚ÆBG·–¸‘Ï%®8÷"
  b"""
    \n
    ¾oŽH‘Bʱ¾\x06[ý\x1D†Ž
    """
  null
  b"°¶½5§aG1¸¾'\tóX‹Ÿ"
  b"Ùa—þîóFꐾZD=q\x16J"
]
View formatted query    View runnable query    Explain query    View query backtrace
55 0.24 ms 
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"Ùa—þîóFꐾZD=q\x16J"
]
View formatted query    View runnable query    Explain query    View query backtrace
56 0.75 ms 
SELECT `handler_identifier`, LOWER(HEX(`id`)) FROM `payment_method`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
57 0.43 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"²z*šNI!Ÿ½¿[ÖlÉE"
]
View formatted query    View runnable query    Explain query    View query backtrace
58 0.25 ms 
SELECT `language`.`id` FROM `language` WHERE `language`.`id` IN (?) LIMIT 1
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
59 0.48 ms 
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.name`, `language.locale.translation.name` as `language.locale.name`, `language.locale.translation.territory`, `language.locale.translation.territory` as `language.locale.territory`, `language.locale.translation.customFields`, `language.locale.translation.customFields` as `language.locale.customFields` FROM `language` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.locale.translation`.`locale_id`, `language.locale.translation`.`name` as `language.locale.translation.name`, `language.locale.translation`.`territory` as `language.locale.translation.territory`, `language.locale.translation`.`custom_fields` as `language.locale.translation.customFields` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation`.`language_id` = ?) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE `language`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
60 0.96 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  null
  "IntediaDoofinderSW6.config.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
61 0.72 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  null
  "IntediaDoofinderSW6.config.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
62 1.43 ms 
SELECT `sales_channel_domain`.`id` as `sales_channel_domain.id`, `sales_channel_domain`.`url` as `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt`, `sales_channel_domain.language`.`id` as `sales_channel_domain.language.id`, `sales_channel_domain.language`.`parent_id` as `sales_channel_domain.language.parentId`, `sales_channel_domain.language`.`locale_id` as `sales_channel_domain.language.localeId`, `sales_channel_domain.language`.`translation_code_id` as `sales_channel_domain.language.translationCodeId`, `sales_channel_domain.language`.`name` as `sales_channel_domain.language.name`, `sales_channel_domain.language`.`custom_fields` as `sales_channel_domain.language.customFields`, `sales_channel_domain.language`.`created_at` as `sales_channel_domain.language.createdAt`, `sales_channel_domain.language`.`updated_at` as `sales_channel_domain.language.updatedAt`, `sales_channel_domain.language.locale`.`id` as `sales_channel_domain.language.locale.id`, `sales_channel_domain.language.locale`.`code` as `sales_channel_domain.language.locale.code`, `sales_channel_domain.language.locale`.`created_at` as `sales_channel_domain.language.locale.createdAt`, `sales_channel_domain.language.locale`.`updated_at` as `sales_channel_domain.language.locale.updatedAt`, `sales_channel_domain.language.locale.translation.name`, `sales_channel_domain.language.locale.translation.name` as `sales_channel_domain.language.locale.name`, `sales_channel_domain.language.locale.translation.territory`, `sales_channel_domain.language.locale.translation.territory` as `sales_channel_domain.language.locale.territory`, `sales_channel_domain.language.locale.translation.customFields`, `sales_channel_domain.language.locale.translation.customFields` as `sales_channel_domain.language.locale.customFields`, `sales_channel_domain.currency`.`id` as `sales_channel_domain.currency.id`, `sales_channel_domain.currency`.`factor` as `sales_channel_domain.currency.factor`, `sales_channel_domain.currency`.`symbol` as `sales_channel_domain.currency.symbol`, `sales_channel_domain.currency`.`iso_code` as `sales_channel_domain.currency.isoCode`, `sales_channel_domain.currency`.`position` as `sales_channel_domain.currency.position`, `sales_channel_domain.currency`.`tax_free_from` as `sales_channel_domain.currency.taxFreeFrom`, `sales_channel_domain.currency`.`item_rounding` as `sales_channel_domain.currency.itemRounding`, `sales_channel_domain.currency`.`total_rounding` as `sales_channel_domain.currency.totalRounding`, `sales_channel_domain.currency`.`created_at` as `sales_channel_domain.currency.createdAt`, `sales_channel_domain.currency`.`updated_at` as `sales_channel_domain.currency.updatedAt`, `sales_channel_domain.currency.netiCurrency`.`id` as `sales_channel_domain.currency.netiCurrency.id`, `sales_channel_domain.currency.netiCurrency`.`currency_id` as `sales_channel_domain.currency.netiCurrency.currencyID`, `sales_channel_domain.currency.netiCurrency`.`active` as `sales_channel_domain.currency.netiCurrency.active`, `sales_channel_domain.currency.netiCurrency`.`buffer` as `sales_channel_domain.currency.netiCurrency.buffer`, `sales_channel_domain.currency.netiCurrency`.`last_factor` as `sales_channel_domain.currency.netiCurrency.lastFactor`, `sales_channel_domain.currency.netiCurrency`.`last_update` as `sales_channel_domain.currency.netiCurrency.lastUpdate`, `sales_channel_domain.currency.netiCurrency`.`created_at` as `sales_channel_domain.currency.netiCurrency.createdAt`, `sales_channel_domain.currency.netiCurrency`.`updated_at` as `sales_channel_domain.currency.netiCurrency.updatedAt`, `sales_channel_domain.currency.translation.shortName`, `sales_channel_domain.currency.translation.shortName` as `sales_channel_domain.currency.shortName`, `sales_channel_domain.currency.translation.name`, `sales_channel_domain.currency.translation.name` as `sales_channel_domain.currency.name`, `sales_channel_domain.currency.translation.customFields`, `sales_channel_domain.currency.translation.customFields` as `sales_channel_domain.currency.customFields` FROM `sales_channel_domain` LEFT JOIN `language` `sales_channel_domain.language` ON `sales_channel_domain`.`language_id` = `sales_channel_domain.language`.`id` LEFT JOIN `currency` `sales_channel_domain.currency` ON `sales_channel_domain`.`currency_id` = `sales_channel_domain.currency`.`id` LEFT JOIN `locale` `sales_channel_domain.language.locale` ON `sales_channel_domain.language`.`locale_id` = `sales_channel_domain.language.locale`.`id` LEFT JOIN (SELECT `sales_channel_domain.language.locale.translation`.`locale_id`, `sales_channel_domain.language.locale.translation`.`name` as `sales_channel_domain.language.locale.translation.name`, `sales_channel_domain.language.locale.translation`.`territory` as `sales_channel_domain.language.locale.translation.territory`, `sales_channel_domain.language.locale.translation`.`custom_fields` as `sales_channel_domain.language.locale.translation.customFields` FROM `locale_translation` `sales_channel_domain.language.locale.translation` WHERE `sales_channel_domain.language.locale.translation`.`language_id` = ?) `sales_channel_domain.language.locale.locale_translation` ON `sales_channel_domain.language.locale.locale_translation`.`locale_id` = `sales_channel_domain.language.locale`.`id` LEFT JOIN `neti_current_currencies_currency` `sales_channel_domain.currency.netiCurrency` ON `sales_channel_domain.currency`.`id` = `sales_channel_domain.currency.netiCurrency`.`currency_id` LEFT JOIN (SELECT `sales_channel_domain.currency.translation`.`currency_id`, `sales_channel_domain.currency.translation`.`short_name` as `sales_channel_domain.currency.translation.shortName`, `sales_channel_domain.currency.translation`.`name` as `sales_channel_domain.currency.translation.name`, `sales_channel_domain.currency.translation`.`custom_fields` as `sales_channel_domain.currency.translation.customFields` FROM `currency_translation` `sales_channel_domain.currency.translation` WHERE `sales_channel_domain.currency.translation`.`language_id` = ?) `sales_channel_domain.currency.currency_translation` ON `sales_channel_domain.currency.currency_translation`.`currency_id` = `sales_channel_domain.currency`.`id` WHERE `sales_channel_domain`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01X<lŒx»‹tFª£Gx "
]
View formatted query    View runnable query    Explain query    View query backtrace
63 0.53 ms 
SELECT `intedia_doofinder_layer`.`id` as `intedia_doofinder_layer.id`, `intedia_doofinder_layer`.`doofinder_channel_id` as `intedia_doofinder_layer.doofinderChannelId`, `intedia_doofinder_layer`.`doofinder_hash_id` as `intedia_doofinder_layer.doofinderHashId`, `intedia_doofinder_layer`.`doofinder_store_id` as `intedia_doofinder_layer.doofinderStoreId`, `intedia_doofinder_layer`.`domain_id` as `intedia_doofinder_layer.domainId`, `intedia_doofinder_layer`.`trigger` as `intedia_doofinder_layer.trigger`, `intedia_doofinder_layer`.`name` as `intedia_doofinder_layer.name`, `intedia_doofinder_layer`.`status` as `intedia_doofinder_layer.status`, `intedia_doofinder_layer`.`status_message` as `intedia_doofinder_layer.statusMessage`, `intedia_doofinder_layer`.`status_date` as `intedia_doofinder_layer.statusDate`, `intedia_doofinder_layer`.`status_received_date` as `intedia_doofinder_layer.statusReceivedDate`, `intedia_doofinder_layer`.`created_at` as `intedia_doofinder_layer.createdAt`, `intedia_doofinder_layer`.`updated_at` as `intedia_doofinder_layer.updatedAt` FROM `intedia_doofinder_layer` WHERE (`intedia_doofinder_layer`.`domain_id` = ?)
Parameters: 
[
  b"\x01X<lŒx»‹tFª£Gx "
]
View formatted query    View runnable query    Explain query    View query backtrace
64 0.59 ms 
SELECT `sales_channel`.`id` FROM `sales_channel` LEFT JOIN `sales_channel_payment_method` `sales_channel.paymentMethods.mapping` ON `sales_channel`.`id` = `sales_channel.paymentMethods.mapping`.`sales_channel_id`  LEFT JOIN `payment_method` `sales_channel.paymentMethods` ON `sales_channel.paymentMethods.mapping`.`payment_method_id` = `sales_channel.paymentMethods`.`id`  WHERE ((`sales_channel`.`id` = ? AND `sales_channel.paymentMethods`.`id` = ? AND `sales_channel.paymentMethods`.`active` = ?)) LIMIT 1
Parameters: 
[
  b"4U0/þõH÷—÷5’6\x1Cç¡"
  b"÷¸ÉÀ\x10G\x02©ofM«þ&V"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
65 1.79 ms 
# category::data::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`file_hash` as `category.media.fileHash`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, `category.media.translation.title` as `category.media.title`, `category.media.translation.alt`, `category.media.translation.alt` as `category.media.alt`, `category.media.translation.customFields`, `category.media.translation.customFields` as `category.media.customFields`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.`language_id` = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01nˆ#ìsâ\x01Ÿ° ÆÿÄ"
]
View formatted query    View runnable query    Explain query    View query backtrace
66 0.80 ms 
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `swag_dynamic_access_category_rule` `category.swagDynamicAccessRules.mapping` ON `category`.`id` = `category.swagDynamicAccessRules.mapping`.`category_id`  AND `category`.`version_id` = `category.swagDynamicAccessRules.mapping`.`category_version_id` LEFT JOIN `rule` `category.swagDynamicAccessRules` ON `category.swagDynamicAccessRules.mapping`.`rule_id` = `category.swagDynamicAccessRules`.`id`  WHERE (`category`.`version_id` = ?) AND (((`category.swagDynamicAccessRules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?) OR `category.swagDynamicAccessRules`.`id` <=> ?))) AND (`category`.`id` IN (?)) GROUP BY `category`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01Ž^ /\x08qW‚ö\x1E`ÝÄÞÀ"
  b"\x08d¯\x107\F\x04§tOVS\x158G"
  b"jME~ÙMËŒ#—\x12¸õÑ\f"
  b"õÆ“è)“Fv¢Lïѳ€\x1C"
  b"7žhªàrK^¡ÁÙ"È?“\x08"
  b"\x01Ž=ºõ`\x7Fı‚Ô½‹’Ïñ"
  b"\x01Q®~\x14p¢ ²1vÞя\x04"
  b"äNg‚ÆBG·–¸‘Ï%®8÷"
  b"""
    \n
    ¾oŽH‘Bʱ¾\x06[ý\x1D†Ž
    """
  null
  b"\x01nˆ#ìsâ\x01Ÿ° ÆÿÄ"
]
View formatted query    View runnable query    Explain query    View query backtrace
67 1.24 ms 
# category::cms-page::read
SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`version_id` as `cms_page.versionId`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`css_class` as `cms_page.cssClass`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`id` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.id`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`active` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.active`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`duration` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.duration`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`easing` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.easing`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`bouncy` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.bouncy`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`easing_degree` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.easingDegree`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`native_scrolling` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.nativeScrolling`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`cms_page_id` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPageId`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`cms_page_version_id` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPageVersionId`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`id` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.id`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`version_id` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.versionId`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`type` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.type`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`entity` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.entity`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`css_class` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.cssClass`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`config` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.config`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`preview_media_id` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.previewMediaId`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`locked` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.locked`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`created_at` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.createdAt`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`updated_at` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.updatedAt`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation.name`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation.name` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.name`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation.customFields`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation.customFields` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.customFields`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`created_at` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.createdAt`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`updated_at` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.updatedAt`, `cms_page.translation.name`, `cms_page.translation.name` as `cms_page.name`, `cms_page.translation.customFields`, `cms_page.translation.customFields` as `cms_page.customFields` FROM `cms_page` LEFT JOIN `swag_cms_extensions_scroll_navigation_page_settings` `cms_page.swagCmsExtensionsScrollNavigationPageSettings` ON `cms_page`.`id` = `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`id` LEFT JOIN (SELECT `cms_page.translation`.`cms_page_id`, `cms_page.translation`.`cms_page_version_id`, `cms_page.translation`.`name` as `cms_page.translation.name`, `cms_page.translation`.`custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.`language_id` = ?) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.`cms_page_version_id` = `cms_page`.`version_id` LEFT JOIN `cms_page` `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage` ON `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`cms_page_id` = `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`id` AND `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`cms_page_version_id` = `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`version_id` LEFT JOIN (SELECT `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation`.`cms_page_id`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation`.`cms_page_version_id`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation`.`name` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation.name`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation`.`custom_fields` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation.customFields` FROM `cms_page_translation` `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation` WHERE `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.translation`.`language_id` = ?) `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.cms_page_translation` ON `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.cms_page_translation`.`cms_page_id` = `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`id` AND `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage.cms_page_translation`.`cms_page_version_id` = `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPage`.`version_id` WHERE (`cms_page`.`version_id` = ?) AND (`cms_page`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01nz\x14ºz;¼ªóIg„\x07"
]
View formatted query    View runnable query    Explain query    View query backtrace
68 1.67 ms 
# category::cms-page::association::sections::read
SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`position` as `cms_section.position`, `cms_section`.`type` as `cms_section.type`, `cms_section`.`locked` as `cms_section.locked`, `cms_section`.`name` as `cms_section.name`, `cms_section`.`sizing_mode` as `cms_section.sizingMode`, `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`, `cms_section`.`background_color` as `cms_section.backgroundColor`, `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`, `cms_section`.`css_class` as `cms_section.cssClass`, `cms_section`.`cms_page_id` as `cms_section.pageId`, `cms_section`.`visibility` as `cms_section.visibility`, `cms_section`.`custom_fields` as `cms_section.customFields`, `cms_section`.`version_id` as `cms_section.versionId`, `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`, `cms_section`.`created_at` as `cms_section.createdAt`, `cms_section`.`updated_at` as `cms_section.updatedAt`, `cms_section.swagCmsExtensionsScrollNavigation`.`id` as `cms_section.swagCmsExtensionsScrollNavigation.id`, `cms_section.swagCmsExtensionsScrollNavigation`.`active` as `cms_section.swagCmsExtensionsScrollNavigation.active`, `cms_section.swagCmsExtensionsScrollNavigation`.`cms_section_version_id` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSectionVersionId`, `cms_section.swagCmsExtensionsScrollNavigation`.`cms_section_id` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSectionId`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`id` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.id`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`position` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.position`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`type` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.type`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`locked` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.locked`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`name` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.name`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`sizing_mode` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.sizingMode`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`mobile_behavior` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.mobileBehavior`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`background_color` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.backgroundColor`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`background_media_id` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.backgroundMediaId`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`background_media_mode` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.backgroundMediaMode`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`css_class` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.cssClass`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`cms_page_id` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.pageId`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`visibility` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.visibility`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`custom_fields` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.customFields`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`version_id` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.versionId`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`cms_page_version_id` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.cmsPageVersionId`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`created_at` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.createdAt`, `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`updated_at` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSection.updatedAt`, `cms_section.swagCmsExtensionsScrollNavigation`.`created_at` as `cms_section.swagCmsExtensionsScrollNavigation.createdAt`, `cms_section.swagCmsExtensionsScrollNavigation`.`updated_at` as `cms_section.swagCmsExtensionsScrollNavigation.updatedAt`, `cms_section.swagCmsExtensionsScrollNavigation.translation.displayName`, `cms_section.swagCmsExtensionsScrollNavigation.translation.displayName` as `cms_section.swagCmsExtensionsScrollNavigation.displayName`, `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`config` as `cms_section.backgroundMedia.config`, `cms_section.backgroundMedia`.`path` as `cms_section.backgroundMedia.path`, `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`file_hash` as `cms_section.backgroundMedia.fileHash`, `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title`, `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt`, `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation.customFields` as `cms_section.backgroundMedia.customFields` FROM `cms_section` LEFT JOIN `swag_cms_extensions_scroll_navigation` `cms_section.swagCmsExtensionsScrollNavigation` ON `cms_section`.`id` = `cms_section.swagCmsExtensionsScrollNavigation`.`id` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN `cms_section` `cms_section.swagCmsExtensionsScrollNavigation.cmsSection` ON `cms_section.swagCmsExtensionsScrollNavigation`.`cms_section_id` = `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`id` AND `cms_section.swagCmsExtensionsScrollNavigation`.`cms_section_version_id` = `cms_section.swagCmsExtensionsScrollNavigation.cmsSection`.`version_id` LEFT JOIN (SELECT `cms_section.swagCmsExtensionsScrollNavigation.translation`.`swag_cms_extensions_scroll_navigation_id`, `cms_section.swagCmsExtensionsScrollNavigation.translation`.`display_name` as `cms_section.swagCmsExtensionsScrollNavigation.translation.displayName` FROM `swag_cms_extensions_scroll_navigation_translation` `cms_section.swagCmsExtensionsScrollNavigation.translation` WHERE `cms_section.swagCmsExtensionsScrollNavigation.translation`.`language_id` = ?) `cms_section.swagCmsExtensionsScrollNavigation.swag_cms_extensions_scroll_navigation_translation` ON `cms_section.swagCmsExtensionsScrollNavigation.swag_cms_extensions_scroll_navigation_translation`.`swag_cms_extensions_scroll_navigation_id` = `cms_section.swagCmsExtensionsScrollNavigation`.`id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation`.`media_id`, `cms_section.backgroundMedia.translation`.`alt` as `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation`.`title` as `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.`custom_fields` as `cms_section.backgroundMedia.translation.customFields` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation`.`language_id` = ?) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id` WHERE (`cms_section`.`version_id` = ?) AND ((`cms_section`.`cms_page_id` IN (?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01nz\x14ºz;¼ªóIg„\x07"
]
View formatted query    View runnable query    Explain query    View query backtrace
69 1.15 ms 
# category::cms-page::association::sections::association::blocks::read
SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`position` as `cms_block.position`, `cms_block`.`type` as `cms_block.type`, `cms_block`.`locked` as `cms_block.locked`, `cms_block`.`name` as `cms_block.name`, `cms_block`.`section_position` as `cms_block.sectionPosition`, `cms_block`.`margin_top` as `cms_block.marginTop`, `cms_block`.`margin_bottom` as `cms_block.marginBottom`, `cms_block`.`margin_left` as `cms_block.marginLeft`, `cms_block`.`margin_right` as `cms_block.marginRight`, `cms_block`.`background_color` as `cms_block.backgroundColor`, `cms_block`.`background_media_id` as `cms_block.backgroundMediaId`, `cms_block`.`background_media_mode` as `cms_block.backgroundMediaMode`, `cms_block`.`css_class` as `cms_block.cssClass`, `cms_block`.`visibility` as `cms_block.visibility`, `cms_block`.`cms_section_id` as `cms_block.sectionId`, `cms_block`.`custom_fields` as `cms_block.customFields`, `cms_block`.`version_id` as `cms_block.versionId`, `cms_block`.`cms_section_version_id` as `cms_block.cmsSectionVersionId`, `cms_block`.`created_at` as `cms_block.createdAt`, `cms_block`.`updated_at` as `cms_block.updatedAt`, `cms_block.swagCmsExtensionsBlockRule`.`id` as `cms_block.swagCmsExtensionsBlockRule.id`, `cms_block.swagCmsExtensionsBlockRule`.`inverted` as `cms_block.swagCmsExtensionsBlockRule.inverted`, `cms_block.swagCmsExtensionsBlockRule`.`visibility_rule_id` as `cms_block.swagCmsExtensionsBlockRule.visibilityRuleId`, `cms_block.swagCmsExtensionsBlockRule`.`cms_block_id` as `cms_block.swagCmsExtensionsBlockRule.cmsBlockId`, `cms_block.swagCmsExtensionsBlockRule`.`cms_block_version_id` as `cms_block.swagCmsExtensionsBlockRule.cmsBlockVersionId`, `cms_block.swagCmsExtensionsBlockRule`.`created_at` as `cms_block.swagCmsExtensionsBlockRule.createdAt`, `cms_block.swagCmsExtensionsBlockRule`.`updated_at` as `cms_block.swagCmsExtensionsBlockRule.updatedAt`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`id` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.id`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`name` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.name`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`priority` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.priority`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`description` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.description`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`payload` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.payload`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`invalid` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.invalid`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`areas` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.areas`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`custom_fields` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.customFields`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`module_types` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.moduleTypes`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`created_at` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.createdAt`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`updated_at` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.updatedAt`, `cms_block.swagCmsExtensionsQuickview`.`id` as `cms_block.swagCmsExtensionsQuickview.id`, `cms_block.swagCmsExtensionsQuickview`.`active` as `cms_block.swagCmsExtensionsQuickview.active`, `cms_block.swagCmsExtensionsQuickview`.`cms_block_id` as `cms_block.swagCmsExtensionsQuickview.cmsBlockId`, `cms_block.swagCmsExtensionsQuickview`.`cms_block_version_id` as `cms_block.swagCmsExtensionsQuickview.cmsBlockVersionId`, `cms_block.swagCmsExtensionsQuickview`.`created_at` as `cms_block.swagCmsExtensionsQuickview.createdAt`, `cms_block.swagCmsExtensionsQuickview`.`updated_at` as `cms_block.swagCmsExtensionsQuickview.updatedAt`, `cms_block.backgroundMedia`.`id` as `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` as `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` as `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` as `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` as `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` as `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` as `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` as `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` as `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` as `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`config` as `cms_block.backgroundMedia.config`, `cms_block.backgroundMedia`.`path` as `cms_block.backgroundMedia.path`, `cms_block.backgroundMedia`.`private` as `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`file_hash` as `cms_block.backgroundMedia.fileHash`, `cms_block.backgroundMedia`.`created_at` as `cms_block.backgroundMedia.createdAt`, `cms_block.backgroundMedia`.`updated_at` as `cms_block.backgroundMedia.updatedAt`, `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation.title` as `cms_block.backgroundMedia.title`, `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation.alt` as `cms_block.backgroundMedia.alt`, `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation.customFields` as `cms_block.backgroundMedia.customFields` FROM `cms_block` LEFT JOIN `swag_cms_extensions_block_rule` `cms_block.swagCmsExtensionsBlockRule` ON `cms_block`.`id` = `cms_block.swagCmsExtensionsBlockRule`.`cms_block_id` LEFT JOIN `swag_cms_extensions_quickview` `cms_block.swagCmsExtensionsQuickview` ON `cms_block`.`id` = `cms_block.swagCmsExtensionsQuickview`.`cms_block_id` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN `rule` `cms_block.swagCmsExtensionsBlockRule.visibilityRule` ON `cms_block.swagCmsExtensionsBlockRule`.`visibility_rule_id` = `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation`.`media_id`, `cms_block.backgroundMedia.translation`.`alt` as `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation`.`title` as `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.`custom_fields` as `cms_block.backgroundMedia.translation.customFields` FROM `media_translation` `cms_block.backgroundMedia.translation` WHERE `cms_block.backgroundMedia.translation`.`language_id` = ?) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation`.`media_id` = `cms_block.backgroundMedia`.`id` WHERE (`cms_block`.`version_id` = ?) AND ((`cms_block`.`cms_section_id` IN (?, ?, ?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01nz!ãwY¦\x12àWðâõÌ"
  b"\x01nŽƒ<~׈­¤³Ö‰M_"
  b"\x01™¹FðŽqq¯\x14\x04qys¨&"
]
View formatted query    View runnable query    Explain query    View query backtrace
70 0.96 ms 
# category::cms-page::association::sections::association::blocks::association::slots::read
SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`type` as `cms_slot.type`, `cms_slot`.`slot` as `cms_slot.slot`, `cms_slot`.`locked` as `cms_slot.locked`, `cms_slot`.`cms_block_id` as `cms_slot.blockId`, `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.swagCmsExtensionsForm`.`id` as `cms_slot.swagCmsExtensionsForm.id`, `cms_slot.swagCmsExtensionsForm`.`cms_slot_id` as `cms_slot.swagCmsExtensionsForm.cmsSlotId`, `cms_slot.swagCmsExtensionsForm`.`cms_slot_version_id` as `cms_slot.swagCmsExtensionsForm.cmsSlotVersionId`, `cms_slot.swagCmsExtensionsForm`.`is_template` as `cms_slot.swagCmsExtensionsForm.isTemplate`, `cms_slot.swagCmsExtensionsForm`.`technical_name` as `cms_slot.swagCmsExtensionsForm.technicalName`, `cms_slot.swagCmsExtensionsForm`.`mail_template_id` as `cms_slot.swagCmsExtensionsForm.mailTemplateId`, `cms_slot.swagCmsExtensionsForm`.`created_at` as `cms_slot.swagCmsExtensionsForm.createdAt`, `cms_slot.swagCmsExtensionsForm`.`updated_at` as `cms_slot.swagCmsExtensionsForm.updatedAt`, `cms_slot.swagCmsExtensionsForm.translation.title`, `cms_slot.swagCmsExtensionsForm.translation.title` as `cms_slot.swagCmsExtensionsForm.title`, `cms_slot.swagCmsExtensionsForm.translation.successMessage`, `cms_slot.swagCmsExtensionsForm.translation.successMessage` as `cms_slot.swagCmsExtensionsForm.successMessage`, `cms_slot.swagCmsExtensionsForm.translation.receivers`, `cms_slot.swagCmsExtensionsForm.translation.receivers` as `cms_slot.swagCmsExtensionsForm.receivers`, `cms_slot.translation.config`, `cms_slot.translation.config` as `cms_slot.config`, `cms_slot.translation.customFields`, `cms_slot.translation.customFields` as `cms_slot.customFields` FROM `cms_slot` LEFT JOIN `swag_cms_extensions_form` `cms_slot.swagCmsExtensionsForm` ON `cms_slot`.`id` = `cms_slot.swagCmsExtensionsForm`.`cms_slot_id` LEFT JOIN (SELECT `cms_slot.translation`.`cms_slot_id`, `cms_slot.translation`.`cms_slot_version_id`, `cms_slot.translation`.`config` as `cms_slot.translation.config`, `cms_slot.translation`.`custom_fields` as `cms_slot.translation.customFields` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation`.`language_id` = ?) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` AND `cms_slot.cms_slot_translation`.`cms_slot_version_id` = `cms_slot`.`version_id` LEFT JOIN (SELECT `cms_slot.swagCmsExtensionsForm.translation`.`swag_cms_extensions_form_id`, `cms_slot.swagCmsExtensionsForm.translation`.`title` as `cms_slot.swagCmsExtensionsForm.translation.title`, `cms_slot.swagCmsExtensionsForm.translation`.`success_message` as `cms_slot.swagCmsExtensionsForm.translation.successMessage`, `cms_slot.swagCmsExtensionsForm.translation`.`receivers` as `cms_slot.swagCmsExtensionsForm.translation.receivers` FROM `swag_cms_extensions_form_translation` `cms_slot.swagCmsExtensionsForm.translation` WHERE `cms_slot.swagCmsExtensionsForm.translation`.`language_id` = ?) `cms_slot.swagCmsExtensionsForm.swag_cms_extensions_form_translation` ON `cms_slot.swagCmsExtensionsForm.swag_cms_extensions_form_translation`.`swag_cms_extensions_form_id` = `cms_slot.swagCmsExtensionsForm`.`id` WHERE (`cms_slot`.`version_id` = ?) AND ((`cms_slot`.`cms_block_id` IN (?, ?, ?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01n…~u­«róz×`"
  b"\x01n”¿\x11y¢‰<û\x15 T3¯"
  b"\x01™¹G5Bz!­Å …£BOþ"
]
View formatted query    View runnable query    Explain query    View query backtrace
71 0.90 ms 
SELECT `salutation`.`id` as `salutation.id`, `salutation`.`salutation_key` as `salutation.salutationKey`, `salutation`.`created_at` as `salutation.createdAt`, `salutation`.`updated_at` as `salutation.updatedAt`, `salutation.translation.displayName`, `salutation.translation.displayName` as `salutation.displayName`, `salutation.translation.letterName`, `salutation.translation.letterName` as `salutation.letterName`, `salutation.translation.customFields`, `salutation.translation.customFields` as `salutation.customFields` FROM `salutation` LEFT JOIN (SELECT `salutation.translation`.`salutation_id`, `salutation.translation`.`display_name` as `salutation.translation.displayName`, `salutation.translation`.`letter_name` as `salutation.translation.letterName`, `salutation.translation`.`custom_fields` as `salutation.translation.customFields` FROM `salutation_translation` `salutation.translation` WHERE `salutation.translation`.`language_id` = ?) `salutation.salutation_translation` ON `salutation.salutation_translation`.`salutation_id` = `salutation`.`id`
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
72 2.04 ms 
SELECT `country`.`id` FROM `country` LEFT JOIN (SELECT `country.translation`.`country_id`, `country.translation`.`name` as `country.translation.name` FROM `country_translation` `country.translation` WHERE `country.translation`.`language_id` = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE (`country`.`active` = ?) ORDER BY `country`.`position` ASC, COALESCE(`country.translation.name`) ASC
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
73 3.06 ms 
SELECT `country`.`id` as `country.id`, `country`.`iso` as `country.iso`, `country`.`position` as `country.position`, `country`.`active` as `country.active`, `country`.`shipping_available` as `country.shippingAvailable`, `country`.`iso3` as `country.iso3`, `country`.`display_state_in_registration` as `country.displayStateInRegistration`, `country`.`force_state_in_registration` as `country.forceStateInRegistration`, `country`.`check_vat_id_pattern` as `country.checkVatIdPattern`, `country`.`vat_id_required` as `country.vatIdRequired`, `country`.`vat_id_pattern` as `country.vatIdPattern`, `country`.`customer_tax` as `country.customerTax`, `country`.`company_tax` as `country.companyTax`, `country`.`postal_code_required` as `country.postalCodeRequired`, `country`.`check_postal_code_pattern` as `country.checkPostalCodePattern`, `country`.`check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern`, `country`.`advanced_postal_code_pattern` as `country.advancedPostalCodePattern`, `country`.`default_postal_code_pattern` as `country.defaultPostalCodePattern`, `country`.`is_eu` as `country.isEu`, `country`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, `country.translation.name`, `country.translation.name` as `country.name`, `country.translation.addressFormat`, `country.translation.addressFormat` as `country.addressFormat`, `country.translation.customFields`, `country.translation.customFields` as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation`.`country_id`, `country.translation`.`name` as `country.translation.name`, `country.translation`.`custom_fields` as `country.translation.customFields`, `country.translation`.`address_format` as `country.translation.addressFormat` FROM `country_translation` `country.translation` WHERE `country.translation`.`language_id` = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Pß|Š¡>L™€´+\x1F\x04ã¬ò"
  b"\x15žK¥H\x16J–„\x07•1ÓtàÀ"
  b"P\x0F\x14½UÊD\x18»ôÛŽ&x\x1An"
  b"©\x06{\x0EgENÛ¸G\x15\x12\x11µÍÛ"
  b"\x11 \x11€ŽÛDސõA´8R´\x18"
  b"IcôÔxUII‰ÞC¥\x11‡\fr"
  b"kð\x15kQ‘OÔ¶b[oì\x16JT"
  b"Õ®kP•ôAPªÒÉqÞØ[="
  b"ÁÛ4!™\x03J$¿ÅÜ\x1DãÜUÿ"
  b"~H&Ü\rF\x15ˆ§æc\x03\e¸Æ"
  b"k×XpÁGL®b\r!­ð6â"
  b"v¦#å3¬K\x02œÁø\x07¤\æ_"
  b"WCäk#¤A‚ž¾\x174Óé\x10e"
  b"³"„[õêL)­l\e}›ËŽþ"
  b"òmÿ¿—\x08B»¦w´wyW’ª"
  b"²G\x14Ç}O¬ ‹¯ã•m>\t"
  b"§€-ŽÊKFh¤ÝÆŠ¤U’F"
  b"˜ëæÐ\x15ïHµ”‡/ä™ì®W"
  b"4ª§Aw¹LܶÖ\x1F_…V&\x1D"
  b"Á\äGwõGû‡t\x0EIÆ:D!"
  b"FJæ7EFzˆÔaØVφœ"
  b"0\x14óÓ@O‡Ž˜\fŸ]\x12\x12—"
  b"b4:L\x06”LÙ¨¼¯\x08\x06/¹L"
  b"\x06ã\x1CkëyG\§ÆÆ\r8\x14ò+"
  b"\x08Êê]zkI𮡝l\vI±<"
  b"Î^6Ö!ÕGÙª¤y.ãBè"
  b"9 9ý\x05\x03AÙ²¯Í•Â‘ÞÆ"
  b"8µ3L*¢Hë„\x07‰Ú¯Þ/±"
  b"""
    Ï`oähA ‹ÔÅ™C\n
    ôÑ
    """
  b"x¹w§\x15Gu¿•ß¼êBû\x04"
  b"Ôü‹éñ[K\x7F,CaÏÛa "
  b"p¿œ\x05dTGø–ÔDlµ|Cã"
  b"ûEBKä…TÊgü(\x11m"
  b"›qùJ\tMJR”\x7F\x1Fe—'1<"
  b"§§¬0\f¶Fý–îÎ"ÿ}c½"
  b";÷Ki¡óMçºàD–d—Ýð"
  b"½à¯s D½€ÿptQ#›Ù"
  b"""
    \x04Ur¡ùUB\n
    “¹RkB6\fý
    """
  b"£ƒ‚´Ñ0EÕ¼+HyhTÑ^"
  b"\x12çQ…8C;¸ú©ãMuïþ"
  b"ÿä8·éÌB¾”Ì ¢J,\x10w"
  b"šK*\x19þÔK’‡;›ÃÖB‚ñ"
  b"ÝDää ²K!±3§•Š\x10‚"
  b"‡BH\x1D\x19‚B\toæXšÃ\³"
  b"œGŽ…FxI›T—\x10X‚\x05·"
  b"9<W\x0E¢ŸH\e°Ž _ŒxÁó"
  b"‚<\x16ý“€Dò£±ðŽeC}ì"
  b">Ž\e\Y\x14G\x1C»Ä%>Aø\x13É"
  b"Š\x18å2Á\x1EMq‘á„̺VÜÉ"
  b"‚+5©>ÝFrˆªKÖ·_¯Ž"
  b"\x11F®Ìî0BÝ•Ó\x1E1¨3CÕ"
  b"ŽO$\x13uîG’“ °•ôrb("
  b"@ŠV?‰EBˏ„XÅa°T2"
  b"]#„ôY®F-†gö`B3ìú"
  b"Û<¯‰\x17UB¨––?}\x085i£"
  b"Sú€ '\x0EOßœÐÈ/é\x7F\tŽ"
  b"""
    ëìóƒ+nI³™²:m\n
    KKâ
    """
  b"""
    \x1F™\x0FÒ\x1A§A"¦ÒT\n
    !d\x15û
    """
  b"ýÊ\aзB‹£\x0E­¬¾\x14â°"
  b"pq_–`\x06GJ˜t-ªL\x12×b"
  b"º\x1F‘jÿÅM3¼ã2\x05­GÌ%"
  b"Þðg”\x14\x7FB±œo¼ä*ŽW"
  b"""
    \x0Eæ±ÁÌ\n
    E-ªÝwµ^}q)
    """
  b"uvdáAH€‚W32;\x08‹ý"
  b"ù™ê3¥«AÓ‹ÀSy¢2»Æ"
  b"¨bÓ-ïöFè»”bñNN‰?"
  b"j®Ï”ü{Gשּׁ7\x19ƒÕÛ^"
  b"™n¯ïñÞL‡¸Cìýh\x08\x08š"
  b":!M.\x06ƒEј$‚ÿÅ6N*"
  b"Ácî\fîÓMÞŽ˜#W£\x1A\vW"
  b"Ù\x1FZ1R—C\x13©A63\r¢‚Ô"
  b"‰˜¡‹`Mb…\x17süQ}»V"
  b"(\vžÎ8ØMe¤K(•ÿ³G\x19"
  b"\x05ÙÂ\x1C²‰Où²¸\x15¿„À|\x05"
  b"O–¸ŸQ/K\x16¥ÜT-\x0E<è«"
  b"ÈÖy\x03lºBfžâ×ýà!G\x02"
  b"\vÉ!\x16\x0EËNœ{—ž¶ó\x0Ep"
  b"""
    t"\x17Ó¿^E@¾P”\x10u‚\n
     
    """
  b"­£\x07–›vJ°¢{Œï¬ÂÐ¥"
  b"\x082Ëg7tIY¿Ü\x10Ô\x13¸kÚ"
  b"ú«Â'h.CWª|™‹çŸë\x19"
  b"\x10¬˜¯Â¤E/¸E}ôÅ\x08€"
  b"\x1D˜ByÅ=B×…\epÓN\x1F7"
  b"¤Ñ’9UÊMGµ‚p^çNq["
  b"ô\x06ÌE\x0E,JR›ä’\x19g÷xó"
  b"Ò ´s\x7FåK¦—œ}_{UÝ\t"
  b"<I\x07ÑËßAM­Æ¿^’Œ\x13G"
  b"@\x170>¥¾M\x1F¨>\x13ï8dUÈ"
  b"ÛaEï\r‘A೶%¼j¸{\x18"
  b""Òµµ\x04ÈL²˜Ð½oQ·\x19¾"
  b"ˆÿË\x10µˆBG‹×{Ì„š»\x02"
  b"àï\x12A\x1DgIÑŽ+Žë¡žØÛ"
  b"‰\x1E—áRN%¢a>ÅŽé(&"
  b"SÍ»\x01É\x14@ô•"pí*†6‰"
  b"äÌí“ÓíBÜ·>€ÝËþkï"
  b"‡f\¦ÎüBq•¤4c9Nd\x07"
  b"³\fm¹\x06\x1DOŽ¢k ´¯Ó¡"
  b"Ñ®à-ð]EHŠ3\tW·–Šo"
  b"øÃFú¢\x1EBn¹VÁ’\x02+À~"
  b"¥d%ÖöOAˆ¹|¦»‘µAs"
  b"ðÇ}žDÍJÒ…­o\x1C\x19B¹"
  b"© Ì¾wTLO£.\x1E-9¢¥Œ"
  b"\x0FÑ#ñûOG¼‹½S¨ÿ¼"
  b"\x1C\x0FFn.ŽM¹§”rÔ¤Ýû\x17"
  b"N\x12´\x1E\t\x1CK¦¬…µOEKlå"
  b"ë3\x02\x04ûwIß©Én\x13®vªD"
  b"¬kP·E¦J\x0E“\tOÂe™\x0E["
  b"”œ\x1CÚ>³B“»\x1C\x1DÜ\x00ábÜ"
  b"""
    {)!ø\n
    ÒOq¦\x1AVn"…Nš
    """
  b"""
    U\n
    \x0E¨²VJ↱\x16†•á`ø
    """
  b"ÜOÌCLOE\t«~¯­G£\ft"
  b"öŠ*ÚECÏ„Iè'×ÉO—"
  b"òOÓ\x17j\x14K‚‰G7æ•ä²\x1C"
  b"c\=f`<Có`¼ÅÜØ\x11k"
  b"4›Ú/¸DA–üwT“«Þ?"
  b"+»â"\Alª-dËGCºŠ"
  b"ÕÂLA½²K\v…sgÐð\x7FgP"
  b"9£â„µZHŸªK\x1Eæ\ekÕœ"
  b"ˆ“HÜ"ÊBÖšv\x04\x02Ÿ˜¦¡"
  b"=üw,˜©L\x18„¼ñ~‹¶ý "
  b"GÆѝÔRB•±SÅž\x15ûÁ"
  b"ð\x1FE\x1E\tÆH\x1A‘=ª€\x0E\x11K˜"
  b"\e•ù+°ãMǾ’\f\rw\x15\ˆ"
  b"áJü‘z\x13N\t„\x14!Ò\x05\x03Ÿ\x12"
  b"©jA¬ù\x00Ml™ðê÷\x12éùl"
  b"!at…pˆFÊ’.swT"]Ž"
  b"«ÜÏ\x01NCMúž™,Sé1Ä\x12"
  b"Ö\\x14¡ffN1­J¶Âuöw8"
  b"»Xi]ûgLQ¬x·\x12‡ŒµØ"
  b"'°Ì{eœL]¸Óx†Úq]•"
  b"r$è¹\x1FÝJ·­…Û3\x10S\x12œ"
  b"ëíVO÷ËOx™qrÈ]W‰-"
  b"gý\x07\x00ƒiL ¥ò\x18vvAêx"
  b"äÃ\x1AOU,J@–Pr¾Ã\rOý"
  b":‡í¯ÑoA{¤Fæ[ÚtO°"
  b"ˆÁÛ©\x01•C< ¬’îÖZ\x0FS"
  b"\x7Fô\x06ú\x1CO“‰\²„H\x11z€"
  b"ø\x17ØÆ\x1DhN'ªÁW\x1E+-\v\x1A"
  b"B¦÷ÏÕàM¼¹?ÅŒ\x1FÕ±È"
  b"C´cÊ&¾DW´3Ï2Úm½Û"
  b"ø¡\vQ|BÀˆqòø;\ˆ"
  b"¦b&WK9A´µ3ð@ìïÊ@"
  b"C"&ù\x101MH¸ò„ü×\x1DÝ"
  b"@Z*„ç_IóŽ}Ú¬>Öß]"
  b" E{ P6A7†oÓ\x08ä%‡"
  b"""
    Ua\n
    ’ýˆDr€\x12\x15À“ÍSÕ
    """
  b"\ev>³ó\x07EN¤˜\x0F‚9“¡‚"
  b"ËYôƒNºGƒ`N¯;#Þ`"
  b"cJ\f·¬™Dâ™À¾³žÿ¡d"
  b"0àdšåcB¢–»ßDªEì×"
  b"1GˆX×J\ež;ò\x03Ýj\r"
  b"¥\x15¤_’ÍFá¹Î¾®ÿWz‚"
  b"›à¥+þ\x0EK[¯»Ï\x08w§j+"
  b"Eh“Åë.C2©3ôq¿‘íÕ"
  b"•ùÏó¢[Gÿ”-vøµ€~\x08"
  b"øÆîß„„C\x1E»™¼ÑMÍ\x0EZ"
  b"6¶¨]oóI‡œ¯MX©o•‹"
  b"Æ¢ *ÂtBy–ÿÀP\x1E 9"
  b"""
    Ú`\x1A\x1C\n
    ¿F€¯ÙZÎoÆmE
    """
  b"c—ïBÕÜLY¨µ©‘sºÐ¯"
  b"7Mˆ\eÀ™F1¦Àý²\x12ÖCy"
  b"O9Ž¤ó¤J®°'­\ØA»‘"
  b"hü¤âõ·@õ»AªÁ2QÓì"
  b"\x0EÛÝ•XØKȉ\v0øjîsø"
  b"}\x06P\x04ðŸO\µT­\f^{\x13b"
  b"[öï\e`LH5¥1(Ê¼UÜ"
  b"Úûº%\x04íK2˜w¢ÿ1Xm"
  b":\x1Eh´3~L^—$èr·\x18ë"
  b"ã’à…ϝKË„\x02Á&û\eZ¦"
  b"ðÑHýØ\x0FF‹·1Ë#è;\x0E\"
  b"\x12d±MÀÛKʆ2Lõר{\n"
  b"tïŽ\x03Ϋ@ï³¹âü¡Q¤p"
  b"S‹Øtí²DrGÎÈ\x0Eä³ê"
  b"\x1A\x15%=°:O\x04–¾§èÊᎣ"
  b"?«¾ÁH A·¯\x7FóÀh@3½"
  b"©tm´·¿NÉ°`\x16Hr<¤\f"
  b"Š\x1FÉD€—Nà§\¤ç^ï©["
  b"]|gH¶ Ly¼Koy:ê\x03D"
  b"ÄE¿Ü\x1FýHÄ­\x15]ºÜwqV"
  b"w£5è\x08ÊEÒ³8ÕM¸ÿ›1"
  b"\x11É\e\rJÀO>¸\w\rŽô8¼"
  b"\x17\x05*A.Kœ¾\x0E¯r ä_="
  b"¨\x11\x11hÑõJGžYKÌW\x11\tõ"
  b"\x1E~D”\x13HHÿBªí\x1Cï´"
  b"""
    \eÊ‹AÖòFcžQ\n
    \x14·QÝ·
    """
  b"[ÌÚfÏHLtªk4¯„Ê‚™"
  b"Ch\x13\x06ÚZEX¥/¬è]\x12±ç"
  b"\x03Ô\x03å \x05@òŸ3/Ucÿn£"
  b""í¯•ÚyI¡žEÞ'£\x10‰q"
  b"ãR\frM\x1DJäˆÄ+èÈïi"
  b"""
    ûó¦óå@\—8Á\n
    ´Â´Ž
    """
  b"oùÖä%;I\x08Ž2\x056¦Á\x02Ž"
  b"¿'¬sTDL\x1CŸZ¦h …UÒ"
  b"Ð^Cƒ§\x10L,–Ïò$ýêô^"
  b"ECáYAíH÷§ÐæìÊs­s"
  b"#\x1CÿÚZú@s¯YÍÉM©Xs"
  b"‘n\x01o\x05âD\x08”‚°!Ó\x12="
  b"Ž³6ƒ"øNÕºìâÈAéçß"
  b"ÆjöpN\eD†˜¼\x14êí&Ã0"
  b"ŽßÜéÒpG+’NµÒmÞk\x08"
  b"¦\tâ\x1F\x10+Nͺ/KÞg1DG"
  b"i5GIH\x10M\x7Fáà&¬\x08€–"
  b"ÿ\x0E—ÞY§E©Ž\x14Ùбv2ƒ"
  b"Fù\tz4eCž¨0G2,\v0\x00"
  b"L\x16S\x07]A\¾\x17°©›Ùç"
  b"ŠMólç\x18N자\x05–n\x1Fu"
  b"16\x1FÂïÁJ½“6ÕR\x1D§¹\x07"
  b"õ™ð‹ÅvO»Š¿±¥Ša´Ù"
  b"\x12`:ÊãgDi†‰\rÅ2‡y<"
  b"!…DÉ,\x1DL š[EZ­\x1D\x10L"
  b"ˆ\x05IUlÛMþ½Â&›¶EB4"
  b"TªøE0ÀL{’\x12ö\x07ÿ9J\x7F"
  b"¾iÆ¢J@AÙ£ã|9°ÔÙ5"
  b"«óº|¿üKý¹ÈzÊJ\x1AÓ"
  b"ìveëõ*Fµ¿÷)à+_\x10U"
  b"W?§ö­Apœcâ1Ö©N’"
  b"6ì\v\x1C÷D5†½»WÆÚ\\x16"
  b"\v°·&-\fFê³Áµçß0ú+"
]
View formatted query    View runnable query    Explain query    View query backtrace
74 0.44 ms 
SELECT COUNT(DISTINCT `category`.`id`) as `categories` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"Ùa—þîóFꐾZD=q\x16J"
  b"Ä»L\r#™K£±Ì®%\x15Êr«"
]
View formatted query    View runnable query    Explain query    View query backtrace
75 0.60 ms 
SELECT `sales_channel`.`id` FROM `sales_channel` LEFT JOIN `sales_channel_payment_method` `sales_channel.paymentMethods.mapping` ON `sales_channel`.`id` = `sales_channel.paymentMethods.mapping`.`sales_channel_id`  LEFT JOIN `payment_method` `sales_channel.paymentMethods` ON `sales_channel.paymentMethods.mapping`.`payment_method_id` = `sales_channel.paymentMethods`.`id`  WHERE ((`sales_channel`.`id` = ? AND `sales_channel.paymentMethods`.`id` = ? AND `sales_channel.paymentMethods`.`active` = ?)) LIMIT 1
Parameters: 
[
  b"4U0/þõH÷—÷5’6\x1Cç¡"
  b"÷¸ÉÀ\x10G\x02©ofM«þ&V"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
76 0.52 ms 
SELECT `acl_role`.`privileges` AS `privileges`
            FROM `acl_role`
            INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
            WHERE `app`.`id` = ?
Parameters: 
[
  b"\x01™•^/q¦”—\t¹×c6"
]
View formatted query    View runnable query    Explain query    View query backtrace
77 0.55 ms 
SELECT `acl_role`.`privileges` AS `privileges`
            FROM `acl_role`
            INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
            WHERE `app`.`id` = ?
Parameters: 
[
  b"\x01™¾èì8s„¥P\v»‚ªÁ"
]
View formatted query    View runnable query    Explain query    View query backtrace
78 0.80 ms 
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.name`, `language.locale.translation.name` as `language.locale.name`, `language.locale.translation.territory`, `language.locale.translation.territory` as `language.locale.territory`, `language.locale.translation.customFields`, `language.locale.translation.customFields` as `language.locale.customFields` FROM `language` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.locale.translation`.`locale_id`, `language.locale.translation`.`name` as `language.locale.translation.name`, `language.locale.translation`.`territory` as `language.locale.translation.territory`, `language.locale.translation`.`custom_fields` as `language.locale.translation.customFields` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation`.`language_id` = ?) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE `language`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
79 0.58 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  b"4U0/þõH÷—÷5’6\x1Cç¡"
  "Sendinblue.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
80 0.58 ms 
SELECT `domain`.`language_id` AS languageId,
                          `domain`.`id` AS id,
                          `domain`.`url` AS url,
                          `domain`.`hreflang_use_only_locale` AS onlyLocale,
                          `locale`.`code` AS locale
            FROM `sales_channel_domain` AS `domain`
            INNER JOIN `language` ON `language`.`id` = `domain`.`language_id`
            INNER JOIN `locale` ON `locale`.`id` = `language`.`locale_id`
            WHERE `domain`.`sales_channel_id` = ?
Parameters: 
[
  b"4U0/þõH÷—÷5’6\x1Cç¡"
]
View formatted query    View runnable query    Explain query    View query backtrace
81 1.24 ms 
SELECT `seo_path_info` AS seoPathInfo, `language_id` AS languageId
            FROM `seo_url`
            WHERE `path_info` = ? AND `is_canonical` = 1 AND
                  `sales_channel_id` = ? AND `language_id` IN (?, ?)
Parameters: 
[
  "/navigation/018f6e8823ec73e281019fb0a0c6ffc4"
  b"4U0/þõH÷—÷5’6\x1Cç¡"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"–Hó8]aLU½|ÔÜhÓ\x01Ì"
]
View formatted query    View runnable query    Explain query    View query backtrace
82 0.92 ms 
SELECT `app`.`name`, `app`.`version`, `app`.`template_load_priority`
             FROM `app`
             INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id`
             WHERE `app`.`active` = 1 AND `app_template`.`active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
83 0.73 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"
  "NINJAManufacturerExtension"
]
View formatted query    View runnable query    Explain query    View query backtrace
84 0.93 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"
  "AcrisTagManagerAppCS"
]
View formatted query    View runnable query    Explain query    View query backtrace
85 0.75 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"
  "CampitVariantSwitch"
]
View formatted query    View runnable query    Explain query    View query backtrace
86 0.76 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"
  "TrustedShopsEasyIntegrationS6"
]
View formatted query    View runnable query    Explain query    View query backtrace
87 0.70 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"
  "SwagAnalytics"
]
View formatted query    View runnable query    Explain query    View query backtrace
88 0.41 ms 
SELECT path FROM category WHERE id = ?
Parameters: 
[
  b"\x01nˆ#ìsâ\x01Ÿ° ÆÿÄ"
]
View formatted query    View runnable query    Explain query    View query backtrace
89 0.52 ms 
SELECT min_search_length FROM product_search_config WHERE language_id = ?
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
90 0.41 ms 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"4U0/þõH÷—÷5’6\x1Cç¡"
  "0VthiogIldSUzrUu1wjgUkVaggn3Nlvy"
]
View formatted query    View runnable query    Explain query    View query backtrace
91 0.57 ms 
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters: 
[
  "de-DE"
]
View formatted query    View runnable query    Explain query    View query backtrace
92 1.35 ms 
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01nˆ#ìsâ\x01Ÿ° ÆÿÄ"
]
View formatted query    View runnable query    Explain query    View query backtrace
93 1.23 ms 
# breadcrumb-extension::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"Ùa—þîóFꐾZD=q\x16J"
  b"Ä»L\r#™K£±Ì®%\x15Êr«"
  b"\x01nˆ#ìsâ\x01Ÿ° ÆÿÄ"
]
View formatted query    View runnable query    Explain query    View query backtrace
94 13.65 ms 
# seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (seo_url.language_id = ?) AND (seo_url.sales_channel_id = ? OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0)
Parameters: 
[
  "/navigation/018f6e8823ec73e281019fb0a0c6ffc4"
  "/navigation/088cce47075247e08e3a872d5916d8b5"
  "/navigation/6146db238319420ca6ea5301e64aeab9"
  "/navigation/fda06120bc4d4a9895503a850a4bbc2c"
  "/navigation/d3e6454efa2f4989afd0d1dce8c23d3f"
  "/navigation/82294566c4064694a25d801ce8c4cf89"
  "/navigation/2adfa32a66574a40b6f721e2e5489a32"
  "/navigation/f85ebb51b0834eec8880888fe17570e1"
  "/navigation/d0b7686808c34439a974f217eae792aa"
  "/navigation/85ed4b988f1b499eb869a5fc03b5d36f"
  "/navigation/39e90e2776d4401dad8e83ed0cbcac3a"
  "/navigation/e3760ec9b03e4181aebc48a799eadeda"
  "/navigation/0e8d5f3598004c47888eef56f76c268a"
  "/navigation/f8c558b68e804990b91b6f71242b5f15"
  "/navigation/7cc0d0f72de24f089aafa2343e8cc1ea"
  "/navigation/9a0c19c9e21749709c8b7f2dbe833ef7"
  "/navigation/92a0905322144e7b9f56e1bfccad3ff9"
  "/navigation/788ed152e8b349889bb94e773c9683ac"
  "/navigation/222017e254114dad9cc8902ebedc295e"
  "/navigation/37deff31f6594da5a91d95e572eb3579"
  "/navigation/cf33e089be3f45a182da22417e0ae177"
  "/navigation/b508f3c54230428fbbd2177df060e408"
  "/navigation/f105f3c43c934df1bcee839bcb830777"
  "/navigation/782dd780c4ff42ff883f4c632448ccba"
  "/navigation/0fe8b77df58b46779275294c947bd905"
  "/navigation/b383e1d650f646cda0d10f523762a8c5"
  "/navigation/3f646aca9f284851b7cd74c811dabf9d"
  "/navigation/db61e315195b457cbedca5787f203ada"
  "/navigation/469391a875a5492fa5b63c5f1ee61d69"
  "/navigation/7a1709a514064f3684b7c5d50c42c3ad"
  "/navigation/425505f74c5c49a48bf55fe0b36f6efa"
  "/navigation/75a4d83adc9c4761b558ef79e16e83d9"
  "/navigation/cb2c63b1273145be9e3380d1a3e505f7"
  "/navigation/f7ee2e72e77f464983f9cf727bef6d32"
  "/navigation/47cfd1b5825742769946ec6179ec906f"
  "/navigation/3f4c23c1903541e199cacdde0159e768"
  "/navigation/09c96cbea6694721a641557e3899f793"
  "/navigation/af025bc2d1464b98b4869434b37bded9"
  "/navigation/e2a5facc79e44d169f8906b0f08c7c86"
  "/navigation/c59c194ab1514f10b10bfcf705e727be"
  "/navigation/ceee4a8debab47529cca2c7f0209d4e1"
  "/navigation/0b38c87530e648a089d3e4d8bb1adcf0"
  "/navigation/c5ab2a1861d74a9981261d7e5d43922b"
  "/navigation/696637456b3e497993ca7eadbfca5ddd"
  "/navigation/0975e541afe0417d9509ba869616d5c6"
  "/navigation/0d0a2d21bfc1496fbe4139eaaa6def23"
  "/navigation/be0a563d3c5c48a2a88556dc2cf6919e"
  "/navigation/67fd433bda244bf8b4af59d4190e03c7"
  "/navigation/c26fe1dcd7e54fd0ab7d58f0ad513239"
  "/navigation/ccdbc5e4b8c7408daf4c410159b8d4dc"
  "/navigation/f42a467083b04e38a38e0372b6900f62"
  "/navigation/52a13a086e634ce18f6f72b637e3f7e7"
  "/navigation/d67377796c8f4a3cb60b1b950c9f9968"
  "/navigation/afe1cb74876647e1a90db46c70bccebd"
  "/navigation/eda38c72035d4089a07c8c7201e9f65d"
  "/navigation/062f14f9c9a0487db02eae5a3e9adb11"
  "/navigation/bb5f7881fa724731bc790b6584dc01e2"
  "/navigation/5a6c761d8c164263ae56c5c605788f1f"
  "/navigation/c556325d1dc54036acd3d1a0c19b0734"
  "/navigation/1719dabe0e6347acb3219a77f5c9bdef"
  "/navigation/1a0d277741964e2bb69537fe7c9fff8d"
  "/navigation/52946dabdeb34e4faa80bc43b8754e48"
  "/navigation/24d27889234f4f95888b48e7f94953bc"
  "/navigation/74ec89fc157143b8b1e54404e6927a0b"
  "/navigation/f8400603f7f34ab1b16afe1e55f9bd89"
  "/navigation/fe16ab5555ca4b5bb56b4c3c7cf43487"
  "/navigation/075ee8e3fef6445e94a3471140baa5fe"
  "/navigation/8bd5623be4cf4805b79b1dc61b73f4a9"
  "/navigation/256506a01f184cc6879e658b483d48cc"
  "/navigation/d5be655976be4259b7d6a6c88436090b"
  "/navigation/52edf1c9d90e4907a30d3d9c121358eb"
  "/navigation/e252159a06e6408ab9d546d5b0b375ed"
  "/navigation/3a5c913adb774d99ab0245a1735f0a97"
  "/navigation/998a2987292f4040a20e495a584dc033"
  "/navigation/90a0c113abcf42c08b0588b40bbebb6e"
  "/navigation/ea795d635cc4409baafc3c091e50d55d"
  "/navigation/db7c411e11044d64b8fe4491836d1498"
  "/navigation/60d8b4a0293a498a99576b1864e05aa8"
  "/navigation/fb94d9f77b1648a599ecfce531b61579"
  "/navigation/9c24edcd5f9d4defafe656b3bb87eab4"
  "/navigation/4fac7ef61f48411ba03fe3749d90c071"
  "/navigation/eed6fce7b4a346c3b778ccdded7325ba"
  "/navigation/538934efa9804fcaa043a17b1cdaa3d8"
  "/navigation/57705ed93cc140bcb5417f2892c19499"
  "/navigation/8d38a5ff1e9243a186bd2115ff9eadc2"
  "/navigation/c32fa5d21dea40529095be5925262783"
  "/navigation/67f198396c94456190f14358f931c26a"
  "/navigation/025cbb13c47f42968331904c0259de0e"
  "/navigation/b72d96e714ad474eb1f1a4766cdd3aa7"
  "/navigation/c3e7a0014e394592ad0a18a8cfaf3372"
  "/navigation/8380c2c0292e4c2b995f17ac96fc221a"
  "/navigation/8ed7c5c8ce2042b3aa14428457c2a6d2"
  "/navigation/2ffd9e9d00f64b7ca75bbe1e2c061f9c"
  "/navigation/018a1991bbce4cc3a0b36881e0609858"
  "/navigation/80275fec53cc4418b13757780d0a391a"
  "/navigation/7d831bc424f94acbaded4c192b90ab00"
  "/navigation/c13385ceea66432ebf9c90b5241245fa"
  "/navigation/c21ad6b9a2674c9bbc7fc887a8f4baf8"
  "/navigation/1bfc9663a98d43ee976a5d72a1f6f952"
  "/navigation/d0b5244b803e4d8689f0cf29d1783d69"
  "/navigation/7d696320009349f59d8b4d4ae689fa0e"
  "/navigation/e162efe6834c4c18a37d89df24a85ee9"
  "/navigation/6b17b411b0894416bbec2e6152923c55"
  "/navigation/788233ee30fd4dd5bccdf1cc78307e71"
  "/navigation/68058afef9e146cfa6ac22b9ddc9b259"
  "/navigation/b34c881b75064164b353bc1dec6ac68e"
  "/navigation/c7785ee97b314f3db03edee3d9737975"
  "/navigation/93402c7a97f949a096f24dfb66d62f12"
  "/navigation/705c5df17ecd4d4e8b66cb875c4ac4a4"
  "/navigation/95e119c707fb4f108af00dabc98c1b59"
  "/navigation/517d5b4be04e48ccba78dc027a40488f"
  "/navigation/8298961aeeeb4684acbb6dbd68f4f6fa"
  "/navigation/abe4e14d48e6413d9388df40cbe44f08"
  "/navigation/a3a47692c1f14c2c8db71eecce611eca"
  "/navigation/61deb88a56e04e1c928430569113bfba"
  "/navigation/10c26629e81346f194fe697b7a75e294"
  "/navigation/9e5251b3eb3f4a268bcae8a4a30ff7f2"
  "/navigation/b589d61a2f434726a18b59767a95b99e"
  "/navigation/4400d71f465e4cd7b4242b941296f472"
  "/navigation/b732f1a97a4e44c2be17c49db554a84d"
  "/navigation/4cf6563db8b14e28b849ce9332d755ec"
  "/navigation/6e95e7e6d0f84c22ba20dfd7981594cb"
  "/navigation/ff333e1dabef4c5983af1122ed798d3e"
  "/navigation/4d22db93233d4086bfee36ef3b1f35f6"
  "/navigation/4d02dbf4122e4058bf2080900a44455a"
  "/navigation/119ae3d12644495fa6f3618364cbb727"
  "/navigation/e46870e430b747ecb2d349c455263141"
  "/navigation/be23eb58dd78417f8787ee0c6ebe330c"
  "/navigation/466647936cab40d3904d2d31ca2cf3e6"
  "/navigation/f4a44516f22b4cc8954b3cb231002411"
  "/navigation/7df08da7978d4247900f9270108bb595"
  "/navigation/d59c6fa53fc64f14ae6ee401298ee9ec"
  "/navigation/3647c4d5b9864b9797613bd740285d81"
  "/navigation/11aa8af2e5914337b80147fb3b417f01"
  "/navigation/c35da5cb62394401bb4b8a27e9e9e4ba"
  "/navigation/482b53ae8e0342b0959994dcfd22ebef"
  "/navigation/e0b14a92d05640fe9aaa7f5838123bed"
  "/navigation/2cc6f0ad58cc41f7a1e0fee5a8d69afd"
  "/navigation/522abd10811146118388dd8d252c644a"
  "/navigation/f16e91784bf44ba98025bf6d4b960eff"
  "/navigation/09e908767248492d933a52cb3f9f117b"
  "/navigation/5a365c2907fc4b92ad6865ca0dce12d4"
  "/navigation/50590070321b4992b1815c059ad59ca4"
  "/navigation/99a15c90b32244f29da88b4ab4ee3239"
  "/navigation/c2f3b04dff2648469829fa9e2f5705f9"
  "/navigation/935166103a3e490095790d4ccc314086"
  "/navigation/a25c08ee2a204af59f5efa21e30090f4"
  "/navigation/361443a7216249de96928e3d5004f452"
  "/navigation/e5b8cb522b544f1c99362ac233994e00"
  "/navigation/afc70d4cc4704282906ced99404f7a72"
  "/navigation/82b3c25a888a4ebeb5fb661ec00b8abb"
  "/navigation/cd6a8dabe66241b5ab003a60e73670fe"
  "/navigation/d84d88b1caa34b40ae32fc89a82632aa"
  "/navigation/1832298afded43d0bafb4f9adffb7f7b"
  "/navigation/47d9feac11ec4dd4aa2ca28ef647487d"
  "/navigation/11e80a654d334dae8b0a865222914898"
  "/navigation/6b1f36d3c3c74106a1e79c36f4213bc7"
  "/navigation/f4b7603bafc44414ab117c8b38cfd878"
  "/navigation/e5ce80e45abd415f8d0895ab89e06f77"
  "/navigation/cef44518aa174c05973fcdc34d5422c6"
  "/navigation/60bb56d041354f1e939e88f666a9cd65"
  "/navigation/94b5cd34662b47de98a5ca08a153d540"
  "/navigation/ee22b10674724db0b93bbefb3a53b000"
  "/navigation/051fa87536b24ad5888de4352eb66dcd"
  "/navigation/a3325dcd976744a9b7f2990703246ef7"
  "/navigation/2b60a69d4a5a47e0a3fdbf9f6d58f7e8"
  "/navigation/cfc787d6fdfa46a989f2f9ac405eb28c"
  "/navigation/4cac06891e084b4ab42034389be686a6"
  "/navigation/592dc6a003174c72939f9c9206bb9fc8"
  "/navigation/f1ebd70a55c3423d87cfc3e3b6c47a3a"
  "/navigation/97dca773c7e64a0a9382c62cbb3c3092"
  "/navigation/0d45ecb6ed3d4fd685bc2fbbc1203ecc"
  "/navigation/907f84eb71d047498c4d4a61c44c4978"
  "/navigation/742aa3c20c5f4e36977fd1158c36916a"
  "/navigation/16ad571d128444849fd08837180a1ef0"
  "/navigation/8544509a798e4615af5b534b5a35f5b5"
  "/navigation/c2c220b6478248989238c07e245fca35"
  "/navigation/a3c71aa0afd94c9aa1fe66ecd777206b"
  "/navigation/e7b72d5fccc1493c971eccb526f6d12d"
  "/navigation/7dddc7d8d1d74ef28f9c12e2e8aac677"
  "/navigation/b03a2c463c93486eacc93f4f742ea1f2"
  "/navigation/21bfb02687734332811066e98085ba11"
  "/navigation/fbbc83de22664f7994df395b2a340613"
  "/navigation/563f957f228a48fb9ef95efbe8f1ad83"
  "/navigation/15d9c5b6e04d4646a3050fc3fc2f84df"
  "/navigation/02455587dbe7441cb30b620bd222ac3b"
  "/navigation/460ad71b0a9d4b96aed25472735f4777"
  "/navigation/c0140d331b1d4802a60de10691fc3d5f"
  "/navigation/4d01fc191f9740149fdc6102711c6823"
  "/navigation/92fb2b306b8842d6a71b326857b5cbb5"
  "/navigation/40a3b520ae5d4017b6eefe15e75e1980"
  "/navigation/1392601f332c428abd4cc7398f071259"
  "/navigation/e8c6a616d32c4892998f7a8b86fba4ef"
  "/navigation/105fc3f5c83d46778ded9b38355ddb5e"
  "/navigation/abd9631fe49b40e6ac10a17cc6181df7"
  "/navigation/825c3e44198b41f48e881e722033fb9b"
  "/navigation/be585685fec1422fabf9556c5b1d4955"
  "/navigation/ee446ee6cc7b40f2903bd25891a18890"
  "/navigation/2be391b2a29a4bfeb14b1b990081ce28"
  "/navigation/614fba7efeaa40808b12f5dc90501757"
  "/navigation/ee1fb9bf87f14ec086eb23f3e27b84d0"
  "/navigation/5ec40e618a4d4e56a4f9302f29258d39"
  "/navigation/c056c12aacce442987daca041ac61028"
  "/navigation/0e837b0d82d54343bf02a58c3012111c"
  "/navigation/7ed8bb18171341e1b1cd7f0a31de5cc0"
  "/navigation/d276ad2d62db43f9bca54b5a5c8d5baf"
  "/navigation/1be5d8d2204a4fc1b589197b9c5a9db4"
  "/navigation/9b106747cfe141409c036310400259e4"
  "/navigation/6d1782600e1546f7aefc9fbde46336fe"
  "/navigation/d3584a9491e44ee5bf068f19ee855a6c"
  "/navigation/3bb178ff44ab4ecbbd4f4f6fbc99ac7b"
  "/navigation/9a7c6dfbf50a4b52927d9585366175a8"
  "/navigation/d96197feeef346ea90be5a443d71164a"
  "/navigation/c4bb4c0d23994ba3b1ccae2515ca72ab"
  "/navigation/16d6820611844818b21f02db155f5571"
  "/navigation/a803fe72ddfd4c7a963fc7aef88d2982"
  "/navigation/9407783af883403f9ae466523d9ba969"
  "/navigation/6b3e2cceaff847288ce982185d3eb159"
  "/navigation/14411d2ca159444f8c88440374da98ce"
  "/navigation/d02b90bca7924fde90435125dbfd115f"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"4U0/þõH÷—÷5’6\x1Cç¡"
]
View formatted query    View runnable query    Explain query    View query backtrace
95 0.49 ms 
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x01Ž^ /\x08qW‚ö\x1E`ÝÄÞÀ"
  b"\x08d¯\x107\F\x04§tOVS\x158G"
  b"jME~ÙMËŒ#—\x12¸õÑ\f"
  b"õÆ“è)“Fv¢Lïѳ€\x1C"
  b"7žhªàrK^¡ÁÙ"È?“\x08"
  b"\x01Ž=ºõ`\x7Fı‚Ô½‹’Ïñ"
  b"\x01Q®~\x14p¢ ²1vÞя\x04"
  b"äNg‚ÆBG·–¸‘Ï%®8÷"
  b"""
    \n
    ¾oŽH‘Bʱ¾\x06[ý\x1D†Ž
    """
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.