PHP Code-Snippet

Code

-- tested with MySQL 5.6

-- full table scan
EXPLAIN
SELECT * FROM history
 WHERE id + 300 = 400;

-- uses index
EXPLAIN
SELECT * FROM history
 WHERE id = 400 - 300;

Result

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	history	null	const	PRIMARY	PRIMARY	4	const	1	100	null

More Snippets

Getting row counts of different columns in one query in MySQL
Combined indexes may not work with OR. Try an index_merge in MySQL
Not equal where condition on index as a performance problem

Used Versions

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

Doing math in SQL can ignore indices