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?
Do you have telescope or xdebug enabled ?
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
is this a local server?
mine locally (old mac) takes 0.4/0.5ms but 22ms when running the same against my vps
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.
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 sign in or create an account to participate in this conversation.