SELECT 
  cscart_product_reviews.*, 
  cscart_users.company_id as reply_company_id, 
  cscart_companies.company as reply_company, 
  cscart_country_descriptions.country as country 
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 = 'en' 
WHERE 
  1 
  AND cscart_product_reviews.product_id IN (5) 
  AND cscart_product_reviews.status = 'A' 
ORDER BY 
  cscart_product_reviews.product_review_timestamp desc 
LIMIT 
  0, 10

Query time 0.00051

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "4.68"
    },
    "ordering_operation": {
      "using_filesort": true,
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_product_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": "(`danishecarter_latest`.`cscart_product_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": "(`danishecarter_latest`.`cscart_product_reviews`.`status` = 'A')"
          }
        },
        {
          "table": {
            "table_name": "cscart_users",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "user_id"
            ],
            "key_length": "3",
            "ref": [
              "danishecarter_latest.cscart_product_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_companies",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "company_id"
            ],
            "key_length": "4",
            "ref": [
              "danishecarter_latest.cscart_users.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": "2K"
            },
            "used_columns": [
              "company_id",
              "company"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_country_descriptions",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "code",
              "lang_code"
            ],
            "key_length": "12",
            "ref": [
              "danishecarter_latest.cscart_product_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