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

- old
+ new

@@ -10559,5 +10559,1888 @@ counter_last_2_days: 4 ', counter_last_day = 0, counter_last_2_days = 0 WHERE id = 1  Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (2.0ms) SET SQL_AUTO_IS_NULL=0 + SQL (2.3ms) SHOW TABLES + SQL (607.6ms) 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 (260.1ms) DROP TABLE `counters` + SQL (2.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 (29.0ms) 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_data` varchar(2048)) ENGINE=InnoDB + SQL (0.9ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (2.0ms) SHOW FIELDS FROM `counters` + SQL (0.2ms) BEGIN + Counter Create (0.4ms) INSERT INTO `counters` (`counter_data`, `counter_last_day`, `counter`, `counter_last_2_days`) VALUES(NULL, NULL, 1, NULL) + SQL (0.6ms) COMMIT + SQL (0.4ms) SHOW TABLES + SQL (1.1ms) SHOW FIELDS FROM `counters` + SQL (17.2ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.5ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days + FROM counters + + SQL (1.2ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 1 +counter_last_day_at: 2010-06-17 00:00:00 Z +counter_last_2_days_at: 2010-06-17 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 0, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.4ms) 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_day: 1\ncounter_last_day_at: 2010-06-17 00:00:00 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-17 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (10.1ms) COMMIT + SQL (0.4ms) SHOW TABLES + SQL (1.9ms) SHOW FIELDS FROM `counters` + SQL (1.2ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.3ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days + FROM counters + + SQL (0.8ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 1 +counter_last_day_at: 2010-06-17 00:00:00 Z +counter_last_2_days_at: 2010-06-17 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 1, counter_last_2_days = 1 + WHERE id = 1 + + Counter Load (0.2ms) 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_day: 1\ncounter_last_day_at: 2010-06-17 00:00:00 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-17 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 + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 3 +counter_last_day_at: 2010-06-18 00:00:00 Z +counter_last_2_days_at: 2010-06-17 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 0, 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_day: 3\ncounter_last_day_at: 2010-06-18 00:00:00 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-17 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 + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 4 +counter_last_day_at: 2010-06-19 00:00:00 Z +counter_last_2_days_at: 2010-06-19 00:00:00 Z +counter_last_2_days: 4 +', counter_last_day = 0, 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.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.6ms) 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 (17.2ms) 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 (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_data` varchar(2048)) ENGINE=InnoDB + SQL (0.6ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.4ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.4ms) INSERT INTO `counters` (`counter_data`, `counter_last_day`, `counter`, `counter_last_2_days`) VALUES(NULL, NULL, 1, NULL) + SQL (0.5ms) COMMIT + SQL (0.4ms) SHOW TABLES + SQL (1.4ms) SHOW FIELDS FROM `counters` + SQL (1.4ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.3ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days + FROM counters + + SQL (0.9ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 1 +counter_last_day_at: 2010-06-17 00:00:00 Z +counter_last_2_days_at: 2010-06-17 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 0, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.2ms) 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_day: 1\ncounter_last_day_at: 2010-06-17 00:00:00 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-17 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.6ms) COMMIT + SQL (0.3ms) SHOW TABLES + SQL (1.3ms) SHOW FIELDS FROM `counters` + SQL (1.3ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.5ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days + FROM counters + + SQL (0.6ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 1 +counter_last_day_at: 2010-06-17 00:00:00 Z +counter_last_2_days_at: 2010-06-17 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 1, counter_last_2_days = 1 + WHERE id = 1 + + Counter Load (0.2ms) 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.1ms) BEGIN + Counter Update (0.2ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_day: 1\ncounter_last_day_at: 2010-06-17 00:00:00 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-17 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 + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 3 +counter_last_day_at: 2010-06-18 00:00:00 Z +counter_last_2_days_at: 2010-06-17 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 0, 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.2ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.2ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_day: 3\ncounter_last_day_at: 2010-06-18 00:00:00 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-17 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 + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 4 +counter_last_day_at: 2010-06-19 00:00:00 Z +counter_last_2_days_at: 2010-06-19 00:00:00 Z +counter_last_2_days: 4 +', counter_last_day = 0, 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.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 (0.9ms) 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.0ms) 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_thursday` 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.2ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_last_thursday`, `counter_data`, `counter_last_day`, `counter`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, 1, NULL) + SQL (1.7ms) COMMIT + SQL (0.3ms) SHOW TABLES + SQL (1.3ms) SHOW FIELDS FROM `counters` + SQL (1.4ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.2ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_thursday + FROM counters + + 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` = NULL, `counter` = 2 WHERE `id` = 1 + SQL (0.4ms) COMMIT + SQL (0.3ms) SHOW TABLES + SQL (1.1ms) SHOW FIELDS FROM `counters` + SQL (1.4ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.9ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_thursday + FROM counters + + Counter Load (0.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.2ms) UPDATE `counters` SET `counter_data` = NULL, `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_last_day, counter_last_2_days, counter_last_thursday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_thursday = 0, counter_data = '--- +counter_last_thursday_before_today: 3 +counter_last_day: 3 +counter_last_day_at: 2010-06-18 00:00:00 Z +counter_last_2_days_at: 2010-06-18 00:00:00 Z +counter_last_2_days: 3 +', counter_last_day = 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.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_thursday_before_today: 3\ncounter_last_day: 3\ncounter_last_day_at: 2010-06-18 00:00:00 Z\ncounter_last_2_days: 3\ncounter_last_2_days_at: 2010-06-18 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_last_day, counter_last_2_days, counter_last_thursday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_thursday = 0, counter_data = '--- +counter_last_thursday_before_today: 4 +counter_last_day: 4 +counter_last_day_at: 2010-06-19 00:00:00 Z +counter_last_2_days_at: 2010-06-18 00:00:00 Z +counter_last_2_days: 3 +', counter_last_day = 0, counter_last_2_days = 1 + 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.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 (2.0ms) 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_thursday` int(11), `counter_last_friday` int(11), `counter_last_saturday` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.7ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (2.8ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_last_friday`, `counter_last_saturday`, `counter_last_thursday`, `counter_data`, `counter_last_day`, `counter`, `counter_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL) + SQL (0.5ms) COMMIT + SQL (0.3ms) SHOW TABLES + SQL (1.3ms) SHOW FIELDS FROM `counters` + SQL (1.7ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.9ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_thursday, counter_last_friday, counter_last_saturday + FROM counters + + SQL (0.7ms)  UPDATE counters + SET counter_last_saturday = 0, counter_last_friday = 0, counter_last_thursday = 0, counter_data = '--- +counter_last_thursday: 1 +counter_last_thursday_before_today: 0 +counter_last_saturday_before_today: 1 +counter_last_day: 1 +counter_last_friday_before_today: 1 +counter_last_day_at: 2010-06-17 00:00:00 Z +counter_last_2_days_at: 2010-06-17 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 0, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.2ms) 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_thursday_before_today: 0\ncounter_last_thursday: 1\ncounter_last_saturday_before_today: 1\ncounter_last_day: 1\ncounter_last_friday_before_today: 1\ncounter_last_day_at: 2010-06-17 00:00:00 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-17 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.6ms) COMMIT + SQL (0.4ms) SHOW TABLES + SQL (1.2ms) SHOW FIELDS FROM `counters` + SQL (1.7ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.5ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days, counter_last_thursday, counter_last_friday, counter_last_saturday + FROM counters + + SQL (0.7ms)  UPDATE counters + SET counter_last_saturday = 0, counter_last_friday = 0, counter_last_thursday = 0, counter_data = '--- +counter_last_thursday: 2 +counter_last_thursday_before_today: 0 +counter_last_saturday_before_today: 2 +counter_last_day: 1 +counter_last_friday_before_today: 2 +counter_last_day_at: 2010-06-17 00:00:00 Z +counter_last_2_days_at: 2010-06-17 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 1, counter_last_2_days = 1 + WHERE id = 1 + + Counter Load (0.2ms) 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_thursday_before_today: 0\ncounter_last_thursday: 2\ncounter_last_saturday_before_today: 2\ncounter_last_day: 1\ncounter_last_friday_before_today: 2\ncounter_last_day_at: 2010-06-17 00:00:00 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-17 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_last_day, counter_last_2_days, counter_last_thursday, counter_last_friday, counter_last_saturday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_saturday = 0, counter_last_friday = 0, counter_last_thursday = 0, counter_data = '--- +counter_last_friday: 1 +counter_last_thursday: 2 +counter_last_thursday_before_today: 3 +counter_last_saturday_before_today: 3 +counter_last_day: 3 +counter_last_friday_before_today: 2 +counter_last_day_at: 2010-06-18 00:00:00 Z +counter_last_2_days_at: 2010-06-17 00:00:00 Z +counter_last_2_days: 1 +', counter_last_day = 0, 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_friday: 1\ncounter_last_thursday_before_today: 3\ncounter_last_thursday: 2\ncounter_last_saturday_before_today: 3\ncounter_last_day: 3\ncounter_last_friday_before_today: 2\ncounter_last_day_at: 2010-06-18 00:00:00 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-17 00:00:00 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (1.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_thursday, counter_last_friday, counter_last_saturday + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_last_saturday = 0, counter_last_friday = 0, counter_last_thursday = 0, counter_data = '--- +counter_last_saturday: 1 +counter_last_friday: 1 +counter_last_thursday: 2 +counter_last_thursday_before_today: 4 +counter_last_saturday_before_today: 3 +counter_last_day: 4 +counter_last_friday_before_today: 4 +counter_last_day_at: 2010-06-19 00:00:00 Z +counter_last_2_days_at: 2010-06-19 00:00:00 Z +counter_last_2_days: 4 +', counter_last_day = 0, 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.8ms) 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.0ms) 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 (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_last_2_days`) VALUES(NULL, NULL, NULL, NULL, NULL, 1, NULL) + SQL (0.5ms) COMMIT + SQL (0.3ms) SHOW TABLES + SQL (1.3ms) SHOW FIELDS FROM `counters` + SQL (1.3ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.3ms)  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.7ms)  UPDATE counters + SET counter_last_monday = 0, counter_data = '--- +counter_last_monday_before_today: 1 +counter_last_tuesday_before_today: 1 +counter_last_day: 1 +counter_last_day_at: 2010-06-17 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-17 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.2ms) 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: 1\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-17 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-17 00:00:00 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.6ms) COMMIT + SQL (0.4ms) SHOW TABLES + SQL (1.2ms) SHOW FIELDS FROM `counters` + SQL (2.4ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.2ms)  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.7ms)  UPDATE counters + SET counter_last_monday = 0, counter_data = '--- +counter_last_monday_before_today: 2 +counter_last_tuesday_before_today: 2 +counter_last_day: 1 +counter_last_day_at: 2010-06-17 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-17 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.2ms) 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: 2\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-17 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-17 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_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 = 0, counter_data = '--- +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 3 +counter_last_day: 3 +counter_last_day_at: 2010-06-18 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-17 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 = 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: 3\ncounter_last_day: 3\ncounter_last_day_at: 2010-06-18 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-17 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 = 0, counter_data = '--- +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_last_day: 4 +counter_last_day_at: 2010-06-19 00:00:00 Z +counter_last_wednesday_before_today: 4 +counter_last_2_days_at: 2010-06-19 00:00:00 Z +counter_last_2_days: 4 +', 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 + 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.5ms) 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.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (1.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 (0.5ms) INSERT INTO schema_migrations (version) VALUES ('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.4ms) 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 (1.7ms) 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 = 0, counter_data = '--- +counter_last_monday: 1 +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 1 +counter_last_day: 1 +counter_last_day_at: 2010-06-14 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-14 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: 1\ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 1\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-14 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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 = 0, counter_data = '--- +counter_last_monday: 2 +counter_last_monday_before_today: 0 +counter_last_tuesday_before_today: 2 +counter_last_day: 1 +counter_last_day_at: 2010-06-14 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-14 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: 2\ncounter_last_monday_before_today: 0\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 1\ncounter_last_day_at: 2010-06-14 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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 = 0, counter_data = '--- +counter_last_monday: 2 +counter_last_monday_before_today: 3 +counter_last_tuesday_before_today: 2 +counter_last_day: 3 +counter_last_tuesday: 1 +counter_last_day_at: 2010-06-15 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-14 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 = 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: 2\ncounter_last_monday_before_today: 3\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_last_tuesday: 1\ncounter_last_day_at: 2010-06-15 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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 = 0, counter_data = '--- +counter_last_monday: 2 +counter_last_monday_before_today: 4 +counter_last_tuesday_before_today: 4 +counter_last_day: 4 +counter_last_tuesday: 1 +counter_last_day_at: 2010-06-19 00:00:00 Z +counter_last_wednesday_before_today: 4 +counter_last_2_days_at: 2010-06-19 00:00:00 Z +counter_last_2_days: 4 +', 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 + 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.5ms) 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.6ms) 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-14 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-15 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-14 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-15 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-19 00:00:00 Z +counter_last_wednesday_before_today: 4 +counter_last_2_days_at: 2010-06-19 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.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.3ms) DROP TABLE `counters` + SQL (0.9ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.5ms) 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 (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.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-14 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-15 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-14 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-15 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 00:00:00 Z\n', `counter` = 4 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_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-19 00:00:00 Z +counter_last_wednesday_before_today: 4 +counter_last_2_days_at: 2010-06-19 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.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.5ms) 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 (40.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-14 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-15 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-14 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 (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-15 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-19 00:00:00 Z +counter_last_wednesday_before_today: 4 +counter_last_2_days_at: 2010-06-19 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.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.5ms) 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 (59.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-14 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-15 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-14 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 (3.1ms) 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_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_last_day_at: 2010-06-15 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-19 00:00:00 Z +counter_last_wednesday_before_today: 4 +counter_last_2_days_at: 2010-06-19 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.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.5ms) 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.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (58.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-14 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-15 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-14 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 (7.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: 3\ncounter_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_last_day_at: 2010-06-15 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-19 00:00:00 Z +counter_last_wednesday_before_today: 4 +counter_last_2_days_at: 2010-06-19 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.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 (10.5ms) 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.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.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-14 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-15 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-14 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.2ms) BEGIN + Counter Update (2.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-15 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-19 00:00:00 Z +counter_last_wednesday_before_today: 4 +counter_last_2_days_at: 2010-06-19 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.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 (37.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.4ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (2.7ms) 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-14 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-15 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-14 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.2ms) 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-15 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-19 00:00:00 Z +counter_last_wednesday_before_today: 4 +counter_last_2_days_at: 2010-06-19 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.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.5ms) 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 (38.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-14 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-15 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-14 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.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_last_tuesday_before_today: 2\ncounter_last_day: 3\ncounter_last_day_at: 2010-06-15 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-19 00:00:00 Z +counter_last_wednesday_before_today: 4 +counter_last_2_days_at: 2010-06-19 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.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 (39.5ms) 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 (1.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.4ms) 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-14 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-15 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-14 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.2ms) 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-15 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-19 00:00:00 Z +counter_last_wednesday_before_today: 4 +counter_last_2_days_at: 2010-06-19 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.2ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.4ms) 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.5ms) 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.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.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-14 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-15 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-14 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-15 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-19 00:00:00 Z +counter_last_wednesday_before_today: 4 +counter_last_2_days_at: 2010-06-19 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.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 (22.3ms) DROP TABLE `counters` + SQL (0.8ms) 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.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 (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-14 00:00:00 Z +counter_last_wednesday_before_today: 1 +counter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z\ncounter_last_wednesday_before_today: 1\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z +counter_last_wednesday_before_today: 2 +counter_last_2_days_at: 2010-06-14 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-14 00:00:00 Z\ncounter_last_wednesday_before_today: 2\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-15 00:00:00 Z +counter_last_wednesday_before_today: 3 +counter_last_2_days_at: 2010-06-14 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.2ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (0.2ms) 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-15 00:00:00 Z\ncounter_last_wednesday_before_today: 3\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-14 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-19 00:00:00 Z +counter_last_wednesday_before_today: 4 +counter_last_2_days_at: 2010-06-19 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