troba | extensible PHP entity and query manager | Object-Relational Mapping library

All in all this seems to be an issue of Transaction Isolation.

Basically, as long as some transaction has not commited inserted or updated data, you cannot see that in another program.

Just the same, as long as your transaction is open, you'll always receive the same state your database had when your transaction started.

Having set autocommit=false you started that transaction very early on in your program and as long as you don't commit() your transaction, you'll see same snapshot (at least with default mysql transaction isolation REPEATABLE READ in place)

That's why manually commit()ing your connection before your select works.

consistent read

A read operation that uses snapshot information to present query results based on a point in time, regardless of changes performed by other transactions running at the same time. If queried data has been changed by another transaction, the original data is reconstructed based on the contents of the undo log. This technique avoids some of the locking issues that can reduce concurrency by forcing transactions to wait for other transactions to finish.

On another topic: Your code could greatly benefit from some cleaning - see the following implementation of getCitas using try-with-resource: