Query Metrics
105
Database Queries
77
Different statements
261.90 ms
Query time
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.69 ms (53.72%) |
10 |
# product-listing::property-filter::read SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.media`.`id` as `property_group_option.media.id`, `property_group_option.media`.`user_id` as `property_group_option.media.userId`, `property_group_option.media`.`media_folder_id` as `property_group_option.media.mediaFolderId`, `property_group_option.media`.`mime_type` as `property_group_option.media.mimeType`, `property_group_option.media`.`file_extension` as `property_group_option.media.fileExtension`, `property_group_option.media`.`uploaded_at` as `property_group_option.media.uploadedAt`, `property_group_option.media`.`file_name` as `property_group_option.media.fileName`, `property_group_option.media`.`file_size` as `property_group_option.media.fileSize`, `property_group_option.media`.`media_type` as `property_group_option.media.mediaTypeRaw`, `property_group_option.media`.`meta_data` as `property_group_option.media.metaData`, `property_group_option.media`.`config` as `property_group_option.media.config`, `property_group_option.media`.`path` as `property_group_option.media.path`, `property_group_option.media`.`private` as `property_group_option.media.private`, `property_group_option.media`.`thumbnails_ro` as `property_group_option.media.thumbnailsRo`, `property_group_option.media`.`file_hash` as `property_group_option.media.fileHash`, `property_group_option.media`.`created_at` as `property_group_option.media.createdAt`, `property_group_option.media`.`updated_at` as `property_group_option.media.updatedAt`, `property_group_option.media.translation.title`, `property_group_option.media.translation.title` as `property_group_option.media.title`, `property_group_option.media.translation.alt`, `property_group_option.media.translation.alt` as `property_group_option.media.alt`, `property_group_option.media.translation.customFields`, `property_group_option.media.translation.customFields` as `property_group_option.media.customFields`, `property_group_option.translation.name`, `property_group_option.translation.name` as `property_group_option.name`, `property_group_option.translation.position`, `property_group_option.translation.position` as `property_group_option.position`, `property_group_option.translation.customFields`, `property_group_option.translation.customFields` as `property_group_option.customFields` FROM `property_group_option` LEFT JOIN `media` `property_group_option.media` ON `property_group_option`.`media_id` = `property_group_option.media`.`id` LEFT JOIN (SELECT `property_group_option.translation`.`property_group_option_id`, `property_group_option.translation`.`name` as `property_group_option.translation.name`, `property_group_option.translation`.`position` as `property_group_option.translation.position`, `property_group_option.translation`.`custom_fields` as `property_group_option.translation.customFields` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.`language_id` = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN (SELECT `property_group_option.media.translation`.`media_id`, `property_group_option.media.translation`.`alt` as `property_group_option.media.translation.alt`, `property_group_option.media.translation`.`title` as `property_group_option.media.translation.title`, `property_group_option.media.translation`.`custom_fields` as `property_group_option.media.translation.customFields` FROM `media_translation` `property_group_option.media.translation` WHERE `property_group_option.media.translation`.`language_id` = ?) `property_group_option.media.media_translation` ON `property_group_option.media.media_translation`.`media_id` = `property_group_option.media`.`id` WHERE `property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"K\x1C*™•\x13²\x13¨æ[ùô " b""" |Á¤ÖH&.ƒ8'rº\n @Ù """ b"6}?RJ=å—E#=«Â\x05ýŽ" b"N™\x1AY\x1Cr¥‘ä’ß\x11#\x1E×Ú" b"½œ`tÍ‹l·™'{“7Q¦ã" b"á\x1A7V–\x1A[µ.€ÄW\x1A5\x14Á" b""" îBËß\x1A\n B3½«3ÇÜÿ–Ò """ b"gî§\L\x13\x0E†‘‰òF…’ÒU" b"g÷É\‰À\x048G«ó\x08K_ìª" b"ƒ%+\x13…Qç\x12ÎÉ2\x17èèR" b"m\x12)2\x015r\vD¸Àü´" b"d}Í\x15øæÄ速\x03˺R¨\x10" b"Kï·\fÛc\x01ГˆH’ª“ÛÃ" b"–¡·/\x13h¤~ MÂÐ?\x18@X" b"tü_…\tg\x1D‡¶°Â\x13LP“¥" b";¦³`a~ ZöãUóŒä¥\x0E" b"jÞqÑÆp\x1DCGÌêû"?\rd" b">{õ\x7FÖR~)Ä0A'\x16:s!" b"£®{:~\x10ñ³„çòƒ â.4" b"ÆÛËsÝr·Ä\x05q¹ò“ãx¿" b""" uUbØÊá\n Ó_Tø\x15ct² """ b"\x06]R\rù–r"Üð?áÑ6¤t" b"N¨\x1CŽÎï”ÂÔWÖju7æÜ" b"ÿ›"»²ŽÙ>)HFvvÿC" b"‹\x15tØE6hY˜¯1Äúžóe" b""" 6Ò¾Ë\n ™F´‹SÎpZÛ\f3 """ b"Ln¦ÈÅZ’øë\x15eƒ½Õ9x" b"Ô¥Xq@¨.ók¿¥öˆ˜9`" b"\x05KA\x1DcÎhDê{A–*\t}\n" b"QŽ²Í,¿üës´È±ÑÑLÈ" b"¿I·“¦ú€&SÔ×A«…Ã" b"gaë\x11ªšÌªÇ™\x17`=#\x15" b""" ð¿ü\x1Fa(8‰–ðŽ\n βVè """ b"ð0å^&\x19àDï\x1Aí¶–¿\x7Fž" b"'óú†\x17·X;£f1(ŽåÒ?" b"(Â\x10“¥Oc73í²8s½È" b"ȯ@ë`ù©À)\x16\Žx~Ì" b"K\x02\x1EA\x19Ò¤ÌnB\x0EÞIÇ|" b"¯±Üä\x1A»Í„e‡¯Ö$á" b"}9?¥T \x1E\x1AAÍ-øŒŽ\x1F¶" b"…‘£_Ž\x1FwF÷ÏK7ªXH" b"•›Ì \x06\x03o2ð–ª>'ë® " b")\x0E'MÎ]äóV ËO¸Ø\x18Á" b"Î(:é±» Uú¡°œ;áº~" b""" \x06"\x14V\\x1E\x7FW\n ×àïR ‚ """ b"nd¨Ù´ŽÌí°{\vö«ß¬Ï" b"ˆCÛ\\x14Ë\x01{s8$Ý\x12Ò\v˜" b"Û‰Uañ¢L•_CÛÜ ÅVŽ" b"\x05ƒ/r\x05ÝP$ãº{8õt\#" b"\x06í3Ä])À†êÙB3˜*[%" b"/¾lò?ümÎÇ£D:²ýM}" b"A"Zåá\x1C\fG)ÙŒ´]\x1Aƒ‰" b"´\x07<\x1Fçš|¿~·0b‚L°s" b"e¸Ž¤ž¯ü{•\x11›I$°Ë\x01" b"\r!dÈFÝz©k¤ Q¸j\x15" b"a\x13te 2&\x10µE~,U†r\x1D" b"?!Òì¹…Jðš¤\x0E©Ž_>ê" b"´¸¨#l\x08 änBK å3ê" b"¾0äÊ9ÍŸ¼ñ ·¶P¥H" b"hˆ9!ÛŽ\fMÎ\x1A*L¦b÷;" b"v²LBõlGSi\x05ðÛ \x0F¿\x11" b"\x7F\r㮋.è8kq? »Óˆ—" b"ï÷ÆÏ3W\x06ê¹Ç>Q±gå©" b"ËnÞ\x1A¿9ûˆø–Œ÷oL;š" b":Nh=[Å“B#-<M` NŒ" b"³-È0\vèú8ã+ÌÕI÷—" b"’lrív0õ\x15›Ó6\x1C’FFÚ" b"\x0F‘ˆ\x14ðmÉgìõ8\x0F¡#WR" b"Á\x05)O”ír#ªs¸1°,ã" b"q9\x18“\x0Fù7\x02ï\x1F™\f¡óÂ" b"Í\x14Ë:tã\x05Ú–€-Î8¦\x10†" b"\x00Þ¿·\x07K’?u\x11\x18ø#Pë" b"\x0FßX&îm;Û}ók‚ÌB^;" b"Ï~\x1CŸ¦=Üw\eªx«»˜3ç" b"ê¥|÷èxÃJN¼©)iTV" b"@\x01Ñi}\x19zaý!1R§æ‰Ã" b"^ó²\x12ÖÞ„<3Ô,\x1C\x19\x11’ˆ" b"p†\x01(ì!Ó6ºúö”׸çb" b"Yq3ùeÖñ{“<DIo×\x01" b"\x05ŒŽ£Å¸4\x19\x01g)Å\vˆõÇ" b"™‚ÿI=Dw\x02¼¬\x18i¿ß°Ã" b"ß)iõ+R(8ï’/¨÷ËM" b"í\x1E_ÆËÚ\\x18z' "jÕ¢" b"\x01\x19X\x17\rW/\tØÑ›ÀIÏÊÀ" b"5†\x19"„\x7Fo‘+÷=º\x00Xì" b"‘<¼¦l\x07/Ò†×Nê«\x02S•" b"E\t!^:FAFÖ\v‚YVIéþ" b"\x05“ñ\x01•jJ±Ò\x11 6U¿»á" b"Yc‘Z\x06%¦@ä¯\x1F©1¤\x04J" b"ìp{¯Õs;ÕÒÙ…n~Ö\x00#" b"вñ´ŸóYO\x18ÒŠ\x05ë¸ÇÏ" b"ý„”sb&hXX\x15Ê|Pæ\e" b"c?‹‘GÂh)Y\x7Fö©Q`Ÿ|" b" {øƒ7Â\x11~gê$\x04ÉóH" b""" ò\eÃ\t\x15\n ö…¬¤:CÕŽœa """ b"\x00_Ö>\x7Fßê_ÈÏ\x14z±ÄíF" b"ÊÐô])¾„t+Y\x0EÈ¿DmG" b"ˆiLÏ"Á\t\v\x7FVJ¬÷*L\x1D" b"Ü+©«N¨Ü–£T“eà½í\x06" b"\x16ÞŸŠ}Ì,\ϼž(ÀÃùF" b""" O \n ]§d}¶\x12\x17\x06v\v\x15¡ """ b"ÁÍ9¢¥Ù.T«\U¾\¤\x7F" b""" ÐFŒ\x0EÆ\vì\n +þ/\x18©\x7FÄ """ b""" o\x15Ýr-7£?ë\v\x0F\n üˆÆ\x07 """ b"¤l¢\x16Æ·ª–\x079¢i1FFz" b"\x19íŒÇHe^Ùœ“r‡höä" b"¨\t\eÌJX¨\x0FÊó"{!ÿO" b""" ©˜Ê\n Mºîš\x03:\x11[^9Åø """ b"DÕ¸:êZgôUýÍB´gÔ" b"]r1ÿäÅ_V\x02CÃÁ—”&!" b"š_u:,@Ð\x14gŒ\x1F¶]É–\x18" b"ÇöãÁ㈆Рƒ÷0\v¦Ã•" b"\eJʼwÕÕý\x16ÞŸWÙ¬j¨" b"¾¶¤}g®rš‡»\e,JμÖ" b"Xv*B`h.\x11¿lD°\x16Å\x0EÐ" b"¸\x0F\x1F}\x17ú8!‡‡RÙ‰ßíÄ" b""" YÝ.AuùP³\n =cÅ-í%ð """ b"Q° ·C5Ãåà\x16,€D\x05Û¨" b"µ¶†¿\x04\x12G–;\x07ýâ\=·‡" b"ü`0*S*o –œf™ø\x08ë¶" b"p[\\e3²éd¬\x1Fþƒæˆay" b"|ËfI-EݾQ\x04.xCFþ‹" b"ƒ¥\x02\x1Epyi\x10j\x10Î)\rZÒÝ" b""" \x06\x10»\n ب»e¥A\x1DwÚ\x16‡\x7F """ b"ܾ\x18E†\x1C%Iç‰Õ-ý\" b"·QŠ\x7FŒ`Àþé@D!ÎIv5" b"\x1E©u4n|@-Ìž,éköö†" b""" šbùˆŽk\n H¹¶÷VÐM """ b"Ø\x1D˜£2Ù(;×K¤ åWr&" b"°éá\x01Êfíåé|È\x05á’\x196" b"\x1Af\x13lž ?²$äÂ[<)õ2" b"\x1E$Íg¶þä11¼\x07K\x1EQPJ" b"¨ñ†\x1E—6ìñiCÜä|$‡½" b"Ä‚Ò\x19a'\x0FûG¯ëQQ¿\e\x1E" b"ÒQ6dú^u Èhãô\x15™¿í" b"\x1D+·¬É’âô¸¾öG\x02ÁÎ" b"«=ç>ùID%Ô\x16ä9GúÝ" b"¨\x07·è\fh~43V%¥×§²" b""" õ"Q\n †*6‘\x06”•Ý&„þ\x14 """ b"\x01¯‘o\v’]~jã(z\x1E\x10" b"\x08ÝðÆbûú,§KÀ\x119ñT" b"*Í\x1A›\x0E±3´@8Ð\x03G»$w" b"Í43¥ô¿G.q¨\x0E\fo\x04ÅŠ" b"åB³'ÁÒo\x19îãŽ|{×\x07\r" b"Ù\x13'7Í¡Ÿ-€QͶóV\x1A_" b"RóíÍï&ò^ý-É*B¦\v\x00" b"žx·\vî½upú_Z!ý"Øõ" b"¬úf•Üg±¦$‘gjzú°" b"æQ0²ö\x11\x107}ÌüŽ©³\x191" b"\r·®(Äö+Ô‘¤2“:g\x10Ý" b"99ÍòçƒÌà~€\x1Cæ÷\x19ô¥" b"§sï\x11—ý¹\x04c=\x18'+ËR'" b"þ6݈\x14<$H\x03¿\tÄ|§¤," b"9>|Q¡¼ çAõÙZ~v@4" b"Wâ\ev\f\x1E\vïí/r3¥\f›š" b""" ‡B£5ýžÖ\n Îj¨\x1Fû\x03Žn """ b"ä•\x00\f\e¿Ž§¸.\v\x02õTAŸ" b"úm³€TmsŽêÄü(Û9ü" b"\x13QïoW\x10^ʸUµR‰M”3" b""" m§\n ðQŸÀ#^]jÔ^³\t¤ """ b"¯Ž!xÂp\x19ö«êˆÇhL#’" b"\x15ˆ—aOpŠ\x14·ö•\x10'¦Âg" b"öš«\x03\Ì)HBm®y´óÊL" b"J˜…\x00Ðçëê§)\x1Fr°@ù1" b" •3cô2¶W|\x0FmF”JÏ" b"§jž\x05©\x08°R2\x1DÅ©ÉKšÝ" b"Á\x1F7bôë6(—<\féTÕÔ" b"uº\x16ñŽÄ\x13Ç«\x17>\x10\x10,\x0F?" b"š1ð2Bë\x103ŸFHðÝ]Ò" b"…A\x0E æ0vzêâÁjx;¬\x1A" b"\x12.S\x1AB±A™+#(ß#\x08ál" b"bl^È dQN“ “Ð{ŽiÎ" b"ÕUŠ\x1E|íÅþW/h°V¹Üf" b"é5ÌAh¿Ý‹–\x1D¾T!5ùé" b"rÏÔÂs½ÃÜà ͼE0à²" b"º´o\x0E\x1CX°¼f&T°uˆ" b"\x06W¿800˜\nL7íÄ[º\x00>" b"\eþyŽêⰦŕ\v×%° " b"s\x1DDØðÙÃ-ˆß×\x08…¬\x7F\x10" b"ˆ>¡\x1A2¾ë©\rõµV§Ýd" b"²0\x1F3×6fGË\x0Fh\x1C£&€" b"Ç8e‡\x1E^\x16RàƒsŽæÓ”í" b"\x00\x1CŽT(Ðâ.Ow\r\±ü\e" b"\x1Aí|ÿ`à=»17x¼6ÿ»š" b"\x02¸Ç\tÉ–éØÃóçÝž%\x07" b"\x03Œ®‡R¹—M_\x01Ll¡Õ&" b"\x12\x1E.ˆµ\x031M+Ö»šŒ\x01åŽ" b"NŒjB\x04Œe8#Úx¯ÿñ9W" b"qƒÄÓG—¶\x04\x18Í\x1F\x1CדN" b"ÐêS mT™¯SˆÊ=-È\x10*" b"*Øp>,Ê–þ¦É:('œ<‘" b"?&\x1EôgdÆ\x15o=åÍ®Üçq" b"Tœe‘#–"Cù¿ÅPv½" b"co–ò<€'ݬUSG\x0Ei,l" b""" §\x1C\n ö“N†ý‰òtÉ\tØa€ """ b"?±\x00\ Ü%…•‚Ö´±\x7F$%" b"fÚcÅ\x0FÙ~‚\x1C/‚f2ÖÏ–" b"\es¼E6ŽåüÒ\x1F^/Ú:\x19~" b"!\·qÇ¥Ž¡`eÛ•=z§J" b"«hs\x1C@Æ5¥þ—}\x07I4\x7FN" b"7>#¢î†pºmƒ«tÞ$\t>" b"lßn“\x17aäܧ‹ÜÐç'h" b"tgÂ%ò½V*r\x05ˆF\x06ì5" b"Ÿuñ-‡o’ÍÛ5ûA5Ï" b"¬£M˜0\x18ÃþªH\x07®`ÀV}" b"ó¸\x00\x08j\x0E\x19åmì¶èÔ\x19á" b"Gâ$âjéÍ\eŽýÓ€µ>ì" b""" p—{ \x1A\x10\n ‰³gõ~ã$´• """ b""" ‰ú¨x^\n *Õ\x12äðG‰7³ê """ b""" ‘™©×[€÷\x07£{ž“\n Æ¹Ý """ b"x`\tb\f2ü\x02\x01…9üNC\x04" b"çÊlT\f&䘀ê\vW \x1F©#" b"ý;\rŽÃÔ\tÌ\x1D\x14v¶Ç" b""" ÿggé\n v»†s;L³lœã¬ """ b"\x16HPž±Ë|㻲sUì홆" b"—¸\x08K_jºÃ™ä£¦ùlÀó" b"¤úõ=á‰pœ\ef¾-%Ï\t\r" b"í \x00Öä²4ܳW•ü\t¼²”" b"òü\x02j\x0EläKŸ Ô`÷“#e" b"P—ÉÍ\x11÷‘'F,„ý9Ut\x10" b"d|Áã®Cÿþ\t\x00ÆÖv—½±" b"Š¼›\x1E‚)Å-kÓŽÿ\x04 Ð" b"ÑïyPh)çz5\t—Õ\x18îPw" b"Ò\x11I7y[V\f\x03\x12ôDV¼ô>" b"ßõ¹«ñ\tî‚c»÷\x1D¢4" b""°¬oÑ\x03ôû†¶\x7F½ÄÆȧ" b"ÑÚ‡„›\x00û\x11§ý"Vû'3Ó" b"ú¬:\x00³X'‘iˆU^JŸë\x7F" b"\x1E×hZ/Qðu‘xaúÄ6ÎF" b"QÁ7šÃ`££íÐršŽUn\" b"S=2\x1CãÞ4’ÏÎ\x13Óc÷" b"q÷\x13Å<?¨Ãp+ã‡à~ââ" b""" sZ¡†;ê‡R4Z…=—\n ç """ b"°H7T\x08ïÍá\x17”_Dâ|[`" b"Ó;ÂKïjW\x16zqdŽiÈ–\x13" b"-)x²èø³âÈTS³öÙ\x04Ã" b"eÆŽ›¥i=C\x06|\x19–ˆ\x1Fš" b"w[æ×\x15ŽÂºUB„×öÎA" b"{Ð\Ã\x1CºÃÚGªœ\x11ŸŽ¢-" b"}(4eá^öŠ_>bD\x12eèÉ" b"œeÕ/ f`FnHÍ‹Ž,†5" b"³·ÂxÉñ\x1C\x14¬sêdsöƒä" b"»ÃðiÚ\x7Fl\vK|¢âÛÁwd" b"âT¦Ç¡Ý¬pÄLq¼Cç\x11A" b"!"\x02¥›®ã×\x00„¯:êj¹<" b"*\x07§CÒ(ì6¼Ô3é?ã˜1" b""" I\n ó\x160Õ÷ȬÇ\x0Foß^ÉW """ b"x\f^YúÒC=õzoÝ\x0E½" b"‹~^c†s{\eë`ß•Ìe§P" b"ŽfŒ¥¿ÐÚr\x1AZáÐcüø%" b"“ÇD®š‘¼¹Ý-…ƒ+Ëý" b"\x14ÏY\x06nÉ\x7Fè²æŠûa½¦\x01" b"\x1C@B4JÄ\x08ªëÿ\x07\x18bChG" b"1y {7\x7FU³±o>ŽO‚Ñ'" b"8= ‘¶¼\x11 ¢;€ß¼ÆÜJ" b"g=‹Šsí\x02\fæÑAy&Ò«" b"jÅ\x07öYz¿‘fQ\x05ÙþSq" b"'cÛ\x1FlÃWJŠŽ²ŸlÙ\x1F" b""" 2SC”«ëG\x11ê\n §÷>Ìw """ b"¡p4"1 é\x1A{2E\x01ÜýÈm" b"Ç \x00¡º\x01/©Çú#ëÖó˜´" b"Þ8óÓ\x1Ea\x10¡â\x03é½k)¸n" b"ó|þ›ÍQ×x™"¯Ê\x11¼¹Ò" b""" \x07_ÞÈ\v‚ï·m¡l°\n Ü\x0F """ b""" \x10%œ‰mí\x7Fv¸\n \x0FúÌ\x19\x03 """ b"\x17ЂFȶ\-=,Å\x15"Rbz" b"\x17ák¡,ù T€¬ˆŽêFùt" b"\x1Agª³lÉ«\x0Fߟ?MÛ¾Ë" b"OËš´%\fØ\x1FŸ"féXíË\x18" b"VÕQ–PqÛFAz>ávçšà" b"W¬uƒœÞÍ·Ø1ò¤¨{qÜ" b"|\x06NÖžò\x16»\x00ä9ò¡C>q" b"†\x1AÍ~`7o«>® C4‘" b"ŠŽ¼\x06Ǭžè#i\x1F›…)_5" b"’ÕHñâ\x08\x06Âõ÷Dן\x0Eú×" b"ž$ñ'`ê\v¿É“m+kY)S" b"×½s¦ê±.íÌ\x18s³ñ7û" b"\x05C\x17ê½\x00¹\x07œ\x05yÜ¿\x16,î" b",§þñ8ù“"÷{â4ËcÔŽ" b"eó‰FCטu9\x08¦N\x00%ÄS" b"ìH8ƒ\x03\x1F\x19Å]ËC-å\x02?Ä" b"ûƒ4fàWêugyx‚\x15Áâ~" b"\x02\e+^Õ"!fSþ^\?\x03Ê?" b"\x0E\x03Òx¡ 6°ïÜ\x7F@óÙ§)" b" 6#‰í6Æ’êçö„„\r\x1DB" b"&î\x1AF\x7F®t›hÃMÞ\x08\x0E6L" b"BÆ2\x15à[] :wâö@åÏS" b"JB±B‰rS½\x06jæ÷ªÂ\x13c" b"rw\x1A§OõãA\x19’€¸œÆ÷" b"|ŸÆ…T›\x079¯YÕþ.øe" b"£^§ÓðG^c–qm ”õ\x1D¤" b"á÷ÆŧßK³žÁê\x00y)ô7" b"\x1F¨–å’߸w\x16‡DØ\x11¯" b"R\x10&É1C\x11¶½ì^I|†\t." b"\ð<@“˜\eŸ¾E\x1E\x15ƒó™x" b"¹™…~D*\x7F¸b<&]Ã1IG" b"Ãþþ¥‚ìªyCxGæÚ±4º" b"Ä&®â7ª’(¾3à\x17gëÊñ" b"̤M\tîêýJZÞô,yŸ\r#" b"×\e†€ÿôdø\x0F`\r—ÔŸ\x07%" b"ÙØ`\x19œÜ-\vÌX'¶K*'" b"+Œ€Þ+y\x1A…,\v\tÝ\x14ÛŽ\x00" b"/‚2\x04\x08tiàH\x1E\v‹÷nTµ" b"T²Æ êÚ\tç¡\x11@ÞÉ>¿¡" b"h©»÷0\x0E+Â\x1E‹HÕ¡*)¸" b"}~•êåË‹ØüÏn·ÚÜu" b"§sô³í×\x04oƒ\x05ÁJøFbo" b"ÄíÀ\føG‰ÃlcÇk^Ê" b"ËCÞc#6\x0E£}ÖK½\x05Áv\x18" b"Ú¯v}ÿ6Yà·ù7Ðt%àœ" b"êhw¸šEÞax%Æ>/Ê‘l" b"îÿp¾îD.A@è wÄÑd‘" b"ð\x1F›´æjÚ*1›\x1C[4[Yó" b"ñ\x1ECì£àITLê5)‚ÉR\v" b"ö>o2\x108%)[÷É»Oâ\x08f" b"\f\rFLð}[µ\x07„ÚN\x03Ø\x12½" b"\x1D\t<à`ýŽ2©\x12î{vC\x08" b""" *—\x11³\x15onš\n ¼Ãx°@¼¤ """ b"+\x16êÑ.Hr Õ6ºNià³" b"2Ñ—yØ;\x7F䥜dÓ®\x06\x15Ú" b"2ó\x14Å‹1^¥_q\x11\x1Aè†)" b"@¡î̘QÖÎ?¤omM¿yê" b"v#/˜3ê7sN‹ø•\r§Žö" b"‚:«ÔkN¢Ös^fÓk:^¥" b"§¹èR«ßË<h½ITœÔw¾" b"«0\fîm\vãfÞS¶>]\x10]" b"³/Žû}“\x17iÜÌ#ëJtã" b"Ú‹Œ}fÊ\x177?\x15Í.8I\x08Ë" b"à®|²bäÛ…_í¶í¦‰Ë" b"âÛ®j\x13®Rûáh^kÂ'ÄÆ" b"êVÍ™\x01BÛÕ7È€äyqìN" b"êËŽj!\x1F[µÓ1 c±±R\x16" b"ì\x1F»ê•ÞAï×8Á)X±\x7FÚ" b"\x1EÀbl\x07Æžo¥Ð7\x06ŽQH\x11" b"Cλú²ä§õñüN¸¶j\x1DŽ" b"U\x00%ì\x02Gg^ßÂ\e°×¡_ú" b"t77K$'L,ò;?‡úcåÇ" b"ü\e°Ù$\x18\x13\T\t|žô6–ž" b"\x1C0õkĺ„*ø“™\x08Å\x15¾V" b"(.=´f!ª\x17yd\x1EÀ¯Ã¯Š" b"Lª \x11颦d ×o™EV•¾" b"N,´\x1DÓF}\t\’н¯½÷¦" b"T)\x7FñÑ(÷Ø8Fâ¨LŠmö" b"]\x08XVkBÔòr‹\f\x0Fb%J÷" b"bäíðÃ\v\x16é;V\x14ªão\x11"" b"ˆØOƒ§IJFà%ŒX¶Û§" b"™0sOçÎ\x12½ŽŽ·–\x1D™_¯" b"¨åÂNXIèÀ·pŸ@¼€à" b"½6Œ\x13Ùþˆ«ÊKGY³\x05]" b"ÅŽò‚ËÈ8ÄÑÁÀ\x12öþî2" b"ÆLe¯x¢š\x15ý¡¹BŸä4Q" b""" Ü©(MõWÜÝÝ\n D‚7ýÉ """ b"ÝõÀÀó\v.¥]z!¾öùç\x06" b"\x1FùðRjx\x16w\x7F?½ãmg¤" b""" :6W\x0E >\Z\x03ö\n ¿ŒéI3 """ b"?—ù¬"dp¯(\Ž÷Æ3sŸ" b"K~eó!o(Rà\x01\x06@I\x08Žr" b"Tò?¦ÔâÝCÔeÖj0Ì" b"_¢%\x01\x03b}PUC/ÿ\x04±\x0F`" b"cÃо<¢Œ\x17èMótè\x07Í" b"‰„¥ Ù|\v\x7F\t3Mm\x1F«\fÖ" b"‘£iO©ŒìŽ\x01–ïí5*ƒ" b"›]vÊÃ\x07¼¦?7-Ôµg¦Ž" b"¸`¬CþKýš£–Ùþ!\x18#T" b"\e~í·ÕÉŸÝ\x18)KM\x14\x15Æ\x02" b"'}÷GßróÅA'Š;'°u" b"+LH¯„i\x01ö÷ø\x1Eʱ䋥" b"LE-\x1Dd ,Öî/XùÒ¬J" b"^üî\x13@"kë*YF\x00A]Þ" b"r•o˜K[¯Â\x13à …îÚw" b"‚-ñÈúã”TÆù)8fÏ\x07E" b""" \n OL›LÀϵŽq\tè¬ó """ b"¥'m\x16Ÿí2\x07Ãì\x048|C:²" b"©\5:¶¸ó#]ÿe<…ût" b"©ªŠ\x1EFò¨ÿcg8^ò<`•" b"É\x16$/øãïS\x16,’\x1D€“fÂ" b"ïlà5ä•\x06=”»ëˆ0n_Ž" b"øý´[4´QP`ÐþÛs®\" b"þ䵡sÀáBˆ¹8ô!¤Þ" b":¤¶|¶Tá<Ùã.\t÷Ãî’" b"BŽZ_'\fy£qÍÙ5çw\x19Í" b"kTæ`ü\x14\x05´ ž9[ <ò\x18" b"—æ2äp>³\x00Nk§‚„á½’" b"µ‡`ÁL]^\6KÁ„€\x02ô’" b"·QKõS¹ÐŽ3{Lasj¤o" b"¸b}\x14Î\f\x7F\x1Cìa\x11&Bxvp" b"À°j`r>~+—ÉW—SNuÚ" b"ÃŒ÷Áã Ø|\x1D9Žó\x01zŽ·" b"ÊwЋ.£Üas¾0Unˆ©" b"Π퓲Ò\x13\x1EV„ò~\x07\vpb" b"àˆªôH`1^\x0F\x17à\x10‘—ä…" b"äÖaaÁC\x02ÓC‘™³2R\x014" b"ì\r~MUˆ\x07\x1Ac\Ïc9Š"5" b"\vö\x06Â\x03‰RO\x0E\x00ª»1‰\x7FD" b",d9Þ™ã`%\v“s$—Ó¡ö" b"F®ö@Hê¸ÿú×.\x11”8í\x18" b"H£\x14-zpd~Û\x0F}Æ\x1ErT\v" b"Néë-V/\x06Õ\x1Fpó†\e¹ît" b"Rÿ¾'ª:[ ,h\òü6ÄT" b"k4›À>戨W}l\x05^#ë¶" b"|H©ã²¤C\x1Ck3ΕŠ\tì\r" b"\x7F¾’UWC/Å=\x18\vú\x1A’]ø" b"ƒáHÂJ\v×*x‚öÄûL\x07j" b"—g_”ôÞ¥=|í¯Æ=.Èß" b"°ÒþTF¥>š\x12$.®ˆŠSé" b"Ói´ý“‰å\x7Fºr~£"Ï\v=" b"Õåb{a†Ÿ°Ö/?ÃtëJœ" b"òZóóícûdæt]q\x16”\vò" b"÷\r™RÂÐ\ü\x19#Ç0‹±\x01Ó" b"\x0EuS¶u^y¢†#Áa ®\x05" b"\x11ÁQ|ÞW\x17\îy?ÔfÏ" b"*M% Rar[\x1A>RÒ`\x19´&" b",”\x7F _\x04#ölVOK×>ÿ\n" b"E²«Úí2"GØÒ Ñ•Rë©" b"Hœ\x7Fõó1†\x11\x00tVueFÑU" b"N,6²™%qÑŠõúó¼ÎÛ\x08" b"QI¤ñž0-EÂêR\x11š" b"s9Y©\f3'é®éËiO2ŽŽ" b"€{5Q³:m“Fq†2yÛ÷ù" b"„ˆ¼q;à5÷^Dã\x08ÇÔv¤" b"©Ác„¥HG¨\x1D3ko\x1F0" b"ÁV*õ8ȳ\x06mÕ÷JPRQi" b"ÍJpš‘®\x05#Fbò]Ôpµu" b"ÙA®Ñ\t¾•õ5Ø)jøæˆ" b"Û8\x10\x1C×¢\eA_é\x7FGÊš¶û" b"â=\x19Q¹U®õë\x0Eæ³+Ã\x1C" b"ë\x07lq}É>e¬Ê¸”2vÛ°" b"þÿŸÒß\x1DX±ŽŽ”\x12Ut_\x1E" b"\x12×Ä+ÉDéûm\f\r¾V»/’" b"1\x10 Q"ä\r‘`ÓÚrn 60" b"1\x11`Â\x04Œ\x16Õü§:)\x06ð¨t" b"3W67‚kL´ø]bÇ–†o\x12" b""" J\n æuÁ;ŸØ$ƒ\x02"\x01¥º\x18 """ b"N²ôpqYGòÛ4æ#e0Ë\x11" b"€\x04Ò¦\x06‹4ÎN1ÚNO¨n?" b"„ë\x7F0œ=ª>\x04†7Q„¹" b"¥\x050ÛR‚”œÐkÆjY¢¡" b"©M‘\x0FÖ\x19\x16YáÊÓÖà¶E" b"´á9P¶(ø=x0×—ø»çµ" b"ºÌŽcÀÌ’É\t£¤@´£"" b"»b³²\x19cªg/Öåy\x15ûÐ_" b""" ¾®\n iî?I "~ÝŸ\x18\x039Å """ b"Å2ß[=2[Ømç\x04`Ç\‰•" b"ÊP'{àbÐç“\x1C1aOê" b"Ës)5´ªnEÂÁf\x1Cg‚|" b"ã2“áþ‹ER"¶"îoØLŽ" b"úß¼ uÁÛG¼y‡\x13›(œU" b"\e%§ú5H%Ëëã¨é\x08ºV" b"79(g§‘J_\x03TÁ\x08Wì\x02ü" b"QÄ\r\x16ŽÑ\x16ÂŽì{®u\x07’l" b"a\x04}ò\x03\x14\tí}éK\x04:\x7F\x06" b"eÄ‚E¬Æå¹b žÔp\x11G" b"i«ôh\fäqm\v\‰íKÿ\x01" b"pWo¾GÍûeÓGÕOnZR\x02" b"sE…\x10¤Uvß·\x06àÀÐÝ" b"z‡»\x1FÀ\x0E‹¹l¹°s@\vDo" b"|Î˹kƒCò«jäo2dóK" b"}±\x1Cþ›\x0F~\x07_šK¶KܼÁ" b"…v÷e\x1Dm•¡pá\x10\x13öª" b"‹\x1Cí“^Zýc|F™¤j\x10÷ç" b"‹ËÚ*(YtjÏ\x12+[qÄ–\x10" b"Ž´\x17*üìjNý(U!\x04û" b"’T^mj‡\rF\r„Ó¾ÎL" b"•õíœQx\x16\x7FjA\x01©Yž'¼" b"–àt\x18íÀŸ˜²GE_ùîG\f" b"Ÿ<§ÂP:R…ÉÍ\v#bÓÚy" b"·ú÷\x18Ȉ\x15°t¸ñbêÿe" b"Æ–-MJlºU'9Œ»¨›§3" b""" Ùß%á~÷\n E³\x0FöŽL\x15Âf """ b"ðƒ±Ýõ”üAJ[Ñóóé\x07/" b"ô\x19B\dGæ.\f;·wî@ý¹" b"ø‡pg•\x07…\x7F¾×-\x1A’àûx" b"ûŠSy!ún\x06=\x0EC\x07æíŸA" b"\x14vŒù½]Þv}J#¨¥¦Ôn" b"\eJ|RÄXªI3Ò_z£ÏÔ9" b"\x1DÍ)¬ï˜`\x12Ëã\x02Þ±ã\x0EÓ" b"$~Ûæ\tÔf8\x7F“È\x12Ûçâ\r" b"*ü8R³¿;«\¹« 9J<w" b".¯8B}–Ðò2Bâ\x02\x11(¹" b"F>ÑÐú&nï\x12ÏP\x0Eƒž\x105" b"SZým\x08\x19³ÓŽ#\v õÆ6‰" b"fÈ\x18œÕ¡jïnÉï„ê>¤Ò" b"oÞö{Øž²\x05Õ\x1Da$ò7Ü»" b"q\x0FŸ\r²XˆÕÞ6îeâ%‰5" b"…\t\x11Έ³(>è\x1Dº\x04‚î‹" b"‹{¯ã\x04íÈq4\x00+…Òn" b"lÚZ*\x1A\x16Ú‰¯²hóî¸w" b"³Œ=4\vï¶Ü\fª™¨—I€" b"½#éM‰f\x12âÏ™`’]W—G" b"Âóp Pë…\x00\n¯wà‘wa\x18" b"ÇL\x17‹&l鹚ÉMë\x10àС" b"ҘГ·\x13\x04©â³OjL!Gú" b"Õ5Â\x15s«\x12ÕgîmÎEr¬/" b"éaPüN–‰ˆ[ÚMaPA«Í" b"ìÅÍ9ÌC5@ FûhQçN`" b"ò\x13µ.`\x0E ™\x11Ud“-²‘?" b"ò4ºÀú(ñL#+,–fÇ^¬" b"öÇøBŠ–U‘\x0EÇ-(¼ÓøÔ" b"öÿ{kžð›G\x11™Å†!õ\x01\x12" b"\x04ÝäK+üqüÍ}rœ4\x02\'" b"\x0Fwf/A5|÷f×ÀÙYtN" b"\x12ÙúÓÞF°«ä\x19kŒ¦Eaw" b"\x1E“å»,\x03%Ú åRH;žu—" b"\x1F,_\tÑMÏ\x1Cë”"¯RLÛÂ" b"+í•`,h4L¦ôÍÞO]oQ" b"586û\x1F@ô\x01R³™ §Tå—" b"5Ë[¾ˆ\x0EoÍ@ŠìËùÓà"" b":\x12â\x18Í„%ü\x05iº(ŸçE:" b"@\t¢Ø7>;›2É0.c:å\x1A" b"Dk\x10ýäˆ\x00¼\x182¢NOD Ç" b"FŽOòÌ>•y–ÌKËžËf" b"L7n¥ªÎ—\x04‰R\x11Ê7yý4" b"MWoàœ¹>m\x0E/èÖ!þö\x15" b"XÖ£\x1C\x07·Ÿá\x01ò%’:ò\x1Aó" b"jT¦Xˆ\x05¼Ÿu:"»\vÓ\x05ª" b"n\x1F\x06³»»0K¾À=\x18ÐtÅE" b"oœÿÃðKhË&¶+\KŽî" b"wÐÉþ¥j "Éa‘õeµ9\x00" b"y\x17-Ám±(\x069@8\x198\f”u" b"…¥5Wð†òÇ‹Ru7vLâ)" b"”ZâÔ2l]-¯Zœ\x1A‘î¬Ê" b""" –þ]çæ·ê\n \x12Ñ\x01àlN À """ b"šöÑÉÇq¨íò:7¸TOaN" b""" §Êá׫²Ž\n 84€?¤‚1 """ b"©J\x13IôÚw§·¼+åëF8t" b""" ª(]F\x10AY\vcFò\n g欪 """ b"´Çþµy,%mÔ\x18ê²\x19;þ—" b"µÁä¶zhýy•"³9c´&–" b"Æ‚OiONQ &Hsé\x08‘K" b"Ë_Ûü¹+†¨¾SïÈœÐ8g" b"ïé\x15çÿÙi+ž¾\tŸ8É9" b"ñûUÑ‘`\x19³f*™ÀæÉS" b"ùð"\x18ʆüúØ=\x7F)ÿèäú" b"\x01Î=Î+¤òHLš>‹\x03{7¤" b"\rÙÁ×*¢v‰jÀæ=cë4X" b"\x10LN\x14¤ŽþÔ.W¦! ‰‰f" b"\x18Â\x126ɉBo/çüóä:~Æ" b""" "ÅâVÄ‘w»"Ò%ŽA¶\n : """ b"0ñÙ¿\x11.ž±3tY\x01Á\rü7" b"4‘éœB׌\r‡ý™iFFÚ2" b"<#º+\fÕ\x1CÍJ\e§¦h\x08)" b"@\x00€`ƒà×½\x08ÃÕÌÊ\x01˜" b"C·LhŸ]PEcLà>±˜p\" b"XX¾“Àá÷‰K°ýôÎUm6" b"b…sE^-F¿«·FŽƒ,µF" b"d\x07ë\x16“\x11QméÞÐböp\x13Q" b"q§|2Vg\x06\r[î\x7F"‹žÎ " b""" tíÏŽÐ\x0E³X†×S\n µ™ ! """ b"„=°»\ev\x14ÿ„Œ³±žºL" b"¤QUÓf\x01l¦k§´aƒ!¡" b"¬‹{ö‚´\x18t-kŽsÑ©[½" b"ÁLTæÏž\fm\rªu©¬DaÈ" b"Ó•Ô6‰æÖìÔ°ø0á飜" b"ÕW½xͬd\x1A6\x1CBË"Û\v\t" b"í”WRK5 dNuÓuªúÅp" b"ô&JéObä\x04ÑÁ±œ]E$Ö" b"öºq$è/‰%|øz.ºÅ1\v" b"þo²Ï$£6¨7³:Ãb\fR" b"þûc\røsõô}¨§6\tËV" b"\x01ù\x13Bxä\x05\x12lZŽÎ\x11Å`²" b"\x02ýèî¥ë¹"3qýŸ¨ ï" b"\x04’!I°€\x0EKØ9?UÙ\x0E i" b"\vL9A‚.\e°‡0A\x1F•†Ž\n" b"\f÷›Ù葺£¥\x16z{dÛʱ" b")éö7h°\x0Fsð´æ¯µyüÜ" b".bÚ\x1CK\x01KÞ+¹ž\x07e™\x03" b"/àjaJ\x04¨6\x7F-!‚ÂÚè\x1D" b""" 0-F@Ò»Gž¶z¹\x1E\n Wº\x17 """ b"9(–ÜU$Ĺ\fç\x1C\x12½šWì" b"PŠí'†„÷•®\x1A¬¡VZ" b"SöÕ±ÃJ²©&‡ç¥\Ôvø" b"U€‚=lâ\rØçЪÊ%WEg" b"dcUK\fhjH\$xÄø}\x01€" b"p¾I=\x0Eùžê{ΗpŒÉBŽ" b"y¾ÒÊ; \x13è¡\x07´;™Õ\e²" b"‚Ž0\x16`‡ûwŒï‹ˆÙU Ó" b"ƒÓ\vj¬ó\x17â·7¨ò'ƒ®" b"„BéÖžªo\x1FIW\x18\x1FŠ€\x10¾" b"…þ\x14–×P\x0F'd|\x7FÜ”±„ˆ" b"Žêi¡Bñ-²…€\x1EßwR'Ô" b"—ÐØ_Ža¦îü¡ùË\x08ƒþ»" b"ž5©«žé…Õ‡‰âöG%b" b"©‚)í.´SŸIÄ4ã0|\x11_" b"ª~Lk8a%G²#F†“¿·Ä" b"¯\x17¾]\x1E\x06òIõãúŠƒ\x7Fó" b"³ð!ˆ<µ™ícª~Y\õS" b"¹ü5\x006]\x11Ì3'îS-\x13à¶" b"¼\x1D\x10Äú “Û»TŸØ˜¦õ›" b"½\x0FŒ%—5&Þ4\x19—q°\vœ" b"Â[s2t3‘jصß\t¥è~!" b"Îýk'©9’\x16\x0F>ƒYi\x01;G" b"èxáIb[û\x1A˜‹Û$ÞÕý " b"éõqó{¤Â]8€\x7F*Òø!³" b"ò'œ¯â:\x1EÂKrÜéÀïM " b"\x0Fõ\x14F\x0585o©Wë\v\x05Òt," b"\e}\x7F.[#1)\täZ»/nÏ0" b"!’NÌ :~â™\x15>Dt&‚" b"'À¢\x7FwÀAprþ(¢¶\x17Á" b"-€Ï“\x12ö½µd\x05ñ¼7¨qC" b">\x1CJ£¿&tV«Uí+7ø" b"@•FM¥“h¦tàªy£”ˆ%" b"BX|ò¾[u=ˆ¾Š¾0Dr" b"Pdq\x04Ãjr\x12\x18i&‹\x1Ef" b"UËOøI^Û Œõ#\\vAô¦" b"c¦àýŽTÍá¬ËYù\e˜nÖ" b"s_ÑÔΫîáÄóq’k²N\x7F" b"‚îÜ[}»1Ü/ö?¯¹ÃÕS" b"Š\x1DEõ6D‰«\x05®+È!\x02Œæ" b"ŠqŽ\x08\tOˆYœFAÈQ@½" b""" ’\n *\x08‰WF°mÛ–\x12\x17+ """ b"œ°\x1Dóoï373òï\x1C–7è8" b"¯Å–œu¹½\x1C\tøÌ\x03\x00\x06ó" b"¾,E¯ÔÁ\x1FÆž®ú¥ýzÏ\x12" b"À1Õéæžd\x15J\x1Dº’\x19”.†" b"É‹ä–Mé•ûb p~¡QC" b"Ì\x1C9\x02},¬EÕ&\x1F“ôÜ_r" b"ÒH\ªR"âSûïÏ\x15bý*Ž" b"Ô´»;™\x08>C\x01yþ\x02`\x1E¬%" b"Ü÷áÊ«ˆÝf€òUË\x10Š#\x1D" b"ÜþÑX@S’\x7FéÂJP\x03ÎÎÿ" b"Ý\x16Î$!øBæ×Ï\x11>\Y¬" b"ö‹Jzw¼åÑ{¶KŒöV\x7F" b"û4¨‡:xÈßÐ(µà¥–e4" b"\rö½{\fCES¡-ª\x1C'ø\x0Fº" b"\x0EÎe9ëK\x1CFjVž¹\x05kˆÛ" b"\x12Ÿ)¸¿ÉðZ˜ãRÑþ\x06Ø\x1C" b"\x1EÌaÄ`‘›»K¿¾:Ƹ¹£" b""Žî€-¢\x03 ïžË8åã@\x18" b"'\x19\x00ÄácTø%@®V@Œ»„" b".ÿìÐà\x08\x13Ÿ:ú’Ü\x18d:@" b"2€\x14\x1FÜh[²Jo£†Ë\x18\x13i" b"7Œm\x07\x0EýQ©ý^q}\v;\x01Ì" b"Q<·MÂLVâÄ]\x17Ó\x16\rŽC" b"Sѯ\x10ÔU7\x04ÀÿP¤¡Ÿ\x02" b"W€ƒ6\x08mF%/6’ÏŠ;CU" b"[Ï\x01¦¤ù ôÙ®ÇÊ”\tÆJ" b"i•\x10²9šºý\x12êm\x17Ì=vø" b"l•nXÐÅ\x08\x13‰¿—Ú—FÈ\e" b"oßØ£Ò‡®Í‡8öaV.\x01D" b"oõé½\´\x1E\x11Ò0ÄKŒse" b"p!1µØ\x0EQÅ\x12†™Ùb¢Ý‡" b"t\vŠñNZ\fÒRÈ#ªY¼§‡" b"tÍ\x0FÁdUn\x04üæNþë YO" b"u×K†™ &´ºÕÞ‚‡lO˜" b""" yÙÙ0 \n ß0¥“¸x¬¢†4 """ b"‚®¡Z,)êú:žµÁ…`XÆ" b"‚¹¥\x04-³ÎÊ(¡ìË\_¾" b"‹ æßrܯúäbIÉMSgs" b"•„ÉÚ~x8«Ýûgq²Í°" b"›\x1EÞ™¦§=LôZŠ¨³óÝV" b" ÚøNNx×}¿{”ò\x06P§\x7F" b"³ìñ\x10¬;é»°ëߨl‘e)" b"¶Xð|µ\x16)Qõe`]q%\x00d" b""" ºõ2\n Å.\n ›\n O+\x1Eùò_£ """ b"¾]¯‘gS¯0!‰†Ç\x04מE" b"¾˜5e__\x11("ix0+," b"¿xáñ¶^V†Û××èžC9Ï" b"É\x1E.×e²ŽÄÉ W'þÐh*" b"ÎN!†0qÉx[èº\x1A`\r´z" b"ÒÞQ\x16B*\x1A‡Ü§\x00•\x1Ds`¢" b"Ù\x14<¹ˆF숉ÁuË6ù™›" b"ïgoS:=co¾*Š(bb,¨" b"ïÂ`Ž9\x12›¤ê›µ\x01bûá " b"ð4¬é“¢$öòTaÂÙ\x11o" b"óªxÀÎ;e7íÙ¬áwº\f†" b"ôOô{bëJŒÚYóm\r\x15mþ" b"ý\x11ˆÆŠ}\x10°\vÅÙ ¸kê" b"\x02ªf)`\x1EGÒ3—ƒi6+N" b""" \n )‹À—8Ó½b¨\x15\vƒcXé """ b"\x10š•®\x1C\x1A\e\x06½F¤>¦\x19¸•" b""" \x14ÂSd\n qb`x—Ve\x13ÏÉ """ b"\x16RJÐ]!¢L]”Ò1å p‘" b"\x17ç®ÚÇt\x16¾»WH° ÌÔô" b""" \x1F>(ÈÓ¤\n õð6:„eƒ;® """ b"\x1F²¶]wȱ\x0FŒ/–;ZoX”" b" ðïçp\x06sT¥A6oéª[˜" b"!\x13†F©Ë_ôL^\x02Ó‹îæK" b"-…ܾ–…£ÑbuÙk‹èþQ" b"/Œ¤^%pþ/c2d®'hõn" b"4E\x18ý‡ð¡Û\x03\x10CmSt¾´" b":èük\x176%µo&¤4ký\x14¥" b";U›\x0F\x10OË’·Kü1a4\x1FP" b"B뙚%¬ÏEZR×CÌ\x7Fb˜" b"J&µNø%\x19ÍòV“˜ºÔÎi" b"K¥“\x00VÅF¿\x16ÛŽùõ" b"MÈÂ*\x02!•q,¢y‘“±Ý" b"]i0©ÌÀ<JÐaWÝ·è\x11\x08" b""" ]‰$\n z\x03\x1CcG[“.Z9\x11N """ b"`\x0E«¬Œå\x07–ú¦eY\x0E+•\r" b"l®\x17^ ÕNßµ3 „ÄLU" b"pú"_5ë|]ÂG<ÙXq„4" b"rü0¨\f«Žœãp/l3W¥F" b"v¬\x11\x1E¶šï„\x12“oáã[÷Q" b"zH9¼\x15·j@k\fG\x14IØ_µ" b"|L:B4ë¹\x07\‚]\x13aš#" b"\x7Fܧ\x03pø\x1Ef¦AÞ@C&'ä" b"ƒ’6:*ÏcTè–‹¶Þè" b"„m\x15+´\x01Pœ\e\x1EÇLÞߣ" b"„À^g\x07^>cd`|ÝEg5¹" b"ŒÚÎMÄ1·!"Ü‘îݯù" b"Ž8øÍq†gn^Þ+Ö\x1A»“”" b"’¢c®çJ°]\x1EK¥hãÀÙ²" b"”ó©Úþ\x04þR‡Š‹ƒ6tÖ;" b"¥Úq×%Ô‡²Ë\x1Dp]@Uƒ¢" b"§üpðÁ6¥œ'ñˆtH\x11\x1E<" b""" ª×UìNËxзUÉ \n â\x11 """ b"¬êÞ½gþX,Vê|\ªÑ;\x08" b"°ÔÝžV&4\x10r<Ÿw\x14/õ " b"ºšOxÖAiáòEmTi;v" b"ÀÊ\x05ð\x0E’\x0F‘åë\x06¯²\x02L" b"Èu™s¤Ëô¤Æ\x16\x0Fë¼'8" b"Ò\f ÕÖ\x14Ë)ÌâöœEÔ" b"Ó\x16‰C6O£6g•$Š_\x18ìø" b""" Ó+Éu¢äòÓ\n ©Oò|ªA """ b""" Ö\n \x03÷·ðúÜpj†Éã\n ‚ö """ b"×wŒ.œO\tue¦ú¦}dzå" b"Þð1¯W2&᯷Ÿw㙬" b"䬻-Ý\vXu<ÎhßµU÷ƒ" b"õ\x06¼\t#\r¬ÈÀ\x04Uäˆjh" b"\x03;#@?—J×53@ê\x07Ö\x060" b"\x03Ž‰™=ò’…?®hReè\x0Fa" b"\x04Aa\x7FãÃFŠ<’\x07Z:€¥" b""" \n U€\x12$ù\x0E¯‚¾”\x15ëÒer """ b""" \n §\x10³oX¥\x13˜á10.É– """ b"\fÊ2œHd'´ÛªÚ\x0Fèƒa" b"\rÃèrJDŽ9\x07ì“NoU×—" b"\x0E¼3Õ•GUë]\x05´ù\x05â" b"\x12ö–¦¸\x01iÓv-ðu"Ü©Ý" b"\x13ºZ£‡¢]àÆ\x03äõd™ûØ" b"\x17•Ö\efB5úoŽ\x0E¡ÃPô+" b"\x18’Ë@JP½×Q\f£w¡1œT" b"\x19Wy\x01`1?»\x03:ªD•PÀ" b"'hôt—<—[\x02v½\x07A‡2" b"*B[Ó¼‰jk½ÚîBáÔ\x7FÃ" b"/\fí“\x1CÚ"\v\x06¬ÓHÎÁÀ‡" b"6\x07"Z9\x00:\x06·U;\x04m–0" b"8 ´¤ªã\x02Ô>÷ªSoYû" b"<iá×Ù8„‹qM~i\x1FGŸ‘" b">ÏçKãÉKåB„ïk2jmÞ" b"?\x04l+3èÉ=§_•"˜ZîŒ" b"?”9¦\x02ޚ߉HeEš\x1E4Å" b"@<¢\x05QB\x14ä’Ðbûßú\x05" b"Gü\x19Øëê§ÄÕ¯/ AñÊÕ" b"MŒv¢\x07k\x13µrto8‰\x04Ù" b"T»4fÏÖN…vn™˜1¥^" b"Vá2|·ë‚Ž‹×U^²Õ" b"fO\x13¨uðas3_:_…Qg\x10" b"gèð"\x1A\x10+çZn´d 7[û" b"iúø\ePÓ—çÒ;\x06º{┤" b"xç/n÷„y'ç3ô-§\x7F’%" b"}÷<—¡Íh´[2¤ý/YmÍ" b"€`3 Meuœ¥Po)z3¸ " b"‚\x05H\x03Ì¢qRTÉ\\x07M\tì(" b"ƒ›ü<*{OÌ$ñúå\x1Aýp" b"Œ±ÑMzf\vì\x1AöŒ\x05j^ÉE" b"k;$\x19ú\x04³½+ˆI±ŸÚƒ" b"’²\eدÍ\x0F€“ÒlY\x06\x17" b"”¨z¶½°D…äîV²ç bk" b"—ôë7ê$\vŠèýO+ÁkŸ" b"¡¾”Â\x11™\x13ÁÀ\x10œQ)_³" b"§Õ1£Ú\x19 î\x0Fƒ¯¤R<ëé" b""" ©â´CÉ\x0EužØKæOüW\n ô """ b"ª\x1A¡ˆŽØp²\x15æ¾.$ö\x19" b"ª\e\x01O_™!Lù´;ãz\x00”\n" b"ª€¶¨ùõ~ˆŸÂ¥ÁU€ïŒ" b"¬(±Ú~‚[ç¬g›El^ÓÚ" b""" º\x0E·\vn\n ±DñìÀ\x14‚¥8ž """ b""" ½\x1D\x0F/p¨-*\n ÝZë„Ìa """ b"ÂÉ[ZžÍ]Ÿ%âžsÈPaK" b"Å¿\x1C3\x0F€W\x137«VÑ‘\x17ñ=" b""" Ð%…»¶D¢{"\n ®\fëssq """ b"Ú?úI»T/\x08„\x10|@a>Y’" b"ÚðTRµ™šôNiF0rô" b"Ûñ5ý\x04}\,„º|KNfY\x03" b"á¬.âŽx 3uû*k~…ƒ#" b"ãí¡Zú!}Ê¿H†…rëÓ“" b"ç$Ì8œÄî,g5ï%›BÍ`" b""" ì¶Ía\e%•P/\n H\emô\x02ð """ b"ñ\r]DëX×%’m©å3\tßE" b""" ñ\x18\n \x13&‘¤›\x17Ò›DscE """ b"õó„Ø€moÑߟK\x08Y#\x1E\n" b"øÌƃÑ~Í ÏàÁƒ´\x07³Ž" b"ý›Î\x0E‰Y\x12gû!bÒùôvŽ" b"ý¢äúËO\x0FáÅ͹DžBl\x10" b"\x07ÛµPÃ’tèÿd÷ð\eØ\x00" b"\x0Eè¿Ý\æ\x17Õ>8\x1F"!°\x1Aæ" b"\x12ÿŠÃ\x1A>Û\x16鬰Æþç\x1C\x18" b"\x1A\x02:Ê\x1D2Ô#9Âw}h\x7F6‘" b"\x1Eª›Þ$§í¼\x05¬b((dÙ\n" b"'Z4€³ÏÝÚcñ¢B9P¬" b"-¥-\x08@ä\eƒ63\x1E&éY\x04ß" b"0.Õ:\x12Åw\x16\x07µí\x0Ef\v…\v" b"3\x18-£Lí±+\x15‚}g¶—ªò" b">¶Á=ûÛØ\x1Dl)ÄtZ7\r\x1F" b"A³ú+—Ì\x0E~*?C`€ïŠx" b"E€ÌòUL\x14â2]Vü\x00ê¶á" b"LÙøGâó+É. >m)F‰\x19" b"P`E\fÏѹeˆªîã\x15” ì" b"V\x08Öˆä$ß\x00ôêÐ*NÊ6Á" b"W¢ˆü+ï×Áǘ\x11Ž\êÃÅ" b"`8?†jðíq§À¾%\x18%mA" b"aÔÚ[p,{$Èü\x04øÍödj" b"k5kÅ\x12PrÁ\x11ä’ò\x06,Å" b"q\x03§Ô\x12§:å–\x00ß|–¼ë’" b"sÜAY›ÜÅ׎yvõD€\x04ü" b"z¾âBÁ\e¤»QŒü\x14Pþ?\x1A" b"|©\x13³@"%ö\x05Q˜\x1A‡¿mâ" b"€MŽ\x1EA¹™`ðš–T7" b"Ó©¼[\x0Fµ\vfìCê\x0F}@" b"„:Í¥ØÂL7z܉tË·%" b"…wîm<ȺmÒ\x17võ.¸±’" b"…¨’\x05ÿ@ú -¡Ýh|›\x18ò" b"‰p,_›ÜÏÁ\x12•m0D\x1DÆ–" b"Œ0¿VjêŠ,\x07ô›Ø\x1DM¿y" b"4\x14`~\x143\x02Td8\x1FêI¼" b"‘±¼u¼íP…\x1A]\x069ðí" b"“R\x0F%ŽÀ\5ø}¾‰Ká\x1EZ" b"“b\x7FõŽÉÖÑ£Åòí\eÔà³" b"—\x1Cáü\x1F€„ä::1ËäM\x12V" b"£×á\x1A?ºý¹½\ÁÛa߈" b"©¹Ð¥Ü\x1F[Ü~\x17Fya¯—¹" b""" ¬tÂJM\n q 0;\x0Ef\x159é\t """ b"ÅÏ\x062ñâ\f\x04$e€7\x19¹È" b"ÍXFÈtBúfËÀ\x11®)tá" b"Îñ‡ 4%¹¨ËÈÕR÷:5" b"Ï^5û\x05ÁЖ‹)]F#eã" b"Ú2—æ²ý.¹lãª1…ö\x0F\x1A" b"Ü\x1Eýéü1ÇžX-¡Õ¼±ç\x04" b"ÞhÔ,/–w?úeŠ]S—5¨" b"ßù(ïPÌèŠãápGJ·öñ" b"쇌\e9~\vÅ \x1D,\x05\x15\x19æ\x12" b"ð‰\x17\x19ÊÏã=éÝ•Ú·úé0" b"óa^ä]*4Y\tfì©\x0FÇ{Ë" b"ósQejhW?2¹`Ì‘ß\x1D\x01" b"õ}NP\x7F¶\x01\x07QtTâUv±Ê" b"ø’QÁa³õ·¦v\x17²\x04ûÌÕ" b"\x02}\x07.\x12h“ @ÿªÅýy\x03®" b""" \n \x05šÄ>ÄÈ°×K\x1AYR,\x180 """ b"\rr\eiÆ\e@1ÿÏJJŽ;\x0E6" b"\x10Dðù½åÙt—%ÓÉÜ\x1F\x15" b"\x1C:,\x07Oî\x12‰\x1CQNüªFï/" b"\x1E¨ß{˼̣]\x00\x17Eº›p’" b"*:šK‡\x1EXÛò¡J½\x02³\x05V" b"+b¥º£” ¯´Ò—ë´ºË|" b",¼òßZ%)ƺ1\x14PM’ÿ" b".Œ\x06i‘Ý„Äö²'½ À\x05¹" b"/Uʾk9”b¾àMñóÉÛß" b"6\x02ËB\x19W\x14A †«2¢jý4" b"6Ÿ3#Z„î€5¢üDZ”º£" b"6¥sEj¸—ß-ŸWÿ\x18 õ" b"6î*H¬…\x7F!)ÐÐw\x07äìs" b"AF\x11|ñÞ'\eKS'\x13v©ú±" b"B\x12«±Dæ\x06œ5O\x07vo\vLŒ" b"H\x08±p'4‡\x10ŸRèÿ")„ " b"I7•v‘\x07x³\x13ªþÁÅFÒ" b"Nb ý[è\x0E\x1CO>’‡³k—\x15" b"Q2ga˜(c6éF_µ«\x06=µ" b"Që\x1A\x03\x07õ¥\\x14\x0EáÒ°5Mš" b"U\x05ʲ…ŠR`\x12Ãý‰\x11\f\x1CÞ" b"ZÜVûéüÈÖÞ°à˜\x14í" b"]`OFãl\x05k¥Ÿò*p#wC" b"_˜í\rÀÃ\x03A‚\x7F“cîn\x0FI" b"d«OÞ\x16ÑP\x10>ÀI0s›$" b"n4€¼ÕEn€¢ÙbÂAœ«q" b"qæ\x15Æ”™ÂAÙXjõù§•%" b"t-ÅÙ·W€<+„æ\x1Fly\x01" b"w"»4¤ÒJØáyø/ÄN®" b"xm;à\tg©ˆ{ì[ÞÛ\x11%ô" b"‚LUÞŽt[µ©^\x070Ãp*" b"‚Õ\r¿u\x06lŽé9ëêŽ×?^" b"Š*„&%;öF\x05£\x08\x1DºP]" b"—¯CƒëLHßWyflZ{t»" b"›\x11Ðɇùî‹/\x10 Z\x0EIÜw" b"£G?\vpÝâŠ\x0E"‰zÅŽ\x13þ" b"¥¹}\x0E³Øldb|©GØÔ‘" b"¦ÑaUäöÿ2Üš™„\x13Ô`P" b"§x9‚püÀìM7¥¼\x11çšÑ" b"«ïjß‘ý^A/s¾Â£[Á]" b"¼•Ù¾\x16éŸta\x13Õßz©\x1C" b"¼Æ'\x02ÉðÓ›!\x12‹ß\x0F¶¹\r" b"¾~·‹Û\x08d}Ï£*÷Ì’\x139" b"ÀLy¾‹owLýŸC²F8" b"Àæ©á*Aò¹[\x03W>\r%ñD" b"Â8+\x0E\x01W—±SÊÈ(`hØ\x03" b"Ã}–þ\x15¶©)óVZ\x14\x174Ÿ\x06" b"ÇŸà\x08/$Ÿä"ª á´\x1F-%" b"ÈÈ߀h»ê…)qqÁo–lë" b"É\x1Ao+„þ8Qs^\x18ÝAþ\x00" b"Éf„3¶ƒámÂGÕNs\x18" b"Éĺ}Õk©ñF,e'’_" b"Ë\x05¡o~;ÀÅLŠœFì~•]" b"̽\x04-åÿžO`+Ø’n~Z" b"ÍË—q×bùÉ4\x1CÏÐÑ^—¤" b"Ï#r\x05þs?m«û”IDÛ*ý" b"Ò\x14¸‰ÏïŸÓb\x06.wGdiê" b"ÖrJiGVe„ú\u÷É|«V" b""" ܾ\x08!ÌÉw\n E@¤Ž…eÔ """ b"ݪ¬v\x0F5s¥»\x08™/%£\x18c" b"àf7o†ø×+úü[ocS" b"äÇàˆÔÕhŒ,Üɼ—?\x02" b"é6)J\x1AÙãçˆ;\e°„\x07\x18" b"éÐBÊØÊùÎ\eh\x1EN\x7Fë™" b"êl\x1Ft'\x0EPe¨‹I\eFó\x1A´" b"ðä={\x00ãQׄ\x17p¤a¦dG" b"òÀƒÛªí\x7Fç0PíTóèÁÔ" b"öà0· ”Þ°K±üÂ_\x1Dš]" b"÷çHôóžó?ñV#ò\x19Ü1ï" b"ø€·åu?ëT7ð¤¥>‹kÕ" b"\x04ìÎ'ÁÀ§™\x07R<pùc„" b"\x05¶,”ÊçU¥]ÕKæS'íW" b"\x08+Y.ð”¸Kð´ÿ¡5·Y" b""" \vµ\x01\x1CÛàýˆ[ÔOtÜ\x08\n š """ b"\r\x0EÒaŒS\x0F\x07Ž\e'βX‰í" b""" \x0F'Y¢”µý½)WÂ\n NßÈ """ b"\x11 *ñQž=•o@{Öˆ(¼£" b"\x14ÔúxÅ¢C\x12Õb'D$à¾" b"\x17à1.}Ž¯„ë.y(H‡À;" b"\x19\x03èÕúAj¼%¢¸—€ì…$" b"\x1DÊ$ð(‘âç‡.\x172\x18s³" b" )+£ ÿN5–Ò5P†®zt" b"!L=/\x18"\x7F\x01\x12Q\x00\x02Â\x14C" b"$0å¸_c\x01(I\x16 ‘tðoî" b"%%ê\x01Anþˆ…V*uˆ\\x19Z" b"*h®ÕE»º¨Õx\x00ñ‘Ë÷M" b"*ÎîÞ|Õ=\x15Üˉ§õ4VÓ" b"+PÔÁ\x19CÂæ¹³\x150ÛH¾S" b"7|)pcº†Ö‚Ü›¦Wº$Ï" b">}>}Få“âÑ•Èѹ\x06£" b"DÝ•\x7F¤A¯RGˆøyëfØ$" b""" Ewv\x1EÏ•\n pò3í,¸‹hì """ b"G\x0EXu\x05‰çÂ$\x1Am\x1F%rÚø" b"Hß¼6IËi3ÓÓcRÔC\x14´" b"IO÷‘¿ï>ºGq\x01M\x11˜ì" b"P¡\x7FÝížÐoažuãñàB÷" b"S@í\x07z–N5»\x19úq‰Âò" b"Tô!m‚[€\x14àÍÌ2¤"“Ž" b"Wëðë\r,X<\x00·€¨)z™" b"Yd¦\x05!e9cê‡ÊsÃÍ\x06" b"b† \x157ýÕâ"J=\x1E,\x06f" b"bŽ\x01Sú_æ³ÒULíÙî‚" b"j«§ ?\x12÷;§\x002‚3ô\x08³" b"k\x160¬*qèúÏ©ÎCõ\x08\x02i" b"n==î\x1Dfk@©(Í4H$[" b"wä'rˆjÅîâfÜÿ%™KÕ" b"{âfI\r(\x08p)\x0EJ®àŸ " b""" ~8\x0FØ*k— ©ï\x14Þ¡s\n Š """ b"‚\x0F5Y\x0EPÜe;W1V|E" b"ƒ\x15%µâÐ-£"9߬h\x18G" b""" ƒ1#R\n BƒŽ\x04„Àós·\ """ b"Žòp¤ô\x18óŽxù*€?\x03©œ" b".—yY²ŽD‚!Fº‚Qþ\x7F" b"’àc\f\vÉ4w¹·ÄŠÃ“¯" b"–Ûζì¤j~Z\x18(‘ J‡" b"šp´\x1F=Ë\x1FhËþ·ýk¬ð'" b" Ö4ñGÑY\x1Aô¯þÜH-&Ê" b"©Øo^ü6\x01\x00T&ì¡WS=ð" b"¬20\x03\x12i}t\x0FW+†ê¾w§" b"¬‰F¶*l\x0Fæ-¡°dbºb" b""" æàmTµ\x11\n iJPüß¼ù\ """ b"°Úþ:Ã\x0FH’fÂÇ#ø\x06Vå" b"³³›C¢\x08¢x7ü™¼\rþ\x08Û" b"¶\x10¼@T`HEg\x14ì¦ÿ" b"¿Ò㮨\x1CBdlqº‹=“\x06ê" b""" ÂAz¦Xk·É\x13‚¨zî\x01\n c """ b"Ä5Ð6øÒÍ`\x04™c\x11‹Ïh€" b""" Ç¡Û[\n ¡³³„̸¾\x13ü‘ì """ b"Í\x12í‘.Q\x12ò„§ö\t%öðI" b"Í U58ZvP1T5¼…\ex€" b"Ò\x0F†H‹õ\x18¤Ï²&Û9Á\x04" b"Üæ燰£Âµ{y”ßÒôJ" b"㤙c\x1DÃx9©\x08àØ\x12×C\x1D" b"åC)‡x5æŽ"læZC*hÆ" b"è7]ïæÐïr\x0F`FÙ¥s\vu" b"è¯$ôû,‹\x1A\x18\x1FW\x1AŒ´7\x15" b"èü„\x05RpO»¶Ò¶¬†M\x0Eú" b"ì‘TÙÍg\x12£+-kåîI$ñ" b"í\x0F\x1AG\x17k8Oó‡qË(\rÛ*" b"îH,¨C+1 ÙjÓËo’\x1Aq" b"ïS'\x0EÅ\x19šQ¢È*„1Ì¥/" b"÷Ïf@91Â\x08]úŽ\x05C<\¥" b"ùƒ/ÝA0îL\x1EbQFcd“" b"ú\x11,êÁ“\x11\x0EÕŠb™³\t\x1F”" b"ý¢¨„;\x1Ey\x16›"Ó¢—Èn " b"\v(¶\x1E)‚ú³Ç+\x03bÔi¿" b"\x13ûÆc²\x16$°þ–¨•Òâ¹Ù" b"\x16sF¯Ÿ&œå¨ú0ãéï•" b"\x18FG¬=õݺÐ<ü¤®ý\x03À" b"'ÝhRYÄm¶Ç :uûðœC" b"*N~E_Äö™W\x06\x19£Íyv>" b"1X½\x1CSÜ\x1FA>F=\v˜]Ñ" b"3Q\x02!ópÿp{UËàÛ'vä" b"4¼šˆXˆùû†œxÿ»Ë3Ï" b"5܈ô–T\x11=Ù[ö:ãM{" b"6*\x13⥵WÀ\x17T©øº1[P" b"=Uí1—-ÝŽˆÎH\x1DÿÃt" b"BKŒâîFm̆$w\x024ØhÝ" b"D0\x0E›X\ú\vzÅüèpo\x13ˆ" b"GN$ø¯\x0EÁ½Æy8Èö†$" b"GT\x16úOøÙ;è¹É÷\x19‹6î" b"KHrÄ€ýý"ÉÐ}Žtý£" ] |
||||||||||||||||||||||||
|
9.19 ms (3.51%) |
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/13a65f0962e64be9ab3210a371a2f790" "/navigation/17a3e1082a41422486b5cd8312b85338" "/navigation/ce8d2ea829eb4f068922ce8d9928aaf8" "/navigation/00000186a07e7e7e7e7e7e7e7e7e0001" "/navigation/000003d0907e7e7e7e7e7e7e7e7e0001" "/navigation/000006ddd07e7e7e7e7e7e7e7e7e0001" "/navigation/00000493e07e7e7e7e7e7e7e7e7e0001" "/navigation/0000057e407e7e7e7e7e7e7e7e7e0001" "/navigation/00000668a07e7e7e7e7e7e7e7e7e0001" "/navigation/4d689ea4e1ee4be7a7ff17c3d1c2a9fd" "/navigation/0d5c0178b61f43409317ecb7f0423217" "/navigation/9f316991c7b843988ba2d691af81e051" "/navigation/b5f029ae393e42019d3c84d1745747d9" "/navigation/87329892f04642a091cf97d76cf2e172" "/navigation/d0c3ec10ad7f43eab1566c1442929e7b" "/navigation/405d1cbfa9ac40988230b3550335457d" "/navigation/fc1ec1df1e6e4f1a8143c5ba27bf4971" "/navigation/73d86ffcbaf24d1ead280925070a92d7" "/navigation/830789a628d847209c38fd4dede151ef" "/navigation/604b2db8d0664366b6b22358d17f7a59" "/navigation/3effeb8dc90a440cade956cd15571d2e" "/navigation/6a9710cbd4ef455d882138cc36089aed" "/navigation/13f58cf7fb2d4fdc8090e2d111219483" "/navigation/413ab9571e424278a787f8a4381c0c9f" "/navigation/853c3c6b6ffe47e2866acbc815d7ef0d" "/navigation/37e42c1a596f44aaa610954f0a82095e" "/navigation/0a500eeb24b74c4eab8e1982232bf4f7" "/navigation/0799bf2edc454c3287d633d9afd8d680" "/navigation/92bb5f4d67e84697841c730082f2bbda" "/navigation/1756c757bedb444bbacec61fc6f0c159" "/navigation/eb040e19715440c08c9806233a73f42a" "/navigation/d5f98579fc6a4def8a173f3cd4eb0c1f" "/navigation/d67ef9c439bf46b9976fd4c577abecc9" "/navigation/9fc9bc9065d44af9984985664c242443" "/navigation/3b0c1d5504484565a8bdced3ab2d3665" "/navigation/b90f87fb1a1c4230af629184792d84e3" "/navigation/eb51729977f44659b74712aad3e7e7a3" "/navigation/e907e8f1668c4fb4afe752ffe417a63e" "/navigation/f1b52c4932dc4ad590c5ee6ff62c87b7" "/navigation/88435e53e98c4d08877d9e13a9607c2a" "/navigation/00000249f07e7e7e7e7e7e7e7e7e0001" "/navigation/0000024be47e7e7e7e7e7e7e7e7e0001" "/navigation/0000024bee7e7e7e7e7e7e7e7e7e0001" "/navigation/0000024bf87e7e7e7e7e7e7e7e7e0001" "/navigation/0000024c027e7e7e7e7e7e7e7e7e0001" "/navigation/0000024c0c7e7e7e7e7e7e7e7e7e0001" "/navigation/0000024c167e7e7e7e7e7e7e7e7e0001" "/navigation/0000024dd87e7e7e7e7e7e7e7e7e0001" "/navigation/0000024de27e7e7e7e7e7e7e7e7e0001" "/navigation/0000024dec7e7e7e7e7e7e7e7e7e0001" "/navigation/0000024df67e7e7e7e7e7e7e7e7e0001" "/navigation/0000024fcc7e7e7e7e7e7e7e7e7e0001" "/navigation/0000024fd67e7e7e7e7e7e7e7e7e0001" "/navigation/00000251c07e7e7e7e7e7e7e7e7e0001" "/navigation/00000251ca7e7e7e7e7e7e7e7e7e0001" "/navigation/00000251d47e7e7e7e7e7e7e7e7e0001" "/navigation/00000251de7e7e7e7e7e7e7e7e7e0001" "/navigation/00000251e37e7e7e7e7e7e7e7e7e0001" "/navigation/00000251e87e7e7e7e7e7e7e7e7e0001" "/navigation/00000251ed7e7e7e7e7e7e7e7e7e0001" "/navigation/00000251f27e7e7e7e7e7e7e7e7e0001" "/navigation/00000251fc7e7e7e7e7e7e7e7e7e0001" "/navigation/00000252887e7e7e7e7e7e7e7e7e0001" "/navigation/00000252927e7e7e7e7e7e7e7e7e0001" "/navigation/00000253b47e7e7e7e7e7e7e7e7e0001" "/navigation/00000253be7e7e7e7e7e7e7e7e7e0001" "/navigation/00000253c87e7e7e7e7e7e7e7e7e0001" "/navigation/00000253d27e7e7e7e7e7e7e7e7e0001" "/navigation/00000253e67e7e7e7e7e7e7e7e7e0001" "/navigation/00000253eb7e7e7e7e7e7e7e7e7e0001" "/navigation/00000253f07e7e7e7e7e7e7e7e7e0001" "/navigation/00000255a87e7e7e7e7e7e7e7e7e0001" "/navigation/00000255b27e7e7e7e7e7e7e7e7e0001" "/navigation/000002579c7e7e7e7e7e7e7e7e7e0001" "/navigation/00000257a17e7e7e7e7e7e7e7e7e0001" "/navigation/00000257a37e7e7e7e7e7e7e7e7e0001" "/navigation/00000257a47e7e7e7e7e7e7e7e7e0001" "/navigation/00000257b07e7e7e7e7e7e7e7e7e0001" "/navigation/00000257ba7e7e7e7e7e7e7e7e7e0001" "/navigation/00000259907e7e7e7e7e7e7e7e7e0001" "/navigation/000002599a7e7e7e7e7e7e7e7e7e0001" "/navigation/00000259a47e7e7e7e7e7e7e7e7e0001" "/navigation/00000259ae7e7e7e7e7e7e7e7e7e0001" "/navigation/0000025b847e7e7e7e7e7e7e7e7e0001" "/navigation/0000025b8e7e7e7e7e7e7e7e7e7e0001" "/navigation/0000025b987e7e7e7e7e7e7e7e7e0001" "/navigation/0000025d787e7e7e7e7e7e7e7e7e0001" "/navigation/0000025d827e7e7e7e7e7e7e7e7e0001" "/navigation/0000025f6c7e7e7e7e7e7e7e7e7e0001" "/navigation/0000025f767e7e7e7e7e7e7e7e7e0001" "/navigation/00000261607e7e7e7e7e7e7e7e7e0001" "/navigation/000002616a7e7e7e7e7e7e7e7e7e0001" "/navigation/00000261747e7e7e7e7e7e7e7e7e0001" "/navigation/000002617e7e7e7e7e7e7e7e7e7e0001" "/navigation/00000261887e7e7e7e7e7e7e7e7e0001" "/navigation/00000261927e7e7e7e7e7e7e7e7e0001" "/navigation/000002619c7e7e7e7e7e7e7e7e7e0001" "/navigation/0000030d407e7e7e7e7e7e7e7e7e0001" "/navigation/0000030f347e7e7e7e7e7e7e7e7e0001" "/navigation/0000030f487e7e7e7e7e7e7e7e7e0001" "/navigation/0000030f4d7e7e7e7e7e7e7e7e7e0001" "/navigation/0000030f4f7e7e7e7e7e7e7e7e7e0001" "/navigation/0000030f527e7e7e7e7e7e7e7e7e0001" "/navigation/0000030f537e7e7e7e7e7e7e7e7e0001" "/navigation/0000030f547e7e7e7e7e7e7e7e7e0001" "/navigation/0000030f577e7e7e7e7e7e7e7e7e0001" "/navigation/0000030f5c7e7e7e7e7e7e7e7e7e0001" "/navigation/0000030f987e7e7e7e7e7e7e7e7e0001" "/navigation/0000030fa27e7e7e7e7e7e7e7e7e0001" "/navigation/0000030fa77e7e7e7e7e7e7e7e7e0001" "/navigation/0000030fac7e7e7e7e7e7e7e7e7e0001" "/navigation/0000030fb67e7e7e7e7e7e7e7e7e0001" "/navigation/0000030ffc7e7e7e7e7e7e7e7e7e0001" "/navigation/00000310067e7e7e7e7e7e7e7e7e0001" "/navigation/00000310107e7e7e7e7e7e7e7e7e0001" "/navigation/00000310607e7e7e7e7e7e7e7e7e0001" "/navigation/000003106a7e7e7e7e7e7e7e7e7e0001" "/navigation/00000311287e7e7e7e7e7e7e7e7e0001" "/navigation/00000311327e7e7e7e7e7e7e7e7e0001" "/navigation/000003113c7e7e7e7e7e7e7e7e7e0001" "/navigation/00000311467e7e7e7e7e7e7e7e7e0001" "/navigation/00000311487e7e7e7e7e7e7e7e7e0001" "/navigation/00000311507e7e7e7e7e7e7e7e7e0001" "/navigation/000003115a7e7e7e7e7e7e7e7e7e0001" "/navigation/00000311647e7e7e7e7e7e7e7e7e0001" "/navigation/000003131c7e7e7e7e7e7e7e7e7e0001" "/navigation/00000313267e7e7e7e7e7e7e7e7e0001" "/navigation/00000313307e7e7e7e7e7e7e7e7e0001" "/navigation/000003133a7e7e7e7e7e7e7e7e7e0001" "/navigation/00000313447e7e7e7e7e7e7e7e7e0001" "/navigation/00000313467e7e7e7e7e7e7e7e7e0001" "/navigation/00000315107e7e7e7e7e7e7e7e7e0001" "/navigation/000003151a7e7e7e7e7e7e7e7e7e0001" "/navigation/000003151f7e7e7e7e7e7e7e7e7e0001" "/navigation/00000315247e7e7e7e7e7e7e7e7e0001" "/navigation/00000317047e7e7e7e7e7e7e7e7e0001" "/navigation/000003170e7e7e7e7e7e7e7e7e7e0001" "/navigation/00000317227e7e7e7e7e7e7e7e7e0001" "/navigation/00000318f87e7e7e7e7e7e7e7e7e0001" "/navigation/00000319027e7e7e7e7e7e7e7e7e0001" "/navigation/00000319047e7e7e7e7e7e7e7e7e0001" "/navigation/00000319077e7e7e7e7e7e7e7e7e0001" "/navigation/0000031aec7e7e7e7e7e7e7e7e7e0001" "/navigation/0000031af67e7e7e7e7e7e7e7e7e0001" "/navigation/0000031ce07e7e7e7e7e7e7e7e7e0001" "/navigation/0000031cea7e7e7e7e7e7e7e7e7e0001" "/navigation/0000031cf47e7e7e7e7e7e7e7e7e0001" "/navigation/0000031cfe7e7e7e7e7e7e7e7e7e0001" "/navigation/0000031d087e7e7e7e7e7e7e7e7e0001" "/navigation/00000320c87e7e7e7e7e7e7e7e7e0001" "/navigation/00000320d27e7e7e7e7e7e7e7e7e0001" "/navigation/000008b1807e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbba07e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbc047e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbc0e7e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbc187e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbc227e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbc687e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbc727e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbc7c7e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbc867e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbccc7e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbcd67e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbd307e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbd3a7e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbd3f7e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbd447e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbd497e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbd4e7e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbd537e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbd587e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbd5d7e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbd627e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbd947e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbd9e7e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbda87e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbdf87e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbe027e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbe0c7e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbe207e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbe2a7e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbe5c7e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbe667e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbe707e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbec07e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbeca7e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbed47e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbede7e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbf247e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbf2e7e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbf387e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbf427e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbf4c7e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbf567e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbfec7e7e7e7e7e7e7e7e7e0001" "/navigation/00000dc0007e7e7e7e7e7e7e7e7e0001" "/navigation/00000dc0507e7e7e7e7e7e7e7e7e0001" "/navigation/00000dc05a7e7e7e7e7e7e7e7e7e0001" "/navigation/00000dc0647e7e7e7e7e7e7e7e7e0001" "/navigation/00000dc06e7e7e7e7e7e7e7e7e7e0001" "/navigation/00000dc0787e7e7e7e7e7e7e7e7e0001" b"/»_ââšMpªXTÎ|ãâ\v" b"¤½mg\x16ÖA&½Ssª¾èɯ" ] |
||||||||||||||||||||||||
|
6.59 ms (2.52%) |
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%" "%|c7b4532d41104fd9a780deeb543b5f2c|%" 4 true true ] |
||||||||||||||||||||||||
|
6.21 ms (2.37%) |
4 |
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[ b"¤½mg\x16ÖA&½Ssª¾èɯ" "44S7lgDNZXHgps8miY66jaiTloy2acW1" ] |
||||||||||||||||||||||||
|
5.74 ms (2.19%) |
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"¤½mg\x16ÖA&½Ssª¾èɯ"
]
|
||||||||||||||||||||||||
|
5.31 ms (2.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"¤½mg\x16ÖA&½Ssª¾èɯ" b"¤½mg\x16ÖA&½Ssª¾èɯ" ] |
||||||||||||||||||||||||
|
4.70 ms (1.79%) |
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`.`cms_navigation_page_id` as `category.cmsNavigationPageId`, `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`.`file_hash` as `category.media.fileHash`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, `category.media.translation.title` as `category.media.title`, `category.media.translation.alt`, `category.media.translation.alt` as `category.media.alt`, `category.media.translation.customFields`, `category.media.translation.customFields` as `category.media.customFields`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields` 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` = ? OR (`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%" b"Ç´S-A\x10OÙ§€ÞëT;_," "%|c7b4532d41104fd9a780deeb543b5f2c|%" 1 4 ] |
||||||||||||||||||||||||
|
4.56 ms (1.74%) |
3 |
# seo-url::resolve SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND ((seo_path_info = ? OR seo_path_info = ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"¤½mg\x16ÖA&½Ssª¾èɯ" "Laborverbauchsmaterial-Geraete/Produktgruppen/Allgemeiner-Laborbedarf" "Laborverbauchsmaterial-Geraete/Produktgruppen/Allgemeiner-Laborbedarf/" ] |
||||||||||||||||||||||||
|
4.26 ms (1.63%) |
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`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `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`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.swagCmsExtensionsForm`.`id` as `cms_slot.swagCmsExtensionsForm.id`, `cms_slot.swagCmsExtensionsForm`.`cms_slot_id` as `cms_slot.swagCmsExtensionsForm.cmsSlotId`, `cms_slot.swagCmsExtensionsForm`.`cms_slot_version_id` as `cms_slot.swagCmsExtensionsForm.cmsSlotVersionId`, `cms_slot.swagCmsExtensionsForm`.`is_template` as `cms_slot.swagCmsExtensionsForm.isTemplate`, `cms_slot.swagCmsExtensionsForm`.`technical_name` as `cms_slot.swagCmsExtensionsForm.technicalName`, `cms_slot.swagCmsExtensionsForm`.`mail_template_id` as `cms_slot.swagCmsExtensionsForm.mailTemplateId`, `cms_slot.swagCmsExtensionsForm`.`created_at` as `cms_slot.swagCmsExtensionsForm.createdAt`, `cms_slot.swagCmsExtensionsForm`.`updated_at` as `cms_slot.swagCmsExtensionsForm.updatedAt`, `cms_slot.swagCmsExtensionsForm.translation.title`, `cms_slot.swagCmsExtensionsForm.translation.title` as `cms_slot.swagCmsExtensionsForm.title`, `cms_slot.swagCmsExtensionsForm.translation.successMessage`, `cms_slot.swagCmsExtensionsForm.translation.successMessage` as `cms_slot.swagCmsExtensionsForm.successMessage`, `cms_slot.swagCmsExtensionsForm.translation.receivers`, `cms_slot.swagCmsExtensionsForm.translation.receivers` as `cms_slot.swagCmsExtensionsForm.receivers`, `cms_slot.translation.config`, `cms_slot.translation.config` as `cms_slot.config`, `cms_slot.translation.customFields`, `cms_slot.translation.customFields` as `cms_slot.customFields` FROM `cms_slot` LEFT JOIN `swag_cms_extensions_form` `cms_slot.swagCmsExtensionsForm` ON `cms_slot`.`id` = `cms_slot.swagCmsExtensionsForm`.`cms_slot_id` 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` 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` LEFT JOIN (SELECT `cms_slot.swagCmsExtensionsForm.translation`.`swag_cms_extensions_form_id`, `cms_slot.swagCmsExtensionsForm.translation`.`title` as `cms_slot.swagCmsExtensionsForm.translation.title`, `cms_slot.swagCmsExtensionsForm.translation`.`success_message` as `cms_slot.swagCmsExtensionsForm.translation.successMessage`, `cms_slot.swagCmsExtensionsForm.translation`.`receivers` as `cms_slot.swagCmsExtensionsForm.translation.receivers` FROM `swag_cms_extensions_form_translation` `cms_slot.swagCmsExtensionsForm.translation` WHERE `cms_slot.swagCmsExtensionsForm.translation`.`language_id` = ?) `cms_slot.swagCmsExtensionsForm.swag_cms_extensions_form_translation` ON `cms_slot.swagCmsExtensionsForm.swag_cms_extensions_form_translation`.`swag_cms_extensions_form_id` = `cms_slot.swagCmsExtensionsForm`.`id` WHERE (`cms_slot`.`version_id` = ?) AND (((`cms_slot`.`cms_block_id` IN (?, ?, ?, ?, ?))))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01›ÛÓ•ÁrƒŒ×ål\rÁÚ2" b"\x01›ÛÓ•ÁrƒŒ×ål\x0E‰ÿÃ" b"\x01›ÛÓ•ÁrƒŒ×ål\x10‘\x01s" b"\x01›ÛÓ•ÁrƒŒ×ål\x11?¯Œ" b"\x01›ÛÓ•ÁrƒŒ×ål\x12ûð " ] |
||||||||||||||||||||||||
|
3.71 ms (1.42%) |
1 |
# category::cms-page::association::sections::association::blocks::read SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`version_id` as `cms_block.versionId`, `cms_block`.`cms_section_version_id` as `cms_block.cmsSectionVersionId`, `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`.`created_at` as `cms_block.createdAt`, `cms_block`.`updated_at` as `cms_block.updatedAt`, `cms_block.swagCmsExtensionsBlockRule`.`id` as `cms_block.swagCmsExtensionsBlockRule.id`, `cms_block.swagCmsExtensionsBlockRule`.`inverted` as `cms_block.swagCmsExtensionsBlockRule.inverted`, `cms_block.swagCmsExtensionsBlockRule`.`visibility_rule_id` as `cms_block.swagCmsExtensionsBlockRule.visibilityRuleId`, `cms_block.swagCmsExtensionsBlockRule`.`cms_block_id` as `cms_block.swagCmsExtensionsBlockRule.cmsBlockId`, `cms_block.swagCmsExtensionsBlockRule`.`cms_block_version_id` as `cms_block.swagCmsExtensionsBlockRule.cmsBlockVersionId`, `cms_block.swagCmsExtensionsBlockRule`.`created_at` as `cms_block.swagCmsExtensionsBlockRule.createdAt`, `cms_block.swagCmsExtensionsBlockRule`.`updated_at` as `cms_block.swagCmsExtensionsBlockRule.updatedAt`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`id` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.id`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`name` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.name`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`priority` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.priority`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`description` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.description`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`payload` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.payload`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`invalid` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.invalid`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`areas` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.areas`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`custom_fields` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.customFields`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`module_types` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.moduleTypes`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`created_at` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.createdAt`, `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`updated_at` as `cms_block.swagCmsExtensionsBlockRule.visibilityRule.updatedAt`, `cms_block.swagCmsExtensionsQuickview`.`id` as `cms_block.swagCmsExtensionsQuickview.id`, `cms_block.swagCmsExtensionsQuickview`.`active` as `cms_block.swagCmsExtensionsQuickview.active`, `cms_block.swagCmsExtensionsQuickview`.`cms_block_id` as `cms_block.swagCmsExtensionsQuickview.cmsBlockId`, `cms_block.swagCmsExtensionsQuickview`.`cms_block_version_id` as `cms_block.swagCmsExtensionsQuickview.cmsBlockVersionId`, `cms_block.swagCmsExtensionsQuickview`.`created_at` as `cms_block.swagCmsExtensionsQuickview.createdAt`, `cms_block.swagCmsExtensionsQuickview`.`updated_at` as `cms_block.swagCmsExtensionsQuickview.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`.`file_hash` as `cms_block.backgroundMedia.fileHash`, `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`, `cms_block.backgroundMedia.translation.title` as `cms_block.backgroundMedia.title`, `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation.alt` as `cms_block.backgroundMedia.alt`, `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation.customFields` as `cms_block.backgroundMedia.customFields` FROM `cms_block` LEFT JOIN `swag_cms_extensions_block_rule` `cms_block.swagCmsExtensionsBlockRule` ON `cms_block`.`id` = `cms_block.swagCmsExtensionsBlockRule`.`cms_block_id` LEFT JOIN `swag_cms_extensions_quickview` `cms_block.swagCmsExtensionsQuickview` ON `cms_block`.`id` = `cms_block.swagCmsExtensionsQuickview`.`cms_block_id` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN `rule` `cms_block.swagCmsExtensionsBlockRule.visibilityRule` ON `cms_block.swagCmsExtensionsBlockRule`.`visibility_rule_id` = `cms_block.swagCmsExtensionsBlockRule.visibilityRule`.`id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation`.`media_id`, `cms_block.backgroundMedia.translation`.`alt` as `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation`.`title` as `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.`custom_fields` as `cms_block.backgroundMedia.translation.customFields` 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"\x01›ÛÓ•ÁrƒŒ×ål\rxÿ\x13" b"\x01›ÛÓ•ÁrƒŒ×ål\x0FÊA" ] |
||||||||||||||||||||||||
|
3.70 ms (1.41%) |
1 |
# product-listing-route::loading::read SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.parent`.`cheapest_price` as `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.manufacturer`.`id` as `product.manufacturer.id`, `product.manufacturer`.`version_id` as `product.manufacturer.versionId`, `product.manufacturer`.`media_id` as `product.manufacturer.mediaId`, `product.manufacturer`.`link` as `product.manufacturer.link`, `product.manufacturer`.`created_at` as `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` as `product.manufacturer.updatedAt`, `product.manufacturer.translation.name`, `product.manufacturer.translation.name` as `product.manufacturer.name`, `product.manufacturer.translation.description`, `product.manufacturer.translation.description` as `product.manufacturer.description`, `product.manufacturer.translation.customFields`, `product.manufacturer.translation.customFields` as `product.manufacturer.customFields`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||') FROM `product_option` `product.options.mapping` WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, `product.unit`.`id` as `product.unit.id`, `product.unit`.`created_at` as `product.unit.createdAt`, `product.unit`.`updated_at` as `product.unit.updatedAt`, `product.unit.translation.shortCode`, `product.unit.translation.shortCode` as `product.unit.shortCode`, `product.unit.translation.name`, `product.unit.translation.name` as `product.unit.name`, `product.unit.translation.customFields`, `product.unit.translation.customFields` as `product.unit.customFields`, `product.deliveryTime`.`id` as `product.deliveryTime.id`, `product.deliveryTime`.`min` as `product.deliveryTime.min`, `product.deliveryTime`.`max` as `product.deliveryTime.max`, `product.deliveryTime`.`unit` as `product.deliveryTime.unit`, `product.deliveryTime`.`created_at` as `product.deliveryTime.createdAt`, `product.deliveryTime`.`updated_at` as `product.deliveryTime.updatedAt`, `product.deliveryTime.translation.name`, `product.deliveryTime.translation.name` as `product.deliveryTime.name`, `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation.customFields` as `product.deliveryTime.customFields`, `product.cover`.`id` as `product.cover.id`, `product.cover`.`version_id` as `product.cover.versionId`, `product.cover`.`product_id` as `product.cover.productId`, `product.cover`.`product_version_id` as `product.cover.productVersionId`, `product.cover`.`media_id` as `product.cover.mediaId`, `product.cover`.`position` as `product.cover.position`, `product.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, `product.cover.media`.`id` as `product.cover.media.id`, `product.cover.media`.`user_id` as `product.cover.media.userId`, `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` as `product.cover.media.fileName`, `product.cover.media`.`file_size` as `product.cover.media.fileSize`, `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` as `product.cover.media.metaData`, `product.cover.media`.`config` as `product.cover.media.config`, `product.cover.media`.`path` as `product.cover.media.path`, `product.cover.media`.`private` as `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, `product.cover.media`.`file_hash` as `product.cover.media.fileHash`, `product.cover.media`.`created_at` as `product.cover.media.createdAt`, `product.cover.media`.`updated_at` as `product.cover.media.updatedAt`, `product.cover.media.translation.title`, `product.cover.media.translation.title` as `product.cover.media.title`, `product.cover.media.translation.alt`, `product.cover.media.translation.alt` as `product.cover.media.alt`, `product.cover.media.translation.customFields`, `product.cover.media.translation.customFields` as `product.cover.media.customFields`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, (SELECT GROUP_CONCAT(HEX(`product.subscriptionPlans.mapping`.`subscription_plan_id`) SEPARATOR '||') FROM `subscription_plan_product_mapping` `product.subscriptionPlans.mapping` WHERE `product.subscriptionPlans.mapping`.`product_id` = `product`.`subscriptionPlans` ) as `product.subscriptionPlans.id_mapping`, (SELECT GROUP_CONCAT(HEX(`product.streams.mapping`.`product_stream_id`) SEPARATOR '||') FROM `product_stream_mapping` `product.streams.mapping` WHERE `product.streams.mapping`.`product_id` = `product`.`id` ) as `product.streams.id_mapping`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`meta_description` as `product.translation.metaDescription`, `product.translation`.`name` as `product.translation.name`, `product.translation`.`keywords` as `product.translation.keywords`, `product.translation`.`description` as `product.translation.description`, `product.translation`.`meta_title` as `product.translation.metaTitle`, `product.translation`.`pack_unit` as `product.translation.packUnit`, `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`, `product.translation`.`custom_fields` as `product.translation.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`meta_description` as `product.parent.translation.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.manufacturer.translation`.`product_manufacturer_id`, `product.manufacturer.translation`.`product_manufacturer_version_id`, `product.manufacturer.translation`.`name` as `product.manufacturer.translation.name`, `product.manufacturer.translation`.`description` as `product.manufacturer.translation.description`, `product.manufacturer.translation`.`custom_fields` as `product.manufacturer.translation.customFields` FROM `product_manufacturer_translation` `product.manufacturer.translation` WHERE `product.manufacturer.translation`.`language_id` = ?) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_version_id` = `product.manufacturer`.`version_id` LEFT JOIN (SELECT `product.unit.translation`.`unit_id`, `product.unit.translation`.`short_code` as `product.unit.translation.shortCode`, `product.unit.translation`.`name` as `product.unit.translation.name`, `product.unit.translation`.`custom_fields` as `product.unit.translation.customFields` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation`.`language_id` = ?) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id` LEFT JOIN (SELECT `product.deliveryTime.translation`.`delivery_time_id`, `product.deliveryTime.translation`.`name` as `product.deliveryTime.translation.name`, `product.deliveryTime.translation`.`custom_fields` as `product.deliveryTime.translation.customFields` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation`.`language_id` = ?) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id` LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.cover.media.translation`.`media_id`, `product.cover.media.translation`.`alt` as `product.cover.media.translation.alt`, `product.cover.media.translation`.`title` as `product.cover.media.translation.title`, `product.cover.media.translation`.`custom_fields` as `product.cover.media.translation.customFields` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation`.`language_id` = ?) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" "\x00\x00\x00\x073~~~~~~~~~\x00\x02" b"\x00\x00\vÚÚ~~~~~~~~~\x00\x02" "\x00\x00\x00\x16;~~~~~~~~~\x00\x02" b"\x00\x00\x00\x1E›~~~~~~~~~\x00\x02" "\x00\x00\f\x1EP~~~~~~~~~\x00\x02" "\x00\x00\x00%v~~~~~~~~~\x00\x02" "\x00\x00\x00$P~~~~~~~~~\x00\x02" "\x00\x00\x00\x05J~~~~~~~~~\x00\x02" "\x00\x00\x00\x05K~~~~~~~~~\x00\x02" "\x00\x00\x00\x05S~~~~~~~~~\x00\x02" b"\x00\x00\x00\x1Eî~~~~~~~~~\x00\x02" ] |
||||||||||||||||||||||||
|
3.42 ms (1.31%) |
1 |
SELECT `language`.`id` FROM `language` WHERE `language`.`id` IN (?) LIMIT 1
Parameters:
[
b"/»_ââšMpªXTÎ|ãâ\v"
]
|
||||||||||||||||||||||||
|
3.32 ms (1.27%) |
1 |
SELECT `sales_channel_country`.`sales_channel_id`, `sales_channel_country`.`country_id` FROM `sales_channel_country` WHERE (`sales_channel_country`.`sales_channel_id` = ? AND `sales_channel_country`.`country_id` = ?)
Parameters:
[ b"¤½mg\x16ÖA&½Ssª¾èɯ" b"/NñAš(Bû©tûÓëE:{" ] |
||||||||||||||||||||||||
|
3.28 ms (1.25%) |
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`.`cms_navigation_page_id` as `category.cmsNavigationPageId`, `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`.`file_hash` as `category.media.fileHash`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, `category.media.translation.title` as `category.media.title`, `category.media.translation.alt`, `category.media.translation.alt` as `category.media.alt`, `category.media.translation.customFields`, `category.media.translation.customFields` as `category.media.customFields`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields` 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"\x00\x00\x01† ~~~~~~~~~\x00\x01" ] |
||||||||||||||||||||||||
|
3.27 ms (1.25%) |
3 |
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"\t,¿}{¸Eχ\x1F‹ÃXG\x02\x1A" b",õ˜–¯fGX–슽\x03¬&¶" b"8X•p\x16dMä®HÀP\vóÌÈ" b""" <}’kjGþŽJâ\r\n ™4$ """ b"iàé\vÔMFY‰ˆyvu.ýü" b"á7Ž·€ŠG‘ž\rt\r]l\x1A" b"é+6oàÎI{›^+L*,°ö" b"úŸë8R\eLPŠù\x1Aúüøžª" b"&×\x15wãeIÈ‹pK¹ç÷9\x18" b"(Ê®u¥bO\r˜Z½\x0E³*¡`" b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-" b"q\x01,<[öA=ƒ¹bAä{ÙÝ" ] |
||||||||||||||||||||||||
|
3.22 ms (1.23%) |
1 |
# product-listing::property-group-filter::read SELECT `property_group`.`id` as `property_group.id`, `property_group`.`display_type` as `property_group.displayType`, `property_group`.`sorting_type` as `property_group.sortingType`, `property_group`.`filterable` as `property_group.filterable`, `property_group`.`visible_on_product_detail_page` as `property_group.visibleOnProductDetailPage`, `property_group`.`created_at` as `property_group.createdAt`, `property_group`.`updated_at` as `property_group.updatedAt`, `property_group.translation.name`, `property_group.translation.name` as `property_group.name`, `property_group.translation.description`, `property_group.translation.description` as `property_group.description`, `property_group.translation.position`, `property_group.translation.position` as `property_group.position`, `property_group.translation.customFields`, `property_group.translation.customFields` as `property_group.customFields` FROM `property_group` LEFT JOIN (SELECT `property_group.translation`.`property_group_id`, `property_group.translation`.`name` as `property_group.translation.name`, `property_group.translation`.`description` as `property_group.translation.description`, `property_group.translation`.`position` as `property_group.translation.position`, `property_group.translation`.`custom_fields` as `property_group.translation.customFields` FROM `property_group_translation` `property_group.translation` WHERE `property_group.translation`.`language_id` = ?) `property_group.property_group_translation` ON `property_group.property_group_translation`.`property_group_id` = `property_group`.`id` WHERE ((`property_group`.`filterable` = ?)) AND (`property_group`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" true b"z~1\x1AšÊZT\x1EÉùl·¶ë" b"u;\x1Cð*‡\x07Ì’P4o©ÅJ\" b"ÉøéŽ\x19üŽ›a~R!€ø9ë" b"¨oÊ;€sÜ[õü\n\r´è\x00\x06" b"]Ž:²yô\x02ª½ßF\x18ª³Ã" b"hŠÅ<\x1CöH–ëèf«‰ƒÂ" b"¨²„Îå\x1FÐv“\\x1EÂvûô" b"ë<€à™\x1Aà/\x17ɲ=’]\x1D&" b"Ž|Ñá„ëfE…L–ñŒY\x0Fó" b"ð\eèių2ÚKäûv²ÁM\x16" b"Î}…Ô\x7F&S|Þ@,[\x13ã\x01" b"÷Ð?ôÌeò7càÙu\x10aô£" b"\fÔ÷"Ö"Þ‹ô\x1Eƒ†\x00\x01!í" b"›ìKŽü6ÍÓ‘\x1FlÎJya" b""" ´ÛK\x1EŽ\n RQé}¥®ÅPÁº """ b">:Ž$ÝjÁŽ¶ˆco“b9)" b"4š¬F”'^8ð¢Ž<Èòàñ" b"”\x03œ§\f¬Ø‹*ŠÄþÅyŽÍ" b"\v»½{³hô\x1F<<\x10Eå\I\x1C" b"#uxÌ“Ôµ3\v…Sj0\x07¸ö" b"d\x1D–%\x1CûÚ\x18TF•eï<ë6" b"˜Rr\x03gvˆŒ%„\tP\v%|Ý" b"\x10ìSšTŸ\x12.ô{êŽ\x12ÅM" b"Cwa5)Á"ƒ\x06o3áj´u–" b";›ú@\x01L®˜ƒt=]P\f÷:" b"hT\x11\x1Fß Qs×|@›£™ˆc" b"DÅm›È\x13xi\x15™Ç¡Ø µ" b"L~y’‚¦hU\x14}¯ëll&Ü" b"Y¸÷Zd½If\tù¨xð˜Ž\x1A" b"ýA\x1F\x03\x12Ø`Y\x7Fûêy\x10\x01Žë" b"Íì\x17\x1Câ\x04͆i³˜fBLë\x08" b"ˆš\x10\x1CI³+\x1E\x17º¯3=™¼" b"ú^Æ*4l‹Ó~ŽTµœþÐ," b"ÂÂðFÏçÛÍ\f÷|\x1D\x18\x11°²" b"gmͯNé^zºwS”§¸–\x08" b"\x1CÁ‹¶|#¹¢õ\x07Ò\eæˆ\x01" b"'ȵ¹¯<Œ.€K’^È?|h" b"+Ú”HaÔU\x17¯Í>*ÏÄ׉" b"òîœ?÷.&\x1C‚û¨‚¿YèU" b"úŸïÌëÞÓ\t,\eÇàbpBþ" b"\x10\x19\t#B¬Î2®eaôwï–Ë" b"I„@2¹û(8ýLÀgŽ§ˆ" b"šŽ:l‚\x1EÍ\x122HöŽÆŒ=" b"Òa+ùaÄ{z¥v»ñ\x19\x1FÖd" b"É%†«\x11Ic\x02ìÇ\x14›O" b"µ\x07vw\x05¨0kûÞ7‡L8u" b"5à\x04z’\x1DÎqe%®\x1Cí£|$" b"{ö¶»ž\x1F\x1AËç<SD©øX3" b"”\ví/KF¼¹Údû-\x01|J9" b"Yü¯™\x08\x1EKG¤Nf\x0E¹¸©é" b"Ò"ëûÆ‚\x12ŽÊ¼¸W#\x01" b"y&»ð2ÞЧÅyq-\x16\x08Ø\x01" b"gk(–PvIJŽæto\x1EÚ" b"7¨4 ™œ³&‡\x146„qç[" b"tEJ'¥Ê|/Æ\v(mÙ‹¿Í" b"§+ûÅZŽªÔ¾ç\vŽˆCŽÅ" b"\v±—L\x0El)3\r\x1E-PB]‹\" b"B€\x05jáãP&¡Q\x18”\rr¾ç" b"=&XÈ\x07ÅáÏ\x7F\x14áÙ=q0‰" b"—\x05ºeß›Ðqó{c]¢¬ø›" b"ðÆk3n\x03×—\x12ÎD8ÎË‹E" b""" u\x13—ˆÈWΛr\x13\n ì‡u\e """ b"7(ˆA+På¸ÏÜ|ábûÁ\x19" b"/ìH\x17^Ö¾ÄBà÷Àí„GT" b"Le¼\x01͇®Â•µƒØ&4û\x0F" b"ÌÃ\v \x14^v2æ®\x05åÕW\x14å" b"åû|6Œ\x1EÝ°´¨<\rVZt¥" b"-ªÀˆbA\x7F¾¨\x05–Œ\x03ôBé" b"çqÇ’üÛÔ9Ø"â\x13)Æž³" b"‘^·:\r_7=Q“Ü ægö¡" b""" 1jÜà÷°©t@ÐQG‹\n ½ """ b"*˜²:cÍ"ÆÝ?ø\x13¢{Ûî" b"þ\x031ÐGD†ãÆÄ\x08q\tî¥" b"Ö\x08…\x1Côiàz”O’ü\x1Cd=" b"BR¹wŸÜÃg&`(ZÛV–" b"i Û±}Væ9¸qãis\x18ô\x00" b""" \r–ªGŽE²Ž\x13\n I\x19';y """ b"±:\v\x04פà\fOE"¾f\v£µ" b"c±(‚\x1FŒ‚¿\x14´‰NHúÕG" b"ëß±¯4rtófM˜U³ÏŽ6" b"Á\x1E¶ºâ«g0\x02OúlšÊ÷P" b"7™k\x1D\v˜*jf!†ÿ©\x0FÄ7" b"t_ñ˜ÄàzC¹¸`\r#î-\f" b"þ¼¼0Áßûçæé 9\x01c†" b"{ì +ƒb2Íídw\x17·\x01ò" b"<at_ŽÁam[rlq\x10,\fí" b"X°–¸¥Î1\x00Ö\n€Žýrs" b"°C6Û¼¼B\x13\x18þˆ[$‹" b",Câow¯-ªS;JQ”â]\x19" b""" |Ï\¸/Îî‚¢\n ú\rªçÜ« """ b"ê¿N7+þŠ3Þ«\x7F²\x1C@‰™" b"kCy f\x05U°|GŽ\fE\vñ\x14" b"z-»€É#Ñø"ÛÞ\x13wkek" b"ÂXL/˜³ óô\x0FŒ\e^˜ÙÅ" b"Â\x15v݈\x1Dß~øÙÏýì°ó%" b""" ]Ù¾nî´n\n I\x1E»T¯+í\x17 """ b"r‹s\rÉ¥®‡ ¨¶9¼š#" b"Ò`X×9\x06bN̘”{ŠA´R" b"fNV¨Oæ;›”ñ°Ù×3áË" b"\x0F\x06ghtMR\x1AðóË,µ…7Æ" b""" zõ¹¹Œ0ðÅ/ ¥x<*\n 9 """ b"™¯‘'bÐßÎàV4üÚÉv" b"¡\ÌÍ\r\x16ƒ˜‹Ññ†\x05ûŠm" b"“þ¬3ð\x19\x1CÆc:Ñ_ÁÇ\x1D" b"½6\x16Í\x1Fj“ØI>«ÅÌ¥`" b"ðS.¾Žˆ\x11\x01ž¯<dJ\e$\x13" b""" Å‘^\n §Ž"í⾞ü¥\x1DJ~ """ b"0\x02ñû\x0FbÀ\x14Ó>P\x7F\x13‘.\x1E" b"É·ÒX¨=ëßq±¶ˆú”‡" b""" sâÉ\n ) #çŽr\x17–RÀ\x1F° """ b"²ð„¹\x00\e\x16’~\x18Ø6$ò\n" b"aÑM~¾T\tyÞO|`\x18Ó¶" b"'A^\x01µû¢cŽ-cÔõ³ux" b""" &~8"zTø?\\x08\x1AÄWà\n • """ b"1oŽUGšˆX‰»jý+\x17Pæ" b"q?tÆÒm#ÔÓR‚/å_¤f" b"Öj¦Î\x11\x7F°-§S\x1Fº„öø" b"Ô:þ+õD\x10N\x1FŒWµ©e×" b"=\x16\x02#}ã$¹&\x06·¬²%îÿ" b"ŽTnQi|¿ÍSCÙ\x02Èad•" b"ÞÄÙ\x1Aˆ#¥\f©ž\x10ôoF~p" b"‡%»¶¼ls\x19\x02_ÌüÝ™×\x05" b""" ¬?'Ä\x0Fü\n sm`Ý¡O/ƒ\v """ b"\x04Ž\x04«ÐQ\x19\x02Ð\x025Á°òÓ" b"Hñ´\x16\tò5ÒCÕ¼W\vÑh" b"³\x01¬W~¨óg@Ä\x08)3\x02”_" b" *È)\x123\x1D§jïQ°u²Ù\x18" b"Ô›üÏ9'Ž\x07P3&<BÍ%8" b"ÿoÈT¤}–ÞÝ\x01ÆñXV€u" b"Uù¬Ÿ6yþ'ËW|Õù‚´ö" b"j”Œü\x06ã\x12ï\x08;HÚ\x06\twÒ" b"ôê–“³¸\x06\n\x00È¢dûÔ¡‘" b"j\v²ÏÞ¼è1\v×[ÆéoÃÊ" b"§.Ô¥¦b/‘¹ˆ\x00Î\x19»$Ì" b"Íï\x13Ò´!^"Ò\x14\fx =ðn" "Z\x18\e鞬A(V2ȡݾu\x1F" b"³Y\x12ái³ÙS q›l–®" b"ç\x1EaU’<e†|$C›OŸ?¢" b"–ù¢„"ky—8–€™?.&~" b"t~Ìi;:j‚©ôÀåþßk" b"\t¢¨á,Ê\x17‚\x1A‡åd\x19¨šƒ" b"ý4vÐŒ‰¶šH%0«%Ân" b"£z9^©va¤+4¤çÃå" b"N\x1Aj¯\x0E›w\x06Ö8 #Œu\x03M" b"Õ\x10\x1D\x02ÝØ–âìöÎôŸ„°z" b"©õþÑ\x1CË\x7F’\x01\x04,4œ\x01\x05ë" b"%aú·ï\x06ï˜\x16Þ…Ÿóç‰" b"Ndk´ÞŸë\x08P$O¼ëwì" b"ÚœL\x1E¯aÑÎ%£ˆÞ-×\x04ñ" b"”¯öÎ0Úí\x0Eä_T϶\x1CÙ˜" b"îõ^\x01ýVÍÝwhÜãú\x06Y" b"Ê‹ø˜zÊ<RO¿ªû\x7F°Ò”" b"W2\x1Eß%G\x08\x13áàÐ~d÷7Å" b""" 1r\x19]ØÍg\n ˜\x10€äwd®î """ b"Æ\x01\x1FŽAžŠ\x17ÁAyZ\f¬\x03\n" b"ÈN«Ž+qðŠ\x1FÆüË89r" b"ïã\x17£¢‘lÓÄÐú \x021*" b"¹\fQ:\x06ž€!úÅã\v¤\x04ÒŽ" b"›Å\x19ÒÇQ]0 ¼‡`k\x11" b"X3‘½\x10«I]î—‡S“/1õ" b"{LM&Ó\x1F\x06Ø\x13q\x13o…l7 " b"”\x04ÈÉ\x12Mú¤‡~l…\x00ž[" b"~͘\f)\x03f~<J\x06\fj\Å" b"_ì-óГRN6\x1AåÎDÂ\vX" b"\x02Asƒù\t³ìbÊ{n30Áä" b"«öB\x03¹,®m\fX\x1CÎ_Æ‘¸" b"{Y\vìídY\x12 „‚³«€š" b"n&Ú`D©^þ\rº#œeµ´" b":[\x13#\x0Ea·7*È"Êw¬¿ª" b"Ãœù\x00-Ÿóº\vÔ»9\x08\v6l" b"CàÒµ93C½ó<Ä l£~¾" b"›óCäˆ#\eèðrÒÿvô-'" b"ö“Ã…v¿L—Ÿ×3õÿ&\x02" b"ÿÒV©æŒPxp»•©Îb\x03ÿ" b"$@ \e¬'[ù¬˜½w4ŽRÔ" b"‚÷€å2ÍÍ™&í–\x08ÎÝ€" b"P\x02Ö>Opb\HR÷»\x01\x00ë¹" b"ù:_\x05-#ˆ\x1D#)Ÿ`ª" b"\x1CQC!Ài5zªlD\x07\x12ïg\r" b"±¹7ôÔ\ròè\f\±a:\x1D¦" b"±Í†¬¢-\x01{€iÊvby^" b"¾(:pÚ®WêĽÉ@Ÿ´" b"õñ¾\x12vÕq=uçu\x15T è " b"\x12Š«ia^‚\x1Cü‡Oî¸?±\x03" b""" %±‹ŒO\x02\x17\x085¨-(\n Ní( """ b"šÓzꧧm,;k5UÜ\x13Cf" b"\x02\x08ŠË83œ\x16ôoy!ÅsÀ" b"\x1F÷\x073\x04KJeY[Ó—V®Žt" b"Ì׌µ5PN¿¿ÛÚ\x0F6…øo" b"ïé«\x06½\x19åÅ0\x02{\x00\x1Aò|È" b"¥Ú\x0FÏ…€Q"R÷7\x03;oß«" b"L\x18‹Ÿ™Ž¹\vF\x1C'\x0Eâ\x02" b"\x02þc\x18‘ßA\x05üî \x1Fã×ß®" b"wwïSC(Ä\x15\x16í\v\x00fCà‰" b"¸n\x00"\x17\x07‘ŽÈ¹,Ô\x14pd‚" b""" §ô„¡\x05aJ'\x01ŒÚC˜\n L‘ """ b""\x05y"í4pŸ{\f3ßáä6“" b"ÝO‹”Å?ߦKÑB6…\x08E¬" b"\x13z(s6ˆ!=0\x19L$‹6" b":\x08f_+Í\t[1M|½\x1FWÀs" b"_Íèv3, •š•w½\x15}²\v" b"tUH\x03ý\x01, ¢D\x14ò\x1A\x1EÞ\e" b".8DÅåæÕ–\r„z:\x1C\vËš" b"ņ»‘\x03\x1C_—°«‚œŽÅü0" b"~™Ÿ§yùtá`¤Ì¤\x1C‰Ø" b"3@\x19ì}¦\x7F¸–Š6èyæ\eÐ" b"—c +”²„‰ö\x02ŸãaÅ6\x15" b"BÛ©‹RÌ(Ø”"\x0Fmæ–õð" b"èk¨rã%ÜF\x0Eô(\x01\x1C£÷" b"©áT(i¤!B<´’F2+òŠ" b"\x15\r\v—ó,,\x192\x18S}™\x02EÃ" b"•ÕÃÕÀ^Ðu¯“ñ¹æð¯Œ" b"Kþq}Ñ%\x03³š+ÞF®\x01›ô" b"{¹\x12a0§ÑªéPÄ™(Ìü\" b"Š&½#¸%º-߂¿‘Züë" b"#YBXµw˜\x1C)óîH±\x10\x1D" b"øýs?f`¤\x17ŠjÃ5èü|ã" b"”Ö«Ö"(Û[KoA\x01þ¶&’" b""" û»Îþã³ÞÞÀŽ®\n ¨À‰ """ b"Œ‚µžâEä‘,½\x1Af§ù°›" b"å\x1CØî$'ÊoÞ\x0F¯;’nZp" b"ÄÖƒ6Õú§ô\e7šY\x04œ"y" b"N%föAÖàD|Ö®ïÉÞS" b"¿VìÄ;"¿×ÂØUU²°\x0F+" b")ðêÝûB6uÿöD\x0F"\t~C" b"S\x1FG\x1Cu\x0FŽœÎ‚\x01\x08ª\x1Fj" b" \x0FúûîuU°\x18źë5é" b"Ñ<ûj•/Ô¢ïóß\x04%ÄL6" b"ôþõ\x07¿[ÐŒùæÛJ^[U" b"ÁNņÙ$J\e\x1Fà|›wd" b"¸S¨…\vÈcßeìf1úD\tå" b"œeí\x0EœåÞþÎyÓDdï6ô" b"öæk¹-c=¸H\x03ÒÍy\x10›" b"ß\x13\x0EîL¦\x03\tÿÀoúZr„" b" ‚ö€\x1FÒ*| ™\x00\rqþÖ—" b"¼xëñƒZ³ü‡¹¬P²V0U" b""" SB›\x16Š\x1E\n qÚ\x1F[\x13ú\x14ç """ b"f#Ô†êZÃ[¨ÛÕÉp¡s" b"â\x1C§6دèó:ÇÞ\x19XÚ²\x11" b"Ê?ˆ-?O\x10Ö*D\x1E/¹š\x1Aä" b"Èç[C¬>~†é\x1EœÉ±+´\x04" b"ôø½\x1FšA\x08\x18ýœQ&28Àß" b"ÚÑqX*ZÝug“ŽD(^Ðh" b"Í\x0E\x0Eb×û5Wð›+.GË\x10\x07" b"_do"l\x16bZøæ‚Ó5TaÞ" b"»“J\x06\x07¬ÝØ"/ýÕq¼\x02" b"w¥?¿-x\x0F\x04Ûñx\x02‘®i&" b"Ü©VÈDe%|Ü6í\x19 çþ" b"+æ÷û\x17\HÞEß\tXD®Ü¤" b"g\x10\x06P\x08 =\x07çªs\x1DÕ>à" b"Aòk?›¿\x06͵ôlm|u]\x05" b"âå+fþsöÕYºH\x01_t\x1FY" b"\vI.TÎz\x06×P]\x0F!ÜÌÿ" b"¼nUy@F\eûÖ(\x1EŸæ¢\x16±" b"\x10}žƒÐ6{þ\x00ý®\x08_96T" b"p\x01ï¡\x03&òj-°ÿÆiùÄÕ" b"\tP½#±¤÷\x04\x1D*$ôÙ·O" b"\x00Õw1W…üºþOº¥r;P„" b"ð‹Ø»#\x05ÿóžÁŽ\x17«oVŽ" b"}È<RŸ\x01¨œYÛá\x1A@cÁµ" b"¿ž\eÊ\x0E˽™îM\x1CÛú\x19M£" b"š…:_\x17mHXåŒÃÈ•Ì\x025" b"“¦[¤ƒÔ\Xæð¥õW~?`" b"*K\x00ÉFCÖ#?¾µˆý\x1Eb\x1E" b"—Ý/‡\x07“ètËÎç\x01Žˆdˆ" b"\x04™—¢¸_\x10Š \x1DÂ\x16¤F x" b"OÑTa‘¹7y\x03»M\x0F¥…fë" b"îOªºê&¯l×IÁ\rߺo’" ] |
||||||||||||||||||||||||
|
2.91 ms (1.11%) |
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`.`active` as `language.active`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.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`, `language.translationCode.translation.name` as `language.translationCode.name`, `language.translationCode.translation.territory`, `language.translationCode.translation.territory` as `language.translationCode.territory`, `language.translationCode.translation.customFields`, `language.translationCode.translation.customFields` as `language.translationCode.customFields` FROM `language` 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` 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" b"SC(\rúÚO\x13¸~¦m5¶ü." b"ü¯™I#2NT£ÒO\x16ÿÝ0K" b"í¦!§~bE8–³ÄVاý" ] |
||||||||||||||||||||||||
|
2.71 ms (1.03%) |
1 |
# category::data::association::translations::read SELECT `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` WHERE (`category_translation`.`category_version_id` = ?) AND (((`category_translation`.`category_id` IN (?))))
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x00\x00\x01† ~~~~~~~~~\x00\x01" ] |
||||||||||||||||||||||||
|
2.67 ms (1.02%) |
4 |
# navigation-route::meta-information SELECT LOWER(HEX(`id`)), `path`, `level` FROM `category` WHERE `id` = ? OR `id` = ?
Parameters:
[ b"\x00\x00\x01† ~~~~~~~~~\x00\x01" b"|Ï—V\x050LÜ»l´+š“ì¤" ] |
||||||||||||||||||||||||
|
2.12 ms (0.81%) |
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/00000186a07e7e7e7e7e7e7e7e7e0001" "/navigation/17a3e1082a41422486b5cd8312b85338" "/navigation/ce8d2ea829eb4f068922ce8d9928aaf8" "/navigation/13a65f0962e64be9ab3210a371a2f790" "/navigation/00000188947e7e7e7e7e7e7e7e7e0001" "/navigation/0000018a887e7e7e7e7e7e7e7e7e0001" "/navigation/0000018c7c7e7e7e7e7e7e7e7e7e0001" "/navigation/0000018e707e7e7e7e7e7e7e7e7e0001" "/navigation/00000190647e7e7e7e7e7e7e7e7e0001" "/navigation/000003d0907e7e7e7e7e7e7e7e7e0001" "/navigation/000006ddd07e7e7e7e7e7e7e7e7e0001" "/navigation/00000493e07e7e7e7e7e7e7e7e7e0001" "/navigation/0000057e407e7e7e7e7e7e7e7e7e0001" "/navigation/00000668a07e7e7e7e7e7e7e7e7e0001" "/navigation/000007ef407e7e7e7e7e7e7e7e7e0001" "/navigation/00000864707e7e7e7e7e7e7e7e7e0001" "/navigation/00000afc807e7e7e7e7e7e7e7e7e0001" "/navigation/00000bbfd07e7e7e7e7e7e7e7e7e0001" "/navigation/00000c35007e7e7e7e7e7e7e7e7e0001" "/navigation/00000cf8507e7e7e7e7e7e7e7e7e0001" "/navigation/4d689ea4e1ee4be7a7ff17c3d1c2a9fd" "/navigation/87329892f04642a091cf97d76cf2e172" "/navigation/13f58cf7fb2d4fdc8090e2d111219483" "/navigation/0799bf2edc454c3287d633d9afd8d680" "/navigation/d67ef9c439bf46b9976fd4c577abecc9" "/navigation/b90f87fb1a1c4230af629184792d84e3" "/navigation/00000249f07e7e7e7e7e7e7e7e7e0001" "/navigation/0000030d407e7e7e7e7e7e7e7e7e0001" "/navigation/00000dbba07e7e7e7e7e7e7e7e7e0001" "/detail/00000007337e7e7e7e7e7e7e7e7e0002" "/detail/00000bdada7e7e7e7e7e7e7e7e7e0002" "/detail/000000163b7e7e7e7e7e7e7e7e7e0002" "/detail/0000001e9b7e7e7e7e7e7e7e7e7e0002" "/detail/00000c1e507e7e7e7e7e7e7e7e7e0002" "/detail/00000025767e7e7e7e7e7e7e7e7e0002" "/detail/00000024507e7e7e7e7e7e7e7e7e0002" "/detail/000000054a7e7e7e7e7e7e7e7e7e0002" "/detail/000000054b7e7e7e7e7e7e7e7e7e0002" "/detail/00000005537e7e7e7e7e7e7e7e7e0002" "/detail/0000001eee7e7e7e7e7e7e7e7e7e0002" b"/»_ââšMpªXTÎ|ãâ\v" b"¤½mg\x16ÖA&½Ssª¾èɯ" ] |
||||||||||||||||||||||||
|
1.98 ms (0.76%) |
1 |
SELECT `product_manufacturer`.`id` as `product_manufacturer.id`, `product_manufacturer`.`version_id` as `product_manufacturer.versionId`, `product_manufacturer`.`media_id` as `product_manufacturer.mediaId`, `product_manufacturer`.`link` as `product_manufacturer.link`, `product_manufacturer`.`created_at` as `product_manufacturer.createdAt`, `product_manufacturer`.`updated_at` as `product_manufacturer.updatedAt`, `product_manufacturer.translation.name`, `product_manufacturer.translation.name` as `product_manufacturer.name`, `product_manufacturer.translation.description`, `product_manufacturer.translation.description` as `product_manufacturer.description`, `product_manufacturer.translation.customFields`, `product_manufacturer.translation.customFields` as `product_manufacturer.customFields` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.`product_manufacturer_id`, `product_manufacturer.translation`.`product_manufacturer_version_id`, `product_manufacturer.translation`.`name` as `product_manufacturer.translation.name`, `product_manufacturer.translation`.`description` as `product_manufacturer.translation.description`, `product_manufacturer.translation`.`custom_fields` as `product_manufacturer.translation.customFields` FROM `product_manufacturer_translation` `product_manufacturer.translation` WHERE `product_manufacturer.translation`.`language_id` = ?) `product_manufacturer.product_manufacturer_translation` ON `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product_manufacturer`.`id` AND `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_version_id` = `product_manufacturer`.`version_id` WHERE (`product_manufacturer`.`version_id` = ?) AND (`product_manufacturer`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x00\x00‰€q~~~~~~~~~\x00\x04" b"\x00\x00‰{¨~~~~~~~~~\x00\x04" b"\x00\x00‰{õ~~~~~~~~~\x00\x04" b"\x00\x00˜–\x7F~~~~~~~~~\x00\x04" b"\x00\x00‰¤…~~~~~~~~~\x00\x04" b"\x00\x00oN~~~~~~~~~\x00\x04" b"\x00\x00‰+~~~~~~~~~\x00\x04" b"\x00\x00‰|W~~~~~~~~~\x00\x04" b"\x00\x00nÜ~~~~~~~~~\x00\x04" b"\x00\x00‰{~~~~~~~~~\x00\x04" b"\x00\x00‰~,~~~~~~~~~\x00\x04" b"\x00\x00‰{›~~~~~~~~~\x00\x04" b"\x00\x00˜”b~~~~~~~~~\x00\x04" b"\x00\x00‰¢o~~~~~~~~~\x00\x04" b"\x00\x00nð~~~~~~~~~\x00\x04" b"\x00\x00‰}¨~~~~~~~~~\x00\x04" b"\x00\x00‰}&~~~~~~~~~\x00\x04" b"\x00\x00‰¢ò~~~~~~~~~\x00\x04" b"\x00\x00‰€Š~~~~~~~~~\x00\x04" b"\x00\x00nú~~~~~~~~~\x00\x04" b"\x00\x00˜’¢~~~~~~~~~\x00\x04" b"\x00\x00’|‘~~~~~~~~~\x00\x04" b"\x00\x00‰}n~~~~~~~~~\x00\x04" b"\x00\x00‰€x~~~~~~~~~\x00\x04" b"\x00\x00‰}S~~~~~~~~~\x00\x04" b"\x00\x00‰{Ž~~~~~~~~~\x00\x04" b"\x00\x00‰\x7F:~~~~~~~~~\x00\x04" b"\x00\x00‰\x7FÅ~~~~~~~~~\x00\x04" b"\x00\x00”\x03\x08~~~~~~~~~\x00\x04" b"\x00\x00‰~—~~~~~~~~~\x00\x04" b"\x00\x00‰{Ø~~~~~~~~~\x00\x04" b"\x00\x00‰l~~~~~~~~~\x00\x04" b"\x00\x00’|k~~~~~~~~~\x00\x04" b"\x00\x00‰\x7Fâ~~~~~~~~~\x00\x04" b"\x00\x00‰\x7Fï~~~~~~~~~\x00\x04" b"\x00\x00õ~~~~~~~~~\x00\x04" b"\x00\x00‰\x7Fœ~~~~~~~~~\x00\x04" b"\x00\x00‰}Ô~~~~~~~~~\x00\x04" b"\x00\x00‰\x7F~~~~~~~~~\x00\x04" b"\x00\x00oA~~~~~~~~~\x00\x04" b"\x00\x00˜–v~~~~~~~~~\x00\x04" b"\x00\x00‰{~~~~~~~~~\x00\x04" b"\x00\x00‰¢³~~~~~~~~~\x00\x04" b"\x00\x00o\x03~~~~~~~~~\x00\x04" b"\x00\x00ov~~~~~~~~~\x00\x04" b"\x00\x00‰{ç~~~~~~~~~\x00\x04" b"\x00\x00‰~³~~~~~~~~~\x00\x04" b"\x00\x00‰\x7Fý~~~~~~~~~\x00\x04" b"\x00\x00‰{–~~~~~~~~~\x00\x04" b"\x00\x00‰\t~~~~~~~~~\x00\x04" b"\x00\x00”\x03!~~~~~~~~~\x00\x04" b"\x00\x00‰€p~~~~~~~~~\x00\x04" b"\x00\x00‰¢¿~~~~~~~~~\x00\x04" b"\x00\x00‰~æ~~~~~~~~~\x00\x04" b"\x00\x00o\x13~~~~~~~~~\x00\x04" b"\x00\x00‰Wm~~~~~~~~~\x00\x04" b"\x00\x00‰¢å~~~~~~~~~\x00\x04" b"\x00\x00‰\x7Fq~~~~~~~~~\x00\x04" b"\x00\x00‰¢¨~~~~~~~~~\x00\x04" b"\x00\x00‰{V~~~~~~~~~\x00\x04" b"\x00\x00‰}\x14~~~~~~~~~\x00\x04" b"\x00\x00‰}Ú~~~~~~~~~\x00\x04" b"\x00\x00‰£%~~~~~~~~~\x00\x04" b"\x00\x00‰¤„~~~~~~~~~\x00\x04" b"\x00\x00‰€\x02~~~~~~~~~\x00\x04" b"\x00\x00‰€\x07~~~~~~~~~\x00\x04" b"\x00\x00‰€~~~~~~~~~\x00\x04" b"\x00\x00‰€ž~~~~~~~~~\x00\x04" b"\x00\x00”\x03\x13~~~~~~~~~\x00\x04" b"\x00\x00‰}~~~~~~~~~\x00\x04" b"\x00\x00‰~°~~~~~~~~~\x00\x04" b"\x00\x00‰¢z~~~~~~~~~\x00\x04" b"\x00\x00‰m~~~~~~~~~\x00\x04" b"\x00\x00‰¢y~~~~~~~~~\x00\x04" b"\x00\x00‰~£~~~~~~~~~\x00\x04" b"\x00\x00‰¢õ~~~~~~~~~\x00\x04" b"\x00\x00‰|(~~~~~~~~~\x00\x04" b"\x00\x00‰|^~~~~~~~~~\x00\x04" b"\x00\x00‰}H~~~~~~~~~\x00\x04" b"\x00\x00‰\x7Fo~~~~~~~~~\x00\x04" b"\x00\x00‰2~~~~~~~~~\x00\x04" b"\x00\x00ŠÿT~~~~~~~~~\x00\x04" b"\x00\x00oS~~~~~~~~~\x00\x04" b"\x00\x00‰\x7F\x03~~~~~~~~~\x00\x04" b"\x00\x00‰|á~~~~~~~~~\x00\x04" b"\x00\x00‰\x7F%~~~~~~~~~\x00\x04" b"\x00\x00‰¢Ë~~~~~~~~~\x00\x04" b"\x00\x00”\x03\x1E~~~~~~~~~\x00\x04" b"\x00\x00˜”t~~~~~~~~~\x00\x04" b"\x00\x00‰T³~~~~~~~~~\x00\x04" b"\x00\x00‰|†~~~~~~~~~\x00\x04" b"\x00\x00‰€Ü~~~~~~~~~\x00\x04" b"\x00\x00‰};~~~~~~~~~\x00\x04" b"\x00\x00‰}_~~~~~~~~~\x00\x04" b"\x00\x00‰}¡~~~~~~~~~\x00\x04" b"\x00\x00‰€Ò~~~~~~~~~\x00\x04" b"\x00\x00‰¢¤~~~~~~~~~\x00\x04" b"\x00\x00‰¢¼~~~~~~~~~\x00\x04" b"\x00\x00‰¢ä~~~~~~~~~\x00\x04" b"\x00\x00’|Œ~~~~~~~~~\x00\x04" b"\x00\x00”\x03 ~~~~~~~~~\x00\x04" b"\x00\x00•…~~~~~~~~~\x00\x04" b"\x00\x00˜–\~~~~~~~~~\x00\x04" b"\x00\x00‰TK~~~~~~~~~\x00\x04" b"\x00\x00‰¢~~~~~~~~~\x00\x04" b"\x00\x00ŠÜh~~~~~~~~~\x00\x04" b"\x00\x00‹\x05ô~~~~~~~~~\x00\x04" b"\x00\x00Žû¾~~~~~~~~~\x00\x04" b"\x00\x00‰{å~~~~~~~~~\x00\x04" b"\x00\x00‰}v~~~~~~~~~\x00\x04" b"\x00\x00‰~\x13~~~~~~~~~\x00\x04" b"\x00\x00‰~¹~~~~~~~~~\x00\x04" b"\x00\x00‰~ò~~~~~~~~~\x00\x04" b"\x00\x00‰€%~~~~~~~~~\x00\x04" b"\x00\x00‰_~~~~~~~~~\x00\x04" b"\x00\x00‹\x04[~~~~~~~~~\x00\x04" b"\x00\x00s^~~~~~~~~~\x00\x04" b"\x00\x00\x00\x03ç~~~~~~~~~\x00\x04" b"\x00\x00‰|9~~~~~~~~~\x00\x04" b"\x00\x00‰}\x1E~~~~~~~~~\x00\x04" b"\x00\x00‰}x~~~~~~~~~\x00\x04" b"\x00\x00‰}„~~~~~~~~~\x00\x04" b"\x00\x00‰}§~~~~~~~~~\x00\x04" b"\x00\x00‰~Ê~~~~~~~~~\x00\x04" b"\x00\x00‰~è~~~~~~~~~\x00\x04" b"\x00\x00‰\x7FÒ~~~~~~~~~\x00\x04" b"\x00\x00‰¢}~~~~~~~~~\x00\x04" b"\x00\x00‰¢\x7F~~~~~~~~~\x00\x04" b"\x00\x00‰¢Å~~~~~~~~~\x00\x04" b"\x00\x00o\x05~~~~~~~~~\x00\x04" ] |
||||||||||||||||||||||||
|
1.95 ms (0.74%) |
1 |
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
|
||||||||||||||||||||||||
|
1.81 ms (0.69%) |
3 |
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `swag_dynamic_access_category_rule` `category.swagDynamicAccessRules.mapping` ON `category`.`id` = `category.swagDynamicAccessRules.mapping`.`category_id` AND `category`.`version_id` = `category.swagDynamicAccessRules.mapping`.`category_version_id` LEFT JOIN `rule` `category.swagDynamicAccessRules` ON `category.swagDynamicAccessRules.mapping`.`rule_id` = `category.swagDynamicAccessRules`.`id` WHERE (`category`.`version_id` = ?) AND ((((`category.swagDynamicAccessRules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) OR `category.swagDynamicAccessRules`.`id` <=> ?))) AND (`category`.`id` IN (?, ?, ?)) GROUP BY `category`.`id`
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\t,¿}{¸Eχ\x1F‹ÃXG\x02\x1A" b",õ˜–¯fGX–슽\x03¬&¶" b"8X•p\x16dMä®HÀP\vóÌÈ" b""" <}’kjGþŽJâ\r\n ™4$ """ b"iàé\vÔMFY‰ˆyvu.ýü" b"á7Ž·€ŠG‘ž\rt\r]l\x1A" b"é+6oàÎI{›^+L*,°ö" b"úŸë8R\eLPŠù\x1Aúüøžª" b"&×\x15wãeIÈ‹pK¹ç÷9\x18" b"(Ê®u¥bO\r˜Z½\x0E³*¡`" b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-" b"q\x01,<[öA=ƒ¹bAä{ÙÝ" null b"\x17£á\x08*AB$†µÍƒ\x12¸S8" b"ÎŽ.¨)ëO\x06‰"ÎŽ™(ªø" b"\x00\x00\x01† ~~~~~~~~~\x00\x01" ] |
||||||||||||||||||||||||
|
1.76 ms (0.67%) |
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.swagCmsExtensionsScrollNavigationPageSettings`.`id` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.id`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`active` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.active`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`duration` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.duration`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`easing` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.easing`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`bouncy` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.bouncy`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`easing_degree` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.easingDegree`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`native_scrolling` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.nativeScrolling`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`cms_page_id` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPageId`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`cms_page_version_id` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.cmsPageVersionId`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`created_at` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.createdAt`, `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`updated_at` as `cms_page.swagCmsExtensionsScrollNavigationPageSettings.updatedAt`, `cms_page.translation.name`, `cms_page.translation.name` as `cms_page.name`, `cms_page.translation.customFields`, `cms_page.translation.customFields` as `cms_page.customFields` FROM `cms_page` LEFT JOIN `swag_cms_extensions_scroll_navigation_page_settings` `cms_page.swagCmsExtensionsScrollNavigationPageSettings` ON `cms_page`.`id` = `cms_page.swagCmsExtensionsScrollNavigationPageSettings`.`id` 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` 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"\x01›ÛÓ•§r\x07‹\x15¾ç–„Ž”" ] |
||||||||||||||||||||||||
|
1.67 ms (0.64%) |
2 |
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`.`checkout_gateway_url` as `app.checkoutGatewayUrl`, `app`.`context_gateway_url` as `app.contextGatewayUrl`, `app`.`in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl`, `app`.`source_type` as `app.sourceType`, `app`.`source_config` as `app.sourceConfig`, `app`.`self_managed` as `app.selfManaged`, `app`.`requested_privileges` as `app.requestedPrivileges`, `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`.`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`, `app.translation.label` as `app.label`, `app.translation.description`, `app.translation.description` as `app.description`, `app.translation.privacyPolicyExtensions`, `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`, `app.translation.customFields`, `app.translation.customFields` as `app.customFields` FROM `app` 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` 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` FROM `app_translation` `app.translation` WHERE `app.translation`.`language_id` = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` WHERE (`app`.`name` = ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" "mailcShopware6MailchimpIntegration" ] |
||||||||||||||||||||||||
|
1.53 ms (0.59%) |
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/c5d71ffef8bc453ea4c8ab3623de4362" "/navigation/afe8cf6121644961842962f6a7ae36e0" "/navigation/14c9d4116b8941cabfca749a05e63978" "/navigation/ad80da660e2c4003a8cfdff97972a983" "/navigation/17a3e1082a41422486b5cd8312b85338" "/navigation/87329892f04642a091cf97d76cf2e172" "/navigation/13f58cf7fb2d4fdc8090e2d111219483" "/navigation/0799bf2edc454c3287d633d9afd8d680" "/navigation/d67ef9c439bf46b9976fd4c577abecc9" "/navigation/b90f87fb1a1c4230af629184792d84e3" "/navigation/111390a861714935a97e5d8259f1f61d" "/navigation/7fd58b6848ad4d169d17ba7ab2651a20" "/navigation/70423ec9267541f781e3d811667d54e1" "/navigation/6667589a4a9a491d939b69471f41c449" "/navigation/55459d7a2dad4ebca1f0404340f003c8" "/navigation/5442042ebdad49dda1cc04c5839d340f" "/navigation/bd5e94c4d5164737b2e0ce3c08d4d156" "/navigation/469a3de0895648609dea1d02c2225087" b"/»_ââšMpªXTÎ|ãâ\v" b"¤½mg\x16ÖA&½Ssª¾èɯ" ] |
||||||||||||||||||||||||
|
1.35 ms (0.52%) |
2 |
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`.`cms_navigation_page_id` as `category.cmsNavigationPageId`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x17£á\x08*AB$†µÍƒ\x12¸S8" b"ÎŽ.¨)ëO\x06‰"ÎŽ™(ªø" b"\x00\x00\x01† ~~~~~~~~~\x00\x01" ] |
||||||||||||||||||||||||
|
1.22 ms (0.47%) |
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:
[] |
||||||||||||||||||||||||
|
1.17 ms (0.45%) |
1 |
SELECT LOWER(HEX(advanced_search_config.id)) AS id, advanced_search_config.and_logic AS andLogic, advanced_search_config.min_search_length AS minSearchLength, advanced_search_config.es_enabled AS esEnabled, advanced_search_config.hit_count AS hitCount, CONCAT( '[', GROUP_CONCAT(DISTINCT JSON_OBJECT( 'field', advanced_search_config_field.field, 'entity', advanced_search_config_field.entity, 'tokenize', advanced_search_config_field.tokenize, 'searchable', advanced_search_config_field.searchable, 'ranking', advanced_search_config_field.ranking ) ), ']' ) as searchableFields FROM advanced_search_config LEFT JOIN advanced_search_config_field ON advanced_search_config_field.config_id = advanced_search_config.id AND advanced_search_config_field.searchable = 1 WHERE advanced_search_config.sales_channel_id = ? GROUP BY advanced_search_config.id
Parameters:
[
b"¤½mg\x16ÖA&½Ssª¾èɯ"
]
|
||||||||||||||||||||||||
|
1.17 ms (0.44%) |
1 |
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `swag_dynamic_access_product_rule` `product.swagDynamicAccessRules.mapping` ON `product`.`id` = `product.swagDynamicAccessRules.mapping`.`product_id` AND `product`.`version_id` = `product.swagDynamicAccessRules.mapping`.`product_version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product` `product.parent.parent` ON `product.parent`.`parent_id` = `product.parent.parent`.`id` AND `product.parent`.`parent_version_id` = `product.parent.parent`.`version_id` LEFT JOIN `swag_dynamic_access_product_rule` `product.parent.swagDynamicAccessRules.mapping` ON `product.parent`.`id` = `product.parent.swagDynamicAccessRules.mapping`.`product_id` AND `product.parent`.`version_id` = `product.parent.swagDynamicAccessRules.mapping`.`product_version_id` LEFT JOIN `rule` `product.parent.swagDynamicAccessRules` ON `product.parent.swagDynamicAccessRules.mapping`.`rule_id` = `product.parent.swagDynamicAccessRules`.`id` LEFT JOIN `rule` `product.swagDynamicAccessRules` ON `product.swagDynamicAccessRules.mapping`.`rule_id` = `product.swagDynamicAccessRules`.`id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND (((`product.parent.swagDynamicAccessRules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND `product.swagDynamicAccessRules`.`id` <=> ?) OR ((`product.swagDynamicAccessRules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))) OR (`product.parent.swagDynamicAccessRules`.`id` <=> ? AND `product.swagDynamicAccessRules`.`id` <=> ?)))) AND (`product`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY `product`.`id`
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" 30 b"¤½mg\x16ÖA&½Ssª¾èɯ" true b"\t,¿}{¸Eχ\x1F‹ÃXG\x02\x1A" b",õ˜–¯fGX–슽\x03¬&¶" b"8X•p\x16dMä®HÀP\vóÌÈ" b""" <}’kjGþŽJâ\r\n ™4$ """ b"iàé\vÔMFY‰ˆyvu.ýü" b"á7Ž·€ŠG‘ž\rt\r]l\x1A" b"é+6oàÎI{›^+L*,°ö" b"úŸë8R\eLPŠù\x1Aúüøžª" b"&×\x15wãeIÈ‹pK¹ç÷9\x18" b"(Ê®u¥bO\r˜Z½\x0E³*¡`" b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-" b"q\x01,<[öA=ƒ¹bAä{ÙÝ" null b"\t,¿}{¸Eχ\x1F‹ÃXG\x02\x1A" b",õ˜–¯fGX–슽\x03¬&¶" b"8X•p\x16dMä®HÀP\vóÌÈ" b""" <}’kjGþŽJâ\r\n ™4$ """ b"iàé\vÔMFY‰ˆyvu.ýü" b"á7Ž·€ŠG‘ž\rt\r]l\x1A" b"é+6oàÎI{›^+L*,°ö" b"úŸë8R\eLPŠù\x1Aúüøžª" b"&×\x15wãeIÈ‹pK¹ç÷9\x18" b"(Ê®u¥bO\r˜Z½\x0E³*¡`" b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-" b"q\x01,<[öA=ƒ¹bAä{ÙÝ" null null "\x00\x00\x00\x073~~~~~~~~~\x00\x02" b"\x00\x00\vÚÚ~~~~~~~~~\x00\x02" "\x00\x00\x00\x16;~~~~~~~~~\x00\x02" b"\x00\x00\x00\x1E›~~~~~~~~~\x00\x02" "\x00\x00\f\x1EP~~~~~~~~~\x00\x02" "\x00\x00\x00%v~~~~~~~~~\x00\x02" "\x00\x00\x00$P~~~~~~~~~\x00\x02" "\x00\x00\x00\x05J~~~~~~~~~\x00\x02" "\x00\x00\x00\x05K~~~~~~~~~\x00\x02" "\x00\x00\x00\x05S~~~~~~~~~\x00\x02" b"\x00\x00\x00\x1Eî~~~~~~~~~\x00\x02" ] |
||||||||||||||||||||||||
|
0.96 ms (0.37%) |
1 |
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `swag_dynamic_access_category_rule` `category.swagDynamicAccessRules.mapping` ON `category`.`id` = `category.swagDynamicAccessRules.mapping`.`category_id` AND `category`.`version_id` = `category.swagDynamicAccessRules.mapping`.`category_version_id` LEFT JOIN `rule` `category.swagDynamicAccessRules` ON `category.swagDynamicAccessRules.mapping`.`rule_id` = `category.swagDynamicAccessRules`.`id` WHERE (`category`.`version_id` = ?) AND ((((`category.swagDynamicAccessRules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) OR `category.swagDynamicAccessRules`.`id` <=> ?))) AND (`category`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY `category`.`id`
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\t,¿}{¸Eχ\x1F‹ÃXG\x02\x1A" b",õ˜–¯fGX–슽\x03¬&¶" b"8X•p\x16dMä®HÀP\vóÌÈ" b""" <}’kjGþŽJâ\r\n ™4$ """ b"iàé\vÔMFY‰ˆyvu.ýü" b"á7Ž·€ŠG‘ž\rt\r]l\x1A" b"é+6oàÎI{›^+L*,°ö" b"úŸë8R\eLPŠù\x1Aúüøžª" b"&×\x15wãeIÈ‹pK¹ç÷9\x18" b"(Ê®u¥bO\r˜Z½\x0E³*¡`" b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-" b"q\x01,<[öA=ƒ¹bAä{ÙÝ" null b"\vgF‚Ï\x06G¡»A*×ófÄ’" b"\x1E(|\x15<ÒB[¨\x10\x1DUÛ£’œ" b"TB\x04.½IÝ¡Ì\x04Ń4\x0F" b"UEz-N¼¡ð@C@ð\x03È" b"fgXšJšI\x1D“›iG\x1FAÄI" b"n#Â\fg\x1CI:€€e!±\x00¿©" b"pB>É&uA÷ãØ\x11f}Tá" b"zÌDJ|\x03Mè©Z\x07\x0FQ\x13ý-" b"\x7FÕ‹hHM\x16\x17ºz²e\x1A " b"„\x0FfXHøFìƒ/KeW¿Zi" b"ˆÖþ?Æ·Nä½]æ±³÷ó" b"€Úf\x0E,@\x03¨Ïßùyr©ƒ" b"Å×\x1Fþø¼E>¤È«6#ÞCb" b"Öx@\x08©[GK½‰D_ê\x17¤N" b"ÛζNkÞE%º†¢Pt.õ\x10" b"ìãeQÓ\x11NŽ·j;'P\x10" b"úä²6RÄN¾˜Ž‹\^X§#" b"Ç´S-A\x10OÙ§€ÞëT;_," ] |
||||||||||||||||||||||||
|
0.95 ms (0.36%) |
1 |
# category::cms-page::association::sections::read SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`version_id` as `cms_section.versionId`, `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`, `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`.`created_at` as `cms_section.createdAt`, `cms_section`.`updated_at` as `cms_section.updatedAt`, `cms_section.swagCmsExtensionsScrollNavigation`.`id` as `cms_section.swagCmsExtensionsScrollNavigation.id`, `cms_section.swagCmsExtensionsScrollNavigation`.`active` as `cms_section.swagCmsExtensionsScrollNavigation.active`, `cms_section.swagCmsExtensionsScrollNavigation`.`cms_section_version_id` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSectionVersionId`, `cms_section.swagCmsExtensionsScrollNavigation`.`cms_section_id` as `cms_section.swagCmsExtensionsScrollNavigation.cmsSectionId`, `cms_section.swagCmsExtensionsScrollNavigation`.`created_at` as `cms_section.swagCmsExtensionsScrollNavigation.createdAt`, `cms_section.swagCmsExtensionsScrollNavigation`.`updated_at` as `cms_section.swagCmsExtensionsScrollNavigation.updatedAt`, `cms_section.swagCmsExtensionsScrollNavigation.translation.displayName`, `cms_section.swagCmsExtensionsScrollNavigation.translation.displayName` as `cms_section.swagCmsExtensionsScrollNavigation.displayName`, `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`.`file_hash` as `cms_section.backgroundMedia.fileHash`, `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`, `cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title`, `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt`, `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation.customFields` as `cms_section.backgroundMedia.customFields` FROM `cms_section` LEFT JOIN `swag_cms_extensions_scroll_navigation` `cms_section.swagCmsExtensionsScrollNavigation` ON `cms_section`.`id` = `cms_section.swagCmsExtensionsScrollNavigation`.`id` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_section.swagCmsExtensionsScrollNavigation.translation`.`swag_cms_extensions_scroll_navigation_id`, `cms_section.swagCmsExtensionsScrollNavigation.translation`.`display_name` as `cms_section.swagCmsExtensionsScrollNavigation.translation.displayName` FROM `swag_cms_extensions_scroll_navigation_translation` `cms_section.swagCmsExtensionsScrollNavigation.translation` WHERE `cms_section.swagCmsExtensionsScrollNavigation.translation`.`language_id` = ?) `cms_section.swagCmsExtensionsScrollNavigation.swag_cms_extensions_scroll_navigation_translation` ON `cms_section.swagCmsExtensionsScrollNavigation.swag_cms_extensions_scroll_navigation_translation`.`swag_cms_extensions_scroll_navigation_id` = `cms_section.swagCmsExtensionsScrollNavigation`.`id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation`.`media_id`, `cms_section.backgroundMedia.translation`.`alt` as `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation`.`title` as `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.`custom_fields` as `cms_section.backgroundMedia.translation.customFields` 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"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01›ÛÓ•§r\x07‹\x15¾ç–„Ž”" ] |
||||||||||||||||||||||||
|
0.93 ms (0.35%) |
1 |
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category`.`cms_navigation_page_id` as `category.cmsNavigationPageId`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x00\x00\x01† ~~~~~~~~~\x00\x01" ] |
||||||||||||||||||||||||
|
0.90 ms (0.34%) |
1 |
SELECT DISTINCT `technical_name` FROM `theme_runtime_config` WHERE `technical_name` IS NOT NULL
Parameters:
[] |
||||||||||||||||||||||||
|
0.88 ms (0.33%) |
1 |
# product-listing-loader::resolve-previews SELECT parent.variant_listing_config as variantListingConfig, LOWER(HEX(child.id)) as id, LOWER(HEX(parent.id)) as parentId FROM product as child INNER JOIN product as parent ON parent.id = child.parent_id AND parent.version_id = child.version_id WHERE child.version_id = ? AND child.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x00\x00“Ý~~~~~~~~~\x00\x03" b"\x00\x00¡,~~~~~~~~~\x00\x03" b"\x00\x00¡I~~~~~~~~~\x00\x03" b"\x00\x00¢¶~~~~~~~~~\x00\x03" b"\x00\x00‘J{~~~~~~~~~\x00\x03" b"\x00\x00”Rc~~~~~~~~~\x00\x03" b"\x00\x00”h0~~~~~~~~~\x00\x03" b"\x00\x00—/•~~~~~~~~~\x00\x03" b"\x00\x00—/š~~~~~~~~~\x00\x03" b"\x00\x00—/¢~~~~~~~~~\x00\x03" b"\x00\x00—þ(~~~~~~~~~\x00\x03" ] |
||||||||||||||||||||||||
|
0.84 ms (0.32%) |
1 |
SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.translation.label`, `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.`product_sorting_id`, `product_sorting.translation`.`label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.`language_id` = ?) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"Ë›1 è¯Jx°\x0F¨¾=Ö\f1" ] |
||||||||||||||||||||||||
|
0.82 ms (0.31%) |
2 |
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `swag_dynamic_access_category_rule` `category.swagDynamicAccessRules.mapping` ON `category`.`id` = `category.swagDynamicAccessRules.mapping`.`category_id` AND `category`.`version_id` = `category.swagDynamicAccessRules.mapping`.`category_version_id` LEFT JOIN `rule` `category.swagDynamicAccessRules` ON `category.swagDynamicAccessRules.mapping`.`rule_id` = `category.swagDynamicAccessRules`.`id` WHERE (`category`.`version_id` = ?) AND ((((`category.swagDynamicAccessRules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) OR `category.swagDynamicAccessRules`.`id` <=> ?))) AND (`category`.`id` IN (?)) GROUP BY `category`.`id`
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\t,¿}{¸Eχ\x1F‹ÃXG\x02\x1A" b",õ˜–¯fGX–슽\x03¬&¶" b"8X•p\x16dMä®HÀP\vóÌÈ" b""" <}’kjGþŽJâ\r\n ™4$ """ b"iàé\vÔMFY‰ˆyvu.ýü" b"á7Ž·€ŠG‘ž\rt\r]l\x1A" b"é+6oàÎI{›^+L*,°ö" b"úŸë8R\eLPŠù\x1Aúüøžª" b"&×\x15wãeIÈ‹pK¹ç÷9\x18" b"(Ê®u¥bO\r˜Z½\x0E³*¡`" b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-" b"q\x01,<[öA=ƒ¹bAä{ÙÝ" null b"\x00\x00\x01† ~~~~~~~~~\x00\x01" ] |
||||||||||||||||||||||||
|
0.82 ms (0.31%) |
1 |
# product-listing-route::loading::search-ids SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `swag_dynamic_access_product_rule` `product.swagDynamicAccessRules.mapping` ON `product`.`id` = `product.swagDynamicAccessRules.mapping`.`product_id` AND `product`.`version_id` = `product.swagDynamicAccessRules.mapping`.`product_version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product` `product.parent.parent` ON `product.parent`.`parent_id` = `product.parent.parent`.`id` AND `product.parent`.`parent_version_id` = `product.parent.parent`.`version_id` LEFT JOIN `swag_dynamic_access_product_rule` `product.parent.swagDynamicAccessRules.mapping` ON `product.parent`.`id` = `product.parent.swagDynamicAccessRules.mapping`.`product_id` AND `product.parent`.`version_id` = `product.parent.swagDynamicAccessRules.mapping`.`product_version_id` LEFT JOIN `rule` `product.parent.swagDynamicAccessRules` ON `product.parent.swagDynamicAccessRules.mapping`.`rule_id` = `product.parent.swagDynamicAccessRules`.`id` LEFT JOIN `rule` `product.swagDynamicAccessRules` ON `product.swagDynamicAccessRules.mapping`.`rule_id` = `product.swagDynamicAccessRules`.`id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND (((`product.parent.swagDynamicAccessRules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND `product.swagDynamicAccessRules`.`id` <=> ?) OR ((`product.swagDynamicAccessRules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))) OR (`product.parent.swagDynamicAccessRules`.`id` <=> ? AND `product.swagDynamicAccessRules`.`id` <=> ?)))) AND (`product`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY `product`.`id`
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" 10 b"¤½mg\x16ÖA&½Ssª¾èɯ" true b"\t,¿}{¸Eχ\x1F‹ÃXG\x02\x1A" b",õ˜–¯fGX–슽\x03¬&¶" b"8X•p\x16dMä®HÀP\vóÌÈ" b""" <}’kjGþŽJâ\r\n ™4$ """ b"iàé\vÔMFY‰ˆyvu.ýü" b"á7Ž·€ŠG‘ž\rt\r]l\x1A" b"é+6oàÎI{›^+L*,°ö" b"úŸë8R\eLPŠù\x1Aúüøžª" b"&×\x15wãeIÈ‹pK¹ç÷9\x18" b"(Ê®u¥bO\r˜Z½\x0E³*¡`" b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-" b"q\x01,<[öA=ƒ¹bAä{ÙÝ" null b"\t,¿}{¸Eχ\x1F‹ÃXG\x02\x1A" b",õ˜–¯fGX–슽\x03¬&¶" b"8X•p\x16dMä®HÀP\vóÌÈ" b""" <}’kjGþŽJâ\r\n ™4$ """ b"iàé\vÔMFY‰ˆyvu.ýü" b"á7Ž·€ŠG‘ž\rt\r]l\x1A" b"é+6oàÎI{›^+L*,°ö" b"úŸë8R\eLPŠù\x1Aúüøžª" b"&×\x15wãeIÈ‹pK¹ç÷9\x18" b"(Ê®u¥bO\r˜Z½\x0E³*¡`" b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-" b"q\x01,<[öA=ƒ¹bAä{ÙÝ" null null "\x00\x00\x00\x073~~~~~~~~~\x00\x02" b"\x00\x00\vÚÚ~~~~~~~~~\x00\x02" "\x00\x00\x00\x16;~~~~~~~~~\x00\x02" b"\x00\x00\x00\x1E›~~~~~~~~~\x00\x02" "\x00\x00\f\x1EP~~~~~~~~~\x00\x02" "\x00\x00\x00%v~~~~~~~~~\x00\x02" "\x00\x00\x00$P~~~~~~~~~\x00\x02" "\x00\x00\x00\x05J~~~~~~~~~\x00\x02" "\x00\x00\x00\x05K~~~~~~~~~\x00\x02" "\x00\x00\x00\x05S~~~~~~~~~\x00\x02" b"\x00\x00\x00\x1Eî~~~~~~~~~\x00\x02" ] |
||||||||||||||||||||||||
|
0.80 ms (0.31%) |
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`.`file_hash` as `media.fileHash`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, `media.translation.title` as `media.title`, `media.translation.alt`, `media.translation.alt` as `media.alt`, `media.translation.customFields`, `media.translation.customFields` as `media.customFields` 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`.`alt` as `media.translation.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation`.`custom_fields` as `media.translation.customFields` 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"Ëö\x19¢oK·¤;ãC‚ûÎ4" b"‰w³•¢+G+—“kÒ0&\x07" b"–g\x00è•/O8¶+Ãö\x05\x10d" ] |
||||||||||||||||||||||||
|
0.77 ms (0.29%) |
1 |
# footer-pagelet::shipping-methods::read SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`technical_name` as `shipping_method.technicalName`, `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`.`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`.`file_hash` as `shipping_method.media.fileHash`, `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`, `shipping_method.media.translation.title` as `shipping_method.media.title`, `shipping_method.media.translation.alt`, `shipping_method.media.translation.alt` as `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, `shipping_method.media.translation.customFields` as `shipping_method.media.customFields`, `shipping_method.translation.name`, `shipping_method.translation.name` as `shipping_method.name`, `shipping_method.translation.description`, `shipping_method.translation.description` as `shipping_method.description`, `shipping_method.translation.trackingUrl`, `shipping_method.translation.trackingUrl` as `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, `shipping_method.translation.customFields` as `shipping_method.customFields` FROM `shipping_method` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name`, `shipping_method.translation`.`custom_fields` as `shipping_method.translation.customFields`, `shipping_method.translation`.`description` as `shipping_method.translation.description`, `shipping_method.translation`.`tracking_url` as `shipping_method.translation.trackingUrl` 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 (SELECT `shipping_method.media.translation`.`media_id`, `shipping_method.media.translation`.`alt` as `shipping_method.media.translation.alt`, `shipping_method.media.translation`.`title` as `shipping_method.media.translation.title`, `shipping_method.media.translation`.`custom_fields` as `shipping_method.media.translation.customFields` 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"µ®êØ~@NJº~âê~r1Ê" b"]×1%,ÇN¬¥+/Jç¹>÷" ] |
||||||||||||||||||||||||
|
0.77 ms (0.29%) |
1 |
# footer-pagelet::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`.`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`.`file_hash` as `payment_method.media.fileHash`, `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`, `payment_method.media.translation.title` as `payment_method.media.title`, `payment_method.media.translation.alt`, `payment_method.media.translation.alt` as `payment_method.media.alt`, `payment_method.media.translation.customFields`, `payment_method.media.translation.customFields` as `payment_method.media.customFields`, `payment_method.translation.name`, `payment_method.translation.name` as `payment_method.name`, `payment_method.translation.distinguishableName`, `payment_method.translation.distinguishableName` as `payment_method.distinguishableName`, `payment_method.translation.description`, `payment_method.translation.description` as `payment_method.description`, `payment_method.translation.customFields`, `payment_method.translation.customFields` as `payment_method.customFields` FROM `payment_method` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` 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` 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 (SELECT `payment_method.media.translation`.`media_id`, `payment_method.media.translation`.`alt` as `payment_method.media.translation.alt`, `payment_method.media.translation`.`title` as `payment_method.media.translation.title`, `payment_method.media.translation`.`custom_fields` as `payment_method.media.translation.customFields` 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"ç\x05CL6@J\x11©§*Ù,vÛÔ" b"\x13=ÇWŽeI«¢yº)øìøZ" b"Í\ræmÌZC‹›\x08î퇮Ç\x00" b"ų{i¼'IZ‹¡”V&\x08é" b"1Å&÷ý=Dĵ´HV|7;)" ] |
||||||||||||||||||||||||
|
0.75 ms (0.29%) |
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`, `currency.translation.shortName` as `currency.shortName`, `currency.translation.name`, `currency.translation.name` as `currency.name`, `currency.translation.customFields`, `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation`.`currency_id`, `currency.translation`.`short_name` as `currency.translation.shortName`, `currency.translation`.`name` as `currency.translation.name`, `currency.translation`.`custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.`language_id` = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ" ] |
||||||||||||||||||||||||
|
0.74 ms (0.28%) |
2 |
# seo-url::resolve-fallback SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (path_info = ?) AND (is_canonical = 1) LIMIT 1
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"¤½mg\x16ÖA&½Ssª¾èɯ" "/_esi/global/header" ] |
||||||||||||||||||||||||
|
0.73 ms (0.28%) |
1 |
SELECT `theme_id`, `technical_name`, `resolved_config`, `view_inheritance`, `script_files`, `icon_sets`, `updated_at` FROM `theme_runtime_config` WHERE `theme_id` = ?
Parameters:
[
b"5™\x11í›\eDHÔºñÝĨç"
]
|
||||||||||||||||||||||||
|
0.73 ms (0.28%) |
1 |
# breadcrumb-extension::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`.`cms_navigation_page_id` as `category.cmsNavigationPageId`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x17£á\x08*AB$†µÍƒ\x12¸S8" b"ÎŽ.¨)ëO\x06‰"ÎŽ™(ªø" b"\x00\x00\x01† ~~~~~~~~~\x00\x01" ] |
||||||||||||||||||||||||
|
0.71 ms (0.27%) |
1 |
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`active` as `language.active`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.name`, `language.locale.translation.name` as `language.locale.name`, `language.locale.translation.territory`, `language.locale.translation.territory` as `language.locale.territory`, `language.locale.translation.customFields`, `language.locale.translation.customFields` as `language.locale.customFields` FROM `language` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.locale.translation`.`locale_id`, `language.locale.translation`.`name` as `language.locale.translation.name`, `language.locale.translation`.`territory` as `language.locale.translation.territory`, `language.locale.translation`.`custom_fields` as `language.locale.translation.customFields` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation`.`language_id` = ?) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE `language`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" ] |
||||||||||||||||||||||||
|
0.69 ms (0.26%) |
1 |
# product-listing::load-sortings::read SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.translation.label`, `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.`product_sorting_id`, `product_sorting.translation`.`label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.`language_id` = ?) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"Ë›1 è¯Jx°\x0F¨¾=Ö\f1" b"VO(U¢IMä¡vÿ\x1C¶\x00<C" b"aüÕ\f_\x07N“”\x05³c.\x13(y" b"¬a–˜\x10öJíµ?ËeþÊ[Ž" b"\x16 nÄý¼Fû¹"vÈm’\x00a" b" ”#л2CuŽ¯rç%•\e+" b"\x14\x1Eƒæ˜\fJô„@#yFS3\x12" ] |
||||||||||||||||||||||||
|
0.67 ms (0.26%) |
1 |
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `swag_dynamic_access_category_rule` `category.swagDynamicAccessRules.mapping` ON `category`.`id` = `category.swagDynamicAccessRules.mapping`.`category_id` AND `category`.`version_id` = `category.swagDynamicAccessRules.mapping`.`category_version_id` LEFT JOIN `rule` `category.swagDynamicAccessRules` ON `category.swagDynamicAccessRules.mapping`.`rule_id` = `category.swagDynamicAccessRules`.`id` WHERE (`category`.`version_id` = ?) AND ((((`category.swagDynamicAccessRules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) OR `category.swagDynamicAccessRules`.`id` <=> ?))) AND (`category`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY `category`.`id`
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\t,¿}{¸Eχ\x1F‹ÃXG\x02\x1A" b",õ˜–¯fGX–슽\x03¬&¶" b"8X•p\x16dMä®HÀP\vóÌÈ" b""" <}’kjGþŽJâ\r\n ™4$ """ b"iàé\vÔMFY‰ˆyvu.ýü" b"á7Ž·€ŠG‘ž\rt\r]l\x1A" b"é+6oàÎI{›^+L*,°ö" b"úŸë8R\eLPŠù\x1Aúüøžª" b"&×\x15wãeIÈ‹pK¹ç÷9\x18" b"(Ê®u¥bO\r˜Z½\x0E³*¡`" b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-" b"q\x01,<[öA=ƒ¹bAä{ÙÝ" null b"\x11\x13¨aqI5©~]‚Yñö\x1D" b"\x11°þÛBøKç½\x1CÏ·5>6r" b"\x14ÉÔ\x11k‰AÊ¿Êtš\x05æ9x" b"\x16÷2W\ròMÖ¤åõœµbâÌ" b"$.¡Ü~iMp¦+÷g>#\x01Å" b"Fš=à‰VH`ê\x1D\x02Â"P‡" b"J$%à 1HS¸ëS=ícLø" b""" [Ƨ\x7FðñN\n ¿•wB¦™è\x17 """ b"eb8“n–G$±&‰fmE¬4" b"¯èÏa!dIa„)bö§®6à" b"²„'éº?E»‹ßq¹D.ð0" b"½^”ÄÕ\x16G7²àÎ<\x08ÔÑV" b"Ê5+Œ·\x04OÚ¹úîñƒ•\x0E`" b"ÓŠ*¡ð@\x14²£8jÖ¥‰Y" b"ýÍ2µ?Bku¤—ïAÈé" ] |
||||||||||||||||||||||||
|
0.63 ms (0.24%) |
1 |
SELECT LOWER(HEX(product.id)) AS product_id, LOWER(HEX(product_warehouse_group.warehouse_group_id)) AS warehouse_group_id, COALESCE(SUM(product_warehouse.stock), 0) AS stock, warehouse_group.priority AS priority, (warehouse_group.id IS NOT NULL) AS assigned FROM product INNER JOIN product_warehouse_group ON product.id = product_warehouse_group.product_id AND product.version_id = product_warehouse_group.product_version_id LEFT JOIN warehouse_group ON product_warehouse_group.warehouse_group_id = warehouse_group.id AND warehouse_group.rule_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) LEFT JOIN warehouse_group_warehouse ON warehouse_group_warehouse.warehouse_group_id = product_warehouse_group.warehouse_group_id LEFT JOIN product_warehouse ON product_warehouse.product_id = product_warehouse_group.product_id AND product_warehouse.product_version_id = product_warehouse_group.product_version_id AND product_warehouse.warehouse_id = warehouse_group_warehouse.warehouse_id WHERE product.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND product.version_id = ? GROUP BY product_warehouse_group.warehouse_group_id, product_warehouse_group.product_id
Parameters:
[ b"\t,¿}{¸Eχ\x1F‹ÃXG\x02\x1A" b",õ˜–¯fGX–슽\x03¬&¶" b"8X•p\x16dMä®HÀP\vóÌÈ" b""" <}’kjGþŽJâ\r\n ™4$ """ b"iàé\vÔMFY‰ˆyvu.ýü" b"á7Ž·€ŠG‘ž\rt\r]l\x1A" b"é+6oàÎI{›^+L*,°ö" b"úŸë8R\eLPŠù\x1Aúüøžª" b"&×\x15wãeIÈ‹pK¹ç÷9\x18" b"(Ê®u¥bO\r˜Z½\x0E³*¡`" b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-" b"q\x01,<[öA=ƒ¹bAä{ÙÝ" "\x00\x00\x00\x073~~~~~~~~~\x00\x02" b"\x00\x00\vÚÚ~~~~~~~~~\x00\x02" "\x00\x00\x00\x16;~~~~~~~~~\x00\x02" b"\x00\x00\x00\x1E›~~~~~~~~~\x00\x02" "\x00\x00\f\x1EP~~~~~~~~~\x00\x02" "\x00\x00\x00%v~~~~~~~~~\x00\x02" "\x00\x00\x00$P~~~~~~~~~\x00\x02" "\x00\x00\x00\x05J~~~~~~~~~\x00\x02" "\x00\x00\x00\x05K~~~~~~~~~\x00\x02" "\x00\x00\x00\x05S~~~~~~~~~\x00\x02" b"\x00\x00\x00\x1Eî~~~~~~~~~\x00\x02" b"\x0F©\x1CãéjK¾KÙÎu,4%" ] |
||||||||||||||||||||||||
|
0.57 ms (0.22%) |
1 |
SELECT `acris_search_product_pushing`.`id` FROM `acris_search_product_pushing` LEFT JOIN `acris_search_product_pushing_rule` `acris_search_product_pushing.rules.mapping` ON `acris_search_product_pushing`.`id` = `acris_search_product_pushing.rules.mapping`.`search_product_pushing_id` LEFT JOIN `rule` `acris_search_product_pushing.rules` ON `acris_search_product_pushing.rules.mapping`.`rule_id` = `acris_search_product_pushing.rules`.`id` WHERE ((`acris_search_product_pushing`.`active` = ? AND (`acris_search_product_pushing`.`type` = ? OR `acris_search_product_pushing`.`type` = ?) AND ((`acris_search_product_pushing.rules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) OR `acris_search_product_pushing.rules`.`id` <=> ?))) GROUP BY `acris_search_product_pushing`.`id`
Parameters:
[ true "all" "listing" b"\t,¿}{¸Eχ\x1F‹ÃXG\x02\x1A" b",õ˜–¯fGX–슽\x03¬&¶" b"8X•p\x16dMä®HÀP\vóÌÈ" b""" <}’kjGþŽJâ\r\n ™4$ """ b"iàé\vÔMFY‰ˆyvu.ýü" b"á7Ž·€ŠG‘ž\rt\r]l\x1A" b"é+6oàÎI{›^+L*,°ö" b"úŸë8R\eLPŠù\x1Aúüøžª" b"&×\x15wãeIÈ‹pK¹ç÷9\x18" b"(Ê®u¥bO\r˜Z½\x0E³*¡`" b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-" b"q\x01,<[öA=ƒ¹bAä{ÙÝ" null ] |
||||||||||||||||||||||||
|
0.52 ms (0.20%) |
1 |
# footer-pagelet::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` 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"¤½mg\x16ÖA&½Ssª¾èɯ" ] |
||||||||||||||||||||||||
|
0.50 ms (0.19%) |
1 |
SELECT `acris_search_product_pushing`.`id` as `acris_search_product_pushing.id`, `acris_search_product_pushing`.`name` as `acris_search_product_pushing.name`, `acris_search_product_pushing`.`active` as `acris_search_product_pushing.active`, `acris_search_product_pushing`.`type` as `acris_search_product_pushing.type`, `acris_search_product_pushing`.`search_term_matching` as `acris_search_product_pushing.searchTermMatching`, `acris_search_product_pushing`.`factor` as `acris_search_product_pushing.factor`, `acris_search_product_pushing`.`created_at` as `acris_search_product_pushing.createdAt`, `acris_search_product_pushing`.`updated_at` as `acris_search_product_pushing.updatedAt`, (SELECT GROUP_CONCAT(HEX(`acris_search_product_pushing.productStream.mapping`.`product_stream_id`) SEPARATOR '||') FROM `acris_search_product_pushing_stream` `acris_search_product_pushing.productStream.mapping` WHERE `acris_search_product_pushing.productStream.mapping`.`search_product_pushing_id` = `acris_search_product_pushing`.`id` ) as `acris_search_product_pushing.productStream.id_mapping` FROM `acris_search_product_pushing` WHERE `acris_search_product_pushing`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"+êJbu‡E¶OϽ§‘ëÿ" b"8êÊ•i×F~«\x14¥#\x0FÌmz" b"9¸2b\x0FŒB5†\x03ºC¿7·×" b"GhW½–¹N\x05¼¸`\x18@ÚBî" b"HIH&:ª@¬½ùQŽ~Öed" b"WO)ÆELZŽ¹îm\x11{ƒý" b"—“ìõ\x7F´Mk˜„ j?öéè" b"žÄm'!vOHµy4\x18pV]T" b"Èüû\x15\x02tOh£ê“fTÊ\fæ" b"Ïï§K‘ÜEd¦LbDŒ\x15"‚" b"áŸ0Üc©EŠ»€œ\x10ü'¹e" b"ù«e\x00P¾Hö“'xÅW6Æõ" b"úõ*dÒMDÅ•HÈ\vÉz~E" b"ÿ‘l©›¿H…³²PP\t\x06ò\x0E" ] |
||||||||||||||||||||||||
|
0.48 ms (0.18%) |
1 |
SELECT `acris_search_product_restriction`.`id` FROM `acris_search_product_restriction` LEFT JOIN `acris_search_restriction_cat` `acris_search_product_restriction.categories.mapping` ON `acris_search_product_restriction`.`id` = `acris_search_product_restriction.categories.mapping`.`search_product_restriction_id` LEFT JOIN `acris_search_restriction_rule` `acris_search_product_restriction.rules.mapping` ON `acris_search_product_restriction`.`id` = `acris_search_product_restriction.rules.mapping`.`search_product_restriction_id` LEFT JOIN `category` `acris_search_product_restriction.categories` ON `acris_search_product_restriction.categories.mapping`.`category_id` = `acris_search_product_restriction.categories`.`id` AND `acris_search_product_restriction.categories`.`version_id` = `acris_search_product_restriction.categories.mapping`.`category_version_id` LEFT JOIN `rule` `acris_search_product_restriction.rules` ON `acris_search_product_restriction.rules.mapping`.`rule_id` = `acris_search_product_restriction.rules`.`id` WHERE ((`acris_search_product_restriction`.`active` = ? AND (`acris_search_product_restriction`.`type` = ? OR `acris_search_product_restriction`.`type` = ?) AND (`acris_search_product_restriction.categories`.`id` <=> ? OR (`acris_search_product_restriction.categories`.`id` IN (?))) AND ((`acris_search_product_restriction.rules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) OR `acris_search_product_restriction.rules`.`id` <=> ?))) GROUP BY `acris_search_product_restriction`.`id`
Parameters:
[ true "all" "listing" null b"\x00\x00\x01† ~~~~~~~~~\x00\x01" b"\t,¿}{¸Eχ\x1F‹ÃXG\x02\x1A" b",õ˜–¯fGX–슽\x03¬&¶" b"8X•p\x16dMä®HÀP\vóÌÈ" b""" <}’kjGþŽJâ\r\n ™4$ """ b"iàé\vÔMFY‰ˆyvu.ýü" b"á7Ž·€ŠG‘ž\rt\r]l\x1A" b"é+6oàÎI{›^+L*,°ö" b"úŸë8R\eLPŠù\x1Aúüøžª" b"&×\x15wãeIÈ‹pK¹ç÷9\x18" b"(Ê®u¥bO\r˜Z½\x0E³*¡`" b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-" b"q\x01,<[öA=ƒ¹bAä{ÙÝ" null ] |
||||||||||||||||||||||||
|
0.47 ms (0.18%) |
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.45 ms (0.17%) |
1 |
SELECT `product_stream`.`id` as `product_stream.id`, `product_stream`.`api_filter` as `product_stream.apiFilter`, `product_stream`.`invalid` as `product_stream.invalid`, `product_stream`.`created_at` as `product_stream.createdAt`, `product_stream`.`updated_at` as `product_stream.updatedAt`, `product_stream.translation.name`, `product_stream.translation.name` as `product_stream.name`, `product_stream.translation.description`, `product_stream.translation.description` as `product_stream.description`, `product_stream.translation.customFields`, `product_stream.translation.customFields` as `product_stream.customFields` FROM `product_stream` LEFT JOIN (SELECT `product_stream.translation`.`product_stream_id`, `product_stream.translation`.`name` as `product_stream.translation.name`, `product_stream.translation`.`description` as `product_stream.translation.description`, `product_stream.translation`.`custom_fields` as `product_stream.translation.customFields` FROM `product_stream_translation` `product_stream.translation` WHERE `product_stream.translation`.`language_id` = ?) `product_stream.product_stream_translation` ON `product_stream.product_stream_translation`.`product_stream_id` = `product_stream`.`id` WHERE `product_stream`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"rÖ"`qÝ@J±ðm‹]=JJ" b""" Ã\n BrJéL\x140[R\x05\x04‰ """ b"\rAfÀ\x07N‡¼¨òz–g%Ž" b"Ô#n€uÂO\n¡O¼\x00å§ÒÏ" b"üo{#cóN°¬Lèȼ„œ€" b"KÀ«\eƒÑL{Šx2J¨\x16\\x19" b""" Ã\n BrJéL\x140[R\x05\x04‰ """ b"$½žùzÏI«¼. f…@ý“" b"å";G¥pH\x04·©\e Ïv\x06´" b"IÍklç¤L ¿» ¥ŠZR" b"ZSÉ\x18fJf—U`‡\føˆÙ" b"ñÜoUä"EÅŽ¤"þ÷+\x02\v" b"ÙÑÓGmþI»¦\x02\x14—y\x7F\x13" b"ZqË4¼/Nœ„O‚{¬ýN^" ] |
||||||||||||||||||||||||
|
0.44 ms (0.17%) |
1 |
# footer-pagelet::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"¤½mg\x16ÖA&½Ssª¾èɯ" ] |
||||||||||||||||||||||||
|
0.44 ms (0.17%) |
1 |
SELECT LOWER(HEX(p.id)), pt.name FROM product p INNER JOIN product pp ON pp.id = p.parent_id AND pp.version_id = ? INNER JOIN product_translation pt ON pp.id = pt.product_id WHERE p.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p.version_id = ?
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" "\x00\x00\x00\x073~~~~~~~~~\x00\x02" b"\x00\x00\vÚÚ~~~~~~~~~\x00\x02" "\x00\x00\x00\x16;~~~~~~~~~\x00\x02" b"\x00\x00\x00\x1E›~~~~~~~~~\x00\x02" "\x00\x00\f\x1EP~~~~~~~~~\x00\x02" "\x00\x00\x00%v~~~~~~~~~\x00\x02" "\x00\x00\x00$P~~~~~~~~~\x00\x02" "\x00\x00\x00\x05J~~~~~~~~~\x00\x02" "\x00\x00\x00\x05K~~~~~~~~~\x00\x02" "\x00\x00\x00\x05S~~~~~~~~~\x00\x02" b"\x00\x00\x00\x1Eî~~~~~~~~~\x00\x02" b"\x0F©\x1CãéjK¾KÙÎu,4%" ] |
||||||||||||||||||||||||
|
0.44 ms (0.17%) |
2 |
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" b"Ç´S-A\x10OÙ§€ÞëT;_," ] |
||||||||||||||||||||||||
|
0.43 ms (0.16%) |
1 |
# product-listing-route::loading::association::streams::read SELECT `product_stream`.`id` as `product_stream.id`, `product_stream`.`api_filter` as `product_stream.apiFilter`, `product_stream`.`invalid` as `product_stream.invalid`, `product_stream`.`created_at` as `product_stream.createdAt`, `product_stream`.`updated_at` as `product_stream.updatedAt`, `product_stream.translation.name`, `product_stream.translation.name` as `product_stream.name`, `product_stream.translation.description`, `product_stream.translation.description` as `product_stream.description`, `product_stream.translation.customFields`, `product_stream.translation.customFields` as `product_stream.customFields` FROM `product_stream` LEFT JOIN (SELECT `product_stream.translation`.`product_stream_id`, `product_stream.translation`.`name` as `product_stream.translation.name`, `product_stream.translation`.`description` as `product_stream.translation.description`, `product_stream.translation`.`custom_fields` as `product_stream.translation.customFields` FROM `product_stream_translation` `product_stream.translation` WHERE `product_stream.translation`.`language_id` = ?) `product_stream.product_stream_translation` ON `product_stream.product_stream_translation`.`product_stream_id` = `product_stream`.`id` WHERE `product_stream`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"¤Á„eß@Ю¸´xI([" b"°{†\x02-"K¿¬\x1FNz\x02¼U¢" b"¤Á„eß@Ю¸´xI([" b"°{†\x02-"K¿¬\x1FNz\x02¼U¢" b"¤Á„eß@Ю¸´xI([" b"°{†\x02-"K¿¬\x1FNz\x02¼U¢" b"¤Á„eß@Ю¸´xI([" b"°{†\x02-"K¿¬\x1FNz\x02¼U¢" b"¤Á„eß@Ю¸´xI([" b"°{†\x02-"K¿¬\x1FNz\x02¼U¢" b"¤Á„eß@Ю¸´xI([" b"°{†\x02-"K¿¬\x1FNz\x02¼U¢" b"¤Á„eß@Ю¸´xI([" b"°{†\x02-"K¿¬\x1FNz\x02¼U¢" b"¤Á„eß@Ю¸´xI([" b"°{†\x02-"K¿¬\x1FNz\x02¼U¢" b"¤Á„eß@Ю¸´xI([" b"°{†\x02-"K¿¬\x1FNz\x02¼U¢" b"°{†\x02-"K¿¬\x1FNz\x02¼U¢" b"¤Á„eß@Ю¸´xI([" b"°{†\x02-"K¿¬\x1FNz\x02¼U¢" ] |
||||||||||||||||||||||||
|
0.40 ms (0.15%) |
1 |
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||||||
|
0.37 ms (0.14%) |
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.36 ms (0.14%) |
1 |
# product-listing-route::loading::association::prices::read SELECT `product_price`.`id` as `product_price.id`, `product_price`.`version_id` as `product_price.versionId`, `product_price`.`product_id` as `product_price.productId`, `product_price`.`product_version_id` as `product_price.productVersionId`, `product_price`.`rule_id` as `product_price.ruleId`, `product_price`.`price` as `product_price.price`, `product_price`.`quantity_start` as `product_price.quantityStart`, `product_price`.`quantity_end` as `product_price.quantityEnd`, `product_price`.`custom_fields` as `product_price.customFields`, `product_price`.`created_at` as `product_price.createdAt`, `product_price`.`updated_at` as `product_price.updatedAt` FROM `product_price` WHERE (`product_price`.`version_id` = ?) AND (((`product_price`.`product_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))))
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" "\x00\x00\x00\x05J~~~~~~~~~\x00\x02" "\x00\x00\x00\x05K~~~~~~~~~\x00\x02" "\x00\x00\x00\x05S~~~~~~~~~\x00\x02" "\x00\x00\x00\x073~~~~~~~~~\x00\x02" "\x00\x00\x00\x16;~~~~~~~~~\x00\x02" b"\x00\x00\x00\x1E›~~~~~~~~~\x00\x02" b"\x00\x00\x00\x1Eî~~~~~~~~~\x00\x02" "\x00\x00\x00$P~~~~~~~~~\x00\x02" "\x00\x00\x00%v~~~~~~~~~\x00\x02" b"\x00\x00\vÚÚ~~~~~~~~~\x00\x02" "\x00\x00\f\x1EP~~~~~~~~~\x00\x02" ] |
||||||||||||||||||||||||
|
0.35 ms (0.13%) |
1 |
SELECT `product_warehouse_group`.`product_id`, `product_warehouse_group`.`warehouse_group_id` FROM `product_warehouse_group` LEFT JOIN `warehouse_group` `product_warehouse_group.warehouseGroup` ON `product_warehouse_group`.`warehouse_group_id` = `product_warehouse_group.warehouseGroup`.`id` WHERE ((`product_warehouse_group`.`product_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (`product_warehouse_group.warehouseGroup`.`rule_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))) ORDER BY `product_warehouse_group.warehouseGroup`.`priority` ASC
Parameters:
[ "\x00\x00\x00\x073~~~~~~~~~\x00\x02" b"\x00\x00\vÚÚ~~~~~~~~~\x00\x02" "\x00\x00\x00\x16;~~~~~~~~~\x00\x02" b"\x00\x00\x00\x1E›~~~~~~~~~\x00\x02" "\x00\x00\f\x1EP~~~~~~~~~\x00\x02" "\x00\x00\x00%v~~~~~~~~~\x00\x02" "\x00\x00\x00$P~~~~~~~~~\x00\x02" "\x00\x00\x00\x05J~~~~~~~~~\x00\x02" "\x00\x00\x00\x05K~~~~~~~~~\x00\x02" "\x00\x00\x00\x05S~~~~~~~~~\x00\x02" b"\x00\x00\x00\x1Eî~~~~~~~~~\x00\x02" b"\t,¿}{¸Eχ\x1F‹ÃXG\x02\x1A" b",õ˜–¯fGX–슽\x03¬&¶" b"8X•p\x16dMä®HÀP\vóÌÈ" b""" <}’kjGþŽJâ\r\n ™4$ """ b"iàé\vÔMFY‰ˆyvu.ýü" b"á7Ž·€ŠG‘ž\rt\r]l\x1A" b"é+6oàÎI{›^+L*,°ö" b"úŸë8R\eLPŠù\x1Aúüøžª" b"&×\x15wãeIÈ‹pK¹ç÷9\x18" b"(Ê®u¥bO\r˜Z½\x0E³*¡`" b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-" b"q\x01,<[öA=ƒ¹bAä{ÙÝ" ] |
||||||||||||||||||||||||
|
0.33 ms (0.13%) |
1 |
SELECT COUNT(DISTINCT `category`.`id`) as `categories` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?))
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x17£á\x08*AB$†µÍƒ\x12¸S8" b"ÎŽ.¨)ëO\x06‰"ÎŽ™(ªø" ] |
||||||||||||||||||||||||
|
0.33 ms (0.12%) |
1 |
# product-price-calculator::units::read SELECT `unit`.`id` as `unit.id`, `unit`.`created_at` as `unit.createdAt`, `unit`.`updated_at` as `unit.updatedAt`, `unit.translation.shortCode`, `unit.translation.shortCode` as `unit.shortCode`, `unit.translation.name`, `unit.translation.name` as `unit.name`, `unit.translation.customFields`, `unit.translation.customFields` as `unit.customFields` FROM `unit` LEFT JOIN (SELECT `unit.translation`.`unit_id`, `unit.translation`.`short_code` as `unit.translation.shortCode`, `unit.translation`.`name` as `unit.translation.name`, `unit.translation`.`custom_fields` as `unit.translation.customFields` FROM `unit_translation` `unit.translation` WHERE `unit.translation`.`language_id` = ?) `unit.unit_translation` ON `unit.unit_translation`.`unit_id` = `unit`.`id`
Parameters:
[
b"/»_ââšMpªXTÎ|ãâ\v"
]
|
||||||||||||||||||||||||
|
0.29 ms (0.11%) |
1 |
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
"de-DE"
]
|
||||||||||||||||||||||||
|
0.28 ms (0.11%) |
1 |
SELECT `theme_id`, `technical_name`, `resolved_config`, `view_inheritance`, `script_files`, `icon_sets`, `updated_at` FROM `theme_runtime_config` WHERE `technical_name` = ?
Parameters:
[
"BehrTheme"
]
|
||||||||||||||||||||||||
|
0.25 ms (0.10%) |
1 |
SELECT LOWER(HEX(assoc.`sales_channel_id`)) FROM `sales_channel_payment_method` AS assoc LEFT JOIN `payment_method` AS pm ON pm.`id` = assoc.`payment_method_id` WHERE assoc.`payment_method_id` = ? AND pm.`active` = 1
Parameters:
[
b"ç\x05CL6@J\x11©§*Ù,vÛÔ"
]
|
||||||||||||||||||||||||
|
0.25 ms (0.10%) |
1 |
SELECT `acl_role`.`privileges` AS `privileges` FROM `acl_role` INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id` WHERE `app`.`id` = ?
Parameters:
[
b"\x01›\x12(`µpþƒG\x07\x0FˆŽÕE"
]
|
||||||||||||||||||||||||
|
0.25 ms (0.10%) |
1 |
SELECT url FROM sales_channel_domain
Parameters:
[] |
||||||||||||||||||||||||
|
0.23 ms (0.09%) |
1 |
SELECT path FROM category WHERE id = ?
Parameters:
[
b"\x00\x00\x01† ~~~~~~~~~\x00\x01"
]
|
||||||||||||||||||||||||
|
0.22 ms (0.08%) |
1 |
# product-listing::load-sortings::search-ids SELECT `product_sorting`.`id` FROM `product_sorting` WHERE (`product_sorting`.`active` = ?) ORDER BY `product_sorting`.`priority` DESC
Parameters:
[
true
]
|
||||||||||||||||||||||||
|
0.22 ms (0.08%) |
1 |
SELECT `handler_identifier`, LOWER(HEX(`id`)) FROM `payment_method`
Parameters:
[] |
||||||||||||||||||||||||
|
0.22 ms (0.08%) |
1 |
# product-listing-route::category-loading::read SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`product_stream_id` as `category.productStreamId` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x00\x00\x01† ~~~~~~~~~\x00\x01" ] |
||||||||||||||||||||||||
|
0.20 ms (0.08%) |
1 |
SELECT `name`, `path`, `author`, `self_managed` FROM `app` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||||||
|
0.19 ms (0.07%) |
1 |
# product-listing-route::category-loading::search-ids SELECT `category`.`id`, `category`.`auto_increment` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?)) LIMIT 1
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x00\x00\x01† ~~~~~~~~~\x00\x01" ] |
||||||||||||||||||||||||
|
0.16 ms (0.06%) |
1 |
SELECT `min_search_length` FROM `product_search_config` WHERE `language_id` = ?
Parameters:
[
b"/»_ââšMpªXTÎ|ãâ\v"
]
|
Database Connections
| Name | Service |
|---|---|
| 0 | default |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.