DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:0.00016403198242188 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00096297264099121 / seconds
host not found setting manual db connection
loadtime:0.0013611316680908 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0016369819641113 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0018351078033447 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0018889904022217 / seconds
zipcode:
loadtime:0.0019071102142334 / seconds
Query Executed:select * from search_referrer where page_hash='89b307c6b539a614f54ba9cc389fb778' limit 10 DB:ezrox_toadli
loadtime:0.00211501121521 / seconds
Operation header executed (non global)
loadtime:0.0021331310272217 / seconds
Operation leaderboard executed (non global)
loadtime:0.0021750926971436 / seconds
Operation square executed (non global)
loadtime:0.0021891593933105 / seconds
Operation square_bottom executed (non global)
loadtime:0.0022010803222656 / seconds
Operation smallsquare executed (non global)
loadtime:0.0022130012512207 / seconds
Operation headeradright executed (non global)
loadtime:0.0022239685058594 / seconds
Operation google_analytics executed (non global)
loadtime:0.0022339820861816 / seconds
Operation topstories executed (non global)
loadtime:0.0022461414337158 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0022571086883545 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0022850036621094 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0025150775909424 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0026650428771973 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0027070045471191 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0027740001678467 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0028209686279297 / seconds
Template key: archive_menu pushed
loadtime:0.0028259754180908 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0028321743011475 / seconds
Template key: get_gravatar pushed
loadtime:0.0028359889984131 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0028400421142578 / seconds
*10)-10)+1 | start:0
loadtime:0.0028631687164307 / seconds
Query loaded from cache:select * from categories where cat_URLid='cable-and-other-pay-television-services'
loadtime:0.0028951168060303 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-hampshire'
loadtime:0.0029220581054688 / seconds
DB connected to localhost business_master_new
loadtime:0.0031750202178955 / seconds
Query Executed:select * from `nh_catmap` where sic='4841' order by city ascDB:business_master_new
loadtime:0.2562689781189 / seconds
Query stored in cache : _QUERY_www.toadli.com539c22c594f271b1e10ccc740aba6088
loadtime:0.25767397880554 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-hampshire'
loadtime:0.25770807266235 / seconds
Query Executed:select sum(totalcount) as totalsum from `nh_catmap` where sic='4841'DB:business_master_new
loadtime:0.26154708862305 / seconds
Query stored in cache : _QUERY_www.toadli.com95fe5c4f8f704da97819b991f0298c4a
loadtime:0.2616491317749 / seconds
309 / 11
loadtime:0.26173496246338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acworth' limit 1
loadtime:0.26183605194092 / seconds
Query Executed:select id FROM `nh` where city='Acworth' && SIC_code='4841'DB:business_master_new
loadtime:0.26368713378906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albany' limit 1
loadtime:0.26373600959778 / seconds
Query Executed:select id FROM `nh` where city='Albany' && SIC_code='4841'DB:business_master_new
loadtime:0.26749706268311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexandria' limit 1
loadtime:0.26753902435303 / seconds
Query Executed:select id FROM `nh` where city='Alexandria' && SIC_code='4841'DB:business_master_new
loadtime:0.26982808113098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allenstown' limit 1
loadtime:0.26986908912659 / seconds
Query Executed:select id FROM `nh` where city='Allenstown' && SIC_code='4841'DB:business_master_new
loadtime:0.27565717697144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alstead' limit 1
loadtime:0.27574706077576 / seconds
Query Executed:select id FROM `nh` where city='Alstead' && SIC_code='4841'DB:business_master_new
loadtime:0.32225918769836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.32232308387756 / seconds
Query Executed:select id FROM `nh` where city='Alton' && SIC_code='4841'DB:business_master_new
loadtime:0.32290410995483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton Bay' limit 1
loadtime:0.32296204566956 / seconds
Query Executed:select id FROM `nh` where city='Alton Bay' && SIC_code='4841'DB:business_master_new
loadtime:0.32384896278381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.32395505905151 / seconds
Query Executed:select id FROM `nh` where city='Amherst' && SIC_code='4841'DB:business_master_new
loadtime:0.32468700408936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.32472205162048 / seconds
Query Executed:select id FROM `nh` where city='Andover' && SIC_code='4841'DB:business_master_new
loadtime:0.32534909248352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Antrim' limit 1
loadtime:0.32538199424744 / seconds
Query Executed:select id FROM `nh` where city='Antrim' && SIC_code='4841'DB:business_master_new
loadtime:0.32604312896729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.32617807388306 / seconds
Query Executed:select id FROM `nh` where city='Ashland' && SIC_code='4841'DB:business_master_new
loadtime:0.3270320892334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashuelot' limit 1
loadtime:0.32708096504211 / seconds
Query Executed:select id FROM `nh` where city='Ashuelot' && SIC_code='4841'DB:business_master_new
loadtime:0.33300995826721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atkinson' limit 1
loadtime:0.33306002616882 / seconds
Query Executed:select id FROM `nh` where city='Atkinson' && SIC_code='4841'DB:business_master_new
loadtime:0.3336181640625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.33365702629089 / seconds
Query Executed:select id FROM `nh` where city='Auburn' && SIC_code='4841'DB:business_master_new
loadtime:0.33418607711792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnstead' limit 1
loadtime:0.33424305915833 / seconds
Query Executed:select id FROM `nh` where city='Barnstead' && SIC_code='4841'DB:business_master_new
loadtime:0.33483099937439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barrington' limit 1
loadtime:0.33488011360168 / seconds
Query Executed:select id FROM `nh` where city='Barrington' && SIC_code='4841'DB:business_master_new
loadtime:0.33576917648315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bartlett' limit 1
loadtime:0.33581209182739 / seconds
Query Executed:select id FROM `nh` where city='Bartlett' && SIC_code='4841'DB:business_master_new
loadtime:0.33659315109253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.33669400215149 / seconds
Query Executed:select id FROM `nh` where city='Bath' && SIC_code='4841'DB:business_master_new
loadtime:0.33715105056763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.33724117279053 / seconds
Query Executed:select id FROM `nh` where city='Bedford' && SIC_code='4841'DB:business_master_new
loadtime:0.33838295936584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.3384690284729 / seconds
Query Executed:select id FROM `nh` where city='Belmont' && SIC_code='4841'DB:business_master_new
loadtime:0.33952212333679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennington' limit 1
loadtime:0.33967518806458 / seconds
Query Executed:select id FROM `nh` where city='Bennington' && SIC_code='4841'DB:business_master_new
loadtime:0.34017515182495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benton' limit 1
loadtime:0.34028196334839 / seconds
Query Executed:select id FROM `nh` where city='Benton' && SIC_code='4841'DB:business_master_new
loadtime:0.34101319313049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.34112310409546 / seconds
Query Executed:select id FROM `nh` where city='Berlin' && SIC_code='4841'DB:business_master_new
loadtime:0.34202218055725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethlehem' limit 1
loadtime:0.34219312667847 / seconds
Query Executed:select id FROM `nh` where city='Bethlehem' && SIC_code='4841'DB:business_master_new
loadtime:0.34338617324829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boscawen' limit 1
loadtime:0.34345698356628 / seconds
Query Executed:select id FROM `nh` where city='Boscawen' && SIC_code='4841'DB:business_master_new
loadtime:0.34651017189026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bow' limit 1
loadtime:0.34656405448914 / seconds
Query Executed:select id FROM `nh` where city='Bow' && SIC_code='4841'DB:business_master_new
loadtime:0.34713912010193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.34719204902649 / seconds
Query Executed:select id FROM `nh` where city='Bradford' && SIC_code='4841'DB:business_master_new
loadtime:0.34776401519775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brentwood' limit 1
loadtime:0.34781408309937 / seconds
Query Executed:select id FROM `nh` where city='Brentwood' && SIC_code='4841'DB:business_master_new
loadtime:0.35123300552368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bretton Woods' limit 1
loadtime:0.35130000114441 / seconds
Query Executed:select id FROM `nh` where city='Bretton Woods' && SIC_code='4841'DB:business_master_new
loadtime:0.35540819168091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.35546016693115 / seconds
Query Executed:select id FROM `nh` where city='Bristol' && SIC_code='4841'DB:business_master_new
loadtime:0.35603404045105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.35608506202698 / seconds
Query Executed:select id FROM `nh` where city='Brookfield' && SIC_code='4841'DB:business_master_new
loadtime:0.35679411888123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline' limit 1
loadtime:0.35683512687683 / seconds
Query Executed:select id FROM `nh` where city='Brookline' && SIC_code='4841'DB:business_master_new
loadtime:0.35737299919128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Campton' limit 1
loadtime:0.35741901397705 / seconds
Query Executed:select id FROM `nh` where city='Campton' && SIC_code='4841'DB:business_master_new
loadtime:0.35798096656799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canaan' limit 1
loadtime:0.35803413391113 / seconds
Query Executed:select id FROM `nh` where city='Canaan' && SIC_code='4841'DB:business_master_new
loadtime:0.35859513282776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Candia' limit 1
loadtime:0.35865211486816 / seconds
Query Executed:select id FROM `nh` where city='Candia' && SIC_code='4841'DB:business_master_new
loadtime:0.35919213294983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canterbury' limit 1
loadtime:0.35923409461975 / seconds
Query Executed:select id FROM `nh` where city='Canterbury' && SIC_code='4841'DB:business_master_new
loadtime:0.35976409912109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carroll' limit 1
loadtime:0.35981917381287 / seconds
Query Executed:select id FROM `nh` where city='Carroll' && SIC_code='4841'DB:business_master_new
loadtime:0.36121416091919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Barnstead' limit 1
loadtime:0.36127710342407 / seconds
Query Executed:select id FROM `nh` where city='Center Barnstead' && SIC_code='4841'DB:business_master_new
loadtime:0.36162114143372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Conway' limit 1
loadtime:0.36165404319763 / seconds
Query Executed:select id FROM `nh` where city='Center Conway' && SIC_code='4841'DB:business_master_new
loadtime:0.36221599578857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Harbor' limit 1
loadtime:0.36227798461914 / seconds
Query Executed:select id FROM `nh` where city='Center Harbor' && SIC_code='4841'DB:business_master_new
loadtime:0.36283397674561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Ossipee' limit 1
loadtime:0.36287713050842 / seconds
Query Executed:select id FROM `nh` where city='Center Ossipee' && SIC_code='4841'DB:business_master_new
loadtime:0.36340999603271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Sandwich' limit 1
loadtime:0.36345314979553 / seconds
Query Executed:select id FROM `nh` where city='Center Sandwich' && SIC_code='4841'DB:business_master_new
loadtime:0.36382102966309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Strafford' limit 1
loadtime:0.36386299133301 / seconds
Query Executed:select id FROM `nh` where city='Center Strafford' && SIC_code='4841'DB:business_master_new
loadtime:0.36416602134705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Tuftonboro' limit 1
loadtime:0.36420512199402 / seconds
Query Executed:select id FROM `nh` where city='Center Tuftonboro' && SIC_code='4841'DB:business_master_new
loadtime:0.36454296112061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlestown' limit 1
loadtime:0.3645920753479 / seconds
Query Executed:select id FROM `nh` where city='Charlestown' && SIC_code='4841'DB:business_master_new
loadtime:0.36513996124268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:0.36519503593445 / seconds
Query Executed:select id FROM `nh` where city='Chatham' && SIC_code='4841'DB:business_master_new
loadtime:0.36667799949646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.3667299747467 / seconds
Query Executed:select id FROM `nh` where city='Chester' && SIC_code='4841'DB:business_master_new
loadtime:0.36729717254639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:0.36734509468079 / seconds
Query Executed:select id FROM `nh` where city='Chesterfield' && SIC_code='4841'DB:business_master_new
loadtime:0.36772918701172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chichester' limit 1
loadtime:0.36777114868164 / seconds
Query Executed:select id FROM `nh` where city='Chichester' && SIC_code='4841'DB:business_master_new
loadtime:0.36830401420593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chocorua' limit 1
loadtime:0.36834502220154 / seconds
Query Executed:select id FROM `nh` where city='Chocorua' && SIC_code='4841'DB:business_master_new
loadtime:0.36867499351501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:0.36872410774231 / seconds
Query Executed:select id FROM `nh` where city='Claremont' && SIC_code='4841'DB:business_master_new
loadtime:0.36927103996277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksville' limit 1
loadtime:0.36931419372559 / seconds
Query Executed:select id FROM `nh` where city='Clarksville' && SIC_code='4841'DB:business_master_new
loadtime:0.36997008323669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colebrook' limit 1
loadtime:0.3700110912323 / seconds
Query Executed:select id FROM `nh` where city='Colebrook' && SIC_code='4841'DB:business_master_new
loadtime:0.37058711051941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.37064409255981 / seconds
Query Executed:select id FROM `nh` where city='Concord' && SIC_code='4841'DB:business_master_new
loadtime:0.3711941242218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Contoocook' limit 1
loadtime:0.37125015258789 / seconds
Query Executed:select id FROM `nh` where city='Contoocook' && SIC_code='4841'DB:business_master_new
loadtime:0.37180519104004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.37184810638428 / seconds
Query Executed:select id FROM `nh` where city='Conway' && SIC_code='4841'DB:business_master_new
loadtime:0.37237405776978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornish' limit 1
loadtime:0.37241506576538 / seconds
Query Executed:select id FROM `nh` where city='Cornish' && SIC_code='4841'DB:business_master_new
loadtime:0.37275004386902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornish Flat' limit 1
loadtime:0.37279415130615 / seconds
Query Executed:select id FROM `nh` where city='Cornish Flat' && SIC_code='4841'DB:business_master_new
loadtime:0.37830018997192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Croydon' limit 1
loadtime:0.37834000587463 / seconds
Query Executed:select id FROM `nh` where city='Croydon' && SIC_code='4841'DB:business_master_new
loadtime:0.37904500961304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ctr Tuftonboro' limit 1
loadtime:0.37909412384033 / seconds
Query Executed:select id FROM `nh` where city='Ctr Tuftonboro' && SIC_code='4841'DB:business_master_new
loadtime:0.37934398651123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dalton' limit 1
loadtime:0.3793830871582 / seconds
Query Executed:select id FROM `nh` where city='Dalton' && SIC_code='4841'DB:business_master_new
loadtime:0.37991619110107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:0.37996411323547 / seconds
Query Executed:select id FROM `nh` where city='Danbury' && SIC_code='4841'DB:business_master_new
loadtime:0.38030505180359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.38035416603088 / seconds
Query Executed:select id FROM `nh` where city='Danville' && SIC_code='4841'DB:business_master_new
loadtime:0.38071513175964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:0.38075613975525 / seconds
Query Executed:select id FROM `nh` where city='Deerfield' && SIC_code='4841'DB:business_master_new
loadtime:0.38129210472107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deering' limit 1
loadtime:0.38131809234619 / seconds
Query Executed:select id FROM `nh` where city='Deering' && SIC_code='4841'DB:business_master_new
loadtime:0.38337016105652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derry' limit 1
loadtime:0.38341999053955 / seconds
Query Executed:select id FROM `nh` where city='Derry' && SIC_code='4841'DB:business_master_new
loadtime:0.38397908210754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:0.38403010368347 / seconds
Query Executed:select id FROM `nh` where city='Dorchester' && SIC_code='4841'DB:business_master_new
loadtime:0.38427495956421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dover' limit 1
loadtime:0.38431596755981 / seconds
Query Executed:select id FROM `nh` where city='Dover' && SIC_code='4841'DB:business_master_new
loadtime:0.38485097885132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drewsville' limit 1
loadtime:0.38490509986877 / seconds
Query Executed:select id FROM `nh` where city='Drewsville' && SIC_code='4841'DB:business_master_new
loadtime:0.38612508773804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dublin' limit 1
loadtime:0.38617300987244 / seconds
Query Executed:select id FROM `nh` where city='Dublin' && SIC_code='4841'DB:business_master_new
loadtime:0.38650608062744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dummer' limit 1
loadtime:0.38653302192688 / seconds
Query Executed:select id FROM `nh` where city='Dummer' && SIC_code='4841'DB:business_master_new
loadtime:0.38755702972412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunbarton' limit 1
loadtime:0.38760709762573 / seconds
Query Executed:select id FROM `nh` where city='Dunbarton' && SIC_code='4841'DB:business_master_new
loadtime:0.38797497749329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durham' limit 1
loadtime:0.3880250453949 / seconds
Query Executed:select id FROM `nh` where city='Durham' && SIC_code='4841'DB:business_master_new
loadtime:0.38858509063721 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Andover' limit 1
loadtime:0.38863515853882 / seconds
Query Executed:select id FROM `nh` where city='East Andover' && SIC_code='4841'DB:business_master_new
loadtime:0.39387202262878 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Candia' limit 1
loadtime:0.39391303062439 / seconds
Query Executed:select id FROM `nh` where city='East Candia' && SIC_code='4841'DB:business_master_new
loadtime:0.39416813850403 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Derry' limit 1
loadtime:0.39420914649963 / seconds
Query Executed:select id FROM `nh` where city='East Derry' && SIC_code='4841'DB:business_master_new
loadtime:0.39457702636719 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hampstead' limit 1
loadtime:0.39463305473328 / seconds
Query Executed:select id FROM `nh` where city='East Hampstead' && SIC_code='4841'DB:business_master_new
loadtime:0.39518618583679 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hebron' limit 1
loadtime:0.3952271938324 / seconds
Query Executed:select id FROM `nh` where city='East Hebron' && SIC_code='4841'DB:business_master_new
loadtime:0.39582896232605 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Kingston' limit 1
loadtime:0.39587998390198 / seconds
Query Executed:select id FROM `nh` where city='East Kingston' && SIC_code='4841'DB:business_master_new
loadtime:0.39641618728638 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Swanzey' limit 1
loadtime:0.39644813537598 / seconds
Query Executed:select id FROM `nh` where city='East Swanzey' && SIC_code='4841'DB:business_master_new
loadtime:0.39669609069824 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Wakefield' limit 1
loadtime:0.39673614501953 / seconds
Query Executed:select id FROM `nh` where city='East Wakefield' && SIC_code='4841'DB:business_master_new
loadtime:0.39706301689148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eaton Center' limit 1
loadtime:0.39709496498108 / seconds
Query Executed:select id FROM `nh` where city='Eaton Center' && SIC_code='4841'DB:business_master_new
loadtime:0.39741516113281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Effingham' limit 1
loadtime:0.39744997024536 / seconds
Query Executed:select id FROM `nh` where city='Effingham' && SIC_code='4841'DB:business_master_new
loadtime:0.39781212806702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkins' limit 1
loadtime:0.39785718917847 / seconds
Query Executed:select id FROM `nh` where city='Elkins' && SIC_code='4841'DB:business_master_new
loadtime:0.39816308021545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth' limit 1
loadtime:0.39819812774658 / seconds
Query Executed:select id FROM `nh` where city='Ellsworth' && SIC_code='4841'DB:business_master_new
loadtime:0.3984260559082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enfield' limit 1
loadtime:0.39846801757812 / seconds
Query Executed:select id FROM `nh` where city='Enfield' && SIC_code='4841'DB:business_master_new
loadtime:0.39900517463684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enfield Center' limit 1
loadtime:0.39903998374939 / seconds
Query Executed:select id FROM `nh` where city='Enfield Center' && SIC_code='4841'DB:business_master_new
loadtime:0.4019181728363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Epping' limit 1
loadtime:0.4019660949707 / seconds
Query Executed:select id FROM `nh` where city='Epping' && SIC_code='4841'DB:business_master_new
loadtime:0.40249705314636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Epsom' limit 1
loadtime:0.4025251865387 / seconds
Query Executed:select id FROM `nh` where city='Epsom' && SIC_code='4841'DB:business_master_new
loadtime:0.40306615829468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Errol' limit 1
loadtime:0.40312314033508 / seconds
Query Executed:select id FROM `nh` where city='Errol' && SIC_code='4841'DB:business_master_new
loadtime:0.40344715118408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Etna' limit 1
loadtime:0.40348410606384 / seconds
Query Executed:select id FROM `nh` where city='Etna' && SIC_code='4841'DB:business_master_new
loadtime:0.40382504463196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exeter' limit 1
loadtime:0.40387010574341 / seconds
Query Executed:select id FROM `nh` where city='Exeter' && SIC_code='4841'DB:business_master_new
loadtime:0.40440702438354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.4044451713562 / seconds
Query Executed:select id FROM `nh` where city='Farmington' && SIC_code='4841'DB:business_master_new
loadtime:0.40498208999634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fitzwilliam' limit 1
loadtime:0.40502214431763 / seconds
Query Executed:select id FROM `nh` where city='Fitzwilliam' && SIC_code='4841'DB:business_master_new
loadtime:0.40535807609558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Francestown' limit 1
loadtime:0.40539813041687 / seconds
Query Executed:select id FROM `nh` where city='Francestown' && SIC_code='4841'DB:business_master_new
loadtime:0.40577006340027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franconia' limit 1
loadtime:0.4058051109314 / seconds
Query Executed:select id FROM `nh` where city='Franconia' && SIC_code='4841'DB:business_master_new
loadtime:0.40632510185242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.40636897087097 / seconds
Query Executed:select id FROM `nh` where city='Franklin' && SIC_code='4841'DB:business_master_new
loadtime:0.40690207481384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freedom' limit 1
loadtime:0.40694499015808 / seconds
Query Executed:select id FROM `nh` where city='Freedom' && SIC_code='4841'DB:business_master_new
loadtime:0.40726017951965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fremont' limit 1
loadtime:0.40730905532837 / seconds
Query Executed:select id FROM `nh` where city='Fremont' && SIC_code='4841'DB:business_master_new
loadtime:0.4078471660614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georges Mills' limit 1
loadtime:0.40789318084717 / seconds
Query Executed:select id FROM `nh` where city='Georges Mills' && SIC_code='4841'DB:business_master_new
loadtime:0.40822100639343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilford' limit 1
loadtime:0.40825796127319 / seconds
Query Executed:select id FROM `nh` where city='Gilford' && SIC_code='4841'DB:business_master_new
loadtime:0.40880918502808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilmanton' limit 1
loadtime:0.40884900093079 / seconds
Query Executed:select id FROM `nh` where city='Gilmanton' && SIC_code='4841'DB:business_master_new
loadtime:0.40918302536011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilmanton Iron Works' limit 1
loadtime:0.40922403335571 / seconds
Query Executed:select id FROM `nh` where city='Gilmanton Iron Works' && SIC_code='4841'DB:business_master_new
loadtime:0.40956211090088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilsum' limit 1
loadtime:0.40961313247681 / seconds
Query Executed:select id FROM `nh` where city='Gilsum' && SIC_code='4841'DB:business_master_new
loadtime:0.40993118286133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen' limit 1
loadtime:0.40997409820557 / seconds
Query Executed:select id FROM `nh` where city='Glen' && SIC_code='4841'DB:business_master_new
loadtime:0.41029715538025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glencliff' limit 1
loadtime:0.41032218933105 / seconds
Query Executed:select id FROM `nh` where city='Glencliff' && SIC_code='4841'DB:business_master_new
loadtime:0.4121150970459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glmntn Iron Wks' limit 1
loadtime:0.41216516494751 / seconds
Query Executed:select id FROM `nh` where city='Glmntn Iron Wks' && SIC_code='4841'DB:business_master_new
loadtime:0.41325902938843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goffstown' limit 1
loadtime:0.41331005096436 / seconds
Query Executed:select id FROM `nh` where city='Goffstown' && SIC_code='4841'DB:business_master_new
loadtime:0.41386198997498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gorham' limit 1
loadtime:0.41391205787659 / seconds
Query Executed:select id FROM `nh` where city='Gorham' && SIC_code='4841'DB:business_master_new
loadtime:0.4144401550293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.41447710990906 / seconds
Query Executed:select id FROM `nh` where city='Goshen' && SIC_code='4841'DB:business_master_new
loadtime:0.41482400894165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.4148690700531 / seconds
Query Executed:select id FROM `nh` where city='Grafton' && SIC_code='4841'DB:business_master_new
loadtime:0.4151771068573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grantham' limit 1
loadtime:0.41521716117859 / seconds
Query Executed:select id FROM `nh` where city='Grantham' && SIC_code='4841'DB:business_master_new
loadtime:0.41576504707336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenfield' limit 1
loadtime:0.41581702232361 / seconds
Query Executed:select id FROM `nh` where city='Greenfield' && SIC_code='4841'DB:business_master_new
loadtime:0.41614699363708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenland' limit 1
loadtime:0.41618609428406 / seconds
Query Executed:select id FROM `nh` where city='Greenland' && SIC_code='4841'DB:business_master_new
loadtime:0.41674518585205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.41679406166077 / seconds
Query Executed:select id FROM `nh` where city='Greenville' && SIC_code='4841'DB:business_master_new
loadtime:0.41731905937195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groveton' limit 1
loadtime:0.41735100746155 / seconds
Query Executed:select id FROM `nh` where city='Groveton' && SIC_code='4841'DB:business_master_new
loadtime:0.41771697998047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guild' limit 1
loadtime:0.41776514053345 / seconds
Query Executed:select id FROM `nh` where city='Guild' && SIC_code='4841'DB:business_master_new
loadtime:0.42298102378845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hales Location' limit 1
loadtime:0.42302298545837 / seconds
Query Executed:select id FROM `nh` where city='Hales Location' && SIC_code='4841'DB:business_master_new
loadtime:0.42324304580688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampstead' limit 1
loadtime:0.42329406738281 / seconds
Query Executed:select id FROM `nh` where city='Hampstead' && SIC_code='4841'DB:business_master_new
loadtime:0.42382907867432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:0.42386412620544 / seconds
Query Executed:select id FROM `nh` where city='Hampton' && SIC_code='4841'DB:business_master_new
loadtime:0.42439007759094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton Falls' limit 1
loadtime:0.42443919181824 / seconds
Query Executed:select id FROM `nh` where city='Hampton Falls' && SIC_code='4841'DB:business_master_new
loadtime:0.42498111724854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:0.42503309249878 / seconds
Query Executed:select id FROM `nh` where city='Hancock' && SIC_code='4841'DB:business_master_new
loadtime:0.42536616325378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.42540502548218 / seconds
Query Executed:select id FROM `nh` where city='Hanover' && SIC_code='4841'DB:business_master_new
loadtime:0.4259660243988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisville' limit 1
loadtime:0.42601203918457 / seconds
Query Executed:select id FROM `nh` where city='Harrisville' && SIC_code='4841'DB:business_master_new
loadtime:0.42635798454285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harts Location' limit 1
loadtime:0.42639017105103 / seconds
Query Executed:select id FROM `nh` where city='Harts Location' && SIC_code='4841'DB:business_master_new
loadtime:0.42784309387207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haverhill' limit 1
loadtime:0.42789006233215 / seconds
Query Executed:select id FROM `nh` where city='Haverhill' && SIC_code='4841'DB:business_master_new
loadtime:0.42819809913635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hebron' limit 1
loadtime:0.4282341003418 / seconds
Query Executed:select id FROM `nh` where city='Hebron' && SIC_code='4841'DB:business_master_new
loadtime:0.42857098579407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henniker' limit 1
loadtime:0.42861914634705 / seconds
Query Executed:select id FROM `nh` where city='Henniker' && SIC_code='4841'DB:business_master_new
loadtime:0.42915797233582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hill' limit 1
loadtime:0.42920303344727 / seconds
Query Executed:select id FROM `nh` where city='Hill' && SIC_code='4841'DB:business_master_new
loadtime:0.42955017089844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:0.429612159729 / seconds
Query Executed:select id FROM `nh` where city='Hillsboro' && SIC_code='4841'DB:business_master_new
loadtime:0.42993211746216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsborough' limit 1
loadtime:0.42997097969055 / seconds
Query Executed:select id FROM `nh` where city='Hillsborough' && SIC_code='4841'DB:business_master_new
loadtime:0.43049216270447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinsdale' limit 1
loadtime:0.43051815032959 / seconds
Query Executed:select id FROM `nh` where city='Hinsdale' && SIC_code='4841'DB:business_master_new
loadtime:0.43089699745178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holderness' limit 1
loadtime:0.43095397949219 / seconds
Query Executed:select id FROM `nh` where city='Holderness' && SIC_code='4841'DB:business_master_new
loadtime:0.43128108978271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollis' limit 1
loadtime:0.43132019042969 / seconds
Query Executed:select id FROM `nh` where city='Hollis' && SIC_code='4841'DB:business_master_new
loadtime:0.4318630695343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hooksett' limit 1
loadtime:0.43189811706543 / seconds
Query Executed:select id FROM `nh` where city='Hooksett' && SIC_code='4841'DB:business_master_new
loadtime:0.43242216110229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkinton' limit 1
loadtime:0.43246412277222 / seconds
Query Executed:select id FROM `nh` where city='Hopkinton' && SIC_code='4841'DB:business_master_new
loadtime:0.43714213371277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:0.43718910217285 / seconds
Query Executed:select id FROM `nh` where city='Hudson' && SIC_code='4841'DB:business_master_new
loadtime:0.43777012825012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Intervale' limit 1
loadtime:0.43780517578125 / seconds
Query Executed:select id FROM `nh` where city='Intervale' && SIC_code='4841'DB:business_master_new
loadtime:0.4381639957428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:0.4382061958313 / seconds
Query Executed:select id FROM `nh` where city='Jackson' && SIC_code='4841'DB:business_master_new
loadtime:0.43857717514038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jaffrey' limit 1
loadtime:0.43863296508789 / seconds
Query Executed:select id FROM `nh` where city='Jaffrey' && SIC_code='4841'DB:business_master_new
loadtime:0.43918704986572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:0.43923401832581 / seconds
Query Executed:select id FROM `nh` where city='Jefferson' && SIC_code='4841'DB:business_master_new
loadtime:0.43960905075073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kearsarge' limit 1
loadtime:0.43964815139771 / seconds
Query Executed:select id FROM `nh` where city='Kearsarge' && SIC_code='4841'DB:business_master_new
loadtime:0.44298696517944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keene' limit 1
loadtime:0.44303512573242 / seconds
Query Executed:select id FROM `nh` where city='Keene' && SIC_code='4841'DB:business_master_new
loadtime:0.44360017776489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kensington' limit 1
loadtime:0.4436559677124 / seconds
Query Executed:select id FROM `nh` where city='Kensington' && SIC_code='4841'DB:business_master_new
loadtime:0.44415998458862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:0.44420599937439 / seconds
Query Executed:select id FROM `nh` where city='Kingston' && SIC_code='4841'DB:business_master_new
loadtime:0.44476819038391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laconia' limit 1
loadtime:0.44481706619263 / seconds
Query Executed:select id FROM `nh` where city='Laconia' && SIC_code='4841'DB:business_master_new
loadtime:0.44535398483276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:0.44540405273438 / seconds
Query Executed:select id FROM `nh` where city='Lancaster' && SIC_code='4841'DB:business_master_new
loadtime:0.44596409797668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Landaff' limit 1
loadtime:0.44601011276245 / seconds
Query Executed:select id FROM `nh` where city='Landaff' && SIC_code='4841'DB:business_master_new
loadtime:0.44667506217957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langdon' limit 1
loadtime:0.44672513008118 / seconds
Query Executed:select id FROM `nh` where city='Langdon' && SIC_code='4841'DB:business_master_new
loadtime:0.44847512245178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:0.44852304458618 / seconds
Query Executed:select id FROM `nh` where city='Lebanon' && SIC_code='4841'DB:business_master_new
loadtime:0.44906115531921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lee' limit 1
loadtime:0.44910597801208 / seconds
Query Executed:select id FROM `nh` where city='Lee' && SIC_code='4841'DB:business_master_new
loadtime:0.44942903518677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lempster' limit 1
loadtime:0.44946098327637 / seconds
Query Executed:select id FROM `nh` where city='Lempster' && SIC_code='4841'DB:business_master_new
loadtime:0.44980406761169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.44985604286194 / seconds
Query Executed:select id FROM `nh` where city='Lincoln' && SIC_code='4841'DB:business_master_new
loadtime:0.4503800868988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lisbon' limit 1
loadtime:0.45042109489441 / seconds
Query Executed:select id FROM `nh` where city='Lisbon' && SIC_code='4841'DB:business_master_new
loadtime:0.45076417922974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield' limit 1
loadtime:0.45079898834229 / seconds
Query Executed:select id FROM `nh` where city='Litchfield' && SIC_code='4841'DB:business_master_new
loadtime:0.45130896568298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littleton' limit 1
loadtime:0.45134997367859 / seconds
Query Executed:select id FROM `nh` where city='Littleton' && SIC_code='4841'DB:business_master_new
loadtime:0.45189213752747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lochmere' limit 1
loadtime:0.45194816589355 / seconds
Query Executed:select id FROM `nh` where city='Lochmere' && SIC_code='4841'DB:business_master_new
loadtime:0.45559310913086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Londonderry' limit 1
loadtime:0.45564413070679 / seconds
Query Executed:select id FROM `nh` where city='Londonderry' && SIC_code='4841'DB:business_master_new
loadtime:0.45618605613708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loudon' limit 1
loadtime:0.45622897148132 / seconds
Query Executed:select id FROM `nh` where city='Loudon' && SIC_code='4841'DB:business_master_new
loadtime:0.45676803588867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyman' limit 1
loadtime:0.45681715011597 / seconds
Query Executed:select id FROM `nh` where city='Lyman' && SIC_code='4841'DB:business_master_new
loadtime:0.45703911781311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyme' limit 1
loadtime:0.45707416534424 / seconds
Query Executed:select id FROM `nh` where city='Lyme' && SIC_code='4841'DB:business_master_new
loadtime:0.45741105079651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyme Center' limit 1
loadtime:0.457444190979 / seconds
Query Executed:select id FROM `nh` where city='Lyme Center' && SIC_code='4841'DB:business_master_new
loadtime:0.45902895927429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndeborough' limit 1
loadtime:0.45908212661743 / seconds
Query Executed:select id FROM `nh` where city='Lyndeborough' && SIC_code='4841'DB:business_master_new
loadtime:0.45941209793091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madbury' limit 1
loadtime:0.45944905281067 / seconds
Query Executed:select id FROM `nh` where city='Madbury' && SIC_code='4841'DB:business_master_new
loadtime:0.45978713035583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.45983409881592 / seconds
Query Executed:select id FROM `nh` where city='Madison' && SIC_code='4841'DB:business_master_new
loadtime:0.46018004417419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.46021604537964 / seconds
Query Executed:select id FROM `nh` where city='Manchester' && SIC_code='4841'DB:business_master_new
loadtime:0.46077704429626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlborough' limit 1
loadtime:0.46082210540771 / seconds
Query Executed:select id FROM `nh` where city='Marlborough' && SIC_code='4841'DB:business_master_new
loadtime:0.46118903160095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlow' limit 1
loadtime:0.46123504638672 / seconds
Query Executed:select id FROM `nh` where city='Marlow' && SIC_code='4841'DB:business_master_new
loadtime:0.46158599853516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mason' limit 1
loadtime:0.46163511276245 / seconds
Query Executed:select id FROM `nh` where city='Mason' && SIC_code='4841'DB:business_master_new
loadtime:0.46336603164673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadows' limit 1
loadtime:0.46341896057129 / seconds
Query Executed:select id FROM `nh` where city='Meadows' && SIC_code='4841'DB:business_master_new
loadtime:0.46364498138428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melvin Village' limit 1
loadtime:0.46367216110229 / seconds
Query Executed:select id FROM `nh` where city='Melvin Village' && SIC_code='4841'DB:business_master_new
loadtime:0.46398901939392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meredith' limit 1
loadtime:0.46402096748352 / seconds
Query Executed:select id FROM `nh` where city='Meredith' && SIC_code='4841'DB:business_master_new
loadtime:0.46458697319031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meriden' limit 1
loadtime:0.46463108062744 / seconds
Query Executed:select id FROM `nh` where city='Meriden' && SIC_code='4841'DB:business_master_new
loadtime:0.46496295928955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrimack' limit 1
loadtime:0.46500301361084 / seconds
Query Executed:select id FROM `nh` where city='Merrimack' && SIC_code='4841'DB:business_master_new
loadtime:0.46556496620178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleton' limit 1
loadtime:0.46561598777771 / seconds
Query Executed:select id FROM `nh` where city='Middleton' && SIC_code='4841'DB:business_master_new
loadtime:0.4672269821167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milan' limit 1
loadtime:0.46728706359863 / seconds
Query Executed:select id FROM `nh` where city='Milan' && SIC_code='4841'DB:business_master_new
loadtime:0.46762013435364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:0.46765899658203 / seconds
Query Executed:select id FROM `nh` where city='Milford' && SIC_code='4841'DB:business_master_new
loadtime:0.46818399429321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:0.46821904182434 / seconds
Query Executed:select id FROM `nh` where city='Milton' && SIC_code='4841'DB:business_master_new
loadtime:0.46858596801758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton Mills' limit 1
loadtime:0.46863603591919 / seconds
Query Executed:select id FROM `nh` where city='Milton Mills' && SIC_code='4841'DB:business_master_new
loadtime:0.47441816329956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mirror Lake' limit 1
loadtime:0.47446918487549 / seconds
Query Executed:select id FROM `nh` where city='Mirror Lake' && SIC_code='4841'DB:business_master_new
loadtime:0.47484016418457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.47488307952881 / seconds
Query Executed:select id FROM `nh` where city='Monroe' && SIC_code='4841'DB:business_master_new
loadtime:0.47519898414612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mont Vernon' limit 1
loadtime:0.47522497177124 / seconds
Query Executed:select id FROM `nh` where city='Mont Vernon' && SIC_code='4841'DB:business_master_new
loadtime:0.47558617591858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moultonborough' limit 1
loadtime:0.47563695907593 / seconds
Query Executed:select id FROM `nh` where city='Moultonborough' && SIC_code='4841'DB:business_master_new
loadtime:0.47618699073792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Sunapee' limit 1
loadtime:0.47622799873352 / seconds
Query Executed:select id FROM `nh` where city='Mt Sunapee' && SIC_code='4841'DB:business_master_new
loadtime:0.47676801681519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munsonville' limit 1
loadtime:0.47681713104248 / seconds
Query Executed:select id FROM `nh` where city='Munsonville' && SIC_code='4841'DB:business_master_new
loadtime:0.47975397109985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashua' limit 1
loadtime:0.47979402542114 / seconds
Query Executed:select id FROM `nh` where city='Nashua' && SIC_code='4841'DB:business_master_new
loadtime:0.48032402992249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelson' limit 1
loadtime:0.48036503791809 / seconds
Query Executed:select id FROM `nh` where city='Nelson' && SIC_code='4841'DB:business_master_new
loadtime:0.48544502258301 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Boston' limit 1
loadtime:0.48549509048462 / seconds
Query Executed:select id FROM `nh` where city='New Boston' && SIC_code='4841'DB:business_master_new
loadtime:0.48607611656189 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Castle' limit 1
loadtime:0.48612308502197 / seconds
Query Executed:select id FROM `nh` where city='New Castle' && SIC_code='4841'DB:business_master_new
loadtime:0.48648118972778 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Durham' limit 1
loadtime:0.48652315139771 / seconds
Query Executed:select id FROM `nh` where city='New Durham' && SIC_code='4841'DB:business_master_new
loadtime:0.48686909675598 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hampton' limit 1
loadtime:0.48690319061279 / seconds
Query Executed:select id FROM `nh` where city='New Hampton' && SIC_code='4841'DB:business_master_new
loadtime:0.48727917671204 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Ipswich' limit 1
loadtime:0.48732018470764 / seconds
Query Executed:select id FROM `nh` where city='New Ipswich' && SIC_code='4841'DB:business_master_new
loadtime:0.48786902427673 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:0.48791313171387 / seconds
Query Executed:select id FROM `nh` where city='New London' && SIC_code='4841'DB:business_master_new
loadtime:0.48844814300537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbury' limit 1
loadtime:0.48849415779114 / seconds
Query Executed:select id FROM `nh` where city='Newbury' && SIC_code='4841'DB:business_master_new
loadtime:0.48885798454285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newfields' limit 1
loadtime:0.48890399932861 / seconds
Query Executed:select id FROM `nh` where city='Newfields' && SIC_code='4841'DB:business_master_new
loadtime:0.48923110961914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newington' limit 1
loadtime:0.48925709724426 / seconds
Query Executed:select id FROM `nh` where city='Newington' && SIC_code='4841'DB:business_master_new
loadtime:0.49249696731567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newmarket' limit 1
loadtime:0.4925491809845 / seconds
Query Executed:select id FROM `nh` where city='Newmarket' && SIC_code='4841'DB:business_master_new
loadtime:0.49310398101807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:0.49314713478088 / seconds
Query Executed:select id FROM `nh` where city='Newport' && SIC_code='4841'DB:business_master_new
loadtime:0.49371910095215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:0.49377417564392 / seconds
Query Executed:select id FROM `nh` where city='Newton' && SIC_code='4841'DB:business_master_new
loadtime:0.49430704116821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Junction' limit 1
loadtime:0.49433898925781 / seconds
Query Executed:select id FROM `nh` where city='Newton Junction' && SIC_code='4841'DB:business_master_new
loadtime:0.4989321231842 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Conway' limit 1
loadtime:0.49898600578308 / seconds
Query Executed:select id FROM `nh` where city='North Conway' && SIC_code='4841'DB:business_master_new
loadtime:0.49957418441772 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hampton' limit 1
loadtime:0.4996280670166 / seconds
Query Executed:select id FROM `nh` where city='North Hampton' && SIC_code='4841'DB:business_master_new
loadtime:0.50017619132996 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Haverhill' limit 1
loadtime:0.5002110004425 / seconds
Query Executed:select id FROM `nh` where city='North Haverhill' && SIC_code='4841'DB:business_master_new
loadtime:0.5006000995636 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Salem' limit 1
loadtime:0.50064897537231 / seconds
Query Executed:select id FROM `nh` where city='North Salem' && SIC_code='4841'DB:business_master_new
loadtime:0.50101613998413 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Sandwich' limit 1
loadtime:0.501060962677 / seconds
Query Executed:select id FROM `nh` where city='North Sandwich' && SIC_code='4841'DB:business_master_new
loadtime:0.50137209892273 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Stratford' limit 1
loadtime:0.50141596794128 / seconds
Query Executed:select id FROM `nh` where city='North Stratford' && SIC_code='4841'DB:business_master_new
loadtime:0.50176310539246 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Sutton' limit 1
loadtime:0.50180315971375 / seconds
Query Executed:select id FROM `nh` where city='North Sutton' && SIC_code='4841'DB:business_master_new
loadtime:0.50213313102722 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Walpole' limit 1
loadtime:0.50216817855835 / seconds
Query Executed:select id FROM `nh` where city='North Walpole' && SIC_code='4841'DB:business_master_new
loadtime:0.50250101089478 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Woodstock' limit 1
loadtime:0.50253295898438 / seconds
Query Executed:select id FROM `nh` where city='North Woodstock' && SIC_code='4841'DB:business_master_new
loadtime:0.50287699699402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:0.502925157547 / seconds
Query Executed:select id FROM `nh` where city='Northfield' && SIC_code='4841'DB:business_master_new
loadtime:0.50408101081848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northwood' limit 1
loadtime:0.50412917137146 / seconds
Query Executed:select id FROM `nh` where city='Northwood' && SIC_code='4841'DB:business_master_new
loadtime:0.50471210479736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nottingham' limit 1
loadtime:0.50476098060608 / seconds
Query Executed:select id FROM `nh` where city='Nottingham' && SIC_code='4841'DB:business_master_new
loadtime:0.50512409210205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:0.50516700744629 / seconds
Query Executed:select id FROM `nh` where city='Orange' && SIC_code='4841'DB:business_master_new
loadtime:0.50541615486145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orford' limit 1
loadtime:0.50544214248657 / seconds
Query Executed:select id FROM `nh` where city='Orford' && SIC_code='4841'DB:business_master_new
loadtime:0.50581216812134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ossipee' limit 1
loadtime:0.50586414337158 / seconds
Query Executed:select id FROM `nh` where city='Ossipee' && SIC_code='4841'DB:business_master_new
loadtime:0.50639319419861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelham' limit 1
loadtime:0.50642108917236 / seconds
Query Executed:select id FROM `nh` where city='Pelham' && SIC_code='4841'DB:business_master_new
loadtime:0.50696802139282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:0.50702214241028 / seconds
Query Executed:select id FROM `nh` where city='Pembroke' && SIC_code='4841'DB:business_master_new
loadtime:0.51029300689697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penacook' limit 1
loadtime:0.51034212112427 / seconds
Query Executed:select id FROM `nh` where city='Penacook' && SIC_code='4841'DB:business_master_new
loadtime:0.51189303398132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peterborough' limit 1
loadtime:0.51194500923157 / seconds
Query Executed:select id FROM `nh` where city='Peterborough' && SIC_code='4841'DB:business_master_new
loadtime:0.51248002052307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piermont' limit 1
loadtime:0.51251411437988 / seconds
Query Executed:select id FROM `nh` where city='Piermont' && SIC_code='4841'DB:business_master_new
loadtime:0.51286816596985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pike' limit 1
loadtime:0.51291608810425 / seconds
Query Executed:select id FROM `nh` where city='Pike' && SIC_code='4841'DB:business_master_new
loadtime:0.51789617538452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsburg' limit 1
loadtime:0.51794910430908 / seconds
Query Executed:select id FROM `nh` where city='Pittsburg' && SIC_code='4841'DB:business_master_new
loadtime:0.51829099655151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsfield' limit 1
loadtime:0.51832914352417 / seconds
Query Executed:select id FROM `nh` where city='Pittsfield' && SIC_code='4841'DB:business_master_new
loadtime:0.51888298988342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:0.51892805099487 / seconds
Query Executed:select id FROM `nh` where city='Plainfield' && SIC_code='4841'DB:business_master_new
loadtime:0.51929116249084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plaistow' limit 1
loadtime:0.51932001113892 / seconds
Query Executed:select id FROM `nh` where city='Plaistow' && SIC_code='4841'DB:business_master_new
loadtime:0.5198609828949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.51990699768066 / seconds
Query Executed:select id FROM `nh` where city='Plymouth' && SIC_code='4841'DB:business_master_new
loadtime:0.52044701576233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portsmouth' limit 1
loadtime:0.52049398422241 / seconds
Query Executed:select id FROM `nh` where city='Portsmouth' && SIC_code='4841'DB:business_master_new
loadtime:0.52103400230408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:0.52108502388 / seconds
Query Executed:select id FROM `nh` where city='Randolph' && SIC_code='4841'DB:business_master_new
loadtime:0.52371597290039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:0.52376818656921 / seconds
Query Executed:select id FROM `nh` where city='Raymond' && SIC_code='4841'DB:business_master_new
loadtime:0.52429103851318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:0.524334192276 / seconds
Query Executed:select id FROM `nh` where city='Richmond' && SIC_code='4841'DB:business_master_new
loadtime:0.52568316459656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rindge' limit 1
loadtime:0.5257351398468 / seconds
Query Executed:select id FROM `nh` where city='Rindge' && SIC_code='4841'DB:business_master_new
loadtime:0.5262770652771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:0.52631616592407 / seconds
Query Executed:select id FROM `nh` where city='Rochester' && SIC_code='4841'DB:business_master_new
loadtime:0.52686500549316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rollinsford' limit 1
loadtime:0.52691507339478 / seconds
Query Executed:select id FROM `nh` where city='Rollinsford' && SIC_code='4841'DB:business_master_new
loadtime:0.52728796005249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:0.52733111381531 / seconds
Query Executed:select id FROM `nh` where city='Roxbury' && SIC_code='4841'DB:business_master_new
loadtime:0.52754402160645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rumney' limit 1
loadtime:0.52757906913757 / seconds
Query Executed:select id FROM `nh` where city='Rumney' && SIC_code='4841'DB:business_master_new
loadtime:0.52793097496033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rye' limit 1
loadtime:0.52797102928162 / seconds
Query Executed:select id FROM `nh` where city='Rye' && SIC_code='4841'DB:business_master_new
loadtime:0.52849102020264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rye Beach' limit 1
loadtime:0.52853417396545 / seconds
Query Executed:select id FROM `nh` where city='Rye Beach' && SIC_code='4841'DB:business_master_new
loadtime:0.528892993927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.52893805503845 / seconds
Query Executed:select id FROM `nh` where city='Salem' && SIC_code='4841'DB:business_master_new
loadtime:0.52946305274963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:0.52950215339661 / seconds
Query Executed:select id FROM `nh` where city='Salisbury' && SIC_code='4841'DB:business_master_new
loadtime:0.52986812591553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanbornton' limit 1
loadtime:0.52990317344666 / seconds
Query Executed:select id FROM `nh` where city='Sanbornton' && SIC_code='4841'DB:business_master_new
loadtime:0.53042817115784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanbornville' limit 1
loadtime:0.53046917915344 / seconds
Query Executed:select id FROM `nh` where city='Sanbornville' && SIC_code='4841'DB:business_master_new
loadtime:0.53101801872253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandown' limit 1
loadtime:0.53106617927551 / seconds
Query Executed:select id FROM `nh` where city='Sandown' && SIC_code='4841'DB:business_master_new
loadtime:0.53162503242493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seabrook' limit 1
loadtime:0.53167700767517 / seconds
Query Executed:select id FROM `nh` where city='Seabrook' && SIC_code='4841'DB:business_master_new
loadtime:0.532222032547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.53229212760925 / seconds
Query Executed:select id FROM `nh` where city='Sharon' && SIC_code='4841'DB:business_master_new
loadtime:0.53329515457153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelburne' limit 1
loadtime:0.53333616256714 / seconds
Query Executed:select id FROM `nh` where city='Shelburne' && SIC_code='4841'DB:business_master_new
loadtime:0.53475308418274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Lake' limit 1
loadtime:0.53479909896851 / seconds
Query Executed:select id FROM `nh` where city='Silver Lake' && SIC_code='4841'DB:business_master_new
loadtime:0.53510499000549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somersworth' limit 1
loadtime:0.53514218330383 / seconds
Query Executed:select id FROM `nh` where city='Somersworth' && SIC_code='4841'DB:business_master_new
loadtime:0.53570318222046 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Acworth' limit 1
loadtime:0.53574299812317 / seconds
Query Executed:select id FROM `nh` where city='South Acworth' && SIC_code='4841'DB:business_master_new
loadtime:0.53949213027954 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Effingham' limit 1
loadtime:0.53954100608826 / seconds
Query Executed:select id FROM `nh` where city='South Effingham' && SIC_code='4841'DB:business_master_new
loadtime:0.53976106643677 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hampton' limit 1
loadtime:0.5397961139679 / seconds
Query Executed:select id FROM `nh` where city='South Hampton' && SIC_code='4841'DB:business_master_new
loadtime:0.54075908660889 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Newbury' limit 1
loadtime:0.54079508781433 / seconds
Query Executed:select id FROM `nh` where city='South Newbury' && SIC_code='4841'DB:business_master_new
loadtime:0.54251003265381 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Sutton' limit 1
loadtime:0.54256296157837 / seconds
Query Executed:select id FROM `nh` where city='South Sutton' && SIC_code='4841'DB:business_master_new
loadtime:0.54288005828857 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Tamworth' limit 1
loadtime:0.54291605949402 / seconds
Query Executed:select id FROM `nh` where city='South Tamworth' && SIC_code='4841'DB:business_master_new
loadtime:0.54320406913757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spofford' limit 1
loadtime:0.54324007034302 / seconds
Query Executed:select id FROM `nh` where city='Spofford' && SIC_code='4841'DB:business_master_new
loadtime:0.54358696937561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.54364013671875 / seconds
Query Executed:select id FROM `nh` where city='Springfield' && SIC_code='4841'DB:business_master_new
loadtime:0.54398107528687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stark' limit 1
loadtime:0.54401302337646 / seconds
Query Executed:select id FROM `nh` where city='Stark' && SIC_code='4841'DB:business_master_new
loadtime:0.54421901702881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stewartstown' limit 1
loadtime:0.54425096511841 / seconds
Query Executed:select id FROM `nh` where city='Stewartstown' && SIC_code='4841'DB:business_master_new
loadtime:0.54474306106567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stinson Lake' limit 1
loadtime:0.54478311538696 / seconds
Query Executed:select id FROM `nh` where city='Stinson Lake' && SIC_code='4841'DB:business_master_new
loadtime:0.54498696327209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoddard' limit 1
loadtime:0.5450291633606 / seconds
Query Executed:select id FROM `nh` where city='Stoddard' && SIC_code='4841'DB:business_master_new
loadtime:0.54532408714294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strafford' limit 1
loadtime:0.54536414146423 / seconds
Query Executed:select id FROM `nh` where city='Strafford' && SIC_code='4841'DB:business_master_new
loadtime:0.54571008682251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratham' limit 1
loadtime:0.54574513435364 / seconds
Query Executed:select id FROM `nh` where city='Stratham' && SIC_code='4841'DB:business_master_new
loadtime:0.54627919197083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar Hill' limit 1
loadtime:0.54632115364075 / seconds
Query Executed:select id FROM `nh` where city='Sugar Hill' && SIC_code='4841'DB:business_master_new
loadtime:0.54663801193237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sullivan' limit 1
loadtime:0.54668712615967 / seconds
Query Executed:select id FROM `nh` where city='Sullivan' && SIC_code='4841'DB:business_master_new
loadtime:0.54699301719666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunapee' limit 1
loadtime:0.54702115058899 / seconds
Query Executed:select id FROM `nh` where city='Sunapee' && SIC_code='4841'DB:business_master_new
loadtime:0.54757308959961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suncook' limit 1
loadtime:0.54762196540833 / seconds
Query Executed:select id FROM `nh` where city='Suncook' && SIC_code='4841'DB:business_master_new
loadtime:0.5481481552124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surry' limit 1
loadtime:0.54818511009216 / seconds
Query Executed:select id FROM `nh` where city='Surry' && SIC_code='4841'DB:business_master_new
loadtime:0.54995918273926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swanzey' limit 1
loadtime:0.55000305175781 / seconds
Query Executed:select id FROM `nh` where city='Swanzey' && SIC_code='4841'DB:business_master_new
loadtime:0.55056118965149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tamworth' limit 1
loadtime:0.55061101913452 / seconds
Query Executed:select id FROM `nh` where city='Tamworth' && SIC_code='4841'DB:business_master_new
loadtime:0.55115413665771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temple' limit 1
loadtime:0.55120015144348 / seconds
Query Executed:select id FROM `nh` where city='Temple' && SIC_code='4841'DB:business_master_new
loadtime:0.55156898498535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornton' limit 1
loadtime:0.55162000656128 / seconds
Query Executed:select id FROM `nh` where city='Thornton' && SIC_code='4841'DB:business_master_new
loadtime:0.55193018913269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tilton' limit 1
loadtime:0.55196499824524 / seconds
Query Executed:select id FROM `nh` where city='Tilton' && SIC_code='4841'DB:business_master_new
loadtime:0.5524799823761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:0.55251908302307 / seconds
Query Executed:select id FROM `nh` where city='Troy' && SIC_code='4841'DB:business_master_new
loadtime:0.55285596847534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twin Mountain' limit 1
loadtime:0.55289602279663 / seconds
Query Executed:select id FROM `nh` where city='Twin Mountain' && SIC_code='4841'DB:business_master_new
loadtime:0.55323219299316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:0.55328011512756 / seconds
Query Executed:select id FROM `nh` where city='Union' && SIC_code='4841'DB:business_master_new
loadtime:0.55363202095032 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Chesterfield' limit 1
loadtime:0.55368113517761 / seconds
Query Executed:select id FROM `nh` where city='W Chesterfield' && SIC_code='4841'DB:business_master_new
loadtime:0.55585408210754 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Peterborough' limit 1
loadtime:0.55588912963867 / seconds
Query Executed:select id FROM `nh` where city='W Peterborough' && SIC_code='4841'DB:business_master_new
loadtime:0.5561101436615 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Stewartstown' limit 1
loadtime:0.55615401268005 / seconds
Query Executed:select id FROM `nh` where city='W Stewartstown' && SIC_code='4841'DB:business_master_new
loadtime:0.5564661026001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walpole' limit 1
loadtime:0.55650210380554 / seconds
Query Executed:select id FROM `nh` where city='Walpole' && SIC_code='4841'DB:business_master_new
loadtime:0.55704307556152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warner' limit 1
loadtime:0.55709218978882 / seconds
Query Executed:select id FROM `nh` where city='Warner' && SIC_code='4841'DB:business_master_new
loadtime:0.55765604972839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:0.55770397186279 / seconds
Query Executed:select id FROM `nh` where city='Warren' && SIC_code='4841'DB:business_master_new
loadtime:0.55803298950195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.55806708335876 / seconds
Query Executed:select id FROM `nh` where city='Washington' && SIC_code='4841'DB:business_master_new
loadtime:0.55840706825256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville Valley' limit 1
loadtime:0.55843710899353 / seconds
Query Executed:select id FROM `nh` where city='Waterville Valley' && SIC_code='4841'DB:business_master_new
loadtime:0.55878710746765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville Vly' limit 1
loadtime:0.55884504318237 / seconds
Query Executed:select id FROM `nh` where city='Waterville Vly' && SIC_code='4841'DB:business_master_new
loadtime:0.55908799171448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weare' limit 1
loadtime:0.55911898612976 / seconds
Query Executed:select id FROM `nh` where city='Weare' && SIC_code='4841'DB:business_master_new
loadtime:0.5596821308136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:0.55973696708679 / seconds
Query Executed:select id FROM `nh` where city='Webster' && SIC_code='4841'DB:business_master_new
loadtime:0.56129908561707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworth' limit 1
loadtime:0.56135201454163 / seconds
Query Executed:select id FROM `nh` where city='Wentworth' && SIC_code='4841'DB:business_master_new
loadtime:0.56172299385071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworths Loctn' limit 1
loadtime:0.56177401542664 / seconds
Query Executed:select id FROM `nh` where city='Wentworths Loctn' && SIC_code='4841'DB:business_master_new
loadtime:0.56198716163635 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chesterfield' limit 1
loadtime:0.56202006340027 / seconds
Query Executed:select id FROM `nh` where city='West Chesterfield' && SIC_code='4841'DB:business_master_new
loadtime:0.56232810020447 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Lebanon' limit 1
loadtime:0.56237196922302 / seconds
Query Executed:select id FROM `nh` where city='West Lebanon' && SIC_code='4841'DB:business_master_new
loadtime:0.56290817260742 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Nottingham' limit 1
loadtime:0.56295299530029 / seconds
Query Executed:select id FROM `nh` where city='West Nottingham' && SIC_code='4841'DB:business_master_new
loadtime:0.56733298301697 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Ossipee' limit 1
loadtime:0.56737899780273 / seconds
Query Executed:select id FROM `nh` where city='West Ossipee' && SIC_code='4841'DB:business_master_new
loadtime:0.56775212287903 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Peterborough' limit 1
loadtime:0.56780219078064 / seconds
Query Executed:select id FROM `nh` where city='West Peterborough' && SIC_code='4841'DB:business_master_new
loadtime:0.56949996948242 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Springfield' limit 1
loadtime:0.56954097747803 / seconds
Query Executed:select id FROM `nh` where city='West Springfield' && SIC_code='4841'DB:business_master_new
loadtime:0.56978702545166 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Stewartstown' limit 1
loadtime:0.56982707977295 / seconds
Query Executed:select id FROM `nh` where city='West Stewartstown' && SIC_code='4841'DB:business_master_new
loadtime:0.57015800476074 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Swanzey' limit 1
loadtime:0.57018899917603 / seconds
Query Executed:select id FROM `nh` where city='West Swanzey' && SIC_code='4841'DB:business_master_new
loadtime:0.57057499885559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westmoreland' limit 1
loadtime:0.57062315940857 / seconds
Query Executed:select id FROM `nh` where city='Westmoreland' && SIC_code='4841'DB:business_master_new
loadtime:0.57097196578979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitefield' limit 1
loadtime:0.57102298736572 / seconds
Query Executed:select id FROM `nh` where city='Whitefield' && SIC_code='4841'DB:business_master_new
loadtime:0.57159399986267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmot' limit 1
loadtime:0.57164406776428 / seconds
Query Executed:select id FROM `nh` where city='Wilmot' && SIC_code='4841'DB:business_master_new
loadtime:0.5721709728241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmot Flat' limit 1
loadtime:0.57220816612244 / seconds
Query Executed:select id FROM `nh` where city='Wilmot Flat' && SIC_code='4841'DB:business_master_new
loadtime:0.57242202758789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:0.57246017456055 / seconds
Query Executed:select id FROM `nh` where city='Wilton' && SIC_code='4841'DB:business_master_new
loadtime:0.57297015190125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:0.57299613952637 / seconds
Query Executed:select id FROM `nh` where city='Winchester' && SIC_code='4841'DB:business_master_new
loadtime:0.57354617118835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windham' limit 1
loadtime:0.57360100746155 / seconds
Query Executed:select id FROM `nh` where city='Windham' && SIC_code='4841'DB:business_master_new
loadtime:0.57413005828857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:0.57416605949402 / seconds
Query Executed:select id FROM `nh` where city='Windsor' && SIC_code='4841'DB:business_master_new
loadtime:0.57613706588745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winnisquam' limit 1
loadtime:0.57617211341858 / seconds
Query Executed:select id FROM `nh` where city='Winnisquam' && SIC_code='4841'DB:business_master_new
loadtime:0.57674598693848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolfeboro' limit 1
loadtime:0.57679414749146 / seconds
Query Executed:select id FROM `nh` where city='Wolfeboro' && SIC_code='4841'DB:business_master_new
loadtime:0.57732605934143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolfeboro Falls' limit 1
loadtime:0.57735300064087 / seconds
Query Executed:select id FROM `nh` where city='Wolfeboro Falls' && SIC_code='4841'DB:business_master_new
loadtime:0.57790017127991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wonalancet' limit 1
loadtime:0.57795119285583 / seconds
Query Executed:select id FROM `nh` where city='Wonalancet' && SIC_code='4841'DB:business_master_new
loadtime:0.57947111129761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:0.57951903343201 / seconds
Query Executed:select id FROM `nh` where city='Woodstock' && SIC_code='4841'DB:business_master_new
loadtime:0.58007311820984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodsville' limit 1
loadtime:0.58011412620544 / seconds
Query Executed:select id FROM `nh` where city='Woodsville' && SIC_code='4841'DB:business_master_new
loadtime:0.58065414428711 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.58073115348816 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.58089017868042 / seconds
Operation template executed (chunk cache operation)
loadtime:0.58096504211426 / seconds
template override:Default
loadtime:0.58098316192627 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:0.58180212974548 / seconds
Template Constructed, Array Rows:49
loadtime:0.58202695846558 / seconds
TOTAL EXECUTION TIME: 0.58184
loadtime:0.58211016654968 / seconds

THIS PAGE CACHED ON:
THIS PAGE COMPRESSION:
HITS TO THIS PAGE/CACHE:
PAGES STORED:
DATASIZE: Bytes
Compression:


PAGE OBJECT DATA


Key: page;
subKey: directorystate;
subKey: directorystatepages;
subKey: template;



_GET


Array ( [cat_URLid] => cable-and-other-pay-television-services [stateURLid] => new-hampshire )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


Array ( [0] => cache [1] => query [2] => output [3] => session [4] => db [5] => db2 [6] => dbnew [7] => sphinxsearch [8] => sphinx [9] => dbConn [10] => functions [11] => sphinx_search [12] => template_operations [13] => buildtemplate [14] => syndication_handler [15] => directorystate )


MEMCACHED STATS




TOTAL EXECTUTION TIME:0.58211398124695
TOTAL KEY ARRAYS: 69