Query time 0.00038
JSON explain
{
"query_block": {
"select_id": 1,
"table": {
"table_name": "cscart_discussion",
"access_type": "range",
"possible_keys": ["object_id"],
"key": "object_id",
"key_length": "6",
"used_key_parts": ["object_id", "object_type"],
"rows": 30,
"filtered": 100,
"index_condition": "cscart_discussion.object_id in (4340,2364,13765,13826,13993,2218,2349,2178,2177,11786,2827,2640,2312,2309,2310,2311,3236,4344,3221,3225,3218,3246,3222,4347,3242,12675,11361,12647,12880,12670) and cscart_discussion.object_type = 'P'"
},
"table": {
"table_name": "cscart_discussion_posts",
"access_type": "ref",
"possible_keys": ["thread_id", "thread_id_2"],
"key": "thread_id_2",
"key_length": "6",
"used_key_parts": ["thread_id", "status"],
"ref": ["ymonline_livedata.cscart_discussion.thread_id", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_discussion_posts.`status` = 'A')"
},
"table": {
"table_name": "cscart_discussion_rating",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY", "thread_id"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["post_id"],
"ref": ["ymonline_livedata.cscart_discussion_posts.post_id"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_discussion_rating.thread_id = cscart_discussion.thread_id and cscart_discussion_rating.rating_value <> 0 and trigcond(cscart_discussion_posts.post_id is not null))"
}
}
}
Result
product_id |
average_rating |
discussion_type |
discussion_thread_id |
2177 |
|
B |
2015 |
2178 |
|
B |
2016 |
2218 |
|
B |
2056 |
2309 |
|
B |
2147 |
2310 |
|
B |
2148 |
2311 |
|
B |
2149 |
2312 |
|
B |
2150 |
2349 |
|
B |
2187 |
2364 |
|
B |
2202 |
2640 |
|
B |
2478 |
2827 |
|
B |
2665 |
3218 |
|
B |
3070 |
3221 |
|
B |
3075 |
3222 |
|
B |
3076 |
3225 |
|
B |
3080 |
3236 |
|
B |
3077 |
3242 |
|
B |
3083 |
3246 |
|
B |
3087 |
4340 |
|
B |
4213 |
4344 |
|
B |
4217 |
4347 |
|
B |
3072 |
11361 |
|
B |
12378 |
11786 |
|
B |
12838 |
12647 |
|
B |
13699 |
12670 |
|
B |
13722 |
12675 |
|
B |
13727 |
12880 |
|
B |
13939 |
13765 |
|
B |
14698 |
13826 |
|
B |
14759 |
13993 |
|
B |
14908 |