SELECT 
  discussion_posts.*, 
  discussion_messages.message, 
  discussion_rating.rating_value 
FROM 
  discussion_posts 
  LEFT JOIN discussion_messages ON discussion_messages.post_id = discussion_posts.post_id 
  LEFT JOIN discussion_rating ON discussion_rating.post_id = discussion_posts.post_id 
WHERE 
  discussion_posts.thread_id = 1580502 
  AND discussion_posts.status = 'A' 
ORDER BY 
  discussion_posts.timestamp DESC 
LIMIT 
  0, 10

Query time 0.00074

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "0.85"
    },
    "ordering_operation": {
      "using_filesort": true,
      "nested_loop": [
        {
          "table": {
            "table_name": "discussion_posts",
            "access_type": "ref",
            "possible_keys": [
              "thread_id",
              "thread_id_2"
            ],
            "key": "thread_id",
            "used_key_parts": [
              "thread_id"
            ],
            "key_length": "3",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 2,
            "rows_produced_per_join": 0,
            "filtered": "10.00",
            "cost_info": {
              "read_cost": "0.50",
              "eval_cost": "0.02",
              "prefix_cost": "0.70",
              "data_read_per_join": "89"
            },
            "used_columns": [
              "post_id",
              "thread_id",
              "name",
              "timestamp",
              "user_id",
              "ip_address",
              "status"
            ],
            "attached_condition": "(`goimagine`.`discussion_posts`.`status` = 'A')"
          }
        },
        {
          "table": {
            "table_name": "discussion_messages",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "post_id"
            ],
            "key_length": "3",
            "ref": [
              "goimagine.discussion_posts.post_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.06",
              "eval_cost": "0.02",
              "prefix_cost": "0.78",
              "data_read_per_join": "4"
            },
            "used_columns": [
              "message",
              "post_id"
            ]
          }
        },
        {
          "table": {
            "table_name": "discussion_rating",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "post_id"
            ],
            "key_length": "3",
            "ref": [
              "goimagine.discussion_posts.post_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.05",
              "eval_cost": "0.02",
              "prefix_cost": "0.85",
              "data_read_per_join": "3"
            },
            "used_columns": [
              "rating_value",
              "post_id"
            ]
          }
        }
      ]
    }
  }
}

Result

post_id thread_id name timestamp user_id ip_address status message rating_value
1505 1580502 Maureen Blanco 1652837460 79011 46b5c32f A Thank you Desiree for your beautiful creations. Thank you for going above and beyond to help me get the perfect leis - this my 3rd purchase and i will be back again! 5
1373 1580502 RE 1650396660 17005 622397f3 A Received item fast and safely yesterday. Seller’s communication was quick and concise. Item is perfect and beautiful as pictured. You can tell she pays attention to details. The lei is quality made with clean, crisp bills and added touches like the personalized card and careful packaging. I would definitely order again! Thank you for sharing your talent! 5