Query time 0.00178
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "150.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 ('50232','50378','50240','50372','50310','50370','50308','50368','50283','50366','50301','50359','50360','50361','50362','50280','50342','50291','50340','50272','50327','50334','50276','50333','50269','50325')))",
"cost_info": {
"read_cost": "57.21",
"eval_cost": "5.20",
"prefix_cost": "62.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": "93.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": "124.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 |
hz16-04d-1.JPG |
500 |
500 |
N |
81278 |
50240 |
product |
83221 |
M |
0 |
|
83221 |
0 |
hz17-15d-1.JPG |
500 |
500 |
N |
81934 |
50301 |
product |
83877 |
M |
0 |
|
83877 |
0 |
hz17-02d-1.JPG |
500 |
500 |
N |
82446 |
50325 |
product |
84389 |
M |
0 |
|
84389 |
0 |
hz17-03s-1_cutq-ex.JPG |
500 |
500 |
N |
82449 |
50327 |
product |
84392 |
M |
0 |
|
84392 |
0 |
hz17-03k-1.JPG |
500 |
500 |
N |
82455 |
50334 |
product |
84398 |
M |
0 |
|
84398 |
0 |
hz17-11k-1_bbcm-58.JPG |
500 |
500 |
N |
82469 |
50340 |
product |
84412 |
M |
0 |
|
84412 |
0 |
hz17-07d-1.JPG |
500 |
500 |
N |
82470 |
50342 |
product |
84413 |
M |
0 |
|
84413 |
0 |
hz17-08k-1_puvh-eq.JPG |
500 |
500 |
N |
82479 |
50366 |
product |
84422 |
M |
0 |
|
84422 |
0 |
hz17-19d-1.JPG |
500 |
500 |
N |
82482 |
50370 |
product |
84425 |
M |
0 |
|
84425 |
0 |
hz16-04d-1.JPG |
500 |
500 |
N |
82484 |
50372 |
product |
84427 |
M |
0 |
|
84427 |
0 |
hz16-01d-1.JPG |
500 |
500 |
N |
82489 |
50378 |
product |
84432 |
M |
0 |
|
84432 |
0 |
hz17-02d-1_gpqb-mi.JPG |
500 |
500 |
N |
85897 |
50269 |
product |
84390 |
M |
0 |
|
84390 |
0 |
hz17-03s-1.JPG |
500 |
500 |
N |
85898 |
50272 |
product |
84391 |
M |
0 |
|
84391 |
0 |
hz17-05d-1.JPG |
500 |
500 |
N |
85902 |
50333 |
product |
83802 |
M |
0 |
|
83802 |
0 |
hz17-05d-1.JPG |
500 |
500 |
N |
85903 |
50276 |
product |
84397 |
M |
0 |
|
84397 |
0 |
hz17-11k-1.JPG |
500 |
500 |
N |
85906 |
50291 |
product |
84411 |
M |
0 |
|
84411 |
0 |
hz17-07d-1_1shk-36.JPG |
500 |
500 |
N |
85907 |
50280 |
product |
84414 |
M |
0 |
|
84414 |
0 |
hz17-15d-1.JPG |
500 |
500 |
N |
85922 |
50359 |
product |
83877 |
M |
0 |
|
83877 |
0 |
hz17-15d-1.JPG |
500 |
500 |
N |
85923 |
50360 |
product |
83877 |
M |
0 |
|
83877 |
0 |
hz17-15d-1.JPG |
500 |
500 |
N |
85924 |
50361 |
product |
83877 |
M |
0 |
|
83877 |
0 |
hz17-15d-1.JPG |
500 |
500 |
N |
85925 |
50362 |
product |
83877 |
M |
0 |
|
83877 |
0 |
hz17-08k-1.JPG |
500 |
500 |
N |
85926 |
50283 |
product |
84421 |
M |
0 |
|
84421 |
0 |
hz17-18d-1_r6l5-fe_6okh-ct.JPG |
500 |
500 |
N |
85927 |
50308 |
product |
84424 |
M |
0 |
|
84424 |
0 |
hz17-19d-1_05a2-5n.JPG |
500 |
500 |
N |
85928 |
50310 |
product |
84426 |
M |
0 |
|
84426 |
0 |
hz16-01d-1_exu4-il.JPG |
500 |
500 |
N |
85934 |
50232 |
product |
84433 |
M |
0 |
|
84433 |
0 |
hz17-18d-1_r6l5-fe.JPG |
500 |
500 |
N |
82480 |
50368 |
product |
84423 |
M |
1 |
|
84423 |