10.96 ms (18.53%)
13
SELECT `currency` . `id` as `currency.id` , `currency` . `factor` as `currency.factor` , `currency` . `symbol` as `currency.symbol` , `currency` . `iso_code` as `currency.isoCode` , `currency` . `position` as `currency.position` , `currency` . `tax_free_from` as `currency.taxFreeFrom` , `currency` . `item_rounding` as `currency.itemRounding` , `currency` . `total_rounding` as `currency.totalRounding` , `currency` . `created_at` as `currency.createdAt` , `currency` . `updated_at` as `currency.updatedAt` , `currency.translation.shortName` , `currency.translation.shortName` as `currency.shortName` , `currency.translation.name` , `currency.translation.name` as `currency.name` , `currency.translation.customFields` , `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation` . `currency_id` , `currency.translation` . `short_name` as `currency.translation.shortName` , `currency.translation` . `name` as `currency.translation.name` , `currency.translation` . `custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation` . `language_id` = ? ) `currency.currency_translation` ON `currency.currency_translation` . `currency_id` = `currency` . `id` WHERE (`currency` . `iso_code` IN (? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
"CHF "
]
SELECT `currency` . `id` as `currency.id` , `currency` . `factor` as `currency.factor` , `currency` . `symbol` as `currency.symbol` , `currency` . `iso_code` as `currency.isoCode` , `currency` . `position` as `currency.position` , `currency` . `tax_free_from` as `currency.taxFreeFrom` , `currency` . `item_rounding` as `currency.itemRounding` , `currency` . `total_rounding` as `currency.totalRounding` , `currency` . `created_at` as `currency.createdAt` , `currency` . `updated_at` as `currency.updatedAt` , `currency.translation.shortName` , `currency.translation.shortName` as `currency.shortName` , `currency.translation.name` , `currency.translation.name` as `currency.name` , `currency.translation.customFields` , `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation` . `currency_id` , `currency.translation` . `short_name` as `currency.translation.shortName` , `currency.translation` . `name` as `currency.translation.name` , `currency.translation` . `custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `currency.currency_translation` ON `currency.currency_translation` . `currency_id` = `currency` . `id` WHERE (`currency` . `iso_code` IN ('CHF' ));
Copy
8.84 ms (14.95%)
1
SELECT `meta_catalog_id` . `id` FROM `meta_catalog_id` WHERE `meta_catalog_id` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"æõàÊ?²½L<\x19 BÝ$\x03 Y\x14 "
b"·é˜\v g\x18\x1C Ì?Ùä$÷µ° "
b"À¶eëitÉi- ’M;¨\x13 Ú "
b"\f Ã\x02 ?\û€aüh ý(ö;~ "
b"d\x02 Îõ„K’Èßàéö3"ok "
b"\x1F \t nû(•ñï"hœ\x08\x13 U "
b"ç\x17 \x1F Û}€—Å›[`8Äl5 "
b"ÈÙœ\x11 @¦ô^¡Üš5ñ¨‡‘ "
b"4ê¾ïÊ๎¬ÚÛ?C§I "
b"ØLÚôcÃÙ=pnI·\x00 Rþ\x1D "
b"7¿\x0E \{á*a#\x19 ü"¤bY? "
b"æg&KÉ:< tÓÞ±àÊß\x13 "
b"%ÙzjL/ÌSÛšŠÖ͉µ” "
b"èbåÄ¿A;O\x1A\x12 2¡ùãÖ "
b"|RÍ©“SI±K\v àUüjP "
b"•îÏé52k\x17 @\x07\x14 ¡ZòŸj "
b"\x08 ì¶T¿|ÖS|Õ9ù}3,2 "
b"""
Y¹\x12 ô\x06 îû¾æÎ#\n
Õã\x01 ð
"""
b"³t!2G«-¨Ö‘{w\x13 x\x07 C "
b"""
ì\n
Ší>Ÿ2ZT›\e ±vä\x03 »
"""
b"Ýh¿š³$×»@ôË“*lȸ "
b"DèxŠ&#Ù˜áyòç!ƒ‡Š "
b"!;ÿEª²k¿‡\x15 áb)éLã "
b"Û\x02 ÚÇ*ß:\†)ñi[§û "
b"\x01 '«k\x04 ›\x11 ßF\x01 #ïvý¾ "
b"j¼+¢\x0E ©‰Vý’"›`\x1A\x1F m "
b"Ι)ƒÅ\x17 ?JžUª\f \x17\x13 ü "
b"õâ\x12 `û>µ TÕ¬÷½\x0F f+ "
b"žäþK¡L‹eN¾“PM\x1F KŒ "
b"Â\x15 åOU7\x13 ¡ºh9¥”ަ_ "
b"Ö3N™Ñ¨¼\x1A ù\x16 ¦Æ~Ðþ "
b"«ŠS#í\x03 ¾HC„¬f\x1D ]\r , "
b"c»ßA\x10 å»\e fó–•Ú¹\x19\e "
b"\x0F pEö|\x03 {µuj’˸\x03 œO "
b"""
ûOúzaÛÐ\x19 ƒG‹n\n
\x0E\x7F\x05
"""
b"²y8œÄ·ñ0cô\x10 sSù™ "
b"Z‘aí¾_Ä+UŽBnJàÏ\x1D "
b"?ÀÕÇ\x1F ‹Œ\x12 hv\x03 081MK "
b":~WỀ\x03 ûj_\f ½5¬\x15 "
b"Z&-§\x15\x17 ~7\x00 26: -çÇ "
b"ýެJ8¿[bªð\x13 –¼ý\x19 å "
b"!\e 8\x04 L5«0\x10\f ;ÁX<St "
b"p\x05 öï$Ú\x1C\x08 6ZMT’ç\x01 "
b"""
¶×´]â x“;hô\n
uBuc
"""
b"¾hfbÓÉØ‡[êlìtãÞÛ "
b"""
³£\n
ÛO\x0E Ž\x14 LRŒé\x03 “B~
"""
b"q¿°§Í\f ãJx\x14 Ø\x18 z\x13\x02 B "
b"åHÄ•!\f 7\x11 vBÓJ¿¼_m "
b"""
\x13 $Ž\n
¦±dâ—‘šA=¼§
"""
b"°´þ›Â¦’Ð’Í(úÔk×n "
b"ܱU\x12 Ô33-r\x1E ˜AàU¿ú "
b"F—ðäö<\ι”^Žä½ÿ\x15 "
b"\e ºòÐ\x02\x1D •Qâ`¹0‹× "
b"ÙÙ…{\x1E bŽNñ3‹Ï` "
b"ÿP\x04 &÷2"9\f :\x05 »CRùô "
b"J\e ¶~Á`íÌíYÉJŽ\x12 û\x10 "
b"""
\n
·,ˆ\x03 ‘\x1E @KFÒ*7iÒ½
"""
b"ÀjmiG©è\x7F G‘w<>#-$ "
b"d\v\x16 ýr\e ÐØ¹Éí±æ‰/û "
b"œ\v\x19 *RšìMN\t Â‹ÇøùÏ "
b"8\x1C a©wÐPµ0¾\f\x1D %\x1F ]ý "
b"ì·íú \x14 BG{†¼\x7F k\x15\x0E  "
b"8E\x15\x06 PâD%tW¢¢>ù "
b"˜ž\x0F £›\x0E ÷]®M&ë \ä "
b"À\r Ò\x1F õ¬µj\x1A 6·y››Xƒ "
b"""
ÎÑ/\n
¥ú;‹õO6\x12 ²º Æ
"""
b"B¬—\e (”û]÷í½þ_}\x06 "
b"\x14 Ô/ä\x04 ZÔÀå4Ð\e H\x14 (w "
b"8…Ì1¶´åRfþ¯é?¯¦f "
b"›\x08 Èz®rÑÇ}QFœ\x07\f Ð\n "
b"š{T\x00 vRÞñÂÀ¦Þj\f -Ö "
b"Ý÷ ¿Ø6éA+þ›1íäŽ "
b"3?2\x15\x01 óþ1øõ 5A²\x1D | "
b"lGÒߘ\x11 OKLÈ?·mði¥ "
b"–6Tôé–¨D~\x06 žº0KW« "
b"‚í7\x05 ÷Ñã-_^~Ãûͬ€ "
b"Ð\x18 ‰/‚X[caÔ›+Þ¡?a "
b"²è\x06 Ö¨šô\x15 ióÂ&è\x04\x19\x00 "
b" i\x00 jåZ¯¶ù‘Œï\x06\x16 ÙÍ "
b"\x03 è\x07\x10 ñ¡S\x1E ëÿ…X»¤í\e "
b"óÇÒbcÃT['jÆù\x07\v ÔŽ "
b"¶é×\x01 i\e ll_<æï\x18 ߇A "
b"‹PŸ®©uÈ^u{“†0s\x07 ’ "
b"\x1C\x05 Á:JÝÿí_\x04 œ´ÛÒ¦~ "
b"6t¿²Å7»\x18 â31„JW i "
b"'m\f «ÜR§hù³ÈV÷=lß "
b"ÓÑ\x7F zÐè¦TÙ\x16 Dð{\"» "
b"ê"³=øn-Ä%\x12\x13 í\x14\x15 þ, "
b"Ùa–7õœ\x1E\x01 ð˜T\r \x04 …K "
b"îó\x04 ÔÊ·ÐQˆu†"eT/ "
b"\r -/\e\x1D ¬×nD\e ·øm\é "
b"0³Ï0ÊæP̃\x12 ?Q˜\t\x18 ì "
b"¸ã\x18 ü×¢Ô\x12 „åÍL‡ÎZ "
b"\x05 Äæ¬gÊ›€v57\x06 "nä "
b"\x1D Ô\x1C Ê*\x07 Ó\t Ý\x13 tµu²\x1C s "
b"†\x03 #\x15 ˜%¥´ºLÐÄù_Å "
b"¹Nƒ¹íBuð”Ihi˨‡ "
b"”ðîa×S/´å’x\x06 ¼\t D "
b"\x03 äò^Ú﹊³À_$z¡Ô "
b"¦ÿS=´<:º\x01 þKO#„©± "
b"ûãëÌs2Þ`Œ(Iún·ñ§ "
b"y¦g\x0F J•\x02\x17 7ç\x15 ¼ŒˆÈ4 "
b"Ξ%\f +ï¦vÖ\x14 ¯Zµ\\x17\x7F "
b"Ïé)5\x1C ”–—ÏXzxÐ\x16 "
b"c\x19 §]ß™vœ÷)fQ@Ô\r ¾ "
b"£ìT&›Li²\x0E ¢Lb"J\e c "
b"å0qŽ˜ éUn}da6Ï£ò "
b"õ¢\x19 LÐ|é%•‘®îTkŸ "
b"*[qʜP?3@�Y2. "
b"\v c\x19 rå€FÂ\zÏÔš¼õ\x1C "
b"Áž\x18 L޽\x0F û7_\x06\x16 =ê`0 "
b"‹´×6ìrôÅTž\x16 ¦ÓOLi "
b"O%äÀôõËXž\x05\x01 |~J<ˆ "
b"ã\x14 ežEÜáW&ÀàÁÐ\v\x17 "
b"\x0F ·#¸³r;Jé©ÑQ—5,\x11 "
b"\x14 µ!;<d„‰¹žÓ\x12 úõp "
b"üyÙš¦mƒs™Ž´¢\x06 çA¨ "
b"«_I*¥é$ͺòÕdJ‚k "
b"$’î\x1F tŶñ;V³»iJ\v "
b"6†âª?“‘ÌNCìf–m\x06 Š "
b"-I`a\x04 âõ=—AðÂö–G "
b"Ïxµ¬\x1A .÷vû«\x18 |\x17 \r ‹Ú "
b"|{wOž¿8ãÖ(Žf¥\x11 œ\n "
b"\x0F †IÜÄN¶fšTjþÈÕ\x02 "
b"¨>\x1E\x01 kÒ\x1F ÆÆÄ\x1E\x7F ©ã> "
b"""
gªÈ9Þ"<™o‘qQ+n\n
ä
"""
b"I\x16 Íø\x0F =ú¾ÔÚ‘ˆ|Š\x16\x12 "
b"8…YO‘®U˜Ê\v ‹ÁYÎsö "
b"M\x1D žd¡ŒÁù‚Åή\x04\x02 žV "
b"""
\x18 Ž\x13 \n
NÊ{ED÷æ’Ά™]
"""
b"àÑø)\x16 FSþÈß?‚ýùp "
b"{õƒ^´êB\x1A €ù¹§öV\x7F "
b"EÃ`tIãØšõƬ\x1C ƒüi6 "
b"\x0E b±Ð¨ŠÙî-Æ\x05 Ä\x08 1è. "
b"¼©g`èÚQRáp|™sÙxÕ "
b"ý\x1D\x05 ÌD‘\x0E\x19 9Ï^>]ÕWÚ "
b"\x15 v,+©ïÔ0ˆ7Ž\x12 ò³€\x02 "
b"¬Öõ¶(±·\x16 aw¦ÿâ/\x11 œ "
b"\x18 +–\x1A 6µ]SÑÖV£chU\x04 "
b",Åg+sçñ«H\x10 Lª\x02 Ž\x14 ˜ "
b"Â["T¥0ÈÒ4\x04 åöú "
b"\x1D V›ÌXm"âDûÎŽ\x1D ÁX "
b"ÅÍØ°3v){Q£\x00 •€†¯š "
b"\x1E š>C\x06 kûfùJ•ú«س "
b"ófW2]=\x00 vFU&\x05 j\x1F\x7F q "
b"-a«Oüx\x14 ªéBì¡¢¶â£ "
b"³ôj\x02 ù¨J a¹¶×ÖÈÜT "
b"—_¯}îUÓVºôÙkŒ–nj "
b">\íû¤=Õ´z·1óMSª‡ "
b"ø¸-Rô‰\v ßUÁ\t j#>@ "
b"fKøQðS\x11\x06 ×&À‘\x06\x03 ¦¹ "
b"~•\x01 »\x12 Ú»¥ùNSמçm# "
b"c9ì\x06 ƒçñ.Y¦;\x04 \r C "
b"~T๠è¢ìçýÄìrä2 "
b"\x12 w±\x1F C8_ßÞùȾ_\x13 [\n "
b"àµ8³–,9qð݃›UÜ$ "
b"Fx \§0Gß5Ëjwˆ\x17 BŒ "
b"â\x00 K5»\x10 €rS06G|òÄB "
b"ƒMVª+A#\x1D å°Ù3ÃMÚ\x1A "
b"Ó°ª\e pÿ«z6e€d\x19 S\x0E "
b"R4„\e wâ3®¶8*\x1C ŽÖnO "
b"…®;ê…\x1C TeKÚøð^“þ "
b"õ\r ÞW›\x06\x16 vÓû„ò\x0E | "
b"ǣ窔“ŠnÔ£#N‹âº "
b"H\x18 +ã}ßU–<tRÂL\f ø "
b"(G@—È¢v/@ͧ^MÊ*û "
b"^øßÉâ#õ<€\‰/\x1D Ò‘M "
b"»°P\x07 .ç\x10 |ÚäÚ¨\x08 œ× "
b"gNîIA\x13 »œDÄ*?²I\x02 ¦ "
b"‰(~º².¾‰ïý=\x02 Ð[ÚÕ "
b"=)zèú¤7ðL?84€€mÈ "
b"·UÎ^ð¦±Í§?ƒm\x04\x16 c¢ "
b"\r ”%â™õëy\x1A Ý ¦²\x14 "
b"LGME#DMÁß-(ØÔìߪ "
b"ÁÄ&äßtýV~K™v¦Wƒ "
b"""
ßœj&Ó‹·0G \n
ÌŽª0
"""
b"æ,3\r µ\x15\x04 -efÃt]nì "
b"þ;\x08 û&\x16 ƒ\x08 ¡HíYç¬ "
b"\x11 Ça)Ùêûë\f {v\„Wݼ "
b"æ*Ë_~-|(Ñ®ª¦/í0\ "
b"æ@{ÚR‡º\x07 ë™®Àòc "
b"TŒ£Û¤ŸóÍ^\v û¨»Òÿë "
b"*\e \x1C ½DûÑV#~ÅT‹ë] "
b" Æ\x04 ¥TžÙÀÝ݉àx ÌŽ "
b"ŠäÜEH˜\e Ðz]ž¥Ç@\v "
b"""
\r €.‡\n
´-È"<\x11 ¬EVVJ
"""
b"ò3ö§\x1A }øP‡ð„þÏ—i\x16 "
b"ùcB¹ìÊZujLS•ù8\x0F ž "
b"1·'–|y˜˜é\x16 &ã˜\x06 ,È "
b"¥Š…É5ÓUVZ¶6鹬ô' "
b"å+NåO¶ˆ\x19 d&‹¢‘ÑS "
b"K`\x1D\x15 +ãZÒ\x15\x07\x14 ˧ºm "
b"èÑ^V¶'S‚lÄÐ\x1F £fpé "
b"rºOJ,«\x0E —®¿Òlƒ\x13 dÖ "
b"&!z=”ÏytâáôU–\x13 ¡F "
b"u!òn\x06 m\x14 ¡ÑxÅ\x08 àB\x02 t "
b"Æc‹`üK\x02 š¡\x7F Œl!¥Tw "
b"""
Žï™Ý\n
\e ´ž›\x14\x1D ÙþLà\x7F
"""
b"†xsǾcÑCŒ\x01 B²<Òäà "
b"\f Fä4¯FË©ÀýÕèc'j "
b"""
ÙɆËnb¯Ö£\n
ÒÌVp‡i
"""
b"ø‚#\x16 }Ž-ö7\x18 jµ[w3 "
b"ÿ¨%\x03 Q_ª\x10 M¬\x1D £¥Z>f "
b"¨F\x0E ®‰yrƒŸT“\x03 Á1<† "
b"#÷£¤·¯é(\x14 QKk9DIé "
b"biÒRËÇØdÊ\x7F þÖ>õ, "
b" ’4êÝ®M\x13 °ÔUÝì‚ï4 "
b"™¾_6.\x13 ÉSùn$Lf…Ò' "
b"%3VhM\x14 Òšƒ¹cãÙkS! "
b"i,RQË€\x13 RaÀaÔ§ýx] "
b"|«GXˆÛçŽÝÙb¡d¢†R "
b"·šds2uö}¼¬}Èo\x0F S¾ "
b"\r ³Ó0y8P—\x7F ¦ýLÕ* "
b"ÕÖLO\x0F òS˜úf\x12 Ä,œŽï "
b"9\x01 -í|³´<ÿ xM‘ãd< "
b"צÄ\x11 §d¥Ø¯‘j&\x15\t ©8 "
]
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 (0xE6F5E0CA3FB2BD4C3C1942DD24035914 , 0xB781E9980B67181CCC3FD9E424F7B5B0 , 0xC0B665EB6974C9692D20924D3BA813DA , 0x0CC3023F5CFB8061FC6820FD28F63B7E , 0x6402CEF5844B92C8DFE0E9F633226F6B , 0x1F9081096EFB2895F1EF22689C081355 , 0xE717AD1FDB7D8097C59B5B6038C46C35 , 0xC8D99C1140A6F45EA1DC9A35F1A88791 , 0x34EABEEFCAE0B98DADACDADB3F43A749 , 0xD84CDAF463C3D93D706E49B70052FE1D , 0x37BF0E5C7BE12A612319FC22A462593F , 0xE667264BC93A3C2074D3DEB1E0CADF13 , 0x25D97A6A4C2FCC53DB9A8AD6CD89B594 , 0xC3A862E5C4BF413B4F1A1232A1F9E3D6 , 0x7C52CDADA9935349B14B0BE055FC6A50 , 0x95EECFE935326B17400714A15AF29F6A , 0x08ECB654BF7CD6537CD539F97D332C32 , 0x59B912F406EEFBBEE6CE230AD5E301F0 , 0xB374213247AB2DA8D6917B7713780743 , 0xEC0A8AED3E9F325A549B1BB176E403BB , 0xDD68BF9AB324D7BB40F4CB932A6CC8B8 , 0x44E8788A2623D998E179F2E72183878A , 0x213BFF45AAB26BBF8715E16229E94CE3 , 0xDB02DAC72ADF3A5C8629F169815BA7FB , 0x0127ABAD6B049B11DF460123EF76FDBE , 0x6ABC2BA20EA98956FD92229B601A1F6D , 0xCE992983C5173F4A9E55AA0CAD1713FC , 0xF5E21260FB3EB5A054D5ACF7BD0F662B , 0x9EE4FE4BA14C8B654EBE93504D1F4B8C , 0xC215E54F553713A1BA6839A5948DA65F , 0xD6334E99D1A8BC1AF916A6C67ED0FE81 , 0xAB8A5323ED03BE484384AC661D5D0D2C , 0x63BBDF4110E5BB1B66F39695DAB9191B , 0x0F7045F67C037BB5756A92CBB8039C4F , 0xFB4FFA7A61DBD01983478B6E0A0E7F05 , 0xB279389CC4B7F13063F4107353F98199 , 0x5A9161EDBE5FC42B558D426E4AE0CF1D , 0x3FC0D5C71F8B8C126876033038314D4B , 0x3A7E57E1BB8003FB6A815F0CBD35AC15 , 0x5A262DA715177E370032363A202DE7C7 , 0xFD8DAC4A38BF5B62AAF01396BCFD19E5 , 0x211B38044C35AB30100C3BC1583C5374 , 0x7005F6EF24DA1C08365A4D548F92E701 , 0xB6D7B45DE2A078933B68F40A75427563 , 0xBE686662D3C9D8875BEA6CEC74E3DEDB , 0xB3A30ADB4F0E8D144C528CE90393427E , 0x71BFB0A7CD0CE34A7814D8187A130242 , 0xE548C495210C37117642D34ABFBC5F6D , 0x13248D0AA6B164E297919A81413DBCA7 , 0xB0B4FE9BC2A692D092CD28FAD46BD76E , 0xDCB15512D433332D721E9841E055BFFA , 0x4697F0E4F63C5CCEB9945E8EE4BDFF15 , 0x1BBA8EF2D0021D9551E29060B9308BD7 , 0xD9D9857B9F1E628D4EF18E338BCF6090 , 0xFF500426F73222390C3A05BB4352F9F4 , 0x4A1BB67EC160EDCCED59C94A8E12FB10 , 0x0AB72C8803911E404B46D22A3769D2BD , 0xC06A6D6947A9E87F4791773C3E232D24 , 0x640B16FD721BD0D8B9C9EDB1E6892FFB , 0x9C0B192A529AEC4D4E09C28BC7F8F9CF , 0x381C61A977D050B530BE0C1D251F5DFD , 0xECB7EDFAA01442477B86BC7F6B150EC2 , 0x3845150650E2449F25749D57A2A23EF9 , 0x989E0FA39B0EF75DAE4D268FEB205CE4 , 0xC00DD21FF5ACB56A1A36B7799B9B5883 , 0xCED12F0AA5FA3B8BF54F3612B2BAA0C6 , 0x42AC971B288194FB5DF7EDBDFE5F7D06 , 0x14D42FE4045AD4C0E534D01B48142877 , 0x3885CC31B6B4E55266FEAFE93FAFA666 , 0x9B08C87AAE72D1C77D51469C070CD00A , 0x9A7B54007652DEF1C2C0A6DE6A0C2DD6 , 0xADDDF7A0BFD836E9412BFE9B31EDE48D , 0x333F321501F3FE31F8F5203541B21D7C , 0x6C47D2DF98114F4B4CC83FB76DF069A5 , 0x963654F4E996A8447E069EBA304B57AB , 0x82ED3705F7D1E32D5F5E7EC3FBCDAC80 , 0xD018892F82585B6361D49B2BDEA13F61 , 0xB2E806D6A89AF41569F3C226E8041900 , 0xA069006AE55AAFB6F9918CEF0616D9CD , 0x03E80710F1A1531EEBFF8558BBA4ED1B , 0xF3C7D26263C3545B276AC6F9070BD48D , 0xB6E9D701691B6C6C5F3CE6EF18DF8741 , 0x8B509FAEA975C85E757B938630730792 , 0x1C05C13A4ADDFFED5F049CB4DBD2A67E , 0x3674BFB2C537BB18E23331844A57A069 , 0x276D0CABDC52A768F9B3C856F73D6CDF , 0xD3D17F7AD0E8A654D91644F07B5C22BB , 0xEA22B33DF86E2DC4251213ED1415FE2C , 0xD961969037F59C1E01F098540D04854B , 0xEEF304D4CAB7D0518875862265542F90 , 0x0D2D9D2F1B1DACD76E441BB7F86D5CE9 , 0x30B3CF30CAE650CC83123F51980918EC , 0xB8E318FCD7A2D41284E5CD4CAD87CE5A , 0x05C4E6AC67CA8F9B8076353706226EE4 , 0x1DD41CCA2A07D309DD1374B575B21C73 , 0x86032315989D25A5B4BA4CD0C4F95FC5 , 0xB94E83B9ED4275F09449688169CBA887 , 0x94F0EE61D7532FB4E5927806BC09449D , 0x03E4F25EDAEFB99D8AB3C05F247AA1D4 , 0xA6FF533DB43C3ABA01FE4B4F2384A9B1 , 0xFBE3EBCC7332DE608C2849FA6EB7F1A7 , 0x79A6670F4A95021737E715BC8C88C834 , 0xCE9E250C2BEFA676D614AF5AB55C177F , 0xCFE929351C949697CF588E907A78D016 , 0x6319A75DDF99769CF729665140D40DBE , 0xA3EC54269B4C69B20EA24C62224A1B63 , 0xE530718E9820E9556E7D646136CFA3F2 , 0xF5A2194CD07CE9259591AEEEAD546B9F , 0x2AAD5B71CA9C503F3340E4893F59322E , 0x0B631972E58046C25C7ACFD49ABCF51C , 0xC19E184C8DBD0FFB375F06163DEA6030 , 0x8BB4D736EC72F4C5549E16A6D34F4C69 , 0x4F25E4C0F4F5CB589E05017C7E4A3C88 , 0xE314659E45DCE15726C0E0C1D00B178F , 0x0FB723B8B3723B4AE9A9D15197352C11 , 0x14B5213B3CAD648489B99ED312FAF570 , 0xFC79D99AA66D8373998DB4A206E741A8 , 0xAB5F492AA59DE924CDBAF2D5644A826B , 0x2492EE1F74C5B6F13B8F56B3BB694A0B , 0x3686E2AA3F9391CC4E43EC66966D068A , 0x2D49606104C3A2F53D9741F0C2F69647 , 0xCF78B5AC1A2EF776FBAB187C170D8BDA , 0x7C7B774F9EBF38E3D6288E66A5119C0A , 0x0F8649DCC44EB6669A90546AFEC8D502 , 0xA83E1E016BD21FC6C6C41E7FA9E38F3E , 0x67AAC839DE223C996F9171512B6E0AE4 , 0x4916CDF80F3DFABED4DA91887C8A1612 , 0x3885594F91AE5598CA0B8BC159CE73F6 , 0x4D1D9E64A18CC1F982C5CEAE04029E56 , 0x188E130A4ECA7B4544F7E692CE86995D , 0xE0D181F829164653FEC8DF3F82FDF970 , 0x7BF5835EB4EA421A80F9B9A781F6567F , 0x45C3607449E3D89AF5C6AC1C83FC6936 , 0x0E62B1D0A88AD9EE2DC605C40831E82E , 0xBCA96760E8DA5152E1707C9973D978D5 , 0xFD1D05CC44910E1939CF5E3E5DD557DA , 0x15762C2BA9EFD43088378D12F2B38002 , 0xACD6F5B628B1B7166177A6FFE22F119C , 0x182B961A36B55D53D1D656A363685504 , 0x2CC5672B73E7F1AB48104CAA028E1498 , 0xC25B22548F90A530C8D2348F04E5F6FA , 0x1D569BCC586D22ADE244FBCE8E1DC158 , 0xC5CDD8B03376297B51A300958086AF9A , 0x1E9A3E43066BFB66F94A95FAC2ABD8B3 , 0xF36657325D3D0076465526056A1F7F71 , 0x2D61AB4FFC7814AAE942ECA1A2B6E2A3 , 0xB3F46A02F9A84A2061B9B6D7D6C8DC54 , 0x975FAF7DEE55D356BAF4D96B8C966E6A , 0x3E5CEDFBA43DD5B47AB731F34D53AA87 , 0xF8B82D52F4C2890BDF55C1096A233E40 , 0x664BF851F0531106D726C0910603A6B9 , 0x7E9501BB12DABBA5F94E53D79EE76D23 , 0x6339EC90068381E7F12E59A63B040D43 , 0x7E54E0B9A0E8A2ECE7FDC384EC72E432 , 0x1277B11F43385FDFDEF9C8BE5F135B0A , 0xE0B538B3968F2C3971F0DD839B55DC24 , 0x4678205CA73047DF35CB6A778817428C , 0xE2004B35BB108072533036477CF2C442 , 0x834D56AA2B41231DE5B0D933C34DDA1A , 0xD3B0AA811B70FFAB7A3665806419530E , 0x5234841B77E233AEB6382A1C8ED66E4F , 0x85AE3BEA81851C54654BDAF8F05E93FE , 0xF50DDE579B061676ADD3FB84F20E7C90 , 0xC7A3E7AA94938A6E9DD4A3234E8BE2BA , 0xAD48182BE37DDF55963C7452C24C0CF8 , 0x28474097C8A2762F40CDA75E4DCA2AFB , 0x5EF8DFC9E223F53C805C892F1DD2914D , 0xBBB05090072EE7107CDAE4DAA8089CD7 , 0x674EEE494113BB9C44C42A3FB24902A6 , 0x89287EBAB22EBE89EFFD3D02D05BDAD5 , 0x3D297AE8FAA437F04C3F383480806DC8 , 0xB755CE5EF0A6B1CDA73F836D041663A2 , 0x0D9425E299F5EB791ADDA0A6B214A09D , 0x4C474D4523444DC1DF2D28D8D4ECDFAA , 0xC1C426E4DF74FD56907E4B9976A65783 , 0xDF9C6A26D38BB73047A00ACCAD8EAA30 , 0xE62C330DB515042D6566C3745D6E8FEC , 0xFE3B08FB2616839F08A14890ED59E7AC , 0x11C76129D9EAFBEB0C7B765C8457DDBC , 0xE62ACB5F7E2D7C28D1AEAAA62FED305C , 0xE6407BDA5287ADBA07EB9990AEC0F263 , 0x548CA3DBA49FF3CD5E0BFBA8BBD2FFEB , 0x2A1B8F1CBD44FBD156237EC5548BEB5D , 0xA0C604A5549ED9C0DDDD89E078A0CC8D , 0x818AE4DC4548981BD07A5D9EA5C7400B , 0x0D802E870AB42DC8223C11AC4556564A , 0xF233F6A71A7DF85087F084FECF976916 , 0xF96342B9ECCA5A756A4C5395F9380F9E , 0x31B727967C799898E91626E398062CC8 , 0xA58A85C935D355565AB636E9B9ACF427 , 0xE52B814EE54FB6881964268BA291D153 , 0x4B601D152BADE35AD2150714CBA7BA6D , 0xE8D15E56B62753826CC4D01FA36670E9 , 0x72BA4F4A2CAB0E97AEBFD26C831364D6 , 0x26217A3D94CF7974E2E1F4559613A146 , 0x7521F26E066D14A1D178C508E0420274 , 0xC6638B60FC4B029AA17F8C6C21A55477 , 0x8EEF99DD0A1BB49E9B141DD9FE4CE07F , 0x867873C7BE63D1438C0142B23CD2E4C3 , 0x0C46E434AF46CBA9C0FDD5E863276AAD , 0xD9C986CB6E62AFD6A30AD2CC56708769 , 0xF88223167D8D2DF63718206AB55B7733 , 0xFFA82503515FAA104DAC1DA3A55A3E66 , 0xA8460EAE897972839F549303C1313C86 , 0x23F7A3A4B7AFE92814514B6B394449E9 , 0x6269D29052CBC7D864CA7FFED63EF52C , 0xA09234EADDAE4D13B0D455DDEC82EF34 , 0x99BE5F362E13C953F96E244C6685D227 , 0x253356684D14D29A83B963E3D96B5321 , 0x692C5251CB80135261C061D4A7FD785D , 0x7CAB475888DBE78DDDD962A164A28652 , 0xB79A64733275F67DBCAC7DC86F0F53BE , 0x8F0D9FB3D330793850977FA6FD4CD52A , 0xD5D64C4F0FF25398FA6612C42C9C8DEF , 0x39012DED7CB3B43CFFA0784D91E3643C , 0xD7A6C411A764A5D8AF916A261509A938 );
Copy
5.30 ms (8.95%)
7
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
4.77 ms (8.06%)
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/019f84f4a39c7411a2f53617980b1037 "
"/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/818ae4dc4548981bd07a5d9ea5c7400b "
"/detail/0d802e870ab42dc8223c11ac4556564a "
"/detail/f233f6a71a7df85087f084fecf976916 "
"/detail/f96342b9ecca5a756a4c5395f9380f9e "
"/detail/31b727967c799898e91626e398062cc8 "
"/detail/a58a85c935d355565ab636e9b9acf427 "
"/detail/e52b814ee54fb6881964268ba291d153 "
"/detail/4b601d152bade35ad2150714cba7ba6d "
"/detail/e8d15e56b62753826cc4d01fa36670e9 "
"/detail/72ba4f4a2cab0e97aebfd26c831364d6 "
"/detail/26217a3d94cf7974e2e1f4559613a146 "
"/detail/7521f26e066d14a1d178c508e0420274 "
"/detail/c6638b60fc4b029aa17f8c6c21a55477 "
"/detail/8eef99dd0a1bb49e9b141dd9fe4ce07f "
"/detail/867873c7be63d1438c0142b23cd2e4c3 "
"/detail/0c46e434af46cba9c0fdd5e863276aad "
"/detail/d9c986cb6e62afd6a30ad2cc56708769 "
"/detail/f88223167d8d2df63718206ab55b7733 "
"/detail/ffa82503515faa104dac1da3a55a3e66 "
"/detail/a8460eae897972839f549303c1313c86 "
"/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/019f84f4a39c7411a2f53617980b1037' , '/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/818ae4dc4548981bd07a5d9ea5c7400b' , '/detail/0d802e870ab42dc8223c11ac4556564a' , '/detail/f233f6a71a7df85087f084fecf976916' , '/detail/f96342b9ecca5a756a4c5395f9380f9e' , '/detail/31b727967c799898e91626e398062cc8' , '/detail/a58a85c935d355565ab636e9b9acf427' , '/detail/e52b814ee54fb6881964268ba291d153' , '/detail/4b601d152bade35ad2150714cba7ba6d' , '/detail/e8d15e56b62753826cc4d01fa36670e9' , '/detail/72ba4f4a2cab0e97aebfd26c831364d6' , '/detail/26217a3d94cf7974e2e1f4559613a146' , '/detail/7521f26e066d14a1d178c508e0420274' , '/detail/c6638b60fc4b029aa17f8c6c21a55477' , '/detail/8eef99dd0a1bb49e9b141dd9fe4ce07f' , '/detail/867873c7be63d1438c0142b23cd2e4c3' , '/detail/0c46e434af46cba9c0fdd5e863276aad' , '/detail/d9c986cb6e62afd6a30ad2cc56708769' , '/detail/f88223167d8d2df63718206ab55b7733' , '/detail/ffa82503515faa104dac1da3a55a3e66' , '/detail/a8460eae897972839f549303c1313c86' , '/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
3.99 ms (6.75%)
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"ŠäÜEH˜\e Ðz]ž¥Ç@\v "
b"""
\r €.‡\n
´-È"<\x11 ¬EVVJ
"""
b"ò3ö§\x1A }øP‡ð„þÏ—i\x16 "
b"ùcB¹ìÊZujLS•ù8\x0F ž "
b"1·'–|y˜˜é\x16 &ã˜\x06 ,È "
b"¥Š…É5ÓUVZ¶6鹬ô' "
b"å+NåO¶ˆ\x19 d&‹¢‘ÑS "
b"K`\x1D\x15 +ãZÒ\x15\x07\x14 ˧ºm "
b"èÑ^V¶'S‚lÄÐ\x1F £fpé "
b"rºOJ,«\x0E —®¿Òlƒ\x13 dÖ "
b"&!z=”ÏytâáôU–\x13 ¡F "
b"u!òn\x06 m\x14 ¡ÑxÅ\x08 àB\x02 t "
b"Æc‹`üK\x02 š¡\x7F Œl!¥Tw "
b"""
Žï™Ý\n
\e ´ž›\x14\x1D ÙþLà\x7F
"""
b"†xsǾcÑCŒ\x01 B²<Òäà "
b"\f Fä4¯FË©ÀýÕèc'j "
b"""
ÙɆËnb¯Ö£\n
ÒÌVp‡i
"""
b"ø‚#\x16 }Ž-ö7\x18 jµ[w3 "
b"ÿ¨%\x03 Q_ª\x10 M¬\x1D £¥Z>f "
b"¨F\x0E ®‰yrƒŸT“\x03 Á1<† "
]
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 (0x818AE4DC4548981BD07A5D9EA5C7400B , 0x0D802E870AB42DC8223C11AC4556564A , 0xF233F6A71A7DF85087F084FECF976916 , 0xF96342B9ECCA5A756A4C5395F9380F9E , 0x31B727967C799898E91626E398062CC8 , 0xA58A85C935D355565AB636E9B9ACF427 , 0xE52B814EE54FB6881964268BA291D153 , 0x4B601D152BADE35AD2150714CBA7BA6D , 0xE8D15E56B62753826CC4D01FA36670E9 , 0x72BA4F4A2CAB0E97AEBFD26C831364D6 , 0x26217A3D94CF7974E2E1F4559613A146 , 0x7521F26E066D14A1D178C508E0420274 , 0xC6638B60FC4B029AA17F8C6C21A55477 , 0x8EEF99DD0A1BB49E9B141DD9FE4CE07F , 0x867873C7BE63D1438C0142B23CD2E4C3 , 0x0C46E434AF46CBA9C0FDD5E863276AAD , 0xD9C986CB6E62AFD6A30AD2CC56708769 , 0xF88223167D8D2DF63718206AB55B7733 , 0xFFA82503515FAA104DAC1DA3A55A3E66 , 0xA8460EAE897972839F549303C1313C86 ));
Copy
2.78 ms (4.70%)
4
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )) AND (sales_channel_id = ? )
Parameters :
[
b"ŠäÜEH˜\e Ðz]ž¥Ç@\v "
b"""
\r €.‡\n
´-È"<\x11 ¬EVVJ
"""
b"ò3ö§\x1A }øP‡ð„þÏ—i\x16 "
b"ùcB¹ìÊZujLS•ù8\x0F ž "
b"1·'–|y˜˜é\x16 &ã˜\x06 ,È "
b"¥Š…É5ÓUVZ¶6鹬ô' "
b"å+NåO¶ˆ\x19 d&‹¢‘ÑS "
b"K`\x1D\x15 +ãZÒ\x15\x07\x14 ˧ºm "
b"èÑ^V¶'S‚lÄÐ\x1F £fpé "
b"rºOJ,«\x0E —®¿Òlƒ\x13 dÖ "
b"&!z=”ÏytâáôU–\x13 ¡F "
b"u!òn\x06 m\x14 ¡ÑxÅ\x08 àB\x02 t "
b"Æc‹`üK\x02 š¡\x7F Œl!¥Tw "
b"""
Žï™Ý\n
\e ´ž›\x14\x1D ÙþLà\x7F
"""
b"†xsǾcÑCŒ\x01 B²<Òäà "
b"\f Fä4¯FË©ÀýÕèc'j "
b"""
ÙɆËnb¯Ö£\n
ÒÌVp‡i
"""
b"ø‚#\x16 }Ž-ö7\x18 jµ[w3 "
b"ÿ¨%\x03 Q_ª\x10 M¬\x1D £¥Z>f "
b"¨F\x0E ®‰yrƒŸT“\x03 Á1<† "
b"\x01 ¦Jœ&p•²ÇŠÿÞ“šà "
]
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (0x818AE4DC4548981BD07A5D9EA5C7400B , 0x0D802E870AB42DC8223C11AC4556564A , 0xF233F6A71A7DF85087F084FECF976916 , 0xF96342B9ECCA5A756A4C5395F9380F9E , 0x31B727967C799898E91626E398062CC8 , 0xA58A85C935D355565AB636E9B9ACF427 , 0xE52B814EE54FB6881964268BA291D153 , 0x4B601D152BADE35AD2150714CBA7BA6D , 0xE8D15E56B62753826CC4D01FA36670E9 , 0x72BA4F4A2CAB0E97AEBFD26C831364D6 , 0x26217A3D94CF7974E2E1F4559613A146 , 0x7521F26E066D14A1D178C508E0420274 , 0xC6638B60FC4B029AA17F8C6C21A55477 , 0x8EEF99DD0A1BB49E9B141DD9FE4CE07F , 0x867873C7BE63D1438C0142B23CD2E4C3 , 0x0C46E434AF46CBA9C0FDD5E863276AAD , 0xD9C986CB6E62AFD6A30AD2CC56708769 , 0xF88223167D8D2DF63718206AB55B7733 , 0xFFA82503515FAA104DAC1DA3A55A3E66 , 0xA8460EAE897972839F549303C1313C86 )) AND (sales_channel_id = 0x0190A64A9C267095B2C78AFFDE939AE0 );
Copy
1.22 ms (2.07%)
2
SELECT `delivery_time` . `id` as `delivery_time.id` , `delivery_time` . `min` as `delivery_time.min` , `delivery_time` . `max` as `delivery_time.max` , `delivery_time` . `unit` as `delivery_time.unit` , `delivery_time` . `created_at` as `delivery_time.createdAt` , `delivery_time` . `updated_at` as `delivery_time.updatedAt` , `delivery_time.translation.name` , `delivery_time.translation.name` as `delivery_time.name` , `delivery_time.translation.customFields` , `delivery_time.translation.customFields` as `delivery_time.customFields` FROM `delivery_time` LEFT JOIN (SELECT `delivery_time.translation` . `delivery_time_id` , `delivery_time.translation` . `name` as `delivery_time.translation.name` , `delivery_time.translation` . `custom_fields` as `delivery_time.translation.customFields` FROM `delivery_time_translation` `delivery_time.translation` WHERE `delivery_time.translation` . `language_id` = ? ) `delivery_time.delivery_time_translation` ON `delivery_time.delivery_time_translation` . `delivery_time_id` = `delivery_time` . `id` WHERE `delivery_time` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 ¥Ðº¥qh“?6:þÇ,\x02 "
]
SELECT `delivery_time` . `id` as `delivery_time.id` , `delivery_time` . `min` as `delivery_time.min` , `delivery_time` . `max` as `delivery_time.max` , `delivery_time` . `unit` as `delivery_time.unit` , `delivery_time` . `created_at` as `delivery_time.createdAt` , `delivery_time` . `updated_at` as `delivery_time.updatedAt` , `delivery_time.translation.name` , `delivery_time.translation.name` as `delivery_time.name` , `delivery_time.translation.customFields` , `delivery_time.translation.customFields` as `delivery_time.customFields` FROM `delivery_time` LEFT JOIN (SELECT `delivery_time.translation` . `delivery_time_id` , `delivery_time.translation` . `name` as `delivery_time.translation.name` , `delivery_time.translation` . `custom_fields` as `delivery_time.translation.customFields` FROM `delivery_time_translation` `delivery_time.translation` WHERE `delivery_time.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `delivery_time.delivery_time_translation` ON `delivery_time.delivery_time_translation` . `delivery_time_id` = `delivery_time` . `id` WHERE `delivery_time` . `id` IN (0x0190A5D0BAA57168933F363AFEC72C02 );
Copy
1.09 ms (1.85%)
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/Boerboom,%20Peter "
"/author/Boerboom,%20Peter "
"https://hauptbuchhandlung.staging.eurosoft.network/author/Boerboom,%20Peter "
"https://hauptbuchhandlung.staging.eurosoft.network//author/Boerboom,%20Peter "
"/author/Boerboom,%20Peter "
"//author/Boerboom,%20Peter "
"author/Boerboom,%20Peter "
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/Boerboom,%20Peter' , '/author/Boerboom,%20Peter' , 'https://hauptbuchhandlung.staging.eurosoft.network/author/Boerboom,%20Peter' , 'https://hauptbuchhandlung.staging.eurosoft.network//author/Boerboom,%20Peter' , '/author/Boerboom,%20Peter' , '//author/Boerboom,%20Peter' , 'author/Boerboom,%20Peter' ) AND `scop_platform_redirecter_redirect` . `enabled` = 1 AND (`scop_platform_redirecter_redirect` . `salesChannelId` = 0x01914A3133A37822896D0C70B2FD3B67 OR `scop_platform_redirecter_redirect` . `salesChannelId` < = > NULL )) LIMIT 1 ;
Copy
1.01 ms (1.71%)
2
SELECT `key` , `value` FROM `app_config`
SELECT `key` , `value` FROM `app_config` ;
Copy
0.94 ms (1.59%)
1
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = ?
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = 'de-DE' ;
Copy
0.87 ms (1.47%)
1
SELECT `country` . `id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country` . `id` = `country.salesChannels.mapping` . `country_id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping` . `sales_channel_id` = `country.salesChannels` . `id` WHERE (`country.salesChannels` . `id` = ? ) GROUP BY `country` . `id`
Parameters :
[
b"\x01 ‘J13£x"‰m\f p²ý;g "
]
SELECT `country` . `id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country` . `id` = `country.salesChannels.mapping` . `country_id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping` . `sales_channel_id` = `country.salesChannels` . `id` WHERE (`country.salesChannels` . `id` = 0x01914A3133A37822896D0C70B2FD3B67 ) GROUP BY `country` . `id` ;
Copy
0.84 ms (1.41%)
1
SELECT `plugin` . `id` as `plugin.id` , `plugin` . `base_class` as `plugin.baseClass` , `plugin` . `name` as `plugin.name` , `plugin` . `composer_name` as `plugin.composerName` , `plugin` . `autoload` as `plugin.autoload` , `plugin` . `active` as `plugin.active` , `plugin` . `managed_by_composer` as `plugin.managedByComposer` , `plugin` . `path` as `plugin.path` , `plugin` . `author` as `plugin.author` , `plugin` . `copyright` as `plugin.copyright` , `plugin` . `license` as `plugin.license` , `plugin` . `version` as `plugin.version` , `plugin` . `upgrade_version` as `plugin.upgradeVersion` , `plugin` . `installed_at` as `plugin.installedAt` , `plugin` . `upgraded_at` as `plugin.upgradedAt` , `plugin` . `icon` as `plugin.iconRaw` , `plugin` . `created_at` as `plugin.createdAt` , `plugin` . `updated_at` as `plugin.updatedAt` , `plugin.translation.label` , `plugin.translation.label` as `plugin.label` , `plugin.translation.description` , `plugin.translation.description` as `plugin.description` , `plugin.translation.manufacturerLink` , `plugin.translation.manufacturerLink` as `plugin.manufacturerLink` , `plugin.translation.supportLink` , `plugin.translation.supportLink` as `plugin.supportLink` , `plugin.translation.customFields` , `plugin.translation.customFields` as `plugin.customFields` FROM `plugin` LEFT JOIN (SELECT `plugin.translation` . `plugin_id` , `plugin.translation` . `label` as `plugin.translation.label` , `plugin.translation` . `description` as `plugin.translation.description` , `plugin.translation` . `manufacturer_link` as `plugin.translation.manufacturerLink` , `plugin.translation` . `support_link` as `plugin.translation.supportLink` , `plugin.translation` . `custom_fields` as `plugin.translation.customFields` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation` . `language_id` = ? ) `plugin.plugin_translation` ON `plugin.plugin_translation` . `plugin_id` = `plugin` . `id` WHERE (`plugin` . `name` = ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
"esMetaCatalog6 "
]
SELECT `plugin` . `id` as `plugin.id` , `plugin` . `base_class` as `plugin.baseClass` , `plugin` . `name` as `plugin.name` , `plugin` . `composer_name` as `plugin.composerName` , `plugin` . `autoload` as `plugin.autoload` , `plugin` . `active` as `plugin.active` , `plugin` . `managed_by_composer` as `plugin.managedByComposer` , `plugin` . `path` as `plugin.path` , `plugin` . `author` as `plugin.author` , `plugin` . `copyright` as `plugin.copyright` , `plugin` . `license` as `plugin.license` , `plugin` . `version` as `plugin.version` , `plugin` . `upgrade_version` as `plugin.upgradeVersion` , `plugin` . `installed_at` as `plugin.installedAt` , `plugin` . `upgraded_at` as `plugin.upgradedAt` , `plugin` . `icon` as `plugin.iconRaw` , `plugin` . `created_at` as `plugin.createdAt` , `plugin` . `updated_at` as `plugin.updatedAt` , `plugin.translation.label` , `plugin.translation.label` as `plugin.label` , `plugin.translation.description` , `plugin.translation.description` as `plugin.description` , `plugin.translation.manufacturerLink` , `plugin.translation.manufacturerLink` as `plugin.manufacturerLink` , `plugin.translation.supportLink` , `plugin.translation.supportLink` as `plugin.supportLink` , `plugin.translation.customFields` , `plugin.translation.customFields` as `plugin.customFields` FROM `plugin` LEFT JOIN (SELECT `plugin.translation` . `plugin_id` , `plugin.translation` . `label` as `plugin.translation.label` , `plugin.translation` . `description` as `plugin.translation.description` , `plugin.translation` . `manufacturer_link` as `plugin.translation.manufacturerLink` , `plugin.translation` . `support_link` as `plugin.translation.supportLink` , `plugin.translation` . `custom_fields` as `plugin.translation.customFields` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `plugin.plugin_translation` ON `plugin.plugin_translation` . `plugin_id` = `plugin` . `id` WHERE (`plugin` . `name` = 'esMetaCatalog6' );
Copy
0.83 ms (1.40%)
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.79 ms (1.33%)
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.76 ms (1.29%)
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.76 ms (1.28%)
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 ŸF\x7F #ˆpá͟@\f š1§ "
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 , 0x019F467F238870C3A1CD9F400C9A31A7 , 0x0190A5D0BA7A733A8B556FC290A8FC47 , 0x0190A5D0BAC7736CB4C7E4E63A7F6A37 , 0x0190A5D0F8E1705185B7C4CF43AA1E09 , 0x01919949597F7CF9952F88D3C9922182 , 0x0190A5D0BB6473948636854C684B9FD9 , 0x0197F925678E7208AE78E078763952CE );
Copy
0.75 ms (1.26%)
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-10-01T23:35:39+00:00' ) OR (`show_until` > `updated_at` AND `show_until` < '2026-10-01T23:35:39+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-10-01T23:35:39+00:00' ) OR (`show_until` > `updated_at` AND `show_until` < '2026-10-01T23:35:39+00:00' )) AND `active` = '1' ; ;
Copy
0.71 ms (1.20%)
1
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.translation.name` , `category.translation.name` as `category.name` , `category.translation.breadcrumb` , `category.translation.breadcrumb` as `category.breadcrumb` , `category.translation.slotConfig` , `category.translation.slotConfig` as `category.slotConfig` , `category.translation.linkType` , `category.translation.linkType` as `category.linkType` , `category.translation.internalLink` , `category.translation.internalLink` as `category.internalLink` , `category.translation.externalLink` , `category.translation.externalLink` as `category.externalLink` , `category.translation.linkNewTab` , `category.translation.linkNewTab` as `category.linkNewTab` , `category.translation.description` , `category.translation.description` as `category.description` , `category.translation.metaTitle` , `category.translation.metaTitle` as `category.metaTitle` , `category.translation.metaDescription` , `category.translation.metaDescription` as `category.metaDescription` , `category.translation.keywords` , `category.translation.keywords` as `category.keywords` , `category.translation.customFields` , `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation` . `category_id` , `category.translation` . `category_version_id` , `category.translation` . `breadcrumb` as `category.translation.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation` . `slot_config` as `category.translation.slotConfig` , `category.translation` . `link_type` as `category.translation.linkType` , `category.translation` . `internal_link` as `category.translation.internalLink` , `category.translation` . `external_link` as `category.translation.externalLink` , `category.translation` . `link_new_tab` as `category.translation.linkNewTab` , `category.translation` . `description` as `category.translation.description` , `category.translation` . `meta_title` as `category.translation.metaTitle` , `category.translation` . `meta_description` as `category.translation.metaDescription` , `category.translation` . `keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation` . `language_id` = ? ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . `category_version_id` = `category` . `version_id` WHERE (`category` . `version_id` = ? ) AND (`category` . `id` IN (? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4% "
b"\x01 ‘C\¬t®Ö_œêdÎy "
]
SELECT
`category` . `id` as `category.id` ,
`category` . `version_id` as `category.versionId` ,
`category` . `parent_id` as `category.parentId` ,
`category` . `parent_version_id` as `category.parentVersionId` ,
`category` . `after_category_id` as `category.afterCategoryId` ,
`category` . `after_category_version_id` as `category.afterCategoryVersionId` ,
`category` . `media_id` as `category.mediaId` ,
`category` . `display_nested_products` as `category.displayNestedProducts` ,
`category` . `auto_increment` as `category.autoIncrement` ,
`category` . `level` as `category.level` ,
`category` . `path` as `category.path` ,
`category` . `child_count` as `category.childCount` ,
`category` . `type` as `category.type` ,
`category` . `product_assignment_type` as `category.productAssignmentType` ,
`category` . `visible` as `category.visible` ,
`category` . `active` as `category.active` ,
`category` . `cms_page_id` as `category.cmsPageId` ,
`category` . `cms_page_version_id` as `category.cmsPageVersionId` ,
`category` . `product_stream_id` as `category.productStreamId` ,
`category` . `custom_entity_type_id` as `category.customEntityTypeId` ,
`category` . `created_at` as `category.createdAt` ,
`category` . `updated_at` as `category.updatedAt` ,
`category.translation.name` ,
`category.translation.name` as `category.name` ,
`category.translation.breadcrumb` ,
`category.translation.breadcrumb` as `category.breadcrumb` ,
`category.translation.slotConfig` ,
`category.translation.slotConfig` as `category.slotConfig` ,
`category.translation.linkType` ,
`category.translation.linkType` as `category.linkType` ,
`category.translation.internalLink` ,
`category.translation.internalLink` as `category.internalLink` ,
`category.translation.externalLink` ,
`category.translation.externalLink` as `category.externalLink` ,
`category.translation.linkNewTab` ,
`category.translation.linkNewTab` as `category.linkNewTab` ,
`category.translation.description` ,
`category.translation.description` as `category.description` ,
`category.translation.metaTitle` ,
`category.translation.metaTitle` as `category.metaTitle` ,
`category.translation.metaDescription` ,
`category.translation.metaDescription` as `category.metaDescription` ,
`category.translation.keywords` ,
`category.translation.keywords` as `category.keywords` ,
`category.translation.customFields` ,
`category.translation.customFields` as `category.customFields`
FROM
`category`
LEFT JOIN (
SELECT
`category.translation` . `category_id` ,
`category.translation` . `category_version_id` ,
`category.translation` . `breadcrumb` as `category.translation.breadcrumb` ,
`category.translation` . `name` as `category.translation.name` ,
`category.translation` . `custom_fields` as `category.translation.customFields` ,
`category.translation` . `slot_config` as `category.translation.slotConfig` ,
`category.translation` . `link_type` as `category.translation.linkType` ,
`category.translation` . `internal_link` as `category.translation.internalLink` ,
`category.translation` . `external_link` as `category.translation.externalLink` ,
`category.translation` . `link_new_tab` as `category.translation.linkNewTab` ,
`category.translation` . `description` as `category.translation.description` ,
`category.translation` . `meta_title` as `category.translation.metaTitle` ,
`category.translation` . `meta_description` as `category.translation.metaDescription` ,
`category.translation` . `keywords` as `category.translation.keywords`
FROM
`category_translation` `category.translation`
WHERE
`category.translation` . `language_id` = ?
) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id`
AND `category.category_translation` . `category_version_id` = `category` . `version_id`
WHERE
(`category` . `version_id` = ? )
AND (
`category` . `id` IN (? )
)
Copy
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.translation.name` , `category.translation.name` as `category.name` , `category.translation.breadcrumb` , `category.translation.breadcrumb` as `category.breadcrumb` , `category.translation.slotConfig` , `category.translation.slotConfig` as `category.slotConfig` , `category.translation.linkType` , `category.translation.linkType` as `category.linkType` , `category.translation.internalLink` , `category.translation.internalLink` as `category.internalLink` , `category.translation.externalLink` , `category.translation.externalLink` as `category.externalLink` , `category.translation.linkNewTab` , `category.translation.linkNewTab` as `category.linkNewTab` , `category.translation.description` , `category.translation.description` as `category.description` , `category.translation.metaTitle` , `category.translation.metaTitle` as `category.metaTitle` , `category.translation.metaDescription` , `category.translation.metaDescription` as `category.metaDescription` , `category.translation.keywords` , `category.translation.keywords` as `category.keywords` , `category.translation.customFields` , `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation` . `category_id` , `category.translation` . `category_version_id` , `category.translation` . `breadcrumb` as `category.translation.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation` . `slot_config` as `category.translation.slotConfig` , `category.translation` . `link_type` as `category.translation.linkType` , `category.translation` . `internal_link` as `category.translation.internalLink` , `category.translation` . `external_link` as `category.translation.externalLink` , `category.translation` . `link_new_tab` as `category.translation.linkNewTab` , `category.translation` . `description` as `category.translation.description` , `category.translation` . `meta_title` as `category.translation.metaTitle` , `category.translation` . `meta_description` as `category.translation.metaDescription` , `category.translation` . `keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . `category_version_id` = `category` . `version_id` WHERE (`category` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (`category` . `id` IN (0x01918E435CAC74AE90D65F9CEA64CE79 ));
Copy
0.71 ms (1.20%)
4
"START TRANSACTION"
"START TRANSACTION" ;
Copy
0.70 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.66 ms (1.11%)
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.57 ms (0.97%)
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/Boerboom,%20Peter "
"author/Boerboom,%20Peter/ "
]
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/Boerboom,%20Peter' OR seo_path_info = 'author/Boerboom,%20Peter/' ));
Copy
0.56 ms (0.95%)
1
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ? ) AND (token = ? ) LIMIT 1
Parameters :
[
b"\x01 ‘J13£x"‰m\f p²ý;g "
"76SghzW5JxTiSuFcYsc3KlNkHUS9KYlr "
]
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0x01914A3133A37822896D0C70B2FD3B67 ) AND (token = '76SghzW5JxTiSuFcYsc3KlNkHUS9KYlr' ) LIMIT 1 ;
Copy
0.53 ms (0.90%)
1
SELECT `country` . `id` as `country.id` , `country` . `iso` as `country.iso` , `country` . `position` as `country.position` , `country` . `active` as `country.active` , `country` . `shipping_available` as `country.shippingAvailable` , `country` . `iso3` as `country.iso3` , `country` . `display_state_in_registration` as `country.displayStateInRegistration` , `country` . `force_state_in_registration` as `country.forceStateInRegistration` , `country` . `check_vat_id_pattern` as `country.checkVatIdPattern` , `country` . `vat_id_required` as `country.vatIdRequired` , `country` . `vat_id_pattern` as `country.vatIdPattern` , `country` . `customer_tax` as `country.customerTax` , `country` . `company_tax` as `country.companyTax` , `country` . `postal_code_required` as `country.postalCodeRequired` , `country` . `check_postal_code_pattern` as `country.checkPostalCodePattern` , `country` . `check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern` , `country` . `advanced_postal_code_pattern` as `country.advancedPostalCodePattern` , `country` . `default_postal_code_pattern` as `country.defaultPostalCodePattern` , `country` . `is_eu` as `country.isEu` , `country` . `created_at` as `country.createdAt` , `country` . `updated_at` as `country.updatedAt` , `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.51 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.51 ms (0.86%)
1
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = ?
Parameters :
[
"76SghzW5JxTiSuFcYsc3KlNkHUS9KYlr "
]
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = '76SghzW5JxTiSuFcYsc3KlNkHUS9KYlr' ;
Copy
0.50 ms (0.85%)
4
"COMMIT"
0.50 ms (0.84%)
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.47 ms (0.79%)
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.45 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.44 ms (0.74%)
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.43 ms (0.73%)
1
SELECT `unit` . `id` as `unit.id` , `unit` . `created_at` as `unit.createdAt` , `unit` . `updated_at` as `unit.updatedAt` , `unit.translation.shortCode` , `unit.translation.shortCode` as `unit.shortCode` , `unit.translation.name` , `unit.translation.name` as `unit.name` , `unit.translation.customFields` , `unit.translation.customFields` as `unit.customFields` FROM `unit` LEFT JOIN (SELECT `unit.translation` . `unit_id` , `unit.translation` . `short_code` as `unit.translation.shortCode` , `unit.translation` . `name` as `unit.translation.name` , `unit.translation` . `custom_fields` as `unit.translation.customFields` FROM `unit_translation` `unit.translation` WHERE `unit.translation` . `language_id` = ? ) `unit.unit_translation` ON `unit.unit_translation` . `unit_id` = `unit` . `id`
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `unit` . `id` as `unit.id` , `unit` . `created_at` as `unit.createdAt` , `unit` . `updated_at` as `unit.updatedAt` , `unit.translation.shortCode` , `unit.translation.shortCode` as `unit.shortCode` , `unit.translation.name` , `unit.translation.name` as `unit.name` , `unit.translation.customFields` , `unit.translation.customFields` as `unit.customFields` FROM `unit` LEFT JOIN (SELECT `unit.translation` . `unit_id` , `unit.translation` . `short_code` as `unit.translation.shortCode` , `unit.translation` . `name` as `unit.translation.name` , `unit.translation` . `custom_fields` as `unit.translation.customFields` FROM `unit_translation` `unit.translation` WHERE `unit.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `unit.unit_translation` ON `unit.unit_translation` . `unit_id` = `unit` . `id` ;
Copy
0.42 ms (0.72%)
2
SELECT LOWER (HEX (parent_id )) FROM language WHERE id = ?
Parameters :
[
"0190a5d21558701cb17a1f89991d17e2 "
]
SELECT LOWER (HEX (parent_id )) FROM language WHERE id = '0190a5d21558701cb17a1f89991d17e2' ;
Copy
0.42 ms (0.70%)
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.64%)
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/Boerboom,%20Peter "
]
SELECT path_info pathInfo , seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (sales_channel_id = 0x01914A3133A37822896D0C70B2FD3B67 ) AND (path_info = '/author/Boerboom,%20Peter' ) AND (is_canonical = 1 ) LIMIT 1 ;
Copy
0.36 ms (0.61%)
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.32 ms (0.55%)
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.31 ms (0.52%)
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.29 ms (0.49%)
1
SELECT path FROM category WHERE id = ?
Parameters :
[
b"\x01 ‘C\¬t®Ö_œêdÎy "
]
SELECT path FROM category WHERE id = 0x01918E435CAC74AE90D65F9CEA64CE79 ;
Copy
0.29 ms (0.48%)
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.27 ms (0.46%)
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.26 ms (0.44%)
1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1 ;
Copy
0.25 ms (0.41%)
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.23 ms (0.39%)
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.22 ms (0.38%)
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.20 ms (0.34%)
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.19 ms (0.31%)
1
SET @@group_concat_max_len = CAST (IF (@@group_concat_max_len > 320000 , @@group_concat_max_len , 320000 ) AS UNSIGNED ); SET sql_mode = (SELECT REPLACE (@@sql_mode , 'ONLY_FULL_GROUP_BY' , '' ))
SET @@group_concat_max_len = CAST (IF (@@group_concat_max_len > 320000 , @@group_concat_max_len , 320000 ) AS UNSIGNED ); SET sql_mode = (SELECT REPLACE (@@sql_mode , 'ONLY_FULL_GROUP_BY' , '' ));
Copy