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 (9552) 
  AND cscart_product_reviews.status = 'A' 
ORDER BY 
  cscart_product_reviews.helpfulness desc

Query time 0.00047

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "3.17"
    },
    "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": 6,
            "rows_produced_per_join": 0,
            "filtered": "10.00",
            "cost_info": {
              "read_cost": "1.50",
              "eval_cost": "0.06",
              "prefix_cost": "2.10",
              "data_read_per_join": "1003"
            },
            "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": "(`cscart_db`.`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": [
              "cscart_db.cscart_product_reviews.reply_user_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.59",
              "eval_cost": "0.06",
              "prefix_cost": "2.75",
              "data_read_per_join": "4K"
            },
            "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": [
              "cscart_db.cscart_users.company_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.15",
              "eval_cost": "0.06",
              "prefix_cost": "2.96",
              "data_read_per_join": "4K"
            },
            "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": [
              "cscart_db.cscart_product_reviews.country_code",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.15",
              "eval_cost": "0.06",
              "prefix_cost": "3.17",
              "data_read_per_join": "240"
            },
            "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
2095 9552 23774 Viswa Pambar It's really beautiful on the skin..it doesn't have any thick shiny particles as others comment..it's finely milled ..that cannot be seen on skin..very subtle and beautiful glow..it's got a beautiful smell 5 6acdf030 N 1651664779 IN 0 0 0 A 1 0 0 0 India
3335 9552 23782 Meera Virani My favourite illuminating moisturiser… It's too good for parties not for regular use and gets little chunky at time. 5 6ad5e816 N 1655723106 IN Rajkot 0 0 0 A 1 0 0 0 India
3573 9552 37378 Charul Kedar Gush beauty glow getter is absolutely amazing! The best make up prodcut i have used. It gives this instant glow on your face. I mixed it with my Cc creams and it works wonders!!. Definitely a very good purchase. This is my go to makeup product!! 5 3124653b Y 1656179675 IN Thane 0 0 0 A 1 0 0 0 India
8068 9552 99186 Maanvi Very fine particles.Can be used as a highlighter after makeup and also before makeup to get that illuminating effect. 4 2a6be030 N 1677596831 IN 0 0 0 A 1 0 0 0 India
11824 9552 61156 P Rithika It works like wonder 5 6a33a087 Y 1686599071 IN Doddakanahalli 0 0 0 A 1 0 0 0 India
12864 9552 141817 Keerti Maurya Good luminizer ? 5 2f095fbb N 1690108605 IN 0 0 0 A 1 0 0 0 India