Redirect 302 redirect from GET @frontend.detail.page (789c0b)

GET https://shop.devmsa.sharpness.de/account/login?redirectParameters=%7B%22productId%22%3A%2278739c0327c5482780611b90c6a76699%22%7D&redirectTo=frontend.detail.pageā€¦

Response
200 OK
Browse referrer URL
IP
216.73.216.3
Profiled on
Token
1a4c6f

Query Metrics

48 Database Queries
36 Different statements
16.20 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
2.37 ms
(14.61%) 		1 
-- country-route::association::states::read
SELECT `country_state`.`id` as `country_state.id`, `country_state`.`country_id` as `country_state.countryId`, `country_state`.`short_code` as `country_state.shortCode`, `country_state`.`position` as `country_state.position`, `country_state`.`active` as `country_state.active`, `country_state`.`created_at` as `country_state.createdAt`, `country_state`.`updated_at` as `country_state.updatedAt`, `country_state.translation.name`, `country_state.translation.name` as `country_state.name`, `country_state.translation.customFields`, `country_state.translation.customFields` as `country_state.customFields` FROM `country_state` LEFT JOIN `country` `country_state.country` ON `country_state`.`country_id` = `country_state.country`.`id` LEFT JOIN (SELECT `country_state.translation`.`country_state_id`, `country_state.translation`.`name` as `country_state.translation.name`, `country_state.translation`.`custom_fields` as `country_state.translation.customFields` FROM `country_state_translation` `country_state.translation` WHERE `country_state.translation`.`language_id` = ?) `country_state.country_state_translation` ON `country_state.country_state_translation`.`country_state_id` = `country_state`.`id` LEFT JOIN `sales_channel_country` `country_state.country.salesChannels.mapping` ON `country_state.country`.`id` = `country_state.country.salesChannels.mapping`.`country_id`  LEFT JOIN `sales_channel` `country_state.country.salesChannels` ON `country_state.country.salesChannels.mapping`.`sales_channel_id` = `country_state.country.salesChannels`.`id`  WHERE (`country_state.country.salesChannels`.`id` = ? AND (`country_state`.`country_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))) GROUP BY `country_state`.`id` ORDER BY MIN(`country_state`.`position`) ASC, MIN(COALESCE(`country_state.translation.name`)) ASC
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Íe’Æ6®Kóƒx°\x1A›1äm"
  b"\x00ŸOzµIO#ˆ\x13Çž\x18;Ô7"
  b"\x00Â#5IÃH\x1C\x7Fªßø6yW"
  b"\x01–\x18UuÙMÑ´5ÄR÷\x18:T"
  b"\x03¹ò!@O_²íéZ\x12o8."
  b"\x04jc\x06b„Fz¦0c‰A\x1Ed>"
  b"\x05º~\x1C§<A©kÇ—ìp¾¿"
  b"\x07̝æ\x04­K\x04—¿g²Y¸ ç"
  b"\t‰~ßÞë@îŽâ¥ƒ\x1F3¦O"
  b"\t¤3\x01…çFTˆa \x13dº'"
  b"""
    \n
    <¾ß‹\x07I=¼É\x02î®\x02Ý\x16
    """
  b"""
    \n
    ü\x13\x1D\tâD´¸¨„©(_"L
    """
  b"""
    \fâ‘\n
    \x1F\x01D7„—\n
    ­¥È
    """
  b"\x0Eÿ;Û ÞBP¹¦Ä\x1DÁ¡ :"
  b"\x11w²íW¥Jh‹„tPHóÖ\x7F"
  b"\x12Y”€ÚìE\x1F¥\x1C°X€h–o"
  b"\x13\x7FhÉ#˜B(—~ÊÙ\x13èJ0"
  b"\x13ˆd¹€ÎA,†‰Ó-\x1F©Ç5"
  b"\x14¼óÙ°†B•¢Ž‚\x07\x02ú;"
  b"\x17\x13h¬ RIÝ®o–Ì€\x14ÇŽ"
  b"\x1A¡\x00°×\J—Ž÷Y‹À'\x02»"
  b"\x1D0ë£Á©OA´\x19EÛ‡\x0E™À"
  b"\x1D]\x18ÚpäD¹™"©¶`z\x14À"
  b"\x1DÊ\x10rÊò@ˆ«\x1AdqïÌ\x19Ê"
  b"\x1F\x06C^ž•A³­ÕOô})@"
  b"\x1FøUj\x13—O}—¦ˆHûöK;"
  b"#¢eá®\x19Nº¨9†B\x06&Šô"
  b"%^âÞfÍE\x1EŽXY‹X‘½’"
  b"%ÙyÌ\x0E·Mi¬ \x078\x06Ã\t]"
  b"'NU\x05ˆ‘O­‘‘áë‹j\x11_"
  b"'¯“CSVJ¢‰´±h|ˆº#"
  b"'É3üFãLŸÎ\tïŽ:)ì"
  b"+¡÷\x7FúE÷AÀ×7Üqn"
  b",s'ʯå@è«œƒèÁ¤ä"
  b"-Ï|cú8MŠ¼J߇\x06à´¥"
  b".«)\x0FJOÅ´‰‘e¹\x13ä–"
  b"2OÍb\x07AEp¸r·3°ç\€"
  b"2k<\x03u\x19Dȉ?üwŠ4IÅ"
  b"3\f}FC,N†Œ³’\v›\x11Ñh"
  b"3²Žhe­Mñ»Žrj2JÇ\x16"
  b"7Kk\x04AîE^ƒ=\x18Ú€âpÄ"
  b"7„Šp4\rNŽ Œ;½«~Fç"
  b"8H\tc\x06žN †G·BÉ¿IB"
  b"9sˆoÒß@¾²TÀ+&\vÖ\x0F"
  b";³\x03­/1Dݦö0íÐÏq‡"
  b";øýžÊMªŸo\x14Èρ\x08†"
  b"<j¯‚:@DV‡¸"\x7FÄÉS\x15"
  b"<šØžG_A¢…¾ýG\x15\x14ÈW"
  b">Vs–µHK¥€\x12;‡_\x15+("
  b">•bï†*O.¬±\x08õswùñ"
  b"@%VÚ,ÝM¶¹÷e?õ!Ì"
  b"A!…¶,}Kߎ&Þ\x07\x7F)\x07\x15"
  b"A_¯MoIR®××\x15zzñÉ"
  b"BÜ\x1F·‡YEá±”ÛÐp°Êˆ"
  b"CA\x05xw™E~Œ¼ˆ9MÍy|"
  b"DÚ»ˆÃ¯F‰‹}xxÃM¨l"
  b"E\x14\x7FþIê¾+†Å…5Üj"
  b"E¡àzÎïOøˆ½Ï‘Õ\x19éZ"
  b"F‚Zú•ÙK¨˜¤ÑB\x05^;9"
  b"FÙ;\x15KåK¢—gFúB‡Èñ"
  b"G9K\`îJg«\x10\x00ÇÑg\t2"
  b"GKŠ¶8ÔE\x19¥XVkää\x01)"
  b"H<Mˆ…K\x16£Ð±…i\x1Eð\x1D"
  b"HÆ€\x17ðtJ¹‘\x0E\x1Eçd?\x18;"
  b"Kû¼e@\x17I…‘[©h‡ßç"
  b"LÂ\x0Fè`ÿJîŽf„Y\x08Éz¨"
  b"""
    MÇ*Ï¿\x13Dš¤C\n
    m™R­ê
    """
  b"Mâ„Š2\x18M¨©°\²/'•<"
  b"Nª/y\x08pF»±ã$÷¦µÒk"
  b"O\:Ò9CN3§ì^¶ëäå\x13"
  b"Oi˜º°¦J§‚ê%Ô9J´z"
  b"P\x10 \x12ˆ}C\x0F£!\x0FÅ)Å©\r"
  b"Pz±Þ\x1F¦JÔ„µû” vªÉ"
  b"QÚœöWÌI6•Óâ\x0FFV$Q"
  b"S1ñg’µFô§ïp4tãÝ­"
  b"""
    SŒ\n
    ü„+G'²Ó]*0̉\x04
    """
  b"""
    Ts,‡\n
    \x0FJvƒUó¦\x07Jð^
    """
  b"Uv ™_¤H\x19¤ÇÂ’\x03œŸÛ"
  b"V\x05HCDbD#¯µ_\rA˜ª3"
  b"V•\x1Fë\fpO°žY\x0EÛ\x1CìZñ"
  b"Vé.B–îN\x1C›oQö¢óLO"
  b"WÑ”l”‡B쬁ö¯c\r#"
  b"X@e“ÿ•J¤°\x1E\x13fµ*\x04P"
  b"XÿŽq??G£²µX—\x00˜\x03Ã"
  b"YN\x1D\r  B\x0E–yaD\x1D”²"
  b"Y~/v\t4N¢‚:\x1E\x02d¡…U"
  b"\Æ^!e=IÙŠúùƒ`ä!á"
  b"^wÑ«2F`„peê\x11×ö\x10"
  b"^²Æl\x06¶@í©§‚ÛI\××"
  b"_ @ƒÎUGè­¿öÄÏÓ²·"
  b"_>i…\x19QN~¹K\x1A\x13>ÿ““"
  b"`;i‚’fKþ\x1D{ý>éÞg"
  b"a\r\tœ\x13\x01Cë·¼/èA@Õð"
  b"a#‹–•#I\t“:kƒGn\x01¢"
  b"aÃÌë½ÌI6“\x02Ë5|Q\x00ó"
  b"c\e¢}9vO%œâ\x02ñ¸Šsô"
  b"d;aµ]†Nò²)T,V\x02\x01—"
  b"""
    dý\n
    ²­vOKŒkC\x1F¿¡Òª
    """
  b"f9¹”*rD  ?˜Y\x1Dâ\e6"
  b"f¯Ô~c`JP¬6\x13i•O‘c"
  b"g)Þ¾IÃM¿Ü©)²êñx"
  b"g­qB\ÇMÖˆx\e{çªw^"
  b"h„á\x11F–J«³h§y{\x08˜ "
  b"hÞ·\x07Ô­L¾+x?'Ð]„"
  b"iM#ð‡\x15Gíºëw«\vïý"
  b"jaÿÔÌ¡Hn¨r\x15\x1CAˆ\x13ö"
  b"jج0s•CLœåHÞb\x04éi"
  b"""
    n\n
    vO·8D¬•í\x7F¼À˜ûŽ
    """
  b"om²žâšHà«\\rÍm„Ò8"
  b"o€\x12å}£@ˆ˜OJ/6¤DE"
  b"q\x13ö¶e¨M\x07œ\v‚¯t÷{Ë"
  b"s\x18ªêËÔIÏ“MŠ\x07xKH"
  b"sÕæÊHæN\vŽ2á(¹«£/"
  b"uj"¥/ZKô‚<V™éíÑö"
  b"v\x05þ¹^ºJ|‡µ¨ˆeù\x00"
  b"v\x14„yC?@%’@T\x1Ep;4"
  b"v\x1CÏfr\x00CŽ„´æ&VOf^"
  b"v¡M×ð«@ƒ¶Ì \x1A òi…"
  b"wH•Xe\x07@Ⴊä5©57\x07"
  b"wË®ú\nÑJZž;ýhü\x00OK"
  b"xC³\x12˜CF¯›\x13é\x1F\x17©\x12"
  b"y¶"Ô-eN“š\x1DÃË7.¾f"
  b"yðL2VÀK§¥\x18\vñdÂbv"
  b"yù“ã\x07·B۝".xì »Ë"
  b"|A£q1ÊK·ˆ°ã§c\x05.…"
  b"|oT€EÚMR£ƒpö\x15 <4"
  b"€M¯Ã\x1D\x10IEŠ—ªòÎ_œ¿"
  b"‚Ó¸ÈxéB·›¾4œb\x18\x00ß"
  b"ƒóÒhY\x13Cc´ü<À\ö\x13\x1F"
  b"„ö:gìŸOþ¾¸Œ†Ñ@‡'"
  b"‡*7:•íNf¼° aLp\x12W"
  b"‡ÙÎ{~óD&–wª\v/?–Û"
  b"ˆˆ¥EcJw‚/ãã¼ç¡–"
  b"‹£Ü\x17ʇ@¾”Uü‡3=`M"
  b"ŒúJþ“UMÒ¢6\tžíìF©"
  b"Ž\x1E\x14gS^OĨoÝÏ\x18è\x1CÛ"
  b"’3…­±\x06NŹø,v¶•ìù"
  b"’“X\x17óuN\x02«I\x16\x11ì\x1APã"
  b"’ì·,ߝN\v†Ñ\f”þ\x1D}ÿ"
  b"”\x10\e\x13à«CԁðN\9CÅ+"
  b"”wó•M:Gª®˜ôÿ\x19)F"
  b"–4…¸o\x11MW¦÷Ka\x03‰hÚ"
  b"–=%ŽyüLά\x16GüL7S\x1A"
  b"—ø¯•QÚH\x0F¦\x17U!\x15$ݽ"
  b"˜\x04·Ëâ/G`WÌž²1p"
  b"™ÌnÊ”ŽHˆ‚ÅHYòVW3"
  b"šî„g«C\x05²\x16\x16ýçmZm"
  b"šý?\x03îICvš…nJß8K„"
  b"›‹?~à\x14Ižƒ\x08lh\x10¸\x117"
  b"œbb¨k‘GÀ„õY§`O\x1C"
  b"1æëwÏ@\x19”yùÆÉ\x18çë"
  b"ž\x15ŒäÈHi¥–ß#\x0E„4:"
  b"ŸîÜXæ\x1DK\x07‚´\x03U\x0Fù6ì"
  b"¢IÄÖTÀB\x00§"þiH…\x7F¾"
  b"""
    ¢{\n
     Ùï@"¢™ý\x0F0=és
    """
  b"¤&×PäŸE8¢!nÂ\x1Dã£A"
  b"¥\x16•µ‘ˆF§¤\x1C[%¹ˆ\x02e"
  b"¥ÒW®0(F\x17²§°Hý&¢\f"
  b"¦{µ\x12á¯K{¸È\x18\f(Ý@8"
  b"¨\x07°(Úù@=¤d\x04\x1D’ë´Î"
  b"""
    ¨.!D\n
    Ky‹\x7F”¢¹W¯±
    """
  b"¨`.$F\x05BÛ¹á\x00\x1C\x160Qx"
  b"¨ê.\x7FV\x15Oà•jªABD*J"
  b"ª:0¨Ÿ-Bß‹¢Q‹¤.æž"
  b"ªdr\x1806Cˆ‰N\x10Û,±Ô\f"
  b"«\x08O‚Ä\x13BqžñôVQ6t…"
  b"«b)oÌ×Aâ¢\x06\x01\x11€÷Üð"
  b"«ïS‹ý¨A£ª®»+‹÷­9"
  b"¬–lRýrJEŸ¨24\¬Di"
  b"­~™ÒqÅB½± \x15°-ŒÚå"
  b"®Kê~\x1A_H–¼©SË\t Ov"
  b"®NþŸg\x1EN\x1Cµ\x01¢~TÓ|"
  b"¯ÌÕ˜ü\x02F5¿ð!Ü3}vE"
  b"°\x06×@\x08ÚGO½A×ý\x1F\e\x16\x15"
  b"°Â@¸Ê:C{§–êµ×Ë \x1F"
  b"µ„xqÓs@ß­}œ£…B¯"
  b"µüsDiõG:©ò¾åT¶È "
  b"\x05\x15\x13²àA ¼-¼˜¼ˆkŽ"
  b"·ké&(¶AÑ‚åÂd·\x132…"
  b"¹jA!¼ëF8£úº,ÎVÐ|"
  b"º5¢½>èJƸÏ+¡^\x12VÆ"
  b"ºr\x1FÀ¹çAÎœƒÎ&´\x11íU"
  b"½\x16…¦AsEƽ)\x036«j\x10"
  b"½w-)„úM"•âtŠ‚œOÔ"
  b"½¨á~õËD1¹\x0Fn\x02žY’ÿ"
  b"¾ˆ%÷\x12ëEœ©Ã9\e\x1D©Éb"
  b"¾å:·êLk»e»läSŽZ"
  b"¿¯ºýW–O\x1A«`1äL\x13‰\n"
  b"ÁÕû6ÑO#†éõÚÂ;Z"
  b"ÁÿW€‡jJ.¾NJ—º?¿ò"
  b"ÄÈ=¼ÊCB̘\x11já\vgÑ$"
  b"Å\x08×PÉVKÿ»IQ\x1EøP\x08r"
  b"ÇÒñ»cåO5†Ø¹\x01%‚á6"
  b"""
    È\n
    aùaPEE… T´}{ÝF
    """
  b"È\r¯¬ûˆCÞœÍÀL\x05)Ñi"
  b"ȇŽ¼WKFl˜\x04«G󞇨"
  b"Ë\x0EÉüùc@½žéºÄ\x0E«ÂL"
  b"ËâíéďO¨“*_i/\x17\x03â"
  b"ÎÞÂWº0O\x1Cœö‰àMö­"
  b"ÎáœÈ4~G¹«!l\x12V–ŽN"
  b"ϘDf;O†³Cò¨ú'×\x1D"
  b"ÑÞÉ㐸A\x18²ÿÎöG$q*"
  b"Ó\x1E¸î32O'œÏ\x07=3´*í"
  b"ÔObúëÞA#¢Èü\x07õf\x1A"
  b"Õ(Œ^;@ב›Ï\x16 B\x01¾"
  b"ÕNÃ\eܨNË»–ƒ\x11ÿ÷ï\e"
  b"ÕáJÒçlLYÑuÿóOÂþ"
  b"Ö(ѽWçGü™yÞÆÞ†Á›"
  b"Û^¶.²îJ$¹\ežh¨6{"
  b"Ûá1$×–F›¨Ó»6P\x02w³"
  b"ÜK¦mýÊAè…×_êéž6è"
  b"ÜÑ\x00~”WMÓ­}øc¸ôlÁ"
  b"Ý$\x0F@—@ᨷ\x017Á`\f¦"
  b"Ý4\vãůC›«ž¡P\x05EŽù"
  b"Ý6\x03\x08Õ*H\x7F¡ËÛ\x10JVõ¯"
  b"ß\x1E`¹¸\x1EC<©f3\x1Ah\x18Æ»"
  b"à½vڐ‹KÊ¢\Ñ£5\x01Iv"
  b"áwUH³Ju’\t=H[ÆÃ\r"
  b"á…yľ¢J¿·¦Ý.ÞïÃ"
  b"âÉÖ\e¼}AO·úºo\x1EÉcd"
  b"å\v‹m\x08ZO•ŽÑÀn¥ìô"
  b"""
    èŽóý™"GWž¬oÿì\n
    ;±
    """
  b"èê\KåÝCÀ—Gýq'å†ø"
  b"éh\x07Ù€äB9¦\x00‡ìÑ-\x7F"
  b"ê\x08àœe¸Dµ‘ËQF¢®—6"
  b"ê>®´LâM,¯\v‘£95fŽ"
  b"ì»ðó®°Aº€ü›áAgõs"
  b"íx䚈ÓH¿™šðw[»\f["
  b"í„\x13à{ÏI¥‹ÁEÂÉñÛú"
  b"î¬Ï\x18ù2Cd‚¯K£Kß…"
  b"爫-÷bE††âŠ8É7B…"
  b"ïýì/æÝAЦCÝ©KÞÅd"
  b"ñ`\x1E\x12\tJݬý(ïìÅJ~"
  b"ñ®‚ÖùÝO\x00„<Üõ?¡h*"
  b"òƒ‚v7~OʁmÓ§WÁ4„"
  b"óË<ÌF{G¢…<l;\x08¾\x13æ"
  b"óâF\x1FªÒGÝ”\x02§3®ÁÅ^"
  b"ô°ôG1âB½•ÃR.\x06šø""
  b"õkm6\t=@ø¿ÿ÷Ð\x0E-àÃ"
  b"öIX\x12t;M\x06»Eû,U\x10ƒù"
  b"ùX–à®×F¯‡¶úx’ŠÑl"
  b"ùõ1EïýFè·\x1C“w”¨hþ"
  b"""
    ú\x7FDØIŸOþ¶ ÷à\n
    \x17–…
    """
  b"úR£HqDP_´ ðÆ£÷"
  b"û\x01¤ºvÆDÚ¦f„$ ¸ö&"
  b"û̦¹¬L ·\x13ó¶\x1F&F\x13"
  b"ûÓ%A›ÑNèˆ\t÷À0\x01³t"
  b"üÈËøVâD5•næ\x14"ÚCž"
  b"ÿÜQTYÁJ¡™á=J1&¦5"
  b"ÿÝ@àìSM§Ž;…V⛡u"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.24 ms
(7.67%) 		1 
-- country-route::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"Å\x08×PÉVKÿ»IQ\x1EøP\x08r"
  b"¨\x07°(Úù@=¤d\x04\x1D’ë´Î"
  b"WÑ”l”‡B쬁ö¯c\r#"
  b"ñ®‚ÖùÝO\x00„<Üõ?¡h*"
  b"""
    \fâ‘\n
    \x1F\x01D7„—\n
    ­¥È
    """
  b"¹jA!¼ëF8£úº,ÎVÐ|"
  b"áwUH³Ju’\t=H[ÆÃ\r"
  b"%^âÞfÍE\x1EŽXY‹X‘½’"
  b"'É3üFãLŸÎ\tïŽ:)ì"
  b"ÿÝ@àìSM§Ž;…V⛡u"
  b"s\x18ªêËÔIÏ“MŠ\x07xKH"
  b"_ @ƒÎUGè­¿öÄÏÓ²·"
  b"\x05º~\x1C§<A©kÇ—ìp¾¿"
  b"V•\x1Fë\fpO°žY\x0EÛ\x1CìZñ"
  b"¨ê.\x7FV\x15Oà•jªABD*J"
  b"E\x14\x7FþIê¾+†Å…5Üj"
  b"c\e¢}9vO%œâ\x02ñ¸Šsô"
  b"ƒóÒhY\x13Cc´ü<À\ö\x13\x1F"
  b"H<Mˆ…K\x16£Ð±…i\x1Eð\x1D"
  b"\x03¹ò!@O_²íéZ\x12o8."
  b"DÚ»ˆÃ¯F‰‹}xxÃM¨l"
  b"Ö(ѽWçGü™yÞÆÞ†Á›"
  b"Ûá1$×–F›¨Ó»6P\x02w³"
  b"'¯“CSVJ¢‰´±h|ˆº#"
  b"om²žâšHà«\\rÍm„Ò8"
  b"\x1DÊ\x10rÊò@ˆ«\x1AdqïÌ\x19Ê"
  b"–=%ŽyüLά\x16GüL7S\x1A"
  b"F‚Zú•ÙK¨˜¤ÑB\x05^;9"
  b"f¯Ô~c`JP¬6\x13i•O‘c"
  b"€M¯Ã\x1D\x10IEŠ—ªòÎ_œ¿"
  b"|A£q1ÊK·ˆ°ã§c\x05.…"
  b"""
    dý\n
    ²­vOKŒkC\x1F¿¡Òª
    """
  b"XÿŽq??G£²µX—\x00˜\x03Ã"
  b"-Ï|cú8MŠ¼J߇\x06à´¥"
  b"\x01–\x18UuÙMÑ´5ÄR÷\x18:T"
  b"ÜÑ\x00~”WMÓ­}øc¸ôlÁ"
  b"\t‰~ßÞë@îŽâ¥ƒ\x1F3¦O"
  b"\x07̝æ\x04­K\x04—¿g²Y¸ ç"
  b"2OÍb\x07AEp¸r·3°ç\€"
  b"+¡÷\x7FúE÷AÀ×7Üqn"
  b"7„Šp4\rNŽ Œ;½«~Fç"
  b"BÜ\x1F·‡YEá±”ÛÐp°Êˆ"
  b"ȇŽ¼WKFl˜\x04«G󞇨"
  b"«ïS‹ý¨A£ª®»+‹÷­9"
  b"ˆˆ¥EcJw‚/ãã¼ç¡–"
  b"""
    ¨.!D\n
    Ky‹\x7F”¢¹W¯±
    """
  b"Y~/v\t4N¢‚:\x1E\x02d¡…U"
  b"šî„g«C\x05²\x16\x16ýçmZm"
  b"""
    MÇ*Ï¿\x13Dš¤C\n
    m™R­ê
    """
  b"Pz±Þ\x1F¦JÔ„µû” vªÉ"
  b"'NU\x05ˆ‘O­‘‘áë‹j\x11_"
  b"\x14¼óÙ°†B•¢Ž‚\x07\x02ú;"
  b"ÎÞÂWº0O\x1Cœö‰àMö­"
  b"ÄÈ=¼ÊCB̘\x11já\vgÑ$"
  b"’3…­±\x06NŹø,v¶•ìù"
  b"Vé.B–îN\x1C›oQö¢óLO"
  b"Oi˜º°¦J§‚ê%Ô9J´z"
  b"f9¹”*rD  ?˜Y\x1Dâ\e6"
  b"\x1D0ë£Á©OA´\x19EÛ‡\x0E™À"
  b"\x1FøUj\x13—O}—¦ˆHûöK;"
  b"^²Æl\x06¶@í©§‚ÛI\××"
  b"ŒúJþ“UMÒ¢6\tžíìF©"
  b"|oT€EÚMR£ƒpö\x15 <4"
  b"ËâíéďO¨“*_i/\x17\x03â"
  b"#¢eá®\x19Nº¨9†B\x06&Šô"
  b"µüsDiõG:©ò¾åT¶È "
  b"úR£HqDP_´ ðÆ£÷"
  b"爫-÷bE††âŠ8É7B…"
  b"à½vڐ‹KÊ¢\Ñ£5\x01Iv"
  b"v\x14„yC?@%’@T\x1Ep;4"
  b"ì»ðó®°Aº€ü›áAgõs"
  b"âÉÖ\e¼}AO·úºo\x1EÉcd"
  b"½¨á~õËD1¹\x0Fn\x02žY’ÿ"
  b"\x11w²íW¥Jh‹„tPHóÖ\x7F"
  b"GKŠ¶8ÔE\x19¥XVkää\x01)"
  b"½\x16…¦AsEƽ)\x036«j\x10"
  b"ß\x1E`¹¸\x1EC<©f3\x1Ah\x18Æ»"
  b"hÞ·\x07Ô­L¾+x?'Ð]„"
  b"g)Þ¾IÃM¿Ü©)²êñx"
  b"Ž\x1E\x14gS^OĨoÝÏ\x18è\x1CÛ"
  b"\x17\x13h¬ RIÝ®o–Ì€\x14ÇŽ"
  b"°\x06×@\x08ÚGO½A×ý\x1F\e\x16\x15"
  b"%ÙyÌ\x0E·Mi¬ \x078\x06Ã\t]"
  b"ž\x15ŒäÈHi¥–ß#\x0E„4:"
  b"\x04jc\x06b„Fz¦0c‰A\x1Ed>"
  b"ÕNÃ\eܨNË»–ƒ\x11ÿ÷ï\e"
  b"ÕáJÒçlLYÑuÿóOÂþ"
  b"@%VÚ,ÝM¶¹÷e?õ!Ì"
  b"˜\x04·Ëâ/G`WÌž²1p"
  b"""
    ú\x7FDØIŸOþ¶ ÷à\n
    \x17–…
    """
  b"A!…¶,}Kߎ&Þ\x07\x7F)\x07\x15"
  b"YN\x1D\r  B\x0E–yaD\x1D”²"
  b"\x13\x7FhÉ#˜B(—~ÊÙ\x13èJ0"
  b"í„\x13à{ÏI¥‹ÁEÂÉñÛú"
  b"LÂ\x0Fè`ÿJîŽf„Y\x08Éz¨"
  b"öIX\x12t;M\x06»Eû,U\x10ƒù"
  b"1æëwÏ@\x19”yùÆÉ\x18çë"
  b"õkm6\t=@ø¿ÿ÷Ð\x0E-àÃ"
  b"ªdr\x1806Cˆ‰N\x10Û,±Ô\f"
  b"QÚœöWÌI6•Óâ\x0FFV$Q"
  b"¯ÌÕ˜ü\x02F5¿ð!Ü3}vE"
  b"<j¯‚:@DV‡¸"\x7FÄÉS\x15"
  b"òƒ‚v7~OʁmÓ§WÁ4„"
  b"Õ(Œ^;@ב›Ï\x16 B\x01¾"
  b"""
    Ts,‡\n
    \x0FJvƒUó¦\x07Jð^
    """
  b">•bï†*O.¬±\x08õswùñ"
  b"ª:0¨Ÿ-Bß‹¢Q‹¤.æž"
  b"""
    \n
    ü\x13\x1D\tâD´¸¨„©(_"L
    """
  b"½w-)„úM"•âtŠ‚œOÔ"
  b"S1ñg’µFô§ïp4tãÝ­"
  b"\x1A¡\x00°×\J—Ž÷Y‹À'\x02»"
  b"’“X\x17óuN\x02«I\x16\x11ì\x1APã"
  b"_>i…\x19QN~¹K\x1A\x13>ÿ““"
  b"yðL2VÀK§¥\x18\vñdÂbv"
  b"éh\x07Ù€äB9¦\x00‡ìÑ-\x7F"
  b"°Â@¸Ê:C{§–êµ×Ë \x1F"
  b"yù“ã\x07·B۝".xì »Ë"
  b"\x13ˆd¹€ÎA,†‰Ó-\x1F©Ç5"
  b"¤&×PäŸE8¢!nÂ\x1Dã£A"
  b"ÜK¦mýÊAè…×_êéž6è"
  b"Ý$\x0F@—@ᨷ\x017Á`\f¦"
  b"v\x1CÏfr\x00CŽ„´æ&VOf^"
  b"®NþŸg\x1EN\x1Cµ\x01¢~TÓ|"
  b"iM#ð‡\x15Gíºëw«\vïý"
  b"y¶"Ô-eN“š\x1DÃË7.¾f"
  b"aÃÌë½ÌI6“\x02Ë5|Q\x00ó"
  b"v¡M×ð«@ƒ¶Ì \x1A òi…"
  b"v\x05þ¹^ºJ|‡µ¨ˆeù\x00"
  b"‚Ó¸ÈxéB·›¾4œb\x18\x00ß"
  b"xC³\x12˜CF¯›\x13é\x1F\x17©\x12"
  b"\x1F\x06C^ž•A³­ÕOô})@"
  b"û̦¹¬L ·\x13ó¶\x1F&F\x13"
  b"ÿÜQTYÁJ¡™á=J1&¦5"
  b"ê\x08àœe¸Dµ‘ËQF¢®—6"
  b"ÎáœÈ4~G¹«!l\x12V–ŽN"
  b"èê\KåÝCÀ—Gýq'å†ø"
  b",s'ʯå@è«œƒèÁ¤ä"
  b"A_¯MoIR®××\x15zzñÉ"
  b"‡ÙÎ{~óD&–wª\v/?–Û"
  b"""
    n\n
    vO·8D¬•í\x7F¼À˜ûŽ
    """
  b"\Æ^!e=IÙŠúùƒ`ä!á"
  b"E¡àzÎïOøˆ½Ï‘Õ\x19éZ"
  b"Ý4\vãůC›«ž¡P\x05EŽù"
  b"å\v‹m\x08ZO•ŽÑÀn¥ìô"
  b"«b)oÌ×Aâ¢\x06\x01\x11€÷Üð"
  b"9sˆoÒß@¾²TÀ+&\vÖ\x0F"
  b"Nª/y\x08pF»±ã$÷¦µÒk"
  b"Uv ™_¤H\x19¤ÇÂ’\x03œŸÛ"
  b"‹£Ü\x17ʇ@¾”Uü‡3=`M"
  b"Ó\x1E¸î32O'œÏ\x07=3´*í"
  b"\t¤3\x01…çFTˆa \x13dº'"
  b"¥ÒW®0(F\x17²§°Hý&¢\f"
  b"jج0s•CLœåHÞb\x04éi"
  b"V\x05HCDbD#¯µ_\rA˜ª3"
  b"‡*7:•íNf¼° aLp\x12W"
  b"\x05\x15\x13²àA ¼-¼˜¼ˆkŽ"
  b"ïýì/æÝAЦCÝ©KÞÅd"
  b"¾ˆ%÷\x12ëEœ©Ã9\e\x1D©Éb"
  b"3\f}FC,N†Œ³’\v›\x11Ñh"
  b"2k<\x03u\x19Dȉ?üwŠ4IÅ"
  b"""
    èŽóý™"GWž¬oÿì\n
    ;±
    """
  b"ÁÕû6ÑO#†éõÚÂ;Z"
  b"wH•Xe\x07@Ⴊä5©57\x07"
  b">Vs–µHK¥€\x12;‡_\x15+("
  b"„ö:gìŸOþ¾¸Œ†Ñ@‡'"
  b"µ„xqÓs@ß­}œ£…B¯"
  b"Ý6\x03\x08Õ*H\x7F¡ËÛ\x10JVõ¯"
  b"­~™ÒqÅB½± \x15°-ŒÚå"
  b"jaÿÔÌ¡Hn¨r\x15\x1CAˆ\x13ö"
  b"h„á\x11F–J«³h§y{\x08˜ "
  b"Mâ„Š2\x18M¨©°\²/'•<"
  b"sÕæÊHæN\vŽ2á(¹«£/"
  b"¨`.$F\x05BÛ¹á\x00\x1C\x160Qx"
  b"®Kê~\x1A_H–¼©SË\t Ov"
  b"¢IÄÖTÀB\x00§"þiH…\x7F¾"
  b"\x0Eÿ;Û ÞBP¹¦Ä\x1DÁ¡ :"
  b"d;aµ]†Nò²)T,V\x02\x01—"
  b"¥\x16•µ‘ˆF§¤\x1C[%¹ˆ\x02e"
  b"G9K\`îJg«\x10\x00ÇÑg\t2"
  b"X@e“ÿ•J¤°\x1E\x13fµ*\x04P"
  b"Û^¶.²îJ$¹\ežh¨6{"
  b"”wó•M:Gª®˜ôÿ\x19)F"
  b"á…yľ¢J¿·¦Ý.ÞïÃ"
  b"\x1D]\x18ÚpäD¹™"©¶`z\x14À"
  b"a#‹–•#I\t“:kƒGn\x01¢"
  b"ÑÞÉ㐸A\x18²ÿÎöG$q*"
  b"¿¯ºýW–O\x1A«`1äL\x13‰\n"
  b"·ké&(¶AÑ‚åÂd·\x132…"
  b"ûÓ%A›ÑNèˆ\t÷À0\x01³t"
  b"ϘDf;O†³Cò¨ú'×\x1D"
  b"ùõ1EïýFè·\x1C“w”¨hþ"
  b"íx䚈ÓH¿™šðw[»\f["
  b"üÈËøVâD5•næ\x14"ÚCž"
  b"ùX–à®×F¯‡¶úx’ŠÑl"
  b"P\x10 \x12ˆ}C\x0F£!\x0FÅ)Å©\r"
  b"«\x08O‚Ä\x13BqžñôVQ6t…"
  b"`;i‚’fKþ\x1D{ý>éÞg"
  b"û\x01¤ºvÆDÚ¦f„$ ¸ö&"
  b"óË<ÌF{G¢…<l;\x08¾\x13æ"
  b"a\r\tœ\x13\x01Cë·¼/èA@Õð"
  b"î¬Ï\x18ù2Cd‚¯K£Kß…"
  b"ŸîÜXæ\x1DK\x07‚´\x03U\x0Fù6ì"
  b"^wÑ«2F`„peê\x11×ö\x10"
  b"’ì·,ߝN\v†Ñ\f”þ\x1D}ÿ"
  b"O\:Ò9CN3§ì^¶ëäå\x13"
  b"\x00Â#5IÃH\x1C\x7Fªßø6yW"
  b"""
    \n
    <¾ß‹\x07I=¼É\x02î®\x02Ý\x16
    """
  b"¦{µ\x12á¯K{¸È\x18\f(Ý@8"
  b"Ë\x0EÉüùc@½žéºÄ\x0E«ÂL"
  b"›‹?~à\x14Ižƒ\x08lh\x10¸\x117"
  b".«)\x0FJOÅ´‰‘e¹\x13ä–"
  b"8H\tc\x06žN †G·BÉ¿IB"
  b"È\r¯¬ûˆCÞœÍÀL\x05)Ñi"
  b"ºr\x1FÀ¹çAÎœƒÎ&´\x11íU"
  b"""
    SŒ\n
    ü„+G'²Ó]*0̉\x04
    """
  b"o€\x12å}£@ˆ˜OJ/6¤DE"
  b"ÔObúëÞA#¢Èü\x07õf\x1A"
  b"¾å:·êLk»e»läSŽZ"
  b"Kû¼e@\x17I…‘[©h‡ßç"
  b"™ÌnÊ”ŽHˆ‚ÅHYòVW3"
  b"šý?\x03îICvš…nJß8K„"
  b";øýžÊMªŸo\x14Èρ\x08†"
  b"""
    ¢{\n
     Ùï@"¢™ý\x0F0=és
    """
  b"uj"¥/ZKô‚<V™éíÑö"
  b"""
    È\n
    aùaPEE… T´}{ÝF
    """
  b"”\x10\e\x13à«CԁðN\9CÅ+"
  b"ÁÿW€‡jJ.¾NJ—º?¿ò"
  b"FÙ;\x15KåK¢—gFúB‡Èñ"
  b"ñ`\x1E\x12\tJݬý(ïìÅJ~"
  b"ÇÒñ»cåO5†Ø¹\x01%‚á6"
  b"wË®ú\nÑJZž;ýhü\x00OK"
  b"g­qB\ÇMÖˆx\e{çªw^"
  b"HÆ€\x17ðtJ¹‘\x0E\x1Eçd?\x18;"
  b"\x12Y”€ÚìE\x1F¥\x1C°X€h–o"
  b"ô°ôG1âB½•ÃR.\x06šø""
  b"óâF\x1FªÒGÝ”\x02§3®ÁÅ^"
  b"3²Žhe­Mñ»Žrj2JÇ\x16"
  b"<šØžG_A¢…¾ýG\x15\x14ÈW"
  b"–4…¸o\x11MW¦÷Ka\x03‰hÚ"
  b"q\x13ö¶e¨M\x07œ\v‚¯t÷{Ë"
  b"\x00ŸOzµIO#ˆ\x13Çž\x18;Ô7"
  b"ê>®´LâM,¯\v‘£95fŽ"
  b"º5¢½>èJƸÏ+¡^\x12VÆ"
  b"œbb¨k‘GÀ„õY§`O\x1C"
  b"—ø¯•QÚH\x0F¦\x17U!\x15$ݽ"
  b"7Kk\x04AîE^ƒ=\x18Ú€âpÄ"
  b"CA\x05xw™E~Œ¼ˆ9MÍy|"
  b";³\x03­/1Dݦö0íÐÏq‡"
  b"¬–lRýrJEŸ¨24\¬Di"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.24 ms
(7.65%) 		1 
-- header::languages::search-ids
SELECT `language`.`id` FROM `language` LEFT JOIN `sales_channel_domain` `language.salesChannelDomains` ON `language`.`id` = `language.salesChannelDomains`.`language_id` LEFT JOIN `sales_channel_language` `language.salesChannels.mapping` ON `language`.`id` = `language.salesChannels.mapping`.`language_id`  LEFT JOIN `sales_channel` `language.salesChannels` ON `language.salesChannels.mapping`.`sales_channel_id` = `language.salesChannels`.`id`  WHERE (`language.salesChannelDomains`.`sales_channel_id` = ? AND `language.salesChannels`.`id` = ?) GROUP BY `language`.`id` ORDER BY MIN(`language`.`name`) ASC
Parameters: 
[
  b"Íe’Æ6®Kóƒx°\x1A›1äm"
  b"Íe’Æ6®Kóƒx°\x1A›1äm"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.07 ms
(6.58%) 		1 
-- country-route::search-ids
SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id`  LEFT JOIN (SELECT `country.translation`.`country_id`, `country.translation`.`name` as `country.translation.name` FROM `country_translation` `country.translation` WHERE `country.translation`.`language_id` = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id`  WHERE (`country`.`active` = ? AND `country.salesChannels`.`id` = ?) GROUP BY `country`.`id` ORDER BY MIN(`country`.`position`) ASC, MIN(COALESCE(`country.translation.name`)) ASC
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  b"Íe’Æ6®Kóƒx°\x1A›1äm"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.04 ms
(6.44%) 		1 
-- 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"«ª‘ËûFB\fV\x07¶\äâ»"
  "%|abaa91cbfb46420c9d5607b65ce4e2bb|%"
  1
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
1.04 ms
(6.42%) 		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/19ca405790ff4f07aac8c599d4317868"
  "/navigation/e8a8269008a540938b0fe5c9f5ddda80"
  "/navigation/44cf99695e964def895a2f2938c049e9"
  "/navigation/656bf6338d194c4c86f26735fb442233"
  "/navigation/2a10ddb190174f688f9bc1d14697c06c"
  "/navigation/6db7ddbb1c764ed38b1b8718f1e4c6db"
  "/navigation/48f97f432fd041388b2630184139cf0e"
  "/navigation/27ec2420d9d2470283912dcbe9688c94"
  "/navigation/02a52ab5a44648c99f64d06a638249ac"
  "/navigation/1ddd1de7e4a3458bba6a0327bd0b49f2"
  "/navigation/bb22b05bff9140f3808b1cff975b75eb"
  "/navigation/744b20f4f08a455cb6bd74ecc040d5ce"
  "/navigation/d9d5740612214d618c7f6dac6c9b82d8"
  "/navigation/7fac11a34495463da395fc8b5f28cdc9"
  "/navigation/80c69a1d15af44b9a0a49e52a6135ec6"
  "/navigation/4fdb02311abc4fa9862b03c487026c5b"
  "/navigation/06f5dda360c04112937601574122c515"
  "/navigation/323f5a5c631043579688a0f53ce9de79"
  "/navigation/9ecd510745e544bfb29227421c49324e"
  "/navigation/b0001b5eb08e45c1b6aa67b43a3619cf"
  "/navigation/809a6c89b2e24a6e968249e00f115b90"
  "/navigation/c3057bb031634c669cd6dfb0d4acbb15"
  "/navigation/9d2b0fec9ebf49feb299f3060de6a174"
  "/navigation/9350ecd5bd6e4f85b7a14c85c0c3b31e"
  "/navigation/4aafda73311b49f5b9d06888f2608c18"
  "/navigation/7f29e74723ac457ea8c30ae0c3b2f598"
  "/navigation/905ec61c150b4ba69d966f2a32bd41e3"
  "/navigation/21ec9e984a904d34847f8a7cd57f822b"
  "/navigation/4be69f56bc6b40089c648434e5cbe159"
  "/navigation/5710f01394f54c8ba846acd95bdaa0f7"
  "/navigation/b69638776c1546ddba10d36087bd1dde"
  "/navigation/045ee9e57770451bb0a315bb33ac4ddc"
  "/navigation/98109c580f9441d6b72d8f1a031aa243"
  "/navigation/e379fcc096f343568dcb1e294d45c931"
  "/navigation/5d6b1f54e92c42bf89b512baf3b79e08"
  "/navigation/d60d60f6a5e044adbca44cbb25c3125b"
  "/navigation/bbc91f8512f3476697f0e9d4fd97483f"
  "/navigation/7356bb41f6fc4b168cc34fc7d92d7110"
  "/navigation/4924c22225644deea3a54c3ba6396c85"
  "/navigation/3bb3274a57f04bc9970c795f2dfddbe5"
  "/navigation/9d89181620be42dcb7e440ce0cd27456"
  "/navigation/e5fbe1167d8443fa95804dd5bbc6ba2e"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Íe’Æ6®Kóƒx°\x1A›1äm"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.72 ms
(4.42%) 		3 
-- seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND ((seo_path_info = ? OR seo_path_info = ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Íe’Æ6®Kóƒx°\x1A›1äm"
  "account/login"
  "account/login/"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.53 ms
(3.26%) 		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"""
    \x17\n
    C\x7F6ø@²—-ûrøæ¿b
    """
  b"\x1E›mÉ\vRG|·'÷ïeÆ]Ö"
  b"8X•p\x16dMä®HÀP\vóÌÈ"
  b"¸Rs=·eO;‚°T•Ë!ÚW"
  b"Ð[4\ÛyIgƒ\x12\x17[ÄLKL"
  b"á7Ž·€ŠG‘ž\rt\r]l\x1A"
  b"ï\x7FÙ.®S@I’\x06€\x12¨.’‹"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.51 ms
(3.17%) 		3 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"Íe’Æ6®Kóƒx°\x1A›1äm"
  "cSfLtwGhPGwLoiODikYNEdedhgVexPjw"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.46 ms
(2.84%) 		3 
-- seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (path_info = ?) AND (is_canonical = 1) LIMIT 1
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Íe’Æ6®Kóƒx°\x1A›1äm"
  "/account/login"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.41 ms
(2.52%) 		1 
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"w¹YÏfÞL\x15Çù·Ú9‚ó"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.41 ms
(2.50%) 		4 
#cart-persister::load
            SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters: 
[
  "cSfLtwGhPGwLoiODikYNEdedhgVexPjw"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.35 ms
(2.18%) 		2 
# navigation-route::meta-information
            SELECT LOWER(HEX(`id`)), `path`, `level`
            FROM `category`
            WHERE `id` = ? OR `id` = ?
Parameters: 
[
  b"w¹YÏfÞL\x15Çù·Ú9‚ó"
  b"w¹YÏfÞL\x15Çù·Ú9‚ó"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(2.07%) 		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"àT\fT±ìKÒ‡Õ©\x14x§ÖJ"
  b"".ÍuM.Cð³úXžNáé"
  b"""
    “DâcœCL\f$1¶C\n
    ¸\v
    """
  b"î¯PãŒÏK"”óv9Ÿ$=."
  b"DaÈ®¡\x18Nî£L&\x02Ÿ¯ÿ\x15"
  b"¼\x07“‡›Ll€R¯"‡™yb"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(2.07%) 		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/08b084b26e86408d8e14924df617c21c"
  "/navigation/3fcb62f34b934b4e8080f68dcbc0a562"
  "/navigation/85b1f115dd07486fa2776dae8c6e77b6"
  "/navigation/92d3e8ac7eb84d2b856fbad73154fa2d"
  "/navigation/8b906b975bfd41b3bd3eecade091b25f"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Íe’Æ6®Kóƒx°\x1A›1äm"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(2.02%) 		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"\x01›1{Aõpµ·ñ:C‹u\x10È"
  b"\x01›1{AüqU¢Ý}ìë(D}"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(1.97%) 		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"R\x1Ft\rHªK5ŸÞh\x07ÒñÜS"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(1.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: 
[
  "/account/recover"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Íe’Æ6®Kóƒx°\x1A›1äm"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(1.80%) 		1 
-- footer-pagelet::shipping-methods::search-ids
SELECT `shipping_method`.`id` FROM `shipping_method` LEFT JOIN `sales_channel_shipping_method` `shipping_method.salesChannels.mapping` ON `shipping_method`.`id` = `shipping_method.salesChannels.mapping`.`shipping_method_id`  LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `sales_channel` `shipping_method.salesChannels` ON `shipping_method.salesChannels.mapping`.`sales_channel_id` = `shipping_method.salesChannels`.`id`  WHERE (`shipping_method`.`active` = ? AND `shipping_method.salesChannels`.`id` = ?) GROUP BY `shipping_method`.`id` ORDER BY MIN(`shipping_method`.`position`) ASC, MIN(COALESCE(`shipping_method.translation.name`)) ASC
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  b"Íe’Æ6®Kóƒx°\x1A›1äm"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(1.78%) 		1 
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%"
  "%|abaa91cbfb46420c9d5607b65ce4e2bb|%"
  4
  true
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(1.67%) 		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"¦Ð­öhF@\x0F¶8æþ‡†‘å"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.22 ms
(1.36%) 		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.22 ms
(1.36%) 		1 
SELECT `salutation`.`id` as `salutation.id`, `salutation`.`salutation_key` as `salutation.salutationKey`, `salutation`.`created_at` as `salutation.createdAt`, `salutation`.`updated_at` as `salutation.updatedAt`, `salutation.translation.displayName`, `salutation.translation.displayName` as `salutation.displayName`, `salutation.translation.letterName`, `salutation.translation.letterName` as `salutation.letterName`, `salutation.translation.customFields`, `salutation.translation.customFields` as `salutation.customFields` FROM `salutation` LEFT JOIN (SELECT `salutation.translation`.`salutation_id`, `salutation.translation`.`display_name` as `salutation.translation.displayName`, `salutation.translation`.`letter_name` as `salutation.translation.letterName`, `salutation.translation`.`custom_fields` as `salutation.translation.customFields` FROM `salutation_translation` `salutation.translation` WHERE `salutation.translation`.`language_id` = ?) `salutation.salutation_translation` ON `salutation.salutation_translation`.`salutation_id` = `salutation`.`id`
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(1.26%) 		1 
-- footer-pagelet::payment-methods::search-ids
SELECT `payment_method`.`id` FROM `payment_method` LEFT JOIN `sales_channel_payment_method` `payment_method.salesChannels.mapping` ON `payment_method`.`id` = `payment_method.salesChannels.mapping`.`payment_method_id`  LEFT JOIN `sales_channel` `payment_method.salesChannels` ON `payment_method.salesChannels.mapping`.`sales_channel_id` = `payment_method.salesChannels`.`id`  WHERE (`payment_method`.`active` = ? AND `payment_method.salesChannels`.`id` = ?) GROUP BY `payment_method`.`id` ORDER BY MIN(`payment_method`.`position`) ASC
Parameters: 
[
  true
  b"Íe’Æ6®Kóƒx°\x1A›1äm"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.19 ms
(1.18%) 		1 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.19 ms
(1.17%) 		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.17 ms
(1.05%) 		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.17 ms
(1.04%) 		1 
-- header::currencies::search-ids
SELECT `currency`.`id` FROM `currency` LEFT JOIN `sales_channel_currency` `currency.salesChannels.mapping` ON `currency`.`id` = `currency.salesChannels.mapping`.`currency_id`  LEFT JOIN `sales_channel` `currency.salesChannels` ON `currency.salesChannels.mapping`.`sales_channel_id` = `currency.salesChannels`.`id`  WHERE (`currency.salesChannels`.`id` = ?) GROUP BY `currency`.`id`
Parameters: 
[
  b"Íe’Æ6®Kóƒx°\x1A›1äm"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.16 ms
(0.96%) 		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.15 ms
(0.95%) 		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.14 ms
(0.89%) 		1 
SELECT `sales_channel_country`.`sales_channel_id`, `sales_channel_country`.`country_id` FROM `sales_channel_country` WHERE (`sales_channel_country`.`sales_channel_id` = ? AND `sales_channel_country`.`country_id` = ?)
Parameters: 
[
  b"Íe’Æ6®Kóƒx°\x1A›1äm"
  b"Å\x08×PÉVKÿ»IQ\x1EøP\x08r"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.79%) 		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.11 ms
(0.69%) 		1 
SELECT path FROM category WHERE id = ?
Parameters: 
[
  b"w¹YÏfÞL\x15Çù·Ú9‚ó"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.10 ms
(0.64%) 		1 
SELECT
    `theme_id`,
    `technical_name`,
    `resolved_config`,
    `view_inheritance`,
    `script_files`,
    `icon_sets`,
    `updated_at`
    FROM `theme_runtime_config`
    WHERE `technical_name` = ?
Parameters: 
[
  "Storefront"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.09 ms
(0.58%) 		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.08 ms
(0.52%) 		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.