Query Metrics
95
Database Queries
74
Different statements
127.86 ms
Query time
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32.99 ms (25.80%) |
3 |
# header::navigation::read SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.override_1.title`, `category.media.translation.title`, COALESCE(`category.media.translation.override_1.title`,`category.media.translation.title`) as `category.media.title`, `category.media.translation.override_1.alt`, `category.media.translation.alt`, COALESCE(`category.media.translation.override_1.alt`,`category.media.translation.alt`) as `category.media.alt`, `category.media.translation.override_1.customFields`, `category.media.translation.customFields`, COALESCE(`category.media.translation.override_1.customFields`,`category.media.translation.customFields`) as `category.media.customFields`, `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 `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation.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` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation.override_1`.`alt` as `category.media.translation.override_1.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation.override_1`.`title` as `category.media.translation.override_1.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields`, `category.media.translation.override_1`.`custom_fields` as `category.media.translation.override_1.customFields` FROM `media_translation` `category.media.translation` LEFT JOIN `media_translation` `category.media.translation.override_1` ON `category.media.translation`.`media_id` = `category.media.translation.override_1`.`media_id` AND `category.media.translation.override_1`.`language_id` = ? WHERE `category.media.translation`.`language_id` = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND ((`category`.`path` LIKE ? AND (`category`.`level` > ? AND `category`.`level` <= ?)))
Parameters:
[ b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"\x0F©\x1CãéjK¾KÙÎu,4%" "%|c81f275613694bb28c5c3c394412ebde|%" 1 5 ] |
||||||||||||||||||
17.66 ms (13.81%) |
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/43ee5062dfb1422587cec722bd000af4" "/navigation/b74edce2e93e4e41b819435141ff1592" "/navigation/982b201a19754e7e9d7b570ecfbda99a" "/navigation/bc44ee282cfc45a4bf0c4b3b683cefb9" "/navigation/0e439d60e52c4efaa11964afb2543082" "/navigation/401cd1814c484b2db780a2ce5a922191" "/detail/f5360349cba84355b21c4edf83cc7065" "/detail/4f9a74003f624364bcfb8206b65f0e91" "/detail/dc420cecf3e44bcb985ea74824b35464" "/detail/842e4f6204434181ad7ae948892bcc37" "/detail/41073458bea748e498b6d37ac6c2ba2c" "/detail/3107e03d9e414db7813479e65d253f63" "/detail/7e7f02949a154e02a74d63d93bf89bf0" "/detail/1beff1f310a2475a97bfae8c0508f178" "/detail/1c6f1cc825df4b56a805b639a44b51fc" "/detail/be5b4544b65741a9b6c88aba78003712" "/detail/740fb0e885fc4555b5e583d20545e8fa" "/detail/f7d817a0bfca4dada8de27643bbbe553" "/detail/83a8c7510cbc44689fc259e5f7694342" "/detail/fc3b6da349f240138a25d93bdf530204" "/detail/f00b051839644e9f94c9598a93146a8d" "/detail/544bc7aa29914b78b93fe8ffadffc4dd" "/detail/882f303f42544e9ab500bb0a1fe94cd7" "/detail/1a641c06d6ec4b34adddbb450b7eac7a" "/detail/b6b9c03348e54ae6b24c5cc5e9609442" "/detail/1b2c1083b1d34b8c8034a619e4bb89a9" "/detail/c1f0bad4dbd14b9b94ffcb57a2253cab" "/detail/858ca930fc684f32bab9f0f1c4970396" "/detail/fc11902d410e40248c343eacc45ea6b0" "/detail/2f687a6c4c8c4d42965388da122df431" "/detail/b0aa46dc020b41448295c40f0137b60d" "/detail/1361cc08797f4f65a545590b1d3ca00d" "/detail/9ebc1598ea3d4f38b33e991fbb67062f" "/detail/5e61a2f8376449e58d664f666f4c0935" "/detail/df031b9090e647f59b56a86c2fb02e27" "/detail/151e63b558c44f5b9857bf67be6c1d6e" "/detail/5c378e7f697c44fb822b4c7c6706d771" "/detail/fde38a33f7704c0db6c4eaa2fe20643b" "/detail/724fced3549b4a49ba224abbafcb72c8" "/detail/900c13d2a8b044dea8468f0c87a105ff" "/detail/cde1c93c98344fd2a4f211869f13c985" "/detail/8ff5acf1bdae46da9e0c7de5dfde3702" "/detail/82b3c75aa2874aa4bee1c3850df892e6" "/detail/5aa50e9035a547b39cbdacf9db764e49" "/detail/0610e3fac7a64c6ea7594dbb5360c670" "/detail/b969949bacd34c138b0f3a94a4087f01" "/detail/4be0cedaf41643cf943695e155577fd6" "/detail/795376a7208d47f5bba60e9ef182cd15" "/detail/f0a1a7847caa403c8c8724ac008faa5a" "/detail/8aadfef272c94b18bbe8366a7a1abdea" "/detail/2dfd926d9e2a4e309048dd50490cdd8a" "/detail/12b4c9b39a8449a2953867b6a74c7f84" "/detail/e597fba6ab1346c18480ec4ca00cc2d9" "/detail/011c939531354a7592634c114b99189c" "/detail/e53f89b7d53c4a0897aa4cab253a89c7" "/detail/b7a4a3a3361a4f59909eaf99f289c10c" "/detail/75a5c9e946bd489bb5585954f6e61d73" "/detail/2e93f071bbf84ddcb6ab706bf89b0389" "/detail/97b9b84910eb4c4592700ad2307a4a4b" "/detail/4b7d3f0cdeab4d6c80bbc7e1601ab875" "/detail/138bc4260ea84c1db571d5a3f4b9f512" "/detail/c32f2123673c4d769ec95ae00cccf0c4" "/detail/2a51a4abc2144722ad05914df8c99664" "/detail/62650d55d16c4301bcfb22c9d0d11629" "/detail/3f2662a54a0e4bf4b8de929bf48b796a" "/detail/8c6ea987846442f399a41a5ed715e72d" "/detail/e806c9a27deb4ef684de2bcdc77626c1" "/detail/d45fe1af70f64795a1f51d3ec3140c70" "/detail/d59577dbed8e40b9b68effaf4e512c71" "/detail/dde3146e27d0492eb1fd9e129f6270e6" "/detail/d2237bd712b64d06b19a9b26c7c1a6cd" "/detail/20870c7d57604414bc849c28d146fad2" "/detail/a43697e282734ab483471b61e8775266" "/detail/ebd0c53fa70a4a0090c74154a70b0f1f" "/detail/26bc09088fa04a2d9c2454e2d8872dcf" "/detail/2fa581429fb848ed833388cb2286f8c4" "/detail/9cb64bbb56724eda9cf139d823ff6ae0" "/detail/32dbf33cfa1046a3a29538728107258c" "/detail/41a7f1ef4202407497c6291cd83df228" "/detail/52d5bd0b4ab343e788a6c06e83602460" "/detail/c4c0fad128e44aa0a0ad7d9f81f6f966" "/detail/fe180a800ce64fdf9e73a7c7e0b3e61e" "/detail/3a83a04e520547edb0115298bbf52111" "/detail/c596a21a95fc4d4091eaf49a622e9300" "/detail/4ab2aed783fb422cbfd21d7d168aab81" "/detail/157ef1169cdd401a99df0bc85ff9a3ec" "/detail/163882c668e34ca9b2d3ce58f748e807" "/detail/570092cb6f3b43a9a2e1c78dd441da53" "/detail/9c0d9cc6508e4f849aef8647061b278b" "/detail/7442c0592aee48bca763b32656645e9a" "/detail/169eff25c41643f58fa7a2fc1c31c98c" "/detail/3b22696cc988487eb7eaed47651784c7" "/detail/0a8a6e457ce3437abf437e5c7484a328" "/detail/33d4808611494d5ba81504b790fd841b" "/detail/a8efdb28516f4a66863d4d4bb2ef689a" "/detail/8e0c855f1a254664afc2d10a0e49bd8c" "/detail/3c2ee998ede641f5904bd969bdc63c18" "/detail/09643682eeba4ec08e87c8f5be4996df" "/detail/8b0ac84ccfa142c98d71385c42507f7f" "/detail/678d4ccebbbf4aaf82cd918322413254" "/detail/ea542fe5df1744af9bcb9d7a7eface02" "/detail/32c833a7ee424c3b8e863b12e38a611b" "/detail/c63f9e80a5ae4e3f87d0ff7dfd9f832f" "/detail/a4149152ce784108aee9c2b4c89948be" "/detail/95c6ec6d4fae40909614f5691d34924d" "/detail/674e2832ea62462da769d87fdd5016e2" "/detail/01279b40cb594126ae9eb239687bfaba" "/detail/ac8a558870f04750a4b91f0a1ec58315" "/detail/ee255736f9d943c7b2c536e97d87bf35" "/detail/5a839a2213ba4c29aa59daaccd97d430" "/detail/2865b31a002b4a11aeb6be89f631ecd1" "/detail/8107c1bd2bb1405f8c5a6c02dce7ce97" "/detail/e6afc649382d4189929f378bcef2e1e3" "/detail/28563bac714a453d8b8a3a96701fcb86" "/detail/e177e944c5f3475fbbccaec4e7f90134" "/detail/26ce6034072c4a459f6eca0959aec226" "/detail/9324640b73974877baf20e288ddd3c2c" "/detail/357a452866c54209af45a7f5faa27b2d" "/detail/ce9059ca0296453988afeb0e66efa337" "/detail/0afb05b474124d13a370273f87de4e17" "/detail/ab0ccd21e6414e84a7178863dc4ec317" "/detail/97f75dce073d4691ba5fd6ae5a21fb1c" "/detail/f19e887668ba46f8a39cd810fb8e31e3" "/detail/5fd7c310e7fd4e84bfb60e69858de786" "/detail/6249024b7f0841e18c5e13964d5ac6c0" "/detail/3a9d070fc142408e8ad657b25889f48d" "/detail/7504d63bfd9642fe9e509a434ca9cf19" "/detail/e5264174e9324f63870b2adba6110141" "/detail/4e887451cc4a4a2f9e6fbf2492d5a960" "/detail/ffb5a1c6c2ef4a908c193598d581733a" "/detail/32578a7436c044b98c022d8810395b4f" "/detail/6e9dd68773514cfdb1da2d2387d9ea7f" "/detail/c45ec55d5d6c4bc3895ecbce254ab1bc" "/detail/a78da718f53e406aa0a6be3634d5a2cb" "/detail/6662361374204697b6d047d4976d5eb5" "/detail/8f004a829c5547059611156270d445a1" "/detail/54d38bc353444aeb874212639c3f976d" "/detail/44a8e6341b0f42079008a06642a9b3b3" "/detail/e32a72110f3648898ec607e8829a319d" "/detail/9db4b898d1f4433fb783aaeae52f6af7" "/detail/05d189fd84b04c03b994d7b79df43d19" "/detail/a368bd6458a64702ade214a50ba88d91" "/detail/930d9491139e406b8cfcd4b3d69a8878" "/detail/a48231c63ffb46ce81ef622d9fc5118b" "/detail/5bb273654f0046569ebe270bd7a73c7e" "/detail/5e21f17adebe431bbd6b8eb0c1f1c42f" "/detail/60854390ed1e45feb2d36c78519172f9" "/detail/f33e407574db40d998c814b16e5a682a" "/detail/51ec1d5662af4f54b883e3ad46c941a5" "/detail/c5a9174387334ed0b3073119b4e7f613" "/detail/67da9a1ced48442fb558a639bcf58235" "/detail/ec314ac479c74b1dba807c407984a69a" "/detail/5c0b359b3eb245a3b1face54542423bf" "/detail/d9fcbb09fad04f83bad8d007fcd04f0a" "/detail/9f1765270eef4737be1502d73f7fbb09" "/detail/82185e24c8e248eb8e7585616e03a48a" "/detail/1e6bdd972fcc4a97997fec1af11dc617" "/detail/9e937834f072421faa2b0ab6a0f5701c" "/detail/e0a71849cb70496ba50bdb5e235b9c99" "/detail/dbd38b85c70e4d05bb462357109cc21e" "/detail/c5401e8236af4cd3a49fde37255f9dbe" "/detail/40e86dd3752c44e3bbc3d90afb369d05" "/detail/dae83e10e7d045f58474de4003dcdc06" "/detail/ec44a4705b9d4c3abd174371c7c871f9" "/detail/10d73bbd5ad64c74ac4e3bc1ba929141" "/detail/908ea880c37043ccbaca720a574ab1ee" "/detail/9e3f8e59717f46bd8ca0a0b083926e88" "/detail/b5dd50b8189346dd8cc7c954625d8eb8" "/detail/4729649ee7294234a7ca8f207f76ab6f" "/detail/6be3b7a99640498d943f8522e9128d18" "/detail/a23b3516c8db44099873f407c60bf241" "/detail/39ebce816d7440ceabbfc9e4cdccbded" "/detail/0740c0be347646ad9a887df6e11a3988" "/detail/c34f9938b14f4b858987afbdcfa0bf0c" "/detail/3c2a8b329cec45f683c27d154d8f0de1" "/detail/b4e2bf3639964baeab19d64f30831ee1" "/detail/0fd8c666d4394dc89728c5f96dcf3fea" "/detail/36fb5a70bc6142db99ee85c4a5ca24bf" "/detail/b12d0b17f2434adc95430c1657151dba" "/detail/6e97fd54d20144aab8e4ada2d732e3e4" "/detail/d135b96edf334718bab12243e6cf2022" "/detail/0d1c116d1baf492fa9218b5a6176bc11" "/detail/ba3815e42bcc4a9e8e0fbdbc746a3b63" "/detail/76eaffe590934a239b80a8f53c7994a7" "/detail/008f156e2fb645a28edb8a6a6bd83d5f" "/detail/2416fe2d9ae8466d9e074ea8d4e5dc85" "/detail/f406dd6fba5049fab6563acf4cfbac85" "/detail/fea6152634db4f63be2438ef6b3e8773" "/detail/1c61c95d27b04795bb81550f44ab75dd" "/detail/e0441407f60e4d1cb3c539fe323d6c98" "/detail/e6b72d7126cc45bab1c4d266219fb8a6" "/detail/7ae8d4356d8c454f9397f82f77e579cc" "/detail/9db71334c67040859b7d20c698481839" "/detail/8299aba5c32f4fd495d97eb79f869ea3" "/detail/aedcef71294e45d4864f3d4fff501f94" "/detail/e0c1392f994d430296ecb5201cd2e228" "/detail/70db68dc1d4942c78b9a05396ec032a9" "/detail/ec7a95b214694d62addd0ed52c3ebdf3" "/detail/dfb16a567d8c4be2b5853749e968f905" "/detail/cc8bc93590b446c784ec1bd276cc0e43" "/detail/2ee4619c54044fe7beba6cb93fd89fd4" "/detail/09b1435cadbc444fa2f93eba75083d4b" "/detail/30517257b40e4e989380142f73525691" "/detail/641e5da741a84234a0cf4ac708bd5dcb" "/detail/741240f21a2e4167833eeff835cfc815" "/detail/e0bd7ab7f11f4f7f803b93d3676766fa" "/detail/c72d02f77bc54bd0be2963eaf9c752eb" "/detail/c5719e98e0ef458f837cafedd6ab59cb" "/detail/ee92ebd46ec04173a25fd73f6d998197" "/detail/d539bceea1584c7c94b2648cec962339" "/detail/a81d93c067be4ada823907fb365a892f" "/detail/d40882448c934170b001f2b0a393d809" "/detail/1aee3407d0c44e06909f2bdcf384c1d7" "/detail/0e12afe254e6413db82cb2de22db0d77" "/detail/0d569381fbcd4a85bc92c5fe8d7460e5" "/detail/8629ece16d6946fea20d991640223938" "/detail/35311cfb101440288718644e03550d34" "/detail/fbaeb29e76734c438b90b9f3f7826cf4" "/detail/4cdf456b72b8476a83698cc7b1ff824c" "/detail/8ab11ef6338e4861bff10f8b9c3a33ed" "/detail/a2da0fc7ed8545be829b3911a1e76c72" "/detail/8efa59b35603494489c0cfff87c8cbc5" "/detail/0ed87f0782214cbb82a2c4f36acc7905" "/detail/e08d5bd347eb4cc6baac71315a56d5f0" "/detail/1e7f66cf6f34479ca17ee1d048e09372" "/detail/87e859958db0460296f99ab09f2453f8" "/detail/ff7655d1ad6742b982cda4dd8116fcf4" "/detail/5a225ee7e6ab4bcf869a60249a431651" "/detail/d837c141338347e099acfd0ff6ff53e6" "/detail/8512a02da35f4af8ba71830b8d47a18b" "/detail/88d89f4cfa764277b523f99d5f681ae2" "/detail/9d6eea231f5344b9b09e7129b51e42c8" "/detail/c9ee4eddd7f84ca79ba262c113a4e50f" "/detail/88d484bff1314e20a4a2f0b77d80cc71" "/detail/b8dab6183b104207a5f0a667d25ba490" "/detail/5713abfe30dc4f309409e590066e8ca4" "/detail/9d671059a4df40c3849dd578186acf4a" "/detail/f6fa09f70fe94711a8931eb97ad24786" "/detail/d9fb57dc3f744fd1b87003ee38774e40" "/detail/049c76f309144021a3d3d6b219dede88" "/detail/66427e4f37ae494a8852bba53af1651e" "/detail/427352b18cec4517a6b59afed84875d5" "/detail/6f2fe98d27b644cfb0823c2c517a3883" "/detail/ca18e4eb7a574e319b775d65ad814160" "/detail/2754aa1ba4984d258e066e91fe6f8a1d" "/detail/7bbcab28aeac41a7be3553966919af37" "/detail/fa1bf74a5e5f433f82a73c25a925010a" "/detail/c2072a8ac1e44ad08b1437ecd59b5f8e" "/detail/bc5295b86cae4bda8708eeeddd754fec" "/detail/2b171d0ec76d4126a1956679023ad295" "/detail/61dec363c6d84352b5909159f3828300" "/detail/c5cb839183014ddda57fe8646a4172f9" "/detail/fa8b9caa24bc4cd8a2cb34a780839c1f" "/detail/be01f54dd27b428e90837f5c12da4fde" "/detail/0e4a2dba0eb74db898d0f69d19594bfe" "/detail/20bdcae8423e4b00b4abb538980e0623" "/detail/fc1898c674684fbb803ee2d12dfdadad" "/detail/1d9deabddf4c487ca5b5fffc783ea555" "/detail/1e23397f36f145ccb833935856c57abd" "/navigation/83f7f66ae86240d987807e0f3e4f0f7e" "/navigation/9f2dcbbe3e6547e199d5fc20523b2454" "/navigation/fb863fe989bc4cfd939ae88253d5d7c0" "/navigation/cf625fcd202c4d23ad26ce169d3478db" "/navigation/59520067684b44809ec319062efd544b" "/navigation/1c00d7ade7a8497a9010f0fddf0b4a6f" "/navigation/9c8c627ed89e44e1a681ccde5e08912f" "/navigation/72de036ec0684eb8b73398ba579a5cfd" "/navigation/9242ba548280441085c16407ab98b317" "/navigation/3fbc9c172b9a41069eb15667f58abadd" "/navigation/f99cc2bf0a1148da9aed3ef8961899d7" "/navigation/c5ac1685478149459289d16b80270dfd" "/navigation/ca5b125406d64ccbade5eb021740ecc6" "/navigation/b4202f5159934df2aca3cdc5339ac6fc" "/navigation/e967a3a52ffd4a7b92623a0f6e68f76f" "/navigation/e9b7686d53394a93bebac49be2930fd6" "/navigation/9a3c3764b7bb4c35bbb60f2128fc12a0" "/navigation/e81db6939ad8467eb9db8a2719560c93" "/navigation/cd9479a55e734c9081a1ccb33fadf041" "/navigation/865df0a8e53c499bb2ea3e553cf70842" "/navigation/ef6c23bef96c48b3a0ba3eeac4d47b6b" "/navigation/1f563ad9d8664a82a809fa2c8fefca56" "/navigation/2c99b48e4270449c8bc0c71ccd17284a" "/navigation/9c9c23721ff847c99827abec628e4ad0" "/navigation/b216f1feea8145aa867f0fc7ba882e51" "/navigation/dc6df4aa2b2f4b818d99a7341af2e204" "/navigation/0a24b41102b3444a8590887cb4459fec" "/navigation/2140ad5fb6c54b43b1d44a5b92b54b75" "/navigation/1d7703c3d4dc48ffa49ea0b073cf39cc" "/navigation/52ea1037f41f4c7b8b1309cf9e08b6a9" "/navigation/7ec4da9fc03c4b3f8b676b97dbe3aeb9" "/navigation/0e038c1fcb6c401cb60824b8849e904c" "/navigation/ae72d48c4eb04d6e96ef5927af4cda8c" "/navigation/7e647b060ea74a1195ab1c675bb8bb8d" "/navigation/621c653da3114262848eca4b11f447b4" "/navigation/69dee7eeab784834a535ac84d03e96f9" "/navigation/9ac17625edc7417ca631c2ebcfbb1fb3" "/navigation/db21b273b72947728d768c545960209a" "/navigation/336b5dc95bf74d90a3ce42b50c34f01f" "/navigation/17e0480158854b1d83667b077a8f5421" "/navigation/7525825e2f884136bf7e0c986ad59b79" "/navigation/7530abff99f640adbf01a8ae4e431923" "/navigation/e0cbc9c26b4543c28ff87c4e8c572edb" "/navigation/733d84155e8e480dab9df307c898701e" "/navigation/46f79439e60a4b71b83652c492eb3928" "/navigation/71fd961183d64379ab73c8e9e3d9cfce" "/navigation/ad437f3e50f24e94a0edbb3be39c289a" "/navigation/f4626db9e9e240f0b7cdc5c3ff6a0178" "/navigation/74978b4c1af242a6b9be429f8fd46ce4" "/navigation/30d080e5e8284834b176f0b7d137dc91" "/navigation/af7e118ff9d44fcf8a533415bd1e0005" "/navigation/d0b3c50dcb8e43b195c431ce37339f9c" "/navigation/bf94aa9678484a1397d1afc15b81e084" "/navigation/b8feeb70e38f468dab25ece942beddda" "/navigation/7033503a12054529b00716a39f83fd58" "/navigation/a67679cc4a1842babcd0e5e6255e60c2" "/navigation/6987c5a535c64a048b21033506cc12ca" "/navigation/73eea2b2412e4b81ae45c81f062007d7" "/navigation/4b9eebc95d4d4a699e5e9aac0d8afe0b" "/navigation/9aeb8bddf3304a8fb47b9f2beb3809d9" "/navigation/08b4bde9de66443bb728ccd17f2e7507" "/navigation/3629fda43e7542d4860cc44ae0ede250" "/navigation/f0372fed97f1495b84b7cb49c0736ada" "/navigation/781768a5b51b4973ac5b46b20ac5c2e6" "/navigation/dab14c5a60fe4670b648f6846aecd95b" "/navigation/4c272ce03dda4c96b77cef5625794b92" "/navigation/dc540971faae43ecb4afac28546cf701" "/navigation/15d009d5c7a046f586fec3aab22041cc" "/navigation/7a7d230748e047e5a8420dcf6579cda4" "/navigation/ba8c9b1602e24c9ca8dd3cbc365b3183" "/navigation/a5393e08797041f1975b5e059d697ce2" "/navigation/0a81af7e5c5b4d7e9eb6965fa95c8d4f" "/navigation/74f7d1f466044808a66a3c9e05969cb3" "/navigation/1aa685f7e51c4daab033678b64347799" "/navigation/a48c8e32a3ab453996258f3e94bb54ac" "/navigation/d2951871dd2f46f4b5a7bea2f3d436f5" "/navigation/e6b25595c7104dfaa5f29369e7beaab6" "/navigation/04bf7c3efc9e4831ab5327234a46992d" "/navigation/0a9d3116ea7a45b787a70a8722c00d79" "/navigation/7241ec49ff1a4a3a9388272234da9651" "/navigation/6f305a810fb34e0fa7528baebbde5086" "/navigation/adaa854725ef4b659e22c8e7962fd121" "/navigation/dce9dc6fcebd43afb176f5fea9d20aa4" "/navigation/42e3d8c3a9504d0f98ffb543b74c6270" "/navigation/68f2fb59cf1a4aeabded451e534ba979" "/navigation/e52105d9df384cc78881ebcbbe45cb1e" "/navigation/b802fdef591e4850990237259d2d8747" "/navigation/342f822f68a0406d902b7b3c08abf690" "/navigation/88f32ffabf17433080ebc6ac8c0a2909" "/navigation/187dcf959cc04d74909b51546c8192a9" "/navigation/73d83978007e4f06bb6e362e02fb0000" "/navigation/7494f03d08cb4313ada8fcc397a196c0" "/navigation/b05a1d7916b74f268b373f766c7eb1da" "/navigation/24e36382830d48d8bc6bce633d5bdc8c" "/navigation/39e829c427e1440cb77cd2b63acdd9f9" "/navigation/016de025f43a412db3d79f797cc9d5e4" "/navigation/df065b3a2eca4e979838fe950db6d134" "/navigation/662e9eb4c38a4f3d967ab59b2b7d6174" "/navigation/1c30c8096bcf442ca3fb757359d8b0f7" "/navigation/2e8a59fdad10498a86a310bc794e7569" "/navigation/d244e253d3914a74a86517ac3668c8bb" "/navigation/103d8d205602485eb719b24e84c7b10f" "/navigation/c867b3b5e13349f79e612c503922dc36" "/navigation/120fe59d19e6474aaa918c7a494aaeab" "/navigation/f0317b515dd24887911791699345f54b" "/navigation/49b545b4062643eeaa6db1ee97133f14" "/navigation/cc2213879c1a43839fe5e394989b1e0a" "/navigation/b47de44053594eae813add998a0c3d83" "/navigation/c5035218e23141c296cc20207c249194" "/navigation/ce685e9b2b5041afa9f8a7fb163c3dec" "/navigation/3b9c6d9cb136458c97dc3382478741b6" "/navigation/422200cf14064009ba0e6dc62e8fd5bd" "/navigation/d5ebbfc2ba6e4ac082bdcd3276efe882" "/navigation/6168a105f34049e792320d7515cd97ba" "/navigation/64d2f526bb084b4ca548361b4c73ac2f" "/navigation/1b82169b23ca4564b7419242e1a7f83b" "/navigation/050b9cfb94f445b08c82f602e5cf35f5" "/navigation/a41ac1041c6d4e37890e862a0eb9d1d6" "/navigation/e10fa98f5bc44612bbac2ce376324263" "/navigation/85059c8fff1445458acd7e3b1cd0d3b5" "/navigation/953f390ee3ce44dfbcf0c9aa93f4bab6" "/navigation/4d564a54181c40919417a06de2e5a9fe" "/navigation/3a26f0c2c2864d42882f15f7718e7bde" "/navigation/a05e323cabde443f960473af265e6aca" "/navigation/2460f9da2c8f4da28ee36ca642fc9b7b" "/navigation/54b846af3e844d718b51fd77920b9851" "/navigation/fcdb46c99bc548a797d090099a70dffc" "/navigation/d259852d46df4a48ab3e84d1b458e1a6" "/navigation/31353fbe3eee405690b673a6a7c110e2" "/navigation/d7f32761100d4d0899d4deed2c8bcc17" "/navigation/74da5269984e4d9895a01e0e03fd3137" "/navigation/6cea9a6c29cb46689cd3f95740d04916" "/navigation/69af787ee78642eea7a54ecbf2f1eacd" "/navigation/f840f4a4fd1145e8afcb6300d4dd61c0" "/navigation/a34390ca778649f0a50ff1763e7cec39" "/navigation/74dc01119e7b410da177d129987a847f" "/navigation/fb1d3ff8c5b54c36bbcb1d9879818228" "/navigation/62f4fd5e625b4506b3d6cf9c67840684" "/navigation/b0b87d052efc4cb3bef5f401ea21090c" "/navigation/dfadb8183cee4fa79733f1d5c0416bee" "/navigation/b47853d6e711494b93e322dbb204971d" "/navigation/da9d0c0d4afc4435a718030f0eb66806" "/navigation/a5f72c63f24e4fefb841b460a9730fc1" "/navigation/f745367050bd41a89c714cdd91918758" "/navigation/91ae574bf6bf42d7a9dcea6ad13c3dd9" "/navigation/461f154ea92e4672b2fcfa55b6880ed1" "/navigation/87f5bb67ff154287a8226786f1b9f2a0" "/navigation/7d77f4a5113b4787baddc8d5dc4a07d6" "/navigation/e37592337a5a4b05b69524ea66cb196c" "/navigation/a80b16029c4744298627049ee0720da4" "/navigation/2acc8607ffa9429ea9ed138a7c58b015" "/navigation/f7762239bebe4f84a067ffdac7a3b5fe" "/navigation/dabf315f974e4391a1ec9d4154502313" "/navigation/69e0b70d176d4b1b919ce2368a3108a9" "/navigation/886e5035fd0447378c95efc0b867ade8" "/navigation/8b9b2fcfd0a44b4b8a815f41068841c7" "/navigation/6211c99e20d04b2c865bb2b67c29c4d5" "/navigation/a2c3ada80bb141eca756677cd1901f53" "/navigation/17780f95f0314067888450874d7015b1" "/navigation/0e40a10210f1406294710708bfe9d1bb" "/navigation/aba3e12bcf5346a69f98912ffccc104e" "/navigation/8f092d0bc4af48b9be9f61bc96901cd4" "/navigation/e0f50f36a04a4580a4c4cf941aec7769" "/navigation/b0e39679d638448bb5a9ccaff9161036" "/navigation/3025032497774432badef3ee54c64382" "/navigation/faeaa0b4484a4c038bc7219c53c2fc1a" "/navigation/975d0ba5a6c746db80b66da65b836f70" "/navigation/494a47a1ad9a491bb755036ea5b5d26f" "/navigation/e1b002bcf423429ca9ff324fb75e07a5" "/navigation/acb817f9c15d4d3db4c74834a20b3a6a" "/navigation/089ef2cd90cd4265964abfbc016e04ad" "/navigation/44e2de865bd94dbfaaabd455d6298919" "/navigation/c4b6cf3e869f404992ac01b0ec44e30d" "/navigation/b995ce90e15046dbb687e144637727cf" "/navigation/65cba9d9ee114fbc888e5533a42ea950" "/navigation/8803d666dfab4777a553812315f6df01" "/navigation/4482620bd1424834bc3808f9b1af27fd" "/navigation/665a0a3e130347eaaf66a073c655c94b" "/navigation/f3327b5fde77437f98f617f5e8c94c97" "/navigation/c89d7faec9c5415189bf0fcc94dcb915" "/navigation/8382df424b68456689e9abe3127e5c14" "/navigation/d0e3587330ef4bab9a1495191edfebf6" "/navigation/e194c79e34b74088ac9613dd45aa3b36" "/navigation/dfc800202a104e88977be6c648795e5c" "/navigation/c25765ab1a014f65acba8a2eb49b7575" "/navigation/d7ff69c8c9d742469ea8486133e87373" "/navigation/5237db48683c43f6b3090637c6388fe2" "/navigation/c528215238074fbebe8aaca20e8494b2" "/navigation/d49d0d762ea743d2b31c07fef60fff33" "/navigation/c3343f0514374ec48c2c326458548592" "/navigation/f51d1b01333441f68c786d5e62eddae1" "/navigation/e4de5b8127f74208a8088dce319d1e2f" "/navigation/7a320cd6f5924b72b664ddf0027a8edf" "/navigation/cfff6f1b19bd494c9806f64421853fda" "/navigation/241d91022b2945b4a28552f2e38c5765" "/navigation/137fb6bdaf7147598c8c686014d3a4c2" "/navigation/a23523f151fc429bbbb24dcb29883c01" "/navigation/db13de19ec7545d7bb49ae44e5b383c3" "/navigation/8d959dda329043aab33f62526d131aff" "/navigation/6214d93f7c0742bcb4de524f3cb85307" "/navigation/a05b626c47194b7eab9f8c51a9c2bd34" "/navigation/3b6a64c15b56435d9d1ca013859c7e23" "/navigation/36fa6f793bf44fb3a0d3c650cd82adb4" "/navigation/cbc95c9a5bbc437ca69e69d26cd70df0" "/navigation/98ea7310525144dcae3423e51bcc792a" "/navigation/860cdd1e6cd74e39996202c789d5bc89" "/navigation/56593f1c68d3449eba642bebcc78f444" "/navigation/fe06563b461840e4aa029b1d574e23f0" "/navigation/7389fefbe2cc4f5ca2eac20ebdd7c8bd" "/navigation/dab3366249374d1b9a28733128983487" "/navigation/b15d6a58f082405a92fea21ceba7a5c1" "/navigation/afd627cf17504baf87ea99e3f28086dd" "/navigation/ec5dc47552454d1b98f584e910f3c59f" "/navigation/1938405c15074169b6b10634da61e094" "/navigation/ce62b75fa09c4fe4b5578d0b43ab7ae7" "/navigation/54f92310bc684662a699bbb47b4fcadf" "/navigation/8e3654908a674869add805d258b0dccc" "/navigation/fa7857f0dc8f466f842feb041193836c" "/navigation/9e575bf16b05484e9926b5daede4852e" "/navigation/aa0d409245c34e5b8fc7a66ea6f73fc3" "/navigation/092b2101e3334dec9556829eb11b82bb" "/navigation/a4b8541d7c474a2c8870cf7a6281f3eb" "/navigation/2fae1bceb9d343abafdace2fa77dc5b6" "/navigation/bb2cce9bc28d481da1c5ca50775719f7" "/navigation/568a1162c16448dc870de7b159540fff" "/navigation/9e3be7191354472db0d2498e7a3a212a" "/navigation/f83873e720c1431f820133f15735b107" "/navigation/88d087162c614b46a6762b77e503cfa6" "/navigation/96d0660baa5846a38b4bdff55089232c" "/navigation/a20ed18085204e48a15284717dac9c66" "/navigation/39b05ee60aae437d88fbbdd6a781d84f" "/navigation/4d13a9cfcbf441a08ad98093c9c6154c" "/navigation/3c4bb8fb55ce432aaeb121a09bd9dd81" "/navigation/3f36664f52e744c6aa3d515465858f11" "/navigation/921e827a8be048e7ad126fe71045a944" "/navigation/a15785f9bf984550a59bc29fda96918d" "/navigation/4eba8fc4f60f4651862b41795cbbabb4" "/navigation/91e62a5ee3bb4387a5f0c3c02ffe481d" "/navigation/2ca0393d641c4dcf8699f88d0c6ff3d3" "/navigation/c08a7934888543d6bd1c593a0b30ce9a" "/navigation/35d2269d872c4ad38ac276b6ffd62fb8" "/navigation/e34c8c39857b4c58a4f9adbb426afda3" "/navigation/767e099e1f134e0cab9feab367410b31" "/navigation/a9be62d397ed41bcb0837a9a507e31da" "/navigation/e83cb6b6b61b43189a5d683ff77eba8c" "/navigation/7a1d4f05c7e94a568b4aa902c50d101f" "/navigation/e3692120453a4a3bbe55b1a4d1909e16" "/navigation/cb064e437f064cc1990d652576ead89d" "/navigation/03c6494017b147409bd6b5bff7dc3e1a" "/navigation/7c176612a6e044e9a2361ac667d62d04" "/navigation/c65e69678c444e96a98231abfa389943" "/navigation/f553c4747e144306abf118be158e3aee" "/navigation/dedbbceed50b4a708902cac079f8dc96" "/navigation/fdf5179e8730484b884855acdc1a5b80" "/navigation/d24fc59c81e845f5a705bbf95878760b" "/navigation/ab762e93242e470a9780e052ff099cbd" "/navigation/b175b934bb5e4abc82d9111fdb6c0b96" "/navigation/7731142170a24a608f17179fd9203921" "/navigation/9796a181a2134a48b9d3487ce05373a5" "/navigation/09af9c08a5c24d2a88c62fe545da8402" "/navigation/7f677f257f774f55a7d42649a6813ae6" "/navigation/344d6ce42c9e40be85da8adae13f5c7f" "/navigation/d6e71b625dd84cf599abaa5eeaf4c37b" "/navigation/ac457cf51ad84719ad25839e3f6d4182" "/navigation/9003a98777a34a5f995cb743108fbdcb" "/navigation/f208396430e14625918308637c265a2c" "/navigation/655c87cdc32443099d8cf876e02f47b7" "/navigation/9f60574452f44367a68191c6343927a9" "/navigation/69bb890520e246299793eb2c5dbd6acc" "/navigation/69e596a1332147208819a738fe1c7c9f" "/navigation/b99d6cbd6e4a47e3a140fd32af6710a8" "/navigation/7f2d7d051cd6467eab91f7f9d2c511f9" "/navigation/89dad2e611854f6f9667ee7bd67fe7e9" "/navigation/996f9d66a7814c9285197239ef48f5ee" "/navigation/2bfd6ee29d3d482297f1c8f443e12b29" "/navigation/c0031bfc01004ee598e88f5db946fa1b" "/navigation/9f01a1a58df94b659cdde1ecffee8976" "/navigation/33f49a6fd96f47fcb80e5f597eb3ef39" "/navigation/8a198d42031943aa8c4f4314f0fa6453" "/navigation/0fef02a6f6d546f4a935e72aad3da8df" "/navigation/f91e00c4af0a495aba85c7af1aa6f9b3" "/navigation/db6c77470cd54b0f82662c4d0a72c49d" "/navigation/5e0e49832b4f49bcb329d61c1869c4b0" "/navigation/46a58dd768cf4955a8633bdbda77538c" "/navigation/2dbab7357647496c83bba2940a447ad5" "/navigation/14c229a60d1648a4aa10efd04fedbd3a" "/navigation/757f2b2e0ef54997baff6f75529485f1" "/navigation/1bc2eceedce34e42b1872e766e1b9e72" "/navigation/ff235286fcb947a9b8d895364e961a7b" "/navigation/a78a59bdc1284449ba438c66cdec999e" "/navigation/30ba2841face466ba4133a3043e7435d" "/navigation/f25514346a59453bb34b4fe4b1a27538" "/navigation/5ca43b4ef76644189f2da09b39ad949e" "/navigation/8897ba8dc4784626a0b72c8619717da8" "/navigation/b1e99f27663e44e488f6454917dbbc79" "/navigation/1bcd9e43f84b4218b1377b38c67502a8" "/navigation/0d19d0400b274309bc5816d2a6b33829" "/navigation/f129a5adff364cfe96b8444b6ef42e5d" "/navigation/af5d958b7aac46978ef6eb2b56419396" "/navigation/7d5229eefa2e4bc6834b6e45c78d3318" "/navigation/7c0c43e0d0a947e1947cb9b09445aff3" "/navigation/ee41b8b8da034235b804abb723bb12b8" "/navigation/a1cf961931164193acb7e0596fbba798" "/navigation/bef9deae24de4c028a9017b42c07f34e" "/navigation/a603360b7e2f42c29a8c5fd6e7586df3" "/navigation/26d8627bb2184a9e92785f62de8d249a" "/navigation/776eee72295e437a92af2ba3bdbf9e23" "/navigation/49ca23d329554efb8124de000f7accf1" "/navigation/e56c2d9a1ed949118f64fed36e783273" "/navigation/5c3556e90fb14febab9464c0dfb98df7" "/navigation/37be4e0c27314fdfb106c1b845629fb4" "/navigation/a24ded4368ae4e719d166c0ffa55ba9f" "/navigation/b736b418489547159926433a1405e691" "/navigation/8c559f34cbbf4985b19c676c61d83dfe" "/navigation/9f2e528395184c5f802e61c8d69dff6f" "/navigation/4bbb67be87ac4c449a26f4605046741d" "/navigation/e55ad9e21325415cb3882baabdd48f7a" "/navigation/40dbef35f6874e9dac6af382469ed567" "/navigation/072559fbbacf4149aeb7722a103dcb6c" "/navigation/44d61a3e63c74ec1ad597529e1873253" "/navigation/3be3f0a0ebd2477b9acc34cf84be995a" "/navigation/be1fb4cbd82744a6a3fd9fa4f75a1f2e" "/navigation/e34ef9d8adb94a949606ce736d0dfc73" "/navigation/cd9a172fa84b40dd86ae1508159bf127" "/navigation/7351549f6d9146dca6e2eb62b8c79fa9" "/navigation/d59d7a501e5f4ffa9d8c208191d66243" "/navigation/0f8723520d5648b79ba36f32380fe4d6" "/navigation/89bb87be6c5747e2a22b71e4a8cf4f38" "/navigation/7fbe55d358b7462fae1c466b58e95a7b" "/navigation/52c7f80418a647aeb7b9058c9d0f30c3" "/navigation/701a56f0c2d343aaadb52843f53c908e" "/navigation/78708982953d49288bb71528230662df" "/navigation/9451a68e0603467eb2ae4a9711b5514a" "/navigation/08a3afbb6aa946c7b7f5717fd260cbd3" "/navigation/4283cbab1470492bba0be7877260a01f" "/navigation/3c842335fec746899563618bcefad45c" "/navigation/30d942b8345d440382c4e44017f93b37" "/navigation/32acd72a08fc42c39887f8e42917a3ef" "/navigation/7dbc8c4cd02e4fb392395c0720a120f4" "/navigation/b9c0362f8e4848bd9c962292f49993af" "/navigation/d617c52f6e1f40e1b84ee40cb2a6161e" "/navigation/593262e3f771422a82f02d74eeaa1405" "/navigation/525d2c39ed794d66994aafd95907e055" "/navigation/d8004a315b7242a3865fbff57c02f6a5" "/navigation/28409d4c3582490084b68e0d7e59806f" "/navigation/6fd3751b7d07496398ea4579e2d2376d" "/navigation/d25fadfc8e904705b4959db6cb811bff" "/navigation/e83f8e6b0026473a92b92b1924894aa4" "/navigation/33b8c87afef546e5a0c815f29af55c76" "/navigation/4c5c9536e964482abb711b6d6cf09331" "/navigation/e452dc6108fe42daac63c4ff405b7140" "/navigation/aefe682177b74786b3e2e00514a1d495" "/navigation/c2c0cdff39ef4d58a45817b036ee343c" "/navigation/3296c0c6ed32461eb2108a48bdb653d9" "/navigation/c02173051c4c4f88a911ef7ae12636b2" "/navigation/c3139c38f1fe4b7e8e63be2b5a70df0c" "/navigation/cce3ca4207c74d3bba2d26a9af41bad4" "/navigation/788bbed0193446eba2d682f208708e19" "/navigation/07d7b9f97d354f6cbcbcf1ce3c513752" "/navigation/f70e939c2b714cf8b821b101ebcc78c1" "/navigation/1d60553b75e54fd38e046a89fb8f3cee" "/navigation/b94814388860479187ea51351322251c" "/navigation/06eb09f4b3e546518223822bce06b660" "/navigation/50175bce6a524414afdf74d60c125f16" "/navigation/23140fa0c12c40fda6eeece457c1687d" "/navigation/fe13226371f744df99230b7f8b01d392" "/navigation/daf6fb46a12948e6b95b8d7e26cef1fd" "/navigation/72bdf8909ba649578b104c12a95797ed" "/navigation/055e54c680654326a4e54cbe7bc0e800" "/navigation/1ea5fb61ad6a4266860662ef389617bf" "/navigation/8ddab5591e4142f489078b0f4f45ab41" "/navigation/572947278591432c8bba5429dacbed4a" "/navigation/2f22d9ee25854ada85471e3f563ff541" "/navigation/f88ada22b7264cdd8b2e22bc5c649546" "/navigation/965863dd842f45eb877b0ef57f405cd3" "/navigation/de1780efadc84ac199c88c90c4a2c53a" "/navigation/910d26da224a46e58de8c410d759f98b" "/navigation/d74e0de722eb42f29903538efa46a28d" "/navigation/bdc9eb53b4404f5884e98415190cb5cb" "/navigation/ede4477576934c06bad86368b51ebcd2" "/navigation/229ccbcd606c42a7b9c0bbe67b656e88" "/navigation/9fa9b19e8d7a452894542778d027eafe" "/navigation/2a431db7d3884d0aa73b796a207327ec" "/navigation/f0b4e91e24384e6f9f46086002eeb903" "/navigation/c9e0cb49d71847b0bb28c1bd934e8745" "/navigation/027a6ace1dee4120a693597a9f69db4a" "/navigation/3c5669a5f0cf415c8f03121208544adf" "/navigation/ac42c756ead540f894d528a01139e4bc" "/navigation/bca92904513d401ab436988a87170880" "/navigation/24b9415c963b4c8b851c16c436bc3dbb" "/navigation/78f0f26010444a64a8e42cb4ea348c8d" "/navigation/c4f0ce3f3b6b4ee98d75066ab21bb1fd" "/navigation/e6c164ffd9fa4718a7503ff8e205d21c" "/navigation/65b1e4765fb34d6bae5a2fee6f4b8e4c" "/navigation/b8a62dea88a3446ba0467ccb6af9b22e" "/navigation/ba98e2cdcc004c41998121b93ddd8fe5" "/navigation/f75f4de458c144b197933d7b85970cc1" "/navigation/c272ead4d3754ddf90f8bb9d665c7be5" "/navigation/2fb7541c3d234d388a6c1eb45056ec28" "/navigation/68ce8036022e4cafbadaa493785b07fe" "/navigation/a799c9e9aa394b70acb384090f6c0596" "/navigation/0f6675ac5b304d52a71a2a088047ba4a" "/navigation/b90fd51621d94ca195ef7bb0ba6b2084" "/navigation/0f91ac9f43db4ade9bd84a9d54d1a3f9" "/navigation/d2b032c9fce6444d9e69a92f1d4666d5" "/navigation/7eb5f811131e4907bc8295aae8bd052e" "/navigation/5448cb79bbed4eeca15fed20eefcc9c9" "/navigation/42325dc2a8fb42e991808d5554a598a4" "/navigation/0a7988f1b58e4f5e8a3d80ecf1b4072e" "/navigation/af326edf0f1d41f79862f7e2fc51e01e" "/navigation/752e4a8e84084a5fb69555b044d957e1" "/navigation/59eb99a5cbcc45c4b53ebab0af992070" "/navigation/12f4949d7ff6450eb7a3b3be5de54eb2" "/navigation/0c1265370734418ea870ad340efc6e9e" "/navigation/da7fda8af916444ba2caa3b45f5e984e" "/navigation/3c722e32f9534333bdb262be97427fbc" "/navigation/4400c10e3c824079ae65f36b5dadf3d4" "/navigation/93619f18819c4fc3bd335694fbf8e7a2" "/navigation/f46c45e44ae44dde8c5feabd14785767" "/navigation/e5eaa1b00ed44fc9a9dfabf4deec64c6" "/navigation/9f548040c87c45abb13c6fc550597154" "/navigation/d9c792dcb13c44319168d6657be55e03" "/navigation/be389fde4e6447499ee67297b302cb2c" "/navigation/da1ab873bb3e42d88e35d7811a6f99d1" "/navigation/9327bd415ce5495489d6ee6e88f6b4af" "/navigation/ae7040f8a56f419cb094947794ed4447" "/navigation/dfe3e08d3eef4af499a4119afda97fb2" "/navigation/4d4066ab16a748289314cc3c009f2c1a" "/navigation/626e3626c9d34f2bae172c48504469e2" "/navigation/dd83f12302c847d3b646063dcad80648" "/navigation/0747a7d1129d4ebc801333ffc134b347" "/navigation/16c278e8daa94445865088d8558d4829" "/navigation/af04de4482714908b3c508798781c5df" "/navigation/5b922820adfc432b90c1b5f71152bffe" "/navigation/c0e9d3e1eba648a19267f378cc34aafa" "/navigation/805886a34aca4776b4d5b6912a30094d" "/navigation/110d299932ee4740b6468fa738104224" "/navigation/e9e67cceb92949e2954ec4d6a8b2abb6" "/navigation/4e15ea843822403a8cb738207f8db5f1" "/navigation/38fec6db0f774974a5a9fe7ef03b7fad" "/navigation/f5a12e0e3c264ce481b7f7a8e0be8fb6" "/navigation/09d381e5e0684eb283606533c6108f9c" "/navigation/ab4e599c778a4f5a957f06b13ea901f3" "/navigation/63b058aee8fb4a3f85d786bd142af256" "/navigation/85675cf79722416da3bef53dbfddbd92" "/navigation/5a4cfe995bee4f43becb239d625e8dbe" "/navigation/588816670521406db43bce868a6f501e" "/navigation/f179a65bc672499e918a3e32ac2ade70" "/navigation/ae6398d954454f0a971f8c702ee39ca7" "/navigation/cd217f7844224d1b8b3c1cfe4f401b8a" "/navigation/4d4e16aaf08f474296fe06b333b7add5" "/navigation/1233f98a6c614958b32810377a2a5b0b" "/navigation/17bbafb49942466fb68ddb4b1f14ba85" "/navigation/2a7b393a73e24ff2826230829e7db963" "/navigation/e8aee20a38d64819a25b97a5034a4284" "/navigation/dc6c64727f2b4533a5af4bc3423f82d8" "/navigation/3a8072914e274bbeade8b0b2edd74e10" "/navigation/51baee6d63a949e2aeb97652d6295dc8" "/navigation/bd130ee00da0492f9bb6dc84634e78e9" "/navigation/9ed2ffac2a944c8dbd85e2868e8ee7c5" "/navigation/197d628e42a448b3b3e1256622d7385e" "/navigation/18292ff99bc847d6bc684046aa3c76b3" "/navigation/673bf487435e445aa4639e06495d3701" "/navigation/a0363f9ef0cb4400b60fd70165fc6d20" "/navigation/1aead5260ed54a89804687508324c90b" "/navigation/0329360ae2fe4361a986582639dc480b" "/navigation/ada54e8cfb564507951cf4e538acf31e" "/navigation/e1e2c8f3e07643de92428d9292bf1324" "/navigation/23448ae2fc0940d19c1ef8e9f10a6fd0" "/navigation/29e7021e07fa47e593d443ffac54008d" "/navigation/fc9e592f0746439b9c83ef12adcad886" "/navigation/8a51976db67542e6a1af695bf7a1808d" "/navigation/dd3db9f1cce6424fb80cbe546a37b874" "/navigation/626564c53ee840d7b717b09fbf24c4b3" "/navigation/3d7feb94d59c45f6bc39c446796e4cf4" "/navigation/26464ea1a6024393a9e6e0b2a0e1b911" "/navigation/9d46a7f8a2e647f996a7d2508a08f592" "/navigation/d028cef0732f48f9bfc5c07972bf8a9d" "/navigation/bf146c67b5bf4e4991cf07c5f8619af4" "/navigation/8841d395a05b48e0bdcebe58a773b1c7" "/navigation/eb039efb97a7411eb5b1de565c91c2fc" "/navigation/59a2fbe760f147c0978466143e6f11f4" "/navigation/9bf9c3fed2be48bcb7917cf676acb657" "/navigation/cf382bb77c7c44219c7dbbbc4d91e41a" "/navigation/91a2ef29f8124bf5a6e71ba3c1ba9459" "/navigation/c3dfb8f75c744e908e3a45bc30b292ad" "/navigation/77931b53c9714978807e9d2a3ac72680" "/navigation/ac8a30598ef84d508839bb31ee921b9e" "/navigation/e8f6159809fd4ccba72120454420d6fc" "/navigation/0505cf4f10ee4d3e8fb248f4e8ccff82" "/navigation/31cfc357d18945a985f850f3b9e2a376" "/navigation/abac5d370d7b4b62890a4e6bab72e22c" "/navigation/768f4ac260374a7483d0966582bb60f3" "/navigation/1e290f1abeca4e11aeb90439050bb969" "/navigation/bfead05a974a44f2b818bf3aefd5ddea" "/navigation/c7e8e7c81240402faeb2ed12dcc638af" "/navigation/a5d0b2746a7d47768f21f819407112f4" "/navigation/ec2990e5d5b44aa38371aac2a6f3206d" "/navigation/315d3b9de762443f8990d2a7a0a4d9ef" "/navigation/3c9e4141ad704780b44959a56fa80d38" "/navigation/e77eff9d85ea4a16b6b895625033dcd6" "/navigation/179366377332478bb1b0603844f6de7d" "/navigation/1a7b205de12742e79c80352a26b389b3" "/navigation/0ec21d0040e14848bdd4a5c512d1a4a1" "/navigation/48f929082ed047cfbed44c399a9b1071" "/navigation/e96215cff3504025b2ceba9b20ba51a6" "/navigation/c573f404182841cfba7f0aa195a06e59" "/navigation/91010439dfb644e289e55813fe88081c" "/navigation/67403f3103e34995a84a44527b538d45" "/navigation/a1dc986abe88459b88b42e9ff412fc0d" "/navigation/c4a001e98c7e4ccc8182bcc123fd9ca6" "/navigation/4af289479b544de1b55377b02f751e3e" "/navigation/d65d5c9725e74c2a9872ed8e9067476a" "/navigation/378783a99c3f470eb7f499011370c274" "/navigation/c76a50264721447db5473ec51ef8d46d" "/detail/1c8f8e89f3b94e25b426d4425fc5f91a" "/navigation/9674edf1aa2344cdac6da9f6059dbdd4" "/navigation/e77003e52a14431fbbbf7e63ea954d4b" "/navigation/c1ec60dc3e6940639878caa03272ab36" "/navigation/26496f1dec42456abb7283ccf4de04e4" "/navigation/819c048b0c0649a788d8d259eb5d2b5d" "/navigation/a8d403d8f67e47babec97802cda8f5b6" "/navigation/de6f5cb156e649bd95d190f2e6689940" "/navigation/8c32a91ffa884a8b924fc00e88a9bd79" "/navigation/ad76a6f403a24990beca20ab8d46880a" "/navigation/56bc15133d2d45e8afee0cade3e017e8" "/navigation/d30159bdf31246e89ca11096abeb8a33" "/navigation/28df0b5a1f7543baa7039cebca65bbc6" "/navigation/c9283e1764f04de2920e08f472af4ced" "/navigation/6163b0876d8d4635860633f0d00c229f" "/navigation/c5ab985875e64d48a4afe610a6625b5f" "/navigation/5ccacc70f904450090489810062542af" "/navigation/86a313e2f88843388aeaeb26d650b685" "/navigation/4ad978e5298c45cd96021c57737fd11a" "/navigation/36c81c8f97b64858b32ca8398ce1cd38" "/navigation/61f137c8b1a64476875917a59b36851c" "/navigation/03c97419c8d1421f92e7d405cec3bd7f" "/navigation/11746a8774534e628f43bb79bee26bfd" "/navigation/2efeaed9ace0484fb1b519779c45983e" "/navigation/fbbb8fb06bf54f43a695acd484176e3c" "/navigation/90f1153a5ca54b649f0c461170ca5e84" "/navigation/9b28fc9807964d89b14336d8013a7058" "/navigation/97d4a5efab714969ba74cc3a6951fbe4" "/navigation/a0fa5c78dd954cf0a42c3270c74d1341" "/navigation/2474cefd55794526a03332db1cb12b1a" "/navigation/9a6e6ff40a0c4f24937699e80356f90f" "/navigation/ddfe94acbb6b4d8fbab51da5646866b8" "/navigation/404d144a31664f47b732e1f907dad118" "/navigation/e9e14393919446bcba9adff50f6c6512" "/navigation/f7236d6aa7dc497da73c5311255fd4b5" b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"\x0FÎe³¿<JE»AVó“Ô5õ" ] |
||||||||||||||||||
4.66 ms (3.65%) |
3 |
SELECT LOWER(HEX(`category`.`parent_id`)) as `category-ids.key`, COUNT(`category`.`id`) as `category-ids.count`, COUNT(DISTINCT `category`.`id`) as `visible-children-count` FROM `category` WHERE (`category`.`version_id` = ?) AND ((`category`.`path` LIKE ? AND `category`.`level` = ? AND `category`.`active` = ? AND `category`.`visible` = ?)) GROUP BY `category`.`parent_id`
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" "%|c81f275613694bb28c5c3c394412ebde|%" 5 true true ] |
||||||||||||||||||
4.25 ms (3.32%) |
1 |
SELECT translation_key, value FROM snippet WHERE snippet_set_id = ?
Parameters:
[
b"÷BsÆq¾I¾Œ:vC><Bè"
]
|
||||||||||||||||||
3.88 ms (3.04%) |
3 |
# header::navigation::read SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.override_1.title`, `category.media.translation.title`, COALESCE(`category.media.translation.override_1.title`,`category.media.translation.title`) as `category.media.title`, `category.media.translation.override_1.alt`, `category.media.translation.alt`, COALESCE(`category.media.translation.override_1.alt`,`category.media.translation.alt`) as `category.media.alt`, `category.media.translation.override_1.customFields`, `category.media.translation.customFields`, COALESCE(`category.media.translation.override_1.customFields`,`category.media.translation.customFields`) as `category.media.customFields`, `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 `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation.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` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation.override_1`.`alt` as `category.media.translation.override_1.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation.override_1`.`title` as `category.media.translation.override_1.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields`, `category.media.translation.override_1`.`custom_fields` as `category.media.translation.override_1.customFields` FROM `media_translation` `category.media.translation` LEFT JOIN `media_translation` `category.media.translation.override_1` ON `category.media.translation`.`media_id` = `category.media.translation.override_1`.`media_id` AND `category.media.translation.override_1`.`language_id` = ? WHERE `category.media.translation`.`language_id` = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters:
[ b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"È\x1F'V\x13iK²Œ\<9D\x12ëÞ" ] |
||||||||||||||||||
3.10 ms (2.42%) |
4 |
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`checkout_gateway_url` as `app.checkoutGatewayUrl`, `app`.`in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl`, `app`.`source_type` as `app.sourceType`, `app`.`source_config` as `app.sourceConfig`, `app`.`self_managed` as `app.selfManaged`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, `app.translation.label` as `app.label`, `app.translation.description`, `app.translation.description` as `app.description`, `app.translation.privacyPolicyExtensions`, `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`, `app.translation.customFields`, `app.translation.customFields` as `app.customFields` FROM `app` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` LEFT JOIN (SELECT `app.translation`.`app_id`, `app.translation`.`label` as `app.translation.label`, `app.translation`.`description` as `app.translation.description`, `app.translation`.`privacy_policy_extensions` as `app.translation.privacyPolicyExtensions`, `app.translation`.`custom_fields` as `app.translation.customFields` FROM `app_translation` `app.translation` WHERE `app.translation`.`language_id` = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` WHERE (`app`.`name` = ?)
Parameters:
[ b"!ä\rp¸eI*«ó\v|‰!¥Ð" "ComanConsentManagerC" ] |
||||||||||||||||||
2.84 ms (2.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.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`.`parent_id` = ? AND `category`.`active` = ?))
Parameters:
[ b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"·NÜâé>NA¸\x19CQAÿ\x15’" 1 ] |
||||||||||||||||||
2.69 ms (2.11%) |
1 |
# base-context-factory::sales-channel::read SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.currency`.`id` as `sales_channel.currency.id`, `sales_channel.currency`.`factor` as `sales_channel.currency.factor`, `sales_channel.currency`.`symbol` as `sales_channel.currency.symbol`, `sales_channel.currency`.`iso_code` as `sales_channel.currency.isoCode`, `sales_channel.currency`.`position` as `sales_channel.currency.position`, `sales_channel.currency`.`tax_free_from` as `sales_channel.currency.taxFreeFrom`, `sales_channel.currency`.`item_rounding` as `sales_channel.currency.itemRounding`, `sales_channel.currency`.`total_rounding` as `sales_channel.currency.totalRounding`, `sales_channel.currency`.`created_at` as `sales_channel.currency.createdAt`, `sales_channel.currency`.`updated_at` as `sales_channel.currency.updatedAt`, `sales_channel.currency.translation.override_1.shortName`, `sales_channel.currency.translation.shortName`, COALESCE(`sales_channel.currency.translation.override_1.shortName`,`sales_channel.currency.translation.shortName`) as `sales_channel.currency.shortName`, `sales_channel.currency.translation.override_1.name`, `sales_channel.currency.translation.name`, COALESCE(`sales_channel.currency.translation.override_1.name`,`sales_channel.currency.translation.name`) as `sales_channel.currency.name`, `sales_channel.currency.translation.override_1.customFields`, `sales_channel.currency.translation.customFields`, COALESCE(`sales_channel.currency.translation.override_1.customFields`,`sales_channel.currency.translation.customFields`) as `sales_channel.currency.customFields`, `sales_channel.translation.override_1.name`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.override_1.name`,`sales_channel.translation.name`) as `sales_channel.name`, `sales_channel.translation.override_1.homeSlotConfig`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.override_1.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_channel.homeSlotConfig`, `sales_channel.translation.override_1.homeEnabled`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.override_1.homeEnabled`,`sales_channel.translation.homeEnabled`) as `sales_channel.homeEnabled`, `sales_channel.translation.override_1.homeName`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.override_1.homeName`,`sales_channel.translation.homeName`) as `sales_channel.homeName`, `sales_channel.translation.override_1.homeMetaTitle`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.override_1.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, `sales_channel.translation.override_1.homeMetaDescription`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.override_1.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) as `sales_channel.homeMetaDescription`, `sales_channel.translation.override_1.homeKeywords`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.override_1.homeKeywords`,`sales_channel.translation.homeKeywords`) as `sales_channel.homeKeywords`, `sales_channel.translation.override_1.customFields`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.override_1.customFields`,`sales_channel.translation.customFields`) as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel`.`currency_id` = `sales_channel.currency`.`id` LEFT JOIN (SELECT `sales_channel.translation`.`sales_channel_id`, `sales_channel.translation`.`name` as `sales_channel.translation.name`, `sales_channel.translation.override_1`.`name` as `sales_channel.translation.override_1.name`, `sales_channel.translation`.`custom_fields` as `sales_channel.translation.customFields`, `sales_channel.translation.override_1`.`custom_fields` as `sales_channel.translation.override_1.customFields`, `sales_channel.translation`.`home_slot_config` as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation.override_1`.`home_slot_config` as `sales_channel.translation.override_1.homeSlotConfig`, `sales_channel.translation`.`home_enabled` as `sales_channel.translation.homeEnabled`, `sales_channel.translation.override_1`.`home_enabled` as `sales_channel.translation.override_1.homeEnabled`, `sales_channel.translation`.`home_name` as `sales_channel.translation.homeName`, `sales_channel.translation.override_1`.`home_name` as `sales_channel.translation.override_1.homeName`, `sales_channel.translation`.`home_meta_title` as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation.override_1`.`home_meta_title` as `sales_channel.translation.override_1.homeMetaTitle`, `sales_channel.translation`.`home_meta_description` as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation.override_1`.`home_meta_description` as `sales_channel.translation.override_1.homeMetaDescription`, `sales_channel.translation`.`home_keywords` as `sales_channel.translation.homeKeywords`, `sales_channel.translation.override_1`.`home_keywords` as `sales_channel.translation.override_1.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` LEFT JOIN `sales_channel_translation` `sales_channel.translation.override_1` ON `sales_channel.translation`.`sales_channel_id` = `sales_channel.translation.override_1`.`sales_channel_id` AND `sales_channel.translation.override_1`.`language_id` = ? WHERE `sales_channel.translation`.`language_id` = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` LEFT JOIN (SELECT `sales_channel.currency.translation`.`currency_id`, `sales_channel.currency.translation`.`short_name` as `sales_channel.currency.translation.shortName`, `sales_channel.currency.translation.override_1`.`short_name` as `sales_channel.currency.translation.override_1.shortName`, `sales_channel.currency.translation`.`name` as `sales_channel.currency.translation.name`, `sales_channel.currency.translation.override_1`.`name` as `sales_channel.currency.translation.override_1.name`, `sales_channel.currency.translation`.`custom_fields` as `sales_channel.currency.translation.customFields`, `sales_channel.currency.translation.override_1`.`custom_fields` as `sales_channel.currency.translation.override_1.customFields` FROM `currency_translation` `sales_channel.currency.translation` LEFT JOIN `currency_translation` `sales_channel.currency.translation.override_1` ON `sales_channel.currency.translation`.`currency_id` = `sales_channel.currency.translation.override_1`.`currency_id` AND `sales_channel.currency.translation.override_1`.`language_id` = ? WHERE `sales_channel.currency.translation`.`language_id` = ?) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation`.`currency_id` = `sales_channel.currency`.`id` WHERE `sales_channel`.`id` IN (?)
Parameters:
[ b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"\x0FÎe³¿<JE»AVó“Ô5õ" ] |
||||||||||||||||||
2.17 ms (1.70%) |
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:
[ "/" "" "" "/" "" "/" "" true null null ] |
||||||||||||||||||
2.16 ms (1.69%) |
3 |
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`checkout_gateway_url` as `app.checkoutGatewayUrl`, `app`.`in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl`, `app`.`source_type` as `app.sourceType`, `app`.`source_config` as `app.sourceConfig`, `app`.`self_managed` as `app.selfManaged`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, `app.translation.label` as `app.label`, `app.translation.description`, `app.translation.description` as `app.description`, `app.translation.privacyPolicyExtensions`, `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`, `app.translation.customFields`, `app.translation.customFields` as `app.customFields` FROM `app` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` LEFT JOIN (SELECT `app.translation`.`app_id`, `app.translation`.`label` as `app.translation.label`, `app.translation`.`description` as `app.translation.description`, `app.translation`.`privacy_policy_extensions` as `app.translation.privacyPolicyExtensions`, `app.translation`.`custom_fields` as `app.translation.customFields` FROM `app_translation` `app.translation` WHERE `app.translation`.`language_id` = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` WHERE `app`.`id` IN (?)
Parameters:
[ b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"\x01É5¥├Ôqñê■óðkú┬x" ] |
||||||||||||||||||
2.00 ms (1.57%) |
1 |
# base-context-factory::taxes::association::rules::read SELECT `tax_rule`.`id` as `tax_rule.id`, `tax_rule`.`tax_rule_type_id` as `tax_rule.taxRuleTypeId`, `tax_rule`.`country_id` as `tax_rule.countryId`, `tax_rule`.`tax_rate` as `tax_rule.taxRate`, `tax_rule`.`data` as `tax_rule.data`, `tax_rule`.`tax_id` as `tax_rule.taxId`, `tax_rule`.`active_from` as `tax_rule.activeFrom`, `tax_rule`.`created_at` as `tax_rule.createdAt`, `tax_rule`.`updated_at` as `tax_rule.updatedAt`, `tax_rule.type`.`id` as `tax_rule.type.id`, `tax_rule.type`.`technical_name` as `tax_rule.type.technicalName`, `tax_rule.type`.`position` as `tax_rule.type.position`, `tax_rule.type`.`created_at` as `tax_rule.type.createdAt`, `tax_rule.type`.`updated_at` as `tax_rule.type.updatedAt`, `tax_rule.type.translation.override_1.typeName`, `tax_rule.type.translation.typeName`, COALESCE(`tax_rule.type.translation.override_1.typeName`,`tax_rule.type.translation.typeName`) as `tax_rule.type.typeName` FROM `tax_rule` LEFT JOIN `tax_rule_type` `tax_rule.type` ON `tax_rule`.`tax_rule_type_id` = `tax_rule.type`.`id` LEFT JOIN (SELECT `tax_rule.type.translation`.`tax_rule_type_id`, `tax_rule.type.translation`.`type_name` as `tax_rule.type.translation.typeName`, `tax_rule.type.translation.override_1`.`type_name` as `tax_rule.type.translation.override_1.typeName` FROM `tax_rule_type_translation` `tax_rule.type.translation` LEFT JOIN `tax_rule_type_translation` `tax_rule.type.translation.override_1` ON `tax_rule.type.translation`.`tax_rule_type_id` = `tax_rule.type.translation.override_1`.`tax_rule_type_id` AND `tax_rule.type.translation.override_1`.`language_id` = ? WHERE `tax_rule.type.translation`.`language_id` = ?) `tax_rule.type.tax_rule_type_translation` ON `tax_rule.type.tax_rule_type_translation`.`tax_rule_type_id` = `tax_rule.type`.`id` WHERE (`tax_rule`.`tax_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters:
[ b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"\x1E\x7F\x136É~MÖÑæ*S:\x1C\x1FÛ" b"7©\x1Aùr+IþŒ_ÃQ‘CPÁ" b"Vü0ø„¦MÈ«UŠÀ\x7FGt‚" b""" s›£OÃÃKʱÎ\n ”€Éäs """ b"™0KX+|HŸ¯\x02‘Ç÷\x19§‚" b"ú┴tB┌ðD¸Ø\x1CO┤┼÷ó¤" b"«>‚\x1CÄhN(¿\x0F³q¡ÛžÚ" b"¼õ&y\x13!OÞ╣ìƒ÷Ëíav" b"ÇÌœg’C@ŸÊ«÷J©?Z" b"×áì…×íN˸ï‹H\x14)jª" b"õ§×s-ê@M¿\x7FÏEî5by" b"²l'\x112oE¼Ø'é±Â╔ë\x15" ] |
||||||||||||||||||
1.98 ms (1.55%) |
3 |
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"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" ] |
||||||||||||||||||
1.76 ms (1.38%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id = ? OR system_config.sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[
b"\x0FÎe³¿<JE»AVó“Ô5õ"
]
|
||||||||||||||||||
1.71 ms (1.34%) |
1 |
# generic-page::shipping-methods::read SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`active` as `shipping_method.active`, `shipping_method`.`position` as `shipping_method.position`, `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` as `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` as `shipping_method.taxType`, `shipping_method`.`tax_id` as `shipping_method.taxId`, `shipping_method.deliveryTime`.`id` as `shipping_method.deliveryTime.id`, `shipping_method.deliveryTime`.`min` as `shipping_method.deliveryTime.min`, `shipping_method.deliveryTime`.`max` as `shipping_method.deliveryTime.max`, `shipping_method.deliveryTime`.`unit` as `shipping_method.deliveryTime.unit`, `shipping_method.deliveryTime`.`created_at` as `shipping_method.deliveryTime.createdAt`, `shipping_method.deliveryTime`.`updated_at` as `shipping_method.deliveryTime.updatedAt`, `shipping_method.deliveryTime.translation.override_1.name`, `shipping_method.deliveryTime.translation.name`, COALESCE(`shipping_method.deliveryTime.translation.override_1.name`,`shipping_method.deliveryTime.translation.name`) as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.override_1.customFields`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.override_1.customFields`,`shipping_method.deliveryTime.translation.customFields`) as `shipping_method.deliveryTime.customFields`, `shipping_method.appShippingMethod`.`id` as `shipping_method.appShippingMethod.id`, `shipping_method.appShippingMethod`.`app_name` as `shipping_method.appShippingMethod.appName`, `shipping_method.appShippingMethod`.`identifier` as `shipping_method.appShippingMethod.identifier`, `shipping_method.appShippingMethod`.`app_id` as `shipping_method.appShippingMethod.appId`, `shipping_method.appShippingMethod`.`shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId`, `shipping_method.appShippingMethod`.`original_media_id` as `shipping_method.appShippingMethod.originalMediaId`, `shipping_method.appShippingMethod`.`created_at` as `shipping_method.appShippingMethod.createdAt`, `shipping_method.appShippingMethod`.`updated_at` as `shipping_method.appShippingMethod.updatedAt`, `shipping_method`.`technical_name` as `shipping_method.technicalName`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.media`.`id` as `shipping_method.media.id`, `shipping_method.media`.`user_id` as `shipping_method.media.userId`, `shipping_method.media`.`media_folder_id` as `shipping_method.media.mediaFolderId`, `shipping_method.media`.`mime_type` as `shipping_method.media.mimeType`, `shipping_method.media`.`file_extension` as `shipping_method.media.fileExtension`, `shipping_method.media`.`uploaded_at` as `shipping_method.media.uploadedAt`, `shipping_method.media`.`file_name` as `shipping_method.media.fileName`, `shipping_method.media`.`file_size` as `shipping_method.media.fileSize`, `shipping_method.media`.`media_type` as `shipping_method.media.mediaTypeRaw`, `shipping_method.media`.`meta_data` as `shipping_method.media.metaData`, `shipping_method.media`.`config` as `shipping_method.media.config`, `shipping_method.media`.`path` as `shipping_method.media.path`, `shipping_method.media`.`private` as `shipping_method.media.private`, `shipping_method.media`.`thumbnails_ro` as `shipping_method.media.thumbnailsRo`, `shipping_method.media`.`created_at` as `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`, `shipping_method.media.translation.override_1.title`, `shipping_method.media.translation.title`, COALESCE(`shipping_method.media.translation.override_1.title`,`shipping_method.media.translation.title`) as `shipping_method.media.title`, `shipping_method.media.translation.override_1.alt`, `shipping_method.media.translation.alt`, COALESCE(`shipping_method.media.translation.override_1.alt`,`shipping_method.media.translation.alt`) as `shipping_method.media.alt`, `shipping_method.media.translation.override_1.customFields`, `shipping_method.media.translation.customFields`, COALESCE(`shipping_method.media.translation.override_1.customFields`,`shipping_method.media.translation.customFields`) as `shipping_method.media.customFields`, `shipping_method.translation.override_1.name`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.override_1.name`,`shipping_method.translation.name`) as `shipping_method.name`, `shipping_method.translation.override_1.description`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.override_1.description`,`shipping_method.translation.description`) as `shipping_method.description`, `shipping_method.translation.override_1.trackingUrl`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.override_1.trackingUrl`,`shipping_method.translation.trackingUrl`) as `shipping_method.trackingUrl`, `shipping_method.translation.override_1.customFields`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.override_1.customFields`,`shipping_method.translation.customFields`) as `shipping_method.customFields` FROM `shipping_method` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method`.`id` = `shipping_method.appShippingMethod`.`shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name`, `shipping_method.translation.override_1`.`name` as `shipping_method.translation.override_1.name`, `shipping_method.translation`.`custom_fields` as `shipping_method.translation.customFields`, `shipping_method.translation.override_1`.`custom_fields` as `shipping_method.translation.override_1.customFields`, `shipping_method.translation`.`description` as `shipping_method.translation.description`, `shipping_method.translation.override_1`.`description` as `shipping_method.translation.override_1.description`, `shipping_method.translation`.`tracking_url` as `shipping_method.translation.trackingUrl`, `shipping_method.translation.override_1`.`tracking_url` as `shipping_method.translation.override_1.trackingUrl` FROM `shipping_method_translation` `shipping_method.translation` LEFT JOIN `shipping_method_translation` `shipping_method.translation.override_1` ON `shipping_method.translation`.`shipping_method_id` = `shipping_method.translation.override_1`.`shipping_method_id` AND `shipping_method.translation.override_1`.`language_id` = ? WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation`.`delivery_time_id`, `shipping_method.deliveryTime.translation`.`name` as `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation.override_1`.`name` as `shipping_method.deliveryTime.translation.override_1.name`, `shipping_method.deliveryTime.translation`.`custom_fields` as `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation.override_1`.`custom_fields` as `shipping_method.deliveryTime.translation.override_1.customFields` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` LEFT JOIN `delivery_time_translation` `shipping_method.deliveryTime.translation.override_1` ON `shipping_method.deliveryTime.translation`.`delivery_time_id` = `shipping_method.deliveryTime.translation.override_1`.`delivery_time_id` AND `shipping_method.deliveryTime.translation.override_1`.`language_id` = ? WHERE `shipping_method.deliveryTime.translation`.`language_id` = ?) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.`media_id`, `shipping_method.media.translation`.`alt` as `shipping_method.media.translation.alt`, `shipping_method.media.translation.override_1`.`alt` as `shipping_method.media.translation.override_1.alt`, `shipping_method.media.translation`.`title` as `shipping_method.media.translation.title`, `shipping_method.media.translation.override_1`.`title` as `shipping_method.media.translation.override_1.title`, `shipping_method.media.translation`.`custom_fields` as `shipping_method.media.translation.customFields`, `shipping_method.media.translation.override_1`.`custom_fields` as `shipping_method.media.translation.override_1.customFields` FROM `media_translation` `shipping_method.media.translation` LEFT JOIN `media_translation` `shipping_method.media.translation.override_1` ON `shipping_method.media.translation`.`media_id` = `shipping_method.media.translation.override_1`.`media_id` AND `shipping_method.media.translation.override_1`.`language_id` = ? WHERE `shipping_method.media.translation`.`language_id` = ?) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (?, ?)
Parameters:
[ b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"\x11└■ø×IJÅöõ\x1C£±5Y\x10" b"AÈs\x00²áKù·98(&ÊU)" ] |
||||||||||||||||||
1.70 ms (1.33%) |
2 |
# theme-service::load-config::read SELECT `theme`.`id` as `theme.id`, `theme`.`technical_name` as `theme.technicalName`, `theme`.`name` as `theme.name`, `theme`.`author` as `theme.author`, `theme`.`preview_media_id` as `theme.previewMediaId`, `theme`.`parent_theme_id` as `theme.parentThemeId`, `theme`.`theme_json` as `theme.themeJson`, `theme`.`base_config` as `theme.baseConfig`, `theme`.`config_values` as `theme.configValues`, `theme`.`active` as `theme.active`, `theme`.`created_at` as `theme.createdAt`, `theme`.`updated_at` as `theme.updatedAt`, `theme.translation.override_1.description`, `theme.translation.description`, COALESCE(`theme.translation.override_1.description`,`theme.translation.description`) as `theme.description`, `theme.translation.override_1.labels`, `theme.translation.labels`, COALESCE(`theme.translation.override_1.labels`,`theme.translation.labels`) as `theme.labels`, `theme.translation.override_1.helpTexts`, `theme.translation.helpTexts`, COALESCE(`theme.translation.override_1.helpTexts`,`theme.translation.helpTexts`) as `theme.helpTexts`, `theme.translation.override_1.customFields`, `theme.translation.customFields`, COALESCE(`theme.translation.override_1.customFields`,`theme.translation.customFields`) as `theme.customFields` FROM `theme` LEFT JOIN (SELECT `theme.translation`.`theme_id`, `theme.translation`.`description` as `theme.translation.description`, `theme.translation.override_1`.`description` as `theme.translation.override_1.description`, `theme.translation`.`labels` as `theme.translation.labels`, `theme.translation.override_1`.`labels` as `theme.translation.override_1.labels`, `theme.translation`.`help_texts` as `theme.translation.helpTexts`, `theme.translation.override_1`.`help_texts` as `theme.translation.override_1.helpTexts`, `theme.translation`.`custom_fields` as `theme.translation.customFields`, `theme.translation.override_1`.`custom_fields` as `theme.translation.override_1.customFields` FROM `theme_translation` `theme.translation` LEFT JOIN `theme_translation` `theme.translation.override_1` ON `theme.translation`.`theme_id` = `theme.translation.override_1`.`theme_id` AND `theme.translation.override_1`.`language_id` = ? WHERE `theme.translation`.`language_id` = ?) `theme.theme_translation` ON `theme.theme_translation`.`theme_id` = `theme`.`id`
Parameters:
[ b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" ] |
||||||||||||||||||
1.53 ms (1.20%) |
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:
[ "//it/feedback/list" "/it/feedback/list" "https://swdev.biotikon.de/it/feedback/list" "https://swdev.biotikon.de//it/feedback/list" "/it/feedback/list" "//it/feedback/list" "it/feedback/list" true b"\x0FÎe³¿<JE»AVó“Ô5õ" null ] |
||||||||||||||||||
1.50 ms (1.17%) |
1 |
# generic-page::payment-methods::read SELECT `payment_method`.`id` as `payment_method.id`, `payment_method`.`plugin_id` as `payment_method.pluginId`, `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`, `payment_method`.`position` as `payment_method.position`, `payment_method`.`active` as `payment_method.active`, `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`, `payment_method`.`media_id` as `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` as `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` as `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` as `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`recurring_url` as `payment_method.appPaymentMethod.recurringUrl`, `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`, `payment_method`.`technical_name` as `payment_method.technicalName`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `payment_method.media`.`id` as `payment_method.media.id`, `payment_method.media`.`user_id` as `payment_method.media.userId`, `payment_method.media`.`media_folder_id` as `payment_method.media.mediaFolderId`, `payment_method.media`.`mime_type` as `payment_method.media.mimeType`, `payment_method.media`.`file_extension` as `payment_method.media.fileExtension`, `payment_method.media`.`uploaded_at` as `payment_method.media.uploadedAt`, `payment_method.media`.`file_name` as `payment_method.media.fileName`, `payment_method.media`.`file_size` as `payment_method.media.fileSize`, `payment_method.media`.`media_type` as `payment_method.media.mediaTypeRaw`, `payment_method.media`.`meta_data` as `payment_method.media.metaData`, `payment_method.media`.`config` as `payment_method.media.config`, `payment_method.media`.`path` as `payment_method.media.path`, `payment_method.media`.`private` as `payment_method.media.private`, `payment_method.media`.`thumbnails_ro` as `payment_method.media.thumbnailsRo`, `payment_method.media`.`created_at` as `payment_method.media.createdAt`, `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`, `payment_method.media.translation.override_1.title`, `payment_method.media.translation.title`, COALESCE(`payment_method.media.translation.override_1.title`,`payment_method.media.translation.title`) as `payment_method.media.title`, `payment_method.media.translation.override_1.alt`, `payment_method.media.translation.alt`, COALESCE(`payment_method.media.translation.override_1.alt`,`payment_method.media.translation.alt`) as `payment_method.media.alt`, `payment_method.media.translation.override_1.customFields`, `payment_method.media.translation.customFields`, COALESCE(`payment_method.media.translation.override_1.customFields`,`payment_method.media.translation.customFields`) as `payment_method.media.customFields`, `payment_method.translation.override_1.name`, `payment_method.translation.name`, COALESCE(`payment_method.translation.override_1.name`,`payment_method.translation.name`) as `payment_method.name`, `payment_method.translation.override_1.distinguishableName`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.override_1.distinguishableName`,`payment_method.translation.distinguishableName`) as `payment_method.distinguishableName`, `payment_method.translation.override_1.description`, `payment_method.translation.description`, COALESCE(`payment_method.translation.override_1.description`,`payment_method.translation.description`) as `payment_method.description`, `payment_method.translation.override_1.customFields`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.override_1.customFields`,`payment_method.translation.customFields`) as `payment_method.customFields` FROM `payment_method` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.translation`.`payment_method_id`, `payment_method.translation`.`name` as `payment_method.translation.name`, `payment_method.translation.override_1`.`name` as `payment_method.translation.override_1.name`, `payment_method.translation`.`distinguishable_name` as `payment_method.translation.distinguishableName`, `payment_method.translation.override_1`.`distinguishable_name` as `payment_method.translation.override_1.distinguishableName`, `payment_method.translation`.`description` as `payment_method.translation.description`, `payment_method.translation.override_1`.`description` as `payment_method.translation.override_1.description`, `payment_method.translation`.`custom_fields` as `payment_method.translation.customFields`, `payment_method.translation.override_1`.`custom_fields` as `payment_method.translation.override_1.customFields` FROM `payment_method_translation` `payment_method.translation` LEFT JOIN `payment_method_translation` `payment_method.translation.override_1` ON `payment_method.translation`.`payment_method_id` = `payment_method.translation.override_1`.`payment_method_id` AND `payment_method.translation.override_1`.`language_id` = ? WHERE `payment_method.translation`.`language_id` = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.`media_id`, `payment_method.media.translation`.`alt` as `payment_method.media.translation.alt`, `payment_method.media.translation.override_1`.`alt` as `payment_method.media.translation.override_1.alt`, `payment_method.media.translation`.`title` as `payment_method.media.translation.title`, `payment_method.media.translation.override_1`.`title` as `payment_method.media.translation.override_1.title`, `payment_method.media.translation`.`custom_fields` as `payment_method.media.translation.customFields`, `payment_method.media.translation.override_1`.`custom_fields` as `payment_method.media.translation.override_1.customFields` FROM `media_translation` `payment_method.media.translation` LEFT JOIN `media_translation` `payment_method.media.translation.override_1` ON `payment_method.media.translation`.`media_id` = `payment_method.media.translation.override_1`.`media_id` AND `payment_method.media.translation.override_1`.`language_id` = ? WHERE `payment_method.media.translation`.`language_id` = ?) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"^Ñ8‘qN{‹I``†}ÈP" b"\x01æOÅe³pþûøóýK#H8" b"\x01‘ZÄ\ x5ƒ›/ÌÛÑ…" b"\x1C'¸\r└ëMMáhúÇÙØCÊ" b"I‗µØ\x11EA4╝é$\x1E\x06\x1FFO" b"•\x0Fq‰ÎÒD=¿‰7 …óõ=" b"Çü»²¡ZH\x0EëÞHs─)H¸" b"/\x06S}¥\x13FU¦ý2»·8ž¸" ] |
||||||||||||||||||
1.48 ms (1.15%) |
3 |
# navigation-route::meta-information SELECT LOWER(HEX(`id`)), `path`, `level` FROM `category` WHERE `id` = ? OR `parent_id` = ? OR `id` = ?
Parameters:
[ b"È\x1F'V\x13iK²Œ\<9D\x12ëÞ" b"È\x1F'V\x13iK²Œ\<9D\x12ëÞ" b"È\x1F'V\x13iK²Œ\<9D\x12ëÞ" ] |
||||||||||||||||||
1.46 ms (1.14%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[] |
||||||||||||||||||
1.46 ms (1.14%) |
1 |
# base-context-factory::shipping-method::read SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`active` as `shipping_method.active`, `shipping_method`.`position` as `shipping_method.position`, `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` as `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` as `shipping_method.taxType`, `shipping_method`.`tax_id` as `shipping_method.taxId`, `shipping_method.deliveryTime`.`id` as `shipping_method.deliveryTime.id`, `shipping_method.deliveryTime`.`min` as `shipping_method.deliveryTime.min`, `shipping_method.deliveryTime`.`max` as `shipping_method.deliveryTime.max`, `shipping_method.deliveryTime`.`unit` as `shipping_method.deliveryTime.unit`, `shipping_method.deliveryTime`.`created_at` as `shipping_method.deliveryTime.createdAt`, `shipping_method.deliveryTime`.`updated_at` as `shipping_method.deliveryTime.updatedAt`, `shipping_method.deliveryTime.translation.override_1.name`, `shipping_method.deliveryTime.translation.name`, COALESCE(`shipping_method.deliveryTime.translation.override_1.name`,`shipping_method.deliveryTime.translation.name`) as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.override_1.customFields`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.override_1.customFields`,`shipping_method.deliveryTime.translation.customFields`) as `shipping_method.deliveryTime.customFields`, `shipping_method.appShippingMethod`.`id` as `shipping_method.appShippingMethod.id`, `shipping_method.appShippingMethod`.`app_name` as `shipping_method.appShippingMethod.appName`, `shipping_method.appShippingMethod`.`identifier` as `shipping_method.appShippingMethod.identifier`, `shipping_method.appShippingMethod`.`app_id` as `shipping_method.appShippingMethod.appId`, `shipping_method.appShippingMethod`.`shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId`, `shipping_method.appShippingMethod`.`original_media_id` as `shipping_method.appShippingMethod.originalMediaId`, `shipping_method.appShippingMethod`.`created_at` as `shipping_method.appShippingMethod.createdAt`, `shipping_method.appShippingMethod`.`updated_at` as `shipping_method.appShippingMethod.updatedAt`, `shipping_method`.`technical_name` as `shipping_method.technicalName`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.media`.`id` as `shipping_method.media.id`, `shipping_method.media`.`user_id` as `shipping_method.media.userId`, `shipping_method.media`.`media_folder_id` as `shipping_method.media.mediaFolderId`, `shipping_method.media`.`mime_type` as `shipping_method.media.mimeType`, `shipping_method.media`.`file_extension` as `shipping_method.media.fileExtension`, `shipping_method.media`.`uploaded_at` as `shipping_method.media.uploadedAt`, `shipping_method.media`.`file_name` as `shipping_method.media.fileName`, `shipping_method.media`.`file_size` as `shipping_method.media.fileSize`, `shipping_method.media`.`media_type` as `shipping_method.media.mediaTypeRaw`, `shipping_method.media`.`meta_data` as `shipping_method.media.metaData`, `shipping_method.media`.`config` as `shipping_method.media.config`, `shipping_method.media`.`path` as `shipping_method.media.path`, `shipping_method.media`.`private` as `shipping_method.media.private`, `shipping_method.media`.`thumbnails_ro` as `shipping_method.media.thumbnailsRo`, `shipping_method.media`.`created_at` as `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`, `shipping_method.media.translation.override_1.title`, `shipping_method.media.translation.title`, COALESCE(`shipping_method.media.translation.override_1.title`,`shipping_method.media.translation.title`) as `shipping_method.media.title`, `shipping_method.media.translation.override_1.alt`, `shipping_method.media.translation.alt`, COALESCE(`shipping_method.media.translation.override_1.alt`,`shipping_method.media.translation.alt`) as `shipping_method.media.alt`, `shipping_method.media.translation.override_1.customFields`, `shipping_method.media.translation.customFields`, COALESCE(`shipping_method.media.translation.override_1.customFields`,`shipping_method.media.translation.customFields`) as `shipping_method.media.customFields`, `shipping_method.translation.override_1.name`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.override_1.name`,`shipping_method.translation.name`) as `shipping_method.name`, `shipping_method.translation.override_1.description`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.override_1.description`,`shipping_method.translation.description`) as `shipping_method.description`, `shipping_method.translation.override_1.trackingUrl`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.override_1.trackingUrl`,`shipping_method.translation.trackingUrl`) as `shipping_method.trackingUrl`, `shipping_method.translation.override_1.customFields`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.override_1.customFields`,`shipping_method.translation.customFields`) as `shipping_method.customFields` FROM `shipping_method` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method`.`id` = `shipping_method.appShippingMethod`.`shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name`, `shipping_method.translation.override_1`.`name` as `shipping_method.translation.override_1.name`, `shipping_method.translation`.`custom_fields` as `shipping_method.translation.customFields`, `shipping_method.translation.override_1`.`custom_fields` as `shipping_method.translation.override_1.customFields`, `shipping_method.translation`.`description` as `shipping_method.translation.description`, `shipping_method.translation.override_1`.`description` as `shipping_method.translation.override_1.description`, `shipping_method.translation`.`tracking_url` as `shipping_method.translation.trackingUrl`, `shipping_method.translation.override_1`.`tracking_url` as `shipping_method.translation.override_1.trackingUrl` FROM `shipping_method_translation` `shipping_method.translation` LEFT JOIN `shipping_method_translation` `shipping_method.translation.override_1` ON `shipping_method.translation`.`shipping_method_id` = `shipping_method.translation.override_1`.`shipping_method_id` AND `shipping_method.translation.override_1`.`language_id` = ? WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation`.`delivery_time_id`, `shipping_method.deliveryTime.translation`.`name` as `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation.override_1`.`name` as `shipping_method.deliveryTime.translation.override_1.name`, `shipping_method.deliveryTime.translation`.`custom_fields` as `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation.override_1`.`custom_fields` as `shipping_method.deliveryTime.translation.override_1.customFields` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` LEFT JOIN `delivery_time_translation` `shipping_method.deliveryTime.translation.override_1` ON `shipping_method.deliveryTime.translation`.`delivery_time_id` = `shipping_method.deliveryTime.translation.override_1`.`delivery_time_id` AND `shipping_method.deliveryTime.translation.override_1`.`language_id` = ? WHERE `shipping_method.deliveryTime.translation`.`language_id` = ?) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.`media_id`, `shipping_method.media.translation`.`alt` as `shipping_method.media.translation.alt`, `shipping_method.media.translation.override_1`.`alt` as `shipping_method.media.translation.override_1.alt`, `shipping_method.media.translation`.`title` as `shipping_method.media.translation.title`, `shipping_method.media.translation.override_1`.`title` as `shipping_method.media.translation.override_1.title`, `shipping_method.media.translation`.`custom_fields` as `shipping_method.media.translation.customFields`, `shipping_method.media.translation.override_1`.`custom_fields` as `shipping_method.media.translation.override_1.customFields` FROM `media_translation` `shipping_method.media.translation` LEFT JOIN `media_translation` `shipping_method.media.translation.override_1` ON `shipping_method.media.translation`.`media_id` = `shipping_method.media.translation.override_1`.`media_id` AND `shipping_method.media.translation.override_1`.`language_id` = ? WHERE `shipping_method.media.translation`.`language_id` = ?) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (?)
Parameters:
[ b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"\x11└■ø×IJÅöõ\x1C£±5Y\x10" ] |
||||||||||||||||||
1.44 ms (1.13%) |
2 |
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"ä-:ÑÄCÑè[\x1F<ؤ¾S" b"W]?牿Dœœsñ(’y\x04‘" b"“³»?I%@\x0E§9æå¯„tå" b"\x031ÖjvŽM6¯ÄªÞ»³9\x1D" b"\x04\v\x17·\x06\x01E║ìRÍN¨îÙ┬" b"\x1Fr¢║]\x08Iþü½{zð\x14\x16q" b"$ì-ê[å1Ær§æ╗¢<Û×" b""" U^/μ\fAO¼ÙŠ×\n hâ9 """ b"uw¼'/N¤¥Ñëï¸*ÇÕ" b"ËþÔ~dæMØ»r╔╗¡89n" b"à†ŸÊñÖHE´™,_\r´\x14" b"{?‚/N!Aòƒå\x13ë\x13Ÿ}F" b"\x07\x1DQîé#I—·¤GÄc½õ\x7F" b"\x16‰l\x16ðîFCµ*(¨±+Ï" b"8Y\x17uêäD\eüO\x0FÐF¡R\x04" b"Xsž¤çÙN|·>s”«ƒ˜C" b"│tü;óÏHµÄ_!├áªöÀ" b"Ê\x15zÅ\x1CÞB;ˆ§\x02ô\x1EBh<" ] |
||||||||||||||||||
1.42 ms (1.11%) |
1 |
# cart-rule-loader::load-rules::read SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"ä-:ÑÄCÑè[\x1F<ؤ¾S" b"\x01ñÈåBùKXžj\x06Ù€—öB" b"\x1A\x18\x1EàŠtL¡·e¬$ŽF9" b"&$Dî"eOûŸ¸ÙOÎ…ÐM" b"q¦«ìú\x07FA˜«ÈŽ˜¼à™" b"ɯgË$;HÔ£ÍH┌ãð\x07Ñ" b"›E®S\x06SOv˜æX9\f¡+å" b"£\x07³\x06]ÖKT’l\x07$À9t†" b"├Brep'J.ØÉ¯S3a\x1Ac" b"î5\x1Fû;•Db”½hN/°ÂÏ" b""" ï›\n p\x1EñK\x14·NÅý†Ï,è """ b"1P L¡xDUŠTjʺùg\v" b"{å¯zoêH¸¢ç†f\rÁò\v" b";ü‹¸OÔD\x7F¶ø·p"™;"" b"=‹\x17¤\x03·H\x06»†Ëñ„—iu" b"\x1EäÀqÄäFiµŽ¦sùmÇç" b"W]?牿Dœœsñ(’y\x04‘" b"{I™X%ýBä‘J\x7F\x1E/½äÁ" b"“³»?I%@\x0E§9æå¯„tå" b"¥ oZ\x01“Lzªmˆíäð–\x18" b"ÿïÍdÕ¼Jº©¾ÂµÑ<:v" b"\x01’#ìí‚q¯˜\x14F‡àE›\x19" b"\x01Æ$&üVpKÄ0\x17Ó\x00‗}Ó" b"\x031ÖjvŽM6¯ÄªÞ»³9\x1D" b"\x04\v\x17·\x06\x01E║ìRÍN¨îÙ┬" b"\x05Y╔\x01Þ6N¤üû\x02§ûå§Ø" b"\x1Fr¢║]\x08Iþü½{zð\x14\x16q" b"$ì-ê[å1Ær§æ╗¢<Û×" b"G\x7F’ÜnbGJ¶Ø\x03Wr+u„" b""" U^/μ\fAO¼ÙŠ×\n hâ9 """ b"[þ┌│╬·K┘ÿçÜÝïÙÅù" b"^RŒ\vˆÜGàµÆyç\x03\x12¹ˆ" b"jí\x01$ÚîOq¤u3ï¶8\x01w" b"m\x03ÅþC\rC\x1F│═É\x0FMIAµ" b"uw¼'/N¤¥Ñëï¸*ÇÕ" b"{\x04VƒŽ\Ú¦ƒ_ÀM™›)µ" b"ƒÛX€»«A<>½&†\x08¯K" b"Éÿ\x17lcáEÒ¼'#úg┼"║" b"‘ËáfLÍ·6Z\r\x17nÉ" b"Ñ#âÃ}¶L▓û9\x1A░\x17ÅÁî" b"Â6\x10╝éÏMÎüR×D:AY‗" b"╩╦0▄Ö\x15C§ì~*¼┐F²Í" b"ËþÔ~dæMØ»r╔╗¡89n" b"çã°xS‡Lk‚~ÏL\x16²¦f" b"ý†@O*\x1EGŸ´;76£¼\x1EY" b"À'\x14»ÑÚJN¿xTx5ÕÅ " b"Zóè¸ý^BTŠi\x02ÿÍ…or" b"à†ŸÊñÖHE´™,_\r´\x14" b"Q`§æ\x15dJ4‚5\x1CÔiD,Û" b"{?‚/N!Aòƒå\x13ë\x13Ÿ}F" b"\x01æZÅÃ╦{{ó┤ýK´÷*ó" b"\x01’eϬ¾\x7F¯¸Æ\x15µbUäí" b"\x01’eйæy\x1F›ºÅ\rëêè\x0E" b"\x01’eãá¼ra±bûvF\x0Eê†" b"\x01’lo\x06ãr\x19¹Öi‘gYñF" b"\x01ôåÅðhp?¿┐G┘%nÜD" b"\x01•ë—Òþr³¥võîTQ5>" b"\x01•ð&´Ws\x16ƒp³öÇý?ý" b"\x01•ð™gƒr\x16”"¤=\x7FAµÓ" b"\x01•û\x1En\ep·…\x19¾ÁóÙóy" b"\x01•û"].s£¯üXbβ\x06¨" b"\x01–\x15%\x068r>ºÂFÄXA;A" b"\x01û░ì░\x10}¢┤ï█î┴┐\x0E\x08" b"\x03´¯"n•Aå©\x04I«ìàó\t" b"\x04’\x08\x07UËFº H?Ûª,¨\e" b"\x07\x1DQîé#I—·¤GÄc½õ\x7F" b"\x10×\x0E„ŠÕAݽ7zý\x16\x03Ò§" b"\x13’Ì\x10>'Gi“sc‡Îâ\x1C¬" b"\x15sX\tÊzKøÖ╦YÉÓ\x13RÉ" b"\x16‰l\x16ðîFCµ*(¨±+Ï" b" Vw“1.A›ˆbðи³®Ê" b")|ÜhN·A\x1AŽoõ|š¨¤ª" b",B>(n¹N└╗h´1Øıı┴" b"8Y\x17uêäD\eüO\x0FÐF¡R\x04" b"AÞ\x19,ÇûEo¥Œ±)\x11*Š*" b"RÙ’\x15Ý6IH Έ)º^\x03ý" b"X+ýSDPM’ƒ;C\x7FöÍЗ" b"Xsž¤çÙN|·>s”«ƒ˜C" b"kQÈßS\tC>¢›=jÆŠŒC" b"rëÒúá)N¸ª´ã¦\x16ô(\x1E" b"‚%V\x02soH]±ˆ¤µÃ\f‘s" b"‡L\x00¢hPC¨‰8ßj³\x00£" b"’\x0EENmxA¥º(¤næ¤\x04n" b"“°dïS²DÁ¿ƒj7IB\fy" b"š%×D'\fC-†Í‹®Ä¢j°" b"¿íN╣ï·IÉÄ®┼\x00jñD÷" b"ªÜ·\x08¤½@²†¥_q\x0EÂùM" b"±ïA’f8Nl‡7\x1Evù)/c" b"│tü;óÏHµÄ_!├áªöÀ" b"¹^\x18yÑQE—€zî6\ed\x08‘" b""" ║¨g╔ivBs¢\x13\n ÅS^øñ """ b"├×{\x1AQKN&┤x>╗Ø%╦Ì" b"Ç\x07ž\x13i¨O8¸7\x05BÍíDŒ" b"Ê\x15zÅ\x1CÞB;ˆ§\x02ô\x1EBh<" b"╩áØrªÏH░Ü[eO\tE┴Ì" b"Òzó\x11ÆèC\x13œ\x14dŒ„t\x06ó" b"Ùf®\x0F>\x14Jf«Æ -K×’ã" b"┌\fu\x10\x03©@¯ÉÂþ\x01û\x13à0" b"ÞB\x10¢¡¡AЉnU'pË\f–" b"ã\r\™fµD\x0E‘‚ëþ)\x1D˜’" b"çÙxõkºC\x1E‡Î\x06™ï\x10¹¡" b"ò=¾õù¸Gå‚Ã5屟çt" b"õ5D]A8Nð¨p\x01}ˆk\x1Ea" b"¸XôG\x04àH╚É└╚«%²>R" ] |
||||||||||||||||||
1.29 ms (1.01%) |
1 |
# base-context-factory::payment-method::read SELECT `payment_method`.`id` as `payment_method.id`, `payment_method`.`plugin_id` as `payment_method.pluginId`, `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`, `payment_method`.`position` as `payment_method.position`, `payment_method`.`active` as `payment_method.active`, `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`, `payment_method`.`media_id` as `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` as `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` as `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` as `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`recurring_url` as `payment_method.appPaymentMethod.recurringUrl`, `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`, `payment_method`.`technical_name` as `payment_method.technicalName`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `payment_method.media`.`id` as `payment_method.media.id`, `payment_method.media`.`user_id` as `payment_method.media.userId`, `payment_method.media`.`media_folder_id` as `payment_method.media.mediaFolderId`, `payment_method.media`.`mime_type` as `payment_method.media.mimeType`, `payment_method.media`.`file_extension` as `payment_method.media.fileExtension`, `payment_method.media`.`uploaded_at` as `payment_method.media.uploadedAt`, `payment_method.media`.`file_name` as `payment_method.media.fileName`, `payment_method.media`.`file_size` as `payment_method.media.fileSize`, `payment_method.media`.`media_type` as `payment_method.media.mediaTypeRaw`, `payment_method.media`.`meta_data` as `payment_method.media.metaData`, `payment_method.media`.`config` as `payment_method.media.config`, `payment_method.media`.`path` as `payment_method.media.path`, `payment_method.media`.`private` as `payment_method.media.private`, `payment_method.media`.`thumbnails_ro` as `payment_method.media.thumbnailsRo`, `payment_method.media`.`created_at` as `payment_method.media.createdAt`, `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`, `payment_method.media.translation.override_1.title`, `payment_method.media.translation.title`, COALESCE(`payment_method.media.translation.override_1.title`,`payment_method.media.translation.title`) as `payment_method.media.title`, `payment_method.media.translation.override_1.alt`, `payment_method.media.translation.alt`, COALESCE(`payment_method.media.translation.override_1.alt`,`payment_method.media.translation.alt`) as `payment_method.media.alt`, `payment_method.media.translation.override_1.customFields`, `payment_method.media.translation.customFields`, COALESCE(`payment_method.media.translation.override_1.customFields`,`payment_method.media.translation.customFields`) as `payment_method.media.customFields`, `payment_method.translation.override_1.name`, `payment_method.translation.name`, COALESCE(`payment_method.translation.override_1.name`,`payment_method.translation.name`) as `payment_method.name`, `payment_method.translation.override_1.distinguishableName`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.override_1.distinguishableName`,`payment_method.translation.distinguishableName`) as `payment_method.distinguishableName`, `payment_method.translation.override_1.description`, `payment_method.translation.description`, COALESCE(`payment_method.translation.override_1.description`,`payment_method.translation.description`) as `payment_method.description`, `payment_method.translation.override_1.customFields`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.override_1.customFields`,`payment_method.translation.customFields`) as `payment_method.customFields` FROM `payment_method` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.translation`.`payment_method_id`, `payment_method.translation`.`name` as `payment_method.translation.name`, `payment_method.translation.override_1`.`name` as `payment_method.translation.override_1.name`, `payment_method.translation`.`distinguishable_name` as `payment_method.translation.distinguishableName`, `payment_method.translation.override_1`.`distinguishable_name` as `payment_method.translation.override_1.distinguishableName`, `payment_method.translation`.`description` as `payment_method.translation.description`, `payment_method.translation.override_1`.`description` as `payment_method.translation.override_1.description`, `payment_method.translation`.`custom_fields` as `payment_method.translation.customFields`, `payment_method.translation.override_1`.`custom_fields` as `payment_method.translation.override_1.customFields` FROM `payment_method_translation` `payment_method.translation` LEFT JOIN `payment_method_translation` `payment_method.translation.override_1` ON `payment_method.translation`.`payment_method_id` = `payment_method.translation.override_1`.`payment_method_id` AND `payment_method.translation.override_1`.`language_id` = ? WHERE `payment_method.translation`.`language_id` = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.`media_id`, `payment_method.media.translation`.`alt` as `payment_method.media.translation.alt`, `payment_method.media.translation.override_1`.`alt` as `payment_method.media.translation.override_1.alt`, `payment_method.media.translation`.`title` as `payment_method.media.translation.title`, `payment_method.media.translation.override_1`.`title` as `payment_method.media.translation.override_1.title`, `payment_method.media.translation`.`custom_fields` as `payment_method.media.translation.customFields`, `payment_method.media.translation.override_1`.`custom_fields` as `payment_method.media.translation.override_1.customFields` FROM `media_translation` `payment_method.media.translation` LEFT JOIN `media_translation` `payment_method.media.translation.override_1` ON `payment_method.media.translation`.`media_id` = `payment_method.media.translation.override_1`.`media_id` AND `payment_method.media.translation.override_1`.`language_id` = ? WHERE `payment_method.media.translation`.`language_id` = ?) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (?)
Parameters:
[ b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"•\x0Fq‰ÎÒD=¿‰7 …óõ=" ] |
||||||||||||||||||
1.22 ms (0.95%) |
1 |
# header::currencies::search-ids SELECT `currency`.`id` FROM `currency` LEFT JOIN `sales_channel_currency` `currency.salesChannels.mapping` ON `currency`.`id` = `currency.salesChannels.mapping`.`currency_id` LEFT JOIN `sales_channel` `currency.salesChannels` ON `currency.salesChannels.mapping`.`sales_channel_id` = `currency.salesChannels`.`id` WHERE (`currency.salesChannels`.`id` = ?) GROUP BY `currency`.`id`
Parameters:
[
b"\x0FÎe³¿<JE»AVó“Ô5õ"
]
|
||||||||||||||||||
1.08 ms (0.85%) |
1 |
# header::languages::read SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.productSearchConfig`.`id` as `language.productSearchConfig.id`, `language.productSearchConfig`.`language_id` as `language.productSearchConfig.languageId`, `language.productSearchConfig`.`and_logic` as `language.productSearchConfig.andLogic`, `language.productSearchConfig`.`min_search_length` as `language.productSearchConfig.minSearchLength`, `language.productSearchConfig`.`excluded_terms` as `language.productSearchConfig.excludedTerms`, `language.productSearchConfig`.`created_at` as `language.productSearchConfig.createdAt`, `language.productSearchConfig`.`updated_at` as `language.productSearchConfig.updatedAt`, `language.translationCode`.`id` as `language.translationCode.id`, `language.translationCode`.`code` as `language.translationCode.code`, `language.translationCode`.`created_at` as `language.translationCode.createdAt`, `language.translationCode`.`updated_at` as `language.translationCode.updatedAt`, `language.translationCode.translation.override_1.name`, `language.translationCode.translation.name`, COALESCE(`language.translationCode.translation.override_1.name`,`language.translationCode.translation.name`) as `language.translationCode.name`, `language.translationCode.translation.override_1.territory`, `language.translationCode.translation.territory`, COALESCE(`language.translationCode.translation.override_1.territory`,`language.translationCode.translation.territory`) as `language.translationCode.territory`, `language.translationCode.translation.override_1.customFields`, `language.translationCode.translation.customFields`, COALESCE(`language.translationCode.translation.override_1.customFields`,`language.translationCode.translation.customFields`) as `language.translationCode.customFields` FROM `language` LEFT JOIN `product_search_config` `language.productSearchConfig` ON `language`.`id` = `language.productSearchConfig`.`language_id` LEFT JOIN `locale` `language.translationCode` ON `language`.`translation_code_id` = `language.translationCode`.`id` LEFT JOIN (SELECT `language.translationCode.translation`.`locale_id`, `language.translationCode.translation`.`name` as `language.translationCode.translation.name`, `language.translationCode.translation.override_1`.`name` as `language.translationCode.translation.override_1.name`, `language.translationCode.translation`.`territory` as `language.translationCode.translation.territory`, `language.translationCode.translation.override_1`.`territory` as `language.translationCode.translation.override_1.territory`, `language.translationCode.translation`.`custom_fields` as `language.translationCode.translation.customFields`, `language.translationCode.translation.override_1`.`custom_fields` as `language.translationCode.translation.override_1.customFields` FROM `locale_translation` `language.translationCode.translation` LEFT JOIN `locale_translation` `language.translationCode.translation.override_1` ON `language.translationCode.translation`.`locale_id` = `language.translationCode.translation.override_1`.`locale_id` AND `language.translationCode.translation.override_1`.`language_id` = ? WHERE `language.translationCode.translation`.`language_id` = ?) `language.translationCode.locale_translation` ON `language.translationCode.locale_translation`.`locale_id` = `language.translationCode`.`id` WHERE `language`.`id` IN (?, ?, ?, ?, ?)
Parameters:
[ b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"/»_ââšMpªXTÎ|ãâ\v" b"Ñ6 )»˜A%Ž\x14\x1Aeiq\x1E\x0F" b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b""" \x01‘Eþ[&yMð1\n P°rš """ ] |
||||||||||||||||||
1.07 ms (0.84%) |
1 |
# header::currencies::read SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.override_1.shortName`, `currency.translation.shortName`, COALESCE(`currency.translation.override_1.shortName`,`currency.translation.shortName`) as `currency.shortName`, `currency.translation.override_1.name`, `currency.translation.name`, COALESCE(`currency.translation.override_1.name`,`currency.translation.name`) as `currency.name`, `currency.translation.override_1.customFields`, `currency.translation.customFields`, COALESCE(`currency.translation.override_1.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.override_1`.`short_name` as `currency.translation.override_1.shortName`, `currency.translation`.`name` as `currency.translation.name`, `currency.translation.override_1`.`name` as `currency.translation.override_1.name`, `currency.translation`.`custom_fields` as `currency.translation.customFields`, `currency.translation.override_1`.`custom_fields` as `currency.translation.override_1.customFields` FROM `currency_translation` `currency.translation` LEFT JOIN `currency_translation` `currency.translation.override_1` ON `currency.translation`.`currency_id` = `currency.translation.override_1`.`currency_id` AND `currency.translation.override_1`.`language_id` = ? WHERE `currency.translation`.`language_id` = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"\x05ß-?7%Hç›iˆÿ Fýó" b"&]#êÁ\x1DFT¯õñwðöm•" b"-~¡\x06·ACš·e…A%|á." b"6\vÔð\x17gJO™ô#¼/"´ã" b"N&z}j˜F…™e„P¢\x10¦=" b"t8àþ¸╚CÉ£+┐5©ôJD" b"€Éé®ôºCǼ“´Xk„¡¤" b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ" b"Ù\x19~$¶ÌEuŽAˆ#ÜñX2" ] |
||||||||||||||||||
1.00 ms (0.78%) |
3 |
SELECT `script`.`id` as `script.id`, `script`.`script` as `script.script`, `script`.`hook` as `script.hook`, `script`.`name` as `script.name`, `script`.`active` as `script.active`, `script`.`app_id` as `script.appId`, `script`.`created_at` as `script.createdAt`, `script`.`updated_at` as `script.updatedAt` FROM `script` WHERE (`script`.`app_id` IN (?))
Parameters:
[
b"\x01É5¥├Ôqñê■óðkú┬x"
]
|
||||||||||||||||||
1.00 ms (0.78%) |
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"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"·NÜâé>NA¸\x19CQAÿ\x15’" ] |
||||||||||||||||||
0.97 ms (0.76%) |
1 |
# header::languages::search-ids SELECT `language`.`id` FROM `language` LEFT JOIN `sales_channel_domain` `language.salesChannelDomains` ON `language`.`id` = `language.salesChannelDomains`.`language_id` LEFT JOIN `sales_channel_language` `language.salesChannels.mapping` ON `language`.`id` = `language.salesChannels.mapping`.`language_id` LEFT JOIN `sales_channel` `language.salesChannels` ON `language.salesChannels.mapping`.`sales_channel_id` = `language.salesChannels`.`id` WHERE (`language.salesChannelDomains`.`sales_channel_id` = ? AND `language.salesChannels`.`id` = ?) GROUP BY `language`.`id` ORDER BY MIN(`language`.`name`) ASC
Parameters:
[ b"\x0FÎe³¿<JE»AVó“Ô5õ" b"\x0FÎe³¿<JE»AVó“Ô5õ" ] |
||||||||||||||||||
0.97 ms (0.76%) |
1 |
# theme-service::resolve-media::read SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.override_1.title`, `media.translation.title`, COALESCE(`media.translation.override_1.title`,`media.translation.title`) as `media.title`, `media.translation.override_1.alt`, `media.translation.alt`, COALESCE(`media.translation.override_1.alt`,`media.translation.alt`) as `media.alt`, `media.translation.override_1.customFields`, `media.translation.customFields`, COALESCE(`media.translation.override_1.customFields`,`media.translation.customFields`) as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.`media_id`, `media.translation`.`alt` as `media.translation.alt`, `media.translation.override_1`.`alt` as `media.translation.override_1.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation.override_1`.`title` as `media.translation.override_1.title`, `media.translation`.`custom_fields` as `media.translation.customFields`, `media.translation.override_1`.`custom_fields` as `media.translation.override_1.customFields` FROM `media_translation` `media.translation` LEFT JOIN `media_translation` `media.translation.override_1` ON `media.translation`.`media_id` = `media.translation.override_1`.`media_id` AND `media.translation.override_1`.`language_id` = ? WHERE `media.translation`.`language_id` = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?))
Parameters:
[ b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" false true "product_download" b"1‘pÈýþB2‡k2I_â|Þ" b"äQÌ}‹\x17Bk»Z\x07Ù›\x05(‰" ] |
||||||||||||||||||
0.97 ms (0.76%) |
1 |
# context-factory::base-context SELECT sales_channel.id as sales_channel_id, sales_channel.language_id as sales_channel_default_language_id, sales_channel.currency_id as sales_channel_currency_id, currency.factor as sales_channel_currency_factor, GROUP_CONCAT(LOWER(HEX(sales_channel_language.language_id))) as sales_channel_language_ids FROM sales_channel INNER JOIN currency ON sales_channel.currency_id = currency.id LEFT JOIN sales_channel_language ON sales_channel_language.sales_channel_id = sales_channel.id WHERE sales_channel.id = ? GROUP BY sales_channel.id, sales_channel.language_id, sales_channel.currency_id, currency.factor
Parameters:
[
b"\x0FÎe³¿<JE»AVó“Ô5õ"
]
|
||||||||||||||||||
0.93 ms (0.73%) |
1 |
SELECT CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') `key`, CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') url, LOWER(HEX(domain.id)) id, LOWER(HEX(sales_channel.id)) salesChannelId, LOWER(HEX(sales_channel.type_id)) typeId, LOWER(HEX(domain.snippet_set_id)) snippetSetId, LOWER(HEX(domain.currency_id)) currencyId, LOWER(HEX(domain.language_id)) languageId, LOWER(HEX(theme.id)) themeId, sales_channel.maintenance maintenance, sales_channel.maintenance_ip_whitelist maintenanceIpWhitelist, snippet_set.iso as locale, theme.technical_name as themeName, parentTheme.technical_name as parentThemeName FROM sales_channel INNER JOIN sales_channel_domain domain ON domain.sales_channel_id = sales_channel.id LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id INNER JOIN snippet_set snippet_set ON snippet_set.id = domain.snippet_set_id LEFT JOIN theme theme ON theme_sales_channel.theme_id = theme.id LEFT JOIN theme parentTheme ON theme.parent_theme_id = parentTheme.id WHERE (sales_channel.type_id = UNHEX(?)) AND (sales_channel.active)
Parameters:
[
"8a243080f92e4c719546314b577cf82b"
]
|
||||||||||||||||||
0.92 ms (0.72%) |
1 |
SELECT `seo_path_info` AS seoPathInfo, `language_id` AS languageId FROM `seo_url` WHERE `path_info` = ? AND `is_canonical` = 1 AND `sales_channel_id` = ? AND `language_id` IN (?, ?, ?, ?, ?)
Parameters:
[ "/feedback/list" b"\x0FÎe³¿<JE»AVó“Ô5õ" b""" \x01‘Eþ[&yMð1\n P°rš """ b"/»_ââšMpªXTÎ|ãâ\v" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"Ñ6 )»˜A%Ž\x14\x1Aeiq\x1E\x0F" ] |
||||||||||||||||||
0.88 ms (0.69%) |
1 |
SELECT `swag_biotikon_theme_feedback_comment`.`id` as `swag_biotikon_theme_feedback_comment.id`, `swag_biotikon_theme_feedback_comment`.`theme` as `swag_biotikon_theme_feedback_comment.theme`, `swag_biotikon_theme_feedback_comment`.`person_name` as `swag_biotikon_theme_feedback_comment.personName`, `swag_biotikon_theme_feedback_comment`.`email` as `swag_biotikon_theme_feedback_comment.email`, `swag_biotikon_theme_feedback_comment`.`message` as `swag_biotikon_theme_feedback_comment.message`, `swag_biotikon_theme_feedback_comment`.`verified` as `swag_biotikon_theme_feedback_comment.verified`, `swag_biotikon_theme_feedback_comment`.`active` as `swag_biotikon_theme_feedback_comment.active`, `swag_biotikon_theme_feedback_comment`.`created_at` as `swag_biotikon_theme_feedback_comment.createdAt`, `swag_biotikon_theme_feedback_comment`.`updated_at` as `swag_biotikon_theme_feedback_comment.updatedAt` FROM `swag_biotikon_theme_feedback_comment` WHERE ((`swag_biotikon_theme_feedback_comment`.`verified` = ? AND `swag_biotikon_theme_feedback_comment`.`active` = ?))
Parameters:
[ true true ] |
||||||||||||||||||
0.87 ms (0.68%) |
1 |
# generic-page::shipping-methods::search-ids SELECT `shipping_method`.`id` FROM `shipping_method` LEFT JOIN `sales_channel_shipping_method` `shipping_method.salesChannels.mapping` ON `shipping_method`.`id` = `shipping_method.salesChannels.mapping`.`shipping_method_id` LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name`, `shipping_method.translation.override_1`.`name` as `shipping_method.translation.override_1.name` FROM `shipping_method_translation` `shipping_method.translation` LEFT JOIN `shipping_method_translation` `shipping_method.translation.override_1` ON `shipping_method.translation`.`shipping_method_id` = `shipping_method.translation.override_1`.`shipping_method_id` AND `shipping_method.translation.override_1`.`language_id` = ? WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `sales_channel` `shipping_method.salesChannels` ON `shipping_method.salesChannels.mapping`.`sales_channel_id` = `shipping_method.salesChannels`.`id` WHERE (`shipping_method`.`active` = ? AND `shipping_method.salesChannels`.`id` = ?) GROUP BY `shipping_method`.`id` ORDER BY MIN(`shipping_method`.`position`) ASC, MIN(COALESCE(`shipping_method.translation.override_1.name`,`shipping_method.translation.name`)) ASC
Parameters:
[ b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" true b"\x0FÎe³¿<JE»AVó“Ô5õ" ] |
||||||||||||||||||
0.80 ms (0.63%) |
1 |
SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, parentLocale.code AS parentCode, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id LEFT JOIN language parentLanguage ON language.parent_id = parentLanguage.id LEFT JOIN locale parentLocale ON parentLanguage.translation_code_id = parentLocale.id
Parameters:
[] |
||||||||||||||||||
0.78 ms (0.61%) |
1 |
# base-context-factory::customer-group::read SELECT `customer_group`.`id` as `customer_group.id`, `customer_group`.`display_gross` as `customer_group.displayGross`, `customer_group`.`registration_active` as `customer_group.registrationActive`, `customer_group`.`created_at` as `customer_group.createdAt`, `customer_group`.`updated_at` as `customer_group.updatedAt`, `customer_group.translation.override_1.name`, `customer_group.translation.name`, COALESCE(`customer_group.translation.override_1.name`,`customer_group.translation.name`) as `customer_group.name`, `customer_group.translation.override_1.registrationTitle`, `customer_group.translation.registrationTitle`, COALESCE(`customer_group.translation.override_1.registrationTitle`,`customer_group.translation.registrationTitle`) as `customer_group.registrationTitle`, `customer_group.translation.override_1.registrationIntroduction`, `customer_group.translation.registrationIntroduction`, COALESCE(`customer_group.translation.override_1.registrationIntroduction`,`customer_group.translation.registrationIntroduction`) as `customer_group.registrationIntroduction`, `customer_group.translation.override_1.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationOnlyCompanyRegistration`, COALESCE(`customer_group.translation.override_1.registrationOnlyCompanyRegistration`,`customer_group.translation.registrationOnlyCompanyRegistration`) as `customer_group.registrationOnlyCompanyRegistration`, `customer_group.translation.override_1.registrationSeoMetaDescription`, `customer_group.translation.registrationSeoMetaDescription`, COALESCE(`customer_group.translation.override_1.registrationSeoMetaDescription`,`customer_group.translation.registrationSeoMetaDescription`) as `customer_group.registrationSeoMetaDescription`, `customer_group.translation.override_1.customFields`, `customer_group.translation.customFields`, COALESCE(`customer_group.translation.override_1.customFields`,`customer_group.translation.customFields`) as `customer_group.customFields` FROM `customer_group` LEFT JOIN (SELECT `customer_group.translation`.`customer_group_id`, `customer_group.translation`.`name` as `customer_group.translation.name`, `customer_group.translation.override_1`.`name` as `customer_group.translation.override_1.name`, `customer_group.translation`.`custom_fields` as `customer_group.translation.customFields`, `customer_group.translation.override_1`.`custom_fields` as `customer_group.translation.override_1.customFields`, `customer_group.translation`.`registration_title` as `customer_group.translation.registrationTitle`, `customer_group.translation.override_1`.`registration_title` as `customer_group.translation.override_1.registrationTitle`, `customer_group.translation`.`registration_introduction` as `customer_group.translation.registrationIntroduction`, `customer_group.translation.override_1`.`registration_introduction` as `customer_group.translation.override_1.registrationIntroduction`, `customer_group.translation`.`registration_only_company_registration` as `customer_group.translation.registrationOnlyCompanyRegistration`, `customer_group.translation.override_1`.`registration_only_company_registration` as `customer_group.translation.override_1.registrationOnlyCompanyRegistration`, `customer_group.translation`.`registration_seo_meta_description` as `customer_group.translation.registrationSeoMetaDescription`, `customer_group.translation.override_1`.`registration_seo_meta_description` as `customer_group.translation.override_1.registrationSeoMetaDescription` FROM `customer_group_translation` `customer_group.translation` LEFT JOIN `customer_group_translation` `customer_group.translation.override_1` ON `customer_group.translation`.`customer_group_id` = `customer_group.translation.override_1`.`customer_group_id` AND `customer_group.translation.override_1`.`language_id` = ? WHERE `customer_group.translation`.`language_id` = ?) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation`.`customer_group_id` = `customer_group`.`id` WHERE `customer_group`.`id` IN (?)
Parameters:
[ b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"¤¢P\x18ËìAÏ¡╩\x10┘O╚¢Í" ] |
||||||||||||||||||
0.77 ms (0.60%) |
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:
[]
|
||||||||||||||||||
0.72 ms (0.56%) |
1 |
SELECT `theme`.`id` as `theme.id`, `theme`.`technical_name` as `theme.technicalName`, `theme`.`name` as `theme.name`, `theme`.`author` as `theme.author`, `theme`.`preview_media_id` as `theme.previewMediaId`, `theme`.`parent_theme_id` as `theme.parentThemeId`, `theme`.`theme_json` as `theme.themeJson`, `theme`.`base_config` as `theme.baseConfig`, `theme`.`config_values` as `theme.configValues`, `theme`.`active` as `theme.active`, `theme`.`created_at` as `theme.createdAt`, `theme`.`updated_at` as `theme.updatedAt`, `theme.translation.override_1.description`, `theme.translation.description`, COALESCE(`theme.translation.override_1.description`,`theme.translation.description`) as `theme.description`, `theme.translation.override_1.labels`, `theme.translation.labels`, COALESCE(`theme.translation.override_1.labels`,`theme.translation.labels`) as `theme.labels`, `theme.translation.override_1.helpTexts`, `theme.translation.helpTexts`, COALESCE(`theme.translation.override_1.helpTexts`,`theme.translation.helpTexts`) as `theme.helpTexts`, `theme.translation.override_1.customFields`, `theme.translation.customFields`, COALESCE(`theme.translation.override_1.customFields`,`theme.translation.customFields`) as `theme.customFields` FROM `theme` LEFT JOIN (SELECT `theme.translation`.`theme_id`, `theme.translation`.`description` as `theme.translation.description`, `theme.translation.override_1`.`description` as `theme.translation.override_1.description`, `theme.translation`.`labels` as `theme.translation.labels`, `theme.translation.override_1`.`labels` as `theme.translation.override_1.labels`, `theme.translation`.`help_texts` as `theme.translation.helpTexts`, `theme.translation.override_1`.`help_texts` as `theme.translation.override_1.helpTexts`, `theme.translation`.`custom_fields` as `theme.translation.customFields`, `theme.translation.override_1`.`custom_fields` as `theme.translation.override_1.customFields` FROM `theme_translation` `theme.translation` LEFT JOIN `theme_translation` `theme.translation.override_1` ON `theme.translation`.`theme_id` = `theme.translation.override_1`.`theme_id` AND `theme.translation.override_1`.`language_id` = ? WHERE `theme.translation`.`language_id` = ?) `theme.theme_translation` ON `theme.theme_translation`.`theme_id` = `theme`.`id` WHERE `theme`.`id` IN (?)
Parameters:
[ b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"Ó}‡Uz=O4¸RCn·Á\rd" ] |
||||||||||||||||||
0.71 ms (0.55%) |
2 |
SELECT `payment_method`.`id` FROM `payment_method` WHERE (`payment_method`.`handler_identifier` = ? AND `payment_method`.`active` = ?)
Parameters:
[ "Kiener\MolliePayments\Handler\Method\ApplePayPayment" true ] |
||||||||||||||||||
0.70 ms (0.55%) |
1 |
SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.override_1.title`, `media.translation.title`, COALESCE(`media.translation.override_1.title`,`media.translation.title`) as `media.title`, `media.translation.override_1.alt`, `media.translation.alt`, COALESCE(`media.translation.override_1.alt`,`media.translation.alt`) as `media.alt`, `media.translation.override_1.customFields`, `media.translation.customFields`, COALESCE(`media.translation.override_1.customFields`,`media.translation.customFields`) as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.`media_id`, `media.translation`.`alt` as `media.translation.alt`, `media.translation.override_1`.`alt` as `media.translation.override_1.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation.override_1`.`title` as `media.translation.override_1.title`, `media.translation`.`custom_fields` as `media.translation.customFields`, `media.translation.override_1`.`custom_fields` as `media.translation.override_1.customFields` FROM `media_translation` `media.translation` LEFT JOIN `media_translation` `media.translation.override_1` ON `media.translation`.`media_id` = `media.translation.override_1`.`media_id` AND `media.translation.override_1`.`language_id` = ? WHERE `media.translation`.`language_id` = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?, ?, ?, ?))
Parameters:
[ b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" false true "product_download" b"1‘pÈýþB2‡k2I_â|Þ" b"1‘pÈýþB2‡k2I_â|Þ" b"1‘pÈýþB2‡k2I_â|Þ" b"äQÌ}‹\x17Bk»Z\x07Ù›\x05(‰" b"äQÌ}‹\x17Bk»Z\x07Ù›\x05(‰" ] |
||||||||||||||||||
0.70 ms (0.55%) |
1 |
# base-context-factory::country::read SELECT `country`.`id` as `country.id`, `country`.`iso` as `country.iso`, `country`.`position` as `country.position`, `country`.`active` as `country.active`, `country`.`shipping_available` as `country.shippingAvailable`, `country`.`iso3` as `country.iso3`, `country`.`display_state_in_registration` as `country.displayStateInRegistration`, `country`.`force_state_in_registration` as `country.forceStateInRegistration`, `country`.`check_vat_id_pattern` as `country.checkVatIdPattern`, `country`.`vat_id_required` as `country.vatIdRequired`, `country`.`vat_id_pattern` as `country.vatIdPattern`, `country`.`customer_tax` as `country.customerTax`, `country`.`company_tax` as `country.companyTax`, `country`.`postal_code_required` as `country.postalCodeRequired`, `country`.`check_postal_code_pattern` as `country.checkPostalCodePattern`, `country`.`check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern`, `country`.`advanced_postal_code_pattern` as `country.advancedPostalCodePattern`, `country`.`default_postal_code_pattern` as `country.defaultPostalCodePattern`, `country`.`is_eu` as `country.isEu`, `country`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, `country.translation.override_1.name`, `country.translation.name`, COALESCE(`country.translation.override_1.name`,`country.translation.name`) as `country.name`, `country.translation.override_1.addressFormat`, `country.translation.addressFormat`, COALESCE(`country.translation.override_1.addressFormat`,`country.translation.addressFormat`) as `country.addressFormat`, `country.translation.override_1.customFields`, `country.translation.customFields`, COALESCE(`country.translation.override_1.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.override_1`.`name` as `country.translation.override_1.name`, `country.translation`.`custom_fields` as `country.translation.customFields`, `country.translation.override_1`.`custom_fields` as `country.translation.override_1.customFields`, `country.translation`.`address_format` as `country.translation.addressFormat`, `country.translation.override_1`.`address_format` as `country.translation.override_1.addressFormat` FROM `country_translation` `country.translation` LEFT JOIN `country_translation` `country.translation.override_1` ON `country.translation`.`country_id` = `country.translation.override_1`.`country_id` AND `country.translation.override_1`.`language_id` = ? WHERE `country.translation`.`language_id` = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (?)
Parameters:
[ b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"ò\x0E5„»@G³žñ'$ \v\x19" ] |
||||||||||||||||||
0.66 ms (0.51%) |
1 |
# generic-page::payment-methods::search-ids SELECT `payment_method`.`id` FROM `payment_method` LEFT JOIN `sales_channel_payment_method` `payment_method.salesChannels.mapping` ON `payment_method`.`id` = `payment_method.salesChannels.mapping`.`payment_method_id` LEFT JOIN `sales_channel` `payment_method.salesChannels` ON `payment_method.salesChannels.mapping`.`sales_channel_id` = `payment_method.salesChannels`.`id` WHERE (`payment_method`.`active` = ? AND `payment_method.salesChannels`.`id` = ?) GROUP BY `payment_method`.`id` ORDER BY MIN(`payment_method`.`position`) ASC
Parameters:
[ true b"\x0FÎe³¿<JE»AVó“Ô5õ" ] |
||||||||||||||||||
0.64 ms (0.50%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters:
[ b"\x0FÎe³¿<JE»AVó“Ô5õ" "UnzerPayment6.settings.%" ] |
||||||||||||||||||
0.63 ms (0.50%) |
1 |
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[ b"\x0FÎe³¿<JE»AVó“Ô5õ" "yu7q0ILW7P0jC5EOHegn9HvnudbL1KDx" ] |
||||||||||||||||||
0.63 ms (0.49%) |
1 |
# base-context-factory::currency::read SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.override_1.shortName`, `currency.translation.shortName`, COALESCE(`currency.translation.override_1.shortName`,`currency.translation.shortName`) as `currency.shortName`, `currency.translation.override_1.name`, `currency.translation.name`, COALESCE(`currency.translation.override_1.name`,`currency.translation.name`) as `currency.name`, `currency.translation.override_1.customFields`, `currency.translation.customFields`, COALESCE(`currency.translation.override_1.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.override_1`.`short_name` as `currency.translation.override_1.shortName`, `currency.translation`.`name` as `currency.translation.name`, `currency.translation.override_1`.`name` as `currency.translation.override_1.name`, `currency.translation`.`custom_fields` as `currency.translation.customFields`, `currency.translation.override_1`.`custom_fields` as `currency.translation.override_1.customFields` FROM `currency_translation` `currency.translation` LEFT JOIN `currency_translation` `currency.translation.override_1` ON `currency.translation`.`currency_id` = `currency.translation.override_1`.`currency_id` AND `currency.translation.override_1`.`language_id` = ? WHERE `currency.translation`.`language_id` = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters:
[ b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"!ä\rp¸eI*«ó\v|‰!¥Ð" b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ" ] |
||||||||||||||||||
0.61 ms (0.48%) |
2 |
SELECT `key`, `value` FROM `app_config`
Parameters:
[] |
||||||||||||||||||
0.59 ms (0.46%) |
1 |
# cart-rule-loader::load-rules::search-ids SELECT `rule`.`id` FROM `rule` WHERE (`rule`.`invalid` = ?) ORDER BY `rule`.`priority` DESC, `rule`.`id` ASC LIMIT 500
Parameters:
[
false
]
|
||||||||||||||||||
0.57 ms (0.44%) |
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"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"\x0FÎe³¿<JE»AVó“Ô5õ" "feedback/list" "feedback/list/" ] |
||||||||||||||||||
0.52 ms (0.40%) |
1 |
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`, `script`.`name` AS scriptName, `script`.`script` AS script, `script`.`hook` AS hook, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, `app`.`version` AS appVersion, `script`.`active` AS active FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` != 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters:
[] |
||||||||||||||||||
0.49 ms (0.38%) |
1 |
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||
0.46 ms (0.36%) |
1 |
SELECT `domain`.`language_id` AS languageId, `domain`.`id` AS id, `domain`.`url` AS url, `domain`.`hreflang_use_only_locale` AS onlyLocale, `locale`.`code` AS locale FROM `sales_channel_domain` AS `domain` INNER JOIN `language` ON `language`.`id` = `domain`.`language_id` INNER JOIN `locale` ON `locale`.`id` = `language`.`locale_id` WHERE `domain`.`sales_channel_id` = ?
Parameters:
[
b"\x0FÎe³¿<JE»AVó“Ô5õ"
]
|
||||||||||||||||||
0.45 ms (0.35%) |
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"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" b"\x0FÎe³¿<JE»AVó“Ô5õ" "/feedback/list" ] |
||||||||||||||||||
0.44 ms (0.35%) |
1 |
# base-context-factory::cash-rounding::search-ids SELECT `currency_country_rounding`.`id` FROM `currency_country_rounding` WHERE (`currency_country_rounding`.`currency_id` = ? AND `currency_country_rounding`.`country_id` = ?) LIMIT 1
Parameters:
[ b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ" b"ò\x0E5„»@G³žñ'$ \v\x19" ] |
||||||||||||||||||
0.44 ms (0.34%) |
1 |
# base-context-factory::sales-channel::association::domains::read SELECT `sales_channel_domain`.`id` as `sales_channel_domain.id`, `sales_channel_domain`.`url` as `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt` FROM `sales_channel_domain` WHERE (`sales_channel_domain`.`sales_channel_id` IN (?))
Parameters:
[
b"\x0FÎe³¿<JE»AVó“Ô5õ"
]
|
||||||||||||||||||
0.43 ms (0.34%) |
1 |
SELECT `cms_slot_translation`.`config` as `cms_slot_translation.config`, `cms_slot_translation`.`custom_fields` as `cms_slot_translation.customFields`, `cms_slot_translation`.`created_at` as `cms_slot_translation.createdAt`, `cms_slot_translation`.`updated_at` as `cms_slot_translation.updatedAt`, `cms_slot_translation`.`cms_slot_id` as `cms_slot_translation.cmsSlotId`, `cms_slot_translation`.`language_id` as `cms_slot_translation.languageId`, `cms_slot_translation`.`cms_slot_version_id` as `cms_slot_translation.cmsSlotVersionId` FROM `cms_slot_translation` WHERE (`cms_slot_translation`.`cms_slot_version_id` = ?) AND (((`cms_slot_translation`.`cms_slot_id` = ? AND `cms_slot_translation`.`language_id` = ?)))
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" b"Âó¢½Z¹K¹\x1F_E#™f," b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E" ] |
||||||||||||||||||
0.43 ms (0.34%) |
1 |
SELECT LOWER(HEX(theme.id)) themeId, theme.technical_name as themeName, parentTheme.technical_name as parentThemeName, LOWER(HEX(parentTheme.parent_theme_id)) as grandParentThemeId FROM sales_channel LEFT JOIN theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id LEFT JOIN theme ON theme_sales_channel.theme_id = theme.id LEFT JOIN theme AS parentTheme ON parentTheme.id = theme.parent_theme_id WHERE sales_channel.id = ?
Parameters:
[
b"\x0FÎe³¿<JE»AVó“Ô5õ"
]
|
||||||||||||||||||
0.43 ms (0.33%) |
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:
[]
|
||||||||||||||||||
0.42 ms (0.33%) |
1 |
SELECT `handler_identifier`, LOWER(HEX(`id`)) FROM `payment_method`
Parameters:
[] |
||||||||||||||||||
0.41 ms (0.32%) |
1 |
SELECT `base_class` AS `baseClass`, `author` FROM `plugin`
Parameters:
[] |
||||||||||||||||||
0.39 ms (0.31%) |
1 |
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`, `script`.`name` AS name, `script`.`script` AS script, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` = 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters:
[] |
||||||||||||||||||
0.38 ms (0.29%) |
1 |
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
"en-GB"
]
|
||||||||||||||||||
0.36 ms (0.28%) |
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:
[] |
||||||||||||||||||
0.36 ms (0.28%) |
1 |
#cart-persister::load SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters:
[
"yu7q0ILW7P0jC5EOHegn9HvnudbL1KDx"
]
|
||||||||||||||||||
0.35 ms (0.27%) |
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"^Ñ8‘qN{‹I``†}ÈP"
]
|
||||||||||||||||||
0.33 ms (0.26%) |
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"\x0FÎe³¿<JE»AVó“Ô5õ" b"ò\x0E5„»@G³žñ'$ \v\x19" ] |
||||||||||||||||||
0.31 ms (0.25%) |
1 |
SELECT `dvsn_quick_cart`.`id` FROM `dvsn_quick_cart` WHERE (`dvsn_quick_cart`.`seo_url` = ? AND `dvsn_quick_cart`.`active` = ?)
Parameters:
[ "feedback/list" true ] |
||||||||||||||||||
0.31 ms (0.24%) |
1 |
# app-scripts::refresh::search-ids SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ?)
Parameters:
[
true
]
|
||||||||||||||||||
0.30 ms (0.23%) |
1 |
SELECT LOWER(HEX(language.parent_id)) FROM language WHERE language.id = ?
Parameters:
[
b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E"
]
|
||||||||||||||||||
0.30 ms (0.23%) |
1 |
SELECT `name`, `path`, `author` FROM `app` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||
0.29 ms (0.23%) |
1 |
# base-context-factory::taxes::read SELECT `tax`.`id` as `tax.id`, `tax`.`tax_rate` as `tax.taxRate`, `tax`.`name` as `tax.name`, `tax`.`position` as `tax.position`, `tax`.`custom_fields` as `tax.customFields`, `tax`.`created_at` as `tax.createdAt`, `tax`.`updated_at` as `tax.updatedAt` FROM `tax`
Parameters:
[] |
||||||||||||||||||
0.28 ms (0.22%) |
1 |
SELECT `language`.`id` FROM `language` WHERE `language`.`id` IN (?) LIMIT 1
Parameters:
[
b"Y\x19_\x15…µNH‹ÐòéªÁs\x1E"
]
|
||||||||||||||||||
0.26 ms (0.20%) |
1 |
SELECT iso FROM snippet_set WHERE id = ?
Parameters:
[
b"÷BsÆq¾I¾Œ:vC><Bè"
]
|
||||||||||||||||||
0.19 ms (0.15%) |
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:
[]
|
Database Connections
Name | Service |
---|---|
0 | default |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.