Query time 0.00121
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "150.41"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "28.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": 28,
"rows_produced_per_join": 28,
"filtered": "100.00",
"index_condition": "((`portal`.`q_images_links`.`object_type` = 'product') and (`portal`.`q_images_links`.`type` = 'A') and (`portal`.`q_images_links`.`object_id` in ('10051','10052','10053','10054','8682','8662','8582','8583','8584','8585','8586','8587','8588','8589','8590','8591')))",
"cost_info": {
"read_cost": "49.61",
"eval_cost": "5.60",
"prefix_cost": "55.21",
"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.image_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 28,
"filtered": "100.00",
"cost_info": {
"read_cost": "28.00",
"eval_cost": "5.60",
"prefix_cost": "88.81",
"data_read_per_join": "21K"
},
"used_columns": [
"image_id",
"image_path",
"image_x",
"image_y",
"is_high_res"
]
}
},
{
"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": 28,
"filtered": "100.00",
"cost_info": {
"read_cost": "28.00",
"eval_cost": "5.60",
"prefix_cost": "122.41",
"data_read_per_join": "16K"
},
"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 |
|
|
|
|
18172 |
8662 |
product |
20134 |
A |
1 |
|
|
0 |
|
|
|
|
18185 |
8682 |
product |
20147 |
A |
1 |
|
|
0 |
|
|
|
|
18614 |
10053 |
product |
20576 |
A |
1 |
|
|
0 |
|
|
|
|
85011 |
10051 |
product |
20620 |
A |
1 |
|
|
0 |
|
|
|
|
18175 |
8662 |
product |
20137 |
A |
2 |
|
|
0 |
|
|
|
|
18186 |
8682 |
product |
20148 |
A |
2 |
|
|
0 |
|
|
|
|
18615 |
10053 |
product |
20577 |
A |
2 |
|
|
0 |
|
|
|
|
85012 |
10051 |
product |
20621 |
A |
2 |
|
|
0 |
|
|
|
|
18187 |
8682 |
product |
20149 |
A |
3 |
|
|
0 |
|
|
|
|
18655 |
10053 |
product |
20617 |
A |
3 |
|
|
0 |
|
|
|
|
85013 |
10051 |
product |
20622 |
A |
3 |
|
|
0 |
|
|
|
|
18656 |
10053 |
product |
20618 |
A |
4 |
|
|
0 |
|
|
|
|
85014 |
10051 |
product |
20623 |
A |
4 |
|
|
0 |
|
|
|
|
85015 |
10051 |
product |
20624 |
A |
5 |
|
|
0 |
|
|
|
|
17955 |
8583 |
product |
19917 |
A |
10 |
|
|
0 |
|
|
|
|
17959 |
8584 |
product |
19921 |
A |
10 |
|
|
0 |
|
|
|
|
17961 |
8585 |
product |
19923 |
A |
10 |
|
|
0 |
|
|
|
|
17963 |
8586 |
product |
19925 |
A |
10 |
|
|
0 |
|
|
|
|
17965 |
8587 |
product |
19927 |
A |
10 |
|
|
0 |
|
|
|
|
17971 |
8589 |
product |
19933 |
A |
10 |
|
|
0 |
|
|
|
|
17977 |
8591 |
product |
19939 |
A |
10 |
|
|
0 |
|
|
|
|
18609 |
10052 |
product |
20571 |
A |
10 |
|
|
0 |
|
|
|
|
18617 |
10054 |
product |
20579 |
A |
10 |
|
|
0 |
|
|
|
|
17956 |
8583 |
product |
19918 |
A |
20 |
|
|
0 |
|
|
|
|
17966 |
8587 |
product |
19928 |
A |
20 |
|
|
0 |
|
|
|
|
17972 |
8589 |
product |
19934 |
A |
20 |
|
|
0 |
|
|
|
|
17978 |
8591 |
product |
19940 |
A |
20 |
|
|
0 |
|
|
|
|
18610 |
10052 |
product |
20572 |
A |
20 |
|
|
0 |
|
|
|
|
17957 |
8583 |
product |
19919 |
A |
30 |
|
|
0 |
|
|
|
|
17967 |
8587 |
product |
19929 |
A |
30 |
|
|
0 |
|
|
|
|
17973 |
8589 |
product |
19935 |
A |
30 |
|
|
0 |
|
|
|
|
17979 |
8591 |
product |
19941 |
A |
30 |
|
|
0 |
|
|
|
|
18611 |
10052 |
product |
20573 |
A |
30 |
|
|
0 |
|
|
|
|
17968 |
8587 |
product |
19930 |
A |
40 |
|
|
0 |
|
|
|
|
17974 |
8589 |
product |
19936 |
A |
40 |
|
|
0 |
|
|
|
|
18612 |
10052 |
product |
20574 |
A |
40 |
|
|
0 |
|
|
|
|
18613 |
10052 |
product |
20575 |
A |
50 |
|
|