GET https://hauptverlag.staging.eurosoft.network/detail/2b5a0e68b2e0b28e2178c5965ffaac75

Response
200 OK
Browse referrer URL
IP
216.73.216.6
Profiled on
Token
430cd1

Query Metrics

71 Database Queries
57 Different statements
43.12 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
5.24 ms
(12.14%) 		1 
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`, (SELECT GROUP_CONCAT(HEX(`country.salesChannels.mapping`.`sales_channel_id`) SEPARATOR '||')
                  FROM `sales_channel_country` `country.salesChannels.mapping`
                  WHERE `country.salesChannels.mapping`.`country_id` = `country`.`id` ) as `country.salesChannels.id_mapping`, `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"\x01¥Ð¶œsu€\x1DPx\rF\x1C´"
  b"\x01¥Ð¶äqסÔ\x18­‚\x1E\x17“"
  b"\x01¥Ð¶èsÞ¨Õ\x06\x06ÂÚ,Ç"
  b"\x01¥Ð¹CpѮç¥\x10\x1F¸»"
  b"\x01¥Ð¹Fp§·bS±víeÌ"
  b"\x01¥Ð¹IqµŒUû¯ÄrŽ"
  b"\x01¥Ð¹Mq¡ŸØŒœ\x13ºŸí"
  b"\x01¥Ð¹Qq\x1C¡±ÏŸpeõ™"
  b"\x01¥Ð¹Ur\x00—ߎ´\A=ú"
  b"\x01¥Ð¹Yqv“ \f/3•]]"
  b"\x01¥Ð¹\r\x05”k\{œ4Æ\x1F"
  b"\x01¥Ð¹_s²½yñÿ\x15ÅLÏ"
  b"\x01¥Ð¹csIœ\x0E\x0F}`qûA"
  b"\x01¥Ð¹gpÍ°\x1AQ7›Ûr¤"
  b"\x01¥Ð¹jpÚª—º\x14.#Èi"
  b"\x01¥Ð¹ms\x03¿5=Ó\x03å¹'"
  b"\x01¥Ð¹pr0Ÿ/†ÁºÿâÆ"
  b"\x01¥Ð¹spohJ±\x05–\x18–"
  b"\x01¥Ðº\x1Cqò­b\x1C,h—{"
  b"\x01¥Ðº#pÁ‚rº\x07IÐ\n"
  b"""
    \x01¥Ðº*r\x06†g3ÝŽ‘\n
    ç
    """
  b"\x01¥Ðº.sv®ª\x13làÛÉ6"
  b"\x01¥Ðº2s&³\x15”‰~–~ø"
  b"\x01¥Ðº7sð¬,:M³¾6Ö"
  b"\x01¥Ðº;s;°¨c\x1Aç° €"
  b"\x01¥Ðº?rJžD:žr±ßî"
  b"\x01¥ÐºBpò·B\eÓ\x03Ö˜B"
  b"\x01¥ÐºFqp˜4\x1Ab\x15ùX "
  b"\x01¥ÐºKp\x16®ß´Ö\x05÷)ò"
  b"\x01¥ÐºNp:±^‹M¯z,Ü"
  b"\x01¥ÐºSpIŽÿ\x00OODˆ\x1D"
  b"\x01¥ÐºYp¦KÆ\x00ÊmJ"
  b"\x01¥Ðº_pI¶áÁB·«Ãù"
  b"\x01¥Ñ\x07xpv°’½ºëvÌõ"
  b"\x01¥Ñ\x07‹sÍ¡ž\vsv\x12\x13â"
  b"\x01¥Ñ\x07 p/ºJÐΔq¢"
  b"\x01¥Ñ\x07´sÍ¢£;\x03+™|š"
  b"\x01¥Ñ\x07Épȹáé}ƒP¢E"
  b"\x01¥Ñ\x07àrÏ‹J¾-YÊó®"
  b"\x01¥Ñ\x07óp+®KÅ\rœä™˜"
  b"\x01¥Ñ\x08\x06p.¨”\x15: &ö"
  b"\x01¥Ñ\x08\x1Aq\t»g\x07\x0EP’P\x1D"
  b"\x01¥Ñ\x08.r¾–LÏ"V¶A\f"
  b"\x01¥Ñ\x08Ap\x7F²ñ9E,\x19W\v"
  b"\x01¥Ñ\x08Wsô¨Mõ™\ëò"
  b"\x01¥Ñ\x08ksݘ¿æTgr ª"
  b"\x01¥Ñ\x08\x7Frþ‹˜0Šõ\x1E.Ð"
  b"\x01¥Ñ\x08•så«"âØÇ7&V"
  b"\x01¥Ñ\x08«qè†÷±\x00ÔÏ»+"
  b"\x01¥Ñ\x08Àpw‹ƒ¨ŸŸT_b"
  b"\x01¥Ñ\x08Ôs˪5»Y°´Ñ\x11"
  b"\x01¥Ñ\x08ìpܼÖ\x7FAÂÊîü"
  b"\x01¥Ñ\t\x02qt„[ÛLY¢J¶"
  b"\x01¥Ñ\t\x18rèË¦«œó¯Q"
  b"\x01¥Ñ\tOs\x0F™N\x7Fª‘\tJ"
  b"\x01¥Ñ\t|rü“MQè©\x00í"
  b"\x01¥Ñ\t¤rVœ\x12̐®,¦\x10"
  b"\x01¥Ñ\tÙpJŽ\x07uúÓ㬭"
  b"\x01¥Ñ\tðp€¥²×E”Åqú"
  b"""
    \x01¥Ñ\n
    \x03pÒ°(ŒÖ\x08|ñÂ
    """
  b"""
    \x01¥Ñ\n
    \x17s]“Ï‹Žãvû®
    """
  b"""
    \x01¥Ñ\n
    -s>¥ôé-š\x1Eö€
    """
  b"""
    \x01¥Ñ\n
    Bs¿™\x07ZÃh»r¯
    """
  b"""
    \x01¥Ñ\n
    XsLšê¯œ7ZH¶
    """
  b"""
    \x01¥Ñ\n
    lsÙ' À„À”<
    """
  b"""
    \x01¥Ñ\n
    pß‘`â\x12\x1C.™3
    """
  b"""
    \x01¥Ñ\n
    ™r£¥@:’.¡\x07\x13
    """
  b"""
    \x01¥Ñ\n
    ¬sO‘ô\eG*ùèT
    """
  b"""
    \x01¥Ñ\n
    ÀrIŒ‘pæhq‡a
    """
  b"""
    \x01¥Ñ\n
    Óq›—úñ‚ËIÄì
    """
  b"\x01¥Ñ\nêq[‡7\x00èÜDí\x1C"
  b"""
    \x01¥Ñ\n
    ÿsQ™‘\x1A\x18‘ÛV„
    """
  b"\x01¥Ñ\v\x13sг§!¿ü"
  b"\x01¥Ñ\v&qç¡Ã\x1Cå?ë\x05@"
  b"\x01¥Ñ\v9rä‹¥Ñ\r|'cH"
  b"\x01¥Ñ\vLs¯©Y\x0F\x0F™Sß "
  b"\x01¥Ñ\vgr<…Gj\x06:ªÑ"
  b"\x01¥Ñ\v{qõˆÅ;LŽ†ü¸"
  b"\x01¥Ñ\vq[±×\tépä“Ç"
  b"\x01¥Ñ\v¥sɻ˕\x11ªY\x7Fì"
  b"\x01¥Ñ\vºq\x03—\x15}q—b‘Õ"
  b"\x01¥Ñ\vÎpú„\tµx» ™ü"
  b"\x01¥Ñ\vãqF—\x1DÙ‹t\x02ò["
  b"\x01¥Ñ\vús\x1D†R²±›Øeå"
  b"\x01¥Ñ\f\rq‚ŽDƒS­ì"
  b"\x01¥Ñ\f$p5¢ñÞí`”áF"
  b"\x01¥Ñ\f7p€¯\x1D«èpُº"
  b"""
    \x01¥Ñ\fMsv\n
    \r$¡ÏcE
    """
  b"\x01¥Ñ\fapn‚¨•‡®\x19h"
  b"\x01¥Ñ\fwp¦¤6*€º;²\x11"
  b"\x01¥Ñ\f‹q…ŸXsò;à‰!"
  b"\x01¥Ñ\fŸq5»\x08u6­ÀâÙ"
  b"\x01¥Ñ\f³r–§YÛ\x00\x1C˜Ä@"
  b"\x01¥Ñ\fÇpW·À\x0FèBÆàm"
  b"\x01¥Ñ\fÛr†´\x06$so0­L"
  b"\x01¥Ñ\fðr\ršNj$l3‘\x1A"
  b"\x01¥Ñ\r\rróœc2‚\f|›`"
  b"\x01¥Ñ\r0pû *÷R¢Å«M"
  b"\x01¥Ñ\r[q\x0F‰gm˜@¯­*"
  b"\x01¥Ñ\r\x7Fq&˜P\x1Ax‚qj"
  b"\x01¥Ñ\r‘põٺ˜:\x0F'"
  b"\x01¥Ñ\r¦pv‰¹5áXú\x1A\n"
  b"\x01¥Ñ\r½r\v—GŽV–…Àñ"
  b"\x01¥Ñ\rÑrÞ²áßc(A\x03Ó"
  b"\x01¥Ñ\rãpR²wì¥ãpWh"
  b"\x01¥Ñ\r÷s–´å\x7FéuÆ›x"
  b"\x01¥Ñ\x0E\vqè˜Nu\x0F\x16‰l"
  b"\x01¥Ñ\x0E q;±ÌÊP\tnå…"
  b"\x01¥Ñ\x0E5r]‚Ù(`£­$H"
  b"\x01¥Ñ\x0EUr\e‘\x02“Q˜\x12~É"
  b"\x01¥Ñ\x0EjqEŽtÀ<ˆÿ ª"
  b"\x01¥Ñ\x0E~qjš—;ê­Ž@y"
  b"\x01¥Ñ\x0E“rê‚\x0EŸ\x154ë:T"
  b"\x01¥Ñ\x0E¦qúšóh‰ãÅ1\"
  b"\x01¥Ñ\x0E¸sc°!·cà-qL"
  b"\x01¥Ñ\x0EÌq[»¹IŒL:@™"
  b"\x01¥Ñ\x0Eßq0ž\x7F\x1En\x05VæØ"
  b"\x01¥Ñ\x0Eór²J³èM%ñ7"
  b"\x01¥Ñ\x0F\x06qo>_qä²Æü"
  b"\x01¥Ñ\x0F\x19sS‰—‚\x007\x7F\x1C9"
  b"\x01¥Ñ\x0F,rê®;Ãî~]å\v"
  b"\x01¥Ñ\x0FAq\x00 Õ\x16rêŸ\x15\v"
  b"\x01¥Ñ\x0FUr ²\f„oðd2f"
  b"\x01¥Ñ\x0Fip§†üî»kŠëx"
  b"\x01¥Ñ\x0Fzs_‡¾ü¦\x16ðZ×"
  b"\x01¥Ñ\x0FŽrP«ªE¼nŽr\x19"
  b"\x01¥Ñ\x0F¢pÿ€šd‰øb²ý"
  b"\x01¥Ñ\x0F¸q?“ŽNC\x03­Çè"
  b"\x01¥Ñ\x0FËq1€Ø&É+rµ\x04"
  b"\x01¥Ñ\x0FÞrK nÙÅ…¢zZ"
  b"\x01¥Ñ\x0Fñp\x04+üÁ<æ;Ž"
  b"\x01¥Ñ\x10\x05pHŠx ˆ \ÎË"
  b"\x01¥Ñ\x10\x18q?¸µa•iR "
  b"\x01¥Ñ\x10*p\x03‡øß\x0E\x05_±Ý"
  b"\x01¥Ñ\x10FqŽ¿£ê/éu\x1FÌ"
  b"\x01¥Ñ\x10Sp“Ÿî\x08jÔþhE"
  b"\x01¥Ñ\x10ksü»‹å~{d ¿"
  b"\x01¥Ñ\x10…r\x1A¿as‘zÖ\x160"
  b"\x01¥Ñ\x10¶sí­ŽÔ\x02òî–Ä"
  b"\x01¥Ñ\x10¿pVš²#¥#­Px"
  b"\x01¥Ñ\x10Åsr¾:\tJ‰\x1D4"
  b"\x01¥Ñ\x10ÌrûŸ\x02ÜãƒÈ;\x12"
  b"\x01¥Ñ\x10àrQŽQÿ¹Ð°’E"
  b"\x01¥Ñ\x10÷r¤Žo\x14Éí¶ì¾"
  b"\x01¥Ñ\x11"qp¤¯HŒRu¯ƒ"
  b"\x01¥Ñ\x11Qsà€”'$r’5\x11"
  b"\x01¥Ñ\x11}p$”¨–Þ‹\x1D\x05j"
  b"\x01¥Ñ\x11±p!­\x02¬"p¦›."
  b"\x01¥Ñ\x11ýr!¶Kóÿ\x0Eƒu\x03"
  b"\x01¥Ñ\x12\x03s?ŠÉï</\x00H-"
  b"\x01¥Ñ\x12\x08pݹI\Ú!kQþ"
  b"\x01¥Ñ\x12\x12q>³›,/`ýÆZ"
  b"\x01¥Ñ\x12%s݆ØÙMŠ£\f"
  b"""
    \x01¥Ñ\x12<q\n
    ‡\x19«¾u¯Öc
    """
  b"\x01¥Ñ\x12OrÀ¨Kêy^wèf"
  b"\x01¥Ñ\x12€q-¬çjá[†šö"
  b"\x01¥Ñ\x12†p…‚4[p¸Ìü¨"
  b"\x01¥Ñ\x12‹q\x07¡¤ï,uÌ÷s"
  b"\x01¥Ñ\x12’r!´)Á\x1C«—3\x0F"
  b"\x01¥Ñ\x12©r>½®‚¹GÃ9\x1C"
  b"\x01¥Ñ\x12»pžúú•û\x00ùù"
  b"\x01¥Ñ\x12Ñr¦§­×yòC\x02""
  b"\x01¥Ñ\x12òp˜¦•R\x15[Ÿ\x16Ù"
  b"\x01¥Ñ\x13\x03pø«¼ºsoÕh\x02"
  b"\x01¥Ñ\x13\x16s\x1A°æ^}Vföz"
  b"\x01¥Ñ\x13*s8°ãH…ʤF¿"
  b"\x01¥Ñ\x13=p¶©gk¿-ƒJÄ"
  b"\x01¥Ñ\x13Pq4›ðL¨\x19fŽÁ"
  b"\x01¥Ñ\x13asRˆ(üEV¡\x10Z"
  b"\x01¥Ñ\x13sqû²Qjÿ\x0EP\x045"
  b"\x01¥Ñ\x13‡q?½¡\x03œIM\x07¼"
  b"\x01¥Ñ\x13šrWŒŒÇò`\x1C­"
  b"\x01¥Ñ\x13´rõ½\x00f\x02É\x134¾"
  b"\x01¥Ñ\x13½r%¢\x13\x1A…-èÁ2"
  b"\x01¥Ñ\x13Òq\t•“\x15Þ´»üÞ"
  b"\x01¥Ñ\x13æp\x01 Eúª’^\x00&"
  b"\x01¥Ñ\x14\fsQ›Kïù$¸\f"
  b"\x01¥Ñ\x14\x12rK·f¹\eaâÀ_"
  b"\x01¥Ñ\x14\x1Fs£µçÙÒØ»Ž«"
  b"\x01¥Ñ\x140s˜»)g}Ü\x17Ú‰"
  b"\x01¥Ñ\x14Dqú¦\ÏŒp\x13\x14¼"
  b"\x01¥Ñ\x14\råŽlxá~´¶O"
  b"\x01¥Ñ\x14oqÍœîfÌXB\x01c"
  b"\x01¥Ñ\x14„rò¡ÐspŽtþN"
  b"\x01¥Ñ\x14œráôƒ—Z\x04ØY"
  b"\x01¥Ñ\x14¯s”fÊ•hÒ2§"
  b"\x01¥Ñ\x14Ås¶’Á•!\x17¢¬ä"
  b"\x01¥Ñ\x14çpÕ‹òÇ“•¥×ç"
  b"\x01¥Ñ\x15\x0EpK¹ÇŒý\x0E$Ü€"
  b"\x01¥Ñ\x15<qޏÙa|\x01”€c"
  b"\x01¥Ñ\x15bs.˜¨K\x08¾R\x01\x04"
  b"\x01¥Ñ\x15Œrɾö±^d›ç›"
  b"\x01¥Ñ\x15²pM–èxL"þU\x0F"
  b"\x01¥Ñ\x15Çqó¦ã\x0EFT‰úÏ"
  b"\x01¥Ñ\x15Ùp¶¢AáÙ~ÂáJ"
  b"\x01¥Ñ\x15ìq³‹Mý}—kÑž"
  b"\x01¥Ñ\x15ÿro‰Úæ‚Mwþ\x06"
  b"\x01¥Ñ\x16\x12qQ‰\x07[\rEI‹"
  b"\x01¥Ñ\x16'rd­t†ã£½ªm"
  b"\x01¥Ñ\x168p\x19–¥>øô»ZÝ"
  b"\x01¥Ñ\x16Mq…š\x07áH²UVj"
  b"\x01¥Ñ\x16`q-‡\x04‘kp\x10H"
  b"\x01¥Ñ\x16sr\x02››¿L¨ý¢"
  b"\x01¥Ñ\x16…quŒ\x7F÷áÅÄØÖ"
  b"\x01¥Ñ\x16™r!´Ü\r‹Ä\x17j<"
  b"\x01¥Ñ\x16­p ’ÑN:‰‰ù"
  b"\x01¥Ñ\x16ÂrP“–.•\x18\x1CþR"
  b"\x01¥Ñ\x16Ös\x01»°ïw_B¬*"
  b"\x01¥Ñ\x16ést°Ù\x13ëÁm\x1Dz"
  b"\x01¥Ñ\x16úr&Šž¸%®Ï¯{"
  b"\x01¥Ñ\x17\x11sA¶v\x05;n´ª\r"
  b"\x01¥Ñ\x17"s¬¬%oâ]7æ\x10"
  b"\x01¥Ñ\x176r§ŒVöÒg^Ò;"
  b"\x01¥Ñ\x17Jrá½}c—x/\x1D¡"
  b"\x01¥Ñ\x17^p¡»kÙ[?Š,W"
  b"\x01¥Ñ\x17qs\x04£\x14œ1; ¢Ž"
  b"\x01¥Ñ\x17…pŸŽÝ¡V¶\eÐÍ"
  b"\x01¥Ñ\x17¦p蕧|Éèïΰ"
  b"""
    \x01¥Ñ\x17¾r·–ºÀ\n
    Œq\x055
    """
  b"\x01¥Ñ\x17ÖsA…ôàãùËo\x00"
  b"\x01¥Ñ\x17åqí£ß+yÌ,\fÍ"
  b"\x01¥Ñ\x18 s®¥¤MU\x18PÚ"
  b"\x01¥Ñ\x182q+“+Ü“éÑ\x1DE"
  b"\x01¥Ñ\x18Hr®ºãi\x17;Z÷±"
  b"\x01¥Ñ\x18\qþ˜I¹e[úÚ\x04"
  b"\x01¥Ñ\x18rp¤Ý\x7FݔɄÃ"
  b"\x01¥Ñ\x18†pÓ-ǬÉð·_"
  b"\x01¥Ñ\x18™pp³\x04ÆiÈPÜ\x19"
  b"\x01¥Ñ\x18®pS°ûL-Ï>£l"
  b"\x01¥Ñ\x18Ñs-Ž\x18¼÷BZ™"
  b"\x01¥Ñ\x18âqÛ‰G}\v‡4Ñf"
  b"\x01¥Ñ\x18ùsr¤\vcíûŒGC"
  b"""
    \x01¥Ñ\x19\n
    q„¨¸¤rêÀ)ª
    """
  b"\x01¥Ñ\x19!q\x7Fªöë/“(H"
  b"\x01¥Ñ\x195q”¯98Í-ÖÚ:"
  b"\x01¥Ñ\x19Nq#¡÷+¾Ù9Fá"
  b"\x01¥Ñ\x19bpr€§>\x15g7üq"
  b"\x01¥Ñ\x19xq˜‰—úP\x1A£v€"
  b"\x01¥Ñ\x19Žs(¸ùýx-\x01J"
  b"\x01¥Ñ\x19 qO¢‰e(Ê\XŠ"
  b"\x01¥Ñ\x19²rè¸Ú|Ã’¦ñ¿"
  b"\x01¥Ñ\x19ÇriL\x7FÑ°Â.A"
  b"\x01¥Ñ\x19Ør†±Gñì÷]”“"
  b"\x01¥Ñ\x19îs`€ŠäeÈ6ºƒ"
  b"\x01¥Ñ\x1A\x04p—«šÐº\x17\x1489"
  b"\x01¥Ñ\x1A\x17s\x1F²ØÙÉcá6˜"
  b"\x01¥Ñ\x1A)r·“‰ËjDú‹±"
  b"\x01¥Ñ\x1A<q\x00¶`L»…ô­—"
  b"\x01¥Ñ\x1ASpÕŠ-ןQBÊÙ"
  b"\x01¥Ñ\x1AfpH´¸\x05\x16àŠ\x11×"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.95 ms
(11.49%) 		1 
-- seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (seo_url.language_id = ?) AND (seo_url.sales_channel_id = ? OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0)
Parameters: 
[
  "/detail/2b5a0e68b2e0b28e2178c5965ffaac75"
  "/navigation/0191991d5eb67fd4b567fba328e920b9"
  "/navigation/0191ee79a6787f3ebee5fac531dd762f"
  "/navigation/0191ee79d625774ea134623944f3fcbb"
  "/navigation/0191ee79f4297d84b7916c7493090310"
  "/navigation/0191ee8834aa7e0bacebfed3705d2f42"
  "/navigation/0191ee7b08dc78f49e8cc3d05be28f77"
  "/navigation/0191ee6d4d6b7fc5bcad94019bf1e96b"
  "/navigation/0191ee6d70757a6ca9c423539622f9ae"
  "/navigation/0191ee6d8fb27f8eb69858c1e836a16a"
  "/navigation/0191ee6db9f3790d80e39026e4cd8ebb"
  "/navigation/0191ee6ddae6739ba84e5b6196ec2c88"
  "/navigation/0191ee6dfd087c0dacb354db6e3d36ef"
  "/navigation/0191ee6e265d768a91a683a7ef2d63fc"
  "/navigation/0191ee6e4a32731a900bb77db5d36c32"
  "/navigation/0191ee6e78d2746ca16d6b93bada0a81"
  "/navigation/0191ee6ea63a7c8bbdbda9515feddae9"
  "/navigation/0191ee6edf2d765283cc5d79189f0394"
  "/navigation/0191ee6ef1fe75429f15660a27ec31ba"
  "/navigation/019bbc13360772d48aa0e775b36078fc"
  "/navigation/0191ee7a8eff7f1ebc65845f5e28284c"
  "/navigation/0191ee8f84c671d78bd828bdfaa24128"
  "/navigation/0191ee8fb87e7680b42765fffe64b6c2"
  "/navigation/0191ee8fcf8c70738480b2ab98219716"
  "/navigation/019bbc8addde7ec0b9de3c09f9d67c79"
  "/navigation/0191ee8b859d7e7da514bdc0768cc521"
  "/navigation/0191ee8ba2087cf980fe6bcb30af6db2"
  "/navigation/0191ee8bbda37bd7b9e0fad4751a32ce"
  "/navigation/0191ee8bcfe27cbaa3ff3939db0de93a"
  "/navigation/0191ee8bf4fb72e48edc1694c64a24be"
  "/navigation/0191ee8bfdd076bbb2a4eb12e1fbb085"
  "/navigation/0191ee8c0f2a7b958b4976e43d13f1bd"
  "/navigation/0191ee8c2af57498845593f11f801c1e"
  "/navigation/0191ee8c39b071929ec9011fc654c0d4"
  "/navigation/0191ee8c48587f56b6507202f96c078a"
  "/navigation/0191ee8c6b317bf8bac59dd0539ee242"
  "/navigation/0191ee8c9ffd7531921fa96cd08e6870"
  "/navigation/019bbc1f5a437136aab323feda1d2318"
  "/navigation/0191ee88ef8870e39e23e5c220b067fb"
  "/navigation/0191ee8904567fe7adbab40cfc5d69d5"
  "/navigation/0191ee8923c472ab81aa73663f7cf3f7"
  "/navigation/0191ee894a09763b8057e91754cef150"
  "/navigation/0191ee8968177963ac3aa14c10d37bc9"
  "/navigation/0191ee89779879ef963e6f1540030795"
  "/navigation/0191ee89884e78368492ab963012db6c"
  "/navigation/0191ee8998cc7222b91ba046b53192f9"
  "/navigation/019bbc8c364e78b38debf325c0948ed3"
  "/navigation/0197eab99a3e75dd8ad2c73889740341"
  "/navigation/0197d448ba2c7b199942eb3f22924203"
  "/navigation/0197eaba7b8c7e55abd85d988e9cee74"
  "/navigation/0197eaba9d2e7732bf768c604fd3f081"
  "/navigation/0191ee7ba89c75a2ba0ab988a5d8eb41"
  "/navigation/0197c6cd65837af7b7b5bb1d07118f90"
  "/navigation/0197c6cda35d73078fe33fce062c3f8f"
  "/navigation/0197c6cdef4e7480ad18f56a29f1c2de"
  "/navigation/0197c6ce0f52712a82719412b96a72cc"
  "/navigation/0197c6ce2a9d71d29ab20a61450751f4"
  "/navigation/0197c6ce5f5877dab18548a7feca9cb0"
  "/navigation/0191ee7bbca17c70b8fafb3b5ba5e986"
  "/navigation/0197cbf7289070ac9957fb8239ac36f3"
  "/navigation/0197cbf7897d714382426d8376f4bfc8"
  "/navigation/0191ee7bd61d725cb9b1f1665a57ff2b"
  "/navigation/0191ee7bf27c7f0b9d4b926ed5083238"
  "/navigation/0197e971cb747e65b6c65a1d256f4ea2"
  "/navigation/0197e97244247d2bb74e791fd85fb1fd"
  "/navigation/019690bc6707711e88da28969c511a89"
  "/navigation/0197cbb94c187370ae556386a7468a03"
  "/navigation/0197cbb986f570fb8b2eed529ea53e75"
  "/navigation/0191ee7c21677f4595a2b91b0303681d"
  "/navigation/0190ba53fe0673a28d789f957f8c8db7"
  "/navigation/0190ba542b957fab996cb7ede232036e"
  "/navigation/0190ba5447c07f729e5aac14ab3977b8"
  "/navigation/0190ba546be170968b14cb8c25875a2a"
  "/navigation/0190ba58be4b7a20a08c5bb8c1a6daaf"
  "/navigation/0190ba556daf75c1a2780021b765e2d9"
  "/navigation/0190ba558dea7f4ca2e1a2d8a22b1081"
  "/navigation/0190ba55964f7ad9bcf0d435407e367f"
  "/navigation/0190ba55c18b70218fa12367468dc14a"
  "/navigation/0190ba5826c97e72ad021d9ac2ab2ffb"
  "/navigation/0190ba583d7d773387a1506471bed744"
  "/navigation/0190ba5869fe70f79e656dfa6b015df2"
  "/navigation/01968c734b3f7eef8c0efce23dddc529"
  "/navigation/0190ba58834b73568e28fef89cb2b86f"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.12 ms
(4.91%) 		4 
SELECT LOWER(HEX(seo_url.id)) as id, LOWER(HEX(seo_url.foreign_key)) foreignKey, LOWER(HEX(seo_url.sales_channel_id)) salesChannelId, seo_url.is_modified as isModified, seo_url.seo_path_info seoPathInfo FROM seo_url seo_url WHERE (seo_url.route_name = ?) AND (seo_url.language_id = ?) AND (seo_url.is_canonical = 1) AND (seo_url.foreign_key IN (?))
Parameters: 
[
  "frontend.detail.page"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"+Z\x0Eh²à²Ž!xÅ–_ú¬u"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.39 ms
(3.22%) 		1 
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`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.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 (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` WHERE `sales_channel`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"˜C-ï9üF$³2\x13¥kŒ”M"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01‘J13£x"‰m\fp²ý;g"
  b"˜C-ï9üF$³2\x13¥kŒ”M"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01‘J13£x"‰m\fp²ý;g"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.38 ms
(3.19%) 		1 
SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id`  LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id`  WHERE (`country.salesChannels`.`id` = ?) GROUP BY `country`.`id`
Parameters: 
[
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.33 ms
(3.08%) 		4 
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (?)) AND (sales_channel_id = ?)
Parameters: 
[
  b"+Z\x0Eh²à²Ž!xÅ–_ú¬u"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.15 ms
(2.67%) 		1 
SELECT `scop_platform_redirecter_redirect`.`id` FROM `scop_platform_redirecter_redirect` WHERE (`scop_platform_redirecter_redirect`.`sourceURL` IN (?, ?, ?, ?, ?, ?, ?) AND `scop_platform_redirecter_redirect`.`enabled` = ? AND (`scop_platform_redirecter_redirect`.`salesChannelId` = ? OR `scop_platform_redirecter_redirect`.`salesChannelId` <=> ?)) LIMIT 1
Parameters: 
[
  "//wirksame-fuehrung-und-aufsicht-von-not-for-profit-organisationen/23138572498"
  "/wirksame-fuehrung-und-aufsicht-von-not-for-profit-organisationen/23138572498"
  "https://hauptverlag.staging.eurosoft.network/wirksame-fuehrung-und-aufsicht-von-not-for-profit-organisationen/23138572498"
  "https://hauptverlag.staging.eurosoft.network//wirksame-fuehrung-und-aufsicht-von-not-for-profit-organisationen/23138572498"
  "/wirksame-fuehrung-und-aufsicht-von-not-for-profit-organisationen/23138572498"
  "//wirksame-fuehrung-und-aufsicht-von-not-for-profit-organisationen/23138572498"
  "wirksame-fuehrung-und-aufsicht-von-not-for-profit-organisationen/23138572498"
  true
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
1.07 ms
(2.48%) 		1 
SELECT `meta_catalog_id`.`id` FROM `meta_catalog_id` WHERE `meta_catalog_id`.`id` IN (?, ?)
Parameters: 
[
  b"+Z\x0Eh²à²Ž!xÅ–_ú¬u"
  b"™\x085-äp\x01ǐú®Â†\x1FÖt"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.90 ms
(2.09%) 		1 
SELECT `plugin`.`id` as `plugin.id`, `plugin`.`base_class` as `plugin.baseClass`, `plugin`.`name` as `plugin.name`, `plugin`.`composer_name` as `plugin.composerName`, `plugin`.`autoload` as `plugin.autoload`, `plugin`.`active` as `plugin.active`, `plugin`.`managed_by_composer` as `plugin.managedByComposer`, `plugin`.`path` as `plugin.path`, `plugin`.`author` as `plugin.author`, `plugin`.`copyright` as `plugin.copyright`, `plugin`.`license` as `plugin.license`, `plugin`.`version` as `plugin.version`, `plugin`.`upgrade_version` as `plugin.upgradeVersion`, `plugin`.`installed_at` as `plugin.installedAt`, `plugin`.`upgraded_at` as `plugin.upgradedAt`, `plugin`.`icon` as `plugin.iconRaw`, `plugin`.`created_at` as `plugin.createdAt`, `plugin`.`updated_at` as `plugin.updatedAt`, `plugin.translation.label`, `plugin.translation.label` as `plugin.label`, `plugin.translation.description`, `plugin.translation.description` as `plugin.description`, `plugin.translation.manufacturerLink`, `plugin.translation.manufacturerLink` as `plugin.manufacturerLink`, `plugin.translation.supportLink`, `plugin.translation.supportLink` as `plugin.supportLink`, `plugin.translation.customFields`, `plugin.translation.customFields` as `plugin.customFields` FROM `plugin` LEFT JOIN (SELECT `plugin.translation`.`plugin_id`, `plugin.translation`.`label` as `plugin.translation.label`, `plugin.translation`.`description` as `plugin.translation.description`, `plugin.translation`.`manufacturer_link` as `plugin.translation.manufacturerLink`, `plugin.translation`.`support_link` as `plugin.translation.supportLink`, `plugin.translation`.`custom_fields` as `plugin.translation.customFields` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation`.`language_id` = ?) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` WHERE (`plugin`.`name` = ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  "esMetaCatalog6"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.90 ms
(2.08%) 		1 
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x01˜3\x1Aì†sÞºð\x19KHB\x00Ï"
  b"\x01˜8\x07³.su·M\x1Fàë\x042‰"
  b"\x01˜8\x1DJ$y\x04‰²±!øË\t5"
  b"\x01‘jÿ\x7FíqÔŽ\x11\x1DñMˆwÃ"
  b"\x01‘k\x06àŽr\x16‡BÁ¶ûƒ9i"
  b"\x01‘k\x07õ>xý©g\x0Fó~\eÿ«"
  b"\x01–g^Ü\x1Ar1™ŽnÉf™’²"
  b"""
    \x01—Àï¿ýp\x0E´ë%¬óf\n
    õ
    """
  b"\x01˜,\x033Õr©€AÃ\x1Aݯßï"
  b"\x01˜6Sà\x01}þ‹|&Y¹Íå¥"
  b"\x01˜7ú\x1Ccr²¦¸foB$\x16é"
  b"\x01˜­\x04y/y\x0F¤úé4Z˜\x11Ô"
  b"\x01¥Ðºzs:‹Uo¨üG"
  b"\x01¥ÐºÇsl´Çäæ:\x7Fj7"
  b"\x01¥ÐøápQ…·ÄÏCª\x1E\t"
  b"\x01‘™IY\x7F|ù•/ˆÓÉ’!‚"
  b"\x01¥Ð»ds”†6…LhKŸÙ"
  b"\x01—ù%gŽr\x08®xàxv9RÎ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.87 ms
(2.01%) 		2 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.78 ms
(1.81%) 		1 
SELECT LOWER(HEX(`id`)) AS `id` FROM `moorl_magazine_article` WHERE (`updated_at` IS NULL OR (`show_from` > `updated_at` AND `show_from` < '2026-04-08T12:00:36+00:00') OR (`show_until` > `updated_at` AND `show_until` < '2026-04-08T12:00:36+00:00')) AND `active` = '1';
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.76 ms
(1.77%) 		4 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.75 ms
(1.75%) 		1 
SELECT COUNT(DISTINCT `product_review`.`id`) as `review-count` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` WHERE (((`product_review`.`status` = ?) AND (`product_review.product`.`id` = ? OR `product_review.product`.`parent_id` = ?)))
Parameters: 
[
  true
  b"+Z\x0Eh²à²Ž!xÅ–_ú¬u"
  b"+Z\x0Eh²à²Ž!xÅ–_ú¬u"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.74 ms
(1.71%) 		4 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.72 ms
(1.66%) 		1 
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"\x01¥Ð¹ms\x03¿5=Ó\x03å¹'"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.67 ms
(1.56%) 		1 
-- product::cms-page::association::sections::read
SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`position` as `cms_section.position`, `cms_section`.`type` as `cms_section.type`, `cms_section`.`locked` as `cms_section.locked`, `cms_section`.`name` as `cms_section.name`, `cms_section`.`sizing_mode` as `cms_section.sizingMode`, `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`, `cms_section`.`background_color` as `cms_section.backgroundColor`, `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`, `cms_section`.`css_class` as `cms_section.cssClass`, `cms_section`.`cms_page_id` as `cms_section.pageId`, `cms_section`.`visibility` as `cms_section.visibility`, `cms_section`.`custom_fields` as `cms_section.customFields`, `cms_section`.`version_id` as `cms_section.versionId`, `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`, `cms_section`.`created_at` as `cms_section.createdAt`, `cms_section`.`updated_at` as `cms_section.updatedAt`, `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`config` as `cms_section.backgroundMedia.config`, `cms_section.backgroundMedia`.`path` as `cms_section.backgroundMedia.path`, `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`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ïx-Çs]™–Z×^V›¥"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.64 ms
(1.48%) 		1 
-- 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"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  "wirksame-fuehrung-und-aufsicht-von-not-for-profit-organisationen/23138572498"
  "wirksame-fuehrung-und-aufsicht-von-not-for-profit-organisationen/23138572498/"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.63 ms
(1.46%) 		1 
SELECT `meta_catalog_id`.`id` as `meta_catalog_id.id`, `meta_catalog_id`.`type` as `meta_catalog_id.type`, `meta_catalog_id`.`number` as `meta_catalog_id.number`, `meta_catalog_id`.`created_at` as `meta_catalog_id.createdAt`, `meta_catalog_id`.`updated_at` as `meta_catalog_id.updatedAt` FROM `meta_catalog_id` WHERE ((`meta_catalog_id`.`type` = ?)) AND (`meta_catalog_id`.`id` IN (?))
Parameters: 
[
  "product"
  b"+Z\x0Eh²à²Ž!xÅ–_ú¬u"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.62 ms
(1.44%) 		1 
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`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.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 (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`
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.60 ms
(1.40%) 		1 
SELECT `property_group`.`id` as `property_group.id`, `property_group`.`display_type` as `property_group.displayType`, `property_group`.`sorting_type` as `property_group.sortingType`, `property_group`.`filterable` as `property_group.filterable`, `property_group`.`visible_on_product_detail_page` as `property_group.visibleOnProductDetailPage`, `property_group`.`created_at` as `property_group.createdAt`, `property_group`.`updated_at` as `property_group.updatedAt`, `property_group.translation.name`, `property_group.translation.name` as `property_group.name`, `property_group.translation.description`, `property_group.translation.description` as `property_group.description`, `property_group.translation.position`, `property_group.translation.position` as `property_group.position`, `property_group.translation.customFields`, `property_group.translation.customFields` as `property_group.customFields` FROM `property_group` LEFT JOIN (SELECT `property_group.translation`.`property_group_id`, `property_group.translation`.`name` as `property_group.translation.name`, `property_group.translation`.`description` as `property_group.translation.description`, `property_group.translation`.`position` as `property_group.translation.position`, `property_group.translation`.`custom_fields` as `property_group.translation.customFields` FROM `property_group_translation` `property_group.translation` WHERE `property_group.translation`.`language_id` = ?) `property_group.property_group_translation` ON `property_group.property_group_translation`.`property_group_id` = `property_group`.`id`
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.59 ms
(1.38%) 		1 
SELECT DISTINCT
               LOWER(HEX(sales_channel.id)) AS salesChannelId,
               LOWER(HEX(domains.language_id)) AS languageId
             FROM sales_channel_domain AS domains
             INNER JOIN sales_channel
               ON domains.sales_channel_id = sales_channel.id
               AND sales_channel.active = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.59 ms
(1.37%) 		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.59 ms
(1.37%) 		1 
# product-detail-route::check-variant-listing-config
            SELECT
                variant_listing_config as variantListingConfig,
                parent_id as parentId
            FROM product
            WHERE id = ?
            AND version_id = ?
Parameters: 
[
  b"+Z\x0Eh²à²Ž!xÅ–_ú¬u"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.58 ms
(1.34%) 		1 
SELECT LOWER(HEX(article_id)) as article_id
FROM moorl_magazine_article_product
WHERE product_id = :product_id
Parameters: 
[
  "product_id" => b"+Z\x0Eh²à²Ž!xÅ–_ú¬u"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(1.32%) 		1 
-- product::cms-page::association::sections::association::blocks::read
SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`position` as `cms_block.position`, `cms_block`.`type` as `cms_block.type`, `cms_block`.`locked` as `cms_block.locked`, `cms_block`.`name` as `cms_block.name`, `cms_block`.`section_position` as `cms_block.sectionPosition`, `cms_block`.`margin_top` as `cms_block.marginTop`, `cms_block`.`margin_bottom` as `cms_block.marginBottom`, `cms_block`.`margin_left` as `cms_block.marginLeft`, `cms_block`.`margin_right` as `cms_block.marginRight`, `cms_block`.`background_color` as `cms_block.backgroundColor`, `cms_block`.`background_media_id` as `cms_block.backgroundMediaId`, `cms_block`.`background_media_mode` as `cms_block.backgroundMediaMode`, `cms_block`.`css_class` as `cms_block.cssClass`, `cms_block`.`visibility` as `cms_block.visibility`, `cms_block`.`cms_section_id` as `cms_block.sectionId`, `cms_block`.`custom_fields` as `cms_block.customFields`, `cms_block`.`version_id` as `cms_block.versionId`, `cms_block`.`cms_section_version_id` as `cms_block.cmsSectionVersionId`, `cms_block`.`created_at` as `cms_block.createdAt`, `cms_block`.`updated_at` as `cms_block.updatedAt`, `cms_block.backgroundMedia`.`id` as `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` as `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` as `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` as `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` as `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` as `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` as `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` as `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` as `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` as `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`config` as `cms_block.backgroundMedia.config`, `cms_block.backgroundMedia`.`path` as `cms_block.backgroundMedia.path`, `cms_block.backgroundMedia`.`private` as `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`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ïx-ërý´—¬4\x1E²\r¤"
  b"\x01.…7Ž\x7F؇`s3mX_Þ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(1.32%) 		1 
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: 
[
  "/detail/2b5a0e68b2e0b28e2178c5965ffaac75"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01¥Ò\x15Xp\x1C±z\x1F‰™\x1D\x17â"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(1.32%) 		1 
-- product-review-route::aggregation::customer-login-filter
SELECT `product_review`.`points` as `ratingMatrix.key`, COUNT(`product_review`.`id`) as `ratingMatrix.count` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` WHERE ((((`product_review`.`status` = ?) AND (`product_review.product`.`id` = ? OR `product_review.product`.`parent_id` = ?)))) AND (((`product_review`.`status` = ?))) GROUP BY `product_review`.`points`
Parameters: 
[
  true
  b"+Z\x0Eh²à²Ž!xÅ–_ú¬u"
  b"+Z\x0Eh²à²Ž!xÅ–_ú¬u"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(1.31%) 		1 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  "5p1UPJfbixnarRjsMa9xYCiYbkRSw08Q"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.56 ms
(1.30%) 		2 
SELECT LOWER(HEX(parent_id)) FROM language WHERE id = ?
Parameters: 
[
  "0190a5d21558701cb17a1f89991d17e2"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.55 ms
(1.27%) 		1 
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`.`iso_code` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  "CHF"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.52 ms
(1.20%) 		1 
-- product-cross-selling-route::search-ids
SELECT `product_cross_selling`.`id` FROM `product_cross_selling` LEFT JOIN `product` `product_cross_selling.product` ON `product_cross_selling`.`product_id` = `product_cross_selling.product`.`crossSellings` AND `product_cross_selling`.`product_version_id` = `product_cross_selling.product`.`version_id` LEFT JOIN `product` `product_cross_selling.product.parent` ON `product_cross_selling.product`.`parent_id` = `product_cross_selling.product.parent`.`id` AND `product_cross_selling.product`.`parent_version_id` = `product_cross_selling.product.parent`.`version_id` WHERE (`product_cross_selling.product`.`id` = ? AND `product_cross_selling`.`active` = ?) ORDER BY `product_cross_selling`.`position` ASC
Parameters: 
[
  b"+Z\x0Eh²à²Ž!xÅ–_ú¬u"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.50 ms
(1.17%) 		1 
-- product::cms-page::association::sections::association::blocks::association::slots::read
SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`type` as `cms_slot.type`, `cms_slot`.`slot` as `cms_slot.slot`, `cms_slot`.`locked` as `cms_slot.locked`, `cms_slot`.`cms_block_id` as `cms_slot.blockId`, `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.translation.config`, `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 (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` WHERE (`cms_slot`.`version_id` = ?) AND ((`cms_slot`.`cms_block_id` IN (?, ?, ?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01ïx-ërý´—¬4 üY”"
  b"\x01ïx-ìruº*\x12\x029\x10Z"
  b"\x01ïx-ìruº*\x12\x02©Võ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.45 ms
(1.03%) 		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.43 ms
(1.01%) 		1 
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"\x01¦Jœ&p•²ÇŠÿÞ“šà"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.43 ms
(1.00%) 		1 
-- product::cms-page::read
SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`version_id` as `cms_page.versionId`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`css_class` as `cms_page.cssClass`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.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` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01ïx-Çs]™–Z×^V›¥"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.43 ms
(1.00%) 		1 
-- product-price-calculator::units::read
SELECT `unit`.`id` as `unit.id`, `unit`.`created_at` as `unit.createdAt`, `unit`.`updated_at` as `unit.updatedAt`, `unit.translation.shortCode`, `unit.translation.shortCode` as `unit.shortCode`, `unit.translation.name`, `unit.translation.name` as `unit.name`, `unit.translation.customFields`, `unit.translation.customFields` as `unit.customFields` FROM `unit` LEFT JOIN (SELECT `unit.translation`.`unit_id`, `unit.translation`.`short_code` as `unit.translation.shortCode`, `unit.translation`.`name` as `unit.translation.name`, `unit.translation`.`custom_fields` as `unit.translation.customFields` FROM `unit_translation` `unit.translation` WHERE `unit.translation`.`language_id` = ?) `unit.unit_translation` ON `unit.unit_translation`.`unit_id` = `unit`.`id`
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.40 ms
(0.94%) 		1 
-- product-review-route::aggregation::language-filter
SELECT LOWER(HEX(`product_review`.`language_id`)) as `languageMatrix.key`, COUNT(`product_review`.`id`) as `languageMatrix.count` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` WHERE ((((`product_review`.`status` = ?) AND (`product_review.product`.`id` = ? OR `product_review.product`.`parent_id` = ?)))) AND ((`product_review`.`language_id` = ? AND (`product_review`.`status` = ?))) GROUP BY `product_review`.`language_id`
Parameters: 
[
  true
  b"+Z\x0Eh²à²Ž!xÅ–_ú¬u"
  b"+Z\x0Eh²à²Ž!xÅ–_ú¬u"
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(0.91%) 		1 
-- sales-channel::load-analytics::read
SELECT `sales_channel_analytics`.`id` as `sales_channel_analytics.id`, `sales_channel_analytics`.`tracking_id` as `sales_channel_analytics.trackingId`, `sales_channel_analytics`.`active` as `sales_channel_analytics.active`, `sales_channel_analytics`.`track_orders` as `sales_channel_analytics.trackOrders`, `sales_channel_analytics`.`anonymize_ip` as `sales_channel_analytics.anonymizeIp`, `sales_channel_analytics`.`created_at` as `sales_channel_analytics.createdAt`, `sales_channel_analytics`.`updated_at` as `sales_channel_analytics.updatedAt` FROM `sales_channel_analytics` WHERE `sales_channel_analytics`.`id` IN (?)
Parameters: 
[
  b"\x01—œHí<wEªXfÔ5¸·Þ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(0.90%) 		1 
-- breadcrumb-builder::main-category::search-ids
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `main_category` `category.mainCategories` ON `category`.`id` = `category.mainCategories`.`category_id` AND `category`.version_id = `category.mainCategories`.category_version_id WHERE (`category`.`version_id` = ?) AND (((`category.mainCategories`.`product_id` = ? AND `category.mainCategories`.`sales_channel_id` = ? AND (`category`.`path` LIKE ? OR `category`.`path` LIKE ?)))) LIMIT 1
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"+Z\x0Eh²à²Ž!xÅ–_ú¬u"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  "%|0191991a105174c48f1b28c088885668|%"
  "%|0190ba4e482679e083203b767c4e3a53|%"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.38 ms
(0.89%) 		1 
-- product-review-route::search-ids
SELECT `product_review`.`id` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` WHERE (((`product_review`.`status` = ?) AND (`product_review.product`.`id` = ? OR `product_review.product`.`parent_id` = ?))) ORDER BY `product_review`.`created_at` DESC LIMIT 10
Parameters: 
[
  true
  b"+Z\x0Eh²à²Ž!xÅ–_ú¬u"
  b"+Z\x0Eh²à²Ž!xÅ–_ú¬u"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.37 ms
(0.85%) 		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"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¥Ð¹ms\x03¿5=Ó\x03å¹'"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.35 ms
(0.81%) 		1 
SELECT COUNT(*) FROM (-- product-review-route::search-ids
SELECT `product_review`.`id` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` WHERE (((`product_review`.`status` = ?) AND (`product_review.product`.`id` = ? OR `product_review.product`.`parent_id` = ?)))) total
Parameters: 
[
  true
  b"+Z\x0Eh²à²Ž!xÅ–_ú¬u"
  b"+Z\x0Eh²à²Ž!xÅ–_ú¬u"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.34 ms
(0.79%) 		1 
SELECT `delivery_time`.`id` as `delivery_time.id`, `delivery_time`.`min` as `delivery_time.min`, `delivery_time`.`max` as `delivery_time.max`, `delivery_time`.`unit` as `delivery_time.unit`, `delivery_time`.`created_at` as `delivery_time.createdAt`, `delivery_time`.`updated_at` as `delivery_time.updatedAt`, `delivery_time.translation.name`, `delivery_time.translation.name` as `delivery_time.name`, `delivery_time.translation.customFields`, `delivery_time.translation.customFields` as `delivery_time.customFields` FROM `delivery_time` LEFT JOIN (SELECT `delivery_time.translation`.`delivery_time_id`, `delivery_time.translation`.`name` as `delivery_time.translation.name`, `delivery_time.translation`.`custom_fields` as `delivery_time.translation.customFields` FROM `delivery_time_translation` `delivery_time.translation` WHERE `delivery_time.translation`.`language_id` = ?) `delivery_time.delivery_time_translation` ON `delivery_time.delivery_time_translation`.`delivery_time_id` = `delivery_time`.`id` WHERE `delivery_time`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01¥Ñ¨ipžP¡ž¶\x12\x18­"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.75%) 		1 
SELECT path FROM category WHERE id = ?
Parameters: 
[
  b"\x01‘™\x1A\x10Qtď\e(ÀˆˆVh"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(0.75%) 		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.32 ms
(0.74%) 		1 
SELECT `product_search_config`.`id` as `product_search_config.id`, `product_search_config`.`language_id` as `product_search_config.languageId`, `product_search_config`.`and_logic` as `product_search_config.andLogic`, `product_search_config`.`min_search_length` as `product_search_config.minSearchLength`, `product_search_config`.`excluded_terms` as `product_search_config.excludedTerms`, `product_search_config`.`created_at` as `product_search_config.createdAt`, `product_search_config`.`updated_at` as `product_search_config.updatedAt` FROM `product_search_config` WHERE `product_search_config`.`id` IN (?)
Parameters: 
[
  b"\x01¥ÑLÃr'™Œ‘CŽ\x1DÒy"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(0.73%) 		1 
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.31 ms
(0.72%) 		1 
#cart-persister::load
            SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters: 
[
  "5p1UPJfbixnarRjsMa9xYCiYbkRSw08Q"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(0.72%) 		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.31 ms
(0.72%) 		1 
SELECT `product_search_config`.`id` FROM `product_search_config` WHERE (`product_search_config`.`language_id` = ?) LIMIT 1
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(0.71%) 		1 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.30 ms
(0.70%) 		1 
SELECT LOWER(HEX(sales_channel_id)) AS sales_channel_id, route_name, template
             FROM seo_url_template
             WHERE route_name IN (?)
Parameters: 
[
  "frontend.detail.page"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(0.67%) 		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.28 ms
(0.64%) 		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
0.24 ms
(0.56%) 		1 
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt` FROM `language`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(0.38%) 		1 
SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
Parameters: 
[]
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.