GET https://bodev.bottega.ch/cbax/manufacturer/index

Response
200 OK
IP
216.73.216.120
Profiled on
Token
b5d929

Query Metrics

95 Database Queries
70 Different statements
70.40 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
8.32 ms
(11.82%) 		1 
-- Manufacturer getManufacturerByChar manufacturer::read
SELECT `product_manufacturer`.`id` as `product_manufacturer.id`, `product_manufacturer`.`version_id` as `product_manufacturer.versionId`, `product_manufacturer`.`media_id` as `product_manufacturer.mediaId`, `product_manufacturer`.`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` FROM `product_manufacturer` 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` WHERE (`product_manufacturer`.`version_id` = ?) AND (`product_manufacturer`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"9ã{©-’G8\x00رìz\x02À"
  b"Õûª`'ÖEµ««Wáï\x0FóO"
  b"ÑcZ´ôóOIz\x17çBe"
  b"î³³ŽËR@„‡ÊfÖ\x08î"G"
  b"±›ñ\x1D€-N‘¦†ýJi¹~\x02"
  b"Xi§ûIŠL€»Ú2dÛ¡ßÛ"
  b"""
    \n
    kº±z›H.†üEë³Zšv
    """
  b"m2âÐØÚEô¸|ÃW\x15©\x01€"
  b"Úþ³å-PN1…!ã^ëX´\x1D"
  b"Ú\x1E™í*xGÈœ˜Ý•¸ïç;"
  b"ô\rSoߤKâ…Úöˆ%@2-"
  b"Ò\x07ïµ6{Kë“Ç\x12\x11u\x10JU"
  b"±\x7F¤\x1Aa@‚š>Ͳðø»˜"
  b"»\x16ÅÔ7:D“—eˆê.£ŒÉ"
  b"\x00Ä‘Ù\vŠN¡¸<|¡<4¼À"
  b"É* 7÷#H™œÖ·\x05KÊKË"
  b"Û]£K81H1©’\x0FÛ¶/R„"
  b"ž\x19d1àüN̦Òî4^\x07\x10ö"
  b"lÔÄò\x07\x07A¯¥„ÖŦ–¢Ä"
  b"N\x00—«e;A·±Ù§Úh‹^"
  b"\x1EÂ6F“PK(‡÷[Ù·ñ/D"
  b"Ä5&:œnD̤ö\x00tÐløG"
  b"E"ö\x05%\x17Fƒ·ÂÙª[\x7FW"
  b"R>¦‹§˜N^®\x11XNÌ@:Ô"
  b"Eí΁ìsL †^`Ò\v nÙ"
  b"Ú½[ÀÝÈF+»ÚÞè :SY"
  b"½bg\x04Ö9C\¢\eÅ 7\x108D"
  b"Zþ_Í\x0EðB[„pÀÃrñ9&"
  b"îdÊ.…XG"´Ç©–‘9°O"
  b"\v¯]æQéLò¾òIŽO`Èw"
  b"\x01‹Í‡V•qM¢•-á\v \tø"
  b"yì~ã5NÛ¶íXSCÖÄ«"
  b"PHÍùœCñƒ ¹›"'jQ"
  b"G_»•ÅªLø›VÉ Î\x11yÞ"
  b"[óÑ¡Y^N[±‘*–Bk#£"
  b"\x12\x08Á×Ó.Mξ\f@\t\x15Ÿkà"
  b"›Å.D#‰G«“\x16Òµëˆ:k"
  b"r‡.¬;aI…§ZÔçÂÉ—÷"
  b"\x06á_Õœ\x06DÕ¯²4)ãv\vk"
  b"Pý7\x16”kLqŸ¼oùÅåŽ)"
  b"߉\x11·\x0EŽGA„Œ†¶ú\x1CÈ!"
  b"€k-¸âöCä§EBÞ›2I\x14"
  b"¥¿EqbzB©´xa—|¸\x7FÎ"
  b"«X€`ø\x12CÙ°×›Æ|ÉL\x07"
  b"P<à‹\x1DfD;“lôS¥êx"
  b"}\eÑÙµ˜B7©H|Ôýó"ÿ"
  b"s]\x1C²IµHŸŒMd“™§\x7Fz"
  b"Ä­Ò‹E-A£†iZEÕ­4ì"
  b"¾N‰èÎ\x1CI´£\x1A˜N&ÝL†"
  b"ª{‹œ;ìO\x16 ¤\x1E>áÓ\x1Cœ"
  b"\x1F[³–fAå§ûǁßdŽ\x15"
  b".ÌgaÕðCˆ•Ð\x06æ_7Ó>"
  b"iYØ\eì•C† ƒçv\x00Š—"
  b"Ê\vgÒ\x0EG\x14‡­Ü3\\x10çö"
  b"""
    ÕÙ9t0\n
    Bb†ˆ:ƒZ\x05|Q
    """
  b"&_œ¥dŽDZ©-QTÃM\x13"
  b"汯‡zËEʈ\x17f\x03<“ÓŒ"
  b"Z\x12|tü\x12H\x7F´Ó’…b¸W1"
  b":€g“êrL/›vòµ¯ôÄo"
  b"""
    A\n
    jç\x08„F\x05—žm4nIæ\x0E
    """
  b"E™Ò8C\x1FD`ºÿI"*»¡_"
  b"B‘\x1Eò]ßEòœàÑu)R\x06/"
  b"MU»,ÕÓG¬²&\x15r„€ç}"
  b"/µþ<¡DK\x14…EÞ*¤#[¢"
  b"s™”²wµMö®MW:¬¢íÈ"
  b"""
    TDÏLäß@e™;vû*\n
    ìQ
    """
  b"6åýdýL@B¿ T›´2õ"
  b"Œ7E\x19ùâD\x04½ùƒÑ³Kª"
  b"îKtÒ½pE½–¨ö­\x02ã\x04w"
  b"»ÐÕ–ü›KVˆà{^TNÓW"
  b"…–UÏ)ŽHQ¼Ž \x17ãÖd´"
  b"@Z\x19\e®öK8•!F¿\x1C©\x1A¦"
  b"\x01ŒD\eèe~RŽ+\x12\x19–þå"
  b"—…ß\x0F¿òE¨\x05\x1EÖÂN…ï"
  b"µŠ›Î$YG{„ûZ•¨—0P"
  b"#\x11;åû”I’û\x1D\x0F󉈬"
  b"{™x¬nŽG(¾ëÃq\x04\x11*Z"
  b"Äÿ\x1E5ˆ\x1FO÷’­÷˜_\x18\x17—"
  b""\x06±¸EßI\x0FŸËó™“Á3ª"
  b"“\x1FÚï\x05|B*ŠðV’\x1EH×"
  b"vÔÙÄF£Eî¾$‘~}-øA"
  b"7O®¶Ì¨J›švYµÒ$-Ÿ"
  b"ª<ü÷Ç—N œCf¨rw°\x01"
  b"Z\x0F–Ê$[AE€) \x16ë‘â2"
  b"˜©³­hÉAʶHLb`\t›\r"
  b"ÜÚtM&,AB­kîîsy1\x15"
  b"­Êñ\x1C\èJ¼•\x00\n\x13)ý!Ê"
  b"1Ú¦¼ƒlH\x18–²4õ\x1E6ÅD"
  b"æR9\x10u O¯¿RFgÒ»\x1E\x0F"
  b"ÿÿ¾j¢5G\x17¶T\r˜¼\x06LQ"
  b"¢ýpÎe–Lޏÿ˜Tà£c…"
  b"^¿œ¥VF\f™Ü“¹\x10õzZ"
  b"ß™,f»õJN»²\x13@ÅÓ{ï"
  b"\x05à">î\x03HK»\vµžmÆ…‹"
  b"""
    W@\n
    G–\x08JŠ¤YV‰Ôº]v
    """
  b"""
    t¹&ò\n
    ŽI"Ž>ð•\x7FÖÛ
    """
  b"Û|bߎØEN†'‘2F¡ì"
  b"7P»4\x00\x1EIy«Ý\x0F¾¿™M"
  b"cÜÅ\fI·Kƒ²C\x10›\x01©:\x1F"
  b"ú©€ÝsñEá™´,ª÷˜ë«"
  b"“†&b\x1Eü@¸£gÂ]u;·Þ"
  b"Š%.ù!bG˯©mðœ÷ê\x04"
  b"Ê@éO8ÀGì€t|XàuK\r"
  b"†Ül“s…@1\x11ˆ{le7k"
  b"õYÕñeuFÔ¹:~\x17Eø¿H"
  b"\x10ϧ¬žUAP¶’Õêžn,;"
  b"Gû\x11\tªhF\x12¦¢ÚòŽY;["
  b"w\x04ŠGgNþªgî\x12߬|Ž"
  b"\x01ŒD-}ÓrR£Pàˆ\x1E;8¤"
  b"Ì\r…Ê<XA¼¨¢\t½}¿‹"
  b"\x0E0/çZ!Aóˆh¢ÝßM´ß"
  b"(°\x1F%\rLÚ¾ëÒ}(rR\x17"
  b"ÞSò†8@&â,4‚O*‘"
  b"ìßóg+ùFS°ÏáÂ\t–\x0F"
  b"ÉkXß7\x1AMU¥ÎÀÞú¯§l"
  b"‰F\x0E4Ä F\x1E«Sk¿7olk"
  b"\x01ŒCxõÏp§ƒuš~€¡ \x1A"
  b"”š¼¦$…E\x7F¸l¸ïâéÿ…"
  b"é¸R}þ\x04I\x06¨Œ÷Pk\x19@\x0E"
  b"\x19qBxºFJ\r£®"CwsaV"
  b"Ÿ˜ü6\x14NØ©ÙáW\x129ˆ\x1A"
  b"\x0E1·­n­H\x16¿çÒ»Le¾Û"
  b"9¾Ç¨¢EÝ€p7Ld\x04¹´"
  b"""
    H¥\n
    ç\x07Cíµ9l\x02^BÍ£
    """
  b"i\x1C\x1D\x18aCcÅÖýÞKâ\x02"
  b"\x12œƒ:©žJ\x1A¸¥BG²“Ê"
  b"\x00zC÷—»NsŠƒ§Þ9¼'×"
  b"ã\x0E»ç\x17ŸCU½’Z‹\x0F²ž«"
  b"ÍüƒùQ\x10F*„›d|¸6-_"
  b""HÅ\e\x07sN¢›\x17\x01f÷éy¡"
  b"\x03€Ù1"pC¬¹B)ÉzŽGA"
  b"|æzW1YG*ºCŒ\x08ÕŠé "
  b"C¡\x13ˆa\x7FBāx»’Nˤž"
  b"w?(\v\x0E6EË¡­)  Ø€Ñ"
  b"\x01‘\x1F(vuB\x1E¹óËÏ\x10Ë«ô"
  b"t\rcïÑ´BÿŽNï³ï!\x03\x1C"
  b"áL®A7DFçƒë\x17žm!Ï\x06"
  b"›^‡l\x1DªC‚¯Ì\x05<\x14\x1EAæ"
  b"Uǐ¹¯\x13FÚ’W_6\vößd"
  b"øiÍë°:EM‘Z8ɝ7|"
  b"·±kôõ;Fϼ¬\x10ûåa–î"
  b"ä´Ä‰¿çG­®\x15îÄ2ú™À"
  b"w\rÓõÿ@OLâ6\x15M¥‚;"
  b"\x00ÿ„ÙŸ&L\x16ŸMŽu\x17W\x08m"
  b"è®ïåkr@οkñ”²c\eM"
  b"\x19ôv³Ó^L&¥ü:‡ÂŒzŽ"
  b"s~‰%ýÒNk•ÈMöùs\x1D\x08"
  b"\x06ô;#\x03\e@\x19Ž7\x0E¾-²{"
  b"k†OŒ_KÝ 2ߥï‚Éù"
  b"$Èm.FéLr“„–úÈ\x065<"
  b"¼Ž¦#€|NS±F‡E‡\x1C\x01»"
  b"S\tŽ”\x0FKGN€E\x04xîc«\x1D"
  b"µæmЯµF>š=·x:ŠÞ‡"
  b"’\x1CþvíXMàžïÉè)¼\Â"
  b"*m_H86LS¶4šè´Ô¤G"
  b"P„\x1CââLK„“\x074¶Æ?\x13µ"
  b"rûŒ\‘æB0¿©êJMPò}"
  b"ÞüU3DFi›3náfªÆ="
  b"""
    åÝo9IPAD¤=î5\n
    é¦Ì
    """
  b"›ÀlïM.A\x17ºy”Ö¾‰Ät"
  b"""
    Ö€@V\x01\x17Ea´R\n
    ¾ß:2v
    """
  b"^¬ö³düJ\x10±_³@MÖܺ"
  b"Ž\x01œg­†GŽ­\x1D-\x1Es&z‘"
  b"èNݪ`¤BF³ì_7AUÓ\n"
  b"Ç3 ?3[F\x13Ž\v\x03\Æ•³\x03"
  b"lÝ_ƒö\x1DB`‚vì¾¥ÊF;"
  b"×Ü•å?H<¦\x1E×ë†;0$"
  b"͏Ž\x10ÜZO9¾I«@¼bØ"
  b"rS)í–ÄN1¡SÞŠ¹\x1Aë\x0F"
  b"µz^™…bM<±\x0E,[\x1Ayuµ"
  b"‰a|”\x01!@\x13…™˜:JOp{"
  b"d#õªùbB9¸Ê)\ö(*("
  b"«(ß\x16vïBôsªŠOKžÌ"
  b"*àP\x7F´=A¬¾»"èÙ[Æ"
  b"„›\x15U\x01JiµÈ‡?&Ì?é"
  b"Ú 3[\x17I\r®„ŒëªàÍy"
  b"Þ3s\x10€@N Ý¨\x0E˜+^»"
  b"mç70sÔK±–°F—ñ –Þ"
  b"è¹í\x02\x07\x1FJ ‰UwºŸšÃè"
  b"2IE\x16ÿ{Aœ¿N9öôŸ\\x03"
  b"Ìæ‘…\x06‚ED¢¦ÝV3Ajd"
  b"@Ð\x1D\x10<ßMm·\x19ñ:ù~Žè"
  b"Ÿ?ãl¦LAu®8N¤‰«h÷"
  b"«Þö}\x06ŽF®ƒÅ8u¾}j“"
  b"ªj‰\Ž_IÀš1eW—ÝM"
  b""~TJžæF¸µiE\fýYÁÿ"
  b"""
    fñ¸¡ø“C»”* ½\n
    ,äŒ
    """
  b"5‘©\x07‹\x07Fº/êv-Ë\x14\x01"
  b"ñ®zî C®Žhù%ù&Éá"
  b"e/<^öH\x17ž>»I¿ea'"
  b"+!-a(\x1AJ ¥;Ímàù"â"
  b"Qrû\x05x\x02B±´ž¹Ó7\x1F$V"
  b"à>€(\eVG‰‚3¾…×|¿î"
  b"\x1Aû|\f›As¤cì'3°R¬"
  b"6\x1A\x01<‚€DùÃs£”ù\x11Ã"
  b""\x0E\t\x0FßGκ,ƒ\tÁÝ©"
  b"‚¤ý#(\x1CJažq¢¾?\x19\x7F*"
  b"—lY7Ñ)NWÃËù‘ƒtb"
  b"ñ¶‡ˆVŽI“©Ž¯\x15E\x12|\t"
  b"ÔL‚ÝËVB¦¢úü[ \f<;"
  b"º³©ÄÃ÷E\x1EÚ!JÃP+†"
  b"$ײ.¿ÉLO“ÛÐ4­8Åì"
  b"ë\¿oú/@K‹Qµô_Öîf"
  b"ˆ-'\Ô^C\x03²Žs/‚\x16–e"
  b"\x0EÝ#·x¨N\x08Œ)þ0AX\x1A\x06"
  b"?‹\x12¥P˜N3´\x1A\x02@ª\r1b"
  b"ØPr\tD#IcêboÆþ™\x15"
  b"ö*\x12àÌÊJ0¥™¼•‹Þ*œ"
  b"HÄ¡p¤CL½µù®\x14/6–\x06"
  b"èá²ÞœøLÔ€\x7FD˜\x02ÂJ\x1F"
  b"ÿ¶Â(#éE^’0ëW\x16jãÿ"
  b"\x08rñ€ûyJä—êÕHôA\e6"
  b" M0–ÁäFFŽÌÈâ…†qå"
  b")‚h(>üJdœ2U3¤Îz"
  b"""
    =CmFc­@\x1A»\Ò\n
    Df-š
    """
  b"ªÆÔT0Mz‡ù€\x08·ö­"
  b"Ðå:G˜öD}«ÀW¿µà»5"
  b";®Þo\x1F¡O¡¡w\x0E\x0Eqž\x1FÜ"
  b"^,\x07iÖ‚Eð±’ºèºÔ\x0FA"
  b"Ï\x14‰ªPŽO€»\x16P–ì,P"
  b"€»1\x00\x1AHý\x1C\eÀfš\x07G"
  b"F†çxµK\x1C“B­o\x1AG÷\r"
  b"udø\x18¶šDþ‹‹¯\rãž\x04\x06"
  b"Þ¼œ\x15æÊAÅ”+(\x1Fñ\x15I7"
  b"\x17 Ÿ\x00œ=Iyå¾ÒV“yƒ"
  b"ui‘\x11[IE¾¶ØÏ:¼hBá"
  b"Ё†´ ÊGKš°ô\x00{cÃx"
  b"³Ë+\v´(Gô“È\x133Ž8ž"
  b"\x13ÿ|Ö©KCòŸLLD{aI\x06"
  b"Rus½×Or¸Ùä\x13ÃÛnQ"
  b"ç\x1A\ó‡£J,§â¥¸¬\x16$'"
  b"i«Pì8éHÙ¸£Ä¸‚Šîœ"
  b"""
    ~çº\x06ÞnNh¢Š» Ô\n
    ό
    """
  b"$#"Ï\x1D\x03HD•«/¤ÿÈw˜"
  b"ÿ{i“\x1DÔD{’ çžßçí\x04"
  b"‡\x03(®-OG\r¯­Ë”\x17:Œð"
  b"ĆF‚îi@O‘Ý[öþ¬Þª"
  b"öN)À:ëNGš7ø‚½\x19Vˆ"
  b"š\x00xÓÑ\x08Mƒ­ê·\x18Y%5ã"
  b"\x1AŠ—·lóOu–q–\x01M\x00.Œ"
  b"P±®Ý¦vHC$±Ñ‘\x08¹\e"
  b"Q¤h/ü–Bpµ2]´¶I´"
  b"øL®kµWL߆©ÒjžÈÔç"
  b"ýa¾ÕýïDG»\x07œþü\x0FõV"
  b"\x0ErFt•GO\f¢Ž1\x00‰4:}"
  b"ü´…4¼¨@©·ž²Õù$"
  b"'Zá*ÿÐJ{¬‘p_·ê÷L"
  b".\x12*‚Q>GC6$Ä®¾ù\x13"
  b"\x00Ö\x06ûYûG4™7ÆÖa‚*ð"
  b"\ˆÄPBÝH~ƒs~ê?šõë"
  b"\x06›¦Žú[@$°ãG¿Œ¶Ò¿"
  b"cÒtû.\x11DóŽÏT{è\.ê"
  b"ú©ÇmÓ\x05A\t©\x14ë<¤BwÊ"
  b"\x04ö!2\x1A‚Eg›Œ_¼v•úA"
  b"å*ƒPPžB6ŽÕöþ9±DË"
  b"¼œþo72K¡¬J''Úœ?:"
  b"ÙÌ5]ü¿F\x03q=\x1F6]Ñ©"
  b"%\x10¸éý@Lg´‡\x0Flgoµœ"
  b"¸a‡\x7FÛ¡D·²Ç|ø^\x1C¯Õ"
  b"›—|ú\x10ACUŒ5[ãÉñ1&"
  b"\e'ÞR÷MJ8¬óN–¡ŒH$"
  b"_ƒ^6mœL1­do:MKŽ>"
  b"ÜQ¥Q\x042CŽ¦Tù\x02´\t¯›"
  b"""
    ›³\n
    \x08—7E=Áó™ü´ë
    """
  b"Üa›í¶\tOV½ìƒçå†\x14s"
  b"”…¦ôùUD–»ðE\x06³†[–"
  b"Œ—ÚÓR·Og¥\x07\x17‘—©)="
  b",\x18›\x17¸ûC^µ\x15Tø²>p¾"
  b"üjצÊÒK»žÑŽ¥\x1FÏÚŠ"
  b"-Ž€vÔüA—œ7ll[C·ž"
  b"|Ì\x13‘\…JGš&lÜŒ\ÓÄ"
  b"\x01iÁÆH%H4”7q·÷\x14\x15¹"
  b"‹!Yïq˜Cn¨\x0E2KïÂ/`"
  b"ªšV\x124øF÷ƒßž?Çþ\x14\"
  b"FZuj[hBšØ׊ã¥KÎ"
  b"""
    P=¨OŒÓK8˜\n
    qØžW[”
    """
  b"ü›Ë¤>ÎDB¹Çy–¡.0„"
  b"%‚‘j\x10¡JD§;öø÷Eã§"
  b"²Q¥`§iFÿŽ’U¼mŸ¾Ï"
  b"Ý×\x15w1“JJ“fŸ\x7F§Ê½Û"
  b"\x1CX¨<¦\rG\x1Aª\vèi2gng"
  b"€¶M7!NK¿€ŽÚ@\x1F&È—"
  b"¨€5Yå\x12Eî£è!šÕ\t˜º"
  b"\x1Dó-övLB¿‹vf\x11Y\x07"
  b"®,òÖµSC`”ïoê\x17§™‰"
  b"^‹þ>§õ@ú¬\x18\x01\v¤(­"
  b"eŠ:ê\x07\x00G2¦;HGŽ&Px"
  b"\¶:+4×Hu±£öúöŒ+Ÿ"
  b"Ô+)”áËB\«\x13ÌË‘ë;¶"
  b"ªÓ^¥{ù@\t·¿œD;Û†!"
  b"\x15«CºaîBû“†n,ŽX'$"
  b"•Dûø¢mHHBÓ\x00\x02—\tI"
  b"C\vÍ:Ô¯@ù¼ú–\x06çøê"
  b"ƒAÑztžC“·jÌ4UE”¢"
  b"ìf\x14§‰”Lî·V7Më“Ðï"
  b"""
    lÄ\x1E!\n
    ¹AD²i‡\rg\x15[
    """
  b"T¯j\x18¸ÙAÄ´TL¯+þw"
  b";vŽèÚvI†ƒ+Šb\x03îÕÁ"
  b"ž\x1D‚7@@Qµ\x1FK\x06\x1D“üÐ"
  b"‚TB™yêA\v¥÷¥÷¿oC"
  b"-v3Œ8'I1¤Åñ;AõƒÀ"
  b"j=²TÎÀHž‘Ÿ*\f \x1C4\x02"
  b"ÚBÚ’$=L[ƒš`\x0E\x7F%"o"
  b"7¬z"†H@\x05¦×ÉŽâ‰46"
  b"„vÏ™ÚëOÔ–\x10t¸\x7FÌŠ€"
  b"¸¨(\v0qGŠ¾j4\x1D¯QGÝ"
  b"[Ž`7:GNºSÀTW®°P"
  b"0 ¯ÐiôCv¤Ôœ\x07&\x04Óá"
  b"Á¶VR½<Ep¥‚…88÷õ¿"
  b"\tŽþÆ¶G3¯6\x16\x18*éÔJ"
  b"""
    J—hœbãA\x1C²ˆÆØ\n
    È+|
    """
  b"OáLqCÒBr€ß°\x17UŽ0-"
  b"¤¡1£‚ªM¨“Z^âY\x1FM³"
  b"\x16§Å“1†En¢+¸ŽzT:D"
  b"Û_ÎJú`Bß·òí픸Gê"
  b"ùNï¢cŽI!ŽÀxë\váD©"
  b"Í0×µT4Bî¿mÌÖŽ&º­"
  b"\x17ˆÒ\x01^~OX·pð_^0½Õ"
  b"a½\x00†ŒGm£‰\x0E»\x18¿dè"
  b"›®\rWVäN\x05¾\x0EÀøN¾å˜"
  b"\x01T™µ@yMû™…|õJ7ÃQ"
  b"4L*ªÁ\x12K»™€µ×\e¾¬?"
  b"""
    ëÖû¶\n
    PDtœW\x03\x1FÍAµõ
    """
  b"y§Kqw•KN™\x1EcbMš\r"
  b"rºÄ´ž½M\x1C³+mÒNù†È"
  b"õ8\ty\vI(Y«5òÉ0Š"
  b"z5¢\x1Dý;D\x1Dˆ%×0Ùˆûq"
  b"²:\x00å€EN‹‘9Œ\x07\x01*·L"
  b"¨ö}q«åKÏš æ§Z‰&¾"
  b"&$ºž_PI°«qà\x04BŽªª"
  b"ûŽ07-¢Cˆ¿rÅÿ0æ9@"
  b":`•þêøH$¨4\x13‡Â\x12B/"
  b"]ñ»ràíFZ­ÐqgµJÃ'"
  b"9ò;U··HÞ„®w–«\x18‡,"
  b"‡h)\\x02\x00JŸ¼•éØò¼°b"
  b"j¬?\x04³XOl‚J2T3!ç"
  b"\x0F¨ðŽF¨J2¼xO™ã' \x1E"
  b"F“‹\x1C§@?£wÍ*Zo½è"
  b"ªˆ\x155\rÊNz”Ô\x15´ÎŒG\r"
  b"""
    â:Ÿ\n
    ]ØIÞ‰–Ë.\x146ÒG
    """
  b"϶mMïùIÛµš‚ÅtŠD"
  b"\x00-À\x7F?æAs­ñKFÈ\x17\x11g"
  b"""
    Ìô÷¡Þ2F\x18«Ö\x18G\x0F\n
    [\x1F
    """
  b"$aÿ?ä(C5—‹§<B\vY…"
  b"«wßSŽuD­C\w2Ö\x11œ"
  b"Šý•ã¢^F £Š±Î\x02‡íÔ"
  b"vÖ¶íÎ\x1AA㾃ˆ NïS§"
  b"0\x05°ÿ~F\x17¸¬¹oasßy"
  b"ÿoñUê.C4›i,Sn\x11\x13"
  b"Ʊ/~äiNé\x11\x01=Ì9%\x1E"
  b"\x1F\x02$ ë B\x1EšÕÙ7`Ê™þ"
  b"e?½\x07’ƒNBŽìå¢Ý\x05c~"
  b"¯²\x12W\r¡J:´¦¢ÚÇ~øX"
  b"""
    d?˜°™ÙM\n
    ŒÍÅ\x13\x1E—=´
    """
  b"MI}€‡íNŠ¢§ý7\x16©³Z"
  b"\x07ö‰ÿÎæE\x19µ†èÐœLÖ½"
  b"Q¶»(ËÕCl”ê\x15TÂ\x12ÊÞ"
  b"ÏõU\x1F3¤@»¦•\x12fŽ%À§"
  b"\x19\x7Fεå™@œš\x7F\x14H\f±ÙS"
  b"­ñez\x00\nHH¢TlÇt…f€"
  b"€ ÏˆòH\x14‰®ù¯\x10Om"
  b"lÉçÌ 8J\x04Š§·ñ”u×6"
  b"\x17À«\x18¼xL5•Žº\fçIQ>"
  b"=Û\vü#pI¹¡™­î7û\x16\x05"
  b"ÃÐ@\x1DéùD>¥({‹ÄÛç"
  b"{—"® ‡L˜‡+¸×;®x™"
  b"—e¤û\x02ñB‹–i[ñ«W%¡"
  b"=ÑwLŸ]L—Ÿòð\x00–ÿ^\x12"
  b"éÊ“HúDND²ø,Ú?\x1C”z"
  b"@¬Læ\x1A÷A­ž¹6?ÈGöÌ"
  b"¬ŽÑ\x07~nD\x16›.óe‚߸ò"
  b"\x11ä@ÏmÑJ™»\x17ùA7‚Zˆ"
  b"½\x13¯\x08ŽóD6ž´¹ÊËö¡Ÿ"
  b"¦ððëæ—Iô•‰Gh"Žœ?"
  b"-ù„íËzA΁‹JÔ£\x17Y("
  b"F®\x03:xÆLX¥åQëš–Âv"
  b"ý²ÙüsºAˆ€r5^Õû­"
  b"¹Ã}³\x1DîJlœy{l& .\r"
  b"^ËMQ0)KŠ«È̱1†\x07‚"
  b"G‡e½¾¢D˜·h6›Éöº„"
  b"¨…Ï‘ñAEœ­\x7F¢Ô­°¹"
  b"\x05ŒMÜ\x1F\x10I\x00‡R€Äý˜\x13\x7F"
  b"᪯ÂÈLJuŒ\x17á—º1œ˜"
  b",É.±IeG;‰“Ù\õ­Ñ7"
]
View formatted query    View runnable query    Explain query    View query backtrace
8.05 ms
(11.43%) 		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: 
[
  "/cbax/manufacturer/detail/d5fbaa6027d645b5abab57e1ef0ff34f"
  "/cbax/manufacturer/detail/d1635ab4f4f34fefa3a0497a17e74265"
  "/cbax/manufacturer/detail/eeb3b38dcb52408487ca66d608ee2247"
  "/cbax/manufacturer/detail/b19bf11d802d4e91a686fd4a69b97e02"
  "/cbax/manufacturer/detail/5869a7fb498a4c80bbda3264dba1dfdb"
  "/cbax/manufacturer/detail/0a6bbab17a9b482e86fc45ebb35a9a76"
  "/cbax/manufacturer/detail/dafeb3e52d504e318521e35eeb58b41d"
  "/cbax/manufacturer/detail/da1e99ed2a7847c89c98dd95b8efe73b"
  "/cbax/manufacturer/detail/bb16c5d4373a4493976588ea2ea38cc9"
  "/cbax/manufacturer/detail/9e196431e0fc4ecca6d2ee345e0710f6"
  "/cbax/manufacturer/detail/6cd4c4f2070741afa584d6c5a696a2c4"
  "/cbax/manufacturer/detail/4e0097ab653b41b7b1d990a7da688b5e"
  "/cbax/manufacturer/detail/1ec2364693504b2887f75bd9b7f12f44"
  "/cbax/manufacturer/detail/523ea68ba7984e5eae11584ecc403ad4"
  "/cbax/manufacturer/detail/bd626704d639435ca21bc5a037103844"
  "/cbax/manufacturer/detail/5afe5fcd0ef0425b8470c0c372f13926"
  "/cbax/manufacturer/detail/018bcd875695714da2952de10ba009f8"
  "/cbax/manufacturer/detail/815048cdf99c43f18320b99b22276a51"
  "/cbax/manufacturer/detail/475fbb95c5aa4cf89b56c9a0ce1179de"
  "/cbax/manufacturer/detail/5bf3d1a1595e4e5bb1912a96426b23a3"
  "/cbax/manufacturer/detail/1208c1d7d32e4dcebe0c4009159f6be0"
  "/cbax/manufacturer/detail/9bc52e44238947ab9316d2b5eb883a6b"
  "/cbax/manufacturer/detail/df8911b70e8e4741848c86b6fa1cc821"
  "/cbax/manufacturer/detail/a5bf4571627a42a9b47861977cb87fce"
  "/cbax/manufacturer/detail/ab588060f81243d9b0d79bc67cc94c07"
  "/cbax/manufacturer/detail/7d1bd1d9b5984237a9487cd4fdf322ff"
  "/cbax/manufacturer/detail/735d1cb249b5489f8c4d649399a77f7a"
  "/cbax/manufacturer/detail/c4add28b452d41a386695a45d5ad34ec"
  "/cbax/manufacturer/detail/be4e89e8ce1c49b4a31a984e26dd4c86"
  "/cbax/manufacturer/detail/aa7b8b9c3bec4f16a0a41e3ee1d31c9c"
  "/cbax/manufacturer/detail/1f5bc2b3966641e5a7fbc781df648d15"
  "/cbax/manufacturer/detail/2ecc6761d5f0438895d006e65f37d33e"
  "/cbax/manufacturer/detail/6959d81bec954386a083e776008f8a97"
  "/cbax/manufacturer/detail/ca0b67d20e90471487addc335c10e7f6"
  "/cbax/manufacturer/detail/265f9ca5648e445aa98f2d5154c34d13"
  "/cbax/manufacturer/detail/5a127c74fc12487fb4d3928562b85731"
  "/cbax/manufacturer/detail/3a806793ea724c2f9b76f2b5aff4c46f"
  "/cbax/manufacturer/detail/410a6ae708844605979e6d346e49e60e"
  "/cbax/manufacturer/detail/4599d238431f4460baff49222abba15f"
  "/cbax/manufacturer/detail/42911ef25ddf45f29ce0d1752952062f"
  "/cbax/manufacturer/detail/2fb5fe3ca1444b148545de2aa4235ba2"
  "/cbax/manufacturer/detail/739994b277b54df6ae4d573aaca2edc8"
  "/cbax/manufacturer/detail/36e5fd64fd4c4042bf209d549bb432f5"
  "/cbax/manufacturer/detail/8c374519f9e24404bdf983d1b34b9daa"
  "/cbax/manufacturer/detail/ee4b74d2bd7045bd96a8f6ad02e30477"
  "/cbax/manufacturer/detail/859655cf298d4851bc8e2017e3d664b4"
  "/cbax/manufacturer/detail/405a191baef64b38952146bf1ca91aa6"
  "/cbax/manufacturer/detail/018c441be8657e528d2b1219c296fee5"
  "/cbax/manufacturer/detail/b58a9bce2459477b84fb5a95a8973050"
  "/cbax/manufacturer/detail/7b9978ac6e8d4728beebc37104112a5a"
  "/cbax/manufacturer/detail/c4ff1e35881f4ff792adf7985f181797"
  "/cbax/manufacturer/detail/931fdaef057c422a8af056928f1e48d7"
  "/cbax/manufacturer/detail/374faeb6cca84a9b9a7659b5d2242d9f"
  "/cbax/manufacturer/detail/aa3cfcf7c7974ea09c4366a87277b001"
  "/cbax/manufacturer/detail/dcda744d262c4142ad6beeee73793115"
  "/cbax/manufacturer/detail/31daa6bc836c481896b234f51e36c544"
  "/cbax/manufacturer/detail/a2fd70ce65964cde8fff9854e0a36385"
  "/cbax/manufacturer/detail/5ebf819ca556460c99dc93b910f57a5a"
  "/cbax/manufacturer/detail/57400a4796084a8aa4595689d4ba5d76"
  "/cbax/manufacturer/detail/74b926f20a8d49228d3ef09d957fd6db"
  "/cbax/manufacturer/detail/db7c62df8dd8454e862791328f46a1ec"
  "/cbax/manufacturer/detail/3750bb34001e4979abdd0fbebf994d8f"
  "/cbax/manufacturer/detail/63dcc50c49b74b83b243109b01a93a1f"
  "/cbax/manufacturer/detail/faa980dd73f145e199b42caaf798ebab"
  "/cbax/manufacturer/detail/938626621efc40b8a367c25d753bb7de"
  "/cbax/manufacturer/detail/8a252ef9216247cbafa96df09cf7ea04"
  "/cbax/manufacturer/detail/ca40e94f38c047ec80747c58e0754b0d"
  "/cbax/manufacturer/detail/86dc6c93738540319d11887b6c65376b"
  "/cbax/manufacturer/detail/f559d5f1657546d4b93a7e1745f8bf48"
  "/cbax/manufacturer/detail/10cfa7ac9e554150b692d5ea9e6e2c3b"
  "/cbax/manufacturer/detail/47fb1109aa684612a6a2daf28e593b5b"
  "/cbax/manufacturer/detail/cc0d85ca3c584181bca8a209bd7dbf8b"
  "/cbax/manufacturer/detail/289db01f250d4cdabeebd27d28725217"
  "/cbax/manufacturer/detail/ecdff3672bf94653b0cfe1c209960fb6"
  "/cbax/manufacturer/detail/c96b58df371a4d55a5cec0defaafa76c"
  "/cbax/manufacturer/detail/89460e34c4a0461eab536bbf376f6c6b"
  "/cbax/manufacturer/detail/018c4378f5cf70a783759a7e80a1a01a"
  "/cbax/manufacturer/detail/949abca62485457fb86cb8efe2e9ff85"
  "/cbax/manufacturer/detail/e9b8527dfe044906a88cf7506b19400e"
  "/cbax/manufacturer/detail/9f8198fc36144ed8a9d9e1571239881a"
  "/cbax/manufacturer/detail/0e31b7ad6ead4816bfe7d2bb4c65bedb"
  "/cbax/manufacturer/detail/8f39bec7a8a245dd8070374c6404b9b4"
  "/cbax/manufacturer/detail/48a50ac3a70743edb5396c025e42cda3"
  "/cbax/manufacturer/detail/698f1c1d186143638fc5d6fdde4be202"
  "/cbax/manufacturer/detail/129c833aa99e4a1ab8a54247b29d93ca"
  "/cbax/manufacturer/detail/007a43f797bb4e738a83a7de39bc27d7"
  "/cbax/manufacturer/detail/cdfc83f95110462a849b647cb8362d5f"
  "/cbax/manufacturer/detail/2248c51b07734ea29b170166f7e979a1"
  "/cbax/manufacturer/detail/0380d931227043acb94229c97a8e4741"
  "/cbax/manufacturer/detail/7ce67a573159472aba438c08d58ae9a0"
  "/cbax/manufacturer/detail/43a11388617f42c48178bb924ecba49e"
  "/cbax/manufacturer/detail/e14cae41374446e783eb179e6d21cf06"
  "/cbax/manufacturer/detail/f869cdebb03a454d81915a38c99d377c"
  "/cbax/manufacturer/detail/e4b4c489bfe747adae15eec432fa99c0"
  "/cbax/manufacturer/detail/770dd3f5ff404f4c90e236154da5823b"
  "/cbax/manufacturer/detail/e8aeefe56b7240cebf6bf194b2631b4d"
  "/cbax/manufacturer/detail/19f476b3d35e4c26a5fc3a87c28c7a8e"
  "/cbax/manufacturer/detail/24c86d2e46e94c72938496fac806353c"
  "/cbax/manufacturer/detail/bc8ea623807c4e53b1468745871c01bb"
  "/cbax/manufacturer/detail/53098d940f4b474e80450478ee63ab1d"
  "/cbax/manufacturer/detail/72fb8c5c91e64230bfa9ea4a4d50f27d"
  "/cbax/manufacturer/detail/defc559d334446699b336ee166aac63d"
  "/cbax/manufacturer/detail/e5dd6f3949504144a43dee350ae9a6cc"
  "/cbax/manufacturer/detail/d680405601174561b4520abedf3a3276"
  "/cbax/manufacturer/detail/5eacf6b364fc4a10b15fb3404dd6dcba"
  "/cbax/manufacturer/detail/e84eddaa60a44246b3ec5f374155d30a"
  "/cbax/manufacturer/detail/d7dcc295e53f483ca61ed7eb863b3024"
  "/cbax/manufacturer/detail/cd8f8e10dc5a4f39be4981ab40bc62d8"
  "/cbax/manufacturer/detail/725329ed96c44e31a153de8ab91aeb0f"
  "/cbax/manufacturer/detail/89617c94012140138599983a4a4f707b"
  "/cbax/manufacturer/detail/6423f5aaf9624239b8ca295cf6282a28"
  "/cbax/manufacturer/detail/2ae0507fb43d41acbe90bb22e8d95bc6"
  "/cbax/manufacturer/detail/c2849b1555014a69b5c8873f26cc3fe9"
  "/cbax/manufacturer/detail/daa0335b8f17490dae848cebaae0cd79"
  "/cbax/manufacturer/detail/6de7373073d44bb196b04697f12096de"
  "/cbax/manufacturer/detail/e8b9ed02071f4a20895577ba9f9ac3e8"
  "/cbax/manufacturer/detail/32494516ff7b419cbf4e39f6f49f5c03"
  "/cbax/manufacturer/detail/cce6918506824544a2a6dd5633416a64"
  "/cbax/manufacturer/detail/9f3fe36ca64c4175ae384ea489ab68f7"
  "/cbax/manufacturer/detail/aa6a895c8d5f49c09a3190655797dd4d"
  "/cbax/manufacturer/detail/227e544a9ee646b8b569450cfd59c1ff"
  "/cbax/manufacturer/detail/66f1b8a1f89343bb942aa0bd0a2ce48c"
  "/cbax/manufacturer/detail/f18fae7aeea043ae8e68f925f926c9e1"
  "/cbax/manufacturer/detail/5172fb05780242b1b49eb9d3371f2456"
  "/cbax/manufacturer/detail/8f1afb7c0c9b4173a463ec2733b052ac"
  "/cbax/manufacturer/detail/361a013c828044f98fc373a394f911c3"
  "/cbax/manufacturer/detail/220e090fc39f47ceba2c8309c1dda99d"
  "/cbax/manufacturer/detail/82a4fd23281c4a619e71a2be3f197f2a"
  "/cbax/manufacturer/detail/976c5937d1294e5781c3cbf991837462"
  "/cbax/manufacturer/detail/f1b68788568e4993a98daf1545127c09"
  "/cbax/manufacturer/detail/24d7b22ebfc94c4f93dbd034ad38c5ec"
  "/cbax/manufacturer/detail/eb5cbf6ffa2f404b8b51b5f45fd6ee66"
  "/cbax/manufacturer/detail/882d275cd45e4303b28e732f82169665"
  "/cbax/manufacturer/detail/0edd23b778a84e088c29fe3041581a06"
  "/cbax/manufacturer/detail/f62a12e0ccca4a30a599bc958bde2a9c"
  "/cbax/manufacturer/detail/ffb6c22823e9455e9230eb57166ae3ff"
  "/cbax/manufacturer/detail/0872f180fb794ae497ead548f4411b36"
  "/cbax/manufacturer/detail/298268283efc4a649c325533a4ce817a"
  "/cbax/manufacturer/detail/3baede6f1fa14fa1a1770e0e719e1fdc"
  "/cbax/manufacturer/detail/5e2c0769d68245f0b192bae8bad40f41"
  "/cbax/manufacturer/detail/7564f818b69a44fe8b8baf0de39e0406"
  "/cbax/manufacturer/detail/17209f009c3d49799de5bed256937983"
  "/cbax/manufacturer/detail/756991115b4945beb6d8cf3abc6842e1"
  "/cbax/manufacturer/detail/d08186b4a0ca474b9ab0f4007b63c378"
  "/cbax/manufacturer/detail/b3cb2b0bb42847f49d93c813338e389e"
  "/cbax/manufacturer/detail/13ff7cd6a94b43f29f4c4c447b614906"
  "/cbax/manufacturer/detail/52759073bdd74f72b8d9e413c3db6e51"
  "/cbax/manufacturer/detail/e71a5cf387a34a2ca7e2a5b8ac162427"
  "/cbax/manufacturer/detail/7ee7ba06de6e4e68a28abb20d40acf8c"
  "/cbax/manufacturer/detail/242322cf1d03484495ab2fa4ffc87798"
  "/cbax/manufacturer/detail/870328ae2d4f470dafadcb94173a8cf0"
  "/cbax/manufacturer/detail/f64e29c03aeb4e479a37f882bd195688"
  "/cbax/manufacturer/detail/9a0078d3d1084d83adeab718592535e3"
  "/cbax/manufacturer/detail/1a8a97b76cf34f75967196014d002e8c"
  "/cbax/manufacturer/detail/50b1aedda67648438f24b1d19108b91b"
  "/cbax/manufacturer/detail/51a4682ffc964270b5325db4b64990b4"
  "/cbax/manufacturer/detail/f84cae6bb5574cdf86a9d26a9ec8d4e7"
  "/cbax/manufacturer/detail/fd61bed5fdef4447bb079cfefc0ff556"
  "/cbax/manufacturer/detail/0e72467495474f0ca28d310089343a7d"
  "/cbax/manufacturer/detail/275ae12affd04a7bac91705fb7eaf74c"
  "/cbax/manufacturer/detail/069ba68dfa5b4024b0e347bf8cb6d2bf"
  "/cbax/manufacturer/detail/63d274fb2e1144f38ecf547be85c2eea"
  "/cbax/manufacturer/detail/04f621321a8245679b8c5fbc7695fa41"
  "/cbax/manufacturer/detail/e52a8350509e42368dd5f6fe39b144cb"
  "/cbax/manufacturer/detail/bc9cfe6f37324ba1ac4a2727da9c3f3a"
  "/cbax/manufacturer/detail/d9cc355dfcbf460390713d1f365dd1a9"
  "/cbax/manufacturer/detail/2510b8e9fd404c67b4870f6c676fb59c"
  "/cbax/manufacturer/detail/b861877fdba144b7b2c77cf85e1cafd5"
  "/cbax/manufacturer/detail/1b27de52f74d4a38acf34e96a18c4824"
  "/cbax/manufacturer/detail/5f835e366d9c4c31ad646f3a4d4b8e3e"
  "/cbax/manufacturer/detail/9bb30a089737453d9d81c1f399fcb4eb"
  "/cbax/manufacturer/detail/dc619bedb6094f56bdec83e7e5861473"
  "/cbax/manufacturer/detail/9485a6f4f9554496bbf04506b3865b96"
  "/cbax/manufacturer/detail/2c189b17b8fb435eb51554f8b23e70be"
  "/cbax/manufacturer/detail/2d8d8076d4fc41979c376c6c5b43b79e"
  "/cbax/manufacturer/detail/7ccc13915c854a479a266cdc8c5cd3c4"
  "/cbax/manufacturer/detail/aa9a561234f846f783df9e3fc7fe145c"
  "/cbax/manufacturer/detail/465a756a5b6842c29ad8d78ae3a54bce"
  "/cbax/manufacturer/detail/fc9bcba43ece4442b9c77996a12e3084"
  "/cbax/manufacturer/detail/b251a560a76946ff8e9255bc6d9fbecf"
  "/cbax/manufacturer/detail/ddd7157731934a4a93669f7fa7cabddb"
  "/cbax/manufacturer/detail/80b64d37214e4bbf808eda401f26c897"
  "/cbax/manufacturer/detail/a8803559e51245eea3e8219ad50998ba"
  "/cbax/manufacturer/detail/ae2cf2d6b553436094ef6fea17a79989"
  "/cbax/manufacturer/detail/5e8bfe3ea7f540faac18010b81a428ad"
  "/cbax/manufacturer/detail/658a3aea07004732a63b48478d265078"
  "/cbax/manufacturer/detail/d42b2994e1cb425cab13cccb91eb3bb6"
  "/cbax/manufacturer/detail/aad35ea57bf94009b7bf9c443bdb8621"
  "/cbax/manufacturer/detail/430bcd3ad4af40f9bcfa9606e7f8ea8f"
  "/cbax/manufacturer/detail/54af6a18b8d941c384b4544caf2bfe77"
  "/cbax/manufacturer/detail/3b768ee8da764986832b8a6203eed5c1"
  "/cbax/manufacturer/detail/2d76338c38274931a4c5f13b41f583c0"
  "/cbax/manufacturer/detail/da42da92243d4c5b839a600e7f25226f"
  "/cbax/manufacturer/detail/8476cf99daeb4fd4961074b87fcc8a80"
  "/cbax/manufacturer/detail/b8a8280b3071478abe6a341daf5147dd"
  "/cbax/manufacturer/detail/5b8d609d373a474eba53c05457aeb050"
  "/cbax/manufacturer/detail/3020afd069f44376a4d49c072604d3e1"
  "/cbax/manufacturer/detail/c1b65652bd3c4570a582853838f7f5bf"
  "/cbax/manufacturer/detail/098dfe9dc6b64733af3616182ae9d44a"
  "/cbax/manufacturer/detail/4a97689c62e3411cb288c6d80ac82b7c"
  "/cbax/manufacturer/detail/4fe14c7143d2427280dfb017558e302d"
  "/cbax/manufacturer/detail/a4a131a382aa4da8935a5ee2591f4db3"
  "/cbax/manufacturer/detail/16a7c5933186456ea22bb88d7a543a44"
  "/cbax/manufacturer/detail/f94eefa2638d49218dc078eb0be144a9"
  "/cbax/manufacturer/detail/1788d2015e7e4f58b770f05f5e30bdd5"
  "/cbax/manufacturer/detail/9d61bd00868c476da3890ebb18bf64e8"
  "/cbax/manufacturer/detail/9bae0d5756e44e05be0ec0f84ebee598"
  "/cbax/manufacturer/detail/344c2aaac1124bbb9980b5d71bbeac3f"
  "/cbax/manufacturer/detail/72bac4b49ebd4d1cb32b6dd24ef986c8"
  "/cbax/manufacturer/detail/f538099d790b49289059ab35f2c9308a"
  "/cbax/manufacturer/detail/7a35a21dfd3b441d8825d730d988fb71"
  "/cbax/manufacturer/detail/b23a00e580454e8b91398c07012ab74c"
  "/cbax/manufacturer/detail/2624ba9e5f5049b0ab71e004428eaaaa"
  "/cbax/manufacturer/detail/fb8e30372da24388bf72c5ff30e63940"
  "/cbax/manufacturer/detail/3a6095feeaf84824a8341387c212422f"
  "/cbax/manufacturer/detail/5df1bb72e0ed465aadd07167b54ac327"
  "/cbax/manufacturer/detail/39f23b55b7b748de84ae7796ab18872c"
  "/cbax/manufacturer/detail/6aac3f04b3584f6c824a3290543321e7"
  "/cbax/manufacturer/detail/0fa8f08d46a84a32bc784f99e327201e"
  "/cbax/manufacturer/detail/46938b901ca7403fa377cd2a5a6fbde8"
  "/cbax/manufacturer/detail/aa8815350dca4e7a94d415b4ce8c470d"
  "/cbax/manufacturer/detail/e23a9f0a5dd849de8996cb2e1436d247"
  "/cbax/manufacturer/detail/cfb66d4deff949dbb5909a82c5748a44"
  "/cbax/manufacturer/detail/002dc07f3fe64173adf14b46c8171167"
  "/cbax/manufacturer/detail/ccf4f7a1de324618abd618470f0a5b1f"
  "/cbax/manufacturer/detail/2461ff3fe4284335978ba73c420b5985"
  "/cbax/manufacturer/detail/ab77df538d754481ad435c7732d6119c"
  "/cbax/manufacturer/detail/8afd95e3a25e46a0a38ab1ce0287edd4"
  "/cbax/manufacturer/detail/76d6b6edce1a41e3be8388204eef53a7"
  "/cbax/manufacturer/detail/30059db0ff7e4617b8acb96f6173df79"
  "/cbax/manufacturer/detail/ff6ff155ea2e43349b692c539d6e1113"
  "/cbax/manufacturer/detail/c6b12f7ee4694ec3a911013dcc39251e"
  "/cbax/manufacturer/detail/653fbd0792834e428eece5a2dd05637e"
  "/cbax/manufacturer/detail/afb212570da14a3ab4a6a2dac77ef858"
  "/cbax/manufacturer/detail/643f98b099d94d0a8ccdc5131e973db4"
  "/cbax/manufacturer/detail/4d497d8087ed4e8aa2a7fd3716a9b35a"
  "/cbax/manufacturer/detail/07f689ffcee64519b586e8d09c4cd6bd"
  "/cbax/manufacturer/detail/cff5551f33a440bba69512668d25c0a7"
  "/cbax/manufacturer/detail/197fceb5e599409c9a7f14480cb1d953"
  "/cbax/manufacturer/detail/adf1657a000a4848a2546cc774856680"
  "/cbax/manufacturer/detail/6cc9e7cca0384a048aa7b7f19475d736"
  "/cbax/manufacturer/detail/3ddb0bfc237049b9a199adee37fb1605"
  "/cbax/manufacturer/detail/9765a4fb02f1428b96695bf1ab5725a1"
  "/cbax/manufacturer/detail/e9ca9348fa444e44b2f82cda3f1c947a"
  "/cbax/manufacturer/detail/11e440cf6dd14a99bb17f94137825a88"
  "/cbax/manufacturer/detail/bd13af088ef344369eb4b9cacbf6a19f"
  "/cbax/manufacturer/detail/a6f0f0ebe69749f495894768228e9c3f"
  "/cbax/manufacturer/detail/46ae033a78c64c58a5e551eb9a96c276"
  "/cbax/manufacturer/detail/fdb2d9fc73ba4188809d72355ed5fbad"
  "/cbax/manufacturer/detail/b9c37db31dee4a6c9c797b6c26202e0d"
  "/cbax/manufacturer/detail/5ecb4d5130294b8aabc8ccb131860782"
  "/cbax/manufacturer/detail/478765bdbea24498b768369bc9f6ba84"
  "/cbax/manufacturer/detail/9da885cf91f141459cad7fa2d4adb0b9"
  "/cbax/manufacturer/detail/e1aaafc2c84c4a758c17e197ba319c98"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ñ\x12Ñê°ÁAŽ˜Á„a`«[\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.71 ms
(6.70%) 		2 
-- header::navigation::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`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"""
    œ}@\f\n
    ¡D÷ŸBސïÉQÛ
    """
  "%|9c7d400c0aa144f79f42de90efc951db|%"
  1
  5
]
View formatted query    View runnable query    Explain query    View query backtrace
2.75 ms
(3.91%) 		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/c40c3a513a6645beb4c7574cb61b75e9"
  "/navigation/d685c82ce3764755bcc28739060a4574"
  "/navigation/3c97eb7c7535443092cc05efe38c9682"
  "/navigation/6463b04019304d939b0a67004ddb04a1"
  "/navigation/e6ffeaf57b6942658aab0e23e29cb1ff"
  "/navigation/1579ffecad8f4476b7fdee0f225ce131"
  "/navigation/70b90726fffd4ade86542aaaddd99345"
  "/navigation/41b2a0cea3ab49248c918d5a5d403f18"
  "/navigation/fc3554f933fa412a96cbeb33888e692b"
  "/navigation/100a9448513a449096d1257c55b6279d"
  "/navigation/d51c452c7d154f3b86116d384e0c4507"
  "/navigation/0f2938353aa54b6ba4688ab4041a08c9"
  "/navigation/af13b8bab7ec40468173597c04726102"
  "/navigation/9601fa9d9d0a4feaa3c015b102296e90"
  "/navigation/a1651b78778d4ffcb6c8d613c31e92a7"
  "/navigation/4246b229d7634de1aff3ed9bbc3bfa2e"
  "/navigation/44cdcab654ff43999f82bf6c703d1895"
  "/navigation/8c33746dad064c2086ab336cf097c4ac"
  "/navigation/b652f69467cb427c8f4dd92f70787ec5"
  "/navigation/39d31a1995474b619a43130545b8f1a3"
  "/navigation/036102f468a64e47a387c2170c17d712"
  "/navigation/742bc754c85d4e5e846b6c18a0cb7ffb"
  "/navigation/4b03ca07c45043f3a415f9c683a31a19"
  "/navigation/d8138422e0894f34a8b3a737aa16ef26"
  "/navigation/b279b2881dd1436c8f6482fa6980f687"
  "/navigation/e0391bfb84204ebda986a75982c91b30"
  "/navigation/669892d0b4814cde93e4aa14f0d1496a"
  "/navigation/59ce07c8201a4ca38dacdf117ca8e100"
  "/navigation/84e5b28a12b3459482b9bd6cf961f525"
  "/navigation/2a6d0aa84c574264bc225087156739b8"
  "/navigation/43cbda344f6f41ab85f19b67f8ad364f"
  "/navigation/427d9ede01de4730b4d29de313d6743c"
  "/navigation/55f90db7e99a460d873d6659d2610493"
  "/navigation/eda66c3a4f3d45799f2d1d237efe93df"
  "/navigation/bcb9cc5a7e3546c7bf252a2ca020f940"
  "/navigation/b99bbcf62e4341d193bae75814745cf9"
  "/navigation/dc5bfefca2a243d88ad9fac711e2a4b2"
  "/navigation/7d15ab0356a1468da1d8ff9ad990de4d"
  "/navigation/6f4dd4e223df49cc9402d67196987ec1"
  "/navigation/fc20ac6822224845b583e9f590a14f03"
  "/navigation/d6900a5de88d48c284116b61e893cfb2"
  "/navigation/924b727cea2f426292292670865600b5"
  "/navigation/559e1e6e1cd24659a605894835cedda4"
  "/navigation/dbec975798684a829f9b6aeaf84301b7"
  "/navigation/253d6a5db66e4e65bc44fa0524bd4a81"
  "/navigation/54e2a717a05f4592ab1bc5a36c4d8602"
  "/navigation/7a7622c5deb442e3aef7a2fd493b5045"
  "/navigation/35d1f3bbe1df449aa3e9b2f412ad86c8"
  "/navigation/957dcf7bd292428983e257dcd25a0f9b"
  "/navigation/0f1bfe7a3ef141d2ae3fd0cbe2f94411"
  "/navigation/8c6564023e0d4832a7cfba507991287e"
  "/navigation/36adfd7f204a41b8965ed0b2c12cbe97"
  "/navigation/5f9fa9754143423fb8b9878d7e71a199"
  "/navigation/1ded223c99a34993ae46f10641ced1a3"
  "/navigation/8f4c78fb983b4c4584002dcbe2943a38"
  "/navigation/79d30b904558471c894861f53b01a913"
  "/navigation/399ccbfd42d04f3f958f4b2438bf8886"
  "/navigation/083cbb8f16be4090a4990031ca43a96a"
  "/navigation/877808f53f6f40e99d375b6276f7c6b0"
  "/navigation/af5a0be44842421d98e673d65e94038d"
  "/navigation/abfa37c7dd1441769787dbd46be9d077"
  "/navigation/a633d1fd8fd04c9d8e5ca7a74111b407"
  "/navigation/38be4dd0eef94b298cb6b2b9dbeea1af"
  "/navigation/f5b8b77cb76b44689777653a0fc54f2a"
  "/navigation/69125696bb1e4a15900b360667ccdcf5"
  "/navigation/2229ae596426490a85dbc3e1dea68eff"
  "/navigation/14f7895c38974b168db7023994f1c22b"
  "/navigation/7b9630b1490d46699c8fcd801bcdc26c"
  "/navigation/12d980ec647a4ae8970d60ae1ad30131"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ñ\x12Ñê°ÁAŽ˜Á„a`«[\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.24 ms
(3.18%) 		1 
SELECT `product_manufacturer`.`id` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.`product_manufacturer_id`, `product_manufacturer.translation`.`product_manufacturer_version_id`, `product_manufacturer.translation`.`custom_fields` as `product_manufacturer.translation.customFields`, `product_manufacturer.translation`.`name` as `product_manufacturer.translation.name` FROM `product_manufacturer_translation` `product_manufacturer.translation` WHERE `product_manufacturer.translation`.`language_id` = ?) `product_manufacturer.product_manufacturer_translation` ON `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product_manufacturer`.`id` AND `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_version_id` = `product_manufacturer`.`version_id` WHERE (`product_manufacturer`.`version_id` = ?) AND ((COALESCE(IF(JSON_TYPE(JSON_EXTRACT(`product_manufacturer.translation.customFields`, '$.cbaxManufacturerPremium')) != "NULL", IF(JSON_UNQUOTE(JSON_EXTRACT(`product_manufacturer.translation.customFields`, '$.cbaxManufacturerPremium')) != "true" AND JSON_UNQUOTE(JSON_EXTRACT(`product_manufacturer.translation.customFields`, '$.cbaxManufacturerPremium')) = 0, 0, 1), NULL)) = ? AND (COALESCE(IF(JSON_TYPE(JSON_EXTRACT(`product_manufacturer.translation.customFields`, '$.cbaxManufacturerIsHidden')) != "NULL", IF(JSON_UNQUOTE(JSON_EXTRACT(`product_manufacturer.translation.customFields`, '$.cbaxManufacturerIsHidden')) != "true" AND JSON_UNQUOTE(JSON_EXTRACT(`product_manufacturer.translation.customFields`, '$.cbaxManufacturerIsHidden')) = 0, 0, 1), NULL)) <=> ? OR NOT (COALESCE(IF(JSON_TYPE(JSON_EXTRACT(`product_manufacturer.translation.customFields`, '$.cbaxManufacturerIsHidden')) != "NULL", IF(JSON_UNQUOTE(JSON_EXTRACT(`product_manufacturer.translation.customFields`, '$.cbaxManufacturerIsHidden')) != "true" AND JSON_UNQUOTE(JSON_EXTRACT(`product_manufacturer.translation.customFields`, '$.cbaxManufacturerIsHidden')) = 0, 0, 1), NULL)) <=> ?)) AND (COALESCE(IF(JSON_TYPE(JSON_EXTRACT(`product_manufacturer.translation.customFields`, '$.cbaxManufacturerSCBlackList')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`product_manufacturer.translation.customFields`, '$.cbaxManufacturerSCBlackList')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL)) <=> ? OR NOT (COALESCE(IF(JSON_TYPE(JSON_EXTRACT(`product_manufacturer.translation.customFields`, '$.cbaxManufacturerSCBlackList')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`product_manufacturer.translation.customFields`, '$.cbaxManufacturerSCBlackList')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL)) LIKE ?)))) ORDER BY COALESCE(`product_manufacturer.translation.name`) ASC
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  1
  null
  1
  null
  "%f112d1eab0c1418d98c1846160ab5b0b%"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.94 ms
(2.76%) 		1 
-- Manufacturer getManufacturerByChar manufacturer::search-ids
SELECT `product_manufacturer`.`id` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.`product_manufacturer_id`, `product_manufacturer.translation`.`product_manufacturer_version_id`, `product_manufacturer.translation`.`name` as `product_manufacturer.translation.name` FROM `product_manufacturer_translation` `product_manufacturer.translation` WHERE `product_manufacturer.translation`.`language_id` = ?) `product_manufacturer.product_manufacturer_translation` ON `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product_manufacturer`.`id` AND `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_version_id` = `product_manufacturer`.`version_id` WHERE `product_manufacturer`.`version_id` = ? ORDER BY COALESCE(`product_manufacturer.translation.name`) ASC
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.72 ms
(2.44%) 		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"+>ý&\x06WA6¾Â\x14ÚÐðW'"
  b"5úòIa¢GI­aaœpü\x18\x7F"
  b"o徘†ò@l¤*ù†$Ñ–·"
  b"¢ŸÕ/\x000AɦȻxUeæb"
  b"Ö4$‚€lE@Œ,mŠ\x07\Pf"
  b"Û"²ÖðÞM†k$$´Ø€K"
  b"\x1F?mq(ÕB@¼¾v¼AÁ¿"
  b"Ì™W!\x14\x00IP€’Ĉ£‰”\x04"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.65 ms
(2.35%) 		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"ñ\x12Ñê°ÁAŽ˜Á„a`«[\v"
  "hersteller"
  "hersteller/"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.53 ms
(2.17%) 		3 
SELECT `seo_path_info` AS seoPathInfo, `language_id` AS languageId
            FROM `seo_url`
            WHERE `path_info` = ? AND `is_canonical` = 1 AND
                  `sales_channel_id` = ? AND `language_id` IN (?, ?)
Parameters: 
[
  "/cbax/manufacturer/index"
  b"ñ\x12Ñê°ÁAŽ˜Á„a`«[\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x19£^绩Aö…^Œ$RçÕ2"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.32 ms
(1.87%) 		3 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"ñ\x12Ñê°ÁAŽ˜Á„a`«[\v"
  "O5sUCvo6ydzRulfx8q8VjvJ0qcC3Icus"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.26 ms
(1.79%) 		4 
SELECT translation_key, value FROM snippet WHERE snippet_set_id = ?
Parameters: 
[
  b"—3Ø—êBý›ÇÜHº\x01ËÅ"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.15 ms
(1.64%) 		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"Ë\x10ƒ¬—\x1FGý‹œÈ&K\x1D“)"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.14 ms
(1.62%) 		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/911d4136608948a097d8dd947fa59750"
  "/navigation/cd07a70b8c5249fab9cca83d4e187ce0"
  "/navigation/aae4940db3c84a1c9d22be3f2b814bd1"
  "/navigation/b669f5a02f84432fb0b7ac5d567e964d"
  "/navigation/bf67fc29143048a0b4b7262cec19d29d"
  "/navigation/e783d2614f624d9a8f7f568a56046b4a"
  "/navigation/058aada99ac74c6caec84aab22a468c2"
  "/navigation/1887972ab586471bbc0e653045253ab8"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ñ\x12Ñê°ÁAŽ˜Á„a`«[\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.13 ms
(1.61%) 		2 
SELECT LOWER(HEX(`category`.`parent_id`)) as `category-ids.key`, COUNT(`category`.`id`) as `category-ids.count`, COUNT(DISTINCT `category`.`id`) as `visible-children-count` FROM `category` WHERE (`category`.`version_id` = ?) AND ((`category`.`path` LIKE ? AND `category`.`level` = ? AND `category`.`active` = ? AND `category`.`visible` = ?)) GROUP BY `category`.`parent_id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  "%|9c7d400c0aa144f79f42de90efc951db|%"
  5
  true
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
1.10 ms
(1.56%) 		3 
SELECT `domain`.`language_id` AS languageId,
                          `domain`.`id` AS id,
                          `domain`.`url` AS url,
                          `domain`.`hreflang_use_only_locale` AS onlyLocale,
                          `locale`.`code` AS locale
            FROM `sales_channel_domain` AS `domain`
            INNER JOIN `language` ON `language`.`id` = `domain`.`language_id`
            INNER JOIN `locale` ON `locale`.`id` = `language`.`locale_id`
            WHERE `domain`.`sales_channel_id` = ?
Parameters: 
[
  b"ñ\x12Ñê°ÁAŽ˜Á„a`«[\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.06 ms
(1.51%) 		4 
#cart-persister::load
            SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters: 
[
  "O5sUCvo6ydzRulfx8q8VjvJ0qcC3Icus"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.06 ms
(1.50%) 		2 
SELECT LOWER(HEX(`id`)) AS `id` FROM `moorl_interrupter` WHERE (`updated_at` IS NULL OR (`show_from` > `updated_at` AND `show_from` < '2025-12-28T09:06:31+00:00') OR (`show_until` > `updated_at` AND `show_until` < '2025-12-28T09:06:31+00:00')) AND `active` = '1';
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.03 ms
(1.46%) 		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"ñ\x12Ñê°ÁAŽ˜Á„a`«[\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.00 ms
(1.42%) 		2 
# navigation-route::meta-information
            SELECT LOWER(HEX(`id`)), `path`, `level`
            FROM `category`
            WHERE `id` = ? OR `id` = ?
Parameters: 
[
  b"""
    œ}@\f\n
    ¡D÷ŸBސïÉQÛ
    """
  b"""
    œ}@\f\n
    ¡D÷ŸBސïÉQÛ
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.99 ms
(1.40%) 		1 
-- Manufacturer getCmsPage::association::sections::association::blocks::association::slots::read
SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `cms_slot`.`type` as `cms_slot.type`, `cms_slot`.`slot` as `cms_slot.slot`, `cms_slot`.`locked` as `cms_slot.locked`, `cms_slot`.`cms_block_id` as `cms_slot.blockId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.swagCmsExtensionsForm`.`id` as `cms_slot.swagCmsExtensionsForm.id`, `cms_slot.swagCmsExtensionsForm`.`cms_slot_id` as `cms_slot.swagCmsExtensionsForm.cmsSlotId`, `cms_slot.swagCmsExtensionsForm`.`cms_slot_version_id` as `cms_slot.swagCmsExtensionsForm.cmsSlotVersionId`, `cms_slot.swagCmsExtensionsForm`.`is_template` as `cms_slot.swagCmsExtensionsForm.isTemplate`, `cms_slot.swagCmsExtensionsForm`.`technical_name` as `cms_slot.swagCmsExtensionsForm.technicalName`, `cms_slot.swagCmsExtensionsForm`.`mail_template_id` as `cms_slot.swagCmsExtensionsForm.mailTemplateId`, `cms_slot.swagCmsExtensionsForm`.`created_at` as `cms_slot.swagCmsExtensionsForm.createdAt`, `cms_slot.swagCmsExtensionsForm`.`updated_at` as `cms_slot.swagCmsExtensionsForm.updatedAt`, `cms_slot.swagCmsExtensionsForm.translation.title`, `cms_slot.swagCmsExtensionsForm.translation.title` as `cms_slot.swagCmsExtensionsForm.title`, `cms_slot.swagCmsExtensionsForm.translation.successMessage`, `cms_slot.swagCmsExtensionsForm.translation.successMessage` as `cms_slot.swagCmsExtensionsForm.successMessage`, `cms_slot.swagCmsExtensionsForm.translation.receivers`, `cms_slot.swagCmsExtensionsForm.translation.receivers` as `cms_slot.swagCmsExtensionsForm.receivers`, `cms_slot.translation.config`, `cms_slot.translation.config` as `cms_slot.config`, `cms_slot.translation.customFields`, `cms_slot.translation.customFields` as `cms_slot.customFields` FROM `cms_slot` LEFT JOIN `swag_cms_extensions_form` `cms_slot.swagCmsExtensionsForm` ON `cms_slot`.`id` = `cms_slot.swagCmsExtensionsForm`.`cms_slot_id` LEFT JOIN (SELECT `cms_slot.translation`.`cms_slot_id`, `cms_slot.translation`.`cms_slot_version_id`, `cms_slot.translation`.`config` as `cms_slot.translation.config`, `cms_slot.translation`.`custom_fields` as `cms_slot.translation.customFields` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation`.`language_id` = ?) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` AND `cms_slot.cms_slot_translation`.`cms_slot_version_id` = `cms_slot`.`version_id` LEFT JOIN (SELECT `cms_slot.swagCmsExtensionsForm.translation`.`swag_cms_extensions_form_id`, `cms_slot.swagCmsExtensionsForm.translation`.`title` as `cms_slot.swagCmsExtensionsForm.translation.title`, `cms_slot.swagCmsExtensionsForm.translation`.`success_message` as `cms_slot.swagCmsExtensionsForm.translation.successMessage`, `cms_slot.swagCmsExtensionsForm.translation`.`receivers` as `cms_slot.swagCmsExtensionsForm.translation.receivers` FROM `swag_cms_extensions_form_translation` `cms_slot.swagCmsExtensionsForm.translation` WHERE `cms_slot.swagCmsExtensionsForm.translation`.`language_id` = ?) `cms_slot.swagCmsExtensionsForm.swag_cms_extensions_form_translation` ON `cms_slot.swagCmsExtensionsForm.swag_cms_extensions_form_translation`.`swag_cms_extensions_form_id` = `cms_slot.swagCmsExtensionsForm`.`id` WHERE (`cms_slot`.`version_id` = ?) AND (((`cms_slot`.`cms_block_id` IN (?, ?, ?, ?, ?, ?))))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01’÷z?q‘„÷Ur©®b\x0F"
  b"\x01’÷z?q‘„÷Ur«S¸"
  b"\x01’÷z?q‘„÷Ur¬÷‘\x1F"
  b"\x01’÷z?q‘„÷Ur­Ÿ\x1D6"
  b"\x01’÷z?q‘„÷Ur®ïcí"
  b"\x01’÷z?q‘„÷Ur°\x17Yö"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.94 ms
(1.33%) 		1 
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.92 ms
(1.30%) 		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"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.83 ms
(1.17%) 		1 
-- theme-service::resolve-media::read
SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`file_hash` as `media.fileHash`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, `media.translation.title` as `media.title`, `media.translation.alt`, `media.translation.alt` as `media.alt`, `media.translation.customFields`, `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.`media_id`, `media.translation`.`alt` as `media.translation.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation`.`custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation`.`language_id` = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  false
  true
  "product_download"
  b"N\x16åô\x15ôCâ€5„U]éT\x05"
  b"”ˆÖ–êFKÌ‘6öuÿ4Ë "
  b"ú™fÓ5×Es„\tŒ\x04f‰Ž\x04"
  b"KäiÉÁÄM̲Áãònj‘}"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.80 ms
(1.13%) 		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"\r›2pþB•«Jà€2Dº–"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.78 ms
(1.11%) 		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"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.77 ms
(1.09%) 		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"ñ\x12Ñê°ÁAŽ˜Á„a`«[\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.76 ms
(1.08%) 		1 
-- Manufacturer getCmsPage::read
SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`version_id` as `cms_page.versionId`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`css_class` as `cms_page.cssClass`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.translation.name`, `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 (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` = ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01’÷z\x1EpJ©ŠÔ< ÙÓ¶"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.73 ms
(1.04%) 		1 
SELECT seo_path_info FROM seo_url
                      WHERE language_id = ?
                      AND sales_channel_id = ?
                      AND route_name = ?
                      AND path_info = ?
                      AND is_deleted = ?
                      AND is_canonical = ?
                      LIMIT 1;
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ñ\x12Ñê°ÁAŽ˜Á„a`«[\v"
  "frontend.cbax.manufacturer.index"
  "/cbax/manufacturer/index"
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.73 ms
(1.04%) 		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"ñ\x12Ñê°ÁAŽ˜Á„a`«[\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.72 ms
(1.02%) 		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"ñ\x12Ñê°ÁAŽ˜Á„a`«[\v"
  b"ñ\x12Ñê°ÁAŽ˜Á„a`«[\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.68 ms
(0.97%) 		1 
-- Manufacturer getCmsPage::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.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 `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation`.`media_id`, `cms_section.backgroundMedia.translation`.`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"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01’÷z\x1EpJ©ŠÔ< ÙÓ¶"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.68 ms
(0.96%) 		1 
-- Manufacturer getCmsPage::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.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 `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation`.`media_id`, `cms_block.backgroundMedia.translation`.`alt` as `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation`.`title` as `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.`custom_fields` as `cms_block.backgroundMedia.translation.customFields` FROM `media_translation` `cms_block.backgroundMedia.translation` WHERE `cms_block.backgroundMedia.translation`.`language_id` = ?) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation`.`media_id` = `cms_block.backgroundMedia`.`id` WHERE (`cms_block`.`version_id` = ?) AND (((`cms_block`.`cms_section_id` IN (?))))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01’÷z?q‘„÷Ur©ƒ‘Î"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.67 ms
(0.95%) 		4 
SELECT iso FROM snippet_set WHERE id = ?
Parameters: 
[
  b"—3Ø—êBý›ÇÜHº\x01ËÅ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.63 ms
(0.90%) 		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"Ë\x10ƒ¬—\x1FGý‹œÈ&K\x1D“)"
  b"»¾¡v\x00§Ký¤ÃÖ3È\x1A\r7"
  b"¢Ýãg•@8¡,\x00”º²ˆ\x06"
  b"oâ6YX|H§žê\x1Dù$†i"
  b"\x01é艂r‰¾Þ÷­³À\x02å"
  b"¹Ü²#qOã»ÁK\x19\v„*ª"
  b"\x02ŽN›Õ F*›\x02ʯ—+»Ž"
  b"'égô£\x12K⟌=Ói¥ã›"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.62 ms
(0.88%) 		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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.61 ms
(0.87%) 		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"ñ\x12Ñê°ÁAŽ˜Á„a`«[\v"
  "/_esi/global/header"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.60 ms
(0.86%) 		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"ñ\x12Ñê°ÁAŽ˜Á„a`«[\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.60 ms
(0.85%) 		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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.54 ms
(0.76%) 		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"\x7F»;¯"°Kø—±\x07’ƒ4d""
  b"”ó Bó´8l€OÈÿ"
  b"ê!duºRFº€=\x12Z8ãÛ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.53 ms
(0.75%) 		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Í‚ó¬›ÑÀßÊ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.50 ms
(0.71%) 		1 
-- app-scripts::refresh::search-ids
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ? AND `app`.`self_managed` = ?)
Parameters: 
[
  true
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
0.50 ms
(0.71%) 		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"ñ\x12Ñê°ÁAŽ˜Á„a`«[\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.49 ms
(0.69%) 		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"^_ó‘î1@…¤}÷ŽÐV\x12\x07"
  b"\r›2pþB•«Jà€2Dº–"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.49 ms
(0.69%) 		1 
SELECT `name`, `path`, `author`, `self_managed`
                FROM `app`
                WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.48 ms
(0.68%) 		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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.47 ms
(0.67%) 		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"ñ\x12Ñê°ÁAŽ˜Á„a`«[\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.46 ms
(0.65%) 		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
]
View formatted query    View runnable query    Explain query    View query backtrace
0.46 ms
(0.65%) 		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"ñ\x12Ñê°ÁAŽ˜Á„a`«[\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.43 ms
(0.62%) 		1 
SELECT LOWER(HEX(`id`)) AS `id` FROM `moorl_interrupter` WHERE (`updated_at` IS NULL OR (`show_from` > `updated_at` AND `show_from` < '2025-12-28T09:06:30+00:00') OR (`show_until` > `updated_at` AND `show_until` < '2025-12-28T09:06:30+00:00')) AND `active` = '1';
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.42 ms
(0.60%) 		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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.42 ms
(0.59%) 		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"ñ\x12Ñê°ÁAŽ˜Á„a`«[\v"
  b"ÝMú\eü‘Cý¨Õ^?î–Ë"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.40 ms
(0.57%) 		1 
SELECT `base_class` AS `baseClass`, `author`
                FROM `plugin`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.40 ms
(0.57%) 		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ȽÖ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.38 ms
(0.54%) 		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Í‚ó¬›ÑÀßÊ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.38 ms
(0.54%) 		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"ñ\x12Ñê°ÁAŽ˜Á„a`«[\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.38 ms
(0.54%) 		1 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.37 ms
(0.53%) 		1 
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters: 
[
  "de-DE"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.37 ms
(0.52%) 		1 
-- header::languages::read
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`active` as `language.active`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.translationCode`.`id` as `language.translationCode.id`, `language.translationCode`.`code` as `language.translationCode.code`, `language.translationCode`.`created_at` as `language.translationCode.createdAt`, `language.translationCode`.`updated_at` as `language.translationCode.updatedAt`, `language.translationCode.translation.name`, `language.translationCode.translation.name` as `language.translationCode.name`, `language.translationCode.translation.territory`, `language.translationCode.translation.territory` as `language.translationCode.territory`, `language.translationCode.translation.customFields`, `language.translationCode.translation.customFields` as `language.translationCode.customFields` FROM `language` LEFT JOIN `locale` `language.translationCode` ON `language`.`translation_code_id` = `language.translationCode`.`id` LEFT JOIN (SELECT `language.translationCode.translation`.`locale_id`, `language.translationCode.translation`.`name` as `language.translationCode.translation.name`, `language.translationCode.translation`.`territory` as `language.translationCode.translation.territory`, `language.translationCode.translation`.`custom_fields` as `language.translationCode.translation.customFields` FROM `locale_translation` `language.translationCode.translation` WHERE `language.translationCode.translation`.`language_id` = ?) `language.translationCode.locale_translation` ON `language.translationCode.locale_translation`.`locale_id` = `language.translationCode`.`id` WHERE `language`.`id` IN (?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x19£^绩Aö…^Œ$RçÕ2"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(0.50%) 		1 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.34 ms
(0.49%) 		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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.34 ms
(0.49%) 		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"ÝMú\eü‘Cý¨Õ^?î–Ë"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.47%) 		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šNÈUýsü«—QoP¸°š"
  b"""
    \x01šNÇ…‹pŒ·\n
    yê»nBº
    """
  b"\x01“º+„µs¿ª®omfôR^"
  b"\x01–÷&<©r¥ÄTT:‡ó¤"
  b"\x1CÔ—ke\x00D\x08”ˆoa¦°,ö"
  b"+>ý&\x06WA6¾Â\x14ÚÐðW'"
  b"5úòIa¢GI­aaœpü\x18\x7F"
  b"o徘†ò@l¤*ù†$Ñ–·"
  b"¢ŸÕ/\x000AɦȻxUeæb"
  b"Ö4$‚€lE@Œ,mŠ\x07\Pf"
  b"Û"²ÖðÞM†k$$´Ø€K"
  b"\x1F?mq(ÕB@¼¾v¼AÁ¿"
  b"vÞBowUC\x15•©|‰\x19vƒ…"
  b"Ì™W!\x14\x00IP€’Ĉ£‰”\x04"
  b"@qx¶çEJˆ°G÷Ì‚\x17Í"
  b"“ëA|N\x1EF\x18¼\x10÷í\x16þcý"
  b"©T}@z\x12Mɤa}50Źö"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(0.45%) 		1 
SELECT
    `theme_id`,
    `technical_name`,
    `resolved_config`,
    `view_inheritance`,
    `script_files`,
    `icon_sets`,
    `updated_at`
    FROM `theme_runtime_config`
    WHERE `technical_name` = ?
Parameters: 
[
  "BottegaTheme"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(0.44%) 		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"ÝMú\eü‘Cý¨Õ^?î–Ë"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(0.38%) 		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"ñ\x12Ñê°ÁAŽ˜Á„a`«[\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(0.37%) 		2 
SELECT url FROM sales_channel_domain
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.24 ms
(0.34%) 		1 
SELECT DISTINCT `technical_name`
    FROM `theme_runtime_config`
    WHERE `technical_name` IS NOT NULL
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.22 ms
(0.31%) 		1 
SELECT path FROM category WHERE id = ?
Parameters: 
[
  b"""
    œ}@\f\n
    ¡D÷ŸBސïÉQÛ
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.21 ms
(0.30%) 		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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.12 ms
(0.17%) 		1 
SELECT `min_search_length` FROM `product_search_config` WHERE `language_id` = ?
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.