GET https://dv-test-24-stage.scalecommerce.cloud/navigation/019759b80a407138993711f660ee1311

Response
200 OK
IP
216.73.216.157
Profiled on
Token
1ff5a0

Query Metrics

42 Database Queries
42 Different statements
40.37 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
12.85 ms
(31.82%) 		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/019759b80a407138993711f660ee1311"
  "/navigation/019759b80a3a7396a5778aaf39e0ff72"
  "/navigation/019759b80a4170cbad8085a2842416b3"
  "/navigation/019759b80a54702eb1e6ce83ad7f8ba4"
  "/navigation/019759b80a6370a6a5680919213f187d"
  "/navigation/019759b80a66716bb31a5f0dced34c8e"
  "/navigation/019759b80a70725f99f61f9d17fd4dc4"
  "/navigation/019759b80a7570669094348af10f8aea"
  "/navigation/019759b80a7c71a8a481c2d53e9ecf2c"
  "/navigation/019759b80a7e72419276f75eb3ac5016"
  "/navigation/019759b80a7f7015a97eec2c257dd1c9"
  "/navigation/019759b80a3b73579f10ef23ed146218"
  "/navigation/019759b80a3b73579f10ef23ed216bf2"
  "/navigation/019759b80a3b73579f10ef23ed7de16e"
  "/navigation/019759b80a3b73579f10ef23ee6558f4"
  "/navigation/019759b80a3b73579f10ef23ef491b38"
  "/navigation/019759b80a3b73579f10ef23f01e1e9e"
  "/navigation/019759b80a3b73579f10ef23f0f56fc8"
  "/navigation/019759b80a3b73579f10ef23f1a6b1d1"
  "/navigation/019759b80a3b73579f10ef23f24b868a"
  "/navigation/019759b80a3c71d5a4bcd92c0cf98bfe"
  "/navigation/019759b80a3c71d5a4bcd92c0dd9942d"
  "/navigation/019759b80a3c71d5a4bcd92c0e6eb991"
  "/navigation/019759b80a3c71d5a4bcd92c0ebf12e1"
  "/navigation/019759b80a3c71d5a4bcd92c0ec4afa5"
  "/navigation/019759b80a3c71d5a4bcd92c0f8795eb"
  "/navigation/019759b80a3c71d5a4bcd92c0fd9a148"
  "/navigation/019759b80a3c71d5a4bcd92c1016eff6"
  "/navigation/019759b80a3c71d5a4bcd92c1057a863"
  "/navigation/019759b80a3c71d5a4bcd92c11259e2e"
  "/navigation/019759b80a3c71d5a4bcd92c11a92f08"
  "/navigation/019759b80a3c71d5a4bcd92c12852db4"
  "/navigation/019759b80a3c71d5a4bcd92c134ef4fe"
  "/navigation/019759b80a3c71d5a4bcd92c135b3384"
  "/navigation/019759b80a3c71d5a4bcd92c14119b56"
  "/navigation/019759b80a3c71d5a4bcd92c141858ac"
  "/navigation/019759b80a3d7265a7fb48efea05ec13"
  "/navigation/019759b80a3d7265a7fb48efea2007ef"
  "/navigation/019759b80a3d7265a7fb48efea66080e"
  "/navigation/019759b80a3d7265a7fb48efead04373"
  "/navigation/019759b80a3d7265a7fb48efeaf8b7ae"
  "/navigation/019759b80a3d7265a7fb48efebbc4e8a"
  "/navigation/019759b80a3d7265a7fb48efebbf836d"
  "/navigation/019759b80a3d7265a7fb48efec20cc6a"
  "/navigation/019759b80a3d7265a7fb48efecca5afe"
  "/navigation/019759b80a3d7265a7fb48efed0cca7f"
  "/navigation/019759b80a3d7265a7fb48efed7db706"
  "/navigation/019759b80a3d7265a7fb48efed88928a"
  "/navigation/019759b80a3d7265a7fb48efee06dd1d"
  "/navigation/019759b80a3d7265a7fb48efee750f68"
  "/navigation/019759b80a3e724ab337bf375a2c619d"
  "/navigation/019759b80a3e724ab337bf375a553675"
  "/navigation/019759b80a3e724ab337bf375a684a38"
  "/navigation/019759b80a3e724ab337bf375a8dddad"
  "/navigation/019759b80a3e724ab337bf375af75d69"
  "/navigation/019759b80a3e724ab337bf375b9881d4"
  "/navigation/019759b80a3e724ab337bf375c872219"
  "/navigation/019759b80a3e724ab337bf375d43d511"
  "/navigation/019759b80a3e724ab337bf375d8d602a"
  "/navigation/019759b80a3e724ab337bf375e4ed026"
  "/navigation/019759b80a3e724ab337bf375ead6bcc"
  "/navigation/019759b80a3e724ab337bf375f3fb738"
  "/navigation/019759b80a3e724ab337bf37603a48a4"
  "/navigation/019759b80a3e724ab337bf37611e2c23"
  "/navigation/019759b80a3f72828581220e8d5e96d1"
  "/navigation/019759b80a3f72828581220e8d848803"
  "/navigation/019759b80a3f72828581220e8e06a233"
  "/navigation/019759b80a3f72828581220e8e61ba69"
  "/navigation/019759b80a3f72828581220e8f4eadb3"
  "/navigation/019759b80a3f72828581220e901306a5"
  "/navigation/019759b80a3f72828581220e907df24b"
  "/navigation/019759b80a3f72828581220e913057fa"
  "/navigation/019759b80a3f72828581220e914be835"
  "/navigation/019759b80a3f72828581220e91c0bf71"
  "/navigation/019759b80a3f72828581220e9202f047"
  "/navigation/019759b80a3f72828581220e92b660b8"
  "/navigation/019759b80a3f72828581220e937c2dd2"
  "/navigation/019759b80a407138993711f65ee43af8"
  "/navigation/019759b80a407138993711f65f249001"
  "/navigation/019759b80a407138993711f65f765f9b"
  "/navigation/019759b80a407138993711f65fceacaa"
  "/navigation/019759b80a407138993711f65ff3ed42"
  "/navigation/019759b80a407138993711f660b3fc3d"
  "/navigation/019759b80a407138993711f661d6196a"
  "/navigation/019759b80a407138993711f662a08572"
  "/navigation/019759b80a407138993711f662e6f46e"
  "/navigation/019759b80a407138993711f6631bc3d2"
  "/navigation/019759b80a407138993711f663f76d92"
  "/navigation/019759b80a407138993711f6644ab772"
  "/navigation/019759b80a4170cbad8085a28361806f"
  "/navigation/019759b80a4170cbad8085a2836ac460"
  "/navigation/019759b80a4170cbad8085a283efa6e6"
  "/navigation/019759b80a4170cbad8085a284377bbb"
  "/navigation/019759b80a4170cbad8085a2851a5923"
  "/navigation/019759b80a4170cbad8085a285b0ded8"
  "/navigation/019759b80a4170cbad8085a28739a81b"
  "/navigation/019759b80a4170cbad8085a28973e856"
  "/navigation/019759b80a42715b9b4f846cf7547592"
  "/navigation/019759b80a42715b9b4f846cf80cd62e"
  "/navigation/019759b80a42715b9b4f846cfa756672"
  "/navigation/019759b80a4371d1ad85f6c0e2ca4802"
  "/navigation/019759b80a4371d1ad85f6c0e4cc3e09"
  "/navigation/019759b80a4371d1ad85f6c0e71bda69"
  "/navigation/019759b80a4470e9a3f563a03f434fa8"
  "/navigation/019759b80a4470e9a3f563a040e62e90"
  "/navigation/019759b80a4470e9a3f563a0437571ca"
  "/navigation/019759b80a4470e9a3f563a046edb4b0"
  "/navigation/019759b80a45723089aaf91acdcdbc06"
  "/navigation/019759b80a45723089aaf91ace5ca5a9"
  "/navigation/019759b80a45723089aaf91acf192a24"
  "/navigation/019759b80a45723089aaf91ad1a219ed"
  "/navigation/019759b80a45723089aaf91ad3a84e32"
  "/navigation/019759b80a4670b69433ea73b07d44a9"
  "/navigation/019759b80a4670b69433ea73b0cfd155"
  "/navigation/019759b80a47732d86a28ff547b97441"
  "/navigation/019759b80a47732d86a28ff54a908189"
  "/navigation/019759b80a47732d86a28ff54dc982b4"
  "/navigation/019759b80a4871c6a94a91272fc67f78"
  "/navigation/019759b80a4871c6a94a91272ff40631"
  "/navigation/019759b80a4871c6a94a912731418347"
  "/navigation/019759b80a497033beca4cd610c073df"
  "/navigation/019759b80a497033beca4cd612395661"
  "/navigation/019759b80a497033beca4cd612e598a3"
  "/navigation/019759b80a497033beca4cd61348779e"
  "/navigation/019759b80a497033beca4cd614d3a3a4"
  "/navigation/019759b80a4a73bcac6f3924ed4380a2"
  "/navigation/019759b80a4a73bcac6f3924ef885104"
  "/navigation/019759b80a4a73bcac6f3924f3271e4b"
  "/navigation/019759b80a4a73bcac6f3924f3e42dea"
  "/navigation/019759b80a4a73bcac6f3924f4585b35"
  "/navigation/019759b80a4b7307bda21e19c2840edf"
  "/navigation/019759b80a4b7307bda21e19c5bede91"
  "/navigation/019759b80a4c730f8a5892800bcea87c"
  "/navigation/019759b80a4c730f8a5892800c721641"
  "/navigation/019759b80a4c730f8a5892800fffd0cc"
  "/navigation/019759b80a4d717a99794fcf76e90d07"
  "/navigation/019759b80a4d717a99794fcf7843de78"
  "/navigation/019759b80a4d717a99794fcf7c47f4f8"
  "/navigation/019759b80a4e705a8bf667eaa9bdc146"
  "/navigation/019759b80a4e705a8bf667eaa9faaa69"
  "/navigation/019759b80a4e705a8bf667eaaadc7bb4"
  "/navigation/019759b80a4e705a8bf667eaad97ad19"
  "/navigation/019759b80a4e705a8bf667eab075495f"
  "/navigation/019759b80a4f7237884f3eca5707a72b"
  "/navigation/019759b80a4f7237884f3eca58f00c74"
  "/navigation/019759b80a4f7237884f3eca5938cf68"
  "/navigation/019759b80a4f7237884f3eca5a523b2e"
  "/navigation/019759b80a507315a316fbce5f64e2b7"
  "/navigation/019759b80a507315a316fbce600f1348"
  "/navigation/019759b80a507315a316fbce60c26c70"
  "/navigation/019759b80a507315a316fbce631fd55f"
  "/navigation/019759b80a507315a316fbce6454d735"
  "/navigation/019759b80a5171cd928defdccc70a60d"
  "/navigation/019759b80a5171cd928defdccd6f9f17"
  "/navigation/019759b80a5171cd928defdcce9dedc2"
  "/navigation/019759b80a5270b58ecaccf26c3e3e79"
  "/navigation/019759b80a5270b58ecaccf26fa0e9ea"
  "/navigation/019759b80a5270b58ecaccf270464d19"
  "/navigation/019759b80a537347b61e1665d20d8fee"
  "/navigation/019759b80a537347b61e1665d6797d88"
  "/navigation/019759b80a537347b61e1665d69d8605"
  "/navigation/019759b80a54702eb1e6ce83aa58f69e"
  "/navigation/019759b80a54702eb1e6ce83ae27901a"
  "/navigation/019759b80a54702eb1e6ce83ae5b32d2"
  "/navigation/019759b80a54702eb1e6ce83af4bb83c"
  "/navigation/019759b80a557155b733a0c5f31577c9"
  "/navigation/019759b80a557155b733a0c5f4b4bada"
  "/navigation/019759b80a557155b733a0c5f89da2aa"
  "/navigation/019759b80a5673bc9587467a8620c402"
  "/navigation/019759b80a5673bc9587467a880bbdd0"
  "/navigation/019759b80a5673bc9587467a8874e059"
  "/navigation/019759b80a5673bc9587467a8aa0a7d1"
  "/navigation/019759b80a5773df9265f1da9788939f"
  "/navigation/019759b80a5773df9265f1da98688094"
  "/navigation/019759b80a5773df9265f1da9ad4477c"
  "/navigation/019759b80a5773df9265f1da9e3e0ec4"
  "/navigation/019759b80a5871059cff1d49da33ca62"
  "/navigation/019759b80a5871059cff1d49dafc09ca"
  "/navigation/019759b80a5871059cff1d49ded99a95"
  "/navigation/019759b80a597202a5eec87ce4365acc"
  "/navigation/019759b80a597202a5eec87ce4c13f24"
  "/navigation/019759b80a597202a5eec87ce7d0a075"
  "/navigation/019759b80a5a7046a9f019fa5133aac6"
  "/navigation/019759b80a5a7046a9f019fa52d634ac"
  "/navigation/019759b80a5a7046a9f019fa53bf916a"
  "/navigation/019759b80a5b70aeb94e30baaa68dac6"
  "/navigation/019759b80a5b70aeb94e30baaac5cbf3"
  "/navigation/019759b80a5b70aeb94e30baab2c36cb"
  "/navigation/019759b80a5b70aeb94e30baacb0944b"
  "/navigation/019759b80a5b70aeb94e30baae4aeb78"
  "/navigation/019759b80a5b70aeb94e30baae87f82a"
  "/navigation/019759b80a5c71f19045aa891ed620fe"
  "/navigation/019759b80a5c71f19045aa89216b48cb"
  "/navigation/019759b80a5c71f19045aa8922169529"
  "/navigation/019759b80a5c71f19045aa89258b3604"
  "/navigation/019759b80a5d70aeb89013a5345f86f5"
  "/navigation/019759b80a5d70aeb89013a53512b526"
  "/navigation/019759b80a5d70aeb89013a537ea5193"
  "/navigation/019759b80a5d70aeb89013a53998d4cc"
  "/navigation/019759b80a5d70aeb89013a53b141262"
  "/navigation/019759b80a5e70f89363ca3dc058786b"
  "/navigation/019759b80a5e70f89363ca3dc11766de"
  "/navigation/019759b80a5e70f89363ca3dc2e66e55"
  "/navigation/019759b80a5e70f89363ca3dc554bf30"
  "/navigation/019759b80a5f70cba66b0a2ac1bcf1a4"
  "/navigation/019759b80a5f70cba66b0a2ac2bbf6fb"
  "/navigation/019759b80a5f70cba66b0a2ac4901ee6"
  "/navigation/019759b80a60727c8218b4fe68f50c57"
  "/navigation/019759b80a60727c8218b4fe6c1f865d"
  "/navigation/019759b80a60727c8218b4fe6dd47b95"
  "/navigation/019759b80a61715ca4d248c74254718f"
  "/navigation/019759b80a61715ca4d248c7430536b2"
  "/navigation/019759b80a61715ca4d248c746997ac8"
  "/navigation/019759b80a61715ca4d248c747c0658b"
  "/navigation/019759b80a627364ade8c4904fd22cca"
  "/navigation/019759b80a627364ade8c49050989e16"
  "/navigation/019759b80a627364ade8c49052c34b02"
  "/navigation/019759b80a627364ade8c49055ee51b7"
  "/navigation/019759b80a627364ade8c4905655ef25"
  "/navigation/019759b80a6370a6a56809192066e410"
  "/navigation/019759b80a6370a6a56809192207e070"
  "/navigation/019759b80a6370a6a56809192237c8aa"
  "/navigation/019759b80a6370a6a568091922d29dd1"
  "/navigation/019759b80a6370a6a56809192373fcc4"
  "/navigation/019759b80a647288a83f7244a0a7570d"
  "/navigation/019759b80a647288a83f7244a172c69a"
  "/navigation/019759b80a647288a83f7244a1e41e5c"
  "/navigation/019759b80a647288a83f7244a2b8a163"
  "/navigation/019759b80a647288a83f7244a3575808"
  "/navigation/019759b80a647288a83f7244a4154150"
  "/navigation/019759b80a647288a83f7244a45d54ca"
  "/navigation/019759b80a647288a83f7244a557f842"
  "/navigation/019759b80a647288a83f7244a6337a6e"
  "/navigation/019759b80a647288a83f7244a6d45079"
  "/navigation/019759b80a647288a83f7244a7222f6e"
  "/navigation/019759b80a647288a83f7244a813fbb0"
  "/navigation/019759b80a647288a83f7244a8433b9e"
  "/navigation/019759b80a6570d1bad7418497f191e9"
  "/navigation/019759b80a6570d1bad7418498dedb3e"
  "/navigation/019759b80a6570d1bad7418499aa3518"
  "/navigation/019759b80a6570d1bad741849a03340c"
  "/navigation/019759b80a6570d1bad741849a3e204b"
  "/navigation/019759b80a6570d1bad741849a59c3f8"
  "/navigation/019759b80a6570d1bad741849a78f061"
  "/navigation/019759b80a6570d1bad741849b102e90"
  "/navigation/019759b80a6570d1bad741849b9e0983"
  "/navigation/019759b80a6570d1bad741849c052b9e"
  "/navigation/019759b80a6570d1bad741849c5952de"
  "/navigation/019759b80a6570d1bad741849d22f68b"
  "/navigation/019759b80a6570d1bad741849e08d083"
  "/navigation/019759b80a66716bb31a5f0dceb6e99e"
  "/navigation/019759b80a66716bb31a5f0dcf8ce620"
  "/navigation/019759b80a66716bb31a5f0dd0179bd5"
  "/navigation/019759b80a66716bb31a5f0dd11185e3"
  "/navigation/019759b80a66716bb31a5f0dd356e5ca"
  "/navigation/019759b80a6773e5a1d10255cad1df1e"
  "/navigation/019759b80a6773e5a1d10255cdcc522e"
  "/navigation/019759b80a68706c84d05741b875bb54"
  "/navigation/019759b80a68706c84d05741bc32f58d"
  "/navigation/019759b80a68706c84d05741bcffa042"
  "/navigation/019759b80a6971dbb5cfaed77c7956d5"
  "/navigation/019759b80a6971dbb5cfaed7804ab401"
  "/navigation/019759b80a6971dbb5cfaed7821a9438"
  "/navigation/019759b80a6a732fad6cec970953cb6a"
  "/navigation/019759b80a6a732fad6cec970b95a237"
  "/navigation/019759b80a6a732fad6cec970c89291e"
  "/navigation/019759b80a6b7279b1c560db09e2f437"
  "/navigation/019759b80a6b7279b1c560db0a71b9d5"
  "/navigation/019759b80a6b7279b1c560db0b0b7251"
  "/navigation/019759b80a6b7279b1c560db0da6ccab"
  "/navigation/019759b80a6c70efa65d822528ef0013"
  "/navigation/019759b80a6c70efa65d8225290e4760"
  "/navigation/019759b80a6c70efa65d82252ca40bdd"
  "/navigation/019759b80a6c70efa65d82252f0fb8ee"
  "/navigation/019759b80a6d713785faab2411f7c152"
  "/navigation/019759b80a6d713785faab2413bbb4d6"
  "/navigation/019759b80a6d713785faab2416789d71"
  "/navigation/019759b80a6e71cda3640a8c432939a2"
  "/navigation/019759b80a6e71cda3640a8c4594dc51"
  "/navigation/019759b80a6e71cda3640a8c45ede2c4"
  "/navigation/019759b80a6f72b8b45d0b0488552abd"
  "/navigation/019759b80a6f72b8b45d0b048c1aa638"
  "/navigation/019759b80a6f72b8b45d0b048ecd1764"
  "/navigation/019759b80a70725f99f61f9d18804018"
  "/navigation/019759b80a70725f99f61f9d1915ab11"
  "/navigation/019759b80a70725f99f61f9d19b8afa5"
  "/navigation/019759b80a70725f99f61f9d19d92a6a"
  "/navigation/019759b80a70725f99f61f9d19e3f085"
  "/navigation/019759b80a70725f99f61f9d1a1ac8e9"
  "/navigation/019759b80a70725f99f61f9d1a9ccb8e"
  "/navigation/019759b80a70725f99f61f9d1aa9c718"
  "/navigation/019759b80a70725f99f61f9d1affabc1"
  "/navigation/019759b80a70725f99f61f9d1ba1b529"
  "/navigation/019759b80a70725f99f61f9d1c039a8c"
  "/navigation/019759b80a70725f99f61f9d1cde40fd"
  "/navigation/019759b80a7173e6be46ce4db642035f"
  "/navigation/019759b80a7173e6be46ce4db6757132"
  "/navigation/019759b80a7173e6be46ce4db772bea6"
  "/navigation/019759b80a7173e6be46ce4db78142ca"
  "/navigation/019759b80a7173e6be46ce4db7ec86ba"
  "/navigation/019759b80a7173e6be46ce4db82c3edc"
  "/navigation/019759b80a7173e6be46ce4db8dafdee"
  "/navigation/019759b80a7173e6be46ce4db8e13674"
  "/navigation/019759b80a7173e6be46ce4db9cd6237"
  "/navigation/019759b80a7173e6be46ce4db9e431f3"
  "/navigation/019759b80a7173e6be46ce4dba71d58b"
  "/navigation/019759b80a7173e6be46ce4dbad37a8f"
  "/navigation/019759b80a72738295ab1353c3a69f43"
  "/navigation/019759b80a72738295ab1353c3bab63c"
  "/navigation/019759b80a72738295ab1353c3da4273"
  "/navigation/019759b80a72738295ab1353c3de7db4"
  "/navigation/019759b80a72738295ab1353c3e48b0a"
  "/navigation/019759b80a72738295ab1353c4a5e512"
  "/navigation/019759b80a72738295ab1353c53256b4"
  "/navigation/019759b80a72738295ab1353c5ff96c6"
  "/navigation/019759b80a72738295ab1353c69e89e1"
  "/navigation/019759b80a72738295ab1353c7106906"
  "/navigation/019759b80a72738295ab1353c799837a"
  "/navigation/019759b80a737338b7a766245dafc0e3"
  "/navigation/019759b80a737338b7a766245e65b7c4"
  "/navigation/019759b80a737338b7a766245e7f6936"
  "/navigation/019759b80a737338b7a766245f228143"
  "/navigation/019759b80a737338b7a766245f4c0c9e"
  "/navigation/019759b80a737338b7a766245fb67788"
  "/navigation/019759b80a737338b7a7662460233576"
  "/navigation/019759b80a737338b7a76624605eb148"
  "/navigation/019759b80a737338b7a7662460c504b9"
  "/navigation/019759b80a737338b7a766246168a43c"
  "/navigation/019759b80a737338b7a7662461bd14b4"
  "/navigation/019759b80a737338b7a7662462370e26"
  "/navigation/019759b80a7472969a1bb2bd32a65844"
  "/navigation/019759b80a7472969a1bb2bd3398dcd1"
  "/navigation/019759b80a7472969a1bb2bd34740759"
  "/navigation/019759b80a7472969a1bb2bd3492f87f"
  "/navigation/019759b80a7472969a1bb2bd354943d1"
  "/navigation/019759b80a7472969a1bb2bd355de51d"
  "/navigation/019759b80a7472969a1bb2bd35f1540a"
  "/navigation/019759b80a7472969a1bb2bd361c438b"
  "/navigation/019759b80a7472969a1bb2bd369fba22"
  "/navigation/019759b80a7472969a1bb2bd3744b4a2"
  "/navigation/019759b80a7472969a1bb2bd38252645"
  "/navigation/019759b80a7472969a1bb2bd38ed594c"
  "/navigation/019759b80a7472969a1bb2bd39325a11"
  "/navigation/019759b80a7472969a1bb2bd399c97a5"
  "/navigation/019759b80a7570669094348af030381e"
  "/navigation/019759b80a7570669094348af0885aed"
  "/navigation/019759b80a7570669094348af095a1b9"
  "/navigation/019759b80a7570669094348af20507b6"
  "/navigation/019759b80a7570669094348af2c04faf"
  "/navigation/019759b80a7570669094348af2fb17f0"
  "/navigation/019759b80a7570669094348af3a5df60"
  "/navigation/019759b80a7570669094348af3e93c45"
  "/navigation/019759b80a7570669094348af4af7afc"
  "/navigation/019759b80a7570669094348af54136b5"
  "/navigation/019759b80a7570669094348af5e6d6d5"
  "/navigation/019759b80a76700ea74136d35cb83b38"
  "/navigation/019759b80a76700ea74136d35daff027"
  "/navigation/019759b80a76700ea74136d35ddf1848"
  "/navigation/019759b80a76700ea74136d35eb6fc6a"
  "/navigation/019759b80a76700ea74136d35f9577db"
  "/navigation/019759b80a76700ea74136d360456fa5"
  "/navigation/019759b80a76700ea74136d3611397ab"
  "/navigation/019759b80a76700ea74136d361fb6cea"
  "/navigation/019759b80a76700ea74136d362173b2d"
  "/navigation/019759b80a76700ea74136d362fccee1"
  "/navigation/019759b80a76700ea74136d3631058ba"
  "/navigation/019759b80a76700ea74136d363d8be7f"
  "/navigation/019759b80a76700ea74136d364b93152"
  "/navigation/019759b80a76700ea74136d3656a3460"
  "/navigation/019759b80a77733c83946829f77cb7e0"
  "/navigation/019759b80a77733c83946829f839e9e2"
  "/navigation/019759b80a77733c83946829f89a8115"
  "/navigation/019759b80a77733c83946829f96e3090"
  "/navigation/019759b80a77733c83946829fa01f7a2"
  "/navigation/019759b80a77733c83946829fa7b24b1"
  "/navigation/019759b80a77733c83946829fb456c7e"
  "/navigation/019759b80a77733c83946829fbd22cdd"
  "/navigation/019759b80a77733c83946829fc719eb4"
  "/navigation/019759b80a77733c83946829fd1bb385"
  "/navigation/019759b80a77733c83946829fdbd4583"
  "/navigation/019759b80a77733c83946829fe4ff607"
  "/navigation/019759b80a78712d92dc601a3eec02c5"
  "/navigation/019759b80a78712d92dc601a3faf6788"
  "/navigation/019759b80a78712d92dc601a3fe686d4"
  "/navigation/019759b80a78712d92dc601a400c4d0f"
  "/navigation/019759b80a78712d92dc601a4016a4c2"
  "/navigation/019759b80a78712d92dc601a40d6e878"
  "/navigation/019759b80a78712d92dc601a4170376a"
  "/navigation/019759b80a78712d92dc601a418ad48d"
  "/navigation/019759b80a78712d92dc601a41a730c0"
  "/navigation/019759b80a78712d92dc601a42727788"
  "/navigation/019759b80a78712d92dc601a4365c65f"
  "/navigation/019759b80a78712d92dc601a438427e4"
  "/navigation/019759b80a7973ec87e4c8daa5a7ae30"
  "/navigation/019759b80a7973ec87e4c8daa5d3d194"
  "/navigation/019759b80a7973ec87e4c8daa695e932"
  "/navigation/019759b80a7973ec87e4c8daa6a95297"
  "/navigation/019759b80a7973ec87e4c8daa6d6945b"
  "/navigation/019759b80a7973ec87e4c8daa76501a2"
  "/navigation/019759b80a7973ec87e4c8daa837e022"
  "/navigation/019759b80a7973ec87e4c8daa90c3137"
  "/navigation/019759b80a7973ec87e4c8daa942d52f"
  "/navigation/019759b80a7973ec87e4c8daa9644740"
  "/navigation/019759b80a7973ec87e4c8daa9824280"
  "/navigation/019759b80a7973ec87e4c8daaa365958"
  "/navigation/019759b80a7a72f3b528766fb1b8ddf5"
  "/navigation/019759b80a7a72f3b528766fb29a6b6a"
  "/navigation/019759b80a7a72f3b528766fb385e5ca"
  "/navigation/019759b80a7a72f3b528766fb4593a2d"
  "/navigation/019759b80a7a72f3b528766fb50e51ac"
  "/navigation/019759b80a7a72f3b528766fb5aa691d"
  "/navigation/019759b80a7a72f3b528766fb66caf44"
  "/navigation/019759b80a7a72f3b528766fb7554a4b"
  "/navigation/019759b80a7a72f3b528766fb776f1b8"
  "/navigation/019759b80a7a72f3b528766fb7841158"
  "/navigation/019759b80a7a72f3b528766fb83dbc82"
  "/navigation/019759b80a7a72f3b528766fb8ee195f"
  "/navigation/019759b80a7b7051a2b98417d7781780"
  "/navigation/019759b80a7b7051a2b98417d8507ccd"
  "/navigation/019759b80a7b7051a2b98417d8c8d77f"
  "/navigation/019759b80a7b7051a2b98417d9bc4fe2"
  "/navigation/019759b80a7b7051a2b98417d9d144bd"
  "/navigation/019759b80a7b7051a2b98417da5bb18c"
  "/navigation/019759b80a7b7051a2b98417dae8c20f"
  "/navigation/019759b80a7b7051a2b98417dba6e617"
  "/navigation/019759b80a7b7051a2b98417dc851511"
  "/navigation/019759b80a7b7051a2b98417dcc16087"
  "/navigation/019759b80a7b7051a2b98417dd5b81c0"
  "/navigation/019759b80a7c71a8a481c2d53cd8d024"
  "/navigation/019759b80a7c71a8a481c2d53d328bb9"
  "/navigation/019759b80a7c71a8a481c2d53d89c899"
  "/navigation/019759b80a7c71a8a481c2d53e86f5d0"
  "/navigation/019759b80a7c71a8a481c2d53f6691a6"
  "/navigation/019759b80a7c71a8a481c2d53fa33d48"
  "/navigation/019759b80a7c71a8a481c2d53fa77acb"
  "/navigation/019759b80a7c71a8a481c2d53fe6880d"
  "/navigation/019759b80a7c71a8a481c2d540c133a6"
  "/navigation/019759b80a7c71a8a481c2d5414238c8"
  "/navigation/019759b80a7d71d2be1423d530f085c3"
  "/navigation/019759b80a7d71d2be1423d531622f54"
  "/navigation/019759b80a7d71d2be1423d5321fbbed"
  "/navigation/019759b80a7d71d2be1423d532a537f7"
  "/navigation/019759b80a7d71d2be1423d5336c10d3"
  "/navigation/019759b80a7d71d2be1423d53437b6a1"
  "/navigation/019759b80a7d71d2be1423d534fecde5"
  "/navigation/019759b80a7d71d2be1423d53530f4b2"
  "/navigation/019759b80a7d71d2be1423d535cd6e9e"
  "/navigation/019759b80a7d71d2be1423d535f41a1f"
  "/navigation/019759b80a7d71d2be1423d536ec295d"
  "/navigation/019759b80a7d71d2be1423d5379ca9e1"
  "/navigation/019759b80a7d71d2be1423d537afe829"
  "/navigation/019759b80a7e72419276f75eb12c8b2c"
  "/navigation/019759b80a7e72419276f75eb194dee1"
  "/navigation/019759b80a7e72419276f75eb2101b61"
  "/navigation/019759b80a7e72419276f75eb303a1f8"
  "/navigation/019759b80a7e72419276f75eb44d11a3"
  "/navigation/019759b80a7e72419276f75eb490ba72"
  "/navigation/019759b80a7e72419276f75eb51d8525"
  "/navigation/019759b80a7e72419276f75eb61bc826"
  "/navigation/019759b80a7e72419276f75eb6dc616a"
  "/navigation/019759b80a7e72419276f75eb7b63d7f"
  "/navigation/019759b80a7e72419276f75eb806a1c2"
  "/navigation/019759b80a7e72419276f75eb8118e7d"
  "/navigation/019759b80a7f7015a97eec2c20578eeb"
  "/navigation/019759b80a7f7015a97eec2c2139fb2e"
  "/navigation/019759b80a7f7015a97eec2c21489d0c"
  "/navigation/019759b80a7f7015a97eec2c223753e2"
  "/navigation/019759b80a7f7015a97eec2c22fe6ee5"
  "/navigation/019759b80a7f7015a97eec2c23e7e84f"
  "/navigation/019759b80a7f7015a97eec2c24df3c07"
  "/navigation/019759b80a7f7015a97eec2c2674ec29"
  "/navigation/019759b80a7f7015a97eec2c26b6ed15"
  "/navigation/019759b80a7f7015a97eec2c27955702"
  "/navigation/019759b80a7f7015a97eec2c2880a990"
  "/navigation/019759b80a7f7015a97eec2c2953c932"
  "/navigation/019759b80a7f7015a97eec2c2a13487d"
  "/navigation/019759b80a8071dfa7b4c06e7196bc93"
  "/navigation/019759b80a8071dfa7b4c06e726b8dbe"
  "/navigation/019759b80a8071dfa7b4c06e72b0d90a"
  "/navigation/019759b80a8071dfa7b4c06e72f73cfa"
  "/navigation/019759b80a8071dfa7b4c06e737a4146"
  "/navigation/019759b80a8071dfa7b4c06e744c30cf"
  "/navigation/019759b80a8071dfa7b4c06e752b81cb"
  "/navigation/019759b80a8071dfa7b4c06e75811092"
  "/navigation/019759b80a8071dfa7b4c06e75db4e1b"
  "/navigation/019759b80a8071dfa7b4c06e75e4d162"
  "/navigation/019759b80a8071dfa7b4c06e76bb8ed5"
  "/navigation/019759b80a8071dfa7b4c06e7771782c"
  "/navigation/019759b80a81710e8bcc98a5e13deb93"
  "/navigation/019759b80a81710e8bcc98a5e1f9be1d"
  "/navigation/019759b80a81710e8bcc98a5e26108ec"
  "/navigation/019759b80a81710e8bcc98a5e31b25ab"
  "/navigation/019759b80a81710e8bcc98a5e38ceb85"
  "/navigation/019759b80a81710e8bcc98a5e3e1232a"
  "/navigation/019759b80a81710e8bcc98a5e4835798"
  "/navigation/019759b80a81710e8bcc98a5e49aa337"
  "/navigation/019759b80a81710e8bcc98a5e58ea861"
  "/navigation/019759b80a81710e8bcc98a5e5d24bfa"
  "/navigation/019759b80a81710e8bcc98a5e619025e"
  "/navigation/019759b80a81710e8bcc98a5e6518a0d"
  "/navigation/019759b80a81710e8bcc98a5e6858ff3"
  "/navigation/019759b80a8270878212744afec596e7"
  "/navigation/019759b80a8270878212744affb1e487"
  "/navigation/019759b80a8270878212744afff78fe2"
  "/navigation/019759b80a8270878212744b006ca160"
  "/navigation/019759b80a8270878212744b00a81aaa"
  "/navigation/019759b80a8270878212744b00acaa83"
  "/navigation/019759b80a8270878212744b00f78c52"
  "/navigation/019759b80a8270878212744b01e9fd29"
  "/navigation/019759b80a8270878212744b020435c5"
  "/navigation/019759b80a8270878212744b022f0f31"
  "/navigation/019759b80a8270878212744b02dd08b0"
  "/navigation/019759b80a8270878212744b0334bc0a"
  "/navigation/019759b80a837313a44224c2eda5c439"
  "/detail/019759b831cf7030bcef0f84c63fc0ff"
  "/detail/019759b831b073d3a4ed5f3897eafebc"
  "/detail/019759b830c772dbb0b35ea498a80620"
  "/detail/019759b833f57315b6418beade74ebfb"
  "/detail/019759b831ba717cb9e2133df4ac58a3"
  "/detail/019759b831ca70ec90b9c1b00211c33f"
  "/detail/019759b832c87259a6e25008fa7a726f"
  "/detail/019759b833dd7057a8099672ebfb7b02"
  "/detail/019759b831cd720d9ae3d87b87d664cf"
  "/detail/019759b831c072d1a67b608ad5bc2074"
  "/detail/019759b830c571e6975825fa6d713036"
  "/detail/019759b833df7291a097f8c30ad4ce12"
  "/detail/019759b832ca7340baa72b6dad6c7454"
  "/detail/019759b831b77366811dcfd7cbe7a76e"
  "/detail/019759b833f8726a8e4c20d8f3957226"
  "/detail/019759b832cd71058304f51b166c59d6"
  "/detail/019759b833fa72f1a41b1cc463b32b78"
  "/detail/019759b831c57024aa4ef84172b38a1e"
  "/detail/019759b832a271a1a3cffb9f211d2a23"
  "/detail/019759b831bd72bfbf7fa6aa57758343"
  "/detail/019759b833f2705bb99c1cc602ed327e"
  "/detail/019759b8329f7012bbab37f19c7099d4"
  "/detail/019759b832af730493fd8825d5b1f5fe"
  "/detail/019759b830ab70afb32cbf4659fad783"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01—Y·Ð,pãµ×`üç“r\x7F"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.75 ms
(6.81%) 		1 
# product-listing-route::loading::aggregation::price
SELECT MIN(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule019759b795b27105b658f30564e2d55e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule019759b795b873e9968f23835daf85a5.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule019759b79e18702daa1f8a4185ea1dab.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule019759b795c9723095ac062428d27095.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule019759b795b27105b658f30564e2d55e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule019759b795b873e9968f23835daf85a5.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule019759b79e18702daa1f8a4185ea1dab.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule019759b795c9723095ac062428d27095.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)))) as `price.min`, MAX(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule019759b795b27105b658f30564e2d55e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule019759b795b873e9968f23835daf85a5.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule019759b79e18702daa1f8a4185ea1dab.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule019759b795c9723095ac062428d27095.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule019759b795b27105b658f30564e2d55e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule019759b795b873e9968f23835daf85a5.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule019759b79e18702daa1f8a4185ea1dab.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule019759b795c9723095ac062428d27095.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)))) as `price.max` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?)))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"\x01—Y·Ð,pãµ×`üç“r\x7F"
  true
  b"""
    \x01—Y¸\n
    @q8™7\x11ö`î\x13\x11
    """
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
2.55 ms
(6.33%) 		1 
# product-listing-route::loading::read
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`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`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product.parent`.`cheapest_price` as `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.manufacturer`.`id` as `product.manufacturer.id`, `product.manufacturer`.`version_id` as `product.manufacturer.versionId`, `product.manufacturer`.`media_id` as `product.manufacturer.mediaId`, `product.manufacturer`.`link` as `product.manufacturer.link`, `product.manufacturer`.`created_at` as `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` as `product.manufacturer.updatedAt`, `product.manufacturer.translation.name`, `product.manufacturer.translation.name` as `product.manufacturer.name`, `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`, `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.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.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`) 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 `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN (SELECT `product.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 (SELECT `product.manufacturer.translation`.`product_manufacturer_id`, `product.manufacturer.translation`.`product_manufacturer_version_id`, `product.manufacturer.translation`.`name` as `product.manufacturer.translation.name`, `product.manufacturer.translation`.`description` as `product.manufacturer.translation.description`, `product.manufacturer.translation`.`custom_fields` as `product.manufacturer.translation.customFields` FROM `product_manufacturer_translation` `product.manufacturer.translation` WHERE `product.manufacturer.translation`.`language_id` = ?) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_version_id` = `product.manufacturer`.`version_id` LEFT JOIN (SELECT `product.unit.translation`.`unit_id`, `product.unit.translation`.`short_code` as `product.unit.translation.shortCode`, `product.unit.translation`.`name` as `product.unit.translation.name`, `product.unit.translation`.`custom_fields` as `product.unit.translation.customFields` 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"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01—Y¸1Ïp0¼ï\x0F„Æ?Àÿ"
  b"\x01—Y¸1°sÓ¤í_8—êþ¼"
  b"\x01—Y¸0ÇrÛ°³^¤˜¨\x06 "
  b"\x01—Y¸3õs\x15¶A‹êÞtëû"
  b"\x01—Y¸1ºq|¹â\x13=ô¬X£"
  b"\x01ùY©1╩pýÉ╣┴░\x02\x11├?"
  b"\x01—Y¸2ÈrY¦âP\x08úzro"
  b"\x01—Y¸3ÝpW¨\t–rëû{\x02"
  b"\x01—Y¸1Ír\ršãØ{‡ÖdÏ"
  b"\x01—Y¸1ÀrѦ{`ŠÕ¼ t"
  b"\x01—Y¸0Åqæ—X%úmq06"
  b"""
    \x01—Y¸3ßr‘ —øÃ\n
    ÔÎ\x12
    """
  b"\x01—Y¸2Ês@º§+m­ltT"
  b"\x01ùY©1Àsfü\x1D¤Î╦þºn"
  b"\x01—Y¸3ørjŽL Øó•r&"
  b"\x01—Y¸2Íq\x05ƒ\x04õ\e\x16lYÖ"
  b"\x01—Y¸3úrñ¤\e\x1CÄc³+x"
  b"\x01—Y¸1Åp$ªNøAr³Š\x1E"
  b"\x01—Y¸2¢q¡£ÏûŸ!\x1D*#"
  b"\x01—Y¸1½r¿¿\x7F¦ªWuƒC"
  b"\x01—Y¸3òp[¹œ\x1CÆ\x02í2~"
  b"\x01—Y¸2Ÿp\x12»«7ñœp™Ô"
  b"\x01—Y¸2¯s\x04“ýˆ%Õ±õþ"
  b"\x01—Y¸0«p¯³,¿FYú׃"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.10 ms
(5.20%) 		1 
# product-listing::property-filter::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.media`.`id` as `property_group_option.media.id`, `property_group_option.media`.`user_id` as `property_group_option.media.userId`, `property_group_option.media`.`media_folder_id` as `property_group_option.media.mediaFolderId`, `property_group_option.media`.`mime_type` as `property_group_option.media.mimeType`, `property_group_option.media`.`file_extension` as `property_group_option.media.fileExtension`, `property_group_option.media`.`uploaded_at` as `property_group_option.media.uploadedAt`, `property_group_option.media`.`file_name` as `property_group_option.media.fileName`, `property_group_option.media`.`file_size` as `property_group_option.media.fileSize`, `property_group_option.media`.`media_type` as `property_group_option.media.mediaTypeRaw`, `property_group_option.media`.`meta_data` as `property_group_option.media.metaData`, `property_group_option.media`.`config` as `property_group_option.media.config`, `property_group_option.media`.`path` as `property_group_option.media.path`, `property_group_option.media`.`private` as `property_group_option.media.private`, `property_group_option.media`.`thumbnails_ro` as `property_group_option.media.thumbnailsRo`, `property_group_option.media`.`file_hash` as `property_group_option.media.fileHash`, `property_group_option.media`.`created_at` as `property_group_option.media.createdAt`, `property_group_option.media`.`updated_at` as `property_group_option.media.updatedAt`, `property_group_option.media.translation.title`, `property_group_option.media.translation.title` as `property_group_option.media.title`, `property_group_option.media.translation.alt`, `property_group_option.media.translation.alt` as `property_group_option.media.alt`, `property_group_option.media.translation.customFields`, `property_group_option.media.translation.customFields` as `property_group_option.media.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 `media` `property_group_option.media` ON `property_group_option`.`media_id` = `property_group_option.media`.`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` LEFT JOIN (SELECT `property_group_option.media.translation`.`media_id`, `property_group_option.media.translation`.`alt` as `property_group_option.media.translation.alt`, `property_group_option.media.translation`.`title` as `property_group_option.media.translation.title`, `property_group_option.media.translation`.`custom_fields` as `property_group_option.media.translation.customFields` FROM `media_translation` `property_group_option.media.translation` WHERE `property_group_option.media.translation`.`language_id` = ?) `property_group_option.media.media_translation` ON `property_group_option.media.media_translation`.`media_id` = `property_group_option.media`.`id` WHERE `property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01—Y¸\x08Kr\x17£Fž®÷¾\x10Ð"
  b"\x01—Y¸\x08Kr\x17£Fž®÷ìZo"
  b"\x01—Y¸\x08Kr\x17£Fž®ø\x11‹ß"
  b"\x01—Y¸\x08Kr\x17£Fž®øf\x0F*"
  b"\x01—Y¸\x08Kr\x17£Fž®øs”ò"
  b"\x01—Y¸\x08Kr\x17£Fž®øÉN…"
  b"\x01ùY©\x08Kr\x17úF׫¨Ø£Í"
  b"\x01—Y¸\x08Kr\x17£Fž®ùÇÓ\x19"
  b"\x01—Y¸\x08Kr\x17£Fž®ú±Zƒ"
  b"\x01—Y¸\x08Kr\x17£Fž®úå—„"
  b"\x01—Y¸\x08Kr\x17£Fž®ûE\x1AÕ"
  b"\x01—Y¸\x08Kr\x17£Fž®ü\x18™\x1F"
  b"\x01—Y¸\x08Kr\x17£Fž®üѽ"
  b"\x01—Y¸\x08Kr\x17£Fž®üôÛÒ"
  b"\x01—Y¸\x08Kr\x17£Fž®ýmêí"
  b"\x01—Y¸\x08Kr\x17£Fž®ýä\x01‡"
  b"\x01—Y¸\x08Kr\x17£Fž®þ2+\x18"
  b"\x01—Y¸\x08Kr\x17£Fž®ÿ\x05\x1DÂ"
  b"\x01—Y¸\x08Kr\x17£Fž®ÿáà="
  b"\x01—Y¸\x08Kr\x17£Fž¯\x00Ng°"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x01C…\x1F"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x02)yY"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x02)ÉÆ"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x02¦êx"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x03®\vÝ"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x04\x02\e“"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x04þ\x13M"
  b"\x01ùY©\x08Kr\x17úF×»\x06\x01Ø\x19"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x06:rz"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x06ôpü"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x06ûƒ "
  b"\x01—Y¸\x08Kr\x17£Fž¯\x07º2ô"
  b"\x01ùY©\x08Kr\x17úF×»\x08êì|"
  b"""
    \x01—Y¸\x08Kr\x17£Fž¯\n
    \n
    åˆ
    """
  b"\x01ùY©\x08Kr\x17úF×»\vüY~"
  b"\x01—Y¸\x08Kr\x17£Fž¯\f€lO"
  b"\x01—Y¸\x08Kr\x17£Fž¯\fÔä´"
  b"\x01—Y¸\x08Kr\x17£Fž¯\rD/7"
  b"""
    \x01—Y¸\x08Kr\x17£Fž¯\x0E¡\n
    Z
    """
  b"\x01ùY©\x08Kr\x17úF×»\x0E╚Ø╗"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x10¾éË"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x11=\x184"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x12¸¯Ï"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x13gÐX"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x13Ý%ë"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x14¥J¡"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x16EL¸"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x16¬§‹"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x17z#+"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x17°3Ï"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x19K§\x0F"
  b"\x01ùY©\x08Kr\x17úF×»\x19║ìä"
  b"\x01—Y¸\x08Kr\x17£Fž¯\e^£Ì"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x1CTšr"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x1Cj¥0"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x1D6Å~"
  b"\x01ùY©\x08Kr\x17úF×»\x1DÉ┴\"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x1DÎ>O"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x1DÖ'¾"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x1EÃ#ñ"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x1F§Ñ¢"
  b"\x01—Y¸\x08Kr\x17£Fž¯ éíº"
  b"\x01—Y¸\x08Kr\x17£Fž¯!\x02ĉ"
  b"\x01—Y¸\x08Kr\x17£Fž¯!\x1F,”"
  b"\x01—Y¸\x08Kr\x17£Fž¯!|5{"
  b"\x01—Y¸\x08Kr\x17£Fž¯!Ô'°"
  b"\x01—Y¸\x08Kr\x17£Fž¯"\x1Aâ#"
  b"\x01—Y¸\x08Kr\x17£Fž¯#L–ô"
  b"\x01—Y¸\x08Kr\x17£Fž¯$;÷B"
  b"\x01—Y¸\x08Kr\x17£Fž¯%\x12 x"
  b"\x01—Y¸\x08Kr\x17£Fž¯%L\x10F"
  b"\x01—Y¸\x08Kr\x17£Fž¯&\x01ws"
  b"\x01—Y¸\x08Kr\x17£Fž¯&y\v\x1E"
  b"\x01—Y¸\x08Kr\x17£Fž¯'Ioã"
  b"\x01ùY©\x08Kr\x17úF×»'ô┘ì"
  b"\x01—Y¸\x08Kr\x17£Fž¯(‘ו"
  b"\x01—Y¸\x08Kr\x17£Fž¯)¤@("
  b"\x01—Y¸\x08Kr\x17£Fž¯)Ç5+"
  b"\x01—Y¸\x08Kr\x17£Fž¯*úµ\x02"
  b"\x01—Y¸\x08Kr\x17£Fž¯,²!T"
  b"\x01—Y¸\x08Kr\x17£Fž¯.´ÆL"
  b"\x01—Y¸\x08Kr\x17£Fž¯/ö²/"
  b"\x01—Y¸\x08Kr\x17£Fž¯0e§?"
  b"\x01—Y¸\x08Kr\x17£Fž¯2¾€<"
  b"\x01—Y¸\x08Kr\x17£Fž¯3o\x15o"
  b"\x01—Y¸\x08Kr\x17£Fž¯4\x13d\x15"
  b"\x01—Y¸\x08Kr\x17£Fž¯4Í·”"
  b"\x01—Y¸\x08Kr\x17£Fž¯5z†*"
  b"\x01—Y¸\x08Kr\x17£Fž¯5Ëiz"
  b"\x01—Y¸\x08Kr\x17£Fž¯5å•€"
  b"\x01—Y¸\x08Kr\x17£Fž¯6…Xç"
  b"\x01—Y¸\x08Kr\x17£Fž¯7mç/"
  b"\x01—Y¸\x08Kr\x17£Fž¯7ò°+"
  b"\x01—Y¸\x08Kr\x17£Fž¯9=2\x12"
  b"\x01—Y¸\x08Kr\x17£Fž¯:Wrë"
  b"\x01—Y¸\x08Kr\x17£Fž¯:_“ù"
  b"\x01—Y¸\x08Kr\x17£Fž¯:–\x1Ei"
  b"\x01—Y¸\x08Kr\x17£Fž¯;Z“\x17"
  b"\x01—Y¸\x08Kr\x17£Fž¯;n“Ö"
  b"\x01—Y¸\x08Kr\x17£Fž¯<å´T"
  b"\x01—Y¸\x08Kr\x17£Fž¯=ÖiÀ"
  b"\x01—Y¸\x08Kr\x17£Fž¯>#2æ"
  b"\x01—Y¸\x08Kr\x17£Fž¯?G:¯"
  b"\x01—Y¸\x08Kr\x17£Fž¯@„ûÁ"
  b"\x01—Y¸\x08Kr\x17£Fž¯Aú‰¡"
  b"\x01—Y¸\x08Kr\x17£Fž¯Aÿ†\x00"
  b"\x01—Y¸\x08Kr\x17£Fž¯BŽå$"
  b"\x01—Y¸\x08Kr\x17£Fž¯Bãæ\n"
  b"\x01—Y¸\x08Kr\x17£Fž¯C\x15\x1Eœ"
  b"\x01—Y¸\x08Kr\x17£Fž¯CÂkÔ"
  b"\x01—Y¸\x08Kr\x17£Fž¯CØ#‡"
  b"\x01—Y¸\x08Kr\x17£Fž¯Eþ‡"
  b"\x01—Y¸\x08Kr\x17£Fž¯F¸yõ"
  b"\x01—Y¸\x08Kr\x17£Fž¯G=\x1F¸"
  b"\x01—Y¸\x08Kr\x17£Fž¯Gò\x07þ"
  b"\x01—Y¸\x08Kr\x17£Fž¯HÊœ\x0F"
  b"\x01ùY©\x08¿q9ü┌ì¾\rl6H"
  b"\x01ùY©\x08¿q9ü┌ì¾\x0F\e\x17Æ"
  b"\x01ùY©\x08¿q9ü┌ì¾\x10yúÓ"
  b"\x01ùY©\x08¿q9ü┌ì¾\x10×,T"
  b"\x01ùY©\x08¿q9ü┌ì¾\x11Â&ß"
  b"\x01ùY©\x08¿q9ü┌ì¾\x12äq┐"
  b"\x01ùY©\x08¿q9ü┌ì¾\x13N\x14½"
  b"\x01ùY©\x08¿q9ü┌ì¾\x13‗A="
  b"\x01ùY©\x08¿q9ü┌ì¾\x13 \x03h"
  b"\x01ùY©\x08¿q9ü┌ì¾\x14Ø┌└"
  b"\x01ùY©\x08¿q9ü┌ì¾\x15\rY\x06"
  b"\x01ùY©\x08¿q9ü┌ì¾\x15║¦¤"
  b"\x01ùY©\x08¿q9ü┌ì¾\x16'├®"
  b"\x01ùY©\x08¿q9ü┌ì¾\x164\x0FM"
  b"\x01ùY©\x08¿q9ü┌ì¾\x17\x12"ß"
  b"\x01ùY©\x08¿q9ü┌ì¾\x17¹Ö╩"
  b"\x01ùY©\x08¿q9ü┌ì¾\x18l\x11E"
  b"\x01ùY©\x08¿q9ü┌ì¾\x19OÀÈ"
  b"\x01ùY©\x08¿q9ü┌ì¾\x19─+ö"
  b"\x01ùY©\x08¿q9ü┌ì¾\x1A▓7õ"
  b"\x01ùY©\x08¿q9ü┌ì¾\e*[Í"
  b"\x01ùY©\x08¿q9ü┌ì¾\x1C)Ûã"
  b"\x01ùY©\x08¿q9ü┌ì¾\x1CPÄÛ"
  b"\x01ùY©\x08¿q9ü┌ì¾\x1Cý¤ã"
  b"\x01ùY©\x08¿q9ü┌ì¾\x1Dû¡©"
  b"\x01ùY©\x08¿q9ü┌ì¾\x1EðÇY"
  b"\x01ùY©\x08¿q9ü┌ì¾ Ebæ"
  b"\x01ùY©\x08¿q9ü┌ì¾ õÞõ"
  b"\x01ùY©\x08¿q9ü┌ì¾!╔Ï═"
  b"\x01ùY©\x08¿q9ü┌ì¾!Ú[\f"
  b"\x01—Y¸\x08©r(‹‚ N\x15\x7Fé’"
  b"\x01—Y¸\x08©r(‹‚ N\x16\x10h’"
  b"\x01—Y¸\x08©r(‹‚ N\x16M•½"
  b"\x01—Y¸\x08©r(‹‚ N\x16ýÌ”"
  b"\x01ùY©\x08®r(ïéáN\x18ØÁx"
  b"\x01—Y¸\x08©r(‹‚ N\x1A”\rH"
  b"\x01—Y¸\x08©r(‹‚ N\e\x16\v¨"
  b"\x01—Y¸\x08©r(‹‚ N\x1Cˆ¾+"
  b"\x01—Y¸\x08©r(‹‚ N\x1Dj²Ç"
  b"\x01—Y¸\x08©r(‹‚ N\x1FÏÇ+"
  b"\x01—Y¸\x08©r(‹‚ N ^<\x1F"
  b"\x01—Y¸\x08©r(‹‚ N!q\x02N"
  b"\x01—Y¸\x08©r(‹‚ N!à:F"
  b"\x01—Y¸\x08©r(‹‚ N$\x14\x04”"
  b"\x01—Y¸\x08©r(‹‚ N$Óžß"
  b"\x01—Y¸\x08©r(‹‚ N%ËŒ["
  b"\x01—Y¸\x08©r(‹‚ N&‚˲"
  b"\x01—Y¸\x08©r(‹‚ N&ÖÊ¥"
  b"\x01—Y¸\x08©r(‹‚ N'\x00Ô‰"
  b"\x01—Y¸\x08©r(‹‚ N'7\x1AH"
  b"\x01—Y¸\x08©r(‹‚ N's¥ú"
  b"\x01—Y¸\x08©r(‹‚ N(iOœ"
  b"\x01—Y¸\x08©r(‹‚ N)\eN^"
  b"\x01—Y¸\x08©r(‹‚ N*\x0ElÚ"
  b"\x01—Y¸\x08©r(‹‚ N+\x05½³"
  b"\x01—Y¸\x08©r(‹‚ N+ær¸"
  b"\x01—Y¸\x08©r(‹‚ N,B6n"
  b"\x01—Y¸\x08©r(‹‚ N-\x05/º"
  b"\x01—Y¸\x08©r(‹‚ N-C¦;"
  b"\x01—Y¸\x08©r(‹‚ N-q\x19E"
  b"\x01ùY©\x08®r(ïéáN.cü\n"
  b"\x01—Y¸\x08©r(‹‚ N.™:\x15"
  b"\x01—Y¸\x08©r(‹‚ N.¿\x1F\f"
  b"\x01—Y¸\x08©r(‹‚ N/…,$"
  b"\x01—Y¸\x08©r(‹‚ N/ÅI³"
  b"\x01ùY©\x08®r(ïéáN0kü·"
  b"\x01—Y¸\x08©r(‹‚ N1=ÏÆ"
  b"\x01—Y¸\x08©r(‹‚ N1þÏ\x7F"
  b"\x01—Y¸\x08©r(‹‚ N3V3/"
  b"\x01—Y¸\x08©r(‹‚ N4_%Y"
  b"\x01—Y¸\x08©r(‹‚ N4Í\x04d"
  b"\x01—Y¸\x08©r(‹‚ N5\t\x07\x01"
  b"\x01—Y¸\x08©r(‹‚ N5+zæ"
  b"\x01ùY©\x08®r(ïéáN5Ø@\x1D"
  b"\x01ùY©\x08®r(ïéáN6Å°\x16"
  b"\x01—Y¸\x08©r(‹‚ N7ÎQõ"
  b"\x01—Y¸\x08©r(‹‚ N8it\f"
  b"\x01—Y¸\x08©r(‹‚ N9\x0E:\x14"
  b"\x01—Y¸\x08©r(‹‚ N:!‘ƒ"
  b"\x01—Y¸\x08©r(‹‚ N:»9›"
  b"\x01—Y¸\x08©r(‹‚ N; L&"
  b"\x01—Y¸\x08©r(‹‚ N;Äíª"
  b"\x01—Y¸\x08©r(‹‚ N<\x1Au\x15"
  b"\x01—Y¸\x08©r(‹‚ N=\x02…Æ"
  b"\x01—Y¸\x08©r(‹‚ N=ê%j"
  b"\x01—Y¸\x08©r(‹‚ N>u§7"
  b"\x01—Y¸\x08©r(‹‚ N?lè8"
  b"\x01—Y¸\x08©r(‹‚ N?•^þ"
  b"\x01—Y¸\x08©r(‹‚ NAA•ª"
  b"\x01ùY©\x08®r(ïéáNA╝ÁÉ"
  b"\x01—Y¸\x08©r(‹‚ NCŽ¬\x1D"
  b"\x01—Y¸\x08©r(‹‚ NDAJw"
  b"\x01—Y¸\x08©r(‹‚ ND¢(S"
  b"\x01—Y¸\x08©r(‹‚ NDØó\x1C"
  b"\x01—Y¸\x08©r(‹‚ NF^Q\x19"
  b"\x01—Y¸\x08©r(‹‚ NGXÏð"
  b"\x01—Y¸\x08©r(‹‚ NGû׈"
  b"\x01—Y¸\x08©r(‹‚ NH\x17/\"
  b"\x01—Y¸\x08©r(‹‚ NH¨Ãì"
  b"\x01—Y¸\x08©r(‹‚ NI•øŒ"
  b"\x01—Y¸\x08©r(‹‚ NJ´\x11]"
  b"\x01—Y¸\x08©r(‹‚ NK\x13Âõ"
  b"\x01—Y¸\x08©r(‹‚ NK\x1F\x04¿"
  b"\x01—Y¸\x08©r(‹‚ NKrvN"
  b"\x01—Y¸\x08©r(‹‚ NK\x7FÐÒ"
  b"\x01—Y¸\t\x06r週Â*\eXŠÁ"
  b"\x01—Y¸\t\x06r週Â*\x1C(øº"
  b"\x01—Y¸\t\x06r週Â*\x1CÆ\x1F–"
  b"\x01—Y¸\t\x06r週Â*\x1D»ûe"
  b"\x01—Y¸\t\x06r週Â*\x1DפË"
  b"\x01ùY©\t\x06rÚÇ▒┬* \x02Øh"
  b"\x01—Y¸\t\x06r週Â*!\x05¼„"
  b"\x01—Y¸\t\x06r週Â*!Z\x17Ä"
  b"\x01—Y¸\t\x06r週Â*#>R·"
  b"\x01—Y¸\t\x06r週Â*#Õ–4"
  b"\x01—Y¸\t\x06r週Â*#íˆý"
  b"\x01—Y¸\t\x06r週Â*$a³N"
  b"\x01—Y¸\t\x06r週Â*&t˜-"
  b"\x01—Y¸\t\x06r週Â*)\x11_¡"
  b"\x01—Y¸\t\x06r週Â*0\x19VI"
  b"\x01—Y¸\t\x06r週Â*4\x16#·"
  b"\x01—Y¸\t\x06r週Â*4åüm"
  b"\x01—Y¸\t\x06r週Â*5Hj~"
  b"\x01—Y¸\t\x06r週Â*7ìÅ'"
  b"\x01—Y¸\t\x06r週Â*9ZIM"
  b"\x01—Y¸\t\x06r週Â*;\x16X\x02"
  b"\x01—Y¸\t\x06r週Â*=G¼\x04"
  b"\x01—Y¸\t\x06r週Â*=‰\x17Ú"
  b"\x01—Y¸\t\x06r週Â*=ó¦§"
  b"\x01—Y¸\t\x06r週Â*?ܸP"
  b"\x01—Y¸\t\x06r週Â*AŽZÿ"
  b"\x01—Y¸\t\x06r週Â*BDN÷"
  b"\x01—Y¸\t\x06r週Â*B¾¹û"
  b"\x01ùY©\t\x06rÚÇ▒┬*CÉäó"
  b"\x01—Y¸\t\x06r週Â*Eú‹u"
  b"\x01—Y¸\t\x06r週Â*Gè/P"
  b"\x01—Y¸\t\x06r週Â*HÊÃß"
  b"\x01—Y¸\t\x07q\x10¡\e_hµz\x1D…"
  b"\x01—Y¸\t\x07q\x10¡\e_h¶Ô‰l"
  b"\x01—Y¸\t\x07q\x10¡\e_h·wc\t"
  b"\x01—Y¸\t\x07q\x10¡\e_h·Ù)±"
  b"\x01—Y¸\t\x07q\x10¡\e_h¸®º0"
  b"\x01—Y¸\t\x07q\x10¡\e_h½åNk"
  b"\x01—Y¸\t\x07q\x10¡\e_h½åÜ\x16"
  b"\x01—Y¸\t\x07q\x10¡\e_h¾\x12‹!"
  b"\x01—Y¸\t\x07q\x10¡\e_h¾»k\x19"
  b"\x01—Y¸\t\x07q\x10¡\e_h¿}@\n"
  b"\x01—Y¸\t\x07q\x10¡\e_hÁ9q™"
  b"\x01—Y¸\t\x07q\x10¡\e_hÁÆe¨"
  b"\x01—Y¸\t\x07q\x10¡\e_h‹L°"
  b"\x01—Y¸\t\x07q\x10¡\e_hÄK,ä"
  b"\x01—Y¸\t\x07q\x10¡\e_hÅ@ëº"
  b"\x01ùY©\t\x07q\x10í\e_h┼îØÅ"
  b"\x01—Y¸\t\x07q\x10¡\e_hÇøkÈ"
  b"\x01—Y¸\t\x07q\x10¡\e_hȼv*"
  b"\x01—Y¸\t\x07q\x10¡\e_hÉ \fú"
  b"\x01—Y¸\t\x07q\x10¡\e_hÊwÊò"
  b"\x01—Y¸\t\x07q\x10¡\e_hË'Ïé"
  b"\x01—Y¸\t\x07q\x10¡\e_hÍv[Ë"
  b"\x01—Y¸\t\x07q\x10¡\e_hÎèÉE"
  b"\x01—Y¸\t\x07q\x10¡\e_hÏš\x07t"
  b"\x01—Y¸\t\x07q\x10¡\e_hÐ\x03EV"
  b"\x01—Y¸\t\x07q\x10¡\e_hÒ"É_"
  b"\x01—Y¸\t\x07q\x10¡\e_hÒ,nŒ"
  b"\x01—Y¸\t\x07q\x10¡\e_hÓÕqµ"
  b"\x01—Y¸\tfr¡ºÍŽ¹\f\x02¿\r"
  b"\x01—Y¸\tfr¡ºÍŽ¹\x11\x7F·‚"
  b"\x01—Y¸\tfr¡ºÍŽ¹\x1E-G\x17"
  b"\x01—Y¸\tfr¡ºÍŽ¹$)kì"
  b"\x01—Y¸\tfr¡ºÍŽ¹'Yi!"
  b"\x01ùY©\tfrí║═Ä╣?Å×Ý"
  b"\x01—Y¸\tÆr¿¢í\x07L_Xø´"
  b"\x01—Y¸\tÆr¿¢í\x07Lc ñ¢"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.08 ms
(5.16%) 		1 
# product-listing-route::loading::aggregation::properties
SELECT LOWER(HEX(`product.properties`.`id`)) as `properties.key`, COUNT(`product`.`id`) as `properties.count` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `product_property` `product.properties.mapping` ON `product`.`properties` = `product.properties.mapping`.`product_id`  AND `product`.`version_id` = `product.properties.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` LEFT JOIN `property_group_option` `product.properties` ON `product.properties.mapping`.`property_group_option_id` = `product.properties`.`id`  WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?))) GROUP BY `product.properties`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"\x01—Y·Ð,pãµ×`üç“r\x7F"
  true
  b"""
    \x01—Y¸\n
    @q8™7\x11ö`î\x13\x11
    """
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
1.43 ms
(3.55%) 		1 
# product-listing-route::loading::search-ids
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`name` as `product.translation.name` 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`.`name` as `product.parent.translation.name` 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 `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?))) GROUP BY `product`.`display_group` ORDER BY MIN(COALESCE(`product.translation.name`,`product.parent.translation.name`)) ASC, MIN(`product`.`id`) ASC LIMIT 24
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"\x01—Y·Ð,pãµ×`üç“r\x7F"
  true
  b"""
    \x01—Y¸\n
    @q8™7\x11ö`î\x13\x11
    """
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
1.24 ms
(3.07%) 		1 
# product-listing-route::loading::aggregation::options
SELECT LOWER(HEX(`product.options`.`id`)) as `options.key`, COUNT(`product`.`id`) as `options.count` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `product_option` `product.options.mapping` ON `product`.`id` = `product.options.mapping`.`product_id`  AND `product`.`version_id` = `product.options.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` LEFT JOIN `property_group_option` `product.options` ON `product.options.mapping`.`property_group_option_id` = `product.options`.`id`  WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?))) GROUP BY `product.options`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"\x01—Y·Ð,pãµ×`üç“r\x7F"
  true
  b"""
    \x01—Y¸\n
    @q8™7\x11ö`î\x13\x11
    """
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
1.19 ms
(2.95%) 		1 
# product-listing::property-filter::search-ids
SELECT `property_group_option`.`id` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` WHERE ((`property_group_option.group`.`filterable` = ?)) AND (`property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY `property_group_option`.`id` ASC LIMIT 500
Parameters: 
[
  true
  b"\x01—Y¸\x08Kr\x17£Fž¯.´ÆL"
  b"\x01—Y¸\t\x06r週Â*\x1D»ûe"
  b"\x01—Y¸\tÆr¿¢í\x07L_Xø´"
  b"\x01—Y¸\tÆr¿¢í\x07Lc ñ¢"
  b"\x01—Y¸\x08Kr\x17£Fž¯<å´T"
  b"\x01—Y¸\t\x06r週Â*AŽZÿ"
  b"\x01—Y¸\t\x07q\x10¡\e_h‹L°"
  b"\x01—Y¸\t\x07q\x10¡\e_hÁ9q™"
  b"\x01—Y¸\x08Kr\x17£Fž®ýä\x01‡"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x01C…\x1F"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x03®\vÝ"
  b"\x01—Y¸\x08©r(‹‚ N;Äíª"
  b"\x01—Y¸\x08©r(‹‚ N?lè8"
  b"\x01—Y¸\x08Kr\x17£Fž¯&\x01ws"
  b"\x01—Y¸\x08Kr\x17£Fž¯2¾€<"
  b"\x01—Y¸\x08Kr\x17£Fž¯Aÿ†\x00"
  b"\x01ùY©\x08¿q9ü┌ì¾\x1Cý¤ã"
  b"\x01—Y¸\x08©r(‹‚ N&ÖÊ¥"
  b"\x01—Y¸\x08©r(‹‚ N)\eN^"
  b"\x01—Y¸\t\x06r週Â*\eXŠÁ"
  b"\x01—Y¸\t\x07q\x10¡\e_hÇøkÈ"
  b"\x01—Y¸\t\x07q\x10¡\e_hË'Ïé"
  b"\x01ùY©\x08Kr\x17úF׫¨Ø£Í"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x10¾éË"
  b"\x01—Y¸\x08Kr\x17£Fž¯!\x02ĉ"
  b"\x01—Y¸\x08©r(‹‚ N*\x0ElÚ"
  b"\x01—Y¸\x08Kr\x17£Fž®úå—„"
  b"\x01—Y¸\x08Kr\x17£Fž¯"\x1Aâ#"
  b"\x01—Y¸\x08Kr\x17£Fž¯C\x15\x1Eœ"
  b"\x01ùY©\x08¿q9ü┌ì¾\x12äq┐"
  b"\x01—Y¸\x08©r(‹‚ N\x1FÏÇ+"
  b"\x01—Y¸\x08©r(‹‚ N ^<\x1F"
  b"\x01—Y¸\t\x06r週Â*5Hj~"
  b"\x01ùY©\x08Kr\x17úF×»\x0E╚Ø╗"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x1CTšr"
  b"\x01—Y¸\x08Kr\x17£Fž¯$;÷B"
  b"\x01—Y¸\x08©r(‹‚ N?•^þ"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x17°3Ï"
  b"\x01—Y¸\x08Kr\x17£Fž¯&y\v\x1E"
  b"\x01—Y¸\x08Kr\x17£Fž¯,²!T"
  b"\x01ùY©\x08¿q9ü┌ì¾\x16'├®"
  b"\x01—Y¸\x08©r(‹‚ N/…,$"
  b"\x01ùY©\x08®r(ïéáN6Å°\x16"
  b"\x01—Y¸\t\x06r週Â*HÊÃß"
  b"\x01—Y¸\t\x07q\x10¡\e_hÒ,nŒ"
  b"\x01—Y¸\x08Kr\x17£Fž®üôÛÒ"
  b"\x01ùY©\x08Kr\x17úF×»\x19║ìä"
  b"\x01—Y¸\x08Kr\x17£Fž¯*úµ\x02"
  b"\x01ùY©\x08¿q9ü┌ì¾\x13‗A="
  b"\x01—Y¸\x08©r(‹‚ NCŽ¬\x1D"
  b"\x01—Y¸\x08Kr\x17£Fž®ø\x11‹ß"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x1Cj¥0"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x1DÎ>O"
  b"\x01—Y¸\x08©r(‹‚ N.¿\x1F\f"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x14¥J¡"
  b"\x01—Y¸\x08Kr\x17£Fž¯;n“Ö"
  b"\x01—Y¸\x08Kr\x17£Fž¯Eþ‡"
  b"\x01—Y¸\x08©r(‹‚ N1þÏ\x7F"
  b"\x01—Y¸\x08©r(‹‚ N:»9›"
  b"\x01—Y¸\x08Kr\x17£Fž¯;Z“\x17"
  b"\x01ùY©\x08¿q9ü┌ì¾\x1A▓7õ"
  b"\x01ùY©\x08¿q9ü┌ì¾ õÞõ"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x13Ý%ë"
  b"\x01—Y¸\x08Kr\x17£Fž¯CØ#‡"
  b"\x01—Y¸\x08©r(‹‚ N.™:\x15"
  b"\x01—Y¸\x08©r(‹‚ N; L&"
  b"\x01—Y¸\x08©r(‹‚ ND¢(S"
  b"\x01—Y¸\t\x06r週Â*#>R·"
  b"\x01—Y¸\t\x06r週Â*)\x11_¡"
  b"\x01—Y¸\t\x07q\x10¡\e_hÊwÊò"
  b"\x01—Y¸\x08Kr\x17£Fž®þ2+\x18"
  b"\x01—Y¸\x08Kr\x17£Fž¯Aú‰¡"
  b"\x01—Y¸\x08©r(‹‚ N\x16ýÌ”"
  b"\x01—Y¸\x08©r(‹‚ N8it\f"
  b"\x01—Y¸\x08©r(‹‚ NK\x1F\x04¿"
  b"\x01—Y¸\t\x06r週Â*\x1C(øº"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x07º2ô"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x11=\x184"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x1DÖ'¾"
  b"\x01—Y¸\x08©r(‹‚ N\x1Dj²Ç"
  b"\x01—Y¸\x08©r(‹‚ NK\x7FÐÒ"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x1F§Ñ¢"
  b"\x01ùY©\x08¿q9ü┌ì¾\x17\x12"ß"
  b"\x01—Y¸\t\x06r週Â*?ܸP"
  b"\x01—Y¸\t\x07q\x10¡\e_h¾\x12‹!"
  b"\x01—Y¸\t\x07q\x10¡\e_hÒ"É_"
  b"\x01—Y¸\tfr¡ºÍŽ¹\f\x02¿\r"
  b"\x01—Y¸\x08Kr\x17£Fž¯7ò°+"
  b"\x01ùY©\x08¿q9ü┌ì¾\x13N\x14½"
  b"\x01ùY©\x08¿q9ü┌ì¾\x1CPÄÛ"
  b"\x01—Y¸\x08Kr\x17£Fž®ÿáà="
  b"""
    \x01—Y¸\x08Kr\x17£Fž¯\n
    \n
    åˆ
    """
  b"\x01—Y¸\x08Kr\x17£Fž¯9=2\x12"
  b"\x01—Y¸\x08©r(‹‚ N\x16M•½"
  b"\x01—Y¸\x08©r(‹‚ N-C¦;"
  b"\x01—Y¸\t\x07q\x10¡\e_hÓÕqµ"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x02)yY"
  b"\x01—Y¸\x08Kr\x17£Fž¯:_“ù"
  b"\x01ùY©\x08¿q9ü┌ì¾\x1EðÇY"
  b"\x01—Y¸\x08©r(‹‚ N=ê%j"
  b"\x01—Y¸\t\x07q\x10¡\e_hÁÆe¨"
  b"\x01—Y¸\x08Kr\x17£Fž®ûE\x1AÕ"
  b"\x01—Y¸\x08©r(‹‚ N!q\x02N"
  b"\x01—Y¸\x08Kr\x17£Fž®øs”ò"
  b"\x01ùY©\x08Kr\x17úF×»\x06\x01Ø\x19"
  b"\x01—Y¸\x08Kr\x17£Fž¯G=\x1F¸"
  b"\x01ùY©\x08¿q9ü┌ì¾\rl6H"
  b"\x01ùY©\x08¿q9ü┌ì¾!Ú[\f"
  b"\x01—Y¸\x08©r(‹‚ N$\x14\x04”"
  b"\x01—Y¸\t\x06r週Â*!Z\x17Ä"
  b"\x01—Y¸\t\x06r週Â*&t˜-"
  b"\x01—Y¸\x08Kr\x17£Fž®ùÇÓ\x19"
  b"\x01—Y¸\x08Kr\x17£Fž¯:Wrë"
  b"\x01ùY©\x08¿q9ü┌ì¾\x17¹Ö╩"
  b"\x01—Y¸\x08©r(‹‚ NAA•ª"
  b"\x01—Y¸\t\x06r週Â*9ZIM"
  b"\x01ùY©\t\x07q\x10í\e_h┼îØÅ"
  b"\x01—Y¸\t\x07q\x10¡\e_hÎèÉE"
  b"\x01—Y¸\x08Kr\x17£Fž¯@„ûÁ"
  b"\x01—Y¸\x08©r(‹‚ N+ær¸"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x00Ng°"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x02)ÉÆ"
  b"\x01—Y¸\x08Kr\x17£Fž¯\e^£Ì"
  b"\x01—Y¸\x08Kr\x17£Fž®÷¾\x10Ð"
  b"\x01ùY©\x08Kr\x17úF×»\x1DÉ┴\"
  b"\x01—Y¸\x08Kr\x17£Fž¯!|5{"
  b"\x01ùY©\x08¿q9ü┌ì¾\x11Â&ß"
  b"\x01—Y¸\x08©r(‹‚ N\x16\x10h’"
  b"\x01—Y¸\x08©r(‹‚ N(iOœ"
  b"\x01—Y¸\x08Kr\x17£Fž¯\f€lO"
  b"\x01ùY©\x08¿q9ü┌ì¾\x15\rY\x06"
  b"\x01—Y¸\x08Kr\x17£Fž®ýmêí"
  b"\x01—Y¸\x08Kr\x17£Fž¯%L\x10F"
  b"\x01—Y¸\x08©r(‹‚ N\x1A”\rH"
  b"\x01—Y¸\x08©r(‹‚ N,B6n"
  b"\x01—Y¸\x08©r(‹‚ NK\x13Âõ"
  b"\x01—Y¸\t\x06r週Â*0\x19VI"
  b"\x01—Y¸\t\x06r週Â*BDN÷"
  b"\x01—Y¸\x08Kr\x17£Fž¯!Ô'°"
  b"\x01ùY©\x08¿q9ü┌ì¾\x18l\x11E"
  b"\x01ùY©\x08®r(ïéáN.cü\n"
  b"\x01—Y¸\x08©r(‹‚ NDØó\x1C"
  b"\x01—Y¸\t\x07q\x10¡\e_hȼv*"
  b"\x01—Y¸\x08Kr\x17£Fž¯%\x12 x"
  b"\x01—Y¸\x08Kr\x17£Fž¯)¤@("
  b"\x01ùY©\x08¿q9ü┌ì¾\x14Ø┌└"
  b"\x01ùY©\x08®r(ïéáNA╝ÁÉ"
  b"\x01—Y¸\t\x07q\x10¡\e_h¿}@\n"
  b"\x01—Y¸\x08Kr\x17£Fž¯ éíº"
  b"\x01—Y¸\x08Kr\x17£Fž¯6…Xç"
  b"\x01—Y¸\x08©r(‹‚ N'7\x1AH"
  b"\x01ùY©\x08®r(ïéáN5Ø@\x1D"
  b"\x01—Y¸\x08©r(‹‚ NH\x17/\"
  b"\x01—Y¸\x08Kr\x17£Fž¯!\x1F,”"
  b"\x01—Y¸\x08©r(‹‚ N+\x05½³"
  b"\x01—Y¸\x08©r(‹‚ N1=ÏÆ"
  b"\x01—Y¸\t\x07q\x10¡\e_h¶Ô‰l"
  b"\x01—Y¸\x08Kr\x17£Fž®øf\x0F*"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x06ôpü"
  b"\x01—Y¸\x08Kr\x17£Fž¯?G:¯"
  b"\x01—Y¸\x08©r(‹‚ N$Óžß"
  b"\x01—Y¸\x08Kr\x17£Fž®÷ìZo"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x06ûƒ "
  b"\x01—Y¸\x08Kr\x17£Fž¯\x12¸¯Ï"
  b"\x01—Y¸\x08©r(‹‚ NGû׈"
  b"\x01—Y¸\t\x06r週Â*#Õ–4"
  b"\x01—Y¸\t\x06r週Â*B¾¹û"
  b"\x01—Y¸\t\x07q\x10¡\e_hÍv[Ë"
  b"\x01—Y¸\x08Kr\x17£Fž®üѽ"
  b"\x01—Y¸\x08Kr\x17£Fž¯#L–ô"
  b"\x01—Y¸\x08©r(‹‚ N7ÎQõ"
  b"\x01—Y¸\t\x07q\x10¡\e_h¾»k\x19"
  b"\x01—Y¸\t\x07q\x10¡\e_hÅ@ëº"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x16EL¸"
  b"\x01—Y¸\x08Kr\x17£Fž¯>#2æ"
  b"\x01ùY©\x08¿q9ü┌ì¾\x164\x0FM"
  b"\x01—Y¸\x08©r(‹‚ NH¨Ãì"
  b"\x01ùY©\x08Kr\x17úF×»\x08êì|"
  b"\x01—Y¸\x08Kr\x17£Fž¯(‘ו"
  b"\x01—Y¸\x08Kr\x17£Fž®ú±Zƒ"
  b"\x01—Y¸\x08Kr\x17£Fž¯/ö²/"
  b"\x01ùY©\x08¿q9ü┌ì¾\x1Dû¡©"
  b"\x01—Y¸\x08©r(‹‚ N/ÅI³"
  b"\x01—Y¸\x08©r(‹‚ N<\x1Au\x15"
  b"\x01—Y¸\t\x06r週Â*4åüm"
  b"\x01—Y¸\t\x07q\x10¡\e_hÄK,ä"
  b"\x01—Y¸\x08Kr\x17£Fž®ü\x18™\x1F"
  b"\x01—Y¸\x08©r(‹‚ N9\x0E:\x14"
  b"\x01—Y¸\x08©r(‹‚ NJ´\x11]"
  b"\x01ùY©\x08Kr\x17úF×»\vüY~"
  b"\x01—Y¸\x08Kr\x17£Fž¯5z†*"
  b"\x01—Y¸\x08©r(‹‚ N3V3/"
  b"\x01—Y¸\x08©r(‹‚ N5+zæ"
  b"\x01—Y¸\x08©r(‹‚ NF^Q\x19"
  b"\x01—Y¸\t\x07q\x10¡\e_hµz\x1D…"
  b"\x01—Y¸\t\x07q\x10¡\e_h½åNk"
  b"\x01ùY©\x08¿q9ü┌ì¾\x10yúÓ"
  b"\x01—Y¸\t\x07q\x10¡\e_h·Ù)±"
  b"\x01—Y¸\x08Kr\x17£Fž®øÉN…"
  b"\x01—Y¸\x08Kr\x17£Fž¯'Ioã"
  b"\x01—Y¸\x08Kr\x17£Fž¯Gò\x07þ"
  b"\x01—Y¸\x08©r(‹‚ N\x1Cˆ¾+"
  b"\x01—Y¸\x08Kr\x17£Fž¯\rD/7"
  b"\x01—Y¸\x08Kr\x17£Fž¯4Í·”"
  b"\x01—Y¸\x08Kr\x17£Fž¯=ÖiÀ"
  b"\x01—Y¸\x08©r(‹‚ N\e\x16\v¨"
  b"\x01—Y¸\x08©r(‹‚ N-q\x19E"
  b"\x01—Y¸\x08Kr\x17£Fž¯\fÔä´"
  b"\x01—Y¸\x08Kr\x17£Fž¯3o\x15o"
  b"\x01—Y¸\x08©r(‹‚ N!à:F"
  b"\x01—Y¸\t\x07q\x10¡\e_hÐ\x03EV"
  b"\x01—Y¸\tfr¡ºÍŽ¹\x1E-G\x17"
  b"\x01—Y¸\x08Kr\x17£Fž¯:–\x1Ei"
  b"\x01—Y¸\t\x06r週Â*\x1DפË"
  b"\x01ùY©\t\x06rÚÇ▒┬*CÉäó"
  b"\x01ùY©\tfrí║═Ä╣?Å×Ý"
  b"\x01—Y¸\x08Kr\x17£Fž¯)Ç5+"
  b"\x01—Y¸\x08Kr\x17£Fž¯0e§?"
  b"\x01—Y¸\x08Kr\x17£Fž¯CÂkÔ"
  b"\x01ùY©\x08¿q9ü┌ì¾ Ebæ"
  b"\x01—Y¸\t\x06r週Â*$a³N"
  b"\x01—Y¸\t\x06r週Â*;\x16X\x02"
  b"\x01—Y¸\t\x06r週Â*Gè/P"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x06:rz"
  b"\x01—Y¸\x08Kr\x17£Fž¯5å•€"
  b"\x01ùY©\x08¿q9ü┌ì¾\x19─+ö"
  b"\x01—Y¸\x08©r(‹‚ NDAJw"
  b"\x01—Y¸\x08©r(‹‚ N'\x00Ô‰"
  b"\x01—Y¸\x08©r(‹‚ N's¥ú"
  b"\x01—Y¸\x08©r(‹‚ NGXÏð"
  b"\x01—Y¸\t\x06r週Â*\x1CÆ\x1F–"
  b"\x01—Y¸\t\x07q\x10¡\e_h¸®º0"
  b"\x01—Y¸\t\x07q\x10¡\e_hÉ \fú"
  b"\x01—Y¸\tfr¡ºÍŽ¹'Yi!"
  b"\x01—Y¸\x08Kr\x17£Fž¯5Ëiz"
  b"""
    \x01—Y¸\x08Kr\x17£Fž¯\x0E¡\n
    Z
    """
  b"\x01ùY©\x08¿q9ü┌ì¾\x0F\e\x17Æ"
  b"\x01—Y¸\x08©r(‹‚ N-\x05/º"
  b"\x01ùY©\x08¿q9ü┌ì¾\e*[Í"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x04\x02\e“"
  b"\x01ùY©\x08Kr\x17úF×»'ô┘ì"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x1D6Å~"
  b"\x01—Y¸\x08©r(‹‚ N%ËŒ["
  b"\x01—Y¸\x08©r(‹‚ N4_%Y"
  b"\x01—Y¸\t\x06r週Â*Eú‹u"
  b"\x01—Y¸\x08Kr\x17£Fž¯4\x13d\x15"
  b"\x01—Y¸\x08©r(‹‚ N>u§7"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x04þ\x13M"
  b"\x01—Y¸\x08Kr\x17£Fž¯HÊœ\x0F"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x13gÐX"
  b"\x01—Y¸\x08Kr\x17£Fž¯7mç/"
  b"\x01ùY©\x08¿q9ü┌ì¾\x19OÀÈ"
  b"\x01—Y¸\x08©r(‹‚ N:!‘ƒ"
  b"\x01—Y¸\t\x06r週Â*7ìÅ'"
  b"\x01—Y¸\t\x07q\x10¡\e_h½åÜ\x16"
  b"\x01—Y¸\tfr¡ºÍŽ¹$)kì"
  b"\x01—Y¸\x08©r(‹‚ N\x15\x7Fé’"
  b"\x01—Y¸\t\x06r週Â*=G¼\x04"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x19K§\x0F"
  b"\x01ùY©\x08¿q9ü┌ì¾\x13 \x03h"
  b"\x01—Y¸\x08©r(‹‚ N5\t\x07\x01"
  b"\x01—Y¸\t\x06r週Â*4\x16#·"
  b"\x01—Y¸\t\x06r週Â*=‰\x17Ú"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x1EÃ#ñ"
  b"\x01—Y¸\x08Kr\x17£Fž¯Bãæ\n"
  b"\x01ùY©\x08¿q9ü┌ì¾\x10×,T"
  b"\x01ùY©\x08®r(ïéáN\x18ØÁx"
  b"\x01—Y¸\t\x06r週Â*#íˆý"
  b"\x01—Y¸\x08©r(‹‚ NKrvN"
  b"\x01—Y¸\x08Kr\x17£Fž®ÿ\x05\x1DÂ"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x02¦êx"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x16¬§‹"
  b"\x01ùY©\x08¿q9ü┌ì¾!╔Ï═"
  b"\x01ùY©\x08®r(ïéáN0kü·"
  b"\x01—Y¸\x08©r(‹‚ NI•øŒ"
  b"\x01—Y¸\x08Kr\x17£Fž¯F¸yõ"
  b"\x01ùY©\x08¿q9ü┌ì¾\x1C)Ûã"
  b"\x01—Y¸\t\x07q\x10¡\e_hÏš\x07t"
  b"\x01—Y¸\x08Kr\x17£Fž¯BŽå$"
  b"\x01—Y¸\x08©r(‹‚ N=\x02…Æ"
  b"\x01ùY©\t\x06rÚÇ▒┬* \x02Øh"
  b"\x01—Y¸\t\x06r週Â*!\x05¼„"
  b"\x01—Y¸\t\x06r週Â*=ó¦§"
  b"\x01—Y¸\tfr¡ºÍŽ¹\x11\x7F·‚"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x17z#+"
  b"\x01ùY©\x08¿q9ü┌ì¾\x15║¦¤"
  b"\x01—Y¸\x08©r(‹‚ N&‚˲"
  b"\x01—Y¸\x08©r(‹‚ N4Í\x04d"
  b"\x01—Y¸\t\x07q\x10¡\e_h·wc\t"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.17 ms
(2.89%) 		1 
SELECT COUNT(*) FROM (# product-listing-route::loading::search-ids
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`name` as `product.translation.name` 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`.`name` as `product.parent.translation.name` 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 `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?))) GROUP BY `product`.`display_group`) total
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"\x01—Y·Ð,pãµ×`üç“r\x7F"
  true
  b"""
    \x01—Y¸\n
    @q8™7\x11ö`î\x13\x11
    """
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
1.10 ms
(2.73%) 		1 
# product-listing::property-filter::search-ids
SELECT `property_group_option`.`id` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` WHERE ((`property_group_option.group`.`filterable` = ?)) AND (`property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY `property_group_option`.`id` ASC LIMIT 500 OFFSET 500
Parameters: 
[
  true
  b"\x01—Y¸\x08Kr\x17£Fž¯.´ÆL"
  b"\x01—Y¸\t\x06r週Â*\x1D»ûe"
  b"\x01—Y¸\tÆr¿¢í\x07L_Xø´"
  b"\x01—Y¸\tÆr¿¢í\x07Lc ñ¢"
  b"\x01—Y¸\x08Kr\x17£Fž¯<å´T"
  b"\x01—Y¸\t\x06r週Â*AŽZÿ"
  b"\x01—Y¸\t\x07q\x10¡\e_h‹L°"
  b"\x01—Y¸\t\x07q\x10¡\e_hÁ9q™"
  b"\x01—Y¸\x08Kr\x17£Fž®ýä\x01‡"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x01C…\x1F"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x03®\vÝ"
  b"\x01—Y¸\x08©r(‹‚ N;Äíª"
  b"\x01—Y¸\x08©r(‹‚ N?lè8"
  b"\x01—Y¸\x08Kr\x17£Fž¯&\x01ws"
  b"\x01—Y¸\x08Kr\x17£Fž¯2¾€<"
  b"\x01—Y¸\x08Kr\x17£Fž¯Aÿ†\x00"
  b"\x01ùY©\x08¿q9ü┌ì¾\x1Cý¤ã"
  b"\x01—Y¸\x08©r(‹‚ N&ÖÊ¥"
  b"\x01—Y¸\x08©r(‹‚ N)\eN^"
  b"\x01—Y¸\t\x06r週Â*\eXŠÁ"
  b"\x01—Y¸\t\x07q\x10¡\e_hÇøkÈ"
  b"\x01—Y¸\t\x07q\x10¡\e_hË'Ïé"
  b"\x01ùY©\x08Kr\x17úF׫¨Ø£Í"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x10¾éË"
  b"\x01—Y¸\x08Kr\x17£Fž¯!\x02ĉ"
  b"\x01—Y¸\x08©r(‹‚ N*\x0ElÚ"
  b"\x01—Y¸\x08Kr\x17£Fž®úå—„"
  b"\x01—Y¸\x08Kr\x17£Fž¯"\x1Aâ#"
  b"\x01—Y¸\x08Kr\x17£Fž¯C\x15\x1Eœ"
  b"\x01ùY©\x08¿q9ü┌ì¾\x12äq┐"
  b"\x01—Y¸\x08©r(‹‚ N\x1FÏÇ+"
  b"\x01—Y¸\x08©r(‹‚ N ^<\x1F"
  b"\x01—Y¸\t\x06r週Â*5Hj~"
  b"\x01ùY©\x08Kr\x17úF×»\x0E╚Ø╗"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x1CTšr"
  b"\x01—Y¸\x08Kr\x17£Fž¯$;÷B"
  b"\x01—Y¸\x08©r(‹‚ N?•^þ"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x17°3Ï"
  b"\x01—Y¸\x08Kr\x17£Fž¯&y\v\x1E"
  b"\x01—Y¸\x08Kr\x17£Fž¯,²!T"
  b"\x01ùY©\x08¿q9ü┌ì¾\x16'├®"
  b"\x01—Y¸\x08©r(‹‚ N/…,$"
  b"\x01ùY©\x08®r(ïéáN6Å°\x16"
  b"\x01—Y¸\t\x06r週Â*HÊÃß"
  b"\x01—Y¸\t\x07q\x10¡\e_hÒ,nŒ"
  b"\x01—Y¸\x08Kr\x17£Fž®üôÛÒ"
  b"\x01ùY©\x08Kr\x17úF×»\x19║ìä"
  b"\x01—Y¸\x08Kr\x17£Fž¯*úµ\x02"
  b"\x01ùY©\x08¿q9ü┌ì¾\x13‗A="
  b"\x01—Y¸\x08©r(‹‚ NCŽ¬\x1D"
  b"\x01—Y¸\x08Kr\x17£Fž®ø\x11‹ß"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x1Cj¥0"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x1DÎ>O"
  b"\x01—Y¸\x08©r(‹‚ N.¿\x1F\f"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x14¥J¡"
  b"\x01—Y¸\x08Kr\x17£Fž¯;n“Ö"
  b"\x01—Y¸\x08Kr\x17£Fž¯Eþ‡"
  b"\x01—Y¸\x08©r(‹‚ N1þÏ\x7F"
  b"\x01—Y¸\x08©r(‹‚ N:»9›"
  b"\x01—Y¸\x08Kr\x17£Fž¯;Z“\x17"
  b"\x01ùY©\x08¿q9ü┌ì¾\x1A▓7õ"
  b"\x01ùY©\x08¿q9ü┌ì¾ õÞõ"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x13Ý%ë"
  b"\x01—Y¸\x08Kr\x17£Fž¯CØ#‡"
  b"\x01—Y¸\x08©r(‹‚ N.™:\x15"
  b"\x01—Y¸\x08©r(‹‚ N; L&"
  b"\x01—Y¸\x08©r(‹‚ ND¢(S"
  b"\x01—Y¸\t\x06r週Â*#>R·"
  b"\x01—Y¸\t\x06r週Â*)\x11_¡"
  b"\x01—Y¸\t\x07q\x10¡\e_hÊwÊò"
  b"\x01—Y¸\x08Kr\x17£Fž®þ2+\x18"
  b"\x01—Y¸\x08Kr\x17£Fž¯Aú‰¡"
  b"\x01—Y¸\x08©r(‹‚ N\x16ýÌ”"
  b"\x01—Y¸\x08©r(‹‚ N8it\f"
  b"\x01—Y¸\x08©r(‹‚ NK\x1F\x04¿"
  b"\x01—Y¸\t\x06r週Â*\x1C(øº"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x07º2ô"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x11=\x184"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x1DÖ'¾"
  b"\x01—Y¸\x08©r(‹‚ N\x1Dj²Ç"
  b"\x01—Y¸\x08©r(‹‚ NK\x7FÐÒ"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x1F§Ñ¢"
  b"\x01ùY©\x08¿q9ü┌ì¾\x17\x12"ß"
  b"\x01—Y¸\t\x06r週Â*?ܸP"
  b"\x01—Y¸\t\x07q\x10¡\e_h¾\x12‹!"
  b"\x01—Y¸\t\x07q\x10¡\e_hÒ"É_"
  b"\x01—Y¸\tfr¡ºÍŽ¹\f\x02¿\r"
  b"\x01—Y¸\x08Kr\x17£Fž¯7ò°+"
  b"\x01ùY©\x08¿q9ü┌ì¾\x13N\x14½"
  b"\x01ùY©\x08¿q9ü┌ì¾\x1CPÄÛ"
  b"\x01—Y¸\x08Kr\x17£Fž®ÿáà="
  b"""
    \x01—Y¸\x08Kr\x17£Fž¯\n
    \n
    åˆ
    """
  b"\x01—Y¸\x08Kr\x17£Fž¯9=2\x12"
  b"\x01—Y¸\x08©r(‹‚ N\x16M•½"
  b"\x01—Y¸\x08©r(‹‚ N-C¦;"
  b"\x01—Y¸\t\x07q\x10¡\e_hÓÕqµ"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x02)yY"
  b"\x01—Y¸\x08Kr\x17£Fž¯:_“ù"
  b"\x01ùY©\x08¿q9ü┌ì¾\x1EðÇY"
  b"\x01—Y¸\x08©r(‹‚ N=ê%j"
  b"\x01—Y¸\t\x07q\x10¡\e_hÁÆe¨"
  b"\x01—Y¸\x08Kr\x17£Fž®ûE\x1AÕ"
  b"\x01—Y¸\x08©r(‹‚ N!q\x02N"
  b"\x01—Y¸\x08Kr\x17£Fž®øs”ò"
  b"\x01ùY©\x08Kr\x17úF×»\x06\x01Ø\x19"
  b"\x01—Y¸\x08Kr\x17£Fž¯G=\x1F¸"
  b"\x01ùY©\x08¿q9ü┌ì¾\rl6H"
  b"\x01ùY©\x08¿q9ü┌ì¾!Ú[\f"
  b"\x01—Y¸\x08©r(‹‚ N$\x14\x04”"
  b"\x01—Y¸\t\x06r週Â*!Z\x17Ä"
  b"\x01—Y¸\t\x06r週Â*&t˜-"
  b"\x01—Y¸\x08Kr\x17£Fž®ùÇÓ\x19"
  b"\x01—Y¸\x08Kr\x17£Fž¯:Wrë"
  b"\x01ùY©\x08¿q9ü┌ì¾\x17¹Ö╩"
  b"\x01—Y¸\x08©r(‹‚ NAA•ª"
  b"\x01—Y¸\t\x06r週Â*9ZIM"
  b"\x01ùY©\t\x07q\x10í\e_h┼îØÅ"
  b"\x01—Y¸\t\x07q\x10¡\e_hÎèÉE"
  b"\x01—Y¸\x08Kr\x17£Fž¯@„ûÁ"
  b"\x01—Y¸\x08©r(‹‚ N+ær¸"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x00Ng°"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x02)ÉÆ"
  b"\x01—Y¸\x08Kr\x17£Fž¯\e^£Ì"
  b"\x01—Y¸\x08Kr\x17£Fž®÷¾\x10Ð"
  b"\x01ùY©\x08Kr\x17úF×»\x1DÉ┴\"
  b"\x01—Y¸\x08Kr\x17£Fž¯!|5{"
  b"\x01ùY©\x08¿q9ü┌ì¾\x11Â&ß"
  b"\x01—Y¸\x08©r(‹‚ N\x16\x10h’"
  b"\x01—Y¸\x08©r(‹‚ N(iOœ"
  b"\x01—Y¸\x08Kr\x17£Fž¯\f€lO"
  b"\x01ùY©\x08¿q9ü┌ì¾\x15\rY\x06"
  b"\x01—Y¸\x08Kr\x17£Fž®ýmêí"
  b"\x01—Y¸\x08Kr\x17£Fž¯%L\x10F"
  b"\x01—Y¸\x08©r(‹‚ N\x1A”\rH"
  b"\x01—Y¸\x08©r(‹‚ N,B6n"
  b"\x01—Y¸\x08©r(‹‚ NK\x13Âõ"
  b"\x01—Y¸\t\x06r週Â*0\x19VI"
  b"\x01—Y¸\t\x06r週Â*BDN÷"
  b"\x01—Y¸\x08Kr\x17£Fž¯!Ô'°"
  b"\x01ùY©\x08¿q9ü┌ì¾\x18l\x11E"
  b"\x01ùY©\x08®r(ïéáN.cü\n"
  b"\x01—Y¸\x08©r(‹‚ NDØó\x1C"
  b"\x01—Y¸\t\x07q\x10¡\e_hȼv*"
  b"\x01—Y¸\x08Kr\x17£Fž¯%\x12 x"
  b"\x01—Y¸\x08Kr\x17£Fž¯)¤@("
  b"\x01ùY©\x08¿q9ü┌ì¾\x14Ø┌└"
  b"\x01ùY©\x08®r(ïéáNA╝ÁÉ"
  b"\x01—Y¸\t\x07q\x10¡\e_h¿}@\n"
  b"\x01—Y¸\x08Kr\x17£Fž¯ éíº"
  b"\x01—Y¸\x08Kr\x17£Fž¯6…Xç"
  b"\x01—Y¸\x08©r(‹‚ N'7\x1AH"
  b"\x01ùY©\x08®r(ïéáN5Ø@\x1D"
  b"\x01—Y¸\x08©r(‹‚ NH\x17/\"
  b"\x01—Y¸\x08Kr\x17£Fž¯!\x1F,”"
  b"\x01—Y¸\x08©r(‹‚ N+\x05½³"
  b"\x01—Y¸\x08©r(‹‚ N1=ÏÆ"
  b"\x01—Y¸\t\x07q\x10¡\e_h¶Ô‰l"
  b"\x01—Y¸\x08Kr\x17£Fž®øf\x0F*"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x06ôpü"
  b"\x01—Y¸\x08Kr\x17£Fž¯?G:¯"
  b"\x01—Y¸\x08©r(‹‚ N$Óžß"
  b"\x01—Y¸\x08Kr\x17£Fž®÷ìZo"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x06ûƒ "
  b"\x01—Y¸\x08Kr\x17£Fž¯\x12¸¯Ï"
  b"\x01—Y¸\x08©r(‹‚ NGû׈"
  b"\x01—Y¸\t\x06r週Â*#Õ–4"
  b"\x01—Y¸\t\x06r週Â*B¾¹û"
  b"\x01—Y¸\t\x07q\x10¡\e_hÍv[Ë"
  b"\x01—Y¸\x08Kr\x17£Fž®üѽ"
  b"\x01—Y¸\x08Kr\x17£Fž¯#L–ô"
  b"\x01—Y¸\x08©r(‹‚ N7ÎQõ"
  b"\x01—Y¸\t\x07q\x10¡\e_h¾»k\x19"
  b"\x01—Y¸\t\x07q\x10¡\e_hÅ@ëº"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x16EL¸"
  b"\x01—Y¸\x08Kr\x17£Fž¯>#2æ"
  b"\x01ùY©\x08¿q9ü┌ì¾\x164\x0FM"
  b"\x01—Y¸\x08©r(‹‚ NH¨Ãì"
  b"\x01ùY©\x08Kr\x17úF×»\x08êì|"
  b"\x01—Y¸\x08Kr\x17£Fž¯(‘ו"
  b"\x01—Y¸\x08Kr\x17£Fž®ú±Zƒ"
  b"\x01—Y¸\x08Kr\x17£Fž¯/ö²/"
  b"\x01ùY©\x08¿q9ü┌ì¾\x1Dû¡©"
  b"\x01—Y¸\x08©r(‹‚ N/ÅI³"
  b"\x01—Y¸\x08©r(‹‚ N<\x1Au\x15"
  b"\x01—Y¸\t\x06r週Â*4åüm"
  b"\x01—Y¸\t\x07q\x10¡\e_hÄK,ä"
  b"\x01—Y¸\x08Kr\x17£Fž®ü\x18™\x1F"
  b"\x01—Y¸\x08©r(‹‚ N9\x0E:\x14"
  b"\x01—Y¸\x08©r(‹‚ NJ´\x11]"
  b"\x01ùY©\x08Kr\x17úF×»\vüY~"
  b"\x01—Y¸\x08Kr\x17£Fž¯5z†*"
  b"\x01—Y¸\x08©r(‹‚ N3V3/"
  b"\x01—Y¸\x08©r(‹‚ N5+zæ"
  b"\x01—Y¸\x08©r(‹‚ NF^Q\x19"
  b"\x01—Y¸\t\x07q\x10¡\e_hµz\x1D…"
  b"\x01—Y¸\t\x07q\x10¡\e_h½åNk"
  b"\x01ùY©\x08¿q9ü┌ì¾\x10yúÓ"
  b"\x01—Y¸\t\x07q\x10¡\e_h·Ù)±"
  b"\x01—Y¸\x08Kr\x17£Fž®øÉN…"
  b"\x01—Y¸\x08Kr\x17£Fž¯'Ioã"
  b"\x01—Y¸\x08Kr\x17£Fž¯Gò\x07þ"
  b"\x01—Y¸\x08©r(‹‚ N\x1Cˆ¾+"
  b"\x01—Y¸\x08Kr\x17£Fž¯\rD/7"
  b"\x01—Y¸\x08Kr\x17£Fž¯4Í·”"
  b"\x01—Y¸\x08Kr\x17£Fž¯=ÖiÀ"
  b"\x01—Y¸\x08©r(‹‚ N\e\x16\v¨"
  b"\x01—Y¸\x08©r(‹‚ N-q\x19E"
  b"\x01—Y¸\x08Kr\x17£Fž¯\fÔä´"
  b"\x01—Y¸\x08Kr\x17£Fž¯3o\x15o"
  b"\x01—Y¸\x08©r(‹‚ N!à:F"
  b"\x01—Y¸\t\x07q\x10¡\e_hÐ\x03EV"
  b"\x01—Y¸\tfr¡ºÍŽ¹\x1E-G\x17"
  b"\x01—Y¸\x08Kr\x17£Fž¯:–\x1Ei"
  b"\x01—Y¸\t\x06r週Â*\x1DפË"
  b"\x01ùY©\t\x06rÚÇ▒┬*CÉäó"
  b"\x01ùY©\tfrí║═Ä╣?Å×Ý"
  b"\x01—Y¸\x08Kr\x17£Fž¯)Ç5+"
  b"\x01—Y¸\x08Kr\x17£Fž¯0e§?"
  b"\x01—Y¸\x08Kr\x17£Fž¯CÂkÔ"
  b"\x01ùY©\x08¿q9ü┌ì¾ Ebæ"
  b"\x01—Y¸\t\x06r週Â*$a³N"
  b"\x01—Y¸\t\x06r週Â*;\x16X\x02"
  b"\x01—Y¸\t\x06r週Â*Gè/P"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x06:rz"
  b"\x01—Y¸\x08Kr\x17£Fž¯5å•€"
  b"\x01ùY©\x08¿q9ü┌ì¾\x19─+ö"
  b"\x01—Y¸\x08©r(‹‚ NDAJw"
  b"\x01—Y¸\x08©r(‹‚ N'\x00Ô‰"
  b"\x01—Y¸\x08©r(‹‚ N's¥ú"
  b"\x01—Y¸\x08©r(‹‚ NGXÏð"
  b"\x01—Y¸\t\x06r週Â*\x1CÆ\x1F–"
  b"\x01—Y¸\t\x07q\x10¡\e_h¸®º0"
  b"\x01—Y¸\t\x07q\x10¡\e_hÉ \fú"
  b"\x01—Y¸\tfr¡ºÍŽ¹'Yi!"
  b"\x01—Y¸\x08Kr\x17£Fž¯5Ëiz"
  b"""
    \x01—Y¸\x08Kr\x17£Fž¯\x0E¡\n
    Z
    """
  b"\x01ùY©\x08¿q9ü┌ì¾\x0F\e\x17Æ"
  b"\x01—Y¸\x08©r(‹‚ N-\x05/º"
  b"\x01ùY©\x08¿q9ü┌ì¾\e*[Í"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x04\x02\e“"
  b"\x01ùY©\x08Kr\x17úF×»'ô┘ì"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x1D6Å~"
  b"\x01—Y¸\x08©r(‹‚ N%ËŒ["
  b"\x01—Y¸\x08©r(‹‚ N4_%Y"
  b"\x01—Y¸\t\x06r週Â*Eú‹u"
  b"\x01—Y¸\x08Kr\x17£Fž¯4\x13d\x15"
  b"\x01—Y¸\x08©r(‹‚ N>u§7"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x04þ\x13M"
  b"\x01—Y¸\x08Kr\x17£Fž¯HÊœ\x0F"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x13gÐX"
  b"\x01—Y¸\x08Kr\x17£Fž¯7mç/"
  b"\x01ùY©\x08¿q9ü┌ì¾\x19OÀÈ"
  b"\x01—Y¸\x08©r(‹‚ N:!‘ƒ"
  b"\x01—Y¸\t\x06r週Â*7ìÅ'"
  b"\x01—Y¸\t\x07q\x10¡\e_h½åÜ\x16"
  b"\x01—Y¸\tfr¡ºÍŽ¹$)kì"
  b"\x01—Y¸\x08©r(‹‚ N\x15\x7Fé’"
  b"\x01—Y¸\t\x06r週Â*=G¼\x04"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x19K§\x0F"
  b"\x01ùY©\x08¿q9ü┌ì¾\x13 \x03h"
  b"\x01—Y¸\x08©r(‹‚ N5\t\x07\x01"
  b"\x01—Y¸\t\x06r週Â*4\x16#·"
  b"\x01—Y¸\t\x06r週Â*=‰\x17Ú"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x1EÃ#ñ"
  b"\x01—Y¸\x08Kr\x17£Fž¯Bãæ\n"
  b"\x01ùY©\x08¿q9ü┌ì¾\x10×,T"
  b"\x01ùY©\x08®r(ïéáN\x18ØÁx"
  b"\x01—Y¸\t\x06r週Â*#íˆý"
  b"\x01—Y¸\x08©r(‹‚ NKrvN"
  b"\x01—Y¸\x08Kr\x17£Fž®ÿ\x05\x1DÂ"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x02¦êx"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x16¬§‹"
  b"\x01ùY©\x08¿q9ü┌ì¾!╔Ï═"
  b"\x01ùY©\x08®r(ïéáN0kü·"
  b"\x01—Y¸\x08©r(‹‚ NI•øŒ"
  b"\x01—Y¸\x08Kr\x17£Fž¯F¸yõ"
  b"\x01ùY©\x08¿q9ü┌ì¾\x1C)Ûã"
  b"\x01—Y¸\t\x07q\x10¡\e_hÏš\x07t"
  b"\x01—Y¸\x08Kr\x17£Fž¯BŽå$"
  b"\x01—Y¸\x08©r(‹‚ N=\x02…Æ"
  b"\x01ùY©\t\x06rÚÇ▒┬* \x02Øh"
  b"\x01—Y¸\t\x06r週Â*!\x05¼„"
  b"\x01—Y¸\t\x06r週Â*=ó¦§"
  b"\x01—Y¸\tfr¡ºÍŽ¹\x11\x7F·‚"
  b"\x01—Y¸\x08Kr\x17£Fž¯\x17z#+"
  b"\x01ùY©\x08¿q9ü┌ì¾\x15║¦¤"
  b"\x01—Y¸\x08©r(‹‚ N&‚˲"
  b"\x01—Y¸\x08©r(‹‚ N4Í\x04d"
  b"\x01—Y¸\t\x07q\x10¡\e_h·wc\t"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.94 ms
(2.33%) 		1 
# product-listing-route::loading::association::prices::read
SELECT `product_price`.`id` as `product_price.id`, `product_price`.`version_id` as `product_price.versionId`, `product_price`.`product_id` as `product_price.productId`, `product_price`.`product_version_id` as `product_price.productVersionId`, `product_price`.`rule_id` as `product_price.ruleId`, `product_price`.`price` as `product_price.price`, `product_price`.`quantity_start` as `product_price.quantityStart`, `product_price`.`quantity_end` as `product_price.quantityEnd`, `product_price`.`custom_fields` as `product_price.customFields`, `product_price`.`created_at` as `product_price.createdAt`, `product_price`.`updated_at` as `product_price.updatedAt` FROM `product_price` WHERE (`product_price`.`version_id` = ?) AND ((`product_price`.`product_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01—Y¸0«p¯³,¿FYú׃"
  b"\x01—Y¸0Åqæ—X%úmq06"
  b"\x01—Y¸0ÇrÛ°³^¤˜¨\x06 "
  b"\x01—Y¸1°sÓ¤í_8—êþ¼"
  b"\x01ùY©1Àsfü\x1D¤Î╦þºn"
  b"\x01—Y¸1ºq|¹â\x13=ô¬X£"
  b"\x01—Y¸1½r¿¿\x7F¦ªWuƒC"
  b"\x01—Y¸1ÀrѦ{`ŠÕ¼ t"
  b"\x01—Y¸1Åp$ªNøAr³Š\x1E"
  b"\x01ùY©1╩pýÉ╣┴░\x02\x11├?"
  b"\x01—Y¸1Ír\ršãØ{‡ÖdÏ"
  b"\x01—Y¸1Ïp0¼ï\x0F„Æ?Àÿ"
  b"\x01—Y¸2Ÿp\x12»«7ñœp™Ô"
  b"\x01—Y¸2¢q¡£ÏûŸ!\x1D*#"
  b"\x01—Y¸2¯s\x04“ýˆ%Õ±õþ"
  b"\x01—Y¸2ÈrY¦âP\x08úzro"
  b"\x01—Y¸2Ês@º§+m­ltT"
  b"\x01—Y¸2Íq\x05ƒ\x04õ\e\x16lYÖ"
  b"\x01—Y¸3ÝpW¨\t–rëû{\x02"
  b"""
    \x01—Y¸3ßr‘ —øÃ\n
    ÔÎ\x12
    """
  b"\x01—Y¸3òp[¹œ\x1CÆ\x02í2~"
  b"\x01—Y¸3õs\x15¶A‹êÞtëû"
  b"\x01—Y¸3ørjŽL Øó•r&"
  b"\x01—Y¸3úrñ¤\e\x1CÄc³+x"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.94 ms
(2.33%) 		1 
# product-listing-route::loading::aggregation::manufacturer
SELECT LOWER(HEX(IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`))) as `manufacturer` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?))) GROUP BY IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`)
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"\x01—Y·Ð,pãµ×`üç“r\x7F"
  true
  b"""
    \x01—Y¸\n
    @q8™7\x11ö`î\x13\x11
    """
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
0.73 ms
(1.82%) 		1 
# product-listing-route::loading::aggregation::rating-exists
SELECT MAX(IFNULL(`product`.`rating_average`, `product.parent`.`rating_average`)) as `rating` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?))) AND (((IFNULL(`product`.`rating_average`, `product.parent`.`rating_average`) >= ?)))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"\x01—Y·Ð,pãµ×`üç“r\x7F"
  true
  b"""
    \x01—Y¸\n
    @q8™7\x11ö`î\x13\x11
    """
  null
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
0.71 ms
(1.75%) 		1 
# category::data::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`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` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"""
    \x01—Y¸\n
    @q8™7\x11ö`î\x13\x11
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.64 ms
(1.58%) 		1 
# product-listing-route::loading::aggregation::shipping-free-filter
SELECT MAX(IFNULL(`product`.`shipping_free`, `product.parent`.`shipping_free`)) as `shipping-free` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?))) AND ((IFNULL(`product`.`shipping_free`, `product.parent`.`shipping_free`) = ?))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"\x01—Y·Ð,pãµ×`üç“r\x7F"
  true
  b"""
    \x01—Y¸\n
    @q8™7\x11ö`î\x13\x11
    """
  null
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.58 ms
(1.42%) 		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.55 ms
(1.36%) 		1 
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.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"""
    \x01—Y¸\n
    @q8™7\x11ö`î\x13\x11
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.55 ms
(1.35%) 		1 
# product-listing-route::loading::search-ids
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?))) AND (`product`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY `product`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  10
  b"\x01—Y·Ð,pãµ×`üç“r\x7F"
  true
  b"\x01—Y¸1Ïp0¼ï\x0F„Æ?Àÿ"
  b"\x01—Y¸1°sÓ¤í_8—êþ¼"
  b"\x01—Y¸0ÇrÛ°³^¤˜¨\x06 "
  b"\x01—Y¸3õs\x15¶A‹êÞtëû"
  b"\x01—Y¸1ºq|¹â\x13=ô¬X£"
  b"\x01ùY©1╩pýÉ╣┴░\x02\x11├?"
  b"\x01—Y¸2ÈrY¦âP\x08úzro"
  b"\x01—Y¸3ÝpW¨\t–rëû{\x02"
  b"\x01—Y¸1Ír\ršãØ{‡ÖdÏ"
  b"\x01—Y¸1ÀrѦ{`ŠÕ¼ t"
  b"\x01—Y¸0Åqæ—X%úmq06"
  b"""
    \x01—Y¸3ßr‘ —øÃ\n
    ÔÎ\x12
    """
  b"\x01—Y¸2Ês@º§+m­ltT"
  b"\x01ùY©1Àsfü\x1D¤Î╦þºn"
  b"\x01—Y¸3ørjŽL Øó•r&"
  b"\x01—Y¸2Íq\x05ƒ\x04õ\e\x16lYÖ"
  b"\x01—Y¸3úrñ¤\e\x1CÄc³+x"
  b"\x01—Y¸1Åp$ªNøAr³Š\x1E"
  b"\x01—Y¸2¢q¡£ÏûŸ!\x1D*#"
  b"\x01—Y¸1½r¿¿\x7F¦ªWuƒC"
  b"\x01—Y¸3òp[¹œ\x1CÆ\x02í2~"
  b"\x01—Y¸2Ÿp\x12»«7ñœp™Ô"
  b"\x01—Y¸2¯s\x04“ýˆ%Õ±õþ"
  b"\x01—Y¸0«p¯³,¿FYú׃"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.46 ms
(1.15%) 		1 
# manufacturer-aggregation::read
SELECT `product_manufacturer`.`id` as `product_manufacturer.id`, `product_manufacturer`.`version_id` as `product_manufacturer.versionId`, `product_manufacturer`.`media_id` as `product_manufacturer.mediaId`, `product_manufacturer`.`link` as `product_manufacturer.link`, `product_manufacturer`.`created_at` as `product_manufacturer.createdAt`, `product_manufacturer`.`updated_at` as `product_manufacturer.updatedAt`, `product_manufacturer.translation.name`, `product_manufacturer.translation.name` as `product_manufacturer.name`, `product_manufacturer.translation.description`, `product_manufacturer.translation.description` as `product_manufacturer.description`, `product_manufacturer.translation.customFields`, `product_manufacturer.translation.customFields` as `product_manufacturer.customFields` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.`product_manufacturer_id`, `product_manufacturer.translation`.`product_manufacturer_version_id`, `product_manufacturer.translation`.`name` as `product_manufacturer.translation.name`, `product_manufacturer.translation`.`description` as `product_manufacturer.translation.description`, `product_manufacturer.translation`.`custom_fields` as `product_manufacturer.translation.customFields` FROM `product_manufacturer_translation` `product_manufacturer.translation` WHERE `product_manufacturer.translation`.`language_id` = ?) `product_manufacturer.product_manufacturer_translation` ON `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product_manufacturer`.`id` AND `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_version_id` = `product_manufacturer`.`version_id` WHERE (`product_manufacturer`.`version_id` = ?) AND (`product_manufacturer`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01—Y¸\x13¨qé±dâ=\x06\x075\x07"
  b"\x01—Y¸\x13©seª”Î\x1A\x00*/\x18"
  b"\x01—Y¸\x13¨qé±dâ=\x04ŒÅL"
  b"\x01—Y¸\x13¨qé±dâ=\x05µ\v¹"
  b"\x01ùY©\x13¿qÚ▒dÔ=\x05C┬ü"
  b"\x01ùY©\x13¬qÉù░%ß\x17Þ²\x16"
  b"\x01—Y¸\x13©seª”Î\x19ùT\x12x"
  b"\x01—Y·•Ãrè²ïÓ’\x10’/E"
  b"""
    \x01ùY©\x13¬qÉù░%ß\eE\n
    À
    """
  b"\x01—Y¸\x13©seª”Î\x19öŒS|"
  b"\x01—Y¸\x13©seª”Î\x1A\x04Ñ:_"
  b"\x01—Y¸\x13¨qé±dâ=\x05¤ ò"
  b"\x01ùY©\x13¬qÉù░%ß\x1C4├Ä"
  b"\x01—Y¸\x13©seª”Î\x1A\x03§ï%"
  b"\x01ùY©\x13®se¬ö╬\x19·üÄ3"
  b"\x01—Y¸\x13©seª”Î\x1A\x00¯¬Ó"
  b"\x01ùY©\x13¬qÉù░%ß\x1D)═¥"
  b"\x01—Y¸\x13©seª”Î\x1A\x04\x08­Ð"
  b"\x01—Y¸\x13©seª”Î\x1A\x04\”\v"
  b"\x01—Y¸\x13©seª”Î\x19þ &±"
  b"\x01—Y¸\x13©seª”Î\x19ý¬ï\x16"
  b"\x01—Y¸\x13©seª”Î\x19üñUä"
  b"\x01ùY©\x13¬qÉù░%ß\x18_J▄"
  b"\x01ùY©\x13®se¬ö╬\x19÷ì┤│"
  b"\x01ùY©\x13¬qÉù░%ß\x1Cå? "
  b"\x01ùY©\x13¬qÉù░%ß\x1C$\x01ß"
  b"\x01ùY©\x13¬qÉù░%ß\x19ègÚ"
  b"\x01ùY©\x13¬qÉù░%ß\x15:_O"
  b"\x01—Y¸\x13©seª”Î\x19÷þ¨è"
  b"\x01—Y¸\x13©seª”Î\x19ú\f\x14\x1D"
  b"\x01—Y¸\x13©seª”Î\x1A\x00§E\x05"
  b"\x01ùY©\x13®se¬ö╬\x19¨Øñ-"
  b"\x01ùY©\x13¬qÉù░%ß\x17Fà/"
  b"\x01—Y¸\x13¨qé±dâ=\x03ƒlÿ"
  b"\x01ùY©\x13¬qÉù░%ß\x14╣ÄÊ"
  b"\x01—Y¸\x13©seª”Î\x1A\x02‘\r§"
  b"\x01ùY©\x13¬qÉù░%ß\x1CÁ╦©"
  b"\x01—Y¸\x13©seª”Î\x19þ:\x02 "
  b"\x01—Y¸\x13¨qé±dâ=\x04ãæâ"
  b"\x01—Y¸\x13©seª”Î\x19øg\x13Ü"
  b"\x01—Y¸\x13©seª”Î\x19ûlé7"
  b"\x01—Y¸\x13©seª”Î\x19÷Xž×"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.40 ms
(0.98%) 		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"""
    \x01—Y¸\n
    :s–¥wŠ¯9àÿr
    """
  b"""
    \x01—Y¸\n
    @q8™7\x11ö`î\x13\x11
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(0.97%) 		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"\x01—Y·•²q\x05¶Xó\x05dâÕ^"
  b"\x01ùYÀò©sÚûÅ#â]»àÑ"
  b"\x01—Y·ž\x18p-ª\x1FŠA…ê\x1D«"
  b"\x01—Y·•Ér0•¬\x06$(Òp•"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(0.96%) 		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.38 ms
(0.95%) 		1 
# category::cms-page::association::sections::read
SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`position` as `cms_section.position`, `cms_section`.`type` as `cms_section.type`, `cms_section`.`locked` as `cms_section.locked`, `cms_section`.`name` as `cms_section.name`, `cms_section`.`sizing_mode` as `cms_section.sizingMode`, `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`, `cms_section`.`background_color` as `cms_section.backgroundColor`, `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`, `cms_section`.`css_class` as `cms_section.cssClass`, `cms_section`.`cms_page_id` as `cms_section.pageId`, `cms_section`.`visibility` as `cms_section.visibility`, `cms_section`.`custom_fields` as `cms_section.customFields`, `cms_section`.`version_id` as `cms_section.versionId`, `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`, `cms_section`.`created_at` as `cms_section.createdAt`, `cms_section`.`updated_at` as `cms_section.updatedAt`, `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`config` as `cms_section.backgroundMedia.config`, `cms_section.backgroundMedia`.`path` as `cms_section.backgroundMedia.path`, `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`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"\x01—Y·•ìrì“\x7F\fMòlõG"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.35 ms
(0.87%) 		1 
# category::cms-page::association::sections::association::blocks::read
SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`position` as `cms_block.position`, `cms_block`.`type` as `cms_block.type`, `cms_block`.`locked` as `cms_block.locked`, `cms_block`.`name` as `cms_block.name`, `cms_block`.`section_position` as `cms_block.sectionPosition`, `cms_block`.`margin_top` as `cms_block.marginTop`, `cms_block`.`margin_bottom` as `cms_block.marginBottom`, `cms_block`.`margin_left` as `cms_block.marginLeft`, `cms_block`.`margin_right` as `cms_block.marginRight`, `cms_block`.`background_color` as `cms_block.backgroundColor`, `cms_block`.`background_media_id` as `cms_block.backgroundMediaId`, `cms_block`.`background_media_mode` as `cms_block.backgroundMediaMode`, `cms_block`.`css_class` as `cms_block.cssClass`, `cms_block`.`visibility` as `cms_block.visibility`, `cms_block`.`cms_section_id` as `cms_block.sectionId`, `cms_block`.`custom_fields` as `cms_block.customFields`, `cms_block`.`version_id` as `cms_block.versionId`, `cms_block`.`cms_section_version_id` as `cms_block.cmsSectionVersionId`, `cms_block`.`created_at` as `cms_block.createdAt`, `cms_block`.`updated_at` as `cms_block.updatedAt`, `cms_block.backgroundMedia`.`id` as `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` as `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` as `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` as `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` as `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` as `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` as `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` as `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` as `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` as `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`config` as `cms_block.backgroundMedia.config`, `cms_block.backgroundMedia`.`path` as `cms_block.backgroundMedia.path`, `cms_block.backgroundMedia`.`private` as `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`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"\x01—Y·™=pû°°ŠÅR\x11û¦"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.35 ms
(0.87%) 		1 
# category::cms-page::read
SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`version_id` as `cms_page.versionId`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`css_class` as `cms_page.cssClass`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.translation.name`, `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"\x01—Y·•ìrì“\x7F\fMòlõG"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.34 ms
(0.85%) 		1 
# product-listing-loader::resolve-previews
            SELECT
                parent.variant_listing_config as variantListingConfig,
                LOWER(HEX(child.id)) as id,
                LOWER(HEX(parent.id)) as parentId
             FROM product as child
                INNER JOIN product as parent
                    ON parent.id = child.parent_id
                    AND parent.version_id = child.version_id
             WHERE child.version_id = ?
             AND child.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01—Y¸1Ïp0¼ï\x0F„Æ?Àÿ"
  b"\x01—Y¸1°sÓ¤í_8—êþ¼"
  b"\x01—Y¸0ÇrÛ°³^¤˜¨\x06 "
  b"\x01—Y¸3õs\x15¶A‹êÞtëû"
  b"\x01—Y¸1ºq|¹â\x13=ô¬X£"
  b"\x01ùY©1╩pýÉ╣┴░\x02\x11├?"
  b"\x01—Y¸2ÈrY¦âP\x08úzro"
  b"\x01—Y¸3ÝpW¨\t–rëû{\x02"
  b"\x01—Y¸1Ír\ršãØ{‡ÖdÏ"
  b"\x01—Y¸1ÀrѦ{`ŠÕ¼ t"
  b"\x01—Y¸0Åqæ—X%úmq06"
  b"""
    \x01—Y¸3ßr‘ —øÃ\n
    ÔÎ\x12
    """
  b"\x01—Y¸2Ês@º§+m­ltT"
  b"\x01ùY©1Àsfü\x1D¤Î╦þºn"
  b"\x01—Y¸3ørjŽL Øó•r&"
  b"\x01—Y¸2Íq\x05ƒ\x04õ\e\x16lYÖ"
  b"\x01—Y¸3úrñ¤\e\x1CÄc³+x"
  b"\x01—Y¸1Åp$ªNøAr³Š\x1E"
  b"\x01—Y¸2¢q¡£ÏûŸ!\x1D*#"
  b"\x01—Y¸1½r¿¿\x7F¦ªWuƒC"
  b"\x01—Y¸3òp[¹œ\x1CÆ\x02í2~"
  b"\x01—Y¸2Ÿp\x12»«7ñœp™Ô"
  b"\x01—Y¸2¯s\x04“ýˆ%Õ±õþ"
  b"\x01—Y¸0«p¯³,¿FYú׃"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.81%) 		1 
# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND ((seo_path_info = ? OR seo_path_info = ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01—Y·Ð,pãµ×`üç“r\x7F"
  "Music/Home-Grocery"
  "Music/Home-Grocery/"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.81%) 		1 
# category::cms-page::association::sections::association::blocks::association::slots::read
SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`type` as `cms_slot.type`, `cms_slot`.`slot` as `cms_slot.slot`, `cms_slot`.`locked` as `cms_slot.locked`, `cms_slot`.`cms_block_id` as `cms_slot.blockId`, `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.translation.config`, `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"\x01—Y·•ísEŽ)N–OZç¦"
  b"\x01—Y·•ísEŽ)N–Oº+è"
  b"\x01—Y·™ósÜ·\x12®‰¦ùÀ\x04"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(0.65%) 		1 
SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.translation.label`, `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.`product_sorting_id`, `product_sorting.translation`.`label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.`language_id` = ?) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01—Y·£åsH©qàPTÁ}¨"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.24 ms
(0.59%) 		1 
# product-listing::load-sortings::read
SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.translation.label`, `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.`product_sorting_id`, `product_sorting.translation`.`label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.`language_id` = ?) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01—Y·£åsH©qàPTÁ}¨"
  b"\x01—Y·£åsH©qàPTû\x00J"
  b"""
    \x01—Y·£åsH©qàPUB\n
    x
    """
  b"\x01—Y·£åsH©qàPUx\x19À"
  b"\x01—Y·£åsH©qàPVLõÜ"
  b"\x01—Y·¥Ïs¸¨Ñx¡SX†£"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(0.58%) 		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.21 ms
(0.52%) 		1 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"\x01—Y·Ð,pãµ×`üç“r\x7F"
  "DNQB8eGj3hIg5VI2Or0eDe3dZ0xwbTrI"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.21 ms
(0.52%) 		1 
# product-listing-route::category-loading::search-ids
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?)) LIMIT 1
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"""
    \x01—Y¸\n
    @q8™7\x11ö`î\x13\x11
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.19 ms
(0.47%) 		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.18 ms
(0.46%) 		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"\x01—Y·Ð,pãµ×`üç“r\x7F"
  b"\x01ùYÀòpr\x17Å\vTAU\t\x1EE"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(0.43%) 		1 
SELECT path FROM category WHERE id = ?
Parameters: 
[
  b"""
    \x01—Y¸\n
    @q8™7\x11ö`î\x13\x11
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.16 ms
(0.41%) 		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.16 ms
(0.41%) 		1 
# product-listing::load-sortings::search-ids
SELECT `product_sorting`.`id` FROM `product_sorting` WHERE (`product_sorting`.`active` = ?) ORDER BY `product_sorting`.`priority` DESC
Parameters: 
[
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.14 ms
(0.36%) 		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.13 ms
(0.32%) 		1 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.32%) 		1 
# product-listing-route::category-loading::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`product_stream_id` as `category.productStreamId` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"""
    \x01—Y¸\n
    @q8™7\x11ö`î\x13\x11
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.12 ms
(0.30%) 		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.