Symfony Profiler

Query Metrics

33 Database Queries

21 Different statements

26.59 ms Query time

Grouped Statements

Show all queries

Time▼

Count

Info

4.18 ms
(15.72%)

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`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, `country.translation.name`, COALESCE(`country.translation.name`,`country.translation.name`) as `country.name`, `country.translation.addressFormat`, COALESCE(`country.translation.addressFormat`,`country.translation.addressFormat`) as `country.addressFormat`, `country.translation.customFields`, COALESCE(`country.translation.customFields`,`country.translation.customFields`) as `country.customFields`, `country.translation.createdAt`, `country.translation.updatedAt`, `country.translation.countryId`, `country.translation.languageId` FROM `country` LEFT JOIN (SELECT `country.translation`.country_id, `country.translation`.name as `country.translation.name`, `country.translation`.address_format as `country.translation.addressFormat`, `country.translation`.custom_fields as `country.translation.customFields`, `country.translation`.created_at as `country.translation.createdAt`, `country.translation`.updated_at as `country.translation.updatedAt`, `country.translation`.country_id as `country.translation.countryId`, `country.translation`.language_id as `country.translation.languageId` 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’™Å¥Qs(¡ï£\x06¶WÔ@"
  b"\x01’™Å¥^p\x03šÈ9Ã¤20•"
  b"\x01’™Å¥^p\x03šÈ9Ã¥\x05¡Ã"
  b"\x01’™Å¥ßpÞ¬Æ\x06ç]Ëéñ"
  b"\x01’™Å¥àq”ˆD.ÖÅÄw("
  b"\x01’™Å¥àq”ˆD.ÖÅê\±"
  b"\x01’™Å¥áp\x19ƒÖM™Å\x119ä"
  b"\x01’™Å¥áp\x19ƒÖM™Å'.ƒ"
  b"\x01’™Å¥ârž•/ªÆìæ°´"
  b"\x01’™Å¥ãr ‹‘8ç´#é\"
  b"\x01’™Å¥ãr ‹‘8ç´’åU"
  b"\x01’™Å¥äqI ÛŠ¦P¡XÅ"
  b"\x01’™Å¥åp— #’OJ½E "
  b"\x01’™Å¥åp— #’OJÏ[c"
  b"\x01’™Å¥æpî¦»™\x1DSB¹·"
  b"\x01’™Å¥æpî¦»™\x1DSˆˆ¾"
  b"\x01’™Å¥çq>¹[\x14Ós‰?œ"
  b"\x01’™Å¥çq>¹[\x14Ót`\x06F"
  b"\x01’™Å¥÷sš»\rŠPµÆ©Û"
  b"\x01’™Å¥øq!ºÉ\¶ASù¶"
  b"\x01’™Å¥øq!ºÉ\¶AtFñ"
  b"\x01’™Å¥ùq\x02¼kâ,œ]¹r"
  b"\x01’™Å¥ùq\x02¼kâ,œŠÏâ"
  b"\x01ÆÖ┼Ñ¨q\x02╝kÔ,ØZæi"
  b"\x01’™Å¥úqÊ–Œ4Á0y¥Á"
  b"\x01’™Å¥úqÊ–Œ4Á1DZr"
  b"\x01’™Å¥ûr!¶4ðA!‡'ò"
  b"\x01’™Å¥ûr!¶4ðA"$Íú"
  b"\x01’™Å¥üsú’S[\x17\r³ªS"
  b"\x01’™Å¥üsú’S[\x17\x0E4öB"
  b"\x01’™Å¥ýrs¶]AX+[w¼"
  b"\x01’™Å¥ýrs¶]AX,Qy¸"
  b"\x01’™Å¥ýrs¶]AX,ÆK""
  b"\x01’™ÅÜ°pq…Á×ú\x02å¹_"
  b"\x01’™ÅÜ²qã¼V‰6\e\x11‹Š"
  b"\x01’™ÅÜ²qã¼V‰6\eÿéz"
  b"\x01’™ÅÜ³sìŠƒÛf©1†["
  b"\x01ÆÖ┼▄┤s┼ü+*┌┐\fÐå"
  b"\x01ÆÖ┼▄Ás\x1A┤ýÅª\x00½Ï("
  b"\x01ÆÖ┼▄Âq0¬\x1Füof.¸\x18"
  b"\x01’™ÅÜ·r8¬óÂ4Ï\4Ÿ"
  b"\x01’™ÅÜ·r8¬óÂ4Ï\x7FÔó"
  b"\x01’™ÅÜ¸rÒ¢§LÆô\x10ça"
  b"\x01’™ÅÜ¹p¾¿\rîb)wOŽ"
  b"\x01’™ÅÜºpß§‰^÷Ú›â§"
  b"\x01’™ÅÜºpß§‰^÷Ûx¥/"
  b"\x01’™ÅÜ»s\x04¾ëX\x16•A}…"
  b"\x01’™ÅÜ»s\x04¾ëX\x16•Ž×ñ"
  b"\x01ÆÖ┼▄╝qþóÐ║¹£Oìz"
  b"\x01’™ÅÜ½r\x05„ÚtmTbC—"
  b"\x01’™ÅÜ½r\x05„ÚtmU\x100«"
  b"\x01’™ÅÜ¾s÷». ß\x0Fæ\x01â"
  b"\x01’™ÅÜ¾s÷». ß\x10â]”"
  b"\x01ÆÖ┼▄┐rx┤Ï\x08ØðPyù"
  b"\x01ÆÖ┼▄└sN╝NÒ[\x11ðØ\x12"
  b"\x01’™ÅÜÀsN¼Nã[\x11í„Ö"
  b"\x01ÆÖ┼▄┴rì▓´w¼¨g9¥"
  b"\x01ÆÖ┼▄┴rì▓´w¼¨x.¯"
  b"\x01’™ÅÜÂq>ºC¼}œëY¢"
  b"\x01ÆÖ┼▄┬q>║C╝}Ø▀\x05\t"
  b"\x01ÆÖ┼▄├rÒåüÖpy╠Bƒ"
  b"\x01ÆÖ┼▄─p\x18ú4ÌfìÆß\v"
  b"\x01’™ÅÜÅrF¶‚zÂ>È2\x13"
  b"\x01’™ÅÜÅrF¶‚zÂ?\x11\f¦"
  b"\x01’™ÅÜÆp\e—Ò¬”Û•-«"
  b"\x01’™ÅÜÇqM¸k5²È2\·"
  b"\x01’™ÅÜÇqM¸k5²Èc,¥"
  b"\x01’™ÅÜÈq|”b\x18ÕîÜ"¾"
  b"\x01ÆÖ┼▄╬r\x1D░\x1E\x1F"ÔÅÏ,"
  b"\x01’™ÅÜÏq¤µåd—¨_é_"
  b"\x01’™ÅÜÐsž‹n’÷\x18\e¨^"
  b"\x01’™ÅÜÑqo–\x04ìXÁXíÂ"
  b"\x01’™ÅÜÑqo–\x04ìXÂ"¬O"
  b"\x01’™ÅÜÒq\x7F¦{QD ¾ÿn"
  b"\x01’™ÅÜÒq\x7F¦{QD ó\tø"
  b"\x01’™ÅÜÓrãµr"ØÚöQ\x04"
  b"\x01’™ÅÜÓrãµr"ØÛÔ×°"
  b"\x01’™ÅÜÔq\x00€\x05Å:–èHN"
  b"\x01’™ÅÜÔq\x00€\x05Å:—‰\x1Fõ"
  b"\x01ÆÖ┼▄ıp└äå"!ê\x07É"
  b"\x01’™ÅÜÖpú® C’‹!>\x10"
  b"\x01’™ÅÜÖpú® C’‹E;M"
  b"\x01’™ÅÜ×p\r´W\õW\˜©"
  b"\x01’™ÅÜØs\x02¾Uœ‰\x17Ž\x11y"
  b"\x01’™ÅÜÙsŠŒGóx\x13"÷\"
  b"\x01’™ÅÜÚq\x1C›9ì0ÒBö7"
  b"\x01ÆÖ┼▄█qÞÅº▓Ç─é\x02ë"
  b"\x01’™ÅÜÜsÉ°x«\x10\x0Eâ'+"
  b"\x01’™ÅÜÝqÈŠ©\x7Fy‚½Íì"
  b"\x01’™ÅÜãqv·‘aM³8wR"
  b"\x01’™ÅÜäp\tˆ}³\x15TuæŸ"
  b"\x01’™ÅÜåsí‰cÉ¢E\ß\x10"
  b"\x01’™ÅÜæq]¤Œ\x12\Xõ˜µ"
  b"\x01’™ÅÜæq]¤Œ\x12\Y\f<K"
  b"\x01’™ÅÜçrS»ûžGÉp@À"
  b"\x01’™ÅÜèph„\x02T/\x1D\x175¡"
  b"\x01’™ÅÜér…¦&¯\x01\x17\x12\x05\x1D"
  b"\x01’™ÅÜér…¦&¯\x01\x18\x110Þ"
  b"\x01’™ÅÜêq8®kçëIIÐl"
  b"\x01ÆÖ┼▄Ùq«®Sa\x1FØ÷ÐI"
  b"\x01’™ÅÜìs@¶Y*ñäXîL"
  b"\x01’™ÅÜís¸\x00Á‡¦¬’\x10"
  b"\x01’™ÅÜîpò¸ÿßÞró \r"
  b"\x01’™ÅÜîpò¸ÿßÞs«ú^"
  b"\x01’™ÅÜïsw”ûG¹Y¥Mœ"
  b"\x01’™ÅÜðr/”u$i¢‚†½"
  b"\x01’™ÅÜñq—’\x15×$úí@`"
  b"\x01ÆÖ┼▄‗p£üPÉ³\x1A\x00Ñ&"
  b"\x01’™ÅÜ÷sÁ—V—]Ä,\f‰"
  b"\x01’™ÅÜþqY‘ï9µ†½0\x06"
  b"\x01’™ÅÜÿq!«Ö“pDë—¿"
  b"\x01’™ÅÝ\x00q¨–’=.¥»ds"
  b"\x01’™ÅÝ\x01p¬¤“ì2s¼Ue"
  b"\x01’™ÅÝ\x02r@¬Ù\x07=“‰4^"
  b"\x01ÆÖ┼¦\x03qzë¬─±+É3\e"
  b"\x01’™ÅÝ\x03qz‰ªÄñ,OH."
  b"\x01’™ÅÝ\x04sàšº 0\x1Ax‹ã"
  b"\x01ÆÖ┼¦\x05scÇü\x05ÞÎ╦Á¨"
  b"\x01ÆÖ┼¦\x06p_Àqíf╠▀ÈØ"
  b"\x01’™ÅÝ\x07p\x06¤\x1Eû·»„–Ô"
  b"\x01’™ÅÝ\x08q;–á9\t\e\ÿ˜"
  b"\x01’™ÅÝ\ts!«\x1F§rGxÙ\x07"
  b"\x01’™ÅÝ\ts!«\x1F§rH\eã\x18"
  b"""
    \x01’™ÅÝ\n
    p\x16»á&\f7›xÜ
    """
  b"\x01’™ÅÝ\vrÆœ·4r\x01ÓO#"
  b"\x01’™ÅÝ\fpµ¨ØKítÝSg"
  b"\x01’™ÅÝ\rrº§Þð“óÂ\x14"
  b"\x01’™ÅÝ\x0Epé¯\x00\x19P¨mAÿ"
  b"\x01’™ÅÝ\x0Epé¯\x00\x19P©>Å\x1C"
  b"\x01’™ÅÝ\x0Fs¸°.§\x05)Ç0C"
  b"\x01ÆÖ┼¦\x10rwÜ4ê(Øh0\x08"
  b"\x01’™ÅÝ\x11p-‚Éš\x1FÀeÿ@"
  b"\x01’™ÅÝ\x11p-‚Éš\x1FÁZ/\x18"
  b"\x01’™ÅÝ\x12qC±nÄá%`\x112"
  b"""
    \x01ÆÖ┼¦\x13qÉÂ=\x18 ┤\n
    ÃÛ
    """
  b"\x01ÆÖ┼¦\x13qÉÂ=\x18 ┤\x10\x06>"
  b"\x01’™ÅÝ\x14p«™¬ÿoeóê‰"
  b"\x01’™ÅÝ\x15s†‹.5êLW0\x10"
  b"\x01ÆÖ┼¦\x16pì┐R¼ýØlL╔"
  b"\x01ÆÖ┼¦\x16pì┐R¼ý×Vèè"
  b"\x01’™ÅÝ\x17qA«ìuH\x08©ñ8"
  b"\x01ÆÖ┼¦\x18r(╗6Å┬»_ö'"
  b"\x01’™ÅÝ\x19rù¤íÒ´\vLf!"
  b"\x01’™ÅÝ\x1AsÖ¸O`}—b<ó"
  b"\x01’™ÅÝ\x1FrÍ»í‹›Z*ë\x03"
  b"\x01’™ÅÝ\x1FrÍ»í‹›Zó'õ"
  b"\x01’™ÅÝ roŽ¯Ñà±VØ"
  b"\x01ÆÖ┼¦!r╬ü;élåB+u"
  b"\x01ÆÖ┼¦!r╬ü;élç=QÞ"
  b"""
    \x01’™ÅÝ"rì†\n
    pa\\x13‡±
    """
  b"\x01’™ÅÝ#s› 7R½[´€T"
  b"\x01’™ÅÝ$qç–!\x00\x06\x10‘Ž\x7F"
  b"\x01’™ÅÝ$qç–!\x00\x06\x11\x11Õ˜"
  b"\x01’™ÅÝ%rÿ»mG\x11©¹§Þ"
  b"\x01’™ÅÝ%rÿ»mG\x11ª"Uº"
  b"\x01’™ÅÝ&p½…Ü³þ/!Ô\x17"
  b"\x01’™ÅÝ'pÍ¡Çói+X´\x1C"
  b"\x01’™ÅÝ'pÍ¡Çói+“ù&"
  b"\x01’™ÅÝ(r=‹<…ü‡\rl\e"
  b"\x01’™ÅÝ)s¸µIã«œ“š\v"
  b"\x01’™ÅÝ)s¸µIã«œï”š"
  b"\x01’™ÅÝ*qI–ƒðŒ¥Äí·"
  b"\x01ÆÖ┼¦3pùÁ\x12"Øay+b"
  b"\x01’™ÅÝ4qþ¼\x7FÉlî‚\x044"
  b"\x01’™ÅÝ5s#‡î\x16?*\x17N8"
  b"\x01ÆÖ┼¦6sSîÉqhóE─y"
  b"\x01ÆÖ┼¦6sSîÉqhóJ$\v"
  b"\x01’™ÅÝ7s<—*’Æsç~="
  b"\x01’™ÅÝ8r—˜º¯Ã—‘Îf"
  b"\x01’™ÅÝ9ræû\vÄ§9Œ>"
  b"\x01’™ÅÝ:r\x03‡Ê\x02sZj[õ"
  b"\x01’™ÅÝ:r\x03‡Ê\x02sZÆNy"
  b"\x01’™ÅÝ;s_¬Fkd¾šw""
  b"\x01’™ÅÝ<p;º‹\f\x10-Þþž"
  b"\x01’™ÅÝ<p;º‹\f\x10.\x00Nv"
  b"\x01’™ÅÝ=pµ‡sh¬\x10ß4…"
  b"\x01’™ÅÝ>rD¼4"’Ò„µÀ"
  b"\x01’™ÅÝ?pa—ê\eC=Ÿç_"
  b"\x01’™ÅÝ@pU¡Šk‰\x19r¯³"
  b"""
    \x01’™ÅÝArÃ±[%y›µ\n
    H
    """
  b"\x01ÆÖ┼¦Br┴ö5\x13éô×┬ì"
  b"\x01’™ÅÝGqÒ‡±Õ\x16Ef¥Ê"
  b"\x01’™ÅÝGqÒ‡±Õ\x16F\x00i¶"
  b"\x01’™ÅÝHpêŸ ¾ˆÂë÷”"
  b"\x01’™ÅÝIs\x7Fª8QT7}\x12b"
  b"\x01’™ÅÝJpˆµÒýˆ\x1EŽ£í"
  b"\x01ÆÖ┼¦JpêÁÊ²ê\x1Fe/É"
  b"\x01ÆÖ┼¦Kr╚Å\x19\x00N«È\x02Ï"
  b"\x01’™ÅÝLsŸŸeˆ\x13l.±Ü"
  b"\x01’™ÅÝMscƒÅMþÁ4ª "
  b"\x01’™ÅÝMscƒÅMþÂ\x13\x18r"
  b"\x01’™ÅÝNp¬‰ç\L/bÿÌ"
  b"\x01’™ÅÝOqÛ”\x07õâÃ$=M"
  b"\x01’™ÅÝPqƒŽä«eZg\x08}"
  b"\x01ÆÖ┼¦PqâÄõ½eZü═Ö"
  b"\x01’™ÅÝQs½Ÿ®@bÇÂ<æ"
  b"\x01’™ÅÝRrÊ°{äQ\x16™‘\"
  b"\x01’™ÅÝSp…¡¸}Õƒ‰5 "
  b"\x01’™ÅÝSp…¡¸}Õ„8r1"
  b"\x01’™ÅÝTqâ™Í•MþÚº¿"
  b"\x01’™ÅÝ[s\x14½rè}wuôº"
  b"\x01ÆÖ┼¦\p(½µ&Êì█J^"
  b"\x01’™ÅÝ\p(«æ&ÒŽq)Å"
  b"\x01ÆÖ┼¦]sûü ë┐▀\x12\x04\x1C"
  b"\x01’™ÅÝ^sÔ—c\x19w\x19ßyÁ"
  b"\x01’™ÅÝ^sÔ—c\x19w\x1A\x14…T"
  b"\x01’™ÅÝ_r}° ¥£ùÁÓ‘"
  b"\x01’™ÅÝ`r$¸*‹½U7#¡"
  b"\x01’™ÅÝ`r$¸*‹½V\x0Fb\t"
  b"\x01’™ÅÝaq³„j#8CmKð"
  b"\x01’™ÅÝbqÎ”îã\x12¬oÖ\x13"
  b"\x01’™ÅÝcqÆ¢\x1E®p@ÆÁ6"
  b"\x01’™ÅÝdrš½0„ãpèŒÝ"
  b"\x01’™ÅÝepuºE“W\x10Q\x177"
  b"\x01’™ÅÝepuºE“W\x10ŸÐx"
  b"\x01’™ÅÝfr±†ò\x11'óC\x11H"
  b"\x01ÆÖ┼¦gsmìÙ4\x7FÃP×Ç"
  b"\x01ÆÖ┼¦vrƒ╣4,Å\x14¾gÕ"
  b"\x01’™ÅÝwsäø\x14‹À,À2"
  b"\x01ÆÖ┼¦xp┌ô¬§üY±n§"
  b"\x01’™ÅÝypÛ¶â–80fÎ»"
  b"\x01’™ÅÝzsõž\x19W\emc\x0E¢"
  b"\x01’™ÅÝzsõž\x19W\enW‹æ"
  b"\x01’™ÅÝ{rŒ¬Ìvúñ%3D"
  b"\x01’™ÅÝ|qÌ§GYÒ»¾=Ü"
  b"\x01’™ÅÝ}rÞ¢pD×B6Ú™"
  b"\x01’™ÅÝ~qsžCÇ#\rYO¬"
  b"\x01’™ÅÝ~qsžCÇ#\rÎRÆ"
  b"\x01’™ÅÝ\x7Frú‡NÏ®\x1E(»\x10"
  b"\x01ÆÖ┼¦Çsð╝õ╦$ïõìì"
  b"\x01ÆÖ┼¦üqÏ▒¿E+áý╬À"
  b"\x01’™ÅÝƒrY¾WêA©Úø£"
  b"\x01’™ÅÝƒrY¾WêAª\x13ãÑ"
  b"\x01’™ÅÝ„q9Š¶¾ž:•ád"
  b"\x01’™ÅÝ…r\x03¬\x171|½,$‡"
  b"\x01ÆÖ┼¦àr\x03¼\x171|¢ÉÜN"
  b"\x01ÆÖ┼¦åp\x01«ñ°¾ü_Ãè"
  b"\x01ÆÖ┼¦çs─¢E▀ÂÏÕ\x1DÅ"
  b"\x01’™ÅÝ‡sÄ½Eß¶ÙÃ‰#"
  b"\x01ÆÖ┼¦êpü©└.\x157â═#"
  b"\x01ÆÖ┼¦ër‗░Ø┤ü\t\x01v}"
  b"\x01ÆÖ┼¦èra▓,ì6ÑË\x19┼"
  b"\x01ÆÖ┼¦èra▓,ì6Ñ▄Î╗"
  b"\x01’™ÅÝ‹q¿C\x14r‹ù£ò"
  b"\x01’™ÅÝŒr:²þ"I'þ–\x0E"
  b"\x01’™ÅÝŒr:²þ"I(ô\x04Í"
  b"\x01ÆÖ┼¦ìp╬®F?\x7FN\x15─;"
  b"\x01’™ÅÝŽq.†ÜDp\x0E{eÛ"
  b"\x01ÆÖ┼¦ÅrÖ×ÙÙ\x14I]\x07\x7F"
  b"\x01ÆÖ┼¦Ép\tÉ:¿Z#\x18R<"
]

View formatted query View runnable query Explain query View query backtrace

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`.`created_at` as `country.createdAt`,
  `country`.`updated_at` as `country.updatedAt`,
  `country.translation.name`,
  COALESCE(
    `country.translation.name`, `country.translation.name`
  ) as `country.name`,
  `country.translation.addressFormat`,
  COALESCE(
    `country.translation.addressFormat`,
    `country.translation.addressFormat`
  ) as `country.addressFormat`,
  `country.translation.customFields`,
  COALESCE(
    `country.translation.customFields`,
    `country.translation.customFields`
  ) as `country.customFields`,
  `country.translation.createdAt`,
  `country.translation.updatedAt`,
  `country.translation.countryId`,
  `country.translation.languageId`
FROM
  `country`
  LEFT JOIN (
    SELECT
      `country.translation`.country_id,
      `country.translation`.name as `country.translation.name`,
      `country.translation`.address_format as `country.translation.addressFormat`,
      `country.translation`.custom_fields as `country.translation.customFields`,
      `country.translation`.created_at as `country.translation.createdAt`,
      `country.translation`.updated_at as `country.translation.updatedAt`,
      `country.translation`.country_id as `country.translation.countryId`,
      `country.translation`.language_id as `country.translation.languageId`
    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 (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )

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`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, `country.translation.name`, COALESCE(`country.translation.name`,`country.translation.name`) as `country.name`, `country.translation.addressFormat`, COALESCE(`country.translation.addressFormat`,`country.translation.addressFormat`) as `country.addressFormat`, `country.translation.customFields`, COALESCE(`country.translation.customFields`,`country.translation.customFields`) as `country.customFields`, `country.translation.createdAt`, `country.translation.updatedAt`, `country.translation.countryId`, `country.translation.languageId` FROM `country` LEFT JOIN (SELECT `country.translation`.country_id, `country.translation`.name as `country.translation.name`, `country.translation`.address_format as `country.translation.addressFormat`, `country.translation`.custom_fields as `country.translation.customFields`, `country.translation`.created_at as `country.translation.createdAt`, `country.translation`.updated_at as `country.translation.updatedAt`, `country.translation`.country_id as `country.translation.countryId`, `country.translation`.language_id as `country.translation.languageId` FROM `country_translation` `country.translation` WHERE `country.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (0x019299C5A5517328A1EFA306B657D440, 0x019299C5A55E70039AC839C3A4323095, 0x019299C5A55E70039AC839C3A505A1C3, 0x019299C5A5DF70DEACC606E75DCBE9F1, 0x019299C5A5E0719488442ED6C5C47728, 0x019299C5A5E0719488442ED6C5EA5CB1, 0x019299C5A5E1701983D64D99C51139E4, 0x019299C5A5E1701983D64D99C5272E83, 0x019299C5A5E2729E952FAAC6ECE6B0B4, 0x019299C5A5E372208B9138E7B423E95C, 0x019299C5A5E372208B9138E7B492E555, 0x019299C5A5E47149A0DB8AA650A158C5, 0x019299C5A5E57097A023924F4ABD45A0, 0x019299C5A5E57097A023924F4ACF5B63, 0x019299C5A5E670EEA6BB991D5342B9B7, 0x019299C5A5E670EEA6BB991D538888BE, 0x019299C5A5E7713EB95B14D373893F9C, 0x019299C5A5E7713EB95B14D374600646, 0x019299C5A5F7739ABB0D8A50B5C6A9DB, 0x019299C5A5F87121BAC95CB64153F9B6, 0x019299C5A5F87121BAC95CB6417446F1, 0x019299C5A5F97102BC6BE22C9C5DB972, 0x019299C5A5F97102BC6BE22C9C8ACFE2, 0x019299C5A5F97102BC6BE22C9D5A9169, 0x019299C5A5FA71CA968C34C13079A5C1, 0x019299C5A5FA71CA968C34C131445A72, 0x019299C5A5FB7221B634F041218727F2, 0x019299C5A5FB7221B634F0412224CDFA, 0x019299C5A5FC73FA92535B170DB3AA53, 0x019299C5A5FC73FA92535B170E34F642, 0x019299C5A5FD7273B65D41582B5B77BC, 0x019299C5A5FD7273B65D41582C5179B8, 0x019299C5A5FD7273B65D41582CC64B22, 0x019299C5DCB0707185C1D7FA02E5B95F, 0x019299C5DCB271E3BC5689361B118B8A, 0x019299C5DCB271E3BC5689361BFFE97A, 0x019299C5DCB373EC8A83DB66A931865B, 0x019299C5DCB473C5812B2ADABF0CD186, 0x019299C5DCB5731AB4EC8FA600ABD828, 0x019299C5DCB67130AA1F816F662EF718, 0x019299C5DCB77238ACF3C234CF5C349F, 0x019299C5DCB77238ACF3C234CF7FD4F3, 0x019299C5DCB872D2A2A74CC6F410E761, 0x019299C5DCB970BEBF0DEE6229774F8E, 0x019299C5DCBA70DFA7895EF7DA9BE2A7, 0x019299C5DCBA70DFA7895EF7DB78A52F, 0x019299C5DCBB7304BEEB581695417D85, 0x019299C5DCBB7304BEEB5816958ED7F1, 0x019299C5DCBC71E7A2D1BAFB9C4F8D7A, 0x019299C5DCBD720584DA746D54624397, 0x019299C5DCBD720584DA746D551030AB, 0x019299C5DCBE73F7BB2EA0DF0FE601E2, 0x019299C5DCBE73F7BB2EA0DF10E25D94, 0x019299C5DCBF7278B4D8089DD0507997, 0x019299C5DCC0734EBC4EE35B11D09D12, 0x019299C5DCC0734EBC4EE35B11ED84D6, 0x019299C5DCC1728DB2EF77ACF96739BE, 0x019299C5DCC1728DB2EF77ACF9782EEE, 0x019299C5DCC2713EBA43BC7D9CEB59A2, 0x019299C5DCC2713EBA43BC7D9DDF0509, 0x019299C5DCC372E38681997079CC429F, 0x019299C5DCC47018A334DE668D92E10B, 0x019299C5DCC57246B6827AC23EC83213, 0x019299C5DCC57246B6827AC23F110CA6, 0x019299C5DCC6701B97D2AC94DB952DAB, 0x019299C5DCC7714DB86B35B2C8325CB7, 0x019299C5DCC7714DB86B35B2C8632CA5, 0x019299C5DCC8717C946218D5EEDC22BE, 0x019299C5DCCE721DB01E1F22E28FD82C, 0x019299C5DCCF71A4B5E56497A85FE95F, 0x019299C5DCD0739E8B6E92F7181BA85E, 0x019299C5DCD1716F9604EC58C158EDC2, 0x019299C5DCD1716F9604EC58C222AC4F, 0x019299C5DCD2717FA67B5144A0BEFF6E, 0x019299C5DCD2717FA67B5144A0F309F8, 0x019299C5DCD372E3B57222D8DAF65104, 0x019299C5DCD372E3B57222D8DBD4D7B0, 0x019299C5DCD471008005C53A96E8484E, 0x019299C5DCD471008005C53A97891FF5, 0x019299C5DCD570C08486F02221880790, 0x019299C5DCD670FAAE2043928B213E10, 0x019299C5DCD670FAAE2043928B453B4D, 0x019299C5DCD7700DB4575CF5575C98A9, 0x019299C5DCD87302BE559C89178E1179, 0x019299C5DCD9738A8C47F3781322F75C, 0x019299C5DCDA711C9B39EC30D242F637, 0x019299C5DCDB71E88FA7B280C4820289, 0x019299C5DCDC73C9B078AB100EE2272B, 0x019299C5DCDD71C88AA97F7982BDCDEC, 0x019299C5DCE37176B791614DB3387752, 0x019299C5DCE47009887DB3155475E69F, 0x019299C5DCE573ED8963C9A2455CDF10, 0x019299C5DCE6715DA48C125C58F598B5, 0x019299C5DCE6715DA48C125C590C3C4B, 0x019299C5DCE77253BBFB9E47C97040C0, 0x019299C5DCE870688402542F1D1735A1, 0x019299C5DCE97285A626AF011712051D, 0x019299C5DCE97285A626AF01181130DE, 0x019299C5DCEA7138AE6BE7EB4949D06C, 0x019299C5DCEB71AEA953611F9DF6D149, 0x019299C5DCEC7340B6592AF1E458EE4C, 0x019299C5DCED73ADB800C187A6AC9210, 0x019299C5DCEE70F2B8FFDFDE72F3A00D, 0x019299C5DCEE70F2B8FFDFDE73ABFA5E, 0x019299C5DCEF737794FB47B959A54D9C, 0x019299C5DCF0722F94752469A28286BD, 0x019299C5DCF171979215D724FAED4060, 0x019299C5DCF2709C815090FC1A00A526, 0x019299C5DCF773C19756975DC42C0C89, 0x019299C5DCFE715991EF39B586BD3006, 0x019299C5DCFF7121ABD6937044EB97BF, 0x019299C5DD0071A896923D2EA5BB6473, 0x019299C5DD0170ACA493EC3273BC5565, 0x019299C5DD027240ACD9073D9389345E, 0x019299C5DD03717A89AAC4F12B90331B, 0x019299C5DD03717A89AAC4F12C4F482E, 0x019299C5DD0473E09ABA20301A788BE3, 0x019299C5DD057363808105E8D7CBB5F9, 0x019299C5DD06705FB771A166CCDFD49D, 0x019299C5DD077006A41EFBB7BB8496D4, 0x019299C5DD08713B96E139091B5CFF98, 0x019299C5DD097321AB1FA7724778D907, 0x019299C5DD097321AB1FA772481BE318, 0x019299C5DD0A7016BBE1260C379B78DC, 0x019299C5DD0B72C69CB7347201D34F23, 0x019299C5DD0C70B5A8D84BED74DD5367, 0x019299C5DD0D72BAADA7DEF093F3C214, 0x019299C5DD0E70E9AF001950A86D41FF, 0x019299C5DD0E70E9AF001950A93EC51C, 0x019299C5DD0F73B8B02EA70529C73043, 0x019299C5DD1072779A3488289D683008, 0x019299C5DD11702D82C99A1FC065FF40, 0x019299C5DD11702D82C99A1FC15A2F18, 0x019299C5DD127143B16EC4E125601132, 0x019299C5DD137190B63D18FFB40AC7EA, 0x019299C5DD137190B63D18FFB410063E, 0x019299C5DD1470AB99ACFF6F65F3EA89, 0x019299C5DD1573868B2E35EA4C573010, 0x019299C5DD16708DBF52ACEC9D6C4CC9, 0x019299C5DD16708DBF52ACEC9E568A8A, 0x019299C5DD177141ABEC754808A9F138, 0x019299C5DD187228BB368FC2AF5F9427, 0x019299C5DD1972F9A4EDD2B40B4C6621, 0x019299C5DD1A73D6B84F607D97623CF3, 0x019299C5DD1F72CDBBED8B9B5A2AEB03, 0x019299C5DD1F72CDBBED8B9B5AF327F5, 0x019299C5DD20726F8EAFD1E0ADB156D8, 0x019299C5DD2172CE813B826C86422B75, 0x019299C5DD2172CE813B826C873D51E8, 0x019299C5DD2272EC860A70615C1387B1, 0x019299C5DD23739BA03752BD5BB48054, 0x019299C5DD2471E79621000610918E7F, 0x019299C5DD2471E7962100061111D598, 0x019299C5DD2572FFBB6D4711A9B9A7DE, 0x019299C5DD2572FFBB6D4711AA2255BA, 0x019299C5DD2670BD85DCB3FE2F21D417, 0x019299C5DD2770CDA1C7F3692B58B41C, 0x019299C5DD2770CDA1C7F3692B93F926, 0x019299C5DD28723D8B3C85FC870D6C1B, 0x019299C5DD2973B8B549E3AB9C939A0B, 0x019299C5DD2973B8B549E3AB9CEF949A, 0x019299C5DD2A71499683F08CA5C4EDB7, 0x019299C5DD337097B512229D61792B62, 0x019299C5DD3471FEBC7FC96CEE820434, 0x019299C5DD35732387EE163F2A174E38, 0x019299C5DD3673538C907168A245C479, 0x019299C5DD3673538C907168A24A240B, 0x019299C5DD37733C972A92C673E77E3D, 0x019299C5DD38729798BAAFC39791CE66, 0x019299C5DD3972E6ADFB0BC4A7398C3E, 0x019299C5DD3A720387CA02735A6A5BF5, 0x019299C5DD3A720387CA02735AC64E79, 0x019299C5DD3B735FAC466B64BE9A7722, 0x019299C5DD3C703BBA8B0C102DDEFE9E, 0x019299C5DD3C703BBA8B0C102E004E76, 0x019299C5DD3D70B5877368AC10DF3485, 0x019299C5DD3E7244BC342292D284B5C0, 0x019299C5DD3F706197EA1B433D9FE75F, 0x019299C5DD407055A18A6B891972AFB3, 0x019299C5DD4172C3B15B25799BB50A48, 0x019299C5DD4272C194351382939EC28D, 0x019299C5DD4771D287B1D5164566A5CA, 0x019299C5DD4771D287B1D516460069B6, 0x019299C5DD4870EA9F20BE88C2EBF794, 0x019299C5DD49737FAA385154377D1262, 0x019299C5DD4A7088B5D2FD881E8EA3ED, 0x019299C5DD4A7088B5D2FD881F652F90, 0x019299C5DD4B72C88F19004EAED402D8, 0x019299C5DD4C739F9F6588136C2EB1DC, 0x019299C5DD4D736383C54DFEC134AA20, 0x019299C5DD4D736383C54DFEC2131872, 0x019299C5DD4E70AC89E75C4C2F62FFCC, 0x019299C5DD4F71DB9407F5E2C3243D4D, 0x019299C5DD5071838EE4AB655A67087D, 0x019299C5DD5071838EE4AB655A81CD99, 0x019299C5DD5173BD9FAE4062C7C23CE6, 0x019299C5DD5272CAB07BE4511699915C, 0x019299C5DD537085A1B87DD5838935A0, 0x019299C5DD537085A1B87DD584387231, 0x019299C5DD5471E299CD954DFEDABABF, 0x019299C5DD5B7314BD72E87D7775F4BA, 0x019299C5DD5C7028ABE626D28DDB4A5E, 0x019299C5DD5C7028ABE626D28E7129C5, 0x019299C5DD5D739681FF89BFDF12041C, 0x019299C5DD5E73D49763197719DF79C1, 0x019299C5DD5E73D4976319771A148554, 0x019299C5DD5F727DB0A0A5A3F9C1D391, 0x019299C5DD607224B82A8BBD553723A1, 0x019299C5DD607224B82A8BBD560F6209, 0x019299C5DD6171B3846A2338436D4BF0, 0x019299C5DD6271CE94EEE312AC6FD613, 0x019299C5DD6371C6A21EAE7040C6C136, 0x019299C5DD64729ABD3084E370E88CDD, 0x019299C5DD657075BA45935710511737, 0x019299C5DD657075BA459357109FD078, 0x019299C5DD6672B186F21127F3431148, 0x019299C5DD67736D8DEB347FC7509E80, 0x019299C5DD76729FB9342C8F14F367E5, 0x019299C5DD7773E4ADF8148BC02CC032, 0x019299C5DD7870DA93AAF58159F16EF5, 0x019299C5DD7970DBB6E296383066CEBB, 0x019299C5DD7A73F59E19571B6D630EA2, 0x019299C5DD7A73F59E19571B6E578BE6, 0x019299C5DD7B728CACCC76FAF1253344, 0x019299C5DD7C71CCA74759D2BBBE3DDC, 0x019299C5DD7D72DEA27044D74236DA99, 0x019299C5DD7E71739E43C7230D594FAC, 0x019299C5DD7E71739E43C7230DCE52C6, 0x019299C5DD7F72FA874ECFAE1E28BB10, 0x019299C5DD8073D0BCE4CB248BE48D8D, 0x019299C5DD8171D8B1A8452BA0ECCEB7, 0x019299C5DD837259BE57EA41A9DAF8A3, 0x019299C5DD837259BE57EA41AA13E3D1, 0x019299C5DD8471398AB6BE9E3A95E164, 0x019299C5DD857203AC17317CBD2C2487, 0x019299C5DD857203AC17317CBD909A4E, 0x019299C5DD867001AEA4F8F3815FC78A, 0x019299C5DD8773C4BD45DFB6D8E51D8F, 0x019299C5DD8773C4BD45DFB6D9C38923, 0x019299C5DD887081B8C02E153783CD23, 0x019299C5DD8972F2B09DB4810901767D, 0x019299C5DD8A7261B22C8D36A5D319C5, 0x019299C5DD8A7261B22C8D36A5DCD7BB, 0x019299C5DD8B71BFAD4314728BF9A3F2, 0x019299C5DD8C723AB2FE224927FE960E, 0x019299C5DD8C723AB2FE224928F404CD, 0x019299C5DD8D70CEA9463F7F4E15C43B, 0x019299C5DD8E712E86DC44700E7B65DB, 0x019299C5DD8F72999EEBEB14495D077F, 0x019299C5DD907009903AA85A2318523C);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 348)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 307)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 131)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 75)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 141)
6	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->read (line 79)
7	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->search (line 33)
8	Shopware\Core\System\Country\SalesChannel\CountryRoute->load (line 64)
9	Shopware\Core\System\Country\SalesChannel\CachedCountryRoute->Shopware\Core\System\Country\SalesChannel\{closure} (line 416)
10	Shopware\Core\System\SystemConfig\SystemConfigService->trace (line 33)
11	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 96)
12	Shopware\Core\Framework\Adapter\Translation\Translator->trace (line 33)
13	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 56)
14	Shopware\Core\Framework\Adapter\Cache\CacheTagCollection->trace (line 33)
15	Shopware\Core\Framework\Adapter\Cache\CacheTracer->trace (line 35)
16	Shopware\Storefront\Framework\Cache\CacheTracer->Shopware\Storefront\Framework\Cache\{closure} (line 76)
17	Shopware\Storefront\Theme\ThemeConfigValueAccessor->trace (line 35)
18	Shopware\Storefront\Framework\Cache\CacheTracer->trace (line 64)
19	Shopware\Core\System\Country\SalesChannel\CachedCountryRoute->Shopware\Core\System\Country\SalesChannel\{closure} (line 70)
20	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet (line 33)
21	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get (line 69)
22	Shopware\Core\System\Country\SalesChannel\CachedCountryRoute->load (line 81)
23	Shopware\Storefront\Page\Account\Login\AccountLoginPageLoader->getCountries (line 54)
24	Shopware\Storefront\Page\Account\Login\AccountLoginPageLoader->load (line 76)
25	Shopware\Storefront\Controller\AuthController->loginPage (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 65)
28	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
29	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 451)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 72)
34	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
35	Shopware\Core\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 15)

4.07 ms
(15.33%)

# app-scripts::refresh::read
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = ?)

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
]

View formatted query View runnable query Explain query View query backtrace

# app-scripts::refresh::read
SELECT
  `app`.`id` as `app.id`,
  `app`.`name` as `app.name`,
  `app`.`path` as `app.path`,
  `app`.`author` as `app.author`,
  `app`.`copyright` as `app.copyright`,
  `app`.`license` as `app.license`,
  `app`.`active` as `app.active`,
  `app`.`configurable` as `app.configurable`,
  `app`.`privacy` as `app.privacy`,
  `app`.`version` as `app.version`,
  `app`.`icon` as `app.iconRaw`,
  `app`.`app_secret` as `app.appSecret`,
  `app`.`modules` as `app.modules`,
  `app`.`main_module` as `app.mainModule`,
  `app`.`cookies` as `app.cookies`,
  `app`.`allow_disable` as `app.allowDisable`,
  `app`.`base_app_url` as `app.baseAppUrl`,
  `app`.`allowed_hosts` as `app.allowedHosts`,
  `app`.`template_load_priority` as `app.templateLoadPriority`,
  `app`.`integration_id` as `app.integrationId`,
  `app.integration`.`id` as `app.integration.id`,
  `app.integration`.`label` as `app.integration.label`,
  `app.integration`.`access_key` as `app.integration.accessKey`,
  `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`,
  `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`,
  `app.integration`.`admin` as `app.integration.admin`,
  `app.integration`.`custom_fields` as `app.integration.customFields`,
  `app.integration`.`deleted_at` as `app.integration.deletedAt`,
  `app.integration`.`write_access` as `app.integration.writeAccess`,
  `app.integration`.`created_at` as `app.integration.createdAt`,
  `app.integration`.`updated_at` as `app.integration.updatedAt`,
  `app`.`acl_role_id` as `app.aclRoleId`,
  `app.aclRole`.`id` as `app.aclRole.id`,
  `app.aclRole`.`name` as `app.aclRole.name`,
  `app.aclRole`.`description` as `app.aclRole.description`,
  `app.aclRole`.`privileges` as `app.aclRole.privileges`,
  `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`,
  `app.aclRole`.`created_at` as `app.aclRole.createdAt`,
  `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`,
  `app`.`created_at` as `app.createdAt`,
  `app`.`updated_at` as `app.updatedAt`,
  `app.translation.label`,
  COALESCE(
    `app.translation.label`, `app.translation.label`
  ) as `app.label`,
  `app.translation.description`,
  COALESCE(
    `app.translation.description`, `app.translation.description`
  ) as `app.description`,
  `app.translation.privacyPolicyExtensions`,
  COALESCE(
    `app.translation.privacyPolicyExtensions`,
    `app.translation.privacyPolicyExtensions`
  ) as `app.privacyPolicyExtensions`,
  `app.translation.customFields`,
  COALESCE(
    `app.translation.customFields`,
    `app.translation.customFields`
  ) as `app.customFields`,
  `app.translation.createdAt`,
  `app.translation.updatedAt`,
  `app.translation.appId`,
  `app.translation.languageId`
FROM
  `app`
  LEFT JOIN (
    SELECT
      `app.translation`.app_id,
      `app.translation`.label as `app.translation.label`,
      `app.translation`.description as `app.translation.description`,
      `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`,
      `app.translation`.custom_fields as `app.translation.customFields`,
      `app.translation`.created_at as `app.translation.createdAt`,
      `app.translation`.updated_at as `app.translation.updatedAt`,
      `app.translation`.app_id as `app.translation.appId`,
      `app.translation`.language_id as `app.translation.languageId`
    FROM
      `app_translation` `app.translation`
    WHERE
      `app.translation`.language_id = ?
  ) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id`
  LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id`
  LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id`
WHERE
  (`app`.`active` = ?)

# app-scripts::refresh::read
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = 1);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 348)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 307)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 131)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 75)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 212)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 67)
9	Shopware\Core\Profiling\Profiler::trace (line 65)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 106)
11	Shopware\Core\Framework\App\Lifecycle\Persister\ScriptPersister->refresh (line 72)
12	Shopware\Core\Framework\Script\Execution\ScriptLoader->load (line 53)
13	Shopware\Core\Framework\Script\Execution\ScriptLoader->get (line 54)
14	Shopware\Core\Framework\Script\Execution\ScriptExecutor->execute (line 56)
15	Shopware\Core\Checkout\Cart\Processor->Shopware\Core\Checkout\Cart\{closure} (line 67)
16	Shopware\Core\Profiling\Profiler::trace (line 72)
17	Shopware\Core\Checkout\Cart\Processor->process (line 105)
18	Shopware\Core\Checkout\Cart\CartRuleLoader->Shopware\Core\Checkout\Cart\{closure} (line 67)
19	Shopware\Core\Profiling\Profiler::trace (line 156)
20	Shopware\Core\Checkout\Cart\CartRuleLoader->load (line 61)
21	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 91)
22	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
23	Shopware\Core\Profiling\Profiler::trace (line 96)
24	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 63)
25	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
26	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
30	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
31	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
32	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
33	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 65)
36	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
37	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
38	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 451)
39	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
40	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
41	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 72)
42	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
43	Shopware\Core\Kernel->handle (line 35)
44	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
45	require_once (line 15)

3.68 ms
(13.84%)

SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(`script`.`app_id`)
  ) as `app_id`,
  `script`.`name` AS scriptName,
  `script`.`script` AS script,
  `script`.`hook` AS hook,
  IFNULL(
    `script`.`updated_at`, `script`.`created_at`
  ) AS lastModified,
  `app`.`name` AS appName,
  LOWER(
    HEX(`app`.`integration_id`)
  ) AS integrationId,
  `app`.`version` AS appVersion,
  `script`.`active` AS active
FROM
  `script`
  LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE
  `script`.`hook` != 'include'
ORDER BY
  `app`.`created_at`,
  `app`.`id`,
  `script`.`name`

SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 902)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 76)
3	Shopware\Core\Framework\Script\Execution\ScriptLoader->load (line 53)
4	Shopware\Core\Framework\Script\Execution\ScriptLoader->get (line 54)
5	Shopware\Core\Framework\Script\Execution\ScriptExecutor->execute (line 56)
6	Shopware\Core\Checkout\Cart\Processor->Shopware\Core\Checkout\Cart\{closure} (line 67)
7	Shopware\Core\Profiling\Profiler::trace (line 72)
8	Shopware\Core\Checkout\Cart\Processor->process (line 105)
9	Shopware\Core\Checkout\Cart\CartRuleLoader->Shopware\Core\Checkout\Cart\{closure} (line 67)
10	Shopware\Core\Profiling\Profiler::trace (line 156)
11	Shopware\Core\Checkout\Cart\CartRuleLoader->load (line 61)
12	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 91)
13	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
14	Shopware\Core\Profiling\Profiler::trace (line 96)
15	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 63)
16	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
17	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
21	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
22	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
23	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 65)
27	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
28	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 451)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 72)
33	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
34	Shopware\Core\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 15)

3.37 ms
(12.67%)

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`, COALESCE(`country_state.translation.name`,`country_state.translation.name`) as `country_state.name`, `country_state.translation.customFields`, COALESCE(`country_state.translation.customFields`,`country_state.translation.customFields`) as `country_state.customFields`, `country_state.translation.createdAt`, `country_state.translation.updatedAt`, `country_state.translation.countryStateId`, `country_state.translation.languageId` 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`, `country_state.translation`.created_at as `country_state.translation.createdAt`, `country_state.translation`.updated_at as `country_state.translation.updatedAt`, `country_state.translation`.country_state_id as `country_state.translation.countryStateId`, `country_state.translation`.language_id as `country_state.translation.languageId` 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01ÆÖãáÒp\x14ì\x16² ~!\x1C╦"
  b"\x01’™Å¥Qs(¡ï£\x06¶WÔ@"
  b"\x01’™Å¥^p\x03šÈ9Ã¤20•"
  b"\x01’™Å¥^p\x03šÈ9Ã¥\x05¡Ã"
  b"\x01’™Å¥ßpÞ¬Æ\x06ç]Ëéñ"
  b"\x01’™Å¥àq”ˆD.ÖÅÄw("
  b"\x01’™Å¥àq”ˆD.ÖÅê\±"
  b"\x01’™Å¥áp\x19ƒÖM™Å\x119ä"
  b"\x01’™Å¥áp\x19ƒÖM™Å'.ƒ"
  b"\x01’™Å¥ârž•/ªÆìæ°´"
  b"\x01’™Å¥ãr ‹‘8ç´#é\"
  b"\x01’™Å¥ãr ‹‘8ç´’åU"
  b"\x01’™Å¥äqI ÛŠ¦P¡XÅ"
  b"\x01’™Å¥åp— #’OJ½E "
  b"\x01’™Å¥åp— #’OJÏ[c"
  b"\x01’™Å¥æpî¦»™\x1DSB¹·"
  b"\x01’™Å¥æpî¦»™\x1DSˆˆ¾"
  b"\x01’™Å¥çq>¹[\x14Ós‰?œ"
  b"\x01’™Å¥çq>¹[\x14Ót`\x06F"
  b"\x01’™Å¥÷sš»\rŠPµÆ©Û"
  b"\x01’™Å¥øq!ºÉ\¶ASù¶"
  b"\x01’™Å¥øq!ºÉ\¶AtFñ"
  b"\x01’™Å¥ùq\x02¼kâ,œ]¹r"
  b"\x01’™Å¥ùq\x02¼kâ,œŠÏâ"
  b"\x01ÆÖ┼Ñ¨q\x02╝kÔ,ØZæi"
  b"\x01’™Å¥úqÊ–Œ4Á0y¥Á"
  b"\x01’™Å¥úqÊ–Œ4Á1DZr"
  b"\x01’™Å¥ûr!¶4ðA!‡'ò"
  b"\x01’™Å¥ûr!¶4ðA"$Íú"
  b"\x01’™Å¥üsú’S[\x17\r³ªS"
  b"\x01’™Å¥üsú’S[\x17\x0E4öB"
  b"\x01’™Å¥ýrs¶]AX+[w¼"
  b"\x01’™Å¥ýrs¶]AX,Qy¸"
  b"\x01’™Å¥ýrs¶]AX,ÆK""
  b"\x01’™ÅÜ°pq…Á×ú\x02å¹_"
  b"\x01’™ÅÜ²qã¼V‰6\e\x11‹Š"
  b"\x01’™ÅÜ²qã¼V‰6\eÿéz"
  b"\x01’™ÅÜ³sìŠƒÛf©1†["
  b"\x01ÆÖ┼▄┤s┼ü+*┌┐\fÐå"
  b"\x01ÆÖ┼▄Ás\x1A┤ýÅª\x00½Ï("
  b"\x01ÆÖ┼▄Âq0¬\x1Füof.¸\x18"
  b"\x01’™ÅÜ·r8¬óÂ4Ï\4Ÿ"
  b"\x01’™ÅÜ·r8¬óÂ4Ï\x7FÔó"
  b"\x01’™ÅÜ¸rÒ¢§LÆô\x10ça"
  b"\x01’™ÅÜ¹p¾¿\rîb)wOŽ"
  b"\x01’™ÅÜºpß§‰^÷Ú›â§"
  b"\x01’™ÅÜºpß§‰^÷Ûx¥/"
  b"\x01’™ÅÜ»s\x04¾ëX\x16•A}…"
  b"\x01’™ÅÜ»s\x04¾ëX\x16•Ž×ñ"
  b"\x01ÆÖ┼▄╝qþóÐ║¹£Oìz"
  b"\x01’™ÅÜ½r\x05„ÚtmTbC—"
  b"\x01’™ÅÜ½r\x05„ÚtmU\x100«"
  b"\x01’™ÅÜ¾s÷». ß\x0Fæ\x01â"
  b"\x01’™ÅÜ¾s÷». ß\x10â]”"
  b"\x01ÆÖ┼▄┐rx┤Ï\x08ØðPyù"
  b"\x01ÆÖ┼▄└sN╝NÒ[\x11ðØ\x12"
  b"\x01’™ÅÜÀsN¼Nã[\x11í„Ö"
  b"\x01ÆÖ┼▄┴rì▓´w¼¨g9¥"
  b"\x01ÆÖ┼▄┴rì▓´w¼¨x.¯"
  b"\x01’™ÅÜÂq>ºC¼}œëY¢"
  b"\x01ÆÖ┼▄┬q>║C╝}Ø▀\x05\t"
  b"\x01ÆÖ┼▄├rÒåüÖpy╠Bƒ"
  b"\x01ÆÖ┼▄─p\x18ú4ÌfìÆß\v"
  b"\x01’™ÅÜÅrF¶‚zÂ>È2\x13"
  b"\x01’™ÅÜÅrF¶‚zÂ?\x11\f¦"
  b"\x01’™ÅÜÆp\e—Ò¬”Û•-«"
  b"\x01’™ÅÜÇqM¸k5²È2\·"
  b"\x01’™ÅÜÇqM¸k5²Èc,¥"
  b"\x01’™ÅÜÈq|”b\x18ÕîÜ"¾"
  b"\x01ÆÖ┼▄╬r\x1D░\x1E\x1F"ÔÅÏ,"
  b"\x01’™ÅÜÏq¤µåd—¨_é_"
  b"\x01’™ÅÜÐsž‹n’÷\x18\e¨^"
  b"\x01’™ÅÜÑqo–\x04ìXÁXíÂ"
  b"\x01’™ÅÜÑqo–\x04ìXÂ"¬O"
  b"\x01’™ÅÜÒq\x7F¦{QD ¾ÿn"
  b"\x01’™ÅÜÒq\x7F¦{QD ó\tø"
  b"\x01’™ÅÜÓrãµr"ØÚöQ\x04"
  b"\x01’™ÅÜÓrãµr"ØÛÔ×°"
  b"\x01’™ÅÜÔq\x00€\x05Å:–èHN"
  b"\x01’™ÅÜÔq\x00€\x05Å:—‰\x1Fõ"
  b"\x01ÆÖ┼▄ıp└äå"!ê\x07É"
  b"\x01’™ÅÜÖpú® C’‹!>\x10"
  b"\x01’™ÅÜÖpú® C’‹E;M"
  b"\x01’™ÅÜ×p\r´W\õW\˜©"
  b"\x01’™ÅÜØs\x02¾Uœ‰\x17Ž\x11y"
  b"\x01’™ÅÜÙsŠŒGóx\x13"÷\"
  b"\x01’™ÅÜÚq\x1C›9ì0ÒBö7"
  b"\x01ÆÖ┼▄█qÞÅº▓Ç─é\x02ë"
  b"\x01’™ÅÜÜsÉ°x«\x10\x0Eâ'+"
  b"\x01’™ÅÜÝqÈŠ©\x7Fy‚½Íì"
  b"\x01’™ÅÜãqv·‘aM³8wR"
  b"\x01’™ÅÜäp\tˆ}³\x15TuæŸ"
  b"\x01’™ÅÜåsí‰cÉ¢E\ß\x10"
  b"\x01’™ÅÜæq]¤Œ\x12\Xõ˜µ"
  b"\x01’™ÅÜæq]¤Œ\x12\Y\f<K"
  b"\x01’™ÅÜçrS»ûžGÉp@À"
  b"\x01’™ÅÜèph„\x02T/\x1D\x175¡"
  b"\x01’™ÅÜér…¦&¯\x01\x17\x12\x05\x1D"
  b"\x01’™ÅÜér…¦&¯\x01\x18\x110Þ"
  b"\x01’™ÅÜêq8®kçëIIÐl"
  b"\x01ÆÖ┼▄Ùq«®Sa\x1FØ÷ÐI"
  b"\x01’™ÅÜìs@¶Y*ñäXîL"
  b"\x01’™ÅÜís¸\x00Á‡¦¬’\x10"
  b"\x01’™ÅÜîpò¸ÿßÞró \r"
  b"\x01’™ÅÜîpò¸ÿßÞs«ú^"
  b"\x01’™ÅÜïsw”ûG¹Y¥Mœ"
  b"\x01’™ÅÜðr/”u$i¢‚†½"
  b"\x01’™ÅÜñq—’\x15×$úí@`"
  b"\x01ÆÖ┼▄‗p£üPÉ³\x1A\x00Ñ&"
  b"\x01’™ÅÜ÷sÁ—V—]Ä,\f‰"
  b"\x01’™ÅÜþqY‘ï9µ†½0\x06"
  b"\x01’™ÅÜÿq!«Ö“pDë—¿"
  b"\x01’™ÅÝ\x00q¨–’=.¥»ds"
  b"\x01’™ÅÝ\x01p¬¤“ì2s¼Ue"
  b"\x01’™ÅÝ\x02r@¬Ù\x07=“‰4^"
  b"\x01ÆÖ┼¦\x03qzë¬─±+É3\e"
  b"\x01’™ÅÝ\x03qz‰ªÄñ,OH."
  b"\x01’™ÅÝ\x04sàšº 0\x1Ax‹ã"
  b"\x01ÆÖ┼¦\x05scÇü\x05ÞÎ╦Á¨"
  b"\x01ÆÖ┼¦\x06p_Àqíf╠▀ÈØ"
  b"\x01’™ÅÝ\x07p\x06¤\x1Eû·»„–Ô"
  b"\x01’™ÅÝ\x08q;–á9\t\e\ÿ˜"
  b"\x01’™ÅÝ\ts!«\x1F§rGxÙ\x07"
  b"\x01’™ÅÝ\ts!«\x1F§rH\eã\x18"
  b"""
    \x01’™ÅÝ\n
    p\x16»á&\f7›xÜ
    """
  b"\x01’™ÅÝ\vrÆœ·4r\x01ÓO#"
  b"\x01’™ÅÝ\fpµ¨ØKítÝSg"
  b"\x01’™ÅÝ\rrº§Þð“óÂ\x14"
  b"\x01’™ÅÝ\x0Epé¯\x00\x19P¨mAÿ"
  b"\x01’™ÅÝ\x0Epé¯\x00\x19P©>Å\x1C"
  b"\x01’™ÅÝ\x0Fs¸°.§\x05)Ç0C"
  b"\x01ÆÖ┼¦\x10rwÜ4ê(Øh0\x08"
  b"\x01’™ÅÝ\x11p-‚Éš\x1FÀeÿ@"
  b"\x01’™ÅÝ\x11p-‚Éš\x1FÁZ/\x18"
  b"\x01’™ÅÝ\x12qC±nÄá%`\x112"
  b"""
    \x01ÆÖ┼¦\x13qÉÂ=\x18 ┤\n
    ÃÛ
    """
  b"\x01ÆÖ┼¦\x13qÉÂ=\x18 ┤\x10\x06>"
  b"\x01’™ÅÝ\x14p«™¬ÿoeóê‰"
  b"\x01’™ÅÝ\x15s†‹.5êLW0\x10"
  b"\x01ÆÖ┼¦\x16pì┐R¼ýØlL╔"
  b"\x01ÆÖ┼¦\x16pì┐R¼ý×Vèè"
  b"\x01’™ÅÝ\x17qA«ìuH\x08©ñ8"
  b"\x01ÆÖ┼¦\x18r(╗6Å┬»_ö'"
  b"\x01’™ÅÝ\x19rù¤íÒ´\vLf!"
  b"\x01’™ÅÝ\x1AsÖ¸O`}—b<ó"
  b"\x01’™ÅÝ\x1FrÍ»í‹›Z*ë\x03"
  b"\x01’™ÅÝ\x1FrÍ»í‹›Zó'õ"
  b"\x01’™ÅÝ roŽ¯Ñà±VØ"
  b"\x01ÆÖ┼¦!r╬ü;élåB+u"
  b"\x01ÆÖ┼¦!r╬ü;élç=QÞ"
  b"""
    \x01’™ÅÝ"rì†\n
    pa\\x13‡±
    """
  b"\x01’™ÅÝ#s› 7R½[´€T"
  b"\x01’™ÅÝ$qç–!\x00\x06\x10‘Ž\x7F"
  b"\x01’™ÅÝ$qç–!\x00\x06\x11\x11Õ˜"
  b"\x01’™ÅÝ%rÿ»mG\x11©¹§Þ"
  b"\x01’™ÅÝ%rÿ»mG\x11ª"Uº"
  b"\x01’™ÅÝ&p½…Ü³þ/!Ô\x17"
  b"\x01’™ÅÝ'pÍ¡Çói+X´\x1C"
  b"\x01’™ÅÝ'pÍ¡Çói+“ù&"
  b"\x01’™ÅÝ(r=‹<…ü‡\rl\e"
  b"\x01’™ÅÝ)s¸µIã«œ“š\v"
  b"\x01’™ÅÝ)s¸µIã«œï”š"
  b"\x01’™ÅÝ*qI–ƒðŒ¥Äí·"
  b"\x01ÆÖ┼¦3pùÁ\x12"Øay+b"
  b"\x01’™ÅÝ4qþ¼\x7FÉlî‚\x044"
  b"\x01’™ÅÝ5s#‡î\x16?*\x17N8"
  b"\x01ÆÖ┼¦6sSîÉqhóE─y"
  b"\x01ÆÖ┼¦6sSîÉqhóJ$\v"
  b"\x01’™ÅÝ7s<—*’Æsç~="
  b"\x01’™ÅÝ8r—˜º¯Ã—‘Îf"
  b"\x01’™ÅÝ9ræû\vÄ§9Œ>"
  b"\x01’™ÅÝ:r\x03‡Ê\x02sZj[õ"
  b"\x01’™ÅÝ:r\x03‡Ê\x02sZÆNy"
  b"\x01’™ÅÝ;s_¬Fkd¾šw""
  b"\x01’™ÅÝ<p;º‹\f\x10-Þþž"
  b"\x01’™ÅÝ<p;º‹\f\x10.\x00Nv"
  b"\x01’™ÅÝ=pµ‡sh¬\x10ß4…"
  b"\x01’™ÅÝ>rD¼4"’Ò„µÀ"
  b"\x01’™ÅÝ?pa—ê\eC=Ÿç_"
  b"\x01’™ÅÝ@pU¡Šk‰\x19r¯³"
  b"""
    \x01’™ÅÝArÃ±[%y›µ\n
    H
    """
  b"\x01ÆÖ┼¦Br┴ö5\x13éô×┬ì"
  b"\x01’™ÅÝGqÒ‡±Õ\x16Ef¥Ê"
  b"\x01’™ÅÝGqÒ‡±Õ\x16F\x00i¶"
  b"\x01’™ÅÝHpêŸ ¾ˆÂë÷”"
  b"\x01’™ÅÝIs\x7Fª8QT7}\x12b"
  b"\x01’™ÅÝJpˆµÒýˆ\x1EŽ£í"
  b"\x01ÆÖ┼¦JpêÁÊ²ê\x1Fe/É"
  b"\x01ÆÖ┼¦Kr╚Å\x19\x00N«È\x02Ï"
  b"\x01’™ÅÝLsŸŸeˆ\x13l.±Ü"
  b"\x01’™ÅÝMscƒÅMþÁ4ª "
  b"\x01’™ÅÝMscƒÅMþÂ\x13\x18r"
  b"\x01’™ÅÝNp¬‰ç\L/bÿÌ"
  b"\x01’™ÅÝOqÛ”\x07õâÃ$=M"
  b"\x01’™ÅÝPqƒŽä«eZg\x08}"
  b"\x01ÆÖ┼¦PqâÄõ½eZü═Ö"
  b"\x01’™ÅÝQs½Ÿ®@bÇÂ<æ"
  b"\x01’™ÅÝRrÊ°{äQ\x16™‘\"
  b"\x01’™ÅÝSp…¡¸}Õƒ‰5 "
  b"\x01’™ÅÝSp…¡¸}Õ„8r1"
  b"\x01’™ÅÝTqâ™Í•MþÚº¿"
  b"\x01’™ÅÝ[s\x14½rè}wuôº"
  b"\x01ÆÖ┼¦\p(½µ&Êì█J^"
  b"\x01’™ÅÝ\p(«æ&ÒŽq)Å"
  b"\x01ÆÖ┼¦]sûü ë┐▀\x12\x04\x1C"
  b"\x01’™ÅÝ^sÔ—c\x19w\x19ßyÁ"
  b"\x01’™ÅÝ^sÔ—c\x19w\x1A\x14…T"
  b"\x01’™ÅÝ_r}° ¥£ùÁÓ‘"
  b"\x01’™ÅÝ`r$¸*‹½U7#¡"
  b"\x01’™ÅÝ`r$¸*‹½V\x0Fb\t"
  b"\x01’™ÅÝaq³„j#8CmKð"
  b"\x01’™ÅÝbqÎ”îã\x12¬oÖ\x13"
  b"\x01’™ÅÝcqÆ¢\x1E®p@ÆÁ6"
  b"\x01’™ÅÝdrš½0„ãpèŒÝ"
  b"\x01’™ÅÝepuºE“W\x10Q\x177"
  b"\x01’™ÅÝepuºE“W\x10ŸÐx"
  b"\x01’™ÅÝfr±†ò\x11'óC\x11H"
  b"\x01ÆÖ┼¦gsmìÙ4\x7FÃP×Ç"
  b"\x01ÆÖ┼¦vrƒ╣4,Å\x14¾gÕ"
  b"\x01’™ÅÝwsäø\x14‹À,À2"
  b"\x01ÆÖ┼¦xp┌ô¬§üY±n§"
  b"\x01’™ÅÝypÛ¶â–80fÎ»"
  b"\x01’™ÅÝzsõž\x19W\emc\x0E¢"
  b"\x01’™ÅÝzsõž\x19W\enW‹æ"
  b"\x01’™ÅÝ{rŒ¬Ìvúñ%3D"
  b"\x01’™ÅÝ|qÌ§GYÒ»¾=Ü"
  b"\x01’™ÅÝ}rÞ¢pD×B6Ú™"
  b"\x01’™ÅÝ~qsžCÇ#\rYO¬"
  b"\x01’™ÅÝ~qsžCÇ#\rÎRÆ"
  b"\x01’™ÅÝ\x7Frú‡NÏ®\x1E(»\x10"
  b"\x01ÆÖ┼¦Çsð╝õ╦$ïõìì"
  b"\x01ÆÖ┼¦üqÏ▒¿E+áý╬À"
  b"\x01’™ÅÝƒrY¾WêA©Úø£"
  b"\x01’™ÅÝƒrY¾WêAª\x13ãÑ"
  b"\x01’™ÅÝ„q9Š¶¾ž:•ád"
  b"\x01’™ÅÝ…r\x03¬\x171|½,$‡"
  b"\x01ÆÖ┼¦àr\x03¼\x171|¢ÉÜN"
  b"\x01ÆÖ┼¦åp\x01«ñ°¾ü_Ãè"
  b"\x01ÆÖ┼¦çs─¢E▀ÂÏÕ\x1DÅ"
  b"\x01’™ÅÝ‡sÄ½Eß¶ÙÃ‰#"
  b"\x01ÆÖ┼¦êpü©└.\x157â═#"
  b"\x01ÆÖ┼¦ër‗░Ø┤ü\t\x01v}"
  b"\x01ÆÖ┼¦èra▓,ì6ÑË\x19┼"
  b"\x01ÆÖ┼¦èra▓,ì6Ñ▄Î╗"
  b"\x01’™ÅÝ‹q¿C\x14r‹ù£ò"
  b"\x01’™ÅÝŒr:²þ"I'þ–\x0E"
  b"\x01’™ÅÝŒr:²þ"I(ô\x04Í"
  b"\x01ÆÖ┼¦ìp╬®F?\x7FN\x15─;"
  b"\x01’™ÅÝŽq.†ÜDp\x0E{eÛ"
  b"\x01ÆÖ┼¦ÅrÖ×ÙÙ\x14I]\x07\x7F"
  b"\x01ÆÖ┼¦Ép\tÉ:¿Z#\x18R<"
]

View formatted query View runnable query Explain query View query backtrace

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`,
  COALESCE(
    `country_state.translation.name`,
    `country_state.translation.name`
  ) as `country_state.name`,
  `country_state.translation.customFields`,
  COALESCE(
    `country_state.translation.customFields`,
    `country_state.translation.customFields`
  ) as `country_state.customFields`,
  `country_state.translation.createdAt`,
  `country_state.translation.updatedAt`,
  `country_state.translation.countryStateId`,
  `country_state.translation.languageId`
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`,
      `country_state.translation`.created_at as `country_state.translation.createdAt`,
      `country_state.translation`.updated_at as `country_state.translation.updatedAt`,
      `country_state.translation`.country_state_id as `country_state.translation.countryStateId`,
      `country_state.translation`.language_id as `country_state.translation.languageId`
    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 (
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?
    )
  )

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`, COALESCE(`country_state.translation.name`,`country_state.translation.name`) as `country_state.name`, `country_state.translation.customFields`, COALESCE(`country_state.translation.customFields`,`country_state.translation.customFields`) as `country_state.customFields`, `country_state.translation.createdAt`, `country_state.translation.updatedAt`, `country_state.translation.countryStateId`, `country_state.translation.languageId` 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`, `country_state.translation`.created_at as `country_state.translation.createdAt`, `country_state.translation`.updated_at as `country_state.translation.updatedAt`, `country_state.translation`.country_state_id as `country_state.translation.countryStateId`, `country_state.translation`.language_id as `country_state.translation.languageId` FROM `country_state_translation` `country_state.translation` WHERE `country_state.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `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` = 0x019299C6A0E370148D16FDFF7E211CCB AND `country_state`.`country_id` IN (0x019299C5A5517328A1EFA306B657D440, 0x019299C5A55E70039AC839C3A4323095, 0x019299C5A55E70039AC839C3A505A1C3, 0x019299C5A5DF70DEACC606E75DCBE9F1, 0x019299C5A5E0719488442ED6C5C47728, 0x019299C5A5E0719488442ED6C5EA5CB1, 0x019299C5A5E1701983D64D99C51139E4, 0x019299C5A5E1701983D64D99C5272E83, 0x019299C5A5E2729E952FAAC6ECE6B0B4, 0x019299C5A5E372208B9138E7B423E95C, 0x019299C5A5E372208B9138E7B492E555, 0x019299C5A5E47149A0DB8AA650A158C5, 0x019299C5A5E57097A023924F4ABD45A0, 0x019299C5A5E57097A023924F4ACF5B63, 0x019299C5A5E670EEA6BB991D5342B9B7, 0x019299C5A5E670EEA6BB991D538888BE, 0x019299C5A5E7713EB95B14D373893F9C, 0x019299C5A5E7713EB95B14D374600646, 0x019299C5A5F7739ABB0D8A50B5C6A9DB, 0x019299C5A5F87121BAC95CB64153F9B6, 0x019299C5A5F87121BAC95CB6417446F1, 0x019299C5A5F97102BC6BE22C9C5DB972, 0x019299C5A5F97102BC6BE22C9C8ACFE2, 0x019299C5A5F97102BC6BE22C9D5A9169, 0x019299C5A5FA71CA968C34C13079A5C1, 0x019299C5A5FA71CA968C34C131445A72, 0x019299C5A5FB7221B634F041218727F2, 0x019299C5A5FB7221B634F0412224CDFA, 0x019299C5A5FC73FA92535B170DB3AA53, 0x019299C5A5FC73FA92535B170E34F642, 0x019299C5A5FD7273B65D41582B5B77BC, 0x019299C5A5FD7273B65D41582C5179B8, 0x019299C5A5FD7273B65D41582CC64B22, 0x019299C5DCB0707185C1D7FA02E5B95F, 0x019299C5DCB271E3BC5689361B118B8A, 0x019299C5DCB271E3BC5689361BFFE97A, 0x019299C5DCB373EC8A83DB66A931865B, 0x019299C5DCB473C5812B2ADABF0CD186, 0x019299C5DCB5731AB4EC8FA600ABD828, 0x019299C5DCB67130AA1F816F662EF718, 0x019299C5DCB77238ACF3C234CF5C349F, 0x019299C5DCB77238ACF3C234CF7FD4F3, 0x019299C5DCB872D2A2A74CC6F410E761, 0x019299C5DCB970BEBF0DEE6229774F8E, 0x019299C5DCBA70DFA7895EF7DA9BE2A7, 0x019299C5DCBA70DFA7895EF7DB78A52F, 0x019299C5DCBB7304BEEB581695417D85, 0x019299C5DCBB7304BEEB5816958ED7F1, 0x019299C5DCBC71E7A2D1BAFB9C4F8D7A, 0x019299C5DCBD720584DA746D54624397, 0x019299C5DCBD720584DA746D551030AB, 0x019299C5DCBE73F7BB2EA0DF0FE601E2, 0x019299C5DCBE73F7BB2EA0DF10E25D94, 0x019299C5DCBF7278B4D8089DD0507997, 0x019299C5DCC0734EBC4EE35B11D09D12, 0x019299C5DCC0734EBC4EE35B11ED84D6, 0x019299C5DCC1728DB2EF77ACF96739BE, 0x019299C5DCC1728DB2EF77ACF9782EEE, 0x019299C5DCC2713EBA43BC7D9CEB59A2, 0x019299C5DCC2713EBA43BC7D9DDF0509, 0x019299C5DCC372E38681997079CC429F, 0x019299C5DCC47018A334DE668D92E10B, 0x019299C5DCC57246B6827AC23EC83213, 0x019299C5DCC57246B6827AC23F110CA6, 0x019299C5DCC6701B97D2AC94DB952DAB, 0x019299C5DCC7714DB86B35B2C8325CB7, 0x019299C5DCC7714DB86B35B2C8632CA5, 0x019299C5DCC8717C946218D5EEDC22BE, 0x019299C5DCCE721DB01E1F22E28FD82C, 0x019299C5DCCF71A4B5E56497A85FE95F, 0x019299C5DCD0739E8B6E92F7181BA85E, 0x019299C5DCD1716F9604EC58C158EDC2, 0x019299C5DCD1716F9604EC58C222AC4F, 0x019299C5DCD2717FA67B5144A0BEFF6E, 0x019299C5DCD2717FA67B5144A0F309F8, 0x019299C5DCD372E3B57222D8DAF65104, 0x019299C5DCD372E3B57222D8DBD4D7B0, 0x019299C5DCD471008005C53A96E8484E, 0x019299C5DCD471008005C53A97891FF5, 0x019299C5DCD570C08486F02221880790, 0x019299C5DCD670FAAE2043928B213E10, 0x019299C5DCD670FAAE2043928B453B4D, 0x019299C5DCD7700DB4575CF5575C98A9, 0x019299C5DCD87302BE559C89178E1179, 0x019299C5DCD9738A8C47F3781322F75C, 0x019299C5DCDA711C9B39EC30D242F637, 0x019299C5DCDB71E88FA7B280C4820289, 0x019299C5DCDC73C9B078AB100EE2272B, 0x019299C5DCDD71C88AA97F7982BDCDEC, 0x019299C5DCE37176B791614DB3387752, 0x019299C5DCE47009887DB3155475E69F, 0x019299C5DCE573ED8963C9A2455CDF10, 0x019299C5DCE6715DA48C125C58F598B5, 0x019299C5DCE6715DA48C125C590C3C4B, 0x019299C5DCE77253BBFB9E47C97040C0, 0x019299C5DCE870688402542F1D1735A1, 0x019299C5DCE97285A626AF011712051D, 0x019299C5DCE97285A626AF01181130DE, 0x019299C5DCEA7138AE6BE7EB4949D06C, 0x019299C5DCEB71AEA953611F9DF6D149, 0x019299C5DCEC7340B6592AF1E458EE4C, 0x019299C5DCED73ADB800C187A6AC9210, 0x019299C5DCEE70F2B8FFDFDE72F3A00D, 0x019299C5DCEE70F2B8FFDFDE73ABFA5E, 0x019299C5DCEF737794FB47B959A54D9C, 0x019299C5DCF0722F94752469A28286BD, 0x019299C5DCF171979215D724FAED4060, 0x019299C5DCF2709C815090FC1A00A526, 0x019299C5DCF773C19756975DC42C0C89, 0x019299C5DCFE715991EF39B586BD3006, 0x019299C5DCFF7121ABD6937044EB97BF, 0x019299C5DD0071A896923D2EA5BB6473, 0x019299C5DD0170ACA493EC3273BC5565, 0x019299C5DD027240ACD9073D9389345E, 0x019299C5DD03717A89AAC4F12B90331B, 0x019299C5DD03717A89AAC4F12C4F482E, 0x019299C5DD0473E09ABA20301A788BE3, 0x019299C5DD057363808105E8D7CBB5F9, 0x019299C5DD06705FB771A166CCDFD49D, 0x019299C5DD077006A41EFBB7BB8496D4, 0x019299C5DD08713B96E139091B5CFF98, 0x019299C5DD097321AB1FA7724778D907, 0x019299C5DD097321AB1FA772481BE318, 0x019299C5DD0A7016BBE1260C379B78DC, 0x019299C5DD0B72C69CB7347201D34F23, 0x019299C5DD0C70B5A8D84BED74DD5367, 0x019299C5DD0D72BAADA7DEF093F3C214, 0x019299C5DD0E70E9AF001950A86D41FF, 0x019299C5DD0E70E9AF001950A93EC51C, 0x019299C5DD0F73B8B02EA70529C73043, 0x019299C5DD1072779A3488289D683008, 0x019299C5DD11702D82C99A1FC065FF40, 0x019299C5DD11702D82C99A1FC15A2F18, 0x019299C5DD127143B16EC4E125601132, 0x019299C5DD137190B63D18FFB40AC7EA, 0x019299C5DD137190B63D18FFB410063E, 0x019299C5DD1470AB99ACFF6F65F3EA89, 0x019299C5DD1573868B2E35EA4C573010, 0x019299C5DD16708DBF52ACEC9D6C4CC9, 0x019299C5DD16708DBF52ACEC9E568A8A, 0x019299C5DD177141ABEC754808A9F138, 0x019299C5DD187228BB368FC2AF5F9427, 0x019299C5DD1972F9A4EDD2B40B4C6621, 0x019299C5DD1A73D6B84F607D97623CF3, 0x019299C5DD1F72CDBBED8B9B5A2AEB03, 0x019299C5DD1F72CDBBED8B9B5AF327F5, 0x019299C5DD20726F8EAFD1E0ADB156D8, 0x019299C5DD2172CE813B826C86422B75, 0x019299C5DD2172CE813B826C873D51E8, 0x019299C5DD2272EC860A70615C1387B1, 0x019299C5DD23739BA03752BD5BB48054, 0x019299C5DD2471E79621000610918E7F, 0x019299C5DD2471E7962100061111D598, 0x019299C5DD2572FFBB6D4711A9B9A7DE, 0x019299C5DD2572FFBB6D4711AA2255BA, 0x019299C5DD2670BD85DCB3FE2F21D417, 0x019299C5DD2770CDA1C7F3692B58B41C, 0x019299C5DD2770CDA1C7F3692B93F926, 0x019299C5DD28723D8B3C85FC870D6C1B, 0x019299C5DD2973B8B549E3AB9C939A0B, 0x019299C5DD2973B8B549E3AB9CEF949A, 0x019299C5DD2A71499683F08CA5C4EDB7, 0x019299C5DD337097B512229D61792B62, 0x019299C5DD3471FEBC7FC96CEE820434, 0x019299C5DD35732387EE163F2A174E38, 0x019299C5DD3673538C907168A245C479, 0x019299C5DD3673538C907168A24A240B, 0x019299C5DD37733C972A92C673E77E3D, 0x019299C5DD38729798BAAFC39791CE66, 0x019299C5DD3972E6ADFB0BC4A7398C3E, 0x019299C5DD3A720387CA02735A6A5BF5, 0x019299C5DD3A720387CA02735AC64E79, 0x019299C5DD3B735FAC466B64BE9A7722, 0x019299C5DD3C703BBA8B0C102DDEFE9E, 0x019299C5DD3C703BBA8B0C102E004E76, 0x019299C5DD3D70B5877368AC10DF3485, 0x019299C5DD3E7244BC342292D284B5C0, 0x019299C5DD3F706197EA1B433D9FE75F, 0x019299C5DD407055A18A6B891972AFB3, 0x019299C5DD4172C3B15B25799BB50A48, 0x019299C5DD4272C194351382939EC28D, 0x019299C5DD4771D287B1D5164566A5CA, 0x019299C5DD4771D287B1D516460069B6, 0x019299C5DD4870EA9F20BE88C2EBF794, 0x019299C5DD49737FAA385154377D1262, 0x019299C5DD4A7088B5D2FD881E8EA3ED, 0x019299C5DD4A7088B5D2FD881F652F90, 0x019299C5DD4B72C88F19004EAED402D8, 0x019299C5DD4C739F9F6588136C2EB1DC, 0x019299C5DD4D736383C54DFEC134AA20, 0x019299C5DD4D736383C54DFEC2131872, 0x019299C5DD4E70AC89E75C4C2F62FFCC, 0x019299C5DD4F71DB9407F5E2C3243D4D, 0x019299C5DD5071838EE4AB655A67087D, 0x019299C5DD5071838EE4AB655A81CD99, 0x019299C5DD5173BD9FAE4062C7C23CE6, 0x019299C5DD5272CAB07BE4511699915C, 0x019299C5DD537085A1B87DD5838935A0, 0x019299C5DD537085A1B87DD584387231, 0x019299C5DD5471E299CD954DFEDABABF, 0x019299C5DD5B7314BD72E87D7775F4BA, 0x019299C5DD5C7028ABE626D28DDB4A5E, 0x019299C5DD5C7028ABE626D28E7129C5, 0x019299C5DD5D739681FF89BFDF12041C, 0x019299C5DD5E73D49763197719DF79C1, 0x019299C5DD5E73D4976319771A148554, 0x019299C5DD5F727DB0A0A5A3F9C1D391, 0x019299C5DD607224B82A8BBD553723A1, 0x019299C5DD607224B82A8BBD560F6209, 0x019299C5DD6171B3846A2338436D4BF0, 0x019299C5DD6271CE94EEE312AC6FD613, 0x019299C5DD6371C6A21EAE7040C6C136, 0x019299C5DD64729ABD3084E370E88CDD, 0x019299C5DD657075BA45935710511737, 0x019299C5DD657075BA459357109FD078, 0x019299C5DD6672B186F21127F3431148, 0x019299C5DD67736D8DEB347FC7509E80, 0x019299C5DD76729FB9342C8F14F367E5, 0x019299C5DD7773E4ADF8148BC02CC032, 0x019299C5DD7870DA93AAF58159F16EF5, 0x019299C5DD7970DBB6E296383066CEBB, 0x019299C5DD7A73F59E19571B6D630EA2, 0x019299C5DD7A73F59E19571B6E578BE6, 0x019299C5DD7B728CACCC76FAF1253344, 0x019299C5DD7C71CCA74759D2BBBE3DDC, 0x019299C5DD7D72DEA27044D74236DA99, 0x019299C5DD7E71739E43C7230D594FAC, 0x019299C5DD7E71739E43C7230DCE52C6, 0x019299C5DD7F72FA874ECFAE1E28BB10, 0x019299C5DD8073D0BCE4CB248BE48D8D, 0x019299C5DD8171D8B1A8452BA0ECCEB7, 0x019299C5DD837259BE57EA41A9DAF8A3, 0x019299C5DD837259BE57EA41AA13E3D1, 0x019299C5DD8471398AB6BE9E3A95E164, 0x019299C5DD857203AC17317CBD2C2487, 0x019299C5DD857203AC17317CBD909A4E, 0x019299C5DD867001AEA4F8F3815FC78A, 0x019299C5DD8773C4BD45DFB6D8E51D8F, 0x019299C5DD8773C4BD45DFB6D9C38923, 0x019299C5DD887081B8C02E153783CD23, 0x019299C5DD8972F2B09DB4810901767D, 0x019299C5DD8A7261B22C8D36A5D319C5, 0x019299C5DD8A7261B22C8D36A5DCD7BB, 0x019299C5DD8B71BFAD4314728BF9A3F2, 0x019299C5DD8C723AB2FE224927FE960E, 0x019299C5DD8C723AB2FE224928F404CD, 0x019299C5DD8D70CEA9463F7F4E15C43B, 0x019299C5DD8E712E86DC44700E7B65DB, 0x019299C5DD8F72999EEBEB14495D077F, 0x019299C5DD907009903AA85A2318523C));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 348)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 307)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 131)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 497)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToManyWithoutPagination (line 433)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToMany (line 1212)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 135)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 75)
9	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 141)
10	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->read (line 79)
11	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->search (line 33)
12	Shopware\Core\System\Country\SalesChannel\CountryRoute->load (line 64)
13	Shopware\Core\System\Country\SalesChannel\CachedCountryRoute->Shopware\Core\System\Country\SalesChannel\{closure} (line 416)
14	Shopware\Core\System\SystemConfig\SystemConfigService->trace (line 33)
15	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 96)
16	Shopware\Core\Framework\Adapter\Translation\Translator->trace (line 33)
17	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 56)
18	Shopware\Core\Framework\Adapter\Cache\CacheTagCollection->trace (line 33)
19	Shopware\Core\Framework\Adapter\Cache\CacheTracer->trace (line 35)
20	Shopware\Storefront\Framework\Cache\CacheTracer->Shopware\Storefront\Framework\Cache\{closure} (line 76)
21	Shopware\Storefront\Theme\ThemeConfigValueAccessor->trace (line 35)
22	Shopware\Storefront\Framework\Cache\CacheTracer->trace (line 64)
23	Shopware\Core\System\Country\SalesChannel\CachedCountryRoute->Shopware\Core\System\Country\SalesChannel\{closure} (line 70)
24	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet (line 33)
25	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get (line 69)
26	Shopware\Core\System\Country\SalesChannel\CachedCountryRoute->load (line 81)
27	Shopware\Storefront\Page\Account\Login\AccountLoginPageLoader->getCountries (line 54)
28	Shopware\Storefront\Page\Account\Login\AccountLoginPageLoader->load (line 76)
29	Shopware\Storefront\Controller\AuthController->loginPage (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 65)
32	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
33	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 451)
35	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
36	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
37	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 72)
38	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
39	Shopware\Core\Kernel->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 15)

3.23 ms
(12.15%)

SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(`script`.`app_id`)
  ) as `app_id`,
  `script`.`name` AS name,
  `script`.`script` AS script,
  `app`.`name` AS appName,
  LOWER(
    HEX(`app`.`integration_id`)
  ) AS integrationId,
  IFNULL(
    `script`.`updated_at`, `script`.`created_at`
  ) AS lastModified
FROM
  `script`
  LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE
  `script`.`hook` = 'include'
ORDER BY
  `app`.`created_at`,
  `app`.`id`,
  `script`.`name`

SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 902)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 92)
3	Shopware\Core\Framework\Script\Execution\ScriptLoader->load (line 53)
4	Shopware\Core\Framework\Script\Execution\ScriptLoader->get (line 54)
5	Shopware\Core\Framework\Script\Execution\ScriptExecutor->execute (line 56)
6	Shopware\Core\Checkout\Cart\Processor->Shopware\Core\Checkout\Cart\{closure} (line 67)
7	Shopware\Core\Profiling\Profiler::trace (line 72)
8	Shopware\Core\Checkout\Cart\Processor->process (line 105)
9	Shopware\Core\Checkout\Cart\CartRuleLoader->Shopware\Core\Checkout\Cart\{closure} (line 67)
10	Shopware\Core\Profiling\Profiler::trace (line 156)
11	Shopware\Core\Checkout\Cart\CartRuleLoader->load (line 61)
12	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 91)
13	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
14	Shopware\Core\Profiling\Profiler::trace (line 96)
15	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 63)
16	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
17	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
21	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
22	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
23	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 65)
27	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
28	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 451)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 72)
33	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
34	Shopware\Core\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 15)

1.19 ms
(4.48%)

SHOW COLUMNS FROM `cart` WHERE `Field` LIKE ?

Parameters:

[
  "payload"
]

View formatted query View runnable query Explain query View query backtrace

SHOW COLUMNS
FROM
  `cart`
WHERE
  `Field` LIKE ?

SHOW COLUMNS FROM `cart` WHERE `Field` LIKE 'payload';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchOne (line 53)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityDefinitionQueryHelper::columnExists (line 161)
4	Shopware\Core\Checkout\Cart\CartPersister->payloadExists (line 43)
5	Shopware\Core\Checkout\Cart\CartPersister->load (line 55)
6	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 91)
7	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 96)
9	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 63)
10	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
11	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
15	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
16	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
17	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 65)
21	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
22	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 451)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 72)
27	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
28	Shopware\Core\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 15)

0.83 ms
(3.12%)

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`.`active` = ? AND `country`.`active` = ? AND `country.salesChannels`.`id` = ?) GROUP BY `country`.`id`

Parameters:

[
  true
  true
  b"\x01ÆÖãáÒp\x14ì\x16² ~!\x1C╦"
]

View formatted query View runnable query Explain query View query backtrace

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`.`active` = ?
    AND `country`.`active` = ?
    AND `country.salesChannels`.`id` = ?
  )
GROUP BY
  `country`.`id`

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`.`active` = 1 AND `country`.`active` = 1 AND `country.salesChannels`.`id` = 0x019299C6A0E370148D16FDFF7E211CCB) GROUP BY `country`.`id`;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 348)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 95)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 47)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 158)
5	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->doSearch (line 68)
6	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->search (line 33)
7	Shopware\Core\System\Country\SalesChannel\CountryRoute->load (line 64)
8	Shopware\Core\System\Country\SalesChannel\CachedCountryRoute->Shopware\Core\System\Country\SalesChannel\{closure} (line 416)
9	Shopware\Core\System\SystemConfig\SystemConfigService->trace (line 33)
10	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 96)
11	Shopware\Core\Framework\Adapter\Translation\Translator->trace (line 33)
12	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 56)
13	Shopware\Core\Framework\Adapter\Cache\CacheTagCollection->trace (line 33)
14	Shopware\Core\Framework\Adapter\Cache\CacheTracer->trace (line 35)
15	Shopware\Storefront\Framework\Cache\CacheTracer->Shopware\Storefront\Framework\Cache\{closure} (line 76)
16	Shopware\Storefront\Theme\ThemeConfigValueAccessor->trace (line 35)
17	Shopware\Storefront\Framework\Cache\CacheTracer->trace (line 64)
18	Shopware\Core\System\Country\SalesChannel\CachedCountryRoute->Shopware\Core\System\Country\SalesChannel\{closure} (line 70)
19	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet (line 33)
20	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get (line 69)
21	Shopware\Core\System\Country\SalesChannel\CachedCountryRoute->load (line 81)
22	Shopware\Storefront\Page\Account\Login\AccountLoginPageLoader->getCountries (line 54)
23	Shopware\Storefront\Page\Account\Login\AccountLoginPageLoader->load (line 76)
24	Shopware\Storefront\Controller\AuthController->loginPage (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 65)
27	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
28	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 451)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 72)
33	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
34	Shopware\Core\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 15)

0.66 ms
(2.47%)

# 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"\x01ÆÖãáÒp\x14ì\x16² ~!\x1C╦"
]

View formatted query View runnable query Explain query View query backtrace

# 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)

# 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 ('/account/recover')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0x019299C6A0E370148D16FDFF7E211CCB OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 348)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 107)
3	Shopware\Core\Content\Seo\SeoUrlPlaceholderHandler->createSeoMapping (line 52)
4	Shopware\Core\Content\Seo\SeoUrlPlaceholderHandler->Shopware\Core\Content\Seo\{closure} (line 67)
5	Shopware\Core\Profiling\Profiler::trace (line 61)
6	Shopware\Core\Content\Seo\SeoUrlPlaceholderHandler->replace (line 109)
7	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 88)
8	Shopware\Storefront\Controller\AuthController->loginPage (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 65)
11	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
12	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
13	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 451)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 72)
17	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
18	Shopware\Core\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 15)

0.57 ms
(2.14%)

# 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

# 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`;

# 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`;;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 37)
2	Shopware\Core\Framework\Plugin\KernelPluginLoader\DbalKernelPluginLoader->loadPluginInfos (line 109)
3	Shopware\Core\Framework\Plugin\KernelPluginLoader\KernelPluginLoader->initializePlugins (line 182)
4	Shopware\Core\Kernel->boot (line 155)
5	Shopware\Core\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 15)

0.54 ms
(2.04%)

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ÆÖ┼ª\x00r┐ôÜp:ıâØ;"
  b"\x01’™Å¦\x12qÝ„žKÙºÀ|I"
  b"\x01’™ÅÔ?p¯…}Šã¤nÌI"
  b"\x01ÆÖ┼ª:q²Å`iÇÓ╚íè"
]

View formatted query View runnable query Explain query View query backtrace

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 (?, ?, ?, ?)

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 (0x019299C5A60072BF939A703AD5839D3B, 0x019299C5A61271DD849E4BD9BAC07C49, 0x019299C5D43F70AF857D8AE3A46ECC49, 0x019299C5A63A71FD8F606980E0C8A18A);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 348)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 307)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 131)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 75)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 212)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 90)
9	Shopware\Core\Profiling\Subscriber\ActiveRulesDataCollectorSubscriber->getMatchingRules (line 66)
10	Shopware\Core\Profiling\Subscriber\ActiveRulesDataCollectorSubscriber->collect (line 169)
11	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 108)
12	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 214)
20	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 202)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 65)
23	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
24	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 451)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 72)
29	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
30	Shopware\Core\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 15)

0.49 ms
(1.85%)

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

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;

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;
            ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 902)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 35)
3	Shopware\Core\System\CustomEntity\CustomEntityRegistrar->register (line 63)
4	Shopware\Core\System\System->boot (line 212)
5	Shopware\Core\Kernel->boot (line 155)
6	Shopware\Core\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	require_once (line 15)

0.49 ms
(1.84%)

# 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 = ?)

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01ÆÖãáÒp\x14ì\x16² ~!\x1C╦"
  "account/login"
]

View formatted query View runnable query Explain query View query backtrace

# 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 = ?)

# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND ((sales_channel_id = 0x019299C6A0E370148D16FDFF7E211CCB OR sales_channel_id IS NULL)) AND (seo_path_info = 'account/login');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 348)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 48)
3	Shopware\Core\Content\Seo\SeoResolver->resolve (line 35)
4	Shopware\Core\Content\Seo\EmptyPathInfoResolver->resolve (line 325)
5	Shopware\Storefront\Framework\Routing\RequestTransformer->resolveSeoUrl (line 126)
6	Shopware\Storefront\Framework\Routing\RequestTransformer->transform (line 52)
7	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
8	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
9	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 451)
10	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
11	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
12	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 72)
13	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
14	Shopware\Core\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 15)

0.41 ms
(1.53%)

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` = ?)) AND (`country`.`id` IN (?)) GROUP BY `country`.`id`

Parameters:

[
  b"\x01ÆÖãáÒp\x14ì\x16² ~!\x1C╦"
  b"\x01’™Å¥Qs(¡ï£\x06¶WÔ@"
]

View formatted query View runnable query Explain query View query backtrace

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` = ?)
  )
  AND (
    `country`.`id` IN (?)
  )
GROUP BY
  `country`.`id`

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` = 0x019299C6A0E370148D16FDFF7E211CCB)) AND (`country`.`id` IN (0x019299C5A5517328A1EFA306B657D440)) GROUP BY `country`.`id`;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 348)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 95)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 47)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 86)
5	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 93)
6	Shopware\Core\Checkout\Cart\Address\AddressValidator->isSalesChannelCountry (line 53)
7	Shopware\Core\Checkout\Cart\Address\AddressValidator->validate (line 25)
8	Shopware\Core\Checkout\Cart\Validator->validate (line 62)
9	Shopware\Core\Checkout\Cart\Processor->Shopware\Core\Checkout\Cart\{closure} (line 67)
10	Shopware\Core\Profiling\Profiler::trace (line 72)
11	Shopware\Core\Checkout\Cart\Processor->process (line 105)
12	Shopware\Core\Checkout\Cart\CartRuleLoader->Shopware\Core\Checkout\Cart\{closure} (line 67)
13	Shopware\Core\Profiling\Profiler::trace (line 156)
14	Shopware\Core\Checkout\Cart\CartRuleLoader->load (line 61)
15	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 91)
16	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
17	Shopware\Core\Profiling\Profiler::trace (line 96)
18	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 63)
19	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
20	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
24	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
25	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
26	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 65)
30	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
31	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 451)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
35	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 72)
36	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
37	Shopware\Core\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 15)

0.39 ms
(1.45%)

SELECT `key`, `value` FROM `app_config`

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `key`,
  `value`
FROM
  `app_config`

SELECT `key`, `value` FROM `app_config`;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 919)
2	Doctrine\DBAL\Connection->fetchAllKeyValue (line 70)
3	Shopware\Core\Framework\Adapter\Storage\MySQLKeyValueStorage->load (line 36)
4	Shopware\Core\Framework\Adapter\Storage\MySQLKeyValueStorage->get (line 34)
5	Shopware\Core\Framework\Adapter\Cache\CacheIdLoader->load (line 72)
6	Shopware\Core\Framework\Adapter\Kernel\KernelFactory::create (line 61)
7	{closure} (line 25)
8	Symfony\Component\Runtime\Resolver\DebugClosureResolver::Symfony\Component\Runtime\Resolver\{closure} (line 24)
9	require_once (line 15)

0.38 ms
(1.44%)

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

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

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 937)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 67)
3	Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\BundleHierarchyBuilder->getAppTemplateNamespaces (line 43)
4	Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\BundleHierarchyBuilder->buildNamespaceHierarchy (line 31)
5	Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\NamespaceHierarchyBuilder->buildHierarchy (line 136)
6	Shopware\Core\Framework\Adapter\Twig\TemplateFinder->getNamespaceHierarchy (line 57)
7	Shopware\Core\Framework\Adapter\Twig\TemplateFinder->find (line 279)
8	Shopware\Storefront\Controller\StorefrontController->renderView (line 297)
9	Shopware\Storefront\Controller\StorefrontController->render (line 92)
10	Shopware\Storefront\Controller\StorefrontController->Shopware\Storefront\Controller\{closure} (line 67)
11	Shopware\Core\Profiling\Profiler::trace (line 92)
12	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 88)
13	Shopware\Storefront\Controller\AuthController->loginPage (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 65)
16	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
17	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 451)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 72)
22	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
23	Shopware\Core\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 15)

0.38 ms
(1.43%)

SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?

Parameters:

[
  "en-GB"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(id)
  )
FROM
  snippet_set
WHERE
  iso = ?

SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = 'en-GB';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 953)
2	Doctrine\DBAL\Connection->fetchFirstColumn (line 265)
3	Shopware\Core\Framework\Adapter\Translation\Translator->getSnippetSetId (line 312)
4	Shopware\Core\Framework\Adapter\Translation\Translator->getCustomizedCatalog (line 134)
5	Shopware\Core\Framework\Adapter\Translation\Translator->getCatalogue (line 156)
6	Shopware\Core\Framework\Adapter\Translation\Translator->trans (line 45)
7	Symfony\Component\Translation\DataCollectorTranslator->trans (line 125)
8	Symfony\Bridge\Twig\Extension\TranslationExtension->trans (line 69)
9	__TwigTemplate_17c0dcbdaa56e8dbb42407218e70f2fd->block_layout_head_title_inner (line 171)
10	Twig\Template->displayBlock (line 1011)
11	__TwigTemplate_36d2147ef26e5158f075b994552e1c88->block_layout_head_title (line 171)
12	Twig\Template->displayBlock (line 151)
13	__TwigTemplate_36d2147ef26e5158f075b994552e1c88->block_layout_head_inner (line 171)
14	Twig\Template->displayBlock (line 90)
15	__TwigTemplate_36d2147ef26e5158f075b994552e1c88->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 50)
18	__TwigTemplate_17c0dcbdaa56e8dbb42407218e70f2fd->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 83)
21	__TwigTemplate_cec92957575975830bdcc8a35d1e7918->block_base_head (line 171)
22	Twig\Template->displayBlock (line 85)
23	__TwigTemplate_3a7683280fbf133cfe2419fd673c586c->doDisplay (line 394)
24	Twig\Template->displayWithErrorHandling (line 367)
25	Twig\Template->display (line 62)
26	__TwigTemplate_cec92957575975830bdcc8a35d1e7918->doDisplay (line 394)
27	Twig\Template->displayWithErrorHandling (line 367)
28	Twig\Template->display (line 379)
29	Twig\Template->render (line 38)
30	Twig\TemplateWrapper->render (line 280)
31	Twig\Environment->render (line 283)
32	Shopware\Storefront\Controller\StorefrontController->renderView (line 297)
33	Shopware\Storefront\Controller\StorefrontController->render (line 92)
34	Shopware\Storefront\Controller\StorefrontController->Shopware\Storefront\Controller\{closure} (line 67)
35	Shopware\Core\Profiling\Profiler::trace (line 92)
36	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 88)
37	Shopware\Storefront\Controller\AuthController->loginPage (line 181)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 65)
40	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
41	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
42	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 451)
43	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
44	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
45	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 72)
46	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
47	Shopware\Core\Kernel->handle (line 35)
48	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
49	require_once (line 15)

0.38 ms
(1.42%)

#cart-persister::load
                SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?

Parameters:

[
  "BF6SQyxDLJozKBeAUgctVm4BDn6hO6fo"
]

View formatted query View runnable query Explain query View query backtrace

#cart-persister::load
SELECT
  `cart`.`payload`,
  `cart`.`rule_ids`,
  `cart`.`compressed`
FROM
  cart
WHERE
  `token` = ?

#cart-persister::load
                SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = 'BF6SQyxDLJozKBeAUgctVm4BDn6hO6fo';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 588)
2	Doctrine\DBAL\Connection->fetchAssociative (line 47)
3	Shopware\Core\Checkout\Cart\CartPersister->load (line 55)
4	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 91)
5	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
6	Shopware\Core\Profiling\Profiler::trace (line 96)
7	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 63)
8	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
9	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
13	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
14	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
15	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 65)
19	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
20	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 451)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
26	Shopware\Core\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 15)

0.37 ms
(1.38%)

SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1

Parameters:

[
  b"\x01ÆÖãáÒp\x14ì\x16² ~!\x1C╦"
  "BF6SQyxDLJozKBeAUgctVm4BDn6hO6fo"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  sales_channel_api_context
WHERE
  (sales_channel_id = ?)
  AND (token = ?)
LIMIT
  1

SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0x019299C6A0E370148D16FDFF7E211CCB) AND (token = 'BF6SQyxDLJozKBeAUgctVm4BDn6hO6fo') LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 348)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 130)
3	Shopware\Core\System\SalesChannel\Context\SalesChannelContextPersister->load (line 62)
4	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
5	Shopware\Core\Profiling\Profiler::trace (line 96)
6	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 63)
7	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
8	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
12	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
13	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
14	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 65)
18	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 451)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 72)
24	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
25	Shopware\Core\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 15)

0.36 ms
(1.37%)

# 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"\x01ÆÖãáÒp\x14ì\x16² ~!\x1C╦"
  "/account/login"
]

View formatted query View runnable query Explain query View query backtrace

# 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

# seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (sales_channel_id = 0x019299C6A0E370148D16FDFF7E211CCB) AND (path_info = '/account/login') AND (is_canonical = 1) LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 348)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 92)
3	Shopware\Core\Content\Seo\SeoResolver->resolve (line 35)
4	Shopware\Core\Content\Seo\EmptyPathInfoResolver->resolve (line 325)
5	Shopware\Storefront\Framework\Routing\RequestTransformer->resolveSeoUrl (line 126)
6	Shopware\Storefront\Framework\Routing\RequestTransformer->transform (line 52)
7	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
8	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
9	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 451)
10	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
11	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
12	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 72)
13	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
14	Shopware\Core\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 15)

0.36 ms
(1.36%)

SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `name`,
  `path`,
  `author`
FROM
  `app`
WHERE
  `active` = 1

SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
            ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 902)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 61)
3	Shopware\Core\Framework\App\ActiveAppsLoader->loadApps (line 43)
4	Shopware\Core\Framework\App\ActiveAppsLoader->getActiveApps (line 278)
5	Shopware\Storefront\Framework\Routing\StorefrontSubscriber->addShopIdParameter (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
9	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
10	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
11	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 84)
13	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 88)
14	Shopware\Storefront\Controller\AuthController->loginPage (line 181)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 65)
17	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 451)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 72)
23	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
24	Shopware\Core\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 15)

0.26 ms
(0.98%)

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

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',
        ''
      )
  )

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',''));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 393)
2	Shopware\Core\Kernel->initializeDatabaseConnectionVariables (line 215)
3	Shopware\Core\Kernel->boot (line 155)
4	Shopware\Core\Kernel->handle (line 35)
5	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
6	require_once (line 15)

Database Connections

Name	Service
0	default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Symfony Profiler

GET https://q5i7gaitvio5k-prod-code-upz7qpi.de-2.tst.site/account/login?redirectParameters=%7B%22_noStore%22%3Atrue%7D&redirectTo=frontend.account.home.page

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache