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 (5782) 
  AND cscart_product_reviews.status = 'A' 
ORDER BY 
  cscart_product_reviews.product_review_timestamp desc 
LIMIT 
  10, 10

Query time 0.00135

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "read_sorted_file": {
          "filesort": {
            "sort_key": "cscart_product_reviews.product_review_timestamp desc",
            "table": {
              "table_name": "cscart_product_reviews",
              "access_type": "ref",
              "possible_keys": ["idx_product_id"],
              "key": "idx_product_id",
              "key_length": "3",
              "used_key_parts": ["product_id"],
              "ref": ["const"],
              "rows": 13,
              "filtered": 100,
              "attached_condition": "cscart_product_reviews.product_id <=> 5782 and cscart_product_reviews.`status` = 'A'"
            }
          }
        }
      },
      {
        "table": {
          "table_name": "cscart_users",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["user_id"],
          "ref": ["dev_db.cscart_product_reviews.reply_user_id"],
          "rows": 1,
          "filtered": 100
        }
      },
      {
        "table": {
          "table_name": "cscart_companies",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "4",
          "used_key_parts": ["company_id"],
          "ref": ["dev_db.cscart_users.company_id"],
          "rows": 1,
          "filtered": 100,
          "attached_condition": "trigcond(trigcond(cscart_users.company_id is not null))"
        }
      },
      {
        "table": {
          "table_name": "cscart_country_descriptions",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "12",
          "used_key_parts": ["code", "lang_code"],
          "ref": ["dev_db.cscart_product_reviews.country_code", "const"],
          "rows": 1,
          "filtered": 100,
          "attached_condition": "trigcond(cscart_country_descriptions.lang_code = 'en')"
        }
      }
    ]
  }
}

Result

product_review_id product_id user_id name advantages disadvantages quick_comment 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
27143 5782 7325 Tú Lê Đóng gói xinh Đóng gói quá xinh, socola thơm mùi dâu ngon ngon 5 1b4af3fb N 1713867626 VN 79 0 0 0 A 1 0 0 0 Viet Nam
27139 5782 7325 Ye Jin Nah love the flavor Wow! This strawberry chocolate bark is next-level. The white chocolate is smooth and decadent, and the strawberries are bursting with flavor. 5 1b4af3fb N 1713867599 VN 79 0 0 0 A 1 0 0 0 Viet Nam
27136 5782 7325 Thanh Nhàn ngọt vừa Socola ngọt vừa mà siêu thơm mùi dâu luôn nha 5 1b4af3fb N 1713867577 VN 79 0 0 0 A 1 0 0 0 Viet Nam
27133 5782 7325 Ashley Magish beautiful decoration and tasty flavor This bark is a delightful combination of sweet and tart! The creamy white chocolate pairs perfectly with the tangy strawberries, and the coconut and pistachios add a delightful textural contrast. A delicious treat that's perfect for sharing (or not!) - not to mention that the decoration is just top-notch, lovely as a gift for sure! 5 1b4af3fb N 1713867558 VN 79 0 0 0 A 1 0 0 0 Viet Nam
9555 5782 5292 Trác Duy Bảo Good Quality cute 5 71a2b5b1 N 1636004089 VN 79 0 0 0 A 1 1 0 0 Viet Nam
12221 5782 5292 Xung Ngọc Hạnh Chất Lượng Cao xịn 5 0ea10149 N 1627377729 VN 79 0 0 0 A 1 0 0 0 Viet Nam
8394 5782 5292 Trịnh Ðắc Thành Chất Lượng Cao Ngon 5 0ea10149 N 1627007940 VN 79 0 0 0 A 1 0 0 0 Viet Nam