Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.2969665527344E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018119812011719 / seconds
host not found setting manual db connection
loadtime:0.0096590518951416 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0099141597747803 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.01015305519104 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010222196578979 / seconds
zipcode:
loadtime:0.010251045227051 / seconds
Query Executed:select * from search_referrer where page_hash='5d2b5296a1736f5206ae424f89a4ea37' limit 10 DB:ezrox_toadli
loadtime:0.010524034500122 / seconds
Operation header executed (non global)
loadtime:0.010557174682617 / seconds
Operation leaderboard executed (non global)
loadtime:0.010609149932861 / seconds
Operation square executed (non global)
loadtime:0.010637998580933 / seconds
Operation square_bottom executed (non global)
loadtime:0.01066517829895 / seconds
Operation smallsquare executed (non global)
loadtime:0.010691165924072 / seconds
Operation headeradright executed (non global)
loadtime:0.010717153549194 / seconds
Operation google_analytics executed (non global)
loadtime:0.0107421875 / seconds
Operation topstories executed (non global)
loadtime:0.010766983032227 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010794162750244 / seconds
Operation memberbuscount executed (non global)
loadtime:0.01081919670105 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.01104998588562 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.01121997833252 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011255979537964 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011316061019897 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011363983154297 / seconds
Template key: archive_menu pushed
loadtime:0.011373043060303 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011386156082153 / seconds
Template key: get_gravatar pushed
loadtime:0.011393070220947 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011401176452637 / seconds
*10)-10)+1 | start:0
loadtime:0.011440992355347 / seconds
Query loaded from cache:select * from categories where cat_URLid='beauty-shops'
loadtime:0.011482000350952 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-hampshire'
loadtime:0.011518001556396 / seconds
DB connected to localhost business_master_new
loadtime:0.011787176132202 / seconds
Query Executed:select * from `nh_catmap` where sic='7231' order by city ascDB:business_master_new
loadtime:0.018996000289917 / seconds
Query stored in cache : _QUERY_www.toadli.com32f62de80e3a5420d14ae7c43e8a50d7
loadtime:0.020240068435669 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-hampshire'
loadtime:0.020296096801758 / seconds
Query Executed:select sum(totalcount) as totalsum from `nh_catmap` where sic='7231'DB:business_master_new
loadtime:0.022051095962524 / seconds
Query stored in cache : _QUERY_www.toadli.comac90f78c00b065bdc31438065b49c4dd
loadtime:0.02209210395813 / seconds
309 / 11
loadtime:0.022160053253174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acworth' limit 1
loadtime:0.022229194641113 / seconds
Query Executed:select id FROM `nh` where city='Acworth' && SIC_code='7231'DB:business_master_new
loadtime:0.022891998291016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albany' limit 1
loadtime:0.022958040237427 / seconds
Query Executed:select id FROM `nh` where city='Albany' && SIC_code='7231'DB:business_master_new
loadtime:0.023471117019653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexandria' limit 1
loadtime:0.023548126220703 / seconds
Query Executed:select id FROM `nh` where city='Alexandria' && SIC_code='7231'DB:business_master_new
loadtime:0.024001121520996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allenstown' limit 1
loadtime:0.024062156677246 / seconds
Query Executed:select id FROM `nh` where city='Allenstown' && SIC_code='7231'DB:business_master_new
loadtime:0.024537086486816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alstead' limit 1
loadtime:0.02459716796875 / seconds
Query Executed:select id FROM `nh` where city='Alstead' && SIC_code='7231'DB:business_master_new
loadtime:0.026163101196289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.026241064071655 / seconds
Query Executed:select id FROM `nh` where city='Alton' && SIC_code='7231'DB:business_master_new
loadtime:0.041422128677368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton Bay' limit 1
loadtime:0.04150915145874 / seconds
Query Executed:select id FROM `nh` where city='Alton Bay' && SIC_code='7231'DB:business_master_new
loadtime:0.042412996292114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.042474985122681 / seconds
Query Executed:select id FROM `nh` where city='Amherst' && SIC_code='7231'DB:business_master_new
loadtime:0.052994012832642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.053109169006348 / seconds
Query Executed:select id FROM `nh` where city='Andover' && SIC_code='7231'DB:business_master_new
loadtime:0.054656982421875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Antrim' limit 1
loadtime:0.054736137390137 / seconds
Query Executed:select id FROM `nh` where city='Antrim' && SIC_code='7231'DB:business_master_new
loadtime:0.06921911239624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.069298028945923 / seconds
Query Executed:select id FROM `nh` where city='Ashland' && SIC_code='7231'DB:business_master_new
loadtime:0.083677053451538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashuelot' limit 1
loadtime:0.083755970001221 / seconds
Query Executed:select id FROM `nh` where city='Ashuelot' && SIC_code='7231'DB:business_master_new
loadtime:0.084346055984497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atkinson' limit 1
loadtime:0.08440899848938 / seconds
Query Executed:select id FROM `nh` where city='Atkinson' && SIC_code='7231'DB:business_master_new
loadtime:0.088490962982178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.088570117950439 / seconds
Query Executed:select id FROM `nh` where city='Auburn' && SIC_code='7231'DB:business_master_new
loadtime:0.092775106430054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnstead' limit 1
loadtime:0.092857122421265 / seconds
Query Executed:select id FROM `nh` where city='Barnstead' && SIC_code='7231'DB:business_master_new
loadtime:0.093894004821777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barrington' limit 1
loadtime:0.093983173370361 / seconds
Query Executed:select id FROM `nh` where city='Barrington' && SIC_code='7231'DB:business_master_new
loadtime:0.098806142807007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bartlett' limit 1
loadtime:0.098891019821167 / seconds
Query Executed:select id FROM `nh` where city='Bartlett' && SIC_code='7231'DB:business_master_new
loadtime:0.10037803649902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.10044002532959 / seconds
Query Executed:select id FROM `nh` where city='Bath' && SIC_code='7231'DB:business_master_new
loadtime:0.10128307342529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.10135817527771 / seconds
Query Executed:select id FROM `nh` where city='Bedford' && SIC_code='7231'DB:business_master_new
loadtime:0.117840051651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.11795210838318 / seconds
Query Executed:select id FROM `nh` where city='Belmont' && SIC_code='7231'DB:business_master_new
loadtime:0.12352013587952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennington' limit 1
loadtime:0.12360811233521 / seconds
Query Executed:select id FROM `nh` where city='Bennington' && SIC_code='7231'DB:business_master_new
loadtime:0.12457609176636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benton' limit 1
loadtime:0.12465715408325 / seconds
Query Executed:select id FROM `nh` where city='Benton' && SIC_code='7231'DB:business_master_new
loadtime:0.12512111663818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.12518310546875 / seconds
Query Executed:select id FROM `nh` where city='Berlin' && SIC_code='7231'DB:business_master_new
loadtime:0.13176918029785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethlehem' limit 1
loadtime:0.13187503814697 / seconds
Query Executed:select id FROM `nh` where city='Bethlehem' && SIC_code='7231'DB:business_master_new
loadtime:0.14673805236816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boscawen' limit 1
loadtime:0.14682602882385 / seconds
Query Executed:select id FROM `nh` where city='Boscawen' && SIC_code='7231'DB:business_master_new
loadtime:0.14733004570007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bow' limit 1
loadtime:0.14739298820496 / seconds
Query Executed:select id FROM `nh` where city='Bow' && SIC_code='7231'DB:business_master_new
loadtime:0.15338397026062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.15346312522888 / seconds
Query Executed:select id FROM `nh` where city='Bradford' && SIC_code='7231'DB:business_master_new
loadtime:0.16786098480225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brentwood' limit 1
loadtime:0.1679470539093 / seconds
Query Executed:select id FROM `nh` where city='Brentwood' && SIC_code='7231'DB:business_master_new
loadtime:0.16849207878113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bretton Woods' limit 1
loadtime:0.16855406761169 / seconds
Query Executed:select id FROM `nh` where city='Bretton Woods' && SIC_code='7231'DB:business_master_new
loadtime:0.16912007331848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.16918015480042 / seconds
Query Executed:select id FROM `nh` where city='Bristol' && SIC_code='7231'DB:business_master_new
loadtime:0.17431902885437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.17440509796143 / seconds
Query Executed:select id FROM `nh` where city='Brookfield' && SIC_code='7231'DB:business_master_new
loadtime:0.17486596107483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline' limit 1
loadtime:0.17492914199829 / seconds
Query Executed:select id FROM `nh` where city='Brookline' && SIC_code='7231'DB:business_master_new
loadtime:0.18940711021423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Campton' limit 1
loadtime:0.18949198722839 / seconds
Query Executed:select id FROM `nh` where city='Campton' && SIC_code='7231'DB:business_master_new
loadtime:0.19353699684143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canaan' limit 1
loadtime:0.19361996650696 / seconds
Query Executed:select id FROM `nh` where city='Canaan' && SIC_code='7231'DB:business_master_new
loadtime:0.2080249786377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Candia' limit 1
loadtime:0.2081151008606 / seconds
Query Executed:select id FROM `nh` where city='Candia' && SIC_code='7231'DB:business_master_new
loadtime:0.21212100982666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canterbury' limit 1
loadtime:0.21220207214355 / seconds
Query Executed:select id FROM `nh` where city='Canterbury' && SIC_code='7231'DB:business_master_new
loadtime:0.22655510902405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carroll' limit 1
loadtime:0.22662019729614 / seconds
Query Executed:select id FROM `nh` where city='Carroll' && SIC_code='7231'DB:business_master_new
loadtime:0.22706913948059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Barnstead' limit 1
loadtime:0.22714304924011 / seconds
Query Executed:select id FROM `nh` where city='Center Barnstead' && SIC_code='7231'DB:business_master_new
loadtime:0.22847318649292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Conway' limit 1
loadtime:0.22855305671692 / seconds
Query Executed:select id FROM `nh` where city='Center Conway' && SIC_code='7231'DB:business_master_new
loadtime:0.24295806884766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Harbor' limit 1
loadtime:0.24302315711975 / seconds
Query Executed:select id FROM `nh` where city='Center Harbor' && SIC_code='7231'DB:business_master_new
loadtime:0.25730013847351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Ossipee' limit 1
loadtime:0.25737905502319 / seconds
Query Executed:select id FROM `nh` where city='Center Ossipee' && SIC_code='7231'DB:business_master_new
loadtime:0.27179408073425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Sandwich' limit 1
loadtime:0.27187418937683 / seconds
Query Executed:select id FROM `nh` where city='Center Sandwich' && SIC_code='7231'DB:business_master_new
loadtime:0.27305912971497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Strafford' limit 1
loadtime:0.27314901351929 / seconds
Query Executed:select id FROM `nh` where city='Center Strafford' && SIC_code='7231'DB:business_master_new
loadtime:0.27369403839111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Tuftonboro' limit 1
loadtime:0.27375602722168 / seconds
Query Executed:select id FROM `nh` where city='Center Tuftonboro' && SIC_code='7231'DB:business_master_new
loadtime:0.27462100982666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlestown' limit 1
loadtime:0.27469515800476 / seconds
Query Executed:select id FROM `nh` where city='Charlestown' && SIC_code='7231'DB:business_master_new
loadtime:0.27866697311401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:0.27874803543091 / seconds
Query Executed:select id FROM `nh` where city='Chatham' && SIC_code='7231'DB:business_master_new
loadtime:0.27926111221313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.27932596206665 / seconds
Query Executed:select id FROM `nh` where city='Chester' && SIC_code='7231'DB:business_master_new
loadtime:0.29376196861267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:0.29384112358093 / seconds
Query Executed:select id FROM `nh` where city='Chesterfield' && SIC_code='7231'DB:business_master_new
loadtime:0.29500198364258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chichester' limit 1
loadtime:0.29506516456604 / seconds
Query Executed:select id FROM `nh` where city='Chichester' && SIC_code='7231'DB:business_master_new
loadtime:0.30930805206299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chocorua' limit 1
loadtime:0.30938696861267 / seconds
Query Executed:select id FROM `nh` where city='Chocorua' && SIC_code='7231'DB:business_master_new
loadtime:0.31025409698486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:0.31032919883728 / seconds
Query Executed:select id FROM `nh` where city='Claremont' && SIC_code='7231'DB:business_master_new
loadtime:0.32064414024353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksville' limit 1
loadtime:0.32076907157898 / seconds
Query Executed:select id FROM `nh` where city='Clarksville' && SIC_code='7231'DB:business_master_new
loadtime:0.32128214836121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colebrook' limit 1
loadtime:0.32134914398193 / seconds
Query Executed:select id FROM `nh` where city='Colebrook' && SIC_code='7231'DB:business_master_new
loadtime:0.32587099075317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.32596111297607 / seconds
Query Executed:select id FROM `nh` where city='Concord' && SIC_code='7231'DB:business_master_new
loadtime:0.36443519592285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Contoocook' limit 1
loadtime:0.36470413208008 / seconds
Query Executed:select id FROM `nh` where city='Contoocook' && SIC_code='7231'DB:business_master_new
loadtime:0.36961913108826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.36971116065979 / seconds
Query Executed:select id FROM `nh` where city='Conway' && SIC_code='7231'DB:business_master_new
loadtime:0.37586498260498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornish' limit 1
loadtime:0.37595796585083 / seconds
Query Executed:select id FROM `nh` where city='Cornish' && SIC_code='7231'DB:business_master_new
loadtime:0.37687516212463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornish Flat' limit 1
loadtime:0.37695598602295 / seconds
Query Executed:select id FROM `nh` where city='Cornish Flat' && SIC_code='7231'DB:business_master_new
loadtime:0.37755298614502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Croydon' limit 1
loadtime:0.37761497497559 / seconds
Query Executed:select id FROM `nh` where city='Croydon' && SIC_code='7231'DB:business_master_new
loadtime:0.37810611724854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ctr Tuftonboro' limit 1
loadtime:0.37817001342773 / seconds
Query Executed:select id FROM `nh` where city='Ctr Tuftonboro' && SIC_code='7231'DB:business_master_new
loadtime:0.37861013412476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dalton' limit 1
loadtime:0.37866997718811 / seconds
Query Executed:select id FROM `nh` where city='Dalton' && SIC_code='7231'DB:business_master_new
loadtime:0.37913513183594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:0.3791971206665 / seconds
Query Executed:select id FROM `nh` where city='Danbury' && SIC_code='7231'DB:business_master_new
loadtime:0.38021516799927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.38027596473694 / seconds
Query Executed:select id FROM `nh` where city='Danville' && SIC_code='7231'DB:business_master_new
loadtime:0.38169503211975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:0.3817720413208 / seconds
Query Executed:select id FROM `nh` where city='Deerfield' && SIC_code='7231'DB:business_master_new
loadtime:0.39687609672546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deering' limit 1
loadtime:0.39696097373962 / seconds
Query Executed:select id FROM `nh` where city='Deering' && SIC_code='7231'DB:business_master_new
loadtime:0.39746809005737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derry' limit 1
loadtime:0.39753007888794 / seconds
Query Executed:select id FROM `nh` where city='Derry' && SIC_code='7231'DB:business_master_new
loadtime:0.41265797615051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:0.41278910636902 / seconds
Query Executed:select id FROM `nh` where city='Dorchester' && SIC_code='7231'DB:business_master_new
loadtime:0.41325902938843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dover' limit 1
loadtime:0.41332602500916 / seconds
Query Executed:select id FROM `nh` where city='Dover' && SIC_code='7231'DB:business_master_new
loadtime:0.43129205703735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drewsville' limit 1
loadtime:0.4314181804657 / seconds
Query Executed:select id FROM `nh` where city='Drewsville' && SIC_code='7231'DB:business_master_new
loadtime:0.43184900283813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dublin' limit 1
loadtime:0.43193006515503 / seconds
Query Executed:select id FROM `nh` where city='Dublin' && SIC_code='7231'DB:business_master_new
loadtime:0.43324017524719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dummer' limit 1
loadtime:0.43330097198486 / seconds
Query Executed:select id FROM `nh` where city='Dummer' && SIC_code='7231'DB:business_master_new
loadtime:0.4337420463562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunbarton' limit 1
loadtime:0.43380308151245 / seconds
Query Executed:select id FROM `nh` where city='Dunbarton' && SIC_code='7231'DB:business_master_new
loadtime:0.43511319160461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durham' limit 1
loadtime:0.43519115447998 / seconds
Query Executed:select id FROM `nh` where city='Durham' && SIC_code='7231'DB:business_master_new
loadtime:0.44163513183594 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Andover' limit 1
loadtime:0.44172310829163 / seconds
Query Executed:select id FROM `nh` where city='East Andover' && SIC_code='7231'DB:business_master_new
loadtime:0.44230604171753 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Candia' limit 1
loadtime:0.44236898422241 / seconds
Query Executed:select id FROM `nh` where city='East Candia' && SIC_code='7231'DB:business_master_new
loadtime:0.44282007217407 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Derry' limit 1
loadtime:0.44288110733032 / seconds
Query Executed:select id FROM `nh` where city='East Derry' && SIC_code='7231'DB:business_master_new
loadtime:0.4436571598053 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hampstead' limit 1
loadtime:0.44373202323914 / seconds
Query Executed:select id FROM `nh` where city='East Hampstead' && SIC_code='7231'DB:business_master_new
loadtime:0.44541501998901 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hebron' limit 1
loadtime:0.44550204277039 / seconds
Query Executed:select id FROM `nh` where city='East Hebron' && SIC_code='7231'DB:business_master_new
loadtime:0.44598913192749 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Kingston' limit 1
loadtime:0.44605112075806 / seconds
Query Executed:select id FROM `nh` where city='East Kingston' && SIC_code='7231'DB:business_master_new
loadtime:0.46091198921204 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Swanzey' limit 1
loadtime:0.46098113059998 / seconds
Query Executed:select id FROM `nh` where city='East Swanzey' && SIC_code='7231'DB:business_master_new
loadtime:0.46146011352539 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Wakefield' limit 1
loadtime:0.46152210235596 / seconds
Query Executed:select id FROM `nh` where city='East Wakefield' && SIC_code='7231'DB:business_master_new
loadtime:0.46232414245605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eaton Center' limit 1
loadtime:0.46238613128662 / seconds
Query Executed:select id FROM `nh` where city='Eaton Center' && SIC_code='7231'DB:business_master_new
loadtime:0.46308612823486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Effingham' limit 1
loadtime:0.46315717697144 / seconds
Query Executed:select id FROM `nh` where city='Effingham' && SIC_code='7231'DB:business_master_new
loadtime:0.46377515792847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkins' limit 1
loadtime:0.46383619308472 / seconds
Query Executed:select id FROM `nh` where city='Elkins' && SIC_code='7231'DB:business_master_new
loadtime:0.46442103385925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth' limit 1
loadtime:0.46448111534119 / seconds
Query Executed:select id FROM `nh` where city='Ellsworth' && SIC_code='7231'DB:business_master_new
loadtime:0.46488809585571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enfield' limit 1
loadtime:0.46495509147644 / seconds
Query Executed:select id FROM `nh` where city='Enfield' && SIC_code='7231'DB:business_master_new
loadtime:0.47936797142029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enfield Center' limit 1
loadtime:0.47945117950439 / seconds
Query Executed:select id FROM `nh` where city='Enfield Center' && SIC_code='7231'DB:business_master_new
loadtime:0.47995114326477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Epping' limit 1
loadtime:0.48001408576965 / seconds
Query Executed:select id FROM `nh` where city='Epping' && SIC_code='7231'DB:business_master_new
loadtime:0.48457598686218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Epsom' limit 1
loadtime:0.48465919494629 / seconds
Query Executed:select id FROM `nh` where city='Epsom' && SIC_code='7231'DB:business_master_new
loadtime:0.49917197227478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Errol' limit 1
loadtime:0.49925708770752 / seconds
Query Executed:select id FROM `nh` where city='Errol' && SIC_code='7231'DB:business_master_new
loadtime:0.50019407272339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Etna' limit 1
loadtime:0.50025606155396 / seconds
Query Executed:select id FROM `nh` where city='Etna' && SIC_code='7231'DB:business_master_new
loadtime:0.5011351108551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exeter' limit 1
loadtime:0.50120902061462 / seconds
Query Executed:select id FROM `nh` where city='Exeter' && SIC_code='7231'DB:business_master_new
loadtime:0.51606297492981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.51619601249695 / seconds
Query Executed:select id FROM `nh` where city='Farmington' && SIC_code='7231'DB:business_master_new
loadtime:0.53093504905701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fitzwilliam' limit 1
loadtime:0.5310320854187 / seconds
Query Executed:select id FROM `nh` where city='Fitzwilliam' && SIC_code='7231'DB:business_master_new
loadtime:0.5326361656189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Francestown' limit 1
loadtime:0.5327000617981 / seconds
Query Executed:select id FROM `nh` where city='Francestown' && SIC_code='7231'DB:business_master_new
loadtime:0.53398203849792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franconia' limit 1
loadtime:0.53405809402466 / seconds
Query Executed:select id FROM `nh` where city='Franconia' && SIC_code='7231'DB:business_master_new
loadtime:0.548415184021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.54849100112915 / seconds
Query Executed:select id FROM `nh` where city='Franklin' && SIC_code='7231'DB:business_master_new
loadtime:0.55403017997742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freedom' limit 1
loadtime:0.55413508415222 / seconds
Query Executed:select id FROM `nh` where city='Freedom' && SIC_code='7231'DB:business_master_new
loadtime:0.5553560256958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fremont' limit 1
loadtime:0.55543398857117 / seconds
Query Executed:select id FROM `nh` where city='Fremont' && SIC_code='7231'DB:business_master_new
loadtime:0.55723714828491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georges Mills' limit 1
loadtime:0.55731511116028 / seconds
Query Executed:select id FROM `nh` where city='Georges Mills' && SIC_code='7231'DB:business_master_new
loadtime:0.55807614326477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilford' limit 1
loadtime:0.55816102027893 / seconds
Query Executed:select id FROM `nh` where city='Gilford' && SIC_code='7231'DB:business_master_new
loadtime:0.56490206718445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilmanton' limit 1
loadtime:0.56499814987183 / seconds
Query Executed:select id FROM `nh` where city='Gilmanton' && SIC_code='7231'DB:business_master_new
loadtime:0.56640911102295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilmanton Iron Works' limit 1
loadtime:0.56648707389832 / seconds
Query Executed:select id FROM `nh` where city='Gilmanton Iron Works' && SIC_code='7231'DB:business_master_new
loadtime:0.56733512878418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilsum' limit 1
loadtime:0.56740999221802 / seconds
Query Executed:select id FROM `nh` where city='Gilsum' && SIC_code='7231'DB:business_master_new
loadtime:0.56818699836731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen' limit 1
loadtime:0.56825017929077 / seconds
Query Executed:select id FROM `nh` where city='Glen' && SIC_code='7231'DB:business_master_new
loadtime:0.56950402259827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glencliff' limit 1
loadtime:0.56957912445068 / seconds
Query Executed:select id FROM `nh` where city='Glencliff' && SIC_code='7231'DB:business_master_new
loadtime:0.5701220035553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glmntn Iron Wks' limit 1
loadtime:0.57018303871155 / seconds
Query Executed:select id FROM `nh` where city='Glmntn Iron Wks' && SIC_code='7231'DB:business_master_new
loadtime:0.57060313224792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goffstown' limit 1
loadtime:0.57066512107849 / seconds
Query Executed:select id FROM `nh` where city='Goffstown' && SIC_code='7231'DB:business_master_new
loadtime:0.57853412628174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gorham' limit 1
loadtime:0.57863402366638 / seconds
Query Executed:select id FROM `nh` where city='Gorham' && SIC_code='7231'DB:business_master_new
loadtime:0.58308815956116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.58318901062012 / seconds
Query Executed:select id FROM `nh` where city='Goshen' && SIC_code='7231'DB:business_master_new
loadtime:0.58401608467102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.58409118652344 / seconds
Query Executed:select id FROM `nh` where city='Grafton' && SIC_code='7231'DB:business_master_new
loadtime:0.584881067276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grantham' limit 1
loadtime:0.58495116233826 / seconds
Query Executed:select id FROM `nh` where city='Grantham' && SIC_code='7231'DB:business_master_new
loadtime:0.59993815422058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenfield' limit 1
loadtime:0.60004615783691 / seconds
Query Executed:select id FROM `nh` where city='Greenfield' && SIC_code='7231'DB:business_master_new
loadtime:0.6012761592865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenland' limit 1
loadtime:0.6013400554657 / seconds
Query Executed:select id FROM `nh` where city='Greenland' && SIC_code='7231'DB:business_master_new
loadtime:0.60621905326843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.60630917549133 / seconds
Query Executed:select id FROM `nh` where city='Greenville' && SIC_code='7231'DB:business_master_new
loadtime:0.6206111907959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groveton' limit 1
loadtime:0.62069511413574 / seconds
Query Executed:select id FROM `nh` where city='Groveton' && SIC_code='7231'DB:business_master_new
loadtime:0.62234115600586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guild' limit 1
loadtime:0.62242317199707 / seconds
Query Executed:select id FROM `nh` where city='Guild' && SIC_code='7231'DB:business_master_new
loadtime:0.62295818328857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hales Location' limit 1
loadtime:0.62302303314209 / seconds
Query Executed:select id FROM `nh` where city='Hales Location' && SIC_code='7231'DB:business_master_new
loadtime:0.6234290599823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampstead' limit 1
loadtime:0.62349009513855 / seconds
Query Executed:select id FROM `nh` where city='Hampstead' && SIC_code='7231'DB:business_master_new
loadtime:0.62865519523621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:0.628741979599 / seconds
Query Executed:select id FROM `nh` where city='Hampton' && SIC_code='7231'DB:business_master_new
loadtime:0.64116096496582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton Falls' limit 1
loadtime:0.64126396179199 / seconds
Query Executed:select id FROM `nh` where city='Hampton Falls' && SIC_code='7231'DB:business_master_new
loadtime:0.65583300590515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:0.65592503547668 / seconds
Query Executed:select id FROM `nh` where city='Hancock' && SIC_code='7231'DB:business_master_new
loadtime:0.65747904777527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.65755796432495 / seconds
Query Executed:select id FROM `nh` where city='Hanover' && SIC_code='7231'DB:business_master_new
loadtime:0.66420316696167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisville' limit 1
loadtime:0.66429114341736 / seconds
Query Executed:select id FROM `nh` where city='Harrisville' && SIC_code='7231'DB:business_master_new
loadtime:0.6652569770813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harts Location' limit 1
loadtime:0.66532111167908 / seconds
Query Executed:select id FROM `nh` where city='Harts Location' && SIC_code='7231'DB:business_master_new
loadtime:0.66573619842529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haverhill' limit 1
loadtime:0.66579699516296 / seconds
Query Executed:select id FROM `nh` where city='Haverhill' && SIC_code='7231'DB:business_master_new
loadtime:0.66646504402161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hebron' limit 1
loadtime:0.66654205322266 / seconds
Query Executed:select id FROM `nh` where city='Hebron' && SIC_code='7231'DB:business_master_new
loadtime:0.66737914085388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henniker' limit 1
loadtime:0.66744112968445 / seconds
Query Executed:select id FROM `nh` where city='Henniker' && SIC_code='7231'DB:business_master_new
loadtime:0.67192411422729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hill' limit 1
loadtime:0.6720130443573 / seconds
Query Executed:select id FROM `nh` where city='Hill' && SIC_code='7231'DB:business_master_new
loadtime:0.6728630065918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:0.67292618751526 / seconds
Query Executed:select id FROM `nh` where city='Hillsboro' && SIC_code='7231'DB:business_master_new
loadtime:0.67373108863831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsborough' limit 1
loadtime:0.67380499839783 / seconds
Query Executed:select id FROM `nh` where city='Hillsborough' && SIC_code='7231'DB:business_master_new
loadtime:0.67895317077637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinsdale' limit 1
loadtime:0.67904496192932 / seconds
Query Executed:select id FROM `nh` where city='Hinsdale' && SIC_code='7231'DB:business_master_new
loadtime:0.68071007728577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holderness' limit 1
loadtime:0.68079113960266 / seconds
Query Executed:select id FROM `nh` where city='Holderness' && SIC_code='7231'DB:business_master_new
loadtime:0.68224501609802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollis' limit 1
loadtime:0.68232011795044 / seconds
Query Executed:select id FROM `nh` where city='Hollis' && SIC_code='7231'DB:business_master_new
loadtime:0.68830108642578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hooksett' limit 1
loadtime:0.68838596343994 / seconds
Query Executed:select id FROM `nh` where city='Hooksett' && SIC_code='7231'DB:business_master_new
loadtime:0.6984269618988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkinton' limit 1
loadtime:0.69854307174683 / seconds
Query Executed:select id FROM `nh` where city='Hopkinton' && SIC_code='7231'DB:business_master_new
loadtime:0.69913506507874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:0.69920206069946 / seconds
Query Executed:select id FROM `nh` where city='Hudson' && SIC_code='7231'DB:business_master_new
loadtime:0.71242117881775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Intervale' limit 1
loadtime:0.71253299713135 / seconds
Query Executed:select id FROM `nh` where city='Intervale' && SIC_code='7231'DB:business_master_new
loadtime:0.71379113197327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:0.71386909484863 / seconds
Query Executed:select id FROM `nh` where city='Jackson' && SIC_code='7231'DB:business_master_new
loadtime:0.71539211273193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jaffrey' limit 1
loadtime:0.71546697616577 / seconds
Query Executed:select id FROM `nh` where city='Jaffrey' && SIC_code='7231'DB:business_master_new
loadtime:0.72021698951721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:0.72029614448547 / seconds
Query Executed:select id FROM `nh` where city='Jefferson' && SIC_code='7231'DB:business_master_new
loadtime:0.72145104408264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kearsarge' limit 1
loadtime:0.72151398658752 / seconds
Query Executed:select id FROM `nh` where city='Kearsarge' && SIC_code='7231'DB:business_master_new
loadtime:0.72201609611511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keene' limit 1
loadtime:0.72207713127136 / seconds
Query Executed:select id FROM `nh` where city='Keene' && SIC_code='7231'DB:business_master_new
loadtime:0.74065613746643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kensington' limit 1
loadtime:0.74079918861389 / seconds
Query Executed:select id FROM `nh` where city='Kensington' && SIC_code='7231'DB:business_master_new
loadtime:0.74130702018738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:0.74137616157532 / seconds
Query Executed:select id FROM `nh` where city='Kingston' && SIC_code='7231'DB:business_master_new
loadtime:0.74661302566528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laconia' limit 1
loadtime:0.7467041015625 / seconds
Query Executed:select id FROM `nh` where city='Laconia' && SIC_code='7231'DB:business_master_new
loadtime:0.76219010353088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:0.76232600212097 / seconds
Query Executed:select id FROM `nh` where city='Lancaster' && SIC_code='7231'DB:business_master_new
loadtime:0.76706004142761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Landaff' limit 1
loadtime:0.76716613769531 / seconds
Query Executed:select id FROM `nh` where city='Landaff' && SIC_code='7231'DB:business_master_new
loadtime:0.76763296127319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langdon' limit 1
loadtime:0.76769614219666 / seconds
Query Executed:select id FROM `nh` where city='Langdon' && SIC_code='7231'DB:business_master_new
loadtime:0.76820707321167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:0.76826810836792 / seconds
Query Executed:select id FROM `nh` where city='Lebanon' && SIC_code='7231'DB:business_master_new
loadtime:0.77765107154846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lee' limit 1
loadtime:0.77774906158447 / seconds
Query Executed:select id FROM `nh` where city='Lee' && SIC_code='7231'DB:business_master_new
loadtime:0.79272413253784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lempster' limit 1
loadtime:0.79280710220337 / seconds
Query Executed:select id FROM `nh` where city='Lempster' && SIC_code='7231'DB:business_master_new
loadtime:0.79367899894714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.79374217987061 / seconds
Query Executed:select id FROM `nh` where city='Lincoln' && SIC_code='7231'DB:business_master_new
loadtime:0.7976291179657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lisbon' limit 1
loadtime:0.7977089881897 / seconds
Query Executed:select id FROM `nh` where city='Lisbon' && SIC_code='7231'DB:business_master_new
loadtime:0.81210613250732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield' limit 1
loadtime:0.81218600273132 / seconds
Query Executed:select id FROM `nh` where city='Litchfield' && SIC_code='7231'DB:business_master_new
loadtime:0.81566500663757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littleton' limit 1
loadtime:0.8157479763031 / seconds
Query Executed:select id FROM `nh` where city='Littleton' && SIC_code='7231'DB:business_master_new
loadtime:0.82347917556763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lochmere' limit 1
loadtime:0.82357096672058 / seconds
Query Executed:select id FROM `nh` where city='Lochmere' && SIC_code='7231'DB:business_master_new
loadtime:0.82413697242737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Londonderry' limit 1
loadtime:0.82420110702515 / seconds
Query Executed:select id FROM `nh` where city='Londonderry' && SIC_code='7231'DB:business_master_new
loadtime:0.83997702598572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loudon' limit 1
loadtime:0.84009408950806 / seconds
Query Executed:select id FROM `nh` where city='Loudon' && SIC_code='7231'DB:business_master_new
loadtime:0.84405517578125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyman' limit 1
loadtime:0.84415197372437 / seconds
Query Executed:select id FROM `nh` where city='Lyman' && SIC_code='7231'DB:business_master_new
loadtime:0.84455513954163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyme' limit 1
loadtime:0.84461712837219 / seconds
Query Executed:select id FROM `nh` where city='Lyme' && SIC_code='7231'DB:business_master_new
loadtime:0.84734201431274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyme Center' limit 1
loadtime:0.84741997718811 / seconds
Query Executed:select id FROM `nh` where city='Lyme Center' && SIC_code='7231'DB:business_master_new
loadtime:0.84786415100098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndeborough' limit 1
loadtime:0.84792613983154 / seconds
Query Executed:select id FROM `nh` where city='Lyndeborough' && SIC_code='7231'DB:business_master_new
loadtime:0.86237001419067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madbury' limit 1
loadtime:0.86243319511414 / seconds
Query Executed:select id FROM `nh` where city='Madbury' && SIC_code='7231'DB:business_master_new
loadtime:0.86326909065247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.8633451461792 / seconds
Query Executed:select id FROM `nh` where city='Madison' && SIC_code='7231'DB:business_master_new
loadtime:0.86454010009766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.86460304260254 / seconds
Query Executed:select id FROM `nh` where city='Manchester' && SIC_code='7231'DB:business_master_new
loadtime:0.8808901309967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlborough' limit 1
loadtime:0.88125610351562 / seconds
Query Executed:select id FROM `nh` where city='Marlborough' && SIC_code='7231'DB:business_master_new
loadtime:0.89560604095459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlow' limit 1
loadtime:0.89570617675781 / seconds
Query Executed:select id FROM `nh` where city='Marlow' && SIC_code='7231'DB:business_master_new
loadtime:0.89641308784485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mason' limit 1
loadtime:0.89647507667542 / seconds
Query Executed:select id FROM `nh` where city='Mason' && SIC_code='7231'DB:business_master_new
loadtime:0.89692711830139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadows' limit 1
loadtime:0.89699196815491 / seconds
Query Executed:select id FROM `nh` where city='Meadows' && SIC_code='7231'DB:business_master_new
loadtime:0.89740610122681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melvin Village' limit 1
loadtime:0.89746713638306 / seconds
Query Executed:select id FROM `nh` where city='Melvin Village' && SIC_code='7231'DB:business_master_new
loadtime:0.89817905426025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meredith' limit 1
loadtime:0.89825415611267 / seconds
Query Executed:select id FROM `nh` where city='Meredith' && SIC_code='7231'DB:business_master_new
loadtime:0.90555000305176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meriden' limit 1
loadtime:0.9056441783905 / seconds
Query Executed:select id FROM `nh` where city='Meriden' && SIC_code='7231'DB:business_master_new
loadtime:0.90647196769714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrimack' limit 1
loadtime:0.90653610229492 / seconds
Query Executed:select id FROM `nh` where city='Merrimack' && SIC_code='7231'DB:business_master_new
loadtime:0.92049098014832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleton' limit 1
loadtime:0.92061018943787 / seconds
Query Executed:select id FROM `nh` where city='Middleton' && SIC_code='7231'DB:business_master_new
loadtime:0.92106604576111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milan' limit 1
loadtime:0.92114305496216 / seconds
Query Executed:select id FROM `nh` where city='Milan' && SIC_code='7231'DB:business_master_new
loadtime:0.92213296890259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:0.92219400405884 / seconds
Query Executed:select id FROM `nh` where city='Milford' && SIC_code='7231'DB:business_master_new
loadtime:0.93228006362915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:0.93239498138428 / seconds
Query Executed:select id FROM `nh` where city='Milton' && SIC_code='7231'DB:business_master_new
loadtime:0.94704508781433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton Mills' limit 1
loadtime:0.9471390247345 / seconds
Query Executed:select id FROM `nh` where city='Milton Mills' && SIC_code='7231'DB:business_master_new
loadtime:0.94776010513306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mirror Lake' limit 1
loadtime:0.94782400131226 / seconds
Query Executed:select id FROM `nh` where city='Mirror Lake' && SIC_code='7231'DB:business_master_new
loadtime:0.9486141204834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.94867515563965 / seconds
Query Executed:select id FROM `nh` where city='Monroe' && SIC_code='7231'DB:business_master_new
loadtime:0.94946098327637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mont Vernon' limit 1
loadtime:0.94953799247742 / seconds
Query Executed:select id FROM `nh` where city='Mont Vernon' && SIC_code='7231'DB:business_master_new
loadtime:0.96374702453613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moultonborough' limit 1
loadtime:0.96381115913391 / seconds
Query Executed:select id FROM `nh` where city='Moultonborough' && SIC_code='7231'DB:business_master_new
loadtime:0.96766996383667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Sunapee' limit 1
loadtime:0.96775197982788 / seconds
Query Executed:select id FROM `nh` where city='Mt Sunapee' && SIC_code='7231'DB:business_master_new
loadtime:0.96819996833801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munsonville' limit 1
loadtime:0.96826314926147 / seconds
Query Executed:select id FROM `nh` where city='Munsonville' && SIC_code='7231'DB:business_master_new
loadtime:0.96874904632568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashua' limit 1
loadtime:0.96881008148193 / seconds
Query Executed:select id FROM `nh` where city='Nashua' && SIC_code='7231'DB:business_master_new
loadtime:0.98458814620972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelson' limit 1
loadtime:0.98480200767517 / seconds
Query Executed:select id FROM `nh` where city='Nelson' && SIC_code='7231'DB:business_master_new
loadtime:0.98539304733276 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Boston' limit 1
loadtime:0.98546600341797 / seconds
Query Executed:select id FROM `nh` where city='New Boston' && SIC_code='7231'DB:business_master_new
loadtime:0.99982309341431 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Castle' limit 1
loadtime:0.99990296363831 / seconds
Query Executed:select id FROM `nh` where city='New Castle' && SIC_code='7231'DB:business_master_new
loadtime:1.0008680820465 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Durham' limit 1
loadtime:1.0009500980377 / seconds
Query Executed:select id FROM `nh` where city='New Durham' && SIC_code='7231'DB:business_master_new
loadtime:1.0023610591888 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hampton' limit 1
loadtime:1.0024361610413 / seconds
Query Executed:select id FROM `nh` where city='New Hampton' && SIC_code='7231'DB:business_master_new
loadtime:1.0042431354523 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Ipswich' limit 1
loadtime:1.0043210983276 / seconds
Query Executed:select id FROM `nh` where city='New Ipswich' && SIC_code='7231'DB:business_master_new
loadtime:1.0187890529633 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:1.0188710689545 / seconds
Query Executed:select id FROM `nh` where city='New London' && SIC_code='7231'DB:business_master_new
loadtime:1.0254759788513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbury' limit 1
loadtime:1.025573015213 / seconds
Query Executed:select id FROM `nh` where city='Newbury' && SIC_code='7231'DB:business_master_new
loadtime:1.0268981456757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newfields' limit 1
loadtime:1.0269820690155 / seconds
Query Executed:select id FROM `nh` where city='Newfields' && SIC_code='7231'DB:business_master_new
loadtime:1.0282390117645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newington' limit 1
loadtime:1.0283141136169 / seconds
Query Executed:select id FROM `nh` where city='Newington' && SIC_code='7231'DB:business_master_new
loadtime:1.0288281440735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newmarket' limit 1
loadtime:1.0288901329041 / seconds
Query Executed:select id FROM `nh` where city='Newmarket' && SIC_code='7231'DB:business_master_new
loadtime:1.0333499908447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:1.0334331989288 / seconds
Query Executed:select id FROM `nh` where city='Newport' && SIC_code='7231'DB:business_master_new
loadtime:1.039901971817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:1.0400061607361 / seconds
Query Executed:select id FROM `nh` where city='Newton' && SIC_code='7231'DB:business_master_new
loadtime:1.0544230937958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Junction' limit 1
loadtime:1.0545029640198 / seconds
Query Executed:select id FROM `nh` where city='Newton Junction' && SIC_code='7231'DB:business_master_new
loadtime:1.0550711154938 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Conway' limit 1
loadtime:1.0551450252533 / seconds
Query Executed:select id FROM `nh` where city='North Conway' && SIC_code='7231'DB:business_master_new
loadtime:1.0636110305786 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hampton' limit 1
loadtime:1.0637011528015 / seconds
Query Executed:select id FROM `nh` where city='North Hampton' && SIC_code='7231'DB:business_master_new
loadtime:1.0703930854797 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Haverhill' limit 1
loadtime:1.0704870223999 / seconds
Query Executed:select id FROM `nh` where city='North Haverhill' && SIC_code='7231'DB:business_master_new
loadtime:1.0721809864044 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Salem' limit 1
loadtime:1.0722441673279 / seconds
Query Executed:select id FROM `nh` where city='North Salem' && SIC_code='7231'DB:business_master_new
loadtime:1.0730409622192 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Sandwich' limit 1
loadtime:1.0731129646301 / seconds
Query Executed:select id FROM `nh` where city='North Sandwich' && SIC_code='7231'DB:business_master_new
loadtime:1.0737860202789 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Stratford' limit 1
loadtime:1.073860168457 / seconds
Query Executed:select id FROM `nh` where city='North Stratford' && SIC_code='7231'DB:business_master_new
loadtime:1.0747230052948 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Sutton' limit 1
loadtime:1.0748009681702 / seconds
Query Executed:select id FROM `nh` where city='North Sutton' && SIC_code='7231'DB:business_master_new
loadtime:1.0756649971008 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Walpole' limit 1
loadtime:1.0757431983948 / seconds
Query Executed:select id FROM `nh` where city='North Walpole' && SIC_code='7231'DB:business_master_new
loadtime:1.0765600204468 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Woodstock' limit 1
loadtime:1.0766379833221 / seconds
Query Executed:select id FROM `nh` where city='North Woodstock' && SIC_code='7231'DB:business_master_new
loadtime:1.0781161785126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:1.0781941413879 / seconds
Query Executed:select id FROM `nh` where city='Northfield' && SIC_code='7231'DB:business_master_new
loadtime:1.0786981582642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northwood' limit 1
loadtime:1.0787601470947 / seconds
Query Executed:select id FROM `nh` where city='Northwood' && SIC_code='7231'DB:business_master_new
loadtime:1.0933749675751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nottingham' limit 1
loadtime:1.0934541225433 / seconds
Query Executed:select id FROM `nh` where city='Nottingham' && SIC_code='7231'DB:business_master_new
loadtime:1.0951311588287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:1.0952100753784 / seconds
Query Executed:select id FROM `nh` where city='Orange' && SIC_code='7231'DB:business_master_new
loadtime:1.0956580638885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orford' limit 1
loadtime:1.0957210063934 / seconds
Query Executed:select id FROM `nh` where city='Orford' && SIC_code='7231'DB:business_master_new
loadtime:1.0969560146332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ossipee' limit 1
loadtime:1.0970520973206 / seconds
Query Executed:select id FROM `nh` where city='Ossipee' && SIC_code='7231'DB:business_master_new
loadtime:1.1115560531616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelham' limit 1
loadtime:1.1116399765015 / seconds
Query Executed:select id FROM `nh` where city='Pelham' && SIC_code='7231'DB:business_master_new
loadtime:1.1186580657959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:1.1187460422516 / seconds
Query Executed:select id FROM `nh` where city='Pembroke' && SIC_code='7231'DB:business_master_new
loadtime:1.1192741394043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penacook' limit 1
loadtime:1.1193370819092 / seconds
Query Executed:select id FROM `nh` where city='Penacook' && SIC_code='7231'DB:business_master_new
loadtime:1.1198060512543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peterborough' limit 1
loadtime:1.1198680400848 / seconds
Query Executed:select id FROM `nh` where city='Peterborough' && SIC_code='7231'DB:business_master_new
loadtime:1.1276521682739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piermont' limit 1
loadtime:1.1277370452881 / seconds
Query Executed:select id FROM `nh` where city='Piermont' && SIC_code='7231'DB:business_master_new
loadtime:1.1285910606384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pike' limit 1
loadtime:1.1286551952362 / seconds
Query Executed:select id FROM `nh` where city='Pike' && SIC_code='7231'DB:business_master_new
loadtime:1.1292171478271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsburg' limit 1
loadtime:1.1292929649353 / seconds
Query Executed:select id FROM `nh` where city='Pittsburg' && SIC_code='7231'DB:business_master_new
loadtime:1.1306190490723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsfield' limit 1
loadtime:1.1306810379028 / seconds
Query Executed:select id FROM `nh` where city='Pittsfield' && SIC_code='7231'DB:business_master_new
loadtime:1.1451101303101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:1.1451930999756 / seconds
Query Executed:select id FROM `nh` where city='Plainfield' && SIC_code='7231'DB:business_master_new
loadtime:1.1464130878448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plaistow' limit 1
loadtime:1.1464900970459 / seconds
Query Executed:select id FROM `nh` where city='Plaistow' && SIC_code='7231'DB:business_master_new
loadtime:1.1548881530762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:1.154993057251 / seconds
Query Executed:select id FROM `nh` where city='Plymouth' && SIC_code='7231'DB:business_master_new
loadtime:1.1617531776428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portsmouth' limit 1
loadtime:1.161856174469 / seconds
Query Executed:select id FROM `nh` where city='Portsmouth' && SIC_code='7231'DB:business_master_new
loadtime:1.195338010788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:1.1955161094666 / seconds
Query Executed:select id FROM `nh` where city='Randolph' && SIC_code='7231'DB:business_master_new
loadtime:1.196063041687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:1.1961450576782 / seconds
Query Executed:select id FROM `nh` where city='Raymond' && SIC_code='7231'DB:business_master_new
loadtime:1.2015190124512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:1.2016050815582 / seconds
Query Executed:select id FROM `nh` where city='Richmond' && SIC_code='7231'DB:business_master_new
loadtime:1.2020661830902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rindge' limit 1
loadtime:1.2021400928497 / seconds
Query Executed:select id FROM `nh` where city='Rindge' && SIC_code='7231'DB:business_master_new
loadtime:1.2064571380615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:1.2065379619598 / seconds
Query Executed:select id FROM `nh` where city='Rochester' && SIC_code='7231'DB:business_master_new
loadtime:1.2217600345612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rollinsford' limit 1
loadtime:1.22190117836 / seconds
Query Executed:select id FROM `nh` where city='Rollinsford' && SIC_code='7231'DB:business_master_new
loadtime:1.2234539985657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:1.2235391139984 / seconds
Query Executed:select id FROM `nh` where city='Roxbury' && SIC_code='7231'DB:business_master_new
loadtime:1.2239530086517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rumney' limit 1
loadtime:1.2240180969238 / seconds
Query Executed:select id FROM `nh` where city='Rumney' && SIC_code='7231'DB:business_master_new
loadtime:1.2255520820618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rye' limit 1
loadtime:1.2256300449371 / seconds
Query Executed:select id FROM `nh` where city='Rye' && SIC_code='7231'DB:business_master_new
loadtime:1.2306690216064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rye Beach' limit 1
loadtime:1.2307481765747 / seconds
Query Executed:select id FROM `nh` where city='Rye Beach' && SIC_code='7231'DB:business_master_new
loadtime:1.2316501140594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:1.2317140102386 / seconds
Query Executed:select id FROM `nh` where city='Salem' && SIC_code='7231'DB:business_master_new
loadtime:1.254664182663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:1.2548429965973 / seconds
Query Executed:select id FROM `nh` where city='Salisbury' && SIC_code='7231'DB:business_master_new
loadtime:1.2558751106262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanbornton' limit 1
loadtime:1.2559521198273 / seconds
Query Executed:select id FROM `nh` where city='Sanbornton' && SIC_code='7231'DB:business_master_new
loadtime:1.2710070610046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanbornville' limit 1
loadtime:1.2710711956024 / seconds
Query Executed:select id FROM `nh` where city='Sanbornville' && SIC_code='7231'DB:business_master_new
loadtime:1.2856080532074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandown' limit 1
loadtime:1.2856941223145 / seconds
Query Executed:select id FROM `nh` where city='Sandown' && SIC_code='7231'DB:business_master_new
loadtime:1.2999460697174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seabrook' limit 1
loadtime:1.30002617836 / seconds
Query Executed:select id FROM `nh` where city='Seabrook' && SIC_code='7231'DB:business_master_new
loadtime:1.3069930076599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:1.3070809841156 / seconds
Query Executed:select id FROM `nh` where city='Sharon' && SIC_code='7231'DB:business_master_new
loadtime:1.307559967041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelburne' limit 1
loadtime:1.3076241016388 / seconds
Query Executed:select id FROM `nh` where city='Shelburne' && SIC_code='7231'DB:business_master_new
loadtime:1.3081200122833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Lake' limit 1
loadtime:1.3081810474396 / seconds
Query Executed:select id FROM `nh` where city='Silver Lake' && SIC_code='7231'DB:business_master_new
loadtime:1.3088569641113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somersworth' limit 1
loadtime:1.3089179992676 / seconds
Query Executed:select id FROM `nh` where city='Somersworth' && SIC_code='7231'DB:business_master_new
loadtime:1.3164691925049 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Acworth' limit 1
loadtime:1.316565990448 / seconds
Query Executed:select id FROM `nh` where city='South Acworth' && SIC_code='7231'DB:business_master_new
loadtime:1.3171780109406 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Effingham' limit 1
loadtime:1.3172450065613 / seconds
Query Executed:select id FROM `nh` where city='South Effingham' && SIC_code='7231'DB:business_master_new
loadtime:1.3176369667053 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hampton' limit 1
loadtime:1.3176980018616 / seconds
Query Executed:select id FROM `nh` where city='South Hampton' && SIC_code='7231'DB:business_master_new
loadtime:1.3181300163269 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Newbury' limit 1
loadtime:1.3181920051575 / seconds
Query Executed:select id FROM `nh` where city='South Newbury' && SIC_code='7231'DB:business_master_new
loadtime:1.3186430931091 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Sutton' limit 1
loadtime:1.3187041282654 / seconds
Query Executed:select id FROM `nh` where city='South Sutton' && SIC_code='7231'DB:business_master_new
loadtime:1.3193190097809 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Tamworth' limit 1
loadtime:1.3193809986115 / seconds
Query Executed:select id FROM `nh` where city='South Tamworth' && SIC_code='7231'DB:business_master_new
loadtime:1.3199620246887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spofford' limit 1
loadtime:1.3200240135193 / seconds
Query Executed:select id FROM `nh` where city='Spofford' && SIC_code='7231'DB:business_master_new
loadtime:1.321161031723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:1.3212361335754 / seconds
Query Executed:select id FROM `nh` where city='Springfield' && SIC_code='7231'DB:business_master_new
loadtime:1.3221530914307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stark' limit 1
loadtime:1.3222150802612 / seconds
Query Executed:select id FROM `nh` where city='Stark' && SIC_code='7231'DB:business_master_new
loadtime:1.3226091861725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stewartstown' limit 1
loadtime:1.3226699829102 / seconds
Query Executed:select id FROM `nh` where city='Stewartstown' && SIC_code='7231'DB:business_master_new
loadtime:1.3230850696564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stinson Lake' limit 1
loadtime:1.3231580257416 / seconds
Query Executed:select id FROM `nh` where city='Stinson Lake' && SIC_code='7231'DB:business_master_new
loadtime:1.3235511779785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoddard' limit 1
loadtime:1.3236119747162 / seconds
Query Executed:select id FROM `nh` where city='Stoddard' && SIC_code='7231'DB:business_master_new
loadtime:1.3243470191956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strafford' limit 1
loadtime:1.3244080543518 / seconds
Query Executed:select id FROM `nh` where city='Strafford' && SIC_code='7231'DB:business_master_new
loadtime:1.3255610466003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratham' limit 1
loadtime:1.3256220817566 / seconds
Query Executed:select id FROM `nh` where city='Stratham' && SIC_code='7231'DB:business_master_new
loadtime:1.3315451145172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar Hill' limit 1
loadtime:1.3316340446472 / seconds
Query Executed:select id FROM `nh` where city='Sugar Hill' && SIC_code='7231'DB:business_master_new
loadtime:1.3322920799255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sullivan' limit 1
loadtime:1.3323559761047 / seconds
Query Executed:select id FROM `nh` where city='Sullivan' && SIC_code='7231'DB:business_master_new
loadtime:1.33305311203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunapee' limit 1
loadtime:1.3331251144409 / seconds
Query Executed:select id FROM `nh` where city='Sunapee' && SIC_code='7231'DB:business_master_new
loadtime:1.347748041153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suncook' limit 1
loadtime:1.34783411026 / seconds
Query Executed:select id FROM `nh` where city='Suncook' && SIC_code='7231'DB:business_master_new
loadtime:1.3545670509338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surry' limit 1
loadtime:1.3546621799469 / seconds
Query Executed:select id FROM `nh` where city='Surry' && SIC_code='7231'DB:business_master_new
loadtime:1.3551330566406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swanzey' limit 1
loadtime:1.3551981449127 / seconds
Query Executed:select id FROM `nh` where city='Swanzey' && SIC_code='7231'DB:business_master_new
loadtime:1.3595020771027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tamworth' limit 1
loadtime:1.3595840930939 / seconds
Query Executed:select id FROM `nh` where city='Tamworth' && SIC_code='7231'DB:business_master_new
loadtime:1.3740420341492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temple' limit 1
loadtime:1.3741321563721 / seconds
Query Executed:select id FROM `nh` where city='Temple' && SIC_code='7231'DB:business_master_new
loadtime:1.375351190567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornton' limit 1
loadtime:1.3754131793976 / seconds
Query Executed:select id FROM `nh` where city='Thornton' && SIC_code='7231'DB:business_master_new
loadtime:1.3761320114136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tilton' limit 1
loadtime:1.3762090206146 / seconds
Query Executed:select id FROM `nh` where city='Tilton' && SIC_code='7231'DB:business_master_new
loadtime:1.3830740451813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:1.3831820487976 / seconds
Query Executed:select id FROM `nh` where city='Troy' && SIC_code='7231'DB:business_master_new
loadtime:1.3845181465149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twin Mountain' limit 1
loadtime:1.3845980167389 / seconds
Query Executed:select id FROM `nh` where city='Twin Mountain' && SIC_code='7231'DB:business_master_new
loadtime:1.3857290744781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:1.3858051300049 / seconds
Query Executed:select id FROM `nh` where city='Union' && SIC_code='7231'DB:business_master_new
loadtime:1.3868889808655 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Chesterfield' limit 1
loadtime:1.3869550228119 / seconds
Query Executed:select id FROM `nh` where city='W Chesterfield' && SIC_code='7231'DB:business_master_new
loadtime:1.3874530792236 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Peterborough' limit 1
loadtime:1.3875141143799 / seconds
Query Executed:select id FROM `nh` where city='W Peterborough' && SIC_code='7231'DB:business_master_new
loadtime:1.3879389762878 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Stewartstown' limit 1
loadtime:1.3880140781403 / seconds
Query Executed:select id FROM `nh` where city='W Stewartstown' && SIC_code='7231'DB:business_master_new
loadtime:1.3887281417847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walpole' limit 1
loadtime:1.3888080120087 / seconds
Query Executed:select id FROM `nh` where city='Walpole' && SIC_code='7231'DB:business_master_new
loadtime:1.4034130573273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warner' limit 1
loadtime:1.4034931659698 / seconds
Query Executed:select id FROM `nh` where city='Warner' && SIC_code='7231'DB:business_master_new
loadtime:1.4178810119629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:1.4179639816284 / seconds
Query Executed:select id FROM `nh` where city='Warren' && SIC_code='7231'DB:business_master_new
loadtime:1.4187831878662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:1.4188601970673 / seconds
Query Executed:select id FROM `nh` where city='Washington' && SIC_code='7231'DB:business_master_new
loadtime:1.4197580814362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville Valley' limit 1
loadtime:1.4198219776154 / seconds
Query Executed:select id FROM `nh` where city='Waterville Valley' && SIC_code='7231'DB:business_master_new
loadtime:1.4208390712738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville Vly' limit 1
loadtime:1.4209001064301 / seconds
Query Executed:select id FROM `nh` where city='Waterville Vly' && SIC_code='7231'DB:business_master_new
loadtime:1.4213671684265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weare' limit 1
loadtime:1.4214279651642 / seconds
Query Executed:select id FROM `nh` where city='Weare' && SIC_code='7231'DB:business_master_new
loadtime:1.4270331859589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:1.4271340370178 / seconds
Query Executed:select id FROM `nh` where city='Webster' && SIC_code='7231'DB:business_master_new
loadtime:1.4276180267334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworth' limit 1
loadtime:1.4276821613312 / seconds
Query Executed:select id FROM `nh` where city='Wentworth' && SIC_code='7231'DB:business_master_new
loadtime:1.4286160469055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworths Loctn' limit 1
loadtime:1.4286921024323 / seconds
Query Executed:select id FROM `nh` where city='Wentworths Loctn' && SIC_code='7231'DB:business_master_new
loadtime:1.4291200637817 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chesterfield' limit 1
loadtime:1.4291820526123 / seconds
Query Executed:select id FROM `nh` where city='West Chesterfield' && SIC_code='7231'DB:business_master_new
loadtime:1.4300920963287 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Lebanon' limit 1
loadtime:1.4301810264587 / seconds
Query Executed:select id FROM `nh` where city='West Lebanon' && SIC_code='7231'DB:business_master_new
loadtime:1.4368259906769 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Nottingham' limit 1
loadtime:1.4369201660156 / seconds
Query Executed:select id FROM `nh` where city='West Nottingham' && SIC_code='7231'DB:business_master_new
loadtime:1.4374651908875 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Ossipee' limit 1
loadtime:1.4375309944153 / seconds
Query Executed:select id FROM `nh` where city='West Ossipee' && SIC_code='7231'DB:business_master_new
loadtime:1.4386131763458 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Peterborough' limit 1
loadtime:1.4386739730835 / seconds
Query Executed:select id FROM `nh` where city='West Peterborough' && SIC_code='7231'DB:business_master_new
loadtime:1.4391980171204 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Springfield' limit 1
loadtime:1.4392590522766 / seconds
Query Executed:select id FROM `nh` where city='West Springfield' && SIC_code='7231'DB:business_master_new
loadtime:1.4397161006927 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Stewartstown' limit 1
loadtime:1.439777135849 / seconds
Query Executed:select id FROM `nh` where city='West Stewartstown' && SIC_code='7231'DB:business_master_new
loadtime:1.4404101371765 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Swanzey' limit 1
loadtime:1.4404850006104 / seconds
Query Executed:select id FROM `nh` where city='West Swanzey' && SIC_code='7231'DB:business_master_new
loadtime:1.4415700435638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westmoreland' limit 1
loadtime:1.4416470527649 / seconds
Query Executed:select id FROM `nh` where city='Westmoreland' && SIC_code='7231'DB:business_master_new
loadtime:1.4430270195007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitefield' limit 1
loadtime:1.4431140422821 / seconds
Query Executed:select id FROM `nh` where city='Whitefield' && SIC_code='7231'DB:business_master_new
loadtime:1.4577240943909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmot' limit 1
loadtime:1.4578070640564 / seconds
Query Executed:select id FROM `nh` where city='Wilmot' && SIC_code='7231'DB:business_master_new
loadtime:1.4720749855042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmot Flat' limit 1
loadtime:1.4721660614014 / seconds
Query Executed:select id FROM `nh` where city='Wilmot Flat' && SIC_code='7231'DB:business_master_new
loadtime:1.4725520610809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:1.4726140499115 / seconds
Query Executed:select id FROM `nh` where city='Wilton' && SIC_code='7231'DB:business_master_new
loadtime:1.4773020744324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:1.477382183075 / seconds
Query Executed:select id FROM `nh` where city='Winchester' && SIC_code='7231'DB:business_master_new
loadtime:1.4811170101166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windham' limit 1
loadtime:1.4811990261078 / seconds
Query Executed:select id FROM `nh` where city='Windham' && SIC_code='7231'DB:business_master_new
loadtime:1.4887320995331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:1.4888260364532 / seconds
Query Executed:select id FROM `nh` where city='Windsor' && SIC_code='7231'DB:business_master_new
loadtime:1.4892740249634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winnisquam' limit 1
loadtime:1.4893391132355 / seconds
Query Executed:select id FROM `nh` where city='Winnisquam' && SIC_code='7231'DB:business_master_new
loadtime:1.5034871101379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolfeboro' limit 1
loadtime:1.503564119339 / seconds
Query Executed:select id FROM `nh` where city='Wolfeboro' && SIC_code='7231'DB:business_master_new
loadtime:1.5112271308899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolfeboro Falls' limit 1
loadtime:1.5113279819489 / seconds
Query Executed:select id FROM `nh` where city='Wolfeboro Falls' && SIC_code='7231'DB:business_master_new
loadtime:1.5136649608612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wonalancet' limit 1
loadtime:1.5137441158295 / seconds
Query Executed:select id FROM `nh` where city='Wonalancet' && SIC_code='7231'DB:business_master_new
loadtime:1.5141839981079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:1.5142459869385 / seconds
Query Executed:select id FROM `nh` where city='Woodstock' && SIC_code='7231'DB:business_master_new
loadtime:1.528400182724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodsville' limit 1
loadtime:1.5284621715546 / seconds
Query Executed:select id FROM `nh` where city='Woodsville' && SIC_code='7231'DB:business_master_new
loadtime:1.531699180603 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.5318751335144 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.5322911739349 / seconds
Operation template executed (chunk cache operation)
loadtime:1.5324549674988 / seconds
template override:Default
loadtime:1.5324959754944 / 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:1.5337891578674 / seconds
Template Constructed, Array Rows:49
loadtime:1.5343310832977 / seconds
TOTAL EXECUTION TIME: 1.53388
loadtime:1.5362260341644 / 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] => beauty-shops [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:1.5362370014191
TOTAL KEY ARRAYS: 69