SELECT 
  role_system, 
  role_user, 
  role_assistant 
FROM 
  cscart_pw_chat_gpt_sessions_chat 
WHERE 
  session = '8e59d1d10ac1d324916dfcaf04ebf8' 
order by 
  id desc 
LIMIT 
  5

Query time 0.00022

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_pw_chat_gpt_sessions_chat index PRIMARY 4 5 Using where