Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:5.4836273193359E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00041484832763672 / seconds
host not found setting manual db connection
loadtime:0.00067996978759766 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00093293190002441 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0010509490966797 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0010969638824463 / seconds
zipcode:
loadtime:0.0011129379272461 / seconds
Query Executed:select * from search_referrer where page_hash='b0330fb7c78e98ce07f8688e9d6c5fbb' limit 10 DB:ezrox_toadli
loadtime:0.0012879371643066 / seconds
Operation header executed (non global)
loadtime:0.0013048648834229 / seconds
Operation leaderboard executed (non global)
loadtime:0.0013308525085449 / seconds
Operation square executed (non global)
loadtime:0.0013439655303955 / seconds
Operation square_bottom executed (non global)
loadtime:0.0013558864593506 / seconds
Operation smallsquare executed (non global)
loadtime:0.0013680458068848 / seconds
Operation headeradright executed (non global)
loadtime:0.0013918876647949 / seconds
Operation google_analytics executed (non global)
loadtime:0.0014069080352783 / seconds
Operation topstories executed (non global)
loadtime:0.0014190673828125 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0014300346374512 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0014400482177734 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.001662015914917 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0018160343170166 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0018529891967773 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.001910924911499 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0019469261169434 / seconds
Template key: archive_menu pushed
loadtime:0.0019519329071045 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.001957893371582 / seconds
Template key: get_gravatar pushed
loadtime:0.0019619464874268 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0019659996032715 / seconds
*10)-10)+1 | start:0
loadtime:0.0019869804382324 / seconds
Query loaded from cache:select * from categories where cat_URLid='religious-organizations'
loadtime:0.0020220279693604 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-hampshire'
loadtime:0.0020558834075928 / seconds
DB connected to localhost business_master_new
loadtime:0.0022819042205811 / seconds
Query Executed:select * from `nh_catmap` where sic='8661' order by city ascDB:business_master_new
loadtime:0.050969839096069 / seconds
Query stored in cache : _QUERY_www.toadli.com055c54e073da8f5e649ea58f5ca922f8
loadtime:0.052290916442871 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-hampshire'
loadtime:0.052371978759766 / seconds
Query Executed:select sum(totalcount) as totalsum from `nh_catmap` where sic='8661'DB:business_master_new
loadtime:0.057040929794312 / seconds
Query stored in cache : _QUERY_www.toadli.com831dec2cd1dec198d05808ebcd08cb01
loadtime:0.057142019271851 / seconds
309 / 11
loadtime:0.057229042053223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acworth' limit 1
loadtime:0.057337999343872 / seconds
Query Executed:select id FROM `nh` where city='Acworth' && SIC_code='8661'DB:business_master_new
loadtime:0.060016870498657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albany' limit 1
loadtime:0.060173034667969 / seconds
Query Executed:select id FROM `nh` where city='Albany' && SIC_code='8661'DB:business_master_new
loadtime:0.061234951019287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexandria' limit 1
loadtime:0.061367034912109 / seconds
Query Executed:select id FROM `nh` where city='Alexandria' && SIC_code='8661'DB:business_master_new
loadtime:0.062278032302856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allenstown' limit 1
loadtime:0.062466859817505 / seconds
Query Executed:select id FROM `nh` where city='Allenstown' && SIC_code='8661'DB:business_master_new
loadtime:0.063416004180908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alstead' limit 1
loadtime:0.063514947891235 / seconds
Query Executed:select id FROM `nh` where city='Alstead' && SIC_code='8661'DB:business_master_new
loadtime:0.065717935562134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.065784931182861 / seconds
Query Executed:select id FROM `nh` where city='Alton' && SIC_code='8661'DB:business_master_new
loadtime:0.067805051803589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton Bay' limit 1
loadtime:0.06797194480896 / seconds
Query Executed:select id FROM `nh` where city='Alton Bay' && SIC_code='8661'DB:business_master_new
loadtime:0.071953058242798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.072011947631836 / seconds
Query Executed:select id FROM `nh` where city='Amherst' && SIC_code='8661'DB:business_master_new
loadtime:0.074620962142944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.074687004089355 / seconds
Query Executed:select id FROM `nh` where city='Andover' && SIC_code='8661'DB:business_master_new
loadtime:0.076034069061279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Antrim' limit 1
loadtime:0.076084852218628 / seconds
Query Executed:select id FROM `nh` where city='Antrim' && SIC_code='8661'DB:business_master_new
loadtime:0.081364870071411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.081434965133667 / seconds
Query Executed:select id FROM `nh` where city='Ashland' && SIC_code='8661'DB:business_master_new
loadtime:0.083720922470093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashuelot' limit 1
loadtime:0.083879947662354 / seconds
Query Executed:select id FROM `nh` where city='Ashuelot' && SIC_code='8661'DB:business_master_new
loadtime:0.084672927856445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atkinson' limit 1
loadtime:0.084820032119751 / seconds
Query Executed:select id FROM `nh` where city='Atkinson' && SIC_code='8661'DB:business_master_new
loadtime:0.086669921875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.086729049682617 / seconds
Query Executed:select id FROM `nh` where city='Auburn' && SIC_code='8661'DB:business_master_new
loadtime:0.088912963867188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnstead' limit 1
loadtime:0.089053869247437 / seconds
Query Executed:select id FROM `nh` where city='Barnstead' && SIC_code='8661'DB:business_master_new
loadtime:0.090571880340576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barrington' limit 1
loadtime:0.09061598777771 / seconds
Query Executed:select id FROM `nh` where city='Barrington' && SIC_code='8661'DB:business_master_new
loadtime:0.092697858810425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bartlett' limit 1
loadtime:0.092875003814697 / seconds
Query Executed:select id FROM `nh` where city='Bartlett' && SIC_code='8661'DB:business_master_new
loadtime:0.094943046569824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.095098972320557 / seconds
Query Executed:select id FROM `nh` where city='Bath' && SIC_code='8661'DB:business_master_new
loadtime:0.096248865127563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.096304893493652 / seconds
Query Executed:select id FROM `nh` where city='Bedford' && SIC_code='8661'DB:business_master_new
loadtime:0.10052800178528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.10059094429016 / seconds
Query Executed:select id FROM `nh` where city='Belmont' && SIC_code='8661'DB:business_master_new
loadtime:0.10311603546143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennington' limit 1
loadtime:0.10317993164062 / seconds
Query Executed:select id FROM `nh` where city='Bennington' && SIC_code='8661'DB:business_master_new
loadtime:0.10509586334229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benton' limit 1
loadtime:0.10525584220886 / seconds
Query Executed:select id FROM `nh` where city='Benton' && SIC_code='8661'DB:business_master_new
loadtime:0.10591602325439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.10596799850464 / seconds
Query Executed:select id FROM `nh` where city='Berlin' && SIC_code='8661'DB:business_master_new
loadtime:0.10995984077454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethlehem' limit 1
loadtime:0.11008286476135 / seconds
Query Executed:select id FROM `nh` where city='Bethlehem' && SIC_code='8661'DB:business_master_new
loadtime:0.12274599075317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boscawen' limit 1
loadtime:0.12290906906128 / seconds
Query Executed:select id FROM `nh` where city='Boscawen' && SIC_code='8661'DB:business_master_new
loadtime:0.12398386001587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bow' limit 1
loadtime:0.12411999702454 / seconds
Query Executed:select id FROM `nh` where city='Bow' && SIC_code='8661'DB:business_master_new
loadtime:0.12671804428101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.12686896324158 / seconds
Query Executed:select id FROM `nh` where city='Bradford' && SIC_code='8661'DB:business_master_new
loadtime:0.12950897216797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brentwood' limit 1
loadtime:0.12967586517334 / seconds
Query Executed:select id FROM `nh` where city='Brentwood' && SIC_code='8661'DB:business_master_new
loadtime:0.130450963974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bretton Woods' limit 1
loadtime:0.13056993484497 / seconds
Query Executed:select id FROM `nh` where city='Bretton Woods' && SIC_code='8661'DB:business_master_new
loadtime:0.13160586357117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.13173890113831 / seconds
Query Executed:select id FROM `nh` where city='Bristol' && SIC_code='8661'DB:business_master_new
loadtime:0.13498187065125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.13515090942383 / seconds
Query Executed:select id FROM `nh` where city='Brookfield' && SIC_code='8661'DB:business_master_new
loadtime:0.13593602180481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline' limit 1
loadtime:0.1359920501709 / seconds
Query Executed:select id FROM `nh` where city='Brookline' && SIC_code='8661'DB:business_master_new
loadtime:0.13823390007019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Campton' limit 1
loadtime:0.13844084739685 / seconds
Query Executed:select id FROM `nh` where city='Campton' && SIC_code='8661'DB:business_master_new
loadtime:0.14137506484985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canaan' limit 1
loadtime:0.14156699180603 / seconds
Query Executed:select id FROM `nh` where city='Canaan' && SIC_code='8661'DB:business_master_new
loadtime:0.14375400543213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Candia' limit 1
loadtime:0.14389204978943 / seconds
Query Executed:select id FROM `nh` where city='Candia' && SIC_code='8661'DB:business_master_new
loadtime:0.14660501480103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canterbury' limit 1
loadtime:0.14677596092224 / seconds
Query Executed:select id FROM `nh` where city='Canterbury' && SIC_code='8661'DB:business_master_new
loadtime:0.15010499954224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carroll' limit 1
loadtime:0.15016102790833 / seconds
Query Executed:select id FROM `nh` where city='Carroll' && SIC_code='8661'DB:business_master_new
loadtime:0.15046501159668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Barnstead' limit 1
loadtime:0.15050601959229 / seconds
Query Executed:select id FROM `nh` where city='Center Barnstead' && SIC_code='8661'DB:business_master_new
loadtime:0.15136694908142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Conway' limit 1
loadtime:0.15142393112183 / seconds
Query Executed:select id FROM `nh` where city='Center Conway' && SIC_code='8661'DB:business_master_new
loadtime:0.15236306190491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Harbor' limit 1
loadtime:0.15244102478027 / seconds
Query Executed:select id FROM `nh` where city='Center Harbor' && SIC_code='8661'DB:business_master_new
loadtime:0.15339398384094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Ossipee' limit 1
loadtime:0.15343999862671 / seconds
Query Executed:select id FROM `nh` where city='Center Ossipee' && SIC_code='8661'DB:business_master_new
loadtime:0.15436887741089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Sandwich' limit 1
loadtime:0.15443992614746 / seconds
Query Executed:select id FROM `nh` where city='Center Sandwich' && SIC_code='8661'DB:business_master_new
loadtime:0.15530586242676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Strafford' limit 1
loadtime:0.15534996986389 / seconds
Query Executed:select id FROM `nh` where city='Center Strafford' && SIC_code='8661'DB:business_master_new
loadtime:0.15579199790955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Tuftonboro' limit 1
loadtime:0.1558518409729 / seconds
Query Executed:select id FROM `nh` where city='Center Tuftonboro' && SIC_code='8661'DB:business_master_new
loadtime:0.16401696205139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlestown' limit 1
loadtime:0.16405892372131 / seconds
Query Executed:select id FROM `nh` where city='Charlestown' && SIC_code='8661'DB:business_master_new
loadtime:0.1659619808197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:0.16605687141418 / seconds
Query Executed:select id FROM `nh` where city='Chatham' && SIC_code='8661'DB:business_master_new
loadtime:0.16640901565552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.16645002365112 / seconds
Query Executed:select id FROM `nh` where city='Chester' && SIC_code='8661'DB:business_master_new
loadtime:0.16865587234497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:0.16871404647827 / seconds
Query Executed:select id FROM `nh` where city='Chesterfield' && SIC_code='8661'DB:business_master_new
loadtime:0.16954898834229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chichester' limit 1
loadtime:0.16960787773132 / seconds
Query Executed:select id FROM `nh` where city='Chichester' && SIC_code='8661'DB:business_master_new
loadtime:0.170490026474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chocorua' limit 1
loadtime:0.17054891586304 / seconds
Query Executed:select id FROM `nh` where city='Chocorua' && SIC_code='8661'DB:business_master_new
loadtime:0.17460799217224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:0.17466902732849 / seconds
Query Executed:select id FROM `nh` where city='Claremont' && SIC_code='8661'DB:business_master_new
loadtime:0.18865299224854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksville' limit 1
loadtime:0.18872404098511 / seconds
Query Executed:select id FROM `nh` where city='Clarksville' && SIC_code='8661'DB:business_master_new
loadtime:0.18905901908875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colebrook' limit 1
loadtime:0.1891028881073 / seconds
Query Executed:select id FROM `nh` where city='Colebrook' && SIC_code='8661'DB:business_master_new
loadtime:0.19483804702759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.19490098953247 / seconds
Query Executed:select id FROM `nh` where city='Concord' && SIC_code='8661'DB:business_master_new
loadtime:0.21558690071106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Contoocook' limit 1
loadtime:0.21578001976013 / seconds
Query Executed:select id FROM `nh` where city='Contoocook' && SIC_code='8661'DB:business_master_new
loadtime:0.21896505355835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.21913290023804 / seconds
Query Executed:select id FROM `nh` where city='Conway' && SIC_code='8661'DB:business_master_new
loadtime:0.22181797027588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornish' limit 1
loadtime:0.22188401222229 / seconds
Query Executed:select id FROM `nh` where city='Cornish' && SIC_code='8661'DB:business_master_new
loadtime:0.22454285621643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornish Flat' limit 1
loadtime:0.22459387779236 / seconds
Query Executed:select id FROM `nh` where city='Cornish Flat' && SIC_code='8661'DB:business_master_new
loadtime:0.22503399848938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Croydon' limit 1
loadtime:0.22508406639099 / seconds
Query Executed:select id FROM `nh` where city='Croydon' && SIC_code='8661'DB:business_master_new
loadtime:0.2253749370575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ctr Tuftonboro' limit 1
loadtime:0.22542405128479 / seconds
Query Executed:select id FROM `nh` where city='Ctr Tuftonboro' && SIC_code='8661'DB:business_master_new
loadtime:0.22569799423218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dalton' limit 1
loadtime:0.22573804855347 / seconds
Query Executed:select id FROM `nh` where city='Dalton' && SIC_code='8661'DB:business_master_new
loadtime:0.2260148525238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:0.2260479927063 / seconds
Query Executed:select id FROM `nh` where city='Danbury' && SIC_code='8661'DB:business_master_new
loadtime:0.22890901565552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.22896695137024 / seconds
Query Executed:select id FROM `nh` where city='Danville' && SIC_code='8661'DB:business_master_new
loadtime:0.22981595993042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:0.22987699508667 / seconds
Query Executed:select id FROM `nh` where city='Deerfield' && SIC_code='8661'DB:business_master_new
loadtime:0.23160099983215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deering' limit 1
loadtime:0.23164486885071 / seconds
Query Executed:select id FROM `nh` where city='Deering' && SIC_code='8661'DB:business_master_new
loadtime:0.23249387741089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derry' limit 1
loadtime:0.23263597488403 / seconds
Query Executed:select id FROM `nh` where city='Derry' && SIC_code='8661'DB:business_master_new
loadtime:0.23626589775085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:0.23647403717041 / seconds
Query Executed:select id FROM `nh` where city='Dorchester' && SIC_code='8661'DB:business_master_new
loadtime:0.23707294464111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dover' limit 1
loadtime:0.2371199131012 / seconds
Query Executed:select id FROM `nh` where city='Dover' && SIC_code='8661'DB:business_master_new
loadtime:0.24103903770447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drewsville' limit 1
loadtime:0.24122285842896 / seconds
Query Executed:select id FROM `nh` where city='Drewsville' && SIC_code='8661'DB:business_master_new
loadtime:0.24163603782654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dublin' limit 1
loadtime:0.24178886413574 / seconds
Query Executed:select id FROM `nh` where city='Dublin' && SIC_code='8661'DB:business_master_new
loadtime:0.24344205856323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dummer' limit 1
loadtime:0.24360299110413 / seconds
Query Executed:select id FROM `nh` where city='Dummer' && SIC_code='8661'DB:business_master_new
loadtime:0.24444603919983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunbarton' limit 1
loadtime:0.24449801445007 / seconds
Query Executed:select id FROM `nh` where city='Dunbarton' && SIC_code='8661'DB:business_master_new
loadtime:0.24626994132996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durham' limit 1
loadtime:0.24645090103149 / seconds
Query Executed:select id FROM `nh` where city='Durham' && SIC_code='8661'DB:business_master_new
loadtime:0.25022506713867 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Andover' limit 1
loadtime:0.2502908706665 / seconds
Query Executed:select id FROM `nh` where city='East Andover' && SIC_code='8661'DB:business_master_new
loadtime:0.25121188163757 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Candia' limit 1
loadtime:0.25133085250854 / seconds
Query Executed:select id FROM `nh` where city='East Candia' && SIC_code='8661'DB:business_master_new
loadtime:0.25187087059021 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Derry' limit 1
loadtime:0.25192499160767 / seconds
Query Executed:select id FROM `nh` where city='East Derry' && SIC_code='8661'DB:business_master_new
loadtime:0.25299787521362 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hampstead' limit 1
loadtime:0.25311493873596 / seconds
Query Executed:select id FROM `nh` where city='East Hampstead' && SIC_code='8661'DB:business_master_new
loadtime:0.2546808719635 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hebron' limit 1
loadtime:0.25473093986511 / seconds
Query Executed:select id FROM `nh` where city='East Hebron' && SIC_code='8661'DB:business_master_new
loadtime:0.25543403625488 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Kingston' limit 1
loadtime:0.255530834198 / seconds
Query Executed:select id FROM `nh` where city='East Kingston' && SIC_code='8661'DB:business_master_new
loadtime:0.25761604309082 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Swanzey' limit 1
loadtime:0.25767588615417 / seconds
Query Executed:select id FROM `nh` where city='East Swanzey' && SIC_code='8661'DB:business_master_new
loadtime:0.25813603401184 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Wakefield' limit 1
loadtime:0.25825905799866 / seconds
Query Executed:select id FROM `nh` where city='East Wakefield' && SIC_code='8661'DB:business_master_new
loadtime:0.25953388214111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eaton Center' limit 1
loadtime:0.25966691970825 / seconds
Query Executed:select id FROM `nh` where city='Eaton Center' && SIC_code='8661'DB:business_master_new
loadtime:0.26065897941589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Effingham' limit 1
loadtime:0.26079297065735 / seconds
Query Executed:select id FROM `nh` where city='Effingham' && SIC_code='8661'DB:business_master_new
loadtime:0.26197004318237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkins' limit 1
loadtime:0.26205801963806 / seconds
Query Executed:select id FROM `nh` where city='Elkins' && SIC_code='8661'DB:business_master_new
loadtime:0.2632429599762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth' limit 1
loadtime:0.26332402229309 / seconds
Query Executed:select id FROM `nh` where city='Ellsworth' && SIC_code='8661'DB:business_master_new
loadtime:0.26358103752136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enfield' limit 1
loadtime:0.2636239528656 / seconds
Query Executed:select id FROM `nh` where city='Enfield' && SIC_code='8661'DB:business_master_new
loadtime:0.26594185829163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enfield Center' limit 1
loadtime:0.26600289344788 / seconds
Query Executed:select id FROM `nh` where city='Enfield Center' && SIC_code='8661'DB:business_master_new
loadtime:0.26653599739075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Epping' limit 1
loadtime:0.26667189598083 / seconds
Query Executed:select id FROM `nh` where city='Epping' && SIC_code='8661'DB:business_master_new
loadtime:0.26917791366577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Epsom' limit 1
loadtime:0.26922488212585 / seconds
Query Executed:select id FROM `nh` where city='Epsom' && SIC_code='8661'DB:business_master_new
loadtime:0.27142596244812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Errol' limit 1
loadtime:0.27158904075623 / seconds
Query Executed:select id FROM `nh` where city='Errol' && SIC_code='8661'DB:business_master_new
loadtime:0.27656102180481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Etna' limit 1
loadtime:0.27660989761353 / seconds
Query Executed:select id FROM `nh` where city='Etna' && SIC_code='8661'DB:business_master_new
loadtime:0.27729988098145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exeter' limit 1
loadtime:0.27735686302185 / seconds
Query Executed:select id FROM `nh` where city='Exeter' && SIC_code='8661'DB:business_master_new
loadtime:0.27930092811584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.27937197685242 / seconds
Query Executed:select id FROM `nh` where city='Farmington' && SIC_code='8661'DB:business_master_new
loadtime:0.2804548740387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fitzwilliam' limit 1
loadtime:0.28050184249878 / seconds
Query Executed:select id FROM `nh` where city='Fitzwilliam' && SIC_code='8661'DB:business_master_new
loadtime:0.28141283988953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Francestown' limit 1
loadtime:0.28147292137146 / seconds
Query Executed:select id FROM `nh` where city='Francestown' && SIC_code='8661'DB:business_master_new
loadtime:0.2823338508606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franconia' limit 1
loadtime:0.28239583969116 / seconds
Query Executed:select id FROM `nh` where city='Franconia' && SIC_code='8661'DB:business_master_new
loadtime:0.28326201438904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.28331804275513 / seconds
Query Executed:select id FROM `nh` where city='Franklin' && SIC_code='8661'DB:business_master_new
loadtime:0.28440284729004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freedom' limit 1
loadtime:0.28446984291077 / seconds
Query Executed:select id FROM `nh` where city='Freedom' && SIC_code='8661'DB:business_master_new
loadtime:0.2852828502655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fremont' limit 1
loadtime:0.28533601760864 / seconds
Query Executed:select id FROM `nh` where city='Fremont' && SIC_code='8661'DB:business_master_new
loadtime:0.28622484207153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georges Mills' limit 1
loadtime:0.28628206253052 / seconds
Query Executed:select id FROM `nh` where city='Georges Mills' && SIC_code='8661'DB:business_master_new
loadtime:0.2868869304657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilford' limit 1
loadtime:0.28694605827332 / seconds
Query Executed:select id FROM `nh` where city='Gilford' && SIC_code='8661'DB:business_master_new
loadtime:0.28817105293274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilmanton' limit 1
loadtime:0.28822588920593 / seconds
Query Executed:select id FROM `nh` where city='Gilmanton' && SIC_code='8661'DB:business_master_new
loadtime:0.28912305831909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilmanton Iron Works' limit 1
loadtime:0.28918194770813 / seconds
Query Executed:select id FROM `nh` where city='Gilmanton Iron Works' && SIC_code='8661'DB:business_master_new
loadtime:0.28987693786621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilsum' limit 1
loadtime:0.28992700576782 / seconds
Query Executed:select id FROM `nh` where city='Gilsum' && SIC_code='8661'DB:business_master_new
loadtime:0.29050993919373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen' limit 1
loadtime:0.2905650138855 / seconds
Query Executed:select id FROM `nh` where city='Glen' && SIC_code='8661'DB:business_master_new
loadtime:0.29191589355469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glencliff' limit 1
loadtime:0.29207897186279 / seconds
Query Executed:select id FROM `nh` where city='Glencliff' && SIC_code='8661'DB:business_master_new
loadtime:0.2929539680481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glmntn Iron Wks' limit 1
loadtime:0.29299783706665 / seconds
Query Executed:select id FROM `nh` where city='Glmntn Iron Wks' && SIC_code='8661'DB:business_master_new
loadtime:0.29357290267944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goffstown' limit 1
loadtime:0.2936909198761 / seconds
Query Executed:select id FROM `nh` where city='Goffstown' && SIC_code='8661'DB:business_master_new
loadtime:0.29615688323975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gorham' limit 1
loadtime:0.29633903503418 / seconds
Query Executed:select id FROM `nh` where city='Gorham' && SIC_code='8661'DB:business_master_new
loadtime:0.2991988658905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.29926705360413 / seconds
Query Executed:select id FROM `nh` where city='Goshen' && SIC_code='8661'DB:business_master_new
loadtime:0.29990696907043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.29996299743652 / seconds
Query Executed:select id FROM `nh` where city='Grafton' && SIC_code='8661'DB:business_master_new
loadtime:0.30057787895203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grantham' limit 1
loadtime:0.30062699317932 / seconds
Query Executed:select id FROM `nh` where city='Grantham' && SIC_code='8661'DB:business_master_new
loadtime:0.30147004127502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenfield' limit 1
loadtime:0.30152487754822 / seconds
Query Executed:select id FROM `nh` where city='Greenfield' && SIC_code='8661'DB:business_master_new
loadtime:0.30236983299255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenland' limit 1
loadtime:0.3024468421936 / seconds
Query Executed:select id FROM `nh` where city='Greenland' && SIC_code='8661'DB:business_master_new
loadtime:0.30341386795044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.3034770488739 / seconds
Query Executed:select id FROM `nh` where city='Greenville' && SIC_code='8661'DB:business_master_new
loadtime:0.30478000640869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groveton' limit 1
loadtime:0.30483794212341 / seconds
Query Executed:select id FROM `nh` where city='Groveton' && SIC_code='8661'DB:business_master_new
loadtime:0.30612683296204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guild' limit 1
loadtime:0.30618691444397 / seconds
Query Executed:select id FROM `nh` where city='Guild' && SIC_code='8661'DB:business_master_new
loadtime:0.30656599998474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hales Location' limit 1
loadtime:0.30660796165466 / seconds
Query Executed:select id FROM `nh` where city='Hales Location' && SIC_code='8661'DB:business_master_new
loadtime:0.30684590339661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampstead' limit 1
loadtime:0.30688285827637 / seconds
Query Executed:select id FROM `nh` where city='Hampstead' && SIC_code='8661'DB:business_master_new
loadtime:0.30866694450378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:0.30872392654419 / seconds
Query Executed:select id FROM `nh` where city='Hampton' && SIC_code='8661'DB:business_master_new
loadtime:0.31009483337402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton Falls' limit 1
loadtime:0.3101499080658 / seconds
Query Executed:select id FROM `nh` where city='Hampton Falls' && SIC_code='8661'DB:business_master_new
loadtime:0.31154990196228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:0.31160593032837 / seconds
Query Executed:select id FROM `nh` where city='Hancock' && SIC_code='8661'DB:business_master_new
loadtime:0.31244897842407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.31250691413879 / seconds
Query Executed:select id FROM `nh` where city='Hanover' && SIC_code='8661'DB:business_master_new
loadtime:0.32353687286377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisville' limit 1
loadtime:0.32371687889099 / seconds
Query Executed:select id FROM `nh` where city='Harrisville' && SIC_code='8661'DB:business_master_new
loadtime:0.32505702972412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harts Location' limit 1
loadtime:0.32516384124756 / seconds
Query Executed:select id FROM `nh` where city='Harts Location' && SIC_code='8661'DB:business_master_new
loadtime:0.32565188407898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haverhill' limit 1
loadtime:0.32571887969971 / seconds
Query Executed:select id FROM `nh` where city='Haverhill' && SIC_code='8661'DB:business_master_new
loadtime:0.32644891738892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hebron' limit 1
loadtime:0.32654595375061 / seconds
Query Executed:select id FROM `nh` where city='Hebron' && SIC_code='8661'DB:business_master_new
loadtime:0.3276309967041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henniker' limit 1
loadtime:0.32771587371826 / seconds
Query Executed:select id FROM `nh` where city='Henniker' && SIC_code='8661'DB:business_master_new
loadtime:0.32917404174805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hill' limit 1
loadtime:0.32923698425293 / seconds
Query Executed:select id FROM `nh` where city='Hill' && SIC_code='8661'DB:business_master_new
loadtime:0.33003687858582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:0.33013296127319 / seconds
Query Executed:select id FROM `nh` where city='Hillsboro' && SIC_code='8661'DB:business_master_new
loadtime:0.33121705055237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsborough' limit 1
loadtime:0.33131098747253 / seconds
Query Executed:select id FROM `nh` where city='Hillsborough' && SIC_code='8661'DB:business_master_new
loadtime:0.33318495750427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinsdale' limit 1
loadtime:0.33326983451843 / seconds
Query Executed:select id FROM `nh` where city='Hinsdale' && SIC_code='8661'DB:business_master_new
loadtime:0.33505797386169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holderness' limit 1
loadtime:0.33522200584412 / seconds
Query Executed:select id FROM `nh` where city='Holderness' && SIC_code='8661'DB:business_master_new
loadtime:0.33758902549744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollis' limit 1
loadtime:0.33772492408752 / seconds
Query Executed:select id FROM `nh` where city='Hollis' && SIC_code='8661'DB:business_master_new
loadtime:0.33892488479614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hooksett' limit 1
loadtime:0.3389880657196 / seconds
Query Executed:select id FROM `nh` where city='Hooksett' && SIC_code='8661'DB:business_master_new
loadtime:0.34332704544067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkinton' limit 1
loadtime:0.34340190887451 / seconds
Query Executed:select id FROM `nh` where city='Hopkinton' && SIC_code='8661'DB:business_master_new
loadtime:0.34380388259888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:0.34384703636169 / seconds
Query Executed:select id FROM `nh` where city='Hudson' && SIC_code='8661'DB:business_master_new
loadtime:0.34551000595093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Intervale' limit 1
loadtime:0.34556698799133 / seconds
Query Executed:select id FROM `nh` where city='Intervale' && SIC_code='8661'DB:business_master_new
loadtime:0.34641790390015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:0.34646487236023 / seconds
Query Executed:select id FROM `nh` where city='Jackson' && SIC_code='8661'DB:business_master_new
loadtime:0.3477828502655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jaffrey' limit 1
loadtime:0.34790301322937 / seconds
Query Executed:select id FROM `nh` where city='Jaffrey' && SIC_code='8661'DB:business_master_new
loadtime:0.35021591186523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:0.35041785240173 / seconds
Query Executed:select id FROM `nh` where city='Jefferson' && SIC_code='8661'DB:business_master_new
loadtime:0.35230183601379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kearsarge' limit 1
loadtime:0.35236287117004 / seconds
Query Executed:select id FROM `nh` where city='Kearsarge' && SIC_code='8661'DB:business_master_new
loadtime:0.35289692878723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keene' limit 1
loadtime:0.353031873703 / seconds
Query Executed:select id FROM `nh` where city='Keene' && SIC_code='8661'DB:business_master_new
loadtime:0.35733985900879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kensington' limit 1
loadtime:0.35758686065674 / seconds
Query Executed:select id FROM `nh` where city='Kensington' && SIC_code='8661'DB:business_master_new
loadtime:0.35819292068481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:0.35831689834595 / seconds
Query Executed:select id FROM `nh` where city='Kingston' && SIC_code='8661'DB:business_master_new
loadtime:0.36030197143555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laconia' limit 1
loadtime:0.3605010509491 / seconds
Query Executed:select id FROM `nh` where city='Laconia' && SIC_code='8661'DB:business_master_new
loadtime:0.36401891708374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:0.36409687995911 / seconds
Query Executed:select id FROM `nh` where city='Lancaster' && SIC_code='8661'DB:business_master_new
loadtime:0.36633706092834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Landaff' limit 1
loadtime:0.36643695831299 / seconds
Query Executed:select id FROM `nh` where city='Landaff' && SIC_code='8661'DB:business_master_new
loadtime:0.367271900177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langdon' limit 1
loadtime:0.36744689941406 / seconds
Query Executed:select id FROM `nh` where city='Langdon' && SIC_code='8661'DB:business_master_new
loadtime:0.36789393424988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:0.36803197860718 / seconds
Query Executed:select id FROM `nh` where city='Lebanon' && SIC_code='8661'DB:business_master_new
loadtime:0.3714439868927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lee' limit 1
loadtime:0.37155604362488 / seconds
Query Executed:select id FROM `nh` where city='Lee' && SIC_code='8661'DB:business_master_new
loadtime:0.37315702438354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lempster' limit 1
loadtime:0.3732168674469 / seconds
Query Executed:select id FROM `nh` where city='Lempster' && SIC_code='8661'DB:business_master_new
loadtime:0.37452387809753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.37457394599915 / seconds
Query Executed:select id FROM `nh` where city='Lincoln' && SIC_code='8661'DB:business_master_new
loadtime:0.37655997276306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lisbon' limit 1
loadtime:0.3766610622406 / seconds
Query Executed:select id FROM `nh` where city='Lisbon' && SIC_code='8661'DB:business_master_new
loadtime:0.37854695320129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield' limit 1
loadtime:0.37860989570618 / seconds
Query Executed:select id FROM `nh` where city='Litchfield' && SIC_code='8661'DB:business_master_new
loadtime:0.38045787811279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littleton' limit 1
loadtime:0.38056206703186 / seconds
Query Executed:select id FROM `nh` where city='Littleton' && SIC_code='8661'DB:business_master_new
loadtime:0.38312196731567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lochmere' limit 1
loadtime:0.38327097892761 / seconds
Query Executed:select id FROM `nh` where city='Lochmere' && SIC_code='8661'DB:business_master_new
loadtime:0.38415288925171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Londonderry' limit 1
loadtime:0.38421201705933 / seconds
Query Executed:select id FROM `nh` where city='Londonderry' && SIC_code='8661'DB:business_master_new
loadtime:0.38754296302795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loudon' limit 1
loadtime:0.38766098022461 / seconds
Query Executed:select id FROM `nh` where city='Loudon' && SIC_code='8661'DB:business_master_new
loadtime:0.39079904556274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyman' limit 1
loadtime:0.39087390899658 / seconds
Query Executed:select id FROM `nh` where city='Lyman' && SIC_code='8661'DB:business_master_new
loadtime:0.3911509513855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyme' limit 1
loadtime:0.39119100570679 / seconds
Query Executed:select id FROM `nh` where city='Lyme' && SIC_code='8661'DB:business_master_new
loadtime:0.39206194877625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyme Center' limit 1
loadtime:0.39211392402649 / seconds
Query Executed:select id FROM `nh` where city='Lyme Center' && SIC_code='8661'DB:business_master_new
loadtime:0.39244484901428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndeborough' limit 1
loadtime:0.39249396324158 / seconds
Query Executed:select id FROM `nh` where city='Lyndeborough' && SIC_code='8661'DB:business_master_new
loadtime:0.39390897750854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madbury' limit 1
loadtime:0.39395785331726 / seconds
Query Executed:select id FROM `nh` where city='Madbury' && SIC_code='8661'DB:business_master_new
loadtime:0.39558386802673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.39567899703979 / seconds
Query Executed:select id FROM `nh` where city='Madison' && SIC_code='8661'DB:business_master_new
loadtime:0.40118885040283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.40125894546509 / seconds
Query Executed:select id FROM `nh` where city='Manchester' && SIC_code='8661'DB:business_master_new
loadtime:0.4070360660553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlborough' limit 1
loadtime:0.40717005729675 / seconds
Query Executed:select id FROM `nh` where city='Marlborough' && SIC_code='8661'DB:business_master_new
loadtime:0.40810894966125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlow' limit 1
loadtime:0.40816688537598 / seconds
Query Executed:select id FROM `nh` where city='Marlow' && SIC_code='8661'DB:business_master_new
loadtime:0.40872883796692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mason' limit 1
loadtime:0.40878701210022 / seconds
Query Executed:select id FROM `nh` where city='Mason' && SIC_code='8661'DB:business_master_new
loadtime:0.40911102294922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadows' limit 1
loadtime:0.40915894508362 / seconds
Query Executed:select id FROM `nh` where city='Meadows' && SIC_code='8661'DB:business_master_new
loadtime:0.40941905975342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melvin Village' limit 1
loadtime:0.40944695472717 / seconds
Query Executed:select id FROM `nh` where city='Melvin Village' && SIC_code='8661'DB:business_master_new
loadtime:0.40999889373779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meredith' limit 1
loadtime:0.41005802154541 / seconds
Query Executed:select id FROM `nh` where city='Meredith' && SIC_code='8661'DB:business_master_new
loadtime:0.41121697425842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meriden' limit 1
loadtime:0.41127991676331 / seconds
Query Executed:select id FROM `nh` where city='Meriden' && SIC_code='8661'DB:business_master_new
loadtime:0.41193795204163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrimack' limit 1
loadtime:0.41199803352356 / seconds
Query Executed:select id FROM `nh` where city='Merrimack' && SIC_code='8661'DB:business_master_new
loadtime:0.41352605819702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleton' limit 1
loadtime:0.41359400749207 / seconds
Query Executed:select id FROM `nh` where city='Middleton' && SIC_code='8661'DB:business_master_new
loadtime:0.41392087936401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milan' limit 1
loadtime:0.4139678478241 / seconds
Query Executed:select id FROM `nh` where city='Milan' && SIC_code='8661'DB:business_master_new
loadtime:0.41478490829468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:0.41485285758972 / seconds
Query Executed:select id FROM `nh` where city='Milford' && SIC_code='8661'DB:business_master_new
loadtime:0.41614890098572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:0.4162118434906 / seconds
Query Executed:select id FROM `nh` where city='Milton' && SIC_code='8661'DB:business_master_new
loadtime:0.41707587242126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton Mills' limit 1
loadtime:0.41712999343872 / seconds
Query Executed:select id FROM `nh` where city='Milton Mills' && SIC_code='8661'DB:business_master_new
loadtime:0.4175660610199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mirror Lake' limit 1
loadtime:0.41761994361877 / seconds
Query Executed:select id FROM `nh` where city='Mirror Lake' && SIC_code='8661'DB:business_master_new
loadtime:0.41822195053101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.41827583312988 / seconds
Query Executed:select id FROM `nh` where city='Monroe' && SIC_code='8661'DB:business_master_new
loadtime:0.41892004013062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mont Vernon' limit 1
loadtime:0.41896986961365 / seconds
Query Executed:select id FROM `nh` where city='Mont Vernon' && SIC_code='8661'DB:business_master_new
loadtime:0.41981101036072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moultonborough' limit 1
loadtime:0.41987204551697 / seconds
Query Executed:select id FROM `nh` where city='Moultonborough' && SIC_code='8661'DB:business_master_new
loadtime:0.42082691192627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Sunapee' limit 1
loadtime:0.4208779335022 / seconds
Query Executed:select id FROM `nh` where city='Mt Sunapee' && SIC_code='8661'DB:business_master_new
loadtime:0.421138048172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munsonville' limit 1
loadtime:0.42117786407471 / seconds
Query Executed:select id FROM `nh` where city='Munsonville' && SIC_code='8661'DB:business_master_new
loadtime:0.42151403427124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashua' limit 1
loadtime:0.42155599594116 / seconds
Query Executed:select id FROM `nh` where city='Nashua' && SIC_code='8661'DB:business_master_new
loadtime:0.42640590667725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelson' limit 1
loadtime:0.42649793624878 / seconds
Query Executed:select id FROM `nh` where city='Nelson' && SIC_code='8661'DB:business_master_new
loadtime:0.42691683769226 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Boston' limit 1
loadtime:0.42696285247803 / seconds
Query Executed:select id FROM `nh` where city='New Boston' && SIC_code='8661'DB:business_master_new
loadtime:0.42825984954834 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Castle' limit 1
loadtime:0.42831587791443 / seconds
Query Executed:select id FROM `nh` where city='New Castle' && SIC_code='8661'DB:business_master_new
loadtime:0.42958784103394 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Durham' limit 1
loadtime:0.42963194847107 / seconds
Query Executed:select id FROM `nh` where city='New Durham' && SIC_code='8661'DB:business_master_new
loadtime:0.43047499656677 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hampton' limit 1
loadtime:0.43053102493286 / seconds
Query Executed:select id FROM `nh` where city='New Hampton' && SIC_code='8661'DB:business_master_new
loadtime:0.43139791488647 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Ipswich' limit 1
loadtime:0.43145799636841 / seconds
Query Executed:select id FROM `nh` where city='New Ipswich' && SIC_code='8661'DB:business_master_new
loadtime:0.43240690231323 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:0.43246483802795 / seconds
Query Executed:select id FROM `nh` where city='New London' && SIC_code='8661'DB:business_master_new
loadtime:0.43361592292786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbury' limit 1
loadtime:0.43368101119995 / seconds
Query Executed:select id FROM `nh` where city='Newbury' && SIC_code='8661'DB:business_master_new
loadtime:0.43452095985413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newfields' limit 1
loadtime:0.43457198143005 / seconds
Query Executed:select id FROM `nh` where city='Newfields' && SIC_code='8661'DB:business_master_new
loadtime:0.43539905548096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newington' limit 1
loadtime:0.43545603752136 / seconds
Query Executed:select id FROM `nh` where city='Newington' && SIC_code='8661'DB:business_master_new
loadtime:0.4358229637146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newmarket' limit 1
loadtime:0.43586993217468 / seconds
Query Executed:select id FROM `nh` where city='Newmarket' && SIC_code='8661'DB:business_master_new
loadtime:0.43687200546265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:0.436931848526 / seconds
Query Executed:select id FROM `nh` where city='Newport' && SIC_code='8661'DB:business_master_new
loadtime:0.43806004524231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:0.43812203407288 / seconds
Query Executed:select id FROM `nh` where city='Newton' && SIC_code='8661'DB:business_master_new
loadtime:0.43903589248657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Junction' limit 1
loadtime:0.43908190727234 / seconds
Query Executed:select id FROM `nh` where city='Newton Junction' && SIC_code='8661'DB:business_master_new
loadtime:0.43945384025574 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Conway' limit 1
loadtime:0.43950891494751 / seconds
Query Executed:select id FROM `nh` where city='North Conway' && SIC_code='8661'DB:business_master_new
loadtime:0.44069290161133 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hampton' limit 1
loadtime:0.4407479763031 / seconds
Query Executed:select id FROM `nh` where city='North Hampton' && SIC_code='8661'DB:business_master_new
loadtime:0.44180703163147 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Haverhill' limit 1
loadtime:0.44186496734619 / seconds
Query Executed:select id FROM `nh` where city='North Haverhill' && SIC_code='8661'DB:business_master_new
loadtime:0.44275593757629 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Salem' limit 1
loadtime:0.44280600547791 / seconds
Query Executed:select id FROM `nh` where city='North Salem' && SIC_code='8661'DB:business_master_new
loadtime:0.44339084625244 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Sandwich' limit 1
loadtime:0.4434449672699 / seconds
Query Executed:select id FROM `nh` where city='North Sandwich' && SIC_code='8661'DB:business_master_new
loadtime:0.44395995140076 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Stratford' limit 1
loadtime:0.44401693344116 / seconds
Query Executed:select id FROM `nh` where city='North Stratford' && SIC_code='8661'DB:business_master_new
loadtime:0.44469404220581 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Sutton' limit 1
loadtime:0.44473886489868 / seconds
Query Executed:select id FROM `nh` where city='North Sutton' && SIC_code='8661'DB:business_master_new
loadtime:0.44539785385132 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Walpole' limit 1
loadtime:0.44545602798462 / seconds
Query Executed:select id FROM `nh` where city='North Walpole' && SIC_code='8661'DB:business_master_new
loadtime:0.4460608959198 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Woodstock' limit 1
loadtime:0.44611406326294 / seconds
Query Executed:select id FROM `nh` where city='North Woodstock' && SIC_code='8661'DB:business_master_new
loadtime:0.44742703437805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:0.44758892059326 / seconds
Query Executed:select id FROM `nh` where city='Northfield' && SIC_code='8661'DB:business_master_new
loadtime:0.44847297668457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northwood' limit 1
loadtime:0.44855904579163 / seconds
Query Executed:select id FROM `nh` where city='Northwood' && SIC_code='8661'DB:business_master_new
loadtime:0.45002484321594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nottingham' limit 1
loadtime:0.45008301734924 / seconds
Query Executed:select id FROM `nh` where city='Nottingham' && SIC_code='8661'DB:business_master_new
loadtime:0.4514000415802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:0.45145893096924 / seconds
Query Executed:select id FROM `nh` where city='Orange' && SIC_code='8661'DB:business_master_new
loadtime:0.45172190666199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orford' limit 1
loadtime:0.45181703567505 / seconds
Query Executed:select id FROM `nh` where city='Orford' && SIC_code='8661'DB:business_master_new
loadtime:0.45375299453735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ossipee' limit 1
loadtime:0.45386600494385 / seconds
Query Executed:select id FROM `nh` where city='Ossipee' && SIC_code='8661'DB:business_master_new
loadtime:0.4554648399353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelham' limit 1
loadtime:0.45556902885437 / seconds
Query Executed:select id FROM `nh` where city='Pelham' && SIC_code='8661'DB:business_master_new
loadtime:0.45793390274048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:0.45797991752625 / seconds
Query Executed:select id FROM `nh` where city='Pembroke' && SIC_code='8661'DB:business_master_new
loadtime:0.45854187011719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penacook' limit 1
loadtime:0.45857095718384 / seconds
Query Executed:select id FROM `nh` where city='Penacook' && SIC_code='8661'DB:business_master_new
loadtime:0.45892596244812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peterborough' limit 1
loadtime:0.45906901359558 / seconds
Query Executed:select id FROM `nh` where city='Peterborough' && SIC_code='8661'DB:business_master_new
loadtime:0.46119093894958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piermont' limit 1
loadtime:0.46125793457031 / seconds
Query Executed:select id FROM `nh` where city='Piermont' && SIC_code='8661'DB:business_master_new
loadtime:0.46210098266602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pike' limit 1
loadtime:0.46224403381348 / seconds
Query Executed:select id FROM `nh` where city='Pike' && SIC_code='8661'DB:business_master_new
loadtime:0.46309804916382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsburg' limit 1
loadtime:0.46323084831238 / seconds
Query Executed:select id FROM `nh` where city='Pittsburg' && SIC_code='8661'DB:business_master_new
loadtime:0.46489286422729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsfield' limit 1
loadtime:0.46504783630371 / seconds
Query Executed:select id FROM `nh` where city='Pittsfield' && SIC_code='8661'DB:business_master_new
loadtime:0.46651387214661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:0.46657705307007 / seconds
Query Executed:select id FROM `nh` where city='Plainfield' && SIC_code='8661'DB:business_master_new
loadtime:0.46785998344421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plaistow' limit 1
loadtime:0.46801996231079 / seconds
Query Executed:select id FROM `nh` where city='Plaistow' && SIC_code='8661'DB:business_master_new
loadtime:0.47028589248657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.470370054245 / seconds
Query Executed:select id FROM `nh` where city='Plymouth' && SIC_code='8661'DB:business_master_new
loadtime:0.47159194946289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portsmouth' limit 1
loadtime:0.47165894508362 / seconds
Query Executed:select id FROM `nh` where city='Portsmouth' && SIC_code='8661'DB:business_master_new
loadtime:0.47487902641296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:0.47494602203369 / seconds
Query Executed:select id FROM `nh` where city='Randolph' && SIC_code='8661'DB:business_master_new
loadtime:0.47525691986084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:0.47529983520508 / seconds
Query Executed:select id FROM `nh` where city='Raymond' && SIC_code='8661'DB:business_master_new
loadtime:0.47629499435425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:0.47634506225586 / seconds
Query Executed:select id FROM `nh` where city='Richmond' && SIC_code='8661'DB:business_master_new
loadtime:0.4766309261322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rindge' limit 1
loadtime:0.4766640663147 / seconds
Query Executed:select id FROM `nh` where city='Rindge' && SIC_code='8661'DB:business_master_new
loadtime:0.47759795188904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:0.4776439666748 / seconds
Query Executed:select id FROM `nh` where city='Rochester' && SIC_code='8661'DB:business_master_new
loadtime:0.47936797142029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rollinsford' limit 1
loadtime:0.47944188117981 / seconds
Query Executed:select id FROM `nh` where city='Rollinsford' && SIC_code='8661'DB:business_master_new
loadtime:0.48029685020447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:0.48035192489624 / seconds
Query Executed:select id FROM `nh` where city='Roxbury' && SIC_code='8661'DB:business_master_new
loadtime:0.48061394691467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rumney' limit 1
loadtime:0.48064994812012 / seconds
Query Executed:select id FROM `nh` where city='Rumney' && SIC_code='8661'DB:business_master_new
loadtime:0.48149085044861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rye' limit 1
loadtime:0.48155403137207 / seconds
Query Executed:select id FROM `nh` where city='Rye' && SIC_code='8661'DB:business_master_new
loadtime:0.48247694969177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rye Beach' limit 1
loadtime:0.4825279712677 / seconds
Query Executed:select id FROM `nh` where city='Rye Beach' && SIC_code='8661'DB:business_master_new
loadtime:0.48324799537659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.48330497741699 / seconds
Query Executed:select id FROM `nh` where city='Salem' && SIC_code='8661'DB:business_master_new
loadtime:0.48670792579651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:0.48687696456909 / seconds
Query Executed:select id FROM `nh` where city='Salisbury' && SIC_code='8661'DB:business_master_new
loadtime:0.48864984512329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanbornton' limit 1
loadtime:0.48880290985107 / seconds
Query Executed:select id FROM `nh` where city='Sanbornton' && SIC_code='8661'DB:business_master_new
loadtime:0.49076294898987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanbornville' limit 1
loadtime:0.49092793464661 / seconds
Query Executed:select id FROM `nh` where city='Sanbornville' && SIC_code='8661'DB:business_master_new
loadtime:0.49292898178101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandown' limit 1
loadtime:0.49306106567383 / seconds
Query Executed:select id FROM `nh` where city='Sandown' && SIC_code='8661'DB:business_master_new
loadtime:0.49492597579956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seabrook' limit 1
loadtime:0.49509191513062 / seconds
Query Executed:select id FROM `nh` where city='Seabrook' && SIC_code='8661'DB:business_master_new
loadtime:0.49759888648987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.49772787094116 / seconds
Query Executed:select id FROM `nh` where city='Sharon' && SIC_code='8661'DB:business_master_new
loadtime:0.49821090698242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelburne' limit 1
loadtime:0.49823999404907 / seconds
Query Executed:select id FROM `nh` where city='Shelburne' && SIC_code='8661'DB:business_master_new
loadtime:0.49852991104126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Lake' limit 1
loadtime:0.4985659122467 / seconds
Query Executed:select id FROM `nh` where city='Silver Lake' && SIC_code='8661'DB:business_master_new
loadtime:0.49930596351624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somersworth' limit 1
loadtime:0.49946284294128 / seconds
Query Executed:select id FROM `nh` where city='Somersworth' && SIC_code='8661'DB:business_master_new
loadtime:0.50193405151367 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Acworth' limit 1
loadtime:0.50198984146118 / seconds
Query Executed:select id FROM `nh` where city='South Acworth' && SIC_code='8661'DB:business_master_new
loadtime:0.50291395187378 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Effingham' limit 1
loadtime:0.50305986404419 / seconds
Query Executed:select id FROM `nh` where city='South Effingham' && SIC_code='8661'DB:business_master_new
loadtime:0.50365090370178 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hampton' limit 1
loadtime:0.50375890731812 / seconds
Query Executed:select id FROM `nh` where city='South Hampton' && SIC_code='8661'DB:business_master_new
loadtime:0.50448894500732 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Newbury' limit 1
loadtime:0.5045850276947 / seconds
Query Executed:select id FROM `nh` where city='South Newbury' && SIC_code='8661'DB:business_master_new
loadtime:0.50544786453247 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Sutton' limit 1
loadtime:0.50554895401001 / seconds
Query Executed:select id FROM `nh` where city='South Sutton' && SIC_code='8661'DB:business_master_new
loadtime:0.506432056427 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Tamworth' limit 1
loadtime:0.50651788711548 / seconds
Query Executed:select id FROM `nh` where city='South Tamworth' && SIC_code='8661'DB:business_master_new
loadtime:0.50749397277832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spofford' limit 1
loadtime:0.50757884979248 / seconds
Query Executed:select id FROM `nh` where city='Spofford' && SIC_code='8661'DB:business_master_new
loadtime:0.50967693328857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.50983691215515 / seconds
Query Executed:select id FROM `nh` where city='Springfield' && SIC_code='8661'DB:business_master_new
loadtime:0.51144289970398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stark' limit 1
loadtime:0.5115339756012 / seconds
Query Executed:select id FROM `nh` where city='Stark' && SIC_code='8661'DB:business_master_new
loadtime:0.51215195655823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stewartstown' limit 1
loadtime:0.5122709274292 / seconds
Query Executed:select id FROM `nh` where city='Stewartstown' && SIC_code='8661'DB:business_master_new
loadtime:0.51291704177856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stinson Lake' limit 1
loadtime:0.51305389404297 / seconds
Query Executed:select id FROM `nh` where city='Stinson Lake' && SIC_code='8661'DB:business_master_new
loadtime:0.5136239528656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoddard' limit 1
loadtime:0.51369690895081 / seconds
Query Executed:select id FROM `nh` where city='Stoddard' && SIC_code='8661'DB:business_master_new
loadtime:0.51484990119934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strafford' limit 1
loadtime:0.51499891281128 / seconds
Query Executed:select id FROM `nh` where city='Strafford' && SIC_code='8661'DB:business_master_new
loadtime:0.51698589324951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratham' limit 1
loadtime:0.51712489128113 / seconds
Query Executed:select id FROM `nh` where city='Stratham' && SIC_code='8661'DB:business_master_new
loadtime:0.51975798606873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar Hill' limit 1
loadtime:0.51992583274841 / seconds
Query Executed:select id FROM `nh` where city='Sugar Hill' && SIC_code='8661'DB:business_master_new
loadtime:0.52123188972473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sullivan' limit 1
loadtime:0.5214250087738 / seconds
Query Executed:select id FROM `nh` where city='Sullivan' && SIC_code='8661'DB:business_master_new
loadtime:0.52260398864746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunapee' limit 1
loadtime:0.52273297309875 / seconds
Query Executed:select id FROM `nh` where city='Sunapee' && SIC_code='8661'DB:business_master_new
loadtime:0.52485203742981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suncook' limit 1
loadtime:0.52490401268005 / seconds
Query Executed:select id FROM `nh` where city='Suncook' && SIC_code='8661'DB:business_master_new
loadtime:0.52797985076904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surry' limit 1
loadtime:0.52816987037659 / seconds
Query Executed:select id FROM `nh` where city='Surry' && SIC_code='8661'DB:business_master_new
loadtime:0.52905988693237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swanzey' limit 1
loadtime:0.52921199798584 / seconds
Query Executed:select id FROM `nh` where city='Swanzey' && SIC_code='8661'DB:business_master_new
loadtime:0.53165197372437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tamworth' limit 1
loadtime:0.53180193901062 / seconds
Query Executed:select id FROM `nh` where city='Tamworth' && SIC_code='8661'DB:business_master_new
loadtime:0.5335259437561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temple' limit 1
loadtime:0.53369188308716 / seconds
Query Executed:select id FROM `nh` where city='Temple' && SIC_code='8661'DB:business_master_new
loadtime:0.53502106666565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornton' limit 1
loadtime:0.53509497642517 / seconds
Query Executed:select id FROM `nh` where city='Thornton' && SIC_code='8661'DB:business_master_new
loadtime:0.53587603569031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tilton' limit 1
loadtime:0.53592586517334 / seconds
Query Executed:select id FROM `nh` where city='Tilton' && SIC_code='8661'DB:business_master_new
loadtime:0.53774094581604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:0.53781199455261 / seconds
Query Executed:select id FROM `nh` where city='Troy' && SIC_code='8661'DB:business_master_new
loadtime:0.53935384750366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twin Mountain' limit 1
loadtime:0.53951692581177 / seconds
Query Executed:select id FROM `nh` where city='Twin Mountain' && SIC_code='8661'DB:business_master_new
loadtime:0.54109001159668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:0.54124903678894 / seconds
Query Executed:select id FROM `nh` where city='Union' && SIC_code='8661'DB:business_master_new
loadtime:0.54291892051697 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Chesterfield' limit 1
loadtime:0.54297685623169 / seconds
Query Executed:select id FROM `nh` where city='W Chesterfield' && SIC_code='8661'DB:business_master_new
loadtime:0.54343199729919 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Peterborough' limit 1
loadtime:0.54350805282593 / seconds
Query Executed:select id FROM `nh` where city='W Peterborough' && SIC_code='8661'DB:business_master_new
loadtime:0.54410886764526 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Stewartstown' limit 1
loadtime:0.54416084289551 / seconds
Query Executed:select id FROM `nh` where city='W Stewartstown' && SIC_code='8661'DB:business_master_new
loadtime:0.54515385627747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walpole' limit 1
loadtime:0.54521083831787 / seconds
Query Executed:select id FROM `nh` where city='Walpole' && SIC_code='8661'DB:business_master_new
loadtime:0.54616785049438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warner' limit 1
loadtime:0.54622793197632 / seconds
Query Executed:select id FROM `nh` where city='Warner' && SIC_code='8661'DB:business_master_new
loadtime:0.5471498966217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:0.54720902442932 / seconds
Query Executed:select id FROM `nh` where city='Warren' && SIC_code='8661'DB:business_master_new
loadtime:0.54816699028015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.54835391044617 / seconds
Query Executed:select id FROM `nh` where city='Washington' && SIC_code='8661'DB:business_master_new
loadtime:0.5498788356781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville Valley' limit 1
loadtime:0.54993200302124 / seconds
Query Executed:select id FROM `nh` where city='Waterville Valley' && SIC_code='8661'DB:business_master_new
loadtime:0.55142903327942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville Vly' limit 1
loadtime:0.55148196220398 / seconds
Query Executed:select id FROM `nh` where city='Waterville Vly' && SIC_code='8661'DB:business_master_new
loadtime:0.55202698707581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weare' limit 1
loadtime:0.55214786529541 / seconds
Query Executed:select id FROM `nh` where city='Weare' && SIC_code='8661'DB:business_master_new
loadtime:0.55414795875549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:0.55425000190735 / seconds
Query Executed:select id FROM `nh` where city='Webster' && SIC_code='8661'DB:business_master_new
loadtime:0.55515599250793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworth' limit 1
loadtime:0.55528903007507 / seconds
Query Executed:select id FROM `nh` where city='Wentworth' && SIC_code='8661'DB:business_master_new
loadtime:0.55668592453003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworths Loctn' limit 1
loadtime:0.55675196647644 / seconds
Query Executed:select id FROM `nh` where city='Wentworths Loctn' && SIC_code='8661'DB:business_master_new
loadtime:0.55725693702698 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chesterfield' limit 1
loadtime:0.55737400054932 / seconds
Query Executed:select id FROM `nh` where city='West Chesterfield' && SIC_code='8661'DB:business_master_new
loadtime:0.55864000320435 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Lebanon' limit 1
loadtime:0.55879688262939 / seconds
Query Executed:select id FROM `nh` where city='West Lebanon' && SIC_code='8661'DB:business_master_new
loadtime:0.56128287315369 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Nottingham' limit 1
loadtime:0.56145906448364 / seconds
Query Executed:select id FROM `nh` where city='West Nottingham' && SIC_code='8661'DB:business_master_new
loadtime:0.56214189529419 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Ossipee' limit 1
loadtime:0.56230592727661 / seconds
Query Executed:select id FROM `nh` where city='West Ossipee' && SIC_code='8661'DB:business_master_new
loadtime:0.56379795074463 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Peterborough' limit 1
loadtime:0.56393599510193 / seconds
Query Executed:select id FROM `nh` where city='West Peterborough' && SIC_code='8661'DB:business_master_new
loadtime:0.56447196006775 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Springfield' limit 1
loadtime:0.56456089019775 / seconds
Query Executed:select id FROM `nh` where city='West Springfield' && SIC_code='8661'DB:business_master_new
loadtime:0.56532597541809 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Stewartstown' limit 1
loadtime:0.56546783447266 / seconds
Query Executed:select id FROM `nh` where city='West Stewartstown' && SIC_code='8661'DB:business_master_new
loadtime:0.56633901596069 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Swanzey' limit 1
loadtime:0.56649303436279 / seconds
Query Executed:select id FROM `nh` where city='West Swanzey' && SIC_code='8661'DB:business_master_new
loadtime:0.56849884986877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westmoreland' limit 1
loadtime:0.56864905357361 / seconds
Query Executed:select id FROM `nh` where city='Westmoreland' && SIC_code='8661'DB:business_master_new
loadtime:0.57035088539124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitefield' limit 1
loadtime:0.57042384147644 / seconds
Query Executed:select id FROM `nh` where city='Whitefield' && SIC_code='8661'DB:business_master_new
loadtime:0.57269406318665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmot' limit 1
loadtime:0.57285594940186 / seconds
Query Executed:select id FROM `nh` where city='Wilmot' && SIC_code='8661'DB:business_master_new
loadtime:0.57453584671021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmot Flat' limit 1
loadtime:0.57464289665222 / seconds
Query Executed:select id FROM `nh` where city='Wilmot Flat' && SIC_code='8661'DB:business_master_new
loadtime:0.57503390312195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:0.57510805130005 / seconds
Query Executed:select id FROM `nh` where city='Wilton' && SIC_code='8661'DB:business_master_new
loadtime:0.57727003097534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:0.57747101783752 / seconds
Query Executed:select id FROM `nh` where city='Winchester' && SIC_code='8661'DB:business_master_new
loadtime:0.57934594154358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windham' limit 1
loadtime:0.5794620513916 / seconds
Query Executed:select id FROM `nh` where city='Windham' && SIC_code='8661'DB:business_master_new
loadtime:0.58075094223022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:0.58081197738647 / seconds
Query Executed:select id FROM `nh` where city='Windsor' && SIC_code='8661'DB:business_master_new
loadtime:0.58109188079834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winnisquam' limit 1
loadtime:0.58112788200378 / seconds
Query Executed:select id FROM `nh` where city='Winnisquam' && SIC_code='8661'DB:business_master_new
loadtime:0.5819239616394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolfeboro' limit 1
loadtime:0.58197402954102 / seconds
Query Executed:select id FROM `nh` where city='Wolfeboro' && SIC_code='8661'DB:business_master_new
loadtime:0.58325695991516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolfeboro Falls' limit 1
loadtime:0.58332395553589 / seconds
Query Executed:select id FROM `nh` where city='Wolfeboro Falls' && SIC_code='8661'DB:business_master_new
loadtime:0.58419299125671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wonalancet' limit 1
loadtime:0.58424496650696 / seconds
Query Executed:select id FROM `nh` where city='Wonalancet' && SIC_code='8661'DB:business_master_new
loadtime:0.58452987670898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:0.58456897735596 / seconds
Query Executed:select id FROM `nh` where city='Woodstock' && SIC_code='8661'DB:business_master_new
loadtime:0.58534383773804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodsville' limit 1
loadtime:0.58541297912598 / seconds
Query Executed:select id FROM `nh` where city='Woodsville' && SIC_code='8661'DB:business_master_new
loadtime:0.58734893798828 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.58765292167664 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.58793807029724 / seconds
Operation template executed (chunk cache operation)
loadtime:0.58801794052124 / seconds
template override:Default
loadtime:0.58803701400757 / 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.58957290649414 / seconds
Template Constructed, Array Rows:49
loadtime:0.59008502960205 / seconds
TOTAL EXECUTION TIME: 0.58962
loadtime:0.59032201766968 / 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] => religious-organizations [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.59032893180847
TOTAL KEY ARRAYS: 69