GET https://hauptbuchhandlung.staging.eurosoft.network/search?search=UTB%20M

Response
200 OK
IP
216.73.217.23
Profiled on
Token
4eb747

Query Metrics

91 Database Queries
54 Different statements
376.29 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
72.98 ms
(19.39%) 		1 
-- magazine-article-listing::aggregation::magazine-article-category
SELECT LOWER(HEX(`moorl_magazine_article.categories`.`id`)) as `magazine-article-category` FROM `moorl_magazine_article` LEFT JOIN `moorl_magazine_article_sales_channel` `moorl_magazine_article.salesChannels.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.salesChannels.mapping`.`article_id`  LEFT JOIN `moorl_magazine_article_customer_group` `moorl_magazine_article.customerGroups.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.customerGroups.mapping`.`article_id`  INNER JOIN (SELECT SUM(IF(COALESCE(`moorl_magazine_article.translation.name`) = ? , '500', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE ? , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = ? , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE ? , '125', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = ? , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE ? , '125', 0)) / COUNT(moorl_magazine_article.id) as _score, `moorl_magazine_article`.`id` FROM `moorl_magazine_article` LEFT JOIN `moorl_magazine_article_sales_channel` `moorl_magazine_article.salesChannels.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.salesChannels.mapping`.`article_id`  LEFT JOIN `moorl_magazine_article_customer_group` `moorl_magazine_article.customerGroups.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.customerGroups.mapping`.`article_id`  LEFT JOIN (SELECT `moorl_magazine_article.translation`.`moorl_magazine_article_id`, `moorl_magazine_article.translation`.`name` as `moorl_magazine_article.translation.name`, `moorl_magazine_article.translation`.`content` as `moorl_magazine_article.translation.content`, `moorl_magazine_article.translation`.`meta_description` as `moorl_magazine_article.translation.metaDescription` FROM `moorl_magazine_article_translation` `moorl_magazine_article.translation` WHERE `moorl_magazine_article.translation`.`language_id` = ?) `moorl_magazine_article.moorl_magazine_article_translation` ON `moorl_magazine_article.moorl_magazine_article_translation`.`moorl_magazine_article_id` = `moorl_magazine_article`.`id` LEFT JOIN `sales_channel` `moorl_magazine_article.salesChannels` ON `moorl_magazine_article.salesChannels.mapping`.`sales_channel_id` = `moorl_magazine_article.salesChannels`.`id`  LEFT JOIN `customer_group` `moorl_magazine_article.customerGroups` ON `moorl_magazine_article.customerGroups.mapping`.`customer_group_id` = `moorl_magazine_article.customerGroups`.`id`  WHERE (((`moorl_magazine_article`.`active` = ? AND ((`moorl_magazine_article`.`show_from` <=> ? OR (`moorl_magazine_article`.`show_from` <= ?)) AND (`moorl_magazine_article`.`show_until` <=> ? OR (`moorl_magazine_article`.`show_until` >= ?))) AND (`moorl_magazine_article.salesChannels`.`id` <=> ? OR `moorl_magazine_article.salesChannels`.`id` = ?) AND (`moorl_magazine_article.customerGroups`.`id` <=> ? OR `moorl_magazine_article.customerGroups`.`id` = ?) AND `moorl_magazine_article`.`invisible` = ?) AND `moorl_magazine_article`.`invisible` = ?)) AND (COALESCE(`moorl_magazine_article.translation.name`) = ? OR COALESCE(`moorl_magazine_article.translation.name`) LIKE ? OR COALESCE(`moorl_magazine_article.translation.content`) = ? OR COALESCE(`moorl_magazine_article.translation.content`) LIKE ? OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = ? OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE ?) GROUP BY id HAVING _score >= ? ORDER BY _score DESC) score_table ON score_table.`id` = `moorl_magazine_article`.`id`  LEFT JOIN `moorl_magazine_article_category` `moorl_magazine_article.categories.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.categories.mapping`.`article_id`  LEFT JOIN `sales_channel` `moorl_magazine_article.salesChannels` ON `moorl_magazine_article.salesChannels.mapping`.`sales_channel_id` = `moorl_magazine_article.salesChannels`.`id`  LEFT JOIN `customer_group` `moorl_magazine_article.customerGroups` ON `moorl_magazine_article.customerGroups.mapping`.`customer_group_id` = `moorl_magazine_article.customerGroups`.`id`  LEFT JOIN `moorl_magazine_category` `moorl_magazine_article.categories` ON `moorl_magazine_article.categories.mapping`.`category_id` = `moorl_magazine_article.categories`.`id`  WHERE ((`moorl_magazine_article`.`active` = ? AND ((`moorl_magazine_article`.`show_from` <=> ? OR (`moorl_magazine_article`.`show_from` <= ?)) AND (`moorl_magazine_article`.`show_until` <=> ? OR (`moorl_magazine_article`.`show_until` >= ?))) AND (`moorl_magazine_article.salesChannels`.`id` <=> ? OR `moorl_magazine_article.salesChannels`.`id` = ?) AND (`moorl_magazine_article.customerGroups`.`id` <=> ? OR `moorl_magazine_article.customerGroups`.`id` = ?) AND `moorl_magazine_article`.`invisible` = ?) AND `moorl_magazine_article`.`invisible` = ?) GROUP BY `moorl_magazine_article.categories`.`id`
Parameters: 
[
  "UTB M"
  "%UTB M%"
  "UTB M"
  "%UTB M%"
  "UTB M"
  "%UTB M%"
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  null
  "2026-10-01 21:44:10"
  null
  "2026-10-01 21:44:10"
  null
  b"\x01‘J13£x"‰m\fp²ý;g"
  null
  b"ϽP\x18ÓŽAØ­Ê\x10ÙOȽÖ"
  false
  false
  "UTB M"
  "%UTB M%"
  "UTB M"
  "%UTB M%"
  "UTB M"
  "%UTB M%"
  125.0
  true
  null
  "2026-10-01 21:44:10"
  null
  "2026-10-01 21:44:10"
  null
  b"\x01‘J13£x"‰m\fp²ý;g"
  null
  b"ϽP\x18ÓŽAØ­Ê\x10ÙOȽÖ"
  false
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
62.58 ms
(16.63%) 		1 
-- magazine-article-listing::aggregation::child-category
SELECT LOWER(HEX(`moorl_magazine_article.swCategories`.`id`)) as `child-category` FROM `moorl_magazine_article` LEFT JOIN `moorl_magazine_article_sales_channel` `moorl_magazine_article.salesChannels.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.salesChannels.mapping`.`article_id`  LEFT JOIN `moorl_magazine_article_customer_group` `moorl_magazine_article.customerGroups.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.customerGroups.mapping`.`article_id`  INNER JOIN (SELECT SUM(IF(COALESCE(`moorl_magazine_article.translation.name`) = ? , '500', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE ? , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = ? , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE ? , '125', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = ? , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE ? , '125', 0)) / COUNT(moorl_magazine_article.id) as _score, `moorl_magazine_article`.`id` FROM `moorl_magazine_article` LEFT JOIN `moorl_magazine_article_sales_channel` `moorl_magazine_article.salesChannels.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.salesChannels.mapping`.`article_id`  LEFT JOIN `moorl_magazine_article_customer_group` `moorl_magazine_article.customerGroups.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.customerGroups.mapping`.`article_id`  LEFT JOIN (SELECT `moorl_magazine_article.translation`.`moorl_magazine_article_id`, `moorl_magazine_article.translation`.`name` as `moorl_magazine_article.translation.name`, `moorl_magazine_article.translation`.`content` as `moorl_magazine_article.translation.content`, `moorl_magazine_article.translation`.`meta_description` as `moorl_magazine_article.translation.metaDescription` FROM `moorl_magazine_article_translation` `moorl_magazine_article.translation` WHERE `moorl_magazine_article.translation`.`language_id` = ?) `moorl_magazine_article.moorl_magazine_article_translation` ON `moorl_magazine_article.moorl_magazine_article_translation`.`moorl_magazine_article_id` = `moorl_magazine_article`.`id` LEFT JOIN `sales_channel` `moorl_magazine_article.salesChannels` ON `moorl_magazine_article.salesChannels.mapping`.`sales_channel_id` = `moorl_magazine_article.salesChannels`.`id`  LEFT JOIN `customer_group` `moorl_magazine_article.customerGroups` ON `moorl_magazine_article.customerGroups.mapping`.`customer_group_id` = `moorl_magazine_article.customerGroups`.`id`  WHERE (((`moorl_magazine_article`.`active` = ? AND ((`moorl_magazine_article`.`show_from` <=> ? OR (`moorl_magazine_article`.`show_from` <= ?)) AND (`moorl_magazine_article`.`show_until` <=> ? OR (`moorl_magazine_article`.`show_until` >= ?))) AND (`moorl_magazine_article.salesChannels`.`id` <=> ? OR `moorl_magazine_article.salesChannels`.`id` = ?) AND (`moorl_magazine_article.customerGroups`.`id` <=> ? OR `moorl_magazine_article.customerGroups`.`id` = ?) AND `moorl_magazine_article`.`invisible` = ?) AND `moorl_magazine_article`.`invisible` = ?)) AND (COALESCE(`moorl_magazine_article.translation.name`) = ? OR COALESCE(`moorl_magazine_article.translation.name`) LIKE ? OR COALESCE(`moorl_magazine_article.translation.content`) = ? OR COALESCE(`moorl_magazine_article.translation.content`) LIKE ? OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = ? OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE ?) GROUP BY id HAVING _score >= ? ORDER BY _score DESC) score_table ON score_table.`id` = `moorl_magazine_article`.`id`  LEFT JOIN `moorl_magazine_article_sw_category` `moorl_magazine_article.swCategories.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.swCategories.mapping`.`article_id`  LEFT JOIN `sales_channel` `moorl_magazine_article.salesChannels` ON `moorl_magazine_article.salesChannels.mapping`.`sales_channel_id` = `moorl_magazine_article.salesChannels`.`id`  LEFT JOIN `customer_group` `moorl_magazine_article.customerGroups` ON `moorl_magazine_article.customerGroups.mapping`.`customer_group_id` = `moorl_magazine_article.customerGroups`.`id`  LEFT JOIN `category` `moorl_magazine_article.swCategories` ON `moorl_magazine_article.swCategories.mapping`.`category_id` = `moorl_magazine_article.swCategories`.`id`  WHERE (((`moorl_magazine_article`.`active` = ? AND ((`moorl_magazine_article`.`show_from` <=> ? OR (`moorl_magazine_article`.`show_from` <= ?)) AND (`moorl_magazine_article`.`show_until` <=> ? OR (`moorl_magazine_article`.`show_until` >= ?))) AND (`moorl_magazine_article.salesChannels`.`id` <=> ? OR `moorl_magazine_article.salesChannels`.`id` = ?) AND (`moorl_magazine_article.customerGroups`.`id` <=> ? OR `moorl_magazine_article.customerGroups`.`id` = ?) AND `moorl_magazine_article`.`invisible` = ?) AND `moorl_magazine_article`.`invisible` = ?)) AND ((`moorl_magazine_article.swCategories`.`path` LIKE ?)) GROUP BY `moorl_magazine_article.swCategories`.`id`
Parameters: 
[
  "UTB M"
  "%UTB M%"
  "UTB M"
  "%UTB M%"
  "UTB M"
  "%UTB M%"
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  null
  "2026-10-01 21:44:10"
  null
  "2026-10-01 21:44:10"
  null
  b"\x01‘J13£x"‰m\fp²ý;g"
  null
  b"ϽP\x18ÓŽAØ­Ê\x10ÙOȽÖ"
  false
  false
  "UTB M"
  "%UTB M%"
  "UTB M"
  "%UTB M%"
  "UTB M"
  "%UTB M%"
  125.0
  true
  null
  "2026-10-01 21:44:10"
  null
  "2026-10-01 21:44:10"
  null
  b"\x01‘J13£x"‰m\fp²ý;g"
  null
  b"ϽP\x18ÓŽAØ­Ê\x10ÙOȽÖ"
  false
  false
  "%01918e435cac74ae90d65f9cea64ce79%"
]
View formatted query    View runnable query    Explain query    View query backtrace
58.54 ms
(15.56%) 		1 
-- magazine-article-listing::aggregation::tag
SELECT LOWER(HEX(`moorl_magazine_article.tags`.`id`)) as `tag` FROM `moorl_magazine_article` LEFT JOIN `moorl_magazine_article_sales_channel` `moorl_magazine_article.salesChannels.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.salesChannels.mapping`.`article_id`  LEFT JOIN `moorl_magazine_article_customer_group` `moorl_magazine_article.customerGroups.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.customerGroups.mapping`.`article_id`  INNER JOIN (SELECT SUM(IF(COALESCE(`moorl_magazine_article.translation.name`) = ? , '500', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE ? , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = ? , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE ? , '125', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = ? , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE ? , '125', 0)) / COUNT(moorl_magazine_article.id) as _score, `moorl_magazine_article`.`id` FROM `moorl_magazine_article` LEFT JOIN `moorl_magazine_article_sales_channel` `moorl_magazine_article.salesChannels.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.salesChannels.mapping`.`article_id`  LEFT JOIN `moorl_magazine_article_customer_group` `moorl_magazine_article.customerGroups.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.customerGroups.mapping`.`article_id`  LEFT JOIN (SELECT `moorl_magazine_article.translation`.`moorl_magazine_article_id`, `moorl_magazine_article.translation`.`name` as `moorl_magazine_article.translation.name`, `moorl_magazine_article.translation`.`content` as `moorl_magazine_article.translation.content`, `moorl_magazine_article.translation`.`meta_description` as `moorl_magazine_article.translation.metaDescription` FROM `moorl_magazine_article_translation` `moorl_magazine_article.translation` WHERE `moorl_magazine_article.translation`.`language_id` = ?) `moorl_magazine_article.moorl_magazine_article_translation` ON `moorl_magazine_article.moorl_magazine_article_translation`.`moorl_magazine_article_id` = `moorl_magazine_article`.`id` LEFT JOIN `sales_channel` `moorl_magazine_article.salesChannels` ON `moorl_magazine_article.salesChannels.mapping`.`sales_channel_id` = `moorl_magazine_article.salesChannels`.`id`  LEFT JOIN `customer_group` `moorl_magazine_article.customerGroups` ON `moorl_magazine_article.customerGroups.mapping`.`customer_group_id` = `moorl_magazine_article.customerGroups`.`id`  WHERE (((`moorl_magazine_article`.`active` = ? AND ((`moorl_magazine_article`.`show_from` <=> ? OR (`moorl_magazine_article`.`show_from` <= ?)) AND (`moorl_magazine_article`.`show_until` <=> ? OR (`moorl_magazine_article`.`show_until` >= ?))) AND (`moorl_magazine_article.salesChannels`.`id` <=> ? OR `moorl_magazine_article.salesChannels`.`id` = ?) AND (`moorl_magazine_article.customerGroups`.`id` <=> ? OR `moorl_magazine_article.customerGroups`.`id` = ?) AND `moorl_magazine_article`.`invisible` = ?) AND `moorl_magazine_article`.`invisible` = ?)) AND (COALESCE(`moorl_magazine_article.translation.name`) = ? OR COALESCE(`moorl_magazine_article.translation.name`) LIKE ? OR COALESCE(`moorl_magazine_article.translation.content`) = ? OR COALESCE(`moorl_magazine_article.translation.content`) LIKE ? OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = ? OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE ?) GROUP BY id HAVING _score >= ? ORDER BY _score DESC) score_table ON score_table.`id` = `moorl_magazine_article`.`id`  LEFT JOIN `moorl_magazine_article_tag` `moorl_magazine_article.tags.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.tags.mapping`.`article_id`  LEFT JOIN `sales_channel` `moorl_magazine_article.salesChannels` ON `moorl_magazine_article.salesChannels.mapping`.`sales_channel_id` = `moorl_magazine_article.salesChannels`.`id`  LEFT JOIN `customer_group` `moorl_magazine_article.customerGroups` ON `moorl_magazine_article.customerGroups.mapping`.`customer_group_id` = `moorl_magazine_article.customerGroups`.`id`  LEFT JOIN `tag` `moorl_magazine_article.tags` ON `moorl_magazine_article.tags.mapping`.`tag_id` = `moorl_magazine_article.tags`.`id`  WHERE ((`moorl_magazine_article`.`active` = ? AND ((`moorl_magazine_article`.`show_from` <=> ? OR (`moorl_magazine_article`.`show_from` <= ?)) AND (`moorl_magazine_article`.`show_until` <=> ? OR (`moorl_magazine_article`.`show_until` >= ?))) AND (`moorl_magazine_article.salesChannels`.`id` <=> ? OR `moorl_magazine_article.salesChannels`.`id` = ?) AND (`moorl_magazine_article.customerGroups`.`id` <=> ? OR `moorl_magazine_article.customerGroups`.`id` = ?) AND `moorl_magazine_article`.`invisible` = ?) AND `moorl_magazine_article`.`invisible` = ?) GROUP BY `moorl_magazine_article.tags`.`id`
Parameters: 
[
  "UTB M"
  "%UTB M%"
  "UTB M"
  "%UTB M%"
  "UTB M"
  "%UTB M%"
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  null
  "2026-10-01 21:44:10"
  null
  "2026-10-01 21:44:10"
  null
  b"\x01‘J13£x"‰m\fp²ý;g"
  null
  b"ϽP\x18ÓŽAØ­Ê\x10ÙOȽÖ"
  false
  false
  "UTB M"
  "%UTB M%"
  "UTB M"
  "%UTB M%"
  "UTB M"
  "%UTB M%"
  125.0
  true
  null
  "2026-10-01 21:44:10"
  null
  "2026-10-01 21:44:10"
  null
  b"\x01‘J13£x"‰m\fp²ý;g"
  null
  b"ϽP\x18ÓŽAØ­Ê\x10ÙOȽÖ"
  false
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
57.01 ms
(15.15%) 		1 
-- magazine-article-listing::search-ids
SELECT `moorl_magazine_article`.`id`, SUM(IF(COALESCE(`moorl_magazine_article.translation.name`) = ? , '500', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE ? , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = ? , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE ? , '125', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = ? , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE ? , '125', 0)) / COUNT(moorl_magazine_article.id) as _score FROM `moorl_magazine_article` LEFT JOIN `moorl_magazine_article_sales_channel` `moorl_magazine_article.salesChannels.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.salesChannels.mapping`.`article_id`  LEFT JOIN `moorl_magazine_article_customer_group` `moorl_magazine_article.customerGroups.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.customerGroups.mapping`.`article_id`  LEFT JOIN (SELECT `moorl_magazine_article.translation`.`moorl_magazine_article_id`, `moorl_magazine_article.translation`.`name` as `moorl_magazine_article.translation.name`, `moorl_magazine_article.translation`.`content` as `moorl_magazine_article.translation.content`, `moorl_magazine_article.translation`.`meta_description` as `moorl_magazine_article.translation.metaDescription` FROM `moorl_magazine_article_translation` `moorl_magazine_article.translation` WHERE `moorl_magazine_article.translation`.`language_id` = ?) `moorl_magazine_article.moorl_magazine_article_translation` ON `moorl_magazine_article.moorl_magazine_article_translation`.`moorl_magazine_article_id` = `moorl_magazine_article`.`id` LEFT JOIN `sales_channel` `moorl_magazine_article.salesChannels` ON `moorl_magazine_article.salesChannels.mapping`.`sales_channel_id` = `moorl_magazine_article.salesChannels`.`id`  LEFT JOIN `customer_group` `moorl_magazine_article.customerGroups` ON `moorl_magazine_article.customerGroups.mapping`.`customer_group_id` = `moorl_magazine_article.customerGroups`.`id`  WHERE (((`moorl_magazine_article`.`active` = ? AND ((`moorl_magazine_article`.`show_from` <=> ? OR (`moorl_magazine_article`.`show_from` <= ?)) AND (`moorl_magazine_article`.`show_until` <=> ? OR (`moorl_magazine_article`.`show_until` >= ?))) AND (`moorl_magazine_article.salesChannels`.`id` <=> ? OR `moorl_magazine_article.salesChannels`.`id` = ?) AND (`moorl_magazine_article.customerGroups`.`id` <=> ? OR `moorl_magazine_article.customerGroups`.`id` = ?) AND `moorl_magazine_article`.`invisible` = ?) AND `moorl_magazine_article`.`invisible` = ?)) AND (COALESCE(`moorl_magazine_article.translation.name`) = ? OR COALESCE(`moorl_magazine_article.translation.name`) LIKE ? OR COALESCE(`moorl_magazine_article.translation.content`) = ? OR COALESCE(`moorl_magazine_article.translation.content`) LIKE ? OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = ? OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE ?) GROUP BY `moorl_magazine_article`.`id` HAVING _score >= ? ORDER BY MAX(`moorl_magazine_article`.`date`) DESC, MIN(`moorl_magazine_article`.`id`) ASC, MIN(`moorl_magazine_article`.`id`) ASC, _score DESC LIMIT 12
Parameters: 
[
  "UTB M"
  "%UTB M%"
  "UTB M"
  "%UTB M%"
  "UTB M"
  "%UTB M%"
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  null
  "2026-10-01 21:44:10"
  null
  "2026-10-01 21:44:10"
  null
  b"\x01‘J13£x"‰m\fp²ý;g"
  null
  b"ϽP\x18ÓŽAØ­Ê\x10ÙOȽÖ"
  false
  false
  "UTB M"
  "%UTB M%"
  "UTB M"
  "%UTB M%"
  "UTB M"
  "%UTB M%"
  125.0
]
View formatted query    View runnable query    Explain query    View query backtrace
47.14 ms
(12.53%) 		1 
SELECT COUNT(*) FROM (-- magazine-article-listing::search-ids
SELECT `moorl_magazine_article`.`id`, SUM(IF(COALESCE(`moorl_magazine_article.translation.name`) = ? , '500', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE ? , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = ? , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE ? , '125', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = ? , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE ? , '125', 0)) / COUNT(moorl_magazine_article.id) as _score FROM `moorl_magazine_article` LEFT JOIN `moorl_magazine_article_sales_channel` `moorl_magazine_article.salesChannels.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.salesChannels.mapping`.`article_id`  LEFT JOIN `moorl_magazine_article_customer_group` `moorl_magazine_article.customerGroups.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.customerGroups.mapping`.`article_id`  LEFT JOIN (SELECT `moorl_magazine_article.translation`.`moorl_magazine_article_id`, `moorl_magazine_article.translation`.`name` as `moorl_magazine_article.translation.name`, `moorl_magazine_article.translation`.`content` as `moorl_magazine_article.translation.content`, `moorl_magazine_article.translation`.`meta_description` as `moorl_magazine_article.translation.metaDescription` FROM `moorl_magazine_article_translation` `moorl_magazine_article.translation` WHERE `moorl_magazine_article.translation`.`language_id` = ?) `moorl_magazine_article.moorl_magazine_article_translation` ON `moorl_magazine_article.moorl_magazine_article_translation`.`moorl_magazine_article_id` = `moorl_magazine_article`.`id` LEFT JOIN `sales_channel` `moorl_magazine_article.salesChannels` ON `moorl_magazine_article.salesChannels.mapping`.`sales_channel_id` = `moorl_magazine_article.salesChannels`.`id`  LEFT JOIN `customer_group` `moorl_magazine_article.customerGroups` ON `moorl_magazine_article.customerGroups.mapping`.`customer_group_id` = `moorl_magazine_article.customerGroups`.`id`  WHERE (((`moorl_magazine_article`.`active` = ? AND ((`moorl_magazine_article`.`show_from` <=> ? OR (`moorl_magazine_article`.`show_from` <= ?)) AND (`moorl_magazine_article`.`show_until` <=> ? OR (`moorl_magazine_article`.`show_until` >= ?))) AND (`moorl_magazine_article.salesChannels`.`id` <=> ? OR `moorl_magazine_article.salesChannels`.`id` = ?) AND (`moorl_magazine_article.customerGroups`.`id` <=> ? OR `moorl_magazine_article.customerGroups`.`id` = ?) AND `moorl_magazine_article`.`invisible` = ?) AND `moorl_magazine_article`.`invisible` = ?)) AND (COALESCE(`moorl_magazine_article.translation.name`) = ? OR COALESCE(`moorl_magazine_article.translation.name`) LIKE ? OR COALESCE(`moorl_magazine_article.translation.content`) = ? OR COALESCE(`moorl_magazine_article.translation.content`) LIKE ? OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = ? OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE ?) GROUP BY `moorl_magazine_article`.`id` HAVING _score >= ?) total
Parameters: 
[
  "UTB M"
  "%UTB M%"
  "UTB M"
  "%UTB M%"
  "UTB M"
  "%UTB M%"
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  null
  "2026-10-01 21:44:10"
  null
  "2026-10-01 21:44:10"
  null
  b"\x01‘J13£x"‰m\fp²ý;g"
  null
  b"ϽP\x18ÓŽAØ­Ê\x10ÙOȽÖ"
  false
  false
  "UTB M"
  "%UTB M%"
  "UTB M"
  "%UTB M%"
  "UTB M"
  "%UTB M%"
  125.0
]
View formatted query    View runnable query    Explain query    View query backtrace
20.46 ms
(5.44%) 		24 
SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.shortName`, `currency.translation.shortName` as `currency.shortName`, `currency.translation.name`, `currency.translation.name` as `currency.name`, `currency.translation.customFields`, `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation`.`currency_id`, `currency.translation`.`short_name` as `currency.translation.shortName`, `currency.translation`.`name` as `currency.translation.name`, `currency.translation`.`custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.`language_id` = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE (`currency`.`iso_code` IN (?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  "CHF"
  "EUR"
]
View formatted query    View runnable query    Explain query    View query backtrace
9.40 ms
(2.50%) 		4 
SELECT LOWER(HEX(seo_url.id)) as id, LOWER(HEX(seo_url.foreign_key)) foreignKey, LOWER(HEX(seo_url.sales_channel_id)) salesChannelId, seo_url.is_modified as isModified, seo_url.seo_path_info seoPathInfo FROM seo_url seo_url WHERE (seo_url.route_name = ?) AND (seo_url.language_id = ?) AND (seo_url.is_canonical = 1) AND (seo_url.foreign_key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters: 
[
  "frontend.detail.page"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ÅŽ\và–HVÙ\x18pˆýSSu•"
  b"(JËÕa³f}yëîq’·œ:"
  b"ð•OÇ®Î8§&©\vÑŽm_L"
  b"­Ùõéÿé\x1Fú\x18Úƒ\rcÅ\x13."
  b"I›\r1\x16\x07\x05´tî\x06‰SM¸4"
  b"’‹u¦\x1AÂ+qˆ˜',¼£T\x15"
  b"\t±ÿ‹C¡Æ„\x10Eî3ëxsÓ"
  b"\x02Æ\x7Fš&›± ÓT\x02‰Gu Õ"
  b"\x12œ\x03,\x02HlO\x1AØ4!ë-§"
  b"ÎóƬ\x1E9p—G\vT7!ø"
  b"³¾\x07Þ$A”ìK\tlQT!%K"
  b"\x034\x12Âåüxe?u\r\x1D\x05JKž"
  b"Ä€F×9Î=æ\x00Ñ°ÙĶí;"
  b"o$­F4`ìÀD\x07ÝdKÙö\f"
  b"Œµì]/\x17»ßxŸ„—\x07D\x1Eå"
  b"^¨õDú?’›ëË™Ì"eÁ\x02"
  b"gƒ¤¹ÿ\x14aæïRÄ`\x01iDÜ"
  b"WÇ\x15*Y¡û”iÃ'H(\x0EIm"
  b"Ÿ;½x\x0E+¯\x08{\x1EKˆ·¾W\x15"
  b"­\x0Fïj3¨i+”vö‰öÏðr"
  b"h&&bd\x05PHzË¿êì\x03F"
  b"ÈrMF£Á`+éEñ^w1¶Ò"
  b"""
    uŽ«¸l\n
    ÿ=\x16»ÌÏ<EW\v
    """
  b"""
    ۏ°Õ>WA¬ó¦—¬}Ý\n
    
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
7.25 ms
(1.93%) 		1 
SELECT `meta_catalog_id`.`id` FROM `meta_catalog_id` WHERE `meta_catalog_id`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"ÅŽ\và–HVÙ\x18pˆýSSu•"
  b"(JËÕa³f}yëîq’·œ:"
  b"ð•OÇ®Î8§&©\vÑŽm_L"
  b"­Ùõéÿé\x1Fú\x18Úƒ\rcÅ\x13."
  b"I›\r1\x16\x07\x05´tî\x06‰SM¸4"
  b"’‹u¦\x1AÂ+qˆ˜',¼£T\x15"
  b"\t±ÿ‹C¡Æ„\x10Eî3ëxsÓ"
  b"\x02Æ\x7Fš&›± ÓT\x02‰Gu Õ"
  b"\x12œ\x03,\x02HlO\x1AØ4!ë-§"
  b"ÎóƬ\x1E9p—G\vT7!ø"
  b"³¾\x07Þ$A”ìK\tlQT!%K"
  b"\x034\x12Âåüxe?u\r\x1D\x05JKž"
  b"Ä€F×9Î=æ\x00Ñ°ÙĶí;"
  b"o$­F4`ìÀD\x07ÝdKÙö\f"
  b"Œµì]/\x17»ßxŸ„—\x07D\x1Eå"
  b"^¨õDú?’›ëË™Ì"eÁ\x02"
  b"gƒ¤¹ÿ\x14aæïRÄ`\x01iDÜ"
  b"WÇ\x15*Y¡û”iÃ'H(\x0EIm"
  b"Ÿ;½x\x0E+¯\x08{\x1EKˆ·¾W\x15"
  b"­\x0Fïj3¨i+”vö‰öÏðr"
  b"h&&bd\x05PHzË¿êì\x03F"
  b"ÈrMF£Á`+éEñ^w1¶Ò"
  b"""
    uŽ«¸l\n
    ÿ=\x16»ÌÏ<EW\v
    """
  b"""
    ۏ°Õ>WA¬ó¦—¬}Ý\n
    
    """
  b"%6ÅðÃh*\x14”éÎûÌ72Ë"
  b";5{¹…w»\x05#zçè¦o5›"
  b""Ö¼DÞû¢Äpf°EÕg¯+"
  b"\x1F\tnû(•ñï"hœ\x08\x13U"
  b"d\x02Îõ„K’Èßàéö3"ok"
  b"ç\x17­\x1FÛ}€—Å›[`8Äl5"
  b"F(Ìë³\x04³›È&•‘ØÐcH"
  b"¾ÁnÈXfê©0\x7F/Þ©ÔÄ\x0F"
  b"X‡Ù\f†>˜\x0FÐú\x07|ÍŠ#"
  b"r‚oGcP6ª²Ñ ¡ñš\x01«"
  b"3á\x07W/dwZ\x13IšÃ%D7>"
  b"ª„ﱧ—Êf{g£ÁóU"
  b"YâKúJfvæB>„2€Üd¢"
  b"õÄ=·\x7F±PÔ¡§ð¬†×—§"
  b"y\\Õ7¡†îì'’â‹×s½"
  b"õ\x00fŽõ¬ó\x0E}¯ø\x14d\x11Z"
  b"æÁõÍN†ô.¢\x08ÐK"
  b"€ÄÑæÆCX“\vSÖ`‡áÉa"
  b"N%uÔ&?rÅ\v'~‘ftpª"
  b"A‰,h¥·oØ!pR,‡à‘"
  b"\x05;*\x13–(Êd”PdÍý³—z"
  b"•£ÅO—åq;\x11ue\x07ECz€"
  b"/«Ç\x028ò†_·;¦ÜÈFwí"
  b"¿%\x0E\x03ðÒ\x1Fø@Ú\x1ExIè7"
  b"""
    `á)L>Þ@Ó¿ÀË9·\n
    Oø
    """
  b"""
    #\n
    êR"\x7F\x1E\x1D\x04ôÀPÒOòí
    """
  b"©Ž5÷({²¿¾M\x19\x04…ŠKõ"
  b"]7\x04ðB´ýÿMoíj\x12àvÈ"
  b"¥~`\x7F¡+v„—\eë\x0Ežg߈"
  b"r±\x01ÄQµþ+¬ q%eê,®"
  b" L,fXÒq\f%NÕ\x15(˜0å"
  b"0\x18Ù„|§¾\x13^\x7F\x15rž\x0F“"
  b"³Ú#\x05ùzDlBÙ\x08«ÍžK"
  b"ò“ùÈ\x19¢.q\x16X{«¾¨\x1FŒ"
  b"HȲ¥´,:_¬ÌENŸÊþ"
  b"».¿À9xï ˜–~×GVN6"
  b"y—é|\x14e‡\x15à,ŒÛö€z:"
  b"""
    vÞ\n
    =Æý®#r½HcÕæŠ
    """
  b"U¬loMm“‹ãð&9\\x07F"
  b"ëד\x00\eY­<µÃNõ˪=è"
  b"\Ø‹´\f3Iä‚é*Þ\x01˜žÑ"
  b"¤;óÆ\x19ø\x11¿½Á5\x03«\x17¸."
  b"ø/û_\rÔRÇ¢ž\x0EIU!+."
  b"""
    \x1Fõ9Ï]àò:\n
    A.̾šhÃ
    """
  b"ñßIt·Ø—F\x16UWM<ƒFo"
  b"IDþ}?HÊ\&ÑØDpùÛ"
  b"zÂt­„o#Wh7(Te$š."
  b"oË/Ì6[\x1Eû¹ªÛKþÑ3ï"
  b"$/üf}ÉDÅ%ÿ‘‰¼ÕFˆ"
  b"CªcM\x06N*ŒÄ¦\x1Eó—™(\r"
  b"JSÎÓµ’\x1D Ú}+üúfYú"
  b"zq\x03ºEø»³jöw\x11m TÍ"
  b"Ø&º` ¯ï‡§÷.Šœ½¢-"
  b"±Ñõ´Jx˜"Ó€c‡ôœmõ"
  b"o$A*û³h¬–7à|- Uó"
  b"—=ª’VzÒü\x05ʤ9\x12\x15 \x19"
  b"pÿ\x03¿\e~ãÌ+§½ã¾U]\x07"
  b"ý\x1A\x03‰£åÞìÍj\x7F¸\x16>6¿"
  b"¿+‘5&wþ&êŠ'mña\x1DÙ"
  b"y.Ý¿ûŽ¨…;!°xH;‹"
  b"/ð0\x07/ân¼÷\x13rlØâê"
  b"6ÂåØÆ\x0FåK>¯¯ÐL\x0F£ß"
  b".wP@nn¶YÐ_ðHõ—j_"
  b"\tŽ\x17#r°\x04\x14Ð'¬âFrq"
  b"&ÄÆÉko\x1DŒþ“Å°M`>Õ"
  b"¸û\x1F\%&9n4Þ\x18žrB<`"
  b"yU¨+˲a?ŽB(˼­ä-"
  b"{+ªsÿ<|I=ô\x1Cµ\es/"
  b"\x14Ÿÿ“˜GWà–’–p\q`k"
  b"""
    %7¥©mþ¯\n
    b\x14çâJ÷
    """
  b"‰³|ô\x13JMWÄÒqX0É\x15ë"
  b"\e7y£S¯ƒ|²s:\x11\x7FdîÃ"
  b"\x00Z¶ïÓW¸ŸnjAj=—>)"
  b"{š¸¸\tû¢ZJ1²\x02ùUüª"
  b"ümp¡\x0F/D§ª¬yÔߝÚ"
  b"\eh°_Pèb<îO%\t×r\x1AÉ"
  b";\x1Fîñ\x00%ÊÆ6\n\x01=mÝ\n"
  b"‚×UæÍ4Ý\v\x15!à\x05ÄÑ}="
  b"g•ñªa\x13(à3º”څײ\x0E"
  b"ÛaŒBЖbó9ª¢`\x0Fø9~"
  b"\x02¿nÞ\x19ƒw†ÛãuŒöCgV"
  b"‡ïž´Ú\f°\x10ºÙ\væÜ1iÏ"
  b"$’î\x1FtŶñ;V³»iJ\v"
  b"Fx \§0Gß5Ëjwˆ\x17BŒ"
  b"°‘\x1D˜¹žd¡ô™\x01S%ƒdõ"
  b"‡IúTØÚ3ü\e\x06Iÿw#lë"
  b"Ô\x15”¬Û·²\x1Fó\x0EÄ‘õ¤ä?"
  b"D½\x07çßœ?÷Þ\x05 G\x16NÛ‘"
  b"\tgt\vbÓô‚\vÚA¾=¯È·"
  b"$\x046c$ðœ~š×é‚ÓYZ\x16"
  b"¬¤‹fK›†#„xÒe\x10‰Ò,"
  b"â}\x1FU3Âl€´[–\x04©”âö"
  b"þŽ­#c¾LJ¸;8\x13E"
  b"uŸ\eׄOŸ\x18\x1FÜùzê\x16\x1E8"
  b"\fÌ!°ÏŸ}\x019Þ>bK"
  b"öÁÅ_lδÜÔÀ\x12!\x1Eð ²"
  b"0CA$U÷:.²6‚Úò\x00CN"
  b"1£ÇÿÉC\x01’¢\x00/²\x18†a{"
  b"\x16Ù¾\x17S³I(S:·þm#\x18"
  b"ôÎz3b>ô\x15ð‡ØÖxÐ"
  b"\vŽn \x19Ò\x1D}ŸÞ±¥ÅÉ\x16Ë"
  b"‡$®…ÚÇvå‡ýE5P\x05q"
  b"«“¸Z¨\x16\x18–¦€Ÿœò\x01äÿ"
  b"¿UggípÇ6ì‚ŒÛæ”@™"
  b"OÜcóÀ\x1C?Dõ,C5¬ìU"
  b"Êûö”bK€rŽ~Ä…á¡ŸB"
  b"'\x17\x07cWô¢äX’iŽ0„€m"
  b"¡×—¸=ÝÓC“?Cœ\v\x18±Y"
  b"W·®þ¶‰’ù“1df„\vG"
  b"ã¤ò÷Åì‚^dMÐm„GF"
  b"\x07müuD‰ˆ\x05Ü´fÆÏ@V\x08"
  b"ŽÏ¹\x1CCD[œú¹ÈþÑô„"
  b"¸-(S\—tãˆãm®„FÈJ"
  b"U.ý\x07›èïš«¯ïqî9\x04£"
  b"ê\x19{wë\x01ïnÛþ \x1C6ä]"
  b"\x10!Qÿü‡é3ì_ Ž\x05]+x"
  b"%Y-W©… ”®Ÿ&’p˜\x15"
  b"»–M†`\x1E\x13Þ¸íX`ÛCWB"
  b"—2ào\x17Øm\x04äÊé?x\x1CV¹"
  b"É/0\r:÷æKú\x0Fµ]hûÀÚ"
  b"Q Gƒ\vðWwèÅ-B\x10lЮ"
  b"\x7F6›šÄh\x19½à÷„ôî\x04YÌ"
  b"´\x17¡U’_U\e2ÞèWìÿè#"
  b"þ;\x08û&\x16ƒŸ\x08¡HíYç¬"
  b"¤©}-[–\x02áÛ\x04ñ5Bߺ‚"
  b"3¦á±¢z\x12&Ö\x1D¢7×\x13Ÿ"
  b"\x00a(Û±1fzJ\x1AV\rðv÷‡"
  b"Sä@¯Dl\x1FgvX…晈á¾"
  b"ÌÏÓ°\x1D$\x10ß®ºpÑF»þG"
  b"R¸H\x1E(æSI(¬˜Èf\x1FÚX"
  b"зє2ó¬\x7F¹ŒM\x0Fcfrú"
  b" ÿ("#kcµ&WwuèlÆ…"
  b"{—O#EãÁÇã+Ó%Àr˜*"
  b"‚WZ³˜íéX3;E\x0E¹þë·"
  b"""
    UußD_fû, \n
    AÁ( òO
    """
  b"ßÕ•\x12·Æ·\x1E-pÏ\x08\x16‰ãŒ"
  b"""
    \x12¾®Àùº3\x18¤e#Ä7\n
    -ÿ
    """
  b"ãû\x10=ßßÏ^åÕ×ÝUhh_"
  b"ý¸õqWj\x07 ´Œ—³‚£!"
  b"¬\x189Å¡Êo\x07·õhJ\x15\x14á%"
  b"¥è…ÇÇC¯þÿÕ(\x08W”\x01•"
  b"\x13ZÓsÃàÀ\x0Eð( Ì—ßX»"
  b"\x1E\ej÷;ÿõö¬íîØVç°¸"
  b"DjEòñ^\tBMÎ^ÙÕ'/h"
  b"#ÁBõñÔ\x7Far\x08U£‡`‡("
  b"[@ v@Ÿ‚Ä69\x18¢Q¨\x7F\x1E"
  b"ÿpûÖ\x13’™Ç\x1DlŠ”PY="
  b"Lô†¡ÿKº>£é\x0Fž…\x7F\x1D"
  b"Y²Á«>\x17ÍcЊ\t¼\v*\x1FŽ"
  b"…pL\x15“éc\x19늡söÐGT"
  b"vI\r¿0úí\eYG0FÝѱÀ"
  b"˜\x7F³ð©nI`´IÚ’²‡jÄ"
  b"Ó,Ų́öÐ\x1AãÎ\x19ñ¡ÂÍä"
  b"·Ž¿dÖ GBŽFaãk\x1El¢"
  b"7%\x13ˆ\x06{WÒ\x00D5°J¡M~"
  b"\x17\¨n\x10\x1C!\x1C"\x01Ž\x01D„—\v"
  b"\vñMf\e…Ë3$¸u)yÒMe"
  b"ªÍ)–&žÈӝ‰){çOÅ"
  b"S"‘¹Ü\x16)QhAâªiW&\x08"
  b"¹]¡õ?´\x0EXL\rÓ\x15\vÍæ—"
  b"\x07Ä¿\x14±‰À\x18›\v\v\x06ÞÌ…ª"
  b"L\x04µ|ì¹ü\‹\x1F+©œ‘­£"
  b"ã™BÊ÷¨}è3Éç\rÝ>­¥"
  b"‘z|¯øcÔäiñÃ\x03ÅlÁÃ"
  b"¤\x1E³\x17“‘-iþбµŠÍÇG"
  b"•&ô€Oªªøèíò±Ç[ÚB"
  b"Zm~Â\bËa¯¢\x01nžx\x11"
  b"Ʋ:…»z¦½e£pCû\x19`"
  b"‹Óð¬Ç×Þ¹¬Þk£‚Äc\x18"
  b"‰Æ‹€­d!Íù²iÐ?¬OÝ"
  b"ë²wÀ›ÓîJ\t\x1Dõ㣋-á"
  b"Í¡ƒ!Ð~BzÆò¶©×Qwƒ"
  b"V\x05J¦\x13ÊŠ\x01t¼†NËé;Ã"
  b"eŒÈzµ€Àoi\x021œë-%Ì"
  b"¿œ¥\x02Q\x16¶±¸³\x1A/+©Ùv"
  b"=µL,g\x01]-«KÈîR\x1D®û"
  b"ýxÍN⎜H?v¨¸Wf¼"
  b"P]ÿì\e\x1A\x14é\x0Fßá+«\x03(\x16"
  b"y#o¶šÈ±\x1FÑj‹4+}¤3"
  b"~\x1DZ"1œ\x02Z-X\x00²×jw"
  b"\ý°‘<?1+‡\x16U6ÿ† F"
  b"ñ\x0FMñm%£0Cö9õ381"
  b"TŒ£Û¤ŸóÍ^\vû¨»Òÿë"
  b" Æ\x04¥TžÙÀÝ݉àx ÌŽ"
  b"ãt3Fdptþå@8êòˆ4("
  b"""
    \ÈÈP—®ä\x02\n
    \{T\x0FnÊR
    """
  b"cò5š\x1Cˆ÷Qꪊ\x08¶„\x03‰"
  b"˜-Á\x01øŠ\x04¡aü\x04Âj¹ež"
  b"éÑ;þø\x16\x1F¹ïá²ÛGm{R"
]
View formatted query    View runnable query    Explain query    View query backtrace
6.09 ms
(1.62%) 		4 
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (sales_channel_id = ?)
Parameters: 
[
  b"ÅŽ\và–HVÙ\x18pˆýSSu•"
  b"(JËÕa³f}yëîq’·œ:"
  b"ð•OÇ®Î8§&©\vÑŽm_L"
  b"­Ùõéÿé\x1Fú\x18Úƒ\rcÅ\x13."
  b"I›\r1\x16\x07\x05´tî\x06‰SM¸4"
  b"’‹u¦\x1AÂ+qˆ˜',¼£T\x15"
  b"\t±ÿ‹C¡Æ„\x10Eî3ëxsÓ"
  b"\x02Æ\x7Fš&›± ÓT\x02‰Gu Õ"
  b"\x12œ\x03,\x02HlO\x1AØ4!ë-§"
  b"ÎóƬ\x1E9p—G\vT7!ø"
  b"³¾\x07Þ$A”ìK\tlQT!%K"
  b"\x034\x12Âåüxe?u\r\x1D\x05JKž"
  b"Ä€F×9Î=æ\x00Ñ°ÙĶí;"
  b"o$­F4`ìÀD\x07ÝdKÙö\f"
  b"Œµì]/\x17»ßxŸ„—\x07D\x1Eå"
  b"^¨õDú?’›ëË™Ì"eÁ\x02"
  b"gƒ¤¹ÿ\x14aæïRÄ`\x01iDÜ"
  b"WÇ\x15*Y¡û”iÃ'H(\x0EIm"
  b"Ÿ;½x\x0E+¯\x08{\x1EKˆ·¾W\x15"
  b"­\x0Fïj3¨i+”vö‰öÏðr"
  b"h&&bd\x05PHzË¿êì\x03F"
  b"ÈrMF£Á`+éEñ^w1¶Ò"
  b"""
    uŽ«¸l\n
    ÿ=\x16»ÌÏ<EW\v
    """
  b"""
    ۏ°Õ>WA¬ó¦—¬}Ý\n
    
    """
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.77 ms
(1.27%) 		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/01918e44035c7dc4a99bc47f495a0711"
  "/navigation/01918e441648700e84ab007847d14512"
  "/navigation/0197b0e006967583a7245f4339110739"
  "/navigation/01918e4433887438a3185dfc267b9174"
  "/navigation/01918e4448a17cb7a6646183e26966fd"
  "/navigation/01918e4464247aa5bb2372768ea01664"
  "/navigation/01918e4473d2731eade248d232e85ad9"
  "/navigation/019f84f4a39c7411a2f53617980b1037"
  "/navigation/01918e46601f7eab9c3a08cb62266585"
  "/navigation/01918e46f43b76e490998278ab83a15e"
  "/navigation/01918e4733ab7ce4a04db008d6a0571e"
  "/navigation/01918e473c867224a4cd794a3490c061"
  "/navigation/01918e4757337158a5d95ed3b53a109d"
  "/navigation/01918e477ca57fc0a0939f9d671ba749"
  "/navigation/01918e47a64570b59e89994cd433f4d1"
  "/navigation/01918e47bf7374f7b87f760ad53a6f9f"
  "/navigation/01918e47d74f74c2aedd9ad470bb4737"
  "/navigation/019e017df9a276a4af12f2db0c080aff"
  "/navigation/0191ee9a80f5792aa4470bc1bb7ddabd"
  "/navigation/01936d7a6944779cb990d593d7d9b140"
  "/navigation/01936d7b874370fa909a2becef1ac7f3"
  "/navigation/01936d7badff7c64aece3984ce06f2c7"
  "/navigation/01936d7bdb987601b94de98ae7052632"
  "/navigation/01936d7c04c47d08af4b053e0605b585"
  "/navigation/0197b1c1191b74fb913d877e813e9a33"
  "/navigation/0197b1d5eefe74abbe9ec5ee2606a746"
  "/navigation/0197b1d662ba7f6eab0d5b1e1cd0e781"
  "/navigation/0197b1d741c77750808bb080c573fb3e"
  "/navigation/0197b1c1616279c9a4d8e781cbf173cf"
  "/navigation/0197b1defcd8701ebb59303fe3ee4e79"
  "/navigation/0197b1e740ce74b3b95fa94eb90d6482"
  "/navigation/0197b212ee197f59aba350173d0f3870"
  "/navigation/0197b213d68170518b54ec3e38fa07c7"
  "/navigation/0197b213f7187e429075394413321bad"
  "/navigation/0197b1e7605170709081ec0aeb90cca7"
  "/navigation/0197b228d5577f7196f05c286b6607de"
  "/navigation/0197b22a1f0c7d9a97bc1e3859bb6740"
  "/navigation/0197b22a2dad7566a2eda9c10bc43d14"
  "/navigation/0197b22a3664705db9413337a7a2dd63"
  "/navigation/0197b22a3a3f7957be91e796f89378b9"
  "/navigation/0197b22a45e6768d82b1b08c10a3a7fe"
  "/navigation/0197b22a4c8f7054bfddd2570ea510eb"
  "/navigation/0197b22a3e767cb1a01f7ee9c5ec7457"
  "/navigation/0197b22a426d7966ba8e1f01a46eefbf"
  "/navigation/0197b22967937c8387711229c2ba42f6"
  "/navigation/0197b22d432c7aa18713d9633996a846"
  "/navigation/0197b22d5c18798ca5d6235a91ae9faa"
  "/navigation/0197b22d617977b1b4bcd1907752f260"
  "/navigation/0197b22d670b79859e22dafbc6a8361e"
  "/navigation/0197b22d6a9e7827acd9a4db7458b21a"
  "/navigation/0197b22d6d5f7c899774d5c5a00c4431"
  "/navigation/0197b22d72767ff4adffaa731821c543"
  "/navigation/0197b22d756c71bca58843309235dcb3"
  "/navigation/0197b22d784d716684949235c56d44d1"
  "/navigation/0191ee9ae9317bd79b501cffd3fb613e"
  "/navigation/0197d0fd7b077c55b800312ed2c2cf29"
  "/navigation/0191ee9b16a97cc9a147cd4449f46348"
  "/navigation/0191ee9b239e7c9181e6964082608c6b"
  "/navigation/0191ee9b38a0746aa93998ef15d3fe6c"
  "/navigation/0191ee9b475670c983a8fc836aa5cc22"
  "/navigation/0191ee9b55af7827a4968f0e9846b94d"
  "/navigation/0191ee9d0a8e741d8bd582aac09faa8f"
  "/navigation/0191ee9ce967784a97d4bbe54c5ea62f"
  "/navigation/019909cb27c97a0ead2c5b9206adefb4"
  "/navigation/0191ee9d1b347e3481f4071ff5017ee8"
  "/navigation/0191ee9e54a076ddaa4463979f50a4a7"
  "/navigation/0191ee9e6a3b7f28b0b45df9da9cc4c0"
  "/navigation/0191ee9e7b6d7435858c66f429866305"
  "/navigation/0191ee9eaa9c75ba8a3843b3ce4fa334"
  "/navigation/0191ee9ecac979659c233713313910fb"
  "/navigation/0191ee9fac45736e8d462a8a87cc0a31"
  "/navigation/0191ee9fc09d7248bdf68188b88be38a"
  "/navigation/0191ee9fc9117f43a3303ae736f72e6c"
  "/detail/c58d0be0964856d9187088fd53537595"
  "/detail/284acbd561b3667d79ebee7192b79c3a"
  "/detail/f0954fc7aece38a726a90bd18d6d5f4c"
  "/detail/add9f5e9ffe91ffa18da830d63c5132e"
  "/detail/499b0d31160705b474ee0689534db834"
  "/detail/928b75a61ac22b718898272cbca35415"
  "/detail/09b1ff8b43a1c6841045ee33eb7873d3"
  "/detail/02c67f9a269bb120d3540289477520d5"
  "/detail/129c032c02486c4f1ad8348f21eb2da7"
  "/detail/8fcef3c6ac1e397097470b54378f21f8"
  "/detail/b3be07de244194ec4b096c515421254b"
  "/detail/033412c2e5fc78653f750d1d054a4b9e"
  "/detail/c48046d739ce3de600d1b0d9c4b6ed3b"
  "/detail/6f24ad463460ecc04407dd644bd9f60c"
  "/detail/8cb5ec5d2f17bbdf789f849707441ee5"
  "/detail/5ea8f544fa3f929bebcb99cc2265c102"
  "/detail/6783a4b9ff1461e6ef52c460016944dc"
  "/detail/57c7152a59a1fb9469c32748280e496d"
  "/detail/9f3bbd780e2baf087b1e4b88b7be5715"
  "/detail/ad0fef6a33a8692b9476f689f6cff072"
  "/detail/68262662640550487acbbf9deaec0346"
  "/detail/c8724d46a3c1602be945f15e7731b6d2"
  "/detail/758eabb86c0aff3d16bbcccf3c45570b"
  "/detail/db8fb0d53e5741acf3a697ac7ddd0a90"
  "/navigation/01968c8c36bf7d64a6458dea553bd083"
  "/navigation/01968c8c66857cbdaa3fe53f64460992"
  "/navigation/01968c8c819b7a3f80b7123704ac53e6"
  "/navigation/01968c8ca8b57752817b01710b71694a"
  "/navigation/01968c8e2d3a74a38a6c10f9f8460cea"
  "/navigation/01968c8e463172098d9fdfbd02e7079a"
  "/navigation/01968c8e5ce473fd981f91192b9ea060"
  "/navigation/01968c8e70bd7f69b2d493c206e115cb"
  "/navigation/01968c8eb0427cb382bf2677391a27af"
  "/navigation/01968c8f733271dda4a6b5b5769d6a3d"
  "/navigation/01968c8fcbcb7e17b2c838cd17eec670"
  "/navigation/01968c904e6a7dc795fb655c6bba1a6c"
  "/navigation/01968c910b567b13bd06bf0bb60f3a0d"
  "/navigation/01968c91ed89784c83a9842c8cea2016"
  "/navigation/01968c9316807749a8a0e77442aec819"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01‘J13£x"‰m\fp²ý;g"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.52 ms
(0.67%) 		4 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.54 ms
(0.41%) 		4 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.27 ms
(0.34%) 		1 
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 (?, ?) AND (`scop_platform_redirecter_redirect`.`salesChannelId` = ? OR `scop_platform_redirecter_redirect`.`salesChannelId` <=> ?)) LIMIT 1
Parameters: 
[
  "//search"
  "/search"
  "https://hauptbuchhandlung.staging.eurosoft.network/search"
  "https://hauptbuchhandlung.staging.eurosoft.network//search"
  "/search"
  "//search"
  "search"
  true
  1
  2
  b"\x01‘J13£x"‰m\fp²ý;g"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
1.15 ms
(0.31%) 		1 
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: 
[
  "//search?search=UTB+M"
  "/search?search=UTB+M"
  "https://hauptbuchhandlung.staging.eurosoft.network/search?search=UTB+M"
  "https://hauptbuchhandlung.staging.eurosoft.network//search?search=UTB+M"
  "/search?search=UTB+M"
  "//search?search=UTB+M"
  "search?search=UTB+M"
  true
  b"\x01‘J13£x"‰m\fp²ý;g"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
1.02 ms
(0.27%) 		1 
# product-listing-loader::resolve-previews
            SELECT
                parent.variant_listing_config as variantListingConfig,
                LOWER(HEX(child.id)) as id,
                LOWER(HEX(parent.id)) as parentId
             FROM product as child
                INNER JOIN product as parent
                    ON parent.id = child.parent_id
                    AND parent.version_id = child.version_id
             WHERE child.version_id = ?
             AND child.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"ÅŽ\và–HVÙ\x18pˆýSSu•"
  b"(JËÕa³f}yëîq’·œ:"
  b"ð•OÇ®Î8§&©\vÑŽm_L"
  b"­Ùõéÿé\x1Fú\x18Úƒ\rcÅ\x13."
  b"I›\r1\x16\x07\x05´tî\x06‰SM¸4"
  b"’‹u¦\x1AÂ+qˆ˜',¼£T\x15"
  b"\t±ÿ‹C¡Æ„\x10Eî3ëxsÓ"
  b"\x02Æ\x7Fš&›± ÓT\x02‰Gu Õ"
  b"\x12œ\x03,\x02HlO\x1AØ4!ë-§"
  b"ÎóƬ\x1E9p—G\vT7!ø"
  b"³¾\x07Þ$A”ìK\tlQT!%K"
  b"\x034\x12Âåüxe?u\r\x1D\x05JKž"
  b"Ä€F×9Î=æ\x00Ñ°ÙĶí;"
  b"o$­F4`ìÀD\x07ÝdKÙö\f"
  b"Œµì]/\x17»ßxŸ„—\x07D\x1Eå"
  b"^¨õDú?’›ëË™Ì"eÁ\x02"
  b"gƒ¤¹ÿ\x14aæïRÄ`\x01iDÜ"
  b"WÇ\x15*Y¡û”iÃ'H(\x0EIm"
  b"Ÿ;½x\x0E+¯\x08{\x1EKˆ·¾W\x15"
  b"­\x0Fïj3¨i+”vö‰öÏðr"
  b"h&&bd\x05PHzË¿êì\x03F"
  b"ÈrMF£Á`+éEñ^w1¶Ò"
  b"""
    uŽ«¸l\n
    ÿ=\x16»ÌÏ<EW\v
    """
  b"""
    ۏ°Õ>WA¬ó¦—¬}Ý\n
    
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
1.02 ms
(0.27%) 		1 
SELECT `plugin`.`id` as `plugin.id`, `plugin`.`base_class` as `plugin.baseClass`, `plugin`.`name` as `plugin.name`, `plugin`.`composer_name` as `plugin.composerName`, `plugin`.`autoload` as `plugin.autoload`, `plugin`.`active` as `plugin.active`, `plugin`.`managed_by_composer` as `plugin.managedByComposer`, `plugin`.`path` as `plugin.path`, `plugin`.`author` as `plugin.author`, `plugin`.`copyright` as `plugin.copyright`, `plugin`.`license` as `plugin.license`, `plugin`.`version` as `plugin.version`, `plugin`.`upgrade_version` as `plugin.upgradeVersion`, `plugin`.`installed_at` as `plugin.installedAt`, `plugin`.`upgraded_at` as `plugin.upgradedAt`, `plugin`.`icon` as `plugin.iconRaw`, `plugin`.`created_at` as `plugin.createdAt`, `plugin`.`updated_at` as `plugin.updatedAt`, `plugin.translation.label`, `plugin.translation.label` as `plugin.label`, `plugin.translation.description`, `plugin.translation.description` as `plugin.description`, `plugin.translation.manufacturerLink`, `plugin.translation.manufacturerLink` as `plugin.manufacturerLink`, `plugin.translation.supportLink`, `plugin.translation.supportLink` as `plugin.supportLink`, `plugin.translation.customFields`, `plugin.translation.customFields` as `plugin.customFields` FROM `plugin` LEFT JOIN (SELECT `plugin.translation`.`plugin_id`, `plugin.translation`.`label` as `plugin.translation.label`, `plugin.translation`.`description` as `plugin.translation.description`, `plugin.translation`.`manufacturer_link` as `plugin.translation.manufacturerLink`, `plugin.translation`.`support_link` as `plugin.translation.supportLink`, `plugin.translation`.`custom_fields` as `plugin.translation.customFields` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation`.`language_id` = ?) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` WHERE (`plugin`.`name` = ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  "esMetaCatalog6"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.95 ms
(0.25%) 		2 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.94 ms
(0.25%) 		1 
-- product-price-calculator::units::read
SELECT `unit`.`id` as `unit.id`, `unit`.`created_at` as `unit.createdAt`, `unit`.`updated_at` as `unit.updatedAt`, `unit.translation.shortCode`, `unit.translation.shortCode` as `unit.shortCode`, `unit.translation.name`, `unit.translation.name` as `unit.name`, `unit.translation.customFields`, `unit.translation.customFields` as `unit.customFields` FROM `unit` LEFT JOIN (SELECT `unit.translation`.`unit_id`, `unit.translation`.`short_code` as `unit.translation.shortCode`, `unit.translation`.`name` as `unit.translation.name`, `unit.translation`.`custom_fields` as `unit.translation.customFields` FROM `unit_translation` `unit.translation` WHERE `unit.translation`.`language_id` = ?) `unit.unit_translation` ON `unit.unit_translation`.`unit_id` = `unit`.`id`
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.93 ms
(0.25%) 		1 
SELECT LOWER(HEX(`id`)) AS `id` FROM `moorl_magazine_article` WHERE (`updated_at` IS NULL OR (`show_from` > `updated_at` AND `show_from` < '2026-10-01T21:43:59+00:00') OR (`show_until` > `updated_at` AND `show_until` < '2026-10-01T21:43:59+00:00')) AND `active` = '1';
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.91 ms
(0.24%) 		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"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01‘J13£x"‰m\fp²ý;g"
  "search"
  "search/"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.88 ms
(0.23%) 		1 
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.translation.name`, `sales_channel.translation.name` as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, `sales_channel.translation.homeName` as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, `sales_channel.translation.customFields` as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.`sales_channel_id`, `sales_channel.translation`.`name` as `sales_channel.translation.name`, `sales_channel.translation`.`custom_fields` as `sales_channel.translation.customFields`, `sales_channel.translation`.`home_slot_config` as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.`home_enabled` as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.`home_name` as `sales_channel.translation.homeName`, `sales_channel.translation`.`home_meta_title` as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.`home_meta_description` as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.`home_keywords` as `sales_channel.translation.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.`language_id` = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id`
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.88 ms
(0.23%) 		1 
SELECT `property_group`.`id` as `property_group.id`, `property_group`.`display_type` as `property_group.displayType`, `property_group`.`sorting_type` as `property_group.sortingType`, `property_group`.`filterable` as `property_group.filterable`, `property_group`.`visible_on_product_detail_page` as `property_group.visibleOnProductDetailPage`, `property_group`.`created_at` as `property_group.createdAt`, `property_group`.`updated_at` as `property_group.updatedAt`, `property_group.translation.name`, `property_group.translation.name` as `property_group.name`, `property_group.translation.description`, `property_group.translation.description` as `property_group.description`, `property_group.translation.position`, `property_group.translation.position` as `property_group.position`, `property_group.translation.customFields`, `property_group.translation.customFields` as `property_group.customFields` FROM `property_group` LEFT JOIN (SELECT `property_group.translation`.`property_group_id`, `property_group.translation`.`name` as `property_group.translation.name`, `property_group.translation`.`description` as `property_group.translation.description`, `property_group.translation`.`position` as `property_group.translation.position`, `property_group.translation`.`custom_fields` as `property_group.translation.customFields` FROM `property_group_translation` `property_group.translation` WHERE `property_group.translation`.`language_id` = ?) `property_group.property_group_translation` ON `property_group.property_group_translation`.`property_group_id` = `property_group`.`id`
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.84 ms
(0.22%) 		1 
SELECT `moorl_sorting`.`id` FROM `moorl_sorting` WHERE (`moorl_sorting`.`active` = ? AND `moorl_sorting`.`entity` = ?) ORDER BY `moorl_sorting`.`priority` DESC
Parameters: 
[
  true
  "moorl_magazine_article"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.82 ms
(0.22%) 		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‘ŽC\¬t®Ö_œêdÎy"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.73 ms
(0.19%) 		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˜3\x1Aì†sÞºð\x19KHB\x00Ï"
  b"\x01˜8\x07³.su·M\x1Fàë\x042‰"
  b"\x01˜8\x1DJ$y\x04‰²±!øË\t5"
  b"\x01‘jÿ\x7FíqÔŽ\x11\x1DñMˆwÃ"
  b"\x01‘k\x06àŽr\x16‡BÁ¶ûƒ9i"
  b"\x01‘k\x07õ>xý©g\x0Fó~\eÿ«"
  b"\x01–g^Ü\x1Ar1™ŽnÉf™’²"
  b"""
    \x01—Àï¿ýp\x0E´ë%¬óf\n
    õ
    """
  b"\x01˜,\x033Õr©€AÃ\x1Aݯßï"
  b"\x01˜6Sà\x01}þ‹|&Y¹Íå¥"
  b"\x01˜7ú\x1Ccr²¦¸foB$\x16é"
  b"\x01˜­\x04y/y\x0F¤úé4Z˜\x11Ô"
  b"\x01ŸF\x7F#ˆpá͟@\fš1§"
  b"\x01¥Ðºzs:‹Uo¨üG"
  b"\x01¥ÐºÇsl´Çäæ:\x7Fj7"
  b"\x01¥ÐøápQ…·ÄÏCª\x1E\t"
  b"\x01‘™IY\x7F|ù•/ˆÓÉ’!‚"
  b"\x01¥Ð»ds”†6…LhKŸÙ"
  b"\x01—ù%gŽr\x08®xàxv9RÎ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.72 ms
(0.19%) 		1 
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`, (SELECT GROUP_CONCAT(HEX(`country.salesChannels.mapping`.`sales_channel_id`) SEPARATOR '||')
                  FROM `sales_channel_country` `country.salesChannels.mapping`
                  WHERE `country.salesChannels.mapping`.`country_id` = `country`.`id` ) as `country.salesChannels.id_mapping`, `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¥Ð¹ms\x03¿5=Ó\x03å¹'"
  b"\x01¥Ðº\x1Cqò­b\x1C,h—{"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.69 ms
(0.18%) 		1 
-- product-listing::load-sortings::read
SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.translation.label`, `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.`product_sorting_id`, `product_sorting.translation`.`label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.`language_id` = ?) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01¦\üqs™Ì[Îj¥dj"
  b"\x01¥Ñ*ÿsç˜Ã-Œ²5w\n"
  b"\x01¥Ñ*ÿsç˜Ã-Œ² é\x10"
  b"\x01¥Ñ*ÿsç˜Ã-Œ³vœ\x07"
  b"\x01¥Ñ*ÿsç˜Ã-Œ´W\x10ý"
  b"\x01¥Ñ*ÿsç˜Ã-Œµ\x1Dìy"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.69 ms
(0.18%) 		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.68 ms
(0.18%) 		1 
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.translation.name`, `sales_channel.translation.name` as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, `sales_channel.translation.homeName` as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, `sales_channel.translation.customFields` as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.`sales_channel_id`, `sales_channel.translation`.`name` as `sales_channel.translation.name`, `sales_channel.translation`.`custom_fields` as `sales_channel.translation.customFields`, `sales_channel.translation`.`home_slot_config` as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.`home_enabled` as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.`home_name` as `sales_channel.translation.homeName`, `sales_channel.translation`.`home_meta_title` as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.`home_meta_description` as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.`home_keywords` as `sales_channel.translation.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.`language_id` = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` WHERE `sales_channel`.`id` IN (?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01‘J13£x"‰m\fp²ý;g"
  b"˜C-ï9üF$³2\x13¥kŒ”M"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01‘J13£x"‰m\fp²ý;g"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.68 ms
(0.18%) 		1 
-- product-listing::load-sortings::search-ids
SELECT `product_sorting`.`id` FROM `product_sorting` WHERE (`product_sorting`.`active` = ?) ORDER BY `product_sorting`.`priority` DESC
Parameters: 
[
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.62 ms
(0.17%) 		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.62 ms
(0.16%) 		1 
SELECT DISTINCT
               LOWER(HEX(sales_channel.id)) AS salesChannelId,
               LOWER(HEX(domains.language_id)) AS languageId
             FROM sales_channel_domain AS domains
             INNER JOIN sales_channel
               ON domains.sales_channel_id = sales_channel.id
               AND sales_channel.active = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.60 ms
(0.16%) 		1 
SELECT `moorl_sorting`.`id` as `moorl_sorting.id`, `moorl_sorting`.`locked` as `moorl_sorting.locked`, `moorl_sorting`.`url_key` as `moorl_sorting.key`, `moorl_sorting`.`entity` as `moorl_sorting.entity`, `moorl_sorting`.`priority` as `moorl_sorting.priority`, `moorl_sorting`.`active` as `moorl_sorting.active`, `moorl_sorting`.`fields` as `moorl_sorting.fields`, `moorl_sorting`.`created_at` as `moorl_sorting.createdAt`, `moorl_sorting`.`updated_at` as `moorl_sorting.updatedAt`, `moorl_sorting.translation.label`, `moorl_sorting.translation.label` as `moorl_sorting.label` FROM `moorl_sorting` LEFT JOIN (SELECT `moorl_sorting.translation`.`moorl_sorting_id`, `moorl_sorting.translation`.`label` as `moorl_sorting.translation.label` FROM `moorl_sorting_translation` `moorl_sorting.translation` WHERE `moorl_sorting.translation`.`language_id` = ?) `moorl_sorting.moorl_sorting_translation` ON `moorl_sorting.moorl_sorting_translation`.`moorl_sorting_id` = `moorl_sorting`.`id` WHERE `moorl_sorting`.`id` IN (?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"{ÊÚ z-éHaz‡ú¡]š"
  b"øY“ð…3Hàæ\x00‹^\x00bÁ\x08"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.60 ms
(0.16%) 		1 
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¥Ð¹ms\x03¿5=Ó\x03å¹'"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.56 ms
(0.15%) 		1 
-- sales-channel::load-analytics::read
SELECT `sales_channel_analytics`.`id` as `sales_channel_analytics.id`, `sales_channel_analytics`.`tracking_id` as `sales_channel_analytics.trackingId`, `sales_channel_analytics`.`active` as `sales_channel_analytics.active`, `sales_channel_analytics`.`track_orders` as `sales_channel_analytics.trackOrders`, `sales_channel_analytics`.`anonymize_ip` as `sales_channel_analytics.anonymizeIp`, `sales_channel_analytics`.`created_at` as `sales_channel_analytics.createdAt`, `sales_channel_analytics`.`updated_at` as `sales_channel_analytics.updatedAt` FROM `sales_channel_analytics` WHERE `sales_channel_analytics`.`id` IN (?)
Parameters: 
[
  b"\x01—œ2^a~¿¬?“®W¾ ¯"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.55 ms
(0.15%) 		1 
SELECT `product_search_config`.`id` FROM `product_search_config` WHERE (`product_search_config`.`language_id` = ?) LIMIT 1
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.54 ms
(0.14%) 		2 
SELECT LOWER(HEX(parent_id)) FROM language WHERE id = ?
Parameters: 
[
  "0190a5d21558701cb17a1f89991d17e2"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.49 ms
(0.13%) 		1 
SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id`  LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id`  WHERE (`country.salesChannels`.`id` = ?) GROUP BY `country`.`id`
Parameters: 
[
  b"\x01‘J13£x"‰m\fp²ý;g"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.49 ms
(0.13%) 		1 
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
0.46 ms
(0.12%) 		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.46 ms
(0.12%) 		1 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"\x01‘J13£x"‰m\fp²ý;g"
  "4gf9T1W6F8YT1mttR4FqXNnRXukE4Tux"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.44 ms
(0.12%) 		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‘J13£x"‰m\fp²ý;g"
  b"\x01¥Ð¹ms\x03¿5=Ó\x03å¹'"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.40 ms
(0.11%) 		1 
SELECT path FROM category WHERE id = ?
Parameters: 
[
  b"\x01‘ŽC\¬t®Ö_œêdÎy"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.40 ms
(0.11%) 		1 
SELECT `product_search_config`.`id` as `product_search_config.id`, `product_search_config`.`language_id` as `product_search_config.languageId`, `product_search_config`.`and_logic` as `product_search_config.andLogic`, `product_search_config`.`min_search_length` as `product_search_config.minSearchLength`, `product_search_config`.`excluded_terms` as `product_search_config.excludedTerms`, `product_search_config`.`created_at` as `product_search_config.createdAt`, `product_search_config`.`updated_at` as `product_search_config.updatedAt` FROM `product_search_config` WHERE `product_search_config`.`id` IN (?)
Parameters: 
[
  b"\x01¥ÑLÃr'™Œ‘CŽ\x1DÒy"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.37 ms
(0.10%) 		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.36 ms
(0.09%) 		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.35 ms
(0.09%) 		1 
SELECT `delivery_time`.`id` as `delivery_time.id`, `delivery_time`.`min` as `delivery_time.min`, `delivery_time`.`max` as `delivery_time.max`, `delivery_time`.`unit` as `delivery_time.unit`, `delivery_time`.`created_at` as `delivery_time.createdAt`, `delivery_time`.`updated_at` as `delivery_time.updatedAt`, `delivery_time.translation.name`, `delivery_time.translation.name` as `delivery_time.name`, `delivery_time.translation.customFields`, `delivery_time.translation.customFields` as `delivery_time.customFields` FROM `delivery_time` LEFT JOIN (SELECT `delivery_time.translation`.`delivery_time_id`, `delivery_time.translation`.`name` as `delivery_time.translation.name`, `delivery_time.translation`.`custom_fields` as `delivery_time.translation.customFields` FROM `delivery_time_translation` `delivery_time.translation` WHERE `delivery_time.translation`.`language_id` = ?) `delivery_time.delivery_time_translation` ON `delivery_time.delivery_time_translation`.`delivery_time_id` = `delivery_time`.`id` WHERE `delivery_time`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01¥Ðº¥qh“?6:þÇ,\x02"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.34 ms
(0.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) LIMIT 1
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01‘J13£x"‰m\fp²ý;g"
  "/search"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.09%) 		1 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(0.08%) 		1 
SELECT LOWER(HEX(sales_channel_id)) AS sales_channel_id, route_name, template
             FROM seo_url_template
             WHERE route_name IN (?)
Parameters: 
[
  "frontend.detail.page"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(0.07%) 		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.26 ms
(0.07%) 		1 
#cart-persister::load
            SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters: 
[
  "4gf9T1W6F8YT1mttR4FqXNnRXukE4Tux"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(0.06%) 		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` FROM `language`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(0.04%) 		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

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.