Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Multiple queries to oauth_access_tokens #347

Closed
mmmert opened this issue Apr 14, 2017 · 3 comments
Closed

Multiple queries to oauth_access_tokens #347

mmmert opened this issue Apr 14, 2017 · 3 comments

Comments

@mmmert
Copy link

mmmert commented Apr 14, 2017

Hi, I'm pretty new to Passport. I realized when I hit a route with auth:api middleware oauth_access_tokens table gets queried twice. Is this normal behaviour or am I doing something wrong?

41 Prepare select * from oauth_access_tokens where oauth_access_tokens.id = ? limit 1
41 Execute select * from oauth_access_tokens where oauth_access_tokens.id = 'TOKEN' limit 1
41 Close stmt
41 Prepare select * from users where users.id = ? limit 1
41 Execute select * from users where users.id = '1' limit 1
41 Close stmt
41 Prepare select * from oauth_access_tokens where oauth_access_tokens.id = ? limit 1
41 Execute select * from oauth_access_tokens where oauth_access_tokens.id = 'TOKEN' limit 1
41 Close stmt
41 Prepare select exists(select * from oauth_clients where id = ? and revoked = ?) as exists
41 Execute select exists(select * from oauth_clients where id = '3' and revoked = '1') as exists

@themsaid
Copy link
Member

themsaid commented Jul 5, 2017

Closing for lack of activity, hope you got the help you needed :)

@themsaid themsaid closed this as completed Jul 5, 2017
@wdelfuego
Copy link

I see the same behavior and have the same question, not sure why this issue was closed.
My apologies if questions like this don't belong here

@ankurk91
Copy link
Contributor

Duplicate of #382

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants