Created
June 22, 2017 00:19
-
-
Save AlexVKO/5c1c321225b96ddb29a9eec3e2dee32d to your computer and use it in GitHub Desktop.
WORKS: going through http://merchant-wishpond-com.custom.lvh.me/photo-contest/ when `campaign_on_wishpond_custom_subdomain`
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
20:30:24 v1_rails.1 | PageCache Load (0.3ms) SELECT `page_caches`.* FROM `page_caches` WHERE `page_caches`.`id` = 12 LIMIT 1 | |
20:30:24 v1_rails.1 | Executing Utilities::PhantomJS.download_page with command_line=timeout 60 phantomjs --ignore-ssl-errors=true --ssl-protocol=any /Users/alexvko/Dropbox/workspace/wishpond/wishpondv1/lib/phantomjs_download_page.js https://www.lvh.me/lp/15/\?bot\=true /var/folders/n7/ddmtw02s72x_06dzk0_m5nq80000gp/T/phantomjs-download-20170621-5744-h7ysas | |
20:30:24 v1_rails.1 | InstagramSubscription Load (0.3ms) SELECT `instagram_subscriptions`.* FROM `instagram_subscriptions` WHERE `instagram_subscriptions`.`status` = 1 ORDER BY `instagram_subscriptions`.`id` ASC LIMIT 1000 | |
20:30:24 v1_rails.1 | [time:0.000] | |
20:30:24 v1_rails.1 | [time:0.000] | |
20:30:24 v1_rails.1 | [time:0.000] Started GET "/photo-contest/" for 127.0.0.1 at 2017-06-21 20:30:24 -0300 | |
20:30:24 v1_rails.1 | [time:0.056] DomainRouter: http://merchant-wishpond-com.custom.lvh.me/photo-contest/ => /lp/15 | |
20:30:24 v1_rails.1 | [time:0.059] Processing by LpController#show as HTML | |
20:30:24 v1_rails.1 | [time:0.059] Parameters: {"id"=>"15"} | |
20:30:24 v1_rails.1 | [time:0.059] Geokit is using the domain: lvh.me | |
20:30:24 v1_rails.1 | [time:0.060] SocialCampaign Load (0.4ms) SELECT `social_campaigns`.* FROM `social_campaigns` WHERE `social_campaigns`.`id` = 15 AND (social_campaigns.state <> 66) LIMIT 1 | |
20:30:24 v1_rails.1 | [time:0.062] Merchant Load (0.2ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 2 LIMIT 1 | |
20:30:24 v1_rails.1 | [time:0.063] WishpondSubdomain Load (0.2ms) SELECT `wishpond_subdomains`.* FROM `wishpond_subdomains` WHERE `wishpond_subdomains`.`id` = 1 LIMIT 1 | |
20:30:24 v1_rails.1 | [time:0.064] Variation Load (0.2ms) SELECT `variations`.* FROM `variations` WHERE `variations`.`social_campaign_id` = 15 LIMIT 1 | |
20:30:24 v1_rails.1 | [time:0.065] SocialCampaign Load (0.4ms) SELECT `social_campaigns`.* FROM `social_campaigns` WHERE `social_campaigns`.`id` = 15 LIMIT 1 | |
20:30:24 v1_rails.1 | [time:0.066] CACHE (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 2 LIMIT 1 | |
20:30:24 v1_rails.1 | [time:0.067] StripeCustomer Load (0.2ms) SELECT `stripe_customers`.* FROM `stripe_customers` WHERE `stripe_customers`.`owner_id` = 2 AND `stripe_customers`.`owner_type` = 'Merchant' LIMIT 1 | |
20:30:24 v1_rails.1 | [time:0.068] PricingPlan Load (0.2ms) SELECT `pricing_plans`.* FROM `pricing_plans` WHERE `pricing_plans`.`id` = 1086 LIMIT 1 | |
20:30:24 v1_rails.1 | [time:0.069] [pid:5743 scid:15] V1 SCCS: skipping cache | |
20:30:24 v1_rails.1 | [time:0.077] Variation Load (0.3ms) SELECT `variations`.* FROM `variations` WHERE `variations`.`social_campaign_id` = 15 AND `variations`.`status` = 1 | |
20:30:24 v1_rails.1 | [time:0.078] Template Load (0.2ms) SELECT `templates`.* FROM `templates` WHERE `templates`.`id` = 124 LIMIT 1 | |
20:30:24 v1_rails.1 | [time:0.079] TemplateParticipationType Load (0.2ms) SELECT `template_participation_types`.* FROM `template_participation_types` WHERE `template_participation_types`.`template_id` = 124 | |
20:30:24 v1_rails.1 | [time:0.081] Variation Load (0.2ms) SELECT `variations`.* FROM `variations` WHERE `variations`.`social_campaign_id` = 15 | |
20:30:24 v1_rails.1 | [time:0.082] CACHE (0.0ms) SELECT `social_campaigns`.* FROM `social_campaigns` WHERE `social_campaigns`.`id` = 15 LIMIT 1 | |
20:30:24 v1_rails.1 | [time:0.082] CACHE (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 2 LIMIT 1 | |
20:30:24 v1_rails.1 | [time:0.083] Rendered landing_pages/v1/show.html.haml within layouts/landing_pages/v1 (7.5ms) | |
20:30:24 v1_rails.1 | [time:0.091] Locale Load (0.3ms) SELECT `locales`.* FROM `locales` WHERE `locales`.`code` = 'en' LIMIT 1 | |
20:30:24 v1_rails.1 | [time:0.092] FacebookConfig Load (0.2ms) SELECT `facebook_configs`.* FROM `facebook_configs` WHERE `facebook_configs`.`pool_type` = 1 ORDER BY application ASC LIMIT 1 | |
20:30:24 v1_rails.1 | [time:0.093] FacebookConfigEnvironment Load (0.2ms) SELECT `facebook_config_environments`.* FROM `facebook_config_environments` WHERE `facebook_config_environments`.`facebook_config_id` = 35 AND `facebook_config_environments`.`environment` = 'development' LIMIT 1 | |
20:30:24 v1_rails.1 | [time:0.095] CACHE (0.0ms) SELECT `facebook_configs`.* FROM `facebook_configs` WHERE `facebook_configs`.`pool_type` = 1 ORDER BY application ASC LIMIT 1 | |
20:30:24 v1_rails.1 | [time:0.095] CACHE (0.0ms) SELECT `facebook_config_environments`.* FROM `facebook_config_environments` WHERE `facebook_config_environments`.`facebook_config_id` = 35 AND `facebook_config_environments`.`environment` = 'development' LIMIT 1 | |
20:30:24 v1_rails.1 | [time:0.299] SubmissionEntry Load (0.4ms) SELECT `submission_entries`.* FROM `submission_entries` WHERE `submission_entries`.`social_campaign_id` = 15 AND `submission_entries`.`id` IS NULL AND (submission_entries.type != 'SubmissionEntry::Vote') LIMIT 1 | |
20:30:24 v1_rails.1 | [time:0.303] CACHE (0.0ms) SELECT `facebook_configs`.* FROM `facebook_configs` WHERE `facebook_configs`.`pool_type` = 1 ORDER BY application ASC LIMIT 1 | |
20:30:24 v1_rails.1 | [time:0.304] CACHE (0.0ms) SELECT `facebook_configs`.* FROM `facebook_configs` WHERE `facebook_configs`.`pool_type` = 1 ORDER BY application ASC LIMIT 1 | |
20:30:24 v1_rails.1 | [time:0.305] CACHE (0.0ms) SELECT `facebook_config_environments`.* FROM `facebook_config_environments` WHERE `facebook_config_environments`.`facebook_config_id` = 35 AND `facebook_config_environments`.`environment` = 'development' LIMIT 1 | |
20:30:24 v1_rails.1 | [time:0.306] CACHE (0.0ms) SELECT `facebook_configs`.* FROM `facebook_configs` WHERE `facebook_configs`.`pool_type` = 1 ORDER BY application ASC LIMIT 1 | |
20:30:24 v1_rails.1 | [time:0.308] CACHE (0.0ms) SELECT `facebook_config_environments`.* FROM `facebook_config_environments` WHERE `facebook_config_environments`.`facebook_config_id` = 35 AND `facebook_config_environments`.`environment` = 'development' LIMIT 1 | |
20:30:24 v1_rails.1 | [time:0.310] Media::ShareImage Load (0.4ms) SELECT `medias`.* FROM `medias` WHERE `medias`.`type` IN ('Media::ShareImage', 'Media::SeoImage', 'Media::PageShareImage', 'Media::AutoShareImage') AND `medias`.`owner_id` = 15 AND `medias`.`owner_type` = 'SocialCampaign' LIMIT 1 | |
20:30:24 v1_rails.1 | [time:0.312] Rendered text template (0.0ms) | |
20:30:24 v1_rails.1 | [time:0.312] Completed 200 OK in 253.2ms (Views: 0.6ms | ActiveRecord: 4.5ms | SQL count: 26) | |
20:30:25 shoal_rails.1 | | |
20:30:25 shoal_rails.1 | | |
20:30:25 shoal_rails.1 | Started GET "/api/columns?page=1" for 127.0.0.1 at 2017-06-21 20:30:25 -0300 | |
20:30:25 shoal_rails.1 | Processing by Api::MerchantColumnsController#index as JSON | |
20:30:25 shoal_rails.1 | Parameters: {"page"=>"1"} | |
20:30:25 shoal_rails.1 | ApiToken Load (0.4ms) SELECT `api_tokens`.* FROM `api_tokens` WHERE `api_tokens`.`token` = 'f34259860dc65455da50f35042152c27' AND `api_tokens`.`enabled` = 1 ORDER BY `api_tokens`.`id` ASC LIMIT 1 | |
20:30:25 shoal_rails.1 | Merchant Load (0.4ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 2 ORDER BY `merchants`.`id` ASC LIMIT 1 | |
20:30:25 shoal_rails.1 | (0.4ms) SELECT COUNT(*) FROM `merchant_columns` WHERE `merchant_columns`.`merchant_id` = 2 | |
20:30:25 shoal_rails.1 | MerchantColumn Load (0.3ms) SELECT `merchant_columns`.* FROM `merchant_columns` WHERE `merchant_columns`.`merchant_id` = 2 LIMIT 25 OFFSET 0 | |
20:30:25 shoal_rails.1 | Completed 200 OK in 16ms (Views: 0.9ms | ActiveRecord: 1.6ms) | |
20:30:25 shoal_rails.1 | | |
20:30:25 shoal_rails.1 | | |
20:30:25 shoal_rails.1 | Started GET "/api/ledgers/49" for 127.0.0.1 at 2017-06-21 20:30:25 -0300 | |
20:30:25 shoal_rails.1 | Processing by Api::LedgersController#show as JSON | |
20:30:25 shoal_rails.1 | Parameters: {"id"=>"49"} | |
20:30:25 shoal_rails.1 | Ledger Load (0.5ms) SELECT `ledgers`.* FROM `ledgers` WHERE `ledgers`.`id` = 49 LIMIT 1 | |
20:30:25 shoal_rails.1 | ApiToken Load (0.6ms) SELECT `api_tokens`.* FROM `api_tokens` WHERE `api_tokens`.`token` = 'f34259860dc65455da50f35042152c27' AND `api_tokens`.`enabled` = 1 ORDER BY `api_tokens`.`id` ASC LIMIT 1 | |
20:30:25 shoal_rails.1 | Merchant Load (0.5ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 2 ORDER BY `merchants`.`id` ASC LIMIT 1 | |
20:30:25 shoal_rails.1 | LedgerColumn Exists (0.4ms) SELECT 1 AS one FROM `ledger_columns` WHERE `ledger_columns`.`ledger_id` = 49 LIMIT 1 | |
20:30:25 shoal_rails.1 | LedgerColumn Load (0.3ms) SELECT id FROM `ledger_columns` WHERE `ledger_columns`.`ledger_id` = 49 | |
20:30:25 shoal_rails.1 | Completed 200 OK in 21ms (Views: 4.2ms | ActiveRecord: 2.4ms) | |
20:30:25 shoal_rails.1 | | |
20:30:25 shoal_rails.1 | | |
20:30:25 shoal_rails.1 | Started GET "/api/ledgers/49/columns?page=1" for 127.0.0.1 at 2017-06-21 20:30:25 -0300 | |
20:30:25 shoal_rails.1 | Processing by Api::LedgerColumnsController#index as JSON | |
20:30:25 shoal_rails.1 | Parameters: {"page"=>"1", "ledger_id"=>"49"} | |
20:30:25 shoal_rails.1 | Ledger Load (0.4ms) SELECT `ledgers`.* FROM `ledgers` WHERE `ledgers`.`id` = 49 LIMIT 1 | |
20:30:25 shoal_rails.1 | ApiToken Load (0.3ms) SELECT `api_tokens`.* FROM `api_tokens` WHERE `api_tokens`.`token` = 'f34259860dc65455da50f35042152c27' AND `api_tokens`.`enabled` = 1 ORDER BY `api_tokens`.`id` ASC LIMIT 1 | |
20:30:25 shoal_rails.1 | Merchant Load (0.3ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 2 ORDER BY `merchants`.`id` ASC LIMIT 1 | |
20:30:25 shoal_rails.1 | (0.3ms) SELECT COUNT(*) FROM `ledger_columns` WHERE `ledger_columns`.`ledger_id` = 49 AND `ledger_columns`.`ledger_id` = 49 | |
20:30:25 shoal_rails.1 | LedgerColumn Load (0.3ms) SELECT `ledger_columns`.* FROM `ledger_columns` WHERE `ledger_columns`.`ledger_id` = 49 AND `ledger_columns`.`ledger_id` = 49 LIMIT 25 OFFSET 0 | |
20:30:25 shoal_rails.1 | Ledger Load (0.3ms) SELECT `ledgers`.* FROM `ledgers` WHERE `ledgers`.`id` = 49 ORDER BY `ledgers`.`id` ASC LIMIT 1 | |
20:30:25 shoal_rails.1 | Completed 200 OK in 20ms (Views: 2.8ms | ActiveRecord: 2.0ms) | |
20:30:25 shoal_rails.1 | | |
20:30:25 shoal_rails.1 | | |
20:30:25 shoal_rails.1 | Started GET "/api/ledgers/49/columns?page=1" for 127.0.0.1 at 2017-06-21 20:30:25 -0300 | |
20:30:25 shoal_rails.1 | Processing by Api::LedgerColumnsController#index as JSON | |
20:30:25 shoal_rails.1 | Parameters: {"page"=>"1", "ledger_id"=>"49"} | |
20:30:25 shoal_rails.1 | Ledger Load (0.6ms) SELECT `ledgers`.* FROM `ledgers` WHERE `ledgers`.`id` = 49 LIMIT 1 | |
20:30:25 shoal_rails.1 | ApiToken Load (0.6ms) SELECT `api_tokens`.* FROM `api_tokens` WHERE `api_tokens`.`token` = 'f34259860dc65455da50f35042152c27' AND `api_tokens`.`enabled` = 1 ORDER BY `api_tokens`.`id` ASC LIMIT 1 | |
20:30:25 shoal_rails.1 | Merchant Load (0.5ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 2 ORDER BY `merchants`.`id` ASC LIMIT 1 | |
20:30:25 shoal_rails.1 | (0.3ms) SELECT COUNT(*) FROM `ledger_columns` WHERE `ledger_columns`.`ledger_id` = 49 AND `ledger_columns`.`ledger_id` = 49 | |
20:30:25 shoal_rails.1 | LedgerColumn Load (0.4ms) SELECT `ledger_columns`.* FROM `ledger_columns` WHERE `ledger_columns`.`ledger_id` = 49 AND `ledger_columns`.`ledger_id` = 49 LIMIT 25 OFFSET 0 | |
20:30:25 shoal_rails.1 | Ledger Load (0.3ms) SELECT `ledgers`.* FROM `ledgers` WHERE `ledgers`.`id` = 49 ORDER BY `ledgers`.`id` ASC LIMIT 1 | |
20:30:25 v1_rails.1 | [time:0.000] | |
20:30:25 shoal_rails.1 | Completed 200 OK in 22ms (Views: 2.6ms | ActiveRecord: 2.6ms) | |
20:30:25 v1_rails.1 | [time:0.000] | |
20:30:25 v1_rails.1 | [time:0.000] Started GET "/api/pages_v1/social_campaigns/15?mode=showing&variation_id=50" for 127.0.0.1 at 2017-06-21 20:30:25 -0300 | |
20:30:25 v1_rails.1 | [time:0.073] Processing by Api::PagesV1::SocialCampaignsController#show as JSON | |
20:30:25 v1_rails.1 | [time:0.073] Parameters: {"mode"=>"showing", "variation_id"=>"50", "id"=>"15"} | |
20:30:25 v1_rails.1 | [time:0.073] Geokit is using the domain: lvh.me | |
20:30:25 v1_rails.1 | [time:0.075] SocialCampaign Load (0.5ms) SELECT `social_campaigns`.* FROM `social_campaigns` WHERE `social_campaigns`.`id` = 15 LIMIT 1 | |
20:30:25 v1_rails.1 | [time:0.077] Merchant Load (0.4ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 2 LIMIT 1 | |
20:30:25 v1_rails.1 | [time:0.080] Variation Load (0.4ms) SELECT `variations`.* FROM `variations` WHERE `variations`.`social_campaign_id` = 15 AND `variations`.`id` = 50 LIMIT 1 | |
20:30:25 v1_rails.1 | [time:0.082] CACHE (0.0ms) SELECT `social_campaigns`.* FROM `social_campaigns` WHERE `social_campaigns`.`id` = 15 LIMIT 1 | |
20:30:25 v1_rails.1 | [time:0.087] CACHE (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 2 LIMIT 1 | |
20:30:25 v1_rails.1 | [time:0.089] StripeCustomer Load (0.4ms) SELECT `stripe_customers`.* FROM `stripe_customers` WHERE `stripe_customers`.`owner_id` = 2 AND `stripe_customers`.`owner_type` = 'Merchant' LIMIT 1 | |
20:30:25 v1_rails.1 | [time:0.091] PricingPlan Load (0.4ms) SELECT `pricing_plans`.* FROM `pricing_plans` WHERE `pricing_plans`.`id` = 1086 LIMIT 1 | |
20:30:25 v1_rails.1 | [time:0.094] Variation Load (0.4ms) SELECT `variations`.* FROM `variations` WHERE `variations`.`social_campaign_id` = 15 LIMIT 1 | |
20:30:25 v1_rails.1 | [time:0.095] CACHE (0.0ms) SELECT `variations`.* FROM `variations` WHERE `variations`.`social_campaign_id` = 15 LIMIT 1 | |
20:30:25 v1_rails.1 | [time:0.099] WishpondSubdomain Load (0.3ms) SELECT `wishpond_subdomains`.* FROM `wishpond_subdomains` WHERE `wishpond_subdomains`.`id` = 1 LIMIT 1 | |
20:30:25 v1_rails.1 | [time:0.101] Media::ShareImage Load (0.4ms) SELECT `medias`.* FROM `medias` WHERE `medias`.`type` IN ('Media::ShareImage', 'Media::SeoImage', 'Media::PageShareImage', 'Media::AutoShareImage') AND `medias`.`owner_id` = 15 AND `medias`.`owner_type` = 'SocialCampaign' LIMIT 1 | |
20:30:25 v1_rails.1 | [time:0.103] AuthKey Load (0.4ms) SELECT `auth_keys`.* FROM `auth_keys` WHERE `auth_keys`.`merchant_id` = 2 AND `auth_keys`.`token_type` = 0 AND `auth_keys`.`owner_id` = 15 AND `auth_keys`.`owner_type` = 'SocialCampaign' AND (expires_at IS NULL OR expires_at > '2017-06-21 23:30:25') LIMIT 1 | |
20:30:25 v1_rails.1 | [time:0.104] Variation Load (0.4ms) SELECT `variations`.* FROM `variations` WHERE `variations`.`social_campaign_id` = 15 AND `variations`.`status` = 1 LIMIT 1 | |
20:30:25 v1_rails.1 | [time:0.109] Variation Load (0.4ms) SELECT `variations`.* FROM `variations` WHERE `variations`.`social_campaign_id` = 15 AND `variations`.`status` = 1 ORDER BY created_at ASC | |
20:30:25 v1_rails.1 | [time:0.150] MerchantTour Load (0.3ms) SELECT `merchant_tours`.* FROM `merchant_tours` WHERE `merchant_tours`.`merchant_id` = 2 | |
20:30:25 v1_rails.1 | [time:0.154] Template Load (0.3ms) SELECT `templates`.* FROM `templates` WHERE `templates`.`id` = 124 LIMIT 1 | |
20:30:25 v1_rails.1 | [time:0.156] TemplateParticipationType Load (0.4ms) SELECT `template_participation_types`.* FROM `template_participation_types` WHERE `template_participation_types`.`template_id` = 124 | |
20:30:25 v1_rails.1 | [time:0.157] CACHE (0.0ms) SELECT `social_campaigns`.* FROM `social_campaigns` WHERE `social_campaigns`.`id` = 15 LIMIT 1 | |
20:30:25 v1_rails.1 | [time:0.159] CACHE (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 2 LIMIT 1 | |
20:30:25 v1_rails.1 | [time:0.207] CACHE (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 2 LIMIT 1 | |
20:30:25 v1_rails.1 | [time:0.307] Completed 200 OK in 233.5ms (Views: 6.3ms | ActiveRecord: 5.3ms | SQL count: 20) | |
20:30:25 v1_rails.1 | [time:0.000] | |
20:30:25 v1_rails.1 | [time:0.000] | |
20:30:25 v1_rails.1 | [time:0.000] Started GET "/popups.json?merchant_id=2&url=https%3A%2F%2Fmerchant-wishpond-com.custom.lvh.me%2Fphoto-contest%2F&social_campaign_id=15" for 127.0.0.1 at 2017-06-21 20:30:25 -0300 | |
20:30:25 v1_rails.1 | [time:0.085] Processing by PopupsController#index as JSON | |
20:30:25 v1_rails.1 | [time:0.085] Parameters: {"merchant_id"=>"2", "url"=>"https://merchant-wishpond-com.custom.lvh.me/photo-contest/", "social_campaign_id"=>"15"} | |
20:30:25 v1_rails.1 | [time:0.085] Geokit is using the domain: lvh.me | |
20:30:25 v1_rails.1 | [time:0.087] Merchant Load (0.4ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 2 LIMIT 1 | |
20:30:25 v1_rails.1 | [time:0.091] Contest::LandingPage Load (0.8ms) SELECT `social_campaigns`.* FROM `social_campaigns` WHERE `social_campaigns`.`type` IN ('Contest::LandingPage') AND `social_campaigns`.`owner_id` = 2 AND `social_campaigns`.`owner_type` = 'Merchant' AND `social_campaigns`.`state` = 33 AND `social_campaigns`.`landing_page_type` = 2 AND (EXISTS (SELECT * FROM `match_rules` WHERE `match_rules`.`action` = 0 AND (match_rules.popup_owner_id = '15' OR -- current_match_type = social_campaign_destination? ? : simple : match_type | |
20:30:25 v1_rails.1 | CASE IF(match_rules.destination_type = 1, 0, match_rules.match_type) | |
20:30:25 v1_rails.1 | WHEN 0 THEN -- simple | |
20:30:25 v1_rails.1 | -- Remove everything from the '?', chomp trailing '/', rightmost comparison with url | |
20:30:25 v1_rails.1 | RIGHT( | |
20:30:25 v1_rails.1 | TRIM(TRAILING '/' FROM | |
20:30:25 v1_rails.1 | IF(LOCATE('?', match_rules.match_string) != 0, | |
20:30:25 v1_rails.1 | LEFT(match_rules.match_string, LOCATE('?', match_rules.match_string)-1), | |
20:30:25 v1_rails.1 | match_rules.match_string | |
20:30:25 v1_rails.1 | ) | |
20:30:25 v1_rails.1 | ), | |
20:30:25 v1_rails.1 | 49 | |
20:30:25 v1_rails.1 | ) = 'merchant-wishpond-com.custom.lvh.me/photo-contest' | |
20:30:25 v1_rails.1 | WHEN 1 THEN -- exact | |
20:30:25 v1_rails.1 | -- url.chomp("/") == match_string.chomp("/") | |
20:30:25 v1_rails.1 | TRIM(TRAILING '/' FROM 'https://merchant-wishpond-com.custom.lvh.me/photo-contest/') = TRIM(TRAILING '/' FROM match_rules.match_string) | |
20:30:25 v1_rails.1 | WHEN 2 THEN -- substring | |
20:30:25 v1_rails.1 | -- url.include?(match_string) | |
20:30:25 v1_rails.1 | LOCATE(match_rules.match_string, 'https://merchant-wishpond-com.custom.lvh.me/photo-contest/') != 0 | |
20:30:25 v1_rails.1 | WHEN 3 THEN -- regular_expression | |
20:30:25 v1_rails.1 | -- Regexp.new(match_string) === url | |
20:30:25 v1_rails.1 | ('https://merchant-wishpond-com.custom.lvh.me/photo-contest/' REGEXP match_rules.match_string) = 1 | |
20:30:25 v1_rails.1 | WHEN 4 THEN -- all | |
20:30:25 v1_rails.1 | TRUE | |
20:30:25 v1_rails.1 | END | |
20:30:25 v1_rails.1 | ) AND (match_rules.social_campaign_id = social_campaigns.id)) AND NOT EXISTS(SELECT * FROM `match_rules` WHERE `match_rules`.`action` = 1 AND (match_rules.popup_owner_id = '15' OR -- current_match_type = social_campaign_destination? ? : simple : match_type | |
20:30:25 v1_rails.1 | CASE IF(match_rules.destination_type = 1, 0, match_rules.match_type) | |
20:30:25 v1_rails.1 | WHEN 0 THEN -- simple | |
20:30:25 v1_rails.1 | -- Remove everything from the '?', chomp trailing '/', rightmost comparison with url | |
20:30:25 v1_rails.1 | RIGHT( | |
20:30:25 v1_rails.1 | TRIM(TRAILING '/' FROM | |
20:30:25 v1_rails.1 | IF(LOCATE('?', match_rules.match_string) != 0, | |
20:30:25 v1_rails.1 | LEFT(match_rules.match_string, LOCATE('?', match_rules.match_string)-1), | |
20:30:25 v1_rails.1 | match_rules.match_string | |
20:30:25 v1_rails.1 | ) | |
20:30:25 v1_rails.1 | ), | |
20:30:25 v1_rails.1 | 49 | |
20:30:25 v1_rails.1 | ) = 'merchant-wishpond-com.custom.lvh.me/photo-contest' | |
20:30:25 v1_rails.1 | WHEN 1 THEN -- exact | |
20:30:25 v1_rails.1 | -- url.chomp("/") == match_string.chomp("/") | |
20:30:25 v1_rails.1 | TRIM(TRAILING '/' FROM 'https://merchant-wishpond-com.custom.lvh.me/photo-contest/') = TRIM(TRAILING '/' FROM match_rules.match_string) | |
20:30:25 v1_rails.1 | WHEN 2 THEN -- substring | |
20:30:25 v1_rails.1 | -- url.include?(match_string) | |
20:30:25 v1_rails.1 | LOCATE(match_rules.match_string, 'https://merchant-wishpond-com.custom.lvh.me/photo-contest/') != 0 | |
20:30:25 v1_rails.1 | WHEN 3 THEN -- regular_expression | |
20:30:25 v1_rails.1 | -- Regexp.new(match_string) === url | |
20:30:25 v1_rails.1 | ('https://merchant-wishpond-com.custom.lvh.me/photo-contest/' REGEXP match_rules.match_string) = 1 | |
20:30:25 v1_rails.1 | WHEN 4 THEN -- all | |
20:30:25 v1_rails.1 | TRUE | |
20:30:25 v1_rails.1 | END | |
20:30:25 v1_rails.1 | ) AND (match_rules.social_campaign_id = social_campaigns.id))) | |
20:30:26 v1_rails.1 | [time:0.112] Completed 200 OK in 26.2ms (Views: 1.4ms | ActiveRecord: 0.0ms | SQL count: 2) | |
20:30:26 v1_rails.1 | [time:0.000] | |
20:30:26 v1_rails.1 | [time:0.000] | |
20:30:26 v1_rails.1 | [time:0.000] Started GET "/api/pages_v1/social_campaigns/15/entries?query=&sort=random" for 127.0.0.1 at 2017-06-21 20:30:25 -0300 | |
20:30:26 v1_rails.1 | [time:0.087] Processing by Api::PagesV1::SubmissionEntriesController#index as JSON | |
20:30:26 v1_rails.1 | [time:0.087] Parameters: {"query"=>"", "sort"=>"random", "social_campaign_id"=>"15"} | |
20:30:26 v1_rails.1 | [time:0.087] Geokit is using the domain: lvh.me | |
20:30:26 v1_rails.1 | [time:0.089] SocialCampaign Load (0.6ms) SELECT `social_campaigns`.* FROM `social_campaigns` WHERE `social_campaigns`.`id` = 15 LIMIT 1 | |
20:30:26 v1_rails.1 | [time:0.091] Merchant Load (0.4ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 2 LIMIT 1 | |
20:30:26 v1_rails.1 | [time:0.093] (0.4ms) SELECT COUNT(*) FROM `submission_entries` WHERE `submission_entries`.`social_campaign_id` = 15 AND `submission_entries`.`visible` = 1 AND (submission_entries.type != 'SubmissionEntry::Vote') | |
20:30:26 v1_rails.1 | [time:0.094] SubmissionEntry Load (0.3ms) SELECT submission_entries.id, submission_entries.updated_at FROM `submission_entries` WHERE `submission_entries`.`social_campaign_id` = 15 AND `submission_entries`.`visible` = 1 AND (submission_entries.type != 'SubmissionEntry::Vote') ORDER BY RAND(985) LIMIT 12 OFFSET 0 | |
20:30:26 v1_rails.1 | [time:0.098] Completed 200 OK in 10.7ms (Views: 2.1ms | ActiveRecord: 1.7ms | SQL count: 4) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment