Query time 0.00153
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "140.81"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "26.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": 26,
"rows_produced_per_join": 26,
"filtered": "100.00",
"index_condition": "((`portal`.`q_images_links`.`object_type` = 'product') and (`portal`.`q_images_links`.`type` = 'M') and (`portal`.`q_images_links`.`object_id` in ('30848','30849','30850','30851','30852','30853','30854','30855','30856','30857','30858','30859','30860','30861','30862','30863')))",
"cost_info": {
"read_cost": "47.21",
"eval_cost": "5.20",
"prefix_cost": "52.41",
"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": 26,
"filtered": "100.00",
"cost_info": {
"read_cost": "26.00",
"eval_cost": "5.20",
"prefix_cost": "83.61",
"data_read_per_join": "19K"
},
"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": 26,
"filtered": "100.00",
"cost_info": {
"read_cost": "26.00",
"eval_cost": "5.20",
"prefix_cost": "114.81",
"data_read_per_join": "15K"
},
"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 |
51D-3L1IBnL._SL1024_.jpg |
1024 |
1024 |
N |
48892 |
30863 |
product |
50853 |
M |
0 |
|
50853 |
0 |
61VaZoq_x9L._SL1000_.jpg |
1000 |
1000 |
N |
48894 |
30862 |
product |
50855 |
M |
0 |
|
50855 |
0 |
41tEkwBn7xL.jpg |
500 |
500 |
N |
48897 |
30859 |
product |
50858 |
M |
0 |
|
50858 |
0 |
51FHkyAkvYL._SL1000_.jpg |
1000 |
1000 |
N |
48900 |
30858 |
product |
50861 |
M |
0 |
|
50861 |
0 |
51yT1dVOT3L.jpg |
500 |
460 |
N |
48904 |
30856 |
product |
50865 |
M |
0 |
|
50865 |
0 |
714gNhup6CL._SL1000_.jpg |
1000 |
1000 |
N |
48906 |
30855 |
product |
50867 |
M |
0 |
|
50867 |
0 |
61CPfT8oVcL._SL1000_.jpg |
1000 |
1000 |
N |
48907 |
30854 |
product |
50868 |
M |
0 |
|
50868 |
0 |
51o-IJzsWdL._SL1024_.jpg |
1024 |
1024 |
N |
48908 |
30853 |
product |
50869 |
M |
0 |
|
50869 |
0 |
61oGQ8zyqxL._SL1000_.jpg |
1000 |
998 |
N |
48910 |
30852 |
product |
50871 |
M |
0 |
|
50871 |
0 |
51uNGrnp-4L._SL1210_.jpg |
1210 |
1000 |
N |
48911 |
30851 |
product |
50872 |
M |
0 |
|
50872 |
0 |
61wjFWU_GIL._SX385_.jpg |
385 |
385 |
N |
48912 |
30850 |
product |
50873 |
M |
0 |
|
50873 |
0 |
41WuH5oqvyL._SL1363_.jpg |
1363 |
721 |
N |
48914 |
30848 |
product |
50875 |
M |
0 |
|
50875 |
0 |
coffee_whisk.jpg |
640 |
626 |
N |
50990 |
30860 |
product |
52951 |
M |
0 |
|
52951 |
0 |
bag.jpg |
640 |
626 |
N |
51698 |
30849 |
product |
53659 |
M |
0 |
|
53659 |
0 |
61WGAaBrBLL._SL1024_.jpg |
1024 |
1024 |
N |
65521 |
30861 |
product |
67472 |
M |
0 |
|
67472 |
0 |
2_x5a9-fg.jpg |
640 |
626 |
N |
82607 |
30857 |
product |
84550 |
M |
0 |
|
84550 |