# Logfile created on Thu Feb 22 22:40:54 EST 2007 by logger.rb/1.5.2.7
  [4;36;1mTopic Columns (0.000000)[0m   [0;1mMysql::Error: Table 'myiog_development.topics' doesn't exist: SHOW FIELDS FROM topics[0m
  [4;36;1mSQL (0.000000)[0m   [0;1mMysql::Error: Unknown table 'comments': DROP TABLE comments[0m
  [4;35;1mSQL (0.037681)[0m   [0mCREATE TABLE comments (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `body` text, `created_by` int(11), `created_at` datetime, `topic_id` int(11) DEFAULT 0, `root_id` int(11) DEFAULT 0, `parent_id` int(11) DEFAULT 0, `lft` int(11) DEFAULT 0, `rgt` int(11) DEFAULT 0, `depth` int(11) DEFAULT 0, `removed` tinyint(1) DEFAULT 0, `word_count` int(11), `reading_count` int(11) DEFAULT 0, `avg_rating` float) ENGINE=InnoDB[0m
  [4;36;1mSQL (0.015824)[0m   [0;1mCREATE INDEX `root_id` ON comments (`root_id`)[0m
  [4;35;1mSQL (0.000000)[0m   [0mMysql::Error: Unknown table 'logged_exceptions': DROP TABLE logged_exceptions[0m
  [4;36;1mSQL (0.002545)[0m   [0;1mCREATE TABLE logged_exceptions (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `exception_class` varchar(255), `controller_name` varchar(255), `action_name` varchar(255), `message` varchar(255), `backtrace` text, `environment` text, `request` text, `created_at` datetime) ENGINE=InnoDB[0m
  [4;35;1mSQL (0.000000)[0m   [0mMysql::Error: Unknown table 'page_versions': DROP TABLE page_versions[0m
  [4;36;1mSQL (0.002914)[0m   [0;1mCREATE TABLE page_versions (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `page_id` int(11), `version` int(11), `parent_id` int(11), `full_path` text, `title` varchar(255), `slug` varchar(255), `keywords` varchar(255), `body` text, `filter_type` varchar(25) DEFAULT 'Textile', `author` varchar(255), `position` int(11) DEFAULT 0, `updated_on` datetime, `created_on` datetime) ENGINE=InnoDB[0m
  [4;35;1mSQL (0.000000)[0m   [0mMysql::Error: Unknown table 'ratings': DROP TABLE ratings[0m
  [4;36;1mSQL (0.001765)[0m   [0;1mCREATE TABLE ratings (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `value` int(11) DEFAULT 0 NOT NULL, `subject_id` int(11) DEFAULT 0 NOT NULL, `participant_id` int(11), `created_on` datetime NOT NULL, `type` varchar(255)) ENGINE=InnoDB[0m
  [4;35;1mSQL (0.004398)[0m   [0mCREATE INDEX `subject_id` ON ratings (`subject_id`)[0m
  [4;36;1mSQL (0.015312)[0m   [0;1mCREATE INDEX `value` ON ratings (`value`)[0m
  [4;35;1mSQL (0.000000)[0m   [0mMysql::Error: Unknown table 'readings': DROP TABLE readings[0m
  [4;36;1mSQL (0.002866)[0m   [0;1mCREATE TABLE readings (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `participant_id` int(11) DEFAULT 0 NOT NULL, `readable_id` int(11), `created_at` datetime, `readable_type` varchar(255)) ENGINE=InnoDB[0m
  [4;35;1mSQL (0.000000)[0m   [0mMysql::Error: Unknown table 'sessions': DROP TABLE sessions[0m
  [4;36;1mSQL (0.002015)[0m   [0;1mCREATE TABLE sessions (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `session_id` varchar(255), `data` text, `updated_at` datetime, `created_at` datetime) ENGINE=InnoDB[0m
  [4;35;1mSQL (0.004355)[0m   [0mCREATE INDEX `sessions_session_id_index` ON sessions (`session_id`)[0m
  [4;36;1mSQL (0.000000)[0m   [0;1mMysql::Error: Unknown table 'settings': DROP TABLE settings[0m
  [4;35;1mSQL (0.001583)[0m   [0mCREATE TABLE settings (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `var` varchar(255) DEFAULT '' NOT NULL, `value` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB[0m
  [4;36;1mSQL (0.000000)[0m   [0;1mMysql::Error: Unknown table 'snippets': DROP TABLE snippets[0m
  [4;35;1mSQL (0.001808)[0m   [0mCREATE TABLE snippets (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255), `body` text) ENGINE=InnoDB[0m
  [4;36;1mSQL (0.000000)[0m   [0;1mMysql::Error: Unknown table 'support_materials': DROP TABLE support_materials[0m
  [4;35;1mSQL (0.001925)[0m   [0mCREATE TABLE support_materials (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255) DEFAULT '' NOT NULL, `url` varchar(255) DEFAULT '', `topic_id` int(11) DEFAULT 0 NOT NULL, `reading_count` int(11), `filename` varchar(255), `content_type` varchar(255), `size` int(11), `parent_id` int(11)) ENGINE=InnoDB[0m
  [4;36;1mSQL (0.000000)[0m   [0;1mMysql::Error: Unknown table 'topics': DROP TABLE topics[0m
  [4;35;1mSQL (0.002111)[0m   [0mCREATE TABLE topics (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `introduction` text, `body_copy` text, `start_date` date, `expert_id` int(11), `approved` blob, `lock_version` int(11) DEFAULT 0, `continue_reading` varchar(255) DEFAULT 'Read the full piece', `front_page_worthy` tinyint(1) DEFAULT 1) ENGINE=InnoDB[0m
  [4;36;1mSQL (0.000000)[0m   [0;1mMysql::Error: Unknown table 'users': DROP TABLE users[0m
  [4;35;1mSQL (0.018836)[0m   [0mCREATE TABLE users (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255), `type` varchar(255), `email` varchar(100), `crypted_password` varchar(40), `salt` varchar(40), `created_at` datetime, `bio` text, `picture` varchar(255), `user_number` varchar(255), `year_of_birth` int(11), `gender` int(11) DEFAULT 0, `postal_code` varchar(255), `login_key` varchar(255), `verified` tinyint(1) DEFAULT 0, `login_key_expires_at` datetime, `avg_rating` float, `suspended` tinyint(1) DEFAULT 0) ENGINE=InnoDB[0m
  [4;36;1mSQL (0.001237)[0m   [0;1mCREATE TABLE schema_info (version int(11))[0m
  [4;35;1mSQL (0.000217)[0m   [0mINSERT INTO schema_info (version) VALUES(0)[0m
  [4;36;1mSQL (0.000207)[0m   [0;1mSHOW FIELDS FROM schema_info[0m
  [4;35;1mSQL (0.000169)[0m   [0mUPDATE schema_info SET version = 39[0m
  [4;36;1mTopic Columns (0.000419)[0m   [0;1mSHOW FIELDS FROM topics[0m
  [4;35;1mSQL (0.000256)[0m   [0mSELECT count(*) AS count_all FROM topics [0m
  [4;36;1mSQL (0.000296)[0m   [0;1mSELECT * FROM schema_info[0m
  [4;35;1mSQL (0.000179)[0m   [0mSHOW TABLES[0m
  [4;36;1mSQL (0.000250)[0m   [0;1mSHOW FIELDS FROM comments[0m
  [4;35;1mSQL (0.000208)[0m   [0mSHOW KEYS FROM comments[0m
  [4;36;1mSQL (0.000228)[0m   [0;1mSHOW FIELDS FROM logged_exceptions[0m
  [4;35;1mSQL (0.000158)[0m   [0mSHOW KEYS FROM logged_exceptions[0m
  [4;36;1mSQL (0.000229)[0m   [0;1mSHOW FIELDS FROM page_versions[0m
  [4;35;1mSQL (0.000155)[0m   [0mSHOW KEYS FROM page_versions[0m
  [4;36;1mSQL (0.000208)[0m   [0;1mSHOW FIELDS FROM ratings[0m
  [4;35;1mSQL (0.000212)[0m   [0mSHOW KEYS FROM ratings[0m
  [4;36;1mSQL (0.000208)[0m   [0;1mSHOW FIELDS FROM readings[0m
  [4;35;1mSQL (0.000151)[0m   [0mSHOW KEYS FROM readings[0m
  [4;36;1mSQL (0.000205)[0m   [0;1mSHOW FIELDS FROM sessions[0m
  [4;35;1mSQL (0.000155)[0m   [0mSHOW KEYS FROM sessions[0m
  [4;36;1mSQL (0.000200)[0m   [0;1mSHOW FIELDS FROM settings[0m
  [4;35;1mSQL (0.000145)[0m   [0mSHOW KEYS FROM settings[0m
  [4;36;1mSQL (0.000175)[0m   [0;1mSHOW FIELDS FROM snippets[0m
  [4;35;1mSQL (0.000130)[0m   [0mSHOW KEYS FROM snippets[0m
  [4;36;1mSQL (0.000194)[0m   [0;1mSHOW FIELDS FROM support_materials[0m
  [4;35;1mSQL (0.000150)[0m   [0mSHOW KEYS FROM support_materials[0m
  [4;36;1mSQL (0.000112)[0m   [0;1mSHOW FIELDS FROM topics[0m
  [4;35;1mSQL (0.059581)[0m   [0mSHOW KEYS FROM topics[0m
  [4;36;1mSQL (0.006204)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mSQL (0.000235)[0m   [0mSHOW KEYS FROM users[0m
  [4;36;1mSQL (0.013817)[0m   [0;1mDROP DATABASE IF EXISTS `myiog_test`[0m
  [4;35;1mSQL (0.000167)[0m   [0mCREATE DATABASE `myiog_test`[0m
  [4;36;1mSQL (0.000000)[0m   [0;1mMysql::Error: Unknown table 'comments': DROP TABLE comments[0m
  [4;35;1mSQL (0.002490)[0m   [0mCREATE TABLE comments (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `body` text, `created_by` int(11), `created_at` datetime, `topic_id` int(11) DEFAULT 0, `root_id` int(11) DEFAULT 0, `parent_id` int(11) DEFAULT 0, `lft` int(11) DEFAULT 0, `rgt` int(11) DEFAULT 0, `depth` int(11) DEFAULT 0, `removed` tinyint(1) DEFAULT 0, `word_count` int(11), `reading_count` int(11) DEFAULT 0, `avg_rating` float) ENGINE=InnoDB[0m
  [4;36;1mSQL (0.003896)[0m   [0;1mCREATE INDEX `root_id` ON comments (`root_id`)[0m
  [4;35;1mSQL (0.000000)[0m   [0mMysql::Error: Unknown table 'logged_exceptions': DROP TABLE logged_exceptions[0m
  [4;36;1mSQL (0.002086)[0m   [0;1mCREATE TABLE logged_exceptions (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `exception_class` varchar(255), `controller_name` varchar(255), `action_name` varchar(255), `message` varchar(255), `backtrace` text, `environment` text, `request` text, `created_at` datetime) ENGINE=InnoDB[0m
  [4;35;1mSQL (0.000000)[0m   [0mMysql::Error: Unknown table 'page_versions': DROP TABLE page_versions[0m
  [4;36;1mSQL (0.002891)[0m   [0;1mCREATE TABLE page_versions (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `page_id` int(11), `version` int(11), `parent_id` int(11), `full_path` text, `title` varchar(255), `slug` varchar(255), `keywords` varchar(255), `body` text, `filter_type` varchar(25) DEFAULT 'Textile', `author` varchar(255), `position` int(11) DEFAULT 0, `updated_on` datetime, `created_on` datetime) ENGINE=InnoDB[0m
  [4;35;1mSQL (0.000000)[0m   [0mMysql::Error: Unknown table 'ratings': DROP TABLE ratings[0m
  [4;36;1mSQL (0.002555)[0m   [0;1mCREATE TABLE ratings (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `value` int(11) DEFAULT 0 NOT NULL, `subject_id` int(11) DEFAULT 0 NOT NULL, `participant_id` int(11), `created_on` datetime NOT NULL, `type` varchar(255)) ENGINE=InnoDB[0m
  [4;35;1mSQL (0.004455)[0m   [0mCREATE INDEX `subject_id` ON ratings (`subject_id`)[0m
  [4;36;1mSQL (0.004581)[0m   [0;1mCREATE INDEX `value` ON ratings (`value`)[0m
  [4;35;1mSQL (0.000000)[0m   [0mMysql::Error: Unknown table 'readings': DROP TABLE readings[0m
  [4;36;1mSQL (0.002359)[0m   [0;1mCREATE TABLE readings (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `participant_id` int(11) DEFAULT 0 NOT NULL, `readable_id` int(11), `created_at` datetime, `readable_type` varchar(255)) ENGINE=InnoDB[0m
  [4;35;1mSQL (0.000000)[0m   [0mMysql::Error: Unknown table 'sessions': DROP TABLE sessions[0m
  [4;36;1mSQL (0.002571)[0m   [0;1mCREATE TABLE sessions (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `session_id` varchar(255), `data` text, `updated_at` datetime, `created_at` datetime) ENGINE=InnoDB[0m
  [4;35;1mSQL (0.004095)[0m   [0mCREATE INDEX `sessions_session_id_index` ON sessions (`session_id`)[0m
  [4;36;1mSQL (0.000000)[0m   [0;1mMysql::Error: Unknown table 'settings': DROP TABLE settings[0m
  [4;35;1mSQL (0.001894)[0m   [0mCREATE TABLE settings (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `var` varchar(255) DEFAULT '' NOT NULL, `value` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB[0m
  [4;36;1mSQL (0.000000)[0m   [0;1mMysql::Error: Unknown table 'snippets': DROP TABLE snippets[0m
  [4;35;1mSQL (0.002439)[0m   [0mCREATE TABLE snippets (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255), `body` text) ENGINE=InnoDB[0m
  [4;36;1mSQL (0.000000)[0m   [0;1mMysql::Error: Unknown table 'support_materials': DROP TABLE support_materials[0m
  [4;35;1mSQL (0.002321)[0m   [0mCREATE TABLE support_materials (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255) DEFAULT '' NOT NULL, `url` varchar(255) DEFAULT '', `topic_id` int(11) DEFAULT 0 NOT NULL, `reading_count` int(11), `filename` varchar(255), `content_type` varchar(255), `size` int(11), `parent_id` int(11)) ENGINE=InnoDB[0m
  [4;36;1mSQL (0.000000)[0m   [0;1mMysql::Error: Unknown table 'topics': DROP TABLE topics[0m
  [4;35;1mSQL (0.001813)[0m   [0mCREATE TABLE topics (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `introduction` text, `body_copy` text, `start_date` date, `expert_id` int(11), `approved` blob, `lock_version` int(11) DEFAULT 0, `continue_reading` varchar(255) DEFAULT 'Read the full piece', `front_page_worthy` tinyint(1) DEFAULT 1) ENGINE=InnoDB[0m
  [4;36;1mSQL (0.000000)[0m   [0;1mMysql::Error: Unknown table 'users': DROP TABLE users[0m
  [4;35;1mSQL (0.002518)[0m   [0mCREATE TABLE users (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255), `type` varchar(255), `email` varchar(100), `crypted_password` varchar(40), `salt` varchar(40), `created_at` datetime, `bio` text, `picture` varchar(255), `user_number` varchar(255), `year_of_birth` int(11), `gender` int(11) DEFAULT 0, `postal_code` varchar(255), `login_key` varchar(255), `verified` tinyint(1) DEFAULT 0, `login_key_expires_at` datetime, `avg_rating` float, `suspended` tinyint(1) DEFAULT 0) ENGINE=InnoDB[0m
  [4;36;1mSQL (0.001725)[0m   [0;1mCREATE TABLE schema_info (version int(11))[0m
  [4;35;1mSQL (0.000205)[0m   [0mINSERT INTO schema_info (version) VALUES(0)[0m
  [4;36;1mSQL (0.000111)[0m   [0;1mSHOW FIELDS FROM schema_info[0m
  [4;35;1mSQL (0.000132)[0m   [0mUPDATE schema_info SET version = 39[0m
  [4;36;1mSQL (0.000296)[0m   [0;1mSELECT * FROM schema_info[0m
  [4;35;1mSQL (0.000186)[0m   [0mSHOW TABLES[0m
  [4;36;1mSQL (0.000142)[0m   [0;1mSHOW FIELDS FROM comments[0m
  [4;35;1mSQL (0.000201)[0m   [0mSHOW KEYS FROM comments[0m
  [4;36;1mSQL (0.000108)[0m   [0;1mSHOW FIELDS FROM logged_exceptions[0m
  [4;35;1mSQL (0.000145)[0m   [0mSHOW KEYS FROM logged_exceptions[0m
  [4;36;1mSQL (0.000118)[0m   [0;1mSHOW FIELDS FROM page_versions[0m
  [4;35;1mSQL (0.000160)[0m   [0mSHOW KEYS FROM page_versions[0m
  [4;36;1mSQL (0.000096)[0m   [0;1mSHOW FIELDS FROM ratings[0m
  [4;35;1mSQL (0.000212)[0m   [0mSHOW KEYS FROM ratings[0m
  [4;36;1mSQL (0.000095)[0m   [0;1mSHOW FIELDS FROM readings[0m
  [4;35;1mSQL (0.000141)[0m   [0mSHOW KEYS FROM readings[0m
  [4;36;1mSQL (0.000090)[0m   [0;1mSHOW FIELDS FROM sessions[0m
  [4;35;1mSQL (0.000149)[0m   [0mSHOW KEYS FROM sessions[0m
  [4;36;1mSQL (0.000093)[0m   [0;1mSHOW FIELDS FROM settings[0m
  [4;35;1mSQL (0.000133)[0m   [0mSHOW KEYS FROM settings[0m
  [4;36;1mSQL (0.000083)[0m   [0;1mSHOW FIELDS FROM snippets[0m
  [4;35;1mSQL (0.000123)[0m   [0mSHOW KEYS FROM snippets[0m
  [4;36;1mSQL (0.000099)[0m   [0;1mSHOW FIELDS FROM support_materials[0m
  [4;35;1mSQL (0.000136)[0m   [0mSHOW KEYS FROM support_materials[0m
  [4;36;1mSQL (0.000104)[0m   [0;1mSHOW FIELDS FROM topics[0m
  [4;35;1mSQL (0.064575)[0m   [0mSHOW KEYS FROM topics[0m
  [4;36;1mSQL (0.002214)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mSQL (0.000248)[0m   [0mSHOW KEYS FROM users[0m
  [4;36;1mSQL (0.013874)[0m   [0;1mDROP DATABASE IF EXISTS `myiog_test`[0m
  [4;35;1mSQL (0.000166)[0m   [0mCREATE DATABASE `myiog_test`[0m
  [4;36;1mSQL (0.000000)[0m   [0;1mMysql::Error: Unknown table 'comments': DROP TABLE comments[0m
  [4;35;1mSQL (0.002985)[0m   [0mCREATE TABLE comments (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `body` text, `created_by` int(11), `created_at` datetime, `topic_id` int(11) DEFAULT 0, `root_id` int(11) DEFAULT 0, `parent_id` int(11) DEFAULT 0, `lft` int(11) DEFAULT 0, `rgt` int(11) DEFAULT 0, `depth` int(11) DEFAULT 0, `removed` tinyint(1) DEFAULT 0, `word_count` int(11), `reading_count` int(11) DEFAULT 0, `avg_rating` float) ENGINE=InnoDB[0m
  [4;36;1mSQL (0.003765)[0m   [0;1mCREATE INDEX `root_id` ON comments (`root_id`)[0m
  [4;35;1mSQL (0.000000)[0m   [0mMysql::Error: Unknown table 'logged_exceptions': DROP TABLE logged_exceptions[0m
  [4;36;1mSQL (0.002408)[0m   [0;1mCREATE TABLE logged_exceptions (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `exception_class` varchar(255), `controller_name` varchar(255), `action_name` varchar(255), `message` varchar(255), `backtrace` text, `environment` text, `request` text, `created_at` datetime) ENGINE=InnoDB[0m
  [4;35;1mSQL (0.000000)[0m   [0mMysql::Error: Unknown table 'page_versions': DROP TABLE page_versions[0m
  [4;36;1mSQL (0.002166)[0m   [0;1mCREATE TABLE page_versions (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `page_id` int(11), `version` int(11), `parent_id` int(11), `full_path` text, `title` varchar(255), `slug` varchar(255), `keywords` varchar(255), `body` text, `filter_type` varchar(25) DEFAULT 'Textile', `author` varchar(255), `position` int(11) DEFAULT 0, `updated_on` datetime, `created_on` datetime) ENGINE=InnoDB[0m
  [4;35;1mSQL (0.000000)[0m   [0mMysql::Error: Unknown table 'ratings': DROP TABLE ratings[0m
  [4;36;1mSQL (0.001944)[0m   [0;1mCREATE TABLE ratings (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `value` int(11) DEFAULT 0 NOT NULL, `subject_id` int(11) DEFAULT 0 NOT NULL, `participant_id` int(11), `created_on` datetime NOT NULL, `type` varchar(255)) ENGINE=InnoDB[0m
  [4;35;1mSQL (0.004210)[0m   [0mCREATE INDEX `subject_id` ON ratings (`subject_id`)[0m
  [4;36;1mSQL (0.004587)[0m   [0;1mCREATE INDEX `value` ON ratings (`value`)[0m
  [4;35;1mSQL (0.000000)[0m   [0mMysql::Error: Unknown table 'readings': DROP TABLE readings[0m
  [4;36;1mSQL (0.002655)[0m   [0;1mCREATE TABLE readings (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `participant_id` int(11) DEFAULT 0 NOT NULL, `readable_id` int(11), `created_at` datetime, `readable_type` varchar(255)) ENGINE=InnoDB[0m
  [4;35;1mSQL (0.000000)[0m   [0mMysql::Error: Unknown table 'sessions': DROP TABLE sessions[0m
  [4;36;1mSQL (0.002418)[0m   [0;1mCREATE TABLE sessions (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `session_id` varchar(255), `data` text, `updated_at` datetime, `created_at` datetime) ENGINE=InnoDB[0m
  [4;35;1mSQL (0.003966)[0m   [0mCREATE INDEX `sessions_session_id_index` ON sessions (`session_id`)[0m
  [4;36;1mSQL (0.000000)[0m   [0;1mMysql::Error: Unknown table 'settings': DROP TABLE settings[0m
  [4;35;1mSQL (0.001815)[0m   [0mCREATE TABLE settings (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `var` varchar(255) DEFAULT '' NOT NULL, `value` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB[0m
  [4;36;1mSQL (0.000000)[0m   [0;1mMysql::Error: Unknown table 'snippets': DROP TABLE snippets[0m
  [4;35;1mSQL (0.002543)[0m   [0mCREATE TABLE snippets (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255), `body` text) ENGINE=InnoDB[0m
  [4;36;1mSQL (0.000000)[0m   [0;1mMysql::Error: Unknown table 'support_materials': DROP TABLE support_materials[0m
  [4;35;1mSQL (0.002150)[0m   [0mCREATE TABLE support_materials (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255) DEFAULT '' NOT NULL, `url` varchar(255) DEFAULT '', `topic_id` int(11) DEFAULT 0 NOT NULL, `reading_count` int(11), `filename` varchar(255), `content_type` varchar(255), `size` int(11), `parent_id` int(11)) ENGINE=InnoDB[0m
  [4;36;1mSQL (0.000000)[0m   [0;1mMysql::Error: Unknown table 'topics': DROP TABLE topics[0m
  [4;35;1mSQL (0.002024)[0m   [0mCREATE TABLE topics (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `introduction` text, `body_copy` text, `start_date` date, `expert_id` int(11), `approved` blob, `lock_version` int(11) DEFAULT 0, `continue_reading` varchar(255) DEFAULT 'Read the full piece', `front_page_worthy` tinyint(1) DEFAULT 1) ENGINE=InnoDB[0m
  [4;36;1mSQL (0.000000)[0m   [0;1mMysql::Error: Unknown table 'users': DROP TABLE users[0m
  [4;35;1mSQL (0.002444)[0m   [0mCREATE TABLE users (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255), `type` varchar(255), `email` varchar(100), `crypted_password` varchar(40), `salt` varchar(40), `created_at` datetime, `bio` text, `picture` varchar(255), `user_number` varchar(255), `year_of_birth` int(11), `gender` int(11) DEFAULT 0, `postal_code` varchar(255), `login_key` varchar(255), `verified` tinyint(1) DEFAULT 0, `login_key_expires_at` datetime, `avg_rating` float, `suspended` tinyint(1) DEFAULT 0) ENGINE=InnoDB[0m
  [4;36;1mSQL (0.001671)[0m   [0;1mCREATE TABLE schema_info (version int(11))[0m
  [4;35;1mSQL (0.000209)[0m   [0mINSERT INTO schema_info (version) VALUES(0)[0m
  [4;36;1mSQL (0.000111)[0m   [0;1mSHOW FIELDS FROM schema_info[0m
  [4;35;1mSQL (0.000123)[0m   [0mUPDATE schema_info SET version = 39[0m


Processing BlogController#index (for 74.104.79.219 at 2007-02-22 22:58:23) [GET]
  Session ID: 9d32f0b496c4ffa288daa5a2cb71acbd
  Parameters: {"action"=>"index", "controller"=>"blog"}
  [4;36;1mGuest Columns (0.000195)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mGuest Load (0.000317)[0m   [0mSELECT * FROM users WHERE (users.id = 53638) AND ( (users.`type` = 'Guest' ) ) [0m
  [4;36;1mSQL (0.000078)[0m   [0;1mBEGIN[0m
  [4;35;1mSQL (0.000349)[0m   [0mINSERT INTO users (`name`, `salt`, `user_number`, `postal_code`, `crypted_password`, `login_key`, `login_key_expires_at`, `type`, `gender`, `suspended`, `year_of_birth`, `bio`, `picture`, `verified`, `avg_rating`, `created_at`, `email`) VALUES(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Guest', 0, 0, NULL, NULL, NULL, 0, NULL, '2007-02-22 22:58:23', NULL)[0m
  [4;36;1mSQL (0.001476)[0m   [0;1mCOMMIT[0m
Cookie set: guest_id=1; path=/; expires=Sat, 23 Feb 2008 09:58:23 GMT
  [4;35;1mTopic Load (0.000459)[0m   [0mSELECT * FROM topics WHERE (approved = 1 && `start_date` <= '2007-02-22') AND (front_page_worthy = 1) ORDER BY `start_date` DESC LIMIT 5[0m
  [4;36;1mComment Columns (0.000211)[0m   [0;1mSHOW FIELDS FROM comments[0m
  [4;35;1mUser Columns (0.000168)[0m   [0mSHOW FIELDS FROM users[0m
  [4;36;1mComment Load Including Associations (0.000514)[0m   [0;1mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 22:58:23') AND (reading_count > 0) ORDER BY reading_count DESC LIMIT 3[0m
  [4;35;1mComment Load Including Associations (0.000497)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 22:58:23') AND (comments.avg_rating > 0) ORDER BY comments.avg_rating ASC LIMIT 3[0m
  [4;36;1mParticipant Columns (0.000170)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mParticipant Load (0.000328)[0m   [0mSELECT * FROM users WHERE (avg_rating > 0) AND ( (users.`type` = 'Participant' ) ) ORDER BY avg_rating ASC LIMIT 10[0m
  [4;36;1mComment Load Including Associations (0.000420)[0m   [0;1mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by ORDER BY comments.created_at DESC LIMIT 3[0m
  [4;35;1mSnippet Columns (0.000206)[0m   [0mSHOW FIELDS FROM snippets[0m
  [4;36;1mSnippet Load (0.000249)[0m   [0;1mSELECT * FROM snippets WHERE (snippets.`name` = 'blog_font_page_greeting' ) LIMIT 1[0m
  [4;35;1mSQL (0.000070)[0m   [0mBEGIN[0m
  [4;36;1mSQL (0.000250)[0m   [0;1mINSERT INTO snippets (`name`, `body`) VALUES('blog_font_page_greeting', NULL)[0m
  [4;35;1mSQL (0.000280)[0m   [0mCOMMIT[0m
Rendering  within layouts/application
Rendering blog/index
Rendered /account/_user_bar (0.00499)
Rendered sidebar/_email_signup (0.00382)
Rendered /account/_login_or_register_dialog (0.01081)
Completed in 0.10082 (9 reqs/sec) | Rendering: 0.04779 (47%) | DB: 0.00624 (6%) | 200 OK [http://nikonthenumbers.com/]


Processing BlogController#index (for 74.104.79.219 at 2007-02-22 22:58:52) [GET]
  Session ID: 1efe16cb0133a711a4a8eecffc66d3e9
  Parameters: {"action"=>"index", "controller"=>"blog"}
  [4;36;1mGuest Columns (0.000252)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mSQL (0.000076)[0m   [0mBEGIN[0m
  [4;36;1mSQL (0.000296)[0m   [0;1mINSERT INTO users (`name`, `salt`, `user_number`, `postal_code`, `crypted_password`, `login_key`, `login_key_expires_at`, `type`, `gender`, `suspended`, `year_of_birth`, `bio`, `picture`, `verified`, `avg_rating`, `created_at`, `email`) VALUES(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Guest', 0, 0, NULL, NULL, NULL, 0, NULL, '2007-02-22 22:58:52', NULL)[0m
  [4;35;1mSQL (0.001060)[0m   [0mCOMMIT[0m
Cookie set: guest_id=2; path=/; expires=Sat, 23 Feb 2008 09:58:52 GMT
  [4;36;1mTopic Load (0.000373)[0m   [0;1mSELECT * FROM topics WHERE (approved = 1 && `start_date` <= '2007-02-22') AND (front_page_worthy = 1) ORDER BY `start_date` DESC LIMIT 5[0m
  [4;35;1mComment Columns (0.000228)[0m   [0mSHOW FIELDS FROM comments[0m
  [4;36;1mUser Columns (0.000188)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mComment Load Including Associations (0.000488)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 22:58:52') AND (reading_count > 0) ORDER BY reading_count DESC LIMIT 3[0m
  [4;36;1mComment Load Including Associations (0.000658)[0m   [0;1mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 22:58:52') AND (comments.avg_rating > 0) ORDER BY comments.avg_rating ASC LIMIT 3[0m
  [4;35;1mParticipant Columns (0.000236)[0m   [0mSHOW FIELDS FROM users[0m
  [4;36;1mParticipant Load (0.000339)[0m   [0;1mSELECT * FROM users WHERE (avg_rating > 0) AND ( (users.`type` = 'Participant' ) ) ORDER BY avg_rating ASC LIMIT 10[0m
  [4;35;1mComment Load Including Associations (0.000436)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by ORDER BY comments.created_at DESC LIMIT 3[0m
  [4;36;1mSnippet Columns (0.000199)[0m   [0;1mSHOW FIELDS FROM snippets[0m
  [4;35;1mSnippet Load (0.000269)[0m   [0mSELECT * FROM snippets WHERE (snippets.`name` = 'blog_font_page_greeting' ) LIMIT 1[0m
Rendering  within layouts/application
Rendering blog/index
Rendered /account/_user_bar (0.00028)
Rendered sidebar/_email_signup (0.00012)
Rendered /account/_login_or_register_dialog (0.00282)
Completed in 0.08940 (11 reqs/sec) | Rendering: 0.01291 (14%) | DB: 0.00510 (5%) | 200 OK [http://204.15.198.179/]


Processing BlogController#index (for 74.104.79.219 at 2007-02-22 22:58:56) [GET]
  Session ID: a6052bc643442d3cd2303437ecca8656
  Parameters: {"action"=>"index", "controller"=>"blog"}
  [4;36;1mGuest Columns (0.000259)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mSQL (0.000076)[0m   [0mBEGIN[0m
  [4;36;1mSQL (0.000291)[0m   [0;1mINSERT INTO users (`name`, `salt`, `user_number`, `postal_code`, `crypted_password`, `login_key`, `login_key_expires_at`, `type`, `gender`, `suspended`, `year_of_birth`, `bio`, `picture`, `verified`, `avg_rating`, `created_at`, `email`) VALUES(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Guest', 0, 0, NULL, NULL, NULL, 0, NULL, '2007-02-22 22:58:56', NULL)[0m
  [4;35;1mSQL (0.001536)[0m   [0mCOMMIT[0m
Cookie set: guest_id=3; path=/; expires=Sat, 23 Feb 2008 09:58:56 GMT
  [4;36;1mTopic Load (0.000363)[0m   [0;1mSELECT * FROM topics WHERE (approved = 1 && `start_date` <= '2007-02-22') AND (front_page_worthy = 1) ORDER BY `start_date` DESC LIMIT 5[0m
  [4;35;1mComment Columns (0.000173)[0m   [0mSHOW FIELDS FROM comments[0m
  [4;36;1mUser Columns (0.000180)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mComment Load Including Associations (0.000508)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 22:58:57') AND (reading_count > 0) ORDER BY reading_count DESC LIMIT 3[0m
  [4;36;1mComment Load Including Associations (0.000481)[0m   [0;1mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 22:58:57') AND (comments.avg_rating > 0) ORDER BY comments.avg_rating ASC LIMIT 3[0m
  [4;35;1mParticipant Columns (0.000250)[0m   [0mSHOW FIELDS FROM users[0m
  [4;36;1mParticipant Load (0.000355)[0m   [0;1mSELECT * FROM users WHERE (avg_rating > 0) AND ( (users.`type` = 'Participant' ) ) ORDER BY avg_rating ASC LIMIT 10[0m
  [4;35;1mComment Load Including Associations (0.000415)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by ORDER BY comments.created_at DESC LIMIT 3[0m
  [4;36;1mSnippet Columns (0.000179)[0m   [0;1mSHOW FIELDS FROM snippets[0m
  [4;35;1mSnippet Load (0.000250)[0m   [0mSELECT * FROM snippets WHERE (snippets.`name` = 'blog_font_page_greeting' ) LIMIT 1[0m
Rendering  within layouts/application
Rendering blog/index
Rendered /account/_user_bar (0.00028)
Rendered sidebar/_email_signup (0.00012)
Rendered /account/_login_or_register_dialog (0.00277)
Completed in 0.08928 (11 reqs/sec) | Rendering: 0.01295 (14%) | DB: 0.00532 (5%) | 200 OK [http://204.15.198.178/]


Processing BlogController#index (for 74.104.79.219 at 2007-02-22 22:59:08) [GET]
  Session ID: 1efe16cb0133a711a4a8eecffc66d3e9
  Parameters: {"action"=>"index", "controller"=>"blog"}
  [4;36;1mUser Columns (0.000261)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mUser Load (0.000347)[0m   [0mSELECT * FROM users WHERE (users.`id` = 2 ) LIMIT 1[0m
  [4;36;1mGuest Columns (0.000233)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mTopic Load (0.000358)[0m   [0mSELECT * FROM topics WHERE (approved = 1 && `start_date` <= '2007-02-22') AND (front_page_worthy = 1) ORDER BY `start_date` DESC LIMIT 5[0m
  [4;36;1mComment Columns (0.000180)[0m   [0;1mSHOW FIELDS FROM comments[0m
  [4;35;1mComment Load Including Associations (0.000518)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 22:59:09') AND (reading_count > 0) ORDER BY reading_count DESC LIMIT 3[0m
  [4;36;1mComment Load Including Associations (0.000487)[0m   [0;1mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 22:59:09') AND (comments.avg_rating > 0) ORDER BY comments.avg_rating ASC LIMIT 3[0m
  [4;35;1mParticipant Columns (0.000244)[0m   [0mSHOW FIELDS FROM users[0m
  [4;36;1mParticipant Load (0.000336)[0m   [0;1mSELECT * FROM users WHERE (avg_rating > 0) AND ( (users.`type` = 'Participant' ) ) ORDER BY avg_rating ASC LIMIT 10[0m
  [4;35;1mComment Load Including Associations (0.000435)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by ORDER BY comments.created_at DESC LIMIT 3[0m
  [4;36;1mSnippet Columns (0.000182)[0m   [0;1mSHOW FIELDS FROM snippets[0m
  [4;35;1mSnippet Load (0.000237)[0m   [0mSELECT * FROM snippets WHERE (snippets.`name` = 'blog_font_page_greeting' ) LIMIT 1[0m
Rendering  within layouts/application
Rendering blog/index
Rendered /account/_user_bar (0.00035)
Rendered sidebar/_email_signup (0.00024)
Rendered /account/_login_or_register_dialog (0.00295)
Completed in 0.16109 (6 reqs/sec) | Rendering: 0.09162 (56%) | DB: 0.00382 (2%) | 200 OK [http://204.15.198.179/]


Processing BlogController#index (for 74.104.79.219 at 2007-02-22 23:03:01) [GET]
  Session ID: 1efe16cb0133a711a4a8eecffc66d3e9
  Parameters: {"action"=>"index", "controller"=>"blog"}
  [4;36;1mUser Columns (0.000205)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mUser Load (0.000343)[0m   [0mSELECT * FROM users WHERE (users.`id` = 2 ) LIMIT 1[0m
  [4;36;1mGuest Columns (0.000233)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mTopic Load (0.000360)[0m   [0mSELECT * FROM topics WHERE (approved = 1 && `start_date` <= '2007-02-22') AND (front_page_worthy = 1) ORDER BY `start_date` DESC LIMIT 5[0m
  [4;36;1mComment Columns (0.000213)[0m   [0;1mSHOW FIELDS FROM comments[0m
  [4;35;1mComment Load Including Associations (0.000505)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:03:01') AND (reading_count > 0) ORDER BY reading_count DESC LIMIT 3[0m
  [4;36;1mComment Load Including Associations (0.000488)[0m   [0;1mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:03:01') AND (comments.avg_rating > 0) ORDER BY comments.avg_rating ASC LIMIT 3[0m
  [4;35;1mParticipant Columns (0.000182)[0m   [0mSHOW FIELDS FROM users[0m
  [4;36;1mParticipant Load (0.000335)[0m   [0;1mSELECT * FROM users WHERE (avg_rating > 0) AND ( (users.`type` = 'Participant' ) ) ORDER BY avg_rating ASC LIMIT 10[0m
  [4;35;1mComment Load Including Associations (0.000437)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by ORDER BY comments.created_at DESC LIMIT 3[0m
  [4;36;1mSnippet Columns (0.000188)[0m   [0;1mSHOW FIELDS FROM snippets[0m
  [4;35;1mSnippet Load (0.000260)[0m   [0mSELECT * FROM snippets WHERE (snippets.`name` = 'blog_font_page_greeting' ) LIMIT 1[0m
Rendering  within layouts/application
Rendering blog/index
Rendered /account/_user_bar (0.00241)
Rendered sidebar/_email_signup (0.00372)
Rendered /account/_login_or_register_dialog (0.01054)
Completed in 0.08470 (11 reqs/sec) | Rendering: 0.04282 (50%) | DB: 0.00375 (4%) | 200 OK [http://204.15.198.179/]


Processing BlogController#index (for 74.104.79.219 at 2007-02-22 23:22:42) [GET]
  Session ID: 1efe16cb0133a711a4a8eecffc66d3e9
  Parameters: {"action"=>"index", "controller"=>"blog"}
  [4;36;1mUser Columns (0.000192)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mUser Load (0.000352)[0m   [0mSELECT * FROM users WHERE (users.`id` = 2 ) LIMIT 1[0m
  [4;36;1mGuest Columns (0.000217)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mTopic Load (0.000373)[0m   [0mSELECT * FROM topics WHERE (approved = 1 && `start_date` <= '2007-02-22') AND (front_page_worthy = 1) ORDER BY `start_date` DESC LIMIT 5[0m
  [4;36;1mComment Columns (0.000201)[0m   [0;1mSHOW FIELDS FROM comments[0m
  [4;35;1mComment Load Including Associations (0.000514)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:22:42') AND (reading_count > 0) ORDER BY reading_count DESC LIMIT 3[0m
  [4;36;1mComment Load Including Associations (0.000488)[0m   [0;1mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:22:42') AND (comments.avg_rating > 0) ORDER BY comments.avg_rating ASC LIMIT 3[0m
  [4;35;1mParticipant Columns (0.000176)[0m   [0mSHOW FIELDS FROM users[0m
  [4;36;1mParticipant Load (0.000345)[0m   [0;1mSELECT * FROM users WHERE (avg_rating > 0) AND ( (users.`type` = 'Participant' ) ) ORDER BY avg_rating ASC LIMIT 10[0m
  [4;35;1mComment Load Including Associations (0.000428)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by ORDER BY comments.created_at DESC LIMIT 3[0m
  [4;36;1mSnippet Columns (0.000185)[0m   [0;1mSHOW FIELDS FROM snippets[0m
  [4;35;1mSnippet Load (0.000263)[0m   [0mSELECT * FROM snippets WHERE (snippets.`name` = 'blog_font_page_greeting' ) LIMIT 1[0m
Rendering  within layouts/application
Rendering blog/index
Rendered /account/_user_bar (0.01120)
Rendered sidebar/_email_signup (0.02018)
Rendered /account/_login_or_register_dialog (0.01085)
Completed in 0.21121 (4 reqs/sec) | Rendering: 0.13464 (63%) | DB: 0.00373 (1%) | 200 OK [http://204.15.198.179/]


Processing BlogController#index (for 74.104.79.219 at 2007-02-22 23:23:35) [GET]
  Session ID: 1efe16cb0133a711a4a8eecffc66d3e9
  Parameters: {"action"=>"index", "controller"=>"blog"}
  [4;36;1mUser Columns (0.000194)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mUser Load (0.000363)[0m   [0mSELECT * FROM users WHERE (users.`id` = 2 ) LIMIT 1[0m
  [4;36;1mGuest Columns (0.000224)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mTopic Load (0.000358)[0m   [0mSELECT * FROM topics WHERE (approved = 1 && `start_date` <= '2007-02-22') AND (front_page_worthy = 1) ORDER BY `start_date` DESC LIMIT 5[0m
  [4;36;1mComment Columns (0.000195)[0m   [0;1mSHOW FIELDS FROM comments[0m
  [4;35;1mComment Load Including Associations (0.000498)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:23:35') AND (reading_count > 0) ORDER BY reading_count DESC LIMIT 3[0m
  [4;36;1mComment Load Including Associations (0.000484)[0m   [0;1mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:23:35') AND (comments.avg_rating > 0) ORDER BY comments.avg_rating ASC LIMIT 3[0m
  [4;35;1mParticipant Columns (0.000166)[0m   [0mSHOW FIELDS FROM users[0m
  [4;36;1mParticipant Load (0.000323)[0m   [0;1mSELECT * FROM users WHERE (avg_rating > 0) AND ( (users.`type` = 'Participant' ) ) ORDER BY avg_rating ASC LIMIT 10[0m
  [4;35;1mComment Load Including Associations (0.000431)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by ORDER BY comments.created_at DESC LIMIT 3[0m
  [4;36;1mSnippet Columns (0.000184)[0m   [0;1mSHOW FIELDS FROM snippets[0m
  [4;35;1mSnippet Load (0.000258)[0m   [0mSELECT * FROM snippets WHERE (snippets.`name` = 'blog_font_page_greeting' ) LIMIT 1[0m
Rendering  within layouts/application
Rendering blog/index
Rendered /account/_user_bar (0.00239)
Rendered sidebar/_email_signup (0.00374)
Rendered /account/_login_or_register_dialog (0.01074)
Completed in 0.08342 (11 reqs/sec) | Rendering: 0.04307 (51%) | DB: 0.00368 (4%) | 200 OK [http://204.15.198.179/]


Processing BlogController#index (for 74.104.79.219 at 2007-02-22 23:23:38) [GET]
  Session ID: 1efe16cb0133a711a4a8eecffc66d3e9
  Parameters: {"action"=>"index", "controller"=>"blog"}
  [4;36;1mUser Columns (0.000248)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mUser Load (0.000350)[0m   [0mSELECT * FROM users WHERE (users.`id` = 2 ) LIMIT 1[0m
  [4;36;1mGuest Columns (0.000246)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mTopic Load (0.000354)[0m   [0mSELECT * FROM topics WHERE (approved = 1 && `start_date` <= '2007-02-22') AND (front_page_worthy = 1) ORDER BY `start_date` DESC LIMIT 5[0m
  [4;36;1mComment Columns (0.000232)[0m   [0;1mSHOW FIELDS FROM comments[0m
  [4;35;1mComment Load Including Associations (0.000499)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:23:38') AND (reading_count > 0) ORDER BY reading_count DESC LIMIT 3[0m
  [4;36;1mComment Load Including Associations (0.000473)[0m   [0;1mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:23:38') AND (comments.avg_rating > 0) ORDER BY comments.avg_rating ASC LIMIT 3[0m
  [4;35;1mParticipant Columns (0.000237)[0m   [0mSHOW FIELDS FROM users[0m
  [4;36;1mParticipant Load (0.000347)[0m   [0;1mSELECT * FROM users WHERE (avg_rating > 0) AND ( (users.`type` = 'Participant' ) ) ORDER BY avg_rating ASC LIMIT 10[0m
  [4;35;1mComment Load Including Associations (0.000416)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by ORDER BY comments.created_at DESC LIMIT 3[0m
  [4;36;1mSnippet Columns (0.000181)[0m   [0;1mSHOW FIELDS FROM snippets[0m
  [4;35;1mSnippet Load (0.000252)[0m   [0mSELECT * FROM snippets WHERE (snippets.`name` = 'blog_font_page_greeting' ) LIMIT 1[0m
Rendering  within layouts/application
Rendering blog/index
Rendered /account/_user_bar (0.00029)
Rendered sidebar/_email_signup (0.00012)
Rendered /account/_login_or_register_dialog (0.00285)
Completed in 0.08093 (12 reqs/sec) | Rendering: 0.01321 (16%) | DB: 0.00383 (4%) | 200 OK [http://204.15.198.179/]


Processing BlogController#index (for 74.104.79.219 at 2007-02-22 23:23:45) [GET]
  Session ID: 1efe16cb0133a711a4a8eecffc66d3e9
  Parameters: {"action"=>"index", "controller"=>"blog"}
  [4;36;1mUser Columns (0.000206)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mUser Load (0.000374)[0m   [0mSELECT * FROM users WHERE (users.`id` = 2 ) LIMIT 1[0m
  [4;36;1mGuest Columns (0.000243)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mTopic Load (0.000336)[0m   [0mSELECT * FROM topics WHERE (approved = 1 && `start_date` <= '2007-02-22') AND (front_page_worthy = 1) ORDER BY `start_date` DESC LIMIT 5[0m
  [4;36;1mComment Columns (0.000198)[0m   [0;1mSHOW FIELDS FROM comments[0m
  [4;35;1mComment Load Including Associations (0.000513)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:23:46') AND (reading_count > 0) ORDER BY reading_count DESC LIMIT 3[0m
  [4;36;1mComment Load Including Associations (0.000486)[0m   [0;1mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:23:46') AND (comments.avg_rating > 0) ORDER BY comments.avg_rating ASC LIMIT 3[0m
  [4;35;1mParticipant Columns (0.000187)[0m   [0mSHOW FIELDS FROM users[0m
  [4;36;1mParticipant Load (0.000339)[0m   [0;1mSELECT * FROM users WHERE (avg_rating > 0) AND ( (users.`type` = 'Participant' ) ) ORDER BY avg_rating ASC LIMIT 10[0m
  [4;35;1mComment Load Including Associations (0.000425)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by ORDER BY comments.created_at DESC LIMIT 3[0m
  [4;36;1mSnippet Columns (0.000187)[0m   [0;1mSHOW FIELDS FROM snippets[0m
  [4;35;1mSnippet Load (0.000260)[0m   [0mSELECT * FROM snippets WHERE (snippets.`name` = 'blog_font_page_greeting' ) LIMIT 1[0m
Rendering  within layouts/application
Rendering blog/index
Rendered /account/_user_bar (0.00237)
Rendered sidebar/_email_signup (0.00375)
Rendered /account/_login_or_register_dialog (0.01065)
Completed in 0.08519 (11 reqs/sec) | Rendering: 0.04285 (50%) | DB: 0.00375 (4%) | 200 OK [http://204.15.198.179/]


Processing BlogController#index (for 74.104.79.219 at 2007-02-22 23:23:47) [GET]
  Session ID: 1efe16cb0133a711a4a8eecffc66d3e9
  Parameters: {"action"=>"index", "controller"=>"blog"}
  [4;36;1mUser Columns (0.000259)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mUser Load (0.000357)[0m   [0mSELECT * FROM users WHERE (users.`id` = 2 ) LIMIT 1[0m
  [4;36;1mGuest Columns (0.000242)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mTopic Load (0.000360)[0m   [0mSELECT * FROM topics WHERE (approved = 1 && `start_date` <= '2007-02-22') AND (front_page_worthy = 1) ORDER BY `start_date` DESC LIMIT 5[0m
  [4;36;1mComment Columns (0.000216)[0m   [0;1mSHOW FIELDS FROM comments[0m
  [4;35;1mComment Load Including Associations (0.000515)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:23:47') AND (reading_count > 0) ORDER BY reading_count DESC LIMIT 3[0m
  [4;36;1mComment Load Including Associations (0.000478)[0m   [0;1mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:23:47') AND (comments.avg_rating > 0) ORDER BY comments.avg_rating ASC LIMIT 3[0m
  [4;35;1mParticipant Columns (0.000245)[0m   [0mSHOW FIELDS FROM users[0m
  [4;36;1mParticipant Load (0.000343)[0m   [0;1mSELECT * FROM users WHERE (avg_rating > 0) AND ( (users.`type` = 'Participant' ) ) ORDER BY avg_rating ASC LIMIT 10[0m
  [4;35;1mComment Load Including Associations (0.000425)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by ORDER BY comments.created_at DESC LIMIT 3[0m
  [4;36;1mSnippet Columns (0.000180)[0m   [0;1mSHOW FIELDS FROM snippets[0m
  [4;35;1mSnippet Load (0.000246)[0m   [0mSELECT * FROM snippets WHERE (snippets.`name` = 'blog_font_page_greeting' ) LIMIT 1[0m
Rendering  within layouts/application
Rendering blog/index
Rendered /account/_user_bar (0.00028)
Rendered sidebar/_email_signup (0.00012)
Rendered /account/_login_or_register_dialog (0.00287)
Completed in 0.08091 (12 reqs/sec) | Rendering: 0.01324 (16%) | DB: 0.00387 (4%) | 200 OK [http://204.15.198.179/]


Processing BlogController#index (for 74.104.79.219 at 2007-02-22 23:23:49) [GET]
  Session ID: 1efe16cb0133a711a4a8eecffc66d3e9
  Parameters: {"action"=>"index", "controller"=>"blog"}
  [4;36;1mUser Columns (0.000238)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mUser Load (0.000353)[0m   [0mSELECT * FROM users WHERE (users.`id` = 2 ) LIMIT 1[0m
  [4;36;1mGuest Columns (0.000262)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mTopic Load (0.000358)[0m   [0mSELECT * FROM topics WHERE (approved = 1 && `start_date` <= '2007-02-22') AND (front_page_worthy = 1) ORDER BY `start_date` DESC LIMIT 5[0m
  [4;36;1mComment Columns (0.000232)[0m   [0;1mSHOW FIELDS FROM comments[0m
  [4;35;1mComment Load Including Associations (0.000513)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:23:49') AND (reading_count > 0) ORDER BY reading_count DESC LIMIT 3[0m
  [4;36;1mComment Load Including Associations (0.000497)[0m   [0;1mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:23:49') AND (comments.avg_rating > 0) ORDER BY comments.avg_rating ASC LIMIT 3[0m
  [4;35;1mParticipant Columns (0.000242)[0m   [0mSHOW FIELDS FROM users[0m
  [4;36;1mParticipant Load (0.000338)[0m   [0;1mSELECT * FROM users WHERE (avg_rating > 0) AND ( (users.`type` = 'Participant' ) ) ORDER BY avg_rating ASC LIMIT 10[0m
  [4;35;1mComment Load Including Associations (0.000433)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by ORDER BY comments.created_at DESC LIMIT 3[0m
  [4;36;1mSnippet Columns (0.000184)[0m   [0;1mSHOW FIELDS FROM snippets[0m
  [4;35;1mSnippet Load (0.000248)[0m   [0mSELECT * FROM snippets WHERE (snippets.`name` = 'blog_font_page_greeting' ) LIMIT 1[0m
Rendering  within layouts/application
Rendering blog/index
Rendered /account/_user_bar (0.00028)
Rendered sidebar/_email_signup (0.00013)
Rendered /account/_login_or_register_dialog (0.00286)
Completed in 0.08172 (12 reqs/sec) | Rendering: 0.01329 (16%) | DB: 0.00390 (4%) | 200 OK [http://204.15.198.179/]


Processing BlogController#index (for 74.104.79.219 at 2007-02-22 23:23:51) [GET]
  Session ID: 1efe16cb0133a711a4a8eecffc66d3e9
  Parameters: {"action"=>"index", "controller"=>"blog"}
  [4;36;1mUser Columns (0.000236)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mUser Load (0.000354)[0m   [0mSELECT * FROM users WHERE (users.`id` = 2 ) LIMIT 1[0m
  [4;36;1mGuest Columns (0.000233)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mTopic Load (0.000361)[0m   [0mSELECT * FROM topics WHERE (approved = 1 && `start_date` <= '2007-02-22') AND (front_page_worthy = 1) ORDER BY `start_date` DESC LIMIT 5[0m
  [4;36;1mComment Columns (0.000236)[0m   [0;1mSHOW FIELDS FROM comments[0m
  [4;35;1mComment Load Including Associations (0.000518)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:23:51') AND (reading_count > 0) ORDER BY reading_count DESC LIMIT 3[0m
  [4;36;1mComment Load Including Associations (0.000485)[0m   [0;1mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:23:51') AND (comments.avg_rating > 0) ORDER BY comments.avg_rating ASC LIMIT 3[0m
  [4;35;1mParticipant Columns (0.000251)[0m   [0mSHOW FIELDS FROM users[0m
  [4;36;1mParticipant Load (0.000342)[0m   [0;1mSELECT * FROM users WHERE (avg_rating > 0) AND ( (users.`type` = 'Participant' ) ) ORDER BY avg_rating ASC LIMIT 10[0m
  [4;35;1mComment Load Including Associations (0.000419)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by ORDER BY comments.created_at DESC LIMIT 3[0m
  [4;36;1mSnippet Columns (0.000185)[0m   [0;1mSHOW FIELDS FROM snippets[0m
  [4;35;1mSnippet Load (0.000254)[0m   [0mSELECT * FROM snippets WHERE (snippets.`name` = 'blog_font_page_greeting' ) LIMIT 1[0m
Rendering  within layouts/application
Rendering blog/index
Rendered /account/_user_bar (0.00029)
Rendered sidebar/_email_signup (0.00012)
Rendered /account/_login_or_register_dialog (0.00291)
Completed in 0.08152 (12 reqs/sec) | Rendering: 0.01338 (16%) | DB: 0.00387 (4%) | 200 OK [http://204.15.198.179/]


Processing BlogController#index (for 74.104.79.219 at 2007-02-22 23:23:52) [GET]
  Session ID: 1efe16cb0133a711a4a8eecffc66d3e9
  Parameters: {"action"=>"index", "controller"=>"blog"}
  [4;36;1mUser Columns (0.000257)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mUser Load (0.000359)[0m   [0mSELECT * FROM users WHERE (users.`id` = 2 ) LIMIT 1[0m
  [4;36;1mGuest Columns (0.000227)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mTopic Load (0.000358)[0m   [0mSELECT * FROM topics WHERE (approved = 1 && `start_date` <= '2007-02-22') AND (front_page_worthy = 1) ORDER BY `start_date` DESC LIMIT 5[0m
  [4;36;1mComment Columns (0.000236)[0m   [0;1mSHOW FIELDS FROM comments[0m
  [4;35;1mComment Load Including Associations (0.000519)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:23:52') AND (reading_count > 0) ORDER BY reading_count DESC LIMIT 3[0m
  [4;36;1mComment Load Including Associations (0.000481)[0m   [0;1mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:23:52') AND (comments.avg_rating > 0) ORDER BY comments.avg_rating ASC LIMIT 3[0m
  [4;35;1mParticipant Columns (0.000261)[0m   [0mSHOW FIELDS FROM users[0m
  [4;36;1mParticipant Load (0.000343)[0m   [0;1mSELECT * FROM users WHERE (avg_rating > 0) AND ( (users.`type` = 'Participant' ) ) ORDER BY avg_rating ASC LIMIT 10[0m
  [4;35;1mComment Load Including Associations (0.000429)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by ORDER BY comments.created_at DESC LIMIT 3[0m
  [4;36;1mSnippet Columns (0.000189)[0m   [0;1mSHOW FIELDS FROM snippets[0m
  [4;35;1mSnippet Load (0.000253)[0m   [0mSELECT * FROM snippets WHERE (snippets.`name` = 'blog_font_page_greeting' ) LIMIT 1[0m
Rendering  within layouts/application
Rendering blog/index
Rendered /account/_user_bar (0.00030)
Rendered sidebar/_email_signup (0.00012)
Rendered /account/_login_or_register_dialog (0.00286)
Completed in 0.08172 (12 reqs/sec) | Rendering: 0.01329 (16%) | DB: 0.00391 (4%) | 200 OK [http://204.15.198.179/]


Processing BlogController#index (for 74.104.79.219 at 2007-02-22 23:23:53) [GET]
  Session ID: 1efe16cb0133a711a4a8eecffc66d3e9
  Parameters: {"action"=>"index", "controller"=>"blog"}
  [4;36;1mUser Columns (0.000241)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mUser Load (0.000368)[0m   [0mSELECT * FROM users WHERE (users.`id` = 2 ) LIMIT 1[0m
  [4;36;1mGuest Columns (0.000231)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mTopic Load (0.000364)[0m   [0mSELECT * FROM topics WHERE (approved = 1 && `start_date` <= '2007-02-22') AND (front_page_worthy = 1) ORDER BY `start_date` DESC LIMIT 5[0m
  [4;36;1mComment Columns (0.000222)[0m   [0;1mSHOW FIELDS FROM comments[0m
  [4;35;1mComment Load Including Associations (0.000514)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:23:53') AND (reading_count > 0) ORDER BY reading_count DESC LIMIT 3[0m
  [4;36;1mComment Load Including Associations (0.000475)[0m   [0;1mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:23:53') AND (comments.avg_rating > 0) ORDER BY comments.avg_rating ASC LIMIT 3[0m
  [4;35;1mParticipant Columns (0.000249)[0m   [0mSHOW FIELDS FROM users[0m
  [4;36;1mParticipant Load (0.000343)[0m   [0;1mSELECT * FROM users WHERE (avg_rating > 0) AND ( (users.`type` = 'Participant' ) ) ORDER BY avg_rating ASC LIMIT 10[0m
  [4;35;1mComment Load Including Associations (0.000421)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by ORDER BY comments.created_at DESC LIMIT 3[0m
  [4;36;1mSnippet Columns (0.000186)[0m   [0;1mSHOW FIELDS FROM snippets[0m
  [4;35;1mSnippet Load (0.000238)[0m   [0mSELECT * FROM snippets WHERE (snippets.`name` = 'blog_font_page_greeting' ) LIMIT 1[0m
Rendering  within layouts/application
Rendering blog/index
Rendered /account/_user_bar (0.00031)
Rendered sidebar/_email_signup (0.00016)
Rendered /account/_login_or_register_dialog (0.00307)
Completed in 0.15807 (6 reqs/sec) | Rendering: 0.09074 (57%) | DB: 0.00385 (2%) | 200 OK [http://204.15.198.179/]


Processing BlogController#index (for 74.104.79.219 at 2007-02-22 23:24:09) [GET]
  Session ID: 1efe16cb0133a711a4a8eecffc66d3e9
  Parameters: {"action"=>"index", "controller"=>"blog"}
  [4;36;1mUser Columns (0.000259)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mUser Load (0.000337)[0m   [0mSELECT * FROM users WHERE (users.`id` = 2 ) LIMIT 1[0m
  [4;36;1mGuest Columns (0.000244)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mTopic Load (0.000363)[0m   [0mSELECT * FROM topics WHERE (approved = 1 && `start_date` <= '2007-02-22') AND (front_page_worthy = 1) ORDER BY `start_date` DESC LIMIT 5[0m
  [4;36;1mComment Columns (0.000227)[0m   [0;1mSHOW FIELDS FROM comments[0m
  [4;35;1mComment Load Including Associations (0.000523)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:24:09') AND (reading_count > 0) ORDER BY reading_count DESC LIMIT 3[0m
  [4;36;1mComment Load Including Associations (0.000497)[0m   [0;1mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:24:09') AND (comments.avg_rating > 0) ORDER BY comments.avg_rating ASC LIMIT 3[0m
  [4;35;1mParticipant Columns (0.000254)[0m   [0mSHOW FIELDS FROM users[0m
  [4;36;1mParticipant Load (0.000355)[0m   [0;1mSELECT * FROM users WHERE (avg_rating > 0) AND ( (users.`type` = 'Participant' ) ) ORDER BY avg_rating ASC LIMIT 10[0m
  [4;35;1mComment Load Including Associations (0.000448)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by ORDER BY comments.created_at DESC LIMIT 3[0m
  [4;36;1mSnippet Columns (0.000187)[0m   [0;1mSHOW FIELDS FROM snippets[0m
  [4;35;1mSnippet Load (0.000251)[0m   [0mSELECT * FROM snippets WHERE (snippets.`name` = 'blog_font_page_greeting' ) LIMIT 1[0m
Rendering  within layouts/application
Rendering blog/index
Rendered /account/_user_bar (0.00029)
Rendered sidebar/_email_signup (0.00014)
Rendered /account/_login_or_register_dialog (0.00297)
Completed in 0.16319 (6 reqs/sec) | Rendering: 0.01386 (8%) | DB: 0.00394 (2%) | 200 OK [http://204.15.198.179/]


Processing BlogController#index (for 74.104.79.219 at 2007-02-22 23:24:11) [GET]
  Session ID: 1efe16cb0133a711a4a8eecffc66d3e9
  Parameters: {"action"=>"index", "controller"=>"blog"}
  [4;36;1mUser Columns (0.000244)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mUser Load (0.000356)[0m   [0mSELECT * FROM users WHERE (users.`id` = 2 ) LIMIT 1[0m
  [4;36;1mGuest Columns (0.000238)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mTopic Load (0.000430)[0m   [0mSELECT * FROM topics WHERE (approved = 1 && `start_date` <= '2007-02-22') AND (front_page_worthy = 1) ORDER BY `start_date` DESC LIMIT 5[0m
  [4;36;1mComment Columns (0.000214)[0m   [0;1mSHOW FIELDS FROM comments[0m
  [4;35;1mComment Load Including Associations (0.000539)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:24:11') AND (reading_count > 0) ORDER BY reading_count DESC LIMIT 3[0m
  [4;36;1mComment Load Including Associations (0.000492)[0m   [0;1mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:24:11') AND (comments.avg_rating > 0) ORDER BY comments.avg_rating ASC LIMIT 3[0m
  [4;35;1mParticipant Columns (0.000269)[0m   [0mSHOW FIELDS FROM users[0m
  [4;36;1mParticipant Load (0.000341)[0m   [0;1mSELECT * FROM users WHERE (avg_rating > 0) AND ( (users.`type` = 'Participant' ) ) ORDER BY avg_rating ASC LIMIT 10[0m
  [4;35;1mComment Load Including Associations (0.000439)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by ORDER BY comments.created_at DESC LIMIT 3[0m
  [4;36;1mSnippet Columns (0.000185)[0m   [0;1mSHOW FIELDS FROM snippets[0m
  [4;35;1mSnippet Load (0.000263)[0m   [0mSELECT * FROM snippets WHERE (snippets.`name` = 'blog_font_page_greeting' ) LIMIT 1[0m
Rendering  within layouts/application
Rendering blog/index
Rendered /account/_user_bar (0.00032)
Rendered sidebar/_email_signup (0.00012)
Rendered /account/_login_or_register_dialog (0.07348)
Completed in 0.15292 (6 reqs/sec) | Rendering: 0.08413 (55%) | DB: 0.00401 (2%) | 200 OK [http://204.15.198.179/]


Processing BlogController#index (for 74.104.79.219 at 2007-02-22 23:24:12) [GET]
  Session ID: 1efe16cb0133a711a4a8eecffc66d3e9
  Parameters: {"action"=>"index", "controller"=>"blog"}
  [4;36;1mUser Columns (0.000242)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mUser Load (0.000364)[0m   [0mSELECT * FROM users WHERE (users.`id` = 2 ) LIMIT 1[0m
  [4;36;1mGuest Columns (0.000234)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mTopic Load (0.000361)[0m   [0mSELECT * FROM topics WHERE (approved = 1 && `start_date` <= '2007-02-22') AND (front_page_worthy = 1) ORDER BY `start_date` DESC LIMIT 5[0m
  [4;36;1mComment Columns (0.000229)[0m   [0;1mSHOW FIELDS FROM comments[0m
  [4;35;1mComment Load Including Associations (0.000522)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:24:12') AND (reading_count > 0) ORDER BY reading_count DESC LIMIT 3[0m
  [4;36;1mComment Load Including Associations (0.000503)[0m   [0;1mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:24:12') AND (comments.avg_rating > 0) ORDER BY comments.avg_rating ASC LIMIT 3[0m
  [4;35;1mParticipant Columns (0.000287)[0m   [0mSHOW FIELDS FROM users[0m
  [4;36;1mParticipant Load (0.000354)[0m   [0;1mSELECT * FROM users WHERE (avg_rating > 0) AND ( (users.`type` = 'Participant' ) ) ORDER BY avg_rating ASC LIMIT 10[0m
  [4;35;1mComment Load Including Associations (0.000439)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by ORDER BY comments.created_at DESC LIMIT 3[0m
  [4;36;1mSnippet Columns (0.000190)[0m   [0;1mSHOW FIELDS FROM snippets[0m
  [4;35;1mSnippet Load (0.000273)[0m   [0mSELECT * FROM snippets WHERE (snippets.`name` = 'blog_font_page_greeting' ) LIMIT 1[0m
Rendering  within layouts/application
Rendering blog/index
Rendered /account/_user_bar (0.00032)
Rendered sidebar/_email_signup (0.00013)
Rendered /account/_login_or_register_dialog (0.00299)
Completed in 0.16309 (6 reqs/sec) | Rendering: 0.01381 (8%) | DB: 0.00400 (2%) | 200 OK [http://204.15.198.179/]


Processing BlogController#index (for 74.104.79.219 at 2007-02-22 23:24:14) [GET]
  Session ID: 1efe16cb0133a711a4a8eecffc66d3e9
  Parameters: {"action"=>"index", "controller"=>"blog"}
  [4;36;1mUser Columns (0.000274)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mUser Load (0.000347)[0m   [0mSELECT * FROM users WHERE (users.`id` = 2 ) LIMIT 1[0m
  [4;36;1mGuest Columns (0.000232)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mTopic Load (0.000362)[0m   [0mSELECT * FROM topics WHERE (approved = 1 && `start_date` <= '2007-02-22') AND (front_page_worthy = 1) ORDER BY `start_date` DESC LIMIT 5[0m
  [4;36;1mComment Columns (0.000239)[0m   [0;1mSHOW FIELDS FROM comments[0m
  [4;35;1mComment Load Including Associations (0.000538)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:24:14') AND (reading_count > 0) ORDER BY reading_count DESC LIMIT 3[0m
  [4;36;1mComment Load Including Associations (0.000487)[0m   [0;1mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-15 23:24:14') AND (comments.avg_rating > 0) ORDER BY comments.avg_rating ASC LIMIT 3[0m
  [4;35;1mParticipant Columns (0.000252)[0m   [0mSHOW FIELDS FROM users[0m
  [4;36;1mParticipant Load (0.005503)[0m   [0;1mSELECT * FROM users WHERE (avg_rating > 0) AND ( (users.`type` = 'Participant' ) ) ORDER BY avg_rating ASC LIMIT 10[0m
  [4;35;1mComment Load Including Associations (0.000704)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by ORDER BY comments.created_at DESC LIMIT 3[0m
  [4;36;1mSnippet Columns (0.000184)[0m   [0;1mSHOW FIELDS FROM snippets[0m
  [4;35;1mSnippet Load (0.000267)[0m   [0mSELECT * FROM snippets WHERE (snippets.`name` = 'blog_font_page_greeting' ) LIMIT 1[0m
Rendering  within layouts/application
Rendering blog/index
Rendered /account/_user_bar (0.00031)
Rendered sidebar/_email_signup (0.00017)
Rendered /account/_login_or_register_dialog (0.00312)
Completed in 0.15894 (6 reqs/sec) | Rendering: 0.01453 (9%) | DB: 0.00939 (5%) | 200 OK [http://204.15.198.179/]


Processing BlogController#index (for 70.48.43.208 at 2007-02-23 08:09:01) [GET]
  Session ID: 8f2ff113dd2e81dac103fe79cbdaaf6a
  Parameters: {"action"=>"index", "controller"=>"blog"}
  [4;36;1mGuest Columns (0.000246)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mSQL (0.000084)[0m   [0mBEGIN[0m
  [4;36;1mSQL (0.007260)[0m   [0;1mINSERT INTO users (`name`, `salt`, `user_number`, `postal_code`, `crypted_password`, `login_key`, `login_key_expires_at`, `type`, `gender`, `suspended`, `year_of_birth`, `bio`, `picture`, `verified`, `avg_rating`, `created_at`, `email`) VALUES(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Guest', 0, 0, NULL, NULL, NULL, 0, NULL, '2007-02-23 08:09:01', NULL)[0m
  [4;35;1mSQL (0.001443)[0m   [0mCOMMIT[0m
Cookie set: guest_id=4; path=/; expires=Sat, 23 Feb 2008 19:09:01 GMT
  [4;36;1mTopic Load (0.000774)[0m   [0;1mSELECT * FROM topics WHERE (approved = 1 && `start_date` <= '2007-02-23') AND (front_page_worthy = 1) ORDER BY `start_date` DESC LIMIT 5[0m
  [4;35;1mComment Columns (0.000238)[0m   [0mSHOW FIELDS FROM comments[0m
  [4;36;1mUser Columns (0.000179)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mComment Load Including Associations (0.009835)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-16 08:09:01') AND (reading_count > 0) ORDER BY reading_count DESC LIMIT 3[0m
  [4;36;1mComment Load Including Associations (0.000523)[0m   [0;1mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by WHERE (comments.created_at > '2007-02-16 08:09:01') AND (comments.avg_rating > 0) ORDER BY comments.avg_rating ASC LIMIT 3[0m
  [4;35;1mParticipant Columns (0.000241)[0m   [0mSHOW FIELDS FROM users[0m
  [4;36;1mParticipant Load (0.000364)[0m   [0;1mSELECT * FROM users WHERE (avg_rating > 0) AND ( (users.`type` = 'Participant' ) ) ORDER BY avg_rating ASC LIMIT 10[0m
  [4;35;1mComment Load Including Associations (0.000446)[0m   [0mSELECT comments.`id` AS t0_r0, comments.`body` AS t0_r1, comments.`created_by` AS t0_r2, comments.`created_at` AS t0_r3, comments.`topic_id` AS t0_r4, comments.`root_id` AS t0_r5, comments.`parent_id` AS t0_r6, comments.`lft` AS t0_r7, comments.`rgt` AS t0_r8, comments.`depth` AS t0_r9, comments.`removed` AS t0_r10, comments.`word_count` AS t0_r11, comments.`reading_count` AS t0_r12, comments.`avg_rating` AS t0_r13, users.`id` AS t1_r0, users.`name` AS t1_r1, users.`type` AS t1_r2, users.`email` AS t1_r3, users.`crypted_password` AS t1_r4, users.`salt` AS t1_r5, users.`created_at` AS t1_r6, users.`bio` AS t1_r7, users.`picture` AS t1_r8, users.`user_number` AS t1_r9, users.`year_of_birth` AS t1_r10, users.`gender` AS t1_r11, users.`postal_code` AS t1_r12, users.`login_key` AS t1_r13, users.`verified` AS t1_r14, users.`login_key_expires_at` AS t1_r15, users.`avg_rating` AS t1_r16, users.`suspended` AS t1_r17 FROM comments LEFT OUTER JOIN users ON users.id = comments.created_by ORDER BY comments.created_at DESC LIMIT 3[0m
  [4;36;1mSnippet Columns (0.000194)[0m   [0;1mSHOW FIELDS FROM snippets[0m
  [4;35;1mSnippet Load (0.000822)[0m   [0mSELECT * FROM snippets WHERE (snippets.`name` = 'blog_font_page_greeting' ) LIMIT 1[0m
Rendering  within layouts/application
Rendering blog/index
Rendered /account/_user_bar (0.00033)
Rendered sidebar/_email_signup (0.00016)
Rendered /account/_login_or_register_dialog (0.00316)
Completed in 0.18273 (5 reqs/sec) | Rendering: 0.01464 (8%) | DB: 0.02265 (12%) | 200 OK [http://204.15.198.179/]
  [4;36;1mTopic Columns (0.000339)[0m   [0;1mSHOW FIELDS FROM topics[0m
  [4;35;1mSQL (0.000232)[0m   [0mSELECT count(*) AS count_all FROM topics [0m
  [4;36;1mUser Columns (0.000190)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mSQL (0.000207)[0m   [0mSELECT count(*) AS count_all FROM users [0m
  [4;36;1mUser Load (0.000342)[0m   [0;1mSELECT * FROM users [0m
  [4;35;1mAdmin Columns (0.000194)[0m   [0mSHOW FIELDS FROM users[0m
  [4;36;1mSQL (0.000091)[0m   [0;1mBEGIN[0m
  [4;35;1mAdmin Load (0.000580)[0m   [0mSELECT * FROM users WHERE (users.email = 'iogadmin@sesresearch.com') AND ( (users.`type` = 'Admin' ) ) LIMIT 1[0m
  [4;36;1mSQL (0.000271)[0m   [0;1mINSERT INTO users (`name`, `salt`, `user_number`, `postal_code`, `crypted_password`, `login_key`, `login_key_expires_at`, `type`, `gender`, `suspended`, `year_of_birth`, `bio`, `picture`, `verified`, `avg_rating`, `created_at`, `email`) VALUES(NULL, '0d11e7475f8bee480cb35de3c4c05bca3af62bd1', NULL, NULL, 'kuM3DZIOrTeUdgxA+SqhzQ==\n', NULL, NULL, 'Admin', 0, 0, NULL, NULL, NULL, 0, NULL, '2007-02-23 11:47:10', 'iogadmin@sesresearch.com')[0m
  [4;35;1mAdmin Update (0.000369)[0m   [0mUPDATE users SET `created_at` = '2007-02-23 11:47:10', `year_of_birth` = NULL, `login_key_expires_at` = NULL, `crypted_password` = 'kuM3DZIOrTeUdgxA+SqhzQ==\n', `picture` = NULL, `bio` = NULL, `gender` = 0, `user_number` = NULL, `salt` = '0d11e7475f8bee480cb35de3c4c05bca3af62bd1', `avg_rating` = NULL, `login_key` = 'bf21d0ca4513f3d66e88a9c7521628f04411a84e', `verified` = 0, `type` = 'Admin', `email` = 'iogadmin@sesresearch.com', `suspended` = 0, `postal_code` = NULL, `name` = NULL WHERE id = 5[0m
  [4;36;1mSettings Load (0.010764)[0m   [0;1mSELECT * FROM settings WHERE (var = 'admin_email') LIMIT 1[0m
  [4;35;1mSettings Load (0.000192)[0m   [0mSELECT * FROM settings WHERE (var = 'email_subject_label') LIMIT 1[0m
  [4;36;1mSettings Load (0.000141)[0m   [0;1mSELECT * FROM settings WHERE (var = 'application_url') LIMIT 1[0m
Sent mail:
 Date: Fri, 23 Feb 2007 11:47:10 -0500
To: iogadmin@sesresearch.com
Bcc: pierre.killeen@gmail.com, lee@omara.ca
Subject: [] Thank you for registering
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8

Your account has been created.

  Email: iogadmin@sesresearch.com
  Password: iogadmin

Please visit this url to verify your account:

  /verify/bf21d0ca4513f3d66e88a9c7521628f04411a84e
  
  [4;35;1mSQL (0.002190)[0m   [0mCOMMIT[0m
  [4;36;1mAdmin Load (0.000475)[0m   [0;1mSELECT * FROM users WHERE (users.email = 'iogadmin@sesresearch.com' AND users.id <> 5) AND ( (users.`type` = 'Admin' ) ) LIMIT 1[0m
  [4;36;1mAdmin Columns (0.000324)[0m   [0;1mSHOW FIELDS FROM users[0m
  [4;35;1mAdmin Load (0.000376)[0m   [0mSELECT * FROM users WHERE ( (users.`type` = 'Admin' ) ) LIMIT 1[0m
  [4;36;1mSQL (0.000126)[0m   [0;1mBEGIN[0m
  [4;35;1mAdmin Load (0.000445)[0m   [0mSELECT * FROM users WHERE (users.email = 'iogadmin@sesresearch.com' AND users.id <> 5) AND ( (users.`type` = 'Admin' ) ) LIMIT 1[0m
  [4;36;1mAdmin Update (0.000349)[0m   [0;1mUPDATE users SET `created_at` = '2007-02-23 11:47:10', `year_of_birth` = NULL, `login_key_expires_at` = NULL, `crypted_password` = 'kuM3DZIOrTeUdgxA+SqhzQ==\n', `picture` = NULL, `bio` = NULL, `gender` = 0, `user_number` = NULL, `salt` = '0d11e7475f8bee480cb35de3c4c05bca3af62bd1', `avg_rating` = NULL, `login_key` = 'bf21d0ca4513f3d66e88a9c7521628f04411a84e', `verified` = 1, `type` = 'Admin', `email` = 'iogadmin@sesresearch.com', `suspended` = 0, `postal_code` = NULL, `name` = NULL WHERE id = 5[0m
  [4;35;1mSQL (0.001557)[0m   [0mCOMMIT[0m
