Skip to content

Instantly share code, notes, and snippets.

@huemorgan
Created November 7, 2011 08:16
Show Gist options
  • Save huemorgan/1344437 to your computer and use it in GitHub Desktop.
Save huemorgan/1344437 to your computer and use it in GitHub Desktop.
Started DELETE "/posts/38442.json" for 127.0.0.1 at 2011-11-07 10:14:30 +0200
[Barista] Compiling all scripts for barista
[Barista] Compiling all coffeescripts
[Barista] Copying all javascripts
Processing by PostsController#destroy as JSON
Parameters: {"id"=>"38442"}
## 0.0, 33.301212, 33.301212, 1970-01-01 02:00:00 +0200, 2011-11-07 10:14:33 +0200, 0, /posts/38442.json
User Load (0.9ms) SELECT `users`.* FROM `users` WHERE `users`.`account_id` = 1 AND `users`.`id` = 2 LIMIT 1
Post Load (0.6ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND `posts`.`id` = 38442 LIMIT 1
Item Load (0.4ms) SELECT `items`.* FROM `items` WHERE `items`.`account_id` = 1 AND `items`.`id` = 1934 LIMIT 1
SQL (0.1ms) BEGIN
AREL (308.5ms) DELETE FROM `post_refs` WHERE `post_refs`.`account_id` = 1 AND `post_refs`.`post_id` = 38442
Post Load (1.1ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND (`posts`.parent_id = 38442 AND (kind <> 'like')) ORDER BY created_at ASC
User Load (0.5ms) SELECT `users`.* FROM `users` WHERE (`users`.`id` IN (2,43))
Post Load (0.3ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND `posts`.`id` = 38442 LIMIT 1
AREL (0.3ms) UPDATE `posts` SET `replies_count` = COALESCE(`replies_count`, 0) - 1 WHERE `posts`.`account_id` = 1 AND `posts`.`id` = 38442
AREL (0.2ms) DELETE FROM `post_refs` WHERE `post_refs`.`account_id` = 1 AND `post_refs`.`post_id` = 38450
Post Load (1.0ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND (`posts`.parent_id = 38450 AND (kind <> 'like')) ORDER BY created_at ASC
Post Load (1.0ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND (`posts`.parent_id = 38450 AND (kind = 'like')) ORDER BY created_at ASC
User Load (0.4ms) SELECT `users`.* FROM `users` WHERE (`users`.`id` = 2)
Post Load (0.4ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND `posts`.`id` = 38450 LIMIT 1
AREL (0.4ms) UPDATE `posts` SET `replies_count` = COALESCE(`replies_count`, 0) - 1 WHERE `posts`.`account_id` = 1 AND `posts`.`id` = 38450
AREL (0.3ms) UPDATE `posts` SET `likes_count` = COALESCE(`likes_count`, 0) - 1 WHERE `posts`.`account_id` = 1 AND `posts`.`id` = 38450
AREL (0.2ms) DELETE FROM `post_refs` WHERE `post_refs`.`account_id` = 1 AND `post_refs`.`post_id` = 38481
Post Load (1.6ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND (`posts`.parent_id = 38481 AND (kind <> 'like')) ORDER BY created_at ASC
Post Load (0.9ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND (`posts`.parent_id = 38481 AND (kind = 'like')) ORDER BY created_at ASC
AREL (112.7ms) DELETE FROM `posts` WHERE `posts`.`id` = 38481
AREL (0.4ms) DELETE FROM `posts` WHERE `posts`.`id` = 38450
Post Load (0.4ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND `posts`.`id` = 38442 LIMIT 1
AREL (0.3ms) UPDATE `posts` SET `replies_count` = COALESCE(`replies_count`, 0) - 1 WHERE `posts`.`account_id` = 1 AND `posts`.`id` = 38442
AREL (0.3ms) DELETE FROM `post_refs` WHERE `post_refs`.`account_id` = 1 AND `post_refs`.`post_id` = 38451
Post Load (1.2ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND (`posts`.parent_id = 38451 AND (kind <> 'like')) ORDER BY created_at ASC
Post Load (1.7ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND (`posts`.parent_id = 38451 AND (kind = 'like')) ORDER BY created_at ASC
AREL (0.5ms) DELETE FROM `posts` WHERE `posts`.`id` = 38451
Post Load (0.4ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND `posts`.`id` = 38442 LIMIT 1
AREL (0.3ms) UPDATE `posts` SET `replies_count` = COALESCE(`replies_count`, 0) - 1 WHERE `posts`.`account_id` = 1 AND `posts`.`id` = 38442
AREL (0.3ms) DELETE FROM `post_refs` WHERE `post_refs`.`account_id` = 1 AND `post_refs`.`post_id` = 38458
Post Load (1.1ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND (`posts`.parent_id = 38458 AND (kind <> 'like')) ORDER BY created_at ASC
Post Load (1.0ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND (`posts`.parent_id = 38458 AND (kind = 'like')) ORDER BY created_at ASC
AREL (0.3ms) DELETE FROM `posts` WHERE `posts`.`id` = 38458
Post Load (0.4ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND `posts`.`id` = 38442 LIMIT 1
AREL (0.3ms) UPDATE `posts` SET `replies_count` = COALESCE(`replies_count`, 0) - 1 WHERE `posts`.`account_id` = 1 AND `posts`.`id` = 38442
AREL (0.3ms) DELETE FROM `post_refs` WHERE `post_refs`.`account_id` = 1 AND `post_refs`.`post_id` = 38459
Post Load (1.0ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND (`posts`.parent_id = 38459 AND (kind <> 'like')) ORDER BY created_at ASC
Post Load (1.4ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND (`posts`.parent_id = 38459 AND (kind = 'like')) ORDER BY created_at ASC
AREL (0.3ms) DELETE FROM `posts` WHERE `posts`.`id` = 38459
Post Load (0.4ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND `posts`.`id` = 38442 LIMIT 1
AREL (0.4ms) UPDATE `posts` SET `replies_count` = COALESCE(`replies_count`, 0) - 1 WHERE `posts`.`account_id` = 1 AND `posts`.`id` = 38442
AREL (0.2ms) DELETE FROM `post_refs` WHERE `post_refs`.`account_id` = 1 AND `post_refs`.`post_id` = 38460
Post Load (1.8ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND (`posts`.parent_id = 38460 AND (kind <> 'like')) ORDER BY created_at ASC
Post Load (1.0ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND (`posts`.parent_id = 38460 AND (kind = 'like')) ORDER BY created_at ASC
AREL (1.3ms) DELETE FROM `posts` WHERE `posts`.`id` = 38460
Post Load (0.4ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND `posts`.`id` = 38442 LIMIT 1
AREL (0.4ms) UPDATE `posts` SET `replies_count` = COALESCE(`replies_count`, 0) - 1 WHERE `posts`.`account_id` = 1 AND `posts`.`id` = 38442
AREL (0.3ms) DELETE FROM `post_refs` WHERE `post_refs`.`account_id` = 1 AND `post_refs`.`post_id` = 38474
Post Load (1.0ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND (`posts`.parent_id = 38474 AND (kind <> 'like')) ORDER BY created_at ASC
Post Load (1.0ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND (`posts`.parent_id = 38474 AND (kind = 'like')) ORDER BY created_at ASC
AREL (0.3ms) DELETE FROM `posts` WHERE `posts`.`id` = 38474
Post Load (0.4ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND `posts`.`id` = 38442 LIMIT 1
AREL (0.4ms) UPDATE `posts` SET `replies_count` = COALESCE(`replies_count`, 0) - 1 WHERE `posts`.`account_id` = 1 AND `posts`.`id` = 38442
AREL (0.2ms) DELETE FROM `post_refs` WHERE `post_refs`.`account_id` = 1 AND `post_refs`.`post_id` = 38483
Post Load (1.6ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND (`posts`.parent_id = 38483 AND (kind <> 'like')) ORDER BY created_at ASC
Post Load (1.5ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND (`posts`.parent_id = 38483 AND (kind = 'like')) ORDER BY created_at ASC
AREL (67.4ms) DELETE FROM `posts` WHERE `posts`.`id` = 38483
Post Load (0.4ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND `posts`.`id` = 38442 LIMIT 1
AREL (0.3ms) UPDATE `posts` SET `replies_count` = COALESCE(`replies_count`, 0) - 1 WHERE `posts`.`account_id` = 1 AND `posts`.`id` = 38442
AREL (0.3ms) DELETE FROM `post_refs` WHERE `post_refs`.`account_id` = 1 AND `post_refs`.`post_id` = 38484
Post Load (1.3ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND (`posts`.parent_id = 38484 AND (kind <> 'like')) ORDER BY created_at ASC
Post Load (1.0ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND (`posts`.parent_id = 38484 AND (kind = 'like')) ORDER BY created_at ASC
AREL (0.3ms) DELETE FROM `posts` WHERE `posts`.`id` = 38484
Post Load (1.6ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND (`posts`.parent_id = 38442 AND (kind = 'like')) ORDER BY created_at ASC
User Load (0.4ms) SELECT `users`.* FROM `users` WHERE (`users`.`id` = 2)
Post Load (0.3ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND `posts`.`id` = 38442 LIMIT 1
AREL (0.3ms) UPDATE `posts` SET `replies_count` = COALESCE(`replies_count`, 0) - 1 WHERE `posts`.`account_id` = 1 AND `posts`.`id` = 38442
AREL (0.2ms) UPDATE `posts` SET `likes_count` = COALESCE(`likes_count`, 0) - 1 WHERE `posts`.`account_id` = 1 AND `posts`.`id` = 38442
AREL (0.3ms) DELETE FROM `post_refs` WHERE `post_refs`.`account_id` = 1 AND `post_refs`.`post_id` = 38455
Post Load (1.0ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND (`posts`.parent_id = 38455 AND (kind <> 'like')) ORDER BY created_at ASC
Post Load (1.0ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`account_id` = 1 AND (`posts`.parent_id = 38455 AND (kind = 'like')) ORDER BY created_at ASC
AREL (0.3ms) DELETE FROM `posts` WHERE `posts`.`id` = 38455
AREL (36.1ms) DELETE FROM `posts` WHERE `posts`.`id` = 38442
SQL (21.5ms) COMMIT
Completed 200 OK in 6633ms (Views: 35.1ms | ActiveRecor
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment