10.78 ms (15.45%)
19
SELECT `currency` . `id` as `currency.id` , `currency` . `factor` as `currency.factor` , `currency` . `symbol` as `currency.symbol` , `currency` . `iso_code` as `currency.isoCode` , `currency` . `position` as `currency.position` , `currency` . `tax_free_from` as `currency.taxFreeFrom` , `currency` . `item_rounding` as `currency.itemRounding` , `currency` . `total_rounding` as `currency.totalRounding` , `currency` . `created_at` as `currency.createdAt` , `currency` . `updated_at` as `currency.updatedAt` , `currency.translation.shortName` , `currency.translation.shortName` as `currency.shortName` , `currency.translation.name` , `currency.translation.name` as `currency.name` , `currency.translation.customFields` , `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation` . `currency_id` , `currency.translation` . `short_name` as `currency.translation.shortName` , `currency.translation` . `name` as `currency.translation.name` , `currency.translation` . `custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation` . `language_id` = ? ) `currency.currency_translation` ON `currency.currency_translation` . `currency_id` = `currency` . `id` WHERE (`currency` . `iso_code` IN (? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
"CHF "
]
SELECT `currency` . `id` as `currency.id` , `currency` . `factor` as `currency.factor` , `currency` . `symbol` as `currency.symbol` , `currency` . `iso_code` as `currency.isoCode` , `currency` . `position` as `currency.position` , `currency` . `tax_free_from` as `currency.taxFreeFrom` , `currency` . `item_rounding` as `currency.itemRounding` , `currency` . `total_rounding` as `currency.totalRounding` , `currency` . `created_at` as `currency.createdAt` , `currency` . `updated_at` as `currency.updatedAt` , `currency.translation.shortName` , `currency.translation.shortName` as `currency.shortName` , `currency.translation.name` , `currency.translation.name` as `currency.name` , `currency.translation.customFields` , `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation` . `currency_id` , `currency.translation` . `short_name` as `currency.translation.shortName` , `currency.translation` . `name` as `currency.translation.name` , `currency.translation` . `custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `currency.currency_translation` ON `currency.currency_translation` . `currency_id` = `currency` . `id` WHERE (`currency` . `iso_code` IN ('CHF' ));
Copy
10.17 ms (14.57%)
2
SELECT `key` , `value` FROM `app_config`
SELECT `key` , `value` FROM `app_config` ;
Copy
9.18 ms (13.16%)
1
SELECT `meta_catalog_id` . `id` FROM `meta_catalog_id` WHERE `meta_catalog_id` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"\x0E nÔr\x05 HÔÓd\x12 ,‚wt“µ "
b"×°«\x08 Yò\x17 ▄üD"·z¶É░ "
b"\x07 Z‡\x15 ú\x12\x04 …!õ\x01 ,ZÇû" "
b"\x01 ¦º"Ç\x11 :ú¶5`}D,… "
b"Cs°¢2åÍJÅ<p,ü\x1E ▄É "
b"\x15 ┬Í··^.ż■┌\x14 X¸Þ} "
b"+ذ¥\t 'â°Ngy─Êı¼| "
b"\x7F\x01 ©wÚøÝêqÖQyê\x17 »! "
b"pŠ\x16 QÍšŽÍìM6nE—e\x12 "
b"§Å3¢˜ºTámÑF‚\x13 8¨ "
b"\x1C SûYɘL²î0ÃÕY\x1E R\t "
b"úëŸÏhC€¹®÷\\f {á„G "
b"q®½,\x1C „\x04\x05 û<\x03 ˜0É4u "
b"ò\x16 çøÝ èŠj¯KÚ5‡•* "
b"|\v Œy¢ºóp|£$j¯Dš€ "
b"²\x0F wÎJ\x16 ¯1s\x08 ÌÜSé#÷ "
b"H¨2N܈tÿÚˆÈþ W³û "
b"‚‹¹)´lCk9HÛ%EÁ [ "
b"üÊÍ\x1D ©\x1E d?\v رéÎ┐{ "
b"Xw\x12 Å\x19 E4%ç"ß©L~\x12\x04 "
b";äÚ\x0E >"\x1C *„\e gº>Òî” "
b"÷ßmp®\x13 ^kº░\x0E jØw\v È "
b"ù\f vû˜Œ¾VÞXÜ\e óQú€ "
b"QàTXqª]¢Yï<H\f Œ\x02 ¡ "
b"r³½Ì\x1E K2pËq5ï/3÷ "
b"R)â\x06 îʉA0Êäöûé\x1A é "
b"vc\x05 `\x13 ±ZÇ‚B\x15 ¿£e\x07 § "
b"%6ÅðÃh*\x14 ”éÎûÌ72Ë "
b";5{¹…w»\x05 #zçè¦o5› "
b""Ö¼DÞû¢Äpf°EÕg¯+ "
b"d\x02 Îõ„K’Èßàéö3"ok "
b"ç\x17 \x1F Û}€—Å›[`8Äl5 "
b"ÈÙœ\x11 @¦ô^¡Üš5ñ¨‡‘ "
b"\x1F Éü\t n¹(ò±´"h£\x08\x13 U "
b"Á߆+Þ\¶Ú&\x1C b|‘ª›\x13 "
b"‰¾‡\x18 Þõ\x12 NP¢šiÿ?›\x13 "
b"©6ˆ¨ÖAÆ&@‡J5²Ì\x1D 9 "
b"\x07 Q6Ú/\f ÕƒŸe‰GâTê7 "
b"É■ºâ╗¤8\x00 µ╣~■=µ▒º "
b"ÒãeÍY›€û£‘l¼¶&‰{ "
b"`\x11 ÝZÐíôá-ó\x06 ‡ÒôU\x10 "
b"""
\n
\x1E }¢nÎÙ´╔ÂùØÆ5¿=
"""
b"ï \x07 ¤½\v „McS‚KÅ&w/ "
b"pR!W\x18\x7F ¦lØ\x13 ░\x08 Ì2'µ "
b"\x12 BªµMç&j„gÒ•B¢=2 "
b"ˆ\x03 †Gñ¬\x14 W\x06 PêœÙïN¢ "
b"0JÝ™Ý9ñ—kÙu2щ\ "
b"£¸Ñs┼4¿§\x15 ÛÅI─¶\x01 & "
b"_9†Žë}S\x16 *SNœôh,Ú "
b"KyìÓÓx^¦æé/Ø=\x10 ½µ "
b"ò*Ü▀ë┐ØÑ█░▓O\x12 ¬üÆ "
b"C.x¬öôäbüÛ\x19 ¸ejl\x1F "
b"\x11 Œü?hÿ¬O‘/—8ÚjÄw "
b"µåWw®±³òï"±×ËiIž "
b"\x0F “¿\x06 nY¤dhxŽÔ¾ç÷ "
b"Í&u›'-¸\f í9§oq¦ëb "
b"›[\x12 V\x11 ž´b^±¸ˆ,§\x1A ½ "
b"YÀEJ[&«$\x17 L]\x7F ºæó2 "
b"Æ^Pn\x12 P╬║\x04 âüDÁ\x11\x06\x18 "
b"¤\x06 LgÍ鞺v’\x19 >0\x01\x02 Š "
b"åÕ\x14 aáù]k÷¸Åä│░\x11 c "
b"î\x7F ŠQJ\x15 ÙŽ°~`ÚA…S" "
b"ËêZÏÙ~gÑ\\t\x04 ˆ‚õ·õ "
b"Ðw²\x08 ¶9\x1A ²…Ï \t Ô "
b"-Ts\x19 ‹ø\x13 GÄÿ÷ι’7\x10 "
b"vgAx@Ù¥Gä*ÏîoFì² "
b"\x19 ±Ôþ#á\x0E !¦U]\x01 ä«‰Ö "
b"""
¸W\x15 %Ù/\n
çóŒYj¶kãJ
"""
b"¥\x03 ¿ÝTfžðýù©±m+n\x13 "
b"42å.kA├\x10 Ø┘\e ¯(O╝À "
b" ÅІ€)ƒ°QÑÈqÎc\x17 ˆ "
b"W\x16 M░\x0E É▓┼╗┼jOF9}á "
b"Ç;¯╩üı▒│ZÞk`S(ç "
b"£Œ\x1E „pm\x1D Eªý,Ë<A¾9 "
b"/†ìAk\x17 N§÷·9©\x02 Á\x17 ç "
b"êVj¹Äï¤ï©Êwc~éüm "
b"""
\x7F û©TºeÈôD™_f,\x17 \n
_
"""
b"\r Y+ý\x0F [â└Ų\x7F\x14 ▒0OP "
b"¼\x0F ×lçz³—5èžù‚\r »- "
b"²5\x17\x12 ╔Î\x19\x03 ┼ÅJÿ®╣õ` "
b"™ü\x10 €!\x1A ˆÒµäÞõß\x01 Xç "
b"ßÔÅÌ7§x×Á"Ij¯L@£ "
b"_¬Ý´\r æë†ý+ÙF¥\x0E\x06 p "
b"§(î═Ã^ý╔0ƒ╦Å·█W[ "
b" všÏé\x08 Tu\x03 “•\x1A n,†= "
b"VÆÔßy¿«Ù{3¤Üóé\x19 ³ "
b"\x14 gw„¹nm»Á°%L\x14 AÒú "
b"èC&ùŠAÜ/¢šõF\x04 “ˆ\f "
b"\e %\f\f &¥\x1C ÐÚεÒþ "
b"Õ˜u‘¡Rö%hA4\x10 ]\f -( "
b"ö—B9¡Í+ß¾\x01 î‰YÔT "
b"ûí‹f3¦/¯¦tÑ\Ìò·› "
b"±±«Mp\x18 Åû7çdµ\x1D N2÷ "
b"üªÃ¹fSïå\x11 ▒Eqp‗\x12 Ù "
b"Ûåy…%›˜¦é\x12 ›?F-Ð' "
b"ãpú)\x16 ²ä”ñ‚£±«~cn "
b"b\x04 ë?\JüË\f ƒ*\e ┼[\x08 ý "
b"jË░cnسj╩Và" É ª "
b"»|JÛ%™¢::&\x03 Ü\x05 8€8 "
b"q¿Ù:?|\x1F h‚û–\x1C «¸m† "
b"\f p\x0F ÊPÇ\x1F ®ïX(>,, ³ "
b"áiæ\t óìÚK¦nõ\x0F\x08 "èü "
b"å\r \x1E F¯Ìþ&=ó›\x14 fiAØ "
b"í‡6úXO£ø“ð›O\x1E ™Åb "
b"Mlop5OõåÌ\e y@Û\x1D\x00 c "
b"\x16 ±Yç¦Zü\x0E (Š*‘Êä“â "
b"d¢ª•d\x00 ÞdLqu;¨kœ” "
b"Ãì¶öîG»Q\f\x15 í\x10 ig/P "
b"¼ÕlEì J┐Üf\x07 Þç\x15 5÷ "
b"/AÆìcàhMÏã¯\x19 Àê\t\x17 "
b"âJLZö„Þêèƒ ù”(A\x16 "
b"ơЬRÚ²®j\x07 ▒dû░Éù "
b"""
ÙrÛä\n
S+¿Ær‹$ uN@
"""
b"òü6ì²\x03 §gûØ!Ç¡ÌC\x1C "
b"8+^Pýai*\x0E øDÅËñ[‗ "
b"‡\x1A æ*d…4³_¬\x17 ò8²Vš "
b"""
MU]\x7F Ô4»ØcV©N\n
zøD
"""
b"à\x0F ‹+Öç\x03 ²{\x07 ›aµ¨\x7F ÿ "
b"""
h»f»-ÕÒ╝■K9]\n
\x13 >ì
"""
b"\x12 5Ëî(”xB€+\x1E 'Ÿ)å\v "
b"¯ÒU\t !×O\v =&ïŒ\x0E ý,¶ "
b"╩íÚýKÐ╔]ÏóD(É_v┘ "
b"Ó\x07 fYüuÏaaŽFgá}\x1D q "
b"\x10\x19 †\x17 㜿,&^L\e Žd†M "
b""\x07\x08 #éσ\x11 WØÁ$3ªÈA "
b"uı·gß8Óùìö\x17 Ô\x10 \r fÑ "
b"\x00 `é‡\x00 Ø@x\x17 @s'”A›+ "
b",sé╩Þ·:ù_ÅÈÅoè\x0F\f "
b"8—Õ8›{FÑ«%o½’·ïš "
b"å\e\x1C\x16 \}u°]:ߣ7õ\x14 ¥ "
b"ôö\e Ö,¥Vô4£7Å\e š\x7F "
b"¯Q·óV¯º`ÃŽ'í[Q¶ "
b"©Ž¦A,\x19 ¯È€Îå•Ëw‡J "
b")Æ=¢J\v @[Å\x05 ËpY;,' "
b"â±└ì¸,┴ó3o~╦\x18 ┼Á+ "
b"\x14 £\x02 .Â\x12 p-+í¦ÁýR╬Ø "
b"RíøNô²KsÏ|€qíÛýú "
b"Îq\x13 ґήD7xD/¬ "
b"‚Þ\x03 %XYÕ–õ5®2Je\x1E ¿ "
b"r\x16 áýòbÌ├;0\x12\x17 ½¼Øª "
b"y‚òô¨¯\x1E\x7F ¢à\x1C .EÖú° "
b"Mѯ©/å[„IÐÉòµAHÀ "
b"@IÌêCE‰ß$Ö\v j™œÛg "
b"˜3 M?\t •ð!î<V\mûv "
b"""
/\x02\x04 ¤à¬`®ü(\x11 Õ\n
>C
"""
b"\x19\x19 €\x1C y\r E¤Ñ\x01 |î$=w~ "
b"\e 0KÄâF\x0E \x0E 8è\x14 i&¡ù "
b"µ■ìP3º\x14 |Ï¿æÇ`n┼ "
b"C®Þ`\f «\x0F ùºQp´V‰\x05 "
b"\x1E ¦+h\x01 1\x17 Xæ\x10 Ü5?‰S5 "
b"Ö<úÉ\x17 Ö▀O\x1C\v ┴\x14 \Ó┤u "
b"EPäbNÅ░üö²I^©1ìÆ "
b"ßq\x1E ;®‚ºÎ\x04\x01 å”*´Ü "
b"\\t ]»æÙk·µ\x0E …ÙDaN& "
b"køUÔ/˜kGÞq ÛÔ·\x0E · "
b"tŒÊt\r ˜þþåĈ#fðÓ "
b"‰Ø×\x14 ŸØP+«ñ;Ò¬˜‰J "
b"×\x07\x01 ’]\x15 c\x11\x05 c8Dî~Àf "
b"GV\x10 Ô\x01 j–r/Í*µÄ3oB "
b"\v ³Ï¹@Æ\x16 ‚c±ö;Ž÷¨! "
b"ò€ozr=’dÇ\e j©â§W\x7F "
b"Öà\e Ëê\x04 çðPO‚²¬È¸ "
b".\x12 O|\x0E \ºQ¼Ú]Ž›‹äí "
b"g\e }`8äø\x1E aí“qÇ𤃠"
b"NUdvÜO▒*Õ╚\x18 75Cì┼ "
b"ÊãˆT1z4xAñ=\t ð\x14 äÈ "
b",ŸÅU\t €W$\x18\x03 ˆBqÈöË "
b"û\x11 ¾è\x11 Æ’^Í•³A¤ç¼| "
b"²U\x19 WJ┴ ³ì░Ø\┬\x1C ╣ò "
b"""
▒üG\n
╠¦1\x1A aHðy\x19 åçÚ
"""
b"â/\x11 µ\x04 n}¥D\x18 ?>ûÑÛ# "
b"\x10\x1C ÌããW%þ‹øÕG‘%ža "
b"?Ø‘{]\x00\x0F ç/øx\e í1 "
b"±^ªÓ¢ °ì┐ÙÜ─└a¬ñ "
b"%█\x02 s├×è█E\x11 +#è zØ "
b"T'h\%~Ì6íEzüÞÛýf "
b"""
‹ŸG.S\e `°+ð=\n
I+Í]
"""
b"ÄW‘}2Že$H\x7F N¨#¿\x17 ê "
b"7V*\™¿™1Ô§\x10 ò?øîÎ "
b"│mMå\x1D Kæ\x1F q³-ãüF÷F "
b"ðï7\x14 ÔûòL\x02 æëƒ\x1A\f\x01 a "
b"Y(EæŽÅN¹¹rPBîË\x17 e "
b"G\x1D óú\x12 ÏÎ3ᨙ×kî«þ "
b";¾Ó…eí²]í¡Á;Uï-ó "
b"Wøo$Á`]?ô$éÊò¦ÿÉ "
b",£\x12 *bý(ûΚ^/é\x1F ä\r "
b"¯âä½Úf‘²5<@{Ç\x7F — "
b"1£ÇÿÉC\x01 ’¢\x00 /²\x18 †a{ "
b"\x12\x12 µD£˜¼Ìq|mG\x07 @`„ "
b":Ý`äË®À 8Ã`e\x1F µu\x03 "
b"Œ†Ì´\x19 軤ú4R$ü7&U "
b"ù┘tëôé®êÅL }¯¡\x02\x7F "
b"°j‚¥\x0E î\x15 w½ \x03 p\x00 ¡Ñÿ "
b"\x19\x18 ¨]}è@e~ǨùúÉ¥¸ "
b"─}^vT÷\x0E Å÷D╗åü\x03 ÙN "
b"ÜŸj•ª·¹»\x19 J[\e 'Hê÷ "
b"S\(`¤#Ëòõ_9üwW¯▀ "
b"€\t Ý 1雿Ö'ç{ØÌ\x05 Ì "
b"é>к¢Æ\x18 P÷G\x06 …Swèã "
b"*Ç´Ñ^p\x1C\x04 -±ì«ð,rS "
b"êÞÅA_7\t l!\x7F tÚW\x14 .F "
b"8nôVÉñøã░X»;÷Êߣ "
b"""
øÜ\f Øç¨N¦«\n
=\t 2,░
"""
b"y5┘─YÁ\x0E ª=Ç;ì;*B£ "
b"""
OÎ\x1D ™\x1E Õ6Dá\n
k\x1D ݩxz
"""
b"W)©Ó’ÚNøÄä…vnÚ”k "
b"`\v NŽkgLº|e\x08 NYQ<Â "
b"Š+-¦•ã¥_G¸Á³àm©¹ "
b"\x13 é’Ö…k\e Èš•€Ÿ¾ô_v "
b"Ì5\x1F ´¨ s{Q"F@]ŠI¢ "
b"ÓP\x7F ü½O6¡º }¹tUî³ "
b"Óa+€k•\x08 ò\x1E\x0F s.öt\x1A , "
b"©«íÉ\x19 º¼ø\x1C &´\x08 PSÅ\x01 "
b"Ðml)×_LBLm9Û!¯p\x11 "
b"”©\x19 „6`féu◤˹\x0E "
b"ÒR\x11 ž\x16 åå¶ëNûÄ0ùÞÏ "
b"á╗cÏÙÏU▀DKå[ü1\x10 ¾ "
b"hwžÂRôô¨”\t Cß\x11 Û¡¹ "
b"\x07 üÑô9 ;n\e wÄ▀àØw' "
b"+¾\x07 h!ÍlõƒÑ\x1C ÚíÉ*Ç "
b"-‚8Ï\x7F o\t ˆ\e {T5-\x03 "Ö "
b"fþd\t SµOÿLŽÅ½8»Ó "
b"I¾¯¢L\x15\x12 ßà8R]▓ü±+ "
b"ª_[=æûîÜd│É╩p─r\x13 "
b"sçX¨¬\x10 Ü\x1C e┴´QÉ═* "
b"À¿f4¡▀KÏìJ═┬\x1C û\x05\x06 "
b"ÅaŒPK¸N»ªÑÁ\x17 ïóªÂ "
b"Ö³qº~/²§Ê#Rgþó6\x18 "
b"~>ŽZE\x11 ÄÒ\x1C\x1F „\x04\x05 ²)~ "
b"Ä?\x08 ‗ÀW¤┬G¿É ¥,÷ã "
b"â\x00 K5»\x10 €rS06G|òÄB "
b"9\x05 Ž\x12 ¸| À§ï„7&‡\x12 "
b"áÄDµ²º’én[“ñ<÷@” "
b"?\x07 MtjN\x07 J!u\x17\x18 ÎJb‡ "
b"Ð\x1E éÙXô\¸=ȵ\x01 lûŽO "
b"»f ó 9\x15\x7F 3)\x07 »ä•Úl "
b"6ç@Ø▒^`\x1C ª%è.Y^└K "
b"ù\x19 É\■¡╝ø©)¢U»}ÑP "
b"Ö®• ºC\x1E ;`þ\x0E\x1F Ï‘Ü6 "
b"‡:Talmý&¬Ä1y†é9\x1C "
b"o`N¨$%àuY©©Pˆ2Ñ\e "
b"\x03\x07 ²(€ÊJ2oÄ\x1E J¢93+ "
b"Ð\x1C <WV(¥l\x13 `€9óï"“ "
b"U&‚N\x01\x05 Žl\x1A ¾jžo,U³ "
b"\x03 äçáòûO\x18 .EO¼îSMÅ "
b"µ4Ÿ“\x1E ׎\x08\x02 2\x02 H“äëÓ "
b"TŒ£Û¤ŸóÍ^\v û¨»Òÿë "
b"áã\x04 ÑT×┘└¦¦ëÓxá╠ì "
b"¢ë¶÷1Ùv…*:\x16 Ç\x04 ô){ "
b"#©*ã\x1C ìî^5ÌÌ\x0F ptÝ\x12 "
b"ó\x0E øAeÁ·Bö\Eô‘²sp "
b"§»û´ÄoB\e µ\x02 ðü\x10 "— "
b"\r ÆÏ\x18 )òûºN®â>\x08 þt^ "
b"õ\x11 ^ˆ\x08\x14 „h\x15\x10 \Fh³\x10 "
b"KC\x02 :\x1F ©”§y‰EŰïƒ2 "
b"""
°,&ec©\x17 )øŸz\n
Oþ²}
"""
b"\x0E @ìÉ!0ST;åÎ<¸3┴Î "
b"®½<%.ÙƒK3§ñ®ª_M) "
b"\x0F yãÈê1 ®¥\x1D ¥ÝÄ>Åó "
b"\x13\x02 x)ü©À®¶X øJ!\x06 ^ "
b"""
Ã\n
Þö\x11 J¤”§1¦¡%%åd
"""
b"Ǹ■:È┴Åh¡ªÇO#³═Ë "
b"R9S5\x19\x12 ¢|¯\x19\x13 %`\x15 Ìe "
b"2<Ýø æØ$\x0F\x16 þ§ã×*o "
b"˜5ÉUì;ï$ï›ð>/\x1F ‹¨ "
b"´²×´ýøZ░├xüÉ'r¡Ç "
b"%Ð @X'šíFUḦøñ± "
b"8ΕpÍIúaJ_nÑ\x1F f\x1C * "
b"\x0F └\x1D\x19 ÏyòaëÈ\x16 ü°9C\x06 "
b"×\t à3è¿~V<‘GA\e "
]
SELECT
`meta_catalog_id` . `id`
FROM
`meta_catalog_id`
WHERE
`meta_catalog_id` . `id` IN (
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
?
)
Copy
SELECT `meta_catalog_id` . `id` FROM `meta_catalog_id` WHERE `meta_catalog_id` . `id` IN (0x0E6ED4720548D4D364122C82777493B5 , 0x9EF8AE08599517DC814422FA7AF490B0 , 0x075A8715FA12048521F5012C5AC7FB22 , 0x01A6BA22C7113AFAB635607D442CAD85 , 0x4373F8BD3286D64A8F3C702C811EDC90 , 0x15C2D6FAFA5E2E8FACFEDA1458F7E87D , 0x2B9DF8BE092783F84E6779C4D2D5AC7C , 0x7F01A977DAF8DDEA71D65179EA17BB21 , 0x708A1651CD9A8ECDEC4D366E45976512 , 0xA7C533A298BA54C3A16DD146821338A8 , 0x1C53FB59C9984CB2EE30C3D5591E5209 , 0xFAEB9FCF684380B9AEF75C0C7BE18447 , 0x71AEBD2C1C840405FB3C039830C93475 , 0xF216E7F8DD20E88A6AAF4BDA3587952A , 0x7C0B8C79A2BAF3707CA3246AAF449A80 , 0xB20F77CE4A16AF317308CCDC53E923F7 , 0x48A8324EDC8874FFDA88C8FEA057B3FB , 0x828BB929B46C436B3948DB2545C1205B , 0x81D2D61DB81E64F03F0B9DF182D7BF7B , 0x587712C519453425E722DFA94C7E1204 , 0x3BE4DA0E3E221C2A841B67BA3ED2EE94 , 0xF6E16D70A9135E6BA7B00E6A9D770BD4 , 0xF90C76FB988CBE56DE58DC1BF351FA80 , 0x51E0545871AA5DA259EF3C480C8C02A1 , 0x72B3BDCC1E4B3270CB7135EF2F33F7A0 , 0x5229E206EECA894130CAE4F6FBE91AE9 , 0x7663056013B15AC7824215BFA36507A7 , 0x2536C5F0C3682A1494E9CEFBCC3732CB , 0x3B357BB98577BB05237AE7E8A66F359B , 0x22D6BC44DEFBA2C47066B045D567AF2B , 0x6402CEF5844B92C8DFE0E9F633226F6B , 0xE717AD1FDB7D8097C59B5B6038C46C35 , 0xC8D99C1140A6F45EA1DC9A35F1A88791 , 0x1F9081096EFB2895F1EF22689C081355 , 0xC1DF862BDE5CB6DA261C627C91AA9B13 , 0x89BE8718DEF5124E50A29A69FF3F9B13 , 0xA93688A8D641C62640874A35B2CC1D39 , 0x075136DA2F0CD5839F658947E254EA37 , 0x90FEA783BBCF3800E6B97EFE3DE6B1A7 , 0xD2E365CD599B80FBA3916CBCB626897B , 0x6011DD5AD0EDF4E12DF30687D2F45510 , 0x0A1E7DBD6ED7EBEFC9B6979D9235A83D , 0xEFA007A4BD0B844D6353824BC526772F , 0x70522157187FDD6C9D13B008DE3227E6 , 0x1242AAB54DE7266A8467D29542A23D32 , 0x88038647F1AC14570650EA9CD9EF4EA2 , 0x304ADD99DD39F1976BD9AD7532D1895C , 0x9CF7A573C534A8F515EA8F49C4F40126 , 0x5F39868EEB7D53162A534E9CF4682CDA , 0x4B798DE0E0785EDD91822F9D3D10ABE6 , 0x952A9ADF89BF9DA5DBB0B24F12AA8192 , 0x432E78AA9493846281EA19F7656A6C1F , 0x118CFC3F68FFAC4F912F9738DA6AC477 , 0xB5E55777AEB1B3F2EF22B1D7CB69499E , 0x0F93BF066E59A46468788ED4C2BEE7F7 , 0xCD26759B272DB80CED39A76F71A6EB62 , 0x9B5B1256119EB4625EB1B8882CA71ABD , 0x59C0454A5B26AB24174C5D7FBAE6F332 , 0x925E506E1250CEBA04838144B5110618 , 0xA4064C67CDE99EBA7692193E3001028A , 0x86E51461A0975D6BF6F78F84B3B01163 , 0xEE7F8A514A15D98EB07E60DA41855322 , 0xCBEA5ACFD97E67D15C09048882F5B7F5 , 0xD077B208EEA6A4B6391AB285CF2009D4 , 0x2D5473198BF81347C4FFF7CEB9923710 , 0x7667417840EBBE47842AD88C6F468DFD , 0x19B1D4FE23E10E21A6555D01E4AB89D6 , 0xB8571525D92F0AE7F38C596AB66BE34A , 0xA503BFDD54669EF0FDF9A9B16D2B6E13 , 0x3432862E6B41C3109DD91BEE284FBCB7 , 0xA0C5D086802983B051D1C871CE631788 , 0x57164DB00E90B2C5BBC56A4F46397DA0 , 0x803BEECA81D5B1B35AE86B605328C7F5 , 0xA38C1E84706D1D45AAFD2CCB3C41BE39 , 0x2F86EC416B174EA7F7B739A902C117E7 , 0x88566AFB8E8BCF8BB8D277637E82816D , 0x7FFBA954BA65C8F444995F662C170A5F , 0x0D592BEC0F5B83C08FFD7F14B1304F50 , 0xBC0FD76CE77AB39735E89EF9820DBB2D , 0xFD351712C9D71903C58F4A98A9B9E460 , 0x99FC1080211A88D2B5E4DEF5DF0158E7 , 0xDFD4C5CC37A778D7C122496AAF4C40A3 , 0x5FACDDB40DE6EB86FD2BD946A50E0670 , 0xF5288CCDC75EECC9309FCB8FFADB575B , 0x20769ACFE90854750393951A6E2C863D , 0x56C6D4DF79BFABD97B33A4DCF3E919B3 , 0x14677784B96E6DBBC1B0254C1441D2FA , 0xE84326F98A41DC2FA29AF5460493880C , 0xEEB9A61B250C0C26A51CD0DACEB5D2FE , 0xD5987591A152F625684134105D0C2D28 , 0xF6974239A1CDAD2BDFBE01EE8959D454 , 0xFBED8B6633A62FAFA674D15CCCF2B79B , 0xF1F1AE4D70188F96378764E61D4E32F6 , 0x81A6C7FB66538B8611B1457170F212EB , 0xDBE57985259B98A6E9129B3F462DD027 , 0xE370FA2916B2E494F182A3B1AB7E636E , 0x6204893F5C4A81D30C9F2A1BC55B08EC , 0x6AD3B0636E9DFC6ACA5685222090FFA6 , 0xBB7C4ADB2599A23A3A2603DC05388038 , 0x71BFD93A3F7C1F6882FB961CABB86D86 , 0x0C700FCA50C71FAEEF58283E2C2CA0B3 , 0xA0699109A28DE94BDD6EE40F08228A81 , 0xE50D1E46AFCCFE263DF39B14666941D8 , 0xED8736FA584FA3F893F09B4F1E99C562 , 0x4D6C6F70354FF5E5CC1B7940DB1D0063 , 0x16B159E7A65AFC0E288A2A91CAE493E2 , 0x64A2AA956400DE644C71753BA86B9C94 , 0xC78DF4948C47AF510C15A11069672F50 , 0xACE56C458DFF4ABF9A6607E8871535F6 , 0x2F41928D6385684DD8C6EE19B7880917 , 0xE24A4C5AF684DEEAE883A0F994284116 , 0x92ADD1AA52E9FDA96A07B16496B09097 , 0xD972DBE40A532BBFC6728B2420754E40 , 0xF2FC36ECB203A767FBD821C7A1CC431C , 0x382B5E50EC61692A0E9B448FD3A45BF2 , 0x871AE62A648534B35FAC17F238B2569A , 0x4D555D7FE234AF9D6356B84E0A7A9B44 , 0xE00F8B2BD6E703B27B079B61B5A87FFF , 0x68AF66AF2DE5E3BCFE4B395D0A133E8D , 0x1235CBEE28947842802B1E279F29E50B , 0xAFD2550921D74F0B3D26EF8C0EFD2CB6 , 0xCAA1E9EC4BD1C95DD8A24428905F76D9 , 0xD3076659FC75CF61618E4667E17D1D71 , 0x10198617E39CBF2C265E4C1B8E64864D , 0x2207082382D89F11579DB52433A6D441 , 0x75D5FA67E138E0978D9417E2100D66A5 , 0x0060E98700D840781740732794419B2B , 0x2C7382CAE8FA3A975F8FD48F6F8A0F0C , 0x3897D5389B7B46D1AB256FBD92B7EF9A , 0xE51B1C165C7D75B05D3ADFA337F514A5 , 0xF4F61BD6AD2CA556F434A337C51B9A7F , 0xAF51B7ADF356AFBA60C38E27ED5B51B6 , 0xA98EA6412C19AFC880CEE595CB77874A , 0x29C63DA24A0B405BC505CB70593B2C27 , 0x83F1C08DF72CC1A2336F7ECB18C5B52B , 0x149C022EB612702D2BA1DDB5EC52CE9D , 0x52EDF84EF4B24B73CF7C8071EDDBFDFA , 0xCE7113D291CEAE443778442FEE8C98AC , 0x82DE03255859D596F535AE324A651EBF , 0x7216A0EC9562DEC33B301217ABAC9DA6 , 0x7982F2F4A8AF1E7FA2E01C2E45D6FAB0 , 0x4DD1AFA92FE55B8449D0C9F2B54148C0 , 0x4049CCEA434589DF24D60B6A999CDB67 , 0x9833A04D3F0995F021EE3C565C6DFB76 , 0x2FF00204CF85AA60A9812811E50A3E43 , 0x1919801C790D45A4D1017CEE243D777E , 0x1B304BC4E2460E200E38E8146926A1F9 , 0xE6FE8D5033A7147CD8A89180606EC5FF , 0x43AEDE600CAB0FF9BA5170B4568905A0 , 0x1EA62B6801311758E610DC353F895335 , 0x993CA3901799DF4F1C0BC1145CE0B475 , 0x455084624E8FB08194FD495EB8318D92 , 0xDF711E3BAE82BACE0401E5942AB4DC20 , 0x5C095DBBE6D96BB7B50E85D944614E26 , 0x6BF855D42F986B47DE7120DBD4B70EB7 , 0x748CCAAD740D98FEFEE5C4882366F0D3 , 0x89D8D7149FD8502BABF13BD2AC98894A , 0xD70701925D15631105633844EE7EC066 , 0x475610D4016A96722FCD2AB5C4336F42 , 0x0BB3CFB940C6168263B1F63B8EF7A821 , 0xF2806F7A723D9264C71B6AA9E2A7577F , 0xD6E01BCBEA04ADE7F0504F82B2ACC8B8 , 0x2E124F7C0E5CBA51BCDA5D8E9B8BE4ED , 0x671B7D6038E4F81E61ED9371C7F0A483 , 0x4E5564769A4FB12AE5C8183735438DC5 , 0xCAE38854317A347841F13D09F014E4C8 , 0x2C9FC555098057241803884271C8F6CB , 0xFB11BEE811C6925ECD95B341A4E7BC7C , 0xFD5519574AC120FC8DB09D5CC21CB995 , 0xB181470ACCDD311A6148D079198687E9 , 0xE22F11B5046E7DA544183F3EFBD1DB23 , 0x101CCCE3E35725FE8BF8D54791259E61 , 0x3FD891AD7B5D000FE72FC3B8781BED31 , 0xF15EA6E0BD20F88DBFEB9AC4C061AAA4 , 0x25DB0273C39E8ADB45112B238A207A9D , 0x5427685C257EDE36A1457A81E8EAEC66 , 0x8B9F472E531B60B02BF03D0A492BCD5D , 0xC457917D328E6524487F4EA823BF17EA , 0x37562A5C99BF9931D4A710F23FF8EECE , 0xB36D4D861D4B911F71FC2DC68146F646 , 0xF0EF3714D4FBF24C02E6EB831A0C0161 , 0x592845E68EC54EB9B9725042EECB1765 , 0x471DF3FA12CFCE33E1A899D76BEEABFE , 0x3BBED38565EDB25DEDA1C13B55EF2DF3 , 0x57F86F24C1605D3FF424E9CAF2A6FFC9 , 0x2CA3122A62FD28FBCE9A5E2FE91FE40D , 0xAFE2E4BDDA6691C2B2353C407BC77F97 , 0x31A3C7FFC9430192A2002FB21886617B , 0x1212B544A398BCCC717C6D4707406084 , 0x3ADD60E4CBAEC0A038C360651FB57503 , 0x8C86CCB419E8BBA4FA345224FC372655 , 0x97D974899382A9888F4C207DEEAD027F , 0xB06A82A50EEE1577BDA0037000A1D1FF , 0x1918F95D7D8A40657E80F997A390BEF7 , 0xC47D5E7654F60E8FF644BB868103EB4E , 0xDC9F6A95AAB7B9BB194A5B1B2748EAF7 , 0x535C2860CF23D395E45F39817757EEDF , 0x8009DD2031E99BE6D627E77BD8CC05CC , 0xE93ED0BAA2C61850F74706855377E8E3 , 0x2AC7B4D15E701C042DB1ECABF02C7253 , 0xEADEC5415F37096C217F74DA57142E46 , 0x386E935690A49BC6B058AF3BF6D2E19C , 0x9B9A0C9D87F94EF0DDAE0A3D09322CB0 , 0x7935D9C459B50EA63D803B8D3B2A429C , 0x4FCE1D991ED53644E10A6B1DDDA9787A , 0x5729A9D392DA4EF8C4E485766EDA946B , 0x600B4E8E6B674CBA7C65084E59513CC2 , 0x8A2B2DA695E3A55F47B8C1B3E06DA9B9 , 0x13E992D6856B1BC89A95809FBEF45F76 , 0xCC351FB4A820737B512246405D8A49A2 , 0xE0507F81AB4F36ADA7FF7DFB74558CFC , 0xD3612B806B9508F21E0F732EF6741A2C , 0xB8AEA19019A7AC9B1C26EF0850538F01 , 0xD06D6C29D75F4C424C6D39DB21AF7011 , 0x94A91984366066E975E297A4C38BB90E , 0xD252119E16E5E5B6EB4EFBC430F9DECF , 0xA0BB63D8EBD855DF444B865B813110F3 , 0x68779EC252F4F4A8940943DF11DBA1B9 , 0x0781A59339203B6E1B778EDF859D7727 , 0x2BBE076821CD6CF583D11CDAEDC92AC7 , 0x2D8238CF7F6F09881B7B54352D0322D6 , 0x66FE640953B54FFF4C8EADC5BD38BBD3 , 0x49F3EEBD4C1512E18538525DB281F12B , 0xA65F5B3D91968C9A64B390CA70C47213 , 0x738758F9AA109A1C65C1EF5190F0CD2A , 0xB7A86634ADDF4BD88D4ACDC21C960506 , 0xC5618C504BB84EBBAAD1C117EFF3AAC2 , 0xD6B371BA7E2FB2A7CA235267FEF33618 , 0x7E3E8E5A4511C4D21C1F840405B2297E , 0x8E3F08F2B757CFC247A89020BE2CF6C6 , 0xE2004B35BB108072533036477CF2C442 , 0x39058E12B87CA0C0A7EF8437268712AD , 0xE1C444B5B2BA92E96E5B93F13CF74094 , 0x3F074D746A4E074A21751718CE4A6287 , 0xD01EE9D958F45CB83DC8B5016CFB8E4F , 0xBB66A0F32039157F332907BBE495DA6C , 0x3687409DB15E601CA6258A2E595EC04B , 0x9719905CFEADBC9BB829BD55AF7DA550 , 0xD6AE95A0BA431E3B60FE0E1FCF91DC36 , 0x873A54616C6DFD26ACC4317986E9391C , 0x6F604EA82425E07559A9A9508832D11B , 0x0307B22880CA4A326FC41E4AA239332B , 0xD01C3C575628A56C13608039F3EF2293 , 0x5526824E01058E6C1ABE6A9E6F2C55B3 , 0x03E4E7E1F2FB4F182E454FBCEE534DC5 , 0xB5349F931ED78E080232024893E4EBD3 , 0x548CA3DBA49FF3CD5E0BFBA8BBD2FFEB , 0xA0C604A5549ED9C0DDDD89E078A0CC8D , 0xA2EBB6F731D976852A3A16C704F4297B , 0x23B82AC61C8D8C5E35DEDE0F7074ED12 , 0xF30EF84165C1B742F65C45F491B27370 , 0xA7BBFBB4C46F421BB5AD02F0FC102297 , 0x0DC6CF1829F2FBBA4EAEE23E08FE745E , 0xADF5115E880814846815105C4668B310 , 0x4B43023A1FA994A7798945C5B0EF8332 , 0xB02C266563A91729F89F7A0A4FFEB27D , 0x0E408D90213053543B86D73CF733C1D7 , 0xAEBD3C252ED9834B33A7F1AEAA5F4D29 , 0x0F79C6D48831FFA9BE1DBEED8E3E8FA2 , 0x13027829FCA9C0AEB65820F84A21065E , 0xC30ADEF6114AA494A731A6A12525E564 , 0x80F7FE3AD4C18F68ADA6804F23FCCDD3 , 0x523953351912A27CAF1913256015CC65 , 0x323CED9B20919D240F16E7F5C69E2A6F , 0x9835C955EC3BEF24EF9BF03E2F1F8BA8 , 0xEFFD9EEFEC9B5AB0C37881902772AD80 , 0x25D0204058279AED465548CC88F8F1B1 , 0x38CE9570CD49FA614A5F6ED11F661C2A , 0x0FC01D19D879956189D41681F8394306 , 0xD709E033E8BF7E56EFA3883C9147411B );
Copy
6.46 ms (9.26%)
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/f30ef84165c1b742f65c45f491b27370 "
"/detail/a7bbfbb4c46f421bb5ad02f0fc102297 "
"/detail/0dc6cf1829f2fbba4eaee23e08fe745e "
"/detail/adf5115e880814846815105c4668b310 "
"/detail/4b43023a1fa994a7798945c5b0ef8332 "
"/detail/b02c266563a91729f89f7a0a4ffeb27d "
"/detail/0e408d90213053543b86d73cf733c1d7 "
"/detail/aebd3c252ed9834b33a7f1aeaa5f4d29 "
"/detail/0f79c6d48831ffa9be1dbeed8e3e8fa2 "
"/detail/13027829fca9c0aeb65820f84a21065e "
"/detail/c30adef6114aa494a731a6a12525e564 "
"/detail/80f7fe3ad4c18f68ada6804f23fccdd3 "
"/detail/523953351912a27caf1913256015cc65 "
"/detail/323ced9b20919d240f16e7f5c69e2a6f "
"/detail/9835c955ec3bef24ef9bf03e2f1f8ba8 "
"/detail/effd9eefec9b5ab0c37881902772ad80 "
"/detail/25d0204058279aed465548cc88f8f1b1 "
"/detail/38ce9570cd49fa614a5f6ed11f661c2a "
"/detail/0fc01d19d879956189d41681f8394306 "
"/detail/d709e033e8bf7e56efa3883c9147411b "
"/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/f30ef84165c1b742f65c45f491b27370' , '/detail/a7bbfbb4c46f421bb5ad02f0fc102297' , '/detail/0dc6cf1829f2fbba4eaee23e08fe745e' , '/detail/adf5115e880814846815105c4668b310' , '/detail/4b43023a1fa994a7798945c5b0ef8332' , '/detail/b02c266563a91729f89f7a0a4ffeb27d' , '/detail/0e408d90213053543b86d73cf733c1d7' , '/detail/aebd3c252ed9834b33a7f1aeaa5f4d29' , '/detail/0f79c6d48831ffa9be1dbeed8e3e8fa2' , '/detail/13027829fca9c0aeb65820f84a21065e' , '/detail/c30adef6114aa494a731a6a12525e564' , '/detail/80f7fe3ad4c18f68ada6804f23fccdd3' , '/detail/523953351912a27caf1913256015cc65' , '/detail/323ced9b20919d240f16e7f5c69e2a6f' , '/detail/9835c955ec3bef24ef9bf03e2f1f8ba8' , '/detail/effd9eefec9b5ab0c37881902772ad80' , '/detail/25d0204058279aed465548cc88f8f1b1' , '/detail/38ce9570cd49fa614a5f6ed11f661c2a' , '/detail/0fc01d19d879956189d41681f8394306' , '/detail/d709e033e8bf7e56efa3883c9147411b' , '/navigation/01968c8c36bf7d64a6458dea553bd083' , '/navigation/01968c8c66857cbdaa3fe53f64460992' , '/navigation/01968c8c819b7a3f80b7123704ac53e6' , '/navigation/01968c8ca8b57752817b01710b71694a' , '/navigation/01968c8e2d3a74a38a6c10f9f8460cea' , '/navigation/01968c8e463172098d9fdfbd02e7079a' , '/navigation/01968c8e5ce473fd981f91192b9ea060' , '/navigation/01968c8e70bd7f69b2d493c206e115cb' , '/navigation/01968c8eb0427cb382bf2677391a27af' , '/navigation/01968c8f733271dda4a6b5b5769d6a3d' , '/navigation/01968c8fcbcb7e17b2c838cd17eec670' , '/navigation/01968c904e6a7dc795fb655c6bba1a6c' , '/navigation/01968c910b567b13bd06bf0bb60f3a0d' , '/navigation/01968c91ed89784c83a9842c8cea2016' , '/navigation/01968c9316807749a8a0e77442aec819' )) AND (seo_url . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (seo_url . sales_channel_id = 0x01914A3133A37822896D0C70B2FD3B67 OR seo_url . sales_channel_id IS NULL ) AND (seo_url . is_deleted = 0 );
Copy
4.30 ms (6.17%)
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"ó\x0E øAeÁ·Bö\Eô‘²sp "
b"§»û´ÄoB\e µ\x02 ðü\x10 "— "
b"\r ÆÏ\x18 )òûºN®â>\x08 þt^ "
b"õ\x11 ^ˆ\x08\x14 „h\x15\x10 \Fh³\x10 "
b"KC\x02 :\x1F ©”§y‰EŰïƒ2 "
b"""
°,&ec©\x17 )øŸz\n
Oþ²}
"""
b"\x0E @ìÉ!0ST;åÎ<¸3┴Î "
b"®½<%.ÙƒK3§ñ®ª_M) "
b"\x0F yãÈê1 ®¥\x1D ¥ÝÄ>Åó "
b"\x13\x02 x)ü©À®¶X øJ!\x06 ^ "
b"""
Ã\n
Þö\x11 J¤”§1¦¡%%åd
"""
b"Ǹ■:È┴Åh¡ªÇO#³═Ë "
b"R9S5\x19\x12 ¢|¯\x19\x13 %`\x15 Ìe "
b"2<Ýø æØ$\x0F\x16 þ§ã×*o "
b"˜5ÉUì;ï$ï›ð>/\x1F ‹¨ "
b"´²×´ýøZ░├xüÉ'r¡Ç "
b"%Ð @X'šíFUḦøñ± "
b"8ΕpÍIúaJ_nÑ\x1F f\x1C * "
b"\x0F └\x1D\x19 ÏyòaëÈ\x16 ü°9C\x06 "
b"×\t à3è¿~V<‘GA\e "
]
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 (0xF30EF84165C1B742F65C45F491B27370 , 0xA7BBFBB4C46F421BB5AD02F0FC102297 , 0x0DC6CF1829F2FBBA4EAEE23E08FE745E , 0xADF5115E880814846815105C4668B310 , 0x4B43023A1FA994A7798945C5B0EF8332 , 0xB02C266563A91729F89F7A0A4FFEB27D , 0x0E408D90213053543B86D73CF733C1D7 , 0xAEBD3C252ED9834B33A7F1AEAA5F4D29 , 0x0F79C6D48831FFA9BE1DBEED8E3E8FA2 , 0x13027829FCA9C0AEB65820F84A21065E , 0xC30ADEF6114AA494A731A6A12525E564 , 0x80F7FE3AD4C18F68ADA6804F23FCCDD3 , 0x523953351912A27CAF1913256015CC65 , 0x323CED9B20919D240F16E7F5C69E2A6F , 0x9835C955EC3BEF24EF9BF03E2F1F8BA8 , 0xEFFD9EEFEC9B5AB0C37881902772AD80 , 0x25D0204058279AED465548CC88F8F1B1 , 0x38CE9570CD49FA614A5F6ED11F661C2A , 0x0FC01D19D879956189D41681F8394306 , 0xD709E033E8BF7E56EFA3883C9147411B ));
Copy
2.76 ms (3.95%)
4
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )) AND (sales_channel_id = ? )
Parameters :
[
b"ó\x0E øAeÁ·Bö\Eô‘²sp "
b"§»û´ÄoB\e µ\x02 ðü\x10 "— "
b"\r ÆÏ\x18 )òûºN®â>\x08 þt^ "
b"õ\x11 ^ˆ\x08\x14 „h\x15\x10 \Fh³\x10 "
b"KC\x02 :\x1F ©”§y‰EŰïƒ2 "
b"""
°,&ec©\x17 )øŸz\n
Oþ²}
"""
b"\x0E @ìÉ!0ST;åÎ<¸3┴Î "
b"®½<%.ÙƒK3§ñ®ª_M) "
b"\x0F yãÈê1 ®¥\x1D ¥ÝÄ>Åó "
b"\x13\x02 x)ü©À®¶X øJ!\x06 ^ "
b"""
Ã\n
Þö\x11 J¤”§1¦¡%%åd
"""
b"Ǹ■:È┴Åh¡ªÇO#³═Ë "
b"R9S5\x19\x12 ¢|¯\x19\x13 %`\x15 Ìe "
b"2<Ýø æØ$\x0F\x16 þ§ã×*o "
b"˜5ÉUì;ï$ï›ð>/\x1F ‹¨ "
b"´²×´ýøZ░├xüÉ'r¡Ç "
b"%Ð @X'šíFUḦøñ± "
b"8ΕpÍIúaJ_nÑ\x1F f\x1C * "
b"\x0F └\x1D\x19 ÏyòaëÈ\x16 ü°9C\x06 "
b"×\t à3è¿~V<‘GA\e "
b"\x01 ɪJ£&pò▓Ãè ÌôÜÓ "
]
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (0xF30EF84165C1B742F65C45F491B27370 , 0xA7BBFBB4C46F421BB5AD02F0FC102297 , 0x0DC6CF1829F2FBBA4EAEE23E08FE745E , 0xADF5115E880814846815105C4668B310 , 0x4B43023A1FA994A7798945C5B0EF8332 , 0xB02C266563A91729F89F7A0A4FFEB27D , 0x0E408D90213053543B86D73CF733C1D7 , 0xAEBD3C252ED9834B33A7F1AEAA5F4D29 , 0x0F79C6D48831FFA9BE1DBEED8E3E8FA2 , 0x13027829FCA9C0AEB65820F84A21065E , 0xC30ADEF6114AA494A731A6A12525E564 , 0x80F7FE3AD4C18F68ADA6804F23FCCDD3 , 0x523953351912A27CAF1913256015CC65 , 0x323CED9B20919D240F16E7F5C69E2A6F , 0x9835C955EC3BEF24EF9BF03E2F1F8BA8 , 0xEFFD9EEFEC9B5AB0C37881902772AD80 , 0x25D0204058279AED465548CC88F8F1B1 , 0x38CE9570CD49FA614A5F6ED11F661C2A , 0x0FC01D19D879956189D41681F8394306 , 0xD709E033E8BF7E56EFA3883C9147411B )) AND (sales_channel_id = 0x0190A64A9C267095B2C78AFFDE939AE0 );
Copy
1.22 ms (1.74%)
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/Schmitt,%20Thomas "
"/author/Schmitt,%20Thomas "
"https://hauptbuchhandlung.staging.eurosoft.network/author/Schmitt,%20Thomas "
"https://hauptbuchhandlung.staging.eurosoft.network//author/Schmitt,%20Thomas "
"/author/Schmitt,%20Thomas "
"//author/Schmitt,%20Thomas "
"author/Schmitt,%20Thomas "
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/Schmitt,%20Thomas' , '/author/Schmitt,%20Thomas' , 'https://hauptbuchhandlung.staging.eurosoft.network/author/Schmitt,%20Thomas' , 'https://hauptbuchhandlung.staging.eurosoft.network//author/Schmitt,%20Thomas' , '/author/Schmitt,%20Thomas' , '//author/Schmitt,%20Thomas' , 'author/Schmitt,%20Thomas' ) 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.10 ms (1.57%)
2
SELECT `delivery_time` . `id` as `delivery_time.id` , `delivery_time` . `min` as `delivery_time.min` , `delivery_time` . `max` as `delivery_time.max` , `delivery_time` . `unit` as `delivery_time.unit` , `delivery_time` . `created_at` as `delivery_time.createdAt` , `delivery_time` . `updated_at` as `delivery_time.updatedAt` , `delivery_time.translation.name` , `delivery_time.translation.name` as `delivery_time.name` , `delivery_time.translation.customFields` , `delivery_time.translation.customFields` as `delivery_time.customFields` FROM `delivery_time` LEFT JOIN (SELECT `delivery_time.translation` . `delivery_time_id` , `delivery_time.translation` . `name` as `delivery_time.translation.name` , `delivery_time.translation` . `custom_fields` as `delivery_time.translation.customFields` FROM `delivery_time_translation` `delivery_time.translation` WHERE `delivery_time.translation` . `language_id` = ? ) `delivery_time.delivery_time_translation` ON `delivery_time.delivery_time_translation` . `delivery_time_id` = `delivery_time` . `id` WHERE `delivery_time` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 ÉÑð║Ñqhô?6:■Ã,\x02 "
]
SELECT `delivery_time` . `id` as `delivery_time.id` , `delivery_time` . `min` as `delivery_time.min` , `delivery_time` . `max` as `delivery_time.max` , `delivery_time` . `unit` as `delivery_time.unit` , `delivery_time` . `created_at` as `delivery_time.createdAt` , `delivery_time` . `updated_at` as `delivery_time.updatedAt` , `delivery_time.translation.name` , `delivery_time.translation.name` as `delivery_time.name` , `delivery_time.translation.customFields` , `delivery_time.translation.customFields` as `delivery_time.customFields` FROM `delivery_time` LEFT JOIN (SELECT `delivery_time.translation` . `delivery_time_id` , `delivery_time.translation` . `name` as `delivery_time.translation.name` , `delivery_time.translation` . `custom_fields` as `delivery_time.translation.customFields` FROM `delivery_time_translation` `delivery_time.translation` WHERE `delivery_time.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `delivery_time.delivery_time_translation` ON `delivery_time.delivery_time_translation` . `delivery_time_id` = `delivery_time` . `id` WHERE `delivery_time` . `id` IN (0x0190A5D0BAA57168933F363AFEC72C02 );
Copy
1.02 ms (1.47%)
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
1.02 ms (1.46%)
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
1.00 ms (1.44%)
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.98 ms (1.41%)
1
SELECT `rule` . `id` as `rule.id` , `rule` . `name` as `rule.name` , `rule` . `priority` as `rule.priority` , `rule` . `description` as `rule.description` , `rule` . `payload` as `rule.payload` , `rule` . `invalid` as `rule.invalid` , `rule` . `areas` as `rule.areas` , `rule` . `custom_fields` as `rule.customFields` , `rule` . `module_types` as `rule.moduleTypes` , `rule` . `created_at` as `rule.createdAt` , `rule` . `updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"\x01 ˜8\x07 ³.su·M\x1F àë\x04 2‰ "
b"\x01 æj \x7F ÝqÈì\x11\x1D ±Mêw├ "
b"\x01 æk\x06 Óìr\x16 çB┴¹â9i "
b"\x01 ‘k\x07 õ>xý©g\x0F ó~\e ÿ« "
b"""
\x01 —Àï¿ýp\x0E ´ë%¬óf\n
õ
"""
b"\x01 ˜7ú\x1C cr²¦¸foB$\x16 é "
b"\x01 ÉÑð║zs:ïUo┬É¿³G "
b"\x01 ÉÑð║Ãsl┤Ãõµ:\x7F j7 "
b"\x01 ÉÑð°ßpQàÀ─¤C¬\x1E\t "
b"\x01 ‘™IY\x7F |ù•/ˆÓÉ’!‚ "
b"\x01 ÉÑð╗dsöå6àLhKƒ┘ "
]
SELECT `rule` . `id` as `rule.id` , `rule` . `name` as `rule.name` , `rule` . `priority` as `rule.priority` , `rule` . `description` as `rule.description` , `rule` . `payload` as `rule.payload` , `rule` . `invalid` as `rule.invalid` , `rule` . `areas` as `rule.areas` , `rule` . `custom_fields` as `rule.customFields` , `rule` . `module_types` as `rule.moduleTypes` , `rule` . `created_at` as `rule.createdAt` , `rule` . `updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule` . `id` IN (0x01983807B32E7375B74D1FE0EB043289 , 0x01916AFF7FED71D48D111DF14D8877C3 , 0x01916B06E08D72168742C1B6FB833969 , 0x01916B07F53E78FDA9670FF37E1BFFAB , 0x0197C0EFBFFD700EB4EB25ACF3660AF5 , 0x019837FA1C6372B2A6B8666F422416E9 , 0x0190A5D0BA7A733A8B556FC290A8FC47 , 0x0190A5D0BAC7736CB4C7E4E63A7F6A37 , 0x0190A5D0F8E1705185B7C4CF43AA1E09 , 0x01919949597F7CF9952F88D3C9922182 , 0x0190A5D0BB6473948636854C684B9FD9 );
Copy
0.94 ms (1.35%)
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.94 ms (1.34%)
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.92 ms (1.32%)
1
SELECT `country` . `id` as `country.id` , `country` . `iso` as `country.iso` , `country` . `position` as `country.position` , `country` . `active` as `country.active` , `country` . `shipping_available` as `country.shippingAvailable` , `country` . `iso3` as `country.iso3` , `country` . `display_state_in_registration` as `country.displayStateInRegistration` , `country` . `force_state_in_registration` as `country.forceStateInRegistration` , `country` . `check_vat_id_pattern` as `country.checkVatIdPattern` , `country` . `vat_id_required` as `country.vatIdRequired` , `country` . `vat_id_pattern` as `country.vatIdPattern` , `country` . `customer_tax` as `country.customerTax` , `country` . `company_tax` as `country.companyTax` , `country` . `postal_code_required` as `country.postalCodeRequired` , `country` . `check_postal_code_pattern` as `country.checkPostalCodePattern` , `country` . `check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern` , `country` . `advanced_postal_code_pattern` as `country.advancedPostalCodePattern` , `country` . `default_postal_code_pattern` as `country.defaultPostalCodePattern` , `country` . `is_eu` as `country.isEu` , `country` . `created_at` as `country.createdAt` , `country` . `updated_at` as `country.updatedAt` , `country.translation.name` , `country.translation.name` as `country.name` , `country.translation.addressFormat` , `country.translation.addressFormat` as `country.addressFormat` , `country.translation.customFields` , `country.translation.customFields` as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation` . `country_id` , `country.translation` . `name` as `country.translation.name` , `country.translation` . `custom_fields` as `country.translation.customFields` , `country.translation` . `address_format` as `country.translation.addressFormat` FROM `country_translation` `country.translation` WHERE `country.translation` . `language_id` = ? ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` WHERE `country` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 ÉÑð╣ms\x03 ┐5=Ë\x03 Õ╣' "
]
SELECT `country` . `id` as `country.id` , `country` . `iso` as `country.iso` , `country` . `position` as `country.position` , `country` . `active` as `country.active` , `country` . `shipping_available` as `country.shippingAvailable` , `country` . `iso3` as `country.iso3` , `country` . `display_state_in_registration` as `country.displayStateInRegistration` , `country` . `force_state_in_registration` as `country.forceStateInRegistration` , `country` . `check_vat_id_pattern` as `country.checkVatIdPattern` , `country` . `vat_id_required` as `country.vatIdRequired` , `country` . `vat_id_pattern` as `country.vatIdPattern` , `country` . `customer_tax` as `country.customerTax` , `country` . `company_tax` as `country.companyTax` , `country` . `postal_code_required` as `country.postalCodeRequired` , `country` . `check_postal_code_pattern` as `country.checkPostalCodePattern` , `country` . `check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern` , `country` . `advanced_postal_code_pattern` as `country.advancedPostalCodePattern` , `country` . `default_postal_code_pattern` as `country.defaultPostalCodePattern` , `country` . `is_eu` as `country.isEu` , `country` . `created_at` as `country.createdAt` , `country` . `updated_at` as `country.updatedAt` , `country.translation.name` , `country.translation.name` as `country.name` , `country.translation.addressFormat` , `country.translation.addressFormat` as `country.addressFormat` , `country.translation.customFields` , `country.translation.customFields` as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation` . `country_id` , `country.translation` . `name` as `country.translation.name` , `country.translation` . `custom_fields` as `country.translation.customFields` , `country.translation` . `address_format` as `country.translation.addressFormat` FROM `country_translation` `country.translation` WHERE `country.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` WHERE `country` . `id` IN (0x0190A5D0B96D7303BF353DD303E5B927 );
Copy
0.92 ms (1.32%)
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.92 ms (1.31%)
1
SELECT `property_group` . `id` as `property_group.id` , `property_group` . `display_type` as `property_group.displayType` , `property_group` . `sorting_type` as `property_group.sortingType` , `property_group` . `filterable` as `property_group.filterable` , `property_group` . `visible_on_product_detail_page` as `property_group.visibleOnProductDetailPage` , `property_group` . `created_at` as `property_group.createdAt` , `property_group` . `updated_at` as `property_group.updatedAt` , `property_group.translation.name` , `property_group.translation.name` as `property_group.name` , `property_group.translation.description` , `property_group.translation.description` as `property_group.description` , `property_group.translation.position` , `property_group.translation.position` as `property_group.position` , `property_group.translation.customFields` , `property_group.translation.customFields` as `property_group.customFields` FROM `property_group` LEFT JOIN (SELECT `property_group.translation` . `property_group_id` , `property_group.translation` . `name` as `property_group.translation.name` , `property_group.translation` . `description` as `property_group.translation.description` , `property_group.translation` . `position` as `property_group.translation.position` , `property_group.translation` . `custom_fields` as `property_group.translation.customFields` FROM `property_group_translation` `property_group.translation` WHERE `property_group.translation` . `language_id` = ? ) `property_group.property_group_translation` ON `property_group.property_group_translation` . `property_group_id` = `property_group` . `id`
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `property_group` . `id` as `property_group.id` , `property_group` . `display_type` as `property_group.displayType` , `property_group` . `sorting_type` as `property_group.sortingType` , `property_group` . `filterable` as `property_group.filterable` , `property_group` . `visible_on_product_detail_page` as `property_group.visibleOnProductDetailPage` , `property_group` . `created_at` as `property_group.createdAt` , `property_group` . `updated_at` as `property_group.updatedAt` , `property_group.translation.name` , `property_group.translation.name` as `property_group.name` , `property_group.translation.description` , `property_group.translation.description` as `property_group.description` , `property_group.translation.position` , `property_group.translation.position` as `property_group.position` , `property_group.translation.customFields` , `property_group.translation.customFields` as `property_group.customFields` FROM `property_group` LEFT JOIN (SELECT `property_group.translation` . `property_group_id` , `property_group.translation` . `name` as `property_group.translation.name` , `property_group.translation` . `description` as `property_group.translation.description` , `property_group.translation` . `position` as `property_group.translation.position` , `property_group.translation` . `custom_fields` as `property_group.translation.customFields` FROM `property_group_translation` `property_group.translation` WHERE `property_group.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `property_group.property_group_translation` ON `property_group.property_group_translation` . `property_group_id` = `property_group` . `id` ;
Copy
0.90 ms (1.29%)
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:21+00:00' ) OR (`show_until` > `updated_at` AND `show_until` < '2026-02-04T13:29:21+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:21+00:00' ) OR (`show_until` > `updated_at` AND `show_until` < '2026-02-04T13:29:21+00:00' )) AND `active` = '1' ; ;
Copy
0.74 ms (1.06%)
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/Schmitt,%20Thomas "
"author/Schmitt,%20Thomas/ "
]
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/Schmitt,%20Thomas' OR seo_path_info = 'author/Schmitt,%20Thomas/' ));
Copy
0.73 ms (1.05%)
1
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = ?
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = 'de-DE' ;
Copy
0.73 ms (1.04%)
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.73 ms (1.04%)
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.72 ms (1.03%)
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.71 ms (1.02%)
4
"START TRANSACTION"
"START TRANSACTION" ;
Copy
0.60 ms (0.87%)
1
SELECT `currency` . `id` as `currency.id` , `currency` . `factor` as `currency.factor` , `currency` . `symbol` as `currency.symbol` , `currency` . `iso_code` as `currency.isoCode` , `currency` . `position` as `currency.position` , `currency` . `tax_free_from` as `currency.taxFreeFrom` , `currency` . `item_rounding` as `currency.itemRounding` , `currency` . `total_rounding` as `currency.totalRounding` , `currency` . `created_at` as `currency.createdAt` , `currency` . `updated_at` as `currency.updatedAt` , `currency.translation.shortName` , `currency.translation.shortName` as `currency.shortName` , `currency.translation.name` , `currency.translation.name` as `currency.name` , `currency.translation.customFields` , `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation` . `currency_id` , `currency.translation` . `short_name` as `currency.translation.shortName` , `currency.translation` . `name` as `currency.translation.name` , `currency.translation` . `custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation` . `language_id` = ? ) `currency.currency_translation` ON `currency.currency_translation` . `currency_id` = `currency` . `id` WHERE (`currency` . `iso_code` IN (? , ? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
"CHF "
"EUR "
]
SELECT `currency` . `id` as `currency.id` , `currency` . `factor` as `currency.factor` , `currency` . `symbol` as `currency.symbol` , `currency` . `iso_code` as `currency.isoCode` , `currency` . `position` as `currency.position` , `currency` . `tax_free_from` as `currency.taxFreeFrom` , `currency` . `item_rounding` as `currency.itemRounding` , `currency` . `total_rounding` as `currency.totalRounding` , `currency` . `created_at` as `currency.createdAt` , `currency` . `updated_at` as `currency.updatedAt` , `currency.translation.shortName` , `currency.translation.shortName` as `currency.shortName` , `currency.translation.name` , `currency.translation.name` as `currency.name` , `currency.translation.customFields` , `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation` . `currency_id` , `currency.translation` . `short_name` as `currency.translation.shortName` , `currency.translation` . `name` as `currency.translation.name` , `currency.translation` . `custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `currency.currency_translation` ON `currency.currency_translation` . `currency_id` = `currency` . `id` WHERE (`currency` . `iso_code` IN ('CHF' , 'EUR' ));
Copy
0.60 ms (0.86%)
4
"COMMIT"
0.58 ms (0.83%)
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.56 ms (0.80%)
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.54 ms (0.77%)
1
SELECT path FROM category WHERE id = ?
Parameters :
[
b"\x01 æÄC\¼t«ÉÍ_£Ûd╬y "
]
SELECT path FROM category WHERE id = 0x01918E435CAC74AE90D65F9CEA64CE79 ;
Copy
0.53 ms (0.76%)
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.53 ms (0.76%)
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.50 ms (0.72%)
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.49 ms (0.70%)
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.69%)
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.45 ms (0.65%)
2
SELECT LOWER (HEX (parent_id )) FROM language WHERE id = ?
Parameters :
[
"0190a5d21558701cb17a1f89991d17e2 "
]
SELECT LOWER (HEX (parent_id )) FROM language WHERE id = '0190a5d21558701cb17a1f89991d17e2' ;
Copy
0.43 ms (0.62%)
1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1 ;
Copy
0.41 ms (0.58%)
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.41 ms (0.58%)
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.36 ms (0.51%)
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.36 ms (0.51%)
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/Schmitt,%20Thomas "
]
SELECT path_info pathInfo , seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (sales_channel_id = 0x01914A3133A37822896D0C70B2FD3B67 ) AND (path_info = '/author/Schmitt,%20Thomas' ) AND (is_canonical = 1 ) LIMIT 1 ;
Copy
0.35 ms (0.50%)
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.34 ms (0.49%)
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.29 ms (0.42%)
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.29 ms (0.41%)
1
SET @@group_concat_max_len = CAST (IF (@@group_concat_max_len > 320000 , @@group_concat_max_len , 320000 ) AS UNSIGNED ); SET sql_mode = (SELECT REPLACE (@@sql_mode , 'ONLY_FULL_GROUP_BY' , '' ))
SET @@group_concat_max_len = CAST (IF (@@group_concat_max_len > 320000 , @@group_concat_max_len , 320000 ) AS UNSIGNED ); SET sql_mode = (SELECT REPLACE (@@sql_mode , 'ONLY_FULL_GROUP_BY' , '' ));
Copy
0.28 ms (0.40%)
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.27 ms (0.39%)
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.24 ms (0.34%)
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