Query Metrics
81
Database Queries
55
Different statements
33.29 ms
Query time
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
4.68 ms (14.07%) |
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:
[ "/detail/e44e875c12109e4fa3716c05008048b2" "/navigation/df41b8ba15674e349cacdfff2f86650c" "/navigation/018b227d792f7f719cdcbe4a61f4cdf8" "/navigation/10026ccddbed4da3b2057bf7aac9f4a5" "/navigation/f79fd420473142efbbd7c3bc4aa2f070" "/navigation/fc490ca45c00b1249bbe3554a4fdf6fb" "/navigation/33e75ff09dd601bbe69f351039152189" "/navigation/28dd2c7955ce926456240b2ff0100bde" "/navigation/f033ab37c30201f73f142449d037028d" "/navigation/3295c76acbf4caaed33c36b1b5fc2cb1" "/navigation/9dfcd5e558dfa04aaf37f137a1d9d3e5" "/navigation/950a4152c2b4aa3ad78bdd6b366cc179" "/navigation/3fe94a002317b5f9259f82690aeea4cd" "/navigation/bbf94b34eb32268ada57a3be5062fe7d" "/navigation/4f4adcbf8c6f66dcfc8a3282ac2bf10a" "/navigation/8d3bba7425e7c98c50f52ca1b52d3735" "/navigation/bbcbff5c1f1ded46c25d28119a85c6c2" "/navigation/8cb22bdd0b7ba1ab13d742e22eed8da2" "/navigation/5737c6ec2e0716f3d8a7a5c4e0de0d9a" "/navigation/352fe25daf686bdb4edca223c921acea" "/navigation/d1f255a373a3cef72e03aa9d980c7eca" "/navigation/735b90b4568125ed6c3f678819b6e058" "/navigation/ad13a2a07ca4b7642959dc0c4c740ab6" "/navigation/a3f390d88e4c41f2747bfa2f1b5f87db" "/navigation/a666587afda6e89aec274a3657558a27" "/navigation/40008b9a5380fcacce3976bf7c08af5b" "/navigation/310dcbbf4cce62f762a2aaa148d556bd" "/navigation/018e603168d27b5ba5dfa4eded2b9143" "/navigation/34173cb38f07f89ddbebc2ac9128303f" "/navigation/c16a5320fa475530d9583c34fd356ef5" "/navigation/6364d3f0f495b6ab9dcf8d3b5c6e0b01" "/navigation/182be0c5cdcd5072bb1864cdee4d3d6e" "/navigation/a5771bce93e200c36f7cd9dfd0e5deaa" "/navigation/d67d8ab4f4c10bf22aa353e27879133c" "/navigation/d645920e395fedad7bbbed0eca3fe2e0" "/navigation/3416a75f4cea9109507cacd8e2f2aefc" "/navigation/a1d0c6e83f027327d8461063f4ac58a6" "/navigation/17e62166fc8586dfa4d1bc0e1742c08b" "/navigation/f7177163c833dff4b38fc8d2872f1ec6" "/navigation/6c8349cc7260ae62e3b1396831a8398f" "/navigation/d9d4f495e875a2e075a1a4a6e1b9770f" "/navigation/e369853df766fa44e1ed0ff613f563bd" "/navigation/0deb1c54814305ca9ad266f53bc82511" "/navigation/66808e327dc79d135ba18e051673d906" "/navigation/19ca14e7ea6328a42e0eb13d585e4c22" "/navigation/1c383cd30b7c298ab50293adfecb7b18" "/navigation/a5bfc9e07964f8dddeb95fc584cd965d" "/navigation/67c6a1e7ce56d3d6fa748ab6d9af3fd7" "/navigation/642e92efb79421734881b53e1e1b18b6" "/navigation/f457c545a9ded88f18ecee47145a72c0" "/navigation/72b32a1f754ba1c09b3695e0cb6cde7f" "/navigation/cf004fdc76fa1a4f25f62e0eb5261ca3" "/navigation/66f041e16a60928b05a7e228a89c3799" "/navigation/093f65e080a295f8076b1c5722a46aa2" "/navigation/072b030ba126b2f4b2374f342be9ed44" "/navigation/c0c7c76d30bd3dcaefc96f40275bdc0a" "/navigation/2838023a778dfaecdc212708f721b788" "/navigation/9a1158154dfa42caddbd0694a4e9bdc8" "/navigation/14bfa6bb14875e45bba028a21ed38046" "/navigation/7cbbc409ec990f19c78c75bd1e06f215" "/navigation/6855456e2fe46a9d49d3d3af4f57443d" "/navigation/41ae36ecb9b3eee609d05b90c14222fb" "/navigation/bd686fd640be98efaae0091fa301e613" "/navigation/289dff07669d7a23de0ef88d2f7129e7" "/navigation/a4f23670e1833f3fdb077ca70bbd5d66" "/navigation/577ef1154f3240ad5b9b413aa7346a1e" "/navigation/c5ff2543b53f4cc0ad3819a36752467b" "/navigation/0bb4aec1710521c12ee76289d9440817" "/navigation/854d6fae5ee42911677c739ee1734486" "/navigation/01386bd6d8e091c2ab4c7c7de644d37b" "/navigation/35f4a8d465e6e1edc05f3d8ab658c551" "/navigation/f7664060cc52bc6f3d620bcedc94a4b6" "/navigation/13f9896df61279c928f19721878fac41" "/navigation/8f121ce07d74717e0b1f21d122e04521" "/navigation/39059724f73a9969845dfe4146c5660e" "/navigation/7f100b7b36092fb9b06dfb4fac360931" "/navigation/9872ed9fc22fc182d371c3e9ed316094" "/navigation/31fefc0e570cb3860f2a6d4b38c6490d" "/navigation/0aa1883c6411f7873cb83dacb17b0afc" "/navigation/fb7b9ffa5462084c5f4e7e85a093e6d7" "/navigation/9dcb88e0137649590b755372b040afad" "/navigation/a2557a7b2e94197ff767970b67041697" "/navigation/58a2fc6ed39fd083f55d4182bf88826d" "/navigation/9fc3d7152ba9336a670e36d0ed79bc43" "/navigation/3988c7f88ebcb58c6ce932b957b6f332" "/navigation/1385974ed5904a438616ff7bdb3f7439" "/navigation/9de6d14fff9806d4bcd1ef555be766cd" "/navigation/903ce9225fca3e988c2af215d4e544d3" "/navigation/0a09c8844ba8f0936c20bd791130d6b6" "/navigation/02522a2b2726fb0a03bb19f2d8d9524d" "/navigation/8d5e957f297893487bd98fa830fa6413" "/navigation/357a6fdf7642bf815a88822c447d9dc4" "/navigation/a49e9411d64ff53eccfdd09ad10a15b3" "/navigation/e2ef524fbf3d9fe611d5a8e90fefdc9c" "/navigation/140f6969d5213fd0ece03148e62e461e" "/navigation/36660e59856b4de58a219bcf4e27eba3" "/navigation/e96ed478dab8595a7dbda4cbcbee168f" "/navigation/f340f1b1f65b6df5b5e3f94d95b11daf" "/navigation/d1fe173d08e959397adf34b1d77e88d7" "/navigation/43ec517d68b6edd3015b3edc9a11367b" "/navigation/9778d5d219c5080b9a6a17bef029331c" "/navigation/c7e1249ffc03eb9ded908c236bd1996d" "/navigation/fe9fc289c3ff0af142b6d3bead98a923" "/navigation/26657d5ff9020d2abefe558796b99584" "/navigation/82cec96096d4281b7c95cd7e74623496" "/navigation/d1f491a404d6854880943e5c3cd9ca25" "/navigation/819f46e52c25763a55cc642422644317" "/navigation/13fe9d84310e77f13a6d184dbf1232f3" "/navigation/eddea82ad2755b24c4e168c5fc2ebd40" "/navigation/cb70ab375662576bd1ac5aaf16b3fca4" "/navigation/1d7f7abc18fcb43975065399b0d1e48e" "/navigation/e4a6222cdb5b34375400904f03d8e6a5" "/navigation/37bc2f75bf1bcfe8450a1a41c200364c" "/navigation/496e05e1aea0a9c4655800e8a7b9ea28" "/navigation/6faa8040da20ef399b63a72d0e4ab575" "/navigation/816b112c6105b3ebd537828a39af4818" "/navigation/b83aac23b9528732c23cc7352950e880" "/navigation/d947bf06a885db0d477d707121934ff8" "/navigation/63923f49e5241343aa7acb6a06a751e7" "/navigation/0f49c89d1e7298bb9930789c8ed59d48" "/navigation/16a5cdae362b8d27a1d8f8c7b78b4330" "/navigation/5a4b25aaed25c2ee1b74de72dc03c14e" "/navigation/d395771085aab05244a4fb8fd91bf4ee" "/navigation/839ab46820b524afda05122893c2fe8e" "/navigation/1700002963a49da13542e0726b7bb758" "/navigation/49182f81e6a13cf5eaa496d51fea6406" "/navigation/a01a0380ca3c61428c26a231f0e49a09" "/navigation/18d8042386b79e2c279fd162df0205c8" "/navigation/69cb3ea317a32c4e6143e665fdb20b14" "/cbax/manufacturer/index" "/cbax/manufacturer/detail/4bbd9c23e810a10a299357ea4c2b94ff" "/cbax/manufacturer/detail/a8898d3439db66e2a670294067edefbf" "/cbax/manufacturer/detail/44bdcee382a044c24ba7477b33b1621b" "/cbax/manufacturer/detail/857ea8aa2763de1c32f6adc4d3b7e8b5" "/cbax/manufacturer/detail/a3e53a1877ed03bee5dadbea956b00fe" "/cbax/manufacturer/detail/71b82474e68e1a402330979a9936fd81" "/cbax/manufacturer/detail/abf9cd412ca678eaeb0c223c5106c6ab" "/cbax/manufacturer/detail/cf8a3f59abe95022116f5a666c8367ff" "/cbax/manufacturer/detail/f78833b45c46f32d5922a036b06062a0" "/cbax/manufacturer/detail/ebe4ac2125061050ea6f4f61d0ffc1dd" "/cbax/manufacturer/detail/2748595b0787cd229ed52976936ecc53" "/cbax/manufacturer/detail/9914b4a164534b7cd5a9385ea36bb0f9" "/cbax/manufacturer/detail/3b24adb00570f5613cc8706ee397b0c0" "/cbax/manufacturer/detail/8f6cb82673d87e7fa4117b9e71dadb59" "/cbax/manufacturer/detail/a294c80c3eede5f14c96e97536ef080e" "/cbax/manufacturer/detail/22f0d1db8a4bffe1caa4516d391588a5" "/cbax/manufacturer/detail/e87b2ad973028e550ad31b7a41d32df1" "/cbax/manufacturer/detail/88f60185502437d61b64caa4c8e052c0" "/cbax/manufacturer/detail/ddd93cb9c04e8558c0a4db7bc548ed4c" "/cbax/manufacturer/detail/0b7224ffb0e76b602812e27899c6df7f" "/cbax/manufacturer/detail/859ff07af35d40a4e936ad335d62bcb2" "/cbax/manufacturer/detail/c4ca4238a0b923820dcc509a6f75849b" "/cbax/manufacturer/detail/5f5166c1f13757c72e0ab605ca43a070" "/cbax/manufacturer/detail/c2f80bd113a8829ee96eb7457c64493b" "/cbax/manufacturer/detail/4aa47fce25c574893331b435fdddecd7" "/cbax/manufacturer/detail/756b3e2aeff691b7d674da6295299518" "/cbax/manufacturer/detail/02715b264be6320d09a0fa2a841e6551" "/cbax/manufacturer/detail/45c48cce2e2d7fbdea1afc51c7c6ad26" "/cbax/manufacturer/detail/56ebfbd98f92f90704f38a00be40420e" "/cbax/manufacturer/detail/144af2b96a34ff42b4783635fbe26369" "/cbax/manufacturer/detail/11fa3016cef67b32c3a69aa831929cca" "/cbax/manufacturer/detail/686a08d1969df147813ea618cbce76be" "/cbax/manufacturer/detail/15d5d6d420efdde1bf3a51eec69c974a" "/cbax/manufacturer/detail/0c45a901430e2d554f533a36de52b4ca" "/cbax/manufacturer/detail/113a80259eea2dabecb4f1d35f5aafb8" "/cbax/manufacturer/detail/32b8d83f411ecf0d3620850dd1d444aa" "/cbax/manufacturer/detail/c8d534d430a7c414b0599364bed8ed51" "/cbax/manufacturer/detail/eee7e1e68fc8e5e01c923895e1570acf" "/cbax/manufacturer/detail/a2f2f560e8199f2135f220c01af8744a" "/cbax/manufacturer/detail/6fd4696a4458819a4125314dba9dcad2" "/navigation/76d6a1a64bf74ee4a9a5c7a9ea81ff74" "/navigation/6ac18b0184b3472081d23c6cd0d3be6c" "/navigation/b5cd3fd52922492086dd9e6ecd2bdd08" "/navigation/376550aa4fad477d83174e95f685ad1f" "/navigation/cdbbb71db836462f817b5d5a17b396e9" "/navigation/6fa6434adc0e4725bf4dc803abea1d07" "/navigation/0e99b11ddff84bb5a3c3f03ba80c4652" "/navigation/481dcdf7f3a54443987980964e9a1ca3" "/navigation/1aa59333e7a04ba2ba93897cc60f8554" "/navigation/32179757e8974da692a79af3f6b969f5" "/landingPage/018a4565d4d7781396db135e242125ff" "/navigation/2f500e3e758341aa9b9d7595d40828fd" "/navigation/6ffaa09bc4534c6cb5761cbd54e16519" "/navigation/514eeeca73964ea2a6a289046ec7b626" "/navigation/b70da7099682416db74698c21feb6794" "/navigation/f9cb4618268d4a76b8085a5ea63ada80" "/navigation/f3da3ade5d2a4072b3ff8ebf04258029" "/detail/c82b013313066e0702d58dc70db033ca" "/detail/b7f1f29db7c23648f2bb8d6a8ee0469b" "/navigation/018a685be96f7db891bcc2c1b5624790" "/navigation/018a685c4d6a727eb8c8b0607c5fdc34" "/navigation/018a685d6f887ddd96b1fc32f074fc45" "/navigation/018a685dd5117b59a78e507c94b046c3" "/navigation/174e6ad734ab403abbccba761868f03a" "/navigation/7698c7806a2b4c93b4beac1cccc5431e" "/navigation/6e355d018d19491a92c3c7628185932c" "/navigation/d2375b3fb5ed4247a58ddcc97aad1a44" "/navigation/3df26b12819d4725995e5a930a2de526" "/navigation/bc41d588c9f54f70b76cd1a6d52023b6" "/navigation/6e5293e04f2f414cb4ec33c894df6948" "/navigation/434b6b89aaef4df9a574c26253117bfd" "/navigation/3fde9c65ad334285a4783d0c642c5cba" "/navigation/4b3cc5d817784bde9846b23b574406a2" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" ] |
||||||||||||||||||||||||||||||
|
3.18 ms (9.56%) |
1 |
SELECT `product_highlight`.`id` FROM `product_highlight` WHERE ((`product_highlight`.`product_stream_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND `product_highlight`.`active` = ?)) ORDER BY `product_highlight`.`position` ASC LIMIT 5
Parameters:
[ b"\x00\x10ŸqÁ┐$ºÝ)L·Ñ\x0E," b"\x015Öûg$ŸY\x10ÑÁxÀ\x07²q" b"\x019j╚[¤í\x12÷½Ñ¿ÕTÅ\x0F" b"\x01ŠJÈ´?{\x17½çReé‘\x175" b"\x01‹C\x13‚PyX²åêÄ\x1F\x15\x18\f" b"\x01‹C.ª]}\x0E°w×ì£å`Ì" b"\x01ïF¹[Éxñ¬\x10ëe®\x13`\x11" b"\x01ïýÉ\e¶tÛبSq\r┴\n" b"\x01Œ9§n'}ùª$_å\x02ìŃ" b"\x02\x1F\x10”ý%U\x15\x18î¢Ç\x13ÿ\x15:" b"\x02üó?Ýõ÷░ÉC$*éÊ▀9" b"\x03"†â”$\x14Ïâ̲KãÕ)\x7F" b"\x03ë║Ý\x07¥\x1C▒■P¢Ù┴Å>'" b""" \x04K\n Áùò\x02\x08;¯TÝ«=¥/ """ b"\x04Ù/Oîs×AP\x19êêî8{é" b"\x05\x07▒3Q╣¦S▀VüÿYÓį" b"\x05Q”Ì_v\x06˜ËÈ\x1AÒ³l‹W" b"\x05o\x0EGàê'DåXúHÔ°ã¾" b"\x05²I¨òø\x1DÝ8’_¥×ÓâS" b"\x06"\x11C¾)tÀзғÐnsA" b"\x064°:™ý‹î\x1DXÈ~ê#í\x04" b"\x06Æ÷\x12xýܯKÍT█Ê\t_Ø" b""" \x06ž¿Ôt†%\x16ñ\x12\\n } Î- """ b"\x06²‘±´Õ®3\x0EC·ì\x03†\x15Ì" b"\x06╦°ÿfèßür.û¦°ß╦│" b"\x07(Å£\x03^þ\x12Nå´üÌ▓Áö" b"\x07Z½\,U#|à;']ê´ ¯" b"\x07‰¥zÚ.wý=n†õ±üc " b"\x07 í«×‹¬ÅìÍÈXú\x7F&•" b"\x07ظò¨Äæ?àý³=ƒ\x1F=l" b"\x08Q~Ág7\x04\yRZ&¦ßu”" b"\x08ÛjZ,åIç³Húñgø‡" b"\tØ▒_\x12þÅA\1MÈ\x04\x04:÷" b"\t¶'¿g\x15^Æ\x117þ&0N\x06ï" b""" \n <¨ã\x12:a›õu]Údºü„ """ b""" \n ^\x17ï®óâx¾ê\x06\x05Ùâƒä """ b""" \n b[/0®)ºêb“®øG*n """ b""" \n Ï’ã)ˆºÈ¬&\x1DpIvh """ b"\v,€ÃRì;ÝÊž„Gš<,Ä" b"\v3gâ\x16\x1C‗F±{\jãäÉ" b"\v>p÷¯mÕ$>\x00æ%\x0Fƒž\f" b"\vO«´œ¤äbÁI£!Õƒ\x10µ" b"\v┌N├îÇ@╝\x0EØ8yà´6" b"\vè#\fã›BÄÓ$H¡2\x11\v\x10" b"\f\x07G-ýêVqº„¤¹+\x10\f¯" b"\f&\eˆ\x1A«ÉÍ”Q\x03Ҫˡµ" b"\f‹°UÊ\x05Þ‹A‘‘Z\x03¶[" b"\fùøçûqr‘¸MüÚZfº®" b"\fÿß³‹\x1Aò¯\x17ŠIªN–¢£" b"\r\x10åø\x1C\x1F+¨rhOò²DÇ»" b"\rMÔÚ§ÍæE\x16q\x08y7³ƒ‹" b""" \rh#×oðNßî\x7F€Û\n ²\x13ñ """ b"\ršw1¡\x19<ØÃ\vD:ÕhÊ5" b"\râp\f×ä¬ð:ë¡:1±êœ" b"\x0Eç9=1ƾ9+ñ°»[\x16\x1EÇ" b"\x0Eëêz¤å½\x1FOFÂIº" b"\x0Eúâ\fL\x1D””ƒö2Ô\x15±û^" b"\x0E³@\t▓{ÉJ»7M\x14\x00█2╗" b"\x0Eþ¨Ü1g|'ˆËWe£iHù" b"\x0F^Ò‡)Ê\x04×¢\x13´^B r¥" b"\x0Fì ÆàPåb\x7FØ└îö]\r¶" b"\x0FÎ{Ñ(J¹k÷¶XgÛ¡O2" b"\x104L\vI0ð<š¬Î\x19Æ!¼ê" b"\x10iÄM/ÈÇO┬¦╩x=åÉ┐" b"\x10y¨=\x7F¹Ó—\x19ãK×J¬—¥" b"\x10»Ó\x03\rmìFÎÿ4\x1A┬┘ùâ" b"\x10ȶÐÝÜ”C }Ž>Ú‹U\x1D" b"\x11\x16Åø:.|F\x17‘c;¼Åâ‘" b"\x11epî7\x02Í\x03q{\x1DÊ\x05» T" b"\x11Ž2Kæ\x02–LÅ?&Úƒ¢~u" b"\x11þóm█\x06ı Ö[l}É?4Í" b"\x12$Wn§>¼\vÍS0ýÔ”.Ú" b"\x12‰÷nRïÞÙcñ‡‡ \x03cÉ" b"\x12█År¢╬\x16é\x18éÃÃ\r'╦ç" b"\x13é¡~}×7®Eè$Ôæ2\t]" b"\x14®Ý$Wƒ bÐhÑ═Åh├d" b"\x156¤i(ÝÕö´áô=`ÓDä" b"\x15?§‚·\x13¶2CrHA<̈/" b"\x15q|°RñØ÷\x04Je#┘\x15\x00à" b"\x15—£H±\e\x13\x03äxU‰ú»Â\x7F" b"\x15ôé²°é¤qäý¯°6x8x" b"\x15÷©Pr/Ô0äìÿæ_*\x164" b"\x16\x10I÷F>vÔ·÷¢¼”€\x19h" b"\x16žËjÈ8³E"\x10\tt¡çûI" b"\x16°ë¥&\x04\x1Cð_zùõ©m\x10Ô" b"\x16²9/ËaîCÃN4žêõU." b"\x16½\x0E2ÓAäó§\x12ôv¯†ý\x19" b"\x16ÄøÎîìªÜ“&I¼?á\x1Dó" b"\x17\x02│íØ;Å°╚Y├sÙ╬»i" b""" \x17\n òwT\x04‹ p(÷\x13#é\x19 """ b"\x17=\x1C…5Ûõ˜\x15ìÍcÎz5¿" b"\x17>1‚}vç¿£CÂa\x03\x0Fu¨" b"\x17«»~YöÛ×LSí\x11†÷©L" b"\x181N€[ØP’ŠGhï‰Á\x1C " b"\x18‰¤1õîêb@\x18®^ÊÅp&" b"\x18Õk›L¦\x1EÌ\x0F«àñ\x1D¯@¥" b"\x18úC.ÌUI8)óîL‘{dˆ" b"\x18þ¢öÃÆ—AÅ<ÄE|É6\x1A" b"\x19=ô\x07É>Vüëz‚"‹méU" b"\x19X\x17Ô¤³–¯\tÿUI£‚@Ã" b"\x19ˆ\x08ضía¿\r\x08#‹—?c" b"\x19æ=B{Á¬Bµ\x03Ø\x06š£Ë_" b"\e\f —µ+\x19L§|ѳ·¹\x19Ú" b""" \ež‘Ò_ü9É\n ÜQ‡Í”n """ b"\e¦KÈ\x1F½vŠAÄ‹`Í‹B}" b"\eÔ`à┬╔ï¦*╗Yw\rFÅ" b"\x1C\x11?┬\x19©\x0F°üºÅo\x13Ñ\x05" b"\x1C\x1EÊ\x14)ÂFÈ€\x10\v²0I>à" b"\x1CKìw•&éï&Á˜\x18;\x16²ô" b"\x1CqÛ…±ëÝ(×\x08w\vɲ\x170" b"\x1C¬à¡fìœXÐ>á¾\x18¹%\f" b"\x1D>\x1F¶\x17»\x0E[J|©gGwgî" b"\x1D_Áõ´–´j¥Ì\x1E¡ÃU¯Ê" b"\x1Dì\x11¶8■╗©ÞÍê]$┬┘\x04" b"\x1DÑü z·ýÌÏ\x7F\x0F´\x1F@\t4" b"\x1E\x1Ezx\x03ÀÅË}ý│ýÆo²Ì" b"\x1EOérÎd½–¤&^UÛ±ÀÝ" b""" \x1Ef\x10A;n\x0E\x1C\x08±\x11\x11e5\n \x7F """ b"\x1E”\x7F\x1FÊʶ‡,ØìêßQ@\n" b""" \x1E¡\x12Ø\n âOë;ïL=%j\x1C_ """ b"\x1E¶S\x12'g&Ó˜¹/<Xþ¬ç" b"\x1F\x07KªÔ\x12lÙœS\x14ïòã¨b" b"\x1F\x1C\x0F•e©U›P\x1F\x19ù\x1A©ˆj" b"\x1F*mqçÓ®ñG½\fd7Í\t(" b"\x1FBÐ]B\x1F] \x03.G$ጥ" b"\x1Ff€\fÃ\r¤chÄ\x1C\x1Fl“õ‹" b"\x1FÖ\x12\x19_õ\x05sW§£>1I.ë" b"\x1FÏw┼-|E┘\x12D█4ÄÅæh" b" l‰¿æ/Þ\x12×H\t`¸SÚÝ" b" {Ànï'Š\x01¦#Z’ñ½9=" b"!¬\x049›\v¶\x01§š\x14ìI\x10£|" b"!¹Hî\x13\x1FË\fÒY)b@ñMy" b"!Ê×JÉ=þ▄Á\x10┼ÚZ¥\x04û" b"!´?96öWk\x19=É^r\v%\x08" b""\x01˜]\x13ýî\x08Gãw[sM\x00 " b""NöM5ö\x16"¯;Tæ.r(F" b"#‡å§ý(\x1Eë†iÍJ\x18õ‰»" b"#╬║─\x01 qö7«a■Éȸk" b"#ßÅ\\x15ا_ò┬»@¶\x08I" b"$Êîš\x07†a\fÊ'¼LDä¶C" b"$÷0ö\x05\f\x06§ºèYÁäIþf" b"%K!E\x1A¶ÀŽt’Øz‚üï/" b"&<ìäXêÚ”®î†¹ZQ\x00Î" b"&Ûü^ïÑ&\x19┐Zv\x13\tÚıZ" b""" '#¬\n ý<Õ\x14äÛìX\x1EƼ\v """ b"'^Üç×\x1F®Ï\x1Aa×\x07O, Å" b"'‘µÓ¤ïk÷¾êÞýˆ•\x12\r" b"'éŠ~ºÿLå|.dìx¥È´" b"(/\x13)$9Äš*¶¢ç®ËÅ÷" b"(8\x1Eÿê“\x1FÞÀù\x11\x11`.Ý\x14" b"(<5m-ŒüÅ„5\x18Çå!‚U" b"(DÓ\x04A;¬%\x0E╗╣╚Éæ▄\x14" b"(^PlŸ¶ê\x7FyEŸwÌ%Ç\r" b"(b\x05w¼¦ÃÛø\f´ÁSwÁ" b"(i½ÕŸõíÃ1û%iÃâÔT" b"(Ïßìœã\x10Æ—n‘“\x7FE¼ï" b")\v¶|k#Ö{›,ûâ\x08fN¡" b"*€K\x15-N.ª/_4¡Ä[$R" b"*Ǻ6°Îž®d>kC*\x1D\x02V" b"+%.›æ\x17˜I*%\x18,@åÇ " b"+e\x7Fä˜ÈÏ{•F×®\x0E¹Ts" b"+ŽÃ}-“3æ£/7ŸuÒ±+" b",\x01Ä\x1Cý\r%€™\x17½q#Ë\x10=" b",\x17 ó*\3£OÜ°4=å÷>" b",jŒJwëM\x16~\x05ÞÇ`Æ£è" b",…á‘ݨ5ž«×(8öG¨á" b",ø╣#=måoâ║\x05ÅÀ═╔H" b",×ì\x11=_±ã äu-}Ð‗ÿ" b",º\x14r¨-îJ\x003\äpĘ\x10" b",ÌTbÄÑ6¢œ¼÷ØñŒ7ó" b",ÎêÆzÔNyqý\x10}µ2 ¶" b"-"¿\x02ì1UäÛì`\x11dÿ)9" b"-ZþîæPcU%Ñ@ßn¨Qò" b"-[¨\x01“§$¿¬_\x06x5\\x14³" b".nŠ&¹ÌOndÊøM\x1FòS†" b".‹¬Âò>'\x00Ž©\x17æá4Ø{" b"/W»*È\x17ÿÆ©§C░ü$êë" b"/â¬ÑÒ_˜Õ†”¬\vö{5õ" b"/ð3[$¦ëýš\f±\x13\x0F\ea." b"/÷Ù¨¨]Ô3HŽ¸pþ\x02\x1A" b"0^eijòF˜‘hâXÀØEk" b"0©N[jŒ=‘‘#ñ)ú\x101e" b"1\x1A\x11O╣+\x03j╬§üÁ]Ì\x1C«" b"1j÷!¥#\x17p<É\x0FPX\eSþ" b"1À^K[a\x0EƆè\x085þ\x1AÆB" b"2*Ž8\x108\x0EÔ§M4Ò\x19‘¸\x1E" b"21ä0Þ#XÆÅÂHaM\B]" b"2lêИ·‚¨èw4•6\x06h\x03" b"2ÇQ},à[‹úv_\x01w„\x1F÷" "2Ϻ$UJV8ÖM-}!Ú" b"3\x0EÄÐäg§Ë%8Ú\te´€\x12" b""" 3Ypú\n Ø79\x02░×}´Dm| """ b"3Ã¥\x19$άÐ&Xñ—ð4h|" b"3úÄ›§n~p¨&šÑT0£¸" b"4\tö·oL;ù[ñ\x03\x12U‹·ê" b"4+ŽÎFç^Z¾R¹VÂ3§œ" b"4.±š 7ÒÝÝg\x10®ån,"" b"41Ù„˜\x07ÐI1\x13ª\x06ˆÃä‹" b"4d0\x13┌>{U\x10þüIGÎ\x1A¢" b"4½uÓc‡4Hµçzž\x1FPg" b"5\x0EDHí\x16d(\x17ʧß\fQNL" b"5p¯▄A\x006ö¡Áëýð┌Ø■" b"5»µ¨AZJ¥#L!ãi\x1A\eË" b"5ß\x1E‹ï\x04¼é\x02È‚%U4\x1F‹" b"5ã%ã¦YUâáö\x1FΔÂUe" b"6$œ/\x0E™²`\x08`eê»ÃŠõ" b"6;¹[„\x08?3Wî¡f]|.§" b"6O^÷Š/ý\x17Ãê\v‚Ö\x19Â\x1F" b"6l\x1D‹¬Ðô\x1A)\x0F*\x15\t6" b"6Â\x0F¸\x14µslÄÆ3—M\x1DÍn" b"7GÅ\x1Co³`‘I7ëcP”\v\r" b"7M\x10¥L/P\x1E’O\x1DÍ=\x08žï" b"7oBóRÞÂQµ~\x15®Þh8d" b"7Ö\x02t\x19B\x1DÀ\r:õàì\x111a" b"7Øé×8 ã▀n╔╣┬ÿ\x03■\x7F" b"7¯Û\x11Ö¯\x02\r\x18Y\x0F\x1D…\tÿ’" b"7▒┘A!QÀ\x07ïØGI¿·©(" b"7»j½”e[|£§\x17JL)\x0FA" b"8\x1DîŽÛ Ñ™3\x12\x18‹Â–)ê" b"87f¯\x0F0¯—±n\x148å®I"" b"8c¶?┌\x08X;ØòõS@(\x04õ" b"8ü\rù“ˆ'?æ=\x0Fì\eìI¦" b"9\x06c5{?~\x7FQ|\e\x1F÷\x1CÅ7" b"9\x0FI‰3=8ZW\x10\;$ßà" b""" 9[¬hO˜\n TbÖ8AûâúH """ b"9Ä{\tà‹=pAH*¼§W]Z" b"9ÒÉ=c█\x03üfü«t▓]8Ì" b"9ùôÙP‘X\x15…í\x07C'\x06s4" b":\r6\rlˆÙ8‘ÏAE$d" b":/cU˜€eÁˆ³¬fŽ\x016¢" b":1H²p4¸ãã: •ãŸùî" b":cÎ\x19\x19Å#UÙ¿2P“\x04¼ê" b":zQ│_ã'┘zW×ìqMMÙ" b""" ;/1`\x03Hc¿ƒìÓ\n 3O\x18Ñ """ b";žHF»çqï)‹ØëåÏ™Þ" b";¶~†ÑQ77\x7F\x12¬\x1Eyv0å" b";Ò0\x7F8“•0æ\vsÈ™\x7FÈ\x19" b";õØv\x00¹¼└½┼Óg\x15ø)ö" b"<-rÑbJºýZu\x11+1ñß\x03" b"<dÜYÌ╩; ÝR_\x0Eäüƒì" b"<äëæ¤O&╠1sØEêp█╔" b"<▓\x15Õ┼ÉÔr\r▒)ñ\x10Ïàï" b"=lkÖ\x04Æ\e/B\x15Õv8e\x16º" b"=zlblî²þ3┴KØ┌ªÆÕ" b""" >8å\x14Þª×\n Ò^ŸÛ–û‰ú """ b">Ê*\v\x07\x1C ¥\x01ÕM1‰MÕ†" b"?ƒ\x0EG\x1Ebl'└^┤´Å)[¼" b"?øs®\x11\x12û³\x11q\x07 Ûofk" b"@\x0Eò™\x1CŠ\x01brìíû?\e²—" b"@š~‡=»ÿ¹úFêWÛ8>Á" b"@›ëN÷¡\tBÑøG[<•¾¶" b"@ظ3”\x18\tJ2"33/团" b"@õÕ\x19tÌî\x1Fëü•ïêUÑ$" b"AAU┌R╠┌_ö·.\x7FØèdÚ" b"Aþñ+D|ï\x16Y\x17&ì"\x07»õ" b"B\e{˜ˆsX\x15¸´¼–]z£d" b"B,\vWÄügx\qݵÅ)ŸÓ" b"B¤Í?²¾ñA—ü\x04-lŒ\x02\x0E" b"B└eä░*í¢M▄yƒFrgØ" b"C]RÂ\x02ë\x11\x04ÓcÕ\x18\x1Fž5" b"D)Ôô€2Ž?1t4Þ\x04ñ)ñ" b"D¡a\x12Ï -OÍd#»\x10AV)" b"Dà\x12¸¹üÑ\x0Eç®_ï#¥ïÝ" b"DîÈôŒÇí›AH…ßšS\x1Dn" b"E\x05q#߃øYLÒ_ù…vC{" b"E14?£6ñ\x01\x06\x13V\x11å…Ý“" b"EBdþ)¯Ô‘ëµÞ[ÚŠÀK" b"EW\x1F\x07pÉù\x18xh"Dè*ã%" b"FPò@AC~ø’ba²œ…±ó" b"FY\tžvST¼Š«ìkM[¤(" b"FhªtGë\x07ÓÁ½Ú(áãG\x1E" b"Fu \x10Ç`¶í€Å\x10Ü \x17<<" b"Fì7±Îº\vÚV╔4áA]ÛX" b"F“VNܪ\x1E\x01OC¤X@ÜÔˆ" b"F›ì¿L\x14Ÿ\t\x1E\x12\x02²\x08#\x05W" b"F¤ótU\x199ö\rt╝¾X¤\x05ü" b"Fñû‰\x7Fob8,pÖ×\§âí" b"G=Õ±µ½¥%tÔ;û©çTÁ" b"GN—Z\x10M¹È•Ä~+øöéð" b"GSÔÔúz„/"åi1~Zi\t" b"H\x14]e´uÖærø1W:ÅGI" b"HCNQºwGÁæ?¶U\x1AX'" b"H™ß%q\eíU£Ó™,fmÍ" b"HÚÔ¶úQ¡\x12LÙ :85KÇ" b"I\v¨€ãí\x12\x15…È}[èÇàÿ" b"IYñ\x08Ü€¯H\x01³\x0EÕT.@8" b"IdtU±\x1DqPxM¼Û:’÷¥" b"IvI6³äG\x1DõÍ÷ü\x1Aı\x7F\x08" b"Ißs\x10|’#Ðèä¥b\x14£ªI" b"J\x04¨›Ë5\x15fu~\x0E çRüD" b"J\x14æ«Þ\f»L¥T»ü%‗\fƒ" b"JA\x00êÏì\x15\x0F+7╠╗)ñ¶ô" b"Jn³║‗Þð│╬wrØ?\x07²c" b"J\x7FÝ\tÉ╦þ´r\x1FË\x01á¾▓¥" b"JØ`\x05ÏZn\x16\x15ƒ…2\é™" b"JðY¾ÆdJTD²ØNUý¥\x05" b"K×·ˆSïz´¥2j;9\x19Ý÷" b"Kâ#]1Kƒ2§ì\x0F™w\x1Ea«" b"L0{T\x14\f{´eÁ¢mË\x05lœ" b"L] w®=8\vã¬\r\x1D˜Ð<" b"Lî+│Çâ\x00 ¯é½¦ì:─Ê" b"LíÛ-ß\x0E\x1F°ÍÚiŠŸû}F" b"L°█\x03¼ô/gìGÏ:uB\x00\x07" b"M\x06D\x19\x16\x06úfð\x02׋\x1E\x06ì›" b"MsjâÃ\x01÷Ï?õ{Zn│É<" b"M»ö¯Q&8þ±^úåúÕ-R" b"MÏ:Æ\x1AÜ\x1CŒ4lÚ!˜9Ä\x02" b"MÜ;B®gk.X\x07 \rM80ˆ" b"Mã)êßdÕÉ_''ù„Ñö÷" b"M¯4yƒlü¿{îê\x06³▀\x19²" b"M¯p┘\tõ╠╝±Õw-fªüê" b"N\x15öðÛMü0bÍ#&ÜÊàÿ" b"N1' ‹\x06‰Ô2`Ü–/v\x15´" b"NH.¡µo¥HØÑ'g\x7FfEc" b"NÖ\x08┌\x08qRr¯├²Ã╠ü4"" b"O\x01Òüæ\v\x7F\x1Aðe\x14ÿÐ!¤¿" b""" O\n Aíôb—|âB\x7F\t\x07ó×R """ b"OCÒdì^þ\x0E¾\v#©■ák9" b"OWRŠ\x117½^½\rˆ«¼ÒÝß" b"Oƒ.ÿä\x0E║\x19ø·\x1C\x1F¬]╩É" b"OªØ5÷\x17Y+Žîåz\r1\x14Õ" b"O╚A*â\x1C\x117µÉKÂ\x7F\x01Û▓" b"PKN‹ÃPhêÜ(l2õ^¸Œ" b"P¿§Í\x19^íüª\x1CÛZ¾)QÜ" b"QE’{èOl=¸L\x1C8\x7FW\rÒ" b"Q¡Õ¬:;ÚÐèØÉt™ \x19k" b"QìáÉ·ð‹eÆáÙÏ\x08P.ß" b"R5Yìèg▒º7ɬô▄±2¸" b"S┌ÖÊ\x1C2tm\x13\x10n\x15É│ä╔" b"Sà6.7\x7FBê.¾Á¹’$”-" b"Sä\x00\x02-\n’ɇ\x1A\x0FÉóÜ#š" b"Sò]uê?ܦ½j\x03:¼0Q\x15" b"T¬Ë¸ZÊ,Â╣Óü\r\x7FÑQØ" b"Tÿ\x12M#Ø”K0ÜÚ<S\x18^\t" b"U\x01GTøµM}ĺ$ù®\x05àH" b"UBþô*þÛN\x16Ê#>*xýc" b"Ui?\“\x03ÚK\xÌH‰;áo" b"V\x0EúÒk©Zs]¡CZ\x15¨¡À" b""" V\x1D\rr:VæŠá.M\n R×”Ô """ b"Vô©\tüýW²O\x1D»«NÓr." b"VÂ┘gÚô\x14\x15ìnG/È▒Ï£" b"W*ì░ÍüP,Ä}Zß└\vb~" b"WS░▄z*\x06\x01ı\x17ÿî°CðÉ" b"X;\x03F#`©ì'┌│¿|^vÒ" b"XrSãÞóx™\x12j^Rœãiü" b"X{\x17ôÞßQg7Î}\x10ñîïç" b"Xüb┬$Ñõ\x17z\x02Àq~od\x0E" b"X®\x12\x1A#\x05ñÁ¸-.`A¯s\x08" b"X╣½ê6ð Ê´u\x10░´JìÓ" b"XÐ**÷Ã{'╬-ØÛí\v©Z" b"X븖#¾’\x1CÚ¹<©ÞÅÙÝ" b"Yßöö‡dÒog~p³¦\x08‡" b"Y÷“=·b¾+&úﳟ‚ò\x16" b"Zf[¾…+ýE—ù¬„iß~0" b"[~Ü\x1E{ÃÞ_²\x08û×ò>Ú¢" b"[è\x1Að\x1EÜ‚°r\x15ûžhù\x08¢" b"[ô¹}ö\vÖýsžñ¯ÚÎ^â" b"\*'a¬\x16ÎÏQè}\x10512î" b"\«ñ¼▄▓9S┬ÉR-z\x19\x11>" b"\à–\x15Ž¯|öV5rº‘mù}" b"\þÃèï¾1!㜓¡“¡ÝË" b"]3±D)OL(/\t\x180¨¦QJ" b"]4 ;Çd \x03É:1Œƒ)s\" b"]åÕæ▓×bZs:[ØÏæÄ{" b"]è2C*ÔU ,Æ\x16Ú╣ü▒" b"]╣ı0ùðh╔\x15╚ÓØ5î2\x15" b"]Þîʃ£\x16ıÊØgÀb\x1A┐§" b"^“¬GeÙW!{2\x00Âæo\x1Cß" b"^šÎ‡Ðt£ƒ\x1Eà%–²õŸ\x12" b"^öx+!§Ãì\x1Cñž•GþÞ€" b"_\x1FY┌ç¥\x0E{Øá╩Jƒ¨ä¾" b"_w\x13㟩\x18cÎhäw\x10" b"_¢îGÌ“\x1C\eTró—ŒcVÄ" b"_Ô\x04\fˆ¸Á¯žXðïd)\x02" b"_Ýd\x11\x13ÕÙ¥4:”Ïóøì&" b"`€ªƒ\t€ö÷ps…¶\x11ÈMb" b"a>ć£Âí|ìlAT¢“6ù" b"aTÁCŒïö{Éî&<\x19äÉß" b""" abfÖÆb[Æ\n P“|\x16餒 """ b"a¯%Ê\x0F`|Yhg‰\x15é® \x1C" b"aÌâ*êy5fêVšªÐó·(" b"aöÆwÔÕgspX¦¸\x19\vû”" b""" b<×q_Ûcß0º\n Ï´Ø\x1CQ """ b"bz\x187W\x1D¾‚\x18_g+º\x05Ú\x11" b"b‚(‰çô.UQHõ¥¡¸‘O" b"b¡çÔ£$\x14/ó ´zŒÍ\n" b"bþ\x06€p»×¯Ï!ö?¥á\x15" b"c\x07\x12гØá\x17└Ѭøô Rþ" b"c#šBYTÀ\v0¯œ\x11ø\x1Cÿ\x04" b"c;\x1Aú·67\x13W‹!憲\x171" b"dEŸ\x16Mb„ˆËÉ}‘1†9n" b"d┐}]lÅy¨\x14ËU░º ■È" b"dõ¶ð(ì*#uZ\x00\x06■Êà\t" b"e\x0E\x04ýà£VÙ¦r©è¬\x0Eñ " b"e\x1FóÇÎä_A~\x02\x087Œ›Ëä" b"eü—\x05¥~™"F²$Ø&Çlò" b"f\x03\x03¢\x1Cª5eÒ²3·Ï=ÿË" b"f\fQz§¤8e.\x07— {m3Ï" b"f'#\x18:5e\x12W\x11èÅ.\vÂM" b"f2XSs┬89ù\x1FÆÁZ‗æü" b"ftƒÇè[Œe·\x03¨.7œ]\t" b"f¢‡ßÁÆŽ\x00ð=ÞòY2¥‡" b"fÛ║áãØÐQ«1\x0EÉb;xè" b"g\x04Ô±HŠ¿¯Ü³\r”Z\x14IÙ" b"gG°«Á\x13oý_\x19Å%Ç(¥Ê" b"güSA┬└v╠▀Þ£þ üçe" b"g©2¹K³Y[íª\x01Ž®^Ï„" b"gèÔZ… š\x06à7\x07\x06o1ß" b"h\füÀ9¸¿æA!‡†è¼$‡" b"h\x15°Ò^â²ì,¸\x0FãZƒb\x05" b"h†ÍÚ9\x10\x1CBÝä‰ç@ƒè" b"hœ$Ø(ÃxÜ™0ývMW\x03\x0F" b"hÔ\x08VÔ¯ŒÀà׈Ì\x1C~\x14}" b"i\x13·¨©0\x00\nÃ:Íó’Êý" b"i9\x03é¼PÞ*iÏ!\x0Fp‹+Å" b"i?q|uà┴î\x1D\x16éUNõÉ+" b"iÏï3,\x1EžA×Å3\x00Ÿ\x03P$" b"j-\ff$OãVyË\x10¤ì=ÆÃ" b"jZC~"ò×ÓçP5ÐjæY·" b"k\x13LSŠúþ#¶³Õ±g<ã—" b"kˆ\x0Eây/Gé!å%0\x10áÍã" b"kßÅÔºËöázq>Ñ·“b"" b"küOš>Š}¾‘†„Ök'Z¥" b"lSl5Ö\x03KVª7Žw95÷J" b"ly\8y°\x11y³í<'«ô5ú" b"l‹ï¥øaX‹”;c\x02\x02ÂJ£" b"lÇ\x17\x10Ï$¿Ø—Š©Ÿ=@\x0Fµ" b"m\vø\x16âV¾░À,\x19Å\x06\x1CÏ" b"m‘Ö\x02ý „,CÅ 8Y\t¥" b"mž¥\x1FXZÀÁÿ\vÿ[õ¾Ò>" b"mÀ\x1D5 BW\v█Øö[ï├ú╚" b"m·\x1Eèæ0©ð¯Òä웇" b"m¾Ó;@w5âÕ{Í\x0FÒ>Å," b"nlˆT¹õs#Žd\x1Dʯý" b"nz+█üѧÇ\x11r"ú\x077Þ┌" b"nÈ\x12…ž\x14Ú%¯Dß\x1C6\x08\x1FK" b"nÉÜ´ià\x1Eƒª\x07›i–cÎò" b"o_Eô\x17G.=W²“*Öwд" b"oÞù~Oí\x14PÐü5ä/KÝ´" b"oôÕ2e-ž\x18D\x07&±”×\x15¾" b"p<\x1CZz\x06?OξwйY\x04Õ" b"pEª×@¢,BUeb_›6Ðë" b"púá\x058ÒÆ┌Ù\x7F\x13þ1äØÆ" b"q\x03Ák\x03░j─èiº°ü¤Ê\x10" b"q\x13Ðëâ¢/õ\x0F!XéÆÖõ1" b"q@¸ÈÐmú\x18¥\x02ð¡ëNß+" b"qZÒŽ×fÑ\x1Egé–]\x16$\f”" b"q’µ¤+¸w\e\r3o„罩\x01" b"qù7ìý\x1AYµ-\\vü[Láö" b"r;ù¡´•P²ž†,@'.Xz" b"rdP6ëúl{s}.p\x10┤Xì" b"s+Í7áµÈOœÇˆ„Xh\x11\e" b"s-ì¾Lò\x00ö\x103\x0E╦³¬Ïo" b"sl╗m+Bbþª)S£Å┘\f\x1E" b"s¥\ÃÝI\x0EUõÀÕ\Ë&¢O" b"t/>«¤ð\x00~gòÍgÓ)z" b"tVÂ,“W³Ùª&K®ö”;?" b"t|W×P¢cÛób\x06`ìàw\x1E" b"t¢6z\t▒ŵƒiã┴åqðƒ" b"u\x17O§\x01ô9\rׂùh¹§šä" b"uúoä‹|\t^ÄbÊ\rYø:ç" b"v8;þ\x05Eæ9@®Îiž¤\x18œ" b"v¦y¸L¤³õòr|Xû[Ò°" b"v¿œÙ\x18JÈ\x1D\x11Ä×v`¨Ð¸" b"v÷.Ê×1fy‚$çÅ\x1FXÍ\x03" b"w<è{\x1D\x1E>s*¼\x00a¢ÒBY" b"wm\x10¹@ …Ž~"'Í\x06\x01£•" b"wÅV╝yoТԸ═│[KòN" b"w¥Ã‘'Škúî¨m… #¾á" b"x\x06_\x08ƒãéÍß$\x14ɾâã\r" b"xQºnx&ý,ýgb¯þ\x1D¦ë" b"xS\x19;\x0E=ÊŒ\x10Vx"'„\tm" b"xhDc\tÚxÞ6GZã¹,MÇ" b"xpn’…v\x02Qª\x1FùÃ\r\x0EKC" b"xñ¦Å`ej7Ë\x13.@Òž)½" b"y‹þVGÄžh³t(j›;ÔÕ" b"yÆä\x15Î\x11m?ùÚ¥xì<…¾" b"z\x0E´'«<8ô\eT\x16¬\x7F¢H>" b"z\x15%|¬ ÈZiÌj4Œ\x14Æ|" b""" z®╚═╝Þ\n O«}ìl/Ò-ý """ b"{\r;\x06còS╬¢ZAiDü\@" b"{\x10$|¶‚\x0Fƒ÷n-zV—+µ" b"{ 2¼ËFüÝ|u?Τl÷u" b"{:.–\x15\x0E3:“cYHò(Ïî" b"{‘þÚõ¤z6Çmyîxh4õ" b"{Ô±RfÃŽ™@@\x0EJÞyEg" b"{þ*ì!è╩└Û═ÑË\x06ÞöÈ" b"{øÒ¬juKéóuiâü\x17›x" b"|\x02ó\x18ÕÞ<\x1F┌ò▓\Æñ\x1Cü" b"|/òØL\x13¾ã§#\tÿº*ÛB" b"|Bìp\x0F:²ÖÔ/L\v\x1F0\x0E&" b"|LQÕù¾×Êq°¦qzhý" b"|gb\x7FµŒ›îÛ"íÑ È|›" b"}\x02╣¢Kr~!É\x1E¤Í▒Ï`╔" b"}v²;nÙ®¼\x0FÜVØÎþ\x040" b"}³go\x0E~e6×\x7FÃ%»Î46" b"~gx@\x02\x17v9a:òáa\x02x½" b"~À¾òHºsPµN`¾\fOŠL" b"~¦kgìʧ|¢┐┴ëFmÞf" b"\x7F<\x0ESì■`\x06┐‗Ëå2Ïaî" b"éÆgfÅ[<û˶\x14}d4?é" b"‚¯äG-ÌûhXRj2\x13õ‡·" b"ƒ\x1C?Ü©œ£û\x17Ì\x06ô\x04¨áŸ" b"ƒ1[¹\x08ÉR€Q—p9u«\x1Aë" b"äO\x1AG|8O?©¹ìñÃÊ\M" b"„”\x14óÙc\v\x01‹ÅáÇ×êÀB" b"„ÁÀòv©m¼ºØV Š\x01\x0EG" b"…\x0FTÒ>hrÆðýâ\x13fÑÏ…" b"…}I„=¡ì\x078\x1Eò%\eGÐç" b"…›\x1D¦ã;\x03?â|zY[\e*Ý" b"…Æ\x01Íø\x1F\x01Î\x01\x0F\rõƒôÓ\x19" b"…Û\x19½}\x0E \x17çߺ\x7F\x1FG;ä" b"†Š<T})}ì[+µ\x0Fã\x06¨ç" b"åì■M║¿×n.╩Ùû-┐\x1A>" b"†·2C2ü°\x076\x02’|f¤é`" b"ç\x16\x04W╣CôÉF}\x12mSge\e" b"‡B!/Š£\x04'„ܬü\x04ªh4" b"‡†Zu§ò{%Ûç 4´ýÈã" b"‡¬qÈ×½\x1A½\x1CáútÙÔ)'" b""" ‡ï$\n Â7‹›bx\x1Ar¡K\x17c """ b"‡õ\v™‘b9¹\e*XùV¥tœ" b"ˆ+ÿ|@ÕEÊEV\e±3L0#" b""" ‰\n ’db¶Õ§½Ýê›å9¡ """ b"‰&¨4œ¾Áë‰É©;Ѓ'M" b"‰\x7FÈ\x01¸‰æ–çZdì`\x06Ï°" b"Š6h8m®2ªmš(#\x0EÝ\x13•" b"Š•8²òè—¢¨…S¡gˆz\x16" b"èñZØâ\x04Ñ¥§Se\x08j\tc╦" b"èÙ\eÉɦ3¤\x08\x01\x08=4º┐+" b"‹2Juæz•\x01*bcžp÷\x05U" b"ïqð\x02_ı/ÑÇ\x02\x15@dA¾Ø" b"‹¢üâ\x19N²ñ8«Â‹}.Ç©" b"‹õ¯Qp.á\x14\x08Œ[©0À75" b"Œ\x08aj`=*Õ\x19’ŽÞfÍ%Æ" b"Œ•»••Mv5.\rÿ;\x06ã\v/" b"ìNʦ\x10âlÓ÷┼À‗þW├'" b"ìU╗QÈ\x1DÃq╩Ùùн¥+" b"ìâ\x07îª\x04╔å1WÍ4Ý╠C " b"ì½l┘vb®B\x1AD\x1A\x12¯D╚\x12" b"ì╚^││Ò\x19ð├V#I\┤T▓" b"ìË{▀Ô-╬╔6▀░╚U¼ÛÜ" b"Ä\x19ã9ps[|2\x07^ÿ▄ûYÅ" b"ÅåXð9¥]C|ÌÃ\x1Dí\x01j³" b"ÅÎd×ÏÓ\x00Gþ╝\x1C│x▀µ" b"Å█É\x1Aý\x15┘¹0àù\x08\x08\x03å-" b"ŧ¡Â\t\x08Ú\f¸\x06f\x17ı╗▓>" b"ɽ\fSh"1ÆæÐC!üHa¨" b"ÉÝN ¤\x10\x7Fy`C¦#;ìÌ║" b"æ×2^╗5)³ª;iBÉ╗MH" b"æ░Z■¶Ç\x14\x05ì[y═├\x02³9" b"Æ5)ñ½─┴▄\x16þõ¯\x01ÖØd" b"Æ8l\x02øM░\x07õ·¦°╝ì┐x" b"’p”Ø\x1Eê’^݃¤j\x12r\x11:" b"Ʊ\x15D»´ùï¥ú»É#ıÌx" b"“#nÜ2x“üE¸-®Cp\x1Dq" b"“$©5ä±õ¹j(Ôc\rÖ\x16\x06" b"“'q«LÜ\x06zýýB\x00çÖX?" b"”D\x10“s&Ö\x1Aè?bþâC\eY" b"öI[&╝Åa4LäÁƒZóO\e" b"•Q/áIQûï=>ú\x04äcÝæ" b"òV■½UÖù\x05uØPæ¸gF╣" b"•q-ºŒÁryDwõ£©\x18!8" b""" •’^¿ôŸŸœsÖ\x16ß`ó\n A """ b"òø}Ë¢«@\x01Ø\rÎ\x14Û▀╠£" b"ò©u©VÇÕ@íá\réI~ü0" b"û\x0E^·yìùCLÈ×K─cÍx" b""" –U_! ¬\n ÔVQÛ$Ý\x12\eÉ """ b"ûÑı<#│@T|ì╝*┐ý¥9" b"–ámSíØ–\x1DmÃzÙ¨œ¢ƒ" b"ùï¸hÞ?(éØܧÑ:‗5F" b"ùØ\x11Só5i¥íÛ\x1D╚1ÄZ╩" b"—Ï´YBßùð?ãwV›\x0E\x16\x15" b"—ÔK5Á7°d\x01\x1C\f¿)rY#" b"ù┘ÃpéDì╦¾┌Ôd×?ä¥" b""" ù¶\x08â╔Hø\x11Ä\x18\n \fÉzwå """ b"˜†x¨\x1Có2Ø\x19±\x00QÑÃYÎ" b"˜™\x11J9ñ¸8ÝSó²³Ó Š" b"˜÷óí\x12d:ÔûX\x19"Ô>ŸÅ" b"™\x10\x19kë©4»Ó‡Ú&uX²q" b"™…˜•Vý–w/\t³é\vÊ\x080" b"š‘üa£Îo?Ø°#k'Å“=" b"šÜbQö€UY÷-^¨ Ì\tÛ" b"›4`\x0E꼬@å\x19\x11ž\x11; \t" b"›Q°§²p²¼0Ü3ï¿8¨\x1D" b"›œÖ>å9Ã\x02?\x0F´î‹´=Â" b"›Îa¢2F\x045|6ÃD¼tç;" b"›ØCV.÷—ŒŠª\e\t\x1Eˆ\vH" b"œ\x13#9æ×…ñÛh$ò£]Û×" b"œ9Ê\x1A?NÞK-oHa‚)\x07" b"£>ãá(.׿1\x06\x18EñSÿÉ" b"œA§\x17TÞ/\x10Ý¢:\x17Þî\x13‚" b"Ø\v%æ×ı²¯\x02aBkÀ┌ƒ[" b"Ø\x15çÔ■|BÉ\x02S)É\x04\x07l&" b"Ø\x17ïݦÀþÑq]\f×wÙM1" b"Ø▄1Å\x7FKËæ@>®ï\x0F|\x11a" b"ž\eÒe \x08ÐV\vHU‹zÕõâ" b"žD£ÔõE Sýx±§ä’"\r" b"žFhŸ3á&æ,û½q¤¦YÚ" b"žSž0Ë’(àô)ê1ãì×á" b"žY$§÷=Â_²êÀ\x04´±úg" b"žf“W…Ç\v¯Oø±\x00¤ì¿\x06" b"žtÛOBƒé\x00péî›ZÈìÍ" b"×á \x00┴\x01ÿ\r'1Å\x1E0G)@" b"žàö’\x1A\x0F\r¼¾\x17ÝW\x18w\x0E‡" b"Ÿ\x08œ´Ù’\x17N¸ÇmV‰y\x19ì" b"ŸPœFÞ\x11\x11ùPo[|}9Dm" b"Ÿ¦Öô›ã*ifÿÜ9‹¼\x1A¦" b"ƒ¡pÝÉM\x1A\x18▀[╬3\tªÉÞ" b"Ÿ²\x00\x16ôc°L/\nÚº…6¯á" b""" Ÿë‚äÈ\x1E"r\n ä¢'î\x14ðT """ b"Ÿð\x02\x01\x15\f♂ìá”-üªJ" b""" \n Ú\x05>)A?QmN÷ó¾ÍZ """ b" 3\e³›ÚË\x07õ\x05!L\x12:\x12Ä" b"áMÉzÝ\x1Dìh1\f╦«Ñ┤±§" b" ¯Ö¡o7'Ó¯³Ã¨Çx¸U" b" ö×öB¥ìióÓ?ô®äk" b""" í\n \x05├\x0Fj┌Ø´Ts9╔▀më """ b"¡\x14B~_\x0Eý\x0Eñ(½oø¿““" b"¡é\x04ÈÂü\x0FPT›l\e¯Nïe" b"óV@° k\x10─çlI;ØYC§" b""" ú\n \tÛý©\x0EÚÉjÝpÿ%g\e """ b"£,îÏ\x03e§( ܆ åEFô" b"£_ã ±\x1ACØWéþ)×\x19a£" b"ú¡\x1Aýò\x1AíÅè\x18¾$Ã%┬ö" b"£³wqüÈ„.‚fZ‰©§Õo" b"£îøÎ\[~\v"ü\x14v·y×½" b"¤7,i–â²ïRÒ\x0F=;Ɇë" b"ñR>_ÙØÜÑ´Áçbbá}\x1C" b"ñØ÷°╔:=ñk╔a±┌╚ÖU" b"¤æ{éÜËô1\f‰z’—„Ì9" b"¥š\x1FYKÛÝAô‹\x16ü–œ‹ˆ" b"¦\eülSÈ'\x7F\x04·uÝŸ©ž" b"¦/b\x02ÉË›\x17^—\x1DèD¹+\x05" b"¦„{Š\x04uŠ4\eÈ\x08·¥\x11gñ" b"¦Ñòõûˆo^Q¾û¥*r»}" b"§\x12¹éd¿öeç\x0F\x14·\x11P@Þ" b""" § \x07kÑ{oóŒ‰\fZ\x08\x17\n í """ b"º(XõGäì┐f²²¶-8Ø╩" b"§cÞ\r.\x03rQ\x1D€–’SRQÐ" b"¨B"1žG\€Ü¾U¸T\x1DnH" b"¨BDíÀ\x08°öª•k‘öô\x00À" b"¨}÷JÀ$¨¡þß·³³›\x12þ" b"©]<(σú\tä²ÄïË3\x1Dû" b"¬IÉâ\x0EË\x1Aã6¨Tµú\x13ù¬" b"ªœKïÂf¸±\x04\x7FúØ•\x16²¾" b""" ªª\x04\n ¥ÊÐ¥½\x1EŒ·Ògr† """ b"«!Ë•”¨ŒXF,Þ‰Ô¤\r•" b"«Ö‹ëgQ%aÿµÒ\x0EÔ\x11t" b"¼j£ØË4Â■\x07ÏÛ\x1E¢æ\t:" b"¬ÆšÌbðƒIx5ƒçY·€z" b"¬ê\x02+µ”iöSãßí\x1E<\x7FÛ" b"¬ñÖ\f?$Ê›,¹«9¡\e"ø" b"WFCgƒÿ…\x1C<&z\eu\x15«" b"¡c\x0E]¬üTù÷▀¶R3dãC" b"¡ä×Þì\x13ImÙìxxòÊJ " b"Õjþ\x03Í!\x7F\x04}ä\x1DÉÀ3*" b"®W%ãâÄ\x08ä‹DÖyt\x04’|" b"®¡¸HäögH}~é7\x179®‰" b"»\v▓úFBpDúµÉ╦┬úµí" b"¯@”©V˜¥½ãçÏ„\fšç\t" b"»üûYF\x0E¹õ Zл*qn▒" b"»ì╠ë@j&vÑÐ"!¿þÙÈ" b"¯²!õVUÝkåЕX“Þ\v" b"»µÌ\x13█═\x0FÜ\x00ì\x1F³»©t" b"°"RK—p•ô\rÙ\x07|£'.˜" b"°hXG\x01ë(Á¾4³ ‘ÞÎI" b"°h”fdý®*\x18\x18óAž‰ÒÈ" b"°¥‹ÀCÒ\x03Ö¨€ï¦¿øب" b""" °¸«á¤M\n TP=\x02B\x7FÏ^} """ b"°Ö4G{UŽÏ>\x7FùãS€ôé" b"±žªÖù™˜‡‰z»\x04\x02’\v\x1E" b"±ô\x07\x04ÞV\x1D(wÞI~\x08Í£:" b"▓┬9Ïá\v>q8ô╚`Ø+ö\x0E" b"³hI’ê\fš t¯øú²Šy£" b"³£¯pM˜pàïÜ„ìÕÓ&" b"³Ñ\fç\x0FÐvH5,\x02¶™a\x16\" b"´\x18r\x13"ã\rRàØ.PpèL" b""" ┤ü¾×ÙÊv\n ÖJ\x12FùywD """ b"´¯ˆöÔt\x15-YvÇŠ»¦ßy" b"Á'¾õ5Ý\x12Uv\x7Fiıìh7q" b"µ:m¹\¼ai¥Á\x03K—ßÒ\x19" b"µ¤ ½èäŸ9Ý{GŸÂ\x0F¼á" b"µèLr\x1CƒÃ/ÒS9\x01ÌŸÝ×" b"µúõü“.¦o„}0–)?\t\x18" b""" ¶\x07ì}äu\n «sGômg1å """ b"¶*¤Ñ†z*˜ª—›'\x15Eðü" b"¶‘˜m\x10Í×ù\x14ÌB%Ú:Ì" b"ƒV^\x10øn,┌\x13\x02¬\e\x1Aüµ" b"Â░Ø\x049×ß3│┐±ëøac\e" b"¶Ï\x0Fá¤P¤Þ3¥`fÎgã'" b"¶ÔÎZÛ\x03$d~œ”Ž\x1E¢_\x1C" b"·e7ÆNÏ,h\x0E<Ÿ¸'èQ\x0F" b"·lô3Tìø!¾\x1F\t=\x1AÕk\e" b"·t¡<³¬ƒUÁm÷À}Þ>Ú" b"·wö\x17sºîT¤VTcE\x02°ì" b"À ▄Oü(bácwæ-©ìá\x12" b"¸\x14‚Uú°\x1FÿÑ„™H…²¼1" b""" ¸TÐÅ|àÉò\x07J\n \r\t“€Ù """ b"©m´L`┼\x15\tÒf■[%ì+ñ" b"¸Ë’}¥_‰\x1FŠ¦BA\x1FCÀ2" b"¸ÞÅ\x7F3¬\x1Dßù_úÚªÛƒ\x12" b"¹\x04ú˜qÃÃÙÚ\x15´\r“©É" b"¹\x1C}ö\f‹àâ{Rý˜œLŽ)" b"╣ /¦$ÍÐ■vÿ\x1E§\x13┴½Ø" b"¹^ÅG\vUÅ \x1Fœ\x17ê@Ö»ñ" b"¹wî5\x12H6ž*~‘4¯””L" b"╣ª\x16Ñg¡cP)¨\x0F¦É@*Q" b"º/o7EÙ.\x0Eu#Q\x17Œþ|Ë" b"║░·╬ê¥ÄØ\x17Þa$░`dÑ" b"║ðì\x01\x06îd\x0Füí%┴┘\x06d" b"ºíE°óð-l\f>´\x1Dò¬\t>" b"»v\x1E—QõVb\rcÁP§~º¼" b"»—a\eiÉ2V5K\x06eÈ\x154D" b"╗óçö\x13\x00█å§r├ì-▒ùÛ" b"╝>├╦îì¢\x0E╠ƒ\t╦ª\t)X" b"¼œß.ð-A½ê\x19[\x12ìé\x14é" b"½\x16gè\fLŒœ\x01L”áÍ(ÈZ" b"½A.Õ\x06?—Q2Ê\x10VÅÂH\n" b"¥/┴m/êu\x19Pìó4\x0F©È#" b"¥UäöA\x06°═\rÿU^Åì╚╔" b"┐JÖîú ºý§┌ì¥óuàà" b"¿”6\x1Câg¨\x10\x14½T¸4¶„å" b"¿±Ä¤DÕ–äéÌã'a3Ø7" b"¿¸â‹e*‹¸\vÒ16DCeì" b"¿Ä[¡'\x11d£@\x1E*94“šq" b"¿ât¨ñ\t«^\x16,„lõ\x15g4" b"À¢9.vôôpY\x05DÝ$‰Éõ" b"┴ 8\x07±ë&æ╣ G┐ü\x06dì" b"ÁA!&ºâ×Æ\x11]‹¸–^0P" b"┴}^\x0F└┐\x08ýÅ<L■\x05\x13-¾" b"ÁŸ‡\x05Ú¥b˜oé‚\x15Ãs\x18é" b"Á²pIwÍé0A¿\x12ãÖ·+Í" b""" ┬¼\n *M\x13Æ┼\x03¾a;âÅ╔Ò """ b"µEU‚\x7F¾”]\x12gm÷Ç…D" b"┬Àä0-§kÙÅì┴ME\x07n½" b"Ã\x04ð\t0ó²—Ûê;IM„ò|" b"Ã+T?Í\x1CYˆïÃ(56Hyé" b"ÃJ³…aŸU½ãr\x01”½}X}" b"├`Ázìág\tıbo│Ë▒\t\x14" b"Ã|îxômiþ’>Œ^TÆ\x12X" b"├ß1»±#Ó┌\x02Ø\x00\x1A_¹0>" b"ÄÝež´!&¬\x15\r4©GNuï" b"Äí¯¸xA36ác\x122¼06É" b"─Rñ¬åâü<\x12ÎtnÅÜ█" b"┼1¹A\rÅÀõ\x1D\x10 \x08òÇl®" b"Å•w-º"€\x16 @â>IVD›" b"ÅÆ^ÉáËfv°2`ü8ÍŒ" b"┼█&+Åhi\x13Ç\fQ8Ø.\x19X" b"┼¯l\x1D╦íÉÈS-Ø╩3«#G" b"Æ0BЂHWe\x1E¥¬jTBÖ¤" b"ÆûÌpi%\x1C¸\x06´Hua\x7Fÿº" b"ÇLS¿à.\x05¯\x04(€ºä%Ò¶" b"Ç€ Ø<)Ê-P â'ˆv\x02\x11" b"ÇÃ*PY6\x16À£^\tdŸ/Ú4" b"È÷žerô\x0Eíý؃pgRš÷" b"É),\t\x10R´—:¡&çšË¤5" b"ÉX•F\x1CZÔ\x1C=˜3‚'™L" b"ÉbDÌØÙ7›ÊzXà²\x15à\x15" b"╔Ã\x13ÚN×ñòî█wo-¸¢É" b"Éúw0ËçCqÛó³õ \fja" b"Ê!\x04ÙÝ\x18Ï\x0E“\x01L\x1CñÉ4ƒ" b"Ê\x7FÙ¥?šÙe'Z”fF̘Ø" b"Êœ\x0F´£\x03\x13à\x18D¤øj\x1DûO" b"ʬ»ál"B\x18ö‰–{uËÏö" b"ÊÝŒ<¦yŒÓÀ~wê\x0F. ò" b"Ë>ÙÈ\x0FtèÉ/T=\x03ÛËá:" b"ËÛqÏœQ:,ø\x00éä#£.£" b"╠FU║┐0ìì\vêZÎ\x13¼╣\x1A" b"ÌQ¸‘\r·ýz:¹š@$\x11m " b"ÌÿF¹‡ÃbuçÕjÝg'£Ä" b"Í\x01¥Ié‚Ï.²¯{Óékgt" b"Í=]Êa”É<&ˆÎ-ƒhÐò" b"Ík“×\x17Êa›&‚¤\x0Eùý?j" b"Í„õæ‚u —yY\x0F»\x0F5Zv" b"Í”§Ùí0\x10oѹñ©€6?\r" b"═ÿ¿Å`£1WWB±¦/\x1FE" b"ÍÔ bš‡žñ\x03#÷lÒz¼â" b"ÍýÇ9™rš\v…djyw¼¥" b"ÎB¨q¾éºnú^¥¼Wæ\x14¢" b"Ί¿òÅ€DL=\x1C¶öÕ»Î[" b"Ï<w\x18þˤãù~{èùÃgŸ" b"ÏAš¼ÚF}ü»A\x15¦\x10‘?Ø" b"¤~╗aÓ6ýw─=¬\x0EÉZüÿ" b"Ï‚rë¯Þ[¹\x10Q[§ðÊ„O" b"ÏœÉm[aÛ*Æl÷—Ü‹1s" b"ÏÒ1mméÚðµü\x1D†è·qT" b"Ð\x1Eö¾ÏÁËš…=øM\v}\x1Fï" b"ð3╠│YZ%ƒä$'ìof®\x1C" b"ðbÑ1\x01ô#Ea┐ï▒▓üb" b"Ñ >ŠX\x7F]\x07M\x01ñwÏ1‰M" b"ÐI$ËÙ«Å\x144[\x04_(ÂÄv" b"Ѷ\x11èéUˆ]ÅÇ›\vc÷á‚" b"ÒFzØ\x10ëëí²¤\x7FŠ¿Çba" b"ÒdyN\x1D\Ùf\x11Y̲÷Qý\x08" b"ʵbY´ôüjòf\fêÊ}╩╔" b"Ó\x00Yd\x19€òã \x12ÎEæ§sÍ" b"Ó\x14}£9£ä\x14åWéÃWߣ7" b"Ë\x18ÐØM▄Ï\x13"P\x01\x18=■çª" b"ÓC*\x1DÑ\x05ùùǤ7EÓfò" b"ÓpŸlN\x07G·ñ2î™\x03lèX" b"Ó“3Q\x14Pà\x11‚Åèvhâ6*" b"Ô\x18Lààõ¸¨8>ff¡Ì/Õ" b"ÔXCˆ\x05,)43h‚4\x17\x01¿\x12" b"ÔÍS\x1C\x1DTð8Ð\x02,!ŽÍyÞ" b"Ôëùêmüs\x7Fžn\x1Acu@N¼" b"Ö\x7F|«Úý@%¸\x11T\x04ûÃë\x07" b""" Ö€Àâ*Ü6»g›-\n \x02\x19Ç¡ """ b"Í¿ø\fboÜjï■ÍÊÜ\rgØ" b"Íßì█\x00╦╝┐sìò,Ätı┴" b"×fºÇ\x1AQO>Ïòä\¬’\x16É" b"×óØŸ¢NSåâ™énî\x1CÙF" b"Ø\x14ZIpz\v¼ÍŽãv×\x17n/" b"Ø\x1Fü5Ìç¿dä7ýøå\x00»" b"Ø^ž-@VÛ#\x1DªPôu\x00ÿ" b"Ø‚£õ_:úþF“õÚª\x16KÉ" b"Ù\f‰OJ~qïHkµaôŠ4p" b"Ùü¿cí%j\x14¯è\x06¥~Bv" b"Ú<%j™7hÖmŠ±ó“¸\x06™" b"┌?J\vì╗ÓË¥\x00}┴B¾┬\x11" b"┌OQËsèJ·▒▀‗®Tù╩É" b"Úg¨\x18ÔRÅd\x01\x1C|§»»–Ì" b"ÚvvyŒê6\x1F€»"Q\t\x1D`¤" b"Ú¸þí×^FÔñý\x16¤¨Û>h" b"ÚÓ¸\x1E5`¼\x12ì&\x0F*æ^x@" b""" ┌ÌGk\x17ÝınÅNW\x1Cæ\n ƒ8 """ b"Û`\x1CÀž\f¸úžÿN%“\x12é¼" b"Ûx÷ÑT0`òͬ®ªDú€º" b"Û\x7FR¾ç\x12sÛ_f\x0EµÀ›ŽÀ" b"Û»M¶Pfµ\x16œEªÂ#9Å$" b"ÜPôÊá¦þ\x00“‘²4ø°¸¤" b"▄z÷gõæþ³{}ÅÃÒ\x18"¬" b"ÜÆuXйÄ\x0E\e;‘÷\x11ßEª" b"Ý,‰D\x18ƒìã`ÏÈÕ\eˆ\x1CÙ" b"¦╣X(Ø >ë\v\x1D\x06}3k\x0Ez" b"¦┴ıeª▓þIe?yTì█HÀ" b"Þ\x1C£ïÑOEšáËSÒE{M‚" b"ÞRÛHN\x14ž\x15\t½Ö^}غ-" b"Þj`&'T)Ò\x1EcÜr\x19\x18Ξ" b"ÞŽ LÆ\x0E¥6yÜqžÉâZË" b"Þž6Eøê\x01j9Ø“\x01‰ZZ\x15" b"Þ÷×@뜪/ž\ey\x1AãÂ:³" b"ßXÝpk2¾Ü\x11¨âVÞ\x0Eïh" b"ߌöˆ¢H”‚u:ÛHÌcù²" b"▀Åû,¨¯|(\5£àè\x1Dî" b"▀þ¤Sj\x08»\x1A·┴\x0EÉ\x06mg3" b"ßþ$\x14ò=Y;¨»¹â´PÃJ" b"àb\x16²ÁÛ‘âØ(£1̉E\x19" b"à~ÔOÄN–5ç.DG§¿§×" b"Ó╗¼Ñ²▓ñ┌pÓ\x02\x1AÙÒÉ"" b"àÊ\x16\en¦\Sø—*\x15Î\x13RÈ" b"á)\x05Ë\f–|4û@5á`‹úÉ" b"ßäüÂ\x110┤X╠ÁØ┴>ÑËå" b"á”Ý"w´ÇÑ8ªå“Å%u" b"áÕ\x0Eâå%½¯\x7FÖDÑO\x02ês" b"â\x1C@ &¸hÞÿ¬ió”sÊå" b"âé·ðȪ3`\x0E\x03Œ\x08\x1C\x13Ww" b"ã'í\x00l1î¬\x100nyÆQ‘\x17" b"ãQ¼\x14S.6$_–ý–ÿ%ï\x13" b"ã{†ðf9'ÿçÊq\x1D@’)Y" b"Òé$¤w\x014ðÅ┴╔Y¯ËÿL" b"ÒÀOô\x06à0o%\x1F½¬ÀÅ'm" b"ÒÒR+\x04ø#!zý2QGÿü\x07" b"äE¿\x11¾0\x1D¾Ð꿸æÙiK" b"äHz\x02økÅÜ*-î¹áDM\x13" b"䪿7FaÇè0f4>>\x1EGã" b"ÕY°²©HúOù×╠ÅJën\x1A" b"å¿\x1FˆM\x02ê ú]Ow‹Æ!Ä" b"åøŸµ¯\rÃ|\x0FGQk\x03ªûx" b"æ8\x0FÕÂoMa=±„ά¦\x00I" b"æ\x7F\x03wZŽ¢õ\x1E‡zKZþ\x1FY" b"æá§\x11Žž\x08?«Þ\x1CÐsD¡ª" b"çS×Åæù\x13¯XMX_û^Û•" b"þp\x1A³Uüºãh■3z"Gwy" b"è\t!Ý\x0EM+1šô-$^çY›" b"Þ#\x0Eï═ÛÌ┐ZËn÷ ñÉP" b"èt¸×£ˆ‰¹Äw\x01\x0Fl*›\v" b"èÂY(\x17®d\óøÇ\x02ý½ÍÊ" b"èÜŒuÁ\x12{•5ÕÓB´ÈƒÐ" b"Ú%\tï$\x05Í@Åð:)À╣¥\x11" b""" Únµ\x08s\n 1¼└ÿ,ÅùQÌ£ """ b"é{lìA"»Oñ’}€¾3Ü" b"Ú█z\x16ıº2T\ØH]}Mg\x11" b"éöÏ#¹AS\x7F¨BvÓP\x13™»" b"ê\x16c9äü\x18Çð ²'gË›" b"Û6BY(rØàj\x11ã[╝U4o" b"Û:"r^\r-\x19╬ZßÚ#uØU" b"êS\x16ÉØú\x14ÆÌ3ƒáÕÔt†" b"ê•b`AlÝ>Å\x05XJƒ€\®" b"Û╚&~ß,│┬▀3¤ý▒╦õì" b"ÛÕ÷ð}XøÄì\r¸#È:F┐" b"êéß݃…F›anÖ\rW\vèZ" b"ì\x17(×\x19Iû/Pb†Ÿ-\x00 û" b"ìqž\x12\x03É0"éé-H¸M\x1E!" b"ݽeZb■¼ÑàÏ©IÕZ9ì" b"íÄ`Š¿Dj‡\x7F¿úP[wŠ\x19" b"¯[ÖsP`JØ1´,£Ò°╠·" b"î¡p\x1D”gx¸c’ye3‡/ž" b"îÙëè&w2yèè^ûå²+A" b""" îÞ;î¡\x10mýNÛÙÛ—P\n œ """ b"îö™«\fLõ\x17¹n\x05Èü·Êõ" b"´\x1F┤¹O fÖÆƧ«Étü\x0F" b"ïj½›\x02—(ÃkÐ)Ý‚Î<ô" b"ïkQ!‡\x02U/7裿Ð>Ãò" b"ï•šÑ>¯\x02”\x04\x05\x00JƱ¦E" b"ï˳™\x10\x7FO¥Ò?$ iŸö:" b"ðS•J˜M¹EÛp\x19\x1CªKt×" b"^\x16(ô 7E¼■1Þj▀Üì" b"ð•Ì–\tŽtaUËC\x17ËohM" b"ñj̈t«\x19¢bRy\x17\x08¨ß‹" b"±ÿ\x1CeÚÕZT?█▒¸\rÉ\vâ" b"ñ¨OèÖ‡Ó·%0¹ûOë–ø" b"ñÜmDç)*CÚþgù\x1D›š’" b"‗\x19×AÅ#õ║è-4R╦■Ѫ" b"‗XıìO\x16-ëæ?±├¸Où┴" b"òn¡†g¶¢½u\x00N¨îô\x04ð" b"ò”ôæ}wWïôCe&Ug®ï" b"ò¿!öüH~óåˆà8’%YÐ" b"óbǯµýÝ~y€çò\t›¤'" b"óˆëMxñПN\x0E\eŸ8óáS" b"ó™ø„°M)?Ò®\x07í\x0EÛ%ò" b"ó·QUóö[(èç"ánè~5" b"óȯt/\x10ó\x18Ÿ\e¼Íă2f" b"ô+g\x18øÝâÊT\x18sÃ\x0Fï‡i" b"ô/ë>š]A;\x18‘Ç»›:\x19Í" b"ô¢æ\rÀú\x17\x08~Õ²HKêJ\x05" b"ôÓ4\v¨óã¿@j¹zä!Ë•" b"õžÙŸ$©ŠG˜_\x1Ei‹0?" b"õ´D\x10žÙD’³çÜ}\x17\x03zº" b"õ×"¶À 9–Ï`i<]£Z’" b"ö)P¿AÙùgYðOž\x08y¹à" b"ö„:"8š†aóÍ\x1EAâG¹˜" b"öË WCôb\x1EÕ\x06‹z”ÀœÜ" b"ö÷êó‘]½µÆ\x1D.Ó\x05•º\x10" b"÷/\x13(«\x1C™Ë¢Å/Yo\x1A!†" b"÷C«lóQ8C±WæÔ ƒ^" b"ø\x00r\x10_\x1A\x01.\t„€t„×É•" b""" °* éI\x10Á└1■\n ü%þÃz """ b"ø@h\x05MôåÉwˆw^\x06؈[" b"°£ê\x15»Óüdºé╔╦·\x11\x19]" b"ù"POÕž4ç¼´„H:ôÅP" b"ù_jhå±\vã@\x1A£˜¬3wn" b"ùߟIÄܽ MäXŽ{Ÿ ¿" b"ú^˜¤Ò\eÍ\x10\x17á–ß\x1C\x7Fo–" b"úhé®\x14·Î×\rëe\x15Þ†HB" b"ú‹ËVü)¸I]/p\e~\x12T=" b"úœ$T#°\x7Få¿&Î'Á¹Xg" b"úþ’Uôi\ez\x11ƒ£Eà\Å1" b"û6¥ÑDª[È\x00§\x1D,¼JÜŸ" b"ûd+"o/Lfw‰…¨¯M†J" b"ûh"E¾\vy|oŽÀ%Føì\x01" b"û“©\fztï©*¹\x1FwúVÂú" b"û£ªà\rÃ)\x0Eg‰2´j%\tß" b"ûÇ05¨•—Ä%ÖØy#³‰e" b"¹Ï\x10íåØ\x08⃶nJV|\vù" b"üA\x13}Hõ¼ª€5ßþ7\x12*Ÿ" b"ü~ž5låf%ÓÑÃÝ=xºØ" b"üˆIÿ-´–qÿÁ\#•§®7" b"üãWŸÐ«b) x¥íZr\f÷" b"üç›x#{ÀÃ…·2RW\tG~" b"²4ÈL┤c?ìý4├fs\x1A║╦" b"þ!règTcl/q*Æ¥V:\x06" b"þ/W⳶°,\x03\x1Eð™ç•VI" b"þJ“IŸæÏn\x1C„éÈ—Y~å" b"þÁwVg‚zä\x1F½Áz‚,pe" b"þìä]â„Ͳͽ\fϼ\x1EP†" b" \x13qÍ▄®¤³[××\x12Ô╬ü" true ] |
||||||||||||||||||||||||||||||
|
3.09 ms (9.29%) |
4 |
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`, COALESCE(`media.translation.title`,`media.translation.title`) as `media.title`, `media.translation.alt`, COALESCE(`media.translation.alt`,`media.translation.alt`) as `media.alt`, `media.translation.customFields`, COALESCE(`media.translation.customFields`,`media.translation.customFields`) as `media.customFields`, `media.translation.createdAt`, `media.translation.updatedAt`, `media.translation.mediaId`, `media.translation.languageId` 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`.title as `media.translation.title`, `media.translation`.alt as `media.translation.alt`, `media.translation`.custom_fields as `media.translation.customFields`, `media.translation`.created_at as `media.translation.createdAt`, `media.translation`.updated_at as `media.translation.updatedAt`, `media.translation`.media_id as `media.translation.mediaId`, `media.translation`.language_id as `media.translation.languageId` FROM `media_translation` `media.translation` WHERE `media.translation`.language_id = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" false true "product_download" b"\x01‹\x1E\x17ߦuKˆÚu\x07›\x03eH" ] |
||||||||||||||||||||||||||||||
|
3.07 ms (9.22%) |
11 |
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`, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `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`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` 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"ŸÃ×\x15+©3jg\x0E6Ðíy¼C" ] |
||||||||||||||||||||||||||||||
|
2.49 ms (7.47%) |
1 |
SELECT `id`, `old_url`, `new_url`, `old_url_regex`, `search_url_by` ,`temporary`, ? REGEXP `old_url_regex` as regex0, ? REGEXP `old_url_regex` as regex2, ? REGEXP `old_url_regex` as regex3 FROM `acris_seo_redirect` WHERE `active` = ? AND ((NOT (`search_url_by` = ?) AND ((`old_url` = ? OR `old_url` = ? OR `old_url` = ?))) OR (`search_url_by` = ? AND ((? REGEXP `old_url_regex` OR ? REGEXP `old_url_regex` OR ? REGEXP `old_url_regex`)))) LIMIT 6;
Parameters:
[ "/Unix-Anteo-Vorderradkorb/7360" "https://stage-sw6.radwelt-shop.de/Unix-Anteo-Vorderradkorb/7360" "stage-sw6.radwelt-shop.de/Unix-Anteo-Vorderradkorb/7360" 1 "regex" "/Unix-Anteo-Vorderradkorb/7360" "https://stage-sw6.radwelt-shop.de/Unix-Anteo-Vorderradkorb/7360" "stage-sw6.radwelt-shop.de/Unix-Anteo-Vorderradkorb/7360" "regex" "/Unix-Anteo-Vorderradkorb/7360" "https://stage-sw6.radwelt-shop.de/Unix-Anteo-Vorderradkorb/7360" "stage-sw6.radwelt-shop.de/Unix-Anteo-Vorderradkorb/7360" ]
|
||||||||||||||||||||||||||||||
|
2.18 ms (6.54%) |
1 |
# Manufacturer getManufacturerByChar manufacturer::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.media`.`id` as `product_manufacturer.media.id`, `product_manufacturer.media`.`user_id` as `product_manufacturer.media.userId`, `product_manufacturer.media`.`media_folder_id` as `product_manufacturer.media.mediaFolderId`, `product_manufacturer.media`.`mime_type` as `product_manufacturer.media.mimeType`, `product_manufacturer.media`.`file_extension` as `product_manufacturer.media.fileExtension`, `product_manufacturer.media`.`uploaded_at` as `product_manufacturer.media.uploadedAt`, `product_manufacturer.media`.`file_name` as `product_manufacturer.media.fileName`, `product_manufacturer.media`.`file_size` as `product_manufacturer.media.fileSize`, `product_manufacturer.media`.`media_type` as `product_manufacturer.media.mediaTypeRaw`, `product_manufacturer.media`.`meta_data` as `product_manufacturer.media.metaData`, `product_manufacturer.media`.`config` as `product_manufacturer.media.config`, `product_manufacturer.media`.`path` as `product_manufacturer.media.path`, `product_manufacturer.media`.`private` as `product_manufacturer.media.private`, `product_manufacturer.media`.`thumbnails_ro` as `product_manufacturer.media.thumbnailsRo`, `product_manufacturer.media`.`created_at` as `product_manufacturer.media.createdAt`, `product_manufacturer.media`.`updated_at` as `product_manufacturer.media.updatedAt`, `product_manufacturer.media.translation.title`, COALESCE(`product_manufacturer.media.translation.title`,`product_manufacturer.media.translation.title`) as `product_manufacturer.media.title`, `product_manufacturer.media.translation.alt`, COALESCE(`product_manufacturer.media.translation.alt`,`product_manufacturer.media.translation.alt`) as `product_manufacturer.media.alt`, `product_manufacturer.media.translation.customFields`, COALESCE(`product_manufacturer.media.translation.customFields`,`product_manufacturer.media.translation.customFields`) as `product_manufacturer.media.customFields`, `product_manufacturer.media.translation.createdAt`, `product_manufacturer.media.translation.updatedAt`, `product_manufacturer.media.translation.mediaId`, `product_manufacturer.media.translation.languageId`, `product_manufacturer.translation.name`, COALESCE(`product_manufacturer.translation.name`,`product_manufacturer.translation.name`) as `product_manufacturer.name`, `product_manufacturer.translation.description`, COALESCE(`product_manufacturer.translation.description`,`product_manufacturer.translation.description`) as `product_manufacturer.description`, `product_manufacturer.translation.customFields`, COALESCE(`product_manufacturer.translation.customFields`,`product_manufacturer.translation.customFields`) as `product_manufacturer.customFields`, `product_manufacturer.translation.createdAt`, `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation.languageId`, `product_manufacturer.translation.productManufacturerVersionId` 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`, `product_manufacturer.translation`.created_at as `product_manufacturer.translation.createdAt`, `product_manufacturer.translation`.updated_at as `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation`.product_manufacturer_id as `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation`.language_id as `product_manufacturer.translation.languageId`, `product_manufacturer.translation`.product_manufacturer_version_id as `product_manufacturer.translation.productManufacturerVersionId` 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 `media` `product_manufacturer.media` ON `product_manufacturer`.`media_id` = `product_manufacturer.media`.`id` LEFT JOIN (SELECT `product_manufacturer.media.translation`.media_id, `product_manufacturer.media.translation`.title as `product_manufacturer.media.translation.title`, `product_manufacturer.media.translation`.alt as `product_manufacturer.media.translation.alt`, `product_manufacturer.media.translation`.custom_fields as `product_manufacturer.media.translation.customFields`, `product_manufacturer.media.translation`.created_at as `product_manufacturer.media.translation.createdAt`, `product_manufacturer.media.translation`.updated_at as `product_manufacturer.media.translation.updatedAt`, `product_manufacturer.media.translation`.media_id as `product_manufacturer.media.translation.mediaId`, `product_manufacturer.media.translation`.language_id as `product_manufacturer.media.translation.languageId` FROM `media_translation` `product_manufacturer.media.translation` WHERE `product_manufacturer.media.translation`.language_id = ?) `product_manufacturer.media.media_translation` ON `product_manufacturer.media.media_translation`.`media_id` = `product_manufacturer.media`.`id` WHERE (`product_manufacturer`.`version_id` = ?) AND (`product_manufacturer`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"Ø"Úðµô1a╦ã/;\x1A7n█" b"9\x0Föê\x18„…ˆ\x18\x13¨ätåÅŽ" b""" K½œ#è\x10¡\n )“WêL+”ÿ """ b"¿ëì49█fÔªp)@gÝ´┐" b"D½Îã‚ DÂK§G{3±b\e" b"…~¨ª'cÞ\x1C2öÄÓ·èµ" b"£å:\x18wí\x03¾åÚÛê•k\x00þ" b"q©$tµÄ\x1A@#0ùÜÖ6²ü" b"«ùÍA,¦xêë\f"<Q\x06Æ«" b"ÏŠ?Y«éP"\x11oZflƒgÿ" b"÷ˆ3´\Fó-Y" 6°`b " b"ëä¬!%\x06\x10PêoOaÐÿÁÝ" b"O\x0Eh´\x7FDYl\x1Dl&‚}g³&" b"oøº¶Ö®\x1CÈî,\r\x16°V \e" b"¶6´P\x06ôìõÂ$\fEYý╝½" b"ó,"ÊÂó\x05ÄCÒúÉ\x03V\x08Ì" b"┘\x084Mü╚0\x101E─ƒÇ\x03:Ã" b"Û\x1C‡@-þµÝ\x00¯E˜Ð¢Wº" b"äÚ;\x7F»Î#E×w+\x06t£\x18Õ" b"db3\x1AiÍÇ·mÈ\x116Ê'\x13Ý" b"\x10Ð0|\x11QCëä!&9qu\x1A " b"jÞe•+>†Þu†]1tž;u" b"åL¢\n\x00¸.‘ãÁõq\x06¼‡Î" b"Æ╚\x7FÆë'ü/\x15ê¡Å\x1FÝÍË" b"AY"\x16ÿÎ]vXÞÚ\e~¡I©" b"–È4\x17‘Y›×\x05¥\x16–² \x05" b"åÚ\x13hPúÆN§ùd~atR7" b"ÞL\x01iæ”Oý\g$^Ò|(U" b"Ø\x08E»\x7FË_½”×\x02‹òãE\t" b""" 6$\n └╝'ìí\x10:>§.¾°A """ b"ÁÌ$öâf¡18©ÅSÉ¿ªH" b"–Ž\x12äË°\x08#¥Vû^ñZÛs" b"©S─Ã\x1A©3²NØ┼Y1Øu\x15" b"ä\x10\x0EŽ¹È\tÝN¸ÐT^˜ÞH" b"─uFü=¨Süñ@\x1D¾I Õ|" b"¦y8ž¹—ž\x15òõåÆHTèJ" b"'6\x11\x01§O\x1E߈$ñPÐ;Vž" b"#¶Þwh\x16^ù¦‡˜‡±ç\t´" b"L■>í\x07±iü├åÒ&ù\x7FÚ~" b"9^"â\x16Áv–¸—<Â,ßÿ\x01" b"^─Åc░║#¨,Å·îé\x12s¨" b"4║╩@ì*\x10ÊhÑÉ[ú&aG" b"'HY[\x07‡Í"žÕ)v“nÌS" b"™\x14´¡dSK|Õ©8^£k°ù" b";$°\x05põa<Èpnã—°À" b"Ål©&sÏ~\x7Fñ\x11{×q┌█Y" b"¢”È\f>íåñL–éu6ï\x08\x0E" b""ðÑÛŠKÿáʤQm9\x15ˆ¥" b""" è{*Ùs\x02ŽU\n Ó\ezAÓ-ñ """ b"ˆö\x01…P$7Ö\edʤÈàRÀ" b"ÝÙ<¹ÀN…XÀ¤Û{ÅHíL" b"\vr$ÿ°çk`(\x12âx™Æß\x7F" b"øŸ…i(Qö|¥úþ¼"S[ö" b"¿ya/8û‡#‚Ý‚tŸï\\x07" b"myé\eý\tvv™\x05\x1E¤£€QÃ" b"\x0Fߎæñ˜\x17d\x1Dý¹\x18Åí\r§" b"▒ää\x03iiÅ|7ÓÆ\tC×åã" b"\ewf:Õ}hüe#í¶…\x18G\x19" b"ÊÉ‘ÌGõÈs\x04d\x7Fm†ºM‹" b"‘H#„Ñ\x12ð¼PÿŠ‚W\x06×\x0F" b"┬wØþ\x1E╣ æüÛ(æÚ;╬" b""" ÜÕõ\r"\n ú²¯Ÿ·2Ý›¿ """ b"Í•nt,Wöô1„ßÌ/e«Î" b"`ˆ\x18$•\x143l\x0Eë\x06t{´>" b"~æq\x00ï\v\rX:P9^¯?2…" b">ï¹èļ\x10ªwú`Hg-\x03ª" b"=7\x06'\v¸V±Á·\x11ïÓ^\x08*" b"ËÃ\x1F\x02 0ÍK©Í#hÌzÌÝ" b"ûYJY¥)ìP†\x05gèë[_é" b"ÙxãSðßO$\x04Sáór|˜§" b"¢Â\x1D\x10–XáY\x1Dã‘\x03Ô{¯" b"@ùSafç*ØäAYÇûuW\e" b"\x01m\x08]¥áaG¢°Û…µZß" b"╦│Û~ú├─"\\x13Êà¨NüÈ" b"j´(³\x16±Å\fjÚïÝQŠý\x00" b"\x06S>‡Œ\x07ïÕ\e#Ï4RÛle" b"\x08†Ž¢˜~ü)V«„.\x01ÅÒú" b"~÷\x02†ÏkéÎ\x1Džþÿ®¿ºG" b"…Ÿðzó]@¤é63]b¼²" b"ÄÊB8 ¹#‚\rÌPšou„›" b""" _QfÁñ7WÇ.\n ¶\x05ÊC p """ b"Âø\vÑ\x13¨‚žén·E|dI;" b"J¤\x7FÎ%Åt‰31´5ýÝì×" b"uk>*ïö‘·ÖtÚb•)•\x18" b"\x02q[&Kæ2\r\t ú*„\x1EeQ" b"EÄŒÎ.-\x7F½ê\x1AüQÇÆ&" b"VÙ¹┘Åƨ\x07\x04¾è\x00¥@B\x0E" b"\x14Jò¹j4ÿB´x65ûâci" b"t\x07¨§Ód?\x03Ò:}_\e\x1F\x0E\x00" b"Éí¾§BÓÚ^B¨\x10X\rÞ╗[" b"äÎ"˜[þ\f¨\vÔ\tçî ý" b"…\x02\x01<èE˜J\r#\x0F\æÜWl" b"È\x1Dî┘Å\x00▓\x04ÚÇ\tÿý°B~" b"\x00~\x03µ\f¢Ý\x06Ïî\Š*»ü•" b"ïâ>&U\x0EW«\x1A2;ÞÆ~\x0E÷" b"š)Å'saæ»–žÅÛ¼aû¢" b"ü\x17ºy‹çq¦]¤P€ô†Ã‡" b"Ò‰SÜX;ÛÈì€:Ò9Bi¼" b"ú$m\x02bÃ’V\x17°Ç+²\x0Eë\x1D" b""" u\e├¬Õ¡¸▓É%×\n ¢õV """ b"^Š\x19¹ó[4 ”¢5¾s\x031Ý" b"\x17ÙÏò¬¡KVQþlq\x19Kî" b"│U\x06Ȥ*ì│üX╚├\º2v" b"Áé\x16£_¬‹80ò-èëØðÙ" b"ªØ®ráÇ┬\f«¯èc!ä<Ë" b"\e³S¡ÏÒ¯álÚF;\x07\x1F-ƒ" b"\x16\x04ÜÒUM║&n³╔ø╠<Pü" b"Ôsµ\t\t\x0FÔã\x1E_¦snþ½ï" b"Ѐ‹\x1C7°Ìó:"øȯÃÅ¢" b"骾\rwÕbº\x12+6'#•ng" b"\x11ú0\x16Îö{2暨1’œÊ" b"hj\x08ÐûرGü>ª\x18╦╬v¥" b"\x15ÕÖÔ ïÝá¿:QîÆœ—J" b"\fE©\x01C\x0E-UOS:6ÞR´Ê" b"\x11:€%žê-«ì´ñÓ_Z¯¸" b"2¸Ø?A\x1EÏ\r6 …\rÑÔDª" b"ÈÕ4Ô0§Ä\x14°Y“d¾ØíQ" b""" ¯þßµÅ╚ÕÓ\x1CÆ8òßW\n ¤ """ b"¢òõ`è\x19Ÿ!5ò À\x1AøtJ" b"oÈijDXüÜA%1M║Ø╩Ê" b"ËNù®\x00±‰@d^Iª[–‰Ä" b"\r†K\x0E÷ö o\x14j»Î³Òø\x1A" b"░ÕÈ?ô│U²\x0E¢Å:KåÑ" b"ª\x00³hg`ýñõ@¾l3fb–" b"\x1Ea=Í\x06±û˜.mq^¨ßW" b"ú?Ë›~â\x1DaBiB¹j®3é" b"áøÕé¯}¶ª¶\x157P\x11\x119ü" ] |
||||||||||||||||||||||||||||||
|
2.17 ms (6.53%) |
1 |
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`.`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`, COALESCE(`product.manufacturer.translation.name`,`product.manufacturer.translation.name`) as `product.manufacturer.name`, `product.manufacturer.translation.description`, COALESCE(`product.manufacturer.translation.description`,`product.manufacturer.translation.description`) as `product.manufacturer.description`, `product.manufacturer.translation.customFields`, COALESCE(`product.manufacturer.translation.customFields`,`product.manufacturer.translation.customFields`) as `product.manufacturer.customFields`, `product.manufacturer.translation.createdAt`, `product.manufacturer.translation.updatedAt`, `product.manufacturer.translation.productManufacturerId`, `product.manufacturer.translation.languageId`, `product.manufacturer.translation.productManufacturerVersionId`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`,`product.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`,`product.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`,`product.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`,`product.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`,`product.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`,`product.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`,`product.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`,`product.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`,`product.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`,`product.translation.customFields`) as `product.customFields`, `product.translation.createdAt`, `product.parent.translation.createdAt`, `product.translation.updatedAt`, `product.parent.translation.updatedAt`, `product.translation.productId`, `product.parent.translation.productId`, `product.translation.languageId`, `product.parent.translation.languageId`, `product.translation.productVersionId`, `product.parent.translation.productVersionId` 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 (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_search_keywords as `product.translation.customSearchKeywords`, `product.translation`.slot_config as `product.translation.slotConfig`, `product.translation`.custom_fields as `product.translation.customFields`, `product.translation`.created_at as `product.translation.createdAt`, `product.translation`.updated_at as `product.translation.updatedAt`, `product.translation`.product_id as `product.translation.productId`, `product.translation`.language_id as `product.translation.languageId`, `product.translation`.product_version_id as `product.translation.productVersionId` 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_search_keywords as `product.parent.translation.customSearchKeywords`, `product.parent.translation`.slot_config as `product.parent.translation.slotConfig`, `product.parent.translation`.custom_fields as `product.parent.translation.customFields`, `product.parent.translation`.created_at as `product.parent.translation.createdAt`, `product.parent.translation`.updated_at as `product.parent.translation.updatedAt`, `product.parent.translation`.product_id as `product.parent.translation.productId`, `product.parent.translation`.language_id as `product.parent.translation.languageId`, `product.parent.translation`.product_version_id as `product.parent.translation.productVersionId` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.language_id = ?) `product.product_translation.parent` ON `product.product_translation.parent`.`product_id` = `product.parent`.`id` AND `product.product_translation.parent`.product_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 (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`, `product.manufacturer.translation`.created_at as `product.manufacturer.translation.createdAt`, `product.manufacturer.translation`.updated_at as `product.manufacturer.translation.updatedAt`, `product.manufacturer.translation`.product_manufacturer_id as `product.manufacturer.translation.productManufacturerId`, `product.manufacturer.translation`.language_id as `product.manufacturer.translation.languageId`, `product.manufacturer.translation`.product_manufacturer_version_id as `product.manufacturer.translation.productManufacturerVersionId` 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`.`version_id` = ?) AND ((`product`.`id` = ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"äN‡\\x12\x10žO£ql\x05\x00€H²" ] |
||||||||||||||||||||||||||||||
|
1.03 ms (3.08%) |
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`, COALESCE(`media.translation.title`,`media.translation.title`) as `media.title`, `media.translation.alt`, COALESCE(`media.translation.alt`,`media.translation.alt`) as `media.alt`, `media.translation.customFields`, COALESCE(`media.translation.customFields`,`media.translation.customFields`) as `media.customFields`, `media.translation.createdAt`, `media.translation.updatedAt`, `media.translation.mediaId`, `media.translation.languageId` 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`.title as `media.translation.title`, `media.translation`.alt as `media.translation.alt`, `media.translation`.custom_fields as `media.translation.customFields`, `media.translation`.created_at as `media.translation.createdAt`, `media.translation`.updated_at as `media.translation.updatedAt`, `media.translation`.media_id as `media.translation.mediaId`, `media.translation`.language_id as `media.translation.languageId` FROM `media_translation` `media.translation` WHERE `media.translation`.language_id = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" false true "product_download" b"\x01ï\x1Ed╗¼yÅûO¹\x0E\x07E\x04ï" b"\x01‹\x1E„¥ðqï¿Ùÿ.‘~&ñ" b"\x01‹\x1E…F'}@§\x13kßeíI½" b"\x01‹\x1E…¸àr©œ8ßDsMŽ" ] |
||||||||||||||||||||||||||||||
|
0.94 ms (2.84%) |
1 |
SELECT `product_review`.`points` as `ratingMatrix.key`, COUNT(`product_review`.`id`) as `ratingMatrix.count` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` WHERE ((`product_review`.`status` = ? AND (`product_review.product`.`id` = ? OR `product_review.product`.`parent_id` = ?))) AND ((`product_review`.`status` = ?)) GROUP BY `product_review`.`points`
Parameters:
[ 1 b"äN‡\\x12\x10žO£ql\x05\x00€H²" b"äN‡\\x12\x10žO£ql\x05\x00€H²" 1 ] |
||||||||||||||||||||||||||||||
|
0.68 ms (2.05%) |
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:
[ "/detail/e44e875c12109e4fa3716c05008048b2" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" ] |
||||||||||||||||||||||||||||||
|
0.66 ms (1.99%) |
1 |
SELECT `product_media`.`id` as `product_media.id`, `product_media`.`version_id` as `product_media.versionId`, `product_media`.`product_id` as `product_media.productId`, `product_media`.`product_version_id` as `product_media.productVersionId`, `product_media`.`media_id` as `product_media.mediaId`, `product_media`.`position` as `product_media.position`, `product_media.media`.`id` as `product_media.media.id`, `product_media.media`.`user_id` as `product_media.media.userId`, `product_media.media`.`media_folder_id` as `product_media.media.mediaFolderId`, `product_media.media`.`mime_type` as `product_media.media.mimeType`, `product_media.media`.`file_extension` as `product_media.media.fileExtension`, `product_media.media`.`uploaded_at` as `product_media.media.uploadedAt`, `product_media.media`.`file_name` as `product_media.media.fileName`, `product_media.media`.`file_size` as `product_media.media.fileSize`, `product_media.media`.`media_type` as `product_media.media.mediaTypeRaw`, `product_media.media`.`meta_data` as `product_media.media.metaData`, `product_media.media`.`config` as `product_media.media.config`, `product_media.media`.`path` as `product_media.media.path`, `product_media.media`.`private` as `product_media.media.private`, `product_media.media`.`thumbnails_ro` as `product_media.media.thumbnailsRo`, `product_media.media`.`created_at` as `product_media.media.createdAt`, `product_media.media`.`updated_at` as `product_media.media.updatedAt`, `product_media.media.translation.title`, COALESCE(`product_media.media.translation.title`,`product_media.media.translation.title`) as `product_media.media.title`, `product_media.media.translation.alt`, COALESCE(`product_media.media.translation.alt`,`product_media.media.translation.alt`) as `product_media.media.alt`, `product_media.media.translation.customFields`, COALESCE(`product_media.media.translation.customFields`,`product_media.media.translation.customFields`) as `product_media.media.customFields`, `product_media.media.translation.createdAt`, `product_media.media.translation.updatedAt`, `product_media.media.translation.mediaId`, `product_media.media.translation.languageId`, `product_media`.`custom_fields` as `product_media.customFields`, `product_media`.`created_at` as `product_media.createdAt`, `product_media`.`updated_at` as `product_media.updatedAt` FROM `product_media` LEFT JOIN `media` `product_media.media` ON `product_media`.`media_id` = `product_media.media`.`id` LEFT JOIN (SELECT `product_media.media.translation`.media_id, `product_media.media.translation`.title as `product_media.media.translation.title`, `product_media.media.translation`.alt as `product_media.media.translation.alt`, `product_media.media.translation`.custom_fields as `product_media.media.translation.customFields`, `product_media.media.translation`.created_at as `product_media.media.translation.createdAt`, `product_media.media.translation`.updated_at as `product_media.media.translation.updatedAt`, `product_media.media.translation`.media_id as `product_media.media.translation.mediaId`, `product_media.media.translation`.language_id as `product_media.media.translation.languageId` FROM `media_translation` `product_media.media.translation` WHERE `product_media.media.translation`.language_id = ?) `product_media.media.media_translation` ON `product_media.media.media_translation`.`media_id` = `product_media.media`.`id` WHERE (`product_media`.`version_id` = ?) AND (`product_media`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"¸Ù›Î\t/É1ˆ\x11r‘JCôØ" ] |
||||||||||||||||||||||||||||||
|
0.61 ms (1.84%) |
1 |
# seo-url::resolve SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND ((seo_path_info = ? OR seo_path_info = ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" "Unix-Anteo-Vorderradkorb/7360" "Unix-Anteo-Vorderradkorb/7360/" ] |
||||||||||||||||||||||||||||||
|
0.52 ms (1.56%) |
1 |
SELECT option_translation.name FROM product product INNER JOIN product_option product_group ON product_group.product_id = product.id INNER JOIN property_group_option product_option ON product_group.property_group_option_id = product_option.id INNER JOIN property_group_option_translation option_translation ON option_translation.property_group_option_id = product_option.id WHERE (product.id = ?) AND (product.parent_id IS NOT NULL) AND (product.option_ids IS NOT NULL) AND (option_translation.language_id = ?)
Parameters:
[ b"äN‡\\x12\x10žO£ql\x05\x00€H²" b"/»_ââšMpªXTÎ|ãâ\v" ] |
||||||||||||||||||||||||||||||
|
0.52 ms (1.55%) |
1 |
SELECT `product_review`.`id` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` WHERE (`product_review`.`status` = ? AND (`product_review.product`.`id` = ? OR `product_review.product`.`parent_id` = ?)) ORDER BY `product_review`.`points` DESC LIMIT 10
Parameters:
[ 1 b"äN‡\\x12\x10žO£ql\x05\x00€H²" b"äN‡\\x12\x10žO£ql\x05\x00€H²" ] |
||||||||||||||||||||||||||||||
|
0.48 ms (1.44%) |
4 |
# app-scripts::refresh::search-ids SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ?)
Parameters:
[
true
]
|
||||||||||||||||||||||||||||||
|
0.45 ms (1.37%) |
1 |
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.plugin`.`id` as `payment_method.plugin.id`, `payment_method.plugin`.`base_class` as `payment_method.plugin.baseClass`, `payment_method.plugin`.`name` as `payment_method.plugin.name`, `payment_method.plugin`.`composer_name` as `payment_method.plugin.composerName`, `payment_method.plugin`.`autoload` as `payment_method.plugin.autoload`, `payment_method.plugin`.`active` as `payment_method.plugin.active`, `payment_method.plugin`.`managed_by_composer` as `payment_method.plugin.managedByComposer`, `payment_method.plugin`.`path` as `payment_method.plugin.path`, `payment_method.plugin`.`author` as `payment_method.plugin.author`, `payment_method.plugin`.`copyright` as `payment_method.plugin.copyright`, `payment_method.plugin`.`license` as `payment_method.plugin.license`, `payment_method.plugin`.`version` as `payment_method.plugin.version`, `payment_method.plugin`.`upgrade_version` as `payment_method.plugin.upgradeVersion`, `payment_method.plugin`.`installed_at` as `payment_method.plugin.installedAt`, `payment_method.plugin`.`upgraded_at` as `payment_method.plugin.upgradedAt`, `payment_method.plugin`.`icon` as `payment_method.plugin.iconRaw`, `payment_method.plugin`.`created_at` as `payment_method.plugin.createdAt`, `payment_method.plugin`.`updated_at` as `payment_method.plugin.updatedAt`, `payment_method.plugin.translation.label`, COALESCE(`payment_method.plugin.translation.label`,`payment_method.plugin.translation.label`) as `payment_method.plugin.label`, `payment_method.plugin.translation.description`, COALESCE(`payment_method.plugin.translation.description`,`payment_method.plugin.translation.description`) as `payment_method.plugin.description`, `payment_method.plugin.translation.manufacturerLink`, COALESCE(`payment_method.plugin.translation.manufacturerLink`,`payment_method.plugin.translation.manufacturerLink`) as `payment_method.plugin.manufacturerLink`, `payment_method.plugin.translation.supportLink`, COALESCE(`payment_method.plugin.translation.supportLink`,`payment_method.plugin.translation.supportLink`) as `payment_method.plugin.supportLink`, `payment_method.plugin.translation.customFields`, COALESCE(`payment_method.plugin.translation.customFields`,`payment_method.plugin.translation.customFields`) as `payment_method.plugin.customFields`, `payment_method.plugin.translation.createdAt`, `payment_method.plugin.translation.updatedAt`, `payment_method.plugin.translation.pluginId`, `payment_method.plugin.translation.languageId`, `payment_method.translation.name`, COALESCE(`payment_method.translation.name`,`payment_method.translation.name`) as `payment_method.name`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableName`) as `payment_method.distinguishableName`, `payment_method.translation.description`, COALESCE(`payment_method.translation.description`,`payment_method.translation.description`) as `payment_method.description`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.customFields`,`payment_method.translation.customFields`) as `payment_method.customFields`, `payment_method.translation.createdAt`, `payment_method.translation.updatedAt`, `payment_method.translation.paymentMethodId`, `payment_method.translation.languageId` FROM `payment_method` 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`, `payment_method.translation`.created_at as `payment_method.translation.createdAt`, `payment_method.translation`.updated_at as `payment_method.translation.updatedAt`, `payment_method.translation`.payment_method_id as `payment_method.translation.paymentMethodId`, `payment_method.translation`.language_id as `payment_method.translation.languageId` 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 `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` LEFT JOIN `plugin` `payment_method.plugin` ON `payment_method`.`plugin_id` = `payment_method.plugin`.`id` LEFT JOIN (SELECT `payment_method.plugin.translation`.plugin_id, `payment_method.plugin.translation`.label as `payment_method.plugin.translation.label`, `payment_method.plugin.translation`.description as `payment_method.plugin.translation.description`, `payment_method.plugin.translation`.manufacturer_link as `payment_method.plugin.translation.manufacturerLink`, `payment_method.plugin.translation`.support_link as `payment_method.plugin.translation.supportLink`, `payment_method.plugin.translation`.custom_fields as `payment_method.plugin.translation.customFields`, `payment_method.plugin.translation`.created_at as `payment_method.plugin.translation.createdAt`, `payment_method.plugin.translation`.updated_at as `payment_method.plugin.translation.updatedAt`, `payment_method.plugin.translation`.plugin_id as `payment_method.plugin.translation.pluginId`, `payment_method.plugin.translation`.language_id as `payment_method.plugin.translation.languageId` FROM `plugin_translation` `payment_method.plugin.translation` WHERE `payment_method.plugin.translation`.language_id = ?) `payment_method.plugin.plugin_translation` ON `payment_method.plugin.plugin_translation`.`plugin_id` = `payment_method.plugin`.`id` WHERE (`payment_method`.`id` = ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"¸©Å╔└\x10G\x02®ofM½■&V" ] |
||||||||||||||||||||||||||||||
|
0.45 ms (1.36%) |
4 |
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.29 ms (0.87%) |
1 |
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.translation.name`, COALESCE(`payment_method.translation.name`,`payment_method.translation.name`) as `payment_method.name`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableName`) as `payment_method.distinguishableName`, `payment_method.translation.description`, COALESCE(`payment_method.translation.description`,`payment_method.translation.description`) as `payment_method.description`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.customFields`,`payment_method.translation.customFields`) as `payment_method.customFields`, `payment_method.translation.createdAt`, `payment_method.translation.updatedAt`, `payment_method.translation.paymentMethodId`, `payment_method.translation.languageId` FROM `payment_method` 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`, `payment_method.translation`.created_at as `payment_method.translation.createdAt`, `payment_method.translation`.updated_at as `payment_method.translation.updatedAt`, `payment_method.translation`.payment_method_id as `payment_method.translation.paymentMethodId`, `payment_method.translation`.language_id as `payment_method.translation.languageId` 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 `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` WHERE `payment_method`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x01‰NÒÃûsú´¶½\x03Dh{â" b""" \x01‰NÓ\n ¸q豬ÿJÎ%\x03: """ b""" \x01‰NÓ\n ºr\x17•j\z€úƒ> """ b""" \x01‰NÓ\n »r\x06 Ù½¿UÀå\x19 """ b""" \x01ëNË\n ╝rØÜ0.BÞçR█ """ b""" \x01ëNË\n ╝rØÜ0.BÚ+\t╠ """ b"\x01ëdch?p\x06ÅÁôòjÈh®" b"\x01‰dg§Ðq?¼÷7„\x01l9¾" b"\x01‰dg§Ðq?¼÷7„\x027€" b"\x01‰dg§Ðq?¼÷7„\x02æ\x16\x03" b"\x01‰dg§Ðq?¼÷7„\x03=‹u" b"\x01‰dg§Ðq?¼÷7„\x04ŸµÛ" b"\x01‰dg§Ðq?¼÷7„\x04´\x17" b"\x01‰dg§Ðq?¼÷7„\x05ÆÏç" b"\x01‰dg§Ðq?¼÷7„\x06YRõ" b"\x01‰dg§Ðq?¼÷7„\x07:ײ" b"\x01‰dg§Ðq?¼÷7„\x08\x01\x03ß" b"\x01Œ «\x1DŠ\x7F®‡Ì¤@œ\x1D•\x12" b"\x01Ä\x07ø[¢q ØÊk<┤\x06ÝZ" b"\x01Ä\x18eÒËs7ÿ=IØ\x02\x1688" b"\x01Ž1Ë‘Tq˜Ÿ—D „„Ûö" b"\x01–ç\x16Ÿ\x17qG•\x1F£ç\x1FÍ0#" b"\x01˜1 éYy9¬ í{8`w\x0E" b"\UùŠ9my!eE^\x07Š<_" b"¸©Å╔└\x10G\x02®ofM½■&V" ] |
||||||||||||||||||||||||||||||
|
0.26 ms (0.78%) |
4 |
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.25 ms (0.77%) |
2 |
SELECT `sales_channel`.`id` FROM `sales_channel` LEFT JOIN `sales_channel_payment_method` `sales_channel.paymentMethods.mapping` ON `sales_channel`.`id` = `sales_channel.paymentMethods.mapping`.`sales_channel_id` LEFT JOIN `payment_method` `sales_channel.paymentMethods` ON `sales_channel.paymentMethods.mapping`.`payment_method_id` = `sales_channel.paymentMethods`.`id` WHERE ((`sales_channel`.`id` = ? AND `sales_channel.paymentMethods`.`id` = ? AND `sales_channel.paymentMethods`.`active` = ?)) LIMIT 1
Parameters:
[ b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" b"¸©Å╔└\x10G\x02®ofM½■&V" true ] |
||||||||||||||||||||||||||||||
|
0.25 ms (0.75%) |
1 |
SELECT `country`.`id` as `country.id`, `country`.`iso` as `country.iso`, `country`.`position` as `country.position`, `country`.`active` as `country.active`, `country`.`shipping_available` as `country.shippingAvailable`, `country`.`iso3` as `country.iso3`, `country`.`display_state_in_registration` as `country.displayStateInRegistration`, `country`.`force_state_in_registration` as `country.forceStateInRegistration`, `country`.`check_vat_id_pattern` as `country.checkVatIdPattern`, `country`.`vat_id_required` as `country.vatIdRequired`, `country`.`vat_id_pattern` as `country.vatIdPattern`, `country`.`customer_tax` as `country.customerTax`, `country`.`company_tax` as `country.companyTax`, `country`.`postal_code_required` as `country.postalCodeRequired`, `country`.`check_postal_code_pattern` as `country.checkPostalCodePattern`, `country`.`check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern`, `country`.`advanced_postal_code_pattern` as `country.advancedPostalCodePattern`, `country`.`default_postal_code_pattern` as `country.defaultPostalCodePattern`, `country`.`is_eu` as `country.isEu`, `country`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, `country.translation.name`, COALESCE(`country.translation.name`,`country.translation.name`) as `country.name`, `country.translation.addressFormat`, COALESCE(`country.translation.addressFormat`,`country.translation.addressFormat`) as `country.addressFormat`, `country.translation.customFields`, COALESCE(`country.translation.customFields`,`country.translation.customFields`) as `country.customFields`, `country.translation.createdAt`, `country.translation.updatedAt`, `country.translation.countryId`, `country.translation.languageId` FROM `country` LEFT JOIN (SELECT `country.translation`.country_id, `country.translation`.name as `country.translation.name`, `country.translation`.address_format as `country.translation.addressFormat`, `country.translation`.custom_fields as `country.translation.customFields`, `country.translation`.created_at as `country.translation.createdAt`, `country.translation`.updated_at as `country.translation.updatedAt`, `country.translation`.country_id as `country.translation.countryId`, `country.translation`.language_id as `country.translation.languageId` FROM `country_translation` `country.translation` WHERE `country.translation`.language_id = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x01‰NÒâq囩±â4Rú¤" b"\x01ëNÊ├®s󪶽┤═\x7F?Å" b"\x01ëNÊ├Óp<½¦_VìB\x02V" b"\x01ëNÊ├ßq\x07½ËÃÉ▀ù,ƒ" b"\x01‰NÒÃâp¹†lŠ\x1D\x1AŽÍc" b"\x01‰NÒÃãpÓ¿QS6\x07ðï½" b"\x01‰NÒÃãpÓ¿QS6\x08d'5" b"\x01ëNÊ├õp»øE©}ü\x16Þe" b"\x01ëNÊ├õp»øE©}üEÀÑ" b"\x01ëNÊ├õp»øE©}üÅ_W" b"\x01‰NÒÃårÕ´³\x18/DB {" b"\x01‰NÒÃårÕ´³\x18/Dt\x1Fê" b"\x01‰NÒÃòqÿ‹Ü…–Ó|¼\x08" b"\x01‰NÒÃóq··Ë,\x00ÂíbW" b"\x01‰NÒÃóq··Ë,\x00Ä\x06$Ÿ" b"\x01‰NÒÃôr¶¬Û|Qixa\x19" b"\x01‰NÒÃôr¶¬Û|Qjs5E" b""" \x01‰NÒÃösw•\n ;\x01@\x10\x05% """ b""" \x01‰NÒÃösw•\n ;\x01@–ÎÏ """ b""" \x01‰NÒÃösw•\n ;\x01@¬÷Y """ b"\x01‰NÒÃ÷s뱊\x04ãø,A" b"\x01ëNÊãÓqSüê(zÆ<n█" b"\x01‰NÒÆâpH–×%óáÎ\x1Dp" b"\x01‰NÒÆâpH–×%óâÇ-N" b"\x01‰NÒÆãsÖ¾zŽ‰’O²\x1A" b"\x01‰NÒÆäslŸ\x1E®M¡eS)" ] |
||||||||||||||||||||||||||||||
|
0.23 ms (0.70%) |
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`, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `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`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` 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`.`product_assignment_type` = ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" "product_stream" ] |
||||||||||||||||||||||||||||||
|
0.22 ms (0.67%) |
1 |
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?)
Parameters:
[ b"\x01—ô*Yžr4´qxkØ%›¡" b"\x01—ô*ZSq\f‘q\x04!\x18´)×" ] |
||||||||||||||||||||||||||||||
|
0.22 ms (0.67%) |
1 |
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
b"""
\x01‰NÒÃùrXƒý>,˜\n
Úª
"""
b"\x01ëNÊ├■r>×~gÉ╗b¡┴"
b"\x01‰NÒÆ1psŠÁû\x06âù£Ï"
b"\x01‰NÒÄ\vsç¢y%ý±g\x01«"
b"\x01‹)\x15Ü\x11uošã3\x1D‹#½å"
b"\x01‹4Lˆ0q¼€£P›Ä\x041@"
b"\x01‹4MV1|B¿D»s6—2D"
b"\x01‹4O[ }š˜¸l[ÇÑA\n"
b"\x01‹4P\x0E…zã«\x1CÿÏ\x15”×{"
b"\x01‹8ܱ9rm§çö/¯ñ`ú"
b"\x01‹8áNw~8š8ŒÙ\x17\@Ì"
b"\x01‹®\x1Di¼u±ª‚\x03\x16«â\x11ò"
b"\x01‹×?\t×pU•ºÿ,Œù"\x03"
b"\x01Œ\x15¸Þœp•™ßvŒ¶¢$¾"
b"\x01î\x19¨ê¬|±║Åöc╦9\x04è"
b"\x01—^óŒÅs4Œp)õ\x03¼Õ"
b"äNg‚ÆBG·–¸‘Ï%®8÷"
]
|
||||||||||||||||||||||||||||||
|
0.22 ms (0.66%) |
1 |
# breadcrumb-extension::read SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `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`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` 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"(Ý,yUÎ’dV$\v/ð\x10\vÞ" b"ŸÃ×\x15+©3jg\x0E6Ðíy¼C" b""" \x02R*+'&û\n \x03»\x19òØÙRM """ ] |
||||||||||||||||||||||||||||||
|
0.22 ms (0.65%) |
3 |
SELECT property.name, property.value, property.id, property.child_count, property.on_event, property.event_name, property.parent_id FROM wbm_data_layer_properties property WHERE (property.parent_id = ?) AND (property.module = ?)
Parameters:
[ b"1ýOf\,L\x0EÉ\x16mo╚▄êÑ" "frontend.detail.page" ] |
||||||||||||||||||||||||||||||
|
0.20 ms (0.60%) |
2 |
SELECT `payment_method`.`id` FROM `payment_method` WHERE (`payment_method`.`handler_identifier` = ? AND `payment_method`.`active` = ?)
Parameters:
[ "Kiener\MolliePayments\Handler\Method\ApplePayPayment" true ] |
||||||||||||||||||||||||||||||
|
0.20 ms (0.59%) |
1 |
# Manufacturer getManufacturerByChar manufacturer::search-ids SELECT `product_manufacturer`.`id` 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`, `product_manufacturer.translation`.created_at as `product_manufacturer.translation.createdAt`, `product_manufacturer.translation`.updated_at as `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation`.product_manufacturer_id as `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation`.language_id as `product_manufacturer.translation.languageId`, `product_manufacturer.translation`.product_manufacturer_version_id as `product_manufacturer.translation.productManufacturerVersionId` 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` = ? ORDER BY COALESCE(`product_manufacturer.translation.name`) ASC
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" ] |
||||||||||||||||||||||||||||||
|
0.19 ms (0.57%) |
1 |
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.translation.name`, COALESCE(`payment_method.translation.name`,`payment_method.translation.name`) as `payment_method.name`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableName`) as `payment_method.distinguishableName`, `payment_method.translation.description`, COALESCE(`payment_method.translation.description`,`payment_method.translation.description`) as `payment_method.description`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.customFields`,`payment_method.translation.customFields`) as `payment_method.customFields`, `payment_method.translation.createdAt`, `payment_method.translation.updatedAt`, `payment_method.translation.paymentMethodId`, `payment_method.translation.languageId` FROM `payment_method` 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`, `payment_method.translation`.created_at as `payment_method.translation.createdAt`, `payment_method.translation`.updated_at as `payment_method.translation.updatedAt`, `payment_method.translation`.payment_method_id as `payment_method.translation.paymentMethodId`, `payment_method.translation`.language_id as `payment_method.translation.languageId` 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 `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` WHERE (`payment_method`.`handler_identifier` IN (?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" "Netzkollektiv\EasyCredit\Payment\Handler\InstallmentPaymentHandler" "Netzkollektiv\EasyCredit\Payment\Handler\BillPaymentHandler" ] |
||||||||||||||||||||||||||||||
|
0.18 ms (0.55%) |
1 |
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.name`,`sales_channel.translation.name`) as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) as `sales_channel.customFields`, `sales_channel.translation.createdAt`, `sales_channel.translation.updatedAt`, `sales_channel.translation.salesChannelId`, `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name as `sales_channel.translation.name`, `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`, `sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`, `sales_channel.translation`.created_at as `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.language_id = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` WHERE `sales_channel`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" ] |
||||||||||||||||||||||||||||||
|
0.18 ms (0.54%) |
1 |
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, (SELECT GROUP_CONCAT(HEX(`sales_channel.paymentMethods.mapping`.`payment_method_id`) SEPARATOR '||') FROM `sales_channel_payment_method` `sales_channel.paymentMethods.mapping` WHERE `sales_channel.paymentMethods.mapping`.`sales_channel_id` = `sales_channel`.`id` ) as `sales_channel.paymentMethods.id_mapping`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.name`,`sales_channel.translation.name`) as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) as `sales_channel.customFields`, `sales_channel.translation.createdAt`, `sales_channel.translation.updatedAt`, `sales_channel.translation.salesChannelId`, `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name as `sales_channel.translation.name`, `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`, `sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`, `sales_channel.translation`.created_at as `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.language_id = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` WHERE `sales_channel`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" ] |
||||||||||||||||||||||||||||||
|
0.17 ms (0.50%) |
1 |
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`, COALESCE(`currency.translation.shortName`,`currency.translation.shortName`) as `currency.shortName`, `currency.translation.name`, COALESCE(`currency.translation.name`,`currency.translation.name`) as `currency.name`, `currency.translation.customFields`, COALESCE(`currency.translation.customFields`,`currency.translation.customFields`) as `currency.customFields`, `currency.translation.createdAt`, `currency.translation.updatedAt`, `currency.translation.currencyId`, `currency.translation.languageId` 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`, `currency.translation`.created_at as `currency.translation.createdAt`, `currency.translation`.updated_at as `currency.translation.updatedAt`, `currency.translation`.currency_id as `currency.translation.currencyId`, `currency.translation`.language_id as `currency.translation.languageId` 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.17 ms (0.50%) |
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.16 ms (0.49%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters:
[ b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" "EasyCreditRatenkauf.config.%" ] |
||||||||||||||||||||||||||||||
|
0.15 ms (0.46%) |
1 |
SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id` WHERE (`country`.`shipping_available` = ? AND `country.salesChannels`.`id` = ?) GROUP BY `country`.`id`
Parameters:
[ true b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" ] |
||||||||||||||||||||||||||||||
|
0.15 ms (0.46%) |
1 |
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
0.14 ms (0.43%) |
1 |
# finsearch-config::load::search-ids SELECT `finsearch_config`.`id` FROM `finsearch_config` WHERE ((`finsearch_config`.`sales_channel_id` = ? AND `finsearch_config`.`language_id` = ?)) ORDER BY `finsearch_config`.`sales_channel_id` ASC, `finsearch_config`.`id` ASC LIMIT 500
Parameters:
[ b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" b"/»_ââšMpªXTÎ|ãâ\v" ] |
||||||||||||||||||||||||||||||
|
0.14 ms (0.43%) |
1 |
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||||||||||||
|
0.14 ms (0.42%) |
1 |
SELECT `acris_snippets_product`.`id` as `acris_snippets_product.id`, `acris_snippets_product`.`assignment_active` as `acris_snippets_product.assignmentActive`, `acris_snippets_product`.`priority` as `acris_snippets_product.priority`, `acris_snippets_product`.`created_at` as `acris_snippets_product.createdAt`, `acris_snippets_product`.`updated_at` as `acris_snippets_product.updatedAt`, (SELECT GROUP_CONCAT(HEX(`acris_snippets_product.productStreams.mapping`.`product_stream_id`) SEPARATOR '||') FROM `acris_product_stream` `acris_snippets_product.productStreams.mapping` WHERE `acris_snippets_product.productStreams.mapping`.`product_snippet_id` = `acris_snippets_product`.`id` ) as `acris_snippets_product.productStreams.id_mapping`, (SELECT GROUP_CONCAT(HEX(`acris_snippets_product.salesChannels.mapping`.`sales_channel_id`) SEPARATOR '||') FROM `acris_product_sales_channel` `acris_snippets_product.salesChannels.mapping` WHERE `acris_snippets_product.salesChannels.mapping`.`product_snippet_id` = `acris_snippets_product`.`id` ) as `acris_snippets_product.salesChannels.id_mapping`, `acris_snippets_product.translation.title`, COALESCE(`acris_snippets_product.translation.title`,`acris_snippets_product.translation.title`) as `acris_snippets_product.title`, `acris_snippets_product.translation.description`, COALESCE(`acris_snippets_product.translation.description`,`acris_snippets_product.translation.description`) as `acris_snippets_product.description`, `acris_snippets_product.translation.title_separator`, COALESCE(`acris_snippets_product.translation.title_separator`,`acris_snippets_product.translation.title_separator`) as `acris_snippets_product.title_separator`, `acris_snippets_product.translation.description_separator`, COALESCE(`acris_snippets_product.translation.description_separator`,`acris_snippets_product.translation.description_separator`) as `acris_snippets_product.description_separator`, `acris_snippets_product.translation.createdAt`, `acris_snippets_product.translation.updatedAt`, `acris_snippets_product.translation.acrisSnippetsProductId`, `acris_snippets_product.translation.languageId` FROM `acris_snippets_product` LEFT JOIN (SELECT `acris_snippets_product.translation`.acris_snippets_product_id, `acris_snippets_product.translation`.title as `acris_snippets_product.translation.title`, `acris_snippets_product.translation`.description as `acris_snippets_product.translation.description`, `acris_snippets_product.translation`.title_separator as `acris_snippets_product.translation.title_separator`, `acris_snippets_product.translation`.description_separator as `acris_snippets_product.translation.description_separator`, `acris_snippets_product.translation`.created_at as `acris_snippets_product.translation.createdAt`, `acris_snippets_product.translation`.updated_at as `acris_snippets_product.translation.updatedAt`, `acris_snippets_product.translation`.acris_snippets_product_id as `acris_snippets_product.translation.acrisSnippetsProductId`, `acris_snippets_product.translation`.language_id as `acris_snippets_product.translation.languageId` FROM `acris_snippets_product_translation` `acris_snippets_product.translation` WHERE `acris_snippets_product.translation`.language_id = ?) `acris_snippets_product.acris_snippets_product_translation` ON `acris_snippets_product.acris_snippets_product_translation`.`acris_snippets_product_id` = `acris_snippets_product`.`id` WHERE `acris_snippets_product`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x01ŠÛû.˜p\e°YØ—Á€$x" ] |
||||||||||||||||||||||||||||||
|
0.14 ms (0.41%) |
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.14 ms (0.41%) |
1 |
SELECT `acris_snippets_product`.`id` FROM `acris_snippets_product` LEFT JOIN `acris_product_sales_channel` `acris_snippets_product.salesChannels.mapping` ON `acris_snippets_product`.`id` = `acris_snippets_product.salesChannels.mapping`.`product_snippet_id` LEFT JOIN `sales_channel` `acris_snippets_product.salesChannels` ON `acris_snippets_product.salesChannels.mapping`.`sales_channel_id` = `acris_snippets_product.salesChannels`.`id` WHERE ((`acris_snippets_product`.`assignment_active` = ? AND `acris_snippets_product.salesChannels`.`id` = ?)) GROUP BY `acris_snippets_product`.`id` ORDER BY LENGTH(`acris_snippets_product`.`priority`) DESC, MAX(`acris_snippets_product`.`priority`) DESC
Parameters:
[ true b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" ] |
||||||||||||||||||||||||||||||
|
0.13 ms (0.40%) |
1 |
# sales-channel::load-analytics::read SELECT `sales_channel_analytics`.`id` as `sales_channel_analytics.id`, `sales_channel_analytics`.`tracking_id` as `sales_channel_analytics.trackingId`, `sales_channel_analytics`.`active` as `sales_channel_analytics.active`, `sales_channel_analytics`.`track_orders` as `sales_channel_analytics.trackOrders`, `sales_channel_analytics`.`anonymize_ip` as `sales_channel_analytics.anonymizeIp`, `sales_channel_analytics`.`created_at` as `sales_channel_analytics.createdAt`, `sales_channel_analytics`.`updated_at` as `sales_channel_analytics.updatedAt` FROM `sales_channel_analytics` WHERE `sales_channel_analytics`.`id` IN (?)
Parameters:
[
b"\x01Æ2:«ðt═®®»½ø\x13ÄÉ"
]
|
||||||||||||||||||||||||||||||
|
0.13 ms (0.39%) |
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`, COALESCE(`language.locale.translation.name`,`language.locale.translation.name`) as `language.locale.name`, `language.locale.translation.territory`, COALESCE(`language.locale.translation.territory`,`language.locale.translation.territory`) as `language.locale.territory`, `language.locale.translation.customFields`, COALESCE(`language.locale.translation.customFields`,`language.locale.translation.customFields`) as `language.locale.customFields`, `language.locale.translation.createdAt`, `language.locale.translation.updatedAt`, `language.locale.translation.localeId`, `language.locale.translation.languageId` 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`, `language.locale.translation`.created_at as `language.locale.translation.createdAt`, `language.locale.translation`.updated_at as `language.locale.translation.updatedAt`, `language.locale.translation`.locale_id as `language.locale.translation.localeId`, `language.locale.translation`.language_id as `language.locale.translation.languageId` 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.12 ms (0.36%) |
1 |
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
"de-DE"
]
|
||||||||||||||||||||||||||||||
|
0.11 ms (0.34%) |
1 |
SELECT `easycredit_payment_state`.`token` as `easycredit_payment_state.token`, `easycredit_payment_state`.`payload` as `easycredit_payment_state.payload`, `easycredit_payment_state`.`created_at` as `easycredit_payment_state.createdAt`, `easycredit_payment_state`.`updated_at` as `easycredit_payment_state.updatedAt` FROM `easycredit_payment_state` WHERE `easycredit_payment_state`.`token` IN (?)
Parameters:
[
"niMWhJu8PizSGgzbW9GgIbU3tI6qI5qN"
]
|
||||||||||||||||||||||||||||||
|
0.11 ms (0.34%) |
1 |
# finsearch-config::load::read SELECT `finsearch_config`.`id` as `finsearch_config.id`, `finsearch_config`.`configuration_key` as `finsearch_config.configurationKey`, `finsearch_config`.`configuration_value` as `finsearch_config.configurationValue`, `finsearch_config`.`sales_channel_id` as `finsearch_config.salesChannelId`, `finsearch_config`.`language_id` as `finsearch_config.languageId`, `finsearch_config`.`created_at` as `finsearch_config.createdAt`, `finsearch_config`.`updated_at` as `finsearch_config.updatedAt` FROM `finsearch_config` WHERE `finsearch_config`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"\x01‹\x04—pÄr¿¦\t¢šR²E·" b"\x01ï\x04ùp╠rÂáôârÅB§Ä" b"\x01‹\x04—pÏs„VD´\x06\x11›O" b"\x01ï\x04ùpËq~ú2¬rÌþ\x05Ø" b"\x01‹\x04—pÕp˜…þæ;"öI€" b"\x01‹\x04—p×p\x0FŽ8¥ø0_í¸" b"\x01ï\x04ùp┘rÔüt\x02┐-/á╝" b"\x01ï\x04ùu!s$ü¤<×■^~4" b"\x01‹\x04—u(qÔ½¬TQ\x061¹2" b"\x01‹A\x05¾ÜqU®,/\x18êf>“" b"\x01‹A\x05¾ÝsE‘£µ\v®#4W" b"\x01‹KDÃ-r<•ž\x00L\nÑR\x13" ] |
||||||||||||||||||||||||||||||
|
0.11 ms (0.33%) |
1 |
SELECT module.module, module.response FROM wbm_data_layer_modules module
Parameters:
[] |
||||||||||||||||||||||||||||||
|
0.11 ms (0.32%) |
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.11 ms (0.32%) |
1 |
SELECT `product_stream`.`id` as `product_stream.id`, `product_stream`.`api_filter` as `product_stream.apiFilter`, `product_stream`.`invalid` as `product_stream.invalid`, `product_stream`.`created_at` as `product_stream.createdAt`, `product_stream`.`updated_at` as `product_stream.updatedAt`, `product_stream.translation.name`, COALESCE(`product_stream.translation.name`,`product_stream.translation.name`) as `product_stream.name`, `product_stream.translation.description`, COALESCE(`product_stream.translation.description`,`product_stream.translation.description`) as `product_stream.description`, `product_stream.translation.customFields`, COALESCE(`product_stream.translation.customFields`,`product_stream.translation.customFields`) as `product_stream.customFields`, `product_stream.translation.createdAt`, `product_stream.translation.updatedAt`, `product_stream.translation.productStreamId`, `product_stream.translation.languageId` FROM `product_stream` LEFT JOIN (SELECT `product_stream.translation`.product_stream_id, `product_stream.translation`.name as `product_stream.translation.name`, `product_stream.translation`.description as `product_stream.translation.description`, `product_stream.translation`.custom_fields as `product_stream.translation.customFields`, `product_stream.translation`.created_at as `product_stream.translation.createdAt`, `product_stream.translation`.updated_at as `product_stream.translation.updatedAt`, `product_stream.translation`.product_stream_id as `product_stream.translation.productStreamId`, `product_stream.translation`.language_id as `product_stream.translation.languageId` FROM `product_stream_translation` `product_stream.translation` WHERE `product_stream.translation`.language_id = ?) `product_stream.product_stream_translation` ON `product_stream.product_stream_translation`.`product_stream_id` = `product_stream`.`id` WHERE `product_stream`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x01‹#\x08x§|pƒJÄÕÅ3\x1FÔ" ] |
||||||||||||||||||||||||||||||
|
0.10 ms (0.31%) |
1 |
SELECT `name`, `path`, `author` FROM `app` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||||||||||||
|
0.08 ms (0.25%) |
1 |
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[ b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" "niMWhJu8PizSGgzbW9GgIbU3tI6qI5qN" ] |
||||||||||||||||||||||||||||||
|
0.08 ms (0.25%) |
1 |
SELECT `sales_channel_country`.`sales_channel_id`, `sales_channel_country`.`country_id` FROM `sales_channel_country` WHERE (`sales_channel_country`.`sales_channel_id` = ? AND `sales_channel_country`.`country_id` = ?)
Parameters:
[ b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" b"\x01‰NÒâq囩±â4Rú¤" ] |
||||||||||||||||||||||||||||||
|
0.08 ms (0.24%) |
1 |
#cart-persister::load SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters:
[
"niMWhJu8PizSGgzbW9GgIbU3tI6qI5qN"
]
|
||||||||||||||||||||||||||||||
|
0.08 ms (0.24%) |
1 |
SELECT property.name, property.value, property.id, property.child_count, property.on_event, property.event_name, property.parent_id FROM wbm_data_layer_properties property WHERE (property.parent_id IS NULL) AND (property.module = ?)
Parameters:
[
"frontend.detail.page"
]
|
||||||||||||||||||||||||||||||
|
0.08 ms (0.24%) |
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:
[]
|
Database Connections
| Name | Service |
|---|---|
| 0 | default |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.