Query time 0.00199
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "255.61"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "47.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": 47,
"rows_produced_per_join": 47,
"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 ('41278','41279','41280','41281','41282','41283','41284','41285','41286','41287','41288','41289','41290','41291','41292','41293','41294','41295','41296','41297','41298','41299','41300','41301','41302','41303','41304','41305','41306','41307')))",
"cost_info": {
"read_cost": "86.41",
"eval_cost": "9.40",
"prefix_cost": "95.81",
"data_read_per_join": "4K"
},
"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": 47,
"filtered": "100.00",
"cost_info": {
"read_cost": "47.00",
"eval_cost": "9.40",
"prefix_cost": "152.21",
"data_read_per_join": "35K"
},
"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": 47,
"filtered": "100.00",
"cost_info": {
"read_cost": "47.00",
"eval_cost": "9.40",
"prefix_cost": "208.61",
"data_read_per_join": "27K"
},
"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 |
N18629519A_1.jpg |
800 |
1091 |
N |
66817 |
41278 |
product |
68768 |
M |
0 |
|
68768 |
0 |
N15031388A_1.jpg |
800 |
1091 |
N |
66818 |
41279 |
product |
68769 |
M |
0 |
|
68769 |
0 |
N15031390A_1.jpg |
800 |
1091 |
N |
66821 |
41281 |
product |
68772 |
M |
0 |
|
68772 |
0 |
N18629523A_1.jpg |
800 |
1091 |
N |
66822 |
41282 |
product |
68773 |
M |
0 |
|
68773 |
0 |
N15031392A_1.jpg |
800 |
1091 |
N |
66823 |
41283 |
product |
68774 |
M |
0 |
|
68774 |
0 |
N15031393A_1.jpg |
800 |
1091 |
N |
66824 |
41284 |
product |
68775 |
M |
0 |
|
68775 |
0 |
N15031396A_1.jpg |
800 |
1091 |
N |
66828 |
41287 |
product |
68779 |
M |
0 |
|
68779 |
0 |
N15031398A_1.jpg |
800 |
1091 |
N |
66831 |
41290 |
product |
68782 |
M |
0 |
|
68782 |
0 |
N18629530A_1.jpg |
800 |
1091 |
N |
66832 |
41291 |
product |
68783 |
M |
0 |
|
68783 |
0 |
N15031400A_1.jpg |
800 |
1091 |
N |
66836 |
41293 |
product |
68787 |
M |
0 |
|
68787 |
0 |
N18629531A_1.jpg |
800 |
1091 |
N |
66837 |
41294 |
product |
68788 |
M |
0 |
|
68788 |
0 |
N18629532A_1.jpg |
800 |
1091 |
N |
66838 |
41295 |
product |
68789 |
M |
0 |
|
68789 |
0 |
N15031401A_1.jpg |
800 |
1091 |
N |
66839 |
41296 |
product |
68790 |
M |
0 |
|
68790 |
0 |
N15031402A_1.jpg |
800 |
1091 |
N |
66840 |
41297 |
product |
68791 |
M |
0 |
|
68791 |
0 |
N15031403A_1.jpg |
800 |
1091 |
N |
66842 |
41298 |
product |
68793 |
M |
0 |
|
68793 |
0 |
N18629533A_1.jpg |
800 |
1091 |
N |
66844 |
41300 |
product |
68795 |
M |
0 |
|
68795 |
0 |
N15031406A_1.jpg |
800 |
1091 |
N |
66846 |
41302 |
product |
68797 |
M |
0 |
|
68797 |
0 |
N18629534A_1.jpg |
800 |
1091 |
N |
66847 |
41303 |
product |
68798 |
M |
0 |
|
68798 |
0 |
N18629535A_1.jpg |
800 |
1091 |
N |
66848 |
41304 |
product |
68799 |
M |
0 |
|
68799 |
0 |
N15031407A_1.jpg |
800 |
1091 |
N |
66849 |
41305 |
product |
68800 |
M |
0 |
|
68800 |
0 |
N15031408A_1.jpg |
800 |
1091 |
N |
66850 |
41306 |
product |
68801 |
M |
0 |
|
68801 |
0 |
N15031409A_1.jpg |
800 |
1091 |
N |
66851 |
41307 |
product |
68802 |
M |
0 |
|
68802 |
0 |
2_2mrm-b8.jpg |
640 |
626 |
N |
81506 |
41280 |
product |
83449 |
M |
0 |
|
83449 |
0 |
2_jwea-37.jpg |
640 |
626 |
N |
81528 |
41301 |
product |
83471 |
M |
0 |
|
83471 |
0 |
2_njr4-ph.jpg |
640 |
626 |
N |
81531 |
41299 |
product |
83474 |
M |
0 |
|
83474 |
0 |
2_bax6-vy.jpg |
640 |
626 |
N |
81553 |
41286 |
product |
83496 |
M |
0 |
|
83496 |
0 |
2_awc4-ov.jpg |
640 |
626 |
N |
81554 |
41288 |
product |
83497 |
M |
0 |
|
83497 |
0 |
N15031394A_1.jpg |
800 |
1091 |
N |
66825 |
41285 |
product |
68776 |
M |
1 |
|
68776 |
0 |
N15031394A_1_eu4g-hm.jpg |
800 |
1091 |
N |
66826 |
41285 |
product |
68777 |
M |
1 |
|
68777 |
0 |
N18629528A_1.jpg |
800 |
1091 |
N |
66830 |
41289 |
product |
68781 |
M |
1 |
|
68781 |
0 |
N18629530A_1_jl1j-mo.jpg |
800 |
1091 |
N |
66835 |
41292 |
product |
68786 |
M |
1 |
|
68786 |