Query Metrics
76
Database Queries
53
Different statements
32.38 ms
Query time
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
3.63 ms (11.22%) |
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‹\x1DûÀjp|´\fû¶÷» ×" ] |
||||||||||||||||||||||||||||||
|
3.23 ms (9.97%) |
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/44ece762ae7e41e3a0b1301488907eaa" "/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/456048afb7253926e1fbb7486e699180" "/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Üâ—" ] |
||||||||||||||||||||||||||||||
|
2.87 ms (8.85%) |
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)IŸ¨ûsÑð\x10¤\x16lª\x08Í" b"\x00i▒\x7FÖ¬\x16o┼\tjJ7>üð" b"\x00ª1ÙÞüc¿ÛƯxƒr╔h" 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Þ÷¾íÛ\x01J¹f\r¥º\x08ìÿ" b"\x02C\x13\x1Cy‡’CÐ&Œ\x16‰‰0ó" b""" \x02ЊԖî\n 90\x0F=¨£\x04\x19Ò """ b"\x03\tÃzùÎ}´ïþ¢ˆh>å4" b"\x036Å':èñí~Èl*~ý«\x13" b"\x03>x:Â-£y3┴üÙw\x1EG\x19" b"\x03t\x16œæû\v[AMMG\x7Fè´Û" b"\x03‗,àÂ\x12#~ì¡░╦3{ÿ." b""" \x04ò\x08Vt\x10\x14Ö\n Ô7àÔ!ÐÆ """ b"\x05Qè‘\x00zê2FšâMÈ—Gt" b"\x05ɑðT‰zªØ8'\t‹Ù”" b"\x06\x03t¤*Ôanï\x1DMúfó6^" b"\x06\x10\x19Hór@|ÍÈ\x08\x1D\x05ù…[" b"\x064°:™ý‹î\x1DXÈ~ê#í\x04" b"\x06[û6\ëˆ#¨©UNÚG\x11ë" b"\x07%6É\x03?xoÐ\x01Ĩ┤:¯á" b""" \x07Hp½u"Ì\n HÞi‰R„qÞ """ b"\x07ha\x18Ÿ¸#h4èæorºxr" b"\x07rRÅ╣Âuà¬ð▀║Òuz÷" b"\x07 í«×‹¬ÅìÍÈXú\x7F&•" b"\x07Ó𘤳^] ýŸž©¥}0" b"\x08ÂÈ£•\x11@1¡. +뀴k" b"\t\÷═Ä3\x7F¾°XìôaF¨▄" b"\tt\x11\x08Ô\x13\x11ü#\x1CÄÈ-m" b"\tÜ(Ȧdo¶úñ@5Ø\x13Þê" b"\tÄ\rg\x14._g÷À佚ò³£" b"\tËü¡=fòëp─Yûµ;F·" b"\tסˆVµ‘e\x1E65©\x16c©'" b"\t V@Kñ«ºØ\x03e6▄Ìí5" b""" \n !\x1FK¦y\x1F^y│\x1Dö(\x12\x0Eü """ b""" \n bŠùæV9W\x1E"‡Õ\n \t‹™ """ b""" \n ¾;KU"®î”Š!\x15h¦ø\x10 """ b""" \n ÃÂ<\x16Æû\x19u‹OzpgK@ """ b"\v3gâ\x16\x1C‗F±{\jãäÉ" b"\vO«´œ¤äbÁI£!Õƒ\x10µ" b"\v[\x0Ff›œEpÃÒ¡¨Í)\x15Ï" b"\v┌N├îÇ@╝\x0EØ8yà´6" b"\vè#\fã›BÄÓ$H¡2\x11\v\x10" b"\f\x07G-ýêVqº„¤¹+\x10\f¯" b"\f1z\x19\x07MZËä…›Ãp\x7Fàš" b"\r\x10åø\x1C\x1F+¨rhOò²DÇ»" b"\rMÔÚ§ÍæE\x16q\x08y7³ƒ‹" b"\ršw1¡\x19<ØÃ\vD:ÕhÊ5" b"\râp\f×ä¬ð:ë¡:1±êœ" b"\x0E[n_\x16¡fÖ2Ù\x07Ò›eæ" b"\x0Eþ¨Ü1g|'ˆËWe£iHù" b"\x0F\tÚoµ\x08dò|®™Oò\e™¿" b"\x0FUÊM7ÖBªAHÕÆNüá" b"\x0F^Ò‡)Ê\x04×¢\x13´^B r¥" b"\x0Fh¬\x10ÝŽ¿\x12Å}OÍÔýUÒ" b"\x0Fq$N?É‘&\x0FPjË*\x08I¤" b"\x0FŒë\x19òç¶j•¢ ]ùå'Ø" b"\x0FÎ{Ñ(J¹k÷¶XgÛ¡O2" b"\x104L\vI0ð<š¬Î\x19Æ!¼ê" b"\x109íšE þeÅ\x07VÓàŽ…\x1C" b"\x10[u$Rp\x11¤mT\x11¬Ž^+Ö" b"\x10—H¼ÌCͳüìø\x1D\x04Þš!" b"\x10ö~Û#\x17®‹Æ·QÖxÁèù" b"\x117´d\tØ·k\x03ŽgV6̳}" b"\x11D±r¢µª%=ë„\x07ªˆ¶Q" b""" \x12#‹¿\x08\x1D´æÎk\n \x11ß\tR¨ """ b"\x12$Wn§>¼\vÍS0ýÔ”.Ú" b"\x12•]õ)«\x10¬yÔ»Éð}$ " b"\x12ƒs"þÅ\x14£Ý▄gç\x1EêI¦" b"\x12º\t‚ˆs‡\x0F^ZßÏ(¹’¾" b"\x12À\x15qÇq# Ãaö#\x11\x0E8ê" b"\x12█År¢╬\x16é\x18éÃÃ\r'╦ç" b"\x12 Ñ\x15ëD©q#É[│WNMK" b"\x13@ý╣^k)5Q║çþÅ\x12E`" b""" \x13Cî'\n Ö#Šþ´Ù\x14½S\x12Œ """ b"\x13]Ó%\x184^iŒ ‘-\x02>—•" b"\x14\x11¿öûíe1×4:²*æÅ." b"\x14\x12û\x17ØB\x19P?…jœ«ÊC#" b"\x14}[A6ÀH\x05\x13Ä9)$RÄü" b"\x14®Ý$Wƒ bÐhÑ═Åh├d" b"\x15\vœÄ\x02HçþêÇp¤w`\x13\v" b"\x15?§‚·\x13¶2CrHA<̈/" b"\x15PŽ¹LöÇ{Ðòòô$"j§" b"\x15q|°RñØ÷\x04Je#┘\x15\x00à" b"\x15‚Dðqø«U\x19ü0AGÝû\x14" b"\x15—£H±\e\x13\x03äxU‰ú»Â\x7F" b"\x15÷©Pr/Ô0äìÿæ_*\x164" b""" \x16\eä§─5MzE■Øw\n À\x11\v """ b"\x16$▄pr}h:\x13Úùe\x14T£ü" b"\x16m+f\ÜÏã·=^=ùï„î" b"\x16žËjÈ8³E"\x10\tt¡çûI" b"\x16░\x0EìéM¥\@÷gdóÌ\x03ô" b"\x16°ë¥&\x04\x1Cð_zùõ©m\x10Ô" b"\x16²9/ËaîCÃN4žêõU." b"\x17\tH¿õwI\x1ES©°Š½Í8\x12" b"\x17A^‡6™a\x16yÏ8{£[\x04a" b"\x17B\x01%&¼WÃ\x02½Í²r7¡i" b"\x17Ï\x17\r¥\x1DÝ.ÙÇŒþõa!\x1D" b"\x17Õ\x1E½¬\x01Z¾Œ‚ÏUiÒ.y" b"\x18\x15uË;H§ç\x7F»|wüc)\x02" b"\x18Èæ2ºI,¸Ò䎩\r÷ë\t" b"\x19eöÅ·7††wî\x00ïyœÐÁ" b"\x19šC¬Óž›¸ÞÈ”HÐ5æ" b"\x19╬\x7F#¤n░Ç\x03(<═ÇÅ■z" b"\x1AVÌ iT¿ìJä–k \x162â" b"\x1A®“`á\x0F\ef™wîüܲk" b"\x1A▒ä`─<u\x0F\x174¢ó ┌"Ø" b"\x1Aÿ[üá8\x1D¿üÐ\x02sÅÝd\x1E" b"\e\f —µ+\x19L§|ѳ·¹\x19Ú" b"\e\x1Eþ-=êçfg0Ï\\rôÿî" b"\e=SŒ)PÎ\x1D;“)‰eþ†±" b"\e¦KÈ\x1F½vŠAÄ‹`Í‹B}" b"\x1C?\x1D\x13º·ZÉ[eí\x15£2¿©" b"\x1CKìw•&éï&Á˜\x18;\x16²ô" b"\x1C}¤µ\x15‰l_Ü\x05}[\x04Š\x1C\x14" b"\x1D>\x1F¶\x17»\x0E[J|©gGwgî" b"\x1D»”Bùq*³›Â‰IÊ „(" b"\x1DÂk»£®Œ+1 ðw;kLm" b"\x1E"~…êÙ{¼2á=ÞFmŸe" b"\x1EC?Xý¯ K*x\f\x1FM_ ë" b"\x1EOérÎd½–¤&^UÛ±ÀÝ" b"\x1Ed¹s\x0Fa¨%©ümøó^õë" b"\x1Ek\x13\\x06ø$<^_Â_YOx]" b"\x1E„eœÑ†HDÃÔ\fà\x05g6" b""" \x1F\n \x10ñú[`ñ›|¢\x04Þà\x01q """ b"\x1F\x1C\x0F•e©U›P\x1F\x19ù\x1A©ˆj" b"\x1F_à&HZ7JFØu╬T┬Òµ" b"\x1FíÅpCsüÕIÚÛ║£³·©" b"\x1F¥øNÚ\x01\x05Ê\x00š\n¶vój»" b"\x1Fç£Z\fnB^©â\x10W>‡½" b"\x1FÆ\x1CEs\x01U[xvʱÀ\x15yH" b" J\x00üØ"\x01MBC\rÄíq\x104" b" cT{\x03bª÷\t~7QUäÃÚ" b"!<ƳAã%À·„»ag²[\x05" b"!é1ŽËìÕ0Gò5ß+Ô…ã" b""Øý²Ä\x03Gг▄├┴_├\x7Fa" b""¡¨\x11@\x00×\x1E‘ù•»\x04ÓË3" b""" "╩³=▀Í╔ü,\n zÿ\x1F\N─ """ b"#„ó\x7FÇ)ÅÍlî\x02¶ÕëÒc" b"#¦É\x13sq4î<╝6\tÔ■Þ\x1E" b"$ó▀╬ô5\x1At^Ä\x03ź\x1FÈt" b"$§g\x1E±‡’\x1F6{án‹À«X" b"%K!E\x1A¶ÀŽt’Øz‚üï/" b"%oÙanšéèrÕ\f\tÑ„x‹" b"%äÊ└OíH═É"O│Eé·¥" b"%úab¹†\x08ù‰ýøªìý\x05~" b"&,KÉ¿e╣ô£┬º®èh3" b"&|ö–µOæFz¨<n[\x18›S" b"&–ìæ8•Ž1D1¹\x17:7aC" b"&°CcÝÿŠMb‰Ô9}nµ\x16" b"&Î9U┘\x1DV█\x0EÅRçýl‗Ä" b"&äíê¼?Ó¡0\x0E-\x122JÑö" b"&¾?┘Ì{ÀZ²Q;ÅáÒZ)" b"'#jnSË\x00ߊBæÂG+Ȩ" b"(8\x1Eÿê“\x1FÞÀù\x11\x11`.Ý\x14" b"(<5m-ŒüÅ„5\x18Çå!‚U" b"(ƒaµ¥½Õ€'&\x14Š×!’\x08" b"(Ïßìœã\x10Æ—n‘“\x7FE¼ï" b"(¯zJ\x0EÛºå█´ü▄|CE£" b")S›Àa¶$sfMôCSÃÔˆ" b"*€K\x15-N.ª/_4¡Ä[$R" b"* dªa’*'+Ì;A\Ç\x08\x08" b"+\x07„¥\x08\x1C¹½¡Â•¬o\x18·\x06" b"+\x1D¶1Ý\x02ˆjù w?½&ÇÑ" b"+—Ñt›Ñ¹\x03ª˜ƒó²DIÂ" b"+¼õ¼qWäFo\x0F6L‹q\x1Cì" b",\x01Ä\x1Cý\r%€™\x17½q#Ë\x10=" b",╩G·$´wM═²q#\x15\tØÚ" b",ÎêÆzÔNyqý\x10}µ2 ¶" b",ôÌh@\x1F!ÚÎô8Ha5\x17\x7F" b",ýŠ-\x08 Û‘Ý\x034eÛ=¡á" b"-+j´ö!>å‘\x7Fà¾Ë¥‹M" b"-[¨\x01“§$¿¬_\x06x5\\x14³" b".nŠ&¹ÌOndÊøM\x1FòS†" b".¹wòì_í\x0FýE…æ§K…ô" b".ãCÄÈç¦à,¹¨¦¦Ð;I" b"/O:\x01ýÁºë~XŒp/\\x0Eö" b"/é\x10┘J]ßã└l\x1DýY\x12¿Ø" b"/â¬ÑÒ_˜Õ†”¬\vö{5õ" b"/÷Ù¨¨]Ô3HŽ¸pþ\x02\x1A" b"0BQ]A\x0F¼-÷>q]Wj[^" b"0_°aìÅîú‚¨\x1Dó\x08S‰?" b"0r¥\x12╗*ªìO╔yêCßÞ" b""" 0¸\x01\n \x03ª!˜…nݽÅÒÝ """ b""" 0×dßz‡s‚Ë\x1DÃ\x1Fn\x18\n 5 """ b"1T\x06;Ša78ûÉÕ9â\x1E\x0E*" b"1uw\tþ\tý~‰€ða[ìƒ\x07" b"1¬Èø-\x00”…¨øàcèç¶`" b"2\x03ÑÍq~³³µ\x10‹.œó\x018" b"2*Ž8\x108\x0EÔ§M4Ò\x19‘¸\x1E" b"2J0\x07Ø\r×ä\x11Æb¼c{O\x13" b"2uû›>ºï Õ¯\x01\x151’<d" b"2ÇQ},à[‹úv_\x01w„\x1F÷" b"2ÇâœÀÖ¨±¾µÒˆfÏN-" b"3\x14¸Ø%ò©g»¡V¯*yú\n" b"3z\x058Pø\vv\x05€#³ë‚'\x16" b"3‹ªÝ¬w\x00ÜtC.¼F™6\x19" b""" 4\x03F^Ú\n …øôj‰, ×þû """ b"4\tö·oL;ù[ñ\x03\x12U‹·ê" b"4+ŽÎFç^Z¾R¹VÂ3§œ" b"4d0\x13┌>{U\x10þüIGÎ\x1A¢" b"4òÛ]f×\x07_õ! █ØS°Ö" b"4µ\x06½øàõ„Î\x07rÁ\x14Sº€" b"4½uÓc‡4Hµçzž\x1FPg" b"4ür\x1DUr†‰ˆÃ©ßnžjH" b"5»µ¨AZJ¥#L!ãi\x1A\eË" 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ˆ¥\x13>\x18¦Tƒ¦ž˜lý$4" b"6Â\x0F¸\x14µslÄÆ3—M\x1DÍn" b"6ú;Óµó'±wàÂ(oDºf" b"7\x10g═\x19[H9L }È■Ë É" b"7qÛÆS$H\x15\x12J¾í_ÏóÅ" b"7xJ\x14ó\x15Ãu;\x08\x075B2Ù" b"7Ö\x02t\x19B\x1DÀ\r:õàì\x111a" b"7¯Û\x11Ö¯\x02\r\x18Y\x0F\x1D…\tÿ’" b"7ø¶‹8\x17½u\x0Fƒ®¨©s“s" b"8\x1DîŽÛ Ñ™3\x12\x18‹Â–)ê" b"8&µ\x0FF⪠©¹MÅò\x19ï" b"87f¯\x0F0¯—±n\x148å®I"" b"8Jq\x1FÅ }6M;L\x1Dý„W\" b"8üiµQñ╔ûú┤ùâBî╝:" b"9\x02åWR2C2ØÓV=\x0E'+Ú" b""" 9\n q…U\x1Ek|8âÍ?ûê(\x07 """ b"9\rþƒ‰(ßÚ¯õÿ¨v&\t¸" b"9\QpÕ -›vé\r8Xó\e§" b"9™¸\e\r×ó\x16TÎ\x18ìʈÎ" b"9ÒÉ=c█\x03üfü«t▓]8Ì" b":/cU˜€eÁˆ³¬fŽ\x016¢" b":1H²p4¸ãã: •ãŸùî" b":`]»X¹O,‘NÈVwö”à" b":nb%B═èÔÖ³\x197üíxÒ" b":o`nÐ/W|kò‹-[Êþ." b":ƒÓmŲÝ\x18Ý(|║ \x04%" b";¶~†ÑQ77\x7F\x12¬\x1Eyv0å" b";õØv\x00¹¼└½┼Óg\x15ø)ö" b"<»ã%E4E\x118Ó\x01Qaûf8" b"<ÌömUØh═à|@haÑ┤¥" b"=\t›qÒ;/ðãüG…~,\x08A" b"=-cósÈÿ\x12\x10ÛoÑ\x1A¿Hv" b"=~\x1E@7\x15Bô\x13ah aW\x02÷" b"=ìcy\x07ÎÝÉr\x19\x06iÛ?³" b"=“˜À1%hó8Bß!hˆ¥\x01" b"=¥\x1C^“T-Jm(–ErC«§" b"=¯}'ô^§`µê~¯(ÿs" b">2õ\x04GýÉC¨╩cyö┴-Ð" b">••JM°Tt¹\x1FÑ\f·‘\x0F2" b"?\x10õ\x13\e»\x1Cí[ýЦ·g?Î" b"?Uwo«\x15ïÞ9¡ð®¥‚°6" b"?XÑX\x17a7\x7F`¼\x03ÿÒ:\x08Ì" b"?Ÿƒ=<\x1F\x1E"7Ââ^iÓ˜Ø" b""" ?è¡3OÝ\x07bUhX\x1F\n Í›Œ """ b"?øs®\x11\x12û³\x11q\x07 Ûofk" b"@X\fÔ³\x18!Ói-─\fÉoFØ" b"@š~‡=»ÿ¹úFêWÛ8>Á" b"@›ëN÷¡\tBÑøG[<•¾¶" b"@ظ3”\x18\tJ2"33/团" b"AAU┌R╠┌_ö·.\x7FØèdÚ" b"B\e{˜ˆsX\x15¸´¼–]z£d" b"B,\vWÄügx\qݵÅ)ŸÓ" b"B?óEËI½6hmz\x1Dþ‰g¥" b"B¼:.7V»š{¦ƒ5jÅ\e\x07" b"B└eä░*í¢M▄yƒFrgØ" b"Bð[ IÄü׺à.çqM“ò" b"C\x06i^øÈX¬é»¢_¡▄ÅI" b"C.ûg┘Ø`0pJ@ôí┬05" b"C]RÂ\x02ë\x11\x04ÓcÕ\x18\x1Fž5" b"Cyåô\x1Aã@t\x1E‡ãÙ|ØW" b"D"SÃ\x05…ÍÂDýgRq\x05\x1Aò" b"Dª¥ÊI`£ð¥\x1CjZ>\x16³½" b"DÍÅû¾ S¤ ¤├▒¿¸N]" b"DîÈôŒÇí›AH…ßšS\x1Dn" b"E\x07ï\f╣¤é─Ò¢û$Å\x13╗D" b"E;\x10.ž$®´ôv™Ö\x1C„:ú" b""" ED°\n ïüC\x12Ms觥0À* """ b"Eyó¤ãj\x18@Ýù†#`‰’b" b""" E¸\f\n Ý\x18¢ôb¼œg\x03²7Q """ b"FhªtGë\x07ÓÁ½Ú(áãG\x1E" b"Fì7±Îº\vÚV╔4áA]ÛX" b"GN—Z\x10M¹È•Ä~+øöéð" b"GO]î0?¥:\x06`ëý•ž3‰" b"GªI<\x18\x07-î*I\x19\x1FóŒwl" b"G«#v\x1Dúl9‹OÂî›]¶\x00" b"GÅñA”;¸&!ὡ÷w2Ì" b"GÚ£\x07nÁ·eã\x10Q\x19ï\x19uj" b"HCNQºwGÁæ?¶U\x1AX'" b"Huõˆ›ˆÚ™Ž|î]‘qõ}" b"H¤è•Æî#=\x1CC\x1C–§ü\v–" b"HÚ\e┴ë;\x05\x06Þ\x0EüW\x7F┼I×" b"I\x0F*\x08\x13«±Ø9°¬$\x08w▓©" b""" Iˆî\x16\v\x16\x1F;8¡Æž\n \n k‘ """ b"J\x06‚ D:¯àïœ×ÒúnÀ¸" b"J\x14æ«Þ\f»L¥T»ü%‗\fƒ" b"Jm*žúx¬ö«\x7FŽÇ\x19²\x03Z" b"Jn³║‗Þð│╬wrØ?\x07²c" b"J¼¼-Þ9Õx]w\t\x19¤jˆ" b"JðY¾ÆdJTD²ØNUý¥\x05" b"K)TøÒøb\x025'«âÍ[c\x14" b"Kz¤¼LœcGÆœgFra'Ô" b"KŒi1f{ëNí\x00ZòÍplB" b"KŸ×\x112rbþ>ìgžûÁ\x13€" b"K©\x7FÚÔ#ØÁ ÐôVT®¸}" b"K×·ˆSïz´¥2j;9\x19Ý÷" b"K┌Òãjì╬4øO\x10║Bï%┬" b"Kâ#]1Kƒ2§ì\x0F™w\x1Ea«" b"KÿWÿAE\x0EPŒL9Ô\x00H››" b"L] w®=8\vã¬\r\x1D˜Ð<" b"L„Ö\t˜"?5¥^ ¾H3–Ý" b"MŸò\x0F®Ð¥ç-\x13®Ù·INs" b"MÜ;B®gk.X\x07 \rM80ˆ" b"NH.¡µo¥HØÑ'g\x7FfEc" b"NV.îŠâÔŠ¾\x0FnwIp\x07 " b"NÖ\x08┌\x08qRr¯├²Ã╠ü4"" b"N›\x11Á":ì\x10‚\x02\x15õÕãã" b""" Of\f3═ùÀö\n ├\x12Åõ\x03║| """ b"Oyuüªd~ 9Ùcé#òæx" b"O³Ì¡©öý\x03£Ea\x0EœiVâ" b"O┤#m▓Ç\f¹ FÈ7¤MxÅ" b"Oñ]~)O‰\x10ËÞŽEÈ¡É\x19" b"P\x04b╔ù\x14}¤ü¡\x1CCôvgë" b"P«ä×£Õù5÷(6ȱ |¯" b"PÆÇzŠ‚µR÷m÷Ãò\x04…>" b"QE’{èOl=¸L\x1C8\x7FW\rÒ" b"QìáÉ·ð‹eÆáÙÏ\x08P.ß" b"Qõ%ñÙ€‚‰ãeµ²§ªýÉ" b"R\rØú\x1EƒæUñ7¾òÞ\x00\x01$" b"R"üÿQð©¾í]\x7FÿT\x01Ä┤" b"R┴V\x12ò\v[ÕìJõî╠E²½" b"S"ô IIÏ═\x1Cq│\rÞSÄÉ" b"S┌ÖÊ\x1C2tm\x13\x10n\x15É│ä╔" b"SáɦôÄ;KW\x1ḎÆl¢Ü" b"T\x1E\x13üý╗Ðñ╠~(û▒»v\x12" b"T\x7F½c!D³e!“5€s£$Ž" b"T…ÄˤMÒ\x17ŒÕ39ÒfŒ©" b"TÓÄ\x1F└═ ô9▒ÍÉ*▀Ú1" b"Tÿ\x12M#Ø”K0ÜÚ<S\x18^\t" b"U\x01GTøµM}ĺ$ù®\x05àH" b"U\x15±Ÿ´\f¹.qí\x12ª)7íÁ" b"U7qUIê2¨#ü]BSYUZ" b"Us\eäf÷2°¦Ì\x15À\x18ºwè" b"UÑ펊³2,¹à\x00Í)Õ[ø" b"UÒ±\x11ı¹¤èʹ»\t\x14oâÉ" b"V\x0EúÒk©Zs]¡CZ\x15¨¡À" b"V†(g\x00¸\x12Y\x1AÔ93\vTúë" b"VŽ\x18þ7>Nn\x06íø¼\t:\t&" b"VÒ;%½¦”?N®XlÒwó\x07" b"Vÿ†\x01Ê\x1A\x1F‚o=\x1C\x05\x00vT—" b"W\eÄÒ\x11Qg9]©b”õ‘R’" b"W*ì░ÍüP,Ä}Zß└\vb~" b"WS░▄z*\x06\x01ı\x17ÿî°CðÉ" b"WÅŸèòRbƒå\x11IÈ‚Ú„" b"XN]╚\x01kfxÉ/\x14Ö\´Nõ" b"X{\x17ôÞßQg7Î}\x10ñîïç" b"X»â┴èÝ2ü\x1AâYí\x07h¶," b"XÁœ9\x05.?\x1Eâ~3_C€\x08ä" b"Xåà\x00Vû\x1E£\x00h·ntÄ>\x17" b"Y!`¾ƒR¤”ŽË\fUwt‡ö" b"Y\ñû£\x16\x17Ë&\x1C…;R>aW" b"ZºÈƒ²F£žÝKOQe¿XÕ" b""" [«├î/\x04>\n ÁèJsØë▒\e """ b"[°ÒI°Ê²/¨÷SC¬â¿\x0E" b"[¸.\tû \x136Æ£ëûº\x18\x1FT" b"[è\x1Að\x1EÜ‚°r\x15ûžhù\x08¢" b"\à–\x15Ž¯|öV5rº‘mù}" b"\þÃèï¾1!㜓¡“¡ÝË" b"]$°<\x1FäïˆÛ]\x17šÕϸä" b"]c|i0C\rnÀ<į́œj—" b"]š\x07ŒeaU7¶a\x07ñÀ%x“" b"]¯\x7F„Ì §ÁË©£Æ\x05V¶\x1D" b"]Þîʃ£\x16ıÊØgÀb\x1A┐§" b"^3ùü`\eáÊS*x¦el¾×" b"^@\x03gbüø\x03Õ\x03‹\x07 ª©Z" b"^“¬GeÙW!{2\x00Âæo\x1Cß" b"^ȺV×Ìí\x13q\x12Ã\x00\x05\x0FÅz" b"_\x0Fïz▓`ü\x051[,â¶@±Ñ" b"_=Š±¥‰¬¨Ï\x13j]*ÐHÔ" b"_hŹW\x00o+î\r=wô€È¤" b"_pŠ\\x07ÓD+Ȫ\x0Fý˜"Î¥" b"_w\x13㟩\x18cÎhäw\x10" b"_œÉ¢ßûA¤ÓøÓYÐæÖh" b"_¢îGÌ“\x1C\eTró—ŒcVÄ" b"_Ýd\x11\x13ÕÙ¥4:”Ïóøì&" b"`v\x08ÖfKfÁÿs†Û™}\x1Eé" b"`õ“„+¢ƒ†àþ\x07\t\x15A{9" b""" abfÖÆb[Æ\n P“|\x16餒 """ b"a¢\x04+\x17Fõå™0€e\x18%;C" b"aöÆwÔÕgspX¦¸\x19\vû”" b""" b<×q_Ûcß0º\n Ï´Ø\x1CQ """ b"b|•,ˆ\x0Ebêº%!¯ýƒ[Ä" b"c#šBYTÀ\v0¯œ\x11ø\x1Cÿ\x04" b"dEŸ\x16Mb„ˆËÉ}‘1†9n" b"dVÕ~ñÀI>\fœ[\x0F*OÈÅ" b"d¤»iYªÃ)nóÆ\v\x18\x11I\x10" b"d┐}]lÅy¨\x14ËU░º ■È" b"dÝ\x7FÖŒbÔŠò»[~C>ù{" b"dõ¶ð(ì*#uZ\x00\x06■Êà\t" b"e\x0E\x04ýà£VÙ¦r©è¬\x0Eñ " b"eøËpõqóÿKc§ãPò€Þ" b"f\x03\x03¢\x1Cª5eÒ²3·Ï=ÿË" b"f\fQz§¤8e.\x07— {m3Ï" b"f'#\x18:5e\x12W\x11èÅ.\vÂM" b""" f+/Æ╝Öy76¼x\n mÉ\x1EC """ b"ftƒÇè[Œe·\x03¨.7œ]\t" b"fÛ║áãØÐQ«1\x0EÉb;xè" b"g\x04Ô±HŠ¿¯Ü³\r”Z\x14IÙ" b"g#ìïßéÖâ>ª¬·sÏ!5" b"h\füÀ9¸¿æA!‡†è¼$‡" b"hœ$Ø(ÃxÜ™0ývMW\x03\x0F" b"håùmÉ\x00è\r1[Àn@‚\x0F" b"hæ\x15k9x¥ \r\vú€\x18µ8u" b"i9\x03é¼PÞ*iÏ!\x0Fp‹+Å" b"jSVmœ\fFŠ›…Æ¥m.¯\x19" b"kƒÇîr¤¶H‘z¯ñ?\x03Éu" b"kßÅÔºËöázq>Ñ·“b"" b"küOš>Š}¾‘†„Ök'Z¥" b"l\x15û7\x18═8üAGåÏ¿\f\x0Ef" b"l}\x15áHFýgÉ\x1D\v¶Úª0Å" b"l‹ï¥øaX‹”;c\x02\x02ÂJ£" b"lÇ\x17\x10Ï$¿Ø—Š©Ÿ=@\x0Fµ" b""" lÍ\n \x1AÛ §\x06ËúLêýóñË """ b"mZ,\x11&ô\x13µ\x18éìµì¾×\e" b"nFÖ×|çå_>×ß èt½3" b"nz+█üѧÇ\x11r"ú\x077Þ┌" b"næ\x1C-(`î╝Èèr\rÅ~Cc" b"o\x07'r\x15ð£\x14 É,¿\x1C³›\x10" b"oÞù~Oí\x14PÐü5ä/KÝ´" b"p\x07Ú¤´░Ø^ßD╬?ÀÅìú" b"p}@áQ%€÷¦Ž\x1Få<~Ž)" b"p\x7FÊóú?ÎÙ<\x0EN8†\x12F÷" b"p©Ùü9fü*i|K®l\x19|ç" b"q\x13Ðëâ¢/õ\x0F!XéÆÖõ1" b""" q(¤\n >Eâ1– uÅL·Ì„ """ b"qLE0Ŷ5;ÂT\x18Q´mÞ\f" b"q§Û•âOßvÞ\e\x1C·²\vTÖ" b"qÊŽ\fÔØ.È;Œ¾,Ä\x1F›~" b"qÒØCdÔ}⺿`ìåé\x07ø" b"r+Z–\x147k/TE5õÜ1½‘" b"r‰™ç¥à’ö¸\x06\r¨ŸÅ†\x08" b"r¢²ýÙwGaü ¢▄V¢\x14\x13" b""" rÔJ\e`Ñ7=—/§\n \x12\x01¯Z """ b"s\x04\x02Ù4üä_¤╗╣╦─żå" b"s\x13\x0E¼Œ?\e\x16)8\x03D\t…þÝ" b"s\x1E8y\f\x06\x10ðò‡ì<Û±\x18$" b"s+Í7áµÈOœÇˆ„Xh\x11\e" b""" s0šž¯Å÷\x1Eã󟹱\n a« """ b"srév\x19¸µ’Fú—ü¸½^´" b"sÅ\x7FcáÊ▀UâbMÁ┴¿zR" b"s¥\ÃÝI\x0EUõÀÕ\Ë&¢O" b"sÙLÃ-;n?0¨\x07O߃—º" b"síYèç}r&‘O*Ôñ]A" b"u&õ{Ý1\x06¿"üb^ý2Œh" b"uÒà\eË“ƒãÇ£`qZñœ0" b"uúoä‹|\t^ÄbÊ\rYø:ç" b"vÀßȨ[¦nD>]TF"ÌŒ" b"vÊç éXÜ─´²\x02ÉY¾§┬" b"vìJ̤YðŽ.!ªÓ\x0E]Æ\x1D" b"w4rËÃdS¬2ÿß„¢g¨q" b"wÅnù\e\fWN╚ã@âÔƒj=" b"x\x14ÙAó—ò³^\x1A\fŒ‰¯é2" b"xQºnx&ý,ýgb¯þ\x1D¦ë" b"x_Q…¼×å±T\vÁ¬ƒ~Ð3" b"xhDc\tÚxÞ6GZã¹,MÇ" b"xpn’…v\x02Qª\x1FùÃ\r\x0EKC" b"x„›9\x05m»·\væ\x1E"ö4j" b"xµr\x02\x0EÜ,Q>•dg×_ç÷" b"y\x1FÚ¯\x1F\e=jCóÚzöhP'" b"y§\e˜i•‰\rå\rè˹\x146Ì" b"y²Å\x0FÚš\x04Iî\x05o††þTq" b"z\x0E´'«<8ô\eT\x16¬\x7F¢H>" b"zBn¹!\x1A‹ª\x1A¹*\x0Eص,Û" b"zM˜s\v \x03¿¨,\f\x17\x1Ex{Š" b""" zR:íÿ£Â”^\n KAÐÎN½ """ b"zYb7¢BÓB\x18Œôï_Nõ\r" b""" zë^x°×áLš¯\n ˜Ð¿}Å """ b"{,¥p\x06УáDHÎ\x08–÷·?" b"{9t½6Ù‹Xa\x14\x19ëúUy\x16" b"{:.–\x15\x0E3:“cYHò(Ïî" b"{iÈ>Šõ}Na!\x04ПStP" b"{É_c¹Í▀\x1AÙä\x1D▓HÍ╦o" b"{Øü²^-Dº/¬í9ðúT×" b"{þ*ì!è╩└Û═ÑË\x06ÞöÈ" b"|Bìp\x0F:²ÖÔ/L\v\x1F0\x0E&" b"|„°KÐǬt\eRʼn Èö8" b"|Ä\x1Ccåm\x03Üèœ_XfÕ¿Ñ" b"|Æ7\x10¼;šƒ–y¿\x16t\x0Eæ—" b"}\x02╣¢Kr~!É\x1E¤Í▒Ï`╔" b"}\x19*"rãžã9®™\x19¿`)ü" b"}:ìµU\x16¾Q¬*║╬:#¨×" b"}Äç\x12º8æ╩ò2O0\x15Üìg" b"}îŽ\x1D0b/B´ð\x12Ñ\r\x06Œs" b"\x7F!«i–œde>Buö.ûAÄ" b"€ ¨ž1R ¼¼ìáçãá|V" b"€\x18ö|ƒŒJwEOD ¿‹X" b"€Ò}N\x00íØ\x10©\x02+“½ºxì" b"ü4═\x0E├à\x15╠RP╠ã9`s\x0E" b"ü¦A[«®F%³\x1Cå`ò°÷ï" b"üßâ╦Ü2+¾]o┴øsr+c" b"ü¹üÛñ.)«\x16ÔÌ▀G%Ä╚" b"‚0íàäHˆ\x7FQ*Ô`\x03é˜ì" b"‚²l4:vNÅ&6DÚ)q·–" b"‚ÄoÔœq³ï»Iø8ÁõÕ9" b"‚ȸ'ì\x01}APœ?œ¯ïæ@" b"‚Ò’R\x1Aô‡lü Ú’J,;´" b"ƒ\x1C?Ü©œ£û\x17Ì\x06ô\x04¨áŸ" b"ƒË\f\x18\x03ÆB\v¾CøÅúÍ$" b""" „\x1A\x15\x01&yA®\x1CÔ#I\n ÉêÍ """ b"äO\x1AG|8O?©¹ìñÃÊ\M" b""" „Y\n \x02\x1C[Ì2}žÛ\x16*2éò """ b"äæ┬¶O╬6`┼¿$V¨É░W" b"…\vûÿr>§\x07™ó×Â.èG\x12" b"…Æ\x01Íø\x1F\x01Î\x01\x0F\rõƒôÓ\x19" b"…Û\x19½}\x0E \x17çߺ\x7F\x1FG;ä" b"…ô Gy{¡SO\x0E\x1CÀÍ\\x15\" b"…õa\x14©ú ST#)þ»]\x14" b"†7ZÛxÎÑK⤴Y>IŒ›" b"†Š<T})}ì[+µ\x0Fã\x06¨ç" b"†¦ªŒàívZ{¹>WºO±\x03" b"å¿àØ‗┐:▀║¦ÑsVEÞ\f" b"‡\x1ECõâ^dY\x1A<ÁŒËË\x1E¹" b"‡†Zu§ò{%Ûç 4´ýÈã" b"‡¤r, ª\x7F\x19•ñ–,\x14E\x18â" b"ˆEÊY\x7FE\x07¡ZüÀ\x1A*rfV" b""" ‰\n ’db¶Õ§½Ýê›å9¡ """ b"ëYo╣bâºÙ╗o\x04_Øú░\x14" b"ëÛ┤Ñ\x05\x01o¢0¼\x14ÉÌ\x1E®ô" b"Šôê\~#\x0FNŽð\x12\x10)ïVö" b"‹2Juæz•\x01*bcžp÷\x05U" b"‹AŸ>’Ÿï¥V/ÇF\x02óû" b"ïqð\x02_ı/ÑÇ\x02\x15@dA¾Ø" b"‹¢üâ\x19N²ñ8«Â‹}.Ç©" b"ŒY\x18X\x10E{¹X§ýÜ–…«ô" b"Œk%Øc\x04Õ#u9\x7Fý"õ>³" b"Œ°ø§RŠïWÖ•=JU\x19f•" b"î¦├\x16╔\x7FÅú║g´\x08\x1A\v¾À" b"ì\x10/╣¦.p‗B«ªVä1¬Æ" b"ìIâ#¸ß╠┐nXIú╣ík\e" b"Ž&ÐLòÔùÏ(Ca\x16—f\x19@" b"Žf¿tƒ¶»Ý\t]gkï?“½" b"Ä£ääkîÌ─îBmÏó║¾ü" b"ÅUÑÒ©gÈ\tk»├Í®├^5" b"Å░#?å\x06»\x00\x04├O╗~í3Õ" b"ÉKc¤I\x06ï"¼├\x0E9Ǹ╔" b"ÉÖ´Q@i·§╠eò\x14┘õ0¢" b"æ<¢IÒçÍü2ü\x11?Îï\x1E" b"æy\x07«¶Ã^§:Ô\x1F┌ì╩k" b"æ░Z■¶Ç\x14\x05ì[y═├\x02³9" b"Æ8l\x02øM░\x07õ·¦°╝ì┐x" b"’BA\x05»{‡>\x19Ö.ìã\x01?1" b"ÆwÌß5Ú®gD©\x1EØ0─\f║" b"“\x1CÉ\x7F=Jk…‰i\x0Fš@™6µ" b"“'q«LÜ\x06zýýB\x00çÖX?" b"“ï\tš§O+Ew¸g‹Š\x08\x04" b"ö\x0FòÀÀÇj┴\x13õI#Ì╦ÇØ" b"”\x12ô†P\x03ã®.ºÑb\x1AŸ®¦" b"öI[&╝Åa4LäÁƒZóO\e" b"”P»j~_ÅÕ\x11|,°R(H×" b"òF\x13¹\x1C<\x1F\x01èNLÄúJØ3" b"òV■½UÖù\x05uØPæ¸gF╣" b"•p9¡¹ÊG.FÛæ^zdï“" b"•yâÉ¿Ãq&´nAŸìÝWÏ" b"• Ì\\x7F÷ûQNçPˆ(ÜWZ" b"û\vÌ [(CÖ\x17┌ù'\x12×ü\x1C" b"–,\x1AKD%ŽŠÌAù¯#ÖÍ\x11" b"û>(\tEL`╚ì1ü·ò6R\x1C" b"–C> Z\x0FrSÁ]M¦å€õÏ" b"–wTÑ\x1D‹‹¤K+£…\v?Y=" b"ûÑı<#│@T|ì╝*┐ý¥9" b"û»ü\x7FÝÍ╠R5@█┤=ƒ\x1De" b"–؉‚¢£hÍ9YbÒ\x10û±\x12" b"ù$\x16WQï\x17rìG`\x04\x05\t╝¼" b""" —^'¢™F0šÞœk(\x19\n e\x0F """ b"—¿Ãh¾i3`”ѲóCèGï" b"˜~#\r6NRXàß\x14\x0EëÓïÉ" b"ÿƒmÔ\eoX┬D\x1EÀØEêßÇ" b"Öïüà³)+»\x16\x06▀ä_É£Ï" b"™¬Û¤Œ\x1CšâöU\x1F\rýy'\x02" b"™´5ÑH›\x17jûUKP-Ã\x15ò" b"™ú"Õ\x00\x0E‘Wfo9k\x0F\x1CLî" b"š_ó¿C^"`¿cP{“\x05.·" b"š‘üa£Îo?Ø°#k'Å“=" b"›\x15t… ÁNÁ¬i÷´çTŽ[" b"›Œô™ë-¦Ø»S÷Ǫ\\eX" b"›œÖ>å9Ã\x02?\x0F´î‹´=Â" b"œ9Ê\x1A?NÞK-oHa‚)\x07" b"£>ãá(.׿1\x06\x18EñSÿÉ" b"œËþ=‡ªé\x13ïÏõæ©ÀA" b"œäähÛ?ì,d‹u¸\x14¹ÿ¦" b"Ø\v%æ×ı²¯\x02aBkÀ┌ƒ[" b"Ø|╔#ÜLı¢÷░²╗´¸Ò│" b"ؼpc.ÿg_ÄÔ!êËlH³" b"ØÁ╚"╠─\x18>ÝìÈ:LźÄ" b"Ø╝ƒé▄\v%©i|ú¡ÂWú╠" b"ž\eÒe \x08ÐV\vHU‹zÕõâ" b""" ž)\x17–\n \x0ENª§ÖI÷m¥:^ """ b"žD£ÔõE Sýx±§ä’"\r" b"žFhŸ3á&æ,û½q¤¦YÚ" b"žSž0Ë’(àô)ê1ãì×á" b"žrœ>üæ¤\x12¶«Û|äÁn‰" b"×~ë©`ï%Fö\x0FØÙF┤═" b"×¢±NãË!\x012¯hìðy/þ" b"žàö’\x1A\x0F\r¼¾\x17ÝW\x18w\x0E‡" b"ƒjÔ╝@ZWðMmP]═ª\x1FÉ" b"ŸƒìïÙ\vS½\x13å†åË¢\x06" b"ƒ¡pÝÉM\x1A\x18▀[╬3\tªÉÞ" b"Ÿð\x02\x01\x15\f♂ìá”-üªJ" b"áMÉzÝ\x1Dìh1\f╦«Ñ┤±§" b" ö×öB¥ìióÓ?ô®äk" b"¡\x14B~_\x0Eý\x0Eñ(½oø¿““" b"¡Bxu%¤ã¨iÎä\x16m]‡H" b"¡ºòn_X\x14\x07,\x10È\x1Eo4Ú\f" b"¡é\x04ÈÂü\x0FPT›l\e¯Nïe" b"í±LhÅp×V‗Þâ8åLÓS" b"¢\x05²)³6Cd>yo®‚4/\x1D" b"ó\x15┐cıÚ\x16Öè╦×╚RÅÑ" b"¢OJŠÁÀ\x16uöU\x03j?Tö~" b"¢k\x11/-Zž›¯hl x\x17f’" b"ó×\raÉX\x10"u┬eYPqî'" b"¢Ö½?·Û\x01V<‹®é‚OR!" b""" ú\n \tÛý©\x0EÚÉjÝpÿ%g\e """ b"£\x15„©ŒÎ\vž‡Ø@ƒ-®8b" b"£ã\x11_‘AU_¾\x10˜K._ë€" b"ñ7Æν\x15╚â(Hü»ÿuI\x19" b""" ¤QL\x06û¡\n "Ï+ƒ&€\x17z7 """ b"Ñ6wØ\x01\x00m\x0E┘\fS\§¬¬\x1A" b"¥X|\x14Qü3Ùkó‚6»§\x0E¦" b"¥]\x1Df4C—\x1Fµ/pÙ6X'à" b"ÑwMØ~$õ\x03Ï\x04Õ£ÇtÃ" b"¥‰lMc?Í¡`[€l4sÉ¡" b"¥š\x1FYKÛÝAô‹\x16ü–œ‹ˆ" b"¦/b\x02ÉË›\x17^—\x1DèD¹+\x05" b"¦„{Š\x04uŠ4\eÈ\x08·¥\x11gñ" b"§\x12¹éd¿öeç\x0F\x14·\x11P@Þ" b"§\eVN‚ÿ¢\e.ºCd8™gF" b"§T*è’J‡Ä<ÏoÙ\}8{" b"ºzñ\x16ƒÊ-^¿\x1Fâ\x08¾%─Ø" b"§}Ês\x1D\v¦ãCÆþÛÔ6" b"§}øéÀ÷„®x<g.×ls•" b"¨\x02\x1Cz\nrÀ\x12\x16ê&;\x00\x077O" b"¨ˆ§ ²oqúìÆ•èüØÒ¶" b"¨äׄûâä!ü^6~“,Ö\x02" b"¨êMµÒ\x00‰xM@YüÒûEh" b"©\x14\x14ÉÚ¯ŸSV”‰ã0Læ”" b"©.z\vƒ<ƒ·\x1D É\x13ä1ó†" b"©I–9k^\tÆ Œ:9¤Ų̀" b"®Z~½p4ì?ü¯¦P\x0F:?S" b"©–p¿³R3\v>»òmixƒü" b"®ÜþæøÉ=«I«i:w(sr" b"®¡_üÜDò£Hq╩░(\x01Ø\x1F" b"ª€ê^ñFóèˆ\x015•~’\x1E×" b""" ªª\x04\n ¥ÊÐ¥½\x1EŒ·Ògr† """ b"«\x19ŒKg\f¯Tj¶0mĺF." b"«'’\x1D\x16_Ð\x13Ùïáæ½cfŠ" b"«yFnjÚáÎhÄ\x10¥Är“" b"«‹·}S8‘(<ó•>\x13ÿ\x16¶" b"«ŽÂΡßÆŽ´\x0E®<“Ž\x15\x08" b"«¢ÿnaÅ\x1A§6ÿˆ €ú¨’" b"«ØD¹˜©œÐ\x1Aí ûBóµ\x7F" b"«îÅ°ç\x0EqÂ\x04~[fVãv\r" b"¬+æpþ÷…u\x1FsÅ~îJ\x16P" b"¬QU„Â\eG5\x1Fo&0«¶\e^" b"¼j£ØË4Â■\x07ÏÛ\x1E¢æ\t:" b"€ïÏæÁôÚ\x0Etó¸²\9›" b"¡»ü\x19¼³»Mu┤¹Â╝&\x17?" b"«2Óm\x1E┼\fФ®w)┤Çüh" b"®~²~óyG«C\x0Eþ¶Ò\x05\x073" b"®ô\x045Q8àÛŒþ»~/\x16Ö×" b"»\v▓úFBpDúµÉ╦┬úµí" b"¯\x124ûÏ*»ØÁ]\x13W4•¡\x05" b"¯AKð®ƒÖº’бöE>\x01ì" b"¯PqJ«´\x1E\t÷xIué:Dì" b"»ì╠ë@j&vÑÐ"!¿þÙÈ" b"░æ\f┐$┌EúŸ\x12|~g╗g" b""" ±\x11*@\x10¢ND\n ^\x11TÉ’•Ñ """ b"±\x15\x0Eæx,'Àpp6\x01\x1C Çi" b"±qJ\x1AzvhFÈ€Yj‚\x00?ï" b"±ˆ’5<ÎÔœåÍjDª:\v\x06" b"±Â¬õ\eù©ûJ˜0¬5tÛ" b"±ô\x07\x04ÞV\x1D(wÞI~\x08Í£:" b"▓(\x17yñvÇj#█¶0É>\x13k" b"²[\x05æC\x07r\x18\x12\x02âñd›:T" b"▓┬9Ïá\v>q8ô╚`Ø+ö\x0E" b"³©t\x10Ý0J¥<=iE8r\x1FÚ" b"µ:m¹\¼ai¥Á\x03K—ßÒ\x19" b"ÁØ═Ô\x0EÑ\x17!█´¤6½ëü\" b"ÁóéıÓ┬nD>\v\x07ÚpµûÉ" b"¶*\x19(\f£5õz\x08Vr(\x10%à" b"¶:ö\x19…n©nsôªMé\x07.\x01" b"¶A46áyxelWuìy\x04Ëà" b"À7 üñ&±░a\t┼■xú´²" b"·<Cnw\x1Ciúìý\x18uÏ-NØ" b"ÀÅIøiÕϬ┴ä"ò\x11:5Â" b"·¦×¸äæFd ¶¤\x1CÅ;º\n" b"·Ô*`±ÜêÏÚx>_O58G" b"¹\x04ú˜qÃÃÙÚ\x15´\r“©É" b"¹\x1C}ö\f‹àâ{Rý˜œLŽ)" b"¹]Ô\rQ:„Yevb\x13\x17UÈï" b"¹^ÅG\vUÅ \x1Fœ\x17ê@Ö»ñ" b"¹wî5\x12H6ž*~‘4¯””L" b"¹œ5w-´LÙúL\x1FŸø™iò" b"¹Ÿfdl\x08°;÷¡½²d\rsè" b"╣░Þ@k-r\x1A\e?ì À× r" b"º˜=…ä4…,…×Õuï^\x11f" b"║░·╬ê¥ÄØ\x17Þa$░`dÑ" b"º´Ð~åJ§Ó\x05Ät\x17£š$" b"║ÏAßý69Ø:Pd¸yºp" b"»”àÄ ;vøä~NE×QÆ"" b"╗óçö\x13\x00█å§r├ì-▒ùÛ" b"╝>├╦îì¢\x0E╠ƒ\t╦ª\t)X" b"½\x16gè\fLŒœ\x01L”áÍ(ÈZ" b"½~èDè\fç©·³\x1Dq‹^¦ç" b"½Ôòù\x01\x1D=%jdbú|\x13GI" b"½Þê/1ö4§r\x07^5äîÎ\x17" b"¥/┴m/êu\x19Pìó4\x0F©È#" b"¥Èþü \x10=jT>"ß{+Zú" b"¾Üƒµ‚\x05uYÏh\x17’òÔÒ" b"¿(¡x3i›af™Àwí¯©!" b"┐JÖîú ºý§┌ì¥óuàà" b"¿^%]W\x06+_Œm°¤‰a‘†" b"¿±Ä¤DÕ–äéÌã'a3Ø7" b"À\x06œ‹\x14™g‡ˆ±ü÷y\x15c»" b"À\x1E?7cà¸\x7FÉo¦ì‚l\x11—" b""" └GmáUƒÐµ:└┤¤§\n ÉW """ b"┴ 8\x07±ë&æ╣ G┐ü\x06dì" b"ÁA!&ºâ×Æ\x11]‹¸–^0P" b"Á²pIwÍé0A¿\x12ãÖ·+Í" b"┬è└\x0F\x0Eaxà#$\x1Aìï\x00I\x16" b"┬Àä0-§kÙÅì┴ME\x07n½" b"ÂËž¦\f e™P8\x07¡^IÐ\r" b"Â÷3zv\x13)\x0F\x149$VTaE!" b"ÃIi†J·_9+Úç'_*4\x01" b"├`Ázìág\tıbo│Ë▒\t\x14" b""" ─'÷Å‗?¬NÞÈ\n SÚ6e■ """ b"ÄÃo¨nÛÊñÿy\x1AìhÛ¢ " b"ÄÝež´!&¬\x15\r4©GNuï" b"Äí¯¸xA36ác\x122¼06É" b"┼1¹A\rÅÀõ\x1D\x10 \x08òÇl®" b"Å9_:õý\x18‘«Þƒ\x1E0ɶ¦" b"Å•w-º"€\x16 @â>IVD›" b"ÅÑøjƒ_W\ŽÞÔÖ\x18\x7F®«" b"Åå\x00\x1AìKôß\x04rÒ]»Šl˜" b"┼¯l\x1D╦íÉÈS-Ø╩3«#G" b"Åûínu¿ý’Æ$€±‚\x03Öú" b"Æ\x03÷wÃN/Tæ„;4Ô÷(í" b"Æ;gb½•\x1Fm¹lzš<¶%=" b"ÆB\x14«LŸwõîäÏôŽ°h*" b"Ƭ\x1C:òÖIK\x0Fªr \v”Yj" b"Ƽ·»]³5-áö|V&\x03{l" b"ÆûÌpi%\x1C¸\x06´Hua\x7Fÿº" b"ÇÃ*PY6\x16À£^\tdŸ/Ú4" b"╚█¸ı\x18┼`l6â\tlGü█³" b""" É\x11\x08\n \v!ÞÊ•ó¤²Vãf† """ b"É),\t\x10R´—:¡&çšË¤5" b"Éúw0ËçCqÛó³õ \fja" b"ÊÁzM&mѳ(AØU÷Älú" b"ÊÇ[\x16™\rù`£é¿ì*w¤\v" b"ÊÝŒ<¦yŒÓÀ~wê\x0F. ò" b"╩ý╣¸Ú/ëÛ(ËdÀ¹Èì±" b"Ë"`uR\x13]“€“Û!UÚûR" b"ËaÚýÕÿ·(”\x1A<\Ð\fA\x1D" b"ˆ¢-R÷÷í¡Œ÷…ŽI\x17\x12" b"ÌBnð2l\x15¾ÏiÎÉØ\x0FyX" b"ÌBøùj\x13=gGÇ£õÙÉR‹" b"ÌFa)€²öÃ\f‘.Zb¯ú\n" b""" ÌŒ\x03“¿\n DŒ·2h÷Äü<ï """ b"ÌŽ—€Ñû†Þt\x7F\}Å\x13\x08" b"ÌÓ%}à‰\f"2\x04{ãÛØ°\x15" b"Ìã™ñF]\x15ͯ©"³.¿{M" b"ÌéTÉ5Zm\tæœg×™ÎÜ®" b"╠·À>v─o‗Aù%┼\eôüƒ" b"Í\x01¥Ié‚Ï.²¯{Óékgt" b"Í=]Êa”É<&ˆÎ-ƒhÐò" b"ÍJì.‹]|hèv®Ù½µŸ" b"Ík“×\x17Êa›&‚¤\x0Eùý?j" b""" Í{\n ij–\x10`¶ \x11óÒ¼©\x14 """ b"ͲðÔîíØl3\x1CD‚Ûýz5" b"ÍÎ{ˆ|U\x10|§eÑÛÕ\x05â" b"ÍÝyb!Ý:ï"K½W£Î߯" b"═¶cF\x19رUkm\x03ê¸┼w┌" b"Î\x11"\x1FB’¨=ÿááºí)Fæ" b"Î\x17œUºÉápq‘bŸêÚÆ[" b"ÎO ˜óë)[‚ªt¢@™5f" b"ÎþôCôWw†E§âÆ<äíµ" b""" Ï$\x06)ì1ò\x1C9ÂÝ\n \x15~Žf """ b"Ï<w\x18þˤãù~{èùÃgŸ" b"Ï<Î\x15\x0F…í\x1D»‹\x10›‰\t¯«" b"Ï‚rë¯Þ[¹\x10Q[§ðÊ„O" b"¤¬ÙÜO┐»Öì\x13ü■çı¦x" b"ЧŽÛÔH‘rí§¾\x15\e?\x7Fá" b"Ñ >ŠX\x7F]\x07M\x01ñwÏ1‰M" b"Ñ^UÝSä\vîngf5¦\x02êæ" b"Ѷ\x11èéUˆ]ÅÇ›\vc÷á‚" b"Цbá\x1F(¶░Øù\x04┤Ä└\x05Â" b"ÑçÝ–Œ§Àq†\x16bp§Qm„" b"Ð‗ò´u\x0E$ñï╣╔┴×\x05\x00ì" b"Ò\x12·¶\x07X\e9q‰åù\x19ÔŠ|" b"ÒFzØ\x10ëëí²¤\x7FŠ¿Çba" b"ÒÆí\f¨Ê1€\e˜\x00\x7FBøF(" b"ʵbY´ôüjòf\fêÊ}╩╔" b"Ë\x1Fó└ËÕks«Ý4¥Å¸®Z" b"È@ëK┼#Ó£Á\eÉ3ñäÁ?" b"Ô‚‘ãl_æï6dþ»\x05~A\x08" b"Ôëùêmüs\x7Fžn\x1Acu@N¼" b"ÕHÒåÝ.ļâ3+ËÚåÍo" b"ÕU•3‰ÊÊ\x1Dr¸gZýè«c" b"Õ†ðiTö4»˜Ø\x0F\x03žJ\x17œ" b"ÕœVe*²-Ë€)¶(U>À\x0E" b"Ö*ˆÚ¦+$é3-\x17ü]\c¯" b"Í¿ø\fboÜjï■ÍÊÜ\rgØ" b"ÖìKõâ!FÜ÷\x15.ÒVÚ‘‰" b"ÎZs┘ÑÉ5░ù©\x03KÈ║Óª" b"×fºÇ\x1AQO>Ïòä\¬’\x16É" b"×ÓŒ÷I‚Ûj\x19=#“j\x17·þ" b"Ø^ž-@VÛ#\x1DªPôu\x00ÿ" b"Ø‚£õ_:úþF“õÚª\x16KÉ" b"Ïìp║ô┐Û.\x17▓×RNÒÐz" b"Ø´5Zôj€‹î:Ò”*‹¥Ú" b"Ïã\x08\x19╬ú\x07\SÎ÷┌"╣É" b"Ïý3«V\x11¹ÂzNü´'d\x7F\r" b"ÙV˜[Ï”ëMzÜE;ä4{Õ" b"┘êÛ┘$¦ÐÉá┤e+o‗½R" b"ÙÍø\x19ëÁ\x11\x0Eä^\x14\x1A÷×èµ" b"ÙÑ{StbÈïnªì£gîqÛ" b"Ú7Ë[Ù%*¬Q«Y»œ\x18†ß" b"Ú<%j™7hÖmŠ±ó“¸\x06™" b"ÚWƯýt= \x03Ó»\fõ\x1AS#" b"Ú¬Ý\x179óò\x13¢fï³:\r8" b"ÚîÅx^Áâ29›•ÿc\x17¸Ð" b"█hîÉ3¹;%4╚\x10ò/÷\x06ð" b"Û\x7FR¾ç\x12sÛ_f\x0EµÀ›ŽÀ" b"█╗¥TüçD╩Ðl¾Ç╩,┬ð" b"ÛÚd\x06~\x16ÕÊ.BÆÒ^Ñ)Ð" b"Ük¨ÏŠ¹\x12þã‰ïÍF\x04‘$" b"Ü 1•¤–ã=•ü\x12Ó0bÂK" b"▄‗├▓O\x10╔\x00C\x05òi2îÉÅ" b"ÝVaƒì\x1F×b\f\x06."9c6" b"¦v\x1ABÉ;Ð█I÷╗\x07¦ÐÞc" b"ÝÞK„\x0F´\x107\x07¼$cÓ\x17\x06k" b""" Þ#bZéRT\x1F\x16¿Ôšz\n \t¬ """ b"Þâ¢Lê®#\x17\x05¦F7•}~\x12" b"ß\x06ÊÃ%áìT{¶\x108¤Ö.ž" b"ßXÝpk2¾Ü\x11¨âVÞ\x0Eïh" b"▀]ã│┐å┤f¼jüÝoÇ)¥" b"▀è\x7F³xüB-³\x04\x1EÎ\x0Ej\x07" b"▀«â÷┐\x01=t¹è▄(XÅ\vÍ" b"ßÁ4E\x15À®õ³sß0\x00V÷\" b"▀┴m±┘¡c\x08ZÁ\x08>ù\x13ØS" b"▀þ¤Sj\x08»\x1A·┴\x0EÉ\x06mg3" b"ßþ$\x14ò=Y;¨»¹â´PÃJ" b"Ó\x03øºc²o┐çÉ\t├J'Ø░" b"ÓÅì╚▓┼3È\x00║[U╚}\¯" b"á0i\x1E0€‡Ë\x07³Ñ ß×Ü7" b"á`[Z'x\x14Ü*ç\x12³å2œ\v" b"á”Ý"w´ÇÑ8ªå“Å%u" b"áàe!³(K„<'‡J\x15× " b"â\rë•ß¼)óMAþæ‚æ\x05ó" b"ãQ¼\x14S.6$_–ý–ÿ%ï\x13" b"ãcöYS\x08SN/c¨\x12žqn-" b"Ò│öéC\x13Þsçðm¨┼ü&y" b"ãÜ8òI9\x13 Üò¶DPÉXV" b"ãè÷VÄç¬iö¿;Ûï²kâ" b""" ãþ\x19kGÚƒ¾ÎÌ\n é\x1CÐK\x12 """ b"ä\x1C¨§"t#æÕñ\fÀÉ‘¾Y" b"äE¿\x11¾0\x1D¾Ð꿸æÙiK" b"äHz\x02økÅÜ*-î¹áDM\x13" b"õqBE«HÚÉ▄Õm╦Ø▀ |" b"ä”_qÚŽ|üﹺ£\Tkè" b"䚆–!\x16…¯)4É\x18\x03¿>¤" b"õáؾE╔_)ß'ı¹a\x08\x05" b"䪿7FaÇè0f4>>\x1EGã" b"äÆ=usSÛ—üÎÚDùœa\x1E" b"äÌ%)¹RÚÃD´žªô0d8" b"å\x12¢ÅèDϦkkî±<D{î" b"å(B.:œ\x05µ S\eeJ~™g" b"å/Ø?’ò\e•\x06\x19õ¿ÌÃ\x03é" b"ÕY°²©HúOù×╠ÅJën\x1A" b"µé² í*ð\x0FZ$°lfÅÆÁ" b"µî9Ïâ╣╦▄W┤¾\x15A┌ü░" b"æ´m¹oW6ÿmË\x10O9³'" b"æÚ˜RˆLõç[<©úŽG\x14N" b"æá§\x11Žž\x08?«Þ\x1CÐsD¡ª" b"çË¡j€6™Ù“´À|‹±Cï" b"þÔFÖ\t$¹ì¯ú`U\x14ä[Ï" b"Þ#\x0Eï═ÛÌ┐ZËn÷ ñÉP" b"è¬b¬–Õ~4vÂmå`O\eÙ" b"èÜŒuÁ\x12{•5ÕÓB´ÈƒÐ" b"é\x05Ùôol¦†‘Ö—ô™Ð.³" b""" Únµ\x08s\n 1¼└ÿ,ÅùQÌ£ """ b"ÚÀÉp\x08j%H\x1C╠║~å¨╩a" b"éÃmÏmëÓ±ˆï×ÎS4½2" b"Ú█z\x16ıº2T\ØH]}Mg\x11" b"éöÏ#¹AS\x7F¨BvÓP\x13™»" b"Ú²▀\x14Å\x1Dø´\x1C°°À\x00ë\f└" b"Û:"r^\r-\x19╬ZßÚ#uØU" b"êaè-µ:a1\x7FüXÞqôƱ" b"Ù&Ø-¹\x1C]ÃÉJ³¶/▄ÅJ" b"Ùfq°5O Ú$$Üð\x0E¤░Å" b"ë‡t¶{G蘓§À´>%Ú1" b""" Ù└6sØyo\epý\n ?\fcâe """ b""" ëÔ€;\x111\x01‘\n :¥\8Å# """ b"ì\x02Í°5@\x17\x06Û\fÛÝ@É€" b"ìcVÇ•–Jp¸\x1D³\x15Å\x16ÝŽ" b"í5Ä€3\x01a×V͆¢V¬ƒ\e" b"ídJ™GY\x16\x02\x13•À‹f~¤Á" b"ísÉ®Hœ\x1EMý\x00'DØ¡Bv" b"í™|–;~°Ì’\fµ¶lÀä~" b"ݽeZb■¼ÑàÏ©IÕZ9ì" b"íïeš83Þ†3\x19\x1E÷ÞÒ‹ï" b"íñ?C^\x0F6ú½«"&\x04\x1F{\x1D" b"Ý·Hâ¾y,\x17║╬?vÇØû┤" b"îÌ‹\x0EèD¶H·yq\t¿äŠ…" b""" îÞ;î¡\x10mýNÛÙÛ—P\n œ """ b"îç•\x1Eª3ýbƒ”\x1Dc‹x«" b"ïXí¨¹·n&MÊÜÀ`\x14Ô\x14" b"ï•šÑ>¯\x02”\x04\x05\x00JƱ¦E" b"´├┘:÷áÖ¯½bµÒÅ╔ı2" b""" ´³\x14\n ]ôGÓÉ░┘Q\x1Fûıd """ b"ð&¶rº)Áß\r¹ŒAŽƒÒ" b"ðSš—8ò5\x08z\x1DP‹uß1R" b"^\x16(ô 7E¼■1Þj▀Üì" b"ðÇWÜÇ]\x17µß—X&Wáò" b"ñ¨OèÖ‡Ó·%0¹ûOë–ø" b"±ã¡╠└ü╚■sÔ\x16¦Û\v(\x7F" b"ñÊêß:È1Ä[×\x7Fò\x11Sì\n" b"òJü7m\x10€È^®ns,¿Ï&" b"òR¥e\x1Dó^Â\x03½\foÎu)¡" b"óYPË\x1F$wmIÔð[³AjÆ" b"óe„JxÀ Uﯺœ*ðÏS" b"¾Å~R\x12\e©ßóâ¶-(qª╩" b"ó™ø„°M)?Ò®\x07í\x0EÛ%ò" b"óñ……»ƒ\x14RÒÞ\x06B\x05|›í" b"ô+g\x18øÝâÊT\x18sÃ\x0Fï‡i" b"ô/ë>š]A;\x18‘Ç»›:\x19Í" b"¶H>=\x12mCjy+cäIì┴-" b"§1▒CïÛì\r╣\e\x0ED®+f»" b"õ´D\x10žÙD’³çÜ}\x17\x03zº" b"õÇ" r‘/E\t²ŽA>—dÝ" b"öË WCôb\x1EÕ\x06‹z”ÀœÜ" b"öíÌÒ\x173»à¥L\x1498“\rF" b"°\x03\x03\x11ó\x1Fl╩÷h┘wì▓²╠" b"°ú,\x1A,Ê¥bÅb~╚Í╠¤à" b""" ø®^!\x0E’\x10Š\n \x0EÃzRÔJ? """ b"ø´”¾ÏP’söuK,Ò6æ\x7F" b""" øþ\x11!Ò<\x18\x05ló\f\x03¥\n \x07ß """ b"¨`\x05\x07á\x1C\vضOýÖqAê╗" b"¨Ø┤<×÷ƒ3<-£é\e═\x1D" b"ù¯:>‡Z©»»n‹QMv%«" b"ùߟIÄܽ MäXŽ{Ÿ ¿" b"úh½\x02\eš<1õ:Â×EË0^" b"úhé®\x14·Î×\rëe\x15Þ†HB" b"ú‹ËVü)¸I]/p\e~\x12T=" b"úœ$T#°\x7Få¿&Î'Á¹Xg" b"·─÷\r▄£\x17؃zr\x08E┴u\x04" b"û6¥ÑDª[È\x00§\x1D,¼JÜŸ" b"¹<┌│\f°ıRò·Y\x14OØxH" b"¹a½Ç~▓Ø¿kZ-âO╔;R" b"ûd+"o/Lfw‰…¨¯M†J" b"ûh"E¾\vy|oŽÀ%Føì\x01" b"û˜…%Ïg*5öË\x1EÚ„Eº" b"¹Ï\x10íåØ\x08⃶nJV|\vù" b"ü?8•ø\x02¨ì¡â\x06Ĭ:ŠÉ" b"³t$\x03vÀ\vÒ\x1Cìõ@ ■Òu" b"üˆIÿ-´–qÿÁ\#•§®7" b"ý-rs5ÂÝs³Â\v…¾~\x17\x04" b"ý3™#½¥É\x00ÓìZÇ0\x04fz" b"ýb/\x17òj\x11ãzrCO³ð\x11ï" b"ý¤oô¿à\x17-«V\x0F5\x10c3ç" b"ý±}Õ¾æN\x0Ec6OÛë™\x03&" b"²Ímå░½\x02Yƒ×è°Éec7" b"þJ“IŸæÏn\x1C„éÈ—Y~å" b"þ˜7\x08ÂœŸ’û\r\x04°\x1F-\x0E³" b"þÕ\x05ÃRK®QMp\x07vÑ»·\x12" b"ÿ\x1EåE\x02Ç@ǜٗ:ê\x12 ê" true ] |
||||||||||||||||||||||||||||||
|
2.61 ms (8.05%) |
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"Dýþb«~AÒá▒0\x14êÉ~¬" ] |
||||||||||||||||||||||||||||||
|
2.41 ms (7.45%) |
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:
[ "/Fahrer-Berlin-Akku-Cover-Tube/6850" "https://stage-sw6.radwelt-shop.de/Fahrer-Berlin-Akku-Cover-Tube/6850" "stage-sw6.radwelt-shop.de/Fahrer-Berlin-Akku-Cover-Tube/6850" 1 "regex" "/Fahrer-Berlin-Akku-Cover-Tube/6850" "https://stage-sw6.radwelt-shop.de/Fahrer-Berlin-Akku-Cover-Tube/6850" "stage-sw6.radwelt-shop.de/Fahrer-Berlin-Akku-Cover-Tube/6850" "regex" "/Fahrer-Berlin-Akku-Cover-Tube/6850" "https://stage-sw6.radwelt-shop.de/Fahrer-Berlin-Akku-Cover-Tube/6850" "stage-sw6.radwelt-shop.de/Fahrer-Berlin-Akku-Cover-Tube/6850" ]
|
||||||||||||||||||||||||||||||
|
2.16 ms (6.66%) |
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""" u\e├¬Õ¡¸▓É%×\n ¢õV """ b"ú$m\x02bÃ’V\x17°Ç+²\x0Eë\x1D" 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ü" ] |
||||||||||||||||||||||||||||||
|
1.76 ms (5.42%) |
7 |
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"hUEn/õjØIËË»OWD=" ] |
||||||||||||||||||||||||||||||
|
0.90 ms (2.78%) |
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"h(>–‹5/\x13æÎNáµ×lú" ] |
||||||||||||||||||||||||||||||
|
0.87 ms (2.69%) |
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.83 ms (2.55%) |
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/44ece762ae7e41e3a0b1301488907eaa" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" ] |
||||||||||||||||||||||||||||||
|
0.68 ms (2.11%) |
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"Dýþb«~AÒá▒0\x14êÉ~¬" b"/»_ââšMpªXTÎ|ãâ\v" ] |
||||||||||||||||||||||||||||||
|
0.68 ms (2.09%) |
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"Dýþb«~AÒá▒0\x14êÉ~¬" b"Dýþb«~AÒá▒0\x14êÉ~¬" 1 ] |
||||||||||||||||||||||||||||||
|
0.61 ms (1.89%) |
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Üâ—" "Fahrer-Berlin-Akku-Cover-Tube/6850" "Fahrer-Berlin-Akku-Cover-Tube/6850/" ] |
||||||||||||||||||||||||||||||
|
0.50 ms (1.55%) |
4 |
# app-scripts::refresh::search-ids SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ?)
Parameters:
[
true
]
|
||||||||||||||||||||||||||||||
|
0.50 ms (1.55%) |
2 |
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"\UùŠ9my!eE^\x07Š<_" b"¸©Å╔└\x10G\x02®ofM½■&V" ] |
||||||||||||||||||||||||||||||
|
0.49 ms (1.51%) |
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"Dýþb«~AÒá▒0\x14êÉ~¬" b"Dýþb«~AÒá▒0\x14êÉ~¬" ] |
||||||||||||||||||||||||||||||
|
0.47 ms (1.46%) |
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.40%) |
2 |
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.34 ms (1.06%) |
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"hUEn/õjØIËË»OWD=" b"\v´®Áq\x05!Á.çb‰ÙD\x08\x17" ] |
||||||||||||||||||||||||||||||
|
0.33 ms (1.03%) |
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.32 ms (0.99%) |
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.30 ms (0.92%) |
1 |
SELECT `payment_method`.`id` FROM `payment_method` WHERE (`payment_method`.`handler_identifier` = ? AND `payment_method`.`active` = ?)
Parameters:
[ "Kiener\MolliePayments\Handler\Method\ApplePayPayment" true ] |
||||||||||||||||||||||||||||||
|
0.27 ms (0.84%) |
1 |
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
0.27 ms (0.84%) |
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.27 ms (0.84%) |
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.27 ms (0.83%) |
1 |
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
"de-DE"
]
|
||||||||||||||||||||||||||||||
|
0.26 ms (0.81%) |
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"äNg‚ÆBG·–¸‘Ï%®8÷"
]
|
||||||||||||||||||||||||||||||
|
0.26 ms (0.81%) |
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.25 ms (0.76%) |
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.23 ms (0.72%) |
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.21 ms (0.65%) |
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.20 ms (0.61%) |
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.20 ms (0.60%) |
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.18 ms (0.56%) |
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.17 ms (0.53%) |
1 |
SELECT `payment_method`.`id` FROM `payment_method` WHERE (`payment_method`.`handler_identifier` = ?)
Parameters:
[
"Netzkollektiv\EasyCredit\Payment\Handler"
]
|
||||||||||||||||||||||||||||||
|
0.16 ms (0.49%) |
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.16 ms (0.49%) |
1 |
SELECT module.module, module.response FROM wbm_data_layer_modules module
Parameters:
[] |
||||||||||||||||||||||||||||||
|
0.15 ms (0.48%) |
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.15 ms (0.47%) |
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.15 ms (0.46%) |
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.14 ms (0.44%) |
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.44%) |
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.14 ms (0.42%) |
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.14 ms (0.42%) |
1 |
SELECT `name`, `path`, `author` FROM `app` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||||||||||||
|
0.13 ms (0.40%) |
1 |
SELECT custom_entity.name, custom_entity.fields, custom_entity.flags FROM custom_entity LEFT JOIN app ON app.id = custom_entity.app_id WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
0.13 ms (0.40%) |
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.13 ms (0.39%) |
1 |
# dbal-plugin-loader SELECT `name`, `base_class` AS baseClass, IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active, `path`, `version`, `autoload`, `managed_by_composer` AS managedByComposer, composer_name as composerName FROM `plugin` ORDER BY `installed_at`;
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
0.12 ms (0.38%) |
1 |
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||||||||||||
|
0.12 ms (0.38%) |
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.12 ms (0.38%) |
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.10 ms (0.32%) |
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.10 ms (0.31%) |
1 |
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[ b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" "TrgQRi4EQQxdlsKdImScMrWU8ipGwYIH" ] |
||||||||||||||||||||||||||||||
|
0.09 ms (0.29%) |
1 |
#cart-persister::load SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters:
[
"TrgQRi4EQQxdlsKdImScMrWU8ipGwYIH"
]
|
Database Connections
| Name | Service |
|---|---|
| 0 | default |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.