MySQL Optimization

I recently spent some time optimizing the MySQL import process and database queries to make the site run more efficiently. The imports were taking longer than they should, and I noticed some queries could be improved.

I made several changes including adding better indexes, optimizing the import scripts to reduce redundant operations, and tuning some of the more complex queries. These updates have helped reduce load times and made the overall system more responsive.