Query time 0.00038
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 (2172,2175,2170,2166,2173,2174,12742,2600,2597,2598,2357,2807,12976,2305,2304,11806,12740,11117,11787,2587,2588,2591,2590,2553,2589,2581,2592,2576,2685,2686) 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 |
2166 |
|
B |
2004 |
2170 |
|
B |
2008 |
2172 |
|
B |
2010 |
2173 |
|
B |
2011 |
2174 |
|
B |
2012 |
2175 |
|
B |
2013 |
2304 |
|
B |
2142 |
2305 |
|
B |
2143 |
2357 |
|
B |
2195 |
2553 |
|
B |
2391 |
2576 |
|
B |
2414 |
2581 |
|
B |
2419 |
2587 |
|
B |
2425 |
2588 |
|
B |
2426 |
2589 |
|
B |
2427 |
2590 |
|
B |
2428 |
2591 |
|
B |
2429 |
2592 |
|
B |
2430 |
2597 |
|
B |
2435 |
2598 |
|
B |
2436 |
2600 |
|
B |
2438 |
2685 |
|
B |
2523 |
2686 |
|
B |
2524 |
2807 |
|
B |
2645 |
11117 |
|
B |
12115 |
11787 |
|
B |
12839 |
11806 |
|
B |
12858 |
12740 |
|
B |
13793 |
12742 |
|
B |
13795 |
12976 |
|
B |
14040 |