Laravel 8.16 - Duplicate/Multiple Prepare statements per execute?

[alturic]

Running Laravel 8.16, on MySQL, and I'm noticing multiple prepare statements, for every execute, and I'm trying to find out what's causing this.

I'm seeing things like:

2021-01-15T21:51:28.857545Z 264 Prepare select * from `users` where `id` = ? limit 1
2021-01-15T21:51:28.857661Z 264 Prepare select * from `users` where `id` = ? limit 1
2021-01-15T21:51:28.857680Z 264 Execute select * from `users` where `id` = 1 limit 1

Same with session updates, interestingly the selection of the session data looks to be a single prepare/execute. If I run this:

DB::select('SELECT * from users where id = 1');

it's a single prepare/execute. However, if I run this:

DB::select('SELECT * from users where id = ?', [1]);

then it's two prepares and an execute. Using model methods, it's two prepares and an execute...

[sportinsightsmedia]

Did you get to the bottom of this? I have just noticed the same thing, using Laravel 8.80.0 and MySQL on AWS Lightsail