Query Metrics
89
Database Queries
64
Different statements
61.40 ms
Query time
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
15.93 ms (25.95%) |
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:
[ "/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/f34907b2c46fed119d20005056be7e8d" "/navigation/f44907b2c46fed119d20005056be7e8d" "/navigation/f54907b2c46fed119d20005056be7e8d" "/navigation/f64907b2c46fed119d20005056be7e8d" "/navigation/f74907b2c46fed119d20005056be7e8d" "/navigation/f84907b2c46fed119d20005056be7e8d" "/navigation/cb323ab8c46fed119d20005056be7e8d" "/navigation/a0d33c69e68ced119d24005056be7e8d" "/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" "/account/recover" "/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±ø" ] |
||||||||||||||||||||
|
13.72 ms (22.34%) |
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 ] |
||||||||||||||||||||
|
2.44 ms (3.97%) |
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 ] |
||||||||||||||||||||
|
2.30 ms (3.75%) |
5 |
# 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 ] |
||||||||||||||||||||
|
2.29 ms (3.73%) |
5 |
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:
[] |
||||||||||||||||||||
|
2.02 ms (3.30%) |
5 |
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:
[] |
||||||||||||||||||||
|
1.53 ms (2.49%) |
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.00 ms (1.63%) |
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.83 ms (1.36%) |
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.82 ms (1.34%) |
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.79 ms (1.28%) |
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.77 ms (1.25%) |
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}åõ" ] |
||||||||||||||||||||
|
0.76 ms (1.23%) |
1 |
SELECT `country_state`.`id` as `country_state.id`, `country_state`.`country_id` as `country_state.countryId`, `country_state`.`short_code` as `country_state.shortCode`, `country_state`.`position` as `country_state.position`, `country_state`.`active` as `country_state.active`, `country_state`.`created_at` as `country_state.createdAt`, `country_state`.`updated_at` as `country_state.updatedAt`, `country_state.translation.name`, COALESCE(`country_state.translation.name`,`country_state.translation.name`) as `country_state.name`, `country_state.translation.customFields`, COALESCE(`country_state.translation.customFields`,`country_state.translation.customFields`) as `country_state.customFields`, `country_state.translation.createdAt`, `country_state.translation.updatedAt`, `country_state.translation.countryStateId`, `country_state.translation.languageId` FROM `country_state` LEFT JOIN `country` `country_state.country` ON `country_state`.`country_id` = `country_state.country`.`id` LEFT JOIN (SELECT `country_state.translation`.country_state_id, `country_state.translation`.name as `country_state.translation.name`, `country_state.translation`.custom_fields as `country_state.translation.customFields`, `country_state.translation`.created_at as `country_state.translation.createdAt`, `country_state.translation`.updated_at as `country_state.translation.updatedAt`, `country_state.translation`.country_state_id as `country_state.translation.countryStateId`, `country_state.translation`.language_id as `country_state.translation.languageId` FROM `country_state_translation` `country_state.translation` WHERE `country_state.translation`.language_id = ?) `country_state.country_state_translation` ON `country_state.country_state_translation`.`country_state_id` = `country_state`.`id` LEFT JOIN `sales_channel_country` `country_state.country.salesChannels.mapping` ON `country_state.country`.`id` = `country_state.country.salesChannels.mapping`.`country_id` LEFT JOIN `sales_channel` `country_state.country.salesChannels` ON `country_state.country.salesChannels.mapping`.`sales_channel_id` = `country_state.country.salesChannels`.`id` WHERE (`country_state.country.salesChannels`.`id` = ? AND `country_state`.`country_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"äN15ºÖLý»&’ÄA7±ø" b"\x07mjÄÕýMáûþ÷JÑ2\x14Ø" b"\t\eÞÓ øE¢ùÅûè°║\x076" b"\x14Qè\x1C\f|Bð£Ñ:\x18âhAM" b"\x16ûþ†\x02ÙB\x02§˜[±Uô[|" b"+ó´áý\x06@ô“\x06Š2V=ÒÌ" b"0═{(\x17#Gï║+█\rúÁÅ╔" b"2É«ÌèñG\x1A½·ªçÆ ð\x14" b"2Á·pþNHê¼\x1C\x05¯ª}À" b"5͆+\x12æMå´”îK¾â\x1F\x07" b"7╠╩\v■÷I╗üp\x1E:©\x05m" b">·Ðy\e\x1ECI¹*ÉÖücE]" b"D\x16\x03\x05ÒÏO#§h´B~%\x19[" b"L‚hùÄ\x17Aà¼*‹.þFe‰" b"L╝`%Ø\x01@©║céx§*▀x" b"Mìî┬0OEð┐ãUÙ(\x0F®\x06" b"R=\î¹sL½¡–„ÍÒ(\x01\r" b"bÁ38§\x04N\x1C¶.=4÷«pL" b"mW°n¦àM˵ìuPJ\x14PG" b"pÀºéåÕ@ù’Ó`3‡Û:à" b"{95ã.\x03Jbƒ‘ÅôÙã5¸" b"~ð¼Ö¹EDÓX–\x1Aʬ\eÇ" b"ü\x06╦?ÏvF\x08Ñ┘\x01b<Ø~╬" b"†!÷Öý\x07A¹±Úa6Wæ\x10\x0E" b"ŒÈfy…\x19B*\x17“ žcyå" b"Ž>\x15èеO¼Ÿ¯Æ]\x0EÉÂò" b"Üÿ,zà¾CØØÝã\x1CÕ\x12çÎ" b"ØéÖ\x05─!@+òdt!5@(S" b""" Ø▓ðª]\n CÃæ┬|'ëù▒± """ b"£\x00\x03c\f8@0æ›s:â]Ç" b"ª¨"“\©D\x08¹‘ùã£=\x06p" b"´\x0FŠ\x16ÅNEœº\x00Ì´Gk·" b"´)Ñ™\tËGOƒ®àN⚪º" b"┤`jA╩¥I/òdì■Ë$╚Ý" b"¸)ÿá†\x05FJºìs‚¶\x1Dq}" b"¾q€†\x16\x0EBô¬Œ§¢\x11\x7F¦j" b"╩▀ÅD\x1C\x0FK\x18ÑÍ͵º¢w^" b"ÍF8OÈ\x06K\x7F±2Ňnš0Ø" b"Ð\t\x7F‗~OË׺Sk¦É<§" b"æò‡\x0F¾fMº²?Þ\x08#óÞÈ" b"ÞÚtY¥ÉD¢┐#P▓\x02¤ Ò" b"°¸ÒÌí-M*úè\x13\x01)\x0F┐ì" ] |
||||||||||||||||||||
|
0.75 ms (1.22%) |
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.74 ms (1.20%) |
10 |
SELECT `base_class` AS `baseClass`, `author` FROM `plugin`
Parameters:
[] |
||||||||||||||||||||
|
0.71 ms (1.15%) |
1 |
SELECT translation_key, value FROM snippet WHERE snippet_set_id = ?
Parameters:
[
b" “\x07;‘M´š_bž„ÚÐ>"
]
|
||||||||||||||||||||
|
0.65 ms (1.06%) |
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.61 ms (1.00%) |
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"\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.59 ms (0.96%) |
1 |
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"\x07mjÄÕýMáûþ÷JÑ2\x14Ø" b"\t\eÞÓ øE¢ùÅûè°║\x076" b"\x14Qè\x1C\f|Bð£Ñ:\x18âhAM" b"\x16ûþ†\x02ÙB\x02§˜[±Uô[|" b"+ó´áý\x06@ô“\x06Š2V=ÒÌ" b"0═{(\x17#Gï║+█\rúÁÅ╔" b"2É«ÌèñG\x1A½·ªçÆ ð\x14" b"2Á·pþNHê¼\x1C\x05¯ª}À" b"5͆+\x12æMå´”îK¾â\x1F\x07" b"7╠╩\v■÷I╗üp\x1E:©\x05m" b">·Ðy\e\x1ECI¹*ÉÖücE]" b"D\x16\x03\x05ÒÏO#§h´B~%\x19[" b"L‚hùÄ\x17Aà¼*‹.þFe‰" b"L╝`%Ø\x01@©║céx§*▀x" b"Mìî┬0OEð┐ãUÙ(\x0F®\x06" b"R=\î¹sL½¡–„ÍÒ(\x01\r" b"bÁ38§\x04N\x1C¶.=4÷«pL" b"mW°n¦àM˵ìuPJ\x14PG" b"pÀºéåÕ@ù’Ó`3‡Û:à" b"{95ã.\x03Jbƒ‘ÅôÙã5¸" b"~ð¼Ö¹EDÓX–\x1Aʬ\eÇ" b"ü\x06╦?ÏvF\x08Ñ┘\x01b<Ø~╬" b"†!÷Öý\x07A¹±Úa6Wæ\x10\x0E" b"ŒÈfy…\x19B*\x17“ žcyå" b"Ž>\x15èеO¼Ÿ¯Æ]\x0EÉÂò" b"Üÿ,zà¾CØØÝã\x1CÕ\x12çÎ" b"ØéÖ\x05─!@+òdt!5@(S" b""" Ø▓ðª]\n CÃæ┬|'ëù▒± """ b"£\x00\x03c\f8@0æ›s:â]Ç" b"ª¨"“\©D\x08¹‘ùã£=\x06p" b"´\x0FŠ\x16ÅNEœº\x00Ì´Gk·" b"´)Ñ™\tËGOƒ®àN⚪º" b"┤`jA╩¥I/òdì■Ë$╚Ý" b"¸)ÿá†\x05FJºìs‚¶\x1Dq}" b"¾q€†\x16\x0EBô¬Œ§¢\x11\x7F¦j" b"╩▀ÅD\x1C\x0FK\x18ÑÍ͵º¢w^" b"ÍF8OÈ\x06K\x7F±2Ňnš0Ø" b"Ð\t\x7F‗~OË׺Sk¦É<§" b"æò‡\x0F¾fMº²?Þ\x08#óÞÈ" b"ÞÚtY¥ÉD¢┐#P▓\x02¤ Ò" b"°¸ÒÌí-M*úè\x13\x01)\x0F┐ì" ] |
||||||||||||||||||||
|
0.58 ms (0.95%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[] |
||||||||||||||||||||
|
0.58 ms (0.94%) |
1 |
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE ?
Parameters:
[
"payload"
]
|
||||||||||||||||||||
|
0.52 ms (0.85%) |
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.51 ms (0.83%) |
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.46 ms (0.75%) |
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.44 ms (0.71%) |
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.39 ms (0.63%) |
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.39 ms (0.63%) |
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.38 ms (0.61%) |
2 |
# 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.37 ms (0.61%) |
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.37 ms (0.60%) |
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.33 ms (0.53%) |
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.32 ms (0.52%) |
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±ø" "account/login" ] |
||||||||||||||||||||
|
0.32 ms (0.52%) |
1 |
SELECT `woso_nav_customer_type`.`id` as `woso_nav_customer_type.id`, `woso_nav_customer_type`.`sales_channel_id` as `woso_nav_customer_type.salesChannelId`, `woso_nav_customer_type`.`parent_id` as `woso_nav_customer_type.parentId`, `woso_nav_customer_type`.`code` as `woso_nav_customer_type.code`, `woso_nav_customer_type`.`position` as `woso_nav_customer_type.position`, `woso_nav_customer_type`.`status` as `woso_nav_customer_type.status`, `woso_nav_customer_type`.`tmpl_code` as `woso_nav_customer_type.tmplCode`, `woso_nav_customer_type`.`isBusiness` as `woso_nav_customer_type.isBusiness`, `woso_nav_customer_type`.`created_at` as `woso_nav_customer_type.createdAt`, `woso_nav_customer_type`.`updated_at` as `woso_nav_customer_type.updatedAt`, `woso_nav_customer_type.translation.name`, COALESCE(`woso_nav_customer_type.translation.name`,`woso_nav_customer_type.translation.name`) as `woso_nav_customer_type.name`, `woso_nav_customer_type.translation.description`, COALESCE(`woso_nav_customer_type.translation.description`,`woso_nav_customer_type.translation.description`) as `woso_nav_customer_type.description`, `woso_nav_customer_type.translation.extData`, COALESCE(`woso_nav_customer_type.translation.extData`,`woso_nav_customer_type.translation.extData`) as `woso_nav_customer_type.extData`, `woso_nav_customer_type.translation.createdAt`, `woso_nav_customer_type.translation.updatedAt`, `woso_nav_customer_type.translation.wosoNavCustomerTypeId`, `woso_nav_customer_type.translation.languageId` FROM `woso_nav_customer_type` LEFT JOIN (SELECT `woso_nav_customer_type.translation`.woso_nav_customer_type_id, `woso_nav_customer_type.translation`.name as `woso_nav_customer_type.translation.name`, `woso_nav_customer_type.translation`.description as `woso_nav_customer_type.translation.description`, `woso_nav_customer_type.translation`.extData as `woso_nav_customer_type.translation.extData`, `woso_nav_customer_type.translation`.created_at as `woso_nav_customer_type.translation.createdAt`, `woso_nav_customer_type.translation`.updated_at as `woso_nav_customer_type.translation.updatedAt`, `woso_nav_customer_type.translation`.woso_nav_customer_type_id as `woso_nav_customer_type.translation.wosoNavCustomerTypeId`, `woso_nav_customer_type.translation`.language_id as `woso_nav_customer_type.translation.languageId` FROM `woso_nav_customer_type_translation` `woso_nav_customer_type.translation` WHERE `woso_nav_customer_type.translation`.language_id = ?) `woso_nav_customer_type.woso_nav_customer_type_translation` ON `woso_nav_customer_type.woso_nav_customer_type_translation`.`woso_nav_customer_type_id` = `woso_nav_customer_type`.`id` WHERE `woso_nav_customer_type`.`id` IN (?, ?, ?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x00V€\x01-¯HÏ–ï\x1D{Ïäc8" b"¦pÒÕÅnOíŸ:Ž'\x7Ff˜Ý" b"│kÙÝ·‗OÅ┐˦ÉP¯Ã8" b"╦¯¿Iz!Mãª:ü)╩¹¤2" ] |
||||||||||||||||||||
|
0.31 ms (0.51%) |
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.30 ms (0.50%) |
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.29 ms (0.48%) |
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.29 ms (0.47%) |
1 |
SELECT `salutation`.`id` as `salutation.id`, `salutation`.`salutation_key` as `salutation.salutationKey`, `salutation`.`created_at` as `salutation.createdAt`, `salutation`.`updated_at` as `salutation.updatedAt`, `salutation.translation.displayName`, COALESCE(`salutation.translation.displayName`,`salutation.translation.displayName`) as `salutation.displayName`, `salutation.translation.letterName`, COALESCE(`salutation.translation.letterName`,`salutation.translation.letterName`) as `salutation.letterName`, `salutation.translation.customFields`, COALESCE(`salutation.translation.customFields`,`salutation.translation.customFields`) as `salutation.customFields`, `salutation.translation.createdAt`, `salutation.translation.updatedAt`, `salutation.translation.salutationId`, `salutation.translation.languageId` FROM `salutation` LEFT JOIN (SELECT `salutation.translation`.salutation_id, `salutation.translation`.display_name as `salutation.translation.displayName`, `salutation.translation`.letter_name as `salutation.translation.letterName`, `salutation.translation`.custom_fields as `salutation.translation.customFields`, `salutation.translation`.created_at as `salutation.translation.createdAt`, `salutation.translation`.updated_at as `salutation.translation.updatedAt`, `salutation.translation`.salutation_id as `salutation.translation.salutationId`, `salutation.translation`.language_id as `salutation.translation.languageId` FROM `salutation_translation` `salutation.translation` WHERE `salutation.translation`.language_id = ?) `salutation.salutation_translation` ON `salutation.salutation_translation`.`salutation_id` = `salutation`.`id`
Parameters:
[
b"/»_ââšMpªXTÎ|ãâ\v"
]
|
||||||||||||||||||||
|
0.29 ms (0.47%) |
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`.`active` = ? AND `country`.`active` = ? AND `country.salesChannels`.`id` = ?) GROUP BY `country`.`id`
Parameters:
[ true true b"äN15ºÖLý»&’ÄA7±ø" ] |
||||||||||||||||||||
|
0.29 ms (0.47%) |
1 |
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
|
||||||||||||||||||||
|
0.28 ms (0.46%) |
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.46%) |
1 |
SELECT custom_entity.name, custom_entity.fields, custom_entity.flags FROM custom_entity LEFT JOIN app ON app.id = custom_entity.app_id WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
Parameters:
[]
|
||||||||||||||||||||
|
0.27 ms (0.45%) |
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.27 ms (0.43%) |
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.42%) |
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.40%) |
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.24 ms (0.39%) |
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.22 ms (0.36%) |
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.20 ms (0.33%) |
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.20 ms (0.33%) |
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±ø" "/account/login" ] |
||||||||||||||||||||
|
0.20 ms (0.32%) |
1 |
# base-context-factory::sales-channel::association::domains::read SELECT `sales_channel_domain`.`id` as `sales_channel_domain.id`, `sales_channel_domain`.`url` as `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt` FROM `sales_channel_domain` WHERE (`sales_channel_domain`.`sales_channel_id` IN (?))
Parameters:
[
b"äN15ºÖLý»&’ÄA7±ø"
]
|
||||||||||||||||||||
|
0.20 ms (0.32%) |
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.17 ms (0.28%) |
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.16 ms (0.26%) |
1 |
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[ b"äN15ºÖLý»&’ÄA7±ø" "U2tz9t4l5km664b4gnDkVVlArwueasY5" ] |
||||||||||||||||||||
|
0.14 ms (0.22%) |
1 |
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||
|
0.13 ms (0.21%) |
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.13 ms (0.21%) |
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.13 ms (0.21%) |
1 |
SELECT `handler_identifier`, LOWER(HEX(`id`)) FROM `payment_method`
Parameters:
[] |
||||||||||||||||||||
|
0.12 ms (0.20%) |
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.12 ms (0.20%) |
1 |
#cart-persister::load SELECT `cart`.`cart` as payload, `cart`.`rule_ids`, 0 as `compressed` FROM cart WHERE `token` = ?
Parameters:
[
"U2tz9t4l5km664b4gnDkVVlArwueasY5"
]
|
||||||||||||||||||||
|
0.11 ms (0.19%) |
1 |
SELECT `woso_nav_customer_type`.`id` FROM `woso_nav_customer_type` WHERE (`woso_nav_customer_type`.`parent_id` <=> ?) ORDER BY `woso_nav_customer_type`.`position` ASC
Parameters:
[
null
]
|
||||||||||||||||||||
|
0.10 ms (0.17%) |
1 |
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
"de-DE"
]
|
||||||||||||||||||||
|
0.09 ms (0.15%) |
1 |
SELECT `name`, `path`, `author` FROM `app` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||
|
0.08 ms (0.14%) |
1 |
SELECT `language`.`id` FROM `language` WHERE `language`.`id` IN (?) LIMIT 1
Parameters:
[
b"/»_ââšMpªXTÎ|ãâ\v"
]
|
||||||||||||||||||||
|
0.08 ms (0.13%) |
1 |
SELECT iso FROM snippet_set WHERE id = ?
Parameters:
[
b" “\x07;‘M´š_bž„ÚÐ>"
]
|
Database Connections
| Name | Service |
|---|---|
| 0 | default |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.