Ignore SHOW statements within the statements_with_full_table_scans views, they will always do a full table scan, and there is nothing an administrator can do about it