Sandbox

SELECT 
  tmall_ec_livecommerce_video_comments.*, 
  tmall_users.firstname, 
  tmall_users.lastname, 
  tmall_users.user_type 
FROM 
  tmall_ec_livecommerce_video_comments 
  LEFT JOIN tmall_users ON tmall_ec_livecommerce_video_comments.user_id = tmall_users.user_id 
WHERE 
  1 
  AND tmall_ec_livecommerce_video_comments.video_id = 1 
ORDER BY 
  tmall_ec_livecommerce_video_comments.timestamp asc

Query time 0.00773

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}