Query time 0.00097
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 (12669,12975,2299,2297,2298,2203,2566,3215,3214,11118,12685,13990,2340,11888,2339,2338,2180,2181,13661,15141,2228,2226,2227,2336,12743,2185,14298,15154,13222,15155) 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 |
2180 |
|
B |
2018 |
2181 |
|
B |
2019 |
2185 |
|
B |
2023 |
2203 |
|
B |
2041 |
2226 |
|
B |
2064 |
2227 |
|
B |
2065 |
2228 |
|
B |
2066 |
2297 |
|
B |
2135 |
2298 |
|
B |
2136 |
2299 |
|
B |
2137 |
2336 |
|
B |
2174 |
2338 |
|
B |
2176 |
2339 |
|
B |
2177 |
2340 |
|
B |
2178 |
2566 |
|
B |
2404 |
3214 |
|
B |
3054 |
3215 |
|
B |
3055 |
11118 |
|
B |
12116 |
11888 |
|
B |
12943 |
12669 |
|
B |
13721 |
12685 |
|
B |
13737 |
12743 |
|
B |
13796 |
12975 |
|
B |
14039 |
13222 |
|
B |
14277 |
13661 |
|
B |
14607 |
13990 |
|
B |
14905 |
14298 |
|
B |
15213 |
15141 |
|
B |
15971 |
15154 |
|
B |
15984 |
15155 |
|
B |
15985 |