spec/log/test.log in periodic_counter-0.1.3 vs spec/log/test.log in periodic_counter-0.1.4

- old
+ new

@@ -12442,5 +12442,4130 @@ counter_last_2_days: 4 ', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_last_2_days = 0 WHERE id = 1  Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 + SQL (22.5ms) SHOW TABLES + SQL (51.7ms) SELECT version FROM schema_migrations + SQL (0.4ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (163.1ms) DROP TABLE `counters` + SQL (0.8ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.4ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (3.8ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (1.0ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) BEGIN + Counter Create (0.0ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL) + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_last_2_days = 1 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-22 00:00:00 Z +counter_last_2_days: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.4ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 3\ncounter_last_2_days_at: 2010-06-22 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_last_day: 4 +counter_last_day_at: 2010-06-23 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-23 00:00:00 Z +counter_last_2_days: 4 +', counter_last_day = 0, counter_last_wednesday = 1, counter_last_tuesday = 1, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (35.5ms) SHOW TABLES + SQL (0.4ms) SELECT version FROM schema_migrations + SQL (0.4ms) SHOW TABLES + SQL (0.3ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.4ms) SHOW TABLES + SQL (0.3ms) SELECT version FROM schema_migrations + SQL (0.4ms) SHOW TABLES + SQL (8.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (29.9ms) DROP TABLE `counters` + SQL (21.6ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.5ms) SHOW TABLES + SQL (0.3ms) SELECT version FROM schema_migrations + SQL (0.4ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (2.2ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.6ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) BEGIN + Counter Create (0.0ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL) + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_last_2_days = 1 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-22 00:00:00 Z +counter_last_2_days: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (1.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.4ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 3\ncounter_last_2_days_at: 2010-06-22 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (93.4ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_last_day: 4 +counter_last_day_at: 2010-06-23 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-23 00:00:00 Z +counter_last_2_days: 4 +', counter_last_day = 0, counter_last_wednesday = 1, counter_last_tuesday = 1, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (30.4ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (9.6ms) DROP TABLE `counters` + SQL (0.6ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.3ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (26.2ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.6ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) BEGIN + Counter Create (0.0ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL) + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = NULL, `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = NULL, `counter` = 3 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + Counter Load (0.4ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.2ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = NULL, `counter` = 4 WHERE `id` = 1 + SQL (1.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (1.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.4ms) SHOW TABLES + SQL (0.8ms) SELECT version FROM schema_migrations + SQL (0.3ms) SHOW TABLES + SQL (1.7ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.3ms) SHOW TABLES + SQL (0.8ms) SELECT version FROM schema_migrations + SQL (1.9ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (2.2ms) DROP TABLE `counters` + SQL (1.2ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.5ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (4.4ms) SHOW TABLES + SQL (0.5ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (32.5ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.7ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) BEGIN + Counter Create (0.0ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL) + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_last_2_days = 1 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-22 00:00:00 Z +counter_last_2_days: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.4ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 3\ncounter_last_2_days_at: 2010-06-22 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_last_day: 4 +counter_last_day_at: 2010-06-23 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-23 00:00:00 Z +counter_last_2_days: 4 +', counter_last_day = 0, counter_last_wednesday = 1, counter_last_tuesday = 1, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.8ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (59.2ms) DROP TABLE `counters` + SQL (0.8ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.5ms) SHOW TABLES + SQL (0.3ms) SELECT version FROM schema_migrations + SQL (0.3ms) SHOW TABLES + SQL (0.3ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (2.2ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (1.1ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) BEGIN + Counter Create (0.0ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL) + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_last_2_days = 1 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-22 00:00:00 Z +counter_last_2_days: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.5ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 3\ncounter_last_2_days_at: 2010-06-22 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (0.6ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_last_day: 4 +counter_last_day_at: 2010-06-23 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-23 00:00:00 Z +counter_last_2_days: 4 +', counter_last_day = 0, counter_last_wednesday = 1, counter_last_tuesday = 1, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (10.9ms) DROP TABLE `counters` + SQL (1.4ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.4ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (40.9ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.7ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) BEGIN + Counter Create (0.0ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL) + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_last_2_days = 1 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-22 00:00:00 Z +counter_last_2_days: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.4ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 3\ncounter_last_2_days_at: 2010-06-22 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (10.6ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_last_day: 4 +counter_last_day_at: 2010-06-23 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-23 00:00:00 Z +counter_last_2_days: 4 +', counter_last_day = 0, counter_last_wednesday = 1, counter_last_tuesday = 1, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (46.4ms) DROP TABLE `counters` + SQL (0.9ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.5ms) SHOW TABLES + SQL (0.3ms) SELECT version FROM schema_migrations + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (2.1ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (1.2ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) BEGIN + Counter Create (0.0ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL) + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_last_2_days = 1 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_last_2_days = 2 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (0.7ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_last_day: 4 +counter_last_day_at: 2010-06-23 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-23 00:00:00 Z +counter_last_2_days: 4 +', counter_last_day = 0, counter_last_wednesday = 1, counter_last_tuesday = 1, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (10.7ms) DROP TABLE `counters` + SQL (0.6ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (39.6ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.8ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) BEGIN + Counter Create (0.0ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL) + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_last_2_days = 1 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_last_2_days = 2 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (0.6ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_last_day: 4 +counter_last_day_at: 2010-06-23 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-23 00:00:00 Z +counter_last_2_days: 4 +', counter_last_day = 0, counter_last_wednesday = 1, counter_last_tuesday = 1, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (38.1ms) DROP TABLE `counters` + SQL (0.7ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.3ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (1.9ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.5ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) BEGIN + Counter Create (0.0ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL) + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_last_2_days = 1 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_last_2_days = 2 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.4ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (24.8ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_last_day: 4 +counter_last_day_at: 2010-06-23 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-23 00:00:00 Z +counter_last_2_days: 4 +', counter_last_day = 0, counter_last_wednesday = 1, counter_last_tuesday = 1, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (10.8ms) DROP TABLE `counters` + SQL (1.0ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.5ms) SHOW TABLES + SQL (0.3ms) SELECT version FROM schema_migrations + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (34.3ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.7ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) BEGIN + Counter Create (0.0ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL) + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_last_2_days = 1 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_last_2_days = 2 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.9ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (1.4ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (0.9ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_last_day: 4 +counter_last_day_at: 2010-06-23 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-23 00:00:00 Z +counter_last_2_days: 4 +', counter_last_day = 0, counter_last_wednesday = 1, counter_last_tuesday = 1, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (40.6ms) DROP TABLE `counters` + SQL (0.8ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.4ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (2.2ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.6ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (110.7ms) SHOW FIELDS FROM `counters` + SQL (34.5ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL) + SQL (0.7ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_last_2_days = 1 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.4ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.6ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_last_2_days = 2 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.4ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (1.1ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (0.7ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_last_day: 4 +counter_last_day_at: 2010-06-23 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-23 00:00:00 Z +counter_last_2_days: 4 +', counter_last_day = 0, counter_last_wednesday = 1, counter_last_tuesday = 1, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (10.6ms) DROP TABLE `counters` + SQL (0.7ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (42.1ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.6ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.5ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL) + SQL (0.6ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_last_2_days = 1 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.5ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.7ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_last_2_days = 2 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.9ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_last_day: 4 +counter_last_day_at: 2010-06-24 00:00:00 Z +counter_last_wednesday_before_today: 4 +counter_last_2_days_at: 2010-06-24 00:00:00 Z +counter_last_2_days: 4 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.9ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (10.6ms) DROP TABLE `counters` + SQL (39.3ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.5ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (2.3ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_1_day_ago` int(11), `counter_2_days_ago` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.5ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.4ms) SHOW FIELDS FROM `counters` + SQL (0.9ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_2_days_ago`, `counter_1_day_ago`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL) + SQL (0.4ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 1 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 0, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 2 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 1, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 3 +counter_1_day_ago_at: 2010-06-22 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 0, counter_last_2_days = 2, counter_1_day_ago = 3 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (10.2ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_1_day_ago: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (1.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_2_days_ago_at: 2010-06-24 00:00:00 Z +counter_last_day: 4 +counter_last_day_at: 2010-06-24 00:00:00 Z +counter_2_days_ago: 4 +counter_last_wednesday_before_today: 4 +counter_1_day_ago_at: 2010-06-24 00:00:00 Z +counter_last_2_days_at: 2010-06-24 00:00:00 Z +counter_last_2_days: 4 +counter_1_day_ago: 4 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 4, counter_last_2_days = 0, counter_1_day_ago = 4 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (41.5ms) DROP TABLE `counters` + SQL (0.7ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.3ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (2.0ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_1_day_ago` int(11), `counter_2_days_ago` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.5ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.5ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_2_days_ago`, `counter_1_day_ago`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL) + SQL (0.9ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 1 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 0, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 2 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 1, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (1.2ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.6ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 3 +counter_1_day_ago_at: 2010-06-22 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 0, counter_last_2_days = 2, counter_1_day_ago = 3 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_1_day_ago: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (1.1ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_2_days_ago_at: 2010-06-24 00:00:00 Z +counter_last_day: 4 +counter_last_day_at: 2010-06-24 00:00:00 Z +counter_2_days_ago: 4 +counter_last_wednesday_before_today: 4 +counter_1_day_ago_at: 2010-06-24 00:00:00 Z +counter_last_2_days_at: 2010-06-24 00:00:00 Z +counter_last_2_days: 4 +counter_1_day_ago: 4 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 4, counter_last_2_days = 0, counter_1_day_ago = 4 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (44.2ms) DROP TABLE `counters` + SQL (0.6ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.3ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (2.0ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_1_day_ago` int(11), `counter_2_days_ago` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.5ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.5ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_2_days_ago`, `counter_1_day_ago`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL) + SQL (10.8ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 1 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 0, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 2 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 1, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.6ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (1.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 3 +counter_1_day_ago_at: 2010-06-22 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 0, counter_last_2_days = 2, counter_1_day_ago = 3 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.5ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_1_day_ago: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_2_days_ago_at: 2010-06-24 00:00:00 Z +counter_last_day: 4 +counter_last_day_at: 2010-06-24 00:00:00 Z +counter_2_days_ago: 4 +counter_last_wednesday_before_today: 4 +counter_1_day_ago_at: 2010-06-24 00:00:00 Z +counter_last_2_days_at: 2010-06-24 00:00:00 Z +counter_last_2_days: 4 +counter_1_day_ago: 4 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 4, counter_last_2_days = 0, counter_1_day_ago = 4 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (47.1ms) DROP TABLE `counters` + SQL (0.7ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.3ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (2.2ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_1_day_ago` int(11), `counter_2_days_ago` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.5ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.5ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_2_days_ago`, `counter_1_day_ago`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL) + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 1 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 0, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 2 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 1, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.4ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.4ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.6ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 3 +counter_1_day_ago_at: 2010-06-22 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 0, counter_last_2_days = 2, counter_1_day_ago = 3 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.5ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.2ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_1_day_ago: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_2_days_ago_at: 2010-06-24 00:00:00 Z +counter_last_day: 4 +counter_last_day_at: 2010-06-24 00:00:00 Z +counter_2_days_ago: 4 +counter_last_wednesday_before_today: 4 +counter_1_day_ago_at: 2010-06-24 00:00:00 Z +counter_last_2_days_at: 2010-06-24 00:00:00 Z +counter_last_2_days: 4 +counter_1_day_ago: 4 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 4, counter_last_2_days = 0, counter_1_day_ago = 4 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (48.3ms) DROP TABLE `counters` + SQL (0.7ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (2.0ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_1_day_ago` int(11), `counter_2_days_ago` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.5ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.5ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.5ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_2_days_ago`, `counter_1_day_ago`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL) + SQL (1.2ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 1 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 0, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 2 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 1, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 3 +counter_1_day_ago_at: 2010-06-22 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 0, counter_last_2_days = 2, counter_1_day_ago = 3 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.4ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_1_day_ago: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_2_days_ago_at: 2010-06-24 00:00:00 Z +counter_last_day: 4 +counter_last_day_at: 2010-06-24 00:00:00 Z +counter_2_days_ago: 4 +counter_last_wednesday_before_today: 4 +counter_1_day_ago_at: 2010-06-24 00:00:00 Z +counter_last_2_days_at: 2010-06-24 00:00:00 Z +counter_last_2_days: 4 +counter_1_day_ago: 4 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 4, counter_last_2_days = 0, counter_1_day_ago = 4 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (27.8ms) DROP TABLE `counters` + SQL (0.7ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (2.5ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_1_day_ago` int(11), `counter_2_days_ago` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.6ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.8ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_2_days_ago`, `counter_1_day_ago`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL) + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 1 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 0, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` WHERE (`counters`.`id` = 1)  + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 2 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 1, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.5ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (25.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 3 +counter_1_day_ago_at: 2010-06-22 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 0, counter_last_2_days = 2, counter_1_day_ago = 3 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.5ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_1_day_ago: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (1.4ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_2_days_ago_at: 2010-06-24 00:00:00 Z +counter_last_day: 4 +counter_last_day_at: 2010-06-24 00:00:00 Z +counter_2_days_ago: 4 +counter_last_wednesday_before_today: 4 +counter_1_day_ago_at: 2010-06-24 00:00:00 Z +counter_last_2_days_at: 2010-06-24 00:00:00 Z +counter_last_2_days: 4 +counter_1_day_ago: 4 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 4, counter_last_2_days = 0, counter_1_day_ago = 4 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.5ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (11.5ms) DROP TABLE `counters` + SQL (0.9ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.3ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (1.9ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_1_day_ago` int(11), `counter_2_days_ago` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.5ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.3ms) SHOW FIELDS FROM `counters` + SQL (1.5ms) BEGIN + Counter Create (0.5ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_2_days_ago`, `counter_1_day_ago`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL) + SQL (0.4ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 1 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 0, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` WHERE (`counters`.`id` = 1)  + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 2 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 1, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.5ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (1.2ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 3 +counter_1_day_ago_at: 2010-06-22 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 0, counter_last_2_days = 2, counter_1_day_ago = 3 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.4ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_1_day_ago: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (11.1ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_2_days_ago_at: 2010-06-24 00:00:00 Z +counter_last_day: 4 +counter_last_day_at: 2010-06-24 00:00:00 Z +counter_2_days_ago: 4 +counter_last_wednesday_before_today: 4 +counter_1_day_ago_at: 2010-06-24 00:00:00 Z +counter_last_2_days_at: 2010-06-24 00:00:00 Z +counter_last_2_days: 4 +counter_1_day_ago: 4 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 4, counter_last_2_days = 0, counter_1_day_ago = 4 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (47.8ms) DROP TABLE `counters` + SQL (0.7ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.3ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (2.0ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_1_day_ago` int(11), `counter_2_days_ago` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.8ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.9ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_2_days_ago`, `counter_1_day_ago`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL) + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 1 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 0, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` WHERE (`counters`.`id` = 1)  + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 2 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 1, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.5ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.7ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 3 +counter_1_day_ago_at: 2010-06-22 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 0, counter_last_2_days = 2, counter_1_day_ago = 3 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.2ms) BEGIN + Counter Update (0.4ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_1_day_ago: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_2_days_ago_at: 2010-06-24 00:00:00 Z +counter_last_day: 4 +counter_last_day_at: 2010-06-24 00:00:00 Z +counter_2_days_ago: 4 +counter_last_wednesday_before_today: 4 +counter_1_day_ago_at: 2010-06-24 00:00:00 Z +counter_last_2_days_at: 2010-06-24 00:00:00 Z +counter_last_2_days: 4 +counter_1_day_ago: 4 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 4, counter_last_2_days = 0, counter_1_day_ago = 4 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (1.5ms) DROP TABLE `counters` + SQL (0.6ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.3ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (26.5ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_1_day_ago` int(11), `counter_2_days_ago` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.6ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.6ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_2_days_ago`, `counter_1_day_ago`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL) + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 1 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 0, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` WHERE (`counters`.`id` = 1)  + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 2 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 1, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.6ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.8ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 3 +counter_1_day_ago_at: 2010-06-22 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 0, counter_last_2_days = 2, counter_1_day_ago = 3 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (4.4ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.6ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_1_day_ago: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (0.8ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_2_days_ago_at: 2010-06-24 00:00:00 Z +counter_last_day: 4 +counter_last_day_at: 2010-06-24 00:00:00 Z +counter_2_days_ago: 4 +counter_last_wednesday_before_today: 4 +counter_1_day_ago_at: 2010-06-24 00:00:00 Z +counter_last_2_days_at: 2010-06-24 00:00:00 Z +counter_last_2_days: 4 +counter_1_day_ago: 4 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 4, counter_last_2_days = 0, counter_1_day_ago = 4 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.4ms) SHOW TABLES + SQL (0.6ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (57.9ms) DROP TABLE `counters` + SQL (0.6ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (2.5ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_1_day_ago` int(11), `counter_2_days_ago` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.5ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.9ms) SHOW FIELDS FROM `counters` + SQL (1.1ms) BEGIN + Counter Create (0.8ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_2_days_ago`, `counter_1_day_ago`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL) + SQL (0.4ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 1 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 0, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` WHERE (`counters`.`id` = 1)  + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 2 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 1, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.4ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.8ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 3 +counter_1_day_ago_at: 2010-06-22 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 0, counter_last_2_days = 2, counter_1_day_ago = 3 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (3.2ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.2ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_1_day_ago: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_2_days_ago_at: 2010-06-24 00:00:00 Z +counter_last_day: 4 +counter_last_day_at: 2010-06-24 00:00:00 Z +counter_2_days_ago: 4 +counter_last_wednesday_before_today: 4 +counter_1_day_ago_at: 2010-06-24 00:00:00 Z +counter_last_2_days_at: 2010-06-24 00:00:00 Z +counter_last_2_days: 4 +counter_1_day_ago: 4 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 4, counter_last_2_days = 0, counter_1_day_ago = 4 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (1.6ms) DROP TABLE `counters` + SQL (0.6ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (30.6ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_1_day_ago` int(11), `counter_2_days_ago` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.6ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.6ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.4ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_2_days_ago`, `counter_1_day_ago`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL) + SQL (0.6ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 1 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 0, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` WHERE (`counters`.`id` = 1)  + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 2 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 2 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 1, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.4ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.8ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_1_day_ago: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (1.1ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 3 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 2 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 0, counter_last_2_days = 2, counter_1_day_ago = 3 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.5ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_1_day_ago: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (53.6ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 4 +counter_last_day_at: 2010-06-24 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 4 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-24 00:00:00 Z +counter_last_2_days: 4 +counter_1_day_ago: 2 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 4, counter_last_2_days = 0, counter_1_day_ago = 4 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (10.7ms) DROP TABLE `counters` + SQL (1.1ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (56.9ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_1_day_ago` int(11), `counter_2_days_ago` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.7ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.9ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_2_days_ago`, `counter_1_day_ago`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL) + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 1 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 0, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` WHERE (`counters`.`id` = 1)  + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 2 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 2 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 1, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.4ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_1_day_ago: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.8ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 3 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 2 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 0, counter_last_2_days = 2, counter_1_day_ago = 3 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.6ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.5ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_1_day_ago: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 4 +counter_last_day_at: 2010-06-24 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 4 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-24 00:00:00 Z +counter_last_2_days: 4 +counter_1_day_ago: 2 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 4, counter_last_2_days = 0, counter_1_day_ago = 4 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.4ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (10.9ms) DROP TABLE `counters` + SQL (1.0ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.4ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (33.2ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_1_day_ago` int(11), `counter_2_days_ago` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.9ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.9ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_2_days_ago`, `counter_1_day_ago`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL) + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 1 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 0, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` WHERE (`counters`.`id` = 1)  + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 2 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 2 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 1, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_1_day_ago: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (11.8ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 3 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 2 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 0, counter_last_2_days = 2, counter_1_day_ago = 3 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.4ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.2ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_1_day_ago: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 4 +counter_last_day_at: 2010-06-24 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 4 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-24 00:00:00 Z +counter_last_2_days: 4 +counter_1_day_ago: 2 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 4, counter_last_2_days = 0, counter_1_day_ago = 4 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (11.1ms) DROP TABLE `counters` + SQL (0.7ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.3ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (42.8ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_1_day_ago` int(11), `counter_2_days_ago` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.8ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (2.4ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_2_days_ago`, `counter_1_day_ago`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL) + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 1 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 0, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` WHERE (`counters`.`id` = 1)  + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 2 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 2 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 1, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_1_day_ago: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (1.1ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 3 +counter_1_day_ago_at: 2010-06-22 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 0, counter_last_2_days = 2, counter_1_day_ago = 3 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.4ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.5ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_1_day_ago: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_2_days_ago_at: 2010-06-24 00:00:00 Z +counter_last_day: 4 +counter_last_day_at: 2010-06-24 00:00:00 Z +counter_2_days_ago: 4 +counter_last_wednesday_before_today: 4 +counter_1_day_ago_at: 2010-06-24 00:00:00 Z +counter_last_2_days_at: 2010-06-24 00:00:00 Z +counter_last_2_days: 4 +counter_1_day_ago: 4 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 4, counter_last_2_days = 0, counter_1_day_ago = 4 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (10.7ms) DROP TABLE `counters` + SQL (0.6ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (55.2ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_1_day_ago` int(11), `counter_2_days_ago` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.7ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.4ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_2_days_ago`, `counter_1_day_ago`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL) + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 1 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 0, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` WHERE (`counters`.`id` = 1)  + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 2 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 2 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 1, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.6ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_1_day_ago: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 3 +counter_1_day_ago_at: 2010-06-22 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 0, counter_last_2_days = 2, counter_1_day_ago = 3 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_1_day_ago: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (0.6ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_2_days_ago_at: 2010-06-24 00:00:00 Z +counter_last_day: 4 +counter_last_day_at: 2010-06-24 00:00:00 Z +counter_2_days_ago: 4 +counter_last_wednesday_before_today: 4 +counter_1_day_ago_at: 2010-06-24 00:00:00 Z +counter_last_2_days_at: 2010-06-24 00:00:00 Z +counter_last_2_days: 4 +counter_1_day_ago: 4 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 4, counter_last_2_days = 0, counter_1_day_ago = 4 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (10.6ms) DROP TABLE `counters` + SQL (0.7ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (55.8ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_1_day_ago` int(11), `counter_2_days_ago` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.8ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (2.4ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_2_days_ago`, `counter_1_day_ago`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL) + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 1 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 0, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` WHERE (`counters`.`id` = 1)  + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 2 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 2 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 1, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.9ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_1_day_ago: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 3 +counter_1_day_ago_at: 2010-06-22 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 0, counter_last_2_days = 2, counter_1_day_ago = 2 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_1_day_ago: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (0.6ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_2_days_ago_at: 2010-06-24 00:00:00 Z +counter_last_day: 4 +counter_last_day_at: 2010-06-24 00:00:00 Z +counter_2_days_ago: 4 +counter_last_wednesday_before_today: 4 +counter_1_day_ago_at: 2010-06-24 00:00:00 Z +counter_last_2_days_at: 2010-06-24 00:00:00 Z +counter_last_2_days: 4 +counter_1_day_ago: 4 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 2, counter_last_2_days = 0, counter_1_day_ago = 3 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (10.6ms) DROP TABLE `counters` + SQL (1.3ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (36.3ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_1_day_ago` int(11), `counter_2_days_ago` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.6ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.6ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_2_days_ago`, `counter_1_day_ago`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL) + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 1 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 0, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` WHERE (`counters`.`id` = 1)  + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 2 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 2 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 1, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_1_day_ago: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.4ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 3 +counter_1_day_ago_at: 2010-06-22 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 0, counter_last_2_days = 2, counter_1_day_ago = 2 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.7ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.9ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_1_day_ago: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (0.9ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_2_days_ago_at: 2010-06-24 00:00:00 Z +counter_last_day: 4 +counter_last_day_at: 2010-06-24 00:00:00 Z +counter_2_days_ago: 4 +counter_last_wednesday_before_today: 4 +counter_1_day_ago_at: 2010-06-24 00:00:00 Z +counter_last_2_days_at: 2010-06-24 00:00:00 Z +counter_last_2_days: 4 +counter_1_day_ago: 4 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 2, counter_last_2_days = 0, counter_1_day_ago = 3 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (10.6ms) DROP TABLE `counters` + SQL (0.8ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (2.2ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_1_day_ago` int(11), `counter_2_days_ago` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.5ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.5ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.6ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_2_days_ago`, `counter_1_day_ago`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL) + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 1 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 0, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` WHERE (`counters`.`id` = 1)  + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 2 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 2 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 1, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.4ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_1_day_ago: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.6ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 3 +counter_1_day_ago_at: 2010-06-22 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 0, counter_last_2_days = 2, counter_1_day_ago = 2 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.4ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_1_day_ago: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (0.8ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_2_days_ago_at: 2010-06-24 00:00:00 Z +counter_last_day: 4 +counter_last_day_at: 2010-06-24 00:00:00 Z +counter_2_days_ago: 4 +counter_last_wednesday_before_today: 4 +counter_1_day_ago_at: 2010-06-24 00:00:00 Z +counter_last_2_days_at: 2010-06-24 00:00:00 Z +counter_last_2_days: 4 +counter_1_day_ago: 4 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 2, counter_last_2_days = 0, counter_1_day_ago = 3 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (10.7ms) DROP TABLE `counters` + SQL (1.3ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.2ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (39.2ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_1_day_ago` int(11), `counter_2_days_ago` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.8ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (2.4ms) SHOW FIELDS FROM `counters` + SQL (0.2ms) BEGIN + Counter Create (0.4ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_2_days_ago`, `counter_1_day_ago`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL) + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 1 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 0, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` WHERE (`counters`.`id` = 1)  + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 2 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 2 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 1, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.4ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_1_day_ago: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.8ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 3 +counter_1_day_ago_at: 2010-06-22 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 0, counter_last_2_days = 2, counter_1_day_ago = 2 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_1_day_ago: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (12.1ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_2_days_ago_at: 2010-06-24 00:00:00 Z +counter_last_day: 4 +counter_last_day_at: 2010-06-24 00:00:00 Z +counter_2_days_ago: 4 +counter_last_wednesday_before_today: 4 +counter_1_day_ago_at: 2010-06-24 00:00:00 Z +counter_last_2_days_at: 2010-06-24 00:00:00 Z +counter_last_2_days: 4 +counter_1_day_ago: 4 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 2, counter_last_2_days = 0, counter_1_day_ago = 3 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (10.8ms) DROP TABLE `counters` + SQL (1.3ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (37.0ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_1_day_ago` int(11), `counter_2_days_ago` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.7ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.8ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_2_days_ago`, `counter_1_day_ago`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL) + SQL (0.6ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 1 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 0, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` WHERE (`counters`.`id` = 1)  + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 2 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 2 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 1, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.4ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_1_day_ago: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (11.4ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 3 +counter_1_day_ago_at: 2010-06-22 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 0, counter_last_2_days = 2, counter_1_day_ago = 2 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_1_day_ago: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (0.8ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_2_days_ago_at: 2010-06-24 00:00:00 Z +counter_last_day: 4 +counter_last_day_at: 2010-06-24 00:00:00 Z +counter_2_days_ago: 4 +counter_last_wednesday_before_today: 4 +counter_1_day_ago_at: 2010-06-24 00:00:00 Z +counter_last_2_days_at: 2010-06-24 00:00:00 Z +counter_last_2_days: 4 +counter_1_day_ago: 4 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 2, counter_last_2_days = 0, counter_1_day_ago = 3 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (10.6ms) DROP TABLE `counters` + SQL (1.3ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (34.0ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_1_day_ago` int(11), `counter_2_days_ago` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.7ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (2.5ms) SHOW FIELDS FROM `counters` + SQL (0.2ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_2_days_ago`, `counter_1_day_ago`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL) + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 1 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 0, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` WHERE (`counters`.`id` = 1)  + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 2 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 2 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 1, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_1_day_ago: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 3 +counter_1_day_ago_at: 2010-06-22 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 0, counter_last_2_days = 2, counter_1_day_ago = 2 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_1_day_ago: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (1.2ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_2_days_ago_at: 2010-06-24 00:00:00 Z +counter_last_day: 4 +counter_last_day_at: 2010-06-24 00:00:00 Z +counter_2_days_ago: 4 +counter_last_wednesday_before_today: 4 +counter_1_day_ago_at: 2010-06-24 00:00:00 Z +counter_last_2_days_at: 2010-06-24 00:00:00 Z +counter_last_2_days: 4 +counter_1_day_ago: 4 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 2, counter_last_2_days = 0, counter_1_day_ago = 3 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (11.9ms) DROP TABLE `counters` + SQL (0.6ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.5ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (70.7ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_1_day_ago` int(11), `counter_2_days_ago` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_last_monday` int(11), `counter_last_tuesday` int(11), `counter_last_wednesday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.5ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (27.8ms) SHOW FIELDS FROM `counters` + SQL (0.3ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_last_monday`, `counter_data`, `counter_last_day`, `counter_last_tuesday`, `counter_last_wednesday`, `counter`, `counter_2_days_ago`, `counter_1_day_ago`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL) + SQL (0.5ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 1, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 1 +counter_last_wednesday_before_today: 1 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 1 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 0, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.0ms) SELECT * FROM `counters` WHERE (`counters`.`id` = 1)  + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.0ms) BEGIN + Counter Update (0.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_2_days_ago: 1\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_1_day_ago: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.0ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 1 +counter_last_day_at: 2010-06-21 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 2 +counter_1_day_ago_at: 2010-06-21 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 2 +', counter_last_day = 1, counter_last_wednesday = 0, counter_last_tuesday = 0, counter_2_days_ago = 0, counter_last_2_days = 1, counter_1_day_ago = 0 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.5ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 0\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-21 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_1_day_ago: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.7ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_2_days_ago_at: 2010-06-21 00:00:00 Z +counter_last_day: 3 +counter_last_day_at: 2010-06-22 00:00:00 Z +counter_2_days_ago: 2 +counter_last_wednesday_before_today: 3 +counter_1_day_ago_at: 2010-06-22 00:00:00 Z +counter_last_2_days_at: 2010-06-21 00:00:00 Z +counter_last_2_days: 1 +counter_1_day_ago: 3 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 0, counter_last_2_days = 2, counter_1_day_ago = 2 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (0.2ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.2ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_monday_before_today: 3\ncounter_2_days_ago_at: 2010-06-21 00:00:00 Z\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_2_days_ago: 2\ncounter_last_day_at: 2010-06-22 00:00:00 Z\ncounter_1_day_ago_at: 2010-06-22 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_1_day_ago: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-21 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (0.7ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_1_day_ago, counter_2_days_ago, counter_last_day, counter_last_2_days, counter_last_monday, counter_last_tuesday, counter_last_wednesday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_monday = 2, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_2_days_ago_at: 2010-06-24 00:00:00 Z +counter_last_day: 4 +counter_last_day_at: 2010-06-24 00:00:00 Z +counter_2_days_ago: 4 +counter_last_wednesday_before_today: 4 +counter_1_day_ago_at: 2010-06-24 00:00:00 Z +counter_last_2_days_at: 2010-06-24 00:00:00 Z +counter_last_2_days: 4 +counter_1_day_ago: 4 +', counter_last_day = 0, counter_last_wednesday = 0, counter_last_tuesday = 1, counter_2_days_ago = 2, counter_last_2_days = 0, counter_1_day_ago = 3 + WHERE id = 1 + + Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1