Query time 0.00194
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "150.41"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "28.00"
},
"nested_loop": [
{
"table": {
"table_name": "q_images_links",
"access_type": "range",
"possible_keys": [
"object_id"
],
"key": "object_id",
"used_key_parts": [
"object_id",
"object_type",
"type"
],
"key_length": "81",
"rows_examined_per_scan": 28,
"rows_produced_per_join": 28,
"filtered": "100.00",
"index_condition": "((`portal`.`q_images_links`.`object_type` = 'product') and (`portal`.`q_images_links`.`type` = 'A') and (`portal`.`q_images_links`.`object_id` in ('10051','10052','10053','10054','8682','8662','8582','8583','8584','8585','8586','8587','8588','8589','8590','8591')))",
"cost_info": {
"read_cost": "49.61",
"eval_cost": "5.60",
"prefix_cost": "55.21",
"data_read_per_join": "2K"
},
"used_columns": [
"pair_id",
"object_id",
"object_type",
"image_id",
"detailed_id",
"type",
"position"
]
}
},
{
"table": {
"table_name": "q_images",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"image_id"
],
"key_length": "4",
"ref": [
"portal.q_images_links.detailed_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 28,
"filtered": "100.00",
"cost_info": {
"read_cost": "28.00",
"eval_cost": "5.60",
"prefix_cost": "88.81",
"data_read_per_join": "21K"
},
"used_columns": [
"image_id",
"image_path",
"image_x",
"image_y",
"is_high_res"
],
"attached_condition": "<if>(is_not_null_compl(q_images), (`portal`.`q_images_links`.`detailed_id` = `portal`.`q_images`.`image_id`), true)"
}
},
{
"table": {
"table_name": "q_common_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"lang_code",
"object_holder"
],
"key_length": "107",
"ref": [
"portal.q_images.image_id",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 28,
"filtered": "100.00",
"cost_info": {
"read_cost": "28.00",
"eval_cost": "5.60",
"prefix_cost": "122.41",
"data_read_per_join": "16K"
},
"used_columns": [
"object_id",
"description",
"lang_code",
"object_holder"
],
"attached_condition": "<if>(is_not_null_compl(q_common_descriptions), (`portal`.`q_common_descriptions`.`object_id` = `portal`.`q_images`.`image_id`), true)"
}
}
]
}
}
}
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 |
a5958752117e59f6e4cb80c28a772f4a.JPG |
280 |
280 |
N |
18172 |
8662 |
product |
20134 |
A |
1 |
|
20134 |
0 |
3f56034b-b320-4ea9-9e6c-13ff7316f30e.jpg |
1000 |
1000 |
N |
18185 |
8682 |
product |
20147 |
A |
1 |
|
20147 |
0 |
71myOfd8QiL._SL1500_.jpg |
934 |
1500 |
N |
18614 |
10053 |
product |
20576 |
A |
1 |
|
20576 |
0 |
312vmp5r6_L_4zqs-7d.jpg |
500 |
500 |
N |
85011 |
10051 |
product |
20620 |
A |
1 |
|
20620 |
0 |
LASPERAL-1PC-5-Grids-Socks-Bra-Underwear-Organizer-Closet-Storage-Box-Organizer-Wardrobe-Plastic-Makeup-Storage.jpg_q50.jpg |
800 |
800 |
N |
18175 |
8662 |
product |
20137 |
A |
2 |
|
20137 |
0 |
Huami-Amazfit-Stratos-Smartwatch-2-734x490.jpg |
734 |
490 |
N |
18186 |
8682 |
product |
20148 |
A |
2 |
|
20148 |
0 |
61vsX51oXUL._SL1500_.jpg |
936 |
1500 |
N |
18615 |
10053 |
product |
20577 |
A |
2 |
|
20577 |
0 |
31mlzkeZsZL_t5r2-dw.jpg |
500 |
500 |
N |
85012 |
10051 |
product |
20621 |
A |
2 |
|
20621 |
0 |
Xiaomi-Huami-Amazfit-2-Amazfit-Stratos-Pace.jpg_350x350.jpg |
350 |
350 |
N |
18187 |
8682 |
product |
20149 |
A |
3 |
|
20149 |
0 |
pms_1539340885.52381908.png |
800 |
800 |
N |
18655 |
10053 |
product |
20617 |
A |
3 |
|
20617 |
0 |
51LkYD-HeUL._SL1000__e8xo-0a.jpg |
1000 |
1000 |
N |
85013 |
10051 |
product |
20622 |
A |
3 |
|
20622 |
0 |
5ca0ce9e0280680f8ed57770d04d2fb8b43b8d57-tc-img-preview.jpg |
800 |
500 |
N |
18656 |
10053 |
product |
20618 |
A |
4 |
|
20618 |
0 |
41T3e3H8I8L._SL1000__nugc-0g.jpg |
1000 |
1000 |
N |
85014 |
10051 |
product |
20623 |
A |
4 |
|
20623 |
0 |
51o7_Su85XL._SL1000__63yp-2r.jpg |
1000 |
1000 |
N |
85015 |
10051 |
product |
20624 |
A |
5 |
|
20624 |
0 |
413ahkvORvL._SX466_.jpg |
466 |
466 |
N |
17955 |
8583 |
product |
19917 |
A |
10 |
|
19917 |
0 |
514rtKh8xtL.jpg |
500 |
415 |
N |
17959 |
8584 |
product |
19921 |
A |
10 |
|
19921 |
0 |
419yRXc-H1L.jpg |
500 |
390 |
N |
17961 |
8585 |
product |
19923 |
A |
10 |
|
19923 |
0 |
51Oi2S6psYL.jpg |
500 |
500 |
N |
17963 |
8586 |
product |
19925 |
A |
10 |
|
19925 |
0 |
81qe62LREvL._SL1500_.jpg |
1500 |
1500 |
N |
17965 |
8587 |
product |
19927 |
A |
10 |
|
19927 |
0 |
61NTn2PhGxL.jpg |
500 |
500 |
N |
17971 |
8589 |
product |
19933 |
A |
10 |
|
19933 |
0 |
41nkLoddz4L.jpg |
500 |
500 |
N |
17977 |
8591 |
product |
19939 |
A |
10 |
|
19939 |
0 |
616D5R-Jb-L._SL1500_.jpg |
1500 |
889 |
N |
18609 |
10052 |
product |
20571 |
A |
10 |
|
20571 |
0 |
31IRAyN4InL.jpg |
500 |
500 |
N |
18617 |
10054 |
product |
20579 |
A |
10 |
|
20579 |
0 |
51dsKGmSIBL._SX466_.jpg |
466 |
466 |
N |
17956 |
8583 |
product |
19918 |
A |
20 |
|
19918 |
0 |
817GfjN6cEL._SL1500_.jpg |
1500 |
1500 |
N |
17966 |
8587 |
product |
19928 |
A |
20 |
|
19928 |
0 |
51dfzqCTgTL.jpg |
500 |
500 |
N |
17972 |
8589 |
product |
19934 |
A |
20 |
|
19934 |
0 |
61lyFp9Y15L._SL1500_.jpg |
1500 |
1084 |
N |
17978 |
8591 |
product |
19940 |
A |
20 |
|
19940 |
0 |
81kcDUAEXTL._SL1500_.jpg |
1500 |
1313 |
N |
18610 |
10052 |
product |
20572 |
A |
20 |
|
20572 |
0 |
51k9ttmbnrL._SX466_.jpg |
466 |
466 |
N |
17957 |
8583 |
product |
19919 |
A |
30 |
|
19919 |
0 |
61WeH2Q8XbL.jpg |
500 |
500 |
N |
17967 |
8587 |
product |
19929 |
A |
30 |
|
19929 |
0 |
41tlRJZPq_L.jpg |
500 |
500 |
N |
17973 |
8589 |
product |
19935 |
A |
30 |
|
19935 |
0 |
71vuwaCmtLL._SL1500_.jpg |
1500 |
1089 |
N |
17979 |
8591 |
product |
19941 |
A |
30 |
|
19941 |
0 |
61lZO07QTuL._SL1500_.jpg |
1500 |
818 |
N |
18611 |
10052 |
product |
20573 |
A |
30 |
|
20573 |
0 |
61p2iVAKmlL._SL1349_.jpg |
1100 |
1349 |
N |
17968 |
8587 |
product |
19930 |
A |
40 |
|
19930 |
0 |
81z0NsuInCL._SL1500_.jpg |
1500 |
999 |
N |
17974 |
8589 |
product |
19936 |
A |
40 |
|
19936 |
0 |
61VOi7qrMrL._SL1037_.jpg |
1037 |
1037 |
N |
18612 |
10052 |
product |
20574 |
A |
40 |
|
20574 |
0 |
814CEw9anpL._SL1500_.jpg |
1500 |
855 |
N |
18613 |
10052 |
product |
20575 |
A |
50 |
|
20575 |