14.71 ms (26.79%)
20
SELECT `currency` . `id` as `currency.id` , `currency` . `factor` as `currency.factor` , `currency` . `symbol` as `currency.symbol` , `currency` . `iso_code` as `currency.isoCode` , `currency` . `position` as `currency.position` , `currency` . `tax_free_from` as `currency.taxFreeFrom` , `currency` . `item_rounding` as `currency.itemRounding` , `currency` . `total_rounding` as `currency.totalRounding` , `currency` . `created_at` as `currency.createdAt` , `currency` . `updated_at` as `currency.updatedAt` , `currency.translation.shortName` , `currency.translation.shortName` as `currency.shortName` , `currency.translation.name` , `currency.translation.name` as `currency.name` , `currency.translation.customFields` , `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation` . `currency_id` , `currency.translation` . `short_name` as `currency.translation.shortName` , `currency.translation` . `name` as `currency.translation.name` , `currency.translation` . `custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation` . `language_id` = ? ) `currency.currency_translation` ON `currency.currency_translation` . `currency_id` = `currency` . `id` WHERE (`currency` . `iso_code` IN (? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
"CHF "
]
SELECT `currency` . `id` as `currency.id` , `currency` . `factor` as `currency.factor` , `currency` . `symbol` as `currency.symbol` , `currency` . `iso_code` as `currency.isoCode` , `currency` . `position` as `currency.position` , `currency` . `tax_free_from` as `currency.taxFreeFrom` , `currency` . `item_rounding` as `currency.itemRounding` , `currency` . `total_rounding` as `currency.totalRounding` , `currency` . `created_at` as `currency.createdAt` , `currency` . `updated_at` as `currency.updatedAt` , `currency.translation.shortName` , `currency.translation.shortName` as `currency.shortName` , `currency.translation.name` , `currency.translation.name` as `currency.name` , `currency.translation.customFields` , `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation` . `currency_id` , `currency.translation` . `short_name` as `currency.translation.shortName` , `currency.translation` . `name` as `currency.translation.name` , `currency.translation` . `custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `currency.currency_translation` ON `currency.currency_translation` . `currency_id` = `currency` . `id` WHERE (`currency` . `iso_code` IN ('CHF' ));
Copy
7.99 ms (14.54%)
1
SELECT seo_path_info , path_info , sales_channel_id FROM seo_url WHERE (seo_url . is_canonical = 1 ) AND (seo_url . path_info IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )) AND (seo_url . language_id = ? ) AND (seo_url . sales_channel_id = ? OR seo_url . sales_channel_id IS NULL ) AND (seo_url . is_deleted = 0 )
Parameters :
[
"/navigation/01918e44035c7dc4a99bc47f495a0711 "
"/navigation/01918e441648700e84ab007847d14512 "
"/navigation/0197b0e006967583a7245f4339110739 "
"/navigation/01918e4433887438a3185dfc267b9174 "
"/navigation/01918e4448a17cb7a6646183e26966fd "
"/navigation/01918e4464247aa5bb2372768ea01664 "
"/navigation/01918e4473d2731eade248d232e85ad9 "
"/navigation/01918e46601f7eab9c3a08cb62266585 "
"/navigation/01918e46f43b76e490998278ab83a15e "
"/navigation/01918e4733ab7ce4a04db008d6a0571e "
"/navigation/01918e473c867224a4cd794a3490c061 "
"/navigation/01918e4757337158a5d95ed3b53a109d "
"/navigation/01918e477ca57fc0a0939f9d671ba749 "
"/navigation/01918e47a64570b59e89994cd433f4d1 "
"/navigation/01918e47bf7374f7b87f760ad53a6f9f "
"/navigation/01918e47d74f74c2aedd9ad470bb4737 "
"/navigation/0191ee9a80f5792aa4470bc1bb7ddabd "
"/navigation/01936d7a6944779cb990d593d7d9b140 "
"/navigation/01936d7b874370fa909a2becef1ac7f3 "
"/navigation/01936d7badff7c64aece3984ce06f2c7 "
"/navigation/01936d7bdb987601b94de98ae7052632 "
"/navigation/01936d7c04c47d08af4b053e0605b585 "
"/navigation/0197b1c1191b74fb913d877e813e9a33 "
"/navigation/0197b1d5eefe74abbe9ec5ee2606a746 "
"/navigation/0197b1d662ba7f6eab0d5b1e1cd0e781 "
"/navigation/0197b1d741c77750808bb080c573fb3e "
"/navigation/0197b1c1616279c9a4d8e781cbf173cf "
"/navigation/0197b1defcd8701ebb59303fe3ee4e79 "
"/navigation/0197b1e740ce74b3b95fa94eb90d6482 "
"/navigation/0197b212ee197f59aba350173d0f3870 "
"/navigation/0197b213d68170518b54ec3e38fa07c7 "
"/navigation/0197b213f7187e429075394413321bad "
"/navigation/0197b1e7605170709081ec0aeb90cca7 "
"/navigation/0197b228d5577f7196f05c286b6607de "
"/navigation/0197b22a1f0c7d9a97bc1e3859bb6740 "
"/navigation/0197b22a2dad7566a2eda9c10bc43d14 "
"/navigation/0197b22a3664705db9413337a7a2dd63 "
"/navigation/0197b22a3a3f7957be91e796f89378b9 "
"/navigation/0197b22a45e6768d82b1b08c10a3a7fe "
"/navigation/0197b22a4c8f7054bfddd2570ea510eb "
"/navigation/0197b22a3e767cb1a01f7ee9c5ec7457 "
"/navigation/0197b22a426d7966ba8e1f01a46eefbf "
"/navigation/0197b22967937c8387711229c2ba42f6 "
"/navigation/0197b22d432c7aa18713d9633996a846 "
"/navigation/0197b22d5c18798ca5d6235a91ae9faa "
"/navigation/0197b22d617977b1b4bcd1907752f260 "
"/navigation/0197b22d670b79859e22dafbc6a8361e "
"/navigation/0197b22d6a9e7827acd9a4db7458b21a "
"/navigation/0197b22d6d5f7c899774d5c5a00c4431 "
"/navigation/0197b22d72767ff4adffaa731821c543 "
"/navigation/0197b22d756c71bca58843309235dcb3 "
"/navigation/0197b22d784d716684949235c56d44d1 "
"/navigation/0191ee9ae9317bd79b501cffd3fb613e "
"/navigation/0197d0fd7b077c55b800312ed2c2cf29 "
"/navigation/0191ee9b16a97cc9a147cd4449f46348 "
"/navigation/0191ee9b239e7c9181e6964082608c6b "
"/navigation/0191ee9b38a0746aa93998ef15d3fe6c "
"/navigation/0191ee9b475670c983a8fc836aa5cc22 "
"/navigation/0191ee9b55af7827a4968f0e9846b94d "
"/navigation/0191ee9d0a8e741d8bd582aac09faa8f "
"/navigation/0191ee9ce967784a97d4bbe54c5ea62f "
"/navigation/019909cb27c97a0ead2c5b9206adefb4 "
"/navigation/0191ee9d1b347e3481f4071ff5017ee8 "
"/navigation/0191ee9e54a076ddaa4463979f50a4a7 "
"/navigation/0191ee9e6a3b7f28b0b45df9da9cc4c0 "
"/navigation/0191ee9e7b6d7435858c66f429866305 "
"/navigation/0191ee9eaa9c75ba8a3843b3ce4fa334 "
"/navigation/0191ee9ecac979659c233713313910fb "
"/navigation/0191ee9fac45736e8d462a8a87cc0a31 "
"/navigation/0191ee9fc09d7248bdf68188b88be38a "
"/navigation/0191ee9fc9117f43a3303ae736f72e6c "
"/detail/a19237445e4854bcf4b79d1fcaf22e87 "
"/detail/3e317664f36cad4300c3e2f15a8a5733 "
"/detail/1fe3f370918e83082c0438446a005bc7 "
"/detail/459cda4daabde2daf7b44936cea2409a "
"/detail/13c16dfa473b16b5cf5a0cd46866ff6e "
"/detail/629523e43ae6ab9270ba7e184084ea0f "
"/detail/4835533bdbcb2bde3d3c938bf3bc4f8a "
"/detail/2b23c0995ec5348d1f19c52d24e6c588 "
"/detail/5df864b5a842fa4f9b275a4f7428213b "
"/detail/acb704f9afd5424e2429b8eb12a1309f "
"/detail/6764b799caaab5b2613c61b090cfed30 "
"/detail/4d7ca9551af2cbc7df89d907292d48c8 "
"/detail/b20d15a601ad88ad854bd6e7a2d4f2d7 "
"/detail/e84d0760fe866f78f54cd6ddd19497cf "
"/detail/fdc5de9dd0d3de08f16c69cfa2e058f3 "
"/detail/292400e79da21779b421d3ae5fe3c5df "
"/detail/159a33532f4c3f36ac38d4b79e334e3b "
"/detail/5b26e10d30f0e6e844487708f8df7ca1 "
"/detail/4a587d2390f3fa7289afc8a2f06922f8 "
"/detail/b99025b5a9e8f9836ade07cc49130eb9 "
"/navigation/01968c8c36bf7d64a6458dea553bd083 "
"/navigation/01968c8c66857cbdaa3fe53f64460992 "
"/navigation/01968c8c819b7a3f80b7123704ac53e6 "
"/navigation/01968c8ca8b57752817b01710b71694a "
"/navigation/01968c8e2d3a74a38a6c10f9f8460cea "
"/navigation/01968c8e463172098d9fdfbd02e7079a "
"/navigation/01968c8e5ce473fd981f91192b9ea060 "
"/navigation/01968c8e70bd7f69b2d493c206e115cb "
"/navigation/01968c8eb0427cb382bf2677391a27af "
"/navigation/01968c8f733271dda4a6b5b5769d6a3d "
"/navigation/01968c8fcbcb7e17b2c838cd17eec670 "
"/navigation/01968c904e6a7dc795fb655c6bba1a6c "
"/navigation/01968c910b567b13bd06bf0bb60f3a0d "
"/navigation/01968c91ed89784c83a9842c8cea2016 "
"/navigation/01968c9316807749a8a0e77442aec819 "
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 ‘J13£x"‰m\f p²ý;g "
]
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 )
Copy
SELECT seo_path_info , path_info , sales_channel_id FROM seo_url WHERE (seo_url . is_canonical = 1 ) AND (seo_url . path_info IN ('/navigation/01918e44035c7dc4a99bc47f495a0711' , '/navigation/01918e441648700e84ab007847d14512' , '/navigation/0197b0e006967583a7245f4339110739' , '/navigation/01918e4433887438a3185dfc267b9174' , '/navigation/01918e4448a17cb7a6646183e26966fd' , '/navigation/01918e4464247aa5bb2372768ea01664' , '/navigation/01918e4473d2731eade248d232e85ad9' , '/navigation/01918e46601f7eab9c3a08cb62266585' , '/navigation/01918e46f43b76e490998278ab83a15e' , '/navigation/01918e4733ab7ce4a04db008d6a0571e' , '/navigation/01918e473c867224a4cd794a3490c061' , '/navigation/01918e4757337158a5d95ed3b53a109d' , '/navigation/01918e477ca57fc0a0939f9d671ba749' , '/navigation/01918e47a64570b59e89994cd433f4d1' , '/navigation/01918e47bf7374f7b87f760ad53a6f9f' , '/navigation/01918e47d74f74c2aedd9ad470bb4737' , '/navigation/0191ee9a80f5792aa4470bc1bb7ddabd' , '/navigation/01936d7a6944779cb990d593d7d9b140' , '/navigation/01936d7b874370fa909a2becef1ac7f3' , '/navigation/01936d7badff7c64aece3984ce06f2c7' , '/navigation/01936d7bdb987601b94de98ae7052632' , '/navigation/01936d7c04c47d08af4b053e0605b585' , '/navigation/0197b1c1191b74fb913d877e813e9a33' , '/navigation/0197b1d5eefe74abbe9ec5ee2606a746' , '/navigation/0197b1d662ba7f6eab0d5b1e1cd0e781' , '/navigation/0197b1d741c77750808bb080c573fb3e' , '/navigation/0197b1c1616279c9a4d8e781cbf173cf' , '/navigation/0197b1defcd8701ebb59303fe3ee4e79' , '/navigation/0197b1e740ce74b3b95fa94eb90d6482' , '/navigation/0197b212ee197f59aba350173d0f3870' , '/navigation/0197b213d68170518b54ec3e38fa07c7' , '/navigation/0197b213f7187e429075394413321bad' , '/navigation/0197b1e7605170709081ec0aeb90cca7' , '/navigation/0197b228d5577f7196f05c286b6607de' , '/navigation/0197b22a1f0c7d9a97bc1e3859bb6740' , '/navigation/0197b22a2dad7566a2eda9c10bc43d14' , '/navigation/0197b22a3664705db9413337a7a2dd63' , '/navigation/0197b22a3a3f7957be91e796f89378b9' , '/navigation/0197b22a45e6768d82b1b08c10a3a7fe' , '/navigation/0197b22a4c8f7054bfddd2570ea510eb' , '/navigation/0197b22a3e767cb1a01f7ee9c5ec7457' , '/navigation/0197b22a426d7966ba8e1f01a46eefbf' , '/navigation/0197b22967937c8387711229c2ba42f6' , '/navigation/0197b22d432c7aa18713d9633996a846' , '/navigation/0197b22d5c18798ca5d6235a91ae9faa' , '/navigation/0197b22d617977b1b4bcd1907752f260' , '/navigation/0197b22d670b79859e22dafbc6a8361e' , '/navigation/0197b22d6a9e7827acd9a4db7458b21a' , '/navigation/0197b22d6d5f7c899774d5c5a00c4431' , '/navigation/0197b22d72767ff4adffaa731821c543' , '/navigation/0197b22d756c71bca58843309235dcb3' , '/navigation/0197b22d784d716684949235c56d44d1' , '/navigation/0191ee9ae9317bd79b501cffd3fb613e' , '/navigation/0197d0fd7b077c55b800312ed2c2cf29' , '/navigation/0191ee9b16a97cc9a147cd4449f46348' , '/navigation/0191ee9b239e7c9181e6964082608c6b' , '/navigation/0191ee9b38a0746aa93998ef15d3fe6c' , '/navigation/0191ee9b475670c983a8fc836aa5cc22' , '/navigation/0191ee9b55af7827a4968f0e9846b94d' , '/navigation/0191ee9d0a8e741d8bd582aac09faa8f' , '/navigation/0191ee9ce967784a97d4bbe54c5ea62f' , '/navigation/019909cb27c97a0ead2c5b9206adefb4' , '/navigation/0191ee9d1b347e3481f4071ff5017ee8' , '/navigation/0191ee9e54a076ddaa4463979f50a4a7' , '/navigation/0191ee9e6a3b7f28b0b45df9da9cc4c0' , '/navigation/0191ee9e7b6d7435858c66f429866305' , '/navigation/0191ee9eaa9c75ba8a3843b3ce4fa334' , '/navigation/0191ee9ecac979659c233713313910fb' , '/navigation/0191ee9fac45736e8d462a8a87cc0a31' , '/navigation/0191ee9fc09d7248bdf68188b88be38a' , '/navigation/0191ee9fc9117f43a3303ae736f72e6c' , '/detail/a19237445e4854bcf4b79d1fcaf22e87' , '/detail/3e317664f36cad4300c3e2f15a8a5733' , '/detail/1fe3f370918e83082c0438446a005bc7' , '/detail/459cda4daabde2daf7b44936cea2409a' , '/detail/13c16dfa473b16b5cf5a0cd46866ff6e' , '/detail/629523e43ae6ab9270ba7e184084ea0f' , '/detail/4835533bdbcb2bde3d3c938bf3bc4f8a' , '/detail/2b23c0995ec5348d1f19c52d24e6c588' , '/detail/5df864b5a842fa4f9b275a4f7428213b' , '/detail/acb704f9afd5424e2429b8eb12a1309f' , '/detail/6764b799caaab5b2613c61b090cfed30' , '/detail/4d7ca9551af2cbc7df89d907292d48c8' , '/detail/b20d15a601ad88ad854bd6e7a2d4f2d7' , '/detail/e84d0760fe866f78f54cd6ddd19497cf' , '/detail/fdc5de9dd0d3de08f16c69cfa2e058f3' , '/detail/292400e79da21779b421d3ae5fe3c5df' , '/detail/159a33532f4c3f36ac38d4b79e334e3b' , '/detail/5b26e10d30f0e6e844487708f8df7ca1' , '/detail/4a587d2390f3fa7289afc8a2f06922f8' , '/detail/b99025b5a9e8f9836ade07cc49130eb9' , '/navigation/01968c8c36bf7d64a6458dea553bd083' , '/navigation/01968c8c66857cbdaa3fe53f64460992' , '/navigation/01968c8c819b7a3f80b7123704ac53e6' , '/navigation/01968c8ca8b57752817b01710b71694a' , '/navigation/01968c8e2d3a74a38a6c10f9f8460cea' , '/navigation/01968c8e463172098d9fdfbd02e7079a' , '/navigation/01968c8e5ce473fd981f91192b9ea060' , '/navigation/01968c8e70bd7f69b2d493c206e115cb' , '/navigation/01968c8eb0427cb382bf2677391a27af' , '/navigation/01968c8f733271dda4a6b5b5769d6a3d' , '/navigation/01968c8fcbcb7e17b2c838cd17eec670' , '/navigation/01968c904e6a7dc795fb655c6bba1a6c' , '/navigation/01968c910b567b13bd06bf0bb60f3a0d' , '/navigation/01968c91ed89784c83a9842c8cea2016' , '/navigation/01968c9316807749a8a0e77442aec819' )) AND (seo_url . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (seo_url . sales_channel_id = 0x01914A3133A37822896D0C70B2FD3B67 OR seo_url . sales_channel_id IS NULL ) AND (seo_url . is_deleted = 0 );
Copy
3.62 ms (6.60%)
4
SELECT LOWER (HEX (seo_url . id )) as id , LOWER (HEX (seo_url . foreign_key )) foreignKey , LOWER (HEX (seo_url . sales_channel_id )) salesChannelId , seo_url . is_modified as isModified , seo_url . seo_path_info seoPathInfo FROM seo_url seo_url WHERE (seo_url . route_name = ? ) AND (seo_url . language_id = ? ) AND (seo_url . is_canonical = 1 ) AND (seo_url . foreign_key IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ))
Parameters :
[
"frontend.detail.page "
b"/»_ââšMpªXTÎ|ãâ\v "
b"íÆ7D^HT╝¶ÀØ\x1F ╩‗.ç "
b">1vdólC\x00 ÃâñZŠW3 "
b"\x1F ãóp‘Žƒ\x08 ,\x04 8Dj\x00 [Ç "
b"EœÚMª½âÚ÷´I6΢@š "
b"\x13 ÁmúG;\x16 µÏZ\f Ôhfÿn "
b"b•#ä:æ«’pº~\x18 @„ê\x0F "
b"H5S;ÛË+Þ=<“‹ó¼OŠ "
b"+#└Ö^┼4ì\x1F\x19 ┼-$µ┼ê "
b"]ødµ¨BúO›'ZOt(!; "
b"¬·\x04 ù¯ÕBN$)¸ë\x12 ¡0Ÿ "
b"gdÀÖ╩¬Á▓a<a░ɤÝ0 "
b"M|©U\x1A òËÇ߉Ù\x07 )-HÈ "
b"²\r \x15 ¦\x01 ˆ…KÖç¢Ôò× "
b"èM\x07 `þ†oxõLÖÝÑ”—Ï "
b"²┼ÌØðËÌ\x08 ±li¤óÓX¾ "
b")$\x00 þØó\x17 y┤!Ë«_Ò┼▀ "
b"\x15 š3S/L?6¬8Ô·ž3N; "
b"[&á\r 0ðæèDHw\x08 øß|¡ "
b"JX}#ɾ·rë»╚ói"° "
b"╣É%Á®Þ¨âjÌ\x07 ╠I\x13\x0E ╣ "
]
SELECT LOWER (HEX (seo_url . id )) as id , LOWER (HEX (seo_url . foreign_key )) foreignKey , LOWER (HEX (seo_url . sales_channel_id )) salesChannelId , seo_url . is_modified as isModified , seo_url . seo_path_info seoPathInfo FROM seo_url seo_url WHERE (seo_url . route_name = 'frontend.detail.page' ) AND (seo_url . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (seo_url . is_canonical = 1 ) AND (seo_url . foreign_key IN (0xA19237445E4854BCF4B79D1FCAF22E87 , 0x3E317664F36CAD4300C3E2F15A8A5733 , 0x1FE3F370918E83082C0438446A005BC7 , 0x459CDA4DAABDE2DAF7B44936CEA2409A , 0x13C16DFA473B16B5CF5A0CD46866FF6E , 0x629523E43AE6AB9270BA7E184084EA0F , 0x4835533BDBCB2BDE3D3C938BF3BC4F8A , 0x2B23C0995EC5348D1F19C52D24E6C588 , 0x5DF864B5A842FA4F9B275A4F7428213B , 0xACB704F9AFD5424E2429B8EB12A1309F , 0x6764B799CAAAB5B2613C61B090CFED30 , 0x4D7CA9551AF2CBC7DF89D907292D48C8 , 0xB20D15A601AD88AD854BD6E7A2D4F2D7 , 0xE84D0760FE866F78F54CD6DDD19497CF , 0xFDC5DE9DD0D3DE08F16C69CFA2E058F3 , 0x292400E79DA21779B421D3AE5FE3C5DF , 0x159A33532F4C3F36AC38D4B79E334E3B , 0x5B26E10D30F0E6E844487708F8DF7CA1 , 0x4A587D2390F3FA7289AFC8A2F06922F8 , 0xB99025B5A9E8F9836ADE07CC49130EB9 ));
Copy
2.91 ms (5.31%)
1
SELECT `meta_catalog_id` . `id` FROM `meta_catalog_id` WHERE `meta_catalog_id` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"¥)Nñ\x1E ´;lz)û{¯¼•\e "
b"Ö2kh{\x0F ¢\x13 !>/"Ó'z\r "
b"ÀüÚÿ\v g\x18\x1C ╠?┘õ$¸Á░ "
b"al\x18 ÙÀã▄=\x7F ü╬î\x13 ~▄Q "
b"ı)<É╠■¢\x1E\x15\f cÇõÅÓ\x01 "
b"½^Â\x16 œsþ\t Ü\x19 º°“Ð\x04 º "
b"×°«\x08 Yò\x17 ▄üD"·z¶É░ "
b"\x01 ¦º"Ç\x11 :ú¶5`}D,… "
b"F\r Pj’ s¸«ÂO§ÔëŸ_ "
b"""
?\x16 K\x0F\x1A 4ñ³‰ÅG[ñ\n
O
"""
b"²\x0F wÎJ\x16 ¯1s\x08 ÌÜSé#÷ "
b"H¨2N܈tÿÚˆÈþ W³û "
b"Ò„\x13 —!¤Ú¨’©•\x7F ›=\x08 à "
b"s¡ŽéVæìWM\f\x1D é_3‡¡ "
b"Ãä/{•\x0E åO\x05 {s“Uß©< "
b"vc\x05 `\x13 ±ZÇ‚B\x15 ¿£e\x07 § "
b"""
Ó¨Jü|gâ:$"d-\n
U║,
"""
b"M\x16 ™Lµ›¹ÁZõð\x19 ]D–À "
b"²└y\x0F zÕÐÅÞÒø\x1E «âGX "
b"d\x02 Îõ„K’Èßàéö3"ok "
b"ÈÙœ\x11 @¦ô^¡Üš5ñ¨‡‘ "
b"ç\x17 \x1F Û}€—Å›[`8Äl5 "
b"\x1F Éü\t n¹(ò±´"h£\x08\x13 U "
b"ý¦—0Ä\x13\x14\t š’Ü\e f³¾ð "
b"nâò·k[®)¿cûÊ0Óým "
b"iïc£W\r c_Ö|k;\x10 H} "
b"çÐ5ùIþÅ*ÕÜÈ|FÙ'\r "
b"t9w’\x12 •ú”næ2ä…àâÊ "
b"}Ã\x1A\x16\x0E ÕÓ(©õ•T–\x18 Ö£ "
b"ƒÔ\x1C Ññ²ä!2lüýúƒ┼þ "
b"\x19 "ÇŸØÁö팾\x16\x10\x13 …yÙ "
b";YÔ\x06 f<l\x04 ä”߿ޛöK "
b"f\x1F\x1D X8ˆtM\e ™¢[44îÅ "
b"H•À%•ø¹{\x14 ;6£hmÃl "
b"üÒ02┐├╦ߨ?ß▓ðÊmu "
b"Y>Ѽo+évë‘\x1E ðSµµß "
b"""
U·\x08 á#áÆ\n
¹»\x01\x06 ï\x07 ¶N
"""
b"Bñå1X˜H®ÝðËú7¹J@ "
b"ªÙ5╣câ\x0E É┘¦£\r Æ;╦ "
b"„ä\x1F\x08 ôx𝫫kamž'& "
b"SP¦G?×╩┘ØTq¨¿\x00 h╠ "
b"øY¼$”¹>ŤmÝ\x14 Èt[e "
b"a+éÔñ¹I/ÎmÖˆ„²,‡ "
b"´*OžÞ‰€\x01 F³q\x14 ¯{Zð "
b"C\x16 ,\x16 Œ\r \x05 Hhk\x04 d©|ë\x12 "
b"¥K¶\x7F uFrŸ"†PŸPÚ\x1C — "
b"à5ŒßÞ^j8ù.:_S»õ\x00 "
b"Ÿ\x14 @Ýã\x7F $í{B|¸x‹\x0F i "
b"ÍÈŒûV:\‰ÈÄâÈGY\x04 K "
b"¦î_ö«\x01 µ\x14 E€eúùYÜl "
b"zDž&\x07 A÷ÒB\f “:AéãM "
b"""
\x1D i\x1A\x10 Û\x1D \n
\x1E µ\x1F íÓ‚i\x10 /
"""
b"-Hð╬ì┐>R╩*²Êvh>& "
b"""
âè\n
}\x18 :–àgCÏ,/î N
"""
b"t1\x00 <o\x1C 1óÁÂxI\x19 -U\x06 "
b"øÂ>Sb\x11 0ë_ŸúHãX+ô "
b"Ða<\x12 ǪùLŒt9Þ5ó\x7F ù "
b"¡»úH°Àz•CØ+\x08\x08\v\x0E Ô "
b"/\x1D [ˆ¿U\x13 26\x16 ©k0¹_¸ "
b"AëÔÍÒé~œc:ò[¤êú\t "
b"A#ì©N-c\x16 ▀─à)¡¢ûh "
b"Î\x02 uâ\x02 Îw\e a"ù´–.¿! "
b"[ïÓòûü$оž\x04\x1F ž!ê "
b"‚\x13 «Wrß.b \x1E «À*W{À "
b""þ¥ Ôâ\r §l>Žx\x07 “ÙÙ "
b".ÛE\e +M¿\t û{¦î¹v…– "
b"[\x11 óœ˜`-*¯¶‡ež¶r¨ "
b"à<ÞŦ(Ï╝M}0;4\f `µ "
b"çœ ë~Êáj¶#³![´JÄ "
b"¬Öõ¶(±·\x16 aw¦ÿâ/\x11 œ "
b"S¤è}6\u\x03 ÏÄ^ƒÇõ÷¾ "
b"â\x00 K5»\x10 €rS06G|òÄB "
b"""
\x13 =]üÞÔ\x0F Ïæ\t \n
Öf=&Ï
"""
b"┌Fw░´ìƒª4«ýx\x12 J5▀ "
b"\x0E\x06 ˆ\x1E\x1C\x17 ¾”ÛT¼lFk1Ð "
b"╩Ó┤3Ò\x19 ÙiTôÉó■Nܶ "
b"gGm\x14 Ø\x13 ×ûŠÒe”jIC\x0E "
b"$y™E·ÏºÂ|Å‹¾ƒþæ¯ "
b"ø2`█0¯ã½ìs┴x0Zs┼ "
b"–u·,fSþÂ4Ú……q”½& "
b"Ú\x13 ú═^r^+Üùl¨\f ┘ÍØ "
b"ï.ÝÕ\x04 ù^.¦È>ã—-Z5 "
b"ÀM_"|í\x7F ¹`ìÝ┬h\x1A Ü┴ "
b"µ~¦ŠÔD§ã§ìI Ü\êD "
b"J[,ê\x17 fæ|¥\x14 8¬¯§YÄ "
b"9\x10 G\x10 ¤,\x05\e O´ÞMº>so "
b"\x06 ¢E'6╚Ûpc\x00 ÎQü╣û╦ "
b"Å„/-\x14 Ø\x08 $é\x08 JÓ?*$ "
b"6p£\x18\x1A ˜ÝÜÝ&,ÃÈ^hª "
b"\x00 ¦\v jŲhg\e (ÙîØ|_\x13 "
b" Zþô¾™DU¿\x07 q4EF£r "
b"ü*Ñ2¸\x14\x12 ì\x06 ÖØ5uþº× "
b"äC0Ó2Ò&<]k\x07\x03 ù\t sÅ "
b"Ú8╬Dm\yùMÅ╚ úgBì "
b"¹~ÁpØ<[X<~ö)p©\x19 Î "
b"Wøo$Á`]?ô$éÊò¦ÿÉ "
b"*k\x16 [\x1C 3m|i_´4ú–KÅ "
b"A?–N„Š>o—^…S4TTq "
b"╩_ýqq1O├\x16 SƒÉ\f ═\x08 ╚ "
b"ýå÷?Œ‰Rƒ§ñ³ú¯,1ó "
b"(¼êÛ\t aêV\x05 ü#Imêda "
b"«&óæúGrŒhk\x1C\x1A 0™Ÿ¨ "
b"&\x11 Ïæ\x0F q°ë²~¥Ç²iÏ\x02 "
b"1øa<Ó┌v\e Ôü¢øMÖ²K "
b"\x07 ÔH\x0E ɽ\x14 KƒdaK¿\x05 °ë "
b"+P*šü¡~{^zm\x1D [gvê "
b"a\x07 ¤B\x10 ‡°»Æ‡¨ÁµA,X "
b"øþú\v\x1D µ,<HÁLE‹\x04 ¼\x1F "
b"V\t j”®Ü®ñˆŒ\x12 ”F}Ú# "
b"yT/MΕØ\x08\x14 Ý3\x0E ¼Ê{ç "
b"""
ëöp\n
Æ\x10\x0E Œ\x19 ø‡MD\x11 šD
"""
b"\x06 á7åC\x18 #Ư\Á󼂯x "
b"L¦YúnIòX‗à¾ØN¾1o "
b"ä0GMF\x12\x15 FFÕofö*E* "
b"\x02 õC<_ª_eÝá)Å;‗\x1C B "
b"¨PGü\x1E o»J&7\x03 ,Î\x15 )– "
b"h}\x02 4bôULŠQkR{|\x1C ¦ "
b"\x03 ıï\x14 ,┐G═bì\v {k╗GÉ "
b"#ª®¹ÉÀø)\f\x08 E—\r ÆOr "
b"W\x05 w)²¤7\x18 \r oÉÎS¢çµ "
b"´º=\x03 ;NîWywu5þZ\[ "
b"ßÞ^•¾‹æ¬Â-`Àõ„\x06 K "
b"µ\x03 ░ÊÂ\r G¸NZ├±ô ØÀ "
b"1ÜÓ{JžÎ\x7F\v\v –ë!á\v \n "
b"äDÉþÛg\x18 :R²ÂƵe›Ý "
b"\x19 ª7.Ë_°y\v uNµ˜\x07 ø "
b"\x04\x18 'ù\t\x1E Â& :—ЀË×\x1D "
b"ÒtܤË>œ\f LåÀÑ•ô2 "
b"\x12 îƒÄ@£1Mì4È ö'¥\x1E "
b"XÌ?¯'~;ñ\x0E nºâŠ\x06 ™Ò "
b"tÍ«R*–zÒ¼ò*•V[ÉK "
b"ógåx=>Üû@^ü║ê;\x7F [ "
b"H”ïÙÚ"\x16 Ò¿ühÁäì”c "
b"Í\x1A 6\x14 ÐzZ-AàȪÉ(U« "
b"""
F\x13 =ˆ\n
_C-+´¤§¼MÇÕ
"""
b"H\x14 ŒÉèÓ¶P¦©G&írâ‚ "
b"˜U¤Q”0\x0F ÊéQ"³øEâY "
b"Å£ëyµ\x13\v Æ]╗\┬┘·í "
b"©\x1C ÅKÜà|E1¾¢‘,bý4 "
b"@ªiWƨåË©³\e úöºÐý "
b"ÿIg<â[ñÉd[÷\x07\t #+Å "
b"\x05 ta█\x17 Ñ\x1D\x15 Ã\x07 Ø \x0E bsÙ "
b"ÿ„7öTâÙpÒJ¨).¶Ÿ' "
b"b\x1E À·KÁùÈ\x12 âf\x0E àz" "
b"?jƒ»uØ\x03 »®èT╝ö¥©T "
b"nH“}\x18 (ËrÄóîáÂ\x0F\x11 "
b"ƒæì^î"╗Ø\x03 c<!\x7F À2( "
b"dkôKä*mF¤¨ò@\x1D šLÒ "
b"╝ h¶~Nëå³OêÉÈ<¯P "
b"»*ñÄ>½t7G)hácc•¦ "
b"""
4î\x7F Éz$\n
JÏ\x01 Âq?t\x17\x13
"""
b"Ò▓¼Ý£X(ìévÃ═r`¾q "
b"\x08 ┴\t *Ü.┐┬g=Zu\x7F Å÷\x1C "
b"¢\x00 GwÓÙZahùI þ\x11 —Q "
b"®jìÃ}’|jF=\x07\x0E 7Ì)X "
b"Æ;R›Ž®„,¼,‹°ËP– "
b"\x02 Ž‘üz\x18 7\x04 ¡GÏ’å\x1C Ê< "
b"Y\r ìMÙôÃÖ\î╗)y¯K "
b"ͽÇPäøŠ˜#&Â\x16 k'UI "
b"=)zèú¤7ðL?84€€mÈ "
b"è£ZG÷¯îÓ†-ˆ„ÌëÆi "
b"ÅüÏOb„ë^Ìç¦Ø\x18 IË_ "
b"yGEáD\x7F ·×E*\x02 æRN\ "
b"\x19 )¥\r Ÿ\x19 ô”Ê\x06\x1D /¨+\x05 ® "
b"ßÕ•\x12 ·Æ·\x1E -pÏ\x08\x16 ‰ãŒ "
b"Öí–kïúã#Õ[I`\x1C ²Æ\n "
b"šö$¬[íà°Ê\t 6§86 > "
b"\x04 'Æ`k Óã\x1E ø\x03\x10\x02 ñU• "
b"TŒ£Û¤ŸóÍ^\v û¨»Òÿë "
b"áã\x04 ÑT×┘└¦¦ëÓxá╠ì "
b"íÆ7D^HT╝¶ÀØ\x1F ╩‗.ç "
b">1vdólC\x00 ÃâñZŠW3 "
b"\x1F ãóp‘Žƒ\x08 ,\x04 8Dj\x00 [Ç "
b"EœÚMª½âÚ÷´I6΢@š "
b"\x13 ÁmúG;\x16 µÏZ\f Ôhfÿn "
b"b•#ä:æ«’pº~\x18 @„ê\x0F "
b"H5S;ÛË+Þ=<“‹ó¼OŠ "
b"+#└Ö^┼4ì\x1F\x19 ┼-$µ┼ê "
b"]ødµ¨BúO›'ZOt(!; "
b"¬·\x04 ù¯ÕBN$)¸ë\x12 ¡0Ÿ "
b"gdÀÖ╩¬Á▓a<a░ɤÝ0 "
b"M|©U\x1A òËÇ߉Ù\x07 )-HÈ "
b"²\r \x15 ¦\x01 ˆ…KÖç¢Ôò× "
b"èM\x07 `þ†oxõLÖÝÑ”—Ï "
b"²┼ÌØðËÌ\x08 ±li¤óÓX¾ "
b")$\x00 þØó\x17 y┤!Ë«_Ò┼▀ "
b"\x15 š3S/L?6¬8Ô·ž3N; "
b"[&á\r 0ðæèDHw\x08 øß|¡ "
b"JX}#ɾ·rë»╚ói"° "
b"╣É%Á®Þ¨âjÌ\x07 ╠I\x13\x0E ╣ "
]
SELECT
`meta_catalog_id` . `id`
FROM
`meta_catalog_id`
WHERE
`meta_catalog_id` . `id` IN (
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
?
)
Copy
SELECT `meta_catalog_id` . `id` FROM `meta_catalog_id` WHERE `meta_catalog_id` . `id` IN (0xA5294EF11EB43B6C7A29FB7BAFBC951B , 0xD6326B687B0FA213213E2F22D3277A0D , 0xB781E9980B67181CCC3FD9E424F7B5B0 , 0x616C18EBB7C6DC3D7F81CE8C137EDC51 , 0xD5293C90CCFEBD1E150C6380E48FE001 , 0xBD5EC2169C73FE09DC19BAB093D004BA , 0x9EF8AE08599517DC814422FA7AF490B0 , 0x01A6BA22C7113AFAB635607D442CAD85 , 0x460D506A92A073B8ABC24FA7D4EB9F5F , 0x3F164B0F1A34F1B389C5475BF1AD0A4F , 0xB20F77CE4A16AF317308CCDC53E923F7 , 0x48A8324EDC8874FFDA88C8FEA057B3FB , 0xD284139721A4DAA892A9957F9B3D08E0 , 0x73A18EE956E6EC574D0C1DE95F3387A1 , 0xC3E42F7B950EE54F057B739355DFA93C , 0x7663056013B15AC7824215BFA36507A7 , 0xE0F94A817C67833A2422642D0A55BA2C , 0x4D16994CB59BB9C15AF5F0195D4496C0 , 0xFDC0790F7AE5D18FE8E39B1EAE834758 , 0x6402CEF5844B92C8DFE0E9F633226F6B , 0xC8D99C1140A6F45EA1DC9A35F1A88791 , 0xE717AD1FDB7D8097C59B5B6038C46C35 , 0x1F9081096EFB2895F1EF22689C081355 , 0xFDA69730C41314099A92DC1B66B3BEF0 , 0x6EE2F2B76B5BAE29BF63FBCA30D3FD6D , 0x69EF63A3570D635FD67C6BAD3B10487D , 0x87D1359749E78F2AE59AD47C46EB270D , 0x743977921295FA946EE632E485E0E2CA , 0x7DC31A160ED5D328A9F595549618D6A3 , 0x9FE21CA5A4FD8421326C81ECA39FC5E7 , 0x1922C79FD8C1F6ED8CBE1610138579D9 , 0x3B59D406663C6C04E494DFE68E9BF64B , 0x661F1D583888744D1B99A25B3434EEC5 , 0x4895C02595F8B97B143B36A3686DC36C , 0x81E33032BFC3CBE1F93FE1B2D0D26D75 , 0x593ED1BC6F2BE976EB911EF053B5B5DF , 0x55B708E123E1C60AB9BB0106EF07B64E , 0x42F1E531589848AEDDF0CBFA37B94A40 , 0xA6EB35B96383F00E90D9DD9C0D923BCB , 0x84E41F08F4789AAFABAB6B616D9E2726 , 0x5350DD473F9ECAD99D5471F9A80068CC , 0xF859BC2494B93EC5A46DDD14C8745B65 , 0x612BE9D4F1B9492FCE6DD68884B22C87 , 0xB42A4F9EDE89800146B37114AF7B5AF0 , 0x43162C168C0D0548686B0464A97CEB12 , 0xA54BB67F7546729F2286509F50DA1C97 , 0xE0358CDFDE5E6A38F92E3A5F53BBF500 , 0x9F1440DDE37F24ED7B427CB8788B0F69 , 0xCDC88CFB563A5C89C8C4E2C84759044B , 0xA6EE5FF6AB01B514458065FAF959DC6C , 0x7A449E260741F7D2420C933A41E9E34D , 0x1D691A10DB1D0A1EB51FEDD38269102F , 0x2D48D0CE8DBF3E52CA2AFDD276683E26 , 0xE2E80A7D183A96E06743CF2C2FEE204E , 0x7431003C6F1C31F3C1C27849192D5506 , 0xF8C23E53621130EB5F9FFA48E3582BF4 , 0xD0613C12C7AAF94C8C7439DE35F37FF9 , 0xA1BBFA48B0C07A9543D82B08080B0ED4 , 0x2F1D5B88BF5513323616A96B30B95FB8 , 0x41EBD4CDD2E97E9C633AF25BA4EAFA09 , 0x41238DB84E2D6316DFC48529ADBD9668 , 0xCE0275E202CE771B6122F9B4962EBF21 , 0x5BEFD3F2FBFC24D0BEC29E041F9E21EA , 0x8213AB5772DF2E62201EABC02A577BC0 , 0x22FEA520D4E20DA76C3E8E780793D9D9 , 0x2EDB451B2B4DBF09FB7BA6EEB9768596 , 0x5B11F39C98602D2AAFB687659EB672A8 , 0x853CE88FDD28D8BC4D7D303B340C60E6 , 0xE79CA0EB7ECAE16AB623B3215BB44AC4 , 0xACD6F5B628B1B7166177A6FFE22F119C , 0x53A4E87D365C7503CFC45E83C7F5F7BE , 0xE2004B35BB108072533036477CF2C442 , 0x133D5D81E8E20FD891090A99663D26D8 , 0xDA4677B0EF8D9FA634AEEC78124A35DF , 0x0E06881E1C17BE94DB54BC6C466B31D0 , 0xCAE0B433E319EB69549390A2FE4E9AF4 , 0x67476D14D813D7FB8AD265946A49430E , 0x24799945B7CFBAC27CC58BBE83FEE6AF , 0x9B3260DB30EEC6AB8D73C178305A73C5 , 0x9675B72C6653FEC234DA85857194BD26 , 0xE913A3CD5E725E2B9A976CF90CD9D69D , 0xEF2EDDD504F95E2EA6C83EE3972D5A35 , 0xB74D5F227CA17FFB608DEDC2681A9AC1 , 0xB57EA68AD444A7E3A7EC4920DC5CEA44 , 0x4A5B2CEA1766E67CA51438ACAFA759C4 , 0x39104710A42C051B4FB4DE4DBA3E736F , 0x06BD452736C8EA706300D75181B996CB , 0xC5842F2D14D80824E9084AD33F2A2420 , 0x3670A3181A98DDDCDD262CC3C85E68AA , 0x00DD0B6A8FFD68671B28EB8C9D7C5F13 , 0x205AFEF4BE994455BF0771344546A372 , 0xFC2AD132B81412EC06D6D83575FEBAD7 , 0x844330E032E3263C5D6B07039709738F , 0xE938CE446D5C79974D8FC8FFA367428D , 0xB97EC170D83C5B583C7EF62970A919CE , 0x57F86F24C1605D3FF424E9CAF2A6FFC9 , 0x2A6B165B1C336D7C695FB434FA964BC5 , 0x413F964E848A3E6F975E855334545471 , 0xCA5FEC7171314FC316539F900CCD08C8 , 0xFDE5F73F8C895283A7F1B3FAAF2C31F3 , 0x28BCEADB0961EA5605FC23496DEA6461 , 0xAB26F3E6FA47728C686B1C1A30999FA8 , 0x2611CFE60F71B0EBB27EA5C7B269CF02 , 0x319B613CE0DA761BE281BD9B4D99FD4B , 0x07E2480E90AB144B9F64614BA805F889 , 0x2B502A9AFCA17E7B5E7A6D1D5B6776EA , 0x6107A4421087B0BBC687A8C1B5412C58 , 0xF8FEFA0B1DB52C3C48C14C458B04BC1F , 0x56096A94AEDCAEF1888C1294467DDA23 , 0x79542F4DCE95D80814DD330EBCCA7BE7 , 0xEBF6700AC6100E8C19F8874D44119A44 , 0x06A0378643182392EE5CB5EAA7809D78 , 0x4CDD59A36E499558F285F39D4EF3316F , 0xE430474D4612154646D56F66F62A452A , 0x02E4433C5FA65F65EDA0298F3BF21C42 , 0xA85047FC1E6FBB4A2637032CCE152996 , 0x687D023462F4554C8A516B527B7C1CA6 , 0x03D58B142CBF47CD628D0B7B6BBB4790 , 0x23AAAEB9C9C0F8290C0845970DC64F72 , 0x57057729FDCF37180D6F90D753BD87E6 , 0xB4BA3D033B4EEE5779777535FE5A5C5B , 0xDFDE5E95BE8BE6ACC22D60C0F584064B , 0xE603B0D2B60D47F74E5AC3F193209DB7 , 0x31DCD37B4A9ECE7F0B0B96EB21E10B0A , 0xE444C9FEDB67183A52B2C2C6B5659BDD , 0x19AA372ECB5FB0790B20754EB59807F8 , 0x041827F9091EC226203A97D080CBD71D , 0xD274DCA4CB3EAD9C0C4CE5C0D195F432 , 0x128C9F8E409C314D8D34D4FF9427BE1E , 0x58CC3FAF277E3BF10E6EBAE28A0699D2 , 0x74CDAB522A967AD2BCF22A95565BC94B , 0xA26786783D3E9A96405E81BA883B7F5B , 0x4894EFD9DA2216D2BFFC68C1E4EC9463 , 0xCD1A3614D07A5A2D41E0C8AAC92855AB , 0x46133D880A5F432D2BB4A4A7BC4DC7D5 , 0x48148CC9E8D3B650A6A94726ED72E282 , 0x9855A45194300FCAE95122B3F845E259 , 0x8F9C8979E6130BF0925DBB5CC2D9FAA1 , 0xA91CC54BDCE07C4531BEA2912C62FD34 , 0x40AA6957C6A8E5CBA9B31BFAF6BAD0FD , 0x9849673C835BA490645BF60709232B8F , 0x057461DB17A51D15C7079D200E6273EB , 0xFF8437F654E2D970D24AA8292EB69F27 , 0x621EC0B74BC1F9C812E2660EA0E07A22 , 0x3F6A9FAF759D03AFA98A54BC94BEB854 , 0x6E48C2937D1828CB72C4F3EEE1C20F11 , 0x9F918D5E8C22BB9D03633C217FB73228 , 0x646BF44BE42A6D46A4A8F2401D9A4CD2 , 0xBC2068F47E4E8986FC4F8890D43CEE50 , 0xBB2AF1C43EBD7437472968E1636395A6 , 0x34EE7FC97A240A4ACF01C2713F741713 , 0xE3B2ACED9C58288D8276C7CD7260F371 , 0x08C1092A9A2EBFC2673D5A757F8FF61C , 0xA2004777D3D95A6168F949A0FE119751 , 0xAE6AECC37D927C6A463D070E37CC2958 , 0xC63B529B8EAE842CC2BC2C8BB0CB5096 , 0x028E91FC7A183704A147CF92E51CCA3C , 0x590D8D4DEBC7EFC7995C8CBB2979EE4B , 0xCDBDC750E4F88A982326C2166B275549 , 0x3D297AE8FAA437F04C3F383480806DC8 , 0xE8A35A47F7AFEED3862D8884CCEBC669 , 0xC5FCCF4F6284EB5ECCE7A6D81849CB5F , 0x794745E1447FC2B7D7452A02E6524E5C , 0x1929A50D9F19F494CA061D2FA82B05AE , 0xDFD59512B7C6B71E2D70CF081689E38C , 0xD6ED966BEFFAE323D55B49601CB2C60A , 0x9AF624AC5BEDE0B0CA0936A73836A03E , 0x0427C6606B20D3E31EF8031002F15595 , 0x548CA3DBA49FF3CD5E0BFBA8BBD2FFEB , 0xA0C604A5549ED9C0DDDD89E078A0CC8D , 0xA19237445E4854BCF4B79D1FCAF22E87 , 0x3E317664F36CAD4300C3E2F15A8A5733 , 0x1FE3F370918E83082C0438446A005BC7 , 0x459CDA4DAABDE2DAF7B44936CEA2409A , 0x13C16DFA473B16B5CF5A0CD46866FF6E , 0x629523E43AE6AB9270BA7E184084EA0F , 0x4835533BDBCB2BDE3D3C938BF3BC4F8A , 0x2B23C0995EC5348D1F19C52D24E6C588 , 0x5DF864B5A842FA4F9B275A4F7428213B , 0xACB704F9AFD5424E2429B8EB12A1309F , 0x6764B799CAAAB5B2613C61B090CFED30 , 0x4D7CA9551AF2CBC7DF89D907292D48C8 , 0xB20D15A601AD88AD854BD6E7A2D4F2D7 , 0xE84D0760FE866F78F54CD6DDD19497CF , 0xFDC5DE9DD0D3DE08F16C69CFA2E058F3 , 0x292400E79DA21779B421D3AE5FE3C5DF , 0x159A33532F4C3F36AC38D4B79E334E3B , 0x5B26E10D30F0E6E844487708F8DF7CA1 , 0x4A587D2390F3FA7289AFC8A2F06922F8 , 0xB99025B5A9E8F9836ADE07CC49130EB9 );
Copy
2.67 ms (4.86%)
4
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )) AND (sales_channel_id = ? )
Parameters :
[
b"íÆ7D^HT╝¶ÀØ\x1F ╩‗.ç "
b">1vdólC\x00 ÃâñZŠW3 "
b"\x1F ãóp‘Žƒ\x08 ,\x04 8Dj\x00 [Ç "
b"EœÚMª½âÚ÷´I6΢@š "
b"\x13 ÁmúG;\x16 µÏZ\f Ôhfÿn "
b"b•#ä:æ«’pº~\x18 @„ê\x0F "
b"H5S;ÛË+Þ=<“‹ó¼OŠ "
b"+#└Ö^┼4ì\x1F\x19 ┼-$µ┼ê "
b"]ødµ¨BúO›'ZOt(!; "
b"¬·\x04 ù¯ÕBN$)¸ë\x12 ¡0Ÿ "
b"gdÀÖ╩¬Á▓a<a░ɤÝ0 "
b"M|©U\x1A òËÇ߉Ù\x07 )-HÈ "
b"²\r \x15 ¦\x01 ˆ…KÖç¢Ôò× "
b"èM\x07 `þ†oxõLÖÝÑ”—Ï "
b"²┼ÌØðËÌ\x08 ±li¤óÓX¾ "
b")$\x00 þØó\x17 y┤!Ë«_Ò┼▀ "
b"\x15 š3S/L?6¬8Ô·ž3N; "
b"[&á\r 0ðæèDHw\x08 øß|¡ "
b"JX}#ɾ·rë»╚ói"° "
b"╣É%Á®Þ¨âjÌ\x07 ╠I\x13\x0E ╣ "
b"\x01 ɪJ£&pò▓Ãè ÌôÜÓ "
]
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (0xA19237445E4854BCF4B79D1FCAF22E87 , 0x3E317664F36CAD4300C3E2F15A8A5733 , 0x1FE3F370918E83082C0438446A005BC7 , 0x459CDA4DAABDE2DAF7B44936CEA2409A , 0x13C16DFA473B16B5CF5A0CD46866FF6E , 0x629523E43AE6AB9270BA7E184084EA0F , 0x4835533BDBCB2BDE3D3C938BF3BC4F8A , 0x2B23C0995EC5348D1F19C52D24E6C588 , 0x5DF864B5A842FA4F9B275A4F7428213B , 0xACB704F9AFD5424E2429B8EB12A1309F , 0x6764B799CAAAB5B2613C61B090CFED30 , 0x4D7CA9551AF2CBC7DF89D907292D48C8 , 0xB20D15A601AD88AD854BD6E7A2D4F2D7 , 0xE84D0760FE866F78F54CD6DDD19497CF , 0xFDC5DE9DD0D3DE08F16C69CFA2E058F3 , 0x292400E79DA21779B421D3AE5FE3C5DF , 0x159A33532F4C3F36AC38D4B79E334E3B , 0x5B26E10D30F0E6E844487708F8DF7CA1 , 0x4A587D2390F3FA7289AFC8A2F06922F8 , 0xB99025B5A9E8F9836ADE07CC49130EB9 )) AND (sales_channel_id = 0x0190A64A9C267095B2C78AFFDE939AE0 );
Copy
1.73 ms (3.15%)
1
SELECT `product_sorting` . `id` as `product_sorting.id` , `product_sorting` . `locked` as `product_sorting.locked` , `product_sorting` . `url_key` as `product_sorting.key` , `product_sorting` . `priority` as `product_sorting.priority` , `product_sorting` . `active` as `product_sorting.active` , `product_sorting` . `fields` as `product_sorting.fields` , `product_sorting` . `created_at` as `product_sorting.createdAt` , `product_sorting` . `updated_at` as `product_sorting.updatedAt` , `product_sorting.translation.label` , `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation` . `product_sorting_id` , `product_sorting.translation` . `label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation` . `language_id` = ? ) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation` . `product_sorting_id` = `product_sorting` . `id` WHERE `product_sorting` . `id` IN (? , ? , ? , ? , ? , ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 ɪ\³üqsÖ╠[╬jÑdj "
b"\x01 ÉÑÐ* sþÿ├-î▓5w\n "
b"\x01 ÉÑÐ* sþÿ├-î▓áÚ\x10 "
b"\x01 ÉÑÐ* sþÿ├-î│v£\x07 "
b"\x01 ÉÑÐ* sþÿ├-î┤W\x10 ² "
b"\x01 ÉÑÐ* sþÿ├-îÁ\x1D ýy "
]
SELECT `product_sorting` . `id` as `product_sorting.id` , `product_sorting` . `locked` as `product_sorting.locked` , `product_sorting` . `url_key` as `product_sorting.key` , `product_sorting` . `priority` as `product_sorting.priority` , `product_sorting` . `active` as `product_sorting.active` , `product_sorting` . `fields` as `product_sorting.fields` , `product_sorting` . `created_at` as `product_sorting.createdAt` , `product_sorting` . `updated_at` as `product_sorting.updatedAt` , `product_sorting.translation.label` , `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation` . `product_sorting_id` , `product_sorting.translation` . `label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation` . `product_sorting_id` = `product_sorting` . `id` WHERE `product_sorting` . `id` IN (0x0190A65CFC81717399CC5BCE6AA5646A , 0x0190A5D12AFF73E798C32D8CB235770A , 0x0190A5D12AFF73E798C32D8CB2A0E910 , 0x0190A5D12AFF73E798C32D8CB3769C07 , 0x0190A5D12AFF73E798C32D8CB45710FD , 0x0190A5D12AFF73E798C32D8CB51DEC79 );
Copy
1.17 ms (2.13%)
1
SELECT `scop_platform_redirecter_redirect` . `id` FROM `scop_platform_redirecter_redirect` WHERE (`scop_platform_redirecter_redirect` . `sourceURL` IN (? , ? , ? , ? , ? , ? , ? ) AND `scop_platform_redirecter_redirect` . `enabled` = ? AND (`scop_platform_redirecter_redirect` . `salesChannelId` = ? OR `scop_platform_redirecter_redirect` . `salesChannelId` < = > ? )) LIMIT 1
Parameters :
[
"//author/Bauer,%20Karin "
"/author/Bauer,%20Karin "
"https://hauptbuchhandlung.staging.eurosoft.network/author/Bauer,%20Karin "
"https://hauptbuchhandlung.staging.eurosoft.network//author/Bauer,%20Karin "
"/author/Bauer,%20Karin "
"//author/Bauer,%20Karin "
"author/Bauer,%20Karin "
true
b"\x01 ‘J13£x"‰m\f p²ý;g "
null
]
SELECT `scop_platform_redirecter_redirect` . `id` FROM `scop_platform_redirecter_redirect` WHERE (`scop_platform_redirecter_redirect` . `sourceURL` IN ('//author/Bauer,%20Karin' , '/author/Bauer,%20Karin' , 'https://hauptbuchhandlung.staging.eurosoft.network/author/Bauer,%20Karin' , 'https://hauptbuchhandlung.staging.eurosoft.network//author/Bauer,%20Karin' , '/author/Bauer,%20Karin' , '//author/Bauer,%20Karin' , 'author/Bauer,%20Karin' ) AND `scop_platform_redirecter_redirect` . `enabled` = 1 AND (`scop_platform_redirecter_redirect` . `salesChannelId` = 0x01914A3133A37822896D0C70B2FD3B67 OR `scop_platform_redirecter_redirect` . `salesChannelId` < = > NULL )) LIMIT 1 ;
Copy
1.09 ms (1.98%)
1
SELECT `unit` . `id` as `unit.id` , `unit` . `created_at` as `unit.createdAt` , `unit` . `updated_at` as `unit.updatedAt` , `unit.translation.shortCode` , `unit.translation.shortCode` as `unit.shortCode` , `unit.translation.name` , `unit.translation.name` as `unit.name` , `unit.translation.customFields` , `unit.translation.customFields` as `unit.customFields` FROM `unit` LEFT JOIN (SELECT `unit.translation` . `unit_id` , `unit.translation` . `short_code` as `unit.translation.shortCode` , `unit.translation` . `name` as `unit.translation.name` , `unit.translation` . `custom_fields` as `unit.translation.customFields` FROM `unit_translation` `unit.translation` WHERE `unit.translation` . `language_id` = ? ) `unit.unit_translation` ON `unit.unit_translation` . `unit_id` = `unit` . `id`
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `unit` . `id` as `unit.id` , `unit` . `created_at` as `unit.createdAt` , `unit` . `updated_at` as `unit.updatedAt` , `unit.translation.shortCode` , `unit.translation.shortCode` as `unit.shortCode` , `unit.translation.name` , `unit.translation.name` as `unit.name` , `unit.translation.customFields` , `unit.translation.customFields` as `unit.customFields` FROM `unit` LEFT JOIN (SELECT `unit.translation` . `unit_id` , `unit.translation` . `short_code` as `unit.translation.shortCode` , `unit.translation` . `name` as `unit.translation.name` , `unit.translation` . `custom_fields` as `unit.translation.customFields` FROM `unit_translation` `unit.translation` WHERE `unit.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `unit.unit_translation` ON `unit.unit_translation` . `unit_id` = `unit` . `id` ;
Copy
1.02 ms (1.86%)
2
SELECT `delivery_time` . `id` as `delivery_time.id` , `delivery_time` . `min` as `delivery_time.min` , `delivery_time` . `max` as `delivery_time.max` , `delivery_time` . `unit` as `delivery_time.unit` , `delivery_time` . `created_at` as `delivery_time.createdAt` , `delivery_time` . `updated_at` as `delivery_time.updatedAt` , `delivery_time.translation.name` , `delivery_time.translation.name` as `delivery_time.name` , `delivery_time.translation.customFields` , `delivery_time.translation.customFields` as `delivery_time.customFields` FROM `delivery_time` LEFT JOIN (SELECT `delivery_time.translation` . `delivery_time_id` , `delivery_time.translation` . `name` as `delivery_time.translation.name` , `delivery_time.translation` . `custom_fields` as `delivery_time.translation.customFields` FROM `delivery_time_translation` `delivery_time.translation` WHERE `delivery_time.translation` . `language_id` = ? ) `delivery_time.delivery_time_translation` ON `delivery_time.delivery_time_translation` . `delivery_time_id` = `delivery_time` . `id` WHERE `delivery_time` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 ÉÑð║Ñqhô?6:■Ã,\x02 "
]
SELECT `delivery_time` . `id` as `delivery_time.id` , `delivery_time` . `min` as `delivery_time.min` , `delivery_time` . `max` as `delivery_time.max` , `delivery_time` . `unit` as `delivery_time.unit` , `delivery_time` . `created_at` as `delivery_time.createdAt` , `delivery_time` . `updated_at` as `delivery_time.updatedAt` , `delivery_time.translation.name` , `delivery_time.translation.name` as `delivery_time.name` , `delivery_time.translation.customFields` , `delivery_time.translation.customFields` as `delivery_time.customFields` FROM `delivery_time` LEFT JOIN (SELECT `delivery_time.translation` . `delivery_time_id` , `delivery_time.translation` . `name` as `delivery_time.translation.name` , `delivery_time.translation` . `custom_fields` as `delivery_time.translation.customFields` FROM `delivery_time_translation` `delivery_time.translation` WHERE `delivery_time.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `delivery_time.delivery_time_translation` ON `delivery_time.delivery_time_translation` . `delivery_time_id` = `delivery_time` . `id` WHERE `delivery_time` . `id` IN (0x0190A5D0BAA57168933F363AFEC72C02 );
Copy
0.87 ms (1.58%)
1
SELECT `property_group` . `id` as `property_group.id` , `property_group` . `display_type` as `property_group.displayType` , `property_group` . `sorting_type` as `property_group.sortingType` , `property_group` . `filterable` as `property_group.filterable` , `property_group` . `visible_on_product_detail_page` as `property_group.visibleOnProductDetailPage` , `property_group` . `created_at` as `property_group.createdAt` , `property_group` . `updated_at` as `property_group.updatedAt` , `property_group.translation.name` , `property_group.translation.name` as `property_group.name` , `property_group.translation.description` , `property_group.translation.description` as `property_group.description` , `property_group.translation.position` , `property_group.translation.position` as `property_group.position` , `property_group.translation.customFields` , `property_group.translation.customFields` as `property_group.customFields` FROM `property_group` LEFT JOIN (SELECT `property_group.translation` . `property_group_id` , `property_group.translation` . `name` as `property_group.translation.name` , `property_group.translation` . `description` as `property_group.translation.description` , `property_group.translation` . `position` as `property_group.translation.position` , `property_group.translation` . `custom_fields` as `property_group.translation.customFields` FROM `property_group_translation` `property_group.translation` WHERE `property_group.translation` . `language_id` = ? ) `property_group.property_group_translation` ON `property_group.property_group_translation` . `property_group_id` = `property_group` . `id` WHERE (`property_group` . `filterable` = ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
true
]
SELECT `property_group` . `id` as `property_group.id` , `property_group` . `display_type` as `property_group.displayType` , `property_group` . `sorting_type` as `property_group.sortingType` , `property_group` . `filterable` as `property_group.filterable` , `property_group` . `visible_on_product_detail_page` as `property_group.visibleOnProductDetailPage` , `property_group` . `created_at` as `property_group.createdAt` , `property_group` . `updated_at` as `property_group.updatedAt` , `property_group.translation.name` , `property_group.translation.name` as `property_group.name` , `property_group.translation.description` , `property_group.translation.description` as `property_group.description` , `property_group.translation.position` , `property_group.translation.position` as `property_group.position` , `property_group.translation.customFields` , `property_group.translation.customFields` as `property_group.customFields` FROM `property_group` LEFT JOIN (SELECT `property_group.translation` . `property_group_id` , `property_group.translation` . `name` as `property_group.translation.name` , `property_group.translation` . `description` as `property_group.translation.description` , `property_group.translation` . `position` as `property_group.translation.position` , `property_group.translation` . `custom_fields` as `property_group.translation.customFields` FROM `property_group_translation` `property_group.translation` WHERE `property_group.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `property_group.property_group_translation` ON `property_group.property_group_translation` . `property_group_id` = `property_group` . `id` WHERE (`property_group` . `filterable` = 1 );
Copy
0.85 ms (1.54%)
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 ˜8\x07 ³.su·M\x1F àë\x04 2‰ "
b"\x01 æj \x7F ÝqÈì\x11\x1D ±Mêw├ "
b"\x01 æk\x06 Óìr\x16 çB┴¹â9i "
b"\x01 ‘k\x07 õ>xý©g\x0F ó~\e ÿ« "
b"""
\x01 —Àï¿ýp\x0E ´ë%¬óf\n
õ
"""
b"\x01 ˜7ú\x1C cr²¦¸foB$\x16 é "
b"\x01 ÉÑð║zs:ïUo┬É¿³G "
b"\x01 ÉÑð║Ãsl┤Ãõµ:\x7F j7 "
b"\x01 ÉÑð°ßpQàÀ─¤C¬\x1E\t "
b"\x01 ‘™IY\x7F |ù•/ˆÓÉ’!‚ "
b"\x01 ÉÑð╗dsöå6àLhKƒ┘ "
]
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 (0x01983807B32E7375B74D1FE0EB043289 , 0x01916AFF7FED71D48D111DF14D8877C3 , 0x01916B06E08D72168742C1B6FB833969 , 0x01916B07F53E78FDA9670FF37E1BFFAB , 0x0197C0EFBFFD700EB4EB25ACF3660AF5 , 0x019837FA1C6372B2A6B8666F422416E9 , 0x0190A5D0BA7A733A8B556FC290A8FC47 , 0x0190A5D0BAC7736CB4C7E4E63A7F6A37 , 0x0190A5D0F8E1705185B7C4CF43AA1E09 , 0x01919949597F7CF9952F88D3C9922182 , 0x0190A5D0BB6473948636854C684B9FD9 );
Copy
0.84 ms (1.53%)
1
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.translation.name` , `category.translation.name` as `category.name` , `category.translation.breadcrumb` , `category.translation.breadcrumb` as `category.breadcrumb` , `category.translation.slotConfig` , `category.translation.slotConfig` as `category.slotConfig` , `category.translation.linkType` , `category.translation.linkType` as `category.linkType` , `category.translation.internalLink` , `category.translation.internalLink` as `category.internalLink` , `category.translation.externalLink` , `category.translation.externalLink` as `category.externalLink` , `category.translation.linkNewTab` , `category.translation.linkNewTab` as `category.linkNewTab` , `category.translation.description` , `category.translation.description` as `category.description` , `category.translation.metaTitle` , `category.translation.metaTitle` as `category.metaTitle` , `category.translation.metaDescription` , `category.translation.metaDescription` as `category.metaDescription` , `category.translation.keywords` , `category.translation.keywords` as `category.keywords` , `category.translation.customFields` , `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation` . `category_id` , `category.translation` . `category_version_id` , `category.translation` . `breadcrumb` as `category.translation.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation` . `slot_config` as `category.translation.slotConfig` , `category.translation` . `link_type` as `category.translation.linkType` , `category.translation` . `internal_link` as `category.translation.internalLink` , `category.translation` . `external_link` as `category.translation.externalLink` , `category.translation` . `link_new_tab` as `category.translation.linkNewTab` , `category.translation` . `description` as `category.translation.description` , `category.translation` . `meta_title` as `category.translation.metaTitle` , `category.translation` . `meta_description` as `category.translation.metaDescription` , `category.translation` . `keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation` . `language_id` = ? ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . `category_version_id` = `category` . `version_id` WHERE (`category` . `version_id` = ? ) AND (`category` . `id` IN (? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4% "
b"\x01 æÄC\¼t«ÉÍ_£Ûd╬y "
]
SELECT
`category` . `id` as `category.id` ,
`category` . `version_id` as `category.versionId` ,
`category` . `parent_id` as `category.parentId` ,
`category` . `parent_version_id` as `category.parentVersionId` ,
`category` . `after_category_id` as `category.afterCategoryId` ,
`category` . `after_category_version_id` as `category.afterCategoryVersionId` ,
`category` . `media_id` as `category.mediaId` ,
`category` . `display_nested_products` as `category.displayNestedProducts` ,
`category` . `auto_increment` as `category.autoIncrement` ,
`category` . `level` as `category.level` ,
`category` . `path` as `category.path` ,
`category` . `child_count` as `category.childCount` ,
`category` . `type` as `category.type` ,
`category` . `product_assignment_type` as `category.productAssignmentType` ,
`category` . `visible` as `category.visible` ,
`category` . `active` as `category.active` ,
`category` . `cms_page_id` as `category.cmsPageId` ,
`category` . `cms_page_version_id` as `category.cmsPageVersionId` ,
`category` . `product_stream_id` as `category.productStreamId` ,
`category` . `custom_entity_type_id` as `category.customEntityTypeId` ,
`category` . `created_at` as `category.createdAt` ,
`category` . `updated_at` as `category.updatedAt` ,
`category.translation.name` ,
`category.translation.name` as `category.name` ,
`category.translation.breadcrumb` ,
`category.translation.breadcrumb` as `category.breadcrumb` ,
`category.translation.slotConfig` ,
`category.translation.slotConfig` as `category.slotConfig` ,
`category.translation.linkType` ,
`category.translation.linkType` as `category.linkType` ,
`category.translation.internalLink` ,
`category.translation.internalLink` as `category.internalLink` ,
`category.translation.externalLink` ,
`category.translation.externalLink` as `category.externalLink` ,
`category.translation.linkNewTab` ,
`category.translation.linkNewTab` as `category.linkNewTab` ,
`category.translation.description` ,
`category.translation.description` as `category.description` ,
`category.translation.metaTitle` ,
`category.translation.metaTitle` as `category.metaTitle` ,
`category.translation.metaDescription` ,
`category.translation.metaDescription` as `category.metaDescription` ,
`category.translation.keywords` ,
`category.translation.keywords` as `category.keywords` ,
`category.translation.customFields` ,
`category.translation.customFields` as `category.customFields`
FROM
`category`
LEFT JOIN (
SELECT
`category.translation` . `category_id` ,
`category.translation` . `category_version_id` ,
`category.translation` . `breadcrumb` as `category.translation.breadcrumb` ,
`category.translation` . `name` as `category.translation.name` ,
`category.translation` . `custom_fields` as `category.translation.customFields` ,
`category.translation` . `slot_config` as `category.translation.slotConfig` ,
`category.translation` . `link_type` as `category.translation.linkType` ,
`category.translation` . `internal_link` as `category.translation.internalLink` ,
`category.translation` . `external_link` as `category.translation.externalLink` ,
`category.translation` . `link_new_tab` as `category.translation.linkNewTab` ,
`category.translation` . `description` as `category.translation.description` ,
`category.translation` . `meta_title` as `category.translation.metaTitle` ,
`category.translation` . `meta_description` as `category.translation.metaDescription` ,
`category.translation` . `keywords` as `category.translation.keywords`
FROM
`category_translation` `category.translation`
WHERE
`category.translation` . `language_id` = ?
) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id`
AND `category.category_translation` . `category_version_id` = `category` . `version_id`
WHERE
(`category` . `version_id` = ? )
AND (
`category` . `id` IN (? )
)
Copy
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.translation.name` , `category.translation.name` as `category.name` , `category.translation.breadcrumb` , `category.translation.breadcrumb` as `category.breadcrumb` , `category.translation.slotConfig` , `category.translation.slotConfig` as `category.slotConfig` , `category.translation.linkType` , `category.translation.linkType` as `category.linkType` , `category.translation.internalLink` , `category.translation.internalLink` as `category.internalLink` , `category.translation.externalLink` , `category.translation.externalLink` as `category.externalLink` , `category.translation.linkNewTab` , `category.translation.linkNewTab` as `category.linkNewTab` , `category.translation.description` , `category.translation.description` as `category.description` , `category.translation.metaTitle` , `category.translation.metaTitle` as `category.metaTitle` , `category.translation.metaDescription` , `category.translation.metaDescription` as `category.metaDescription` , `category.translation.keywords` , `category.translation.keywords` as `category.keywords` , `category.translation.customFields` , `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation` . `category_id` , `category.translation` . `category_version_id` , `category.translation` . `breadcrumb` as `category.translation.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation` . `slot_config` as `category.translation.slotConfig` , `category.translation` . `link_type` as `category.translation.linkType` , `category.translation` . `internal_link` as `category.translation.internalLink` , `category.translation` . `external_link` as `category.translation.externalLink` , `category.translation` . `link_new_tab` as `category.translation.linkNewTab` , `category.translation` . `description` as `category.translation.description` , `category.translation` . `meta_title` as `category.translation.metaTitle` , `category.translation` . `meta_description` as `category.translation.metaDescription` , `category.translation` . `keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `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` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (`category` . `id` IN (0x01918E435CAC74AE90D65F9CEA64CE79 ));
Copy
0.83 ms (1.51%)
2
SELECT `key` , `value` FROM `app_config`
SELECT `key` , `value` FROM `app_config` ;
Copy
0.83 ms (1.51%)
1
SELECT id , path_info pathInfo , is_canonical isCanonical , sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ? ) AND ((sales_channel_id = ? OR sales_channel_id IS NULL )) AND ((seo_path_info = ? OR seo_path_info = ? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 ‘J13£x"‰m\f p²ý;g "
"author/Bauer,%20Karin "
"author/Bauer,%20Karin/ "
]
SELECT id , path_info pathInfo , is_canonical isCanonical , sales_channel_id salesChannelId FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND ((sales_channel_id = 0x01914A3133A37822896D0C70B2FD3B67 OR sales_channel_id IS NULL )) AND ((seo_path_info = 'author/Bauer,%20Karin' OR seo_path_info = 'author/Bauer,%20Karin/' ));
Copy
0.79 ms (1.44%)
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 ;
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 ;
;
Copy
0.75 ms (1.36%)
4
"START TRANSACTION"
"START TRANSACTION" ;
Copy
0.73 ms (1.32%)
1
SELECT `country` . `id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country` . `id` = `country.salesChannels.mapping` . `country_id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping` . `sales_channel_id` = `country.salesChannels` . `id` WHERE (`country.salesChannels` . `id` = ? ) GROUP BY `country` . `id`
Parameters :
[
b"\x01 ‘J13£x"‰m\f p²ý;g "
]
SELECT `country` . `id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country` . `id` = `country.salesChannels.mapping` . `country_id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping` . `sales_channel_id` = `country.salesChannels` . `id` WHERE (`country.salesChannels` . `id` = 0x01914A3133A37822896D0C70B2FD3B67 ) GROUP BY `country` . `id` ;
Copy
0.64 ms (1.17%)
1
SELECT LOWER (HEX (`id` )) AS `id` FROM `moorl_magazine_article` WHERE (`updated_at` IS NULL OR (`show_from` > `updated_at` AND `show_from` < '2026-04-06T14:28:11+00:00' ) OR (`show_until` > `updated_at` AND `show_until` < '2026-04-06T14:28:11+00:00' )) AND `active` = '1' ;
SELECT LOWER (HEX (`id` )) AS `id` FROM `moorl_magazine_article` WHERE (`updated_at` IS NULL OR (`show_from` > `updated_at` AND `show_from` < '2026-04-06T14:28:11+00:00' ) OR (`show_until` > `updated_at` AND `show_until` < '2026-04-06T14:28:11+00:00' )) AND `active` = '1' ; ;
Copy
0.64 ms (1.16%)
1
SELECT `product_sorting` . `id` FROM `product_sorting` WHERE (`product_sorting` . `active` = ? ) ORDER BY `product_sorting` . `priority` DESC
SELECT `product_sorting` . `id` FROM `product_sorting` WHERE (`product_sorting` . `active` = 1 ) ORDER BY `product_sorting` . `priority` DESC ;
Copy
0.60 ms (1.10%)
1
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = ?
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = 'de-DE' ;
Copy
0.60 ms (1.09%)
1
SELECT `plugin` . `id` as `plugin.id` , `plugin` . `base_class` as `plugin.baseClass` , `plugin` . `name` as `plugin.name` , `plugin` . `composer_name` as `plugin.composerName` , `plugin` . `autoload` as `plugin.autoload` , `plugin` . `active` as `plugin.active` , `plugin` . `managed_by_composer` as `plugin.managedByComposer` , `plugin` . `path` as `plugin.path` , `plugin` . `author` as `plugin.author` , `plugin` . `copyright` as `plugin.copyright` , `plugin` . `license` as `plugin.license` , `plugin` . `version` as `plugin.version` , `plugin` . `upgrade_version` as `plugin.upgradeVersion` , `plugin` . `installed_at` as `plugin.installedAt` , `plugin` . `upgraded_at` as `plugin.upgradedAt` , `plugin` . `icon` as `plugin.iconRaw` , `plugin` . `created_at` as `plugin.createdAt` , `plugin` . `updated_at` as `plugin.updatedAt` , `plugin.translation.label` , `plugin.translation.label` as `plugin.label` , `plugin.translation.description` , `plugin.translation.description` as `plugin.description` , `plugin.translation.manufacturerLink` , `plugin.translation.manufacturerLink` as `plugin.manufacturerLink` , `plugin.translation.supportLink` , `plugin.translation.supportLink` as `plugin.supportLink` , `plugin.translation.customFields` , `plugin.translation.customFields` as `plugin.customFields` FROM `plugin` LEFT JOIN (SELECT `plugin.translation` . `plugin_id` , `plugin.translation` . `label` as `plugin.translation.label` , `plugin.translation` . `description` as `plugin.translation.description` , `plugin.translation` . `manufacturer_link` as `plugin.translation.manufacturerLink` , `plugin.translation` . `support_link` as `plugin.translation.supportLink` , `plugin.translation` . `custom_fields` as `plugin.translation.customFields` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation` . `language_id` = ? ) `plugin.plugin_translation` ON `plugin.plugin_translation` . `plugin_id` = `plugin` . `id` WHERE (`plugin` . `name` = ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
"esMetaCatalog6 "
]
SELECT `plugin` . `id` as `plugin.id` , `plugin` . `base_class` as `plugin.baseClass` , `plugin` . `name` as `plugin.name` , `plugin` . `composer_name` as `plugin.composerName` , `plugin` . `autoload` as `plugin.autoload` , `plugin` . `active` as `plugin.active` , `plugin` . `managed_by_composer` as `plugin.managedByComposer` , `plugin` . `path` as `plugin.path` , `plugin` . `author` as `plugin.author` , `plugin` . `copyright` as `plugin.copyright` , `plugin` . `license` as `plugin.license` , `plugin` . `version` as `plugin.version` , `plugin` . `upgrade_version` as `plugin.upgradeVersion` , `plugin` . `installed_at` as `plugin.installedAt` , `plugin` . `upgraded_at` as `plugin.upgradedAt` , `plugin` . `icon` as `plugin.iconRaw` , `plugin` . `created_at` as `plugin.createdAt` , `plugin` . `updated_at` as `plugin.updatedAt` , `plugin.translation.label` , `plugin.translation.label` as `plugin.label` , `plugin.translation.description` , `plugin.translation.description` as `plugin.description` , `plugin.translation.manufacturerLink` , `plugin.translation.manufacturerLink` as `plugin.manufacturerLink` , `plugin.translation.supportLink` , `plugin.translation.supportLink` as `plugin.supportLink` , `plugin.translation.customFields` , `plugin.translation.customFields` as `plugin.customFields` FROM `plugin` LEFT JOIN (SELECT `plugin.translation` . `plugin_id` , `plugin.translation` . `label` as `plugin.translation.label` , `plugin.translation` . `description` as `plugin.translation.description` , `plugin.translation` . `manufacturer_link` as `plugin.translation.manufacturerLink` , `plugin.translation` . `support_link` as `plugin.translation.supportLink` , `plugin.translation` . `custom_fields` as `plugin.translation.customFields` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `plugin.plugin_translation` ON `plugin.plugin_translation` . `plugin_id` = `plugin` . `id` WHERE (`plugin` . `name` = 'esMetaCatalog6' );
Copy
0.59 ms (1.08%)
4
"COMMIT"
0.59 ms (1.07%)
1
SELECT `property_group` . `id` as `property_group.id` , `property_group` . `display_type` as `property_group.displayType` , `property_group` . `sorting_type` as `property_group.sortingType` , `property_group` . `filterable` as `property_group.filterable` , `property_group` . `visible_on_product_detail_page` as `property_group.visibleOnProductDetailPage` , `property_group` . `created_at` as `property_group.createdAt` , `property_group` . `updated_at` as `property_group.updatedAt` , `property_group.translation.name` , `property_group.translation.name` as `property_group.name` , `property_group.translation.description` , `property_group.translation.description` as `property_group.description` , `property_group.translation.position` , `property_group.translation.position` as `property_group.position` , `property_group.translation.customFields` , `property_group.translation.customFields` as `property_group.customFields` FROM `property_group` LEFT JOIN (SELECT `property_group.translation` . `property_group_id` , `property_group.translation` . `name` as `property_group.translation.name` , `property_group.translation` . `description` as `property_group.translation.description` , `property_group.translation` . `position` as `property_group.translation.position` , `property_group.translation` . `custom_fields` as `property_group.translation.customFields` FROM `property_group_translation` `property_group.translation` WHERE `property_group.translation` . `language_id` = ? ) `property_group.property_group_translation` ON `property_group.property_group_translation` . `property_group_id` = `property_group` . `id`
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `property_group` . `id` as `property_group.id` , `property_group` . `display_type` as `property_group.displayType` , `property_group` . `sorting_type` as `property_group.sortingType` , `property_group` . `filterable` as `property_group.filterable` , `property_group` . `visible_on_product_detail_page` as `property_group.visibleOnProductDetailPage` , `property_group` . `created_at` as `property_group.createdAt` , `property_group` . `updated_at` as `property_group.updatedAt` , `property_group.translation.name` , `property_group.translation.name` as `property_group.name` , `property_group.translation.description` , `property_group.translation.description` as `property_group.description` , `property_group.translation.position` , `property_group.translation.position` as `property_group.position` , `property_group.translation.customFields` , `property_group.translation.customFields` as `property_group.customFields` FROM `property_group` LEFT JOIN (SELECT `property_group.translation` . `property_group_id` , `property_group.translation` . `name` as `property_group.translation.name` , `property_group.translation` . `description` as `property_group.translation.description` , `property_group.translation` . `position` as `property_group.translation.position` , `property_group.translation` . `custom_fields` as `property_group.translation.customFields` FROM `property_group_translation` `property_group.translation` WHERE `property_group.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `property_group.property_group_translation` ON `property_group.property_group_translation` . `property_group_id` = `property_group` . `id` ;
Copy
0.56 ms (1.03%)
1
SELECT `country` . `id` as `country.id` , `country` . `iso` as `country.iso` , `country` . `position` as `country.position` , `country` . `active` as `country.active` , `country` . `shipping_available` as `country.shippingAvailable` , `country` . `iso3` as `country.iso3` , `country` . `display_state_in_registration` as `country.displayStateInRegistration` , `country` . `force_state_in_registration` as `country.forceStateInRegistration` , `country` . `check_vat_id_pattern` as `country.checkVatIdPattern` , `country` . `vat_id_required` as `country.vatIdRequired` , `country` . `vat_id_pattern` as `country.vatIdPattern` , `country` . `customer_tax` as `country.customerTax` , `country` . `company_tax` as `country.companyTax` , `country` . `postal_code_required` as `country.postalCodeRequired` , `country` . `check_postal_code_pattern` as `country.checkPostalCodePattern` , `country` . `check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern` , `country` . `advanced_postal_code_pattern` as `country.advancedPostalCodePattern` , `country` . `default_postal_code_pattern` as `country.defaultPostalCodePattern` , `country` . `is_eu` as `country.isEu` , `country` . `created_at` as `country.createdAt` , `country` . `updated_at` as `country.updatedAt` , `country.translation.name` , `country.translation.name` as `country.name` , `country.translation.addressFormat` , `country.translation.addressFormat` as `country.addressFormat` , `country.translation.customFields` , `country.translation.customFields` as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation` . `country_id` , `country.translation` . `name` as `country.translation.name` , `country.translation` . `custom_fields` as `country.translation.customFields` , `country.translation` . `address_format` as `country.translation.addressFormat` FROM `country_translation` `country.translation` WHERE `country.translation` . `language_id` = ? ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` WHERE `country` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 ÉÑð╣ms\x03 ┐5=Ë\x03 Õ╣' "
]
SELECT `country` . `id` as `country.id` , `country` . `iso` as `country.iso` , `country` . `position` as `country.position` , `country` . `active` as `country.active` , `country` . `shipping_available` as `country.shippingAvailable` , `country` . `iso3` as `country.iso3` , `country` . `display_state_in_registration` as `country.displayStateInRegistration` , `country` . `force_state_in_registration` as `country.forceStateInRegistration` , `country` . `check_vat_id_pattern` as `country.checkVatIdPattern` , `country` . `vat_id_required` as `country.vatIdRequired` , `country` . `vat_id_pattern` as `country.vatIdPattern` , `country` . `customer_tax` as `country.customerTax` , `country` . `company_tax` as `country.companyTax` , `country` . `postal_code_required` as `country.postalCodeRequired` , `country` . `check_postal_code_pattern` as `country.checkPostalCodePattern` , `country` . `check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern` , `country` . `advanced_postal_code_pattern` as `country.advancedPostalCodePattern` , `country` . `default_postal_code_pattern` as `country.defaultPostalCodePattern` , `country` . `is_eu` as `country.isEu` , `country` . `created_at` as `country.createdAt` , `country` . `updated_at` as `country.updatedAt` , `country.translation.name` , `country.translation.name` as `country.name` , `country.translation.addressFormat` , `country.translation.addressFormat` as `country.addressFormat` , `country.translation.customFields` , `country.translation.customFields` as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation` . `country_id` , `country.translation` . `name` as `country.translation.name` , `country.translation` . `custom_fields` as `country.translation.customFields` , `country.translation` . `address_format` as `country.translation.addressFormat` FROM `country_translation` `country.translation` WHERE `country.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` WHERE `country` . `id` IN (0x0190A5D0B96D7303BF353DD303E5B927 );
Copy
0.53 ms (0.96%)
1
SELECT `country` . `id` as `country.id` , `country` . `iso` as `country.iso` , `country` . `position` as `country.position` , `country` . `active` as `country.active` , `country` . `shipping_available` as `country.shippingAvailable` , `country` . `iso3` as `country.iso3` , `country` . `display_state_in_registration` as `country.displayStateInRegistration` , `country` . `force_state_in_registration` as `country.forceStateInRegistration` , `country` . `check_vat_id_pattern` as `country.checkVatIdPattern` , `country` . `vat_id_required` as `country.vatIdRequired` , `country` . `vat_id_pattern` as `country.vatIdPattern` , `country` . `customer_tax` as `country.customerTax` , `country` . `company_tax` as `country.companyTax` , `country` . `postal_code_required` as `country.postalCodeRequired` , `country` . `check_postal_code_pattern` as `country.checkPostalCodePattern` , `country` . `check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern` , `country` . `advanced_postal_code_pattern` as `country.advancedPostalCodePattern` , `country` . `default_postal_code_pattern` as `country.defaultPostalCodePattern` , `country` . `is_eu` as `country.isEu` , `country` . `created_at` as `country.createdAt` , `country` . `updated_at` as `country.updatedAt` , (SELECT GROUP_CONCAT (HEX (`country.salesChannels.mapping` . `sales_channel_id` ) SEPARATOR '||' )
FROM `sales_channel_country` `country.salesChannels.mapping`
WHERE `country.salesChannels.mapping` . `country_id` = `country` . `id` ) as `country.salesChannels.id_mapping` , `country.translation.name` , `country.translation.name` as `country.name` , `country.translation.addressFormat` , `country.translation.addressFormat` as `country.addressFormat` , `country.translation.customFields` , `country.translation.customFields` as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation` . `country_id` , `country.translation` . `name` as `country.translation.name` , `country.translation` . `custom_fields` as `country.translation.customFields` , `country.translation` . `address_format` as `country.translation.addressFormat` FROM `country_translation` `country.translation` WHERE `country.translation` . `language_id` = ? ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` WHERE `country` . `id` IN (? , ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 ÉÑð╣ms\x03 ┐5=Ë\x03 Õ╣' "
b"\x01 ÉÑð║\x1C q‗¡b\x1C ,h┬ù{ "
]
SELECT `country` . `id` as `country.id` , `country` . `iso` as `country.iso` , `country` . `position` as `country.position` , `country` . `active` as `country.active` , `country` . `shipping_available` as `country.shippingAvailable` , `country` . `iso3` as `country.iso3` , `country` . `display_state_in_registration` as `country.displayStateInRegistration` , `country` . `force_state_in_registration` as `country.forceStateInRegistration` , `country` . `check_vat_id_pattern` as `country.checkVatIdPattern` , `country` . `vat_id_required` as `country.vatIdRequired` , `country` . `vat_id_pattern` as `country.vatIdPattern` , `country` . `customer_tax` as `country.customerTax` , `country` . `company_tax` as `country.companyTax` , `country` . `postal_code_required` as `country.postalCodeRequired` , `country` . `check_postal_code_pattern` as `country.checkPostalCodePattern` , `country` . `check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern` , `country` . `advanced_postal_code_pattern` as `country.advancedPostalCodePattern` , `country` . `default_postal_code_pattern` as `country.defaultPostalCodePattern` , `country` . `is_eu` as `country.isEu` , `country` . `created_at` as `country.createdAt` , `country` . `updated_at` as `country.updatedAt` , (SELECT GROUP_CONCAT (HEX (`country.salesChannels.mapping` . `sales_channel_id` ) SEPARATOR '||' )
FROM `sales_channel_country` `country.salesChannels.mapping`
WHERE `country.salesChannels.mapping` . `country_id` = `country` . `id` ) as `country.salesChannels.id_mapping` , `country.translation.name` , `country.translation.name` as `country.name` , `country.translation.addressFormat` , `country.translation.addressFormat` as `country.addressFormat` , `country.translation.customFields` , `country.translation.customFields` as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation` . `country_id` , `country.translation` . `name` as `country.translation.name` , `country.translation` . `custom_fields` as `country.translation.customFields` , `country.translation` . `address_format` as `country.translation.addressFormat` FROM `country_translation` `country.translation` WHERE `country.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` WHERE `country` . `id` IN (0x0190A5D0B96D7303BF353DD303E5B927 , 0x0190A5D0BA1C71F2AD621C2C68C2977B );
Copy
0.52 ms (0.95%)
1
SELECT `sales_channel` . `id` as `sales_channel.id` , `sales_channel` . `type_id` as `sales_channel.typeId` , `sales_channel` . `language_id` as `sales_channel.languageId` , `sales_channel` . `customer_group_id` as `sales_channel.customerGroupId` , `sales_channel` . `currency_id` as `sales_channel.currencyId` , `sales_channel` . `payment_method_id` as `sales_channel.paymentMethodId` , `sales_channel` . `shipping_method_id` as `sales_channel.shippingMethodId` , `sales_channel` . `country_id` as `sales_channel.countryId` , `sales_channel` . `analytics_id` as `sales_channel.analyticsId` , `sales_channel` . `navigation_category_id` as `sales_channel.navigationCategoryId` , `sales_channel` . `navigation_category_version_id` as `sales_channel.navigationCategoryVersionId` , `sales_channel` . `navigation_category_depth` as `sales_channel.navigationCategoryDepth` , `sales_channel` . `footer_category_id` as `sales_channel.footerCategoryId` , `sales_channel` . `footer_category_version_id` as `sales_channel.footerCategoryVersionId` , `sales_channel` . `service_category_id` as `sales_channel.serviceCategoryId` , `sales_channel` . `service_category_version_id` as `sales_channel.serviceCategoryVersionId` , `sales_channel` . `mail_header_footer_id` as `sales_channel.mailHeaderFooterId` , `sales_channel` . `hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId` , `sales_channel` . `short_name` as `sales_channel.shortName` , `sales_channel` . `tax_calculation_type` as `sales_channel.taxCalculationType` , `sales_channel` . `access_key` as `sales_channel.accessKey` , `sales_channel` . `configuration` as `sales_channel.configuration` , `sales_channel` . `active` as `sales_channel.active` , `sales_channel` . `hreflang_active` as `sales_channel.hreflangActive` , `sales_channel` . `maintenance` as `sales_channel.maintenance` , `sales_channel` . `maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist` , `sales_channel` . `payment_method_ids` as `sales_channel.paymentMethodIds` , `sales_channel` . `home_cms_page_id` as `sales_channel.homeCmsPageId` , `sales_channel` . `home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId` , `sales_channel` . `created_at` as `sales_channel.createdAt` , `sales_channel` . `updated_at` as `sales_channel.updatedAt` , `sales_channel.translation.name` , `sales_channel.translation.name` as `sales_channel.name` , `sales_channel.translation.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig` , `sales_channel.translation.homeEnabled` , `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled` , `sales_channel.translation.homeName` , `sales_channel.translation.homeName` as `sales_channel.homeName` , `sales_channel.translation.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle` , `sales_channel.translation.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription` , `sales_channel.translation.homeKeywords` , `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords` , `sales_channel.translation.customFields` , `sales_channel.translation.customFields` as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation` . `sales_channel_id` , `sales_channel.translation` . `name` as `sales_channel.translation.name` , `sales_channel.translation` . `custom_fields` as `sales_channel.translation.customFields` , `sales_channel.translation` . `home_slot_config` as `sales_channel.translation.homeSlotConfig` , `sales_channel.translation` . `home_enabled` as `sales_channel.translation.homeEnabled` , `sales_channel.translation` . `home_name` as `sales_channel.translation.homeName` , `sales_channel.translation` . `home_meta_title` as `sales_channel.translation.homeMetaTitle` , `sales_channel.translation` . `home_meta_description` as `sales_channel.translation.homeMetaDescription` , `sales_channel.translation` . `home_keywords` as `sales_channel.translation.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation` . `language_id` = ? ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id` WHERE `sales_channel` . `id` IN (? , ? , ? , ? , ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 ɪJ£&pò▓Ãè ÌôÜÓ "
b"\x01 ‘J13£x"‰m\f p²ý;g "
b"˜C-ï9üF$³2\x13 ¥kŒ”M "
b"\x01 ɪJ£&pò▓Ãè ÌôÜÓ "
b"\x01 ‘J13£x"‰m\f p²ý;g "
]
SELECT
`sales_channel` . `id` as `sales_channel.id` ,
`sales_channel` . `type_id` as `sales_channel.typeId` ,
`sales_channel` . `language_id` as `sales_channel.languageId` ,
`sales_channel` . `customer_group_id` as `sales_channel.customerGroupId` ,
`sales_channel` . `currency_id` as `sales_channel.currencyId` ,
`sales_channel` . `payment_method_id` as `sales_channel.paymentMethodId` ,
`sales_channel` . `shipping_method_id` as `sales_channel.shippingMethodId` ,
`sales_channel` . `country_id` as `sales_channel.countryId` ,
`sales_channel` . `analytics_id` as `sales_channel.analyticsId` ,
`sales_channel` . `navigation_category_id` as `sales_channel.navigationCategoryId` ,
`sales_channel` . `navigation_category_version_id` as `sales_channel.navigationCategoryVersionId` ,
`sales_channel` . `navigation_category_depth` as `sales_channel.navigationCategoryDepth` ,
`sales_channel` . `footer_category_id` as `sales_channel.footerCategoryId` ,
`sales_channel` . `footer_category_version_id` as `sales_channel.footerCategoryVersionId` ,
`sales_channel` . `service_category_id` as `sales_channel.serviceCategoryId` ,
`sales_channel` . `service_category_version_id` as `sales_channel.serviceCategoryVersionId` ,
`sales_channel` . `mail_header_footer_id` as `sales_channel.mailHeaderFooterId` ,
`sales_channel` . `hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId` ,
`sales_channel` . `short_name` as `sales_channel.shortName` ,
`sales_channel` . `tax_calculation_type` as `sales_channel.taxCalculationType` ,
`sales_channel` . `access_key` as `sales_channel.accessKey` ,
`sales_channel` . `configuration` as `sales_channel.configuration` ,
`sales_channel` . `active` as `sales_channel.active` ,
`sales_channel` . `hreflang_active` as `sales_channel.hreflangActive` ,
`sales_channel` . `maintenance` as `sales_channel.maintenance` ,
`sales_channel` . `maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist` ,
`sales_channel` . `payment_method_ids` as `sales_channel.paymentMethodIds` ,
`sales_channel` . `home_cms_page_id` as `sales_channel.homeCmsPageId` ,
`sales_channel` . `home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId` ,
`sales_channel` . `created_at` as `sales_channel.createdAt` ,
`sales_channel` . `updated_at` as `sales_channel.updatedAt` ,
`sales_channel.translation.name` ,
`sales_channel.translation.name` as `sales_channel.name` ,
`sales_channel.translation.homeSlotConfig` ,
`sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig` ,
`sales_channel.translation.homeEnabled` ,
`sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled` ,
`sales_channel.translation.homeName` ,
`sales_channel.translation.homeName` as `sales_channel.homeName` ,
`sales_channel.translation.homeMetaTitle` ,
`sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle` ,
`sales_channel.translation.homeMetaDescription` ,
`sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription` ,
`sales_channel.translation.homeKeywords` ,
`sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords` ,
`sales_channel.translation.customFields` ,
`sales_channel.translation.customFields` as `sales_channel.customFields`
FROM
`sales_channel`
LEFT JOIN (
SELECT
`sales_channel.translation` . `sales_channel_id` ,
`sales_channel.translation` . `name` as `sales_channel.translation.name` ,
`sales_channel.translation` . `custom_fields` as `sales_channel.translation.customFields` ,
`sales_channel.translation` . `home_slot_config` as `sales_channel.translation.homeSlotConfig` ,
`sales_channel.translation` . `home_enabled` as `sales_channel.translation.homeEnabled` ,
`sales_channel.translation` . `home_name` as `sales_channel.translation.homeName` ,
`sales_channel.translation` . `home_meta_title` as `sales_channel.translation.homeMetaTitle` ,
`sales_channel.translation` . `home_meta_description` as `sales_channel.translation.homeMetaDescription` ,
`sales_channel.translation` . `home_keywords` as `sales_channel.translation.homeKeywords`
FROM
`sales_channel_translation` `sales_channel.translation`
WHERE
`sales_channel.translation` . `language_id` = ?
) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id`
WHERE
`sales_channel` . `id` IN (? , ? , ? , ? , ? )
Copy
SELECT `sales_channel` . `id` as `sales_channel.id` , `sales_channel` . `type_id` as `sales_channel.typeId` , `sales_channel` . `language_id` as `sales_channel.languageId` , `sales_channel` . `customer_group_id` as `sales_channel.customerGroupId` , `sales_channel` . `currency_id` as `sales_channel.currencyId` , `sales_channel` . `payment_method_id` as `sales_channel.paymentMethodId` , `sales_channel` . `shipping_method_id` as `sales_channel.shippingMethodId` , `sales_channel` . `country_id` as `sales_channel.countryId` , `sales_channel` . `analytics_id` as `sales_channel.analyticsId` , `sales_channel` . `navigation_category_id` as `sales_channel.navigationCategoryId` , `sales_channel` . `navigation_category_version_id` as `sales_channel.navigationCategoryVersionId` , `sales_channel` . `navigation_category_depth` as `sales_channel.navigationCategoryDepth` , `sales_channel` . `footer_category_id` as `sales_channel.footerCategoryId` , `sales_channel` . `footer_category_version_id` as `sales_channel.footerCategoryVersionId` , `sales_channel` . `service_category_id` as `sales_channel.serviceCategoryId` , `sales_channel` . `service_category_version_id` as `sales_channel.serviceCategoryVersionId` , `sales_channel` . `mail_header_footer_id` as `sales_channel.mailHeaderFooterId` , `sales_channel` . `hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId` , `sales_channel` . `short_name` as `sales_channel.shortName` , `sales_channel` . `tax_calculation_type` as `sales_channel.taxCalculationType` , `sales_channel` . `access_key` as `sales_channel.accessKey` , `sales_channel` . `configuration` as `sales_channel.configuration` , `sales_channel` . `active` as `sales_channel.active` , `sales_channel` . `hreflang_active` as `sales_channel.hreflangActive` , `sales_channel` . `maintenance` as `sales_channel.maintenance` , `sales_channel` . `maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist` , `sales_channel` . `payment_method_ids` as `sales_channel.paymentMethodIds` , `sales_channel` . `home_cms_page_id` as `sales_channel.homeCmsPageId` , `sales_channel` . `home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId` , `sales_channel` . `created_at` as `sales_channel.createdAt` , `sales_channel` . `updated_at` as `sales_channel.updatedAt` , `sales_channel.translation.name` , `sales_channel.translation.name` as `sales_channel.name` , `sales_channel.translation.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig` , `sales_channel.translation.homeEnabled` , `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled` , `sales_channel.translation.homeName` , `sales_channel.translation.homeName` as `sales_channel.homeName` , `sales_channel.translation.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle` , `sales_channel.translation.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription` , `sales_channel.translation.homeKeywords` , `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords` , `sales_channel.translation.customFields` , `sales_channel.translation.customFields` as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation` . `sales_channel_id` , `sales_channel.translation` . `name` as `sales_channel.translation.name` , `sales_channel.translation` . `custom_fields` as `sales_channel.translation.customFields` , `sales_channel.translation` . `home_slot_config` as `sales_channel.translation.homeSlotConfig` , `sales_channel.translation` . `home_enabled` as `sales_channel.translation.homeEnabled` , `sales_channel.translation` . `home_name` as `sales_channel.translation.homeName` , `sales_channel.translation` . `home_meta_title` as `sales_channel.translation.homeMetaTitle` , `sales_channel.translation` . `home_meta_description` as `sales_channel.translation.homeMetaDescription` , `sales_channel.translation` . `home_keywords` as `sales_channel.translation.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id` WHERE `sales_channel` . `id` IN (0x0190A64A9C267095B2C78AFFDE939AE0 , 0x01914A3133A37822896D0C70B2FD3B67 , 0x98432DEF39FC4624B33213A56B8C944D , 0x0190A64A9C267095B2C78AFFDE939AE0 , 0x01914A3133A37822896D0C70B2FD3B67 );
Copy
0.48 ms (0.87%)
1
SELECT `sales_channel` . `id` as `sales_channel.id` , `sales_channel` . `type_id` as `sales_channel.typeId` , `sales_channel` . `language_id` as `sales_channel.languageId` , `sales_channel` . `customer_group_id` as `sales_channel.customerGroupId` , `sales_channel` . `currency_id` as `sales_channel.currencyId` , `sales_channel` . `payment_method_id` as `sales_channel.paymentMethodId` , `sales_channel` . `shipping_method_id` as `sales_channel.shippingMethodId` , `sales_channel` . `country_id` as `sales_channel.countryId` , `sales_channel` . `analytics_id` as `sales_channel.analyticsId` , `sales_channel` . `navigation_category_id` as `sales_channel.navigationCategoryId` , `sales_channel` . `navigation_category_version_id` as `sales_channel.navigationCategoryVersionId` , `sales_channel` . `navigation_category_depth` as `sales_channel.navigationCategoryDepth` , `sales_channel` . `footer_category_id` as `sales_channel.footerCategoryId` , `sales_channel` . `footer_category_version_id` as `sales_channel.footerCategoryVersionId` , `sales_channel` . `service_category_id` as `sales_channel.serviceCategoryId` , `sales_channel` . `service_category_version_id` as `sales_channel.serviceCategoryVersionId` , `sales_channel` . `mail_header_footer_id` as `sales_channel.mailHeaderFooterId` , `sales_channel` . `hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId` , `sales_channel` . `short_name` as `sales_channel.shortName` , `sales_channel` . `tax_calculation_type` as `sales_channel.taxCalculationType` , `sales_channel` . `access_key` as `sales_channel.accessKey` , `sales_channel` . `configuration` as `sales_channel.configuration` , `sales_channel` . `active` as `sales_channel.active` , `sales_channel` . `hreflang_active` as `sales_channel.hreflangActive` , `sales_channel` . `maintenance` as `sales_channel.maintenance` , `sales_channel` . `maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist` , `sales_channel` . `payment_method_ids` as `sales_channel.paymentMethodIds` , `sales_channel` . `home_cms_page_id` as `sales_channel.homeCmsPageId` , `sales_channel` . `home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId` , `sales_channel` . `created_at` as `sales_channel.createdAt` , `sales_channel` . `updated_at` as `sales_channel.updatedAt` , `sales_channel.translation.name` , `sales_channel.translation.name` as `sales_channel.name` , `sales_channel.translation.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig` , `sales_channel.translation.homeEnabled` , `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled` , `sales_channel.translation.homeName` , `sales_channel.translation.homeName` as `sales_channel.homeName` , `sales_channel.translation.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle` , `sales_channel.translation.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription` , `sales_channel.translation.homeKeywords` , `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords` , `sales_channel.translation.customFields` , `sales_channel.translation.customFields` as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation` . `sales_channel_id` , `sales_channel.translation` . `name` as `sales_channel.translation.name` , `sales_channel.translation` . `custom_fields` as `sales_channel.translation.customFields` , `sales_channel.translation` . `home_slot_config` as `sales_channel.translation.homeSlotConfig` , `sales_channel.translation` . `home_enabled` as `sales_channel.translation.homeEnabled` , `sales_channel.translation` . `home_name` as `sales_channel.translation.homeName` , `sales_channel.translation` . `home_meta_title` as `sales_channel.translation.homeMetaTitle` , `sales_channel.translation` . `home_meta_description` as `sales_channel.translation.homeMetaDescription` , `sales_channel.translation` . `home_keywords` as `sales_channel.translation.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation` . `language_id` = ? ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id`
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT
`sales_channel` . `id` as `sales_channel.id` ,
`sales_channel` . `type_id` as `sales_channel.typeId` ,
`sales_channel` . `language_id` as `sales_channel.languageId` ,
`sales_channel` . `customer_group_id` as `sales_channel.customerGroupId` ,
`sales_channel` . `currency_id` as `sales_channel.currencyId` ,
`sales_channel` . `payment_method_id` as `sales_channel.paymentMethodId` ,
`sales_channel` . `shipping_method_id` as `sales_channel.shippingMethodId` ,
`sales_channel` . `country_id` as `sales_channel.countryId` ,
`sales_channel` . `analytics_id` as `sales_channel.analyticsId` ,
`sales_channel` . `navigation_category_id` as `sales_channel.navigationCategoryId` ,
`sales_channel` . `navigation_category_version_id` as `sales_channel.navigationCategoryVersionId` ,
`sales_channel` . `navigation_category_depth` as `sales_channel.navigationCategoryDepth` ,
`sales_channel` . `footer_category_id` as `sales_channel.footerCategoryId` ,
`sales_channel` . `footer_category_version_id` as `sales_channel.footerCategoryVersionId` ,
`sales_channel` . `service_category_id` as `sales_channel.serviceCategoryId` ,
`sales_channel` . `service_category_version_id` as `sales_channel.serviceCategoryVersionId` ,
`sales_channel` . `mail_header_footer_id` as `sales_channel.mailHeaderFooterId` ,
`sales_channel` . `hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId` ,
`sales_channel` . `short_name` as `sales_channel.shortName` ,
`sales_channel` . `tax_calculation_type` as `sales_channel.taxCalculationType` ,
`sales_channel` . `access_key` as `sales_channel.accessKey` ,
`sales_channel` . `configuration` as `sales_channel.configuration` ,
`sales_channel` . `active` as `sales_channel.active` ,
`sales_channel` . `hreflang_active` as `sales_channel.hreflangActive` ,
`sales_channel` . `maintenance` as `sales_channel.maintenance` ,
`sales_channel` . `maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist` ,
`sales_channel` . `payment_method_ids` as `sales_channel.paymentMethodIds` ,
`sales_channel` . `home_cms_page_id` as `sales_channel.homeCmsPageId` ,
`sales_channel` . `home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId` ,
`sales_channel` . `created_at` as `sales_channel.createdAt` ,
`sales_channel` . `updated_at` as `sales_channel.updatedAt` ,
`sales_channel.translation.name` ,
`sales_channel.translation.name` as `sales_channel.name` ,
`sales_channel.translation.homeSlotConfig` ,
`sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig` ,
`sales_channel.translation.homeEnabled` ,
`sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled` ,
`sales_channel.translation.homeName` ,
`sales_channel.translation.homeName` as `sales_channel.homeName` ,
`sales_channel.translation.homeMetaTitle` ,
`sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle` ,
`sales_channel.translation.homeMetaDescription` ,
`sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription` ,
`sales_channel.translation.homeKeywords` ,
`sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords` ,
`sales_channel.translation.customFields` ,
`sales_channel.translation.customFields` as `sales_channel.customFields`
FROM
`sales_channel`
LEFT JOIN (
SELECT
`sales_channel.translation` . `sales_channel_id` ,
`sales_channel.translation` . `name` as `sales_channel.translation.name` ,
`sales_channel.translation` . `custom_fields` as `sales_channel.translation.customFields` ,
`sales_channel.translation` . `home_slot_config` as `sales_channel.translation.homeSlotConfig` ,
`sales_channel.translation` . `home_enabled` as `sales_channel.translation.homeEnabled` ,
`sales_channel.translation` . `home_name` as `sales_channel.translation.homeName` ,
`sales_channel.translation` . `home_meta_title` as `sales_channel.translation.homeMetaTitle` ,
`sales_channel.translation` . `home_meta_description` as `sales_channel.translation.homeMetaDescription` ,
`sales_channel.translation` . `home_keywords` as `sales_channel.translation.homeKeywords`
FROM
`sales_channel_translation` `sales_channel.translation`
WHERE
`sales_channel.translation` . `language_id` = ?
) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id`
Copy
SELECT `sales_channel` . `id` as `sales_channel.id` , `sales_channel` . `type_id` as `sales_channel.typeId` , `sales_channel` . `language_id` as `sales_channel.languageId` , `sales_channel` . `customer_group_id` as `sales_channel.customerGroupId` , `sales_channel` . `currency_id` as `sales_channel.currencyId` , `sales_channel` . `payment_method_id` as `sales_channel.paymentMethodId` , `sales_channel` . `shipping_method_id` as `sales_channel.shippingMethodId` , `sales_channel` . `country_id` as `sales_channel.countryId` , `sales_channel` . `analytics_id` as `sales_channel.analyticsId` , `sales_channel` . `navigation_category_id` as `sales_channel.navigationCategoryId` , `sales_channel` . `navigation_category_version_id` as `sales_channel.navigationCategoryVersionId` , `sales_channel` . `navigation_category_depth` as `sales_channel.navigationCategoryDepth` , `sales_channel` . `footer_category_id` as `sales_channel.footerCategoryId` , `sales_channel` . `footer_category_version_id` as `sales_channel.footerCategoryVersionId` , `sales_channel` . `service_category_id` as `sales_channel.serviceCategoryId` , `sales_channel` . `service_category_version_id` as `sales_channel.serviceCategoryVersionId` , `sales_channel` . `mail_header_footer_id` as `sales_channel.mailHeaderFooterId` , `sales_channel` . `hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId` , `sales_channel` . `short_name` as `sales_channel.shortName` , `sales_channel` . `tax_calculation_type` as `sales_channel.taxCalculationType` , `sales_channel` . `access_key` as `sales_channel.accessKey` , `sales_channel` . `configuration` as `sales_channel.configuration` , `sales_channel` . `active` as `sales_channel.active` , `sales_channel` . `hreflang_active` as `sales_channel.hreflangActive` , `sales_channel` . `maintenance` as `sales_channel.maintenance` , `sales_channel` . `maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist` , `sales_channel` . `payment_method_ids` as `sales_channel.paymentMethodIds` , `sales_channel` . `home_cms_page_id` as `sales_channel.homeCmsPageId` , `sales_channel` . `home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId` , `sales_channel` . `created_at` as `sales_channel.createdAt` , `sales_channel` . `updated_at` as `sales_channel.updatedAt` , `sales_channel.translation.name` , `sales_channel.translation.name` as `sales_channel.name` , `sales_channel.translation.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig` , `sales_channel.translation.homeEnabled` , `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled` , `sales_channel.translation.homeName` , `sales_channel.translation.homeName` as `sales_channel.homeName` , `sales_channel.translation.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle` , `sales_channel.translation.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription` , `sales_channel.translation.homeKeywords` , `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords` , `sales_channel.translation.customFields` , `sales_channel.translation.customFields` as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation` . `sales_channel_id` , `sales_channel.translation` . `name` as `sales_channel.translation.name` , `sales_channel.translation` . `custom_fields` as `sales_channel.translation.customFields` , `sales_channel.translation` . `home_slot_config` as `sales_channel.translation.homeSlotConfig` , `sales_channel.translation` . `home_enabled` as `sales_channel.translation.homeEnabled` , `sales_channel.translation` . `home_name` as `sales_channel.translation.homeName` , `sales_channel.translation` . `home_meta_title` as `sales_channel.translation.homeMetaTitle` , `sales_channel.translation` . `home_meta_description` as `sales_channel.translation.homeMetaDescription` , `sales_channel.translation` . `home_keywords` as `sales_channel.translation.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id` ;
Copy
0.46 ms (0.83%)
1
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ? ) AND (token = ? ) LIMIT 1
Parameters :
[
b"\x01 ‘J13£x"‰m\f p²ý;g "
"aGdnPBJXzfO8zO6i8LDNWW8YkhWtSPKR "
]
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0x01914A3133A37822896D0C70B2FD3B67 ) AND (token = 'aGdnPBJXzfO8zO6i8LDNWW8YkhWtSPKR' ) LIMIT 1 ;
Copy
0.45 ms (0.82%)
1
SELECT DISTINCT
LOWER (HEX (sales_channel . id )) AS salesChannelId ,
LOWER (HEX (domains . language_id )) AS languageId
FROM sales_channel_domain AS domains
INNER JOIN sales_channel
ON domains . sales_channel_id = sales_channel . id
AND sales_channel . active = 1
SELECT DISTINCT
LOWER (HEX (sales_channel . id )) AS salesChannelId ,
LOWER (HEX (domains . language_id )) AS languageId
FROM sales_channel_domain AS domains
INNER JOIN sales_channel
ON domains . sales_channel_id = sales_channel . id
AND sales_channel . active = 1 ;
Copy
0.40 ms (0.73%)
2
SELECT LOWER (HEX (parent_id )) FROM language WHERE id = ?
Parameters :
[
"0190a5d21558701cb17a1f89991d17e2 "
]
SELECT LOWER (HEX (parent_id )) FROM language WHERE id = '0190a5d21558701cb17a1f89991d17e2' ;
Copy
0.38 ms (0.70%)
1
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` ;
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` ; ;
Copy
0.36 ms (0.66%)
1
SELECT path_info pathInfo , seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ? ) AND (sales_channel_id = ? ) AND (path_info = ? ) AND (is_canonical = 1 ) LIMIT 1
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 ‘J13£x"‰m\f p²ý;g "
"/author/Bauer,%20Karin "
]
SELECT path_info pathInfo , seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (sales_channel_id = 0x01914A3133A37822896D0C70B2FD3B67 ) AND (path_info = '/author/Bauer,%20Karin' ) AND (is_canonical = 1 ) LIMIT 1 ;
Copy
0.35 ms (0.64%)
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
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 ;
Copy
0.34 ms (0.62%)
1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1 ;
Copy
0.32 ms (0.58%)
1
SELECT `sales_channel_country` . `sales_channel_id` , `sales_channel_country` . `country_id` FROM `sales_channel_country` WHERE (`sales_channel_country` . `sales_channel_id` = ? AND `sales_channel_country` . `country_id` = ? )
Parameters :
[
b"\x01 ‘J13£x"‰m\f p²ý;g "
b"\x01 ÉÑð╣ms\x03 ┐5=Ë\x03 Õ╣' "
]
SELECT `sales_channel_country` . `sales_channel_id` , `sales_channel_country` . `country_id` FROM `sales_channel_country` WHERE (`sales_channel_country` . `sales_channel_id` = 0x01914A3133A37822896D0C70B2FD3B67 AND `sales_channel_country` . `country_id` = 0x0190A5D0B96D7303BF353DD303E5B927 );
Copy
0.29 ms (0.52%)
1
SELECT path FROM category WHERE id = ?
Parameters :
[
b"\x01 æÄC\¼t«ÉÍ_£Ûd╬y "
]
SELECT path FROM category WHERE id = 0x01918E435CAC74AE90D65F9CEA64CE79 ;
Copy
0.28 ms (0.52%)
1
SELECT `product_search_config` . `id` as `product_search_config.id` , `product_search_config` . `language_id` as `product_search_config.languageId` , `product_search_config` . `and_logic` as `product_search_config.andLogic` , `product_search_config` . `min_search_length` as `product_search_config.minSearchLength` , `product_search_config` . `excluded_terms` as `product_search_config.excludedTerms` , `product_search_config` . `created_at` as `product_search_config.createdAt` , `product_search_config` . `updated_at` as `product_search_config.updatedAt` FROM `product_search_config` WHERE `product_search_config` . `id` IN (? )
Parameters :
[
b"\x01 ÉÑÐL├r'ÖîæCÄ\x1D Êy "
]
SELECT `product_search_config` . `id` as `product_search_config.id` , `product_search_config` . `language_id` as `product_search_config.languageId` , `product_search_config` . `and_logic` as `product_search_config.andLogic` , `product_search_config` . `min_search_length` as `product_search_config.minSearchLength` , `product_search_config` . `excluded_terms` as `product_search_config.excludedTerms` , `product_search_config` . `created_at` as `product_search_config.createdAt` , `product_search_config` . `updated_at` as `product_search_config.updatedAt` FROM `product_search_config` WHERE `product_search_config` . `id` IN (0x0190A5D14CC37227998C91438E1DD279 );
Copy
0.26 ms (0.48%)
1
SELECT `product_search_config` . `id` FROM `product_search_config` WHERE (`product_search_config` . `language_id` = ? ) LIMIT 1
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `product_search_config` . `id` FROM `product_search_config` WHERE (`product_search_config` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) LIMIT 1 ;
Copy
0.26 ms (0.47%)
1
SELECT LOWER (HEX (sales_channel_id )) AS sales_channel_id , route_name , template
FROM seo_url_template
WHERE route_name IN (? )
Parameters :
[
"frontend.detail.page "
]
SELECT LOWER (HEX (sales_channel_id )) AS sales_channel_id , route_name , template
FROM seo_url_template
WHERE route_name IN ('frontend.detail.page' );
Copy
0.26 ms (0.47%)
1
SELECT `sales_channel_analytics` . `id` as `sales_channel_analytics.id` , `sales_channel_analytics` . `tracking_id` as `sales_channel_analytics.trackingId` , `sales_channel_analytics` . `active` as `sales_channel_analytics.active` , `sales_channel_analytics` . `track_orders` as `sales_channel_analytics.trackOrders` , `sales_channel_analytics` . `anonymize_ip` as `sales_channel_analytics.anonymizeIp` , `sales_channel_analytics` . `created_at` as `sales_channel_analytics.createdAt` , `sales_channel_analytics` . `updated_at` as `sales_channel_analytics.updatedAt` FROM `sales_channel_analytics` WHERE `sales_channel_analytics` . `id` IN (? )
Parameters :
[
b"\x01 —œ2^a~¿¬?“®W¾ ¯ "
]
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 (0x01979C325E617EBFAC3F93AE57BEA0AF );
Copy
0.26 ms (0.47%)
1
SELECT `name` , `path` , `author` , `self_managed`
FROM `app`
WHERE `active` = 1
SELECT `name` , `path` , `author` , `self_managed`
FROM `app`
WHERE `active` = 1
;
Copy
0.24 ms (0.44%)
1
SELECT min_search_length FROM product_search_config WHERE language_id = ?
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT min_search_length FROM product_search_config WHERE language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ;
Copy
0.24 ms (0.43%)
1
SELECT `tax` . `id` as `tax.id` , `tax` . `tax_rate` as `tax.taxRate` , `tax` . `name` as `tax.name` , `tax` . `position` as `tax.position` , `tax` . `custom_fields` as `tax.customFields` , `tax` . `created_at` as `tax.createdAt` , `tax` . `updated_at` as `tax.updatedAt` FROM `tax`
SELECT `tax` . `id` as `tax.id` , `tax` . `tax_rate` as `tax.taxRate` , `tax` . `name` as `tax.name` , `tax` . `position` as `tax.position` , `tax` . `custom_fields` as `tax.customFields` , `tax` . `created_at` as `tax.createdAt` , `tax` . `updated_at` as `tax.updatedAt` FROM `tax` ;
Copy
0.23 ms (0.41%)
1
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = ?
Parameters :
[
"aGdnPBJXzfO8zO6i8LDNWW8YkhWtSPKR "
]
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = 'aGdnPBJXzfO8zO6i8LDNWW8YkhWtSPKR' ;
Copy
0.21 ms (0.38%)
1
SELECT `language` . `id` as `language.id` , `language` . `parent_id` as `language.parentId` , `language` . `locale_id` as `language.localeId` , `language` . `translation_code_id` as `language.translationCodeId` , `language` . `name` as `language.name` , `language` . `custom_fields` as `language.customFields` , `language` . `created_at` as `language.createdAt` , `language` . `updated_at` as `language.updatedAt` FROM `language`
SELECT `language` . `id` as `language.id` , `language` . `parent_id` as `language.parentId` , `language` . `locale_id` as `language.localeId` , `language` . `translation_code_id` as `language.translationCodeId` , `language` . `name` as `language.name` , `language` . `custom_fields` as `language.customFields` , `language` . `created_at` as `language.createdAt` , `language` . `updated_at` as `language.updatedAt` FROM `language` ;
Copy
0.19 ms (0.35%)
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' , '' ))
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' , '' ));
Copy