16.01 ms (22.71%)
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
8.54 ms (12.11%)
1
SELECT `meta_catalog_id` . `id` FROM `meta_catalog_id` WHERE `meta_catalog_id` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"ÀüÚÿ\v g\x18\x1C ╠?┘õ$¸Á░ "
b"I║\fË\x07 A¨\x17 r}@|]ü. "
b"ó\x06 :Õà45\t ôåôCŠ U´ "
b"A-2裳§HEZɾ┌yf╠ "
b"QàTXqª]¢Yï<H\f Œ\x02 ¡ "
b"ab|ïbظ\x01 dr┬s&▓n╗ "
b"~˜äS®(£ ;L\x15 Œýº^– "
b"P¶µ@\x1C ðFå÷HŸ€Ðª„\x10 "
b"UhÉ5×¹êÏ\x11 »oº8Å\x1E\x10 "
b"5Wæ@ò’\x18 ç—$*l%^Iæ "
b"pŠ\x16 QÍšŽÍìM6nE—e\x12 "
b"ª¤‚<‘QQ\t Mnœ‚ž%kZ "
b"‡ê¬\x0E\x7F .f;•%oK€Ç‰ð "
b"\x0E nÔr\x05 HÔÓd\x12 ,‚wt“µ "
b"\x7F\x01 ©wÚøÝêqÖQyê\x17 »! "
b"ð!.¥O\x13 7ÀB3©)&ßa\x02 "
b"X¨\x1F Ñz¤\x01 [„iè\x13\x04 :¹! "
b"NØåºô`wÂ]Kë°@øþ2 "
b"\x01 ¦º"Ç\x11 :ú¶5`}D,… "
b"\x1E Æ\x1F éP }°ïÏ.¯gmx] "
b"ªk¨Ê8-\x06\x15 WsðÑŒ>9‘ "
b"Ï_âpGmÜ\e 4…Ξþï·r "
b"hûÙ£!/Áa\x15 ë\r \x0F\x1E $AÙ "
b"’84”E7LÂJéŽ\x02 1h¥1 "
b"0.™\x11 2\x13 K%\x14 Sé¸\x11 Vu} "
b"\x00 ØmCóªúÇ║\x08 Á6░z`U "
b"ž.cŠZ?EQ“©ó\v aN\x13 d "
b"\x02 í}%Tó„\x00\x10\e Lë5ÏúE "
b"n¬ZÜS {x8ë‹àÒƒ\x1F Ö "
b"ËÄ[s>Ï ]³B%áÛ\x1C @¡ "
b"±b~Æ«Úiݤ'▄\x12 PüÓk "
b"L’"Z”‰Êþ\t )\x14 À[Õ„Ž "
b"zþVPœ[ÿ9èq\x0F ½—vï "
b"r³½Ì\x1E K2pËq5ï/3÷ "
b";5{¹…w»\x05 #zçè¦o5› "
b"'ÿš{×½üŒÂ;“ä…\x17 H "
b"\e ^ÆÞ‡\x14 ¦[·ë´Þ‹bÕ "
b"ç\x17 \x1F Û}€—Å›[`8Äl5 "
b"d\x02 Îõ„K’Èßàéö3"ok "
b"ÈÙœ\x11 @¦ô^¡Üš5ñ¨‡‘ "
b"\x1F Éü\t n¹(ò±´"h£\x08\x13 U "
b"Ïl\x00 ÏóK*\x15 5ؽü\x03 ¶Ùß "
b"┬È#O\v 8\x03 G6,\x17 Øüåéo "
b"7Ü}´Ô\x15 •7ÿ³\x03 º\x15\x1F ÃY "
b"\x19 Ê2€Âÿ™À¤„\x13 /𙬠"
b"—¥L‹›±xgº©\x12 Y\x1E\x7F ÂZ "
b"¥Ð‚{8\x12 W\f [0\x14 Y9×\x12\x04 "
b"\x13 ³=lÄÕ¤$‹\x02 âpgz\x10 ÿ "
b"ŽÊqtxOUR~H\x16 p\v ™ ; "
b"â#Æ\x1D ª:‡ÆµˆÅÛ[%sX "
b"G\x1C nõ@Ó┤åçɲÖüß.¿ "
b" ›‘\x00 ¡‚9lÔ\x16 ^à©\x12 .Ž "
b" eø'¬eÏ3\x05 —MÜŒPhË "
b"lÅVh6X±¢╔A·^·▄\t ╗ "
b"žeÔd-ûœ¥äŒVÚÉsV "
b"x\t zû9\x04 !@.k°¯Pˆ5n "
b"\x1F 4À\x03 ·ØÍËâwúN\x18 éºÇ "
b"\x1F\x13 ÷b#«\x02 '\x14\x06\x02 ¥)P@ý "
b"""
?ùïmãcVâm\n
ú¡CztÓ
"""
b"äì¥╬¿\x16 ║Ò×-\x04 Èv\x16 ƒ8 "
b"·xŸ/V5ƒÁØ\x19\x17\t Ú\f ¼d "
b"¢\x1A\x10 åWÉ‹/®Õ\x0E ×ñ‘k "
b"‚^R§KTûm„\x1F Š÷¶Nc^ "
b"\x04 ˆ\f å8\x00 üº] ÿ}0Ã{\x1E "
b"Ðñ¸ƒ4A‚S©VÑ.ÿ”\x07 † "
b"phª:åš°›ÜØw\x05 Mw»; "
b"HvÆH\x02\x03 –iQƒ‹š\x10 ¾ûù "
b"Šî6…‰\x13 ‡[L‘ý€x8Ez "
b"│ë╠ä\x07 ÅêP±m®Êícz┼ "
b"""
~i5\n
df§Pkïý2á/c\x14
"""
b"╣┬üؤҺÑzz\x1C »▒À¡Ñ "
b"¶«┴9j#yjùPÂÅ╗▄└╝ "
b"Âu=@ù=êÀjØ\x1D ô\x06 ö‰“ "
b"ŠžE!\x02 æ\x17 Ó\x15 Ç,\x03 Ðþ“d "
b"D\x15 v“\x1F ‰©^‘\x1F Å_wXÌ\x06 "
b"ÜàÊéJÊWÄ\x04 ôè\x15 ݵ« "
b"Dì\r ┐8{^\x1F 2$Áq¶\x1A ╠6 "
b"üyN¼ªïW5░!Xà\x1C ╣è' "
b"Üqk>Nvv´\v q\x14 ›\x11 wè+ "
b"█h`└¯Ò»\x11 │óTgjåqÉ "
b"_J\x05 c‰Šú„\x18 „O.vŒj¨ "
b"\x1D ¼`g”j\x04 À«3¥\t Å}ºó "
b"´vA†ÍpúYjµkç;Hk\n "
b"\x04 oh\x19 ù†°Û%Y\x12 Å9\x16 €9 "
b"?wU·D½cÀóüc첋Õ{ "
b"""
ZìNÀ/þ├T\x06 ióÌ\n
ß\x0E
"""
b"\x08 T¥h&¼Ï\x02 7½±ÀÏ0yß "
b"""
F2iÙõJd;È\n
ò„žüw8
"""
b"ò°_ÑHuèÂ}HŸÐ¤8”{ "
b"'ƒQ\x06 ┐┤¢ñô▄ì\x1A ƒFüt "
b"¼~ÝäsÂVÈik‰:åoýá "
b"ºóoÑR¡ºé\x1C\x07 Ñ¿„LŠ| "
b"ìÑ{Ù¦³Fg¯ˆK_±ÏV+ "
b"›`$0q\x1D ±#ª\x15 Xó˜ë\x1A µ "
b"³!DÉ[øQe¨\x07 ? \x17 ¿·Ú "
b"J§\x18 è\x13 9}e]Œ\x01 ·Æ@dL "
b"\¿ÉS\x16 ÷¢±JI\x17 2o\x1E gÙ "
b"╔╝0|\x11 $[╩ÿ÷Ø.¹ûWå "
b"\x06 ÁAŒ¨I}þ\x1C é\f ]Ö\x01 ÷‚ "
b"YÌ\r û\x16\x1D mQ2µëhŸ6ýÀ "
b"""
ÒÀ.Æê–”\r \x04 ³B\n
6Ü1°
"""
b"]┼┌■┬ôª\x13 ʤiIØèù "
b"Ä¿yLîêQ£²Ø\x0E êcr“¬ "
b"Á5\e ¼»LÞ\x12 &™6‰;'\e ± "
b"ìd-fL^nyF\x18 2iÔÉF "
b"""
ˆ\x04 ò4\n
ÉÄÜsÔë\x1F _‡ço
"""
b"gYÊ×dSß\x1F g\x14 ñO˃_. "
b"oºú\x12 ×&=Õê\f ëvvà\x0F ì "
b"6íù\x13\x10 vߨ╠\x0E ÒRfg┐µ "
b"â\x16 ûfÖ*\x03\x1F -”ËH2¹÷ï "
b"‘ˆ|É\x16 ñ§£\x10 ³ÜzQTcZ "
b"hN3ô`Ǻ„ÈdbÛù臲 "
b"åìÿ│║╝MåÍX½h«ýÒù "
b"òè3¬Ðo¥™Õtu?\x0E õ å "
b"â5øšw\x16 d\x05 ÇÎÌÄóž; "
b"ßÖ$†\x10 ~Éc,œˆ‡Ðÿr” "
b"¹2ÂüŸ<iîMf9û¾YE "
b"RyT\r ?-TyÚ»O¤)\x1E q“ "
b"\x18 ;\x0F ¹½\r AŠ[j\x17 b,4Ä\x0E "
b"E´òLÐ^\x02 —×¥v_¼4Öö "
b"\x16 xÝCå·tE60\t ]).<\x07 "
b"■\x17 ÅA║cÈù\x1E NcÜ┬T>? "
b"\x05 Håf§-kp\x1C ¿\x17 I\x1D èEp "
b"šâ.\v `8½-ÀÿX0¸œ“Ñ "
b"§!èÇXÊϨGœ‹\x0F —Ù\x07 ¹ "
b"Sð\x1C .ƒ\x19 ß9>!UÎ9\x0E Y\x1C "
b"ÄóöâDó•“J\x19 Ú\e Y42- "
b""þ¥ Ôâ\r §l>Žx\x07 “ÙÙ "
b"ðeZGdÈbda¾\x1D 7═üag "
b"@y¿u\r {\t ø´ú>&àÄû@ "
b"cÅOè»;╗Ó3v<¡MsðÄ "
b"g|qË\f\v ÀÃÁJWÜÓñY… "
b"\x06 F%\x17\x03 Kö^§&»ü5yd\x0F "
b"ùl~{±Ö\x05\x7F ƒ\x0E n®S╣Å "
b"Ø┘╚QÜ·^\x1F ZÓıÿ¬ö#P "
b"¥ggR\x17 @j/p ³“{\x02 I "
b"""
fat\x1E ³‰(²\n
á€wV6hf
"""
b"§/╦0ÆìÜ̹│\x1D ü^ÉuZ "
b"""
\v ±ì╣#Ü\x1D `h^Y\n
´*ù=
"""
b"bG▓╦\x1D !Â/÷Ã\v ÉÌr±¬ "
b"\x1C\x01 ©:1¨cñRà\x1A È\x1C f\e "
b"•6‡º¥@y}Å\x13 ꃿ2r¤ "
b"»â\x13 ý«oÄñ\x06\x15 ‰ïQ×T\x1E "
b"╬┘(\t ÷▒D|\x12 [ÉdÓ-Î "
b"D0\x00 -\n !\v Nªæ\x1D VÃö\x1A ì "
b"=)zèú¤7ðL?84€€mÈ "
b"\x7F Æ•1\x1C ÜOt¥æðT¶\x00 Q„ "
b"(ƒ¢EâÒ5Ë\x06 ÉÅ\x12\x10 ▄╦\x19 "
b"Õ¥½\x12 ›4Ù´^“Ê3.³“\x19 "
b"{oJ9ëu&˜\x06 PTÀA©\x02 È "
b"Qv˜…\e ßQ\x19\x08 §GÃ\x0E 3ç\x07 "
b"j]§¬4`êSòÐ;ƈ\x00 "
b"\x12 ïçr›Œ?8Rä¤\x1C nȯ‡ "
b"™«ÍKL«Öäqˆ\x10 ö\x1F ,eá "
b"¼]ôAæÊ‹$îv°ùT‚qr "
b"ããÅ\x06\x7F —°=¼ÅƒFb%?Ð "
b"ü AGï\x18 -¹\x13 ˜…H>€Íë "
b"0ÏÔæJnþ\x12\x1A GÒX•Ï¿H "
b"OK©î&¿ÿßgUˆã†«Ò "
b"ìK\x16 +ÈBrGà╚{o\r \x02\x12 \r "
b"µ4Ÿ“\x1E ׎\x08\x02 2\x02 H“äëÓ "
b"Š\x08 (~»\x17 mÓ\v D®Cò‘ã| "
b"\x03 ıï\x14 ,┐G═bì\v {k╗GÉ "
b"""
ÌÖ¦Mò\x02\x0E ‹˜\n
Pw\x7F à†“
"""
b"Ê8J"øú‗ù‗¯■ü\x17 ß\x03 Ï "
b"õ╝Ö @ÅÂ\x15\e\x04 cë¦GX{ "
b"\x0F Û×F+¥Œ+´û\x16\x06\x18 Åql "
b"k䲦>\x0E\x16\x1D óŒ¦bóN+Û "
b"(kb…Š`‚ÈÐ\x02 ÄÖÖµÕ¸ "
b"Ëk \x1C ž \x05 f¦gw\x1A ºd\f â "
b"äû\x16 »óÉȾ\x15 õ\x08 ”²ÎÒ\x1D "
b";EÿôŽ9½¢³ú³hU\x18 ¡N "
b"\x18 •æÛ\r 𫺲¨àÓÜQéu "
b"Z▀Ô²Éu©Q;G\x12 Ñ├fÃ8 "
b"ööiÙn§jšÌ\x10 aÎ\x7F 6…è "
b"ò€ozr=’dÇ\e j©â§W\x7F "
b"E¬òýNžÿFéIøÈŒQÓ\x1C "
b"\x7F 騲+"sM"L8Ö{ùæF "
b"Íd—Ò\e jì~nk °%“Z\x13 "
b"wÒwSìÍu'SgNj\x06 ÐÐ( "
b"ð[¯%\Á N·Be·ú›€¯ "
b"ïHÄ–ÁèDŽF\f ‹j1ÉK“ "
b":@▓\x15 Ø▒¥C┐H6╦å\t ªÆ "
b"\x13 §Q\f ʪS{8\x02 a¾¨åÕ "
b"=¸<دó\x14 U*ÇGýwüàx "
b"M@Ê_Wo1þ\“ñi1B–Ì "
b"ø»Ñ»gÅò\x0F I\e (Ùça\x00 h "
b"ì;y¯ç*¹═§dûÿ\x17 o=¸ "
b")!¹$Ð_\t øv%ýsHÑÙ« "
b"ıÏ6¶╬\x1E [Ø┤i╔À-ë\î "
b"É╝Z\x1F úDDU?▄^\x7F y*╔é "
b"íèÊ┘■/5üÙn«▒┼%¹ "
b"ƒO╠Ã.╝¼B¶\x0E ╠ı\x15 ü\x17\x1C "
b"\f bÑq7ž!¹\f »³W®Ûp· "
b"8šˆ±Q@'\x19 v\v 0\x1C ™k£… "
b"nO¯\e\x17 ƒ\x1F »–ü\x14 mygd "
b"É\v *íÇ├\x08 m▓]ÆúÈ]>H "
b"û\x11 ¾è\x11 Æ’^Í•³A¤ç¼| "
b"\x05 ôAÉ\x1F BG╩Jä╩\f 1/òD "
b"%█\x02 s├×è█E\x11 +#è zØ "
b"Ú\x00\t =\x7F pÿ·áØžrRT5ø "
b"¿ð䀂!Î\x1C Æ^Zñ`\x10 ‚ô "
b"Ð\x0F 3Ö\x0E $}üı│È ╗_\f\x07 "
b"\e 0KÄâF\x0E \x0E 8è\x14 i&¡ù "
b"\x1F üôýD\x11\x05\x04 ▄║eÚåæÊò "
b"@┌\x16 $tïv£säjì▄Òâë "
b"\x12\e h£‘à©:\x12 v'q,â˜\x13 "
b"\r ]eŶ³┌e¬╩¤)╚Ø<K "
b"Ÿ&®£eSŒx•¢ÅTÏ9D+ "
b"┘▀£╬hÛØwݦ~&ê╚░Ì "
b"Ó<Ÿí5ºXI‰Æ¶|¿d¨\x11 "
b"¦v«ºcÄë!\x05 )¬´Å¥!\x1D "
b"”½§{ühEÌ;]¡™Šˆ‘< "
b"4¥Â9├┌Ûoç8ÏÖ:Ø▒Í "
b"""
D1/\n
y³L€¯Z\x1F Ù%í®›
"""
b"\x07 ðƒÝø•ÿ+\x1C ÆÖO- "
b"¨┤q\x16 ñTW§{uµoÉ\f ³N "
b"\x03 ŽØ½Ê–Î\e rd¾‚F\x1F ÷… "
b"l"è\x13 µ²#çü_v>aœ:B "
b"ıùuAZèíüÎU┌©·ðow "
b"b¯k²¥╗Éói×╩╠Õ┬Zº "
b"œ‘\f\x16 Ì£\x06 Ÿ% ¥IÓ>Ž2 "
b"†©¥s:÷óW×µ8·:½½æ "
b"ƒ©95)',mNó•Ì\x02 ˆt "
b"ûüm%©<\v 3Ãa7\x05 ãdrâ "
b"\x0F %Ƶ\x10 ©c÷\x14 X\x12 ª9KÃ\r "
b"@&†dλZ^lL\x14 ›A\x05 ù£ "
b"║£\r ÞØôàH■>Çïã¯ØÉ "
b"+¼cª6FÀV‘\x16 .tê\x13 ʯ "
b"R_Ú.\x04 %ü\x17\x1E ┤\f d┘øËÎ "
b"ºq3P[\x07 ,Çü‗l¾┐¬½^ "
b"óe¯GÃú&Ø.y)µË─ð. "
b"ÝAú\v ³ÞíÓÓº4ùöÔÆæ "
b"ÿKœu“f²ñIû‹\x07 $\x7F \ý "
b"""
Š1Ñ\e c>Ö\x1F µ9µ\n
\x10 ßÄ‹
"""
b"I–ÎÁ¡ú”qp9TÃL\v ø/ "
b"p\x1F ¤5z>P\t Í7\ÿ3Æd¼ "
b"‚;n\f ŒéÎß¾>Ÿ‚a9èT "
b"Qº4ú›Ë…}»¶\x00 ú§jgß "
b"*—"ö*8\x1C Þ\x7F äŸîëf\x16 X "
b"Ùº‗^*¡oöØ5╗┐¿Ê┤y "
b"TŒ£Û¤ŸóÍ^\v û¨»Òÿë "
b"áã\x04 ÑT×┘└¦¦ëÓxá╠ì "
b"*\e Å\x1C ¢D¹ÐV#~┼TïÙ] "
b"ÅZï:\x01 îp\x7F\f €5B'À¾Õ "
b"öqFtå╝\x0F ┘ë╝Ûì\e &┬ù "
b"ÚM\x17 „ý\x07 5~\x0F Í\x1F \‰f`È "
b"Ä\x02 —\e –Ð(§Ê«ìì\e bˆw "
b"&¿\v\x18 "êmWb\x19\x15\x0F éüO\x04 "
b"¬▀V\x07 ÂÆI\x1F Åo÷\t ·W▓l "
b";w8Ð\x16\x18 ^•\x07 ·£Aˆ‹@Þ "
b"8¸\x02 íU!FÃØDı\x07\x19 ╚È "
b"\x1E Ôò│ïK%¿T_^õØ\x0E øS "
b"\x1E\x00 -C\x0E\f ÷¶âj.Túèñà "
b"-‡Ö\t —\x1D áˆ\x14 ÐLN@p~* "
b"3X¬B®ÉÝ¡¤»xæ[Âè™ "
b"sc9|Îíÿ;>ý,ãh>å\x04 "
b"!?Éi”ü“¹(%7QLlv| "
b"Âo0QéÈ\x05 ¨ƒó\x15\x10 "eÜ\r "
b"8…â¹"Õ«†B²¹+µ¯ R "
b"Íðl6▀ohtü\x1C ·k)└\x15 ^ "
b"/oÍðú+ïõ\x00 \x06 ôƒ+gð "
b"\x13 y\x18 Å|5ê²\x08 ÀðmåÓv "
b"\x01 õF•ˆvuj×~<G¿°\x12 h "
b"ÖÂwa’Xï·&—=<Q\x14 œr "
b"Tݾ}îýK¢&\x15 Þ;0‚\x15 "
b"MŸÌ\x1E Y¬hî1ë‡\x05 8\x1D '\x18 "
b"ù̯°ÐÖÜy\x13 £\x19 ÉýiËÕ "
]
SELECT
`meta_catalog_id` . `id`
FROM
`meta_catalog_id`
WHERE
`meta_catalog_id` . `id` IN (
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
?
)
Copy
SELECT `meta_catalog_id` . `id` FROM `meta_catalog_id` WHERE `meta_catalog_id` . `id` IN (0xB781E9980B67181CCC3FD9E424F7B5B0 , 0x49BA5C66D30741F917727D407C5D812E , 0xF3063AD5E0343509F4E5F4438AA055B4 , 0x412D328A9CFCF548455A90F3DA7966CC , 0x51E0545871AA5DA259EF3C480C8C02A1 , 0x61627C8B629DF7016472C27326B26EBB , 0x7E98E453AE28A3203B4C158CFDBA5E96 , 0x50B6B5401CF046E5F7489F80D0AA8410 , 0x556890359EFB88D811AF6FA7388F1E10 , 0x3557E640F29218E797242A6C255E49E6 , 0x708A1651CD9A8ECDEC4D366E45976512 , 0xAAA4823C915151094D6E9C829E256B5A , 0x87EAAC0E7F2E663B95256F4B80C789F0 , 0x0E6ED4720548D4D364122C82777493B5 , 0x7F01A977DAF8DDEA71D65179EA17BB21 , 0xF0212EA54F1337C04233A92926DF6102 , 0x58A81FD17AA4015B8469E813043AB921 , 0x4ED8E5BAF46077C25D4BEBB040F8FE32 , 0x01A6BA22C7113AFAB635607D442CAD85 , 0x1EC61FE950A07DB0EFCF2EAF676D785D , 0xAA6BA8CA382D06155773F0D18C3E3991 , 0xCF5FE270476DDC1B3485CE9EFEEFB772 , 0x68FBD9A3212FC16115EB0D0F1E2441D9 , 0x9238349445374CC24AE98E023168A531 , 0x302E991132134B251453E9B81156757D , 0x009D6D43A2A6A380BA08B536B07A6055 , 0x9E2E638A5A3F455193A9F30B614E1364 , 0x02ED7D2554F38400101B4CEB35CFFA45 , 0x6EAC5ADC53A07B7838EB8BE0D2831FD6 , 0xCBC45B733ECF205DB34225E1DB1C40A1 , 0xF1627E92AEE969EDCF27DC125081E06B , 0x4C92225A9489CAFE092914C05BD5848E , 0x7AFE56509C5BFF39E8710FBD9776EFA0 , 0x72B3BDCC1E4B3270CB7135EF2F33F7A0 , 0x3B357BB98577BB05237AE7E8A66F359B , 0x27ADFF9A7BD7BDFC8CC23B93E4851748 , 0x1B5EC6DE8714A65BB7EBB4DEAD8B62D5 , 0xE717AD1FDB7D8097C59B5B6038C46C35 , 0x6402CEF5844B92C8DFE0E9F633226F6B , 0xC8D99C1140A6F45EA1DC9A35F1A88791 , 0x1F9081096EFB2895F1EF22689C081355 , 0xD86C00D8A24B2A15359DAB8103F4EBE1 , 0xC2D4234F0B380347362C179D8186826F , 0x37DC7DB4D4159537FFB303BA151FC359 , 0x19CA3280C2FF99C0A484132FAD9A99AC , 0x97A54C8B9BB17867BAA912591E7FC25A , 0xA5D0827B3812570C5B30145939D71204 , 0x13B33D6CC4D5A4248B02E270677A10FF , 0x8ECA7174784F55527E4816700B99A03B , 0xE223C61DAA3A87C6B588C5DB5B257358 , 0x471C6EE440E0B4868790FD9981E12EA8 , 0xA09B9100A182396CD4165EE0A9122E8E , 0x2065F827AC65CF3305974DDC8C5068CB , 0x6C8F56683658F1BDC941FA5EFADC09BB , 0xAD9E65D4642DFB9CA5E48C56DAC97356 , 0x78097AFB390421402E6BB0AF5088356E , 0x1F34C003B7D8CDCBE277FA4E18E9BAC7 , 0x1F13F76223AB0227140602A5295040FD , 0x3FF9EF6DE36356E26D0AFAA1437A74D3 , 0x848DBECEA816BAE39E2D04D476169F38 , 0xB7789F2F563583C1D8191709DA0CBC64 , 0xA21A10E557C98B2FAEADD50ED7F1916B , 0x825E52A74B54FB6D841F8AF7B64E635E , 0x04880CE53800FCBA5DA0FF7D30C37B1E , 0xD0F1B88334418253A956D12EFF940786 , 0x7068AA3AE59AB09BDCD877054D77BB3B , 0x4876C6480203966951838B9A10BEFBF9 , 0x8AEE36858913875B4C91FD807838457A , 0xB389CC84078F8850F16DA9D2A1637AC5 , 0x7E69350A6466A7506BEFFD32E12F6314 , 0xB9C2819DCFE3A7A57A7A1CAFB1B7ADA5 , 0xF4AEC1396A23796A9750B68FBBDCC0BC , 0xC2753D40F93DEAC06AD81DF406F68993 , 0x8A9E452102E617D315C72C03D0FE9364 , 0x441576931F89A95E911FC55F7758CC06 , 0xDCE0CAE94ACA57C404F4E81520DDB5AB , 0x448D0DBF387B5E1F3224B571F41ACC36 , 0x81794EACA68B5735B02158851CB98A27 , 0xDC716B3E4E7676B40B71149B1177E82B , 0xDB6860C0EEE3AF11B3A254676A867190 , 0x5F4A0563898AFA8418844F2E768C6AA8 , 0x1DBC6067946A04C0AB33A509C57DBAF3 , 0xB4764186CD70FA596AB56BE73B486B0A , 0x046F6819F986B0DB255912C539168039 , 0x3F7755B744BD63C0F3FC63ECB28BD57B , 0x5AF08D4EB72FE7C3540669A2DE0AE10E , 0x0854A56826BCCF0237BDB1C0CF3079DF , 0x463269D9F54A643BC80AF2849EFC7738 , 0xF2B05FD14875E8C27D489FD0A438947B , 0x279F5106BFB4BDA493DC8D1A9F468174 , 0xBC7EDDE473C256C8696B893AE56FFDE1 , 0xBAF36FD152A1BAE91C07D1BF844C8A7C , 0xECD17BD9A6B34667AF884B5FB1CF562B , 0x9B602430711DB123AA1558F398EB1AB5 , 0xB32144C95BF85165A8073F2017BFB7DA , 0x4AA718E813397D655D8C01B7C640644C , 0x5CA8905316F6BDF14A4917326F1E67EB , 0xC9BC307C11245BCA98F69D2EFB965786 , 0x06C1418CA8497DFE1CE90C5DD601F782 , 0x59CC0DFB161D6D5132B5EB689F36FDC0 , 0xD2C02EC6EA96940D04B3420A36DC31B0 , 0x5DC5DAFEC293A613D2CF69499D8A97F0 , 0xC4BF794CEEEA51A3B2D80EEA637293AC , 0xC1351BBCBB4CDE12269936893B271BB1 , 0xEC642DAD664C5E6E7946183269D4C946 , 0x8804F2340AC9C4DC73D4EB1F5F87E76F , 0x6759CAD76453DF1F6714F14FCB835F2E , 0x6FBAFA12D7263DD5EA0CEB7676E00FEC , 0x36A197131076E19DCC0EE3526667BFE6 , 0xE216FB66D62A031F2D94CB4832B9F7EF , 0x91887CC916F1A7A310B3DC7A5154635A , 0x684E33F460C7BA84C86462DBF9E887B2 , 0x868D98B3BABC4D86D658AB68AEECE397 , 0xF2E833ACD06FA599D574753F0EF5A0E5 , 0xE235F89A77166405C7CECCC4ADF39E3B , 0xDFD62486107EC9632C9C8887D0FF7294 , 0xB932C2FC9F3C69EE4D6639FBBE59AD45 , 0x5279540D3F2D5479DABB4FA4291E7193 , 0x183B0FB9BD0D418A5B6A17622C34C40E , 0x45B4F24CD05E0297D7A5765FBC34D6F6 , 0x1678DD43E5B774453630095D292E3C07 , 0xFE178F41BA63D4971E4E639AC2543E3F , 0x0548E566A72D6B701CBF17491DE84570 , 0x9AE22E0B6038BD2DC0FF5830B89C93D1 , 0xA721E8C758CACFA8479C8B0F97D907B9 , 0x53F01C2E8319DF393E2155CE390E591C , 0xC4F3F6E244F395934A19DA1B5934322D , 0x22FEA520D4E20DA76C3E8E780793D9D9 , 0xD0655A4764D4626461F31D37CD816167 , 0x4079BF750D7B09F8B4FA3E26E0C4FB40 , 0x638F4F8AAF3BBBE033763CAD4D73D08E , 0x677C71CB0C0BC0C3C14A57DCD3F15985 , 0x06462517034B945EF526AF813579640F , 0x976C7E7BF199057FFF9F0E6EA953B98F , 0x9DD9C8519AFA5E1F5AE0D598AA942350 , 0xA5676752AD17406A2F7020B3937B0249 , 0x6661741EB38928B20AE1807756366866 , 0xF52FCB30928D9ADEFBB31D815E90755A , 0x0BF18DB9239A1D60685E590AEF2A973D , 0x6247B2CB1D21B62FF6C70B90DE72F1AA , 0x1C01A93A31A863F152E01AC81C661B20 , 0x953687BAA540797DC513EA83BF3272A4 , 0xBBE213FDAB6FC4F1061589EF51D7541E , 0xF0CED92809F6B1447C125B9064E02DD7 , 0x4430002D0A210B4EA6911D56C7941A8D , 0x3D297AE8FAA437F04C3F383480806DC8 , 0x7FC695311CDC4F74A5E6F054B6005184 , 0x289FBD4583E335D306908F1210DCCB19 , 0xD5A5BD129B34D9B45E93CA332EB39319 , 0x7B6F4A39EB752698065054C041A902C8 , 0x517698851BDF511908A747C30E33E707 , 0x6A5DA7AC3460EA53F2D0CDBEC688AD00 , 0x12EFE7729B8C3F3852E4A41C6EC8AF87 , 0x99ABCD4B4CABD6E4718810F61F2C65E1 , 0xBC5DF441E6CA8B24EE76B0F954827172 , 0xE3E3C5067F97B03DBCC5834662253FD0 , 0xFCA04147EF182DB9139885483E80CDEB , 0x30CFD4E64A6EFE121A47D25895CFBF48 , 0x4F4BA9EE26BFFFDF675588ADE386ABD2 , 0x8D4B162BD442724785C87B6F0D02120D , 0xB5349F931ED78E080232024893E4EBD3 , 0x8A08287EBB176DD30B44AE43F291E37C , 0x03D58B142CBF47CD628D0B7B6BBB4790 , 0xCCD6A64DF2020E8B980A50777FE08693 , 0xD2384A229BA3F297F2EEFE8117E103D8 , 0xE4BC99FF408FB6151B046389DD47587B , 0x0FDBD7462BA58C2BB4FB160618C5716C , 0x6BE4B2A63E0E161DF38CA662F34E2BDB , 0x286B62858A6082C8D002C4D6D6B5D5B8 , 0xCB6B201C9EA00566A667771ABA640CE2 , 0xE4FB16BBF3C9C8BE15F50894B2CED21D , 0x3B45FFF48E39BDA2B3FAB3685518A14E , 0x1895E6DB0DF0ABBAB2A8E0D3DC51E975 , 0x5ADFE2FD9075B8513B4712A5C366C738 , 0xF6F669D96EA76A9ACC1061CE7F3685E8 , 0xF2806F7A723D9264C71B6AA9E2A7577F , 0x45ACF2FD4E9EFF46E949F8C88C51D31C , 0x7F829DFD2B22734D224C38997B979146 , 0xCD6497D21B6AEC7E6E6BA0B025935A13 , 0x77E377538DD6752753674E6A06D1D128 , 0xF05BAF255CC1A04EB74265B7FA9B80AF , 0xEF48C496C1E8448E460C8B6A31C94B93 , 0x3A40B2159DB1BE43BF4836CB8609A692 , 0x13A7510CCAAA537B3802AD61BEA8E5D5 , 0x3DB83CD8AFF314552AC747FD77FCE078 , 0x4D40CA5F576F31FE5C93F169314296CC , 0x9BAFA5AF678F950F491B28EB87610068 , 0x8D3B79EE872AFBCDF5649698176F3DF7 , 0x2921B924D05F09F87625FD7348D1D9AB , 0xD5D836F4CE1E5B9DB469C9B72D895C8C , 0x90BC5A1FA34444553FDC5E7F792AC982 , 0xA18AD2D9FE2F3581F0EB6EAEB1C525FB , 0x9F4FCCC72EBCAC42F40ECCD51581171C , 0x0C62D171379E21B90CBBB357AEDB70B7 , 0x389A88B151402719760B301C996BA385 , 0x6E4FAF5C6517831FBB96FC146D796764 , 0x900B2AA180C3086DB25D92A3D45D3E48 , 0xFB11BEE811C6925ECD95B341A4E7BC7C , 0x059341901F4247CA4A84CA0C312F9544 , 0x25DB0273C39E8ADB45112B238A207A9D , 0xDA00093D7F70FFB7E1D89E72525435F8 , 0xBFF0E4808221CE1CC65E5AF1601082F4 , 0xD10F33990E247D81D5B3D420BB5F0C07 , 0x1B304BC4E2460E200E38E8146926A1F9 , 0x1F8193EC44110504DCBA65E98691D295 , 0x40DA1624748B769C73846A8DDCE38389 , 0x121B68A391E0A93A127627712CE29813 , 0x0D5D658FF4FCDA65AACACF29C89D3C4B , 0x9F26AEA365538C7895A2C554CF39442B , 0xD9DF9CCE68EA9D77EDDD7E2688C8B0DE , 0xD33C9FED35BA584989C6B67CBF64A811 , 0xDD76AEA7638E89210529AAEF8FBE211D , 0x94BDA77BFC6845CC3B5DA1998A88913C , 0x34BEB639C3DAEA6F8738D8993A9DB1D6 , 0x44312F0A79B34C80AF5A1FD925EDAE9B , 0x07F083DDF895FFEE8ABC2B1CC6D64F2D , 0xF9B47116A45457F57B75E66F900CFC4E , 0x038ED8BDCA96CE1B7264BE82461FF785 , 0x6C22E813B5B223E7FC5F763E619C3A42 , 0xD59775415A8AA181D755DAB8FAD06F77 , 0x62EE6BFDBEBB90A2699ECACCE5C25AA7 , 0x9C910C16CCA3069F2520A549D33E8E32 , 0x86A9A5733AF7F357D7B538B73ABDBDE6 , 0x83ADA9393529272C6D4EF395CC028874 , 0xFBFC6D25A93C0B33C3613705E36472E2 , 0x0F25C6B510A963F7145812AA394BC30D , 0x40268664CEBB5A5E6C4C149B4105F9A3 , 0xBA9C0DE89D938548FE3E808BC6EE9D90 , 0x2BBC63AA3646C05691162E74EA13CAAF , 0x525FE92E042581171EB40C64D99BD3D7 , 0xA77133505B072C8081F26CF3BFAAAB5E , 0xA265EE47C7A3269D2E7929E6D3C4D02E , 0xDD41FA0BB3DEEDD3D3BA34F9F6D4C6E6 , 0xFF4B9C759366B2F149FB8B07247F5CFD , 0x8A31D11B633ED61FB539B50A10DFC48B , 0x4996CEC1A1FA9471703954C34C0BF82F , 0x701FA4357A3E5009CD375CFF33C664BC , 0x823B6E0C8CE9CEDFBE3E9F826139E854 , 0x51BA34FA9BCB857DBBB600FAA76A67DF , 0x2A9722F62A381CDE7FE49FEEEB661658 , 0xEBA7F25E2AAD6F949D35BBBFA8D2B479 , 0x548CA3DBA49FF3CD5E0BFBA8BBD2FFEB , 0xA0C604A5549ED9C0DDDD89E078A0CC8D , 0x2A1B8F1CBD44FBD156237EC5548BEB5D , 0xC55AEF3A01EE707F0C80354227C0BED5 , 0x9471467486BC0FD989BCEA8D1B26C297 , 0xDA4D1784FD07357E0FCD1F5C896660C8 , 0xC402971B96D028A7CAABECEC1B628877 , 0x26A80B1822886D576219150F82814F04 , 0xAADF5607B692491F8F6FF609FA57B26C , 0x3B7738D016185E9507B7A341888B40DE , 0x38F702A1F0552146C79D44D50719C8D4 , 0x1EE295B38B4B25A8545F5EE49D0E9B53 , 0x1E002D430E0CF7B6E26A2E54FAE8F1C3 , 0x2D87D609971DE18814D04C4E40707E2A , 0x3358AC42AEC9DDA1A4BB78E65BC2E899 , 0x7363397CCEEDFF3B3EFD2CE3683EE504 , 0x213FC96994FC93B9282537514C6C767C , 0xC26F3051E9C805A883F315102265DC0D , 0x3885E2B922D5AB8642B2B92BB5AF2052 , 0xD6D06C36DF6F6874811CFA6B29C0155E , 0x2F6FCDF0FA2BEFF5002006F4832B67F0 , 0x137918C57C35EAB208C0F06DE5ADD376 , 0x01F546958876756AD77E3C47BFB01268 , 0xD6C277619258EFB726973D3C51149C72 , 0x54DDC2BE7DEEFD4BA22615DE3B308215 , 0x4D9FCC1E59AC68EE31EB8705381D2718 , 0xF9CCAFB0D0D6DC7913A319C9FD69CBD5 );
Copy
7.21 ms (10.22%)
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/c402971b96d028a7caabecec1b628877 "
"/detail/26a80b1822886d576219150f82814f04 "
"/detail/aadf5607b692491f8f6ff609fa57b26c "
"/detail/3b7738d016185e9507b7a341888b40de "
"/detail/38f702a1f0552146c79d44d50719c8d4 "
"/detail/1ee295b38b4b25a8545f5ee49d0e9b53 "
"/detail/1e002d430e0cf7b6e26a2e54fae8f1c3 "
"/detail/2d87d609971de18814d04c4e40707e2a "
"/detail/3358ac42aec9dda1a4bb78e65bc2e899 "
"/detail/7363397cceedff3b3efd2ce3683ee504 "
"/detail/213fc96994fc93b9282537514c6c767c "
"/detail/c26f3051e9c805a883f315102265dc0d "
"/detail/3885e2b922d5ab8642b2b92bb5af2052 "
"/detail/d6d06c36df6f6874811cfa6b29c0155e "
"/detail/2f6fcdf0fa2beff5002006f4832b67f0 "
"/detail/137918c57c35eab208c0f06de5add376 "
"/detail/01f546958876756ad77e3c47bfb01268 "
"/detail/d6c277619258efb726973d3c51149c72 "
"/detail/54ddc2be7deefd4ba22615de3b308215 "
"/detail/4d9fcc1e59ac68ee31eb8705381d2718 "
"/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/c402971b96d028a7caabecec1b628877' , '/detail/26a80b1822886d576219150f82814f04' , '/detail/aadf5607b692491f8f6ff609fa57b26c' , '/detail/3b7738d016185e9507b7a341888b40de' , '/detail/38f702a1f0552146c79d44d50719c8d4' , '/detail/1ee295b38b4b25a8545f5ee49d0e9b53' , '/detail/1e002d430e0cf7b6e26a2e54fae8f1c3' , '/detail/2d87d609971de18814d04c4e40707e2a' , '/detail/3358ac42aec9dda1a4bb78e65bc2e899' , '/detail/7363397cceedff3b3efd2ce3683ee504' , '/detail/213fc96994fc93b9282537514c6c767c' , '/detail/c26f3051e9c805a883f315102265dc0d' , '/detail/3885e2b922d5ab8642b2b92bb5af2052' , '/detail/d6d06c36df6f6874811cfa6b29c0155e' , '/detail/2f6fcdf0fa2beff5002006f4832b67f0' , '/detail/137918c57c35eab208c0f06de5add376' , '/detail/01f546958876756ad77e3c47bfb01268' , '/detail/d6c277619258efb726973d3c51149c72' , '/detail/54ddc2be7deefd4ba22615de3b308215' , '/detail/4d9fcc1e59ac68ee31eb8705381d2718' , '/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
5.22 ms (7.40%)
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"Ä\x02 —\e –Ð(§Ê«ìì\e bˆw "
b"&¿\v\x18 "êmWb\x19\x15\x0F éüO\x04 "
b"¬▀V\x07 ÂÆI\x1F Åo÷\t ·W▓l "
b";w8Ð\x16\x18 ^•\x07 ·£Aˆ‹@Þ "
b"8¸\x02 íU!FÃØDı\x07\x19 ╚È "
b"\x1E Ôò│ïK%¿T_^õØ\x0E øS "
b"\x1E\x00 -C\x0E\f ÷¶âj.Túèñà "
b"-‡Ö\t —\x1D áˆ\x14 ÐLN@p~* "
b"3X¬B®ÉÝ¡¤»xæ[Âè™ "
b"sc9|Îíÿ;>ý,ãh>å\x04 "
b"!?Éi”ü“¹(%7QLlv| "
b"Âo0QéÈ\x05 ¨ƒó\x15\x10 "eÜ\r "
b"8…â¹"Õ«†B²¹+µ¯ R "
b"Íðl6▀ohtü\x1C ·k)└\x15 ^ "
b"/oÍðú+ïõ\x00 \x06 ôƒ+gð "
b"\x13 y\x18 Å|5ê²\x08 ÀðmåÓv "
b"\x01 õF•ˆvuj×~<G¿°\x12 h "
b"ÖÂwa’Xï·&—=<Q\x14 œr "
b"Tݾ}îýK¢&\x15 Þ;0‚\x15 "
b"MŸÌ\x1E Y¬hî1ë‡\x05 8\x1D '\x18 "
]
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 (0xC402971B96D028A7CAABECEC1B628877 , 0x26A80B1822886D576219150F82814F04 , 0xAADF5607B692491F8F6FF609FA57B26C , 0x3B7738D016185E9507B7A341888B40DE , 0x38F702A1F0552146C79D44D50719C8D4 , 0x1EE295B38B4B25A8545F5EE49D0E9B53 , 0x1E002D430E0CF7B6E26A2E54FAE8F1C3 , 0x2D87D609971DE18814D04C4E40707E2A , 0x3358AC42AEC9DDA1A4BB78E65BC2E899 , 0x7363397CCEEDFF3B3EFD2CE3683EE504 , 0x213FC96994FC93B9282537514C6C767C , 0xC26F3051E9C805A883F315102265DC0D , 0x3885E2B922D5AB8642B2B92BB5AF2052 , 0xD6D06C36DF6F6874811CFA6B29C0155E , 0x2F6FCDF0FA2BEFF5002006F4832B67F0 , 0x137918C57C35EAB208C0F06DE5ADD376 , 0x01F546958876756AD77E3C47BFB01268 , 0xD6C277619258EFB726973D3C51149C72 , 0x54DDC2BE7DEEFD4BA22615DE3B308215 , 0x4D9FCC1E59AC68EE31EB8705381D2718 ));
Copy
3.70 ms (5.25%)
4
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )) AND (sales_channel_id = ? )
Parameters :
[
b"Ä\x02 —\e –Ð(§Ê«ìì\e bˆw "
b"&¿\v\x18 "êmWb\x19\x15\x0F éüO\x04 "
b"¬▀V\x07 ÂÆI\x1F Åo÷\t ·W▓l "
b";w8Ð\x16\x18 ^•\x07 ·£Aˆ‹@Þ "
b"8¸\x02 íU!FÃØDı\x07\x19 ╚È "
b"\x1E Ôò│ïK%¿T_^õØ\x0E øS "
b"\x1E\x00 -C\x0E\f ÷¶âj.Túèñà "
b"-‡Ö\t —\x1D áˆ\x14 ÐLN@p~* "
b"3X¬B®ÉÝ¡¤»xæ[Âè™ "
b"sc9|Îíÿ;>ý,ãh>å\x04 "
b"!?Éi”ü“¹(%7QLlv| "
b"Âo0QéÈ\x05 ¨ƒó\x15\x10 "eÜ\r "
b"8…â¹"Õ«†B²¹+µ¯ R "
b"Íðl6▀ohtü\x1C ·k)└\x15 ^ "
b"/oÍðú+ïõ\x00 \x06 ôƒ+gð "
b"\x13 y\x18 Å|5ê²\x08 ÀðmåÓv "
b"\x01 õF•ˆvuj×~<G¿°\x12 h "
b"ÖÂwa’Xï·&—=<Q\x14 œr "
b"Tݾ}îýK¢&\x15 Þ;0‚\x15 "
b"MŸÌ\x1E Y¬hî1ë‡\x05 8\x1D '\x18 "
b"\x01 ɪJ£&pò▓Ãè ÌôÜÓ "
]
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (0xC402971B96D028A7CAABECEC1B628877 , 0x26A80B1822886D576219150F82814F04 , 0xAADF5607B692491F8F6FF609FA57B26C , 0x3B7738D016185E9507B7A341888B40DE , 0x38F702A1F0552146C79D44D50719C8D4 , 0x1EE295B38B4B25A8545F5EE49D0E9B53 , 0x1E002D430E0CF7B6E26A2E54FAE8F1C3 , 0x2D87D609971DE18814D04C4E40707E2A , 0x3358AC42AEC9DDA1A4BB78E65BC2E899 , 0x7363397CCEEDFF3B3EFD2CE3683EE504 , 0x213FC96994FC93B9282537514C6C767C , 0xC26F3051E9C805A883F315102265DC0D , 0x3885E2B922D5AB8642B2B92BB5AF2052 , 0xD6D06C36DF6F6874811CFA6B29C0155E , 0x2F6FCDF0FA2BEFF5002006F4832B67F0 , 0x137918C57C35EAB208C0F06DE5ADD376 , 0x01F546958876756AD77E3C47BFB01268 , 0xD6C277619258EFB726973D3C51149C72 , 0x54DDC2BE7DEEFD4BA22615DE3B308215 , 0x4D9FCC1E59AC68EE31EB8705381D2718 )) AND (sales_channel_id = 0x0190A64A9C267095B2C78AFFDE939AE0 );
Copy
1.83 ms (2.60%)
2
SELECT `delivery_time` . `id` as `delivery_time.id` , `delivery_time` . `min` as `delivery_time.min` , `delivery_time` . `max` as `delivery_time.max` , `delivery_time` . `unit` as `delivery_time.unit` , `delivery_time` . `created_at` as `delivery_time.createdAt` , `delivery_time` . `updated_at` as `delivery_time.updatedAt` , `delivery_time.translation.name` , `delivery_time.translation.name` as `delivery_time.name` , `delivery_time.translation.customFields` , `delivery_time.translation.customFields` as `delivery_time.customFields` FROM `delivery_time` LEFT JOIN (SELECT `delivery_time.translation` . `delivery_time_id` , `delivery_time.translation` . `name` as `delivery_time.translation.name` , `delivery_time.translation` . `custom_fields` as `delivery_time.translation.customFields` FROM `delivery_time_translation` `delivery_time.translation` WHERE `delivery_time.translation` . `language_id` = ? ) `delivery_time.delivery_time_translation` ON `delivery_time.delivery_time_translation` . `delivery_time_id` = `delivery_time` . `id` WHERE `delivery_time` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 ÉÑпip×ÉPí×Â\x12\x18 ¡ "
]
SELECT `delivery_time` . `id` as `delivery_time.id` , `delivery_time` . `min` as `delivery_time.min` , `delivery_time` . `max` as `delivery_time.max` , `delivery_time` . `unit` as `delivery_time.unit` , `delivery_time` . `created_at` as `delivery_time.createdAt` , `delivery_time` . `updated_at` as `delivery_time.updatedAt` , `delivery_time.translation.name` , `delivery_time.translation.name` as `delivery_time.name` , `delivery_time.translation.customFields` , `delivery_time.translation.customFields` as `delivery_time.customFields` FROM `delivery_time` LEFT JOIN (SELECT `delivery_time.translation` . `delivery_time_id` , `delivery_time.translation` . `name` as `delivery_time.translation.name` , `delivery_time.translation` . `custom_fields` as `delivery_time.translation.customFields` FROM `delivery_time_translation` `delivery_time.translation` WHERE `delivery_time.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `delivery_time.delivery_time_translation` ON `delivery_time.delivery_time_translation` . `delivery_time_id` = `delivery_time` . `id` WHERE `delivery_time` . `id` IN (0x0190A5D1A869709E9050A19EB61218AD );
Copy
1.59 ms (2.26%)
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/Weiss,%20Hans "
"/author/Weiss,%20Hans "
"https://hauptbuchhandlung.staging.eurosoft.network/author/Weiss,%20Hans "
"https://hauptbuchhandlung.staging.eurosoft.network//author/Weiss,%20Hans "
"/author/Weiss,%20Hans "
"//author/Weiss,%20Hans "
"author/Weiss,%20Hans "
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/Weiss,%20Hans' , '/author/Weiss,%20Hans' , 'https://hauptbuchhandlung.staging.eurosoft.network/author/Weiss,%20Hans' , 'https://hauptbuchhandlung.staging.eurosoft.network//author/Weiss,%20Hans' , '/author/Weiss,%20Hans' , '//author/Weiss,%20Hans' , 'author/Weiss,%20Hans' ) 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.12 ms (1.59%)
4
"START TRANSACTION"
"START TRANSACTION" ;
Copy
1.09 ms (1.55%)
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
1.08 ms (1.53%)
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
1.06 ms (1.51%)
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
1.06 ms (1.50%)
2
SELECT `key` , `value` FROM `app_config`
SELECT `key` , `value` FROM `app_config` ;
Copy
0.99 ms (1.40%)
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.94 ms (1.33%)
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.93 ms (1.31%)
4
"COMMIT"
0.90 ms (1.27%)
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.85 ms (1.21%)
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.85 ms (1.21%)
1
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.translation.name` , `category.translation.name` as `category.name` , `category.translation.breadcrumb` , `category.translation.breadcrumb` as `category.breadcrumb` , `category.translation.slotConfig` , `category.translation.slotConfig` as `category.slotConfig` , `category.translation.linkType` , `category.translation.linkType` as `category.linkType` , `category.translation.internalLink` , `category.translation.internalLink` as `category.internalLink` , `category.translation.externalLink` , `category.translation.externalLink` as `category.externalLink` , `category.translation.linkNewTab` , `category.translation.linkNewTab` as `category.linkNewTab` , `category.translation.description` , `category.translation.description` as `category.description` , `category.translation.metaTitle` , `category.translation.metaTitle` as `category.metaTitle` , `category.translation.metaDescription` , `category.translation.metaDescription` as `category.metaDescription` , `category.translation.keywords` , `category.translation.keywords` as `category.keywords` , `category.translation.customFields` , `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation` . `category_id` , `category.translation` . `category_version_id` , `category.translation` . `breadcrumb` as `category.translation.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation` . `slot_config` as `category.translation.slotConfig` , `category.translation` . `link_type` as `category.translation.linkType` , `category.translation` . `internal_link` as `category.translation.internalLink` , `category.translation` . `external_link` as `category.translation.externalLink` , `category.translation` . `link_new_tab` as `category.translation.linkNewTab` , `category.translation` . `description` as `category.translation.description` , `category.translation` . `meta_title` as `category.translation.metaTitle` , `category.translation` . `meta_description` as `category.translation.metaDescription` , `category.translation` . `keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation` . `language_id` = ? ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . `category_version_id` = `category` . `version_id` WHERE (`category` . `version_id` = ? ) AND (`category` . `id` IN (? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4% "
b"\x01 æÄC\¼t«ÉÍ_£Ûd╬y "
]
SELECT
`category` . `id` as `category.id` ,
`category` . `version_id` as `category.versionId` ,
`category` . `parent_id` as `category.parentId` ,
`category` . `parent_version_id` as `category.parentVersionId` ,
`category` . `after_category_id` as `category.afterCategoryId` ,
`category` . `after_category_version_id` as `category.afterCategoryVersionId` ,
`category` . `media_id` as `category.mediaId` ,
`category` . `display_nested_products` as `category.displayNestedProducts` ,
`category` . `auto_increment` as `category.autoIncrement` ,
`category` . `level` as `category.level` ,
`category` . `path` as `category.path` ,
`category` . `child_count` as `category.childCount` ,
`category` . `type` as `category.type` ,
`category` . `product_assignment_type` as `category.productAssignmentType` ,
`category` . `visible` as `category.visible` ,
`category` . `active` as `category.active` ,
`category` . `cms_page_id` as `category.cmsPageId` ,
`category` . `cms_page_version_id` as `category.cmsPageVersionId` ,
`category` . `product_stream_id` as `category.productStreamId` ,
`category` . `custom_entity_type_id` as `category.customEntityTypeId` ,
`category` . `created_at` as `category.createdAt` ,
`category` . `updated_at` as `category.updatedAt` ,
`category.translation.name` ,
`category.translation.name` as `category.name` ,
`category.translation.breadcrumb` ,
`category.translation.breadcrumb` as `category.breadcrumb` ,
`category.translation.slotConfig` ,
`category.translation.slotConfig` as `category.slotConfig` ,
`category.translation.linkType` ,
`category.translation.linkType` as `category.linkType` ,
`category.translation.internalLink` ,
`category.translation.internalLink` as `category.internalLink` ,
`category.translation.externalLink` ,
`category.translation.externalLink` as `category.externalLink` ,
`category.translation.linkNewTab` ,
`category.translation.linkNewTab` as `category.linkNewTab` ,
`category.translation.description` ,
`category.translation.description` as `category.description` ,
`category.translation.metaTitle` ,
`category.translation.metaTitle` as `category.metaTitle` ,
`category.translation.metaDescription` ,
`category.translation.metaDescription` as `category.metaDescription` ,
`category.translation.keywords` ,
`category.translation.keywords` as `category.keywords` ,
`category.translation.customFields` ,
`category.translation.customFields` as `category.customFields`
FROM
`category`
LEFT JOIN (
SELECT
`category.translation` . `category_id` ,
`category.translation` . `category_version_id` ,
`category.translation` . `breadcrumb` as `category.translation.breadcrumb` ,
`category.translation` . `name` as `category.translation.name` ,
`category.translation` . `custom_fields` as `category.translation.customFields` ,
`category.translation` . `slot_config` as `category.translation.slotConfig` ,
`category.translation` . `link_type` as `category.translation.linkType` ,
`category.translation` . `internal_link` as `category.translation.internalLink` ,
`category.translation` . `external_link` as `category.translation.externalLink` ,
`category.translation` . `link_new_tab` as `category.translation.linkNewTab` ,
`category.translation` . `description` as `category.translation.description` ,
`category.translation` . `meta_title` as `category.translation.metaTitle` ,
`category.translation` . `meta_description` as `category.translation.metaDescription` ,
`category.translation` . `keywords` as `category.translation.keywords`
FROM
`category_translation` `category.translation`
WHERE
`category.translation` . `language_id` = ?
) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id`
AND `category.category_translation` . `category_version_id` = `category` . `version_id`
WHERE
(`category` . `version_id` = ? )
AND (
`category` . `id` IN (? )
)
Copy
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.translation.name` , `category.translation.name` as `category.name` , `category.translation.breadcrumb` , `category.translation.breadcrumb` as `category.breadcrumb` , `category.translation.slotConfig` , `category.translation.slotConfig` as `category.slotConfig` , `category.translation.linkType` , `category.translation.linkType` as `category.linkType` , `category.translation.internalLink` , `category.translation.internalLink` as `category.internalLink` , `category.translation.externalLink` , `category.translation.externalLink` as `category.externalLink` , `category.translation.linkNewTab` , `category.translation.linkNewTab` as `category.linkNewTab` , `category.translation.description` , `category.translation.description` as `category.description` , `category.translation.metaTitle` , `category.translation.metaTitle` as `category.metaTitle` , `category.translation.metaDescription` , `category.translation.metaDescription` as `category.metaDescription` , `category.translation.keywords` , `category.translation.keywords` as `category.keywords` , `category.translation.customFields` , `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation` . `category_id` , `category.translation` . `category_version_id` , `category.translation` . `breadcrumb` as `category.translation.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation` . `slot_config` as `category.translation.slotConfig` , `category.translation` . `link_type` as `category.translation.linkType` , `category.translation` . `internal_link` as `category.translation.internalLink` , `category.translation` . `external_link` as `category.translation.externalLink` , `category.translation` . `link_new_tab` as `category.translation.linkNewTab` , `category.translation` . `description` as `category.translation.description` , `category.translation` . `meta_title` as `category.translation.metaTitle` , `category.translation` . `meta_description` as `category.translation.metaDescription` , `category.translation` . `keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . `category_version_id` = `category` . `version_id` WHERE (`category` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (`category` . `id` IN (0x01918E435CAC74AE90D65F9CEA64CE79 ));
Copy
0.76 ms (1.08%)
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.75 ms (1.07%)
1
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ? ) AND (token = ? ) LIMIT 1
Parameters :
[
b"\x01 ‘J13£x"‰m\f p²ý;g "
"6wuwqOg3hxmksdY2PxpA0qbK3OBjjFmR "
]
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0x01914A3133A37822896D0C70B2FD3B67 ) AND (token = '6wuwqOg3hxmksdY2PxpA0qbK3OBjjFmR' ) LIMIT 1 ;
Copy
0.74 ms (1.05%)
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.72 ms (1.03%)
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.72 ms (1.02%)
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/Weiss,%20Hans "
"author/Weiss,%20Hans/ "
]
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/Weiss,%20Hans' OR seo_path_info = 'author/Weiss,%20Hans/' ));
Copy
0.71 ms (1.01%)
1
SELECT LOWER (HEX (`id` )) AS `id` FROM `moorl_magazine_article` WHERE (`updated_at` IS NULL OR (`show_from` > `updated_at` AND `show_from` < '2026-02-04T13:29:25+00:00' ) OR (`show_until` > `updated_at` AND `show_until` < '2026-02-04T13:29:25+00:00' )) AND `active` = '1' ;
SELECT LOWER (HEX (`id` )) AS `id` FROM `moorl_magazine_article` WHERE (`updated_at` IS NULL OR (`show_from` > `updated_at` AND `show_from` < '2026-02-04T13:29:25+00:00' ) OR (`show_until` > `updated_at` AND `show_until` < '2026-02-04T13:29:25+00:00' )) AND `active` = '1' ; ;
Copy
0.71 ms (1.01%)
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.68 ms (0.96%)
1
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = ?
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = 'de-DE' ;
Copy
0.66 ms (0.94%)
1
SELECT `country` . `id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country` . `id` = `country.salesChannels.mapping` . `country_id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping` . `sales_channel_id` = `country.salesChannels` . `id` WHERE (`country.salesChannels` . `id` = ? ) GROUP BY `country` . `id`
Parameters :
[
b"\x01 ‘J13£x"‰m\f p²ý;g "
]
SELECT `country` . `id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country` . `id` = `country.salesChannels.mapping` . `country_id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping` . `sales_channel_id` = `country.salesChannels` . `id` WHERE (`country.salesChannels` . `id` = 0x01914A3133A37822896D0C70B2FD3B67 ) GROUP BY `country` . `id` ;
Copy
0.64 ms (0.91%)
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.64 ms (0.90%)
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.63 ms (0.90%)
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.62 ms (0.88%)
1
SELECT path FROM category WHERE id = ?
Parameters :
[
b"\x01 æÄC\¼t«ÉÍ_£Ûd╬y "
]
SELECT path FROM category WHERE id = 0x01918E435CAC74AE90D65F9CEA64CE79 ;
Copy
0.60 ms (0.85%)
2
SELECT LOWER (HEX (parent_id )) FROM language WHERE id = ?
Parameters :
[
"0190a5d21558701cb17a1f89991d17e2 "
]
SELECT LOWER (HEX (parent_id )) FROM language WHERE id = '0190a5d21558701cb17a1f89991d17e2' ;
Copy
0.60 ms (0.85%)
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/Weiss,%20Hans "
]
SELECT path_info pathInfo , seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (sales_channel_id = 0x01914A3133A37822896D0C70B2FD3B67 ) AND (path_info = '/author/Weiss,%20Hans' ) AND (is_canonical = 1 ) LIMIT 1 ;
Copy
0.60 ms (0.85%)
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.58 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.48 ms (0.68%)
1
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = ?
Parameters :
[
"6wuwqOg3hxmksdY2PxpA0qbK3OBjjFmR "
]
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = '6wuwqOg3hxmksdY2PxpA0qbK3OBjjFmR' ;
Copy
0.47 ms (0.66%)
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.46 ms (0.66%)
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.46 ms (0.65%)
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.44 ms (0.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
0.40 ms (0.56%)
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.33 ms (0.47%)
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.32 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.30 ms (0.43%)
1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1 ;
Copy
0.29 ms (0.42%)
1
SELECT min_search_length FROM product_search_config WHERE language_id = ?
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT min_search_length FROM product_search_config WHERE language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ;
Copy
0.23 ms (0.32%)
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