How do i imporve my mysql query

Hi,

Im using symfony doctrine with my database.

my problem is when i look into the profiler, i see that my problem is within the query that needs to retrieve thousands of rows and pass it through datatable.

How can i improve my query to load the page fast? WordPress ...