zabbix4.4.4 The same sql is particularly slow on mysql8.0 and particularly fast on mysql5.7. Is there any problem?

SQL: SELECT g.groupid,g.name FROM hstgrp g WHERE EXISTS (SELECT NULL FROM hosts h,items i,graphs_items gi,graphs gr,hosts_groups hg WHERE hg.hostid=h.hostid AND h.status IN (0,1) AND hg.hostid=i.hostid AND i.itemid=gi.itemid AND gi.graphid=gr.graphid AND gr.flags IN (0,4) AND g.groupid=hg.groupid) AND EXISTS (SELECT NULL FROM hosts h,hosts_groups hg WHERE hg.hostid=h.hostid AND h.status IN (0,1) AND g.groupid=hg.groupid);

mysql5.7

mysql8.0