GET https://staging.broga.ch/page/cms/4525b2766c164d8896c462275cbd9e3f

Response
200 OK
IP
216.73.217.47
Profiled on
Token
6022f9

Query Metrics

69 Database Queries
45 Different statements
57.57 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
16.51 ms
(28.67%) 		3 
SELECT `scop_platform_redirecter_redirect`.`id` FROM `scop_platform_redirecter_redirect` WHERE ((`scop_platform_redirecter_redirect`.`sourceURL` IN (?, ?, ?, ?, ?, ?, ?)) AND `scop_platform_redirecter_redirect`.`enabled` = ? AND (`scop_platform_redirecter_redirect`.`salesChannelId` = ? OR `scop_platform_redirecter_redirect`.`salesChannelId` <=> ?)) LIMIT 1
Parameters: 
[
  "//page/cms/4525b2766c164d8896c462275cbd9e3f"
  "/page/cms/4525b2766c164d8896c462275cbd9e3f"
  "https://staging.broga.ch/page/cms/4525b2766c164d8896c462275cbd9e3f"
  "https://staging.broga.ch//page/cms/4525b2766c164d8896c462275cbd9e3f"
  "/page/cms/4525b2766c164d8896c462275cbd9e3f"
  "//page/cms/4525b2766c164d8896c462275cbd9e3f"
  "page/cms/4525b2766c164d8896c462275cbd9e3f"
  true
  b"'\x7Fi\x17\x16§C –ü6N;P¨"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
8.27 ms
(14.37%) 		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/e83629e5135f41d590e32b887027547a"
  "/navigation/7dcc60db207140cd8dec4fce9b01974f"
  "/navigation/0c688d584cc646159a9d75bbfe5ffc49"
  "/navigation/98ec13c9838f4539a3df90fcdd7676b6"
  "/navigation/5c07fdfc62a94168bac7ca2f1a4fa987"
  "/navigation/f988e257ef954fae96a546a0cb33febb"
  "/navigation/78e18a67bd0d458badb141a4bac9e88a"
  "/navigation/c63ca699eca249f5967e434bf56b00df"
  "/navigation/a610ead38c86498abfccc809b61834ff"
  "/navigation/55abe0a70e3a4f3193b85a6459272839"
  "/navigation/82df8525de914532a41908312e9f2199"
  "/navigation/06772c8521c8415b8875a2e1bb4f3f82"
  "/navigation/27a9a152b73b45959d2a7daea3b10ca9"
  "/navigation/b19a1e0a50db43798df4547e020d308c"
  "/navigation/08725f66081447559e8bb50b8945e927"
  "/navigation/9975b54bcae7483e92a8d8f0e5896575"
  "/navigation/53bf0f729eff4559af0a9ba96f2d1951"
  "/navigation/f99fb8489ed84f7bbbd202e1f22f35f0"
  "/navigation/3b5b6b8555d740d995b64f685af83dcc"
  "/navigation/990538e48f9b4ccaac3009e2674bb4c6"
  "/navigation/edbae79a57ec4b47977acf71a977035e"
  "/navigation/6d7ad788bec64512aa8bea4e81b20866"
  "/navigation/1a8dbd84791640ea9f8824c9f3f7c9f4"
  "/navigation/3ed74ddceda347b88278fa59926bd39d"
  "/navigation/e3563f60298843a8856c76d5d889a318"
  "/navigation/7eb828faacab4289b515061af62e5997"
  "/navigation/741a0be18699409e811b1c67177ebb18"
  "/navigation/526b39ed41624de98398b4110b4ea631"
  "/navigation/e5f25694afd84bda8ecddcd7e57a1104"
  "/navigation/1519f91d4a35474aaed0c10d509cbf4d"
  "/navigation/0e5a8b049e444079b13b9186a74c276d"
  "/navigation/14ee07a661e647a1ae2cb14e61bee969"
  "/navigation/f089a582104f4201817aefe0b381b44b"
  "/navigation/ac869290095c4ddf8ed9c9c2ac71b92a"
  "/navigation/89cc42d4c7cd41beacff403eb3276239"
  "/navigation/d16b3827962f46e0ac4f948e05eeb5ab"
  "/navigation/09d5356a087c41fa8856f63800b7e75c"
  "/navigation/3b1c88b919324029a9ec9e1084abc005"
  "/navigation/1b262223e37241ba91ce3832a192d7d7"
  "/navigation/ac557f8f8f37444db0429e223a8eac2e"
  "/navigation/354336a3786f4507a4963b4b893ce496"
  "/navigation/12367ed3443846e99a2bf64a2d654e32"
  "/navigation/932daaa17ff349d38ae6cd04a6e7ed29"
  "/navigation/7133d36f771f412eb4ee515cd407ffa9"
  "/navigation/7e4a9556740c4b09b3821b7a0c7d90db"
  "/navigation/43e2d607038a47d9a272fabb7f21db82"
  "/navigation/97b4e808231b4a589400e10787902ef4"
  "/navigation/269d06780368436ea8e0e7fa502f0ece"
  "/navigation/c5d66dd92a2b4372b2b0059ec5312b54"
  "/navigation/20a169c6485e4dd694e1582540698aed"
  "/navigation/5443ec72c9e34f17915c445d399279a2"
  "/navigation/4b201df9acbf474abbd6c15d38d261dc"
  "/navigation/1bc382df932a47ce975b20b22cd201f3"
  "/navigation/edcc6fad0d2141a5b7ea60db6afe2ac5"
  "/navigation/ee010008b98e473faf8da636b33522d8"
  "/navigation/a29fdd8ffa80477c9a28f21007ddbc7b"
  "/navigation/3ea2fda8f3d64013a1e1bc0722bd4ffa"
  "/navigation/75feed4edb9b4fd4b04a51c3e5356c50"
  "/navigation/fb9efe1d16be4cd083a5257842172977"
  "/navigation/7008c11a99834a1dac890ed98aa550bd"
  "/navigation/9399105cde0e4b8d97f3521d762b47ee"
  "/navigation/a9d547974c0c42329b7124f575168a09"
  "/navigation/b4dc490c36394c57821223776f053aff"
  "/navigation/93b85c1893eb4735866880ffa95fd335"
  "/navigation/a2cb5d696b7a4a35b690a76adad86579"
  "/navigation/3a70bc62bf1848f3a675beff9e300ad6"
  "/navigation/382afdfc63054970ae0d9b786be17694"
  "/navigation/29ea11cb0a28438c8278f9eea788bd8b"
  "/navigation/e70ed45be9484212bfd99b27dd284551"
  "/navigation/f44c0aa810b74f65a9274027de4ce7c5"
  "/navigation/fff98b615f26425ca8161b461143d3d4"
  "/navigation/c424fed4e033454ca2dd202aec18e4de"
  "/navigation/461dcf6f41754fe3afdf8e7510822251"
  "/navigation/846792cd92504c37a0d8f57a261d2bfd"
  "/navigation/f2479df368294dbba2b1ba61f523d040"
  "/navigation/733604c03aac4f549ac363619ea46034"
  "/navigation/1bf716af846b43e695a3b552462bc5f4"
  "/navigation/f520f42058e446b5bf1ffa23caad1c16"
  "/navigation/68cddb0b5546468eba180ccf9d3100b1"
  "/navigation/f1da0d51c4814215bdc968858e765f92"
  "/navigation/7d1c01e297224894954518d57e9e1c12"
  "/navigation/c0345bef261340678c79c55a9367a7cb"
  "/navigation/2bb02a67eb6a4d0388a72e9bb7dae4df"
  "/navigation/01962e0b8f5775458bbe336f491aada5"
  "/navigation/bb4f07d38f1448dc8bd454fd8a00b032"
  "/navigation/ecc3083eb9d8498d88df6c4c840d3c60"
  "/navigation/5e87be8afe9e4977b5062be542300d4c"
  "/navigation/d70e7b6934ff41aea376b879478b0b25"
  "/navigation/5fd22ba285ed43e699ba1fd99d39cbe8"
  "/navigation/cc199d66403f48cb8e60d7d0f4e05c65"
  "/navigation/5f334eb5c00b49179a3c0046f4b5ebde"
  "/navigation/6ed6d9c7551d48cba28cbc4daf8d4019"
  "/navigation/2f1f298ebc2546e18a7c747ab94de0a4"
  "/navigation/c38ce758109a4f80bb6b0436b4eab126"
  "/navigation/c80994f86b5546a5936482df255870f3"
  "/navigation/9c49865ebe9b4cfb8b8f80978e9eb184"
  "/navigation/dbc89f4da18f4aefb1be070a4342b475"
  "/navigation/ed392fda5c6a4330a69638d592bb60f6"
  "/navigation/364ad171281542edac305c9447dbf1b7"
  "/navigation/40e37a9c7f4a4989b5c531031fe892ae"
  "/navigation/adfb9e8334184e0ab6a13ff037dcabaf"
  "/navigation/294e1058a3704b8993d3df65afbb0abf"
  "/navigation/e812c3db1dcb4e4fa5dfaa774d007a41"
  "/navigation/3a9f631b85ad468b9ed416f63d042f17"
  "/navigation/124e1027b0f04dbb99346e7a922e5e28"
  "/navigation/fe3d8ed101ec45dcb2f05845bb9a2602"
  "/navigation/0197c23a0ad1758b865d996ce9c414e0"
  "/navigation/b8e4fef5830a488786345f9de2ac0d70"
  "/navigation/0197c2476135782694171565480f4e56"
  "/navigation/58fde7f32abf48949ab952088d8de254"
  "/navigation/8abe413939234d4d9c3938438409f14a"
  "/navigation/83d9f73e1e6c40418374a0c618a2ee77"
  "/navigation/01962e0e095e72099ac3630ad415e6a7"
  "/navigation/c782f41895394fcea0d92ca0a2d35e7c"
  "/navigation/41835df068c04e8487a920ef869d0181"
  "/navigation/d0fe65e0d0fd42fb95410168a7c54388"
  "/navigation/8952d1facea640cab3f7cca2ae889755"
  "/navigation/dd7bd3965ecd429ca16cff0b07db39cf"
  "/navigation/e8096244e57d40db81f2146748377923"
  "/navigation/f34c21026aa7489baca63bb3ed9658c9"
  "/navigation/23ad88cfd0ed4a70ac51cc06bbae5de7"
  "/navigation/8929b60a94824f13b5065fc6bbb9c5a9"
  "/navigation/71b85a4c1c7e4ff0ba221586857275b4"
  "/navigation/e0c604874a4543a6b3ff850a10fc5ca2"
  "/navigation/cd7e77fb371c4fe394e7fddd0fcc3aac"
  "/navigation/01586208c64e4d63861aad1111bce291"
  "/navigation/792251d933a24ff0a69edc95c1e08dd7"
  "/navigation/0a38e0f02b2a412aa959ab65969f002a"
  "/navigation/d9f538589347464d8ac3378fd478b577"
  "/navigation/5e425da91d934c7da1fcb09a75a53f5a"
  "/navigation/a95365cf91944adf9699d4ccd70e193e"
  "/navigation/132296ff9df44b2faeae7c1b649b412d"
  "/navigation/7bfe986de8ca4ac7ad4d2c007005b05e"
  "/navigation/938978c543274408a7723ed913f58fac"
  "/navigation/f304390b9bdf4e19861051ca8cff6e16"
  "/navigation/1ba7c08d082e476a92590810ef872419"
  "/navigation/26ee2f4c2d5f4888ac15926398378451"
  "/navigation/bcd328a6a16746aebe64531780c72184"
  "/navigation/317164abe25f4ec1980d2fba829171b3"
  "/navigation/01996d44ddab7d4198dd83f13cabbdb2"
  "/navigation/e15e646eb58b448eafaa4157b2b64c50"
  "/navigation/33e7bd5d19e84328862041c958449104"
  "/navigation/007a0957e30b4aa1b76a44bd4d4be5f1"
  "/navigation/01962e0c37357aaa8dbe30aeb3ab9cc7"
  "/navigation/af90776707054575994ecf59706b36c7"
  "/navigation/81cafa5d4b9c435d8581c3d890200ac3"
  "/navigation/286f5abd41e64db78e823598c9316551"
  "/navigation/46bf92baf2ee4081b3d0d0abb3fcc9ff"
  "/navigation/43f7bc97336e4a8bae2aede195ce82fe"
  "/navigation/67ba58622dae4a69a90316f3bb0f469c"
  "/navigation/5a4e25afef7d486ebeb2bc5ecc064bf1"
  "/navigation/5307c64e8b3547d0a87a89b1b3466c1c"
  "/navigation/7303fc33a7124dba9db03f2e1aefb2dd"
  "/navigation/a4541613b9d44915b32aef789a56a620"
  "/navigation/ded4dbdc7f784dbaaad5afe681f3c9a7"
  "/navigation/002a20c977d344178b1c49b44222626b"
  "/navigation/8fd4bf2ae1964beb8ac4da83615b3cf8"
  "/navigation/5508d325869b43a89f64cef713a1c75c"
  "/navigation/b6669fba91e146489f0502f21745c9e9"
  "/navigation/4e18877217e64f1f8644603183879b33"
  "/navigation/428fbda22945422ea0915bbdec1fc954"
  "/navigation/eba113e6c05b47c480b5accde1db858d"
  "/navigation/683565128c074b41aff4ac157dbc10cc"
  "/navigation/3670b1b7fcc546708dc76b565c1ce762"
  "/navigation/6927b17889fa49c1a529f66925d6c98b"
  "/navigation/1c33fb0e865747c9a7842416d54dc81b"
  "/navigation/95bdae13a8394c9ea86a1062cb65f682"
  "/navigation/8d5c93821a494731bf066ad3888be333"
  "/navigation/01962e0ea894779cb6927535ddcb8762"
  "/navigation/2fbe3c5f811440e98ba7a34d2dde0c38"
  "/navigation/c3f2d22fc7d1417b8af17ea301161d69"
  "/navigation/141dbc94a726453d83d2e9e9d9fd5952"
  "/navigation/a7b3fdedfb3b483b8fa0a448c9ac48ce"
  "/navigation/6fcd4027306d42e2bfa7eb52097ebd84"
  "/navigation/958f64a103ae4f2095cf91094a6540dd"
  "/navigation/c1ee9517a3dc4c47b250f1a078a7699f"
  "/navigation/d16e447d58f04cbb9e83c06bee92e4e7"
  "/navigation/2da295c68cc74c2e8ebb317412179d61"
  "/navigation/65d80515382640ad9d9f64b92736f9ba"
  "/navigation/1ddeaa4681f24b8192a18edbf1eab8f0"
  "/navigation/1f3709bb5e504fa0a7445b8596ce525c"
  "/navigation/6f6d279edec941d682f612f3c1fadc2a"
  "/navigation/3aea257809b54203b797ab2eebb0879a"
  "/navigation/ed99d8adef4c4c7983000ab051792ccc"
  "/navigation/359aa2cd085943d7b13f041b70ee950e"
  "/navigation/8ca722a2d45440e0b3e4d8db2158d481"
  "/navigation/2f845b4db4434b99949f1de793b1e38d"
  "/navigation/24c89d02fd844e418d1d7ab6d8f44732"
  "/navigation/8c471e2ebf404a4f8f7605ce0ea6b1cf"
  "/navigation/41e0321849b845698e6c5cd6b7bc23a1"
  "/navigation/036a4572128e49f8a11a01c204731d96"
  "/navigation/501e21a94fdb4020826e2103dd8bb47b"
  "/navigation/e5f11eb8aa5345d1b7069f96b8562987"
  "/navigation/ca66a1ef91e548569a191d69a70a785d"
  "/navigation/14bf1766dec248379c432af25afad80e"
  "/navigation/9d628ac14d6244569340d6d4105abd1f"
  "/navigation/9d16ccb4c554411ab1e6fd2e9553af10"
  "/navigation/4039b457cd6d4b77985cb53feb2e2308"
  "/navigation/6a9fc05f62de471cbabc238867cef88a"
  "/navigation/4b58725ebf0044ed8fc45510563066a1"
  "/navigation/ae238af4ebe34cd8b7915ce767f5e1aa"
  "/navigation/c7da30b915a24886826b59641f6dfec9"
  "/navigation/a23e12aea8634381ab16825d9868abc0"
  "/navigation/c16b62ef3e7a401cbb567109594f3119"
  "/navigation/0197bb6869bd7cd88be6310e5e81876e"
  "/navigation/0197bb689a3278be9cee151bbe0cfabb"
  "/navigation/0197bb68ba927d2a914cebd2620bcca8"
  "/navigation/0197bb68f02679299f58a7b278f35dda"
  "/navigation/0197bb6b786f791db8b637b78440ee29"
  "/navigation/4c4bc11aec234f9c982cf414178c12c6"
  "/navigation/66f514326f684dbc8ac069759f1296bb"
  "/navigation/073002b38c7d404d9ba1459e0f1f0ea5"
  "/navigation/598c53ff4fdf4e59a984c39647e73dae"
  "/navigation/c7a03cd8fca64450a3975b3d6379bfdd"
  "/navigation/30176d624bbc42e39df40f2d813ef659"
  "/navigation/d943b59ac8c7430cb0f3d0ddb16a1104"
  "/navigation/249e3e9d308946b8a4e8d475804bedc4"
  "/navigation/d0062de8d4384ef8aec21ecd570960e9"
  "/navigation/725508179877433ebe410cb9166acacf"
  "/navigation/2a1efdc0d7be46d3b2f20546d81700e3"
  "/navigation/f4f6342f7466434b95e401d4e1c3ae43"
  "/navigation/fbc22b3b1d414d2a9a209c03d94f393b"
  "/navigation/b5ac71d784024d4dadd665318be7400b"
  "/navigation/c973843c2efa41b59a24eec7bbb52aa5"
  "/navigation/6824dc544d274b2c867662984717efcb"
  "/navigation/db943b0d31b24f43b87c082d3a415c7c"
  "/navigation/a51d5e564b084a0199eb7b83674deceb"
  "/navigation/9e81ad97ec194f3385d43caf7b2bc891"
  "/navigation/be63308b3fdf49ed8842b1d0fcda5ffc"
  "/navigation/cc146923283f4752ac4530f092546542"
  "/navigation/b79f4d994d4b4602a7c92b27bbbb4576"
  "/navigation/71510c93962443f8ab51aec70a1cc347"
  "/navigation/9d898a6a445e4227a469025de5a1bf1e"
  "/navigation/0c93538c7c3048958b9bdb6e0d0a461f"
  "/navigation/10aa104045384921b140378c5839271b"
  "/navigation/05e5fa89ce874ebb9e42c7029e1074c1"
  "/navigation/012446ebb05a4f4fa75f513d00b45bbb"
  "/navigation/035e8d7fa5c04fa3bea112a30de71ccc"
  "/navigation/67fedd8ed38149a99dcf8b18e2ffc289"
  "/navigation/31d3408441b24ee48fb536df085b8683"
  "/navigation/019aaeeb51c47b148e65794e55707373"
  "/navigation/d19908aebfb24892906007ea2f07922d"
  "/navigation/3ff521c5e8184e8ea242969871020209"
  "/navigation/66c877b0d00b4d5db76f6729d631bd62"
  "/navigation/febf7f280e5242bea896c74009f77e48"
  "/navigation/808e9119d6284ec197f37de059d64017"
  "/navigation/e0be1ed09b5e4c599f7baa38169a58fc"
  "/navigation/7e7b28a44a3b432c9efdf30fdb97f685"
  "/navigation/6c5ade3a2d864b22bc34a66f34d7ac93"
  "/navigation/019411a21c747167aad251c4c97c0816"
  "/navigation/3f7ce87b7d754654af53fef484c046a3"
  "/navigation/28afa100d7864bd4804f8aeed5ccdc9a"
  "/navigation/4674d75a14c24d8aab5e77749b1d2bf3"
  "/navigation/fdc46bc69cc3460483f33d0d0023875b"
  "/navigation/56b1860291a740ae929437855a4fbcfe"
  "/navigation/9f4a1eb8a34042188e84072d30003211"
  "/navigation/ebf81c3143e34afd989262bc16539aa2"
  "/navigation/06f1d995999f4ec0b9eb020e56cf0e96"
  "/navigation/d611d5fc2f304d98bbf3d4745a175a1e"
  "/navigation/3c77e8b4a959474981e7549a58ddc105"
  "/navigation/f9ae68a531b94b9fa0e309ed9d9198b9"
  "/navigation/dd91f28abd684d9f9b35dfcf0c9696a5"
  "/navigation/41f0b9bd91c5460e9d76fe54c3cd7710"
  "/navigation/4231e7d87ca04c7a9b2e1665b3fe6752"
  "/navigation/25f96a791efb4a2fbcf1e32ed9ac8866"
  "/navigation/35c3c87f931e46749fcd5237ab5ba24a"
  "/navigation/0199424dced47005b5d2c2365fae9cc5"
  "/navigation/4004541ccc834fcd87d85c3cbe04aa8a"
  "/navigation/f1dd14c8df11476dbfb899430450fa26"
  "/navigation/cc25289e92b048c6891c00408fd9cf54"
  "/navigation/a6e54ee0b60d4d928190f42b2365febf"
  "/navigation/f2d9fc4249524cd3a05263f6d48bc3e1"
  "/navigation/f4522f2d0b7e4afabd16eb745a3fbb9a"
  "/navigation/865620cba55d449eb57ee34c212329bb"
  "/navigation/9042e4ebef244606a73642982fd4d4b6"
  "/navigation/37869ed70cde466a9797d66519da4b2a"
  "/navigation/b11b72221fb34286b9620a3470914b35"
  "/navigation/8562fe1e80124df286ced8d503dbeb94"
  "/navigation/ac57df7d48b94ba394f3d536cfb65625"
  "/navigation/ac42f8c16cea470ca11437e6200724ac"
  "/navigation/595a908dcbf9484ea87690f937dc6b2d"
  "/navigation/5d8a04194fc4447f9e1693feb14d4b26"
  "/navigation/d865e6687b484fcbb78927c7a19453b8"
  "/navigation/b3c41b1b08b3483dbe88e392b1587544"
  "/navigation/626a2f0bd0924fd7b39b79b60f4037dd"
  "/navigation/b70e1846aa584624821798f62322a2ef"
  "/navigation/37eb6597258c4e7eb3dc2b74c85f478d"
  "/navigation/e2b5d7065fcf4ed081f266ff7d7e8a09"
  "/navigation/ee8f3eacb3bf49c183d1385d0e6901ac"
  "/navigation/b665418c2c7648b197f4c67b5b69fe48"
  "/navigation/8169c0ce74c44ae7a2456bded58d2baf"
  "/navigation/3e419c30222a44139fc46af364b88166"
  "/navigation/019abee8c17f75e4a5cae0a29d9f81b4"
  "/navigation/e9d679ad8e0c4f3fbe9aafb87b5e2e0c"
  "/navigation/f4df062e20484ad3b9b886ecf2597024"
  "/navigation/c393876fcba8414598572fb23277f306"
  "/navigation/3120f84ee9c44fd2aa513638a10f4cc6"
  "/navigation/2b081189c4e044088cb53e9040896f94"
  "/navigation/db39e1aa08c84f64a86b34d246c943c8"
  "/navigation/ad75c918bb4d4c8bbd296d3dcefb23ee"
  "/navigation/1931095699d54f9c90e16a53fa269b7e"
  "/navigation/5414a59180824b89815a2615b86f27d3"
  "/navigation/f2450b5adb6640cdaed2400c3fa2e8f0"
  "/navigation/17ad2dcc6978419490e4a5c88f2297bb"
  "/navigation/6987510b26ea4efeb90399ac9c1c86d2"
  "/navigation/68c60a972064487f99504c83873c083e"
  "/navigation/7a979d0df37c4c578beb87eeba2b09af"
  "/navigation/5a5868c93cee4325909dad466bdb43e3"
  "/navigation/9de0d4834eeb404dabb4e475fbf199f5"
  "/navigation/7e9a4f37c924491ab6d525bf675175d2"
  "/navigation/d8b6d2bfdb784061a78c905c3e404d79"
  "/navigation/53ab35fd1fd942c4ad7b7a43db9af932"
  "/navigation/e634ba9b1d464bb9bf70554f6022d867"
  "/navigation/ef96a78af81245ad9190702fb90a32a4"
  "/navigation/018f74d7c703701b93e44f83c50c36bc"
  b"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"'\x7Fi\x17\x16§C –ü6N;P¨"
]
View formatted query    View runnable query    Explain query    View query backtrace
3.50 ms
(6.08%) 		3 
SELECT `acris_price_on_request`.`id` as `acris_price_on_request.id`, `acris_price_on_request`.`version_id` as `acris_price_on_request.versionId`, `acris_price_on_request`.`cms_page_id` as `acris_price_on_request.cmsPageId`, `acris_price_on_request`.`cms_page_version_id` as `acris_price_on_request.cmsPageVersionId`, `acris_price_on_request`.`active` as `acris_price_on_request.active`, `acris_price_on_request`.`priority` as `acris_price_on_request.priority`, `acris_price_on_request`.`default_type` as `acris_price_on_request.defaultType`, `acris_price_on_request`.`price_display` as `acris_price_on_request.priceDisplay`, `acris_price_on_request`.`cart_functionality` as `acris_price_on_request.cartFunctionality`, `acris_price_on_request`.`delivery_display` as `acris_price_on_request.deliveryDisplay`, `acris_price_on_request`.`price_meta_data` as `acris_price_on_request.priceMetaData`, `acris_price_on_request`.`bot_price_display` as `acris_price_on_request.botPriceDisplay`, `acris_price_on_request`.`info_text_position` as `acris_price_on_request.infoTextPosition`, `acris_price_on_request`.`request_button_type` as `acris_price_on_request.requestButtonType`, `acris_price_on_request`.`login_button_type` as `acris_price_on_request.loginButtonType`, `acris_price_on_request`.`use_for` as `acris_price_on_request.useFor`, `acris_price_on_request`.`request_form_position` as `acris_price_on_request.requestFormPosition`, `acris_price_on_request`.`request_cart_button_type` as `acris_price_on_request.requestCartButtonType`, `acris_price_on_request`.`request_cart_display_position` as `acris_price_on_request.requestCartDisplayPosition`, `acris_price_on_request`.`request_cart_icon` as `acris_price_on_request.requestCartIcon`, `acris_price_on_request`.`request_cart_icon_media_id` as `acris_price_on_request.requestCartIconMediaId`, `acris_price_on_request`.`icon_width` as `acris_price_on_request.iconWidth`, `acris_price_on_request`.`created_at` as `acris_price_on_request.createdAt`, `acris_price_on_request`.`updated_at` as `acris_price_on_request.updatedAt`, `acris_price_on_request.requestCartIconMedia`.`id` as `acris_price_on_request.requestCartIconMedia.id`, `acris_price_on_request.requestCartIconMedia`.`user_id` as `acris_price_on_request.requestCartIconMedia.userId`, `acris_price_on_request.requestCartIconMedia`.`media_folder_id` as `acris_price_on_request.requestCartIconMedia.mediaFolderId`, `acris_price_on_request.requestCartIconMedia`.`mime_type` as `acris_price_on_request.requestCartIconMedia.mimeType`, `acris_price_on_request.requestCartIconMedia`.`file_extension` as `acris_price_on_request.requestCartIconMedia.fileExtension`, `acris_price_on_request.requestCartIconMedia`.`uploaded_at` as `acris_price_on_request.requestCartIconMedia.uploadedAt`, `acris_price_on_request.requestCartIconMedia`.`file_name` as `acris_price_on_request.requestCartIconMedia.fileName`, `acris_price_on_request.requestCartIconMedia`.`file_size` as `acris_price_on_request.requestCartIconMedia.fileSize`, `acris_price_on_request.requestCartIconMedia`.`media_type` as `acris_price_on_request.requestCartIconMedia.mediaTypeRaw`, `acris_price_on_request.requestCartIconMedia`.`meta_data` as `acris_price_on_request.requestCartIconMedia.metaData`, `acris_price_on_request.requestCartIconMedia`.`config` as `acris_price_on_request.requestCartIconMedia.config`, `acris_price_on_request.requestCartIconMedia`.`path` as `acris_price_on_request.requestCartIconMedia.path`, `acris_price_on_request.requestCartIconMedia`.`private` as `acris_price_on_request.requestCartIconMedia.private`, `acris_price_on_request.requestCartIconMedia`.`thumbnails_ro` as `acris_price_on_request.requestCartIconMedia.thumbnailsRo`, `acris_price_on_request.requestCartIconMedia`.`file_hash` as `acris_price_on_request.requestCartIconMedia.fileHash`, `acris_price_on_request.requestCartIconMedia`.`created_at` as `acris_price_on_request.requestCartIconMedia.createdAt`, `acris_price_on_request.requestCartIconMedia`.`updated_at` as `acris_price_on_request.requestCartIconMedia.updatedAt`, `acris_price_on_request.requestCartIconMedia.translation.override_1.title`, `acris_price_on_request.requestCartIconMedia.translation.title`, COALESCE(`acris_price_on_request.requestCartIconMedia.translation.override_1.title`,`acris_price_on_request.requestCartIconMedia.translation.title`) as `acris_price_on_request.requestCartIconMedia.title`, `acris_price_on_request.requestCartIconMedia.translation.override_1.alt`, `acris_price_on_request.requestCartIconMedia.translation.alt`, COALESCE(`acris_price_on_request.requestCartIconMedia.translation.override_1.alt`,`acris_price_on_request.requestCartIconMedia.translation.alt`) as `acris_price_on_request.requestCartIconMedia.alt`, `acris_price_on_request.requestCartIconMedia.translation.override_1.customFields`, `acris_price_on_request.requestCartIconMedia.translation.customFields`, COALESCE(`acris_price_on_request.requestCartIconMedia.translation.override_1.customFields`,`acris_price_on_request.requestCartIconMedia.translation.customFields`) as `acris_price_on_request.requestCartIconMedia.customFields`, (SELECT GROUP_CONCAT(HEX(`acris_price_on_request.productStreams.mapping`.`product_stream_id`) SEPARATOR '||')
                  FROM `acris_price_on_request_product_stream` `acris_price_on_request.productStreams.mapping`
                  WHERE `acris_price_on_request.productStreams.mapping`.`price_on_request_id` = `acris_price_on_request`.`id` ) as `acris_price_on_request.productStreams.id_mapping`, `acris_price_on_request.translation.override_1.loginButtonText`, `acris_price_on_request.translation.loginButtonText`, COALESCE(`acris_price_on_request.translation.override_1.loginButtonText`,`acris_price_on_request.translation.loginButtonText`) as `acris_price_on_request.loginButtonText`, `acris_price_on_request.translation.override_1.formButtonText`, `acris_price_on_request.translation.formButtonText`, COALESCE(`acris_price_on_request.translation.override_1.formButtonText`,`acris_price_on_request.translation.formButtonText`) as `acris_price_on_request.formButtonText`, `acris_price_on_request.translation.override_1.requestCartButtonText`, `acris_price_on_request.translation.requestCartButtonText`, COALESCE(`acris_price_on_request.translation.override_1.requestCartButtonText`,`acris_price_on_request.translation.requestCartButtonText`) as `acris_price_on_request.requestCartButtonText`, `acris_price_on_request.translation.override_1.internalName`, `acris_price_on_request.translation.internalName`, COALESCE(`acris_price_on_request.translation.override_1.internalName`,`acris_price_on_request.translation.internalName`) as `acris_price_on_request.internalName`, `acris_price_on_request.translation.override_1.infoText`, `acris_price_on_request.translation.infoText`, COALESCE(`acris_price_on_request.translation.override_1.infoText`,`acris_price_on_request.translation.infoText`) as `acris_price_on_request.infoText`, `acris_price_on_request.translation.override_1.infoTextBefore`, `acris_price_on_request.translation.infoTextBefore`, COALESCE(`acris_price_on_request.translation.override_1.infoTextBefore`,`acris_price_on_request.translation.infoTextBefore`) as `acris_price_on_request.infoTextBefore`, `acris_price_on_request.translation.override_1.infoTextAfter`, `acris_price_on_request.translation.infoTextAfter`, COALESCE(`acris_price_on_request.translation.override_1.infoTextAfter`,`acris_price_on_request.translation.infoTextAfter`) as `acris_price_on_request.infoTextAfter`, `acris_price_on_request.translation.override_1.productBoxTextBefore`, `acris_price_on_request.translation.productBoxTextBefore`, COALESCE(`acris_price_on_request.translation.override_1.productBoxTextBefore`,`acris_price_on_request.translation.productBoxTextBefore`) as `acris_price_on_request.productBoxTextBefore`, `acris_price_on_request.translation.override_1.productBoxTextAfter`, `acris_price_on_request.translation.productBoxTextAfter`, COALESCE(`acris_price_on_request.translation.override_1.productBoxTextAfter`,`acris_price_on_request.translation.productBoxTextAfter`) as `acris_price_on_request.productBoxTextAfter`, `acris_price_on_request.translation.override_1.slotConfig`, `acris_price_on_request.translation.slotConfig`, COALESCE(`acris_price_on_request.translation.override_1.slotConfig`,`acris_price_on_request.translation.slotConfig`) as `acris_price_on_request.slotConfig`, `acris_price_on_request.translation.override_1.priceText`, `acris_price_on_request.translation.priceText`, COALESCE(`acris_price_on_request.translation.override_1.priceText`,`acris_price_on_request.translation.priceText`) as `acris_price_on_request.priceText` FROM `acris_price_on_request` LEFT JOIN `media` `acris_price_on_request.requestCartIconMedia` ON `acris_price_on_request`.`request_cart_icon_media_id` = `acris_price_on_request.requestCartIconMedia`.`id` LEFT JOIN (SELECT `acris_price_on_request.translation`.`acris_price_on_request_id`, `acris_price_on_request.translation`.`acris_price_on_request_version_id`, `acris_price_on_request.translation`.`internal_name` as `acris_price_on_request.translation.internalName`, `acris_price_on_request.translation.override_1`.`internal_name` as `acris_price_on_request.translation.override_1.internalName`, `acris_price_on_request.translation`.`login_button_text` as `acris_price_on_request.translation.loginButtonText`, `acris_price_on_request.translation.override_1`.`login_button_text` as `acris_price_on_request.translation.override_1.loginButtonText`, `acris_price_on_request.translation`.`form_button_text` as `acris_price_on_request.translation.formButtonText`, `acris_price_on_request.translation.override_1`.`form_button_text` as `acris_price_on_request.translation.override_1.formButtonText`, `acris_price_on_request.translation`.`request_cart_button_text` as `acris_price_on_request.translation.requestCartButtonText`, `acris_price_on_request.translation.override_1`.`request_cart_button_text` as `acris_price_on_request.translation.override_1.requestCartButtonText`, `acris_price_on_request.translation`.`slot_config` as `acris_price_on_request.translation.slotConfig`, `acris_price_on_request.translation.override_1`.`slot_config` as `acris_price_on_request.translation.override_1.slotConfig`, `acris_price_on_request.translation`.`info_text` as `acris_price_on_request.translation.infoText`, `acris_price_on_request.translation.override_1`.`info_text` as `acris_price_on_request.translation.override_1.infoText`, `acris_price_on_request.translation`.`info_text_before` as `acris_price_on_request.translation.infoTextBefore`, `acris_price_on_request.translation.override_1`.`info_text_before` as `acris_price_on_request.translation.override_1.infoTextBefore`, `acris_price_on_request.translation`.`info_text_after` as `acris_price_on_request.translation.infoTextAfter`, `acris_price_on_request.translation.override_1`.`info_text_after` as `acris_price_on_request.translation.override_1.infoTextAfter`, `acris_price_on_request.translation`.`product_box_text_before` as `acris_price_on_request.translation.productBoxTextBefore`, `acris_price_on_request.translation.override_1`.`product_box_text_before` as `acris_price_on_request.translation.override_1.productBoxTextBefore`, `acris_price_on_request.translation`.`product_box_text_after` as `acris_price_on_request.translation.productBoxTextAfter`, `acris_price_on_request.translation.override_1`.`product_box_text_after` as `acris_price_on_request.translation.override_1.productBoxTextAfter`, `acris_price_on_request.translation`.`price_text` as `acris_price_on_request.translation.priceText`, `acris_price_on_request.translation.override_1`.`price_text` as `acris_price_on_request.translation.override_1.priceText` FROM `acris_price_on_request_translation` `acris_price_on_request.translation` LEFT JOIN `acris_price_on_request_translation` `acris_price_on_request.translation.override_1` ON `acris_price_on_request.translation`.`acris_price_on_request_id` = `acris_price_on_request.translation.override_1`.`acris_price_on_request_id` AND `acris_price_on_request.translation.override_1`.`language_id` = ? AND `acris_price_on_request.translation`.`acris_price_on_request_version_id` = `acris_price_on_request.translation.override_1`.`acris_price_on_request_version_id` WHERE `acris_price_on_request.translation`.`language_id` = ?) `acris_price_on_request.acris_price_on_request_translation` ON `acris_price_on_request.acris_price_on_request_translation`.`acris_price_on_request_id` = `acris_price_on_request`.`id` AND `acris_price_on_request.acris_price_on_request_translation`.`acris_price_on_request_version_id` = `acris_price_on_request`.`version_id` LEFT JOIN (SELECT `acris_price_on_request.requestCartIconMedia.translation`.`media_id`, `acris_price_on_request.requestCartIconMedia.translation`.`alt` as `acris_price_on_request.requestCartIconMedia.translation.alt`, `acris_price_on_request.requestCartIconMedia.translation.override_1`.`alt` as `acris_price_on_request.requestCartIconMedia.translation.override_1.alt`, `acris_price_on_request.requestCartIconMedia.translation`.`title` as `acris_price_on_request.requestCartIconMedia.translation.title`, `acris_price_on_request.requestCartIconMedia.translation.override_1`.`title` as `acris_price_on_request.requestCartIconMedia.translation.override_1.title`, `acris_price_on_request.requestCartIconMedia.translation`.`custom_fields` as `acris_price_on_request.requestCartIconMedia.translation.customFields`, `acris_price_on_request.requestCartIconMedia.translation.override_1`.`custom_fields` as `acris_price_on_request.requestCartIconMedia.translation.override_1.customFields` FROM `media_translation` `acris_price_on_request.requestCartIconMedia.translation` LEFT JOIN `media_translation` `acris_price_on_request.requestCartIconMedia.translation.override_1` ON `acris_price_on_request.requestCartIconMedia.translation`.`media_id` = `acris_price_on_request.requestCartIconMedia.translation.override_1`.`media_id` AND `acris_price_on_request.requestCartIconMedia.translation.override_1`.`language_id` = ? WHERE `acris_price_on_request.requestCartIconMedia.translation`.`language_id` = ?) `acris_price_on_request.requestCartIconMedia.media_translation` ON `acris_price_on_request.requestCartIconMedia.media_translation`.`media_id` = `acris_price_on_request.requestCartIconMedia`.`id` WHERE (`acris_price_on_request`.`version_id` = ?) AND (`acris_price_on_request`.`id` IN (?))
Parameters: 
[
  b"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01Œè‚¯ç{TƒÔaò¹w\x11Õ"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.97 ms
(5.16%) 		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`.`file_hash` as `category.media.fileHash`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.override_1.title`, `category.media.translation.title`, COALESCE(`category.media.translation.override_1.title`,`category.media.translation.title`) as `category.media.title`, `category.media.translation.override_1.alt`, `category.media.translation.alt`, COALESCE(`category.media.translation.override_1.alt`,`category.media.translation.alt`) as `category.media.alt`, `category.media.translation.override_1.customFields`, `category.media.translation.customFields`, COALESCE(`category.media.translation.override_1.customFields`,`category.media.translation.customFields`) as `category.media.customFields`, `category.translation.override_1.name`, `category.translation.name`, COALESCE(`category.translation.override_1.name`,`category.translation.name`) as `category.name`, `category.translation.override_1.breadcrumb`, `category.translation.breadcrumb`, COALESCE(`category.translation.override_1.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.override_1.slotConfig`, `category.translation.slotConfig`, COALESCE(`category.translation.override_1.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.override_1.linkType`, `category.translation.linkType`, COALESCE(`category.translation.override_1.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.override_1.internalLink`, `category.translation.internalLink`, COALESCE(`category.translation.override_1.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.override_1.externalLink`, `category.translation.externalLink`, COALESCE(`category.translation.override_1.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.override_1.linkNewTab`, `category.translation.linkNewTab`, COALESCE(`category.translation.override_1.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.override_1.description`, `category.translation.description`, COALESCE(`category.translation.override_1.description`,`category.translation.description`) as `category.description`, `category.translation.override_1.metaTitle`, `category.translation.metaTitle`, COALESCE(`category.translation.override_1.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.override_1.metaDescription`, `category.translation.metaDescription`, COALESCE(`category.translation.override_1.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.override_1.keywords`, `category.translation.keywords`, COALESCE(`category.translation.override_1.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.override_1.customFields`, `category.translation.customFields`, COALESCE(`category.translation.override_1.customFields`,`category.translation.customFields`) as `category.customFields` FROM `category` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation.override_1`.`breadcrumb` as `category.translation.override_1.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation.override_1`.`name` as `category.translation.override_1.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation.override_1`.`custom_fields` as `category.translation.override_1.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation.override_1`.`slot_config` as `category.translation.override_1.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation.override_1`.`link_type` as `category.translation.override_1.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation.override_1`.`internal_link` as `category.translation.override_1.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation.override_1`.`external_link` as `category.translation.override_1.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation.override_1`.`link_new_tab` as `category.translation.override_1.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation.override_1`.`description` as `category.translation.override_1.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation.override_1`.`meta_title` as `category.translation.override_1.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation.override_1`.`meta_description` as `category.translation.override_1.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords`, `category.translation.override_1`.`keywords` as `category.translation.override_1.keywords` FROM `category_translation` `category.translation` LEFT JOIN `category_translation` `category.translation.override_1` ON `category.translation`.`category_id` = `category.translation.override_1`.`category_id` AND `category.translation.override_1`.`language_id` = ? AND `category.translation`.`category_version_id` = `category.translation.override_1`.`category_version_id` 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 (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation.override_1`.`alt` as `category.media.translation.override_1.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation.override_1`.`title` as `category.media.translation.override_1.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields`, `category.media.translation.override_1`.`custom_fields` as `category.media.translation.override_1.customFields` FROM `media_translation` `category.media.translation` LEFT JOIN `media_translation` `category.media.translation.override_1` ON `category.media.translation`.`media_id` = `category.media.translation.override_1`.`media_id` AND `category.media.translation.override_1`.`language_id` = ? 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` = ? OR (`category`.`path` LIKE ? AND (`category`.`level` > ? AND `category`.`level` <= ?)))))
Parameters: 
[
  b"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"¡|c\x19¦gB ¹°]ñ7ÑAÜ"
  "%|a17c6319a66742a0b9b05df137d141dc|%"
  3
  5
]
View formatted query    View runnable query    Explain query    View query backtrace
1.95 ms
(3.39%) 		3 
-- seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND ((seo_path_info = ? OR seo_path_info = ?))
Parameters: 
[
  b"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"'\x7Fi\x17\x16§C –ü6N;P¨"
  "page/cms/4525b2766c164d8896c462275cbd9e3f"
  "page/cms/4525b2766c164d8896c462275cbd9e3f/"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.58 ms
(2.74%) 		3 
SELECT `acris_price_on_request`.`id` FROM `acris_price_on_request` LEFT JOIN `acris_price_on_request_rule` `acris_price_on_request.rules.mapping` ON `acris_price_on_request`.`id` = `acris_price_on_request.rules.mapping`.`price_on_request_id`  LEFT JOIN `rule` `acris_price_on_request.rules` ON `acris_price_on_request.rules.mapping`.`rule_id` = `acris_price_on_request.rules`.`id`  WHERE (`acris_price_on_request`.`version_id` = ?) AND (((`acris_price_on_request`.`active` = ? AND (`acris_price_on_request.rules`.`id` <=> ? OR (`acris_price_on_request.rules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?)))))) GROUP BY `acris_price_on_request`.`id` ORDER BY LENGTH(`acris_price_on_request`.`priority`) DESC, MAX(`acris_price_on_request`.`priority`) DESC
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  true
  null
  b"\x01Œè€\x0E\x1Ar—ŽLÊÈÔøÈ9"
  b"\fžö¢jÃI¾±P$¯ì\x1F»\x0E"
  b"0žwäÂCJô¾ü\x08üõ\x04¡Á"
  b"™\x18¥ërGCì\x10‹ \x00KW³"
  b"Ù·ªÂÛJB¹ \x19üöyÐý"
  b"›\x13¯ó\x15ðAR¯Œ\x10˜"­$°"
  b"÷Ëçý\x17#F\r¦\x1E!KÇ\x07‰Ê"
  b"Ê\x04›hœ¾B†˜@ï\x12µ]Cø"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.35 ms
(2.34%) 		3 
-- seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (path_info = ?) AND (is_canonical = 1) LIMIT 1
Parameters: 
[
  b"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"'\x7Fi\x17\x16§C –ü6N;P¨"
  "/page/cms/4525b2766c164d8896c462275cbd9e3f"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.20 ms
(2.09%) 		3 
SELECT 1 FROM `acris_price_on_request` WHERE `active` = 1 AND `bot_price_display` = ? LIMIT 1
Parameters: 
[
  "show"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.17 ms
(2.04%) 		1 
SELECT
    `theme_id`,
    `technical_name`,
    `resolved_config`,
    `view_inheritance`,
    `script_files`,
    `icon_sets`,
    `updated_at`
    FROM `theme_runtime_config`
    WHERE `technical_name` = ?
Parameters: 
[
  "TcinnThemeWareModern"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.07 ms
(1.86%) 		3 
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x01Œè€\x0E\x1Ar—ŽLÊÈÔøÈ9"
  b"\fžö¢jÃI¾±P$¯ì\x1F»\x0E"
  b"0žwäÂCJô¾ü\x08üõ\x04¡Á"
  b"™\x18¥ërGCì\x10‹ \x00KW³"
  b"Ù·ªÂÛJB¹ \x19üöyÐý"
  b"›\x13¯ó\x15ðAR¯Œ\x10˜"­$°"
  b"÷Ëçý\x17#F\r¦\x1E!KÇ\x07‰Ê"
  b"Ê\x04›hœ¾B†˜@ï\x12µ]Cø"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.06 ms
(1.85%) 		3 
SELECT `dtgs_gtm_custom_service`.`id` as `dtgs_gtm_custom_service.id`, `dtgs_gtm_custom_service`.`event_name` as `dtgs_gtm_custom_service.eventName`, `dtgs_gtm_custom_service`.`category` as `dtgs_gtm_custom_service.category`, `dtgs_gtm_custom_service`.`active` as `dtgs_gtm_custom_service.active`, `dtgs_gtm_custom_service`.`created_at` as `dtgs_gtm_custom_service.createdAt`, `dtgs_gtm_custom_service`.`updated_at` as `dtgs_gtm_custom_service.updatedAt`, `dtgs_gtm_custom_service.translation.override_1.name`, `dtgs_gtm_custom_service.translation.name`, COALESCE(`dtgs_gtm_custom_service.translation.override_1.name`,`dtgs_gtm_custom_service.translation.name`) as `dtgs_gtm_custom_service.name` FROM `dtgs_gtm_custom_service` LEFT JOIN (SELECT `dtgs_gtm_custom_service.translation`.`dtgs_gtm_custom_service_id`, `dtgs_gtm_custom_service.translation`.`name` as `dtgs_gtm_custom_service.translation.name`, `dtgs_gtm_custom_service.translation.override_1`.`name` as `dtgs_gtm_custom_service.translation.override_1.name` FROM `dtgs_gtm_custom_service_translation` `dtgs_gtm_custom_service.translation` LEFT JOIN `dtgs_gtm_custom_service_translation` `dtgs_gtm_custom_service.translation.override_1` ON `dtgs_gtm_custom_service.translation`.`dtgs_gtm_custom_service_id` = `dtgs_gtm_custom_service.translation.override_1`.`dtgs_gtm_custom_service_id` AND `dtgs_gtm_custom_service.translation.override_1`.`language_id` = ? WHERE `dtgs_gtm_custom_service.translation`.`language_id` = ?) `dtgs_gtm_custom_service.dtgs_gtm_custom_service_translation` ON `dtgs_gtm_custom_service.dtgs_gtm_custom_service_translation`.`dtgs_gtm_custom_service_id` = `dtgs_gtm_custom_service`.`id` WHERE (`dtgs_gtm_custom_service`.`active` = ?)
Parameters: 
[
  b"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
1.03 ms
(1.79%) 		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/22ed621f8008464d88ededff50a07d11"
  "/navigation/b8dd833da00545a988084c76b89fd5e2"
  "/navigation/0ccad620cfb74dcab9f2cad128e79969"
  "/navigation/26cdfbc2301f41aea2b2a1507be1b8ff"
  "/navigation/863b2591b82e455989fa92032c67b87c"
  b"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"'\x7Fi\x17\x16§C –ü6N;P¨"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.01 ms
(1.76%) 		1 
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.override_1.name`, `category.translation.name`, COALESCE(`category.translation.override_1.name`,`category.translation.name`) as `category.name`, `category.translation.override_1.breadcrumb`, `category.translation.breadcrumb`, COALESCE(`category.translation.override_1.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.override_1.slotConfig`, `category.translation.slotConfig`, COALESCE(`category.translation.override_1.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.override_1.linkType`, `category.translation.linkType`, COALESCE(`category.translation.override_1.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.override_1.internalLink`, `category.translation.internalLink`, COALESCE(`category.translation.override_1.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.override_1.externalLink`, `category.translation.externalLink`, COALESCE(`category.translation.override_1.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.override_1.linkNewTab`, `category.translation.linkNewTab`, COALESCE(`category.translation.override_1.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.override_1.description`, `category.translation.description`, COALESCE(`category.translation.override_1.description`,`category.translation.description`) as `category.description`, `category.translation.override_1.metaTitle`, `category.translation.metaTitle`, COALESCE(`category.translation.override_1.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.override_1.metaDescription`, `category.translation.metaDescription`, COALESCE(`category.translation.override_1.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.override_1.keywords`, `category.translation.keywords`, COALESCE(`category.translation.override_1.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.override_1.customFields`, `category.translation.customFields`, COALESCE(`category.translation.override_1.customFields`,`category.translation.customFields`) as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation.override_1`.`breadcrumb` as `category.translation.override_1.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation.override_1`.`name` as `category.translation.override_1.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation.override_1`.`custom_fields` as `category.translation.override_1.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation.override_1`.`slot_config` as `category.translation.override_1.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation.override_1`.`link_type` as `category.translation.override_1.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation.override_1`.`internal_link` as `category.translation.override_1.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation.override_1`.`external_link` as `category.translation.override_1.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation.override_1`.`link_new_tab` as `category.translation.override_1.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation.override_1`.`description` as `category.translation.override_1.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation.override_1`.`meta_title` as `category.translation.override_1.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation.override_1`.`meta_description` as `category.translation.override_1.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords`, `category.translation.override_1`.`keywords` as `category.translation.override_1.keywords` FROM `category_translation` `category.translation` LEFT JOIN `category_translation` `category.translation.override_1` ON `category.translation`.`category_id` = `category.translation.override_1`.`category_id` AND `category.translation.override_1`.`language_id` = ? AND `category.translation`.`category_version_id` = `category.translation.override_1`.`category_version_id` 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"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"x)gÜœ‘@Í•šŒJ¯­™D"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.97 ms
(1.69%) 		3 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"'\x7Fi\x17\x16§C –ü6N;P¨"
  "Xgs3JOkHK45VAzKHbPUoX5SluvBTUFgs"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.91 ms
(1.58%) 		1 
-- footer-pagelet::shipping-methods::read
SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`technical_name` as `shipping_method.technicalName`, `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`.`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`.`file_hash` as `shipping_method.media.fileHash`, `shipping_method.media`.`created_at` as `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`, `shipping_method.media.translation.override_1.title`, `shipping_method.media.translation.title`, COALESCE(`shipping_method.media.translation.override_1.title`,`shipping_method.media.translation.title`) as `shipping_method.media.title`, `shipping_method.media.translation.override_1.alt`, `shipping_method.media.translation.alt`, COALESCE(`shipping_method.media.translation.override_1.alt`,`shipping_method.media.translation.alt`) as `shipping_method.media.alt`, `shipping_method.media.translation.override_1.customFields`, `shipping_method.media.translation.customFields`, COALESCE(`shipping_method.media.translation.override_1.customFields`,`shipping_method.media.translation.customFields`) as `shipping_method.media.customFields`, `shipping_method.translation.override_1.name`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.override_1.name`,`shipping_method.translation.name`) as `shipping_method.name`, `shipping_method.translation.override_1.description`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.override_1.description`,`shipping_method.translation.description`) as `shipping_method.description`, `shipping_method.translation.override_1.trackingUrl`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.override_1.trackingUrl`,`shipping_method.translation.trackingUrl`) as `shipping_method.trackingUrl`, `shipping_method.translation.override_1.customFields`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.override_1.customFields`,`shipping_method.translation.customFields`) as `shipping_method.customFields` FROM `shipping_method` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name`, `shipping_method.translation.override_1`.`name` as `shipping_method.translation.override_1.name`, `shipping_method.translation`.`custom_fields` as `shipping_method.translation.customFields`, `shipping_method.translation.override_1`.`custom_fields` as `shipping_method.translation.override_1.customFields`, `shipping_method.translation`.`description` as `shipping_method.translation.description`, `shipping_method.translation.override_1`.`description` as `shipping_method.translation.override_1.description`, `shipping_method.translation`.`tracking_url` as `shipping_method.translation.trackingUrl`, `shipping_method.translation.override_1`.`tracking_url` as `shipping_method.translation.override_1.trackingUrl` FROM `shipping_method_translation` `shipping_method.translation` LEFT JOIN `shipping_method_translation` `shipping_method.translation.override_1` ON `shipping_method.translation`.`shipping_method_id` = `shipping_method.translation.override_1`.`shipping_method_id` AND `shipping_method.translation.override_1`.`language_id` = ? 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 (SELECT `shipping_method.media.translation`.`media_id`, `shipping_method.media.translation`.`alt` as `shipping_method.media.translation.alt`, `shipping_method.media.translation.override_1`.`alt` as `shipping_method.media.translation.override_1.alt`, `shipping_method.media.translation`.`title` as `shipping_method.media.translation.title`, `shipping_method.media.translation.override_1`.`title` as `shipping_method.media.translation.override_1.title`, `shipping_method.media.translation`.`custom_fields` as `shipping_method.media.translation.customFields`, `shipping_method.media.translation.override_1`.`custom_fields` as `shipping_method.media.translation.override_1.customFields` FROM `media_translation` `shipping_method.media.translation` LEFT JOIN `media_translation` `shipping_method.media.translation.override_1` ON `shipping_method.media.translation`.`media_id` = `shipping_method.media.translation.override_1`.`media_id` AND `shipping_method.media.translation.override_1`.`language_id` = ? 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"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"#<£\x02…ºGH©æÏ\x10¡Ì«ä"
  b"üŪß&\fHOœb\x17*-«\x15ˆ"
  b"TKa†\x01N2°#\x1Aûëý\x04n"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.85 ms
(1.48%) 		1 
-- footer-pagelet::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`.`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`.`file_hash` as `payment_method.media.fileHash`, `payment_method.media`.`created_at` as `payment_method.media.createdAt`, `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`, `payment_method.media.translation.override_1.title`, `payment_method.media.translation.title`, COALESCE(`payment_method.media.translation.override_1.title`,`payment_method.media.translation.title`) as `payment_method.media.title`, `payment_method.media.translation.override_1.alt`, `payment_method.media.translation.alt`, COALESCE(`payment_method.media.translation.override_1.alt`,`payment_method.media.translation.alt`) as `payment_method.media.alt`, `payment_method.media.translation.override_1.customFields`, `payment_method.media.translation.customFields`, COALESCE(`payment_method.media.translation.override_1.customFields`,`payment_method.media.translation.customFields`) as `payment_method.media.customFields`, `payment_method.translation.override_1.name`, `payment_method.translation.name`, COALESCE(`payment_method.translation.override_1.name`,`payment_method.translation.name`) as `payment_method.name`, `payment_method.translation.override_1.distinguishableName`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.override_1.distinguishableName`,`payment_method.translation.distinguishableName`) as `payment_method.distinguishableName`, `payment_method.translation.override_1.description`, `payment_method.translation.description`, COALESCE(`payment_method.translation.override_1.description`,`payment_method.translation.description`) as `payment_method.description`, `payment_method.translation.override_1.customFields`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.override_1.customFields`,`payment_method.translation.customFields`) as `payment_method.customFields` FROM `payment_method` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.translation`.`payment_method_id`, `payment_method.translation`.`name` as `payment_method.translation.name`, `payment_method.translation.override_1`.`name` as `payment_method.translation.override_1.name`, `payment_method.translation`.`distinguishable_name` as `payment_method.translation.distinguishableName`, `payment_method.translation.override_1`.`distinguishable_name` as `payment_method.translation.override_1.distinguishableName`, `payment_method.translation`.`description` as `payment_method.translation.description`, `payment_method.translation.override_1`.`description` as `payment_method.translation.override_1.description`, `payment_method.translation`.`custom_fields` as `payment_method.translation.customFields`, `payment_method.translation.override_1`.`custom_fields` as `payment_method.translation.override_1.customFields` FROM `payment_method_translation` `payment_method.translation` LEFT JOIN `payment_method_translation` `payment_method.translation.override_1` ON `payment_method.translation`.`payment_method_id` = `payment_method.translation.override_1`.`payment_method_id` AND `payment_method.translation.override_1`.`language_id` = ? 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 (SELECT `payment_method.media.translation`.`media_id`, `payment_method.media.translation`.`alt` as `payment_method.media.translation.alt`, `payment_method.media.translation.override_1`.`alt` as `payment_method.media.translation.override_1.alt`, `payment_method.media.translation`.`title` as `payment_method.media.translation.title`, `payment_method.media.translation.override_1`.`title` as `payment_method.media.translation.override_1.title`, `payment_method.media.translation`.`custom_fields` as `payment_method.media.translation.customFields`, `payment_method.media.translation.override_1`.`custom_fields` as `payment_method.media.translation.override_1.customFields` FROM `media_translation` `payment_method.media.translation` LEFT JOIN `media_translation` `payment_method.media.translation.override_1` ON `payment_method.media.translation`.`media_id` = `payment_method.media.translation.override_1`.`media_id` AND `payment_method.media.translation.override_1`.`language_id` = ? 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"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"š®\x1F\e%›ECŠ(®„\x03G^g"
  b"i8a:éãGo‹\x07›\tÈ!\e\x15"
  b"Ï+S3cH,©¡6ïÞžŽµ"
  b";ƒ@×N2B³‚Æ’;K:\x1F@"
  b"žRåpßÓJlŽ\r§Ÿ—›æö"
  b"¤%í|QOO!‚™˜nÈn¹?"
  b"\f—§IkZ@\x14¤-@B„«×\x05"
  b"\x119dúÛÈF\e ,0yz‡ZF"
  b"È9z‹TmKDŽ\x1E)\x0F¢#"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.78 ms
(1.36%) 		1 
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`active` as `language.active`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.override_1.name`, `language.locale.translation.name`, COALESCE(`language.locale.translation.override_1.name`,`language.locale.translation.name`) as `language.locale.name`, `language.locale.translation.override_1.territory`, `language.locale.translation.territory`, COALESCE(`language.locale.translation.override_1.territory`,`language.locale.translation.territory`) as `language.locale.territory`, `language.locale.translation.override_1.customFields`, `language.locale.translation.customFields`, COALESCE(`language.locale.translation.override_1.customFields`,`language.locale.translation.customFields`) as `language.locale.customFields` FROM `language` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.locale.translation`.`locale_id`, `language.locale.translation`.`name` as `language.locale.translation.name`, `language.locale.translation.override_1`.`name` as `language.locale.translation.override_1.name`, `language.locale.translation`.`territory` as `language.locale.translation.territory`, `language.locale.translation.override_1`.`territory` as `language.locale.translation.override_1.territory`, `language.locale.translation`.`custom_fields` as `language.locale.translation.customFields`, `language.locale.translation.override_1`.`custom_fields` as `language.locale.translation.override_1.customFields` FROM `locale_translation` `language.locale.translation` LEFT JOIN `locale_translation` `language.locale.translation.override_1` ON `language.locale.translation`.`locale_id` = `language.locale.translation.override_1`.`locale_id` AND `language.locale.translation.override_1`.`language_id` = ? WHERE `language.locale.translation`.`language_id` = ?) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE `language`.`id` IN (?)
Parameters: 
[
  b"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ô’rŽ)­@Æ·ì–4"Y\x07h"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.71 ms
(1.24%) 		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"'\x7Fi\x17\x16§C –ü6N;P¨"
  b"'\x7Fi\x17\x16§C –ü6N;P¨"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.67 ms
(1.17%) 		3 
SELECT `acris_price_on_request_request_cart`.`id`, `acris_price_on_request_request_cart`.`auto_increment`, `acris_price_on_request_request_cart`.`request_number` FROM `acris_price_on_request_request_cart` WHERE ((`acris_price_on_request_request_cart`.`customer_id` <=> ? AND `acris_price_on_request_request_cart`.`sales_channel_id` = ? AND (`acris_price_on_request_request_cart`.`status` IN (?))))
Parameters: 
[
  null
  b"'\x7Fi\x17\x16§C –ü6N;P¨"
  "draft"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.67 ms
(1.16%) 		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`.`file_hash` as `media.fileHash`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.override_1.title`, `media.translation.title`, COALESCE(`media.translation.override_1.title`,`media.translation.title`) as `media.title`, `media.translation.override_1.alt`, `media.translation.alt`, COALESCE(`media.translation.override_1.alt`,`media.translation.alt`) as `media.alt`, `media.translation.override_1.customFields`, `media.translation.customFields`, COALESCE(`media.translation.override_1.customFields`,`media.translation.customFields`) as `media.customFields` 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`.`alt` as `media.translation.alt`, `media.translation.override_1`.`alt` as `media.translation.override_1.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation.override_1`.`title` as `media.translation.override_1.title`, `media.translation`.`custom_fields` as `media.translation.customFields`, `media.translation.override_1`.`custom_fields` as `media.translation.override_1.customFields` FROM `media_translation` `media.translation` LEFT JOIN `media_translation` `media.translation.override_1` ON `media.translation`.`media_id` = `media.translation.override_1`.`media_id` AND `media.translation.override_1`.`language_id` = ? 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`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?, ?, ?, ?))
Parameters: 
[
  b"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  false
  true
  "product_download"
  false
  true
  "product_download"
  b"g\x12]ÿtìG<†NÎ\x07\x03\r»1"
  b"Šm¬#\t†HOªšzH\eIIW"
  b"įZÏžvEА£óÃ\x04~–Ù"
  b"ëã‰8yiAx¹\x1EýyqFöÏ"
  b"\x010jY0w\x10µ»¡È®íŽÝ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.65 ms
(1.12%) 		3 
-- sales-channel::load-analytics::read
SELECT `sales_channel_analytics`.`id` as `sales_channel_analytics.id`, `sales_channel_analytics`.`tracking_id` as `sales_channel_analytics.trackingId`, `sales_channel_analytics`.`active` as `sales_channel_analytics.active`, `sales_channel_analytics`.`track_orders` as `sales_channel_analytics.trackOrders`, `sales_channel_analytics`.`anonymize_ip` as `sales_channel_analytics.anonymizeIp`, `sales_channel_analytics`.`track_offcanvas_cart` as `sales_channel_analytics.trackOffcanvasCart`, `sales_channel_analytics`.`created_at` as `sales_channel_analytics.createdAt`, `sales_channel_analytics`.`updated_at` as `sales_channel_analytics.updatedAt` FROM `sales_channel_analytics` WHERE `sales_channel_analytics`.`id` IN (?)
Parameters: 
[
  b"•eTtT¨LÍœ1˜q\x18¨©z"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.62 ms
(1.08%) 		1 
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.override_1.name`, `cms_page.translation.name`, COALESCE(`cms_page.translation.override_1.name`,`cms_page.translation.name`) as `cms_page.name`, `cms_page.translation.override_1.customFields`, `cms_page.translation.customFields`, COALESCE(`cms_page.translation.override_1.customFields`,`cms_page.translation.customFields`) as `cms_page.customFields` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.`cms_page_id`, `cms_page.translation`.`cms_page_version_id`, `cms_page.translation`.`name` as `cms_page.translation.name`, `cms_page.translation.override_1`.`name` as `cms_page.translation.override_1.name`, `cms_page.translation`.`custom_fields` as `cms_page.translation.customFields`, `cms_page.translation.override_1`.`custom_fields` as `cms_page.translation.override_1.customFields` FROM `cms_page_translation` `cms_page.translation` LEFT JOIN `cms_page_translation` `cms_page.translation.override_1` ON `cms_page.translation`.`cms_page_id` = `cms_page.translation.override_1`.`cms_page_id` AND `cms_page.translation.override_1`.`language_id` = ? AND `cms_page.translation`.`cms_page_version_id` = `cms_page.translation.override_1`.`cms_page_version_id` 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"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"E%²vl\x16Mˆ–Äb'\½ž?"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.56 ms
(0.98%) 		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.52 ms
(0.91%) 		1 
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%"
  "%|a17c6319a66742a0b9b05df137d141dc|%"
  5
  true
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.49 ms
(0.84%) 		1 
SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`version_id` as `cms_block.versionId`, `cms_block`.`cms_section_version_id` as `cms_block.cmsSectionVersionId`, `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`.`created_at` as `cms_block.createdAt`, `cms_block`.`updated_at` as `cms_block.updatedAt`, `cms_block.backgroundMedia`.`id` as `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` as `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` as `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` as `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` as `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` as `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` as `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` as `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` as `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` as `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`config` as `cms_block.backgroundMedia.config`, `cms_block.backgroundMedia`.`path` as `cms_block.backgroundMedia.path`, `cms_block.backgroundMedia`.`private` as `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`file_hash` as `cms_block.backgroundMedia.fileHash`, `cms_block.backgroundMedia`.`created_at` as `cms_block.backgroundMedia.createdAt`, `cms_block.backgroundMedia`.`updated_at` as `cms_block.backgroundMedia.updatedAt`, `cms_block.backgroundMedia.translation.override_1.title`, `cms_block.backgroundMedia.translation.title`, COALESCE(`cms_block.backgroundMedia.translation.override_1.title`,`cms_block.backgroundMedia.translation.title`) as `cms_block.backgroundMedia.title`, `cms_block.backgroundMedia.translation.override_1.alt`, `cms_block.backgroundMedia.translation.alt`, COALESCE(`cms_block.backgroundMedia.translation.override_1.alt`,`cms_block.backgroundMedia.translation.alt`) as `cms_block.backgroundMedia.alt`, `cms_block.backgroundMedia.translation.override_1.customFields`, `cms_block.backgroundMedia.translation.customFields`, COALESCE(`cms_block.backgroundMedia.translation.override_1.customFields`,`cms_block.backgroundMedia.translation.customFields`) as `cms_block.backgroundMedia.customFields` FROM `cms_block` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation`.`media_id`, `cms_block.backgroundMedia.translation`.`alt` as `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation.override_1`.`alt` as `cms_block.backgroundMedia.translation.override_1.alt`, `cms_block.backgroundMedia.translation`.`title` as `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation.override_1`.`title` as `cms_block.backgroundMedia.translation.override_1.title`, `cms_block.backgroundMedia.translation`.`custom_fields` as `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation.override_1`.`custom_fields` as `cms_block.backgroundMedia.translation.override_1.customFields` FROM `media_translation` `cms_block.backgroundMedia.translation` LEFT JOIN `media_translation` `cms_block.backgroundMedia.translation.override_1` ON `cms_block.backgroundMedia.translation`.`media_id` = `cms_block.backgroundMedia.translation.override_1`.`media_id` AND `cms_block.backgroundMedia.translation.override_1`.`language_id` = ? 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"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"ºBhÿLX@Gšp<\x14D³äö"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.48 ms
(0.83%) 		1 
SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`version_id` as `cms_section.versionId`, `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`, `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`.`created_at` as `cms_section.createdAt`, `cms_section`.`updated_at` as `cms_section.updatedAt`, `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`config` as `cms_section.backgroundMedia.config`, `cms_section.backgroundMedia`.`path` as `cms_section.backgroundMedia.path`, `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`file_hash` as `cms_section.backgroundMedia.fileHash`, `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.translation.override_1.title`, `cms_section.backgroundMedia.translation.title`, COALESCE(`cms_section.backgroundMedia.translation.override_1.title`,`cms_section.backgroundMedia.translation.title`) as `cms_section.backgroundMedia.title`, `cms_section.backgroundMedia.translation.override_1.alt`, `cms_section.backgroundMedia.translation.alt`, COALESCE(`cms_section.backgroundMedia.translation.override_1.alt`,`cms_section.backgroundMedia.translation.alt`) as `cms_section.backgroundMedia.alt`, `cms_section.backgroundMedia.translation.override_1.customFields`, `cms_section.backgroundMedia.translation.customFields`, COALESCE(`cms_section.backgroundMedia.translation.override_1.customFields`,`cms_section.backgroundMedia.translation.customFields`) as `cms_section.backgroundMedia.customFields` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation`.`media_id`, `cms_section.backgroundMedia.translation`.`alt` as `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation.override_1`.`alt` as `cms_section.backgroundMedia.translation.override_1.alt`, `cms_section.backgroundMedia.translation`.`title` as `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation.override_1`.`title` as `cms_section.backgroundMedia.translation.override_1.title`, `cms_section.backgroundMedia.translation`.`custom_fields` as `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation.override_1`.`custom_fields` as `cms_section.backgroundMedia.translation.override_1.customFields` FROM `media_translation` `cms_section.backgroundMedia.translation` LEFT JOIN `media_translation` `cms_section.backgroundMedia.translation.override_1` ON `cms_section.backgroundMedia.translation`.`media_id` = `cms_section.backgroundMedia.translation.override_1`.`media_id` AND `cms_section.backgroundMedia.translation.override_1`.`language_id` = ? 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"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"E%²vl\x16Mˆ–Äb'\½ž?"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.47 ms
(0.82%) 		1 
SELECT `acl_role`.`privileges` AS `privileges`
            FROM `acl_role`
            INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
            WHERE `app`.`id` = ?
Parameters: 
[
  b"\x01–0]\rAq\x1D‰‹Shuö'\x03"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.43 ms
(0.75%) 		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`.`active` as `language.active`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.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.override_1.name`, `language.translationCode.translation.name`, COALESCE(`language.translationCode.translation.override_1.name`,`language.translationCode.translation.name`) as `language.translationCode.name`, `language.translationCode.translation.override_1.territory`, `language.translationCode.translation.territory`, COALESCE(`language.translationCode.translation.override_1.territory`,`language.translationCode.translation.territory`) as `language.translationCode.territory`, `language.translationCode.translation.override_1.customFields`, `language.translationCode.translation.customFields`, COALESCE(`language.translationCode.translation.override_1.customFields`,`language.translationCode.translation.customFields`) as `language.translationCode.customFields` FROM `language` 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.override_1`.`name` as `language.translationCode.translation.override_1.name`, `language.translationCode.translation`.`territory` as `language.translationCode.translation.territory`, `language.translationCode.translation.override_1`.`territory` as `language.translationCode.translation.override_1.territory`, `language.translationCode.translation`.`custom_fields` as `language.translationCode.translation.customFields`, `language.translationCode.translation.override_1`.`custom_fields` as `language.translationCode.translation.override_1.customFields` FROM `locale_translation` `language.translationCode.translation` LEFT JOIN `locale_translation` `language.translationCode.translation.override_1` ON `language.translationCode.translation`.`locale_id` = `language.translationCode.translation.override_1`.`locale_id` AND `language.translationCode.translation.override_1`.`language_id` = ? 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"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Ÿ­a\x05s÷Nk²Þܝ\x0FUU£"
  b"ô’rŽ)­@Æ·ì–4"Y\x07h"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.43 ms
(0.75%) 		1 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.43 ms
(0.74%) 		1 
SELECT `sales_channel_country`.`sales_channel_id`, `sales_channel_country`.`country_id` FROM `sales_channel_country` WHERE (`sales_channel_country`.`sales_channel_id` = ? AND `sales_channel_country`.`country_id` = ?)
Parameters: 
[
  b"'\x7Fi\x17\x16§C –ü6N;P¨"
  b"""
    iB­\n
    à\x07D\x17´z\x19(Íxé]
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.42 ms
(0.72%) 		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.41 ms
(0.72%) 		2 
# navigation-route::meta-information
            SELECT LOWER(HEX(`id`)), `path`, `level`
            FROM `category`
            WHERE `id` = ? OR `id` = ?
Parameters: 
[
  b"x)gÜœ‘@Í•šŒJ¯­™D"
  b"x)gÜœ‘@Í•šŒJ¯­™D"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.41 ms
(0.71%) 		1 
-- footer-pagelet::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.override_1`.`name` as `shipping_method.translation.override_1.name` FROM `shipping_method_translation` `shipping_method.translation` LEFT JOIN `shipping_method_translation` `shipping_method.translation.override_1` ON `shipping_method.translation`.`shipping_method_id` = `shipping_method.translation.override_1`.`shipping_method_id` AND `shipping_method.translation.override_1`.`language_id` = ? 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.override_1.name`,`shipping_method.translation.name`)) ASC
Parameters: 
[
  b"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  b"'\x7Fi\x17\x16§C –ü6N;P¨"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.37 ms
(0.64%) 		1 
SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `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`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.translation.override_1.config`, `cms_slot.translation.config`, COALESCE(`cms_slot.translation.override_1.config`,`cms_slot.translation.config`) as `cms_slot.config`, `cms_slot.translation.override_1.customFields`, `cms_slot.translation.customFields`, COALESCE(`cms_slot.translation.override_1.customFields`,`cms_slot.translation.customFields`) as `cms_slot.customFields` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation`.`cms_slot_id`, `cms_slot.translation`.`cms_slot_version_id`, `cms_slot.translation`.`config` as `cms_slot.translation.config`, `cms_slot.translation.override_1`.`config` as `cms_slot.translation.override_1.config`, `cms_slot.translation`.`custom_fields` as `cms_slot.translation.customFields`, `cms_slot.translation.override_1`.`custom_fields` as `cms_slot.translation.override_1.customFields` FROM `cms_slot_translation` `cms_slot.translation` LEFT JOIN `cms_slot_translation` `cms_slot.translation.override_1` ON `cms_slot.translation`.`cms_slot_id` = `cms_slot.translation.override_1`.`cms_slot_id` AND `cms_slot.translation.override_1`.`language_id` = ? AND `cms_slot.translation`.`cms_slot_version_id` = `cms_slot.translation.override_1`.`cms_slot_version_id` 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"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"<«îb»?Gï‚Åí% Èë¥"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.35 ms
(0.61%) 		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.override_1.shortName`, `currency.translation.shortName`, COALESCE(`currency.translation.override_1.shortName`,`currency.translation.shortName`) as `currency.shortName`, `currency.translation.override_1.name`, `currency.translation.name`, COALESCE(`currency.translation.override_1.name`,`currency.translation.name`) as `currency.name`, `currency.translation.override_1.customFields`, `currency.translation.customFields`, COALESCE(`currency.translation.override_1.customFields`,`currency.translation.customFields`) as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation`.`currency_id`, `currency.translation`.`short_name` as `currency.translation.shortName`, `currency.translation.override_1`.`short_name` as `currency.translation.override_1.shortName`, `currency.translation`.`name` as `currency.translation.name`, `currency.translation.override_1`.`name` as `currency.translation.override_1.name`, `currency.translation`.`custom_fields` as `currency.translation.customFields`, `currency.translation.override_1`.`custom_fields` as `currency.translation.override_1.customFields` FROM `currency_translation` `currency.translation` LEFT JOIN `currency_translation` `currency.translation.override_1` ON `currency.translation`.`currency_id` = `currency.translation.override_1`.`currency_id` AND `currency.translation.override_1`.`language_id` = ? WHERE `currency.translation`.`language_id` = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters: 
[
  b"ô’rŽ)­@Æ·ì–4"Y\x07h"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(0.55%) 		1 
-- footer-pagelet::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"'\x7Fi\x17\x16§C –ü6N;P¨"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(0.54%) 		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.27 ms
(0.47%) 		1 
SELECT path FROM category WHERE id = ?
Parameters: 
[
  b"x)gÜœ‘@Í•šŒJ¯­™D"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(0.46%) 		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.24 ms
(0.42%) 		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"'\x7Fi\x17\x16§C –ü6N;P¨"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.22 ms
(0.37%) 		2 
SELECT url FROM sales_channel_domain
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.21 ms
(0.37%) 		1 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.19 ms
(0.32%) 		1 
SELECT `name`, `path`, `author`, `self_managed`
                FROM `app`
                WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.14 ms
(0.25%) 		1 
SELECT DISTINCT `technical_name`
    FROM `theme_runtime_config`
    WHERE `technical_name` IS NOT NULL
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.23%) 		1 
SELECT `min_search_length` FROM `product_search_config` WHERE `language_id` = ?
Parameters: 
[
  b"ô’rŽ)­@Æ·ì–4"Y\x07h"
]
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.