{
"query_block": {
"select_id": 1,
"filesort": {
"sort_key": "cscart_product_reviews.product_review_id",
"temporary_table": {
"nested_loop": [
{
"table": {
"table_name": "cscart_product_reviews",
"access_type": "ref",
"possible_keys": ["idx_product_id"],
"key": "idx_product_id",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["const"],
"rows": 38,
"filtered": 100,
"attached_condition": "cscart_product_reviews.product_id <=> 39613 and cscart_product_reviews.`status` = 'A'"
}
},
{
"table": {
"table_name": "cscart_users",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["user_id"],
"ref": ["dev_db.cscart_product_reviews.reply_user_id"],
"rows": 1,
"filtered": 100
}
}
]
}
}
}
}
product_review_id |
---|
16923 |
17425 |
17551 |
18138 |
23462 |
23463 |
23464 |
23465 |
23466 |
23467 |
23468 |
23642 |
23643 |
23644 |
23645 |
23646 |
23647 |
23648 |
24005 |
24008 |
24018 |
24023 |
24030 |
24032 |
24039 |
24364 |
24913 |
24914 |
24915 |
24917 |
24918 |
24919 |
24920 |
25223 |
25224 |
25225 |
25226 |
25227 |
25228 |
30469 |
30470 |
30471 |
30901 |
30903 |
30905 |
31057 |
31060 |
31065 |