Query time 0.00166
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "174.41"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "33.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": 33,
"rows_produced_per_join": 33,
"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 ('2988','2992','2997','3002','3007','3012','2802','2807','2808','2384','2385','2386','2388','2389','2390','2391')))",
"cost_info": {
"read_cost": "55.61",
"eval_cost": "6.60",
"prefix_cost": "62.21",
"data_read_per_join": "3K"
},
"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": 33,
"filtered": "100.00",
"cost_info": {
"read_cost": "33.00",
"eval_cost": "6.60",
"prefix_cost": "101.81",
"data_read_per_join": "25K"
},
"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": 33,
"filtered": "100.00",
"cost_info": {
"read_cost": "33.00",
"eval_cost": "6.60",
"prefix_cost": "141.41",
"data_read_per_join": "19K"
},
"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 |
|
|
|
|
8062 |
2992 |
product |
10027 |
A |
1 |
|
|
0 |
|
|
|
|
8202 |
3012 |
product |
10167 |
A |
1 |
|
|
0 |
|
|
|
|
8226 |
2807 |
product |
10191 |
A |
1 |
|
|
0 |
|
|
|
|
8233 |
2808 |
product |
10198 |
A |
1 |
|
|
0 |
|
|
|
|
8063 |
2992 |
product |
10028 |
A |
2 |
|
|
0 |
|
|
|
|
8203 |
3012 |
product |
10168 |
A |
2 |
|
|
0 |
|
|
|
|
8227 |
2807 |
product |
10192 |
A |
2 |
|
|
0 |
|
|
|
|
8234 |
2808 |
product |
10199 |
A |
2 |
|
|
0 |
|
|
|
|
8064 |
2992 |
product |
10029 |
A |
3 |
|
|
0 |
|
|
|
|
8204 |
3012 |
product |
10169 |
A |
3 |
|
|
0 |
|
|
|
|
8228 |
2807 |
product |
10193 |
A |
3 |
|
|
0 |
|
|
|
|
8235 |
2808 |
product |
10200 |
A |
3 |
|
|
0 |
|
|
|
|
8065 |
2992 |
product |
10030 |
A |
4 |
|
|
0 |
|
|
|
|
8205 |
3012 |
product |
10170 |
A |
4 |
|
|
0 |
|
|
|
|
8229 |
2807 |
product |
10194 |
A |
4 |
|
|
0 |
|
|
|
|
8236 |
2808 |
product |
10201 |
A |
4 |
|
|
0 |
|
|
|
|
8066 |
2992 |
product |
10031 |
A |
5 |
|
|
0 |
|
|
|
|
8231 |
2807 |
product |
10196 |
A |
5 |
|
|
0 |
|
|
|
|
8067 |
2992 |
product |
10032 |
A |
6 |
|
|
0 |
|
|
|
|
8068 |
2992 |
product |
10033 |
A |
7 |
|
|
0 |
|
|
|
|
5586 |
2384 |
product |
7557 |
A |
10 |
|
|
0 |
|
|
|
|
5591 |
2385 |
product |
7562 |
A |
10 |
|
|
0 |
|
|
|
|
5594 |
2386 |
product |
7565 |
A |
10 |
|
|
0 |
|
|
|
|
5601 |
2388 |
product |
7572 |
A |
10 |
|
|
0 |
|
|
|
|
5604 |
2389 |
product |
7575 |
A |
10 |
|
|
0 |
|
|
|
|
5610 |
2391 |
product |
7581 |
A |
10 |
|
|
0 |
|
|
|
|
5653 |
2386 |
product |
7624 |
A |
10 |
|
|
0 |
|
|
|
|
5662 |
2390 |
product |
7633 |
A |
10 |
|
|
0 |
|
|
|
|
6202 |
2802 |
product |
8170 |
A |
10 |
|
|
0 |
|
|
|
|
5587 |
2384 |
product |
7558 |
A |
20 |
|
|
0 |
|
|
|
|
5592 |
2385 |
product |
7563 |
A |
20 |
|
|
0 |
|
|
|
|
5595 |
2386 |
product |
7566 |
A |
20 |
|
|
0 |
|
|
|
|
5602 |
2388 |
product |
7573 |
A |
20 |
|
|
0 |
|
|
|
|
5605 |
2389 |
product |
7576 |
A |
20 |
|
|
0 |
|
|
|
|
5611 |
2391 |
product |
7582 |
A |
20 |
|
|
0 |
|
|
|
|
5654 |
2386 |
product |
7625 |
A |
20 |
|
|
0 |
|
|
|
|
5663 |
2390 |
product |
7634 |
A |
20 |
|
|
0 |
|
|
|
|
6203 |
2802 |
product |
8171 |
A |
20 |
|
|
0 |
|
|
|
|
5588 |
2384 |
product |
7559 |
A |
30 |
|
|
0 |
|
|
|
|
5596 |
2386 |
product |
7567 |
A |
30 |
|
|
0 |
|
|
|
|
5655 |
2386 |
product |
7626 |
A |
30 |
|
|
0 |
|
|
|
|
6204 |
2802 |
product |
8172 |
A |
30 |
|
|
0 |
|
|
|
|
5589 |
2384 |
product |
7560 |
A |
40 |
|
|
0 |
|
|
|
|
6205 |
2802 |
product |
8173 |
A |
40 |
|
|
0 |
|
|
|
|
6206 |
2802 |
product |
8174 |
A |
50 |
|
|
0 |
|
|
|
|
82498 |
2802 |
product |
84441 |
A |
51 |
|
|
0 |
|
|
|
|
8172 |
3007 |
product |
10137 |
A |
52 |
|
|
0 |
|
|
|
|
8173 |
3007 |
product |
10138 |
A |
53 |
|
|
0 |
|
|
|
|
8174 |
3007 |
product |
10139 |
A |
54 |
|
|
0 |
|
|
|
|
8175 |
3007 |
product |
10140 |
A |
55 |
|
|
0 |
|
|
|
|
8176 |
3007 |
product |
10141 |
A |
56 |
|
|
0 |
|
|
|
|
8102 |
2997 |
product |
10067 |
A |
62 |
|
|
0 |
|
|
|
|
8137 |
3002 |
product |
10102 |
A |
62 |
|
|
0 |
|
|
|
|
8103 |
2997 |
product |
10068 |
A |
63 |
|
|
0 |
|
|
|
|
8138 |
3002 |
product |
10103 |
A |
63 |
|
|
0 |
|
|
|
|
8104 |
2997 |
product |
10069 |
A |
64 |
|
|
0 |
|
|
|
|
8139 |
3002 |
product |
10104 |
A |
64 |
|
|
0 |
|
|
|
|
8105 |
2997 |
product |
10070 |
A |
65 |
|
|
0 |
|
|
|
|
8140 |
3002 |
product |
10105 |
A |
65 |
|
|
0 |
|
|
|
|
8106 |
2997 |
product |
10071 |
A |
66 |
|
|
0 |
|
|
|
|
8141 |
3002 |
product |
10106 |
A |
66 |
|
|
0 |
|
|
|
|
8107 |
2997 |
product |
10072 |
A |
67 |
|
|
0 |
|
|
|
|
8142 |
3002 |
product |
10107 |
A |
67 |
|
|