Query Metrics
107
Database Queries
96
Different statements
848.06 ms
Query time
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
445.24 ms (52.50%) |
1 |
# product-listing-route::loading::aggregation::manufacturer SELECT LOWER(HEX(IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`))) as `manufacturer` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`)
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" 30 b"‘ùnjÔ±Fçµ¼¾A/a{º" true b"\x15ä╝SXÍLM▓;ÊY╝Ã╬É" b"\x15ä╝SXÍLM▓;ÊY╝Ã╬É" null true false ] |
||||||||||||||||||||
|
108.13 ms (12.75%) |
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/09d2ce8488e94a28bce222e2e22ceda8" "/navigation/ef9dbacf27b240309d1e603cb49bd272" "/navigation/2370a606774546b48f8fcab6b8286ac6" "/navigation/3c44bafdc37d4cdbaaa2cd70ce60679a" "/navigation/f2f4615d83d4426b8e5538b834d377a1" "/navigation/e0cdbc551b64462fa6c040eae8842902" "/navigation/b5acb8208d2949e599bcf94fa105490a" "/navigation/d60fe3f633dc480da5908308921e64f7" "/navigation/5d85bbeedb9540bc97afb4ed0a9dbad4" "/navigation/feba94f259e941b38042d448ac9aa6f1" "/navigation/c61086d4d7134412b8387f3545f5be39" "/navigation/c51fcf901d364d1f86694cfcdd9eb9a7" "/navigation/d949a96e79ec4da58c1498cfafe19e68" "/navigation/f56c8688cb3547f4ba2664c24641cb08" "/navigation/e33d4c8a1f4b46fca20628f6fe5012b7" "/navigation/9d3a4568ecde49fdb93fdf766914e8fb" "/navigation/9abccf9ea2a641eb8fbd3760ecc9cc88" "/navigation/d01af7cfd2d44febb5a5d96e1de41f38" "/navigation/eae6700d50254e468db1180ee308c2d5" "/navigation/ff69e61e866b4008bf8402adc3a026f4" "/navigation/06d451b0999f46379de73b08f22c169e" "/navigation/134098a8a9874f7083c356442a7c710a" "/navigation/104fe514648049ae84e042d16ebe95c7" "/navigation/b078ac6f26ae42859c481da342c6f2f7" "/navigation/1ce9780a765f40babc9e16b5b75cadb9" "/navigation/056b9e14cf59437286c5fc7e51857699" "/navigation/0f5360f936d84845a43fc16b52440765" "/navigation/16cf2784414f4f5fb6e2d29aea1325f1" "/navigation/b6358c1605014d239ef4110ef308b278" "/navigation/65865e4861674f58992ae92575262259" "/navigation/f650c74fc4e549ba9d2e44c777de1749" "/navigation/e066e96822e94b30bbc899d58b0ce7f7" "/navigation/9302bd5be0564517895eecb01c47d076" "/navigation/cb1119a34f6c4b18ac2de15e1f0e7d17" "/navigation/45e7335eb55447279ff2bec210c91bf4" "/navigation/24a7114488ff4c67b8aa944b3acfc5e3" "/navigation/fa5e0a07dc86401cbc53e4d8362724bd" "/navigation/8ecc23ca4c234bfbb9579fc42c81f354" "/navigation/86b4bf5ed9464a68816e2db9dee5efd8" "/navigation/91b00ab8ff79421eadc62676665121f3" "/navigation/ad00b48057e346cb91fd31e90bf91c1a" "/navigation/e72179143ba043a992c85e9b09777453" "/navigation/5e8ad69a8b81419f8a64c17118747503" "/navigation/426e45b2f1fe4b548ba7610c5f376a67" "/navigation/defdcd2839114f3e83207d26bc37e743" "/navigation/14e4afa373334cc8ba21703f779ec4bc" "/navigation/a4935291c57443639fbf61df1aad6d75" "/navigation/d727d8e1e5a545d0b88ca93ad8154c19" "/navigation/ee0648b5174542e5a4b158b16e4e7f0a" "/navigation/30fb667374e44f0a9debd310e0f14c16" "/navigation/b86815e2f5d0477287a49c360f67fd9d" "/navigation/9590101555f6405787a852875a427156" "/navigation/a4c48b49d58f46e9ac01d85e1c9057f4" "/navigation/ef972c4913a64f26aa2e86b916f2a01c" "/navigation/dfcdebbe50ef40c0ae832ab10cf8d813" "/navigation/75a374f617c2492b83f41308577cb5fa" "/navigation/fc545b6253bd47a7803344c1a216fd2b" "/navigation/422384a875b845a28446aabefe5d02a1" "/navigation/15f6273398dd423daa6e469a7e736199" "/navigation/ad771ec2b0ae4a05a7f88d3e84347da0" "/navigation/da0b25c7107948d1b70d7857e7fbcd02" "/navigation/9b939e8b882a447689587c5c421fe6cd" "/navigation/dad1b88e6b6a41d294742d7ed9debac6" "/navigation/5116877617ce402d944bce16aeffac60" "/navigation/b58df0a004ba4f0ebe1a07cc3e79b1a7" "/navigation/ca679e714414410ca085111a6ff6c0dd" "/navigation/006cbd8a6ac0403db6659bed803062a4" "/navigation/c09bf64e62c54b2aa55124b3f2f41f2c" "/navigation/89bb8a6fe5724ff4a37bb82024ab8ff0" "/navigation/6548102f1a7247678ce400fee2266eb7" "/navigation/fb87e77fde86450bb9e7f892e8247e65" "/navigation/c387095caf094709bbc7a9cbac1c0311" "/navigation/615b789f5ca54bed8d23a5fb0d2b33a1" "/navigation/92ab43d153734b61b09765a05ec804f3" "/navigation/c9462fd11b9c495ab138db44b0d3afb7" "/navigation/aaebbf30e73f4b85b48475e08a036d1b" "/navigation/bc41d3bcc7904b92b86d187118a556cb" "/navigation/12e08f52f92c4e4c871cfa0e8fe00117" "/navigation/2a6dcbb345f74304b3ac653e2ad4d2af" "/navigation/3af54e649c494849810018fb527ad00c" "/navigation/0a391de2b73841339e0b54e6fbd54849" "/navigation/82b891ec799749d0948652de007fa62f" "/navigation/f5c215c7ca6e45c6930d6c4064ade126" "/navigation/f724f9f8b35f47a6b7d0ddac2c6e6d89" "/navigation/774ea5bab3c54623bd546d6c9c26b31e" "/navigation/2470e66686d64905967defb9f5df8d3e" "/navigation/a9367d93455344768b380e4f804db56c" "/navigation/85a18b40594d4fb3bb91c46e011a77c0" "/navigation/0dc40f67884344b8929210b7e5aa22d1" "/navigation/920c097059bc4a61a9f4db41e59751fb" "/navigation/19df51e552a24dee9c9a1710a94f095b" "/navigation/70cdd05c6e5949468f37f121d2004236" "/navigation/ab609dd4871c4cbd89f1933a03432436" "/navigation/90114638303041f397bfc2b01d62ac43" "/navigation/7f2a966db1e9423aa96a0b1c36000533" "/navigation/f9b249d87650444baeff36af787a994f" "/navigation/e19390ccdbd142da945af97c51c02703" "/navigation/3534cf2472f8488d8121d53e3f64d402" "/navigation/bffef678702747c28dfdd5dfa4cb1013" "/navigation/cd9682e97f77401e88162bdc19b9bb8c" "/navigation/8cc96d18bbf747cc885db56f385a7a48" "/navigation/368b575ec8ba46cd9895c15e23f4c07d" "/navigation/8a84d0868ec345f3a42f9fa7ec219490" "/navigation/036537f24ed0486385166e9c5154c5d7" "/navigation/0a84d4899018416ea8854e0ab81bd064" "/navigation/8127cbee394a4ba8b3d808a0ec6327bb" "/navigation/ccecbf817e804b38b020a71d81bfbf79" "/navigation/454bd802e74f4f0d870a38d804536e92" "/navigation/893fbb14888b43b8865c44614d7ea60b" "/navigation/5184aedfc2ae4f0580a10deb957d5a62" "/navigation/5d77f3b3b4e14fa8b3cfc7796bd64b7f" "/navigation/99fb78b6e96c4ea2b54ad6903dc6cc01" "/navigation/4172c0af5ec34f7eb6bfef2fb5aa37ed" "/navigation/68292ef0b97e48bb81461693e56b0bcc" "/navigation/713a829050e5471cb4cda0a2b26b2f39" "/navigation/87f3f6762629429888985a90195f7949" "/navigation/c459c57eaff24880a80b8b41065d028d" "/navigation/6adbebdfd7fe491499bcf721a6ecd9be" "/navigation/462e35fe4d814c289acf712780ae5a0a" "/navigation/018f105488a973419d7a3fdef1769030" "/navigation/018f1055aa18727fa63b0b0fa276dec1" "/navigation/018f10551c80759d953688d2db9bdc76" "/navigation/018f105531d97697b34bf9dbfa570399" "/navigation/4b837f8d150444b1ae7012b36be47fc3" "/navigation/4556885bcab94c2f9e32500268ce101a" "/navigation/8b5d8dbe190b4cb2a715a8e84e0134c0" "/navigation/d66d2cd69db647698198417dfc53f326" "/navigation/84003fbb44074f0a9b83ad667ffd2647" "/navigation/54e09de87c5b49d792d4c62ff0202ae7" "/navigation/638f8832f9db4873a385133e83f55ca9" "/navigation/f64a5e8d15ec4ac8b0b175428682ed83" "/navigation/43b3fdf4370549e59ce6ee02eb8de4c2" "/navigation/1aefb6101b184c9eba1fa58b7c1429dd" "/navigation/015bd7b4c20a474691fca3865af10ff4" "/navigation/7f07c7ee5c464e10810eaa2f7d9ded8c" "/navigation/46b205b6674c4d63a7cea80b66abe2b9" "/navigation/6df7ff9efd56401e822a4d2fe28dda80" "/navigation/cee9773ef93e49ed974e13c8b11b018a" "/navigation/859c9a152e79496fbd66893e9b9f0e5c" "/navigation/49ba846a2d4e4629a7cce6e9e8abf961" "/navigation/3165114444364cf3b28ee47710323dfe" "/navigation/5477551a6ab041d398698925ef84ca73" "/navigation/018f58946ec77ef59e92d49096cc2ceb" "/navigation/42e486a9da6f41c690ae788e01e678aa" "/navigation/4d280192ab6541499f7fe9b410f16043" "/navigation/b71c02ce69ed4165935e2644b5709862" "/navigation/05bc063b0f174ce2b4197983ee595e10" "/navigation/b811032dfe6c4a958661d20310687704" "/navigation/43f227a5aa7649089e89abfb0897f481" "/navigation/d03e3eb2bc25436f92233b2572de00c7" "/navigation/432dc5bf111e433d9a10ca94a62dfc95" "/navigation/f8bd26a66d12405e9d4f9117386b7d45" "/navigation/f96131f133034be7a98f694b4e482e10" "/navigation/018f58a30eba72f49fd5c41bd2f8a7c2" "/navigation/018f58a48429741eacb7c978f2d81e5f" "/navigation/018f584347087eddbe3eb55771548e57" "/navigation/018f5843fb8678a48b0d7b71e7395aec" "/navigation/f5c1ea4bfa9742d2ab485088707e37a5" "/navigation/8074e2e56e124fb7b5f22b301d016c0b" "/navigation/989a1f466c4749ba8e94e9113c5729b7" "/navigation/018f5895c3e8741e9585ac7ad92ab304" "/navigation/42bacabd9bfc454881cb6137cda4fd8e" "/navigation/8e626e4b91ca4da4bb7023877a79a7e6" "/navigation/018f589b832d7e00accc6f418e678b3d" "/navigation/4ec2b3cdec0644a18fde0f212eb72858" "/navigation/018f58a5f001741eab3ab7b8f8ab6bc6" "/navigation/aef5fdd7403044c2a6b71ed862d78570" "/navigation/018f58a6d0487ad29748cd7a87e03308" "/navigation/8d1a0664060b47ed8b6dff68d8542201" "/navigation/4ae3558274454b4392a4f8664447808b" "/navigation/2d712bcb1e254331b432b30a3aa8dcf9" "/navigation/7296c337397e4f289fa8858d3c7c7db4" "/navigation/018f58a7a5e773d38e838bfef5144e9e" "/navigation/01917f39828f7c4aa86b0bc10a961564" "/navigation/018f5888c5fd746b8e81adc94b706511" "/navigation/8be671f0b6a641ca81d614173daba97d" "/navigation/018f58ab72be72ff89009d9f10cfe544" "/navigation/018f58abf5767510867eacc579377b85" "/navigation/42d40f8fab8040938f7704eba01317ba" "/navigation/018f58a9c9c77aad9bf956a9952ef9ec" "/navigation/774a005e688043699bb458cd61fa654c" "/navigation/018f58ad6525757a91d1887a0568fd3e" "/navigation/9d22ae740d6a4af68b535cea8de49a48" "/navigation/25c0986e665d49d88d4e39e76c43a3ff" "/navigation/07f39c5d48154f86960c70d1974a4949" "/navigation/31a993622b6043f9a1e584eddad5bd8c" "/navigation/83593a4483eb4ba0bd6cce81f7849726" "/navigation/b3d53be6cc204d0cb88d76401a213fa7" "/navigation/0d2f58ca297042128ea1412e315f3e75" "/navigation/018faaddd34c78269b89a398bbc3aa9a" "/navigation/018faadebe1873128eaf30752c7f31d1" "/navigation/018f58e2724e7400aab4510f6e910df5" "/navigation/018f58e2892a74a5a99a46b3bb6a8ae1" "/navigation/018faade6bcd7fea9ff6f25a3c4d1f8c" "/navigation/018f588e30897945b8d9fcbfe2c79540" "/navigation/c6c324dc838046eb831c99d7bf68be82" "/navigation/01917f96f44575239eff331589a8dcc7" "/navigation/018f58afb245704d8d3baa2f9a9b6fce" "/navigation/9bf305c290a342779cfcca8b02a680b0" "/navigation/018f58b303647f8aa29973566800f350" "/navigation/018f58b2556c72d0a63de9bd51b41580" "/navigation/018f58b634b27b1cb55b2f764e181924" "/navigation/f800f9d0a8b74166b7f7f3a3bbd962d6" "/navigation/018f58bba31b75d6ad492048b660ecbe" "/navigation/aa57829479154f27a8973a09a5f5dc48" "/navigation/018f58b6dad37707901e8c6741ae1b41" "/navigation/018f58bc5db47bd180c44de3a547d6b6" "/navigation/018f58b8311a7a6781afda03e2ed9142" "/navigation/018f58bdf30b7d7f8bb4d78731c66d0f" "/navigation/018f4e7edeee7a328cd0a2ff91984719" "/navigation/018f58be88727cf4b0c5d8d2da46c68e" "/navigation/018f58bf59137a78b65885c8d78c44aa" "/navigation/352ee310d604455283058d09c0c88c1a" "/navigation/018f58c944d9702bb062d2f08d4e877f" "/navigation/018f58c04f1a79cfaf9c5a0970671278" "/navigation/6443a8fda1554cff8aeafe31b163a516" "/navigation/018f58ca2d3972f99e25aa54249b7601" "/navigation/0f565502bc9f4bd988ead46b5d5b9f40" "/navigation/d06b487bb31143ceb4d9332f22418011" "/navigation/018f58c1083373e88cfce3e09c204be9" "/navigation/018f58cb07c87472bea38378111ba8b3" "/navigation/018f58c74da07370964dcbdcc11f8733" "/navigation/018f58c801d87e3d9bdcd4cc549ed7c9" "/navigation/bbdb56acca91406d9803d6a0aa7d7ecd" "/navigation/018f5876f2a87f59acc37e7379a44970" "/navigation/018f58cc9d9f7efca1f74a7deaf9b6c6" "/navigation/018f58cebc6f71a0b57b556e71f54bd3" "/navigation/018f58cdc7f077fbbfdb03d568ff1e7c" "/navigation/730ccb18b1314b0595ef1f00ff99125d" "/navigation/018f58cfc5b67191b2700e8401928428" "/navigation/4c16fbdae26144aabdf70afe2ba385b3" "/navigation/018f58d37afd70c5b052883ce9fec785" "/navigation/a47b3083f64044f288cb10864c2a78c8" "/navigation/018f58d478cd7dfd8f700dcd3a0ba487" "/navigation/018f86c106ff7c8cbc28d2ee12c5ff33" "/navigation/018f86c25e067e628f89776919f8c061" "/navigation/6d72d7f493b54d439ef51eed33448230" "/navigation/018f86c3730873308f3a1c9feef9c10c" "/navigation/018f86c4821a7cda98e40bc9e9c8b7ea" "/navigation/4c969bd8bdce4d80bfe6c570ac4d00d0" "/navigation/49984716787b4a0cb55f560bb7f019e2" "/navigation/6667a42578994181b0e0476d9314dac4" "/navigation/d9845bc6cb2744b2be51dbe278884e35" "/navigation/ebad16ffe77d45b18ce7b1c7a9c0101e" "/navigation/d9dbc04af29242529c8b50d95a853b71" "/navigation/d6fb34be4d314096821fbb232c71d035" "/navigation/a09958ff1c3b4ae7af1852b3a7d13bca" "/navigation/02f91e5c5843433f99ade07249392e96" "/navigation/2e95e37fd5354c4eb92d4c60950f7109" "/navigation/018f86ceb8547494a790c02ce9d30580" "/navigation/2eb9deab99434f2687e8c2f51d913a4f" "/navigation/018f86d067867c0c904c45ce692c3c43" "/navigation/018f86d326c97485bc72644a470fa607" "/navigation/fa7645c0394840a090f9f24ae3cec709" "/navigation/018f86d114d37512a5258aaf5db9d15a" "/navigation/5e38efcf767d439a93f1c3af2e8df5ec" "/navigation/364417ccaff2444ca97a01471ef6d1db" "/navigation/5d9ff7f971ba4c24a8e03360dd37510a" "/navigation/74f12524af5b4ff4b6dc773a1ec2689b" "/navigation/78995c51bc1a4509bc6494fc25709100" "/navigation/cfcd478b9293496ca2dd9d563b4ad4c3" "/navigation/f3697d66d108419da156dd377102cdf0" "/navigation/fc07efd0b0fe43e682913fdf18320867" "/navigation/018f86d2329d74d583a1302304b37860" "/navigation/018f86cf767c734ab59b1b3c2b26a7f6" "/navigation/018f86d3b038737f9fb0508190b5ec65" "/navigation/018f86d45a497dec9ebf9d61d7f17eaf" "/navigation/231d9b2c8d6148338a974512b2f35ca2" "/navigation/10fb92aa6adf4c3ba27790a3e65f0afb" "/navigation/2bbaa0b3ce824633a0ee745b5d40f1f6" "/navigation/32bb04eb735547eea9adb1e5d6f3c02b" "/navigation/41121a8b60ee449b9680ceff21c884a0" "/navigation/53c81246805740eca69c786cb33d51cd" "/navigation/54e19bb610dc453195496e5245c8cba5" "/navigation/6398d60bbddf4725bdd80e83b5646209" "/navigation/7047d4c32e344225a5c03c68bf7c7200" "/navigation/9c221ce85e6b4942a51d14ebb92a55ca" "/navigation/a26f984941624c159b9ddfaa9a7af591" "/navigation/018f86d579ff7521ad9e6192fce76c4f" "/navigation/018f86d697567ac19b73aa3d10edfd4e" "/navigation/737f838a91e6487d9abe59a096526dd1" "/navigation/a205163e939d4619bf192147c34e90ec" "/navigation/018f86d77a1775f284b5047dac52e7b3" "/navigation/018f86dc27917fc5a7fffa266cdd1373" "/navigation/c9c39f24ce0641c9917efa17f2f976cc" "/navigation/018f86deeb3a7ffaa43ff8237ea66c93" "/navigation/018fc4eca0bf725584d1ebb0cc3f83cc" "/navigation/018f86dd454c7385b12fb49238728674" "/navigation/7676e883a80b4366a4069b03b24a7c1f" "/navigation/37235d9c71cb4ba9a8c183bf41a58fa3" "/navigation/8cf104918cc3456da7ed6c3e5105cd21" "/navigation/e72bf5b59cf641eeb41f2e22a4c5a13c" "/navigation/018f86e0b4927c90bc8031f98b92d78a" "/navigation/d671e1a157934d378b9cca8b9630ead4" "/navigation/018f9c7821b978ffb7872e48aedb8730" "/navigation/018f86de30cf76159aef35493800037e" "/navigation/7a7a6f1864764022bc13d5b0e1572814" "/navigation/018f86dfd5667aaa885b6653a5215584" "/navigation/018f86e14ad77a448edc9790a736d3e6" "/navigation/97d5192f777f485ca657f2b2628bcee6" "/navigation/6cb0fa871e2646258d1e6090cb08f326" "/navigation/018f86e306a97b4ba10b9636ea4531b1" "/navigation/01933f4b9c097a7a8ccf6ff1c795e661" "/navigation/9efda7dc8c3c49328c4904f0ab587c91" "/navigation/a9a02947db474d85aaaa5ff84901e971" "/navigation/2357b863ecb348bfb1279078d907f56f" "/navigation/9c36ba54df844f9f9d58edcaa93d0807" "/navigation/a52430ba3b484d8794567f3648f62687" "/navigation/c96abae891324a66a2175a6fb4d57f03" "/navigation/ca160c796a8e48b49a3a74da1e7fb584" "/navigation/f4498dccf59647f58a5ea7e638b6d675" "/navigation/797ab028d4214f9289d1ba3a7f5c907c" "/navigation/c46c3c4de08c47ac8e857fb46155e69d" "/navigation/018f86e72975763ca9abd49c4bcbd11a" "/navigation/018f86e55808764eab6269a48c814331" "/navigation/d064f177abda4b89840f3263c3db2bc7" "/navigation/e5c3d96c18014d46a65778ab87cb8309" "/navigation/9a77b7482bd44ee088a01f8c6266d643" "/navigation/018ea3dbec697240aee76a39a7931286" "/navigation/018ea3dc002c72a9b87a5909419e1d86" "/navigation/018f86e6272f71cb841687b48ebd9a89" "/navigation/018f86f8491271ae92341b266e8755cb" "/navigation/018f86ea40f879a0b6bde5aa45edfc3d" "/navigation/018f86f12242771da8c8bd1516dc320c" "/navigation/018f86f53cf47d61a2a688965bd91552" "/navigation/018f86f5fbed7bb382a7e481ae9352ab" "/navigation/018f86f765157797a6da6dea84b279cd" "/navigation/018f8709035e793993b89af2cf31f1c2" "/navigation/35c3d66f2acf427e942446d0ff05a66f" "/navigation/1624265523f4482b8bf23049f538c927" "/navigation/44a2ec935fa445efbaeab216b2a75a07" "/navigation/018f871bd2af77b19b1a01514a14cfb8" "/navigation/65d40e675e054e51b1e67f35849f3d7d" "/navigation/9dac66018fca4ac7b91e77d286136f0e" "/navigation/6340ddccbbef4376975c4bcd26cfddab" "/navigation/6b67ecfbd9be4a6d829fa43a44861daa" "/navigation/b4f2058945ce4fd9bb12cdf24b8395a7" "/navigation/be0d0a13e9ec4a2984d095e5589735be" "/navigation/d797eddba80349c0a8d540ac4b08c6f9" "/navigation/d9ae546c7c13449aabb95d787456d6a1" "/navigation/e051a078f914462a9ac55cc6e08c9cd0" "/navigation/018f8718835078448133b9a02d068dcc" "/navigation/9c8fc73be1404ac29bf23203c3c700c0" "/navigation/7218b56e2f194c2bae5b087bdeb116c0" "/navigation/0190bb9b9a9e7699921c89e632d39ee5" "/navigation/0190bb9baf3e7ef48024aa39b81b4835" "/navigation/0190bb9bbf267c29acf6fe1b459fa4d5" "/navigation/5a9c7c597abc48dfb596575f3794032d" "/navigation/2dcb87292fc94feb91433acf5b1b2620" "/navigation/c743b88395cd4c77a81ec52851b8e930" "/navigation/018f871a431c75138d8e4afb59ed2da8" "/navigation/018f8714101a71daae7e38fa9b268048" "/navigation/018f871632607646818a51fd7717b75f" "/navigation/018fe3f7f4137fcabbaaa9dd399697b9" "/navigation/018f871c99a27b63906885d10d77b273" "/navigation/cbfa09808c5b477d87f8fa6c33bcfec9" "/navigation/176a29859d1a44e8b0da649a8784bf03" "/navigation/20ea8371dbf44afcad77f8ad4986a4bd" "/navigation/2a4dbee07e9c44479fcdc66609cb0813" "/navigation/8386a293b47a417aaf5798ad4660560c" "/navigation/84054e9d7c4a4cebbf43fb3034f1b8da" "/navigation/60ebee6f33f24f3489ed4271abd7911d" "/navigation/630d71b9871f439286688296b8b24a53" "/navigation/0b1538e8d7504ec5a2656ab64b400031" "/navigation/2ecbb0100d6c4136bc9ba1fbee2c73d3" "/navigation/313cbb63e61549af8893a8bc73c0512e" "/navigation/96f8dfd69a0f438a98228afd7d13bbdc" "/navigation/9df14c7afad6410cb0e6a0a2a6b2c091" "/navigation/dfb10b82f9774dbfbfb6216560790837" "/navigation/9e89c10ed8884841a94c3cf2af9779fc" "/navigation/fd4364758e064a25b53d2cbde722f589" "/navigation/3408f8fa672b4600b6368411b0557031" "/navigation/72676f8b9757408e93d261938c8f509f" "/navigation/018fe3f137f575e882969dec9aa0a792" "/navigation/018f871d5ab07342afe9b09e40186eee" "/navigation/0e20abbcb8414049a36da59e1e724e66" "/navigation/a7dff32ee86f44d284f493c33c75955a" "/navigation/f5e859db1ab3462089b0481fc0ae74eb" "/navigation/7adf83f1be924e24893b3e3ba16a5bc8" "/navigation/6d6c6a4f39cf4691a30d2771225d1ca1" "/navigation/46279973be3a40b5b9115778cda25c5b" "/navigation/1ab8513bb1dc4286a38e56a76f407bc7" "/navigation/018f871e45dc7ed8ac57cb9c371c2092" "/navigation/018fe917b5207a8fbab2fb7cab5c61d0" "/navigation/018fe3f98aa670a2836ae4f2e6ccafac" "/navigation/44680a6dcd5a4d3bab548cbb125826cc" "/navigation/a4e7b673b87946469818c4a28ab3a16f" "/navigation/a220414b870740f9a3da8ed762775810" "/navigation/018fe3f645197dcda2a9e081147f2dd9" "/navigation/e28977a70a8c4dd484798d3646b62af5" "/navigation/926a4b6cfab9458599d609d7a2b09853" "/navigation/e4982f1154c24c98babae3568fc8603c" "/navigation/3a35011cea5e4ba4a19da436b2e0341b" "/navigation/fadeb1fade76439da69524d7ae21d8bc" "/navigation/018fe3f03e457ed7a6e723838709d6a8" "/navigation/3739fdab7a1b40d88de960803a142ca0" "/navigation/018f871f5e8e7b5f9e934481c673bf40" "/navigation/fbb5101f17784a328f69d034872c9d19" "/navigation/b05943e98bb0434f920a24caeda9ab07" "/navigation/018f87201a2e7b85bbf5b45917b08288" "/navigation/25d3cff59961408a8c02c8ed8245873a" "/navigation/018f8720e368785894112c131fbd0f31" "/navigation/018f8721d0b57b1aa4a6ccc922f2e8f4" "/navigation/018f87229ca277a9badf1c0430e2655e" "/navigation/056f9e298b074e02864d757008ff476d" "/navigation/5ff0c5de111d45c38f43d6a27974c809" "/navigation/d0958611e5c24e2491dba6c611fd1bbc" "/navigation/cd02b40a8a6f41499f7123ebbe272fe4" "/navigation/302709ed4ad24bd69d21594a01414f96" "/navigation/659d2eb76a2e4542806a4c062c18491b" "/navigation/34fe0d46232346bba0683062171c193d" "/navigation/d6c9a6103f4f4acd8380560ab62fedc4" "/navigation/e21e4837e34e445298e67f7e3820590f" "/navigation/0c8d5653dfd64e3fa88c9f8c32246968" "/navigation/68f6324b036a4e0ab8ea2fb10b3a5e73" "/navigation/bba8ca88c2e14f3f8bbd8693c1da3b2f" "/navigation/c52d26eafb664cffa41a05a95ebd2ccf" "/navigation/e8b58fda942a428dbe988323c81f9774" "/navigation/550488753df64a3ea18dce89e733097a" "/navigation/01966d49202773c688c01b5dff49028c" "/navigation/f5c5a20146f1405688146a20d052f819" "/navigation/018f872383a67f219cad6cc081ef1fd2" "/navigation/13e590db80c74464aaaa2c6ca0966fc4" "/navigation/23dc9bd86c0e4c65aec433e3d436cc2d" "/navigation/6a45f8cb89ca4c8489d66d14355f3e7e" "/navigation/018f872418b17732961b6a16855a8ad1" "/navigation/c9e647055bc8453b9d15150bd7f12210" "/navigation/930d4a063d674bc1bf7ce28fcc748b3f" "/navigation/547a7958847d45bc86df3a273efe6528" "/navigation/0ba99152f04649a58ef8f7a5cef28b4c" "/navigation/018e80a13dbf7c8ca2e9473b6e796855" "/navigation/018e80a153ac7221befb06351332118e" "/navigation/018e80a1660f7c27a146e9e53991f990" "/navigation/018e80a17a2a7d5588ddca72a71577f1" "/navigation/4ba66d12a123487b93fb9b5516aecb86" "/navigation/0a6c9349f7ed4b06a84e5cb954429a05" "/navigation/3fb4e3dc9678455ab54918fd6b8cdc79" "/navigation/432a0906efca45e7bfb6703221556cef" "/navigation/4f3fd4dd95f64310a6f3875d99971eee" "/navigation/d040608ecaed428da7290ad41b7db917" "/navigation/64a25f1825fc4a6b8d4be75308913a88" "/navigation/018e8078b121753ea246c8b8f090e641" "/navigation/018f4e95411f70898c428edd129a46cc" "/navigation/018f9f339445717e972d68c17d745dbd" "/navigation/257a5d3679534e4bbfa0d4de13f4756b" "/navigation/018f872613f7736eba9d3af28987d88b" "/navigation/018f8726daec726fbc077208e3220300" "/navigation/297d82027c3b4eb2bd8bee97d8f2f6f1" "/navigation/018fb9341783714cb2434a2a3c917e72" "/navigation/018fb93437f1796e92aa36e1ada6cc02" "/navigation/3ca638cfd61d474cab8fe06650891a07" "/navigation/018fb93456157c40a2575895d7b07b19" "/navigation/018fb93496dd78fe95b8cb3df2a6b774" "/navigation/018fb934ad37712393a489591b285478" "/navigation/018fb93489e8712fab60a3a9e22d7853" "/navigation/018fc365db6b7a8089a1bf83700e6305" "/navigation/7f944b82bbe24eb181c101245b457905" "/navigation/f2ee3e898b5d4a2e845510b2a2ab6540" "/navigation/396427618f744b0da682ac556e62a3b8" "/navigation/6e587cabd86f4a839a0a888156bf9bd0" "/navigation/62dda90b8b16427092a2f7a756ea08e9" "/navigation/96e2ff53acc6408e83129db3aab9839a" "/navigation/1bb96785f81c47eaa9031c092dc973c7" "/navigation/a4d18364053445139a225e05342504e0" "/detail/725b723e570e4679be45a8dc1c460fac" "/detail/2f09755432b7c0775a54b7dab9b39128" "/detail/6dbbb141c6f74355bc8bc843e088fcf1" "/detail/16d5f6dcaf5b9f24c6ff9c0d72eac39c" "/detail/356f85cad55e44ce933c8aa1d942f544" "/detail/9984da317945f400431ac01c2c28d138" "/detail/cf18b37a7c4f660590db7dae0736091d" "/detail/4f6855c1bececa9f1a4128b11ec85caf" "/detail/910c2ce8f7674cd695244bf22d2fbeed" "/detail/6d44e396c4f978446aa2a04e74d3373b" "/detail/78d4588177dd8d510a0de3e23b1df691" "/detail/923c1d8b0d27b409e3e15865c91b173b" "/detail/afcfdabc27594821b2dbb89cff0b0283" "/detail/65a6830356b9e44eb5e3831dc56dffc5" "/detail/6e4ada9bef76498ba7c7063f92ea178d" "/detail/db564f5e969f4c86afa35f24acb3c6fa" "/detail/072108d68ae54cbf94b0cdee427946b2" "/detail/1294c008df418f049bdeb65b3032c132" "/detail/31d5b01ed41a478d648e2379e49f8779" "/detail/a0d33f2b9d494c9b910709c43c846c74" "/detail/edf587d7746b47a78a44418c3897206b" "/detail/624443e691ecdc93f81d754cae310260" "/detail/05da4495e4c14a79951aefd0e47392ca" "/detail/6dd0756c305b46ccb6db4a57aa3f1898" "/detail/c12f75294b5a40bd9c988bd6f9266781" "/detail/53be93139b4f43a08e0711f90731ffbf" "/detail/a814d2c3d5d5a95238fee5ed890a9554" "/detail/26cd93aa971d426cb11d94e2febf6f37" "/detail/3975d8f9a7484ffc927bdc8ca5b63878" "/detail/3d082fa3bc1c45808c69751374842a71" "/detail/44db3dd4f0ff4b9d8302e2338b224f23" "/detail/7a387422b37848078dfde8254453feda" "/detail/90d88b3aa9da4823a1a6466d08abddcf" "/detail/091365783d5841efb326e06e3515e863" "/detail/46f21dac4cd4b013d6322006b9e9af9d" "/detail/78a966e843048eb568911c46caee1d37" "/detail/81489b8dd3b4476fbfe1ae96dd5e94da" "/detail/a56a9b92378444acb12b37b116568a69" "/detail/a755083ba21c477ba753713166def006" "/detail/be9e998384444b078146b6edc7b9a366" "/detail/c1765d44eedc431fa29bb7cf3a9cfb6a" "/detail/dfe976370b644e21a2ead735a3994369" "/detail/0e66ac702ea7404dac0662944d489a5d" "/detail/15d7d61dceec2f3c49c146f33643c398" "/detail/1a4696dc5afe03cd34302f5a8d1153ae" "/detail/234a467127354a94abde271e6de22ef0" "/detail/42a813e437f742c8a3b5d04c2d32a476" "/detail/476c5f9ace234f65b67f0e664cef6b4d" "/navigation/29560bf318a44ad6ba8771662a0cc454" "/navigation/16299f54e03e4a548066aeb6ab3ab88e" "/navigation/27afc901ff884ed192da8051379e66ce" "/navigation/970658b3cbb74c73b869e617b203d80f" "/navigation/59a193cfbfb140bd84295b5b993c20df" "/navigation/687b40719e304c098c0a35edbd9bc508" "/navigation/05ed008099c64b18b4163957390cd455" "/navigation/bf17a18ba7aa4093871acea2bb2def22" "/navigation/cd6d9961b0564862b0f7913e41d4a68c" b"/»_ââšMpªXTÎ|ãâ\v" b"‘ùnjÔ±Fçµ¼¾A/a{º" ] |
||||||||||||||||||||
|
61.95 ms (7.30%) |
1 |
# product-listing-route::loading::read SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product.parent`.`cheapest_price` as `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.manufacturer`.`id` as `product.manufacturer.id`, `product.manufacturer`.`version_id` as `product.manufacturer.versionId`, `product.manufacturer`.`media_id` as `product.manufacturer.mediaId`, `product.manufacturer`.`link` as `product.manufacturer.link`, `product.manufacturer`.`created_at` as `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` as `product.manufacturer.updatedAt`, `product.manufacturer.translation.name`, `product.manufacturer.translation.name` as `product.manufacturer.name`, `product.manufacturer.translation.description`, `product.manufacturer.translation.description` as `product.manufacturer.description`, `product.manufacturer.translation.customFields`, `product.manufacturer.translation.customFields` as `product.manufacturer.customFields`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||') FROM `product_option` `product.options.mapping` WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, `product.unit`.`id` as `product.unit.id`, `product.unit`.`created_at` as `product.unit.createdAt`, `product.unit`.`updated_at` as `product.unit.updatedAt`, `product.unit.translation.shortCode`, `product.unit.translation.shortCode` as `product.unit.shortCode`, `product.unit.translation.name`, `product.unit.translation.name` as `product.unit.name`, `product.unit.translation.customFields`, `product.unit.translation.customFields` as `product.unit.customFields`, `product.deliveryTime`.`id` as `product.deliveryTime.id`, `product.deliveryTime`.`min` as `product.deliveryTime.min`, `product.deliveryTime`.`max` as `product.deliveryTime.max`, `product.deliveryTime`.`unit` as `product.deliveryTime.unit`, `product.deliveryTime`.`created_at` as `product.deliveryTime.createdAt`, `product.deliveryTime`.`updated_at` as `product.deliveryTime.updatedAt`, `product.deliveryTime.translation.name`, `product.deliveryTime.translation.name` as `product.deliveryTime.name`, `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation.customFields` as `product.deliveryTime.customFields`, `product.cover`.`id` as `product.cover.id`, `product.cover`.`version_id` as `product.cover.versionId`, `product.cover`.`product_id` as `product.cover.productId`, `product.cover`.`product_version_id` as `product.cover.productVersionId`, `product.cover`.`media_id` as `product.cover.mediaId`, `product.cover`.`position` as `product.cover.position`, `product.cover.media`.`id` as `product.cover.media.id`, `product.cover.media`.`user_id` as `product.cover.media.userId`, `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` as `product.cover.media.fileName`, `product.cover.media`.`file_size` as `product.cover.media.fileSize`, `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` as `product.cover.media.metaData`, `product.cover.media`.`config` as `product.cover.media.config`, `product.cover.media`.`path` as `product.cover.media.path`, `product.cover.media`.`private` as `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, `product.cover.media`.`created_at` as `product.cover.media.createdAt`, `product.cover.media`.`updated_at` as `product.cover.media.updatedAt`, `product.cover.media.translation.title`, `product.cover.media.translation.title` as `product.cover.media.title`, `product.cover.media.translation.alt`, `product.cover.media.translation.alt` as `product.cover.media.alt`, `product.cover.media.translation.customFields`, `product.cover.media.translation.customFields` as `product.cover.media.customFields`, `product.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`meta_description` as `product.translation.metaDescription`, `product.translation`.`name` as `product.translation.name`, `product.translation`.`keywords` as `product.translation.keywords`, `product.translation`.`description` as `product.translation.description`, `product.translation`.`meta_title` as `product.translation.metaTitle`, `product.translation`.`pack_unit` as `product.translation.packUnit`, `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`, `product.translation`.`custom_fields` as `product.translation.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`meta_description` as `product.parent.translation.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.manufacturer.translation`.`product_manufacturer_id`, `product.manufacturer.translation`.`product_manufacturer_version_id`, `product.manufacturer.translation`.`name` as `product.manufacturer.translation.name`, `product.manufacturer.translation`.`description` as `product.manufacturer.translation.description`, `product.manufacturer.translation`.`custom_fields` as `product.manufacturer.translation.customFields` FROM `product_manufacturer_translation` `product.manufacturer.translation` WHERE `product.manufacturer.translation`.`language_id` = ?) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_version_id` = `product.manufacturer`.`version_id` LEFT JOIN (SELECT `product.unit.translation`.`unit_id`, `product.unit.translation`.`short_code` as `product.unit.translation.shortCode`, `product.unit.translation`.`name` as `product.unit.translation.name`, `product.unit.translation`.`custom_fields` as `product.unit.translation.customFields` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation`.`language_id` = ?) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id` LEFT JOIN (SELECT `product.deliveryTime.translation`.`delivery_time_id`, `product.deliveryTime.translation`.`name` as `product.deliveryTime.translation.name`, `product.deliveryTime.translation`.`custom_fields` as `product.deliveryTime.translation.customFields` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation`.`language_id` = ?) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id` LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.cover.media.translation`.`media_id`, `product.cover.media.translation`.`alt` as `product.cover.media.translation.alt`, `product.cover.media.translation`.`title` as `product.cover.media.translation.title`, `product.cover.media.translation`.`custom_fields` as `product.cover.media.translation.customFields` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation`.`language_id` = ?) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"r[r>W\x0EFy¾E¨Ü\x1CF\x0F¬" b"/\tuT2·ÀwZT·Ú¹³‘(" b"m»±AÆ÷CU¼‹ÈCàˆüñ" b"\x16Õöܯ[Ÿ$Æÿœ\rrêÃœ" b"5o…ÊÕ^DΓ<Š¡ÙBõD" b"™„Ú1yEô\x00C\x1AÀ\x1C,(Ñ8" b"¤\x18│z|Of\x05É█}«\x076\t\x1D" b"OhUÁ¾ÎÊŸ\x1AA(±\x1EÈ\¯" b"‘\f,è÷gLÖ•$Kò-/¾í" b"mDã–ÄùxDj¢ NtÓ7;" b""" xÈXüw¦ìQ\n \rÒÔ;\x1D÷æ """ b"’<\x1D‹\r'´\tãáXeÉ\e\x17;" b"¯ÏÚ¼'YH!²Û¸œÿ\v\x02ƒ" b"e¦ƒ\x03V¹äNµãƒ\x1DÅmÿÅ" b"nJ┌ø´vIïºÃ\x06?ÆÛ\x17ì" b"ÛVO^–ŸL†¯£_$¬³Æú" b"\x07!\x08ÖŠåL¿”°ÍîByF²" b"\x12ö└\x08▀AÅ\x04øÌÂ[02┴2" b"1ı░\x1EÈ\x1AGìdÄ#yõƒçy" b"áË?+ØILøæ\x07\t─<ält" b"íõ‡×tkG§ŠDAŒ8— k" b"bDCæ‘ìÜ“ø\x1DuL®1\x02`" b"\x05ÚD•äÁJy•\x1AïÐäs’Ê" b"mÐul0[F̶ÛJWª?\x18˜" b"┴/u)KZ@¢£ÿïͨ&gü" b"S¾“\x13›OC Ž\x07\x11ù\x071ÿ¿" b""" ¨\x14ÒÃÕÕ©R8þåí‰\n •T """ b"&Í“ª—\x1DBl±\x1D”âþ¿o7" b"9uØù§HOü’{ÜŒ¥¶8x" b"=\x08/£¼\x1CE€Œiu\x13t„*q" b"D█=È KØâ\x02Ô3ï"O#" b"z8t"│xH\x07ì²Þ%DS■┌" b"ÉÏï:®┌H#íªFm\x08½¦¤" b"\t\x13ex=XAï³&àn5\x15èc" b"F‗\x1D¼LÈ░\x13Í2 \x06╣Ú»Ø" b"x©fèC\x04Žµh‘\x1CFÊî\x1D7" b"üHøìË┤Go┐ß«û¦^ö┌" b"¥j›’7„D¬±+7±\x16VŠi" b"§U\x08;¢\x1CG{§Sq1fÞð\x06" b"¥×ÖâäDK\x07üFÂÝÃ╣úf" b"Áv]DîÜC\x1F¢›·Ï:œûj" b"ßév7\vdN!¢ê×5£™Ci" b"\x0Ef¬p.§@M¬\x06b”MHš]" b"\x15×Ö\x1DÎì/<IÁFó6CØ" b"\x1AFû▄Z■\x03═40/Zì\x11S«" b"#JFq'5J”«Þ'\x1Emâ.ð" b"B¨\x13ä7÷BÈ£µÐL-2¤v" b"Gl_šÎ#Oe¶\x7F\x0EfLïkM" ] |
||||||||||||||||||||
|
36.24 ms (4.27%) |
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.title`, `category.media.translation.title` as `category.media.title`, `category.media.translation.alt`, `category.media.translation.alt` as `category.media.alt`, `category.media.translation.customFields`, `category.media.translation.customFields` as `category.media.customFields`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.`language_id` = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND ((`category`.`path` LIKE ? AND (`category`.`level` > ? AND `category`.`level` <= ?)))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" "%|ca910c95cfe24f0faee100911472c07b|%" 1 4 ] |
||||||||||||||||||||
|
26.61 ms (3.14%) |
1 |
# product-listing-route::loading::aggregation::properties SELECT LOWER(HEX(`product.properties`.`id`)) as `properties.key`, COUNT(`product`.`id`) as `properties.count` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_property` `product.properties.mapping` ON `product`.`properties` = `product.properties.mapping`.`product_id` AND `product`.`version_id` = `product.properties.mapping`.`product_version_id` LEFT JOIN `property_group_option` `product.properties` ON `product.properties.mapping`.`property_group_option_id` = `product.properties`.`id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product.properties`.`id`
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" 30 b"‘ùnjÔ±Fçµ¼¾A/a{º" true b"\x15ä╝SXÍLM▓;ÊY╝Ã╬É" b"\x15ä╝SXÍLM▓;ÊY╝Ã╬É" null true false ] |
||||||||||||||||||||
|
20.28 ms (2.39%) |
1 |
# seo-url::resolve SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND ((seo_path_info = ? OR seo_path_info = ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"‘ùnjÔ±Fçµ¼¾A/a{º" "biloba_product_manufacturer" "biloba_product_manufacturer/" ] |
||||||||||||||||||||
|
15.25 ms (1.80%) |
1 |
# seo-url::resolve-fallback SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (path_info = ?) AND (is_canonical = 1) LIMIT 1
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"‘ùnjÔ±Fçµ¼¾A/a{º" "/biloba_product_manufacturer" ] |
||||||||||||||||||||
|
13.23 ms (1.56%) |
1 |
# product-listing-route::loading::aggregation::price SELECT MIN(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule000b6b5cca674671b51ff61286259993.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule5ce2989d1ea547d2a6a3030b50dba78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulebedabb5e310f4165a658dfa41bce11af.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulec191bcf2f13b43f69cfb37d3b3705d7b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018ec8acdf73781aa3f6de8bee719efa.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule1bfb2ece3eda4b4f8927b4a2176132c6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule6416b6b49098496abbfa9d13e6755f96.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleb0479f6beb8f46a88352b20f60ede65d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule000b6b5cca674671b51ff61286259993.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule5ce2989d1ea547d2a6a3030b50dba78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulebedabb5e310f4165a658dfa41bce11af.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulec191bcf2f13b43f69cfb37d3b3705d7b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018ec8acdf73781aa3f6de8bee719efa.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule1bfb2ece3eda4b4f8927b4a2176132c6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule6416b6b49098496abbfa9d13e6755f96.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleb0479f6beb8f46a88352b20f60ede65d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)))) as `price.min`, MAX(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule000b6b5cca674671b51ff61286259993.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule5ce2989d1ea547d2a6a3030b50dba78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulebedabb5e310f4165a658dfa41bce11af.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulec191bcf2f13b43f69cfb37d3b3705d7b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018ec8acdf73781aa3f6de8bee719efa.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule1bfb2ece3eda4b4f8927b4a2176132c6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule6416b6b49098496abbfa9d13e6755f96.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleb0479f6beb8f46a88352b20f60ede65d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule000b6b5cca674671b51ff61286259993.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule5ce2989d1ea547d2a6a3030b50dba78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulebedabb5e310f4165a658dfa41bce11af.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulec191bcf2f13b43f69cfb37d3b3705d7b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018ec8acdf73781aa3f6de8bee719efa.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule1bfb2ece3eda4b4f8927b4a2176132c6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule6416b6b49098496abbfa9d13e6755f96.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleb0479f6beb8f46a88352b20f60ede65d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)))) as `price.max` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?)))
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" 30 b"‘ùnjÔ±Fçµ¼¾A/a{º" true b"\x15ä╝SXÍLM▓;ÊY╝Ã╬É" b"\x15ä╝SXÍLM▓;ÊY╝Ã╬É" null true false ] |
||||||||||||||||||||
|
8.54 ms (1.01%) |
1 |
# product-listing-route::loading::search-ids SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product`.`display_group` ORDER BY MAX(`product`.`sales`) DESC, MIN(`product`.`id`) ASC LIMIT 48
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" 30 b"‘ùnjÔ±Fçµ¼¾A/a{º" true b"\x15ä╝SXÍLM▓;ÊY╝Ã╬É" b"\x15ä╝SXÍLM▓;ÊY╝Ã╬É" null true false ] |
||||||||||||||||||||
|
8.37 ms (0.99%) |
1 |
SELECT COUNT(*) FROM (# product-listing-route::loading::search-ids SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product`.`display_group`) total
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" 30 b"‘ùnjÔ±Fçµ¼¾A/a{º" true b"\x15ä╝SXÍLM▓;ÊY╝Ã╬É" b"\x15ä╝SXÍLM▓;ÊY╝Ã╬É" null true false ] |
||||||||||||||||||||
|
8.13 ms (0.96%) |
1 |
# product-listing-route::loading::aggregation::options SELECT LOWER(HEX(`product.options`.`id`)) as `options.key`, COUNT(`product`.`id`) as `options.count` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_option` `product.options.mapping` ON `product`.`id` = `product.options.mapping`.`product_id` AND `product`.`version_id` = `product.options.mapping`.`product_version_id` LEFT JOIN `property_group_option` `product.options` ON `product.options.mapping`.`property_group_option_id` = `product.options`.`id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product.options`.`id`
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" 30 b"‘ùnjÔ±Fçµ¼¾A/a{º" true b"\x15ä╝SXÍLM▓;ÊY╝Ã╬É" b"\x15ä╝SXÍLM▓;ÊY╝Ã╬É" null true false ] |
||||||||||||||||||||
|
7.93 ms (0.94%) |
1 |
# product-listing-route::loading::aggregation::rating-exists SELECT MAX(IFNULL(`product`.`rating_average`, `product.parent`.`rating_average`)) as `rating` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) AND (((IFNULL(`product`.`rating_average`, `product.parent`.`rating_average`) >= ?)))
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" 30 b"‘ùnjÔ±Fçµ¼¾A/a{º" true b"\x15ä╝SXÍLM▓;ÊY╝Ã╬É" b"\x15ä╝SXÍLM▓;ÊY╝Ã╬É" null true false 0 ] |
||||||||||||||||||||
|
7.69 ms (0.91%) |
1 |
# product-listing-route::loading::aggregation::shipping-free-filter SELECT MAX(IFNULL(`product`.`shipping_free`, `product.parent`.`shipping_free`)) as `shipping-free` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) AND ((IFNULL(`product`.`shipping_free`, `product.parent`.`shipping_free`) = ?))
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" 30 b"‘ùnjÔ±Fçµ¼¾A/a{º" true b"\x15ä╝SXÍLM▓;ÊY╝Ã╬É" b"\x15ä╝SXÍLM▓;ÊY╝Ã╬É" null true false true ] |
||||||||||||||||||||
|
6.64 ms (0.78%) |
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.title`, `payment_method.media.translation.title` as `payment_method.media.title`, `payment_method.media.translation.alt`, `payment_method.media.translation.alt` as `payment_method.media.alt`, `payment_method.media.translation.customFields`, `payment_method.media.translation.customFields` as `payment_method.media.customFields`, `payment_method.translation.name`, `payment_method.translation.name` as `payment_method.name`, `payment_method.translation.distinguishableName`, `payment_method.translation.distinguishableName` as `payment_method.distinguishableName`, `payment_method.translation.description`, `payment_method.translation.description` as `payment_method.description`, `payment_method.translation.customFields`, `payment_method.translation.customFields` as `payment_method.customFields` FROM `payment_method` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.translation`.`payment_method_id`, `payment_method.translation`.`name` as `payment_method.translation.name`, `payment_method.translation`.`distinguishable_name` as `payment_method.translation.distinguishableName`, `payment_method.translation`.`description` as `payment_method.translation.description`, `payment_method.translation`.`custom_fields` as `payment_method.translation.customFields` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.`language_id` = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.`media_id`, `payment_method.media.translation`.`alt` as `payment_method.media.translation.alt`, `payment_method.media.translation`.`title` as `payment_method.media.translation.title`, `payment_method.media.translation`.`custom_fields` as `payment_method.media.translation.customFields` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation`.`language_id` = ?) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"Åë~À\x0FUGœ½1Z\x06?è\x14¥" ] |
||||||||||||||||||||
|
5.98 ms (0.71%) |
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%" "%|ca910c95cfe24f0faee100911472c07b|%" 4 true true ] |
||||||||||||||||||||
|
3.45 ms (0.41%) |
1 |
# landing-page::cms-page::association::sections::association::blocks::association::slots::read SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`type` as `cms_slot.type`, `cms_slot`.`slot` as `cms_slot.slot`, `cms_slot`.`locked` as `cms_slot.locked`, `cms_slot`.`cms_block_id` as `cms_slot.blockId`, `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.translation.config`, `cms_slot.translation.config` as `cms_slot.config`, `cms_slot.translation.customFields`, `cms_slot.translation.customFields` as `cms_slot.customFields` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation`.`cms_slot_id`, `cms_slot.translation`.`cms_slot_version_id`, `cms_slot.translation`.`config` as `cms_slot.translation.config`, `cms_slot.translation`.`custom_fields` as `cms_slot.translation.customFields` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation`.`language_id` = ?) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` AND `cms_slot.cms_slot_translation`.`cms_slot_version_id` = `cms_slot`.`version_id` WHERE (`cms_slot`.`version_id` = ?) AND ((`cms_slot`.`cms_block_id` IN (?, ?, ?, ?)))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01ÅN\x05ô¸p¾Ø,æôÀH\tá" b"\x01ÅN\x05ô¸p¾Ø,æôÀ·æá" b"\x01ÅN\x05ô¸p¾Ø,æô©Ær\x19" b"\x01ÅN\x05ô¸p¾Ø,æô╣\x1C╣B" ] |
||||||||||||||||||||
|
3.18 ms (0.38%) |
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.name`, `shipping_method.deliveryTime.translation.name` as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation.customFields` as `shipping_method.deliveryTime.customFields`, `shipping_method.appShippingMethod`.`id` as `shipping_method.appShippingMethod.id`, `shipping_method.appShippingMethod`.`app_name` as `shipping_method.appShippingMethod.appName`, `shipping_method.appShippingMethod`.`identifier` as `shipping_method.appShippingMethod.identifier`, `shipping_method.appShippingMethod`.`app_id` as `shipping_method.appShippingMethod.appId`, `shipping_method.appShippingMethod`.`shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId`, `shipping_method.appShippingMethod`.`original_media_id` as `shipping_method.appShippingMethod.originalMediaId`, `shipping_method.appShippingMethod`.`created_at` as `shipping_method.appShippingMethod.createdAt`, `shipping_method.appShippingMethod`.`updated_at` as `shipping_method.appShippingMethod.updatedAt`, `shipping_method`.`technical_name` as `shipping_method.technicalName`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.media`.`id` as `shipping_method.media.id`, `shipping_method.media`.`user_id` as `shipping_method.media.userId`, `shipping_method.media`.`media_folder_id` as `shipping_method.media.mediaFolderId`, `shipping_method.media`.`mime_type` as `shipping_method.media.mimeType`, `shipping_method.media`.`file_extension` as `shipping_method.media.fileExtension`, `shipping_method.media`.`uploaded_at` as `shipping_method.media.uploadedAt`, `shipping_method.media`.`file_name` as `shipping_method.media.fileName`, `shipping_method.media`.`file_size` as `shipping_method.media.fileSize`, `shipping_method.media`.`media_type` as `shipping_method.media.mediaTypeRaw`, `shipping_method.media`.`meta_data` as `shipping_method.media.metaData`, `shipping_method.media`.`config` as `shipping_method.media.config`, `shipping_method.media`.`path` as `shipping_method.media.path`, `shipping_method.media`.`private` as `shipping_method.media.private`, `shipping_method.media`.`thumbnails_ro` as `shipping_method.media.thumbnailsRo`, `shipping_method.media`.`created_at` as `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`, `shipping_method.media.translation.title`, `shipping_method.media.translation.title` as `shipping_method.media.title`, `shipping_method.media.translation.alt`, `shipping_method.media.translation.alt` as `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, `shipping_method.media.translation.customFields` as `shipping_method.media.customFields`, `shipping_method.translation.name`, `shipping_method.translation.name` as `shipping_method.name`, `shipping_method.translation.description`, `shipping_method.translation.description` as `shipping_method.description`, `shipping_method.translation.trackingUrl`, `shipping_method.translation.trackingUrl` as `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, `shipping_method.translation.customFields` as `shipping_method.customFields` FROM `shipping_method` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method`.`id` = `shipping_method.appShippingMethod`.`shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name`, `shipping_method.translation`.`custom_fields` as `shipping_method.translation.customFields`, `shipping_method.translation`.`description` as `shipping_method.translation.description`, `shipping_method.translation`.`tracking_url` as `shipping_method.translation.trackingUrl` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation`.`delivery_time_id`, `shipping_method.deliveryTime.translation`.`name` as `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation`.`custom_fields` as `shipping_method.deliveryTime.translation.customFields` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation`.`language_id` = ?) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.`media_id`, `shipping_method.media.translation`.`alt` as `shipping_method.media.translation.alt`, `shipping_method.media.translation`.`title` as `shipping_method.media.translation.title`, `shipping_method.media.translation`.`custom_fields` as `shipping_method.media.translation.customFields` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation`.`language_id` = ?) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"ш«\tÅ\tH\x1D– \U×T¸K" ] |
||||||||||||||||||||
|
2.91 ms (0.34%) |
1 |
# product-listing::property-filter::read SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group.translation.name`, `property_group_option.group.translation.name` as `property_group_option.group.name`, `property_group_option.group.translation.description`, `property_group_option.group.translation.description` as `property_group_option.group.description`, `property_group_option.group.translation.position`, `property_group_option.group.translation.position` as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, `property_group_option.group.translation.customFields` as `property_group_option.group.customFields`, `property_group_option.media`.`id` as `property_group_option.media.id`, `property_group_option.media`.`user_id` as `property_group_option.media.userId`, `property_group_option.media`.`media_folder_id` as `property_group_option.media.mediaFolderId`, `property_group_option.media`.`mime_type` as `property_group_option.media.mimeType`, `property_group_option.media`.`file_extension` as `property_group_option.media.fileExtension`, `property_group_option.media`.`uploaded_at` as `property_group_option.media.uploadedAt`, `property_group_option.media`.`file_name` as `property_group_option.media.fileName`, `property_group_option.media`.`file_size` as `property_group_option.media.fileSize`, `property_group_option.media`.`media_type` as `property_group_option.media.mediaTypeRaw`, `property_group_option.media`.`meta_data` as `property_group_option.media.metaData`, `property_group_option.media`.`config` as `property_group_option.media.config`, `property_group_option.media`.`path` as `property_group_option.media.path`, `property_group_option.media`.`private` as `property_group_option.media.private`, `property_group_option.media`.`thumbnails_ro` as `property_group_option.media.thumbnailsRo`, `property_group_option.media`.`created_at` as `property_group_option.media.createdAt`, `property_group_option.media`.`updated_at` as `property_group_option.media.updatedAt`, `property_group_option.media.translation.title`, `property_group_option.media.translation.title` as `property_group_option.media.title`, `property_group_option.media.translation.alt`, `property_group_option.media.translation.alt` as `property_group_option.media.alt`, `property_group_option.media.translation.customFields`, `property_group_option.media.translation.customFields` as `property_group_option.media.customFields`, `property_group_option.translation.name`, `property_group_option.translation.name` as `property_group_option.name`, `property_group_option.translation.position`, `property_group_option.translation.position` as `property_group_option.position`, `property_group_option.translation.customFields`, `property_group_option.translation.customFields` as `property_group_option.customFields` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN `media` `property_group_option.media` ON `property_group_option`.`media_id` = `property_group_option.media`.`id` LEFT JOIN (SELECT `property_group_option.translation`.`property_group_option_id`, `property_group_option.translation`.`name` as `property_group_option.translation.name`, `property_group_option.translation`.`position` as `property_group_option.translation.position`, `property_group_option.translation`.`custom_fields` as `property_group_option.translation.customFields` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.`language_id` = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN (SELECT `property_group_option.group.translation`.`property_group_id`, `property_group_option.group.translation`.`name` as `property_group_option.group.translation.name`, `property_group_option.group.translation`.`description` as `property_group_option.group.translation.description`, `property_group_option.group.translation`.`position` as `property_group_option.group.translation.position`, `property_group_option.group.translation`.`custom_fields` as `property_group_option.group.translation.customFields` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.`language_id` = ?) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.media.translation`.`media_id`, `property_group_option.media.translation`.`alt` as `property_group_option.media.translation.alt`, `property_group_option.media.translation`.`title` as `property_group_option.media.translation.title`, `property_group_option.media.translation`.`custom_fields` as `property_group_option.media.translation.customFields` FROM `media_translation` `property_group_option.media.translation` WHERE `property_group_option.media.translation`.`language_id` = ?) `property_group_option.media.media_translation` ON `property_group_option.media.media_translation`.`media_id` = `property_group_option.media`.`id` WHERE `property_group_option`.`id` IN (?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b""" ¢\t\x07\n ˜0KÀ²/wÆ,Ðùú """ b"ñý\x14-Y[Ný‰ŒÈ ’\t|N" ] |
||||||||||||||||||||
|
2.75 ms (0.32%) |
3 |
# navigation-route::meta-information SELECT LOWER(HEX(`id`)), `path`, `level` FROM `category` WHERE `id` = ? OR `parent_id` = ? OR `id` = ?
Parameters:
[ b"Ê‘\f•ÏâO\x0F®á\x00‘\x14rÀ{" b"Ê‘\f•ÏâO\x0F®á\x00‘\x14rÀ{" b"Ê‘\f•ÏâO\x0F®á\x00‘\x14rÀ{" ] |
||||||||||||||||||||
|
2.69 ms (0.32%) |
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"\x11w¹£‗¢E8¿\ì®d,e)" ] |
||||||||||||||||||||
|
2.59 ms (0.31%) |
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"
]
|
||||||||||||||||||||
|
2.30 ms (0.27%) |
1 |
# base-context-factory::sales-channel::association::languages::read SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.translationCode`.`id` as `language.translationCode.id`, `language.translationCode`.`code` as `language.translationCode.code`, `language.translationCode`.`created_at` as `language.translationCode.createdAt`, `language.translationCode`.`updated_at` as `language.translationCode.updatedAt`, `language.translationCode.translation.name`, `language.translationCode.translation.name` as `language.translationCode.name`, `language.translationCode.translation.territory`, `language.translationCode.translation.territory` as `language.translationCode.territory`, `language.translationCode.translation.customFields`, `language.translationCode.translation.customFields` as `language.translationCode.customFields`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.name`, `language.locale.translation.name` as `language.locale.name`, `language.locale.translation.territory`, `language.locale.translation.territory` as `language.locale.territory`, `language.locale.translation.customFields`, `language.locale.translation.customFields` as `language.locale.customFields` FROM `language` LEFT JOIN `locale` `language.translationCode` ON `language`.`translation_code_id` = `language.translationCode`.`id` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.translationCode.translation`.`locale_id`, `language.translationCode.translation`.`name` as `language.translationCode.translation.name`, `language.translationCode.translation`.`territory` as `language.translationCode.translation.territory`, `language.translationCode.translation`.`custom_fields` as `language.translationCode.translation.customFields` FROM `locale_translation` `language.translationCode.translation` WHERE `language.translationCode.translation`.`language_id` = ?) `language.translationCode.locale_translation` ON `language.translationCode.locale_translation`.`locale_id` = `language.translationCode`.`id` LEFT JOIN (SELECT `language.locale.translation`.`locale_id`, `language.locale.translation`.`name` as `language.locale.translation.name`, `language.locale.translation`.`territory` as `language.locale.translation.territory`, `language.locale.translation`.`custom_fields` as `language.locale.translation.customFields` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation`.`language_id` = ?) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE ((`language`.`id` = ?)) AND (`language`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" ] |
||||||||||||||||||||
|
2.22 ms (0.26%) |
1 |
SELECT translation_key, value FROM snippet WHERE snippet_set_id = ?
Parameters:
[
b"ﮨ™°\tIô»\tÀCÍP4\e"
]
|
||||||||||||||||||||
|
2.16 ms (0.25%) |
1 |
# landing-page::cms-page::read SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`version_id` as `cms_page.versionId`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`css_class` as `cms_page.cssClass`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.translation.name`, `cms_page.translation.name` as `cms_page.name`, `cms_page.translation.customFields`, `cms_page.translation.customFields` as `cms_page.customFields` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.`cms_page_id`, `cms_page.translation`.`cms_page_version_id`, `cms_page.translation`.`name` as `cms_page.translation.name`, `cms_page.translation`.`custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.`language_id` = ?) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.`cms_page_version_id` = `cms_page`.`version_id` WHERE (`cms_page`.`version_id` = ?) AND (`cms_page`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"┬¿Þes0Iµ¡■>\x0Eì1È<" ] |
||||||||||||||||||||
|
2.11 ms (0.25%) |
1 |
# footer-pagelet::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.title`, `payment_method.media.translation.title` as `payment_method.media.title`, `payment_method.media.translation.alt`, `payment_method.media.translation.alt` as `payment_method.media.alt`, `payment_method.media.translation.customFields`, `payment_method.media.translation.customFields` as `payment_method.media.customFields`, `payment_method.translation.name`, `payment_method.translation.name` as `payment_method.name`, `payment_method.translation.distinguishableName`, `payment_method.translation.distinguishableName` as `payment_method.distinguishableName`, `payment_method.translation.description`, `payment_method.translation.description` as `payment_method.description`, `payment_method.translation.customFields`, `payment_method.translation.customFields` as `payment_method.customFields` FROM `payment_method` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.translation`.`payment_method_id`, `payment_method.translation`.`name` as `payment_method.translation.name`, `payment_method.translation`.`distinguishable_name` as `payment_method.translation.distinguishableName`, `payment_method.translation`.`description` as `payment_method.translation.description`, `payment_method.translation`.`custom_fields` as `payment_method.translation.customFields` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.`language_id` = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.`media_id`, `payment_method.media.translation`.`alt` as `payment_method.media.translation.alt`, `payment_method.media.translation`.`title` as `payment_method.media.translation.title`, `payment_method.media.translation`.`custom_fields` as `payment_method.media.translation.customFields` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation`.`language_id` = ?) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (?, ?, ?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"Åë~À\x0FUGœ½1Z\x06?è\x14¥" b"´][òjsG±«ð3\x1AE\x7Fõ¾" b"°Þ*\x1FùQLú–WÁ!\x10t×\x19" b"\fdeû\x00”MM¸LI\x1DHª.·" ] |
||||||||||||||||||||
|
2.10 ms (0.25%) |
2 |
SELECT `product_manufacturer`.`id` as `product_manufacturer.id`, `product_manufacturer`.`version_id` as `product_manufacturer.versionId`, `product_manufacturer`.`media_id` as `product_manufacturer.mediaId`, `product_manufacturer`.`link` as `product_manufacturer.link`, `product_manufacturer`.`created_at` as `product_manufacturer.createdAt`, `product_manufacturer`.`updated_at` as `product_manufacturer.updatedAt`, `product_manufacturer.translation.name`, `product_manufacturer.translation.name` as `product_manufacturer.name`, `product_manufacturer.translation.description`, `product_manufacturer.translation.description` as `product_manufacturer.description`, `product_manufacturer.translation.customFields`, `product_manufacturer.translation.customFields` as `product_manufacturer.customFields` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.`product_manufacturer_id`, `product_manufacturer.translation`.`product_manufacturer_version_id`, `product_manufacturer.translation`.`name` as `product_manufacturer.translation.name`, `product_manufacturer.translation`.`description` as `product_manufacturer.translation.description`, `product_manufacturer.translation`.`custom_fields` as `product_manufacturer.translation.customFields` FROM `product_manufacturer_translation` `product_manufacturer.translation` WHERE `product_manufacturer.translation`.`language_id` = ?) `product_manufacturer.product_manufacturer_translation` ON `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product_manufacturer`.`id` AND `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_version_id` = `product_manufacturer`.`version_id` WHERE (`product_manufacturer`.`version_id` = ?) AND (`product_manufacturer`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x15ä╝SXÍLM▓;ÊY╝Ã╬É" ] |
||||||||||||||||||||
|
2.01 ms (0.24%) |
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.title`, `media.translation.title` as `media.title`, `media.translation.alt`, `media.translation.alt` as `media.alt`, `media.translation.customFields`, `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.`media_id`, `media.translation`.`alt` as `media.translation.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation`.`custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation`.`language_id` = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" false true "product_download" b"‹KY†\x06³Oœ”?š!™W‚µ" b"|:├aaëKõÂÙì\x00{eló" ] |
||||||||||||||||||||
|
1.99 ms (0.23%) |
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.name`, `country.translation.name` as `country.name`, `country.translation.addressFormat`, `country.translation.addressFormat` as `country.addressFormat`, `country.translation.customFields`, `country.translation.customFields` as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation`.`country_id`, `country.translation`.`name` as `country.translation.name`, `country.translation`.`custom_fields` as `country.translation.customFields`, `country.translation`.`address_format` as `country.translation.addressFormat` FROM `country_translation` `country.translation` WHERE `country.translation`.`language_id` = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x11w¹£‗¢E8¿\ì®d,e)" ] |
||||||||||||||||||||
|
1.85 ms (0.22%) |
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"‘ùnjÔ±Fçµ¼¾A/a{º"
]
|
||||||||||||||||||||
|
1.78 ms (0.21%) |
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.title`, `media.translation.title` as `media.title`, `media.translation.alt`, `media.translation.alt` as `media.alt`, `media.translation.customFields`, `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.`media_id`, `media.translation`.`alt` as `media.translation.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation`.`custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation`.`language_id` = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" false true "product_download" b"„•ÇŠáÌJ+…\r#kt\x07´b" ] |
||||||||||||||||||||
|
1.69 ms (0.20%) |
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.typeName`, `tax_rule.type.translation.typeName` as `tax_rule.type.typeName` FROM `tax_rule` LEFT JOIN `tax_rule_type` `tax_rule.type` ON `tax_rule`.`tax_rule_type_id` = `tax_rule.type`.`id` LEFT JOIN (SELECT `tax_rule.type.translation`.`tax_rule_type_id`, `tax_rule.type.translation`.`type_name` as `tax_rule.type.translation.typeName` FROM `tax_rule_type_translation` `tax_rule.type.translation` WHERE `tax_rule.type.translation`.`language_id` = ?) `tax_rule.type.tax_rule_type_translation` ON `tax_rule.type.tax_rule_type_translation`.`tax_rule_type_id` = `tax_rule.type`.`id` WHERE (`tax_rule`.`tax_id` IN (?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x1C~o%ÆyO–¦9ÆãŒ\x08]C" b"'Ò\x10##öO°‡-\x0FUbóêp" b"{’ËQæƒAY•NÄþË%¤E" ] |
||||||||||||||||||||
|
1.67 ms (0.20%) |
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
]
|
||||||||||||||||||||
|
1.65 ms (0.19%) |
1 |
# landing-page::cms-page::association::sections::association::blocks::read SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`position` as `cms_block.position`, `cms_block`.`type` as `cms_block.type`, `cms_block`.`locked` as `cms_block.locked`, `cms_block`.`name` as `cms_block.name`, `cms_block`.`section_position` as `cms_block.sectionPosition`, `cms_block`.`margin_top` as `cms_block.marginTop`, `cms_block`.`margin_bottom` as `cms_block.marginBottom`, `cms_block`.`margin_left` as `cms_block.marginLeft`, `cms_block`.`margin_right` as `cms_block.marginRight`, `cms_block`.`background_color` as `cms_block.backgroundColor`, `cms_block`.`background_media_id` as `cms_block.backgroundMediaId`, `cms_block`.`background_media_mode` as `cms_block.backgroundMediaMode`, `cms_block`.`css_class` as `cms_block.cssClass`, `cms_block`.`visibility` as `cms_block.visibility`, `cms_block`.`cms_section_id` as `cms_block.sectionId`, `cms_block`.`custom_fields` as `cms_block.customFields`, `cms_block`.`version_id` as `cms_block.versionId`, `cms_block`.`cms_section_version_id` as `cms_block.cmsSectionVersionId`, `cms_block`.`created_at` as `cms_block.createdAt`, `cms_block`.`updated_at` as `cms_block.updatedAt`, `cms_block.backgroundMedia`.`id` as `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` as `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` as `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` as `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` as `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` as `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` as `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` as `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` as `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` as `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`config` as `cms_block.backgroundMedia.config`, `cms_block.backgroundMedia`.`path` as `cms_block.backgroundMedia.path`, `cms_block.backgroundMedia`.`private` as `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`created_at` as `cms_block.backgroundMedia.createdAt`, `cms_block.backgroundMedia`.`updated_at` as `cms_block.backgroundMedia.updatedAt`, `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation.title` as `cms_block.backgroundMedia.title`, `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation.alt` as `cms_block.backgroundMedia.alt`, `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation.customFields` as `cms_block.backgroundMedia.customFields` FROM `cms_block` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation`.`media_id`, `cms_block.backgroundMedia.translation`.`alt` as `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation`.`title` as `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.`custom_fields` as `cms_block.backgroundMedia.translation.customFields` FROM `media_translation` `cms_block.backgroundMedia.translation` WHERE `cms_block.backgroundMedia.translation`.`language_id` = ?) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation`.`media_id` = `cms_block.backgroundMedia`.`id` WHERE (`cms_block`.`version_id` = ?) AND ((`cms_block`.`cms_section_id` IN (?)))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01ÅN\x05ô÷p│¼¨úaAܨ," ] |
||||||||||||||||||||
|
1.57 ms (0.19%) |
1 |
# landing-page::cms-page::association::sections::read SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`position` as `cms_section.position`, `cms_section`.`type` as `cms_section.type`, `cms_section`.`locked` as `cms_section.locked`, `cms_section`.`name` as `cms_section.name`, `cms_section`.`sizing_mode` as `cms_section.sizingMode`, `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`, `cms_section`.`background_color` as `cms_section.backgroundColor`, `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`, `cms_section`.`css_class` as `cms_section.cssClass`, `cms_section`.`cms_page_id` as `cms_section.pageId`, `cms_section`.`visibility` as `cms_section.visibility`, `cms_section`.`custom_fields` as `cms_section.customFields`, `cms_section`.`version_id` as `cms_section.versionId`, `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`, `cms_section`.`created_at` as `cms_section.createdAt`, `cms_section`.`updated_at` as `cms_section.updatedAt`, `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`config` as `cms_section.backgroundMedia.config`, `cms_section.backgroundMedia`.`path` as `cms_section.backgroundMedia.path`, `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title`, `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt`, `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation.customFields` as `cms_section.backgroundMedia.customFields` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation`.`media_id`, `cms_section.backgroundMedia.translation`.`alt` as `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation`.`title` as `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.`custom_fields` as `cms_section.backgroundMedia.translation.customFields` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation`.`language_id` = ?) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id` WHERE (`cms_section`.`version_id` = ?) AND ((`cms_section`.`cms_page_id` IN (?)))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"┬¿Þes0Iµ¡■>\x0Eì1È<" ] |
||||||||||||||||||||
|
1.29 ms (0.15%) |
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.shortName`, `sales_channel.currency.translation.shortName` as `sales_channel.currency.shortName`, `sales_channel.currency.translation.name`, `sales_channel.currency.translation.name` as `sales_channel.currency.name`, `sales_channel.currency.translation.customFields`, `sales_channel.currency.translation.customFields` as `sales_channel.currency.customFields`, `sales_channel.translation.name`, `sales_channel.translation.name` as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, `sales_channel.translation.homeName` as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, `sales_channel.translation.customFields` as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel`.`currency_id` = `sales_channel.currency`.`id` LEFT JOIN (SELECT `sales_channel.translation`.`sales_channel_id`, `sales_channel.translation`.`name` as `sales_channel.translation.name`, `sales_channel.translation`.`custom_fields` as `sales_channel.translation.customFields`, `sales_channel.translation`.`home_slot_config` as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.`home_enabled` as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.`home_name` as `sales_channel.translation.homeName`, `sales_channel.translation`.`home_meta_title` as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.`home_meta_description` as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.`home_keywords` as `sales_channel.translation.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.`language_id` = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` LEFT JOIN (SELECT `sales_channel.currency.translation`.`currency_id`, `sales_channel.currency.translation`.`short_name` as `sales_channel.currency.translation.shortName`, `sales_channel.currency.translation`.`name` as `sales_channel.currency.translation.name`, `sales_channel.currency.translation`.`custom_fields` as `sales_channel.currency.translation.customFields` FROM `currency_translation` `sales_channel.currency.translation` WHERE `sales_channel.currency.translation`.`language_id` = ?) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation`.`currency_id` = `sales_channel.currency`.`id` WHERE `sales_channel`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"‘ùnjÔ±Fçµ¼¾A/a{º" ] |
||||||||||||||||||||
|
1.19 ms (0.14%) |
1 |
SELECT `base_class` AS `baseClass`, `author` FROM `plugin`
Parameters:
[] |
||||||||||||||||||||
|
1.19 ms (0.14%) |
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.name`, `customer_group.translation.name` as `customer_group.name`, `customer_group.translation.registrationTitle`, `customer_group.translation.registrationTitle` as `customer_group.registrationTitle`, `customer_group.translation.registrationIntroduction`, `customer_group.translation.registrationIntroduction` as `customer_group.registrationIntroduction`, `customer_group.translation.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationOnlyCompanyRegistration` as `customer_group.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationSeoMetaDescription`, `customer_group.translation.registrationSeoMetaDescription` as `customer_group.registrationSeoMetaDescription`, `customer_group.translation.customFields`, `customer_group.translation.customFields` as `customer_group.customFields` FROM `customer_group` LEFT JOIN (SELECT `customer_group.translation`.`customer_group_id`, `customer_group.translation`.`name` as `customer_group.translation.name`, `customer_group.translation`.`custom_fields` as `customer_group.translation.customFields`, `customer_group.translation`.`registration_title` as `customer_group.translation.registrationTitle`, `customer_group.translation`.`registration_introduction` as `customer_group.translation.registrationIntroduction`, `customer_group.translation`.`registration_only_company_registration` as `customer_group.translation.registrationOnlyCompanyRegistration`, `customer_group.translation`.`registration_seo_meta_description` as `customer_group.translation.registrationSeoMetaDescription` FROM `customer_group_translation` `customer_group.translation` WHERE `customer_group.translation`.`language_id` = ?) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation`.`customer_group_id` = `customer_group`.`id` WHERE `customer_group`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"¤¢P\x18ËìAÏ¡╩\x10┘O╚¢Í" ] |
||||||||||||||||||||
|
1.13 ms (0.13%) |
1 |
SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.translation.label`, `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.`product_sorting_id`, `product_sorting.translation`.`label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.`language_id` = ?) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"CáèûžÎFYˆ"¨x\x06÷S˜" ] |
||||||||||||||||||||
|
1.12 ms (0.13%) |
1 |
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[ b"‘ùnjÔ±Fçµ¼¾A/a{º" "2m1Y4xpNvuvECYg2MLpFGhC3OCHMe0DO" ] |
||||||||||||||||||||
|
1.08 ms (0.13%) |
1 |
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||
|
1.08 ms (0.13%) |
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.description`, `theme.translation.description` as `theme.description`, `theme.translation.labels`, `theme.translation.labels` as `theme.labels`, `theme.translation.helpTexts`, `theme.translation.helpTexts` as `theme.helpTexts`, `theme.translation.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`.`labels` as `theme.translation.labels`, `theme.translation`.`help_texts` as `theme.translation.helpTexts`, `theme.translation`.`custom_fields` as `theme.translation.customFields` FROM `theme_translation` `theme.translation` WHERE `theme.translation`.`language_id` = ?) `theme.theme_translation` ON `theme.theme_translation`.`theme_id` = `theme`.`id`
Parameters:
[
b"/»_ââšMpªXTÎ|ãâ\v"
]
|
||||||||||||||||||||
|
1.06 ms (0.12%) |
1 |
#cart-persister::load SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters:
[
"2m1Y4xpNvuvECYg2MLpFGhC3OCHMe0DO"
]
|
||||||||||||||||||||
|
1.03 ms (0.12%) |
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.93 ms (0.11%) |
1 |
# footer-pagelet::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.name`, `shipping_method.deliveryTime.translation.name` as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation.customFields` as `shipping_method.deliveryTime.customFields`, `shipping_method.appShippingMethod`.`id` as `shipping_method.appShippingMethod.id`, `shipping_method.appShippingMethod`.`app_name` as `shipping_method.appShippingMethod.appName`, `shipping_method.appShippingMethod`.`identifier` as `shipping_method.appShippingMethod.identifier`, `shipping_method.appShippingMethod`.`app_id` as `shipping_method.appShippingMethod.appId`, `shipping_method.appShippingMethod`.`shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId`, `shipping_method.appShippingMethod`.`original_media_id` as `shipping_method.appShippingMethod.originalMediaId`, `shipping_method.appShippingMethod`.`created_at` as `shipping_method.appShippingMethod.createdAt`, `shipping_method.appShippingMethod`.`updated_at` as `shipping_method.appShippingMethod.updatedAt`, `shipping_method`.`technical_name` as `shipping_method.technicalName`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.media`.`id` as `shipping_method.media.id`, `shipping_method.media`.`user_id` as `shipping_method.media.userId`, `shipping_method.media`.`media_folder_id` as `shipping_method.media.mediaFolderId`, `shipping_method.media`.`mime_type` as `shipping_method.media.mimeType`, `shipping_method.media`.`file_extension` as `shipping_method.media.fileExtension`, `shipping_method.media`.`uploaded_at` as `shipping_method.media.uploadedAt`, `shipping_method.media`.`file_name` as `shipping_method.media.fileName`, `shipping_method.media`.`file_size` as `shipping_method.media.fileSize`, `shipping_method.media`.`media_type` as `shipping_method.media.mediaTypeRaw`, `shipping_method.media`.`meta_data` as `shipping_method.media.metaData`, `shipping_method.media`.`config` as `shipping_method.media.config`, `shipping_method.media`.`path` as `shipping_method.media.path`, `shipping_method.media`.`private` as `shipping_method.media.private`, `shipping_method.media`.`thumbnails_ro` as `shipping_method.media.thumbnailsRo`, `shipping_method.media`.`created_at` as `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`, `shipping_method.media.translation.title`, `shipping_method.media.translation.title` as `shipping_method.media.title`, `shipping_method.media.translation.alt`, `shipping_method.media.translation.alt` as `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, `shipping_method.media.translation.customFields` as `shipping_method.media.customFields`, `shipping_method.translation.name`, `shipping_method.translation.name` as `shipping_method.name`, `shipping_method.translation.description`, `shipping_method.translation.description` as `shipping_method.description`, `shipping_method.translation.trackingUrl`, `shipping_method.translation.trackingUrl` as `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, `shipping_method.translation.customFields` as `shipping_method.customFields` FROM `shipping_method` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method`.`id` = `shipping_method.appShippingMethod`.`shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name`, `shipping_method.translation`.`custom_fields` as `shipping_method.translation.customFields`, `shipping_method.translation`.`description` as `shipping_method.translation.description`, `shipping_method.translation`.`tracking_url` as `shipping_method.translation.trackingUrl` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation`.`delivery_time_id`, `shipping_method.deliveryTime.translation`.`name` as `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation`.`custom_fields` as `shipping_method.deliveryTime.translation.customFields` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation`.`language_id` = ?) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.`media_id`, `shipping_method.media.translation`.`alt` as `shipping_method.media.translation.alt`, `shipping_method.media.translation`.`title` as `shipping_method.media.translation.title`, `shipping_method.media.translation`.`custom_fields` as `shipping_method.media.translation.customFields` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation`.`language_id` = ?) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (?, ?, ?, ?, ?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"5lf\r¿IBˆ ’AŸøÊÆg" b"U¡\x1CX£sJ\¯\x12îÉY+5'" b"ш«\tÅ\tH\x1D– \U×T¸K" b"Ó\x0E,ƒHÎMÉòצ³\x11\x7F¡\x01" b"v\x07•\•NN&›Üö’o‡Àæ" b"ûA\x15\x1FD\x1CC,‡¿\x04 \x14šÛã" ] |
||||||||||||||||||||
|
0.86 ms (0.10%) |
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.name`, `language.translationCode.translation.name` as `language.translationCode.name`, `language.translationCode.translation.territory`, `language.translationCode.translation.territory` as `language.translationCode.territory`, `language.translationCode.translation.customFields`, `language.translationCode.translation.customFields` as `language.translationCode.customFields` FROM `language` LEFT JOIN `product_search_config` `language.productSearchConfig` ON `language`.`id` = `language.productSearchConfig`.`language_id` LEFT JOIN `locale` `language.translationCode` ON `language`.`translation_code_id` = `language.translationCode`.`id` LEFT JOIN (SELECT `language.translationCode.translation`.`locale_id`, `language.translationCode.translation`.`name` as `language.translationCode.translation.name`, `language.translationCode.translation`.`territory` as `language.translationCode.translation.territory`, `language.translationCode.translation`.`custom_fields` as `language.translationCode.translation.customFields` FROM `locale_translation` `language.translationCode.translation` WHERE `language.translationCode.translation`.`language_id` = ?) `language.translationCode.locale_translation` ON `language.translationCode.locale_translation`.`locale_id` = `language.translationCode`.`id` WHERE `language`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" ] |
||||||||||||||||||||
|
0.76 ms (0.09%) |
1 |
# product-listing-route::loading::association::prices::read SELECT `product_price`.`id` as `product_price.id`, `product_price`.`version_id` as `product_price.versionId`, `product_price`.`product_id` as `product_price.productId`, `product_price`.`product_version_id` as `product_price.productVersionId`, `product_price`.`rule_id` as `product_price.ruleId`, `product_price`.`price` as `product_price.price`, `product_price`.`quantity_start` as `product_price.quantityStart`, `product_price`.`quantity_end` as `product_price.quantityEnd`, `product_price`.`custom_fields` as `product_price.customFields`, `product_price`.`created_at` as `product_price.createdAt`, `product_price`.`updated_at` as `product_price.updatedAt` FROM `product_price` WHERE (`product_price`.`version_id` = ?) AND ((`product_price`.`product_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)))
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x05ÚD•äÁJy•\x1AïÐäs’Ê" b"\x07!\x08ÖŠåL¿”°ÍîByF²" b"\t\x13ex=XAï³&àn5\x15èc" b"\x0Ef¬p.§@M¬\x06b”MHš]" b"\x12ö└\x08▀AÅ\x04øÌÂ[02┴2" b"\x15×Ö\x1DÎì/<IÁFó6CØ" b"\x16Õöܯ[Ÿ$Æÿœ\rrêÃœ" b"\x1AFû▄Z■\x03═40/Zì\x11S«" b"#JFq'5J”«Þ'\x1Emâ.ð" b"&Í“ª—\x1DBl±\x1D”âþ¿o7" b"/\tuT2·ÀwZT·Ú¹³‘(" b"1ı░\x1EÈ\x1AGìdÄ#yõƒçy" b"5o…ÊÕ^DΓ<Š¡ÙBõD" b"9uØù§HOü’{ÜŒ¥¶8x" b"=\x08/£¼\x1CE€Œiu\x13t„*q" b"B¨\x13ä7÷BÈ£µÐL-2¤v" b"D█=È KØâ\x02Ô3ï"O#" b"F‗\x1D¼LÈ░\x13Í2 \x06╣Ú»Ø" b"Gl_šÎ#Oe¶\x7F\x0EfLïkM" b"OhUÁ¾ÎÊŸ\x1AA(±\x1EÈ\¯" b"S¾“\x13›OC Ž\x07\x11ù\x071ÿ¿" b"bDCæ‘ìÜ“ø\x1DuL®1\x02`" b"e¦ƒ\x03V¹äNµãƒ\x1DÅmÿÅ" b"mDã–ÄùxDj¢ NtÓ7;" b"m»±AÆ÷CU¼‹ÈCàˆüñ" b"mÐul0[F̶ÛJWª?\x18˜" b"nJ┌ø´vIïºÃ\x06?ÆÛ\x17ì" b"r[r>W\x0EFy¾E¨Ü\x1CF\x0F¬" b"x©fèC\x04Žµh‘\x1CFÊî\x1D7" b""" xÈXüw¦ìQ\n \rÒÔ;\x1D÷æ """ b"z8t"│xH\x07ì²Þ%DS■┌" b"üHøìË┤Go┐ß«û¦^ö┌" b"ÉÏï:®┌H#íªFm\x08½¦¤" b"‘\f,è÷gLÖ•$Kò-/¾í" b"’<\x1D‹\r'´\tãáXeÉ\e\x17;" b"™„Ú1yEô\x00C\x1AÀ\x1C,(Ñ8" b"áË?+ØILøæ\x07\t─<ält" b"¥j›’7„D¬±+7±\x16VŠi" b"§U\x08;¢\x1CG{§Sq1fÞð\x06" b""" ¨\x14ÒÃÕÕ©R8þåí‰\n •T """ b"¯ÏÚ¼'YH!²Û¸œÿ\v\x02ƒ" b"¥×ÖâäDK\x07üFÂÝÃ╣úf" b"┴/u)KZ@¢£ÿïͨ&gü" b"Áv]DîÜC\x1F¢›·Ï:œûj" b"¤\x18│z|Of\x05É█}«\x076\t\x1D" b"ÛVO^–ŸL†¯£_$¬³Æú" b"ßév7\vdN!¢ê×5£™Ci" b"íõ‡×tkG§ŠDAŒ8— k" ] |
||||||||||||||||||||
|
0.66 ms (0.08%) |
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"‘ùnjÔ±Fçµ¼¾A/a{º"
]
|
||||||||||||||||||||
|
0.66 ms (0.08%) |
2 |
# 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.title`, `category.media.translation.title` as `category.media.title`, `category.media.translation.alt`, `category.media.translation.alt` as `category.media.alt`, `category.media.translation.customFields`, `category.media.translation.customFields` as `category.media.customFields`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.`language_id` = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"Ê‘\f•ÏâO\x0F®á\x00‘\x14rÀ{" ] |
||||||||||||||||||||
|
0.55 ms (0.07%) |
1 |
# app-scripts::refresh::search-ids SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ? AND `app`.`self_managed` = ?)
Parameters:
[ true false ] |
||||||||||||||||||||
|
0.52 ms (0.06%) |
2 |
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters:
[ null "IntediaDoofinderSW6.config.%" ] |
||||||||||||||||||||
|
0.47 ms (0.06%) |
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"‘ùnjÔ±Fçµ¼¾A/a{º" b"\x11w¹£‗¢E8¿\ì®d,e)" ] |
||||||||||||||||||||
|
0.46 ms (0.05%) |
1 |
SELECT LOWER(HEX(`language.salesChannels.mapping`.`sales_channel_id`)) as `key`, GROUP_CONCAT(LOWER(HEX(`language.salesChannels.mapping`.`language_id`)) ) as `value` FROM `language` LEFT JOIN `sales_channel_language` `language.salesChannels.mapping` ON `language.salesChannels.mapping`.`language_id` = `language`.id WHERE ((`language`.`id` = ?)) AND (`language.salesChannels.mapping`.`sales_channel_id` IN (?)) GROUP BY `language.salesChannels.mapping`.`sales_channel_id`
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"‘ùnjÔ±Fçµ¼¾A/a{º" ] |
||||||||||||||||||||
|
0.46 ms (0.05%) |
1 |
# footer-pagelet::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` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `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.name`)) ASC
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" true b"‘ùnjÔ±Fçµ¼¾A/a{º" ] |
||||||||||||||||||||
|
0.45 ms (0.05%) |
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.44 ms (0.05%) |
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"‘ùnjÔ±Fçµ¼¾A/a{º"
]
|
||||||||||||||||||||
|
0.41 ms (0.05%) |
1 |
# product-listing::property-filter::search-ids SELECT `property_group_option`.`id` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` WHERE ((`property_group_option.group`.`filterable` = ?)) AND (`property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY `property_group_option`.`id` ASC LIMIT 500
Parameters:
[ true b"\x02ÿ˜\x01›B\x02 ßy÷|%”ü" b"\x05hà¥:/B\x7F¦\x15ï²›ò¤õ" b"%ô\t\x15àü@x»êÒÑ&å3É" b"+\x05&Vs`KÒŸeCƺwiÆ" b"=ߣKrÐL^Š\x0F™\e{=IÏ" b"ƒ"[YÅ—J\x16ªóö\x056\x17\x1E" b"ìl╚&C:L(×tÎbãƒti" b"ôJ.█\x02\x03IÒ▒,¶µGáêÉ" b"—l‰\x01A.Nn¥5hÎ\x12öõÓ" b""" ¢\t\x07\n ˜0KÀ²/wÆ,Ðùú """ b"¤¹0C«ÄC¸¾þUÊåÝ®6" b"²c\x17ìÉ\x16Jf·¦Ú^ÅRU`" b"╚╦üÆ÷tNrº6P$jý!╦" b"ÛŒ˜?.%I%•Òºõ— \x12›" b"âØÖ’å0O|œÿ9\x11"-–y" b"ÞßéÈ░├Fjìe║é\x1F‗¦╚" b"ñý\x14-Y[Ný‰ŒÈ ’\t|N" ] |
||||||||||||||||||||
|
0.41 ms (0.05%) |
1 |
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"Ê‘\f•ÏâO\x0F®á\x00‘\x14rÀ{" ] |
||||||||||||||||||||
|
0.40 ms (0.05%) |
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"\x00\vk\ÊgFqµ\x1Fö\x12†%™“" b"\x18ÛÁ^\x08yK覎h2¯wn\x7F" b"\ÔÿØ\x1EÑGʪú\x03\vP█ºï" b"z>I£┼┼N\x13Øû7┴µ└╗L" b"€R¶DÀ™I…@ÏO¥hH\x04" b"ƒ\x0E"=┤;DãÉ3DG`KF\x08" b"ú▒\x1Cü÷¦A]╗Â1c«^╬ƒ" b"¤åíeæ‚@ÁšSb¨Ø\x19\x1Eg" b"¾Ú»^1\x0FAe¦Xߤ\eÎ\x11¯" b"Á‘¼òñ;Cöœû7Ó³p]{" b"³þ\x16Ñì\x08G.ÀÝÇI:4SÂ" b"\fE\x016†CLFŠ2h/"ñd‰" b"“\x1E\x1A½\x120Lí¯&“!òŽ¾6" b"\x01ì´;{\x10xsî)X\x06Þk»Ù" b"\x01Ž½\x16 •{8ª_\x17\eVOJ(" b"\x01ŽÈ¬ßsx\x1A£öÞ‹îqžú" b"\x01Ä═\x07ß*{÷©%-j¿ üÓ" b"\x01ŽÖ‚Ãgq¼¤—“—ÎXŸ" b"\x01Å\x1F~■\x12\x7F╩®ôsS+¨\x01-" b"\x01Å®ïëD\x7F║ö`┘\x16╔▓╠È" b"\x01Å®ÉW4w~âwb┌⃩" b"\x01űðú╦{>£É▓VÖ╝ö\x14" b"\x01űÎl/z÷ÂXíUØ@x"" b"\x01Å‗├╬‗p╩ÿÕ¯Æ┬¡ÌÑ" b"\x01É+±\x1A╚v,¬─`·┬╬P¡" b"\x01‘\x04\x11äî\x7F2˜\tÝÄú‰\x14¶" b"\x01‘\x041÷ÂxÆ°;4\x1FE¤Bï" b"\x01‘\t€+u|Ö¤Ñ+5o±76" b"\x01‘\x0E-ãYs7…5¢ i\x1A$¡" b"\x01‘F:vÎ}@¹Ó†¦\x12RsÍ" b"\x01æ\x7Fu8={;ü─\x01\x167R\x04é" b"\x01æÿ3ý╣r²ÉD'\x06╔~\x07" b""" \x01Æ\n ■U╠~L┐ÀØrixÄ¡ """ b"\x01Æ\x1F-ØS}ðù\x7FYü§?Ø\t" b"\x01’\x1FUý•sv©\x19½Ãº\x0F\t\x06" b"\x01Æ\x1Fkæp|!Áª×¿─║ÅÛ" b"\x01’Ü”K½sP¨ÂÈ\x02»5\tš" b""" \x01’ÜÊ‹\r}\n °\x03\BL[˜¦ """ b"\x01’ÜõÊrrM¥Y+Ò?\x1D?Û" b"\x01’ÝJ\x14Êt\x00†Ž›™+‚ÊG" b"\x01’ÝW(öqêª\fý5}ÔÝÂ" b"\x01ôd\x03\x11+u▓╣É█å\x0FıÁI" b""" \n bÇT.»Nܦ6ÐÇô^/ã """ b"\va\x10Ó¹ƒ@Û“yD¿«\x7F\x0F" b"\x19Ä\x7FMéìGÖ¨1J°æÞLÿ" b"\x1A"óɤ\x04@\x07 ÔÉ°=Àª+" b"\eû.Î>ÚKO‰'´¢\x17a2Æ" b"\x1FR¿ÃÍÜLZ²\x15uÈ¿‡!B" b"\x1FÒÒ¾À˜K]<Uç˜G\x05É" b".±)ÿ“\tB…ƒ§³¢êøþÂ" b"3þåa7ûH0‹Ç1»Íá£C" b""" 5—\n Ÿß™J^¶|µtfãè| """ b"9\x16ÇÑ]ŒE\x19ž|¥,nè^E" b">7~sW°H\x05¢÷~Ö]ˆ?õ" b"C.r”çfHuKp²`wÕŽ" b"D\x07ÊïlBA\t˜ËØ\x10Åh«%" b"F´\x06E\x12ûDk¢÷uÚÁ(SC" b"GN\x1E\x03╩õFs▒Îü{÷I¬T" b"R\x05#"-"Aª×ØaáÛî{Ñ" b"d\x16Â┤ÉÿIj╗·Ø\x13µu_û" b"d®©8\x07╠FÁü─{xg_bû" b"hëSªÇš@Ù¬ÚSpïHþª" b"l—²¢ÞÙM“¶mè'ëµ\x18\x1C" b"’šK\t\x06UJ^½|\x02_\x1Aï½\x17" b"©¶Ô¯\x19ûJ\x1C«©Òlu¨Éj" b"░GƒkÙÅF¿âR▓\x0F`ݵ]" b"▒┼├Ø\rîAþñÍ.ÌÝ.¾Ý" b"±ÌŽe"\x12E—§NpŒ»\x121Y" b"´WP“¥@FÁ¨}\x17ph®ÂÅ" b"¶ÿÙ¦ó“N—¬+ú3Z½\fÂ" b"¿ÿz®\x08A\v ÙX~è·ip" b"ÇSæê×M\x12Ÿ["¥®…ì³" b"ȹ&ŽjDL.Œ$£Ò8\x02ëø" b"ËÚŽ\x01†)Là¡Ä/”EJÑ1" b"Ï}A‡M1@\x17©/\x01}Ú”yI" b"Ô½²À{RLó€x7XOŒ\x15f" b"Ö¬¤Z\x18gD”Š\x0FCÛåÎ\x1E—" b"à÷c\e¥¡BV·)…EˆÐë" b"ìR… …\x1CĶt\x07êK\x08¼æ" b"îðÌj\x1A¾Fƶ¥§ZD(ðm" b"ýœås\x16,H/¥\x1DWì¹ôúž" b"\x1FÈdóÚ”G¶™èIµ`JcØ" ] |
||||||||||||||||||||
|
0.40 ms (0.05%) |
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"‘ùnjÔ±Fçµ¼¾A/a{º"
]
|
||||||||||||||||||||
|
0.39 ms (0.05%) |
1 |
# footer-pagelet::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"‘ùnjÔ±Fçµ¼¾A/a{º" ] |
||||||||||||||||||||
|
0.36 ms (0.04%) |
1 |
SELECT `sales_channel_domain`.`id` as `sales_channel_domain.id`, `sales_channel_domain`.`url` as `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt`, `sales_channel_domain.language`.`id` as `sales_channel_domain.language.id`, `sales_channel_domain.language`.`parent_id` as `sales_channel_domain.language.parentId`, `sales_channel_domain.language`.`locale_id` as `sales_channel_domain.language.localeId`, `sales_channel_domain.language`.`translation_code_id` as `sales_channel_domain.language.translationCodeId`, `sales_channel_domain.language`.`name` as `sales_channel_domain.language.name`, `sales_channel_domain.language`.`custom_fields` as `sales_channel_domain.language.customFields`, `sales_channel_domain.language`.`created_at` as `sales_channel_domain.language.createdAt`, `sales_channel_domain.language`.`updated_at` as `sales_channel_domain.language.updatedAt`, `sales_channel_domain.language.locale`.`id` as `sales_channel_domain.language.locale.id`, `sales_channel_domain.language.locale`.`code` as `sales_channel_domain.language.locale.code`, `sales_channel_domain.language.locale`.`created_at` as `sales_channel_domain.language.locale.createdAt`, `sales_channel_domain.language.locale`.`updated_at` as `sales_channel_domain.language.locale.updatedAt`, `sales_channel_domain.language.locale.translation.name`, `sales_channel_domain.language.locale.translation.name` as `sales_channel_domain.language.locale.name`, `sales_channel_domain.language.locale.translation.territory`, `sales_channel_domain.language.locale.translation.territory` as `sales_channel_domain.language.locale.territory`, `sales_channel_domain.language.locale.translation.customFields`, `sales_channel_domain.language.locale.translation.customFields` as `sales_channel_domain.language.locale.customFields`, `sales_channel_domain.currency`.`id` as `sales_channel_domain.currency.id`, `sales_channel_domain.currency`.`factor` as `sales_channel_domain.currency.factor`, `sales_channel_domain.currency`.`symbol` as `sales_channel_domain.currency.symbol`, `sales_channel_domain.currency`.`iso_code` as `sales_channel_domain.currency.isoCode`, `sales_channel_domain.currency`.`position` as `sales_channel_domain.currency.position`, `sales_channel_domain.currency`.`tax_free_from` as `sales_channel_domain.currency.taxFreeFrom`, `sales_channel_domain.currency`.`item_rounding` as `sales_channel_domain.currency.itemRounding`, `sales_channel_domain.currency`.`total_rounding` as `sales_channel_domain.currency.totalRounding`, `sales_channel_domain.currency`.`created_at` as `sales_channel_domain.currency.createdAt`, `sales_channel_domain.currency`.`updated_at` as `sales_channel_domain.currency.updatedAt`, `sales_channel_domain.currency.translation.shortName`, `sales_channel_domain.currency.translation.shortName` as `sales_channel_domain.currency.shortName`, `sales_channel_domain.currency.translation.name`, `sales_channel_domain.currency.translation.name` as `sales_channel_domain.currency.name`, `sales_channel_domain.currency.translation.customFields`, `sales_channel_domain.currency.translation.customFields` as `sales_channel_domain.currency.customFields` FROM `sales_channel_domain` LEFT JOIN `language` `sales_channel_domain.language` ON `sales_channel_domain`.`language_id` = `sales_channel_domain.language`.`id` LEFT JOIN `currency` `sales_channel_domain.currency` ON `sales_channel_domain`.`currency_id` = `sales_channel_domain.currency`.`id` LEFT JOIN `locale` `sales_channel_domain.language.locale` ON `sales_channel_domain.language`.`locale_id` = `sales_channel_domain.language.locale`.`id` LEFT JOIN (SELECT `sales_channel_domain.language.locale.translation`.`locale_id`, `sales_channel_domain.language.locale.translation`.`name` as `sales_channel_domain.language.locale.translation.name`, `sales_channel_domain.language.locale.translation`.`territory` as `sales_channel_domain.language.locale.translation.territory`, `sales_channel_domain.language.locale.translation`.`custom_fields` as `sales_channel_domain.language.locale.translation.customFields` FROM `locale_translation` `sales_channel_domain.language.locale.translation` WHERE `sales_channel_domain.language.locale.translation`.`language_id` = ?) `sales_channel_domain.language.locale.locale_translation` ON `sales_channel_domain.language.locale.locale_translation`.`locale_id` = `sales_channel_domain.language.locale`.`id` LEFT JOIN (SELECT `sales_channel_domain.currency.translation`.`currency_id`, `sales_channel_domain.currency.translation`.`short_name` as `sales_channel_domain.currency.translation.shortName`, `sales_channel_domain.currency.translation`.`name` as `sales_channel_domain.currency.translation.name`, `sales_channel_domain.currency.translation`.`custom_fields` as `sales_channel_domain.currency.translation.customFields` FROM `currency_translation` `sales_channel_domain.currency.translation` WHERE `sales_channel_domain.currency.translation`.`language_id` = ?) `sales_channel_domain.currency.currency_translation` ON `sales_channel_domain.currency.currency_translation`.`currency_id` = `sales_channel_domain.currency`.`id` WHERE `sales_channel_domain`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"XÕ\x1DéâŒMs´½™»\x03Ã…" ] |
||||||||||||||||||||
|
0.34 ms (0.04%) |
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.33 ms (0.04%) |
1 |
# manufacturer-aggregation::read SELECT `product_manufacturer`.`id` as `product_manufacturer.id`, `product_manufacturer`.`version_id` as `product_manufacturer.versionId`, `product_manufacturer`.`media_id` as `product_manufacturer.mediaId`, `product_manufacturer`.`link` as `product_manufacturer.link`, `product_manufacturer`.`created_at` as `product_manufacturer.createdAt`, `product_manufacturer`.`updated_at` as `product_manufacturer.updatedAt`, `product_manufacturer.translation.name`, `product_manufacturer.translation.name` as `product_manufacturer.name`, `product_manufacturer.translation.description`, `product_manufacturer.translation.description` as `product_manufacturer.description`, `product_manufacturer.translation.customFields`, `product_manufacturer.translation.customFields` as `product_manufacturer.customFields` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.`product_manufacturer_id`, `product_manufacturer.translation`.`product_manufacturer_version_id`, `product_manufacturer.translation`.`name` as `product_manufacturer.translation.name`, `product_manufacturer.translation`.`description` as `product_manufacturer.translation.description`, `product_manufacturer.translation`.`custom_fields` as `product_manufacturer.translation.customFields` FROM `product_manufacturer_translation` `product_manufacturer.translation` WHERE `product_manufacturer.translation`.`language_id` = ?) `product_manufacturer.product_manufacturer_translation` ON `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product_manufacturer`.`id` AND `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_version_id` = `product_manufacturer`.`version_id` WHERE (`product_manufacturer`.`version_id` = ?) AND (`product_manufacturer`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x15ä╝SXÍLM▓;ÊY╝Ã╬É" ] |
||||||||||||||||||||
|
0.32 ms (0.04%) |
1 |
# sales-channel::load-analytics::read SELECT `sales_channel_analytics`.`id` as `sales_channel_analytics.id`, `sales_channel_analytics`.`tracking_id` as `sales_channel_analytics.trackingId`, `sales_channel_analytics`.`active` as `sales_channel_analytics.active`, `sales_channel_analytics`.`track_orders` as `sales_channel_analytics.trackOrders`, `sales_channel_analytics`.`anonymize_ip` as `sales_channel_analytics.anonymizeIp`, `sales_channel_analytics`.`created_at` as `sales_channel_analytics.createdAt`, `sales_channel_analytics`.`updated_at` as `sales_channel_analytics.updatedAt` FROM `sales_channel_analytics` WHERE `sales_channel_analytics`.`id` IN (?)
Parameters:
[
b"æOá\x05█©A\x12£)/v■┘ìf"
]
|
||||||||||||||||||||
|
0.31 ms (0.04%) |
1 |
SELECT `intedia_doofinder_layer`.`id` as `intedia_doofinder_layer.id`, `intedia_doofinder_layer`.`doofinder_channel_id` as `intedia_doofinder_layer.doofinderChannelId`, `intedia_doofinder_layer`.`doofinder_hash_id` as `intedia_doofinder_layer.doofinderHashId`, `intedia_doofinder_layer`.`doofinder_store_id` as `intedia_doofinder_layer.doofinderStoreId`, `intedia_doofinder_layer`.`domain_id` as `intedia_doofinder_layer.domainId`, `intedia_doofinder_layer`.`trigger` as `intedia_doofinder_layer.trigger`, `intedia_doofinder_layer`.`name` as `intedia_doofinder_layer.name`, `intedia_doofinder_layer`.`status` as `intedia_doofinder_layer.status`, `intedia_doofinder_layer`.`status_message` as `intedia_doofinder_layer.statusMessage`, `intedia_doofinder_layer`.`status_date` as `intedia_doofinder_layer.statusDate`, `intedia_doofinder_layer`.`status_received_date` as `intedia_doofinder_layer.statusReceivedDate`, `intedia_doofinder_layer`.`created_at` as `intedia_doofinder_layer.createdAt`, `intedia_doofinder_layer`.`updated_at` as `intedia_doofinder_layer.updatedAt` FROM `intedia_doofinder_layer` WHERE (`intedia_doofinder_layer`.`domain_id` = ?)
Parameters:
[
b"XÕ\x1DéâŒMs´½™»\x03Ã…"
]
|
||||||||||||||||||||
|
0.31 ms (0.04%) |
1 |
SELECT `pickware_shipping_sales_channel_api_context`.`sales_channel_context_token` as `pickware_shipping_sales_channel_api_context.salesChannelContextToken`, `pickware_shipping_sales_channel_api_context`.`payload` as `pickware_shipping_sales_channel_api_context.payload`, `pickware_shipping_sales_channel_api_context`.`created_at` as `pickware_shipping_sales_channel_api_context.createdAt`, `pickware_shipping_sales_channel_api_context`.`updated_at` as `pickware_shipping_sales_channel_api_context.updatedAt` FROM `pickware_shipping_sales_channel_api_context` WHERE `pickware_shipping_sales_channel_api_context`.`sales_channel_context_token` IN (?)
Parameters:
[
"2m1Y4xpNvuvECYg2MLpFGhC3OCHMe0DO"
]
|
||||||||||||||||||||
|
0.30 ms (0.04%) |
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"Åë~À\x0FUGœ½1Z\x06?è\x14¥"
]
|
||||||||||||||||||||
|
0.26 ms (0.03%) |
2 |
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
|
||||||||||||||||||||
|
0.26 ms (0.03%) |
1 |
# 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.title`, `category.media.translation.title` as `category.media.title`, `category.media.translation.alt`, `category.media.translation.alt` as `category.media.alt`, `category.media.translation.customFields`, `category.media.translation.customFields` as `category.media.customFields`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.`language_id` = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b""" C/A¦aKI«™SË\n „&¼\x12 """ b".×X¤À‚AI°\v¾Ô~ýIq" ] |
||||||||||||||||||||
|
0.23 ms (0.03%) |
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"‘ùnjÔ±Fçµ¼¾A/a{º" b"‘ùnjÔ±Fçµ¼¾A/a{º" ] |
||||||||||||||||||||
|
0.20 ms (0.02%) |
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.19 ms (0.02%) |
1 |
# product-listing-route::category-loading::read SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"Ê‘\f•ÏâO\x0F®á\x00‘\x14rÀ{" ] |
||||||||||||||||||||
|
0.19 ms (0.02%) |
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.title`, `media.translation.title` as `media.title`, `media.translation.alt`, `media.translation.alt` as `media.alt`, `media.translation.customFields`, `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.`media_id`, `media.translation`.`alt` as `media.translation.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation`.`custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation`.`language_id` = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" false true "product_download" b"‹KY†\x06³Oœ”?š!™W‚µ" b"‹KY†\x06³Oœ”?š!™W‚µ" b"‹KY†\x06³Oœ”?š!™W‚µ" b"|:├aaëKõÂÙì\x00{eló" ] |
||||||||||||||||||||
|
0.18 ms (0.02%) |
1 |
# product-price-calculator::units::read SELECT `unit`.`id` as `unit.id`, `unit`.`created_at` as `unit.createdAt`, `unit`.`updated_at` as `unit.updatedAt`, `unit.translation.shortCode`, `unit.translation.shortCode` as `unit.shortCode`, `unit.translation.name`, `unit.translation.name` as `unit.name`, `unit.translation.customFields`, `unit.translation.customFields` as `unit.customFields` FROM `unit` LEFT JOIN (SELECT `unit.translation`.`unit_id`, `unit.translation`.`short_code` as `unit.translation.shortCode`, `unit.translation`.`name` as `unit.translation.name`, `unit.translation`.`custom_fields` as `unit.translation.customFields` FROM `unit_translation` `unit.translation` WHERE `unit.translation`.`language_id` = ?) `unit.unit_translation` ON `unit.unit_translation`.`unit_id` = `unit`.`id`
Parameters:
[
b"/»_ââšMpªXTÎ|ãâ\v"
]
|
||||||||||||||||||||
|
0.15 ms (0.02%) |
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.shortName`, `currency.translation.shortName` as `currency.shortName`, `currency.translation.name`, `currency.translation.name` as `currency.name`, `currency.translation.customFields`, `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation`.`currency_id`, `currency.translation`.`short_name` as `currency.translation.shortName`, `currency.translation`.`name` as `currency.translation.name`, `currency.translation`.`custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.`language_id` = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ" ] |
||||||||||||||||||||
|
0.15 ms (0.02%) |
1 |
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"\x00\vk\ÊgFqµ\x1Fö\x12†%™“" b"\ÔÿØ\x1EÑGʪú\x03\vP█ºï" b"¾Ú»^1\x0FAe¦Xߤ\eÎ\x11¯" b"Á‘¼òñ;Cöœû7Ó³p]{" b"\x01ŽÈ¬ßsx\x1A£öÞ‹îqžú" b"\eû.Î>ÚKO‰'´¢\x17a2Æ" b"d\x16Â┤ÉÿIj╗·Ø\x13µu_û" b"░GƒkÙÅF¿âR▓\x0F`ݵ]" ] |
||||||||||||||||||||
|
0.14 ms (0.02%) |
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.14 ms (0.02%) |
1 |
# product-listing::property-filter::search-ids SELECT `property_group_option`.`id` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` WHERE ((`property_group_option.group`.`filterable` = ?)) AND (`property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY `property_group_option`.`id` ASC LIMIT 500 OFFSET 500
Parameters:
[ true b"\x02ÿ˜\x01›B\x02 ßy÷|%”ü" b"\x05hà¥:/B\x7F¦\x15ï²›ò¤õ" b"%ô\t\x15àü@x»êÒÑ&å3É" b"+\x05&Vs`KÒŸeCƺwiÆ" b"=ߣKrÐL^Š\x0F™\e{=IÏ" b"ƒ"[YÅ—J\x16ªóö\x056\x17\x1E" b"ìl╚&C:L(×tÎbãƒti" b"ôJ.█\x02\x03IÒ▒,¶µGáêÉ" b"—l‰\x01A.Nn¥5hÎ\x12öõÓ" b""" ¢\t\x07\n ˜0KÀ²/wÆ,Ðùú """ b"¤¹0C«ÄC¸¾þUÊåÝ®6" b"²c\x17ìÉ\x16Jf·¦Ú^ÅRU`" b"╚╦üÆ÷tNrº6P$jý!╦" b"ÛŒ˜?.%I%•Òºõ— \x12›" b"âØÖ’å0O|œÿ9\x11"-–y" b"ÞßéÈ░├Fjìe║é\x1F‗¦╚" b"ñý\x14-Y[Ný‰ŒÈ ’\t|N" ] |
||||||||||||||||||||
|
0.13 ms (0.02%) |
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.description`, `theme.translation.description` as `theme.description`, `theme.translation.labels`, `theme.translation.labels` as `theme.labels`, `theme.translation.helpTexts`, `theme.translation.helpTexts` as `theme.helpTexts`, `theme.translation.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`.`labels` as `theme.translation.labels`, `theme.translation`.`help_texts` as `theme.translation.helpTexts`, `theme.translation`.`custom_fields` as `theme.translation.customFields` FROM `theme_translation` `theme.translation` WHERE `theme.translation`.`language_id` = ?) `theme.theme_translation` ON `theme.theme_translation`.`theme_id` = `theme`.`id` WHERE `theme`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"TÑYщcOÀ§Ëe”aô¢ï" ] |
||||||||||||||||||||
|
0.13 ms (0.02%) |
1 |
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.name`, `language.locale.translation.name` as `language.locale.name`, `language.locale.translation.territory`, `language.locale.translation.territory` as `language.locale.territory`, `language.locale.translation.customFields`, `language.locale.translation.customFields` as `language.locale.customFields` FROM `language` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.locale.translation`.`locale_id`, `language.locale.translation`.`name` as `language.locale.translation.name`, `language.locale.translation`.`territory` as `language.locale.translation.territory`, `language.locale.translation`.`custom_fields` as `language.locale.translation.customFields` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation`.`language_id` = ?) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE `language`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" ] |
||||||||||||||||||||
|
0.13 ms (0.02%) |
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:
[]
|
||||||||||||||||||||
|
0.12 ms (0.01%) |
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.12 ms (0.01%) |
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.shortName`, `currency.translation.shortName` as `currency.shortName`, `currency.translation.name`, `currency.translation.name` as `currency.name`, `currency.translation.customFields`, `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation`.`currency_id`, `currency.translation`.`short_name` as `currency.translation.shortName`, `currency.translation`.`name` as `currency.translation.name`, `currency.translation`.`custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.`language_id` = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ" ] |
||||||||||||||||||||
|
0.11 ms (0.01%) |
1 |
# product-listing::load-sortings::read SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.translation.label`, `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.`product_sorting_id`, `product_sorting.translation`.`label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.`language_id` = ?) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (?, ?, ?, ?, ?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"¸\x1F\tè_qAÀ«áá±m¼çf" b"°ðéDivL8Ž\ýð¢ÐßN" b"N쌡\x7F\x05M\x1CŠ1û%|äVt" b"‹\x01Ü€‰ØH³©0JÞn‚4@" b"CáèûžÎFYˆ"¨x\x06÷S˜" b"¯¢æ=ÓMäƒ\x12á#_¯"Û" ] |
||||||||||||||||||||
|
0.10 ms (0.01%) |
1 |
SELECT `handler_identifier`, LOWER(HEX(`id`)) FROM `payment_method`
Parameters:
[] |
||||||||||||||||||||
|
0.08 ms (0.01%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters:
[ b"‘ùnjÔ±Fçµ¼¾A/a{º" "Sendinblue.%" ] |
||||||||||||||||||||
|
0.07 ms (0.01%) |
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.06 ms (0.01%) |
1 |
# product-listing::load-sortings::search-ids SELECT `product_sorting`.`id` FROM `product_sorting` WHERE (`product_sorting`.`active` = ?) ORDER BY `product_sorting`.`priority` DESC
Parameters:
[
true
]
|
||||||||||||||||||||
|
0.06 ms (0.01%) |
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"‘ùnjÔ±Fçµ¼¾A/a{º"
]
|
||||||||||||||||||||
|
0.06 ms (0.01%) |
1 |
SELECT path FROM category WHERE id = ?
Parameters:
[
b"Ê‘\f•ÏâO\x0F®á\x00‘\x14rÀ{"
]
|
||||||||||||||||||||
|
0.05 ms (0.01%) |
1 |
SELECT `language`.`id` FROM `language` WHERE `language`.`id` IN (?) LIMIT 1
Parameters:
[
b"/»_ââšMpªXTÎ|ãâ\v"
]
|
||||||||||||||||||||
|
0.04 ms (0.00%) |
1 |
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
"de-DE"
]
|
||||||||||||||||||||
|
0.04 ms (0.00%) |
1 |
SELECT min_search_length FROM product_search_config WHERE language_id = ?
Parameters:
[
b"/»_ââšMpªXTÎ|ãâ\v"
]
|
||||||||||||||||||||
|
0.03 ms (0.00%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[] |
||||||||||||||||||||
|
0.03 ms (0.00%) |
1 |
SELECT iso FROM snippet_set WHERE id = ?
Parameters:
[
b"ﮨ™°\tIô»\tÀCÍP4\e"
]
|
||||||||||||||||||||
|
0.03 ms (0.00%) |
1 |
SELECT `name`, `path`, `author`, `self_managed` FROM `app` WHERE `active` = 1
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| 0 | default |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.