· 10 years ago · Aug 23, 2016, 12:36 AM
1➜ crm git:(bulk-import-csv) ✗ rails s
2=> Booting WEBrick
3=> Rails 4.2.5 application starting in development on http://localhost:3000
4=> Run `rails server -h` for more startup options
5=> Ctrl-C to shutdown server
6[2016-08-22 20:57:27] INFO WEBrick 1.3.1
7[2016-08-22 20:57:27] INFO ruby 2.3.1 (2016-04-26) [x86_64-linux]
8[2016-08-22 20:57:27] INFO WEBrick::HTTPServer#start: pid=8504 port=3000
9
10
11Started GET "/accounts/new" for 127.0.0.1 at 2016-08-22 20:57:29 +0900
12 ActiveRecord::SchemaMigration Load (0.9ms) SELECT "schema_migrations".* FROM "schema_migrations"
13Processing by AccountsController#new as HTML
14 Account Load (0.3ms) SELECT "public"."accounts".* FROM "public"."accounts" WHERE "public"."accounts"."subdomain" = $1 LIMIT 1 [["subdomain", ""]]
15* Locale set to 'en'
16 Rendered accounts/new.html.erb within layouts/application (62.2ms)
17Completed 200 OK in 955ms (Views: 863.1ms | ActiveRecord: 5.6ms)
18
19
20Started GET "/assets/autocomplete.coffee" for 127.0.0.1 at 2016-08-22 20:57:30 +0900
21
22
23Started POST "/accounts" for 127.0.0.1 at 2016-08-22 20:57:46 +0900
24Processing by AccountsController#create as HTML
25 Parameters: {"utf8"=>"✓", "authenticity_token"=>"0gToWXs6q5eulvp+/3aOyKoUh7TODDJD3EuAglX5KjMNKhQO0QRWE6z68zVCJfFt91OnZOGwTFH9lLC0cZhLJQ==", "account"=>{"company_name"=>"hello", "owner_attributes"=>{"name"=>"hello", "email"=>"hello", "password"=>"[FILTERED]", "password_confirmation"=>"[FILTERED]"}, "subdomain"=>"hello"}, "commit"=>"Create Account"}
26 Account Load (0.4ms) SELECT "public"."accounts".* FROM "public"."accounts" WHERE "public"."accounts"."subdomain" = $1 LIMIT 1 [["subdomain", ""]]
27* Locale set to 'en'
28 Account Exists (0.9ms) SELECT 1 AS one FROM "public"."accounts" WHERE LOWER("public"."accounts"."subdomain") = LOWER('hello') LIMIT 1
29 User Exists (0.7ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'hello' LIMIT 1
30 Rendered accounts/new.html.erb within layouts/application (13.4ms)
31Completed 200 OK in 330ms (Views: 227.0ms | ActiveRecord: 2.4ms)
32
33
34Started GET "/assets/autocomplete.coffee" for 127.0.0.1 at 2016-08-22 20:57:47 +0900
35
36
37Started POST "/accounts" for 127.0.0.1 at 2016-08-22 20:58:15 +0900
38Processing by AccountsController#create as HTML
39 Parameters: {"utf8"=>"✓", "authenticity_token"=>"6e/r+kCOd4BFNDU1+bc+EeKDQFXtCz/ti1m2wtzdPGg2wRet6rCKBEdYPH5E5EG0v8RghcK3Qf+qhob0+Lxdfg==", "account"=>{"company_name"=>"hello", "owner_attributes"=>{"name"=>"hello", "email"=>"hello@mail.com", "password"=>"[FILTERED]", "password_confirmation"=>"[FILTERED]"}, "subdomain"=>"hello"}, "commit"=>"Create Account"}
40 Account Load (0.3ms) SELECT "public"."accounts".* FROM "public"."accounts" WHERE "public"."accounts"."subdomain" = $1 LIMIT 1 [["subdomain", ""]]
41* Locale set to 'en'
42 Account Exists (0.4ms) SELECT 1 AS one FROM "public"."accounts" WHERE LOWER("public"."accounts"."subdomain") = LOWER('hello') LIMIT 1
43 User Exists (0.3ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'hello@mail.com' LIMIT 1
44 (51.8ms) CREATE SCHEMA "hello"
45 SQL (0.2ms) CREATE EXTENSION IF NOT EXISTS "plpgsql"
46 (74.6ms) CREATE TABLE "accounts" ("id" serial primary key, "subdomain" character varying, "owner_id" integer, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL, "company_name" character varying)
47 (71.4ms) CREATE TABLE "businesses" ("id" serial primary key, "name" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
48 (80.5ms) CREATE TABLE "clients" ("id" serial primary key, "last_name" character varying, "first_name" character varying, "email" character varying, "country_code_phone_number" character varying DEFAULT '81', "phone_number" character varying, "country_code_mobile_number" character varying DEFAULT '81', "mobile_number" character varying, "fax" character varying, "memo" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL, "country_code_fax" character varying DEFAULT '81', "deleted_at" timestamp, "company_id" integer, "gender_id" integer, "position" character varying, "address" character varying, "zip" character varying, "romaji_full_name" character varying)
49 (46.8ms) CREATE INDEX "index_clients_on_company_id" ON "clients" USING btree ("company_id")
50 (47.5ms) CREATE INDEX "index_clients_on_deleted_at" ON "clients" USING btree ("deleted_at")
51 (80.3ms) CREATE TABLE "companies" ("id" serial primary key, "name" character varying, "zip" character varying, "address" character varying, "country_id" integer, "business_id" integer, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL, "deleted_at" timestamp, "country_code_phone_number" character varying DEFAULT '81', "phone_number" character varying, "country_code_fax" character varying DEFAULT '81', "fax" character varying, "website" character varying)
52 (47.6ms) CREATE INDEX "index_companies_on_deleted_at" ON "companies" USING btree ("deleted_at")
53 (64.6ms) CREATE TABLE "countries" ("id" serial primary key, "name" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
54 (81.3ms) CREATE TABLE "csv_files" ("id" serial primary key, "file_id" character varying, "file_filename" character varying, "file_size" integer, "file_content_type" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
55 (47.5ms) CREATE INDEX "index_csv_files_on_file_id" ON "csv_files" USING btree ("file_id")
56 (80.8ms) CREATE TABLE "genders" ("id" serial primary key, "name" character varying, "after_name" boolean DEFAULT 'f', "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
57 (81.5ms) CREATE TABLE "languages" ("id" serial primary key, "name" character varying, "code" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
58 (81.6ms) CREATE TABLE "refile_attachments" ("id" serial primary key, "oid" integer NOT NULL, "namespace" character varying NOT NULL, "created_at" timestamp)
59 (47.4ms) CREATE INDEX "index_refile_attachments_on_namespace" ON "refile_attachments" USING btree ("namespace")
60 (38.2ms) CREATE INDEX "index_refile_attachments_on_oid" ON "refile_attachments" USING btree ("oid")
61 (46.2ms) CREATE TABLE "relation_clients" ("id" serial primary key, "relation_id" integer, "client_id" integer, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
62 (47.8ms) CREATE INDEX "index_relation_clients_on_client_id" ON "relation_clients" USING btree ("client_id")
63 (38.6ms) CREATE INDEX "index_relation_clients_on_relation_id" ON "relation_clients" USING btree ("relation_id")
64 (73.4ms) CREATE TABLE "relation_files" ("id" serial primary key, "relation_id" integer, "file_id" character varying, "file_filename" character varying, "file_size" integer, "file_content_type" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
65 (45.7ms) CREATE INDEX "index_relation_files_on_file_id" ON "relation_files" USING btree ("file_id")
66 (47.0ms) CREATE INDEX "index_relation_files_on_relation_id" ON "relation_files" USING btree ("relation_id")
67 (97.9ms) CREATE TABLE "relation_types" ("id" serial primary key, "name" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
68 (47.3ms) CREATE TABLE "relation_users" ("id" serial primary key, "relation_id" integer, "user_id" integer, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
69 (46.7ms) CREATE INDEX "index_relation_users_on_relation_id" ON "relation_users" USING btree ("relation_id")
70 (38.4ms) CREATE INDEX "index_relation_users_on_user_id" ON "relation_users" USING btree ("user_id")
71 (95.5ms) CREATE TABLE "relations" ("id" serial primary key, "date" date, "title" character varying, "content_type" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL, "relation_types_id" integer)
72 (46.1ms) CREATE INDEX "index_relations_on_relation_types_id" ON "relations" USING btree ("relation_types_id")
73 (48.5ms) CREATE TABLE "role_inheritances" ("id" serial primary key, "parent_role_id" integer, "child_role_id" integer, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
74 (47.4ms) CREATE INDEX "index_role_inheritances_on_child_role_id" ON "role_inheritances" USING btree ("child_role_id")
75 (38.4ms) CREATE INDEX "index_role_inheritances_on_parent_role_id" ON "role_inheritances" USING btree ("parent_role_id")
76 (79.2ms) CREATE TABLE "roles" ("id" serial primary key, "name" character varying, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
77 (78.0ms) CREATE TABLE "users" ("id" serial primary key, "name" character varying, "email" character varying DEFAULT '' NOT NULL, "encrypted_password" character varying DEFAULT '' NOT NULL, "reset_password_token" character varying, "reset_password_sent_at" timestamp, "remember_created_at" timestamp, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL, "invitation_token" character varying, "invitation_created_at" timestamp, "invitation_sent_at" timestamp, "invitation_accepted_at" timestamp, "invitation_limit" integer, "invited_by_id" integer, "invited_by_type" character varying, "invitations_count" integer DEFAULT 0, "confirmation_token" character varying, "confirmed_at" timestamp, "confirmation_sent_at" timestamp, "role_id" integer, "avatar_id" character varying, "avatar_filename" character varying, "avatar_size" integer, "avatar_content_type" character varying, "languages_id" integer)
78 (38.9ms) CREATE UNIQUE INDEX "index_users_on_confirmation_token" ON "users" USING btree ("confirmation_token")
79 (47.4ms) CREATE UNIQUE INDEX "index_users_on_email" ON "users" USING btree ("email")
80 (39.1ms) CREATE UNIQUE INDEX "index_users_on_invitation_token" ON "users" USING btree ("invitation_token")
81 (46.7ms) CREATE INDEX "index_users_on_invitations_count" ON "users" USING btree ("invitations_count")
82 (45.6ms) CREATE INDEX "index_users_on_invited_by_id" ON "users" USING btree ("invited_by_id")
83 (39.2ms) CREATE INDEX "index_users_on_languages_id" ON "users" USING btree ("languages_id")
84 (46.6ms) CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" USING btree ("reset_password_token")
85 (47.8ms) CREATE INDEX "index_users_on_role_id" ON "users" USING btree ("role_id")
86 (48.4ms) CREATE TABLE "schema_migrations" ("version" character varying NOT NULL)
87 (62.6ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
88 (0.5ms) SELECT version FROM "schema_migrations"
89 (5.1ms) INSERT INTO "schema_migrations" (version) VALUES ('20160714071440')
90 (8.1ms) INSERT INTO "schema_migrations" (version) VALUES ('20160610085238')
91 (8.0ms) INSERT INTO "schema_migrations" (version) VALUES ('20160512030050')
92 (8.1ms) INSERT INTO "schema_migrations" (version) VALUES ('20160526072357')
93 (8.0ms) INSERT INTO "schema_migrations" (version) VALUES ('20160601061923')
94 (8.1ms) INSERT INTO "schema_migrations" (version) VALUES ('20160513014342')
95 (8.1ms) INSERT INTO "schema_migrations" (version) VALUES ('20151216090717')
96 (8.0ms) INSERT INTO "schema_migrations" (version) VALUES ('20160419033350')
97 (8.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20160610084433')
98 (7.5ms) INSERT INTO "schema_migrations" (version) VALUES ('20160418010904')
99 (8.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20160428075233')
100 (6.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20151215010659')
101 (8.0ms) INSERT INTO "schema_migrations" (version) VALUES ('20160421092321')
102 (8.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20160428055033')
103 (6.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20160428051229')
104 (8.0ms) INSERT INTO "schema_migrations" (version) VALUES ('20160419032359')
105 (8.0ms) INSERT INTO "schema_migrations" (version) VALUES ('20160428071354')
106 (8.0ms) INSERT INTO "schema_migrations" (version) VALUES ('20160419070140')
107 (8.0ms) INSERT INTO "schema_migrations" (version) VALUES ('20160610082758')
108 (8.6ms) INSERT INTO "schema_migrations" (version) VALUES ('20160425025407')
109 (7.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20160707002733')
110 (8.1ms) INSERT INTO "schema_migrations" (version) VALUES ('20160517051537')
111 (8.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20160419055540')
112 (7.6ms) INSERT INTO "schema_migrations" (version) VALUES ('20160610070707')
113 (8.1ms) INSERT INTO "schema_migrations" (version) VALUES ('20160419044554')
114 (8.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20151214063314')
115 (7.8ms) INSERT INTO "schema_migrations" (version) VALUES ('20160427031255')
116 (7.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20151216055005')
117 (8.0ms) INSERT INTO "schema_migrations" (version) VALUES ('20160427031924')
118 (8.0ms) INSERT INTO "schema_migrations" (version) VALUES ('20160517050056')
119 Role Load (0.2ms) SELECT "roles".* FROM "roles" WHERE "roles"."name" = $1 LIMIT 1 [["name", "Admin"]]
120 (0.1ms) BEGIN
121 Account Exists (0.3ms) SELECT 1 AS one FROM "public"."accounts" WHERE LOWER("public"."accounts"."subdomain") = LOWER('hello') LIMIT 1
122 User Exists (0.9ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'hello@mail.com' LIMIT 1
123 User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."confirmation_token" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["confirmation_token", "538210a824f7806d1dd226a99478c1fc9d80de98524c0a0f3bde99069b3b70f1"]]
124 SQL (0.5ms) INSERT INTO "users" ("name", "email", "encrypted_password", "role_id", "languages_id", "created_at", "updated_at", "confirmation_token", "confirmation_sent_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id" [["name", "hello"], ["email", "hello@mail.com"], ["encrypted_password", "$2a$10$8MtliXBXOVhAYkfAJPfE1.SMSUI01Rq2tLFApzYDPrD0Wxzbl6zLa"], ["role_id", 3], ["languages_id", 1], ["created_at", "2016-08-22 11:58:39.196211"], ["updated_at", "2016-08-22 11:58:39.196211"], ["confirmation_token", "ybbybYh23ZPz3zLX6brt"], ["confirmation_sent_at", "2016-08-22 11:58:39.385273"]]
125 Rendered devise/mailer/confirmation_instructions.html.erb (1.0ms)
126
127Devise::Mailer#confirmation_instructions: processed outbound mail in 213.5ms
128
129Sent mail to hello@mail.com (31.2ms)
130Date: Mon, 22 Aug 2016 20:58:39 +0900
131From: noreply@exjcrm.com
132Reply-To: noreply@exjcrm.com
133To: hello@mail.com
134Message-ID: <57bae8ef96090_2138450ff1089692@antergos.mail>
135Subject: [EXJ Crm] Confirmation instructions
136Mime-Version: 1.0
137Content-Type: text/html;
138 charset=UTF-8
139Content-Transfer-Encoding: 7bit
140
141<h1>EXJ Crm</h1>
142<br/>
143
144<h2>Dear hello,</h2>
145<p>You have successfully completed your registration at EXJ Crm !</p>
146<br/>
147
148<p>Please confirm your account by clicking on the link below :</p>
149<p><a href="http://hello.lvh.me:3000/users/confirmation?confirmation_token=ybbybYh23ZPz3zLX6brt">Confirm my account</a></p>
150<br/>
151
152<p>Regards</p>
153<p>EXJ staff</p>
154<br/>
155
156<p>----------------------------</p>
157<p>This is an automated email, no reply is required. If this email was not requested please contact us through our website.</p>
158<p>No one from the EXJ staff will never ask you for your password.</p>
159 SQL (0.5ms) INSERT INTO "public"."accounts" ("subdomain", "company_name", "owner_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["subdomain", "hello"], ["company_name", "hello"], ["owner_id", 1], ["created_at", "2016-08-22 11:58:39.637640"], ["updated_at", "2016-08-22 11:58:39.637640"]]
160 (59.7ms) COMMIT
161 Client Load (0.7ms) SELECT "clients".* FROM "clients" WHERE "clients"."deleted_at" IS NULL ORDER BY "clients"."id" ASC LIMIT 1000
162 Company Load (0.3ms) SELECT "companies".* FROM "companies" WHERE "companies"."deleted_at" IS NULL AND "companies"."id" = $1 LIMIT 1 [["id", 1]]
163 CACHE (0.0ms) SELECT "companies".* FROM "companies" WHERE "companies"."deleted_at" IS NULL AND "companies"."id" = $1 LIMIT 1 [["id", 1]]
164 Company Load (0.5ms) SELECT "companies".* FROM "companies" WHERE "companies"."deleted_at" IS NULL AND "companies"."id" = $1 LIMIT 1 [["id", 6]]
165 CACHE (0.0ms) SELECT "companies".* FROM "companies" WHERE "companies"."deleted_at" IS NULL AND "companies"."id" = $1 LIMIT 1 [["id", 6]]
166 Company Load (0.4ms) SELECT "companies".* FROM "companies" WHERE "companies"."deleted_at" IS NULL AND "companies"."id" = $1 LIMIT 1 [["id", 7]]
167 CACHE (0.1ms) SELECT "companies".* FROM "companies" WHERE "companies"."deleted_at" IS NULL AND "companies"."id" = $1 LIMIT 1 [["id", 7]]
168 Company Load (0.5ms) SELECT "companies".* FROM "companies" WHERE "companies"."deleted_at" IS NULL AND "companies"."id" = $1 LIMIT 1 [["id", 2]]
169 Company Load (0.6ms) SELECT "companies".* FROM "companies" WHERE "companies"."deleted_at" IS NULL AND "companies"."id" = $1 LIMIT 1 [["id", 5]]
170 CACHE (0.0ms) SELECT "companies".* FROM "companies" WHERE "companies"."deleted_at" IS NULL AND "companies"."id" = $1 LIMIT 1 [["id", 5]]
171 CACHE (0.0ms) SELECT "companies".* FROM "companies" WHERE "companies"."deleted_at" IS NULL AND "companies"."id" = $1 LIMIT 1 [["id", 5]]
172 Client Import (851.4ms) {"count":12}
173 Company Load (0.5ms) SELECT "companies".* FROM "companies" WHERE "companies"."deleted_at" IS NULL ORDER BY "companies"."id" ASC LIMIT 1000
174 Country Load (0.3ms) SELECT "countries".* FROM "countries" WHERE "countries"."id" = $1 LIMIT 1 [["id", 114]]
175 Business Load (0.3ms) SELECT "businesses".* FROM "businesses" WHERE "businesses"."id" = $1 LIMIT 1 [["id", 2]]
176 Country Load (0.4ms) SELECT "countries".* FROM "countries" WHERE "countries"."id" = $1 LIMIT 1 [["id", 242]]
177 Business Load (0.4ms) SELECT "businesses".* FROM "businesses" WHERE "businesses"."id" = $1 LIMIT 1 [["id", 8]]
178 Country Load (0.5ms) SELECT "countries".* FROM "countries" WHERE "countries"."id" = $1 LIMIT 1 [["id", 158]]
179 Business Load (0.4ms) SELECT "businesses".* FROM "businesses" WHERE "businesses"."id" = $1 LIMIT 1 [["id", 13]]
180 CACHE (0.0ms) SELECT "countries".* FROM "countries" WHERE "countries"."id" = $1 LIMIT 1 [["id", 242]]
181 Business Load (2.1ms) SELECT "businesses".* FROM "businesses" WHERE "businesses"."id" = $1 LIMIT 1 [["id", 9]]
182 CACHE (0.0ms) SELECT "countries".* FROM "countries" WHERE "countries"."id" = $1 LIMIT 1 [["id", 242]]
183 Business Load (2.6ms) SELECT "businesses".* FROM "businesses" WHERE "businesses"."id" = $1 LIMIT 1 [["id", 5]]
184 CACHE (0.0ms) SELECT "countries".* FROM "countries" WHERE "countries"."id" = $1 LIMIT 1 [["id", 242]]
185 CACHE (0.0ms) SELECT "countries".* FROM "countries" WHERE "countries"."id" = $1 LIMIT 1 [["id", 114]]
186 Business Load (0.4ms) SELECT "businesses".* FROM "businesses" WHERE "businesses"."id" = $1 LIMIT 1 [["id", 14]]
187 Company Import (844.0ms) {"count":7}
188 Country Load (0.8ms) SELECT "countries".* FROM "countries" ORDER BY "countries"."id" ASC LIMIT 1000
189 Country Import (788.9ms) {"count":253}
190 Business Load (0.3ms) SELECT "businesses".* FROM "businesses" ORDER BY "businesses"."id" ASC LIMIT 1000
191 Business Import (726.3ms) {"count":14}
192 Relation Load (0.3ms) SELECT "relations".* FROM "relations" ORDER BY "relations"."id" ASC LIMIT 1000
193 RelationType Load (0.2ms) SELECT "relation_types".* FROM "relation_types" WHERE "relation_types"."id" = $1 LIMIT 1 [["id", 6]]
194 Client Load (0.4ms) SELECT "clients".* FROM "clients" INNER JOIN "relation_clients" ON "clients"."id" = "relation_clients"."client_id" WHERE "clients"."deleted_at" IS NULL AND "relation_clients"."relation_id" = $1 [["relation_id", 1]]
195 CACHE (0.0ms) SELECT "companies".* FROM "companies" WHERE "companies"."deleted_at" IS NULL AND "companies"."id" = $1 LIMIT 1 [["id", 7]]
196 CACHE (0.0ms) SELECT "companies".* FROM "companies" WHERE "companies"."deleted_at" IS NULL AND "companies"."id" = $1 LIMIT 1 [["id", 7]]
197 CACHE (0.0ms) SELECT "companies".* FROM "companies" WHERE "companies"."deleted_at" IS NULL AND "companies"."id" = $1 LIMIT 1 [["id", 1]]
198 RelationType Load (0.3ms) SELECT "relation_types".* FROM "relation_types" WHERE "relation_types"."id" = $1 LIMIT 1 [["id", 4]]
199 Client Load (0.4ms) SELECT "clients".* FROM "clients" INNER JOIN "relation_clients" ON "clients"."id" = "relation_clients"."client_id" WHERE "clients"."deleted_at" IS NULL AND "relation_clients"."relation_id" = $1 [["relation_id", 2]]
200 RelationType Load (0.2ms) SELECT "relation_types".* FROM "relation_types" WHERE "relation_types"."id" = $1 LIMIT 1 [["id", 1]]
201 Client Load (0.2ms) SELECT "clients".* FROM "clients" INNER JOIN "relation_clients" ON "clients"."id" = "relation_clients"."client_id" WHERE "clients"."deleted_at" IS NULL AND "relation_clients"."relation_id" = $1 [["relation_id", 3]]
202 CACHE (0.0ms) SELECT "companies".* FROM "companies" WHERE "companies"."deleted_at" IS NULL AND "companies"."id" = $1 LIMIT 1 [["id", 5]]
203 RelationType Load (0.3ms) SELECT "relation_types".* FROM "relation_types" WHERE "relation_types"."id" = $1 LIMIT 1 [["id", 7]]
204 Client Load (0.4ms) SELECT "clients".* FROM "clients" INNER JOIN "relation_clients" ON "clients"."id" = "relation_clients"."client_id" WHERE "clients"."deleted_at" IS NULL AND "relation_clients"."relation_id" = $1 [["relation_id", 4]]
205 CACHE (0.0ms) SELECT "companies".* FROM "companies" WHERE "companies"."deleted_at" IS NULL AND "companies"."id" = $1 LIMIT 1 [["id", 5]]
206 Relation Import (870.2ms) {"count":4}
207 RelationType Load (0.3ms) SELECT "relation_types".* FROM "relation_types" ORDER BY "relation_types"."id" ASC LIMIT 1000
208 RelationType Import (1165.2ms) {"count":7}
209Redirected to http://hello.lvh.me:3000/users/sign_in
210Completed 302 Found in 31971ms (Searchkick: 20352.4ms | ActiveRecord: 7469.4ms)
211
212
213Started GET "/users/confirmation?confirmation_token=ybbybYh23ZPz3zLX6brt" for 127.0.0.1 at 2016-08-22 20:58:47 +0900
214Processing by Devise::ConfirmationsController#show as HTML
215 Parameters: {"confirmation_token"=>"ybbybYh23ZPz3zLX6brt"}
216 Account Load (0.3ms) SELECT "public"."accounts".* FROM "public"."accounts" WHERE "public"."accounts"."subdomain" = $1 LIMIT 1 [["subdomain", "hello"]]
217* Locale set to 'en'
218 User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."confirmation_token" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["confirmation_token", "ybbybYh23ZPz3zLX6brt"]]
219 (0.1ms) BEGIN
220 SQL (0.3ms) UPDATE "users" SET "confirmed_at" = $1, "updated_at" = $2 WHERE "users"."id" = $3 [["confirmed_at", "2016-08-22 11:58:47.422058"], ["updated_at", "2016-08-22 11:58:47.422747"], ["id", 1]]
221 (15.8ms) COMMIT
222Redirected to http://hello.lvh.me:3000/users/sign_in
223Completed 302 Found in 37ms (ActiveRecord: 17.8ms)
224
225
226Started GET "/users/sign_in" for 127.0.0.1 at 2016-08-22 20:58:47 +0900
227Processing by Devise::SessionsController#new as HTML
228 Account Load (0.4ms) SELECT "public"."accounts".* FROM "public"."accounts" WHERE "public"."accounts"."subdomain" = $1 LIMIT 1 [["subdomain", "hello"]]
229* Locale set to 'en'
230 Rendered devise/shared/_links.html.erb (15.6ms)
231 Rendered devise/sessions/new.html.erb within layouts/application (37.4ms)
232Completed 200 OK in 474ms (Views: 466.1ms | ActiveRecord: 3.7ms)
233
234
235Started GET "/users/sign_in" for 127.0.0.1 at 2016-08-22 20:58:47 +0900
236Processing by Devise::SessionsController#new as HTML
237 Account Load (0.2ms) SELECT "public"."accounts".* FROM "public"."accounts" WHERE "public"."accounts"."subdomain" = $1 LIMIT 1 [["subdomain", "hello"]]
238* Locale set to 'en'
239 Rendered devise/shared/_links.html.erb (11.4ms)
240 Rendered devise/sessions/new.html.erb within layouts/application (34.4ms)
241Completed 200 OK in 566ms (Views: 560.4ms | ActiveRecord: 1.3ms)
242
243
244Started GET "/assets/autocomplete.coffee" for 127.0.0.1 at 2016-08-22 20:58:48 +0900
245
246
247Started GET "/assets/autocomplete.coffee" for 127.0.0.1 at 2016-08-22 20:58:49 +0900
248^C[2016-08-22 20:58:52] INFO going to shutdown ...
249[2016-08-22 20:58:52] INFO WEBrick::HTTPServer#start done.
250Exiting