2012-11-28 11:05:57.221 (3) [main]: Debug Level set to 3 2012-11-28 11:05:57.223 (3) [main]: Licensing environment detected, loading configuration. 2012-11-28 11:05:57.224 (3) [main]: Loaded property: tsa.google.mcc.email=optusbooster@gmail.com 2012-11-28 11:05:57.224 (3) [main]: Loaded property: tsa.google.mcc.password=optus789 2012-11-28 11:05:57.224 (3) [main]: Loaded property: tsa.google.mcc.developerToken=ojCnjZaM6RD1h0yt_DOJZg 2012-11-28 11:05:57.224 (3) [main]: Loaded property: tsa.google.mcc.applicationToken=none 2012-11-28 11:05:57.225 (3) [main]: Loaded property: tsa.google.mcc.isReseller=true 2012-11-28 11:05:57.225 (3) [main]: Loaded property: tsa.google.mcc.userAgent=Optus AdWords Software 2012-11-28 11:05:57.225 (3) [main]: Loaded property: tsa.google.isSandbox=false 2012-11-28 11:05:57.225 (3) [main]: Loaded property: tsa.google.sandbox.currency=AUD 2012-11-28 11:05:57.225 (3) [main]: Loaded property: tsa.timezone=Australia/Sydney 2012-11-28 11:05:57.227 (3) [main]: Debug Level set to 5 2012-11-28 11:05:57.229 (3) [main]: Using 50 SEUser Threads 2012-11-28 11:05:57.236 (3) [main]: =============== Starting Search Engine Summarizer for Sat Nov 17 00:00:00 EST 2012 ================ 2012-11-28 11:05:57.236 (3) [main]: ----------------Search Engine Summarizer starting 2012-11-28 11:05:57.241 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2012-11-28 11:05:57.444 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-11-28 11:05:57.462 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2012-11-28 11:05:57.463 (4) [main]: spike: SQL->[select * from `searchEngineUsers` join `accounts` on ((`tsacommon`.`accounts`.`id`=`tsacommon`.`searchEngineUsers`.`accountID`)) where ((`enabled`="true") and (`tsacommon`.`accounts`.`isActive`="true") and (`tsacommon`.`searchEngineUsers`.`distributionID`="3") and (`tsacommon`.`searchEngineUsers`.`accountID` in (694))) order by `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priority` asc,`tsacommon`.`accounts`.`id` desc] 2012-11-28 11:05:57.482 (5) [main]: recordAsSubs("db", 19, "main") 2012-11-28 11:05:57.482 (5) [main]: ProfilerRec.end("db", true): ret=19 2012-11-28 11:05:57.483 (4) [main]: time=0.019 2012-11-28 11:05:57.483 (4) [main]: Query executed in 0.019s 2012-11-28 11:05:57.487 (5) [main]: loading 33 columns from result set: 2012-11-28 11:05:57.488 (5) [main]: loaded column: searchEngineUsers.id->84 2012-11-28 11:05:57.488 (5) [main]: loaded column: searchEngineUsers.accountID->694 2012-11-28 11:05:57.488 (5) [main]: loaded column: searchEngineUsers.distributionID->3 2012-11-28 11:05:57.489 (5) [main]: loaded column: searchEngineUsers.searchEngineIdentifier->6728067261 2012-11-28 11:05:57.489 (5) [main]: loaded column: searchEngineUsers.description->82190643000197-0411661664_1 2012-11-28 11:05:57.489 (5) [main]: loaded column: searchEngineUsers.username-> 2012-11-28 11:05:57.489 (5) [main]: loaded column: searchEngineUsers.password-> 2012-11-28 11:05:57.489 (5) [main]: loaded column: searchEngineUsers.enabled->true 2012-11-28 11:05:57.490 (5) [main]: loaded column: searchEngineUsers.inTsaMcc->true 2012-11-28 11:05:57.490 (5) [main]: loaded column: searchEngineUsers.apiKey-> 2012-11-28 11:05:57.490 (5) [main]: loaded column: searchEngineUsers.managerUsernames->null 2012-11-28 11:05:57.490 (5) [main]: loaded column: searchEngineUsers.managerIDs->9558055230 2012-11-28 11:05:57.499 (5) [main]: loaded column: searchEngineUsers.lastChecked->2012-11-28 09:10:26.0 2012-11-28 11:05:57.499 (5) [main]: loaded column: searchEngineUsers.lastInMcc->null 2012-11-28 11:05:57.499 (5) [main]: skipping invalid column: accounts.id 2012-11-28 11:05:57.499 (5) [main]: skipping invalid column: accounts.description 2012-11-28 11:05:57.499 (5) [main]: skipping invalid column: accounts.tier 2012-11-28 11:05:57.499 (5) [main]: skipping invalid column: accounts.priority 2012-11-28 11:05:57.499 (5) [main]: skipping invalid column: accounts.reportClicksOut 2012-11-28 11:05:57.500 (5) [main]: skipping invalid column: accounts.reportConversions 2012-11-28 11:05:57.500 (5) [main]: skipping invalid column: accounts.conversionTypes 2012-11-28 11:05:57.500 (5) [main]: skipping invalid column: accounts.isBidManaged 2012-11-28 11:05:57.500 (5) [main]: skipping invalid column: accounts.isActive 2012-11-28 11:05:57.500 (5) [main]: skipping invalid column: accounts.perfMetric 2012-11-28 11:05:57.500 (5) [main]: skipping invalid column: accounts.providesConversionData 2012-11-28 11:05:57.500 (5) [main]: skipping invalid column: accounts.addConversionData 2012-11-28 11:05:57.501 (5) [main]: skipping invalid column: accounts.fractionalConversionCounts 2012-11-28 11:05:57.501 (5) [main]: skipping invalid column: accounts.hideNullSources 2012-11-28 11:05:57.501 (5) [main]: skipping invalid column: accounts.nowTime 2012-11-28 11:05:57.501 (5) [main]: skipping invalid column: accounts.warehouseDatabase 2012-11-28 11:05:57.501 (5) [main]: skipping invalid column: accounts.databaseInstance 2012-11-28 11:05:57.501 (5) [main]: skipping invalid column: accounts.warehouseInstance 2012-11-28 11:05:57.501 (5) [main]: skipping invalid column: accounts.isOnline 2012-11-28 11:05:57.509 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-11-28 11:05:57.512 (3) [P1T1]: DatabasePool with a limit of 352 created 2012-11-28 11:05:57.513 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread 2012-11-28 11:05:57.542 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-11-28 11:05:57.542 (4) [P1T1]: Created new Object 2012-11-28 11:05:57.543 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:57.543 (4) [P1T1]: spike: SQL->[select @@version] 2012-11-28 11:05:57.544 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:57.544 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:57.544 (4) [P1T1]: time=0.0010 2012-11-28 11:05:57.544 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:57.544 (4) [P1T1]: test query succeeded, returned "5.1.57-rel12.8-log" 2012-11-28 11:05:57.545 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:57.545 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:57.545 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`tsacommon`.`accounts`.`id`=694) limit 1] 2012-11-28 11:05:57.547 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-11-28 11:05:57.547 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-11-28 11:05:57.547 (4) [P1T1]: time=0.0020 2012-11-28 11:05:57.547 (4) [P1T1]: Query executed in 0.002s 2012-11-28 11:05:57.547 (5) [P1T1]: loading 19 columns from result set: 2012-11-28 11:05:57.547 (5) [P1T1]: loaded column: accounts.id->694 2012-11-28 11:05:57.548 (5) [P1T1]: loaded column: accounts.description->82190643000197-0411661664 2012-11-28 11:05:57.548 (5) [P1T1]: loaded column: accounts.tier->1 2012-11-28 11:05:57.548 (5) [P1T1]: loaded column: accounts.priority->50 2012-11-28 11:05:57.548 (5) [P1T1]: loaded column: accounts.reportClicksOut->false 2012-11-28 11:05:57.548 (5) [P1T1]: loaded column: accounts.reportConversions->false 2012-11-28 11:05:57.549 (5) [P1T1]: loaded column: accounts.conversionTypes->paid 2012-11-28 11:05:57.549 (5) [P1T1]: loaded column: accounts.isBidManaged->true 2012-11-28 11:05:57.549 (5) [P1T1]: loaded column: accounts.isActive->true 2012-11-28 11:05:57.549 (5) [P1T1]: loaded column: accounts.perfMetric->cpa 2012-11-28 11:05:57.549 (5) [P1T1]: loaded column: accounts.providesConversionData->true 2012-11-28 11:05:57.550 (5) [P1T1]: loaded column: accounts.addConversionData->true 2012-11-28 11:05:57.550 (5) [P1T1]: loaded column: accounts.fractionalConversionCounts->false 2012-11-28 11:05:57.550 (5) [P1T1]: loaded column: accounts.hideNullSources->false 2012-11-28 11:05:57.550 (5) [P1T1]: loaded column: accounts.nowTime->null 2012-11-28 11:05:57.554 (5) [P1T1]: skipping invalid column: accounts.warehouseDatabase 2012-11-28 11:05:57.554 (5) [P1T1]: loaded column: accounts.databaseInstance->1 2012-11-28 11:05:57.554 (5) [P1T1]: loaded column: accounts.warehouseInstance->1 2012-11-28 11:05:57.554 (5) [P1T1]: loaded column: accounts.isOnline->true 2012-11-28 11:05:57.554 (4) [P1T1]: Record Loaded 2012-11-28 11:05:57.556 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:57.557 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:57.557 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`distribution` where (`id`=3) limit 1] 2012-11-28 11:05:57.558 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:57.558 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:57.558 (4) [P1T1]: time=0.0010 2012-11-28 11:05:57.559 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:57.559 (5) [P1T1]: loading 18 columns from result set: 2012-11-28 11:05:57.559 (5) [P1T1]: loaded column: distribution.id->3 2012-11-28 11:05:57.559 (5) [P1T1]: loaded column: distribution.accountID->0 2012-11-28 11:05:57.559 (5) [P1T1]: loaded column: distribution.siteID->0 2012-11-28 11:05:57.559 (5) [P1T1]: loaded column: distribution.type->paid search 2012-11-28 11:05:57.560 (5) [P1T1]: loaded column: distribution.channelID->1 2012-11-28 11:05:57.560 (5) [P1T1]: loaded column: distribution.showStats->1 2012-11-28 11:05:57.560 (5) [P1T1]: loaded column: distribution.bidMatchTypes->exact,phrase,broad,content 2012-11-28 11:05:57.560 (5) [P1T1]: loaded column: distribution.trackMatchTypes->exact,phrase,broad,content 2012-11-28 11:05:57.560 (5) [P1T1]: loaded column: distribution.mergeMatchTypeStats->false 2012-11-28 11:05:57.561 (5) [P1T1]: loaded column: distribution.rollupMatchTypes->content 2012-11-28 11:05:57.561 (5) [P1T1]: loaded column: distribution.positionalBidding->false 2012-11-28 11:05:57.561 (5) [P1T1]: loaded column: distribution.description->Google AdWords 2012-11-28 11:05:57.561 (5) [P1T1]: loaded column: distribution.shortCode->GO 2012-11-28 11:05:57.562 (5) [P1T1]: loaded column: distribution.searchEngineClass->com.thesearchagency.searchengines.google.GoogleAPISearchEngine 2012-11-28 11:05:57.562 (5) [P1T1]: loaded column: distribution.bidMinCPC->0.01 2012-11-28 11:05:57.563 (5) [P1T1]: loaded column: distribution.bidCapCPC->100.0 2012-11-28 11:05:57.563 (5) [P1T1]: loaded column: distribution.bidMinCPM->0.25 2012-11-28 11:05:57.563 (5) [P1T1]: loaded column: distribution.bidCapCPM->500.0 2012-11-28 11:05:57.563 (4) [P1T1]: Record Loaded 2012-11-28 11:05:57.564 (5) [P1T1]: class name is "com.thesearchagency.searchengines.google.GoogleAPISearchEngine" 2012-11-28 11:05:57.636 (4) [P1T1]: User in TSA MCC, connecting using master username/password 2012-11-28 11:05:57.637 (4) [P1T1]: client customer id = 6728067261 2012-11-28 11:05:57.639 (5) [P1T1]: parseInteger->[84] 2012-11-28 11:05:57.639 (5) [P1T1]: parseInteger<-[84] 2012-11-28 11:05:57.731 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-11-28 11:05:57.751 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-11-28 11:05:57.751 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:57.751 (4) [P1T1]: spike: SQL->[select `id`,`shortCode` from distribution where ((`searchEngineClass` is not null) and (`searchEngineClass`!=""))] 2012-11-28 11:05:57.752 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:57.752 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:57.752 (4) [P1T1]: time=0.0010 2012-11-28 11:05:57.752 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:57.753 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-11-28 11:05:57.754 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-11-28 11:05:57.773 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-11-28 11:05:57.775 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:57.775 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="global-sesystem") and (`type`="mysql")) limit 1] 2012-11-28 11:05:57.776 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:57.776 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:57.776 (4) [P1T1]: time=0.0010 2012-11-28 11:05:57.776 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:57.776 (5) [P1T1]: loading 8 columns from result set: 2012-11-28 11:05:57.776 (5) [P1T1]: loaded column: databaseInstances.id->2 2012-11-28 11:05:57.776 (5) [P1T1]: loaded column: databaseInstances.name->global-sesystem 2012-11-28 11:05:57.776 (5) [P1T1]: loaded column: databaseInstances.description->Global Search Engine API system tables 2012-11-28 11:05:57.777 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2012-11-28 11:05:57.777 (5) [P1T1]: loaded column: databaseInstances.database->sesystem 2012-11-28 11:05:57.777 (5) [P1T1]: loaded column: databaseInstances.host->sesystem-01-write 2012-11-28 11:05:57.777 (5) [P1T1]: loaded column: databaseInstances.port->3306 2012-11-28 11:05:57.777 (5) [P1T1]: loaded column: databaseInstances.access->rw 2012-11-28 11:05:57.777 (4) [P1T1]: Record Loaded 2012-11-28 11:05:57.777 (4) [P1T1]: DataCache: put key global-sesystem 2012-11-28 11:05:57.777 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-11-28 11:05:57.798 (4) [P1T1]: opened [jdbc:mysql://sesystem-01-write:3306/sesystem?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-11-28 11:05:57.798 (3) [P1T1]: Created shared sesystem connection rw 2012-11-28 11:05:57.799 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:57.799 (4) [P1T1]: sesystem: SQL->[select 1] 2012-11-28 11:05:57.799 (5) [P1T1]: recordAsSubs("db", 0, "P1T1") 2012-11-28 11:05:57.799 (5) [P1T1]: ProfilerRec.end("db", true): ret=0 2012-11-28 11:05:57.800 (4) [P1T1]: time=0.0 2012-11-28 11:05:57.800 (4) [P1T1]: Query executed in 0.000s 2012-11-28 11:05:57.800 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:57.800 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:57.801 (4) [P1T1]: sesystem: SQL->[select `authToken`,`date` from `sesystem`.`googleAuthToken` where ((`seUserID`=0))] 2012-11-28 11:05:57.801 (5) [P1T1]: recordAsSubs("db", 0, "P1T1") 2012-11-28 11:05:57.801 (5) [P1T1]: ProfilerRec.end("db", true): ret=0 2012-11-28 11:05:57.802 (4) [P1T1]: time=0.0 2012-11-28 11:05:57.802 (4) [P1T1]: Query executed in 0.000s 2012-11-28 11:05:57.802 (4) [P1T1]: MasterAuthToken retrieved from database [DQAAALoAAAByg7of-FSkgZilcKpumI8xzh13ewME5dHgTWueEz5LZxBvOqeW2UL4sjcv4fEQx3O3lEQZLAQQ9CZbWl32bgr9ID0z2NPKP-TTPU8U3eoPTy5vKSoVG-2jcdKtAvPw__mbG1rstBurx3GDyb7pHgwDsKCnudvMDzaSFqqi5PqIbzZEhw-FEltp0re81Vj8vAhL4HpFJAKJw-LoVFrs2pW9fOW2i_AZLWm_3OadSP-_L8WioM80hNZjLejxNbzO_rY] for search engine user ID[0] 2012-11-28 11:05:57.802 (4) [P1T1]: seuserid[84] username[null] password[null] customerID[6728067261] log4j:ERROR Could not read configuration file [/var/local/tsa/config/com.thesearchagency.searchengines.google.GoogleAdWordsAPI.props]. java.io.FileNotFoundException: /var/local/tsa/config/com.thesearchagency.searchengines.google.GoogleAdWordsAPI.props (No such file or directory) at java.io.FileInputStream.open(Native Method) at java.io.FileInputStream.(FileInputStream.java:120) at java.io.FileInputStream.(FileInputStream.java:79) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:316) at org.apache.log4j.PropertyConfigurator.configure(PropertyConfigurator.java:342) at com.google.api.adwords.lib.AdWordsServiceLogger.loadLog4JConfiguration(AdWordsServiceLogger.java:130) at com.thesearchagency.searchengines.google.GoogleAdWordsAPI.(GoogleAdWordsAPI.java:522) at com.thesearchagency.searchengines.google.GoogleAdWordsAPI.(GoogleAdWordsAPI.java:455) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.createAPI(GoogleAPISearchEngine.java:244) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.createAPI(GoogleAPISearchEngine.java:195) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.init(GoogleAPISearchEngine.java:281) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.init(GoogleAPISearchEngine.java:269) at com.thesearchagency.searchengines.SearchEngineFactory.getSearchEngine(SearchEngineFactory.java:160) at com.thesearchagency.searchengines.SearchEngineFactory.getSearchEngine(SearchEngineFactory.java:107) at com.thesearchagency.searchengines.SearchEngineFactory.getSearchEngine(SearchEngineFactory.java:83) at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineUserWorker.run(SearchEngineSummarizer.java:419) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) log4j:ERROR Ignoring configuration file [/var/local/tsa/config/com.thesearchagency.searchengines.google.GoogleAdWordsAPI.props]. 2012-11-28 11:05:57.813 (3) [P1T1]: secureProxy : fwdproxy.syd.optusnet.com.au:3128 2012-11-28 11:05:57.813 (3) [P1T1]: normalProxy : fwdproxy.syd.optusnet.com.au:3128 2012-11-28 11:05:57.813 (4) [P1T1]: ClearConnections called at: Wed Nov 28 11:05:57 EST 2012 Timer: 0 2012-11-28 11:05:57.813 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:57.814 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:57.814 (4) [P1T1]: sesystem: SQL->[select 1] 2012-11-28 11:05:57.815 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:57.815 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:57.815 (4) [P1T1]: time=0.0010 2012-11-28 11:05:57.815 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:57.815 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:57.815 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `holder`="",`inUse`="false",`holderIdentifier`="",`timeStamp`="2012-11-28 11:05:57" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="true") and (`sesystem`.`searchEngineConnections`.`timeStamp`<="2012-11-28 11:00:57")) limit 1], genflags=no 2012-11-28 11:05:57.817 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-11-28 11:05:57.817 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-11-28 11:05:57.817 (4) [P1T1]: time=0.0020 2012-11-28 11:05:57.817 (4) [P1T1]: Query executed in 0.002s, 0 row(s) affected 2012-11-28 11:05:57.825 (4) [P1T1]: Setting AuthToken [DQAAALoAAAByg7of-FSkgZilcKpumI8xzh13ewME5dHgTWueEz5LZxBvOqeW2UL4sjcv4fEQx3O3lEQZLAQQ9CZbWl32bgr9ID0z2NPKP-TTPU8U3eoPTy5vKSoVG-2jcdKtAvPw__mbG1rstBurx3GDyb7pHgwDsKCnudvMDzaSFqqi5PqIbzZEhw-FEltp0re81Vj8vAhL4HpFJAKJw-LoVFrs2pW9fOW2i_AZLWm_3OadSP-_L8WioM80hNZjLejxNbzO_rY] to AdWordsUser object for username[optusbooster@gmail.com] 2012-11-28 11:05:57.827 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-11-28 11:05:57.846 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-11-28 11:05:57.846 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:57.846 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:57.846 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=694) limit 1] 2012-11-28 11:05:57.847 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:57.848 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:57.848 (4) [P1T1]: time=0.0010 2012-11-28 11:05:57.848 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:57.848 (5) [P1T1]: loading 19 columns from result set: 2012-11-28 11:05:57.848 (5) [P1T1]: loaded column: accounts.id->694 2012-11-28 11:05:57.848 (5) [P1T1]: loaded column: accounts.description->82190643000197-0411661664 2012-11-28 11:05:57.848 (5) [P1T1]: loaded column: accounts.tier->1 2012-11-28 11:05:57.848 (5) [P1T1]: loaded column: accounts.priority->50 2012-11-28 11:05:57.848 (5) [P1T1]: loaded column: accounts.reportClicksOut->false 2012-11-28 11:05:57.848 (5) [P1T1]: loaded column: accounts.reportConversions->false 2012-11-28 11:05:57.848 (5) [P1T1]: loaded column: accounts.conversionTypes->paid 2012-11-28 11:05:57.849 (5) [P1T1]: loaded column: accounts.isBidManaged->true 2012-11-28 11:05:57.849 (5) [P1T1]: loaded column: accounts.isActive->true 2012-11-28 11:05:57.849 (5) [P1T1]: loaded column: accounts.perfMetric->cpa 2012-11-28 11:05:57.849 (5) [P1T1]: loaded column: accounts.providesConversionData->true 2012-11-28 11:05:57.849 (5) [P1T1]: loaded column: accounts.addConversionData->true 2012-11-28 11:05:57.849 (5) [P1T1]: loaded column: accounts.fractionalConversionCounts->false 2012-11-28 11:05:57.849 (5) [P1T1]: loaded column: accounts.hideNullSources->false 2012-11-28 11:05:57.849 (5) [P1T1]: loaded column: accounts.nowTime->null 2012-11-28 11:05:57.849 (5) [P1T1]: skipping invalid column: accounts.warehouseDatabase 2012-11-28 11:05:57.849 (5) [P1T1]: loaded column: accounts.databaseInstance->1 2012-11-28 11:05:57.850 (5) [P1T1]: loaded column: accounts.warehouseInstance->1 2012-11-28 11:05:57.850 (5) [P1T1]: loaded column: accounts.isOnline->true 2012-11-28 11:05:57.850 (4) [P1T1]: Record Loaded 2012-11-28 11:05:57.850 (4) [P1T1]: DataCache: put key acct-st-tracker 694 2012-11-28 11:05:57.850 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:57.850 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="acct-st-tracker-1") and (`type`="mysql")) limit 1] 2012-11-28 11:05:57.851 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:57.851 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:57.851 (4) [P1T1]: time=0.0010 2012-11-28 11:05:57.851 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:57.851 (5) [P1T1]: loading 8 columns from result set: 2012-11-28 11:05:57.852 (5) [P1T1]: loaded column: databaseInstances.id->15 2012-11-28 11:05:57.852 (5) [P1T1]: loaded column: databaseInstances.name->acct-st-tracker-1 2012-11-28 11:05:57.852 (5) [P1T1]: loaded column: databaseInstances.description->Account-specific Catch-all database 2012-11-28 11:05:57.852 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2012-11-28 11:05:57.852 (5) [P1T1]: loaded column: databaseInstances.database->st-tracker 2012-11-28 11:05:57.853 (5) [P1T1]: loaded column: databaseInstances.host->acctdb-01-write 2012-11-28 11:05:57.853 (5) [P1T1]: loaded column: databaseInstances.port->3307 2012-11-28 11:05:57.853 (5) [P1T1]: loaded column: databaseInstances.access->rw 2012-11-28 11:05:57.853 (4) [P1T1]: Record Loaded 2012-11-28 11:05:57.853 (4) [P1T1]: DataCache: put key acct-st-tracker-1 2012-11-28 11:05:57.853 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-11-28 11:05:57.853 (3) [P1T1]: DatabasePool with a limit of 352 created 2012-11-28 11:05:57.872 (4) [P1T1]: opened [jdbc:mysql://acctdb-01-write:3307/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-11-28 11:05:57.872 (4) [P1T1]: Created new Object 2012-11-28 11:05:57.872 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:57.872 (4) [P1T1]: spike: SQL->[select @@version] 2012-11-28 11:05:57.873 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:57.873 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:57.874 (4) [P1T1]: time=0.0010 2012-11-28 11:05:57.874 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:57.874 (4) [P1T1]: test query succeeded, returned "5.1.57-rel12.8-log" 2012-11-28 11:05:57.874 (3) [P1T1]: SESUMM: Handling User (84) "82190643000197-0411661664_1" in account (694) 2012-11-28 11:05:57.876 (4) [P1T1]: SearchEngineActivityTable: verifyCreated() called getCreated() for searchEngineActivitySummary201211, got false 2012-11-28 11:05:57.876 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:57.876 (4) [P1T1]: spike: SQL->[show tables in `tmp` like "searchEngineActivitySummary201211"] 2012-11-28 11:05:57.877 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:57.877 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:57.877 (4) [P1T1]: time=0.0010 2012-11-28 11:05:57.877 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:57.878 (5) [P1T1]: quoteValue(), nothing special about it=>[84], type=class java.lang.Integer 2012-11-28 11:05:57.878 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:57.878 (4) [P1T1]: spike: SQL->[select `id`,`searchEngineIdentifier` from `tsacommon`.`searchEngineAccounts` where (`searchEngineUserID`=84)] 2012-11-28 11:05:57.880 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:57.880 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:57.880 (4) [P1T1]: time=0.0010 2012-11-28 11:05:57.880 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:57.881 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-11-28 11:05:57.900 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-11-28 11:05:57.900 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:57.900 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="global-staging") and (`type`="mysql")) limit 1] 2012-11-28 11:05:57.901 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:57.901 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:57.901 (4) [P1T1]: time=0.0010 2012-11-28 11:05:57.901 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:57.901 (5) [P1T1]: loading 8 columns from result set: 2012-11-28 11:05:57.901 (5) [P1T1]: loaded column: databaseInstances.id->3 2012-11-28 11:05:57.901 (5) [P1T1]: loaded column: databaseInstances.name->global-staging 2012-11-28 11:05:57.902 (5) [P1T1]: loaded column: databaseInstances.description->Global Staging Tables 2012-11-28 11:05:57.902 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2012-11-28 11:05:57.902 (5) [P1T1]: loaded column: databaseInstances.database->staging 2012-11-28 11:05:57.902 (5) [P1T1]: loaded column: databaseInstances.host->staging-01-write 2012-11-28 11:05:57.902 (5) [P1T1]: loaded column: databaseInstances.port->3306 2012-11-28 11:05:57.902 (5) [P1T1]: loaded column: databaseInstances.access->rw 2012-11-28 11:05:57.902 (4) [P1T1]: Record Loaded 2012-11-28 11:05:57.902 (4) [P1T1]: DataCache: put key global-staging 2012-11-28 11:05:57.902 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-11-28 11:05:57.902 (3) [P1T1]: DatabasePool with a limit of 352 created 2012-11-28 11:05:57.920 (4) [P1T1]: opened [jdbc:mysql://staging-01-write:3306/staging?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-11-28 11:05:57.920 (4) [P1T1]: Created new Object 2012-11-28 11:05:57.920 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:57.920 (4) [P1T1]: spike: SQL->[select @@version] 2012-11-28 11:05:57.921 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:57.921 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:57.921 (4) [P1T1]: time=0.0010 2012-11-28 11:05:57.921 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:57.921 (4) [P1T1]: test query succeeded, returned "5.1.57-rel12.8-log" 2012-11-28 11:05:57.923 (5) [P1T1]: quoteValue(), nothing special about it=>[94794313], type=class java.lang.Long 2012-11-28 11:05:57.924 (5) [P1T1]: quoteValue(), nothing special about it=>[94794073], type=class java.lang.Long 2012-11-28 11:05:57.924 (5) [P1T1]: quoteValue(), nothing special about it=>[94794193], type=class java.lang.Long 2012-11-28 11:05:57.924 (5) [P1T1]: quoteValue(), nothing special about it=>[94793353], type=class java.lang.Long 2012-11-28 11:05:57.924 (5) [P1T1]: quoteValue(), nothing special about it=>[94793473], type=class java.lang.Long 2012-11-28 11:05:57.924 (5) [P1T1]: quoteValue(), nothing special about it=>[94793113], type=class java.lang.Long 2012-11-28 11:05:57.924 (5) [P1T1]: quoteValue(), nothing special about it=>[94793233], type=class java.lang.Long 2012-11-28 11:05:57.924 (5) [P1T1]: quoteValue(), nothing special about it=>[94881793], type=class java.lang.Long 2012-11-28 11:05:57.924 (5) [P1T1]: quoteValue(), nothing special about it=>[94793833], type=class java.lang.Long 2012-11-28 11:05:57.924 (5) [P1T1]: quoteValue(), nothing special about it=>[94793953], type=class java.lang.Long 2012-11-28 11:05:57.924 (5) [P1T1]: quoteValue(), nothing special about it=>[94793593], type=class java.lang.Long 2012-11-28 11:05:57.924 (5) [P1T1]: quoteValue(), nothing special about it=>[94793713], type=class java.lang.Long 2012-11-28 11:05:57.924 (5) [P1T1]: quoteValue(), nothing special about it=>[94790233], type=class java.lang.Long 2012-11-28 11:05:57.924 (5) [P1T1]: quoteValue(), nothing special about it=>[94790353], type=class java.lang.Long 2012-11-28 11:05:57.924 (5) [P1T1]: quoteValue(), nothing special about it=>[94790473], type=class java.lang.Long 2012-11-28 11:05:57.925 (5) [P1T1]: quoteValue(), nothing special about it=>[94790593], type=class java.lang.Long 2012-11-28 11:05:57.925 (5) [P1T1]: quoteValue(), nothing special about it=>[94790713], type=class java.lang.Long 2012-11-28 11:05:57.925 (5) [P1T1]: quoteValue(), nothing special about it=>[94790833], type=class java.lang.Long 2012-11-28 11:05:57.925 (5) [P1T1]: quoteValue(), nothing special about it=>[94790953], type=class java.lang.Long 2012-11-28 11:05:57.925 (5) [P1T1]: quoteValue(), nothing special about it=>[94791073], type=class java.lang.Long 2012-11-28 11:05:57.925 (5) [P1T1]: quoteValue(), nothing special about it=>[94789273], type=class java.lang.Long 2012-11-28 11:05:57.925 (5) [P1T1]: quoteValue(), nothing special about it=>[94789393], type=class java.lang.Long 2012-11-28 11:05:57.925 (5) [P1T1]: quoteValue(), nothing special about it=>[94789513], type=class java.lang.Long 2012-11-28 11:05:57.925 (5) [P1T1]: quoteValue(), nothing special about it=>[94789633], type=class java.lang.Long 2012-11-28 11:05:57.925 (5) [P1T1]: quoteValue(), nothing special about it=>[94789753], type=class java.lang.Long 2012-11-28 11:05:57.925 (5) [P1T1]: quoteValue(), nothing special about it=>[94789873], type=class java.lang.Long 2012-11-28 11:05:57.925 (5) [P1T1]: quoteValue(), nothing special about it=>[94789993], type=class java.lang.Long 2012-11-28 11:05:57.925 (5) [P1T1]: quoteValue(), nothing special about it=>[94790113], type=class java.lang.Long 2012-11-28 11:05:57.925 (5) [P1T1]: quoteValue(), nothing special about it=>[94792273], type=class java.lang.Long 2012-11-28 11:05:57.925 (5) [P1T1]: quoteValue(), nothing special about it=>[94792153], type=class java.lang.Long 2012-11-28 11:05:57.926 (5) [P1T1]: quoteValue(), nothing special about it=>[94792513], type=class java.lang.Long 2012-11-28 11:05:57.926 (5) [P1T1]: quoteValue(), nothing special about it=>[94792393], type=class java.lang.Long 2012-11-28 11:05:57.926 (5) [P1T1]: quoteValue(), nothing special about it=>[94792753], type=class java.lang.Long 2012-11-28 11:05:57.926 (5) [P1T1]: quoteValue(), nothing special about it=>[94792633], type=class java.lang.Long 2012-11-28 11:05:57.926 (5) [P1T1]: quoteValue(), nothing special about it=>[94792993], type=class java.lang.Long 2012-11-28 11:05:57.926 (5) [P1T1]: quoteValue(), nothing special about it=>[94792873], type=class java.lang.Long 2012-11-28 11:05:57.926 (5) [P1T1]: quoteValue(), nothing special about it=>[94791313], type=class java.lang.Long 2012-11-28 11:05:57.926 (5) [P1T1]: quoteValue(), nothing special about it=>[94791193], type=class java.lang.Long 2012-11-28 11:05:57.926 (5) [P1T1]: quoteValue(), nothing special about it=>[94791553], type=class java.lang.Long 2012-11-28 11:05:57.926 (5) [P1T1]: quoteValue(), nothing special about it=>[94791433], type=class java.lang.Long 2012-11-28 11:05:57.926 (5) [P1T1]: quoteValue(), nothing special about it=>[94791793], type=class java.lang.Long 2012-11-28 11:05:57.926 (5) [P1T1]: quoteValue(), nothing special about it=>[94791673], type=class java.lang.Long 2012-11-28 11:05:57.926 (5) [P1T1]: quoteValue(), nothing special about it=>[94792033], type=class java.lang.Long 2012-11-28 11:05:57.926 (5) [P1T1]: quoteValue(), nothing special about it=>[94791913], type=class java.lang.Long 2012-11-28 11:05:57.927 (5) [P1T1]: quoteValue(), nothing special about it=>[94788073], type=class java.lang.Long 2012-11-28 11:05:57.927 (5) [P1T1]: quoteValue(), nothing special about it=>[94788193], type=class java.lang.Long 2012-11-28 11:05:57.927 (5) [P1T1]: quoteValue(), nothing special about it=>[94787953], type=class java.lang.Long 2012-11-28 11:05:57.927 (5) [P1T1]: quoteValue(), nothing special about it=>[94789033], type=class java.lang.Long 2012-11-28 11:05:57.927 (5) [P1T1]: quoteValue(), nothing special about it=>[94789153], type=class java.lang.Long 2012-11-28 11:05:57.927 (5) [P1T1]: quoteValue(), nothing special about it=>[94788793], type=class java.lang.Long 2012-11-28 11:05:57.927 (5) [P1T1]: quoteValue(), nothing special about it=>[94788913], type=class java.lang.Long 2012-11-28 11:05:57.927 (5) [P1T1]: quoteValue(), nothing special about it=>[94788553], type=class java.lang.Long 2012-11-28 11:05:57.927 (5) [P1T1]: quoteValue(), nothing special about it=>[94788673], type=class java.lang.Long 2012-11-28 11:05:57.927 (5) [P1T1]: quoteValue(), nothing special about it=>[94788313], type=class java.lang.Long 2012-11-28 11:05:57.927 (5) [P1T1]: quoteValue(), nothing special about it=>[94788433], type=class java.lang.Long 2012-11-28 11:05:57.930 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:57.930 (4) [P1T1]: spike: SQL->[select * from `staging`.`googleMcc` where ((`staging`.`googleMcc`.`campaignid` in (94794313,94794073,94794193,94793353,94793473,94793113,94793233,94881793,94793833,94793953,94793593,94793713,94790233,94790353,94790473,94790593,94790713,94790833,94790953,94791073,94789273,94789393,94789513,94789633,94789753,94789873,94789993,94790113,94792273,94792153,94792513,94792393,94792753,94792633,94792993,94792873,94791313,94791193,94791553,94791433,94791793,94791673,94792033,94791913,94788073,94788193,94787953,94789033,94789153,94788793,94788913,94788553,94788673,94788313,94788433)) and (`staging`.`googleMcc`.`startTime`="2012-11-17 00:00:00") and (`staging`.`googleMcc`.`adwordsType`="Search Only") and (`staging`.`googleMcc`.`kwType` in ("Broad","BroadMatch","Exact","Phrase")))] 2012-11-28 11:05:57.932 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-11-28 11:05:57.932 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-11-28 11:05:57.932 (4) [P1T1]: time=0.0020 2012-11-28 11:05:57.932 (4) [P1T1]: Query executed in 0.002s 2012-11-28 11:05:57.932 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:57.932 (4) [P1T1]: spike: SQL->[show create table `staging`.`googleMcc`] 2012-11-28 11:05:57.933 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:57.933 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:57.933 (4) [P1T1]: time=0.0010 2012-11-28 11:05:57.933 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:57.934 (4) [P1T1]: convertCreateTableToTemp: source: CREATE TABLE `googleMcc` ( `startTime` date NOT NULL DEFAULT '0000-00-00', `campaignid` bigint(20) unsigned NOT NULL DEFAULT '0', `adgroupid` bigint(20) unsigned NOT NULL DEFAULT '0', `keywordid` bigint(20) unsigned NOT NULL DEFAULT '0', `keyword` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '', `kwType` enum('Broad','BroadMatch','Content','Phrase','Exact','WebSite','ContentChannel','DocVertical','unknown') NOT NULL DEFAULT 'unknown', `creativeid` bigint(20) unsigned NOT NULL DEFAULT '0', `creativeDestUrl` text NOT NULL, `kwDestUrl` text NOT NULL, `adwordsType` enum('Search Only','Content Only','unknown') NOT NULL DEFAULT 'unknown', `maxCpc` double NOT NULL DEFAULT '0', `imps` int(11) NOT NULL DEFAULT '0', `clicks` int(11) NOT NULL DEFAULT '0', `cost` double NOT NULL DEFAULT '0', `pos` double NOT NULL DEFAULT '0', `conv` int(11) NOT NULL DEFAULT '0', `transactions` int(11) NOT NULL DEFAULT '0', `purchases` int(11) NOT NULL DEFAULT '0', `purchaseValue` double NOT NULL DEFAULT '0', `leads` int(11) NOT NULL DEFAULT '0', `leadValue` double NOT NULL DEFAULT '0', `signups` int(11) NOT NULL DEFAULT '0', `signupValue` double NOT NULL DEFAULT '0', `pageviews` int(11) NOT NULL DEFAULT '0', `pageviewValue` double NOT NULL DEFAULT '0', `defaultConv` int(11) NOT NULL DEFAULT '0', `defaultConvValue` double NOT NULL DEFAULT '0', `qualityScore` double(8,3) DEFAULT NULL, `firstPageCPC` double DEFAULT NULL, PRIMARY KEY (`startTime`,`campaignid`,`adwordsType`,`adgroupid`,`creativeid`,`keywordid`,`kwType`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Column names are defined by Google' 2012-11-28 11:05:57.938 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:57.938 (4) [P1T1]: spike: SQL->[CREATE TEMPORARY TABLE `st-tracker`.`tmp1` ( `startTime` date DEFAULT '0000-00-00', `campaignid` bigint(20) unsigned DEFAULT '0', `adgroupid` bigint(20) unsigned DEFAULT '0', `keywordid` bigint(20) unsigned DEFAULT '0', `keyword` varchar(255) CHARACTER SET utf8 DEFAULT '', `kwType` enum('Broad','BroadMatch','Content','Phrase','Exact','WebSite','ContentChannel','DocVertical','unknown') DEFAULT 'unknown', `creativeid` bigint(20) unsigned DEFAULT '0', `creativeDestUrl` text , `kwDestUrl` text , `adwordsType` enum('Search Only','Content Only','unknown') DEFAULT 'unknown', `maxCpc` double DEFAULT '0', `imps` int(11) DEFAULT '0', `clicks` int(11) DEFAULT '0', `cost` double DEFAULT '0', `pos` double DEFAULT '0', `conv` int(11) DEFAULT '0', `transactions` int(11) DEFAULT '0', `purchases` int(11) DEFAULT '0', `purchaseValue` double DEFAULT '0', `leads` int(11) DEFAULT '0', `leadValue` double DEFAULT '0', `signups` int(11) DEFAULT '0', `signupValue` double DEFAULT '0', `pageviews` int(11) DEFAULT '0', `pageviewValue` double DEFAULT '0', `defaultConv` int(11) DEFAULT '0', `defaultConvValue` double DEFAULT '0', `qualityScore` double(8,3) DEFAULT NULL, `firstPageCPC` double DEFAULT NULL, PRIMARY KEY (`startTime`,`campaignid`,`adwordsType`,`adgroupid`,`creativeid`,`keywordid`,`kwType`))] 2012-11-28 11:05:57.940 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-11-28 11:05:57.940 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-11-28 11:05:57.940 (4) [P1T1]: time=0.0020 2012-11-28 11:05:57.940 (4) [P1T1]: Query executed in 0.002s 2012-11-28 11:05:57.940 (5) [P1T1]: SQL execute() returned false 2012-11-28 11:05:57.941 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.`tmp1` (`startTime`, `campaignid`, `adgroupid`, `keywordid`, `keyword`, `kwType`, `creativeid`, `creativeDestUrl`, `kwDestUrl`, `adwordsType`, `maxCpc`, `imps`, `clicks`, `cost`, `pos`, `conv`, `transactions`, `purchases`, `purchaseValue`, `leads`, `leadValue`, `signups`, `signupValue`, `pageviews`, `pageviewValue`, `defaultConv`, `defaultConvValue`, `qualityScore`, `firstPageCPC`) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)] 2012-11-28 11:05:57.964 (4) [P1T1]: replicated 13 rows to `st-tracker`.`tmp1` 2012-11-28 11:05:57.965 (5) [P1T1]: quoteValue(), nothing special about it=>[4266], type=class java.lang.Integer 2012-11-28 11:05:57.965 (5) [P1T1]: quoteValue(), nothing special about it=>[4264], type=class java.lang.Integer 2012-11-28 11:05:57.965 (5) [P1T1]: quoteValue(), nothing special about it=>[4265], type=class java.lang.Integer 2012-11-28 11:05:57.965 (5) [P1T1]: quoteValue(), nothing special about it=>[4258], type=class java.lang.Integer 2012-11-28 11:05:57.965 (5) [P1T1]: quoteValue(), nothing special about it=>[4259], type=class java.lang.Integer 2012-11-28 11:05:57.965 (5) [P1T1]: quoteValue(), nothing special about it=>[4256], type=class java.lang.Integer 2012-11-28 11:05:57.965 (5) [P1T1]: quoteValue(), nothing special about it=>[4257], type=class java.lang.Integer 2012-11-28 11:05:57.965 (5) [P1T1]: quoteValue(), nothing special about it=>[4736], type=class java.lang.Integer 2012-11-28 11:05:57.965 (5) [P1T1]: quoteValue(), nothing special about it=>[4262], type=class java.lang.Integer 2012-11-28 11:05:57.965 (5) [P1T1]: quoteValue(), nothing special about it=>[4263], type=class java.lang.Integer 2012-11-28 11:05:57.965 (5) [P1T1]: quoteValue(), nothing special about it=>[4260], type=class java.lang.Integer 2012-11-28 11:05:57.965 (5) [P1T1]: quoteValue(), nothing special about it=>[4261], type=class java.lang.Integer 2012-11-28 11:05:57.965 (5) [P1T1]: quoteValue(), nothing special about it=>[4232], type=class java.lang.Integer 2012-11-28 11:05:57.965 (5) [P1T1]: quoteValue(), nothing special about it=>[4233], type=class java.lang.Integer 2012-11-28 11:05:57.965 (5) [P1T1]: quoteValue(), nothing special about it=>[4234], type=class java.lang.Integer 2012-11-28 11:05:57.965 (5) [P1T1]: quoteValue(), nothing special about it=>[4235], type=class java.lang.Integer 2012-11-28 11:05:57.965 (5) [P1T1]: quoteValue(), nothing special about it=>[4236], type=class java.lang.Integer 2012-11-28 11:05:57.966 (5) [P1T1]: quoteValue(), nothing special about it=>[4237], type=class java.lang.Integer 2012-11-28 11:05:57.966 (5) [P1T1]: quoteValue(), nothing special about it=>[4238], type=class java.lang.Integer 2012-11-28 11:05:57.966 (5) [P1T1]: quoteValue(), nothing special about it=>[4239], type=class java.lang.Integer 2012-11-28 11:05:57.966 (5) [P1T1]: quoteValue(), nothing special about it=>[4224], type=class java.lang.Integer 2012-11-28 11:05:57.966 (5) [P1T1]: quoteValue(), nothing special about it=>[4225], type=class java.lang.Integer 2012-11-28 11:05:57.966 (5) [P1T1]: quoteValue(), nothing special about it=>[4226], type=class java.lang.Integer 2012-11-28 11:05:57.966 (5) [P1T1]: quoteValue(), nothing special about it=>[4227], type=class java.lang.Integer 2012-11-28 11:05:57.966 (5) [P1T1]: quoteValue(), nothing special about it=>[4228], type=class java.lang.Integer 2012-11-28 11:05:57.966 (5) [P1T1]: quoteValue(), nothing special about it=>[4229], type=class java.lang.Integer 2012-11-28 11:05:57.966 (5) [P1T1]: quoteValue(), nothing special about it=>[4230], type=class java.lang.Integer 2012-11-28 11:05:57.966 (5) [P1T1]: quoteValue(), nothing special about it=>[4231], type=class java.lang.Integer 2012-11-28 11:05:57.966 (5) [P1T1]: quoteValue(), nothing special about it=>[4249], type=class java.lang.Integer 2012-11-28 11:05:57.966 (5) [P1T1]: quoteValue(), nothing special about it=>[4248], type=class java.lang.Integer 2012-11-28 11:05:57.966 (5) [P1T1]: quoteValue(), nothing special about it=>[4251], type=class java.lang.Integer 2012-11-28 11:05:57.966 (5) [P1T1]: quoteValue(), nothing special about it=>[4250], type=class java.lang.Integer 2012-11-28 11:05:57.966 (5) [P1T1]: quoteValue(), nothing special about it=>[4253], type=class java.lang.Integer 2012-11-28 11:05:57.967 (5) [P1T1]: quoteValue(), nothing special about it=>[4252], type=class java.lang.Integer 2012-11-28 11:05:57.967 (5) [P1T1]: quoteValue(), nothing special about it=>[4255], type=class java.lang.Integer 2012-11-28 11:05:57.967 (5) [P1T1]: quoteValue(), nothing special about it=>[4254], type=class java.lang.Integer 2012-11-28 11:05:57.967 (5) [P1T1]: quoteValue(), nothing special about it=>[4241], type=class java.lang.Integer 2012-11-28 11:05:57.967 (5) [P1T1]: quoteValue(), nothing special about it=>[4240], type=class java.lang.Integer 2012-11-28 11:05:57.967 (5) [P1T1]: quoteValue(), nothing special about it=>[4243], type=class java.lang.Integer 2012-11-28 11:05:57.967 (5) [P1T1]: quoteValue(), nothing special about it=>[4242], type=class java.lang.Integer 2012-11-28 11:05:57.967 (5) [P1T1]: quoteValue(), nothing special about it=>[4245], type=class java.lang.Integer 2012-11-28 11:05:57.967 (5) [P1T1]: quoteValue(), nothing special about it=>[4244], type=class java.lang.Integer 2012-11-28 11:05:57.967 (5) [P1T1]: quoteValue(), nothing special about it=>[4247], type=class java.lang.Integer 2012-11-28 11:05:57.967 (5) [P1T1]: quoteValue(), nothing special about it=>[4246], type=class java.lang.Integer 2012-11-28 11:05:57.967 (5) [P1T1]: quoteValue(), nothing special about it=>[4214], type=class java.lang.Integer 2012-11-28 11:05:57.967 (5) [P1T1]: quoteValue(), nothing special about it=>[4215], type=class java.lang.Integer 2012-11-28 11:05:57.967 (5) [P1T1]: quoteValue(), nothing special about it=>[4213], type=class java.lang.Integer 2012-11-28 11:05:57.967 (5) [P1T1]: quoteValue(), nothing special about it=>[4222], type=class java.lang.Integer 2012-11-28 11:05:57.967 (5) [P1T1]: quoteValue(), nothing special about it=>[4223], type=class java.lang.Integer 2012-11-28 11:05:57.968 (5) [P1T1]: quoteValue(), nothing special about it=>[4220], type=class java.lang.Integer 2012-11-28 11:05:57.968 (5) [P1T1]: quoteValue(), nothing special about it=>[4221], type=class java.lang.Integer 2012-11-28 11:05:57.968 (5) [P1T1]: quoteValue(), nothing special about it=>[4218], type=class java.lang.Integer 2012-11-28 11:05:57.968 (5) [P1T1]: quoteValue(), nothing special about it=>[4219], type=class java.lang.Integer 2012-11-28 11:05:57.968 (5) [P1T1]: quoteValue(), nothing special about it=>[4216], type=class java.lang.Integer 2012-11-28 11:05:57.968 (5) [P1T1]: quoteValue(), nothing special about it=>[4217], type=class java.lang.Integer 2012-11-28 11:05:57.968 (5) [P1T1]: quoteValue(), nothing special about it=>[94794313], type=class java.lang.Long 2012-11-28 11:05:57.968 (5) [P1T1]: quoteValue(), nothing special about it=>[94794073], type=class java.lang.Long 2012-11-28 11:05:57.968 (5) [P1T1]: quoteValue(), nothing special about it=>[94794193], type=class java.lang.Long 2012-11-28 11:05:57.968 (5) [P1T1]: quoteValue(), nothing special about it=>[94793353], type=class java.lang.Long 2012-11-28 11:05:57.968 (5) [P1T1]: quoteValue(), nothing special about it=>[94793473], type=class java.lang.Long 2012-11-28 11:05:57.968 (5) [P1T1]: quoteValue(), nothing special about it=>[94793113], type=class java.lang.Long 2012-11-28 11:05:57.968 (5) [P1T1]: quoteValue(), nothing special about it=>[94793233], type=class java.lang.Long 2012-11-28 11:05:57.968 (5) [P1T1]: quoteValue(), nothing special about it=>[94881793], type=class java.lang.Long 2012-11-28 11:05:57.968 (5) [P1T1]: quoteValue(), nothing special about it=>[94793833], type=class java.lang.Long 2012-11-28 11:05:57.968 (5) [P1T1]: quoteValue(), nothing special about it=>[94793953], type=class java.lang.Long 2012-11-28 11:05:57.969 (5) [P1T1]: quoteValue(), nothing special about it=>[94793593], type=class java.lang.Long 2012-11-28 11:05:57.969 (5) [P1T1]: quoteValue(), nothing special about it=>[94793713], type=class java.lang.Long 2012-11-28 11:05:57.969 (5) [P1T1]: quoteValue(), nothing special about it=>[94790233], type=class java.lang.Long 2012-11-28 11:05:57.969 (5) [P1T1]: quoteValue(), nothing special about it=>[94790353], type=class java.lang.Long 2012-11-28 11:05:57.969 (5) [P1T1]: quoteValue(), nothing special about it=>[94790473], type=class java.lang.Long 2012-11-28 11:05:57.969 (5) [P1T1]: quoteValue(), nothing special about it=>[94790593], type=class java.lang.Long 2012-11-28 11:05:57.969 (5) [P1T1]: quoteValue(), nothing special about it=>[94790713], type=class java.lang.Long 2012-11-28 11:05:57.969 (5) [P1T1]: quoteValue(), nothing special about it=>[94790833], type=class java.lang.Long 2012-11-28 11:05:57.969 (5) [P1T1]: quoteValue(), nothing special about it=>[94790953], type=class java.lang.Long 2012-11-28 11:05:57.969 (5) [P1T1]: quoteValue(), nothing special about it=>[94791073], type=class java.lang.Long 2012-11-28 11:05:57.969 (5) [P1T1]: quoteValue(), nothing special about it=>[94789273], type=class java.lang.Long 2012-11-28 11:05:57.969 (5) [P1T1]: quoteValue(), nothing special about it=>[94789393], type=class java.lang.Long 2012-11-28 11:05:57.969 (5) [P1T1]: quoteValue(), nothing special about it=>[94789513], type=class java.lang.Long 2012-11-28 11:05:57.969 (5) [P1T1]: quoteValue(), nothing special about it=>[94789633], type=class java.lang.Long 2012-11-28 11:05:57.969 (5) [P1T1]: quoteValue(), nothing special about it=>[94789753], type=class java.lang.Long 2012-11-28 11:05:57.969 (5) [P1T1]: quoteValue(), nothing special about it=>[94789873], type=class java.lang.Long 2012-11-28 11:05:57.970 (5) [P1T1]: quoteValue(), nothing special about it=>[94789993], type=class java.lang.Long 2012-11-28 11:05:57.970 (5) [P1T1]: quoteValue(), nothing special about it=>[94790113], type=class java.lang.Long 2012-11-28 11:05:57.970 (5) [P1T1]: quoteValue(), nothing special about it=>[94792273], type=class java.lang.Long 2012-11-28 11:05:57.970 (5) [P1T1]: quoteValue(), nothing special about it=>[94792153], type=class java.lang.Long 2012-11-28 11:05:57.970 (5) [P1T1]: quoteValue(), nothing special about it=>[94792513], type=class java.lang.Long 2012-11-28 11:05:57.970 (5) [P1T1]: quoteValue(), nothing special about it=>[94792393], type=class java.lang.Long 2012-11-28 11:05:57.970 (5) [P1T1]: quoteValue(), nothing special about it=>[94792753], type=class java.lang.Long 2012-11-28 11:05:57.970 (5) [P1T1]: quoteValue(), nothing special about it=>[94792633], type=class java.lang.Long 2012-11-28 11:05:57.970 (5) [P1T1]: quoteValue(), nothing special about it=>[94792993], type=class java.lang.Long 2012-11-28 11:05:57.970 (5) [P1T1]: quoteValue(), nothing special about it=>[94792873], type=class java.lang.Long 2012-11-28 11:05:57.970 (5) [P1T1]: quoteValue(), nothing special about it=>[94791313], type=class java.lang.Long 2012-11-28 11:05:57.970 (5) [P1T1]: quoteValue(), nothing special about it=>[94791193], type=class java.lang.Long 2012-11-28 11:05:57.970 (5) [P1T1]: quoteValue(), nothing special about it=>[94791553], type=class java.lang.Long 2012-11-28 11:05:57.970 (5) [P1T1]: quoteValue(), nothing special about it=>[94791433], type=class java.lang.Long 2012-11-28 11:05:57.970 (5) [P1T1]: quoteValue(), nothing special about it=>[94791793], type=class java.lang.Long 2012-11-28 11:05:57.971 (5) [P1T1]: quoteValue(), nothing special about it=>[94791673], type=class java.lang.Long 2012-11-28 11:05:57.971 (5) [P1T1]: quoteValue(), nothing special about it=>[94792033], type=class java.lang.Long 2012-11-28 11:05:57.971 (5) [P1T1]: quoteValue(), nothing special about it=>[94791913], type=class java.lang.Long 2012-11-28 11:05:57.971 (5) [P1T1]: quoteValue(), nothing special about it=>[94788073], type=class java.lang.Long 2012-11-28 11:05:57.971 (5) [P1T1]: quoteValue(), nothing special about it=>[94788193], type=class java.lang.Long 2012-11-28 11:05:57.971 (5) [P1T1]: quoteValue(), nothing special about it=>[94787953], type=class java.lang.Long 2012-11-28 11:05:57.971 (5) [P1T1]: quoteValue(), nothing special about it=>[94789033], type=class java.lang.Long 2012-11-28 11:05:57.971 (5) [P1T1]: quoteValue(), nothing special about it=>[94789153], type=class java.lang.Long 2012-11-28 11:05:57.971 (5) [P1T1]: quoteValue(), nothing special about it=>[94788793], type=class java.lang.Long 2012-11-28 11:05:57.971 (5) [P1T1]: quoteValue(), nothing special about it=>[94788913], type=class java.lang.Long 2012-11-28 11:05:57.971 (5) [P1T1]: quoteValue(), nothing special about it=>[94788553], type=class java.lang.Long 2012-11-28 11:05:57.971 (5) [P1T1]: quoteValue(), nothing special about it=>[94788673], type=class java.lang.Long 2012-11-28 11:05:57.971 (5) [P1T1]: quoteValue(), nothing special about it=>[94788313], type=class java.lang.Long 2012-11-28 11:05:57.971 (5) [P1T1]: quoteValue(), nothing special about it=>[94788433], type=class java.lang.Long 2012-11-28 11:05:57.973 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:57.973 (4) [P1T1]: spike: SQL->[select `st-tracker`.`searchEngineGroups`.`searchEngineAccountID`,`st-tracker`.`searchEngineGroups`.`id` AS `searchEngineGroupID`,`tmp1`.`creativeid`,`tmp1`.`kwType` AS `searchEngineMatchType`,`tmp1`.`keywordid` AS `searchEngineIdentifier`,SUM(`tmp1`.`imps`) AS `imps`,SUM(`tmp1`.`clicks`) AS `clicks`,SUM(`tmp1`.`cost`) AS `cost`,SUM(`tmp1`.`pos` * `tmp1`.`imps`)/SUM(`tmp1`.`imps`) AS `pos`,`tmp1`.`qualityScore` AS `qualityScore`,`tmp1`.`firstPageCPC` AS `firstPageCPC` from `st-tracker`.`tmp1` inner join `st-tracker`.`searchEngineGroups` on (((((`tmp1`.`adgroupid`=`st-tracker`.`searchEngineGroups`.`searchEngineIdentifier`)) and ((`st-tracker`.`searchEngineGroups`.`searchEngineAccountID` in (4266,4264,4265,4258,4259,4256,4257,4736,4262,4263,4260,4261,4232,4233,4234,4235,4236,4237,4238,4239,4224,4225,4226,4227,4228,4229,4230,4231,4249,4248,4251,4250,4253,4252,4255,4254,4241,4240,4243,4242,4245,4244,4247,4246,4214,4215,4213,4222,4223,4220,4221,4218,4219,4216,4217)))))) where ((`tmp1`.`campaignid` in (94794313,94794073,94794193,94793353,94793473,94793113,94793233,94881793,94793833,94793953,94793593,94793713,94790233,94790353,94790473,94790593,94790713,94790833,94790953,94791073,94789273,94789393,94789513,94789633,94789753,94789873,94789993,94790113,94792273,94792153,94792513,94792393,94792753,94792633,94792993,94792873,94791313,94791193,94791553,94791433,94791793,94791673,94792033,94791913,94788073,94788193,94787953,94789033,94789153,94788793,94788913,94788553,94788673,94788313,94788433)) and (`tmp1`.`startTime`="2012-11-17 00:00:00") and (`tmp1`.`adwordsType`="Search Only") and (`tmp1`.`kwType` in ("Broad","BroadMatch","Exact","Phrase"))) group by `tmp1`.`adgroupid`,`tmp1`.`creativeid`,`keywordid`,`kwType`] 2012-11-28 11:05:57.976 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2012-11-28 11:05:57.976 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2012-11-28 11:05:57.976 (4) [P1T1]: time=0.0030 2012-11-28 11:05:57.976 (4) [P1T1]: Query executed in 0.003s 2012-11-28 11:05:57.977 (5) [P1T1]: parseInteger->[4215] 2012-11-28 11:05:57.977 (5) [P1T1]: parseInteger<-[4215] 2012-11-28 11:05:57.977 (5) [P1T1]: parseInteger->[3] 2012-11-28 11:05:57.977 (5) [P1T1]: parseInteger<-[3] 2012-11-28 11:05:57.977 (5) [P1T1]: parseInteger->[694] 2012-11-28 11:05:57.977 (5) [P1T1]: parseInteger<-[694] 2012-11-28 11:05:57.977 (5) [P1T1]: parseInteger->[4252] 2012-11-28 11:05:57.977 (5) [P1T1]: parseInteger<-[4252] 2012-11-28 11:05:57.978 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:57.978 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:57.979 (5) [P1T1]: quoteValue(), nothing special about it=>[4215], type=class java.lang.Integer 2012-11-28 11:05:57.979 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:57.979 (5) [P1T1]: quoteValue(), nothing special about it=>[4252], type=class java.lang.Integer 2012-11-28 11:05:57.979 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:57.979 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:57.979 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineIdentifier`="17744110"))) and (((`sources`.`searchEngineMatchType`="broad"))) and (((`sources`.`searchEngineAccountID`=4215))) and (((`sources`.`searchEngineGroupID`=4252))))] 2012-11-28 11:05:57.981 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-11-28 11:05:57.981 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-11-28 11:05:57.981 (4) [P1T1]: time=0.0020 2012-11-28 11:05:57.981 (4) [P1T1]: Query executed in 0.002s 2012-11-28 11:05:57.981 (5) [P1T1]: loading 26 columns from result set: 2012-11-28 11:05:57.981 (5) [P1T1]: loaded column: sources.id->221511 2012-11-28 11:05:57.981 (5) [P1T1]: loaded column: sources.altKey->go4728_86s 2012-11-28 11:05:57.982 (5) [P1T1]: loaded column: sources.accountID->694 2012-11-28 11:05:57.982 (5) [P1T1]: loaded column: sources.siteID->0 2012-11-28 11:05:57.982 (5) [P1T1]: loaded column: sources.searchEngineAccountID->4215 2012-11-28 11:05:57.982 (5) [P1T1]: loaded column: sources.keywordID->0 2012-11-28 11:05:57.982 (5) [P1T1]: loaded column: sources.distributionID->3 2012-11-28 11:05:57.982 (5) [P1T1]: loaded column: sources.searchEngineIdentifier->17744110 2012-11-28 11:05:57.982 (5) [P1T1]: loaded column: sources.searchEngineGroupIdentifier->5354982913 2012-11-28 11:05:57.982 (5) [P1T1]: loaded column: sources.searchEngineMatchType->broad 2012-11-28 11:05:57.982 (5) [P1T1]: loaded column: sources.searchEngineGroupID->4252 2012-11-28 11:05:57.982 (5) [P1T1]: loaded column: sources.isBiddable->false 2012-11-28 11:05:57.983 (5) [P1T1]: loaded column: sources.campaignID->0 2012-11-28 11:05:57.983 (5) [P1T1]: loaded column: sources.description->BiddableAdGroupCriterion: [commercial cleaners] broad 2012-11-28 11:05:57.983 (5) [P1T1]: loaded column: sources.type->1 2012-11-28 11:05:57.983 (5) [P1T1]: loaded column: sources.keyword->commercial cleaners 2012-11-28 11:05:57.983 (5) [P1T1]: loaded column: sources.sourceURL-> 2012-11-28 11:05:57.984 (5) [P1T1]: loaded column: sources.cost->0.0 2012-11-28 11:05:57.984 (5) [P1T1]: loaded column: sources.maxCost->0.0 2012-11-28 11:05:57.984 (5) [P1T1]: loaded column: sources.waypointID->null 2012-11-28 11:05:57.984 (5) [P1T1]: loaded column: sources.landingURL->http://www.cleanitoffice.com.au/m/sem-officecleaningcompaniesyarra.html?refcd=go4728_86s&tsacr=go{creative} 2012-11-28 11:05:57.984 (5) [P1T1]: loaded column: sources.passParams-> 2012-11-28 11:05:57.984 (5) [P1T1]: loaded column: sources.trackPerformance->true 2012-11-28 11:05:57.984 (5) [P1T1]: loaded column: sources.searchEngineStatus->ok 2012-11-28 11:05:57.984 (5) [P1T1]: loaded column: sources.searchEngineStatusText->ACTIVE 2012-11-28 11:05:57.984 (5) [P1T1]: loaded column: sources.lastChecked->null 2012-11-28 11:05:57.985 (5) [P1T1]: yesterday: month=11, day=27, year=2012 2012-11-28 11:05:57.985 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:57.986 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:57.986 (4) [P1T1]: spike: SQL->[select `tsacommon`.`searchEngineAccounts`.`searchEngineStatus`,`searchEngineListings`.`id`,`searchEngineListings`.`searchEngineIdentifier`,`altKey`,`searchEngineListings`.`searchEngineStatus` from `searchEngineListings` left join `tsacommon`.`searchEngineAccounts` on ((`tsacommon`.`searchEngineAccounts`.`id`=`searchEngineListings`.`searchEngineAccountID`)) where ((`tsacommon`.`searchEngineAccounts`.`accountID`=694) and (`searchEngineListings`.`searchEngineIdentifier`="22866585193") and (`tsacommon`.`searchEngineAccounts`.`distributionID`="3"))] 2012-11-28 11:05:57.993 (5) [P1T1]: recordAsSubs("db", 7, "P1T1") 2012-11-28 11:05:57.993 (5) [P1T1]: ProfilerRec.end("db", true): ret=7 2012-11-28 11:05:57.993 (4) [P1T1]: time=0.0070 2012-11-28 11:05:57.993 (4) [P1T1]: Query executed in 0.007s 2012-11-28 11:05:57.995 (5) [P1T1]: parseInteger->[4216] 2012-11-28 11:05:57.995 (5) [P1T1]: parseInteger<-[4216] 2012-11-28 11:05:57.995 (5) [P1T1]: parseInteger->[3] 2012-11-28 11:05:57.996 (5) [P1T1]: parseInteger<-[3] 2012-11-28 11:05:57.996 (5) [P1T1]: parseInteger->[694] 2012-11-28 11:05:57.996 (5) [P1T1]: parseInteger<-[694] 2012-11-28 11:05:57.996 (5) [P1T1]: parseInteger->[4219] 2012-11-28 11:05:57.996 (5) [P1T1]: parseInteger<-[4219] 2012-11-28 11:05:57.996 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:57.996 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:57.996 (5) [P1T1]: quoteValue(), nothing special about it=>[4216], type=class java.lang.Integer 2012-11-28 11:05:57.996 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:57.997 (5) [P1T1]: quoteValue(), nothing special about it=>[4219], type=class java.lang.Integer 2012-11-28 11:05:57.997 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:57.997 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:57.997 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineIdentifier`="11490821"))) and (((`sources`.`searchEngineMatchType`="broad"))) and (((`sources`.`searchEngineAccountID`=4216))) and (((`sources`.`searchEngineGroupID`=4219))))] 2012-11-28 11:05:57.998 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:57.998 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:57.998 (4) [P1T1]: time=0.0010 2012-11-28 11:05:57.999 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:57.999 (5) [P1T1]: loading 26 columns from result set: 2012-11-28 11:05:57.999 (5) [P1T1]: loaded column: sources.id->219585 2012-11-28 11:05:57.999 (5) [P1T1]: loaded column: sources.altKey->go4729_162s 2012-11-28 11:05:57.999 (5) [P1T1]: loaded column: sources.accountID->694 2012-11-28 11:05:57.999 (5) [P1T1]: loaded column: sources.siteID->0 2012-11-28 11:05:57.999 (5) [P1T1]: loaded column: sources.searchEngineAccountID->4216 2012-11-28 11:05:57.999 (5) [P1T1]: loaded column: sources.keywordID->0 2012-11-28 11:05:57.999 (5) [P1T1]: loaded column: sources.distributionID->3 2012-11-28 11:05:57.999 (5) [P1T1]: loaded column: sources.searchEngineIdentifier->11490821 2012-11-28 11:05:57.999 (5) [P1T1]: loaded column: sources.searchEngineGroupIdentifier->5354983033 2012-11-28 11:05:57.999 (5) [P1T1]: loaded column: sources.searchEngineMatchType->broad 2012-11-28 11:05:58.000 (5) [P1T1]: loaded column: sources.searchEngineGroupID->4219 2012-11-28 11:05:58.000 (5) [P1T1]: loaded column: sources.isBiddable->false 2012-11-28 11:05:58.000 (5) [P1T1]: loaded column: sources.campaignID->0 2012-11-28 11:05:58.000 (5) [P1T1]: loaded column: sources.description->BiddableAdGroupCriterion: [recycling] broad 2012-11-28 11:05:58.000 (5) [P1T1]: loaded column: sources.type->1 2012-11-28 11:05:58.000 (5) [P1T1]: loaded column: sources.keyword->recycling 2012-11-28 11:05:58.000 (5) [P1T1]: loaded column: sources.sourceURL-> 2012-11-28 11:05:58.000 (5) [P1T1]: loaded column: sources.cost->0.0 2012-11-28 11:05:58.000 (5) [P1T1]: loaded column: sources.maxCost->0.0 2012-11-28 11:05:58.000 (5) [P1T1]: loaded column: sources.waypointID->null 2012-11-28 11:05:58.001 (5) [P1T1]: loaded column: sources.landingURL->http://www.cleanitoffice.com.au/sem-recyclingservicesyarra.html?refcd=go4729_162s&tsacr=go{creative} 2012-11-28 11:05:58.001 (5) [P1T1]: loaded column: sources.passParams-> 2012-11-28 11:05:58.001 (5) [P1T1]: loaded column: sources.trackPerformance->true 2012-11-28 11:05:58.001 (5) [P1T1]: loaded column: sources.searchEngineStatus->ok 2012-11-28 11:05:58.001 (5) [P1T1]: loaded column: sources.searchEngineStatusText->ACTIVE 2012-11-28 11:05:58.001 (5) [P1T1]: loaded column: sources.lastChecked->null 2012-11-28 11:05:58.001 (5) [P1T1]: yesterday: month=11, day=27, year=2012 2012-11-28 11:05:58.001 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.002 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.002 (4) [P1T1]: spike: SQL->[select `tsacommon`.`searchEngineAccounts`.`searchEngineStatus`,`searchEngineListings`.`id`,`searchEngineListings`.`searchEngineIdentifier`,`altKey`,`searchEngineListings`.`searchEngineStatus` from `searchEngineListings` left join `tsacommon`.`searchEngineAccounts` on ((`tsacommon`.`searchEngineAccounts`.`id`=`searchEngineListings`.`searchEngineAccountID`)) where ((`tsacommon`.`searchEngineAccounts`.`accountID`=694) and (`searchEngineListings`.`searchEngineIdentifier`="22866583633") and (`tsacommon`.`searchEngineAccounts`.`distributionID`="3"))] 2012-11-28 11:05:58.003 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.003 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.003 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.003 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.004 (5) [P1T1]: parseInteger->[4216] 2012-11-28 11:05:58.004 (5) [P1T1]: parseInteger<-[4216] 2012-11-28 11:05:58.004 (5) [P1T1]: parseInteger->[3] 2012-11-28 11:05:58.004 (5) [P1T1]: parseInteger<-[3] 2012-11-28 11:05:58.004 (5) [P1T1]: parseInteger->[694] 2012-11-28 11:05:58.004 (5) [P1T1]: parseInteger<-[694] 2012-11-28 11:05:58.004 (5) [P1T1]: parseInteger->[4219] 2012-11-28 11:05:58.004 (5) [P1T1]: parseInteger<-[4219] 2012-11-28 11:05:58.005 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.005 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:58.005 (5) [P1T1]: quoteValue(), nothing special about it=>[4216], type=class java.lang.Integer 2012-11-28 11:05:58.005 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.005 (5) [P1T1]: quoteValue(), nothing special about it=>[4219], type=class java.lang.Integer 2012-11-28 11:05:58.005 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.005 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.005 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineIdentifier`="11490821"))) and (((`sources`.`searchEngineMatchType`="broad"))) and (((`sources`.`searchEngineAccountID`=4216))) and (((`sources`.`searchEngineGroupID`=4219))))] 2012-11-28 11:05:58.007 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-11-28 11:05:58.007 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-11-28 11:05:58.007 (4) [P1T1]: time=0.0020 2012-11-28 11:05:58.007 (4) [P1T1]: Query executed in 0.002s 2012-11-28 11:05:58.007 (5) [P1T1]: loading 26 columns from result set: 2012-11-28 11:05:58.007 (5) [P1T1]: loaded column: sources.id->219585 2012-11-28 11:05:58.007 (5) [P1T1]: loaded column: sources.altKey->go4729_162s 2012-11-28 11:05:58.007 (5) [P1T1]: loaded column: sources.accountID->694 2012-11-28 11:05:58.007 (5) [P1T1]: loaded column: sources.siteID->0 2012-11-28 11:05:58.008 (5) [P1T1]: loaded column: sources.searchEngineAccountID->4216 2012-11-28 11:05:58.008 (5) [P1T1]: loaded column: sources.keywordID->0 2012-11-28 11:05:58.008 (5) [P1T1]: loaded column: sources.distributionID->3 2012-11-28 11:05:58.008 (5) [P1T1]: loaded column: sources.searchEngineIdentifier->11490821 2012-11-28 11:05:58.008 (5) [P1T1]: loaded column: sources.searchEngineGroupIdentifier->5354983033 2012-11-28 11:05:58.008 (5) [P1T1]: loaded column: sources.searchEngineMatchType->broad 2012-11-28 11:05:58.008 (5) [P1T1]: loaded column: sources.searchEngineGroupID->4219 2012-11-28 11:05:58.008 (5) [P1T1]: loaded column: sources.isBiddable->false 2012-11-28 11:05:58.008 (5) [P1T1]: loaded column: sources.campaignID->0 2012-11-28 11:05:58.008 (5) [P1T1]: loaded column: sources.description->BiddableAdGroupCriterion: [recycling] broad 2012-11-28 11:05:58.008 (5) [P1T1]: loaded column: sources.type->1 2012-11-28 11:05:58.009 (5) [P1T1]: loaded column: sources.keyword->recycling 2012-11-28 11:05:58.009 (5) [P1T1]: loaded column: sources.sourceURL-> 2012-11-28 11:05:58.009 (5) [P1T1]: loaded column: sources.cost->0.0 2012-11-28 11:05:58.009 (5) [P1T1]: loaded column: sources.maxCost->0.0 2012-11-28 11:05:58.009 (5) [P1T1]: loaded column: sources.waypointID->null 2012-11-28 11:05:58.009 (5) [P1T1]: loaded column: sources.landingURL->http://www.cleanitoffice.com.au/sem-recyclingservicesyarra.html?refcd=go4729_162s&tsacr=go{creative} 2012-11-28 11:05:58.009 (5) [P1T1]: loaded column: sources.passParams-> 2012-11-28 11:05:58.009 (5) [P1T1]: loaded column: sources.trackPerformance->true 2012-11-28 11:05:58.009 (5) [P1T1]: loaded column: sources.searchEngineStatus->ok 2012-11-28 11:05:58.009 (5) [P1T1]: loaded column: sources.searchEngineStatusText->ACTIVE 2012-11-28 11:05:58.010 (5) [P1T1]: loaded column: sources.lastChecked->null 2012-11-28 11:05:58.010 (5) [P1T1]: yesterday: month=11, day=27, year=2012 2012-11-28 11:05:58.010 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.010 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.010 (4) [P1T1]: spike: SQL->[select `tsacommon`.`searchEngineAccounts`.`searchEngineStatus`,`searchEngineListings`.`id`,`searchEngineListings`.`searchEngineIdentifier`,`altKey`,`searchEngineListings`.`searchEngineStatus` from `searchEngineListings` left join `tsacommon`.`searchEngineAccounts` on ((`tsacommon`.`searchEngineAccounts`.`id`=`searchEngineListings`.`searchEngineAccountID`)) where ((`tsacommon`.`searchEngineAccounts`.`accountID`=694) and (`searchEngineListings`.`searchEngineIdentifier`="22866583753") and (`tsacommon`.`searchEngineAccounts`.`distributionID`="3"))] 2012-11-28 11:05:58.011 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.012 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.012 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.012 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.012 (5) [P1T1]: parseInteger->[4216] 2012-11-28 11:05:58.012 (5) [P1T1]: parseInteger<-[4216] 2012-11-28 11:05:58.012 (5) [P1T1]: parseInteger->[3] 2012-11-28 11:05:58.012 (5) [P1T1]: parseInteger<-[3] 2012-11-28 11:05:58.012 (5) [P1T1]: parseInteger->[694] 2012-11-28 11:05:58.012 (5) [P1T1]: parseInteger<-[694] 2012-11-28 11:05:58.012 (5) [P1T1]: parseInteger->[4219] 2012-11-28 11:05:58.012 (5) [P1T1]: parseInteger<-[4219] 2012-11-28 11:05:58.012 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.013 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:58.013 (5) [P1T1]: quoteValue(), nothing special about it=>[4216], type=class java.lang.Integer 2012-11-28 11:05:58.013 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.013 (5) [P1T1]: quoteValue(), nothing special about it=>[4219], type=class java.lang.Integer 2012-11-28 11:05:58.013 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.013 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.013 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineIdentifier`="11490821"))) and (((`sources`.`searchEngineMatchType`="broad"))) and (((`sources`.`searchEngineAccountID`=4216))) and (((`sources`.`searchEngineGroupID`=4219))))] 2012-11-28 11:05:58.015 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-11-28 11:05:58.015 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-11-28 11:05:58.015 (4) [P1T1]: time=0.0020 2012-11-28 11:05:58.015 (4) [P1T1]: Query executed in 0.002s 2012-11-28 11:05:58.015 (5) [P1T1]: loading 26 columns from result set: 2012-11-28 11:05:58.015 (5) [P1T1]: loaded column: sources.id->219585 2012-11-28 11:05:58.015 (5) [P1T1]: loaded column: sources.altKey->go4729_162s 2012-11-28 11:05:58.015 (5) [P1T1]: loaded column: sources.accountID->694 2012-11-28 11:05:58.015 (5) [P1T1]: loaded column: sources.siteID->0 2012-11-28 11:05:58.015 (5) [P1T1]: loaded column: sources.searchEngineAccountID->4216 2012-11-28 11:05:58.015 (5) [P1T1]: loaded column: sources.keywordID->0 2012-11-28 11:05:58.015 (5) [P1T1]: loaded column: sources.distributionID->3 2012-11-28 11:05:58.016 (5) [P1T1]: loaded column: sources.searchEngineIdentifier->11490821 2012-11-28 11:05:58.016 (5) [P1T1]: loaded column: sources.searchEngineGroupIdentifier->5354983033 2012-11-28 11:05:58.016 (5) [P1T1]: loaded column: sources.searchEngineMatchType->broad 2012-11-28 11:05:58.016 (5) [P1T1]: loaded column: sources.searchEngineGroupID->4219 2012-11-28 11:05:58.016 (5) [P1T1]: loaded column: sources.isBiddable->false 2012-11-28 11:05:58.016 (5) [P1T1]: loaded column: sources.campaignID->0 2012-11-28 11:05:58.016 (5) [P1T1]: loaded column: sources.description->BiddableAdGroupCriterion: [recycling] broad 2012-11-28 11:05:58.016 (5) [P1T1]: loaded column: sources.type->1 2012-11-28 11:05:58.016 (5) [P1T1]: loaded column: sources.keyword->recycling 2012-11-28 11:05:58.016 (5) [P1T1]: loaded column: sources.sourceURL-> 2012-11-28 11:05:58.016 (5) [P1T1]: loaded column: sources.cost->0.0 2012-11-28 11:05:58.017 (5) [P1T1]: loaded column: sources.maxCost->0.0 2012-11-28 11:05:58.017 (5) [P1T1]: loaded column: sources.waypointID->null 2012-11-28 11:05:58.017 (5) [P1T1]: loaded column: sources.landingURL->http://www.cleanitoffice.com.au/sem-recyclingservicesyarra.html?refcd=go4729_162s&tsacr=go{creative} 2012-11-28 11:05:58.017 (5) [P1T1]: loaded column: sources.passParams-> 2012-11-28 11:05:58.017 (5) [P1T1]: loaded column: sources.trackPerformance->true 2012-11-28 11:05:58.017 (5) [P1T1]: loaded column: sources.searchEngineStatus->ok 2012-11-28 11:05:58.017 (5) [P1T1]: loaded column: sources.searchEngineStatusText->ACTIVE 2012-11-28 11:05:58.017 (5) [P1T1]: loaded column: sources.lastChecked->null 2012-11-28 11:05:58.017 (5) [P1T1]: yesterday: month=11, day=27, year=2012 2012-11-28 11:05:58.018 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.018 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.018 (4) [P1T1]: spike: SQL->[select `tsacommon`.`searchEngineAccounts`.`searchEngineStatus`,`searchEngineListings`.`id`,`searchEngineListings`.`searchEngineIdentifier`,`altKey`,`searchEngineListings`.`searchEngineStatus` from `searchEngineListings` left join `tsacommon`.`searchEngineAccounts` on ((`tsacommon`.`searchEngineAccounts`.`id`=`searchEngineListings`.`searchEngineAccountID`)) where ((`tsacommon`.`searchEngineAccounts`.`accountID`=694) and (`searchEngineListings`.`searchEngineIdentifier`="22866583873") and (`tsacommon`.`searchEngineAccounts`.`distributionID`="3"))] 2012-11-28 11:05:58.019 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.019 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.019 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.019 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.020 (5) [P1T1]: parseInteger->[4216] 2012-11-28 11:05:58.020 (5) [P1T1]: parseInteger<-[4216] 2012-11-28 11:05:58.020 (5) [P1T1]: parseInteger->[3] 2012-11-28 11:05:58.020 (5) [P1T1]: parseInteger<-[3] 2012-11-28 11:05:58.020 (5) [P1T1]: parseInteger->[694] 2012-11-28 11:05:58.020 (5) [P1T1]: parseInteger<-[694] 2012-11-28 11:05:58.020 (5) [P1T1]: parseInteger->[4219] 2012-11-28 11:05:58.020 (5) [P1T1]: parseInteger<-[4219] 2012-11-28 11:05:58.020 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.020 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:58.021 (5) [P1T1]: quoteValue(), nothing special about it=>[4216], type=class java.lang.Integer 2012-11-28 11:05:58.021 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.021 (5) [P1T1]: quoteValue(), nothing special about it=>[4219], type=class java.lang.Integer 2012-11-28 11:05:58.021 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.021 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.021 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineIdentifier`="14628573"))) and (((`sources`.`searchEngineMatchType`="broad"))) and (((`sources`.`searchEngineAccountID`=4216))) and (((`sources`.`searchEngineGroupID`=4219))))] 2012-11-28 11:05:58.022 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.023 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.023 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.023 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.023 (5) [P1T1]: loading 26 columns from result set: 2012-11-28 11:05:58.023 (5) [P1T1]: loaded column: sources.id->219589 2012-11-28 11:05:58.023 (5) [P1T1]: loaded column: sources.altKey->go4729_165s 2012-11-28 11:05:58.023 (5) [P1T1]: loaded column: sources.accountID->694 2012-11-28 11:05:58.023 (5) [P1T1]: loaded column: sources.siteID->0 2012-11-28 11:05:58.023 (5) [P1T1]: loaded column: sources.searchEngineAccountID->4216 2012-11-28 11:05:58.023 (5) [P1T1]: loaded column: sources.keywordID->0 2012-11-28 11:05:58.023 (5) [P1T1]: loaded column: sources.distributionID->3 2012-11-28 11:05:58.023 (5) [P1T1]: loaded column: sources.searchEngineIdentifier->14628573 2012-11-28 11:05:58.023 (5) [P1T1]: loaded column: sources.searchEngineGroupIdentifier->5354983033 2012-11-28 11:05:58.024 (5) [P1T1]: loaded column: sources.searchEngineMatchType->broad 2012-11-28 11:05:58.024 (5) [P1T1]: loaded column: sources.searchEngineGroupID->4219 2012-11-28 11:05:58.024 (5) [P1T1]: loaded column: sources.isBiddable->false 2012-11-28 11:05:58.024 (5) [P1T1]: loaded column: sources.campaignID->0 2012-11-28 11:05:58.024 (5) [P1T1]: loaded column: sources.description->BiddableAdGroupCriterion: [recycling bin] broad 2012-11-28 11:05:58.024 (5) [P1T1]: loaded column: sources.type->1 2012-11-28 11:05:58.024 (5) [P1T1]: loaded column: sources.keyword->recycling bin 2012-11-28 11:05:58.024 (5) [P1T1]: loaded column: sources.sourceURL-> 2012-11-28 11:05:58.024 (5) [P1T1]: loaded column: sources.cost->0.0 2012-11-28 11:05:58.024 (5) [P1T1]: loaded column: sources.maxCost->0.0 2012-11-28 11:05:58.024 (5) [P1T1]: loaded column: sources.waypointID->null 2012-11-28 11:05:58.025 (5) [P1T1]: loaded column: sources.landingURL->http://www.cleanitoffice.com.au/sem-recyclingservicesyarra.html?refcd=go4729_165s&tsacr=go{creative} 2012-11-28 11:05:58.025 (5) [P1T1]: loaded column: sources.passParams-> 2012-11-28 11:05:58.025 (5) [P1T1]: loaded column: sources.trackPerformance->true 2012-11-28 11:05:58.025 (5) [P1T1]: loaded column: sources.searchEngineStatus->ok 2012-11-28 11:05:58.025 (5) [P1T1]: loaded column: sources.searchEngineStatusText->ACTIVE 2012-11-28 11:05:58.025 (5) [P1T1]: loaded column: sources.lastChecked->null 2012-11-28 11:05:58.025 (5) [P1T1]: yesterday: month=11, day=27, year=2012 2012-11-28 11:05:58.025 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.026 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.026 (4) [P1T1]: spike: SQL->[select `tsacommon`.`searchEngineAccounts`.`searchEngineStatus`,`searchEngineListings`.`id`,`searchEngineListings`.`searchEngineIdentifier`,`altKey`,`searchEngineListings`.`searchEngineStatus` from `searchEngineListings` left join `tsacommon`.`searchEngineAccounts` on ((`tsacommon`.`searchEngineAccounts`.`id`=`searchEngineListings`.`searchEngineAccountID`)) where ((`tsacommon`.`searchEngineAccounts`.`accountID`=694) and (`searchEngineListings`.`searchEngineIdentifier`="22866583873") and (`tsacommon`.`searchEngineAccounts`.`distributionID`="3"))] 2012-11-28 11:05:58.027 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.027 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.027 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.027 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.027 (5) [P1T1]: parseInteger->[4217] 2012-11-28 11:05:58.027 (5) [P1T1]: parseInteger<-[4217] 2012-11-28 11:05:58.028 (5) [P1T1]: parseInteger->[3] 2012-11-28 11:05:58.028 (5) [P1T1]: parseInteger<-[3] 2012-11-28 11:05:58.028 (5) [P1T1]: parseInteger->[694] 2012-11-28 11:05:58.028 (5) [P1T1]: parseInteger<-[694] 2012-11-28 11:05:58.028 (5) [P1T1]: parseInteger->[4259] 2012-11-28 11:05:58.028 (5) [P1T1]: parseInteger<-[4259] 2012-11-28 11:05:58.028 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.028 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:58.028 (5) [P1T1]: quoteValue(), nothing special about it=>[4217], type=class java.lang.Integer 2012-11-28 11:05:58.028 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.028 (5) [P1T1]: quoteValue(), nothing special about it=>[4259], type=class java.lang.Integer 2012-11-28 11:05:58.029 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.029 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.029 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineIdentifier`="45120431233"))) and (((`sources`.`searchEngineMatchType`="exact"))) and (((`sources`.`searchEngineAccountID`=4217))) and (((`sources`.`searchEngineGroupID`=4259))))] 2012-11-28 11:05:58.030 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.030 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.030 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.030 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.030 (5) [P1T1]: loading 26 columns from result set: 2012-11-28 11:05:58.031 (5) [P1T1]: loaded column: sources.id->222307 2012-11-28 11:05:58.031 (5) [P1T1]: loaded column: sources.altKey->go4730_210s 2012-11-28 11:05:58.031 (5) [P1T1]: loaded column: sources.accountID->694 2012-11-28 11:05:58.031 (5) [P1T1]: loaded column: sources.siteID->0 2012-11-28 11:05:58.031 (5) [P1T1]: loaded column: sources.searchEngineAccountID->4217 2012-11-28 11:05:58.031 (5) [P1T1]: loaded column: sources.keywordID->0 2012-11-28 11:05:58.031 (5) [P1T1]: loaded column: sources.distributionID->3 2012-11-28 11:05:58.031 (5) [P1T1]: loaded column: sources.searchEngineIdentifier->45120431233 2012-11-28 11:05:58.031 (5) [P1T1]: loaded column: sources.searchEngineGroupIdentifier->5354983153 2012-11-28 11:05:58.031 (5) [P1T1]: loaded column: sources.searchEngineMatchType->exact 2012-11-28 11:05:58.031 (5) [P1T1]: loaded column: sources.searchEngineGroupID->4259 2012-11-28 11:05:58.032 (5) [P1T1]: loaded column: sources.isBiddable->false 2012-11-28 11:05:58.032 (5) [P1T1]: loaded column: sources.campaignID->0 2012-11-28 11:05:58.032 (5) [P1T1]: loaded column: sources.description->BiddableAdGroupCriterion: [Yarra recycling] exact 2012-11-28 11:05:58.032 (5) [P1T1]: loaded column: sources.type->1 2012-11-28 11:05:58.032 (5) [P1T1]: loaded column: sources.keyword->Yarra recycling 2012-11-28 11:05:58.032 (5) [P1T1]: loaded column: sources.sourceURL-> 2012-11-28 11:05:58.032 (5) [P1T1]: loaded column: sources.cost->0.0 2012-11-28 11:05:58.032 (5) [P1T1]: loaded column: sources.maxCost->0.0 2012-11-28 11:05:58.032 (5) [P1T1]: loaded column: sources.waypointID->null 2012-11-28 11:05:58.032 (5) [P1T1]: loaded column: sources.landingURL->http://www.cleanitoffice.com.au/sem-recyclingservicesyarra.html?refcd=go4730_210s&tsacr=go{creative} 2012-11-28 11:05:58.032 (5) [P1T1]: loaded column: sources.passParams-> 2012-11-28 11:05:58.033 (5) [P1T1]: loaded column: sources.trackPerformance->true 2012-11-28 11:05:58.033 (5) [P1T1]: loaded column: sources.searchEngineStatus->ok 2012-11-28 11:05:58.033 (5) [P1T1]: loaded column: sources.searchEngineStatusText->ACTIVE 2012-11-28 11:05:58.033 (5) [P1T1]: loaded column: sources.lastChecked->null 2012-11-28 11:05:58.033 (5) [P1T1]: yesterday: month=11, day=27, year=2012 2012-11-28 11:05:58.033 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.033 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.034 (4) [P1T1]: spike: SQL->[select `tsacommon`.`searchEngineAccounts`.`searchEngineStatus`,`searchEngineListings`.`id`,`searchEngineListings`.`searchEngineIdentifier`,`altKey`,`searchEngineListings`.`searchEngineStatus` from `searchEngineListings` left join `tsacommon`.`searchEngineAccounts` on ((`tsacommon`.`searchEngineAccounts`.`id`=`searchEngineListings`.`searchEngineAccountID`)) where ((`tsacommon`.`searchEngineAccounts`.`accountID`=694) and (`searchEngineListings`.`searchEngineIdentifier`="22866585553") and (`tsacommon`.`searchEngineAccounts`.`distributionID`="3"))] 2012-11-28 11:05:58.035 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.035 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.035 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.035 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.035 (5) [P1T1]: parseInteger->[4219] 2012-11-28 11:05:58.035 (5) [P1T1]: parseInteger<-[4219] 2012-11-28 11:05:58.035 (5) [P1T1]: parseInteger->[3] 2012-11-28 11:05:58.035 (5) [P1T1]: parseInteger<-[3] 2012-11-28 11:05:58.035 (5) [P1T1]: parseInteger->[694] 2012-11-28 11:05:58.035 (5) [P1T1]: parseInteger<-[694] 2012-11-28 11:05:58.036 (5) [P1T1]: parseInteger->[4253] 2012-11-28 11:05:58.036 (5) [P1T1]: parseInteger<-[4253] 2012-11-28 11:05:58.036 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.036 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:58.036 (5) [P1T1]: quoteValue(), nothing special about it=>[4219], type=class java.lang.Integer 2012-11-28 11:05:58.036 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.036 (5) [P1T1]: quoteValue(), nothing special about it=>[4253], type=class java.lang.Integer 2012-11-28 11:05:58.036 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.036 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.036 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineIdentifier`="13202360"))) and (((`sources`.`searchEngineMatchType`="broad"))) and (((`sources`.`searchEngineAccountID`=4219))) and (((`sources`.`searchEngineGroupID`=4253))))] 2012-11-28 11:05:58.038 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-11-28 11:05:58.038 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-11-28 11:05:58.038 (4) [P1T1]: time=0.0020 2012-11-28 11:05:58.038 (4) [P1T1]: Query executed in 0.002s 2012-11-28 11:05:58.038 (5) [P1T1]: loading 26 columns from result set: 2012-11-28 11:05:58.038 (5) [P1T1]: loaded column: sources.id->221561 2012-11-28 11:05:58.038 (5) [P1T1]: loaded column: sources.altKey->go4732_353s 2012-11-28 11:05:58.038 (5) [P1T1]: loaded column: sources.accountID->694 2012-11-28 11:05:58.038 (5) [P1T1]: loaded column: sources.siteID->0 2012-11-28 11:05:58.039 (5) [P1T1]: loaded column: sources.searchEngineAccountID->4219 2012-11-28 11:05:58.039 (5) [P1T1]: loaded column: sources.keywordID->0 2012-11-28 11:05:58.039 (5) [P1T1]: loaded column: sources.distributionID->3 2012-11-28 11:05:58.039 (5) [P1T1]: loaded column: sources.searchEngineIdentifier->13202360 2012-11-28 11:05:58.039 (5) [P1T1]: loaded column: sources.searchEngineGroupIdentifier->5354983393 2012-11-28 11:05:58.039 (5) [P1T1]: loaded column: sources.searchEngineMatchType->broad 2012-11-28 11:05:58.039 (5) [P1T1]: loaded column: sources.searchEngineGroupID->4253 2012-11-28 11:05:58.039 (5) [P1T1]: loaded column: sources.isBiddable->false 2012-11-28 11:05:58.039 (5) [P1T1]: loaded column: sources.campaignID->0 2012-11-28 11:05:58.039 (5) [P1T1]: loaded column: sources.description->BiddableAdGroupCriterion: [window cleaning] broad 2012-11-28 11:05:58.039 (5) [P1T1]: loaded column: sources.type->1 2012-11-28 11:05:58.039 (5) [P1T1]: loaded column: sources.keyword->window cleaning 2012-11-28 11:05:58.040 (5) [P1T1]: loaded column: sources.sourceURL-> 2012-11-28 11:05:58.040 (5) [P1T1]: loaded column: sources.cost->0.0 2012-11-28 11:05:58.040 (5) [P1T1]: loaded column: sources.maxCost->0.0 2012-11-28 11:05:58.040 (5) [P1T1]: loaded column: sources.waypointID->null 2012-11-28 11:05:58.040 (5) [P1T1]: loaded column: sources.landingURL->http://www.cleanitoffice.com.au/sem-windowcleaningservicesyarra.html?refcd=go4732_353s&tsacr=go{creative} 2012-11-28 11:05:58.040 (5) [P1T1]: loaded column: sources.passParams-> 2012-11-28 11:05:58.040 (5) [P1T1]: loaded column: sources.trackPerformance->true 2012-11-28 11:05:58.040 (5) [P1T1]: loaded column: sources.searchEngineStatus->ok 2012-11-28 11:05:58.040 (5) [P1T1]: loaded column: sources.searchEngineStatusText->ACTIVE 2012-11-28 11:05:58.040 (5) [P1T1]: loaded column: sources.lastChecked->null 2012-11-28 11:05:58.041 (5) [P1T1]: yesterday: month=11, day=27, year=2012 2012-11-28 11:05:58.041 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.041 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.041 (4) [P1T1]: spike: SQL->[select `tsacommon`.`searchEngineAccounts`.`searchEngineStatus`,`searchEngineListings`.`id`,`searchEngineListings`.`searchEngineIdentifier`,`altKey`,`searchEngineListings`.`searchEngineStatus` from `searchEngineListings` left join `tsacommon`.`searchEngineAccounts` on ((`tsacommon`.`searchEngineAccounts`.`id`=`searchEngineListings`.`searchEngineAccountID`)) where ((`tsacommon`.`searchEngineAccounts`.`accountID`=694) and (`searchEngineListings`.`searchEngineIdentifier`="22866586513") and (`tsacommon`.`searchEngineAccounts`.`distributionID`="3"))] 2012-11-28 11:05:58.042 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.042 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.042 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.042 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.043 (5) [P1T1]: parseInteger->[4219] 2012-11-28 11:05:58.043 (5) [P1T1]: parseInteger<-[4219] 2012-11-28 11:05:58.043 (5) [P1T1]: parseInteger->[3] 2012-11-28 11:05:58.043 (5) [P1T1]: parseInteger<-[3] 2012-11-28 11:05:58.043 (5) [P1T1]: parseInteger->[694] 2012-11-28 11:05:58.043 (5) [P1T1]: parseInteger<-[694] 2012-11-28 11:05:58.043 (5) [P1T1]: parseInteger->[4253] 2012-11-28 11:05:58.043 (5) [P1T1]: parseInteger<-[4253] 2012-11-28 11:05:58.043 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.043 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:58.043 (5) [P1T1]: quoteValue(), nothing special about it=>[4219], type=class java.lang.Integer 2012-11-28 11:05:58.044 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.044 (5) [P1T1]: quoteValue(), nothing special about it=>[4253], type=class java.lang.Integer 2012-11-28 11:05:58.044 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.044 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.044 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineIdentifier`="13166880"))) and (((`sources`.`searchEngineMatchType`="broad"))) and (((`sources`.`searchEngineAccountID`=4219))) and (((`sources`.`searchEngineGroupID`=4253))))] 2012-11-28 11:05:58.045 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.045 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.046 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.046 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.046 (5) [P1T1]: loading 26 columns from result set: 2012-11-28 11:05:58.046 (5) [P1T1]: loaded column: sources.id->221559 2012-11-28 11:05:58.046 (5) [P1T1]: loaded column: sources.altKey->go4732_346s 2012-11-28 11:05:58.046 (5) [P1T1]: loaded column: sources.accountID->694 2012-11-28 11:05:58.046 (5) [P1T1]: loaded column: sources.siteID->0 2012-11-28 11:05:58.046 (5) [P1T1]: loaded column: sources.searchEngineAccountID->4219 2012-11-28 11:05:58.046 (5) [P1T1]: loaded column: sources.keywordID->0 2012-11-28 11:05:58.046 (5) [P1T1]: loaded column: sources.distributionID->3 2012-11-28 11:05:58.046 (5) [P1T1]: loaded column: sources.searchEngineIdentifier->13166880 2012-11-28 11:05:58.047 (5) [P1T1]: loaded column: sources.searchEngineGroupIdentifier->5354983393 2012-11-28 11:05:58.047 (5) [P1T1]: loaded column: sources.searchEngineMatchType->broad 2012-11-28 11:05:58.047 (5) [P1T1]: loaded column: sources.searchEngineGroupID->4253 2012-11-28 11:05:58.047 (5) [P1T1]: loaded column: sources.isBiddable->false 2012-11-28 11:05:58.047 (5) [P1T1]: loaded column: sources.campaignID->0 2012-11-28 11:05:58.047 (5) [P1T1]: loaded column: sources.description->BiddableAdGroupCriterion: [window cleaner] broad 2012-11-28 11:05:58.047 (5) [P1T1]: loaded column: sources.type->1 2012-11-28 11:05:58.047 (5) [P1T1]: loaded column: sources.keyword->window cleaner 2012-11-28 11:05:58.047 (5) [P1T1]: loaded column: sources.sourceURL-> 2012-11-28 11:05:58.047 (5) [P1T1]: loaded column: sources.cost->0.0 2012-11-28 11:05:58.047 (5) [P1T1]: loaded column: sources.maxCost->0.0 2012-11-28 11:05:58.047 (5) [P1T1]: loaded column: sources.waypointID->null 2012-11-28 11:05:58.048 (5) [P1T1]: loaded column: sources.landingURL->http://www.cleanitoffice.com.au/sem-windowcleaningservicesyarra.html?refcd=go4732_346s&tsacr=go{creative} 2012-11-28 11:05:58.048 (5) [P1T1]: loaded column: sources.passParams-> 2012-11-28 11:05:58.048 (5) [P1T1]: loaded column: sources.trackPerformance->true 2012-11-28 11:05:58.048 (5) [P1T1]: loaded column: sources.searchEngineStatus->ok 2012-11-28 11:05:58.048 (5) [P1T1]: loaded column: sources.searchEngineStatusText->ACTIVE 2012-11-28 11:05:58.048 (5) [P1T1]: loaded column: sources.lastChecked->null 2012-11-28 11:05:58.048 (5) [P1T1]: yesterday: month=11, day=27, year=2012 2012-11-28 11:05:58.048 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.049 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.049 (4) [P1T1]: spike: SQL->[select `tsacommon`.`searchEngineAccounts`.`searchEngineStatus`,`searchEngineListings`.`id`,`searchEngineListings`.`searchEngineIdentifier`,`altKey`,`searchEngineListings`.`searchEngineStatus` from `searchEngineListings` left join `tsacommon`.`searchEngineAccounts` on ((`tsacommon`.`searchEngineAccounts`.`id`=`searchEngineListings`.`searchEngineAccountID`)) where ((`tsacommon`.`searchEngineAccounts`.`accountID`=694) and (`searchEngineListings`.`searchEngineIdentifier`="22866586753") and (`tsacommon`.`searchEngineAccounts`.`distributionID`="3"))] 2012-11-28 11:05:58.050 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.050 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.050 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.050 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.050 (5) [P1T1]: parseInteger->[4225] 2012-11-28 11:05:58.050 (5) [P1T1]: parseInteger<-[4225] 2012-11-28 11:05:58.050 (5) [P1T1]: parseInteger->[3] 2012-11-28 11:05:58.051 (5) [P1T1]: parseInteger<-[3] 2012-11-28 11:05:58.051 (5) [P1T1]: parseInteger->[694] 2012-11-28 11:05:58.051 (5) [P1T1]: parseInteger<-[694] 2012-11-28 11:05:58.051 (5) [P1T1]: parseInteger->[4231] 2012-11-28 11:05:58.051 (5) [P1T1]: parseInteger<-[4231] 2012-11-28 11:05:58.051 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.051 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:58.051 (5) [P1T1]: quoteValue(), nothing special about it=>[4225], type=class java.lang.Integer 2012-11-28 11:05:58.051 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.051 (5) [P1T1]: quoteValue(), nothing special about it=>[4231], type=class java.lang.Integer 2012-11-28 11:05:58.051 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.052 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.052 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineIdentifier`="11490821"))) and (((`sources`.`searchEngineMatchType`="broad"))) and (((`sources`.`searchEngineAccountID`=4225))) and (((`sources`.`searchEngineGroupID`=4231))))] 2012-11-28 11:05:58.053 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.053 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.053 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.053 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.053 (5) [P1T1]: loading 26 columns from result set: 2012-11-28 11:05:58.053 (5) [P1T1]: loaded column: sources.id->220937 2012-11-28 11:05:58.054 (5) [P1T1]: loaded column: sources.altKey->go4738_630s 2012-11-28 11:05:58.054 (5) [P1T1]: loaded column: sources.accountID->694 2012-11-28 11:05:58.054 (5) [P1T1]: loaded column: sources.siteID->0 2012-11-28 11:05:58.054 (5) [P1T1]: loaded column: sources.searchEngineAccountID->4225 2012-11-28 11:05:58.054 (5) [P1T1]: loaded column: sources.keywordID->0 2012-11-28 11:05:58.054 (5) [P1T1]: loaded column: sources.distributionID->3 2012-11-28 11:05:58.054 (5) [P1T1]: loaded column: sources.searchEngineIdentifier->11490821 2012-11-28 11:05:58.054 (5) [P1T1]: loaded column: sources.searchEngineGroupIdentifier->5354984113 2012-11-28 11:05:58.054 (5) [P1T1]: loaded column: sources.searchEngineMatchType->broad 2012-11-28 11:05:58.054 (5) [P1T1]: loaded column: sources.searchEngineGroupID->4231 2012-11-28 11:05:58.054 (5) [P1T1]: loaded column: sources.isBiddable->false 2012-11-28 11:05:58.054 (5) [P1T1]: loaded column: sources.campaignID->0 2012-11-28 11:05:58.055 (5) [P1T1]: loaded column: sources.description->BiddableAdGroupCriterion: [recycling] broad 2012-11-28 11:05:58.055 (5) [P1T1]: loaded column: sources.type->1 2012-11-28 11:05:58.055 (5) [P1T1]: loaded column: sources.keyword->recycling 2012-11-28 11:05:58.055 (5) [P1T1]: loaded column: sources.sourceURL-> 2012-11-28 11:05:58.055 (5) [P1T1]: loaded column: sources.cost->0.0 2012-11-28 11:05:58.055 (5) [P1T1]: loaded column: sources.maxCost->0.0 2012-11-28 11:05:58.055 (5) [P1T1]: loaded column: sources.waypointID->null 2012-11-28 11:05:58.055 (5) [P1T1]: loaded column: sources.landingURL->http://www.cleanitoffice.com.au/sem-recyclingserviceshobsonsbay.html?refcd=go4738_630s&tsacr=go{creative} 2012-11-28 11:05:58.055 (5) [P1T1]: loaded column: sources.passParams-> 2012-11-28 11:05:58.055 (5) [P1T1]: loaded column: sources.trackPerformance->true 2012-11-28 11:05:58.055 (5) [P1T1]: loaded column: sources.searchEngineStatus->ok 2012-11-28 11:05:58.055 (5) [P1T1]: loaded column: sources.searchEngineStatusText->ACTIVE 2012-11-28 11:05:58.056 (5) [P1T1]: loaded column: sources.lastChecked->null 2012-11-28 11:05:58.056 (5) [P1T1]: yesterday: month=11, day=27, year=2012 2012-11-28 11:05:58.056 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.056 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.056 (4) [P1T1]: spike: SQL->[select `tsacommon`.`searchEngineAccounts`.`searchEngineStatus`,`searchEngineListings`.`id`,`searchEngineListings`.`searchEngineIdentifier`,`altKey`,`searchEngineListings`.`searchEngineStatus` from `searchEngineListings` left join `tsacommon`.`searchEngineAccounts` on ((`tsacommon`.`searchEngineAccounts`.`id`=`searchEngineListings`.`searchEngineAccountID`)) where ((`tsacommon`.`searchEngineAccounts`.`accountID`=694) and (`searchEngineListings`.`searchEngineIdentifier`="22866589633") and (`tsacommon`.`searchEngineAccounts`.`distributionID`="3"))] 2012-11-28 11:05:58.057 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.058 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.058 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.058 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.058 (5) [P1T1]: parseInteger->[4227] 2012-11-28 11:05:58.058 (5) [P1T1]: parseInteger<-[4227] 2012-11-28 11:05:58.058 (5) [P1T1]: parseInteger->[3] 2012-11-28 11:05:58.058 (5) [P1T1]: parseInteger<-[3] 2012-11-28 11:05:58.058 (5) [P1T1]: parseInteger->[694] 2012-11-28 11:05:58.058 (5) [P1T1]: parseInteger<-[694] 2012-11-28 11:05:58.058 (5) [P1T1]: parseInteger->[4224] 2012-11-28 11:05:58.058 (5) [P1T1]: parseInteger<-[4224] 2012-11-28 11:05:58.058 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.058 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:58.059 (5) [P1T1]: quoteValue(), nothing special about it=>[4227], type=class java.lang.Integer 2012-11-28 11:05:58.059 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.059 (5) [P1T1]: quoteValue(), nothing special about it=>[4224], type=class java.lang.Integer 2012-11-28 11:05:58.059 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.059 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.059 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineIdentifier`="11490821"))) and (((`sources`.`searchEngineMatchType`="broad"))) and (((`sources`.`searchEngineAccountID`=4227))) and (((`sources`.`searchEngineGroupID`=4224))))] 2012-11-28 11:05:58.061 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-11-28 11:05:58.061 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-11-28 11:05:58.061 (4) [P1T1]: time=0.0020 2012-11-28 11:05:58.061 (4) [P1T1]: Query executed in 0.002s 2012-11-28 11:05:58.061 (5) [P1T1]: loading 26 columns from result set: 2012-11-28 11:05:58.061 (5) [P1T1]: loaded column: sources.id->219973 2012-11-28 11:05:58.061 (5) [P1T1]: loaded column: sources.altKey->go4740_739s 2012-11-28 11:05:58.061 (5) [P1T1]: loaded column: sources.accountID->694 2012-11-28 11:05:58.061 (5) [P1T1]: loaded column: sources.siteID->0 2012-11-28 11:05:58.061 (5) [P1T1]: loaded column: sources.searchEngineAccountID->4227 2012-11-28 11:05:58.061 (5) [P1T1]: loaded column: sources.keywordID->0 2012-11-28 11:05:58.061 (5) [P1T1]: loaded column: sources.distributionID->3 2012-11-28 11:05:58.061 (5) [P1T1]: loaded column: sources.searchEngineIdentifier->11490821 2012-11-28 11:05:58.062 (5) [P1T1]: loaded column: sources.searchEngineGroupIdentifier->5354984353 2012-11-28 11:05:58.062 (5) [P1T1]: loaded column: sources.searchEngineMatchType->broad 2012-11-28 11:05:58.062 (5) [P1T1]: loaded column: sources.searchEngineGroupID->4224 2012-11-28 11:05:58.062 (5) [P1T1]: loaded column: sources.isBiddable->false 2012-11-28 11:05:58.062 (5) [P1T1]: loaded column: sources.campaignID->0 2012-11-28 11:05:58.062 (5) [P1T1]: loaded column: sources.description->BiddableAdGroupCriterion: [recycling] broad 2012-11-28 11:05:58.062 (5) [P1T1]: loaded column: sources.type->1 2012-11-28 11:05:58.062 (5) [P1T1]: loaded column: sources.keyword->recycling 2012-11-28 11:05:58.062 (5) [P1T1]: loaded column: sources.sourceURL-> 2012-11-28 11:05:58.062 (5) [P1T1]: loaded column: sources.cost->0.0 2012-11-28 11:05:58.062 (5) [P1T1]: loaded column: sources.maxCost->0.0 2012-11-28 11:05:58.063 (5) [P1T1]: loaded column: sources.waypointID->null 2012-11-28 11:05:58.063 (5) [P1T1]: loaded column: sources.landingURL->http://www.cleanitoffice.com.au/m/sem-recyclingserviceshobsonsbay.html?refcd=go4740_739s&tsacr=go{creative} 2012-11-28 11:05:58.063 (5) [P1T1]: loaded column: sources.passParams-> 2012-11-28 11:05:58.063 (5) [P1T1]: loaded column: sources.trackPerformance->true 2012-11-28 11:05:58.063 (5) [P1T1]: loaded column: sources.searchEngineStatus->ok 2012-11-28 11:05:58.063 (5) [P1T1]: loaded column: sources.searchEngineStatusText->ACTIVE 2012-11-28 11:05:58.063 (5) [P1T1]: loaded column: sources.lastChecked->null 2012-11-28 11:05:58.063 (5) [P1T1]: yesterday: month=11, day=27, year=2012 2012-11-28 11:05:58.063 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.064 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.064 (4) [P1T1]: spike: SQL->[select `tsacommon`.`searchEngineAccounts`.`searchEngineStatus`,`searchEngineListings`.`id`,`searchEngineListings`.`searchEngineIdentifier`,`altKey`,`searchEngineListings`.`searchEngineStatus` from `searchEngineListings` left join `tsacommon`.`searchEngineAccounts` on ((`tsacommon`.`searchEngineAccounts`.`id`=`searchEngineListings`.`searchEngineAccountID`)) where ((`tsacommon`.`searchEngineAccounts`.`accountID`=694) and (`searchEngineListings`.`searchEngineIdentifier`="22866589993") and (`tsacommon`.`searchEngineAccounts`.`distributionID`="3"))] 2012-11-28 11:05:58.065 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.065 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.065 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.065 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.065 (5) [P1T1]: parseInteger->[4227] 2012-11-28 11:05:58.065 (5) [P1T1]: parseInteger<-[4227] 2012-11-28 11:05:58.065 (5) [P1T1]: parseInteger->[3] 2012-11-28 11:05:58.065 (5) [P1T1]: parseInteger<-[3] 2012-11-28 11:05:58.066 (5) [P1T1]: parseInteger->[694] 2012-11-28 11:05:58.066 (5) [P1T1]: parseInteger<-[694] 2012-11-28 11:05:58.066 (5) [P1T1]: parseInteger->[4224] 2012-11-28 11:05:58.066 (5) [P1T1]: parseInteger<-[4224] 2012-11-28 11:05:58.066 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.066 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:58.066 (5) [P1T1]: quoteValue(), nothing special about it=>[4227], type=class java.lang.Integer 2012-11-28 11:05:58.066 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.066 (5) [P1T1]: quoteValue(), nothing special about it=>[4224], type=class java.lang.Integer 2012-11-28 11:05:58.066 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.066 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.066 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineIdentifier`="11490821"))) and (((`sources`.`searchEngineMatchType`="broad"))) and (((`sources`.`searchEngineAccountID`=4227))) and (((`sources`.`searchEngineGroupID`=4224))))] 2012-11-28 11:05:58.068 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-11-28 11:05:58.068 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-11-28 11:05:58.068 (4) [P1T1]: time=0.0020 2012-11-28 11:05:58.068 (4) [P1T1]: Query executed in 0.002s 2012-11-28 11:05:58.068 (5) [P1T1]: loading 26 columns from result set: 2012-11-28 11:05:58.068 (5) [P1T1]: loaded column: sources.id->219973 2012-11-28 11:05:58.068 (5) [P1T1]: loaded column: sources.altKey->go4740_739s 2012-11-28 11:05:58.068 (5) [P1T1]: loaded column: sources.accountID->694 2012-11-28 11:05:58.068 (5) [P1T1]: loaded column: sources.siteID->0 2012-11-28 11:05:58.069 (5) [P1T1]: loaded column: sources.searchEngineAccountID->4227 2012-11-28 11:05:58.069 (5) [P1T1]: loaded column: sources.keywordID->0 2012-11-28 11:05:58.069 (5) [P1T1]: loaded column: sources.distributionID->3 2012-11-28 11:05:58.069 (5) [P1T1]: loaded column: sources.searchEngineIdentifier->11490821 2012-11-28 11:05:58.069 (5) [P1T1]: loaded column: sources.searchEngineGroupIdentifier->5354984353 2012-11-28 11:05:58.069 (5) [P1T1]: loaded column: sources.searchEngineMatchType->broad 2012-11-28 11:05:58.069 (5) [P1T1]: loaded column: sources.searchEngineGroupID->4224 2012-11-28 11:05:58.069 (5) [P1T1]: loaded column: sources.isBiddable->false 2012-11-28 11:05:58.069 (5) [P1T1]: loaded column: sources.campaignID->0 2012-11-28 11:05:58.069 (5) [P1T1]: loaded column: sources.description->BiddableAdGroupCriterion: [recycling] broad 2012-11-28 11:05:58.069 (5) [P1T1]: loaded column: sources.type->1 2012-11-28 11:05:58.069 (5) [P1T1]: loaded column: sources.keyword->recycling 2012-11-28 11:05:58.070 (5) [P1T1]: loaded column: sources.sourceURL-> 2012-11-28 11:05:58.070 (5) [P1T1]: loaded column: sources.cost->0.0 2012-11-28 11:05:58.070 (5) [P1T1]: loaded column: sources.maxCost->0.0 2012-11-28 11:05:58.070 (5) [P1T1]: loaded column: sources.waypointID->null 2012-11-28 11:05:58.070 (5) [P1T1]: loaded column: sources.landingURL->http://www.cleanitoffice.com.au/m/sem-recyclingserviceshobsonsbay.html?refcd=go4740_739s&tsacr=go{creative} 2012-11-28 11:05:58.070 (5) [P1T1]: loaded column: sources.passParams-> 2012-11-28 11:05:58.070 (5) [P1T1]: loaded column: sources.trackPerformance->true 2012-11-28 11:05:58.070 (5) [P1T1]: loaded column: sources.searchEngineStatus->ok 2012-11-28 11:05:58.070 (5) [P1T1]: loaded column: sources.searchEngineStatusText->ACTIVE 2012-11-28 11:05:58.070 (5) [P1T1]: loaded column: sources.lastChecked->null 2012-11-28 11:05:58.070 (5) [P1T1]: yesterday: month=11, day=27, year=2012 2012-11-28 11:05:58.071 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.071 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.071 (4) [P1T1]: spike: SQL->[select `tsacommon`.`searchEngineAccounts`.`searchEngineStatus`,`searchEngineListings`.`id`,`searchEngineListings`.`searchEngineIdentifier`,`altKey`,`searchEngineListings`.`searchEngineStatus` from `searchEngineListings` left join `tsacommon`.`searchEngineAccounts` on ((`tsacommon`.`searchEngineAccounts`.`id`=`searchEngineListings`.`searchEngineAccountID`)) where ((`tsacommon`.`searchEngineAccounts`.`accountID`=694) and (`searchEngineListings`.`searchEngineIdentifier`="22866590113") and (`tsacommon`.`searchEngineAccounts`.`distributionID`="3"))] 2012-11-28 11:05:58.072 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.072 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.072 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.072 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.073 (5) [P1T1]: parseInteger->[4231] 2012-11-28 11:05:58.073 (5) [P1T1]: parseInteger<-[4231] 2012-11-28 11:05:58.073 (5) [P1T1]: parseInteger->[3] 2012-11-28 11:05:58.073 (5) [P1T1]: parseInteger<-[3] 2012-11-28 11:05:58.073 (5) [P1T1]: parseInteger->[694] 2012-11-28 11:05:58.073 (5) [P1T1]: parseInteger<-[694] 2012-11-28 11:05:58.073 (5) [P1T1]: parseInteger->[4220] 2012-11-28 11:05:58.073 (5) [P1T1]: parseInteger<-[4220] 2012-11-28 11:05:58.073 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.073 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:58.073 (5) [P1T1]: quoteValue(), nothing special about it=>[4231], type=class java.lang.Integer 2012-11-28 11:05:58.073 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.074 (5) [P1T1]: quoteValue(), nothing special about it=>[4220], type=class java.lang.Integer 2012-11-28 11:05:58.074 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.074 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.074 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineIdentifier`="13201760"))) and (((`sources`.`searchEngineMatchType`="broad"))) and (((`sources`.`searchEngineAccountID`=4231))) and (((`sources`.`searchEngineGroupID`=4220))))] 2012-11-28 11:05:58.075 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.075 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.075 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.075 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.075 (5) [P1T1]: loading 26 columns from result set: 2012-11-28 11:05:58.076 (5) [P1T1]: loaded column: sources.id->219455 2012-11-28 11:05:58.076 (5) [P1T1]: loaded column: sources.altKey->go4744_964s 2012-11-28 11:05:58.076 (5) [P1T1]: loaded column: sources.accountID->694 2012-11-28 11:05:58.076 (5) [P1T1]: loaded column: sources.siteID->0 2012-11-28 11:05:58.076 (5) [P1T1]: loaded column: sources.searchEngineAccountID->4231 2012-11-28 11:05:58.076 (5) [P1T1]: loaded column: sources.keywordID->0 2012-11-28 11:05:58.076 (5) [P1T1]: loaded column: sources.distributionID->3 2012-11-28 11:05:58.076 (5) [P1T1]: loaded column: sources.searchEngineIdentifier->13201760 2012-11-28 11:05:58.076 (5) [P1T1]: loaded column: sources.searchEngineGroupIdentifier->5354984833 2012-11-28 11:05:58.076 (5) [P1T1]: loaded column: sources.searchEngineMatchType->broad 2012-11-28 11:05:58.076 (5) [P1T1]: loaded column: sources.searchEngineGroupID->4220 2012-11-28 11:05:58.076 (5) [P1T1]: loaded column: sources.isBiddable->false 2012-11-28 11:05:58.076 (5) [P1T1]: loaded column: sources.campaignID->0 2012-11-28 11:05:58.077 (5) [P1T1]: loaded column: sources.description->BiddableAdGroupCriterion: [office cleaner] broad 2012-11-28 11:05:58.077 (5) [P1T1]: loaded column: sources.type->1 2012-11-28 11:05:58.077 (5) [P1T1]: loaded column: sources.keyword->office cleaner 2012-11-28 11:05:58.077 (5) [P1T1]: loaded column: sources.sourceURL-> 2012-11-28 11:05:58.077 (5) [P1T1]: loaded column: sources.cost->0.0 2012-11-28 11:05:58.077 (5) [P1T1]: loaded column: sources.maxCost->0.0 2012-11-28 11:05:58.077 (5) [P1T1]: loaded column: sources.waypointID->null 2012-11-28 11:05:58.077 (5) [P1T1]: loaded column: sources.landingURL->http://www.cleanitoffice.com.au/sem-officecleaningcompanieskeilor.html?refcd=go4744_964s&tsacr=go{creative} 2012-11-28 11:05:58.077 (5) [P1T1]: loaded column: sources.passParams-> 2012-11-28 11:05:58.077 (5) [P1T1]: loaded column: sources.trackPerformance->true 2012-11-28 11:05:58.077 (5) [P1T1]: loaded column: sources.searchEngineStatus->ok 2012-11-28 11:05:58.077 (5) [P1T1]: loaded column: sources.searchEngineStatusText->ACTIVE 2012-11-28 11:05:58.078 (5) [P1T1]: loaded column: sources.lastChecked->null 2012-11-28 11:05:58.078 (5) [P1T1]: yesterday: month=11, day=27, year=2012 2012-11-28 11:05:58.078 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.078 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.078 (4) [P1T1]: spike: SQL->[select `tsacommon`.`searchEngineAccounts`.`searchEngineStatus`,`searchEngineListings`.`id`,`searchEngineListings`.`searchEngineIdentifier`,`altKey`,`searchEngineListings`.`searchEngineStatus` from `searchEngineListings` left join `tsacommon`.`searchEngineAccounts` on ((`tsacommon`.`searchEngineAccounts`.`id`=`searchEngineListings`.`searchEngineAccountID`)) where ((`tsacommon`.`searchEngineAccounts`.`accountID`=694) and (`searchEngineListings`.`searchEngineIdentifier`="22866592273") and (`tsacommon`.`searchEngineAccounts`.`distributionID`="3"))] 2012-11-28 11:05:58.079 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.079 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.079 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.080 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.080 (5) [P1T1]: parseInteger->[4236] 2012-11-28 11:05:58.080 (5) [P1T1]: parseInteger<-[4236] 2012-11-28 11:05:58.080 (5) [P1T1]: parseInteger->[3] 2012-11-28 11:05:58.080 (5) [P1T1]: parseInteger<-[3] 2012-11-28 11:05:58.080 (5) [P1T1]: parseInteger->[694] 2012-11-28 11:05:58.080 (5) [P1T1]: parseInteger<-[694] 2012-11-28 11:05:58.080 (5) [P1T1]: parseInteger->[4217] 2012-11-28 11:05:58.080 (5) [P1T1]: parseInteger<-[4217] 2012-11-28 11:05:58.080 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.081 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:58.081 (5) [P1T1]: quoteValue(), nothing special about it=>[4236], type=class java.lang.Integer 2012-11-28 11:05:58.081 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.081 (5) [P1T1]: quoteValue(), nothing special about it=>[4217], type=class java.lang.Integer 2012-11-28 11:05:58.081 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.081 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.081 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineIdentifier`="11490821"))) and (((`sources`.`searchEngineMatchType`="broad"))) and (((`sources`.`searchEngineAccountID`=4236))) and (((`sources`.`searchEngineGroupID`=4217))))] 2012-11-28 11:05:58.083 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-11-28 11:05:58.083 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-11-28 11:05:58.083 (4) [P1T1]: time=0.0020 2012-11-28 11:05:58.083 (4) [P1T1]: Query executed in 0.002s 2012-11-28 11:05:58.083 (5) [P1T1]: loading 26 columns from result set: 2012-11-28 11:05:58.083 (5) [P1T1]: loaded column: sources.id->219697 2012-11-28 11:05:58.083 (5) [P1T1]: loaded column: sources.altKey->go4749_1207s 2012-11-28 11:05:58.083 (5) [P1T1]: loaded column: sources.accountID->694 2012-11-28 11:05:58.083 (5) [P1T1]: loaded column: sources.siteID->0 2012-11-28 11:05:58.083 (5) [P1T1]: loaded column: sources.searchEngineAccountID->4236 2012-11-28 11:05:58.083 (5) [P1T1]: loaded column: sources.keywordID->0 2012-11-28 11:05:58.083 (5) [P1T1]: loaded column: sources.distributionID->3 2012-11-28 11:05:58.084 (5) [P1T1]: loaded column: sources.searchEngineIdentifier->11490821 2012-11-28 11:05:58.084 (5) [P1T1]: loaded column: sources.searchEngineGroupIdentifier->5354985433 2012-11-28 11:05:58.084 (5) [P1T1]: loaded column: sources.searchEngineMatchType->broad 2012-11-28 11:05:58.084 (5) [P1T1]: loaded column: sources.searchEngineGroupID->4217 2012-11-28 11:05:58.084 (5) [P1T1]: loaded column: sources.isBiddable->false 2012-11-28 11:05:58.084 (5) [P1T1]: loaded column: sources.campaignID->0 2012-11-28 11:05:58.084 (5) [P1T1]: loaded column: sources.description->BiddableAdGroupCriterion: [recycling] broad 2012-11-28 11:05:58.084 (5) [P1T1]: loaded column: sources.type->1 2012-11-28 11:05:58.084 (5) [P1T1]: loaded column: sources.keyword->recycling 2012-11-28 11:05:58.084 (5) [P1T1]: loaded column: sources.sourceURL-> 2012-11-28 11:05:58.085 (5) [P1T1]: loaded column: sources.cost->0.0 2012-11-28 11:05:58.085 (5) [P1T1]: loaded column: sources.maxCost->0.0 2012-11-28 11:05:58.085 (5) [P1T1]: loaded column: sources.waypointID->null 2012-11-28 11:05:58.085 (5) [P1T1]: loaded column: sources.landingURL->http://www.cleanitoffice.com.au/m/sem-recyclingserviceskeilor.html?refcd=go4749_1207s&tsacr=go{creative} 2012-11-28 11:05:58.085 (5) [P1T1]: loaded column: sources.passParams-> 2012-11-28 11:05:58.085 (5) [P1T1]: loaded column: sources.trackPerformance->true 2012-11-28 11:05:58.085 (5) [P1T1]: loaded column: sources.searchEngineStatus->ok 2012-11-28 11:05:58.085 (5) [P1T1]: loaded column: sources.searchEngineStatusText->ACTIVE 2012-11-28 11:05:58.085 (5) [P1T1]: loaded column: sources.lastChecked->null 2012-11-28 11:05:58.085 (5) [P1T1]: yesterday: month=11, day=27, year=2012 2012-11-28 11:05:58.086 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.086 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.086 (4) [P1T1]: spike: SQL->[select `tsacommon`.`searchEngineAccounts`.`searchEngineStatus`,`searchEngineListings`.`id`,`searchEngineListings`.`searchEngineIdentifier`,`altKey`,`searchEngineListings`.`searchEngineStatus` from `searchEngineListings` left join `tsacommon`.`searchEngineAccounts` on ((`tsacommon`.`searchEngineAccounts`.`id`=`searchEngineListings`.`searchEngineAccountID`)) where ((`tsacommon`.`searchEngineAccounts`.`accountID`=694) and (`searchEngineListings`.`searchEngineIdentifier`="22866594553") and (`tsacommon`.`searchEngineAccounts`.`distributionID`="3"))] 2012-11-28 11:05:58.087 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.087 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.087 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.087 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.088 (5) [P1T1]: quoteValue(), nothing special about it=>[94794313], type=class java.lang.Long 2012-11-28 11:05:58.088 (5) [P1T1]: quoteValue(), nothing special about it=>[94794073], type=class java.lang.Long 2012-11-28 11:05:58.088 (5) [P1T1]: quoteValue(), nothing special about it=>[94794193], type=class java.lang.Long 2012-11-28 11:05:58.088 (5) [P1T1]: quoteValue(), nothing special about it=>[94793353], type=class java.lang.Long 2012-11-28 11:05:58.088 (5) [P1T1]: quoteValue(), nothing special about it=>[94793473], type=class java.lang.Long 2012-11-28 11:05:58.088 (5) [P1T1]: quoteValue(), nothing special about it=>[94793113], type=class java.lang.Long 2012-11-28 11:05:58.088 (5) [P1T1]: quoteValue(), nothing special about it=>[94793233], type=class java.lang.Long 2012-11-28 11:05:58.088 (5) [P1T1]: quoteValue(), nothing special about it=>[94881793], type=class java.lang.Long 2012-11-28 11:05:58.088 (5) [P1T1]: quoteValue(), nothing special about it=>[94793833], type=class java.lang.Long 2012-11-28 11:05:58.088 (5) [P1T1]: quoteValue(), nothing special about it=>[94793953], type=class java.lang.Long 2012-11-28 11:05:58.088 (5) [P1T1]: quoteValue(), nothing special about it=>[94793593], type=class java.lang.Long 2012-11-28 11:05:58.088 (5) [P1T1]: quoteValue(), nothing special about it=>[94793713], type=class java.lang.Long 2012-11-28 11:05:58.088 (5) [P1T1]: quoteValue(), nothing special about it=>[94790233], type=class java.lang.Long 2012-11-28 11:05:58.088 (5) [P1T1]: quoteValue(), nothing special about it=>[94790353], type=class java.lang.Long 2012-11-28 11:05:58.088 (5) [P1T1]: quoteValue(), nothing special about it=>[94790473], type=class java.lang.Long 2012-11-28 11:05:58.088 (5) [P1T1]: quoteValue(), nothing special about it=>[94790593], type=class java.lang.Long 2012-11-28 11:05:58.089 (5) [P1T1]: quoteValue(), nothing special about it=>[94790713], type=class java.lang.Long 2012-11-28 11:05:58.089 (5) [P1T1]: quoteValue(), nothing special about it=>[94790833], type=class java.lang.Long 2012-11-28 11:05:58.089 (5) [P1T1]: quoteValue(), nothing special about it=>[94790953], type=class java.lang.Long 2012-11-28 11:05:58.089 (5) [P1T1]: quoteValue(), nothing special about it=>[94791073], type=class java.lang.Long 2012-11-28 11:05:58.089 (5) [P1T1]: quoteValue(), nothing special about it=>[94789273], type=class java.lang.Long 2012-11-28 11:05:58.089 (5) [P1T1]: quoteValue(), nothing special about it=>[94789393], type=class java.lang.Long 2012-11-28 11:05:58.089 (5) [P1T1]: quoteValue(), nothing special about it=>[94789513], type=class java.lang.Long 2012-11-28 11:05:58.089 (5) [P1T1]: quoteValue(), nothing special about it=>[94789633], type=class java.lang.Long 2012-11-28 11:05:58.089 (5) [P1T1]: quoteValue(), nothing special about it=>[94789753], type=class java.lang.Long 2012-11-28 11:05:58.089 (5) [P1T1]: quoteValue(), nothing special about it=>[94789873], type=class java.lang.Long 2012-11-28 11:05:58.089 (5) [P1T1]: quoteValue(), nothing special about it=>[94789993], type=class java.lang.Long 2012-11-28 11:05:58.089 (5) [P1T1]: quoteValue(), nothing special about it=>[94790113], type=class java.lang.Long 2012-11-28 11:05:58.089 (5) [P1T1]: quoteValue(), nothing special about it=>[94792273], type=class java.lang.Long 2012-11-28 11:05:58.089 (5) [P1T1]: quoteValue(), nothing special about it=>[94792153], type=class java.lang.Long 2012-11-28 11:05:58.089 (5) [P1T1]: quoteValue(), nothing special about it=>[94792513], type=class java.lang.Long 2012-11-28 11:05:58.089 (5) [P1T1]: quoteValue(), nothing special about it=>[94792393], type=class java.lang.Long 2012-11-28 11:05:58.089 (5) [P1T1]: quoteValue(), nothing special about it=>[94792753], type=class java.lang.Long 2012-11-28 11:05:58.089 (5) [P1T1]: quoteValue(), nothing special about it=>[94792633], type=class java.lang.Long 2012-11-28 11:05:58.089 (5) [P1T1]: quoteValue(), nothing special about it=>[94792993], type=class java.lang.Long 2012-11-28 11:05:58.090 (5) [P1T1]: quoteValue(), nothing special about it=>[94792873], type=class java.lang.Long 2012-11-28 11:05:58.090 (5) [P1T1]: quoteValue(), nothing special about it=>[94791313], type=class java.lang.Long 2012-11-28 11:05:58.090 (5) [P1T1]: quoteValue(), nothing special about it=>[94791193], type=class java.lang.Long 2012-11-28 11:05:58.090 (5) [P1T1]: quoteValue(), nothing special about it=>[94791553], type=class java.lang.Long 2012-11-28 11:05:58.090 (5) [P1T1]: quoteValue(), nothing special about it=>[94791433], type=class java.lang.Long 2012-11-28 11:05:58.090 (5) [P1T1]: quoteValue(), nothing special about it=>[94791793], type=class java.lang.Long 2012-11-28 11:05:58.090 (5) [P1T1]: quoteValue(), nothing special about it=>[94791673], type=class java.lang.Long 2012-11-28 11:05:58.090 (5) [P1T1]: quoteValue(), nothing special about it=>[94792033], type=class java.lang.Long 2012-11-28 11:05:58.090 (5) [P1T1]: quoteValue(), nothing special about it=>[94791913], type=class java.lang.Long 2012-11-28 11:05:58.090 (5) [P1T1]: quoteValue(), nothing special about it=>[94788073], type=class java.lang.Long 2012-11-28 11:05:58.090 (5) [P1T1]: quoteValue(), nothing special about it=>[94788193], type=class java.lang.Long 2012-11-28 11:05:58.090 (5) [P1T1]: quoteValue(), nothing special about it=>[94787953], type=class java.lang.Long 2012-11-28 11:05:58.090 (5) [P1T1]: quoteValue(), nothing special about it=>[94789033], type=class java.lang.Long 2012-11-28 11:05:58.090 (5) [P1T1]: quoteValue(), nothing special about it=>[94789153], type=class java.lang.Long 2012-11-28 11:05:58.090 (5) [P1T1]: quoteValue(), nothing special about it=>[94788793], type=class java.lang.Long 2012-11-28 11:05:58.090 (5) [P1T1]: quoteValue(), nothing special about it=>[94788913], type=class java.lang.Long 2012-11-28 11:05:58.090 (5) [P1T1]: quoteValue(), nothing special about it=>[94788553], type=class java.lang.Long 2012-11-28 11:05:58.090 (5) [P1T1]: quoteValue(), nothing special about it=>[94788673], type=class java.lang.Long 2012-11-28 11:05:58.090 (5) [P1T1]: quoteValue(), nothing special about it=>[94788313], type=class java.lang.Long 2012-11-28 11:05:58.091 (5) [P1T1]: quoteValue(), nothing special about it=>[94788433], type=class java.lang.Long 2012-11-28 11:05:58.091 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.091 (4) [P1T1]: spike: SQL->[select * from `staging`.`googleMcc` where ((`staging`.`googleMcc`.`campaignid` in (94794313,94794073,94794193,94793353,94793473,94793113,94793233,94881793,94793833,94793953,94793593,94793713,94790233,94790353,94790473,94790593,94790713,94790833,94790953,94791073,94789273,94789393,94789513,94789633,94789753,94789873,94789993,94790113,94792273,94792153,94792513,94792393,94792753,94792633,94792993,94792873,94791313,94791193,94791553,94791433,94791793,94791673,94792033,94791913,94788073,94788193,94787953,94789033,94789153,94788793,94788913,94788553,94788673,94788313,94788433)) and (`staging`.`googleMcc`.`startTime`="2012-11-17 00:00:00") and (`staging`.`googleMcc`.`adwordsType`="Content Only") and (`staging`.`googleMcc`.`kwType`="Content"))] 2012-11-28 11:05:58.092 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.092 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.092 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.092 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.093 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.093 (4) [P1T1]: spike: SQL->[delete from `st-tracker`.`tmp1`], genflags=no 2012-11-28 11:05:58.093 (5) [P1T1]: recordAsSubs("db", 0, "P1T1") 2012-11-28 11:05:58.093 (5) [P1T1]: ProfilerRec.end("db", true): ret=0 2012-11-28 11:05:58.094 (4) [P1T1]: time=0.0 2012-11-28 11:05:58.094 (4) [P1T1]: Query executed in 0.000s, 13 row(s) affected 2012-11-28 11:05:58.094 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.`tmp1` (`startTime`, `campaignid`, `adgroupid`, `keywordid`, `keyword`, `kwType`, `creativeid`, `creativeDestUrl`, `kwDestUrl`, `adwordsType`, `maxCpc`, `imps`, `clicks`, `cost`, `pos`, `conv`, `transactions`, `purchases`, `purchaseValue`, `leads`, `leadValue`, `signups`, `signupValue`, `pageviews`, `pageviewValue`, `defaultConv`, `defaultConvValue`, `qualityScore`, `firstPageCPC`) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)] 2012-11-28 11:05:58.105 (4) [P1T1]: replicated 10 rows to `st-tracker`.`tmp1` 2012-11-28 11:05:58.105 (5) [P1T1]: quoteValue(), nothing special about it=>[4266], type=class java.lang.Integer 2012-11-28 11:05:58.105 (5) [P1T1]: quoteValue(), nothing special about it=>[4264], type=class java.lang.Integer 2012-11-28 11:05:58.105 (5) [P1T1]: quoteValue(), nothing special about it=>[4265], type=class java.lang.Integer 2012-11-28 11:05:58.105 (5) [P1T1]: quoteValue(), nothing special about it=>[4258], type=class java.lang.Integer 2012-11-28 11:05:58.105 (5) [P1T1]: quoteValue(), nothing special about it=>[4259], type=class java.lang.Integer 2012-11-28 11:05:58.105 (5) [P1T1]: quoteValue(), nothing special about it=>[4256], type=class java.lang.Integer 2012-11-28 11:05:58.106 (5) [P1T1]: quoteValue(), nothing special about it=>[4257], type=class java.lang.Integer 2012-11-28 11:05:58.106 (5) [P1T1]: quoteValue(), nothing special about it=>[4736], type=class java.lang.Integer 2012-11-28 11:05:58.106 (5) [P1T1]: quoteValue(), nothing special about it=>[4262], type=class java.lang.Integer 2012-11-28 11:05:58.106 (5) [P1T1]: quoteValue(), nothing special about it=>[4263], type=class java.lang.Integer 2012-11-28 11:05:58.106 (5) [P1T1]: quoteValue(), nothing special about it=>[4260], type=class java.lang.Integer 2012-11-28 11:05:58.106 (5) [P1T1]: quoteValue(), nothing special about it=>[4261], type=class java.lang.Integer 2012-11-28 11:05:58.106 (5) [P1T1]: quoteValue(), nothing special about it=>[4232], type=class java.lang.Integer 2012-11-28 11:05:58.106 (5) [P1T1]: quoteValue(), nothing special about it=>[4233], type=class java.lang.Integer 2012-11-28 11:05:58.106 (5) [P1T1]: quoteValue(), nothing special about it=>[4234], type=class java.lang.Integer 2012-11-28 11:05:58.106 (5) [P1T1]: quoteValue(), nothing special about it=>[4235], type=class java.lang.Integer 2012-11-28 11:05:58.106 (5) [P1T1]: quoteValue(), nothing special about it=>[4236], type=class java.lang.Integer 2012-11-28 11:05:58.106 (5) [P1T1]: quoteValue(), nothing special about it=>[4237], type=class java.lang.Integer 2012-11-28 11:05:58.106 (5) [P1T1]: quoteValue(), nothing special about it=>[4238], type=class java.lang.Integer 2012-11-28 11:05:58.106 (5) [P1T1]: quoteValue(), nothing special about it=>[4239], type=class java.lang.Integer 2012-11-28 11:05:58.106 (5) [P1T1]: quoteValue(), nothing special about it=>[4224], type=class java.lang.Integer 2012-11-28 11:05:58.106 (5) [P1T1]: quoteValue(), nothing special about it=>[4225], type=class java.lang.Integer 2012-11-28 11:05:58.106 (5) [P1T1]: quoteValue(), nothing special about it=>[4226], type=class java.lang.Integer 2012-11-28 11:05:58.106 (5) [P1T1]: quoteValue(), nothing special about it=>[4227], type=class java.lang.Integer 2012-11-28 11:05:58.106 (5) [P1T1]: quoteValue(), nothing special about it=>[4228], type=class java.lang.Integer 2012-11-28 11:05:58.107 (5) [P1T1]: quoteValue(), nothing special about it=>[4229], type=class java.lang.Integer 2012-11-28 11:05:58.107 (5) [P1T1]: quoteValue(), nothing special about it=>[4230], type=class java.lang.Integer 2012-11-28 11:05:58.107 (5) [P1T1]: quoteValue(), nothing special about it=>[4231], type=class java.lang.Integer 2012-11-28 11:05:58.107 (5) [P1T1]: quoteValue(), nothing special about it=>[4249], type=class java.lang.Integer 2012-11-28 11:05:58.107 (5) [P1T1]: quoteValue(), nothing special about it=>[4248], type=class java.lang.Integer 2012-11-28 11:05:58.107 (5) [P1T1]: quoteValue(), nothing special about it=>[4251], type=class java.lang.Integer 2012-11-28 11:05:58.107 (5) [P1T1]: quoteValue(), nothing special about it=>[4250], type=class java.lang.Integer 2012-11-28 11:05:58.107 (5) [P1T1]: quoteValue(), nothing special about it=>[4253], type=class java.lang.Integer 2012-11-28 11:05:58.107 (5) [P1T1]: quoteValue(), nothing special about it=>[4252], type=class java.lang.Integer 2012-11-28 11:05:58.107 (5) [P1T1]: quoteValue(), nothing special about it=>[4255], type=class java.lang.Integer 2012-11-28 11:05:58.107 (5) [P1T1]: quoteValue(), nothing special about it=>[4254], type=class java.lang.Integer 2012-11-28 11:05:58.107 (5) [P1T1]: quoteValue(), nothing special about it=>[4241], type=class java.lang.Integer 2012-11-28 11:05:58.107 (5) [P1T1]: quoteValue(), nothing special about it=>[4240], type=class java.lang.Integer 2012-11-28 11:05:58.107 (5) [P1T1]: quoteValue(), nothing special about it=>[4243], type=class java.lang.Integer 2012-11-28 11:05:58.107 (5) [P1T1]: quoteValue(), nothing special about it=>[4242], type=class java.lang.Integer 2012-11-28 11:05:58.107 (5) [P1T1]: quoteValue(), nothing special about it=>[4245], type=class java.lang.Integer 2012-11-28 11:05:58.107 (5) [P1T1]: quoteValue(), nothing special about it=>[4244], type=class java.lang.Integer 2012-11-28 11:05:58.107 (5) [P1T1]: quoteValue(), nothing special about it=>[4247], type=class java.lang.Integer 2012-11-28 11:05:58.107 (5) [P1T1]: quoteValue(), nothing special about it=>[4246], type=class java.lang.Integer 2012-11-28 11:05:58.107 (5) [P1T1]: quoteValue(), nothing special about it=>[4214], type=class java.lang.Integer 2012-11-28 11:05:58.108 (5) [P1T1]: quoteValue(), nothing special about it=>[4215], type=class java.lang.Integer 2012-11-28 11:05:58.108 (5) [P1T1]: quoteValue(), nothing special about it=>[4213], type=class java.lang.Integer 2012-11-28 11:05:58.108 (5) [P1T1]: quoteValue(), nothing special about it=>[4222], type=class java.lang.Integer 2012-11-28 11:05:58.108 (5) [P1T1]: quoteValue(), nothing special about it=>[4223], type=class java.lang.Integer 2012-11-28 11:05:58.108 (5) [P1T1]: quoteValue(), nothing special about it=>[4220], type=class java.lang.Integer 2012-11-28 11:05:58.108 (5) [P1T1]: quoteValue(), nothing special about it=>[4221], type=class java.lang.Integer 2012-11-28 11:05:58.108 (5) [P1T1]: quoteValue(), nothing special about it=>[4218], type=class java.lang.Integer 2012-11-28 11:05:58.108 (5) [P1T1]: quoteValue(), nothing special about it=>[4219], type=class java.lang.Integer 2012-11-28 11:05:58.108 (5) [P1T1]: quoteValue(), nothing special about it=>[4216], type=class java.lang.Integer 2012-11-28 11:05:58.108 (5) [P1T1]: quoteValue(), nothing special about it=>[4217], type=class java.lang.Integer 2012-11-28 11:05:58.108 (5) [P1T1]: quoteValue(), nothing special about it=>[94794313], type=class java.lang.Long 2012-11-28 11:05:58.108 (5) [P1T1]: quoteValue(), nothing special about it=>[94794073], type=class java.lang.Long 2012-11-28 11:05:58.108 (5) [P1T1]: quoteValue(), nothing special about it=>[94794193], type=class java.lang.Long 2012-11-28 11:05:58.108 (5) [P1T1]: quoteValue(), nothing special about it=>[94793353], type=class java.lang.Long 2012-11-28 11:05:58.108 (5) [P1T1]: quoteValue(), nothing special about it=>[94793473], type=class java.lang.Long 2012-11-28 11:05:58.108 (5) [P1T1]: quoteValue(), nothing special about it=>[94793113], type=class java.lang.Long 2012-11-28 11:05:58.108 (5) [P1T1]: quoteValue(), nothing special about it=>[94793233], type=class java.lang.Long 2012-11-28 11:05:58.108 (5) [P1T1]: quoteValue(), nothing special about it=>[94881793], type=class java.lang.Long 2012-11-28 11:05:58.108 (5) [P1T1]: quoteValue(), nothing special about it=>[94793833], type=class java.lang.Long 2012-11-28 11:05:58.109 (5) [P1T1]: quoteValue(), nothing special about it=>[94793953], type=class java.lang.Long 2012-11-28 11:05:58.109 (5) [P1T1]: quoteValue(), nothing special about it=>[94793593], type=class java.lang.Long 2012-11-28 11:05:58.109 (5) [P1T1]: quoteValue(), nothing special about it=>[94793713], type=class java.lang.Long 2012-11-28 11:05:58.109 (5) [P1T1]: quoteValue(), nothing special about it=>[94790233], type=class java.lang.Long 2012-11-28 11:05:58.109 (5) [P1T1]: quoteValue(), nothing special about it=>[94790353], type=class java.lang.Long 2012-11-28 11:05:58.109 (5) [P1T1]: quoteValue(), nothing special about it=>[94790473], type=class java.lang.Long 2012-11-28 11:05:58.109 (5) [P1T1]: quoteValue(), nothing special about it=>[94790593], type=class java.lang.Long 2012-11-28 11:05:58.109 (5) [P1T1]: quoteValue(), nothing special about it=>[94790713], type=class java.lang.Long 2012-11-28 11:05:58.109 (5) [P1T1]: quoteValue(), nothing special about it=>[94790833], type=class java.lang.Long 2012-11-28 11:05:58.109 (5) [P1T1]: quoteValue(), nothing special about it=>[94790953], type=class java.lang.Long 2012-11-28 11:05:58.109 (5) [P1T1]: quoteValue(), nothing special about it=>[94791073], type=class java.lang.Long 2012-11-28 11:05:58.109 (5) [P1T1]: quoteValue(), nothing special about it=>[94789273], type=class java.lang.Long 2012-11-28 11:05:58.109 (5) [P1T1]: quoteValue(), nothing special about it=>[94789393], type=class java.lang.Long 2012-11-28 11:05:58.109 (5) [P1T1]: quoteValue(), nothing special about it=>[94789513], type=class java.lang.Long 2012-11-28 11:05:58.109 (5) [P1T1]: quoteValue(), nothing special about it=>[94789633], type=class java.lang.Long 2012-11-28 11:05:58.109 (5) [P1T1]: quoteValue(), nothing special about it=>[94789753], type=class java.lang.Long 2012-11-28 11:05:58.109 (5) [P1T1]: quoteValue(), nothing special about it=>[94789873], type=class java.lang.Long 2012-11-28 11:05:58.109 (5) [P1T1]: quoteValue(), nothing special about it=>[94789993], type=class java.lang.Long 2012-11-28 11:05:58.109 (5) [P1T1]: quoteValue(), nothing special about it=>[94790113], type=class java.lang.Long 2012-11-28 11:05:58.109 (5) [P1T1]: quoteValue(), nothing special about it=>[94792273], type=class java.lang.Long 2012-11-28 11:05:58.110 (5) [P1T1]: quoteValue(), nothing special about it=>[94792153], type=class java.lang.Long 2012-11-28 11:05:58.110 (5) [P1T1]: quoteValue(), nothing special about it=>[94792513], type=class java.lang.Long 2012-11-28 11:05:58.110 (5) [P1T1]: quoteValue(), nothing special about it=>[94792393], type=class java.lang.Long 2012-11-28 11:05:58.110 (5) [P1T1]: quoteValue(), nothing special about it=>[94792753], type=class java.lang.Long 2012-11-28 11:05:58.110 (5) [P1T1]: quoteValue(), nothing special about it=>[94792633], type=class java.lang.Long 2012-11-28 11:05:58.110 (5) [P1T1]: quoteValue(), nothing special about it=>[94792993], type=class java.lang.Long 2012-11-28 11:05:58.110 (5) [P1T1]: quoteValue(), nothing special about it=>[94792873], type=class java.lang.Long 2012-11-28 11:05:58.110 (5) [P1T1]: quoteValue(), nothing special about it=>[94791313], type=class java.lang.Long 2012-11-28 11:05:58.110 (5) [P1T1]: quoteValue(), nothing special about it=>[94791193], type=class java.lang.Long 2012-11-28 11:05:58.110 (5) [P1T1]: quoteValue(), nothing special about it=>[94791553], type=class java.lang.Long 2012-11-28 11:05:58.110 (5) [P1T1]: quoteValue(), nothing special about it=>[94791433], type=class java.lang.Long 2012-11-28 11:05:58.110 (5) [P1T1]: quoteValue(), nothing special about it=>[94791793], type=class java.lang.Long 2012-11-28 11:05:58.110 (5) [P1T1]: quoteValue(), nothing special about it=>[94791673], type=class java.lang.Long 2012-11-28 11:05:58.110 (5) [P1T1]: quoteValue(), nothing special about it=>[94792033], type=class java.lang.Long 2012-11-28 11:05:58.110 (5) [P1T1]: quoteValue(), nothing special about it=>[94791913], type=class java.lang.Long 2012-11-28 11:05:58.110 (5) [P1T1]: quoteValue(), nothing special about it=>[94788073], type=class java.lang.Long 2012-11-28 11:05:58.110 (5) [P1T1]: quoteValue(), nothing special about it=>[94788193], type=class java.lang.Long 2012-11-28 11:05:58.110 (5) [P1T1]: quoteValue(), nothing special about it=>[94787953], type=class java.lang.Long 2012-11-28 11:05:58.110 (5) [P1T1]: quoteValue(), nothing special about it=>[94789033], type=class java.lang.Long 2012-11-28 11:05:58.111 (5) [P1T1]: quoteValue(), nothing special about it=>[94789153], type=class java.lang.Long 2012-11-28 11:05:58.111 (5) [P1T1]: quoteValue(), nothing special about it=>[94788793], type=class java.lang.Long 2012-11-28 11:05:58.111 (5) [P1T1]: quoteValue(), nothing special about it=>[94788913], type=class java.lang.Long 2012-11-28 11:05:58.111 (5) [P1T1]: quoteValue(), nothing special about it=>[94788553], type=class java.lang.Long 2012-11-28 11:05:58.111 (5) [P1T1]: quoteValue(), nothing special about it=>[94788673], type=class java.lang.Long 2012-11-28 11:05:58.111 (5) [P1T1]: quoteValue(), nothing special about it=>[94788313], type=class java.lang.Long 2012-11-28 11:05:58.111 (5) [P1T1]: quoteValue(), nothing special about it=>[94788433], type=class java.lang.Long 2012-11-28 11:05:58.112 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.112 (4) [P1T1]: spike: SQL->[select `st-tracker`.`searchEngineGroups`.`searchEngineAccountID`,`st-tracker`.`searchEngineGroups`.`id` AS `searchEngineGroupID`,`tmp1`.`creativeid`,SUM(`tmp1`.`imps`) AS `imps`,SUM(`tmp1`.`clicks`) AS `clicks`,SUM(`tmp1`.`cost`) AS `cost`,SUM(`tmp1`.`pos` * `tmp1`.`imps`)/SUM(`tmp1`.`imps`) AS `pos`,`tmp1`.`qualityScore` AS `qualityScore`,`tmp1`.`firstPageCPC` AS `firstPageCPC` from `st-tracker`.`tmp1` inner join `st-tracker`.`searchEngineGroups` on (((((`tmp1`.`adgroupid`=`st-tracker`.`searchEngineGroups`.`searchEngineIdentifier`)) and ((`st-tracker`.`searchEngineGroups`.`searchEngineAccountID` in (4266,4264,4265,4258,4259,4256,4257,4736,4262,4263,4260,4261,4232,4233,4234,4235,4236,4237,4238,4239,4224,4225,4226,4227,4228,4229,4230,4231,4249,4248,4251,4250,4253,4252,4255,4254,4241,4240,4243,4242,4245,4244,4247,4246,4214,4215,4213,4222,4223,4220,4221,4218,4219,4216,4217)))))) where ((`tmp1`.`campaignid` in (94794313,94794073,94794193,94793353,94793473,94793113,94793233,94881793,94793833,94793953,94793593,94793713,94790233,94790353,94790473,94790593,94790713,94790833,94790953,94791073,94789273,94789393,94789513,94789633,94789753,94789873,94789993,94790113,94792273,94792153,94792513,94792393,94792753,94792633,94792993,94792873,94791313,94791193,94791553,94791433,94791793,94791673,94792033,94791913,94788073,94788193,94787953,94789033,94789153,94788793,94788913,94788553,94788673,94788313,94788433)) and (`tmp1`.`startTime`="2012-11-17 00:00:00") and (`tmp1`.`adwordsType`="Content Only") and (`tmp1`.`kwType`="Content")) group by `tmp1`.`adgroupid`,`tmp1`.`creativeid`] 2012-11-28 11:05:58.114 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-11-28 11:05:58.114 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-11-28 11:05:58.114 (4) [P1T1]: time=0.0020 2012-11-28 11:05:58.114 (4) [P1T1]: Query executed in 0.002s 2012-11-28 11:05:58.115 (5) [P1T1]: parseInteger->[4213] 2012-11-28 11:05:58.115 (5) [P1T1]: parseInteger<-[4213] 2012-11-28 11:05:58.115 (5) [P1T1]: parseInteger->[3] 2012-11-28 11:05:58.116 (5) [P1T1]: parseInteger<-[3] 2012-11-28 11:05:58.116 (5) [P1T1]: parseInteger->[694] 2012-11-28 11:05:58.116 (5) [P1T1]: parseInteger<-[694] 2012-11-28 11:05:58.116 (5) [P1T1]: parseInteger->[7] 2012-11-28 11:05:58.116 (5) [P1T1]: parseInteger<-[7] 2012-11-28 11:05:58.116 (5) [P1T1]: parseInteger->[4238] 2012-11-28 11:05:58.116 (5) [P1T1]: parseInteger<-[4238] 2012-11-28 11:05:58.116 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.116 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:58.117 (5) [P1T1]: quoteValue(), nothing special about it=>[4213], type=class java.lang.Integer 2012-11-28 11:05:58.117 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.117 (5) [P1T1]: quoteValue(), nothing special about it=>[4238], type=class java.lang.Integer 2012-11-28 11:05:58.117 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.117 (5) [P1T1]: quoteValue(), nothing special about it=>[7], type=class java.lang.Integer 2012-11-28 11:05:58.117 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.117 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineMatchType`="content"))) and (((`sources`.`searchEngineAccountID`=4213))) and (((`sources`.`searchEngineGroupID`=4238))) and (((`sources`.`type`=7))) and (`sources`.`keyword`="content network"))] 2012-11-28 11:05:58.119 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-11-28 11:05:58.119 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-11-28 11:05:58.119 (4) [P1T1]: time=0.0020 2012-11-28 11:05:58.119 (4) [P1T1]: Query executed in 0.002s 2012-11-28 11:05:58.119 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.119 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineMatchType`="content") or (`sources`.`searchEngineMatchType`="unknown"))) and (((`sources`.`searchEngineAccountID`=4213) or (`sources`.`searchEngineAccountID`=0))) and (((`sources`.`searchEngineGroupID`=4238) or (`sources`.`searchEngineGroupID`=0))) and (((`sources`.`type`=7) or (`sources`.`type`="0"))) and (`sources`.`keyword`="content network")) order by `sources`.`id`] 2012-11-28 11:05:58.120 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.121 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.121 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.121 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.121 (4) [P1T1]: Unable to find source for keyword "content network", altkey "null", identifier "null" (match type: content) 2012-11-28 11:05:58.121 (5) [P1T1]: parseInteger->[4213] 2012-11-28 11:05:58.121 (5) [P1T1]: parseInteger<-[4213] 2012-11-28 11:05:58.121 (5) [P1T1]: parseInteger->[3] 2012-11-28 11:05:58.121 (5) [P1T1]: parseInteger<-[3] 2012-11-28 11:05:58.121 (5) [P1T1]: parseInteger->[694] 2012-11-28 11:05:58.121 (5) [P1T1]: parseInteger<-[694] 2012-11-28 11:05:58.121 (5) [P1T1]: parseInteger->[7] 2012-11-28 11:05:58.121 (5) [P1T1]: parseInteger<-[7] 2012-11-28 11:05:58.121 (5) [P1T1]: parseInteger->[4238] 2012-11-28 11:05:58.121 (5) [P1T1]: parseInteger<-[4238] 2012-11-28 11:05:58.121 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.121 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:58.122 (5) [P1T1]: quoteValue(), nothing special about it=>[4213], type=class java.lang.Integer 2012-11-28 11:05:58.122 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.122 (5) [P1T1]: quoteValue(), nothing special about it=>[4238], type=class java.lang.Integer 2012-11-28 11:05:58.122 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.122 (5) [P1T1]: quoteValue(), nothing special about it=>[7], type=class java.lang.Integer 2012-11-28 11:05:58.122 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.122 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineMatchType`="content"))) and (((`sources`.`searchEngineAccountID`=4213))) and (((`sources`.`searchEngineGroupID`=4238))) and (((`sources`.`type`=7))) and (`sources`.`keyword`="content network"))] 2012-11-28 11:05:58.124 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-11-28 11:05:58.124 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-11-28 11:05:58.124 (4) [P1T1]: time=0.0020 2012-11-28 11:05:58.124 (4) [P1T1]: Query executed in 0.002s 2012-11-28 11:05:58.124 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.124 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineMatchType`="content") or (`sources`.`searchEngineMatchType`="unknown"))) and (((`sources`.`searchEngineAccountID`=4213) or (`sources`.`searchEngineAccountID`=0))) and (((`sources`.`searchEngineGroupID`=4238) or (`sources`.`searchEngineGroupID`=0))) and (((`sources`.`type`=7) or (`sources`.`type`="0"))) and (`sources`.`keyword`="content network")) order by `sources`.`id`] 2012-11-28 11:05:58.125 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.126 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.126 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.126 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.126 (4) [P1T1]: Unable to find source for keyword "content network", altkey "null", identifier "null" (match type: content) 2012-11-28 11:05:58.126 (5) [P1T1]: parseInteger->[4213] 2012-11-28 11:05:58.126 (5) [P1T1]: parseInteger<-[4213] 2012-11-28 11:05:58.126 (5) [P1T1]: parseInteger->[3] 2012-11-28 11:05:58.126 (5) [P1T1]: parseInteger<-[3] 2012-11-28 11:05:58.126 (5) [P1T1]: parseInteger->[694] 2012-11-28 11:05:58.126 (5) [P1T1]: parseInteger<-[694] 2012-11-28 11:05:58.126 (5) [P1T1]: parseInteger->[7] 2012-11-28 11:05:58.126 (5) [P1T1]: parseInteger<-[7] 2012-11-28 11:05:58.126 (5) [P1T1]: parseInteger->[4238] 2012-11-28 11:05:58.126 (5) [P1T1]: parseInteger<-[4238] 2012-11-28 11:05:58.126 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.126 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:58.127 (5) [P1T1]: quoteValue(), nothing special about it=>[4213], type=class java.lang.Integer 2012-11-28 11:05:58.127 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.127 (5) [P1T1]: quoteValue(), nothing special about it=>[4238], type=class java.lang.Integer 2012-11-28 11:05:58.127 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.127 (5) [P1T1]: quoteValue(), nothing special about it=>[7], type=class java.lang.Integer 2012-11-28 11:05:58.127 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.127 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineMatchType`="content"))) and (((`sources`.`searchEngineAccountID`=4213))) and (((`sources`.`searchEngineGroupID`=4238))) and (((`sources`.`type`=7))) and (`sources`.`keyword`="content network"))] 2012-11-28 11:05:58.129 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-11-28 11:05:58.129 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-11-28 11:05:58.129 (4) [P1T1]: time=0.0020 2012-11-28 11:05:58.129 (4) [P1T1]: Query executed in 0.002s 2012-11-28 11:05:58.129 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.129 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineMatchType`="content") or (`sources`.`searchEngineMatchType`="unknown"))) and (((`sources`.`searchEngineAccountID`=4213) or (`sources`.`searchEngineAccountID`=0))) and (((`sources`.`searchEngineGroupID`=4238) or (`sources`.`searchEngineGroupID`=0))) and (((`sources`.`type`=7) or (`sources`.`type`="0"))) and (`sources`.`keyword`="content network")) order by `sources`.`id`] 2012-11-28 11:05:58.130 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.131 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.131 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.131 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.131 (4) [P1T1]: Unable to find source for keyword "content network", altkey "null", identifier "null" (match type: content) 2012-11-28 11:05:58.131 (5) [P1T1]: parseInteger->[4213] 2012-11-28 11:05:58.131 (5) [P1T1]: parseInteger<-[4213] 2012-11-28 11:05:58.131 (5) [P1T1]: parseInteger->[3] 2012-11-28 11:05:58.131 (5) [P1T1]: parseInteger<-[3] 2012-11-28 11:05:58.131 (5) [P1T1]: parseInteger->[694] 2012-11-28 11:05:58.131 (5) [P1T1]: parseInteger<-[694] 2012-11-28 11:05:58.131 (5) [P1T1]: parseInteger->[7] 2012-11-28 11:05:58.131 (5) [P1T1]: parseInteger<-[7] 2012-11-28 11:05:58.131 (5) [P1T1]: parseInteger->[4238] 2012-11-28 11:05:58.131 (5) [P1T1]: parseInteger<-[4238] 2012-11-28 11:05:58.131 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.131 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:58.132 (5) [P1T1]: quoteValue(), nothing special about it=>[4213], type=class java.lang.Integer 2012-11-28 11:05:58.132 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.132 (5) [P1T1]: quoteValue(), nothing special about it=>[4238], type=class java.lang.Integer 2012-11-28 11:05:58.132 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.132 (5) [P1T1]: quoteValue(), nothing special about it=>[7], type=class java.lang.Integer 2012-11-28 11:05:58.132 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.132 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineMatchType`="content"))) and (((`sources`.`searchEngineAccountID`=4213))) and (((`sources`.`searchEngineGroupID`=4238))) and (((`sources`.`type`=7))) and (`sources`.`keyword`="content network"))] 2012-11-28 11:05:58.134 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-11-28 11:05:58.134 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-11-28 11:05:58.134 (4) [P1T1]: time=0.0020 2012-11-28 11:05:58.134 (4) [P1T1]: Query executed in 0.002s 2012-11-28 11:05:58.134 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.134 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineMatchType`="content") or (`sources`.`searchEngineMatchType`="unknown"))) and (((`sources`.`searchEngineAccountID`=4213) or (`sources`.`searchEngineAccountID`=0))) and (((`sources`.`searchEngineGroupID`=4238) or (`sources`.`searchEngineGroupID`=0))) and (((`sources`.`type`=7) or (`sources`.`type`="0"))) and (`sources`.`keyword`="content network")) order by `sources`.`id`] 2012-11-28 11:05:58.135 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.136 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.136 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.136 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.136 (4) [P1T1]: Unable to find source for keyword "content network", altkey "null", identifier "null" (match type: content) 2012-11-28 11:05:58.136 (5) [P1T1]: parseInteger->[4215] 2012-11-28 11:05:58.136 (5) [P1T1]: parseInteger<-[4215] 2012-11-28 11:05:58.136 (5) [P1T1]: parseInteger->[3] 2012-11-28 11:05:58.136 (5) [P1T1]: parseInteger<-[3] 2012-11-28 11:05:58.136 (5) [P1T1]: parseInteger->[694] 2012-11-28 11:05:58.136 (5) [P1T1]: parseInteger<-[694] 2012-11-28 11:05:58.136 (5) [P1T1]: parseInteger->[7] 2012-11-28 11:05:58.136 (5) [P1T1]: parseInteger<-[7] 2012-11-28 11:05:58.136 (5) [P1T1]: parseInteger->[4252] 2012-11-28 11:05:58.136 (5) [P1T1]: parseInteger<-[4252] 2012-11-28 11:05:58.136 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.136 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:58.137 (5) [P1T1]: quoteValue(), nothing special about it=>[4215], type=class java.lang.Integer 2012-11-28 11:05:58.137 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.137 (5) [P1T1]: quoteValue(), nothing special about it=>[4252], type=class java.lang.Integer 2012-11-28 11:05:58.137 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.137 (5) [P1T1]: quoteValue(), nothing special about it=>[7], type=class java.lang.Integer 2012-11-28 11:05:58.137 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.138 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineMatchType`="content"))) and (((`sources`.`searchEngineAccountID`=4215))) and (((`sources`.`searchEngineGroupID`=4252))) and (((`sources`.`type`=7))) and (`sources`.`keyword`="content network"))] 2012-11-28 11:05:58.139 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.139 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.139 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.139 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.139 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.139 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineMatchType`="content") or (`sources`.`searchEngineMatchType`="unknown"))) and (((`sources`.`searchEngineAccountID`=4215) or (`sources`.`searchEngineAccountID`=0))) and (((`sources`.`searchEngineGroupID`=4252) or (`sources`.`searchEngineGroupID`=0))) and (((`sources`.`type`=7) or (`sources`.`type`="0"))) and (`sources`.`keyword`="content network")) order by `sources`.`id`] 2012-11-28 11:05:58.141 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-11-28 11:05:58.141 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-11-28 11:05:58.141 (4) [P1T1]: time=0.0020 2012-11-28 11:05:58.141 (4) [P1T1]: Query executed in 0.002s 2012-11-28 11:05:58.141 (4) [P1T1]: Unable to find source for keyword "content network", altkey "null", identifier "null" (match type: content) 2012-11-28 11:05:58.141 (5) [P1T1]: parseInteger->[4215] 2012-11-28 11:05:58.141 (5) [P1T1]: parseInteger<-[4215] 2012-11-28 11:05:58.141 (5) [P1T1]: parseInteger->[3] 2012-11-28 11:05:58.141 (5) [P1T1]: parseInteger<-[3] 2012-11-28 11:05:58.141 (5) [P1T1]: parseInteger->[694] 2012-11-28 11:05:58.141 (5) [P1T1]: parseInteger<-[694] 2012-11-28 11:05:58.141 (5) [P1T1]: parseInteger->[7] 2012-11-28 11:05:58.141 (5) [P1T1]: parseInteger<-[7] 2012-11-28 11:05:58.141 (5) [P1T1]: parseInteger->[4252] 2012-11-28 11:05:58.141 (5) [P1T1]: parseInteger<-[4252] 2012-11-28 11:05:58.142 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.142 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:58.142 (5) [P1T1]: quoteValue(), nothing special about it=>[4215], type=class java.lang.Integer 2012-11-28 11:05:58.142 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.142 (5) [P1T1]: quoteValue(), nothing special about it=>[4252], type=class java.lang.Integer 2012-11-28 11:05:58.142 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.142 (5) [P1T1]: quoteValue(), nothing special about it=>[7], type=class java.lang.Integer 2012-11-28 11:05:58.143 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.143 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineMatchType`="content"))) and (((`sources`.`searchEngineAccountID`=4215))) and (((`sources`.`searchEngineGroupID`=4252))) and (((`sources`.`type`=7))) and (`sources`.`keyword`="content network"))] 2012-11-28 11:05:58.144 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.144 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.144 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.144 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.144 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.145 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineMatchType`="content") or (`sources`.`searchEngineMatchType`="unknown"))) and (((`sources`.`searchEngineAccountID`=4215) or (`sources`.`searchEngineAccountID`=0))) and (((`sources`.`searchEngineGroupID`=4252) or (`sources`.`searchEngineGroupID`=0))) and (((`sources`.`type`=7) or (`sources`.`type`="0"))) and (`sources`.`keyword`="content network")) order by `sources`.`id`] 2012-11-28 11:05:58.146 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-11-28 11:05:58.146 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-11-28 11:05:58.146 (4) [P1T1]: time=0.0020 2012-11-28 11:05:58.146 (4) [P1T1]: Query executed in 0.002s 2012-11-28 11:05:58.146 (4) [P1T1]: Unable to find source for keyword "content network", altkey "null", identifier "null" (match type: content) 2012-11-28 11:05:58.146 (5) [P1T1]: parseInteger->[4216] 2012-11-28 11:05:58.146 (5) [P1T1]: parseInteger<-[4216] 2012-11-28 11:05:58.146 (5) [P1T1]: parseInteger->[3] 2012-11-28 11:05:58.146 (5) [P1T1]: parseInteger<-[3] 2012-11-28 11:05:58.146 (5) [P1T1]: parseInteger->[694] 2012-11-28 11:05:58.146 (5) [P1T1]: parseInteger<-[694] 2012-11-28 11:05:58.146 (5) [P1T1]: parseInteger->[7] 2012-11-28 11:05:58.147 (5) [P1T1]: parseInteger<-[7] 2012-11-28 11:05:58.147 (5) [P1T1]: parseInteger->[4219] 2012-11-28 11:05:58.147 (5) [P1T1]: parseInteger<-[4219] 2012-11-28 11:05:58.147 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.147 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:58.147 (5) [P1T1]: quoteValue(), nothing special about it=>[4216], type=class java.lang.Integer 2012-11-28 11:05:58.147 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.147 (5) [P1T1]: quoteValue(), nothing special about it=>[4219], type=class java.lang.Integer 2012-11-28 11:05:58.147 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.148 (5) [P1T1]: quoteValue(), nothing special about it=>[7], type=class java.lang.Integer 2012-11-28 11:05:58.148 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.148 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineMatchType`="content"))) and (((`sources`.`searchEngineAccountID`=4216))) and (((`sources`.`searchEngineGroupID`=4219))) and (((`sources`.`type`=7))) and (`sources`.`keyword`="content network"))] 2012-11-28 11:05:58.149 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.149 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.149 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.149 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.150 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.150 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineMatchType`="content") or (`sources`.`searchEngineMatchType`="unknown"))) and (((`sources`.`searchEngineAccountID`=4216) or (`sources`.`searchEngineAccountID`=0))) and (((`sources`.`searchEngineGroupID`=4219) or (`sources`.`searchEngineGroupID`=0))) and (((`sources`.`type`=7) or (`sources`.`type`="0"))) and (`sources`.`keyword`="content network")) order by `sources`.`id`] 2012-11-28 11:05:58.151 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.151 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.151 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.151 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.151 (4) [P1T1]: Unable to find source for keyword "content network", altkey "null", identifier "null" (match type: content) 2012-11-28 11:05:58.151 (5) [P1T1]: parseInteger->[4216] 2012-11-28 11:05:58.151 (5) [P1T1]: parseInteger<-[4216] 2012-11-28 11:05:58.152 (5) [P1T1]: parseInteger->[3] 2012-11-28 11:05:58.152 (5) [P1T1]: parseInteger<-[3] 2012-11-28 11:05:58.152 (5) [P1T1]: parseInteger->[694] 2012-11-28 11:05:58.152 (5) [P1T1]: parseInteger<-[694] 2012-11-28 11:05:58.152 (5) [P1T1]: parseInteger->[7] 2012-11-28 11:05:58.152 (5) [P1T1]: parseInteger<-[7] 2012-11-28 11:05:58.152 (5) [P1T1]: parseInteger->[4219] 2012-11-28 11:05:58.152 (5) [P1T1]: parseInteger<-[4219] 2012-11-28 11:05:58.152 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.152 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:58.152 (5) [P1T1]: quoteValue(), nothing special about it=>[4216], type=class java.lang.Integer 2012-11-28 11:05:58.152 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.153 (5) [P1T1]: quoteValue(), nothing special about it=>[4219], type=class java.lang.Integer 2012-11-28 11:05:58.153 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.153 (5) [P1T1]: quoteValue(), nothing special about it=>[7], type=class java.lang.Integer 2012-11-28 11:05:58.153 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.153 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineMatchType`="content"))) and (((`sources`.`searchEngineAccountID`=4216))) and (((`sources`.`searchEngineGroupID`=4219))) and (((`sources`.`type`=7))) and (`sources`.`keyword`="content network"))] 2012-11-28 11:05:58.154 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.155 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.155 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.155 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.155 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.155 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineMatchType`="content") or (`sources`.`searchEngineMatchType`="unknown"))) and (((`sources`.`searchEngineAccountID`=4216) or (`sources`.`searchEngineAccountID`=0))) and (((`sources`.`searchEngineGroupID`=4219) or (`sources`.`searchEngineGroupID`=0))) and (((`sources`.`type`=7) or (`sources`.`type`="0"))) and (`sources`.`keyword`="content network")) order by `sources`.`id`] 2012-11-28 11:05:58.156 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.156 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.156 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.157 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.157 (4) [P1T1]: Unable to find source for keyword "content network", altkey "null", identifier "null" (match type: content) 2012-11-28 11:05:58.157 (5) [P1T1]: parseInteger->[4216] 2012-11-28 11:05:58.157 (5) [P1T1]: parseInteger<-[4216] 2012-11-28 11:05:58.157 (5) [P1T1]: parseInteger->[3] 2012-11-28 11:05:58.157 (5) [P1T1]: parseInteger<-[3] 2012-11-28 11:05:58.157 (5) [P1T1]: parseInteger->[694] 2012-11-28 11:05:58.157 (5) [P1T1]: parseInteger<-[694] 2012-11-28 11:05:58.157 (5) [P1T1]: parseInteger->[7] 2012-11-28 11:05:58.157 (5) [P1T1]: parseInteger<-[7] 2012-11-28 11:05:58.157 (5) [P1T1]: parseInteger->[4219] 2012-11-28 11:05:58.157 (5) [P1T1]: parseInteger<-[4219] 2012-11-28 11:05:58.157 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.157 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:58.158 (5) [P1T1]: quoteValue(), nothing special about it=>[4216], type=class java.lang.Integer 2012-11-28 11:05:58.158 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.158 (5) [P1T1]: quoteValue(), nothing special about it=>[4219], type=class java.lang.Integer 2012-11-28 11:05:58.158 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.158 (5) [P1T1]: quoteValue(), nothing special about it=>[7], type=class java.lang.Integer 2012-11-28 11:05:58.158 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.158 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineMatchType`="content"))) and (((`sources`.`searchEngineAccountID`=4216))) and (((`sources`.`searchEngineGroupID`=4219))) and (((`sources`.`type`=7))) and (`sources`.`keyword`="content network"))] 2012-11-28 11:05:58.160 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-11-28 11:05:58.160 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-11-28 11:05:58.160 (4) [P1T1]: time=0.0020 2012-11-28 11:05:58.160 (4) [P1T1]: Query executed in 0.002s 2012-11-28 11:05:58.160 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.160 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineMatchType`="content") or (`sources`.`searchEngineMatchType`="unknown"))) and (((`sources`.`searchEngineAccountID`=4216) or (`sources`.`searchEngineAccountID`=0))) and (((`sources`.`searchEngineGroupID`=4219) or (`sources`.`searchEngineGroupID`=0))) and (((`sources`.`type`=7) or (`sources`.`type`="0"))) and (`sources`.`keyword`="content network")) order by `sources`.`id`] 2012-11-28 11:05:58.161 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.161 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.162 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.162 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.162 (4) [P1T1]: Unable to find source for keyword "content network", altkey "null", identifier "null" (match type: content) 2012-11-28 11:05:58.162 (5) [P1T1]: parseInteger->[4216] 2012-11-28 11:05:58.162 (5) [P1T1]: parseInteger<-[4216] 2012-11-28 11:05:58.162 (5) [P1T1]: parseInteger->[3] 2012-11-28 11:05:58.162 (5) [P1T1]: parseInteger<-[3] 2012-11-28 11:05:58.162 (5) [P1T1]: parseInteger->[694] 2012-11-28 11:05:58.162 (5) [P1T1]: parseInteger<-[694] 2012-11-28 11:05:58.162 (5) [P1T1]: parseInteger->[7] 2012-11-28 11:05:58.162 (5) [P1T1]: parseInteger<-[7] 2012-11-28 11:05:58.162 (5) [P1T1]: parseInteger->[4219] 2012-11-28 11:05:58.162 (5) [P1T1]: parseInteger<-[4219] 2012-11-28 11:05:58.162 (5) [P1T1]: quoteValue(), nothing special about it=>[694], type=class java.lang.Integer 2012-11-28 11:05:58.162 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2012-11-28 11:05:58.163 (5) [P1T1]: quoteValue(), nothing special about it=>[4216], type=class java.lang.Integer 2012-11-28 11:05:58.163 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.163 (5) [P1T1]: quoteValue(), nothing special about it=>[4219], type=class java.lang.Integer 2012-11-28 11:05:58.163 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2012-11-28 11:05:58.163 (5) [P1T1]: quoteValue(), nothing special about it=>[7], type=class java.lang.Integer 2012-11-28 11:05:58.163 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.163 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineMatchType`="content"))) and (((`sources`.`searchEngineAccountID`=4216))) and (((`sources`.`searchEngineGroupID`=4219))) and (((`sources`.`type`=7))) and (`sources`.`keyword`="content network"))] 2012-11-28 11:05:58.165 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-11-28 11:05:58.165 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-11-28 11:05:58.165 (4) [P1T1]: time=0.0020 2012-11-28 11:05:58.165 (4) [P1T1]: Query executed in 0.002s 2012-11-28 11:05:58.165 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.165 (4) [P1T1]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=694) and (`sources`.`distributionID`=3) and (((`sources`.`searchEngineMatchType`="content") or (`sources`.`searchEngineMatchType`="unknown"))) and (((`sources`.`searchEngineAccountID`=4216) or (`sources`.`searchEngineAccountID`=0))) and (((`sources`.`searchEngineGroupID`=4219) or (`sources`.`searchEngineGroupID`=0))) and (((`sources`.`type`=7) or (`sources`.`type`="0"))) and (`sources`.`keyword`="content network")) order by `sources`.`id`] 2012-11-28 11:05:58.166 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.166 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.166 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.167 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.167 (4) [P1T1]: Unable to find source for keyword "content network", altkey "null", identifier "null" (match type: content) 2012-11-28 11:05:58.167 (5) [P1T1]: quoteValue(), nothing special about it=>[94794313], type=class java.lang.Long 2012-11-28 11:05:58.167 (5) [P1T1]: quoteValue(), nothing special about it=>[94794073], type=class java.lang.Long 2012-11-28 11:05:58.167 (5) [P1T1]: quoteValue(), nothing special about it=>[94794193], type=class java.lang.Long 2012-11-28 11:05:58.167 (5) [P1T1]: quoteValue(), nothing special about it=>[94793353], type=class java.lang.Long 2012-11-28 11:05:58.167 (5) [P1T1]: quoteValue(), nothing special about it=>[94793473], type=class java.lang.Long 2012-11-28 11:05:58.167 (5) [P1T1]: quoteValue(), nothing special about it=>[94793113], type=class java.lang.Long 2012-11-28 11:05:58.167 (5) [P1T1]: quoteValue(), nothing special about it=>[94793233], type=class java.lang.Long 2012-11-28 11:05:58.167 (5) [P1T1]: quoteValue(), nothing special about it=>[94881793], type=class java.lang.Long 2012-11-28 11:05:58.167 (5) [P1T1]: quoteValue(), nothing special about it=>[94793833], type=class java.lang.Long 2012-11-28 11:05:58.167 (5) [P1T1]: quoteValue(), nothing special about it=>[94793953], type=class java.lang.Long 2012-11-28 11:05:58.167 (5) [P1T1]: quoteValue(), nothing special about it=>[94793593], type=class java.lang.Long 2012-11-28 11:05:58.167 (5) [P1T1]: quoteValue(), nothing special about it=>[94793713], type=class java.lang.Long 2012-11-28 11:05:58.167 (5) [P1T1]: quoteValue(), nothing special about it=>[94790233], type=class java.lang.Long 2012-11-28 11:05:58.167 (5) [P1T1]: quoteValue(), nothing special about it=>[94790353], type=class java.lang.Long 2012-11-28 11:05:58.167 (5) [P1T1]: quoteValue(), nothing special about it=>[94790473], type=class java.lang.Long 2012-11-28 11:05:58.167 (5) [P1T1]: quoteValue(), nothing special about it=>[94790593], type=class java.lang.Long 2012-11-28 11:05:58.167 (5) [P1T1]: quoteValue(), nothing special about it=>[94790713], type=class java.lang.Long 2012-11-28 11:05:58.167 (5) [P1T1]: quoteValue(), nothing special about it=>[94790833], type=class java.lang.Long 2012-11-28 11:05:58.168 (5) [P1T1]: quoteValue(), nothing special about it=>[94790953], type=class java.lang.Long 2012-11-28 11:05:58.168 (5) [P1T1]: quoteValue(), nothing special about it=>[94791073], type=class java.lang.Long 2012-11-28 11:05:58.168 (5) [P1T1]: quoteValue(), nothing special about it=>[94789273], type=class java.lang.Long 2012-11-28 11:05:58.168 (5) [P1T1]: quoteValue(), nothing special about it=>[94789393], type=class java.lang.Long 2012-11-28 11:05:58.168 (5) [P1T1]: quoteValue(), nothing special about it=>[94789513], type=class java.lang.Long 2012-11-28 11:05:58.168 (5) [P1T1]: quoteValue(), nothing special about it=>[94789633], type=class java.lang.Long 2012-11-28 11:05:58.168 (5) [P1T1]: quoteValue(), nothing special about it=>[94789753], type=class java.lang.Long 2012-11-28 11:05:58.168 (5) [P1T1]: quoteValue(), nothing special about it=>[94789873], type=class java.lang.Long 2012-11-28 11:05:58.168 (5) [P1T1]: quoteValue(), nothing special about it=>[94789993], type=class java.lang.Long 2012-11-28 11:05:58.168 (5) [P1T1]: quoteValue(), nothing special about it=>[94790113], type=class java.lang.Long 2012-11-28 11:05:58.168 (5) [P1T1]: quoteValue(), nothing special about it=>[94792273], type=class java.lang.Long 2012-11-28 11:05:58.177 (5) [P1T1]: quoteValue(), nothing special about it=>[94792153], type=class java.lang.Long 2012-11-28 11:05:58.177 (5) [P1T1]: quoteValue(), nothing special about it=>[94792513], type=class java.lang.Long 2012-11-28 11:05:58.177 (5) [P1T1]: quoteValue(), nothing special about it=>[94792393], type=class java.lang.Long 2012-11-28 11:05:58.177 (5) [P1T1]: quoteValue(), nothing special about it=>[94792753], type=class java.lang.Long 2012-11-28 11:05:58.177 (5) [P1T1]: quoteValue(), nothing special about it=>[94792633], type=class java.lang.Long 2012-11-28 11:05:58.177 (5) [P1T1]: quoteValue(), nothing special about it=>[94792993], type=class java.lang.Long 2012-11-28 11:05:58.177 (5) [P1T1]: quoteValue(), nothing special about it=>[94792873], type=class java.lang.Long 2012-11-28 11:05:58.178 (5) [P1T1]: quoteValue(), nothing special about it=>[94791313], type=class java.lang.Long 2012-11-28 11:05:58.178 (5) [P1T1]: quoteValue(), nothing special about it=>[94791193], type=class java.lang.Long 2012-11-28 11:05:58.178 (5) [P1T1]: quoteValue(), nothing special about it=>[94791553], type=class java.lang.Long 2012-11-28 11:05:58.178 (5) [P1T1]: quoteValue(), nothing special about it=>[94791433], type=class java.lang.Long 2012-11-28 11:05:58.178 (5) [P1T1]: quoteValue(), nothing special about it=>[94791793], type=class java.lang.Long 2012-11-28 11:05:58.178 (5) [P1T1]: quoteValue(), nothing special about it=>[94791673], type=class java.lang.Long 2012-11-28 11:05:58.178 (5) [P1T1]: quoteValue(), nothing special about it=>[94792033], type=class java.lang.Long 2012-11-28 11:05:58.178 (5) [P1T1]: quoteValue(), nothing special about it=>[94791913], type=class java.lang.Long 2012-11-28 11:05:58.178 (5) [P1T1]: quoteValue(), nothing special about it=>[94788073], type=class java.lang.Long 2012-11-28 11:05:58.178 (5) [P1T1]: quoteValue(), nothing special about it=>[94788193], type=class java.lang.Long 2012-11-28 11:05:58.178 (5) [P1T1]: quoteValue(), nothing special about it=>[94787953], type=class java.lang.Long 2012-11-28 11:05:58.178 (5) [P1T1]: quoteValue(), nothing special about it=>[94789033], type=class java.lang.Long 2012-11-28 11:05:58.178 (5) [P1T1]: quoteValue(), nothing special about it=>[94789153], type=class java.lang.Long 2012-11-28 11:05:58.178 (5) [P1T1]: quoteValue(), nothing special about it=>[94788793], type=class java.lang.Long 2012-11-28 11:05:58.178 (5) [P1T1]: quoteValue(), nothing special about it=>[94788913], type=class java.lang.Long 2012-11-28 11:05:58.178 (5) [P1T1]: quoteValue(), nothing special about it=>[94788553], type=class java.lang.Long 2012-11-28 11:05:58.178 (5) [P1T1]: quoteValue(), nothing special about it=>[94788673], type=class java.lang.Long 2012-11-28 11:05:58.178 (5) [P1T1]: quoteValue(), nothing special about it=>[94788313], type=class java.lang.Long 2012-11-28 11:05:58.178 (5) [P1T1]: quoteValue(), nothing special about it=>[94788433], type=class java.lang.Long 2012-11-28 11:05:58.179 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.179 (4) [P1T1]: spike: SQL->[select * from `staging`.`googleMcc` where ((`staging`.`googleMcc`.`campaignid` in (94794313,94794073,94794193,94793353,94793473,94793113,94793233,94881793,94793833,94793953,94793593,94793713,94790233,94790353,94790473,94790593,94790713,94790833,94790953,94791073,94789273,94789393,94789513,94789633,94789753,94789873,94789993,94790113,94792273,94792153,94792513,94792393,94792753,94792633,94792993,94792873,94791313,94791193,94791553,94791433,94791793,94791673,94792033,94791913,94788073,94788193,94787953,94789033,94789153,94788793,94788913,94788553,94788673,94788313,94788433)) and (`staging`.`googleMcc`.`startTime`="2012-11-17 00:00:00") and (`staging`.`googleMcc`.`adwordsType`="Content Only") and (`staging`.`googleMcc`.`kwType`="WebSite"))] 2012-11-28 11:05:58.180 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.180 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.180 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.180 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.180 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.180 (4) [P1T1]: spike: SQL->[delete from `st-tracker`.`tmp1`], genflags=no 2012-11-28 11:05:58.181 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.181 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.181 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.181 (4) [P1T1]: Query executed in 0.001s, 10 row(s) affected 2012-11-28 11:05:58.182 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.`tmp1` (`startTime`, `campaignid`, `adgroupid`, `keywordid`, `keyword`, `kwType`, `creativeid`, `creativeDestUrl`, `kwDestUrl`, `adwordsType`, `maxCpc`, `imps`, `clicks`, `cost`, `pos`, `conv`, `transactions`, `purchases`, `purchaseValue`, `leads`, `leadValue`, `signups`, `signupValue`, `pageviews`, `pageviewValue`, `defaultConv`, `defaultConvValue`, `qualityScore`, `firstPageCPC`) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)] 2012-11-28 11:05:58.183 (4) [P1T1]: replicated 0 rows to `st-tracker`.`tmp1` 2012-11-28 11:05:58.184 (5) [P1T1]: quoteValue(), nothing special about it=>[4266], type=class java.lang.Integer 2012-11-28 11:05:58.184 (5) [P1T1]: quoteValue(), nothing special about it=>[4264], type=class java.lang.Integer 2012-11-28 11:05:58.184 (5) [P1T1]: quoteValue(), nothing special about it=>[4265], type=class java.lang.Integer 2012-11-28 11:05:58.184 (5) [P1T1]: quoteValue(), nothing special about it=>[4258], type=class java.lang.Integer 2012-11-28 11:05:58.184 (5) [P1T1]: quoteValue(), nothing special about it=>[4259], type=class java.lang.Integer 2012-11-28 11:05:58.184 (5) [P1T1]: quoteValue(), nothing special about it=>[4256], type=class java.lang.Integer 2012-11-28 11:05:58.184 (5) [P1T1]: quoteValue(), nothing special about it=>[4257], type=class java.lang.Integer 2012-11-28 11:05:58.184 (5) [P1T1]: quoteValue(), nothing special about it=>[4736], type=class java.lang.Integer 2012-11-28 11:05:58.184 (5) [P1T1]: quoteValue(), nothing special about it=>[4262], type=class java.lang.Integer 2012-11-28 11:05:58.184 (5) [P1T1]: quoteValue(), nothing special about it=>[4263], type=class java.lang.Integer 2012-11-28 11:05:58.184 (5) [P1T1]: quoteValue(), nothing special about it=>[4260], type=class java.lang.Integer 2012-11-28 11:05:58.184 (5) [P1T1]: quoteValue(), nothing special about it=>[4261], type=class java.lang.Integer 2012-11-28 11:05:58.184 (5) [P1T1]: quoteValue(), nothing special about it=>[4232], type=class java.lang.Integer 2012-11-28 11:05:58.184 (5) [P1T1]: quoteValue(), nothing special about it=>[4233], type=class java.lang.Integer 2012-11-28 11:05:58.184 (5) [P1T1]: quoteValue(), nothing special about it=>[4234], type=class java.lang.Integer 2012-11-28 11:05:58.184 (5) [P1T1]: quoteValue(), nothing special about it=>[4235], type=class java.lang.Integer 2012-11-28 11:05:58.184 (5) [P1T1]: quoteValue(), nothing special about it=>[4236], type=class java.lang.Integer 2012-11-28 11:05:58.184 (5) [P1T1]: quoteValue(), nothing special about it=>[4237], type=class java.lang.Integer 2012-11-28 11:05:58.184 (5) [P1T1]: quoteValue(), nothing special about it=>[4238], type=class java.lang.Integer 2012-11-28 11:05:58.184 (5) [P1T1]: quoteValue(), nothing special about it=>[4239], type=class java.lang.Integer 2012-11-28 11:05:58.185 (5) [P1T1]: quoteValue(), nothing special about it=>[4224], type=class java.lang.Integer 2012-11-28 11:05:58.185 (5) [P1T1]: quoteValue(), nothing special about it=>[4225], type=class java.lang.Integer 2012-11-28 11:05:58.185 (5) [P1T1]: quoteValue(), nothing special about it=>[4226], type=class java.lang.Integer 2012-11-28 11:05:58.185 (5) [P1T1]: quoteValue(), nothing special about it=>[4227], type=class java.lang.Integer 2012-11-28 11:05:58.185 (5) [P1T1]: quoteValue(), nothing special about it=>[4228], type=class java.lang.Integer 2012-11-28 11:05:58.185 (5) [P1T1]: quoteValue(), nothing special about it=>[4229], type=class java.lang.Integer 2012-11-28 11:05:58.185 (5) [P1T1]: quoteValue(), nothing special about it=>[4230], type=class java.lang.Integer 2012-11-28 11:05:58.185 (5) [P1T1]: quoteValue(), nothing special about it=>[4231], type=class java.lang.Integer 2012-11-28 11:05:58.185 (5) [P1T1]: quoteValue(), nothing special about it=>[4249], type=class java.lang.Integer 2012-11-28 11:05:58.185 (5) [P1T1]: quoteValue(), nothing special about it=>[4248], type=class java.lang.Integer 2012-11-28 11:05:58.185 (5) [P1T1]: quoteValue(), nothing special about it=>[4251], type=class java.lang.Integer 2012-11-28 11:05:58.185 (5) [P1T1]: quoteValue(), nothing special about it=>[4250], type=class java.lang.Integer 2012-11-28 11:05:58.185 (5) [P1T1]: quoteValue(), nothing special about it=>[4253], type=class java.lang.Integer 2012-11-28 11:05:58.185 (5) [P1T1]: quoteValue(), nothing special about it=>[4252], type=class java.lang.Integer 2012-11-28 11:05:58.185 (5) [P1T1]: quoteValue(), nothing special about it=>[4255], type=class java.lang.Integer 2012-11-28 11:05:58.185 (5) [P1T1]: quoteValue(), nothing special about it=>[4254], type=class java.lang.Integer 2012-11-28 11:05:58.185 (5) [P1T1]: quoteValue(), nothing special about it=>[4241], type=class java.lang.Integer 2012-11-28 11:05:58.185 (5) [P1T1]: quoteValue(), nothing special about it=>[4240], type=class java.lang.Integer 2012-11-28 11:05:58.185 (5) [P1T1]: quoteValue(), nothing special about it=>[4243], type=class java.lang.Integer 2012-11-28 11:05:58.185 (5) [P1T1]: quoteValue(), nothing special about it=>[4242], type=class java.lang.Integer 2012-11-28 11:05:58.186 (5) [P1T1]: quoteValue(), nothing special about it=>[4245], type=class java.lang.Integer 2012-11-28 11:05:58.186 (5) [P1T1]: quoteValue(), nothing special about it=>[4244], type=class java.lang.Integer 2012-11-28 11:05:58.186 (5) [P1T1]: quoteValue(), nothing special about it=>[4247], type=class java.lang.Integer 2012-11-28 11:05:58.186 (5) [P1T1]: quoteValue(), nothing special about it=>[4246], type=class java.lang.Integer 2012-11-28 11:05:58.186 (5) [P1T1]: quoteValue(), nothing special about it=>[4214], type=class java.lang.Integer 2012-11-28 11:05:58.186 (5) [P1T1]: quoteValue(), nothing special about it=>[4215], type=class java.lang.Integer 2012-11-28 11:05:58.186 (5) [P1T1]: quoteValue(), nothing special about it=>[4213], type=class java.lang.Integer 2012-11-28 11:05:58.186 (5) [P1T1]: quoteValue(), nothing special about it=>[4222], type=class java.lang.Integer 2012-11-28 11:05:58.186 (5) [P1T1]: quoteValue(), nothing special about it=>[4223], type=class java.lang.Integer 2012-11-28 11:05:58.186 (5) [P1T1]: quoteValue(), nothing special about it=>[4220], type=class java.lang.Integer 2012-11-28 11:05:58.186 (5) [P1T1]: quoteValue(), nothing special about it=>[4221], type=class java.lang.Integer 2012-11-28 11:05:58.186 (5) [P1T1]: quoteValue(), nothing special about it=>[4218], type=class java.lang.Integer 2012-11-28 11:05:58.186 (5) [P1T1]: quoteValue(), nothing special about it=>[4219], type=class java.lang.Integer 2012-11-28 11:05:58.186 (5) [P1T1]: quoteValue(), nothing special about it=>[4216], type=class java.lang.Integer 2012-11-28 11:05:58.186 (5) [P1T1]: quoteValue(), nothing special about it=>[4217], type=class java.lang.Integer 2012-11-28 11:05:58.186 (5) [P1T1]: quoteValue(), nothing special about it=>[94794313], type=class java.lang.Long 2012-11-28 11:05:58.186 (5) [P1T1]: quoteValue(), nothing special about it=>[94794073], type=class java.lang.Long 2012-11-28 11:05:58.186 (5) [P1T1]: quoteValue(), nothing special about it=>[94794193], type=class java.lang.Long 2012-11-28 11:05:58.186 (5) [P1T1]: quoteValue(), nothing special about it=>[94793353], type=class java.lang.Long 2012-11-28 11:05:58.186 (5) [P1T1]: quoteValue(), nothing special about it=>[94793473], type=class java.lang.Long 2012-11-28 11:05:58.186 (5) [P1T1]: quoteValue(), nothing special about it=>[94793113], type=class java.lang.Long 2012-11-28 11:05:58.186 (5) [P1T1]: quoteValue(), nothing special about it=>[94793233], type=class java.lang.Long 2012-11-28 11:05:58.187 (5) [P1T1]: quoteValue(), nothing special about it=>[94881793], type=class java.lang.Long 2012-11-28 11:05:58.187 (5) [P1T1]: quoteValue(), nothing special about it=>[94793833], type=class java.lang.Long 2012-11-28 11:05:58.187 (5) [P1T1]: quoteValue(), nothing special about it=>[94793953], type=class java.lang.Long 2012-11-28 11:05:58.187 (5) [P1T1]: quoteValue(), nothing special about it=>[94793593], type=class java.lang.Long 2012-11-28 11:05:58.187 (5) [P1T1]: quoteValue(), nothing special about it=>[94793713], type=class java.lang.Long 2012-11-28 11:05:58.187 (5) [P1T1]: quoteValue(), nothing special about it=>[94790233], type=class java.lang.Long 2012-11-28 11:05:58.187 (5) [P1T1]: quoteValue(), nothing special about it=>[94790353], type=class java.lang.Long 2012-11-28 11:05:58.187 (5) [P1T1]: quoteValue(), nothing special about it=>[94790473], type=class java.lang.Long 2012-11-28 11:05:58.187 (5) [P1T1]: quoteValue(), nothing special about it=>[94790593], type=class java.lang.Long 2012-11-28 11:05:58.187 (5) [P1T1]: quoteValue(), nothing special about it=>[94790713], type=class java.lang.Long 2012-11-28 11:05:58.187 (5) [P1T1]: quoteValue(), nothing special about it=>[94790833], type=class java.lang.Long 2012-11-28 11:05:58.187 (5) [P1T1]: quoteValue(), nothing special about it=>[94790953], type=class java.lang.Long 2012-11-28 11:05:58.187 (5) [P1T1]: quoteValue(), nothing special about it=>[94791073], type=class java.lang.Long 2012-11-28 11:05:58.187 (5) [P1T1]: quoteValue(), nothing special about it=>[94789273], type=class java.lang.Long 2012-11-28 11:05:58.187 (5) [P1T1]: quoteValue(), nothing special about it=>[94789393], type=class java.lang.Long 2012-11-28 11:05:58.187 (5) [P1T1]: quoteValue(), nothing special about it=>[94789513], type=class java.lang.Long 2012-11-28 11:05:58.187 (5) [P1T1]: quoteValue(), nothing special about it=>[94789633], type=class java.lang.Long 2012-11-28 11:05:58.187 (5) [P1T1]: quoteValue(), nothing special about it=>[94789753], type=class java.lang.Long 2012-11-28 11:05:58.187 (5) [P1T1]: quoteValue(), nothing special about it=>[94789873], type=class java.lang.Long 2012-11-28 11:05:58.187 (5) [P1T1]: quoteValue(), nothing special about it=>[94789993], type=class java.lang.Long 2012-11-28 11:05:58.187 (5) [P1T1]: quoteValue(), nothing special about it=>[94790113], type=class java.lang.Long 2012-11-28 11:05:58.187 (5) [P1T1]: quoteValue(), nothing special about it=>[94792273], type=class java.lang.Long 2012-11-28 11:05:58.187 (5) [P1T1]: quoteValue(), nothing special about it=>[94792153], type=class java.lang.Long 2012-11-28 11:05:58.188 (5) [P1T1]: quoteValue(), nothing special about it=>[94792513], type=class java.lang.Long 2012-11-28 11:05:58.188 (5) [P1T1]: quoteValue(), nothing special about it=>[94792393], type=class java.lang.Long 2012-11-28 11:05:58.188 (5) [P1T1]: quoteValue(), nothing special about it=>[94792753], type=class java.lang.Long 2012-11-28 11:05:58.188 (5) [P1T1]: quoteValue(), nothing special about it=>[94792633], type=class java.lang.Long 2012-11-28 11:05:58.188 (5) [P1T1]: quoteValue(), nothing special about it=>[94792993], type=class java.lang.Long 2012-11-28 11:05:58.188 (5) [P1T1]: quoteValue(), nothing special about it=>[94792873], type=class java.lang.Long 2012-11-28 11:05:58.188 (5) [P1T1]: quoteValue(), nothing special about it=>[94791313], type=class java.lang.Long 2012-11-28 11:05:58.188 (5) [P1T1]: quoteValue(), nothing special about it=>[94791193], type=class java.lang.Long 2012-11-28 11:05:58.188 (5) [P1T1]: quoteValue(), nothing special about it=>[94791553], type=class java.lang.Long 2012-11-28 11:05:58.188 (5) [P1T1]: quoteValue(), nothing special about it=>[94791433], type=class java.lang.Long 2012-11-28 11:05:58.188 (5) [P1T1]: quoteValue(), nothing special about it=>[94791793], type=class java.lang.Long 2012-11-28 11:05:58.188 (5) [P1T1]: quoteValue(), nothing special about it=>[94791673], type=class java.lang.Long 2012-11-28 11:05:58.188 (5) [P1T1]: quoteValue(), nothing special about it=>[94792033], type=class java.lang.Long 2012-11-28 11:05:58.188 (5) [P1T1]: quoteValue(), nothing special about it=>[94791913], type=class java.lang.Long 2012-11-28 11:05:58.188 (5) [P1T1]: quoteValue(), nothing special about it=>[94788073], type=class java.lang.Long 2012-11-28 11:05:58.188 (5) [P1T1]: quoteValue(), nothing special about it=>[94788193], type=class java.lang.Long 2012-11-28 11:05:58.188 (5) [P1T1]: quoteValue(), nothing special about it=>[94787953], type=class java.lang.Long 2012-11-28 11:05:58.188 (5) [P1T1]: quoteValue(), nothing special about it=>[94789033], type=class java.lang.Long 2012-11-28 11:05:58.188 (5) [P1T1]: quoteValue(), nothing special about it=>[94789153], type=class java.lang.Long 2012-11-28 11:05:58.188 (5) [P1T1]: quoteValue(), nothing special about it=>[94788793], type=class java.lang.Long 2012-11-28 11:05:58.188 (5) [P1T1]: quoteValue(), nothing special about it=>[94788913], type=class java.lang.Long 2012-11-28 11:05:58.188 (5) [P1T1]: quoteValue(), nothing special about it=>[94788553], type=class java.lang.Long 2012-11-28 11:05:58.188 (5) [P1T1]: quoteValue(), nothing special about it=>[94788673], type=class java.lang.Long 2012-11-28 11:05:58.189 (5) [P1T1]: quoteValue(), nothing special about it=>[94788313], type=class java.lang.Long 2012-11-28 11:05:58.189 (5) [P1T1]: quoteValue(), nothing special about it=>[94788433], type=class java.lang.Long 2012-11-28 11:05:58.190 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.190 (4) [P1T1]: spike: SQL->[select `st-tracker`.`searchEngineGroups`.`searchEngineAccountID`,`st-tracker`.`searchEngineGroups`.`id` AS `searchEngineGroupID`,`tmp1`.`creativeid`,`tmp1`.`kwType` AS `searchEngineMatchType`,`tmp1`.`keywordid` AS `searchEngineIdentifier`,SUM(`tmp1`.`imps`) AS `imps`,SUM(`tmp1`.`clicks`) AS `clicks`,SUM(`tmp1`.`cost`) AS `cost`,SUM(`tmp1`.`pos` * `tmp1`.`imps`)/SUM(`tmp1`.`imps`) AS `pos`,`tmp1`.`qualityScore` AS `qualityScore`,`tmp1`.`firstPageCPC` AS `firstPageCPC` from `st-tracker`.`tmp1` inner join `st-tracker`.`searchEngineGroups` on (((((`tmp1`.`adgroupid`=`st-tracker`.`searchEngineGroups`.`searchEngineIdentifier`)) and ((`st-tracker`.`searchEngineGroups`.`searchEngineAccountID` in (4266,4264,4265,4258,4259,4256,4257,4736,4262,4263,4260,4261,4232,4233,4234,4235,4236,4237,4238,4239,4224,4225,4226,4227,4228,4229,4230,4231,4249,4248,4251,4250,4253,4252,4255,4254,4241,4240,4243,4242,4245,4244,4247,4246,4214,4215,4213,4222,4223,4220,4221,4218,4219,4216,4217)))))) where ((`tmp1`.`campaignid` in (94794313,94794073,94794193,94793353,94793473,94793113,94793233,94881793,94793833,94793953,94793593,94793713,94790233,94790353,94790473,94790593,94790713,94790833,94790953,94791073,94789273,94789393,94789513,94789633,94789753,94789873,94789993,94790113,94792273,94792153,94792513,94792393,94792753,94792633,94792993,94792873,94791313,94791193,94791553,94791433,94791793,94791673,94792033,94791913,94788073,94788193,94787953,94789033,94789153,94788793,94788913,94788553,94788673,94788313,94788433)) and (`tmp1`.`startTime`="2012-11-17 00:00:00") and (`tmp1`.`adwordsType`="Content Only") and (`tmp1`.`kwType`="WebSite")) group by `tmp1`.`adgroupid`,`tmp1`.`creativeid`,`keywordid`,`kwType`] 2012-11-28 11:05:58.191 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.191 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.191 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.191 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.191 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.192 (4) [P1T1]: spike: SQL->[drop table `st-tracker`.`tmp1`] 2012-11-28 11:05:58.192 (5) [P1T1]: recordAsSubs("db", 0, "P1T1") 2012-11-28 11:05:58.192 (5) [P1T1]: ProfilerRec.end("db", true): ret=0 2012-11-28 11:05:58.192 (4) [P1T1]: time=0.0 2012-11-28 11:05:58.192 (4) [P1T1]: Query executed in 0.000s 2012-11-28 11:05:58.193 (5) [P1T1]: SQL execute() returned false 2012-11-28 11:05:58.193 (4) [P1T1]: SESUMM: SE returned 13 rows 2012-11-28 11:05:58.197 (4) [P1T1]: ------- Reading seAct ------------- 2012-11-28 11:05:58.197 (4) [P1T1]: 84 694 3 221559 17051 0 2012-11-17 0 1 0.0 6.0 0.0 \N 0 3.0 2012-11-28 11:05:58.197 (4) [P1T1]: 84 694 3 219973 16943 0 2012-11-17 0 1 0.0 1.0 0.0 \N 0 3.0 2012-11-28 11:05:58.197 (4) [P1T1]: 84 694 3 219973 16942 0 2012-11-17 0 1 0.0 1.0 0.0 \N 0 3.0 2012-11-28 11:05:58.197 (4) [P1T1]: 84 694 3 219585 16927 0 2012-11-17 0 1 0.0 2.0 0.0 \N 0 3.0 2012-11-28 11:05:58.198 (4) [P1T1]: 84 694 3 219455 16916 0 2012-11-17 0 1 0.0 9.0 0.0 \N 0 4.0 2012-11-28 11:05:58.198 (4) [P1T1]: 84 694 3 219697 16931 0 2012-11-17 0 1 0.0 4.0 0.0 \N 0 3.0 2012-11-28 11:05:58.198 (4) [P1T1]: 84 694 3 219585 16925 0 2012-11-17 0 1 0.0 1.0 0.0 \N 0 3.0 2012-11-28 11:05:58.198 (4) [P1T1]: 84 694 3 219585 16926 0 2012-11-17 0 1 0.0 1.0 0.0 \N 0 3.0 2012-11-28 11:05:58.198 (4) [P1T1]: 84 694 3 221561 17049 0 2012-11-17 0 1 0.0 11.0 0.0 \N 0 4.0 2012-11-28 11:05:58.198 (4) [P1T1]: 84 694 3 222307 17109 0 2012-11-17 0 1 0.0 1.0 0.0 \N 0 5.0 2012-11-28 11:05:58.198 (4) [P1T1]: 84 694 3 221511 17046 0 2012-11-17 0 1 0.0 4.0 0.0 \N 0 6.0 2012-11-28 11:05:58.198 (4) [P1T1]: 84 694 3 220937 17011 0 2012-11-17 0 1 0.0 2.0 0.0 \N 0 3.0 2012-11-28 11:05:58.198 (4) [P1T1]: 84 694 3 219589 16927 0 2012-11-17 0 2 0.0 6.0 0.0 \N 0 3.0 2012-11-28 11:05:58.198 (4) [P1T1]: ------- Reading files Done -------- 2012-11-28 11:05:58.198 (5) [P1T1]: quoteValue(), nothing special about it=>[84], type=class java.lang.Integer 2012-11-28 11:05:58.198 (4) [P1T1]: SESUMM: deleting existing records for user "84" 2012-11-28 11:05:58.198 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.198 (4) [P1T1]: spike: SQL->[delete from `tmp`.`searchEngineActivitySummary201211` where ((`searchEngineActivitySummary201211`.`searchEngineUserID`=84) and (`searchEngineActivitySummary201211`.`startTime`="2012-11-17 00:00:00"))], genflags=no 2012-11-28 11:05:58.200 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-11-28 11:05:58.200 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-11-28 11:05:58.200 (4) [P1T1]: time=0.0020 2012-11-28 11:05:58.200 (4) [P1T1]: Query executed in 0.002s, 13 row(s) affected 2012-11-28 11:05:58.201 (4) [P1T1]: DB IsolationLevel -> 4 2012-11-28 11:05:58.201 (4) [P1T1]: DB AutoCommit -> false 2012-11-28 11:05:58.201 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.201 (4) [P1T1]: spike: SQL->[start transaction] 2012-11-28 11:05:58.202 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2012-11-28 11:05:58.202 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2012-11-28 11:05:58.202 (4) [P1T1]: time=0.0010 2012-11-28 11:05:58.202 (4) [P1T1]: Query executed in 0.001s 2012-11-28 11:05:58.202 (5) [P1T1]: SQL execute() returned false 2012-11-28 11:05:58.202 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.202 (4) [P1T1]: spike: SQL->[LOAD DATA LOCAL INFILE '/tmp/sesummUser843686695526130351768.csv' REPLACE INTO TABLE `tmp`.`searchEngineActivitySummary201211` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' (`searchEngineUserID`,`accountID`,`distributionID`,`sourceID`,`searchEngineListingID`,`siteID`,`startTime`,`count`,`impressions`,`cost`,`avgPosition`,`avgCTR`,`conversions`,`value`,`qualityScore`)], genflags=no 2012-11-28 11:05:58.204 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2012-11-28 11:05:58.205 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2012-11-28 11:05:58.205 (4) [P1T1]: time=0.0020 2012-11-28 11:05:58.205 (4) [P1T1]: Query executed in 0.002s, 13 row(s) affected 2012-11-28 11:05:58.205 (4) [P1T1]: SESUMM: Inserted 13 into `tmp`.`searchEngineActivitySummary201211` 2012-11-28 11:05:58.205 (4) [P1T1]: spike: SQL->[commit] 2012-11-28 11:05:58.205 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2012-11-28 11:05:58.214 (5) [P1T1]: recordAsSubs("db", 9, "P1T1") 2012-11-28 11:05:58.214 (5) [P1T1]: ProfilerRec.end("db", true): ret=9 2012-11-28 11:05:58.214 (4) [P1T1]: time=0.0090 2012-11-28 11:05:58.214 (4) [P1T1]: Query executed in 0.009s 2012-11-28 11:05:58.214 (4) [P1T1]: DB AutoCommit -> true 2012-11-28 11:05:58.214 (4) [P1T1]: DB IsolationLevel -> 4 2012-11-28 11:05:58.215 (3) [P1T1]: SESUMM: Completed User (84) "82190643000197-0411661664_1" in account (694), 13 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2012-11-28 11:05:58.215 (4) [P1T1]: Returning Object to Pool 2012-11-28 11:05:58.215 (4) [P1T1]: Returning Object to Pool 2012-11-28 11:05:58.215 (4) [P1T1]: Returning Object to Pool 2012-11-28 11:05:58.215 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-11-28 11:05:58.216 (3) [main]: ------------Search Engine Summarizer done 2012-11-28 11:05:58.216 (3) [main]: =============== Completed Search Engine Summarizer ================