Query time 0.00304
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": 68,
"filtered": 100,
"index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (4164,4165,4166,4167,4168,4169,4170,4171,4173,4174,4162,4163,4185,4195,4196,4197,4198,4202,4203,4367,3934,3935,3936,3937,3970,3971,3972,3973,4065,4066,4089,4090,4091,4093,4094,4095,4096,4097,4098,4099,4100,4052,4053,4010,4011,3955,3956,3957,4050,4051,4189,4190,4191,4119,4120,4121,4122,4123,4124,4072,4060,4061,3974,3975,3976,4064,4365)"
}
}
},
"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 |
CF141_a_BONE_WOOD_SUGAR_SPOON_STRIPE.jpg |
500 |
500 |
N |
5390 |
3934 |
product |
6188 |
M |
0 |
|
6188 |
0 |
CF141_b_BONE_WOOD_SUGAR_SPOON_CHEVRON.jpg |
500 |
500 |
N |
5391 |
3935 |
product |
6189 |
M |
0 |
|
6189 |
0 |
CF141_c_BONE_WOOD_SUGAR_SPOON_WHITE_PLAIN.jpg |
500 |
500 |
N |
5392 |
3936 |
product |
6190 |
M |
0 |
|
6190 |
0 |
CF141_d_OLIVE_BONE_WOOD_SUGAR_SPOON_BATIK.jpg |
500 |
500 |
N |
5393 |
3937 |
product |
6191 |
M |
0 |
|
6191 |
0 |
CF26_a_LEATHER_BRACELET_BROWN_.jpg |
500 |
500 |
N |
5411 |
3955 |
product |
6209 |
M |
0 |
|
6209 |
0 |
CF26_b_LEATHER_BRACELET_RED.jpg |
500 |
500 |
N |
5412 |
3956 |
product |
6210 |
M |
0 |
|
6210 |
0 |
CF26_c_LEATHER_BRACELET_white.jpg |
500 |
500 |
N |
5413 |
3957 |
product |
6211 |
M |
0 |
|
6211 |
0 |
CF18_a_BONE_WOOD_PEN_STARS_AND_STRIPES.jpg |
500 |
500 |
N |
5426 |
3970 |
product |
6224 |
M |
0 |
|
6224 |
0 |
CF18_b_BONE_WOOD_PEN_BATIK_CIRCLES.jpg |
500 |
500 |
N |
5427 |
3971 |
product |
6225 |
M |
0 |
|
6225 |
0 |
CF18_c_BONE_WOOD_PEN_BATIK_STRIPES.jpg |
500 |
500 |
N |
5428 |
3972 |
product |
6226 |
M |
0 |
|
6226 |
0 |
CF18_d_BONE_WOOD_PEN_PLAIN_WHITE.jpg |
500 |
500 |
N |
5429 |
3973 |
product |
6227 |
M |
0 |
|
6227 |
0 |
CF179_a_WOOD_BONE_SALAD_SERVERS_8_INCH_DIAG_STRIPE.jpg |
500 |
500 |
N |
5430 |
3974 |
product |
6228 |
M |
0 |
|
6228 |
0 |
CF179_b_WOOD_BONE_SALAD_SERVERS_8_INCH_LONG_STRIPE_COVER.jpg |
500 |
500 |
N |
5431 |
3975 |
product |
6229 |
M |
0 |
|
6229 |
0 |
CF179_c_WOOD_BONE_SALAD_SERVERS_8_INCH_circles_CIRCLES.jpg |
500 |
500 |
N |
5432 |
3976 |
product |
6230 |
M |
0 |
|
6230 |
0 |
BAMBARA_MASK_COVER.jpg |
500 |
500 |
N |
5462 |
4010 |
product |
6260 |
M |
0 |
|
6260 |
0 |
BAMBARA_MASK_SMALL_b1.jpg |
500 |
500 |
N |
5463 |
4011 |
product |
6261 |
M |
0 |
|
6261 |
0 |
TH01_THROW_BUSHCOLORS-2.jpg |
500 |
500 |
N |
5501 |
4050 |
product |
6299 |
M |
0 |
|
6299 |
0 |
RUN01_RUNNER_ZEBRA.jpg |
500 |
500 |
N |
5502 |
4051 |
product |
6300 |
M |
0 |
|
6300 |
0 |
RUN01_RUNNER_ANIMALS.jpg |
500 |
500 |
N |
5503 |
4052 |
product |
6301 |
M |
0 |
|
6301 |
0 |
RUN01_RUNNER_ZEBRA_b_.jpg |
500 |
500 |
N |
5504 |
4053 |
product |
6302 |
M |
0 |
|
6302 |
0 |
ABU063_aHANGING_DECOR_LARGE.jpg |
1365 |
2048 |
N |
5511 |
4060 |
product |
6309 |
M |
0 |
|
6309 |
0 |
ABU063_bHANGING_DECOR.jpg |
1365 |
2048 |
N |
5512 |
4061 |
product |
6310 |
M |
0 |
|
6310 |
0 |
ABU01_YARUBA_OPEN_RED.jpg |
2048 |
2048 |
N |
5515 |
4064 |
product |
6313 |
M |
0 |
|
6313 |
0 |
ABU72-a_BONE_BEADS_PATTERN_BROWN_WHITE.jpg |
2048 |
2048 |
N |
5516 |
4065 |
product |
6314 |
M |
0 |
|
6314 |
0 |
ABU72_BONE_BEADS_PATTERN_WHITE.jpg |
2048 |
2048 |
N |
5517 |
4066 |
product |
6315 |
M |
0 |
|
6315 |
0 |
ABU22_bBONE_BEADS_TUBE_DECOR.jpg |
2048 |
2048 |
N |
5523 |
4072 |
product |
6321 |
M |
0 |
|
6321 |
0 |
ABU60_aGLASS_BEADS_BLACK.jpg |
2048 |
2048 |
N |
5539 |
4089 |
product |
6337 |
M |
0 |
|
6337 |
0 |
ABU60_GLASS_BEADS_BLUE.jpg |
2048 |
2048 |
N |
5540 |
4090 |
product |
6338 |
M |
0 |
|
6338 |
0 |
ABU60_cGLASS_BEADS_WHITE.jpg |
2048 |
2048 |
N |
5541 |
4091 |
product |
6339 |
M |
0 |
|
6339 |
0 |
ABU44_aBEADS_BLUGREEN.jpg |
2048 |
2048 |
N |
5543 |
4093 |
product |
6341 |
M |
0 |
|
6341 |
0 |
ABU44_bBEADS_WHITE.jpg |
2048 |
2048 |
N |
5544 |
4094 |
product |
6342 |
M |
0 |
|
6342 |
0 |
ABU44_cBEADS_DARKBLUE.jpg |
2048 |
2048 |
N |
5545 |
4095 |
product |
6343 |
M |
0 |
|
6343 |
0 |
ABU44_dBEADS_BLUEGREY.jpg |
2048 |
2048 |
N |
5546 |
4096 |
product |
6344 |
M |
0 |
|
6344 |
0 |
ABU48_aGLASS_BEADS_MULTICOLOR.jpg |
2048 |
2048 |
N |
5547 |
4097 |
product |
6345 |
M |
0 |
|
6345 |
0 |
ABU48_bGLASS_BEADS_WHITE.jpg |
2048 |
2048 |
N |
5548 |
4098 |
product |
6346 |
M |
0 |
|
6346 |
0 |
ABU48_cGLASS_BEADS_BLUE.jpg |
2048 |
2048 |
N |
5549 |
4099 |
product |
6347 |
M |
0 |
|
6347 |
0 |
ABU48_dGLASS_BEADS_Bluegrey.jpg |
2048 |
2048 |
N |
5550 |
4100 |
product |
6348 |
M |
0 |
|
6348 |
0 |
OM6_aCOVER_PHOTO_1.jpg |
2048 |
1365 |
N |
5569 |
4119 |
product |
6367 |
M |
0 |
|
6367 |
0 |
OM6_bOVAL_DARK_BROWN.jpg |
2048 |
1366 |
N |
5570 |
4120 |
product |
6368 |
M |
0 |
|
6368 |
0 |
OM6_cDARK_BROWN_HINGED.jpg |
2048 |
1365 |
N |
5571 |
4121 |
product |
6369 |
M |
0 |
|
6369 |
0 |
OM6_dBLUE.jpg |
2048 |
1366 |
N |
5572 |
4122 |
product |
6370 |
M |
0 |
|
6370 |
0 |
OM6_eGREEN.jpg |
2048 |
1361 |
N |
5573 |
4123 |
product |
6371 |
M |
0 |
|
6371 |
0 |
OM6_fRED.jpg |
2048 |
1365 |
N |
5574 |
4124 |
product |
6372 |
M |
0 |
|
6372 |
0 |
AN88_aBLACK_1.jpg |
1365 |
2048 |
N |
5610 |
4162 |
product |
6408 |
M |
0 |
|
6408 |
0 |
AN88_bWHITE_1.jpg |
1365 |
2048 |
N |
5611 |
4163 |
product |
6409 |
M |
0 |
|
6409 |
0 |
AN861_aBLACK_RUNNER.jpg |
1365 |
2048 |
N |
5612 |
4164 |
product |
6410 |
M |
0 |
|
6410 |
0 |
AN861_bBlack_with_rectangle_and_dot_pattern.jpg |
1293 |
2047 |
N |
5613 |
4165 |
product |
6411 |
M |
0 |
|
6411 |
0 |
AN863_c_black_chev_stripe.jpg |
1365 |
2048 |
N |
5614 |
4166 |
product |
6412 |
M |
0 |
|
6412 |
0 |
AN864_d_black_with_white_stripe.jpg |
1365 |
2048 |
N |
5615 |
4167 |
product |
6413 |
M |
0 |
|
6413 |
0 |
AN865_e_Black_and_white.jpg |
1365 |
2048 |
N |
5616 |
4168 |
product |
6414 |
M |
0 |
|
6414 |
0 |
AN866_f_Natural_with_black_wave.jpg |
1365 |
2048 |
N |
5617 |
4169 |
product |
6415 |
M |
0 |
|
6415 |
0 |
AN867_g_Natural_chev_with_dots.jpg |
1365 |
2048 |
N |
5618 |
4170 |
product |
6416 |
M |
0 |
|
6416 |
0 |
AN868_h_nat_with_black_chev.jpg |
1365 |
2048 |
N |
5619 |
4171 |
product |
6417 |
M |
0 |
|
6417 |
0 |
AN869_j_Brown___Black_1.jpg |
1365 |
2048 |
N |
5620 |
4173 |
product |
6418 |
M |
0 |
|
6418 |
0 |
AN72_BLACK_1.jpg |
1365 |
2048 |
N |
5631 |
4185 |
product |
6429 |
M |
0 |
|
6429 |
0 |
AN40_a_WHITE_1.jpg |
1365 |
2048 |
N |
5635 |
4189 |
product |
6433 |
M |
0 |
|
6433 |
0 |
AN40_b_SILVER_1.jpg |
1365 |
2048 |
N |
5636 |
4190 |
product |
6434 |
M |
0 |
|
6434 |
0 |
AN40_c_BLACK_1.jpg |
1365 |
2048 |
N |
5637 |
4191 |
product |
6435 |
M |
0 |
|
6435 |
0 |
AN106_BLACK_1.jpg |
1365 |
2048 |
N |
5641 |
4195 |
product |
6439 |
M |
0 |
|
6439 |
0 |
AN106_SILVER_1.jpg |
1365 |
2048 |
N |
5642 |
4196 |
product |
6440 |
M |
0 |
|
6440 |
0 |
AN106_GOLD_1.jpg |
1245 |
2048 |
N |
5643 |
4197 |
product |
6441 |
M |
0 |
|
6441 |
0 |
AN106_WHITE_1.jpg |
1365 |
2048 |
N |
5644 |
4198 |
product |
6442 |
M |
0 |
|
6442 |
0 |
AN01_WHITE_1.jpg |
1365 |
2048 |
N |
5648 |
4202 |
product |
6446 |
M |
0 |
|
6446 |
0 |
AN01_YELLOW_1.jpg |
1365 |
2048 |
N |
5649 |
4203 |
product |
6447 |
M |
0 |
|
6447 |
0 |
ABU01_YARUBA_OPEN_BLUE_01.jpg |
2048 |
2048 |
N |
5854 |
4365 |
product |
6652 |
M |
0 |
|
6652 |
0 |
AN73_WHITE_1_sm8s-gs.jpg |
1365 |
2048 |
N |
5856 |
4367 |
product |
6654 |
M |
0 |
|
6654 |
0 |
AN861_k_Mustard.jpg |
1825 |
2048 |
N |
10477 |
4174 |
product |
11223 |
M |
0 |
|
11223 |