Processing by JpAddress::ZipcodesController#search as HTML JpAddress::Zipcode Load (0.4ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" IS NULL LIMIT 1 Completed 500 Internal Server Error in 5ms (ActiveRecord: 0.4ms)  (3.1ms) CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)   (0.1ms) select sqlite_version(*)  (2.8ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateJpAddressZipcodes (20160312045953)  (0.0ms) begin transaction  (0.7ms) CREATE TABLE "jp_address_zipcodes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "zip" varchar NOT NULL, "prefecture" varchar NOT NULL, "city" varchar NOT NULL, "town" varchar)  (0.1ms) CREATE INDEX "index_jp_address_zipcodes_on_zip" ON "jp_address_zipcodes" ("zip") SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20160312045953"]]  (2.5ms) commit transaction ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.1ms)  SELECT sql FROM sqlite_master WHERE name='index_jp_address_zipcodes_on_zip' AND type='index' UNION ALL SELECT sql FROM sqlite_temp_master WHERE name='index_jp_address_zipcodes_on_zip' AND type='index'  Processing by JpAddress::ZipcodesController#search as HTML JpAddress::Zipcode Load (1.5ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" IS NULL LIMIT 1 Rendered text template (0.0ms) Completed 200 OK in 20ms (Views: 7.4ms | ActiveRecord: 1.8ms) Processing by JpAddress::ZipcodesController#search as HTML JpAddress::Zipcode Load (1.8ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" IS NULL LIMIT 1 Rendered text template (0.0ms) Completed 200 OK in 21ms (Views: 7.7ms | ActiveRecord: 2.0ms) Processing by JpAddress::ZipcodesController#search as HTML JpAddress::Zipcode Load (1.6ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" IS NULL LIMIT 1 Rendered text template (0.0ms) Completed 200 OK in 25ms (Views: 8.1ms | ActiveRecord: 1.9ms) Processing by JpAddress::ZipcodesController#search as HTML JpAddress::Zipcode Load (1.6ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" IS NULL LIMIT 1 Rendered text template (0.0ms) Completed 200 OK in 24ms (Views: 7.6ms | ActiveRecord: 1.8ms) Processing by JpAddress::ZipcodesController#search as HTML JpAddress::Zipcode Load (1.5ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" IS NULL LIMIT 1 Rendered text template (0.0ms) Completed 200 OK in 26ms (Views: 7.8ms | ActiveRecord: 1.8ms) Processing by JpAddress::ZipcodesController#search as HTML JpAddress::Zipcode Load (1.9ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" IS NULL LIMIT 1 Rendered text template (0.0ms) Completed 200 OK in 29ms (Views: 9.2ms | ActiveRecord: 2.2ms) Processing by JpAddress::ZipcodesController#search as HTML JpAddress::Zipcode Load (1.6ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" IS NULL LIMIT 1 Rendered text template (0.0ms) Completed 200 OK in 25ms (Views: 8.2ms | ActiveRecord: 1.8ms)  (0.1ms) begin transaction SQL (2.0ms) INSERT INTO "jp_address_zipcodes" ("zip", "prefecture", "city", "town") VALUES (?, ?, ?, ?) [["zip", "5330033"], ["prefecture", "大阪府"], ["city", "大阪市東淀川区"], ["town", "東中島"]]  (2.8ms) commit transaction Processing by JpAddress::ZipcodesController#search as HTML Parameters: {"zip"=>"5330033"} JpAddress::Zipcode Load (0.2ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" = ? LIMIT 1 [["zip", "5330033"]] Rendered text template (0.0ms) Completed 200 OK in 17ms (Views: 0.2ms | ActiveRecord: 0.2ms) Processing by JpAddress::ZipcodesController#search as HTML JpAddress::Zipcode Load (1.6ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" IS NULL LIMIT 1 Rendered text template (0.0ms) Completed 200 OK in 25ms (Views: 7.5ms | ActiveRecord: 1.8ms)  (0.1ms) begin transaction SQL (0.8ms) INSERT INTO "jp_address_zipcodes" ("zip", "prefecture", "city", "town") VALUES (?, ?, ?, ?) [["zip", "5330033"], ["prefecture", "大阪府"], ["city", "大阪市東淀川区"], ["town", "東中島"]]  (2.4ms) commit transaction Processing by JpAddress::ZipcodesController#search as HTML Parameters: {"zip"=>"5330033"} JpAddress::Zipcode Load (0.2ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" = ? LIMIT 1 [["zip", "5330033"]] Rendered text template (0.0ms) Completed 200 OK in 4ms (Views: 0.3ms | ActiveRecord: 0.2ms) Processing by JpAddress::ZipcodesController#search as HTML JpAddress::Zipcode Load (1.6ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" IS NULL LIMIT 1 Rendered text template (0.0ms) Completed 200 OK in 25ms (Views: 7.9ms | ActiveRecord: 1.9ms)  (0.1ms) begin transaction SQL (0.8ms) INSERT INTO "jp_address_zipcodes" ("zip", "prefecture", "city", "town") VALUES (?, ?, ?, ?) [["zip", "5330033"], ["prefecture", "大阪府"], ["city", "大阪市東淀川区"], ["town", "東中島"]]  (2.5ms) commit transaction Processing by JpAddress::ZipcodesController#search as HTML Parameters: {"zip"=>"5330033"} JpAddress::Zipcode Load (0.2ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" = ? LIMIT 1 [["zip", "5330033"]] Rendered text template (0.0ms) Completed 200 OK in 4ms (Views: 0.3ms | ActiveRecord: 0.2ms) Processing by JpAddress::ZipcodesController#search as HTML JpAddress::Zipcode Load (1.6ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" IS NULL LIMIT 1 Rendered text template (0.0ms) Completed 200 OK in 24ms (Views: 8.0ms | ActiveRecord: 1.9ms)  (0.1ms) begin transaction SQL (0.8ms) INSERT INTO "jp_address_zipcodes" ("zip", "prefecture", "city", "town") VALUES (?, ?, ?, ?) [["zip", "5330033"], ["prefecture", "大阪府"], ["city", "大阪市東淀川区"], ["town", "東中島"]]  (2.4ms) commit transaction Processing by JpAddress::ZipcodesController#search as HTML Parameters: {"zip"=>"5330033"} JpAddress::Zipcode Load (0.2ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" = ? LIMIT 1 [["zip", "5330033"]] Rendered text template (0.0ms) Completed 200 OK in 4ms (Views: 0.4ms | ActiveRecord: 0.2ms)  (0.1ms) begin transaction SQL (0.7ms) INSERT INTO "jp_address_zipcodes" ("zip", "prefecture", "city", "town") VALUES (?, ?, ?, ?) [["zip", "5330033"], ["prefecture", "大阪府"], ["city", "大阪市東淀川区"], ["town", "東中島"]]  (2.6ms) commit transaction Processing by JpAddress::ZipcodesController#search as HTML Parameters: {"zip"=>"9999999"} JpAddress::Zipcode Load (0.1ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" = ? LIMIT 1 [["zip", "9999999"]] Rendered text template (0.0ms) Completed 200 OK in 1ms (Views: 0.2ms | ActiveRecord: 0.1ms) Processing by JpAddress::ZipcodesController#search as HTML JpAddress::Zipcode Load (1.5ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" IS NULL LIMIT 1 Rendered text template (0.0ms) Completed 200 OK in 24ms (Views: 7.4ms | ActiveRecord: 1.8ms)  (0.1ms) begin transaction SQL (0.9ms) INSERT INTO "jp_address_zipcodes" ("zip", "prefecture", "city", "town") VALUES (?, ?, ?, ?) [["zip", "5330033"], ["prefecture", "大阪府"], ["city", "大阪市東淀川区"], ["town", "東中島"]]  (2.7ms) commit transaction Processing by JpAddress::ZipcodesController#search as HTML Parameters: {"zip"=>"5330033"} JpAddress::Zipcode Load (0.2ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" = ? LIMIT 1 [["zip", "5330033"]] Rendered text template (0.0ms) Completed 200 OK in 4ms (Views: 0.4ms | ActiveRecord: 0.2ms)  (0.0ms) begin transaction SQL (0.7ms) INSERT INTO "jp_address_zipcodes" ("zip", "prefecture", "city", "town") VALUES (?, ?, ?, ?) [["zip", "5330033"], ["prefecture", "大阪府"], ["city", "大阪市東淀川区"], ["town", "東中島"]]  (2.6ms) commit transaction Processing by JpAddress::ZipcodesController#search as HTML Parameters: {"zip"=>"9999999"} JpAddress::Zipcode Load (0.1ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" = ? LIMIT 1 [["zip", "9999999"]] Rendered text template (0.0ms) Completed 200 OK in 1ms (Views: 0.3ms | ActiveRecord: 0.1ms) Processing by JpAddress::ZipcodesController#search as HTML JpAddress::Zipcode Load (1.7ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" IS NULL LIMIT 1 Rendered text template (0.0ms) Completed 200 OK in 23ms (Views: 7.2ms | ActiveRecord: 1.9ms)  (0.1ms) begin transaction SQL (0.8ms) INSERT INTO "jp_address_zipcodes" ("zip", "prefecture", "city", "town") VALUES (?, ?, ?, ?) [["zip", "5330033"], ["prefecture", "大阪府"], ["city", "大阪市東淀川区"], ["town", "東中島"]]  (2.5ms) commit transaction Processing by JpAddress::ZipcodesController#search as HTML Parameters: {"zip"=>"5330033"} JpAddress::Zipcode Load (0.2ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" = ? LIMIT 1 [["zip", "5330033"]] Rendered text template (0.0ms) Completed 200 OK in 4ms (Views: 0.3ms | ActiveRecord: 0.2ms)  (0.1ms) begin transaction SQL (0.7ms) INSERT INTO "jp_address_zipcodes" ("zip", "prefecture", "city", "town") VALUES (?, ?, ?, ?) [["zip", "5330033"], ["prefecture", "大阪府"], ["city", "大阪市東淀川区"], ["town", "東中島"]]  (2.4ms) commit transaction Processing by JpAddress::ZipcodesController#search as HTML Parameters: {"zip"=>"9999999"} JpAddress::Zipcode Load (0.1ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" = ? LIMIT 1 [["zip", "9999999"]] Rendered text template (0.0ms) Completed 200 OK in 1ms (Views: 0.3ms | ActiveRecord: 0.1ms) Processing by JpAddress::ZipcodesController#search as HTML JpAddress::Zipcode Load (1.6ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" IS NULL LIMIT 1 Rendered text template (0.0ms) Completed 200 OK in 27ms (Views: 9.7ms | ActiveRecord: 1.8ms)  (0.1ms) begin transaction SQL (0.9ms) INSERT INTO "jp_address_zipcodes" ("zip", "prefecture", "city", "town") VALUES (?, ?, ?, ?) [["zip", "5330033"], ["prefecture", "大阪府"], ["city", "大阪市東淀川区"], ["town", "東中島"]]  (2.9ms) commit transaction Processing by JpAddress::ZipcodesController#search as HTML Parameters: {"zip"=>"5330033"} JpAddress::Zipcode Load (0.2ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" = ? LIMIT 1 [["zip", "5330033"]] Rendered text template (0.0ms) Completed 200 OK in 4ms (Views: 0.3ms | ActiveRecord: 0.2ms)  (0.1ms) begin transaction SQL (0.7ms) INSERT INTO "jp_address_zipcodes" ("zip", "prefecture", "city", "town") VALUES (?, ?, ?, ?) [["zip", "5330033"], ["prefecture", "大阪府"], ["city", "大阪市東淀川区"], ["town", "東中島"]]  (2.7ms) commit transaction Processing by JpAddress::ZipcodesController#search as HTML Parameters: {"zip"=>"9999999"} JpAddress::Zipcode Load (0.2ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" = ? LIMIT 1 [["zip", "9999999"]] Rendered text template (0.0ms) Completed 200 OK in 1ms (Views: 0.2ms | ActiveRecord: 0.2ms) Processing by JpAddress::ZipcodesController#search as HTML JpAddress::Zipcode Load (1.7ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" IS NULL LIMIT 1 Rendered text template (0.0ms) Completed 200 OK in 25ms (Views: 8.1ms | ActiveRecord: 1.9ms)  (0.1ms) begin transaction SQL (0.9ms) INSERT INTO "jp_address_zipcodes" ("zip", "prefecture", "city", "town") VALUES (?, ?, ?, ?) [["zip", "5330033"], ["prefecture", "大阪府"], ["city", "大阪市東淀川区"], ["town", "東中島"]]  (2.6ms) commit transaction Processing by JpAddress::ZipcodesController#search as HTML Parameters: {"zip"=>"5330033"} JpAddress::Zipcode Load (0.2ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" = ? LIMIT 1 [["zip", "5330033"]] Rendered text template (0.0ms) Completed 200 OK in 4ms (Views: 0.3ms | ActiveRecord: 0.2ms)  (0.1ms) begin transaction SQL (0.7ms) INSERT INTO "jp_address_zipcodes" ("zip", "prefecture", "city", "town") VALUES (?, ?, ?, ?) [["zip", "5330033"], ["prefecture", "大阪府"], ["city", "大阪市東淀川区"], ["town", "東中島"]]  (2.5ms) commit transaction Processing by JpAddress::ZipcodesController#search as HTML Parameters: {"zip"=>"9999999"} JpAddress::Zipcode Load (0.1ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" = ? LIMIT 1 [["zip", "9999999"]] Rendered text template (0.0ms) Completed 200 OK in 1ms (Views: 0.3ms | ActiveRecord: 0.1ms)  (0.1ms) SELECT COUNT(*) FROM "jp_address_zipcodes"  (5.4ms) delete from jp_address_zipcodes  (0.1ms) SELECT COUNT(*) FROM "jp_address_zipcodes"  (3.7ms) delete from jp_address_zipcodes  (3.5ms) delete from jp_address_zipcodes  (3.9ms) delete from jp_address_zipcodes  (3.7ms) delete from jp_address_zipcodes  (0.2ms) SELECT COUNT(*) FROM "jp_address_zipcodes"  (3.9ms) delete from jp_address_zipcodes  (3.5ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600000', '北海道', '札幌市中央区', '以下に掲載がない場合')  (2.9ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0640941', '北海道', '札幌市中央区', '旭ケ丘')  (2.8ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600041', '北海道', '札幌市中央区', '大通東')  (3.2ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600042', '北海道', '札幌市中央区', '大通西（１～１９丁目）')  (2.7ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0640820', '北海道', '札幌市中央区', '大通西（２０～２８丁目）')  (0.2ms) SELECT COUNT(*) FROM "jp_address_zipcodes"  (3.8ms) delete from jp_address_zipcodes  (3.1ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600000', '北海道', '札幌市中央区', '以下に掲載がない場合')  (3.2ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0640941', '北海道', '札幌市中央区', '旭ケ丘')  (2.7ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600041', '北海道', '札幌市中央区', '大通東')  (2.7ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600042', '北海道', '札幌市中央区', '大通西（１～１９丁目）')  (2.7ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0640820', '北海道', '札幌市中央区', '大通西（２０～２８丁目）')  (0.2ms) SELECT COUNT(*) FROM "jp_address_zipcodes" JpAddress::Zipcode Load (0.1ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" ORDER BY "jp_address_zipcodes"."id" DESC LIMIT 1  (3.7ms) delete from jp_address_zipcodes  (3.4ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600000', '北海道', '札幌市中央区', '以下に掲載がない場合')  (3.2ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0640941', '北海道', '札幌市中央区', '旭ケ丘')  (2.8ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600041', '北海道', '札幌市中央区', '大通東')  (2.6ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600042', '北海道', '札幌市中央区', '大通西（１～１９丁目）')  (2.5ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0640820', '北海道', '札幌市中央区', '大通西（２０～２８丁目）')  (0.2ms) SELECT COUNT(*) FROM "jp_address_zipcodes" JpAddress::Zipcode Load (0.1ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" ORDER BY "jp_address_zipcodes"."id" DESC LIMIT 1  (3.7ms) delete from jp_address_zipcodes  (3.0ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600000', '北海道', '札幌市中央区', '以下に掲載がない場合')  (2.9ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0640941', '北海道', '札幌市中央区', '旭ケ丘')  (2.7ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600041', '北海道', '札幌市中央区', '大通東')  (2.7ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600042', '北海道', '札幌市中央区', '大通西（１～１９丁目）')  (2.7ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0640820', '北海道', '札幌市中央区', '大通西（２０～２８丁目）')  (0.1ms) SELECT COUNT(*) FROM "jp_address_zipcodes" JpAddress::Zipcode Load (0.1ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" ORDER BY "jp_address_zipcodes"."id" DESC LIMIT 1  (3.8ms) delete from jp_address_zipcodes  (2.9ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600000', '北海道', '札幌市中央区', '以下に掲載がない場合')  (2.9ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0640941', '北海道', '札幌市中央区', '旭ケ丘')  (3.1ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600041', '北海道', '札幌市中央区', '大通東')  (2.9ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600042', '北海道', '札幌市中央区', '大通西（１～１９丁目）')  (2.7ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0640820', '北海道', '札幌市中央区', '大通西（２０～２８丁目）')  (0.2ms) SELECT COUNT(*) FROM "jp_address_zipcodes" JpAddress::Zipcode Load (0.1ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" ORDER BY "jp_address_zipcodes"."id" DESC LIMIT 1  (3.8ms) delete from jp_address_zipcodes  (3.4ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600000', '北海道', '札幌市中央区', '')  (3.0ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0640941', '北海道', '札幌市中央区', '旭ケ丘')  (2.8ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600041', '北海道', '札幌市中央区', '大通東')  (2.7ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600042', '北海道', '札幌市中央区', '大通西')  (2.7ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0640820', '北海道', '札幌市中央区', '大通西')  (0.2ms) SELECT COUNT(*) FROM "jp_address_zipcodes" JpAddress::Zipcode Load (0.2ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" ORDER BY "jp_address_zipcodes"."id" DESC LIMIT 1  (3.7ms) delete from jp_address_zipcodes  (3.1ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600000', '北海道', '札幌市中央区', '')  (2.8ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0640941', '北海道', '札幌市中央区', '旭ケ丘')  (2.7ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600041', '北海道', '札幌市中央区', '大通東')  (2.9ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600042', '北海道', '札幌市中央区', '大通西')  (2.8ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0640820', '北海道', '札幌市中央区', '大通西')  (0.2ms) SELECT COUNT(*) FROM "jp_address_zipcodes" JpAddress::Zipcode Load (0.1ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" ORDER BY "jp_address_zipcodes"."id" DESC LIMIT 1  (3.5ms) delete from jp_address_zipcodes  (3.3ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600000', '北海道', '札幌市中央区', '')  (3.0ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0640941', '北海道', '札幌市中央区', '旭ケ丘')  (2.8ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600041', '北海道', '札幌市中央区', '大通東')  (2.7ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600042', '北海道', '札幌市中央区', '大通西')  (3.5ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0640820', '北海道', '札幌市中央区', '大通西')  (0.2ms) SELECT COUNT(*) FROM "jp_address_zipcodes" JpAddress::Zipcode Load (0.1ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" ORDER BY "jp_address_zipcodes"."id" DESC LIMIT 1 Processing by JpAddress::ZipcodesController#search as HTML JpAddress::Zipcode Load (2.2ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" IS NULL LIMIT 1 Rendered text template (0.0ms) Completed 200 OK in 23ms (Views: 8.1ms | ActiveRecord: 2.4ms)  (0.1ms) begin transaction SQL (0.9ms) INSERT INTO "jp_address_zipcodes" ("zip", "prefecture", "city", "town") VALUES (?, ?, ?, ?) [["zip", "5330033"], ["prefecture", "大阪府"], ["city", "大阪市東淀川区"], ["town", "東中島"]]  (2.7ms) commit transaction Processing by JpAddress::ZipcodesController#search as HTML Parameters: {"zip"=>"5330033"} JpAddress::Zipcode Load (0.3ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" = ? LIMIT 1 [["zip", "5330033"]] Rendered text template (0.0ms) Completed 200 OK in 4ms (Views: 0.4ms | ActiveRecord: 0.3ms)  (0.0ms) begin transaction SQL (0.9ms) INSERT INTO "jp_address_zipcodes" ("zip", "prefecture", "city", "town") VALUES (?, ?, ?, ?) [["zip", "5330033"], ["prefecture", "大阪府"], ["city", "大阪市東淀川区"], ["town", "東中島"]]  (2.6ms) commit transaction Processing by JpAddress::ZipcodesController#search as HTML Parameters: {"zip"=>"9999999"} JpAddress::Zipcode Load (0.1ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" = ? LIMIT 1 [["zip", "9999999"]] Rendered text template (0.0ms) Completed 200 OK in 1ms (Views: 0.3ms | ActiveRecord: 0.1ms)  (3.4ms) delete from jp_address_zipcodes  (3.3ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600000', '北海道', '札幌市中央区', '')  (3.0ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0640941', '北海道', '札幌市中央区', '旭ケ丘')  (2.8ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600041', '北海道', '札幌市中央区', '大通東')  (2.7ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600042', '北海道', '札幌市中央区', '大通西')  (3.2ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0640820', '北海道', '札幌市中央区', '大通西')  (0.2ms) SELECT COUNT(*) FROM "jp_address_zipcodes" JpAddress::Zipcode Load (0.2ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" ORDER BY "jp_address_zipcodes"."id" DESC LIMIT 1  (5.1ms) delete from jp_address_zipcodes  (3.5ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600000', '北海道', '札幌市中央区', '')  (2.9ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0640941', '北海道', '札幌市中央区', '旭ケ丘')  (2.9ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600041', '北海道', '札幌市中央区', '大通東')  (2.7ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600042', '北海道', '札幌市中央区', '大通西')  (2.6ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0640820', '北海道', '札幌市中央区', '大通西')  (0.2ms) SELECT COUNT(*) FROM "jp_address_zipcodes" JpAddress::Zipcode Load (0.1ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" ORDER BY "jp_address_zipcodes"."id" DESC LIMIT 1 Processing by JpAddress::ZipcodesController#search as HTML JpAddress::Zipcode Load (2.7ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" IS NULL LIMIT ? [["LIMIT", 1]] Rendering text template Rendered text template (0.0ms) Completed 200 OK in 32ms (Views: 7.0ms | ActiveRecord: 3.3ms)  (0.1ms) begin transaction SQL (1.2ms) INSERT INTO "jp_address_zipcodes" ("zip", "prefecture", "city", "town") VALUES (?, ?, ?, ?) [["zip", "5330033"], ["prefecture", "大阪府"], ["city", "大阪市東淀川区"], ["town", "東中島"]]  (3.3ms) commit transaction Processing by JpAddress::ZipcodesController#search as HTML Parameters: {"zip"=>"5330033"} JpAddress::Zipcode Load (0.4ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" = ? LIMIT ? [["zip", "5330033"], ["LIMIT", 1]] Rendering text template Rendered text template (0.0ms) Completed 200 OK in 6ms (Views: 0.5ms | ActiveRecord: 0.4ms)  (0.1ms) begin transaction SQL (0.9ms) INSERT INTO "jp_address_zipcodes" ("zip", "prefecture", "city", "town") VALUES (?, ?, ?, ?) [["zip", "5330033"], ["prefecture", "大阪府"], ["city", "大阪市東淀川区"], ["town", "東中島"]]  (3.0ms) commit transaction Processing by JpAddress::ZipcodesController#search as HTML Parameters: {"zip"=>"9999999"} JpAddress::Zipcode Load (0.2ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" WHERE "jp_address_zipcodes"."zip" = ? LIMIT ? [["zip", "9999999"], ["LIMIT", 1]] Rendering text template Rendered text template (0.0ms) Completed 200 OK in 1ms (Views: 0.3ms | ActiveRecord: 0.2ms)  (3.7ms) delete from jp_address_zipcodes  (3.5ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600000', '北海道', '札幌市中央区', '')  (3.5ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0640941', '北海道', '札幌市中央区', '旭ケ丘')  (4.0ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600041', '北海道', '札幌市中央区', '大通東')  (3.7ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0600042', '北海道', '札幌市中央区', '大通西')  (3.4ms) insert into jp_address_zipcodes (zip, prefecture, city, town) values ('0640820', '北海道', '札幌市中央区', '大通西')  (0.2ms) SELECT COUNT(*) FROM "jp_address_zipcodes" JpAddress::Zipcode Load (0.2ms) SELECT "jp_address_zipcodes".* FROM "jp_address_zipcodes" ORDER BY "jp_address_zipcodes"."id" DESC LIMIT ? [["LIMIT", 1]]