Query Metrics
14
Database Queries
13
Different statements
12.91 ms
Query time
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4.28 ms (33.14%) |
1 |
SELECT `country`.`id` as `country.id`, `country`.`iso` as `country.iso`, `country`.`position` as `country.position`, `country`.`active` as `country.active`, `country`.`shipping_available` as `country.shippingAvailable`, `country`.`iso3` as `country.iso3`, `country`.`display_state_in_registration` as `country.displayStateInRegistration`, `country`.`force_state_in_registration` as `country.forceStateInRegistration`, `country`.`check_vat_id_pattern` as `country.checkVatIdPattern`, `country`.`vat_id_required` as `country.vatIdRequired`, `country`.`vat_id_pattern` as `country.vatIdPattern`, `country`.`customer_tax` as `country.customerTax`, `country`.`company_tax` as `country.companyTax`, `country`.`postal_code_required` as `country.postalCodeRequired`, `country`.`check_postal_code_pattern` as `country.checkPostalCodePattern`, `country`.`check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern`, `country`.`advanced_postal_code_pattern` as `country.advancedPostalCodePattern`, `country`.`default_postal_code_pattern` as `country.defaultPostalCodePattern`, `country`.`is_eu` as `country.isEu`, `country`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, `country.translation.name`, `country.translation.name` as `country.name`, `country.translation.addressFormat`, `country.translation.addressFormat` as `country.addressFormat`, `country.translation.customFields`, `country.translation.customFields` as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation`.`country_id`, `country.translation`.`name` as `country.translation.name`, `country.translation`.`custom_fields` as `country.translation.customFields`, `country.translation`.`address_format` as `country.translation.addressFormat` FROM `country_translation` `country.translation` WHERE `country.translation`.`language_id` = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x00\x13„1.òO@šž¦5sÐWŽ" b"\x00ÂÓƒšãEK²à+Ì\x7FU\rŠ" b"\x02ˆ¤“]ÐHGµÏ‘}¯YLÓ" b"\x07‗Öì`mL]Ö\x7F╔¤\x15ßw\x04" b"\x08\vd‹gCAž‰µÞ‹»µÝL" b"\x08\x15>¼\rAN‚¦\x1E~G”´.¥" b"\x08cgÃ+─F┼½/yËü»╠¼" b"\x08}‘ÙÐ\x16J¥©ß{e”a8Ž" b"\v!@ÝkA@o¤esáÿDÓÖ" b"\x10(*ŸK&B‹šê™ü`ú£Á" b"\x10BW\x1A52@iæ+ìg║Sè¦" b"\x10L‡1\x0E5@ޝxyC¯9]_" b"\x12]¹\x02ß Gþƒvƒ•lHuÙ" b"\x12t1ÇsÖEô©\x1F‡\vT5\x14#" b"\x12ô╗╠║ØD¹«A²q>\t╚\x7F" b"\x13\x01Z7D5LJ†“¦»Î\x14óZ" b"\x13µi4/oB-ÑØƒöÕ· T" b"\x14(\x1AOr´N\x7F»•±Ÿ6ÜÍ’" b"\x14EÊ>\x05*Nr›±»þ¾C¹\x1A" b"\x14¢Å¨eXBià¯Qõ\x15hêÁ" b"\x15%âІ\x12Hx±ù¿½øŸdé" b"\x15h^\x14Í│M}êBM\füêb═" b"\x16\x14©2 ÐG\x06œòxŒy‰W¸" b"\x16\x1C|©´›K\f½ÅµmˆÞ¾p" b"\x16axH—ÒHʬæ†D\x08‡,B" b"\x18\rù“'úDª¹ÝÚ§õf`°" b"\ef'†®ýJ\x11”ƒ…kGÌš>" b"\x1Eš\x12-\x11LD÷’âA\x04Ÿj›±" b"\x1F4Qˆ÷¹OA±”t„ØG\x7F‚" b"\x1F\Éú OIÄèÚå├ѵ\x16\n" b"\x1F³z»ßûM;Ÿ¹\x02¨G>Ùn" b" \x03Õž\x05¿G\x11ŒJ«!3`cG" b" WtF ¨B}ƒÙI\x1CÖX¾\x10" b" ÔQ]”»K㩘ۊ†¿¾æ" b""8î~í╠OÞìöÌ\x08`░\x03." b""_â쎩H»½Ð~[“v°n" b""è%\f!àFNƒ¬›\x7F»Þ4à" b"#P…XK\x04L\x07£<û8¨»ÚÎ" b"#gä\x04-oNX‰u>$@%eó" b"%!8\x06┼║L\x0FÅé¯dî'é^" b"%)ÝÂxÓMd…\x1A\x013¯E_G" b"%Ý║\x14ü╚Fu╗9┘\x00¶[A¢" b"&Á\x07‰·ÆC\v¦º\eifëÞL" b"'╚D▀«XBV¢Åç\x1EÕ▄4█" b"(7└ÛI┤NF┐┐█‗ÿØFn" b")Í«Çj\x06DQ‰ç\x05í\x1DädÑ" b")ü±Þ¾kEƒ‰ë-³õòœ½" b"*\x1CRÐsšJ‘£\x1Dò¼\x16]¦\x1E" b"*’ª÷H\x08Ow¾Ø\v*Š žô" b"*ºö\r=±Fl”F\x1C\x01‘Šz»" b"*éÔŠ÷\x15C?¯NRÒ§ÄË\x1A" b"+\x18\x033Ž\x12Müœ=žA\x00t̺" b"+×:\x01*èDL¶ùÏ4ýþb‰" b""" ,¬È\t\n ¶G]µ1;(\x18$)' """ b",Û░¾;\x1D@Ø¡íÆav¹ª¼" b"-\t\x18\x14º¼O»†#\x19&aÕma" b"-ÑÇÉ█XN¶«Od\x06ÓÏ1[" b""" -ù\e „ADò’Ù\n \eŽ6—> """ b"."!!êH\x08Ÿ83}Î\x13áñ" b"2ÖFÒìÜCS®ðıL½År\x1E" b"2¥DÇ*ÇG\n¬¿¾\x13:\x00Ž2" b"3Q04â\rJ¦€ÕµKß ?K" b"4É¢M~×O╩ÉÖ\x106bÑ=p" b"4±Z46¦F@ìB'T)Uà\x0F" b"5,Þä═REïìò¡¾è\r±½" b"5ª×Òÿ–@z±Ž\róX%·n" b"6€'\x02=YLuš‘¹]`¸U-" b"7.º\x12üÞMA™·ô\r¸f\x17È" b"8]Û©+\x14Dï¨Vù½`LM®" b"9bj"\x05¶HO™C›}\x04×Ï1" b"9ÍC¼°‰F}…;<_%\x1C¢v" b": 2‹$½@ø‰5‹j(Y‘˜" b":ÏÜ\x0EÍ\x16Da®+Û\x1Dÿ \x1D:" b"<p ³\x0E¤HÒØä|\x1C6┴Zw" b"=õÈ\x1Dï\x18I\x00Šèd÷€k±" b"BhßÚ\x1E\x1AGz˜\x1E¥´\vgíD" b"B¯6æ–ZDî©‹ÂE²@~\t" b"C¢æ±ÝZDò‘Õ¸º\x06hî\x03" b"HæQª┬\x00DJØlú▒l\x1D·" b"J\x1DZã^‚Lì…µî’܃&„" b"Lr\x13ÒïÀL)ˆêžÓ^'™4" b"ND\eÓ¿B\v®„¬®§ïg?" b"NaÿÄ@tGuš?ÀåÝH\x1F¡" b"PêU®ÇZGU¸ŒèeÛª6²" b"S\eW\x7F:ŸHŸ\x05‚(ÁRU¢" b"T\x18ÿi\v/H\x13òÌÃòü┐┌Ò" b"UZJÂØvK8ˆ|à¯%ëçÞ" b"Um\x12‘²'H¿©w`¿?al!" b"V…üÌCäL\x1A™ÿ!µ[0)¨" b"WZ&òÎGH:»Ñ\x07@\enèØ" b"X9Å\x05¿ƒKtéÊ_¹C─Ç╣" b"Z·┤OöïH\x04ì\x00);÷A+ù" b"\\r¦.DMKš€WIK§\x10æ™" b"\▒ØP6ZL\téëG`\x0EÒpø" b"]¼5¢:›IŽ˜ZÏPÉ;œ\x02" b"]àËì6ÊJ9¡éù\x04R#9F" b"]öª\x0E¼\x7FOW¥~Œ\x0FˆzÅÀ" b"^)\x16o-ˆHí«—\x06»Œ€ ‚" b"aTxÓöGGÝ›…=4œÐ—È" b"aw¹Ù"çC\x05–‰¿@ë\x18l " b"bºøÞ³¬@,ìO\µRu╝¿" b"e¨n,G϶‚zOwv~Ý" b"fo\x03çv]Cá·çJÌQ”̆" b""" i\x02¾(\n íBß„\x10ã\x1C5È3l """ b"ieÉ\x1Ag©M\x04Ÿ\x13]\x10‡V²\x00" b"jNàô‹ÖM\x7F¨#ç†Vƒ$·" b"kL(ìá┬G\x02ÁêíÆá┘░Ç" b"kª\x11¶S7F©’\r¼mzòGk" b"lï═▀FaMüæIî4<²_5" b"l™!¡ÕBG&€´IjJãAl" b"oÂ'§FØJãÀE^uIäô┬" b""" q:‰%w\n C}¶¿Êhû0w """ b"r<’Õ\x00þNl¦2MsH§¶¬" b"r¨ø^\x0EÆDÎüb\x0Eþr^c\v" b"sÕ½{\x14¨H3†hÏiP\x16gö" b"uNü╩ðæNüÀ^_Ц\x1C\fC" b"uqø¥\x1FHHJ—ð§6Ô¿RK" b"u•7i\x08KF—…³\x04V\v?Yú" b"u╝\rsaÇG├«¶ÉÆ╬\x01{{" b"x\x06├_\x043AwîàÍ£\x03 Éô" b"x ¸\x1Eëå@¢¢\x06¸[{â'Œ" b"z4±›'@H¿©#®5pÌ\x11á" b"zZ@\x11oäC‘¹*mDfÈ7û" b"{]░L\x10Û@Øÿ░\vfféfE" b"{˜\vÏÊVIeœ\x06ëvM1NÅ" b"{Ý\x14\x1D\x7FH÷€\eÈ*Ô2Ã\x1D" b"|¦4\x0E(¥IމÑÑ&—\x16\x00Ø" b"~ý░┤¬EIÐó\x1C.\x04gíì║" b"\x7Ftû¨%\x1CKÒšÏÏ&àî{\" b"\x7FÙ'{\x08NLË”\x06ÉNgòç‚" b"\x7FßJ5Ç”Oã·\x0E“ø\x1C9‹“" b"€¢8µæUH–‰\x1A{òhÈnº" b"€±(·óƒD´¶Ãb¼ö-kˆ" b"âA┘úÐ^H\x18Éà7ªéB\f\t" b"äÉÁªÂ\x0EE║ºNu\x150v\e\x06" b"†/®\rIRN‹¯L¹%¢¬ë¬" b"†æ\x18´«ÒHÈ©²dd\x04zþê" b"‡0‡\x0FŒ¬F7®°ø%\x17Õ§E" b"‰\x05_\x7F˜âBt”žoISC5y" b"ë<\x1D╗ïúEmØ╠9Åþ7\r÷" b"‰Gë\x12T8N²°¡V•za¥5" b""" ëh║nmıD\x13ïü▓ÛÎÚ\n ? """ b"‹1\x16°aÍJ\x07»ÔßÖÍçâF" b"‹Çi¶M\x1EDQ¤žŒ\x02¯Eˆ#" b"ì!®"`cC┬ÂÉ╬fn¢I█" b"ìl\x10¦EAJ+üQ±\x15¬\x08ÈÞ" b"ì¯\x1A%ô╠IÞúì \x04L\x15tÅ" b"ÅvÕ)É▀GeôI\x00j\x1C■]─" b"É\x11iW\x15ÜJ\x03ŤZ<\x11Vi\t" b"æüuÐMJK.ÀѤ\x19%?À\x17" b"ôN}g║Á@\x07ôÆì}1ã═¡" b"ôe\x19B»ÝO:ì"░®ªv┬▀" b"•‡Llþ\x7FLà·æÏw]Úð|" b"•‹rû;‘@l±åþ€ôF\x7Fé" b"ù±┬UìcC¡óâ¥f▓³\x10\x1D" b"œ=¨¸¯\x1EO]”Ò¯y*\x02+-" b"œõR§ø8M ¼Þ\x03\x02-\x16îí" b"Ø┬\x02Á4`OZéWÀ+Å6\e\x08" b"¡ÅÍ"5×Bï§\x08_e&¬NÛ" b"ú'¶Ä¡\x12I§âø┤3h┐ì¥" b"úZ┼‗ÅàNÆ║ùÍSPæ┴}" b"¥É*ž ?M\x7Fš…\x7FDzq§¡" b"¨w´ ÅlEC¢‡èúŒþö0" b"¨¡€–>\x06Gþ£U¡MÈ=¨–" b"¬y■└íUJüçþMD\x1FX_»" b"¬{a“D°Gâ‰\x18™3¤µKs" b";½ñVž@ £²ŒÈ%5Ôl" b"ëY\x0EÛ\x19McŽá…§¿1î\x1E" b"®€c\x19\x02ŠNW ÒÌN³„\x1Eƒ" b"®ñW’·HN*‘ö\x1D”ˆ§¿\x1E" b"¯tù¾Ç%Fƒ±ˆÇp\x00×o×" b"¯ˆ(\x04ÆúEQ¶U ©®ŸÏ\x03" b""" °>\n ’¹4Hñ“:\rHÚ9\x14q """ b"░|ú\x14älIëì¨gr{CéÌ" b"³{BôÌ\Mñ·\x03\x05ú`\x19€Q" b"´;LÚÕÂJСGwV¢dÝ>" b"ÁìËyÈGG«╝0Þ¢Ù<òç" b"ÂòTYfBKB©á╔M│2½Ø" b"ÀP¾&WB@Å«HÑ4°┼²_" b"À÷hÀà1N9ü┘\x0E\etZ╦ù" b"¸”ŠñwlK\x12Û_‹Éõ\x01¿" b"»¯ÉLþ£F°¤\t+åVBë½" b"¼B\x1EiÏúGÌ‚SÖ.|ozH" b"½_l-î§@Ø…Tb}öói\x12" b"¾ˆŠ\x1DÝ·L#²\x05:‘ÿ;P¶" b"¾š›j\x1CçCj‹Âë\x19ø^"ò" b"¿Då PØGÒ’E‹ÊÌxƒI" b"ÀÔcКÜC\x02½áØÞ¼*J\n" b"Á\x07¦}E:D¯¾‹_YÊÝöL" b"Á\x15{K\x08«@‹£•.ÙÙ’\x01Ç" b"Á‘„|;COü©/÷\x10\x1CË5\x05" b"┴óEò‗£I\x00ÅO$ñÞƒ╣ö" b"Â\x00ë\x04RÊO̺|\x14§ù˜¤Ð" b"┬2■úë▒Enúì׃qLÓ4" b"Ä8\x08Ä<UNêŒEÝ\x0F/F\x15•" b"ÄýÁÉ\x10ÛHö²\x01ê¼ÙK\x1DM" b"Æ\x12\x1EcÅ\x06J\x05Ž˜"±':6\x19" b"ã\x1A▀[║ò@╔î¾óSÉ®Çn" b"Ã!Yl\x19\x05MKú\x14Ý\x08ìFìB" b"ÇþªõÂÝE稜g›Z,Bá" b"É\Ä”/…Ir¯&fm\x1F;wÔ" b"╩ì\x03³E\rGÓ×Ws]\x01nG0" b"Ë7žû\x15PC|²H\x1ET¸ö‰‰" b"˪4øÍ2D~‘ƒâ‘ÿ@=á" b"═R±ìàIHªÉÙ}║o8ƒÕ" b"╬T#$Ï\x10H ûI¹u£þüÌ" b"Îã#@“áEニ„4kD\x00f" b"ÈäùÉúéE`╗ÆêRò0nA" b"ÈÉ╝ïuTM═ºäéE▄6I╗" b"Ô·£–ævD7·¾øà\x7F“ -" b"Õ°\x072Î\x19L¬¡zÕ\x1E{“Mã" b"ÖB¡ó\x7FÉK\f»_(hEëå®" b"Ööå°„úH刴\x07¿ x_Ñ" b"×ä\x06QŸZKÒƒÿ´0¢5ËD" b"Ø[\x12̇O£¯°âhQ\x1C\x12¬" b"Ûë´\x13N›I|ŸÞvÌ`ÿG\x1F" b"݃™ï³`K`©¥ÜaÌYMÕ" b"Ý«æ\x18ÐîB\³Ì§Ëƒ\x14—\x01" b"Þy®š\vô@\x03¨"á(›ï¥" b"ßN†êyQJž¾\x13bMc?$Z" b"ßnÉ~ñòFö€\x19ã\eøŽÐô" b"àCMÅÚØG¦“\x7F®[ü¼ér" b"ß~|¿£IN\x1E╣¼▒ì\x10F(Ä" b"á¸Ï}ðâDð¤u†Ü¹Ý\x11õ" b"åM.ÒW\x05GN‘ŽUޏ$´í" b"æ \x1FAk“KÅ’EÕÎ4æ+\x06" b"æz#EñdF\x03¦v_ò¦6ð-" b"ê:è£2#M{°`uZqeÄ!" b"íM‰&ÕrJb§ŽÑf¯tõ«" b"ñ`¥2Ê\x08E*³\x07){s®óä" b"ò+†\tÌ\x06L\x18±xži—\x07Vf" b"ò8›55þGã¬4-ô5R½r" b"‗┘\x14=ÍùHÜò│0~└\x18\x1DÅ" b"ô\x02°äW0KþŽJ¦\x14xG‰Å" b"ô\x10eb¸\x13Di²BAR¾\x06ýC" b"¶╚Ø╩)+Ojª/ØØ3§\x00." b"õˆRdòÐMÊ… çž\x12}}s" b"öTŠìЕFT§Çÿ*Ìëê " b"÷ƒ1ªä^IÍÅwZpim\x14▓" b"÷\x1E\x07ï¡K´“Ó\x18]@’ 9" b"÷fM$â:@\x06™Ç/ƒ\x18þ-C" b"÷lwdC(G¬„ÃŽ¼S\x03ÿ#" b"÷Ú0Rö-KG‘š\x14Ú"YäÁ" b"¸õîûı╚F¢äxì=ʵ}é" b"ú\x05ÜêáI™‘“i&Ìdþ\x11" b"¹\x13\x1A±d½EþàØRÚ4╩µå" b"üÅ\7>%G\x16µ…)'¡Gž" b"ý\x03þ~ΑA0´G&\x1F"Áþ " b"þ\x08k{{ØAù /¬‡¬|R+" b"ÿk89t+OÇ“‘\x01>R¨’¥" ] |
||||||||||||||||||||
1.67 ms (12.92%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[] |
||||||||||||||||||||
1.50 ms (11.63%) |
2 |
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
|
||||||||||||||||||||
1.02 ms (7.89%) |
1 |
SELECT custom_entity.name, custom_entity.fields, custom_entity.flags FROM custom_entity LEFT JOIN app ON app.id = custom_entity.app_id WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
Parameters:
[]
|
||||||||||||||||||||
0.94 ms (7.26%) |
1 |
SELECT `country`.`id` FROM `country` LIMIT 500
Parameters:
[] |
||||||||||||||||||||
0.76 ms (5.93%) |
1 |
SELECT `name`, `path`, `author`, `self_managed` FROM `app` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||
0.66 ms (5.14%) |
1 |
SELECT item_rounding FROM currency WHERE id = ?
Parameters:
[
b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
|
||||||||||||||||||||
0.51 ms (3.99%) |
1 |
# dbal-plugin-loader SELECT `name`, `base_class` AS baseClass, IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active, `path`, `version`, `autoload`, `managed_by_composer` AS managedByComposer, composer_name as composerName FROM `plugin` ORDER BY `installed_at`;
Parameters:
[]
|
||||||||||||||||||||
0.44 ms (3.38%) |
1 |
SELECT id FROM integration WHERE access_key = ?
Parameters:
[
"SWIANXZVZUVDB3N2T2JNUVE0ZG"
]
|
||||||||||||||||||||
0.42 ms (3.22%) |
1 |
SELECT `acl_role`.`privileges` FROM `acl_role` INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id` WHERE `app`.`integration_id` = ?
Parameters:
[
b"WÄr\x03!├AoÜÇì\x02Þ1s¿"
]
|
||||||||||||||||||||
0.31 ms (2.43%) |
1 |
SELECT role.privileges FROM integration_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.integration_id = ?
Parameters:
[
b"WÄr\x03!├AoÜÇì\x02Þ1s¿"
]
|
||||||||||||||||||||
0.20 ms (1.57%) |
1 |
SELECT admin FROM `integration` WHERE id = ?
Parameters:
[
b"WÄr\x03!├AoÜÇì\x02Þ1s¿"
]
|
||||||||||||||||||||
0.19 ms (1.50%) |
1 |
SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
Parameters:
[]
|
Database Connections
Name | Service |
---|---|
0 | default |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.