Query time 0.00041
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 (2307,2306,2308,13820,11805,2335,2216,2217,15142,2220,2803,2264,2262,13109,13110,12701,2580,4394,2769,2768,2767,2766,12700,13840,2224,15149,2192,2191,15146,15147) 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 |
2191 |
|
B |
2029 |
2192 |
|
B |
2030 |
2216 |
|
B |
2054 |
2217 |
|
B |
2055 |
2220 |
|
B |
2058 |
2224 |
|
B |
2062 |
2262 |
|
B |
2100 |
2264 |
|
B |
2102 |
2306 |
|
B |
2144 |
2307 |
|
B |
2145 |
2308 |
|
B |
2146 |
2335 |
|
B |
2173 |
2580 |
|
B |
2418 |
2766 |
|
B |
2604 |
2767 |
|
B |
2605 |
2768 |
|
B |
2606 |
2769 |
|
B |
2607 |
2803 |
|
B |
2641 |
4394 |
|
B |
4267 |
11805 |
|
B |
12857 |
12700 |
|
B |
13752 |
12701 |
|
B |
13753 |
13109 |
|
B |
14176 |
13110 |
|
B |
14177 |
13820 |
|
B |
14753 |
13840 |
|
B |
14773 |
15142 |
|
B |
15972 |
15146 |
|
B |
15976 |
15147 |
|
B |
15977 |
15149 |
|
B |
15979 |