Query time 0.00109
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "116.81"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "21.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": 21,
"rows_produced_per_join": 21,
"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 ('12995','12996','12997','12998','12999','13000','13001','13002','13003','13004','13005','13006','13007','13008','13009','13010')))",
"cost_info": {
"read_cost": "41.21",
"eval_cost": "4.20",
"prefix_cost": "45.41",
"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": 21,
"filtered": "100.00",
"cost_info": {
"read_cost": "21.00",
"eval_cost": "4.20",
"prefix_cost": "70.61",
"data_read_per_join": "16K"
},
"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": 21,
"filtered": "100.00",
"cost_info": {
"read_cost": "21.00",
"eval_cost": "4.20",
"prefix_cost": "95.81",
"data_read_per_join": "12K"
},
"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 |
c5079e151a20fb034351eeb46801f023.jpg |
700 |
600 |
N |
26633 |
12996 |
product |
28595 |
M |
0 |
|
28595 |
0 |
bbe34f0e7113ba63ab64a5dcf12b96f1.jpg |
700 |
600 |
N |
26634 |
12997 |
product |
28596 |
M |
0 |
|
28596 |
0 |
34d97ed6e9b933a62c964dea4cfdc306.jpg |
700 |
600 |
N |
26635 |
12998 |
product |
28597 |
M |
0 |
|
28597 |
0 |
1fa2f11a22c64b0cc7fee8ccdeabd599.jpg |
700 |
600 |
N |
26636 |
12999 |
product |
28598 |
M |
0 |
|
28598 |
0 |
e8e40aaad1f9486ffc2e42f48ca15607.jpg |
700 |
600 |
N |
26637 |
13000 |
product |
28599 |
M |
0 |
|
28599 |
0 |
ed2b616455c592b92054ae54630b0a65.jpg |
700 |
600 |
N |
26638 |
13001 |
product |
28600 |
M |
0 |
|
28600 |
0 |
.jpg |
500 |
600 |
N |
26640 |
13003 |
product |
28602 |
M |
0 |
|
28602 |
0 |
81HqbW83DAL._UY606_.jpg |
322 |
606 |
N |
26641 |
13004 |
product |
28603 |
M |
0 |
|
28603 |
0 |
9c521d6e4a956eeb344a6726a8d8d4225292f686_cbfea3e6e1c5221b8dec44b6119445f93aabbb2a_25-1.jpg |
496 |
496 |
N |
26642 |
13005 |
product |
28604 |
M |
0 |
|
28604 |
0 |
edb41b45211cdfdfc186867262597c7f52cc10de_a24fef7139c87dca2e40ae5ad2683db963845710_26-1.jpg |
499 |
499 |
N |
26643 |
13006 |
product |
28605 |
M |
0 |
|
28605 |
0 |
71_JIFzs8EL._SY679_.jpg |
480 |
679 |
N |
26644 |
13007 |
product |
28606 |
M |
0 |
|
28606 |
0 |
71_JIFzs8EL._SY606_.jpg |
428 |
606 |
N |
26645 |
13008 |
product |
28607 |
M |
0 |
|
28607 |
0 |
71Nf_lta2yL._UX679_.jpg |
679 |
679 |
N |
26646 |
13009 |
product |
28608 |
M |
0 |
|
28608 |
0 |
61z-Uk-7_cL._UY879_.jpg |
660 |
879 |
N |
26647 |
13010 |
product |
28609 |
M |
0 |
|
28609 |
0 |
85981899846-ana.jpg |
569 |
550 |
N |
30721 |
12997 |
product |
32683 |
M |
0 |
|
32683 |
0 |
08d8f5953ae09b4c44b0e8ba882a5aaf.jpg |
1000 |
1000 |
N |
30722 |
13002 |
product |
32684 |
M |
0 |
|
32684 |
0 |
casio_watch_web.jpg |
640 |
626 |
N |
65552 |
12995 |
product |
67503 |
M |
0 |
|
67503 |