Skip to content

Instantly share code, notes, and snippets.

@halfdan
Created November 26, 2013 09:27
Show Gist options
  • Save halfdan/7655631 to your computer and use it in GitHub Desktop.
Save halfdan/7655631 to your computer and use it in GitHub Desktop.
{ sql: 'insert into `users` (`bio`, `created_at`, `created_by`, `email`, `image`, `location`, `name`, `password`, `updated_at`, `updated_by`, `uuid`, `website`) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)',
bindings:
[ '',
Tue Nov 26 2013 09:24:40 GMT+0000 (UTC),
1,
'[email protected]',
'http://www.gravatar.com/avatar/2174875fdee25e314d90b3382a123cf5?d=404',
'',
'Fabian Becker',
'$2a$10$hnTtkwsj4MEHzu7oES3quu3pXojLw.2Vi3OXI92uDpVjs6j8p9zUK',
Tue Nov 26 2013 09:24:40 GMT+0000 (UTC),
1,
'40c5e30a-b34f-4603-a76f-8ebeda700372',
'' ],
__cid: '__cid5' }
{ sql: 'select `users`.* from `users` where `slug` = ? limit 1',
bindings: [ 'fabian-becker' ],
__cid: '__cid3' }
{ sql: 'insert into `roles_users` (`role_id`, `user_id`) values (?, ?)',
bindings: [ 1, 1 ],
__cid: '__cid6' }
{ sql: 'select `settings`.* from `settings` where `key` = ? limit 1',
bindings: [ 'email' ],
__cid: '__cid7' }
{ sql: 'select `settings`.* from `settings` where `key` = ? limit 1',
bindings: [ 'email' ],
__cid: '__cid8' }
{ sql: 'update `settings` set `created_at` = ?, `created_by` = ?, `id` = ?, `key` = ?, `type` = ?, `updated_at` = ?, `updated_by` = ?, `uuid` = ?, `value` = ? where `id` = ?',
bindings:
[ Tue Nov 26 2013 09:23:53 GMT+0000 (UTC),
1,
4,
'email',
'blog',
Tue Nov 26 2013 09:24:40 GMT+0000 (UTC),
1,
'c588eeb1-bba7-40d7-8e3e-b2e75eca96fe',
'[email protected]',
4 ],
__cid: '__cid1' }
{ sql: 'delete from `sessions` where `id` = ?',
bindings: [ '8GOCjEfcKwNiLMRblE8r2E0D' ],
__cid: '__cid2' }
{ sql: 'select `sessions`.* from `sessions` where `id` = ? limit 1',
bindings: [ 'wrA6jKWYGnqWLS1woaCRbGyB' ],
__cid: '__cid4' }
POST /ghost/signup/ 200 468ms - 27b
{ sql: 'insert into `sessions` (`expires`, `id`, `sess`) values (?, ?, ?)',
bindings:
[ 1385501080468,
'wrA6jKWYGnqWLS1woaCRbGyB',
'{"cookie":{"originalMaxAge":43200000,"expires":"2013-11-26T21:24:40.468Z","httpOnly":true,"path":"/"},"user":1}' ],
__cid: '__cid5' }
{ sql: 'select `sessions`.* from `sessions` where `id` = ? limit 1',
bindings: [ 'wrA6jKWYGnqWLS1woaCRbGyB' ],
__cid: '__cid3' }
{ sql: 'select `users`.* from `users` where `id` = ? limit 1',
bindings: [ 1 ],
__cid: '__cid6' }
{ sql: 'select `users`.* from `users`',
bindings: [],
__cid: '__cid7' }
{ sql: 'select `sessions`.* from `sessions` where `id` = ? limit 1',
bindings: [ 'wrA6jKWYGnqWLS1woaCRbGyB' ],
__cid: '__cid8' }
GET /ghost/ 200 56ms - 5.33kb
{ sql: 'update `sessions` set `expires` = ?, `id` = ?, `sess` = ? where `id` = ?',
bindings:
[ 1385501080540,
'wrA6jKWYGnqWLS1woaCRbGyB',
'{"cookie":{"originalMaxAge":43200000,"expires":"2013-11-26T21:24:40.540Z","httpOnly":true,"path":"/"},"user":1,"_csrfSecret":"ecr3iMrJ7UGrvQMEqhMBkXSv"}',
'wrA6jKWYGnqWLS1woaCRbGyB' ],
__cid: '__cid1' }
GET /ghost/css/screen.css 304 4ms
{ sql: 'select `sessions`.* from `sessions` where `id` = ? limit 1',
bindings: [ 'wrA6jKWYGnqWLS1woaCRbGyB' ],
__cid: '__cid2' }
{ sql: 'select `users`.* from `users` where `id` = ? limit 1',
bindings: [ 1 ],
__cid: '__cid4' }
{ sql: 'select `posts`.* from `posts` order by `updated_at` DESC limit 15 offset 0',
bindings: [],
__cid: '__cid5' }
{ sql: 'select `users`.* from `users` where `users`.`id` in (?)',
bindings: [ 1 ],
__cid: '__cid3' }
{ sql: 'select `users`.* from `users` where `users`.`id` in (?)',
bindings: [ 1 ],
__cid: '__cid6' }
{ sql: 'select `tags`.*, `posts_tags`.`post_id` as `_pivot_post_id`, `posts_tags`.`tag_id` as `_pivot_tag_id` from `tags` inner join `posts_tags` on `posts_tags`.`tag_id` = `tags`.`id` where `posts_tags`.`post_id` in (?)',
bindings: [ 1 ],
__cid: '__cid7' }
{ sql: 'select count(`id`) as `aggregate` from `posts`',
bindings: [],
__cid: '__cid8' }
{ sql: 'select `sessions`.* from `sessions` where `id` = ? limit 1',
bindings: [ 'wrA6jKWYGnqWLS1woaCRbGyB' ],
__cid: '__cid1' }
GET /ghost/api/v0.1/posts/?status=all&orderBy%5B%5D=updated_at&orderBy%5B%5D=DESC&where%5Bpage%5D=all 200 70ms - 7.35kb
{ sql: 'update `sessions` set `expires` = ?, `id` = ?, `sess` = ? where `id` = ?',
bindings:
[ 1385501080794,
'wrA6jKWYGnqWLS1woaCRbGyB',
'{"cookie":{"originalMaxAge":43200000,"expires":"2013-11-26T21:24:40.794Z","httpOnly":true,"path":"/"},"user":1,"_csrfSecret":"ecr3iMrJ7UGrvQMEqhMBkXSv"}',
'wrA6jKWYGnqWLS1woaCRbGyB' ],
__cid: '__cid2' }
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment