ZFDebug log Log variables Variables file 269 Files database 89 in 132.99 ms 10215K in 321ms

Event log for direct_linkController->direct-linkAction()

101ms2782KStartup - ZFDebug construct()
0ms6KRoute
210ms6968Kdirect_linkController::direct-linkAction
210ms6971KDispatch
321ms10117KShutdown

View variables

affiliateDestinationUrl => ''
destinationUrl => 'http://byvue.com/?a=76123&c=1396031&m=32&s1=m1'
host => 'affportal-lb.bevomedia.com'
s3Host => 'http://cdn.bevomedia.com/'
trackerClick => Tracker_Click Object()
trackerCodesRemarketingTag => NULL
trackingHost => 'http://affportal-lb.bevomedia.com/'

Request parameters

action => 'direct-link'
adVar => 'y4'
controller => 'direct_link'
id => 'NORPEEVKIPWOUZVGDHLOCCJJDORGKLOE'
module => 'default'

Zend Registry

Zend_View_Helper_Doctype => ArrayObject Object()
Zend_View_Helper_Placeholder_Registry => Zend_View_Helper_Placeholder_Registry Object()
config => Zend_Config Object()

Cookies

 

269 files included worth 2607.5K

Application Files

/Bootstrap.php
/controllers/Direct/LinkController.php
/models/Browser.php
/models/Db/Mapper/Abstract.php
/models/Db/Mapper/Advertiser/Credit/Balance.php
/models/Db/Mapper/Advertiser/Credit/Invoice/Click.php
/models/Db/Mapper/Advertising/Accepted/Bid.php
/models/Db/Mapper/Advertising/Accepted/Bid/Custom.php
/models/Db/Mapper/Advertising/Campaign.php
/models/Db/Mapper/Advertising/Campaign/Custom.php
/models/Db/Mapper/Advertising/Tracker/Code.php
/models/Db/Mapper/Browser.php
/models/Db/Mapper/Cloak.php
/models/Db/Mapper/Cloak/Custom.php
/models/Db/Mapper/Cpa/Exchange/Activity/Log.php
/models/Db/Mapper/Cpa/Optimizer.php
/models/Db/Mapper/Cpa/Optimizer/Box.php
/models/Db/Mapper/Cpa/Optimizer/Box/Custom.php
/models/Db/Mapper/Cpa/Optimizer/Retest.php
/models/Db/Mapper/Cpa/Optimizer/Retest/Box.php
/models/Db/Mapper/Cpa/Optimizer/Retest/Box/Custom.php
/models/Db/Mapper/Cpa/Optimizer/Retest/Custom.php
/models/Db/Mapper/Cpa/Optimizer/Trial.php
/models/Db/Mapper/Cpa/Optimizer/Trial/Box.php
/models/Db/Mapper/Cpa/Optimizer/Trial/Box/Custom.php
/models/Db/Mapper/Cpa/Optimizer/Trial/Custom.php
/models/Db/Mapper/Direct/Link.php
/models/Db/Mapper/Direct/Link/Custom.php
/models/Db/Mapper/Internet/Provider.php
/models/Db/Mapper/Internet/Provider/Custom.php
/models/Db/Mapper/Ip/Address.php
/models/Db/Mapper/Ip/Address/Custom.php
/models/Db/Mapper/Ip/Location.php
/models/Db/Mapper/Ip/Location/Custom.php
/models/Db/Mapper/Landing/Page.php
/models/Db/Mapper/Landing/Page/Custom.php
/models/Db/Mapper/Niche.php
/models/Db/Mapper/Niche/Offers.php
/models/Db/Mapper/Niche/User/Offers.php
/models/Db/Mapper/Niche/User/Offers/Custom.php
/models/Db/Mapper/Offer/Rotator.php
/models/Db/Mapper/Offer/Rotator/Custom.php
/models/Db/Mapper/Offer/Rotator/Link.php
/models/Db/Mapper/Offer/Rotator/Link/Custom.php
/models/Db/Mapper/Operating/System.php
/models/Db/Mapper/Ppc/Ad/Group.php
/models/Db/Mapper/Ppc/Ad/Variation.php
/models/Db/Mapper/Ppc/Ad/Variation/Custom.php
/models/Db/Mapper/Ppc/Ad/Variation/Stat.php
/models/Db/Mapper/Ppc/Ad/Variation/Stat/Custom.php
/models/Db/Mapper/Ppc/Campaign.php
/models/Db/Mapper/Ppc/Keyword.php
/models/Db/Mapper/Ppc/Provider.php
/models/Db/Mapper/Settings.php
/models/Db/Mapper/Settings/Custom.php
/models/Db/Mapper/Step/Optimizer.php
/models/Db/Mapper/Step/Optimizer/Offer/Box.php
/models/Db/Mapper/Step/Optimizer/Offer/Trial.php
/models/Db/Mapper/Tracker/Click.php
/models/Db/Mapper/Tracker/Click/Additional/SubId.php
/models/Db/Mapper/Tracker/Click/Click/Through.php
/models/Db/Mapper/Tracker/Click/Custom.php
/models/Db/Mapper/Tracker/Click/Offer.php
/models/Db/Mapper/Tracker/Click/Offer/Custom.php
/models/Db/Mapper/Tracker/Codes.php
/models/Db/Mapper/Tracker/Codes/Additional/SubId.php
/models/Db/Mapper/Tracker/Codes/Custom.php
/models/Db/Mapper/Tracker/Codes/Remarketing/Tag.php
/models/Db/Mapper/User.php
/models/Db/Mapper/User/Daily/Stats.php
/models/Db/Mapper/User/Stats.php
/models/Db/Mapper/User/Stats/Custom.php
/models/Db/Mapper/User/Subscription.php
/models/Db/Mapper/User/Subscription/Custom.php
/models/Db/Table/Advertising/Tracker/Code.php
/models/Db/Table/Browser.php
/models/Db/Table/Cpa/Optimizer.php
/models/Db/Table/Direct/Link.php
/models/Db/Table/Internet/Provider.php
/models/Db/Table/Ip/Address.php
/models/Db/Table/Ip/Location.php
/models/Db/Table/Landing/Page.php
/models/Db/Table/Niche.php
/models/Db/Table/Offer/Rotator.php
/models/Db/Table/Offer/Rotator/Link.php
/models/Db/Table/Operating/System.php
/models/Db/Table/Ppc/Ad/Group.php
/models/Db/Table/Ppc/Ad/Variation.php
/models/Db/Table/Ppc/Ad/Variation/Stat.php
/models/Db/Table/Ppc/Campaign.php
/models/Db/Table/Ppc/Keyword.php
/models/Db/Table/Ppc/Provider.php
/models/Db/Table/Settings.php
/models/Db/Table/Step/Optimizer.php
/models/Db/Table/Tracker/Click.php
/models/Db/Table/Tracker/Click/Additional/SubId.php
/models/Db/Table/Tracker/Click/Click/Through.php
/models/Db/Table/Tracker/Click/Offer.php
/models/Db/Table/Tracker/Codes.php
/models/Db/Table/Tracker/Codes/Additional/SubId.php
/models/Db/Table/Tracker/Codes/Remarketing/Tag.php
/models/Db/Table/User.php
/models/Db/Table/User/Daily/Stats.php
/models/Db/Table/User/Stats.php
/models/Db/Table/User/Subscription.php
/models/Direct/Link.php
/models/Internet/Provider.php
/models/Ip/Address.php
/models/Ip/Location.php
/models/Landing/Page.php
/models/Mapper/Interface.php
/models/Model.php
/models/Niche.php
/models/Offer/Rotator.php
/models/Offer/Rotator/Link.php
/models/Operating/System.php
/models/Ppc/Ad/Group.php
/models/Ppc/Ad/Variation.php
/models/Ppc/Ad/Variation/Stat.php
/models/Ppc/Campaign.php
/models/Ppc/Keyword.php
/models/Ppc/Provider.php
/models/Service/Advertising/Accepted/Bid.php
/models/Service/Advertising/Accepted/Bid/Custom.php
/models/Service/Browser.php
/models/Service/Browser/Custom.php
/models/Service/Offer.php
/models/Service/Offer/Custom.php
/models/Service/Operating/System.php
/models/Service/Operating/System/Custom.php
/models/Service/User/Daily/Stats.php
/models/Service/User/Daily/Stats/Custom.php
/models/Tracker/Click.php
/models/Tracker/Click/Click/Through.php
/models/Tracker/Click/Offer.php
/models/Tracker/Codes.php
/models/User.php
/models/User/Daily/Stats.php
/models/User/Stats.php
/models/User/Subscription.php
/views/scripts/direct/link/direct-link.phtml
/var/www/bevo-v3-git/library/Bevomedia/Service/Drip/Api.php
/var/www/bevo-v3-git/library/Bevomedia/Service/Drip/Manager.php
/var/www/bevo-v3-git/library/RCS/Controller/Action.php
/var/www/bevo-v3-git/library/RCS/Controller/Action/Helper/LayoutLoader.php
/var/www/bevo-v3-git/library/RCS/Core/Object.php
/var/www/bevo-v3-git/library/RCS/Resource.php
/var/www/bevo-v3-git/public/index.php

Zend Files

/usr/share/php/library/Zend/Application.php
/usr/share/php/library/Zend/Application/Bootstrap/Bootstrap.php
/usr/share/php/library/Zend/Application/Bootstrap/BootstrapAbstract.php
/usr/share/php/library/Zend/Application/Bootstrap/Bootstrapper.php
/usr/share/php/library/Zend/Application/Bootstrap/ResourceBootstrapper.php
/usr/share/php/library/Zend/Application/Module/Autoloader.php
/usr/share/php/library/Zend/Application/Resource/Db.php
/usr/share/php/library/Zend/Application/Resource/Frontcontroller.php
/usr/share/php/library/Zend/Application/Resource/Layout.php
/usr/share/php/library/Zend/Application/Resource/Modules.php
/usr/share/php/library/Zend/Application/Resource/Resource.php
/usr/share/php/library/Zend/Application/Resource/ResourceAbstract.php
/usr/share/php/library/Zend/Application/Resource/Session.php
/usr/share/php/library/Zend/Application/Resource/View.php
/usr/share/php/library/Zend/Config.php
/usr/share/php/library/Zend/Config/Ini.php
/usr/share/php/library/Zend/Controller/Action.php
/usr/share/php/library/Zend/Controller/Action/Helper/Abstract.php
/usr/share/php/library/Zend/Controller/Action/Helper/ViewRenderer.php
/usr/share/php/library/Zend/Controller/Action/HelperBroker.php
/usr/share/php/library/Zend/Controller/Action/HelperBroker/PriorityStack.php
/usr/share/php/library/Zend/Controller/Action/Interface.php
/usr/share/php/library/Zend/Controller/Dispatcher/Abstract.php
/usr/share/php/library/Zend/Controller/Dispatcher/Interface.php
/usr/share/php/library/Zend/Controller/Dispatcher/Standard.php
/usr/share/php/library/Zend/Controller/Exception.php
/usr/share/php/library/Zend/Controller/Front.php
/usr/share/php/library/Zend/Controller/Plugin/Abstract.php
/usr/share/php/library/Zend/Controller/Plugin/Broker.php
/usr/share/php/library/Zend/Controller/Plugin/ErrorHandler.php
/usr/share/php/library/Zend/Controller/Request/Abstract.php
/usr/share/php/library/Zend/Controller/Request/Http.php
/usr/share/php/library/Zend/Controller/Response/Abstract.php
/usr/share/php/library/Zend/Controller/Response/Http.php
/usr/share/php/library/Zend/Controller/Router/Abstract.php
/usr/share/php/library/Zend/Controller/Router/Interface.php
/usr/share/php/library/Zend/Controller/Router/Rewrite.php
/usr/share/php/library/Zend/Controller/Router/Route.php
/usr/share/php/library/Zend/Controller/Router/Route/Abstract.php
/usr/share/php/library/Zend/Controller/Router/Route/Interface.php
/usr/share/php/library/Zend/Controller/Router/Route/Module.php
/usr/share/php/library/Zend/Db.php
/usr/share/php/library/Zend/Db/Adapter/Abstract.php
/usr/share/php/library/Zend/Db/Adapter/Pdo/Abstract.php
/usr/share/php/library/Zend/Db/Adapter/Pdo/Mysql.php
/usr/share/php/library/Zend/Db/Expr.php
/usr/share/php/library/Zend/Db/Profiler.php
/usr/share/php/library/Zend/Db/Profiler/Query.php
/usr/share/php/library/Zend/Db/Select.php
/usr/share/php/library/Zend/Db/Statement.php
/usr/share/php/library/Zend/Db/Statement/Interface.php
/usr/share/php/library/Zend/Db/Statement/Pdo.php
/usr/share/php/library/Zend/Db/Table.php
/usr/share/php/library/Zend/Db/Table/Abstract.php
/usr/share/php/library/Zend/Db/Table/Definition.php
/usr/share/php/library/Zend/Db/Table/Row.php
/usr/share/php/library/Zend/Db/Table/Row/Abstract.php
/usr/share/php/library/Zend/Db/Table/Rowset.php
/usr/share/php/library/Zend/Db/Table/Rowset/Abstract.php
/usr/share/php/library/Zend/Db/Table/Select.php
/usr/share/php/library/Zend/Exception.php
/usr/share/php/library/Zend/Filter.php
/usr/share/php/library/Zend/Filter/Inflector.php
/usr/share/php/library/Zend/Filter/Interface.php
/usr/share/php/library/Zend/Filter/PregReplace.php
/usr/share/php/library/Zend/Filter/StringToLower.php
/usr/share/php/library/Zend/Filter/Word/CamelCaseToDash.php
/usr/share/php/library/Zend/Filter/Word/CamelCaseToSeparator.php
/usr/share/php/library/Zend/Filter/Word/Separator/Abstract.php
/usr/share/php/library/Zend/Filter/Word/SeparatorToSeparator.php
/usr/share/php/library/Zend/Filter/Word/UnderscoreToSeparator.php
/usr/share/php/library/Zend/Layout.php
/usr/share/php/library/Zend/Layout/Controller/Action/Helper/Layout.php
/usr/share/php/library/Zend/Layout/Controller/Plugin/Layout.php
/usr/share/php/library/Zend/Loader.php
/usr/share/php/library/Zend/Loader/Autoloader.php
/usr/share/php/library/Zend/Loader/Autoloader/Interface.php
/usr/share/php/library/Zend/Loader/Autoloader/Resource.php
/usr/share/php/library/Zend/Loader/PluginLoader.php
/usr/share/php/library/Zend/Loader/PluginLoader/Interface.php
/usr/share/php/library/Zend/Log.php
/usr/share/php/library/Zend/Log/FactoryInterface.php
/usr/share/php/library/Zend/Log/Filter/Abstract.php
/usr/share/php/library/Zend/Log/Filter/Interface.php
/usr/share/php/library/Zend/Log/Filter/Priority.php
/usr/share/php/library/Zend/Log/Writer/Abstract.php
/usr/share/php/library/Zend/Registry.php
/usr/share/php/library/Zend/Rest/Route.php
/usr/share/php/library/Zend/Session.php
/usr/share/php/library/Zend/Session/Abstract.php
/usr/share/php/library/Zend/Session/Namespace.php
/usr/share/php/library/Zend/Session/SaveHandler/DbTable.php
/usr/share/php/library/Zend/Session/SaveHandler/Interface.php
/usr/share/php/library/Zend/Uri.php
/usr/share/php/library/Zend/Version.php
/usr/share/php/library/Zend/View.php
/usr/share/php/library/Zend/View/Abstract.php
/usr/share/php/library/Zend/View/Helper/Abstract.php
/usr/share/php/library/Zend/View/Helper/Doctype.php
/usr/share/php/library/Zend/View/Helper/HeadLink.php
/usr/share/php/library/Zend/View/Helper/HeadScript.php
/usr/share/php/library/Zend/View/Helper/Interface.php
/usr/share/php/library/Zend/View/Helper/Placeholder/Container.php
/usr/share/php/library/Zend/View/Helper/Placeholder/Container/Abstract.php
/usr/share/php/library/Zend/View/Helper/Placeholder/Container/Standalone.php
/usr/share/php/library/Zend/View/Helper/Placeholder/Registry.php
/usr/share/php/library/Zend/View/Helper/ServerUrl.php
/usr/share/php/library/Zend/View/Interface.php
/usr/share/php/library/Zend/View/Stream.php

ZFDebug Files

/usr/share/php/library/ZFDebug/Controller/Plugin/Debug.php
/usr/share/php/library/ZFDebug/Controller/Plugin/Debug/Plugin.php
/usr/share/php/library/ZFDebug/Controller/Plugin/Debug/Plugin/Database.php
/usr/share/php/library/ZFDebug/Controller/Plugin/Debug/Plugin/Exception.php
/usr/share/php/library/ZFDebug/Controller/Plugin/Debug/Plugin/File.php
/usr/share/php/library/ZFDebug/Controller/Plugin/Debug/Plugin/Interface.php
/usr/share/php/library/ZFDebug/Controller/Plugin/Debug/Plugin/Log.php
/usr/share/php/library/ZFDebug/Controller/Plugin/Debug/Plugin/Log/Writer.php
/usr/share/php/library/ZFDebug/Controller/Plugin/Debug/Plugin/Memory.php
/usr/share/php/library/ZFDebug/Controller/Plugin/Debug/Plugin/Text.php
/usr/share/php/library/ZFDebug/Controller/Plugin/Debug/Plugin/Time.php
/usr/share/php/library/ZFDebug/Controller/Plugin/Debug/Plugin/Variables.php

Database queries – Metadata cache DISABLED

4.16ms DESCRIBE `direct_link`
1.14ms SELECT `direct_link`.* FROM `direct_link` WHERE (`publicId` = 'NORPEEVKIPWOUZVGDHLOCCJJDORGKLOE')
0.89ms DESCRIBE `direct_link`
1.37ms DESCRIBE `tracking_codes`
0.61ms SELECT `tracking_codes`.* FROM `tracking_codes` WHERE (`directLink` = '19239')
1.13ms DESCRIBE `tracking_codes`
1.03ms DESCRIBE `ppc_ad_variation`
4.13ms SELECT `ppc_ad_variation`.* FROM `ppc_ad_variation` WHERE (((`ppc_ad_variation`.`id` = 138764)))
2.25ms DESCRIBE `pcc_ad_group`
1.13ms SELECT `pcc_ad_group`.* FROM `pcc_ad_group` WHERE (((`pcc_ad_group`.`id` = 24543)))
1.14ms DESCRIBE `ppc_ad_variation`
1.03ms SELECT `ppc_ad_variation`.* FROM `ppc_ad_variation` WHERE (name = 'y4' AND groupId = 24543)
1.05ms DESCRIBE `users`
0.61ms SELECT `users`.* FROM `users` WHERE (((`users`.`id` = 12)))
0.60ms SELECT `ip_location`.`ID` FROM `ip_location` WHERE (IP_TO >= INET_ATON('54.162.166.214')) LIMIT 1
1.08ms DESCRIBE `ip_location`
0.56ms SELECT `ip_location`.* FROM `ip_location` WHERE (((`ip_location`.`id` = 538370)))
1.74ms SELECT `internet_provider_ip_range`.`internetProvider` FROM `internet_provider_ip_range` WHERE (end >= INET_ATON('54.162.166.214')) LIMIT 1
2.37ms DESCRIBE `internet_provider`
1.13ms SELECT `internet_provider`.* FROM `internet_provider` WHERE (((`internet_provider`.`id` = 3716)))
1.13ms DESCRIBE `browsers`
1.20ms SELECT `browsers`.* FROM `browsers` WHERE (((`browsers`.`id` = 2)))
1.14ms DESCRIBE `operating_systems`
1.13ms SELECT `operating_systems`.* FROM `operating_systems` WHERE (((`operating_systems`.`id` = 1)))
1.14ms DESCRIBE `advertising_tracker_codes`
1.15ms SELECT `advertising_tracker_codes`.* FROM `advertising_tracker_codes` WHERE (`trackerCode` = '28248')
1.13ms DESCRIBE `advertising_tracker_codes`
1.15ms SELECT `advertising_tracker_codes`.* FROM `advertising_tracker_codes` WHERE (`trackerCode` = '28248')
1.14ms DESCRIBE `offer_rotators`
1.13ms SELECT `offer_rotators`.* FROM `offer_rotators` WHERE (((`offer_rotators`.`id` = 22745)))
1.14ms DESCRIBE `offer_rotator_links`
1.15ms SELECT `offer_rotator_links`.* FROM `offer_rotator_links` WHERE (`rotator` = '22745')
1.14ms DESCRIBE `offer_rotator_links`
1.14ms DESCRIBE `operating_systems`
1.13ms DESCRIBE `operating_systems`
3.02ms DESCRIBE `cpa_optimizers`
1.13ms SELECT `cpa_optimizers`.* FROM `cpa_optimizers` WHERE (`trackerCode` = '28248')
0.89ms DESCRIBE `tracker_landing_pages`
0.67ms SELECT `tracker_landing_pages`.* FROM `tracker_landing_pages` WHERE (landingPageUrl = 'http://byvue.com/?a=76123&c=1396031&m=32&s1=m1' AND user = 12)
0.91ms DESCRIBE `tracker_ip_addresses`
13.59ms SELECT `tracker_ip_addresses`.* FROM `tracker_ip_addresses` WHERE (ip = '54.162.166.214')
1.02ms DESCRIBE `tracker_ip_addresses`
0.61ms INSERT INTO `tracker_ip_addresses` (`ip`, `ipLocation`) VALUES ('54.162.166.214', '538370')
0.85ms DESCRIBE `ppc_keyword`
0.61ms SELECT `ppc_keyword`.* FROM `ppc_keyword` WHERE (`name` = '')
0.83ms DESCRIBE `ppc_keyword`
2.05ms DESCRIBE `ppc_keyword`
1.13ms SELECT `ppc_keyword`.* FROM `ppc_keyword` WHERE (`name` = '')
1.13ms DESCRIBE `ppc_keyword`
1.14ms DESCRIBE `ppc_ad_var_stats`
1.14ms SELECT `ppc_ad_var_stats`.* FROM `ppc_ad_var_stats` WHERE (`adVariationsId` = '138764')
1.13ms DESCRIBE `ppc_ad_var_stats`
1.14ms DESCRIBE `ppc_campaign`
1.14ms SELECT `ppc_campaign`.* FROM `ppc_campaign` WHERE (((`ppc_campaign`.`id` = 15015)))
1.13ms DESCRIBE `ppc_provider`
1.14ms SELECT `ppc_provider`.* FROM `ppc_provider` WHERE (((`ppc_provider`.`id` = 4)))
1.15ms DESCRIBE `tracker_clicks`
1.16ms INSERT INTO `tracker_clicks` (`user`, `advertiser`, `subId`, `rawKeywordId`, `bidKeywordId`, `landingPageId`, `campaignId`, `adGroupId`, `creativeId`, `ipAddressId`, `referrerUrl`, `clickTime`, `origPageUrl`, `clickThrough`, `optionalData`, `conversion`, `cost`, `advertiserCost`, `revenue`, `offerId`, `clickOfferUrl`, `trackerCode`, `cpaOptimizerTrialBox`, `deleted`, `internetProvider`, `operatingSystem`, `browser`, `notUnique`, `advertisingCampaign`, `advertisingAcceptedBid`) VALUES ('12', '', '0', '1', '1', '124439', '15015', '24543', '138764', '62951662', '', '2017-11-21 00:55:51', '', '1', '', '', '0.000', '0', '0', '', '', '28248', '', '0', '3716', '1', '2', '0', '', '')
1.13ms DESCRIBE `user_daily_stats`
2.99ms SELECT `user_daily_stats`.* FROM `user_daily_stats` WHERE (`user` = 12) AND (`date` = '2017-11-21 00:00:00')
1.06ms DESCRIBE `user_daily_stats`
0.63ms UPDATE `user_daily_stats` SET `id` = '100716', `user` = '12', `date` = '2017-11-21 00:00:00', `clicks` = '5', `clickThroughs` = '5', `conversions` = '0', `revenue` = '0.00' WHERE (id = 100716)
0.88ms DESCRIBE `user_stats`
0.57ms SELECT `user_stats`.* FROM `user_stats` WHERE (user = 12 AND trackerCode = 28248) LIMIT 1
0.61ms SELECT `tracker_click_offers`.`id` FROM `tracker_click_offers` WHERE (tracker_click_offers.user = '12') AND (tracker_click_offers.url = 'http://byvue.com/?a=76123&c=1396031&m=32&s1=m1') LIMIT 1
1.03ms DESCRIBE `tracker_click_offers`
0.57ms SELECT `tracker_click_offers`.* FROM `tracker_click_offers` WHERE (((`tracker_click_offers`.`id` = 36752)))
4.15ms UPDATE `tracker_clicks` SET `id` = '140096612', `user` = '12', `advertiser` = '', `subId` = '140096612', `rawKeywordId` = '1', `bidKeywordId` = '1', `landingPageId` = '124439', `campaignId` = '15015', `adGroupId` = '24543', `creativeId` = '138764', `ipAddressId` = '62951662', `referrerUrl` = '', `clickTime` = '2017-11-21 00:55:51', `origPageUrl` = '', `clickThrough` = '1', `optionalData` = '', `conversion` = '', `cost` = '0.000', `advertiserCost` = '0', `revenue` = '0', `offerId` = '', `clickOfferUrl` = '36752', `trackerCode` = '28248', `cpaOptimizerTrialBox` = '', `deleted` = '0', `internetProvider` = '3716', `operatingSystem` = '1', `browser` = '2', `notUnique` = '0', `advertisingCampaign` = '', `advertisingAcceptedBid` = '' WHERE (id = '140096612')
1.14ms DESCRIBE `cpa_optimizers`
1.13ms SELECT `cpa_optimizers`.* FROM `cpa_optimizers` WHERE (`trackerCode` = '28248')
0.85ms DESCRIBE `step_optimizers`
0.57ms SELECT `step_optimizers`.* FROM `step_optimizers` WHERE (`trackerCode` = '28248')
0.89ms DESCRIBE `settings`
0.56ms SELECT `settings`.* FROM `settings` WHERE (settingName = 'DRIP_API_KEY') LIMIT 1
0.98ms DESCRIBE `user_subscriptions`
11.13ms SELECT `user_subscriptions`.* FROM `user_subscriptions` WHERE (`status` = 'active') AND (`user` = 12)
2.27ms SELECT SUM(clicks) FROM `user_daily_stats` WHERE (user = 12) AND (date BETWEEN '2017-11-07' AND '2017-11-21') GROUP BY `user`
1.04ms DESCRIBE `tracking_codes_additional_subids`
0.56ms SELECT `tracking_codes_additional_subids`.* FROM `tracking_codes_additional_subids` WHERE (`trackerCode` = '28248')
0.88ms DESCRIBE `tracker_click_click_throughs`
0.60ms INSERT INTO `tracker_click_click_throughs` (`trackerClick`, `offerRotator`, `trackerClickOffer`, `conversion`, `revenue`) VALUES ('140096612', '22745', '36752', '0', '0')
0.94ms DESCRIBE `tracker_clicks_additional_subids`
0.61ms SELECT `tracker_clicks_additional_subids`.* FROM `tracker_clicks_additional_subids` WHERE (`trackerClick` = '140096612')
4.56ms SELECT `settings`.* FROM `settings` WHERE (settingName = 'BEVO_OFFERS_ENABLED') LIMIT 1
1.13ms UPDATE `user_stats` SET `id` = '19332', `user` = '12', `trackerCode` = '28248', `clicks` = '627125', `clickThroughs` = '627125', `bevoClicks` = '0' WHERE (id = 19332)
1.13ms DESCRIBE `tracker_codes_remarketing_tags`
1.13ms SELECT `tracker_codes_remarketing_tags`.* FROM `tracker_codes_remarketing_tags` WHERE (`trackerCode` = '28248')
1.13ms DESCRIBE `niches`
1.13ms SELECT `niches`.* FROM `niches` WHERE (((`niches`.`id` = 45)))