Query Metrics
74
Database Queries
57
Different statements
63.98 ms
Query time
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
7.68 ms (12.01%) |
1 |
# base-context-factory::taxes::association::rules::read SELECT `tax_rule`.`id` AS `tax_rule.id`, `tax_rule`.`tax_rule_type_id` AS `tax_rule.taxRuleTypeId`, `tax_rule`.`country_id` AS `tax_rule.countryId`, `tax_rule`.`tax_rate` AS `tax_rule.taxRate`, `tax_rule`.`data` AS `tax_rule.data`, `tax_rule`.`tax_id` AS `tax_rule.taxId`, `tax_rule`.`active_from` AS `tax_rule.activeFrom`, `tax_rule.type`.`id` AS `tax_rule.type.id`, `tax_rule.type`.`technical_name` AS `tax_rule.type.technicalName`, `tax_rule.type`.`position` AS `tax_rule.type.position`, `tax_rule.type`.`created_at` AS `tax_rule.type.createdAt`, `tax_rule.type`.`updated_at` AS `tax_rule.type.updatedAt`, `tax_rule.type.translation.typeName`, COALESCE(`tax_rule.type.translation.typeName`,`tax_rule.type.translation.typeName`) AS `tax_rule.type.typeName`, `tax_rule.type.translation.createdAt`, `tax_rule.type.translation.updatedAt`, `tax_rule.type.translation.taxRuleTypeId`, `tax_rule.type.translation.languageId`, `tax_rule`.`created_at` AS `tax_rule.createdAt`, `tax_rule`.`updated_at` AS `tax_rule.updatedAt` FROM `tax_rule` LEFT JOIN `tax_rule_type` `tax_rule.type` ON `tax_rule`.`tax_rule_type_id` = `tax_rule.type`.`id` LEFT JOIN (SELECT `tax_rule.type.translation`.tax_rule_type_id, `tax_rule.type.translation`.type_name AS `tax_rule.type.translation.typeName`, `tax_rule.type.translation`.created_at AS `tax_rule.type.translation.createdAt`, `tax_rule.type.translation`.updated_at AS `tax_rule.type.translation.updatedAt`, `tax_rule.type.translation`.tax_rule_type_id AS `tax_rule.type.translation.taxRuleTypeId`, `tax_rule.type.translation`.language_id AS `tax_rule.type.translation.languageId` FROM `tax_rule_type_translation` `tax_rule.type.translation` WHERE `tax_rule.type.translation`.language_id = ?) `tax_rule.type.tax_rule_type_translation` ON `tax_rule.type.tax_rule_type_translation`.`tax_rule_type_id` = `tax_rule.type`.`id` WHERE (`tax_rule`.`tax_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x00\x00åÒøŽM §5\x12ÁÕ\f…Ã" b"\x00±ñ´L\nO2´ùV]·\t4m" b"\x00╗ñÄD¥Kçò\x7F¢\vÉZ\x05Ç" b"\x00êw\r°¥GλÝhi\x03|Jˆ" b"\x01\x02§î³`NÉ®QB8ìe}p" b"\x01\x1F80ÇÃIOÉÓTé|\x15/¸" b"\x01X[³y\x1F@Ãê\x0Eü┬_ã5¸" b"\x01q›A—ÑD§®½IÔ¨¹2*" b"\x01¦ÔÉ%YMe¥Éªôض\x08æ" b"\x02\fÇ‹’%GÖ·)rÚ ÄšÀ" b"\x02Aé[Ûâ@3ˆg\x13Ua\x02ƒ]" b"\x02¬\x7FyÙ\x07E\x00“‹îu\x13~R" b"\x02²‚\x02®•DÜ™'ss8ñÖ\" b"\x02¹áˆ6\x10I®ƒ"\x1Asiª8—" b"\x03üêÌÀ“J\x02µÃ%õÊ\rÎ\x1D" b"\x04\x0EòŽÆ&E!€…ˆ¹\t\x01\x1C¶" b"\x04 â\x00'ÆHìì¯└×&}Å\x13" b""" \x04Iæ³´}F\n ¢Q¶0¾\x06\fc """ b"\x04▄Z\tR¿E╦ÖØ╝Y\x0F╩\x16*" b"\x05»wÉ▄WD¼ûµo-´ÖGÔ" b"\x05┬_Â█ÚJtôÞ60\x02AúÉ" b"\x05è\x06<\x08–G[Ÿç4•îG\x18\x1F" b"\x06E\x00Ê \x0EI”§ä;$ž¸£›" b"\x06JT3t©E\x12˜Óü£Uy\rB" b"\x06k¡\x16Ô&AO¬•~\x7FÖátÌ" b"\x06u¶Ý*\x04D\x00¦}`‚®\x18“" b"\x06uû,›pO‚¹Q\x1Fì#*Є" b"\x06…¶x¹™B¢‚žô%‹ƒÌ¬" b"\x07\x08&Šƒ÷Fšž<¥åý\x04n\x11" b"\x07\x161\x1Fù)D\e½WŠá˜2}—" b"\x07Jþͼ\rM\x07¥\x14“\x1D…¥Œ“" b"\x07Øn\fò©N\x1EìDS╣\x008bµ" b"\x08¦™H[ÄL\f¸*ˆí9ø'Ú" b"\x08Ð`ÆWQNìç\x06\tÅz=`╔" b"\x08ÕÊT1¹I¬ OWÌ@=´\x10" b"\tñ†q\x12oCr·œ&ï`©\x17å" b""" \n +\x10½³·Lù¹i…²ûñÜß """ b""" \n ;\x02‚´“A\x18‹\x1E¢“?sVŠ """ b""" \n >\x11C>ÍD‡ˆ6\x12\x1D¼nƒŸ """ b"\v+$^/╝Kö┘¡%GÉ┤¢" b"\v0P1nBsžŠEÇ?Õ8…" b"\v\5t│ÁGv¿a×Z\x15àØ\x1C" b"\vÔÏ@ù´Ln‡J\t€Âƒª²" b"\v¹D"ùDKöÂsZg/Øè\v" b""" \f\x1D\n €ö\eIDšÀ\x1C;`i¾¿ """ b"\fAä¯çrOÜ…\x18ç\fOT“Ò" b"\f¯\x041\x1F\x1FFkØ░z¸×\x1CLx" b"\r%|ûIé@ÖÅ3d_\x079ñ┐" b"\r+žâ’*J3¸fL?s<j[" b"\r5Q║ÃANòƒãü¶\x10ÿÜs" b"\rW!ê2\x12DÚªÝc½L\x1D™r" b"\r┬\x1FÅR]@«àp┬╩óí?Â" b"\ràP™(¾J;Ÿ{…¼yºŽº" b"\ráÚ\x03|0AÂ’Ë\x18;\x02ú¥ü" b"\x0E\x02Äý*ÇGb«^Ÿ\x19¡†è¼" b"\x0E†QJ\x10\x15OM„ŸüP¢Òòz" b"\x0EËh¡ì‡F\tŒj75\eŒDâ" b"\x0E¦þôª5@_Ø╩▒▄╝Z,º" b"\x0F\x11\x03à|ÄI1ˆ*¿\x12zB55" b"\x0F>=D*\x1EK\x04»«e °É\rû" b"\x0FC‹4MÒL\x06†Äî \x03X2\t" b"\x0F╝ÿù\x171HQôøü(½╠¯©" b"\x10äÉÁzoO^áæ│XÀ é\x06" b"\x10”P\x1A-¯B³¯“÷è²-Þ2" b"\x11òös│ÏF[┐\x02\x1CÚ┌ÒÅ÷" b"\x11╝º\x12v>FHÅ<6¶ã┌9q" b"\x11ÝA®\x08·Jõºuÿu]ŠŒå" b"\x11åLœCoB_‚FlTp"´\x0F" b"\x12_FÉÈOG6╣Í╬╝┤!Xv" b"\x12zidÅQJÁ«ÀL╗ºL│f" b"\x12™@òº„@•Ÿ¹ó`µ£5" b"\x12¡§Ëñ\x1EEk¸üÛ+\x7FòÏê" b"\x12ÀܨbŠOÝ¢6…k®“¯·" b"\x12Ã!ìÍ\x05B!ºÃ\v4¢¬>▀" b"\x12Êϧí¿D9±ªçˆÔ<\x1A?" b"\x12╦F!×Q@┤ô\eØóL¬|F" b"\x12áäYiÿD?Œ1ƒsÛ>ï\x01" b"\x136m\x7F5ØN ‹(sO\x06ó«ö" b"\x13ïŃĀGp“Vr;ú¡õs" b"\x14\x018¶ÇiM5 ²YÒ+J¢¯" b"\x14ÔÓZaÑH\x1F‚WygKÛ‡`" b"\x14▄Ë\x0FÅ\x17Aþ╣ñ÷Y\x15\x01<=" b"\x15\x1Fã®äÕDçŠæ%ZÕ|ª)" b"\x15³âfgOL\x0E /Ô×\t…\x02ü" b"\x16\x12E„,(OØ•'QËs\/¦" b"\x168f•V•DG°Y9ü\x11x€Ú" b"\x16…üʈaH@–×Ü]„Ô¾Ú" b"\x16ýk†ÎÌC\x03‰kÍ©!\x18JÝ" b"\x17\t¤B\x19…Lº›üà\t\x17T\x16s" b"\x17\vœ‚\v@Ï\x1DÂx.6Iå" b""" \x18\n \x10$ÚiF€¶ª"[R¥A© """ b"\x18\x17\x15Ú¨'B^€\x01ÎÕç\x1FV\x7F" b"\x18\x1FóŠü\x1FDQ¥!u›DB›\r" b"\x18"FÊÈP@ÔžEX‘{Žšî" b"\x189¾˜hßK\x02¬d¤;¨uÙ\x1C" b"\x18W߈P¿FŒ¤³\x1F»ÿ‹J\n" b"\x18fs’æEFK…˜;¶\x06ÖÒ‘" b"\x18¦ªã¿†B@ˆÌ(PŒÃ³A" b"\x19A▓9┌µMRìòÀ7²MGI" b"\x1A$ÇCB”@úƒF\x1Cõžêñö" b"\x1Ar\x0Erh\x15Mò›¯¹Ëê0~ƒ" b"\x1AÅ Éb\x06O▄ïª/{iÂxù" b"\x1A³\x06\e‰ŒB\x01£\x19"l\x12è‹ý" b"\e+Úf2ÅANêN\x19\x1A▄┐█║" b"\ef,bÖqA‘ž¶ZMWµII" b"\el\tZ€\x04MMˆÐ¾ÆôbI\x01" b"\e˜7•ˆi@N¤õßœ_¨ß" b"\e¯÷?Ÿ¾Ióœ2®\x05MŠÓ\x1E" b"\e¦¿/tXN÷Ø\x04¶ÎUOk)" b"\x1C┐%*:¬O\x1FÀì[Uù\x0E-\x7F" b"\x1CÊk^Z5Jq˜¥1ãz,Y"" b"\x1D\x16Ñ░È«J├âaC7ì╩╠Æ" b"\x1DM¿æcZA¿®r™ø‚ùK" b"\x1D}˜]…ÓNæ°ù÷‰…NŠ\x1C" b"\x1D®~P@"KÕüiÏ\v─ܳB" b"\x1D¬Ö$ÅŠHä\x00ÅéJ\fx>" b"\x1EN\x13\x06Q©G\v‡Çß$!Ÿs×" b"\x1Ez├ÓÀÅB\x19╗æ³═}:░È" b"\x1E½Íá©ZMh™ø±1\x13¾Û," b"\x1FÇ#S\x01C└é³2û\x12‗\x1DÉ" b"\x1FÜ\x0F\-ÈE;‹\x1D£xã\x17gÃ" b" %(¿Ø╦@ø½▄ôÂ1║D" b" 1«T`2A䦰s¿`lÄ’" b" 7ÚÃ7{IqŒÁ\x16®ìÄG\x07" b" b®¨Æ/O›“‰Â-¹\x1Ajæ" b" dr´@XDò¹½ÆŒïmç\v" b" š ²=CFº™·Â«ú?&ë" b" ¡ÿ}û‚M^¢š–S\x08)@ü" b" ç\x16Ée–MAš\x03[‰‚‘aP" b"!\x18o¯GžL6ŽÃÇR\tìc\x1C" b"!\x19ëæ\x11¥D1À\rÐÅÎ(á" b"!\x1A\tß\e¬EA•-s\x19ZÀ.(" b"!}\x18sJàFf¥+ Î\rïx&" b"!~:½▓nMeìwaë¡X└┌" b"!²|å\x7F#Hú¨AhÓo¸\x19\x08" b""²c@,gM¸X6?Ó¸mö" b""ÏA¶û›B˜”m\x07Ps;p\x0F" b""ï&xc\x15JN°ð…ºB•¾˜" b"#yðFË|KÀ”×\x04¡nßšP" b"#«ò£»o@\x00°\x05@¯_Ôí\x12" b"#¯3ŠÅºO$‡Oë\x10™Ô\x08" b"$-\x00\x11y»Hµâ~▓\x1Fü╗·h" b"$ÑYR—SJªºÀ#²›C$‹" b"$¨A¿äwDä╣Eì°å)¿Ô" b"%/2š‰¥@N¯mLàV°œ\f" b"%NM\x1CZZF§ QuÌwIæ-" b"&MÄK|ÄH\x12‰‹\x0Fm–b®¾" b"&T}b¬`CwÇÔ2ü;╬ıB" b"&åÇ│YÝFìÜ┘O³RÇô," b"&¡]aÈcK\f–\x01YC·Á}©" b"&®ýï½WJ»▒║îÉÌzÙì" b"&ää夦C:¿n,×Ùóã"" b"'\t^ç¡G;®‘%BÛ[s²" b"'l¨ê†‹G>¸\x0Ed¾Ú\x1D—Z" b"'}‡Ü•Ä@Ë•Í3\x13Š\x18ÏK" b"'ñ%e\x0E■A╔è0\x14FüBt\x05" b"'ã\x02 "ÅG®àHÅ#©╬Õ" b"'ó¥ã\x13 @Æš®4YÚ,Aþ" b"(¾j╦jý@┬üAÅo\x140─\x1D" b")@ÜײQH\t•ÒéãÜ‹\x1F–" b")yèæ\x1CêDšˆê-ûÿÖ¾Ñ" b")ÖÀ\hbF¸ª║hìÃÅ░C" b")¼ÔwÖ\x12M§‚RB#Óï¢\v" b")ëÆ:p!A²…gÂE<\rOH" b"*\x16-+ŒÐHÙ¾y~ól\x05eÀ" b"*K è\x00ÝIVºˆ½•\\x01 “" b"*Mö¢]4G*›6áÓ[í¦+" b"*^\rú\fÚ@\x0EµW6,Õó£X" b"*›®\ÅüJK‡è‰\f\x01\x1CÓ*" b"*ó€ÃPDA,¹G!«H½UÊ" b"+¡\x06éŒUMׯ^3ÿ`+§‰" b"+³@f9òH#ž¿H¨‰˜¬K" b""" +ëim\n ¢JÖ‡wßáX.\fã """ b",\r³l[zL╗Åþ°§\x13å░\x1F" b",?óêK\x14MH¿«¢!Й“”" b",{cpŠÁG@Žiþ\x15Ž‹\x10Ü" b",|G¾†MO\x15Ÿ&áïT™+‘" b",~ÔÄÄÇE\x12¨–4˽€ž‘" b".\rÞyžÔAõ·ûap.Ï)M" b".Už·Â†M5½"ÚW²¸\x07Â" b".V÷■f\x17Iq£F¥µìt¨¥" b".€Ñ!”àB\x1D¸ºOÿ\x1E¾" b".ÎT>┐│MBæ«■ëðì¢\x08" b"/\x1EÓÄÄèK\x07”S\x1DX£³\x10À" b"/t3¹\x19SEXŠRõr¯\x12\e"" b""" /Î\n õP…@P‰™I\x1A-Én """ b"0/sLv└L▓│Æ=┴É▀#\x12" b"03V,ª\x12H,¾#\r\x12¬¦zx" b"0;ð\x01Ð\x1EJÉ ïã$E¡‡\x11" b"0Ít\x1ENs@бգ˜´“\x00j" b"1B)mØ[B┬▒çYd╚0-¶" b"1jìé˜\x04DκÄ0…\x7F†gö" b"1±;¾F±Nš‰RÞ¨§:&\x1C" b"1Ù3\x02ˆ•KŠŸÂ€"% r\r" b"1Ý@\x15\vVD¿³8\x19u$³åŠ" b"1ýÑlÆUKqíÖìï┤ÿñy" b"2\r─╬ÿÿBÌá½tЪìÿØ" b""" 29L\n #£@Ò«é1žŒ=€2 """ b"2J\x03▓#RHLìê«z§ãM7" b"2h[æP,K3ƒ\x100ïpyF" b"2jÄÙ*‚D ³nâ$”x—€" b"2╬ô°ØàOãéö|Õ±r┐Î" b"2ÛJ}ÎwJÁ†\x18 y¦ôÏÎ" b"2ä\téÍ‚F˜ŠàÎ]8ûöA" b"3*†±’9M9¾|œ=úîÏB" b"34\x10©~òOQ‡_>\x7Fé:h´" b"3G‹\x16»ƒK\x04·Å‡óš\x03)®" b"3LŠ+Þ&O÷±nµw½\eí[" b"3´Ái┴±AÝ¿9ùóº╝ÛØ" b"3þ@LÐuG’»Äñb¦~#ô" b"4\x05ê$2┘Gü¿╠©!n7¾" b"4\x07\x00¢\x02¶G›0\x03\x19\x1Aú\x13l" b"4\x1FìÚíºH#¸\x15¨ø4÷Xð" b"4!îKŸšAÌ·t-ò\x02D\v\x17" b"4R>’4pHøªaÄ3ò¹7" b"4¾ûÊh_J2†® o–ÂT\x07" b"4îä\x19¼êHE»\x13‰/j˜\x14M" b"5?zÓi═K\f▓D╠¸ü\x01Ô®" b"5Dr\x05æxC±ì~\x13\eW\x04u\t" b"5[\ÄÅLG]▓ðõ\t×\x14Êð" b"5Ò€~äY@\x1Fƒ¼-#2Ç'â" b"5òÕ:\x1C\x1CM\¬´>€ùaËr" b"6\x0FÌmýöEÜ®ÞE\rcÔÇê" b"6\x16ë›ÄÑLx·\x13ˆ\t5uõv" b"6c3˜5ÜF0·\x1D†\x05Ä\x02íR" b"6p±ü¡yI┐£╣\x03f»³G\x05" b"6¯ÂDì‡O>±ÄѾE\x0Eñ2" b"6ÌGBãÎJ(¢m„ Uï~K" b"74•4\x13JNŽ†“{²¹ˆè," b"7^é‚’žDÒ ‡@ #K·ä" b"7šwÖ—RAµŸž÷>ºhZï" b"7└Gßı1Iü▓]ÑѼ=\x00ó" b"7ô}F$^@}µBfÊ\x06Ôv{" b"8n£Ø▒ÂE+ø½Áà\x06X]þ" b"8óh¡~)@þ│\x12%ûwïì\x19" b"8Ü\x16f§lO…„œƒ,¹ùïm" b"8è'ª¥†E[“\x0EMܖɆ\x06" b"8ÿ¯W#‚Gì¨"®™jÝ|7" b"97JålZAò®2P›ò9ß÷" b"9@¾-þ▄NPÂ;\x16h°\x02ØÒ" b"9¶lLµqK#╣\vì2í\x04═\x04" b":\x00ŸSäºK¢ˆuñvðü\x12\x17" b":\x08p\x19¬¹EÉÄ.·\x007¼═©" b""" :-\x03’‚žE<Ÿ#R#ÿ\n Àµ """ b":_*…l\x10AB˜{1á6&3W" b";\x06`‗\x15\x11F\tüjcA┬ÿH¢" b";X*Ž\x19ÎEø‰0e›7p\x01Ÿ" b";u›û¤ÌF§¡éQ?tú÷=" b"=%ñù\x06┘M`ºØ¨─Øâ²w" b"=Ç5┴J7IÍó_ªöXìSÔ" b">ÃzhžyAߥ\x0ES½ZA_H" b"?\x19¼Z¾6K\x1A©y\x14┬¥ó¤Å" b"?Ac▓\x12a@8׃ã╝£¹═É" b"?\\x16wT\x02C\x08Ÿ•Ò×ÿªÏ›" b"?¬¡übEkŸ5å\x04‘\x05\x7F‡" b"?Æ#¸«\x06L2¿š”•\\2õ" b"?å’b‚\fGº—zX*D2!ô" b"@\x1F'8\x1C¤J:²3oMÐñùÆ" b"@œpZZZ@!¬lÌ\x15\x1Aä[®" b"AH*wí,IA—C™ìrYFØ" b"AS,Œú™L4®>|óp³\x05†" b"As»C"░NãàØs¢\eÛÏÍ" b"A…~uAÎM\v‘ðXëƒæ\x07×" b"AÇÒ\x08Œ&Bv¹\x01*$ÅÀÆ\x1D" b"Bl\x1A[X®M&¤Úpà\fÅ9w" b"B¦•¾)$Ké¯,\x08M&P*q" b"B©\x06³à╗AØì\x03âM╔\x1D¬h" b"BÚ2eÖUB˜Œán°ÿwo‘" b"CïM¬«’E¹™•¥Þü0kÓ" b"DPÎb“\x1EBK ƺãk\x1FÇO" b"DV9è\x1DáL››BíÑ\x046Nç" b"DoØ\x06©ëI5µ™0Ϲö‘e" b"E!K\x1DøID‰¸\x08Ù\x07ƒ'=Ÿ" b"EzN¯PvF «=‡¤>Gbw" b"Eä`™]6LÖÓžùgdÈ\x17" b"Eç»ÂΪF~°‘É7[J&!" b"Fêuæ\x10‡MF¿Õýi&’Xª" b"Gnð/HàMÜúØÓPjP^L" b"GØQÏıUM<┤8┤ÙcÝ╬G" b"G½ÃŒÞ¯A”¹ª¼•w\x1487" b"GÉ@§BÙI!‡œÒÚmZ“2" b"Gì\¾Î|ND—šêIÛ\x172Ô" b"H\x0E\x1F\vàšGG¡üÍGNFåµ" b"H\x12›ª\x06LN‚±\x02HºZ\rk\x1E" b"H\x1CÔÒÉëCúØ\x07ø\x0F\x0FQôú" b"Hh“\x14ã‘E“¬ˆ:]ð¼…š" b"Hr\x08ÂÜÞOÒ«ð«zÃ9tá" b""" Hw¥þ}\n @\v˜òk†s\x14>ˆ """ b"HÑK\x1A»8Hû‚Àë’©V·z" b"IYÍø¦DF9ŒIÔ,#¸¯u" b"IjàÅ\t›@k˜\x18×JX\ˆR" b"I▓`P\õD·Üq¤¹ìTE¬" b"I½\x17\x08ÅIB?Œ\r•Çö¤1…" b"I×gç\x00}M µq€~½•$\x13" b"J&ÓGZ\x03A\x15³\x13\x07\x7FJÒèf" b"J.°óO~MÎœeùle\x03ú>" b"J8—\x1Aõ«J\x10¬–Å\x16¿È-Ç" b"J;ÍWóôLฯ\vÈž}Íb" b"JêýóM\x1AN\x00’¢±\x043:\x02Ž" b"K\x03<7z\x1EHcºçéîr£ó¤" b"K\x1EˆzänG…º´\x07Ž\x04˜z®" b"KCã2qîEâ½O¬`µ ;‘" b"K¼üzTéA\x0Eû▓ºðÙA©\x05" b"K´™v\f$Jt³\x00%é¨â›B" b"K¶$¶CÅBÍ·JŸ¼™á\x16G" b"K¸0!V\x03AÍ„\x080À—ÙjÑ" b"KæxW\x16¡@‡…\x16©¾’\x16\x0EÓ" b"L%„qÉÖFâŸ~%ƒP½Ê®" b"L>\x01K™|M4šª25Å]D½" b"M\t\x1D–e\x11Hé˜)e•…#t¶" b"MG(B –Eì“áSÄ{\x7F\x1C8" b"M÷dËu?MÁ”ê/\x05è‘\x03~" b"N\x13ïÔõAJ\x1C«#tH\tç\x16Û" b"NºàÖ€éNH˜!!µ1\x12yc" b"O\x12÷ã¸\x0EG˜¸\x0Fš\x08þ%ÀU" b"OÇRVÀ╬E╦Å┴Í╦╬ðÇ\x7F" b"OêH§å×I0üx×èß'O~" b"P\x14V%û<LÞè\výY\x12ì╝í" b"P0\r¬ü4E‡ŒO÷çȈqZ" b"P\Á\fº€HJ¨ÔüìŸW*ð" b"Pdå~zTOl§u4\e\e©1y" b"R\x02ÉZrôMª¤ÙØ\x06¦“QÛ" b"RƒzþÖŸH\x10‡½"F¼ p²" b"RåÒj®§M└ê┬d,cÝü|" b"RÝè…¬\x04G¥¦|‡ÓÒ˜`À" b"RõV¤Y#Aß–k\x0E".ii;" b"Sü¤═Ý┐CðÀ ä\x08\x1F║ú\x03" b"SéD\x1C\fÿB<Öì┘nß\x1F'Õ" b"S×籨õB\x1Fé\x1DØdh\x10█\x04" b"S³ý\x16ç«E5¼ˆó\x06uÐr©" b"Sæ\x1EÀ\x04òK1¢·{ašln]" b"SûÔDÜ·K¨¢O€½ ´,Á" b"T\x12Е-Ñ@ë‚o»û\x08–\x16É" b""" TØjßë\x02O_€—>\OÓ\n \x1D """ b"U*2ðÒ‹C¡œ^|;8;žË" b"U®“ô¶ÀH0§Ý×K|ÓÈi" b"Uá5q,‚E¡ƒ¦\fï,>\x0Eh" b"VC©ÍO`BS¤ŽWé˜\x1Cµ~" b"VZ\x1Cm\x13ÕN\n„\x008\x7F~"RK" b"V║5,ÀØDçñ·`\x00\x04²äú" b"WE³P┘9M´Åýí\x17ÓèÎÌ" b"W©6░ì4LHæ÷▄╠b\x0FÆõ" b"W´\x04\x01dÇO\x1EÑÅ\x1F\r»C0â" b"XIdˆMŽKD·Y²]öö ™" b"Yg/ëÑ5N?—'T_µþ]ó" b"Ym5PîoE'¦ñ‡E¥¥_\x10" b"Y─²é{>@LÇ,LDÉn(¼" b"YÈ:¢ñAN‘¯\v\x1FX¿IøÌ" b"[\x15$Ï:+N[«®L“èÔ‹¤" b"[\x17Ó.¾¥LûŠ€è”\x01S\t)" b"[\x18@ã\x149EV…†\x1Fä9„\x17ò" b"[<ìı░4O\x1EêÇ}%ºJa7" b"[┘¬┐ý;N·ì鮫╩O°u" b"\\eeH·\x1CB±«ñ·\x7F¨óÅ\x16" b"\I_%;\x14BÖ—¯¨k\x16èïø" b"\Ç┌\v9VA▓Ø!æ¶BÞD╝" b"]\x17¹ª¹íA\x7F¡†núþ\x15*" b"]Aæ×úçHn»1}ys'ùY" b"]×ý«h@OÚÉ\x1Dé{É╦´Ñ" b"]Íú\tÝ„AÝœ‹Sx\rÖAø" b"^<án³ØJd░"QBÝÒ¨t" b"^Jä,pdN\x05ª¥Ñ¤FuÕD" b"^È´¹`ìKÙˆqÈó:\x131q" b"^ùV‹ûùHX¯DÖSÕLêE" b"_·–“›A\x7F™]ÜPw*-¬" b"`%\x1E©╚%K.É¢\x18årÚ╣·" b"`>\x10΋†G\x11„L\x1EP&â,&" b"`qév®åJ—½^Às®ÀI´" b"a(<¾…ôIs¬n$$\x7F#\x03×" b"aVÎ\v‗çBö│·─ÐÅ÷÷ä" b"a€‘Þ=\x03N^–\x04”k+\eš€" b"a½ÅÆEåO╝º└öç?*Y;" b"b\x0Ep¸ü\x1DNC´_ø‰"ØxO" b"b-Ù└´¨E´ú2\x18ì▓ß\x15û" b"bO´ôFçAµ°1«§E±o¡" b"b^¡v3‚@°µû¡»Lnÿ\x0F" b"bı\x7FE\x02\x15C\t¢\sKÔ\x14ÅÖ" b"bÝ▓£»gD═ž-\x13=E\x0FÍ" b"c\x01\x13ÿ\x08ÈJ*€\x03~§º½¤$" b"cRBÓiòO<—`ò›¯¬ºq" b"c[ÜÜWŸF!¹múÉxA!â" b"c\-z³▓Hb£ñ£┘4xÉd" b"c{l¼oKC¸•0mƒÕÝ?" b"cœ$-ÜIBl‘O~1âÊÅ." b"cºÍÚÓÃKל°þô?Ö2f" b"c¿°ç'€Dí„0ÒX–ŽOI" b"d‰rò¾ÀG_½Ê³ýèM[\x02" b"d–®\x00±tJÔ·ƒ~ìÊžBh" b"d·ëøyüA\x04▓\fW\x03èì]q" b"d³ý,©ÆJü│êV«Å1·‗" b""" e0[¶a\x13@\n ¡ñäÞrÁ€ï """ b"eÂ\r,S\x00BW»L\x1Eßã/™@" b"f\vÝT3\x06K9œ¡ÑÊ’¯F¦" b"fï\x04¡Ô┐M·ØÌ\x07Gý'R█" b"f°3ÂËÿMÝ¥¤ä\e5*¦ì" b"g!@X*«BR³'9°"€nH" b"g;Ü\x1EcØG{¬½í\x01ÓÈÝg" b"gOŽ\x1E3˜O£¸%æð_F©j" b"g‚WZ¹\x17Mü™ðþ%¸5-Ì" b"h\x16‚_tõO>Ž\x16pmxž\x16Ï" b"h\x17þ‘I\x1FEH¤\x13€\x04áQå¿" b"h\x1E\x1E€cåG\x1F‰?ÒuÚ%Ç™" b"hT¦UÊ>Mw£ÿ Þ*\x02;Ö" b"heóô,›@I¹ÅJ”¿žÖ\x7F" b"hòö?›|B%«\x19½Š>i\x12"" b"i_ÅíÞÂJ4¬n╩Égd\x04Ë" b"i¨]É@!LÄ¢¿B┌║N\tB" b"j(·£êÆD,┤‗ÅIÛ"(" b"jÃ…þ‰|O§ŸÉã›ÚúW!" b"jÍÕôØßAÃœ¥iïrd?Ú" b"jòÄ:nûB¡“Ã[ZM´ZÄ" b"k\x01\tNÆ^O]…þﻺŠÎN" b"k'«¬8\x1FGÆž²<°@Q¥" b"k<ÒÕýkM[›²mì\x02l‡\x06" b"kTÂ\x078ñFº½\x13œxÈ·Iñ" b"kŽç®Çµ@ĉèê\f\x1C\x1D¶/" b"k£ÊÒûFAš¤÷JR5šŒÓ" b"kÀAC▓¯A £ØG×¼\x06\vx" b"kÓ\x10º\x15\AVº\x13Ö<ü\x12\x02¤" b"kð—Æ\x178A5«vI¡øg¥\x18" b"köì:ð¶NbŸ:\vT\e‹ãj" b"l-,JðƒH„·áhÔÕ. Ÿ" b"lXùXÚ\tDú„¤ßý¦ 8¦" b"lkÁª=DNç¿•Ø\rB.¸¡" b"l€T›\x13£J\e€Áô>\x14+Æv" b"lÏ”ý^éGX²×\x1Fp>u¢¢" b"lþÅ%]8L_┤ê\x033\x10Éç\x1E" b"m8\x1AêØO±‹?FŠí~\t?" b"mè\f<Œ=K\x16š±ZP虯%" b"n\x11z0±\x1CC!š?+×¥}@\x0F" b"n3ìo=\x04A\x19œ]5t„Ά‹" b"n:µ´±ÅDbíº╦Võb4h" b"nA±´.ßI{úíjØÑV½~" b"n~‘\x03¾;OI¨Œ”»bXÍÏ" b"nïX±!¿I\rÿ\x1AõÖ£ì\x10\x0F" b"n‘HEêDOc\x05juâÇ\fç" b"n¯N±×{KØ´ùÑ>´Ž’" b"o\x11ð«ô\x14@ ¨ùË¡Sè5*" b"o—\x1C\x01\x11]I"®zíäê{õÅ" b"oó\x02\x0FÚ—KÊ›LÑ”lúS”" b"p.±ë\x18 L§·J\x0FX·:\x7F\x02" b"pE¾Í.KE@«\x07\x08¸ÅfH│" b"p┤\x00\x00É\n@óÅôçSÈÿ═-" b"p¿÷1ÀÝKÍ tuQJXQ˜" b"påvWH Gr³Ç$ò[®\x19µ" b"pèO½ÇHAþ¬^ŸJLüI8" b"p‗¶Ø\x18┤D'¡ýäs\x06l¬║" b"q\eÌ+hiFá¨ñ<äðY±³" b"q¹Fà@šJ%¼-Z¬ÐÎÎ0" b"qÓÐpNüK$”«5ÇÆwr3" b"rU‰\x00å”I祖m%\x14p¡Ä" b"rcH_›ÁMLƒˆúáØìLÅ" b"r„¤½\x1D…Mû‰íyRv£Ùe" b"r╬Ö@3\x1FF¼¼b©Å@┬Éâ" b"r¤ Ä\x19WFüâ(║-5ÕÕÔ" b"r▀ÑTËØ@î╣"ê┐\x02´Æ¢" b"r¶\x7F\x18´ÂD6ØN\r¬WÂl`" b"s\x02Q+ãC|š\x0E@k\x0FP_í" b"s\x1C¤ì\t=JR▒\x00êM}+`°" b"si¦\f¾mHF’:ŒÐì˜Ul" b"tX¾ıÿWI╗îÉ▒\x1Fw\fúZ" b"txº.´=Kí¼èY;ÄPg-" b"u8D`)gGc¦uáá«ñJ\n" b"uüA\x11îzCÍéäK\x11dz\x028" b"u®Ø\v´ŸKÛ‚E\x1F\x1C2ÿq\x01" b""" u¢)\n 4ÍIw¢3ü\x15ì4\f$ """ b"u‗ã▄■SKì£!î\x16(ÉÎÅ" b"v\x1AÅæc8CeÇû\x1E▒2╠È▄" b"v\e³\x1Aæ\x19KUŒ\x07Þ\x03yÜ«" b"v:¿¥\fÇI)—ÉØhitzÆ" b"vg2¯gYC┼É─°ûueAõ" b"vì³£õHK\x16›=~“/\x1C\x168" b"w\x17\x03\x7FSÈL·’S\x01=Áçê‰" b"w'!ˆØ²O”¡!"&΃Ø×" b"w1Ÿ%ûµ@tªiTÿ|ˆßû" b"wüqh(EG£ççe0ÆÝØÝ" b"w®\x14'¾ÜJò«Âx_¥Í¯ô" b"wÇú4&XN\x05…dýõ$µ¨" b"wÈîãž\vB¿¥Rõ™¿"P¬" b"wÒiq\x03—OÄ—8ú\x14‹×e”" b"xy²-▓┘JEûÃ\x11\x1Aà\x1EÅ£" b"xŒ£F¿-O\x15¾ã0–|í\x00\x06" b"x¿X5Q\x10AO¤=œøiœW¡" b"y\x17\x1CçRÏOϸûsÄ„—GJ" b"y8Ndi¬O±¡i£!f\x12¹f" b"yWP¥>îE;¸÷\x01\x02ÃÂJØ" b"y ’Ž|WK‹š20§µr$G" b"yÍÂ!ö‚@Ó·«](¿\x06Þ¼" b"yÛ€\x1Eí`HÞ¾lÞöÜ)Ò>" b"yéßL\x07ÙK\’L-ûè\x1Eµ(" b"z\x06·/t‹BÖ’Pé‡ßò[(" b"zt×éŸ\x04LU‰NÝ\x0FŠ˜\x0F\x18" b"zâê’ÀUEÓ”î\x14z¤nŸn" b"zòoÁ,~Jnºš‹\óè\x11\x00" b"{\x05/1ÜIì¼&¿EU-■Y" b"{2ú9Å\x06HtÉe·@G`┼É" b"{û&┬DìAEƒÙKv╬ìÀ©" b"{šÏEu\x04E“‡ýÓ)@çgV" b"{¶ŠÝͨ@A›z\x00á ¨\x1A\x19" b"|×ãů¹AÚìÀ┌\x7F▓´¢å" b"|³õ¸Š¯J\x06šz‹\x17ï\x14:\x01" b"}\x13ÃX\x18IN©¡½öqÆøJ”" b"}\x18PŸ\x00îA…Š¼”Ù¿\tý¥" b"}VÌÝÇYLî€l B\r+\eh" b"}×›\x1Cõ\rIì—”OåÚ\x1C—\" b"}¸¨3¬'DÉèR\x13\x16\f¥|<" b"~=@ú`íO§“\r‚è\x02õçË" b"~ZD§•ÜCΩcRdDêç;" b"~¢#\x1Ap¹CV¹T‘½´ž9\x7F" b"~▓n\x7FÉ¿OEè\x03±Âúkû" b"\x7F\x07"%%ÑM‹Žè»6ç\x10ÚO" b"\x7F6àVßbI²‰ãÜNöwQ)" b"\x7FÂOAzBLD„ƒì¼Q=)–" b""" €\n \x08ãä\x02Dì›’qš×hûŽ """ b"€+™¾0mG9ˆMáįö³\x1D" b"€\|ø÷*M7®_ù\x14ãáí\" b"€e4˜ß H(„\x00/䃹¡ç" b""" €‘D0ûäAH¬Ìþ¶\n \x13\x1D@ """ b"üú³Y«BN(ÿ,Tcıü╠F" b"ü░¸ÉêYB▀ºÇ «÷╩sz" b"‚\x10ûH“ÈJ÷‹<Ñ‚ @5ð" b"‚V ¾¬¨I\‹\x05΢§>¡Ù" b""" ‚[\\x1F¢\n C°¹7…Gt\x0F¶¤ """ b"é▒ÿÉ5\x1DA\Â‗╠\x18Êð═l" b"‚ÿch_çMŽ™I\x02@°wÛT" b"ƒ\x1A\x1F*\x06‰H\x7F¸ý\x10…^\x15ܾ" b"ƒ+\x08o\x01,Nâ¸3Á\e¡B̹" b"ƒ†"RƒBEÙ“@NÌ@Ó¦o" b"ƒ†Øûa—FA®^\x0Fv× }¦" b"âîõ░\x14þO"®´Øüè5ÓÐ" b"ƒ·M^<ÓDƒŽÄ°¿Of.<" b"ƒóÎ ušO¬ž’Û–Xöt\x1A" b"„]¤6¼°B‚¤¼ žNùŸà" b"„b\x1D\x16ÂóMD‰Ó|´\x17Äô4" b"„‰#q\x1FÞM^§;Ρ{Re8" b"äëpþ£<Lwëì½`~ä\x04\x1D" b"…f\\x02Ÿ\x02J¯¦\x7Fï .:-C" b"…±–\x04~âCW²úI\x1F\x08õÆý" b"†\x02:ÂmCB‡/.Ñ%—dÌ" b"å?\x05\x0F[VOÉà┤µ×╔nfâ" b"‡1\x1E’E Mœ¦œñ•ƒÚs½" b"‡QÆ\x0EÅ/A´\x0Fú?¿éx²" b"çZ\x1FìrÑI|ÄÖ.^DÆ\x19S" b"‡]±\x06²u@\x03›Õ¥¼Ð¼\x1Dc" b"‡eø‚ÎGA‹–[y!«‹\x1FÛ" b"‡Á\x02\x17YäOL’ßp\x1AÊÞ5ö" b"ç§\ƒ·öEØæ5õ\x1A¾\x02GÔ" b"ˆ#6©^ªI‹¾G·\r3+ƒ\x02" b"ˆ´9Ê\x18æL\x05‡ô´~\x14ÅüD" b"ˆ·)\vrŒH.˜°š\tðd\x10c" b"ê┼üvñYD\x16ë█■XKz!é" b"ˆÞÅÙ]Ö@%‘´~Ãɼja" b"‰iä¡n"Cj¤M\x0Eñ^‹ßP" b"‰²B÷F_KUšç©á3Wg3" b"‰ö<šgEDó•\x7F 8™\x01¦Õ" b"Š\x088˜ÄQE\x00¤}Ft6\x13ÌX" b"è\x08µü8YLfº}dWáä\x17\x08" b"Šiz7Ñ€E궓sç\x12\x078b" b""" è\x7F¾ÁüÚO\n Á\¶╬î3¢é """ b"Š‰ð2ÄìG^„|LaÄþÉn" b"ŠÊ\fÏ”¸Lë«.â*\x19¥Lg" b"è e÷ìäOiöØsò╩¸┤r" b"‹\x19JXòDNâº[CXñ#7-" b"‹8ð\x13ƒƒJã”Xy\x15%ÿ/%" b"‹‘X•¡OF\x03´ó]#‚k:'" b""" ‹Ó\n \r¦dB\x07¯¿5f\x02ؾW """ b"î\x12╠\x17ÉôFÀ¬Ö\x05─╠TÄò" b"Œ!\x12T\t«C\x01¡EFjwuB" b"îa/;#=G`üÕ¬\x1CôÎ\x1Eä" b"îÅÿË\x04¦M㬼_\x1D┼ú£\x17" b"Œ¢ö\x1E£çD³³ŒKù\rL3b" b"ŒÇS©\x12ßO¨®BÎöü\x0F}ÿ" b"Œæoð\x1A¹C=¿\x1E( ¥\x07Ðj" b"ìW\x1AómåF2Ñp\x11@&Z╩l" b"ì[¦uW└O└ÿù*Ã\x1C=ô¹" b"ì¥Q®pµDà┤Z¬\x18ût¯ñ" b"Ž$C\x04ëZFs©ÌÙc£Ò´R" b"ŽH=” r@÷—ËäŒE‚«V" b"Äq>=Ç/DsÅ©ýJkªï\v" b"ŽÓjÆŒºKLŒîHmK\x15\x19ü" b"ÅLØù«oK*Â╣Â╣ªÉgÝ" b"ÅR¾┴\x03ÄD8║Õ\x04└ÔzÞ╬" b"ÅzoêíÉMòÖFeXx9\x1F\" b"ÅØÇ¿ü\x13C7Ñ╗ynÑ:\f╠" b"Å×&âq¿O\x04Çû\x06¨Ëøõ┐" b"É<\x15\x1F¢\x0FG)Øú\x12Mæ\x06╝D" b"É¿Ùì34@Aì\x15ãT\x081¦©" b"‘\vl\x05H!CŠ»qï]"^Ê" b"‘;Ò\x17þ\vD÷ºÿìŒw\x7F~h" b"‘<,C,¢L¸•°ÙãÂ\x19l(" b"‘óÔY®ÕJ<•Ê?¸\—äÀ" b"‘ù>H&”Bö¯\x1E¥ÅéÑÆË" b"’<ã\x1CÙ\x07B\x05—pÎiR‡tP" b"“óO(œIBª°Œ×Áƒ¾n}" b"ö\eØ\x06╚\x13HL╣Ë϶_÷@ð" b"öU╔dtEN,ÇKUt£║ü{" b"öâ╦‗*┴G\x16╝Å_\x08\x17╔N¨" b"öª\x03Ü\x03.J¬ØW╩.dr▀ª" b"”Ïèja\x07Hx›–Xª¬KQ\r" b"ò┴o4yHCü░i7Ü\x02G┌\x07" b"–\x1D!»ö0A²Žƒ¯ÅkBL\x08" b"–„Ìyö[Iƒž,8¥[›\x16\x04" b"–•üŠ›µI0¡Ë³t©™\x04Ü" b"ûÎ+o×½N\t¿ý┼4üra." b"—.´F‚ÓKà‘1ìšuJï\x10" b"—F£ÂL\x06Lt¢Âh\x04›^\x05ï" b"—kl¨ã\eFé¼Æárõ€‹™" b"—_¬@³† ½¢ò\x0E«á" b"˜=õ“ÐwHF˜S¯›\x03ØÍÖ" b"˜Zel²vA·€WxB/&Ù\t" b"˜†„ÌùLG¾”\x12\x1EªB/bk" b"˜¼Ç+}7B‡²¬}\x7F#y\x17\x16" b"˜ÚX¾\x08mM\x1C¨ôµøZB\x07\r" b"˜êky`OF\x1FžÅDF\ÏE7" b"™¼\x04\x05\x08ÿBŽ¢¢„\x12¾íÕò" b"™ù\væ"NCª(é£õª\x05‡" b"š,ãòx\rKò¤ºí³¤ïO±" b"šj@e-›O\x1F°r*©µ÷nJ" b"šƒXD\x07\x11E‡ƒ/B\x10\x17¾\x14¿" b"šª\x17ƒ”µK»Ž¿7¾ÇpÀ@" b"š®°¶VžMͺI ø½G:\x19" b"šº\vH©TOÚ´aáa·ç\x04¶" b"šøĬ\eÔLÿŒ\¦ãÒÇ\x08Æ" b"›‡‚’·åKô„“{\x16¥ïáº" b"œ\x00ŠŽÊNAŒ‡éœlzå\x08n" b"œ0ê\x10ç=LB´\x11ûô~&ŸC" b"£9±\x03\x07´A0ûÉHçÖØí┤" b"£Z\x17|ŧNMïì\x04*G\x14tA" b"£g?í\x1CÈL¾®¾╬\x0FÐÜhÉ" b"œœ¯zŸ}D)¢7œ=½nç{" b"£ÍG+\x04ñD¦¡ÅÃC8┤ß\x12" b"Ø&▓p¬ÎB½®Î'7~|à¯" b"Ø-PZÉZL·ç\x14:ÕÔìPË" b"Ø¡¶ûKÔL\x1Cè·o\x19¶░ñ»" b"ØÎı·T³HÞÂÉR¼\x16LÖÉ" b"ضg▓þ×@2Ç╠²¯hº³é" b"žŽ§«ŽUHÚ¾Ùw=5@žð" b"ƒ:ÞI&ªE_▒ÅÝ▀■\¾û" b"ŸNli"}J/ˆ\x16\x0F_‚>+c" b"ŸvÜŽÌ\eH\x11†ñ\x05pP\x01ÇC" b"ŸÀ$‚Ö\x10H(¯YÃ]?a\x17\x01" b""" ŸÊ\x197\x0E$B@‹³\n F\x0E\x1C®ž """ b" \x08_\x03ŽgIW„¯–ƒ¨–ç\x1E" b"á+─▓×\tO¯ÉJ\\x06:uýö" b"í|YzÇEO¯®=I (h┌É" b"¡—{\x19˵K\x7F°ee3”Ô<æ" b""" ¡ñLJ+ÀHŒ¾YÖ\n ²´KŸ """ b"¡üš™¦ H¾½ªó¹?ás‡" b"ó15¥ÉýH\x03ü═XÓâ╦l6" b""" ¢Ÿ\n }…\x02O2’\eëˆo×\x13ì """ b"£ G‡\x06µKž°G¹û“»’‹" b"£J\x17\x0E\x04VEpœ˜a}c¢€²" b"£[²éN¡D{¤…l³y0?h" b"£Ö%¢\x00ÒGŠ³\x06\n\¬7—L" b"¤~vBs.G>•übyW‡\x1EÍ" b"ñìÙH5aGXøÁ×wnÒu\r" b"¤ ؤ՚L8©Ž\x08Ë@NðT" b"¤¨…Ö¶NAk¿ðâ:ÇÛA+" b"ñ╔ÞQô┴D╔ìu×,Àk®-" b"¦øÖvkvAÔº`'°2Þ?ž" b"ºlfò\eƒG\x02ìÁ»zº\tÖ┐" b"§¼Œï5ºDW²'Ou çQ{" b"¿\x0F7\x0F‗╬GØ╗\x00┼{Ê│╣¾" b"¨\x11Ôžc'D\x18ƒÆƒ—e WÎ" b"¿c,ɤLH¶âº▀f5xv\x1D" b"¨dŒuHŠHcœÂàÌ‘~qG" b"¿|~¬¬O░üo£÷‗Uü¼" b"¨Ë1C‡PLiƒVQ²Æú}~" b"¨ß$<3iDÛ‚Ïi\x02«ëÓ¡" b"¿·:\x1F"ÀK░ü~A¸6─m\x1D" b"©%iC°âI×°YAid¼" b"®@ÑØ\x13$N┼»╔d‗ö├\e\f" b"©»WKÓaMZ·cñ£\x1A\x0Fé." b"¬\x16\¥ü}Hü©■Ütµ*Q\x07" b"ª,ÄwÔíA÷¦\x15‹v\x11@\x18r" b"ªÆ¥lèçF®³‹¯_UU‰\e" b"«\x12ѳa|K|™ÊŠ¦\x1D5G\x05" b"½L┴¨═▒Nû░I╚ɲ»F9" b"«[šp\x1D³N•®s\x16®Òm9v" b"«s=»HCM©±£u…‹:‚o" b"«ïu®#jI͹XðñÔìå!" b"¼lRÑ¿\rNõäM\x1D<ÅÉ~2" b"¼ª╗é\x1C▓K\x06ùÅXþHfò]" b"¬Ô\x07ú“\x7FI-•1àEŽþÕ@" b"¢×´.ÏM\x04©Ñ4÷(Ú#j" b""" ´Ïå\n RGcŒÐ•\rO~‚ç """ b"¡´Ö\x17O=KíÅÑ\x10ƒl\fh%" b"®IV\x19\ïOKˆ\x1C\x10“2©&D" b"®Z‘KTÙHŸ¹Ñ¢MFIM'" b"®Á+ÌïÑM Š¹Ï‹\f»F\x18" b"«═Óo4·Níó?츩Õ┴ò" b"»IÄ Ï÷F┴Ö¸z%¤üª!" b"»g?ïììL¢¢un÷Ð2éÕ" b"¯œÃ\r‹lGÊ´d‹hÐ\eŠ\x03" b"»²AÀ├ãL{Á@ÍêO\x1AÅ\x1F" b""" °\n b½ºYI&‹æš\n N\x17W7 """ b"°}Âj%&NÓº#ÔGôØœ"" b"░¾³b▒\x02HÚóòÉ\x18\O┤W" b"±\x02UúP+G@‘Ó\x19\rléˆb" b"±E*Y|ºB_©ÅÂÈŸëÔ\x07" b"±P쇋ºE˜«üu¯w C}" b"▓J:rn┼K©èùêÙÅ3³ò" b"²\x7F¹*#¥Höª¨oƒD·î>" b"▓½ÒØ\x1E¦MµÑ─§Èkøı'" b"²ÂIdSùC;Š¤\x1DÚç\x1DBd" b"▓ Ñ╔\x15-F´░\x12┬ò<Ø;*" b"³Vœí5\x1AI͘î€\x17\x0FU†º" b"³g¸+‚\tB渖H5\x1151g" b"´¶{œôE³†ëN™ýr\x1Aq" b"µ6»žÇ÷Aº«6–rØnŽu" b"µEªJe\vD‰¡Ë0fSRe(" b"µd+î©ôEŒ›8s@–k9\x07" b"¶dûÁíWA/˜Ç\x01€HÅ}í" b"ÂüDì┤\x03B▀ö\x02g4Ç\x03\vz" b"¶°¶GôÙJ{Š\x0Få©ÅI\x0Fq" b"¶ÌVt¡ B\x01¥3“\x0F\x05#ag" b"¶û²\x11¶ÎIz‘¤Qþw g" b"·Ž%ì);C\¬z‚öbi¨¢" b"©\x17GR╣~I'êŨ<s{," b"¸qÂå\x00§A¾´—<©ÃÕ\x02ð" b"©Éy╬½8HƒÂ~┐îý(┘," b"¹(\x12º£íJæŒò]Wb±Œw" b"¹3\r\væ·Dõ®®Mã\x18o A" b"¹4ªèé¸Eâ…s—ýë£Ï‡" b"¹Q\x14U\x7FÊKO‡ï¢§œN?w" b"¹Èa\x17V…@»\x7F\x06Sÿz”¶" b"º\x14€\x12}]K¸‡ì+?9f`º" b"º6ã¡D\x00F’€ÍÅŸ\e I" b"║ûå│ßØDÓíiwë.3¥─" b"║·'\x1CA$@ùøù~è\x07ÅÞÐ" b"»sœ—ðSB>±ä?ì$IhÌ" b"»¯€¾ÝXOdŒœNÁù»Þ " b"¼”¸®¤^D\x03°±\x10\x7F¦me£" b"¼–ÿÖî§B¼ŠóË&AÏ.F" b"¼º¹°K•FP€? 5†ž5Q" b"¼Òš\x16ÆÍB¶¯¤‰ŠT˜Í" b"½%‘Ó*&Fù¸Ø¡ý\f8?‰" b"¥'\x1C\x19SìA¢Á/éAëM×═" b"¾¥]!>áM‡´Ç“›\x7F;\x06\x19" b"¾Ëd+³ML?¶;+û¨\x1Fت" b"¾ÝÂïì4Ež°}éD\x0E‹(>" b"¿B67\x07hIO‚\x12’Ž™ñž\x15" b"┐cÑ{ù¼@kùX\x17ôüS\x19÷" b"¿Ü™þü K’‘ \x7F\x11^›Ã\x01" b"¿ð~\x01y³O²°ë4õ‘'D\e" b"└?I²▀\x04F~Éù§═σ ╠" b"ÀE ÿ×ìI?œPÇØSŽ˜Õ" b"À\öŸLòEa…©#…1{Èc" b"ÀŒ¼ï&¬GU‘\x06]~ÉÓÜ€" b"ÀŸ.ƒ.ÅKݯâ„_2ön‚" b"└Á£ÿcÅCäê ¹ªÚpÃ\x1F" b"┴\x01ÈB\x1F╔O<Ø2 \x08)v\x1AV" b"Á\x07„•—‡K>¾\x1Fg,èvøÖ" b"Á!@ö[±Iœ½:²\vóÆ\x1DØ" b"┴ihØ»┴MÖæ¼■»"U;\f" b"Â\x04BƒH\x1EL•³& ›7ý¢\x18" b"Â\x08àE¡\x07B,¼è)|â\x02¯G" b"Â>}80\x12Jæ™\x0E\x07\x18„vâË" b"┬_\x06Ú§ò@═ê¸░¬ÄÃ\x05ü" b"┬lÁ¾hJNÅ┤KàS┘ù╔_" b"°»|1qN[†{ô\x19‡†ùD" b"Âýd\x1C*\x03MJ„\x12¦5`í‘0" b"┬■´ñ×eDí│ïÅÂ¥È\t\x03" b"Ã\x00MãêŸM¿Ú”Ýï|Ê\e" b"ÃOuå³ÛMø¿GdÜ\x06RIä" b"âfuZ¥JA«\x01g˜™\e\x04i" b"├ ùVNÓF\x1Aá╠ù²Æoü─" b"Ä6É{gºFŠ”Ô\x10Å¥`|ª" b"ÄJô©ÌÄB™ÇñH\e72"" b"Äb?]€^I—”e§…“(m„" b"Ä”â\x7FhØE¡¨°ƒ?"Fñ«" b"─ø½3ÛªE\x14Ø\x04E6¦K\x1Aw" b"Å\vt.™~I_™¹?uT#Ôž" b"Å„s…ûeI¤°sŽ2ì×Bm" b"ã_Y×ʵDÐ╣2èıÆ┴╔É" b"Æž\x1A^S\x01L\x0F«]E›ƒl$)" b"Ʊ\x07Á‚êOí´®Cv\x14Éàk" b"ƾ\x049ÅtE<+¸’¶6y" b"Ç\x1A\tbAÕAÊ°›Û¡ÉŽQ—" b"ÇDúzÃ3N6¼¢šl¦¥ôŒ" b""" Ã|RÓ\x0FÁK╔ÅX■ýU\n ¤Ã """ b"Ç}£Ø’JJ}¿Zâ`ƒoúç" b"ÇâFÙÑ«C\x19¬Šú´Ð« \x1D" b"Çý\x04¼²ðL›²–ß³*f5Ñ" b"╚\x06j\x08ßbF\x1FüéG┐╗\x01i░" b"╚c\e²\t\x19K˽¢\x1F°üFòð" b"Èm!›ûPGL¯é!¥íµÒµ" b"ÈwâÚ\x17(B„™¤a·7¿[Ä" b""" È©\x05‹ÖB‡Ž\n \x1ECû'¤á """ b"ÈÑ›\x7F!¯F¥ ù¡"\x10ã?H" b"ÈÑÛ%lpJÒ»WÞ ”\x15»u" b"È×ØiÎ\x14Nž±\tÐþe>·í" b"╔\x00ìý4bF)â³ÄDT]╗ " b""" É\x1E[šû¾@·›Ä\n E‘ŸÎ€ """ b"ÉV\x03Ñ?ÎA$œÃ‹¢ÆÖg5" b"╔a|\x14¹ØE³░═N\rê╣3+" b"ÉfȽN\x19BFŽ±\x15\x07¿Üïà" b"╩\x1CÖ£z)F║ØÚc7l2¶Á" b"╩ï/ì└┴IÏÉ%õ¨ñæ]Y" b"Ê°MAŽÒNš¶5ÈãßÜО" b"Ë!0ðhÚA-‰’È%3w»/" b"╦YyÑ▒┐A═ÖGØöÏΦº" b"Ë]Y‘M|AIYhËæ" b"Ëv®;EÜKA©\x12ûª\x1AEÄ" b"╦êâ▒IP@úìðn°7àò²" b"ËÖ£TxLÔ›B¡xÐ\x08ƒë" b"Ëí¬da\x7FI¼¥þ+wžÿ\f" b"╦‗'¡(hAãë;|╗3ì`│" b"Ì\x19û\x1E\x14ÎK\x16«á‘“EL9\x0F" b"Ì]ì \x7F4L\x17¾WRÏÒ†\x122" b"╠▓óAû4CûÅ.*E&\x7F©¢" b"Í\x06\x19œ|KA÷ž¸ZJÙó¥Ë" b"═\eÕá3!Jjçû§ÀåmÅ4" b"═8³h¾\x12JºÉÏû`cÆLß" b"═={oxìMÁÑ:<½▒Z\x13Ó" b"ÍZÐ3CÂ@0œø@'\x19ž¥\x16" b"Ís8‚-\x1EDÀ’©Íà!V¡£" b"Îà+ü±¯M…©ìÂ'íeã¼" b"¤╦█bTÃK┌üRPR(àMl" b"Ð\r\t{ËûM{–Ù\x15¢¾½Ì#" b"ð\rMM\vöF3ƒyvì\v\t╩Ì" b"ð-è\x128QAôÇç█Éô^îƒ" b"ÐsÊÊ‚?NðŠ1\x12\x19’\x7FÅX" b"Ñ\eÈh‚™BWƒqç\x13Ö\x7Fì£" b"Ñ8á]§œNv€§¯i\rš‡ù" b"ÐãLîPéLæÀ█Lçk³Ø=" b"ÐÒ¨‗ÎÚO¤üvh\x17«\x14═÷" b"ÑÿúXÀÏC¬Šˆ¶^ç¥\x1C¡" b"ÒDþ\x12\x11sNŽ •2\x06Ý‚«\n" b"ÊW\x05y▒ìDþªë4\x10½fÉy" b"Ò¾\x13úŽ.O::±ÕQOØú" b"Ó\tgÞÐæIL™ŠÛüž'{ö" b""" Ó\x1Còß\n œEï¨Ká\r£ôÅQ """ b"ÓLËè2ÒHÀ™žŒ<ËÑ\rW" b"Ó¿’Ò•ÀD\x1AÕj$X\x0E\r©" b"ÔQkêímHD›\x7F&\x1AæzT\x12" b"Ô¡Q¦Ç¬@:€(Ãû=ÃUh" b"Ô¢ú—Ï9C#ºîÂ2\x06Ûàá" b"ÔÁÓé±JIš•)Ø×ä.\x1DN" b"Ô÷§°Ô±EºŽ(\x01÷-…,\x17" b"ÕS\x1C³Ä¦GϽ¸€ÚW{<\x1D" b"Õ\x7F6µT\rM;³«AeT>¯f" b"Õ¤sAM†L€µ¡jýø?½õ" b"ı¾¹þ$¨@fìî\x07p¨qä" b"Ö\x16\x06lЀAG‹’ÝRä\x11‘\f" b"Ö°_(‡yE3»%)\x7F[ \x1EÜ" b"Ö´Ü víBIJ16”øª\x14\x13" b"×\vJeáSIÖŽ\x12?Èæ3@\x1F" b"×\x18v|ĬL´€j(ÍW\x04©\x1C" b"×\x7F;m.„N6 ’W;; ÔÃ" b"×ädIP£DÓO?G²)¹p" b"×éb˜‘IIÕ‚C)¬A[ó3" b"Ø)âXnJK¤¹à²Í°ÇdÄ" b"Ø-XúU£Lz“½ì\x0E^Ã\x14G" b"Ø¡øŸ#{G\x17³×@“] BŸ" b"Øä\x05\x00ìlBë¹ñ\x11ÙKˆ-\t" b"Ù\x19%¤eÆFÌ‹ê;æâÉÎ " b"Ù?ÑÊ?nO\v¬\x1Ai°¸\x1Fvò" b"Ùw\väÞGFùŸµqÔ[DS€" b"ÙŒ£yB~Au™\x18ǯ _e\x17" b""" Ú\n ë'Ÿ\x1EDÙ±É\x1Dl¨?:Ô """ b"Ú4\x06*)›CU–å4\x08h¤U™" b"Úd[²Ê(G7”kpdøC&e" b"┌Ø7o\x03ìO§×]ëy\x07\x1C§Í" b"ÚÈÒ1_\vAò–O”O\x02ã\x1D[" b"ÚãtSò8N9…dz|büpÔ" b"Û\x1E˜÷=X@ ¿\eºG¾=µr" b"Û8®?º†FN·°–›ªcm[" b"ÛBu›^ãLA¯Žk[FÒÝC" b"Û‹ÖT4ÔA^«½D|\x07\e\x02m" b"█ìù╝æÚK$ƒv\x1F]▄\x01Ã÷" b"Ûë\x00ýV&DH¬÷¨f"&yu" b"▄\x02\x15|¡+Isì▒Ì\x005óܸ" b"Ü<½V«†@`£µÿk²!\x0EÇ" b"Ür„\x05Ã>B’–]†;ÄAƲ" b"Üãà+\x1CsA€‰;*Ô]ÎÑÐ" b"¦.\x01§JÌDXêJJ\x11\x1F»ÝÅ" b"ÝjÍ\v^2N’šì~…&òí×" b"Ý~šUVµJ9±Ù0\x1Al!¯?" b"݉‚\x07â…F!œlŒŸu¾\x15K" b"¦¿░±ú\x01J\x08ô╦ºØD\x14k9" b"Ýï\x15«ÛêD˜¦@\x01ŽÆùÿé" b"ÞŒ_휉B Œl(½¶\x1A²k" b"Ì® Å£âLZ┐qê3í,¿╗" b"Þ¼§§º)J\x17€–ú2@£NÏ" b"߇%\x01¯BJø£OYýÕ\x1FbŒ" b"à1\x03“Ó,@+¹™' ––ó\x01" b"Ó;²┘\tíG+ç\x11îsÛØ´¸" b"ḉ_±J\x1DŠ‰o†øŸù\x08" b"áõÁ\x0E ’GÌ»Zcüz«IF" b"âE¿\x18TþB.†Ác‡‹N’U" b"âJ\x03\x06‹¼H¼•zN\x10\x13“d½" b"⎙úŸ\rI#Š\x0E\x12óëâ•”" b"â»\x13á\x1E\x1CL\x1C»NÖÎï†\x13\r" b"ãJ\x159•LÙ¼XK‘ ÿYÔ" b"ÒSf╚ê,B─úÆ╬µÁØ─g" b"ÒS¥\vÕFH)ì©\e\x17▄«\x1Aì" b"ÒVò╝ØÃG<ïl2âÒVt‗" b"Òä\x19©zvOÿÄjÈ^ÔZvÉ" b"ã¦*"z\x12G¦»êånÁpT¸" b"ä\x0F\x070‰aFt™Ÿõ6\x11;—Ë" b"ä,–(;,M˱\x1CY\x12\x19)\x06\x06" b"ä?bþC[D÷¥SÏÒ\x08Â]" b"ä]d\x02\x08SJƒ•/¾œØ”&ñ" b"äžñ±Ç‹O\–²ÿã «²€" b""" åeü\n º\x11L?®ÍÙð\x10$¸= """ b"æWƒ\x0Fä3Fö¢3tþe¤ïS" b"æ[”\x1CM\x05JåŒ_Ësøý¸¦" b"æf\x07ík^A¸„Y¥é]£xW" b"æáºBRîF’ŠûÒþ\x13<yW" b"ç<D\x1E•ùFÌ°gi!tÃ:ö" b"çN³&:=L¹¹U6s üHÄ" b"çÆɸ\x10êBi‚ú\x07i]7üH" b"þ╔Ê-Ë/D\rÉß\x0E\tÃ=\x1E" b"Þ\x16ÝKºøO>©Gë└\flÉÈ" b"è3‡K¤AJv˜IØ^pƱÀ" b"è–è?î(C>¯`Ó ÄÛcù" b"è—L!ŠDI<±2Î\x16P‚üè" b""" Þ£sô\x07[Kàìs©l\n Ö]Ð """ b"Þ§ÚÂ┌{FcìZàðªWEÞ" b"é\x17?±\x038@\x19ƒG‰y\fz`Ÿ" b"éZ2Œ|NAK†v~Fuà›Þ" b"é¡Ï}ÿrO¾¥\x1FYaç÷Äš" b"é¬0\x12©ÙA2§Ô3³\eÉ\x08¤" b"Û'üèZ█M\vå┐Ð\eç»\x0E2" b"Ù!¬ö\x1EuA#é@ì³│}´" b"ëL#L[L@”½ß2ÊÜÈ\x05å" b"ëe¾¢Õã@+†€Ài0Q\r&" b"Ù╝\x04ØY}McÖq\x04¯ƒ\x14░╠" b"Ù±9õÐ×JQÿØv<\x13]‗a" b"ý2p\x1Eÿ\x11N㺷\x04â\x0E▓Øç" b"ýa#\x15╦¤M쥬ır╠‗¹┴" b"ýÏVÅ¥»F\x16û\x18T├©T\x19r" b"íQnyðýNÚŠ3)$ÊiD\x16" b"Ýa!p×ËA║âNÌrYb}Ø" b"íq—ö\x10¡Gß‘ƒe\x06C\v%Ž" b"ítu2Œ{H\x13ŠÌá\x19ò˜ü&" b"íu¸[)\eJp¥›?|\ro0É" b"î=1ÛRÀDå©2A¯jïLx" b"¯£Ëñì░B\x1DÅ┐┌\x05{\x0Eê¨" b"ï6¥\x03Zä@äšä#\vÛ\x01›4" b"ïpn\x7Fþx@ß°y\x01\3w̺" b"ï¤Í.—_Fàš¼`y߃Þt" b"ï¬"“ÙEC|¨{D˜\x183t"" b"´┐¦8VpD\x16ü+Yb:┤¬Z" b"ïæ!a\t¶J”‹Uö´=@fl" b"0\x12¬Ç@B\x10ü\x07o(Qm\x07s" b"j+¾┐ØK¬ú\t¦{Øà\x13‗" b"ðvh–x£I޾肨<\x18ú¦" b"ð´üF€2Lžª<¦\x0E·ß\j" b"ðÈ~°F\x11G…•\x18¾€áTÖ×" b"±$T╝$PCÚö:(\x13åÉĺ" b"ñšÕF¦}@:¼\x10ŒA\v\x16Œ\x07" b"ñ¤\x00zRùKh—\x1DryüV4H" b"ñ¹WeFþJ\x17¡\x0E)ln}sy" b"ñÉÛé5®FП¹©i\x7F¿\f'" b"ñÍÿyÙµF5«\x01\x0EUÄëVA" b"‗2°6¿rN╔¥A║iòâ ì" b"ò6NlXÏG/¤F•/b®ý«" b""" ò|sS‘ND\x1E”\x10˜“ \n #æ """ b"‗▓É┘╚╩HÝ░:H═IÑ"½" b"‗┬¶▓ÙcEáà\x7Fì'╬b╝I" b"òèîÏr\x13D—¦¹ÇûÎ\v?È" b"‗´╝ÒÑØLÜ¢╣ö³%XÈN" b"ó+a?‹PIÝœe\x7Fó\x1CÓ\x00¼" b"óB˜\fk¾G^…Æf\x18®[ä€" b"ó]\x1F\x0F×oGª±Ëý“ø,8½" b"óg\x02äÖ}OÊœ~™Aä\tõs" b"ó\x7FûU;\x1EG¦¡5yA\x17w{c" b"ô\v«^\x1F•M]–™ô`@\x12\eÉ" b"¶üwã\x10ÅJÿÑa\x19t1¥\f█" b"õQI‰œßAå£âíy]=&m" b"õRºÚy·AÑ©„M3^^É\x06" b"õ^k\x1Aé“H˜¢ß¢µzÎ\x13‚" b"õ–º¿Á`Lc¬æ®c{åÒ>" b"§ûÞ)%IOPäÍeëÉÅ\x01q" b"õº}K\x7F‘E´©±\x19Ï·\x05ƒâ" b"õÚø\x00¾\x06N\x02Š|L÷™äˆ³" b"õþD,ô\tG\x03ª\x02\x05Û¶\x13\x03`" b"ö\x0E‚AüSM'—Ÿ‚’å\x14ñ“" b"ö\x1E™ö1ÜNàËGbFæz\x1D" b"ö4ü-„\x17B\x1C·R!•‰›sˆ" b"÷«ËBµüGhùiA^\x14}\x1Eå" b"÷\n\x00%O\x1DA\x06«\x1E\x11‡¸Õˆ1" b"÷BêÀÔ\x11BW²«˜«Æ,7¸" b"÷Ëö;ý“K)†’,¾šŠf\x18" b"ø\t¯¢zlCS¿ÅŽí¾É`¼" b"øKóÀµD·‘^Ý!K94B" b"ù\x02ØÅ€4Hã´ó¬7\x08\r½ñ" b"ú\x06R\fú\x16JÅ¡\x12‘¢Ád;[" b"·*è?£ÔCÐÑ╬?Ǭ+½ì" b"úNz¯ŠÝH\x0F¢Ý\x7FEö\x17SO" b"ú|·dãæK¬¹cõÇD€ˆJ" b"úšq\x13.‚M†®¤>K'ÏØë" b"¹BÌÅ┤yEDç4¨«\x07[N$" b"ûHÏóÿ\x1EC-Šî\x1E\x1FFðyA" b"ûdèU^aLË™}ˆÚ~c(\x0F" b"ûjd¶Õ=LŠ£\tžØT<üÕ" b"ûw‰ƒ\f]@/•ÛbÉ|Ó2ª" b"ûœ8ˆHmCåq'\x05Bò&!" b""" ¹Ø$y7ÏMV║Z_¤\x05▓\n C """ b"ûó|~ãX@²‹gÉ;nýŒW" b"ü\x16XKÄ„E¹¼7üëýžØ\x15" b"ü5LPÙ²OTš6Òàœwñ+" b"ü_\x02i \x1FEž¸™Ü\rÝ„U©" b"³m¿vìØM«Æ7«º┼\e{~" b"ü…æšßíE~–Pdƒ\x16}“ˆ" b"üÐ…ñêE’«Ø=h\x1D¤ŸN" b"ýp.£ˆ\x10H–Ÿ\x07ç\x1Døÿ_×" b"²ìèðYkO7×`Òi®¼Pb" b"²Àæd▓PI\x1Aüt[b(Ó\x7F®" b"²╠Q| ÙL\x17í\x03ì\x13\x18ıdr" b"ýÛ×\f½%C4™ƒ"\x1F.ÀÞ²" b"ýíŒK¦6OB…Ñ1;&óHó" b"þG”WWÛN¸½ÔÙr:£QÍ" b"þžH¼4ºAÓ¯j\f¥u³´ì" b"ÿ1ä›êaIe–\x15·ï\x08Eÿ&" b"ÿ7˜Î\x17øI.¬]\eÓ¸Zë\" b"ÿwI\x13Oþ@X¤\x11ÓQžU\x12ó" b""" ÿ„íI¨öC7’*¨=Cç\n 6 """ b""" ÿ·‡\n \x08|K\x1AÒ„TOŽ\x1F² """ b"ÿ¼òßÂuB<ˆiXOã0“O" ] |
||||||||||||||||||||||||
|
4.35 ms (6.80%) |
5 |
# app-scripts::refresh::read SELECT `app`.`id` AS `app.id`, `app`.`name` AS `app.name`, `app`.`path` AS `app.path`, `app`.`author` AS `app.author`, `app`.`copyright` AS `app.copyright`, `app`.`license` AS `app.license`, `app`.`active` AS `app.active`, `app`.`configurable` AS `app.configurable`, `app`.`privacy` AS `app.privacy`, `app`.`version` AS `app.version`, `app`.`icon` AS `app.iconRaw`, `app`.`app_secret` AS `app.appSecret`, `app`.`modules` AS `app.modules`, `app`.`main_module` AS `app.mainModule`, `app`.`cookies` AS `app.cookies`, `app`.`allow_disable` AS `app.allowDisable`, `app`.`base_app_url` AS `app.baseAppUrl`, `app`.`allowed_hosts` AS `app.allowedHosts`, `app`.`template_load_priority` AS `app.templateLoadPriority`, `app`.`integration_id` AS `app.integrationId`, `app.integration`.`id` AS `app.integration.id`, `app.integration`.`label` AS `app.integration.label`, `app.integration`.`access_key` AS `app.integration.accessKey`, `app.integration`.`secret_access_key` AS `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` AS `app.integration.lastUsageAt`, `app.integration`.`admin` AS `app.integration.admin`, `app.integration`.`custom_fields` AS `app.integration.customFields`, `app.integration`.`deleted_at` AS `app.integration.deletedAt`, `app.integration`.`write_access` AS `app.integration.writeAccess`, `app.integration`.`created_at` AS `app.integration.createdAt`, `app.integration`.`updated_at` AS `app.integration.updatedAt`, `app`.`acl_role_id` AS `app.aclRoleId`, `app.aclRole`.`id` AS `app.aclRole.id`, `app.aclRole`.`name` AS `app.aclRole.name`, `app.aclRole`.`description` AS `app.aclRole.description`, `app.aclRole`.`privileges` AS `app.aclRole.privileges`, `app.aclRole`.`deleted_at` AS `app.aclRole.deletedAt`, `app.aclRole`.`created_at` AS `app.aclRole.createdAt`, `app.aclRole`.`updated_at` AS `app.aclRole.updatedAt`, `app`.`created_at` AS `app.createdAt`, `app`.`updated_at` AS `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) AS `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) AS `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) AS `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) AS `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label AS `app.translation.label`, `app.translation`.description AS `app.translation.description`, `app.translation`.privacy_policy_extensions AS `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields AS `app.translation.customFields`, `app.translation`.created_at AS `app.translation.createdAt`, `app.translation`.updated_at AS `app.translation.updatedAt`, `app.translation`.app_id AS `app.translation.appId`, `app.translation`.language_id AS `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" true ] |
||||||||||||||||||||||||
|
3.51 ms (5.49%) |
1 |
# base-context-factory::taxes::read 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`
Parameters:
[] |
||||||||||||||||||||||||
|
2.87 ms (4.48%) |
5 |
SELECT LOWER(HEX(`script`.`app_id`)) AS `app_id`, `script`.`name` AS scriptName, `script`.`script` AS script, `script`.`hook` AS hook, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, `app`.`version` AS appVersion, `script`.`active` AS active FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` != 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters:
[] |
||||||||||||||||||||||||
|
2.40 ms (3.75%) |
1 |
# base-context-factory::shipping-method::read SELECT `shipping_method`.`id` AS `shipping_method.id`, `shipping_method`.`active` AS `shipping_method.active`, `shipping_method`.`position` AS `shipping_method.position`, `shipping_method`.`availability_rule_id` AS `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` AS `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` AS `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` AS `shipping_method.taxType`, `shipping_method`.`tax_id` AS `shipping_method.taxId`, `shipping_method.deliveryTime`.`id` AS `shipping_method.deliveryTime.id`, `shipping_method.deliveryTime`.`min` AS `shipping_method.deliveryTime.min`, `shipping_method.deliveryTime`.`max` AS `shipping_method.deliveryTime.max`, `shipping_method.deliveryTime`.`unit` AS `shipping_method.deliveryTime.unit`, `shipping_method.deliveryTime`.`created_at` AS `shipping_method.deliveryTime.createdAt`, `shipping_method.deliveryTime`.`updated_at` AS `shipping_method.deliveryTime.updatedAt`, `shipping_method.deliveryTime.translation.name`, COALESCE(`shipping_method.deliveryTime.translation.name`,`shipping_method.deliveryTime.translation.name`) AS `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.customFields`,`shipping_method.deliveryTime.translation.customFields`) AS `shipping_method.deliveryTime.customFields`, `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation.languageId`, `shipping_method.appShippingMethod`.`id` AS `shipping_method.appShippingMethod.id`, `shipping_method.appShippingMethod`.`app_name` AS `shipping_method.appShippingMethod.appName`, `shipping_method.appShippingMethod`.`identifier` AS `shipping_method.appShippingMethod.identifier`, `shipping_method.appShippingMethod`.`app_id` AS `shipping_method.appShippingMethod.appId`, `shipping_method.appShippingMethod`.`shipping_method_id` AS `shipping_method.appShippingMethod.shippingMethodId`, `shipping_method.appShippingMethod`.`original_media_id` AS `shipping_method.appShippingMethod.originalMediaId`, `shipping_method.appShippingMethod`.`created_at` AS `shipping_method.appShippingMethod.createdAt`, `shipping_method.appShippingMethod`.`updated_at` AS `shipping_method.appShippingMethod.updatedAt`, `shipping_method`.`technical_name` AS `shipping_method.technicalName`, `shipping_method`.`created_at` AS `shipping_method.createdAt`, `shipping_method`.`updated_at` AS `shipping_method.updatedAt`, `shipping_method.media`.`id` AS `shipping_method.media.id`, `shipping_method.media`.`user_id` AS `shipping_method.media.userId`, `shipping_method.media`.`media_folder_id` AS `shipping_method.media.mediaFolderId`, `shipping_method.media`.`mime_type` AS `shipping_method.media.mimeType`, `shipping_method.media`.`file_extension` AS `shipping_method.media.fileExtension`, `shipping_method.media`.`uploaded_at` AS `shipping_method.media.uploadedAt`, `shipping_method.media`.`file_name` AS `shipping_method.media.fileName`, `shipping_method.media`.`file_size` AS `shipping_method.media.fileSize`, `shipping_method.media`.`media_type` AS `shipping_method.media.mediaTypeRaw`, `shipping_method.media`.`meta_data` AS `shipping_method.media.metaData`, `shipping_method.media`.`config` AS `shipping_method.media.config`, `shipping_method.media`.`path` AS `shipping_method.media.path`, `shipping_method.media`.`private` AS `shipping_method.media.private`, `shipping_method.media`.`thumbnails_ro` AS `shipping_method.media.thumbnailsRo`, `shipping_method.media`.`created_at` AS `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` AS `shipping_method.media.updatedAt`, `shipping_method.media.translation.title`, COALESCE(`shipping_method.media.translation.title`,`shipping_method.media.translation.title`) AS `shipping_method.media.title`, `shipping_method.media.translation.alt`, COALESCE(`shipping_method.media.translation.alt`,`shipping_method.media.translation.alt`) AS `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, COALESCE(`shipping_method.media.translation.customFields`,`shipping_method.media.translation.customFields`) AS `shipping_method.media.customFields`, `shipping_method.media.translation.createdAt`, `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation.mediaId`, `shipping_method.media.translation.languageId`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.name`,`shipping_method.translation.name`) AS `shipping_method.name`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.description`,`shipping_method.translation.description`) AS `shipping_method.description`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.trackingUrl`,`shipping_method.translation.trackingUrl`) AS `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.customFields`,`shipping_method.translation.customFields`) AS `shipping_method.customFields`, `shipping_method.translation.createdAt`, `shipping_method.translation.updatedAt`, `shipping_method.translation.shippingMethodId`, `shipping_method.translation.languageId` FROM `shipping_method` LEFT JOIN (SELECT `shipping_method.translation`.shipping_method_id, `shipping_method.translation`.name AS `shipping_method.translation.name`, `shipping_method.translation`.description AS `shipping_method.translation.description`, `shipping_method.translation`.tracking_url AS `shipping_method.translation.trackingUrl`, `shipping_method.translation`.custom_fields AS `shipping_method.translation.customFields`, `shipping_method.translation`.created_at AS `shipping_method.translation.createdAt`, `shipping_method.translation`.updated_at AS `shipping_method.translation.updatedAt`, `shipping_method.translation`.shipping_method_id AS `shipping_method.translation.shippingMethodId`, `shipping_method.translation`.language_id AS `shipping_method.translation.languageId` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.language_id = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method`.`id` = `shipping_method.appShippingMethod`.`shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation`.delivery_time_id, `shipping_method.deliveryTime.translation`.name AS `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation`.custom_fields AS `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation`.created_at AS `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation`.updated_at AS `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation`.delivery_time_id AS `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation`.language_id AS `shipping_method.deliveryTime.translation.languageId` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation`.language_id = ?) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.media_id, `shipping_method.media.translation`.title AS `shipping_method.media.translation.title`, `shipping_method.media.translation`.alt AS `shipping_method.media.translation.alt`, `shipping_method.media.translation`.custom_fields AS `shipping_method.media.translation.customFields`, `shipping_method.media.translation`.created_at AS `shipping_method.media.translation.createdAt`, `shipping_method.media.translation`.updated_at AS `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation`.media_id AS `shipping_method.media.translation.mediaId`, `shipping_method.media.translation`.language_id AS `shipping_method.media.translation.languageId` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation`.language_id = ?) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x1A>ÍãïL@\v¢E²<ÔÛêÂ" ] |
||||||||||||||||||||||||
|
2.13 ms (3.33%) |
1 |
# base-context-factory::sales-channel::read 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.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`, `sales_channel`.`created_at` AS `sales_channel.createdAt`, `sales_channel`.`updated_at` AS `sales_channel.updatedAt`, `sales_channel.currency`.`id` AS `sales_channel.currency.id`, `sales_channel.currency`.`factor` AS `sales_channel.currency.factor`, `sales_channel.currency`.`symbol` AS `sales_channel.currency.symbol`, `sales_channel.currency`.`iso_code` AS `sales_channel.currency.isoCode`, `sales_channel.currency`.`position` AS `sales_channel.currency.position`, `sales_channel.currency`.`tax_free_from` AS `sales_channel.currency.taxFreeFrom`, `sales_channel.currency`.`item_rounding` AS `sales_channel.currency.itemRounding`, `sales_channel.currency`.`total_rounding` AS `sales_channel.currency.totalRounding`, `sales_channel.currency`.`created_at` AS `sales_channel.currency.createdAt`, `sales_channel.currency`.`updated_at` AS `sales_channel.currency.updatedAt`, `sales_channel.currency.translation.shortName`, COALESCE(`sales_channel.currency.translation.shortName`,`sales_channel.currency.translation.shortName`) AS `sales_channel.currency.shortName`, `sales_channel.currency.translation.name`, COALESCE(`sales_channel.currency.translation.name`,`sales_channel.currency.translation.name`) AS `sales_channel.currency.name`, `sales_channel.currency.translation.customFields`, COALESCE(`sales_channel.currency.translation.customFields`,`sales_channel.currency.translation.customFields`) AS `sales_channel.currency.customFields`, `sales_channel.currency.translation.createdAt`, `sales_channel.currency.translation.updatedAt`, `sales_channel.currency.translation.currencyId`, `sales_channel.currency.translation.languageId`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.name`,`sales_channel.translation.name`) AS `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) AS `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) AS `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) AS `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) AS `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) AS `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) AS `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) AS `sales_channel.customFields`, `sales_channel.translation.createdAt`, `sales_channel.translation.updatedAt`, `sales_channel.translation.salesChannelId`, `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name AS `sales_channel.translation.name`, `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`, `sales_channel.translation`.custom_fields AS `sales_channel.translation.customFields`, `sales_channel.translation`.created_at AS `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at AS `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id AS `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id AS `sales_channel.translation.languageId` 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` LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel`.`analytics_id` = `sales_channel.analytics`.`id` LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel`.`currency_id` = `sales_channel.currency`.`id` LEFT JOIN (SELECT `sales_channel.currency.translation`.currency_id, `sales_channel.currency.translation`.short_name AS `sales_channel.currency.translation.shortName`, `sales_channel.currency.translation`.name AS `sales_channel.currency.translation.name`, `sales_channel.currency.translation`.custom_fields AS `sales_channel.currency.translation.customFields`, `sales_channel.currency.translation`.created_at AS `sales_channel.currency.translation.createdAt`, `sales_channel.currency.translation`.updated_at AS `sales_channel.currency.translation.updatedAt`, `sales_channel.currency.translation`.currency_id AS `sales_channel.currency.translation.currencyId`, `sales_channel.currency.translation`.language_id AS `sales_channel.currency.translation.languageId` FROM `currency_translation` `sales_channel.currency.translation` WHERE `sales_channel.currency.translation`.language_id = ?) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation`.`currency_id` = `sales_channel.currency`.`id` WHERE `sales_channel`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"ð\0Á…®F¢•o=õ–t\x02Ê" ] |
||||||||||||||||||||||||
|
2.09 ms (3.27%) |
2 |
# header::navigation::read 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.media`.`id` AS `category.media.id`, `category.media`.`user_id` AS `category.media.userId`, `category.media`.`media_folder_id` AS `category.media.mediaFolderId`, `category.media`.`mime_type` AS `category.media.mimeType`, `category.media`.`file_extension` AS `category.media.fileExtension`, `category.media`.`uploaded_at` AS `category.media.uploadedAt`, `category.media`.`file_name` AS `category.media.fileName`, `category.media`.`file_size` AS `category.media.fileSize`, `category.media`.`media_type` AS `category.media.mediaTypeRaw`, `category.media`.`meta_data` AS `category.media.metaData`, `category.media`.`config` AS `category.media.config`, `category.media`.`path` AS `category.media.path`, `category.media`.`private` AS `category.media.private`, `category.media`.`thumbnails_ro` AS `category.media.thumbnailsRo`, `category.media`.`created_at` AS `category.media.createdAt`, `category.media`.`updated_at` AS `category.media.updatedAt`, `category.media.translation.title`, COALESCE(`category.media.translation.title`,`category.media.translation.title`) AS `category.media.title`, `category.media.translation.alt`, COALESCE(`category.media.translation.alt`,`category.media.translation.alt`) AS `category.media.alt`, `category.media.translation.customFields`, COALESCE(`category.media.translation.customFields`,`category.media.translation.customFields`) AS `category.media.customFields`, `category.media.translation.createdAt`, `category.media.translation.updatedAt`, `category.media.translation.mediaId`, `category.media.translation.languageId`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) AS `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) AS `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) AS `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) AS `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) AS `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) AS `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) AS `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) AS `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) AS `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) AS `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) AS `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) AS `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name AS `category.translation.name`, `category.translation`.breadcrumb AS `category.translation.breadcrumb`, `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`, `category.translation`.custom_fields AS `category.translation.customFields`, `category.translation`.created_at AS `category.translation.createdAt`, `category.translation`.updated_at AS `category.translation.updatedAt`, `category.translation`.category_id AS `category.translation.categoryId`, `category.translation`.language_id AS `category.translation.languageId`, `category.translation`.category_version_id AS `category.translation.categoryVersionId` 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 LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title AS `category.media.translation.title`, `category.media.translation`.alt AS `category.media.translation.alt`, `category.media.translation`.custom_fields AS `category.media.translation.customFields`, `category.media.translation`.created_at AS `category.media.translation.createdAt`, `category.media.translation`.updated_at AS `category.media.translation.updatedAt`, `category.media.translation`.media_id AS `category.media.translation.mediaId`, `category.media.translation`.language_id AS `category.media.translation.languageId` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.language_id = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND ((`category`.`path` LIKE ? AND (`category`.`level` > ? AND `category`.`level` <= ?)))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" "%|c4992b218cdc4fabb30f55037ebe11e5|%" 1 5 ] |
||||||||||||||||||||||||
|
2.01 ms (3.14%) |
1 |
# base-context-factory::payment-method::read SELECT `payment_method`.`id` AS `payment_method.id`, `payment_method`.`plugin_id` AS `payment_method.pluginId`, `payment_method`.`handler_identifier` AS `payment_method.handlerIdentifier`, `payment_method`.`position` AS `payment_method.position`, `payment_method`.`active` AS `payment_method.active`, `payment_method`.`after_order_enabled` AS `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` AS `payment_method.availabilityRuleId`, `payment_method`.`media_id` AS `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` AS `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` AS `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` AS `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` AS `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` AS `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` AS `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` AS `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` AS `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`recurring_url` AS `payment_method.appPaymentMethod.recurringUrl`, `payment_method.appPaymentMethod`.`app_id` AS `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` AS `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` AS `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` AS `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` AS `payment_method.appPaymentMethod.updatedAt`, `payment_method`.`technical_name` AS `payment_method.technicalName`, `payment_method`.`created_at` AS `payment_method.createdAt`, `payment_method`.`updated_at` AS `payment_method.updatedAt`, `payment_method.media`.`id` AS `payment_method.media.id`, `payment_method.media`.`user_id` AS `payment_method.media.userId`, `payment_method.media`.`media_folder_id` AS `payment_method.media.mediaFolderId`, `payment_method.media`.`mime_type` AS `payment_method.media.mimeType`, `payment_method.media`.`file_extension` AS `payment_method.media.fileExtension`, `payment_method.media`.`uploaded_at` AS `payment_method.media.uploadedAt`, `payment_method.media`.`file_name` AS `payment_method.media.fileName`, `payment_method.media`.`file_size` AS `payment_method.media.fileSize`, `payment_method.media`.`media_type` AS `payment_method.media.mediaTypeRaw`, `payment_method.media`.`meta_data` AS `payment_method.media.metaData`, `payment_method.media`.`config` AS `payment_method.media.config`, `payment_method.media`.`path` AS `payment_method.media.path`, `payment_method.media`.`private` AS `payment_method.media.private`, `payment_method.media`.`thumbnails_ro` AS `payment_method.media.thumbnailsRo`, `payment_method.media`.`created_at` AS `payment_method.media.createdAt`, `payment_method.media`.`updated_at` AS `payment_method.media.updatedAt`, `payment_method.media.translation.title`, COALESCE(`payment_method.media.translation.title`,`payment_method.media.translation.title`) AS `payment_method.media.title`, `payment_method.media.translation.alt`, COALESCE(`payment_method.media.translation.alt`,`payment_method.media.translation.alt`) AS `payment_method.media.alt`, `payment_method.media.translation.customFields`, COALESCE(`payment_method.media.translation.customFields`,`payment_method.media.translation.customFields`) AS `payment_method.media.customFields`, `payment_method.media.translation.createdAt`, `payment_method.media.translation.updatedAt`, `payment_method.media.translation.mediaId`, `payment_method.media.translation.languageId`, `payment_method.translation.name`, COALESCE(`payment_method.translation.name`,`payment_method.translation.name`) AS `payment_method.name`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableName`) AS `payment_method.distinguishableName`, `payment_method.translation.description`, COALESCE(`payment_method.translation.description`,`payment_method.translation.description`) AS `payment_method.description`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.customFields`,`payment_method.translation.customFields`) AS `payment_method.customFields`, `payment_method.translation.createdAt`, `payment_method.translation.updatedAt`, `payment_method.translation.paymentMethodId`, `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation`.payment_method_id, `payment_method.translation`.name AS `payment_method.translation.name`, `payment_method.translation`.distinguishable_name AS `payment_method.translation.distinguishableName`, `payment_method.translation`.description AS `payment_method.translation.description`, `payment_method.translation`.custom_fields AS `payment_method.translation.customFields`, `payment_method.translation`.created_at AS `payment_method.translation.createdAt`, `payment_method.translation`.updated_at AS `payment_method.translation.updatedAt`, `payment_method.translation`.payment_method_id AS `payment_method.translation.paymentMethodId`, `payment_method.translation`.language_id AS `payment_method.translation.languageId` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.language_id = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.media_id, `payment_method.media.translation`.title AS `payment_method.media.translation.title`, `payment_method.media.translation`.alt AS `payment_method.media.translation.alt`, `payment_method.media.translation`.custom_fields AS `payment_method.media.translation.customFields`, `payment_method.media.translation`.created_at AS `payment_method.media.translation.createdAt`, `payment_method.media.translation`.updated_at AS `payment_method.media.translation.updatedAt`, `payment_method.media.translation`.media_id AS `payment_method.media.translation.mediaId`, `payment_method.media.translation`.language_id AS `payment_method.media.translation.languageId` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation`.language_id = ?) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b""" &´\n ™ÒðMY›Zï´³ÍÖq """ ] |
||||||||||||||||||||||||
|
1.93 ms (3.01%) |
5 |
SELECT LOWER(HEX(`script`.`app_id`)) AS `app_id`, `script`.`name` AS name, `script`.`script` AS script, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` = 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters:
[] |
||||||||||||||||||||||||
|
1.67 ms (2.61%) |
2 |
# header::navigation::read 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.media`.`id` AS `category.media.id`, `category.media`.`user_id` AS `category.media.userId`, `category.media`.`media_folder_id` AS `category.media.mediaFolderId`, `category.media`.`mime_type` AS `category.media.mimeType`, `category.media`.`file_extension` AS `category.media.fileExtension`, `category.media`.`uploaded_at` AS `category.media.uploadedAt`, `category.media`.`file_name` AS `category.media.fileName`, `category.media`.`file_size` AS `category.media.fileSize`, `category.media`.`media_type` AS `category.media.mediaTypeRaw`, `category.media`.`meta_data` AS `category.media.metaData`, `category.media`.`config` AS `category.media.config`, `category.media`.`path` AS `category.media.path`, `category.media`.`private` AS `category.media.private`, `category.media`.`thumbnails_ro` AS `category.media.thumbnailsRo`, `category.media`.`created_at` AS `category.media.createdAt`, `category.media`.`updated_at` AS `category.media.updatedAt`, `category.media.translation.title`, COALESCE(`category.media.translation.title`,`category.media.translation.title`) AS `category.media.title`, `category.media.translation.alt`, COALESCE(`category.media.translation.alt`,`category.media.translation.alt`) AS `category.media.alt`, `category.media.translation.customFields`, COALESCE(`category.media.translation.customFields`,`category.media.translation.customFields`) AS `category.media.customFields`, `category.media.translation.createdAt`, `category.media.translation.updatedAt`, `category.media.translation.mediaId`, `category.media.translation.languageId`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) AS `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) AS `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) AS `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) AS `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) AS `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) AS `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) AS `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) AS `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) AS `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) AS `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) AS `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) AS `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name AS `category.translation.name`, `category.translation`.breadcrumb AS `category.translation.breadcrumb`, `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`, `category.translation`.custom_fields AS `category.translation.customFields`, `category.translation`.created_at AS `category.translation.createdAt`, `category.translation`.updated_at AS `category.translation.updatedAt`, `category.translation`.category_id AS `category.translation.categoryId`, `category.translation`.language_id AS `category.translation.languageId`, `category.translation`.category_version_id AS `category.translation.categoryVersionId` 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 LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title AS `category.media.translation.title`, `category.media.translation`.alt AS `category.media.translation.alt`, `category.media.translation`.custom_fields AS `category.media.translation.customFields`, `category.media.translation`.created_at AS `category.media.translation.createdAt`, `category.media.translation`.updated_at AS `category.media.translation.updatedAt`, `category.media.translation`.media_id AS `category.media.translation.mediaId`, `category.media.translation`.language_id AS `category.media.translation.languageId` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.language_id = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"Ä™+!ŒÜO«³\x0FU\x03~¾\x11å" ] |
||||||||||||||||||||||||
|
1.55 ms (2.42%) |
1 |
# base-context-factory::country::read 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`.`created_at` AS `country.createdAt`, `country`.`updated_at` AS `country.updatedAt`, `country.translation.name`, COALESCE(`country.translation.name`,`country.translation.name`) AS `country.name`, `country.translation.addressFormat`, COALESCE(`country.translation.addressFormat`,`country.translation.addressFormat`) AS `country.addressFormat`, `country.translation.customFields`, COALESCE(`country.translation.customFields`,`country.translation.customFields`) AS `country.customFields`, `country.translation.createdAt`, `country.translation.updatedAt`, `country.translation.countryId`, `country.translation.languageId` FROM `country` LEFT JOIN (SELECT `country.translation`.country_id, `country.translation`.name AS `country.translation.name`, `country.translation`.address_format AS `country.translation.addressFormat`, `country.translation`.custom_fields AS `country.translation.customFields`, `country.translation`.created_at AS `country.translation.createdAt`, `country.translation`.updated_at AS `country.translation.updatedAt`, `country.translation`.country_id AS `country.translation.countryId`, `country.translation`.language_id AS `country.translation.languageId` 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"é==\fõÃA¢¸õ\x0E\x13,>_\x0E" ] |
||||||||||||||||||||||||
|
1.34 ms (2.10%) |
1 |
# seo_url::replacement 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/6cdff63428dc415abf4c13e09c7340e5" "/navigation/bbf95e6e8295425b88b193c7a79f0a7d" "/navigation/28bccdc7244d426a93a199db2b374fa3" "/navigation/d3c9f7fa61db449283aae7878450be75" b"/»_ââšMpªXTÎ|ãâ\v" b"ð\0Á…®F¢•o=õ–t\x02Ê" ] |
||||||||||||||||||||||||
|
1.25 ms (1.96%) |
1 |
# theme-service::load-config::read SELECT `theme`.`id` AS `theme.id`, `theme`.`technical_name` AS `theme.technicalName`, `theme`.`name` AS `theme.name`, `theme`.`author` AS `theme.author`, `theme`.`preview_media_id` AS `theme.previewMediaId`, `theme`.`parent_theme_id` AS `theme.parentThemeId`, `theme`.`theme_json` AS `theme.themeJson`, `theme`.`base_config` AS `theme.baseConfig`, `theme`.`config_values` AS `theme.configValues`, `theme`.`active` AS `theme.active`, `theme`.`created_at` AS `theme.createdAt`, `theme`.`updated_at` AS `theme.updatedAt`, `theme.translation.description`, COALESCE(`theme.translation.description`,`theme.translation.description`) AS `theme.description`, `theme.translation.labels`, COALESCE(`theme.translation.labels`,`theme.translation.labels`) AS `theme.labels`, `theme.translation.helpTexts`, COALESCE(`theme.translation.helpTexts`,`theme.translation.helpTexts`) AS `theme.helpTexts`, `theme.translation.customFields`, COALESCE(`theme.translation.customFields`,`theme.translation.customFields`) AS `theme.customFields`, `theme.translation.createdAt`, `theme.translation.updatedAt`, `theme.translation.themeId`, `theme.translation.languageId` FROM `theme` LEFT JOIN (SELECT `theme.translation`.theme_id, `theme.translation`.description AS `theme.translation.description`, `theme.translation`.labels AS `theme.translation.labels`, `theme.translation`.help_texts AS `theme.translation.helpTexts`, `theme.translation`.custom_fields AS `theme.translation.customFields`, `theme.translation`.created_at AS `theme.translation.createdAt`, `theme.translation`.updated_at AS `theme.translation.updatedAt`, `theme.translation`.theme_id AS `theme.translation.themeId`, `theme.translation`.language_id AS `theme.translation.languageId` FROM `theme_translation` `theme.translation` WHERE `theme.translation`.language_id = ?) `theme.theme_translation` ON `theme.theme_translation`.`theme_id` = `theme`.`id`
Parameters:
[
b"/»_ââšMpªXTÎ|ãâ\v"
]
|
||||||||||||||||||||||||
|
1.20 ms (1.87%) |
1 |
SELECT CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') `key`, CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') url, LOWER(HEX(domain.id)) id, LOWER(HEX(sales_channel.id)) salesChannelId, LOWER(HEX(sales_channel.type_id)) typeId, LOWER(HEX(domain.snippet_set_id)) snippetSetId, LOWER(HEX(domain.currency_id)) currencyId, LOWER(HEX(domain.language_id)) languageId, LOWER(HEX(theme.id)) themeId, sales_channel.maintenance maintenance, sales_channel.maintenance_ip_whitelist maintenanceIpWhitelist, snippet_set.iso AS locale, theme.technical_name AS themeName, parentTheme.technical_name AS parentThemeName FROM sales_channel INNER JOIN sales_channel_domain domain ON domain.sales_channel_id = sales_channel.id LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id INNER JOIN snippet_set snippet_set ON snippet_set.id = domain.snippet_set_id LEFT JOIN theme theme ON theme_sales_channel.theme_id = theme.id LEFT JOIN theme parentTheme ON theme.parent_theme_id = parentTheme.id WHERE (sales_channel.type_id = UNHEX(?)) AND (sales_channel.active)
Parameters:
[
"8a243080f92e4c719546314b577cf82b"
]
|
||||||||||||||||||||||||
|
1.19 ms (1.86%) |
1 |
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE ?
Parameters:
[
"payload"
]
|
||||||||||||||||||||||||
|
1.17 ms (1.83%) |
1 |
# category::cms-page::association::sections::association::blocks::association::slots::read SELECT `cms_slot`.`id` AS `cms_slot.id`, `cms_slot`.`version_id` AS `cms_slot.versionId`, `cms_slot`.`type` AS `cms_slot.type`, `cms_slot`.`slot` AS `cms_slot.slot`, `cms_slot`.`locked` AS `cms_slot.locked`, `cms_slot`.`cms_block_id` AS `cms_slot.blockId`, `cms_slot`.`cms_block_version_id` AS `cms_slot.cmsBlockVersionId`, `cms_slot`.`created_at` AS `cms_slot.createdAt`, `cms_slot`.`updated_at` AS `cms_slot.updatedAt`, `cms_slot.translation.config`, COALESCE(`cms_slot.translation.config`,`cms_slot.translation.config`) AS `cms_slot.config`, `cms_slot.translation.customFields`, COALESCE(`cms_slot.translation.customFields`,`cms_slot.translation.customFields`) AS `cms_slot.customFields`, `cms_slot.translation.createdAt`, `cms_slot.translation.updatedAt`, `cms_slot.translation.cmsSlotId`, `cms_slot.translation.languageId`, `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation`.cms_slot_id, `cms_slot.translation`.cms_slot_version_id, `cms_slot.translation`.config AS `cms_slot.translation.config`, `cms_slot.translation`.custom_fields AS `cms_slot.translation.customFields`, `cms_slot.translation`.created_at AS `cms_slot.translation.createdAt`, `cms_slot.translation`.updated_at AS `cms_slot.translation.updatedAt`, `cms_slot.translation`.cms_slot_id AS `cms_slot.translation.cmsSlotId`, `cms_slot.translation`.language_id AS `cms_slot.translation.languageId`, `cms_slot.translation`.cms_slot_version_id AS `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation`.language_id = ?) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` AND `cms_slot.cms_slot_translation`.cms_slot_version_id = `cms_slot`.version_id WHERE (`cms_slot`.`version_id` = ?) AND ((`cms_slot`.`cms_block_id` IN (?, ?, ?)))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b":<ð>ð·J\e³§’F•[êx" b"Ä\x12~)‹\rK†š\x14:\eŠÞùË" b"Ç\x04P|Æ¥K\x08§\x12±\x03ºÃˆÿ" ] |
||||||||||||||||||||||||
|
1.17 ms (1.83%) |
1 |
# generic-page::shipping-methods::read SELECT `shipping_method`.`id` AS `shipping_method.id`, `shipping_method`.`active` AS `shipping_method.active`, `shipping_method`.`position` AS `shipping_method.position`, `shipping_method`.`availability_rule_id` AS `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` AS `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` AS `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` AS `shipping_method.taxType`, `shipping_method`.`tax_id` AS `shipping_method.taxId`, `shipping_method.deliveryTime`.`id` AS `shipping_method.deliveryTime.id`, `shipping_method.deliveryTime`.`min` AS `shipping_method.deliveryTime.min`, `shipping_method.deliveryTime`.`max` AS `shipping_method.deliveryTime.max`, `shipping_method.deliveryTime`.`unit` AS `shipping_method.deliveryTime.unit`, `shipping_method.deliveryTime`.`created_at` AS `shipping_method.deliveryTime.createdAt`, `shipping_method.deliveryTime`.`updated_at` AS `shipping_method.deliveryTime.updatedAt`, `shipping_method.deliveryTime.translation.name`, COALESCE(`shipping_method.deliveryTime.translation.name`,`shipping_method.deliveryTime.translation.name`) AS `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.customFields`,`shipping_method.deliveryTime.translation.customFields`) AS `shipping_method.deliveryTime.customFields`, `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation.languageId`, `shipping_method.appShippingMethod`.`id` AS `shipping_method.appShippingMethod.id`, `shipping_method.appShippingMethod`.`app_name` AS `shipping_method.appShippingMethod.appName`, `shipping_method.appShippingMethod`.`identifier` AS `shipping_method.appShippingMethod.identifier`, `shipping_method.appShippingMethod`.`app_id` AS `shipping_method.appShippingMethod.appId`, `shipping_method.appShippingMethod`.`shipping_method_id` AS `shipping_method.appShippingMethod.shippingMethodId`, `shipping_method.appShippingMethod`.`original_media_id` AS `shipping_method.appShippingMethod.originalMediaId`, `shipping_method.appShippingMethod`.`created_at` AS `shipping_method.appShippingMethod.createdAt`, `shipping_method.appShippingMethod`.`updated_at` AS `shipping_method.appShippingMethod.updatedAt`, `shipping_method`.`technical_name` AS `shipping_method.technicalName`, `shipping_method`.`created_at` AS `shipping_method.createdAt`, `shipping_method`.`updated_at` AS `shipping_method.updatedAt`, `shipping_method.media`.`id` AS `shipping_method.media.id`, `shipping_method.media`.`user_id` AS `shipping_method.media.userId`, `shipping_method.media`.`media_folder_id` AS `shipping_method.media.mediaFolderId`, `shipping_method.media`.`mime_type` AS `shipping_method.media.mimeType`, `shipping_method.media`.`file_extension` AS `shipping_method.media.fileExtension`, `shipping_method.media`.`uploaded_at` AS `shipping_method.media.uploadedAt`, `shipping_method.media`.`file_name` AS `shipping_method.media.fileName`, `shipping_method.media`.`file_size` AS `shipping_method.media.fileSize`, `shipping_method.media`.`media_type` AS `shipping_method.media.mediaTypeRaw`, `shipping_method.media`.`meta_data` AS `shipping_method.media.metaData`, `shipping_method.media`.`config` AS `shipping_method.media.config`, `shipping_method.media`.`path` AS `shipping_method.media.path`, `shipping_method.media`.`private` AS `shipping_method.media.private`, `shipping_method.media`.`thumbnails_ro` AS `shipping_method.media.thumbnailsRo`, `shipping_method.media`.`created_at` AS `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` AS `shipping_method.media.updatedAt`, `shipping_method.media.translation.title`, COALESCE(`shipping_method.media.translation.title`,`shipping_method.media.translation.title`) AS `shipping_method.media.title`, `shipping_method.media.translation.alt`, COALESCE(`shipping_method.media.translation.alt`,`shipping_method.media.translation.alt`) AS `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, COALESCE(`shipping_method.media.translation.customFields`,`shipping_method.media.translation.customFields`) AS `shipping_method.media.customFields`, `shipping_method.media.translation.createdAt`, `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation.mediaId`, `shipping_method.media.translation.languageId`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.name`,`shipping_method.translation.name`) AS `shipping_method.name`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.description`,`shipping_method.translation.description`) AS `shipping_method.description`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.trackingUrl`,`shipping_method.translation.trackingUrl`) AS `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.customFields`,`shipping_method.translation.customFields`) AS `shipping_method.customFields`, `shipping_method.translation.createdAt`, `shipping_method.translation.updatedAt`, `shipping_method.translation.shippingMethodId`, `shipping_method.translation.languageId` FROM `shipping_method` LEFT JOIN (SELECT `shipping_method.translation`.shipping_method_id, `shipping_method.translation`.name AS `shipping_method.translation.name`, `shipping_method.translation`.description AS `shipping_method.translation.description`, `shipping_method.translation`.tracking_url AS `shipping_method.translation.trackingUrl`, `shipping_method.translation`.custom_fields AS `shipping_method.translation.customFields`, `shipping_method.translation`.created_at AS `shipping_method.translation.createdAt`, `shipping_method.translation`.updated_at AS `shipping_method.translation.updatedAt`, `shipping_method.translation`.shipping_method_id AS `shipping_method.translation.shippingMethodId`, `shipping_method.translation`.language_id AS `shipping_method.translation.languageId` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.language_id = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method`.`id` = `shipping_method.appShippingMethod`.`shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation`.delivery_time_id, `shipping_method.deliveryTime.translation`.name AS `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation`.custom_fields AS `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation`.created_at AS `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation`.updated_at AS `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation`.delivery_time_id AS `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation`.language_id AS `shipping_method.deliveryTime.translation.languageId` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation`.language_id = ?) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.media_id, `shipping_method.media.translation`.title AS `shipping_method.media.translation.title`, `shipping_method.media.translation`.alt AS `shipping_method.media.translation.alt`, `shipping_method.media.translation`.custom_fields AS `shipping_method.media.translation.customFields`, `shipping_method.media.translation`.created_at AS `shipping_method.media.translation.createdAt`, `shipping_method.media.translation`.updated_at AS `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation`.media_id AS `shipping_method.media.translation.mediaId`, `shipping_method.media.translation`.language_id AS `shipping_method.media.translation.languageId` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation`.language_id = ?) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x1A>ÍãïL@\v¢E²<ÔÛêÂ" ] |
||||||||||||||||||||||||
|
1.14 ms (1.79%) |
1 |
# category::cms-page::association::sections::association::blocks::read SELECT `cms_block`.`id` AS `cms_block.id`, `cms_block`.`position` AS `cms_block.position`, `cms_block`.`type` AS `cms_block.type`, `cms_block`.`locked` AS `cms_block.locked`, `cms_block`.`name` AS `cms_block.name`, `cms_block`.`section_position` AS `cms_block.sectionPosition`, `cms_block`.`margin_top` AS `cms_block.marginTop`, `cms_block`.`margin_bottom` AS `cms_block.marginBottom`, `cms_block`.`margin_left` AS `cms_block.marginLeft`, `cms_block`.`margin_right` AS `cms_block.marginRight`, `cms_block`.`background_color` AS `cms_block.backgroundColor`, `cms_block`.`background_media_id` AS `cms_block.backgroundMediaId`, `cms_block`.`background_media_mode` AS `cms_block.backgroundMediaMode`, `cms_block`.`css_class` AS `cms_block.cssClass`, `cms_block`.`visibility` AS `cms_block.visibility`, `cms_block`.`cms_section_id` AS `cms_block.sectionId`, `cms_block`.`custom_fields` AS `cms_block.customFields`, `cms_block`.`version_id` AS `cms_block.versionId`, `cms_block`.`cms_section_version_id` AS `cms_block.cmsSectionVersionId`, `cms_block`.`created_at` AS `cms_block.createdAt`, `cms_block`.`updated_at` AS `cms_block.updatedAt`, `cms_block.backgroundMedia`.`id` AS `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` AS `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` AS `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` AS `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` AS `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` AS `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` AS `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` AS `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` AS `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` AS `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`config` AS `cms_block.backgroundMedia.config`, `cms_block.backgroundMedia`.`path` AS `cms_block.backgroundMedia.path`, `cms_block.backgroundMedia`.`private` AS `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` AS `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`created_at` AS `cms_block.backgroundMedia.createdAt`, `cms_block.backgroundMedia`.`updated_at` AS `cms_block.backgroundMedia.updatedAt`, `cms_block.backgroundMedia.translation.title`, COALESCE(`cms_block.backgroundMedia.translation.title`,`cms_block.backgroundMedia.translation.title`) AS `cms_block.backgroundMedia.title`, `cms_block.backgroundMedia.translation.alt`, COALESCE(`cms_block.backgroundMedia.translation.alt`,`cms_block.backgroundMedia.translation.alt`) AS `cms_block.backgroundMedia.alt`, `cms_block.backgroundMedia.translation.customFields`, COALESCE(`cms_block.backgroundMedia.translation.customFields`,`cms_block.backgroundMedia.translation.customFields`) AS `cms_block.backgroundMedia.customFields`, `cms_block.backgroundMedia.translation.createdAt`, `cms_block.backgroundMedia.translation.updatedAt`, `cms_block.backgroundMedia.translation.mediaId`, `cms_block.backgroundMedia.translation.languageId` FROM `cms_block` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation`.media_id, `cms_block.backgroundMedia.translation`.title AS `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.alt AS `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation`.custom_fields AS `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation`.created_at AS `cms_block.backgroundMedia.translation.createdAt`, `cms_block.backgroundMedia.translation`.updated_at AS `cms_block.backgroundMedia.translation.updatedAt`, `cms_block.backgroundMedia.translation`.media_id AS `cms_block.backgroundMedia.translation.mediaId`, `cms_block.backgroundMedia.translation`.language_id AS `cms_block.backgroundMedia.translation.languageId` FROM `media_translation` `cms_block.backgroundMedia.translation` WHERE `cms_block.backgroundMedia.translation`.language_id = ?) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation`.`media_id` = `cms_block.backgroundMedia`.`id` WHERE (`cms_block`.`version_id` = ?) AND ((`cms_block`.`cms_section_id` IN (?, ?)))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b""" '\fé§2\x10Näš\x0E\n J3ïÍý """ b"µ└\x18ðõ.Hıÿ ═r0aü" ] |
||||||||||||||||||||||||
|
1.08 ms (1.68%) |
1 |
# category::cms-page::read SELECT `cms_page`.`id` AS `cms_page.id`, `cms_page`.`version_id` AS `cms_page.versionId`, `cms_page`.`type` AS `cms_page.type`, `cms_page`.`entity` AS `cms_page.entity`, `cms_page`.`css_class` AS `cms_page.cssClass`, `cms_page`.`config` AS `cms_page.config`, `cms_page`.`preview_media_id` AS `cms_page.previewMediaId`, `cms_page`.`locked` AS `cms_page.locked`, `cms_page`.`created_at` AS `cms_page.createdAt`, `cms_page`.`updated_at` AS `cms_page.updatedAt`, `cms_page.translation.name`, COALESCE(`cms_page.translation.name`,`cms_page.translation.name`) AS `cms_page.name`, `cms_page.translation.customFields`, COALESCE(`cms_page.translation.customFields`,`cms_page.translation.customFields`) AS `cms_page.customFields`, `cms_page.translation.createdAt`, `cms_page.translation.updatedAt`, `cms_page.translation.cmsPageId`, `cms_page.translation.languageId`, `cms_page.translation.cmsPageVersionId` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.cms_page_id, `cms_page.translation`.cms_page_version_id, `cms_page.translation`.name AS `cms_page.translation.name`, `cms_page.translation`.custom_fields AS `cms_page.translation.customFields`, `cms_page.translation`.created_at AS `cms_page.translation.createdAt`, `cms_page.translation`.updated_at AS `cms_page.translation.updatedAt`, `cms_page.translation`.cms_page_id AS `cms_page.translation.cmsPageId`, `cms_page.translation`.language_id AS `cms_page.translation.languageId`, `cms_page.translation`.cms_page_version_id AS `cms_page.translation.cmsPageVersionId` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.language_id = ?) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.cms_page_version_id = `cms_page`.version_id WHERE (`cms_page`.`version_id` = ?) AND (`cms_page`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"¾â^`SQEó¾…8ü]ÇA±" ] |
||||||||||||||||||||||||
|
1.03 ms (1.61%) |
1 |
# category::data::read 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.media`.`id` AS `category.media.id`, `category.media`.`user_id` AS `category.media.userId`, `category.media`.`media_folder_id` AS `category.media.mediaFolderId`, `category.media`.`mime_type` AS `category.media.mimeType`, `category.media`.`file_extension` AS `category.media.fileExtension`, `category.media`.`uploaded_at` AS `category.media.uploadedAt`, `category.media`.`file_name` AS `category.media.fileName`, `category.media`.`file_size` AS `category.media.fileSize`, `category.media`.`media_type` AS `category.media.mediaTypeRaw`, `category.media`.`meta_data` AS `category.media.metaData`, `category.media`.`config` AS `category.media.config`, `category.media`.`path` AS `category.media.path`, `category.media`.`private` AS `category.media.private`, `category.media`.`thumbnails_ro` AS `category.media.thumbnailsRo`, `category.media`.`created_at` AS `category.media.createdAt`, `category.media`.`updated_at` AS `category.media.updatedAt`, `category.media.translation.title`, COALESCE(`category.media.translation.title`,`category.media.translation.title`) AS `category.media.title`, `category.media.translation.alt`, COALESCE(`category.media.translation.alt`,`category.media.translation.alt`) AS `category.media.alt`, `category.media.translation.customFields`, COALESCE(`category.media.translation.customFields`,`category.media.translation.customFields`) AS `category.media.customFields`, `category.media.translation.createdAt`, `category.media.translation.updatedAt`, `category.media.translation.mediaId`, `category.media.translation.languageId`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) AS `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) AS `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) AS `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) AS `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) AS `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) AS `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) AS `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) AS `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) AS `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) AS `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) AS `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) AS `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name AS `category.translation.name`, `category.translation`.breadcrumb AS `category.translation.breadcrumb`, `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`, `category.translation`.custom_fields AS `category.translation.customFields`, `category.translation`.created_at AS `category.translation.createdAt`, `category.translation`.updated_at AS `category.translation.updatedAt`, `category.translation`.category_id AS `category.translation.categoryId`, `category.translation`.language_id AS `category.translation.languageId`, `category.translation`.category_version_id AS `category.translation.categoryVersionId` 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 LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title AS `category.media.translation.title`, `category.media.translation`.alt AS `category.media.translation.alt`, `category.media.translation`.custom_fields AS `category.media.translation.customFields`, `category.media.translation`.created_at AS `category.media.translation.createdAt`, `category.media.translation`.updated_at AS `category.media.translation.updatedAt`, `category.media.translation`.media_id AS `category.media.translation.mediaId`, `category.media.translation`.language_id AS `category.media.translation.languageId` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.language_id = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"Ä™+!ŒÜO«³\x0FU\x03~¾\x11å" ] |
||||||||||||||||||||||||
|
0.99 ms (1.55%) |
1 |
SELECT `media`.`id` AS `media.id`, `media`.`user_id` AS `media.userId`, `media`.`media_folder_id` AS `media.mediaFolderId`, `media`.`mime_type` AS `media.mimeType`, `media`.`file_extension` AS `media.fileExtension`, `media`.`uploaded_at` AS `media.uploadedAt`, `media`.`file_name` AS `media.fileName`, `media`.`file_size` AS `media.fileSize`, `media`.`media_type` AS `media.mediaTypeRaw`, `media`.`meta_data` AS `media.metaData`, `media`.`config` AS `media.config`, `media`.`path` AS `media.path`, `media`.`private` AS `media.private`, `media`.`thumbnails_ro` AS `media.thumbnailsRo`, `media`.`created_at` AS `media.createdAt`, `media`.`updated_at` AS `media.updatedAt`, `media.translation.title`, COALESCE(`media.translation.title`,`media.translation.title`) AS `media.title`, `media.translation.alt`, COALESCE(`media.translation.alt`,`media.translation.alt`) AS `media.alt`, `media.translation.customFields`, COALESCE(`media.translation.customFields`,`media.translation.customFields`) AS `media.customFields`, `media.translation.createdAt`, `media.translation.updatedAt`, `media.translation.mediaId`, `media.translation.languageId` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.media_id, `media.translation`.title AS `media.translation.title`, `media.translation`.alt AS `media.translation.alt`, `media.translation`.custom_fields AS `media.translation.customFields`, `media.translation`.created_at AS `media.translation.createdAt`, `media.translation`.updated_at AS `media.translation.updatedAt`, `media.translation`.media_id AS `media.translation.mediaId`, `media.translation`.language_id AS `media.translation.languageId` FROM `media_translation` `media.translation` WHERE `media.translation`.language_id = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" false true "product_download" b"m.¾\x02ìO†‡.Âó>\x0EF¥" b"év€¤Ì“CŽ²Â‡\x08\x16>|Á" b"#™\x19œ²eAÀ¶~Ž'oNñx" b"¤K{ÓÂ&A§ŒÃ<lV2k"" ] |
||||||||||||||||||||||||
|
0.95 ms (1.48%) |
1 |
# category::cms-page::association::sections::read SELECT `cms_section`.`id` AS `cms_section.id`, `cms_section`.`position` AS `cms_section.position`, `cms_section`.`type` AS `cms_section.type`, `cms_section`.`locked` AS `cms_section.locked`, `cms_section`.`name` AS `cms_section.name`, `cms_section`.`sizing_mode` AS `cms_section.sizingMode`, `cms_section`.`mobile_behavior` AS `cms_section.mobileBehavior`, `cms_section`.`background_color` AS `cms_section.backgroundColor`, `cms_section`.`background_media_id` AS `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` AS `cms_section.backgroundMediaMode`, `cms_section`.`css_class` AS `cms_section.cssClass`, `cms_section`.`cms_page_id` AS `cms_section.pageId`, `cms_section`.`visibility` AS `cms_section.visibility`, `cms_section`.`custom_fields` AS `cms_section.customFields`, `cms_section`.`version_id` AS `cms_section.versionId`, `cms_section`.`cms_page_version_id` AS `cms_section.cmsPageVersionId`, `cms_section`.`created_at` AS `cms_section.createdAt`, `cms_section`.`updated_at` AS `cms_section.updatedAt`, `cms_section.backgroundMedia`.`id` AS `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` AS `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` AS `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` AS `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` AS `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` AS `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` AS `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` AS `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` AS `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` AS `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`config` AS `cms_section.backgroundMedia.config`, `cms_section.backgroundMedia`.`path` AS `cms_section.backgroundMedia.path`, `cms_section.backgroundMedia`.`private` AS `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` AS `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`created_at` AS `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` AS `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.translation.title`, COALESCE(`cms_section.backgroundMedia.translation.title`,`cms_section.backgroundMedia.translation.title`) AS `cms_section.backgroundMedia.title`, `cms_section.backgroundMedia.translation.alt`, COALESCE(`cms_section.backgroundMedia.translation.alt`,`cms_section.backgroundMedia.translation.alt`) AS `cms_section.backgroundMedia.alt`, `cms_section.backgroundMedia.translation.customFields`, COALESCE(`cms_section.backgroundMedia.translation.customFields`,`cms_section.backgroundMedia.translation.customFields`) AS `cms_section.backgroundMedia.customFields`, `cms_section.backgroundMedia.translation.createdAt`, `cms_section.backgroundMedia.translation.updatedAt`, `cms_section.backgroundMedia.translation.mediaId`, `cms_section.backgroundMedia.translation.languageId` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation`.media_id, `cms_section.backgroundMedia.translation`.title AS `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.alt AS `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation`.custom_fields AS `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation`.created_at AS `cms_section.backgroundMedia.translation.createdAt`, `cms_section.backgroundMedia.translation`.updated_at AS `cms_section.backgroundMedia.translation.updatedAt`, `cms_section.backgroundMedia.translation`.media_id AS `cms_section.backgroundMedia.translation.mediaId`, `cms_section.backgroundMedia.translation`.language_id AS `cms_section.backgroundMedia.translation.languageId` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation`.language_id = ?) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id` WHERE (`cms_section`.`version_id` = ?) AND ((`cms_section`.`cms_page_id` IN (?)))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"¾â^`SQEó¾…8ü]ÇA±" ] |
||||||||||||||||||||||||
|
0.93 ms (1.46%) |
1 |
# base-context-factory::customer-group::read SELECT `customer_group`.`id` AS `customer_group.id`, `customer_group`.`display_gross` AS `customer_group.displayGross`, `customer_group`.`registration_active` AS `customer_group.registrationActive`, `customer_group`.`created_at` AS `customer_group.createdAt`, `customer_group`.`updated_at` AS `customer_group.updatedAt`, `customer_group.translation.name`, COALESCE(`customer_group.translation.name`,`customer_group.translation.name`) AS `customer_group.name`, `customer_group.translation.registrationTitle`, COALESCE(`customer_group.translation.registrationTitle`,`customer_group.translation.registrationTitle`) AS `customer_group.registrationTitle`, `customer_group.translation.registrationIntroduction`, COALESCE(`customer_group.translation.registrationIntroduction`,`customer_group.translation.registrationIntroduction`) AS `customer_group.registrationIntroduction`, `customer_group.translation.registrationOnlyCompanyRegistration`, COALESCE(`customer_group.translation.registrationOnlyCompanyRegistration`,`customer_group.translation.registrationOnlyCompanyRegistration`) AS `customer_group.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationSeoMetaDescription`, COALESCE(`customer_group.translation.registrationSeoMetaDescription`,`customer_group.translation.registrationSeoMetaDescription`) AS `customer_group.registrationSeoMetaDescription`, `customer_group.translation.customFields`, COALESCE(`customer_group.translation.customFields`,`customer_group.translation.customFields`) AS `customer_group.customFields`, `customer_group.translation.createdAt`, `customer_group.translation.updatedAt`, `customer_group.translation.customerGroupId`, `customer_group.translation.languageId` FROM `customer_group` LEFT JOIN (SELECT `customer_group.translation`.customer_group_id, `customer_group.translation`.name AS `customer_group.translation.name`, `customer_group.translation`.registration_title AS `customer_group.translation.registrationTitle`, `customer_group.translation`.registration_introduction AS `customer_group.translation.registrationIntroduction`, `customer_group.translation`.registration_only_company_registration AS `customer_group.translation.registrationOnlyCompanyRegistration`, `customer_group.translation`.registration_seo_meta_description AS `customer_group.translation.registrationSeoMetaDescription`, `customer_group.translation`.custom_fields AS `customer_group.translation.customFields`, `customer_group.translation`.created_at AS `customer_group.translation.createdAt`, `customer_group.translation`.updated_at AS `customer_group.translation.updatedAt`, `customer_group.translation`.customer_group_id AS `customer_group.translation.customerGroupId`, `customer_group.translation`.language_id AS `customer_group.translation.languageId` FROM `customer_group_translation` `customer_group.translation` WHERE `customer_group.translation`.language_id = ?) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation`.`customer_group_id` = `customer_group`.`id` WHERE `customer_group`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x1F@}/;üOÁï"‗æh■Z"" ] |
||||||||||||||||||||||||
|
0.91 ms (1.42%) |
1 |
# generic-page::payment-methods::read SELECT `payment_method`.`id` AS `payment_method.id`, `payment_method`.`plugin_id` AS `payment_method.pluginId`, `payment_method`.`handler_identifier` AS `payment_method.handlerIdentifier`, `payment_method`.`position` AS `payment_method.position`, `payment_method`.`active` AS `payment_method.active`, `payment_method`.`after_order_enabled` AS `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` AS `payment_method.availabilityRuleId`, `payment_method`.`media_id` AS `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` AS `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` AS `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` AS `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` AS `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` AS `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` AS `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` AS `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` AS `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`recurring_url` AS `payment_method.appPaymentMethod.recurringUrl`, `payment_method.appPaymentMethod`.`app_id` AS `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` AS `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` AS `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` AS `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` AS `payment_method.appPaymentMethod.updatedAt`, `payment_method`.`technical_name` AS `payment_method.technicalName`, `payment_method`.`created_at` AS `payment_method.createdAt`, `payment_method`.`updated_at` AS `payment_method.updatedAt`, `payment_method.media`.`id` AS `payment_method.media.id`, `payment_method.media`.`user_id` AS `payment_method.media.userId`, `payment_method.media`.`media_folder_id` AS `payment_method.media.mediaFolderId`, `payment_method.media`.`mime_type` AS `payment_method.media.mimeType`, `payment_method.media`.`file_extension` AS `payment_method.media.fileExtension`, `payment_method.media`.`uploaded_at` AS `payment_method.media.uploadedAt`, `payment_method.media`.`file_name` AS `payment_method.media.fileName`, `payment_method.media`.`file_size` AS `payment_method.media.fileSize`, `payment_method.media`.`media_type` AS `payment_method.media.mediaTypeRaw`, `payment_method.media`.`meta_data` AS `payment_method.media.metaData`, `payment_method.media`.`config` AS `payment_method.media.config`, `payment_method.media`.`path` AS `payment_method.media.path`, `payment_method.media`.`private` AS `payment_method.media.private`, `payment_method.media`.`thumbnails_ro` AS `payment_method.media.thumbnailsRo`, `payment_method.media`.`created_at` AS `payment_method.media.createdAt`, `payment_method.media`.`updated_at` AS `payment_method.media.updatedAt`, `payment_method.media.translation.title`, COALESCE(`payment_method.media.translation.title`,`payment_method.media.translation.title`) AS `payment_method.media.title`, `payment_method.media.translation.alt`, COALESCE(`payment_method.media.translation.alt`,`payment_method.media.translation.alt`) AS `payment_method.media.alt`, `payment_method.media.translation.customFields`, COALESCE(`payment_method.media.translation.customFields`,`payment_method.media.translation.customFields`) AS `payment_method.media.customFields`, `payment_method.media.translation.createdAt`, `payment_method.media.translation.updatedAt`, `payment_method.media.translation.mediaId`, `payment_method.media.translation.languageId`, `payment_method.translation.name`, COALESCE(`payment_method.translation.name`,`payment_method.translation.name`) AS `payment_method.name`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableName`) AS `payment_method.distinguishableName`, `payment_method.translation.description`, COALESCE(`payment_method.translation.description`,`payment_method.translation.description`) AS `payment_method.description`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.customFields`,`payment_method.translation.customFields`) AS `payment_method.customFields`, `payment_method.translation.createdAt`, `payment_method.translation.updatedAt`, `payment_method.translation.paymentMethodId`, `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation`.payment_method_id, `payment_method.translation`.name AS `payment_method.translation.name`, `payment_method.translation`.distinguishable_name AS `payment_method.translation.distinguishableName`, `payment_method.translation`.description AS `payment_method.translation.description`, `payment_method.translation`.custom_fields AS `payment_method.translation.customFields`, `payment_method.translation`.created_at AS `payment_method.translation.createdAt`, `payment_method.translation`.updated_at AS `payment_method.translation.updatedAt`, `payment_method.translation`.payment_method_id AS `payment_method.translation.paymentMethodId`, `payment_method.translation`.language_id AS `payment_method.translation.languageId` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.language_id = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.media_id, `payment_method.media.translation`.title AS `payment_method.media.translation.title`, `payment_method.media.translation`.alt AS `payment_method.media.translation.alt`, `payment_method.media.translation`.custom_fields AS `payment_method.media.translation.customFields`, `payment_method.media.translation`.created_at AS `payment_method.media.translation.createdAt`, `payment_method.media.translation`.updated_at AS `payment_method.media.translation.updatedAt`, `payment_method.media.translation`.media_id AS `payment_method.media.translation.mediaId`, `payment_method.media.translation`.language_id AS `payment_method.media.translation.languageId` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation`.language_id = ?) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b""" &´\n ™ÒðMY›Zï´³ÍÖq """ ] |
||||||||||||||||||||||||
|
0.86 ms (1.35%) |
2 |
# navigation-route::meta-information SELECT LOWER(HEX(`id`)), `path`, `level` FROM `category` WHERE `id` = ? OR `parent_id` = ? OR `id` = ?
Parameters:
[ b"Ä™+!ŒÜO«³\x0FU\x03~¾\x11å" b"Ä™+!ŒÜO«³\x0FU\x03~¾\x11å" b"Ä™+!ŒÜO«³\x0FU\x03~¾\x11å" ] |
||||||||||||||||||||||||
|
0.80 ms (1.25%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id = ? OR system_config.sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[
b"ð\0Á…®F¢•o=õ–t\x02Ê"
]
|
||||||||||||||||||||||||
|
0.80 ms (1.25%) |
2 |
SELECT LOWER(HEX(`category`.`parent_id`)) AS `category-ids.key`, COUNT(`category`.`id`) AS `category-ids.count`, COUNT(DISTINCT `category`.`id`) AS `visible-children-count` FROM `category` WHERE (`category`.`version_id` = ?) AND ((`category`.`path` LIKE ? AND `category`.`level` = ? AND `category`.`active` = ? AND `category`.`visible` = ?)) GROUP BY `category`.`parent_id`
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" "%|c4992b218cdc4fabb30f55037ebe11e5|%" 5 true true ] |
||||||||||||||||||||||||
|
0.78 ms (1.22%) |
1 |
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
|
||||||||||||||||||||||||
|
0.76 ms (1.19%) |
1 |
# generic-page::shipping-methods::search-ids SELECT `shipping_method`.`id` FROM `shipping_method` LEFT JOIN `sales_channel_shipping_method` `shipping_method.salesChannels.mapping` ON `shipping_method`.`id` = `shipping_method.salesChannels.mapping`.`shipping_method_id` LEFT JOIN (SELECT `shipping_method.translation`.shipping_method_id, `shipping_method.translation`.name AS `shipping_method.translation.name`, `shipping_method.translation`.description AS `shipping_method.translation.description`, `shipping_method.translation`.tracking_url AS `shipping_method.translation.trackingUrl`, `shipping_method.translation`.custom_fields AS `shipping_method.translation.customFields`, `shipping_method.translation`.created_at AS `shipping_method.translation.createdAt`, `shipping_method.translation`.updated_at AS `shipping_method.translation.updatedAt`, `shipping_method.translation`.shipping_method_id AS `shipping_method.translation.shippingMethodId`, `shipping_method.translation`.language_id AS `shipping_method.translation.languageId` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.language_id = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `sales_channel` `shipping_method.salesChannels` ON `shipping_method.salesChannels.mapping`.`sales_channel_id` = `shipping_method.salesChannels`.`id` WHERE (`shipping_method`.`active` = ? AND `shipping_method.salesChannels`.`id` = ?) GROUP BY `shipping_method`.`id` ORDER BY MIN(`shipping_method`.`position`) ASC, MIN(COALESCE(`shipping_method.translation.name`)) ASC
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" true b"ð\0Á…®F¢•o=õ–t\x02Ê" ] |
||||||||||||||||||||||||
|
0.72 ms (1.12%) |
1 |
# base-context-factory::currency::read 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`, COALESCE(`currency.translation.shortName`,`currency.translation.shortName`) AS `currency.shortName`, `currency.translation.name`, COALESCE(`currency.translation.name`,`currency.translation.name`) AS `currency.name`, `currency.translation.customFields`, COALESCE(`currency.translation.customFields`,`currency.translation.customFields`) AS `currency.customFields`, `currency.translation.createdAt`, `currency.translation.updatedAt`, `currency.translation.currencyId`, `currency.translation.languageId` 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`, `currency.translation`.created_at AS `currency.translation.createdAt`, `currency.translation`.updated_at AS `currency.translation.updatedAt`, `currency.translation`.currency_id AS `currency.translation.currencyId`, `currency.translation`.language_id AS `currency.translation.languageId` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.language_id = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ" ] |
||||||||||||||||||||||||
|
0.72 ms (1.12%) |
1 |
# theme-service::resolve-media::read SELECT `media`.`id` AS `media.id`, `media`.`user_id` AS `media.userId`, `media`.`media_folder_id` AS `media.mediaFolderId`, `media`.`mime_type` AS `media.mimeType`, `media`.`file_extension` AS `media.fileExtension`, `media`.`uploaded_at` AS `media.uploadedAt`, `media`.`file_name` AS `media.fileName`, `media`.`file_size` AS `media.fileSize`, `media`.`media_type` AS `media.mediaTypeRaw`, `media`.`meta_data` AS `media.metaData`, `media`.`config` AS `media.config`, `media`.`path` AS `media.path`, `media`.`private` AS `media.private`, `media`.`thumbnails_ro` AS `media.thumbnailsRo`, `media`.`created_at` AS `media.createdAt`, `media`.`updated_at` AS `media.updatedAt`, `media.translation.title`, COALESCE(`media.translation.title`,`media.translation.title`) AS `media.title`, `media.translation.alt`, COALESCE(`media.translation.alt`,`media.translation.alt`) AS `media.alt`, `media.translation.customFields`, COALESCE(`media.translation.customFields`,`media.translation.customFields`) AS `media.customFields`, `media.translation.createdAt`, `media.translation.updatedAt`, `media.translation.mediaId`, `media.translation.languageId` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.media_id, `media.translation`.title AS `media.translation.title`, `media.translation`.alt AS `media.translation.alt`, `media.translation`.custom_fields AS `media.translation.customFields`, `media.translation`.created_at AS `media.translation.createdAt`, `media.translation`.updated_at AS `media.translation.updatedAt`, `media.translation`.media_id AS `media.translation.mediaId`, `media.translation`.language_id AS `media.translation.languageId` FROM `media_translation` `media.translation` WHERE `media.translation`.language_id = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" false true "product_download" b"’ýÑù®2N‚²Fäû¢<¶{" b"m8ï3^SGú‹c,«›öS~" ] |
||||||||||||||||||||||||
|
0.71 ms (1.10%) |
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"r…\x1F\x19êúH’¬E\x00Ó´E40" b"z½Å1‘)NI”¡¥\x0F ‰Ñ" b"Ôu#/*ÏB\x7F”é>Ù`qP\x11" ] |
||||||||||||||||||||||||
|
0.70 ms (1.09%) |
1 |
# header::languages::read 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`, `language.productSearchConfig`.`id` AS `language.productSearchConfig.id`, `language.productSearchConfig`.`language_id` AS `language.productSearchConfig.languageId`, `language.productSearchConfig`.`and_logic` AS `language.productSearchConfig.andLogic`, `language.productSearchConfig`.`min_search_length` AS `language.productSearchConfig.minSearchLength`, `language.productSearchConfig`.`excluded_terms` AS `language.productSearchConfig.excludedTerms`, `language.productSearchConfig`.`created_at` AS `language.productSearchConfig.createdAt`, `language.productSearchConfig`.`updated_at` AS `language.productSearchConfig.updatedAt`, `language.translationCode`.`id` AS `language.translationCode.id`, `language.translationCode`.`code` AS `language.translationCode.code`, `language.translationCode`.`created_at` AS `language.translationCode.createdAt`, `language.translationCode`.`updated_at` AS `language.translationCode.updatedAt`, `language.translationCode.translation.name`, COALESCE(`language.translationCode.translation.name`,`language.translationCode.translation.name`) AS `language.translationCode.name`, `language.translationCode.translation.territory`, COALESCE(`language.translationCode.translation.territory`,`language.translationCode.translation.territory`) AS `language.translationCode.territory`, `language.translationCode.translation.customFields`, COALESCE(`language.translationCode.translation.customFields`,`language.translationCode.translation.customFields`) AS `language.translationCode.customFields`, `language.translationCode.translation.createdAt`, `language.translationCode.translation.updatedAt`, `language.translationCode.translation.localeId`, `language.translationCode.translation.languageId` FROM `language` LEFT JOIN `product_search_config` `language.productSearchConfig` ON `language`.`id` = `language.productSearchConfig`.`language_id` LEFT JOIN `locale` `language.translationCode` ON `language`.`translation_code_id` = `language.translationCode`.`id` LEFT JOIN (SELECT `language.translationCode.translation`.locale_id, `language.translationCode.translation`.name AS `language.translationCode.translation.name`, `language.translationCode.translation`.territory AS `language.translationCode.translation.territory`, `language.translationCode.translation`.custom_fields AS `language.translationCode.translation.customFields`, `language.translationCode.translation`.created_at AS `language.translationCode.translation.createdAt`, `language.translationCode.translation`.updated_at AS `language.translationCode.translation.updatedAt`, `language.translationCode.translation`.locale_id AS `language.translationCode.translation.localeId`, `language.translationCode.translation`.language_id AS `language.translationCode.translation.languageId` FROM `locale_translation` `language.translationCode.translation` WHERE `language.translationCode.translation`.language_id = ?) `language.translationCode.locale_translation` ON `language.translationCode.locale_translation`.`locale_id` = `language.translationCode`.`id` WHERE `language`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" ] |
||||||||||||||||||||||||
|
0.68 ms (1.07%) |
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` = ?)) AND (`country`.`id` IN (?)) GROUP BY `country`.`id`
Parameters:
[ b"ð\0Á…®F¢•o=õ–t\x02Ê" b"é==\fõÃA¢¸õ\x0E\x13,>_\x0E" ] |
||||||||||||||||||||||||
|
0.66 ms (1.03%) |
1 |
# header::languages::search-ids SELECT `language`.`id` FROM `language` LEFT JOIN `sales_channel_domain` `language.salesChannelDomains` ON `language`.`id` = `language.salesChannelDomains`.`language_id` LEFT JOIN `sales_channel_language` `language.salesChannels.mapping` ON `language`.`id` = `language.salesChannels.mapping`.`language_id` LEFT JOIN `sales_channel` `language.salesChannels` ON `language.salesChannels.mapping`.`sales_channel_id` = `language.salesChannels`.`id` WHERE (`language.salesChannelDomains`.`sales_channel_id` = ? AND `language.salesChannels`.`id` = ?) GROUP BY `language`.`id` ORDER BY MIN(`language`.`name`) ASC
Parameters:
[ b"ð\0Á…®F¢•o=õ–t\x02Ê" b"ð\0Á…®F¢•o=õ–t\x02Ê" ] |
||||||||||||||||||||||||
|
0.63 ms (0.98%) |
1 |
# base-context-factory::sales-channel::association::domains::read SELECT `sales_channel_domain`.`id` AS `sales_channel_domain.id`, `sales_channel_domain`.`url` AS `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` AS `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` AS `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` AS `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` AS `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`hreflang_use_only_locale` AS `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` AS `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` AS `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` AS `sales_channel_domain.updatedAt` FROM `sales_channel_domain` WHERE (`sales_channel_domain`.`sales_channel_id` IN (?))
Parameters:
[
b"ð\0Á…®F¢•o=õ–t\x02Ê"
]
|
||||||||||||||||||||||||
|
0.60 ms (0.94%) |
1 |
# generic-page::payment-methods::search-ids SELECT `payment_method`.`id` FROM `payment_method` LEFT JOIN `sales_channel_payment_method` `payment_method.salesChannels.mapping` ON `payment_method`.`id` = `payment_method.salesChannels.mapping`.`payment_method_id` LEFT JOIN `sales_channel` `payment_method.salesChannels` ON `payment_method.salesChannels.mapping`.`sales_channel_id` = `payment_method.salesChannels`.`id` WHERE (`payment_method`.`active` = ? AND `payment_method.salesChannels`.`id` = ?) GROUP BY `payment_method`.`id` ORDER BY MIN(`payment_method`.`position`) ASC
Parameters:
[ true b"ð\0Á…®F¢•o=õ–t\x02Ê" ] |
||||||||||||||||||||||||
|
0.59 ms (0.93%) |
1 |
# cart-rule-loader::load-rules::search-ids SELECT `rule`.`id` FROM `rule` ORDER BY `rule`.`priority` DESC, `rule`.`id` ASC LIMIT 500
Parameters:
[] |
||||||||||||||||||||||||
|
0.59 ms (0.92%) |
1 |
# context-factory::base-context SELECT sales_channel.id AS sales_channel_id, sales_channel.language_id AS sales_channel_default_language_id, sales_channel.currency_id AS sales_channel_currency_id, currency.factor AS sales_channel_currency_factor, GROUP_CONCAT(LOWER(HEX(sales_channel_language.language_id))) AS sales_channel_language_ids FROM sales_channel INNER JOIN currency ON sales_channel.currency_id = currency.id LEFT JOIN sales_channel_language ON sales_channel_language.sales_channel_id = sales_channel.id WHERE sales_channel.id = ? GROUP BY sales_channel.id, sales_channel.language_id, sales_channel.currency_id, currency.factor
Parameters:
[
b"ð\0Á…®F¢•o=õ–t\x02Ê"
]
|
||||||||||||||||||||||||
|
0.57 ms (0.89%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[] |
||||||||||||||||||||||||
|
0.54 ms (0.84%) |
1 |
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[ b"ð\0Á…®F¢•o=õ–t\x02Ê" "iYQbEYPYfU3JejbCECk7w7AQk5tv0Wsw" ] |
||||||||||||||||||||||||
|
0.54 ms (0.84%) |
1 |
# base-context-factory::cash-rounding::search-ids SELECT `currency_country_rounding`.`id` FROM `currency_country_rounding` WHERE (`currency_country_rounding`.`currency_id` = ? AND `currency_country_rounding`.`country_id` = ?) LIMIT 1
Parameters:
[ b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ" b"é==\fõÃA¢¸õ\x0E\x13,>_\x0E" ] |
||||||||||||||||||||||||
|
0.52 ms (0.81%) |
1 |
# header::currencies::search-ids SELECT `currency`.`id` FROM `currency` LEFT JOIN `sales_channel_currency` `currency.salesChannels.mapping` ON `currency`.`id` = `currency.salesChannels.mapping`.`currency_id` LEFT JOIN `sales_channel` `currency.salesChannels` ON `currency.salesChannels.mapping`.`sales_channel_id` = `currency.salesChannels`.`id` WHERE (`currency.salesChannels`.`id` = ?) GROUP BY `currency`.`id`
Parameters:
[
b"ð\0Á…®F¢•o=õ–t\x02Ê"
]
|
||||||||||||||||||||||||
|
0.52 ms (0.81%) |
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;
Parameters:
[]
|
||||||||||||||||||||||||
|
0.51 ms (0.80%) |
1 |
# cart-rule-loader::load-rules::read 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"A$mL™£Gò¬×~,K§×ª" b"\x02HS»g\fOD¢\x01@|££€\e" b"r…\x1F\x19êúH’¬E\x00Ó´E40" b"z½Å1‘)NI”¡¥\x0F ‰Ñ" b"Ôu#/*ÏB\x7F”é>Ù`qP\x11" b"Ŭµ‰ý5LxŠ¼æ@íÑóP" b",(0û×kNŸ«HCë=®€Ý" b".Z4/é\JöØ;w*|+┬." b"œ\x19É[\eTH¼‘ÁrH·„¸¨" b" Ï\x1D\x03ô2C\x03\x04Û\x14Ë\x7F]=" ] |
||||||||||||||||||||||||
|
0.47 ms (0.74%) |
1 |
# dbal-plugin-loader 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`;
Parameters:
[]
|
||||||||||||||||||||||||
|
0.42 ms (0.65%) |
1 |
SELECT translation_key, value FROM snippet WHERE snippet_set_id = ?
Parameters:
[
b"\x1Fí<Ø5BLÕ \x15p·?Ð¥è"
]
|
||||||||||||||||||||||||
|
0.42 ms (0.65%) |
1 |
SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id
Parameters:
[] |
||||||||||||||||||||||||
|
0.37 ms (0.58%) |
2 |
SELECT `base_class` AS `baseClass`, `author` FROM `plugin`
Parameters:
[] |
||||||||||||||||||||||||
|
0.37 ms (0.57%) |
1 |
# header::currencies::read 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`, COALESCE(`currency.translation.shortName`,`currency.translation.shortName`) AS `currency.shortName`, `currency.translation.name`, COALESCE(`currency.translation.name`,`currency.translation.name`) AS `currency.name`, `currency.translation.customFields`, COALESCE(`currency.translation.customFields`,`currency.translation.customFields`) AS `currency.customFields`, `currency.translation.createdAt`, `currency.translation.updatedAt`, `currency.translation.currencyId`, `currency.translation.languageId` 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`, `currency.translation`.created_at AS `currency.translation.createdAt`, `currency.translation`.updated_at AS `currency.translation.updatedAt`, `currency.translation`.currency_id AS `currency.translation.currencyId`, `currency.translation`.language_id AS `currency.translation.languageId` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.language_id = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ" ] |
||||||||||||||||||||||||
|
0.29 ms (0.46%) |
1 |
SELECT LOWER(HEX(theme.id)) themeId, theme.technical_name AS themeName, parentTheme.technical_name AS parentThemeName FROM sales_channel LEFT JOIN theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id LEFT JOIN theme ON theme_sales_channel.theme_id = theme.id LEFT JOIN theme AS parentTheme ON parentTheme.id = theme.parent_theme_id WHERE sales_channel.id = ?
Parameters:
[
b"ð\0Á…®F¢•o=õ–t\x02Ê"
]
|
||||||||||||||||||||||||
|
0.29 ms (0.45%) |
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
Parameters:
[] |
||||||||||||||||||||||||
|
0.25 ms (0.39%) |
1 |
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
"de-DE"
]
|
||||||||||||||||||||||||
|
0.23 ms (0.36%) |
1 |
SELECT iso FROM snippet_set WHERE id = ?
Parameters:
[
b"\x1Fí<Ø5BLÕ \x15p·?Ð¥è"
]
|
||||||||||||||||||||||||
|
0.20 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',''))
Parameters:
[]
|
||||||||||||||||||||||||
|
0.20 ms (0.31%) |
1 |
#cart-persister::load SELECT `cart`.`cart` AS payload, `cart`.`rule_ids`, 0 AS `compressed` FROM cart WHERE `token` = ?
Parameters:
[
"iYQbEYPYfU3JejbCECk7w7AQk5tv0Wsw"
]
|
||||||||||||||||||||||||
|
0.15 ms (0.24%) |
1 |
SELECT `name`, `path`, `author` FROM `app` WHERE `active` = 1
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| 0 | default |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.