10.81 ms (18.39%)
14
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
5.39 ms (9.16%)
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/624192d6038b855d14f7add2488d50a7 "
"/detail/eb2b22ccc18592829a1fd25df41aaba4 "
"/detail/bd047bf21e003b6320d0d5311c71ac28 "
"/detail/2e9539d5dbaecc037c3df8e3b918c33b "
"/detail/1484217f07f4793049b2fe5eb8701044 "
"/detail/0bdbf018f84a1a286dd6536bebd80c61 "
"/detail/27b66349a8c2abfe08c6682ca88060d4 "
"/detail/42f04a08a42450ee9d9e66557b002c21 "
"/detail/c767f8e8219eba220ec58c9a56a38d96 "
"/detail/c9935485888a96c5015cfe7ff46cf686 "
"/detail/454a571ff496615dbd0fce423a752c73 "
"/detail/0c56370d6bb9268968be45dc106a8b96 "
"/detail/0883e82e2ef27340372aef7af1fea68e "
"/detail/6c729ea21606fe6125cfd492828244be "
"/detail/6cf80c1d01b938513bbdc032485b76a9 "
"/detail/c2cfdddef0496dd00f4d40b28b594ed8 "
"/detail/23e51fab7e1c55a3260d48f42efc2c27 "
"/detail/a70660ab3be8bb2cbba11f1834eef779 "
"/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/624192d6038b855d14f7add2488d50a7' , '/detail/eb2b22ccc18592829a1fd25df41aaba4' , '/detail/bd047bf21e003b6320d0d5311c71ac28' , '/detail/2e9539d5dbaecc037c3df8e3b918c33b' , '/detail/1484217f07f4793049b2fe5eb8701044' , '/detail/0bdbf018f84a1a286dd6536bebd80c61' , '/detail/27b66349a8c2abfe08c6682ca88060d4' , '/detail/42f04a08a42450ee9d9e66557b002c21' , '/detail/c767f8e8219eba220ec58c9a56a38d96' , '/detail/c9935485888a96c5015cfe7ff46cf686' , '/detail/454a571ff496615dbd0fce423a752c73' , '/detail/0c56370d6bb9268968be45dc106a8b96' , '/detail/0883e82e2ef27340372aef7af1fea68e' , '/detail/6c729ea21606fe6125cfd492828244be' , '/detail/6cf80c1d01b938513bbdc032485b76a9' , '/detail/c2cfdddef0496dd00f4d40b28b594ed8' , '/detail/23e51fab7e1c55a3260d48f42efc2c27' , '/detail/a70660ab3be8bb2cbba11f1834eef779' , '/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
4.68 ms (7.96%)
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"bAÆÍ\x03 ïà]\x14 ¸¡ÊHìPº "
b"ë+"ÌÁ…’‚š\x1F Ò]ô\x1A «¤ "
b"½\x04 {ò\x1E\x00 ;c ÐÕ1\x1C q¬( "
b".•9ÕÛ®Ì\x03 |=øã¹\x18 Ã; "
b"\x14 „!\x7F\x07 ôy0I²þ^¸p\x10 D "
b"\v Ûð\x18 øJ\x1A (mÖSkëØ\f a "
b"'¶cI¨Â«þ\x08 Æh,¨€`Ô "
b"BJ\x08 ñ$P¯Ø×fU{\x00 ,! "
b"Ãg°Þ!×║"\x0E ┼îÜVúìû "
b"É“T…ˆŠ–Å\x01 \þ\x7F ôlö† "
b"EJW\x1F ô–a]½\x0F ÎB:u,s "
b"\f V7\r k¹&‰h¾EÜ\x10 j‹– "
b"\x08 ƒè..òs@7*ïzñþ¦Ž "
b"lrž¢\x16\x06 þa%ÏÔ’‚‚D¾ "
b"lø\f\x1D\x01 ¹8Q;½À2H[v© "
b"ÂÏÝÞðImÐ\x0F M@²‹YNØ "
b"#å\x1F «~\x1C U£&\r Hô.ü,' "
b"§\x06 `«;è»,»¡\x1F\x18 4î÷y "
]
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 (0x624192D6038B855D14F7ADD2488D50A7 , 0xEB2B22CCC18592829A1FD25DF41AABA4 , 0xBD047BF21E003B6320D0D5311C71AC28 , 0x2E9539D5DBAECC037C3DF8E3B918C33B , 0x1484217F07F4793049B2FE5EB8701044 , 0x0BDBF018F84A1A286DD6536BEBD80C61 , 0x27B66349A8C2ABFE08C6682CA88060D4 , 0x42F04A08A42450EE9D9E66557B002C21 , 0xC767F8E8219EBA220EC58C9A56A38D96 , 0xC9935485888A96C5015CFE7FF46CF686 , 0x454A571FF496615DBD0FCE423A752C73 , 0x0C56370D6BB9268968BE45DC106A8B96 , 0x0883E82E2EF27340372AEF7AF1FEA68E , 0x6C729EA21606FE6125CFD492828244BE , 0x6CF80C1D01B938513BBDC032485B76A9 , 0xC2CFDDDEF0496DD00F4D40B28B594ED8 , 0x23E51FAB7E1C55A3260D48F42EFC2C27 , 0xA70660AB3BE8BB2CBBA11F1834EEF779 ));
Copy
3.52 ms (5.99%)
1
SELECT `meta_catalog_id` . `id` FROM `meta_catalog_id` WHERE `meta_catalog_id` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"ÀüÚÿ\v g\x18\x1C ╠?┘õ$¸Á░ "
b"ø3‡\x15 ú\x12\x01 µY°ƒ,+†ê\x01 "
b"ÛÎÅNË×fö#█ÌêwKü\x04 "
b"\x15 ›˜\x1A k;¥õ~YÕ¢\x19 Y¨H "
b"Ý(øŠKmŽ º—“ž>)°” "
b"EGJèT¿š–iÅé\x00 û!ì~ "
b"ç\x17 \x1F Û}€—Å›[`8Äl5 "
b"d\x02 Îõ„K’Èßàéö3"ok "
b"\x1F Éü\t n¹(ò±´"h£\x08\x13 U "
b"ÈÙœ\x11 @¦ô^¡Üš5ñ¨‡‘ "
b"øo|EnI›r÷\x15 î[®Ù^Ê "
b"†–\x1C yÅ>g扣mÏ{Ð\x17 ‹ "
b"╬┘(\t ÷▒D|\x12 [ÉdÓ-Î "
b"ÿ„7öTâÙpÒJ¨).¶Ÿ' "
b"\x05 —\x07 µ¸N?\x12 ?\x03\x08 #ŠÀ\x05 ç "
b"DjEòñ^\t BMÎ^ÙÕ'/h "
b"e\x13 ¥x!âÑ,Æö¿nÕ«\f ¿ "
b"zYp\1eNu\x12 ¯…X£Á@\x19 "
b"S¤è}6\u\x03 ÏÄ^ƒÇõ÷¾ "
b"¬Öõ¶(±·\x16 aw¦ÿâ/\x11 œ "
b"–IØa\f V$%ù V!\x1E ¿p© "
b"$ÇÄeIް`Ù\x01 £0#ìk1 "
b"{’d¢·³]ÅÑìÅÀ¾~<# "
b"""
\x13 =]üÞÔ\x0F Ïæ\t \n
Öf=&Ï
"""
b"~y0ü§KÄgA^o0æ*¤ç "
b"< k½Ã†›ÄH\x04 _cUÀ\x7F "
b"*5¥æ‗ü\x11 Âë[²╠╚Ïif "
b" Ú\x1C Í█"\x02 à\x16 첺Æh·▒ "
b"»é6å’\x01 lǹµñ@\x19 n~« "
b"R»œçFξì4øš…s\x14 ª˜ "
b""ØÚ£õÛ¨!\x01 Ëí╗ñ\r [Ù "
b"$¶\v ýœF¿\x02 Ëýn\x1E ,ž"ë "
b"2Àë═½°Ø\x16 ÅËTÕ\x0E ´³y "
b"é„uã\x17 Ô#‰`©š^awã "
b"a®Ó\x02 F±Ô*e¨▄UæõØ0 "
b"(Ðþãƒà›èwˆcwÊ\x1F †µ "
b"X\x10 ├ÉoÁ┐2E\x1F %H┼*¨ü "
b"J\x0F 1iߦU0M@b¶é¤žÓ "
b"œ¹»\x04\x1E ¼‰ã\x04 ñÃ7ÖI@¡ "
b"=)zèú¤7ðL?84€€mÈ "
b"w—¡XFnð\x05 –Ô\x1D ]<£á— "
b"x<ëiG&µü\x1E .¼}ÝYþk "
b"ÛB?ö‚ªÓªòB¼,”\x1F Aá "
b"ë\x07\t Î.©ó¶œ[<×»Whz "
b"ÒÝÅ•0OLúç·Ç\x12 é\t Ž "
b":X\x18 ÿe├çÒ?,ò7ϰØD "
b"wú‚ƒ\x06 †®j†ó„b\x02 Ík[ "
b"i4t╔┴Ôæ╬>?ü[\x0E ¸æ│ "
b"ð[¯%\Á N·Be·ú›€¯ "
b"\x05 :\x04 Í\x12 —kH<#Ù¿õ38\x1C "
b"iŸÊ¬~a\t ³°e.–‹¤»+ "
b"""
ÕX½@éB4â÷\n
œbPÌ\t è
"""
b"’\x06 ÿ’" k\x00 “õn™P_ÐN "
b"╬íÌ┤,[%x\x03 h·w©O+ì "
b"É6\x08 U\x17 fŠML\v 1¦_µ\x14 m "
b"íð‘á¼ûgå»{ó\x01 g¯)‚ "
b"„_³þžÚÚg\x7F 1i[4>R\x02 "
b"µ]Æœñ!*\x0E nµ…\x1C\x14 ¨pì "
b"•4eÙ*âš\x1C $|ˆWEíûš "
b"2â¨L`—Úî\x07 uâ3ùx¥ˆ "
b"S„êÙQ¨ï0ñV9«øˆAÔ "
b"HnöË \x12\x1A ÷öÎMõ¨ðø "
b"wïÂØ,\x00 ù(`²§Ÿ!\v ¯@ "
b"tË+■Ï\x19 ╔\x10 ů,┴Þ|\x04 i "
b"Ùã¦╬├Ü*p]séHü¶³\x03 "
b"´ÚÒtÅâÞ‗"ıê┬?¼pÎ "
b"'CéWYK“G¿Ü„ñ‹H¾T "
b"í\x11 ðaõ^»¢ª°•†–\x13 mJ "
b"z\x15 ¸¹Ò%;9ðÙT\x1D Ã\x10 ¦û "
b"Ýz│ìY+7Ñ^,▓\x1C zV▒j "
b"0‡è^ç&íÿ\n Ü¢²sÃ\x00 ø "
b"MØ/ã\x7F Qâ\x03 Ÿh¥z>ßí_ "
b"g/bê\x15 ›V3ó…ëìÑt˜q "
b"Á¤\x00 T\x13 á\x03 ½öÞ\x1C 6–æ\x18 "
b"A?–N„Š>o—^…S4TTq "
b"\x07\x13 3•ZÙ×a¿›(¼Ë`<é "
b"ã\x1A Ês2Í]*‡$’æci75 "
b"¨|\x1C \x1A î2‰™%xvÀw¦B "
b"oä\x05 þÓ\x13 ±\t Ä>Ã\x7F ðW[ã "
b"€Wmãd¦«Ã\x01 &\x1A ÏM›hL "
b"ÇÇøÃ¥┬ÑvÅ\x01 CJ╗·\x1F à "
b"\\x12 î\x12 ═\f 9.ÈãLÓu╝üC "
b"ZÜkÀ\x1E ÜÇ▀¡\\e\x15 2Q½É "
b"„Ûq‚”Érÿv\x1D &í0B³Ÿ "
b"AÁ²ކ\x1A ¾Ót\x1F ñ}\f (Œ "
b"í║\x16 =ù╝\x0F þƒ─#Ø%¹░ "
b"ÝAú\v ³ÞíÓÓº4ùöÔÆæ "
b"I–ÎÁ¡ú”qp9TÃL\v ø/ "
b"³o«Ð–ý³G‚\x18 LܸóÉó "
b"À\x00 Hq8ìKAuLuà¾JM\x07 "
b"j\x10 ±É2ƒ/|└á╠@í┌úÁ "
b"A^æÂ\x16\f █#É(ÅK^ôÓà "
b"#d\v òøÅo>Åþ{▀┴²) "
b"Ó—\x07 BÎd\x00 ¿iþæ•ñóì› "
b"*|É–j!±2ïâµ\e ð͈ú "
b"&\x11 òàe°ÿt;æð/gq\x11 Z "
b"&>šüC\x03 €\x05 aÜ©V)\x1D Î+ "
b"6[·ø\x01 ¹» Ù╩‗ü%ÌY "
b"\x08 çˆ\x18 Îïü÷Â]Ž×¦šI\x01 "
b"àÅGmqˆÝV1W\x05 ‰N&³¨ "
b"KrôZ˜o~¥ŸÍmÛàí-ß "
b"—\x05 BÅÀ\x15 Ü\x15 ÜœV|ÍïZú "
b"vã£}hnz\x12 æ’ÓÀͽÜ< "
b"""
\x19 ”„g\x1D Z9\n
¢x\x7F ¡ŒË‡'
"""
b"%Þ\x16 2\x18 µÒ{1N3▄ög²ü "
b"D§¡Åߨ쵳Î░é·Wüj "
b"0ÏÔæJnþ\x12\x1A GÒX•Ï¿H "
b"\x04 ÿòß¾=þ•×K‡éW\x0F ~“ "
b"\x0F\e ÉK´¹z┴v▀ºØmÒ\t h "
b"D0\x00 -\n !\v Nªæ\x1D VÃö\x1A ì "
b"ö®†vI´ÕM-\e H\r W òé "
b"½W¿.Æì¼b\x05 6\x16 Äñj\v\x04 "
b"TŒ£Û¤ŸóÍ^\v û¨»Òÿë "
b"áã\x04 ÑT×┘└¦¦ëÓxá╠ì "
b"bAÆÍ\x03 ïà]\x14 ¸¡ÊHìPº "
b"ë+"ÌÁ…’‚š\x1F Ò]ô\x1A «¤ "
b"½\x04 {ò\x1E\x00 ;c ÐÕ1\x1C q¬( "
b".•9ÕÛ®Ì\x03 |=øã¹\x18 Ã; "
b"\x14 „!\x7F\x07 ôy0I²þ^¸p\x10 D "
b"\v Ûð\x18 øJ\x1A (mÖSkëØ\f a "
b"'¶cI¨Â«þ\x08 Æh,¨€`Ô "
b"BJ\x08 ñ$P¯Ø×fU{\x00 ,! "
b"Ãg°Þ!×║"\x0E ┼îÜVúìû "
b"É“T…ˆŠ–Å\x01 \þ\x7F ôlö† "
b"EJW\x1F ô–a]½\x0F ÎB:u,s "
b"\f V7\r k¹&‰h¾EÜ\x10 j‹– "
b"\x08 ƒè..òs@7*ïzñþ¦Ž "
b"lrž¢\x16\x06 þa%ÏÔ’‚‚D¾ "
b"lø\f\x1D\x01 ¹8Q;½À2H[v© "
b"ÂÏÝÞðImÐ\x0F M@²‹YNØ "
b"#å\x1F «~\x1C U£&\r Hô.ü,' "
b"§\x06 `«;è»,»¡\x1F\x18 4î÷y "
b"î‚©Õf\x1F òS2@è>Œá–3 "
]
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 (0xB781E9980B67181CCC3FD9E424F7B5B0 , 0xF8338715FA1201B559B0832C2B86EA01 , 0xEAD78F4ED39E669423DBDE88774B8104 , 0x159B981A6B3BA5F57E59D5A21959A848 , 0xDD28F88A4B6D8E20BA97939E3E29B094 , 0x45474AE854BF9A9669C5E900FB21EC7E , 0xE717AD1FDB7D8097C59B5B6038C46C35 , 0x6402CEF5844B92C8DFE0E9F633226F6B , 0x1F9081096EFB2895F1EF22689C081355 , 0xC8D99C1140A6F45EA1DC9A35F1A88791 , 0xF86F7C456E499B72F715EE5BAED95ECA , 0x86961C79C53E67E689A36DCF7BD0178B , 0xF0CED92809F6B1447C125B9064E02DD7 , 0xFF8437F654E2D970D24AA8292EB69F27 , 0x059707B5B84E3F123F0308238AC005E7 , 0x446A45F2F15E09424DCE5ED9D5272F68 , 0x6513A57821E2D12CC6F6BF6ED5AB0CBF , 0x7A59705C31654E7512AF8558A3C14019 , 0x53A4E87D365C7503CFC45E83C7F5F7BE , 0xACD6F5B628B1B7166177A6FFE22F119C , 0x9649D8610C562425F92056211EBF70A9 , 0x24C7C465498EB060D901A33023EC6B31 , 0x7B9264A2B7B35DC5D1ECC5C0BE7E3C23 , 0x133D5D81E8E20FD891090A99663D26D8 , 0x7E7930FCA74BC467415E6F30E62AA4E7 , 0x3C206BBDC3869BC448045F6355C0AD7F , 0x2A35BE91F28111B6895BFDCCC8D86966 , 0xFFE91CD6DB220285168DFDA79268FAB1 , 0xBBE936E592016CC7B9B5F140196E7EAB , 0x52BB9CE746CEBEEC34F89A857314AA98 , 0x229DE99CE4EAF92101D3A1BBA40D5BEB , 0x24B60BFD9C46BF02CBFD6E1E2C9E22EB , 0x32B789CDABF89D168FD354E50EEFFC79 , 0xE98475E317D4238960C2A99A5E6177E3 , 0x61A9E00246F1E22A65F9DC5591E49D30 , 0x28D0FEE383E09BE877886377CA1F86B5 , 0x5810C3906FB5BF32451F2548C52AF981 , 0x4A0F3169DFA655304D4062B6E9A49ED3 , 0x9CB9BB041EBC89E304F1C337D64940A1 , 0x3D297AE8FAA437F04C3F383480806DC8 , 0x7797A158466EF00596D41D5D3CA3E197 , 0x783C89694726E6811E2EAC7DED59E76B , 0xDB423FF682AAD3AAF242BC2C941F41E1 , 0xEB0709CE2EA9F3B69C5B3CD7BB57687A , 0xD2DDC595304F4CFAE7B7C712E909A08E , 0x3A58189865C387E33F2C9537D8F89D44 , 0x77FA82830686AE6A86F3846202CD6B5B , 0x693474C9C1E291CE3E3F815B0EF791B3 , 0xF05BAF255CC1A04EB74265B7FA9B80AF , 0x053A04CD12976B483C23D9BFF533381C , 0x699FCAAC7E6109B3B0652E968BA4BB2B , 0xD558BD40E94234E2F70A9C6250CC09E8 , 0x9206FF9222206B0093F56E99505FD04E , 0xCEA1DEB42C5B25780368FA77B84F2B8D , 0xC936085517668A4D4C0B31A65FB5146D , 0xEDF091E1BCFB67E5BB7BF30167AF2982 , 0x845FB3FE9EDADA677F31695B343E5202 , 0xB55DC69CF1212A0E6EB5851C14A870EC , 0x953465D92AE29A1C247C885745EDFB9A , 0x32E2A84C6097DAEE0775E233F978A588 , 0x5384EAD951A8EF30F15639ABF88841D4 , 0x486EF6C38B20121AF7F6CE4DF5A8F0F8 , 0x77EFC2D82C00F92860B2A79F210BAF40 , 0x74D32BFED819C9108FEE2CC1E87C0469 , 0xEBC6DDCEC39A2A705D73824881F4FC03 , 0xEFE9E3748F83E8F222D588C23FAC70D7 , 0x2743E957594B9347BFDC84F18B48BE54 , 0xED11F061F55EBBA2AAB0958696136D4A , 0x7A15B8B9D2253B39F0D9541DC310A6FB , 0xED7AB38D592B37A55E2CB21C7A56B16A , 0x3087E85EE726EDFF0ADCA2B273C300F8 , 0x4DD82FE37F51E2039F68A57A3EDFED5F , 0x672F62EA159B5633F385EBECD1749871 , 0xC1A4005413E103BDF6DE1CAD3696E618 , 0x413F964E848A3E6F975E855334545471 , 0x071333955AD9D761BF9B28BCCB603CE9 , 0xE31ACA7332CD5D2A872492E663693735 , 0xA87C1CAD1AEE328999257876C077A642 , 0x6FE405FED313B109C43EC37FF0575BE3 , 0x80576DE364A6ABC301261ACF4D9B684C , 0x80809BC7BEC2A5768F01434ABBFA1FC7 , 0x5C128C12CD0C392ED4C64CE075BC8143 , 0x5A9A6BB71E9A80DFAD5C1B153251AB90 , 0x84DB718294C972FF761D26ED3042B39F , 0x41C1C2B2DE861ABED3741FF17D0C288C , 0xA1BA163D97BC0FE79FC4F0239D25FBB0 , 0xDD41FA0BB3DEEDD3D3BA34F9F6D4C6E6 , 0x4996CEC1A1FA9471703954C34C0BF82F , 0xB36FABD096FDB34782184CDCB8F3C9F3 , 0xC000487138EC4B41754C75E0BE4A4D07 , 0x6A10F190329F2F7CC0A0CC40A1DAA3B5 , 0x415E91B6160CDB2390288F4B5E93E0C7 , 0x23640B959B8F6F3E8FE77BDFC1F0FD29 , 0xD3970742CE6400BF69FEE695F1F3EC9B , 0x2A7CC9966A21B132EFE2B51BF0CD88FA , 0x2611F2E065B0FF743BE6F02F6771115A , 0x263E9AFC4303800561DCA956291DCE2B , 0x365BFA9B01FBAFFF20EBCAF28125DE59 , 0x08E78818CEEFFCF7C25D8ED7A69A4901 , 0xE0C5476D7188DD56315705894E26B3A8 , 0x4B72F45A986F7EA59FCD6DDBE0ED2DDF , 0x970542C5C015DC15DC9C567CCDEF5AFA , 0x76E3A37D686E7A12E692D3C0CDBDDC3C , 0x199484671D5A390AA2787FA18CCB8727 , 0x25E8163218E6E37B314E33DC9467FD81 , 0x44F5AD8FE1F98DE6FCD7B082FA57816A , 0x30CFD4E64A6EFE121A47D25895CFBF48 , 0x04FFF2DFBE3DFE95D74B87E9570F7E93 , 0x0F1B904BEFFB7AC176DFA79D6DE30968 , 0x4430002D0A210B4EA6911D56C7941A8D , 0xF6AE867649B4D54D2D1B480D5720F2E9 , 0xAB57A82E928DAC620536168EA46A0B04 , 0x548CA3DBA49FF3CD5E0BFBA8BBD2FFEB , 0xA0C604A5549ED9C0DDDD89E078A0CC8D , 0x624192D6038B855D14F7ADD2488D50A7 , 0xEB2B22CCC18592829A1FD25DF41AABA4 , 0xBD047BF21E003B6320D0D5311C71AC28 , 0x2E9539D5DBAECC037C3DF8E3B918C33B , 0x1484217F07F4793049B2FE5EB8701044 , 0x0BDBF018F84A1A286DD6536BEBD80C61 , 0x27B66349A8C2ABFE08C6682CA88060D4 , 0x42F04A08A42450EE9D9E66557B002C21 , 0xC767F8E8219EBA220EC58C9A56A38D96 , 0xC9935485888A96C5015CFE7FF46CF686 , 0x454A571FF496615DBD0FCE423A752C73 , 0x0C56370D6BB9268968BE45DC106A8B96 , 0x0883E82E2EF27340372AEF7AF1FEA68E , 0x6C729EA21606FE6125CFD492828244BE , 0x6CF80C1D01B938513BBDC032485B76A9 , 0xC2CFDDDEF0496DD00F4D40B28B594ED8 , 0x23E51FAB7E1C55A3260D48F42EFC2C27 , 0xA70660AB3BE8BB2CBBA11F1834EEF779 , 0xEE82A9D5661FF2533240E83E8CE19633 );
Copy
3.49 ms (5.93%)
4
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )) AND (sales_channel_id = ? )
Parameters :
[
b"bAÆÍ\x03 ïà]\x14 ¸¡ÊHìPº "
b"ë+"ÌÁ…’‚š\x1F Ò]ô\x1A «¤ "
b"½\x04 {ò\x1E\x00 ;c ÐÕ1\x1C q¬( "
b".•9ÕÛ®Ì\x03 |=øã¹\x18 Ã; "
b"\x14 „!\x7F\x07 ôy0I²þ^¸p\x10 D "
b"\v Ûð\x18 øJ\x1A (mÖSkëØ\f a "
b"'¶cI¨Â«þ\x08 Æh,¨€`Ô "
b"BJ\x08 ñ$P¯Ø×fU{\x00 ,! "
b"Ãg°Þ!×║"\x0E ┼îÜVúìû "
b"É“T…ˆŠ–Å\x01 \þ\x7F ôlö† "
b"EJW\x1F ô–a]½\x0F ÎB:u,s "
b"\f V7\r k¹&‰h¾EÜ\x10 j‹– "
b"\x08 ƒè..òs@7*ïzñþ¦Ž "
b"lrž¢\x16\x06 þa%ÏÔ’‚‚D¾ "
b"lø\f\x1D\x01 ¹8Q;½À2H[v© "
b"ÂÏÝÞðImÐ\x0F M@²‹YNØ "
b"#å\x1F «~\x1C U£&\r Hô.ü,' "
b"§\x06 `«;è»,»¡\x1F\x18 4î÷y "
b"\x01 ɪJ£&pò▓Ãè ÌôÜÓ "
]
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (0x624192D6038B855D14F7ADD2488D50A7 , 0xEB2B22CCC18592829A1FD25DF41AABA4 , 0xBD047BF21E003B6320D0D5311C71AC28 , 0x2E9539D5DBAECC037C3DF8E3B918C33B , 0x1484217F07F4793049B2FE5EB8701044 , 0x0BDBF018F84A1A286DD6536BEBD80C61 , 0x27B66349A8C2ABFE08C6682CA88060D4 , 0x42F04A08A42450EE9D9E66557B002C21 , 0xC767F8E8219EBA220EC58C9A56A38D96 , 0xC9935485888A96C5015CFE7FF46CF686 , 0x454A571FF496615DBD0FCE423A752C73 , 0x0C56370D6BB9268968BE45DC106A8B96 , 0x0883E82E2EF27340372AEF7AF1FEA68E , 0x6C729EA21606FE6125CFD492828244BE , 0x6CF80C1D01B938513BBDC032485B76A9 , 0xC2CFDDDEF0496DD00F4D40B28B594ED8 , 0x23E51FAB7E1C55A3260D48F42EFC2C27 , 0xA70660AB3BE8BB2CBBA11F1834EEF779 )) AND (sales_channel_id = 0x0190A64A9C267095B2C78AFFDE939AE0 );
Copy
3.25 ms (5.52%)
4
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 "
"EUR "
]
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' , 'EUR' ));
Copy
1.69 ms (2.87%)
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/Griebl,%20Norbert "
"/author/Griebl,%20Norbert "
"https://hauptbuchhandlung.staging.eurosoft.network/author/Griebl,%20Norbert "
"https://hauptbuchhandlung.staging.eurosoft.network//author/Griebl,%20Norbert "
"/author/Griebl,%20Norbert "
"//author/Griebl,%20Norbert "
"author/Griebl,%20Norbert "
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/Griebl,%20Norbert' , '/author/Griebl,%20Norbert' , 'https://hauptbuchhandlung.staging.eurosoft.network/author/Griebl,%20Norbert' , 'https://hauptbuchhandlung.staging.eurosoft.network//author/Griebl,%20Norbert' , '/author/Griebl,%20Norbert' , '//author/Griebl,%20Norbert' , 'author/Griebl,%20Norbert' ) 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.64 ms (2.78%)
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 ÉÑпip×ÉPí×Â\x12\x18 ¡ "
]
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 (0x0190A5D1A869709E9050A19EB61218AD );
Copy
1.35 ms (2.30%)
4
"START TRANSACTION"
"START TRANSACTION" ;
Copy
1.13 ms (1.92%)
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-02-04T06:50:37+00:00' ) OR (`show_until` > `updated_at` AND `show_until` < '2026-02-04T06:50:37+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-02-04T06:50:37+00:00' ) OR (`show_until` > `updated_at` AND `show_until` < '2026-02-04T06:50:37+00:00' )) AND `active` = '1' ; ;
Copy
1.08 ms (1.84%)
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
1.05 ms (1.78%)
1
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.translation.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
1.02 ms (1.74%)
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.99 ms (1.69%)
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.99 ms (1.68%)
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.99 ms (1.68%)
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/Griebl,%20Norbert "
"author/Griebl,%20Norbert/ "
]
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/Griebl,%20Norbert' OR seo_path_info = 'author/Griebl,%20Norbert/' ));
Copy
0.89 ms (1.51%)
1
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = ?
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = 'de-DE' ;
Copy
0.84 ms (1.43%)
4
"COMMIT"
0.80 ms (1.35%)
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.75 ms (1.28%)
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
0.74 ms (1.25%)
2
SELECT `key` , `value` FROM `app_config`
SELECT `key` , `value` FROM `app_config` ;
Copy
0.72 ms (1.22%)
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.63 ms (1.07%)
1
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ? ) AND (token = ? ) LIMIT 1
Parameters :
[
b"\x01 ‘J13£x"‰m\f p²ý;g "
"VNhWc5XH49ZmB4QdFS5nW4g180BmmMzv "
]
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0x01914A3133A37822896D0C70B2FD3B67 ) AND (token = 'VNhWc5XH49ZmB4QdFS5nW4g180BmmMzv' ) LIMIT 1 ;
Copy
0.60 ms (1.01%)
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.58 ms (0.98%)
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.57 ms (0.97%)
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.57 ms (0.97%)
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.56 ms (0.95%)
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.56 ms (0.95%)
2
SELECT LOWER (HEX (parent_id )) FROM language WHERE id = ?
Parameters :
[
"0190a5d21558701cb17a1f89991d17e2 "
]
SELECT LOWER (HEX (parent_id )) FROM language WHERE id = '0190a5d21558701cb17a1f89991d17e2' ;
Copy
0.55 ms (0.93%)
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.55 ms (0.93%)
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.54 ms (0.92%)
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.50 ms (0.86%)
1
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = ?
Parameters :
[
"VNhWc5XH49ZmB4QdFS5nW4g180BmmMzv "
]
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = 'VNhWc5XH49ZmB4QdFS5nW4g180BmmMzv' ;
Copy
0.50 ms (0.85%)
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
0.50 ms (0.84%)
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/Griebl,%20Norbert "
]
SELECT path_info pathInfo , seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (sales_channel_id = 0x01914A3133A37822896D0C70B2FD3B67 ) AND (path_info = '/author/Griebl,%20Norbert' ) AND (is_canonical = 1 ) LIMIT 1 ;
Copy
0.46 ms (0.79%)
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.45 ms (0.76%)
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.41 ms (0.69%)
1
SELECT path FROM category WHERE id = ?
Parameters :
[
b"\x01 æÄC\¼t«ÉÍ_£Ûd╬y "
]
SELECT path FROM category WHERE id = 0x01918E435CAC74AE90D65F9CEA64CE79 ;
Copy
0.37 ms (0.62%)
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.34 ms (0.59%)
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.32 ms (0.55%)
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.30 ms (0.51%)
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.25 ms (0.43%)
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.25 ms (0.42%)
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.25 ms (0.42%)
1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1 ;
Copy
0.25 ms (0.42%)
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.18 ms (0.31%)
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