{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "16.36"
},
"table": {
"table_name": "q_companies",
"access_type": "ALL",
"rows_examined_per_scan": 49,
"rows_produced_per_join": 14,
"filtered": "30.00",
"cost_info": {
"read_cost": "13.42",
"eval_cost": "2.94",
"prefix_cost": "16.36",
"data_read_per_join": "81K"
},
"used_columns": [
"company_id",
"status"
],
"attached_condition": "(`portal`.`q_companies`.`status` in ('A','P','N'))"
}
}
}
company_id |
---|
2 |
3 |
5 |
9 |
11 |
12 |
17 |
21 |
26 |
28 |
33 |
34 |
41 |
42 |
51 |
57 |
59 |
61 |
62 |
64 |
65 |
66 |
70 |
79 |
86 |
111 |
112 |
102 |
115 |
118 |
120 |
131 |
172 |
173 |
136 |
164 |
152 |
462 |
457 |
466 |
459 |
460 |
461 |
463 |
465 |