14.52 ms (20.79%)
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
6.57 ms (9.41%)
1
SELECT `meta_catalog_id` . `id` FROM `meta_catalog_id` WHERE `meta_catalog_id` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"…O\x1E 6íX›4½9ºM¶©± "
b"„A€2tçŸ\x08 §@¬®Ë\x18 ›s "
b"H¨2N܈tÿÚˆÈþ W³û "
b"ª¾´J\x7F G\x05\x10 ÊÚ 54Ýí[ "
b"QàTXqª]¢Yï<H\f Œ\x02 ¡ "
b"\x0E nÔr\x05 HÔÓd\x12 ,‚wt“µ "
b"ÝÄÀ?caÓŠFo?è¨\x0E 3v "
b"²\x0F wÎJ\x16 ¯1s\x08 ÌÜSé#÷ "
b"·é˜\v g\x18\x1C Ì?Ùä$÷µ° "
b"\x1C\x11 ¶\x1D\f\x02 ì&ö\x02 ´B%†ZM "
b"º´\x07 Q-»\x17 «¦™ë¤¿Kà’ "
b"-ªãxncLˆ@6¼àf}\x02 f "
b"\t å‚8\x13 :R\x18 ƒð„— "
b"c{~!WQ„ûò ׌:{Cñ "
b"\x0F AºceL'œ¿@£×¢\x04 . "
b"Du&‰oö´£È”E¿³ª¹ "
b"\x1C\x18 é›@Ðò ‹Nì\x15 ½‚äÉ "
b"Å‚/÷c‘{L$½\x04\x1E ëàk "
b"+ø¾\t 'ƒøNgyÄÒÕ¬| "
b"""
¼?Œ\n
çµÉ\x01 Ôû*|\x16\f Ý
"""
b"R)â\x06 îʉA0Êäöûé\x1A é "
b"TüUá\x05 ËcøEí£d¯Š5P "
b"ÈÙœ\x11 @¦ô^¡Üš5ñ¨‡‘ "
b"4í8\x02 ¸Ãÿ\x00 5dZŸ\x03 Oo\x14 "
b"d\x02 Îõ„K’Èßàéö3"ok "
b"ç\x17 \x1F Û}€—Å›[`8Äl5 "
b"Á߆+Þ\¶Ú&\x1C b|‘ª›\x13 "
b")׃‡»\x00 IäûÝ\x15\x0F @˜ô "
b"\x1F \t nû(•ñï"hœ\x08\x13 U "
b"©~}ÆzÚƒúáUqŒ§éÆH "
b"vvŽþG©¯\x14\x14 º\x16 î‹¢F "
b"èÅ\x7F\x03\x14 I»ž"V½í\x15 ÃoK "
b"ʺõqùAÀÇ5o\x02 ó\x16 5dï "
b"\x05\x08 Òªáx\v ô˜»Â "
b"–\x1E ™Û¢{lJXZ_\x0E ‰,ÖÑ "
b"û›\x11 ˜=´`©\e †ÃšçÎzì "
b"Ói4†\e {S*ì\t ›Úž\x1A < "
b"G\x04 Eg)\x07 ”4>Hô{+;É- "
b"Þ(Š—\x1D C\x10\t f%\r ¹®}\x15 ‰ "
b"[¶%þºÉ– ì²{¡”\x1C p¾ "
b"*¸µ½‘öè“…ö\x1E ö|/ "
b"¬ÖU\x1D z¾Nªí#ãÏ¢È×¥ "
b"6fL¥™i¡\x13 jl/Z¼(© "
b"_µâR=©$˜¾n\x05 E4´“\x17 "
b"‰,>ë2ë\x06 €w¾+½~Òì "
b"¯\x05 ‹ê“Ô©0—ÍRKÓuu "
b"ÒM \x10 >—â½ÙS«7\x14 ¨é\x04 "
b"\x15 ÀZå¼Lø¬6C™#4ˆÁŽ "
b"µä\v ®žÈ\x15 åòsN‰"p5÷ "
b"xñB´ï¤þ\x10 û\x02 ¾\x04 ÂÛjé "
b"\x13 kóFÒå¤\x14 \r \x18 Ñ”\Í\x07 ì "
b"]JDôÚ>¼@šâ,4oœf "
b"”{7´†\x04 Ê”Ni\f ‚Ê\x06 ` "
b"Ã\x0E #ô-¾·gSÝ\x15 J~ß)û "
b"׃öE\x13 åK<®0‹#A§^¯ "
b"Ø\x06 hEËPr‡U¾zÉ\x07 j\v ñ "
b"\x03\t ºWFØûÇ_K°kÝÿAþ "
b"?Š«v÷ÈÓ\f \x1C ‹§lÈŒë "
b"J~ƒ\x01 ãò\x15 Ñ‚TÛ2\x1E í)\n "
b"?Qömó9ð5\t\x1E\x15 ø ÿîE "
b"޽\f L…P}Œ,\x0E hë\x19 JÅ "
b"|L¬\x10 â@\x06 •{<\x7F CPmh "
b"¤_\r ·Ç\e Î(p\x05 œ` "
b"GÖÖÝ1Ö\x17 ´k”yòÅòn< "
b"\x0F ŠªwŠ\x10 %\x10 >|c\x04 Å\x1F ª¾ "
b"""
HÛZ\n
\x08 €\x14 ™Hx6öá<\x15 ›
"""
b"7sšZÆj˜i€TÙ€çÁû\x1A "
b"E¨f½ýE~r0Y/ý\t ª9\x1D "
b"‚#BªQn7ê\x01 Â )p\r ÊØ "
b"\x03 ª\r É"Ln~\v °;ä6\x1A Bk "
b"Î"výqâ÷VIg<\x15 hŸï‚ "
b"V·ŸdwÑ\x0F 9¦wê1\x1F vîµ "
b"""
®qÓ\n
Iê{Ýb©ï\x03 Ñw€Í
"""
b"""
F\n
Õeºs·¿/÷ÖÃf'Û\x16
"""
b"\x19 ô\½ÆÕ¾º\x06\x08 ¨¶Âký‰ "
b"Áveë\x1D ~Çl¾½ZEiY "
b"EÂ^•\x06 <£;PS»g?¹SK "
b"\x01 ÀøO;ýíßS1!M¬Å¼å "
b"""
n£«Vi—\n
¤\x02 ÈX`ú:
"""
b""úgÆÆËÆòkí=š\x06 ®§\e "
b"Žª\x01 »\x11 »ñ\x1C È\x1A BOØÆau "
b"ZÍá½om¥úâäXå\x16 +? "
b"ÍQ0\x07 †2“8ábP\x0E 2ä§ "
b"&ü*8\x1A Ý"ŠŠ“éÔ/ï\x14 Í "
b"9"'=H…<¨”ñTÐi7\x10 ƒ "
b"íå•ÏM<\x1C i\e èHHÅ\x1A 'è "
b"T<„¬*Â8,¿\x1F ³<Ùuûm "
b"q\x15 RT\x04\x1A\x05\x1F O»]ý\x1D #jŸ "
b"pO\x15 ?\x14 x.žÅÂ6§5N\x1C Ü "
b"hÀG\r ÿò« !c%\x1F åÚW\x13 "
b"ß僑ʟ¡·!ž@†\x13\x01 Üq "
b"`\x10 œù¤‰4«'³FX[ýh\t "
b"§Ésï/\f \Ù{ªýÎÜnš© "
b"\r :ø/E\x08 l2X\x00 òªi4ýŒ "
b"xß\v 17\x17 K¬\f î¯ëzëâÄ "
b"Ü›\x02 N-\x10 FŒKzyïn¥½x "
b"\t\x0F\e œåg#˜v59‹Ê{Æ "
b"öègÈćeë—ëF&¼xVÊ "
b"\x06 ²\x1F\x04 ÖF¿\x12 érë™þ.ôg "
b"±AÀÆÂ‚édO}%ª\x12 ºÅÇ "
b"’t#ÓN¢ñ’‚*<=¡\x14 |¦ "
b"%vkî\x17 á\x04 ÚCFe5.œê "
b"L#ºüvÀߟ =X¸ñ\f <† "
b"âò›N€œ^,,cB)&r‹Ò "
b"""
\n
Ž|¼‰4«ˆ¢nZ\x13 Ú´Ûí
"""
b"ÖÍœ¾¾ìïÝF÷«\x08 {\x03 ] "
b"MîTšlàø\x1A\x18\v †êŒ\x17 Ãü "
b"å´s†è}\x1F mÝÀbQr0ºÖ "
b"Ïn\x17 ô\e h¯7)²zU\x18 lœB "
b"#Ö¢\x13 ±·î~\x1D m\x15 4íÔÛ* "
b"þmF6Ô|s\r %èÑRŠÐ "
b"È)\x05 #\x1C «™¹Ë\x0E ›¬Ø»Š "
b"²õމ‚àó§LOPC^&˜L "
b"i.#;`÷\x1C W¸µÇ<\x1C Wáf "
b"O-†oÊ/“ðŽÒ>W'¸†æ "
b"\x7F ¾\x1D q\x06 ÿ\x07 H¾˜KN÷\x13 Œ\x17 "
b"<\x17\x19\x16 XO^\x19 ÄÀùc\x7F ™ø "
b"°\x05 y)–C£²8x+S\x07 "
b"\x05 ÂõS\x14 q"(›wgÛ£€ÜÍ "
b"—\x1A Ì_\x02 ~VÌn ø\x1F uÈÁ "
b"E]A4û\x1D £ì\x04 C\x19 :èDÇ "
b"†ò”$\x0E œžÈAG¿\x18 ®8\x00 "
b"\x06\x0F 5/>\x0F mìge\r \x1D º;•J "
b"xÓ![‹Óe\x1E 2¸\x00 ! "
b"pn^\x1A u[Dž=¢‰gyœ\x15 "
b"\x11 &Ùýz層y±í|Ì9^¯ "
b"/q†¥å^É\x1A BÛ\x0E .4’±Û "
b"\x0E CÍLf)xÔŸ8V\x03 Mºµ\e "
b"DõáùŽæü×°‚úWj "
b"½üí\x06 Ö?™\x7F *âê¥ûÄ…\x07 "
b"×çjR\x08 ½ò\x7F Pg\x1F éY\x1E »¤ "
b"Á4‘7Z¤\x1F µšJê!Û ”n "
b"±‘ÉÅФdA~£VNÒÚ\ "
b"¥²^3åæ\x07 G×>éò€\x1C ãN "
b")\x11 hbE{Àf´s£ÖëMNû "
b"\x00 *Iå·9\x1A yV\x0E ¹†G\x18 Ž÷ "
b"\x12\x06 ˆþˇGæ\f\x0F ÑêpÞ "
b"•Šöâ]b§·¥a9hV¸8Ã "
b"™87–\x01 ]uBäk:0Õ "
b"\x19 †aC\x15 ‰$TªŽ“¹B}•› "
b"""
Šµë‡¿ñb% \x1D ß^\n
$r
"""
b"""
R½0Ü\x18 áÛ\n
zî©\x1D Óóg
"""
b"l"è\x13 µ²#çü_v>aœ:B "
b"$j²íª\x02\x1A Ït\f xƒ-ž "
b"åB\x10 5\x19 JN˜ÑDóeñà "
b"<\x1F\e –û|eóÃ6ÚjM¾óÏ "
b"""
¹\x18 zã+ÃŒKîá0\n
wѡX
"""
b"\x03 ‰g\x08 Ô\x07\x0E\t ÎÝûºâ\x7F ʼ "
b"Dç\x16\x15 ë=]ÒÝBÝ\x18 3¡+ë "
b"ãd\x17 4ÿì\\x05\x06 ýI\x12 æd¤D "
b"=\v \r Ù»Gu@(íW#H\x12 ø> "
b"(Â7ß\x7F ª(\x17\x01\x03 ½f\v AA\x14 "
b"ÙÖ`)‚@=\x00 /1‘„]`”³ "
b"Ä¢fÞü2†^và_\\x10\x08 "
b"\x03 z\x01 ¶"eÆ\x03 ~\x10 XL²=\x02 "
b"Ta\f NoÞ+\x05 sø6‡Çÿºy "
b"Ø\x19 Õ\n L-Žòõ\x05 š»\x00 wŽÔ "
b"\x00 Û"ÓCÖÓøèø¾\x08 {£,Ê "
b""þ‘nÒK|vÅn\x06 ú\x1A fN\x1F "
b"êñ,¾l\x7F ßkÀr×Õï\x10 "
b"\x05 'Ñç\x19 <€–TÖ®WׇIŒ "
b"\x08 [K@}Lë\x1A SŽä‹FO}R "
b"ã¸TP|ÚmM\x16 ™jd\x19 øÃ{ "
b"""
\n
g¤i\x02 P-ÏKüüf¸Î‰
"""
b"'\x0E ³Â‡ßZ”\x00\x0E ßÀÀi¨¶ "
b"\e àbñÑ+¨¬\x04 ¦šÏÑÀü "
b"\x01 ¿ 4dߎêü0\r âunK "
b"ò¸Ø%6\x14 Î[\x15 F¥ùO“Á "
b"uã,™}éà\x17 .õ¬eh}@C "
b"\á’÷\x1F\x12 È„\x05 1,u€¶œv "
b"ï4ÍzÓÀ\f v>º{ý\x1C Cˆ) "
b"Ƽ\x7F ßk\x15 yµ·\x0F P¢ƒ§=J "
b"†º\x1A ‘ñ)§ôž6ë\e ÁµJ¡ "
b"µ³j¢õOÖy4¯=/ÊD5[ "
b"“Z”15Sg\x7F €¿ð—ßÒDZ "
b"""
Sk·é©=p\n
ˆzH^CVpÊ
"""
b"™dö€”):u(\x18 Ò\t ·ÂPN "
b"CP\e fµ\t BLn{"rÓÕ "
b"80¸¡ê}ý„âsEú·r"À "
b"7Øz%¸‹µÎSkl¢<\x0E 6\x1A "
b"\x0F\x08 êëM¥Øµˆ\v Ã\x18 Øk "
b"2N¹YµíŽ£Sn\x06 Ûâ¯g "
b"\x0E\x19 dÓâP¤¦=ï·Ï\x1F H\x18 í "
b"JÐ\x05 D‰îŸ‡ù›¡›FÍó\x0F "
b"3å¸JÐJÙ¿žm‰o©> "
b"tÞ3\x0F xF#'›P„}³ª¬v "
b"$ =SI‘ö½Rðî‘D軟 "
b"úVh<œœ\x18 CØ«3íÆÐ\x03 ª "
b"ù¾ÞÐ\x07 w+\x1D f“™!$ó¦ "
b"ŽÊ¿nÒ\x12 |;¯ƒè‡“üŸ^ "
b"ètCÍÌX'ÿÔÂ\x18 GN-Ÿ "
b"o•Ÿt·\6¾g\x1D 8PÃÐ~ "
b"žÇºÏ±\x19 U3£Šx}–͵~ "
b"L\x7F kÃ<’\x1A ¿²\x19 ®Ó$òcë "
b"ÛÝÝ‹\t ò"Œðy7`Hëté "
b"\x13\t Wpð¹Fj–ø\x10 Ær;’z "
b"g÷)L.0‘›Q#à„š¦2´ "
b"\x00 øœ„[x\x12 æìÐîç= "
b"2·Ä[Õžw/n\x11 !¼UM‹` "
b"Ç7xÄ.\v *\x0F\t µE$[_»ô "
b"ß—¤|M‰\a¯\x14 Ã0˜~a« "
b"TY\x07 3ì¶\x19 .וJŽbg\x1A Ê "
b"ïlJº\f ]ê\x11 5æp03m\x19 å "
b"ì¾›òí7†?ck\x1A †›zU\x12 "
b"¢a\v ü\x05 caÞ³–#(¸÷·3 "
b"M\x14 ôú~kÇ`@\x11 @€\x19 µq\x10 "
b"\t Ü?\x00 b·ð…¾„9P]\x14 ¤ "
b"Š#Ž\âÕq‚ÜÐ\x7F «?f}• "
b"Å5\x7F Á=¡Ñì0.Äj”\x03 þs "
b"3Ž\\x14 [aT\x16 %¦Ö¢7îä$ "
b"z\x1A\x15 S×ÁS\e RÍã\x1F ®¢?š "
b"·™s \x08 ›ÖyµÓ\x11 ]¦\x02 ˆ¼ "
b"b‚é>ÃëïÿÂÈÝnFÆ&é "
b"V\r åþ ’zŽ\x0F é\r ¯í³x\x06 "
b"\f w6Ò\x0E c\e j‘â‹òß\x00 ° "
b":Ö!t³õ†ŒF\D(•ŠÖ( "
b"\ÎZþ\x1C ¿ãëÕ\r Í¡\x00 âdJ "
b"‡ÍŽÙkùö\t\x0E\e ÑÏnÁ\x10 X "
b"|}‚ƒ6œí\t\x00 †ßÍ‚Š¸9 "
b"ðÎÙ(\t ö±D|\x12 [dà-× "
b"ì\e\x1A %Šv-â>L3\x17 o2 "
b"²©ñ<\x11 TlÿKÆÀʈÚ} "
b"6\x03 E¥Ïþu¦¦‘ê)\x7F ŒeÁ "
b"øÜЏ*êî`\x15 ~Ù¿³ïÕ "
b"Öÿ䎜-§D\x0E i´ð\v\x10 Æ "
b"Ms«MûÀ§;Ô%µ#Wrñs "
b"005ÿMf™*±‡ÔÓ”÷¡N "
b"1\x13 ŠÀ]+:O®oµr—áú² "
b"TŒ£Û¤ŸóÍ^\v û¨»Òÿë "
b" Æ\x04 ¥TžÙÀÝ݉àx ÌŽ "
b"”qFt†¼\x0F Ù‰¼êŽ\e &— "
b"ÚM\x17 „ý\x07 5~\x0F Í\x1F \‰f`È "
b"*\e \x1C ½DûÑV#~ÅT‹ë] "
b"DŸ0\x18 )\x07 \r ÖC\x07 .ýŽÅ¨¡ "
b"±Ã\x18 _Çpá‚qUçÝ\x1E Œ\v ¥ "
b"úy}‡ú‡9+[‘šw\x03 = "
b"ëâöóºÊ\x1D ^Ù<~ø¾}® "
b"õЇU"æø™.ý |1Hµ "
b"»\x05 êfþ½'˲{NŒ«2`x "
b"ëôº~\v\x00 D\x7F T\x15 Më•@áÈ "
b"*]Âû:9”\x01 öìÒ {-n\t "
b"5\x0E g\x12\x01 $ßñ?M‚\x08 \r L\x0E Ž "
b"ç)b\x1C\x01 /s2\x18 ×ÜfÔ!Ý "
b"ròŒË?gñˆu\x1E\x1A ‚É㉠"
b"\x08 ªåD%Hb”\x1E ð¶R\x1F F’å "
b"Ë~Êú(ñ@@EµëźØà "
b"\t\x18 ™ÖÆÄL\x16\x7F ÛJɶ"õ "
b"L´ÿc0—í\x11 _9ö6¾ñ:\x01 "
b"\x08 ɰ¿Ž\x1D ðLŽ>\x08 \Düp¥ "
b"mÊîÒ`ä!óúì\v §>ŽÜ> "
b"Z\x0E ÈY>Õ\x06 t3ÝÝúÀüµª "
b"""
w»³\x06 \n
P–2\x12 Vÿô\x03
"""
b"¬ºyÈm9çöôöÈÙ\% "
b"""
°Þ±BïX\x01 ‘ƒ~Õ\n
†>_
"""
b"P\x07 1¤(ôîL&!UDU\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 (0x854F1E36ED589B34BD39ADBA4DB6A9B1 , 0x8441803274E79F08A740ACAECB189B73 , 0x48A8324EDC8874FFDA88C8FEA057B3FB , 0xAABEB44A7F470510CADA203534DDED5B , 0x51E0545871AA5DA259EF3C480C8C02A1 , 0x0E6ED4720548D4D364122C82777493B5 , 0xDDC4C03F6361D38A466F3FE8A80E3376 , 0xB20F77CE4A16AF317308CCDC53E923F7 , 0xB781E9980B67181CCC3FD9E424F7B5B0 , 0x1C11B61D0C02EC26F602B44225865A4D , 0xBAB407512DBB17ABA699EBA4BF4BE092 , 0x2DAAE3786E634C884036BCE0667D0266 , 0x09E58238133A5218AD83F08497EE8A98 , 0x637B7E21575184FBF220D78C3A7B43F1 , 0x0F41BA63654C278F9CBF40A3D7A2042E , 0x447526896FF6B48FA3C89445BFB3AAB9 , 0x1C18E99B40D0F2A08B4EEC15BD82E4C9 , 0xC5822FF763917B904C24BD041EEBE06B , 0x2B9DF8BE092783F84E6779C4D2D5AC7C , 0x90BC3F8C0AE7B5C901D4FB2A7C160CDD , 0x5229E206EECA894130CAE4F6FBE91AE9 , 0x54FC55E105CB63F845EDA364AF8A3550 , 0xC8D99C1140A6F45EA1DC9A35F1A88791 , 0x34ED3802B8C3FF0035645A9F034F6F14 , 0x6402CEF5844B92C8DFE0E9F633226F6B , 0xE717AD1FDB7D8097C59B5B6038C46C35 , 0xC1DF862BDE5CB6DA261C627C91AA9B13 , 0x29D78387BB0049E4FBDD9D150F4098F4 , 0x1F9081096EFB2895F1EF22689C081355 , 0xA97E7DC67ADA83FAE155718CA7E9C648 , 0x76768DFE47A9AF141420BA16EE8BA246 , 0xE8C57F031449BB9E2256BDED15C36F4B , 0xCABAF571F941C0C7356F02F3163564EF , 0x0508D2AA9DE1788F0BF498BB8EC2AD90 , 0x961E99DBA27B6C4A585A5F0E892CD6D1 , 0xFB9B11983DB460A91B86C39AE7CE7AEC , 0xD36934861B7B532AEC09909BDA9E1A3C , 0x47044567290794343E48F47B2B3BC92D , 0xDE288A971D43100966250DB9AE7D1589 , 0x5BB625FEBAC99620ECB27BA1941C70BE , 0x2A9081B8B5BD91F6E89385F61EF67C2F , 0xACD6551D7ABE4EAAED23E3CFA2C8D7A5 , 0x36664CA59969A1AD136A6C2F5ABC28A9 , 0x5FB5E2523DA92498BE6E054534B49317 , 0x892C3EEB32EB068077BE2BBD7ED2EC20 , 0xAF9D058BEA93D4A93097CD524BD37575 , 0xD24DA0103E97E2BDD953AB3714A8E904 , 0x15C05AE5BC4CF8AC364399233488C18E , 0xB5E40BAE9EC815E5F2734E89227035F7 , 0x78F142B4EFA4FE10FB02BE04C2DB6AE9 , 0x136BF346D2E5A4140D18D1945CCD07EC , 0xAD5D4A44F4DA3EBC409AE22C346F9C66 , 0x947B37B48604CA944E690C82CAAD0660 , 0xC30E23F42DBEB76753DD154A7EDF29FB , 0xD783F64513E54B3CAE308B2341A75EAF , 0xD8066845CB50728755BE7AC9076A0BF1 , 0x0309BA5746D8FBC75F4BB06BDDFF41FE , 0x3F8AAB76F7C8D30C811C8BA76CC88CEB , 0x4A7E8301E3F215D18254DB321EED290A , 0x3F51F66DF339F035091E15F820FFEE45 , 0x8DBD0C4C8550817D8C2C0E68EB194AC5 , 0x817C4CAC10E24006957B3C7F43506D68 , 0xA45F0DB7C7EE8C871BCE28AD70059C60 , 0x47D6D6DD31D617B46B9479F2C5F26E3C , 0x0F8AAA778A1025103E7C6304C51FAABE , 0x48DB5A0A08801499487836F6E13C159B , 0x37739A5AC66A98698054D980E7C1FB1A , 0x45A866BDFD457E7230592FFD09AA391D , 0x822342AA516E37EA01C22029700DCAD8 , 0x03AA0DC9224C6E7E0BB03BE4361A426B , 0xCE2276FD71E2F75649673C15689FEF82 , 0x56B79F6477D10F39A677EA311F76EEB5 , 0xAE71D30A49EA7BDD62A9EF03D17780CD , 0x460AD565BA73B7BF2FF7D6C36627DB16 , 0x19F45CBDC6D5BEBA0608A8B6C26BFD89 , 0xC17665C3AB1D7EC7816CBEBD5A456959 , 0x45C25E95063CA33B5053BB673FB9534B , 0x01C0F84F3BFDEDDF5331214DACC5BCE5 , 0x6EA3AB5669970A20A402C8589060FA3A , 0x22FA67C6C6CBC6F26BED3D9A06AEA71B , 0x8DAA01BB11BBF11CC81A424FD8C66175 , 0x5ACDE190BD6F6DA5FAE2E458E5162B3F , 0xCD51300786329338E162500E32C3A4A7 , 0x26FC2A381ADD228A8A93E9D42FEF14CD , 0x3922273D48853CA894F154D069371083 , 0xEDE595CF4D3C1C691BE84848C51A27E8 , 0x543C84AC2AC2382CBF1FB33CD975FB6D , 0x71155254041A051F4FBB5DFD1D236A9F , 0x704F153F14782E9EC5C236A7354E1CDC , 0x68C0470DFFF2ABA02163251FE5DA5713 , 0xDFE58391CA9FA1B7219E40861301DC71 , 0x60109CF9A48934AB27B346585BFD6809 , 0xA7C973EF2F0C5CD97BAAFDCEDC6E9AA9 , 0x0D3AF82F45086C325800F2AA6934FD8C , 0x78DF0B3137174BAC0CEEAFEB7AEBE2C4 , 0xDC9B024E2D10468C4B7A79EF6EA5BD78 , 0x090F1B9C90E56723987635398BCA7BC6 , 0xF6E867C8C48765EB97EB4626BC7856CA , 0x06B21F04D646BF12E972EB99FE2EF467 , 0xB141C0C6C282E9644F7D25AA12BAC5C7 , 0x927423D34EA2F192822A3C3DA1147CA6 , 0x25766BEE1720E104DA434665352E9CEA , 0x4C23BAFC76C0DF9F203D58B8F10C3C86 , 0xE2F29B4E809C5E2C2C63422926728BD2 , 0x0A8E7CBC8934AB88A26E5A13DAB4DBED , 0xD6CD9CBEBEECEFDD46F7AB087B035D9D , 0x4DEE549A6CE0F81A180B86EA8C17C3FC , 0xE5B47386E87D1F6DDDC062517230BAD6 , 0xCF6E17F41B68AF3729B27A55186C9C42 , 0x23D6A213B1B7EE7E1D6D1534EDD4DB2A , 0xFE6D46369FD47C730D25E8D1528A90D0 , 0xC82905231CAB99B9CB0EA09BACD8BB8A , 0xB2F58E8982E0F3A74C4F50435E26984C , 0x692E233B60F71C57B8B5C73C1C57E166 , 0x4F2D866FCA2F93F08ED23E5727B886E6 , 0x7FBE1D7106FF0748BE984B4EF7138C17 , 0x3C171916584F5E19C4C0F9637F9099F8 , 0xB005EF93B579299643A3B238782B5307 , 0x05C2F553147122289B7767DBA380DCCD , 0x971ACC5F027E56CC6EA0F81F75C881C1 , 0x455D4134FB1DA3EC0443193AE844C720 , 0x86F294240E9C9D9EC84147BF18AE3800 , 0x060F352F3E0F6DEC67650D1DBA3B954A , 0x78D3215B8BD3651EEF918332B8900021 , 0x706E5E1A755B449E3DA2896779819C15 , 0x1126D9FD7AE5B1A479B1ED7CCC395EAF , 0x2F7186A5E55EC91A42DB0E2E3492B1DB , 0x0E43CD4C662978D49F3856034DBAB51B , 0x44F5AD8FE1F98DE6FCD7B082FA57816A , 0xBDFCED06D63F997F2AE2EAA5FBC48507 , 0xD7E76A5208BDF27F50671FE9591EBBA4 , 0xC13491375AA41FB59A4AEA21DB20946E , 0xB191ADC9C5D0A464417EA3564ED2DA5C , 0xA5B25E33E5E60747D73EE9F2801CE34E , 0x29116862457BC066B473A3D6EB4D4EFB , 0x002A49E5B7391A79560EB98647188EF7 , 0x1206888FFECB8747E69D0C0FD1EA70DE , 0x958AF6E25D62A7B7A561396856B838C3 , 0x99383796015D7542E46B9D3A30C38E95 , 0x1986614315892454AA8D93B9427D959B , 0x8AB5EB8781BFF16225A01DDF5E0A2472 , 0xA052BD30DC18E1DB0A7AEEA91DD3F367 , 0x6C22E813B5B223E7FC5F763E619C3A42 , 0x8F246AB2EDAA021A20CF740C78832D9E , 0xE5421035194A4E98D144F39F9065F1C3 , 0x3C1F1B96FB7C65F3C336DA6A4DBEF3CF , 0xB9187AE32BC38C4BEEE1300A77D1A158 , 0x03896708D4070E09CEDDFBBAE27FCABC , 0x44E71615EB3D5DD2DD42DD1833A12BEB , 0xE3641734FFEC5C0506FD4912E664A444 , 0x3D0B0DD9BB47754028ED57234812F83E , 0x28C237DF7FAA28170103BD660B414114 , 0xD9D6602982403D002F3191845D6094B3 , 0xC4A266DEFC32865E76E05F5C10089F81 , 0x037A01B62265C6037E10584CB23D02AD , 0x54610C4E6FDE2B0573F83687C7FFBA79 , 0xD819D50A4C2D8DF2F5059ABB00778DD4 , 0x00DB22D343D6D3F8E8F8BE087BA32CCA , 0x22FE916ED24B7C76C56E06FA1A664E1F , 0x81EAF12C8FBE6C7FDF6BC072D7D5EF10 , 0x0527D1E7193C809654D6AE57D787498C , 0x085B4B407D4CEB1A538EE48B464F7D52 , 0xE3B854507CDA6D4D16996A6419F8C37B , 0x0A67A46902502DCF4BFCFC669DB8CE89 , 0x270EB3C287DF5A94000EDFC0C069A8B6 , 0x811BE062F1D12BA8AC04A69ACFD1C0FC , 0x01BFA03464DF8DEAFC309D0DE2756E4B , 0x9DF2B8D8253614CE5B1546A5F94F93C1 , 0x75E32C997DE9E0172EF5AC65687D4043 , 0x5CE192F71F12C88405312C7580B69C76 , 0xEF34CD7AD3C00C763EBA7BFD1C438829 , 0xC6BC7FDF6B1579B5B70F50A283A73D4A , 0x86BA1A91F129A7F49E36EB1BC1B54AA1 , 0xB5B36AA2F54FD67934AF3D2FCA44355B , 0x935A94313553677F80BFF097DFD2C7B1 , 0x536BB7E9A93D700A887A485E435670CA , 0x9964F68094293A752818D209B7C2504E , 0x4390501B66B509424C8F6E7B2272D3D5 , 0x3830B8A1EA7DFD84E27345FAB77222C0 , 0x37D87A25B88BB5CE536B6CA23C0E361A , 0x0F08EAEB4DA5D8B5AD90880BC318D86B , 0x324EB959B5ED8DA390536E06DBE2AF67 , 0x0E1964D3E250A4A63DEFB7CF1F4818ED , 0x4AD0054489EE9F87F99BA19B46CDF30F , 0x33E590B84AD04AD9BF9E6D896F9DA93E , 0x74DE330F784623279B50847DB3AAAC76 , 0x24A03D534991F6BD52F0EE9144E8BB9F , 0xFA56683C9C9C1843D8AB33EDC6D003AA , 0xF9BEDED007772B1D669399812124F3A6 , 0x8ECABF6ED2127C3BAF83E88793FC9F5E , 0xE87443CDCC5827FFC394C218474E2D9F , 0x6F95C5B874B75C36BE671D3850C3D07E , 0x9EC7BACFB1195533A38A787D96CDB57E , 0x4C7F6BC33C921ABFB219AED324F263EB , 0xDBDDDD8B09F2228CF079376048EB74E9 , 0x13095770F0B9466A96F810C6723B927A , 0x67F7294C2E30919B5123E0849AA632B4 , 0x00F8909C845B7812E6ECD081EEE7AD3D , 0x32B7C45BD59E772F6E1121BC554D8B60 , 0xC73778C42E0B2A0F09B545245B5FBBF4 , 0xDF97A47C4D895C61AF14C330987E61AB , 0x54590733ECB6192ED7954A8E62671ACA , 0xEF6C4ABA0C5DEA1135E67030336D19E5 , 0xECBE9BF2ED37863F636B1A869B7A5512 , 0xA2610BFC056361DEB3962328B8F7B733 , 0x4D14F4FA7E6BC7604011408019B57110 , 0x0990DC3F0062B7F085BE8439505D14A4 , 0x8A238E5CE2D57182DCD07FAB3F667D95 , 0xC5357FC13DA1D1EC302EC46A9403FE73 , 0x338D5C145B61541625A6D6A237EEE424 , 0x7A1A1553D7C1531B52CDE31FAEA23F9A , 0xB79973A0089BD679B5D3115DA60288BC , 0x6282E93EC3EBEFFFC2C8DD6E46C626E9 , 0x560DE5FEA0927A8E0FE90DAFEDB37806 , 0x0C7736D20E631B6A91E28BF2DFAD00B0 , 0x3AD62174B3F5868C465C4428958AD628 , 0x5CCE5AFE1CBFE3EBD50DCDA100E2644A , 0x87CD8DD96BF9F6090E1BD1CF6EC11058 , 0x7C7D8283369CED090086DFCD828AB839 , 0xF0CED92809F6B1447C125B9064E02DD7 , 0x9FEC1B1A25908A762DE23E4C33176F32 , 0xB2A9F13C1154816CFF4BC6C0CA88DA7D , 0x360345A5CFFE75A6A691EA297F8C65C1 , 0xF8DC8AB82AEAC3AE60157ED9BFB3EFD5 , 0xD6FFE48D9C2DA790440E69B4F00B10C6 , 0x4D73AB4DFBC0A73BD425B5235772F173 , 0x303035FF4D66992AB187D4D394F7A14E , 0x31138AC05D2B3A4FAE6FB57297E1FAB2 , 0x548CA3DBA49FF3CD5E0BFBA8BBD2FFEB , 0xA0C604A5549ED9C0DDDD89E078A0CC8D , 0x9471467486BC0FD989BCEA8D1B26C297 , 0xDA4D1784FD07357E0FCD1F5C896660C8 , 0x2A1B8F1CBD44FBD156237EC5548BEB5D , 0x449F301829070DD643072EFD8EC5A8A1 , 0xB1C3185FC770E1827155E7DD1E8C0BA5 , 0xFA79817D87FA87392B5B91819A77033D , 0xEBE2F6F3BACA1D5ED93C7E9DF8BE7DAE , 0xF5D08755AD22E6F8992EFDA07C3148B5 , 0xBB05EA66FEBD27CBB27B4E8CAB326078 , 0xEBF4BA7E0B00447F54154DEB9540E1C8 , 0x2A5DC2FB3A399401F6ECD2A07B2D6E09 , 0x350E67120124DFF13F4D82080D4C0E8D , 0xE729621C012F733218D7DC668FD421DD , 0x72C3B28CCB3F67F188751E1A82C9E389 , 0x08AAE544254862941EF0B6521F4692E5 , 0xCB7ECAFA28F1404045B5EBC5BAD8E08F , 0x091899ADD6C6C44C167FDB4AC9B622F5 , 0x4CB4FF633097ED115F39F636BEF13A01 , 0x08C9B0BF8D1DF04C8D3E085C44FC70A5 , 0x6DCAEED260E421F3FAEC0BA73E8EDC3E , 0x5A0EC8593ED5067433DDDDFAC0FCB5AA , 0x77BBADB306810A509D96321256FFF403 , 0xAC8FBA79C86D39E7F6F4F6C8D95C25A0 , 0xB0DEB1428FEF580191837ED50A863E5F , 0x500731A428F4EE4C26215544551BD9CF );
Copy
6.32 ms (9.05%)
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/019e017df9a276a4af12f2db0c080aff "
"/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/449f301829070dd643072efd8ec5a8a1 "
"/detail/b1c3185fc770e1827155e7dd1e8c0ba5 "
"/detail/fa79817d87fa87392b5b91819a77033d "
"/detail/ebe2f6f3baca1d5ed93c7e9df8be7dae "
"/detail/f5d08755ad22e6f8992efda07c3148b5 "
"/detail/bb05ea66febd27cbb27b4e8cab326078 "
"/detail/ebf4ba7e0b00447f54154deb9540e1c8 "
"/detail/2a5dc2fb3a399401f6ecd2a07b2d6e09 "
"/detail/350e67120124dff13f4d82080d4c0e8d "
"/detail/e729621c012f733218d7dc668fd421dd "
"/detail/72c3b28ccb3f67f188751e1a82c9e389 "
"/detail/08aae544254862941ef0b6521f4692e5 "
"/detail/cb7ecafa28f1404045b5ebc5bad8e08f "
"/detail/091899add6c6c44c167fdb4ac9b622f5 "
"/detail/4cb4ff633097ed115f39f636bef13a01 "
"/detail/08c9b0bf8d1df04c8d3e085c44fc70a5 "
"/detail/6dcaeed260e421f3faec0ba73e8edc3e "
"/detail/5a0ec8593ed5067433ddddfac0fcb5aa "
"/detail/77bbadb306810a509d96321256fff403 "
"/detail/ac8fba79c86d39e7f6f4f6c8d95c25a0 "
"/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/019e017df9a276a4af12f2db0c080aff' , '/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/449f301829070dd643072efd8ec5a8a1' , '/detail/b1c3185fc770e1827155e7dd1e8c0ba5' , '/detail/fa79817d87fa87392b5b91819a77033d' , '/detail/ebe2f6f3baca1d5ed93c7e9df8be7dae' , '/detail/f5d08755ad22e6f8992efda07c3148b5' , '/detail/bb05ea66febd27cbb27b4e8cab326078' , '/detail/ebf4ba7e0b00447f54154deb9540e1c8' , '/detail/2a5dc2fb3a399401f6ecd2a07b2d6e09' , '/detail/350e67120124dff13f4d82080d4c0e8d' , '/detail/e729621c012f733218d7dc668fd421dd' , '/detail/72c3b28ccb3f67f188751e1a82c9e389' , '/detail/08aae544254862941ef0b6521f4692e5' , '/detail/cb7ecafa28f1404045b5ebc5bad8e08f' , '/detail/091899add6c6c44c167fdb4ac9b622f5' , '/detail/4cb4ff633097ed115f39f636bef13a01' , '/detail/08c9b0bf8d1df04c8d3e085c44fc70a5' , '/detail/6dcaeed260e421f3faec0ba73e8edc3e' , '/detail/5a0ec8593ed5067433ddddfac0fcb5aa' , '/detail/77bbadb306810a509d96321256fff403' , '/detail/ac8fba79c86d39e7f6f4f6c8d95c25a0' , '/navigation/01968c8c36bf7d64a6458dea553bd083' , '/navigation/01968c8c66857cbdaa3fe53f64460992' , '/navigation/01968c8c819b7a3f80b7123704ac53e6' , '/navigation/01968c8ca8b57752817b01710b71694a' , '/navigation/01968c8e2d3a74a38a6c10f9f8460cea' , '/navigation/01968c8e463172098d9fdfbd02e7079a' , '/navigation/01968c8e5ce473fd981f91192b9ea060' , '/navigation/01968c8e70bd7f69b2d493c206e115cb' , '/navigation/01968c8eb0427cb382bf2677391a27af' , '/navigation/01968c8f733271dda4a6b5b5769d6a3d' , '/navigation/01968c8fcbcb7e17b2c838cd17eec670' , '/navigation/01968c904e6a7dc795fb655c6bba1a6c' , '/navigation/01968c910b567b13bd06bf0bb60f3a0d' , '/navigation/01968c91ed89784c83a9842c8cea2016' , '/navigation/01968c9316807749a8a0e77442aec819' )) AND (seo_url . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (seo_url . sales_channel_id = 0x01914A3133A37822896D0C70B2FD3B67 OR seo_url . sales_channel_id IS NULL ) AND (seo_url . is_deleted = 0 );
Copy
5.29 ms (7.57%)
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"DŸ0\x18 )\x07 \r ÖC\x07 .ýŽÅ¨¡ "
b"±Ã\x18 _Çpá‚qUçÝ\x1E Œ\v ¥ "
b"úy}‡ú‡9+[‘šw\x03 = "
b"ëâöóºÊ\x1D ^Ù<~ø¾}® "
b"õЇU"æø™.ý |1Hµ "
b"»\x05 êfþ½'˲{NŒ«2`x "
b"ëôº~\v\x00 D\x7F T\x15 Më•@áÈ "
b"*]Âû:9”\x01 öìÒ {-n\t "
b"5\x0E g\x12\x01 $ßñ?M‚\x08 \r L\x0E Ž "
b"ç)b\x1C\x01 /s2\x18 ×ÜfÔ!Ý "
b"ròŒË?gñˆu\x1E\x1A ‚É㉠"
b"\x08 ªåD%Hb”\x1E ð¶R\x1F F’å "
b"Ë~Êú(ñ@@EµëźØà "
b"\t\x18 ™ÖÆÄL\x16\x7F ÛJɶ"õ "
b"L´ÿc0—í\x11 _9ö6¾ñ:\x01 "
b"\x08 ɰ¿Ž\x1D ðLŽ>\x08 \Düp¥ "
b"mÊîÒ`ä!óúì\v §>ŽÜ> "
b"Z\x0E ÈY>Õ\x06 t3ÝÝúÀüµª "
b"""
w»³\x06 \n
P–2\x12 Vÿô\x03
"""
b"¬ºyÈm9çöôöÈÙ\% "
]
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 (0x449F301829070DD643072EFD8EC5A8A1 , 0xB1C3185FC770E1827155E7DD1E8C0BA5 , 0xFA79817D87FA87392B5B91819A77033D , 0xEBE2F6F3BACA1D5ED93C7E9DF8BE7DAE , 0xF5D08755AD22E6F8992EFDA07C3148B5 , 0xBB05EA66FEBD27CBB27B4E8CAB326078 , 0xEBF4BA7E0B00447F54154DEB9540E1C8 , 0x2A5DC2FB3A399401F6ECD2A07B2D6E09 , 0x350E67120124DFF13F4D82080D4C0E8D , 0xE729621C012F733218D7DC668FD421DD , 0x72C3B28CCB3F67F188751E1A82C9E389 , 0x08AAE544254862941EF0B6521F4692E5 , 0xCB7ECAFA28F1404045B5EBC5BAD8E08F , 0x091899ADD6C6C44C167FDB4AC9B622F5 , 0x4CB4FF633097ED115F39F636BEF13A01 , 0x08C9B0BF8D1DF04C8D3E085C44FC70A5 , 0x6DCAEED260E421F3FAEC0BA73E8EDC3E , 0x5A0EC8593ED5067433DDDDFAC0FCB5AA , 0x77BBADB306810A509D96321256FFF403 , 0xAC8FBA79C86D39E7F6F4F6C8D95C25A0 ));
Copy
3.89 ms (5.56%)
4
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )) AND (sales_channel_id = ? )
Parameters :
[
b"DŸ0\x18 )\x07 \r ÖC\x07 .ýŽÅ¨¡ "
b"±Ã\x18 _Çpá‚qUçÝ\x1E Œ\v ¥ "
b"úy}‡ú‡9+[‘šw\x03 = "
b"ëâöóºÊ\x1D ^Ù<~ø¾}® "
b"õЇU"æø™.ý |1Hµ "
b"»\x05 êfþ½'˲{NŒ«2`x "
b"ëôº~\v\x00 D\x7F T\x15 Më•@áÈ "
b"*]Âû:9”\x01 öìÒ {-n\t "
b"5\x0E g\x12\x01 $ßñ?M‚\x08 \r L\x0E Ž "
b"ç)b\x1C\x01 /s2\x18 ×ÜfÔ!Ý "
b"ròŒË?gñˆu\x1E\x1A ‚É㉠"
b"\x08 ªåD%Hb”\x1E ð¶R\x1F F’å "
b"Ë~Êú(ñ@@EµëźØà "
b"\t\x18 ™ÖÆÄL\x16\x7F ÛJɶ"õ "
b"L´ÿc0—í\x11 _9ö6¾ñ:\x01 "
b"\x08 ɰ¿Ž\x1D ðLŽ>\x08 \Düp¥ "
b"mÊîÒ`ä!óúì\v §>ŽÜ> "
b"Z\x0E ÈY>Õ\x06 t3ÝÝúÀüµª "
b"""
w»³\x06 \n
P–2\x12 Vÿô\x03
"""
b"¬ºyÈm9çöôöÈÙ\% "
b"\x01 ¦Jœ&p•²ÇŠÿÞ“šà "
]
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (0x449F301829070DD643072EFD8EC5A8A1 , 0xB1C3185FC770E1827155E7DD1E8C0BA5 , 0xFA79817D87FA87392B5B91819A77033D , 0xEBE2F6F3BACA1D5ED93C7E9DF8BE7DAE , 0xF5D08755AD22E6F8992EFDA07C3148B5 , 0xBB05EA66FEBD27CBB27B4E8CAB326078 , 0xEBF4BA7E0B00447F54154DEB9540E1C8 , 0x2A5DC2FB3A399401F6ECD2A07B2D6E09 , 0x350E67120124DFF13F4D82080D4C0E8D , 0xE729621C012F733218D7DC668FD421DD , 0x72C3B28CCB3F67F188751E1A82C9E389 , 0x08AAE544254862941EF0B6521F4692E5 , 0xCB7ECAFA28F1404045B5EBC5BAD8E08F , 0x091899ADD6C6C44C167FDB4AC9B622F5 , 0x4CB4FF633097ED115F39F636BEF13A01 , 0x08C9B0BF8D1DF04C8D3E085C44FC70A5 , 0x6DCAEED260E421F3FAEC0BA73E8EDC3E , 0x5A0EC8593ED5067433DDDDFAC0FCB5AA , 0x77BBADB306810A509D96321256FFF403 , 0xAC8FBA79C86D39E7F6F4F6C8D95C25A0 )) AND (sales_channel_id = 0x0190A64A9C267095B2C78AFFDE939AE0 );
Copy
2.24 ms (3.21%)
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/Berge,%20Bj%C3%B8rn "
"/author/Berge,%20Bj%C3%B8rn "
"https://hauptbuchhandlung.staging.eurosoft.network/author/Berge,%20Bj%C3%B8rn "
"https://hauptbuchhandlung.staging.eurosoft.network//author/Berge,%20Bj%C3%B8rn "
"/author/Berge,%20Bj%C3%B8rn "
"//author/Berge,%20Bj%C3%B8rn "
"author/Berge,%20Bj%C3%B8rn "
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/Berge,%20Bj%C3%B8rn' , '/author/Berge,%20Bj%C3%B8rn' , 'https://hauptbuchhandlung.staging.eurosoft.network/author/Berge,%20Bj%C3%B8rn' , 'https://hauptbuchhandlung.staging.eurosoft.network//author/Berge,%20Bj%C3%B8rn' , '/author/Berge,%20Bj%C3%B8rn' , '//author/Berge,%20Bj%C3%B8rn' , 'author/Berge,%20Bj%C3%B8rn' ) AND `scop_platform_redirecter_redirect` . `enabled` = 1 AND (`scop_platform_redirecter_redirect` . `salesChannelId` = 0x01914A3133A37822896D0C70B2FD3B67 OR `scop_platform_redirecter_redirect` . `salesChannelId` < = > NULL )) LIMIT 1 ;
Copy
2.15 ms (3.08%)
1
SELECT `unit` . `id` as `unit.id` , `unit` . `created_at` as `unit.createdAt` , `unit` . `updated_at` as `unit.updatedAt` , `unit.translation.shortCode` , `unit.translation.shortCode` as `unit.shortCode` , `unit.translation.name` , `unit.translation.name` as `unit.name` , `unit.translation.customFields` , `unit.translation.customFields` as `unit.customFields` FROM `unit` LEFT JOIN (SELECT `unit.translation` . `unit_id` , `unit.translation` . `short_code` as `unit.translation.shortCode` , `unit.translation` . `name` as `unit.translation.name` , `unit.translation` . `custom_fields` as `unit.translation.customFields` FROM `unit_translation` `unit.translation` WHERE `unit.translation` . `language_id` = ? ) `unit.unit_translation` ON `unit.unit_translation` . `unit_id` = `unit` . `id`
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `unit` . `id` as `unit.id` , `unit` . `created_at` as `unit.createdAt` , `unit` . `updated_at` as `unit.updatedAt` , `unit.translation.shortCode` , `unit.translation.shortCode` as `unit.shortCode` , `unit.translation.name` , `unit.translation.name` as `unit.name` , `unit.translation.customFields` , `unit.translation.customFields` as `unit.customFields` FROM `unit` LEFT JOIN (SELECT `unit.translation` . `unit_id` , `unit.translation` . `short_code` as `unit.translation.shortCode` , `unit.translation` . `name` as `unit.translation.name` , `unit.translation` . `custom_fields` as `unit.translation.customFields` FROM `unit_translation` `unit.translation` WHERE `unit.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `unit.unit_translation` ON `unit.unit_translation` . `unit_id` = `unit` . `id` ;
Copy
1.37 ms (1.97%)
4
"START TRANSACTION"
"START TRANSACTION" ;
Copy
1.37 ms (1.96%)
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
1.30 ms (1.86%)
1
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.translation.name` , `category.translation.name` as `category.name` , `category.translation.breadcrumb` , `category.translation.breadcrumb` as `category.breadcrumb` , `category.translation.slotConfig` , `category.translation.slotConfig` as `category.slotConfig` , `category.translation.linkType` , `category.translation.linkType` as `category.linkType` , `category.translation.internalLink` , `category.translation.internalLink` as `category.internalLink` , `category.translation.externalLink` , `category.translation.externalLink` as `category.externalLink` , `category.translation.linkNewTab` , `category.translation.linkNewTab` as `category.linkNewTab` , `category.translation.description` , `category.translation.description` as `category.description` , `category.translation.metaTitle` , `category.translation.metaTitle` as `category.metaTitle` , `category.translation.metaDescription` , `category.translation.metaDescription` as `category.metaDescription` , `category.translation.keywords` , `category.translation.keywords` as `category.keywords` , `category.translation.customFields` , `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation` . `category_id` , `category.translation` . `category_version_id` , `category.translation` . `breadcrumb` as `category.translation.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation` . `slot_config` as `category.translation.slotConfig` , `category.translation` . `link_type` as `category.translation.linkType` , `category.translation` . `internal_link` as `category.translation.internalLink` , `category.translation` . `external_link` as `category.translation.externalLink` , `category.translation` . `link_new_tab` as `category.translation.linkNewTab` , `category.translation` . `description` as `category.translation.description` , `category.translation` . `meta_title` as `category.translation.metaTitle` , `category.translation` . `meta_description` as `category.translation.metaDescription` , `category.translation` . `keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation` . `language_id` = ? ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . `category_version_id` = `category` . `version_id` WHERE (`category` . `version_id` = ? ) AND (`category` . `id` IN (? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4% "
b"\x01 ‘C\¬t®Ö_œêdÎy "
]
SELECT
`category` . `id` as `category.id` ,
`category` . `version_id` as `category.versionId` ,
`category` . `parent_id` as `category.parentId` ,
`category` . `parent_version_id` as `category.parentVersionId` ,
`category` . `after_category_id` as `category.afterCategoryId` ,
`category` . `after_category_version_id` as `category.afterCategoryVersionId` ,
`category` . `media_id` as `category.mediaId` ,
`category` . `display_nested_products` as `category.displayNestedProducts` ,
`category` . `auto_increment` as `category.autoIncrement` ,
`category` . `level` as `category.level` ,
`category` . `path` as `category.path` ,
`category` . `child_count` as `category.childCount` ,
`category` . `type` as `category.type` ,
`category` . `product_assignment_type` as `category.productAssignmentType` ,
`category` . `visible` as `category.visible` ,
`category` . `active` as `category.active` ,
`category` . `cms_page_id` as `category.cmsPageId` ,
`category` . `cms_page_version_id` as `category.cmsPageVersionId` ,
`category` . `product_stream_id` as `category.productStreamId` ,
`category` . `custom_entity_type_id` as `category.customEntityTypeId` ,
`category` . `created_at` as `category.createdAt` ,
`category` . `updated_at` as `category.updatedAt` ,
`category.translation.name` ,
`category.translation.name` as `category.name` ,
`category.translation.breadcrumb` ,
`category.translation.breadcrumb` as `category.breadcrumb` ,
`category.translation.slotConfig` ,
`category.translation.slotConfig` as `category.slotConfig` ,
`category.translation.linkType` ,
`category.translation.linkType` as `category.linkType` ,
`category.translation.internalLink` ,
`category.translation.internalLink` as `category.internalLink` ,
`category.translation.externalLink` ,
`category.translation.externalLink` as `category.externalLink` ,
`category.translation.linkNewTab` ,
`category.translation.linkNewTab` as `category.linkNewTab` ,
`category.translation.description` ,
`category.translation.description` as `category.description` ,
`category.translation.metaTitle` ,
`category.translation.metaTitle` as `category.metaTitle` ,
`category.translation.metaDescription` ,
`category.translation.metaDescription` as `category.metaDescription` ,
`category.translation.keywords` ,
`category.translation.keywords` as `category.keywords` ,
`category.translation.customFields` ,
`category.translation.customFields` as `category.customFields`
FROM
`category`
LEFT JOIN (
SELECT
`category.translation` . `category_id` ,
`category.translation` . `category_version_id` ,
`category.translation` . `breadcrumb` as `category.translation.breadcrumb` ,
`category.translation` . `name` as `category.translation.name` ,
`category.translation` . `custom_fields` as `category.translation.customFields` ,
`category.translation` . `slot_config` as `category.translation.slotConfig` ,
`category.translation` . `link_type` as `category.translation.linkType` ,
`category.translation` . `internal_link` as `category.translation.internalLink` ,
`category.translation` . `external_link` as `category.translation.externalLink` ,
`category.translation` . `link_new_tab` as `category.translation.linkNewTab` ,
`category.translation` . `description` as `category.translation.description` ,
`category.translation` . `meta_title` as `category.translation.metaTitle` ,
`category.translation` . `meta_description` as `category.translation.metaDescription` ,
`category.translation` . `keywords` as `category.translation.keywords`
FROM
`category_translation` `category.translation`
WHERE
`category.translation` . `language_id` = ?
) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id`
AND `category.category_translation` . `category_version_id` = `category` . `version_id`
WHERE
(`category` . `version_id` = ? )
AND (
`category` . `id` IN (? )
)
Copy
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.translation.name` , `category.translation.name` as `category.name` , `category.translation.breadcrumb` , `category.translation.breadcrumb` as `category.breadcrumb` , `category.translation.slotConfig` , `category.translation.slotConfig` as `category.slotConfig` , `category.translation.linkType` , `category.translation.linkType` as `category.linkType` , `category.translation.internalLink` , `category.translation.internalLink` as `category.internalLink` , `category.translation.externalLink` , `category.translation.externalLink` as `category.externalLink` , `category.translation.linkNewTab` , `category.translation.linkNewTab` as `category.linkNewTab` , `category.translation.description` , `category.translation.description` as `category.description` , `category.translation.metaTitle` , `category.translation.metaTitle` as `category.metaTitle` , `category.translation.metaDescription` , `category.translation.metaDescription` as `category.metaDescription` , `category.translation.keywords` , `category.translation.keywords` as `category.keywords` , `category.translation.customFields` , `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation` . `category_id` , `category.translation` . `category_version_id` , `category.translation` . `breadcrumb` as `category.translation.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation` . `slot_config` as `category.translation.slotConfig` , `category.translation` . `link_type` as `category.translation.linkType` , `category.translation` . `internal_link` as `category.translation.internalLink` , `category.translation` . `external_link` as `category.translation.externalLink` , `category.translation` . `link_new_tab` as `category.translation.linkNewTab` , `category.translation` . `description` as `category.translation.description` , `category.translation` . `meta_title` as `category.translation.metaTitle` , `category.translation` . `meta_description` as `category.translation.metaDescription` , `category.translation` . `keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . `category_version_id` = `category` . `version_id` WHERE (`category` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (`category` . `id` IN (0x01918E435CAC74AE90D65F9CEA64CE79 ));
Copy
1.16 ms (1.66%)
1
SELECT `delivery_time` . `id` as `delivery_time.id` , `delivery_time` . `min` as `delivery_time.min` , `delivery_time` . `max` as `delivery_time.max` , `delivery_time` . `unit` as `delivery_time.unit` , `delivery_time` . `created_at` as `delivery_time.createdAt` , `delivery_time` . `updated_at` as `delivery_time.updatedAt` , `delivery_time.translation.name` , `delivery_time.translation.name` as `delivery_time.name` , `delivery_time.translation.customFields` , `delivery_time.translation.customFields` as `delivery_time.customFields` FROM `delivery_time` LEFT JOIN (SELECT `delivery_time.translation` . `delivery_time_id` , `delivery_time.translation` . `name` as `delivery_time.translation.name` , `delivery_time.translation` . `custom_fields` as `delivery_time.translation.customFields` FROM `delivery_time_translation` `delivery_time.translation` WHERE `delivery_time.translation` . `language_id` = ? ) `delivery_time.delivery_time_translation` ON `delivery_time.delivery_time_translation` . `delivery_time_id` = `delivery_time` . `id` WHERE `delivery_time` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 ¥Ðº¥qh“?6:þÇ,\x02 "
]
SELECT `delivery_time` . `id` as `delivery_time.id` , `delivery_time` . `min` as `delivery_time.min` , `delivery_time` . `max` as `delivery_time.max` , `delivery_time` . `unit` as `delivery_time.unit` , `delivery_time` . `created_at` as `delivery_time.createdAt` , `delivery_time` . `updated_at` as `delivery_time.updatedAt` , `delivery_time.translation.name` , `delivery_time.translation.name` as `delivery_time.name` , `delivery_time.translation.customFields` , `delivery_time.translation.customFields` as `delivery_time.customFields` FROM `delivery_time` LEFT JOIN (SELECT `delivery_time.translation` . `delivery_time_id` , `delivery_time.translation` . `name` as `delivery_time.translation.name` , `delivery_time.translation` . `custom_fields` as `delivery_time.translation.customFields` FROM `delivery_time_translation` `delivery_time.translation` WHERE `delivery_time.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `delivery_time.delivery_time_translation` ON `delivery_time.delivery_time_translation` . `delivery_time_id` = `delivery_time` . `id` WHERE `delivery_time` . `id` IN (0x0190A5D0BAA57168933F363AFEC72C02 );
Copy
1.10 ms (1.57%)
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 ˜3\x1A ì†sÞºð\x19 KHB\x00 Ï "
b"\x01 ˜8\x07 ³.su·M\x1F àë\x04 2‰ "
b"\x01 ˜8\x1D J$y\x04 ‰²±!øË\t 5 "
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 –g^Ü\x1A r1™ŽnÉf™’² "
b"""
\x01 —Àï¿ýp\x0E ´ë%¬óf\n
õ
"""
b"\x01 ˜,\x03 3Õr©€AÃ\x1A ݯßï "
b"\x01 ˜6Sà\x01 }þ‹|&Y¹Íå¥ "
b"\x01 ˜7ú\x1C cr²¦¸foB$\x16 é "
b"\x01 ˜\x04 y/y\x0F ¤úé4Z˜\x11 Ô "
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Ù "
b"\x01 —ù%gŽr\x08 ®xàxv9RÎ "
]
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 (0x0198331AEC8673DEBAF0194B484200CF , 0x01983807B32E7375B74D1FE0EB043289 , 0x0198381D4A24790489B2B121F8CB0935 , 0x01916AFF7FED71D48D111DF14D8877C3 , 0x01916B06E08D72168742C1B6FB833969 , 0x01916B07F53E78FDA9670FF37E1BFFAB , 0x0196675EDC1A7231998E6EC9669992B2 , 0x0197C0EFBFFD700EB4EB25ACF3660AF5 , 0x01982C0333D572A98041C31ADDAFDFEF , 0x01983653E0017DFE8B7C2659B9CDE5A5 , 0x019837FA1C6372B2A6B8666F422416E9 , 0x0198AD04792F790FA4FAE9345A9811D4 , 0x0190A5D0BA7A733A8B556FC290A8FC47 , 0x0190A5D0BAC7736CB4C7E4E63A7F6A37 , 0x0190A5D0F8E1705185B7C4CF43AA1E09 , 0x01919949597F7CF9952F88D3C9922182 , 0x0190A5D0BB6473948636854C684B9FD9 , 0x0197F925678E7208AE78E078763952CE );
Copy
1.03 ms (1.47%)
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-06-04T07:07:44+00:00' ) OR (`show_until` > `updated_at` AND `show_until` < '2026-06-04T07:07:44+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-06-04T07:07:44+00:00' ) OR (`show_until` > `updated_at` AND `show_until` < '2026-06-04T07:07:44+00:00' )) AND `active` = '1' ; ;
Copy
1.02 ms (1.46%)
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.99 ms (1.42%)
2
SELECT `key` , `value` FROM `app_config`
SELECT `key` , `value` FROM `app_config` ;
Copy
0.98 ms (1.40%)
4
"COMMIT"
0.94 ms (1.34%)
1
SELECT `country` . `id` as `country.id` , `country` . `iso` as `country.iso` , `country` . `position` as `country.position` , `country` . `active` as `country.active` , `country` . `shipping_available` as `country.shippingAvailable` , `country` . `iso3` as `country.iso3` , `country` . `display_state_in_registration` as `country.displayStateInRegistration` , `country` . `force_state_in_registration` as `country.forceStateInRegistration` , `country` . `check_vat_id_pattern` as `country.checkVatIdPattern` , `country` . `vat_id_required` as `country.vatIdRequired` , `country` . `vat_id_pattern` as `country.vatIdPattern` , `country` . `customer_tax` as `country.customerTax` , `country` . `company_tax` as `country.companyTax` , `country` . `postal_code_required` as `country.postalCodeRequired` , `country` . `check_postal_code_pattern` as `country.checkPostalCodePattern` , `country` . `check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern` , `country` . `advanced_postal_code_pattern` as `country.advancedPostalCodePattern` , `country` . `default_postal_code_pattern` as `country.defaultPostalCodePattern` , `country` . `is_eu` as `country.isEu` , `country` . `created_at` as `country.createdAt` , `country` . `updated_at` as `country.updatedAt` , (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.90 ms (1.29%)
1
SELECT `country` . `id` as `country.id` , `country` . `iso` as `country.iso` , `country` . `position` as `country.position` , `country` . `active` as `country.active` , `country` . `shipping_available` as `country.shippingAvailable` , `country` . `iso3` as `country.iso3` , `country` . `display_state_in_registration` as `country.displayStateInRegistration` , `country` . `force_state_in_registration` as `country.forceStateInRegistration` , `country` . `check_vat_id_pattern` as `country.checkVatIdPattern` , `country` . `vat_id_required` as `country.vatIdRequired` , `country` . `vat_id_pattern` as `country.vatIdPattern` , `country` . `customer_tax` as `country.customerTax` , `country` . `company_tax` as `country.companyTax` , `country` . `postal_code_required` as `country.postalCodeRequired` , `country` . `check_postal_code_pattern` as `country.checkPostalCodePattern` , `country` . `check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern` , `country` . `advanced_postal_code_pattern` as `country.advancedPostalCodePattern` , `country` . `default_postal_code_pattern` as `country.defaultPostalCodePattern` , `country` . `is_eu` as `country.isEu` , `country` . `created_at` as `country.createdAt` , `country` . `updated_at` as `country.updatedAt` , `country.translation.name` , `country.translation.name` as `country.name` , `country.translation.addressFormat` , `country.translation.addressFormat` as `country.addressFormat` , `country.translation.customFields` , `country.translation.customFields` as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation` . `country_id` , `country.translation` . `name` as `country.translation.name` , `country.translation` . `custom_fields` as `country.translation.customFields` , `country.translation` . `address_format` as `country.translation.addressFormat` FROM `country_translation` `country.translation` WHERE `country.translation` . `language_id` = ? ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` WHERE `country` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 ¥Ð¹ms\x03 ¿5=Ó\x03 å¹' "
]
SELECT `country` . `id` as `country.id` , `country` . `iso` as `country.iso` , `country` . `position` as `country.position` , `country` . `active` as `country.active` , `country` . `shipping_available` as `country.shippingAvailable` , `country` . `iso3` as `country.iso3` , `country` . `display_state_in_registration` as `country.displayStateInRegistration` , `country` . `force_state_in_registration` as `country.forceStateInRegistration` , `country` . `check_vat_id_pattern` as `country.checkVatIdPattern` , `country` . `vat_id_required` as `country.vatIdRequired` , `country` . `vat_id_pattern` as `country.vatIdPattern` , `country` . `customer_tax` as `country.customerTax` , `country` . `company_tax` as `country.companyTax` , `country` . `postal_code_required` as `country.postalCodeRequired` , `country` . `check_postal_code_pattern` as `country.checkPostalCodePattern` , `country` . `check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern` , `country` . `advanced_postal_code_pattern` as `country.advancedPostalCodePattern` , `country` . `default_postal_code_pattern` as `country.defaultPostalCodePattern` , `country` . `is_eu` as `country.isEu` , `country` . `created_at` as `country.createdAt` , `country` . `updated_at` as `country.updatedAt` , `country.translation.name` , `country.translation.name` as `country.name` , `country.translation.addressFormat` , `country.translation.addressFormat` as `country.addressFormat` , `country.translation.customFields` , `country.translation.customFields` as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation` . `country_id` , `country.translation` . `name` as `country.translation.name` , `country.translation` . `custom_fields` as `country.translation.customFields` , `country.translation` . `address_format` as `country.translation.addressFormat` FROM `country_translation` `country.translation` WHERE `country.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` WHERE `country` . `id` IN (0x0190A5D0B96D7303BF353DD303E5B927 );
Copy
0.87 ms (1.25%)
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.84 ms (1.21%)
1
SELECT `country` . `id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country` . `id` = `country.salesChannels.mapping` . `country_id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping` . `sales_channel_id` = `country.salesChannels` . `id` WHERE (`country.salesChannels` . `id` = ? ) GROUP BY `country` . `id`
Parameters :
[
b"\x01 ‘J13£x"‰m\f p²ý;g "
]
SELECT `country` . `id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country` . `id` = `country.salesChannels.mapping` . `country_id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping` . `sales_channel_id` = `country.salesChannels` . `id` WHERE (`country.salesChannels` . `id` = 0x01914A3133A37822896D0C70B2FD3B67 ) GROUP BY `country` . `id` ;
Copy
0.83 ms (1.18%)
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.82 ms (1.18%)
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.82 ms (1.18%)
1
SELECT `sales_channel` . `id` as `sales_channel.id` , `sales_channel` . `type_id` as `sales_channel.typeId` , `sales_channel` . `language_id` as `sales_channel.languageId` , `sales_channel` . `customer_group_id` as `sales_channel.customerGroupId` , `sales_channel` . `currency_id` as `sales_channel.currencyId` , `sales_channel` . `payment_method_id` as `sales_channel.paymentMethodId` , `sales_channel` . `shipping_method_id` as `sales_channel.shippingMethodId` , `sales_channel` . `country_id` as `sales_channel.countryId` , `sales_channel` . `analytics_id` as `sales_channel.analyticsId` , `sales_channel` . `navigation_category_id` as `sales_channel.navigationCategoryId` , `sales_channel` . `navigation_category_version_id` as `sales_channel.navigationCategoryVersionId` , `sales_channel` . `navigation_category_depth` as `sales_channel.navigationCategoryDepth` , `sales_channel` . `footer_category_id` as `sales_channel.footerCategoryId` , `sales_channel` . `footer_category_version_id` as `sales_channel.footerCategoryVersionId` , `sales_channel` . `service_category_id` as `sales_channel.serviceCategoryId` , `sales_channel` . `service_category_version_id` as `sales_channel.serviceCategoryVersionId` , `sales_channel` . `mail_header_footer_id` as `sales_channel.mailHeaderFooterId` , `sales_channel` . `hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId` , `sales_channel` . `short_name` as `sales_channel.shortName` , `sales_channel` . `tax_calculation_type` as `sales_channel.taxCalculationType` , `sales_channel` . `access_key` as `sales_channel.accessKey` , `sales_channel` . `configuration` as `sales_channel.configuration` , `sales_channel` . `active` as `sales_channel.active` , `sales_channel` . `hreflang_active` as `sales_channel.hreflangActive` , `sales_channel` . `maintenance` as `sales_channel.maintenance` , `sales_channel` . `maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist` , `sales_channel` . `payment_method_ids` as `sales_channel.paymentMethodIds` , `sales_channel` . `home_cms_page_id` as `sales_channel.homeCmsPageId` , `sales_channel` . `home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId` , `sales_channel` . `created_at` as `sales_channel.createdAt` , `sales_channel` . `updated_at` as `sales_channel.updatedAt` , `sales_channel.translation.name` , `sales_channel.translation.name` as `sales_channel.name` , `sales_channel.translation.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig` , `sales_channel.translation.homeEnabled` , `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled` , `sales_channel.translation.homeName` , `sales_channel.translation.homeName` as `sales_channel.homeName` , `sales_channel.translation.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle` , `sales_channel.translation.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription` , `sales_channel.translation.homeKeywords` , `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords` , `sales_channel.translation.customFields` , `sales_channel.translation.customFields` as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation` . `sales_channel_id` , `sales_channel.translation` . `name` as `sales_channel.translation.name` , `sales_channel.translation` . `custom_fields` as `sales_channel.translation.customFields` , `sales_channel.translation` . `home_slot_config` as `sales_channel.translation.homeSlotConfig` , `sales_channel.translation` . `home_enabled` as `sales_channel.translation.homeEnabled` , `sales_channel.translation` . `home_name` as `sales_channel.translation.homeName` , `sales_channel.translation` . `home_meta_title` as `sales_channel.translation.homeMetaTitle` , `sales_channel.translation` . `home_meta_description` as `sales_channel.translation.homeMetaDescription` , `sales_channel.translation` . `home_keywords` as `sales_channel.translation.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation` . `language_id` = ? ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id` WHERE `sales_channel` . `id` IN (? , ? , ? , ? , ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 ¦Jœ&p•²ÇŠÿÞ“šà "
b"\x01 ‘J13£x"‰m\f p²ý;g "
b"˜C-ï9üF$³2\x13 ¥kŒ”M "
b"\x01 ¦Jœ&p•²ÇŠÿÞ“šà "
b"\x01 ‘J13£x"‰m\f p²ý;g "
]
SELECT
`sales_channel` . `id` as `sales_channel.id` ,
`sales_channel` . `type_id` as `sales_channel.typeId` ,
`sales_channel` . `language_id` as `sales_channel.languageId` ,
`sales_channel` . `customer_group_id` as `sales_channel.customerGroupId` ,
`sales_channel` . `currency_id` as `sales_channel.currencyId` ,
`sales_channel` . `payment_method_id` as `sales_channel.paymentMethodId` ,
`sales_channel` . `shipping_method_id` as `sales_channel.shippingMethodId` ,
`sales_channel` . `country_id` as `sales_channel.countryId` ,
`sales_channel` . `analytics_id` as `sales_channel.analyticsId` ,
`sales_channel` . `navigation_category_id` as `sales_channel.navigationCategoryId` ,
`sales_channel` . `navigation_category_version_id` as `sales_channel.navigationCategoryVersionId` ,
`sales_channel` . `navigation_category_depth` as `sales_channel.navigationCategoryDepth` ,
`sales_channel` . `footer_category_id` as `sales_channel.footerCategoryId` ,
`sales_channel` . `footer_category_version_id` as `sales_channel.footerCategoryVersionId` ,
`sales_channel` . `service_category_id` as `sales_channel.serviceCategoryId` ,
`sales_channel` . `service_category_version_id` as `sales_channel.serviceCategoryVersionId` ,
`sales_channel` . `mail_header_footer_id` as `sales_channel.mailHeaderFooterId` ,
`sales_channel` . `hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId` ,
`sales_channel` . `short_name` as `sales_channel.shortName` ,
`sales_channel` . `tax_calculation_type` as `sales_channel.taxCalculationType` ,
`sales_channel` . `access_key` as `sales_channel.accessKey` ,
`sales_channel` . `configuration` as `sales_channel.configuration` ,
`sales_channel` . `active` as `sales_channel.active` ,
`sales_channel` . `hreflang_active` as `sales_channel.hreflangActive` ,
`sales_channel` . `maintenance` as `sales_channel.maintenance` ,
`sales_channel` . `maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist` ,
`sales_channel` . `payment_method_ids` as `sales_channel.paymentMethodIds` ,
`sales_channel` . `home_cms_page_id` as `sales_channel.homeCmsPageId` ,
`sales_channel` . `home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId` ,
`sales_channel` . `created_at` as `sales_channel.createdAt` ,
`sales_channel` . `updated_at` as `sales_channel.updatedAt` ,
`sales_channel.translation.name` ,
`sales_channel.translation.name` as `sales_channel.name` ,
`sales_channel.translation.homeSlotConfig` ,
`sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig` ,
`sales_channel.translation.homeEnabled` ,
`sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled` ,
`sales_channel.translation.homeName` ,
`sales_channel.translation.homeName` as `sales_channel.homeName` ,
`sales_channel.translation.homeMetaTitle` ,
`sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle` ,
`sales_channel.translation.homeMetaDescription` ,
`sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription` ,
`sales_channel.translation.homeKeywords` ,
`sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords` ,
`sales_channel.translation.customFields` ,
`sales_channel.translation.customFields` as `sales_channel.customFields`
FROM
`sales_channel`
LEFT JOIN (
SELECT
`sales_channel.translation` . `sales_channel_id` ,
`sales_channel.translation` . `name` as `sales_channel.translation.name` ,
`sales_channel.translation` . `custom_fields` as `sales_channel.translation.customFields` ,
`sales_channel.translation` . `home_slot_config` as `sales_channel.translation.homeSlotConfig` ,
`sales_channel.translation` . `home_enabled` as `sales_channel.translation.homeEnabled` ,
`sales_channel.translation` . `home_name` as `sales_channel.translation.homeName` ,
`sales_channel.translation` . `home_meta_title` as `sales_channel.translation.homeMetaTitle` ,
`sales_channel.translation` . `home_meta_description` as `sales_channel.translation.homeMetaDescription` ,
`sales_channel.translation` . `home_keywords` as `sales_channel.translation.homeKeywords`
FROM
`sales_channel_translation` `sales_channel.translation`
WHERE
`sales_channel.translation` . `language_id` = ?
) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id`
WHERE
`sales_channel` . `id` IN (? , ? , ? , ? , ? )
Copy
SELECT `sales_channel` . `id` as `sales_channel.id` , `sales_channel` . `type_id` as `sales_channel.typeId` , `sales_channel` . `language_id` as `sales_channel.languageId` , `sales_channel` . `customer_group_id` as `sales_channel.customerGroupId` , `sales_channel` . `currency_id` as `sales_channel.currencyId` , `sales_channel` . `payment_method_id` as `sales_channel.paymentMethodId` , `sales_channel` . `shipping_method_id` as `sales_channel.shippingMethodId` , `sales_channel` . `country_id` as `sales_channel.countryId` , `sales_channel` . `analytics_id` as `sales_channel.analyticsId` , `sales_channel` . `navigation_category_id` as `sales_channel.navigationCategoryId` , `sales_channel` . `navigation_category_version_id` as `sales_channel.navigationCategoryVersionId` , `sales_channel` . `navigation_category_depth` as `sales_channel.navigationCategoryDepth` , `sales_channel` . `footer_category_id` as `sales_channel.footerCategoryId` , `sales_channel` . `footer_category_version_id` as `sales_channel.footerCategoryVersionId` , `sales_channel` . `service_category_id` as `sales_channel.serviceCategoryId` , `sales_channel` . `service_category_version_id` as `sales_channel.serviceCategoryVersionId` , `sales_channel` . `mail_header_footer_id` as `sales_channel.mailHeaderFooterId` , `sales_channel` . `hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId` , `sales_channel` . `short_name` as `sales_channel.shortName` , `sales_channel` . `tax_calculation_type` as `sales_channel.taxCalculationType` , `sales_channel` . `access_key` as `sales_channel.accessKey` , `sales_channel` . `configuration` as `sales_channel.configuration` , `sales_channel` . `active` as `sales_channel.active` , `sales_channel` . `hreflang_active` as `sales_channel.hreflangActive` , `sales_channel` . `maintenance` as `sales_channel.maintenance` , `sales_channel` . `maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist` , `sales_channel` . `payment_method_ids` as `sales_channel.paymentMethodIds` , `sales_channel` . `home_cms_page_id` as `sales_channel.homeCmsPageId` , `sales_channel` . `home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId` , `sales_channel` . `created_at` as `sales_channel.createdAt` , `sales_channel` . `updated_at` as `sales_channel.updatedAt` , `sales_channel.translation.name` , `sales_channel.translation.name` as `sales_channel.name` , `sales_channel.translation.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig` , `sales_channel.translation.homeEnabled` , `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled` , `sales_channel.translation.homeName` , `sales_channel.translation.homeName` as `sales_channel.homeName` , `sales_channel.translation.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle` , `sales_channel.translation.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription` , `sales_channel.translation.homeKeywords` , `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords` , `sales_channel.translation.customFields` , `sales_channel.translation.customFields` as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation` . `sales_channel_id` , `sales_channel.translation` . `name` as `sales_channel.translation.name` , `sales_channel.translation` . `custom_fields` as `sales_channel.translation.customFields` , `sales_channel.translation` . `home_slot_config` as `sales_channel.translation.homeSlotConfig` , `sales_channel.translation` . `home_enabled` as `sales_channel.translation.homeEnabled` , `sales_channel.translation` . `home_name` as `sales_channel.translation.homeName` , `sales_channel.translation` . `home_meta_title` as `sales_channel.translation.homeMetaTitle` , `sales_channel.translation` . `home_meta_description` as `sales_channel.translation.homeMetaDescription` , `sales_channel.translation` . `home_keywords` as `sales_channel.translation.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id` WHERE `sales_channel` . `id` IN (0x0190A64A9C267095B2C78AFFDE939AE0 , 0x01914A3133A37822896D0C70B2FD3B67 , 0x98432DEF39FC4624B33213A56B8C944D , 0x0190A64A9C267095B2C78AFFDE939AE0 , 0x01914A3133A37822896D0C70B2FD3B67 );
Copy
0.80 ms (1.15%)
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/Berge,%20Bj%C3%B8rn "
"author/Berge,%20Bj%C3%B8rn/ "
]
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/Berge,%20Bj%C3%B8rn' OR seo_path_info = 'author/Berge,%20Bj%C3%B8rn/' ));
Copy
0.73 ms (1.05%)
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.72 ms (1.04%)
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.70 ms (1.00%)
1
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ? ) AND (token = ? ) LIMIT 1
Parameters :
[
b"\x01 ‘J13£x"‰m\f p²ý;g "
"P8uczLU9gH1vty0FOYUm6QUSbjwy7ELx "
]
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0x01914A3133A37822896D0C70B2FD3B67 ) AND (token = 'P8uczLU9gH1vty0FOYUm6QUSbjwy7ELx' ) LIMIT 1 ;
Copy
0.69 ms (0.98%)
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.67 ms (0.95%)
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.66 ms (0.94%)
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.63 ms (0.90%)
2
SELECT LOWER (HEX (parent_id )) FROM language WHERE id = ?
Parameters :
[
"0190a5d21558701cb17a1f89991d17e2 "
]
SELECT LOWER (HEX (parent_id )) FROM language WHERE id = '0190a5d21558701cb17a1f89991d17e2' ;
Copy
0.62 ms (0.89%)
1
SELECT path FROM category WHERE id = ?
Parameters :
[
b"\x01 ‘C\¬t®Ö_œêdÎy "
]
SELECT path FROM category WHERE id = 0x01918E435CAC74AE90D65F9CEA64CE79 ;
Copy
0.61 ms (0.87%)
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
`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.52 ms (0.74%)
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.49 ms (0.71%)
1
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = ?
Parameters :
[
"P8uczLU9gH1vty0FOYUm6QUSbjwy7ELx "
]
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = 'P8uczLU9gH1vty0FOYUm6QUSbjwy7ELx' ;
Copy
0.48 ms (0.69%)
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.42 ms (0.60%)
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/Berge,%20Bj%C3%B8rn "
]
SELECT path_info pathInfo , seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (sales_channel_id = 0x01914A3133A37822896D0C70B2FD3B67 ) AND (path_info = '/author/Berge,%20Bj%C3%B8rn' ) AND (is_canonical = 1 ) LIMIT 1 ;
Copy
0.41 ms (0.59%)
1
SELECT LOWER (HEX (sales_channel_id )) AS sales_channel_id , route_name , template
FROM seo_url_template
WHERE route_name IN (? )
Parameters :
[
"frontend.detail.page "
]
SELECT LOWER (HEX (sales_channel_id )) AS sales_channel_id , route_name , template
FROM seo_url_template
WHERE route_name IN ('frontend.detail.page' );
Copy
0.40 ms (0.57%)
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.40 ms (0.57%)
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.39 ms (0.55%)
1
SELECT `app` . `name` , `app` . `version` , `app` . `template_load_priority`
FROM `app`
INNER JOIN `app_template` ON `app_template` . `app_id` = `app` . `id`
WHERE `app` . `active` = 1 AND `app_template` . `active` = 1
SELECT `app` . `name` , `app` . `version` , `app` . `template_load_priority`
FROM `app`
INNER JOIN `app_template` ON `app_template` . `app_id` = `app` . `id`
WHERE `app` . `active` = 1 AND `app_template` . `active` = 1 ;
Copy
0.38 ms (0.55%)
1
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = ?
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = 'de-DE' ;
Copy
0.35 ms (0.50%)
1
SELECT `language` . `id` as `language.id` , `language` . `parent_id` as `language.parentId` , `language` . `locale_id` as `language.localeId` , `language` . `translation_code_id` as `language.translationCodeId` , `language` . `name` as `language.name` , `language` . `custom_fields` as `language.customFields` , `language` . `created_at` as `language.createdAt` , `language` . `updated_at` as `language.updatedAt` FROM `language`
SELECT `language` . `id` as `language.id` , `language` . `parent_id` as `language.parentId` , `language` . `locale_id` as `language.localeId` , `language` . `translation_code_id` as `language.translationCodeId` , `language` . `name` as `language.name` , `language` . `custom_fields` as `language.customFields` , `language` . `created_at` as `language.createdAt` , `language` . `updated_at` as `language.updatedAt` FROM `language` ;
Copy
0.34 ms (0.48%)
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.33 ms (0.47%)
1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1 ;
Copy
0.24 ms (0.34%)
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