Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

ssbrar's avatar

Auth::user() query execution time.

Hi, guys. Need your advice. I am getting current authenticated user in controller method, by following code.

$authUser = Auth::user();
echo $authUser->name;

and in debugger console, I get this :-

select * from `users` where `id` = 25 limit 1       12.22ms
\vendor\laravel\framework\src\Illuminate\Auth\EloquentUserProvider.php:52

Why this query is taking so much time to execute. It is always between 10 ms to 30 ms even. Is there any other way around this?

0 likes
5 replies
squiaios's avatar

Do you have telescope or xdebug enabled ?

ssbrar's avatar

Thanks for the response. I dont have any of these. I am coding in VSCode and have installed laravel-debugbar. Here is the output from debugbar:

Bindings 	
0. 25
Hints 	
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
Backtrace 	
15. \vendor\laravel\framework\src\Illuminate\Auth\EloquentUserProvider.php:52
16. \vendor\laravel\framework\src\Illuminate\Auth\SessionGuard.php:139
17. \vendor\laravel\framework\src\Illuminate\Auth\GuardHelpers.php:60
18. middleware::auth:63
19. middleware::auth:42
20. \vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:167
21. \vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\VerifyCsrfToken.php:76
22. \vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:167
23. \vendor\laravel\framework\src\Illuminate\View\Middleware\ShareErrorsFromSession.php:49
24. \vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:167
25. \vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php:116
26. \vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php:62
27. \vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:167
28. \vendor\laravel\framework\src\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse.php:37
29. \vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:167
30. \vendor\laravel\framework\src\Illuminate\Cookie\Middleware\EncryptCookies.php:66
31. \vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:167
32. \vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:103
33. \vendor\laravel\framework\src\Illuminate\Routing\Router.php:687
34. \vendor\laravel\framework\src\Illuminate\Routing\Router.php:662
35. \vendor\laravel\framework\src\Illuminate\Routing\Router.php:628
36. \vendor\laravel\framework\src\Illuminate\Routing\Router.php:617
37. \vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php:165
38. \vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:128
40. \vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:167
41. \vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php:21
42. \vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:167
43. \vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php:21
44. \vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:167
45. \vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\ValidatePostSize.php:27
46. \vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:167
47. \vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode.php:63
48. \vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:167
49. \vendor\fruitcake\laravel-cors\src\HandleCors.php:37
```sql
Snapey's avatar

is this a local server?

mine locally (old mac) takes 0.4/0.5ms but 22ms when running the same against my vps

ssbrar's avatar

sorry i forgot to mention earlier, it is on laragon local server with PHP 7.4.6, laravel 7 and mysql 8.0.21. Even I have only 13 users in my user table.

jlrdw's avatar

Sometimes in development mode queries can take a little longer. Temporarily turn off all debugging, and set app as though production and see if it's faster. But remember to turn debugging on again.

Please or to participate in this conversation.