14.39 ms (21.65%)
20
SELECT `currency` . `id` as `currency.id` , `currency` . `factor` as `currency.factor` , `currency` . `symbol` as `currency.symbol` , `currency` . `iso_code` as `currency.isoCode` , `currency` . `position` as `currency.position` , `currency` . `tax_free_from` as `currency.taxFreeFrom` , `currency` . `item_rounding` as `currency.itemRounding` , `currency` . `total_rounding` as `currency.totalRounding` , `currency` . `created_at` as `currency.createdAt` , `currency` . `updated_at` as `currency.updatedAt` , `currency.translation.shortName` , `currency.translation.shortName` as `currency.shortName` , `currency.translation.name` , `currency.translation.name` as `currency.name` , `currency.translation.customFields` , `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation` . `currency_id` , `currency.translation` . `short_name` as `currency.translation.shortName` , `currency.translation` . `name` as `currency.translation.name` , `currency.translation` . `custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation` . `language_id` = ? ) `currency.currency_translation` ON `currency.currency_translation` . `currency_id` = `currency` . `id` WHERE (`currency` . `iso_code` IN (? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
"CHF "
]
SELECT `currency` . `id` as `currency.id` , `currency` . `factor` as `currency.factor` , `currency` . `symbol` as `currency.symbol` , `currency` . `iso_code` as `currency.isoCode` , `currency` . `position` as `currency.position` , `currency` . `tax_free_from` as `currency.taxFreeFrom` , `currency` . `item_rounding` as `currency.itemRounding` , `currency` . `total_rounding` as `currency.totalRounding` , `currency` . `created_at` as `currency.createdAt` , `currency` . `updated_at` as `currency.updatedAt` , `currency.translation.shortName` , `currency.translation.shortName` as `currency.shortName` , `currency.translation.name` , `currency.translation.name` as `currency.name` , `currency.translation.customFields` , `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation` . `currency_id` , `currency.translation` . `short_name` as `currency.translation.shortName` , `currency.translation` . `name` as `currency.translation.name` , `currency.translation` . `custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `currency.currency_translation` ON `currency.currency_translation` . `currency_id` = `currency` . `id` WHERE (`currency` . `iso_code` IN ('CHF' ));
Copy
10.39 ms (15.63%)
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
5.25 ms (7.90%)
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/bcfd9e4cc9c3d34bd5fa5835a88fef91 "
"/detail/cf990630ca6989fd065a783bb692c0cc "
"/detail/295fda2148c4b34f4cca258db89bec68 "
"/detail/c40fd769dad93ab9637db9a40201707f "
"/detail/d3143344fae016b51943307972b1edce "
"/detail/53188a5959a3373848b7bb6fb3cd14dd "
"/detail/bd91479346572002196271951b87129e "
"/detail/79b75c846a5d925f3aa8f7708af38374 "
"/detail/f6ff9f17d0a225a3f20d6c72fed2e617 "
"/detail/f90ba21ca4390586406a8ad3e2a07692 "
"/detail/fa5d0b53e6d71b5b42ee3ffc751660d6 "
"/detail/33d102795354c6fe161528c5b47b5dab "
"/detail/2395ee2bc7d3bd56d8b93208797fafda "
"/detail/e331934e3d83c33e9de72a7fd90c9b11 "
"/detail/382face9b33c8849631214d7a25fcd02 "
"/detail/272095005f5e5c1039b65c58d442033b "
"/detail/9cc0b2e705478b47d23d88957c89f680 "
"/detail/cfb7b819e79b376c631ad44e82164ac7 "
"/detail/221a70466e85e6cdbd2b0e7f3746348c "
"/detail/c745a4cbc9f776737b8adff6f6a6e9fb "
"/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/bcfd9e4cc9c3d34bd5fa5835a88fef91' , '/detail/cf990630ca6989fd065a783bb692c0cc' , '/detail/295fda2148c4b34f4cca258db89bec68' , '/detail/c40fd769dad93ab9637db9a40201707f' , '/detail/d3143344fae016b51943307972b1edce' , '/detail/53188a5959a3373848b7bb6fb3cd14dd' , '/detail/bd91479346572002196271951b87129e' , '/detail/79b75c846a5d925f3aa8f7708af38374' , '/detail/f6ff9f17d0a225a3f20d6c72fed2e617' , '/detail/f90ba21ca4390586406a8ad3e2a07692' , '/detail/fa5d0b53e6d71b5b42ee3ffc751660d6' , '/detail/33d102795354c6fe161528c5b47b5dab' , '/detail/2395ee2bc7d3bd56d8b93208797fafda' , '/detail/e331934e3d83c33e9de72a7fd90c9b11' , '/detail/382face9b33c8849631214d7a25fcd02' , '/detail/272095005f5e5c1039b65c58d442033b' , '/detail/9cc0b2e705478b47d23d88957c89f680' , '/detail/cfb7b819e79b376c631ad44e82164ac7' , '/detail/221a70466e85e6cdbd2b0e7f3746348c' , '/detail/c745a4cbc9f776737b8adff6f6a6e9fb' , '/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.95 ms (7.45%)
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"╝²×L╔├ËKı·X5¿Å´æ "
b"Ï™\x06 0Êi‰ý\x06 Zx;¶’ÀÌ "
b")_┌!H─│OL╩%ì©øýh "
b"Ä\x0F ×iÚÙ:¹c}¹¤\x02\x01 p\x7F "
b"Ó\x14 3Dúà\x16 µ\x19 C0yr±íÎ "
b"S\x18 ŠYY£78H·»o³Í\x14 Ý "
b"½‘G“FW \x02\x19 bq•\e ‡\x12 ž "
b"y·\„j]’_:¨÷pŠóƒt "
b"öÿŸ\x17 Т%£ò\r lrþÒæ\x17 "
b"ù\v ¢\x1C ¤9\x05 †@jŠÓâ v’ "
b"ú]\v Sæ×\e [Bî?üu\x16 `Ö "
b"3Ñ\x02 ySTÆþ\x16\x15 (Å´{]« "
b"#•î+ÇÓ½Vع2\x08 y\x7F ¯Ú "
b"Ò1ôN=â├>Øþ*\x7F ┘\f ø\x11 "
b"8/¬é³<ˆIc\x12\x14 ×¢_Í\x02 "
b"' •\x00 _^\\x10 9¶\XÔB\x03 ; "
b"œÀ²ç\x05 G‹GÒ=ˆ•|‰ö€ "
b"Ï·¸\x19 ç›7lc\x1A ÔN‚\x16 JÇ "
b""\x1A pFn…æÍ½+\x0E\x7F 7F4Œ "
b"ÇE¤ËÉ÷vs{Šßöö¦éû "
]
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 (0xBCFD9E4CC9C3D34BD5FA5835A88FEF91 , 0xCF990630CA6989FD065A783BB692C0CC , 0x295FDA2148C4B34F4CCA258DB89BEC68 , 0xC40FD769DAD93AB9637DB9A40201707F , 0xD3143344FAE016B51943307972B1EDCE , 0x53188A5959A3373848B7BB6FB3CD14DD , 0xBD91479346572002196271951B87129E , 0x79B75C846A5D925F3AA8F7708AF38374 , 0xF6FF9F17D0A225A3F20D6C72FED2E617 , 0xF90BA21CA4390586406A8AD3E2A07692 , 0xFA5D0B53E6D71B5B42EE3FFC751660D6 , 0x33D102795354C6FE161528C5B47B5DAB , 0x2395EE2BC7D3BD56D8B93208797FAFDA , 0xE331934E3D83C33E9DE72A7FD90C9B11 , 0x382FACE9B33C8849631214D7A25FCD02 , 0x272095005F5E5C1039B65C58D442033B , 0x9CC0B2E705478B47D23D88957C89F680 , 0xCFB7B819E79B376C631AD44E82164AC7 , 0x221A70466E85E6CDBD2B0E7F3746348C , 0xC745A4CBC9F776737B8ADFF6F6A6E9FB ));
Copy
4.25 ms (6.40%)
1
SELECT `meta_catalog_id` . `id` FROM `meta_catalog_id` WHERE `meta_catalog_id` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"\x0E nÔr\x05 HÔÓd\x12 ,‚wt“µ "
b"ÀüÚÿ\v g\x18\x1C ╠?┘õ$¸Á░ "
b"QàTXqª]¢Yï<H\f Œ\x02 ¡ "
b"7Ó\x0E iùÓ?£½6\x1E \r ¥“‰\x7F "
b"Ä …¼°–»\x7F ]èÒ£ÌX{o "
b"H\x18 œ†½Ø‹ãâ2\x14 "p¶sj "
b"ø3‡\x15 ú\x12\x01 µY°ƒ,+†ê\x01 "
b"ÛÎÅNË×fö#█ÌêwKü\x04 "
b"\t û™\x18 n\x00 ñ\x06 õàMóó…æG "
b"ì\x7F zîô\x05 ¬~\x12 hËëãX\x12 6 "
b"€\e ¥ ôCfsS>îFµ|^@ "
b"/™"¡¨â¡e\x03 i\e $ëñ§: "
b"6÷k├ÅehxY╝0\x08\x7F ¿ø6 "
b"™R×dsåˆøHs,›{eýP "
b"êÝ„\x16 &»Ô|ƒÖi[\x0F ‘y "
b"Š\x00 :;ƪKZ¬ê\x19 ³Êw©º "
b"N¬´°\x0F ˜!\x17 Ð\A"Ù\e 8E "
b"d\x02 Îõ„K’Èßàéö3"ok "
b"ç\x17 \x1F Û}€—Å›[`8Äl5 "
b"ÈÙœ\x11 @¦ô^¡Üš5ñ¨‡‘ "
b"\x1F Éü\t n¹(ò±´"h£\x08\x13 U "
b"Á߆+Þ\¶Ú&\x1C b|‘ª›\x13 "
b"üès0}²L\x1E\x19 ,ŒdÅEÜé "
b"#¬¬o”\x16 ?ÆÈ0èwí\x0F ÀC "
b"¤ÑÁØB±¼ü®ú®#ü3}è "
b"N‡•“ø\x18\x0F Vr8ß:,jh¸ "
b"É.¹¸Ü0vX”ÒV8X]Þš "
b"é\x1A ‡ïÂk" BéÙ[ú7§¤ "
b"xáð╦Å »Z▄)¡#¤Ð¹? "
b"▒╩,-\x00 ¨é³\x12 ø¨░û¥Ø, "
b"Á#c™#9ÑWÚWÝ\x12 »j_Q "
b"µB»,LÈ|°ÔÔ£P\x18 È¡\x04 "
b"ç§sÙÐÒƒÉöÇ-\x1D yıh' "
b"á唞Mí"‰I/¤Z÷°·Î "
b"""
W\x7F “}úºDÃì\x13 \n
_!hÄV
"""
b"“p}`\x10 Û÷uX\x7F ž,v-«Ä "
b"\x02 ■i¤ÏÑâ©T‗®þ¦Ø!` "
b"ˆÎçkÉÿô@O-pïz²", "
b"Óš¾žÈ\x03 hŒx\e\x17 i¼¯Ò\x7F "
b"±TjÆé~²\x13 ¦6ä‘ál>¸ "
b"/Æv³˜]Ð\x7F ?i&!Z\x17 Ñ\x14 "
b"╬┘(\t ÷▒D|\x12 [ÉdÓ-Î "
b"\x13 ×\r aÛÉV\x03 G1f\x14 ò³ð "
b"3gÏ\x1F xå-]f<XÅ7«×\e "
b"å\x15 é▒^2D¿ØÚ\x14\x13 /]\x1E Ù "
b"äû\x16 »óÉȾ\x15 õ\x08 ”²ÎÒ\x1D "
b"2Àë═½°Ø\x16 ÅËTÕ\x0E ´³y "
b"DjEòñ^\t BMÎ^ÙÕ'/h "
b"S¤è}6\u\x03 ÏÄ^ƒÇõ÷¾ "
b"ÿ„7öTâÙpÒJ¨).¶Ÿ' "
b"âLd\x16 ^®\x17 Æg¢\x7F xh0d_ "
b"¤\x1F áû\v ´\t Tª\v ñËÙ\x7F Jþ "
b"â\x00 K5»\x10 €rS06G|òÄB "
b"KrôZ˜o~¥ŸÍmÛàí-ß "
b"¬Öõ¶(±·\x16 aw¦ÿâ/\x11 œ "
b"=)zèú¤7ðL?84€€mÈ "
b"""
ìrqï‰\x13 R\n
Á.CàψºÊ
"""
b"ªõhË\x17 höÒX5CݸN\x07\x0F "
b"%\r @ Ås@þX¡›²\x05 £²\x08 "
b"¸š•,\x06 Žç5\x05 ¢ØNö+\x1A ˆ "
b"2ûgœXveL)y¦\x7F ~ªÈw "
b"\x05 —\x07 µ¸N?\x12 ?\x03\x08 #ŠÀ\x05 ç "
b"EI¹┘²Ì\x12 ´\x00 åxVrSáÉ "
b"a®Ó\x02 F±Ô*e¨▄UæõØ0 "
b"ð(~\t IÛøÐ¢fç§8Öð% "
b"ù0{T/I„âíÖòµ{Tÿ\x05 "
b"¾çëÇÔ¨˜?‡] ½\f ò4f "
b"ÇÒq„\v ò©aÚÝ|•€ø¼W "
b"3ƒgÄ®9:V▄ôD²\x05 òRì "
b"79\x19 Yæ"8šÜ@Óä‘’\x0F ¿ "
b"ÊãˆT1z4xAñ=\t ð\x14 äÈ "
b"µ«Ç\x16 ╠Û³\x10 âb╬Å┌ùm0 "
b"\x1A †‘¹ËO±%‰}BÃå×u‚ "
b"¸A\x05 <Ø÷#ê¹═¡ÌúÊK\x15 "
b"""
\x02 )ɉ\x12 ÿ¿˜\n
ƒA\x03\t ¹\x07 è
"""
b"e\x13 ¥x!âÑ,Æö¿nÕ«\f ¿ "
b"\x10 ÊE\x17 ïÏÏànÃÛz0ÝÙU "
b"çÑëI\x7F H.’;©\x00 2¶Ñ7 "
b"ÝAú\v ³ÞíÓÓº4ùöÔÆæ "
b"\x12\f °ã\x0E CêY\x07 1}oÝî½\x07 "
b"B¸„y7Ù\x10\x04 =\x18 kRŸÊÖf "
b"\x07\x01 (\x03 éÖV¬ØÁË\e u¶\x0F D "
b"ø˜"-xÃ\x07 ïß\x08 ¸Kú\è~ "
b"’\f Õ\x13 ·©2_<„EwÂZÐí "
b"""
\x1A ß:\x7F ìNgß+\x12 ¸#\n
Ò#ï
"""
b"Æ5\x16 ‡ë/*\x1D Ò\x04 ±¨É”Rô "
b"‹Û¨”‡t-LU4P8²÷\r Q "
b"ç\x00 ¸àv\x08 É7hû╦öLHXm "
b")¼;±#Ç{ßkšœ«ÿaõà "
b"öÕ:jN9x|ÉB¯×M¬ä\ "
b"GxDéθ+Å$s\x1D FÝä·± "
b"âNd\x0E Õ\x1E\f ¿éÉ{\x15 òNk\x15 "
b"{f>K€¨v?\x03 6²$®£6‹ "
b"\x0E o½\x1A ├Ð╗\x12 ÅÐtI║Çñ "
b"""
kj_é#D´9¦…\n
²{7øÜ
"""
b"s¬é”7Ñ\x12\x18 ™Òé„\x17 ÍÅç "
b"\x1A ‡‡S\x1D {%äEOdK}Õ,¸ "
b"ýýî%É×\x1D –\x00 #“Î\x05 FÔr "
b"\x7F ÈÂ\x12 â#qpŒ7Ûq1!X§ "
b"""
+\t a±»<wÏ\n
QÕÿk`+„
"""
b"═}S¦\r ®L╩;É┬ç0¢÷¯ "
b"\x7F Æ•1\x1C ÜOt¥æðT¶\x00 Q„ "
b"\x15 ‘Ux¥+0ç]çøßŒ±"N "
b" Š4@ÔÇq8Ñ©0ó#ýǧ "
b"÷W’\t úàTawùN>Šb°õ "
b"b˜\x0F =[ pI\x1E œô\x11 XÖ®´ "
b"G┴,\x05 }3Q▀ñj┬·═┌ìs "
b"ÄW‘}2Že$H\x7F N¨#¿\x17 ê "
b"┬Þ╬ü:\x03 \r \x05 ô}âxW)8╣ "
b"5©e\x15 b·u\x0E ’,ùÒ\x0E ä÷\r "
b"]ö®\t ÙKí\x17 èqh)û·╠ì "
b"\e\v {?sÊ?C7Ž,4–\x18 ' "
b"7rq\f 5Z\x05 ª\DäáÙGNö "
b"ÃÛ_\x02 ░Tz4>Z³ÜÏüu£ "
b"%u|êNPB¶Ä\x00 &\x04 -@\x04 Ü "
b"Ùã¦╬├Ü*p]séHü¶³\x03 "
b"»é6å’\x01 lǹµñ@\x19 n~« "
b"0‡è^ç&íÿ\n Ü¢²sÃ\x00 ø "
b"=µL,g\x01 ]-«KÈîR\x1D ®û "
b"ïóL÷\x12 +‘œáåÒ\x1C\x0E\x01 :t "
b"6wÖ¡*ò\x1A +·Óòü—€ÕÄ "
b"(Å▀Z┬▒2Ëà'\f É▀1\v ½ "
b"–;šqfIµ\x04 ¤vÁ¿]{F× "
b"w3S\x00 )«ü═s5y½┐®5ý "
b"ÙFÎ\x07 [Õ\e ‰`aÑ\t Êžô\x03 "
b"¤ín└─\x01 J\x05 1Ùg\x15 Â5¬Ø "
b"+úŠ_\x17 ¥\x01 áP'8\x02\x18 \г "
b"M\x7F\x00 ¦pëWÔÖ“bÞ¾B`Ý "
b"«ÖÐ\x04 ¢r®\x1D o;’1Ûì.? "
b"÷Ž‘•´¯ÝHÙ\x08 4\x1D ÈízÇ "
b"-¿„\x03 5+nÊul~\x1A ô\x0F â8 "
b"q\x1F Ây)OÐ×ý*\x11 ICÊ™ð "
b"—}ßb\x0E >\x10 Äç\x06 0ɉå§\x12 "
b"Êâzg\x1F ,VÒ¦ŒPcKª\x0E "
b"\x11 µ—>â\x03 Ÿ\x7F #›Ha\x03 ›³œ "
b"\x06 èz─\x10 jüËôvQTÿ2Ê\f "
b"{¡bó\f\x1F fnJGÉ÷›\x16 0é "
b"\x10 °þ©ë6¶Ÿy^Ë-„Å\x01 7 "
b"\x0F\x11 Õ®0\x07 ïÂâ\x15 CŒHŒO° "
b",íÌŒã\v ‰Äìþ_\x05 1y“} "
b"""
—Ä“\x15 êñÊQ\n
ÊW&ˆ\f ׿
"""
b"TŒ£Û¤ŸóÍ^\v û¨»Òÿë "
b"╝²×L╔├ËKı·X5¿Å´æ "
b"Ï™\x06 0Êi‰ý\x06 Zx;¶’ÀÌ "
b")_┌!H─│OL╩%ì©øýh "
b"Ä\x0F ×iÚÙ:¹c}¹¤\x02\x01 p\x7F "
b"Ó\x14 3Dúà\x16 µ\x19 C0yr±íÎ "
b"S\x18 ŠYY£78H·»o³Í\x14 Ý "
b"½‘G“FW \x02\x19 bq•\e ‡\x12 ž "
b"y·\„j]’_:¨÷pŠóƒt "
b"öÿŸ\x17 Т%£ò\r lrþÒæ\x17 "
b"ù\v ¢\x1C ¤9\x05 †@jŠÓâ v’ "
b"ú]\v Sæ×\e [Bî?üu\x16 `Ö "
b"3Ñ\x02 ySTÆþ\x16\x15 (Å´{]« "
b"#•î+ÇÓ½Vع2\x08 y\x7F ¯Ú "
b"Ò1ôN=â├>Øþ*\x7F ┘\f ø\x11 "
b"8/¬é³<ˆIc\x12\x14 ×¢_Í\x02 "
b"' •\x00 _^\\x10 9¶\XÔB\x03 ; "
b"œÀ²ç\x05 G‹GÒ=ˆ•|‰ö€ "
b"Ï·¸\x19 ç›7lc\x1A ÔN‚\x16 JÇ "
b""\x1A pFn…æÍ½+\x0E\x7F 7F4Œ "
b"ÇE¤ËÉ÷vs{Šßöö¦éû "
b"""
©€ðT_\n
jí\x10 8 Ìÿ»Šz
"""
b"H\x1C ¼°Ô{Qüæ\x19 ©2'\x08 W "
b"""
\n
\x02 `g╔\r 5ÝðÀƒØx÷¡r
"""
b"›‰ä#ÛÄbG8q\t (Ån½² "
]
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 (0x0E6ED4720548D4D364122C82777493B5 , 0xB781E9980B67181CCC3FD9E424F7B5B0 , 0x51E0545871AA5DA259EF3C480C8C02A1 , 0x37D30E69F9D33FA3BD361E0DA593897F , 0xC4A085BCB096BB7F5DE8D2A3CC587B6F , 0x48189C86BDD88BE3E232142270B6736A , 0xF8338715FA1201B559B0832C2B86EA01 , 0xEAD78F4ED39E669423DBDE88774B8104 , 0x09FB99186E00F106F5E04DF3F385E647 , 0xEC7F7AEEF405AC7E1268CBEBE3581236 , 0x801BA5A0F4436673533EEE46B57C5E40 , 0x2F9922A1A8E2A16503691B24EBF1A73A , 0x36F66BC38F65687859BC30087FA89B36 , 0x9952D76473E588F848732C9B7B65FD50 , 0xEADD8416A026BBD47C83D6695B0F9179 , 0x8A003A3BC6AA4B5AACEA19B3CA77A9BA , 0x4EACB4B00F982117D05C4122D91B3845 , 0x6402CEF5844B92C8DFE0E9F633226F6B , 0xE717AD1FDB7D8097C59B5B6038C46C35 , 0xC8D99C1140A6F45EA1DC9A35F1A88791 , 0x1F9081096EFB2895F1EF22689C081355 , 0xC1DF862BDE5CB6DA261C627C91AA9B13 , 0xFCE873307DB24C1E192C8C64C545DCE9 , 0x23ACAC6F94163FC6C830E877ED0FC043 , 0xCFA5B59D42F1AC81A9A3A92381337D8A , 0x4E879593F8180F567238DF3A2C6A68B8 , 0xC92EB9B8DC30765894D25638585DDE9A , 0xE91A87EFC26B22A042E9D95BFA37A7A4 , 0x78A0D0CB8F20AF5ADC29AD23CFD1FB3F , 0xB1CA2C2D00F982FC129BF9B096BE9D2C , 0xC12363992339D157DA57DD12BB6A5F51 , 0xB542BB2C4CC87CB0D4D4A35018C8A104 , 0x87F573EBD1E39F9094802D1D79D56827 , 0xE1E5949E4DED2289492FA45AF7B0B7CE , 0x577F937DFABA44C3EC130A5F2168C456 , 0x93707D6010DBF775587F9E2C762DABC4 , 0x02FE69CFD8A583B854F2A9E7DD9D2160 , 0x88CEE76BC9FFF4404F2D70EF7AB2222C , 0xD39ABE9EC803688C781B1769BCAFD27F , 0xB1546AC6E97EB213A636E491E16C3EB8 , 0x2FC676B3985DD07F3F6926215A17D114 , 0xF0CED92809F6B1447C125B9064E02DD7 , 0x13F09E0D61EA9056034731661495FCD0 , 0x3367D81F78862D5D663C588F37AE9E1B , 0x861582B15E3244A89DE914132F5D1EEB , 0xE4FB16BBF3C9C8BE15F50894B2CED21D , 0x32B789CDABF89D168FD354E50EEFFC79 , 0x446A45F2F15E09424DCE5ED9D5272F68 , 0x53A4E87D365C7503CFC45E83C7F5F7BE , 0xFF8437F654E2D970D24AA8292EB69F27 , 0xE24C64165EAE17C667A27F786830645F , 0xA41FE1FB0BB40954AA0BF1CBD97F4AFE , 0xE2004B35BB108072533036477CF2C442 , 0x4B72F45A986F7EA59FCD6DDBE0ED2DDF , 0xACD6F5B628B1B7166177A6FFE22F119C , 0x3D297AE8FAA437F04C3F383480806DC8 , 0xEC7271EF8913520AC12E43E0CF88BACA , 0xAAF568CB1768F6D2583543DDB84E070F , 0x250D4020C57340FE58A19BB205A3B208 , 0xB89A952C068EE73505A2D84EF62B1A88 , 0x32FB679C5876654C2979A67F7EAAC877 , 0x059707B5B84E3F123F0308238AC005E7 , 0x4549FBD9FDDE12EF008678567253A090 , 0x61A9E00246F1E22A65F9DC5591E49D30 , 0xF0287E0949DBF8D0A266E7A738D6F025 , 0xF9307B542F4984E2EDD6F2B57B54FF05 , 0xBEE7EBC7D4A8983F875D20BD0CF23466 , 0xC7D271840BF2A961DADD7C9580F8BC57 , 0x339F678EA9393A56DC9344FD0595528D , 0x37391959E622389ADC40D3E491920FBF , 0xCAE38854317A347841F13D09F014E4C8 , 0xE6AE8016CCEAFC108362CE8FDA976D30 , 0x1A8691B9CB4FB125897D42C3E5D77582 , 0xF741053C9DF62388FBCDADDEA3D24B15 , 0x0229C98912FFBF980A83410309B907E8 , 0x6513A57821E2D12CC6F6BF6ED5AB0CBF , 0x10CA4517EFCFCFE06EC3DB7A30DDD955 , 0xE7D1EB497FA0482E923BA90032B6D137 , 0xDD41FA0BB3DEEDD3D3BA34F9F6D4C6E6 , 0x120CB0E30E43EA5907317D6FDDEEBD07 , 0x42B8847937D910043D186B529FCAD666 , 0x07012803829956AA9DB5D31B75F40F44 , 0xF898222D78C307EFDF08B84BFA5CE87E , 0x920CD513B7A9325F3C844577C25AD0ED , 0x1ADF3A7FEC4E67DF2B12B8230AD223EF , 0xC6351687EB2F2A1DD204B1A8C99452F4 , 0x8BDBA89487742D4C55345038B2F70D51 , 0x8700F785760890376896CB944C48586D , 0x29BC3BB123C77BDF6B9A9CABFF61F5C3 , 0xF6D53A6A4E39787CC942AFD74DACE45C , 0x477844E9CEB82BC524731D46DDE4B7B1 , 0x834E640EE51E0CA882907B15954E6B15 , 0x7B663E4B80A8763F0336B224AEA3368B , 0x0E6FAB1AC3D1BBF0128FD17449BA80A4 , 0x6B6A5FE92344B439A6850AB27B37F8DC , 0x73ACE99437D1121899D2E98417CDC5E7 , 0x1A8787531D7B25E4454F644B7DD52CB8 , 0xFDFDEE25C9D71D96002393CE0546D472 , 0x7FC8C212E22371708C37DB71312158A7 , 0x2B0961B1BB3C77CF0A51D5FF6B602B84 , 0xCD7D53DD0DA94CCA3B90C28730BDF6EE , 0x7FC695311CDC4F74A5E6F054B6005184 , 0x15915578A52B30E75DE7F8DF8CB1224E , 0x208A3440D4C77138D1A930F323FDC7A7 , 0xF7579209FAE0546177F94E3E8A62B0F5 , 0x62980F3D5B2070491E9CF41158D6AEB4 , 0x47C12C057D3351DFA46AC2FACDDA8D73 , 0xC457917D328E6524487F4EA823BF17EA , 0xC2E8CE813A030D05937D8378572938B9 , 0x35A9651562B7750E922CF9D20EE4F70D , 0x5D94A909EB4BA1178A71682996FACC8D , 0x1B0B7B3F73CA3F43378E2C3496AD1827 , 0x3772710C355A05AA5C44E4E1D9474EF6 , 0xC7EA5F02B0547A343E5AFC9AD881759C , 0x25757CEA4E5042B6C40026042D4004DC , 0xEBC6DDCEC39A2A705D73824881F4FC03 , 0xBBE936E592016CC7B9B5F140196E7EAB , 0x3087E85EE726EDFF0ADCA2B273C300F8 , 0x3DB54C2C67015D2DAB4BC8EE521DAEFB , 0xEFF34CF7122B919CE1E5D21C0E013A74 , 0x3677D6A12AF21A2BB7D3F2FC9780D5C4 , 0x288FDF5AC2B132D385270C90DF310BAB , 0x963B9A716649B504A476C1BF5D7B46D7 , 0x7733530029AE81CD733579ABBFA935EC , 0xD946CE075BD51B896061D109CA9EF403 , 0xCFA16EC0C4014A0531EB6715B635AA9D , 0x2BFA8A5F17A501E150273802185C8AB3 , 0x4D7F00A670EB57D4D69362DEBE4260DD , 0xABD6D004A272AE1D6F3B9231DBEC2E3F , 0xF78E9195B4AFDD48D908341DC8ED7AC7 , 0x2DBF8403352B6ECA756C7E1AF40FE238 , 0x711FC279294FD0D7FD2A114943CA99F0 , 0x977DDF620E3E10C4E70630C989E5A712 , 0xCAE27A671F2C56D2A68C50634BADAA0E , 0x11B5973EE2039F7F239B4861039BB39C , 0x068A7AC4106A81D3937651549832D20C , 0x7BA162F30C1F666E4A47C9F79B1630E9 , 0x10B0FEA9EB36B69F795ECB2D84C50137 , 0x0F11D5AE3007EFC2E215438C488C4FB0 , 0x2CEDCC8CE30B89C4ECFE5F053179937D , 0x97C49315EAF1CA510ACA5726880CD7BF , 0x548CA3DBA49FF3CD5E0BFBA8BBD2FFEB , 0xBCFD9E4CC9C3D34BD5FA5835A88FEF91 , 0xCF990630CA6989FD065A783BB692C0CC , 0x295FDA2148C4B34F4CCA258DB89BEC68 , 0xC40FD769DAD93AB9637DB9A40201707F , 0xD3143344FAE016B51943307972B1EDCE , 0x53188A5959A3373848B7BB6FB3CD14DD , 0xBD91479346572002196271951B87129E , 0x79B75C846A5D925F3AA8F7708AF38374 , 0xF6FF9F17D0A225A3F20D6C72FED2E617 , 0xF90BA21CA4390586406A8AD3E2A07692 , 0xFA5D0B53E6D71B5B42EE3FFC751660D6 , 0x33D102795354C6FE161528C5B47B5DAB , 0x2395EE2BC7D3BD56D8B93208797FAFDA , 0xE331934E3D83C33E9DE72A7FD90C9B11 , 0x382FACE9B33C8849631214D7A25FCD02 , 0x272095005F5E5C1039B65C58D442033B , 0x9CC0B2E705478B47D23D88957C89F680 , 0xCFB7B819E79B376C631AD44E82164AC7 , 0x221A70466E85E6CDBD2B0E7F3746348C , 0xC745A4CBC9F776737B8ADFF6F6A6E9FB , 0xA980F0545F0A6AED1038A0CCFFBB8A7A , 0xAD481CBCB0D47B51FCE619A932270857 , 0x0A026067C90D35EDD0B79F9D78F6AD72 , 0x9B89E423DBC4624738710928C56EBDB2 );
Copy
3.79 ms (5.71%)
4
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )) AND (sales_channel_id = ? )
Parameters :
[
b"╝²×L╔├ËKı·X5¿Å´æ "
b"Ï™\x06 0Êi‰ý\x06 Zx;¶’ÀÌ "
b")_┌!H─│OL╩%ì©øýh "
b"Ä\x0F ×iÚÙ:¹c}¹¤\x02\x01 p\x7F "
b"Ó\x14 3Dúà\x16 µ\x19 C0yr±íÎ "
b"S\x18 ŠYY£78H·»o³Í\x14 Ý "
b"½‘G“FW \x02\x19 bq•\e ‡\x12 ž "
b"y·\„j]’_:¨÷pŠóƒt "
b"öÿŸ\x17 Т%£ò\r lrþÒæ\x17 "
b"ù\v ¢\x1C ¤9\x05 †@jŠÓâ v’ "
b"ú]\v Sæ×\e [Bî?üu\x16 `Ö "
b"3Ñ\x02 ySTÆþ\x16\x15 (Å´{]« "
b"#•î+ÇÓ½Vع2\x08 y\x7F ¯Ú "
b"Ò1ôN=â├>Øþ*\x7F ┘\f ø\x11 "
b"8/¬é³<ˆIc\x12\x14 ×¢_Í\x02 "
b"' •\x00 _^\\x10 9¶\XÔB\x03 ; "
b"œÀ²ç\x05 G‹GÒ=ˆ•|‰ö€ "
b"Ï·¸\x19 ç›7lc\x1A ÔN‚\x16 JÇ "
b""\x1A pFn…æÍ½+\x0E\x7F 7F4Œ "
b"ÇE¤ËÉ÷vs{Šßöö¦éû "
b"\x01 ɪJ£&pò▓Ãè ÌôÜÓ "
]
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (0xBCFD9E4CC9C3D34BD5FA5835A88FEF91 , 0xCF990630CA6989FD065A783BB692C0CC , 0x295FDA2148C4B34F4CCA258DB89BEC68 , 0xC40FD769DAD93AB9637DB9A40201707F , 0xD3143344FAE016B51943307972B1EDCE , 0x53188A5959A3373848B7BB6FB3CD14DD , 0xBD91479346572002196271951B87129E , 0x79B75C846A5D925F3AA8F7708AF38374 , 0xF6FF9F17D0A225A3F20D6C72FED2E617 , 0xF90BA21CA4390586406A8AD3E2A07692 , 0xFA5D0B53E6D71B5B42EE3FFC751660D6 , 0x33D102795354C6FE161528C5B47B5DAB , 0x2395EE2BC7D3BD56D8B93208797FAFDA , 0xE331934E3D83C33E9DE72A7FD90C9B11 , 0x382FACE9B33C8849631214D7A25FCD02 , 0x272095005F5E5C1039B65C58D442033B , 0x9CC0B2E705478B47D23D88957C89F680 , 0xCFB7B819E79B376C631AD44E82164AC7 , 0x221A70466E85E6CDBD2B0E7F3746348C , 0xC745A4CBC9F776737B8ADFF6F6A6E9FB )) AND (sales_channel_id = 0x0190A64A9C267095B2C78AFFDE939AE0 );
Copy
1.20 ms (1.80%)
4
"START TRANSACTION"
"START TRANSACTION" ;
Copy
1.15 ms (1.73%)
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/Kremer,%20Bruno%20P. "
"/author/Kremer,%20Bruno%20P. "
"https://hauptbuchhandlung.staging.eurosoft.network/author/Kremer,%20Bruno%20P. "
"https://hauptbuchhandlung.staging.eurosoft.network//author/Kremer,%20Bruno%20P. "
"/author/Kremer,%20Bruno%20P. "
"//author/Kremer,%20Bruno%20P. "
"author/Kremer,%20Bruno%20P. "
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/Kremer,%20Bruno%20P.' , '/author/Kremer,%20Bruno%20P.' , 'https://hauptbuchhandlung.staging.eurosoft.network/author/Kremer,%20Bruno%20P.' , 'https://hauptbuchhandlung.staging.eurosoft.network//author/Kremer,%20Bruno%20P.' , '/author/Kremer,%20Bruno%20P.' , '//author/Kremer,%20Bruno%20P.' , 'author/Kremer,%20Bruno%20P.' ) 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.04 ms (1.56%)
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.01 ms (1.52%)
4
"COMMIT"
0.97 ms (1.46%)
2
SELECT `key` , `value` FROM `app_config`
SELECT `key` , `value` FROM `app_config` ;
Copy
0.89 ms (1.34%)
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.87 ms (1.30%)
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.86 ms (1.29%)
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.85 ms (1.27%)
1
SELECT LOWER (HEX (`id` )) AS `id` FROM `moorl_magazine_article` WHERE (`updated_at` IS NULL OR (`show_from` > `updated_at` AND `show_from` < '2026-04-06T06:33:31+00:00' ) OR (`show_until` > `updated_at` AND `show_until` < '2026-04-06T06:33:31+00:00' )) AND `active` = '1' ;
SELECT LOWER (HEX (`id` )) AS `id` FROM `moorl_magazine_article` WHERE (`updated_at` IS NULL OR (`show_from` > `updated_at` AND `show_from` < '2026-04-06T06:33:31+00:00' ) OR (`show_until` > `updated_at` AND `show_until` < '2026-04-06T06:33:31+00:00' )) AND `active` = '1' ; ;
Copy
0.81 ms (1.22%)
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.75 ms (1.12%)
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.64 ms (0.97%)
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.64 ms (0.96%)
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.63 ms (0.95%)
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.63 ms (0.94%)
1
SELECT custom_entity . name , custom_entity . fields , custom_entity . flags
FROM custom_entity
LEFT JOIN app ON app . id = custom_entity . app_id
WHERE (custom_entity . app_id IS NULL OR app . active = 1 ) AND custom_entity . deleted_at IS NULL ;
SELECT custom_entity . name , custom_entity . fields , custom_entity . flags
FROM custom_entity
LEFT JOIN app ON app . id = custom_entity . app_id
WHERE (custom_entity . app_id IS NULL OR app . active = 1 ) AND custom_entity . deleted_at IS NULL ;
;
Copy
0.61 ms (0.92%)
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.59 ms (0.89%)
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.86%)
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/Kremer,%20Bruno%20P. "
"author/Kremer,%20Bruno%20P./ "
]
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/Kremer,%20Bruno%20P.' OR seo_path_info = 'author/Kremer,%20Bruno%20P./' ));
Copy
0.57 ms (0.85%)
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.55 ms (0.83%)
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.81%)
1
SELECT `delivery_time` . `id` as `delivery_time.id` , `delivery_time` . `min` as `delivery_time.min` , `delivery_time` . `max` as `delivery_time.max` , `delivery_time` . `unit` as `delivery_time.unit` , `delivery_time` . `created_at` as `delivery_time.createdAt` , `delivery_time` . `updated_at` as `delivery_time.updatedAt` , `delivery_time.translation.name` , `delivery_time.translation.name` as `delivery_time.name` , `delivery_time.translation.customFields` , `delivery_time.translation.customFields` as `delivery_time.customFields` FROM `delivery_time` LEFT JOIN (SELECT `delivery_time.translation` . `delivery_time_id` , `delivery_time.translation` . `name` as `delivery_time.translation.name` , `delivery_time.translation` . `custom_fields` as `delivery_time.translation.customFields` FROM `delivery_time_translation` `delivery_time.translation` WHERE `delivery_time.translation` . `language_id` = ? ) `delivery_time.delivery_time_translation` ON `delivery_time.delivery_time_translation` . `delivery_time_id` = `delivery_time` . `id` WHERE `delivery_time` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 ÉÑð║Ñqhô?6:■Ã,\x02 "
]
SELECT `delivery_time` . `id` as `delivery_time.id` , `delivery_time` . `min` as `delivery_time.min` , `delivery_time` . `max` as `delivery_time.max` , `delivery_time` . `unit` as `delivery_time.unit` , `delivery_time` . `created_at` as `delivery_time.createdAt` , `delivery_time` . `updated_at` as `delivery_time.updatedAt` , `delivery_time.translation.name` , `delivery_time.translation.name` as `delivery_time.name` , `delivery_time.translation.customFields` , `delivery_time.translation.customFields` as `delivery_time.customFields` FROM `delivery_time` LEFT JOIN (SELECT `delivery_time.translation` . `delivery_time_id` , `delivery_time.translation` . `name` as `delivery_time.translation.name` , `delivery_time.translation` . `custom_fields` as `delivery_time.translation.customFields` FROM `delivery_time_translation` `delivery_time.translation` WHERE `delivery_time.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `delivery_time.delivery_time_translation` ON `delivery_time.delivery_time_translation` . `delivery_time_id` = `delivery_time` . `id` WHERE `delivery_time` . `id` IN (0x0190A5D0BAA57168933F363AFEC72C02 );
Copy
0.53 ms (0.80%)
1
SELECT path FROM category WHERE id = ?
Parameters :
[
b"\x01 æÄC\¼t«ÉÍ_£Ûd╬y "
]
SELECT path FROM category WHERE id = 0x01918E435CAC74AE90D65F9CEA64CE79 ;
Copy
0.52 ms (0.79%)
1
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = ?
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = 'de-DE' ;
Copy
0.51 ms (0.76%)
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.50 ms (0.76%)
2
SELECT LOWER (HEX (parent_id )) FROM language WHERE id = ?
Parameters :
[
"0190a5d21558701cb17a1f89991d17e2 "
]
SELECT LOWER (HEX (parent_id )) FROM language WHERE id = '0190a5d21558701cb17a1f89991d17e2' ;
Copy
0.49 ms (0.74%)
1
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ? ) AND (token = ? ) LIMIT 1
Parameters :
[
b"\x01 ‘J13£x"‰m\f p²ý;g "
"nOS0dZU6nqKtLQtpIgn3M4Z1cun3Nq2k "
]
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0x01914A3133A37822896D0C70B2FD3B67 ) AND (token = 'nOS0dZU6nqKtLQtpIgn3M4Z1cun3Nq2k' ) LIMIT 1 ;
Copy
0.42 ms (0.63%)
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.41 ms (0.62%)
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.37 ms (0.55%)
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
0.36 ms (0.54%)
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.34 ms (0.52%)
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/Kremer,%20Bruno%20P. "
]
SELECT path_info pathInfo , seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (sales_channel_id = 0x01914A3133A37822896D0C70B2FD3B67 ) AND (path_info = '/author/Kremer,%20Bruno%20P.' ) AND (is_canonical = 1 ) LIMIT 1 ;
Copy
0.33 ms (0.50%)
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.33 ms (0.50%)
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.30 ms (0.45%)
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.29 ms (0.44%)
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.28 ms (0.43%)
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.28 ms (0.41%)
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.27 ms (0.41%)
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.27 ms (0.41%)
1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1 ;
Copy
0.27 ms (0.40%)
1
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = ?
Parameters :
[
"nOS0dZU6nqKtLQtpIgn3M4Z1cun3Nq2k "
]
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = 'nOS0dZU6nqKtLQtpIgn3M4Z1cun3Nq2k' ;
Copy