GET https://dev.webshop.fior-gentz.de/detail/da163f6a55de2044994f87db95663889

Response
200 OK
IP
192.168.106.253
Profiled on
Token
4083b9

Query Metrics

114 Database Queries
66 Different statements
48.33 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
10.32 ms
(21.36%) 		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/7c54f56b501c2f852676790165213c1b"
  "/navigation/1373c2fb9e309409fc1ad13f583d1792"
  "/navigation/c839f9b3609ca4e52dd5991b66e86a5f"
  "/navigation/52c51c4a6e042ac9c212fa4b43e8dff9"
  "/navigation/c4072176a9b54e422a621f3a659c395c"
  "/navigation/82c647b0b2926d468c349e9370e3075e"
  "/navigation/0e81b49bd58ed82cc0446a9dd8718397"
  "/navigation/e85b164bd31a3e27714562ffd3b0ab92"
  "/navigation/585842fd00a03b2641b46db48c85f607"
  "/navigation/ea3878777464383d2c5e1462847b6f2c"
  "/navigation/ff05a01d18247fbccc596621109793a3"
  "/navigation/ba01ed72fd96bc8d0cef24ad1f56e223"
  "/navigation/1df0716bd36344f5960043c59e6dcd5b"
  "/navigation/aab06d767eac41488bd37e734c02be15"
  "/navigation/f069bf41e1794fffa35ee81dfcc2662f"
  "/navigation/75ac4815f3f0492181f5fb5f36c69f01"
  "/navigation/1725b55ae8e5432d93b24473626a0062"
  "/navigation/8a39c6323be8474c8561e4d2a2efbfb6"
  "/navigation/b12b585c23a2b443b35cb33f57309a34"
  "/navigation/49d2c858c9954bca188381ad32e48ab1"
  "/navigation/ba0b0665a1b8b6ac875db58764f3996c"
  "/navigation/cdaac66a7511195cf7b18c28271f8ed1"
  "/navigation/859b4a12e9790e0f961519a0d4df2074"
  "/navigation/2af6b5f45de82f3f5e00a89312f64655"
  "/navigation/f9c53d901df222f03d0250ba488779a2"
  "/navigation/9b448f2d506e4fb95d7919602fb9c7b7"
  "/navigation/4896441202610461fe302e370770be8f"
  "/navigation/6c4820510f65ed775ff804da52c54c08"
  "/navigation/05c180788dc3adf3b01e041cbd14918c"
  "/navigation/0cfecf3a05a189a6c58d50604cfac0f6"
  "/navigation/b8758a8573118eaa19d3d4d2c9e9b89d"
  "/navigation/e945f0c35e14acbebbc2a69fc8e79362"
  "/navigation/82292e65cbf61cbc09ad159cebd57f66"
  "/navigation/279e8f93baa3e5f66f0331d996dc3335"
  "/navigation/a1a70a976a3dab4467de83f1ce705926"
  "/navigation/b1ce890327cd3deae1d99ef61de686b1"
  "/navigation/f550237786786dec4694c1d84d999717"
  "/navigation/3d12ee6b9508c976f017a402a98c4806"
  "/navigation/10f518f182ff6fb4504f45ea5a9c5344"
  "/navigation/9d41a375f9f1920806388ec837380a38"
  "/navigation/d1c4d83531d5b936be9c2a636242d6e7"
  "/navigation/4dee7ea0d1fd1b48c199ee744e21dc13"
  "/navigation/466941f9ef29aff486fcc14de5c5346d"
  "/navigation/bb3fcdad153e72c5c9fe6ba655efd813"
  "/navigation/0f1536f9fa812514ba663937e8baca10"
  "/navigation/0e6602616539726bae31cb37fd8ebc2e"
  "/navigation/dae1379343945f96e4d223c6ba71a3de"
  "/navigation/265ee66250385520ab3a15b9381478b4"
  "/navigation/a690ea05465c1a442312e6b88b3f2e7e"
  "/navigation/a5dbebcb026ba297f759cffd369ad3ac"
  "/navigation/3e2b132741763b0d5a50d3b9ef8ef11f"
  "/navigation/7a628b9647b55a6f498d19a2c7ea7b8e"
  "/navigation/b870eb688349c57324070a5b584eff55"
  "/navigation/f21e906a1a246bcd430cdbd8f484563e"
  "/navigation/b610c9629370190fc5a8180b8a428d22"
  "/navigation/1399698736743569904b8fff1e02556a"
  "/navigation/e1c3e518d6b46e142a944c40ce97a4eb"
  "/navigation/32645c12bdc1156cea72c7d799887792"
  "/navigation/e85b91428db44730c20de44aaeb32558"
  "/navigation/d6df5858abae4ad8dd84ddf97f8e2954"
  "/navigation/672383f1c5ff6e60fd38aff871e1de19"
  "/navigation/161315affdbdcbe4f8439ad2f4a8fd06"
  "/navigation/a5995d8cfef68561186fcce9de81c2bb"
  "/navigation/addae266b3497710f07d021c35dac8d0"
  "/navigation/83fc607e756817e7d3b914e00de50fef"
  "/navigation/539009e8df89be652eab43ad7f668a99"
  "/navigation/92627f78e89adf0d91de45f9211682b9"
  "/navigation/24545955358a82d2382d00af2899472d"
  "/navigation/d185e1e0d156b5d951e4ee580db120ea"
  "/navigation/ae3edbafb61cbcd66bd1af601274fe05"
  "/navigation/74a6480435f63eaf32fe1f9f862a90cf"
  "/navigation/93c1f4a7d7940106e5271bf2d67172f0"
  "/navigation/01bf2bf3375b3fbaf8d2dac6dad08c84"
  "/navigation/671334a315d06ecd226900fa2e65d63a"
  "/navigation/06f42997a2b807ae91302fdbd35d6ff4"
  "/navigation/b585909f889a3976438f750182700c24"
  "/navigation/99f88e444c5a3c70962a43a96715405d"
  "/navigation/f99befc5469e8164db7317900e93fdb8"
  "/navigation/7dadb84542b0612758aba16d8dae65c2"
  "/navigation/e1f5cf89e665d1c10f38bb93ff76a710"
  "/navigation/f1fb4bc68bfec29fc2b3a3ad87182f3b"
  "/navigation/a8ded21bc0115c8051230a4e28deab79"
  "/navigation/6a1b5b8c0a95ee8057881906878e4a0a"
  "/navigation/54efc81bb4b2257031c45e48b59da108"
  "/navigation/9668ae3679ed7ad2ea8413f713d68b21"
  "/navigation/ccca6647e06fb8e0d026c9a42ae7b67e"
  "/navigation/c6e45b9016d792273070f413ce170485"
  "/navigation/eff01e1e48a871c550c5b13977d7bf70"
  "/navigation/e1decb094963ed051ebc2869b7b1b49a"
  "/navigation/4cb427c11739339dae985d12bac8b5e8"
  "/navigation/bfc94e6a1245d9045422c6fdb665e09f"
  "/navigation/dc6081c08e1b41a69fededf08a23430c"
  "/navigation/3dd24418f21e4e55a824638b322183ea"
  "/navigation/42cdb419f6864b3abe1e54bac22c4f6e"
  "/navigation/6cc31dd65b444648af9c32f1c34fa56f"
  "/navigation/357eaecdf2274433a33d9d6650bc6fc9"
  "/navigation/bb17d2d5d2444c4095fb88932b2280e5"
  "/navigation/82229e637cb341b4be0e8cf9525e1679"
  "/navigation/7f340c69eabe44cfbb24722408f13398"
  "/navigation/77db980fb638485e97aac24e30b67133"
  "/navigation/36faf1a6f47cad46bc38295a458b7d52"
  "/navigation/86a5e62d50a60c7cb2e39134bba38e4d"
  "/navigation/b444880101d5d44071427338681042dc"
  "/navigation/22e7e21b4b90cb472b74f0d27cac4167"
  "/navigation/79126323ab64e2fc7ee4d0bff4bb2206"
  "/navigation/667f200c07c7999ead9abdc6dabba414"
  "/navigation/ff3242e1557c400afb3b4ddb79d9ba6b"
  "/navigation/2cc3ac160e43574e984e23e6bf1fcd41"
  "/navigation/26c928400044ad7425db4327fc899914"
  "/navigation/5533a71f66981672490973e0f747bda6"
  "/navigation/318757e292139bcd30b4421adb74c9a6"
  "/navigation/de8a21c1ba78b6c8438247280eb37c49"
  "/navigation/6e3e9d12a95e1d0b9ea0ecebd711460e"
  "/navigation/2ae6bfacabecc4b337930999a797ec33"
  "/navigation/8540f07ac3919a9ac2c59a2978591016"
  "/navigation/2de69750627751ec8521675f81e98c62"
  "/navigation/5f96c9ed0a973704dfc8cc6da6616113"
  "/navigation/19696cfb231f7972d097f69af49f89f0"
  "/navigation/b5b4eff9f3544a84266f40a77fca2337"
  "/navigation/6022d43a825903cbf46234727feb5bd7"
  "/navigation/a45297d9c8227d22b69e2e1008085447"
  "/navigation/00d1ba5ed00637d2d44b522c60226cb0"
  "/navigation/0125d0ad77fb1b05d8bb204a891e4502"
  "/navigation/b8df3f2b05ba58a593d2ee56ccba335d"
  "/navigation/1b0f946b06ca94bfce28cb83622ba398"
  "/navigation/3708b6199468a5be957742bfe571c21d"
  "/navigation/98823b16faa3aa70de9f90e021966330"
  "/navigation/b7eb6d4a11a085a8b29bac9f4ec515e6"
  "/navigation/8a358f7f7a3214b661d9fbcbb910205c"
  "/navigation/7925617dc93efab4e0ecc5b788286c1e"
  "/navigation/fe7b34c706c48edf709401d64f86d1cc"
  "/navigation/ca31137e7640c380636b2168c1fa6e77"
  "/navigation/d169c7407dd417152596908d48c11460"
  "/navigation/14e4a24e4f3519f44ae49ed18ebf9e6a"
  "/navigation/f5c94b1636a72e42561960527f3e0308"
  "/navigation/14b1f4e27b048122ca448dafa271f862"
  "/navigation/9a18cfac07bf3032d2c70bd920bba298"
  "/navigation/322dccbffacd4eea9ed49be3ff7bc92b"
  "/navigation/7fa57fd390435355a379e833925ea958"
  "/navigation/b9e8b44d66d88d42b9cfd16ac742bde8"
  "/navigation/1248b0a1c66c6c9264eee1b6857943d0"
  "/navigation/b9c1b73bd7bf2e8e398e6c749854cd8e"
  "/navigation/5dd921ffe71f6896b7973e02ef510c02"
  "/navigation/b3cc5c1f7571aad248ed530d417a0628"
  "/navigation/6ddab4775b855abe954cb129a64b6af2"
  "/navigation/090023649a89a2df6b23920180733ca5"
  "/navigation/be51978014ac795da0fa5ae7e5729f9d"
  "/navigation/9bd0feb9b7f8cd554add332ffbf12dbf"
  "/navigation/680cebfaa36e4f9013b320b1e036db5c"
  "/navigation/dc447ba510c825acffb02d1e52300f20"
  "/navigation/29bd676e6b0912a07f81031e4a80f85b"
  "/navigation/8d7e1fd82366bcf5df93d62a1ee767fc"
  "/navigation/3299835ccdb2855f1c96db3f5f9c027c"
  "/navigation/45829149d6b092916122ec88d226af16"
  "/navigation/d8be04feced570d6657e123246385bf5"
  "/navigation/99490a8aedae476a9a4672adeaaa14f0"
  "/navigation/e0bb31df94b27b383d84bf90918c2a94"
  "/navigation/5e3400be408250ebb7d36b8d33bb3660"
  "/navigation/e0f6369cd16e387c5dde09a1c00d7e23"
  "/navigation/87687cf97591fd137dd6a592d9497546"
  "/navigation/eb42826ecae7ccaf1d9a438b08b928a0"
  "/navigation/c25acadd33c84df68662dd116798f1fe"
  "/navigation/6ef1782cc8224b6fa6d35666ef12b86d"
  "/navigation/fd893af101024b25b0622620ead518d8"
  "/navigation/4e180668ce100cfd9873ab37a9289071"
  "/navigation/cf9a647b76ad238cc8265b4e28794bc2"
  "/navigation/c97f74df68adb4ec3c6a55c96c5419c5"
  "/navigation/c29cd3c66218bbe0db46425cbae8b4a6"
  "/navigation/f3cc52467cca75ab801056c04be5dbaa"
  "/navigation/9bf67e42e49cd13b0ffa799e11f73fcc"
  "/navigation/a1b3efd619b68eb8f053fc6e3040e219"
  "/navigation/2c32e9800da08fd440f3af8fe4e4c3f1"
  "/navigation/4e1caa4840851db73ed8e82a92be7232"
  "/navigation/c3bb5d3aebd67ac95da3c6576183b0ce"
  "/navigation/e77d37ca7d20aa99326f624766abfddb"
  "/navigation/37170a53399977229302e5efdfb4acb2"
  "/navigation/5a9467a9448385ed0463f8d7be0128a9"
  "/navigation/17faeb123a31d2619a622dfb13a100fc"
  "/navigation/da1ce3310aa51a92a99cb1ef92022e4c"
  "/navigation/0e9d9a15d940c060e22134cba17cfe1e"
  "/navigation/b9a7129b21f591f631aec5ae8b9f8e31"
  "/navigation/5656309fcc047a6baed238617779a152"
  "/navigation/a5b81dc66ad4e34e3914bf14e262466d"
  "/navigation/89d1e5147df8b579a8fb7a2ced11f722"
  "/navigation/cfc169667d4419c01666baad7899511d"
  "/navigation/18ea6973b240d85139a4ec39f8321598"
  "/navigation/1fe5a1368df51a7072668b1a4eec7ca4"
  "/navigation/8e175d0e28c022f20696d79274939add"
  "/navigation/38e6d1b4363b4c92bf1bbc33fbbda849"
  "/navigation/693e5dfdbe9fc3e847cec880025e0bdb"
  "/navigation/88c24880f670e8763422ee1b98d1b157"
  "/navigation/1340cc66c137829cfda4e0c0e594d3f2"
  "/navigation/7cc6181b626828d9abb67fe47e721df5"
  "/navigation/14de8d7390d62cff4e5a5b89a0a1bbce"
  "/navigation/c87d6e1cc12d6f4638c2a050274cdbd8"
  "/navigation/93581f432202ca2cd1195b12ef3949dc"
  "/navigation/5f400fb49f64904b598541e3aeca0523"
  "/navigation/c01d3849c44f2e4dcbee1e3545fc9530"
  "/navigation/7a23f07519ace36318ea36a17fb90d47"
  "/navigation/7bd833801b8afeda277ab2d41f9f4408"
  "/navigation/de60b7446b77a80f91178a99fb72ad86"
  "/navigation/28d19af33ec0e92b07d8b462715796db"
  "/navigation/650b04df18485aec4a72533d673799d3"
  "/navigation/6f2bcbe5b1bfadb29ca772bdfe459155"
  "/navigation/422d4eac299f022026b97025e9323bc5"
  "/navigation/d4196b60d45541b4b8253ec5161bdafa"
  "/navigation/51401d6dc5b3097f70290aebbc9347c2"
  "/navigation/64489f1a336139ed1e637dade1856693"
  "/navigation/6bf9a8a4164c70869caed547b6462807"
  "/navigation/b1801e4bd94e4c3884829fce02b93e43"
  "/navigation/49f811f3186f45c6ab88c4f8f9ab30a4"
  "/navigation/cff27de9f21a0bff3138d7f236dcf30a"
  "/navigation/77b88a9dea15db0ff687e7e42eebe574"
  "/navigation/c285228a8f522e9639a4a02dc6c77271"
  "/navigation/6f4975de562517ecdabcc32c5af2c0bb"
  "/navigation/5fac19313b3bb90f8dfb3a68f7cd12f0"
  "/navigation/3c48720f4415323241e0c64c586f2f2e"
  "/navigation/fb9f8d499e9d5148bf15e0b0089079db"
  "/navigation/7cfdeae3fe74b423ff544e776dd6ab5f"
  "/navigation/72ee40303e4373fa50f37b429b6439ff"
  "/navigation/0e4a6de45b77214f44a9383e5f535f82"
  "/navigation/0d5b735cf51c55f28f6c919eecaaec39"
  "/navigation/d264957f0ffd4b86d3f59be0e4af98a0"
  "/navigation/1d30202072371c91119604e8c12b743d"
  "/navigation/7f729ce10e76fd6aaa583c98eb41e7b8"
  "/navigation/b165330573252f7af4eb4a207deb8d9b"
  "/navigation/6d76a3caa1f64b67ab8ee1cc5ce4d3b7"
  "/navigation/0d3d880bb7e74e859e024e8502bc24ec"
  "/navigation/76c17deacd06e4b4c7b17761b23f95f1"
  "/navigation/7fe2f66cdc43983c6b24816bfe9cf6a0"
  "/navigation/2de0998bb8db3933d08797e7e004eed2"
  "/navigation/750340f0c3f1b07f5e4fb38797a182cd"
  "/navigation/412edaa11524444da2ae68ffc8e9c17f"
  "/navigation/34ed7c77c3bb4a86aa97ebb023c78d0f"
  "/navigation/ff802a29af50a8cb75c65aaac0decf67"
  "/navigation/528dd3293aea9151056a5f2d12a863b5"
  "/navigation/f00b832b0540f5e6b8a349eabbebed96"
  "/navigation/062f444899d63e125327072a75fc1896"
  "/navigation/e228254cab07b935b62fa144868d3d24"
  "/navigation/9f7bfc4dab5fe594b70864fb915ecba6"
  "/navigation/0c9e8c778d9f357dca2581dac8546b05"
  "/navigation/418fbdd04d633fe47ea0bb3938e081a7"
  "/navigation/16cb07d058f7abc9db00105313e17682"
  "/navigation/0ec920770779c4a9cfec5c0add8c50ca"
  "/navigation/461597dbdebb1bd8638a34ae445fc061"
  "/navigation/1968e48fc3704e845308beb21e6877fe"
  "/navigation/a6f97b978a8363db834279d7d35db137"
  "/navigation/8037de19c0a19c0ec49af21c77b423d6"
  "/navigation/1a50bd2bac267ae623a4ec1dc5fe5f81"
  "/navigation/396d9a1984bd2c959352a891f8f25c77"
  "/navigation/6826d6fe825462bcc65f365b6701bda5"
  "/navigation/beedb7aa8ba374baac5970e27b10326e"
  "/navigation/eb762df7bc19aec75ec19f8853a19e80"
  "/navigation/1505a9b128be093efdbfff6623117c3e"
  "/navigation/57a10763e9b7509c58e6b6ce8d631907"
  "/navigation/4a23886b3a4920a5fb8d91756a3f28ea"
  "/navigation/15192ed742879c01a7a835f6fafde955"
  "/navigation/211f66a8902dde3d983f41dd6c5cafb8"
  "/navigation/558cfb6ad6be4990b800f75e05b3fd8c"
  "/navigation/1d35f71167094bd4b6ce5399eb0d44a4"
  "/navigation/ad6fe633312c467598e7ed25367c27e7"
  "/navigation/ab43a08c1a254e86861b8c6ab193d206"
  "/navigation/06c50a3093fd4c1391ed8365f59251a6"
  "/navigation/68a77f1ab3de46fcb1cb3937e4dc2d43"
  "/navigation/0e53d76afa5d42f0b3c1fcdf8abbaa47"
  "/navigation/cb0cc806bec149fab65da924e105edf9"
  "/navigation/76828c8fa4222d216b7a7f3deea2dfcb"
  "/navigation/1831ffe550c7d9965bd3fb418381e35f"
  "/navigation/8e37a86681355850d9b63a794ffdbd9f"
  "/navigation/7f430bb91bf1415216944ddaf98ea32e"
  "/navigation/21731b21b089c81e0e1a5ed599316e2f"
  "/navigation/31dac7fbc97662aee4c823c3eeb96dc7"
  "/navigation/4843126cd5621809dae11b0edf2d7d0a"
  "/navigation/18ef33c4600cb489918c8fd9e3967b0b"
  "/navigation/aaa1c91a9cbdc026d33c4d1a3c6eabb1"
  "/navigation/2f6b044e6ae0d233d30a2c07b06c8a22"
  "/navigation/c0f06cce5095aa845cb941e3af00f6e5"
  "/navigation/2dabaf92a81c1ca0d11e46dc9b07a0ec"
  "/navigation/79af8839a07d066bbd5daabeadb0d5b5"
  "/navigation/872ba2b2e02979ece45b09a47034df8b"
  "/navigation/8faef7f380dfab1cd5271b5021fcf16d"
  "/navigation/e2e5760f88289b48ac2857a724f4dab9"
  "/navigation/fb01beddf65cd34e805546c843eb02a7"
  "/navigation/a1bfae4b7bfe9aaa29523796970a5f4a"
  "/navigation/ababb673325e7a2e5f1b0659400dd869"
  "/navigation/f64112eb3fbd29cc8f892f9d15c35e8d"
  "/navigation/fd8f7db9aee4a03d1f04baa80c1e6496"
  "/navigation/55d02e843c099865d2f6eeb23a3ce153"
  "/navigation/3652189815054979c0918b99654206b0"
  "/navigation/4fc3e81f7f132feabd9d3569f0551fd0"
  "/navigation/c31ffcb53c148b9d2a90bc3e2054621b"
  "/navigation/316b42e15b3280c0ab79b66bed29efbd"
  "/navigation/fa16cc11a7720ff65170eff67c9a078f"
  "/navigation/f9e9697590b6cdef84e84f6c31fd63ac"
  "/navigation/eea2cfb2f6714b2f0c6e3dc65f9c9197"
  "/navigation/7e79052964fbae028f498ec9ea839db3"
  "/navigation/a2157dd949ffa95f3b0fe524f1c7001c"
  "/navigation/c8a326fc266b097b8dad35cd7ee92386"
  "/navigation/53ed4e5c7db4369f332a49786f3d1494"
  "/navigation/f89477ffbaeea60919f22db18a91a2d5"
  "/navigation/7ac65d32f605b92deb1414e36cb66b42"
  "/navigation/b5a1382b577b8c190031534841b70dd0"
  "/navigation/8e0e4f2ebf5667f288c8e4ee75038545"
  "/navigation/2f4ffdb3091a39940aaadb8106c5b286"
  "/navigation/797f1bd3291383817b044a24347495e1"
  "/navigation/9ff29047f00eacbc5d9de59f50e06a2a"
  "/navigation/e2f0d489e103ffe1f70d7b31559552fd"
  "/navigation/a0d4140b651ae8b2a402e3039e430025"
  "/navigation/458c8a9212eb29b4f994ef17a5b19de2"
  "/navigation/44c5fc85e575ad077a2741d0b8bd5811"
  "/navigation/9516e0f297b194fed429672e8d623507"
  "/navigation/8de48a6bdff4b6770851ef1ec8e1087b"
  "/navigation/0209086cda6015ab5f8d87a5f8fc891a"
  "/navigation/776d69dd876bf6ef5c284ee7fc2a1cc2"
  "/navigation/521ee7940a175673fde91dded7b46cc2"
  "/navigation/84eaee735096e91526d027cb13d02cdd"
  "/navigation/b916c36ac46feaa29300d81da926070e"
  "/navigation/ecba883a3c9132fccb04cf3d60753bae"
  "/navigation/711c3e7aa4122da99659e89a59fb9d47"
  "/navigation/58e5f71b3815a5b6effd26c1709712f8"
  "/navigation/53cd871d53faf148344d12333300aa80"
  "/navigation/7425ded6f034d04086e78ca0dd73e5d3"
  "/navigation/b531c02bb4a2b90fd3d1462c26f9e03a"
  "/navigation/a41cf8209019ee12c8b7199e90e23d92"
  "/navigation/2c2bbae4d63b74f2f73e9b6dc020370d"
  "/navigation/bdd515296a485d2b6a6f580cf079f1a5"
  "/navigation/a850dc8ea721ee92ff437d556e0e28c0"
  "/navigation/4d5dfd41ee357743178f815e60885d78"
  "/navigation/f030d7655bcf03b04080da7e1fd8cac8"
  "/navigation/21d9cfb915acc95016cfeb5f437c284c"
  "/navigation/d1ad844a9d0ded2a2fb988cfe04c6d07"
  "/navigation/63b49718c6b9df67760a7e8ac75b3991"
  "/navigation/ab127fb7c2727dd8143c125038a14afb"
  "/navigation/43dc6624b95fd41414457959dce70112"
  "/navigation/335c8a76130f9f51ea084fcffa30f41e"
  "/navigation/924c7adebc8f88438d6f64ba9d7f5c33"
  "/navigation/c16e673c7dfdc47fb22ccc7f65444a11"
  "/navigation/6e67469fd7ef67b35ed1765312abb33e"
  "/navigation/168937c11f5ab0262643e4d6b0d3aacd"
  "/navigation/e341d5bec10354b20433c771f2082d30"
  "/navigation/5adfa5825c3e56e88b548281a4b54f44"
  "/navigation/6e23b6f3a5f9768d19cc49c0ff176f47"
  "/navigation/daa7861ddce4db8f22a33b8dffa825b8"
  "/navigation/0febcc112d2da8fb15ae29af3e6b07e8"
  "/navigation/b0057a07962be3e0a9071ec939004ea6"
  "/navigation/1cd8544df4a0461c7a4fcf66851e40e1"
  "/navigation/77cf1a15049d86b973a41e20460fdec5"
  "/navigation/39905a081d7a9b64be9caacac15caa09"
  "/navigation/7567aef6f3d8131ed7dee5dcf2daf095"
  "/navigation/281ebc2a4d594075652875eecf620e07"
  "/navigation/ba7020ca5c3b59da37adc8a2cd9406ef"
  "/navigation/e01a3f6f40df6daa6f50b45a2e93c5a4"
  "/navigation/0840c02023e1f1d3c79a47dd789ec29a"
  "/navigation/e5f7d8c588637b5c074fcd8f2323c003"
  "/navigation/2202c9173f244297f3894f40b56163c6"
  "/navigation/e846f7fb23d0bfa8e47af09a3fac5fa0"
  "/navigation/54d127ee2d58c62494ae87ad1f7d519c"
  "/navigation/e29bcd72169ecae2734ccfad06148811"
  "/navigation/254da6549a0e5eef83e591a51ccf8f9f"
  "/navigation/8d2405089bed88df64799c1c79802d07"
  "/navigation/0fb889b836119ccdc8cae0778802ff31"
  "/navigation/0eafeed1fed8ff89a80adc33db9ab421"
  "/navigation/a09b421e2c307ddc4904be90d41de41d"
  "/navigation/b1b09624c7741c35d5d89bdfd59d1c23"
  "/navigation/2895800562114bd9b4502ab648bebdda"
  "/navigation/76f951e853f81d142d27327c3d662e1a"
  "/navigation/6d1275e17d83f48e638c85f9a9b28a2b"
  "/navigation/962b8d4682068b47e9bf02556a8a198d"
  "/navigation/3f848fe1022e46bbbc0e8dcbbf19d3bb"
  "/navigation/8a3fbaedd50cd6baabbba47b9976e4db"
  "/navigation/711f403f95b565f6bb70aadf1b1507d2"
  "/navigation/74596b6603969b15d669b38d51cddc82"
  "/navigation/7223170c44ec4b01aa9051d6cbe5818b"
  "/navigation/7dc15ac2260f80e90c849908afe20a6e"
  "/navigation/d57fb3b2e6c6805d4786656f7935d8d0"
  "/navigation/8a1785c792025e020415bad4e467657f"
  "/navigation/fb4ecb58ee03753597399cdfaa95af74"
  "/navigation/7b32a3885109e2e179bf559c5c6785fc"
  "/navigation/a9350ceae715d116ebe4c338e6c7d42d"
  "/navigation/c5a73dce2d69b3a7df3f020925c99c28"
  "/navigation/433df5acba5dbcd87c6319147b0e4d9a"
  "/navigation/d6aa56991a6d75399e3d30d52049d3bc"
  "/navigation/10eebebb2f2df1c9a9dcfc0665786f06"
  "/navigation/35d7d818ddc2475a5f7dea28d52ce672"
  "/navigation/d7490a65800b2d74386ecbbce19e428c"
  "/navigation/0fa03bf6e17ba134867e0c29ce834436"
  "/navigation/add177b98ebe8365dc57c2d0bbc4940b"
  "/navigation/b00e874554b72661ead98a2fab2e6a68"
  "/navigation/d7fa16603b18c7f0f98334494c092225"
  "/navigation/2f3dab93fa0b0d7c0cec4679df9ed5cf"
  "/navigation/dcab4ea3baad7018778ae2bf60b96d25"
  "/navigation/9fd1e7b7abeed84f1f2ff9b383283f14"
  "/navigation/8cd224f57ae4d57cea7bf800b099864f"
  "/navigation/250edde0a739cfbb24d8cb3db1b7ec26"
  "/navigation/595bf03e2f2cc27db237b5fd2bd5687e"
  "/navigation/7b68acd89c73075a390a93d58225dc33"
  "/navigation/d3eb270d5e6064536a87d60d26b859de"
  "/navigation/527facb02edfd64d41469c754a81d60f"
  "/navigation/7c5d826272b4788af5d71353719f2daa"
  "/navigation/809bb629c29fec39870b7f7736d886d8"
  "/navigation/2a7ac28d1b895dfc5339a92c53d0e771"
  "/navigation/9939791c5a917dfc55fda098e40fc50e"
  "/navigation/9c9932213cdfbda0bf8e66827118c6a8"
  "/navigation/5e6677a664f1f6a5c7846a16561ce758"
  "/navigation/b591af510780910996b71e76ab8f9c8a"
  "/navigation/61279bbf78acae612dcf1a20246ac746"
  "/navigation/e08612ddafc9e1533bb1c03b7a550a87"
  "/navigation/630f9b6ab82deffd2d95d4e344eedabd"
  "/navigation/3172ba270973bc85c87111cc0a3e6fad"
  "/navigation/39a102a925a1be95922494b19f5f3904"
  "/navigation/cf905749d8644f5092cf77b3532b9322"
  "/navigation/55a1f889758964b77682904218fdb298"
  "/navigation/fe8237f9fe46ccc75e27a3292550d1b8"
  "/navigation/8cfe3c3b4dd440464a8faad30d4dfe8e"
  "/navigation/1b870f5436dd8fe39ea086492199db81"
  "/navigation/0b0244ac7e3272ea30d70f9a601eedf9"
  "/navigation/f9ae01053710aec906506f1e0d29e589"
  "/navigation/40f95b43c23988e4479675d306421138"
  "/navigation/aa0b4d4c4a93106240b4e52247d41fe8"
  "/navigation/c9e01d3e593d1b7d81502b4e90cde19e"
  "/navigation/53ee3650a38fe22fbba02a4b2e0a4ed9"
  "/navigation/3d4e60720b22333b1708b0d8035a634e"
  "/navigation/acd26e54d13232849fb100c82c8e1b92"
  "/navigation/4e491671112e7d39996db77bbfd75d89"
  "/navigation/7ea239fd1979e5d62937fd0dcc03b5f6"
  "/navigation/787506d1f03c2c8800edfabe8322361c"
  "/navigation/99b4bba600a325cfcb0bb0ecf986f017"
  "/navigation/0ff89de99d4a8f4b04cb162bcb5740cf"
  "/navigation/639fc2398fd45606ada087e30168287b"
  "/navigation/4dde77cd192e5101fe0a317e00ba3827"
  "/navigation/772a12a3721c69f0abc363824e6cf1b6"
  "/navigation/927a7d3b293f9ce80dc285a272682cd3"
  "/navigation/3ebcbafcd306d4fc25a9f0e26666cc62"
  "/navigation/7c471da97687baadd63d912264917022"
  "/navigation/5537bade1bf6a3e6487074cef8022c20"
  "/navigation/6494f43cd95fd76b64f77b4fcb4045fb"
  "/navigation/7aa03c3c187aa873b6f20d687ff5c92a"
  "/navigation/10ddf0a2c71ee5910c2bb8f4f9336b39"
  "/navigation/dafb688ddaf1c6c3d5e09ef61c0f0389"
  "/navigation/dddd504a84dbdc3f1646effec0708265"
  "/navigation/017deff5d229f037baa3f5206fda08e2"
  "/navigation/674ff6731b5d6a72332271aa254aaba4"
  "/navigation/70dcaeaa502f6fed750b28d73eacca63"
  "/navigation/8ca10608a248910c25083c3dab4371c3"
  "/navigation/f5a3c7703f11aede3989b7e9c2a815c6"
  "/navigation/9e29fb5b85151a6810ce7256b08475e4"
  "/navigation/768ca93450f97e9356647afb0dc3811f"
  "/navigation/6d710678a0a00bb4a7b7822d631ad5d4"
  "/navigation/b10e1fbf3764edf076cc1e37b8e371d6"
  "/navigation/cd700318a9b42ccbe2aef0598f179fa9"
  "/navigation/6258a9d20fe03e060369caa25ad5ad1e"
  "/navigation/e5c534b5e2eb4b6eaec179ddca1fa73c"
  "/navigation/dce9c2e861e6bdff54401a16fa399389"
  "/navigation/eaf242ac5226b0df1458b2bf21717569"
  "/navigation/50b2ff1aff31c3c705bdbe1390431789"
  "/navigation/d404fd0f3cfc65503c97bfe136b18f2d"
  "/navigation/b81b781aa850684f91c70a7bea770ab0"
  "/navigation/e907e704a5e4c013be95019e66c51162"
  "/navigation/b8c9c460c7a44f26cbd0f525012c9737"
  "/navigation/6cbedf797231a8d7918976b9b1069e23"
  "/navigation/e23689ee828bc6bc6a6ac3baaec4308a"
  "/navigation/3ee12b440e11f505e0a8a9e7e2239f65"
  "/navigation/be9242dc19415e9ab842bdad0f89a448"
  "/navigation/64a0ee2abab6e68eed9da34de85c4642"
  "/navigation/4f2e56e5395e3da2dc801bcd2ef4bbae"
  "/navigation/57eba5badfdbb901603d4324942cdcfe"
  "/navigation/4fa0be3cb645a31ab6ed82ab8eeb386d"
  "/navigation/f925e19f69f3fd273b8153a53b065738"
  "/navigation/88a2b8303f3059ad446acc14121bcce4"
  "/navigation/d7b59972e86f00e016b54288826786ae"
  "/navigation/6845ee14647d4700d5ad7f399cf8f17d"
  "/navigation/be8efb71ff1368b45ed328616af68e7e"
  "/navigation/ca58585cd878d3df6de7871d6d5a6e9e"
  "/navigation/b0b2b0545e076c8cf78b5b226dbe9456"
  "/navigation/7059ce5b9e1dba585ac055f7ad3a99ee"
  "/navigation/2683458197886186a24480f96b50537b"
  "/navigation/d4615a5c2d0d7ed37d7f48706acd67b2"
  "/navigation/93fc1afd3551891018f064afd42fc9d6"
  "/navigation/646a136484b965c0b4a1b18dfbb2c663"
  "/navigation/9530fcdb9351fb8cc163e51c47850c00"
  "/navigation/17c7f16f3ee11d226b05d904d94d98fd"
  "/navigation/b0dc19491a666b8af93bba3962d74fd4"
  "/navigation/d9c7e8adfe59935bb49f20423e35ed2b"
  "/navigation/6245c22afb85898a4ac451e3c741d737"
  "/navigation/ea8a8b940b32ce94e0fbd6129fe01796"
  "/navigation/1bd7238df6d9ea84b9a1adc48e784ea3"
  "/navigation/3f1816ce16c2b7b26fa7ef581a5b7658"
  "/navigation/89da8c2d42b407040b11533d97cd8620"
  "/navigation/b0f4f22ed2bfb469aab50e4de6cb3b2d"
  "/navigation/526468206bca24c1c90da6a312295cf4"
  "/navigation/afb5319ae67bb90d5988db74d628f4e4"
  "/navigation/a51ed5ac3d59086c865791993ecb7479"
  "/navigation/fa303a83c7b4b89cd495ad18283d0e74"
  "/navigation/a3f2950518cad1c2d3c8d6b8f0999c30"
  "/navigation/6c50ead5f8f9cac29c4c3066df9fba45"
  "/navigation/9648523ef1792e673e288da73f97afee"
  "/navigation/18430ac9cca70b276189de6dd7d65528"
  "/navigation/0053ebcd02e0338adedb2afe2b1c28b8"
  "/navigation/75b9242435d8912b9e95202180256f63"
  "/navigation/5fc6a91d8bab478fcf85ff9eee00a818"
  "/navigation/96b74ef522b17d41b557df58d0745141"
  "/navigation/2eeca4f78f2a04a35057c1fa7918e23b"
  "/navigation/588f3cfa4993105d745f3504b2faf50d"
  "/navigation/2e07a0cb439178cc32c7dcb5912554fe"
  "/navigation/80c7a3695a27188e1f0438bea4e615f5"
  "/navigation/e14cdd3f3aada57b6d93e7bc7fa81ba6"
  "/navigation/64badd35233ba2cd4946368ef2f4cf57"
  "/navigation/1ec8a971a88d917104824730cbd7b586"
  "/navigation/cce98ac5d754b32aca2d722291835f18"
  "/navigation/82c6c166b63c313498ad8a6df38f06cf"
  "/navigation/98d105a811fbd253e863833e122ce690"
  "/navigation/dc23b76a4d1e91ff4d772f9385439d75"
  "/navigation/7b5b2e102032913b11acba55dbe189f9"
  "/navigation/2ae0dfdacd61964c6d776296f849fde5"
  "/navigation/453f651149c1c6a58b09fb3beaeb220c"
  "/navigation/8d77c0a4d811f636c1be7ac7c6eca4e7"
  "/navigation/5e5a13c80cfdb6083ee17b5335e49564"
  "/navigation/c864533023cec5ab27670d0d9e0212a4"
  "/navigation/47a73e45ef4d15d753eb61afde0c0f84"
  "/navigation/57316020e03f24759dce0fedeab4caa6"
  "/navigation/e23b1b7e437b8f2a00964621dac8da5f"
  "/navigation/06e1eab6b6bdafc13b52c4fd51c8b271"
  "/navigation/fa418c1005e880c22753ddb515027d6f"
  "/navigation/0cf59dab628bcb72d5be9759aa80f1f2"
  "/navigation/df53941cb327a478eef11e80e41ae099"
  "/navigation/0440cbcfe3ec264ff3ff866af6ae0863"
  "/navigation/069ce0ee99979e714f815c210ad268e2"
  "/navigation/3f75b5c1bdd72c23f74f70130416c621"
  "/navigation/13d07ae7bd3488445854a6a274cfa2a6"
  "/navigation/2b03cae5e6e10df30be4cc195bd967c3"
  "/navigation/9093f6c436f930f151997c1933be6fcb"
  "/navigation/5eb99056600e7f05ca6f066869c055ab"
  "/navigation/4c0194f2fe974db18174a9257489ada5"
  "/navigation/026cd03caf5ecc40fc2fc8c9fa8d5a70"
  "/navigation/c520c8b8f5da02ce2812836bc8320648"
  "/navigation/b9c98ccd5d71a39b748bea0cc1230503"
  "/navigation/0a15ddc18d206a52d30a06f41fe2df4e"
  "/navigation/235d7f9ad18ecd7e6dc62ea4990cb9db"
  "/navigation/1740def10300ddab542af0bf1c07dcb2"
  "/navigation/99976656418bd5b326a03ac2182a6087"
  "/navigation/f5b6f5d036be2feddf52a86c897443ff"
  "/navigation/7ccd0aaf872e7dcb1f3a4e527222e354"
  "/navigation/2557a1e7e57e2768930ecae9013fdbf7"
  "/navigation/c227e91d9d923f343bd7ca512805a03c"
  "/navigation/1032e29d4b935d9522046870023e52fd"
  "/navigation/49e3fe21450d5993d23121d53942ab3b"
  "/navigation/582fc1ff6ab98cbf4d10dc9e5e7add86"
  "/navigation/12f70f9ceed629663ef0099e54970e89"
  "/navigation/5896ea86d9d3dd570a37952c0d0df4b5"
  "/navigation/0f2d31dc327ca9666b19c5a477760d2c"
  "/navigation/ed4f840895b2614ca59bc45ffb2eb15f"
  "/navigation/57c282a96132a7f3d1dbe740ee8a7aa4"
  "/navigation/a245a73f0d978e63f557779752b56baf"
  "/navigation/98455de20c2ad4bfed287a087ee078d1"
  "/navigation/4a728af8dc9951ef5ef21a768da7331f"
  "/navigation/b7c6c56e636d24f82bcabed726ad66b8"
  "/navigation/3fb8683d75ab6c4dae4cf6a1b07ff536"
  "/navigation/fcfe9a060680152e82aa172d576fe2eb"
  "/navigation/8f3918de08173cfa25ef96b1a70df613"
  "/navigation/4afa4bd01a7dea5ef99b50defb4e8d57"
  "/navigation/bc1fb48a71a3ad3dfbd7675fa051f7d7"
  "/navigation/4aa88f259633b81b7cdbbdc9d9038677"
  "/navigation/26cacdfc5b66ce2f1f0cb4467eb64b58"
  "/navigation/0b30bf83b03ae633458e9f18ab646b34"
  "/navigation/fa31f45b5a0f9009bc7a08b5df3dda73"
  "/navigation/d552cd01130a4b017de44970f01ad690"
  "/navigation/363e3a4ac2859f3506fae9fdf768660b"
  "/navigation/8134ec51747a116ca5d904b857490b56"
  "/navigation/5c7a69578676193916d432f806fff065"
  "/navigation/6b4fdbe061b8bc88cd9e13d79167d999"
  "/navigation/be5819e70bd28bfd8559d422a76d25be"
  "/navigation/c6a387358a825d386338a44ab3688d43"
  "/navigation/e71f0986097d7df5377a9359337ca371"
  "/navigation/96554199369af517bbdd265ae287c19a"
  "/navigation/7169efc946d65380d4f523a05d610a42"
  "/navigation/4edd8b6e64bf672ec6fdb073fc547234"
  "/navigation/246ad37580106205b78a18046c2dd2df"
  "/navigation/2491ed10bfc955cb996af5583fa2faa9"
  "/navigation/22165a2bf7e034976a1b72d50a596ba6"
  "/navigation/040f7371e9fad98112777a3ca519b599"
  "/navigation/8861ba1fb1d4ff95ccdb73f56cc15c3c"
  "/navigation/4ad376ab8a00610652cab1cf739229a6"
  "/navigation/1278a69e005742685d31f278a8a7db27"
  "/navigation/1e46841e74424c4a91454a0a1fdf4202"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b")\x1D­\vÿlK¢º±{WЧ\x11"
]
View formatted query    View runnable query    Explain query    View query backtrace
3.41 ms
(7.06%) 		6 
-- acris_checkout_method_preselect_payment_selection::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.title`, `payment_method.media.translation.title` as `payment_method.media.title`, `payment_method.media.translation.alt`, `payment_method.media.translation.alt` as `payment_method.media.alt`, `payment_method.media.translation.customFields`, `payment_method.media.translation.customFields` as `payment_method.media.customFields`, `payment_method.translation.name`, `payment_method.translation.name` as `payment_method.name`, `payment_method.translation.distinguishableName`, `payment_method.translation.distinguishableName` as `payment_method.distinguishableName`, `payment_method.translation.description`, `payment_method.translation.description` as `payment_method.description`, `payment_method.translation.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`.`distinguishable_name` as `payment_method.translation.distinguishableName`, `payment_method.translation`.`description` as `payment_method.translation.description`, `payment_method.translation`.`custom_fields` as `payment_method.translation.customFields` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.`language_id` = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.`media_id`, `payment_method.media.translation`.`alt` as `payment_method.media.translation.alt`, `payment_method.media.translation`.`title` as `payment_method.media.translation.title`, `payment_method.media.translation`.`custom_fields` as `payment_method.media.translation.customFields` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation`.`language_id` = ?) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"×éGK¥]AŠ»D…\x02Ï\x18(Ç"
  b"rERM´“I4­çÓ²Bj¶ü"
  b"À¨ûH¶HGÈ—øv[k\té\x18"
  b"\º¤•ÐOÔŒfP¦in@ü"
  b"Ÿr\x06¢Â<C°©=,ULËü\"
  b"Óˆ\x11ƒ+‘M\f£\x1C¶ß Æ=2"
  b"®²v\x7F°LCµÚš“¬³„9"
  b"XµlãÓ\x01D`ªM¶Û\e\x1Dä'"
  b"""
    ¿ w¯ËYE֐9\x04\n
    \x10¯Íú
    """
  b"MÈXµêoE%š\x15£´7æLó"
  b"-ý§ÐŽ\x18Gל\x1029@Jš<"
  b"„ÕKîÉG5²‘\‘SÇŽ•"
  b"¼&íó×TD\x19Žw•óTðôÒ"
  b"""
    TýÚWèbIŽ”+Ù\n
    *'=D
    """
  b"ÍFø⋹J`Œø¿Qçu¦1"
  b"/؈\x134NH\x15²"±ÁaÉ("
  b";Ò®Ô#%NšžH`Í£-Œ"
  b"\x13½Þ\tÄMBy±ª>0ÂÚ\x12"
  b"ÛNXÞ=\x05OBŽ¡½&È¿:œ"
  b"FÇ\x1D¼‘ F·®c J<[ï«"
  b"˜\x070Ê]DM.®ÞÀ\þú*_"
  b"ôI\x17‘\x17%C[„ä\x1D¤°e\x04Š"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.99 ms
(6.19%) 		6 
-- acris_checkout_method_preselect_shipping_selection::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.title`, `shipping_method.media.translation.title` as `shipping_method.media.title`, `shipping_method.media.translation.alt`, `shipping_method.media.translation.alt` as `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, `shipping_method.media.translation.customFields` as `shipping_method.media.customFields`, `shipping_method.translation.name`, `shipping_method.translation.name` as `shipping_method.name`, `shipping_method.translation.description`, `shipping_method.translation.description` as `shipping_method.description`, `shipping_method.translation.trackingUrl`, `shipping_method.translation.trackingUrl` as `shipping_method.trackingUrl`, `shipping_method.translation.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`.`custom_fields` as `shipping_method.translation.customFields`, `shipping_method.translation`.`description` as `shipping_method.translation.description`, `shipping_method.translation`.`tracking_url` as `shipping_method.translation.trackingUrl` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.`media_id`, `shipping_method.media.translation`.`alt` as `shipping_method.media.translation.alt`, `shipping_method.media.translation`.`title` as `shipping_method.media.translation.title`, `shipping_method.media.translation`.`custom_fields` as `shipping_method.media.translation.customFields` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation`.`language_id` = ?) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b" È\x11̵ÑIW·è ö\x1D7ªŽ"
  b"ó1Ã\x14ØŽEìž÷õ!›§<""
  b"Ò½z}€SAƒ½Z„¾’3ÿ>"
  b"""
    –_2vD×G¾“Ã\n
    €\x14ºeU
    """
  b"áM·t4ÞK㤠H˜„R}¾"
  b"""
    í6cóWE§–ËA“\n
    K–Ñ
    """
  b"EBìªÔÝEøžHJ\x0F\x1E\vÉ"
  b"Mé`9ßGE\x1E¦\x11w9ð!|+"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.83 ms
(5.86%) 		1 
-- product-cross-selling-route::search-ids
SELECT `product_cross_selling`.`id` FROM `product_cross_selling` LEFT JOIN `product` `product_cross_selling.product` ON `product_cross_selling`.`product_id` = `product_cross_selling.product`.`crossSellings` AND `product_cross_selling`.`product_version_id` = `product_cross_selling.product`.`version_id` LEFT JOIN `product` `product_cross_selling.product.parent` ON `product_cross_selling.product`.`parent_id` = `product_cross_selling.product.parent`.`id` AND `product_cross_selling.product`.`parent_version_id` = `product_cross_selling.product.parent`.`version_id` WHERE (`product_cross_selling.product`.`id` = ? AND `product_cross_selling`.`active` = ?) ORDER BY `product_cross_selling`.`position` ASC
Parameters: 
[
  b"Ú\x16?jUÞ D™O‡Û•f8‰"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
2.68 ms
(5.55%) 		6 
-- acris_checkout_method_preselect_shipping_selection::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` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `sales_channel` `shipping_method.salesChannels` ON `shipping_method.salesChannels.mapping`.`sales_channel_id` = `shipping_method.salesChannels`.`id`  WHERE (`shipping_method`.`active` = ? AND `shipping_method.salesChannels`.`id` = ?) GROUP BY `shipping_method`.`id` ORDER BY MIN(`shipping_method`.`position`) ASC, MIN(COALESCE(`shipping_method.translation.name`)) ASC
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  b")\x1D­\vÿlK¢º±{WЧ\x11"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.01 ms
(4.16%) 		6 
-- acris_checkout_method_preselect_payment_selection::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")\x1D­\vÿlK¢º±{WЧ\x11"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.77 ms
(3.67%) 		1 
-- product-detail-route::read
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`type` as `product.type`, `product`.`states` as `product.states`, `product.parent`.`cheapest_price` as `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.manufacturer`.`id` as `product.manufacturer.id`, `product.manufacturer`.`version_id` as `product.manufacturer.versionId`, `product.manufacturer`.`media_id` as `product.manufacturer.mediaId`, `product.manufacturer`.`created_at` as `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` as `product.manufacturer.updatedAt`, `product.manufacturer.media`.`id` as `product.manufacturer.media.id`, `product.manufacturer.media`.`user_id` as `product.manufacturer.media.userId`, `product.manufacturer.media`.`media_folder_id` as `product.manufacturer.media.mediaFolderId`, `product.manufacturer.media`.`mime_type` as `product.manufacturer.media.mimeType`, `product.manufacturer.media`.`file_extension` as `product.manufacturer.media.fileExtension`, `product.manufacturer.media`.`uploaded_at` as `product.manufacturer.media.uploadedAt`, `product.manufacturer.media`.`file_name` as `product.manufacturer.media.fileName`, `product.manufacturer.media`.`file_size` as `product.manufacturer.media.fileSize`, `product.manufacturer.media`.`media_type` as `product.manufacturer.media.mediaTypeRaw`, `product.manufacturer.media`.`meta_data` as `product.manufacturer.media.metaData`, `product.manufacturer.media`.`config` as `product.manufacturer.media.config`, `product.manufacturer.media`.`path` as `product.manufacturer.media.path`, `product.manufacturer.media`.`private` as `product.manufacturer.media.private`, `product.manufacturer.media`.`thumbnails_ro` as `product.manufacturer.media.thumbnailsRo`, `product.manufacturer.media`.`file_hash` as `product.manufacturer.media.fileHash`, `product.manufacturer.media`.`created_at` as `product.manufacturer.media.createdAt`, `product.manufacturer.media`.`updated_at` as `product.manufacturer.media.updatedAt`, `product.manufacturer.media.translation.title`, `product.manufacturer.media.translation.title` as `product.manufacturer.media.title`, `product.manufacturer.media.translation.alt`, `product.manufacturer.media.translation.alt` as `product.manufacturer.media.alt`, `product.manufacturer.media.translation.customFields`, `product.manufacturer.media.translation.customFields` as `product.manufacturer.media.customFields`, `product.manufacturer.translation.name`, `product.manufacturer.translation.name` as `product.manufacturer.name`, `product.manufacturer.translation.link`, `product.manufacturer.translation.link` as `product.manufacturer.link`, `product.manufacturer.translation.description`, `product.manufacturer.translation.description` as `product.manufacturer.description`, `product.manufacturer.translation.customFields`, `product.manufacturer.translation.customFields` as `product.manufacturer.customFields`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_option` `product.options.mapping`
                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, (SELECT GROUP_CONCAT(HEX(`product.properties.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_property` `product.properties.mapping`
                  WHERE `product.properties.mapping`.`product_id` = `product`.`properties` ) as `product.properties.id_mapping`, (SELECT GROUP_CONCAT(HEX(`product.categories.mapping`.`category_id`) SEPARATOR '||')
                  FROM `product_category` `product.categories.mapping`
                  WHERE `product.categories.mapping`.`product_id` = `product`.`categories` AND `product.categories.mapping`.product_version_id = `product`.version_id ) as `product.categories.id_mapping`, `product.unit`.`id` as `product.unit.id`, `product.unit`.`created_at` as `product.unit.createdAt`, `product.unit`.`updated_at` as `product.unit.updatedAt`, `product.unit.translation.shortCode`, `product.unit.translation.shortCode` as `product.unit.shortCode`, `product.unit.translation.name`, `product.unit.translation.name` as `product.unit.name`, `product.unit.translation.customFields`, `product.unit.translation.customFields` as `product.unit.customFields`, `product.deliveryTime`.`id` as `product.deliveryTime.id`, `product.deliveryTime`.`min` as `product.deliveryTime.min`, `product.deliveryTime`.`max` as `product.deliveryTime.max`, `product.deliveryTime`.`unit` as `product.deliveryTime.unit`, `product.deliveryTime`.`created_at` as `product.deliveryTime.createdAt`, `product.deliveryTime`.`updated_at` as `product.deliveryTime.updatedAt`, `product.deliveryTime.translation.name`, `product.deliveryTime.translation.name` as `product.deliveryTime.name`, `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation.customFields` as `product.deliveryTime.customFields`, `product.cover`.`id` as `product.cover.id`, `product.cover`.`version_id` as `product.cover.versionId`, `product.cover`.`product_id` as `product.cover.productId`, `product.cover`.`product_version_id` as `product.cover.productVersionId`, `product.cover`.`media_id` as `product.cover.mediaId`, `product.cover`.`position` as `product.cover.position`, `product.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, `product.cover.media`.`id` as `product.cover.media.id`, `product.cover.media`.`user_id` as `product.cover.media.userId`, `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` as `product.cover.media.fileName`, `product.cover.media`.`file_size` as `product.cover.media.fileSize`, `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` as `product.cover.media.metaData`, `product.cover.media`.`config` as `product.cover.media.config`, `product.cover.media`.`path` as `product.cover.media.path`, `product.cover.media`.`private` as `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, `product.cover.media`.`file_hash` as `product.cover.media.fileHash`, `product.cover.media`.`created_at` as `product.cover.media.createdAt`, `product.cover.media`.`updated_at` as `product.cover.media.updatedAt`, `product.cover.media.translation.title`, `product.cover.media.translation.title` as `product.cover.media.title`, `product.cover.media.translation.alt`, `product.cover.media.translation.alt` as `product.cover.media.alt`, `product.cover.media.translation.customFields`, `product.cover.media.translation.customFields` as `product.cover.media.customFields`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`meta_description` as `product.translation.metaDescription`, `product.translation`.`name` as `product.translation.name`, `product.translation`.`keywords` as `product.translation.keywords`, `product.translation`.`description` as `product.translation.description`, `product.translation`.`meta_title` as `product.translation.metaTitle`, `product.translation`.`pack_unit` as `product.translation.packUnit`, `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`, `product.translation`.`custom_fields` as `product.translation.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`meta_description` as `product.parent.translation.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` LEFT JOIN `media` `product.manufacturer.media` ON `product.manufacturer`.`media_id` = `product.manufacturer.media`.`id` LEFT JOIN (SELECT `product.manufacturer.translation`.`product_manufacturer_id`, `product.manufacturer.translation`.`product_manufacturer_version_id`, `product.manufacturer.translation`.`link` as `product.manufacturer.translation.link`, `product.manufacturer.translation`.`name` as `product.manufacturer.translation.name`, `product.manufacturer.translation`.`description` as `product.manufacturer.translation.description`, `product.manufacturer.translation`.`custom_fields` as `product.manufacturer.translation.customFields` FROM `product_manufacturer_translation` `product.manufacturer.translation` WHERE `product.manufacturer.translation`.`language_id` = ?) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_version_id` = `product.manufacturer`.`version_id` LEFT JOIN (SELECT `product.manufacturer.media.translation`.`media_id`, `product.manufacturer.media.translation`.`alt` as `product.manufacturer.media.translation.alt`, `product.manufacturer.media.translation`.`title` as `product.manufacturer.media.translation.title`, `product.manufacturer.media.translation`.`custom_fields` as `product.manufacturer.media.translation.customFields` FROM `media_translation` `product.manufacturer.media.translation` WHERE `product.manufacturer.media.translation`.`language_id` = ?) `product.manufacturer.media.media_translation` ON `product.manufacturer.media.media_translation`.`media_id` = `product.manufacturer.media`.`id` LEFT JOIN (SELECT `product.unit.translation`.`unit_id`, `product.unit.translation`.`short_code` as `product.unit.translation.shortCode`, `product.unit.translation`.`name` as `product.unit.translation.name`, `product.unit.translation`.`custom_fields` as `product.unit.translation.customFields` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation`.`language_id` = ?) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id` LEFT JOIN (SELECT `product.deliveryTime.translation`.`delivery_time_id`, `product.deliveryTime.translation`.`name` as `product.deliveryTime.translation.name`, `product.deliveryTime.translation`.`custom_fields` as `product.deliveryTime.translation.customFields` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation`.`language_id` = ?) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id` LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.cover.media.translation`.`media_id`, `product.cover.media.translation`.`alt` as `product.cover.media.translation.alt`, `product.cover.media.translation`.`title` as `product.cover.media.translation.title`, `product.cover.media.translation`.`custom_fields` as `product.cover.media.translation.customFields` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation`.`language_id` = ?) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"Ú\x16?jUÞ D™O‡Û•f8‰"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.75 ms
(3.63%) 		12 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b")\x1D­\vÿlK¢º±{WЧ\x11"
  "FfOzEYDUFj6H3a2BuMiIlrp9MkmyyiwM"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.39 ms
(2.88%) 		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.title`, `category.media.translation.title` as `category.media.title`, `category.media.translation.alt`, `category.media.translation.alt` as `category.media.alt`, `category.media.translation.customFields`, `category.media.translation.customFields` as `category.media.customFields`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.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`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.`language_id` = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (((`category`.`id` = ? OR (`category`.`path` LIKE ? AND (`category`.`level` > ? AND `category`.`level` <= ?)))))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"ŽžÆLWOAMŒÚlÞԁH8"
  "%|8d9ec64c574f414d8cda6cded4814838|%"
  1
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
0.96 ms
(1.99%) 		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"/»_ââšMpªXTÎ|ãâ\v"
  b")\x1D­\vÿlK¢º±{WЧ\x11"
  "00-Oberteil/SJ0101-L-TI"
  "00-Oberteil/SJ0101-L-TI/"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.92 ms
(1.91%) 		3 
SELECT DISTINCT LOWER(HEX(category_id)) FROM acris_available_category_customer_group
                 UNION
                 SELECT DISTINCT LOWER(HEX(category_id)) FROM acris_available_category_rule
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.74 ms
(1.53%) 		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"¨âJM€\x18J¾ŽƒD{Nú½€"
  b"`\x00ºýc(@\x18¤¤ò/Ž¬&0"
  b"""
    jð– bòF\n
    •‘]†hà&ÿ
    """
  b"·\eg‹\x18]Nô«5aö¬Ä¡"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.73 ms
(1.51%) 		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%"
  "%|8d9ec64c574f414d8cda6cded4814838|%"
  4
  true
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.71 ms
(1.47%) 		5 
#cart-persister::load
            SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters: 
[
  "FfOzEYDUFj6H3a2BuMiIlrp9MkmyyiwM"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.60 ms
(1.24%) 		1 
-- breadcrumb-extension::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.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`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?, ?, ?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"|TõkP\x1C/…&vy\x01e!<\e"
  b"U3§\x1Ff˜\x16rI\tsà÷G½¦"
  b"1‡Wâ’\x13›Í0´B\x1AÛtɦ"
  b"ÞŠ!Áºx¶ÈC‚G(\x0E³|I"
  b"*濬«ìij7“\t™§—ì3"
  b"ų©qýú[•CÙBV‘‹õ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.52 ms
(1.07%) 		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: 
[
  "/detail/da163f6a55de2044994f87db95663889"
  "/navigation/7c54f56b501c2f852676790165213c1b"
  "/navigation/5533a71f66981672490973e0f747bda6"
  "/navigation/318757e292139bcd30b4421adb74c9a6"
  "/navigation/de8a21c1ba78b6c8438247280eb37c49"
  "/navigation/2ae6bfacabecc4b337930999a797ec33"
  "/navigation/c5b3a971c3bdfa5b9543d94256918bf5"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b")\x1D­\vÿlK¢º±{WЧ\x11"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.50 ms
(1.04%) 		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.title`, `media.translation.title` as `media.title`, `media.translation.alt`, `media.translation.alt` as `media.alt`, `media.translation.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`.`title` as `media.translation.title`, `media.translation`.`custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation`.`language_id` = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  false
  true
  "product_download"
  b"\x01œöjy°p1Š\x02k%Ik6ù"
  b"^T\x123Ž\x15N\x1Fª¨7^Ä ã‰"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.50 ms
(1.03%) 		1 
SELECT `acris_order_fields`.`id` as `acris_order_fields.id`, `acris_order_fields`.`version_id` as `acris_order_fields.versionId`, `acris_order_fields`.`internal_id` as `acris_order_fields.internalId`, `acris_order_fields`.`internal_name` as `acris_order_fields.internalName`, `acris_order_fields`.`active` as `acris_order_fields.active`, `acris_order_fields`.`display_level` as `acris_order_fields.displayLevel`, `acris_order_fields`.`priority` as `acris_order_fields.priority`, `acris_order_fields`.`exclude_lower_priority` as `acris_order_fields.excludeLowerPriority`, `acris_order_fields`.`display_position_cart` as `acris_order_fields.displayPositionCart`, `acris_order_fields`.`display_position` as `acris_order_fields.displayPosition`, `acris_order_fields`.`display_position_finish` as `acris_order_fields.displayPositionFinish`, `acris_order_fields`.`display_position_product_detail` as `acris_order_fields.displayPositionProductDetail`, `acris_order_fields`.`is_required` as `acris_order_fields.isRequired`, `acris_order_fields`.`type` as `acris_order_fields.type`, `acris_order_fields`.`char_limit` as `acris_order_fields.charLimit`, `acris_order_fields`.`expert_mode` as `acris_order_fields.expertMode`, `acris_order_fields`.`regex` as `acris_order_fields.regex`, `acris_order_fields`.`date_picker_time` as `acris_order_fields.datePickerTime`, `acris_order_fields`.`date_picker_period` as `acris_order_fields.datePickerPeriod`, `acris_order_fields`.`date_picker_past_future` as `acris_order_fields.datePickerPastFuture`, `acris_order_fields`.`email_cc` as `acris_order_fields.emailCC`, `acris_order_fields`.`display_doc_credit` as `acris_order_fields.displayDocCredit`, `acris_order_fields`.`display_doc_delivery` as `acris_order_fields.displayDocDelivery`, `acris_order_fields`.`display_doc_invoice` as `acris_order_fields.displayDocInvoice`, `acris_order_fields`.`display_doc_storno` as `acris_order_fields.displayDocStorno`, `acris_order_fields`.`created_at` as `acris_order_fields.createdAt`, `acris_order_fields`.`updated_at` as `acris_order_fields.updatedAt`, (SELECT GROUP_CONCAT(HEX(`acris_order_fields.rules.mapping`.`rule_id`) SEPARATOR '||')
                  FROM `acris_order_fields_rule` `acris_order_fields.rules.mapping`
                  WHERE `acris_order_fields.rules.mapping`.`acris_order_fields_id` = `acris_order_fields`.`id` ) as `acris_order_fields.rules.id_mapping`, `acris_order_fields.translation.label`, `acris_order_fields.translation.label` as `acris_order_fields.label`, `acris_order_fields.translation.fieldLabel`, `acris_order_fields.translation.fieldLabel` as `acris_order_fields.fieldLabel`, `acris_order_fields.translation.placeholder`, `acris_order_fields.translation.placeholder` as `acris_order_fields.placeholder`, `acris_order_fields.translation.regexError`, `acris_order_fields.translation.regexError` as `acris_order_fields.regexError` FROM `acris_order_fields` LEFT JOIN (SELECT `acris_order_fields.translation`.`acris_order_fields_id`, `acris_order_fields.translation`.`acris_order_fields_version_id`, `acris_order_fields.translation`.`label` as `acris_order_fields.translation.label`, `acris_order_fields.translation`.`field_label` as `acris_order_fields.translation.fieldLabel`, `acris_order_fields.translation`.`placeholder` as `acris_order_fields.translation.placeholder`, `acris_order_fields.translation`.`regex_error` as `acris_order_fields.translation.regexError` FROM `acris_order_fields_translation` `acris_order_fields.translation` WHERE `acris_order_fields.translation`.`language_id` = ?) `acris_order_fields.acris_order_fields_translation` ON `acris_order_fields.acris_order_fields_translation`.`acris_order_fields_id` = `acris_order_fields`.`id` AND `acris_order_fields.acris_order_fields_translation`.`acris_order_fields_version_id` = `acris_order_fields`.`version_id` WHERE (`acris_order_fields`.`version_id` = ?) AND (`acris_order_fields`.`id` IN (?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"‡ÿhôMN\x19º\x10\rÕÙ‹\x11©"
  b"œš\t\x00:\x1AKM•H*\x10ÿ9P\x02"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.47 ms
(0.98%) 		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.title`, `payment_method.media.translation.title` as `payment_method.media.title`, `payment_method.media.translation.alt`, `payment_method.media.translation.alt` as `payment_method.media.alt`, `payment_method.media.translation.customFields`, `payment_method.media.translation.customFields` as `payment_method.media.customFields`, `payment_method.translation.name`, `payment_method.translation.name` as `payment_method.name`, `payment_method.translation.distinguishableName`, `payment_method.translation.distinguishableName` as `payment_method.distinguishableName`, `payment_method.translation.description`, `payment_method.translation.description` as `payment_method.description`, `payment_method.translation.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`.`distinguishable_name` as `payment_method.translation.distinguishableName`, `payment_method.translation`.`description` as `payment_method.translation.description`, `payment_method.translation`.`custom_fields` as `payment_method.translation.customFields` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.`language_id` = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.`media_id`, `payment_method.media.translation`.`alt` as `payment_method.media.translation.alt`, `payment_method.media.translation`.`title` as `payment_method.media.translation.title`, `payment_method.media.translation`.`custom_fields` as `payment_method.media.translation.customFields` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation`.`language_id` = ?) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"×éGK¥]AŠ»D…\x02Ï\x18(Ç"
  b"rERM´“I4­çÓ²Bj¶ü"
  b"À¨ûH¶HGÈ—øv[k\té\x18"
  b"\º¤•ÐOÔŒfP¦in@ü"
  b"Ÿr\x06¢Â<C°©=,ULËü\"
  b"Óˆ\x11ƒ+‘M\f£\x1C¶ß Æ=2"
  b"®²v\x7F°LCµÚš“¬³„9"
  b"XµlãÓ\x01D`ªM¶Û\e\x1Dä'"
  b"""
    ¿ w¯ËYE֐9\x04\n
    \x10¯Íú
    """
  b"MÈXµêoE%š\x15£´7æLó"
  b"-ý§ÐŽ\x18Gל\x1029@Jš<"
  b"„ÕKîÉG5²‘\‘SÇŽ•"
  b"¼&íó×TD\x19Žw•óTðôÒ"
  b"""
    TýÚWèbIŽ”+Ù\n
    *'=D
    """
  b"ÍFø⋹J`Œø¿Qçu¦1"
  b"/؈\x134NH\x15²"±ÁaÉ("
  b";Ò®Ô#%NšžH`Í£-Œ"
  b"\x13½Þ\tÄMBy±ª>0ÂÚ\x12"
  b"ÛNXÞ=\x05OBŽ¡½&È¿:œ"
  b"FÇ\x1D¼‘ F·®c J<[ï«"
  b"˜\x070Ê]DM.®ÞÀ\þú*_"
  b"ôI\x17‘\x17%C[„ä\x1D¤°e\x04Š"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.45 ms
(0.92%) 		2 
-- seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (path_info = ?) AND (is_canonical = 1) LIMIT 1
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b")\x1D­\vÿlK¢º±{WЧ\x11"
  "/_esi/global/header"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.44 ms
(0.90%) 		1 
SELECT `acris_order_fields`.`id` FROM `acris_order_fields` LEFT JOIN `acris_order_fields_rule` `acris_order_fields.rules.mapping` ON `acris_order_fields`.`id` = `acris_order_fields.rules.mapping`.`acris_order_fields_id`  LEFT JOIN `rule` `acris_order_fields.rules` ON `acris_order_fields.rules.mapping`.`rule_id` = `acris_order_fields.rules`.`id`  WHERE (`acris_order_fields`.`version_id` = ?) AND ((`acris_order_fields`.`active` = ? AND (`acris_order_fields.rules`.`id` <=> ? OR (`acris_order_fields.rules`.`id` IN (?, ?, ?, ?))))) GROUP BY `acris_order_fields`.`id` ORDER BY MAX(`acris_order_fields`.`priority`) DESC
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  true
  null
  b"¨âJM€\x18J¾ŽƒD{Nú½€"
  b"`\x00ºýc(@\x18¤¤ò/Ž¬&0"
  b"""
    jð– bòF\n
    •‘]†hà&ÿ
    """
  b"·\eg‹\x18]Nô«5aö¬Ä¡"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.43 ms
(0.89%) 		1 
-- product-detail-route::association::properties::read
SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group.translation.name`, `property_group_option.group.translation.name` as `property_group_option.group.name`, `property_group_option.group.translation.description`, `property_group_option.group.translation.description` as `property_group_option.group.description`, `property_group_option.group.translation.position`, `property_group_option.group.translation.position` as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, `property_group_option.group.translation.customFields` as `property_group_option.group.customFields`, `property_group_option.translation.name`, `property_group_option.translation.name` as `property_group_option.name`, `property_group_option.translation.position`, `property_group_option.translation.position` as `property_group_option.position`, `property_group_option.translation.customFields`, `property_group_option.translation.customFields` as `property_group_option.customFields` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.translation`.`property_group_option_id`, `property_group_option.translation`.`name` as `property_group_option.translation.name`, `property_group_option.translation`.`position` as `property_group_option.translation.position`, `property_group_option.translation`.`custom_fields` as `property_group_option.translation.customFields` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.`language_id` = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN (SELECT `property_group_option.group.translation`.`property_group_id`, `property_group_option.group.translation`.`name` as `property_group_option.group.translation.name`, `property_group_option.group.translation`.`description` as `property_group_option.group.translation.description`, `property_group_option.group.translation`.`position` as `property_group_option.group.translation.position`, `property_group_option.group.translation`.`custom_fields` as `property_group_option.group.translation.customFields` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.`language_id` = ?) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` WHERE `property_group_option`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"c¬ÌQ=H#¡É9BƒùÒ$"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.42 ms
(0.86%) 		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")\x1D­\vÿlK¢º±{WЧ\x11"
  b")\x1D­\vÿlK¢º±{WЧ\x11"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.41 ms
(0.86%) 		3 
SELECT DISTINCT LOWER(HEX(category_id))
                 FROM acris_available_category_customer_group
                 WHERE customer_group_id = UNHEX(?)
Parameters: 
[
  "cfbd5018d38d41d8adca10d94fc8bdd6"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.41 ms
(0.85%) 		1 
-- product-detail-route::association::mainCategories::read
SELECT `main_category`.`id` as `main_category.id`, `main_category`.`product_id` as `main_category.productId`, `main_category`.`product_version_id` as `main_category.productVersionId`, `main_category`.`category_id` as `main_category.categoryId`, `main_category`.`category_version_id` as `main_category.categoryVersionId`, `main_category`.`sales_channel_id` as `main_category.salesChannelId`, `main_category`.`created_at` as `main_category.createdAt`, `main_category`.`updated_at` as `main_category.updatedAt`, `main_category.category`.`id` as `main_category.category.id`, `main_category.category`.`version_id` as `main_category.category.versionId`, `main_category.category`.`parent_id` as `main_category.category.parentId`, `main_category.category`.`parent_version_id` as `main_category.category.parentVersionId`, `main_category.category`.`after_category_id` as `main_category.category.afterCategoryId`, `main_category.category`.`after_category_version_id` as `main_category.category.afterCategoryVersionId`, `main_category.category`.`media_id` as `main_category.category.mediaId`, `main_category.category`.`display_nested_products` as `main_category.category.displayNestedProducts`, `main_category.category`.`auto_increment` as `main_category.category.autoIncrement`, `main_category.category`.`level` as `main_category.category.level`, `main_category.category`.`path` as `main_category.category.path`, `main_category.category`.`child_count` as `main_category.category.childCount`, `main_category.category`.`type` as `main_category.category.type`, `main_category.category`.`product_assignment_type` as `main_category.category.productAssignmentType`, `main_category.category`.`visible` as `main_category.category.visible`, `main_category.category`.`active` as `main_category.category.active`, `main_category.category`.`cms_page_id` as `main_category.category.cmsPageId`, `main_category.category`.`cms_page_version_id` as `main_category.category.cmsPageVersionId`, `main_category.category`.`product_stream_id` as `main_category.category.productStreamId`, `main_category.category`.`custom_entity_type_id` as `main_category.category.customEntityTypeId`, `main_category.category`.`created_at` as `main_category.category.createdAt`, `main_category.category`.`updated_at` as `main_category.category.updatedAt`, `main_category.category.translation.name`, `main_category.category.translation.name` as `main_category.category.name`, `main_category.category.translation.breadcrumb`, `main_category.category.translation.breadcrumb` as `main_category.category.breadcrumb`, `main_category.category.translation.slotConfig`, `main_category.category.translation.slotConfig` as `main_category.category.slotConfig`, `main_category.category.translation.linkType`, `main_category.category.translation.linkType` as `main_category.category.linkType`, `main_category.category.translation.internalLink`, `main_category.category.translation.internalLink` as `main_category.category.internalLink`, `main_category.category.translation.externalLink`, `main_category.category.translation.externalLink` as `main_category.category.externalLink`, `main_category.category.translation.linkNewTab`, `main_category.category.translation.linkNewTab` as `main_category.category.linkNewTab`, `main_category.category.translation.description`, `main_category.category.translation.description` as `main_category.category.description`, `main_category.category.translation.metaTitle`, `main_category.category.translation.metaTitle` as `main_category.category.metaTitle`, `main_category.category.translation.metaDescription`, `main_category.category.translation.metaDescription` as `main_category.category.metaDescription`, `main_category.category.translation.keywords`, `main_category.category.translation.keywords` as `main_category.category.keywords`, `main_category.category.translation.customFields`, `main_category.category.translation.customFields` as `main_category.category.customFields` FROM `main_category` LEFT JOIN `category` `main_category.category` ON `main_category`.`category_id` = `main_category.category`.`id` AND `main_category`.`category_version_id` = `main_category.category`.`version_id` LEFT JOIN (SELECT `main_category.category.translation`.`category_id`, `main_category.category.translation`.`category_version_id`, `main_category.category.translation`.`breadcrumb` as `main_category.category.translation.breadcrumb`, `main_category.category.translation`.`name` as `main_category.category.translation.name`, `main_category.category.translation`.`custom_fields` as `main_category.category.translation.customFields`, `main_category.category.translation`.`slot_config` as `main_category.category.translation.slotConfig`, `main_category.category.translation`.`link_type` as `main_category.category.translation.linkType`, `main_category.category.translation`.`internal_link` as `main_category.category.translation.internalLink`, `main_category.category.translation`.`external_link` as `main_category.category.translation.externalLink`, `main_category.category.translation`.`link_new_tab` as `main_category.category.translation.linkNewTab`, `main_category.category.translation`.`description` as `main_category.category.translation.description`, `main_category.category.translation`.`meta_title` as `main_category.category.translation.metaTitle`, `main_category.category.translation`.`meta_description` as `main_category.category.translation.metaDescription`, `main_category.category.translation`.`keywords` as `main_category.category.translation.keywords` FROM `category_translation` `main_category.category.translation` WHERE `main_category.category.translation`.`language_id` = ?) `main_category.category.category_translation` ON `main_category.category.category_translation`.`category_id` = `main_category.category`.`id` AND `main_category.category.category_translation`.`category_version_id` = `main_category.category`.`version_id` WHERE (`main_category`.`sales_channel_id` = ? AND (`main_category`.`product_id` IN (?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b")\x1D­\vÿlK¢º±{WЧ\x11"
  b"Ú\x16?jUÞ D™O‡Û•f8‰"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.40 ms
(0.83%) 		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.title`, `shipping_method.media.translation.title` as `shipping_method.media.title`, `shipping_method.media.translation.alt`, `shipping_method.media.translation.alt` as `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, `shipping_method.media.translation.customFields` as `shipping_method.media.customFields`, `shipping_method.translation.name`, `shipping_method.translation.name` as `shipping_method.name`, `shipping_method.translation.description`, `shipping_method.translation.description` as `shipping_method.description`, `shipping_method.translation.trackingUrl`, `shipping_method.translation.trackingUrl` as `shipping_method.trackingUrl`, `shipping_method.translation.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`.`custom_fields` as `shipping_method.translation.customFields`, `shipping_method.translation`.`description` as `shipping_method.translation.description`, `shipping_method.translation`.`tracking_url` as `shipping_method.translation.trackingUrl` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.`media_id`, `shipping_method.media.translation`.`alt` as `shipping_method.media.translation.alt`, `shipping_method.media.translation`.`title` as `shipping_method.media.translation.title`, `shipping_method.media.translation`.`custom_fields` as `shipping_method.media.translation.customFields` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation`.`language_id` = ?) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b" È\x11̵ÑIW·è ö\x1D7ªŽ"
  b"ó1Ã\x14ØŽEìž÷õ!›§<""
  b"Ò½z}€SAƒ½Z„¾’3ÿ>"
  b"""
    –_2vD×G¾“Ã\n
    €\x14ºeU
    """
  b"áM·t4ÞK㤠H˜„R}¾"
  b"""
    í6cóWE§–ËA“\n
    K–Ñ
    """
  b"EBìªÔÝEøžHJ\x0F\x1E\vÉ"
  b"Mé`9ßGE\x1E¦\x11w9ð!|+"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(0.81%) 		1 
SELECT `acris_order_fields_restriction`.`id` as `acris_order_fields_restriction.id`, `acris_order_fields_restriction`.`acris_order_fields_version_id` as `acris_order_fields_restriction.acrisOrderFieldsVersionId`, `acris_order_fields_restriction`.`operator` as `acris_order_fields_restriction.operator`, `acris_order_fields_restriction`.`value` as `acris_order_fields_restriction.value`, `acris_order_fields_restriction`.`order_fields_id` as `acris_order_fields_restriction.fieldId`, `acris_order_fields_restriction`.`order_fields_restriction_id` as `acris_order_fields_restriction.restrictionId`, `acris_order_fields_restriction`.`created_at` as `acris_order_fields_restriction.createdAt`, `acris_order_fields_restriction`.`updated_at` as `acris_order_fields_restriction.updatedAt`, `acris_order_fields_restriction.restriction`.`id` as `acris_order_fields_restriction.restriction.id`, `acris_order_fields_restriction.restriction`.`version_id` as `acris_order_fields_restriction.restriction.versionId`, `acris_order_fields_restriction.restriction`.`internal_id` as `acris_order_fields_restriction.restriction.internalId`, `acris_order_fields_restriction.restriction`.`internal_name` as `acris_order_fields_restriction.restriction.internalName`, `acris_order_fields_restriction.restriction`.`active` as `acris_order_fields_restriction.restriction.active`, `acris_order_fields_restriction.restriction`.`display_level` as `acris_order_fields_restriction.restriction.displayLevel`, `acris_order_fields_restriction.restriction`.`priority` as `acris_order_fields_restriction.restriction.priority`, `acris_order_fields_restriction.restriction`.`exclude_lower_priority` as `acris_order_fields_restriction.restriction.excludeLowerPriority`, `acris_order_fields_restriction.restriction`.`display_position_cart` as `acris_order_fields_restriction.restriction.displayPositionCart`, `acris_order_fields_restriction.restriction`.`display_position` as `acris_order_fields_restriction.restriction.displayPosition`, `acris_order_fields_restriction.restriction`.`display_position_finish` as `acris_order_fields_restriction.restriction.displayPositionFinish`, `acris_order_fields_restriction.restriction`.`display_position_product_detail` as `acris_order_fields_restriction.restriction.displayPositionProductDetail`, `acris_order_fields_restriction.restriction`.`is_required` as `acris_order_fields_restriction.restriction.isRequired`, `acris_order_fields_restriction.restriction`.`type` as `acris_order_fields_restriction.restriction.type`, `acris_order_fields_restriction.restriction`.`char_limit` as `acris_order_fields_restriction.restriction.charLimit`, `acris_order_fields_restriction.restriction`.`expert_mode` as `acris_order_fields_restriction.restriction.expertMode`, `acris_order_fields_restriction.restriction`.`regex` as `acris_order_fields_restriction.restriction.regex`, `acris_order_fields_restriction.restriction`.`date_picker_time` as `acris_order_fields_restriction.restriction.datePickerTime`, `acris_order_fields_restriction.restriction`.`date_picker_period` as `acris_order_fields_restriction.restriction.datePickerPeriod`, `acris_order_fields_restriction.restriction`.`date_picker_past_future` as `acris_order_fields_restriction.restriction.datePickerPastFuture`, `acris_order_fields_restriction.restriction`.`email_cc` as `acris_order_fields_restriction.restriction.emailCC`, `acris_order_fields_restriction.restriction`.`display_doc_credit` as `acris_order_fields_restriction.restriction.displayDocCredit`, `acris_order_fields_restriction.restriction`.`display_doc_delivery` as `acris_order_fields_restriction.restriction.displayDocDelivery`, `acris_order_fields_restriction.restriction`.`display_doc_invoice` as `acris_order_fields_restriction.restriction.displayDocInvoice`, `acris_order_fields_restriction.restriction`.`display_doc_storno` as `acris_order_fields_restriction.restriction.displayDocStorno`, `acris_order_fields_restriction.restriction`.`created_at` as `acris_order_fields_restriction.restriction.createdAt`, `acris_order_fields_restriction.restriction`.`updated_at` as `acris_order_fields_restriction.restriction.updatedAt`, `acris_order_fields_restriction.restriction.translation.label`, `acris_order_fields_restriction.restriction.translation.label` as `acris_order_fields_restriction.restriction.label`, `acris_order_fields_restriction.restriction.translation.fieldLabel`, `acris_order_fields_restriction.restriction.translation.fieldLabel` as `acris_order_fields_restriction.restriction.fieldLabel`, `acris_order_fields_restriction.restriction.translation.placeholder`, `acris_order_fields_restriction.restriction.translation.placeholder` as `acris_order_fields_restriction.restriction.placeholder`, `acris_order_fields_restriction.restriction.translation.regexError`, `acris_order_fields_restriction.restriction.translation.regexError` as `acris_order_fields_restriction.restriction.regexError` FROM `acris_order_fields_restriction` LEFT JOIN `acris_order_fields` `acris_order_fields_restriction.restriction` ON `acris_order_fields_restriction`.`order_fields_restriction_id` = `acris_order_fields_restriction.restriction`.`id` AND `acris_order_fields_restriction`.`acris_order_fields_version_id` = `acris_order_fields_restriction.restriction`.`version_id` LEFT JOIN (SELECT `acris_order_fields_restriction.restriction.translation`.`acris_order_fields_id`, `acris_order_fields_restriction.restriction.translation`.`acris_order_fields_version_id`, `acris_order_fields_restriction.restriction.translation`.`label` as `acris_order_fields_restriction.restriction.translation.label`, `acris_order_fields_restriction.restriction.translation`.`field_label` as `acris_order_fields_restriction.restriction.translation.fieldLabel`, `acris_order_fields_restriction.restriction.translation`.`placeholder` as `acris_order_fields_restriction.restriction.translation.placeholder`, `acris_order_fields_restriction.restriction.translation`.`regex_error` as `acris_order_fields_restriction.restriction.translation.regexError` FROM `acris_order_fields_translation` `acris_order_fields_restriction.restriction.translation` WHERE `acris_order_fields_restriction.restriction.translation`.`language_id` = ?) `acris_order_fields_restriction.restriction.acris_order_fields_translation` ON `acris_order_fields_restriction.restriction.acris_order_fields_translation`.`acris_order_fields_id` = `acris_order_fields_restriction.restriction`.`id` AND `acris_order_fields_restriction.restriction.acris_order_fields_translation`.`acris_order_fields_version_id` = `acris_order_fields_restriction.restriction`.`version_id` WHERE ((`acris_order_fields_restriction`.`order_fields_id` IN (?, ?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"œš\t\x00:\x1AKM•H*\x10ÿ9P\x02"
  b"‡ÿhôMN\x19º\x10\rÕÙ‹\x11©"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(0.81%) 		1 
-- product-detail-route::find-best-variant::search-ids
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((`product`.`parent_id` = ? AND ((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?))) ORDER BY `product`.`available` DESC, IFNULL((ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) + 0.0))) as DECIMAL(30, 20)), 2)) * 100, 0) / 100), (ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) + 0.0))) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)) ASC LIMIT 1
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"Ú\x16?jUÞ D™O‡Û•f8‰"
  10
  b")\x1D­\vÿlK¢º±{WЧ\x11"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(0.80%) 		1 
-- product::cms-page::association::sections::read
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.title`, `cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title`, `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt`, `cms_section.backgroundMedia.translation.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`.`title` as `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.`custom_fields` as `cms_section.backgroundMedia.translation.customFields` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation`.`language_id` = ?) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id` WHERE (`cms_section`.`version_id` = ?) AND (((`cms_section`.`cms_page_id` IN (?))))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"Èð¢¶?AeƒeaªÏD\fã"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.37 ms
(0.77%) 		1 
-- product::cms-page::association::sections::association::blocks::read
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.title`, `cms_block.backgroundMedia.translation.title` as `cms_block.backgroundMedia.title`, `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation.alt` as `cms_block.backgroundMedia.alt`, `cms_block.backgroundMedia.translation.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`.`title` as `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.`custom_fields` as `cms_block.backgroundMedia.translation.customFields` FROM `media_translation` `cms_block.backgroundMedia.translation` WHERE `cms_block.backgroundMedia.translation`.`language_id` = ?) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation`.`media_id` = `cms_block.backgroundMedia`.`id` WHERE (`cms_block`.`version_id` = ?) AND (((`cms_block`.`cms_section_id` IN (?))))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"Á„Ø\x19¨@vµíÎ.£¾Mf"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.37 ms
(0.77%) 		3 
SELECT DISTINCT LOWER(HEX(category_id))
                     FROM acris_available_category_rule
                     WHERE rule_id IN (?, ?, ?, ?)
Parameters: 
[
  b"¨âJM€\x18J¾ŽƒD{Nú½€"
  b"`\x00ºýc(@\x18¤¤ò/Ž¬&0"
  b"""
    jð– bòF\n
    •‘]†hà&ÿ
    """
  b"·\eg‹\x18]Nô«5aö¬Ä¡"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(0.74%) 		2 
# navigation-route::meta-information
            SELECT LOWER(HEX(`id`)), `path`, `level`
            FROM `category`
            WHERE `id` = ? OR `id` = ?
Parameters: 
[
  b"ñ·\x08»¡\x7F\x1CéHÜ—ŸMp’¼"
  b"ñ·\x08»¡\x7F\x1CéHÜ—ŸMp’¼"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.35 ms
(0.73%) 		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.name`, `language.translationCode.translation.name` as `language.translationCode.name`, `language.translationCode.translation.territory`, `language.translationCode.translation.territory` as `language.translationCode.territory`, `language.translationCode.translation.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`.`territory` as `language.translationCode.translation.territory`, `language.translationCode.translation`.`custom_fields` as `language.translationCode.translation.customFields` FROM `locale_translation` `language.translationCode.translation` WHERE `language.translationCode.translation`.`language_id` = ?) `language.translationCode.locale_translation` ON `language.translationCode.locale_translation`.`locale_id` = `language.translationCode`.`id` WHERE `language`.`id` IN (?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"‰\x15Ÿi\x17EH½|У@‹ó|"
  b"Ö£"\x130\x14J¸’òâ\x07X<õ)"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.35 ms
(0.72%) 		1 
-- product::cms-page::read
SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`version_id` as `cms_page.versionId`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`css_class` as `cms_page.cssClass`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.translation.name`, `cms_page.translation.name` as `cms_page.name`, `cms_page.translation.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`.`custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.`language_id` = ?) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.`cms_page_version_id` = `cms_page`.`version_id` WHERE (`cms_page`.`version_id` = ?) AND (`cms_page`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"Èð¢¶?AeƒeaªÏD\fã"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.68%) 		1 
-- product::cms-page::association::sections::association::blocks::association::slots::read
SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`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.config`, `cms_slot.translation.config` as `cms_slot.config`, `cms_slot.translation.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`.`custom_fields` as `cms_slot.translation.customFields` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation`.`language_id` = ?) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` AND `cms_slot.cms_slot_translation`.`cms_slot_version_id` = `cms_slot`.`version_id` WHERE (`cms_slot`.`version_id` = ?) AND (((`cms_slot`.`cms_block_id` IN (?, ?, ?, ?, ?))))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"%@\x7F$,Ð@e€öd1?äXû"
  b"1HY=™ÀK'„ø_¾5”<i"
  b"qLB¤™QEF¦“¾ðPŠÔÂ"
  b"»Üþé\x19#N\r›#\x17ø|\x18¬L"
  b"æ0.¼ŸÃB'‡Õ~$>í6C"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(0.67%) 		1 
SELECT COUNT(DISTINCT `product_review`.`id`) as `review-count` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` WHERE (((`product_review`.`status` = ?) AND (`product_review.product`.`id` = ? OR `product_review.product`.`parent_id` = ?)))
Parameters: 
[
  true
  b"Ú\x16?jUÞ D™O‡Û•f8‰"
  b"Ú\x16?jUÞ D™O‡Û•f8‰"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(0.67%) 		1 
-- product-detail-route::association::categories::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.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`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"ų©qýú[•CÙBV‘‹õ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(0.65%) 		1 
-- breadcrumb-builder::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.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`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"ų©qýú[•CÙBV‘‹õ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(0.65%) 		1 
-- product-detail-route::association::media::read
SELECT `product_media`.`id` as `product_media.id`, `product_media`.`version_id` as `product_media.versionId`, `product_media`.`product_id` as `product_media.productId`, `product_media`.`product_version_id` as `product_media.productVersionId`, `product_media`.`media_id` as `product_media.mediaId`, `product_media`.`position` as `product_media.position`, `product_media`.`custom_fields` as `product_media.customFields`, `product_media`.`created_at` as `product_media.createdAt`, `product_media`.`updated_at` as `product_media.updatedAt`, `product_media.media`.`id` as `product_media.media.id`, `product_media.media`.`user_id` as `product_media.media.userId`, `product_media.media`.`media_folder_id` as `product_media.media.mediaFolderId`, `product_media.media`.`mime_type` as `product_media.media.mimeType`, `product_media.media`.`file_extension` as `product_media.media.fileExtension`, `product_media.media`.`uploaded_at` as `product_media.media.uploadedAt`, `product_media.media`.`file_name` as `product_media.media.fileName`, `product_media.media`.`file_size` as `product_media.media.fileSize`, `product_media.media`.`media_type` as `product_media.media.mediaTypeRaw`, `product_media.media`.`meta_data` as `product_media.media.metaData`, `product_media.media`.`config` as `product_media.media.config`, `product_media.media`.`path` as `product_media.media.path`, `product_media.media`.`private` as `product_media.media.private`, `product_media.media`.`thumbnails_ro` as `product_media.media.thumbnailsRo`, `product_media.media`.`file_hash` as `product_media.media.fileHash`, `product_media.media`.`created_at` as `product_media.media.createdAt`, `product_media.media`.`updated_at` as `product_media.media.updatedAt`, `product_media.media.translation.title`, `product_media.media.translation.title` as `product_media.media.title`, `product_media.media.translation.alt`, `product_media.media.translation.alt` as `product_media.media.alt`, `product_media.media.translation.customFields`, `product_media.media.translation.customFields` as `product_media.media.customFields` FROM `product_media` LEFT JOIN `media` `product_media.media` ON `product_media`.`media_id` = `product_media.media`.`id` LEFT JOIN (SELECT `product_media.media.translation`.`media_id`, `product_media.media.translation`.`alt` as `product_media.media.translation.alt`, `product_media.media.translation`.`title` as `product_media.media.translation.title`, `product_media.media.translation`.`custom_fields` as `product_media.media.translation.customFields` FROM `media_translation` `product_media.media.translation` WHERE `product_media.media.translation`.`language_id` = ?) `product_media.media.media_translation` ON `product_media.media.media_translation`.`media_id` = `product_media.media`.`id` WHERE (`product_media`.`version_id` = ?) AND (((`product_media`.`product_id` IN (?)))) ORDER BY `product_media`.`position` ASC
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"Ú\x16?jUÞ D™O‡Û•f8‰"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(0.64%) 		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` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `sales_channel` `shipping_method.salesChannels` ON `shipping_method.salesChannels.mapping`.`sales_channel_id` = `shipping_method.salesChannels`.`id`  WHERE (`shipping_method`.`active` = ? AND `shipping_method.salesChannels`.`id` = ?) GROUP BY `shipping_method`.`id` ORDER BY MIN(`shipping_method`.`position`) ASC, MIN(COALESCE(`shipping_method.translation.name`)) ASC
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  b")\x1D­\vÿlK¢º±{WЧ\x11"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(0.64%) 		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/9bb79afca45149dd80d02af306bb3bb0"
  "/navigation/6d93793297514446a50775fe9e2766bf"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b")\x1D­\vÿlK¢º±{WЧ\x11"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(0.60%) 		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.29 ms
(0.60%) 		1 
-- product-price-calculator::units::read
SELECT `unit`.`id` as `unit.id`, `unit`.`created_at` as `unit.createdAt`, `unit`.`updated_at` as `unit.updatedAt`, `unit.translation.shortCode`, `unit.translation.shortCode` as `unit.shortCode`, `unit.translation.name`, `unit.translation.name` as `unit.name`, `unit.translation.customFields`, `unit.translation.customFields` as `unit.customFields` FROM `unit` LEFT JOIN (SELECT `unit.translation`.`unit_id`, `unit.translation`.`short_code` as `unit.translation.shortCode`, `unit.translation`.`name` as `unit.translation.name`, `unit.translation`.`custom_fields` as `unit.translation.customFields` FROM `unit_translation` `unit.translation` WHERE `unit.translation`.`language_id` = ?) `unit.unit_translation` ON `unit.unit_translation`.`unit_id` = `unit`.`id`
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.24 ms
(0.49%) 		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")\x1D­\vÿlK¢º±{WЧ\x11"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(0.48%) 		1 
SELECT `acris_order_fields_val`.`id` as `acris_order_fields_val.id`, `acris_order_fields_val`.`acris_order_fields_version_id` as `acris_order_fields_val.acrisOrderFieldsVersionId`, `acris_order_fields_val`.`internal_id` as `acris_order_fields_val.internalId`, `acris_order_fields_val`.`position` as `acris_order_fields_val.position`, `acris_order_fields_val`.`is_preselected` as `acris_order_fields_val.isPreselected`, `acris_order_fields_val`.`order_fields_id` as `acris_order_fields_val.orderFieldsId`, `acris_order_fields_val`.`created_at` as `acris_order_fields_val.createdAt`, `acris_order_fields_val`.`updated_at` as `acris_order_fields_val.updatedAt`, `acris_order_fields_val.translation.label`, `acris_order_fields_val.translation.label` as `acris_order_fields_val.label` FROM `acris_order_fields_val` LEFT JOIN (SELECT `acris_order_fields_val.translation`.`acris_order_fields_val_id`, `acris_order_fields_val.translation`.`label` as `acris_order_fields_val.translation.label` FROM `acris_order_fields_val_translation` `acris_order_fields_val.translation` WHERE `acris_order_fields_val.translation`.`language_id` = ?) `acris_order_fields_val.acris_order_fields_val_translation` ON `acris_order_fields_val.acris_order_fields_val_translation`.`acris_order_fields_val_id` = `acris_order_fields_val`.`id` WHERE ((`acris_order_fields_val`.`order_fields_id` IN (?, ?))) ORDER BY `acris_order_fields_val`.`position` ASC
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"œš\t\x00:\x1AKM•H*\x10ÿ9P\x02"
  b"‡ÿhôMN\x19º\x10\rÕÙ‹\x11©"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(0.47%) 		1 
-- header::currencies::read
SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.shortName`, `currency.translation.shortName` as `currency.shortName`, `currency.translation.name`, `currency.translation.name` as `currency.name`, `currency.translation.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`.`name` as `currency.translation.name`, `currency.translation`.`custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.`language_id` = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01œ¾RŸþz\x05³]\x1A3>äŸá"
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.21 ms
(0.44%) 		1 
-- product-detail-route::search-ids
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?))) AND (`product`.`id` IN (?)) GROUP BY `product`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  10
  b")\x1D­\vÿlK¢º±{WЧ\x11"
  true
  b"Ú\x16?jUÞ D™O‡Û•f8‰"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(0.41%) 		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")\x1D­\vÿlK¢º±{WЧ\x11"
  b"­X®„"ÁDl™X©ßÎÚíÍ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.19 ms
(0.39%) 		1 
-- breadcrumb-builder::main-category::search-ids
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `main_category` `category.mainCategories` ON `category`.`id` = `category.mainCategories`.`category_id` AND `category`.version_id = `category.mainCategories`.category_version_id WHERE (`category`.`version_id` = ?) AND (((`category.mainCategories`.`product_id` = ? AND `category.mainCategories`.`sales_channel_id` = ? AND (`category`.`path` LIKE ? OR `category`.`path` LIKE ?)))) LIMIT 1
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"Ú\x16?jUÞ D™O‡Û•f8‰"
  b")\x1D­\vÿlK¢º±{WЧ\x11"
  "%|f1b708bba17f1ce948dc979f4d7092bc|%"
  "%|8d9ec64c574f414d8cda6cded4814838|%"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.18 ms
(0.38%) 		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.18 ms
(0.38%) 		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.18 ms
(0.38%) 		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")\x1D­\vÿlK¢º±{WЧ\x11"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.18 ms
(0.37%) 		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.17 ms
(0.36%) 		1 
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?)
Parameters: 
[
  b"""
    jð– bòF\n
    •‘]†hà&ÿ
    """
  b"""
    jð– bòF\n
    •‘]†hà&ÿ
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(0.36%) 		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š$Èm™q»¤¤ó\x03ãm\x0E"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.16 ms
(0.32%) 		1 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.15 ms
(0.31%) 		1 
-- product-detail-route::association::prices::read
SELECT `product_price`.`id` as `product_price.id`, `product_price`.`version_id` as `product_price.versionId`, `product_price`.`product_id` as `product_price.productId`, `product_price`.`product_version_id` as `product_price.productVersionId`, `product_price`.`rule_id` as `product_price.ruleId`, `product_price`.`price` as `product_price.price`, `product_price`.`quantity_start` as `product_price.quantityStart`, `product_price`.`quantity_end` as `product_price.quantityEnd`, `product_price`.`custom_fields` as `product_price.customFields`, `product_price`.`created_at` as `product_price.createdAt`, `product_price`.`updated_at` as `product_price.updatedAt` FROM `product_price` WHERE (`product_price`.`version_id` = ?) AND (((`product_price`.`product_id` IN (?))))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"Ú\x16?jUÞ D™O‡Û•f8‰"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.15 ms
(0.31%) 		1 
# product-detail-route::check-variant-listing-config
            SELECT
                variant_listing_config as variantListingConfig,
                parent_id as parentId
            FROM product
            WHERE id = ?
            AND version_id = ?
Parameters: 
[
  b"Ú\x16?jUÞ D™O‡Û•f8‰"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.14 ms
(0.29%) 		2 
SELECT url FROM sales_channel_domain
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.14 ms
(0.28%) 		1 
SELECT path FROM category WHERE id = ?
Parameters: 
[
  b"ų©qýú[•CÙBV‘‹õ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.27%) 		1 
-- breadcrumb-builder::search-ids
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` WHERE (`category`.`version_id` = ?) AND ((`category`.`active` = ? AND `category`.`visible` = ? AND (`category`.`path` LIKE ? OR `category`.`path` LIKE ?))) AND (`category`.`id` IN (?)) ORDER BY `category`.`level` DESC LIMIT 1
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  true
  true
  "%|f1b708bba17f1ce948dc979f4d7092bc|%"
  "%|8d9ec64c574f414d8cda6cded4814838|%"
  b"ų©qýú[•CÙBV‘‹õ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.12 ms
(0.25%) 		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.12 ms
(0.25%) 		1 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.12 ms
(0.24%) 		1 
SELECT
    `theme_id`,
    `technical_name`,
    `resolved_config`,
    `view_inheritance`,
    `script_files`,
    `icon_sets`,
    `updated_at`
    FROM `theme_runtime_config`
    WHERE `technical_name` = ?
Parameters: 
[
  "Storefront"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.11 ms
(0.22%) 		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.08 ms
(0.17%) 		1 
SELECT `min_search_length` FROM `product_search_config` WHERE `language_id` = ?
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
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.