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

[vrgblzs]

Same here, Laravel v10.48.11, php v8.2.0, mysql v8.0.31 on a local windows machine

[vrgblzs]

I used the built-in mysql general log. On some queries the prepare got duplicated, on some other places it doesn't.

Example
2024-07-12T09:52:54.373303Z 3250 Prepare select * from languages where languages.id = ? limit 1
2024-07-12T09:52:54.373489Z 3250 Prepare select * from languages where languages.id = ? limit 1
2024-07-12T09:52:54.373514Z 3250 Execute select * from languages where languages.id = 1 limit 1
2024-07-12T09:52:54.373817Z 3250 Close stmt

[ghost]

Go here https://github.com/laravel/framework/blob/11.x/src/Illuminate/Database/Connection.php#L410
and search for ->prepare(

That could be the issue

[ghost]

$this->prepared( is called only in 3 places and that is the one that triggers the event.

[ghost]

@vrgblzs what pdo extension are you using in your docker?

[ghost]

see this maybe it is from the pdo extension #51844

[vrgblzs]

Thanks for the help, it is not a Laravel problem.

It seems, the second prepare is actually a reprepare - if the bound type is not the expected (eg signed and unsigned integer types)
source: php/php-src#11744

[alturic]

I wonder if Doctrine doesn't have the issue because you explicitly declare the types in the class?