Speeding up a simple select query on Mariadb
| Sending data         | 0.307494 |


Most of your time is spend on transporting results from server to your client. 


use compression (MYSQLI_CLIENT_COMPRESS)
get faster connection
select less data