[Standalone] Unnecessary queries about orm HOT 2 CLOSED

You'll need to cache the schema reflection. You can do this in one of a few ways:

1. Install the cakephp/cache package and enable cacheMetadata in your connection definition.
2. Create a subclass of Cake\Database\Schema\Collection that caches the results of describe(). The CachedCollection class in the Database package is an example of this. This subclass can be injected into the connection using Connection::schemaCollection($collection).

While the queries look superfluous, they are necessary so the ORM knows which columns can be selected, and the column types when generating insert/update queries.

from orm.

Ok thanks that was what I was looking for. If someone is looking at this issue here is the solution :

\Cake\Cache\Cache::config('_cake_model_', [
    'className' => 'File',
    'duration' => '+1 hours',
    'path' => 'tmp',
    'prefix' => 'my_app_'
]);

And then enable cache for the connection

ConnectionManager::config('default', [
     ...
    'cacheMetadata' => true
]);

from orm.