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='342' and count_ip='13.58.244.216' and wdate='20240427'