SELECT 
  product_review_id 
FROM 
  cscart_product_reviews 
  LEFT JOIN cscart_users ON cscart_product_reviews.reply_user_id = cscart_users.user_id 
  LEFT JOIN cscart_companies ON cscart_users.company_id = cscart_companies.company_id 
  LEFT JOIN cscart_country_descriptions ON cscart_product_reviews.country_code = cscart_country_descriptions.code 
  AND cscart_country_descriptions.lang_code = 'vi' 
WHERE 
  1 
  AND cscart_product_reviews.product_id IN (39613) 
  AND cscart_product_reviews.status = 'A' 
GROUP BY 
  cscart_product_reviews.product_review_id

Query time 0.00149

JSON explain

{
  "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
            }
          }
        ]
      }
    }
  }
}

Result

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