Query time 0.00084
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": 25,
"filtered": 100,
"index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (4070,4071,4026,4027,3999,4000,4001,4002,4003,4004,4005,4006,4204,4205,4206,4207,4110,4111,4130,4131,3977,3978,4055,4056,4057)"
}
}
},
"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 |
CF178_a_BONE_WOOD_SALAD_SERVERS_10_INCH_COVER.jpg |
500 |
500 |
N |
5433 |
3977 |
product |
6231 |
M |
0 |
|
6231 |
0 |
CF178_b_BONE_WOOD_SALAD_SERVERS_10_INCH_HALF_CIRCLES.jpg |
500 |
500 |
N |
5434 |
3978 |
product |
6232 |
M |
0 |
|
6232 |
0 |
JN13_a_GIRAFFE_KENTI_SMALL_BROWN.jpg |
500 |
500 |
N |
5454 |
3999 |
product |
6252 |
M |
0 |
|
6252 |
0 |
JN13_b_GIRAFFE_KENTI_SMALL_YELLOW.jpg |
500 |
500 |
N |
5455 |
4000 |
product |
6253 |
M |
0 |
|
6253 |
0 |
JN13_c_GIRAFFE_KENTI_SMALL_MULITCOLOR.jpg |
500 |
500 |
N |
5456 |
4001 |
product |
6254 |
M |
0 |
|
6254 |
0 |
JN13_d_GIRAFFE_KENTI_SMALL_PINK.jpg |
500 |
500 |
N |
5457 |
4002 |
product |
6255 |
M |
0 |
|
6255 |
0 |
JN14_aGIRAFFE_KENTI_LARGE_ORANGE.jpg |
500 |
500 |
N |
5458 |
4003 |
product |
6256 |
M |
0 |
|
6256 |
0 |
JN14_b_GIRAFFE_KENTI_LARGE_YELLOW.jpg |
500 |
500 |
N |
5459 |
4004 |
product |
6257 |
M |
0 |
|
6257 |
0 |
ABU68_AMBERBEAD_COVER.jpg |
1365 |
2048 |
N |
5478 |
4026 |
product |
6276 |
M |
0 |
|
6276 |
0 |
ABU68_bAMBERBEAD_SMALL.jpg |
1365 |
2048 |
N |
5479 |
4027 |
product |
6277 |
M |
0 |
|
6277 |
0 |
ABU64_a_BONE_BEADS_ROUND_WHITE.jpg |
2048 |
2048 |
N |
5506 |
4055 |
product |
6304 |
M |
0 |
|
6304 |
0 |
ABU64_bBONE_BEADS_ROUND_BATIK.jpg |
2048 |
2048 |
N |
5507 |
4056 |
product |
6305 |
M |
0 |
|
6305 |
0 |
ABU64_c_BONE_BEADS_ROUND_COVER.jpg |
2048 |
2048 |
N |
5508 |
4057 |
product |
6306 |
M |
0 |
|
6306 |
0 |
ABU23_a_BONE_BEADS_10CENT_WHITE.jpg |
2048 |
2048 |
N |
5521 |
4070 |
product |
6319 |
M |
0 |
|
6319 |
0 |
ABU23_b_BONE_BEADS_10CENT_BATIIK.jpg |
2048 |
2048 |
N |
5522 |
4071 |
product |
6320 |
M |
0 |
|
6320 |
0 |
KT01_aMALE_1.jpg |
1365 |
2048 |
N |
5560 |
4110 |
product |
6358 |
M |
0 |
|
6358 |
0 |
KT01_bFEMALE_1-Edit.jpg |
1365 |
2048 |
N |
5561 |
4111 |
product |
6359 |
M |
0 |
|
6359 |
0 |
MY161_a_ELEPHANT.jpg |
2048 |
1365 |
N |
5580 |
4130 |
product |
6378 |
M |
0 |
|
6378 |
0 |
MY161_b_ELEPHANT_2.jpg |
2048 |
1365 |
N |
5581 |
4131 |
product |
6379 |
M |
0 |
|
6379 |
0 |
AN87_B_WHITE_1.jpg |
1365 |
2048 |
N |
5650 |
4204 |
product |
6448 |
M |
0 |
|
6448 |
0 |
AN87_BLACK_1.jpg |
1365 |
2048 |
N |
5651 |
4205 |
product |
6449 |
M |
0 |
|
6449 |
0 |
AN87_c_GOLD_1.jpg |
1365 |
2048 |
N |
5652 |
4206 |
product |
6450 |
M |
0 |
|
6450 |
0 |
AN87_d_SILVER_1.jpg |
1365 |
2048 |
N |
5653 |
4207 |
product |
6451 |
M |
0 |
|
6451 |
0 |
CF293_a_BEADED_FERTILITY_DOLL_BW.jpg |
2048 |
2048 |
N |
10473 |
4005 |
product |
11219 |
M |
0 |
|
11219 |
0 |
CF293_b_BEADED_FERTILITY_DOLL_WHITE.jpg |
2048 |
2048 |
N |
10474 |
4006 |
product |
11220 |
M |
0 |
|
11220 |