May 26 11:27:40 mcapp3 mcwap_core.production[17281]: Started GET "/go/255887dfa58d275853d2ac2e1420991b?utm_source=62894" for 217.197.116.38 at 2017-05-26 11:27:40 +0300
May 26 11:27:40 mcapp3 mcwap_core.production[17281]: Processing by GoController#go as HTML
May 26 11:27:40 mcapp3 mcwap_core.production[17281]: Parameters: {"utm_source"=>"62894", "id"=>"255887dfa58d275853d2ac2e1420991b"}
May 26 11:27:40 mcapp3 mcwap_core.production[17281]: Flow Load (4.1ms)  SELECT  "flows".* FROM "flows" WHERE "flows"."token" = '255887dfa58d275853d2ac2e1420991b' LIMIT 1  [["token", "255887dfa58d275853d2ac2e1420991b"]]
May 26 11:27:40 mcapp3 mcwap_core.production[17281]: Subnet Load (3.1ms)  SELECT  "subnets".* FROM "subnets" WHERE (subnet >>= '37.29.5.218')  ORDER BY "subnets"."id" ASC LIMIT 1
May 26 11:27:40 mcapp3 mcwap_core.production[17281]: PartnerProfile Load (3.5ms)  SELECT  "partner_profiles".* FROM "partner_profiles" WHERE "partner_profiles"."id" = 1214 LIMIT 1  [["id", 1214]]
May 26 11:27:40 mcapp3 mcwap_core.production[17281]:  (3.1ms)  SELECT COUNT(*) FROM "blacklisted_http_referers" WHERE ('http://filmaniaco.com/older-woman-gets-newer-cock/' LIKE '%' || pattern || '%' AND (operators ? 'megafon' OR operators IS NULL))
May 26 11:27:40 mcapp3 mcwap_core.production[17281]:  (3.0ms)  SELECT COUNT(*) FROM "flow_cycles" WHERE "flow_cycles"."flow_id" = 23432 AND ("flow_cycles"."megafon_site_id" IS NOT NULL)  [["flow_id", 23432]]
May 26 11:27:40 mcapp3 mcwap_core.production[17281]: FlowCycle Load (3.1ms)  SELECT  "flow_cycles".* FROM "flow_cycles" WHERE "flow_cycles"."flow_id" = 23432 AND ("flow_cycles"."megafon_site_id" IS NOT NULL)  ORDER BY "flow_cycles"."id" ASC LIMIT 1  [["flow_id", 23432]]
May 26 11:27:40 mcapp3 mcwap_core.production[17281]: Site Load (3.5ms)  SELECT  "sites".* FROM "sites" WHERE "sites"."id" = 551  ORDER BY "sites"."id" DESC LIMIT 1  [["id", 551]]
May 26 11:27:40 mcapp3 mcwap_core.production[17281]: Domain Load (3.2ms)  SELECT  "domains".* FROM "domains" WHERE "domains"."deleted_at" IS NULL AND "domains"."domain" = 'wapsite-8.ru'  ORDER BY "domains"."id" DESC LIMIT 1  [["domain", "wapsite-8.ru"]]
May 26 11:27:40 mcapp3 mcwap_core.production[17281]:  (2.8ms)  BEGIN
May 26 11:27:40 mcapp3 mcwap_core.production[17281]: SQL (3.7ms)  INSERT INTO "clicks" ("flow_id", "partner_profile_id", "site_id", "operator_id", "ip", "referer", "source", "fingerprint_uuid", "host", "callback_params", "ua", "created_at") VALUES (23432, 1214, 551, 3, '37.29.5.218/32', 'http://filmaniaco.com/older-woman-gets-newer-cock/', '62894', 'cf80d211-d9cf-4acc-b0b6-34d8a794fe0d', 'wapsite-8.ru', '{"utm_source":"62894"}', '{"ua":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2837.0 Safari/537.36","browser":{"name":"Chrome","version":"54.0.2837.0","major":"54"},"engine":{"name":"WebKit","version":"537.36"},"os":{"name":"Windows","version":"10"},"device":{"model":null,"vendor":null,"type":null},"cpu":{"architecture":"amd64"}}', '2017-05-26 11:27:40.307050') RETURNING "id"  [["flow_id", 23432], ["partner_profile_id", 1214], ["site_id", 551], ["operator_id", 3], ["ip", #<IPAddr: IPv4:37.29.5.218/255.255.255.255>], ["referer", "http://filmaniaco.com/older-woman-gets-newer-cock/"], ["source", "62894"], ["fingerprint_uuid", "cf80d211-d9cf-4acc-b0b6-34d8a794fe0d"], ["host", "wapsite-8.ru"], ["callback_params", {"utm_source"=>"62894"}], ["ua", {"ua"=>"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2837.0 Safari/537.36", "browser"=>{"name"=>"Chrome", "version"=>"54.0.2837.0", "major"=>"54"}, "engine"=>{"name"=>"WebKit", "version"=>"537.36"}, "os"=>{"name"=>"Windows", "version"=>"10"}, "device"=>{"model"=>nil, "vendor"=>nil, "type"=>nil}, "cpu"=>{"architecture"=>"amd64"}}], ["created_at", Fri, 26 May 2017 11:27:40 MSK +03:00]]
May 26 11:27:40 mcapp3 mcwap_core.production[17281]:  (2.9ms)  COMMIT
May 26 11:27:40 mcapp3 mcwap_core.production[17281]: Flow Load (3.3ms)  SELECT  "flows".* FROM "flows" WHERE "flows"."is_deleted" = 'f' AND "flows"."parent_id" IS NULL AND "flows"."id" = 23432  ORDER BY "flows"."id" DESC LIMIT 1  [["is_deleted", false], ["id", 23432]]
May 26 11:27:40 mcapp3 mcwap_core.production[17281]: Site Load (3.6ms)  SELECT  "sites".* FROM "sites" WHERE "sites"."id" = 551  ORDER BY "sites"."id" DESC LIMIT 1  [["id", 551]]
May 26 11:27:40 mcapp3 mcwap_core.production[17281]: Tariff Load (3.1ms)  SELECT  "meta_tariffs".* FROM "meta_tariffs" WHERE "meta_tariffs"."id" = 1 LIMIT 1  [["id", 1]]
May 26 11:27:40 mcapp3 mcwap_core.production[17281]:  (3.4ms)  SELECT COUNT(*) FROM "ipgeobase_cidrs" WHERE ("start" <= '37.29.5.218' AND "end" >= '37.29.5.218' AND "city_id" IN (2097, 2287, 1427, 1283, 2571, 2284))
May 26 11:27:40 mcapp3 mcwap_core.production[17281]: Completed 500 Internal Server Error in 82ms (ActiveRecord: 49.4ms)