GET https://ets-stage.c-2439.maxcluster.net/navigation/cd6c7a26acac4b0aa79754bcb45a96cc

Response
200 OK
IP
2a05:cc00::73:225:10
Profiled on
Token
df154a

Query Metrics

25 Database Queries
23 Different statements
23.86 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
16.80 ms
(70.41%) 		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: 
[
  "/navigation/cd6c7a26acac4b0aa79754bcb45a96cc"
  "/navigation/01cc1be8a894278e4a4dc08a4939fe6a"
  "/navigation/01909b675712761c8731d9a12b7f506d"
  "/navigation/60cda19ce0904569845f4a6e76baabf1"
  "/detail/9f27ba16bbd14302af2e0a3ca7603adb"
  "/detail/75ceaed1bfe54cc999a749e48b8038de"
  "/detail/3769b088582146ba8ab76a788320d43a"
  "/detail/27192473c4f54e4aafc202b9e9b2affd"
  "/detail/d8019b30751449c4a20a5c542deb528c"
  "/detail/cbe19ccc27164f0db14fe20aa80cf3ee"
  "/detail/6ba36ffd6f54409a8dd39ef583f71608"
  "/detail/57252ed3bcd041648d2f2d83bbe85ace"
  "/detail/e80450e7242c4f6689f191838b27d224"
  "/detail/fe574e869b00441d9082b4036efc5d83"
  "/detail/f6025bef5be44d3c8cc578ae5a5b7b97"
  "/detail/4f946cd05a6a466cbd9b5e7ad6a36b1e"
  "/detail/0d347af1471146a6b17ab68479dd55f9"
  "/detail/1448521c64fb4d519648fe28a6f75042"
  "/detail/8634c58017f44658a34569c339d3b1f5"
  "/detail/0bb8c3c6ffce4d80b2a493ee324ad663"
  "/detail/4e4b90d9d7dd47f098c64cf6eb3b7476"
  "/detail/7b7df0aeb4eb4912949f7a64030e8656"
  "/detail/fff6e6ea4967489d8b9fb8061b6b43ea"
  "/detail/1239fddeb6e74104b0b01f419b67819b"
  "/detail/5d4407335ffe44fd8f4be1fa85c111f3"
  "/detail/0f637bb5e79a450cb297fc40a5d3c030"
  "/detail/b571fc3f1933407e8b739caf1669cfc4"
  "/detail/ec5ad7e472004458a092c0866116033b"
  "/detail/d16aa565ff4a4edbaec705c43b10c2c9"
  "/detail/f8327040d12f4e9fbeebf19250a408bc"
  "/detail/db6d22533f4a4d608c45aa33c0318ed8"
  "/detail/373b6435fe7449a5b3bf97c256f03b84"
  "/detail/1b787fc403be4a6b968ec8672900cecf"
  "/detail/58a2cb851dd64fbc92cb723035002160"
  "/detail/8c8a22fce8c0416ba51a3dcdbf4430ae"
  "/detail/4bfbaca522b849ce85b388af603f94ac"
  "/detail/5294de2e82194441babfc6da46c0bc70"
  "/detail/680483e6a19341c290ab70dec6aa230a"
  "/detail/feae2d95145a425ea771b083a78af971"
  "/detail/53de5cfb60f54c06b8229a35d51d684e"
  "/detail/d63506f980244349960c4774386b1f1c"
  "/detail/b35bb3ddabe54b77939e2cefb02b9e4c"
  "/detail/08d9a514240341ce8e82700181f3cf95"
  "/detail/3896230018e64f5c9bd21ce39dd088b9"
  "/detail/ef295e696f5643eaa02abf2150c7e9c9"
  "/detail/9aff6968af374dc495967e88b5b033f1"
  "/detail/29eac6e4d9b0449689b28731e59a6cee"
  "/detail/934aeb2d93e04bc5bb9649de2c8efc1e"
  "/detail/2e73bf2d9ff94b15b3a935169dbc9a39"
  "/detail/4d31d7a9c849451b96abe7d04570d79e"
  "/detail/9faddf1abc41433fa652dafbb4835ff0"
  "/detail/ca8072f278204c32b05579758c18db7c"
  "/detail/f49938b2cede4888baccca2d5c718827"
  "/detail/cd29fd8d6db14da68ee0e56af47f4864"
  "/detail/f527884cddd74023aff8829b4be04b92"
  "/detail/5b57986a57524a86b286b6393ec3db52"
  "/detail/3f8c6723ab424e3097a0d069278eb2ef"
  "/detail/6e44aa12840040e894cd11bdf64881b7"
  "/detail/732e8a59ebce499facf7eb0cc51b7deb"
  "/detail/2c7f472791b142f0a0f74c5a3bc0e0d6"
  "/detail/822706dd868c4234965652726c267394"
  "/detail/b4d655976e5345718403565f4d40d8b1"
  "/detail/0e988bd93cf7480193a2414306145727"
  "/detail/f3ad3b9db1614803b5406cbe86f3ef3d"
  "/detail/fd3fe813cf8d4386a25dd09f49f73668"
  b"oVúÚY™A ¶~ð±¥ymñ"
  b"Ã@<\x05\x05ŽAó™\x19 úZu|÷"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.41 ms
(5.89%) 		1 
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
0.55 ms
(2.30%) 		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.override_1.name`, `category.translation.name`, COALESCE(`category.translation.override_1.name`,`category.translation.name`) as `category.name`, `category.translation.override_1.breadcrumb`, `category.translation.breadcrumb`, COALESCE(`category.translation.override_1.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.override_1.slotConfig`, `category.translation.slotConfig`, COALESCE(`category.translation.override_1.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.override_1.linkType`, `category.translation.linkType`, COALESCE(`category.translation.override_1.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.override_1.internalLink`, `category.translation.internalLink`, COALESCE(`category.translation.override_1.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.override_1.externalLink`, `category.translation.externalLink`, COALESCE(`category.translation.override_1.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.override_1.linkNewTab`, `category.translation.linkNewTab`, COALESCE(`category.translation.override_1.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.override_1.description`, `category.translation.description`, COALESCE(`category.translation.override_1.description`,`category.translation.description`) as `category.description`, `category.translation.override_1.metaTitle`, `category.translation.metaTitle`, COALESCE(`category.translation.override_1.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.override_1.metaDescription`, `category.translation.metaDescription`, COALESCE(`category.translation.override_1.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.override_1.keywords`, `category.translation.keywords`, COALESCE(`category.translation.override_1.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.override_1.customFields`, `category.translation.customFields`, COALESCE(`category.translation.override_1.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.override_1`.`breadcrumb` as `category.translation.override_1.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation.override_1`.`name` as `category.translation.override_1.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation.override_1`.`custom_fields` as `category.translation.override_1.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation.override_1`.`slot_config` as `category.translation.override_1.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation.override_1`.`link_type` as `category.translation.override_1.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation.override_1`.`internal_link` as `category.translation.override_1.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation.override_1`.`external_link` as `category.translation.override_1.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation.override_1`.`link_new_tab` as `category.translation.override_1.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation.override_1`.`description` as `category.translation.override_1.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation.override_1`.`meta_title` as `category.translation.override_1.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation.override_1`.`meta_description` as `category.translation.override_1.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords`, `category.translation.override_1`.`keywords` as `category.translation.override_1.keywords` FROM `category_translation` `category.translation` LEFT JOIN `category_translation` `category.translation.override_1` ON `category.translation`.`category_id` = `category.translation.override_1`.`category_id` AND `category.translation.override_1`.`language_id` = ? AND `category.translation`.`category_version_id` = `category.translation.override_1`.`category_version_id` 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"oVúÚY™A ¶~ð±¥ymñ"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"""
    Ílz&¬¬K\n
    §—T¼´Z–Ì
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.51 ms
(2.14%) 		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 = ?))
Parameters: 
[
  b"oVúÚY™A ¶~ð±¥ymñ"
  b"Ã@<\x05\x05ŽAó™\x19 úZu|÷"
  "FISCHER-CITA-ECU-1401-522-44-2022"
  "FISCHER-CITA-ECU-1401-522-44-2022/"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.48 ms
(2.02%) 		2 
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"Ã@<\x05\x05ŽAó™\x19 úZu|÷"
  b"¸©Å╔└\x10G\x02®ofM½■&V"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(1.51%) 		1 
SELECT `handler_identifier`, LOWER(HEX(`id`)) FROM `payment_method`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(1.50%) 		1 
# 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.override_1.name`, `category.translation.name`, COALESCE(`category.translation.override_1.name`,`category.translation.name`) as `category.name`, `category.translation.override_1.breadcrumb`, `category.translation.breadcrumb`, COALESCE(`category.translation.override_1.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.override_1.slotConfig`, `category.translation.slotConfig`, COALESCE(`category.translation.override_1.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.override_1.linkType`, `category.translation.linkType`, COALESCE(`category.translation.override_1.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.override_1.internalLink`, `category.translation.internalLink`, COALESCE(`category.translation.override_1.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.override_1.externalLink`, `category.translation.externalLink`, COALESCE(`category.translation.override_1.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.override_1.linkNewTab`, `category.translation.linkNewTab`, COALESCE(`category.translation.override_1.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.override_1.description`, `category.translation.description`, COALESCE(`category.translation.override_1.description`,`category.translation.description`) as `category.description`, `category.translation.override_1.metaTitle`, `category.translation.metaTitle`, COALESCE(`category.translation.override_1.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.override_1.metaDescription`, `category.translation.metaDescription`, COALESCE(`category.translation.override_1.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.override_1.keywords`, `category.translation.keywords`, COALESCE(`category.translation.override_1.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.override_1.customFields`, `category.translation.customFields`, COALESCE(`category.translation.override_1.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.override_1`.`breadcrumb` as `category.translation.override_1.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation.override_1`.`name` as `category.translation.override_1.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation.override_1`.`custom_fields` as `category.translation.override_1.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation.override_1`.`slot_config` as `category.translation.override_1.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation.override_1`.`link_type` as `category.translation.override_1.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation.override_1`.`internal_link` as `category.translation.override_1.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation.override_1`.`external_link` as `category.translation.override_1.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation.override_1`.`link_new_tab` as `category.translation.override_1.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation.override_1`.`description` as `category.translation.override_1.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation.override_1`.`meta_title` as `category.translation.override_1.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation.override_1`.`meta_description` as `category.translation.override_1.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords`, `category.translation.override_1`.`keywords` as `category.translation.override_1.keywords` FROM `category_translation` `category.translation` LEFT JOIN `category_translation` `category.translation.override_1` ON `category.translation`.`category_id` = `category.translation.override_1`.`category_id` AND `category.translation.override_1`.`language_id` = ? AND `category.translation`.`category_version_id` = `category.translation.override_1`.`category_version_id` 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"oVúÚY™A ¶~ð±¥ymñ"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"""
    Ílz&¬¬K\n
    §—T¼´Z–Ì
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.34 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.33 ms
(1.37%) 		2 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.30 ms
(1.24%) 		1 
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.override_1.name`, `language.locale.translation.name`, COALESCE(`language.locale.translation.override_1.name`,`language.locale.translation.name`) as `language.locale.name`, `language.locale.translation.override_1.territory`, `language.locale.translation.territory`, COALESCE(`language.locale.translation.override_1.territory`,`language.locale.translation.territory`) as `language.locale.territory`, `language.locale.translation.override_1.customFields`, `language.locale.translation.customFields`, COALESCE(`language.locale.translation.override_1.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.override_1`.`name` as `language.locale.translation.override_1.name`, `language.locale.translation`.`territory` as `language.locale.translation.territory`, `language.locale.translation.override_1`.`territory` as `language.locale.translation.override_1.territory`, `language.locale.translation`.`custom_fields` as `language.locale.translation.customFields`, `language.locale.translation.override_1`.`custom_fields` as `language.locale.translation.override_1.customFields` FROM `locale_translation` `language.locale.translation` LEFT JOIN `locale_translation` `language.locale.translation.override_1` ON `language.locale.translation`.`locale_id` = `language.locale.translation.override_1`.`locale_id` AND `language.locale.translation.override_1`.`language_id` = ? 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"oVúÚY™A ¶~ð±¥ymñ"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"oVúÚY™A ¶~ð±¥ymñ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(1.15%) 		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‹×•\x1Dzv\x07žM£ž°Ó\x12h"
  b"\x01‹ë¾Jyp\‰}W'ê£e¢"
  b"\x01ŽW\v\x00\x08tQŸ\x7F\x0F›\x05 gf"
  b"\x01ïËKDs{\x0F┤߯¦èØ«/"
  b"\x01ïËA>\x05tnék,░ìªSr"
  b"\x01ì\x1Cı¼Ï\x7FÜô9üL¶╬\x14»"
  b"äNg‚ÆBG·–¸‘Ï%®8÷"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(1.09%) 		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.25 ms
(1.03%) 		1 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.22 ms
(0.93%) 		1 
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"H2E:mmF\x1Džc\x00æ Ôžë"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.19 ms
(0.80%) 		1 
SELECT path FROM category WHERE id = ?
Parameters: 
[
  b"""
    Ílz&¬¬K\n
    §—T¼´Z–Ì
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.19 ms
(0.79%) 		1 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"Ã@<\x05\x05ŽAó™\x19 úZu|÷"
  "HGy9HSwXaNTPqqnyjYhdf2bzNjbNpMmC"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.18 ms
(0.75%) 		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.16 ms
(0.67%) 		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.15 ms
(0.63%) 		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.15 ms
(0.62%) 		1 
#cart-persister::load
            SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters: 
[
  "HGy9HSwXaNTPqqnyjYhdf2bzNjbNpMmC"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.14 ms
(0.61%) 		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"Ã@<\x05\x05ŽAó™\x19 úZu|÷"
  b"ø˜ë›Ó¤E^•ŠÉ P÷§\"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.14 ms
(0.59%) 		1 
SELECT `language`.`id` FROM `language` WHERE `language`.`id` IN (?) LIMIT 1
Parameters: 
[
  b"oVúÚY™A ¶~ð±¥ymñ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.53%) 		1 
SELECT min_search_length FROM product_search_config WHERE language_id = ?
Parameters: 
[
  b"oVúÚY™A ¶~ð±¥ymñ"
]
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.