I noticed that each query is taking between .6 seconds to 1.5 second.
I believe this is where the delay is coming from:
Because if each query takes on average 1 second and you have 500,000 records

500,000 * 1 = 500,000 seconds
-> 8333 minutes
-> 138 hours

DEBUG | 03/19/2019 07:05:42.788 | UPDATE `tbl_hist_results`
                                                           >>  43.781 - 42.788 = 0.993 seconds
DEBUG | 03/19/2019 07:05:43.781 | UPDATE `tbl_hist_results`
                                                           >>  44.372 - 43.781 = 0.591 seconds
DEBUG | 03/19/2019 07:05:44.372 | UPDATE `tbl_hist_results`
DEBUG | 03/19/2019 07:05:44.893 | UPDATE `tbl_races`
                                                           >>    46.423 - 44.893 = 1.53 seconds
DEBUG | 03/19/2019 07:05:46.423 | UPDATE `tbl_hist_results`
DEBUG | 03/19/2019 07:05:47.134 | UPDATE `tbl_hist_results`
                                                           >>        47.134−46.423 = 0.711 seconds
DEBUG | 03/19/2019 07:05:47.374 | UPDATE `tbl_hist_results`


Is it possible to get the query run at 0.1 second or something, or can we debug to find out why this part is
taking so long.