Query time 0.00126
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "112.01"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "20.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": 20,
"rows_produced_per_join": 20,
"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 ('14835','14836','14837','14838','14839','14840','14841','14842','14843','14844','14845','14846','14847','14848','14849','14850')))",
"cost_info": {
"read_cost": "40.01",
"eval_cost": "4.00",
"prefix_cost": "44.01",
"data_read_per_join": "1K"
},
"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": 20,
"filtered": "100.00",
"cost_info": {
"read_cost": "20.00",
"eval_cost": "4.00",
"prefix_cost": "68.01",
"data_read_per_join": "15K"
},
"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": 20,
"filtered": "100.00",
"cost_info": {
"read_cost": "20.00",
"eval_cost": "4.00",
"prefix_cost": "92.01",
"data_read_per_join": "11K"
},
"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 |
510aMO1HxFL.jpg |
500 |
500 |
N |
28743 |
14835 |
product |
30705 |
M |
0 |
|
30705 |
0 |
41mCocOC22L.jpg |
500 |
419 |
N |
28744 |
14836 |
product |
30706 |
M |
0 |
|
30706 |
0 |
31_Z02j-RSL.jpg |
500 |
500 |
N |
28745 |
14837 |
product |
30707 |
M |
0 |
|
30707 |
0 |
31rByoAJBIL.jpg |
500 |
500 |
N |
28746 |
14838 |
product |
30708 |
M |
0 |
|
30708 |
0 |
31TJ1MX3-WL.jpg |
500 |
500 |
N |
28747 |
14839 |
product |
30709 |
M |
0 |
|
30709 |
0 |
41BoL7tPYbL.jpg |
500 |
500 |
N |
28748 |
14840 |
product |
30710 |
M |
0 |
|
30710 |
0 |
51OH19WSleL.jpg |
500 |
375 |
N |
28749 |
14841 |
product |
30711 |
M |
0 |
|
30711 |
0 |
41LvIZTv3bL.jpg |
500 |
500 |
N |
28750 |
14842 |
product |
30712 |
M |
0 |
|
30712 |
0 |
41ZADqWJHkL.jpg |
500 |
310 |
N |
28751 |
14843 |
product |
30713 |
M |
0 |
|
30713 |
0 |
41nxbOH2bnL.jpg |
500 |
311 |
N |
28752 |
14844 |
product |
30714 |
M |
0 |
|
30714 |
0 |
21qpD-AitML.jpg |
500 |
333 |
N |
28753 |
14845 |
product |
30715 |
M |
0 |
|
30715 |
0 |
41WMZG_DGiL.jpg |
500 |
500 |
N |
28754 |
14846 |
product |
30716 |
M |
0 |
|
30716 |
0 |
3192uJjSPyL.jpg |
500 |
343 |
N |
28755 |
14847 |
product |
30717 |
M |
0 |
|
30717 |
0 |
411RNgayN8L.jpg |
500 |
500 |
N |
28756 |
14848 |
product |
30718 |
M |
0 |
|
30718 |
0 |
41PIuHxuLTL.jpg |
500 |
500 |
N |
28757 |
14849 |
product |
30719 |
M |
0 |
|
30719 |
0 |
31F431ftdFL.jpg |
400 |
400 |
N |
28758 |
14850 |
product |
30720 |
M |
0 |
|
30720 |