Query Metrics
148
Database Queries
106
Different statements
77.50 ms
Query time
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
13.42 ms (17.32%) |
4 |
-- header::navigation::read SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`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"#ûŽé´\x05E©¹ÔMÝ›\k'" "%|23fb8ee9b40545a9b9d44ddd9b5c6b27|%" 1 6 ] |
||||||||||||||||||||||||
|
9.27 ms (11.96%) |
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"\x01”ùYW6~Š©vóä}0Ê‹" b"OÒPòý}BÖ„¿Ÿ\x07ÖšÞ " b"Ó´Û–9üAý©ü_\f27~" null b"\x00#Ù\x12ãßNq \e-\x1AÉP^4" b"\x00iÆ^\x14:Em˜\x16å§"\x11%C" b"\x00¢\x02=GÎHb€˜ø\x02ÖÔ\x1FV" b"\x01‹¨×‡\x7Fñ¬½¨\x13¼®¸½" b"\x01‹¨ØtÊ||‡B¨E½q\x05Š" b"\x01‹¨Ü9²tá½1~ƒ¡\tìê" b"\x01‹¨Ýò\x01|1™?\x13鶎â\x19" b"\x01‹¨Þ\x03s—¼Œz\x1C$¨›"" b"\x01‹¨Þ#/wk¡u+\x0E&Á\x05m" b"\x01‹¸´4·tŽ„.,Î<áµ" b"\x01‹¸´’óy"ó°{t\dµ" b""" \x01Žîþ£\x18uà–\x13\x17\x16ŠT\n ¶ """ b"\x01Žz\x19ù\x18zÙ‘›2,h¹\x0Fc" b"\x01Ž\x7F1?Èq„‚Ò¤î+Aúš" b"\x01Ž¼Œ\t\ts6ŽéÓÝb\x1E\x04ß" b"\x01ÈÖk\x02\x7F©˜w\x03qPéj\x00" b"\x01\v‰9&~±±¸Žró\x03YÔ" b"\x01SS½\x00v(º\x01—^^Œ•‰" b"\x01‘5â\x7F…qr„B¸¨ÎæKà" b"\x01‘¼ïòÙx€¬A\v>öÓPí" b"\x01’\x05-¨n|9+—º0ÀŠL" b"\x01’\x1E™#žz£Œˆ cGñû" b"\x01“SU\x03Ô}ô§|p(ˆŸ~\x1A" b"\x01“h…ç‹z9«Ž¼öª\x10\f¢" b"\x01“n\x04Ôçx—•B²W¥" b"\x01”îØ'”qç˜DVÂ¥\x03’ƒ" b"\x01”ïKtéy‹“\x07H\x1FìeÉY" b"\x01”ïQdŸ\x7Fx€Ï£1n~,\x18" b"\x01”ïQ…\x01~\x10‡#ý]\x7F–hU" b"\x01”ïQ£gq.¨TƒØ\x00&rK" b"\x01”ïTÏúw0¶\x11¬G\x14WÿN" b"\x01”ïTåEzD–)^\x01øÝ\x01\x19" b"\x01•\x148ïÿ{ÿ®‡þü¿·Lz" b"\x01•k&\x02vÿ¹3›Ôbm\x08©" b"\x01–´\x1DPlpæ¼ø\x17m—ÇGw" b"\x01–´\x1E\x03!r\x06•\x1E(Ø\x17ÉÖ" b"\x01–´\x1E\x1DŠ}à¹\x17ÈJì~"t" b"\x01–´\x1E.\r~~ª+\x081Fû]" b"\x01–´\x1EGäp…°´KVÖú¹T" b"\x01˜W\x05fqרñ¦ã¨ÀÀÁ" b"\x01ÝšyÖèMk¾Ì™hÆ\x07¦\x07" b"\x02Eñ3GW@ –$§‹â Ëu" b"\x02Þ\v\x04o\x18L-€Vɺ\gÂ" b"\x03{#íÆÀF¸±†¯\x06\x7F’Éz" b"\x06%ÔíðDKоƒqü\z°\x18" b"\x07\Õöü&MB›\x08\v~øh†%" b"\x08w•¿DtB¸Ÿ\x16Š25.\x12›" b""" \x08•TÏ\x01^A\n £Åfr;ÀÉÔ """ b"\x08²ŸMýõH§›\x03¢5~+÷ä" b"\tx[©¤ƒH£˜Yz$ÉG¢" b"\t‡™•©NM0ƒÃ\x08<•K]" b"\tľDL©G׊ÜAó\x04—\x19¨" b"\týôþ§ŸM‹³¿ÉPFÐ\x08" b""" \n \x0F\x1CçB\x17C¾ˆ-Ðø—c' """ b"\n‚'\x12N\x05M{Œ%“Ø\x00.h½" b"\n‰a\v«›IL„\x00á\x15';sù" b""" \n ª\x1EŽÍ(GÕ õX‹ä˜?\f """ b"\voŽ…®F÷”&ÉÖ°Š\v" b"\fVÖ‰ˆÉLÝŽ™\fŒåÍÌ“" b"\r^‹Á‡THv©\x13rr\r{\x1FÄ" b"\r‹®\x1FkŽLr´äϾ¤þD¯" b"\x0EßY\x170²LÂ\¤øîéí>" b"\x0F¿L¥QÓN´’·ºw þCú" b"\x10\x15ð\\f–Næ½xÕLO\®×" b""" \x11\x1DxYnÁO;³Õœ[\n TJ """ b"\x11ø„B¯4NÅ™\x08ý@Á°Ú\x1A" b"\x12;y\x17™?K[ŠË\x14'ëŸ\x02´" b"\x12Û»\x1FT¤F½¬\x0EŠŒmìEÏ" b"\x12î*áÑßJ\x10–šYUŸú?×" b"\x13Ç!ìýdIÑ¢\x05u¬\vRZÝ" b"\x14Û\x15\x00pI³¹ÙŽåü<\e–" b"\x15¢5/Z`Jñ’\x10Õpeópf" b"\x15¾Ñ?ÑÞE•³Ž8VÓGM¡" b"\x15ýâü\x0F/G{¼<!ýÉÄÛ»" b"\x17ŠÓ7N@ÿ¨i‰×dçì" b"\x17é~Õ£"B%žÁ@˜t¸=F" b""" \x18æ\n <pLÜŒ$µ\x16IqÕ‰ """ b"\x19\x07KH˜\x19G\x08ŒÓý8Ç®âº" b"\x19\x16\x04d^\x15Hð™à\x7Ft£.Ýr" b"\x19&wa\x12@kžÿ$éÞã®r" b"\x1A\x17Í}ñ\x1FB\x08 ˆ2\x14\x1D4=\x0F" b"\x1AýôCõ†Bò³ŸB½8>0\x13" b"\eb\x15jÈËC¯°º\x0FÐדb‚" b"\e±’°¶xN}Ÿh£¡ºµzm" b"\x1D&„j’êDEš)à÷1+\x13á" b"\x1FŽÜ*Þ)NăìPsâ@î9" b"\x1FóMhKïL%“&,v«,M$" b" \x19áàÂC6¼Ì*k½}y" b" Cœ-AF¹Ž,7ç"|è " b""FX\x06WÜ@˯j<ïþ\x1EèV" b""]ªý4LLHÝò+¬¯ÓS" b""pPÓ¤·FpkÙãRaŒ" b"#ùCûr‰@û±b{”è3 " b"#ûŽé´\x05E©¹ÔMÝ›\k'" b"%zb˜ÜFñ2N¥\*p¡" b"%í\\x13M’CÆ$üäéKZÔ" b"&aZ\x10¼×Aò¬x2.\x1AòßK" b"'\x12ó/Ë,GZœ”b©³çãÉ" b"'<u3¹JÒl¹C\x14\x1CŽ\e" b"(NÑ&€âN£ºÌÖFïŽíž" b"(™\e)M”G/)\x17\e«õå;" b"(êéÒ…oOà¢Cl6W¯\x1AŽ" b")\x16P~ˆ\x04N\x06‰]\x082,v\x02Û" b"*«÷þî…K-™\rªªÞE`" b"+Í(6\eøD¡´Ê§àŽ\x14\rY" b",4¬-ÑCHp‡]µÜÖèyˆ" b",8Ò¾µ;N¼ŽÀËû¹åde" b",E\t"‚cLe¤ír\x17ŒˆŒX" b",lÉÞóöI㸗\x18GBÑq\x02" b",·\x06ô(ÃO\¼ª1Ê``îà" b"-\x10:Ÿš&H«¦ÐNúý\x08Ò\x0F" b"-(XÅÎ\x04L>´«\x0F×Ü‚\x16=" b"-E\x125£Mº™VÙ</´´ù" b"-‡úüøÑBí±I\x16+…™²"" b"-Ž)Ã4\fDìhOÿW]xâ" b"/½\x7F^ÄSB]¡—VØÒJ¿Þ" b"0Œ\tÛfŽAWœÝÏ\x12\x03*\rÛ" b"0Ýc(`BA¥<N\e¨ŸG›" b"1ù:\x08$æMJ¬7¯€²}\x1EL" b"2.î*Š€LM¨¡B\x12}feï" b"2ºÜ"eýEj¦Ó'YúÙ¤\x05" b"2éÝ\x14ö‚K]¸Vñ\x1Az—Tp" b"3”/d\x1AnDEº@ú~±…UÂ" b"3ß+ØÏ/L\x00…Ãþ\x141.n™" b"4\x13Gkð\x11J\t§kO\e4-¥Ò" b"4\x1F#ßK»KÊ®•¯V\x12ŒÜ" b"4ˆ—6\x1EDEÇ„÷\x1Câã\x1EìÀ" b"4±ª§\x0E\x07OϧŠÍЄK¥" b"4·¦c¸¼IŸ§°¾Qÿªüë" b""" 4Öº\n \f’@š‡¯£<\x16h£Á """ b"5LJe/ïEÍ‘KS‘M\x15§Á" b"5vh¾@ÒIM¹Ïú‰¸åø" b"6\x13bbAO¢¸f]Ó¹5è." b"6¸êyò(Mï³A(]‚ŒNz" b"7\x00.Ó¬B¯™\v¹\x07À"ob" b"7sk/=ê@û¥epþic\x14\x06" b"8EôÁCÏA`•uD8½2º¨" b"8S³™˜PCZµè\x7FK\x00¯’t" b"8—¥Ñë\rIú®ÿ"è&z,¯" b"9y\x04,\e¸Fv£œI–‘[mÎ" b":j\x18ôß\x10Iý•Lüœ}å\x1AÅ" b""" :øªh•ÿMÒ¼äº\x17“\n \x02© """ b";ý\x03±Ð;Jˆ²2\x0FŸe†7\x0E" b"=+Æ5Z!@\x1A¿!Ûos\r„×" b">Lº›\x13‚BÀD.w½ñø\x1F" b">w)*•=C\x11¸Töû\x05sg\n" b">¤¼}œJy¶€bΕô[¤" b">Ù¶Ä „GDŠ"`6zW\x16" b"?D»\f\x03ñA[…\t2ùTœKU" b"?|ôtǧ@ ž’ü#O\x1D»" b"?,æ \x15E„ ’8\x08+Áæ\x1F" b"?¾\ew”#CΆ”\x1F>¿Ö\x7F÷" b"@óßתIN—º\x12-£+°þû" b"B\x13î8BÖGO³BŒÇF\x06¹¸" b"BoÕÌ\x1F¡@Ò¡F^^–$ª" b"B|í\t…ÄD~… Šµ\6Ð@" b"B˜MVû G-œá\x01iìΟ0" b"DB×O\x1C+N€¨73∰ÕL" b"DÞ#OBžJ¦ˆ`†o½|†k" b"DÞ°x¤oES†\x089Ž\x19û\" b"Fød¸À„Kµ¿i¿?/\x0FU§" b"GQú½\x1F%Dª‹\x07œº\x14`]ù" b"G£Õý»K£±ƒÊT\x18›Ü\n" b"H€—¤àFˆ»ùçTOŽ±Î" b"HœÍí\x07iG¯ˆÎÃÍÈœU}" b"I\x15ZÿDôGÝ»n¢:,ŒîM" b"I«\x1Fö#úCK ’”Ò;¿Š`" b"IÏTh\t\x19ON»Lü£¤–Š†" b"J\x02ž[cBŽ–ªÍn'ëÇi" b"Jìã\x05 DmŽÓ»|ˆœG7" b"Kˆ¾Ú\x19zN"›Ï\x00Å·ôÎ" b""" LƒKç·BHžä£Áw\n «n """ b"Lð×#&›Cç°ƒí+*½°ù" b"M\x04¨â\x046D”†ºWä+e\f1" b"Ma§\x1C\x11NJEµ!癬ëšO" b"N&:©ŠN&‹`d#ê¿â" b"O\x1F\x0E®Í\x13H…¥8Ï"z¬\x13×" b"O¦\x08\x04fIµ‡jyyZ\x15â¤" b"O¾°aAøN\x0F²¸ˆ·z€Ù" b"Oû–\x05z¬J>¥#ß\x08DPÌ" b"Q@Ôͧ¦N\x15–b&{³l¾²" b"Q®T{$ÈO’\x07ŒåüÅ\x05Ó" b"S0Ø¥È\x17DÊ¿,\fÎ4Â4€" b"Sk3ÒÜáF\x04’,xß®n±#" b"T%Z0„^K\x05†µ0h“èv\x18" b"T8Æõƒ}B\f™¢NHà\x05kŸ" b"U•B\x19NùHà†ð\\Á–ܵ" b"U¥iD03J\x13´y*P…™~k" b"V‹8“{¿Iø`&ÕNáy'" b"V¸Ãå@ F ´][õÉØŸò" b"Wsîhø\x03O^–\x1A0Ê2…ÆÊ" b"W”¬~éhEÝ‹Nå•\x1Eeíÿ" b""" X\n ¥\x03\x04*C/—8ò\eÜê """ b"X‰¿ø\x11\eIQ‘I•\x0F€ò‚×" b"Y²r}‘]HíˆÚ±%ÀQ>Ÿ" b"[ÖÉ7IóN–Šî-éï\x17aŒ" b"\YÍÌ6˜G·¯šûõJû" b"\†¦\x07/Jȯ>çCÎ9\x17Â" b"]Äß_?SD?§šl\x7F\x7FrÚö" b"]ÎXÏÞhE9€\x11]\x15¢ça" b""" ^…šº\x03>N\n ½x5>øž¡ """ b"aoTåh\x03L\x12†›§^á\x0Fʱ" b"aŽ™¤nõK¢‡Û[\eÿW\x12ç" b"c»Â½kKA€ÝK\tå\x03ÛÂ" b"dY\x08RZ¡@Õ¯ò"Ý\x07‚òM" b"dÖOe‹™G˲‘ŸmÁýv/" b"fÐ4N‘’C. &ŽÙ³'cI" b"jZ¾}ú?MH‚ŠbO‰bdt" b"jî«°Î!EÙ¦^ÕwÔ\x1Ak›" b"k8èÔî“M±µÂ6™‹¯%" b"kª>ÔåÜA€Ÿ\tš\x1F[-MÄ" b"l\x0Fn#3‹I¨©¬õan×\x1D" b"lYLÜF\x01Au\x1A\r8-c"Ô" b"o\x1A¹z›ªJ›³‹m‚Ij1I" b"oÌÿL€qHç›\x05œ1úZ%˜" b"p\x03 \x10VEŸC6/Ϲnë" b"pé|7èO$œ-<»Kæ\x17\" b"q-?àc\x05Iæ‹ï@q\x11åÒÞ" b"r\x05¼«DùI\x00›ó‰bq\x13¥´" b"r Ù±\x19üJu¯gÉ\x16\x1EA™õ" b"t\x0EE"N³Bž½0¡\x7FqÜ" b"t\%©«½Fþ´hÌ:ƒr\x17*" b"t}îç,`G\eªÁÝô\x01-ÿ" b"t«\x005\x00aIv–µïÔ\x16yÄÆ" b"tÏ“3™M\x05±ŽÇ\x13%íÿ\x05" b"u\x1A½ésBL «€\x1F‚?ô¸æ" b"v5«Ð¢ïN\v£Ã\fÜý¹å×" b"vT«R\tIBð¡Õ<Õ°¢¦Ð" b""" vr*>ê\x17OD·Á\x18ºÚ*\n \t """ b"v“Džm\x10H—„bÅ\x08aÑ÷•" b"v¢òQ™ÖOµžg\x11\x17Ïj¡&" b"vÕÖú>‡GžŠ£'w™ïèN" b"xÔõëN]•\x16¦º\x03`\x1D/" b"y˜ÝzÃ`B‰¤==ÕL¤“" b"z6xÂnkMï¾g²'ÄðŠ\x16" b"z\x7F#65õAׄ[åæ“sÕñ" b"z±'W£'E¤£í‘šý¤ßt" b"zº–\x19ÏëJ®—ñTMþ/î\x03" b"{W_¶\eEBX¾Y¡\x03±êì¦" b"{¶ûqHԢ⧦\x1Dþû#" b"|{å¿\rýNt›/\x1FNPÄí" b"|¯µ\x0F\x1CÙCq‚©×B6PM!" b"|Ê\x15—=©I³µË†bel'ö" b"}–¤Ì‡JJy€üDfý±Íº" b"\x7F\x1A\x05\x01\x1FhK©»¥ÒcGþØL" b"€\t\x16]V~N\x04²+1d¬ªâ3" b"%\x7F|)¤G$„ÓÌ\r«W)" b"ïQSÊñKo§QZÏ·”_" b"‚\x19lJ\x0FBG¡Æ\x1CV¹Á‡¤" b"ƒiOßKÂG‰»5î\x109o" b"ƒšs¹L4C사ò‹íT¸å" b"ƒéª•\x08ÀKã•—†¥Ièlõ" b"ƒüƒ{ïêB\x19·‚t>Š§\v" b"„\x04ÈÊ\x1CLN,³p7³Ûc¨ý" b"…n0\x1C\flC\x04±\eÉÙ¸eaC" b""" †oŽ\n ìJO)©˜ûŒ<¯Î\x08 """ b"†Ä‰¶Ž:I]¿)Qø\x06sø'" b"‡W\x12„ª\x03G\eŽæ•.êÀW…" b"ˆ7Â?i×A’³<X®‰\x17d0" b"ˆ*§]xGá’OkfÜ8’S" b"ˆ \x066ËH•Œ¢µº\x18¹èU" b"ˆäÊ0¥\x1DK/Ÿ›¿‹d§d4" b"Š‡CeuuF,Žy\x1A@\x1FœvŠ" b"Š–ò•\tHJJ„Š`…ù™\x18–" b"Šó\x177"†C:…[n×À<Œ\x03" b"‹Dn\x1E×¹MСfàö¸†ãÚ" b"‹IŽ"f\x04NF¶Ü"̉…ô." b"Œ\x11/õÔI‘‡ZÖ\fëÞ<Ž" b"Œ´ÉTKÃH\x14¡çã@T\x1DÝ" b"Œè\x02]&\x19LÁ³\x1F\x05“\vwå" b"Ž¸ ûïjAk¨°VÙOÿô¦" b"ŽƒËWÜBA“\x12öPß\x0E7¼" b"ŽîX›±ôF\x14„\x03\x10Ž\x11õŸ\x03" b"CX·ÆìDF‰KÒÖ \vÞõ" b"K\x1D?ÒV@ÿµ¯SHãfÊ}" b".ßu?DE™Ø\x02\x13k\x08\x04" b"‘\x05ûìTÏLÒ ^Ì\x14@£6°" b"‘sýuhÜN·‚µ€‘Q5àI" b"‘»ü^]€NNŽ»ö>wD3J" b"’ø=>\x0FƒG¸±”æW9òJ" b"“dŽ\x1C¸GK\eœ&f AzUm" b"“q.™óªEM\x0Ee{:²\x10À" b"“ ßú6\x7FH׌å¯\x1A*å\x1CÙ" b"“°0\x10\\x1FCŽ¬Ú\x04!qÉ\r" b"•ÀÜ“Â\x16A\x1FÇìþòÅÙ" b"–\x03l|Q²J/´àÎ\x10ÏÞ\x02K" b"–%sÅ°#B\x16¾Aß\x15üÚ{x" b"—\x16zÅ÷´EV§Ý\x12³#Ä{h" b"—‘YN‰ÕIä¾Ò$\x02_Ý#*" b"—‘ÞäSœJ%œª›\eg@WÛ" b"˜lhX– A7’¢)ÏM½*\x1C" b"™2)\x14{kC «Ä3\x02v\x08|L" b"™X;”é\fCô™\x08ÃO£2¿'" b"™åä)\x17tF]«“ß\x01,9\x10" b""" ›W\n Ù‚ØHS“H½×Ü!\x13œ """ b"›oäy\x18>CŒ›âܨ@S©Ç" b"›‹npd½M¬·ÌÖ¿t·\x06¡" b"œ¡÷ù\x1DØF‡ \x14¥K\x00\x0EU…" b"Ö;Ù‰ABíªð¬\x16H*Õ™" b"ž"\x1Dyk˜B\x13™\f\x1Ex\x088S†" b"žb«·’xIp’o0tæ3 ú" b"Ÿ\rj}+Ø@P€M\x1E$>\x00\x11V" b"Ÿg5#J5N¨±» Áý§X´" b"Ÿug_ãÞJ; \x06\x12;`@¨þ" b"Ÿ’ròÀÂM¨ÊÇ¢\x03\x07“g" b"Ÿ ÈÌ“æLFó\x7Fʽ\x1Fã‰" b" C\x149ZmDʆÁŠ$\x1C@È<" b" †¿Ý\fZDµ”×ÝÅ]O\x1Dî" b" Ž6ž»¡M' \x00tR&ð¥\r" b" —)u[\x0EE\x12›GHÇJÇ¢o" b" WwK‚@9š¹®¯³ÜáÒ" b"£\x0FÛqi–K–ªIŒ/OY²œ" b"£G8\x06ÉD ]ɪ\x07C¹" b"¤‘žÐö\x12I%®U»ÃUY/S" b"¦\fÅB¨\x04Bnº=\x11a·¶¤a" b"§_$”ºÜEz‰\x00WmâL·Ù" b"§¥ÀI\rèG\x12‘\x12ÑüçL1Á" b"§çaÞ)IDÔ€\fY\x10Há`ª" b"¨KH\x12÷«Bù‚çÎ\x1FÍTOŸ" b"¨|'$ 3Jª é`ÌÛØ•†" b"¨ƒ+.×ÂEÍ™<¹æ&‘àZ" b"ª¤ðv,NŒ¥Ò\e\x1D6Úœc" b"ªp<FÞOò¼ÝïlY±×\x0F" b"«(ÂõEâ·ÝúòWO‘G" b"«Ø³pþBX”i/Ã\x1C¿ã—" b"¿Í™#‰CcŸ\x15°f}V=\v" b"®¢åE*pDé’”\x1Eö\x06ip" b"°à\x11\r3ÀGåž×¼ëhX€ì" b"±a„t¯£@,ˆ\x06mn¯Ò:ã" b"²‰jËÁO¸°˜ŽŒ\t\x1Aþ\x1A" b"´\x0E\x068ÁM8Œ\x19\x02Ǫ\x00Dt" b"´hÃœÛïIé†0~)þ4óq" b"µ\x06§—¸\x03K–ƒË²®¯¶jæ" b"µˆ»\x10\x08”Jm¸|g\x1CJ>5" b"¶QT¥yjK5—£‰c¼H\x18" b"¶‘\x08»“ÇM\x1Cª}XC¯\x08\x7F\x15" b"¶Ë*Ár÷Fˆ‚0\x10ÈnPs±" b"·¨g\x02)ßJ̽–ÀÉ_d:|" b""" ¸\x1DŽ!À\n @è‚Å2ûÙ\n 3ˆ """ b"¸Ž¤Y¶çA\x18”ì\x17ô^ÄŽÿ" b"¸é\x18Èð–H´c\x08\x18o#\x1Cj" b"¹Õ÷úÓ™N\vâÖ.–èJ4" b""" ºÐò\vÎ2Lꉟ^:òÕ\n b """ b"ºí½ÒÓ®Eª®¯ôÞYAá=" b"½\x00%™ŽæIû©\x172fdµ!" b"½\x1Dˆ\x13R€J\€\rÏ#¢ŠÝY" b"½ W—R¢KT¦”Û\r_»R" b"½“ܧœ¦E\x04›j!f,\x19P\x1C" b"¾¾9"^˜K@Ž\x0E€\x0FžMý" b"¾¿GP\x19\x04Hó¥\x1C¼°»\x18\tW" b"¾Å\x08v9MÛ‰\x13dï仦" b"¾üÔÍÜNB.¢JÃéÒ\fåx" b"¿\x01Qª/ûEÿ•©\x16èNéZ\r" b"¿Öc3Ù‹LŽ¾rd©\x1DtˆŠ" b"ÂS©/ñÍF-¥¦>1ÈeËô" b"¬¿ˆÛ{B%¿ž\x02¾F™Ûí" b"ÄÎN©^½Hwœw/Ñ0ŽÏ¬" b"Å‚ù™ûGÀ½ñþ®aè2û" b"Ååºk² ED¢´¬i¤!ý," b"Æžth<rD‚\x1C"«o&vk" b"ÆÚž´FÍK\x07\ey×39\x13!" b"Ç,Fä™ëIÅ¥Èæ4òõŸ\r" b"ÇvÏw@jI˼ÑM\x1C¯JB" b"ÈL $gIK¦Á\tÏ\x14t§û" b"ÈšZ€"ãN]€^ó\rÎM\x12i" b"ÈÛ- \x04MEAŽÏr‹Ð%Ii" b""" ÈÜK‹¡hFì¹\n \x05Œ–1r5 """ b""" É<ŒÁÝDF\x1A´q:þŽÊ\n . """ b"É[¯¾_MŠ“t¸§qû\x18h" b"Éʹ\x02m MF‰Þ‡°B 9" b"Ê¥«=ñ C?¥Rñ¸\x16Ã1Ô" b"Ëɳoû[F˜’\f"¦UÞµ¿" b"Ëó\,é*Oü´\x0Fo+\x0EÖF\x04" b"Ì\x04ÇžŽŽOyŽ;Nà0qœj" b"Ìðï¼ÍøK\v…YX\x08E\x05“i" b"Í/±L_mKõŠ8NOz\x14ô¢" b";´±;B\v¦\e8\x05(B©\x13" b"ÍúÃðHwIˆ©q÷u\x00ÍÕŽ" b"Ï:š!ªëMð³jhúçmïã" b"ÏkûYù\x00Lµ’Æ·6â~’P" b"ÏÎh\x08†<IÊ¢ý¿dw\x11¹O" b"ФãIJ=²÷¸yø`uJ" b"гö\x1F‰óD\x0F’Ð\x7FùÊïïº" b"ÐÄõÑ?O@\x11ŽŠ]5-"\fô" b"Ñ\x16Ñç\x1EoG£›n:ŽÉk‚~" b"Ò¢ÞN,¥OÇ£úÊ;÷l‡Ë" b"Ò½ŒH«ÎB\e¤‘…7\x19<íN" b"ÒÒ.b>ªF+–#–btÝ-" b"Ó\x0F\x18ÜûìJ¿…ÿH\x1FâÉ\vp" b"Ô\x1DÊœÃn@ýÉÖ¥{E\x06K" b"Ô–\x08ºÔ\fC#À\x12\x13ÐÚ\f " b"Õ\x05\x03.¶ÀHÙ»mèÇ\x19ñ(ì" b"ÕdG€ä$Np¹«FQ\x05\x1Cx%" b"Õ˜63²ñB_®‡æÜÅ(œ}" b"Õ¡ÊÜÒ}A|‹4\x10\x10Ó\x10C{" b"Õ¤ïÎc³NS¢Y¿ˆÖñRó" b"ÕƸ¾Îˆ@8¿È§·Qï±Î" b"Ö<(Ô\x0F|C× ›Üi¥ ú\x10" b"×;\x7F\x1E‰ýOѧk-}[(Y" b"Ø<°Âõ\x08Eý•c\x7F\x02U´ö¹" b"Ù”d\t\x1D#K2¡\é[»Ÿm" b"Ú\x03†\\fJö‘¹Ý7\x0Euí‚" b"ÚS\x10Ua\rN\f™nîØ\e}Ê—" b"ÚÝpÂÞSAô”Ç\x15Öî[Uç" b"Úñ9™Ê™Jz£ \x14ð·k\x1D" b"Ûµ§!4ùB0‡³gV^\rYá" b"Ü<÷ÛRWIYÖ> î\x16\x12" b"Üd"¸\x10VN••ç[Sw¢¬P" b"Ü´+\nYOÖ¶d¹˜˜é\x11\x7F" b"ÜÆŸÙnÅMœ€ˆ×ë~—›ü" b"ÜÈÜhX%ASšáƒ/O#&\x12" b"ÜéÝ;b\x10IyŠ\x02xß0&ïV" b"Ý]¿¢ˆK\x02·ê/tÔ_@Ž" b"Þ¡CH&\x16IȇwšèÑöLÜ" b"ß` íˆYF0»\x18bº¶˜\x07›" b""" àt…;ïqB´ºéÍ\x1C\n zT" """ b"à´YIá&L&—L\x13ïiê™f" b"á£|³\x0FBOŽ\x1Eéwúçìˆ" b"â\x18¹kè¢NZžÉtôrì5o" b"â\x1DŠˆßRH‰¼S\x1Eé¢0\Ï" b"âl„Áä\x01Ió–±ï_ŽH¼ó" b"ã]×iUšI‹¤eáŸK\x03" b"ã’|â©ã@Ì©<Ÿû(Ò9\x14" b"äuÀcoJå”\x002Ê;S\fü" b"ä—G\x14ÍŽH\e’÷{\x14\x18Åšã" b"åqLÇmjMq®\x1F[‚;\x1F-F" b"ê\x01\v¹\x07E”éý”g_Ï“" b"ê¬I\x04ŒÜO€¨æ´4!~ŒÇ" b"ë\x1EŒ‡XGM0–š\x13WJ€+W" b"ìLÍ\x01}\vJ;\x1Eœ†‡ß¥Ÿ" b"îô\x10–#G=´Hx%¨D[Á" b"ïŒ\x16”\x10FAþUi\x03bQ~" b"ðE\x1Dι\x00D\x0F‰fÄü2Âûí" b"ðœÕ@^FJ¾®S„ÖQ“=º" b"ñÉx¡·G]‰LûªëfÑÿ" b"ñÛÝÌ$ùN ©š{ëÉ"%" b"ò1 R‡¸@ý5Ï\t°Y§+" b"ò[m•\x1CŸL–‘\x13D\x02ø\f" b"ò\x05²q0DĘ\x1AH=QA÷" b"òþø\tM\x08BˆŠtWA\x03ê¹ò" b"óa\rþ@BE^£fˆÍ‹¿èÞ" b"õoÚ®¤ØC\x06–£z›µóì«" b""" ö^o¾¹\x1FD\x02½ìr\n H\x06æÍ """ b"÷\x07DS¨ôIwŸðÈ,_\x05|" b""" ø¨\t\n ätB˜°¤VHµ<Æ """ b"ú7\x0E¬ÖXM‘¼û{íõ&\x08·" b"ú”¢»£@D¨¯žXó“ÇM" b"úŸoÜ\x1A‚G"–}D\x16\mÂP" b"üw2ºQ¸M<“\x00q\x04\x0Eáÿì" b"ü}>lr„LÓ¡ó)Ã1ºó" b"üÐsy²„I²¿DºmšTNµ" b"ý\vB¦4©FË‘û¸\x17¤ööŽ" b"ýëk\x07f,C\x12¼ôÆ\t¹½D" b"ÿ»L}\x1AºMŽß‰ÀUK9Ñ" ] |
||||||||||||||||||||||||
|
3.88 ms (5.00%) |
4 |
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%" "%|23fb8ee9b40545a9b9d44ddd9b5c6b27|%" 6 true true ] |
||||||||||||||||||||||||
|
3.32 ms (4.28%) |
1 |
-- product-detail-route::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`.`type` as `product.type`, `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`, COALESCE(`product`.`swag_customized_products_template_id`, `product.parent`.`swag_customized_products_template_id`) as `product.swagCustomizedProductsTemplateId`, COALESCE(`product`.`swag_customized_products_template_version_id`, `product.parent`.`swag_customized_products_template_version_id`) as `product.swagCustomizedProductsTemplateVersionId`, `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`.`created_at` as `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` as `product.manufacturer.updatedAt`, `product.manufacturer.media`.`id` as `product.manufacturer.media.id`, `product.manufacturer.media`.`user_id` as `product.manufacturer.media.userId`, `product.manufacturer.media`.`media_folder_id` as `product.manufacturer.media.mediaFolderId`, `product.manufacturer.media`.`mime_type` as `product.manufacturer.media.mimeType`, `product.manufacturer.media`.`file_extension` as `product.manufacturer.media.fileExtension`, `product.manufacturer.media`.`uploaded_at` as `product.manufacturer.media.uploadedAt`, `product.manufacturer.media`.`file_name` as `product.manufacturer.media.fileName`, `product.manufacturer.media`.`file_size` as `product.manufacturer.media.fileSize`, `product.manufacturer.media`.`media_type` as `product.manufacturer.media.mediaTypeRaw`, `product.manufacturer.media`.`meta_data` as `product.manufacturer.media.metaData`, `product.manufacturer.media`.`config` as `product.manufacturer.media.config`, `product.manufacturer.media`.`path` as `product.manufacturer.media.path`, `product.manufacturer.media`.`private` as `product.manufacturer.media.private`, `product.manufacturer.media`.`thumbnails_ro` as `product.manufacturer.media.thumbnailsRo`, `product.manufacturer.media`.`file_hash` as `product.manufacturer.media.fileHash`, `product.manufacturer.media`.`created_at` as `product.manufacturer.media.createdAt`, `product.manufacturer.media`.`updated_at` as `product.manufacturer.media.updatedAt`, `product.manufacturer.media.translation.title`, `product.manufacturer.media.translation.title` as `product.manufacturer.media.title`, `product.manufacturer.media.translation.alt`, `product.manufacturer.media.translation.alt` as `product.manufacturer.media.alt`, `product.manufacturer.media.translation.customFields`, `product.manufacturer.media.translation.customFields` as `product.manufacturer.media.customFields`, `product.manufacturer.translation.name`, `product.manufacturer.translation.name` as `product.manufacturer.name`, `product.manufacturer.translation.link`, `product.manufacturer.translation.link` as `product.manufacturer.link`, `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`, (SELECT GROUP_CONCAT(HEX(`product.properties.mapping`.`property_group_option_id`) SEPARATOR '||') FROM `product_property` `product.properties.mapping` WHERE `product.properties.mapping`.`product_id` = `product`.`properties` ) as `product.properties.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`, `product.swagCustomizedProductsTemplate`.`id` as `product.swagCustomizedProductsTemplate.id`, `product.swagCustomizedProductsTemplate`.`version_id` as `product.swagCustomizedProductsTemplate.versionId`, `product.swagCustomizedProductsTemplate`.`parent_version_id` as `product.swagCustomizedProductsTemplate.parentVersionId`, `product.swagCustomizedProductsTemplate`.`internal_name` as `product.swagCustomizedProductsTemplate.internalName`, `product.swagCustomizedProductsTemplate`.`active` as `product.swagCustomizedProductsTemplate.active`, `product.swagCustomizedProductsTemplate`.`step_by_step` as `product.swagCustomizedProductsTemplate.stepByStep`, `product.swagCustomizedProductsTemplate`.`confirm_input` as `product.swagCustomizedProductsTemplate.confirmInput`, `product.swagCustomizedProductsTemplate`.`options_auto_collapse` as `product.swagCustomizedProductsTemplate.optionsAutoCollapse`, `product.swagCustomizedProductsTemplate`.`decision_tree` as `product.swagCustomizedProductsTemplate.decisionTree`, `product.swagCustomizedProductsTemplate`.`media_id` as `product.swagCustomizedProductsTemplate.mediaId`, `product.swagCustomizedProductsTemplate`.`created_at` as `product.swagCustomizedProductsTemplate.createdAt`, `product.swagCustomizedProductsTemplate`.`updated_at` as `product.swagCustomizedProductsTemplate.updatedAt`, `product.swagCustomizedProductsTemplate.translation.displayName`, `product.swagCustomizedProductsTemplate.translation.displayName` as `product.swagCustomizedProductsTemplate.displayName`, `product.swagCustomizedProductsTemplate.translation.description`, `product.swagCustomizedProductsTemplate.translation.description` as `product.swagCustomizedProductsTemplate.description`, `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 `swag_customized_products_template` `product.swagCustomizedProductsTemplate` ON `product`.`swagCustomizedProductsTemplate` = `product.swagCustomizedProductsTemplate`.`id` AND IFNULL(`product`.`swag_customized_products_template_version_id`, `product.parent`.`swag_customized_products_template_version_id`) = `product.swagCustomizedProductsTemplate`.`version_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 `media` `product.manufacturer.media` ON `product.manufacturer`.`media_id` = `product.manufacturer.media`.`id` LEFT JOIN (SELECT `product.manufacturer.translation`.`product_manufacturer_id`, `product.manufacturer.translation`.`product_manufacturer_version_id`, `product.manufacturer.translation`.`link` as `product.manufacturer.translation.link`, `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.manufacturer.media.translation`.`media_id`, `product.manufacturer.media.translation`.`alt` as `product.manufacturer.media.translation.alt`, `product.manufacturer.media.translation`.`title` as `product.manufacturer.media.translation.title`, `product.manufacturer.media.translation`.`custom_fields` as `product.manufacturer.media.translation.customFields` FROM `media_translation` `product.manufacturer.media.translation` WHERE `product.manufacturer.media.translation`.`language_id` = ?) `product.manufacturer.media.media_translation` ON `product.manufacturer.media.media_translation`.`media_id` = `product.manufacturer.media`.`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` LEFT JOIN (SELECT `product.swagCustomizedProductsTemplate.translation`.`swag_customized_products_template_id`, `product.swagCustomizedProductsTemplate.translation`.`swag_customized_products_template_version_id`, `product.swagCustomizedProductsTemplate.translation`.`display_name` as `product.swagCustomizedProductsTemplate.translation.displayName`, `product.swagCustomizedProductsTemplate.translation`.`description` as `product.swagCustomizedProductsTemplate.translation.description` FROM `swag_customized_products_template_translation` `product.swagCustomizedProductsTemplate.translation` WHERE `product.swagCustomizedProductsTemplate.translation`.`language_id` = ?) `product.swagCustomizedProductsTemplate.swag_customized_products_template_translation` ON `product.swagCustomizedProductsTemplate.swag_customized_products_template_translation`.`swag_customized_products_template_id` = `product.swagCustomizedProductsTemplate`.`id` AND `product.swagCustomizedProductsTemplate.swag_customized_products_template_translation`.`swag_customized_products_template_version_id` = `product.swagCustomizedProductsTemplate`.`version_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"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01œ®\x00äŽp¼»»Äº98¬\" ] |
||||||||||||||||||||||||
|
3.31 ms (4.27%) |
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/0fbf4ca551d34eb492b7ba7720fe43fa" "/navigation/5773ee68f8034f5e961a30ca3285c6ca" "/navigation/6c594cdc46014175811a0d382d6322d4" "/navigation/bebf4750190448f3a51cbcb0bb180957" "/navigation/568b38937bbf49f8906026d54ee17927" "/navigation/9fa0c8cc93e64c4690f37fcabd1fe389" "/navigation/83fc837befea4219b782743e8aa75c76" "/navigation/a086bfdd0c5a44b594d7ddc55d4f1dee" "/navigation/0196b41d506c70e6bcf8176d97c74777" "/navigation/da531055610d4e0c996eeed81b7dca97" "/navigation/257a62988fdc46f190324ea55c2a70a1" "/navigation/da03ad865c0c4af691b9dd370e75ed82" "/navigation/7aba9619cfeb4aae97f1544dfe2fee03" "/navigation/1f8edc2ade294ec483ec5073e240ee39" "/navigation/0069c65e143a456d9816e5a722112543" "/navigation/abd8b37081fe425894692fc31cbfe397" "/navigation/3fbe1b77942343ce86941f3ebfd67ff7" "/navigation/76722a3eea174f44b7c118bada2a0a09" "/navigation/40f3dfd7aa494e97ba122da32bb0fefb" "/navigation/e3927ce2a9e340cca93c9ffb28d23914" "/navigation/e5714cc76d6a4d71ae1f5b823b1f2d46" "/navigation/b2896acbc1814fb8b0988e8c091afe1a" "/navigation/0a89610bab9b494c8400e115273b73f9" "/navigation/b40e063881c14d388c1902c7aa004474" "/navigation/2bcd28361bf844a1b4caa7e08e140d59" "/navigation/d63c28d40f7c43d7a09bdc69a5a0fa10" "/navigation/a04314395a6d44ca86c18a241c40c83c" "/navigation/2c38d2beb53b4ebc8ec0cbfbb9e56465" "/navigation/ffbb4c7d1aba4d8daddf89c0554b39d1" "/navigation/2fbd7f5ec453425da19756d8d24abfde" "/navigation/8c112ff581d44991875ad60cebde3c8e" "/navigation/747deee72c60471baac1ddf401ad2dff" "/navigation/e21d8a88df524889bc531ee9a2305ccf" "/navigation/4d61a71c114e4a45b521e799aceb9a4f" "/navigation/2aabf7feee854b2d990daa8faade4560" "/navigation/7998dd7ac360429d89a43d3dd54ca493" "/navigation/37002e90d3ac42af990bb907c0226f62" "/navigation/ef8c1694104641fe818155690362517e" "/navigation/df60a0ed88594630bb1862bab698079b" "/navigation/44deb078a46f45538608398d1990fb5c" "/navigation/93712e99f3aa454d8f0e657b3ab210c0" "/navigation/fdeb6b07662c4312bc81f4c609b9bd44" "/navigation/7693449e6d1048978462c50861d1f795" "/navigation/d49608bad40c43238fc01213d0da0ca0" "/navigation/7cca15973da949b3b5cb8662656c27f6" "/navigation/bd1d881352804a5c800dcf23a28add59" "/navigation/08b29f4dfdf548a79b03a2357e2bf7e4" "/navigation/83694fdf4bc247899d8fbb35ee10396f" "/navigation/b8e918c8f0964890b46308186f231c6a" "/navigation/d2a2de4e2ca54fc7a3faca3bf76c87cb" "/navigation/4f1f0eaecd134885a538cf227aac13d7" "/navigation/6c0f6e23338b49a88fa9acf5616ed71d" "/navigation/8b498e2266044e46b6dc22cc8985f42e" "/navigation/59b2727d915d48ed88dab125c0513e9f" "/navigation/bad0f20bce324cea899f5e3af2d50a62" "/navigation/0a0f1ce7421743be882dadd0f8976327" "/navigation/fc7732ba51b84d3c930071040ee1ffec" "/navigation/d505032eb6c048d9bb6de8c719f128ec" "/navigation/19074b48981947088cd3fd38c7aee2ba" "/navigation/3bfd03b1d03b4a88b2320f9f6586370e" "/navigation/3897a5d1eb0d49faaeff22e8267a2caf" "/navigation/cbf35c2ce92a4ffcb40f6f2b0ed64604" "/navigation/32e9dd14f6824b5db856f11a7a975470" "/navigation/8404c8ca1c4c4e2cb37037b3db63a8fd" "/navigation/089554cf015e410aa3c566723bc0c9d4" "/navigation/9ca1f7f91dd84687a014a54b000e5585" "/navigation/7f1a05011f684ba9bba5d26347fed84c" "/navigation/cf6bfb59f9004cb592c6b736e27e9250" "/navigation/82ad196c4a0f4247a1c61c56b9c187a4" "/navigation/b88ea459b6e7411894ec17f45ec48eff" "/navigation/30dd6328604241a5ad3c4e1ba89f479b" "/navigation/178ad390374e40ffa86989d764ade7ec" "/navigation/17e97ed5a32242259ec1409874b83d46" "/navigation/2712f32fcb2c475a9c9462a9b3e7e3c9" "/navigation/c58f82f999fb47c0bdf1feae61e832fb" "/navigation/1d26846a92ea44459a29e0f7312b13e1" "/navigation/2019e1e090c243368fbccc2a6bbd7d79" "/navigation/f1dbddcc24f94e20a0a99a7bebc92225" "/navigation/dadd70c2de5341f494c715d6ee5b55e7" "/navigation/bebe39225e984b408ead0e800f9e4dfd" "/navigation/34b1aaa70e074fcfa78acdd0844b8fa5" "/navigation/191604645e1548f099e07f74a32edd72" "/navigation/09fdf4fea79f4d8b81b3bfc95046d008" "/navigation/700320901056459f9d43362fcfb96eeb" "/navigation/075cd5f6fc264d429b080b7ef8688625" "/navigation/e0b45949e1264c26974c13ef69ea9966" "/navigation/d30f18dcfbec4abf85ff481fe2c90b70" "/navigation/bd20579752a24b54a694db5c725fbb52" "/navigation/14db1500709d49b3b9d98de5fc3c1b96" "/navigation/f0451dceb900440f8966c4fc32c2fbed" "/navigation/d0b3f61f89f3440f92d07ff9caefefba" "/navigation/b6cb2ac172f74688823010c86e5073b1" "/navigation/9f75675fe3de4a3ba006123b6040a8fe" "/navigation/49155aff44f447ddbb6ea23a2c8cee4d" "/navigation/b1618474afa3402c88066d6eafd23ae3" "/navigation/7badb6fbad7148d4a2e2a7a61dfefb23" "/navigation/7d96a4cc874a4a7980fc4466fdb1cdba" "/navigation/4e263a81a98a4e268b606423eabfe290" "/navigation/11f88442af344ec59908fd40c1b0da1a" "/navigation/8a96f29509484a4a848a6085f9991896" "/navigation/712d3fe0630549e68bef407111e5d2de" "/navigation/9f0d6a7d2bd84050804d1e243e001156" "/navigation/559542194ef948e086f05c5cc196dcb5" "/navigation/1b62156ac8cb43afb0ba0fd0d7936282" "/navigation/c84ca02467494ba690c109cf1474a7fb" "/navigation/5dc4df5f3f53443fa79a6c7f7f72daf6" "/navigation/489ccded076947af88cec3cdc89c557d" "/navigation/645908525aa140d5aff222dd0782f24d" "/navigation/93a0dffa367f48d78ce5af1a2ae51cd9" "/navigation/745c25a9abbd46feb468cc3a8372172a" "/navigation/c4ce4ea95ebd48779c772fd1308dcfac" "/navigation/7654ab52094942f0a1d53cd5b0a2a6d0" "/navigation/44de234f429e4aa68860866fbd7c866b" "/navigation/986c685896a0413792a229cf4dbd2a1c" "/navigation/6baa3ed4e5dc41809f099a1f5b2d4dc4" "/navigation/8a8743657575462c8e791a401f9c768a" "/navigation/dcc8dc68582541539ae1832f4f232612" "/navigation/66d0344e9192432ea0268ed9b3276349" "/navigation/8af317372286433a855b6ed7c03c8c03" "/navigation/e218b96be8a24e5a9ec974f472ec356f" "/navigation/4d04a8e20436449486ba57e42b650c31" "/navigation/b69108bb93c74d1caa7d5843af087f15" "/navigation/bfd66333d98b4c8ebe7264a91d74888a" "/navigation/dcb42b5c6e594fd6b664b99898e9117f" "/navigation/36136262ad414fa2b8665dd3b935e82e" "/navigation/51ae547b24c84f8192078ce5fcc505d3" "/navigation/ccf0efbccdf84b0b8559580845059369" "/navigation/2c6cc9def3f649e3b897184742d17102" "/navigation/93648e1cb8474b1b9c2666a0417a556d" "/navigation/7cafb50f1cd9437182a9d74236504d21" "/navigation/f7074453a8f449779ff0c82c5f059d7c" "/navigation/308c09db668d41579cddcf12032a0ddb" "/navigation/e4758fc0636f4ae5940032ca3b530cfc" "/navigation/01989d57056671d7a8f1a6e3a8c0c0c1" "/navigation/902edfad753f44459d99d802136b0804" "/navigation/55a5694430334a13b4792a5085997e6b" "/navigation/0c56d68988c94cdd8e990c8ce5cdcc93" "/navigation/42984d56fba0472d9ce10169ecce9f30" "/navigation/aaad703c46de4ff2bcddef6c59b1d70f" "/navigation/15bed13fd1de4595b38d3856d3474da1" "/navigation/1015f05c0c964ee6bd78d54c4f5caed7" "/navigation/b0e0110d33c047e59ed7bceb685880ec" "/navigation/866f8d0aec4a4f29a998fb8c3cafce08" "/navigation/32badc2265fd456aa6d32759fad9a405" "/navigation/19267761ad12406b9eff24e9dee3ae72" "/navigation/dc3cf7db525749599d8fd63ea0ee1612" "/navigation/839a73b94c3443ec82acf28bed54b8e5" "/navigation/b468c39cdbef49e986307e29fe34f371" "/navigation/5794ac7ee96845dd8b4ee5951e65edff" "/navigation/018ba8d79d877ff1acbda813bcaeb8bd" "/navigation/9e62abb792784970926f3074e633a0fa" "/navigation/0d5e8bc187544876a91372720d7b1fc4" "/navigation/2246580657dc40cbaf6a3ceffe1ee856" "/navigation/9b8b6e7064bd4dacb7ccd6bf74b706a1" "/navigation/cd2fb14c5f6d4bf58a384e4f7a14f4a2" "/navigation/6aeeabb0ce2145d9a65ed577d41a6b9b" "/navigation/56b8c3e540a04620b45d5bf5c9d89ff2" "/navigation/a75f2494badc457a8900576de24cb7d9" "/navigation/8f4b1d3fd25640ffb5af5348e366ca7d" "/navigation/18e60a3c8f704cdc8c24b5164971d589" "/navigation/a0ad57774b8240399ab9aeafb3dce1d2" "/navigation/3e77292a953d4311b854f6fb0573670a" "/navigation/8eee589bb1f446148403108d11f59f03" "/navigation/f56fdaaea4d8430696a37a9bb5f3ecab" "/navigation/4b88beda197a4e229bcf00c5c2b7f4ce" "/navigation/0b6f8e8590ae46f79426c9d6b08a900b" "/navigation/a3473806c99d4420815dc98faa0743b9" "/navigation/eb1e8c8758474d30969a13574a802b57" "/navigation/eaac49048cdc4f80a8e6b434217e8cc7" "/navigation/d5a1cadcd27d417c8b341010d310437b" "/navigation/64d64f658b9947cbb2919f6dc1fd762f" "/navigation/54255a30845e4b0586b5306893e87618" "/navigation/70e97c37e89d4f249c2d3cbb4be6175c" "/navigation/f25b6d951c9f4c96ad91138f4402f80c" "/navigation/fa9f6fdc1a824722967d44165c6dc250" "/navigation/d116d1e71e6f47a39b6e3a8dc96b827e" "/navigation/a60cc542a804426eba3d1161b7b6a461" "/navigation/a09729755b0e45129b4748c74ac7a26f" "/navigation/aea2e5452a7044e992941ef60669ad70" "/navigation/018bb8b492f3792281f3b07b745c64b5" "/navigation/87571284aa03471b8ee6952eeac05785" "/navigation/dbb5a72134f9423087b367565e0d59e1" "/navigation/a84b4812f7ab42f982e7ce1fcd544f9f" "/navigation/76a2f25199d64fb59e671117cf6aa126" "/navigation/018bb8b434b7748e842e2cce3ce1c2b5" "/navigation/bec5089d76394ddb891364ef8fe4bba6" "/navigation/dcc69fd96ec54d9c8088d7eb7e979bfc" "/navigation/dc6422b810564e9595e75b5377a2ac50" "/navigation/d2d22e623eaa462b9623968f6274dd2d" "/navigation/1afdf443f58642f2b39f42bd383e3013" "/navigation/3d2bc6355a21401abf21db6f730d84d7" "/navigation/f8a8090ae4744298adb0a45648b53cc6" "/navigation/74ab00350061497696b5efd41679c4c6" "/navigation/426fd5cc1fa140d2a1465e5e909624aa" "/navigation/4fbeb06141f84e0fb2b888b77a80d99d" "/navigation/c9cab9026d204d4689de879db0422039" "/navigation/12dbbb1f54a446bdac0e8a8c6dec45cf" "/navigation/3a6a18f4df1049fd954cfc9c7de51ac5" "/navigation/f3610dfe4042455ea36688cd8bbfe8de" "/navigation/99e5e4291774465dab93c39f012c3910" "/navigation/3f44bb0c03f1415b850932f9549c4b55" "/navigation/ec4ccd017d0b4a3b8f1e9c8687dfa59f" "/navigation/6f1ab97a9baa4a9bb38b6d82496a3149" "/navigation/284ed12680e24ea3baccd646ef8eed9e" "/navigation/cbc9b36ffb5b4698920c22a655deb5bf" "/navigation/d83cb0c2f50845fd95637f0255b4f6b9" "/navigation/5438c6f5837d420c99a24e48e0056b9f" "/navigation/96036c7c51b24a2fb4e0ce10cfde024b" "/navigation/15a2352f5a604af19210d57065f37066" "/navigation/322eee2a8a804c4da8a142127d6665ef" "/navigation/31f93a0824e64d4aac37af80b27d1e4c" "/navigation/97167ac5f7b44556a7dd12b323c47b68" "/navigation/0023d912e3df4e71a01b2d1ac9505e34" "/navigation/baedbdd2d3ae45aaaeaff4de5941e13d" "/navigation/a7e761de294944d4800c591048e160aa" "/navigation/d2bd8c48abce421ba4918537193ced4e" "/navigation/b588bb1008944a6db87c671c4a3e358f" "/navigation/5e859aba033e4e0abd78353ef89ea181" "/navigation/6b38e8d4ee934db1b5c23690998baf25" "/navigation/9791594e89d549e4bed224025fdd232a" "/navigation/357668be40d2494db9cffa89b8e59df8" "/navigation/81257f7c29a4472484d3cc0dabad5729" "/navigation/888f2aa75d7847e1924f6b66dc389253" "/navigation/0196b41e1d8a7de0b917c84aec7e2274" "/navigation/0196b41e2e0d7e7eaa2b0831469dfb5d" "/navigation/0196b41e03217206951e8f28d817c9d6" "/navigation/0196b41e47e47085b0b44b56d6fab954" "/navigation/618e99a46ef54ba287db5b1bff5712e7" "/navigation/b81d8d21c00a40e882c532fbd90a3388" "/navigation/5dce58cfde68453980115d159da2e761" "/navigation/5330d8a5c81744cabf2c0cce34c23480" "/navigation/3853b3999850435ab5e87f4b00af9274" "/navigation/46f864b8c0844bb5bf69bf3f2f0f55a7" "/navigation/cc04c79e8e8e4f798e3b4ee030719c6a" "/navigation/8f4358b7c6ec4446894bd2d6200bdef5" "/navigation/09c4be444ca947d78adc41f3049719a8" "/navigation/eef410968f23473db4487825a8445bc1" "/navigation/d5c6b8bece884038bfc8a7b751efb1ce" "/navigation/7ab12757a32745a4a3ed919afda4df74" "/navigation/78d4f5eb90904e5d9516a6ba03601d2f" "/navigation/0194ef4b74e9798b9307481fec65c959" "/navigation/018deefea31875e0961317168a540ab6" "/navigation/20439c902d4146b98e2c37e7227ce820" "/navigation/019135e27f8571728442b8a8cee64be0" "/navigation/3845f4c143cf416095754438bd32baa8" "/navigation/74cf939033994d05b18ec71325edff05" "/navigation/36b8ea79f2284defb341285d828c4e7a" "/navigation/befcd4cddc4e422ea24ac3e9d20ce578" "/navigation/018e7a19f9187ad9919b322c68b90f63" "/navigation/28991b294d94472f9029171babf5e53b" "/navigation/fd0b42a634a946cb91fbb817a4f6f68e" "/navigation/8cb4c9544bc34814a1e790e340541ddd" "/navigation/c6da9eb446cd4b078f1b79d733391321" "/navigation/2c45092282634c65a4ed72178c888c58" "/navigation/dce9dd3b621049798a0278df3026ef56" "/navigation/a8832b2ed7c245cd993cb9e62691e05a" "/navigation/0a8227124e054d7b8c2593d8002e68bd" "/navigation/4c834bade7b742489ee4a3c1770aab6e" "/navigation/3af8aa6895ff4dd2bce4ba17930a02a9" "/navigation/0194eed8279471e7984456c2a5039283" "/navigation/087795bf447442b89f168a32352e129b" "/navigation/354c4a652fef45cd914b53914d15a7c1" "/navigation/47a3d5fd8fbb4ba3b183ca54189bdc0a" "/navigation/83e9aa9508c04be3959786a549e86cf5" "/navigation/caa5ab3df120433fa552f1b816c331d4" "/navigation/3f7cf474c7a740209e92fcad234f1dbb" "/navigation/bd93dca79ca645049b6a21662c19501c" b"/»_ââšMpªXTÎ|ãâ\v" b"E\eeZ/SJj‡,|\x06o&%£" ] |
||||||||||||||||||||||||
|
2.30 ms (2.96%) |
1 |
-- product-detail-route::association::mainCategories::read SELECT `main_category`.`id` as `main_category.id`, `main_category`.`product_id` as `main_category.productId`, `main_category`.`product_version_id` as `main_category.productVersionId`, `main_category`.`category_id` as `main_category.categoryId`, `main_category`.`category_version_id` as `main_category.categoryVersionId`, `main_category`.`sales_channel_id` as `main_category.salesChannelId`, `main_category`.`created_at` as `main_category.createdAt`, `main_category`.`updated_at` as `main_category.updatedAt`, `main_category.category`.`id` as `main_category.category.id`, `main_category.category`.`version_id` as `main_category.category.versionId`, `main_category.category`.`parent_id` as `main_category.category.parentId`, `main_category.category`.`parent_version_id` as `main_category.category.parentVersionId`, `main_category.category`.`after_category_id` as `main_category.category.afterCategoryId`, `main_category.category`.`after_category_version_id` as `main_category.category.afterCategoryVersionId`, `main_category.category`.`media_id` as `main_category.category.mediaId`, `main_category.category`.`display_nested_products` as `main_category.category.displayNestedProducts`, `main_category.category`.`auto_increment` as `main_category.category.autoIncrement`, `main_category.category`.`level` as `main_category.category.level`, `main_category.category`.`path` as `main_category.category.path`, `main_category.category`.`child_count` as `main_category.category.childCount`, `main_category.category`.`type` as `main_category.category.type`, `main_category.category`.`product_assignment_type` as `main_category.category.productAssignmentType`, `main_category.category`.`visible` as `main_category.category.visible`, `main_category.category`.`active` as `main_category.category.active`, `main_category.category`.`cms_page_id` as `main_category.category.cmsPageId`, `main_category.category`.`cms_page_version_id` as `main_category.category.cmsPageVersionId`, `main_category.category`.`product_stream_id` as `main_category.category.productStreamId`, `main_category.category`.`custom_entity_type_id` as `main_category.category.customEntityTypeId`, `main_category.category`.`created_at` as `main_category.category.createdAt`, `main_category.category`.`updated_at` as `main_category.category.updatedAt`, `main_category.category.translation.name`, `main_category.category.translation.name` as `main_category.category.name`, `main_category.category.translation.breadcrumb`, `main_category.category.translation.breadcrumb` as `main_category.category.breadcrumb`, `main_category.category.translation.slotConfig`, `main_category.category.translation.slotConfig` as `main_category.category.slotConfig`, `main_category.category.translation.linkType`, `main_category.category.translation.linkType` as `main_category.category.linkType`, `main_category.category.translation.internalLink`, `main_category.category.translation.internalLink` as `main_category.category.internalLink`, `main_category.category.translation.externalLink`, `main_category.category.translation.externalLink` as `main_category.category.externalLink`, `main_category.category.translation.linkNewTab`, `main_category.category.translation.linkNewTab` as `main_category.category.linkNewTab`, `main_category.category.translation.description`, `main_category.category.translation.description` as `main_category.category.description`, `main_category.category.translation.metaTitle`, `main_category.category.translation.metaTitle` as `main_category.category.metaTitle`, `main_category.category.translation.metaDescription`, `main_category.category.translation.metaDescription` as `main_category.category.metaDescription`, `main_category.category.translation.keywords`, `main_category.category.translation.keywords` as `main_category.category.keywords`, `main_category.category.translation.customFields`, `main_category.category.translation.customFields` as `main_category.category.customFields` FROM `main_category` LEFT JOIN `category` `main_category.category` ON `main_category`.`category_id` = `main_category.category`.`id` AND `main_category`.`category_version_id` = `main_category.category`.`version_id` LEFT JOIN (SELECT `main_category.category.translation`.`category_id`, `main_category.category.translation`.`category_version_id`, `main_category.category.translation`.`breadcrumb` as `main_category.category.translation.breadcrumb`, `main_category.category.translation`.`name` as `main_category.category.translation.name`, `main_category.category.translation`.`custom_fields` as `main_category.category.translation.customFields`, `main_category.category.translation`.`slot_config` as `main_category.category.translation.slotConfig`, `main_category.category.translation`.`link_type` as `main_category.category.translation.linkType`, `main_category.category.translation`.`internal_link` as `main_category.category.translation.internalLink`, `main_category.category.translation`.`external_link` as `main_category.category.translation.externalLink`, `main_category.category.translation`.`link_new_tab` as `main_category.category.translation.linkNewTab`, `main_category.category.translation`.`description` as `main_category.category.translation.description`, `main_category.category.translation`.`meta_title` as `main_category.category.translation.metaTitle`, `main_category.category.translation`.`meta_description` as `main_category.category.translation.metaDescription`, `main_category.category.translation`.`keywords` as `main_category.category.translation.keywords` FROM `category_translation` `main_category.category.translation` WHERE `main_category.category.translation`.`language_id` = ?) `main_category.category.category_translation` ON `main_category.category.category_translation`.`category_id` = `main_category.category`.`id` AND `main_category.category.category_translation`.`category_version_id` = `main_category.category`.`version_id` WHERE (`main_category`.`sales_channel_id` = ? AND (`main_category`.`product_id` IN (?)))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"E\eeZ/SJj‡,|\x06o&%£" b"\x01œ®\x00äŽp¼»»Äº98¬\" ] |
||||||||||||||||||||||||
|
1.87 ms (2.41%) |
1 |
-- product::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"\t{_ÙÆCë‡K\x1D³…Iˆz" b"$õ„ ÁBIv€»—íA=hë" b"²à„ú\x1EF¸Ò°ü&‹XÑ" b"Î:\x03\fÛäEÁ·iÈbÞx#\x04" ] |
||||||||||||||||||||||||
|
1.33 ms (1.71%) |
1 |
-- product-detail-route::find-best-variant::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`.`parent_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` <=> ?)))) ORDER BY `product`.`available` DESC, IFNULL((ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) + 0.0))) as DECIMAL(30, 20)), 2)) * 100, 0) / 100), (ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) + 0.0))) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)) ASC LIMIT 1
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01œ®\x00äŽp¼»»Äº98¬\" 10 b"E\eeZ/SJj‡,|\x06o&%£" true b"\x01”ùYW6~Š©vóä}0Ê‹" b"OÒPòý}BÖ„¿Ÿ\x07ÖšÞ " b"Ó´Û–9üAý©ü_\f27~" null b"\x01”ùYW6~Š©vóä}0Ê‹" b"OÒPòý}BÖ„¿Ÿ\x07ÖšÞ " b"Ó´Û–9üAý©ü_\f27~" null null ] |
||||||||||||||||||||||||
|
1.26 ms (1.62%) |
5 |
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"\x01”ùYW6~Š©vóä}0Ê‹" b"OÒPòý}BÖ„¿Ÿ\x07ÖšÞ " b"Ó´Û–9üAý©ü_\f27~" null b"Ÿ ÈÌ“æLFó\x7Fʽ\x1Fã‰" b"ÒÒ.b>ªF+–#–btÝ-" ] |
||||||||||||||||||||||||
|
1.13 ms (1.46%) |
3 |
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"Ÿ ÈÌ“æLFó\x7Fʽ\x1Fã‰" b"ÒÒ.b>ªF+–#–btÝ-" ] |
||||||||||||||||||||||||
|
1.09 ms (1.41%) |
1 |
-- product-cross-selling-route::search-ids SELECT `product_cross_selling`.`id` FROM `product_cross_selling` LEFT JOIN `product` `product_cross_selling.product` ON `product_cross_selling`.`product_id` = `product_cross_selling.product`.`crossSellings` AND `product_cross_selling`.`product_version_id` = `product_cross_selling.product`.`version_id` LEFT JOIN `product` `product_cross_selling.product.parent` ON `product_cross_selling.product`.`parent_id` = `product_cross_selling.product.parent`.`id` AND `product_cross_selling.product`.`parent_version_id` = `product_cross_selling.product.parent`.`version_id` WHERE (`product_cross_selling.product`.`id` = ? AND `product_cross_selling`.`active` = ?) ORDER BY `product_cross_selling`.`position` ASC
Parameters:
[ b"\x01œ®\x00äŽp¼»»Äº98¬\" 1 ] |
||||||||||||||||||||||||
|
1.04 ms (1.34%) |
1 |
-- product-detail-route::association::reviewSummaries::read SELECT `product_review_summary`.`id` as `product_review_summary.id`, `product_review_summary`.`product_id` as `product_review_summary.productId`, `product_review_summary`.`product_version_id` as `product_review_summary.productVersionId`, `product_review_summary`.`sales_channel_id` as `product_review_summary.salesChannelId`, `product_review_summary`.`created_at` as `product_review_summary.createdAt`, `product_review_summary`.`updated_at` as `product_review_summary.updatedAt`, `product_review_summary.translation.summary`, `product_review_summary.translation.summary` as `product_review_summary.summary`, `product_review_summary.translation.visible`, `product_review_summary.translation.visible` as `product_review_summary.visible` FROM `product_review_summary` LEFT JOIN (SELECT `product_review_summary.translation`.`product_review_summary_id`, `product_review_summary.translation`.`summary` as `product_review_summary.translation.summary`, `product_review_summary.translation`.`visible` as `product_review_summary.translation.visible` FROM `product_review_summary_translation` `product_review_summary.translation` WHERE `product_review_summary.translation`.`language_id` = ?) `product_review_summary.product_review_summary_translation` ON `product_review_summary.product_review_summary_translation`.`product_review_summary_id` = `product_review_summary`.`id` WHERE ((`product_review_summary`.`product_id` IN (?)))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x01œ®\x00äŽp¼»»Äº98¬\" ] |
||||||||||||||||||||||||
|
1.01 ms (1.30%) |
4 |
SELECT translation_key, value FROM snippet WHERE snippet_set_id = ?
Parameters:
[
b"j\x13ȆÅmNK’/¤Ñ»\x1Dãµ"
]
|
||||||||||||||||||||||||
|
1.00 ms (1.29%) |
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"E\eeZ/SJj‡,|\x06o&%£" "dynamic-dynamix-md-95-mit-dzr-und-temperatur-sonde" "dynamic-dynamix-md-95-mit-dzr-und-temperatur-sonde/" ] |
||||||||||||||||||||||||
|
0.93 ms (1.20%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id = ? OR system_config.sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[
b"E\eeZ/SJj‡,|\x06o&%£"
]
|
||||||||||||||||||||||||
|
0.87 ms (1.12%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[] |
||||||||||||||||||||||||
|
0.83 ms (1.06%) |
1 |
-- product-detail-route::association::properties::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.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group.translation.name`, `property_group_option.group.translation.name` as `property_group_option.group.name`, `property_group_option.group.translation.description`, `property_group_option.group.translation.description` as `property_group_option.group.description`, `property_group_option.group.translation.position`, `property_group_option.group.translation.position` as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, `property_group_option.group.translation.customFields` as `property_group_option.group.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 `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`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.group.translation`.`property_group_id`, `property_group_option.group.translation`.`name` as `property_group_option.group.translation.name`, `property_group_option.group.translation`.`description` as `property_group_option.group.translation.description`, `property_group_option.group.translation`.`position` as `property_group_option.group.translation.position`, `property_group_option.group.translation`.`custom_fields` as `property_group_option.group.translation.customFields` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.`language_id` = ?) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` WHERE `property_group_option`.`id` IN (?, ?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x019>Ãy\x1E‡P9Ć[Ùì" b"\x01—iJä\x1F\x7FÑ…ñâ@Ó\x05|\x1C" b"ó\x01û†ÌÕL4®™\x06™¸†á²" ] |
||||||||||||||||||||||||
|
0.81 ms (1.05%) |
1 |
SELECT COUNT(DISTINCT `product_review`.`id`) as `review-count` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` WHERE (((`product_review`.`status` = ?) AND (`product_review.product`.`id` = ? OR `product_review.product`.`parent_id` = ?)))
Parameters:
[ true b"\x01œ®\x00äŽp¼»»Äº98¬\" b"\x01œ®\x00äŽp¼»»Äº98¬\" ] |
||||||||||||||||||||||||
|
0.69 ms (0.89%) |
3 |
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[ b"E\eeZ/SJj‡,|\x06o&%£" "ACdPxTP7e1xckRNMDkFJRTTFr2pHPvS5" ] |
||||||||||||||||||||||||
|
0.68 ms (0.88%) |
1 |
-- product-detail-route::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 NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ? AND `product`.`parent_id` <=> ?) 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"E\eeZ/SJj‡,|\x06o&%£" true true false null b"\x01”ùYW6~Š©vóä}0Ê‹" b"OÒPòý}BÖ„¿Ÿ\x07ÖšÞ " b"Ó´Û–9üAý©ü_\f27~" null b"\x01”ùYW6~Š©vóä}0Ê‹" b"OÒPòý}BÖ„¿Ÿ\x07ÖšÞ " b"Ó´Û–9üAý©ü_\f27~" null null b"\x01œ®\x00äŽp¼»»Äº98¬\" ] |
||||||||||||||||||||||||
|
0.67 ms (0.86%) |
2 |
-- 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.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"Ÿ ÈÌ“æLFó\x7Fʽ\x1Fã‰" b"ÒÒ.b>ªF+–#–btÝ-" ] |
||||||||||||||||||||||||
|
0.67 ms (0.86%) |
1 |
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`measurement_units` as `sales_channel.measurementUnits`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, (SELECT GROUP_CONCAT(HEX(`sales_channel.paymentMethods.mapping`.`payment_method_id`) SEPARATOR '||') FROM `sales_channel_payment_method` `sales_channel.paymentMethods.mapping` WHERE `sales_channel.paymentMethods.mapping`.`sales_channel_id` = `sales_channel`.`id` ) as `sales_channel.paymentMethods.id_mapping`, `sales_channel.country`.`id` as `sales_channel.country.id`, `sales_channel.country`.`iso` as `sales_channel.country.iso`, `sales_channel.country`.`position` as `sales_channel.country.position`, `sales_channel.country`.`active` as `sales_channel.country.active`, `sales_channel.country`.`shipping_available` as `sales_channel.country.shippingAvailable`, `sales_channel.country`.`iso3` as `sales_channel.country.iso3`, `sales_channel.country`.`display_state_in_registration` as `sales_channel.country.displayStateInRegistration`, `sales_channel.country`.`force_state_in_registration` as `sales_channel.country.forceStateInRegistration`, `sales_channel.country`.`check_vat_id_pattern` as `sales_channel.country.checkVatIdPattern`, `sales_channel.country`.`vat_id_required` as `sales_channel.country.vatIdRequired`, `sales_channel.country`.`vat_id_pattern` as `sales_channel.country.vatIdPattern`, `sales_channel.country`.`customer_tax` as `sales_channel.country.customerTax`, `sales_channel.country`.`company_tax` as `sales_channel.country.companyTax`, `sales_channel.country`.`postal_code_required` as `sales_channel.country.postalCodeRequired`, `sales_channel.country`.`check_postal_code_pattern` as `sales_channel.country.checkPostalCodePattern`, `sales_channel.country`.`check_advanced_postal_code_pattern` as `sales_channel.country.checkAdvancedPostalCodePattern`, `sales_channel.country`.`advanced_postal_code_pattern` as `sales_channel.country.advancedPostalCodePattern`, `sales_channel.country`.`default_postal_code_pattern` as `sales_channel.country.defaultPostalCodePattern`, `sales_channel.country`.`is_eu` as `sales_channel.country.isEu`, `sales_channel.country`.`created_at` as `sales_channel.country.createdAt`, `sales_channel.country`.`updated_at` as `sales_channel.country.updatedAt`, `sales_channel.country.translation.name`, `sales_channel.country.translation.name` as `sales_channel.country.name`, `sales_channel.country.translation.addressFormat`, `sales_channel.country.translation.addressFormat` as `sales_channel.country.addressFormat`, `sales_channel.country.translation.customFields`, `sales_channel.country.translation.customFields` as `sales_channel.country.customFields`, `sales_channel.language`.`id` as `sales_channel.language.id`, `sales_channel.language`.`parent_id` as `sales_channel.language.parentId`, `sales_channel.language`.`locale_id` as `sales_channel.language.localeId`, `sales_channel.language`.`translation_code_id` as `sales_channel.language.translationCodeId`, `sales_channel.language`.`name` as `sales_channel.language.name`, `sales_channel.language`.`active` as `sales_channel.language.active`, `sales_channel.language`.`custom_fields` as `sales_channel.language.customFields`, `sales_channel.language`.`created_at` as `sales_channel.language.createdAt`, `sales_channel.language`.`updated_at` as `sales_channel.language.updatedAt`, `sales_channel.language.locale`.`id` as `sales_channel.language.locale.id`, `sales_channel.language.locale`.`code` as `sales_channel.language.locale.code`, `sales_channel.language.locale`.`created_at` as `sales_channel.language.locale.createdAt`, `sales_channel.language.locale`.`updated_at` as `sales_channel.language.locale.updatedAt`, `sales_channel.language.locale.translation.name`, `sales_channel.language.locale.translation.name` as `sales_channel.language.locale.name`, `sales_channel.language.locale.translation.territory`, `sales_channel.language.locale.translation.territory` as `sales_channel.language.locale.territory`, `sales_channel.language.locale.translation.customFields`, `sales_channel.language.locale.translation.customFields` as `sales_channel.language.locale.customFields`, `sales_channel.translation.name`, `sales_channel.translation.name` as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, `sales_channel.translation.homeName` as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, `sales_channel.translation.customFields` as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN `country` `sales_channel.country` ON `sales_channel`.`country_id` = `sales_channel.country`.`id` LEFT JOIN `language` `sales_channel.language` ON `sales_channel`.`language_id` = `sales_channel.language`.`id` LEFT JOIN (SELECT `sales_channel.translation`.`sales_channel_id`, `sales_channel.translation`.`name` as `sales_channel.translation.name`, `sales_channel.translation`.`custom_fields` as `sales_channel.translation.customFields`, `sales_channel.translation`.`home_slot_config` as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.`home_enabled` as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.`home_name` as `sales_channel.translation.homeName`, `sales_channel.translation`.`home_meta_title` as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.`home_meta_description` as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.`home_keywords` as `sales_channel.translation.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.`language_id` = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` LEFT JOIN (SELECT `sales_channel.country.translation`.`country_id`, `sales_channel.country.translation`.`name` as `sales_channel.country.translation.name`, `sales_channel.country.translation`.`custom_fields` as `sales_channel.country.translation.customFields`, `sales_channel.country.translation`.`address_format` as `sales_channel.country.translation.addressFormat` FROM `country_translation` `sales_channel.country.translation` WHERE `sales_channel.country.translation`.`language_id` = ?) `sales_channel.country.country_translation` ON `sales_channel.country.country_translation`.`country_id` = `sales_channel.country`.`id` LEFT JOIN `locale` `sales_channel.language.locale` ON `sales_channel.language`.`locale_id` = `sales_channel.language.locale`.`id` LEFT JOIN (SELECT `sales_channel.language.locale.translation`.`locale_id`, `sales_channel.language.locale.translation`.`name` as `sales_channel.language.locale.translation.name`, `sales_channel.language.locale.translation`.`territory` as `sales_channel.language.locale.translation.territory`, `sales_channel.language.locale.translation`.`custom_fields` as `sales_channel.language.locale.translation.customFields` FROM `locale_translation` `sales_channel.language.locale.translation` WHERE `sales_channel.language.locale.translation`.`language_id` = ?) `sales_channel.language.locale.locale_translation` ON `sales_channel.language.locale.locale_translation`.`locale_id` = `sales_channel.language.locale`.`id` WHERE `sales_channel`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"E\eeZ/SJj‡,|\x06o&%£" ] |
||||||||||||||||||||||||
|
0.66 ms (0.85%) |
4 |
#cart-persister::load SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters:
[
"ACdPxTP7e1xckRNMDkFJRTTFr2pHPvS5"
]
|
||||||||||||||||||||||||
|
0.65 ms (0.85%) |
1 |
SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`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`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" false true "product_download" false true "product_download" b"\x01œÐÊ`qÀ\x04ÀѬ\x05\x0F{" ] |
||||||||||||||||||||||||
|
0.62 ms (0.80%) |
1 |
-- product-detail-route::association::media::read SELECT `product_media`.`id` as `product_media.id`, `product_media`.`version_id` as `product_media.versionId`, `product_media`.`product_id` as `product_media.productId`, `product_media`.`product_version_id` as `product_media.productVersionId`, `product_media`.`media_id` as `product_media.mediaId`, `product_media`.`position` as `product_media.position`, `product_media`.`custom_fields` as `product_media.customFields`, `product_media`.`created_at` as `product_media.createdAt`, `product_media`.`updated_at` as `product_media.updatedAt`, `product_media.media`.`id` as `product_media.media.id`, `product_media.media`.`user_id` as `product_media.media.userId`, `product_media.media`.`media_folder_id` as `product_media.media.mediaFolderId`, `product_media.media`.`mime_type` as `product_media.media.mimeType`, `product_media.media`.`file_extension` as `product_media.media.fileExtension`, `product_media.media`.`uploaded_at` as `product_media.media.uploadedAt`, `product_media.media`.`file_name` as `product_media.media.fileName`, `product_media.media`.`file_size` as `product_media.media.fileSize`, `product_media.media`.`media_type` as `product_media.media.mediaTypeRaw`, `product_media.media`.`meta_data` as `product_media.media.metaData`, `product_media.media`.`config` as `product_media.media.config`, `product_media.media`.`path` as `product_media.media.path`, `product_media.media`.`private` as `product_media.media.private`, `product_media.media`.`thumbnails_ro` as `product_media.media.thumbnailsRo`, `product_media.media`.`file_hash` as `product_media.media.fileHash`, `product_media.media`.`created_at` as `product_media.media.createdAt`, `product_media.media`.`updated_at` as `product_media.media.updatedAt`, `product_media.media.translation.title`, `product_media.media.translation.title` as `product_media.media.title`, `product_media.media.translation.alt`, `product_media.media.translation.alt` as `product_media.media.alt`, `product_media.media.translation.customFields`, `product_media.media.translation.customFields` as `product_media.media.customFields` FROM `product_media` LEFT JOIN `media` `product_media.media` ON `product_media`.`media_id` = `product_media.media`.`id` LEFT JOIN (SELECT `product_media.media.translation`.`media_id`, `product_media.media.translation`.`alt` as `product_media.media.translation.alt`, `product_media.media.translation`.`title` as `product_media.media.translation.title`, `product_media.media.translation`.`custom_fields` as `product_media.media.translation.customFields` FROM `media_translation` `product_media.media.translation` WHERE `product_media.media.translation`.`language_id` = ?) `product_media.media.media_translation` ON `product_media.media.media_translation`.`media_id` = `product_media.media`.`id` WHERE (`product_media`.`version_id` = ?) AND (((`product_media`.`product_id` IN (?)))) ORDER BY `product_media`.`position` ASC
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01œ®\x00äŽp¼»»Äº98¬\" ] |
||||||||||||||||||||||||
|
0.62 ms (0.80%) |
4 |
SELECT iso FROM snippet_set WHERE id = ?
Parameters:
[
b"j\x13ȆÅmNK’/¤Ñ»\x1Dãµ"
]
|
||||||||||||||||||||||||
|
0.62 ms (0.80%) |
1 |
SELECT `theme_id`, `technical_name`, `resolved_config`, `view_inheritance`, `script_files`, `icon_sets`, `updated_at` FROM `theme_runtime_config` WHERE `technical_name` = ?
Parameters:
[
"TcinnThemeWareModern"
]
|
||||||||||||||||||||||||
|
0.60 ms (0.77%) |
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:
[ "/detail/019cae00e48e70bcbbbbc4ba3938ac5c" "/navigation/9fa0c8cc93e64c4690f37fcabd1fe389" "/navigation/d2d22e623eaa462b9623968f6274dd2d" b"/»_ââšMpªXTÎ|ãâ\v" b"E\eeZ/SJj‡,|\x06o&%£" ] |
||||||||||||||||||||||||
|
0.55 ms (0.71%) |
5 |
SELECT `custom_field`.`id` as `custom_field.id`, `custom_field`.`name` as `custom_field.name`, `custom_field`.`type` as `custom_field.type`, `custom_field`.`config` as `custom_field.config`, `custom_field`.`active` as `custom_field.active`, `custom_field`.`set_id` as `custom_field.customFieldSetId`, `custom_field`.`allow_customer_write` as `custom_field.allowCustomerWrite`, `custom_field`.`allow_cart_expose` as `custom_field.allowCartExpose`, `custom_field`.`store_api_aware` as `custom_field.storeApiAware`, `custom_field`.`include_in_search` as `custom_field.includeInSearch`, `custom_field`.`created_at` as `custom_field.createdAt`, `custom_field`.`updated_at` as `custom_field.updatedAt` FROM `custom_field` WHERE `custom_field`.`id` IN (?)
Parameters:
[
b"m«ÕÇÝyMÊ©£\x02cX\x02$å"
]
|
||||||||||||||||||||||||
|
0.55 ms (0.71%) |
4 |
# navigation-route::meta-information SELECT LOWER(HEX(`id`)), `path`, `level` FROM `category` WHERE `id` = ? OR `id` = ?
Parameters:
[ b"#ûŽé´\x05E©¹ÔMÝ›\k'" b"#ûŽé´\x05E©¹ÔMÝ›\k'" ] |
||||||||||||||||||||||||
|
0.54 ms (0.70%) |
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"\x01”ùYW6~Š©vóä}0Ê‹" b"OÒPòý}BÖ„¿Ÿ\x07ÖšÞ " b"Ó´Û–9üAý©ü_\f27~" ] |
||||||||||||||||||||||||
|
0.54 ms (0.70%) |
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/8ad155dc614549adbc5c4d574f1bda84" "/navigation/5b07b69b64934365b86cb1c723b9bd2a" "/navigation/e547f85842f64f1ca93c88261d927f39" "/navigation/6cc34a9cb97b49cfbdac146df01d0a24" "/navigation/9b22c085f93f4002bbb39ced9c1ea5af" "/navigation/d5aa984c57084ca59b6fd5349445d9ce" "/navigation/fea09cad436f40848725fd899b2004db" "/navigation/eb6e817aa8e643d384c73778c3753384" "/navigation/4b4d719dce9d4b608a509ecdc2383675" "/navigation/08181122bdc849e380a0b0e7466f03d5" "/navigation/587e6322587347a29bcb7321cb073300" "/navigation/bc9618effde44ac49a2f82d518ff25a1" "/navigation/f7007bc0e4b04b75bbc478e958fcdff9" "/navigation/0198c164fa3f7d3fb3e7b031e2b17444" b"/»_ââšMpªXTÎ|ãâ\v" b"E\eeZ/SJj‡,|\x06o&%£" ] |
||||||||||||||||||||||||
|
0.52 ms (0.67%) |
1 |
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`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x01š\x10E\x06rpš²T¿*l6r/" ] |
||||||||||||||||||||||||
|
0.51 ms (0.66%) |
1 |
-- base-context-factory::sales-channel::read SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`measurement_units` as `sales_channel.measurementUnits`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.currency`.`id` as `sales_channel.currency.id`, `sales_channel.currency`.`factor` as `sales_channel.currency.factor`, `sales_channel.currency`.`symbol` as `sales_channel.currency.symbol`, `sales_channel.currency`.`iso_code` as `sales_channel.currency.isoCode`, `sales_channel.currency`.`position` as `sales_channel.currency.position`, `sales_channel.currency`.`tax_free_from` as `sales_channel.currency.taxFreeFrom`, `sales_channel.currency`.`item_rounding` as `sales_channel.currency.itemRounding`, `sales_channel.currency`.`total_rounding` as `sales_channel.currency.totalRounding`, `sales_channel.currency`.`created_at` as `sales_channel.currency.createdAt`, `sales_channel.currency`.`updated_at` as `sales_channel.currency.updatedAt`, `sales_channel.currency.translation.shortName`, `sales_channel.currency.translation.shortName` as `sales_channel.currency.shortName`, `sales_channel.currency.translation.name`, `sales_channel.currency.translation.name` as `sales_channel.currency.name`, `sales_channel.currency.translation.customFields`, `sales_channel.currency.translation.customFields` as `sales_channel.currency.customFields`, `sales_channel.translation.name`, `sales_channel.translation.name` as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, `sales_channel.translation.homeName` as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, `sales_channel.translation.customFields` as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel`.`currency_id` = `sales_channel.currency`.`id` LEFT JOIN (SELECT `sales_channel.translation`.`sales_channel_id`, `sales_channel.translation`.`name` as `sales_channel.translation.name`, `sales_channel.translation`.`custom_fields` as `sales_channel.translation.customFields`, `sales_channel.translation`.`home_slot_config` as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.`home_enabled` as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.`home_name` as `sales_channel.translation.homeName`, `sales_channel.translation`.`home_meta_title` as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.`home_meta_description` as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.`home_keywords` as `sales_channel.translation.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.`language_id` = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` LEFT JOIN (SELECT `sales_channel.currency.translation`.`currency_id`, `sales_channel.currency.translation`.`short_name` as `sales_channel.currency.translation.shortName`, `sales_channel.currency.translation`.`name` as `sales_channel.currency.translation.name`, `sales_channel.currency.translation`.`custom_fields` as `sales_channel.currency.translation.customFields` FROM `currency_translation` `sales_channel.currency.translation` WHERE `sales_channel.currency.translation`.`language_id` = ?) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation`.`currency_id` = `sales_channel.currency`.`id` WHERE `sales_channel`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"E\eeZ/SJj‡,|\x06o&%£" ] |
||||||||||||||||||||||||
|
0.50 ms (0.65%) |
1 |
-- product::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"Þ\x0789ÄMõ“Ó½‡Äœ™\x16" ] |
||||||||||||||||||||||||
|
0.48 ms (0.62%) |
1 |
-- base-context-factory::payment-method::read SELECT `payment_method`.`id` as `payment_method.id`, `payment_method`.`plugin_id` as `payment_method.pluginId`, `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`, `payment_method`.`position` as `payment_method.position`, `payment_method`.`active` as `payment_method.active`, `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`, `payment_method`.`media_id` as `payment_method.mediaId`, `payment_method`.`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.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` as `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` as `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` as `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`recurring_url` as `payment_method.appPaymentMethod.recurringUrl`, `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`, `payment_method.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 `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_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"ÞÜ(\x07o\x1FN²¦2F\x06†á9" ] |
||||||||||||||||||||||||
|
0.46 ms (0.60%) |
1 |
-- product::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"¸Iû?“Ah•êƒÑ£ªí3" ] |
||||||||||||||||||||||||
|
0.46 ms (0.59%) |
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"ÞÜ(\x07o\x1FN²¦2F\x06†á9" b"íà[q›!AC¤Ë\x1C\x02\x16¸RÞ" b".·kcµI ÞO®-\x06wÀb" b""" jú\n Åá\x11OO†H¢w«BHö """ b"\x18v›-…¾M@š×Çá\x10\x16³#" b"\x01R\rÖ\x11pe¨ËEQ1¬Žb" b"\x01R\rÔÎp/±‘å/É\x15L+" b"À\e¸\e\x12ÎK³’%üî*ô7" b"\x1EJÓfó’B\eºIH—\x17Ò\x1D\x0F" b"ýU"OÙ\eDô¯â7j\x17¦‹]" ] |
||||||||||||||||||||||||
|
0.45 ms (0.59%) |
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"\x01”ùYW6~Š©vóä}0Ê‹" b"OÒPòý}BÖ„¿Ÿ\x07ÖšÞ " b"Ó´Û–9üAý©ü_\f27~" null b"KMqÎK`ŠPžÍÂ86u" b"¬\x14ä\x12ÚF\x7F‰’f[›É[È" b"ënz¨æCÓ„Ç7xÃu3„" b"þ œCo@„‡%ý‰› \x04Û" ] |
||||||||||||||||||||||||
|
0.44 ms (0.57%) |
1 |
-- base-context-factory::shipping-method::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"AÄ~WájFîæ|\x1E†R•\x19" ] |
||||||||||||||||||||||||
|
0.43 ms (0.56%) |
1 |
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"ÞÜ(\x07o\x1FN²¦2F\x06†á9" b"íà[q›!AC¤Ë\x1C\x02\x16¸RÞ" b".·kcµI ÞO®-\x06wÀb" b""" jú\n Åá\x11OO†H¢w«BHö """ b"\x18v›-…¾M@š×Çá\x10\x16³#" b"\x01R\rÖ\x11pe¨ËEQ1¬Žb" b"\x01R\rÔÎp/±‘å/É\x15L+" b"À\e¸\e\x12ÎK³’%üî*ô7" b"\x1EJÓfó’B\eºIH—\x17Ò\x1D\x0F" b"ýU"OÙ\eDô¯â7j\x17¦‹]" ] |
||||||||||||||||||||||||
|
0.43 ms (0.56%) |
1 |
SELECT id FROM `pickware_erp_return_order_line_item` LIMIT 1
Parameters:
[] |
||||||||||||||||||||||||
|
0.40 ms (0.52%) |
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"\x01”ùYW6~Š©vóä}0Ê‹" b"OÒPòý}BÖ„¿Ÿ\x07ÖšÞ " b"Ó´Û–9üAý©ü_\f27~" null b"\x01˜Ádú?}?³ç°1â±tD" b"\x08\x18\x11"½ÈI〠°çFo\x03Õ" b"GHu•–£LH·\eYµÙÊ B" b"KMqÎK`ŠPžÍÂ86u" b"X~c"XsG¢›Ës!Ë\x073\x00" b"Za}Ó…eE” R%g‚ãÉê" b"[\x07¶›d“Ce¸l±Ç#¹½*" b""" lÃJœ¹{IϽ¬\x14mð\x1D\n $ """ b"ŠÑUÜaEI¼\MWO\eÚ„" b"šòoÛ%¢DÿŸÇÙ‰\x03·ù»" b"›"À…ù?@\x02»³œíœ\x1E¥¯" b"¬\x14ä\x12ÚF\x7F‰’f[›É[È" b"¼–\x18ïýäJÄš/‚Õ\x18ÿ%¡" b"Õª˜LW\x08L¥›oÕ4”EÙÎ" b"åGøXBöO\x1C©<ˆ&\x1D’\x7F9" b"ënz¨æCÓ„Ç7xÃu3„" b"÷\x00{Àä°Ku»ÄxéXüßù" b"þ œCo@„‡%ý‰› \x04Û" ] |
||||||||||||||||||||||||
|
0.40 ms (0.51%) |
1 |
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`, `script`.`name` AS scriptName, `script`.`script` AS script, `script`.`hook` AS hook, `app`.`name` AS appName, `app`.`version` AS appVersion, LOWER(HEX(`app`.`integration_id`)) AS integrationId, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified, IF(`script`.`active` = 1 AND (`app`.id IS NULL OR `app`.`active` = 1), 1, 0) AS active FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters:
[] |
||||||||||||||||||||||||
|
0.39 ms (0.51%) |
1 |
SELECT CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') `key`, CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') url, LOWER(HEX(domain.id)) id, LOWER(HEX(sales_channel.id)) salesChannelId, LOWER(HEX(sales_channel.type_id)) typeId, LOWER(HEX(domain.snippet_set_id)) snippetSetId, LOWER(HEX(domain.currency_id)) currencyId, LOWER(HEX(domain.language_id)) languageId, LOWER(HEX(theme.id)) themeId, sales_channel.maintenance maintenance, sales_channel.maintenance_ip_whitelist maintenanceIpWhitelist, snippet_set.iso as locale, theme.technical_name as themeName, parentTheme.technical_name as parentThemeName FROM sales_channel INNER JOIN sales_channel_domain domain ON domain.sales_channel_id = sales_channel.id LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id INNER JOIN snippet_set snippet_set ON snippet_set.id = domain.snippet_set_id LEFT JOIN theme theme ON theme_sales_channel.theme_id = theme.id LEFT JOIN theme parentTheme ON theme.parent_theme_id = parentTheme.id WHERE (sales_channel.type_id = UNHEX(?)) AND (sales_channel.active)
Parameters:
[
"8a243080f92e4c719546314b577cf82b"
]
|
||||||||||||||||||||||||
|
0.39 ms (0.50%) |
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"²\x08\x02\x05†‰JÙ¡Èà·wÏœo" b"”bN\x03›¬L‹Œ%Ńã¾\x04Ù" b"\x01–Øoôþ\x7FÁ—hBd;¼.Ï" b"ˆ\x02° csN\x0Fµu¶\x16\x05Ù·" b"\x01ŒC2‡§y#‹ýîñ!\x15\x1DJ" b"AÄ~WájFîæ|\x1E†R•\x19" ] |
||||||||||||||||||||||||
|
0.37 ms (0.48%) |
1 |
-- base-context-factory::taxes::association::rules::read SELECT `tax_rule`.`id` as `tax_rule.id`, `tax_rule`.`tax_rule_type_id` as `tax_rule.taxRuleTypeId`, `tax_rule`.`country_id` as `tax_rule.countryId`, `tax_rule`.`tax_rate` as `tax_rule.taxRate`, `tax_rule`.`data` as `tax_rule.data`, `tax_rule`.`tax_id` as `tax_rule.taxId`, `tax_rule`.`active_from` as `tax_rule.activeFrom`, `tax_rule`.`created_at` as `tax_rule.createdAt`, `tax_rule`.`updated_at` as `tax_rule.updatedAt`, `tax_rule.type`.`id` as `tax_rule.type.id`, `tax_rule.type`.`technical_name` as `tax_rule.type.technicalName`, `tax_rule.type`.`position` as `tax_rule.type.position`, `tax_rule.type`.`created_at` as `tax_rule.type.createdAt`, `tax_rule.type`.`updated_at` as `tax_rule.type.updatedAt`, `tax_rule.type.translation.typeName`, `tax_rule.type.translation.typeName` as `tax_rule.type.typeName` FROM `tax_rule` LEFT JOIN `tax_rule_type` `tax_rule.type` ON `tax_rule`.`tax_rule_type_id` = `tax_rule.type`.`id` LEFT JOIN (SELECT `tax_rule.type.translation`.`tax_rule_type_id`, `tax_rule.type.translation`.`type_name` as `tax_rule.type.translation.typeName` FROM `tax_rule_type_translation` `tax_rule.type.translation` WHERE `tax_rule.type.translation`.`language_id` = ?) `tax_rule.type.tax_rule_type_translation` ON `tax_rule.type.tax_rule_type_translation`.`tax_rule_type_id` = `tax_rule.type`.`id` WHERE ((`tax_rule`.`tax_id` IN (?, ?, ?)))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"‚éü.cHŽ—§\x07$Ò‰Iç" b"µ\x15:P%àAÀ©ódùi\x10=•" b"ß+mˆ†çDƱ¢\x11lÀ8;b" ] |
||||||||||||||||||||||||
|
0.37 ms (0.47%) |
1 |
-- breadcrumb-builder::main-category::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.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"ÒÒ.b>ªF+–#–btÝ-" ] |
||||||||||||||||||||||||
|
0.36 ms (0.47%) |
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"\x01”ùYW6~Š©vóä}0Ê‹" b"OÒPòý}BÖ„¿Ÿ\x07ÖšÞ " b"Ó´Û–9üAý©ü_\f27~" null b"ÒÒ.b>ªF+–#–btÝ-" ] |
||||||||||||||||||||||||
|
0.36 ms (0.46%) |
3 |
-- sales-channel::load-analytics::read SELECT `sales_channel_analytics`.`id` as `sales_channel_analytics.id`, `sales_channel_analytics`.`tracking_id` as `sales_channel_analytics.trackingId`, `sales_channel_analytics`.`active` as `sales_channel_analytics.active`, `sales_channel_analytics`.`track_orders` as `sales_channel_analytics.trackOrders`, `sales_channel_analytics`.`anonymize_ip` as `sales_channel_analytics.anonymizeIp`, `sales_channel_analytics`.`track_offcanvas_cart` as `sales_channel_analytics.trackOffcanvasCart`, `sales_channel_analytics`.`created_at` as `sales_channel_analytics.createdAt`, `sales_channel_analytics`.`updated_at` as `sales_channel_analytics.updatedAt` FROM `sales_channel_analytics` WHERE `sales_channel_analytics`.`id` IN (?)
Parameters:
[
b"DôWV06Iû“`³\x18ô€Wè"
]
|
||||||||||||||||||||||||
|
0.36 ms (0.46%) |
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`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" false true "product_download" false true "product_download" b"\x01Š"nE!}ÕªA9cïóU‡" b"\x01™Köï¨qøµ\x19°Ê\uíz" b"\x01™Köï§wÁ‹¸âÛÇî“ñ" b"\x01™M\x03Þ‚\x7F\x13›¸Qpá ,“" ] |
||||||||||||||||||||||||
|
0.36 ms (0.46%) |
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"E\eeZ/SJj‡,|\x06o&%£" b"E\eeZ/SJj‡,|\x06o&%£" ] |
||||||||||||||||||||||||
|
0.35 ms (0.46%) |
1 |
-- base-context-factory::sales-channel::association::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`, `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.translationCode` ON `language`.`translation_code_id` = `language.translationCode`.`id` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`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` 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` = ?)) AND (`language`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" ] |
||||||||||||||||||||||||
|
0.35 ms (0.45%) |
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"E\eeZ/SJj‡,|\x06o&%£" "/_esi/global/header" ] |
||||||||||||||||||||||||
|
0.34 ms (0.44%) |
1 |
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"²\x08\x02\x05†‰JÙ¡Èà·wÏœo" b"”bN\x03›¬L‹Œ%Ńã¾\x04Ù" b"\x01–Øoôþ\x7FÁ—hBd;¼.Ï" b"ˆ\x02° csN\x0Fµu¶\x16\x05Ù·" b"\x01ŒC2‡§y#‹ýîñ!\x15\x1DJ" b"AÄ~WájFîæ|\x1E†R•\x19" ] |
||||||||||||||||||||||||
|
0.32 ms (0.41%) |
1 |
-- product::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"¸Iû?“Ah•êƒÑ£ªí3" ] |
||||||||||||||||||||||||
|
0.31 ms (0.41%) |
1 |
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
|
||||||||||||||||||||||||
|
0.31 ms (0.40%) |
3 |
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"¬\x14ä\x12ÚF\x7F‰’f[›É[È" ] |
||||||||||||||||||||||||
|
0.30 ms (0.39%) |
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.30 ms (0.38%) |
1 |
# context-factory::base-context SELECT sales_channel.id as sales_channel_id, sales_channel.language_id as sales_channel_default_language_id, sales_channel.currency_id as sales_channel_currency_id, currency.factor as sales_channel_currency_factor, GROUP_CONCAT(LOWER(HEX(sales_channel_language.language_id))) as sales_channel_language_ids FROM sales_channel INNER JOIN currency ON sales_channel.currency_id = currency.id LEFT JOIN sales_channel_language ON sales_channel_language.sales_channel_id = sales_channel.id WHERE sales_channel.id = ? GROUP BY sales_channel.id, sales_channel.language_id, sales_channel.currency_id, currency.factor
Parameters:
[
b"E\eeZ/SJj‡,|\x06o&%£"
]
|
||||||||||||||||||||||||
|
0.29 ms (0.38%) |
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.29 ms (0.37%) |
1 |
-- product-detail-route::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%" b"\x01œ®\x00äŽp¼»»Äº98¬\" ] |
||||||||||||||||||||||||
|
0.28 ms (0.36%) |
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"E\eeZ/SJj‡,|\x06o&%£" ] |
||||||||||||||||||||||||
|
0.28 ms (0.36%) |
1 |
SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, parentLocale.code AS parentCode, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id LEFT JOIN language parentLanguage ON language.parent_id = parentLanguage.id LEFT JOIN locale parentLocale ON parentLanguage.translation_code_id = parentLocale.id
Parameters:
[] |
||||||||||||||||||||||||
|
0.27 ms (0.35%) |
1 |
-- base-context-factory::country::read SELECT `country`.`id` as `country.id`, `country`.`iso` as `country.iso`, `country`.`position` as `country.position`, `country`.`active` as `country.active`, `country`.`shipping_available` as `country.shippingAvailable`, `country`.`iso3` as `country.iso3`, `country`.`display_state_in_registration` as `country.displayStateInRegistration`, `country`.`force_state_in_registration` as `country.forceStateInRegistration`, `country`.`check_vat_id_pattern` as `country.checkVatIdPattern`, `country`.`vat_id_required` as `country.vatIdRequired`, `country`.`vat_id_pattern` as `country.vatIdPattern`, `country`.`customer_tax` as `country.customerTax`, `country`.`company_tax` as `country.companyTax`, `country`.`postal_code_required` as `country.postalCodeRequired`, `country`.`check_postal_code_pattern` as `country.checkPostalCodePattern`, `country`.`check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern`, `country`.`advanced_postal_code_pattern` as `country.advancedPostalCodePattern`, `country`.`default_postal_code_pattern` as `country.defaultPostalCodePattern`, `country`.`is_eu` as `country.isEu`, `country`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, `country.translation.name`, `country.translation.name` as `country.name`, `country.translation.addressFormat`, `country.translation.addressFormat` as `country.addressFormat`, `country.translation.customFields`, `country.translation.customFields` as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation`.`country_id`, `country.translation`.`name` as `country.translation.name`, `country.translation`.`custom_fields` as `country.translation.customFields`, `country.translation`.`address_format` as `country.translation.addressFormat` FROM `country_translation` `country.translation` WHERE `country.translation`.`language_id` = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"±Ü–“KFL\x12—K¤Ù¤gPù" ] |
||||||||||||||||||||||||
|
0.27 ms (0.34%) |
1 |
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.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 (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` WHERE `payment_method`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x01R\rÔÎp/±‘å/É\x15L+" b"\x01R\rÖ\x11pe¨ËEQ1¬Žb" b"\x18v›-…¾M@š×Çá\x10\x16³#" b"\x1EJÓfó’B\eºIH—\x17Ò\x1D\x0F" b".·kcµI ÞO®-\x06wÀb" b""" jú\n Åá\x11OO†H¢w«BHö """ b"À\e¸\e\x12ÎK³’%üî*ô7" b"ÞÜ(\x07o\x1FN²¦2F\x06†á9" b"íà[q›!AC¤Ë\x1C\x02\x16¸RÞ" b"ñï6SŒYMÅ€µž( j\x12—" b"ýU"OÙ\eDô¯â7j\x17¦‹]" ] |
||||||||||||||||||||||||
|
0.27 ms (0.34%) |
1 |
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"E\eeZ/SJj‡,|\x06o&%£" ] |
||||||||||||||||||||||||
|
0.27 ms (0.34%) |
1 |
-- base-context-factory::customer-group::read SELECT `customer_group`.`id` as `customer_group.id`, `customer_group`.`display_gross` as `customer_group.displayGross`, `customer_group`.`registration_active` as `customer_group.registrationActive`, `customer_group`.`created_at` as `customer_group.createdAt`, `customer_group`.`updated_at` as `customer_group.updatedAt`, `customer_group.translation.name`, `customer_group.translation.name` as `customer_group.name`, `customer_group.translation.registrationTitle`, `customer_group.translation.registrationTitle` as `customer_group.registrationTitle`, `customer_group.translation.registrationIntroduction`, `customer_group.translation.registrationIntroduction` as `customer_group.registrationIntroduction`, `customer_group.translation.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationOnlyCompanyRegistration` as `customer_group.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationSeoMetaDescription`, `customer_group.translation.registrationSeoMetaDescription` as `customer_group.registrationSeoMetaDescription`, `customer_group.translation.customFields`, `customer_group.translation.customFields` as `customer_group.customFields` FROM `customer_group` LEFT JOIN (SELECT `customer_group.translation`.`customer_group_id`, `customer_group.translation`.`name` as `customer_group.translation.name`, `customer_group.translation`.`custom_fields` as `customer_group.translation.customFields`, `customer_group.translation`.`registration_title` as `customer_group.translation.registrationTitle`, `customer_group.translation`.`registration_introduction` as `customer_group.translation.registrationIntroduction`, `customer_group.translation`.`registration_only_company_registration` as `customer_group.translation.registrationOnlyCompanyRegistration`, `customer_group.translation`.`registration_seo_meta_description` as `customer_group.translation.registrationSeoMetaDescription` FROM `customer_group_translation` `customer_group.translation` WHERE `customer_group.translation`.`language_id` = ?) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation`.`customer_group_id` = `customer_group`.`id` WHERE `customer_group`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"ϽP\x18ÓŽAØÊ\x10ÙOȽÖ" ] |
||||||||||||||||||||||||
|
0.26 ms (0.33%) |
1 |
-- base-context-factory::currency::read SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.shortName`, `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.25 ms (0.32%) |
1 |
-- app-scripts::refresh::search-ids SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ? AND `app`.`self_managed` = ?)
Parameters:
[ true false ] |
||||||||||||||||||||||||
|
0.24 ms (0.31%) |
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" ] |
||||||||||||||||||||||||
|
0.24 ms (0.31%) |
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.23 ms (0.30%) |
1 |
-- breadcrumb-builder::main-category::search-ids SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `main_category` `category.mainCategories` ON `category`.`id` = `category.mainCategories`.`category_id` AND `category`.version_id = `category.mainCategories`.category_version_id WHERE (`category`.`version_id` = ?) AND (((`category.mainCategories`.`product_id` = ? AND `category.mainCategories`.`sales_channel_id` = ? AND (`category`.`path` LIKE ? OR `category`.`path` LIKE ? OR `category`.`path` LIKE ?)))) LIMIT 1
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01œ®\x00äŽp¼»»Äº98¬\" b"E\eeZ/SJj‡,|\x06o&%£" "%|23fb8ee9b40545a9b9d44ddd9b5c6b27|%" "%|ac8f14e412da467f8992665b9bc95bc8|%" "%|5a617dd385654594a052256782e3c9ea|%" ] |
||||||||||||||||||||||||
|
0.23 ms (0.30%) |
1 |
SELECT path FROM category WHERE id = ?
Parameters:
[
b"ÒÒ.b>ªF+–#–btÝ-"
]
|
||||||||||||||||||||||||
|
0.23 ms (0.30%) |
1 |
SELECT pm.`handler_identifier`, LOWER(HEX(sc_pm.`payment_method_id`)) FROM `sales_channel_payment_method` AS sc_pm LEFT JOIN `payment_method` AS pm ON pm.`id` = sc_pm.`payment_method_id` WHERE sc_pm.`sales_channel_id` = ? AND pm.`active` = 1
Parameters:
[
b"E\eeZ/SJj‡,|\x06o&%£"
]
|
||||||||||||||||||||||||
|
0.23 ms (0.30%) |
1 |
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"E\eeZ/SJj‡,|\x06o&%£" ] |
||||||||||||||||||||||||
|
0.22 ms (0.29%) |
1 |
-- cart-rule-loader::load-rules::read SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"\x01ŒC5jî}ª²rqPÿ†" b"\x01\x15 zWxß¡èHÄŠ%¥" b"\x01œæ\x01¡ñspšoPZ\x11\x01¤R" b"ìj=š¡DINŸQa×2\x01\vA" b"ŒðÖ\x08ëûGˆ€\x11Y\x10AT¤²" b"\x01–Ø¿\x06{q‘˜ÎƒøÙC“·" b"\x01f–<«sœ“UCô¾ö\eð" b"9ª/Ös™EȃÍ#6‰ü$" b"ºŽŸ\x03ó«GÀˆê6\”`Z'" b"\x01Ž\x18å;\x0Es\x05…Q\x01˜¡\x04‘Š" b"\x01”ùYW6~Š©vóä}0Ê‹" b"B:*ë]±O™·KüjDQ¢r" b"OÒPòý}BÖ„¿Ÿ\x07ÖšÞ " b"“P?föÞO+ƒôP›&ø)\n" b"Ó´Û–9üAý©ü_\f27~" ] |
||||||||||||||||||||||||
|
0.22 ms (0.28%) |
1 |
SELECT `language`.`id` FROM `language` WHERE `language`.`id` IN (?) LIMIT 1
Parameters:
[
b"/»_ââšMpªXTÎ|ãâ\v"
]
|
||||||||||||||||||||||||
|
0.22 ms (0.28%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters:
[ b"E\eeZ/SJj‡,|\x06o&%£" "KlarnaPayment.settings.%" ] |
||||||||||||||||||||||||
|
0.22 ms (0.28%) |
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.22 ms (0.28%) |
1 |
-- base-context-factory::sales-channel::association::domains::read SELECT `sales_channel_domain`.`id` as `sales_channel_domain.id`, `sales_channel_domain`.`url` as `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`measurement_units` as `sales_channel_domain.measurementUnits`, `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt` FROM `sales_channel_domain` WHERE ((`sales_channel_domain`.`sales_channel_id` IN (?)))
Parameters:
[
b"E\eeZ/SJj‡,|\x06o&%£"
]
|
||||||||||||||||||||||||
|
0.22 ms (0.28%) |
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"E\eeZ/SJj‡,|\x06o&%£" ] |
||||||||||||||||||||||||
|
0.21 ms (0.28%) |
1 |
SELECT LOWER(HEX(`language.salesChannels.mapping`.`sales_channel_id`)) as `key`, GROUP_CONCAT(LOWER(HEX(`language.salesChannels.mapping`.`language_id`)) ) as `value` FROM `language` LEFT JOIN `sales_channel_language` `language.salesChannels.mapping` ON `language.salesChannels.mapping`.`language_id` = `language`.id WHERE ((`language`.`id` = ?)) AND (`language.salesChannels.mapping`.`sales_channel_id` IN (?)) GROUP BY `language.salesChannels.mapping`.`sales_channel_id`
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"E\eeZ/SJj‡,|\x06o&%£" ] |
||||||||||||||||||||||||
|
0.21 ms (0.27%) |
1 |
SELECT IFNULL(locale_translation.name, fallback_translation.name) AS language_name FROM language LEFT JOIN locale_translation ON locale_translation.locale_id = language.locale_id AND locale_translation.language_id = ? LEFT JOIN locale_translation fallback_translation ON fallback_translation.locale_id = language.locale_id AND fallback_translation.language_id = ? WHERE language.id = ?
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" ] |
||||||||||||||||||||||||
|
0.20 ms (0.26%) |
1 |
SELECT LOWER(HEX(theme.id)) themeId, theme.technical_name as themeName, parentTheme.technical_name as parentThemeName, LOWER(HEX(parentTheme.parent_theme_id)) as grandParentThemeId FROM sales_channel LEFT JOIN theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id LEFT JOIN theme ON theme_sales_channel.theme_id = theme.id LEFT JOIN theme AS parentTheme ON parentTheme.id = theme.parent_theme_id WHERE sales_channel.id = ?
Parameters:
[
b"E\eeZ/SJj‡,|\x06o&%£"
]
|
||||||||||||||||||||||||
|
0.19 ms (0.25%) |
1 |
# product-detail-route::check-variant-listing-config SELECT variant_listing_config as variantListingConfig, parent_id as parentId FROM product WHERE id = ? AND version_id = ?
Parameters:
[ b"\x01œ®\x00äŽp¼»»Äº98¬\" b"\x0F©\x1CãéjK¾KÙÎu,4%" ] |
||||||||||||||||||||||||
|
0.19 ms (0.25%) |
1 |
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||||||
|
0.19 ms (0.24%) |
1 |
-- cart-rule-loader::load-rules::search-ids SELECT `rule`.`id` FROM `rule` WHERE (`rule`.`invalid` = ?) ORDER BY `rule`.`priority` DESC, `rule`.`id` ASC LIMIT 500
Parameters:
[
false
]
|
||||||||||||||||||||||||
|
0.18 ms (0.23%) |
1 |
SELECT `script`.`id` as `script.id`, `script`.`script` as `script.script`, `script`.`hook` as `script.hook`, `script`.`name` as `script.name`, `script`.`active` as `script.active`, `script`.`app_id` as `script.appId`, `script`.`created_at` as `script.createdAt`, `script`.`updated_at` as `script.updatedAt` FROM `script` WHERE ((`script`.`app_id` IN (?)))
Parameters:
[
b"\x01š\x10E\x06rpš²T¿*l6r/"
]
|
||||||||||||||||||||||||
|
0.18 ms (0.23%) |
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.18 ms (0.23%) |
1 |
-- base-context-factory::cash-rounding::search-ids SELECT `currency_country_rounding`.`id` FROM `currency_country_rounding` WHERE (`currency_country_rounding`.`currency_id` = ? AND `currency_country_rounding`.`country_id` = ?) LIMIT 1
Parameters:
[ b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ" b"±Ü–“KFL\x12—K¤Ù¤gPù" ] |
||||||||||||||||||||||||
|
0.18 ms (0.23%) |
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"E\eeZ/SJj‡,|\x06o&%£"
]
|
||||||||||||||||||||||||
|
0.16 ms (0.21%) |
1 |
SELECT DISTINCT `technical_name` FROM `theme_runtime_config` WHERE `technical_name` IS NOT NULL
Parameters:
[] |
||||||||||||||||||||||||
|
0.16 ms (0.20%) |
1 |
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
"de-DE"
]
|
||||||||||||||||||||||||
|
0.15 ms (0.20%) |
1 |
SELECT `name`, `path`, `author`, `self_managed` FROM `app` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||||||
|
0.15 ms (0.20%) |
1 |
SELECT `base_class` AS `baseClass`, `author` FROM `plugin`
Parameters:
[] |
||||||||||||||||||||||||
|
0.15 ms (0.20%) |
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"E\eeZ/SJj‡,|\x06o&%£" b"±Ü–“KFL\x12—K¤Ù¤gPù" ] |
||||||||||||||||||||||||
|
0.15 ms (0.19%) |
1 |
SELECT `app`.`name`, `app`.`version`, `app`.`template_load_priority` FROM `app` INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id` WHERE `app`.`active` = 1 AND `app_template`.`active` = 1
Parameters:
[] |
||||||||||||||||||||||||
|
0.15 ms (0.19%) |
1 |
-- base-context-factory::taxes::read SELECT `tax`.`id` as `tax.id`, `tax`.`tax_rate` as `tax.taxRate`, `tax`.`name` as `tax.name`, `tax`.`position` as `tax.position`, `tax`.`custom_fields` as `tax.customFields`, `tax`.`created_at` as `tax.createdAt`, `tax`.`updated_at` as `tax.updatedAt` FROM `tax`
Parameters:
[] |
||||||||||||||||||||||||
|
0.14 ms (0.19%) |
2 |
SELECT url FROM sales_channel_domain
Parameters:
[] |
||||||||||||||||||||||||
|
0.11 ms (0.15%) |
1 |
SELECT id FROM `order_return` LIMIT 1
Parameters:
[] |
||||||||||||||||||||||||
|
0.11 ms (0.14%) |
1 |
SELECT `handler_identifier`, LOWER(HEX(`id`)) FROM `payment_method`
Parameters:
[] |
||||||||||||||||||||||||
|
0.09 ms (0.12%) |
1 |
SELECT COUNT(id) FROM app WHERE app_secret IS NOT NULL
Parameters:
[] |
||||||||||||||||||||||||
|
0.09 ms (0.12%) |
1 |
SELECT `min_search_length` FROM `product_search_config` WHERE `language_id` = ?
Parameters:
[
b"/»_ââšMpªXTÎ|ãâ\v"
]
|
||||||||||||||||||||||||
|
0.09 ms (0.11%) |
1 |
SELECT COUNT(*) FROM `wallee_transaction` LIMIT 1
Parameters:
[] |
||||||||||||||||||||||||
|
0.08 ms (0.10%) |
1 |
SELECT shipping_costs FROM `pickware_erp_return_order` LIMIT 1
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| 0 | default |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.