adding debug information, reducing the job cache, and optimizing the mysql query (only one query instead of two)