SELECT 
  tconnect_product_reviews.*, 
  tconnect_users.company_id as reply_company_id, 
  tconnect_companies.company as reply_company, 
  tconnect_country_descriptions.country as country 
FROM 
  tconnect_product_reviews 
  LEFT JOIN tconnect_users ON tconnect_product_reviews.reply_user_id = tconnect_users.user_id 
  LEFT JOIN tconnect_companies ON tconnect_users.company_id = tconnect_companies.company_id 
  LEFT JOIN tconnect_country_descriptions ON tconnect_product_reviews.country_code = tconnect_country_descriptions.code 
  AND tconnect_country_descriptions.lang_code = 'en' 
WHERE 
  1 
  AND tconnect_product_reviews.rating_value = '4' 
  AND tconnect_product_reviews.product_id IN (228) 
  AND tconnect_product_reviews.status = 'A' 
ORDER BY 
  tconnect_product_reviews.product_review_timestamp desc

Query time 0.00103

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.014451636,
    "nested_loop": [
      {
        "read_sorted_file": {
          "filesort": {
            "sort_key": "tconnect_product_reviews.product_review_timestamp desc",
            "table": {
              "table_name": "tconnect_product_reviews",
              "access_type": "ref",
              "possible_keys": ["idx_product_id"],
              "key": "idx_product_id",
              "key_length": "3",
              "used_key_parts": ["product_id"],
              "ref": ["const"],
              "loops": 1,
              "rows": 2,
              "cost": 0.00325828,
              "filtered": 100,
              "attached_condition": "tconnect_product_reviews.product_id <=> 228 and tconnect_product_reviews.rating_value = '4' and tconnect_product_reviews.`status` = 'A'"
            }
          }
        }
      },
      {
        "table": {
          "table_name": "tconnect_users",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["user_id"],
          "ref": ["tconnect.tconnect_product_reviews.reply_user_id"],
          "loops": 2,
          "rows": 1,
          "cost": 0.003662852,
          "filtered": 100
        }
      },
      {
        "table": {
          "table_name": "tconnect_companies",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "4",
          "used_key_parts": ["company_id"],
          "ref": ["tconnect.tconnect_users.company_id"],
          "loops": 2,
          "rows": 1,
          "cost": 0.003662852,
          "filtered": 100,
          "attached_condition": "trigcond(trigcond(tconnect_users.company_id is not null))"
        }
      },
      {
        "table": {
          "table_name": "tconnect_country_descriptions",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "12",
          "used_key_parts": ["code", "lang_code"],
          "ref": ["tconnect.tconnect_product_reviews.country_code", "const"],
          "loops": 2,
          "rows": 1,
          "cost": 0.003867652,
          "filtered": 100,
          "attached_condition": "trigcond(tconnect_country_descriptions.lang_code = 'en')"
        }
      }
    ]
  }
}

Result

product_review_id product_id user_id name advantages disadvantages comment rating_value ip_address is_buyer product_review_timestamp country_code city reply_user_id reply reply_timestamp helpfulness status storefront_id images_count vote_up vote_down abt__ut2_first_buy_date abt__ut2_purchased_variation_id reply_company_id reply_company country
1 228 3 Tom + Sharp focus + No ghosting in games - Can't rotate the screen I first noticed this monitor at one of those computer stores where they place all the monitors on the same shelf. This one really stood out for color and very sharp focus. I watch movies and play some games and I haven't noticed any ghosting. The only thing that I wish I could do is rotate the screen for word processing (kind of a minor complaint). Otherwise this is a very good monitor and the price is good for a 3D LCD. 4 7f000001 N 1129547428 0 0 -3 A 1 0 1 4 0 0