PHP PDO Caching
There is the MySQL query cache. But in general you should definitely keep the identifier for the prepared statement and re-use it.
The query cache is gone in MySQL version 8.0, see
https://dba.stackexchange.com/questions/217577/why-mysql-remove-query-cache-in-8-0-version
https://mysqlserverteam.com/mysql-8-0-retiring-support-for-the-query-cache/
Two subsequent calls to PDO::prepare()
(even with the same SQL query) should return two different PDOStatement
(or handles) to avoid collisions, especially between previous and current bindings you may apply to it. The cost of creating a PDOStatement with prepare()
is low anyway. What you may want cached are the results returned from the same SQL query, either raw or built by prepare() and this is a feature of your DBMS (MySQL for instance), not PHP.