gistfile1.txt

 ~ (0.034) DROP TABLE IF EXISTS `posts`
 ~ (0.015) com.mysql.jdbc.PreparedStatement@15ede11: SHOW TABLES LIKE 'posts'
 ~ (0.001) com.mysql.jdbc.PreparedStatement@3d511e: SHOW VARIABLES LIKE 'character_set_connection'
 ~ (0.001) com.mysql.jdbc.PreparedStatement@d41f3: SHOW VARIABLES LIKE 'collation_connection'
 ~ (0.771) CREATE TABLE `posts` (`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `title` VARCHAR(50), `body` TEXT, `created_at` DATE, PRIMARY KEY(`id`)) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci
 ~ (0.024) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-24')
 ~ (0.016) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-23')
 ~ (0.009) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-22')
 ~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-21')
 ~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-20')
 ~ (0.024) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-19')
 ~ (0.020) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-18')
 ~ (0.036) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-17')
 ~ (0.019) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-16')
 ~ (0.008) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-15')
 ~ (0.062) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-14')
 ~ (0.003) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-13')
 ~ (0.013) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-12')
 ~ (0.021) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-11')
 ~ (0.016) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-10')
 ~ (0.023) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-09')
 ~ (0.011) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-08')
 ~ (0.038) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-07')
 ~ (0.019) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-06')
 ~ (0.028) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-05')
 ~ (0.010) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-04')
 ~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-03')
 ~ (0.011) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-02')
 ~ (0.029) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-04-01')
 ~ (0.010) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-31')
 ~ (0.021) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-30')
 ~ (0.024) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-29')
 ~ (0.027) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-28')
 ~ (0.026) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-27')
 ~ (0.017) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-26')
 ~ (0.019) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-25')
 ~ (0.030) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-24')
 ~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-23')
 ~ (0.007) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-22')
 ~ (0.008) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-21')
 ~ (0.018) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-20')
 ~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-19')
 ~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-18')
 ~ (0.011) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-17')
 ~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-16')
 ~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-15')
 ~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-14')
 ~ (0.026) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-13')
 ~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-12')
 ~ (0.012) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-11')
 ~ (0.031) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-10')
 ~ (0.005) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-09')
 ~ (0.012) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-08')
 ~ (0.027) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-07')
 ~ (0.026) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-06')
 ~ (0.004) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-05')
 ~ (0.054) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-04')
 ~ (0.052) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-03')
 ~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-02')
 ~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-03-01')
 ~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-28')
 ~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-27')
 ~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-26')
 ~ (0.016) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-25')
 ~ (0.007) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-24')
 ~ (0.009) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-23')
 ~ (0.024) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-22')
 ~ (0.021) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-21')
 ~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-20')
 ~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-19')
 ~ (0.004) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-18')
 ~ (0.003) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-17')
 ~ (0.003) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-16')
 ~ (0.004) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-15')
 ~ (0.004) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-14')
 ~ (0.004) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-13')
 ~ (0.004) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-12')
 ~ (0.013) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-11')
 ~ (0.014) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-10')
 ~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-09')
 ~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-08')
 ~ (0.042) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-07')
 ~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-06')
 ~ (0.086) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-05')
 ~ (0.004) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-04')
 ~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-03')
 ~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-02')
 ~ (0.001) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-02-01')
 ~ (0.003) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-31')
 ~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-30')
 ~ (0.002) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-29')
 ~ (0.000) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-28')
 ~ (0.003) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-27')
 ~ (0.012) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-26')
 ~ (0.023) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-25')
 ~ (0.004) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-24')
 ~ (0.034) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-23')
 ~ (0.037) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-22')
 ~ (0.008) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-21')
 ~ (0.009) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-20')
 ~ (0.013) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-19')
 ~ (0.020) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-18')
 ~ (0.030) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-17')
 ~ (0.006) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-16')
 ~ (0.020) INSERT INTO `posts` (`title`, `body`, `created_at`) VALUES ('foo', 'adngksbfsf kvbsdfblsf vksfbkvbsf', '2010-01-15')
 ~ (0.030) SELECT `id`, `title`, `created_at` FROM `posts` WHERE `created_at` <= '0019-10-01' ORDER BY `id`