GET https://sw6-staging.gt-netstore.de/navigation/587d83a0206940b9b7efde9c27cb267d

Response
200 OK
IP
216.73.217.80
Profiled on
Token
5003bb

Query Metrics

102 Database Queries
81 Different statements
198.48 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
44.16 ms
(22.25%) 		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/587d83a0206940b9b7efde9c27cb267d"
  "/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/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"
  "/detail/5dffa5d4bc52499892460e494384bbed"
  "/detail/26fc8795e3194b4e89c02cde0a6db7f5"
  "/detail/6e1bf5eb12cd4d548fd5c44203d2f376"
  "/detail/e69c55338d624e82b8a5d215514a9783"
  "/detail/bb05045a2d8f48b6878a8636b52e1772"
  "/detail/d434ef414e5946618842fb2ab1a2fd45"
  "/detail/ad7cbc552fdd44949a4dbc63b79b5d37"
  "/detail/8dea71b05b184958be6af8ad9a33bf92"
  "/detail/b1732cff6ac5452a9ae13d1ddd391ef5"
  "/detail/f77d7d053bc64167857875b2721aebfb"
  "/detail/974ac3f6620e46448cbaaa683a5f2795"
  "/detail/1629560cf8ef482186dcb8724a21536e"
  "/detail/715f316156144fd5be92c6199f9cbc5d"
  "/detail/e9cf38e8688a46658b0407da3c9c7838"
  "/detail/95c797e408e14aebb078b590596fd588"
  "/detail/1e6021f3f2ea4c68a5dee4f847830f95"
  "/detail/42ca00338a49419086dfc99386adbe56"
  "/detail/5bb16d645c41417b9325deff269420ae"
  "/detail/71109bcadca34a41b37d3c752ff88bae"
  "/detail/60399237a0de40059f6a90c4da81371d"
  "/detail/a0e5698632ac487d8833a866082bf33c"
  "/detail/3d66d60c685c4b1e8ec0ce23a69bc5a2"
  "/detail/8b5db367524940c8884817dcda82be66"
  "/detail/6809c2d9eeb4442fa330f725a16d169a"
  "/detail/3ba8d50eedbd489aa4ae6ca83604baf7"
  "/detail/c902fcbd052547c9a303f74260de5e90"
  "/detail/6e120bceb8fa44b1913fe6bf54923feb"
  "/detail/f639d2010f25487095970cb46324112c"
  "/detail/d75934737e5946ab88e0d79ceea9fdb5"
  "/detail/e46478c66a49435db12f450a9a7192a4"
  "/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
31.38 ms
(15.81%) 		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
11.51 ms
(5.80%) 		1 
# product-listing-route::loading::read
SELECT `product`.`id` AS `product.id`, `product`.`version_id` AS `product.versionId`, `product`.`parent_id` AS `product.parentId`, `product`.`parent_version_id` AS `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) AS `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) AS `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) AS `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) AS `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) AS `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) AS `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) AS `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) AS `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) AS `product.canonicalProductId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) AS `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) AS `product.cmsPageVersionId`, `product.parent`.`price` AS `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) AS `product.price`, `product`.`product_number` AS `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) AS `product.restockTime`, `product`.`auto_increment` AS `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) AS `product.active`, `product`.`available` AS `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) AS `product.isCloseout`, `product`.`display_group` AS `product.displayGroup`, `product.parent`.`variant_listing_config` AS `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) AS `product.variantListingConfig`, `product`.`variant_restrictions` AS `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) AS `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) AS `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) AS `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) AS `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) AS `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) AS `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) AS `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) AS `product.shippingFree`, `product.parent`.`purchase_prices` AS `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) AS `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) AS `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) AS `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) AS `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) AS `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) AS `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) AS `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) AS `product.ratingAverage`, `product.parent`.`category_tree` AS `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) AS `product.categoryTree`, `product.parent`.`property_ids` AS `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) AS `product.propertyIds`, `product.parent`.`option_ids` AS `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) AS `product.optionIds`, `product.parent`.`stream_ids` AS `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) AS `product.streamIds`, `product.parent`.`tag_ids` AS `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) AS `product.tagIds`, `product.parent`.`category_ids` AS `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) AS `product.categoryIds`, `product`.`child_count` AS `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) AS `product.customFieldSetSelectionActive`, `product`.`sales` AS `product.sales`, `product`.`states` AS `product.states`, `product.tax`.`id` AS `product.tax.id`, `product.tax`.`tax_rate` AS `product.tax.taxRate`, `product.tax`.`name` AS `product.tax.name`, `product.tax`.`position` AS `product.tax.position`, `product.tax`.`custom_fields` AS `product.tax.customFields`, `product.tax`.`created_at` AS `product.tax.createdAt`, `product.tax`.`updated_at` AS `product.tax.updatedAt`, `product`.`available_stock` AS `product.availableStock`, `product`.`stock` AS `product.stock`, `product.parent`.`cheapest_price` AS `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) AS `product.cheapestPrice`, `product`.`created_at` AS `product.createdAt`, `product`.`updated_at` AS `product.updatedAt`, `product.manufacturer`.`id` AS `product.manufacturer.id`, `product.manufacturer`.`version_id` AS `product.manufacturer.versionId`, `product.manufacturer`.`media_id` AS `product.manufacturer.mediaId`, `product.manufacturer`.`link` AS `product.manufacturer.link`, `product.manufacturer`.`created_at` AS `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` AS `product.manufacturer.updatedAt`, `product.manufacturer.translation.name`, COALESCE(`product.manufacturer.translation.name`,`product.manufacturer.translation.name`) AS `product.manufacturer.name`, `product.manufacturer.translation.description`, COALESCE(`product.manufacturer.translation.description`,`product.manufacturer.translation.description`) AS `product.manufacturer.description`, `product.manufacturer.translation.customFields`, COALESCE(`product.manufacturer.translation.customFields`,`product.manufacturer.translation.customFields`) AS `product.manufacturer.customFields`, `product.manufacturer.translation.createdAt`, `product.manufacturer.translation.updatedAt`, `product.manufacturer.translation.productManufacturerId`, `product.manufacturer.translation.languageId`, `product.manufacturer.translation.productManufacturerVersionId`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_option` `product.options.mapping`
                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) AS `product.options.id_mapping`, `product.unit`.`id` AS `product.unit.id`, `product.unit`.`created_at` AS `product.unit.createdAt`, `product.unit`.`updated_at` AS `product.unit.updatedAt`, `product.unit.translation.shortCode`, COALESCE(`product.unit.translation.shortCode`,`product.unit.translation.shortCode`) AS `product.unit.shortCode`, `product.unit.translation.name`, COALESCE(`product.unit.translation.name`,`product.unit.translation.name`) AS `product.unit.name`, `product.unit.translation.customFields`, COALESCE(`product.unit.translation.customFields`,`product.unit.translation.customFields`) AS `product.unit.customFields`, `product.unit.translation.createdAt`, `product.unit.translation.updatedAt`, `product.unit.translation.unitId`, `product.unit.translation.languageId`, `product.deliveryTime`.`id` AS `product.deliveryTime.id`, `product.deliveryTime`.`min` AS `product.deliveryTime.min`, `product.deliveryTime`.`max` AS `product.deliveryTime.max`, `product.deliveryTime`.`unit` AS `product.deliveryTime.unit`, `product.deliveryTime`.`created_at` AS `product.deliveryTime.createdAt`, `product.deliveryTime`.`updated_at` AS `product.deliveryTime.updatedAt`, `product.deliveryTime.translation.name`, COALESCE(`product.deliveryTime.translation.name`,`product.deliveryTime.translation.name`) AS `product.deliveryTime.name`, `product.deliveryTime.translation.customFields`, COALESCE(`product.deliveryTime.translation.customFields`,`product.deliveryTime.translation.customFields`) AS `product.deliveryTime.customFields`, `product.deliveryTime.translation.createdAt`, `product.deliveryTime.translation.updatedAt`, `product.deliveryTime.translation.deliveryTimeId`, `product.deliveryTime.translation.languageId`, `product.cover`.`id` AS `product.cover.id`, `product.cover`.`version_id` AS `product.cover.versionId`, `product.cover`.`product_id` AS `product.cover.productId`, `product.cover`.`product_version_id` AS `product.cover.productVersionId`, `product.cover`.`media_id` AS `product.cover.mediaId`, `product.cover`.`position` AS `product.cover.position`, `product.cover.media`.`id` AS `product.cover.media.id`, `product.cover.media`.`user_id` AS `product.cover.media.userId`, `product.cover.media`.`media_folder_id` AS `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` AS `product.cover.media.mimeType`, `product.cover.media`.`file_extension` AS `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` AS `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` AS `product.cover.media.fileName`, `product.cover.media`.`file_size` AS `product.cover.media.fileSize`, `product.cover.media`.`media_type` AS `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` AS `product.cover.media.metaData`, `product.cover.media`.`config` AS `product.cover.media.config`, `product.cover.media`.`path` AS `product.cover.media.path`, `product.cover.media`.`private` AS `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` AS `product.cover.media.thumbnailsRo`, `product.cover.media`.`created_at` AS `product.cover.media.createdAt`, `product.cover.media`.`updated_at` AS `product.cover.media.updatedAt`, `product.cover.media.translation.title`, COALESCE(`product.cover.media.translation.title`,`product.cover.media.translation.title`) AS `product.cover.media.title`, `product.cover.media.translation.alt`, COALESCE(`product.cover.media.translation.alt`,`product.cover.media.translation.alt`) AS `product.cover.media.alt`, `product.cover.media.translation.customFields`, COALESCE(`product.cover.media.translation.customFields`,`product.cover.media.translation.customFields`) AS `product.cover.media.customFields`, `product.cover.media.translation.createdAt`, `product.cover.media.translation.updatedAt`, `product.cover.media.translation.mediaId`, `product.cover.media.translation.languageId`, `product.cover`.`custom_fields` AS `product.cover.customFields`, `product.cover`.`created_at` AS `product.cover.createdAt`, `product.cover`.`updated_at` AS `product.cover.updatedAt`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`,`product.translation.metaDescription`) AS `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`,`product.translation.name`) AS `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`,`product.translation.keywords`) AS `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`,`product.translation.description`) AS `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`,`product.translation.metaTitle`) AS `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`,`product.translation.packUnit`) AS `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`,`product.translation.packUnitPlural`) AS `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`,`product.translation.customSearchKeywords`) AS `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`,`product.translation.slotConfig`) AS `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`,`product.translation.customFields`) AS `product.customFields`, `product.translation.createdAt`, `product.parent.translation.createdAt`, `product.translation.updatedAt`, `product.parent.translation.updatedAt`, `product.translation.productId`, `product.parent.translation.productId`, `product.translation.languageId`, `product.parent.translation.languageId`, `product.translation.productVersionId`, `product.parent.translation.productVersionId` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.product_id, `product.translation`.product_version_id, `product.translation`.meta_description AS `product.translation.metaDescription`, `product.translation`.name AS `product.translation.name`, `product.translation`.keywords AS `product.translation.keywords`, `product.translation`.description AS `product.translation.description`, `product.translation`.meta_title AS `product.translation.metaTitle`, `product.translation`.pack_unit AS `product.translation.packUnit`, `product.translation`.pack_unit_plural AS `product.translation.packUnitPlural`, `product.translation`.custom_search_keywords AS `product.translation.customSearchKeywords`, `product.translation`.slot_config AS `product.translation.slotConfig`, `product.translation`.custom_fields AS `product.translation.customFields`, `product.translation`.created_at AS `product.translation.createdAt`, `product.translation`.updated_at AS `product.translation.updatedAt`, `product.translation`.product_id AS `product.translation.productId`, `product.translation`.language_id AS `product.translation.languageId`, `product.translation`.product_version_id AS `product.translation.productVersionId` FROM `product_translation` `product.translation` WHERE `product.translation`.language_id = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.product_version_id = `product`.version_id LEFT JOIN (SELECT `product.parent.translation`.product_id, `product.parent.translation`.product_version_id, `product.parent.translation`.meta_description AS `product.parent.translation.metaDescription`, `product.parent.translation`.name AS `product.parent.translation.name`, `product.parent.translation`.keywords AS `product.parent.translation.keywords`, `product.parent.translation`.description AS `product.parent.translation.description`, `product.parent.translation`.meta_title AS `product.parent.translation.metaTitle`, `product.parent.translation`.pack_unit AS `product.parent.translation.packUnit`, `product.parent.translation`.pack_unit_plural AS `product.parent.translation.packUnitPlural`, `product.parent.translation`.custom_search_keywords AS `product.parent.translation.customSearchKeywords`, `product.parent.translation`.slot_config AS `product.parent.translation.slotConfig`, `product.parent.translation`.custom_fields AS `product.parent.translation.customFields`, `product.parent.translation`.created_at AS `product.parent.translation.createdAt`, `product.parent.translation`.updated_at AS `product.parent.translation.updatedAt`, `product.parent.translation`.product_id AS `product.parent.translation.productId`, `product.parent.translation`.language_id AS `product.parent.translation.languageId`, `product.parent.translation`.product_version_id AS `product.parent.translation.productVersionId` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.language_id = ?) `product.product_translation.parent` ON `product.product_translation.parent`.`product_id` = `product.parent`.`id` AND `product.product_translation.parent`.product_version_id = `product.parent`.version_id LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN (SELECT `product.manufacturer.translation`.product_manufacturer_id, `product.manufacturer.translation`.product_manufacturer_version_id, `product.manufacturer.translation`.name AS `product.manufacturer.translation.name`, `product.manufacturer.translation`.description AS `product.manufacturer.translation.description`, `product.manufacturer.translation`.custom_fields AS `product.manufacturer.translation.customFields`, `product.manufacturer.translation`.created_at AS `product.manufacturer.translation.createdAt`, `product.manufacturer.translation`.updated_at AS `product.manufacturer.translation.updatedAt`, `product.manufacturer.translation`.product_manufacturer_id AS `product.manufacturer.translation.productManufacturerId`, `product.manufacturer.translation`.language_id AS `product.manufacturer.translation.languageId`, `product.manufacturer.translation`.product_manufacturer_version_id AS `product.manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer_translation` `product.manufacturer.translation` WHERE `product.manufacturer.translation`.language_id = ?) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product.manufacturer.product_manufacturer_translation`.product_manufacturer_version_id = `product.manufacturer`.version_id LEFT JOIN (SELECT `product.unit.translation`.unit_id, `product.unit.translation`.short_code AS `product.unit.translation.shortCode`, `product.unit.translation`.name AS `product.unit.translation.name`, `product.unit.translation`.custom_fields AS `product.unit.translation.customFields`, `product.unit.translation`.created_at AS `product.unit.translation.createdAt`, `product.unit.translation`.updated_at AS `product.unit.translation.updatedAt`, `product.unit.translation`.unit_id AS `product.unit.translation.unitId`, `product.unit.translation`.language_id AS `product.unit.translation.languageId` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation`.language_id = ?) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id` LEFT JOIN (SELECT `product.deliveryTime.translation`.delivery_time_id, `product.deliveryTime.translation`.name AS `product.deliveryTime.translation.name`, `product.deliveryTime.translation`.custom_fields AS `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation`.created_at AS `product.deliveryTime.translation.createdAt`, `product.deliveryTime.translation`.updated_at AS `product.deliveryTime.translation.updatedAt`, `product.deliveryTime.translation`.delivery_time_id AS `product.deliveryTime.translation.deliveryTimeId`, `product.deliveryTime.translation`.language_id AS `product.deliveryTime.translation.languageId` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation`.language_id = ?) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id` LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.cover.media.translation`.media_id, `product.cover.media.translation`.title AS `product.cover.media.translation.title`, `product.cover.media.translation`.alt AS `product.cover.media.translation.alt`, `product.cover.media.translation`.custom_fields AS `product.cover.media.translation.customFields`, `product.cover.media.translation`.created_at AS `product.cover.media.translation.createdAt`, `product.cover.media.translation`.updated_at AS `product.cover.media.translation.updatedAt`, `product.cover.media.translation`.media_id AS `product.cover.media.translation.mediaId`, `product.cover.media.translation`.language_id AS `product.cover.media.translation.languageId` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation`.language_id = ?) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"]ÿ¥Ô¼RI˜’F\x0EIC„»í"
  b"""
    &ü‡•ã\x19KN‰À,Þ\n
    m·õ
    """
  b"n\e§Ù\x12═MTÅı─B\x03ʾv"
  b"µ£U3ìbNé©ÑÊ\x15QJùâ"
  b"╗\x05\x04Z-ÅHÂçèå6Á.\x17r"
  b"Ô4ïANYFaˆBû*±¢ýE"
  b"­|¼U/ÝD”šM¼c·›]7"
  b"ìÛq░[\x18IX¥j°¡Ü3┐Æ"
  b"±s,ÿjÅE*šá=\x1DÝ9\x1Eõ"
  b"÷}}\x05;ÆAg…xu²r\x1Aëû"
  b"—JÃöb\x0EFDŒºªh:_'•"
  b"\x16)V\føïH!†Ü¸rJ!Sn"
  b"q_1aV\x14OÕ¾’Æ\x19Ÿœ¼]"
  b"éÏ8èhŠFe‹\x04\x07Ú<œx8"
  b"òÃùõ\x08ßJÙ░xÁÉYoıê"
  b"\x1E`!óòêLh¥ÞäøGƒ\x0F•"
  b"B╩\x003èIAÉå▀╔ôå¡¥V"
  b"[±md\AA{“%Þÿ&” ®"
  b"q\x10›ÊÜ£JA³}<u/ø‹®"
  b"`9Æ7áÌ@\x05ƒjÉ─┌ü7\x1D"
  b" åi†2¬H}ˆ3¨f\x08+ó<"
  b"=fÖ\fh\K\x1EŽÀÎ#¦›Å¢"
  b"‹]³gRI@ȈH\x17ÜÚ‚¾f"
  b"h\tÂÙî´D/£0÷%¡m\x16š"
  b";¨Õ\x0Eí½Hš¤®l¨6\x04º÷"
  b"╔\x02³¢\x05%G╔ú\x03¸B`Ì^É"
  b"n\x12\vθúD±‘?æ¿T’?ë"
  b"ö9Ò\x01\x0F%Hp•—\f´c$\x11,"
  b"×Y4s~YF«ˆàלî©ýµ"
  b"""
    ädxÆjIC]±/E\n
    šq’¤
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
10.69 ms
(5.38%) 		1 
# product-listing-route::loading::search-ids
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN (SELECT `product.translation`.product_id, `product.translation`.product_version_id, `product.translation`.meta_description AS `product.translation.metaDescription`, `product.translation`.name AS `product.translation.name`, `product.translation`.keywords AS `product.translation.keywords`, `product.translation`.description AS `product.translation.description`, `product.translation`.meta_title AS `product.translation.metaTitle`, `product.translation`.pack_unit AS `product.translation.packUnit`, `product.translation`.pack_unit_plural AS `product.translation.packUnitPlural`, `product.translation`.custom_search_keywords AS `product.translation.customSearchKeywords`, `product.translation`.slot_config AS `product.translation.slotConfig`, `product.translation`.custom_fields AS `product.translation.customFields`, `product.translation`.created_at AS `product.translation.createdAt`, `product.translation`.updated_at AS `product.translation.updatedAt`, `product.translation`.product_id AS `product.translation.productId`, `product.translation`.language_id AS `product.translation.languageId`, `product.translation`.product_version_id AS `product.translation.productVersionId` FROM `product_translation` `product.translation` WHERE `product.translation`.language_id = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.product_version_id = `product`.version_id LEFT JOIN (SELECT `product.parent.translation`.product_id, `product.parent.translation`.product_version_id, `product.parent.translation`.meta_description AS `product.parent.translation.metaDescription`, `product.parent.translation`.name AS `product.parent.translation.name`, `product.parent.translation`.keywords AS `product.parent.translation.keywords`, `product.parent.translation`.description AS `product.parent.translation.description`, `product.parent.translation`.meta_title AS `product.parent.translation.metaTitle`, `product.parent.translation`.pack_unit AS `product.parent.translation.packUnit`, `product.parent.translation`.pack_unit_plural AS `product.parent.translation.packUnitPlural`, `product.parent.translation`.custom_search_keywords AS `product.parent.translation.customSearchKeywords`, `product.parent.translation`.slot_config AS `product.parent.translation.slotConfig`, `product.parent.translation`.custom_fields AS `product.parent.translation.customFields`, `product.parent.translation`.created_at AS `product.parent.translation.createdAt`, `product.parent.translation`.updated_at AS `product.parent.translation.updatedAt`, `product.parent.translation`.product_id AS `product.parent.translation.productId`, `product.parent.translation`.language_id AS `product.parent.translation.languageId`, `product.parent.translation`.product_version_id AS `product.parent.translation.productVersionId` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.language_id = ?) `product.product_translation.parent` ON `product.product_translation.parent`.`product_id` = `product.parent`.`id` AND `product.product_translation.parent`.product_version_id = `product.parent`.version_id LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product`.`display_group` ORDER BY MIN(COALESCE(IF(JSON_TYPE(JSON_EXTRACT(`product.translation.customFields`, '$.\"migration_GT-SW5to6_product_attr4\"')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`product.translation.customFields`, '$.\"migration_GT-SW5to6_product_attr4\"')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL),IF(JSON_TYPE(JSON_EXTRACT(`product.parent.translation.customFields`, '$.\"migration_GT-SW5to6_product_attr4\"')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`product.parent.translation.customFields`, '$.\"migration_GT-SW5to6_product_attr4\"')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL))) ASC, IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule15f9b035e7524a8b9d19c61ce9275bb5.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule508a20562c994fc89df4457d86f5d95b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule55de79a6edca42b6b523409977dffb2c.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule5665ac6b97aa404fa71cdd9764f632d2.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule5bd734142519446996670df4b5925d36.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule970005fc918143c79249798d853b9dd0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruled80db24c6de24763a31c2f75a8e36ab7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule316e27f9b90740f59512f5078456ece0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleaa26783e6211467a9961aa86307c5426.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule15f9b035e7524a8b9d19c61ce9275bb5.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule508a20562c994fc89df4457d86f5d95b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule55de79a6edca42b6b523409977dffb2c.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule5665ac6b97aa404fa71cdd9764f632d2.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule5bd734142519446996670df4b5925d36.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule970005fc918143c79249798d853b9dd0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruled80db24c6de24763a31c2f75a8e36ab7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule316e27f9b90740f59512f5078456ece0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleaa26783e6211467a9961aa86307c5426.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100))) ASC, MAX(IFNULL(`product`.`release_date`, `product.parent`.`release_date`)) DESC, MIN(`product`.`id`) ASC LIMIT 30
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
  true
  b"X}ƒ  i@¹·ïÞœ'Ë&}"
  null
  true
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
5.71 ms
(2.88%) 		6 
# 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
5.57 ms
(2.81%) 		1 
SELECT COUNT(*) FROM (# product-listing-route::loading::search-ids
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN (SELECT `product.translation`.product_id, `product.translation`.product_version_id, `product.translation`.meta_description AS `product.translation.metaDescription`, `product.translation`.name AS `product.translation.name`, `product.translation`.keywords AS `product.translation.keywords`, `product.translation`.description AS `product.translation.description`, `product.translation`.meta_title AS `product.translation.metaTitle`, `product.translation`.pack_unit AS `product.translation.packUnit`, `product.translation`.pack_unit_plural AS `product.translation.packUnitPlural`, `product.translation`.custom_search_keywords AS `product.translation.customSearchKeywords`, `product.translation`.slot_config AS `product.translation.slotConfig`, `product.translation`.custom_fields AS `product.translation.customFields`, `product.translation`.created_at AS `product.translation.createdAt`, `product.translation`.updated_at AS `product.translation.updatedAt`, `product.translation`.product_id AS `product.translation.productId`, `product.translation`.language_id AS `product.translation.languageId`, `product.translation`.product_version_id AS `product.translation.productVersionId` FROM `product_translation` `product.translation` WHERE `product.translation`.language_id = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.product_version_id = `product`.version_id LEFT JOIN (SELECT `product.parent.translation`.product_id, `product.parent.translation`.product_version_id, `product.parent.translation`.meta_description AS `product.parent.translation.metaDescription`, `product.parent.translation`.name AS `product.parent.translation.name`, `product.parent.translation`.keywords AS `product.parent.translation.keywords`, `product.parent.translation`.description AS `product.parent.translation.description`, `product.parent.translation`.meta_title AS `product.parent.translation.metaTitle`, `product.parent.translation`.pack_unit AS `product.parent.translation.packUnit`, `product.parent.translation`.pack_unit_plural AS `product.parent.translation.packUnitPlural`, `product.parent.translation`.custom_search_keywords AS `product.parent.translation.customSearchKeywords`, `product.parent.translation`.slot_config AS `product.parent.translation.slotConfig`, `product.parent.translation`.custom_fields AS `product.parent.translation.customFields`, `product.parent.translation`.created_at AS `product.parent.translation.createdAt`, `product.parent.translation`.updated_at AS `product.parent.translation.updatedAt`, `product.parent.translation`.product_id AS `product.parent.translation.productId`, `product.parent.translation`.language_id AS `product.parent.translation.languageId`, `product.parent.translation`.product_version_id AS `product.parent.translation.productVersionId` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.language_id = ?) `product.product_translation.parent` ON `product.product_translation.parent`.`product_id` = `product.parent`.`id` AND `product.product_translation.parent`.product_version_id = `product.parent`.version_id LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product`.`display_group`) total
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
  true
  b"X}ƒ  i@¹·ïÞœ'Ë&}"
  null
  true
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
4.48 ms
(2.26%) 		6 
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
3.73 ms
(1.88%) 		1 
# product-listing-route::loading::aggregation::manufacturer
SELECT LOWER(HEX(IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`))) AS `manufacturer` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`)
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
  true
  b"X}ƒ  i@¹·ïÞœ'Ë&}"
  null
  true
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
3.09 ms
(1.56%) 		6 
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
2.69 ms
(1.36%) 		1 
# product-listing-route::loading::aggregation::properties
SELECT LOWER(HEX(`product.properties`.`id`)) AS `properties.key`, COUNT(`product`.`id`) AS `properties.count` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `product_property` `product.properties.mapping` ON `product`.`properties` = `product.properties.mapping`.`product_id`  AND `product`.`version_id` = `product.properties.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` LEFT JOIN `property_group_option` `product.properties` ON `product.properties.mapping`.`property_group_option_id` = `product.properties`.`id`  WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product.properties`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
  true
  b"X}ƒ  i@¹·ïÞœ'Ë&}"
  null
  true
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
2.56 ms
(1.29%) 		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
2.56 ms
(1.29%) 		1 
# product-listing-route::loading::association::prices::read
SELECT `product_price`.`id` AS `product_price.id`, `product_price`.`version_id` AS `product_price.versionId`, `product_price`.`product_id` AS `product_price.productId`, `product_price`.`product_version_id` AS `product_price.productVersionId`, `product_price`.`rule_id` AS `product_price.ruleId`, `product_price`.`price` AS `product_price.price`, `product_price`.`quantity_start` AS `product_price.quantityStart`, `product_price`.`quantity_end` AS `product_price.quantityEnd`, `product_price`.`custom_fields` AS `product_price.customFields`, `product_price`.`created_at` AS `product_price.createdAt`, `product_price`.`updated_at` AS `product_price.updatedAt` FROM `product_price` WHERE (`product_price`.`version_id` = ?) AND ((`product_price`.`product_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x16)V\føïH!†Ü¸rJ!Sn"
  b"\x1E`!óòêLh¥ÞäøGƒ\x0F•"
  b"""
    &ü‡•ã\x19KN‰À,Þ\n
    m·õ
    """
  b";¨Õ\x0Eí½Hš¤®l¨6\x04º÷"
  b"=fÖ\fh\K\x1EŽÀÎ#¦›Å¢"
  b"B╩\x003èIAÉå▀╔ôå¡¥V"
  b"[±md\AA{“%Þÿ&” ®"
  b"]ÿ¥Ô¼RI˜’F\x0EIC„»í"
  b"`9Æ7áÌ@\x05ƒjÉ─┌ü7\x1D"
  b"h\tÂÙî´D/£0÷%¡m\x16š"
  b"n\x12\vθúD±‘?æ¿T’?ë"
  b"n\e§Ù\x12═MTÅı─B\x03ʾv"
  b"q\x10›ÊÜ£JA³}<u/ø‹®"
  b"q_1aV\x14OÕ¾’Æ\x19Ÿœ¼]"
  b"‹]³gRI@ȈH\x17ÜÚ‚¾f"
  b"ìÛq░[\x18IX¥j°¡Ü3┐Æ"
  b"òÃùõ\x08ßJÙ░xÁÉYoıê"
  b"—JÃöb\x0EFDŒºªh:_'•"
  b" åi†2¬H}ˆ3¨f\x08+ó<"
  b"­|¼U/ÝD”šM¼c·›]7"
  b"±s,ÿjÅE*šá=\x1DÝ9\x1Eõ"
  b"╗\x05\x04Z-ÅHÂçèå6Á.\x17r"
  b"╔\x02³¢\x05%G╔ú\x03¸B`Ì^É"
  b"Ô4ïANYFaˆBû*±¢ýE"
  b"×Y4s~YF«ˆàלî©ýµ"
  b"""
    ädxÆjIC]±/E\n
    šq’¤
    """
  b"µ£U3ìbNé©ÑÊ\x15QJùâ"
  b"éÏ8èhŠFe‹\x04\x07Ú<œx8"
  b"ö9Ò\x01\x0F%Hp•—\f´c$\x11,"
  b"÷}}\x05;ÆAg…xu²r\x1Aëû"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.49 ms
(1.26%) 		1 
# product-listing-route::loading::aggregation::options
SELECT LOWER(HEX(`product.options`.`id`)) AS `options.key`, COUNT(`product`.`id`) AS `options.count` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `product_option` `product.options.mapping` ON `product`.`id` = `product.options.mapping`.`product_id`  AND `product`.`version_id` = `product.options.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` LEFT JOIN `property_group_option` `product.options` ON `product.options.mapping`.`property_group_option_id` = `product.options`.`id`  WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product.options`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
  true
  b"X}ƒ  i@¹·ïÞœ'Ë&}"
  null
  true
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
2.46 ms
(1.24%) 		1 
# product-listing-route::loading::search-ids
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?))) AND (`product`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY `product`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  10
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
  true
  b"]ÿ¥Ô¼RI˜’F\x0EIC„»í"
  b"""
    &ü‡•ã\x19KN‰À,Þ\n
    m·õ
    """
  b"n\e§Ù\x12═MTÅı─B\x03ʾv"
  b"µ£U3ìbNé©ÑÊ\x15QJùâ"
  b"╗\x05\x04Z-ÅHÂçèå6Á.\x17r"
  b"Ô4ïANYFaˆBû*±¢ýE"
  b"­|¼U/ÝD”šM¼c·›]7"
  b"ìÛq░[\x18IX¥j°¡Ü3┐Æ"
  b"±s,ÿjÅE*šá=\x1DÝ9\x1Eõ"
  b"÷}}\x05;ÆAg…xu²r\x1Aëû"
  b"—JÃöb\x0EFDŒºªh:_'•"
  b"\x16)V\føïH!†Ü¸rJ!Sn"
  b"q_1aV\x14OÕ¾’Æ\x19Ÿœ¼]"
  b"éÏ8èhŠFe‹\x04\x07Ú<œx8"
  b"òÃùõ\x08ßJÙ░xÁÉYoıê"
  b"\x1E`!óòêLh¥ÞäøGƒ\x0F•"
  b"B╩\x003èIAÉå▀╔ôå¡¥V"
  b"[±md\AA{“%Þÿ&” ®"
  b"q\x10›ÊÜ£JA³}<u/ø‹®"
  b"`9Æ7áÌ@\x05ƒjÉ─┌ü7\x1D"
  b" åi†2¬H}ˆ3¨f\x08+ó<"
  b"=fÖ\fh\K\x1EŽÀÎ#¦›Å¢"
  b"‹]³gRI@ȈH\x17ÜÚ‚¾f"
  b"h\tÂÙî´D/£0÷%¡m\x16š"
  b";¨Õ\x0Eí½Hš¤®l¨6\x04º÷"
  b"╔\x02³¢\x05%G╔ú\x03¸B`Ì^É"
  b"n\x12\vθúD±‘?æ¿T’?ë"
  b"ö9Ò\x01\x0F%Hp•—\f´c$\x11,"
  b"×Y4s~YF«ˆàלî©ýµ"
  b"""
    ädxÆjIC]±/E\n
    šq’¤
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
2.22 ms
(1.12%) 		3 
# 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
2.16 ms
(1.09%) 		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"\x17K\r![AL`œ\x1A#9À]©U"
  b"eÍ\x7F¶ÇHB\v†;4í5_¼H"
  b"ä÷Ìae\fB¶ïãçª┌Ø┌¶"
  b"šáP\x12R\x06Jq¾Pxþž\x06Ýš"
  b"¿\x08&ɦ║M\x01Ñu¶\eR\x04■K"
  b"û¼ÏгëBO†\f\x01RÒ%u\x1F"
  b"X}ƒ  i@¹·ïÞœ'Ë&}"
  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
1.92 ms
(0.97%) 		1 
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE ?
Parameters: 
[
  "payload"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.87 ms
(0.94%) 		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
1.82 ms
(0.91%) 		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.77 ms
(0.89%) 		1 
# category::cms-page::association::sections::association::blocks::association::slots::read
SELECT `cms_slot`.`id` AS `cms_slot.id`, `cms_slot`.`version_id` AS `cms_slot.versionId`, `cms_slot`.`type` AS `cms_slot.type`, `cms_slot`.`slot` AS `cms_slot.slot`, `cms_slot`.`locked` AS `cms_slot.locked`, `cms_slot`.`cms_block_id` AS `cms_slot.blockId`, `cms_slot`.`cms_block_version_id` AS `cms_slot.cmsBlockVersionId`, `cms_slot`.`created_at` AS `cms_slot.createdAt`, `cms_slot`.`updated_at` AS `cms_slot.updatedAt`, `cms_slot.translation.config`, COALESCE(`cms_slot.translation.config`,`cms_slot.translation.config`) AS `cms_slot.config`, `cms_slot.translation.customFields`, COALESCE(`cms_slot.translation.customFields`,`cms_slot.translation.customFields`) AS `cms_slot.customFields`, `cms_slot.translation.createdAt`, `cms_slot.translation.updatedAt`, `cms_slot.translation.cmsSlotId`, `cms_slot.translation.languageId`, `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation`.cms_slot_id, `cms_slot.translation`.cms_slot_version_id, `cms_slot.translation`.config AS `cms_slot.translation.config`, `cms_slot.translation`.custom_fields AS `cms_slot.translation.customFields`, `cms_slot.translation`.created_at AS `cms_slot.translation.createdAt`, `cms_slot.translation`.updated_at AS `cms_slot.translation.updatedAt`, `cms_slot.translation`.cms_slot_id AS `cms_slot.translation.cmsSlotId`, `cms_slot.translation`.language_id AS `cms_slot.translation.languageId`, `cms_slot.translation`.cms_slot_version_id AS `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation`.language_id = ?) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` AND `cms_slot.cms_slot_translation`.cms_slot_version_id = `cms_slot`.version_id WHERE (`cms_slot`.`version_id` = ?) AND ((`cms_slot`.`cms_block_id` IN (?, ?, ?, ?, ?, ?, ?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x02y~Â\x19RD°¶¾\x03 LºF\x17"
  b"<D¸\x1A÷¾JÆöwMÅ┤\x1AvD"
  b"Fw¯ÄÉuB\x15òÒ╚|ñ`eº"
  b"pUÁ…Ì\x1FM5ª’÷ó\täåø"
  b"¿æØmoáHr╣Óø\x15¾y╝s"
  b"╩e\x1A¦åTD%ؤÉê#\x08║h"
  b"Ý—\x13€Ð§O\x1F­dÙÕé׎["
]
View formatted query    View runnable query    Explain query    View query backtrace
1.74 ms
(0.88%) 		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.71 ms
(0.86%) 		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
1.68 ms
(0.85%) 		1 
# breadcrumb-extension::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.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 WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"î\x12¯bëÎOÔÅ▓\x17À×ñ[_"
  b"X}ƒ  i@¹·ïÞœ'Ë&}"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.67 ms
(0.84%) 		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.62 ms
(0.82%) 		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
1.59 ms
(0.80%) 		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
1.47 ms
(0.74%) 		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.29 ms
(0.65%) 		1 
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"-p^$~õMJ•\x13'¸{Ií‚"
  b"\x10åzïå\x13F²¦\r$Pš®‘Â"
  b"5¾?:^IB\tŒC3wä\x16\x1Eì"
  b"¡éõ¿iÍBH¶%¿\x1CÀËÉ:"
  b"Ñä¾QhMLå¹BneÞ™\x17"
  b"µ\x18“·®°Cнp™àñ{ñð"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.25 ms
(0.63%) 		1 
# product-listing::load-sortings::read
SELECT `product_sorting`.`id` AS `product_sorting.id`, `product_sorting`.`locked` AS `product_sorting.locked`, `product_sorting`.`url_key` AS `product_sorting.key`, `product_sorting`.`priority` AS `product_sorting.priority`, `product_sorting`.`active` AS `product_sorting.active`, `product_sorting`.`fields` AS `product_sorting.fields`, `product_sorting`.`created_at` AS `product_sorting.createdAt`, `product_sorting`.`updated_at` AS `product_sorting.updatedAt`, `product_sorting.translation.label`, COALESCE(`product_sorting.translation.label`,`product_sorting.translation.label`) AS `product_sorting.label`, `product_sorting.translation.createdAt`, `product_sorting.translation.updatedAt`, `product_sorting.translation.productSortingId`, `product_sorting.translation.languageId` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.product_sorting_id, `product_sorting.translation`.label AS `product_sorting.translation.label`, `product_sorting.translation`.created_at AS `product_sorting.translation.createdAt`, `product_sorting.translation`.updated_at AS `product_sorting.translation.updatedAt`, `product_sorting.translation`.product_sorting_id AS `product_sorting.translation.productSortingId`, `product_sorting.translation`.language_id AS `product_sorting.translation.languageId` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.language_id = ?) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"!\x16\x03O2ìL¡ó┴\x1A\x16/\x10Ø8"
  b"X\óþfŠLý°\x1C€,~\x1C‰‰"
  b"\x06¯õØö˜A¢«…MÄÖ^Ð\t"
  b"¦åa…]ÏG⯌ó\x0F•Lîs"
  b"àËØ╩[ÕM)à$]│\x1AÒß╦"
  b"(\x04\x12fQ}OÞïØÃT¹áN}"
  b"\vë7¾sâK\x16œUzW×BÔ|"
  b"RlË¥róD6”\x16Dðw¾æÆ"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.21 ms
(0.61%) 		1 
# category::cms-page::association::sections::association::blocks::read
SELECT `cms_block`.`id` AS `cms_block.id`, `cms_block`.`position` AS `cms_block.position`, `cms_block`.`type` AS `cms_block.type`, `cms_block`.`locked` AS `cms_block.locked`, `cms_block`.`name` AS `cms_block.name`, `cms_block`.`section_position` AS `cms_block.sectionPosition`, `cms_block`.`margin_top` AS `cms_block.marginTop`, `cms_block`.`margin_bottom` AS `cms_block.marginBottom`, `cms_block`.`margin_left` AS `cms_block.marginLeft`, `cms_block`.`margin_right` AS `cms_block.marginRight`, `cms_block`.`background_color` AS `cms_block.backgroundColor`, `cms_block`.`background_media_id` AS `cms_block.backgroundMediaId`, `cms_block`.`background_media_mode` AS `cms_block.backgroundMediaMode`, `cms_block`.`css_class` AS `cms_block.cssClass`, `cms_block`.`visibility` AS `cms_block.visibility`, `cms_block`.`cms_section_id` AS `cms_block.sectionId`, `cms_block`.`custom_fields` AS `cms_block.customFields`, `cms_block`.`version_id` AS `cms_block.versionId`, `cms_block`.`cms_section_version_id` AS `cms_block.cmsSectionVersionId`, `cms_block`.`created_at` AS `cms_block.createdAt`, `cms_block`.`updated_at` AS `cms_block.updatedAt`, `cms_block.backgroundMedia`.`id` AS `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` AS `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` AS `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` AS `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` AS `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` AS `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` AS `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` AS `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` AS `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` AS `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`config` AS `cms_block.backgroundMedia.config`, `cms_block.backgroundMedia`.`path` AS `cms_block.backgroundMedia.path`, `cms_block.backgroundMedia`.`private` AS `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` AS `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`created_at` AS `cms_block.backgroundMedia.createdAt`, `cms_block.backgroundMedia`.`updated_at` AS `cms_block.backgroundMedia.updatedAt`, `cms_block.backgroundMedia.translation.title`, COALESCE(`cms_block.backgroundMedia.translation.title`,`cms_block.backgroundMedia.translation.title`) AS `cms_block.backgroundMedia.title`, `cms_block.backgroundMedia.translation.alt`, COALESCE(`cms_block.backgroundMedia.translation.alt`,`cms_block.backgroundMedia.translation.alt`) AS `cms_block.backgroundMedia.alt`, `cms_block.backgroundMedia.translation.customFields`, COALESCE(`cms_block.backgroundMedia.translation.customFields`,`cms_block.backgroundMedia.translation.customFields`) AS `cms_block.backgroundMedia.customFields`, `cms_block.backgroundMedia.translation.createdAt`, `cms_block.backgroundMedia.translation.updatedAt`, `cms_block.backgroundMedia.translation.mediaId`, `cms_block.backgroundMedia.translation.languageId` FROM `cms_block` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation`.media_id, `cms_block.backgroundMedia.translation`.title AS `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.alt AS `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation`.custom_fields AS `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation`.created_at AS `cms_block.backgroundMedia.translation.createdAt`, `cms_block.backgroundMedia.translation`.updated_at AS `cms_block.backgroundMedia.translation.updatedAt`, `cms_block.backgroundMedia.translation`.media_id AS `cms_block.backgroundMedia.translation.mediaId`, `cms_block.backgroundMedia.translation`.language_id AS `cms_block.backgroundMedia.translation.languageId` FROM `media_translation` `cms_block.backgroundMedia.translation` WHERE `cms_block.backgroundMedia.translation`.language_id = ?) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation`.`media_id` = `cms_block.backgroundMedia`.`id` WHERE (`cms_block`.`version_id` = ?) AND ((`cms_block`.`cms_section_id` IN (?, ?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\e€¢£ø\fInªÞ€\x13àÅi£"
  b"Ôb\x13:\x08ÝHA­\x05kó\x01ó\x17="
]
View formatted query    View runnable query    Explain query    View query backtrace
1.16 ms
(0.59%) 		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
1.16 ms
(0.58%) 		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.15 ms
(0.58%) 		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
1.15 ms
(0.58%) 		1 
# manufacturer-aggregation::read
SELECT `product_manufacturer`.`id` AS `product_manufacturer.id`, `product_manufacturer`.`version_id` AS `product_manufacturer.versionId`, `product_manufacturer`.`media_id` AS `product_manufacturer.mediaId`, `product_manufacturer`.`link` AS `product_manufacturer.link`, `product_manufacturer`.`created_at` AS `product_manufacturer.createdAt`, `product_manufacturer`.`updated_at` AS `product_manufacturer.updatedAt`, `product_manufacturer.translation.name`, COALESCE(`product_manufacturer.translation.name`,`product_manufacturer.translation.name`) AS `product_manufacturer.name`, `product_manufacturer.translation.description`, COALESCE(`product_manufacturer.translation.description`,`product_manufacturer.translation.description`) AS `product_manufacturer.description`, `product_manufacturer.translation.customFields`, COALESCE(`product_manufacturer.translation.customFields`,`product_manufacturer.translation.customFields`) AS `product_manufacturer.customFields`, `product_manufacturer.translation.createdAt`, `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation.languageId`, `product_manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.product_manufacturer_id, `product_manufacturer.translation`.product_manufacturer_version_id, `product_manufacturer.translation`.name AS `product_manufacturer.translation.name`, `product_manufacturer.translation`.description AS `product_manufacturer.translation.description`, `product_manufacturer.translation`.custom_fields AS `product_manufacturer.translation.customFields`, `product_manufacturer.translation`.created_at AS `product_manufacturer.translation.createdAt`, `product_manufacturer.translation`.updated_at AS `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation`.product_manufacturer_id AS `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation`.language_id AS `product_manufacturer.translation.languageId`, `product_manufacturer.translation`.product_manufacturer_version_id AS `product_manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer_translation` `product_manufacturer.translation` WHERE `product_manufacturer.translation`.language_id = ?) `product_manufacturer.product_manufacturer_translation` ON `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product_manufacturer`.`id` AND `product_manufacturer.product_manufacturer_translation`.product_manufacturer_version_id = `product_manufacturer`.version_id WHERE (`product_manufacturer`.`version_id` = ?) AND (`product_manufacturer`.`id` IN (?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"ã÷ÁíøëL\x00¼ÝM¼|\t}"
  b"\x1C7\x00µ`\x17GÁì\x1E\x06‗▓ \x0EÚ"
  b"\x05Ä°u÷(Dd‹RÍ >u\x0F'"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.13 ms
(0.57%) 		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
1.10 ms
(0.56%) 		3 
SELECT `base_class` AS `baseClass`, `author`
                FROM `plugin`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.10 ms
(0.55%) 		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
1.09 ms
(0.55%) 		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.03 ms
(0.52%) 		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.03 ms
(0.52%) 		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.99 ms
(0.50%) 		1 
# product-listing-loader::resolve-previews
            SELECT
                parent.variant_listing_config AS variantListingConfig,
                LOWER(HEX(child.id)) AS id,
                LOWER(HEX(parent.id)) AS parentId
             FROM product AS child
                INNER JOIN product AS parent
                    ON parent.id = child.parent_id
                    AND parent.version_id = child.version_id
             WHERE child.version_id = ?
             AND child.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"]ÿ¥Ô¼RI˜’F\x0EIC„»í"
  b"""
    &ü‡•ã\x19KN‰À,Þ\n
    m·õ
    """
  b"n\e§Ù\x12═MTÅı─B\x03ʾv"
  b"µ£U3ìbNé©ÑÊ\x15QJùâ"
  b"╗\x05\x04Z-ÅHÂçèå6Á.\x17r"
  b"Ô4ïANYFaˆBû*±¢ýE"
  b"­|¼U/ÝD”šM¼c·›]7"
  b"ìÛq░[\x18IX¥j°¡Ü3┐Æ"
  b"±s,ÿjÅE*šá=\x1DÝ9\x1Eõ"
  b"÷}}\x05;ÆAg…xu²r\x1Aëû"
  b"—JÃöb\x0EFDŒºªh:_'•"
  b"\x16)V\føïH!†Ü¸rJ!Sn"
  b"q_1aV\x14OÕ¾’Æ\x19Ÿœ¼]"
  b"éÏ8èhŠFe‹\x04\x07Ú<œx8"
  b"òÃùõ\x08ßJÙ░xÁÉYoıê"
  b"\x1E`!óòêLh¥ÞäøGƒ\x0F•"
  b"B╩\x003èIAÉå▀╔ôå¡¥V"
  b"[±md\AA{“%Þÿ&” ®"
  b"q\x10›ÊÜ£JA³}<u/ø‹®"
  b"`9Æ7áÌ@\x05ƒjÉ─┌ü7\x1D"
  b" åi†2¬H}ˆ3¨f\x08+ó<"
  b"=fÖ\fh\K\x1EŽÀÎ#¦›Å¢"
  b"‹]³gRI@ȈH\x17ÜÚ‚¾f"
  b"h\tÂÙî´D/£0÷%¡m\x16š"
  b";¨Õ\x0Eí½Hš¤®l¨6\x04º÷"
  b"╔\x02³¢\x05%G╔ú\x03¸B`Ì^É"
  b"n\x12\vθúD±‘?æ¿T’?ë"
  b"ö9Ò\x01\x0F%Hp•—\f´c$\x11,"
  b"×Y4s~YF«ˆàלî©ýµ"
  b"""
    ädxÆjIC]±/E\n
    šq’¤
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.97 ms
(0.49%) 		1 
# category::data::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"X}ƒ  i@¹·ïÞœ'Ë&}"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.96 ms
(0.49%) 		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.95 ms
(0.48%) 		1 
# product-price-calculator::units::read
SELECT `unit`.`id` AS `unit.id`, `unit`.`created_at` AS `unit.createdAt`, `unit`.`updated_at` AS `unit.updatedAt`, `unit.translation.shortCode`, COALESCE(`unit.translation.shortCode`,`unit.translation.shortCode`) AS `unit.shortCode`, `unit.translation.name`, COALESCE(`unit.translation.name`,`unit.translation.name`) AS `unit.name`, `unit.translation.customFields`, COALESCE(`unit.translation.customFields`,`unit.translation.customFields`) AS `unit.customFields`, `unit.translation.createdAt`, `unit.translation.updatedAt`, `unit.translation.unitId`, `unit.translation.languageId` FROM `unit` LEFT JOIN (SELECT `unit.translation`.unit_id, `unit.translation`.short_code AS `unit.translation.shortCode`, `unit.translation`.name AS `unit.translation.name`, `unit.translation`.custom_fields AS `unit.translation.customFields`, `unit.translation`.created_at AS `unit.translation.createdAt`, `unit.translation`.updated_at AS `unit.translation.updatedAt`, `unit.translation`.unit_id AS `unit.translation.unitId`, `unit.translation`.language_id AS `unit.translation.languageId` FROM `unit_translation` `unit.translation` WHERE `unit.translation`.language_id = ?) `unit.unit_translation` ON `unit.unit_translation`.`unit_id` = `unit`.`id`
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.92 ms
(0.46%) 		1 
# category::cms-page::association::sections::read
SELECT `cms_section`.`id` AS `cms_section.id`, `cms_section`.`position` AS `cms_section.position`, `cms_section`.`type` AS `cms_section.type`, `cms_section`.`locked` AS `cms_section.locked`, `cms_section`.`name` AS `cms_section.name`, `cms_section`.`sizing_mode` AS `cms_section.sizingMode`, `cms_section`.`mobile_behavior` AS `cms_section.mobileBehavior`, `cms_section`.`background_color` AS `cms_section.backgroundColor`, `cms_section`.`background_media_id` AS `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` AS `cms_section.backgroundMediaMode`, `cms_section`.`css_class` AS `cms_section.cssClass`, `cms_section`.`cms_page_id` AS `cms_section.pageId`, `cms_section`.`visibility` AS `cms_section.visibility`, `cms_section`.`custom_fields` AS `cms_section.customFields`, `cms_section`.`version_id` AS `cms_section.versionId`, `cms_section`.`cms_page_version_id` AS `cms_section.cmsPageVersionId`, `cms_section`.`created_at` AS `cms_section.createdAt`, `cms_section`.`updated_at` AS `cms_section.updatedAt`, `cms_section.backgroundMedia`.`id` AS `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` AS `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` AS `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` AS `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` AS `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` AS `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` AS `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` AS `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` AS `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` AS `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`config` AS `cms_section.backgroundMedia.config`, `cms_section.backgroundMedia`.`path` AS `cms_section.backgroundMedia.path`, `cms_section.backgroundMedia`.`private` AS `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` AS `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`created_at` AS `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` AS `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.translation.title`, COALESCE(`cms_section.backgroundMedia.translation.title`,`cms_section.backgroundMedia.translation.title`) AS `cms_section.backgroundMedia.title`, `cms_section.backgroundMedia.translation.alt`, COALESCE(`cms_section.backgroundMedia.translation.alt`,`cms_section.backgroundMedia.translation.alt`) AS `cms_section.backgroundMedia.alt`, `cms_section.backgroundMedia.translation.customFields`, COALESCE(`cms_section.backgroundMedia.translation.customFields`,`cms_section.backgroundMedia.translation.customFields`) AS `cms_section.backgroundMedia.customFields`, `cms_section.backgroundMedia.translation.createdAt`, `cms_section.backgroundMedia.translation.updatedAt`, `cms_section.backgroundMedia.translation.mediaId`, `cms_section.backgroundMedia.translation.languageId` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation`.media_id, `cms_section.backgroundMedia.translation`.title AS `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.alt AS `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation`.custom_fields AS `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation`.created_at AS `cms_section.backgroundMedia.translation.createdAt`, `cms_section.backgroundMedia.translation`.updated_at AS `cms_section.backgroundMedia.translation.updatedAt`, `cms_section.backgroundMedia.translation`.media_id AS `cms_section.backgroundMedia.translation.mediaId`, `cms_section.backgroundMedia.translation`.language_id AS `cms_section.backgroundMedia.translation.languageId` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation`.language_id = ?) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id` WHERE (`cms_section`.`version_id` = ?) AND ((`cms_section`.`cms_page_id` IN (?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x11ࡤëùM\x07É│Ä,×ø╚╚"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.89 ms
(0.45%) 		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
0.88 ms
(0.44%) 		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.87 ms
(0.44%) 		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.86 ms
(0.43%) 		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.86 ms
(0.43%) 		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.82 ms
(0.41%) 		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.81 ms
(0.41%) 		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.78 ms
(0.39%) 		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
0.76 ms
(0.38%) 		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.75 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.74 ms
(0.37%) 		1 
# category::cms-page::read
SELECT `cms_page`.`id` AS `cms_page.id`, `cms_page`.`version_id` AS `cms_page.versionId`, `cms_page`.`type` AS `cms_page.type`, `cms_page`.`entity` AS `cms_page.entity`, `cms_page`.`css_class` AS `cms_page.cssClass`, `cms_page`.`config` AS `cms_page.config`, `cms_page`.`preview_media_id` AS `cms_page.previewMediaId`, `cms_page`.`locked` AS `cms_page.locked`, `cms_page`.`created_at` AS `cms_page.createdAt`, `cms_page`.`updated_at` AS `cms_page.updatedAt`, `cms_page.translation.name`, COALESCE(`cms_page.translation.name`,`cms_page.translation.name`) AS `cms_page.name`, `cms_page.translation.customFields`, COALESCE(`cms_page.translation.customFields`,`cms_page.translation.customFields`) AS `cms_page.customFields`, `cms_page.translation.createdAt`, `cms_page.translation.updatedAt`, `cms_page.translation.cmsPageId`, `cms_page.translation.languageId`, `cms_page.translation.cmsPageVersionId` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.cms_page_id, `cms_page.translation`.cms_page_version_id, `cms_page.translation`.name AS `cms_page.translation.name`, `cms_page.translation`.custom_fields AS `cms_page.translation.customFields`, `cms_page.translation`.created_at AS `cms_page.translation.createdAt`, `cms_page.translation`.updated_at AS `cms_page.translation.updatedAt`, `cms_page.translation`.cms_page_id AS `cms_page.translation.cmsPageId`, `cms_page.translation`.language_id AS `cms_page.translation.languageId`, `cms_page.translation`.cms_page_version_id AS `cms_page.translation.cmsPageVersionId` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.language_id = ?) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.cms_page_version_id = `cms_page`.version_id WHERE (`cms_page`.`version_id` = ?) AND (`cms_page`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x11ࡤëùM\x07É│Ä,×ø╚╚"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.72 ms
(0.36%) 		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.70 ms
(0.35%) 		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.67 ms
(0.34%) 		1 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"±\x10.s\x1EÂL\x14¨\x03K'³EXš"
  "37ijtJ5q12yX38hzoeHrleuQBh28gu4X"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.67 ms
(0.34%) 		1 
# product-listing-route::category-loading::search-ids
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?)) LIMIT 1
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"X}ƒ  i@¹·ïÞœ'Ë&}"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.66 ms
(0.33%) 		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"Pè V,ÖO╚ضE}å§┘["
  b"UÞy¦íÊB¶µ#@™wßû,"
  b"Ve¬k—ª@O§\x1CÝ—dö2Ò"
  b"[×4\x14%\x19Di–g\rôµ’]6"
  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
0.64 ms
(0.32%) 		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.63 ms
(0.32%) 		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.63 ms
(0.32%) 		1 
# product-listing-route::category-loading::read
SELECT `category`.`id` AS `category.id`, `category`.`version_id` AS `category.versionId`, `category`.`product_assignment_type` AS `category.productAssignmentType`, `category`.`product_stream_id` AS `category.productStreamId` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"X}ƒ  i@¹·ïÞœ'Ë&}"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.59 ms
(0.30%) 		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.58 ms
(0.29%) 		1 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(0.29%) 		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.28%) 		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.56 ms
(0.28%) 		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.54 ms
(0.27%) 		1 
SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.54 ms
(0.27%) 		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.52 ms
(0.26%) 		1 
# product-listing::load-sortings::search-ids
SELECT `product_sorting`.`id` FROM `product_sorting` WHERE (`product_sorting`.`active` = ?) ORDER BY `product_sorting`.`priority` DESC
Parameters: 
[
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.49 ms
(0.25%) 		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š"
  "19-Schraenke/Schrankzubehoer/"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.49 ms
(0.25%) 		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.46 ms
(0.23%) 		1 
DELETE FROM `cart` WHERE `token` = :token
Parameters: 
[
  "token" => "37ijtJ5q12yX38hzoeHrleuQBh28gu4X"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.45 ms
(0.23%) 		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.45 ms
(0.22%) 		1 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.44 ms
(0.22%) 		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.38 ms
(0.19%) 		1 
SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(0.18%) 		1 
#cart-persister::load
                SELECT `cart`.`cart` AS payload, `cart`.`rule_ids`, 0 AS `compressed` FROM cart WHERE `token` = ?
Parameters: 
[
  "37ijtJ5q12yX38hzoeHrleuQBh28gu4X"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(0.10%) 		1 
SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.