Query time 0.00151
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 = 'product' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (4340,4339,2364,2381,3236,3223,4344,4352,3234,3221,3239,3225,3218,3246,4349,3235,3222,3231,4347)"
}
}
},
"table": {
"table_name": "cscart_images",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "4",
"used_key_parts": ["image_id"],
"ref": ["ymonline_livedata.cscart_images_links.detailed_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": ["ymonline_livedata.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 = 'en' 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 |
0 |
HEINEKEN_330ML_BEER_NRB_24_x_330ML.jpg |
225 |
225 |
N |
3510 |
2364 |
product |
4329 |
M |
0 |
|
4329 |
0 |
HEINEKEN_330ML_BEER_NRB__6_x_330ML.jpg |
500 |
500 |
N |
3526 |
2381 |
product |
4345 |
M |
0 |
|
4345 |
0 |
EXTREME_EXTREME_NRB__24_x_275ML.jpg |
515 |
515 |
N |
4474 |
3218 |
product |
5293 |
M |
0 |
|
5293 |
0 |
HUNTERS_CIDER_330ML_DRY_NRB__24_x_330ML.jpg |
694 |
636 |
N |
4477 |
3221 |
product |
5296 |
M |
0 |
|
5296 |
0 |
HUNTERS_CIDER_330ML_GOLD_NRB__24_x_330ML.jpg |
515 |
515 |
N |
4478 |
3222 |
product |
5297 |
M |
0 |
|
5297 |
0 |
HUNTERS_CIDER_330ML_HARD_LEMON_NRB__24_x_330ML.jpg |
500 |
500 |
N |
4479 |
3223 |
product |
5298 |
M |
0 |
|
5298 |
0 |
HUNTERS_CIDER_CAN_DRY_24_x_440ML.jpg |
450 |
276 |
N |
4481 |
3225 |
product |
5300 |
M |
0 |
|
5300 |
0 |
HUNTERS_CIDER_CAN_GOLD_6_x_330ML.jpg |
515 |
515 |
N |
4487 |
3231 |
product |
5306 |
M |
0 |
|
5306 |
0 |
HUNTERS_CIDER_330ML_DRY_NRB__6_x_330ML.jpg |
458 |
458 |
N |
4490 |
3234 |
product |
5309 |
M |
0 |
|
5309 |
0 |
HUNTERS_CIDER_330ML_GOLD_NRB__6_x_330ML.jpg |
800 |
800 |
N |
4491 |
3235 |
product |
5310 |
M |
0 |
|
5310 |
0 |
HUNTERS_CIDER_330ML_HARD_LEMON_NRB__6_x_330ML.jpg |
360 |
450 |
N |
4492 |
3236 |
product |
5311 |
M |
0 |
|
5311 |
0 |
HUNTERS_440ML_CIDER_CAN_DRY_6_x_440ML.jpg |
480 |
427 |
N |
4495 |
3239 |
product |
5314 |
M |
0 |
|
5314 |
0 |
EXTREME_CIDER_CAN__6_x_250ML.jpg |
500 |
658 |
N |
4502 |
3246 |
product |
5321 |
M |
0 |
|
5321 |
0 |
HEINEKEN_440ML_BEER_CAN__6_x_440ML.jpg |
600 |
600 |
N |
5826 |
4339 |
product |
6624 |
M |
0 |
|
6624 |
0 |
HEINEKEN_440ML_BEER_CAN__24_x_440ML.jpg |
515 |
515 |
N |
5827 |
4340 |
product |
6625 |
M |
0 |
|
6625 |
0 |
HUNTERS_CIDER_CAN_HARD_LEMON_6_x_440ML.jpg |
480 |
427 |
N |
5831 |
4344 |
product |
6629 |
M |
0 |
|
6629 |
0 |
10450253PK2-20190726-Media-checkers515Wx515H.jpg |
515 |
515 |
N |
5834 |
4347 |
product |
6632 |
M |
0 |
|
6632 |
0 |
EXTREME_CIDER_CAN__24_x_250ML.jpg |
515 |
515 |
N |
5836 |
4349 |
product |
6634 |
M |
0 |
|
6634 |
0 |
HUNTERS_CIDER_CAN_HARD_LEMON_24_x_440ML.jpg |
225 |
225 |
N |
5839 |
4352 |
product |
6637 |
M |
0 |
|
6637 |