Connecting to database specified by database.yml Connecting to database specified by database.yml  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.2ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.0ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.0ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.redirect_rules' doesn't exist: SHOW FULL FIELDS FROM `redirect_rules`  (0.1ms) ROLLBACK  (0.0ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.request_environment_rules' doesn't exist: SHOW FULL FIELDS FROM `request_environment_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.request_environment_rules' doesn't exist: SHOW FULL FIELDS FROM `request_environment_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.request_environment_rules' doesn't exist: SHOW FULL FIELDS FROM `request_environment_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.request_environment_rules' doesn't exist: SHOW FULL FIELDS FROM `request_environment_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.request_environment_rules' doesn't exist: SHOW FULL FIELDS FROM `request_environment_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.request_environment_rules' doesn't exist: SHOW FULL FIELDS FROM `request_environment_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.request_environment_rules' doesn't exist: SHOW FULL FIELDS FROM `request_environment_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.request_environment_rules' doesn't exist: SHOW FULL FIELDS FROM `request_environment_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.request_environment_rules' doesn't exist: SHOW FULL FIELDS FROM `request_environment_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.request_environment_rules' doesn't exist: SHOW FULL FIELDS FROM `request_environment_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.request_environment_rules' doesn't exist: SHOW FULL FIELDS FROM `request_environment_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.request_environment_rules' doesn't exist: SHOW FULL FIELDS FROM `request_environment_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.request_environment_rules' doesn't exist: SHOW FULL FIELDS FROM `request_environment_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.request_environment_rules' doesn't exist: SHOW FULL FIELDS FROM `request_environment_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.request_environment_rules' doesn't exist: SHOW FULL FIELDS FROM `request_environment_rules`  (0.1ms) ROLLBACK  (0.1ms) BEGIN Mysql2::Error: Table 'redirector_dummy_test.request_environment_rules' doesn't exist: SHOW FULL FIELDS FROM `request_environment_rules`  (0.1ms) ROLLBACK Connecting to database specified by database.yml  (10.4ms) CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB  (13.0ms) CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`)  (0.1ms) SELECT `schema_migrations`.`version` FROM `schema_migrations`  Migrating to CreateRedirectRules (20120815212612)  (7.3ms) CREATE TABLE `redirect_rules` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `source` varchar(255) NOT NULL, `source_is_regex` tinyint(1) DEFAULT 0 NOT NULL, `source_is_case_sensitive` tinyint(1) DEFAULT 0 NOT NULL, `destination` varchar(255) NOT NULL, `active` tinyint(1) DEFAULT 0, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL) ENGINE=InnoDB  (9.5ms) CREATE INDEX `index_redirect_rules_on_source` ON `redirect_rules` (`source`)  (11.1ms) CREATE INDEX `index_redirect_rules_on_active` ON `redirect_rules` (`active`)  (11.5ms) CREATE INDEX `index_redirect_rules_on_source_is_regex` ON `redirect_rules` (`source_is_regex`)  (15.3ms) CREATE INDEX `index_redirect_rules_on_source_is_case_sensitive` ON `redirect_rules` (`source_is_case_sensitive`)  (0.3ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20120815212612') Migrating to CreateRequestEnvironmentRules (20120823163756)  (8.0ms) CREATE TABLE `request_environment_rules` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `redirect_rule_id` int(11) NOT NULL, `environment_key_name` varchar(255) NOT NULL, `environment_value` varchar(255) NOT NULL, `environment_value_is_regex` tinyint(1) DEFAULT 0 NOT NULL, `environment_value_is_case_sensitive` tinyint(1) DEFAULT 1 NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL) ENGINE=InnoDB  (9.7ms) CREATE INDEX `index_request_environment_rules_on_redirect_rule_id` ON `request_environment_rules` (`redirect_rule_id`)  (0.4ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20120823163756')  (0.1ms) SELECT `schema_migrations`.`version` FROM `schema_migrations`  Connecting to database specified by database.yml  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', '/news/5', '/my_custom_url', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', '/news/$1', '/my_custom_url/([A-Za-z0-9_]+)', 0, 1, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', '/news', 'categoryID=12345', 0, 1, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1 RedirectRule Load (1.0ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/my_custom_url') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/my_custom_url' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/my_custom_url' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC RequestEnvironmentRule Load (0.2ms) SELECT `request_environment_rules`.* FROM `request_environment_rules` WHERE `request_environment_rules`.`redirect_rule_id` IN (1) RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/news/5') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/news/5' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/news/5' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC Started GET "/news/5" for 127.0.0.1 at 2014-01-16 15:58:20 -0700 Processing by NewsController#show as HTML Parameters: {"id"=>"5"} Rendered text template (0.0ms) Completed 200 OK in 4ms (Views: 3.7ms | ActiveRecord: 0.0ms)  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', '/news/5', '/my_custom_url', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', '/news/$1', '/my_custom_url/([A-Za-z0-9_]+)', 0, 1, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', '/news', 'categoryID=12345', 0, 1, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1 RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/my_custom_url/20') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/my_custom_url/20' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/my_custom_url/20' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC RequestEnvironmentRule Load (0.1ms) SELECT `request_environment_rules`.* FROM `request_environment_rules` WHERE `request_environment_rules`.`redirect_rule_id` IN (5) RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/news/20') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/news/20' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/news/20' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC Started GET "/news/20" for 127.0.0.1 at 2014-01-16 15:58:20 -0700 Processing by NewsController#show as HTML Parameters: {"id"=>"20"} Rendered text template (0.0ms) Completed 200 OK in 0ms (Views: 0.2ms | ActiveRecord: 0.0ms)  (0.5ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', '/news/5', '/my_custom_url', 0, 0, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', '/news/$1', '/my_custom_url/([A-Za-z0-9_]+)', 0, 1, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', '/news', 'categoryID=12345', 0, 1, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1 RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/my_old_url') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/my_old_url' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/my_old_url' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC Started GET "/my_old_url?categoryID=12345" for 127.0.0.1 at 2014-01-16 15:58:20 -0700 ActionController::RoutingError (No route matches [GET] "/my_old_url"): actionpack (3.2.11) lib/action_dispatch/middleware/debug_exceptions.rb:21:in `call' actionpack (3.2.11) lib/action_dispatch/middleware/show_exceptions.rb:56:in `call' railties (3.2.11) lib/rails/rack/logger.rb:32:in `call_app' railties (3.2.11) lib/rails/rack/logger.rb:16:in `block in call' activesupport (3.2.11) lib/active_support/tagged_logging.rb:22:in `tagged' railties (3.2.11) lib/rails/rack/logger.rb:16:in `call' actionpack (3.2.11) lib/action_dispatch/middleware/request_id.rb:22:in `call' rack (1.4.5) lib/rack/methodoverride.rb:21:in `call' rack (1.4.5) lib/rack/runtime.rb:17:in `call' /Users/brianlandau/Projects/redirector/lib/redirector/middleware.rb:25:in `response' /Users/brianlandau/Projects/redirector/lib/redirector/middleware.rb:10:in `call' activesupport (3.2.11) lib/active_support/cache/strategy/local_cache.rb:72:in `call' rack (1.4.5) lib/rack/lock.rb:15:in `call' actionpack (3.2.11) lib/action_dispatch/middleware/static.rb:62:in `call' railties (3.2.11) lib/rails/engine.rb:479:in `call' railties (3.2.11) lib/rails/application.rb:223:in `call' rack (1.4.5) lib/rack/builder.rb:134:in `call' rack (1.4.5) lib/rack/urlmap.rb:64:in `block in call' rack (1.4.5) lib/rack/urlmap.rb:49:in `each' rack (1.4.5) lib/rack/urlmap.rb:49:in `call' rack-test (0.6.2) lib/rack/mock_session.rb:30:in `request' rack-test (0.6.2) lib/rack/test.rb:230:in `process_request' rack-test (0.6.2) lib/rack/test.rb:57:in `get' /Users/brianlandau/.rbenv/versions/2.1.0/lib/ruby/2.1.0/forwardable.rb:183:in `get' capybara (2.2.1) lib/capybara/rack_test/browser.rb:60:in `process' capybara (2.2.1) lib/capybara/rack_test/browser.rb:35:in `process_and_follow_redirects' capybara (2.2.1) lib/capybara/rack_test/browser.rb:21:in `visit' capybara (2.2.1) lib/capybara/rack_test/driver.rb:42:in `visit' capybara (2.2.1) lib/capybara/session.rb:197:in `visit' capybara (2.2.1) lib/capybara/dsl.rb:51:in `block (2 levels) in ' /Users/brianlandau/Projects/redirector/spec/features/middleware_spec.rb:21:in `block (2 levels) in ' rspec-core (2.14.7) lib/rspec/core/example.rb:114:in `instance_eval' rspec-core (2.14.7) lib/rspec/core/example.rb:114:in `block in run' rspec-core (2.14.7) lib/rspec/core/example.rb:254:in `with_around_each_hooks' rspec-core (2.14.7) lib/rspec/core/example.rb:111:in `run' rspec-core (2.14.7) lib/rspec/core/example_group.rb:390:in `block in run_examples' rspec-core (2.14.7) lib/rspec/core/example_group.rb:386:in `map' rspec-core (2.14.7) lib/rspec/core/example_group.rb:386:in `run_examples' rspec-core (2.14.7) lib/rspec/core/example_group.rb:371:in `run' rspec-core (2.14.7) lib/rspec/core/command_line.rb:28:in `block (2 levels) in run' rspec-core (2.14.7) lib/rspec/core/command_line.rb:28:in `map' rspec-core (2.14.7) lib/rspec/core/command_line.rb:28:in `block in run' rspec-core (2.14.7) lib/rspec/core/reporter.rb:58:in `report' rspec-core (2.14.7) lib/rspec/core/command_line.rb:25:in `run' rspec-core (2.14.7) lib/rspec/core/runner.rb:80:in `run' rspec-core (2.14.7) lib/rspec/core/runner.rb:17:in `block in autorun' Rendered /Users/brianlandau/.rbenv/versions/2.1.0/lib/ruby/gems/2.1.0/gems/actionpack-3.2.11/lib/action_dispatch/middleware/templates/rescues/routing_error.erb within rescues/layout (1.1ms)  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', '/news/5', '/my_custom_url', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', '/news/$1', '/my_custom_url/([A-Za-z0-9_]+)', 0, 1, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', '/news', 'categoryID=12345', 0, 1, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1 RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/my_old_url?categoryID=12345') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/my_old_url?categoryID=12345' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/my_old_url?categoryID=12345' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC RequestEnvironmentRule Load (0.2ms) SELECT `request_environment_rules`.* FROM `request_environment_rules` WHERE `request_environment_rules`.`redirect_rule_id` IN (12) RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/news') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/news' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/news' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC Started GET "/news" for 127.0.0.1 at 2014-01-16 15:58:20 -0700 Processing by NewsController#index as HTML Rendered text template (0.0ms) Completed 200 OK in 1ms (Views: 0.3ms | ActiveRecord: 0.0ms)  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', '/news/5', '/my_custom_url', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', '/news/$1', '/my_custom_url/([A-Za-z0-9_]+)', 0, 1, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', '/news', 'categoryID=12345', 0, 1, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1 RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/my_custom_url') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/my_custom_url' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/my_custom_url' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC RequestEnvironmentRule Load (0.2ms) SELECT `request_environment_rules`.* FROM `request_environment_rules` WHERE `request_environment_rules`.`redirect_rule_id` IN (13) RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/news/5') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/news/5' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/news/5' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC Started GET "/news/5" for 127.0.0.1 at 2014-01-16 15:58:20 -0700 Processing by NewsController#show as HTML Parameters: {"id"=>"5"} Rendered text template (0.0ms) Completed 200 OK in 0ms (Views: 0.2ms | ActiveRecord: 0.0ms) RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/my_custom_url') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/my_custom_url' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/my_custom_url' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC RequestEnvironmentRule Load (0.1ms) SELECT `request_environment_rules`.* FROM `request_environment_rules` WHERE `request_environment_rules`.`redirect_rule_id` IN (13) RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/news/5') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/news/5' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/news/5' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC Started GET "/news/5" for 127.0.0.1 at 2014-01-16 15:58:20 -0700 Processing by NewsController#show as HTML Parameters: {"id"=>"5"} Rendered text template (0.0ms) Completed 200 OK in 0ms (Views: 0.2ms | ActiveRecord: 0.0ms)  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', '/news/5', '/my_custom_url', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', '/news/$1', '/my_custom_url/([A-Za-z0-9_]+)', 0, 1, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', '/news', 'categoryID=12345', 0, 1, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com$1', '^/custom(.*)$', 0, 1, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1 RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/custom)%e2') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/custom)%e2' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/custom)%e2' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC RequestEnvironmentRule Load (0.1ms) SELECT `request_environment_rules`.* FROM `request_environment_rules` WHERE `request_environment_rules`.`redirect_rule_id` IN (19) RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/custom)%e2') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/custom)%e2' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/custom)%e2' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC RequestEnvironmentRule Load (0.2ms) SELECT `request_environment_rules`.* FROM `request_environment_rules` WHERE `request_environment_rules`.`redirect_rule_id` IN (19)  (0.6ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.2ms) ROLLBACK  (0.1ms) BEGIN  (0.0ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.3ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.6ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.6ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.8ms) ROLLBACK  (0.1ms) BEGIN  (0.2ms) SAVEPOINT active_record_1 SQL (0.4ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.2ms) RELEASE SAVEPOINT active_record_1  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1 RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/someplace') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/someplace' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/someplace' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC  (0.6ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1 RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/catchy_thingy') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/catchy_thingy' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/catchy_thingy' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC RequestEnvironmentRule Load (0.1ms) SELECT `request_environment_rules`.* FROM `request_environment_rules` WHERE `request_environment_rules`.`redirect_rule_id` IN (38)  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/news/$1', '[A-Za-z0-9_]+shiny\\/([A-Za-z0-9_]+)', 1, 1, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1 RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/new_shiny/from_company') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/new_shiny/from_company' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/new_shiny/from_company' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC RequestEnvironmentRule Load (0.1ms) SELECT `request_environment_rules`.* FROM `request_environment_rules` WHERE `request_environment_rules`.`redirect_rule_id` IN (40)  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/news/$1', '[A-Za-z0-9_]+shiny\\/([A-Za-z0-9_]+)', 1, 1, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1 RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/new_SHINY/from_company') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/new_SHINY/from_company' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/new_SHINY/from_company' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/news/$1', '[A-Za-z0-9_]+shiny\\/([A-Za-z0-9_]+)', 0, 1, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1 RedirectRule Load (0.5ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/new_shiny/from_company') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/new_shiny/from_company' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/new_shiny/from_company' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC RequestEnvironmentRule Load (0.2ms) SELECT `request_environment_rules`.* FROM `request_environment_rules` WHERE `request_environment_rules`.`redirect_rule_id` IN (44)  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/news/$1', '[A-Za-z0-9_]+shiny\\/([A-Za-z0-9_]+)', 0, 1, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1 RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/new_SHINY/from_company') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/new_SHINY/from_company' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/new_SHINY/from_company' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC RequestEnvironmentRule Load (0.1ms) SELECT `request_environment_rules`.* FROM `request_environment_rules` WHERE `request_environment_rules`.`redirect_rule_id` IN (46)  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.5ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'SERVER_NAME', 'example.com', 1, 0, 47, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1 RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/catchy_thingy') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/catchy_thingy' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/catchy_thingy' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC RequestEnvironmentRule Load (0.2ms) SELECT `request_environment_rules`.* FROM `request_environment_rules` WHERE `request_environment_rules`.`redirect_rule_id` IN (47)  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'SERVER_NAME', 'example.com', 1, 0, 48, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1 RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/catchy_thingy') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/catchy_thingy' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/catchy_thingy' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC RequestEnvironmentRule Load (0.2ms) SELECT `request_environment_rules`.* FROM `request_environment_rules` WHERE `request_environment_rules`.`redirect_rule_id` IN (48)  (2.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'SERVER_NAME', 'example.com', 1, 0, 49, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'QUERY_STRING', 'something=value', 1, 1, 49, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1 RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/catchy_thingy') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/catchy_thingy' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/catchy_thingy' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC RequestEnvironmentRule Load (0.2ms) SELECT `request_environment_rules`.* FROM `request_environment_rules` WHERE `request_environment_rules`.`redirect_rule_id` IN (49)  (0.8ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'SERVER_NAME', 'example.com', 1, 0, 50, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'QUERY_STRING', 'something=value', 1, 1, 50, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1 RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/catchy_thingy') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/catchy_thingy' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/catchy_thingy' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC RequestEnvironmentRule Load (0.1ms) SELECT `request_environment_rules`.* FROM `request_environment_rules` WHERE `request_environment_rules`.`redirect_rule_id` IN (50)  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.6ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'SERVER_NAME', 'example.com', 1, 0, 51, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'QUERY_STRING', 'something=value', 1, 1, 51, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'SERVER_NAME', 'example.com', 1, 0, 52, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'QUERY_STRING', 'another=value', 1, 1, 52, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1 RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/catchy_thingy') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/catchy_thingy' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/catchy_thingy' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC RequestEnvironmentRule Load (0.1ms) SELECT `request_environment_rules`.* FROM `request_environment_rules` WHERE `request_environment_rules`.`redirect_rule_id` IN (51, 52)  (0.6ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'SERVER_NAME', 'example.com', 1, 0, 53, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'QUERY_STRING', 'something=value', 1, 1, 53, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'SERVER_NAME', 'example.com', 1, 0, 54, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'QUERY_STRING', 'another=value', 1, 1, 54, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1 RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/catchy_thingy') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/catchy_thingy' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/catchy_thingy' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC RequestEnvironmentRule Load (0.2ms) SELECT `request_environment_rules`.* FROM `request_environment_rules` WHERE `request_environment_rules`.`redirect_rule_id` IN (53, 54)  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'SERVER_NAME', 'example.com', 1, 0, 55, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'QUERY_STRING', 'something=value', 1, 1, 55, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'SERVER_NAME', 'example.com', 1, 0, 56, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'QUERY_STRING', 'another=value', 1, 1, 56, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1 RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/catchy_thingy') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/catchy_thingy' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/catchy_thingy' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC RequestEnvironmentRule Load (0.1ms) SELECT `request_environment_rules`.* FROM `request_environment_rules` WHERE `request_environment_rules`.`redirect_rule_id` IN (55, 56)  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/news/$1', '[A-Za-z0-9]_thingy', 0, 1, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1 RedirectRule Load (0.5ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/catchy_thingy') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/catchy_thingy' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/catchy_thingy' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC RequestEnvironmentRule Load (0.2ms) SELECT `request_environment_rules`.* FROM `request_environment_rules` WHERE `request_environment_rules`.`redirect_rule_id` IN (57, 58)  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/news/$1', '[A-Za-z0-9_]+shiny\\/([A-Za-z0-9_]+)', 0, 1, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1 RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/new_shiny/from_company') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/new_shiny/from_company' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/new_shiny/from_company' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC RequestEnvironmentRule Load (0.1ms) SELECT `request_environment_rules`.* FROM `request_environment_rules` WHERE `request_environment_rules`.`redirect_rule_id` IN (60)  (0.5ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/news/$1', '[A-Za-z0-9_]+shiny\\/([A-Za-z0-9_]+)', 0, 1, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1 RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/catchy_thingy') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/catchy_thingy' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/catchy_thingy' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC RequestEnvironmentRule Load (0.1ms) SELECT `request_environment_rules`.* FROM `request_environment_rules` WHERE `request_environment_rules`.`redirect_rule_id` IN (61)  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/news/$1', '[A-Za-z0-9_]+shiny\\/([A-Za-z0-9_]+)', 0, 1, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1 RedirectRule Load (0.3ms) SELECT `redirect_rules`.* FROM `redirect_rules` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/someplace') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/someplace' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/someplace' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/news/$1', '[A-Za-z0-9_]+shiny\\/([A-Za-z0-9_]+)', 0, 1, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'SERVER_NAME', 'example.com', 1, 0, 68, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.5ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'SERVER_NAME', 'example.com', 1, 0, 69, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.5ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'SERVER_NAME', 'example.com', 1, 0, 70, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'SERVER_NAME', 'example.com', 1, 0, 71, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.5ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'SERVER_NAME', 'example.com', 1, 0, 72, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.4ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'SERVER_NAME', 'example.com', 1, 0, 73, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'SERVER_NAME', 'example.com', 1, 0, 74, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'SERVER_NAME', 'example.com', 1, 0, 75, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.5ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.3ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'SERVER_NAME', 'example.com', 1, 0, 76, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'SERVER_NAME', 'example.com', 1, 0, 77, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'SERVER_NAME', 'example.com', 1, 0, 78, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'SERVER_NAME', 'example.com', 1, 0, 79, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.0ms) BEGIN  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'SERVER_NAME', 'example.com', 1, 0, 81, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.0ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.0ms) RELEASE SAVEPOINT active_record_1  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'QUERY_STRING', 'something=value', 1, 1, 82, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.6ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:20', 'http://www.example.com/products/1', '/catchy_thingy', 0, 0, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:20', 'QUERY_STRING', 'something=value', 0, 1, 83, '2014-01-16 22:58:20')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.3ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', '/news/5', '/my_custom_url', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', '/news/$1', '/my_custom_url/([A-Za-z0-9_]+)', 1, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', '/news', 'categoryID=12345', 1, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1 SQL (0.5ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/my_custom_url') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/my_custom_url' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/my_custom_url' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC SQL (0.5ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/news/5') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/news/5' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/news/5' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC Started GET "/news/5" for 127.0.0.1 at 2014-01-16 15:58:23 -0700 Processing by NewsController#show as HTML Parameters: {"id"=>"5"} Rendered text template (0.0ms) Completed 200 OK in 7ms (Views: 6.3ms | ActiveRecord: 0.0ms)  (0.5ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', '/news/5', '/my_custom_url', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', '/news/$1', '/my_custom_url/([A-Za-z0-9_]+)', 1, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', '/news', 'categoryID=12345', 1, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1 SQL (0.4ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/my_custom_url/20') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/my_custom_url/20' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/my_custom_url/20' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC SQL (0.4ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/news/20') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/news/20' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/news/20' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC Started GET "/news/20" for 127.0.0.1 at 2014-01-16 15:58:23 -0700 Processing by NewsController#show as HTML Parameters: {"id"=>"20"} Rendered text template (0.0ms) Completed 200 OK in 0ms (Views: 0.2ms | ActiveRecord: 0.0ms)  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', '/news/5', '/my_custom_url', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.4ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', '/news/$1', '/my_custom_url/([A-Za-z0-9_]+)', 1, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.3ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', '/news', 'categoryID=12345', 1, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1 SQL (0.9ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/my_old_url') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/my_old_url' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/my_old_url' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC Started GET "/my_old_url?categoryID=12345" for 127.0.0.1 at 2014-01-16 15:58:23 -0700 ActionController::RoutingError (No route matches [GET] "/my_old_url"): actionpack (4.0.2) lib/action_dispatch/middleware/debug_exceptions.rb:21:in `call' actionpack (4.0.2) lib/action_dispatch/middleware/show_exceptions.rb:30:in `call' railties (4.0.2) lib/rails/rack/logger.rb:38:in `call_app' railties (4.0.2) lib/rails/rack/logger.rb:20:in `block in call' activesupport (4.0.2) lib/active_support/tagged_logging.rb:67:in `block in tagged' activesupport (4.0.2) lib/active_support/tagged_logging.rb:25:in `tagged' activesupport (4.0.2) lib/active_support/tagged_logging.rb:67:in `tagged' railties (4.0.2) lib/rails/rack/logger.rb:20:in `call' actionpack (4.0.2) lib/action_dispatch/middleware/request_id.rb:21:in `call' rack (1.5.2) lib/rack/methodoverride.rb:21:in `call' rack (1.5.2) lib/rack/runtime.rb:17:in `call' /Users/brianlandau/Projects/redirector/lib/redirector/middleware.rb:25:in `response' /Users/brianlandau/Projects/redirector/lib/redirector/middleware.rb:10:in `call' activesupport (4.0.2) lib/active_support/cache/strategy/local_cache.rb:83:in `call' actionpack (4.0.2) lib/action_dispatch/middleware/static.rb:64:in `call' rack (1.5.2) lib/rack/sendfile.rb:112:in `call' railties (4.0.2) lib/rails/engine.rb:511:in `call' railties (4.0.2) lib/rails/application.rb:97:in `call' rack (1.5.2) lib/rack/builder.rb:138:in `call' rack (1.5.2) lib/rack/urlmap.rb:65:in `block in call' rack (1.5.2) lib/rack/urlmap.rb:50:in `each' rack (1.5.2) lib/rack/urlmap.rb:50:in `call' rack-test (0.6.2) lib/rack/mock_session.rb:30:in `request' rack-test (0.6.2) lib/rack/test.rb:230:in `process_request' rack-test (0.6.2) lib/rack/test.rb:57:in `get' /Users/brianlandau/.rbenv/versions/2.1.0/lib/ruby/2.1.0/forwardable.rb:183:in `get' capybara (2.2.1) lib/capybara/rack_test/browser.rb:60:in `process' capybara (2.2.1) lib/capybara/rack_test/browser.rb:35:in `process_and_follow_redirects' capybara (2.2.1) lib/capybara/rack_test/browser.rb:21:in `visit' capybara (2.2.1) lib/capybara/rack_test/driver.rb:42:in `visit' capybara (2.2.1) lib/capybara/session.rb:197:in `visit' capybara (2.2.1) lib/capybara/dsl.rb:51:in `block (2 levels) in ' /Users/brianlandau/Projects/redirector/spec/features/middleware_spec.rb:21:in `block (2 levels) in ' rspec-core (2.14.7) lib/rspec/core/example.rb:114:in `instance_eval' rspec-core (2.14.7) lib/rspec/core/example.rb:114:in `block in run' rspec-core (2.14.7) lib/rspec/core/example.rb:179:in `call' rspec-core (2.14.7) lib/rspec/core/example.rb:179:in `run' rspec-rails (2.14.1) lib/rspec/rails/adapters.rb:68:in `block (2 levels) in ' rspec-core (2.14.7) lib/rspec/core/extensions/instance_eval_with_args.rb:16:in `instance_exec' rspec-core (2.14.7) lib/rspec/core/extensions/instance_eval_with_args.rb:16:in `instance_eval_with_args' rspec-core (2.14.7) lib/rspec/core/example.rb:247:in `instance_eval_with_args' rspec-core (2.14.7) lib/rspec/core/hooks.rb:106:in `block (2 levels) in run' rspec-core (2.14.7) lib/rspec/core/hooks.rb:108:in `call' rspec-core (2.14.7) lib/rspec/core/hooks.rb:108:in `run' rspec-core (2.14.7) lib/rspec/core/hooks.rb:446:in `run_hook' rspec-core (2.14.7) lib/rspec/core/example_group.rb:340:in `run_around_each_hooks' rspec-core (2.14.7) lib/rspec/core/example.rb:256:in `with_around_each_hooks' rspec-core (2.14.7) lib/rspec/core/example.rb:111:in `run' rspec-core (2.14.7) lib/rspec/core/example_group.rb:390:in `block in run_examples' rspec-core (2.14.7) lib/rspec/core/example_group.rb:386:in `map' rspec-core (2.14.7) lib/rspec/core/example_group.rb:386:in `run_examples' rspec-core (2.14.7) lib/rspec/core/example_group.rb:371:in `run' rspec-core (2.14.7) lib/rspec/core/command_line.rb:28:in `block (2 levels) in run' rspec-core (2.14.7) lib/rspec/core/command_line.rb:28:in `map' rspec-core (2.14.7) lib/rspec/core/command_line.rb:28:in `block in run' rspec-core (2.14.7) lib/rspec/core/reporter.rb:58:in `report' rspec-core (2.14.7) lib/rspec/core/command_line.rb:25:in `run' rspec-core (2.14.7) lib/rspec/core/runner.rb:80:in `run' rspec-core (2.14.7) lib/rspec/core/runner.rb:17:in `block in autorun' Rendered /Users/brianlandau/.rbenv/versions/2.1.0/lib/ruby/gems/2.1.0/gems/actionpack-4.0.2/lib/action_dispatch/middleware/templates/rescues/_trace.erb (0.9ms) Rendered /Users/brianlandau/.rbenv/versions/2.1.0/lib/ruby/gems/2.1.0/gems/actionpack-4.0.2/lib/action_dispatch/middleware/templates/routes/_route.html.erb (0.6ms) Rendered /Users/brianlandau/.rbenv/versions/2.1.0/lib/ruby/gems/2.1.0/gems/actionpack-4.0.2/lib/action_dispatch/middleware/templates/routes/_table.html.erb (3.0ms) Rendered /Users/brianlandau/.rbenv/versions/2.1.0/lib/ruby/gems/2.1.0/gems/actionpack-4.0.2/lib/action_dispatch/middleware/templates/rescues/routing_error.erb within rescues/layout (16.5ms)  (0.5ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', '/news/5', '/my_custom_url', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', '/news/$1', '/my_custom_url/([A-Za-z0-9_]+)', 1, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', '/news', 'categoryID=12345', 1, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1 SQL (0.4ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/my_old_url?categoryID=12345') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/my_old_url?categoryID=12345' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/my_old_url?categoryID=12345' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC SQL (0.3ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/news') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/news' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/news' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC Started GET "/news" for 127.0.0.1 at 2014-01-16 15:58:23 -0700 Processing by NewsController#index as HTML Rendered text template (0.0ms) Completed 200 OK in 0ms (Views: 0.2ms | ActiveRecord: 0.0ms)  (0.7ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', '/news/5', '/my_custom_url', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', '/news/$1', '/my_custom_url/([A-Za-z0-9_]+)', 1, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', '/news', 'categoryID=12345', 1, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1 SQL (0.4ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/my_custom_url') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/my_custom_url' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/my_custom_url' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC SQL (0.4ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/news/5') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/news/5' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/news/5' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC Started GET "/news/5" for 127.0.0.1 at 2014-01-16 15:58:23 -0700 Processing by NewsController#show as HTML Parameters: {"id"=>"5"} Rendered text template (0.0ms) Completed 200 OK in 0ms (Views: 0.3ms | ActiveRecord: 0.0ms) SQL (0.5ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/my_custom_url') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/my_custom_url' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/my_custom_url' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC SQL (0.4ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/news/5') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/news/5' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/news/5' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC Started GET "/news/5" for 127.0.0.1 at 2014-01-16 15:58:23 -0700 Processing by NewsController#show as HTML Parameters: {"id"=>"5"} Rendered text template (0.0ms) Completed 200 OK in 0ms (Views: 0.2ms | ActiveRecord: 0.0ms)  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', '/news/5', '/my_custom_url', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', '/news/$1', '/my_custom_url/([A-Za-z0-9_]+)', 1, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', '/news', 'categoryID=12345', 1, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com$1', '^/custom(.*)$', 1, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1 SQL (0.4ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/custom)%e2') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/custom)%e2' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/custom)%e2' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC SQL (0.4ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/custom)%e2') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/custom)%e2' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/custom)%e2' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.7ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.5ms) ROLLBACK  (0.2ms) BEGIN  (0.2ms) SAVEPOINT active_record_1 SQL (0.4ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.4ms) ROLLBACK  (0.2ms) BEGIN  (0.2ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1 SQL (0.5ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/someplace') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/someplace' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/someplace' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1 SQL (0.3ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/catchy_thingy') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/catchy_thingy' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/catchy_thingy' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC  (0.5ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/news/$1', '[A-Za-z0-9_]+shiny\\/([A-Za-z0-9_]+)', 1, 1, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1 SQL (0.4ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/new_shiny/from_company') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/new_shiny/from_company' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/new_shiny/from_company' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_case_sensitive`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/news/$1', '[A-Za-z0-9_]+shiny\\/([A-Za-z0-9_]+)', 1, 1, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1 SQL (0.5ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/new_SHINY/from_company') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/new_SHINY/from_company' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/new_SHINY/from_company' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC  (0.6ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/news/$1', '[A-Za-z0-9_]+shiny\\/([A-Za-z0-9_]+)', 1, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1 SQL (0.4ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/new_shiny/from_company') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/new_shiny/from_company' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/new_shiny/from_company' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/news/$1', '[A-Za-z0-9_]+shiny\\/([A-Za-z0-9_]+)', 1, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1 SQL (0.6ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/new_SHINY/from_company') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/new_SHINY/from_company' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/new_SHINY/from_company' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'SERVER_NAME', 'example.com', 130, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1 SQL (0.3ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/catchy_thingy') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/catchy_thingy' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/catchy_thingy' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'SERVER_NAME', 'example.com', 131, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1 SQL (0.4ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/catchy_thingy') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/catchy_thingy' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/catchy_thingy' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'SERVER_NAME', 'example.com', 132, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'QUERY_STRING', 'something=value', 1, 132, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1 SQL (0.3ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/catchy_thingy') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/catchy_thingy' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/catchy_thingy' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC  (0.8ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'SERVER_NAME', 'example.com', 133, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'QUERY_STRING', 'something=value', 1, 133, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1 SQL (0.4ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/catchy_thingy') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/catchy_thingy' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/catchy_thingy' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'SERVER_NAME', 'example.com', 134, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'QUERY_STRING', 'something=value', 1, 134, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'SERVER_NAME', 'example.com', 135, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'QUERY_STRING', 'another=value', 1, 135, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1 SQL (0.4ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/catchy_thingy') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/catchy_thingy' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/catchy_thingy' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'SERVER_NAME', 'example.com', 136, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'QUERY_STRING', 'something=value', 1, 136, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'SERVER_NAME', 'example.com', 137, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'QUERY_STRING', 'another=value', 1, 137, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1 SQL (0.4ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/catchy_thingy') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/catchy_thingy' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/catchy_thingy' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.3ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'SERVER_NAME', 'example.com', 138, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'QUERY_STRING', 'something=value', 1, 138, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'SERVER_NAME', 'example.com', 139, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'QUERY_STRING', 'another=value', 1, 139, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1 SQL (0.4ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/catchy_thingy') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/catchy_thingy' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/catchy_thingy' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC  (0.7ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/news/$1', '[A-Za-z0-9]_thingy', 1, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1 SQL (0.4ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/catchy_thingy') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/catchy_thingy' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/catchy_thingy' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.3ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/news/$1', '[A-Za-z0-9_]+shiny\\/([A-Za-z0-9_]+)', 1, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1 SQL (0.4ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/new_shiny/from_company') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/new_shiny/from_company' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/new_shiny/from_company' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/news/$1', '[A-Za-z0-9_]+shiny\\/([A-Za-z0-9_]+)', 1, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1 SQL (0.4ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/catchy_thingy') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/catchy_thingy' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/catchy_thingy' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/news/$1', '[A-Za-z0-9_]+shiny\\/([A-Za-z0-9_]+)', 1, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1 SQL (0.4ms) SELECT `redirect_rules`.`id` AS t0_r0, `redirect_rules`.`source` AS t0_r1, `redirect_rules`.`source_is_regex` AS t0_r2, `redirect_rules`.`source_is_case_sensitive` AS t0_r3, `redirect_rules`.`destination` AS t0_r4, `redirect_rules`.`active` AS t0_r5, `redirect_rules`.`created_at` AS t0_r6, `redirect_rules`.`updated_at` AS t0_r7, `request_environment_rules`.`id` AS t1_r0, `request_environment_rules`.`redirect_rule_id` AS t1_r1, `request_environment_rules`.`environment_key_name` AS t1_r2, `request_environment_rules`.`environment_value` AS t1_r3, `request_environment_rules`.`environment_value_is_regex` AS t1_r4, `request_environment_rules`.`environment_value_is_case_sensitive` AS t1_r5, `request_environment_rules`.`created_at` AS t1_r6, `request_environment_rules`.`updated_at` AS t1_r7 FROM `redirect_rules` LEFT OUTER JOIN `request_environment_rules` ON `request_environment_rules`.`redirect_rule_id` = `redirect_rules`.`id` WHERE (redirect_rules.active = 1 AND ((source_is_regex = 0 AND redirect_rules.source = '/someplace') OR (source_is_regex = 1 AND ((redirect_rules.source_is_case_sensitive = 1 AND '/someplace' REGEXP BINARY redirect_rules.source) OR (redirect_rules.source_is_case_sensitive = 0 AND '/someplace' REGEXP redirect_rules.source))))) ORDER BY redirect_rules.source_is_regex ASC, LENGTH(redirect_rules.source) DESC  (0.7ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `source_is_regex`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/news/$1', '[A-Za-z0-9_]+shiny\\/([A-Za-z0-9_]+)', 1, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'SERVER_NAME', 'example.com', 151, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.5ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.4ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'SERVER_NAME', 'example.com', 152, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.5ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.3ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.2ms) RELEASE SAVEPOINT active_record_1  (0.3ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'SERVER_NAME', 'example.com', 153, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.4ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'SERVER_NAME', 'example.com', 154, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.4ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'SERVER_NAME', 'example.com', 155, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.5ms) ROLLBACK  (0.1ms) BEGIN  (0.3ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'SERVER_NAME', 'example.com', 156, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'SERVER_NAME', 'example.com', 157, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'SERVER_NAME', 'example.com', 158, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.3ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'SERVER_NAME', 'example.com', 159, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'SERVER_NAME', 'example.com', 160, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'SERVER_NAME', 'example.com', 161, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'SERVER_NAME', 'example.com', 162, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.7ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'SERVER_NAME', 'example.com', 164, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'QUERY_STRING', 'something=value', 1, 165, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) SAVEPOINT active_record_1 SQL (0.2ms) INSERT INTO `redirect_rules` (`active`, `created_at`, `destination`, `source`, `updated_at`) VALUES (1, '2014-01-16 22:58:23', 'http://www.example.com/products/1', '/catchy_thingy', '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.1ms) SAVEPOINT active_record_1 SQL (0.1ms) INSERT INTO `request_environment_rules` (`created_at`, `environment_key_name`, `environment_value`, `environment_value_is_case_sensitive`, `environment_value_is_regex`, `redirect_rule_id`, `updated_at`) VALUES ('2014-01-16 22:58:23', 'QUERY_STRING', 'something=value', 0, 1, 166, '2014-01-16 22:58:23')  (0.1ms) RELEASE SAVEPOINT active_record_1  (0.4ms) ROLLBACK