Query time 0.00056
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": 24,
"filtered": 100,
"index_condition": "cscart_discussion.object_id in (12693,11795,2629,11122,2633,2655,11124,2653,2654,11123,2219,2572,2614,2613,15131,2786,2789,2790,11133,11809,2787,2784,2791,2785) 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 |
2219 |
|
B |
2057 |
2572 |
|
B |
2410 |
2613 |
|
B |
2451 |
2614 |
|
B |
2452 |
2629 |
|
B |
2467 |
2633 |
|
B |
2471 |
2653 |
|
B |
2491 |
2654 |
|
B |
2492 |
2655 |
|
B |
2493 |
2784 |
|
B |
2622 |
2785 |
|
B |
2623 |
2786 |
|
B |
2624 |
2787 |
|
B |
2625 |
2789 |
|
B |
2627 |
2790 |
|
B |
2628 |
2791 |
|
B |
2629 |
11122 |
|
B |
12120 |
11123 |
|
B |
12121 |
11124 |
|
B |
12122 |
11133 |
|
B |
12131 |
11795 |
|
B |
12847 |
11809 |
|
B |
12861 |
12693 |
|
B |
13745 |
15131 |
|
B |
15961 |