Table rebuild required. Please do "ALTER TABLE `rorynews_com.ins_banner_count` FORCE" or dump/reload to fix it! select count(*) from ins_banner_count where banner_uid='292' and count_ip='18.188.252.23' and wdate='20240426'