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