Redirect 302 redirect from GET @frontend.account.home.page (f1dffe)

GET https://sw6-staging.gt-netstore.de/account/login?redirectParameters=%7B%22_noStore%22%3Atrue%7D&redirectTo=frontend.account.home.page

Response
200 OK
Browse referrer URL
IP
216.73.216.38
Profiled on
Token
c20392

Query Metrics

80 Database Queries
63 Different statements
145.67 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
51.60 ms
(35.42%) 		1 
# seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (seo_url.language_id = ?) AND (seo_url.sales_channel_id = ? OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0)
Parameters: 
[
  "/navigation/84ade65198b34b6188cd442f4817a800"
  "/navigation/98dfc620bb454229a230e0e66335c04f"
  "/navigation/a528a151875c40e3aa8b2359fd7cd30d"
  "/navigation/8c12ee6289d74fe28fb217b79ea45b5f"
  "/navigation/d6ec1ea1fc2e45f38858ef90620d7d41"
  "/navigation/38d6b7c718cd49c6b640af5e7d558967"
  "/navigation/a6c18c3223b64bd6b2a2495eb3f69e79"
  "/navigation/6031a180fad94bf1a6695e248bc08ef2"
  "/navigation/20e6708b57ab40b4a44d920c29b5f15a"
  "/navigation/84ea64faefa84fc0a601d2852c7ccf44"
  "/navigation/57a7963aba5a4d24a9bb309309ecf437"
  "/navigation/7c320ac46b7b4d9d87c3b00750ab5eee"
  "/navigation/41b40e2ee05b47e995fc05dd1e535c7c"
  "/navigation/d0eeb85cc59e44f0bb50f39194d05b2b"
  "/navigation/a4e1e8dbce9841358cbab4d79eda87c5"
  "/navigation/225fccc7a1084860b41d26ea21493350"
  "/navigation/a79fcac3d0cd48b7b61d5d4b714cf649"
  "/navigation/00f7f85f1f4b423dba8406558b9ce536"
  "/navigation/8365c2bd24534fcb9486d141a77c6615"
  "/navigation/b77cacc6546f46bc93e40c77813d2708"
  "/navigation/dd377d4f7364472d882780f8a0d3d754"
  "/navigation/11246b08f8064f428fb399d8a0c8d428"
  "/navigation/1d116a3aedb54c2aac86ea96f33b82d8"
  "/navigation/fb44c3966f6b46e39d80a04413395e5b"
  "/navigation/3d0190c16ba642f0a878a4e7bfbe1a20"
  "/navigation/4345bc2760574c33a6aedcda8ef5c61f"
  "/navigation/191f640b9b7a4922942e0c6fe33383fc"
  "/navigation/294be15d754c4c81b8128d0dcb131c56"
  "/navigation/9651cdd1bfe04cd2a700c39ae82dfbde"
  "/navigation/4c4f2046086c460f9a037cd6223d7c2e"
  "/navigation/bf48fed6b28c47199e5692a6f3619b6f"
  "/navigation/13958747d1f244a4b4a0e6fd577dd032"
  "/navigation/fd8b176c74b744d882d551f54c4b4ffd"
  "/navigation/e44965a570af4f5d95785e73e2a0fb2c"
  "/navigation/436c365430624025ae5d9110f2b63fdb"
  "/navigation/a979bc08605e4424bc98a3fb6456ebb0"
  "/navigation/0845d8de24f947dea455ce4617f3ea5a"
  "/navigation/0f8645cab9e34a31b57f5573cc2b5f21"
  "/navigation/b3fe6d4bc500416eb39c65863a6722f6"
  "/navigation/102b83988b57424f90f8fdde1b2195db"
  "/navigation/4361c19b4ed24782a75f629fd741f05a"
  "/navigation/603f8d492d0042c89ea47bbff69f636b"
  "/navigation/3b2df5b47b5347c682afcf7756743890"
  "/navigation/c9b9b36b42f54420a5d4c1d83b2d4df0"
  "/navigation/37a0104cd08c488e82cc95bb31e4c67b"
  "/navigation/0ccefa410ef6408e8028497b70ad2674"
  "/navigation/a82368c0407f43dea2aea0bc23c9bd2e"
  "/navigation/b3bc48842e5840b7b843448517d03600"
  "/navigation/7215a82d5a1d4f758a0783f447256baf"
  "/navigation/83e989cb22b946b5a4c2daf334a7f7e2"
  "/navigation/a7a4a2fcf4f148f19b94fe30e9027315"
  "/navigation/d9572c523cfc4015a0b4e623dadf5cb3"
  "/navigation/5b7a115bfbae4a4ab97fb081fc7e9604"
  "/navigation/e8126eba6b0e491bab5336f969e6cf98"
  "/navigation/efb6e4a9336d405599f67498e9c0c180"
  "/navigation/cde12142403e468c830d380194d29ca8"
  "/navigation/3524f4e4940548c8aed87fdf9e164758"
  "/navigation/ccc87d269f474dcdb3fd9b12553d5a1e"
  "/navigation/bb1d0d1b0a1f40d69b3250dc7b96ae74"
  "/navigation/98c01baab86c48f99d1671107a839f23"
  "/navigation/3c11f1b4aebf4d9e9970ef8a3c6d326a"
  "/navigation/d23817343fba4f8dae736e9f79356987"
  "/navigation/6bd84dc16f4f4c7f911771af730204e0"
  "/navigation/e2b927e0739c43b9a1cbf526ef8c34a1"
  "/navigation/58aa8358541a4085a5c33172c5e8a8f7"
  "/navigation/f68fdab3cb5a468eb9780e509b55a786"
  "/navigation/56b928ff10ae4163943ba216223e2c97"
  "/navigation/f89e6e687dd6475894c0eee8abf79077"
  "/navigation/7e50ac90ada542b5b1ba9f7c9d09dba9"
  "/navigation/a0f0ee910e2b4fce8abb4d9a5a363f16"
  "/navigation/34b2eea80d40457592c45c89bef92f53"
  "/navigation/4d1fdb207d704286b12ae62aa540429a"
  "/navigation/6e1f70c66b7742caac3892237c65e347"
  "/navigation/7ac5ec9e3a46427499e89c3cc911da6b"
  "/navigation/7e07d286c96342ebb5695ec567899fa0"
  "/navigation/c2072d6ff0674c49885a358e3c67bb6c"
  "/navigation/93d8eec88b5e48be9dbbc27f6803f152"
  "/navigation/5822e6e828644ac295a9393d4983d5da"
  "/navigation/d154b076de5d4d2c8498b33aef5b1d0b"
  "/navigation/c2af5cf2ca0a4f5a8f5a3cf704b6b560"
  "/navigation/d7737a8e8a124338baf673c940867ab6"
  "/navigation/f6210f86be9a445891e294fdc039e9c9"
  "/navigation/b8cdd9bb9e8943d69703034fca1fed9f"
  "/navigation/d74b55ce8a8c426f837b0bfecaf41a30"
  "/navigation/4871ee6967d6449bbf235f33f1e523b3"
  "/navigation/882ff60708e84f5baf6276ffb2c590dc"
  "/navigation/eeb528ce010e447793b6099c08740be8"
  "/navigation/2d48699627244139af568f0d734fa3c6"
  "/navigation/c57c214ce0a94caca3da72c7e545ced0"
  "/navigation/985cfb26f01b4265a3c26a1b3859dba2"
  "/navigation/0338a7c864c64ebb9149386e50473664"
  "/navigation/c7b8cf44325047c285847d369eb2f3e0"
  "/navigation/1df87540a77246e89078c342a6a7138d"
  "/navigation/a0a685015b0a46578262cb21cc3ef175"
  "/navigation/274192b9a95649b9ab3fea75a764bb0c"
  "/navigation/b6a4ff1410b74c67ac35640949522965"
  "/navigation/2c612cad06074a3f9fe6044652e198c2"
  "/navigation/7cacadc32f5d498d883ee2fb2a5c44e6"
  "/navigation/d06ecd9b8dab4b6faf7fd1ea3a9ef4ea"
  "/navigation/afd7d503ea1b4134ad4b3a41901b6db5"
  "/navigation/a2f5b7915ffe4127998bdaade0a077c7"
  "/navigation/e750e496e356431e980bf8d2b6a58661"
  "/navigation/0615693ed6654c208a7b9de7c4725e8d"
  "/navigation/3dd53b684c594834899b150be3d1cd8b"
  "/navigation/ca12e45b6cee4eaa9f8dddc4ef17a5d3"
  "/navigation/6712213864874c2bb7c5a136a92a24bb"
  "/navigation/a9c7bd96f66244a3b9527425c03239a8"
  "/navigation/cd0e69b004d1428888cadb16c8d10e5e"
  "/navigation/133fe02b08294b859bf636442a16ef06"
  "/navigation/934ff00b783b4248ab9de18fce07b3e0"
  "/navigation/dab8bb7e1d7041bf8cad408a5164d5f4"
  "/navigation/583c65433e6c4a22a785f685f91afb07"
  "/navigation/4a6978aa036e4a8dbb3f55fe0f77daeb"
  "/navigation/e7f38af185264ae8a228b1f70e1a8185"
  "/navigation/73211d84425645c6917dcd73ea406331"
  "/navigation/ac0dbf31a3b841a2b98453764a696713"
  "/navigation/9e0bd62311f4421cbf79c451f512f48a"
  "/navigation/4c7e106950d94008b842cb9b61ab75af"
  "/navigation/bb358a7857364120bba63709c3356d24"
  "/navigation/4e757a87d7d94dda80703d8b040513df"
  "/navigation/bb080147620246b5bc47ff753f3ee8a5"
  "/navigation/591095ec495d46e6873a8f837321eba7"
  "/navigation/aab8233e183b45d79dcb4611bfe5213d"
  "/navigation/53e41b49fceb45d88a7bc95de32d1253"
  "/navigation/d47f2ac439bf4311a3454948d1589ce7"
  "/navigation/b67aa83c0d7a40d29be46050274927a8"
  "/navigation/b36e154859c24f16b4d5a04feda06a27"
  "/navigation/1d6a42c311234e74a2a4ff3266662679"
  "/navigation/8c652a541dee41c989fbb3826c953294"
  "/navigation/ba2c424186cc4d7dbbd1732c6708a9cf"
  "/navigation/385cb3afe2c44d3883b953aa16eead27"
  "/navigation/6543a525bb1a4d4f89c673d1a7074966"
  "/navigation/1307763cb43242bc942c86c1cba0f30e"
  "/navigation/b3b0e1b38ebf485cb28837c6384d3f48"
  "/navigation/147deff200134803bffe0d7c574a90ef"
  "/navigation/d4882736e1994205a49e3aaf84543807"
  "/navigation/71e352b6aab9498d972aacbb37a74afa"
  "/navigation/a01d0e8dc4da43d4b2d11c076df88bfc"
  "/navigation/32211f67b3c54692b7f34300dea9aea0"
  "/navigation/3ab2e2c7610f4a18a6a6184c28dd78c9"
  "/navigation/a9580b01469246049b037be8b95faec9"
  "/navigation/56b20afb69dc46c493d64e9ad698e7f7"
  "/navigation/6cd77e2e00064dbd926722be8bd5ca83"
  "/navigation/26eed1daed714f288fbd50317bfd49ed"
  "/navigation/6b96d0df53544d57bea64e0ca9d1691b"
  "/navigation/f7f2a98032ff4a60b2f542ddceade594"
  "/navigation/54a759940f59422f86183183bb0586d9"
  "/navigation/2a55735c799845c9b2838543242610eb"
  "/navigation/ca9fa8a066ef4346a2ad44c17f26b1a5"
  "/navigation/7202157688804c78ba2385391a077db6"
  "/navigation/ecc8d8c3ac8f4b48accb2f98947239fd"
  "/navigation/d75f6132015c4db39b4cb39948b7a93c"
  "/navigation/7131413e43d841bb8c7f4908e4f98b09"
  "/navigation/9fd547605e244008b47e4219d213dd7a"
  "/navigation/be42e7b41fd442e3b7acf0db283f66d7"
  "/navigation/afb6771a8bbb4edfb06ccb45d2fa0961"
  "/navigation/2a50b73ea60a44d4b88db036cf44a447"
  "/navigation/a6f601ad752d416899504eb36e5b1ab6"
  "/navigation/212f1f8ec0734e5e887d598f3fbb99e0"
  "/navigation/a64e6d0cc0eb4dc7a1832fab66724f5e"
  "/navigation/9276f1c4f4f742308afe36c63737f5b1"
  "/navigation/7adfe892114f4657a5c219fd06fc6ac2"
  "/navigation/8b96b77fe40246b4aa48132db0ab517e"
  "/navigation/de6c72f2063a4217b63b0f70fc9d5aa8"
  "/navigation/a6b18aa210a34eb8a05341a10f46a70e"
  "/navigation/cc0e8492d3564512834a0091aed7a5a7"
  "/navigation/cca6dbb46b954d93b0505b5451d2d3f6"
  "/navigation/a5e51ec63013426b9c3d3a651fef61b4"
  "/navigation/ce779b81110f4f2682e1a7b346b4356a"
  "/navigation/0c86e483048d4d61b56419ff5c531115"
  "/navigation/2d6ad21d3ccd4a0eb8f7ec6beb5017c0"
  "/navigation/2a4cf57fcc4349389c39951b3011ca7c"
  "/navigation/9c65d435994a4b17863260da8a3c089a"
  "/navigation/b2b4582fbd7443b9b7118f96a4ef7914"
  "/navigation/cc701a42ba244cc08504bbd83a95a38d"
  "/navigation/3b777e8bd9ee4343a8da16c2ed641d75"
  "/navigation/3b41462fdb7c4c36aa3d8ec1be7cbe83"
  "/navigation/617ac2b0414443a8945ae06675cb07ab"
  "/navigation/125a991d63b44d119e84deb19074de74"
  "/navigation/c01eb0e793fb4133a065e31b738beb79"
  "/navigation/b88a9283ae2949c0a96d4efa6e9bbad6"
  "/navigation/6490ea4f6a2044ed9c2b822d709ac6fd"
  "/navigation/1e243e7ec5b94389b9078444f9b8326e"
  "/navigation/c03d52632bff4ab79fffbe160ecdc8fd"
  "/navigation/3bf18880c9fc488cb9281417f8b06fbe"
  "/navigation/ea776e670dda46519e2fa7f0e46629e1"
  "/navigation/f240182589da4d6d86df89ce49c5563d"
  "/navigation/37092bf24d9e49b19be53d526abe842e"
  "/navigation/d99998e1a36b4a309a90ee95269183db"
  "/navigation/c036b5ed5cf14904a370b150ea8e12ab"
  "/navigation/197e5a44a4bd4a408b6734c72bab4d68"
  "/navigation/fc6fc29145554acda9af302845a3511d"
  "/navigation/2b3242489d8a457f93f8a6e74ce6e122"
  "/navigation/3a2a66fa6dde4e93bb75cbb6a4c4936f"
  "/navigation/da6c7c14306e4e4f9d3a45c4ae48954a"
  "/navigation/e04bf40e3a354a20890fefad23329816"
  "/navigation/c99085faceba418da1b5537d84868074"
  "/navigation/c7e8417ec99f42dbbe7410c070547c76"
  "/navigation/1218daa8702d42c3874a523faeaf2d22"
  "/navigation/1330dca4c732459a983aee83124498b7"
  "/navigation/7a02eb09ced8451bb78d31423908a3e7"
  "/navigation/83924cb6438747deaab80f0244945a2b"
  "/navigation/9c311426f8a24bf88ed51ac3430d85eb"
  "/navigation/1841a330a3c04a9c895beca94902e099"
  "/navigation/4795c90456684cbda787fb8bc29d6c02"
  "/navigation/960b20a8d8d641669f1585f54c4c06ad"
  "/navigation/9d6c167c7fe84be796f98bc47b8872fb"
  "/navigation/22e6df2da6684b7485375936773ec99f"
  "/navigation/e4d5e091ff454d44a1bde34fb080ca53"
  "/navigation/5b66c9897d974b2081cdd342c47ec0b3"
  "/navigation/c2dfec2da88a44af8b88e5fd3eadd463"
  "/navigation/a579c021c55643b5b67e056a06c25400"
  "/navigation/61d711eb1fad449894b375aef3181fb9"
  "/navigation/a640c7b891834fd792118469b2e43054"
  "/navigation/e801782c855347a995b80b2230621a97"
  "/navigation/303703c96ef2474abc0b7c614287bf5c"
  "/navigation/48c2de60a8c14b1897db6fc3f9d7e4f5"
  "/navigation/e002e1a425c04dcd9a548ba601bcbec7"
  "/navigation/0d91f8e968034828b9ce080e34f0fa1b"
  "/navigation/412158e3d619499d809503933bff6c27"
  "/navigation/dc927022a10447fea55e1e3e798137e9"
  "/navigation/b0207bec63b24043946a7f90debf6d69"
  "/navigation/f622490449fe488da1b67787c679cbde"
  "/navigation/15804c93a51e495b98488fc098d909c3"
  "/navigation/b14eb4d5aa304271a19ee16abfaee07b"
  "/navigation/59564df50b894993a2d057df728b2e0c"
  "/navigation/c370e0a08f6b4814b32c166aba49d96e"
  "/navigation/9832a4bf44b346c2a46cb20ab002ad33"
  "/navigation/601dcb6a70fe4c939c5f4a1931e4f4d4"
  "/navigation/02b26860e5464649aecc372cd9aff062"
  "/navigation/065413d816b043db86bc61740e5ae816"
  "/navigation/656c56ab721343af827a52529aaa7428"
  "/navigation/1edb1be62cf6446dabcae16fba51a767"
  "/navigation/6edab172871e4a4484eb6a30a1560a99"
  "/navigation/7a67acffe60549ca992ec51a84e369db"
  "/navigation/500b6c5766664ebc8bf8738a330581d0"
  "/navigation/8f591139207e42128086c3ee23273c4a"
  "/navigation/c39c6a24670243539ab7bb72310b6fbd"
  "/navigation/c3a8ff4eff1e40628562b1e599200ec4"
  "/navigation/3dff3441906d4d0eab29e604ffbf78db"
  "/navigation/3850e6e5d68d4219a4c72592f0249ac8"
  "/navigation/750a7ac0f8ce4f60acc26d05f527aeb3"
  "/navigation/f2486a3017bb4cf0bc96733e0adc7cee"
  "/navigation/496722352c41423a9180f91cfa30e21c"
  "/navigation/5d077a3ef4114aeea598121f17cdd33e"
  "/navigation/0f81e94c4b864048bcb8e39482b991ca"
  "/navigation/4ae6ea5ed4fd4fb987c9dca5cc2103e1"
  "/navigation/1b8153c3b43e4673b1b70ab278b71da6"
  "/navigation/791b08e9f1ec4e46bc1ad1aa6180686a"
  "/navigation/591f789a6b4846e8a5e90c3eaa3b1c8a"
  "/navigation/cd26e276f638467ebe68abce3a23d087"
  "/navigation/e3b2f96b14964a17b95d6f656e016188"
  "/navigation/d54e2736458f4092800233eb807b7851"
  "/navigation/27b54f3e467e4579bee42b78378ae5fb"
  "/navigation/1f2f9de9d8bb46db8db02892516ed1b8"
  "/navigation/851d899331854524a4f202e12d77bada"
  "/navigation/a271ff11a8b14e12b5f87d93c66b98dc"
  "/navigation/1f6b867e8ab9451089b07373240b91ca"
  "/navigation/df102052f5a4487fb003906e1c3655f7"
  "/navigation/c45188eeef03487ca208eff7664c60b2"
  "/navigation/39a33c53c8b84dbf98641abdd2a8f9e8"
  "/navigation/9e1fd9ab98e5403fbad87ba7030bdab4"
  "/navigation/b6b2bc223d494e3dbeca11b4a7cbec24"
  "/navigation/6df2c77770b7407f9ba52c64b2423c86"
  "/navigation/ee254f38846f45039b189cf70e814e99"
  "/navigation/a8cca64655af4122a3851600211017b4"
  "/navigation/1aaa027b3b34487b9f3a52613eaa26a8"
  "/navigation/813596210b194f8db8f79bef8b15896b"
  "/navigation/14447d787845483aa089960a6dfe5c80"
  "/navigation/ce5a12ac52694ac6a52877cbc639b493"
  "/navigation/467228f840bf49388cce87430b6b6c34"
  "/navigation/2882ad55bd5743178737540f6aed0bad"
  "/navigation/afd01f50915342bfacff5f0613af8dc8"
  "/navigation/c7856965c50446408011345e52c4f001"
  "/navigation/d01c851b8f2247e6b4b1906cb9e33ace"
  "/navigation/507386af2696435b86e45109bba1d1fa"
  "/navigation/f90fbe8c2cb54344bf259c811ef58494"
  "/navigation/d387d19ececc4c9b859c0ad0fe19f603"
  "/navigation/3dc6361d57ea4bab87dfd06e4ca5d17e"
  "/navigation/b068c7a0062e488fb1806fdfb22f753f"
  "/navigation/73754d4c0d5f455fb89f5bc561e96aef"
  "/navigation/286bbb9353a04577afacac809a9c5031"
  "/navigation/f71bfc8e59aa45babc11dc79956c7ca1"
  "/navigation/ae5a3bfb19314331a615c8e37514eb2c"
  "/navigation/167aaa107b854534adf5ab667321a5bb"
  "/navigation/3c6d0f9a34be4c35996adc1ab499776c"
  "/navigation/9fcbd4018f51437f83a831254bc72539"
  "/navigation/d0ef9515189649ac81e80c5b0db9e894"
  "/navigation/1ada472b914248aaa893134b37556f50"
  "/navigation/6e4bedec86ed409abe59e3a2078b3169"
  "/navigation/a417ceb515b848dbaf8a02c61085a3ce"
  "/navigation/a19d1f424873429392aebc4b7c989d36"
  "/navigation/adc1905cbd694d4bb7247fd715bb468a"
  "/navigation/4e2126710ecb4841a55cb2f9f8afcd25"
  "/navigation/e98a7e2e730c4c6cbd9a81362ebd827f"
  "/navigation/79882f388ae847ac8673d87560f0c783"
  "/navigation/92ad923f0f434207bcf422a5752c71df"
  "/navigation/d634d48577ab4dfdbfb63c344ed2f826"
  "/navigation/8a9b7d6070f243cab77d35db056cabf4"
  "/navigation/5de87d8ba1a842e89c0b2c6f1e89baf5"
  "/navigation/587d83a0206940b9b7efde9c27cb267d"
  "/navigation/fbbccfd0b3eb424f860c0152d225751f"
  "/navigation/a8082690ddba4d01a575f41b5204fe4b"
  "/navigation/65cd7fb6c748420b863b34ed355fbc48"
  "/navigation/84f6de61650c42f48bc687a6da9ddaf4"
  "/navigation/9ae1501252064a71be5078fe9e06dd9a"
  "/navigation/174b0d215b414c609c1a2339c05da955"
  "/navigation/663f792e4a5e4e82985d2e1ce2df25bf"
  "/navigation/628e550a4715400eb3e39848d9628e83"
  "/navigation/324df87b9c8843b5b0c304899b2ec847"
  "/navigation/a883d0a8a3c843b7b39d03d1ec6c9725"
  "/navigation/34a1851c1cd0417ba0951b8d4bc5661f"
  "/navigation/fc1bcd9d1140404f8c359a157eba7f8f"
  "/navigation/13df2516ab6245899ab749785c545685"
  "/navigation/613c4fd1cb60489daba3f431b73fca66"
  "/navigation/017d71100282417b9d69cca5d5da71a7"
  "/navigation/e6a55c93f80143919f08998adc1db7ae"
  "/navigation/42d2f3450db842c296c502a8abf96677"
  "/navigation/51cdd5a7ca0241c0a5f8e097299cfd57"
  "/navigation/c69c8b1dcc4f4f708544ef84b4a73eb9"
  "/navigation/8369b97a78d6471ea490c9ced865cf7e"
  "/navigation/bab761ad7b1e4f23a23a84579665acdb"
  "/navigation/d9916b38d3da4d15988f21487dcaaa4f"
  "/navigation/d87ea3f912a5421c8bfad53f13f9e97c"
  "/navigation/76d80d136b37476fa6ae77ccd8b9fca7"
  "/navigation/763e5222df4a4bc8bf9cbd1eab4b14db"
  "/navigation/574da9ea47244789b70cedd8abc946f0"
  "/navigation/6163f8a9a5df4d089e29bcb4c24b8cd1"
  "/navigation/f654e26645d641538e8fc76b9ab83ecb"
  "/navigation/10ce93ad341b425c8ed690eb7cfbdcbe"
  "/navigation/8cfec7c1f27145aba505876d8054f2eb"
  "/navigation/52c57e06a2294fc1932df95e64079174"
  "/navigation/df67fdfe1fbd450cada4a7bcabc223c7"
  "/navigation/cf2cfbe9ce074107adc2acca50aea0e2"
  "/navigation/9ddbca10be34411bb183a69498b1ec51"
  "/navigation/98d14c9737494ffda7ea9e07cbb9a5ae"
  "/navigation/876ecd05efaa4bbd9c33b1b254abe21b"
  "/navigation/ad9a0ad6e4aa4633ad6dfb2096c57672"
  "/navigation/71f36fb6b6ba43fd90657bd91dd6b6c3"
  "/navigation/e8873c6da359492c9dc25063ea012633"
  "/navigation/d1b9b939c97641faa445739ac3f6d67b"
  "/navigation/166b888cfca146ab97b098f4aeef7b49"
  "/navigation/8849b01991ee41feb7f8970c2cb44627"
  "/navigation/1190a4f6295c4ff39973054f7da9a341"
  "/navigation/14681a1d53fc47269c3abd8fca479c1c"
  "/navigation/8a415872d1254f8690e06af001e37758"
  "/navigation/ecb5e90ab26e47c5ae38f86d6c34f25d"
  "/navigation/c5ba3e67ae344f2aba164a2b6b1d5d35"
  "/navigation/9341ced5177441a1b049fa37611d8999"
  "/navigation/6518a136f64548ab917267c6e471c087"
  "/navigation/dff78ba694444a73a3223ef537ec0311"
  "/navigation/8ba230ec163a41bdb5c2eff1d13001c1"
  "/navigation/8ecd7ec14f624ce6952ad0ebe494f99f"
  "/navigation/5082da125cde44b5ba06788d5ce1db34"
  "/navigation/95bd6a2d58174b07b008c7736889fb64"
  "/navigation/c8a25185ff904778a457b7a247c799fd"
  "/navigation/2a408172fa4347b9be1ee468daa09ba8"
  "/navigation/b1597cc52d30426b8f664e466b1d32bc"
  "/navigation/17441e82845944a2851351ddf7ec7065"
  "/navigation/30b86cf352fb4243983b78ad8b6d0833"
  "/navigation/6f772030d057459a88989f257f087dc1"
  "/navigation/1203d7eaaa00430aaecdcc0f70034c2b"
  "/navigation/248442a28284400d9894290378d27ad7"
  "/navigation/9c6d6c9501e5463e825e2cf154ba5aca"
  "/navigation/71ef31ef28e44b878b47de65f7c031f3"
  "/navigation/96a7e02a40294c869740b0fa19b0633c"
  "/navigation/1cf7962fe7d7401682c0fe07bc2e98b2"
  "/navigation/0afbba1b312444aab7a2d6681845a1cb"
  "/navigation/f82eb10e23e74f93aa209db3b802cbea"
  "/navigation/3e54555c4816491eb1174970afdd6e54"
  "/navigation/512a43ab8656494bb4ea332afce56708"
  "/navigation/1728f82daf074ac284917ffe4d8edf35"
  "/navigation/fc6f432960794818b03cf9e700a970c4"
  "/navigation/359667deb1a64db4ba2507cd4badbfe1"
  "/navigation/9f59ea9ec84a4f6bb850b022f5a041ab"
  "/navigation/b600fa6cfeba4ae8995d053011ce364c"
  "/navigation/3b0a4377a91c43b28c08ede486815830"
  "/navigation/aa481d2484bf4c9f952f1c776a8cd468"
  "/navigation/9c88f2b065f1459d93e672e3406af259"
  "/navigation/e7241c87f9df4d199fcf7ddeea24d5db"
  "/navigation/9706e1dd553e480498f91ec4996b7f16"
  "/navigation/3a2f354f497640d08306236a7e44281b"
  "/navigation/d7a788ffe183459d9696e88fbf372f5e"
  "/navigation/364a7a73750d4682af5b8aba1b67806c"
  "/navigation/e9bfa4adf18743cdb0d65d642a72dab9"
  "/navigation/0cc929a2d59045be9225070605d1c741"
  "/navigation/cacafd3c5c9c48d791ee06d8b6e2f46f"
  "/navigation/77fd0d05f77f45fc818122557a29cb96"
  "/account/recover"
  "/navigation/0195126ba3954a76878f63be0cf0206e"
  "/navigation/a54541464b844636a7223abb0b9be3de"
  "/navigation/18a5160eefcb4944ad47ca5428593712"
  "/navigation/77087b88f91845cfbdf02e215df8c37b"
  "/navigation/342c2c9fcc3a4c059703c07b96381cbe"
  "/navigation/46edd7a2aad94af6976adf3b08b228d9"
  "/navigation/70999379166b47f6aca52a9c74d2f2fd"
  "/navigation/9207448ea5ad4829a2d21e2f8dae3345"
  "/navigation/f1f17a6dcb63428797f7e1393c56efd7"
  "/navigation/aa60f332a31f4efb8b8dc072e14d51a3"
  "/navigation/23cf980725f34ec0b26384d6fd7b3afa"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
]
View formatted query    View runnable query    Explain query    View query backtrace
13.44 ms
(9.23%) 		2 
# header::navigation::read
SELECT `category`.`id` AS `category.id`, `category`.`version_id` AS `category.versionId`, `category`.`parent_id` AS `category.parentId`, `category`.`parent_version_id` AS `category.parentVersionId`, `category`.`after_category_id` AS `category.afterCategoryId`, `category`.`after_category_version_id` AS `category.afterCategoryVersionId`, `category`.`media_id` AS `category.mediaId`, `category`.`display_nested_products` AS `category.displayNestedProducts`, `category`.`auto_increment` AS `category.autoIncrement`, `category`.`level` AS `category.level`, `category`.`path` AS `category.path`, `category`.`child_count` AS `category.childCount`, `category`.`type` AS `category.type`, `category`.`product_assignment_type` AS `category.productAssignmentType`, `category`.`visible` AS `category.visible`, `category`.`active` AS `category.active`, `category`.`cms_page_id` AS `category.cmsPageId`, `category`.`cms_page_version_id` AS `category.cmsPageVersionId`, `category`.`product_stream_id` AS `category.productStreamId`, `category`.`custom_entity_type_id` AS `category.customEntityTypeId`, `category`.`created_at` AS `category.createdAt`, `category`.`updated_at` AS `category.updatedAt`, `category.media`.`id` AS `category.media.id`, `category.media`.`user_id` AS `category.media.userId`, `category.media`.`media_folder_id` AS `category.media.mediaFolderId`, `category.media`.`mime_type` AS `category.media.mimeType`, `category.media`.`file_extension` AS `category.media.fileExtension`, `category.media`.`uploaded_at` AS `category.media.uploadedAt`, `category.media`.`file_name` AS `category.media.fileName`, `category.media`.`file_size` AS `category.media.fileSize`, `category.media`.`media_type` AS `category.media.mediaTypeRaw`, `category.media`.`meta_data` AS `category.media.metaData`, `category.media`.`config` AS `category.media.config`, `category.media`.`path` AS `category.media.path`, `category.media`.`private` AS `category.media.private`, `category.media`.`thumbnails_ro` AS `category.media.thumbnailsRo`, `category.media`.`created_at` AS `category.media.createdAt`, `category.media`.`updated_at` AS `category.media.updatedAt`, `category.media.translation.title`, COALESCE(`category.media.translation.title`,`category.media.translation.title`) AS `category.media.title`, `category.media.translation.alt`, COALESCE(`category.media.translation.alt`,`category.media.translation.alt`) AS `category.media.alt`, `category.media.translation.customFields`, COALESCE(`category.media.translation.customFields`,`category.media.translation.customFields`) AS `category.media.customFields`, `category.media.translation.createdAt`, `category.media.translation.updatedAt`, `category.media.translation.mediaId`, `category.media.translation.languageId`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) AS `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) AS `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) AS `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) AS `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) AS `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) AS `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) AS `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) AS `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) AS `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) AS `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) AS `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) AS `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name AS `category.translation.name`, `category.translation`.breadcrumb AS `category.translation.breadcrumb`, `category.translation`.slot_config AS `category.translation.slotConfig`, `category.translation`.link_type AS `category.translation.linkType`, `category.translation`.internal_link AS `category.translation.internalLink`, `category.translation`.external_link AS `category.translation.externalLink`, `category.translation`.link_new_tab AS `category.translation.linkNewTab`, `category.translation`.description AS `category.translation.description`, `category.translation`.meta_title AS `category.translation.metaTitle`, `category.translation`.meta_description AS `category.translation.metaDescription`, `category.translation`.keywords AS `category.translation.keywords`, `category.translation`.custom_fields AS `category.translation.customFields`, `category.translation`.created_at AS `category.translation.createdAt`, `category.translation`.updated_at AS `category.translation.updatedAt`, `category.translation`.category_id AS `category.translation.categoryId`, `category.translation`.language_id AS `category.translation.languageId`, `category.translation`.category_version_id AS `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title AS `category.media.translation.title`, `category.media.translation`.alt AS `category.media.translation.alt`, `category.media.translation`.custom_fields AS `category.media.translation.customFields`, `category.media.translation`.created_at AS `category.media.translation.createdAt`, `category.media.translation`.updated_at AS `category.media.translation.updatedAt`, `category.media.translation`.media_id AS `category.media.translation.mediaId`, `category.media.translation`.language_id AS `category.media.translation.languageId` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.language_id = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND ((`category`.`path` LIKE ? AND (`category`.`level` > ? AND `category`.`level` <= ?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  "%|647b732a5fdf4c1b9b721d904663af73|%"
  1
  6
]
View formatted query    View runnable query    Explain query    View query backtrace
10.47 ms
(7.19%) 		1 
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"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
  b"\x03‹ØãQmF\x1Aƒ|\x1F\x1C;ÅßV"
  b"""
    \n
    ߤhKÎHº‘f^x˜o„Ð
    """
  b"\x12rlƒ,£A$š\x06F\x18—ïÛ\x06"
  b"\x16€œwöVB-”2\x00\¤L˜\t"
  b"\x1C\x14G>â¢CØšBäÎhZŽP"
  b"+~ŠS\x10IN<“àU™’\x1E»Î"
  b"5\kû▀\x01Mуï\x171eºÌÅ"
  b"6¦\x12Ò¹2EaúN\x06Å\x16%B\x00"
  b"""
    ?D¢y6wM\x16ªkg\n
    8¦q\x04
    """
  b"H\tÍåŠÂ@¹®ã¹š£\x02Ò\x07"
  b"[ü¬\x0Ev╣K▒ÖO═4"=+\r"
  b"düqËr\x14@JÉ[õÊ¥\t¼¨"
  b"j\x1D½\x10t[G¢€Aγ©úa0"
  b"zñc;‹ùK™—0¯Î"u\x04\x19"
  b"|¨¾,õ¢C\x03›\x08¾TE\x13–("
  b"ŠžQݧEKs©ˆ‚©B·8L"
  b"¤œ‰¦ŒJO%™¡e\võ’Þü"
  b"­/¬[:ÂD~µÖxÿ\x04Gi1"
  b"³Rv™QôI\½3~Œh<sä"
  b"»°2Û­\x05F`«Y\x11·\x00\x13£”"
  b"¼'M\x11úò@\x02˜|²ÀóñTw"
  b"Øñ!³«H‚‹F•W\rkîâ"
  b"Ã¥1‡U=Gƒ¨P1…ƒâ\tð"
  b"┼Ã└‗█&H7ïóüE1è┘\x13"
  b"ת\x02mσ@½‚³ÄMd隆"
  b"""
    ü^jµv¢O‘«ë\x08=)\n
    ¦-
    """
  b"ýÐÎP«šB9”÷ùËî\x19—\x07"
]
View formatted query    View runnable query    Explain query    View query backtrace
5.44 ms
(3.73%) 		1 
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE ?
Parameters: 
[
  "payload"
]
View formatted query    View runnable query    Explain query    View query backtrace
5.00 ms
(3.43%) 		1 
SELECT `salutation`.`id` AS `salutation.id`, `salutation`.`salutation_key` AS `salutation.salutationKey`, `salutation`.`created_at` AS `salutation.createdAt`, `salutation`.`updated_at` AS `salutation.updatedAt`, `salutation.translation.displayName`, COALESCE(`salutation.translation.displayName`,`salutation.translation.displayName`) AS `salutation.displayName`, `salutation.translation.letterName`, COALESCE(`salutation.translation.letterName`,`salutation.translation.letterName`) AS `salutation.letterName`, `salutation.translation.customFields`, COALESCE(`salutation.translation.customFields`,`salutation.translation.customFields`) AS `salutation.customFields`, `salutation.translation.createdAt`, `salutation.translation.updatedAt`, `salutation.translation.salutationId`, `salutation.translation.languageId` FROM `salutation` LEFT JOIN (SELECT `salutation.translation`.salutation_id, `salutation.translation`.display_name AS `salutation.translation.displayName`, `salutation.translation`.letter_name AS `salutation.translation.letterName`, `salutation.translation`.custom_fields AS `salutation.translation.customFields`, `salutation.translation`.created_at AS `salutation.translation.createdAt`, `salutation.translation`.updated_at AS `salutation.translation.updatedAt`, `salutation.translation`.salutation_id AS `salutation.translation.salutationId`, `salutation.translation`.language_id AS `salutation.translation.languageId` FROM `salutation_translation` `salutation.translation` WHERE `salutation.translation`.language_id = ?) `salutation.salutation_translation` ON `salutation.salutation_translation`.`salutation_id` = `salutation`.`id`
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.20 ms
(2.89%) 		5 
# 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
2.89 ms
(1.99%) 		5 
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
2.29 ms
(1.57%) 		1 
# base-context-factory::sales-channel::read
SELECT `sales_channel`.`id` AS `sales_channel.id`, `sales_channel`.`type_id` AS `sales_channel.typeId`, `sales_channel`.`language_id` AS `sales_channel.languageId`, `sales_channel`.`customer_group_id` AS `sales_channel.customerGroupId`, `sales_channel`.`currency_id` AS `sales_channel.currencyId`, `sales_channel`.`payment_method_id` AS `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` AS `sales_channel.shippingMethodId`, `sales_channel`.`country_id` AS `sales_channel.countryId`, `sales_channel`.`analytics_id` AS `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` AS `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` AS `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` AS `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` AS `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` AS `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` AS `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` AS `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` AS `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` AS `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` AS `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` AS `sales_channel.taxCalculationType`, `sales_channel`.`access_key` AS `sales_channel.accessKey`, `sales_channel`.`configuration` AS `sales_channel.configuration`, `sales_channel`.`active` AS `sales_channel.active`, `sales_channel`.`hreflang_active` AS `sales_channel.hreflangActive`, `sales_channel`.`maintenance` AS `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` AS `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` AS `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` AS `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` AS `sales_channel.homeCmsPageVersionId`, `sales_channel.analytics`.`id` AS `sales_channel.analytics.id`, `sales_channel.analytics`.`tracking_id` AS `sales_channel.analytics.trackingId`, `sales_channel.analytics`.`active` AS `sales_channel.analytics.active`, `sales_channel.analytics`.`track_orders` AS `sales_channel.analytics.trackOrders`, `sales_channel.analytics`.`anonymize_ip` AS `sales_channel.analytics.anonymizeIp`, `sales_channel.analytics`.`created_at` AS `sales_channel.analytics.createdAt`, `sales_channel.analytics`.`updated_at` AS `sales_channel.analytics.updatedAt`, `sales_channel`.`created_at` AS `sales_channel.createdAt`, `sales_channel`.`updated_at` AS `sales_channel.updatedAt`, `sales_channel.currency`.`id` AS `sales_channel.currency.id`, `sales_channel.currency`.`factor` AS `sales_channel.currency.factor`, `sales_channel.currency`.`symbol` AS `sales_channel.currency.symbol`, `sales_channel.currency`.`iso_code` AS `sales_channel.currency.isoCode`, `sales_channel.currency`.`position` AS `sales_channel.currency.position`, `sales_channel.currency`.`tax_free_from` AS `sales_channel.currency.taxFreeFrom`, `sales_channel.currency`.`item_rounding` AS `sales_channel.currency.itemRounding`, `sales_channel.currency`.`total_rounding` AS `sales_channel.currency.totalRounding`, `sales_channel.currency`.`created_at` AS `sales_channel.currency.createdAt`, `sales_channel.currency`.`updated_at` AS `sales_channel.currency.updatedAt`, `sales_channel.currency.translation.shortName`, COALESCE(`sales_channel.currency.translation.shortName`,`sales_channel.currency.translation.shortName`) AS `sales_channel.currency.shortName`, `sales_channel.currency.translation.name`, COALESCE(`sales_channel.currency.translation.name`,`sales_channel.currency.translation.name`) AS `sales_channel.currency.name`, `sales_channel.currency.translation.customFields`, COALESCE(`sales_channel.currency.translation.customFields`,`sales_channel.currency.translation.customFields`) AS `sales_channel.currency.customFields`, `sales_channel.currency.translation.createdAt`, `sales_channel.currency.translation.updatedAt`, `sales_channel.currency.translation.currencyId`, `sales_channel.currency.translation.languageId`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.name`,`sales_channel.translation.name`) AS `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) AS `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) AS `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) AS `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) AS `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) AS `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) AS `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) AS `sales_channel.customFields`, `sales_channel.translation.createdAt`, `sales_channel.translation.updatedAt`, `sales_channel.translation.salesChannelId`, `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name AS `sales_channel.translation.name`, `sales_channel.translation`.home_slot_config AS `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.home_enabled AS `sales_channel.translation.homeEnabled`, `sales_channel.translation`.home_name AS `sales_channel.translation.homeName`, `sales_channel.translation`.home_meta_title AS `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.home_meta_description AS `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.home_keywords AS `sales_channel.translation.homeKeywords`, `sales_channel.translation`.custom_fields AS `sales_channel.translation.customFields`, `sales_channel.translation`.created_at AS `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at AS `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id AS `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id AS `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.language_id = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel`.`analytics_id` = `sales_channel.analytics`.`id` LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel`.`currency_id` = `sales_channel.currency`.`id` LEFT JOIN (SELECT `sales_channel.currency.translation`.currency_id, `sales_channel.currency.translation`.short_name AS `sales_channel.currency.translation.shortName`, `sales_channel.currency.translation`.name AS `sales_channel.currency.translation.name`, `sales_channel.currency.translation`.custom_fields AS `sales_channel.currency.translation.customFields`, `sales_channel.currency.translation`.created_at AS `sales_channel.currency.translation.createdAt`, `sales_channel.currency.translation`.updated_at AS `sales_channel.currency.translation.updatedAt`, `sales_channel.currency.translation`.currency_id AS `sales_channel.currency.translation.currencyId`, `sales_channel.currency.translation`.language_id AS `sales_channel.currency.translation.languageId` FROM `currency_translation` `sales_channel.currency.translation` WHERE `sales_channel.currency.translation`.language_id = ?) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation`.`currency_id` = `sales_channel.currency`.`id` WHERE `sales_channel`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.24 ms
(1.54%) 		1 
# base-context-factory::shipping-method::read
SELECT `shipping_method`.`id` AS `shipping_method.id`, `shipping_method`.`active` AS `shipping_method.active`, `shipping_method`.`position` AS `shipping_method.position`, `shipping_method`.`availability_rule_id` AS `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` AS `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` AS `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` AS `shipping_method.taxType`, `shipping_method`.`tax_id` AS `shipping_method.taxId`, `shipping_method.deliveryTime`.`id` AS `shipping_method.deliveryTime.id`, `shipping_method.deliveryTime`.`min` AS `shipping_method.deliveryTime.min`, `shipping_method.deliveryTime`.`max` AS `shipping_method.deliveryTime.max`, `shipping_method.deliveryTime`.`unit` AS `shipping_method.deliveryTime.unit`, `shipping_method.deliveryTime`.`created_at` AS `shipping_method.deliveryTime.createdAt`, `shipping_method.deliveryTime`.`updated_at` AS `shipping_method.deliveryTime.updatedAt`, `shipping_method.deliveryTime.translation.name`, COALESCE(`shipping_method.deliveryTime.translation.name`,`shipping_method.deliveryTime.translation.name`) AS `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.customFields`,`shipping_method.deliveryTime.translation.customFields`) AS `shipping_method.deliveryTime.customFields`, `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation.languageId`, `shipping_method.appShippingMethod`.`id` AS `shipping_method.appShippingMethod.id`, `shipping_method.appShippingMethod`.`app_name` AS `shipping_method.appShippingMethod.appName`, `shipping_method.appShippingMethod`.`identifier` AS `shipping_method.appShippingMethod.identifier`, `shipping_method.appShippingMethod`.`app_id` AS `shipping_method.appShippingMethod.appId`, `shipping_method.appShippingMethod`.`shipping_method_id` AS `shipping_method.appShippingMethod.shippingMethodId`, `shipping_method.appShippingMethod`.`original_media_id` AS `shipping_method.appShippingMethod.originalMediaId`, `shipping_method.appShippingMethod`.`created_at` AS `shipping_method.appShippingMethod.createdAt`, `shipping_method.appShippingMethod`.`updated_at` AS `shipping_method.appShippingMethod.updatedAt`, `shipping_method`.`technical_name` AS `shipping_method.technicalName`, `shipping_method`.`created_at` AS `shipping_method.createdAt`, `shipping_method`.`updated_at` AS `shipping_method.updatedAt`, `shipping_method.media`.`id` AS `shipping_method.media.id`, `shipping_method.media`.`user_id` AS `shipping_method.media.userId`, `shipping_method.media`.`media_folder_id` AS `shipping_method.media.mediaFolderId`, `shipping_method.media`.`mime_type` AS `shipping_method.media.mimeType`, `shipping_method.media`.`file_extension` AS `shipping_method.media.fileExtension`, `shipping_method.media`.`uploaded_at` AS `shipping_method.media.uploadedAt`, `shipping_method.media`.`file_name` AS `shipping_method.media.fileName`, `shipping_method.media`.`file_size` AS `shipping_method.media.fileSize`, `shipping_method.media`.`media_type` AS `shipping_method.media.mediaTypeRaw`, `shipping_method.media`.`meta_data` AS `shipping_method.media.metaData`, `shipping_method.media`.`config` AS `shipping_method.media.config`, `shipping_method.media`.`path` AS `shipping_method.media.path`, `shipping_method.media`.`private` AS `shipping_method.media.private`, `shipping_method.media`.`thumbnails_ro` AS `shipping_method.media.thumbnailsRo`, `shipping_method.media`.`created_at` AS `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` AS `shipping_method.media.updatedAt`, `shipping_method.media.translation.title`, COALESCE(`shipping_method.media.translation.title`,`shipping_method.media.translation.title`) AS `shipping_method.media.title`, `shipping_method.media.translation.alt`, COALESCE(`shipping_method.media.translation.alt`,`shipping_method.media.translation.alt`) AS `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, COALESCE(`shipping_method.media.translation.customFields`,`shipping_method.media.translation.customFields`) AS `shipping_method.media.customFields`, `shipping_method.media.translation.createdAt`, `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation.mediaId`, `shipping_method.media.translation.languageId`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.name`,`shipping_method.translation.name`) AS `shipping_method.name`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.description`,`shipping_method.translation.description`) AS `shipping_method.description`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.trackingUrl`,`shipping_method.translation.trackingUrl`) AS `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.customFields`,`shipping_method.translation.customFields`) AS `shipping_method.customFields`, `shipping_method.translation.createdAt`, `shipping_method.translation.updatedAt`, `shipping_method.translation.shippingMethodId`, `shipping_method.translation.languageId` FROM `shipping_method` LEFT JOIN (SELECT `shipping_method.translation`.shipping_method_id, `shipping_method.translation`.name AS `shipping_method.translation.name`, `shipping_method.translation`.description AS `shipping_method.translation.description`, `shipping_method.translation`.tracking_url AS `shipping_method.translation.trackingUrl`, `shipping_method.translation`.custom_fields AS `shipping_method.translation.customFields`, `shipping_method.translation`.created_at AS `shipping_method.translation.createdAt`, `shipping_method.translation`.updated_at AS `shipping_method.translation.updatedAt`, `shipping_method.translation`.shipping_method_id AS `shipping_method.translation.shippingMethodId`, `shipping_method.translation`.language_id AS `shipping_method.translation.languageId` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.language_id = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method`.`id` = `shipping_method.appShippingMethod`.`shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation`.delivery_time_id, `shipping_method.deliveryTime.translation`.name AS `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation`.custom_fields AS `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation`.created_at AS `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation`.updated_at AS `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation`.delivery_time_id AS `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation`.language_id AS `shipping_method.deliveryTime.translation.languageId` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation`.language_id = ?) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.media_id, `shipping_method.media.translation`.title AS `shipping_method.media.translation.title`, `shipping_method.media.translation`.alt AS `shipping_method.media.translation.alt`, `shipping_method.media.translation`.custom_fields AS `shipping_method.media.translation.customFields`, `shipping_method.media.translation`.created_at AS `shipping_method.media.translation.createdAt`, `shipping_method.media.translation`.updated_at AS `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation`.media_id AS `shipping_method.media.translation.mediaId`, `shipping_method.media.translation`.language_id AS `shipping_method.media.translation.languageId` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation`.language_id = ?) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ÇÑwÆzÚLµ§ÒÔñ4\x17Ó³"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.16 ms
(1.48%) 		1 
# base-context-factory::payment-method::read
SELECT `payment_method`.`id` AS `payment_method.id`, `payment_method`.`plugin_id` AS `payment_method.pluginId`, `payment_method`.`handler_identifier` AS `payment_method.handlerIdentifier`, `payment_method`.`position` AS `payment_method.position`, `payment_method`.`active` AS `payment_method.active`, `payment_method`.`after_order_enabled` AS `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` AS `payment_method.availabilityRuleId`, `payment_method`.`media_id` AS `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` AS `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` AS `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` AS `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` AS `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` AS `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` AS `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` AS `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` AS `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`recurring_url` AS `payment_method.appPaymentMethod.recurringUrl`, `payment_method.appPaymentMethod`.`app_id` AS `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` AS `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` AS `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` AS `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` AS `payment_method.appPaymentMethod.updatedAt`, `payment_method`.`technical_name` AS `payment_method.technicalName`, `payment_method`.`created_at` AS `payment_method.createdAt`, `payment_method`.`updated_at` AS `payment_method.updatedAt`, `payment_method.media`.`id` AS `payment_method.media.id`, `payment_method.media`.`user_id` AS `payment_method.media.userId`, `payment_method.media`.`media_folder_id` AS `payment_method.media.mediaFolderId`, `payment_method.media`.`mime_type` AS `payment_method.media.mimeType`, `payment_method.media`.`file_extension` AS `payment_method.media.fileExtension`, `payment_method.media`.`uploaded_at` AS `payment_method.media.uploadedAt`, `payment_method.media`.`file_name` AS `payment_method.media.fileName`, `payment_method.media`.`file_size` AS `payment_method.media.fileSize`, `payment_method.media`.`media_type` AS `payment_method.media.mediaTypeRaw`, `payment_method.media`.`meta_data` AS `payment_method.media.metaData`, `payment_method.media`.`config` AS `payment_method.media.config`, `payment_method.media`.`path` AS `payment_method.media.path`, `payment_method.media`.`private` AS `payment_method.media.private`, `payment_method.media`.`thumbnails_ro` AS `payment_method.media.thumbnailsRo`, `payment_method.media`.`created_at` AS `payment_method.media.createdAt`, `payment_method.media`.`updated_at` AS `payment_method.media.updatedAt`, `payment_method.media.translation.title`, COALESCE(`payment_method.media.translation.title`,`payment_method.media.translation.title`) AS `payment_method.media.title`, `payment_method.media.translation.alt`, COALESCE(`payment_method.media.translation.alt`,`payment_method.media.translation.alt`) AS `payment_method.media.alt`, `payment_method.media.translation.customFields`, COALESCE(`payment_method.media.translation.customFields`,`payment_method.media.translation.customFields`) AS `payment_method.media.customFields`, `payment_method.media.translation.createdAt`, `payment_method.media.translation.updatedAt`, `payment_method.media.translation.mediaId`, `payment_method.media.translation.languageId`, `payment_method.translation.name`, COALESCE(`payment_method.translation.name`,`payment_method.translation.name`) AS `payment_method.name`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableName`) AS `payment_method.distinguishableName`, `payment_method.translation.description`, COALESCE(`payment_method.translation.description`,`payment_method.translation.description`) AS `payment_method.description`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.customFields`,`payment_method.translation.customFields`) AS `payment_method.customFields`, `payment_method.translation.createdAt`, `payment_method.translation.updatedAt`, `payment_method.translation.paymentMethodId`, `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation`.payment_method_id, `payment_method.translation`.name AS `payment_method.translation.name`, `payment_method.translation`.distinguishable_name AS `payment_method.translation.distinguishableName`, `payment_method.translation`.description AS `payment_method.translation.description`, `payment_method.translation`.custom_fields AS `payment_method.translation.customFields`, `payment_method.translation`.created_at AS `payment_method.translation.createdAt`, `payment_method.translation`.updated_at AS `payment_method.translation.updatedAt`, `payment_method.translation`.payment_method_id AS `payment_method.translation.paymentMethodId`, `payment_method.translation`.language_id AS `payment_method.translation.languageId` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.language_id = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.media_id, `payment_method.media.translation`.title AS `payment_method.media.translation.title`, `payment_method.media.translation`.alt AS `payment_method.media.translation.alt`, `payment_method.media.translation`.custom_fields AS `payment_method.media.translation.customFields`, `payment_method.media.translation`.created_at AS `payment_method.media.translation.createdAt`, `payment_method.media.translation`.updated_at AS `payment_method.media.translation.updatedAt`, `payment_method.media.translation`.media_id AS `payment_method.media.translation.mediaId`, `payment_method.media.translation`.language_id AS `payment_method.media.translation.languageId` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation`.language_id = ?) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ˆ\x13ì¬_ºAŽ´?΀\v\x12ŒM"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.97 ms
(1.35%) 		5 
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
1.79 ms
(1.23%) 		1 
SELECT `sales_channel`.`id` AS `sales_channel.id`, `sales_channel`.`type_id` AS `sales_channel.typeId`, `sales_channel`.`language_id` AS `sales_channel.languageId`, `sales_channel`.`customer_group_id` AS `sales_channel.customerGroupId`, `sales_channel`.`currency_id` AS `sales_channel.currencyId`, `sales_channel`.`payment_method_id` AS `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` AS `sales_channel.shippingMethodId`, `sales_channel`.`country_id` AS `sales_channel.countryId`, `sales_channel`.`analytics_id` AS `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` AS `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` AS `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` AS `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` AS `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` AS `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` AS `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` AS `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` AS `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` AS `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` AS `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` AS `sales_channel.taxCalculationType`, `sales_channel`.`access_key` AS `sales_channel.accessKey`, `sales_channel`.`configuration` AS `sales_channel.configuration`, `sales_channel`.`active` AS `sales_channel.active`, `sales_channel`.`hreflang_active` AS `sales_channel.hreflangActive`, `sales_channel`.`maintenance` AS `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` AS `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` AS `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` AS `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` AS `sales_channel.homeCmsPageVersionId`, `sales_channel.analytics`.`id` AS `sales_channel.analytics.id`, `sales_channel.analytics`.`tracking_id` AS `sales_channel.analytics.trackingId`, `sales_channel.analytics`.`active` AS `sales_channel.analytics.active`, `sales_channel.analytics`.`track_orders` AS `sales_channel.analytics.trackOrders`, `sales_channel.analytics`.`anonymize_ip` AS `sales_channel.analytics.anonymizeIp`, `sales_channel.analytics`.`created_at` AS `sales_channel.analytics.createdAt`, `sales_channel.analytics`.`updated_at` AS `sales_channel.analytics.updatedAt`, `sales_channel`.`created_at` AS `sales_channel.createdAt`, `sales_channel`.`updated_at` AS `sales_channel.updatedAt`, (SELECT GROUP_CONCAT(HEX(`sales_channel.paymentMethods.mapping`.`payment_method_id`) SEPARATOR '||')
                  FROM `sales_channel_payment_method` `sales_channel.paymentMethods.mapping`
                  WHERE `sales_channel.paymentMethods.mapping`.`sales_channel_id` = `sales_channel`.`id` ) AS `sales_channel.paymentMethods.id_mapping`, `sales_channel.country`.`id` AS `sales_channel.country.id`, `sales_channel.country`.`iso` AS `sales_channel.country.iso`, `sales_channel.country`.`position` AS `sales_channel.country.position`, `sales_channel.country`.`active` AS `sales_channel.country.active`, `sales_channel.country`.`shipping_available` AS `sales_channel.country.shippingAvailable`, `sales_channel.country`.`iso3` AS `sales_channel.country.iso3`, `sales_channel.country`.`display_state_in_registration` AS `sales_channel.country.displayStateInRegistration`, `sales_channel.country`.`force_state_in_registration` AS `sales_channel.country.forceStateInRegistration`, `sales_channel.country`.`check_vat_id_pattern` AS `sales_channel.country.checkVatIdPattern`, `sales_channel.country`.`vat_id_required` AS `sales_channel.country.vatIdRequired`, `sales_channel.country`.`vat_id_pattern` AS `sales_channel.country.vatIdPattern`, `sales_channel.country`.`customer_tax` AS `sales_channel.country.customerTax`, `sales_channel.country`.`company_tax` AS `sales_channel.country.companyTax`, `sales_channel.country`.`postal_code_required` AS `sales_channel.country.postalCodeRequired`, `sales_channel.country`.`check_postal_code_pattern` AS `sales_channel.country.checkPostalCodePattern`, `sales_channel.country`.`check_advanced_postal_code_pattern` AS `sales_channel.country.checkAdvancedPostalCodePattern`, `sales_channel.country`.`advanced_postal_code_pattern` AS `sales_channel.country.advancedPostalCodePattern`, `sales_channel.country`.`default_postal_code_pattern` AS `sales_channel.country.defaultPostalCodePattern`, `sales_channel.country`.`created_at` AS `sales_channel.country.createdAt`, `sales_channel.country`.`updated_at` AS `sales_channel.country.updatedAt`, `sales_channel.country.translation.name`, COALESCE(`sales_channel.country.translation.name`,`sales_channel.country.translation.name`) AS `sales_channel.country.name`, `sales_channel.country.translation.addressFormat`, COALESCE(`sales_channel.country.translation.addressFormat`,`sales_channel.country.translation.addressFormat`) AS `sales_channel.country.addressFormat`, `sales_channel.country.translation.customFields`, COALESCE(`sales_channel.country.translation.customFields`,`sales_channel.country.translation.customFields`) AS `sales_channel.country.customFields`, `sales_channel.country.translation.createdAt`, `sales_channel.country.translation.updatedAt`, `sales_channel.country.translation.countryId`, `sales_channel.country.translation.languageId`, `sales_channel.language`.`id` AS `sales_channel.language.id`, `sales_channel.language`.`parent_id` AS `sales_channel.language.parentId`, `sales_channel.language`.`locale_id` AS `sales_channel.language.localeId`, `sales_channel.language`.`translation_code_id` AS `sales_channel.language.translationCodeId`, `sales_channel.language`.`name` AS `sales_channel.language.name`, `sales_channel.language`.`custom_fields` AS `sales_channel.language.customFields`, `sales_channel.language`.`created_at` AS `sales_channel.language.createdAt`, `sales_channel.language`.`updated_at` AS `sales_channel.language.updatedAt`, `sales_channel.language.locale`.`id` AS `sales_channel.language.locale.id`, `sales_channel.language.locale`.`code` AS `sales_channel.language.locale.code`, `sales_channel.language.locale`.`created_at` AS `sales_channel.language.locale.createdAt`, `sales_channel.language.locale`.`updated_at` AS `sales_channel.language.locale.updatedAt`, `sales_channel.language.locale.translation.name`, COALESCE(`sales_channel.language.locale.translation.name`,`sales_channel.language.locale.translation.name`) AS `sales_channel.language.locale.name`, `sales_channel.language.locale.translation.territory`, COALESCE(`sales_channel.language.locale.translation.territory`,`sales_channel.language.locale.translation.territory`) AS `sales_channel.language.locale.territory`, `sales_channel.language.locale.translation.customFields`, COALESCE(`sales_channel.language.locale.translation.customFields`,`sales_channel.language.locale.translation.customFields`) AS `sales_channel.language.locale.customFields`, `sales_channel.language.locale.translation.createdAt`, `sales_channel.language.locale.translation.updatedAt`, `sales_channel.language.locale.translation.localeId`, `sales_channel.language.locale.translation.languageId`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.name`,`sales_channel.translation.name`) AS `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) AS `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) AS `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) AS `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) AS `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) AS `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) AS `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) AS `sales_channel.customFields`, `sales_channel.translation.createdAt`, `sales_channel.translation.updatedAt`, `sales_channel.translation.salesChannelId`, `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name AS `sales_channel.translation.name`, `sales_channel.translation`.home_slot_config AS `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.home_enabled AS `sales_channel.translation.homeEnabled`, `sales_channel.translation`.home_name AS `sales_channel.translation.homeName`, `sales_channel.translation`.home_meta_title AS `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.home_meta_description AS `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.home_keywords AS `sales_channel.translation.homeKeywords`, `sales_channel.translation`.custom_fields AS `sales_channel.translation.customFields`, `sales_channel.translation`.created_at AS `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at AS `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id AS `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id AS `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.language_id = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel`.`analytics_id` = `sales_channel.analytics`.`id` LEFT JOIN `country` `sales_channel.country` ON `sales_channel`.`country_id` = `sales_channel.country`.`id` LEFT JOIN `language` `sales_channel.language` ON `sales_channel`.`language_id` = `sales_channel.language`.`id` LEFT JOIN (SELECT `sales_channel.country.translation`.country_id, `sales_channel.country.translation`.name AS `sales_channel.country.translation.name`, `sales_channel.country.translation`.address_format AS `sales_channel.country.translation.addressFormat`, `sales_channel.country.translation`.custom_fields AS `sales_channel.country.translation.customFields`, `sales_channel.country.translation`.created_at AS `sales_channel.country.translation.createdAt`, `sales_channel.country.translation`.updated_at AS `sales_channel.country.translation.updatedAt`, `sales_channel.country.translation`.country_id AS `sales_channel.country.translation.countryId`, `sales_channel.country.translation`.language_id AS `sales_channel.country.translation.languageId` FROM `country_translation` `sales_channel.country.translation` WHERE `sales_channel.country.translation`.language_id = ?) `sales_channel.country.country_translation` ON `sales_channel.country.country_translation`.`country_id` = `sales_channel.country`.`id` LEFT JOIN `locale` `sales_channel.language.locale` ON `sales_channel.language`.`locale_id` = `sales_channel.language.locale`.`id` LEFT JOIN (SELECT `sales_channel.language.locale.translation`.locale_id, `sales_channel.language.locale.translation`.name AS `sales_channel.language.locale.translation.name`, `sales_channel.language.locale.translation`.territory AS `sales_channel.language.locale.translation.territory`, `sales_channel.language.locale.translation`.custom_fields AS `sales_channel.language.locale.translation.customFields`, `sales_channel.language.locale.translation`.created_at AS `sales_channel.language.locale.translation.createdAt`, `sales_channel.language.locale.translation`.updated_at AS `sales_channel.language.locale.translation.updatedAt`, `sales_channel.language.locale.translation`.locale_id AS `sales_channel.language.locale.translation.localeId`, `sales_channel.language.locale.translation`.language_id AS `sales_channel.language.locale.translation.languageId` FROM `locale_translation` `sales_channel.language.locale.translation` WHERE `sales_channel.language.locale.translation`.language_id = ?) `sales_channel.language.locale.locale_translation` ON `sales_channel.language.locale.locale_translation`.`locale_id` = `sales_channel.language.locale`.`id` WHERE `sales_channel`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.67 ms
(1.15%) 		1 
# base-context-factory::country::read
SELECT `country`.`id` AS `country.id`, `country`.`iso` AS `country.iso`, `country`.`position` AS `country.position`, `country`.`active` AS `country.active`, `country`.`shipping_available` AS `country.shippingAvailable`, `country`.`iso3` AS `country.iso3`, `country`.`display_state_in_registration` AS `country.displayStateInRegistration`, `country`.`force_state_in_registration` AS `country.forceStateInRegistration`, `country`.`check_vat_id_pattern` AS `country.checkVatIdPattern`, `country`.`vat_id_required` AS `country.vatIdRequired`, `country`.`vat_id_pattern` AS `country.vatIdPattern`, `country`.`customer_tax` AS `country.customerTax`, `country`.`company_tax` AS `country.companyTax`, `country`.`postal_code_required` AS `country.postalCodeRequired`, `country`.`check_postal_code_pattern` AS `country.checkPostalCodePattern`, `country`.`check_advanced_postal_code_pattern` AS `country.checkAdvancedPostalCodePattern`, `country`.`advanced_postal_code_pattern` AS `country.advancedPostalCodePattern`, `country`.`default_postal_code_pattern` AS `country.defaultPostalCodePattern`, `country`.`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"³Rv™QôI\½3~Œh<sä"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.65 ms
(1.13%) 		1 
# base-context-factory::taxes::association::rules::read
SELECT `tax_rule`.`id` AS `tax_rule.id`, `tax_rule`.`tax_rule_type_id` AS `tax_rule.taxRuleTypeId`, `tax_rule`.`country_id` AS `tax_rule.countryId`, `tax_rule`.`tax_rate` AS `tax_rule.taxRate`, `tax_rule`.`data` AS `tax_rule.data`, `tax_rule`.`tax_id` AS `tax_rule.taxId`, `tax_rule`.`active_from` AS `tax_rule.activeFrom`, `tax_rule.type`.`id` AS `tax_rule.type.id`, `tax_rule.type`.`technical_name` AS `tax_rule.type.technicalName`, `tax_rule.type`.`position` AS `tax_rule.type.position`, `tax_rule.type`.`created_at` AS `tax_rule.type.createdAt`, `tax_rule.type`.`updated_at` AS `tax_rule.type.updatedAt`, `tax_rule.type.translation.typeName`, COALESCE(`tax_rule.type.translation.typeName`,`tax_rule.type.translation.typeName`) AS `tax_rule.type.typeName`, `tax_rule.type.translation.createdAt`, `tax_rule.type.translation.updatedAt`, `tax_rule.type.translation.taxRuleTypeId`, `tax_rule.type.translation.languageId`, `tax_rule`.`created_at` AS `tax_rule.createdAt`, `tax_rule`.`updated_at` AS `tax_rule.updatedAt` FROM `tax_rule` LEFT JOIN `tax_rule_type` `tax_rule.type` ON `tax_rule`.`tax_rule_type_id` = `tax_rule.type`.`id` LEFT JOIN (SELECT `tax_rule.type.translation`.tax_rule_type_id, `tax_rule.type.translation`.type_name AS `tax_rule.type.translation.typeName`, `tax_rule.type.translation`.created_at AS `tax_rule.type.translation.createdAt`, `tax_rule.type.translation`.updated_at AS `tax_rule.type.translation.updatedAt`, `tax_rule.type.translation`.tax_rule_type_id AS `tax_rule.type.translation.taxRuleTypeId`, `tax_rule.type.translation`.language_id AS `tax_rule.type.translation.languageId` FROM `tax_rule_type_translation` `tax_rule.type.translation` WHERE `tax_rule.type.translation`.language_id = ?) `tax_rule.type.tax_rule_type_translation` ON `tax_rule.type.tax_rule_type_translation`.`tax_rule_type_id` = `tax_rule.type`.`id` WHERE (`tax_rule`.`tax_id` IN (?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x05|Å\x18‹ÖIêŠ\x1A÷å\fíòÍ"
  b"\f©“àï…CÄ™5çFæw±`"
  b"""
    §1î²È\x1CFp¤\x7FÞ”sà\n
    
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
1.64 ms
(1.12%) 		1 
# theme-service::load-config::read
SELECT `theme`.`id` AS `theme.id`, `theme`.`technical_name` AS `theme.technicalName`, `theme`.`name` AS `theme.name`, `theme`.`author` AS `theme.author`, `theme`.`preview_media_id` AS `theme.previewMediaId`, `theme`.`parent_theme_id` AS `theme.parentThemeId`, `theme`.`theme_json` AS `theme.themeJson`, `theme`.`base_config` AS `theme.baseConfig`, `theme`.`config_values` AS `theme.configValues`, `theme`.`active` AS `theme.active`, `theme`.`created_at` AS `theme.createdAt`, `theme`.`updated_at` AS `theme.updatedAt`, `theme.translation.description`, COALESCE(`theme.translation.description`,`theme.translation.description`) AS `theme.description`, `theme.translation.labels`, COALESCE(`theme.translation.labels`,`theme.translation.labels`) AS `theme.labels`, `theme.translation.helpTexts`, COALESCE(`theme.translation.helpTexts`,`theme.translation.helpTexts`) AS `theme.helpTexts`, `theme.translation.customFields`, COALESCE(`theme.translation.customFields`,`theme.translation.customFields`) AS `theme.customFields`, `theme.translation.createdAt`, `theme.translation.updatedAt`, `theme.translation.themeId`, `theme.translation.languageId` FROM `theme` LEFT JOIN (SELECT `theme.translation`.theme_id, `theme.translation`.description AS `theme.translation.description`, `theme.translation`.labels AS `theme.translation.labels`, `theme.translation`.help_texts AS `theme.translation.helpTexts`, `theme.translation`.custom_fields AS `theme.translation.customFields`, `theme.translation`.created_at AS `theme.translation.createdAt`, `theme.translation`.updated_at AS `theme.translation.updatedAt`, `theme.translation`.theme_id AS `theme.translation.themeId`, `theme.translation`.language_id AS `theme.translation.languageId` FROM `theme_translation` `theme.translation` WHERE `theme.translation`.language_id = ?) `theme.theme_translation` ON `theme.theme_translation`.`theme_id` = `theme`.`id`
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.58 ms
(1.09%) 		1 
# generic-page::shipping-methods::read
SELECT `shipping_method`.`id` AS `shipping_method.id`, `shipping_method`.`active` AS `shipping_method.active`, `shipping_method`.`position` AS `shipping_method.position`, `shipping_method`.`availability_rule_id` AS `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` AS `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` AS `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` AS `shipping_method.taxType`, `shipping_method`.`tax_id` AS `shipping_method.taxId`, `shipping_method.deliveryTime`.`id` AS `shipping_method.deliveryTime.id`, `shipping_method.deliveryTime`.`min` AS `shipping_method.deliveryTime.min`, `shipping_method.deliveryTime`.`max` AS `shipping_method.deliveryTime.max`, `shipping_method.deliveryTime`.`unit` AS `shipping_method.deliveryTime.unit`, `shipping_method.deliveryTime`.`created_at` AS `shipping_method.deliveryTime.createdAt`, `shipping_method.deliveryTime`.`updated_at` AS `shipping_method.deliveryTime.updatedAt`, `shipping_method.deliveryTime.translation.name`, COALESCE(`shipping_method.deliveryTime.translation.name`,`shipping_method.deliveryTime.translation.name`) AS `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.customFields`,`shipping_method.deliveryTime.translation.customFields`) AS `shipping_method.deliveryTime.customFields`, `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation.languageId`, `shipping_method.appShippingMethod`.`id` AS `shipping_method.appShippingMethod.id`, `shipping_method.appShippingMethod`.`app_name` AS `shipping_method.appShippingMethod.appName`, `shipping_method.appShippingMethod`.`identifier` AS `shipping_method.appShippingMethod.identifier`, `shipping_method.appShippingMethod`.`app_id` AS `shipping_method.appShippingMethod.appId`, `shipping_method.appShippingMethod`.`shipping_method_id` AS `shipping_method.appShippingMethod.shippingMethodId`, `shipping_method.appShippingMethod`.`original_media_id` AS `shipping_method.appShippingMethod.originalMediaId`, `shipping_method.appShippingMethod`.`created_at` AS `shipping_method.appShippingMethod.createdAt`, `shipping_method.appShippingMethod`.`updated_at` AS `shipping_method.appShippingMethod.updatedAt`, `shipping_method`.`technical_name` AS `shipping_method.technicalName`, `shipping_method`.`created_at` AS `shipping_method.createdAt`, `shipping_method`.`updated_at` AS `shipping_method.updatedAt`, `shipping_method.media`.`id` AS `shipping_method.media.id`, `shipping_method.media`.`user_id` AS `shipping_method.media.userId`, `shipping_method.media`.`media_folder_id` AS `shipping_method.media.mediaFolderId`, `shipping_method.media`.`mime_type` AS `shipping_method.media.mimeType`, `shipping_method.media`.`file_extension` AS `shipping_method.media.fileExtension`, `shipping_method.media`.`uploaded_at` AS `shipping_method.media.uploadedAt`, `shipping_method.media`.`file_name` AS `shipping_method.media.fileName`, `shipping_method.media`.`file_size` AS `shipping_method.media.fileSize`, `shipping_method.media`.`media_type` AS `shipping_method.media.mediaTypeRaw`, `shipping_method.media`.`meta_data` AS `shipping_method.media.metaData`, `shipping_method.media`.`config` AS `shipping_method.media.config`, `shipping_method.media`.`path` AS `shipping_method.media.path`, `shipping_method.media`.`private` AS `shipping_method.media.private`, `shipping_method.media`.`thumbnails_ro` AS `shipping_method.media.thumbnailsRo`, `shipping_method.media`.`created_at` AS `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` AS `shipping_method.media.updatedAt`, `shipping_method.media.translation.title`, COALESCE(`shipping_method.media.translation.title`,`shipping_method.media.translation.title`) AS `shipping_method.media.title`, `shipping_method.media.translation.alt`, COALESCE(`shipping_method.media.translation.alt`,`shipping_method.media.translation.alt`) AS `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, COALESCE(`shipping_method.media.translation.customFields`,`shipping_method.media.translation.customFields`) AS `shipping_method.media.customFields`, `shipping_method.media.translation.createdAt`, `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation.mediaId`, `shipping_method.media.translation.languageId`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.name`,`shipping_method.translation.name`) AS `shipping_method.name`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.description`,`shipping_method.translation.description`) AS `shipping_method.description`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.trackingUrl`,`shipping_method.translation.trackingUrl`) AS `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.customFields`,`shipping_method.translation.customFields`) AS `shipping_method.customFields`, `shipping_method.translation.createdAt`, `shipping_method.translation.updatedAt`, `shipping_method.translation.shippingMethodId`, `shipping_method.translation.languageId` FROM `shipping_method` LEFT JOIN (SELECT `shipping_method.translation`.shipping_method_id, `shipping_method.translation`.name AS `shipping_method.translation.name`, `shipping_method.translation`.description AS `shipping_method.translation.description`, `shipping_method.translation`.tracking_url AS `shipping_method.translation.trackingUrl`, `shipping_method.translation`.custom_fields AS `shipping_method.translation.customFields`, `shipping_method.translation`.created_at AS `shipping_method.translation.createdAt`, `shipping_method.translation`.updated_at AS `shipping_method.translation.updatedAt`, `shipping_method.translation`.shipping_method_id AS `shipping_method.translation.shippingMethodId`, `shipping_method.translation`.language_id AS `shipping_method.translation.languageId` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.language_id = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method`.`id` = `shipping_method.appShippingMethod`.`shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation`.delivery_time_id, `shipping_method.deliveryTime.translation`.name AS `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation`.custom_fields AS `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation`.created_at AS `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation`.updated_at AS `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation`.delivery_time_id AS `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation`.language_id AS `shipping_method.deliveryTime.translation.languageId` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation`.language_id = ?) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.media_id, `shipping_method.media.translation`.title AS `shipping_method.media.translation.title`, `shipping_method.media.translation`.alt AS `shipping_method.media.translation.alt`, `shipping_method.media.translation`.custom_fields AS `shipping_method.media.translation.customFields`, `shipping_method.media.translation`.created_at AS `shipping_method.media.translation.createdAt`, `shipping_method.media.translation`.updated_at AS `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation`.media_id AS `shipping_method.media.translation.mediaId`, `shipping_method.media.translation`.language_id AS `shipping_method.media.translation.languageId` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation`.language_id = ?) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x15\x05+é.wC¨º3\x02îxó“X"
  b"_\x08`Zç`Hi¥÷%/v%mÕ"
  b"!ã >´1JÈ”ÊõcG>b\x11"
  b"-\x03┼Ne1OÌÅ4åïrÛ_\x02"
  b"°¨W\t┐!D─ëtüùù»\x03["
  b"]Ô±VðÙ@CìKOÔV\x1D®®"
  b"\x16”,\x06Ê.LU¿\x19\x08ïýá‹["
  b"ÇÑwÆzÚLµ§ÒÔñ4\x17Ó³"
  b"""
    Y€v“.ÆFZ¤\n
    èÆ gÀŸ
    """
  b"UŽ&»%—Cà‘X\x1DùÂj§ï"
  b"õš½CéœC@‹úîD®ì´­"
  b"¶À├ü╣ÍB╬Ég'├ÞSèý"
  b"\@/╬ª\x12N¦éÙA3óØþc"
  b"˜³AÒù…L‡¢ºµ¿M›°\x15"
  b"ü\x12\x1Fb3×KGéÐ╚à¨e┤j"
  b"AÎ8mmCK"ŒÖ÷¾v\x7F\x10î"
  b"é\x07(‹éÓF7–\x1A\x07òÂQ\x13u"
  b"È─üE;$Mµî\x7F▒lƒÈßâ"
  b"x\x0Fµ\x1Cs¹IH¸X©Ý9UÔ”"
  b"¯;>•·YHP¬\x11\x1D?\x15+\vï"
  b"æß—O˜¢KKºç}ôë!G½"
  b"£ù1§§JG‗Ø\x18]ðMs\x05u"
  b"Œ1—ùT`Ky±Žâè\x1E1±\x04"
  b"3¡\x07~ôÏB{³y\x16ÑQ›ãf"
  b"†ùr¥-ŠNg¨¼ÛyÔC ù"
  b"óWŽº7\x0FJ£–;%§ÆGo‡"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.47 ms
(1.01%) 		1 
SELECT `rule`.`id` AS `rule.id`, `rule`.`name` AS `rule.name`, `rule`.`priority` AS `rule.priority`, `rule`.`description` AS `rule.description`, `rule`.`payload` AS `rule.payload`, `rule`.`invalid` AS `rule.invalid`, `rule`.`areas` AS `rule.areas`, `rule`.`custom_fields` AS `rule.customFields`, `rule`.`module_types` AS `rule.moduleTypes`, `rule`.`created_at` AS `rule.createdAt`, `rule`.`updated_at` AS `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x15¨░5þRJïØ\x19ã\x1CÚ'[Á"
  b"Ve¬k—ª@O§\x1CÝ—dö2Ò"
  b"ù\x00\x05³æüCÃÆIyìà;Øð"
  b"Ø\r²LmâGc£\x1C/u¨ãj·"
  b"1n'ù¹\x07@õ•\x12õ\x07„Vìà"
  b"ª&x>b\x11Fz™aª†0|T&"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.45 ms
(1.00%) 		2 
SELECT LOWER(HEX(`category`.`parent_id`)) AS `category-ids.key`, COUNT(`category`.`id`) AS `category-ids.count`, COUNT(DISTINCT `category`.`id`) AS `visible-children-count` FROM `category` WHERE (`category`.`version_id` = ?) AND ((`category`.`path` LIKE ? AND `category`.`level` = ? AND `category`.`active` = ? AND `category`.`visible` = ?)) GROUP BY `category`.`parent_id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  "%|647b732a5fdf4c1b9b721d904663af73|%"
  6
  true
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
1.34 ms
(0.92%) 		1 
# theme-service::resolve-media::read
SELECT `media`.`id` AS `media.id`, `media`.`user_id` AS `media.userId`, `media`.`media_folder_id` AS `media.mediaFolderId`, `media`.`mime_type` AS `media.mimeType`, `media`.`file_extension` AS `media.fileExtension`, `media`.`uploaded_at` AS `media.uploadedAt`, `media`.`file_name` AS `media.fileName`, `media`.`file_size` AS `media.fileSize`, `media`.`media_type` AS `media.mediaTypeRaw`, `media`.`meta_data` AS `media.metaData`, `media`.`config` AS `media.config`, `media`.`path` AS `media.path`, `media`.`private` AS `media.private`, `media`.`thumbnails_ro` AS `media.thumbnailsRo`, `media`.`created_at` AS `media.createdAt`, `media`.`updated_at` AS `media.updatedAt`, `media.translation.title`, COALESCE(`media.translation.title`,`media.translation.title`) AS `media.title`, `media.translation.alt`, COALESCE(`media.translation.alt`,`media.translation.alt`) AS `media.alt`, `media.translation.customFields`, COALESCE(`media.translation.customFields`,`media.translation.customFields`) AS `media.customFields`, `media.translation.createdAt`, `media.translation.updatedAt`, `media.translation.mediaId`, `media.translation.languageId` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.media_id, `media.translation`.title AS `media.translation.title`, `media.translation`.alt AS `media.translation.alt`, `media.translation`.custom_fields AS `media.translation.customFields`, `media.translation`.created_at AS `media.translation.createdAt`, `media.translation`.updated_at AS `media.translation.updatedAt`, `media.translation`.media_id AS `media.translation.mediaId`, `media.translation`.language_id AS `media.translation.languageId` FROM `media_translation` `media.translation` WHERE `media.translation`.language_id = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  false
  true
  "product_download"
  b"f╔¼┤░}Iíùìà┼Ý\f=³"
  b"/\x10n`ÍÍO\x11É»╗!5ÂÜ─"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.32 ms
(0.91%) 		1 
# context-factory::base-context

        SELECT
          sales_channel.id AS sales_channel_id,
          sales_channel.language_id AS sales_channel_default_language_id,
          sales_channel.currency_id AS sales_channel_currency_id,
          currency.factor AS sales_channel_currency_factor,
          GROUP_CONCAT(LOWER(HEX(sales_channel_language.language_id))) AS sales_channel_language_ids
        FROM sales_channel
            INNER JOIN currency
                ON sales_channel.currency_id = currency.id
            LEFT JOIN sales_channel_language
                ON sales_channel_language.sales_channel_id = sales_channel.id
        WHERE sales_channel.id = ?
        GROUP BY sales_channel.id, sales_channel.language_id, sales_channel.currency_id, currency.factor
Parameters: 
[
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.29 ms
(0.88%) 		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`.`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"\x03‹ØãQmF\x1Aƒ|\x1F\x1C;ÅßV"
  b"""
    \n
    ߤhKÎHº‘f^x˜o„Ð
    """
  b"\x12rlƒ,£A$š\x06F\x18—ïÛ\x06"
  b"\x16€œwöVB-”2\x00\¤L˜\t"
  b"\x1C\x14G>â¢CØšBäÎhZŽP"
  b"+~ŠS\x10IN<“àU™’\x1E»Î"
  b"5\kû▀\x01Mуï\x171eºÌÅ"
  b"6¦\x12Ò¹2EaúN\x06Å\x16%B\x00"
  b"""
    ?D¢y6wM\x16ªkg\n
    8¦q\x04
    """
  b"H\tÍåŠÂ@¹®ã¹š£\x02Ò\x07"
  b"[ü¬\x0Ev╣K▒ÖO═4"=+\r"
  b"düqËr\x14@JÉ[õÊ¥\t¼¨"
  b"j\x1D½\x10t[G¢€Aγ©úa0"
  b"zñc;‹ùK™—0¯Î"u\x04\x19"
  b"|¨¾,õ¢C\x03›\x08¾TE\x13–("
  b"ŠžQݧEKs©ˆ‚©B·8L"
  b"¤œ‰¦ŒJO%™¡e\võ’Þü"
  b"­/¬[:ÂD~µÖxÿ\x04Gi1"
  b"³Rv™QôI\½3~Œh<sä"
  b"»°2Û­\x05F`«Y\x11·\x00\x13£”"
  b"¼'M\x11úò@\x02˜|²ÀóñTw"
  b"Øñ!³«H‚‹F•W\rkîâ"
  b"Ã¥1‡U=Gƒ¨P1…ƒâ\tð"
  b"┼Ã└‗█&H7ïóüE1è┘\x13"
  b"ת\x02mσ@½‚³ÄMd隆"
  b"""
    ü^jµv¢O‘«ë\x08=)\n
    ¦-
    """
  b"ýÐÎP«šB9”÷ùËî\x19—\x07"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.18 ms
(0.81%) 		1 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
  "5fzwMt6foKc0dpfO48Y6BCblsazTTUyM"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.10 ms
(0.76%) 		1 
# base-context-factory::customer-group::read
SELECT `customer_group`.`id` AS `customer_group.id`, `customer_group`.`display_gross` AS `customer_group.displayGross`, `customer_group`.`registration_active` AS `customer_group.registrationActive`, `customer_group`.`created_at` AS `customer_group.createdAt`, `customer_group`.`updated_at` AS `customer_group.updatedAt`, `customer_group.translation.name`, COALESCE(`customer_group.translation.name`,`customer_group.translation.name`) AS `customer_group.name`, `customer_group.translation.registrationTitle`, COALESCE(`customer_group.translation.registrationTitle`,`customer_group.translation.registrationTitle`) AS `customer_group.registrationTitle`, `customer_group.translation.registrationIntroduction`, COALESCE(`customer_group.translation.registrationIntroduction`,`customer_group.translation.registrationIntroduction`) AS `customer_group.registrationIntroduction`, `customer_group.translation.registrationOnlyCompanyRegistration`, COALESCE(`customer_group.translation.registrationOnlyCompanyRegistration`,`customer_group.translation.registrationOnlyCompanyRegistration`) AS `customer_group.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationSeoMetaDescription`, COALESCE(`customer_group.translation.registrationSeoMetaDescription`,`customer_group.translation.registrationSeoMetaDescription`) AS `customer_group.registrationSeoMetaDescription`, `customer_group.translation.customFields`, COALESCE(`customer_group.translation.customFields`,`customer_group.translation.customFields`) AS `customer_group.customFields`, `customer_group.translation.createdAt`, `customer_group.translation.updatedAt`, `customer_group.translation.customerGroupId`, `customer_group.translation.languageId` FROM `customer_group` LEFT JOIN (SELECT `customer_group.translation`.customer_group_id, `customer_group.translation`.name AS `customer_group.translation.name`, `customer_group.translation`.registration_title AS `customer_group.translation.registrationTitle`, `customer_group.translation`.registration_introduction AS `customer_group.translation.registrationIntroduction`, `customer_group.translation`.registration_only_company_registration AS `customer_group.translation.registrationOnlyCompanyRegistration`, `customer_group.translation`.registration_seo_meta_description AS `customer_group.translation.registrationSeoMetaDescription`, `customer_group.translation`.custom_fields AS `customer_group.translation.customFields`, `customer_group.translation`.created_at AS `customer_group.translation.createdAt`, `customer_group.translation`.updated_at AS `customer_group.translation.updatedAt`, `customer_group.translation`.customer_group_id AS `customer_group.translation.customerGroupId`, `customer_group.translation`.language_id AS `customer_group.translation.languageId` FROM `customer_group_translation` `customer_group.translation` WHERE `customer_group.translation`.language_id = ?) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation`.`customer_group_id` = `customer_group`.`id` WHERE `customer_group`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"}ïŽ\x0Fg2OåŽO0†7õ‚º"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.10 ms
(0.76%) 		3 
SELECT `base_class` AS `baseClass`, `author`
                FROM `plugin`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.06 ms
(0.73%) 		1 
SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.00 ms
(0.69%) 		1 
# generic-page::shipping-methods::search-ids
SELECT `shipping_method`.`id` FROM `shipping_method` LEFT JOIN `sales_channel_shipping_method` `shipping_method.salesChannels.mapping` ON `shipping_method`.`id` = `shipping_method.salesChannels.mapping`.`shipping_method_id`  LEFT JOIN (SELECT `shipping_method.translation`.shipping_method_id, `shipping_method.translation`.name AS `shipping_method.translation.name`, `shipping_method.translation`.description AS `shipping_method.translation.description`, `shipping_method.translation`.tracking_url AS `shipping_method.translation.trackingUrl`, `shipping_method.translation`.custom_fields AS `shipping_method.translation.customFields`, `shipping_method.translation`.created_at AS `shipping_method.translation.createdAt`, `shipping_method.translation`.updated_at AS `shipping_method.translation.updatedAt`, `shipping_method.translation`.shipping_method_id AS `shipping_method.translation.shippingMethodId`, `shipping_method.translation`.language_id AS `shipping_method.translation.languageId` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.language_id = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `sales_channel` `shipping_method.salesChannels` ON `shipping_method.salesChannels.mapping`.`sales_channel_id` = `shipping_method.salesChannels`.`id`  WHERE (`shipping_method`.`active` = ? AND `shipping_method.salesChannels`.`id` = ?) GROUP BY `shipping_method`.`id` ORDER BY MIN(`shipping_method`.`position`) ASC, MIN(COALESCE(`shipping_method.translation.name`)) ASC
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.99 ms
(0.68%) 		1 
# header::navigation::read
SELECT `category`.`id` AS `category.id`, `category`.`version_id` AS `category.versionId`, `category`.`parent_id` AS `category.parentId`, `category`.`parent_version_id` AS `category.parentVersionId`, `category`.`after_category_id` AS `category.afterCategoryId`, `category`.`after_category_version_id` AS `category.afterCategoryVersionId`, `category`.`media_id` AS `category.mediaId`, `category`.`display_nested_products` AS `category.displayNestedProducts`, `category`.`auto_increment` AS `category.autoIncrement`, `category`.`level` AS `category.level`, `category`.`path` AS `category.path`, `category`.`child_count` AS `category.childCount`, `category`.`type` AS `category.type`, `category`.`product_assignment_type` AS `category.productAssignmentType`, `category`.`visible` AS `category.visible`, `category`.`active` AS `category.active`, `category`.`cms_page_id` AS `category.cmsPageId`, `category`.`cms_page_version_id` AS `category.cmsPageVersionId`, `category`.`product_stream_id` AS `category.productStreamId`, `category`.`custom_entity_type_id` AS `category.customEntityTypeId`, `category`.`created_at` AS `category.createdAt`, `category`.`updated_at` AS `category.updatedAt`, `category.media`.`id` AS `category.media.id`, `category.media`.`user_id` AS `category.media.userId`, `category.media`.`media_folder_id` AS `category.media.mediaFolderId`, `category.media`.`mime_type` AS `category.media.mimeType`, `category.media`.`file_extension` AS `category.media.fileExtension`, `category.media`.`uploaded_at` AS `category.media.uploadedAt`, `category.media`.`file_name` AS `category.media.fileName`, `category.media`.`file_size` AS `category.media.fileSize`, `category.media`.`media_type` AS `category.media.mediaTypeRaw`, `category.media`.`meta_data` AS `category.media.metaData`, `category.media`.`config` AS `category.media.config`, `category.media`.`path` AS `category.media.path`, `category.media`.`private` AS `category.media.private`, `category.media`.`thumbnails_ro` AS `category.media.thumbnailsRo`, `category.media`.`created_at` AS `category.media.createdAt`, `category.media`.`updated_at` AS `category.media.updatedAt`, `category.media.translation.title`, COALESCE(`category.media.translation.title`,`category.media.translation.title`) AS `category.media.title`, `category.media.translation.alt`, COALESCE(`category.media.translation.alt`,`category.media.translation.alt`) AS `category.media.alt`, `category.media.translation.customFields`, COALESCE(`category.media.translation.customFields`,`category.media.translation.customFields`) AS `category.media.customFields`, `category.media.translation.createdAt`, `category.media.translation.updatedAt`, `category.media.translation.mediaId`, `category.media.translation.languageId`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) AS `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) AS `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) AS `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) AS `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) AS `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) AS `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) AS `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) AS `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) AS `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) AS `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) AS `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) AS `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name AS `category.translation.name`, `category.translation`.breadcrumb AS `category.translation.breadcrumb`, `category.translation`.slot_config AS `category.translation.slotConfig`, `category.translation`.link_type AS `category.translation.linkType`, `category.translation`.internal_link AS `category.translation.internalLink`, `category.translation`.external_link AS `category.translation.externalLink`, `category.translation`.link_new_tab AS `category.translation.linkNewTab`, `category.translation`.description AS `category.translation.description`, `category.translation`.meta_title AS `category.translation.metaTitle`, `category.translation`.meta_description AS `category.translation.metaDescription`, `category.translation`.keywords AS `category.translation.keywords`, `category.translation`.custom_fields AS `category.translation.customFields`, `category.translation`.created_at AS `category.translation.createdAt`, `category.translation`.updated_at AS `category.translation.updatedAt`, `category.translation`.category_id AS `category.translation.categoryId`, `category.translation`.language_id AS `category.translation.languageId`, `category.translation`.category_version_id AS `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title AS `category.media.translation.title`, `category.media.translation`.alt AS `category.media.translation.alt`, `category.media.translation`.custom_fields AS `category.media.translation.customFields`, `category.media.translation`.created_at AS `category.media.translation.createdAt`, `category.media.translation`.updated_at AS `category.media.translation.updatedAt`, `category.media.translation`.media_id AS `category.media.translation.mediaId`, `category.media.translation`.language_id AS `category.media.translation.languageId` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.language_id = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"d{s*_▀L\eør\x1DÉFc»s"
  b"""
    Eö\x13ö@\x18KÚ—lÁ\n
    ^w's
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.94 ms
(0.64%) 		1 
# base-context-factory::currency::read
SELECT `currency`.`id` AS `currency.id`, `currency`.`factor` AS `currency.factor`, `currency`.`symbol` AS `currency.symbol`, `currency`.`iso_code` AS `currency.isoCode`, `currency`.`position` AS `currency.position`, `currency`.`tax_free_from` AS `currency.taxFreeFrom`, `currency`.`item_rounding` AS `currency.itemRounding`, `currency`.`total_rounding` AS `currency.totalRounding`, `currency`.`created_at` AS `currency.createdAt`, `currency`.`updated_at` AS `currency.updatedAt`, `currency.translation.shortName`, COALESCE(`currency.translation.shortName`,`currency.translation.shortName`) AS `currency.shortName`, `currency.translation.name`, COALESCE(`currency.translation.name`,`currency.translation.name`) AS `currency.name`, `currency.translation.customFields`, COALESCE(`currency.translation.customFields`,`currency.translation.customFields`) AS `currency.customFields`, `currency.translation.createdAt`, `currency.translation.updatedAt`, `currency.translation.currencyId`, `currency.translation.languageId` FROM `currency` LEFT JOIN (SELECT `currency.translation`.currency_id, `currency.translation`.short_name AS `currency.translation.shortName`, `currency.translation`.name AS `currency.translation.name`, `currency.translation`.custom_fields AS `currency.translation.customFields`, `currency.translation`.created_at AS `currency.translation.createdAt`, `currency.translation`.updated_at AS `currency.translation.updatedAt`, `currency.translation`.currency_id AS `currency.translation.currencyId`, `currency.translation`.language_id AS `currency.translation.languageId` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.language_id = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.92 ms
(0.63%) 		2 
# navigation-route::meta-information
            SELECT LOWER(HEX(`id`)), `path`, `level`
            FROM `category`
            WHERE `id` = ? OR `parent_id` = ? OR `id` = ?
Parameters: 
[
  b"d{s*_▀L\eør\x1DÉFc»s"
  b"d{s*_▀L\eør\x1DÉFc»s"
  b"d{s*_▀L\eør\x1DÉFc»s"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.92 ms
(0.63%) 		1 
# base-context-factory::sales-channel::association::domains::read
SELECT `sales_channel_domain`.`id` AS `sales_channel_domain.id`, `sales_channel_domain`.`url` AS `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` AS `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` AS `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` AS `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` AS `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`hreflang_use_only_locale` AS `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` AS `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` AS `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` AS `sales_channel_domain.updatedAt` FROM `sales_channel_domain` WHERE (`sales_channel_domain`.`sales_channel_id` IN (?))
Parameters: 
[
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.90 ms
(0.62%) 		1 
# header::currencies::search-ids
SELECT `currency`.`id` FROM `currency` LEFT JOIN `sales_channel_currency` `currency.salesChannels.mapping` ON `currency`.`id` = `currency.salesChannels.mapping`.`currency_id`  LEFT JOIN `sales_channel` `currency.salesChannels` ON `currency.salesChannels.mapping`.`sales_channel_id` = `currency.salesChannels`.`id`  WHERE (`currency.salesChannels`.`id` = ?) GROUP BY `currency`.`id`
Parameters: 
[
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.89 ms
(0.61%) 		1 
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id = ? OR system_config.sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters: 
[
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.89 ms
(0.61%) 		1 
# generic-page::payment-methods::read
SELECT `payment_method`.`id` AS `payment_method.id`, `payment_method`.`plugin_id` AS `payment_method.pluginId`, `payment_method`.`handler_identifier` AS `payment_method.handlerIdentifier`, `payment_method`.`position` AS `payment_method.position`, `payment_method`.`active` AS `payment_method.active`, `payment_method`.`after_order_enabled` AS `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` AS `payment_method.availabilityRuleId`, `payment_method`.`media_id` AS `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` AS `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` AS `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` AS `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` AS `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` AS `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` AS `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` AS `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` AS `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`recurring_url` AS `payment_method.appPaymentMethod.recurringUrl`, `payment_method.appPaymentMethod`.`app_id` AS `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` AS `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` AS `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` AS `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` AS `payment_method.appPaymentMethod.updatedAt`, `payment_method`.`technical_name` AS `payment_method.technicalName`, `payment_method`.`created_at` AS `payment_method.createdAt`, `payment_method`.`updated_at` AS `payment_method.updatedAt`, `payment_method.media`.`id` AS `payment_method.media.id`, `payment_method.media`.`user_id` AS `payment_method.media.userId`, `payment_method.media`.`media_folder_id` AS `payment_method.media.mediaFolderId`, `payment_method.media`.`mime_type` AS `payment_method.media.mimeType`, `payment_method.media`.`file_extension` AS `payment_method.media.fileExtension`, `payment_method.media`.`uploaded_at` AS `payment_method.media.uploadedAt`, `payment_method.media`.`file_name` AS `payment_method.media.fileName`, `payment_method.media`.`file_size` AS `payment_method.media.fileSize`, `payment_method.media`.`media_type` AS `payment_method.media.mediaTypeRaw`, `payment_method.media`.`meta_data` AS `payment_method.media.metaData`, `payment_method.media`.`config` AS `payment_method.media.config`, `payment_method.media`.`path` AS `payment_method.media.path`, `payment_method.media`.`private` AS `payment_method.media.private`, `payment_method.media`.`thumbnails_ro` AS `payment_method.media.thumbnailsRo`, `payment_method.media`.`created_at` AS `payment_method.media.createdAt`, `payment_method.media`.`updated_at` AS `payment_method.media.updatedAt`, `payment_method.media.translation.title`, COALESCE(`payment_method.media.translation.title`,`payment_method.media.translation.title`) AS `payment_method.media.title`, `payment_method.media.translation.alt`, COALESCE(`payment_method.media.translation.alt`,`payment_method.media.translation.alt`) AS `payment_method.media.alt`, `payment_method.media.translation.customFields`, COALESCE(`payment_method.media.translation.customFields`,`payment_method.media.translation.customFields`) AS `payment_method.media.customFields`, `payment_method.media.translation.createdAt`, `payment_method.media.translation.updatedAt`, `payment_method.media.translation.mediaId`, `payment_method.media.translation.languageId`, `payment_method.translation.name`, COALESCE(`payment_method.translation.name`,`payment_method.translation.name`) AS `payment_method.name`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableName`) AS `payment_method.distinguishableName`, `payment_method.translation.description`, COALESCE(`payment_method.translation.description`,`payment_method.translation.description`) AS `payment_method.description`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.customFields`,`payment_method.translation.customFields`) AS `payment_method.customFields`, `payment_method.translation.createdAt`, `payment_method.translation.updatedAt`, `payment_method.translation.paymentMethodId`, `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation`.payment_method_id, `payment_method.translation`.name AS `payment_method.translation.name`, `payment_method.translation`.distinguishable_name AS `payment_method.translation.distinguishableName`, `payment_method.translation`.description AS `payment_method.translation.description`, `payment_method.translation`.custom_fields AS `payment_method.translation.customFields`, `payment_method.translation`.created_at AS `payment_method.translation.createdAt`, `payment_method.translation`.updated_at AS `payment_method.translation.updatedAt`, `payment_method.translation`.payment_method_id AS `payment_method.translation.paymentMethodId`, `payment_method.translation`.language_id AS `payment_method.translation.languageId` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.language_id = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.media_id, `payment_method.media.translation`.title AS `payment_method.media.translation.title`, `payment_method.media.translation`.alt AS `payment_method.media.translation.alt`, `payment_method.media.translation`.custom_fields AS `payment_method.media.translation.customFields`, `payment_method.media.translation`.created_at AS `payment_method.media.translation.createdAt`, `payment_method.media.translation`.updated_at AS `payment_method.media.translation.updatedAt`, `payment_method.media.translation`.media_id AS `payment_method.media.translation.mediaId`, `payment_method.media.translation`.language_id AS `payment_method.media.translation.languageId` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation`.language_id = ?) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ˆ\x13ì¬_ºAŽ´?΀\v\x12ŒM"
  b"ébçk´6Jü£¬À\všhµÙ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.87 ms
(0.60%) 		1 
SELECT `payment_method`.`id` AS `payment_method.id`, `payment_method`.`plugin_id` AS `payment_method.pluginId`, `payment_method`.`handler_identifier` AS `payment_method.handlerIdentifier`, `payment_method`.`position` AS `payment_method.position`, `payment_method`.`active` AS `payment_method.active`, `payment_method`.`after_order_enabled` AS `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` AS `payment_method.availabilityRuleId`, `payment_method`.`media_id` AS `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` AS `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` AS `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` AS `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` AS `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` AS `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` AS `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` AS `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` AS `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`recurring_url` AS `payment_method.appPaymentMethod.recurringUrl`, `payment_method.appPaymentMethod`.`app_id` AS `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` AS `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` AS `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` AS `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` AS `payment_method.appPaymentMethod.updatedAt`, `payment_method`.`technical_name` AS `payment_method.technicalName`, `payment_method`.`created_at` AS `payment_method.createdAt`, `payment_method`.`updated_at` AS `payment_method.updatedAt`, `payment_method.translation.name`, COALESCE(`payment_method.translation.name`,`payment_method.translation.name`) AS `payment_method.name`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableName`) AS `payment_method.distinguishableName`, `payment_method.translation.description`, COALESCE(`payment_method.translation.description`,`payment_method.translation.description`) AS `payment_method.description`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.customFields`,`payment_method.translation.customFields`) AS `payment_method.customFields`, `payment_method.translation.createdAt`, `payment_method.translation.updatedAt`, `payment_method.translation.paymentMethodId`, `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation`.payment_method_id, `payment_method.translation`.name AS `payment_method.translation.name`, `payment_method.translation`.distinguishable_name AS `payment_method.translation.distinguishableName`, `payment_method.translation`.description AS `payment_method.translation.description`, `payment_method.translation`.custom_fields AS `payment_method.translation.customFields`, `payment_method.translation`.created_at AS `payment_method.translation.createdAt`, `payment_method.translation`.updated_at AS `payment_method.translation.updatedAt`, `payment_method.translation`.payment_method_id AS `payment_method.translation.paymentMethodId`, `payment_method.translation`.language_id AS `payment_method.translation.languageId` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.language_id = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` WHERE `payment_method`.`id` IN (?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"~c^yY=G=ª4üJ}\x00]B"
  b"ˆ\x13ì¬_ºAŽ´?΀\v\x12ŒM"
  b"""
    ¨ÑKÓKhIœ±õCC\n
    \x0EkÓ
    """
  b"ébçk´6Jü£¬À\všhµÙ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.87 ms
(0.60%) 		1 
SELECT CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') `key`, CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') url, LOWER(HEX(domain.id)) id, LOWER(HEX(sales_channel.id)) salesChannelId, LOWER(HEX(sales_channel.type_id)) typeId, LOWER(HEX(domain.snippet_set_id)) snippetSetId, LOWER(HEX(domain.currency_id)) currencyId, LOWER(HEX(domain.language_id)) languageId, LOWER(HEX(theme.id)) themeId, sales_channel.maintenance maintenance, sales_channel.maintenance_ip_whitelist maintenanceIpWhitelist, snippet_set.iso AS locale, theme.technical_name AS themeName, parentTheme.technical_name AS parentThemeName FROM sales_channel INNER JOIN sales_channel_domain domain ON domain.sales_channel_id = sales_channel.id LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id INNER JOIN snippet_set snippet_set ON snippet_set.id = domain.snippet_set_id LEFT JOIN theme theme ON theme_sales_channel.theme_id = theme.id LEFT JOIN theme parentTheme ON theme.parent_theme_id = parentTheme.id WHERE (sales_channel.type_id = UNHEX(?)) AND (sales_channel.active)
Parameters: 
[
  "8a243080f92e4c719546314b577cf82b"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.83 ms
(0.57%) 		1 
SELECT translation_key, value FROM snippet WHERE snippet_set_id = ?
Parameters: 
[
  b"‹wâvÔ"F•‚Ñ¿GE«ÚE"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.82 ms
(0.56%) 		1 
SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id`  LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id`  WHERE (`country`.`active` = ? AND `country`.`active` = ? AND `country.salesChannels`.`id` = ?) GROUP BY `country`.`id`
Parameters: 
[
  true
  true
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.81 ms
(0.56%) 		1 
# header::languages::search-ids
SELECT `language`.`id` FROM `language` LEFT JOIN `sales_channel_domain` `language.salesChannelDomains` ON `language`.`id` = `language.salesChannelDomains`.`language_id` LEFT JOIN `sales_channel_language` `language.salesChannels.mapping` ON `language`.`id` = `language.salesChannels.mapping`.`language_id`  LEFT JOIN `sales_channel` `language.salesChannels` ON `language.salesChannels.mapping`.`sales_channel_id` = `language.salesChannels`.`id`  WHERE (`language.salesChannelDomains`.`sales_channel_id` = ? AND `language.salesChannels`.`id` = ?) GROUP BY `language`.`id` ORDER BY MIN(`language`.`name`) ASC
Parameters: 
[
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.77 ms
(0.53%) 		1 
# header::navigation::read
SELECT `category`.`id` AS `category.id`, `category`.`version_id` AS `category.versionId`, `category`.`parent_id` AS `category.parentId`, `category`.`parent_version_id` AS `category.parentVersionId`, `category`.`after_category_id` AS `category.afterCategoryId`, `category`.`after_category_version_id` AS `category.afterCategoryVersionId`, `category`.`media_id` AS `category.mediaId`, `category`.`display_nested_products` AS `category.displayNestedProducts`, `category`.`auto_increment` AS `category.autoIncrement`, `category`.`level` AS `category.level`, `category`.`path` AS `category.path`, `category`.`child_count` AS `category.childCount`, `category`.`type` AS `category.type`, `category`.`product_assignment_type` AS `category.productAssignmentType`, `category`.`visible` AS `category.visible`, `category`.`active` AS `category.active`, `category`.`cms_page_id` AS `category.cmsPageId`, `category`.`cms_page_version_id` AS `category.cmsPageVersionId`, `category`.`product_stream_id` AS `category.productStreamId`, `category`.`custom_entity_type_id` AS `category.customEntityTypeId`, `category`.`created_at` AS `category.createdAt`, `category`.`updated_at` AS `category.updatedAt`, `category.media`.`id` AS `category.media.id`, `category.media`.`user_id` AS `category.media.userId`, `category.media`.`media_folder_id` AS `category.media.mediaFolderId`, `category.media`.`mime_type` AS `category.media.mimeType`, `category.media`.`file_extension` AS `category.media.fileExtension`, `category.media`.`uploaded_at` AS `category.media.uploadedAt`, `category.media`.`file_name` AS `category.media.fileName`, `category.media`.`file_size` AS `category.media.fileSize`, `category.media`.`media_type` AS `category.media.mediaTypeRaw`, `category.media`.`meta_data` AS `category.media.metaData`, `category.media`.`config` AS `category.media.config`, `category.media`.`path` AS `category.media.path`, `category.media`.`private` AS `category.media.private`, `category.media`.`thumbnails_ro` AS `category.media.thumbnailsRo`, `category.media`.`created_at` AS `category.media.createdAt`, `category.media`.`updated_at` AS `category.media.updatedAt`, `category.media.translation.title`, COALESCE(`category.media.translation.title`,`category.media.translation.title`) AS `category.media.title`, `category.media.translation.alt`, COALESCE(`category.media.translation.alt`,`category.media.translation.alt`) AS `category.media.alt`, `category.media.translation.customFields`, COALESCE(`category.media.translation.customFields`,`category.media.translation.customFields`) AS `category.media.customFields`, `category.media.translation.createdAt`, `category.media.translation.updatedAt`, `category.media.translation.mediaId`, `category.media.translation.languageId`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) AS `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) AS `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) AS `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) AS `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) AS `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) AS `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) AS `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) AS `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) AS `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) AS `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) AS `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) AS `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name AS `category.translation.name`, `category.translation`.breadcrumb AS `category.translation.breadcrumb`, `category.translation`.slot_config AS `category.translation.slotConfig`, `category.translation`.link_type AS `category.translation.linkType`, `category.translation`.internal_link AS `category.translation.internalLink`, `category.translation`.external_link AS `category.translation.externalLink`, `category.translation`.link_new_tab AS `category.translation.linkNewTab`, `category.translation`.description AS `category.translation.description`, `category.translation`.meta_title AS `category.translation.metaTitle`, `category.translation`.meta_description AS `category.translation.metaDescription`, `category.translation`.keywords AS `category.translation.keywords`, `category.translation`.custom_fields AS `category.translation.customFields`, `category.translation`.created_at AS `category.translation.createdAt`, `category.translation`.updated_at AS `category.translation.updatedAt`, `category.translation`.category_id AS `category.translation.categoryId`, `category.translation`.language_id AS `category.translation.languageId`, `category.translation`.category_version_id AS `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title AS `category.media.translation.title`, `category.media.translation`.alt AS `category.media.translation.alt`, `category.media.translation`.custom_fields AS `category.media.translation.customFields`, `category.media.translation`.created_at AS `category.media.translation.createdAt`, `category.media.translation`.updated_at AS `category.media.translation.updatedAt`, `category.media.translation`.media_id AS `category.media.translation.mediaId`, `category.media.translation`.language_id AS `category.media.translation.languageId` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.language_id = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"d{s*_▀L\eør\x1DÉFc»s"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.75 ms
(0.52%) 		1 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.72 ms
(0.49%) 		1 
SELECT `app`.`name`, `app`.`version`, `app`.`template_load_priority`
             FROM `app`
             INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id`
             WHERE `app`.`active` = 1 AND `app_template`.`active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.65 ms
(0.45%) 		1 
# cart-rule-loader::load-rules::read
SELECT `rule`.`id` AS `rule.id`, `rule`.`name` AS `rule.name`, `rule`.`priority` AS `rule.priority`, `rule`.`description` AS `rule.description`, `rule`.`payload` AS `rule.payload`, `rule`.`invalid` AS `rule.invalid`, `rule`.`areas` AS `rule.areas`, `rule`.`custom_fields` AS `rule.customFields`, `rule`.`module_types` AS `rule.moduleTypes`, `rule`.`created_at` AS `rule.createdAt`, `rule`.`updated_at` AS `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"áòAþ\x1FqK9¦Dñ#\x1C\x1EbT"
  b"\vñQ¨1JG™¾\x7F.˜q×Ã…"
  b"\x0Fõ,»?èA»Šãà\x08ÍZ\x19k"
  b"\x15¨░5þRJïØ\x19ã\x1CÚ'[Á"
  b"#60▄^÷Ihè?ı)Å9ȃ"
  b"(p\x7FBÒ´Iü€ú¯|uâ9\x13"
  b")––\x02Ø\fJ«‚\ˆTÖów "
  b"0p¨PïàLEšÍ©\x1Cƒ÷ðU"
  b"5×ðŒïµH'—,®<iÜ+Œ"
  b"?6│]║\eHHÉ\x17[ë\f8!§"
  b"F,ßmz¶IDœŸÁ<\x1A5¾\t"
  b"Pè V,ÖO╚ضE}å§┘["
  b"R\tªÌˆõO©™›ZÑ+P»\x14"
  b"R¶¾Ý³çF¶‡¬ˆ¼;²Ñµ"
  b"T\x02:"fóM ­\x01SêON,>"
  b"UÞy¦íÊB¶µ#@™wßû,"
  b"Ve¬k—ª@O§\x1CÝ—dö2Ò"
  b"[×4\x14%\x19Di–g\rôµ’]6"
  b"b\x17‘Ó\x02\x7FNx¿âY„–ÇŸW"
  b"wDÿƒ§`BáŸÕŸ.\x05Òå¤"
  b"x°$ÏM-LS‡æÄŠÿíËì"
  b"{mÏz©iL1«¢›HŽfè\x1E"
  b"„\x04õp°©C*¸wNc9ÿ\x15\v"
  b"ŽíX”T†Bç©Õ|•}ljg"
  b"ù\x00\x05³æüCÃÆIyìà;Øð"
  b"˜NÙ\x18äDG ”ž—\x01\x06ïðp"
  b"²ÀßuúÓGó…~\fÿÃÌäà"
  b"║¨]áÈì@Êà4;?v@Tß"
  b"Ø\r²LmâGc£\x1C/u¨ãj·"
  b"ݵhÿ\x7F+Nñ˜¯½cºQpÍ"
  b"áÜ{«À\eAc¥\x04Ö,ê…üþ"
  b"ä\x1CP•Ô<@\f¦;i\x1A‚ø¿L"
  b"ïÅ/#4,G0º'$¡Øè3¢"
  b"­zÔÌ┬èJ┘ü\x169▄tı┌h"
  b"Î¥ñ¬*\x14NñŽÿû\x7F\x1Dë'"
  b"1n'ù¹\x07@õ•\x12õ\x07„Vìà"
  b"7õê\x7FØkC]╝!╚╠├Fâ▓"
  b"ª&x>b\x11Fz™aª†0|T&"
  b"`\eKiP‡C“”€9$œæüï"
  b"cŽ,^\x1FÎK\x05Žúý8Ô3;´"
  b"íÂ]i\x01┘AëìÉ\x12zS\v\x07┌"
  b"£r.72ÍI{“Ë?iÐ\x13C7"
  b"┴¶i\x00Å×Eâ╝wø┼Óî¨õ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.63 ms
(0.43%) 		1 
# base-context-factory::taxes::read
SELECT `tax`.`id` AS `tax.id`, `tax`.`tax_rate` AS `tax.taxRate`, `tax`.`name` AS `tax.name`, `tax`.`position` AS `tax.position`, `tax`.`custom_fields` AS `tax.customFields`, `tax`.`created_at` AS `tax.createdAt`, `tax`.`updated_at` AS `tax.updatedAt` FROM `tax`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.59 ms
(0.41%) 		1 
# header::currencies::read
SELECT `currency`.`id` AS `currency.id`, `currency`.`factor` AS `currency.factor`, `currency`.`symbol` AS `currency.symbol`, `currency`.`iso_code` AS `currency.isoCode`, `currency`.`position` AS `currency.position`, `currency`.`tax_free_from` AS `currency.taxFreeFrom`, `currency`.`item_rounding` AS `currency.itemRounding`, `currency`.`total_rounding` AS `currency.totalRounding`, `currency`.`created_at` AS `currency.createdAt`, `currency`.`updated_at` AS `currency.updatedAt`, `currency.translation.shortName`, COALESCE(`currency.translation.shortName`,`currency.translation.shortName`) AS `currency.shortName`, `currency.translation.name`, COALESCE(`currency.translation.name`,`currency.translation.name`) AS `currency.name`, `currency.translation.customFields`, COALESCE(`currency.translation.customFields`,`currency.translation.customFields`) AS `currency.customFields`, `currency.translation.createdAt`, `currency.translation.updatedAt`, `currency.translation.currencyId`, `currency.translation.languageId` FROM `currency` LEFT JOIN (SELECT `currency.translation`.currency_id, `currency.translation`.short_name AS `currency.translation.shortName`, `currency.translation`.name AS `currency.translation.name`, `currency.translation`.custom_fields AS `currency.translation.customFields`, `currency.translation`.created_at AS `currency.translation.createdAt`, `currency.translation`.updated_at AS `currency.translation.updatedAt`, `currency.translation`.currency_id AS `currency.translation.currencyId`, `currency.translation`.language_id AS `currency.translation.languageId` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.language_id = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.59 ms
(0.41%) 		1 
# header::languages::read
SELECT `language`.`id` AS `language.id`, `language`.`parent_id` AS `language.parentId`, `language`.`locale_id` AS `language.localeId`, `language`.`translation_code_id` AS `language.translationCodeId`, `language`.`name` AS `language.name`, `language`.`custom_fields` AS `language.customFields`, `language`.`created_at` AS `language.createdAt`, `language`.`updated_at` AS `language.updatedAt`, `language.productSearchConfig`.`id` AS `language.productSearchConfig.id`, `language.productSearchConfig`.`language_id` AS `language.productSearchConfig.languageId`, `language.productSearchConfig`.`and_logic` AS `language.productSearchConfig.andLogic`, `language.productSearchConfig`.`min_search_length` AS `language.productSearchConfig.minSearchLength`, `language.productSearchConfig`.`excluded_terms` AS `language.productSearchConfig.excludedTerms`, `language.productSearchConfig`.`created_at` AS `language.productSearchConfig.createdAt`, `language.productSearchConfig`.`updated_at` AS `language.productSearchConfig.updatedAt`, `language.translationCode`.`id` AS `language.translationCode.id`, `language.translationCode`.`code` AS `language.translationCode.code`, `language.translationCode`.`created_at` AS `language.translationCode.createdAt`, `language.translationCode`.`updated_at` AS `language.translationCode.updatedAt`, `language.translationCode.translation.name`, COALESCE(`language.translationCode.translation.name`,`language.translationCode.translation.name`) AS `language.translationCode.name`, `language.translationCode.translation.territory`, COALESCE(`language.translationCode.translation.territory`,`language.translationCode.translation.territory`) AS `language.translationCode.territory`, `language.translationCode.translation.customFields`, COALESCE(`language.translationCode.translation.customFields`,`language.translationCode.translation.customFields`) AS `language.translationCode.customFields`, `language.translationCode.translation.createdAt`, `language.translationCode.translation.updatedAt`, `language.translationCode.translation.localeId`, `language.translationCode.translation.languageId` FROM `language` LEFT JOIN `product_search_config` `language.productSearchConfig` ON `language`.`id` = `language.productSearchConfig`.`language_id` LEFT JOIN `locale` `language.translationCode` ON `language`.`translation_code_id` = `language.translationCode`.`id` LEFT JOIN (SELECT `language.translationCode.translation`.locale_id, `language.translationCode.translation`.name AS `language.translationCode.translation.name`, `language.translationCode.translation`.territory AS `language.translationCode.translation.territory`, `language.translationCode.translation`.custom_fields AS `language.translationCode.translation.customFields`, `language.translationCode.translation`.created_at AS `language.translationCode.translation.createdAt`, `language.translationCode.translation`.updated_at AS `language.translationCode.translation.updatedAt`, `language.translationCode.translation`.locale_id AS `language.translationCode.translation.localeId`, `language.translationCode.translation`.language_id AS `language.translationCode.translation.languageId` FROM `locale_translation` `language.translationCode.translation` WHERE `language.translationCode.translation`.language_id = ?) `language.translationCode.locale_translation` ON `language.translationCode.locale_translation`.`locale_id` = `language.translationCode`.`id` WHERE `language`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.59 ms
(0.40%) 		1 
# generic-page::payment-methods::search-ids
SELECT `payment_method`.`id` FROM `payment_method` LEFT JOIN `sales_channel_payment_method` `payment_method.salesChannels.mapping` ON `payment_method`.`id` = `payment_method.salesChannels.mapping`.`payment_method_id`  LEFT JOIN `sales_channel` `payment_method.salesChannels` ON `payment_method.salesChannels.mapping`.`sales_channel_id` = `payment_method.salesChannels`.`id`  WHERE (`payment_method`.`active` = ? AND `payment_method.salesChannels`.`id` = ?) GROUP BY `payment_method`.`id` ORDER BY MIN(`payment_method`.`position`) ASC
Parameters: 
[
  true
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(0.39%) 		1 
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(0.39%) 		1 
# base-context-factory::cash-rounding::search-ids
SELECT `currency_country_rounding`.`id` FROM `currency_country_rounding` WHERE (`currency_country_rounding`.`currency_id` = ? AND `currency_country_rounding`.`country_id` = ?) LIMIT 1
Parameters: 
[
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
  b"³Rv™QôI\½3~Œh<sä"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.56 ms
(0.39%) 		1 
SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.56 ms
(0.38%) 		1 
SELECT LOWER(HEX(theme.id)) themeId, theme.technical_name AS themeName, parentTheme.technical_name AS parentThemeName
            FROM sales_channel
                LEFT JOIN theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id
                LEFT JOIN theme ON theme_sales_channel.theme_id = theme.id
                LEFT JOIN theme AS parentTheme ON parentTheme.id = theme.parent_theme_id
            WHERE sales_channel.id = ?
Parameters: 
[
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.54 ms
(0.37%) 		1 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.52 ms
(0.35%) 		1 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
  "KlarnaPayment.settings.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.50 ms
(0.35%) 		1 
# cart-rule-loader::load-rules::search-ids
SELECT `rule`.`id` FROM `rule` ORDER BY `rule`.`priority` DESC, `rule`.`id` ASC LIMIT 500
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.48 ms
(0.33%) 		1 
# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND (seo_path_info = ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
  "account/login"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.41 ms
(0.28%) 		1 
SELECT iso FROM snippet_set WHERE id = ?
Parameters: 
[
  b"‹wâvÔ"F•‚Ñ¿GE«ÚE"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.37 ms
(0.26%) 		1 
SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.37 ms
(0.26%) 		1 
# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name AS composerName
        FROM `plugin`
        ORDER BY `installed_at`;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.35 ms
(0.24%) 		1 
#cart-persister::load
                SELECT `cart`.`cart` AS payload, `cart`.`rule_ids`, 0 AS `compressed` FROM cart WHERE `token` = ?
Parameters: 
[
  "5fzwMt6foKc0dpfO48Y6BCblsazTTUyM"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.35 ms
(0.24%) 		1 
SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id`  LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id`  WHERE ((`country.salesChannels`.`id` = ?)) AND (`country`.`id` IN (?)) GROUP BY `country`.`id`
Parameters: 
[
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
  b"³Rv™QôI\½3~Œh<sä"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.23%) 		1 
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters: 
[
  "de-DE"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.22%) 		1 
# 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"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
  "/account/login"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(0.22%) 		1 
SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.21 ms
(0.15%) 		1 
DELETE FROM `cart` WHERE `token` = :token
Parameters: 
[
  "token" => "5fzwMt6foKc0dpfO48Y6BCblsazTTUyM"
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.