Loading speed of the report Balance of clients - more than 40 sec

Loading speed of the report Balance of clients - 43.72 sec https://one-box.shine-bright.com.ua/admin/shop/report/clientbalance/ When selecting the Suppliers group in the filter - 1.4 min (although the selection is supposedly smaller) https://one-box.shine-bright.com.ua/admin/shop/report/clientbalance/?datefrom=&dateto=&contractorid=&clientid=&filtergroup=11&clientmanagerid=&filterstoragetype=&filterpayedtype=&managerid=&ok=%D0%A4% D0%B8%D0%BB%D1%8C%D1%82%D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C When checking the box Show summary rows for all pages - HTTP ERROR 500 or 502 Bad Gateway nginx https://one-box.shine-bright.com.ua/admin/shop/report/clientbalance/?datefrom=&dateto=&contractorid=&clientid=&filtergroup=&clientmanagerid=&filterstoragetype=&filterpayedtype=&managerid=&showtotalbalance=1&ok=%D0% A4%D0%B8%D0%BB%D1%8C%D1%82%D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C The load on the processor at the time of loading the re