让PHP或MySQL做繁重的工作更好吗？

I spent forever building this custom search function for my site in PHP, where it incrementally builds the MySQL query based on what options and input the end user provides. It works perfectly on my local server, but when I uploaded it to the production site, it runs SUPER slow. I'm relatively new to programming with PHP and MySQL, and so I'm curious in general and for future projects:I spent forever building this custom search fun