Skip to content

Instantly share code, notes, and snippets.

@AlexVKO
Created June 22, 2017 00:19
Show Gist options
  • Save AlexVKO/5c1c321225b96ddb29a9eec3e2dee32d to your computer and use it in GitHub Desktop.
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`
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