Not equal where condition on index as a performance problem

Code

-- tested with MySQL 5.6

EXPLAIN SELECT name, status, price FROM history
  WHERE name = 'foo';

EXPLAIN SELECT name, status, price FROM history
  WHERE name != 'foo';

Result

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	history	null	ref	name_timestamp_idx,name_status_idx	name_timestamp_idx	767	const	201	100	null

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	history	null	ALL	name_timestamp_idx,name_status_idx	null	null	null	1407	85.71	Using where

More Snippets

Instead of MySQL's IFNULL function, this works on PostgreSQL, Sqlite and others too
Prevent a temporary DB table caused by SQL group by
SQL Row-Value constructor in a Where-clause

Used Versions

PHP 8.2, Laminas MVC 3.2, Symfony 5.2, Laravel 8.28, PHPUnit 9.5, Doctrine ORM 2.8