GET https://dynatech-stage.sv24.com/detail/cb6fb463de24ec119d1a005056be7e8d

Query Metrics

134 Database Queries
86 Different statements
92.98 ms Query time

Grouped Statements

Show all queries

Time Count Info
16.99 ms
(18.27%)
1
# seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (seo_url.language_id = ?) AND (seo_url.sales_channel_id = ? OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0)
Parameters:
[
  "/detail/cb6fb463de24ec119d1a005056be7e8d"
  "/landingPage/7144211ac0f4464e9688bcec83087317"
  "/navigation/87d8be0bfb6eed119d20005056be7e8d"
  "/navigation/0cb07f8cfb6eed119d20005056be7e8d"
  "/navigation/a22f4199fb6eed119d20005056be7e8d"
  "/navigation/3c80cab6fb6eed119d20005056be7e8d"
  "/navigation/918974fffb6eed119d20005056be7e8d"
  "/navigation/a626060cfc6eed119d20005056be7e8d"
  "/navigation/da26aceafb6eed119d20005056be7e8d"
  "/navigation/db8837d4fb6eed119d20005056be7e8d"
  "/navigation/19bac2f4fb6eed119d20005056be7e8d"
  "/navigation/17044b13fc6eed119d20005056be7e8d"
  "/navigation/7a94f3dffb6eed119d20005056be7e8d"
  "/navigation/7b94f3dffb6eed119d20005056be7e8d"
  "/navigation/c30d4393fb6eed119d20005056be7e8d"
  "/navigation/d35b5b2f9d7ced119d24005056be7e8d"
  "/navigation/352574cb3a7aed119d24005056be7e8d"
  "/navigation/682834e03a7aed119d24005056be7e8d"
  "/navigation/17984fea3a7aed119d24005056be7e8d"
  "/navigation/da8837d4fb6eed119d20005056be7e8d"
  "/navigation/97c95dacfb6eed119d20005056be7e8d"
  "/navigation/96c95dacfb6eed119d20005056be7e8d"
  "/navigation/d926aceafb6eed119d20005056be7e8d"
  "/navigation/0c1ac8befb6eed119d20005056be7e8d"
  "/navigation/a12f4199fb6eed119d20005056be7e8d"
  "/navigation/6a55c6c6fb6eed119d20005056be7e8d"
  "/navigation/a426060cfc6eed119d20005056be7e8d"
  "/navigation/a526060cfc6eed119d20005056be7e8d"
  "/navigation/e492f4b3c877ed119d24005056be7e8d"
  "/navigation/a726060cfc6eed119d20005056be7e8d"
  "/navigation/c5a034a6b877ed119d24005056be7e8d"
  "/navigation/14036006016fed119d20005056be7e8d"
  "/navigation/15036006016fed119d20005056be7e8d"
  "/navigation/16036006016fed119d20005056be7e8d"
  "/navigation/17036006016fed119d20005056be7e8d"
  "/navigation/18036006016fed119d20005056be7e8d"
  "/navigation/d4e12dbdb777ed119d24005056be7e8d"
  "/navigation/19036006016fed119d20005056be7e8d"
  "/navigation/1a036006016fed119d20005056be7e8d"
  "/navigation/1b036006016fed119d20005056be7e8d"
  "/navigation/18bac2f4fb6eed119d20005056be7e8d"
  "/navigation/1c036006016fed119d20005056be7e8d"
  "/navigation/4479e664066fed119d20005056be7e8d"
  "/navigation/4a79e664066fed119d20005056be7e8d"
  "/navigation/4d79e664066fed119d20005056be7e8d"
  "/navigation/c705e96a066fed119d20005056be7e8d"
  "/navigation/ca05e96a066fed119d20005056be7e8d"
  "/navigation/cf05e96a066fed119d20005056be7e8d"
  "/navigation/d405e96a066fed119d20005056be7e8d"
  "/navigation/ea05e96a066fed119d20005056be7e8d"
  "/navigation/f205e96a066fed119d20005056be7e8d"
  "/navigation/f705e96a066fed119d20005056be7e8d"
  "/navigation/d269fc70066fed119d20005056be7e8d"
  "/navigation/d769fc70066fed119d20005056be7e8d"
  "/navigation/718a667d066fed119d20005056be7e8d"
  "/navigation/768a667d066fed119d20005056be7e8d"
  "/navigation/7b8a667d066fed119d20005056be7e8d"
  "/navigation/4736d1cf006fed119d20005056be7e8d"
  "/navigation/4836d1cf006fed119d20005056be7e8d"
  "/navigation/4936d1cf006fed119d20005056be7e8d"
  "/navigation/4a36d1cf006fed119d20005056be7e8d"
  "/navigation/04e3f819fb6eed119d20005056be7e8d"
  "/navigation/5e6a064efc6eed119d20005056be7e8d"
  "/navigation/5f6a064efc6eed119d20005056be7e8d"
  "/navigation/606a064efc6eed119d20005056be7e8d"
  "/navigation/616a064efc6eed119d20005056be7e8d"
  "/navigation/626a064efc6eed119d20005056be7e8d"
  "/navigation/636a064efc6eed119d20005056be7e8d"
  "/navigation/646a064efc6eed119d20005056be7e8d"
  "/navigation/d65eb1690e81ed119d24005056be7e8d"
  "/navigation/656a064efc6eed119d20005056be7e8d"
  "/navigation/666a064efc6eed119d20005056be7e8d"
  "/navigation/676a064efc6eed119d20005056be7e8d"
  "/navigation/686a064efc6eed119d20005056be7e8d"
  "/navigation/696a064efc6eed119d20005056be7e8d"
  "/navigation/6a6a064efc6eed119d20005056be7e8d"
  "/navigation/805c4854fc6eed119d20005056be7e8d"
  "/navigation/815c4854fc6eed119d20005056be7e8d"
  "/navigation/fedd81920d6fed119d20005056be7e8d"
  "/navigation/1ff7797ee47aed119d24005056be7e8d"
  "/navigation/feb4a0bcfd7aed119d24005056be7e8d"
  "/navigation/05de81920d6fed119d20005056be7e8d"
  "/navigation/ef1441dd0d6fed119d20005056be7e8d"
  "/navigation/f01441dd0d6fed119d20005056be7e8d"
  "/navigation/f11441dd0d6fed119d20005056be7e8d"
  "/navigation/d0c6eefe0d6fed119d20005056be7e8d"
  "/navigation/d1c6eefe0d6fed119d20005056be7e8d"
  "/navigation/d2c6eefe0d6fed119d20005056be7e8d"
  "/navigation/5589f33d0e6fed119d20005056be7e8d"
  "/navigation/5689f33d0e6fed119d20005056be7e8d"
  "/navigation/5789f33d0e6fed119d20005056be7e8d"
  "/navigation/5889f33d0e6fed119d20005056be7e8d"
  "/navigation/8c9df8660e6fed119d20005056be7e8d"
  "/navigation/8d9df8660e6fed119d20005056be7e8d"
  "/navigation/8e9df8660e6fed119d20005056be7e8d"
  "/navigation/0a1b6a7a0e6fed119d20005056be7e8d"
  "/navigation/0b1b6a7a0e6fed119d20005056be7e8d"
  "/navigation/0c1b6a7a0e6fed119d20005056be7e8d"
  "/navigation/d33f36ec166fed119d20005056be7e8d"
  "/navigation/d43f36ec166fed119d20005056be7e8d"
  "/navigation/c3b55e740e81ed119d24005056be7e8d"
  "/navigation/c4b55e740e81ed119d24005056be7e8d"
  "/navigation/3064ea7a0e81ed119d24005056be7e8d"
  "/navigation/bd74f610176fed119d20005056be7e8d"
  "/navigation/be74f610176fed119d20005056be7e8d"
  "/navigation/5e65d632176fed119d20005056be7e8d"
  "/navigation/5f65d632176fed119d20005056be7e8d"
  "/navigation/6065d632176fed119d20005056be7e8d"
  "/navigation/6165d632176fed119d20005056be7e8d"
  "/navigation/6265d632176fed119d20005056be7e8d"
  "/navigation/0aa59754176fed119d20005056be7e8d"
  "/navigation/0ba59754176fed119d20005056be7e8d"
  "/navigation/0ca59754176fed119d20005056be7e8d"
  "/navigation/0da59754176fed119d20005056be7e8d"
  "/navigation/04d3e06e176fed119d20005056be7e8d"
  "/navigation/05d3e06e176fed119d20005056be7e8d"
  "/navigation/06d3e06e176fed119d20005056be7e8d"
  "/navigation/07d3e06e176fed119d20005056be7e8d"
  "/navigation/08d3e06e176fed119d20005056be7e8d"
  "/navigation/09d3e06e176fed119d20005056be7e8d"
  "/navigation/0ad3e06e176fed119d20005056be7e8d"
  "/navigation/0bd3e06e176fed119d20005056be7e8d"
  "/navigation/a2da20b9a38ded119d24005056be7e8d"
  "/navigation/0cd3e06e176fed119d20005056be7e8d"
  "/navigation/55143675176fed119d20005056be7e8d"
  "/navigation/56143675176fed119d20005056be7e8d"
  "/navigation/c6ba5f201e6fed119d20005056be7e8d"
  "/navigation/c7ba5f201e6fed119d20005056be7e8d"
  "/navigation/c8ba5f201e6fed119d20005056be7e8d"
  "/navigation/c9ba5f201e6fed119d20005056be7e8d"
  "/navigation/dd1bdd261e6fed119d20005056be7e8d"
  "/navigation/1e1b5388e57aed119d24005056be7e8d"
  "/navigation/ffdd81920d6fed119d20005056be7e8d"
  "/navigation/00de81920d6fed119d20005056be7e8d"
  "/navigation/02de81920d6fed119d20005056be7e8d"
  "/navigation/62b11f3a4097ed119d24005056be7e8d"
  "/navigation/0e6d554b1e6fed119d20005056be7e8d"
  "/navigation/0f6d554b1e6fed119d20005056be7e8d"
  "/navigation/106d554b1e6fed119d20005056be7e8d"
  "/navigation/116d554b1e6fed119d20005056be7e8d"
  "/navigation/126d554b1e6fed119d20005056be7e8d"
  "/navigation/4ff589511e6fed119d20005056be7e8d"
  "/navigation/50f589511e6fed119d20005056be7e8d"
  "/navigation/891e4bd01e6fed119d20005056be7e8d"
  "/navigation/8a1e4bd01e6fed119d20005056be7e8d"
  "/navigation/8b1e4bd01e6fed119d20005056be7e8d"
  "/navigation/8c1e4bd01e6fed119d20005056be7e8d"
  "/navigation/8d1e4bd01e6fed119d20005056be7e8d"
  "/navigation/93bec614246fed119d20005056be7e8d"
  "/navigation/94bec614246fed119d20005056be7e8d"
  "/navigation/95bec614246fed119d20005056be7e8d"
  "/navigation/96bec614246fed119d20005056be7e8d"
  "/navigation/97bec614246fed119d20005056be7e8d"
  "/navigation/98bec614246fed119d20005056be7e8d"
  "/navigation/885422b3588bed119d24005056be7e8d"
  "/navigation/99bec614246fed119d20005056be7e8d"
  "/navigation/b855dc1b246fed119d20005056be7e8d"
  "/navigation/50d12716b47fed119d24005056be7e8d"
  "/navigation/0f38aaa9276fed119d20005056be7e8d"
  "/navigation/1038aaa9276fed119d20005056be7e8d"
  "/navigation/1138aaa9276fed119d20005056be7e8d"
  "/navigation/1238aaa9276fed119d20005056be7e8d"
  "/navigation/1338aaa9276fed119d20005056be7e8d"
  "/navigation/1438aaa9276fed119d20005056be7e8d"
  "/navigation/8e48e6b0276fed119d20005056be7e8d"
  "/navigation/8f48e6b0276fed119d20005056be7e8d"
  "/navigation/7a72aee0276fed119d20005056be7e8d"
  "/navigation/7b72aee0276fed119d20005056be7e8d"
  "/navigation/7c72aee0276fed119d20005056be7e8d"
  "/navigation/7d72aee0276fed119d20005056be7e8d"
  "/navigation/7e72aee0276fed119d20005056be7e8d"
  "/navigation/7f72aee0276fed119d20005056be7e8d"
  "/navigation/feaf1125286fed119d20005056be7e8d"
  "/navigation/ffaf1125286fed119d20005056be7e8d"
  "/navigation/00b01125286fed119d20005056be7e8d"
  "/navigation/01b01125286fed119d20005056be7e8d"
  "/navigation/02b01125286fed119d20005056be7e8d"
  "/navigation/03b01125286fed119d20005056be7e8d"
  "/navigation/ca11192b286fed119d20005056be7e8d"
  "/navigation/cb11192b286fed119d20005056be7e8d"
  "/navigation/3b603be12a6fed119d20005056be7e8d"
  "/navigation/3c603be12a6fed119d20005056be7e8d"
  "/navigation/3d603be12a6fed119d20005056be7e8d"
  "/navigation/52ac10412b6fed119d20005056be7e8d"
  "/navigation/53ac10412b6fed119d20005056be7e8d"
  "/navigation/54ac10412b6fed119d20005056be7e8d"
  "/navigation/9715f1622b6fed119d20005056be7e8d"
  "/navigation/9815f1622b6fed119d20005056be7e8d"
  "/navigation/9915f1622b6fed119d20005056be7e8d"
  "/navigation/9a15f1622b6fed119d20005056be7e8d"
  "/navigation/944853b32b6fed119d20005056be7e8d"
  "/navigation/954853b32b6fed119d20005056be7e8d"
  "/navigation/964853b32b6fed119d20005056be7e8d"
  "/navigation/f5ef5ad92b6fed119d20005056be7e8d"
  "/navigation/f6ef5ad92b6fed119d20005056be7e8d"
  "/navigation/f7ef5ad92b6fed119d20005056be7e8d"
  "/navigation/65fb63ed2b6fed119d20005056be7e8d"
  "/navigation/66fb63ed2b6fed119d20005056be7e8d"
  "/navigation/67fb63ed2b6fed119d20005056be7e8d"
  "/navigation/0dd813202c6fed119d20005056be7e8d"
  "/navigation/0ed813202c6fed119d20005056be7e8d"
  "/navigation/0fd813202c6fed119d20005056be7e8d"
  "/navigation/e41a1f372c6fed119d20005056be7e8d"
  "/navigation/e51a1f372c6fed119d20005056be7e8d"
  "/navigation/e61a1f372c6fed119d20005056be7e8d"
  "/navigation/e71a1f372c6fed119d20005056be7e8d"
  "/navigation/e81a1f372c6fed119d20005056be7e8d"
  "/navigation/1961503d2c6fed119d20005056be7e8d"
  "/navigation/757e63f4b87fed119d24005056be7e8d"
  "/navigation/3a9fff782c6fed119d20005056be7e8d"
  "/navigation/0cd7ed8a2c6fed119d20005056be7e8d"
  "/navigation/c4a400c32c6fed119d20005056be7e8d"
  "/navigation/c5a400c32c6fed119d20005056be7e8d"
  "/navigation/b6f4a31bb37fed119d24005056be7e8d"
  "/navigation/66712b734097ed119d24005056be7e8d"
  "/navigation/7f24b1d42c6fed119d20005056be7e8d"
  "/navigation/8024b1d42c6fed119d20005056be7e8d"
  "/navigation/8124b1d42c6fed119d20005056be7e8d"
  "/navigation/8224b1d42c6fed119d20005056be7e8d"
  "/navigation/d9cf0a58a38ded119d24005056be7e8d"
  "/navigation/c7ec0f60a38ded119d24005056be7e8d"
  "/navigation/7496ad112d6fed119d20005056be7e8d"
  "/navigation/e5d411212d6fed119d20005056be7e8d"
  "/navigation/1a8c9f2b2d6fed119d20005056be7e8d"
  "/navigation/1b8c9f2b2d6fed119d20005056be7e8d"
  "/navigation/48ffd1422d6fed119d20005056be7e8d"
  "/navigation/0669bada897ced119d24005056be7e8d"
  "/navigation/779496672d6fed119d20005056be7e8d"
  "/navigation/789496672d6fed119d20005056be7e8d"
  "/navigation/298e5c822d6fed119d20005056be7e8d"
  "/navigation/2a8e5c822d6fed119d20005056be7e8d"
  "/navigation/904395d88a8aed119d24005056be7e8d"
  "/navigation/0af70a9f2d6fed119d20005056be7e8d"
  "/navigation/0bf70a9f2d6fed119d20005056be7e8d"
  "/navigation/0cf70a9f2d6fed119d20005056be7e8d"
  "/navigation/0df70a9f2d6fed119d20005056be7e8d"
  "/navigation/434e1657fa9aed119d24005056be7e8d"
  "/navigation/81eeced52d6fed119d20005056be7e8d"
  "/navigation/82eeced52d6fed119d20005056be7e8d"
  "/navigation/e7310fff2d6fed119d20005056be7e8d"
  "/navigation/adaa77a0339bed119d24005056be7e8d"
  "/navigation/e8310fff2d6fed119d20005056be7e8d"
  "/navigation/5ceb89162e6fed119d20005056be7e8d"
  "/navigation/5deb89162e6fed119d20005056be7e8d"
  "/navigation/09812580a38ded119d24005056be7e8d"
  "/navigation/4f1f073b2e6fed119d20005056be7e8d"
  "/navigation/501f073b2e6fed119d20005056be7e8d"
  "/navigation/511f073b2e6fed119d20005056be7e8d"
  "/navigation/521f073b2e6fed119d20005056be7e8d"
  "/navigation/c2e2965e2e6fed119d20005056be7e8d"
  "/navigation/c3e2965e2e6fed119d20005056be7e8d"
  "/navigation/664a3d7c2e6fed119d20005056be7e8d"
  "/navigation/674a3d7c2e6fed119d20005056be7e8d"
  "/navigation/6b8b04042f6fed119d20005056be7e8d"
  "/navigation/6c8b04042f6fed119d20005056be7e8d"
  "/navigation/6d8b04042f6fed119d20005056be7e8d"
  "/navigation/3b8d201cc76fed119d20005056be7e8d"
  "/navigation/01046b27c76fed119d20005056be7e8d"
  "/navigation/02046b27c76fed119d20005056be7e8d"
  "/navigation/03046b27c76fed119d20005056be7e8d"
  "/navigation/04046b27c76fed119d20005056be7e8d"
  "/navigation/9d03882dc76fed119d20005056be7e8d"
  "/navigation/9e03882dc76fed119d20005056be7e8d"
  "/navigation/9f03882dc76fed119d20005056be7e8d"
  "/navigation/a003882dc76fed119d20005056be7e8d"
  "/navigation/a103882dc76fed119d20005056be7e8d"
  "/navigation/694edb6cc76fed119d20005056be7e8d"
  "/navigation/6a4edb6cc76fed119d20005056be7e8d"
  "/navigation/6b4edb6cc76fed119d20005056be7e8d"
  "/navigation/6c4edb6cc76fed119d20005056be7e8d"
  "/navigation/4f45518fc76fed119d20005056be7e8d"
  "/navigation/5045518fc76fed119d20005056be7e8d"
  "/navigation/5145518fc76fed119d20005056be7e8d"
  "/navigation/5245518fc76fed119d20005056be7e8d"
  "/navigation/25eca4b9c76fed119d20005056be7e8d"
  "/navigation/1048e7c5c76fed119d20005056be7e8d"
  "/navigation/1a77c4e0c76fed119d20005056be7e8d"
  "/navigation/1b77c4e0c76fed119d20005056be7e8d"
  "/navigation/1c77c4e0c76fed119d20005056be7e8d"
  "/navigation/1d77c4e0c76fed119d20005056be7e8d"
  "/navigation/4106efe6c76fed119d20005056be7e8d"
  "/navigation/e746dc8bbb7fed119d24005056be7e8d"
  "/navigation/e1d900ef728bed119d24005056be7e8d"
  "/navigation/d60ae91efb9aed119d24005056be7e8d"
  "/navigation/10778b2ec86fed119d20005056be7e8d"
  "/navigation/f04abc6dc86fed119d20005056be7e8d"
  "/navigation/f14abc6dc86fed119d20005056be7e8d"
  "/navigation/f24abc6dc86fed119d20005056be7e8d"
  "/navigation/f34abc6dc86fed119d20005056be7e8d"
  "/navigation/4cdade8cc86fed119d20005056be7e8d"
  "/navigation/4ddade8cc86fed119d20005056be7e8d"
  "/navigation/4edade8cc86fed119d20005056be7e8d"
  "/navigation/275cc0cdc86fed119d20005056be7e8d"
  "/navigation/5c329c97b677ed119d24005056be7e8d"
  "/navigation/ddd3fadcc86fed119d20005056be7e8d"
  "/navigation/95863aa7898aed119d24005056be7e8d"
  "/navigation/212324f0c86fed119d20005056be7e8d"
  "/navigation/222324f0c86fed119d20005056be7e8d"
  "/navigation/232324f0c86fed119d20005056be7e8d"
  "/navigation/22719d15c96fed119d20005056be7e8d"
  "/navigation/2cb37825c96fed119d20005056be7e8d"
  "/navigation/2db37825c96fed119d20005056be7e8d"
  "/navigation/bd4f7e47c96fed119d20005056be7e8d"
  "/navigation/be4f7e47c96fed119d20005056be7e8d"
  "/navigation/f121eb65c96fed119d20005056be7e8d"
  "/navigation/f221eb65c96fed119d20005056be7e8d"
  "/navigation/f321eb65c96fed119d20005056be7e8d"
  "/navigation/f421eb65c96fed119d20005056be7e8d"
  "/navigation/2c372d88c96fed119d20005056be7e8d"
  "/navigation/2d372d88c96fed119d20005056be7e8d"
  "/navigation/2e372d88c96fed119d20005056be7e8d"
  "/navigation/2f372d88c96fed119d20005056be7e8d"
  "/navigation/30372d88c96fed119d20005056be7e8d"
  "/navigation/e581319d4897ed119d24005056be7e8d"
  "/navigation/0fc890a44897ed119d24005056be7e8d"
  "/navigation/dfdaacabc96fed119d20005056be7e8d"
  "/navigation/e4b71cb8c96fed119d20005056be7e8d"
  "/navigation/5efea3c4c96fed119d20005056be7e8d"
  "/navigation/30c76a47fb6eed119d20005056be7e8d"
  "/navigation/cfcc5cebfc6eed119d20005056be7e8d"
  "/navigation/d0cc5cebfc6eed119d20005056be7e8d"
  "/navigation/d1cc5cebfc6eed119d20005056be7e8d"
  "/navigation/ab65f630186fed119d20005056be7e8d"
  "/navigation/ac65f630186fed119d20005056be7e8d"
  "/navigation/ad65f630186fed119d20005056be7e8d"
  "/navigation/013eba870695ee119d28005056be7e8d"
  "/navigation/ae65f630186fed119d20005056be7e8d"
  "/navigation/af65f630186fed119d20005056be7e8d"
  "/navigation/b065f630186fed119d20005056be7e8d"
  "/navigation/b165f630186fed119d20005056be7e8d"
  "/navigation/97b6b465186fed119d20005056be7e8d"
  "/navigation/98b6b465186fed119d20005056be7e8d"
  "/navigation/99b6b465186fed119d20005056be7e8d"
  "/navigation/9787fe7f186fed119d20005056be7e8d"
  "/navigation/9887fe7f186fed119d20005056be7e8d"
  "/navigation/f0459a75bc6fed119d20005056be7e8d"
  "/navigation/f1459a75bc6fed119d20005056be7e8d"
  "/navigation/f2459a75bc6fed119d20005056be7e8d"
  "/navigation/f3459a75bc6fed119d20005056be7e8d"
  "/navigation/f4459a75bc6fed119d20005056be7e8d"
  "/navigation/f5459a75bc6fed119d20005056be7e8d"
  "/navigation/b728a67bbc6fed119d20005056be7e8d"
  "/navigation/b828a67bbc6fed119d20005056be7e8d"
  "/navigation/b928a67bbc6fed119d20005056be7e8d"
  "/navigation/ba28a67bbc6fed119d20005056be7e8d"
  "/navigation/850899d8bc6fed119d20005056be7e8d"
  "/navigation/860899d8bc6fed119d20005056be7e8d"
  "/navigation/870899d8bc6fed119d20005056be7e8d"
  "/navigation/880899d8bc6fed119d20005056be7e8d"
  "/navigation/890899d8bc6fed119d20005056be7e8d"
  "/navigation/8a0899d8bc6fed119d20005056be7e8d"
  "/navigation/8b0899d8bc6fed119d20005056be7e8d"
  "/navigation/e25544e0bc6fed119d20005056be7e8d"
  "/navigation/3d3e3c1ebd6fed119d20005056be7e8d"
  "/navigation/0050f025bd6fed119d20005056be7e8d"
  "/navigation/0150f025bd6fed119d20005056be7e8d"
  "/navigation/0250f025bd6fed119d20005056be7e8d"
  "/navigation/0350f025bd6fed119d20005056be7e8d"
  "/navigation/0450f025bd6fed119d20005056be7e8d"
  "/navigation/101ffc2bbd6fed119d20005056be7e8d"
  "/navigation/111ffc2bbd6fed119d20005056be7e8d"
  "/navigation/121ffc2bbd6fed119d20005056be7e8d"
  "/navigation/131ffc2bbd6fed119d20005056be7e8d"
  "/navigation/141ffc2bbd6fed119d20005056be7e8d"
  "/navigation/89592a6dbd6fed119d20005056be7e8d"
  "/navigation/8a592a6dbd6fed119d20005056be7e8d"
  "/navigation/8b592a6dbd6fed119d20005056be7e8d"
  "/navigation/8c592a6dbd6fed119d20005056be7e8d"
  "/navigation/8d592a6dbd6fed119d20005056be7e8d"
  "/navigation/8e592a6dbd6fed119d20005056be7e8d"
  "/navigation/8f592a6dbd6fed119d20005056be7e8d"
  "/navigation/740cb673bd6fed119d20005056be7e8d"
  "/navigation/50be9bd8bd6fed119d20005056be7e8d"
  "/navigation/51be9bd8bd6fed119d20005056be7e8d"
  "/navigation/52be9bd8bd6fed119d20005056be7e8d"
  "/navigation/53be9bd8bd6fed119d20005056be7e8d"
  "/navigation/4ed1fee6be6fed119d20005056be7e8d"
  "/navigation/4fd1fee6be6fed119d20005056be7e8d"
  "/navigation/50d1fee6be6fed119d20005056be7e8d"
  "/navigation/51d1fee6be6fed119d20005056be7e8d"
  "/navigation/52d1fee6be6fed119d20005056be7e8d"
  "/navigation/a48f6aedbe6fed119d20005056be7e8d"
  "/navigation/a58f6aedbe6fed119d20005056be7e8d"
  "/navigation/a68f6aedbe6fed119d20005056be7e8d"
  "/navigation/486cec36249bed119d24005056be7e8d"
  "/navigation/abd42d42d59bed119d24005056be7e8d"
  "/navigation/afbb0abecf77ed119d24005056be7e8d"
  "/navigation/ff2b92e6c96fed119d20005056be7e8d"
  "/navigation/002c92e6c96fed119d20005056be7e8d"
  "/navigation/44950f1eca6fed119d20005056be7e8d"
  "/navigation/45950f1eca6fed119d20005056be7e8d"
  "/navigation/46950f1eca6fed119d20005056be7e8d"
  "/navigation/8671a424ca6fed119d20005056be7e8d"
  "/navigation/d4b6fd4aca6fed119d20005056be7e8d"
  "/navigation/d5b6fd4aca6fed119d20005056be7e8d"
  "/navigation/d6b6fd4aca6fed119d20005056be7e8d"
  "/navigation/d7b6fd4aca6fed119d20005056be7e8d"
  "/navigation/cb6d2b34cb6fed119d20005056be7e8d"
  "/navigation/cc6d2b34cb6fed119d20005056be7e8d"
  "/navigation/cd6d2b34cb6fed119d20005056be7e8d"
  "/navigation/ce6d2b34cb6fed119d20005056be7e8d"
  "/navigation/41ecfa59cb6fed119d20005056be7e8d"
  "/navigation/9f88d36ecb6fed119d20005056be7e8d"
  "/navigation/fab5e07ccd6fed119d20005056be7e8d"
  "/navigation/2ce29c95cd6fed119d20005056be7e8d"
  "/navigation/2de29c95cd6fed119d20005056be7e8d"
  "/navigation/2ee29c95cd6fed119d20005056be7e8d"
  "/navigation/2fe29c95cd6fed119d20005056be7e8d"
  "/navigation/045c4b9ccd6fed119d20005056be7e8d"
  "/navigation/055c4b9ccd6fed119d20005056be7e8d"
  "/navigation/aaa010cbcd6fed119d20005056be7e8d"
  "/navigation/f9b5cd50fb6eed119d20005056be7e8d"
  "/navigation/1b17200dfd6eed119d20005056be7e8d"
  "/navigation/a8f60be80695ee119d28005056be7e8d"
  "/navigation/7caca7010795ee119d28005056be7e8d"
  "/navigation/406f5a080795ee119d28005056be7e8d"
  "/navigation/1c17200dfd6eed119d20005056be7e8d"
  "/navigation/c9eba6a7186fed119d20005056be7e8d"
  "/navigation/caeba6a7186fed119d20005056be7e8d"
  "/navigation/cbeba6a7186fed119d20005056be7e8d"
  "/navigation/cceba6a7186fed119d20005056be7e8d"
  "/navigation/cdeba6a7186fed119d20005056be7e8d"
  "/navigation/ceeba6a7186fed119d20005056be7e8d"
  "/navigation/cfeba6a7186fed119d20005056be7e8d"
  "/navigation/741dedad186fed119d20005056be7e8d"
  "/navigation/751dedad186fed119d20005056be7e8d"
  "/navigation/761dedad186fed119d20005056be7e8d"
  "/navigation/c3a05050b47bed119d24005056be7e8d"
  "/navigation/771dedad186fed119d20005056be7e8d"
  "/navigation/781dedad186fed119d20005056be7e8d"
  "/navigation/791dedad186fed119d20005056be7e8d"
  "/navigation/8893a8c1c67fed119d24005056be7e8d"
  "/navigation/27a6c5831281ed119d24005056be7e8d"
  "/navigation/16cd583107f8ee119d28005056be7e8d"
  "/navigation/2b68cb260795ee119d28005056be7e8d"
  "/navigation/d34a5a310795ee119d28005056be7e8d"
  "/navigation/d54a5a310795ee119d28005056be7e8d"
  "/navigation/fb923c390795ee119d28005056be7e8d"
  "/navigation/5602865e0795ee119d28005056be7e8d"
  "/navigation/5702865e0795ee119d28005056be7e8d"
  "/navigation/3c1746660795ee119d28005056be7e8d"
  "/navigation/fe4c6b730795ee119d28005056be7e8d"
  "/navigation/3623dc970795ee119d28005056be7e8d"
  "/navigation/0b7829a00795ee119d28005056be7e8d"
  "/navigation/3f1badae0795ee119d28005056be7e8d"
  "/navigation/401badae0795ee119d28005056be7e8d"
  "/navigation/0d0c8d0c196fed119d20005056be7e8d"
  "/navigation/0e0c8d0c196fed119d20005056be7e8d"
  "/navigation/0f0c8d0c196fed119d20005056be7e8d"
  "/navigation/100c8d0c196fed119d20005056be7e8d"
  "/navigation/110c8d0c196fed119d20005056be7e8d"
  "/navigation/120c8d0c196fed119d20005056be7e8d"
  "/navigation/4fdd3c212481ed119d24005056be7e8d"
  "/navigation/50dd3c212481ed119d24005056be7e8d"
  "/navigation/c186da502481ed119d24005056be7e8d"
  "/navigation/635f9d49bf6fed119d20005056be7e8d"
  "/navigation/782fb670bf6fed119d20005056be7e8d"
  "/navigation/792fb670bf6fed119d20005056be7e8d"
  "/navigation/7a2fb670bf6fed119d20005056be7e8d"
  "/navigation/7b2fb670bf6fed119d20005056be7e8d"
  "/navigation/2ac2c568c26fed119d20005056be7e8d"
  "/navigation/2bc2c568c26fed119d20005056be7e8d"
  "/navigation/b644fcc05b87ed119d24005056be7e8d"
  "/navigation/2cc2c568c26fed119d20005056be7e8d"
  "/navigation/f1c0b47fc26fed119d20005056be7e8d"
  "/navigation/f2c0b47fc26fed119d20005056be7e8d"
  "/navigation/fd0c897bc17fed119d24005056be7e8d"
  "/navigation/b17df227c36fed119d20005056be7e8d"
  "/navigation/b27df227c36fed119d20005056be7e8d"
  "/navigation/b37df227c36fed119d20005056be7e8d"
  "/navigation/b47df227c36fed119d20005056be7e8d"
  "/navigation/b57df227c36fed119d20005056be7e8d"
  "/navigation/ab9a9c1fb47bed119d24005056be7e8d"
  "/navigation/a72aa142aa80ed119d24005056be7e8d"
  "/navigation/bbefdb54c36fed119d20005056be7e8d"
  "/navigation/bcefdb54c36fed119d20005056be7e8d"
  "/navigation/aa87188f1281ed119d24005056be7e8d"
  "/navigation/2d660fa90895ee119d28005056be7e8d"
  "/navigation/3b4413af0895ee119d28005056be7e8d"
  "/navigation/3c4413af0895ee119d28005056be7e8d"
  "/navigation/530d48b60895ee119d28005056be7e8d"
  "/navigation/b7a01dbd0895ee119d28005056be7e8d"
  "/navigation/14536dc40895ee119d28005056be7e8d"
  "/navigation/15536dc40895ee119d28005056be7e8d"
  "/navigation/c050e0cf0895ee119d28005056be7e8d"
  "/navigation/3fa6f5e70895ee119d28005056be7e8d"
  "/navigation/42a6523d0995ee119d28005056be7e8d"
  "/navigation/565374460995ee119d28005056be7e8d"
  "/navigation/575374460995ee119d28005056be7e8d"
  "/navigation/585374460995ee119d28005056be7e8d"
  "/navigation/595374460995ee119d28005056be7e8d"
  "/navigation/52bc764d0995ee119d28005056be7e8d"
  "/navigation/53bc764d0995ee119d28005056be7e8d"
  "/navigation/bfaeae790995ee119d28005056be7e8d"
  "/navigation/c0aeae790995ee119d28005056be7e8d"
  "/navigation/c1aeae790995ee119d28005056be7e8d"
  "/navigation/d2309c800995ee119d28005056be7e8d"
  "/navigation/d3309c800995ee119d28005056be7e8d"
  "/navigation/d4309c800995ee119d28005056be7e8d"
  "/navigation/d5309c800995ee119d28005056be7e8d"
  "/navigation/9cd520870995ee119d28005056be7e8d"
  "/navigation/9dd520870995ee119d28005056be7e8d"
  "/navigation/9ed520870995ee119d28005056be7e8d"
  "/navigation/a0d520870995ee119d28005056be7e8d"
  "/navigation/ad45b48d0995ee119d28005056be7e8d"
  "/navigation/ae45b48d0995ee119d28005056be7e8d"
  "/navigation/b045b48d0995ee119d28005056be7e8d"
  "/navigation/a500dfd50995ee119d28005056be7e8d"
  "/navigation/a600dfd50995ee119d28005056be7e8d"
  "/navigation/a700dfd50995ee119d28005056be7e8d"
  "/navigation/a900dfd50995ee119d28005056be7e8d"
  "/navigation/89ead9e80995ee119d28005056be7e8d"
  "/navigation/a76a896dc36fed119d20005056be7e8d"
  "/navigation/89cb145f2481ed119d24005056be7e8d"
  "/navigation/cca702672481ed119d24005056be7e8d"
  "/navigation/cda702672481ed119d24005056be7e8d"
  "/navigation/5a044e712481ed119d24005056be7e8d"
  "/navigation/a9f3457d2481ed119d24005056be7e8d"
  "/navigation/53c053804081ed119d24005056be7e8d"
  "/navigation/c23b848c4081ed119d24005056be7e8d"
  "/navigation/56405c9b4081ed119d24005056be7e8d"
  "/navigation/565f2be22481ed119d24005056be7e8d"
  "/navigation/b1c83fe92481ed119d24005056be7e8d"
  "/navigation/b2c83fe92481ed119d24005056be7e8d"
  "/navigation/7b9810e6cd6fed119d20005056be7e8d"
  "/navigation/47aa4619aa80ed119d24005056be7e8d"
  "/navigation/8e400e22aa80ed119d24005056be7e8d"
  "/navigation/8f400e22aa80ed119d24005056be7e8d"
  "/navigation/a6d6b6fd0895ee119d28005056be7e8d"
  "/navigation/57885e57fb6eed119d20005056be7e8d"
  "/navigation/e6e32828fd6eed119d20005056be7e8d"
  "/navigation/e7e32828fd6eed119d20005056be7e8d"
  "/navigation/e8e32828fd6eed119d20005056be7e8d"
  "/navigation/e9e32828fd6eed119d20005056be7e8d"
  "/navigation/d0136569d36fed119d20005056be7e8d"
  "/navigation/eae32828fd6eed119d20005056be7e8d"
  "/navigation/ebe32828fd6eed119d20005056be7e8d"
  "/navigation/ece32828fd6eed119d20005056be7e8d"
  "/navigation/ede32828fd6eed119d20005056be7e8d"
  "/navigation/eee32828fd6eed119d20005056be7e8d"
  "/navigation/f0bdd7491b6fed119d20005056be7e8d"
  "/navigation/f1bdd7491b6fed119d20005056be7e8d"
  "/navigation/f2bdd7491b6fed119d20005056be7e8d"
  "/navigation/f3bdd7491b6fed119d20005056be7e8d"
  "/navigation/9803afa81b6fed119d20005056be7e8d"
  "/navigation/9903afa81b6fed119d20005056be7e8d"
  "/navigation/9a03afa81b6fed119d20005056be7e8d"
  "/navigation/94dc56ec1b6fed119d20005056be7e8d"
  "/navigation/95dc56ec1b6fed119d20005056be7e8d"
  "/navigation/96dc56ec1b6fed119d20005056be7e8d"
  "/navigation/f703ef2f1c6fed119d20005056be7e8d"
  "/navigation/f803ef2f1c6fed119d20005056be7e8d"
  "/navigation/f903ef2f1c6fed119d20005056be7e8d"
  "/navigation/72867d7cc46fed119d20005056be7e8d"
  "/navigation/df09cb4c1c6fed119d20005056be7e8d"
  "/navigation/e009cb4c1c6fed119d20005056be7e8d"
  "/navigation/668ea381009bed119d24005056be7e8d"
  "/navigation/ee3aade4269bed119d24005056be7e8d"
  "/navigation/e5d723ad1d6fed119d20005056be7e8d"
  "/navigation/e6d723ad1d6fed119d20005056be7e8d"
  "/navigation/e7d723ad1d6fed119d20005056be7e8d"
  "/navigation/e4dc49ca1d6fed119d20005056be7e8d"
  "/navigation/e5dc49ca1d6fed119d20005056be7e8d"
  "/navigation/395ce98ec46fed119d20005056be7e8d"
  "/navigation/e6dc49ca1d6fed119d20005056be7e8d"
  "/navigation/e7dc49ca1d6fed119d20005056be7e8d"
  "/navigation/e8dc49ca1d6fed119d20005056be7e8d"
  "/navigation/d1a1bda05196ed119d24005056be7e8d"
  "/navigation/c1fea0a85196ed119d24005056be7e8d"
  "/navigation/c2fea0a85196ed119d24005056be7e8d"
  "/navigation/9d104541c69bed119d24005056be7e8d"
  "/navigation/ea67530e0a95ee119d28005056be7e8d"
  "/navigation/61ef6484c36fed119d20005056be7e8d"
  "/navigation/62ef6484c36fed119d20005056be7e8d"
  "/navigation/f282b54e1298ed119d24005056be7e8d"
  "/navigation/e65271a0c36fed119d20005056be7e8d"
  "/navigation/e75271a0c36fed119d20005056be7e8d"
  "/navigation/e85271a0c36fed119d20005056be7e8d"
  "/navigation/2bb9aaa7c36fed119d20005056be7e8d"
  "/navigation/74faa6c8c36fed119d20005056be7e8d"
  "/navigation/75faa6c8c36fed119d20005056be7e8d"
  "/navigation/f7699edec36fed119d20005056be7e8d"
  "/navigation/f8699edec36fed119d20005056be7e8d"
  "/navigation/d02bd6f0c36fed119d20005056be7e8d"
  "/navigation/d12bd6f0c36fed119d20005056be7e8d"
  "/navigation/d22bd6f0c36fed119d20005056be7e8d"
  "/navigation/d32bd6f0c36fed119d20005056be7e8d"
  "/navigation/54961521c46fed119d20005056be7e8d"
  "/navigation/4e73ee31c46fed119d20005056be7e8d"
  "/navigation/4f73ee31c46fed119d20005056be7e8d"
  "/navigation/5073ee31c46fed119d20005056be7e8d"
  "/navigation/5173ee31c46fed119d20005056be7e8d"
  "/navigation/5273ee31c46fed119d20005056be7e8d"
  "/navigation/5373ee31c46fed119d20005056be7e8d"
  "/navigation/5473ee31c46fed119d20005056be7e8d"
  "/navigation/a033ad38c46fed119d20005056be7e8d"
  "/navigation/4533c191c39bed119d24005056be7e8d"
  "/navigation/1b828263c46fed119d20005056be7e8d"
  "/navigation/1c828263c46fed119d20005056be7e8d"
  "/navigation/71867d7cc46fed119d20005056be7e8d"
  "/navigation/385ce98ec46fed119d20005056be7e8d"
  "/navigation/c96573a1c46fed119d20005056be7e8d"
  "/navigation/de7f7b20d46fed119d20005056be7e8d"
  "/navigation/6072880b4f96ed119d24005056be7e8d"
  "/navigation/0e8d82164f96ed119d24005056be7e8d"
  "/navigation/0f8d82164f96ed119d24005056be7e8d"
  "/navigation/3eca7667189bed119d24005056be7e8d"
  "/navigation/d07d2c1f4f96ed119d24005056be7e8d"
  "/navigation/f6c2bd264f96ed119d24005056be7e8d"
  "/navigation/e687ae540f95ee119d28005056be7e8d"
  "/navigation/f7c2bd264f96ed119d24005056be7e8d"
  "/navigation/cc22e22f4f96ed119d24005056be7e8d"
  "/navigation/eda7355d0f95ee119d28005056be7e8d"
  "/navigation/f042f2cb2b9bed119d24005056be7e8d"
  "/navigation/c997d9ef8ea6ef119d2d005056be7e8d"
  "/navigation/a0d33c69e68ced119d24005056be7e8d"
  "/navigation/f54907b2c46fed119d20005056be7e8d"
  "/navigation/f44907b2c46fed119d20005056be7e8d"
  "/navigation/f64907b2c46fed119d20005056be7e8d"
  "/navigation/f74907b2c46fed119d20005056be7e8d"
  "/navigation/cb323ab8c46fed119d20005056be7e8d"
  "/navigation/f34907b2c46fed119d20005056be7e8d"
  "/navigation/f84907b2c46fed119d20005056be7e8d"
  "/navigation/65261238c56fed119d20005056be7e8d"
  "/navigation/66261238c56fed119d20005056be7e8d"
  "/navigation/f1a448aac56fed119d20005056be7e8d"
  "/navigation/d0a1bda05196ed119d24005056be7e8d"
  "/navigation/d81d287d5196ed119d24005056be7e8d"
  "/navigation/d91d287d5196ed119d24005056be7e8d"
  "/navigation/db4092885196ed119d24005056be7e8d"
  "/navigation/e2ff834ed46fed119d20005056be7e8d"
  "/navigation/e3ff834ed46fed119d20005056be7e8d"
  "/navigation/b8ae2280c29bed119d24005056be7e8d"
  "/navigation/e45148347596ed119d24005056be7e8d"
  "/navigation/0091e3585196ed119d24005056be7e8d"
  "/navigation/b28b40d7c56fed119d20005056be7e8d"
  "/navigation/b38b40d7c56fed119d20005056be7e8d"
  "/navigation/6676ea75a68ded119d24005056be7e8d"
  "/navigation/b48b40d7c56fed119d20005056be7e8d"
  "/navigation/3c41fb4cce6fed119d20005056be7e8d"
  "/navigation/3d41fb4cce6fed119d20005056be7e8d"
  "/navigation/3e41fb4cce6fed119d20005056be7e8d"
  "/navigation/a51ca30f7b7ced119d24005056be7e8d"
  "/navigation/f4cffd56ce6fed119d20005056be7e8d"
  "/navigation/f5cffd56ce6fed119d20005056be7e8d"
  "/navigation/f6cffd56ce6fed119d20005056be7e8d"
  "/navigation/f7cffd56ce6fed119d20005056be7e8d"
  "/navigation/60508689a592ee119d28005056be7e8d"
  "/navigation/db9fc65dce6fed119d20005056be7e8d"
  "/navigation/dc9fc65dce6fed119d20005056be7e8d"
  "/navigation/dd9fc65dce6fed119d20005056be7e8d"
  "/navigation/de9fc65dce6fed119d20005056be7e8d"
  "/navigation/fb4bf91c1495ee119d28005056be7e8d"
  "/navigation/151f4664ce6fed119d20005056be7e8d"
  "/navigation/9a920aa7ce6fed119d20005056be7e8d"
  "/navigation/9b920aa7ce6fed119d20005056be7e8d"
  "/navigation/9c920aa7ce6fed119d20005056be7e8d"
  "/navigation/9d920aa7ce6fed119d20005056be7e8d"
  "/navigation/bf70be207387ed119d24005056be7e8d"
  "/navigation/49eccd588b7ced119d24005056be7e8d"
  "/navigation/351fb9648b7ced119d24005056be7e8d"
  "/navigation/f6c3cf6d8b7ced119d24005056be7e8d"
  "/navigation/56b7a8fdce6fed119d20005056be7e8d"
  "/navigation/57b7a8fdce6fed119d20005056be7e8d"
  "/navigation/58b7a8fdce6fed119d20005056be7e8d"
  "/navigation/59b7a8fdce6fed119d20005056be7e8d"
  "/navigation/5ab7a8fdce6fed119d20005056be7e8d"
  "/navigation/e198e903cf6fed119d20005056be7e8d"
  "/navigation/e298e903cf6fed119d20005056be7e8d"
  "/navigation/d4092c37cf6fed119d20005056be7e8d"
  "/navigation/f9a662ebfe9aed119d24005056be7e8d"
  "/navigation/e2993db40a9bed119d24005056be7e8d"
  "/navigation/f0e02ed8cf6fed119d20005056be7e8d"
  "/navigation/f1e02ed8cf6fed119d20005056be7e8d"
  "/navigation/f2e02ed8cf6fed119d20005056be7e8d"
  "/navigation/f3e02ed8cf6fed119d20005056be7e8d"
  "/navigation/f4e02ed8cf6fed119d20005056be7e8d"
  "/navigation/941ba0721d7ded119d24005056be7e8d"
  "/navigation/206b56f7cf6fed119d20005056be7e8d"
  "/navigation/216b56f7cf6fed119d20005056be7e8d"
  "/navigation/764e9221d06fed119d20005056be7e8d"
  "/navigation/774e9221d06fed119d20005056be7e8d"
  "/navigation/784e9221d06fed119d20005056be7e8d"
  "/navigation/794e9221d06fed119d20005056be7e8d"
  "/navigation/7a4e9221d06fed119d20005056be7e8d"
  "/navigation/58092683d06fed119d20005056be7e8d"
  "/navigation/59092683d06fed119d20005056be7e8d"
  "/navigation/5a092683d06fed119d20005056be7e8d"
  "/navigation/5b092683d06fed119d20005056be7e8d"
  "/navigation/e5f3c9b2d06fed119d20005056be7e8d"
  "/navigation/e7cbbff8d06fed119d20005056be7e8d"
  "/navigation/e8cbbff8d06fed119d20005056be7e8d"
  "/navigation/e9cbbff8d06fed119d20005056be7e8d"
  "/navigation/eacbbff8d06fed119d20005056be7e8d"
  "/navigation/b5ca2effd06fed119d20005056be7e8d"
  "/navigation/b6ca2effd06fed119d20005056be7e8d"
  "/navigation/b7ca2effd06fed119d20005056be7e8d"
  "/navigation/b8ca2effd06fed119d20005056be7e8d"
  "/navigation/cc5ad805d16fed119d20005056be7e8d"
  "/navigation/ab89623dae8ded119d24005056be7e8d"
  "/navigation/cd5ad805d16fed119d20005056be7e8d"
  "/navigation/ce5ad805d16fed119d20005056be7e8d"
  "/navigation/e942d813d26fed119d20005056be7e8d"
  "/navigation/ea42d813d26fed119d20005056be7e8d"
  "/navigation/eb42d813d26fed119d20005056be7e8d"
  "/navigation/ec42d813d26fed119d20005056be7e8d"
  "/navigation/ed42d813d26fed119d20005056be7e8d"
  "/navigation/1442421ad26fed119d20005056be7e8d"
  "/navigation/1542421ad26fed119d20005056be7e8d"
  "/navigation/1642421ad26fed119d20005056be7e8d"
  "/navigation/1742421ad26fed119d20005056be7e8d"
  "/navigation/59af84f8ab8ded119d24005056be7e8d"
  "/navigation/65cd1629d36fed119d20005056be7e8d"
  "/navigation/66cd1629d36fed119d20005056be7e8d"
  "/navigation/97e4a162d36fed119d20005056be7e8d"
  "/navigation/98e4a162d36fed119d20005056be7e8d"
  "/navigation/99e4a162d36fed119d20005056be7e8d"
  "/navigation/8825726f0a95ee119d28005056be7e8d"
  "/navigation/9ae4a162d36fed119d20005056be7e8d"
  "/navigation/9be4a162d36fed119d20005056be7e8d"
  "/navigation/ce136569d36fed119d20005056be7e8d"
  "/navigation/cf136569d36fed119d20005056be7e8d"
  "/navigation/d1136569d36fed119d20005056be7e8d"
  "/navigation/837db9e7d36fed119d20005056be7e8d"
  "/navigation/847db9e7d36fed119d20005056be7e8d"
  "/navigation/857db9e7d36fed119d20005056be7e8d"
  "/navigation/8b5c0c0ad46fed119d20005056be7e8d"
  "/navigation/8c5c0c0ad46fed119d20005056be7e8d"
  "/navigation/8d5c0c0ad46fed119d20005056be7e8d"
  "/navigation/80f1393a4d96ed119d24005056be7e8d"
  "/navigation/1577c6961395ee119d28005056be7e8d"
  "/navigation/43553f34d46fed119d20005056be7e8d"
  "/navigation/44553f34d46fed119d20005056be7e8d"
  "/navigation/d00afdb31395ee119d28005056be7e8d"
  "/navigation/db18586ad46fed119d20005056be7e8d"
  "/navigation/bfa0a9874d96ed119d24005056be7e8d"
  "/navigation/7492b8cc1395ee119d28005056be7e8d"
  "/navigation/a9e9177ed46fed119d20005056be7e8d"
  "/navigation/aae9177ed46fed119d20005056be7e8d"
  "/navigation/ace9177ed46fed119d20005056be7e8d"
  "/navigation/938b559c1e97ed119d24005056be7e8d"
  "/navigation/3266baa7089cef119d2d005056be7e8d"
  "/navigation/afe9177ed46fed119d20005056be7e8d"
  "/navigation/b0e9177ed46fed119d20005056be7e8d"
  "/navigation/4195b184d46fed119d20005056be7e8d"
  "/navigation/4295b184d46fed119d20005056be7e8d"
  "/navigation/4395b184d46fed119d20005056be7e8d"
  "/navigation/4695b184d46fed119d20005056be7e8d"
  "/navigation/4795b184d46fed119d20005056be7e8d"
  "/navigation/cb864ac9d46fed119d20005056be7e8d"
  "/navigation/a915bb841598ed119d24005056be7e8d"
  "/navigation/6da80670fb6eed119d20005056be7e8d"
  "/navigation/3ebe2e4cf07aed119d24005056be7e8d"
  "/navigation/ba748253f07aed119d24005056be7e8d"
  "/navigation/bb748253f07aed119d24005056be7e8d"
  "/navigation/614307b0c9d14dd8b63f725ca237a0e8"
  "/navigation/b134d83a1e564eef9a85c36195622a20"
  "/navigation/6e5ebec3707d44b8b33ef769a6863ae5"
  "/navigation/027e1f8c58dc4ada93f834b00d9d7078"
  "/navigation/5b06fa95971b489fb7956399a6c15d4e"
  "/navigation/2b0ba86c99784d4382270025710b82fe"
  "/navigation/5cae956e56674553aa083e011320f9fb"
  "/navigation/057e02a1f3424433b4a60f88cbb13275"
  "/navigation/6a072c68d9ac4782b855cf6a1df48d0f"
  "/navigation/2ae58c2d4bd34730a7a142634c17c34c"
  "/navigation/506ba0cc76af481498d189baf06fac01"
  "/navigation/a6ab607b47a54b95a0a35c77b7ba2d95"
  "/navigation/7da3247b54984de782dd937bcdfa7615"
  "/navigation/a1e2ac347b2643fbb4962c99196707d6"
  "/navigation/0a8ab5e32e2f454bb49dc8bd8001ec69"
  "/navigation/06d31bddb456479c80f25a44f111cfbd"
  "/navigation/13661320ed2d4f34ad519cf5b384cfba"
  "/navigation/fad7011afb1a4b6490f7fbb4a3830fa1"
  "/navigation/e577aa507c24479c8d9ef0abba9c841e"
  "/navigation/b1c71617ced545fe8f6d883f2d55cd18"
  "/navigation/a4f165eae443466ca73cfec4e4e85fa7"
  "/detail/830e076ce117ed119d1b005056be7e8d"
  "/detail/c04abd57de24ec119d1a005056be7e8d"
  "/detail/35e6f2f7b169ed119d20005056be7e8d"
  "/detail/bf6fb463de24ec119d1a005056be7e8d"
  "/detail/22d101ecb169ed119d20005056be7e8d"
  "/detail/711bbd5dde24ec119d1a005056be7e8d"
  "/detail/284bbd57de24ec119d1a005056be7e8d"
  "/detail/ff60c051de24ec119d1a005056be7e8d"
  "/detail/799b92b5b069ed119d20005056be7e8d"
  "/navigation/0dbb26835d034fcbb7c7f9c642752949"
  "/navigation/a4f93339442d4e9a86517e2d2807e304"
  "/navigation/29a6f74a10d346dabe0d8742b77f92c9"
  "/navigation/d4b2de185ea94555870b1d9405dca1b1"
  "/navigation/c44394e89aa94d2a85c3284a68f35427"
  "/navigation/e46a6f8bf46044e98fd09c34c6db6586"
  "/navigation/f7d07ea9aafb47b3972723219c10ca20"
  "/navigation/953e522e0dbe40f394eaa6ae3114b7b8"
  "/navigation/c913cda3e0f34252a80fc16fe286f0ea"
  "/navigation/2f4fd0256697493295df0b3898f0d87c"
  "/navigation/c20463fe1c194e1e91b1f50f2db66dc7"
  "/navigation/05a2b278f32e4b9fba83f4f1ddffd777"
  "/navigation/2546901e09cd450db93ac900bdb1522b"
  "/navigation/abb265f50b24480ca9d2b06b4cdc5b39"
  "/navigation/82bbe1f983394b79a09a5e08cb2db2dc"
  "/navigation/d285c73d55b34528851b31896901f495"
  "/navigation/c24ffe78ce2842eb833e9bacd8859024"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"äN15ºÖLý»&’ÄA7±ø"
]
15.04 ms
(16.18%)
2
# header::navigation::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, COALESCE(`category.media.translation.title`,`category.media.translation.title`) as `category.media.title`, `category.media.translation.alt`, COALESCE(`category.media.translation.alt`,`category.media.translation.alt`) as `category.media.alt`, `category.media.translation.customFields`, COALESCE(`category.media.translation.customFields`,`category.media.translation.customFields`) as `category.media.customFields`, `category.media.translation.createdAt`, `category.media.translation.updatedAt`, `category.media.translation.mediaId`, `category.media.translation.languageId`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.link_type as `category.translation.linkType`, `category.translation`.internal_link as `category.translation.internalLink`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.link_new_tab as `category.translation.linkNewTab`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title as `category.media.translation.title`, `category.media.translation`.alt as `category.media.translation.alt`, `category.media.translation`.custom_fields as `category.media.translation.customFields`, `category.media.translation`.created_at as `category.media.translation.createdAt`, `category.media.translation`.updated_at as `category.media.translation.updatedAt`, `category.media.translation`.media_id as `category.media.translation.mediaId`, `category.media.translation`.language_id as `category.media.translation.languageId` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.language_id = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND ((`category`.`path` LIKE ? AND (`category`.`level` > ? AND `category`.`level` <= ?)))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  "%|31a9e44cb1454ee894c2efc5eba84167|%"
  1
  7
]
6.36 ms
(6.84%)
2
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product.parent`.`cheapest_price` as `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, COALESCE(`product`.`swag_customized_products_template_id`, `product.parent`.`swag_customized_products_template_id`) as `product.swagCustomizedProductsTemplateId`, COALESCE(`product`.`swag_customized_products_template_version_id`, `product.parent`.`swag_customized_products_template_version_id`) as `product.swagCustomizedProductsTemplateVersionId`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_option` `product.options.mapping`
                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, `product.unit`.`id` as `product.unit.id`, `product.unit`.`created_at` as `product.unit.createdAt`, `product.unit`.`updated_at` as `product.unit.updatedAt`, `product.unit.translation.shortCode`, COALESCE(`product.unit.translation.shortCode`,`product.unit.translation.shortCode`) as `product.unit.shortCode`, `product.unit.translation.name`, COALESCE(`product.unit.translation.name`,`product.unit.translation.name`) as `product.unit.name`, `product.unit.translation.customFields`, COALESCE(`product.unit.translation.customFields`,`product.unit.translation.customFields`) as `product.unit.customFields`, `product.unit.translation.createdAt`, `product.unit.translation.updatedAt`, `product.unit.translation.unitId`, `product.unit.translation.languageId`, `product.deliveryTime`.`id` as `product.deliveryTime.id`, `product.deliveryTime`.`min` as `product.deliveryTime.min`, `product.deliveryTime`.`max` as `product.deliveryTime.max`, `product.deliveryTime`.`unit` as `product.deliveryTime.unit`, `product.deliveryTime`.`created_at` as `product.deliveryTime.createdAt`, `product.deliveryTime`.`updated_at` as `product.deliveryTime.updatedAt`, `product.deliveryTime.translation.name`, COALESCE(`product.deliveryTime.translation.name`,`product.deliveryTime.translation.name`) as `product.deliveryTime.name`, `product.deliveryTime.translation.customFields`, COALESCE(`product.deliveryTime.translation.customFields`,`product.deliveryTime.translation.customFields`) as `product.deliveryTime.customFields`, `product.deliveryTime.translation.createdAt`, `product.deliveryTime.translation.updatedAt`, `product.deliveryTime.translation.deliveryTimeId`, `product.deliveryTime.translation.languageId`, `product.cover`.`id` as `product.cover.id`, `product.cover`.`version_id` as `product.cover.versionId`, `product.cover`.`product_id` as `product.cover.productId`, `product.cover`.`product_version_id` as `product.cover.productVersionId`, `product.cover`.`media_id` as `product.cover.mediaId`, `product.cover`.`position` as `product.cover.position`, `product.cover.media`.`id` as `product.cover.media.id`, `product.cover.media`.`user_id` as `product.cover.media.userId`, `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` as `product.cover.media.fileName`, `product.cover.media`.`file_size` as `product.cover.media.fileSize`, `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` as `product.cover.media.metaData`, `product.cover.media`.`config` as `product.cover.media.config`, `product.cover.media`.`path` as `product.cover.media.path`, `product.cover.media`.`private` as `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, `product.cover.media`.`created_at` as `product.cover.media.createdAt`, `product.cover.media`.`updated_at` as `product.cover.media.updatedAt`, `product.cover.media.translation.title`, COALESCE(`product.cover.media.translation.title`,`product.cover.media.translation.title`) as `product.cover.media.title`, `product.cover.media.translation.alt`, COALESCE(`product.cover.media.translation.alt`,`product.cover.media.translation.alt`) as `product.cover.media.alt`, `product.cover.media.translation.customFields`, COALESCE(`product.cover.media.translation.customFields`,`product.cover.media.translation.customFields`) as `product.cover.media.customFields`, `product.cover.media.translation.createdAt`, `product.cover.media.translation.updatedAt`, `product.cover.media.translation.mediaId`, `product.cover.media.translation.languageId`, `product.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, `product.swagCustomizedProductsTemplate`.`id` as `product.swagCustomizedProductsTemplate.id`, `product.swagCustomizedProductsTemplate`.`version_id` as `product.swagCustomizedProductsTemplate.versionId`, `product.swagCustomizedProductsTemplate`.`parent_version_id` as `product.swagCustomizedProductsTemplate.parentVersionId`, `product.swagCustomizedProductsTemplate`.`internal_name` as `product.swagCustomizedProductsTemplate.internalName`, `product.swagCustomizedProductsTemplate`.`active` as `product.swagCustomizedProductsTemplate.active`, `product.swagCustomizedProductsTemplate`.`step_by_step` as `product.swagCustomizedProductsTemplate.stepByStep`, `product.swagCustomizedProductsTemplate`.`confirm_input` as `product.swagCustomizedProductsTemplate.confirmInput`, `product.swagCustomizedProductsTemplate`.`options_auto_collapse` as `product.swagCustomizedProductsTemplate.optionsAutoCollapse`, `product.swagCustomizedProductsTemplate`.`decision_tree` as `product.swagCustomizedProductsTemplate.decisionTree`, `product.swagCustomizedProductsTemplate`.`media_id` as `product.swagCustomizedProductsTemplate.mediaId`, `product.swagCustomizedProductsTemplate`.`created_at` as `product.swagCustomizedProductsTemplate.createdAt`, `product.swagCustomizedProductsTemplate`.`updated_at` as `product.swagCustomizedProductsTemplate.updatedAt`, `product.swagCustomizedProductsTemplate.translation.displayName`, COALESCE(`product.swagCustomizedProductsTemplate.translation.displayName`,`product.swagCustomizedProductsTemplate.translation.displayName`) as `product.swagCustomizedProductsTemplate.displayName`, `product.swagCustomizedProductsTemplate.translation.description`, COALESCE(`product.swagCustomizedProductsTemplate.translation.description`,`product.swagCustomizedProductsTemplate.translation.description`) as `product.swagCustomizedProductsTemplate.description`, `product.swagCustomizedProductsTemplate.translation.createdAt`, `product.swagCustomizedProductsTemplate.translation.updatedAt`, `product.swagCustomizedProductsTemplate.translation.swagCustomizedProductsTemplateId`, `product.swagCustomizedProductsTemplate.translation.languageId`, `product.swagCustomizedProductsTemplate.translation.swagCustomizedProductsTemplateVersionId`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`,`product.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`,`product.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`,`product.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`,`product.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`,`product.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`,`product.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`,`product.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`,`product.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`,`product.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`,`product.translation.customFields`) as `product.customFields`, `product.translation.createdAt`, `product.parent.translation.createdAt`, `product.translation.updatedAt`, `product.parent.translation.updatedAt`, `product.translation.productId`, `product.parent.translation.productId`, `product.translation.languageId`, `product.parent.translation.languageId`, `product.translation.productVersionId`, `product.parent.translation.productVersionId` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.product_id, `product.translation`.product_version_id, `product.translation`.meta_description as `product.translation.metaDescription`, `product.translation`.name as `product.translation.name`, `product.translation`.keywords as `product.translation.keywords`, `product.translation`.description as `product.translation.description`, `product.translation`.meta_title as `product.translation.metaTitle`, `product.translation`.pack_unit as `product.translation.packUnit`, `product.translation`.pack_unit_plural as `product.translation.packUnitPlural`, `product.translation`.custom_search_keywords as `product.translation.customSearchKeywords`, `product.translation`.slot_config as `product.translation.slotConfig`, `product.translation`.custom_fields as `product.translation.customFields`, `product.translation`.created_at as `product.translation.createdAt`, `product.translation`.updated_at as `product.translation.updatedAt`, `product.translation`.product_id as `product.translation.productId`, `product.translation`.language_id as `product.translation.languageId`, `product.translation`.product_version_id as `product.translation.productVersionId` FROM `product_translation` `product.translation` WHERE `product.translation`.language_id = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.product_version_id = `product`.version_id LEFT JOIN (SELECT `product.parent.translation`.product_id, `product.parent.translation`.product_version_id, `product.parent.translation`.meta_description as `product.parent.translation.metaDescription`, `product.parent.translation`.name as `product.parent.translation.name`, `product.parent.translation`.keywords as `product.parent.translation.keywords`, `product.parent.translation`.description as `product.parent.translation.description`, `product.parent.translation`.meta_title as `product.parent.translation.metaTitle`, `product.parent.translation`.pack_unit as `product.parent.translation.packUnit`, `product.parent.translation`.pack_unit_plural as `product.parent.translation.packUnitPlural`, `product.parent.translation`.custom_search_keywords as `product.parent.translation.customSearchKeywords`, `product.parent.translation`.slot_config as `product.parent.translation.slotConfig`, `product.parent.translation`.custom_fields as `product.parent.translation.customFields`, `product.parent.translation`.created_at as `product.parent.translation.createdAt`, `product.parent.translation`.updated_at as `product.parent.translation.updatedAt`, `product.parent.translation`.product_id as `product.parent.translation.productId`, `product.parent.translation`.language_id as `product.parent.translation.languageId`, `product.parent.translation`.product_version_id as `product.parent.translation.productVersionId` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.language_id = ?) `product.product_translation.parent` ON `product.product_translation.parent`.`product_id` = `product.parent`.`id` AND `product.product_translation.parent`.product_version_id = `product.parent`.version_id LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `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 `swag_customized_products_template` `product.swagCustomizedProductsTemplate` ON `product`.`swagCustomizedProductsTemplate` = `product.swagCustomizedProductsTemplate`.`id` AND IFNULL(`product`.`swag_customized_products_template_version_id`, `product.parent`.`swag_customized_products_template_version_id`) = `product.swagCustomizedProductsTemplate`.`version_id` LEFT JOIN (SELECT `product.unit.translation`.unit_id, `product.unit.translation`.short_code as `product.unit.translation.shortCode`, `product.unit.translation`.name as `product.unit.translation.name`, `product.unit.translation`.custom_fields as `product.unit.translation.customFields`, `product.unit.translation`.created_at as `product.unit.translation.createdAt`, `product.unit.translation`.updated_at as `product.unit.translation.updatedAt`, `product.unit.translation`.unit_id as `product.unit.translation.unitId`, `product.unit.translation`.language_id as `product.unit.translation.languageId` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation`.language_id = ?) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id` LEFT JOIN (SELECT `product.deliveryTime.translation`.delivery_time_id, `product.deliveryTime.translation`.name as `product.deliveryTime.translation.name`, `product.deliveryTime.translation`.custom_fields as `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation`.created_at as `product.deliveryTime.translation.createdAt`, `product.deliveryTime.translation`.updated_at as `product.deliveryTime.translation.updatedAt`, `product.deliveryTime.translation`.delivery_time_id as `product.deliveryTime.translation.deliveryTimeId`, `product.deliveryTime.translation`.language_id as `product.deliveryTime.translation.languageId` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation`.language_id = ?) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id` LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.cover.media.translation`.media_id, `product.cover.media.translation`.title as `product.cover.media.translation.title`, `product.cover.media.translation`.alt as `product.cover.media.translation.alt`, `product.cover.media.translation`.custom_fields as `product.cover.media.translation.customFields`, `product.cover.media.translation`.created_at as `product.cover.media.translation.createdAt`, `product.cover.media.translation`.updated_at as `product.cover.media.translation.updatedAt`, `product.cover.media.translation`.media_id as `product.cover.media.translation.mediaId`, `product.cover.media.translation`.language_id as `product.cover.media.translation.languageId` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation`.language_id = ?) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.swagCustomizedProductsTemplate.translation`.swag_customized_products_template_id, `product.swagCustomizedProductsTemplate.translation`.swag_customized_products_template_version_id, `product.swagCustomizedProductsTemplate.translation`.display_name as `product.swagCustomizedProductsTemplate.translation.displayName`, `product.swagCustomizedProductsTemplate.translation`.description as `product.swagCustomizedProductsTemplate.translation.description`, `product.swagCustomizedProductsTemplate.translation`.created_at as `product.swagCustomizedProductsTemplate.translation.createdAt`, `product.swagCustomizedProductsTemplate.translation`.updated_at as `product.swagCustomizedProductsTemplate.translation.updatedAt`, `product.swagCustomizedProductsTemplate.translation`.swag_customized_products_template_id as `product.swagCustomizedProductsTemplate.translation.swagCustomizedProductsTemplateId`, `product.swagCustomizedProductsTemplate.translation`.language_id as `product.swagCustomizedProductsTemplate.translation.languageId`, `product.swagCustomizedProductsTemplate.translation`.swag_customized_products_template_version_id as `product.swagCustomizedProductsTemplate.translation.swagCustomizedProductsTemplateVersionId` FROM `swag_customized_products_template_translation` `product.swagCustomizedProductsTemplate.translation` WHERE `product.swagCustomizedProductsTemplate.translation`.language_id = ?) `product.swagCustomizedProductsTemplate.swag_customized_products_template_translation` ON `product.swagCustomizedProductsTemplate.swag_customized_products_template_translation`.`swag_customized_products_template_id` = `product.swagCustomizedProductsTemplate`.`id` AND `product.swagCustomizedProductsTemplate.swag_customized_products_template_translation`.swag_customized_products_template_version_id = `product.swagCustomizedProductsTemplate`.version_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"â\x0E\x07\x17Ý\x11Ø\e\x00PV¥~ì"
  b"└J¢WÌ$ý\x11Ø\x1A\x00PV¥~ì"
  b"5µ‗¸▒iÝ\x11Ø \x00PV¥~ì"
  b"┐o┤cÌ$ý\x11Ø\x1A\x00PV¥~ì"
  b"\x01ý▒iÝ\x11Ø \x00PV¥~ì"
  b"q\e¢]Ì$ý\x11Ø\x1A\x00PV¥~ì"
  b"(K¢WÌ$ý\x11Ø\x1A\x00PV¥~ì"
  b" `└QÌ$ý\x11Ø\x1A\x00PV¥~ì"
  b"yøÆÁ░iÝ\x11Ø \x00PV¥~ì"
]
4.38 ms
(4.71%)
9
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters:
[]
4.32 ms
(4.64%)
9
# app-scripts::refresh::read
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = ?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
]
3.69 ms
(3.97%)
9
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters:
[]
3.61 ms
(3.88%)
1
# product-detail-route::read
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product.parent`.`cheapest_price` as `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, COALESCE(`product`.`swag_customized_products_template_id`, `product.parent`.`swag_customized_products_template_id`) as `product.swagCustomizedProductsTemplateId`, COALESCE(`product`.`swag_customized_products_template_version_id`, `product.parent`.`swag_customized_products_template_version_id`) as `product.swagCustomizedProductsTemplateVersionId`, `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.media`.`id` as `product.manufacturer.media.id`, `product.manufacturer.media`.`user_id` as `product.manufacturer.media.userId`, `product.manufacturer.media`.`media_folder_id` as `product.manufacturer.media.mediaFolderId`, `product.manufacturer.media`.`mime_type` as `product.manufacturer.media.mimeType`, `product.manufacturer.media`.`file_extension` as `product.manufacturer.media.fileExtension`, `product.manufacturer.media`.`uploaded_at` as `product.manufacturer.media.uploadedAt`, `product.manufacturer.media`.`file_name` as `product.manufacturer.media.fileName`, `product.manufacturer.media`.`file_size` as `product.manufacturer.media.fileSize`, `product.manufacturer.media`.`media_type` as `product.manufacturer.media.mediaTypeRaw`, `product.manufacturer.media`.`meta_data` as `product.manufacturer.media.metaData`, `product.manufacturer.media`.`config` as `product.manufacturer.media.config`, `product.manufacturer.media`.`path` as `product.manufacturer.media.path`, `product.manufacturer.media`.`private` as `product.manufacturer.media.private`, `product.manufacturer.media`.`thumbnails_ro` as `product.manufacturer.media.thumbnailsRo`, `product.manufacturer.media`.`created_at` as `product.manufacturer.media.createdAt`, `product.manufacturer.media`.`updated_at` as `product.manufacturer.media.updatedAt`, `product.manufacturer.media.translation.title`, COALESCE(`product.manufacturer.media.translation.title`,`product.manufacturer.media.translation.title`) as `product.manufacturer.media.title`, `product.manufacturer.media.translation.alt`, COALESCE(`product.manufacturer.media.translation.alt`,`product.manufacturer.media.translation.alt`) as `product.manufacturer.media.alt`, `product.manufacturer.media.translation.customFields`, COALESCE(`product.manufacturer.media.translation.customFields`,`product.manufacturer.media.translation.customFields`) as `product.manufacturer.media.customFields`, `product.manufacturer.media.translation.createdAt`, `product.manufacturer.media.translation.updatedAt`, `product.manufacturer.media.translation.mediaId`, `product.manufacturer.media.translation.languageId`, `product.manufacturer.translation.name`, COALESCE(`product.manufacturer.translation.name`,`product.manufacturer.translation.name`) as `product.manufacturer.name`, `product.manufacturer.translation.description`, COALESCE(`product.manufacturer.translation.description`,`product.manufacturer.translation.description`) as `product.manufacturer.description`, `product.manufacturer.translation.customFields`, COALESCE(`product.manufacturer.translation.customFields`,`product.manufacturer.translation.customFields`) as `product.manufacturer.customFields`, `product.manufacturer.translation.createdAt`, `product.manufacturer.translation.updatedAt`, `product.manufacturer.translation.productManufacturerId`, `product.manufacturer.translation.languageId`, `product.manufacturer.translation.productManufacturerVersionId`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_option` `product.options.mapping`
                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, (SELECT GROUP_CONCAT(HEX(`product.properties.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_property` `product.properties.mapping`
                  WHERE `product.properties.mapping`.`product_id` = `product`.`properties` ) as `product.properties.id_mapping`, `product.unit`.`id` as `product.unit.id`, `product.unit`.`created_at` as `product.unit.createdAt`, `product.unit`.`updated_at` as `product.unit.updatedAt`, `product.unit.translation.shortCode`, COALESCE(`product.unit.translation.shortCode`,`product.unit.translation.shortCode`) as `product.unit.shortCode`, `product.unit.translation.name`, COALESCE(`product.unit.translation.name`,`product.unit.translation.name`) as `product.unit.name`, `product.unit.translation.customFields`, COALESCE(`product.unit.translation.customFields`,`product.unit.translation.customFields`) as `product.unit.customFields`, `product.unit.translation.createdAt`, `product.unit.translation.updatedAt`, `product.unit.translation.unitId`, `product.unit.translation.languageId`, `product.deliveryTime`.`id` as `product.deliveryTime.id`, `product.deliveryTime`.`min` as `product.deliveryTime.min`, `product.deliveryTime`.`max` as `product.deliveryTime.max`, `product.deliveryTime`.`unit` as `product.deliveryTime.unit`, `product.deliveryTime`.`created_at` as `product.deliveryTime.createdAt`, `product.deliveryTime`.`updated_at` as `product.deliveryTime.updatedAt`, `product.deliveryTime.translation.name`, COALESCE(`product.deliveryTime.translation.name`,`product.deliveryTime.translation.name`) as `product.deliveryTime.name`, `product.deliveryTime.translation.customFields`, COALESCE(`product.deliveryTime.translation.customFields`,`product.deliveryTime.translation.customFields`) as `product.deliveryTime.customFields`, `product.deliveryTime.translation.createdAt`, `product.deliveryTime.translation.updatedAt`, `product.deliveryTime.translation.deliveryTimeId`, `product.deliveryTime.translation.languageId`, `product.cover`.`id` as `product.cover.id`, `product.cover`.`version_id` as `product.cover.versionId`, `product.cover`.`product_id` as `product.cover.productId`, `product.cover`.`product_version_id` as `product.cover.productVersionId`, `product.cover`.`media_id` as `product.cover.mediaId`, `product.cover`.`position` as `product.cover.position`, `product.cover.media`.`id` as `product.cover.media.id`, `product.cover.media`.`user_id` as `product.cover.media.userId`, `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` as `product.cover.media.fileName`, `product.cover.media`.`file_size` as `product.cover.media.fileSize`, `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` as `product.cover.media.metaData`, `product.cover.media`.`config` as `product.cover.media.config`, `product.cover.media`.`path` as `product.cover.media.path`, `product.cover.media`.`private` as `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, `product.cover.media`.`created_at` as `product.cover.media.createdAt`, `product.cover.media`.`updated_at` as `product.cover.media.updatedAt`, `product.cover.media.translation.title`, COALESCE(`product.cover.media.translation.title`,`product.cover.media.translation.title`) as `product.cover.media.title`, `product.cover.media.translation.alt`, COALESCE(`product.cover.media.translation.alt`,`product.cover.media.translation.alt`) as `product.cover.media.alt`, `product.cover.media.translation.customFields`, COALESCE(`product.cover.media.translation.customFields`,`product.cover.media.translation.customFields`) as `product.cover.media.customFields`, `product.cover.media.translation.createdAt`, `product.cover.media.translation.updatedAt`, `product.cover.media.translation.mediaId`, `product.cover.media.translation.languageId`, `product.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, `product.swagCustomizedProductsTemplate`.`id` as `product.swagCustomizedProductsTemplate.id`, `product.swagCustomizedProductsTemplate`.`version_id` as `product.swagCustomizedProductsTemplate.versionId`, `product.swagCustomizedProductsTemplate`.`parent_version_id` as `product.swagCustomizedProductsTemplate.parentVersionId`, `product.swagCustomizedProductsTemplate`.`internal_name` as `product.swagCustomizedProductsTemplate.internalName`, `product.swagCustomizedProductsTemplate`.`active` as `product.swagCustomizedProductsTemplate.active`, `product.swagCustomizedProductsTemplate`.`step_by_step` as `product.swagCustomizedProductsTemplate.stepByStep`, `product.swagCustomizedProductsTemplate`.`confirm_input` as `product.swagCustomizedProductsTemplate.confirmInput`, `product.swagCustomizedProductsTemplate`.`options_auto_collapse` as `product.swagCustomizedProductsTemplate.optionsAutoCollapse`, `product.swagCustomizedProductsTemplate`.`decision_tree` as `product.swagCustomizedProductsTemplate.decisionTree`, `product.swagCustomizedProductsTemplate`.`media_id` as `product.swagCustomizedProductsTemplate.mediaId`, `product.swagCustomizedProductsTemplate`.`created_at` as `product.swagCustomizedProductsTemplate.createdAt`, `product.swagCustomizedProductsTemplate`.`updated_at` as `product.swagCustomizedProductsTemplate.updatedAt`, `product.swagCustomizedProductsTemplate.translation.displayName`, COALESCE(`product.swagCustomizedProductsTemplate.translation.displayName`,`product.swagCustomizedProductsTemplate.translation.displayName`) as `product.swagCustomizedProductsTemplate.displayName`, `product.swagCustomizedProductsTemplate.translation.description`, COALESCE(`product.swagCustomizedProductsTemplate.translation.description`,`product.swagCustomizedProductsTemplate.translation.description`) as `product.swagCustomizedProductsTemplate.description`, `product.swagCustomizedProductsTemplate.translation.createdAt`, `product.swagCustomizedProductsTemplate.translation.updatedAt`, `product.swagCustomizedProductsTemplate.translation.swagCustomizedProductsTemplateId`, `product.swagCustomizedProductsTemplate.translation.languageId`, `product.swagCustomizedProductsTemplate.translation.swagCustomizedProductsTemplateVersionId`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`,`product.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`,`product.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`,`product.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`,`product.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`,`product.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`,`product.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`,`product.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`,`product.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`,`product.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`,`product.translation.customFields`) as `product.customFields`, `product.translation.createdAt`, `product.parent.translation.createdAt`, `product.translation.updatedAt`, `product.parent.translation.updatedAt`, `product.translation.productId`, `product.parent.translation.productId`, `product.translation.languageId`, `product.parent.translation.languageId`, `product.translation.productVersionId`, `product.parent.translation.productVersionId` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.product_id, `product.translation`.product_version_id, `product.translation`.meta_description as `product.translation.metaDescription`, `product.translation`.name as `product.translation.name`, `product.translation`.keywords as `product.translation.keywords`, `product.translation`.description as `product.translation.description`, `product.translation`.meta_title as `product.translation.metaTitle`, `product.translation`.pack_unit as `product.translation.packUnit`, `product.translation`.pack_unit_plural as `product.translation.packUnitPlural`, `product.translation`.custom_search_keywords as `product.translation.customSearchKeywords`, `product.translation`.slot_config as `product.translation.slotConfig`, `product.translation`.custom_fields as `product.translation.customFields`, `product.translation`.created_at as `product.translation.createdAt`, `product.translation`.updated_at as `product.translation.updatedAt`, `product.translation`.product_id as `product.translation.productId`, `product.translation`.language_id as `product.translation.languageId`, `product.translation`.product_version_id as `product.translation.productVersionId` FROM `product_translation` `product.translation` WHERE `product.translation`.language_id = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.product_version_id = `product`.version_id LEFT JOIN (SELECT `product.parent.translation`.product_id, `product.parent.translation`.product_version_id, `product.parent.translation`.meta_description as `product.parent.translation.metaDescription`, `product.parent.translation`.name as `product.parent.translation.name`, `product.parent.translation`.keywords as `product.parent.translation.keywords`, `product.parent.translation`.description as `product.parent.translation.description`, `product.parent.translation`.meta_title as `product.parent.translation.metaTitle`, `product.parent.translation`.pack_unit as `product.parent.translation.packUnit`, `product.parent.translation`.pack_unit_plural as `product.parent.translation.packUnitPlural`, `product.parent.translation`.custom_search_keywords as `product.parent.translation.customSearchKeywords`, `product.parent.translation`.slot_config as `product.parent.translation.slotConfig`, `product.parent.translation`.custom_fields as `product.parent.translation.customFields`, `product.parent.translation`.created_at as `product.parent.translation.createdAt`, `product.parent.translation`.updated_at as `product.parent.translation.updatedAt`, `product.parent.translation`.product_id as `product.parent.translation.productId`, `product.parent.translation`.language_id as `product.parent.translation.languageId`, `product.parent.translation`.product_version_id as `product.parent.translation.productVersionId` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.language_id = ?) `product.product_translation.parent` ON `product.product_translation.parent`.`product_id` = `product.parent`.`id` AND `product.product_translation.parent`.product_version_id = `product.parent`.version_id LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN `swag_customized_products_template` `product.swagCustomizedProductsTemplate` ON `product`.`swagCustomizedProductsTemplate` = `product.swagCustomizedProductsTemplate`.`id` AND IFNULL(`product`.`swag_customized_products_template_version_id`, `product.parent`.`swag_customized_products_template_version_id`) = `product.swagCustomizedProductsTemplate`.`version_id` LEFT JOIN (SELECT `product.manufacturer.translation`.product_manufacturer_id, `product.manufacturer.translation`.product_manufacturer_version_id, `product.manufacturer.translation`.name as `product.manufacturer.translation.name`, `product.manufacturer.translation`.description as `product.manufacturer.translation.description`, `product.manufacturer.translation`.custom_fields as `product.manufacturer.translation.customFields`, `product.manufacturer.translation`.created_at as `product.manufacturer.translation.createdAt`, `product.manufacturer.translation`.updated_at as `product.manufacturer.translation.updatedAt`, `product.manufacturer.translation`.product_manufacturer_id as `product.manufacturer.translation.productManufacturerId`, `product.manufacturer.translation`.language_id as `product.manufacturer.translation.languageId`, `product.manufacturer.translation`.product_manufacturer_version_id as `product.manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer_translation` `product.manufacturer.translation` WHERE `product.manufacturer.translation`.language_id = ?) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product.manufacturer.product_manufacturer_translation`.product_manufacturer_version_id = `product.manufacturer`.version_id LEFT JOIN `media` `product.manufacturer.media` ON `product.manufacturer`.`media_id` = `product.manufacturer.media`.`id` LEFT JOIN (SELECT `product.manufacturer.media.translation`.media_id, `product.manufacturer.media.translation`.title as `product.manufacturer.media.translation.title`, `product.manufacturer.media.translation`.alt as `product.manufacturer.media.translation.alt`, `product.manufacturer.media.translation`.custom_fields as `product.manufacturer.media.translation.customFields`, `product.manufacturer.media.translation`.created_at as `product.manufacturer.media.translation.createdAt`, `product.manufacturer.media.translation`.updated_at as `product.manufacturer.media.translation.updatedAt`, `product.manufacturer.media.translation`.media_id as `product.manufacturer.media.translation.mediaId`, `product.manufacturer.media.translation`.language_id as `product.manufacturer.media.translation.languageId` FROM `media_translation` `product.manufacturer.media.translation` WHERE `product.manufacturer.media.translation`.language_id = ?) `product.manufacturer.media.media_translation` ON `product.manufacturer.media.media_translation`.`media_id` = `product.manufacturer.media`.`id` LEFT JOIN (SELECT `product.unit.translation`.unit_id, `product.unit.translation`.short_code as `product.unit.translation.shortCode`, `product.unit.translation`.name as `product.unit.translation.name`, `product.unit.translation`.custom_fields as `product.unit.translation.customFields`, `product.unit.translation`.created_at as `product.unit.translation.createdAt`, `product.unit.translation`.updated_at as `product.unit.translation.updatedAt`, `product.unit.translation`.unit_id as `product.unit.translation.unitId`, `product.unit.translation`.language_id as `product.unit.translation.languageId` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation`.language_id = ?) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id` LEFT JOIN (SELECT `product.deliveryTime.translation`.delivery_time_id, `product.deliveryTime.translation`.name as `product.deliveryTime.translation.name`, `product.deliveryTime.translation`.custom_fields as `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation`.created_at as `product.deliveryTime.translation.createdAt`, `product.deliveryTime.translation`.updated_at as `product.deliveryTime.translation.updatedAt`, `product.deliveryTime.translation`.delivery_time_id as `product.deliveryTime.translation.deliveryTimeId`, `product.deliveryTime.translation`.language_id as `product.deliveryTime.translation.languageId` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation`.language_id = ?) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id` LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.cover.media.translation`.media_id, `product.cover.media.translation`.title as `product.cover.media.translation.title`, `product.cover.media.translation`.alt as `product.cover.media.translation.alt`, `product.cover.media.translation`.custom_fields as `product.cover.media.translation.customFields`, `product.cover.media.translation`.created_at as `product.cover.media.translation.createdAt`, `product.cover.media.translation`.updated_at as `product.cover.media.translation.updatedAt`, `product.cover.media.translation`.media_id as `product.cover.media.translation.mediaId`, `product.cover.media.translation`.language_id as `product.cover.media.translation.languageId` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation`.language_id = ?) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.swagCustomizedProductsTemplate.translation`.swag_customized_products_template_id, `product.swagCustomizedProductsTemplate.translation`.swag_customized_products_template_version_id, `product.swagCustomizedProductsTemplate.translation`.display_name as `product.swagCustomizedProductsTemplate.translation.displayName`, `product.swagCustomizedProductsTemplate.translation`.description as `product.swagCustomizedProductsTemplate.translation.description`, `product.swagCustomizedProductsTemplate.translation`.created_at as `product.swagCustomizedProductsTemplate.translation.createdAt`, `product.swagCustomizedProductsTemplate.translation`.updated_at as `product.swagCustomizedProductsTemplate.translation.updatedAt`, `product.swagCustomizedProductsTemplate.translation`.swag_customized_products_template_id as `product.swagCustomizedProductsTemplate.translation.swagCustomizedProductsTemplateId`, `product.swagCustomizedProductsTemplate.translation`.language_id as `product.swagCustomizedProductsTemplate.translation.languageId`, `product.swagCustomizedProductsTemplate.translation`.swag_customized_products_template_version_id as `product.swagCustomizedProductsTemplate.translation.swagCustomizedProductsTemplateVersionId` FROM `swag_customized_products_template_translation` `product.swagCustomizedProductsTemplate.translation` WHERE `product.swagCustomizedProductsTemplate.translation`.language_id = ?) `product.swagCustomizedProductsTemplate.swag_customized_products_template_translation` ON `product.swagCustomizedProductsTemplate.swag_customized_products_template_translation`.`swag_customized_products_template_id` = `product.swagCustomizedProductsTemplate`.`id` AND `product.swagCustomizedProductsTemplate.swag_customized_products_template_translation`.swag_customized_products_template_version_id = `product.swagCustomizedProductsTemplate`.version_id WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"╦o┤cÌ$ý\x11Ø\x1A\x00PV¥~ì"
]
2.88 ms
(3.09%)
1
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product.parent`.`cheapest_price` as `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, COALESCE(`product`.`swag_customized_products_template_id`, `product.parent`.`swag_customized_products_template_id`) as `product.swagCustomizedProductsTemplateId`, COALESCE(`product`.`swag_customized_products_template_version_id`, `product.parent`.`swag_customized_products_template_version_id`) as `product.swagCustomizedProductsTemplateVersionId`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_option` `product.options.mapping`
                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, `product.unit`.`id` as `product.unit.id`, `product.unit`.`created_at` as `product.unit.createdAt`, `product.unit`.`updated_at` as `product.unit.updatedAt`, `product.unit.translation.shortCode`, COALESCE(`product.unit.translation.shortCode`,`product.unit.translation.shortCode`) as `product.unit.shortCode`, `product.unit.translation.name`, COALESCE(`product.unit.translation.name`,`product.unit.translation.name`) as `product.unit.name`, `product.unit.translation.customFields`, COALESCE(`product.unit.translation.customFields`,`product.unit.translation.customFields`) as `product.unit.customFields`, `product.unit.translation.createdAt`, `product.unit.translation.updatedAt`, `product.unit.translation.unitId`, `product.unit.translation.languageId`, `product.deliveryTime`.`id` as `product.deliveryTime.id`, `product.deliveryTime`.`min` as `product.deliveryTime.min`, `product.deliveryTime`.`max` as `product.deliveryTime.max`, `product.deliveryTime`.`unit` as `product.deliveryTime.unit`, `product.deliveryTime`.`created_at` as `product.deliveryTime.createdAt`, `product.deliveryTime`.`updated_at` as `product.deliveryTime.updatedAt`, `product.deliveryTime.translation.name`, COALESCE(`product.deliveryTime.translation.name`,`product.deliveryTime.translation.name`) as `product.deliveryTime.name`, `product.deliveryTime.translation.customFields`, COALESCE(`product.deliveryTime.translation.customFields`,`product.deliveryTime.translation.customFields`) as `product.deliveryTime.customFields`, `product.deliveryTime.translation.createdAt`, `product.deliveryTime.translation.updatedAt`, `product.deliveryTime.translation.deliveryTimeId`, `product.deliveryTime.translation.languageId`, `product.cover`.`id` as `product.cover.id`, `product.cover`.`version_id` as `product.cover.versionId`, `product.cover`.`product_id` as `product.cover.productId`, `product.cover`.`product_version_id` as `product.cover.productVersionId`, `product.cover`.`media_id` as `product.cover.mediaId`, `product.cover`.`position` as `product.cover.position`, `product.cover.media`.`id` as `product.cover.media.id`, `product.cover.media`.`user_id` as `product.cover.media.userId`, `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` as `product.cover.media.fileName`, `product.cover.media`.`file_size` as `product.cover.media.fileSize`, `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` as `product.cover.media.metaData`, `product.cover.media`.`config` as `product.cover.media.config`, `product.cover.media`.`path` as `product.cover.media.path`, `product.cover.media`.`private` as `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, `product.cover.media`.`created_at` as `product.cover.media.createdAt`, `product.cover.media`.`updated_at` as `product.cover.media.updatedAt`, `product.cover.media.translation.title`, COALESCE(`product.cover.media.translation.title`,`product.cover.media.translation.title`) as `product.cover.media.title`, `product.cover.media.translation.alt`, COALESCE(`product.cover.media.translation.alt`,`product.cover.media.translation.alt`) as `product.cover.media.alt`, `product.cover.media.translation.customFields`, COALESCE(`product.cover.media.translation.customFields`,`product.cover.media.translation.customFields`) as `product.cover.media.customFields`, `product.cover.media.translation.createdAt`, `product.cover.media.translation.updatedAt`, `product.cover.media.translation.mediaId`, `product.cover.media.translation.languageId`, `product.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, `product.swagCustomizedProductsTemplate`.`id` as `product.swagCustomizedProductsTemplate.id`, `product.swagCustomizedProductsTemplate`.`version_id` as `product.swagCustomizedProductsTemplate.versionId`, `product.swagCustomizedProductsTemplate`.`parent_version_id` as `product.swagCustomizedProductsTemplate.parentVersionId`, `product.swagCustomizedProductsTemplate`.`internal_name` as `product.swagCustomizedProductsTemplate.internalName`, `product.swagCustomizedProductsTemplate`.`active` as `product.swagCustomizedProductsTemplate.active`, `product.swagCustomizedProductsTemplate`.`step_by_step` as `product.swagCustomizedProductsTemplate.stepByStep`, `product.swagCustomizedProductsTemplate`.`confirm_input` as `product.swagCustomizedProductsTemplate.confirmInput`, `product.swagCustomizedProductsTemplate`.`options_auto_collapse` as `product.swagCustomizedProductsTemplate.optionsAutoCollapse`, `product.swagCustomizedProductsTemplate`.`decision_tree` as `product.swagCustomizedProductsTemplate.decisionTree`, `product.swagCustomizedProductsTemplate`.`media_id` as `product.swagCustomizedProductsTemplate.mediaId`, `product.swagCustomizedProductsTemplate`.`created_at` as `product.swagCustomizedProductsTemplate.createdAt`, `product.swagCustomizedProductsTemplate`.`updated_at` as `product.swagCustomizedProductsTemplate.updatedAt`, `product.swagCustomizedProductsTemplate.translation.displayName`, COALESCE(`product.swagCustomizedProductsTemplate.translation.displayName`,`product.swagCustomizedProductsTemplate.translation.displayName`) as `product.swagCustomizedProductsTemplate.displayName`, `product.swagCustomizedProductsTemplate.translation.description`, COALESCE(`product.swagCustomizedProductsTemplate.translation.description`,`product.swagCustomizedProductsTemplate.translation.description`) as `product.swagCustomizedProductsTemplate.description`, `product.swagCustomizedProductsTemplate.translation.createdAt`, `product.swagCustomizedProductsTemplate.translation.updatedAt`, `product.swagCustomizedProductsTemplate.translation.swagCustomizedProductsTemplateId`, `product.swagCustomizedProductsTemplate.translation.languageId`, `product.swagCustomizedProductsTemplate.translation.swagCustomizedProductsTemplateVersionId`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`,`product.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`,`product.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`,`product.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`,`product.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`,`product.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`,`product.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`,`product.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`,`product.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`,`product.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`,`product.translation.customFields`) as `product.customFields`, `product.translation.createdAt`, `product.parent.translation.createdAt`, `product.translation.updatedAt`, `product.parent.translation.updatedAt`, `product.translation.productId`, `product.parent.translation.productId`, `product.translation.languageId`, `product.parent.translation.languageId`, `product.translation.productVersionId`, `product.parent.translation.productVersionId` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.product_id, `product.translation`.product_version_id, `product.translation`.meta_description as `product.translation.metaDescription`, `product.translation`.name as `product.translation.name`, `product.translation`.keywords as `product.translation.keywords`, `product.translation`.description as `product.translation.description`, `product.translation`.meta_title as `product.translation.metaTitle`, `product.translation`.pack_unit as `product.translation.packUnit`, `product.translation`.pack_unit_plural as `product.translation.packUnitPlural`, `product.translation`.custom_search_keywords as `product.translation.customSearchKeywords`, `product.translation`.slot_config as `product.translation.slotConfig`, `product.translation`.custom_fields as `product.translation.customFields`, `product.translation`.created_at as `product.translation.createdAt`, `product.translation`.updated_at as `product.translation.updatedAt`, `product.translation`.product_id as `product.translation.productId`, `product.translation`.language_id as `product.translation.languageId`, `product.translation`.product_version_id as `product.translation.productVersionId` FROM `product_translation` `product.translation` WHERE `product.translation`.language_id = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.product_version_id = `product`.version_id LEFT JOIN (SELECT `product.parent.translation`.product_id, `product.parent.translation`.product_version_id, `product.parent.translation`.meta_description as `product.parent.translation.metaDescription`, `product.parent.translation`.name as `product.parent.translation.name`, `product.parent.translation`.keywords as `product.parent.translation.keywords`, `product.parent.translation`.description as `product.parent.translation.description`, `product.parent.translation`.meta_title as `product.parent.translation.metaTitle`, `product.parent.translation`.pack_unit as `product.parent.translation.packUnit`, `product.parent.translation`.pack_unit_plural as `product.parent.translation.packUnitPlural`, `product.parent.translation`.custom_search_keywords as `product.parent.translation.customSearchKeywords`, `product.parent.translation`.slot_config as `product.parent.translation.slotConfig`, `product.parent.translation`.custom_fields as `product.parent.translation.customFields`, `product.parent.translation`.created_at as `product.parent.translation.createdAt`, `product.parent.translation`.updated_at as `product.parent.translation.updatedAt`, `product.parent.translation`.product_id as `product.parent.translation.productId`, `product.parent.translation`.language_id as `product.parent.translation.languageId`, `product.parent.translation`.product_version_id as `product.parent.translation.productVersionId` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.language_id = ?) `product.product_translation.parent` ON `product.product_translation.parent`.`product_id` = `product.parent`.`id` AND `product.product_translation.parent`.product_version_id = `product.parent`.version_id LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `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 `swag_customized_products_template` `product.swagCustomizedProductsTemplate` ON `product`.`swagCustomizedProductsTemplate` = `product.swagCustomizedProductsTemplate`.`id` AND IFNULL(`product`.`swag_customized_products_template_version_id`, `product.parent`.`swag_customized_products_template_version_id`) = `product.swagCustomizedProductsTemplate`.`version_id` LEFT JOIN (SELECT `product.unit.translation`.unit_id, `product.unit.translation`.short_code as `product.unit.translation.shortCode`, `product.unit.translation`.name as `product.unit.translation.name`, `product.unit.translation`.custom_fields as `product.unit.translation.customFields`, `product.unit.translation`.created_at as `product.unit.translation.createdAt`, `product.unit.translation`.updated_at as `product.unit.translation.updatedAt`, `product.unit.translation`.unit_id as `product.unit.translation.unitId`, `product.unit.translation`.language_id as `product.unit.translation.languageId` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation`.language_id = ?) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id` LEFT JOIN (SELECT `product.deliveryTime.translation`.delivery_time_id, `product.deliveryTime.translation`.name as `product.deliveryTime.translation.name`, `product.deliveryTime.translation`.custom_fields as `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation`.created_at as `product.deliveryTime.translation.createdAt`, `product.deliveryTime.translation`.updated_at as `product.deliveryTime.translation.updatedAt`, `product.deliveryTime.translation`.delivery_time_id as `product.deliveryTime.translation.deliveryTimeId`, `product.deliveryTime.translation`.language_id as `product.deliveryTime.translation.languageId` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation`.language_id = ?) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id` LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.cover.media.translation`.media_id, `product.cover.media.translation`.title as `product.cover.media.translation.title`, `product.cover.media.translation`.alt as `product.cover.media.translation.alt`, `product.cover.media.translation`.custom_fields as `product.cover.media.translation.customFields`, `product.cover.media.translation`.created_at as `product.cover.media.translation.createdAt`, `product.cover.media.translation`.updated_at as `product.cover.media.translation.updatedAt`, `product.cover.media.translation`.media_id as `product.cover.media.translation.mediaId`, `product.cover.media.translation`.language_id as `product.cover.media.translation.languageId` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation`.language_id = ?) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.swagCustomizedProductsTemplate.translation`.swag_customized_products_template_id, `product.swagCustomizedProductsTemplate.translation`.swag_customized_products_template_version_id, `product.swagCustomizedProductsTemplate.translation`.display_name as `product.swagCustomizedProductsTemplate.translation.displayName`, `product.swagCustomizedProductsTemplate.translation`.description as `product.swagCustomizedProductsTemplate.translation.description`, `product.swagCustomizedProductsTemplate.translation`.created_at as `product.swagCustomizedProductsTemplate.translation.createdAt`, `product.swagCustomizedProductsTemplate.translation`.updated_at as `product.swagCustomizedProductsTemplate.translation.updatedAt`, `product.swagCustomizedProductsTemplate.translation`.swag_customized_products_template_id as `product.swagCustomizedProductsTemplate.translation.swagCustomizedProductsTemplateId`, `product.swagCustomizedProductsTemplate.translation`.language_id as `product.swagCustomizedProductsTemplate.translation.languageId`, `product.swagCustomizedProductsTemplate.translation`.swag_customized_products_template_version_id as `product.swagCustomizedProductsTemplate.translation.swagCustomizedProductsTemplateVersionId` FROM `swag_customized_products_template_translation` `product.swagCustomizedProductsTemplate.translation` WHERE `product.swagCustomizedProductsTemplate.translation`.language_id = ?) `product.swagCustomizedProductsTemplate.swag_customized_products_template_translation` ON `product.swagCustomizedProductsTemplate.swag_customized_products_template_translation`.`swag_customized_products_template_id` = `product.swagCustomizedProductsTemplate`.`id` AND `product.swagCustomizedProductsTemplate.swag_customized_products_template_translation`.swag_customized_products_template_version_id = `product.swagCustomizedProductsTemplate`.version_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"└J¢WÌ$ý\x11Ø\x1A\x00PV¥~ì"
  b"5µ‗¸▒iÝ\x11Ø \x00PV¥~ì"
  b"\x01ý▒iÝ\x11Ø \x00PV¥~ì"
  b"q\e¢]Ì$ý\x11Ø\x1A\x00PV¥~ì"
]
2.29 ms
(2.46%)
2
SELECT LOWER(HEX(`category`.`parent_id`)) as `category-ids.key`, COUNT(`category`.`id`) as `category-ids.count`, COUNT(DISTINCT `category`.`id`) as `visible-children-count` FROM `category` WHERE (`category`.`version_id` = ?) AND ((`category`.`path` LIKE ? AND `category`.`level` = ? AND `category`.`active` = ? AND `category`.`visible` = ?)) GROUP BY `category`.`parent_id`
Parameters:
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  "%|31a9e44cb1454ee894c2efc5eba84167|%"
  7
  true
  true
]
1.83 ms
(1.97%)
6
SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.shortName`, COALESCE(`currency.translation.shortName`,`currency.translation.shortName`) as `currency.shortName`, `currency.translation.name`, COALESCE(`currency.translation.name`,`currency.translation.name`) as `currency.name`, `currency.translation.customFields`, COALESCE(`currency.translation.customFields`,`currency.translation.customFields`) as `currency.customFields`, `currency.translation.createdAt`, `currency.translation.updatedAt`, `currency.translation.currencyId`, `currency.translation.languageId` FROM `currency` LEFT JOIN (SELECT `currency.translation`.currency_id, `currency.translation`.short_name as `currency.translation.shortName`, `currency.translation`.name as `currency.translation.name`, `currency.translation`.custom_fields as `currency.translation.customFields`, `currency.translation`.created_at as `currency.translation.createdAt`, `currency.translation`.updated_at as `currency.translation.updatedAt`, `currency.translation`.currency_id as `currency.translation.currencyId`, `currency.translation`.language_id as `currency.translation.languageId` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.language_id = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
1.26 ms
(1.36%)
2
# header::navigation::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, COALESCE(`category.media.translation.title`,`category.media.translation.title`) as `category.media.title`, `category.media.translation.alt`, COALESCE(`category.media.translation.alt`,`category.media.translation.alt`) as `category.media.alt`, `category.media.translation.customFields`, COALESCE(`category.media.translation.customFields`,`category.media.translation.customFields`) as `category.media.customFields`, `category.media.translation.createdAt`, `category.media.translation.updatedAt`, `category.media.translation.mediaId`, `category.media.translation.languageId`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.link_type as `category.translation.linkType`, `category.translation`.internal_link as `category.translation.internalLink`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.link_new_tab as `category.translation.linkNewTab`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title as `category.media.translation.title`, `category.media.translation`.alt as `category.media.translation.alt`, `category.media.translation`.custom_fields as `category.media.translation.customFields`, `category.media.translation`.created_at as `category.media.translation.createdAt`, `category.media.translation`.updated_at as `category.media.translation.updatedAt`, `category.media.translation`.media_id as `category.media.translation.mediaId`, `category.media.translation`.language_id as `category.media.translation.languageId` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.language_id = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"1©äL±ENè”ÂïÅë¨Ag"
]
1.23 ms
(1.32%)
10
SELECT `base_class` AS `baseClass`, `author`
                FROM `plugin`
Parameters:
[]
1.14 ms
(1.22%)
2
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`, COALESCE(`property_group_option.group.translation.name`,`property_group_option.group.translation.name`) as `property_group_option.group.name`, `property_group_option.group.translation.description`, COALESCE(`property_group_option.group.translation.description`,`property_group_option.group.translation.description`) as `property_group_option.group.description`, `property_group_option.group.translation.position`, COALESCE(`property_group_option.group.translation.position`,`property_group_option.group.translation.position`) as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, COALESCE(`property_group_option.group.translation.customFields`,`property_group_option.group.translation.customFields`) as `property_group_option.group.customFields`, `property_group_option.group.translation.createdAt`, `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation.languageId`, `property_group_option.translation.name`, COALESCE(`property_group_option.translation.name`,`property_group_option.translation.name`) as `property_group_option.name`, `property_group_option.translation.position`, COALESCE(`property_group_option.translation.position`,`property_group_option.translation.position`) as `property_group_option.position`, `property_group_option.translation.customFields`, COALESCE(`property_group_option.translation.customFields`,`property_group_option.translation.customFields`) as `property_group_option.customFields`, `property_group_option.translation.createdAt`, `property_group_option.translation.updatedAt`, `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation.languageId` FROM `property_group_option` 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`, `property_group_option.translation`.created_at as `property_group_option.translation.createdAt`, `property_group_option.translation`.updated_at as `property_group_option.translation.updatedAt`, `property_group_option.translation`.property_group_option_id as `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation`.language_id as `property_group_option.translation.languageId` 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 `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`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`, `property_group_option.group.translation`.created_at as `property_group_option.group.translation.createdAt`, `property_group_option.group.translation`.updated_at as `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation`.property_group_id as `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation`.language_id as `property_group_option.group.translation.languageId` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.language_id = ?) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` WHERE `property_group_option`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x08\x0EÎwÝ\x11Ø$\x00PV¥~ì"
]
1.12 ms
(1.21%)
1
# generic-page::shipping-methods::read
SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`active` as `shipping_method.active`, `shipping_method`.`position` as `shipping_method.position`, `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` as `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` as `shipping_method.taxType`, `shipping_method`.`tax_id` as `shipping_method.taxId`, `shipping_method.deliveryTime`.`id` as `shipping_method.deliveryTime.id`, `shipping_method.deliveryTime`.`min` as `shipping_method.deliveryTime.min`, `shipping_method.deliveryTime`.`max` as `shipping_method.deliveryTime.max`, `shipping_method.deliveryTime`.`unit` as `shipping_method.deliveryTime.unit`, `shipping_method.deliveryTime`.`created_at` as `shipping_method.deliveryTime.createdAt`, `shipping_method.deliveryTime`.`updated_at` as `shipping_method.deliveryTime.updatedAt`, `shipping_method.deliveryTime.translation.name`, COALESCE(`shipping_method.deliveryTime.translation.name`,`shipping_method.deliveryTime.translation.name`) as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.customFields`,`shipping_method.deliveryTime.translation.customFields`) as `shipping_method.deliveryTime.customFields`, `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation.languageId`, `shipping_method.appShippingMethod`.`id` as `shipping_method.appShippingMethod.id`, `shipping_method.appShippingMethod`.`app_name` as `shipping_method.appShippingMethod.appName`, `shipping_method.appShippingMethod`.`identifier` as `shipping_method.appShippingMethod.identifier`, `shipping_method.appShippingMethod`.`app_id` as `shipping_method.appShippingMethod.appId`, `shipping_method.appShippingMethod`.`shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId`, `shipping_method.appShippingMethod`.`original_media_id` as `shipping_method.appShippingMethod.originalMediaId`, `shipping_method.appShippingMethod`.`created_at` as `shipping_method.appShippingMethod.createdAt`, `shipping_method.appShippingMethod`.`updated_at` as `shipping_method.appShippingMethod.updatedAt`, `shipping_method`.`technical_name` as `shipping_method.technicalName`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.media`.`id` as `shipping_method.media.id`, `shipping_method.media`.`user_id` as `shipping_method.media.userId`, `shipping_method.media`.`media_folder_id` as `shipping_method.media.mediaFolderId`, `shipping_method.media`.`mime_type` as `shipping_method.media.mimeType`, `shipping_method.media`.`file_extension` as `shipping_method.media.fileExtension`, `shipping_method.media`.`uploaded_at` as `shipping_method.media.uploadedAt`, `shipping_method.media`.`file_name` as `shipping_method.media.fileName`, `shipping_method.media`.`file_size` as `shipping_method.media.fileSize`, `shipping_method.media`.`media_type` as `shipping_method.media.mediaTypeRaw`, `shipping_method.media`.`meta_data` as `shipping_method.media.metaData`, `shipping_method.media`.`config` as `shipping_method.media.config`, `shipping_method.media`.`path` as `shipping_method.media.path`, `shipping_method.media`.`private` as `shipping_method.media.private`, `shipping_method.media`.`thumbnails_ro` as `shipping_method.media.thumbnailsRo`, `shipping_method.media`.`created_at` as `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`, `shipping_method.media.translation.title`, COALESCE(`shipping_method.media.translation.title`,`shipping_method.media.translation.title`) as `shipping_method.media.title`, `shipping_method.media.translation.alt`, COALESCE(`shipping_method.media.translation.alt`,`shipping_method.media.translation.alt`) as `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, COALESCE(`shipping_method.media.translation.customFields`,`shipping_method.media.translation.customFields`) as `shipping_method.media.customFields`, `shipping_method.media.translation.createdAt`, `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation.mediaId`, `shipping_method.media.translation.languageId`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.name`,`shipping_method.translation.name`) as `shipping_method.name`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.description`,`shipping_method.translation.description`) as `shipping_method.description`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.trackingUrl`,`shipping_method.translation.trackingUrl`) as `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.customFields`,`shipping_method.translation.customFields`) as `shipping_method.customFields`, `shipping_method.translation.createdAt`, `shipping_method.translation.updatedAt`, `shipping_method.translation.shippingMethodId`, `shipping_method.translation.languageId` FROM `shipping_method` LEFT JOIN (SELECT `shipping_method.translation`.shipping_method_id, `shipping_method.translation`.name as `shipping_method.translation.name`, `shipping_method.translation`.description as `shipping_method.translation.description`, `shipping_method.translation`.tracking_url as `shipping_method.translation.trackingUrl`, `shipping_method.translation`.custom_fields as `shipping_method.translation.customFields`, `shipping_method.translation`.created_at as `shipping_method.translation.createdAt`, `shipping_method.translation`.updated_at as `shipping_method.translation.updatedAt`, `shipping_method.translation`.shipping_method_id as `shipping_method.translation.shippingMethodId`, `shipping_method.translation`.language_id as `shipping_method.translation.languageId` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.language_id = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method`.`id` = `shipping_method.appShippingMethod`.`shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation`.delivery_time_id, `shipping_method.deliveryTime.translation`.name as `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation`.custom_fields as `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation`.created_at as `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation`.updated_at as `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation`.delivery_time_id as `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation`.language_id as `shipping_method.deliveryTime.translation.languageId` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation`.language_id = ?) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.media_id, `shipping_method.media.translation`.title as `shipping_method.media.translation.title`, `shipping_method.media.translation`.alt as `shipping_method.media.translation.alt`, `shipping_method.media.translation`.custom_fields as `shipping_method.media.translation.customFields`, `shipping_method.media.translation`.created_at as `shipping_method.media.translation.createdAt`, `shipping_method.media.translation`.updated_at as `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation`.media_id as `shipping_method.media.translation.mediaId`, `shipping_method.media.translation`.language_id as `shipping_method.media.translation.languageId` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation`.language_id = ?) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01“%/\x18Ô~—’“dþõ( ’"
  b"\x12”¡` @ïªÒí–\x1Dâ0\"
  b"\x01“%¶Yíz\x0F·c¨çlíˆ\x05"
  b"ý¹nøh…CA¡Tóo±æ´\v"
  b"\x06Jå( ,Gv¤si\x14\x16ÝæÚ"
  b"\x05ldk \eO\x05—¢\x18ÔIHÞ“"
  b"“Ø\x17¡#¨N\x03„¯Þ\r\r\x11"
  b"2y\v6èÃLº¾FÀÑö“L¸"
  b"[¬¶S:ÿD\x13€ØGHú1½8"
  b"o˜<E'ÕI"›=\x05˜\eßiƒ"
  b"Å░L]J`G\x06Ä\ra¥░AµÕ"
  b"\x7F\x03ºÌf#Dθ¨ÁaU}åõ"
]
1.01 ms
(1.08%)
1
# base-context-factory::shipping-method::read
SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`active` as `shipping_method.active`, `shipping_method`.`position` as `shipping_method.position`, `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` as `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` as `shipping_method.taxType`, `shipping_method`.`tax_id` as `shipping_method.taxId`, `shipping_method.deliveryTime`.`id` as `shipping_method.deliveryTime.id`, `shipping_method.deliveryTime`.`min` as `shipping_method.deliveryTime.min`, `shipping_method.deliveryTime`.`max` as `shipping_method.deliveryTime.max`, `shipping_method.deliveryTime`.`unit` as `shipping_method.deliveryTime.unit`, `shipping_method.deliveryTime`.`created_at` as `shipping_method.deliveryTime.createdAt`, `shipping_method.deliveryTime`.`updated_at` as `shipping_method.deliveryTime.updatedAt`, `shipping_method.deliveryTime.translation.name`, COALESCE(`shipping_method.deliveryTime.translation.name`,`shipping_method.deliveryTime.translation.name`) as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.customFields`,`shipping_method.deliveryTime.translation.customFields`) as `shipping_method.deliveryTime.customFields`, `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation.languageId`, `shipping_method.appShippingMethod`.`id` as `shipping_method.appShippingMethod.id`, `shipping_method.appShippingMethod`.`app_name` as `shipping_method.appShippingMethod.appName`, `shipping_method.appShippingMethod`.`identifier` as `shipping_method.appShippingMethod.identifier`, `shipping_method.appShippingMethod`.`app_id` as `shipping_method.appShippingMethod.appId`, `shipping_method.appShippingMethod`.`shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId`, `shipping_method.appShippingMethod`.`original_media_id` as `shipping_method.appShippingMethod.originalMediaId`, `shipping_method.appShippingMethod`.`created_at` as `shipping_method.appShippingMethod.createdAt`, `shipping_method.appShippingMethod`.`updated_at` as `shipping_method.appShippingMethod.updatedAt`, `shipping_method`.`technical_name` as `shipping_method.technicalName`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.media`.`id` as `shipping_method.media.id`, `shipping_method.media`.`user_id` as `shipping_method.media.userId`, `shipping_method.media`.`media_folder_id` as `shipping_method.media.mediaFolderId`, `shipping_method.media`.`mime_type` as `shipping_method.media.mimeType`, `shipping_method.media`.`file_extension` as `shipping_method.media.fileExtension`, `shipping_method.media`.`uploaded_at` as `shipping_method.media.uploadedAt`, `shipping_method.media`.`file_name` as `shipping_method.media.fileName`, `shipping_method.media`.`file_size` as `shipping_method.media.fileSize`, `shipping_method.media`.`media_type` as `shipping_method.media.mediaTypeRaw`, `shipping_method.media`.`meta_data` as `shipping_method.media.metaData`, `shipping_method.media`.`config` as `shipping_method.media.config`, `shipping_method.media`.`path` as `shipping_method.media.path`, `shipping_method.media`.`private` as `shipping_method.media.private`, `shipping_method.media`.`thumbnails_ro` as `shipping_method.media.thumbnailsRo`, `shipping_method.media`.`created_at` as `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`, `shipping_method.media.translation.title`, COALESCE(`shipping_method.media.translation.title`,`shipping_method.media.translation.title`) as `shipping_method.media.title`, `shipping_method.media.translation.alt`, COALESCE(`shipping_method.media.translation.alt`,`shipping_method.media.translation.alt`) as `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, COALESCE(`shipping_method.media.translation.customFields`,`shipping_method.media.translation.customFields`) as `shipping_method.media.customFields`, `shipping_method.media.translation.createdAt`, `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation.mediaId`, `shipping_method.media.translation.languageId`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.name`,`shipping_method.translation.name`) as `shipping_method.name`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.description`,`shipping_method.translation.description`) as `shipping_method.description`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.trackingUrl`,`shipping_method.translation.trackingUrl`) as `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.customFields`,`shipping_method.translation.customFields`) as `shipping_method.customFields`, `shipping_method.translation.createdAt`, `shipping_method.translation.updatedAt`, `shipping_method.translation.shippingMethodId`, `shipping_method.translation.languageId` FROM `shipping_method` LEFT JOIN (SELECT `shipping_method.translation`.shipping_method_id, `shipping_method.translation`.name as `shipping_method.translation.name`, `shipping_method.translation`.description as `shipping_method.translation.description`, `shipping_method.translation`.tracking_url as `shipping_method.translation.trackingUrl`, `shipping_method.translation`.custom_fields as `shipping_method.translation.customFields`, `shipping_method.translation`.created_at as `shipping_method.translation.createdAt`, `shipping_method.translation`.updated_at as `shipping_method.translation.updatedAt`, `shipping_method.translation`.shipping_method_id as `shipping_method.translation.shippingMethodId`, `shipping_method.translation`.language_id as `shipping_method.translation.languageId` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.language_id = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method`.`id` = `shipping_method.appShippingMethod`.`shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation`.delivery_time_id, `shipping_method.deliveryTime.translation`.name as `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation`.custom_fields as `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation`.created_at as `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation`.updated_at as `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation`.delivery_time_id as `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation`.language_id as `shipping_method.deliveryTime.translation.languageId` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation`.language_id = ?) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.media_id, `shipping_method.media.translation`.title as `shipping_method.media.translation.title`, `shipping_method.media.translation`.alt as `shipping_method.media.translation.alt`, `shipping_method.media.translation`.custom_fields as `shipping_method.media.translation.customFields`, `shipping_method.media.translation`.created_at as `shipping_method.media.translation.createdAt`, `shipping_method.media.translation`.updated_at as `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation`.media_id as `shipping_method.media.translation.mediaId`, `shipping_method.media.translation`.language_id as `shipping_method.media.translation.languageId` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation`.language_id = ?) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x12”¡` @ïªÒí–\x1Dâ0\"
]
0.89 ms
(0.96%)
1
# base-context-factory::sales-channel::read
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel.analytics`.`id` as `sales_channel.analytics.id`, `sales_channel.analytics`.`tracking_id` as `sales_channel.analytics.trackingId`, `sales_channel.analytics`.`active` as `sales_channel.analytics.active`, `sales_channel.analytics`.`track_orders` as `sales_channel.analytics.trackOrders`, `sales_channel.analytics`.`anonymize_ip` as `sales_channel.analytics.anonymizeIp`, `sales_channel.analytics`.`created_at` as `sales_channel.analytics.createdAt`, `sales_channel.analytics`.`updated_at` as `sales_channel.analytics.updatedAt`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.currency`.`id` as `sales_channel.currency.id`, `sales_channel.currency`.`factor` as `sales_channel.currency.factor`, `sales_channel.currency`.`symbol` as `sales_channel.currency.symbol`, `sales_channel.currency`.`iso_code` as `sales_channel.currency.isoCode`, `sales_channel.currency`.`position` as `sales_channel.currency.position`, `sales_channel.currency`.`tax_free_from` as `sales_channel.currency.taxFreeFrom`, `sales_channel.currency`.`item_rounding` as `sales_channel.currency.itemRounding`, `sales_channel.currency`.`total_rounding` as `sales_channel.currency.totalRounding`, `sales_channel.currency`.`created_at` as `sales_channel.currency.createdAt`, `sales_channel.currency`.`updated_at` as `sales_channel.currency.updatedAt`, `sales_channel.currency.translation.shortName`, COALESCE(`sales_channel.currency.translation.shortName`,`sales_channel.currency.translation.shortName`) as `sales_channel.currency.shortName`, `sales_channel.currency.translation.name`, COALESCE(`sales_channel.currency.translation.name`,`sales_channel.currency.translation.name`) as `sales_channel.currency.name`, `sales_channel.currency.translation.customFields`, COALESCE(`sales_channel.currency.translation.customFields`,`sales_channel.currency.translation.customFields`) as `sales_channel.currency.customFields`, `sales_channel.currency.translation.createdAt`, `sales_channel.currency.translation.updatedAt`, `sales_channel.currency.translation.currencyId`, `sales_channel.currency.translation.languageId`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.name`,`sales_channel.translation.name`) as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) as `sales_channel.customFields`, `sales_channel.translation.createdAt`, `sales_channel.translation.updatedAt`, `sales_channel.translation.salesChannelId`, `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name as `sales_channel.translation.name`, `sales_channel.translation`.home_slot_config as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.home_enabled as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.home_name as `sales_channel.translation.homeName`, `sales_channel.translation`.home_meta_title as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.home_meta_description as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.home_keywords as `sales_channel.translation.homeKeywords`, `sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`, `sales_channel.translation`.created_at as `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.language_id = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel`.`analytics_id` = `sales_channel.analytics`.`id` LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel`.`currency_id` = `sales_channel.currency`.`id` LEFT JOIN (SELECT `sales_channel.currency.translation`.currency_id, `sales_channel.currency.translation`.short_name as `sales_channel.currency.translation.shortName`, `sales_channel.currency.translation`.name as `sales_channel.currency.translation.name`, `sales_channel.currency.translation`.custom_fields as `sales_channel.currency.translation.customFields`, `sales_channel.currency.translation`.created_at as `sales_channel.currency.translation.createdAt`, `sales_channel.currency.translation`.updated_at as `sales_channel.currency.translation.updatedAt`, `sales_channel.currency.translation`.currency_id as `sales_channel.currency.translation.currencyId`, `sales_channel.currency.translation`.language_id as `sales_channel.currency.translation.languageId` FROM `currency_translation` `sales_channel.currency.translation` WHERE `sales_channel.currency.translation`.language_id = ?) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation`.`currency_id` = `sales_channel.currency`.`id` WHERE `sales_channel`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"äN15ºÖLý»&’ÄA7±ø"
]
0.87 ms
(0.93%)
2
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"äN15ºÖLý»&’ÄA7±ø"
  true
  b"â\x0E\x07\x17Ý\x11Ø\e\x00PV¥~ì"
  b"└J¢WÌ$ý\x11Ø\x1A\x00PV¥~ì"
  b"5µ‗¸▒iÝ\x11Ø \x00PV¥~ì"
  b"┐o┤cÌ$ý\x11Ø\x1A\x00PV¥~ì"
  b"\x01ý▒iÝ\x11Ø \x00PV¥~ì"
  b"q\e¢]Ì$ý\x11Ø\x1A\x00PV¥~ì"
  b"(K¢WÌ$ý\x11Ø\x1A\x00PV¥~ì"
  b" `└QÌ$ý\x11Ø\x1A\x00PV¥~ì"
  b"yøÆÁ░iÝ\x11Ø \x00PV¥~ì"
]
0.83 ms
(0.90%)
1
# generic-page::payment-methods::read
SELECT `payment_method`.`id` as `payment_method.id`, `payment_method`.`plugin_id` as `payment_method.pluginId`, `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`, `payment_method`.`position` as `payment_method.position`, `payment_method`.`active` as `payment_method.active`, `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`, `payment_method`.`media_id` as `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` as `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` as `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` as `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`recurring_url` as `payment_method.appPaymentMethod.recurringUrl`, `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`, `payment_method`.`technical_name` as `payment_method.technicalName`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `payment_method.media`.`id` as `payment_method.media.id`, `payment_method.media`.`user_id` as `payment_method.media.userId`, `payment_method.media`.`media_folder_id` as `payment_method.media.mediaFolderId`, `payment_method.media`.`mime_type` as `payment_method.media.mimeType`, `payment_method.media`.`file_extension` as `payment_method.media.fileExtension`, `payment_method.media`.`uploaded_at` as `payment_method.media.uploadedAt`, `payment_method.media`.`file_name` as `payment_method.media.fileName`, `payment_method.media`.`file_size` as `payment_method.media.fileSize`, `payment_method.media`.`media_type` as `payment_method.media.mediaTypeRaw`, `payment_method.media`.`meta_data` as `payment_method.media.metaData`, `payment_method.media`.`config` as `payment_method.media.config`, `payment_method.media`.`path` as `payment_method.media.path`, `payment_method.media`.`private` as `payment_method.media.private`, `payment_method.media`.`thumbnails_ro` as `payment_method.media.thumbnailsRo`, `payment_method.media`.`created_at` as `payment_method.media.createdAt`, `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`, `payment_method.media.translation.title`, COALESCE(`payment_method.media.translation.title`,`payment_method.media.translation.title`) as `payment_method.media.title`, `payment_method.media.translation.alt`, COALESCE(`payment_method.media.translation.alt`,`payment_method.media.translation.alt`) as `payment_method.media.alt`, `payment_method.media.translation.customFields`, COALESCE(`payment_method.media.translation.customFields`,`payment_method.media.translation.customFields`) as `payment_method.media.customFields`, `payment_method.media.translation.createdAt`, `payment_method.media.translation.updatedAt`, `payment_method.media.translation.mediaId`, `payment_method.media.translation.languageId`, `payment_method.translation.name`, COALESCE(`payment_method.translation.name`,`payment_method.translation.name`) as `payment_method.name`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableName`) as `payment_method.distinguishableName`, `payment_method.translation.description`, COALESCE(`payment_method.translation.description`,`payment_method.translation.description`) as `payment_method.description`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.customFields`,`payment_method.translation.customFields`) as `payment_method.customFields`, `payment_method.translation.createdAt`, `payment_method.translation.updatedAt`, `payment_method.translation.paymentMethodId`, `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation`.payment_method_id, `payment_method.translation`.name as `payment_method.translation.name`, `payment_method.translation`.distinguishable_name as `payment_method.translation.distinguishableName`, `payment_method.translation`.description as `payment_method.translation.description`, `payment_method.translation`.custom_fields as `payment_method.translation.customFields`, `payment_method.translation`.created_at as `payment_method.translation.createdAt`, `payment_method.translation`.updated_at as `payment_method.translation.updatedAt`, `payment_method.translation`.payment_method_id as `payment_method.translation.paymentMethodId`, `payment_method.translation`.language_id as `payment_method.translation.languageId` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.language_id = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.media_id, `payment_method.media.translation`.title as `payment_method.media.translation.title`, `payment_method.media.translation`.alt as `payment_method.media.translation.alt`, `payment_method.media.translation`.custom_fields as `payment_method.media.translation.customFields`, `payment_method.media.translation`.created_at as `payment_method.media.translation.createdAt`, `payment_method.media.translation`.updated_at as `payment_method.media.translation.updatedAt`, `payment_method.media.translation`.media_id as `payment_method.media.translation.mediaId`, `payment_method.media.translation`.language_id as `payment_method.media.translation.languageId` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation`.language_id = ?) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (?, ?, ?, ?, ?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"""
    \f\n
    \rš\x14ÇLºª‚°\x10}ÚŒÏ
    """
  b"òX¬)GÏMýšÑ‚Ø4ô¦_"
  b"ØìD\x0Eø;KY W_«uŽ«»"
  b"¦ð\x10'ë™A<½tHU%\x17GJ"
  b"Á\x1A\x1D}ã─D]¥J\t\x05Ãì8\x16"
]
0.75 ms
(0.81%)
1
# base-context-factory::payment-method::read
SELECT `payment_method`.`id` as `payment_method.id`, `payment_method`.`plugin_id` as `payment_method.pluginId`, `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`, `payment_method`.`position` as `payment_method.position`, `payment_method`.`active` as `payment_method.active`, `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`, `payment_method`.`media_id` as `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` as `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` as `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` as `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`recurring_url` as `payment_method.appPaymentMethod.recurringUrl`, `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`, `payment_method`.`technical_name` as `payment_method.technicalName`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `payment_method.media`.`id` as `payment_method.media.id`, `payment_method.media`.`user_id` as `payment_method.media.userId`, `payment_method.media`.`media_folder_id` as `payment_method.media.mediaFolderId`, `payment_method.media`.`mime_type` as `payment_method.media.mimeType`, `payment_method.media`.`file_extension` as `payment_method.media.fileExtension`, `payment_method.media`.`uploaded_at` as `payment_method.media.uploadedAt`, `payment_method.media`.`file_name` as `payment_method.media.fileName`, `payment_method.media`.`file_size` as `payment_method.media.fileSize`, `payment_method.media`.`media_type` as `payment_method.media.mediaTypeRaw`, `payment_method.media`.`meta_data` as `payment_method.media.metaData`, `payment_method.media`.`config` as `payment_method.media.config`, `payment_method.media`.`path` as `payment_method.media.path`, `payment_method.media`.`private` as `payment_method.media.private`, `payment_method.media`.`thumbnails_ro` as `payment_method.media.thumbnailsRo`, `payment_method.media`.`created_at` as `payment_method.media.createdAt`, `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`, `payment_method.media.translation.title`, COALESCE(`payment_method.media.translation.title`,`payment_method.media.translation.title`) as `payment_method.media.title`, `payment_method.media.translation.alt`, COALESCE(`payment_method.media.translation.alt`,`payment_method.media.translation.alt`) as `payment_method.media.alt`, `payment_method.media.translation.customFields`, COALESCE(`payment_method.media.translation.customFields`,`payment_method.media.translation.customFields`) as `payment_method.media.customFields`, `payment_method.media.translation.createdAt`, `payment_method.media.translation.updatedAt`, `payment_method.media.translation.mediaId`, `payment_method.media.translation.languageId`, `payment_method.translation.name`, COALESCE(`payment_method.translation.name`,`payment_method.translation.name`) as `payment_method.name`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableName`) as `payment_method.distinguishableName`, `payment_method.translation.description`, COALESCE(`payment_method.translation.description`,`payment_method.translation.description`) as `payment_method.description`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.customFields`,`payment_method.translation.customFields`) as `payment_method.customFields`, `payment_method.translation.createdAt`, `payment_method.translation.updatedAt`, `payment_method.translation.paymentMethodId`, `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation`.payment_method_id, `payment_method.translation`.name as `payment_method.translation.name`, `payment_method.translation`.distinguishable_name as `payment_method.translation.distinguishableName`, `payment_method.translation`.description as `payment_method.translation.description`, `payment_method.translation`.custom_fields as `payment_method.translation.customFields`, `payment_method.translation`.created_at as `payment_method.translation.createdAt`, `payment_method.translation`.updated_at as `payment_method.translation.updatedAt`, `payment_method.translation`.payment_method_id as `payment_method.translation.paymentMethodId`, `payment_method.translation`.language_id as `payment_method.translation.languageId` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.language_id = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.media_id, `payment_method.media.translation`.title as `payment_method.media.translation.title`, `payment_method.media.translation`.alt as `payment_method.media.translation.alt`, `payment_method.media.translation`.custom_fields as `payment_method.media.translation.customFields`, `payment_method.media.translation`.created_at as `payment_method.media.translation.createdAt`, `payment_method.media.translation`.updated_at as `payment_method.media.translation.updatedAt`, `payment_method.media.translation`.media_id as `payment_method.media.translation.mediaId`, `payment_method.media.translation`.language_id as `payment_method.media.translation.languageId` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation`.language_id = ?) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"""
    \f\n
    \rš\x14ÇLºª‚°\x10}ÚŒÏ
    """
]
0.72 ms
(0.77%)
1
SELECT translation_key, value FROM snippet WHERE snippet_set_id = ?
Parameters:
[
  b"­ “\x07;‘M´š_bž„ÚÐ>"
]
0.71 ms
(0.77%)
1
# breadcrumb-extension::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.link_type as `category.translation.linkType`, `category.translation`.internal_link as `category.translation.internalLink`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.link_new_tab as `category.translation.linkNewTab`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?, ?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"çÏ¥\v¹nÝ\x11Ø \x00PV¥~ì"
  b"\x17\x04K\x13³nÝ\x11Ø \x00PV¥~ì"
  b"vèf}\x06\x11Ø \x00PV¥~ì"
]
0.67 ms
(0.72%)
2
SELECT `woso_bulkorder_prices`.`id` as `woso_bulkorder_prices.id`, `woso_bulkorder_prices`.`salesChannelId` as `woso_bulkorder_prices.salesChannelId`, `woso_bulkorder_prices`.`productId` as `woso_bulkorder_prices.productId`, `woso_bulkorder_prices`.`taxId` as `woso_bulkorder_prices.taxId`, `woso_bulkorder_prices`.`currencyId` as `woso_bulkorder_prices.currencyId`, `woso_bulkorder_prices`.`customerId` as `woso_bulkorder_prices.customerId`, `woso_bulkorder_prices`.`customerGroupId` as `woso_bulkorder_prices.customerGroupId`, `woso_bulkorder_prices`.`priceGroup` as `woso_bulkorder_prices.priceGroup`, `woso_bulkorder_prices`.`startTime` as `woso_bulkorder_prices.startTime`, `woso_bulkorder_prices`.`endTime` as `woso_bulkorder_prices.endTime`, `woso_bulkorder_prices`.`countryIso3` as `woso_bulkorder_prices.countryIso`, `woso_bulkorder_prices`.`fromQty` as `woso_bulkorder_prices.fromQty`, `woso_bulkorder_prices`.`toQty` as `woso_bulkorder_prices.toQty`, `woso_bulkorder_prices`.`vkPrice` as `woso_bulkorder_prices.vkPrice`, `woso_bulkorder_prices`.`created_at` as `woso_bulkorder_prices.createdAt`, `woso_bulkorder_prices`.`updated_at` as `woso_bulkorder_prices.updatedAt` FROM `woso_bulkorder_prices` WHERE (`woso_bulkorder_prices`.`productId` = ? AND `woso_bulkorder_prices`.`salesChannelId` = ? AND `woso_bulkorder_prices`.`priceGroup` = ? AND (`woso_bulkorder_prices`.`startTime` <=> ? OR (`woso_bulkorder_prices`.`startTime` <= ?)) AND (`woso_bulkorder_prices`.`endTime` <=> ? OR (`woso_bulkorder_prices`.`endTime` >= ?)))
Parameters:
[
  b"╦o┤cÌ$ý\x11Ø\x1A\x00PV¥~ì"
  b"äN15ºÖLý»&’ÄA7±ø"
  "BQZ"
  null
  "2024-12-18 02:13:01.256"
  null
  "2024-12-18 02:13:01.256"
]
0.65 ms
(0.70%)
1
SELECT `unit`.`id` as `unit.id`, `unit`.`created_at` as `unit.createdAt`, `unit`.`updated_at` as `unit.updatedAt`, `unit.translation.shortCode`, COALESCE(`unit.translation.shortCode`,`unit.translation.shortCode`) as `unit.shortCode`, `unit.translation.name`, COALESCE(`unit.translation.name`,`unit.translation.name`) as `unit.name`, `unit.translation.customFields`, COALESCE(`unit.translation.customFields`,`unit.translation.customFields`) as `unit.customFields`, `unit.translation.createdAt`, `unit.translation.updatedAt`, `unit.translation.unitId`, `unit.translation.languageId` FROM `unit` LEFT JOIN (SELECT `unit.translation`.unit_id, `unit.translation`.short_code as `unit.translation.shortCode`, `unit.translation`.name as `unit.translation.name`, `unit.translation`.custom_fields as `unit.translation.customFields`, `unit.translation`.created_at as `unit.translation.createdAt`, `unit.translation`.updated_at as `unit.translation.updatedAt`, `unit.translation`.unit_id as `unit.translation.unitId`, `unit.translation`.language_id as `unit.translation.languageId` FROM `unit_translation` `unit.translation` WHERE `unit.translation`.language_id = ?) `unit.unit_translation` ON `unit.unit_translation`.`unit_id` = `unit`.`id`
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
0.65 ms
(0.70%)
1
# base-context-factory::taxes::association::rules::read
SELECT `tax_rule`.`id` as `tax_rule.id`, `tax_rule`.`tax_rule_type_id` as `tax_rule.taxRuleTypeId`, `tax_rule`.`country_id` as `tax_rule.countryId`, `tax_rule`.`tax_rate` as `tax_rule.taxRate`, `tax_rule`.`data` as `tax_rule.data`, `tax_rule`.`tax_id` as `tax_rule.taxId`, `tax_rule`.`active_from` as `tax_rule.activeFrom`, `tax_rule.type`.`id` as `tax_rule.type.id`, `tax_rule.type`.`technical_name` as `tax_rule.type.technicalName`, `tax_rule.type`.`position` as `tax_rule.type.position`, `tax_rule.type`.`created_at` as `tax_rule.type.createdAt`, `tax_rule.type`.`updated_at` as `tax_rule.type.updatedAt`, `tax_rule.type.translation.typeName`, COALESCE(`tax_rule.type.translation.typeName`,`tax_rule.type.translation.typeName`) as `tax_rule.type.typeName`, `tax_rule.type.translation.createdAt`, `tax_rule.type.translation.updatedAt`, `tax_rule.type.translation.taxRuleTypeId`, `tax_rule.type.translation.languageId`, `tax_rule`.`created_at` as `tax_rule.createdAt`, `tax_rule`.`updated_at` as `tax_rule.updatedAt` FROM `tax_rule` LEFT JOIN `tax_rule_type` `tax_rule.type` ON `tax_rule`.`tax_rule_type_id` = `tax_rule.type`.`id` LEFT JOIN (SELECT `tax_rule.type.translation`.tax_rule_type_id, `tax_rule.type.translation`.type_name as `tax_rule.type.translation.typeName`, `tax_rule.type.translation`.created_at as `tax_rule.type.translation.createdAt`, `tax_rule.type.translation`.updated_at as `tax_rule.type.translation.updatedAt`, `tax_rule.type.translation`.tax_rule_type_id as `tax_rule.type.translation.taxRuleTypeId`, `tax_rule.type.translation`.language_id as `tax_rule.type.translation.languageId` FROM `tax_rule_type_translation` `tax_rule.type.translation` WHERE `tax_rule.type.translation`.language_id = ?) `tax_rule.type.tax_rule_type_translation` ON `tax_rule.type.tax_rule_type_translation`.`tax_rule_type_id` = `tax_rule.type`.`id` WHERE (`tax_rule`.`tax_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x11P=2þ╣Ý\x11Ø$\x00PV¥~ì"
  b"\x11åk\x18»´Ù\x11Ø\x1A\x00PV¥~ì"
  b"\x12åk\x18»´Ù\x11Ø\x1A\x00PV¥~ì"
  b"\x13åk\x18»´Ù\x11Ø\x1A\x00PV¥~ì"
  b"\x14åk\x18»´Ù\x11Ø\x1A\x00PV¥~ì"
  b"\x15åk\x18»´Ù\x11Ø\x1A\x00PV¥~ì"
  b"\x16åk\x18»´Ù\x11Ø\x1A\x00PV¥~ì"
  b"\x17åk\x18»´Ù\x11Ø\x1A\x00PV¥~ì"
  b"\x18åk\x18»´Ù\x11Ø\x1A\x00PV¥~ì"
  b"\x19åk\x18»´Ù\x11Ø\x1A\x00PV¥~ì"
  b"\x1Aåk\x18»´Ù\x11Ø\x1A\x00PV¥~ì"
  b"\eåk\x18»´Ù\x11Ø\x1A\x00PV¥~ì"
  b"\x1Cåk\x18»´Ù\x11Ø\x1A\x00PV¥~ì"
  b"\x1Dåk\x18»´Ù\x11Ø\x1A\x00PV¥~ì"
  b"\x1Eåk\x18»´Ù\x11Ø\x1A\x00PV¥~ì"
  b"\x1Fåk\x18»´Ù\x11Ø\x1A\x00PV¥~ì"
  b" åk\x18»´Ù\x11Ø\x1A\x00PV¥~ì"
  b"!åk\x18»´Ù\x11Ø\x1A\x00PV¥~ì"
  b"yüóZn¿Ý\x11Ø$\x00PV¥~ì"
  b"z\x07\x1E#\x14Žë\x11ªÂ\x00\x15]\x02\x12\x01"
  b"íø°éo¿Ý\x11Ø$\x00PV¥~ì"
  b"éð\x1DQS$ë\x11»K\x00\r:+œå"
]
0.64 ms
(0.69%)
1
# cart-rule-loader::load-rules::read
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  b"\x01“%+\x10ïuT±Vئy¨Ök"
  b"\x01ô%Áç®p9╣¨ÎØ×ê▀ï"
  b"\x01æT─ý¡z\r▒ú6ýÅt²0"
  b"\x01‘np\x1DvxÑ™"ëM0i7u"
  b"\x01ænwI¸y\x15ºâ9\x10═ÒÉL"
  b"\2úÆg<@9¾¥2¤ü¦a¼"
  b"\x16\x13┬#þ\x13DO▓ÿż¬ Z╚"
  b"'¾R-ÖÔF\x0F¦·‘ªTe÷ö"
  b"\rç\x07‘ìB\x05Œø\x18§o\x18†Ì"
  b"¦.\x1Fj\x1A\vE\x19¯@\ebp£qI"
  b"ß7ìÀÇèGÅæ×\rt\r]l\x1A"
  b"›mÈèp(KŠ³X80ƒ…šã"
  b"^ÅOø<œA\v¡k!öqfŒÉ"
  b"\v,QÊD—B³¡l沓RsI"
  b" zHE\x7F\x13NôˆMR‘2\x01Þÿ"
  b"2ý71˸H\x1D¨\vÝ\x19nû»Œ"
  b"f║8È\x12\Cyí\x08üÎbbc\x03"
  b"k®¨ê™ÓL ˜síg2ZÞ–"
  b"n»\ˆoåJå’3+\x01\f`‘ç"
  b"~p8üK KA»y«.4·\x17ÿ"
  b"üJÆ¥%‰J”¯…´÷…òƒÑ"
  b"\x01ÅLK½\x15p|ç4\fu■Eȯ"
  b"\x05€À\x07|µBó•Ê¡=…þB\x16"
  b"œP¯\x11lÞGã‚÷lÔ)6ªz"
  b"ÌçÉÓpfBbÜËfj\x11#kO"
  b"õÖCfk¥Mø´`S\x01\x06Hì;"
  b"·-`\x0EàxDüÆ©+ç┘▄Ä&"
  b"""
    <õA6žmJ/§\n
    ¨hzeü-
    """
  b"TUƒa└\x15GÎÆ┴nÍÞüz┐"
  b"ºË\r\x1FJé§åΰÕ\x15Ëæ"
  b"Ûl■tܹI¾Å┌ir;¤àJ"
  b"ò¿Ku˜‘@@¿ì\x00—³8ù\x04"
  b"\x00VÕª›îG\x16ŒÇ\x0FÊ\ežQ¾"
  b"\x01Å>qA\x0EqÖè\x01▀MWÓÕ/"
  b"\x01Å>x▀8p9ñY:╦╠g╣È"
  b"\x01’‰ÁQ¿tŒªÎšŸL\x1E"
  b"\x01\x06Aìu~öµÿ©è:ó@r"
  b"\x01ôS1=þq\x03│ÉVé«\f┘á"
  b"\x06ÝZınLý\x11Ø\x1A\x00PV¥~ì"
  b"\x07[Éâ\x11cF©║+¢+PR\x1C;"
  b"\x07ÝZınLý\x11Ø\x1A\x00PV¥~ì"
  b"\vÝZınLý\x11Ø\x1A\x00PV¥~ì"
  b"\fÝZınLý\x11Ø\x1A\x00PV¥~ì"
  b"\x101ûâΨE‘¯…Ï}Ù¨\x1F."
  b"\x17?±┐╗µN═üÔ Þ┬\x1E\x16p"
  b"\eÄ–ý,!Cø±úkñˆÂ\x0F»"
  b"1\x1F\x07ƒM\x0EEQ¯ÄªÐ\x1F\x12úm"
  b"7\S\x11▀$F\x04Ø═îµÜnÎ\x02"
  b"8RDè\x1E)Bb‰^ã˜ËÆwñ"
  b"VOrØ\x05ULM©!ì}‗A\x0E©"
  b"^@1§Ú³Là†ÂL\rvb@M"
  b"oìÉ\x1FŠéNG•1\x1Dsa‡q\x04"
  b"u¨a:[┌K1½É\x11æ3Ð"â"
  b"zÕà\x17Â▓M\x1CítÅC0\x13X]"
  b"ø\x15k\x7FVÚJgØ%ìs.h>®"
  b"ƒÐØæ╣ËL╝ɺÁk3IJ×"
  b"ÑR■(°7D╠ƒx{┐┬WÅÞ"
  b"«\x19†…cƒ@Ñ£\rŸúÖ‰ô;"
  b"""
    ®\x11Ù‚ÌýJ\x0F¾ìÎ’\n
    ô–W
    """
  b"¹'vlEGE¦Œmµæ\tÉ\x13r"
  b"├ï├øÊXKþá±É 0.ì*"
  b"Ãñ\\x11n¥Fš¤OÍïnƒ\x17¢"
  b"Ôw¨³Ú³H´¡é'ln\x01¦#"
  b"Ú\x05½”2\x18B\x00¶CBD\x01\fE"
  b"Ü\vQ2ïuAâ®ô”\x1EBðnÛ"
  b"Þ¿|ôY\GQü!\x00Ì(j└t"
  b"ñ \x0FÜ\VL7ƒ.L63\x18"
  b"³d├ì3_O¬»³q8LR8p"
  b"³ýZınLý\x11Ø\x1A\x00PV¥~ì"
  b" ýZınLý\x11Ø\x1A\x00PV¥~ì"
]
0.62 ms
(0.67%)
2
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ý▒iÝ\x11Ø \x00PV¥~ì"
  b"(K¢WÌ$ý\x11Ø\x1A\x00PV¥~ì"
  b"5µ‗¸▒iÝ\x11Ø \x00PV¥~ì"
  b"q\e¢]Ì$ý\x11Ø\x1A\x00PV¥~ì"
  b"yøÆÁ░iÝ\x11Ø \x00PV¥~ì"
  b"â\x0E\x07\x17Ý\x11Ø\e\x00PV¥~ì"
  b"┐o┤cÌ$ý\x11Ø\x1A\x00PV¥~ì"
  b"└J¢WÌ$ý\x11Ø\x1A\x00PV¥~ì"
  b" `└QÌ$ý\x11Ø\x1A\x00PV¥~ì"
  b"pèµ┴ÃæÝ\x11Ø$\x00PV¥~ì"
]
0.62 ms
(0.66%)
1
# header::navigation::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, COALESCE(`category.media.translation.title`,`category.media.translation.title`) as `category.media.title`, `category.media.translation.alt`, COALESCE(`category.media.translation.alt`,`category.media.translation.alt`) as `category.media.alt`, `category.media.translation.customFields`, COALESCE(`category.media.translation.customFields`,`category.media.translation.customFields`) as `category.media.customFields`, `category.media.translation.createdAt`, `category.media.translation.updatedAt`, `category.media.translation.mediaId`, `category.media.translation.languageId`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.link_type as `category.translation.linkType`, `category.translation`.internal_link as `category.translation.internalLink`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.link_new_tab as `category.translation.linkNewTab`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title as `category.media.translation.title`, `category.media.translation`.alt as `category.media.translation.alt`, `category.media.translation`.custom_fields as `category.media.translation.customFields`, `category.media.translation`.created_at as `category.media.translation.createdAt`, `category.media.translation`.updated_at as `category.media.translation.updatedAt`, `category.media.translation`.media_id as `category.media.translation.mediaId`, `category.media.translation`.language_id as `category.media.translation.languageId` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.language_id = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"vèf}\x06\x11Ø \x00PV¥~ì"
  b"˜-·V\x00i@jŠsÉtP%¾‹"
]
0.61 ms
(0.65%)
3
# navigation-route::meta-information
            SELECT LOWER(HEX(`id`)), `path`, `level`
            FROM `category`
            WHERE `id` = ? OR `parent_id` = ? OR `id` = ?
Parameters:
[
  b"1©äL±ENè”ÂïÅë¨Ag"
  b"1©äL±ENè”ÂïÅë¨Ag"
  b"1©äL±ENè”ÂïÅë¨Ag"
]
0.60 ms
(0.64%)
1
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id = ? OR system_config.sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[
  b"äN15ºÖLý»&’ÄA7±ø"
]
0.58 ms
(0.63%)
1
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE ?
Parameters:
[
  "payload"
]
0.53 ms
(0.57%)
1
# theme-service::resolve-media::read
SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, COALESCE(`media.translation.title`,`media.translation.title`) as `media.title`, `media.translation.alt`, COALESCE(`media.translation.alt`,`media.translation.alt`) as `media.alt`, `media.translation.customFields`, COALESCE(`media.translation.customFields`,`media.translation.customFields`) as `media.customFields`, `media.translation.createdAt`, `media.translation.updatedAt`, `media.translation.mediaId`, `media.translation.languageId` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.media_id, `media.translation`.title as `media.translation.title`, `media.translation`.alt as `media.translation.alt`, `media.translation`.custom_fields as `media.translation.customFields`, `media.translation`.created_at as `media.translation.createdAt`, `media.translation`.updated_at as `media.translation.updatedAt`, `media.translation`.media_id as `media.translation.mediaId`, `media.translation`.language_id as `media.translation.languageId` FROM `media_translation` `media.translation` WHERE `media.translation`.language_id = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?, ?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  false
  true
  "product_download"
  b"g(Ò═\x15ÿNkØÝ┐3?óùí"
  b"pO_2\vsF\tƒóòq2ÈØs"
  b"båæ‚)kKA¡+Á«Ó\x06\5"
]
0.53 ms
(0.57%)
1
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[]
0.52 ms
(0.56%)
1
# product-detail-route::association::mainCategories::read
SELECT `main_category`.`id` as `main_category.id`, `main_category`.`product_id` as `main_category.productId`, `main_category`.`product_version_id` as `main_category.productVersionId`, `main_category`.`category_id` as `main_category.categoryId`, `main_category`.`category_version_id` as `main_category.categoryVersionId`, `main_category`.`sales_channel_id` as `main_category.salesChannelId`, `main_category`.`created_at` as `main_category.createdAt`, `main_category`.`updated_at` as `main_category.updatedAt`, `main_category.category`.`id` as `main_category.category.id`, `main_category.category`.`version_id` as `main_category.category.versionId`, `main_category.category`.`parent_id` as `main_category.category.parentId`, `main_category.category`.`parent_version_id` as `main_category.category.parentVersionId`, `main_category.category`.`after_category_id` as `main_category.category.afterCategoryId`, `main_category.category`.`after_category_version_id` as `main_category.category.afterCategoryVersionId`, `main_category.category`.`media_id` as `main_category.category.mediaId`, `main_category.category`.`display_nested_products` as `main_category.category.displayNestedProducts`, `main_category.category`.`auto_increment` as `main_category.category.autoIncrement`, `main_category.category`.`level` as `main_category.category.level`, `main_category.category`.`path` as `main_category.category.path`, `main_category.category`.`child_count` as `main_category.category.childCount`, `main_category.category`.`type` as `main_category.category.type`, `main_category.category`.`product_assignment_type` as `main_category.category.productAssignmentType`, `main_category.category`.`visible` as `main_category.category.visible`, `main_category.category`.`active` as `main_category.category.active`, `main_category.category`.`cms_page_id` as `main_category.category.cmsPageId`, `main_category.category`.`cms_page_version_id` as `main_category.category.cmsPageVersionId`, `main_category.category`.`product_stream_id` as `main_category.category.productStreamId`, `main_category.category`.`custom_entity_type_id` as `main_category.category.customEntityTypeId`, `main_category.category`.`created_at` as `main_category.category.createdAt`, `main_category.category`.`updated_at` as `main_category.category.updatedAt`, `main_category.category.translation.name`, COALESCE(`main_category.category.translation.name`,`main_category.category.translation.name`) as `main_category.category.name`, `main_category.category.translation.breadcrumb`, COALESCE(`main_category.category.translation.breadcrumb`,`main_category.category.translation.breadcrumb`) as `main_category.category.breadcrumb`, `main_category.category.translation.slotConfig`, COALESCE(`main_category.category.translation.slotConfig`,`main_category.category.translation.slotConfig`) as `main_category.category.slotConfig`, `main_category.category.translation.linkType`, COALESCE(`main_category.category.translation.linkType`,`main_category.category.translation.linkType`) as `main_category.category.linkType`, `main_category.category.translation.internalLink`, COALESCE(`main_category.category.translation.internalLink`,`main_category.category.translation.internalLink`) as `main_category.category.internalLink`, `main_category.category.translation.externalLink`, COALESCE(`main_category.category.translation.externalLink`,`main_category.category.translation.externalLink`) as `main_category.category.externalLink`, `main_category.category.translation.linkNewTab`, COALESCE(`main_category.category.translation.linkNewTab`,`main_category.category.translation.linkNewTab`) as `main_category.category.linkNewTab`, `main_category.category.translation.description`, COALESCE(`main_category.category.translation.description`,`main_category.category.translation.description`) as `main_category.category.description`, `main_category.category.translation.metaTitle`, COALESCE(`main_category.category.translation.metaTitle`,`main_category.category.translation.metaTitle`) as `main_category.category.metaTitle`, `main_category.category.translation.metaDescription`, COALESCE(`main_category.category.translation.metaDescription`,`main_category.category.translation.metaDescription`) as `main_category.category.metaDescription`, `main_category.category.translation.keywords`, COALESCE(`main_category.category.translation.keywords`,`main_category.category.translation.keywords`) as `main_category.category.keywords`, `main_category.category.translation.customFields`, COALESCE(`main_category.category.translation.customFields`,`main_category.category.translation.customFields`) as `main_category.category.customFields`, `main_category.category.translation.createdAt`, `main_category.category.translation.updatedAt`, `main_category.category.translation.categoryId`, `main_category.category.translation.languageId`, `main_category.category.translation.categoryVersionId` FROM `main_category` LEFT JOIN `category` `main_category.category` ON `main_category`.`category_id` = `main_category.category`.`id` AND `main_category`.`category_version_id` = `main_category.category`.`version_id` LEFT JOIN (SELECT `main_category.category.translation`.category_id, `main_category.category.translation`.category_version_id, `main_category.category.translation`.name as `main_category.category.translation.name`, `main_category.category.translation`.breadcrumb as `main_category.category.translation.breadcrumb`, `main_category.category.translation`.slot_config as `main_category.category.translation.slotConfig`, `main_category.category.translation`.link_type as `main_category.category.translation.linkType`, `main_category.category.translation`.internal_link as `main_category.category.translation.internalLink`, `main_category.category.translation`.external_link as `main_category.category.translation.externalLink`, `main_category.category.translation`.link_new_tab as `main_category.category.translation.linkNewTab`, `main_category.category.translation`.description as `main_category.category.translation.description`, `main_category.category.translation`.meta_title as `main_category.category.translation.metaTitle`, `main_category.category.translation`.meta_description as `main_category.category.translation.metaDescription`, `main_category.category.translation`.keywords as `main_category.category.translation.keywords`, `main_category.category.translation`.custom_fields as `main_category.category.translation.customFields`, `main_category.category.translation`.created_at as `main_category.category.translation.createdAt`, `main_category.category.translation`.updated_at as `main_category.category.translation.updatedAt`, `main_category.category.translation`.category_id as `main_category.category.translation.categoryId`, `main_category.category.translation`.language_id as `main_category.category.translation.languageId`, `main_category.category.translation`.category_version_id as `main_category.category.translation.categoryVersionId` FROM `category_translation` `main_category.category.translation` WHERE `main_category.category.translation`.language_id = ?) `main_category.category.category_translation` ON `main_category.category.category_translation`.`category_id` = `main_category.category`.`id` AND `main_category.category.category_translation`.category_version_id = `main_category.category`.version_id WHERE (`main_category`.`sales_channel_id` = ? AND `main_category`.`product_id` IN (?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"äN15ºÖLý»&’ÄA7±ø"
  b"╦o┤cÌ$ý\x11Ø\x1A\x00PV¥~ì"
]
0.51 ms
(0.55%)
1
SELECT CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') `key`, CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') url, LOWER(HEX(domain.id)) id, LOWER(HEX(sales_channel.id)) salesChannelId, LOWER(HEX(sales_channel.type_id)) typeId, LOWER(HEX(domain.snippet_set_id)) snippetSetId, LOWER(HEX(domain.currency_id)) currencyId, LOWER(HEX(domain.language_id)) languageId, LOWER(HEX(theme.id)) themeId, sales_channel.maintenance maintenance, sales_channel.maintenance_ip_whitelist maintenanceIpWhitelist, snippet_set.iso as locale, theme.technical_name as themeName, parentTheme.technical_name as parentThemeName FROM sales_channel INNER JOIN sales_channel_domain domain ON domain.sales_channel_id = sales_channel.id LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id INNER JOIN snippet_set snippet_set ON snippet_set.id = domain.snippet_set_id LEFT JOIN theme theme ON theme_sales_channel.theme_id = theme.id LEFT JOIN theme parentTheme ON theme.parent_theme_id = parentTheme.id WHERE (sales_channel.type_id = UNHEX(?)) AND (sales_channel.active)
Parameters:
[
  "8a243080f92e4c719546314b577cf82b"
]
0.50 ms
(0.53%)
1
# breadcrumb-builder::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.link_type as `category.translation.linkType`, `category.translation`.internal_link as `category.translation.internalLink`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.link_new_tab as `category.translation.linkNewTab`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"vèf}\x06\x11Ø \x00PV¥~ì"
]
0.47 ms
(0.50%)
1
# product-detail-route::find-best-variant::search-ids
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((`product`.`parent_id` = ? AND ((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?))) ORDER BY `product`.`available` DESC, IFNULL((ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) + 0.0))) as DECIMAL(30, 20)), 2)) * 100, 0) / 100), (ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) + 0.0))) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)) ASC LIMIT 1
Parameters:
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"╦o┤cÌ$ý\x11Ø\x1A\x00PV¥~ì"
  10
  b"äN15ºÖLý»&’ÄA7±ø"
  true
]
0.44 ms
(0.48%)
1
# header::languages::read
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.productSearchConfig`.`id` as `language.productSearchConfig.id`, `language.productSearchConfig`.`language_id` as `language.productSearchConfig.languageId`, `language.productSearchConfig`.`and_logic` as `language.productSearchConfig.andLogic`, `language.productSearchConfig`.`min_search_length` as `language.productSearchConfig.minSearchLength`, `language.productSearchConfig`.`excluded_terms` as `language.productSearchConfig.excludedTerms`, `language.productSearchConfig`.`created_at` as `language.productSearchConfig.createdAt`, `language.productSearchConfig`.`updated_at` as `language.productSearchConfig.updatedAt`, `language.translationCode`.`id` as `language.translationCode.id`, `language.translationCode`.`code` as `language.translationCode.code`, `language.translationCode`.`created_at` as `language.translationCode.createdAt`, `language.translationCode`.`updated_at` as `language.translationCode.updatedAt`, `language.translationCode.translation.name`, COALESCE(`language.translationCode.translation.name`,`language.translationCode.translation.name`) as `language.translationCode.name`, `language.translationCode.translation.territory`, COALESCE(`language.translationCode.translation.territory`,`language.translationCode.translation.territory`) as `language.translationCode.territory`, `language.translationCode.translation.customFields`, COALESCE(`language.translationCode.translation.customFields`,`language.translationCode.translation.customFields`) as `language.translationCode.customFields`, `language.translationCode.translation.createdAt`, `language.translationCode.translation.updatedAt`, `language.translationCode.translation.localeId`, `language.translationCode.translation.languageId` FROM `language` LEFT JOIN `product_search_config` `language.productSearchConfig` ON `language`.`id` = `language.productSearchConfig`.`language_id` LEFT JOIN `locale` `language.translationCode` ON `language`.`translation_code_id` = `language.translationCode`.`id` LEFT JOIN (SELECT `language.translationCode.translation`.locale_id, `language.translationCode.translation`.name as `language.translationCode.translation.name`, `language.translationCode.translation`.territory as `language.translationCode.translation.territory`, `language.translationCode.translation`.custom_fields as `language.translationCode.translation.customFields`, `language.translationCode.translation`.created_at as `language.translationCode.translation.createdAt`, `language.translationCode.translation`.updated_at as `language.translationCode.translation.updatedAt`, `language.translationCode.translation`.locale_id as `language.translationCode.translation.localeId`, `language.translationCode.translation`.language_id as `language.translationCode.translation.languageId` FROM `locale_translation` `language.translationCode.translation` WHERE `language.translationCode.translation`.language_id = ?) `language.translationCode.locale_translation` ON `language.translationCode.locale_translation`.`locale_id` = `language.translationCode`.`id` WHERE `language`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
0.43 ms
(0.46%)
1
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"äN15ºÖLý»&’ÄA7±ø"
  true
  b"└J¢WÌ$ý\x11Ø\x1A\x00PV¥~ì"
  b"5µ‗¸▒iÝ\x11Ø \x00PV¥~ì"
  b"\x01ý▒iÝ\x11Ø \x00PV¥~ì"
  b"q\e¢]Ì$ý\x11Ø\x1A\x00PV¥~ì"
]
0.41 ms
(0.44%)
1
# generic-page::shipping-methods::search-ids
SELECT `shipping_method`.`id` FROM `shipping_method` LEFT JOIN `sales_channel_shipping_method` `shipping_method.salesChannels.mapping` ON `shipping_method`.`id` = `shipping_method.salesChannels.mapping`.`shipping_method_id`  LEFT JOIN (SELECT `shipping_method.translation`.shipping_method_id, `shipping_method.translation`.name as `shipping_method.translation.name`, `shipping_method.translation`.description as `shipping_method.translation.description`, `shipping_method.translation`.tracking_url as `shipping_method.translation.trackingUrl`, `shipping_method.translation`.custom_fields as `shipping_method.translation.customFields`, `shipping_method.translation`.created_at as `shipping_method.translation.createdAt`, `shipping_method.translation`.updated_at as `shipping_method.translation.updatedAt`, `shipping_method.translation`.shipping_method_id as `shipping_method.translation.shippingMethodId`, `shipping_method.translation`.language_id as `shipping_method.translation.languageId` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.language_id = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `sales_channel` `shipping_method.salesChannels` ON `shipping_method.salesChannels.mapping`.`sales_channel_id` = `shipping_method.salesChannels`.`id`  WHERE (`shipping_method`.`active` = ? AND `shipping_method.salesChannels`.`id` = ?) GROUP BY `shipping_method`.`id` ORDER BY MIN(`shipping_method`.`position`) ASC, MIN(COALESCE(`shipping_method.translation.name`)) ASC
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  b"äN15ºÖLý»&’ÄA7±ø"
]
0.39 ms
(0.42%)
1
# product-detail-route::association::media::read
SELECT `product_media`.`id` as `product_media.id`, `product_media`.`version_id` as `product_media.versionId`, `product_media`.`product_id` as `product_media.productId`, `product_media`.`product_version_id` as `product_media.productVersionId`, `product_media`.`media_id` as `product_media.mediaId`, `product_media`.`position` as `product_media.position`, `product_media.media`.`id` as `product_media.media.id`, `product_media.media`.`user_id` as `product_media.media.userId`, `product_media.media`.`media_folder_id` as `product_media.media.mediaFolderId`, `product_media.media`.`mime_type` as `product_media.media.mimeType`, `product_media.media`.`file_extension` as `product_media.media.fileExtension`, `product_media.media`.`uploaded_at` as `product_media.media.uploadedAt`, `product_media.media`.`file_name` as `product_media.media.fileName`, `product_media.media`.`file_size` as `product_media.media.fileSize`, `product_media.media`.`media_type` as `product_media.media.mediaTypeRaw`, `product_media.media`.`meta_data` as `product_media.media.metaData`, `product_media.media`.`config` as `product_media.media.config`, `product_media.media`.`path` as `product_media.media.path`, `product_media.media`.`private` as `product_media.media.private`, `product_media.media`.`thumbnails_ro` as `product_media.media.thumbnailsRo`, `product_media.media`.`created_at` as `product_media.media.createdAt`, `product_media.media`.`updated_at` as `product_media.media.updatedAt`, `product_media.media.translation.title`, COALESCE(`product_media.media.translation.title`,`product_media.media.translation.title`) as `product_media.media.title`, `product_media.media.translation.alt`, COALESCE(`product_media.media.translation.alt`,`product_media.media.translation.alt`) as `product_media.media.alt`, `product_media.media.translation.customFields`, COALESCE(`product_media.media.translation.customFields`,`product_media.media.translation.customFields`) as `product_media.media.customFields`, `product_media.media.translation.createdAt`, `product_media.media.translation.updatedAt`, `product_media.media.translation.mediaId`, `product_media.media.translation.languageId`, `product_media`.`custom_fields` as `product_media.customFields`, `product_media`.`created_at` as `product_media.createdAt`, `product_media`.`updated_at` as `product_media.updatedAt` FROM `product_media` LEFT JOIN `media` `product_media.media` ON `product_media`.`media_id` = `product_media.media`.`id` LEFT JOIN (SELECT `product_media.media.translation`.media_id, `product_media.media.translation`.title as `product_media.media.translation.title`, `product_media.media.translation`.alt as `product_media.media.translation.alt`, `product_media.media.translation`.custom_fields as `product_media.media.translation.customFields`, `product_media.media.translation`.created_at as `product_media.media.translation.createdAt`, `product_media.media.translation`.updated_at as `product_media.media.translation.updatedAt`, `product_media.media.translation`.media_id as `product_media.media.translation.mediaId`, `product_media.media.translation`.language_id as `product_media.media.translation.languageId` FROM `media_translation` `product_media.media.translation` WHERE `product_media.media.translation`.language_id = ?) `product_media.media.media_translation` ON `product_media.media.media_translation`.`media_id` = `product_media.media`.`id` WHERE (`product_media`.`version_id` = ?) AND ((`product_media`.`product_id` IN (?)))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"╦o┤cÌ$ý\x11Ø\x1A\x00PV¥~ì"
]
0.39 ms
(0.42%)
1
# base-context-factory::country::read
SELECT `country`.`id` as `country.id`, `country`.`iso` as `country.iso`, `country`.`position` as `country.position`, `country`.`active` as `country.active`, `country`.`shipping_available` as `country.shippingAvailable`, `country`.`iso3` as `country.iso3`, `country`.`display_state_in_registration` as `country.displayStateInRegistration`, `country`.`force_state_in_registration` as `country.forceStateInRegistration`, `country`.`check_vat_id_pattern` as `country.checkVatIdPattern`, `country`.`vat_id_required` as `country.vatIdRequired`, `country`.`vat_id_pattern` as `country.vatIdPattern`, `country`.`customer_tax` as `country.customerTax`, `country`.`company_tax` as `country.companyTax`, `country`.`postal_code_required` as `country.postalCodeRequired`, `country`.`check_postal_code_pattern` as `country.checkPostalCodePattern`, `country`.`check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern`, `country`.`advanced_postal_code_pattern` as `country.advancedPostalCodePattern`, `country`.`default_postal_code_pattern` as `country.defaultPostalCodePattern`, `country`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, `country.translation.name`, COALESCE(`country.translation.name`,`country.translation.name`) as `country.name`, `country.translation.addressFormat`, COALESCE(`country.translation.addressFormat`,`country.translation.addressFormat`) as `country.addressFormat`, `country.translation.customFields`, COALESCE(`country.translation.customFields`,`country.translation.customFields`) as `country.customFields`, `country.translation.createdAt`, `country.translation.updatedAt`, `country.translation.countryId`, `country.translation.languageId` FROM `country` LEFT JOIN (SELECT `country.translation`.country_id, `country.translation`.name as `country.translation.name`, `country.translation`.address_format as `country.translation.addressFormat`, `country.translation`.custom_fields as `country.translation.customFields`, `country.translation`.created_at as `country.translation.createdAt`, `country.translation`.updated_at as `country.translation.updatedAt`, `country.translation`.country_id as `country.translation.countryId`, `country.translation`.language_id as `country.translation.languageId` FROM `country_translation` `country.translation` WHERE `country.translation`.language_id = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"¸)ÿá†\x05FJºìs‚¶\x1Dq}"
]
0.38 ms
(0.41%)
1
# base-context-factory::customer-group::read
SELECT `customer_group`.`id` as `customer_group.id`, `customer_group`.`display_gross` as `customer_group.displayGross`, `customer_group`.`registration_active` as `customer_group.registrationActive`, `customer_group`.`created_at` as `customer_group.createdAt`, `customer_group`.`updated_at` as `customer_group.updatedAt`, `customer_group.translation.name`, COALESCE(`customer_group.translation.name`,`customer_group.translation.name`) as `customer_group.name`, `customer_group.translation.registrationTitle`, COALESCE(`customer_group.translation.registrationTitle`,`customer_group.translation.registrationTitle`) as `customer_group.registrationTitle`, `customer_group.translation.registrationIntroduction`, COALESCE(`customer_group.translation.registrationIntroduction`,`customer_group.translation.registrationIntroduction`) as `customer_group.registrationIntroduction`, `customer_group.translation.registrationOnlyCompanyRegistration`, COALESCE(`customer_group.translation.registrationOnlyCompanyRegistration`,`customer_group.translation.registrationOnlyCompanyRegistration`) as `customer_group.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationSeoMetaDescription`, COALESCE(`customer_group.translation.registrationSeoMetaDescription`,`customer_group.translation.registrationSeoMetaDescription`) as `customer_group.registrationSeoMetaDescription`, `customer_group.translation.customFields`, COALESCE(`customer_group.translation.customFields`,`customer_group.translation.customFields`) as `customer_group.customFields`, `customer_group.translation.createdAt`, `customer_group.translation.updatedAt`, `customer_group.translation.customerGroupId`, `customer_group.translation.languageId` FROM `customer_group` LEFT JOIN (SELECT `customer_group.translation`.customer_group_id, `customer_group.translation`.name as `customer_group.translation.name`, `customer_group.translation`.registration_title as `customer_group.translation.registrationTitle`, `customer_group.translation`.registration_introduction as `customer_group.translation.registrationIntroduction`, `customer_group.translation`.registration_only_company_registration as `customer_group.translation.registrationOnlyCompanyRegistration`, `customer_group.translation`.registration_seo_meta_description as `customer_group.translation.registrationSeoMetaDescription`, `customer_group.translation`.custom_fields as `customer_group.translation.customFields`, `customer_group.translation`.created_at as `customer_group.translation.createdAt`, `customer_group.translation`.updated_at as `customer_group.translation.updatedAt`, `customer_group.translation`.customer_group_id as `customer_group.translation.customerGroupId`, `customer_group.translation`.language_id as `customer_group.translation.languageId` FROM `customer_group_translation` `customer_group.translation` WHERE `customer_group.translation`.language_id = ?) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation`.`customer_group_id` = `customer_group`.`id` WHERE `customer_group`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"¤¢P\x18ËìAÏ¡╩\x10┘O╚¢Í"
]
0.37 ms
(0.40%)
1
# context-factory::base-context

        SELECT
          sales_channel.id as sales_channel_id,
          sales_channel.language_id as sales_channel_default_language_id,
          sales_channel.currency_id as sales_channel_currency_id,
          currency.factor as sales_channel_currency_factor,
          GROUP_CONCAT(LOWER(HEX(sales_channel_language.language_id))) as sales_channel_language_ids
        FROM sales_channel
            INNER JOIN currency
                ON sales_channel.currency_id = currency.id
            LEFT JOIN sales_channel_language
                ON sales_channel_language.sales_channel_id = sales_channel.id
        WHERE sales_channel.id = ?
        GROUP BY sales_channel.id, sales_channel.language_id, sales_channel.currency_id, currency.factor
Parameters:
[
  b"äN15ºÖLý»&’ÄA7±ø"
]
0.35 ms
(0.38%)
1
# header::currencies::search-ids
SELECT `currency`.`id` FROM `currency` LEFT JOIN `sales_channel_currency` `currency.salesChannels.mapping` ON `currency`.`id` = `currency.salesChannels.mapping`.`currency_id`  LEFT JOIN `sales_channel` `currency.salesChannels` ON `currency.salesChannels.mapping`.`sales_channel_id` = `currency.salesChannels`.`id`  WHERE (`currency.salesChannels`.`id` = ?) GROUP BY `currency`.`id`
Parameters:
[
  b"äN15ºÖLý»&’ÄA7±ø"
]
0.35 ms
(0.37%)
1
# header::languages::search-ids
SELECT `language`.`id` FROM `language` LEFT JOIN `sales_channel_domain` `language.salesChannelDomains` ON `language`.`id` = `language.salesChannelDomains`.`language_id` LEFT JOIN `sales_channel_language` `language.salesChannels.mapping` ON `language`.`id` = `language.salesChannels.mapping`.`language_id`  LEFT JOIN `sales_channel` `language.salesChannels` ON `language.salesChannels.mapping`.`sales_channel_id` = `language.salesChannels`.`id`  WHERE (`language.salesChannelDomains`.`sales_channel_id` = ? AND `language.salesChannels`.`id` = ?) GROUP BY `language`.`id` ORDER BY MIN(`language`.`name`) ASC
Parameters:
[
  b"äN15ºÖLý»&’ÄA7±ø"
  b"äN15ºÖLý»&’ÄA7±ø"
]
0.33 ms
(0.36%)
1
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
0.33 ms
(0.36%)
1
# base-context-factory::currency::read
SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.shortName`, COALESCE(`currency.translation.shortName`,`currency.translation.shortName`) as `currency.shortName`, `currency.translation.name`, COALESCE(`currency.translation.name`,`currency.translation.name`) as `currency.name`, `currency.translation.customFields`, COALESCE(`currency.translation.customFields`,`currency.translation.customFields`) as `currency.customFields`, `currency.translation.createdAt`, `currency.translation.updatedAt`, `currency.translation.currencyId`, `currency.translation.languageId` FROM `currency` LEFT JOIN (SELECT `currency.translation`.currency_id, `currency.translation`.short_name as `currency.translation.shortName`, `currency.translation`.name as `currency.translation.name`, `currency.translation`.custom_fields as `currency.translation.customFields`, `currency.translation`.created_at as `currency.translation.createdAt`, `currency.translation`.updated_at as `currency.translation.updatedAt`, `currency.translation`.currency_id as `currency.translation.currencyId`, `currency.translation`.language_id as `currency.translation.languageId` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.language_id = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
0.32 ms
(0.35%)
1
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ý▒iÝ\x11Ø \x00PV¥~ì"
  b"5µ‗¸▒iÝ\x11Ø \x00PV¥~ì"
  b"q\e¢]Ì$ý\x11Ø\x1A\x00PV¥~ì"
  b"└J¢WÌ$ý\x11Ø\x1A\x00PV¥~ì"
]
0.32 ms
(0.34%)
1
# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND (seo_path_info = ?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"äN15ºÖLý»&’ÄA7±ø"
  "detail/cb6fb463de24ec119d1a005056be7e8d"
]
0.31 ms
(0.34%)
1
# generic-page::payment-methods::search-ids
SELECT `payment_method`.`id` FROM `payment_method` LEFT JOIN `sales_channel_payment_method` `payment_method.salesChannels.mapping` ON `payment_method`.`id` = `payment_method.salesChannels.mapping`.`payment_method_id`  LEFT JOIN `sales_channel` `payment_method.salesChannels` ON `payment_method.salesChannels.mapping`.`sales_channel_id` = `payment_method.salesChannels`.`id`  WHERE (`payment_method`.`active` = ? AND `payment_method.salesChannels`.`id` = ?) GROUP BY `payment_method`.`id` ORDER BY MIN(`payment_method`.`position`) ASC
Parameters:
[
  true
  b"äN15ºÖLý»&’ÄA7±ø"
]
0.31 ms
(0.33%)
1
# header::currencies::read
SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.shortName`, COALESCE(`currency.translation.shortName`,`currency.translation.shortName`) as `currency.shortName`, `currency.translation.name`, COALESCE(`currency.translation.name`,`currency.translation.name`) as `currency.name`, `currency.translation.customFields`, COALESCE(`currency.translation.customFields`,`currency.translation.customFields`) as `currency.customFields`, `currency.translation.createdAt`, `currency.translation.updatedAt`, `currency.translation.currencyId`, `currency.translation.languageId` FROM `currency` LEFT JOIN (SELECT `currency.translation`.currency_id, `currency.translation`.short_name as `currency.translation.shortName`, `currency.translation`.name as `currency.translation.name`, `currency.translation`.custom_fields as `currency.translation.customFields`, `currency.translation`.created_at as `currency.translation.createdAt`, `currency.translation`.updated_at as `currency.translation.updatedAt`, `currency.translation`.currency_id as `currency.translation.currencyId`, `currency.translation`.language_id as `currency.translation.languageId` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.language_id = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
0.29 ms
(0.31%)
1
# theme-service::load-config::read
SELECT `theme`.`id` as `theme.id`, `theme`.`technical_name` as `theme.technicalName`, `theme`.`name` as `theme.name`, `theme`.`author` as `theme.author`, `theme`.`preview_media_id` as `theme.previewMediaId`, `theme`.`parent_theme_id` as `theme.parentThemeId`, `theme`.`theme_json` as `theme.themeJson`, `theme`.`base_config` as `theme.baseConfig`, `theme`.`config_values` as `theme.configValues`, `theme`.`active` as `theme.active`, `theme`.`created_at` as `theme.createdAt`, `theme`.`updated_at` as `theme.updatedAt`, `theme.translation.description`, COALESCE(`theme.translation.description`,`theme.translation.description`) as `theme.description`, `theme.translation.labels`, COALESCE(`theme.translation.labels`,`theme.translation.labels`) as `theme.labels`, `theme.translation.helpTexts`, COALESCE(`theme.translation.helpTexts`,`theme.translation.helpTexts`) as `theme.helpTexts`, `theme.translation.customFields`, COALESCE(`theme.translation.customFields`,`theme.translation.customFields`) as `theme.customFields`, `theme.translation.createdAt`, `theme.translation.updatedAt`, `theme.translation.themeId`, `theme.translation.languageId` FROM `theme` LEFT JOIN (SELECT `theme.translation`.theme_id, `theme.translation`.description as `theme.translation.description`, `theme.translation`.labels as `theme.translation.labels`, `theme.translation`.help_texts as `theme.translation.helpTexts`, `theme.translation`.custom_fields as `theme.translation.customFields`, `theme.translation`.created_at as `theme.translation.createdAt`, `theme.translation`.updated_at as `theme.translation.updatedAt`, `theme.translation`.theme_id as `theme.translation.themeId`, `theme.translation`.language_id as `theme.translation.languageId` FROM `theme_translation` `theme.translation` WHERE `theme.translation`.language_id = ?) `theme.theme_translation` ON `theme.theme_translation`.`theme_id` = `theme`.`id`
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
0.28 ms
(0.30%)
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:
[]
0.28 ms
(0.30%)
1
# product-review-route::aggregation::customer-login-filter
SELECT `product_review`.`points` as `ratingMatrix.key`, COUNT(`product_review`.`id`) as `ratingMatrix.count` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` WHERE ((((`product_review`.`status` = ?) AND (`product_review.product`.`id` = ? OR `product_review.product`.`parent_id` = ?)))) AND (((`product_review`.`status` = ?))) GROUP BY `product_review`.`points`
Parameters:
[
  true
  b"╦o┤cÌ$ý\x11Ø\x1A\x00PV¥~ì"
  b"╦o┤cÌ$ý\x11Ø\x1A\x00PV¥~ì"
  true
]
0.28 ms
(0.30%)
1
# seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (path_info = ?) AND (is_canonical = 1) LIMIT 1
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"äN15ºÖLý»&’ÄA7±ø"
  "/detail/cb6fb463de24ec119d1a005056be7e8d"
]
0.27 ms
(0.29%)
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"\2úÆg<@9¾¥2¤ü¦a¼"
  b"\x16\x13┬#þ\x13DO▓ÿż¬ Z╚"
  b"'¾R-ÖÔF\x0F¦·‘ªTe÷ö"
  b"\rç\x07‘ìB\x05Œø\x18§o\x18†Ì"
  b"ß7ìÀÇèGÅæ×\rt\r]l\x1A"
  b"œP¯\x11lÞGã‚÷lÔ)6ªz"
  b"ÌçÉÓpfBbÜËfj\x11#kO"
  b"õÖCfk¥Mø´`S\x01\x06Hì;"
  b"\x07[Éâ\x11cF©║+¢+PR\x1C;"
  b"\eÄ–ý,!Cø±úkñˆÂ\x0F»"
  b"zÕà\x17Â▓M\x1CítÅC0\x13X]"
  b"ƒÐØæ╣ËL╝ɺÁk3IJ×"
]
0.26 ms
(0.28%)
1
# product-detail-route::search-ids
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?))) AND (`product`.`id` IN (?)) GROUP BY `product`.`id`
Parameters:
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  10
  b"äN15ºÖLý»&’ÄA7±ø"
  true
  b"╦o┤cÌ$ý\x11Ø\x1A\x00PV¥~ì"
]
0.26 ms
(0.27%)
1
# product-cross-selling-route::read
SELECT `product_cross_selling`.`id` as `product_cross_selling.id`, `product_cross_selling`.`position` as `product_cross_selling.position`, `product_cross_selling`.`sort_by` as `product_cross_selling.sortBy`, `product_cross_selling`.`sort_direction` as `product_cross_selling.sortDirection`, `product_cross_selling`.`type` as `product_cross_selling.type`, `product_cross_selling`.`active` as `product_cross_selling.active`, `product_cross_selling`.`limit` as `product_cross_selling.limit`, `product_cross_selling`.`product_id` as `product_cross_selling.productId`, `product_cross_selling`.`product_version_id` as `product_cross_selling.productVersionId`, `product_cross_selling`.`product_stream_id` as `product_cross_selling.productStreamId`, `product_cross_selling`.`created_at` as `product_cross_selling.createdAt`, `product_cross_selling`.`updated_at` as `product_cross_selling.updatedAt`, `product_cross_selling.translation.name`, COALESCE(`product_cross_selling.translation.name`,`product_cross_selling.translation.name`) as `product_cross_selling.name`, `product_cross_selling.translation.createdAt`, `product_cross_selling.translation.updatedAt`, `product_cross_selling.translation.productCrossSellingId`, `product_cross_selling.translation.languageId` FROM `product_cross_selling` LEFT JOIN (SELECT `product_cross_selling.translation`.product_cross_selling_id, `product_cross_selling.translation`.name as `product_cross_selling.translation.name`, `product_cross_selling.translation`.created_at as `product_cross_selling.translation.createdAt`, `product_cross_selling.translation`.updated_at as `product_cross_selling.translation.updatedAt`, `product_cross_selling.translation`.product_cross_selling_id as `product_cross_selling.translation.productCrossSellingId`, `product_cross_selling.translation`.language_id as `product_cross_selling.translation.languageId` FROM `product_cross_selling_translation` `product_cross_selling.translation` WHERE `product_cross_selling.translation`.language_id = ?) `product_cross_selling.product_cross_selling_translation` ON `product_cross_selling.product_cross_selling_translation`.`product_cross_selling_id` = `product_cross_selling`.`id` WHERE `product_cross_selling`.`id` IN (?, ?, ?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x15›"aÝE\x1Cžœ&eÛ;\x15S"
  b"Øo°;ãzKW▒Åv│h-îò"
  b"""
    Ë wÚ&\n
    Ms”[\x10Wg‹&•
    """
]
0.25 ms
(0.27%)
1
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.name`, COALESCE(`language.locale.translation.name`,`language.locale.translation.name`) as `language.locale.name`, `language.locale.translation.territory`, COALESCE(`language.locale.translation.territory`,`language.locale.translation.territory`) as `language.locale.territory`, `language.locale.translation.customFields`, COALESCE(`language.locale.translation.customFields`,`language.locale.translation.customFields`) as `language.locale.customFields`, `language.locale.translation.createdAt`, `language.locale.translation.updatedAt`, `language.locale.translation.localeId`, `language.locale.translation.languageId` FROM `language` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.locale.translation`.locale_id, `language.locale.translation`.name as `language.locale.translation.name`, `language.locale.translation`.territory as `language.locale.translation.territory`, `language.locale.translation`.custom_fields as `language.locale.translation.customFields`, `language.locale.translation`.created_at as `language.locale.translation.createdAt`, `language.locale.translation`.updated_at as `language.locale.translation.updatedAt`, `language.locale.translation`.locale_id as `language.locale.translation.localeId`, `language.locale.translation`.language_id as `language.locale.translation.languageId` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation`.language_id = ?) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE `language`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
0.24 ms
(0.26%)
1
# cart-rule-loader::load-rules::search-ids
SELECT `rule`.`id` FROM `rule` ORDER BY `rule`.`priority` DESC, `rule`.`id` ASC LIMIT 500
Parameters:
[]
0.24 ms
(0.26%)
1
SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, parentLocale.code AS parentCode, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id LEFT JOIN language parentLanguage ON language.parent_id = parentLanguage.id LEFT JOIN locale parentLocale ON parentLanguage.translation_code_id = parentLocale.id
Parameters:
[]
0.24 ms
(0.25%)
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:
[]
0.23 ms
(0.25%)
1
SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id`  LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id`  WHERE ((`country.salesChannels`.`id` = ?)) AND (`country`.`id` IN (?)) GROUP BY `country`.`id`
Parameters:
[
  b"äN15ºÖLý»&’ÄA7±ø"
  b"¸)ÿá†\x05FJºìs‚¶\x1Dq}"
]
0.21 ms
(0.23%)
1
# product-cross-selling-route::search-ids
SELECT `product_cross_selling`.`id` FROM `product_cross_selling` LEFT JOIN `product` `product_cross_selling.product` ON `product_cross_selling`.`product_id` = `product_cross_selling.product`.`crossSellings` AND `product_cross_selling`.`product_version_id` = `product_cross_selling.product`.`version_id` LEFT JOIN `product` `product_cross_selling.product.parent` ON `product_cross_selling.product`.`parent_id` = `product_cross_selling.product.parent`.`id` AND `product_cross_selling.product`.`parent_version_id` = `product_cross_selling.product.parent`.`version_id` WHERE (`product_cross_selling.product`.`id` = ? AND `product_cross_selling`.`active` = ?) ORDER BY `product_cross_selling`.`position` ASC
Parameters:
[
  b"╦o┤cÌ$ý\x11Ø\x1A\x00PV¥~ì"
  1
]
0.21 ms
(0.22%)
1
# base-context-factory::cash-rounding::search-ids
SELECT `currency_country_rounding`.`id` FROM `currency_country_rounding` WHERE (`currency_country_rounding`.`currency_id` = ? AND `currency_country_rounding`.`country_id` = ?) LIMIT 1
Parameters:
[
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
  b"¸)ÿá†\x05FJºìs‚¶\x1Dq}"
]
0.21 ms
(0.22%)
1
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[
  b"äN15ºÖLý»&’ÄA7±ø"
  "w9pUAJLkeakvetnKX43Yfp2OVhzsfi8P"
]
0.20 ms
(0.22%)
1
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters:
[]
0.20 ms
(0.22%)
1
# base-context-factory::sales-channel::association::domains::read
SELECT `sales_channel_domain`.`id` as `sales_channel_domain.id`, `sales_channel_domain`.`url` as `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt` FROM `sales_channel_domain` WHERE (`sales_channel_domain`.`sales_channel_id` IN (?))
Parameters:
[
  b"äN15ºÖLý»&’ÄA7±ø"
]
0.20 ms
(0.21%)
1
# breadcrumb-builder::main-category::search-ids
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `main_category` `category.mainCategories` ON `category`.`id` = `category.mainCategories`.`category_id` AND `category`.version_id = `category.mainCategories`.category_version_id WHERE (`category`.`version_id` = ?) AND (((`category.mainCategories`.`product_id` = ? AND `category.mainCategories`.`sales_channel_id` = ? AND (`category`.`path` LIKE ? OR `category`.`path` LIKE ?)))) LIMIT 1
Parameters:
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"╦o┤cÌ$ý\x11Ø\x1A\x00PV¥~ì"
  b"äN15ºÖLý»&’ÄA7±ø"
  "%|31a9e44cb1454ee894c2efc5eba84167|%"
  "%|982db7560069406a8a73c9745025be8b|%"
]
0.19 ms
(0.21%)
1
# product-cross-selling-route::association::assignedProducts::read
SELECT `product_cross_selling_assigned_products`.`id` as `product_cross_selling_assigned_products.id`, `product_cross_selling_assigned_products`.`cross_selling_id` as `product_cross_selling_assigned_products.crossSellingId`, `product_cross_selling_assigned_products`.`product_id` as `product_cross_selling_assigned_products.productId`, `product_cross_selling_assigned_products`.`product_version_id` as `product_cross_selling_assigned_products.productVersionId`, `product_cross_selling_assigned_products`.`position` as `product_cross_selling_assigned_products.position`, `product_cross_selling_assigned_products`.`created_at` as `product_cross_selling_assigned_products.createdAt`, `product_cross_selling_assigned_products`.`updated_at` as `product_cross_selling_assigned_products.updatedAt` FROM `product_cross_selling_assigned_products` WHERE (`product_cross_selling_assigned_products`.`cross_selling_id` IN (?, ?, ?))
Parameters:
[
  b"\x15›"aÝE\x1Cžœ&eÛ;\x15S"
  b"Øo°;ãzKW▒Åv│h-îò"
  b"""
    Ë wÚ&\n
    Ms”[\x10Wg‹&•
    """
]
0.19 ms
(0.20%)
1
SELECT COUNT(*) FROM (# product-review-route::search-ids
SELECT `product_review`.`id` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` WHERE (((`product_review`.`status` = ?) AND (`product_review.product`.`id` = ? OR `product_review.product`.`parent_id` = ?)))) total
Parameters:
[
  true
  b"╦o┤cÌ$ý\x11Ø\x1A\x00PV¥~ì"
  b"╦o┤cÌ$ý\x11Ø\x1A\x00PV¥~ì"
]
0.18 ms
(0.20%)
1
# product-review-route::search-ids
SELECT `product_review`.`id` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` WHERE (((`product_review`.`status` = ?) AND (`product_review.product`.`id` = ? OR `product_review.product`.`parent_id` = ?))) ORDER BY `product_review`.`created_at` DESC LIMIT 10
Parameters:
[
  true
  b"╦o┤cÌ$ý\x11Ø\x1A\x00PV¥~ì"
  b"╦o┤cÌ$ý\x11Ø\x1A\x00PV¥~ì"
]
0.18 ms
(0.19%)
1
SELECT LOWER(HEX(theme.id)) themeId, theme.technical_name as themeName, parentTheme.technical_name as parentThemeName
            FROM sales_channel
                LEFT JOIN theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id
                LEFT JOIN theme ON theme_sales_channel.theme_id = theme.id
                LEFT JOIN theme AS parentTheme ON parentTheme.id = theme.parent_theme_id
            WHERE sales_channel.id = ?
Parameters:
[
  b"äN15ºÖLý»&’ÄA7±ø"
]
0.17 ms
(0.18%)
1
# breadcrumb-builder::search-ids
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` WHERE (`category`.`version_id` = ?) AND ((`category`.`active` = ? AND (`category`.`path` LIKE ? OR `category`.`path` LIKE ?))) AND (`category`.`id` IN (?, ?, ?)) LIMIT 1
Parameters:
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  true
  "%|31a9e44cb1454ee894c2efc5eba84167|%"
  "%|982db7560069406a8a73c9745025be8b|%"
  b"vèf}\x06\x11Ø \x00PV¥~ì"
  b"zö¾▀¹nÝ\x11Ø \x00PV¥~ì"
  b"█ê7ȹnÝ\x11Ø \x00PV¥~ì"
]
0.17 ms
(0.18%)
1
# product-detail-route::association::prices::read
SELECT `product_price`.`id` as `product_price.id`, `product_price`.`version_id` as `product_price.versionId`, `product_price`.`product_id` as `product_price.productId`, `product_price`.`product_version_id` as `product_price.productVersionId`, `product_price`.`rule_id` as `product_price.ruleId`, `product_price`.`price` as `product_price.price`, `product_price`.`quantity_start` as `product_price.quantityStart`, `product_price`.`quantity_end` as `product_price.quantityEnd`, `product_price`.`custom_fields` as `product_price.customFields`, `product_price`.`created_at` as `product_price.createdAt`, `product_price`.`updated_at` as `product_price.updatedAt` FROM `product_price` WHERE (`product_price`.`version_id` = ?) AND ((`product_price`.`product_id` IN (?)))
Parameters:
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"╦o┤cÌ$ý\x11Ø\x1A\x00PV¥~ì"
]
0.17 ms
(0.18%)
1
# base-context-factory::taxes::read
SELECT `tax`.`id` as `tax.id`, `tax`.`tax_rate` as `tax.taxRate`, `tax`.`name` as `tax.name`, `tax`.`position` as `tax.position`, `tax`.`custom_fields` as `tax.customFields`, `tax`.`created_at` as `tax.createdAt`, `tax`.`updated_at` as `tax.updatedAt` FROM `tax`
Parameters:
[]
0.16 ms
(0.18%)
1
# product-detail-route::check-variant-listing-config
            SELECT
                variant_listing_config as variantListingConfig,
                parent_id as parentId
            FROM product
            WHERE id = ?
            AND version_id = ?
Parameters:
[
  b"╦o┤cÌ$ý\x11Ø\x1A\x00PV¥~ì"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
]
0.16 ms
(0.18%)
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:
[]
0.16 ms
(0.17%)
1
#cart-persister::load
                SELECT `cart`.`cart` as payload, `cart`.`rule_ids`, 0 as `compressed` FROM cart WHERE `token` = ?
Parameters:
[
  "w9pUAJLkeakvetnKX43Yfp2OVhzsfi8P"
]
0.15 ms
(0.16%)
1
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
  "de-DE"
]
0.14 ms
(0.15%)
1
SELECT LOWER(HEX(assoc.`sales_channel_id`))
                FROM `sales_channel_payment_method` AS assoc
                    LEFT JOIN `payment_method` AS pm
                        ON pm.`id` = assoc.`payment_method_id`
                WHERE
                    assoc.`payment_method_id` = ? AND
                    pm.`active` = 1
Parameters:
[
  b"""
    \f\n
    \rš\x14ÇLºª‚°\x10}ÚŒÏ
    """
]
0.14 ms
(0.15%)
1
SELECT `handler_identifier`, LOWER(HEX(`id`)) FROM `payment_method`
Parameters:
[]
0.14 ms
(0.15%)
1
SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
Parameters:
[]
0.12 ms
(0.13%)
1
SELECT iso FROM snippet_set WHERE id = ?
Parameters:
[
  b"­ “\x07;‘M´š_bž„ÚÐ>"
]
0.10 ms
(0.10%)
1
SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
Parameters:
[]
0.09 ms
(0.09%)
1
SELECT `language`.`id` FROM `language` WHERE `language`.`id` IN (?) LIMIT 1
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.