SELECT 
  cscart_june_setupproduct_reviews.*, 
  cscart_june_setupusers.company_id as reply_company_id, 
  cscart_june_setupcompanies.company as reply_company, 
  cscart_june_setupcountry_descriptions.country as country 
FROM 
  cscart_june_setupproduct_reviews 
  LEFT JOIN cscart_june_setupusers ON cscart_june_setupproduct_reviews.reply_user_id = cscart_june_setupusers.user_id 
  LEFT JOIN cscart_june_setupcompanies ON cscart_june_setupusers.company_id = cscart_june_setupcompanies.company_id 
  LEFT JOIN cscart_june_setupcountry_descriptions ON cscart_june_setupproduct_reviews.country_code = cscart_june_setupcountry_descriptions.code 
  AND cscart_june_setupcountry_descriptions.lang_code = 'ru' 
WHERE 
  1 
  AND cscart_june_setupproduct_reviews.product_id IN (5) 
  AND cscart_june_setupproduct_reviews.status = 'A' 
ORDER BY 
  cscart_june_setupproduct_reviews.product_review_timestamp desc 
LIMIT 
  0, 10

Query time 0.00072

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "4.68"
    },
    "ordering_operation": {
      "using_filesort": true,
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_june_setupproduct_reviews",
            "access_type": "ref",
            "possible_keys": [
              "idx_product_id"
            ],
            "key": "idx_product_id",
            "used_key_parts": [
              "product_id"
            ],
            "key_length": "3",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 3,
            "rows_produced_per_join": 0,
            "filtered": "10.00",
            "index_condition": "(`vishalecarter_june_setup`.`cscart_june_setupproduct_reviews`.`product_id` <=> 5)",
            "cost_info": {
              "read_cost": "3.00",
              "eval_cost": "0.06",
              "prefix_cost": "3.60",
              "data_read_per_join": "501"
            },
            "used_columns": [
              "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"
            ],
            "attached_condition": "(`vishalecarter_june_setup`.`cscart_june_setupproduct_reviews`.`status` = 'A')"
          }
        },
        {
          "table": {
            "table_name": "cscart_june_setupusers",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "user_id"
            ],
            "key_length": "3",
            "ref": [
              "vishalecarter_june_setup.cscart_june_setupproduct_reviews.reply_user_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.30",
              "eval_cost": "0.06",
              "prefix_cost": "3.96",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "user_id",
              "company_id"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_june_setupcompanies",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "company_id"
            ],
            "key_length": "4",
            "ref": [
              "vishalecarter_june_setup.cscart_june_setupusers.company_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.30",
              "eval_cost": "0.06",
              "prefix_cost": "4.32",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "company_id",
              "company"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_june_setupcountry_descriptions",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "code",
              "lang_code"
            ],
            "key_length": "12",
            "ref": [
              "vishalecarter_june_setup.cscart_june_setupproduct_reviews.country_code",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.30",
              "eval_cost": "0.06",
              "prefix_cost": "4.68",
              "data_read_per_join": "120"
            },
            "used_columns": [
              "code",
              "lang_code",
              "country"
            ]
          }
        }
      ]
    }
  }
}

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 reply_company_id reply_company country
10 5 0 Peter I got headaches from this thing, had to return it to the store. Pity, it looks nice. 2 7f000001 N 1484307900 1 Sorry to hear that this TV didn't suit you. We hope that you find something that suits you better. Let us know, and we can help with choosing. 1618476835 -2 A 1 0 2 4 0
8 5 0 John Picture quality is a bit meh but overall nice TV, good for small living rooms 4 7f000001 N 1484307840 0 0 0 A 1 1 2 0
9 5 0 Stacy I really like that TV! Much better than the bulky old one we had for almost 15 years! The image is so sharp and crisp! And the sound quality is really good too! 5 7f000001 N 1484307840 0 0 0 A 1 0 0 0