Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:5.1021575927734E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00043702125549316 / seconds
host not found setting manual db connection
loadtime:0.00078392028808594 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0010800361633301 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0012049674987793 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0012519359588623 / seconds
zipcode:
loadtime:0.0012679100036621 / seconds
Query Executed:select * from search_referrer where page_hash='0c6e2848e850c2b05455a68404f66052' limit 10 DB:ezrox_toadli
loadtime:0.0014679431915283 / seconds
Operation header executed (non global)
loadtime:0.0014960765838623 / seconds
Operation leaderboard executed (non global)
loadtime:0.001539945602417 / seconds
Operation square executed (non global)
loadtime:0.0015640258789062 / seconds
Operation square_bottom executed (non global)
loadtime:0.0015869140625 / seconds
Operation smallsquare executed (non global)
loadtime:0.0016059875488281 / seconds
Operation headeradright executed (non global)
loadtime:0.0016250610351562 / seconds
Operation google_analytics executed (non global)
loadtime:0.0016429424285889 / seconds
Operation topstories executed (non global)
loadtime:0.001662015914917 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0016810894012451 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0016980171203613 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.002173900604248 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.002357006072998 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0023970603942871 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0024518966674805 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0025770664215088 / seconds
Template key: archive_menu pushed
loadtime:0.0025820732116699 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0025880336761475 / seconds
Template key: get_gravatar pushed
loadtime:0.0025920867919922 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0025959014892578 / seconds
*10)-10)+1 | start:0
loadtime:0.0026240348815918 / seconds
DB connected to localhost business_master_new
loadtime:0.0028519630432129 / seconds
Query Executed:select * from categories where cat_URLid='general-contractors-single-family-houses'DB:business_master_new
loadtime:0.0033910274505615 / seconds
Query stored in cache : _QUERY_www.toadli.comf23e047c12325c5b12fb95554fe42a66
loadtime:0.0034229755401611 / seconds
Query Executed:select * from geodata_usstates where url_id='new-hampshire'DB:business_master_new
loadtime:0.0035851001739502 / seconds
Query stored in cache : _QUERY_www.toadli.coma18ca27a314d08cbdc4b1d1da4fd4824
loadtime:0.0036170482635498 / seconds
Query Executed:select * from `nh_catmap` where sic='1521' order by city ascDB:business_master_new
loadtime:0.0745530128479 / seconds
Query stored in cache : _QUERY_www.toadli.com6174ee64b396e97eaf2003d9e2fafe71
loadtime:0.075392961502075 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-hampshire'
loadtime:0.075443983078003 / seconds
Query Executed:select sum(totalcount) as totalsum from `nh_catmap` where sic='1521'DB:business_master_new
loadtime:0.0800940990448 / seconds
Query stored in cache : _QUERY_www.toadli.com17ccbc71c0601caa39bb28dc9dcc8ee8
loadtime:0.08013391494751 / seconds
309 / 11
loadtime:0.080206871032715 / seconds
Query Executed:select * from geodata_geocity where city='Acworth' limit 1DB:business_master_new
loadtime:0.080759048461914 / seconds
Query stored in cache : _QUERY_www.toadli.com028637895891b8eae53d42ac5a84415d
loadtime:0.080832004547119 / seconds
Query Executed:select id FROM `nh` where city='Acworth' && SIC_code='1521'DB:business_master_new
loadtime:0.091332912445068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albany' limit 1
loadtime:0.091391086578369 / seconds
Query Executed:select id FROM `nh` where city='Albany' && SIC_code='1521'DB:business_master_new
loadtime:0.095467090606689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexandria' limit 1
loadtime:0.095509052276611 / seconds
Query Executed:select id FROM `nh` where city='Alexandria' && SIC_code='1521'DB:business_master_new
loadtime:0.097445011138916 / seconds
Query Executed:select * from geodata_geocity where city='Allenstown' limit 1DB:business_master_new
loadtime:0.097706079483032 / seconds
Query stored in cache : _QUERY_www.toadli.com4e46dbe7f0ce29c185b47c5e81467e65
loadtime:0.097738027572632 / seconds
Query Executed:select id FROM `nh` where city='Allenstown' && SIC_code='1521'DB:business_master_new
loadtime:0.1017849445343 / seconds
Query Executed:select * from geodata_geocity where city='Alstead' limit 1DB:business_master_new
loadtime:0.10205388069153 / seconds
Query stored in cache : _QUERY_www.toadli.com59697b7d404b6f199e1b1a518f2628c6
loadtime:0.10209798812866 / seconds
Query Executed:select id FROM `nh` where city='Alstead' && SIC_code='1521'DB:business_master_new
loadtime:0.10517501831055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.10527205467224 / seconds
Query Executed:select id FROM `nh` where city='Alton' && SIC_code='1521'DB:business_master_new
loadtime:0.11126089096069 / seconds
Query Executed:select * from geodata_geocity where city='Alton Bay' limit 1DB:business_master_new
loadtime:0.11152100563049 / seconds
Query stored in cache : _QUERY_www.toadli.com0eef878ea5830529bf0021b543288cc2
loadtime:0.11155200004578 / seconds
Query Executed:select id FROM `nh` where city='Alton Bay' && SIC_code='1521'DB:business_master_new
loadtime:0.15300893783569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.15310907363892 / seconds
Query Executed:select id FROM `nh` where city='Amherst' && SIC_code='1521'DB:business_master_new
loadtime:0.16746401786804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.16758799552917 / seconds
Query Executed:select id FROM `nh` where city='Andover' && SIC_code='1521'DB:business_master_new
loadtime:0.17102193832397 / seconds
Query Executed:select * from geodata_geocity where city='Antrim' limit 1DB:business_master_new
loadtime:0.17129397392273 / seconds
Query stored in cache : _QUERY_www.toadli.com3d2025284ffe8237e5c014039618fb18
loadtime:0.17133688926697 / seconds
Query Executed:select id FROM `nh` where city='Antrim' && SIC_code='1521'DB:business_master_new
loadtime:0.17423987388611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.17429804801941 / seconds
Query Executed:select id FROM `nh` where city='Ashland' && SIC_code='1521'DB:business_master_new
loadtime:0.17625093460083 / seconds
Query Executed:select * from geodata_geocity where city='Ashuelot' limit 1DB:business_master_new
loadtime:0.1765239238739 / seconds
Query stored in cache : _QUERY_www.toadli.com11a2efaa620e43bb81854826c8b4e0e0
loadtime:0.1765570640564 / seconds
Query Executed:select id FROM `nh` where city='Ashuelot' && SIC_code='1521'DB:business_master_new
loadtime:0.18370890617371 / seconds
Query Executed:select * from geodata_geocity where city='Atkinson' limit 1DB:business_master_new
loadtime:0.18396306037903 / seconds
Query stored in cache : _QUERY_www.toadli.comb7e8618748d2c784eb06f4f12743b477
loadtime:0.18400907516479 / seconds
Query Executed:select id FROM `nh` where city='Atkinson' && SIC_code='1521'DB:business_master_new
loadtime:0.18843388557434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.18848705291748 / seconds
Query Executed:select id FROM `nh` where city='Auburn' && SIC_code='1521'DB:business_master_new
loadtime:0.19630289077759 / seconds
Query Executed:select * from geodata_geocity where city='Barnstead' limit 1DB:business_master_new
loadtime:0.19656491279602 / seconds
Query stored in cache : _QUERY_www.toadli.com4f427483e4f8ae236abe64118c64c0b3
loadtime:0.19661092758179 / seconds
Query Executed:select id FROM `nh` where city='Barnstead' && SIC_code='1521'DB:business_master_new
loadtime:0.21992301940918 / seconds
Query Executed:select * from geodata_geocity where city='Barrington' limit 1DB:business_master_new
loadtime:0.2204749584198 / seconds
Query stored in cache : _QUERY_www.toadli.com89eed680674ea331c79ecc0d1286ac7f
loadtime:0.22053194046021 / seconds
Query Executed:select id FROM `nh` where city='Barrington' && SIC_code='1521'DB:business_master_new
loadtime:0.22822189331055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bartlett' limit 1
loadtime:0.22827792167664 / seconds
Query Executed:select id FROM `nh` where city='Bartlett' && SIC_code='1521'DB:business_master_new
loadtime:0.23066186904907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.23071503639221 / seconds
Query Executed:select id FROM `nh` where city='Bath' && SIC_code='1521'DB:business_master_new
loadtime:0.24765586853027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.24770498275757 / seconds
Query Executed:select id FROM `nh` where city='Bedford' && SIC_code='1521'DB:business_master_new
loadtime:0.26537609100342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.26546001434326 / seconds
Query Executed:select id FROM `nh` where city='Belmont' && SIC_code='1521'DB:business_master_new
loadtime:0.27308392524719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennington' limit 1
loadtime:0.27315402030945 / seconds
Query Executed:select id FROM `nh` where city='Bennington' && SIC_code='1521'DB:business_master_new
loadtime:0.29282093048096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benton' limit 1
loadtime:0.29288387298584 / seconds
Query Executed:select id FROM `nh` where city='Benton' && SIC_code='1521'DB:business_master_new
loadtime:0.29313707351685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.29319000244141 / seconds
Query Executed:select id FROM `nh` where city='Berlin' && SIC_code='1521'DB:business_master_new
loadtime:0.29751491546631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethlehem' limit 1
loadtime:0.29757690429688 / seconds
Query Executed:select id FROM `nh` where city='Bethlehem' && SIC_code='1521'DB:business_master_new
loadtime:0.29949903488159 / seconds
Query Executed:select * from geodata_geocity where city='Boscawen' limit 1DB:business_master_new
loadtime:0.29980087280273 / seconds
Query stored in cache : _QUERY_www.toadli.com8d19aeaaed3e8312378c47a15ac268cb
loadtime:0.29984307289124 / seconds
Query Executed:select id FROM `nh` where city='Boscawen' && SIC_code='1521'DB:business_master_new
loadtime:0.30216097831726 / seconds
Query Executed:select * from geodata_geocity where city='Bow' limit 1DB:business_master_new
loadtime:0.30244898796082 / seconds
Query stored in cache : _QUERY_www.toadli.com343406f2627fd02493e32fd36b70b002
loadtime:0.30249500274658 / seconds
Query Executed:select id FROM `nh` where city='Bow' && SIC_code='1521'DB:business_master_new
loadtime:0.31350302696228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.31356906890869 / seconds
Query Executed:select id FROM `nh` where city='Bradford' && SIC_code='1521'DB:business_master_new
loadtime:0.31654500961304 / seconds
Query Executed:select * from geodata_geocity where city='Brentwood' limit 1DB:business_master_new
loadtime:0.31717896461487 / seconds
Query stored in cache : _QUERY_www.toadli.comd9f64a4a4c4d2ba61883592e2e671c77
loadtime:0.31729006767273 / seconds
Query Executed:select id FROM `nh` where city='Brentwood' && SIC_code='1521'DB:business_master_new
loadtime:0.32059502601624 / seconds
Query Executed:select * from geodata_geocity where city='Bretton Woods' limit 1DB:business_master_new
loadtime:0.32087397575378 / seconds
Query stored in cache : _QUERY_www.toadli.comfe6f58ed8b3e5590cdc1b56932632f7d
loadtime:0.3209080696106 / seconds
Query Executed:select id FROM `nh` where city='Bretton Woods' && SIC_code='1521'DB:business_master_new
loadtime:0.32439589500427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.32445096969604 / seconds
Query Executed:select id FROM `nh` where city='Bristol' && SIC_code='1521'DB:business_master_new
loadtime:0.33204102516174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.33211088180542 / seconds
Query Executed:select id FROM `nh` where city='Brookfield' && SIC_code='1521'DB:business_master_new
loadtime:0.33315110206604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline' limit 1
loadtime:0.33320307731628 / seconds
Query Executed:select id FROM `nh` where city='Brookline' && SIC_code='1521'DB:business_master_new
loadtime:0.33675789833069 / seconds
Query Executed:select * from geodata_geocity where city='Campton' limit 1DB:business_master_new
loadtime:0.33705902099609 / seconds
Query stored in cache : _QUERY_www.toadli.com96f369c2c454763661b1d27d652b61f8
loadtime:0.33710098266602 / seconds
Query Executed:select id FROM `nh` where city='Campton' && SIC_code='1521'DB:business_master_new
loadtime:0.34431600570679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canaan' limit 1
loadtime:0.34438300132751 / seconds
Query Executed:select id FROM `nh` where city='Canaan' && SIC_code='1521'DB:business_master_new
loadtime:0.34768199920654 / seconds
Query Executed:select * from geodata_geocity where city='Candia' limit 1DB:business_master_new
loadtime:0.34795808792114 / seconds
Query stored in cache : _QUERY_www.toadli.comf08b36f21d52e97fba85ffc6f9de443a
loadtime:0.34799695014954 / seconds
Query Executed:select id FROM `nh` where city='Candia' && SIC_code='1521'DB:business_master_new
loadtime:0.35241389274597 / seconds
Query Executed:select * from geodata_geocity where city='Canterbury' limit 1DB:business_master_new
loadtime:0.35269689559937 / seconds
Query stored in cache : _QUERY_www.toadli.com7b4df376b9c55c36839787f62b04915d
loadtime:0.35273504257202 / seconds
Query Executed:select id FROM `nh` where city='Canterbury' && SIC_code='1521'DB:business_master_new
loadtime:0.35694289207458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carroll' limit 1
loadtime:0.35701203346252 / seconds
Query Executed:select id FROM `nh` where city='Carroll' && SIC_code='1521'DB:business_master_new
loadtime:0.35813999176025 / seconds
Query Executed:select * from geodata_geocity where city='Center Barnstead' limit 1DB:business_master_new
loadtime:0.35843110084534 / seconds
Query stored in cache : _QUERY_www.toadli.comab55ac09058da5c9ab5088f805e7ef47
loadtime:0.35848808288574 / seconds
Query Executed:select id FROM `nh` where city='Center Barnstead' && SIC_code='1521'DB:business_master_new
loadtime:0.36035394668579 / seconds
Query Executed:select * from geodata_geocity where city='Center Conway' limit 1DB:business_master_new
loadtime:0.36062407493591 / seconds
Query stored in cache : _QUERY_www.toadli.coma9ff9ca0766ccf6c6e0d7cb9b4f55c40
loadtime:0.36065602302551 / seconds
Query Executed:select id FROM `nh` where city='Center Conway' && SIC_code='1521'DB:business_master_new
loadtime:0.36465692520142 / seconds
Query Executed:select * from geodata_geocity where city='Center Harbor' limit 1DB:business_master_new
loadtime:0.36495494842529 / seconds
Query stored in cache : _QUERY_www.toadli.com9e3941cba42658eea69f2d5fcaed9321
loadtime:0.36499404907227 / seconds
Query Executed:select id FROM `nh` where city='Center Harbor' && SIC_code='1521'DB:business_master_new
loadtime:0.36973905563354 / seconds
Query Executed:select * from geodata_geocity where city='Center Ossipee' limit 1DB:business_master_new
loadtime:0.37028288841248 / seconds
Query stored in cache : _QUERY_www.toadli.com38c4471b903579dd79342e22b86c72e1
loadtime:0.37034606933594 / seconds
Query Executed:select id FROM `nh` where city='Center Ossipee' && SIC_code='1521'DB:business_master_new
loadtime:0.37242794036865 / seconds
Query Executed:select * from geodata_geocity where city='Center Sandwich' limit 1DB:business_master_new
loadtime:0.37268900871277 / seconds
Query stored in cache : _QUERY_www.toadli.com2906aa91981f7561a6046df8b01a1402
loadtime:0.37273192405701 / seconds
Query Executed:select id FROM `nh` where city='Center Sandwich' && SIC_code='1521'DB:business_master_new
loadtime:0.40123105049133 / seconds
Query Executed:select * from geodata_geocity where city='Center Strafford' limit 1DB:business_master_new
loadtime:0.40151691436768 / seconds
Query stored in cache : _QUERY_www.toadli.com4e0c24287743a67db85108b62e190654
loadtime:0.40155386924744 / seconds
Query Executed:select id FROM `nh` where city='Center Strafford' && SIC_code='1521'DB:business_master_new
loadtime:0.40925002098083 / seconds
Query Executed:select * from geodata_geocity where city='Center Tuftonboro' limit 1DB:business_master_new
loadtime:0.40970587730408 / seconds
Query stored in cache : _QUERY_www.toadli.com3cd12ff585865faa79df6af53bc7f2ce
loadtime:0.40978503227234 / seconds
Query Executed:select id FROM `nh` where city='Center Tuftonboro' && SIC_code='1521'DB:business_master_new
loadtime:0.43769907951355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlestown' limit 1
loadtime:0.43779993057251 / seconds
Query Executed:select id FROM `nh` where city='Charlestown' && SIC_code='1521'DB:business_master_new
loadtime:0.44124889373779 / seconds
Query Executed:select * from geodata_geocity where city='Chatham' limit 1DB:business_master_new
loadtime:0.44165301322937 / seconds
Query stored in cache : _QUERY_www.toadli.com8cc77b2101af7fe7ca774bde8a308e5f
loadtime:0.44173192977905 / seconds
Query Executed:select id FROM `nh` where city='Chatham' && SIC_code='1521'DB:business_master_new
loadtime:0.44369792938232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.44374990463257 / seconds
Query Executed:select id FROM `nh` where city='Chester' && SIC_code='1521'DB:business_master_new
loadtime:0.45291900634766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:0.45298409461975 / seconds
Query Executed:select id FROM `nh` where city='Chesterfield' && SIC_code='1521'DB:business_master_new
loadtime:0.47548294067383 / seconds
Query Executed:select * from geodata_geocity where city='Chichester' limit 1DB:business_master_new
loadtime:0.47584390640259 / seconds
Query stored in cache : _QUERY_www.toadli.com3a2912ade1c5ef7fa9a9e9aefc6987a5
loadtime:0.47588205337524 / seconds
Query Executed:select id FROM `nh` where city='Chichester' && SIC_code='1521'DB:business_master_new
loadtime:0.47984099388123 / seconds
Query Executed:select * from geodata_geocity where city='Chocorua' limit 1DB:business_master_new
loadtime:0.48046588897705 / seconds
Query stored in cache : _QUERY_www.toadli.com50b3a0bf46dabcdd1f99bf28cba7639c
loadtime:0.48054003715515 / seconds
Query Executed:select id FROM `nh` where city='Chocorua' && SIC_code='1521'DB:business_master_new
loadtime:0.49736905097961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:0.49742794036865 / seconds
Query Executed:select id FROM `nh` where city='Claremont' && SIC_code='1521'DB:business_master_new
loadtime:0.50580286979675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksville' limit 1
loadtime:0.50591087341309 / seconds
Query Executed:select id FROM `nh` where city='Clarksville' && SIC_code='1521'DB:business_master_new
loadtime:0.50679993629456 / seconds
Query Executed:select * from geodata_geocity where city='Colebrook' limit 1DB:business_master_new
loadtime:0.50707697868347 / seconds
Query stored in cache : _QUERY_www.toadli.com48f61dbc5e4a35a1d026c0260bded065
loadtime:0.50711107254028 / seconds
Query Executed:select id FROM `nh` where city='Colebrook' && SIC_code='1521'DB:business_master_new
loadtime:0.51006603240967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.51012206077576 / seconds
Query Executed:select id FROM `nh` where city='Concord' && SIC_code='1521'DB:business_master_new
loadtime:0.5401349067688 / seconds
Query Executed:select * from geodata_geocity where city='Contoocook' limit 1DB:business_master_new
loadtime:0.5408239364624 / seconds
Query stored in cache : _QUERY_www.toadli.com48eb1f12a8c269df0d3007f4894153e2
loadtime:0.54090809822083 / seconds
Query Executed:select id FROM `nh` where city='Contoocook' && SIC_code='1521'DB:business_master_new
loadtime:0.54857492446899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.54869103431702 / seconds
Query Executed:select id FROM `nh` where city='Conway' && SIC_code='1521'DB:business_master_new
loadtime:0.55379796028137 / seconds
Query Executed:select * from geodata_geocity where city='Cornish' limit 1DB:business_master_new
loadtime:0.55408406257629 / seconds
Query stored in cache : _QUERY_www.toadli.comc1c28b2178e49e04ee93c31dea2c40ef
loadtime:0.55411696434021 / seconds
Query Executed:select id FROM `nh` where city='Cornish' && SIC_code='1521'DB:business_master_new
loadtime:0.57182192802429 / seconds
Query Executed:select * from geodata_geocity where city='Cornish Flat' limit 1DB:business_master_new
loadtime:0.57209897041321 / seconds
Query stored in cache : _QUERY_www.toadli.com8c29161740a6ce1ce82a4be8a88132f2
loadtime:0.57214593887329 / seconds
Query Executed:select id FROM `nh` where city='Cornish Flat' && SIC_code='1521'DB:business_master_new
loadtime:0.57744598388672 / seconds
Query Executed:select * from geodata_geocity where city='Croydon' limit 1DB:business_master_new
loadtime:0.57771110534668 / seconds
Query stored in cache : _QUERY_www.toadli.com7307d9ab3193ee65bbcac7c94d9a60f9
loadtime:0.57775092124939 / seconds
Query Executed:select id FROM `nh` where city='Croydon' && SIC_code='1521'DB:business_master_new
loadtime:0.57842087745667 / seconds
Query Executed:select * from geodata_geocity where city='Ctr Tuftonboro' limit 1DB:business_master_new
loadtime:0.57867193222046 / seconds
Query stored in cache : _QUERY_www.toadli.comc64cfcc7b5d17a56df0d5076d73b8e84
loadtime:0.57871699333191 / seconds
Query Executed:select id FROM `nh` where city='Ctr Tuftonboro' && SIC_code='1521'DB:business_master_new
loadtime:0.57895493507385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dalton' limit 1
loadtime:0.57899403572083 / seconds
Query Executed:select id FROM `nh` where city='Dalton' && SIC_code='1521'DB:business_master_new
loadtime:0.5795259475708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:0.57957601547241 / seconds
Query Executed:select id FROM `nh` where city='Danbury' && SIC_code='1521'DB:business_master_new
loadtime:0.59877300262451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.59883403778076 / seconds
Query Executed:select id FROM `nh` where city='Danville' && SIC_code='1521'DB:business_master_new
loadtime:0.60440897941589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:0.60447406768799 / seconds
Query Executed:select id FROM `nh` where city='Deerfield' && SIC_code='1521'DB:business_master_new
loadtime:0.61152195930481 / seconds
Query Executed:select * from geodata_geocity where city='Deering' limit 1DB:business_master_new
loadtime:0.611820936203 / seconds
Query stored in cache : _QUERY_www.toadli.com06dfcf0498712ca18b5d20466c8de043
loadtime:0.61186504364014 / seconds
Query Executed:select id FROM `nh` where city='Deering' && SIC_code='1521'DB:business_master_new
loadtime:0.61363697052002 / seconds
Query Executed:select * from geodata_geocity where city='Derry' limit 1DB:business_master_new
loadtime:0.61393094062805 / seconds
Query stored in cache : _QUERY_www.toadli.combd16a021b6b20fcd52dd8b26f5bccd0e
loadtime:0.61396598815918 / seconds
Query Executed:select id FROM `nh` where city='Derry' && SIC_code='1521'DB:business_master_new
loadtime:0.64144897460938 / seconds
Query Executed:select * from geodata_geocity where city='Dorchester' limit 1DB:business_master_new
loadtime:0.6417670249939 / seconds
Query stored in cache : _QUERY_www.toadli.com73c1917e97fbd08ec73daf22f92141c1
loadtime:0.64181804656982 / seconds
Query Executed:select id FROM `nh` where city='Dorchester' && SIC_code='1521'DB:business_master_new
loadtime:0.64206600189209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dover' limit 1
loadtime:0.64210891723633 / seconds
Query Executed:select id FROM `nh` where city='Dover' && SIC_code='1521'DB:business_master_new
loadtime:0.6617329120636 / seconds
Query Executed:select * from geodata_geocity where city='Drewsville' limit 1DB:business_master_new
loadtime:0.66230487823486 / seconds
Query stored in cache : _QUERY_www.toadli.comb5f691aca7c4f07f8a0530ca594f38e9
loadtime:0.66236400604248 / seconds
Query Executed:select id FROM `nh` where city='Drewsville' && SIC_code='1521'DB:business_master_new
loadtime:0.66313600540161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dublin' limit 1
loadtime:0.66319894790649 / seconds
Query Executed:select id FROM `nh` where city='Dublin' && SIC_code='1521'DB:business_master_new
loadtime:0.6659939289093 / seconds
Query Executed:select * from geodata_geocity where city='Dummer' limit 1DB:business_master_new
loadtime:0.66659808158875 / seconds
Query stored in cache : _QUERY_www.toadli.com62805eafa10966e762a1e65d9071bb91
loadtime:0.66668510437012 / seconds
Query Executed:select id FROM `nh` where city='Dummer' && SIC_code='1521'DB:business_master_new
loadtime:0.66726493835449 / seconds
Query Executed:select * from geodata_geocity where city='Dunbarton' limit 1DB:business_master_new
loadtime:0.66786289215088 / seconds
Query stored in cache : _QUERY_www.toadli.com6fae6640b94c1aec77712902d75853df
loadtime:0.66792702674866 / seconds
Query Executed:select id FROM `nh` where city='Dunbarton' && SIC_code='1521'DB:business_master_new
loadtime:0.67141890525818 / seconds
Query Executed:select * from geodata_geocity where city='Durham' limit 1DB:business_master_new
loadtime:0.67171692848206 / seconds
Query stored in cache : _QUERY_www.toadli.com4f7d3edb25e3a9a90bf7ebbe4b6cc5eb
loadtime:0.67175698280334 / seconds
Query Executed:select id FROM `nh` where city='Durham' && SIC_code='1521'DB:business_master_new
loadtime:0.67992687225342 / seconds
Query Executed:select * from geodata_geocity where city='East Andover' limit 1DB:business_master_new
loadtime:0.68023490905762 / seconds
Query stored in cache : _QUERY_www.toadli.comb36cf6bad2a29963ffd1433bb4abfac1
loadtime:0.68026804924011 / seconds
Query Executed:select id FROM `nh` where city='East Andover' && SIC_code='1521'DB:business_master_new
loadtime:0.68363094329834 / seconds
Query Executed:select * from geodata_geocity where city='East Candia' limit 1DB:business_master_new
loadtime:0.68389010429382 / seconds
Query stored in cache : _QUERY_www.toadli.com57f30429e95d6f95a0defaf0edd1eaea
loadtime:0.68393492698669 / seconds
Query Executed:select id FROM `nh` where city='East Candia' && SIC_code='1521'DB:business_master_new
loadtime:0.68419003486633 / seconds
Query Executed:select * from geodata_geocity where city='East Derry' limit 1DB:business_master_new
loadtime:0.68443489074707 / seconds
Query stored in cache : _QUERY_www.toadli.com7a8d7f7fe0d1f78a86bf61efc4b37e4d
loadtime:0.68447089195251 / seconds
Query Executed:select id FROM `nh` where city='East Derry' && SIC_code='1521'DB:business_master_new
loadtime:0.69656896591187 / seconds
Query Executed:select * from geodata_geocity where city='East Hampstead' limit 1DB:business_master_new
loadtime:0.69684290885925 / seconds
Query stored in cache : _QUERY_www.toadli.com759fb982ead6b7da223385a07b4da611
loadtime:0.69688105583191 / seconds
Query Executed:select id FROM `nh` where city='East Hampstead' && SIC_code='1521'DB:business_master_new
loadtime:0.69922709465027 / seconds
Query Executed:select * from geodata_geocity where city='East Hebron' limit 1DB:business_master_new
loadtime:0.69983887672424 / seconds
Query stored in cache : _QUERY_www.toadli.com185c17d255bc900cb1e0118c6967dade
loadtime:0.6999180316925 / seconds
Query Executed:select id FROM `nh` where city='East Hebron' && SIC_code='1521'DB:business_master_new
loadtime:0.70060205459595 / seconds
Query Executed:select * from geodata_geocity where city='East Kingston' limit 1DB:business_master_new
loadtime:0.70086288452148 / seconds
Query stored in cache : _QUERY_www.toadli.com88f1ff394bd914ef91308d1efceecdf5
loadtime:0.70089793205261 / seconds
Query Executed:select id FROM `nh` where city='East Kingston' && SIC_code='1521'DB:business_master_new
loadtime:0.70430994033813 / seconds
Query Executed:select * from geodata_geocity where city='East Swanzey' limit 1DB:business_master_new
loadtime:0.70457887649536 / seconds
Query stored in cache : _QUERY_www.toadli.com4264d2a1889e62de49f6cd693380d3f4
loadtime:0.70463895797729 / seconds
Query Executed:select id FROM `nh` where city='East Swanzey' && SIC_code='1521'DB:business_master_new
loadtime:0.70524287223816 / seconds
Query Executed:select * from geodata_geocity where city='East Wakefield' limit 1DB:business_master_new
loadtime:0.70581698417664 / seconds
Query stored in cache : _QUERY_www.toadli.com3ea2e0567ee4850c28753831addd0bff
loadtime:0.70588207244873 / seconds
Query Executed:select id FROM `nh` where city='East Wakefield' && SIC_code='1521'DB:business_master_new
loadtime:0.71819496154785 / seconds
Query Executed:select * from geodata_geocity where city='Eaton Center' limit 1DB:business_master_new
loadtime:0.71848797798157 / seconds
Query stored in cache : _QUERY_www.toadli.com5dd8d2de25a260966ebcbfc694b9fd20
loadtime:0.71852803230286 / seconds
Query Executed:select id FROM `nh` where city='Eaton Center' && SIC_code='1521'DB:business_master_new
loadtime:0.72397708892822 / seconds
Query Executed:select * from geodata_geocity where city='Effingham' limit 1DB:business_master_new
loadtime:0.72428607940674 / seconds
Query stored in cache : _QUERY_www.toadli.coma5c93c934a212d021705596b0d5e344e
loadtime:0.72433304786682 / seconds
Query Executed:select id FROM `nh` where city='Effingham' && SIC_code='1521'DB:business_master_new
loadtime:0.73151707649231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkins' limit 1
loadtime:0.73156905174255 / seconds
Query Executed:select id FROM `nh` where city='Elkins' && SIC_code='1521'DB:business_master_new
loadtime:0.73638486862183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth' limit 1
loadtime:0.73644495010376 / seconds
Query Executed:select id FROM `nh` where city='Ellsworth' && SIC_code='1521'DB:business_master_new
loadtime:0.73668003082275 / seconds
Query Executed:select * from geodata_geocity where city='Enfield' limit 1DB:business_master_new
loadtime:0.73693609237671 / seconds
Query stored in cache : _QUERY_www.toadli.comf7b2c30814d60bb5ac7e5ffced40aa10
loadtime:0.73697400093079 / seconds
Query Executed:select id FROM `nh` where city='Enfield' && SIC_code='1521'DB:business_master_new
loadtime:0.73973989486694 / seconds
Query Executed:select * from geodata_geocity where city='Enfield Center' limit 1DB:business_master_new
loadtime:0.74001789093018 / seconds
Query stored in cache : _QUERY_www.toadli.com96f412a167388c1973fda3984b5f0e89
loadtime:0.74006199836731 / seconds
Query Executed:select id FROM `nh` where city='Enfield Center' && SIC_code='1521'DB:business_master_new
loadtime:0.74238395690918 / seconds
Query Executed:select * from geodata_geocity where city='Epping' limit 1DB:business_master_new
loadtime:0.7426860332489 / seconds
Query stored in cache : _QUERY_www.toadli.comd8c0678e165c4a7cfe554563437e1b53
loadtime:0.74271988868713 / seconds
Query Executed:select id FROM `nh` where city='Epping' && SIC_code='1521'DB:business_master_new
loadtime:0.74836802482605 / seconds
Query Executed:select * from geodata_geocity where city='Epsom' limit 1DB:business_master_new
loadtime:0.74865794181824 / seconds
Query stored in cache : _QUERY_www.toadli.coma6b49023d0bf74322bb37094157e2d5d
loadtime:0.74870204925537 / seconds
Query Executed:select id FROM `nh` where city='Epsom' && SIC_code='1521'DB:business_master_new
loadtime:0.75258302688599 / seconds
Query Executed:select * from geodata_geocity where city='Errol' limit 1DB:business_master_new
loadtime:0.75301194190979 / seconds
Query stored in cache : _QUERY_www.toadli.comb823d3178b33bad6ecc442b33e31d4e0
loadtime:0.75307297706604 / seconds
Query Executed:select id FROM `nh` where city='Errol' && SIC_code='1521'DB:business_master_new
loadtime:0.7671959400177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Etna' limit 1
loadtime:0.76725888252258 / seconds
Query Executed:select id FROM `nh` where city='Etna' && SIC_code='1521'DB:business_master_new
loadtime:0.78067088127136 / seconds
Query Executed:select * from geodata_geocity where city='Exeter' limit 1DB:business_master_new
loadtime:0.78095102310181 / seconds
Query stored in cache : _QUERY_www.toadli.comb16696c8366a793227cddf6b4c63d96d
loadtime:0.78099393844604 / seconds
Query Executed:select id FROM `nh` where city='Exeter' && SIC_code='1521'DB:business_master_new
loadtime:0.7909779548645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.79105687141418 / seconds
Query Executed:select id FROM `nh` where city='Farmington' && SIC_code='1521'DB:business_master_new
loadtime:0.79476809501648 / seconds
Query Executed:select * from geodata_geocity where city='Fitzwilliam' limit 1DB:business_master_new
loadtime:0.79503607749939 / seconds
Query stored in cache : _QUERY_www.toadli.com5c38be8bfc3c4a63efb58e78da865917
loadtime:0.79507994651794 / seconds
Query Executed:select id FROM `nh` where city='Fitzwilliam' && SIC_code='1521'DB:business_master_new
loadtime:0.79797387123108 / seconds
Query Executed:select * from geodata_geocity where city='Francestown' limit 1DB:business_master_new
loadtime:0.79825806617737 / seconds
Query stored in cache : _QUERY_www.toadli.com07d3747b65ae66ebfcb38c200c21d1e2
loadtime:0.79830193519592 / seconds
Query Executed:select id FROM `nh` where city='Francestown' && SIC_code='1521'DB:business_master_new
loadtime:0.82106900215149 / seconds
Query Executed:select * from geodata_geocity where city='Franconia' limit 1DB:business_master_new
loadtime:0.82135105133057 / seconds
Query stored in cache : _QUERY_www.toadli.com3fbd35840fb1ea0183a6dda8565cb88c
loadtime:0.8214008808136 / seconds
Query Executed:select id FROM `nh` where city='Franconia' && SIC_code='1521'DB:business_master_new
loadtime:0.82424402236938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.82435202598572 / seconds
Query Executed:select id FROM `nh` where city='Franklin' && SIC_code='1521'DB:business_master_new
loadtime:0.82773303985596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freedom' limit 1
loadtime:0.82779908180237 / seconds
Query Executed:select id FROM `nh` where city='Freedom' && SIC_code='1521'DB:business_master_new
loadtime:0.84898591041565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fremont' limit 1
loadtime:0.84904909133911 / seconds
Query Executed:select id FROM `nh` where city='Fremont' && SIC_code='1521'DB:business_master_new
loadtime:0.85170793533325 / seconds
Query Executed:select * from geodata_geocity where city='Georges Mills' limit 1DB:business_master_new
loadtime:0.85223889350891 / seconds
Query stored in cache : _QUERY_www.toadli.com95c5d9ba9de946277b6c2a08b3fcb9b7
loadtime:0.85230302810669 / seconds
Query Executed:select id FROM `nh` where city='Georges Mills' && SIC_code='1521'DB:business_master_new
loadtime:0.86237907409668 / seconds
Query Executed:select * from geodata_geocity where city='Gilford' limit 1DB:business_master_new
loadtime:0.8626708984375 / seconds
Query stored in cache : _QUERY_www.toadli.com4b7a7dc5c375875c1a2c4fd186255572
loadtime:0.86271500587463 / seconds
Query Executed:select id FROM `nh` where city='Gilford' && SIC_code='1521'DB:business_master_new
loadtime:0.86980605125427 / seconds
Query Executed:select * from geodata_geocity where city='Gilmanton' limit 1DB:business_master_new
loadtime:0.87022495269775 / seconds
Query stored in cache : _QUERY_www.toadli.comc250784fc07569c35daacc6155e3a416
loadtime:0.87028908729553 / seconds
Query Executed:select id FROM `nh` where city='Gilmanton' && SIC_code='1521'DB:business_master_new
loadtime:0.87240195274353 / seconds
Query Executed:select * from geodata_geocity where city='Gilmanton Iron Works' limit 1DB:business_master_new
loadtime:0.87269401550293 / seconds
Query stored in cache : _QUERY_www.toadli.com4a7318a994dc5ca04d294871b5865ece
loadtime:0.87273907661438 / seconds
Query Executed:select id FROM `nh` where city='Gilmanton Iron Works' && SIC_code='1521'DB:business_master_new
loadtime:0.88401103019714 / seconds
Query Executed:select * from geodata_geocity where city='Gilsum' limit 1DB:business_master_new
loadtime:0.88431692123413 / seconds
Query stored in cache : _QUERY_www.toadli.comaf943b10d8e3d35e13ff24f1f41368d7
loadtime:0.8843560218811 / seconds
Query Executed:select id FROM `nh` where city='Gilsum' && SIC_code='1521'DB:business_master_new
loadtime:0.89251303672791 / seconds
Query Executed:select * from geodata_geocity where city='Glen' limit 1DB:business_master_new
loadtime:0.89279198646545 / seconds
Query stored in cache : _QUERY_www.toadli.comfffdec27eabdd84be6ae44b2a04c908c
loadtime:0.89283204078674 / seconds
Query Executed:select id FROM `nh` where city='Glen' && SIC_code='1521'DB:business_master_new
loadtime:0.89522409439087 / seconds
Query Executed:select * from geodata_geocity where city='Glencliff' limit 1DB:business_master_new
loadtime:0.89578604698181 / seconds
Query stored in cache : _QUERY_www.toadli.comf41122dfe04e985574d956757557e2b0
loadtime:0.89584994316101 / seconds
Query Executed:select id FROM `nh` where city='Glencliff' && SIC_code='1521'DB:business_master_new
loadtime:0.8972179889679 / seconds
Query Executed:select * from geodata_geocity where city='Glmntn Iron Wks' limit 1DB:business_master_new
loadtime:0.89751195907593 / seconds
Query stored in cache : _QUERY_www.toadli.com9b3b98af661247c5890b04f8fe7e7323
loadtime:0.89755487442017 / seconds
Query Executed:select id FROM `nh` where city='Glmntn Iron Wks' && SIC_code='1521'DB:business_master_new
loadtime:0.8985378742218 / seconds
Query Executed:select * from geodata_geocity where city='Goffstown' limit 1DB:business_master_new
loadtime:0.8987979888916 / seconds
Query stored in cache : _QUERY_www.toadli.com26e3bc17838bb389746518684cd8e5c5
loadtime:0.89883899688721 / seconds
Query Executed:select id FROM `nh` where city='Goffstown' && SIC_code='1521'DB:business_master_new
loadtime:0.90800309181213 / seconds
Query Executed:select * from geodata_geocity where city='Gorham' limit 1DB:business_master_new
loadtime:0.9084210395813 / seconds
Query stored in cache : _QUERY_www.toadli.combf9b7f308c3d5ba0d08d3f595c0f489e
loadtime:0.90845894813538 / seconds
Query Executed:select id FROM `nh` where city='Gorham' && SIC_code='1521'DB:business_master_new
loadtime:0.91290903091431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.91301894187927 / seconds
Query Executed:select id FROM `nh` where city='Goshen' && SIC_code='1521'DB:business_master_new
loadtime:0.92155599594116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.92159795761108 / seconds
Query Executed:select id FROM `nh` where city='Grafton' && SIC_code='1521'DB:business_master_new
loadtime:0.98009610176086 / seconds
Query Executed:select * from geodata_geocity where city='Grantham' limit 1DB:business_master_new
loadtime:0.98040390014648 / seconds
Query stored in cache : _QUERY_www.toadli.com802c38936f192a02dfdce5a89d62efdc
loadtime:0.98044800758362 / seconds
Query Executed:select id FROM `nh` where city='Grantham' && SIC_code='1521'DB:business_master_new
loadtime:0.98522305488586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenfield' limit 1
loadtime:0.98532700538635 / seconds
Query Executed:select id FROM `nh` where city='Greenfield' && SIC_code='1521'DB:business_master_new
loadtime:0.98729300498962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenland' limit 1
loadtime:0.98735189437866 / seconds
Query Executed:select id FROM `nh` where city='Greenland' && SIC_code='1521'DB:business_master_new
loadtime:0.9926929473877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.99275708198547 / seconds
Query Executed:select id FROM `nh` where city='Greenville' && SIC_code='1521'DB:business_master_new
loadtime:0.9953498840332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groveton' limit 1
loadtime:0.99541187286377 / seconds
Query Executed:select id FROM `nh` where city='Groveton' && SIC_code='1521'DB:business_master_new
loadtime:0.99798202514648 / seconds
Query Executed:select * from geodata_geocity where city='Guild' limit 1DB:business_master_new
loadtime:0.99828290939331 / seconds
Query stored in cache : _QUERY_www.toadli.com4daa04dcb1bdd0ae0dd755ee57f690f6
loadtime:0.99831604957581 / seconds
Query Executed:select id FROM `nh` where city='Guild' && SIC_code='1521'DB:business_master_new
loadtime:1.001072883606 / seconds
Query Executed:select * from geodata_geocity where city='Hales Location' limit 1DB:business_master_new
loadtime:1.0013580322266 / seconds
Query stored in cache : _QUERY_www.toadli.combcd174d14b78e20ab8bf81c4a0fe6a93
loadtime:1.0014019012451 / seconds
Query Executed:select id FROM `nh` where city='Hales Location' && SIC_code='1521'DB:business_master_new
loadtime:1.0016338825226 / seconds
Query Executed:select * from geodata_geocity where city='Hampstead' limit 1DB:business_master_new
loadtime:1.0019180774689 / seconds
Query stored in cache : _QUERY_www.toadli.com5aa38d2c6cc3955395e5c0216820ba32
loadtime:1.0019469261169 / seconds
Query Executed:select id FROM `nh` where city='Hampstead' && SIC_code='1521'DB:business_master_new
loadtime:1.006579875946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:1.0066468715668 / seconds
Query Executed:select id FROM `nh` where city='Hampton' && SIC_code='1521'DB:business_master_new
loadtime:1.0118339061737 / seconds
Query Executed:select * from geodata_geocity where city='Hampton Falls' limit 1DB:business_master_new
loadtime:1.0121269226074 / seconds
Query stored in cache : _QUERY_www.toadli.com5bbdf42d4e9b9762017065800062fbc5
loadtime:1.0121710300446 / seconds
Query Executed:select id FROM `nh` where city='Hampton Falls' && SIC_code='1521'DB:business_master_new
loadtime:1.0141398906708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:1.0142168998718 / seconds
Query Executed:select id FROM `nh` where city='Hancock' && SIC_code='1521'DB:business_master_new
loadtime:1.015508890152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:1.0155708789825 / seconds
Query Executed:select id FROM `nh` where city='Hanover' && SIC_code='1521'DB:business_master_new
loadtime:1.018758058548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisville' limit 1
loadtime:1.0188219547272 / seconds
Query Executed:select id FROM `nh` where city='Harrisville' && SIC_code='1521'DB:business_master_new
loadtime:1.0318210124969 / seconds
Query Executed:select * from geodata_geocity where city='Harts Location' limit 1DB:business_master_new
loadtime:1.0321190357208 / seconds
Query stored in cache : _QUERY_www.toadli.coma1eb64286ff217942267ecdb63297ca5
loadtime:1.0321528911591 / seconds
Query Executed:select id FROM `nh` where city='Harts Location' && SIC_code='1521'DB:business_master_new
loadtime:1.0324060916901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haverhill' limit 1
loadtime:1.0324530601501 / seconds
Query Executed:select id FROM `nh` where city='Haverhill' && SIC_code='1521'DB:business_master_new
loadtime:1.0405929088593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hebron' limit 1
loadtime:1.0406610965729 / seconds
Query Executed:select id FROM `nh` where city='Hebron' && SIC_code='1521'DB:business_master_new
loadtime:1.0476250648499 / seconds
Query Executed:select * from geodata_geocity where city='Henniker' limit 1DB:business_master_new
loadtime:1.0479068756104 / seconds
Query stored in cache : _QUERY_www.toadli.com3817a7ba6851c5f918ecefe5942cdfbc
loadtime:1.0479509830475 / seconds
Query Executed:select id FROM `nh` where city='Henniker' && SIC_code='1521'DB:business_master_new
loadtime:1.0502068996429 / seconds
Query Executed:select * from geodata_geocity where city='Hill' limit 1DB:business_master_new
loadtime:1.0504920482635 / seconds
Query stored in cache : _QUERY_www.toadli.comffa322598b26c13c67d10a9c05ac4274
loadtime:1.0505409240723 / seconds
Query Executed:select id FROM `nh` where city='Hill' && SIC_code='1521'DB:business_master_new
loadtime:1.0597770214081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:1.0598349571228 / seconds
Query Executed:select id FROM `nh` where city='Hillsboro' && SIC_code='1521'DB:business_master_new
loadtime:1.0701990127563 / seconds
Query Executed:select * from geodata_geocity where city='Hillsborough' limit 1DB:business_master_new
loadtime:1.0706329345703 / seconds
Query stored in cache : _QUERY_www.toadli.comded9f05418afa2d3842ba11600aa3d4f
loadtime:1.0706760883331 / seconds
Query Executed:select id FROM `nh` where city='Hillsborough' && SIC_code='1521'DB:business_master_new
loadtime:1.0750560760498 / seconds
Query Executed:select * from geodata_geocity where city='Hinsdale' limit 1DB:business_master_new
loadtime:1.0753479003906 / seconds
Query stored in cache : _QUERY_www.toadli.com778d97f08116dc7d1eddcdf7a9643fe0
loadtime:1.0753939151764 / seconds
Query Executed:select id FROM `nh` where city='Hinsdale' && SIC_code='1521'DB:business_master_new
loadtime:1.0763828754425 / seconds
Query Executed:select * from geodata_geocity where city='Holderness' limit 1DB:business_master_new
loadtime:1.0766630172729 / seconds
Query stored in cache : _QUERY_www.toadli.comc6cd820cf94afcc5ef9148acb9c4080c
loadtime:1.0766930580139 / seconds
Query Executed:select id FROM `nh` where city='Holderness' && SIC_code='1521'DB:business_master_new
loadtime:1.0779960155487 / seconds
Query Executed:select * from geodata_geocity where city='Hollis' limit 1DB:business_master_new
loadtime:1.078281879425 / seconds
Query stored in cache : _QUERY_www.toadli.com0ba7135ed53b2794759b42bdf9fbe221
loadtime:1.0783278942108 / seconds
Query Executed:select id FROM `nh` where city='Hollis' && SIC_code='1521'DB:business_master_new
loadtime:1.0834169387817 / seconds
Query Executed:select * from geodata_geocity where city='Hooksett' limit 1DB:business_master_new
loadtime:1.083694934845 / seconds
Query stored in cache : _QUERY_www.toadli.comd2ef7c22b1680acdd4ac9af4fe303a0a
loadtime:1.0837290287018 / seconds
Query Executed:select id FROM `nh` where city='Hooksett' && SIC_code='1521'DB:business_master_new
loadtime:1.0902349948883 / seconds
Query Executed:select * from geodata_geocity where city='Hopkinton' limit 1DB:business_master_new
loadtime:1.0907418727875 / seconds
Query stored in cache : _QUERY_www.toadli.coma9fde993691063e0eb582e6e2f42a3e6
loadtime:1.0907828807831 / seconds
Query Executed:select id FROM `nh` where city='Hopkinton' && SIC_code='1521'DB:business_master_new
loadtime:1.09237408638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:1.0924210548401 / seconds
Query Executed:select id FROM `nh` where city='Hudson' && SIC_code='1521'DB:business_master_new
loadtime:1.103355884552 / seconds
Query Executed:select * from geodata_geocity where city='Intervale' limit 1DB:business_master_new
loadtime:1.1037709712982 / seconds
Query stored in cache : _QUERY_www.toadli.com2b77b876ac74f9ef0d904682ae7aa1ad
loadtime:1.1038060188293 / seconds
Query Executed:select id FROM `nh` where city='Intervale' && SIC_code='1521'DB:business_master_new
loadtime:1.1219680309296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:1.122015953064 / seconds
Query Executed:select id FROM `nh` where city='Jackson' && SIC_code='1521'DB:business_master_new
loadtime:1.1239418983459 / seconds
Query Executed:select * from geodata_geocity where city='Jaffrey' limit 1DB:business_master_new
loadtime:1.1242120265961 / seconds
Query stored in cache : _QUERY_www.toadli.com2303d219533fd1fe2d6185fbfc702fc8
loadtime:1.124253988266 / seconds
Query Executed:select id FROM `nh` where city='Jaffrey' && SIC_code='1521'DB:business_master_new
loadtime:1.1283140182495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:1.1283700466156 / seconds
Query Executed:select id FROM `nh` where city='Jefferson' && SIC_code='1521'DB:business_master_new
loadtime:1.1390988826752 / seconds
Query Executed:select * from geodata_geocity where city='Kearsarge' limit 1DB:business_master_new
loadtime:1.1394000053406 / seconds
Query stored in cache : _QUERY_www.toadli.comb14fcb040a5a0a417706c25300953978
loadtime:1.1394460201263 / seconds
Query Executed:select id FROM `nh` where city='Kearsarge' && SIC_code='1521'DB:business_master_new
loadtime:1.1413269042969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keene' limit 1
loadtime:1.1413650512695 / seconds
Query Executed:select id FROM `nh` where city='Keene' && SIC_code='1521'DB:business_master_new
loadtime:1.1485159397125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kensington' limit 1
loadtime:1.1485779285431 / seconds
Query Executed:select id FROM `nh` where city='Kensington' && SIC_code='1521'DB:business_master_new
loadtime:1.1488440036774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:1.1488809585571 / seconds
Query Executed:select id FROM `nh` where city='Kingston' && SIC_code='1521'DB:business_master_new
loadtime:1.1516098976135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laconia' limit 1
loadtime:1.1516599655151 / seconds
Query Executed:select id FROM `nh` where city='Laconia' && SIC_code='1521'DB:business_master_new
loadtime:1.1624369621277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:1.1625320911407 / seconds
Query Executed:select id FROM `nh` where city='Lancaster' && SIC_code='1521'DB:business_master_new
loadtime:1.1644420623779 / seconds
Query Executed:select * from geodata_geocity where city='Landaff' limit 1DB:business_master_new
loadtime:1.1647660732269 / seconds
Query stored in cache : _QUERY_www.toadli.com0e96dd6c410641b16b0a094614e0536b
loadtime:1.1648030281067 / seconds
Query Executed:select id FROM `nh` where city='Landaff' && SIC_code='1521'DB:business_master_new
loadtime:1.1653258800507 / seconds
Query Executed:select * from geodata_geocity where city='Langdon' limit 1DB:business_master_new
loadtime:1.1656119823456 / seconds
Query stored in cache : _QUERY_www.toadli.combd0e5b89eb0931a23ed641962ba3dbf1
loadtime:1.1656489372253 / seconds
Query Executed:select id FROM `nh` where city='Langdon' && SIC_code='1521'DB:business_master_new
loadtime:1.166650056839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:1.1666929721832 / seconds
Query Executed:select id FROM `nh` where city='Lebanon' && SIC_code='1521'DB:business_master_new
loadtime:1.1700210571289 / seconds
Query Executed:select * from geodata_geocity where city='Lee' limit 1DB:business_master_new
loadtime:1.1703169345856 / seconds
Query stored in cache : _QUERY_www.toadli.com169a6447be0729ebd06e0e1701b0764e
loadtime:1.1703500747681 / seconds
Query Executed:select id FROM `nh` where city='Lee' && SIC_code='1521'DB:business_master_new
loadtime:1.171863079071 / seconds
Query Executed:select * from geodata_geocity where city='Lempster' limit 1DB:business_master_new
loadtime:1.1721298694611 / seconds
Query stored in cache : _QUERY_www.toadli.com053ee0781f2c3e05c81396098e62b0dd
loadtime:1.1721739768982 / seconds
Query Executed:select id FROM `nh` where city='Lempster' && SIC_code='1521'DB:business_master_new
loadtime:1.1816389560699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:1.1817960739136 / seconds
Query Executed:select id FROM `nh` where city='Lincoln' && SIC_code='1521'DB:business_master_new
loadtime:1.1833260059357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lisbon' limit 1
loadtime:1.1833739280701 / seconds
Query Executed:select id FROM `nh` where city='Lisbon' && SIC_code='1521'DB:business_master_new
loadtime:1.1849660873413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield' limit 1
loadtime:1.1849999427795 / seconds
Query Executed:select id FROM `nh` where city='Litchfield' && SIC_code='1521'DB:business_master_new
loadtime:1.1873760223389 / seconds
Query Executed:select * from geodata_geocity where city='Littleton' limit 1DB:business_master_new
loadtime:1.1876850128174 / seconds
Query stored in cache : _QUERY_www.toadli.com6aaac688ed833a11a8f5780ec1bea54a
loadtime:1.1877219676971 / seconds
Query Executed:select id FROM `nh` where city='Littleton' && SIC_code='1521'DB:business_master_new
loadtime:1.190083026886 / seconds
Query Executed:select * from geodata_geocity where city='Lochmere' limit 1DB:business_master_new
loadtime:1.1903870105743 / seconds
Query stored in cache : _QUERY_www.toadli.com8800f595e4cae0fbd285952088a8b2f2
loadtime:1.1904330253601 / seconds
Query Executed:select id FROM `nh` where city='Lochmere' && SIC_code='1521'DB:business_master_new
loadtime:1.1937379837036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Londonderry' limit 1
loadtime:1.1938059329987 / seconds
Query Executed:select id FROM `nh` where city='Londonderry' && SIC_code='1521'DB:business_master_new
loadtime:1.2045040130615 / seconds
Query Executed:select * from geodata_geocity where city='Loudon' limit 1DB:business_master_new
loadtime:1.2048399448395 / seconds
Query stored in cache : _QUERY_www.toadli.com7e67d31eafc348d9373127d9f7235d8a
loadtime:1.2048819065094 / seconds
Query Executed:select id FROM `nh` where city='Loudon' && SIC_code='1521'DB:business_master_new
loadtime:1.2076389789581 / seconds
Query Executed:select * from geodata_geocity where city='Lyman' limit 1DB:business_master_new
loadtime:1.2079339027405 / seconds
Query stored in cache : _QUERY_www.toadli.coma4318706764a99c15f823072656cf134
loadtime:1.2079689502716 / seconds
Query Executed:select id FROM `nh` where city='Lyman' && SIC_code='1521'DB:business_master_new
loadtime:1.2082109451294 / seconds
Query Executed:select * from geodata_geocity where city='Lyme' limit 1DB:business_master_new
loadtime:1.2084670066833 / seconds
Query stored in cache : _QUERY_www.toadli.coma6f6ae6c7fed5ff991f4ad1a3f5a8c13
loadtime:1.2085070610046 / seconds
Query Executed:select id FROM `nh` where city='Lyme' && SIC_code='1521'DB:business_master_new
loadtime:1.2097718715668 / seconds
Query Executed:select * from geodata_geocity where city='Lyme Center' limit 1DB:business_master_new
loadtime:1.2100410461426 / seconds
Query stored in cache : _QUERY_www.toadli.com1f7863d376fe68aebee6c3dc4d0d702f
loadtime:1.2100698947906 / seconds
Query Executed:select id FROM `nh` where city='Lyme Center' && SIC_code='1521'DB:business_master_new
loadtime:1.2107520103455 / seconds
Query Executed:select * from geodata_geocity where city='Lyndeborough' limit 1DB:business_master_new
loadtime:1.2109930515289 / seconds
Query stored in cache : _QUERY_www.toadli.comcf444f6323442ce87416f0803e0d39bc
loadtime:1.2110300064087 / seconds
Query Executed:select id FROM `nh` where city='Lyndeborough' && SIC_code='1521'DB:business_master_new
loadtime:1.2120099067688 / seconds
Query Executed:select * from geodata_geocity where city='Madbury' limit 1DB:business_master_new
loadtime:1.2122929096222 / seconds
Query stored in cache : _QUERY_www.toadli.comffe908ea666c1fcb2336331ef615229d
loadtime:1.2123210430145 / seconds
Query Executed:select id FROM `nh` where city='Madbury' && SIC_code='1521'DB:business_master_new
loadtime:1.2191128730774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:1.219162940979 / seconds
Query Executed:select id FROM `nh` where city='Madison' && SIC_code='1521'DB:business_master_new
loadtime:1.2289428710938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:1.2289910316467 / seconds
Query Executed:select id FROM `nh` where city='Manchester' && SIC_code='1521'DB:business_master_new
loadtime:1.2467770576477 / seconds
Query Executed:select * from geodata_geocity where city='Marlborough' limit 1DB:business_master_new
loadtime:1.2471630573273 / seconds
Query stored in cache : _QUERY_www.toadli.comcc75f75d854c3e68f32b1a40c223efa4
loadtime:1.2472229003906 / seconds
Query Executed:select id FROM `nh` where city='Marlborough' && SIC_code='1521'DB:business_master_new
loadtime:1.2482678890228 / seconds
Query Executed:select * from geodata_geocity where city='Marlow' limit 1DB:business_master_new
loadtime:1.2485358715057 / seconds
Query stored in cache : _QUERY_www.toadli.com5f1053582cf59c6e037f9665357bb3fb
loadtime:1.2485680580139 / seconds
Query Executed:select id FROM `nh` where city='Marlow' && SIC_code='1521'DB:business_master_new
loadtime:1.251631975174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mason' limit 1
loadtime:1.2516911029816 / seconds
Query Executed:select id FROM `nh` where city='Mason' && SIC_code='1521'DB:business_master_new
loadtime:1.2522509098053 / seconds
Query Executed:select * from geodata_geocity where city='Meadows' limit 1DB:business_master_new
loadtime:1.2525200843811 / seconds
Query stored in cache : _QUERY_www.toadli.com8d4c5ab47f8341dcd46df9967aaa1715
loadtime:1.2525589466095 / seconds
Query Executed:select id FROM `nh` where city='Meadows' && SIC_code='1521'DB:business_master_new
loadtime:1.2527940273285 / seconds
Query Executed:select * from geodata_geocity where city='Melvin Village' limit 1DB:business_master_new
loadtime:1.25306391716 / seconds
Query stored in cache : _QUERY_www.toadli.comde158bd4d36665136103d1a93cc5335f
loadtime:1.2530980110168 / seconds
Query Executed:select id FROM `nh` where city='Melvin Village' && SIC_code='1521'DB:business_master_new
loadtime:1.2583930492401 / seconds
Query Executed:select * from geodata_geocity where city='Meredith' limit 1DB:business_master_new
loadtime:1.2587010860443 / seconds
Query stored in cache : _QUERY_www.toadli.com387f69a9fbab35404939da71f0693fa1
loadtime:1.2587380409241 / seconds
Query Executed:select id FROM `nh` where city='Meredith' && SIC_code='1521'DB:business_master_new
loadtime:1.2609739303589 / seconds
Query Executed:select * from geodata_geocity where city='Meriden' limit 1DB:business_master_new
loadtime:1.2612709999084 / seconds
Query stored in cache : _QUERY_www.toadli.comad6f85cfb976f5fdaa21e8b2b555063f
loadtime:1.2613139152527 / seconds
Query Executed:select id FROM `nh` where city='Meriden' && SIC_code='1521'DB:business_master_new
loadtime:1.2655560970306 / seconds
Query Executed:select * from geodata_geocity where city='Merrimack' limit 1DB:business_master_new
loadtime:1.2658340930939 / seconds
Query stored in cache : _QUERY_www.toadli.coma1b89b84e132ddbf8f26d3189a4d2c08
loadtime:1.2658669948578 / seconds
Query Executed:select id FROM `nh` where city='Merrimack' && SIC_code='1521'DB:business_master_new
loadtime:1.2695429325104 / seconds
Query Executed:select * from geodata_geocity where city='Middleton' limit 1DB:business_master_new
loadtime:1.2699410915375 / seconds
Query stored in cache : _QUERY_www.toadli.com24b6bfc3eb9fb37e588f9262c1822a7f
loadtime:1.2699990272522 / seconds
Query Executed:select id FROM `nh` where city='Middleton' && SIC_code='1521'DB:business_master_new
loadtime:1.2705690860748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milan' limit 1
loadtime:1.2706229686737 / seconds
Query Executed:select id FROM `nh` where city='Milan' && SIC_code='1521'DB:business_master_new
loadtime:1.2750179767609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:1.2750608921051 / seconds
Query Executed:select id FROM `nh` where city='Milford' && SIC_code='1521'DB:business_master_new
loadtime:1.2781610488892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:1.2783739566803 / seconds
Query Executed:select id FROM `nh` where city='Milton' && SIC_code='1521'DB:business_master_new
loadtime:1.2801959514618 / seconds
Query Executed:select * from geodata_geocity where city='Milton Mills' limit 1DB:business_master_new
loadtime:1.2805080413818 / seconds
Query stored in cache : _QUERY_www.toadli.com695c88a384cc2dd6a0e073af0b4159ed
loadtime:1.2805449962616 / seconds
Query Executed:select id FROM `nh` where city='Milton Mills' && SIC_code='1521'DB:business_master_new
loadtime:1.2818670272827 / seconds
Query Executed:select * from geodata_geocity where city='Mirror Lake' limit 1DB:business_master_new
loadtime:1.2821729183197 / seconds
Query stored in cache : _QUERY_www.toadli.comb5741b7b8dc9dac2a5a5fe4dd8d0e301
loadtime:1.2822279930115 / seconds
Query Executed:select id FROM `nh` where city='Mirror Lake' && SIC_code='1521'DB:business_master_new
loadtime:1.2857959270477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:1.2858469486237 / seconds
Query Executed:select id FROM `nh` where city='Monroe' && SIC_code='1521'DB:business_master_new
loadtime:1.2890799045563 / seconds
Query Executed:select * from geodata_geocity where city='Mont Vernon' limit 1DB:business_master_new
loadtime:1.2894361019135 / seconds
Query stored in cache : _QUERY_www.toadli.comf256e4b1012443f27eacca4eb7041e08
loadtime:1.289470911026 / seconds
Query Executed:select id FROM `nh` where city='Mont Vernon' && SIC_code='1521'DB:business_master_new
loadtime:1.2976539134979 / seconds
Query Executed:select * from geodata_geocity where city='Moultonborough' limit 1DB:business_master_new
loadtime:1.2979559898376 / seconds
Query stored in cache : _QUERY_www.toadli.comac828464a15b9ea8c2a147c037b27cc4
loadtime:1.2979989051819 / seconds
Query Executed:select id FROM `nh` where city='Moultonborough' && SIC_code='1521'DB:business_master_new
loadtime:1.2993469238281 / seconds
Query Executed:select * from geodata_geocity where city='Mt Sunapee' limit 1DB:business_master_new
loadtime:1.2997438907623 / seconds
Query stored in cache : _QUERY_www.toadli.com19c831ad0f59f48cd4cd6c3d4597e91a
loadtime:1.2997798919678 / seconds
Query Executed:select id FROM `nh` where city='Mt Sunapee' && SIC_code='1521'DB:business_master_new
loadtime:1.300066947937 / seconds
Query Executed:select * from geodata_geocity where city='Munsonville' limit 1DB:business_master_new
loadtime:1.3003480434418 / seconds
Query stored in cache : _QUERY_www.toadli.com8f0253986579c6baa23a726ed94261c2
loadtime:1.3003768920898 / seconds
Query Executed:select id FROM `nh` where city='Munsonville' && SIC_code='1521'DB:business_master_new
loadtime:1.3011019229889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashua' limit 1
loadtime:1.3011379241943 / seconds
Query Executed:select id FROM `nh` where city='Nashua' && SIC_code='1521'DB:business_master_new
loadtime:1.311644077301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelson' limit 1
loadtime:1.3117730617523 / seconds
Query Executed:select id FROM `nh` where city='Nelson' && SIC_code='1521'DB:business_master_new
loadtime:1.3121719360352 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Boston' limit 1
loadtime:1.3122310638428 / seconds
Query Executed:select id FROM `nh` where city='New Boston' && SIC_code='1521'DB:business_master_new
loadtime:1.3138570785522 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Castle' limit 1
loadtime:1.313924074173 / seconds
Query Executed:select id FROM `nh` where city='New Castle' && SIC_code='1521'DB:business_master_new
loadtime:1.3154060840607 / seconds
Query Executed:select * from geodata_geocity where city='New Durham' limit 1DB:business_master_new
loadtime:1.3156859874725 / seconds
Query stored in cache : _QUERY_www.toadli.com98fc948bba4dfa8eaba5387972a038ae
loadtime:1.3157250881195 / seconds
Query Executed:select id FROM `nh` where city='New Durham' && SIC_code='1521'DB:business_master_new
loadtime:1.3167159557343 / seconds
Query Executed:select * from geodata_geocity where city='New Hampton' limit 1DB:business_master_new
loadtime:1.3169870376587 / seconds
Query stored in cache : _QUERY_www.toadli.com0265fc8969568b1f66c55a7ba12bb543
loadtime:1.3170199394226 / seconds
Query Executed:select id FROM `nh` where city='New Hampton' && SIC_code='1521'DB:business_master_new
loadtime:1.3180999755859 / seconds
Query Executed:select * from geodata_geocity where city='New Ipswich' limit 1DB:business_master_new
loadtime:1.3183920383453 / seconds
Query stored in cache : _QUERY_www.toadli.comcf155a6fdbe670588d78301a3a0de915
loadtime:1.3184359073639 / seconds
Query Executed:select id FROM `nh` where city='New Ipswich' && SIC_code='1521'DB:business_master_new
loadtime:1.3199648857117 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:1.3200290203094 / seconds
Query Executed:select id FROM `nh` where city='New London' && SIC_code='1521'DB:business_master_new
loadtime:1.3224110603333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbury' limit 1
loadtime:1.3224868774414 / seconds
Query Executed:select id FROM `nh` where city='Newbury' && SIC_code='1521'DB:business_master_new
loadtime:1.3235430717468 / seconds
Query Executed:select * from geodata_geocity where city='Newfields' limit 1DB:business_master_new
loadtime:1.3238179683685 / seconds
Query stored in cache : _QUERY_www.toadli.com6c1bec5da81cc5b5699e0dde73b99f74
loadtime:1.3238508701324 / seconds
Query Executed:select id FROM `nh` where city='Newfields' && SIC_code='1521'DB:business_master_new
loadtime:1.324835062027 / seconds
Query Executed:select * from geodata_geocity where city='Newington' limit 1DB:business_master_new
loadtime:1.3251030445099 / seconds
Query stored in cache : _QUERY_www.toadli.com7de35489ff8f7f1b073074cf0f78ac7e
loadtime:1.3251519203186 / seconds
Query Executed:select id FROM `nh` where city='Newington' && SIC_code='1521'DB:business_master_new
loadtime:1.3261170387268 / seconds
Query Executed:select * from geodata_geocity where city='Newmarket' limit 1DB:business_master_new
loadtime:1.3263990879059 / seconds
Query stored in cache : _QUERY_www.toadli.comb70c71b1fb20165e3fab14ce6a72e648
loadtime:1.3264389038086 / seconds
Query Executed:select id FROM `nh` where city='Newmarket' && SIC_code='1521'DB:business_master_new
loadtime:1.3276450634003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:1.3277080059052 / seconds
Query Executed:select id FROM `nh` where city='Newport' && SIC_code='1521'DB:business_master_new
loadtime:1.3289790153503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:1.3290469646454 / seconds
Query Executed:select id FROM `nh` where city='Newton' && SIC_code='1521'DB:business_master_new
loadtime:1.3301448822021 / seconds
Query Executed:select * from geodata_geocity where city='Newton Junction' limit 1DB:business_master_new
loadtime:1.3304500579834 / seconds
Query stored in cache : _QUERY_www.toadli.come61040a2585b5a39acee38a4c4110de8
loadtime:1.3305010795593 / seconds
Query Executed:select id FROM `nh` where city='Newton Junction' && SIC_code='1521'DB:business_master_new
loadtime:1.3308780193329 / seconds
Query Executed:select * from geodata_geocity where city='North Conway' limit 1DB:business_master_new
loadtime:1.3311569690704 / seconds
Query stored in cache : _QUERY_www.toadli.com7cf362cea5bf5937d78ae8432bed87c3
loadtime:1.3312149047852 / seconds
Query Executed:select id FROM `nh` where city='North Conway' && SIC_code='1521'DB:business_master_new
loadtime:1.3325901031494 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hampton' limit 1
loadtime:1.3326508998871 / seconds
Query Executed:select id FROM `nh` where city='North Hampton' && SIC_code='1521'DB:business_master_new
loadtime:1.3343839645386 / seconds
Query Executed:select * from geodata_geocity where city='North Haverhill' limit 1DB:business_master_new
loadtime:1.3346729278564 / seconds
Query stored in cache : _QUERY_www.toadli.com9ccc17314a7f4a13c180aba60ccedbcf
loadtime:1.3347060680389 / seconds
Query Executed:select id FROM `nh` where city='North Haverhill' && SIC_code='1521'DB:business_master_new
loadtime:1.3356950283051 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Salem' limit 1
loadtime:1.3357520103455 / seconds
Query Executed:select id FROM `nh` where city='North Salem' && SIC_code='1521'DB:business_master_new
loadtime:1.3366310596466 / seconds
Query Executed:select * from geodata_geocity where city='North Sandwich' limit 1DB:business_master_new
loadtime:1.3368818759918 / seconds
Query stored in cache : _QUERY_www.toadli.com2e9c3313be950b92325f6d95e75682e0
loadtime:1.3369250297546 / seconds
Query Executed:select id FROM `nh` where city='North Sandwich' && SIC_code='1521'DB:business_master_new
loadtime:1.3374559879303 / seconds
Query Executed:select * from geodata_geocity where city='North Stratford' limit 1DB:business_master_new
loadtime:1.3377320766449 / seconds
Query stored in cache : _QUERY_www.toadli.com166042a80ec5c0d89d97194e0eb7af70
loadtime:1.3377709388733 / seconds
Query Executed:select id FROM `nh` where city='North Stratford' && SIC_code='1521'DB:business_master_new
loadtime:1.3407919406891 / seconds
Query Executed:select * from geodata_geocity where city='North Sutton' limit 1DB:business_master_new
loadtime:1.3410439491272 / seconds
Query stored in cache : _QUERY_www.toadli.com7b33027a62f25dcbe13e8c5cd1ffc0fc
loadtime:1.341089963913 / seconds
Query Executed:select id FROM `nh` where city='North Sutton' && SIC_code='1521'DB:business_master_new
loadtime:1.3424580097198 / seconds
Query Executed:select * from geodata_geocity where city='North Walpole' limit 1DB:business_master_new
loadtime:1.3427250385284 / seconds
Query stored in cache : _QUERY_www.toadli.comdea9ef855cfb5c10e6c9de326410cd6e
loadtime:1.3427650928497 / seconds
Query Executed:select id FROM `nh` where city='North Walpole' && SIC_code='1521'DB:business_master_new
loadtime:1.3435690402985 / seconds
Query Executed:select * from geodata_geocity where city='North Woodstock' limit 1DB:business_master_new
loadtime:1.3438310623169 / seconds
Query stored in cache : _QUERY_www.toadli.combe33c85e1efa5c57e823583de50296fc
loadtime:1.3438708782196 / seconds
Query Executed:select id FROM `nh` where city='North Woodstock' && SIC_code='1521'DB:business_master_new
loadtime:1.344878911972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:1.3449380397797 / seconds
Query Executed:select id FROM `nh` where city='Northfield' && SIC_code='1521'DB:business_master_new
loadtime:1.3452439308167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northwood' limit 1
loadtime:1.345272064209 / seconds
Query Executed:select id FROM `nh` where city='Northwood' && SIC_code='1521'DB:business_master_new
loadtime:1.3463780879974 / seconds
Query Executed:select * from geodata_geocity where city='Nottingham' limit 1DB:business_master_new
loadtime:1.3466579914093 / seconds
Query stored in cache : _QUERY_www.toadli.com79e35aecd797249cf9f2b9e0387bccc6
loadtime:1.3467020988464 / seconds
Query Executed:select id FROM `nh` where city='Nottingham' && SIC_code='1521'DB:business_master_new
loadtime:1.3477869033813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:1.3478519916534 / seconds
Query Executed:select id FROM `nh` where city='Orange' && SIC_code='1521'DB:business_master_new
loadtime:1.3480970859528 / seconds
Query Executed:select * from geodata_geocity where city='Orford' limit 1DB:business_master_new
loadtime:1.3483600616455 / seconds
Query stored in cache : _QUERY_www.toadli.coma4e135c1aec999045a8a58c57e3ceb14
loadtime:1.3483910560608 / seconds
Query Executed:select id FROM `nh` where city='Orford' && SIC_code='1521'DB:business_master_new
loadtime:1.3495750427246 / seconds
Query Executed:select * from geodata_geocity where city='Ossipee' limit 1DB:business_master_new
loadtime:1.3499760627747 / seconds
Query stored in cache : _QUERY_www.toadli.comd1973fcdbfea8b4c6cb7418e4ada0600
loadtime:1.3500180244446 / seconds
Query Executed:select id FROM `nh` where city='Ossipee' && SIC_code='1521'DB:business_master_new
loadtime:1.3516240119934 / seconds
Query Executed:select * from geodata_geocity where city='Pelham' limit 1DB:business_master_new
loadtime:1.3518950939178 / seconds
Query stored in cache : _QUERY_www.toadli.com072fabc85752fb9a4a4ba7aad4a90105
loadtime:1.3519260883331 / seconds
Query Executed:select id FROM `nh` where city='Pelham' && SIC_code='1521'DB:business_master_new
loadtime:1.3537409305573 / seconds
Query Executed:select * from geodata_geocity where city='Pembroke' limit 1DB:business_master_new
loadtime:1.3540439605713 / seconds
Query stored in cache : _QUERY_www.toadli.com5b378735240772a3ca19aa816c206f1b
loadtime:1.3540849685669 / seconds
Query Executed:select id FROM `nh` where city='Pembroke' && SIC_code='1521'DB:business_master_new
loadtime:1.3544640541077 / seconds
Query Executed:select * from geodata_geocity where city='Penacook' limit 1DB:business_master_new
loadtime:1.3547570705414 / seconds
Query stored in cache : _QUERY_www.toadli.com5bccfd513cebb7b7ebf0b151acff6cef
loadtime:1.3547949790955 / seconds
Query Executed:select id FROM `nh` where city='Penacook' && SIC_code='1521'DB:business_master_new
loadtime:1.3550810813904 / seconds
Query Executed:select * from geodata_geocity where city='Peterborough' limit 1DB:business_master_new
loadtime:1.3553700447083 / seconds
Query stored in cache : _QUERY_www.toadli.com051d971f08c995949e24011c88696884
loadtime:1.3554100990295 / seconds
Query Executed:select id FROM `nh` where city='Peterborough' && SIC_code='1521'DB:business_master_new
loadtime:1.3567910194397 / seconds
Query Executed:select * from geodata_geocity where city='Piermont' limit 1DB:business_master_new
loadtime:1.3570530414581 / seconds
Query stored in cache : _QUERY_www.toadli.com58302a137812449657d0ce5a1b4c52a0
loadtime:1.3570840358734 / seconds
Query Executed:select id FROM `nh` where city='Piermont' && SIC_code='1521'DB:business_master_new
loadtime:1.3577148914337 / seconds
Query Executed:select * from geodata_geocity where city='Pike' limit 1DB:business_master_new
loadtime:1.3580000400543 / seconds
Query stored in cache : _QUERY_www.toadli.com19f08a785a1c901bc36f2c17e7d32456
loadtime:1.3580429553986 / seconds
Query Executed:select id FROM `nh` where city='Pike' && SIC_code='1521'DB:business_master_new
loadtime:1.3584940433502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsburg' limit 1
loadtime:1.3585460186005 / seconds
Query Executed:select id FROM `nh` where city='Pittsburg' && SIC_code='1521'DB:business_master_new
loadtime:1.3595609664917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsfield' limit 1
loadtime:1.3596160411835 / seconds
Query Executed:select id FROM `nh` where city='Pittsfield' && SIC_code='1521'DB:business_master_new
loadtime:1.3607668876648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:1.3608288764954 / seconds
Query Executed:select id FROM `nh` where city='Plainfield' && SIC_code='1521'DB:business_master_new
loadtime:1.3621370792389 / seconds
Query Executed:select * from geodata_geocity where city='Plaistow' limit 1DB:business_master_new
loadtime:1.3624320030212 / seconds
Query stored in cache : _QUERY_www.toadli.com684b8b15f8a95d1a3bf9457485f18c19
loadtime:1.3624830245972 / seconds
Query Executed:select id FROM `nh` where city='Plaistow' && SIC_code='1521'DB:business_master_new
loadtime:1.3640720844269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:1.3641390800476 / seconds
Query Executed:select id FROM `nh` where city='Plymouth' && SIC_code='1521'DB:business_master_new
loadtime:1.3654608726501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portsmouth' limit 1
loadtime:1.3655240535736 / seconds
Query Executed:select id FROM `nh` where city='Portsmouth' && SIC_code='1521'DB:business_master_new
loadtime:1.3692879676819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:1.3693680763245 / seconds
Query Executed:select id FROM `nh` where city='Randolph' && SIC_code='1521'DB:business_master_new
loadtime:1.3696908950806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:1.3697409629822 / seconds
Query Executed:select id FROM `nh` where city='Raymond' && SIC_code='1521'DB:business_master_new
loadtime:1.37167096138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:1.3717329502106 / seconds
Query Executed:select id FROM `nh` where city='Richmond' && SIC_code='1521'DB:business_master_new
loadtime:1.3720059394836 / seconds
Query Executed:select * from geodata_geocity where city='Rindge' limit 1DB:business_master_new
loadtime:1.3722870349884 / seconds
Query stored in cache : _QUERY_www.toadli.com6884a770217ce376b6515ce3c873e7e0
loadtime:1.3723180294037 / seconds
Query Executed:select id FROM `nh` where city='Rindge' && SIC_code='1521'DB:business_master_new
loadtime:1.3735599517822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:1.3736250400543 / seconds
Query Executed:select id FROM `nh` where city='Rochester' && SIC_code='1521'DB:business_master_new
loadtime:1.3759958744049 / seconds
Query Executed:select * from geodata_geocity where city='Rollinsford' limit 1DB:business_master_new
loadtime:1.3762938976288 / seconds
Query stored in cache : _QUERY_www.toadli.comb7e1383040c999c5a6540f74a3a2baa7
loadtime:1.3763380050659 / seconds
Query Executed:select id FROM `nh` where city='Rollinsford' && SIC_code='1521'DB:business_master_new
loadtime:1.3773810863495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:1.377445936203 / seconds
Query Executed:select id FROM `nh` where city='Roxbury' && SIC_code='1521'DB:business_master_new
loadtime:1.3776760101318 / seconds
Query Executed:select * from geodata_geocity where city='Rumney' limit 1DB:business_master_new
loadtime:1.3779358863831 / seconds
Query stored in cache : _QUERY_www.toadli.comb6f846e3f37b6431adf5e7cfcac81202
loadtime:1.3779680728912 / seconds
Query Executed:select id FROM `nh` where city='Rumney' && SIC_code='1521'DB:business_master_new
loadtime:1.3790190219879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rye' limit 1
loadtime:1.379077911377 / seconds
Query Executed:select id FROM `nh` where city='Rye' && SIC_code='1521'DB:business_master_new
loadtime:1.3806500434875 / seconds
Query Executed:select * from geodata_geocity where city='Rye Beach' limit 1DB:business_master_new
loadtime:1.3809370994568 / seconds
Query stored in cache : _QUERY_www.toadli.com9b025f7340b503261b480857b778e071
loadtime:1.3809809684753 / seconds
Query Executed:select id FROM `nh` where city='Rye Beach' && SIC_code='1521'DB:business_master_new
loadtime:1.3817160129547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:1.381767988205 / seconds
Query Executed:select id FROM `nh` where city='Salem' && SIC_code='1521'DB:business_master_new
loadtime:1.3842968940735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:1.3843879699707 / seconds
Query Executed:select id FROM `nh` where city='Salisbury' && SIC_code='1521'DB:business_master_new
loadtime:1.385617017746 / seconds
Query Executed:select * from geodata_geocity where city='Sanbornton' limit 1DB:business_master_new
loadtime:1.3859648704529 / seconds
Query stored in cache : _QUERY_www.toadli.comf892c8d8902b8477470c7c3dc3c4adc2
loadtime:1.3860020637512 / seconds
Query Executed:select id FROM `nh` where city='Sanbornton' && SIC_code='1521'DB:business_master_new
loadtime:1.3870770931244 / seconds
Query Executed:select * from geodata_geocity where city='Sanbornville' limit 1DB:business_master_new
loadtime:1.3873898983002 / seconds
Query stored in cache : _QUERY_www.toadli.com894e0926bbf17ed609cfbabb2a0e716c
loadtime:1.3874340057373 / seconds
Query Executed:select id FROM `nh` where city='Sanbornville' && SIC_code='1521'DB:business_master_new
loadtime:1.388571023941 / seconds
Query Executed:select * from geodata_geocity where city='Sandown' limit 1DB:business_master_new
loadtime:1.3888421058655 / seconds
Query stored in cache : _QUERY_www.toadli.com246fe894227f3a0834d92e8787f9d5de
loadtime:1.3888740539551 / seconds
Query Executed:select id FROM `nh` where city='Sandown' && SIC_code='1521'DB:business_master_new
loadtime:1.390429019928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seabrook' limit 1
loadtime:1.390506029129 / seconds
Query Executed:select id FROM `nh` where city='Seabrook' && SIC_code='1521'DB:business_master_new
loadtime:1.3922340869904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:1.3922939300537 / seconds
Query Executed:select id FROM `nh` where city='Sharon' && SIC_code='1521'DB:business_master_new
loadtime:1.392569065094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelburne' limit 1
loadtime:1.3926019668579 / seconds
Query Executed:select id FROM `nh` where city='Shelburne' && SIC_code='1521'DB:business_master_new
loadtime:1.3928670883179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Lake' limit 1
loadtime:1.3928918838501 / seconds
Query Executed:select id FROM `nh` where city='Silver Lake' && SIC_code='1521'DB:business_master_new
loadtime:1.3933398723602 / seconds
Query Executed:select * from geodata_geocity where city='Somersworth' limit 1DB:business_master_new
loadtime:1.3936049938202 / seconds
Query stored in cache : _QUERY_www.toadli.comca1516d43984e717a8c9159869c0c689
loadtime:1.3936440944672 / seconds
Query Executed:select id FROM `nh` where city='Somersworth' && SIC_code='1521'DB:business_master_new
loadtime:1.3950638771057 / seconds
Query Executed:select * from geodata_geocity where city='South Acworth' limit 1DB:business_master_new
loadtime:1.3953731060028 / seconds
Query stored in cache : _QUERY_www.toadli.comdd79336f1449c8d125800d41f01f2c04
loadtime:1.3954150676727 / seconds
Query Executed:select id FROM `nh` where city='South Acworth' && SIC_code='1521'DB:business_master_new
loadtime:1.3957939147949 / seconds
Query Executed:select * from geodata_geocity where city='South Effingham' limit 1DB:business_master_new
loadtime:1.3960609436035 / seconds
Query stored in cache : _QUERY_www.toadli.com4243bb5cc0963a234f6285cf7ce4f811
loadtime:1.3960928916931 / seconds
Query Executed:select id FROM `nh` where city='South Effingham' && SIC_code='1521'DB:business_master_new
loadtime:1.3963239192963 / seconds
Query Executed:select * from geodata_geocity where city='South Hampton' limit 1DB:business_master_new
loadtime:1.3965699672699 / seconds
Query stored in cache : _QUERY_www.toadli.comf3abe4c83ddf1e1994686cc691723ce1
loadtime:1.3966059684753 / seconds
Query Executed:select id FROM `nh` where city='South Hampton' && SIC_code='1521'DB:business_master_new
loadtime:1.396833896637 / seconds
Query Executed:select * from geodata_geocity where city='South Newbury' limit 1DB:business_master_new
loadtime:1.3970739841461 / seconds
Query stored in cache : _QUERY_www.toadli.com7b1df2d448e650c47fff67b228528ee8
loadtime:1.3971018791199 / seconds
Query Executed:select id FROM `nh` where city='South Newbury' && SIC_code='1521'DB:business_master_new
loadtime:1.3974030017853 / seconds
Query Executed:select * from geodata_geocity where city='South Sutton' limit 1DB:business_master_new
loadtime:1.3976490497589 / seconds
Query stored in cache : _QUERY_www.toadli.com0ed6e143c5f8a6d302d6b4e2cc76df25
loadtime:1.3976988792419 / seconds
Query Executed:select id FROM `nh` where city='South Sutton' && SIC_code='1521'DB:business_master_new
loadtime:1.3981320858002 / seconds
Query Executed:select * from geodata_geocity where city='South Tamworth' limit 1DB:business_master_new
loadtime:1.3983800411224 / seconds
Query stored in cache : _QUERY_www.toadli.com50d9b7c1e977853e1a6de8b4a0bf4714
loadtime:1.3984079360962 / seconds
Query Executed:select id FROM `nh` where city='South Tamworth' && SIC_code='1521'DB:business_master_new
loadtime:1.3988580703735 / seconds
Query Executed:select * from geodata_geocity where city='Spofford' limit 1DB:business_master_new
loadtime:1.3991229534149 / seconds
Query stored in cache : _QUERY_www.toadli.comff7880609bc4049b5e1f51ec30d2a30e
loadtime:1.3991680145264 / seconds
Query Executed:select id FROM `nh` where city='Spofford' && SIC_code='1521'DB:business_master_new
loadtime:1.4001500606537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:1.4002239704132 / seconds
Query Executed:select id FROM `nh` where city='Springfield' && SIC_code='1521'DB:business_master_new
loadtime:1.4012179374695 / seconds
Query Executed:select * from geodata_geocity where city='Stark' limit 1DB:business_master_new
loadtime:1.401524066925 / seconds
Query stored in cache : _QUERY_www.toadli.com211b13dbfb16d838ea39227bcaf26394
loadtime:1.4015579223633 / seconds
Query Executed:select id FROM `nh` where city='Stark' && SIC_code='1521'DB:business_master_new
loadtime:1.4017748832703 / seconds
Query Executed:select * from geodata_geocity where city='Stewartstown' limit 1DB:business_master_new
loadtime:1.4020249843597 / seconds
Query stored in cache : _QUERY_www.toadli.comc6eb85090c1178b5d60b81d77758e3f5
loadtime:1.4020619392395 / seconds
Query Executed:select id FROM `nh` where city='Stewartstown' && SIC_code='1521'DB:business_master_new
loadtime:1.402302980423 / seconds
Query Executed:select * from geodata_geocity where city='Stinson Lake' limit 1DB:business_master_new
loadtime:1.40256690979 / seconds
Query stored in cache : _QUERY_www.toadli.combe1440a2802782753234c21d4b843937
loadtime:1.4026010036469 / seconds
Query Executed:select id FROM `nh` where city='Stinson Lake' && SIC_code='1521'DB:business_master_new
loadtime:1.4028129577637 / seconds
Query Executed:select * from geodata_geocity where city='Stoddard' limit 1DB:business_master_new
loadtime:1.403048992157 / seconds
Query stored in cache : _QUERY_www.toadli.com073f84d16a55794751ad7feca98e361a
loadtime:1.4030759334564 / seconds
Query Executed:select id FROM `nh` where city='Stoddard' && SIC_code='1521'DB:business_master_new
loadtime:1.4036619663239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strafford' limit 1
loadtime:1.4037220478058 / seconds
Query Executed:select id FROM `nh` where city='Strafford' && SIC_code='1521'DB:business_master_new
loadtime:1.4047420024872 / seconds
Query Executed:select * from geodata_geocity where city='Stratham' limit 1DB:business_master_new
loadtime:1.4050190448761 / seconds
Query stored in cache : _QUERY_www.toadli.com4bb4bf638cdd4a354cccd59b85cf2fbd
loadtime:1.4050600528717 / seconds
Query Executed:select id FROM `nh` where city='Stratham' && SIC_code='1521'DB:business_master_new
loadtime:1.4064018726349 / seconds
Query Executed:select * from geodata_geocity where city='Sugar Hill' limit 1DB:business_master_new
loadtime:1.4066898822784 / seconds
Query stored in cache : _QUERY_www.toadli.come7016098288e2caf2ebe2584a40dea2a
loadtime:1.4067230224609 / seconds
Query Executed:select id FROM `nh` where city='Sugar Hill' && SIC_code='1521'DB:business_master_new
loadtime:1.4071629047394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sullivan' limit 1
loadtime:1.4072198867798 / seconds
Query Executed:select id FROM `nh` where city='Sullivan' && SIC_code='1521'DB:business_master_new
loadtime:1.4077348709106 / seconds
Query Executed:select * from geodata_geocity where city='Sunapee' limit 1DB:business_master_new
loadtime:1.4079940319061 / seconds
Query stored in cache : _QUERY_www.toadli.com207c4ea91bfad90d22d6672892b987b5
loadtime:1.4080340862274 / seconds
Query Executed:select id FROM `nh` where city='Sunapee' && SIC_code='1521'DB:business_master_new
loadtime:1.4091711044312 / seconds
Query Executed:select * from geodata_geocity where city='Suncook' limit 1DB:business_master_new
loadtime:1.4094479084015 / seconds
Query stored in cache : _QUERY_www.toadli.com7148de11aa35c8a3a40a63a67fe6bc59
loadtime:1.409481048584 / seconds
Query Executed:select id FROM `nh` where city='Suncook' && SIC_code='1521'DB:business_master_new
loadtime:1.4114210605621 / seconds
Query Executed:select * from geodata_geocity where city='Surry' limit 1DB:business_master_new
loadtime:1.4117140769958 / seconds
Query stored in cache : _QUERY_www.toadli.com03188616894832b2c6ba9e5f64be5fb6
loadtime:1.4117538928986 / seconds
Query Executed:select id FROM `nh` where city='Surry' && SIC_code='1521'DB:business_master_new
loadtime:1.4120109081268 / seconds
Query Executed:select * from geodata_geocity where city='Swanzey' limit 1DB:business_master_new
loadtime:1.4122769832611 / seconds
Query stored in cache : _QUERY_www.toadli.com1d0e44bb54c3db4830a1dca0a4a37b48
loadtime:1.4123170375824 / seconds
Query Executed:select id FROM `nh` where city='Swanzey' && SIC_code='1521'DB:business_master_new
loadtime:1.4134359359741 / seconds
Query Executed:select * from geodata_geocity where city='Tamworth' limit 1DB:business_master_new
loadtime:1.413731098175 / seconds
Query stored in cache : _QUERY_www.toadli.com87bc6166160fe454e18f987bb5078175
loadtime:1.4137749671936 / seconds
Query Executed:select id FROM `nh` where city='Tamworth' && SIC_code='1521'DB:business_master_new
loadtime:1.4148449897766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temple' limit 1
loadtime:1.4149038791656 / seconds
Query Executed:select id FROM `nh` where city='Temple' && SIC_code='1521'DB:business_master_new
loadtime:1.4158689975739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornton' limit 1
loadtime:1.4159300327301 / seconds
Query Executed:select id FROM `nh` where city='Thornton' && SIC_code='1521'DB:business_master_new
loadtime:1.4164929389954 / seconds
Query Executed:select * from geodata_geocity where city='Tilton' limit 1DB:business_master_new
loadtime:1.4167609214783 / seconds
Query stored in cache : _QUERY_www.toadli.com56757cf3633c6f94a1ebea6836b5c8d4
loadtime:1.4168040752411 / seconds
Query Executed:select id FROM `nh` where city='Tilton' && SIC_code='1521'DB:business_master_new
loadtime:1.4181458950043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:1.4182229042053 / seconds
Query Executed:select id FROM `nh` where city='Troy' && SIC_code='1521'DB:business_master_new
loadtime:1.419203042984 / seconds
Query Executed:select * from geodata_geocity where city='Twin Mountain' limit 1DB:business_master_new
loadtime:1.4194819927216 / seconds
Query stored in cache : _QUERY_www.toadli.comd53b2ea5d42bf82a41a53592f34ca613
loadtime:1.4195199012756 / seconds
Query Executed:select id FROM `nh` where city='Twin Mountain' && SIC_code='1521'DB:business_master_new
loadtime:1.4210031032562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:1.4210619926453 / seconds
Query Executed:select id FROM `nh` where city='Union' && SIC_code='1521'DB:business_master_new
loadtime:1.4224429130554 / seconds
Query Executed:select * from geodata_geocity where city='W Chesterfield' limit 1DB:business_master_new
loadtime:1.4227418899536 / seconds
Query stored in cache : _QUERY_www.toadli.comb2347d866d45bc3f1e8692714abe8bfb
loadtime:1.4227819442749 / seconds
Query Executed:select id FROM `nh` where city='W Chesterfield' && SIC_code='1521'DB:business_master_new
loadtime:1.4230818748474 / seconds
Query Executed:select * from geodata_geocity where city='W Peterborough' limit 1DB:business_master_new
loadtime:1.4233360290527 / seconds
Query stored in cache : _QUERY_www.toadli.com27c38f8aec0384f3fbcd981774d58095
loadtime:1.4233648777008 / seconds
Query Executed:select id FROM `nh` where city='W Peterborough' && SIC_code='1521'DB:business_master_new
loadtime:1.4235908985138 / seconds
Query Executed:select * from geodata_geocity where city='W Stewartstown' limit 1DB:business_master_new
loadtime:1.4238250255585 / seconds
Query stored in cache : _QUERY_www.toadli.comf4fb056d51fcb0eb0bdfa3bb88af6bc1
loadtime:1.4238638877869 / seconds
Query Executed:select id FROM `nh` where city='W Stewartstown' && SIC_code='1521'DB:business_master_new
loadtime:1.4243729114532 / seconds
Query Executed:select * from geodata_geocity where city='Walpole' limit 1DB:business_master_new
loadtime:1.4246339797974 / seconds
Query stored in cache : _QUERY_www.toadli.comdbe47b8b09b132f73abeed81904e2cf7
loadtime:1.4246718883514 / seconds
Query Executed:select id FROM `nh` where city='Walpole' && SIC_code='1521'DB:business_master_new
loadtime:1.4257080554962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warner' limit 1
loadtime:1.4257550239563 / seconds
Query Executed:select id FROM `nh` where city='Warner' && SIC_code='1521'DB:business_master_new
loadtime:1.4268770217896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:1.4269399642944 / seconds
Query Executed:select id FROM `nh` where city='Warren' && SIC_code='1521'DB:business_master_new
loadtime:1.4275848865509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:1.4276459217072 / seconds
Query Executed:select id FROM `nh` where city='Washington' && SIC_code='1521'DB:business_master_new
loadtime:1.4282970428467 / seconds
Query Executed:select * from geodata_geocity where city='Waterville Valley' limit 1DB:business_master_new
loadtime:1.4285938739777 / seconds
Query stored in cache : _QUERY_www.toadli.comcdcc7e1bdc82bc6e2a9730bb5a4d00f8
loadtime:1.428633928299 / seconds
Query Executed:select id FROM `nh` where city='Waterville Valley' && SIC_code='1521'DB:business_master_new
loadtime:1.4298419952393 / seconds
Query Executed:select * from geodata_geocity where city='Waterville Vly' limit 1DB:business_master_new
loadtime:1.4301099777222 / seconds
Query stored in cache : _QUERY_www.toadli.com8618c8f71ff45cc3f9645a7cde6784b0
loadtime:1.4301519393921 / seconds
Query Executed:select id FROM `nh` where city='Waterville Vly' && SIC_code='1521'DB:business_master_new
loadtime:1.4304139614105 / seconds
Query Executed:select * from geodata_geocity where city='Weare' limit 1DB:business_master_new
loadtime:1.4306619167328 / seconds
Query stored in cache : _QUERY_www.toadli.com0f829217299ff08603dcc922a4f309ee
loadtime:1.4306969642639 / seconds
Query Executed:select id FROM `nh` where city='Weare' && SIC_code='1521'DB:business_master_new
loadtime:1.4320158958435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:1.4320819377899 / seconds
Query Executed:select id FROM `nh` where city='Webster' && SIC_code='1521'DB:business_master_new
loadtime:1.4323689937592 / seconds
Query Executed:select * from geodata_geocity where city='Wentworth' limit 1DB:business_master_new
loadtime:1.4326338768005 / seconds
Query stored in cache : _QUERY_www.toadli.com7c249fdbd5b1321bd02b79361061c19b
loadtime:1.4326739311218 / seconds
Query Executed:select id FROM `nh` where city='Wentworth' && SIC_code='1521'DB:business_master_new
loadtime:1.4337840080261 / seconds
Query Executed:select * from geodata_geocity where city='Wentworths Loctn' limit 1DB:business_master_new
loadtime:1.4340620040894 / seconds
Query stored in cache : _QUERY_www.toadli.comf2c29e3cebd2010331e0361fac2738b3
loadtime:1.4340999126434 / seconds
Query Executed:select id FROM `nh` where city='Wentworths Loctn' && SIC_code='1521'DB:business_master_new
loadtime:1.4343369007111 / seconds
Query Executed:select * from geodata_geocity where city='West Chesterfield' limit 1DB:business_master_new
loadtime:1.4346060752869 / seconds
Query stored in cache : _QUERY_www.toadli.com27381c8f624b06008273ccf253deb22a
loadtime:1.4346420764923 / seconds
Query Executed:select id FROM `nh` where city='West Chesterfield' && SIC_code='1521'DB:business_master_new
loadtime:1.4357469081879 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Lebanon' limit 1
loadtime:1.4358060359955 / seconds
Query Executed:select id FROM `nh` where city='West Lebanon' && SIC_code='1521'DB:business_master_new
loadtime:1.4372088909149 / seconds
Query Executed:select * from geodata_geocity where city='West Nottingham' limit 1DB:business_master_new
loadtime:1.4374859333038 / seconds
Query stored in cache : _QUERY_www.toadli.comc6449d62edb48bee4116cedefc117cb5
loadtime:1.4375178813934 / seconds
Query Executed:select id FROM `nh` where city='West Nottingham' && SIC_code='1521'DB:business_master_new
loadtime:1.4378900527954 / seconds
Query Executed:select * from geodata_geocity where city='West Ossipee' limit 1DB:business_master_new
loadtime:1.4381558895111 / seconds
Query stored in cache : _QUERY_www.toadli.comf39ff5ba642b8befdd8a019e4dfb2a8e
loadtime:1.4382059574127 / seconds
Query Executed:select id FROM `nh` where city='West Ossipee' && SIC_code='1521'DB:business_master_new
loadtime:1.4390859603882 / seconds
Query Executed:select * from geodata_geocity where city='West Peterborough' limit 1DB:business_master_new
loadtime:1.4393820762634 / seconds
Query stored in cache : _QUERY_www.toadli.com4291919510e920428c1127d4075c7f48
loadtime:1.4394190311432 / seconds
Query Executed:select id FROM `nh` where city='West Peterborough' && SIC_code='1521'DB:business_master_new
loadtime:1.4397430419922 / seconds
Query Executed:select * from geodata_geocity where city='West Springfield' limit 1DB:business_master_new
loadtime:1.4400038719177 / seconds
Query stored in cache : _QUERY_www.toadli.com91e4d7d0c559f4a5133a852873c464b3
loadtime:1.4400389194489 / seconds
Query Executed:select id FROM `nh` where city='West Springfield' && SIC_code='1521'DB:business_master_new
loadtime:1.4403150081635 / seconds
Query Executed:select * from geodata_geocity where city='West Stewartstown' limit 1DB:business_master_new
loadtime:1.4406180381775 / seconds
Query stored in cache : _QUERY_www.toadli.com29ec2c9740af93e2150d83e56e8b5f80
loadtime:1.4406540393829 / seconds
Query Executed:select id FROM `nh` where city='West Stewartstown' && SIC_code='1521'DB:business_master_new
loadtime:1.4410541057587 / seconds
Query Executed:select * from geodata_geocity where city='West Swanzey' limit 1DB:business_master_new
loadtime:1.4413230419159 / seconds
Query stored in cache : _QUERY_www.toadli.com17ad640359015887abc6d45aff463e9e
loadtime:1.4413540363312 / seconds
Query Executed:select id FROM `nh` where city='West Swanzey' && SIC_code='1521'DB:business_master_new
loadtime:1.4421560764313 / seconds
Query Executed:select * from geodata_geocity where city='Westmoreland' limit 1DB:business_master_new
loadtime:1.4424359798431 / seconds
Query stored in cache : _QUERY_www.toadli.com928fbf7415e5dfa526e845f0c4d1f08a
loadtime:1.4424839019775 / seconds
Query Executed:select id FROM `nh` where city='Westmoreland' && SIC_code='1521'DB:business_master_new
loadtime:1.4435629844666 / seconds
Query Executed:select * from geodata_geocity where city='Whitefield' limit 1DB:business_master_new
loadtime:1.4438390731812 / seconds
Query stored in cache : _QUERY_www.toadli.comfd9f0a1ed07688a8255c982c3e30f7a5
loadtime:1.4438810348511 / seconds
Query Executed:select id FROM `nh` where city='Whitefield' && SIC_code='1521'DB:business_master_new
loadtime:1.4449899196625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmot' limit 1
loadtime:1.4450480937958 / seconds
Query Executed:select id FROM `nh` where city='Wilmot' && SIC_code='1521'DB:business_master_new
loadtime:1.4460768699646 / seconds
Query Executed:select * from geodata_geocity where city='Wilmot Flat' limit 1DB:business_master_new
loadtime:1.446389913559 / seconds
Query stored in cache : _QUERY_www.toadli.com24085371a398f57f3b5c85b0ad1818ca
loadtime:1.4464340209961 / seconds
Query Executed:select id FROM `nh` where city='Wilmot Flat' && SIC_code='1521'DB:business_master_new
loadtime:1.4466660022736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:1.4467051029205 / seconds
Query Executed:select id FROM `nh` where city='Wilton' && SIC_code='1521'DB:business_master_new
loadtime:1.4479689598083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:1.4480938911438 / seconds
Query Executed:select id FROM `nh` where city='Winchester' && SIC_code='1521'DB:business_master_new
loadtime:1.4492728710175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windham' limit 1
loadtime:1.4493319988251 / seconds
Query Executed:select id FROM `nh` where city='Windham' && SIC_code='1521'DB:business_master_new
loadtime:1.4507219791412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:1.4507899284363 / seconds
Query Executed:select id FROM `nh` where city='Windsor' && SIC_code='1521'DB:business_master_new
loadtime:1.4510400295258 / seconds
Query Executed:select * from geodata_geocity where city='Winnisquam' limit 1DB:business_master_new
loadtime:1.4513309001923 / seconds
Query stored in cache : _QUERY_www.toadli.com612a12e439b1d7bffa6c2f894b44beca
loadtime:1.4513630867004 / seconds
Query Executed:select id FROM `nh` where city='Winnisquam' && SIC_code='1521'DB:business_master_new
loadtime:1.4523079395294 / seconds
Query Executed:select * from geodata_geocity where city='Wolfeboro' limit 1DB:business_master_new
loadtime:1.4525830745697 / seconds
Query stored in cache : _QUERY_www.toadli.com7af7b4ef3c4a4f6cd4ab36efa2bf0ade
loadtime:1.4526290893555 / seconds
Query Executed:select id FROM `nh` where city='Wolfeboro' && SIC_code='1521'DB:business_master_new
loadtime:1.4540300369263 / seconds
Query Executed:select * from geodata_geocity where city='Wolfeboro Falls' limit 1DB:business_master_new
loadtime:1.4543359279633 / seconds
Query stored in cache : _QUERY_www.toadli.comd2d319dadc015e792780981052e5c217
loadtime:1.4543659687042 / seconds
Query Executed:select id FROM `nh` where city='Wolfeboro Falls' && SIC_code='1521'DB:business_master_new
loadtime:1.4553520679474 / seconds
Query Executed:select * from geodata_geocity where city='Wonalancet' limit 1DB:business_master_new
loadtime:1.4556210041046 / seconds
Query stored in cache : _QUERY_www.toadli.com5ba1910c658f28e75b09e39b0fc1936b
loadtime:1.4556629657745 / seconds
Query Executed:select id FROM `nh` where city='Wonalancet' && SIC_code='1521'DB:business_master_new
loadtime:1.4559049606323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:1.4559419155121 / seconds
Query Executed:select id FROM `nh` where city='Woodstock' && SIC_code='1521'DB:business_master_new
loadtime:1.4568889141083 / seconds
Query Executed:select * from geodata_geocity where city='Woodsville' limit 1DB:business_master_new
loadtime:1.457170009613 / seconds
Query stored in cache : _QUERY_www.toadli.com86abee761aca3bbe90c75cbb96a9d349
loadtime:1.4572219848633 / seconds
Query Executed:select id FROM `nh` where city='Woodsville' && SIC_code='1521'DB:business_master_new
loadtime:1.4582130908966 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.4583129882812 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.4584999084473 / seconds
Operation template executed (chunk cache operation)
loadtime:1.4585800170898 / seconds
template override:Default
loadtime:1.4585990905762 / 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.4593820571899 / seconds
Template Constructed, Array Rows:49
loadtime:1.4596140384674 / seconds
TOTAL EXECUTION TIME: 1.45943
loadtime:1.4597289562225 / 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] => general-contractors-single-family-houses [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.4597330093384
TOTAL KEY ARRAYS: 69