Skip to content

Instantly share code, notes, and snippets.

@stevenh512

stevenh512/test.log

Created March 30, 2012 00:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save stevenh512/2245408 to your computer and use it in GitHub Desktop.
Save stevenh512/2245408 to your computer and use it in GitHub Desktop.
Download ZIP
Log of Diaspora's features/tags.feature with latest acts_as_taggable_on gem
Raw
test.log
New Relic Agent not running.
New Relic Agent not running.
(0.2ms) BEGIN
(0.2ms) COMMIT
(47.6ms) SELECT @@FOREIGN_KEY_CHECKS
(0.2ms) SET FOREIGN_KEY_CHECKS = 0
(19.3ms) SELECT DATABASE() as db
(216.0ms) select table_name from information_schema.views where table_schema = 'diaspora_test'
(462.3ms) TRUNCATE TABLE `account_deletions`;
(348.2ms) TRUNCATE TABLE `aspect_memberships`;
(148.9ms) TRUNCATE TABLE `aspect_visibilities`;
(174.7ms) TRUNCATE TABLE `aspects`;
(107.1ms) TRUNCATE TABLE `blocks`;
(109.0ms) TRUNCATE TABLE `comments`;
(91.3ms) TRUNCATE TABLE `contacts`;
(174.9ms) TRUNCATE TABLE `conversation_visibilities`;
(82.8ms) TRUNCATE TABLE `conversations`;
(83.2ms) TRUNCATE TABLE `invitation_codes`;
(116.5ms) TRUNCATE TABLE `invitations`;
(127.6ms) TRUNCATE TABLE `likes`;
(138.0ms) TRUNCATE TABLE `mentions`;
(99.7ms) TRUNCATE TABLE `messages`;
(116.4ms) TRUNCATE TABLE `notification_actors`;
(147.7ms) TRUNCATE TABLE `notifications`;
(110.1ms) TRUNCATE TABLE `o_embed_caches`;
(66.3ms) TRUNCATE TABLE `oauth_access_tokens`;
(49.7ms) TRUNCATE TABLE `oauth_authorization_codes`;
(83.1ms) TRUNCATE TABLE `oauth_authorizations`;
(108.0ms) TRUNCATE TABLE `oauth_clients`;
(66.3ms) TRUNCATE TABLE `participations`;
(128.8ms) TRUNCATE TABLE `people`;
(104.0ms) TRUNCATE TABLE `photos`;
(58.0ms) TRUNCATE TABLE `pods`;
(125.0ms) TRUNCATE TABLE `posts`;
(83.0ms) TRUNCATE TABLE `profiles`;
(74.7ms) TRUNCATE TABLE `service_users`;
(124.9ms) TRUNCATE TABLE `services`;
(74.7ms) TRUNCATE TABLE `share_visibilities`;
(83.0ms) TRUNCATE TABLE `tag_followings`;
(149.7ms) TRUNCATE TABLE `taggings`;
(66.3ms) TRUNCATE TABLE `tags`;
(41.3ms) TRUNCATE TABLE `user_preferences`;
(116.9ms) TRUNCATE TABLE `users`;
(0.3ms) SET FOREIGN_KEY_CHECKS = 1
(0.2ms) BEGIN
(0.3ms) COMMIT
(0.2ms) BEGIN
(0.2ms) COMMIT
(0.2ms) BEGIN
(0.1ms) COMMIT
(0.1ms) BEGIN
(25.4ms) SELECT 1 FROM `users` WHERE `users`.`email` = BINARY 'samuel_beckett@example.com' LIMIT 1
(1.8ms) SELECT 1 FROM `users` WHERE `users`.`username` = BINARY 'samuel_beckett' LIMIT 1
(2.9ms) SELECT 1 FROM `people` WHERE `people`.`guid` = BINARY '' LIMIT 1
(50.5ms) SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` IS NULL AND `taggings`.`taggable_type` = 'Profile' AND (taggings.context = 'tags')
ActsAsTaggableOn::Tag Load (0.8ms) SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` IS NULL AND `taggings`.`taggable_type` = 'Profile' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL)
(0.6ms) SELECT 1 FROM `people` WHERE `people`.`diaspora_handle` = BINARY 'samuel_beckett@localhost:9887' LIMIT 1
(0.7ms) SELECT 1 FROM `people` WHERE `people`.`diaspora_handle` = 'samuel_beckett@localhost:9887' LIMIT 1
(0.3ms) SELECT 1 FROM `people` WHERE `people`.`guid` = BINARY '' LIMIT 1
(0.3ms) SELECT 1 FROM `people` WHERE `people`.`diaspora_handle` = BINARY 'samuel_beckett@localhost:9887' LIMIT 1
SQL (13.7ms) INSERT INTO `people` (`closed_account`, `created_at`, `diaspora_handle`, `guid`, `owner_id`, `serialized_public_key`, `updated_at`, `url`) VALUES (0, '2012-03-30 00:44:03', 'samuel_beckett@localhost:9887', 'e6b73f24221dc6c4', NULL, '-----BEGIN RSA PUBLIC KEY-----\nMIGJAoGBAJ6f89a9feWklDs4lsLdK781GwIjjEqIkXGXbVvE9cpY/spEMeA7seh7\nC9jmuQfk18SzD98pwlLvqZ1IjLkTnnigv39dWm9DumwKy0jiM4BKgQGd0dE3o1/W\nl5bofKHeXDRPHh7p1CB6V57/9yXz62ybsiGRpwVcaylbIzyR9F6BAgMBAAE=\n-----END RSA PUBLIC KEY-----\n', '2012-03-30 00:44:03', 'http://localhost:9887/')
SQL (16.1ms) INSERT INTO `profiles` (`bio`, `birthday`, `created_at`, `diaspora_handle`, `first_name`, `full_name`, `gender`, `image_url`, `image_url_medium`, `image_url_small`, `last_name`, `location`, `nsfw`, `person_id`, `searchable`, `updated_at`) VALUES ('I am a cat lover and I love to run', '2012-03-29', '2012-03-30 00:44:03', NULL, 'Robert126db66', 'robert126db66 grimm1a1e203', 'robot', NULL, NULL, NULL, 'Grimm1a1e203', 'Earth', 0, 1, 1, '2012-03-30 00:44:03')
ActsAsTaggableOn::Tag Load (4.0ms) SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 1 AND `taggings`.`taggable_type` = 'Profile' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL)
ActsAsTaggableOn::Tagging Load (0.7ms) SELECT `taggings`.* FROM `taggings` WHERE `taggings`.`taggable_id` = 1 AND `taggings`.`taggable_type` = 'Profile' AND `taggings`.`tagger_type` IS NULL AND `taggings`.`tagger_id` IS NULL AND `taggings`.`context` = 'tags' AND `taggings`.`tag_id` IN (NULL)
SQL (9.3ms) INSERT INTO `users` (`authentication_token`, `auto_follow_back`, `auto_follow_back_aspect_id`, `confirm_email_token`, `created_at`, `current_sign_in_at`, `current_sign_in_ip`, `disable_mail`, `email`, `encrypted_password`, `getting_started`, `hidden_shareables`, `invitation_identifier`, `invitation_limit`, `invitation_sent_at`, `invitation_service`, `invitation_token`, `invited_by_id`, `invited_by_type`, `language`, `last_sign_in_at`, `last_sign_in_ip`, `locked_at`, `remember_created_at`, `remember_token`, `reset_password_token`, `serialized_private_key`, `show_community_spotlight_in_stream`, `sign_in_count`, `unconfirmed_email`, `updated_at`, `username`) VALUES (NULL, 0, NULL, NULL, '2012-03-30 00:44:04', NULL, NULL, 0, 'samuel_beckett@example.com', '$2a$04$NcjaEy4LQQnBiWwGmk7EdeX3X/qkaP1WaUKMgNkwvzKlVEWOnBaW6', 0, '--- {}\n\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en', NULL, NULL, NULL, NULL, NULL, NULL, '-----BEGIN RSA PRIVATE KEY-----\nMIICXAIBAAKBgQCen/PWvX3lpJQ7OJbC3Su/NRsCI4xKiJFxl21bxPXKWP7KRDHg\nO7HoewvY5rkH5NfEsw/fKcJS76mdSIy5E554oL9/XVpvQ7psCstI4jOASoEBndHR\nN6Nf1peW6Hyh3lw0Tx4e6dQgelee//cl8+tsm7IhkacFXGspWyM8kfRegQIDAQAB\nAoGASqHxhUDE4m5r++0lKewL8DvZSElXcZ4N6IcZwgrKpnj28E3jtaAAleSG73em\n6SrnxjmFpzcrof/3KvR+mXm8nkEw5KYiK0QYrERoW2m8Hb7OD0ddmisRu5ZOsJIC\ny7o4GyMlMpnz0+L/k3rlwYRsCZaaECgUs+Lb/ET+5KqaO0ECQQDQRLgD/6bgik4N\npsiY5zcRbVZLoGSkxjdQd0Lbvc7m0DFrDYr6zlOn+1nDGDU8BWrJ3Xi29gfsJSB1\nhVN2OPKZAkEAwvqZ/l0JpBZRq3F26Y1QR9CguU7cBp+AFERR0ae82YLAVoIwIYvu\nwSVhWoQo9vMRBAmOJQwqZh74uWwu0XgkKQJAeaYp9ev2BWHDhaXNtcIYIE3FAheF\nsdk1pgKDQubzW05wDx+x9h1eL9hY7ePN9GkVnyOFxxieOAjXlM1zmrJYwQJBAL7g\nUi0fq7aFWwJ5m63cd8E2ToHa369kKiCtGWQjz88oH18RKElPEjbnfzz7sJbBMeE/\n8XX3SPKcU2ZCsDrEYLECQGwupECRCK/A6EIikLW+lRrEdls7WZlwzODtPcJBMmhp\n0cVG1k/pHNB3rbTPDlDSt9Vcl4WnFV4NLtQR7Xjr0SU=\n-----END RSA PRIVATE KEY-----\n', 1, 0, NULL, '2012-03-30 00:44:04', 'samuel_beckett')
(8.2ms) SELECT 1 FROM `people` WHERE (`people`.`guid` = BINARY 'e6b73f24221dc6c4' AND `people`.`id` != 1) LIMIT 1
(0.7ms) SELECT 1 FROM `people` WHERE (`people`.`diaspora_handle` = BINARY 'samuel_beckett@localhost:9887' AND `people`.`id` != 1) LIMIT 1
(43.6ms) UPDATE `people` SET `owner_id` = 1, `updated_at` = '2012-03-30 00:44:04' WHERE `people`.`id` = 1
ActsAsTaggableOn::Tag Load (0.3ms) SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 1 AND `taggings`.`taggable_type` = 'Profile' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL)
ActsAsTaggableOn::Tagging Load (0.3ms) SELECT `taggings`.* FROM `taggings` WHERE `taggings`.`taggable_id` = 1 AND `taggings`.`taggable_type` = 'Profile' AND `taggings`.`tagger_type` IS NULL AND `taggings`.`tagger_id` IS NULL AND `taggings`.`context` = 'tags' AND `taggings`.`tag_id` IN (NULL)
(35.4ms) COMMIT
(0.2ms) BEGIN
(9.0ms) SELECT 1 FROM `people` WHERE (`people`.`guid` = BINARY 'e6b73f24221dc6c4' AND `people`.`id` != 1) LIMIT 1
(0.7ms) SELECT 1 FROM `people` WHERE (`people`.`diaspora_handle` = BINARY 'samuel_beckett@localhost:9887' AND `people`.`id` != 1) LIMIT 1
ActsAsTaggableOn::Tag Load (0.3ms) SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 1 AND `taggings`.`taggable_type` = 'Profile' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL)
ActsAsTaggableOn::Tagging Load (0.3ms) SELECT `taggings`.* FROM `taggings` WHERE `taggings`.`taggable_id` = 1 AND `taggings`.`taggable_type` = 'Profile' AND `taggings`.`tagger_type` IS NULL AND `taggings`.`tagger_id` IS NULL AND `taggings`.`context` = 'tags' AND `taggings`.`tag_id` IN (NULL)
(0.2ms) COMMIT
(0.2ms) BEGIN
ActsAsTaggableOn::Tag Load (0.3ms) SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 1 AND `taggings`.`taggable_type` = 'Profile' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL)
ActsAsTaggableOn::Tagging Load (0.3ms) SELECT `taggings`.* FROM `taggings` WHERE `taggings`.`taggable_id` = 1 AND `taggings`.`taggable_type` = 'Profile' AND `taggings`.`tagger_type` IS NULL AND `taggings`.`tagger_id` IS NULL AND `taggings`.`context` = 'tags' AND `taggings`.`tag_id` IN (NULL)
(0.2ms) COMMIT
(0.3ms) BEGIN
(15.5ms) SELECT 1 FROM `aspects` WHERE (LOWER(`aspects`.`name`) = LOWER('Besties') AND `aspects`.`user_id` = 1) LIMIT 1
SQL (0.4ms) INSERT INTO `aspects` (`contacts_visible`, `created_at`, `name`, `order_id`, `updated_at`, `user_id`) VALUES (1, '2012-03-30 00:44:04', 'Besties', NULL, '2012-03-30 00:44:04', 1)
(37.3ms) COMMIT
(0.2ms) BEGIN
(0.7ms) SELECT 1 FROM `aspects` WHERE (LOWER(`aspects`.`name`) = LOWER('Unicorns') AND `aspects`.`user_id` = 1) LIMIT 1
SQL (0.4ms) INSERT INTO `aspects` (`contacts_visible`, `created_at`, `name`, `order_id`, `updated_at`, `user_id`) VALUES (1, '2012-03-30 00:44:04', 'Unicorns', NULL, '2012-03-30 00:44:04', 1)
(34.1ms) COMMIT
(0.2ms) BEGIN
(11.6ms) UPDATE `profiles` SET `first_name` = 'Samuel', `last_name` = 'Beckett', `full_name` = 'samuel beckett', `updated_at` = '2012-03-30 00:44:04' WHERE `profiles`.`id` = 1
ActsAsTaggableOn::Tag Load (0.3ms) SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 1 AND `taggings`.`taggable_type` = 'Profile' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL)
ActsAsTaggableOn::Tagging Load (0.3ms) SELECT `taggings`.* FROM `taggings` WHERE `taggings`.`taggable_id` = 1 AND `taggings`.`taggable_type` = 'Profile' AND `taggings`.`tagger_type` IS NULL AND `taggings`.`tagger_id` IS NULL AND `taggings`.`context` = 'tags' AND `taggings`.`tag_id` IN (NULL)
(32.7ms) COMMIT
User Load (13.1ms) SELECT `users`.* FROM `users` WHERE `users`.`username` = 'samuel_beckett' LIMIT 1
Person Load (0.8ms) SELECT `people`.* FROM `people` WHERE `people`.`owner_id` = 1 LIMIT 1
Profile Load (0.9ms) SELECT `profiles`.* FROM `profiles` WHERE `profiles`.`person_id` = 1 LIMIT 1
(0.2ms) BEGIN
ActsAsTaggableOn::Tag Load (7.1ms) SELECT `tags`.* FROM `tags` WHERE (name LIKE 'rockstar' ESCAPE '!')
(0.6ms) SELECT 1 FROM `tags` WHERE `tags`.`name` = BINARY 'rockstar' LIMIT 1
SQL (0.4ms) INSERT INTO `tags` (`name`) VALUES ('rockstar')
ActsAsTaggableOn::Tag Load (0.8ms) SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 1 AND `taggings`.`taggable_type` = 'Profile' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL)
ActsAsTaggableOn::Tagging Load (0.3ms) SELECT `taggings`.* FROM `taggings` WHERE `taggings`.`taggable_id` = 1 AND `taggings`.`taggable_type` = 'Profile' AND `taggings`.`tagger_type` IS NULL AND `taggings`.`tagger_id` IS NULL AND `taggings`.`context` = 'tags' AND `taggings`.`tag_id` IN (NULL)
(0.7ms) SELECT 1 FROM `taggings` WHERE (`taggings`.`tag_id` = BINARY 1 AND `taggings`.`taggable_type` = 'Profile' AND `taggings`.`taggable_id` = 1 AND `taggings`.`context` = 'tags' AND `taggings`.`tagger_id` IS NULL AND `taggings`.`tagger_type` IS NULL) LIMIT 1
SQL (0.5ms) INSERT INTO `taggings` (`context`, `created_at`, `tag_id`, `taggable_id`, `taggable_type`, `tagger_id`, `tagger_type`) VALUES ('tags', '2012-03-30 00:44:04', 1, 1, 'Profile', NULL, NULL)
(23.1ms) COMMIT
(0.2ms) BEGIN
(0.2ms) COMMIT
(0.3ms) BEGIN
(0.2ms) COMMIT
(0.2ms) BEGIN
(0.1ms) COMMIT
(0.1ms) BEGIN
(0.6ms) SELECT 1 FROM `users` WHERE `users`.`email` = BINARY 'bob1028d6b@pivotallabs.com' LIMIT 1
(0.5ms) SELECT 1 FROM `users` WHERE `users`.`username` = BINARY 'bob1b5b7fb' LIMIT 1
(0.7ms) SELECT 1 FROM `people` WHERE `people`.`guid` = BINARY '' LIMIT 1
(1.0ms) SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` IS NULL AND `taggings`.`taggable_type` = 'Profile' AND (taggings.context = 'tags')
ActsAsTaggableOn::Tag Load (0.9ms) SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` IS NULL AND `taggings`.`taggable_type` = 'Profile' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL)
(0.6ms) SELECT 1 FROM `people` WHERE `people`.`diaspora_handle` = BINARY 'bob1b5b7fb@localhost:9887' LIMIT 1
(0.5ms) SELECT 1 FROM `people` WHERE `people`.`diaspora_handle` = 'bob1b5b7fb@localhost:9887' LIMIT 1
(0.3ms) SELECT 1 FROM `people` WHERE `people`.`guid` = BINARY '' LIMIT 1
(0.3ms) SELECT 1 FROM `people` WHERE `people`.`diaspora_handle` = BINARY 'bob1b5b7fb@localhost:9887' LIMIT 1
SQL (0.6ms) INSERT INTO `people` (`closed_account`, `created_at`, `diaspora_handle`, `guid`, `owner_id`, `serialized_public_key`, `updated_at`, `url`) VALUES (0, '2012-03-30 00:44:04', 'bob1b5b7fb@localhost:9887', 'b4f903ae1efd0795', NULL, '-----BEGIN RSA PUBLIC KEY-----\nMIGJAoGBAJ6f89a9feWklDs4lsLdK781GwIjjEqIkXGXbVvE9cpY/spEMeA7seh7\nC9jmuQfk18SzD98pwlLvqZ1IjLkTnnigv39dWm9DumwKy0jiM4BKgQGd0dE3o1/W\nl5bofKHeXDRPHh7p1CB6V57/9yXz62ybsiGRpwVcaylbIzyR9F6BAgMBAAE=\n-----END RSA PUBLIC KEY-----\n', '2012-03-30 00:44:04', 'http://localhost:9887/')
SQL (0.5ms) INSERT INTO `profiles` (`bio`, `birthday`, `created_at`, `diaspora_handle`, `first_name`, `full_name`, `gender`, `image_url`, `image_url_medium`, `image_url_small`, `last_name`, `location`, `nsfw`, `person_id`, `searchable`, `updated_at`) VALUES ('I am a cat lover and I love to run', '2012-03-29', '2012-03-30 00:44:04', NULL, 'Robert2a97845', 'robert2a97845 grimm2f11971', 'robot', NULL, NULL, NULL, 'Grimm2f11971', 'Earth', 0, 2, 1, '2012-03-30 00:44:04')
ActsAsTaggableOn::Tag Load (0.8ms) SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 2 AND `taggings`.`taggable_type` = 'Profile' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL)
ActsAsTaggableOn::Tagging Load (0.6ms) SELECT `taggings`.* FROM `taggings` WHERE `taggings`.`taggable_id` = 2 AND `taggings`.`taggable_type` = 'Profile' AND `taggings`.`tagger_type` IS NULL AND `taggings`.`tagger_id` IS NULL AND `taggings`.`context` = 'tags' AND `taggings`.`tag_id` IN (NULL)
SQL (0.7ms) INSERT INTO `users` (`authentication_token`, `auto_follow_back`, `auto_follow_back_aspect_id`, `confirm_email_token`, `created_at`, `current_sign_in_at`, `current_sign_in_ip`, `disable_mail`, `email`, `encrypted_password`, `getting_started`, `hidden_shareables`, `invitation_identifier`, `invitation_limit`, `invitation_sent_at`, `invitation_service`, `invitation_token`, `invited_by_id`, `invited_by_type`, `language`, `last_sign_in_at`, `last_sign_in_ip`, `locked_at`, `remember_created_at`, `remember_token`, `reset_password_token`, `serialized_private_key`, `show_community_spotlight_in_stream`, `sign_in_count`, `unconfirmed_email`, `updated_at`, `username`) VALUES (NULL, 0, NULL, NULL, '2012-03-30 00:44:05', NULL, NULL, 0, 'bob1028d6b@pivotallabs.com', '$2a$04$.FDFgRRD73QVVr6f7/.Bu.mjI4zvnZGPuiZSFrzcp7mEjKzxxxHza', 0, '--- {}\n\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en', NULL, NULL, NULL, NULL, NULL, NULL, '-----BEGIN RSA PRIVATE KEY-----\nMIICXAIBAAKBgQCen/PWvX3lpJQ7OJbC3Su/NRsCI4xKiJFxl21bxPXKWP7KRDHg\nO7HoewvY5rkH5NfEsw/fKcJS76mdSIy5E554oL9/XVpvQ7psCstI4jOASoEBndHR\nN6Nf1peW6Hyh3lw0Tx4e6dQgelee//cl8+tsm7IhkacFXGspWyM8kfRegQIDAQAB\nAoGASqHxhUDE4m5r++0lKewL8DvZSElXcZ4N6IcZwgrKpnj28E3jtaAAleSG73em\n6SrnxjmFpzcrof/3KvR+mXm8nkEw5KYiK0QYrERoW2m8Hb7OD0ddmisRu5ZOsJIC\ny7o4GyMlMpnz0+L/k3rlwYRsCZaaECgUs+Lb/ET+5KqaO0ECQQDQRLgD/6bgik4N\npsiY5zcRbVZLoGSkxjdQd0Lbvc7m0DFrDYr6zlOn+1nDGDU8BWrJ3Xi29gfsJSB1\nhVN2OPKZAkEAwvqZ/l0JpBZRq3F26Y1QR9CguU7cBp+AFERR0ae82YLAVoIwIYvu\nwSVhWoQo9vMRBAmOJQwqZh74uWwu0XgkKQJAeaYp9ev2BWHDhaXNtcIYIE3FAheF\nsdk1pgKDQubzW05wDx+x9h1eL9hY7ePN9GkVnyOFxxieOAjXlM1zmrJYwQJBAL7g\nUi0fq7aFWwJ5m63cd8E2ToHa369kKiCtGWQjz88oH18RKElPEjbnfzz7sJbBMeE/\n8XX3SPKcU2ZCsDrEYLECQGwupECRCK/A6EIikLW+lRrEdls7WZlwzODtPcJBMmhp\n0cVG1k/pHNB3rbTPDlDSt9Vcl4WnFV4NLtQR7Xjr0SU=\n-----END RSA PRIVATE KEY-----\n', 1, 0, NULL, '2012-03-30 00:44:05', 'bob1b5b7fb')
(0.7ms) SELECT 1 FROM `people` WHERE (`people`.`guid` = BINARY 'b4f903ae1efd0795' AND `people`.`id` != 2) LIMIT 1
(0.7ms) SELECT 1 FROM `people` WHERE (`people`.`diaspora_handle` = BINARY 'bob1b5b7fb@localhost:9887' AND `people`.`id` != 2) LIMIT 1
(0.6ms) UPDATE `people` SET `owner_id` = 2, `updated_at` = '2012-03-30 00:44:05' WHERE `people`.`id` = 2
ActsAsTaggableOn::Tag Load (0.3ms) SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 2 AND `taggings`.`taggable_type` = 'Profile' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL)
ActsAsTaggableOn::Tagging Load (0.3ms) SELECT `taggings`.* FROM `taggings` WHERE `taggings`.`taggable_id` = 2 AND `taggings`.`taggable_type` = 'Profile' AND `taggings`.`tagger_type` IS NULL AND `taggings`.`tagger_id` IS NULL AND `taggings`.`context` = 'tags' AND `taggings`.`tag_id` IN (NULL)
(40.0ms) COMMIT
(0.2ms) BEGIN
(0.7ms) SELECT 1 FROM `people` WHERE (`people`.`guid` = BINARY 'b4f903ae1efd0795' AND `people`.`id` != 2) LIMIT 1
(0.8ms) SELECT 1 FROM `people` WHERE (`people`.`diaspora_handle` = BINARY 'bob1b5b7fb@localhost:9887' AND `people`.`id` != 2) LIMIT 1
ActsAsTaggableOn::Tag Load (0.3ms) SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 2 AND `taggings`.`taggable_type` = 'Profile' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL)
ActsAsTaggableOn::Tagging Load (0.3ms) SELECT `taggings`.* FROM `taggings` WHERE `taggings`.`taggable_id` = 2 AND `taggings`.`taggable_type` = 'Profile' AND `taggings`.`tagger_type` IS NULL AND `taggings`.`tagger_id` IS NULL AND `taggings`.`context` = 'tags' AND `taggings`.`tag_id` IN (NULL)
(0.2ms) COMMIT
(0.2ms) BEGIN
ActsAsTaggableOn::Tag Load (0.4ms) SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 2 AND `taggings`.`taggable_type` = 'Profile' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL)
ActsAsTaggableOn::Tagging Load (0.3ms) SELECT `taggings`.* FROM `taggings` WHERE `taggings`.`taggable_id` = 2 AND `taggings`.`taggable_type` = 'Profile' AND `taggings`.`tagger_type` IS NULL AND `taggings`.`tagger_id` IS NULL AND `taggings`.`context` = 'tags' AND `taggings`.`tag_id` IN (NULL)
(0.2ms) COMMIT
(0.2ms) BEGIN
(0.8ms) SELECT 1 FROM `aspects` WHERE (LOWER(`aspects`.`name`) = LOWER('generic') AND `aspects`.`user_id` = 2) LIMIT 1
SQL (0.4ms) INSERT INTO `aspects` (`contacts_visible`, `created_at`, `name`, `order_id`, `updated_at`, `user_id`) VALUES (1, '2012-03-30 00:44:05', 'generic', NULL, '2012-03-30 00:44:05', 2)
(30.4ms) COMMIT
Started GET "/integration_sessions?user_id=2" for 127.0.0.1 at 2012-03-29 17:44:36 -0700
Processing by IntegrationSessionsController#new as HTML
Parameters: {"user_id"=>"2"}
Rendered features/support/integration_sessions_form.haml (4.1ms)
Completed 200 OK in 1687ms (Views: 1685.7ms | ActiveRecord: 0.0ms)
Started POST "/integration_sessions?user_id=2" for 127.0.0.1 at 2012-03-29 17:44:46 -0700
Processing by IntegrationSessionsController#create as HTML
Parameters: {"user_id"=>"2"}
User Load (215.6ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 2 LIMIT 1
(0.2ms) BEGIN
Person Load (75.9ms) SELECT `people`.* FROM `people` WHERE `people`.`owner_id` = 2 LIMIT 1
(42.4ms) UPDATE `users` SET `last_sign_in_at` = '2012-03-30 00:44:46', `current_sign_in_at` = '2012-03-30 00:44:46', `last_sign_in_ip` = '127.0.0.1', `current_sign_in_ip` = '127.0.0.1', `sign_in_count` = 1, `updated_at` = '2012-03-30 00:44:47', `hidden_shareables` = '--- {}\n\n' WHERE `users`.`id` = 2
(46.9ms) COMMIT
Redirected to http://127.0.0.1:9887/
Completed 302 Found in 414ms
Started GET "/" for 127.0.0.1 at 2012-03-29 17:44:47 -0700
Processing by HomeController#show as HTML
User Load (8.5ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 2 LIMIT 1
Redirected to http://127.0.0.1:9887/stream
Completed 302 Found in 16ms
Started GET "/stream" for 127.0.0.1 at 2012-03-29 17:44:47 -0700
Processing by StreamsController#multi as HTML
User Load (0.5ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 2 LIMIT 1
Person Load (0.8ms) SELECT `people`.* FROM `people` WHERE `people`.`owner_id` = 2 LIMIT 1
Profile Load (53.2ms) SELECT `profiles`.* FROM `profiles` WHERE `profiles`.`person_id` = 2 LIMIT 1
Rendered aspects/_aspect_listings.haml (10.0ms)
Rendered tags/_followed_tags_listings.haml (11.2ms)
Aspect Load (79.1ms) SELECT `aspects`.* FROM `aspects` WHERE `aspects`.`user_id` = 2 ORDER BY order_id ASC
Service Load (11.5ms) SELECT `services`.* FROM `services` WHERE `services`.`user_id` = 2
CACHE (0.0ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 2 LIMIT 1
Rendered shared/_public_explain.haml (241.6ms)
Rendered photos/_new_photo.haml (15.0ms)
Rendered shared/_publisher.html.haml (495.8ms)
Rendered aspects/_no_posts_message.haml (5.1ms)
(26.2ms) SELECT COUNT(*) FROM `contacts` WHERE `contacts`.`user_id` = 2
Rendered aspects/_no_contacts_message.haml (5.8ms)
Rendered aspects/_aspect_stream.haml (669.9ms)
Rendered shared/_invitations.haml (7.6ms)
(10.1ms) SELECT COUNT(*) FROM `oauth_authorizations` WHERE `oauth_authorizations`.`resource_owner_id` = 2
Rendered shared/_right_sections.html.haml (125.2ms)
Rendered layouts/main_stream.html.haml within layouts/application (1166.5ms)
(34.1ms) SELECT COUNT(*) FROM `notifications` WHERE `notifications`.`recipient_id` = 2 AND `notifications`.`unread` = 1
(2.7ms) SELECT SUM(`conversation_visibilities`.`unread`) AS sum_id FROM `conversation_visibilities` WHERE (person_id = 2)
Completed 200 OK in 1632ms (Views: 1281.9ms | ActiveRecord: 344.3ms)
Started GET "/stream" for 127.0.0.1 at 2012-03-29 17:44:50 -0700
Processing by StreamsController#multi as JSON
User Load (0.7ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 2 LIMIT 1
Aspect Load (15.5ms) SELECT `aspects`.id FROM `aspects` WHERE `aspects`.`user_id` = 2 ORDER BY order_id ASC
Person Load (0.6ms) SELECT `people`.* FROM `people` WHERE `people`.`owner_id` = 2 LIMIT 1
(211.3ms) (SELECT DISTINCT posts.id, posts.updated_at AS updated_at, posts.created_at AS created_at FROM `posts` INNER JOIN `share_visibilities` ON `share_visibilities`.`shareable_id` = `posts`.`id` AND `share_visibilities`.`shareable_type` = 'Post' INNER JOIN `contacts` ON `contacts`.`id` = `share_visibilities`.`contact_id` INNER JOIN `aspect_memberships` ON `aspect_memberships`.`contact_id` = `contacts`.`id` WHERE `posts`.`pending` = 0 AND `share_visibilities`.`hidden` = 0 AND `contacts`.`user_id` = 2 AND `contacts`.`receiving` = 1 AND `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND `aspect_memberships`.`aspect_id` IN (3) AND (`posts`.`created_at` < '2012-03-30 00:44:51') ORDER BY posts.created_at DESC LIMIT 15) UNION ALL (SELECT DISTINCT posts.id, posts.updated_at AS updated_at, posts.created_at AS created_at FROM `posts` INNER JOIN `aspect_visibilities` ON `aspect_visibilities`.`shareable_id` = `posts`.`id` AND `aspect_visibilities`.`shareable_type` = 'Post' WHERE `posts`.`author_id` = 2 AND `posts`.`pending` = 0 AND `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND `aspect_visibilities`.`aspect_id` IN (3) AND (`posts`.`created_at` < '2012-03-30 00:44:51') ORDER BY posts.created_at DESC LIMIT 15) ORDER BY created_at DESC LIMIT 15
Aspect Load (0.6ms) SELECT `aspects`.* FROM `aspects` WHERE `aspects`.`user_id` = 2 ORDER BY order_id ASC
Aspect Load (1.2ms) SELECT `aspects`.* FROM `aspects` WHERE `aspects`.`id` IN (3)
(1.0ms) SELECT people.id FROM `people` INNER JOIN `contacts` ON `contacts`.`person_id` = `people`.`id` INNER JOIN `aspect_memberships` ON `aspect_memberships`.`contact_id` = `contacts`.`id` WHERE `aspect_memberships`.`aspect_id` IN (3)
(0.8ms) SELECT DISTINCT posts.id, posts.updated_at AS updated_at, posts.created_at AS created_at FROM `posts` WHERE `posts`.`author_id` IN (NULL) AND `posts`.`public` = 1 AND `posts`.`pending` = 0 AND `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND (`posts`.`created_at` < '2012-03-30 00:44:51') ORDER BY posts.created_at DESC
ActsAsTaggableOn::Tag Load (18.7ms) SELECT `tags`.id FROM `tags` INNER JOIN `tag_followings` ON `tags`.`id` = `tag_followings`.`tag_id` WHERE `tag_followings`.`user_id` = 2 ORDER BY tags.name
(1.0ms) SELECT posts.id FROM `posts` INNER JOIN `taggings` ON `taggings`.`taggable_id` = `posts`.`id` AND taggings.context = 'tags' AND `taggings`.`taggable_type` = 'Post' INNER JOIN `tags` ON `tags`.`id` = `taggings`.`tag_id` WHERE `posts`.`public` = 1 AND `posts`.`pending` = 0 AND `tags`.`id` IN (NULL) AND `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND (posts.created_at < '2012-03-30 00:44:51') ORDER BY posts.created_at desc LIMIT 15
(3.8ms) SELECT posts.id FROM `posts` INNER JOIN `mentions` ON `mentions`.`post_id` = `posts`.`id` WHERE `mentions`.`person_id` = 2 AND `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND (posts.created_at < '2012-03-30 00:44:51') ORDER BY posts.created_at desc LIMIT 15
(13.8ms) SELECT id FROM `people` WHERE `people`.`diaspora_handle` IN ('diasporahq@joindiaspora.com')
(3.7ms) SELECT posts.id FROM `posts` WHERE `posts`.`public` = 1 AND `posts`.`pending` = 0 AND `posts`.`author_id` IN (NULL) AND `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND (posts.created_at < '2012-03-30 00:44:51') ORDER BY posts.created_at desc LIMIT 15
Block Load (0.9ms) SELECT `blocks`.* FROM `blocks` WHERE `blocks`.`user_id` = 2
Post Load (0.9ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`id` IN (NULL) AND `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND (posts.created_at < '2012-03-30 00:44:51') ORDER BY posts.created_at desc LIMIT 15
Like Load (1.0ms) SELECT `likes`.* FROM `likes` WHERE `likes`.`author_id` = 2 AND `likes`.`target_id` IN (NULL) AND `likes`.`target_type` = 'Post'
Participation Load (7.3ms) SELECT `participations`.* FROM `participations` WHERE `participations`.`author_id` = 2 AND `participations`.`target_id` IN (NULL) AND `participations`.`target_type` = 'Post'
Completed 200 OK in 1705ms (Views: 6.8ms | ActiveRecord: 424.1ms)
Started GET "/stream" for 127.0.0.1 at 2012-03-29 17:44:52 -0700
Processing by StreamsController#multi as HTML
User Load (1.5ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 2 LIMIT 1
Person Load (0.5ms) SELECT `people`.* FROM `people` WHERE `people`.`owner_id` = 2 LIMIT 1
Profile Load (0.5ms) SELECT `profiles`.* FROM `profiles` WHERE `profiles`.`person_id` = 2 LIMIT 1
Rendered aspects/_aspect_listings.haml (1.4ms)
Rendered tags/_followed_tags_listings.haml (1.0ms)
Aspect Load (0.4ms) SELECT `aspects`.* FROM `aspects` WHERE `aspects`.`user_id` = 2 ORDER BY order_id ASC
Service Load (0.4ms) SELECT `services`.* FROM `services` WHERE `services`.`user_id` = 2
CACHE (0.0ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 2 LIMIT 1
Rendered shared/_public_explain.haml (7.2ms)
Rendered photos/_new_photo.haml (1.6ms)
Rendered shared/_publisher.html.haml (27.5ms)
Rendered aspects/_no_posts_message.haml (0.4ms)
(0.3ms) SELECT COUNT(*) FROM `contacts` WHERE `contacts`.`user_id` = 2
Rendered aspects/_no_contacts_message.haml (1.7ms)
Rendered aspects/_aspect_stream.haml (37.8ms)
Rendered shared/_invitations.haml (2.3ms)
(0.3ms) SELECT COUNT(*) FROM `oauth_authorizations` WHERE `oauth_authorizations`.`resource_owner_id` = 2
Rendered shared/_right_sections.html.haml (15.5ms)
Rendered layouts/main_stream.html.haml within layouts/application (78.8ms)
(0.4ms) SELECT COUNT(*) FROM `notifications` WHERE `notifications`.`recipient_id` = 2 AND `notifications`.`unread` = 1
(0.3ms) SELECT SUM(`conversation_visibilities`.`unread`) AS sum_id FROM `conversation_visibilities` WHERE (person_id = 2)
Completed 200 OK in 129ms (Views: 115.3ms | ActiveRecord: 4.6ms)
Started GET "/stream" for 127.0.0.1 at 2012-03-29 17:44:53 -0700
Processing by StreamsController#multi as JSON
User Load (0.8ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 2 LIMIT 1
Aspect Load (0.4ms) SELECT `aspects`.id FROM `aspects` WHERE `aspects`.`user_id` = 2 ORDER BY order_id ASC
Person Load (3.1ms) SELECT `people`.* FROM `people` WHERE `people`.`owner_id` = 2 LIMIT 1
(23.6ms) (SELECT DISTINCT posts.id, posts.updated_at AS updated_at, posts.created_at AS created_at FROM `posts` INNER JOIN `share_visibilities` ON `share_visibilities`.`shareable_id` = `posts`.`id` AND `share_visibilities`.`shareable_type` = 'Post' INNER JOIN `contacts` ON `contacts`.`id` = `share_visibilities`.`contact_id` INNER JOIN `aspect_memberships` ON `aspect_memberships`.`contact_id` = `contacts`.`id` WHERE `posts`.`pending` = 0 AND `share_visibilities`.`hidden` = 0 AND `contacts`.`user_id` = 2 AND `contacts`.`receiving` = 1 AND `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND `aspect_memberships`.`aspect_id` IN (3) AND (`posts`.`created_at` < '2012-03-30 00:44:54') ORDER BY posts.created_at DESC LIMIT 15) UNION ALL (SELECT DISTINCT posts.id, posts.updated_at AS updated_at, posts.created_at AS created_at FROM `posts` INNER JOIN `aspect_visibilities` ON `aspect_visibilities`.`shareable_id` = `posts`.`id` AND `aspect_visibilities`.`shareable_type` = 'Post' WHERE `posts`.`author_id` = 2 AND `posts`.`pending` = 0 AND `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND `aspect_visibilities`.`aspect_id` IN (3) AND (`posts`.`created_at` < '2012-03-30 00:44:54') ORDER BY posts.created_at DESC LIMIT 15) ORDER BY created_at DESC LIMIT 15
Aspect Load (0.5ms) SELECT `aspects`.* FROM `aspects` WHERE `aspects`.`user_id` = 2 ORDER BY order_id ASC
Aspect Load (0.5ms) SELECT `aspects`.* FROM `aspects` WHERE `aspects`.`id` IN (3)
(1.5ms) SELECT people.id FROM `people` INNER JOIN `contacts` ON `contacts`.`person_id` = `people`.`id` INNER JOIN `aspect_memberships` ON `aspect_memberships`.`contact_id` = `contacts`.`id` WHERE `aspect_memberships`.`aspect_id` IN (3)
(7.3ms) SELECT DISTINCT posts.id, posts.updated_at AS updated_at, posts.created_at AS created_at FROM `posts` WHERE `posts`.`author_id` IN (NULL) AND `posts`.`public` = 1 AND `posts`.`pending` = 0 AND `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND (`posts`.`created_at` < '2012-03-30 00:44:54') ORDER BY posts.created_at DESC
ActsAsTaggableOn::Tag Load (2.7ms) SELECT `tags`.id FROM `tags` INNER JOIN `tag_followings` ON `tags`.`id` = `tag_followings`.`tag_id` WHERE `tag_followings`.`user_id` = 2 ORDER BY tags.name
(1.2ms) SELECT posts.id FROM `posts` INNER JOIN `taggings` ON `taggings`.`taggable_id` = `posts`.`id` AND taggings.context = 'tags' AND `taggings`.`taggable_type` = 'Post' INNER JOIN `tags` ON `tags`.`id` = `taggings`.`tag_id` WHERE `posts`.`public` = 1 AND `posts`.`pending` = 0 AND `tags`.`id` IN (NULL) AND `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND (posts.created_at < '2012-03-30 00:44:54') ORDER BY posts.created_at desc LIMIT 15
(6.1ms) SELECT posts.id FROM `posts` INNER JOIN `mentions` ON `mentions`.`post_id` = `posts`.`id` WHERE `mentions`.`person_id` = 2 AND `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND (posts.created_at < '2012-03-30 00:44:54') ORDER BY posts.created_at desc LIMIT 15
(0.3ms) SELECT id FROM `people` WHERE `people`.`diaspora_handle` IN ('diasporahq@joindiaspora.com')
(9.0ms) SELECT posts.id FROM `posts` WHERE `posts`.`public` = 1 AND `posts`.`pending` = 0 AND `posts`.`author_id` IN (NULL) AND `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND (posts.created_at < '2012-03-30 00:44:54') ORDER BY posts.created_at desc LIMIT 15
Block Load (4.5ms) SELECT `blocks`.* FROM `blocks` WHERE `blocks`.`user_id` = 2
Post Load (1.1ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`id` IN (NULL) AND `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND (posts.created_at < '2012-03-30 00:44:54') ORDER BY posts.created_at desc LIMIT 15
Like Load (0.3ms) SELECT `likes`.* FROM `likes` WHERE `likes`.`author_id` = 2 AND `likes`.`target_id` IN (NULL) AND `likes`.`target_type` = 'Post'
Participation Load (0.4ms) SELECT `participations`.* FROM `participations` WHERE `participations`.`author_id` = 2 AND `participations`.`target_id` IN (NULL) AND `participations`.`target_type` = 'Post'
Completed 200 OK in 164ms (Views: 1.4ms | ActiveRecord: 63.3ms)
Started GET "/people?utf8=%E2%9C%93&q=%23rockstar" for 127.0.0.1 at 2012-03-29 17:44:54 -0700
Processing by PeopleController#index as HTML
Parameters: {"utf8"=>"✓", "q"=>"#rockstar"}
User Load (0.8ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 2 LIMIT 1
Redirected to http://127.0.0.1:9887/tags/rockstar?q=%23rockstar
Completed 302 Found in 12ms
Started GET "/tags/rockstar?q=%23rockstar" for 127.0.0.1 at 2012-03-29 17:44:54 -0700
Processing by TagsController#show as HTML
Parameters: {"q"=>"#rockstar", "name"=>"rockstar"}
User Load (0.8ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 2 LIMIT 1
(18.7ms) SELECT COUNT(*) FROM `people` INNER JOIN `profiles` ON `profiles`.`person_id` = `people`.`id` INNER JOIN `taggings` ON `taggings`.`taggable_id` = `profiles`.`id` AND taggings.context = 'tags' AND `taggings`.`taggable_type` = 'Profile' INNER JOIN `tags` ON `tags`.`id` = `taggings`.`tag_id` WHERE `tags`.`name` = 'rockstar' AND (profiles.searchable IS TRUE)
Person Load (1.2ms) SELECT `people`.* FROM `people` INNER JOIN `profiles` ON `profiles`.`person_id` = `people`.`id` INNER JOIN `taggings` ON `taggings`.`taggable_id` = `profiles`.`id` AND taggings.context = 'tags' AND `taggings`.`taggable_type` = 'Profile' INNER JOIN `tags` ON `tags`.`id` = `taggings`.`tag_id` WHERE `tags`.`name` = 'rockstar' AND (profiles.searchable IS TRUE) LIMIT 15 OFFSET 0
Profile Load (0.9ms) SELECT `profiles`.* FROM `profiles` WHERE `profiles`.`person_id` = 1 LIMIT 1
Person Load (0.4ms) SELECT `people`.* FROM `people` WHERE `people`.`owner_id` = 2 LIMIT 1
Rendered people/_index.html.haml (19.7ms)
Rendered tags/_followed_tags_listings.haml (1.4ms)
(0.7ms) SELECT 1 FROM `tag_followings` INNER JOIN `tags` ON `tags`.`id` = `tag_followings`.`tag_id` WHERE `tags`.`name` = 'rockstar' AND `tag_followings`.`user_id` = 2 LIMIT 1
ActsAsTaggableOn::Tag Load (0.7ms) SELECT `tags`.* FROM `tags` WHERE `tags`.`name` = 'rockstar' LIMIT 1
(0.6ms) SELECT COUNT(*) FROM `tag_followings` WHERE `tag_followings`.`tag_id` = 1
Aspect Load (0.5ms) SELECT `aspects`.* FROM `aspects` WHERE `aspects`.`user_id` = 2 ORDER BY order_id ASC
Service Load (0.4ms) SELECT `services`.* FROM `services` WHERE `services`.`user_id` = 2
CACHE (0.0ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 2 LIMIT 1
Rendered shared/_public_explain.haml (4.8ms)
Rendered photos/_new_photo.haml (2.5ms)
Rendered shared/_publisher.html.haml (22.3ms)
Rendered tags/show.haml within layouts/application (161.8ms)
Profile Load (0.5ms) SELECT `profiles`.* FROM `profiles` WHERE `profiles`.`person_id` = 2 LIMIT 1
(0.3ms) SELECT COUNT(*) FROM `notifications` WHERE `notifications`.`recipient_id` = 2 AND `notifications`.`unread` = 1
(0.3ms) SELECT SUM(`conversation_visibilities`.`unread`) AS sum_id FROM `conversation_visibilities` WHERE (person_id = 2)
Completed 200 OK in 265ms (Views: 228.2ms | ActiveRecord: 28.4ms)
Started GET "/tags/rockstar" for 127.0.0.1 at 2012-03-29 17:44:55 -0700
Processing by TagsController#show as JSON
Parameters: {"name"=>"rockstar"}
User Load (0.8ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 2 LIMIT 1
Person Load (0.5ms) SELECT `people`.* FROM `people` WHERE `people`.`owner_id` = 2 LIMIT 1
ActsAsTaggableOn::Tag Load (78.2ms) SELECT `tags`.* FROM `tags` WHERE (name LIKE 'rockstar' ESCAPE '!')
Block Load (0.9ms) SELECT `blocks`.* FROM `blocks` WHERE `blocks`.`user_id` = 2
StatusMessage Load (438.2ms) SELECT DISTINCT posts.* FROM `posts` LEFT OUTER JOIN share_visibilities ON share_visibilities.shareable_id = posts.id AND share_visibilities.shareable_type = 'Post' LEFT OUTER JOIN contacts ON contacts.id = share_visibilities.contact_id JOIN taggings posts_taggings_508dce0 ON posts_taggings_508dce0.taggable_id = posts.id AND posts_taggings_508dce0.taggable_type = 'Post' AND posts_taggings_508dce0.tag_id = 1 WHERE `posts`.`type` IN ('StatusMessage', 'Reshare', 'ActivityStreams::Photo') AND ((`contacts`.`user_id` = 2 OR (`posts`.`public` = 1 OR `posts`.`author_id` = 2))) AND (posts.created_at < '2012-03-30 00:44:56') ORDER BY posts.created_at desc LIMIT 15
Like Load (0.4ms) SELECT `likes`.* FROM `likes` WHERE `likes`.`author_id` = 2 AND `likes`.`target_id` IN (NULL) AND `likes`.`target_type` = 'Post'
Participation Load (0.4ms) SELECT `participations`.* FROM `participations` WHERE `participations`.`author_id` = 2 AND `participations`.`target_id` IN (NULL) AND `participations`.`target_type` = 'Post'
Completed 200 OK in 566ms (Views: 3.3ms | ActiveRecord: 519.3ms)
(24.6ms) SELECT @@FOREIGN_KEY_CHECKS
(0.3ms) SET FOREIGN_KEY_CHECKS = 0
(79.7ms) TRUNCATE TABLE `account_deletions`;
(66.8ms) TRUNCATE TABLE `aspect_memberships`;
(49.5ms) TRUNCATE TABLE `aspect_visibilities`;
(33.3ms) TRUNCATE TABLE `aspects`;
(32.6ms) TRUNCATE TABLE `blocks`;
(124.9ms) TRUNCATE TABLE `comments`;
(41.5ms) TRUNCATE TABLE `contacts`;
(33.0ms) TRUNCATE TABLE `conversation_visibilities`;
(33.0ms) TRUNCATE TABLE `conversations`;
(33.1ms) TRUNCATE TABLE `invitation_codes`;
(33.2ms) TRUNCATE TABLE `invitations`;
(74.8ms) TRUNCATE TABLE `likes`;
(33.1ms) TRUNCATE TABLE `mentions`;
(33.0ms) TRUNCATE TABLE `messages`;
(33.1ms) TRUNCATE TABLE `notification_actors`;
(33.2ms) TRUNCATE TABLE `notifications`;
(33.0ms) TRUNCATE TABLE `o_embed_caches`;
(33.5ms) TRUNCATE TABLE `oauth_access_tokens`;
(57.9ms) TRUNCATE TABLE `oauth_authorization_codes`;
(133.2ms) TRUNCATE TABLE `oauth_authorizations`;
(222.8ms) TRUNCATE TABLE `oauth_clients`;
(460.2ms) TRUNCATE TABLE `participations`;
(34.1ms) TRUNCATE TABLE `people`;
(32.8ms) TRUNCATE TABLE `photos`;
(33.0ms) TRUNCATE TABLE `pods`;
(41.5ms) TRUNCATE TABLE `posts`;
(32.9ms) TRUNCATE TABLE `profiles`;
(32.9ms) TRUNCATE TABLE `service_users`;
(33.0ms) TRUNCATE TABLE `services`;
(33.3ms) TRUNCATE TABLE `share_visibilities`;
(41.1ms) TRUNCATE TABLE `tag_followings`;
(33.0ms) TRUNCATE TABLE `taggings`;
(32.9ms) TRUNCATE TABLE `tags`;
(33.0ms) TRUNCATE TABLE `user_preferences`;
(33.2ms) TRUNCATE TABLE `users`;
(0.2ms) SET FOREIGN_KEY_CHECKS = 1
(64.8ms) SELECT @@FOREIGN_KEY_CHECKS
(0.2ms) SET FOREIGN_KEY_CHECKS = 0
(56.1ms) TRUNCATE TABLE `account_deletions`;
(33.0ms) TRUNCATE TABLE `aspect_memberships`;
(33.0ms) TRUNCATE TABLE `aspect_visibilities`;
(33.1ms) TRUNCATE TABLE `aspects`;
(33.1ms) TRUNCATE TABLE `blocks`;
(41.6ms) TRUNCATE TABLE `comments`;
(33.1ms) TRUNCATE TABLE `contacts`;
(33.2ms) TRUNCATE TABLE `conversation_visibilities`;
(33.0ms) TRUNCATE TABLE `conversations`;
(33.1ms) TRUNCATE TABLE `invitation_codes`;
(33.2ms) TRUNCATE TABLE `invitations`;
(41.4ms) TRUNCATE TABLE `likes`;
(33.1ms) TRUNCATE TABLE `mentions`;
(33.1ms) TRUNCATE TABLE `messages`;
(33.2ms) TRUNCATE TABLE `notification_actors`;
(41.4ms) TRUNCATE TABLE `notifications`;
(33.1ms) TRUNCATE TABLE `o_embed_caches`;
(91.4ms) TRUNCATE TABLE `oauth_access_tokens`;
(33.1ms) TRUNCATE TABLE `oauth_authorization_codes`;
(49.8ms) TRUNCATE TABLE `oauth_authorizations`;
(41.5ms) TRUNCATE TABLE `oauth_clients`;
(41.4ms) TRUNCATE TABLE `participations`;
(41.5ms) TRUNCATE TABLE `people`;
(91.4ms) TRUNCATE TABLE `photos`;
(41.4ms) TRUNCATE TABLE `pods`;
(41.6ms) TRUNCATE TABLE `posts`;
(33.1ms) TRUNCATE TABLE `profiles`;
(41.4ms) TRUNCATE TABLE `service_users`;
(91.5ms) TRUNCATE TABLE `services`;
(41.5ms) TRUNCATE TABLE `share_visibilities`;
(41.4ms) TRUNCATE TABLE `tag_followings`;
(41.4ms) TRUNCATE TABLE `taggings`;
(99.7ms) TRUNCATE TABLE `tags`;
(33.2ms) TRUNCATE TABLE `user_preferences`;
(41.5ms) TRUNCATE TABLE `users`;
(0.2ms) SET FOREIGN_KEY_CHECKS = 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment