Here is the slowlog of mysql, could you please help me find out the issue
# Time: 2025-01-30T07:05:07.592304Z
# User@Host: hellokitty[hellokitty] @ localhost [] Id: 20
# Schema: kitty Last_errno: 0 Killed: 0
# Query_time: 8.860641 Lock_time: 0.000004 Rows_sent: 10 Rows_examined: 117988 Rows_affected: 0 Bytes_sent: 40507
use kitty;
SET timestamp=1738220698;
SELECT
p.ID, p.post_type, p.post_content, p.post_excerpt, p.post_modified_gmt
FROM fwfbed_posts as p
LEFT JOIN 111_aioseo_posts as ap ON ap.post_id = p.ID
WHERE 1 = 1 AND
( ap.id IS NULL OR p.post_modified_gmt > ap.image_scan_date OR ap.image_scan_date IS NULL )
AND p.post_status IN ( 'publish', 'inherit' )
AND p.post_type IN ( 'post', 'page', 'attachment', 'product', 'zn_layout', 'portfolio', 'documentation', 'znpb_template_mngr' )
LIMIT 10
/* 1 = 1 */;
# Time: 2025-01-30T07:06:08.267060Z
# User@Host: hellokitty[hellokitty] @ localhost [] Id: 66
# Schema: kitty Last_errno: 0 Killed: 0
# Query_time: 3.110860 Lock_time: 0.000002 Rows_sent: 500 Rows_examined: 132586 Rows_affected: 0 Bytes_sent: 1456860
SET timestamp=1738220765;
SELECT
p.ID, p.post_title, p.post_content, p.post_excerpt, p.post_type, p.post_password, p.post_parent, p.post_date_gmt, p.post_modified_gmt, ap.priority, ap.frequency, ap.images
FROM fwfbed_posts as p
LEFT JOIN 111_aioseo_posts as ap ON ap.post_id = p.ID
WHERE 1 = 1 AND
p.post_status = 'publish'
AND p.post_type IN ( 'post' )
AND ( ap.robots_noindex IS NULL OR ap.robots_default = 1 OR ap.robots_noindex = 0 OR post_id = 605 )
AND 1=1 OR p.ID = 606
ORDER BY case when p.ID = 606 then 0 else 1 end, ap.priority DESC, p.post_modified_gmt DESC
LIMIT 10000, 500
/* 1 = 1 */;
