Query time 0.00078
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 (2721,2202,2625,2678,2824,2776,2826,2775,2777,2823,13441,13762,11667,11666,11668,11665,13106,15112,13839,13838,13140,13828,12505,13829,13830,15426,2567,2557,2569,2556) 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 |
2202 |
|
B |
2040 |
2556 |
|
B |
2394 |
2557 |
|
B |
2395 |
2567 |
|
B |
2405 |
2569 |
|
B |
2407 |
2625 |
|
B |
2463 |
2678 |
|
B |
2516 |
2721 |
|
B |
2559 |
2775 |
|
B |
2613 |
2776 |
|
B |
2614 |
2777 |
|
B |
2615 |
2823 |
|
B |
2661 |
2824 |
|
B |
2662 |
2826 |
|
B |
2664 |
11665 |
|
B |
12720 |
11666 |
|
B |
12721 |
11667 |
|
B |
12722 |
11668 |
|
B |
12723 |
12505 |
|
B |
13555 |
13106 |
|
B |
14173 |
13140 |
|
B |
14207 |
13441 |
|
B |
14388 |
13762 |
|
B |
14695 |
13828 |
|
B |
14761 |
13829 |
|
B |
14762 |
13830 |
|
B |
14763 |
13838 |
|
B |
14771 |
13839 |
|
B |
14772 |
15112 |
|
B |
15942 |
15426 |
|
B |
16257 |