spec/log/test.log in periodic_counter-0.1.0 vs spec/log/test.log in periodic_counter-0.1.1

- old
+ new

@@ -9179,5 +9179,785 @@ counter_last_2_days: 3 ', counter_last_day = 1, counter_last_2_days = 2 WHERE id = 1  Counter Load (0.0ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (4.4ms) SET SQL_AUTO_IS_NULL=0 + SQL (12.9ms) SHOW TABLES + SQL (0.3ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (4.4ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (3.0ms) 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 (68.8ms) 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_data` varchar(2048)) ENGINE=InnoDB + SQL (11.8ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.2ms) SHOW FIELDS FROM `counters` + SQL (0.8ms) BEGIN + Counter Create (0.3ms) 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.1ms) SHOW FIELDS FROM `counters` + SQL (1.8ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.6ms)  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-10 21:52:32.893979 Z +counter_last_2_days_at: 2010-06-10 21:52:32.894024 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.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_day: 1\ncounter_last_day_at: 2010-06-10 21:52:32.893979 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-10 21:52:32.894024 Z\n', `counter` = 2 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 + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 2 +counter_last_day_at: 2010-06-11 21:52:32.900301 Z +counter_last_2_days_at: 2010-06-10 21:52:32.894024 Z +counter_last_2_days: 1 +', 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 + 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: 2\ncounter_last_day_at: 2010-06-11 21:52:32.900301 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-10 21:52:32.894024 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: &id001 2010-06-12 21:52:32.944040 Z +counter_last_2_days_at: *id001 +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 + SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 + SQL (7.4ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (8.7ms) DROP TABLE `counters` + SQL (0.6ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (22.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_data` varchar(2048)) ENGINE=InnoDB + SQL (0.9ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.5ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_data`, `counter_last_day`, `counter`, `counter_last_2_days`) VALUES(NULL, NULL, 1, NULL) + SQL (0.5ms) COMMIT + SQL (0.3ms) SHOW TABLES + SQL (1.3ms) SHOW FIELDS FROM `counters` + SQL (1.5ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.2ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days + FROM counters + + SQL (11.8ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 1 +counter_last_day_at: 2010-06-10 21:55:06.092149 Z +counter_last_2_days_at: 2010-06-10 21:55:06.092195 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.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_day: 1\ncounter_last_day_at: 2010-06-10 21:55:06.092149 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-10 21:55:06.092195 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.7ms) SHOW FIELDS FROM `schema_migrations` + SQL (1.0ms)  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-10 21:55:06.092149 Z +counter_last_2_days_at: 2010-06-10 21:55:06.092195 Z +counter_last_2_days: 1 +', counter_last_day = 1, counter_last_2_days = 1 + WHERE id = 1 + + Counter Load (0.3ms) 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: 1\ncounter_last_day_at: 2010-06-10 21:55:06.092149 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-10 21:55:06.092195 Z\n' 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: 2 +counter_last_day_at: 2010-06-11 21:55:06.137782 Z +counter_last_2_days_at: 2010-06-10 21:55:06.092195 Z +counter_last_2_days: 1 +', 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 + Counter Load (1.5ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.1ms) BEGIN + Counter Update (1.0ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_day: 2\ncounter_last_day_at: 2010-06-11 21:55:06.137782 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-10 21:55:06.092195 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: &id001 2010-06-12 21:55:06.155953 Z +counter_last_2_days_at: *id001 +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 + SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (11.1ms) DROP TABLE `counters` + SQL (2.2ms) DELETE FROM schema_migrations WHERE version = '1' + SQL (5.2ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (10.0ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (68.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_data` varchar(2048)) ENGINE=InnoDB + SQL (3.9ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (14.0ms) SHOW FIELDS FROM `counters` + SQL (8.3ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_data`, `counter_last_day`, `counter`, `counter_last_2_days`) VALUES(NULL, NULL, 1, NULL) + SQL (0.8ms) COMMIT + SQL (0.3ms) SHOW TABLES + SQL (1.8ms) SHOW FIELDS FROM `counters` + SQL (9.3ms) SHOW FIELDS FROM `schema_migrations` + SQL (2.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days + FROM counters + + SQL (2.3ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 1 +counter_last_day_at: 2010-06-10 21:55:17.011146 Z +counter_last_2_days_at: 2010-06-10 21:55:17.011192 Z +counter_last_2_days: 1 +', counter_last_day = 0, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (1.2ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (1.4ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (2.9ms) BEGIN + Counter Update (0.4ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_day: 1\ncounter_last_day_at: 2010-06-10 21:55:17.011146 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-10 21:55:17.011192 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.4ms) COMMIT + SQL (0.2ms) SHOW TABLES + SQL (1.0ms) SHOW FIELDS FROM `counters` + SQL (4.9ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.2ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days + FROM counters + + SQL (2.8ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 1 +counter_last_day_at: 2010-06-10 21:55:17.011146 Z +counter_last_2_days_at: 2010-06-10 21:55:17.011192 Z +counter_last_2_days: 1 +', counter_last_day = 1, counter_last_2_days = 1 + WHERE id = 1 + + Counter Load (0.4ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + Counter Load (6.3ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (3.1ms) BEGIN + Counter Update (0.7ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_day: 1\ncounter_last_day_at: 2010-06-10 21:55:17.011146 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-10 21:55:17.011192 Z\n' WHERE `id` = 1 + SQL (2.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 + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 2 +counter_last_day_at: 2010-06-11 21:55:17.053983 Z +counter_last_2_days_at: 2010-06-10 21:55:17.011192 Z +counter_last_2_days: 1 +', 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 + 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_day: 2\ncounter_last_day_at: 2010-06-11 21:55:17.053983 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-10 21:55:17.011192 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (9.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 + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 3 +counter_last_day_at: &id001 2010-06-12 21:55:17.146939 Z +counter_last_2_days_at: *id001 +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 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (0.3ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.1ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (1.6ms) DROP TABLE `counters` + SQL (0.6ms) 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 (30.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_data` varchar(2048)) ENGINE=InnoDB + SQL (0.6ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.6ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_data`, `counter_last_day`, `counter`, `counter_last_2_days`) VALUES(NULL, NULL, 1, NULL) + SQL (0.5ms) COMMIT + SQL (0.3ms) SHOW TABLES + SQL (1.3ms) SHOW FIELDS FROM `counters` + SQL (1.9ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.8ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days + FROM counters + + SQL (0.7ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 1 +counter_last_day_at: 2010-06-10 21:55:50.869436 Z +counter_last_2_days_at: 2010-06-10 21:55:50.869483 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.2ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_day: 1\ncounter_last_day_at: 2010-06-10 21:55:50.869436 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-10 21:55:50.869483 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (0.5ms) COMMIT + SQL (0.3ms) SHOW TABLES + SQL (1.3ms) SHOW FIELDS FROM `counters` + SQL (1.6ms) 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-10 21:55:50.869436 Z +counter_last_2_days_at: 2010-06-10 21:55:50.869483 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.6ms) 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-10 21:55:50.869436 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-10 21:55:50.869483 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 + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 3 +counter_last_day_at: 2010-06-11 21:55:50.887279 Z +counter_last_2_days_at: 2010-06-10 21:55:50.869483 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.4ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (0.3ms) BEGIN + Counter Update (0.4ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_day: 3\ncounter_last_day_at: 2010-06-11 21:55:50.887279 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-10 21:55:50.869483 Z\n' 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: 3 +counter_last_day_at: &id001 2010-06-12 21:55:50.919734 Z +counter_last_2_days_at: *id001 +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 + 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 (13.5ms) DROP TABLE `counters` + SQL (7.4ms) 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 (11.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 (5.5ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (15.1ms) SHOW FIELDS FROM `counters` + SQL (7.4ms) BEGIN + Counter Create (13.7ms) INSERT INTO `counters` (`counter_data`, `counter_last_day`, `counter`, `counter_last_2_days`) VALUES(NULL, NULL, 1, NULL) + SQL (5.7ms) COMMIT + SQL (6.5ms) SHOW TABLES + SQL (14.1ms) SHOW FIELDS FROM `counters` + SQL (8.7ms) SHOW FIELDS FROM `schema_migrations` + SQL (7.6ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days + FROM counters + + SQL (10.9ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 1 +counter_last_day_at: 2010-06-10 21:55:59.386527 Z +counter_last_2_days_at: 2010-06-10 21:55:59.386573 Z +counter_last_2_days: 1 +', counter_last_day = 0, counter_last_2_days = 0 + WHERE id = 1 + + Counter Load (0.3ms) 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_day: 1\ncounter_last_day_at: 2010-06-10 21:55:59.386527 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-10 21:55:59.386573 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (6.5ms) COMMIT + SQL (4.7ms) SHOW TABLES + SQL (10.2ms) SHOW FIELDS FROM `counters` + SQL (1.3ms) SHOW FIELDS FROM `schema_migrations` + SQL (1.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days + FROM counters + + SQL (6.1ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 1 +counter_last_day_at: 2010-06-10 21:55:59.386527 Z +counter_last_2_days_at: 2010-06-10 21:55:59.386573 Z +counter_last_2_days: 1 +', counter_last_day = 1, counter_last_2_days = 1 + WHERE id = 1 + + Counter Load (0.3ms) 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.8ms) BEGIN + Counter Update (0.3ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_day: 1\ncounter_last_day_at: 2010-06-10 21:55:59.386527 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-10 21:55:59.386573 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (2.3ms) 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-11 21:55:59.446753 Z +counter_last_2_days_at: 2010-06-10 21:55:59.386573 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 (5.6ms) SELECT * FROM `counters` ORDER BY counters.id DESC LIMIT 1 + SQL (2.2ms) BEGIN + Counter Update (1.9ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_day: 3\ncounter_last_day_at: 2010-06-11 21:55:59.446753 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-10 21:55:59.386573 Z\n' WHERE `id` = 1 + SQL (1.1ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 3 +counter_last_day_at: &id001 2010-06-12 21:55:59.491493 Z +counter_last_2_days_at: *id001 +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 + SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 + SQL (27.4ms) SHOW TABLES + SQL (0.3ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.6ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (0.2ms) SHOW TABLES + SQL (0.7ms) SELECT version FROM schema_migrations + SQL (0.2ms) SHOW TABLES + SQL (0.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (57.8ms) DROP TABLE `counters` + SQL (29.7ms) 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 (5.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 (2.1ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.5ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_data`, `counter_last_day`, `counter`, `counter_last_2_days`) VALUES(NULL, NULL, 1, NULL) + SQL (10.7ms) COMMIT + SQL (0.3ms) SHOW TABLES + SQL (15.3ms) SHOW FIELDS FROM `counters` + SQL (199.7ms) SHOW FIELDS FROM `schema_migrations` + SQL (9.4ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days + FROM counters + + SQL (33.6ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 1 +counter_last_day_at: 2010-06-10 22:13:23.563986 Z +counter_last_2_days_at: 2010-06-10 22:13:23.564031 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.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_day: 1\ncounter_last_day_at: 2010-06-10 22:13:23.563986 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-10 22:13:23.564031 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (27.9ms) COMMIT + SQL (0.3ms) SHOW TABLES + SQL (21.0ms) SHOW FIELDS FROM `counters` + SQL (101.3ms) SHOW FIELDS FROM `schema_migrations` + SQL (2.1ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days + FROM counters + + SQL (8.9ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 1 +counter_last_day_at: 2010-06-10 22:13:23.563986 Z +counter_last_2_days_at: 2010-06-10 22:13:23.564031 Z +counter_last_2_days: 1 +', counter_last_day = 1, counter_last_2_days = 1 + WHERE id = 1 + + Counter Load (0.5ms) 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: 1\ncounter_last_day_at: 2010-06-10 22:13:23.563986 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-10 22:13:23.564031 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (10.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 + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 3 +counter_last_day_at: 2010-06-11 22:13:23.787982 Z +counter_last_2_days_at: 2010-06-10 22:13:23.564031 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 (2.0ms) 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-11 22:13:23.787982 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-10 22:13:23.564031 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (11.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: &id001 2010-06-12 22:13:24.046356 Z +counter_last_2_days_at: *id001 +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.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.6ms) DROP TABLE `counters` + SQL (1.4ms) 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.2ms) SELECT version FROM schema_migrations +Migrating to Counters (1) + SQL (36.3ms) CREATE TABLE `counters` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `counter` int(11), `counter_last_day` int(11), `counter_last_2_days` int(11), `counter_data` varchar(2048)) ENGINE=InnoDB + SQL (0.7ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.9ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_data`, `counter_last_day`, `counter`, `counter_last_2_days`) VALUES(NULL, NULL, 1, NULL) + SQL (12.0ms) COMMIT + SQL (0.3ms) SHOW TABLES + SQL (1.3ms) SHOW FIELDS FROM `counters` + SQL (1.5ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.3ms)  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-10 22:13:46.107266 Z +counter_last_2_days_at: 2010-06-10 22:13:46.107311 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.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_day: 1\ncounter_last_day_at: 2010-06-10 22:13:46.107266 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-10 22:13:46.107311 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (1.0ms) COMMIT + SQL (0.4ms) SHOW TABLES + SQL (1.3ms) SHOW FIELDS FROM `counters` + SQL (1.5ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.6ms)  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-10 22:13:46.107266 Z +counter_last_2_days_at: 2010-06-10 22:13:46.107311 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.2ms) UPDATE `counters` SET `counter_data` = '--- \ncounter_last_day: 1\ncounter_last_day_at: 2010-06-10 22:13:46.107266 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-10 22:13:46.107311 Z\n', `counter` = 3 WHERE `id` = 1 + SQL (0.4ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_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-11 22:13:46.125411 Z +counter_last_2_days_at: 2010-06-10 22:13:46.107311 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.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_day: 3\ncounter_last_day_at: 2010-06-11 22:13:46.125411 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-10 22:13:46.107311 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 + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 4 +counter_last_day_at: &id001 2010-06-12 22:13:46.139238 Z +counter_last_2_days_at: *id001 +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.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.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 (75.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_data` varchar(2048)) ENGINE=InnoDB + SQL (0.6ms) INSERT INTO schema_migrations (version) VALUES ('1') + Counter Columns (1.5ms) SHOW FIELDS FROM `counters` + SQL (0.1ms) BEGIN + Counter Create (0.3ms) INSERT INTO `counters` (`counter_data`, `counter_last_day`, `counter`, `counter_last_2_days`) VALUES(NULL, NULL, 1, NULL) + SQL (0.4ms) COMMIT + SQL (0.3ms) SHOW TABLES + SQL (1.3ms) SHOW FIELDS FROM `counters` + SQL (1.6ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.6ms)  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-10 22:18:56.274766 Z +counter_last_2_days_at: 2010-06-10 22:18:56.274810 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.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-10 22:18:56.274766 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-10 22:18:56.274810 Z\n', `counter` = 2 WHERE `id` = 1 + SQL (10.8ms) COMMIT + SQL (0.3ms) SHOW TABLES + SQL (1.3ms) SHOW FIELDS FROM `counters` + SQL (1.6ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.6ms)  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-10 22:18:56.274766 Z +counter_last_2_days_at: 2010-06-10 22:18:56.274810 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-10 22:18:56.274766 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-10 22:18:56.274810 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 + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 3 +counter_last_day_at: 2010-06-11 22:18:56.300401 Z +counter_last_2_days_at: 2010-06-10 22:18:56.274810 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-11 22:18:56.300401 Z\ncounter_last_2_days: 1\ncounter_last_2_days_at: 2010-06-10 22:18:56.274810 Z\n', `counter` = 4 WHERE `id` = 1 + SQL (1.2ms) COMMIT + SQL (0.0ms) SHOW TABLES + SQL (0.0ms) SHOW FIELDS FROM `counters` + SQL (0.0ms) SHOW FIELDS FROM `schema_migrations` + SQL (0.0ms)  SELECT id, counter, counter_data, counter_last_day, counter_last_2_days + FROM counters + + SQL (0.0ms)  UPDATE counters + SET counter_data = '--- +counter_last_day: 4 +counter_last_day_at: &id001 2010-06-12 22:18:56.313985 Z +counter_last_2_days_at: *id001 +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