SELECT 
  cscart_aprilproduct_reviews.*, 
  cscart_aprilusers.company_id as reply_company_id, 
  cscart_aprilcompanies.company as reply_company, 
  cscart_aprilcountry_descriptions.country as country 
FROM 
  cscart_aprilproduct_reviews 
  LEFT JOIN cscart_aprilusers ON cscart_aprilproduct_reviews.reply_user_id = cscart_aprilusers.user_id 
  LEFT JOIN cscart_aprilcompanies ON cscart_aprilusers.company_id = cscart_aprilcompanies.company_id 
  LEFT JOIN cscart_aprilcountry_descriptions ON cscart_aprilproduct_reviews.country_code = cscart_aprilcountry_descriptions.code 
  AND cscart_aprilcountry_descriptions.lang_code = 'en' 
WHERE 
  1 
  AND cscart_aprilproduct_reviews.product_id IN (5) 
  AND cscart_aprilproduct_reviews.status = 'A' 
ORDER BY 
  cscart_aprilproduct_reviews.product_review_timestamp desc 
LIMIT 
  0, 10

Query time 0.00061

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "4.68"
    },
    "ordering_operation": {
      "using_filesort": true,
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_aprilproduct_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_april_setup`.`cscart_aprilproduct_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_april_setup`.`cscart_aprilproduct_reviews`.`status` = 'A')"
          }
        },
        {
          "table": {
            "table_name": "cscart_aprilusers",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "user_id"
            ],
            "key_length": "3",
            "ref": [
              "vishalecarter_april_setup.cscart_aprilproduct_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_aprilcompanies",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "company_id"
            ],
            "key_length": "4",
            "ref": [
              "vishalecarter_april_setup.cscart_aprilusers.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_aprilcountry_descriptions",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "code",
              "lang_code"
            ],
            "key_length": "12",
            "ref": [
              "vishalecarter_april_setup.cscart_aprilproduct_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