Skip to content

Instantly share code, notes, and snippets.

@andrik
Created February 20, 2020 19:45
Show Gist options
  • Save andrik/5c6b4fc3436cd35e0d4471d8f4cd6ecd to your computer and use it in GitHub Desktop.
Save andrik/5c6b4fc3436cd35e0d4471d8f4cd6ecd to your computer and use it in GitHub Desktop.
{
"method": "GET",
"path": "/v1/users/528",
"format": "*/*",
"controller": "Api::V1::UsersController",
"action": "show",
"status": 200,
"duration": 2249.83,
"view": 14.45,
"db": 2103.34,
"host": "localhost",
"request_id": "948ee8c2-07cb-4b72-94a2-13973ecad025",
"sql_queries": [
{
"name": "User Load",
"duration": 148.87,
"sql": "SELECT `users`.* FROM `users` WHERE `users`.`blocked` = 0 AND `users`.`authentication_token` = 'i6W5_AREpLQJ3Fmti18Z' AND ('2020-02-20 19:35:31' < expire_date) ORDER BY `users`.`id` ASC LIMIT 1"
},
{
"name": "User Load",
"duration": 151.15,
"sql": "SELECT `users`.* FROM `users` WHERE (1=1) AND `users`.`id` = 528 ORDER BY `users`.`id` ASC LIMIT 1"
},
{
"name": "Company Load",
"duration": 149.26,
"sql": "SELECT `companies`.* FROM `companies` WHERE `companies`.`id` = 1 LIMIT 1"
},
{
"name": "Acl Load",
"duration": 148.35,
"sql": "SELECT `access_control_lists`.* FROM `access_control_lists` INNER JOIN `authorizations` ON `access_control_lists`.`id` = `authorizations`.`acl_id` WHERE `authorizations`.`user_id` = 528 AND `access_control_lists`.`access_controllable_type` IN ('BlockVehicle', 'LockTrunk', 'PageMonitoring', 'AdvancedCommands', 'CrudCompany', 'CrudProduct', 'CrudUser', 'ResellerRecursive', 'SupportChatBlocked')"
},
{
"name": "Contact Load",
"duration": 149.51,
"sql": "SELECT `contacts`.`id`, `contacts`.`contact_type`, `contacts`.`contact_value`, `contacts`.`contact_name` FROM `contacts` WHERE `contacts`.`contactable_id` = 528 AND `contacts`.`contactable_type` = 'User' LIMIT 50"
}
],
"sql_queries_count": 5,
"short_message": "[200] GET /v1/users/528 (Api::V1::UsersController#show)"
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment