Query time 0.00048
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 (2241,2238,2164,2283,11114,14589,15137,2743,2742,2687,11797,11796,2688,11899,11898,2756,2755,15156,11810,2189,2328,12694,12696,12695) 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 |
2164 |
|
B |
2002 |
2189 |
|
B |
2027 |
2238 |
|
B |
2076 |
2241 |
|
B |
2079 |
2283 |
|
B |
2121 |
2328 |
|
B |
2166 |
2687 |
|
B |
2525 |
2688 |
|
B |
2526 |
2742 |
|
B |
2580 |
2743 |
|
B |
2581 |
2755 |
|
B |
2593 |
2756 |
|
B |
2594 |
11114 |
|
B |
12112 |
11796 |
|
B |
12848 |
11797 |
|
B |
12849 |
11810 |
|
B |
12862 |
11898 |
|
B |
12953 |
11899 |
|
B |
12954 |
12694 |
|
B |
13746 |
12695 |
|
B |
13747 |
12696 |
|
B |
13748 |
14589 |
|
B |
15415 |
15137 |
|
B |
15967 |
15156 |
|
B |
15986 |