Redirect 302 redirect from GET @frontend.account.home.page (54d764)

GET https://preview.simpleproducts.de/account/login?redirectParameters=%7B%22_noStore%22%3Atrue%7D&redirectTo=frontend.account.home.page

Response
200 OK
Browse referrer URL
IP
216.73.217.54
Profiled on
Token
b1a47f

Query Metrics

45 Database Queries
39 Different statements
40.11 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
5.09 ms
(12.69%) 		1 
-- country-route::search-ids
SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id`  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` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id`  WHERE (`country`.`active` = ? AND `country.salesChannels`.`id` = ?) GROUP BY `country`.`id` ORDER BY MIN(`country`.`position`) ASC, MIN(COALESCE(`country.translation.name`)) ASC
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  b"\x01šÄ\x18ÉsK–ß¾«~—ç$"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.28 ms
(10.67%) 		5 
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`active` as `language.active`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.name`, `language.locale.translation.name` as `language.locale.name`, `language.locale.translation.territory`, `language.locale.translation.territory` as `language.locale.territory`, `language.locale.translation.customFields`, `language.locale.translation.customFields` as `language.locale.customFields` FROM `language` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.locale.translation`.`locale_id`, `language.locale.translation`.`name` as `language.locale.translation.name`, `language.locale.translation`.`territory` as `language.locale.translation.territory`, `language.locale.translation`.`custom_fields` as `language.locale.translation.customFields` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation`.`language_id` = ?) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE `language`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
3.87 ms
(9.66%) 		1 
-- country-route::association::states::read
SELECT `country_state`.`id` as `country_state.id`, `country_state`.`country_id` as `country_state.countryId`, `country_state`.`short_code` as `country_state.shortCode`, `country_state`.`position` as `country_state.position`, `country_state`.`active` as `country_state.active`, `country_state`.`created_at` as `country_state.createdAt`, `country_state`.`updated_at` as `country_state.updatedAt`, `country_state.translation.name`, `country_state.translation.name` as `country_state.name`, `country_state.translation.customFields`, `country_state.translation.customFields` as `country_state.customFields` FROM `country_state` LEFT JOIN `country` `country_state.country` ON `country_state`.`country_id` = `country_state.country`.`id` LEFT JOIN (SELECT `country_state.translation`.`country_state_id`, `country_state.translation`.`name` as `country_state.translation.name`, `country_state.translation`.`custom_fields` as `country_state.translation.customFields` FROM `country_state_translation` `country_state.translation` WHERE `country_state.translation`.`language_id` = ?) `country_state.country_state_translation` ON `country_state.country_state_translation`.`country_state_id` = `country_state`.`id` LEFT JOIN `sales_channel_country` `country_state.country.salesChannels.mapping` ON `country_state.country`.`id` = `country_state.country.salesChannels.mapping`.`country_id`  LEFT JOIN `sales_channel` `country_state.country.salesChannels` ON `country_state.country.salesChannels.mapping`.`sales_channel_id` = `country_state.country.salesChannels`.`id`  WHERE (`country_state.country.salesChannels`.`id` = ? AND (`country_state`.`country_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?))) GROUP BY `country_state`.`id` ORDER BY MIN(`country_state`.`position`) ASC, MIN(COALESCE(`country_state.translation.name`)) ASC
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01šÄ\x18ÉsK–ß¾«~—ç$"
  b"\x01‰‘t?xpgJƒ­©c²"
  b"\x01‰‘t?ãp¼³„"ï²Õþ"
  b"\x01‰‘t?äsi¶‹”õŒýËy"
  b"\x01‰‘t?åq\x12§èýà—÷l­"
  b"\x01‰‘t?çq9‹¿^»zŠÈ1"
  b"\x01‰‘t?èr'´¦—v\x11“œs"
  b"\x01‰‘t?èr'´¦—v\x12ZT½"
  b"\x01‰‘t@\x03s/”BÏúº±8„"
  b"\x01‰‘t@\x03s/”BÏú»\x19ÄŽ"
  b"\x01‰‘t@\x04r5Ž`È–(kç"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.91 ms
(4.76%) 		1 
SELECT `prems_discount_category_base`.`id` as `prems_discount_category_base.id`, `prems_discount_category_base`.`discount` as `prems_discount_category_base.discount`, `prems_discount_category_base`.`active` as `prems_discount_category_base.active`, `prems_discount_category_base`.`is_upprice` as `prems_discount_category_base.isUpprice`, `prems_discount_category_base`.`valid_from` as `prems_discount_category_base.validFrom`, `prems_discount_category_base`.`valid_until` as `prems_discount_category_base.validUntil`, `prems_discount_category_base`.`valid_until_visibility` as `prems_discount_category_base.validUntilVisibility`, `prems_discount_category_base`.`priority` as `prems_discount_category_base.priority`, `prems_discount_category_base`.`type` as `prems_discount_category_base.type`, `prems_discount_category_base`.`price_rounding` as `prems_discount_category_base.priceRounding`, `prems_discount_category_base`.`number_of_orders` as `prems_discount_category_base.numberOfOrders`, `prems_discount_category_base`.`display_type_discount_on_detail_page` as `prems_discount_category_base.displayTypeDiscountOnDetailPage`, `prems_discount_category_base`.`display_type_discount_on_listing_page` as `prems_discount_category_base.displayTypeDiscountOnListingPage`, `prems_discount_category_base`.`discount_product_stream_id` as `prems_discount_category_base.discountProductStreamId`, `prems_discount_category_base`.`discount_category_ids` as `prems_discount_category_base.discountCategoryIds`, `prems_discount_category_base`.`category_ids_mode` as `prems_discount_category_base.categoryIdsMode`, `prems_discount_category_base`.`show_discount_badge_in_listing` as `prems_discount_category_base.showDiscountBadgeInListing`, `prems_discount_category_base`.`listing_badge_text_color` as `prems_discount_category_base.listingBadgeTextColor`, `prems_discount_category_base`.`listing_badge_background_color` as `prems_discount_category_base.listingBadgeBackgroundColor`, `prems_discount_category_base`.`show_discount_infobox_in_listing` as `prems_discount_category_base.showDiscountInfoboxInListing`, `prems_discount_category_base`.`listing_infobox_icon` as `prems_discount_category_base.listingInfoboxIcon`, `prems_discount_category_base`.`listing_infobox_text_color` as `prems_discount_category_base.listingInfoboxTextColor`, `prems_discount_category_base`.`listing_infobox_background_color` as `prems_discount_category_base.listingInfoboxBackgroundColor`, `prems_discount_category_base`.`show_discount_infobox_on_detailpage` as `prems_discount_category_base.showDiscountInfoboxOnDetailpage`, `prems_discount_category_base`.`detailpage_infobox_icon` as `prems_discount_category_base.detailpageInfoboxIcon`, `prems_discount_category_base`.`detailpage_infobox_text_color` as `prems_discount_category_base.detailpageInfoboxTextColor`, `prems_discount_category_base`.`detailpage_infobox_background_color` as `prems_discount_category_base.detailpageInfoboxBackgroundColor`, `prems_discount_category_base`.`required_cookie_name` as `prems_discount_category_base.requiredCookieName`, `prems_discount_category_base`.`required_cookie_value` as `prems_discount_category_base.requiredCookieValue`, `prems_discount_category_base`.`required_url_parameter_name` as `prems_discount_category_base.requiredUrlParameterName`, `prems_discount_category_base`.`required_url_parameter_value` as `prems_discount_category_base.requiredUrlParameterValue`, `prems_discount_category_base`.`discount_customer_group_ids` as `prems_discount_category_base.discountCustomerGroupIds`, `prems_discount_category_base`.`discount_customer_ids` as `prems_discount_category_base.discountCustomerIds`, `prems_discount_category_base`.`discount_sales_channel_ids` as `prems_discount_category_base.discountSalesChannelIds`, `prems_discount_category_base`.`discount_promotions_ids` as `prems_discount_category_base.discountPromotionIds`, `prems_discount_category_base`.`block_all_other_promotions` as `prems_discount_category_base.blockAllOtherPromotions`, `prems_discount_category_base`.`created_at` as `prems_discount_category_base.createdAt`, `prems_discount_category_base`.`updated_at` as `prems_discount_category_base.updatedAt`, `prems_discount_category_base.translation.name`, `prems_discount_category_base.translation.name` as `prems_discount_category_base.name`, `prems_discount_category_base.translation.listingBadgeTitle`, `prems_discount_category_base.translation.listingBadgeTitle` as `prems_discount_category_base.listingBadgeTitle`, `prems_discount_category_base.translation.listingInfoboxTitle`, `prems_discount_category_base.translation.listingInfoboxTitle` as `prems_discount_category_base.listingInfoboxTitle`, `prems_discount_category_base.translation.listingInfoboxText`, `prems_discount_category_base.translation.listingInfoboxText` as `prems_discount_category_base.listingInfoboxText`, `prems_discount_category_base.translation.detailpageInfoboxTitle`, `prems_discount_category_base.translation.detailpageInfoboxTitle` as `prems_discount_category_base.detailpageInfoboxTitle`, `prems_discount_category_base.translation.detailpageInfoboxText`, `prems_discount_category_base.translation.detailpageInfoboxText` as `prems_discount_category_base.detailpageInfoboxText` FROM `prems_discount_category_base` LEFT JOIN (SELECT `prems_discount_category_base.translation`.`prems_discount_category_base_id`, `prems_discount_category_base.translation`.`name` as `prems_discount_category_base.translation.name`, `prems_discount_category_base.translation`.`listing_badge_title` as `prems_discount_category_base.translation.listingBadgeTitle`, `prems_discount_category_base.translation`.`listing_infobox_title` as `prems_discount_category_base.translation.listingInfoboxTitle`, `prems_discount_category_base.translation`.`listing_infobox_text` as `prems_discount_category_base.translation.listingInfoboxText`, `prems_discount_category_base.translation`.`detailpage_infobox_title` as `prems_discount_category_base.translation.detailpageInfoboxTitle`, `prems_discount_category_base.translation`.`detailpage_infobox_text` as `prems_discount_category_base.translation.detailpageInfoboxText` FROM `prems_discount_category_base_translation` `prems_discount_category_base.translation` WHERE `prems_discount_category_base.translation`.`language_id` = ?) `prems_discount_category_base.prems_discount_category_base_translation` ON `prems_discount_category_base.prems_discount_category_base_translation`.`prems_discount_category_base_id` = `prems_discount_category_base`.`id` WHERE (((`prems_discount_category_base`.`valid_from` <= ?) OR `prems_discount_category_base`.`valid_from` <=> ?) AND ((`prems_discount_category_base`.`valid_until` >= ?) OR `prems_discount_category_base`.`valid_until` <=> ?) AND `prems_discount_category_base`.`active` = ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  "2026-08-13 06:00:46.849"
  null
  "2026-08-13 06:00:46.849"
  null
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
1.50 ms
(3.74%) 		1 
-- theme-service::resolve-media::read
SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`file_hash` as `media.fileHash`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, `media.translation.title` as `media.title`, `media.translation.alt`, `media.translation.alt` as `media.alt`, `media.translation.customFields`, `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.`media_id`, `media.translation`.`alt` as `media.translation.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation`.`custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation`.`language_id` = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  false
  true
  "product_download"
  b"\x01’$Cú`\x7FÞ¢q›ç±@tÏ"
  b"\x01’$iê$qJ™©<Öª0ci"
  b"\x01’¸U²žqi£uL]vøø "
  b"\x01’$H=rq¸¼\x10nk\x1CLW›"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.43 ms
(3.58%) 		1 
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x01‰‘t@\tr®Œ:æÐä°Äù"
  b"\x01‰‘t@\x16pN¬`– È/"
  b"\x01‰‘tŽ’râ¥ßŽáZ¿^R"
  b"\x01Ža11åv\x19³\x0FM''ڏ…"
  b"\x01‰‘t@9p\x1D¯4½¡¬\vƒ\x1D"
  b"\x01¤ß4Â~ã›\rQg\fÚB'"
  b"\x01šÌ 2sè¸:1¥#7j\"
  b"\x01šÌ 8s{¬ä¨ÑÕX¢‹"
  b"\x01šÌ >q7½æ¹6ê?1¶"
  b"\x01šÌ EpN‚ÿÍW\x07»€\x14"
  b"\x01šÌ Ls\fŽœâ°~>>;"
  b"\x01šÌ Qq!©lqx~Q\x05\x06"
  b"\x01šÌ Wq”£X%¤ÈŠ\x19\x10"
  b"\x01šÌ ds[ºj¿–GylÞ"
  b"\x01šÌ-¯qk·³ú©—Âþ\x01"
  b"\x01šÌM„rÆ”Ù\x0E«]g¤’"
  b"\x01šÌf\x0Er¾»ð…L÷‚ñ›"
  b"\x01šÌfs‡ª/1\x0FQ®\x1D""
  b"\x01šÌf‡sF¼ÄV4\x1FË\v\x02"
  b"\x01šÌi€sáŠ{^RÑ%\x1Aˆ"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.20 ms
(3.00%) 		1 
-- 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: 
[
  "/account/recover"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01šÄ\x18ÉsK–ß¾«~—ç$"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.16 ms
(2.88%) 		1 
SELECT COUNT(*) FROM `wallee_transaction` LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.10 ms
(2.73%) 		1 
SELECT
    `theme_id`,
    `technical_name`,
    `resolved_config`,
    `view_inheritance`,
    `script_files`,
    `icon_sets`,
    `updated_at`
    FROM `theme_runtime_config`
    WHERE `technical_name` = ?
Parameters: 
[
  "CustomStorefront"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.99 ms
(2.47%) 		1 
-- country-route::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"\x01‰‘t?xpgJƒ­©c²"
  b"\x01‰‘t?çq9‹¿^»zŠÈ1"
  b"\x01‰‘t?ãp¼³„"ï²Õþ"
  b"\x01‰‘t?åq\x12§èýà—÷l­"
  b"\x01‰‘t@\x03s/”BÏúº±8„"
  b"\x01‰‘t?äsi¶‹”õŒýËy"
  b"\x01‰‘t@\x04r5Ž`È–(kç"
  b"\x01‰‘t@\x03s/”BÏú»\x19ÄŽ"
  b"\x01‰‘t?èr'´¦—v\x11“œs"
  b"\x01‰‘t?èr'´¦—v\x12ZT½"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.96 ms
(2.39%) 		2 
#cart-persister::load
            SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters: 
[
  "9pV8m2YQCFhFbrYcbZGKEi0xs9Dcr72j"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.88 ms
(2.20%) 		1 
SELECT `salutation`.`id` as `salutation.id`, `salutation`.`salutation_key` as `salutation.salutationKey`, `salutation`.`position` as `salutation.position`, `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
0.88 ms
(2.19%) 		1 
-- 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 = ?)) AND (seo_url.is_deleted = 0)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01šÄ\x18ÉsK–ß¾«~—ç$"
  "account/login"
  "account/login/"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.87 ms
(2.17%) 		1 
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"""
    \x01šÄ\x12:rŽœ\x16\n
    ©3…Je
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.84 ms
(2.10%) 		1 
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `swag_dynamic_access_category_rule` `category.swagDynamicAccessRules.mapping` ON `category`.`id` = `category.swagDynamicAccessRules.mapping`.`category_id`  AND `category`.`version_id` = `category.swagDynamicAccessRules.mapping`.`category_version_id` LEFT JOIN `rule` `category.swagDynamicAccessRules` ON `category.swagDynamicAccessRules.mapping`.`rule_id` = `category.swagDynamicAccessRules`.`id`  WHERE (`category`.`version_id` = ?) AND ((((`category.swagDynamicAccessRules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) OR `category.swagDynamicAccessRules`.`id` <=> ?))) AND (`category`.`id` IN (?)) GROUP BY `category`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01‰‘t@\tr®Œ:æÐä°Äù"
  b"\x01‰‘t@\x16pN¬`– È/"
  b"\x01‰‘tŽ’râ¥ßŽáZ¿^R"
  b"\x01Ža11åv\x19³\x0FM''ڏ…"
  b"\x01‰‘t@9p\x1D¯4½¡¬\vƒ\x1D"
  b"\x01¤ß4Â~ã›\rQg\fÚB'"
  b"\x01šÌ 2sè¸:1¥#7j\"
  b"\x01šÌ 8s{¬ä¨ÑÕX¢‹"
  b"\x01šÌ >q7½æ¹6ê?1¶"
  b"\x01šÌ EpN‚ÿÍW\x07»€\x14"
  b"\x01šÌ Ls\fŽœâ°~>>;"
  b"\x01šÌ Qq!©lqx~Q\x05\x06"
  b"\x01šÌ Wq”£X%¤ÈŠ\x19\x10"
  b"\x01šÌ ds[ºj¿–GylÞ"
  b"\x01šÌ-¯qk·³ú©—Âþ\x01"
  b"\x01šÌM„rÆ”Ù\x0E«]g¤’"
  b"\x01šÌf\x0Er¾»ð…L÷‚ñ›"
  b"\x01šÌfs‡ª/1\x0FQ®\x1D""
  b"\x01šÌf‡sF¼ÄV4\x1FË\v\x02"
  b"\x01šÌi€sáŠ{^RÑ%\x1Aˆ"
  null
  b"""
    \x01šÄ\x12:rŽœ\x16\n
    ©3…Je
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.76 ms
(1.88%) 		1 
INSERT INTO `pickware_license_bundle_plugin_installation` (
                `id`,
                `installation_id`,
                `created_at`
            ) VALUES (
                ?,
                
        UNHEX(CONCAT(
            LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, "0"),
            LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, "0"),
            LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, "0"),
            "4",
            LPAD(HEX(FLOOR(RAND() * 0x0fff)), 3, "0"),
            HEX(FLOOR(RAND() * 4 + 8)),
            LPAD(HEX(FLOOR(RAND() * 0x0fff)), 3, "0"),
            LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, "0"),
            LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, "0"),
            LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, "0")
        )),
                UTC_TIMESTAMP(3)
            ) ON DUPLICATE KEY UPDATE `id` = `id`
Parameters: 
[
  b"¸Ts\x01\x16\x07AQˆc(Ì9)£i"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.72 ms
(1.78%) 		1 
SELECT id FROM `pickware_erp_return_order_line_item` LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.70 ms
(1.75%) 		1 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  b"\x01šÄ\x18ÉsK–ß¾«~—ç$"
  "Sendinblue.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.68 ms
(1.71%) 		1 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.68 ms
(1.71%) 		1 
SELECT `pickware_license_bundle_plugin_installation`.`id` as `pickware_license_bundle_plugin_installation.id`, `pickware_license_bundle_plugin_installation`.`installation_id` as `pickware_license_bundle_plugin_installation.installationId`, `pickware_license_bundle_plugin_installation`.`installation_uuid` as `pickware_license_bundle_plugin_installation.installationUuid`, `pickware_license_bundle_plugin_installation`.`pickware_account_access_token` as `pickware_license_bundle_plugin_installation.pickwareAccountAccessToken`, `pickware_license_bundle_plugin_installation`.`pickware_license` as `pickware_license_bundle_plugin_installation.pickwareLicense`, `pickware_license_bundle_plugin_installation`.`pickware_license_lease` as `pickware_license_bundle_plugin_installation.pickwareLicenseLease`, `pickware_license_bundle_plugin_installation`.`latest_pickware_license_lease_refresh_error` as `pickware_license_bundle_plugin_installation.latestPickwareLicenseLeaseRefreshError`, `pickware_license_bundle_plugin_installation`.`latest_pickware_license_refresh_error` as `pickware_license_bundle_plugin_installation.latestPickwareLicenseRefreshError`, `pickware_license_bundle_plugin_installation`.`latest_usage_report_error` as `pickware_license_bundle_plugin_installation.latestUsageReportError`, `pickware_license_bundle_plugin_installation`.`last_pickware_license_lease_refreshed_at` as `pickware_license_bundle_plugin_installation.lastPickwareLicenseLeaseRefreshedAt`, `pickware_license_bundle_plugin_installation`.`created_at` as `pickware_license_bundle_plugin_installation.createdAt`, `pickware_license_bundle_plugin_installation`.`updated_at` as `pickware_license_bundle_plugin_installation.updatedAt` FROM `pickware_license_bundle_plugin_installation` WHERE `pickware_license_bundle_plugin_installation`.`id` IN (?)
Parameters: 
[
  b"¸Ts\x01\x16\x07AQˆc(Ì9)£i"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.67 ms
(1.68%) 		1 
SELECT pm.`handler_identifier`, LOWER(HEX(sc_pm.`payment_method_id`))
                FROM `sales_channel_payment_method` AS sc_pm
                LEFT JOIN `payment_method` AS pm ON pm.`id` = sc_pm.`payment_method_id`
                WHERE sc_pm.`sales_channel_id` = ? AND pm.`active` = 1
Parameters: 
[
  b"\x01šÄ\x18ÉsK–ß¾«~—ç$"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.65 ms
(1.61%) 		1 
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters: 
[
  "de-DE"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.64 ms
(1.60%) 		1 
SELECT `version` FROM `plugin` WHERE `base_class` = ? LIMIT 1
Parameters: 
[
  "Klaviyo\Integration\klavi_overd"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.63 ms
(1.58%) 		1 
# 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
0.59 ms
(1.47%) 		1 
SELECT `app`.`name`, `app`.`version`, `app`.`template_load_priority`
             FROM `app`
             INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id`
             WHERE `app`.`active` = 1 AND `app_template`.`active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.58 ms
(1.44%) 		1 
SELECT `sales_channel_country`.`sales_channel_id`, `sales_channel_country`.`country_id` FROM `sales_channel_country` WHERE (`sales_channel_country`.`sales_channel_id` = ? AND `sales_channel_country`.`country_id` = ?)
Parameters: 
[
  b"\x01šÄ\x18ÉsK–ß¾«~—ç$"
  b"\x01‰‘t?xpgJƒ­©c²"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(1.43%) 		1 
SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(1.42%) 		1 
SELECT `name`, `path`, `author`, `self_managed`
                FROM `app`
                WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(1.42%) 		1 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"\x01šÄ\x18ÉsK–ß¾«~—ç$"
  "9pV8m2YQCFhFbrYcbZGKEi0xs9Dcr72j"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.52 ms
(1.30%) 		1 
SELECT path FROM category WHERE id = ?
Parameters: 
[
  b"""
    \x01šÄ\x12:rŽœ\x16\n
    ©3…Je
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.50 ms
(1.24%) 		1 
SELECT `pickware_shipping_sales_channel_api_context`.`sales_channel_context_token` as `pickware_shipping_sales_channel_api_context.salesChannelContextToken`, `pickware_shipping_sales_channel_api_context`.`payload` as `pickware_shipping_sales_channel_api_context.payload`, `pickware_shipping_sales_channel_api_context`.`created_at` as `pickware_shipping_sales_channel_api_context.createdAt`, `pickware_shipping_sales_channel_api_context`.`updated_at` as `pickware_shipping_sales_channel_api_context.updatedAt` FROM `pickware_shipping_sales_channel_api_context` WHERE `pickware_shipping_sales_channel_api_context`.`sales_channel_context_token` IN (?)
Parameters: 
[
  "9pV8m2YQCFhFbrYcbZGKEi0xs9Dcr72j"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.49 ms
(1.21%) 		1 
SELECT DISTINCT LOWER(HEX(discount_product_stream_id)) as discount_product_stream_id
    FROM prems_discount_category_base
    WHERE id IN (NULL)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.47 ms
(1.17%) 		2 
SELECT url FROM sales_channel_domain
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.46 ms
(1.15%) 		1 
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
0.44 ms
(1.09%) 		1 
-- seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (path_info = ?) AND (is_canonical = 1) AND (is_deleted = 0) LIMIT 1
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01šÄ\x18ÉsK–ß¾«~—ç$"
  "/account/login"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.41 ms
(1.03%) 		1 
SELECT shipping_costs FROM `pickware_erp_return_order` LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.34 ms
(0.86%) 		1 
SELECT id FROM `order_return` LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.28 ms
(0.70%) 		1 
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
0.22 ms
(0.55%) 		1 
SELECT DISTINCT `technical_name`
    FROM `theme_runtime_config`
    WHERE `technical_name` IS NOT NULL
Parameters: 
[]
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.