Streamline DB Access

[francsiswanto]

• Passport version: 5.0
• Laravel version: 5.6

in my spare time I casually check what laravel/passports do when serving every guarded requests for data query using SQL Profiler, and this is what I can capture:

select top 1 * from [oauth_access_tokens] where [oauth_access_tokens].[id] = '9f4b9808ef8b5fa0afc952184abcea65738fcfc91107ed023819b1dc5efa143ac8aa49d8121fffcb'

select top 1 * from [oauth_users] where [id] = '2'

select top 1 * from [oauth_access_tokens] where [oauth_access_tokens].[id] = '9f4b9808ef8b5fa0afc952184abcea65738fcfc91107ed023819b1dc5efa143ac8aa49d8121fffcb'

select top 1 * from [oauth_clients] where [oauth_clients].[id] = '2'

Real data query is on the fifth. Since these query is always called for every request, can you make it more optimal to only 1 query maybe? Thank you.

[francsiswanto]

It seems this issue #382 are same AND still no solution yet. I close this issue.