id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | d | const | PRIMARY,object_id,idx_company_id | object_id | 10 | const,const,const | 1 | |
1 | SIMPLE | dp | ref | PRIMARY,thread_id,thread_id_2 | thread_id_2 | 6 | const,const | 2 | Using index condition |
1 | SIMPLE | dr | eq_ref | PRIMARY | PRIMARY | 3 | cscart_dev_4_16.dp.post_id | 1 | Using where |
AVG (dr.rating_value) |
---|
4.5000 |