Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:7.7962875366211E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018548965454102 / seconds
host not found setting manual db connection
loadtime:0.010467052459717 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010709047317505 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010912895202637 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010982036590576 / seconds
zipcode:
loadtime:0.011012077331543 / seconds
Query Executed:select * from search_referrer where page_hash='255a77c136fdd7ce04438d580075fb50' limit 10 DB:ezrox_toadli
loadtime:0.011246919631958 / seconds
Operation header executed (non global)
loadtime:0.011275053024292 / seconds
Operation leaderboard executed (non global)
loadtime:0.011327028274536 / seconds
Operation square executed (non global)
loadtime:0.011355876922607 / seconds
Operation square_bottom executed (non global)
loadtime:0.011384010314941 / seconds
Operation smallsquare executed (non global)
loadtime:0.011409044265747 / seconds
Operation headeradright executed (non global)
loadtime:0.011435031890869 / seconds
Operation google_analytics executed (non global)
loadtime:0.011458873748779 / seconds
Operation topstories executed (non global)
loadtime:0.011484861373901 / seconds
Operation businessnearyou executed (non global)
loadtime:0.011512041091919 / seconds
Operation memberbuscount executed (non global)
loadtime:0.011537075042725 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.011795997619629 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.012009859085083 / seconds
Operation categories executed (global stored into APC)
loadtime:0.012052059173584 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.012115001678467 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.012163877487183 / seconds
Template key: archive_menu pushed
loadtime:0.012172937393188 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.012186050415039 / seconds
Template key: get_gravatar pushed
loadtime:0.012192964553833 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.012202024459839 / seconds
*10)-10)+1 | start:0
loadtime:0.012242078781128 / seconds
Query loaded from cache:select * from categories where cat_URLid='eating-places'
loadtime:0.01228404045105 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-hampshire'
loadtime:0.012318849563599 / seconds
DB connected to localhost business_master_new
loadtime:0.012582063674927 / seconds
Query Executed:select * from `nh_catmap` where sic='5812' order by city ascDB:business_master_new
loadtime:0.018303871154785 / seconds
Query stored in cache : _QUERY_www.toadli.com26ef2a35c37ad3dd1b1f94af56b682e8
loadtime:0.019547939300537 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-hampshire'
loadtime:0.019602060317993 / seconds
Query Executed:select sum(totalcount) as totalsum from `nh_catmap` where sic='5812'DB:business_master_new
loadtime:0.02142596244812 / seconds
Query stored in cache : _QUERY_www.toadli.comd7bec1171b664070887f4b09b22b4ac4
loadtime:0.021466016769409 / seconds
309 / 11
loadtime:0.021523952484131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acworth' limit 1
loadtime:0.021590948104858 / seconds
Query Executed:select id FROM `nh` where city='Acworth' && SIC_code='5812'DB:business_master_new
loadtime:0.022238969802856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albany' limit 1
loadtime:0.022301912307739 / seconds
Query Executed:select id FROM `nh` where city='Albany' && SIC_code='5812'DB:business_master_new
loadtime:0.022793054580688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexandria' limit 1
loadtime:0.022858858108521 / seconds
Query Executed:select id FROM `nh` where city='Alexandria' && SIC_code='5812'DB:business_master_new
loadtime:0.023298978805542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allenstown' limit 1
loadtime:0.023360013961792 / seconds
Query Executed:select id FROM `nh` where city='Allenstown' && SIC_code='5812'DB:business_master_new
loadtime:0.023833990097046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alstead' limit 1
loadtime:0.023894071578979 / seconds
Query Executed:select id FROM `nh` where city='Alstead' && SIC_code='5812'DB:business_master_new
loadtime:0.025434017181396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.02551794052124 / seconds
Query Executed:select id FROM `nh` where city='Alton' && SIC_code='5812'DB:business_master_new
loadtime:0.052304983139038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton Bay' limit 1
loadtime:0.052418947219849 / seconds
Query Executed:select id FROM `nh` where city='Alton Bay' && SIC_code='5812'DB:business_master_new
loadtime:0.053339004516602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.053423881530762 / seconds
Query Executed:select id FROM `nh` where city='Amherst' && SIC_code='5812'DB:business_master_new
loadtime:0.064635038375854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.064735889434814 / seconds
Query Executed:select id FROM `nh` where city='Andover' && SIC_code='5812'DB:business_master_new
loadtime:0.066277027130127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Antrim' limit 1
loadtime:0.066359996795654 / seconds
Query Executed:select id FROM `nh` where city='Antrim' && SIC_code='5812'DB:business_master_new
loadtime:0.068274021148682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.068351984024048 / seconds
Query Executed:select id FROM `nh` where city='Ashland' && SIC_code='5812'DB:business_master_new
loadtime:0.070374965667725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashuelot' limit 1
loadtime:0.070464849472046 / seconds
Query Executed:select id FROM `nh` where city='Ashuelot' && SIC_code='5812'DB:business_master_new
loadtime:0.071043014526367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atkinson' limit 1
loadtime:0.07110595703125 / seconds
Query Executed:select id FROM `nh` where city='Atkinson' && SIC_code='5812'DB:business_master_new
loadtime:0.097553968429565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.097643852233887 / seconds
Query Executed:select id FROM `nh` where city='Auburn' && SIC_code='5812'DB:business_master_new
loadtime:0.12362599372864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnstead' limit 1
loadtime:0.12370991706848 / seconds
Query Executed:select id FROM `nh` where city='Barnstead' && SIC_code='5812'DB:business_master_new
loadtime:0.12474393844604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barrington' limit 1
loadtime:0.12482500076294 / seconds
Query Executed:select id FROM `nh` where city='Barrington' && SIC_code='5812'DB:business_master_new
loadtime:0.15079689025879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bartlett' limit 1
loadtime:0.1508960723877 / seconds
Query Executed:select id FROM `nh` where city='Bartlett' && SIC_code='5812'DB:business_master_new
loadtime:0.15236401557922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.15244793891907 / seconds
Query Executed:select id FROM `nh` where city='Bath' && SIC_code='5812'DB:business_master_new
loadtime:0.15328097343445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.15334391593933 / seconds
Query Executed:select id FROM `nh` where city='Bedford' && SIC_code='5812'DB:business_master_new
loadtime:0.17069792747498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.17084097862244 / seconds
Query Executed:select id FROM `nh` where city='Belmont' && SIC_code='5812'DB:business_master_new
loadtime:0.17719697952271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennington' limit 1
loadtime:0.17729902267456 / seconds
Query Executed:select id FROM `nh` where city='Bennington' && SIC_code='5812'DB:business_master_new
loadtime:0.17825388908386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benton' limit 1
loadtime:0.17833495140076 / seconds
Query Executed:select id FROM `nh` where city='Benton' && SIC_code='5812'DB:business_master_new
loadtime:0.17877101898193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.17883896827698 / seconds
Query Executed:select id FROM `nh` where city='Berlin' && SIC_code='5812'DB:business_master_new
loadtime:0.18615889549255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethlehem' limit 1
loadtime:0.18625593185425 / seconds
Query Executed:select id FROM `nh` where city='Bethlehem' && SIC_code='5812'DB:business_master_new
loadtime:0.18805503845215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boscawen' limit 1
loadtime:0.18814492225647 / seconds
Query Executed:select id FROM `nh` where city='Boscawen' && SIC_code='5812'DB:business_master_new
loadtime:0.18861508369446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bow' limit 1
loadtime:0.18867802619934 / seconds
Query Executed:select id FROM `nh` where city='Bow' && SIC_code='5812'DB:business_master_new
loadtime:0.19541501998901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.19550085067749 / seconds
Query Executed:select id FROM `nh` where city='Bradford' && SIC_code='5812'DB:business_master_new
loadtime:0.19750595092773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brentwood' limit 1
loadtime:0.19758605957031 / seconds
Query Executed:select id FROM `nh` where city='Brentwood' && SIC_code='5812'DB:business_master_new
loadtime:0.19812798500061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bretton Woods' limit 1
loadtime:0.19819092750549 / seconds
Query Executed:select id FROM `nh` where city='Bretton Woods' && SIC_code='5812'DB:business_master_new
loadtime:0.19872999191284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.19880700111389 / seconds
Query Executed:select id FROM `nh` where city='Bristol' && SIC_code='5812'DB:business_master_new
loadtime:0.22569704055786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.22580599784851 / seconds
Query Executed:select id FROM `nh` where city='Brookfield' && SIC_code='5812'DB:business_master_new
loadtime:0.22629499435425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline' limit 1
loadtime:0.22635889053345 / seconds
Query Executed:select id FROM `nh` where city='Brookline' && SIC_code='5812'DB:business_master_new
loadtime:0.25228404998779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Campton' limit 1
loadtime:0.25237202644348 / seconds
Query Executed:select id FROM `nh` where city='Campton' && SIC_code='5812'DB:business_master_new
loadtime:0.27841186523438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canaan' limit 1
loadtime:0.27850794792175 / seconds
Query Executed:select id FROM `nh` where city='Canaan' && SIC_code='5812'DB:business_master_new
loadtime:0.28031396865845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Candia' limit 1
loadtime:0.28039407730103 / seconds
Query Executed:select id FROM `nh` where city='Candia' && SIC_code='5812'DB:business_master_new
loadtime:0.30639100074768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canterbury' limit 1
loadtime:0.30649185180664 / seconds
Query Executed:select id FROM `nh` where city='Canterbury' && SIC_code='5812'DB:business_master_new
loadtime:0.30819988250732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carroll' limit 1
loadtime:0.30827498435974 / seconds
Query Executed:select id FROM `nh` where city='Carroll' && SIC_code='5812'DB:business_master_new
loadtime:0.30870389938354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Barnstead' limit 1
loadtime:0.30878090858459 / seconds
Query Executed:select id FROM `nh` where city='Center Barnstead' && SIC_code='5812'DB:business_master_new
loadtime:0.31010890007019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Conway' limit 1
loadtime:0.31018805503845 / seconds
Query Executed:select id FROM `nh` where city='Center Conway' && SIC_code='5812'DB:business_master_new
loadtime:0.33632802963257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Harbor' limit 1
loadtime:0.33641386032104 / seconds
Query Executed:select id FROM `nh` where city='Center Harbor' && SIC_code='5812'DB:business_master_new
loadtime:0.36404395103455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Ossipee' limit 1
loadtime:0.36415505409241 / seconds
Query Executed:select id FROM `nh` where city='Center Ossipee' && SIC_code='5812'DB:business_master_new
loadtime:0.36614990234375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Sandwich' limit 1
loadtime:0.36624002456665 / seconds
Query Executed:select id FROM `nh` where city='Center Sandwich' && SIC_code='5812'DB:business_master_new
loadtime:0.3674168586731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Strafford' limit 1
loadtime:0.3675000667572 / seconds
Query Executed:select id FROM `nh` where city='Center Strafford' && SIC_code='5812'DB:business_master_new
loadtime:0.36805891990662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Tuftonboro' limit 1
loadtime:0.36813497543335 / seconds
Query Executed:select id FROM `nh` where city='Center Tuftonboro' && SIC_code='5812'DB:business_master_new
loadtime:0.36899995803833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlestown' limit 1
loadtime:0.3690619468689 / seconds
Query Executed:select id FROM `nh` where city='Charlestown' && SIC_code='5812'DB:business_master_new
loadtime:0.39614391326904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:0.39623188972473 / seconds
Query Executed:select id FROM `nh` where city='Chatham' && SIC_code='5812'DB:business_master_new
loadtime:0.39673900604248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.396803855896 / seconds
Query Executed:select id FROM `nh` where city='Chester' && SIC_code='5812'DB:business_master_new
loadtime:0.42313098907471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:0.42321991920471 / seconds
Query Executed:select id FROM `nh` where city='Chesterfield' && SIC_code='5812'DB:business_master_new
loadtime:0.42439985275269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chichester' limit 1
loadtime:0.4244749546051 / seconds
Query Executed:select id FROM `nh` where city='Chichester' && SIC_code='5812'DB:business_master_new
loadtime:0.42617893218994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chocorua' limit 1
loadtime:0.42626595497131 / seconds
Query Executed:select id FROM `nh` where city='Chocorua' && SIC_code='5812'DB:business_master_new
loadtime:0.42712306976318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:0.42719888687134 / seconds
Query Executed:select id FROM `nh` where city='Claremont' && SIC_code='5812'DB:business_master_new
loadtime:0.43844294548035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksville' limit 1
loadtime:0.43857407569885 / seconds
Query Executed:select id FROM `nh` where city='Clarksville' && SIC_code='5812'DB:business_master_new
loadtime:0.43908095359802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colebrook' limit 1
loadtime:0.43915295600891 / seconds
Query Executed:select id FROM `nh` where city='Colebrook' && SIC_code='5812'DB:business_master_new
loadtime:0.46616005897522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.46626400947571 / seconds
Query Executed:select id FROM `nh` where city='Concord' && SIC_code='5812'DB:business_master_new
loadtime:0.50578904151917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Contoocook' limit 1
loadtime:0.50609707832336 / seconds
Query Executed:select id FROM `nh` where city='Contoocook' && SIC_code='5812'DB:business_master_new
loadtime:0.53300595283508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.53311204910278 / seconds
Query Executed:select id FROM `nh` where city='Conway' && SIC_code='5812'DB:business_master_new
loadtime:0.559406042099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornish' limit 1
loadtime:0.5595178604126 / seconds
Query Executed:select id FROM `nh` where city='Cornish' && SIC_code='5812'DB:business_master_new
loadtime:0.56043386459351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornish Flat' limit 1
loadtime:0.56049799919128 / seconds
Query Executed:select id FROM `nh` where city='Cornish Flat' && SIC_code='5812'DB:business_master_new
loadtime:0.56109285354614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Croydon' limit 1
loadtime:0.56115794181824 / seconds
Query Executed:select id FROM `nh` where city='Croydon' && SIC_code='5812'DB:business_master_new
loadtime:0.56161499023438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ctr Tuftonboro' limit 1
loadtime:0.56167602539062 / seconds
Query Executed:select id FROM `nh` where city='Ctr Tuftonboro' && SIC_code='5812'DB:business_master_new
loadtime:0.56212592124939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dalton' limit 1
loadtime:0.56218695640564 / seconds
Query Executed:select id FROM `nh` where city='Dalton' && SIC_code='5812'DB:business_master_new
loadtime:0.56262493133545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:0.56269001960754 / seconds
Query Executed:select id FROM `nh` where city='Danbury' && SIC_code='5812'DB:business_master_new
loadtime:0.56369400024414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.56375503540039 / seconds
Query Executed:select id FROM `nh` where city='Danville' && SIC_code='5812'DB:business_master_new
loadtime:0.56517386436462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:0.56523489952087 / seconds
Query Executed:select id FROM `nh` where city='Deerfield' && SIC_code='5812'DB:business_master_new
loadtime:0.56732988357544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deering' limit 1
loadtime:0.56740689277649 / seconds
Query Executed:select id FROM `nh` where city='Deering' && SIC_code='5812'DB:business_master_new
loadtime:0.56789588928223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derry' limit 1
loadtime:0.56795787811279 / seconds
Query Executed:select id FROM `nh` where city='Derry' && SIC_code='5812'DB:business_master_new
loadtime:0.5838348865509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:0.58399796485901 / seconds
Query Executed:select id FROM `nh` where city='Dorchester' && SIC_code='5812'DB:business_master_new
loadtime:0.5844419002533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dover' limit 1
loadtime:0.58451104164124 / seconds
Query Executed:select id FROM `nh` where city='Dover' && SIC_code='5812'DB:business_master_new
loadtime:0.60374093055725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drewsville' limit 1
loadtime:0.60395407676697 / seconds
Query Executed:select id FROM `nh` where city='Drewsville' && SIC_code='5812'DB:business_master_new
loadtime:0.60438108444214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dublin' limit 1
loadtime:0.60445189476013 / seconds
Query Executed:select id FROM `nh` where city='Dublin' && SIC_code='5812'DB:business_master_new
loadtime:0.6057710647583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dummer' limit 1
loadtime:0.60585999488831 / seconds
Query Executed:select id FROM `nh` where city='Dummer' && SIC_code='5812'DB:business_master_new
loadtime:0.6062970161438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunbarton' limit 1
loadtime:0.60636401176453 / seconds
Query Executed:select id FROM `nh` where city='Dunbarton' && SIC_code='5812'DB:business_master_new
loadtime:0.60770606994629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durham' limit 1
loadtime:0.6077709197998 / seconds
Query Executed:select id FROM `nh` where city='Durham' && SIC_code='5812'DB:business_master_new
loadtime:0.61509299278259 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Andover' limit 1
loadtime:0.61520099639893 / seconds
Query Executed:select id FROM `nh` where city='East Andover' && SIC_code='5812'DB:business_master_new
loadtime:0.61575698852539 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Candia' limit 1
loadtime:0.61582899093628 / seconds
Query Executed:select id FROM `nh` where city='East Candia' && SIC_code='5812'DB:business_master_new
loadtime:0.61627888679504 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Derry' limit 1
loadtime:0.61634397506714 / seconds
Query Executed:select id FROM `nh` where city='East Derry' && SIC_code='5812'DB:business_master_new
loadtime:0.61711096763611 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hampstead' limit 1
loadtime:0.61717796325684 / seconds
Query Executed:select id FROM `nh` where city='East Hampstead' && SIC_code='5812'DB:business_master_new
loadtime:0.61884093284607 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hebron' limit 1
loadtime:0.61892986297607 / seconds
Query Executed:select id FROM `nh` where city='East Hebron' && SIC_code='5812'DB:business_master_new
loadtime:0.61940598487854 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Kingston' limit 1
loadtime:0.61946892738342 / seconds
Query Executed:select id FROM `nh` where city='East Kingston' && SIC_code='5812'DB:business_master_new
loadtime:0.62133002281189 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Swanzey' limit 1
loadtime:0.62140798568726 / seconds
Query Executed:select id FROM `nh` where city='East Swanzey' && SIC_code='5812'DB:business_master_new
loadtime:0.6218729019165 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Wakefield' limit 1
loadtime:0.62193489074707 / seconds
Query Executed:select id FROM `nh` where city='East Wakefield' && SIC_code='5812'DB:business_master_new
loadtime:0.622722864151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eaton Center' limit 1
loadtime:0.62280106544495 / seconds
Query Executed:select id FROM `nh` where city='Eaton Center' && SIC_code='5812'DB:business_master_new
loadtime:0.62349200248718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Effingham' limit 1
loadtime:0.62356805801392 / seconds
Query Executed:select id FROM `nh` where city='Effingham' && SIC_code='5812'DB:business_master_new
loadtime:0.62419199943542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkins' limit 1
loadtime:0.62425994873047 / seconds
Query Executed:select id FROM `nh` where city='Elkins' && SIC_code='5812'DB:business_master_new
loadtime:0.62481999397278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth' limit 1
loadtime:0.62488293647766 / seconds
Query Executed:select id FROM `nh` where city='Ellsworth' && SIC_code='5812'DB:business_master_new
loadtime:0.62528204917908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enfield' limit 1
loadtime:0.62534689903259 / seconds
Query Executed:select id FROM `nh` where city='Enfield' && SIC_code='5812'DB:business_master_new
loadtime:0.62744402885437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enfield Center' limit 1
loadtime:0.62752604484558 / seconds
Query Executed:select id FROM `nh` where city='Enfield Center' && SIC_code='5812'DB:business_master_new
loadtime:0.62802195549011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Epping' limit 1
loadtime:0.62808895111084 / seconds
Query Executed:select id FROM `nh` where city='Epping' && SIC_code='5812'DB:business_master_new
loadtime:0.65486907958984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Epsom' limit 1
loadtime:0.65497994422913 / seconds
Query Executed:select id FROM `nh` where city='Epsom' && SIC_code='5812'DB:business_master_new
loadtime:0.68104386329651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Errol' limit 1
loadtime:0.68113899230957 / seconds
Query Executed:select id FROM `nh` where city='Errol' && SIC_code='5812'DB:business_master_new
loadtime:0.68207693099976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Etna' limit 1
loadtime:0.68215489387512 / seconds
Query Executed:select id FROM `nh` where city='Etna' && SIC_code='5812'DB:business_master_new
loadtime:0.68302202224731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exeter' limit 1
loadtime:0.68308401107788 / seconds
Query Executed:select id FROM `nh` where city='Exeter' && SIC_code='5812'DB:business_master_new
loadtime:0.69859886169434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.69873285293579 / seconds
Query Executed:select id FROM `nh` where city='Farmington' && SIC_code='5812'DB:business_master_new
loadtime:0.7250828742981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fitzwilliam' limit 1
loadtime:0.72517895698547 / seconds
Query Executed:select id FROM `nh` where city='Fitzwilliam' && SIC_code='5812'DB:business_master_new
loadtime:0.72678208351135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Francestown' limit 1
loadtime:0.72686791419983 / seconds
Query Executed:select id FROM `nh` where city='Francestown' && SIC_code='5812'DB:business_master_new
loadtime:0.72813487052917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franconia' limit 1
loadtime:0.72819995880127 / seconds
Query Executed:select id FROM `nh` where city='Franconia' && SIC_code='5812'DB:business_master_new
loadtime:0.73008990287781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.7301709651947 / seconds
Query Executed:select id FROM `nh` where city='Franklin' && SIC_code='5812'DB:business_master_new
loadtime:0.75638389587402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freedom' limit 1
loadtime:0.75647687911987 / seconds
Query Executed:select id FROM `nh` where city='Freedom' && SIC_code='5812'DB:business_master_new
loadtime:0.75768399238586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fremont' limit 1
loadtime:0.75774693489075 / seconds
Query Executed:select id FROM `nh` where city='Fremont' && SIC_code='5812'DB:business_master_new
loadtime:0.75953602790833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georges Mills' limit 1
loadtime:0.75962400436401 / seconds
Query Executed:select id FROM `nh` where city='Georges Mills' && SIC_code='5812'DB:business_master_new
loadtime:0.76038289070129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilford' limit 1
loadtime:0.76044702529907 / seconds
Query Executed:select id FROM `nh` where city='Gilford' && SIC_code='5812'DB:business_master_new
loadtime:0.76806807518005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilmanton' limit 1
loadtime:0.76817107200623 / seconds
Query Executed:select id FROM `nh` where city='Gilmanton' && SIC_code='5812'DB:business_master_new
loadtime:0.76956295967102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilmanton Iron Works' limit 1
loadtime:0.76964902877808 / seconds
Query Executed:select id FROM `nh` where city='Gilmanton Iron Works' && SIC_code='5812'DB:business_master_new
loadtime:0.77048301696777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilsum' limit 1
loadtime:0.77054595947266 / seconds
Query Executed:select id FROM `nh` where city='Gilsum' && SIC_code='5812'DB:business_master_new
loadtime:0.77132105827332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen' limit 1
loadtime:0.771399974823 / seconds
Query Executed:select id FROM `nh` where city='Glen' && SIC_code='5812'DB:business_master_new
loadtime:0.77263903617859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glencliff' limit 1
loadtime:0.77273297309875 / seconds
Query Executed:select id FROM `nh` where city='Glencliff' && SIC_code='5812'DB:business_master_new
loadtime:0.77326488494873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glmntn Iron Wks' limit 1
loadtime:0.77332997322083 / seconds
Query Executed:select id FROM `nh` where city='Glmntn Iron Wks' && SIC_code='5812'DB:business_master_new
loadtime:0.7737410068512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goffstown' limit 1
loadtime:0.77380394935608 / seconds
Query Executed:select id FROM `nh` where city='Goffstown' && SIC_code='5812'DB:business_master_new
loadtime:0.78236603736877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gorham' limit 1
loadtime:0.7824649810791 / seconds
Query Executed:select id FROM `nh` where city='Gorham' && SIC_code='5812'DB:business_master_new
loadtime:0.80895185470581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.80906701087952 / seconds
Query Executed:select id FROM `nh` where city='Goshen' && SIC_code='5812'DB:business_master_new
loadtime:0.80990791320801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.80998492240906 / seconds
Query Executed:select id FROM `nh` where city='Grafton' && SIC_code='5812'DB:business_master_new
loadtime:0.8107590675354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grantham' limit 1
loadtime:0.8108389377594 / seconds
Query Executed:select id FROM `nh` where city='Grantham' && SIC_code='5812'DB:business_master_new
loadtime:0.81279897689819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenfield' limit 1
loadtime:0.8128809928894 / seconds
Query Executed:select id FROM `nh` where city='Greenfield' && SIC_code='5812'DB:business_master_new
loadtime:0.81409502029419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenland' limit 1
loadtime:0.81416988372803 / seconds
Query Executed:select id FROM `nh` where city='Greenland' && SIC_code='5812'DB:business_master_new
loadtime:0.8403000831604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.84039402008057 / seconds
Query Executed:select id FROM `nh` where city='Greenville' && SIC_code='5812'DB:business_master_new
loadtime:0.8425190448761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groveton' limit 1
loadtime:0.84260606765747 / seconds
Query Executed:select id FROM `nh` where city='Groveton' && SIC_code='5812'DB:business_master_new
loadtime:0.84424805641174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guild' limit 1
loadtime:0.84432601928711 / seconds
Query Executed:select id FROM `nh` where city='Guild' && SIC_code='5812'DB:business_master_new
loadtime:0.84486198425293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hales Location' limit 1
loadtime:0.84492802619934 / seconds
Query Executed:select id FROM `nh` where city='Hales Location' && SIC_code='5812'DB:business_master_new
loadtime:0.84531903266907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampstead' limit 1
loadtime:0.84537887573242 / seconds
Query Executed:select id FROM `nh` where city='Hampstead' && SIC_code='5812'DB:business_master_new
loadtime:0.87150907516479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:0.87159991264343 / seconds
Query Executed:select id FROM `nh` where city='Hampton' && SIC_code='5812'DB:business_master_new
loadtime:0.88517594337463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton Falls' limit 1
loadtime:0.88534593582153 / seconds
Query Executed:select id FROM `nh` where city='Hampton Falls' && SIC_code='5812'DB:business_master_new
loadtime:0.91147398948669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:0.91156888008118 / seconds
Query Executed:select id FROM `nh` where city='Hancock' && SIC_code='5812'DB:business_master_new
loadtime:0.91312789916992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.9132080078125 / seconds
Query Executed:select id FROM `nh` where city='Hanover' && SIC_code='5812'DB:business_master_new
loadtime:0.92073607444763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisville' limit 1
loadtime:0.92085886001587 / seconds
Query Executed:select id FROM `nh` where city='Harrisville' && SIC_code='5812'DB:business_master_new
loadtime:0.92180204391479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harts Location' limit 1
loadtime:0.92188405990601 / seconds
Query Executed:select id FROM `nh` where city='Harts Location' && SIC_code='5812'DB:business_master_new
loadtime:0.92229700088501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haverhill' limit 1
loadtime:0.92235994338989 / seconds
Query Executed:select id FROM `nh` where city='Haverhill' && SIC_code='5812'DB:business_master_new
loadtime:0.92301297187805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hebron' limit 1
loadtime:0.9230740070343 / seconds
Query Executed:select id FROM `nh` where city='Hebron' && SIC_code='5812'DB:business_master_new
loadtime:0.92388486862183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henniker' limit 1
loadtime:0.92395186424255 / seconds
Query Executed:select id FROM `nh` where city='Henniker' && SIC_code='5812'DB:business_master_new
loadtime:0.95056891441345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hill' limit 1
loadtime:0.95067095756531 / seconds
Query Executed:select id FROM `nh` where city='Hill' && SIC_code='5812'DB:business_master_new
loadtime:0.95153307914734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:0.95159697532654 / seconds
Query Executed:select id FROM `nh` where city='Hillsboro' && SIC_code='5812'DB:business_master_new
loadtime:0.95239686965942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsborough' limit 1
loadtime:0.95247387886047 / seconds
Query Executed:select id FROM `nh` where city='Hillsborough' && SIC_code='5812'DB:business_master_new
loadtime:0.97860789299011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinsdale' limit 1
loadtime:0.97870707511902 / seconds
Query Executed:select id FROM `nh` where city='Hinsdale' && SIC_code='5812'DB:business_master_new
loadtime:0.98036789894104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holderness' limit 1
loadtime:0.98044991493225 / seconds
Query Executed:select id FROM `nh` where city='Holderness' && SIC_code='5812'DB:business_master_new
loadtime:0.98188090324402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollis' limit 1
loadtime:0.9819610118866 / seconds
Query Executed:select id FROM `nh` where city='Hollis' && SIC_code='5812'DB:business_master_new
loadtime:1.0081920623779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hooksett' limit 1
loadtime:1.0082850456238 / seconds
Query Executed:select id FROM `nh` where city='Hooksett' && SIC_code='5812'DB:business_master_new
loadtime:1.019152879715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkinton' limit 1
loadtime:1.0192730426788 / seconds
Query Executed:select id FROM `nh` where city='Hopkinton' && SIC_code='5812'DB:business_master_new
loadtime:1.0198528766632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:1.019917011261 / seconds
Query Executed:select id FROM `nh` where city='Hudson' && SIC_code='5812'DB:business_master_new
loadtime:1.0339388847351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Intervale' limit 1
loadtime:1.0340929031372 / seconds
Query Executed:select id FROM `nh` where city='Intervale' && SIC_code='5812'DB:business_master_new
loadtime:1.0353329181671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:1.0354180335999 / seconds
Query Executed:select id FROM `nh` where city='Jackson' && SIC_code='5812'DB:business_master_new
loadtime:1.036917924881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jaffrey' limit 1
loadtime:1.037015914917 / seconds
Query Executed:select id FROM `nh` where city='Jaffrey' && SIC_code='5812'DB:business_master_new
loadtime:1.0635330677032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:1.0636298656464 / seconds
Query Executed:select id FROM `nh` where city='Jefferson' && SIC_code='5812'DB:business_master_new
loadtime:1.0647859573364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kearsarge' limit 1
loadtime:1.064868927002 / seconds
Query Executed:select id FROM `nh` where city='Kearsarge' && SIC_code='5812'DB:business_master_new
loadtime:1.0653600692749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keene' limit 1
loadtime:1.0654220581055 / seconds
Query Executed:select id FROM `nh` where city='Keene' && SIC_code='5812'DB:business_master_new
loadtime:1.0851159095764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kensington' limit 1
loadtime:1.0853140354156 / seconds
Query Executed:select id FROM `nh` where city='Kensington' && SIC_code='5812'DB:business_master_new
loadtime:1.0857949256897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:1.0858728885651 / seconds
Query Executed:select id FROM `nh` where city='Kingston' && SIC_code='5812'DB:business_master_new
loadtime:1.1123878955841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laconia' limit 1
loadtime:1.11248087883 / seconds
Query Executed:select id FROM `nh` where city='Laconia' && SIC_code='5812'DB:business_master_new
loadtime:1.1289489269257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:1.1291389465332 / seconds
Query Executed:select id FROM `nh` where city='Lancaster' && SIC_code='5812'DB:business_master_new
loadtime:1.1555850505829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Landaff' limit 1
loadtime:1.1556918621063 / seconds
Query Executed:select id FROM `nh` where city='Landaff' && SIC_code='5812'DB:business_master_new
loadtime:1.1561698913574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langdon' limit 1
loadtime:1.1562349796295 / seconds
Query Executed:select id FROM `nh` where city='Langdon' && SIC_code='5812'DB:business_master_new
loadtime:1.1567130088806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:1.156772851944 / seconds
Query Executed:select id FROM `nh` where city='Lebanon' && SIC_code='5812'DB:business_master_new
loadtime:1.1668548583984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lee' limit 1
loadtime:1.166953086853 / seconds
Query Executed:select id FROM `nh` where city='Lee' && SIC_code='5812'DB:business_master_new
loadtime:1.1683678627014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lempster' limit 1
loadtime:1.1684520244598 / seconds
Query Executed:select id FROM `nh` where city='Lempster' && SIC_code='5812'DB:business_master_new
loadtime:1.1693019866943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:1.1693649291992 / seconds
Query Executed:select id FROM `nh` where city='Lincoln' && SIC_code='5812'DB:business_master_new
loadtime:1.1957669258118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lisbon' limit 1
loadtime:1.1958930492401 / seconds
Query Executed:select id FROM `nh` where city='Lisbon' && SIC_code='5812'DB:business_master_new
loadtime:1.2217860221863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield' limit 1
loadtime:1.2218768596649 / seconds
Query Executed:select id FROM `nh` where city='Litchfield' && SIC_code='5812'DB:business_master_new
loadtime:1.2477378845215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littleton' limit 1
loadtime:1.2478270530701 / seconds
Query Executed:select id FROM `nh` where city='Littleton' && SIC_code='5812'DB:business_master_new
loadtime:1.2564599514008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lochmere' limit 1
loadtime:1.2565770149231 / seconds
Query Executed:select id FROM `nh` where city='Lochmere' && SIC_code='5812'DB:business_master_new
loadtime:1.2571380138397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Londonderry' limit 1
loadtime:1.2572169303894 / seconds
Query Executed:select id FROM `nh` where city='Londonderry' && SIC_code='5812'DB:business_master_new
loadtime:1.2738699913025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loudon' limit 1
loadtime:1.2740180492401 / seconds
Query Executed:select id FROM `nh` where city='Loudon' && SIC_code='5812'DB:business_master_new
loadtime:1.2786939144135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyman' limit 1
loadtime:1.2787799835205 / seconds
Query Executed:select id FROM `nh` where city='Lyman' && SIC_code='5812'DB:business_master_new
loadtime:1.2791850566864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyme' limit 1
loadtime:1.279247045517 / seconds
Query Executed:select id FROM `nh` where city='Lyme' && SIC_code='5812'DB:business_master_new
loadtime:1.3053109645844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyme Center' limit 1
loadtime:1.3053920269012 / seconds
Query Executed:select id FROM `nh` where city='Lyme Center' && SIC_code='5812'DB:business_master_new
loadtime:1.3058409690857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndeborough' limit 1
loadtime:1.3059120178223 / seconds
Query Executed:select id FROM `nh` where city='Lyndeborough' && SIC_code='5812'DB:business_master_new
loadtime:1.3316190242767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madbury' limit 1
loadtime:1.3316979408264 / seconds
Query Executed:select id FROM `nh` where city='Madbury' && SIC_code='5812'DB:business_master_new
loadtime:1.332524061203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:1.3325860500336 / seconds
Query Executed:select id FROM `nh` where city='Madison' && SIC_code='5812'DB:business_master_new
loadtime:1.3337700366974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:1.3338499069214 / seconds
Query Executed:select id FROM `nh` where city='Manchester' && SIC_code='5812'DB:business_master_new
loadtime:1.3630380630493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlborough' limit 1
loadtime:1.363550901413 / seconds
Query Executed:select id FROM `nh` where city='Marlborough' && SIC_code='5812'DB:business_master_new
loadtime:1.389641046524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlow' limit 1
loadtime:1.3897640705109 / seconds
Query Executed:select id FROM `nh` where city='Marlow' && SIC_code='5812'DB:business_master_new
loadtime:1.3904609680176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mason' limit 1
loadtime:1.3905229568481 / seconds
Query Executed:select id FROM `nh` where city='Mason' && SIC_code='5812'DB:business_master_new
loadtime:1.3909850120544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadows' limit 1
loadtime:1.3910539150238 / seconds
Query Executed:select id FROM `nh` where city='Meadows' && SIC_code='5812'DB:business_master_new
loadtime:1.3914589881897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melvin Village' limit 1
loadtime:1.3915190696716 / seconds
Query Executed:select id FROM `nh` where city='Melvin Village' && SIC_code='5812'DB:business_master_new
loadtime:1.3922228813171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meredith' limit 1
loadtime:1.3922839164734 / seconds
Query Executed:select id FROM `nh` where city='Meredith' && SIC_code='5812'DB:business_master_new
loadtime:1.4004368782043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meriden' limit 1
loadtime:1.400554895401 / seconds
Query Executed:select id FROM `nh` where city='Meriden' && SIC_code='5812'DB:business_master_new
loadtime:1.4013659954071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrimack' limit 1
loadtime:1.4014310836792 / seconds
Query Executed:select id FROM `nh` where city='Merrimack' && SIC_code='5812'DB:business_master_new
loadtime:1.4164869785309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleton' limit 1
loadtime:1.4166429042816 / seconds
Query Executed:select id FROM `nh` where city='Middleton' && SIC_code='5812'DB:business_master_new
loadtime:1.4170949459076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milan' limit 1
loadtime:1.4171628952026 / seconds
Query Executed:select id FROM `nh` where city='Milan' && SIC_code='5812'DB:business_master_new
loadtime:1.4181389808655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:1.4182150363922 / seconds
Query Executed:select id FROM `nh` where city='Milford' && SIC_code='5812'DB:business_master_new
loadtime:1.4292409420013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:1.4293820858002 / seconds
Query Executed:select id FROM `nh` where city='Milton' && SIC_code='5812'DB:business_master_new
loadtime:1.4557189941406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton Mills' limit 1
loadtime:1.4558200836182 / seconds
Query Executed:select id FROM `nh` where city='Milton Mills' && SIC_code='5812'DB:business_master_new
loadtime:1.4564518928528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mirror Lake' limit 1
loadtime:1.4565269947052 / seconds
Query Executed:select id FROM `nh` where city='Mirror Lake' && SIC_code='5812'DB:business_master_new
loadtime:1.4573049545288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:1.4573669433594 / seconds
Query Executed:select id FROM `nh` where city='Monroe' && SIC_code='5812'DB:business_master_new
loadtime:1.4581429958344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mont Vernon' limit 1
loadtime:1.4582049846649 / seconds
Query Executed:select id FROM `nh` where city='Mont Vernon' && SIC_code='5812'DB:business_master_new
loadtime:1.4594678878784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moultonborough' limit 1
loadtime:1.4595420360565 / seconds
Query Executed:select id FROM `nh` where city='Moultonborough' && SIC_code='5812'DB:business_master_new
loadtime:1.485641002655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Sunapee' limit 1
loadtime:1.4857439994812 / seconds
Query Executed:select id FROM `nh` where city='Mt Sunapee' && SIC_code='5812'DB:business_master_new
loadtime:1.486163854599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munsonville' limit 1
loadtime:1.4862270355225 / seconds
Query Executed:select id FROM `nh` where city='Munsonville' && SIC_code='5812'DB:business_master_new
loadtime:1.4867000579834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashua' limit 1
loadtime:1.4867649078369 / seconds
Query Executed:select id FROM `nh` where city='Nashua' && SIC_code='5812'DB:business_master_new
loadtime:1.5354330539703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelson' limit 1
loadtime:1.5358259677887 / seconds
Query Executed:select id FROM `nh` where city='Nelson' && SIC_code='5812'DB:business_master_new
loadtime:1.5364789962769 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Boston' limit 1
loadtime:1.5365600585938 / seconds
Query Executed:select id FROM `nh` where city='New Boston' && SIC_code='5812'DB:business_master_new
loadtime:1.5631930828094 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Castle' limit 1
loadtime:1.5632779598236 / seconds
Query Executed:select id FROM `nh` where city='New Castle' && SIC_code='5812'DB:business_master_new
loadtime:1.5642499923706 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Durham' limit 1
loadtime:1.5643270015717 / seconds
Query Executed:select id FROM `nh` where city='New Durham' && SIC_code='5812'DB:business_master_new
loadtime:1.5657088756561 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hampton' limit 1
loadtime:1.5657870769501 / seconds
Query Executed:select id FROM `nh` where city='New Hampton' && SIC_code='5812'DB:business_master_new
loadtime:1.5674428939819 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Ipswich' limit 1
loadtime:1.5675239562988 / seconds
Query Executed:select id FROM `nh` where city='New Ipswich' && SIC_code='5812'DB:business_master_new
loadtime:1.5935549736023 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:1.5936419963837 / seconds
Query Executed:select id FROM `nh` where city='New London' && SIC_code='5812'DB:business_master_new
loadtime:1.6010320186615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbury' limit 1
loadtime:1.6011390686035 / seconds
Query Executed:select id FROM `nh` where city='Newbury' && SIC_code='5812'DB:business_master_new
loadtime:1.6024489402771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newfields' limit 1
loadtime:1.6025290489197 / seconds
Query Executed:select id FROM `nh` where city='Newfields' && SIC_code='5812'DB:business_master_new
loadtime:1.6037600040436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newington' limit 1
loadtime:1.6038498878479 / seconds
Query Executed:select id FROM `nh` where city='Newington' && SIC_code='5812'DB:business_master_new
loadtime:1.6043639183044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newmarket' limit 1
loadtime:1.604425907135 / seconds
Query Executed:select id FROM `nh` where city='Newmarket' && SIC_code='5812'DB:business_master_new
loadtime:1.6307609081268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:1.6308739185333 / seconds
Query Executed:select id FROM `nh` where city='Newport' && SIC_code='5812'DB:business_master_new
loadtime:1.6381268501282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:1.6382300853729 / seconds
Query Executed:select id FROM `nh` where city='Newton' && SIC_code='5812'DB:business_master_new
loadtime:1.6400818824768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Junction' limit 1
loadtime:1.6401600837708 / seconds
Query Executed:select id FROM `nh` where city='Newton Junction' && SIC_code='5812'DB:business_master_new
loadtime:1.6407079696655 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Conway' limit 1
loadtime:1.6407699584961 / seconds
Query Executed:select id FROM `nh` where city='North Conway' && SIC_code='5812'DB:business_master_new
loadtime:1.6504590511322 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hampton' limit 1
loadtime:1.6506309509277 / seconds
Query Executed:select id FROM `nh` where city='North Hampton' && SIC_code='5812'DB:business_master_new
loadtime:1.658164024353 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Haverhill' limit 1
loadtime:1.6582770347595 / seconds
Query Executed:select id FROM `nh` where city='North Haverhill' && SIC_code='5812'DB:business_master_new
loadtime:1.6599559783936 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Salem' limit 1
loadtime:1.6600480079651 / seconds
Query Executed:select id FROM `nh` where city='North Salem' && SIC_code='5812'DB:business_master_new
loadtime:1.6608228683472 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Sandwich' limit 1
loadtime:1.6608870029449 / seconds
Query Executed:select id FROM `nh` where city='North Sandwich' && SIC_code='5812'DB:business_master_new
loadtime:1.6615500450134 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Stratford' limit 1
loadtime:1.6616249084473 / seconds
Query Executed:select id FROM `nh` where city='North Stratford' && SIC_code='5812'DB:business_master_new
loadtime:1.6624698638916 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Sutton' limit 1
loadtime:1.6625468730927 / seconds
Query Executed:select id FROM `nh` where city='North Sutton' && SIC_code='5812'DB:business_master_new
loadtime:1.6633999347687 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Walpole' limit 1
loadtime:1.6634628772736 / seconds
Query Executed:select id FROM `nh` where city='North Walpole' && SIC_code='5812'DB:business_master_new
loadtime:1.6642689704895 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Woodstock' limit 1
loadtime:1.6643509864807 / seconds
Query Executed:select id FROM `nh` where city='North Woodstock' && SIC_code='5812'DB:business_master_new
loadtime:1.6657960414886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:1.665885925293 / seconds
Query Executed:select id FROM `nh` where city='Northfield' && SIC_code='5812'DB:business_master_new
loadtime:1.666384935379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northwood' limit 1
loadtime:1.6664478778839 / seconds
Query Executed:select id FROM `nh` where city='Northwood' && SIC_code='5812'DB:business_master_new
loadtime:1.6928310394287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nottingham' limit 1
loadtime:1.6929190158844 / seconds
Query Executed:select id FROM `nh` where city='Nottingham' && SIC_code='5812'DB:business_master_new
loadtime:1.694580078125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:1.6946549415588 / seconds
Query Executed:select id FROM `nh` where city='Orange' && SIC_code='5812'DB:business_master_new
loadtime:1.6951138973236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orford' limit 1
loadtime:1.6951749324799 / seconds
Query Executed:select id FROM `nh` where city='Orford' && SIC_code='5812'DB:business_master_new
loadtime:1.6963920593262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ossipee' limit 1
loadtime:1.6964700222015 / seconds
Query Executed:select id FROM `nh` where city='Ossipee' && SIC_code='5812'DB:business_master_new
loadtime:1.7225589752197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelham' limit 1
loadtime:1.7226479053497 / seconds
Query Executed:select id FROM `nh` where city='Pelham' && SIC_code='5812'DB:business_master_new
loadtime:1.7304139137268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:1.7305090427399 / seconds
Query Executed:select id FROM `nh` where city='Pembroke' && SIC_code='5812'DB:business_master_new
loadtime:1.7310259342194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penacook' limit 1
loadtime:1.7310900688171 / seconds
Query Executed:select id FROM `nh` where city='Penacook' && SIC_code='5812'DB:business_master_new
loadtime:1.7315490245819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peterborough' limit 1
loadtime:1.7316160202026 / seconds
Query Executed:select id FROM `nh` where city='Peterborough' && SIC_code='5812'DB:business_master_new
loadtime:1.7402150630951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piermont' limit 1
loadtime:1.7403149604797 / seconds
Query Executed:select id FROM `nh` where city='Piermont' && SIC_code='5812'DB:business_master_new
loadtime:1.7411589622498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pike' limit 1
loadtime:1.7412278652191 / seconds
Query Executed:select id FROM `nh` where city='Pike' && SIC_code='5812'DB:business_master_new
loadtime:1.741760969162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsburg' limit 1
loadtime:1.741828918457 / seconds
Query Executed:select id FROM `nh` where city='Pittsburg' && SIC_code='5812'DB:business_master_new
loadtime:1.7431449890137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsfield' limit 1
loadtime:1.7432260513306 / seconds
Query Executed:select id FROM `nh` where city='Pittsfield' && SIC_code='5812'DB:business_master_new
loadtime:1.7693438529968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:1.7694339752197 / seconds
Query Executed:select id FROM `nh` where city='Plainfield' && SIC_code='5812'DB:business_master_new
loadtime:1.7706480026245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plaistow' limit 1
loadtime:1.7707250118256 / seconds
Query Executed:select id FROM `nh` where city='Plaistow' && SIC_code='5812'DB:business_master_new
loadtime:1.7799210548401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:1.7800369262695 / seconds
Query Executed:select id FROM `nh` where city='Plymouth' && SIC_code='5812'DB:business_master_new
loadtime:1.7876420021057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portsmouth' limit 1
loadtime:1.7877600193024 / seconds
Query Executed:select id FROM `nh` where city='Portsmouth' && SIC_code='5812'DB:business_master_new
loadtime:1.8230390548706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:1.8233859539032 / seconds
Query Executed:select id FROM `nh` where city='Randolph' && SIC_code='5812'DB:business_master_new
loadtime:1.8239190578461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:1.8240120410919 / seconds
Query Executed:select id FROM `nh` where city='Raymond' && SIC_code='5812'DB:business_master_new
loadtime:1.8508930206299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:1.8510029315948 / seconds
Query Executed:select id FROM `nh` where city='Richmond' && SIC_code='5812'DB:business_master_new
loadtime:1.8514580726624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rindge' limit 1
loadtime:1.8515219688416 / seconds
Query Executed:select id FROM `nh` where city='Rindge' && SIC_code='5812'DB:business_master_new
loadtime:1.8775889873505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:1.8776869773865 / seconds
Query Executed:select id FROM `nh` where city='Rochester' && SIC_code='5812'DB:business_master_new
loadtime:1.893826007843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rollinsford' limit 1
loadtime:1.8940670490265 / seconds
Query Executed:select id FROM `nh` where city='Rollinsford' && SIC_code='5812'DB:business_master_new
loadtime:1.8956038951874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:1.8956909179688 / seconds
Query Executed:select id FROM `nh` where city='Roxbury' && SIC_code='5812'DB:business_master_new
loadtime:1.896115064621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rumney' limit 1
loadtime:1.8961789608002 / seconds
Query Executed:select id FROM `nh` where city='Rumney' && SIC_code='5812'DB:business_master_new
loadtime:1.8976979255676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rye' limit 1
loadtime:1.8977749347687 / seconds
Query Executed:select id FROM `nh` where city='Rye' && SIC_code='5812'DB:business_master_new
loadtime:1.9241020679474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rye Beach' limit 1
loadtime:1.9242079257965 / seconds
Query Executed:select id FROM `nh` where city='Rye Beach' && SIC_code='5812'DB:business_master_new
loadtime:1.9251148700714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:1.9251930713654 / seconds
Query Executed:select id FROM `nh` where city='Salem' && SIC_code='5812'DB:business_master_new
loadtime:1.9492158889771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:1.9494378566742 / seconds
Query Executed:select id FROM `nh` where city='Salisbury' && SIC_code='5812'DB:business_master_new
loadtime:1.9506289958954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanbornton' limit 1
loadtime:1.9507019519806 / seconds
Query Executed:select id FROM `nh` where city='Sanbornton' && SIC_code='5812'DB:business_master_new
loadtime:1.9523439407349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanbornville' limit 1
loadtime:1.9524219036102 / seconds
Query Executed:select id FROM `nh` where city='Sanbornville' && SIC_code='5812'DB:business_master_new
loadtime:1.9789779186249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandown' limit 1
loadtime:1.9790699481964 / seconds
Query Executed:select id FROM `nh` where city='Sandown' && SIC_code='5812'DB:business_master_new
loadtime:1.9808640480042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seabrook' limit 1
loadtime:1.9809539318085 / seconds
Query Executed:select id FROM `nh` where city='Seabrook' && SIC_code='5812'DB:business_master_new
loadtime:1.9888169765472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:1.9889469146729 / seconds
Query Executed:select id FROM `nh` where city='Sharon' && SIC_code='5812'DB:business_master_new
loadtime:1.9894149303436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelburne' limit 1
loadtime:1.9894819259644 / seconds
Query Executed:select id FROM `nh` where city='Shelburne' && SIC_code='5812'DB:business_master_new
loadtime:1.9899559020996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Lake' limit 1
loadtime:1.9900279045105 / seconds
Query Executed:select id FROM `nh` where city='Silver Lake' && SIC_code='5812'DB:business_master_new
loadtime:1.9906990528107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somersworth' limit 1
loadtime:1.9907739162445 / seconds
Query Executed:select id FROM `nh` where city='Somersworth' && SIC_code='5812'DB:business_master_new
loadtime:1.9990999698639 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Acworth' limit 1
loadtime:1.9992129802704 / seconds
Query Executed:select id FROM `nh` where city='South Acworth' && SIC_code='5812'DB:business_master_new
loadtime:1.9997990131378 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Effingham' limit 1
loadtime:1.9998669624329 / seconds
Query Executed:select id FROM `nh` where city='South Effingham' && SIC_code='5812'DB:business_master_new
loadtime:2.0002539157867 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hampton' limit 1
loadtime:2.000314950943 / seconds
Query Executed:select id FROM `nh` where city='South Hampton' && SIC_code='5812'DB:business_master_new
loadtime:2.0007150173187 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Newbury' limit 1
loadtime:2.0007820129395 / seconds
Query Executed:select id FROM `nh` where city='South Newbury' && SIC_code='5812'DB:business_master_new
loadtime:2.0012390613556 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Sutton' limit 1
loadtime:2.0013010501862 / seconds
Query Executed:select id FROM `nh` where city='South Sutton' && SIC_code='5812'DB:business_master_new
loadtime:2.001895904541 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Tamworth' limit 1
loadtime:2.0019609928131 / seconds
Query Executed:select id FROM `nh` where city='South Tamworth' && SIC_code='5812'DB:business_master_new
loadtime:2.0025398731232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spofford' limit 1
loadtime:2.0026018619537 / seconds
Query Executed:select id FROM `nh` where city='Spofford' && SIC_code='5812'DB:business_master_new
loadtime:2.0037219524384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:2.0037989616394 / seconds
Query Executed:select id FROM `nh` where city='Springfield' && SIC_code='5812'DB:business_master_new
loadtime:2.0046999454498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stark' limit 1
loadtime:2.0047810077667 / seconds
Query Executed:select id FROM `nh` where city='Stark' && SIC_code='5812'DB:business_master_new
loadtime:2.0051810741425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stewartstown' limit 1
loadtime:2.005243062973 / seconds
Query Executed:select id FROM `nh` where city='Stewartstown' && SIC_code='5812'DB:business_master_new
loadtime:2.00563788414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stinson Lake' limit 1
loadtime:2.0056989192963 / seconds
Query Executed:select id FROM `nh` where city='Stinson Lake' && SIC_code='5812'DB:business_master_new
loadtime:2.0060970783234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoddard' limit 1
loadtime:2.0061569213867 / seconds
Query Executed:select id FROM `nh` where city='Stoddard' && SIC_code='5812'DB:business_master_new
loadtime:2.006875038147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strafford' limit 1
loadtime:2.0069360733032 / seconds
Query Executed:select id FROM `nh` where city='Strafford' && SIC_code='5812'DB:business_master_new
loadtime:2.0080890655518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratham' limit 1
loadtime:2.0081670284271 / seconds
Query Executed:select id FROM `nh` where city='Stratham' && SIC_code='5812'DB:business_master_new
loadtime:2.0149500370026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar Hill' limit 1
loadtime:2.0150549411774 / seconds
Query Executed:select id FROM `nh` where city='Sugar Hill' && SIC_code='5812'DB:business_master_new
loadtime:2.0156898498535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sullivan' limit 1
loadtime:2.0157549381256 / seconds
Query Executed:select id FROM `nh` where city='Sullivan' && SIC_code='5812'DB:business_master_new
loadtime:2.0164489746094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunapee' limit 1
loadtime:2.0165090560913 / seconds
Query Executed:select id FROM `nh` where city='Sunapee' && SIC_code='5812'DB:business_master_new
loadtime:2.0429079532623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suncook' limit 1
loadtime:2.0430068969727 / seconds
Query Executed:select id FROM `nh` where city='Suncook' && SIC_code='5812'DB:business_master_new
loadtime:2.0504820346832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surry' limit 1
loadtime:2.0505809783936 / seconds
Query Executed:select id FROM `nh` where city='Surry' && SIC_code='5812'DB:business_master_new
loadtime:2.0510380268097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swanzey' limit 1
loadtime:2.0511028766632 / seconds
Query Executed:select id FROM `nh` where city='Swanzey' && SIC_code='5812'DB:business_master_new
loadtime:2.0771949291229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tamworth' limit 1
loadtime:2.0772800445557 / seconds
Query Executed:select id FROM `nh` where city='Tamworth' && SIC_code='5812'DB:business_master_new
loadtime:2.0791370868683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temple' limit 1
loadtime:2.0792188644409 / seconds
Query Executed:select id FROM `nh` where city='Temple' && SIC_code='5812'DB:business_master_new
loadtime:2.0804300308228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornton' limit 1
loadtime:2.0805139541626 / seconds
Query Executed:select id FROM `nh` where city='Thornton' && SIC_code='5812'DB:business_master_new
loadtime:2.0812270641327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tilton' limit 1
loadtime:2.0813028812408 / seconds
Query Executed:select id FROM `nh` where city='Tilton' && SIC_code='5812'DB:business_master_new
loadtime:2.0890419483185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:2.0891599655151 / seconds
Query Executed:select id FROM `nh` where city='Troy' && SIC_code='5812'DB:business_master_new
loadtime:2.0904848575592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twin Mountain' limit 1
loadtime:2.0905668735504 / seconds
Query Executed:select id FROM `nh` where city='Twin Mountain' && SIC_code='5812'DB:business_master_new
loadtime:2.0916850566864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:2.0917649269104 / seconds
Query Executed:select id FROM `nh` where city='Union' && SIC_code='5812'DB:business_master_new
loadtime:2.0928440093994 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Chesterfield' limit 1
loadtime:2.0929238796234 / seconds
Query Executed:select id FROM `nh` where city='W Chesterfield' && SIC_code='5812'DB:business_master_new
loadtime:2.0934009552002 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Peterborough' limit 1
loadtime:2.0934638977051 / seconds
Query Executed:select id FROM `nh` where city='W Peterborough' && SIC_code='5812'DB:business_master_new
loadtime:2.0938909053802 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Stewartstown' limit 1
loadtime:2.0939528942108 / seconds
Query Executed:select id FROM `nh` where city='W Stewartstown' && SIC_code='5812'DB:business_master_new
loadtime:2.0946569442749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walpole' limit 1
loadtime:2.0947308540344 / seconds
Query Executed:select id FROM `nh` where city='Walpole' && SIC_code='5812'DB:business_master_new
loadtime:2.1209559440613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warner' limit 1
loadtime:2.1210498809814 / seconds
Query Executed:select id FROM `nh` where city='Warner' && SIC_code='5812'DB:business_master_new
loadtime:2.1468110084534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:2.1468930244446 / seconds
Query Executed:select id FROM `nh` where city='Warren' && SIC_code='5812'DB:business_master_new
loadtime:2.1477069854736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:2.1477859020233 / seconds
Query Executed:select id FROM `nh` where city='Washington' && SIC_code='5812'DB:business_master_new
loadtime:2.1486709117889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville Valley' limit 1
loadtime:2.1487329006195 / seconds
Query Executed:select id FROM `nh` where city='Waterville Valley' && SIC_code='5812'DB:business_master_new
loadtime:2.1497418880463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville Vly' limit 1
loadtime:2.149829864502 / seconds
Query Executed:select id FROM `nh` where city='Waterville Vly' && SIC_code='5812'DB:business_master_new
loadtime:2.1502919197083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weare' limit 1
loadtime:2.1503570079803 / seconds
Query Executed:select id FROM `nh` where city='Weare' && SIC_code='5812'DB:business_master_new
loadtime:2.1763429641724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:2.1764299869537 / seconds
Query Executed:select id FROM `nh` where city='Webster' && SIC_code='5812'DB:business_master_new
loadtime:2.1769208908081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworth' limit 1
loadtime:2.1769959926605 / seconds
Query Executed:select id FROM `nh` where city='Wentworth' && SIC_code='5812'DB:business_master_new
loadtime:2.1779088973999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworths Loctn' limit 1
loadtime:2.177983045578 / seconds
Query Executed:select id FROM `nh` where city='Wentworths Loctn' && SIC_code='5812'DB:business_master_new
loadtime:2.1783819198608 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chesterfield' limit 1
loadtime:2.1784420013428 / seconds
Query Executed:select id FROM `nh` where city='West Chesterfield' && SIC_code='5812'DB:business_master_new
loadtime:2.1793448925018 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Lebanon' limit 1
loadtime:2.1794199943542 / seconds
Query Executed:select id FROM `nh` where city='West Lebanon' && SIC_code='5812'DB:business_master_new
loadtime:2.1870138645172 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Nottingham' limit 1
loadtime:2.1871449947357 / seconds
Query Executed:select id FROM `nh` where city='West Nottingham' && SIC_code='5812'DB:business_master_new
loadtime:2.1876668930054 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Ossipee' limit 1
loadtime:2.1877329349518 / seconds
Query Executed:select id FROM `nh` where city='West Ossipee' && SIC_code='5812'DB:business_master_new
loadtime:2.188807964325 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Peterborough' limit 1
loadtime:2.1889228820801 / seconds
Query Executed:select id FROM `nh` where city='West Peterborough' && SIC_code='5812'DB:business_master_new
loadtime:2.1894390583038 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Springfield' limit 1
loadtime:2.1895020008087 / seconds
Query Executed:select id FROM `nh` where city='West Springfield' && SIC_code='5812'DB:business_master_new
loadtime:2.1899719238281 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Stewartstown' limit 1
loadtime:2.1900339126587 / seconds
Query Executed:select id FROM `nh` where city='West Stewartstown' && SIC_code='5812'DB:business_master_new
loadtime:2.1906399726868 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Swanzey' limit 1
loadtime:2.1907188892365 / seconds
Query Executed:select id FROM `nh` where city='West Swanzey' && SIC_code='5812'DB:business_master_new
loadtime:2.191792011261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westmoreland' limit 1
loadtime:2.1918818950653 / seconds
Query Executed:select id FROM `nh` where city='Westmoreland' && SIC_code='5812'DB:business_master_new
loadtime:2.1932399272919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitefield' limit 1
loadtime:2.19331407547 / seconds
Query Executed:select id FROM `nh` where city='Whitefield' && SIC_code='5812'DB:business_master_new
loadtime:2.2195620536804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmot' limit 1
loadtime:2.2196519374847 / seconds
Query Executed:select id FROM `nh` where city='Wilmot' && SIC_code='5812'DB:business_master_new
loadtime:2.2472400665283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmot Flat' limit 1
loadtime:2.2473289966583 / seconds
Query Executed:select id FROM `nh` where city='Wilmot Flat' && SIC_code='5812'DB:business_master_new
loadtime:2.2477240562439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:2.2477869987488 / seconds
Query Executed:select id FROM `nh` where city='Wilton' && SIC_code='5812'DB:business_master_new
loadtime:2.2531750202179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:2.2532560825348 / seconds
Query Executed:select id FROM `nh` where city='Winchester' && SIC_code='5812'DB:business_master_new
loadtime:2.2580890655518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windham' limit 1
loadtime:2.2581779956818 / seconds
Query Executed:select id FROM `nh` where city='Windham' && SIC_code='5812'DB:business_master_new
loadtime:2.266480922699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:2.2665770053864 / seconds
Query Executed:select id FROM `nh` where city='Windsor' && SIC_code='5812'DB:business_master_new
loadtime:2.2670199871063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winnisquam' limit 1
loadtime:2.2670888900757 / seconds
Query Executed:select id FROM `nh` where city='Winnisquam' && SIC_code='5812'DB:business_master_new
loadtime:2.2934629917145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolfeboro' limit 1
loadtime:2.2935569286346 / seconds
Query Executed:select id FROM `nh` where city='Wolfeboro' && SIC_code='5812'DB:business_master_new
loadtime:2.3021068572998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolfeboro Falls' limit 1
loadtime:2.3022320270538 / seconds
Query Executed:select id FROM `nh` where city='Wolfeboro Falls' && SIC_code='5812'DB:business_master_new
loadtime:2.3284990787506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wonalancet' limit 1
loadtime:2.3285889625549 / seconds
Query Executed:select id FROM `nh` where city='Wonalancet' && SIC_code='5812'DB:business_master_new
loadtime:2.3290379047394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:2.3291020393372 / seconds
Query Executed:select id FROM `nh` where city='Woodstock' && SIC_code='5812'DB:business_master_new
loadtime:2.3297610282898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodsville' limit 1
loadtime:2.3298399448395 / seconds
Query Executed:select id FROM `nh` where city='Woodsville' && SIC_code='5812'DB:business_master_new
loadtime:2.3338720798492 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:2.3340659141541 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:2.3344600200653 / seconds
Operation template executed (chunk cache operation)
loadtime:2.3346040248871 / seconds
template override:Default
loadtime:2.3346428871155 / 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:2.335834980011 / seconds
Template Constructed, Array Rows:49
loadtime:2.336364030838 / seconds
TOTAL EXECUTION TIME: 2.33592
loadtime:2.3383450508118 / 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] => eating-places [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:2.3383560180664
TOTAL KEY ARRAYS: 69