Query time 0.00122
JSON explain
{
"query_block": {
"select_id": 1,
"read_sorted_file": {
"filesort": {
"sort_key": "cscart_images_links.position, cscart_images_links.pair_id",
"table": {
"table_name": "cscart_images_links",
"access_type": "range",
"possible_keys": ["object_id"],
"key": "object_id",
"key_length": "81",
"used_key_parts": ["object_id", "object_type", "type"],
"rows": 20,
"filtered": 100,
"index_condition": "cscart_images_links.object_type = 'abt__ut2/menu-with-icon' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (215,213,290,292,301,300,302,303,304,305,306,308,309,310)"
}
}
},
"table": {
"table_name": "cscart_images",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "4",
"used_key_parts": ["image_id"],
"ref": ["admin_test.cscart_images_links.image_id"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "cscart_common_descriptions",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "108",
"used_key_parts": ["object_id", "lang_code", "object_holder"],
"ref": ["admin_test.cscart_images.image_id", "const", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_common_descriptions.object_holder = 'images' and cscart_common_descriptions.lang_code = 'ru' and trigcond(cscart_images.image_id is not null))"
}
}
}
Result
image_id |
image_path |
image_x |
image_y |
is_high_res |
pair_id |
object_id |
object_type |
detailed_id |
type |
position |
alt |
images_image_id |
8737 |
5557114.png |
512 |
512 |
N |
6713 |
213 |
abt__ut2/menu-with-icon |
0 |
M |
0 |
|
8737 |
8739 |
premium-icon-smartphone-3171448.png.webp |
85 |
85 |
N |
6715 |
215 |
abt__ut2/menu-with-icon |
0 |
M |
0 |
|
8739 |
13788 |
free-icon-mini-7134231.png.webp |
85 |
85 |
N |
11764 |
290 |
abt__ut2/menu-with-icon |
0 |
M |
0 |
|
13788 |
13789 |
premium-icon-smartphone-3171429.png.webp |
85 |
85 |
N |
11765 |
292 |
abt__ut2/menu-with-icon |
0 |
M |
0 |
|
13789 |
13790 |
650453.png |
512 |
512 |
N |
11766 |
301 |
abt__ut2/menu-with-icon |
0 |
M |
0 |
|
13790 |
13791 |
free-icon-charger-4549409.png.webp |
85 |
85 |
N |
11767 |
300 |
abt__ut2/menu-with-icon |
0 |
M |
0 |
|
13791 |
13792 |
4738879.png |
512 |
512 |
N |
11768 |
302 |
abt__ut2/menu-with-icon |
0 |
M |
0 |
|
13792 |
13793 |
2575726.png |
512 |
512 |
N |
11769 |
303 |
abt__ut2/menu-with-icon |
0 |
M |
0 |
|
13793 |
13794 |
2263611.png |
512 |
512 |
N |
11770 |
304 |
abt__ut2/menu-with-icon |
0 |
M |
0 |
|
13794 |
13795 |
3144969.png |
512 |
512 |
N |
11771 |
305 |
abt__ut2/menu-with-icon |
0 |
M |
0 |
|
13795 |
13796 |
5713682.png |
512 |
512 |
N |
11772 |
308 |
abt__ut2/menu-with-icon |
0 |
M |
0 |
|
13796 |
13797 |
6611269.png |
512 |
512 |
N |
11773 |
309 |
abt__ut2/menu-with-icon |
0 |
M |
0 |
|
13797 |
13798 |
5050607.png |
512 |
512 |
N |
11774 |
310 |
abt__ut2/menu-with-icon |
0 |
M |
0 |
|
13798 |
13799 |
2850650.png |
512 |
512 |
N |
11775 |
306 |
abt__ut2/menu-with-icon |
0 |
M |
0 |
|
13799 |