Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:7.6055526733398E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018441677093506 / seconds
host not found setting manual db connection
loadtime:0.0096700191497803 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0099000930786133 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010073184967041 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010136127471924 / seconds
zipcode:
loadtime:0.010163068771362 / seconds
Query Executed:select * from search_referrer where page_hash='56ddf6855a0c1078ac8cbff0b6fae63d' limit 10 DB:ezrox_toadli
loadtime:0.010377168655396 / seconds
Operation header executed (non global)
loadtime:0.010408163070679 / seconds
Operation leaderboard executed (non global)
loadtime:0.010459184646606 / seconds
Operation square executed (non global)
loadtime:0.010488986968994 / seconds
Operation square_bottom executed (non global)
loadtime:0.010516166687012 / seconds
Operation smallsquare executed (non global)
loadtime:0.010541200637817 / seconds
Operation headeradright executed (non global)
loadtime:0.010565996170044 / seconds
Operation google_analytics executed (non global)
loadtime:0.01059103012085 / seconds
Operation topstories executed (non global)
loadtime:0.010616064071655 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010643005371094 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010668039321899 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010943174362183 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011147975921631 / seconds
Operation categories executed (global stored into APC)
loadtime:0.01118803024292 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011250019073486 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011298179626465 / seconds
Template key: archive_menu pushed
loadtime:0.011307001113892 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011320114135742 / seconds
Template key: get_gravatar pushed
loadtime:0.011327028274536 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011335134506226 / seconds
*10)-10)+1 | start:0
loadtime:0.011375188827515 / seconds
Query loaded from cache:select * from categories where cat_URLid='real-estate-agents-and-managers'
loadtime:0.011430978775024 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='vermont'
loadtime:0.011469125747681 / seconds
DB connected to localhost business_master_new
loadtime:0.011754989624023 / seconds
Query Executed:select * from `vt_catmap` where sic='6531' order by city ascDB:business_master_new
loadtime:0.025013208389282 / seconds
Query stored in cache : _QUERY_www.toadli.com06f207fd1058c6b4ba5dfa9111bab74f
loadtime:0.026331186294556 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='vermont'
loadtime:0.026385068893433 / seconds
Query Executed:select sum(totalcount) as totalsum from `vt_catmap` where sic='6531'DB:business_master_new
loadtime:0.028156042098999 / seconds
Query stored in cache : _QUERY_www.toadli.comae339a47fc95b7b94e1deefe60742e24
loadtime:0.028197050094604 / seconds
321 / 11
loadtime:0.028254985809326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adamant' limit 1
loadtime:0.028326034545898 / seconds
Query Executed:select id FROM `vt` where city='Adamant' && SIC_code='6531'DB:business_master_new
loadtime:0.039411067962646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albany' limit 1
loadtime:0.039473056793213 / seconds
Query Executed:select id FROM `vt` where city='Albany' && SIC_code='6531'DB:business_master_new
loadtime:0.040120124816895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alburg' limit 1
loadtime:0.040196180343628 / seconds
Query Executed:select id FROM `vt` where city='Alburg' && SIC_code='6531'DB:business_master_new
loadtime:0.040621995925903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.040674209594727 / seconds
Query Executed:select id FROM `vt` where city='Arlington' && SIC_code='6531'DB:business_master_new
loadtime:0.043769121170044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ascutney' limit 1
loadtime:0.043848991394043 / seconds
Query Executed:select id FROM `vt` where city='Ascutney' && SIC_code='6531'DB:business_master_new
loadtime:0.044795036315918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athens' limit 1
loadtime:0.044864177703857 / seconds
Query Executed:select id FROM `vt` where city='Athens' && SIC_code='6531'DB:business_master_new
loadtime:0.045267105102539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Averill' limit 1
loadtime:0.0453200340271 / seconds
Query Executed:select id FROM `vt` where city='Averill' && SIC_code='6531'DB:business_master_new
loadtime:0.045753002166748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bakersfield' limit 1
loadtime:0.045806169509888 / seconds
Query Executed:select id FROM `vt` where city='Bakersfield' && SIC_code='6531'DB:business_master_new
loadtime:0.046440124511719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnard' limit 1
loadtime:0.046499013900757 / seconds
Query Executed:select id FROM `vt` where city='Barnard' && SIC_code='6531'DB:business_master_new
loadtime:0.047255039215088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnet' limit 1
loadtime:0.047327995300293 / seconds
Query Executed:select id FROM `vt` where city='Barnet' && SIC_code='6531'DB:business_master_new
loadtime:0.048315048217773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barre' limit 1
loadtime:0.048367977142334 / seconds
Query Executed:select id FROM `vt` where city='Barre' && SIC_code='6531'DB:business_master_new
loadtime:0.060470104217529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barton' limit 1
loadtime:0.060563087463379 / seconds
Query Executed:select id FROM `vt` where city='Barton' && SIC_code='6531'DB:business_master_new
loadtime:0.06315803527832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beebe Plain' limit 1
loadtime:0.063232183456421 / seconds
Query Executed:select id FROM `vt` where city='Beebe Plain' && SIC_code='6531'DB:business_master_new
loadtime:0.063693046569824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beecher Falls' limit 1
loadtime:0.063760042190552 / seconds
Query Executed:select id FROM `vt` where city='Beecher Falls' && SIC_code='6531'DB:business_master_new
loadtime:0.064280986785889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellows Falls' limit 1
loadtime:0.064338207244873 / seconds
Query Executed:select id FROM `vt` where city='Bellows Falls' && SIC_code='6531'DB:business_master_new
loadtime:0.068876981735229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.068958044052124 / seconds
Query Executed:select id FROM `vt` where city='Belmont' && SIC_code='6531'DB:business_master_new
loadtime:0.069591999053955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvidere Center' limit 1
loadtime:0.069652080535889 / seconds
Query Executed:select id FROM `vt` where city='Belvidere Center' && SIC_code='6531'DB:business_master_new
loadtime:0.070082187652588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennington' limit 1
loadtime:0.07014012336731 / seconds
Query Executed:select id FROM `vt` where city='Bennington' && SIC_code='6531'DB:business_master_new
loadtime:0.081510066986084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benson' limit 1
loadtime:0.081603050231934 / seconds
Query Executed:select id FROM `vt` where city='Benson' && SIC_code='6531'DB:business_master_new
loadtime:0.082182168960571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.082249164581299 / seconds
Query Executed:select id FROM `vt` where city='Berlin' && SIC_code='6531'DB:business_master_new
loadtime:0.08283805847168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethel' limit 1
loadtime:0.08289098739624 / seconds
Query Executed:select id FROM `vt` where city='Bethel' && SIC_code='6531'DB:business_master_new
loadtime:0.085525035858154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton Valley' limit 1
loadtime:0.085591077804565 / seconds
Query Executed:select id FROM `vt` where city='Bolton Valley' && SIC_code='6531'DB:business_master_new
loadtime:0.08604907989502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bomoseen' limit 1
loadtime:0.086120128631592 / seconds
Query Executed:select id FROM `vt` where city='Bomoseen' && SIC_code='6531'DB:business_master_new
loadtime:0.095444202423096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bondville' limit 1
loadtime:0.095513105392456 / seconds
Query Executed:select id FROM `vt` where city='Bondville' && SIC_code='6531'DB:business_master_new
loadtime:0.096570014953613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.096646070480347 / seconds
Query Executed:select id FROM `vt` where city='Bradford' && SIC_code='6531'DB:business_master_new
loadtime:0.099987030029297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.10005903244019 / seconds
Query Executed:select id FROM `vt` where city='Brandon' && SIC_code='6531'DB:business_master_new
loadtime:0.10442709922791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brattleboro' limit 1
loadtime:0.10451197624207 / seconds
Query Executed:select id FROM `vt` where city='Brattleboro' && SIC_code='6531'DB:business_master_new
loadtime:0.12057399749756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.1206841468811 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater' && SIC_code='6531'DB:business_master_new
loadtime:0.12158417701721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater Corners' limit 1
loadtime:0.12165808677673 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater Corners' && SIC_code='6531'DB:business_master_new
loadtime:0.12243604660034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater Cors' limit 1
loadtime:0.1224901676178 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater Cors' && SIC_code='6531'DB:business_master_new
loadtime:0.12287306785583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridport' limit 1
loadtime:0.1229350566864 / seconds
Query Executed:select id FROM `vt` where city='Bridport' && SIC_code='6531'DB:business_master_new
loadtime:0.13175702095032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.13181114196777 / seconds
Query Executed:select id FROM `vt` where city='Bristol' && SIC_code='6531'DB:business_master_new
loadtime:0.13643217086792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.13650703430176 / seconds
Query Executed:select id FROM `vt` where city='Brookfield' && SIC_code='6531'DB:business_master_new
loadtime:0.13734698295593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline' limit 1
loadtime:0.13741111755371 / seconds
Query Executed:select id FROM `vt` where city='Brookline' && SIC_code='6531'DB:business_master_new
loadtime:0.13782000541687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownsville' limit 1
loadtime:0.13788104057312 / seconds
Query Executed:select id FROM `vt` where city='Brownsville' && SIC_code='6531'DB:business_master_new
loadtime:0.13872814178467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.13880801200867 / seconds
Query Executed:select id FROM `vt` where city='Burlington' && SIC_code='6531'DB:business_master_new
loadtime:0.14769911766052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cabot' limit 1
loadtime:0.14786410331726 / seconds
Query Executed:select id FROM `vt` where city='Cabot' && SIC_code='6531'DB:business_master_new
loadtime:0.15665221214294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calais' limit 1
loadtime:0.15672397613525 / seconds
Query Executed:select id FROM `vt` where city='Calais' && SIC_code='6531'DB:business_master_new
loadtime:0.15731716156006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:0.15737414360046 / seconds
Query Executed:select id FROM `vt` where city='Cambridge' && SIC_code='6531'DB:business_master_new
loadtime:0.16613507270813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridgeport' limit 1
loadtime:0.16619610786438 / seconds
Query Executed:select id FROM `vt` where city='Cambridgeport' && SIC_code='6531'DB:business_master_new
loadtime:0.16668200492859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canaan' limit 1
loadtime:0.1667320728302 / seconds
Query Executed:select id FROM `vt` where city='Canaan' && SIC_code='6531'DB:business_master_new
loadtime:0.16756820678711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castleton' limit 1
loadtime:0.16763401031494 / seconds
Query Executed:select id FROM `vt` where city='Castleton' && SIC_code='6531'DB:business_master_new
loadtime:0.17026209831238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cavendish' limit 1
loadtime:0.17031908035278 / seconds
Query Executed:select id FROM `vt` where city='Cavendish' && SIC_code='6531'DB:business_master_new
loadtime:0.1712281703949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Rutland' limit 1
loadtime:0.1713011264801 / seconds
Query Executed:select id FROM `vt` where city='Center Rutland' && SIC_code='6531'DB:business_master_new
loadtime:0.17215514183044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte' limit 1
loadtime:0.17222213745117 / seconds
Query Executed:select id FROM `vt` where city='Charlotte' && SIC_code='6531'DB:business_master_new
loadtime:0.17535901069641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.1754322052002 / seconds
Query Executed:select id FROM `vt` where city='Chelsea' && SIC_code='6531'DB:business_master_new
loadtime:0.18419718742371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.18426418304443 / seconds
Query Executed:select id FROM `vt` where city='Chester' && SIC_code='6531'DB:business_master_new
loadtime:0.18867421150208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chittenden' limit 1
loadtime:0.18876004219055 / seconds
Query Executed:select id FROM `vt` where city='Chittenden' && SIC_code='6531'DB:business_master_new
loadtime:0.18952417373657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colchester' limit 1
loadtime:0.18959498405457 / seconds
Query Executed:select id FROM `vt` where city='Colchester' && SIC_code='6531'DB:business_master_new
loadtime:0.19968104362488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.19978499412537 / seconds
Query Executed:select id FROM `vt` where city='Concord' && SIC_code='6531'DB:business_master_new
loadtime:0.20072817802429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corinth' limit 1
loadtime:0.20080518722534 / seconds
Query Executed:select id FROM `vt` where city='Corinth' && SIC_code='6531'DB:business_master_new
loadtime:0.20148921012878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coventry' limit 1
loadtime:0.20154213905334 / seconds
Query Executed:select id FROM `vt` where city='Coventry' && SIC_code='6531'DB:business_master_new
loadtime:0.20208215713501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury' limit 1
loadtime:0.20213913917542 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury' && SIC_code='6531'DB:business_master_new
loadtime:0.20288515090942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury Cmn' limit 1
loadtime:0.20294213294983 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury Cmn' && SIC_code='6531'DB:business_master_new
loadtime:0.20334410667419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury Common' limit 1
loadtime:0.20340013504028 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury Common' && SIC_code='6531'DB:business_master_new
loadtime:0.20409107208252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuttingsville' limit 1
loadtime:0.20414710044861 / seconds
Query Executed:select id FROM `vt` where city='Cuttingsville' && SIC_code='6531'DB:business_master_new
loadtime:0.21311616897583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danby' limit 1
loadtime:0.21317315101624 / seconds
Query Executed:select id FROM `vt` where city='Danby' && SIC_code='6531'DB:business_master_new
loadtime:0.2219831943512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.22205305099487 / seconds
Query Executed:select id FROM `vt` where city='Danville' && SIC_code='6531'DB:business_master_new
loadtime:0.22432899475098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby' limit 1
loadtime:0.2243959903717 / seconds
Query Executed:select id FROM `vt` where city='Derby' && SIC_code='6531'DB:business_master_new
loadtime:0.22727799415588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby Line' limit 1
loadtime:0.22734618186951 / seconds
Query Executed:select id FROM `vt` where city='Derby Line' && SIC_code='6531'DB:business_master_new
loadtime:0.23618412017822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorset' limit 1
loadtime:0.23625016212463 / seconds
Query Executed:select id FROM `vt` where city='Dorset' && SIC_code='6531'DB:business_master_new
loadtime:0.23884916305542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dummerston' limit 1
loadtime:0.23892712593079 / seconds
Query Executed:select id FROM `vt` where city='Dummerston' && SIC_code='6531'DB:business_master_new
loadtime:0.23930907249451 / seconds
Query loaded from cache:select * from geodata_geocity where city='E St Johnsbury' limit 1
loadtime:0.23936200141907 / seconds
Query Executed:select id FROM `vt` where city='E St Johnsbury' && SIC_code='6531'DB:business_master_new
loadtime:0.23972821235657 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Arlington' limit 1
loadtime:0.23979210853577 / seconds
Query Executed:select id FROM `vt` where city='East Arlington' && SIC_code='6531'DB:business_master_new
loadtime:0.24042820930481 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Barre' limit 1
loadtime:0.24048113822937 / seconds
Query Executed:select id FROM `vt` where city='East Barre' && SIC_code='6531'DB:business_master_new
loadtime:0.24128198623657 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Berkshire' limit 1
loadtime:0.24133515357971 / seconds
Query Executed:select id FROM `vt` where city='East Berkshire' && SIC_code='6531'DB:business_master_new
loadtime:0.24186420440674 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Burke' limit 1
loadtime:0.24193406105042 / seconds
Query Executed:select id FROM `vt` where city='East Burke' && SIC_code='6531'DB:business_master_new
loadtime:0.25040912628174 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Calais' limit 1
loadtime:0.25048112869263 / seconds
Query Executed:select id FROM `vt` where city='East Calais' && SIC_code='6531'DB:business_master_new
loadtime:0.25110602378845 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Charleston' limit 1
loadtime:0.25116014480591 / seconds
Query Executed:select id FROM `vt` where city='East Charleston' && SIC_code='6531'DB:business_master_new
loadtime:0.25163102149963 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Corinth' limit 1
loadtime:0.25168108940125 / seconds
Query Executed:select id FROM `vt` where city='East Corinth' && SIC_code='6531'DB:business_master_new
loadtime:0.25236320495605 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dorset' limit 1
loadtime:0.25242018699646 / seconds
Query Executed:select id FROM `vt` where city='East Dorset' && SIC_code='6531'DB:business_master_new
loadtime:0.25324010848999 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dover' limit 1
loadtime:0.25329613685608 / seconds
Query Executed:select id FROM `vt` where city='East Dover' && SIC_code='6531'DB:business_master_new
loadtime:0.25396108627319 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dummerston' limit 1
loadtime:0.25402808189392 / seconds
Query Executed:select id FROM `vt` where city='East Dummerston' && SIC_code='6531'DB:business_master_new
loadtime:0.25437116622925 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Fairfield' limit 1
loadtime:0.25442910194397 / seconds
Query Executed:select id FROM `vt` where city='East Fairfield' && SIC_code='6531'DB:business_master_new
loadtime:0.25508809089661 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hardwick' limit 1
loadtime:0.25514006614685 / seconds
Query Executed:select id FROM `vt` where city='East Hardwick' && SIC_code='6531'DB:business_master_new
loadtime:0.25588512420654 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Haven' limit 1
loadtime:0.25595998764038 / seconds
Query Executed:select id FROM `vt` where city='East Haven' && SIC_code='6531'DB:business_master_new
loadtime:0.25643801689148 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Middlebury' limit 1
loadtime:0.25649404525757 / seconds
Query Executed:select id FROM `vt` where city='East Middlebury' && SIC_code='6531'DB:business_master_new
loadtime:0.25721406936646 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Montpelier' limit 1
loadtime:0.2572820186615 / seconds
Query Executed:select id FROM `vt` where city='East Montpelier' && SIC_code='6531'DB:business_master_new
loadtime:0.25959205627441 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Orange' limit 1
loadtime:0.25966501235962 / seconds
Query Executed:select id FROM `vt` where city='East Orange' && SIC_code='6531'DB:business_master_new
loadtime:0.26007318496704 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Poultney' limit 1
loadtime:0.26012706756592 / seconds
Query Executed:select id FROM `vt` where city='East Poultney' && SIC_code='6531'DB:business_master_new
loadtime:0.26056909561157 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Randolph' limit 1
loadtime:0.26062417030334 / seconds
Query Executed:select id FROM `vt` where city='East Randolph' && SIC_code='6531'DB:business_master_new
loadtime:0.26112413406372 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Ryegate' limit 1
loadtime:0.26117610931396 / seconds
Query Executed:select id FROM `vt` where city='East Ryegate' && SIC_code='6531'DB:business_master_new
loadtime:0.26177620887756 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Saint Johnsbury' limit 1
loadtime:0.26183104515076 / seconds
Query Executed:select id FROM `vt` where city='East Saint Johnsbury' && SIC_code='6531'DB:business_master_new
loadtime:0.26230001449585 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Thetford' limit 1
loadtime:0.26235508918762 / seconds
Query Executed:select id FROM `vt` where city='East Thetford' && SIC_code='6531'DB:business_master_new
loadtime:0.26324200630188 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Wallingford' limit 1
loadtime:0.26331210136414 / seconds
Query Executed:select id FROM `vt` where city='East Wallingford' && SIC_code='6531'DB:business_master_new
loadtime:0.26385402679443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.26391410827637 / seconds
Query Executed:select id FROM `vt` where city='Eden' && SIC_code='6531'DB:business_master_new
loadtime:0.26450800895691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden Mills' limit 1
loadtime:0.26457214355469 / seconds
Query Executed:select id FROM `vt` where city='Eden Mills' && SIC_code='6531'DB:business_master_new
loadtime:0.2650671005249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enosburg Falls' limit 1
loadtime:0.26512503623962 / seconds
Query Executed:select id FROM `vt` where city='Enosburg Falls' && SIC_code='6531'DB:business_master_new
loadtime:0.26894116401672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.26901507377625 / seconds
Query Executed:select id FROM `vt` where city='Essex' && SIC_code='6531'DB:business_master_new
loadtime:0.26992607116699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex Junction' limit 1
loadtime:0.26999998092651 / seconds
Query Executed:select id FROM `vt` where city='Essex Junction' && SIC_code='6531'DB:business_master_new
loadtime:0.28198909759521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Haven' limit 1
loadtime:0.28213000297546 / seconds
Query Executed:select id FROM `vt` where city='Fair Haven' && SIC_code='6531'DB:business_master_new
loadtime:0.28555011749268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.28563618659973 / seconds
Query Executed:select id FROM `vt` where city='Fairfax' && SIC_code='6531'DB:business_master_new
loadtime:0.28841114044189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.28848004341125 / seconds
Query Executed:select id FROM `vt` where city='Fairfield' && SIC_code='6531'DB:business_master_new
loadtime:0.28937911987305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairlee' limit 1
loadtime:0.28943800926208 / seconds
Query Executed:select id FROM `vt` where city='Fairlee' && SIC_code='6531'DB:business_master_new
loadtime:0.29185009002686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferrisburg' limit 1
loadtime:0.29192519187927 / seconds
Query Executed:select id FROM `vt` where city='Ferrisburg' && SIC_code='6531'DB:business_master_new
loadtime:0.29234504699707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.29239916801453 / seconds
Query Executed:select id FROM `vt` where city='Florence' && SIC_code='6531'DB:business_master_new
loadtime:0.29297804832458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest Dale' limit 1
loadtime:0.2930371761322 / seconds
Query Executed:select id FROM `vt` where city='Forest Dale' && SIC_code='6531'DB:business_master_new
loadtime:0.29347610473633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.29352617263794 / seconds
Query Executed:select id FROM `vt` where city='Franklin' && SIC_code='6531'DB:business_master_new
loadtime:0.30280208587646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaysville' limit 1
loadtime:0.30286908149719 / seconds
Query Executed:select id FROM `vt` where city='Gaysville' && SIC_code='6531'DB:business_master_new
loadtime:0.30334711074829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:0.30340003967285 / seconds
Query Executed:select id FROM `vt` where city='Gilman' && SIC_code='6531'DB:business_master_new
loadtime:0.30387711524963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glover' limit 1
loadtime:0.30393719673157 / seconds
Query Executed:select id FROM `vt` where city='Glover' && SIC_code='6531'DB:business_master_new
loadtime:0.30463409423828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.30470299720764 / seconds
Query Executed:select id FROM `vt` where city='Grafton' && SIC_code='6531'DB:business_master_new
loadtime:0.31325697898865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:0.31332612037659 / seconds
Query Executed:select id FROM `vt` where city='Granby' && SIC_code='6531'DB:business_master_new
loadtime:0.31373500823975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Isle' limit 1
loadtime:0.313796043396 / seconds
Query Executed:select id FROM `vt` where city='Grand Isle' && SIC_code='6531'DB:business_master_new
loadtime:0.32255911827087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graniteville' limit 1
loadtime:0.32263016700745 / seconds
Query Executed:select id FROM `vt` where city='Graniteville' && SIC_code='6531'DB:business_master_new
loadtime:0.32338118553162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granville' limit 1
loadtime:0.32343506813049 / seconds
Query Executed:select id FROM `vt` where city='Granville' && SIC_code='6531'DB:business_master_new
loadtime:0.3239860534668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greensboro' limit 1
loadtime:0.32403802871704 / seconds
Query Executed:select id FROM `vt` where city='Greensboro' && SIC_code='6531'DB:business_master_new
loadtime:0.32473301887512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greensboro Bend' limit 1
loadtime:0.32480907440186 / seconds
Query Executed:select id FROM `vt` where city='Greensboro Bend' && SIC_code='6531'DB:business_master_new
loadtime:0.32537508010864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.32544016838074 / seconds
Query Executed:select id FROM `vt` where city='Groton' && SIC_code='6531'DB:business_master_new
loadtime:0.3341851234436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guildhall' limit 1
loadtime:0.33424305915833 / seconds
Query Executed:select id FROM `vt` where city='Guildhall' && SIC_code='6531'DB:business_master_new
loadtime:0.33498215675354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guilford' limit 1
loadtime:0.33503913879395 / seconds
Query Executed:select id FROM `vt` where city='Guilford' && SIC_code='6531'DB:business_master_new
loadtime:0.33538818359375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:0.33543920516968 / seconds
Query Executed:select id FROM `vt` where city='Hancock' && SIC_code='6531'DB:business_master_new
loadtime:0.33609199523926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardwick' limit 1
loadtime:0.3361451625824 / seconds
Query Executed:select id FROM `vt` where city='Hardwick' && SIC_code='6531'DB:business_master_new
loadtime:0.33913016319275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.33920216560364 / seconds
Query Executed:select id FROM `vt` where city='Hartford' && SIC_code='6531'DB:business_master_new
loadtime:0.34801602363586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland' limit 1
loadtime:0.34808802604675 / seconds
Query Executed:select id FROM `vt` where city='Hartland' && SIC_code='6531'DB:business_master_new
loadtime:0.35041999816895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland 4 Cors' limit 1
loadtime:0.35049104690552 / seconds
Query Executed:select id FROM `vt` where city='Hartland 4 Cors' && SIC_code='6531'DB:business_master_new
loadtime:0.35089802742004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland Four Corners' limit 1
loadtime:0.35095620155334 / seconds
Query Executed:select id FROM `vt` where city='Hartland Four Corners' && SIC_code='6531'DB:business_master_new
loadtime:0.35140919685364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highgate Center' limit 1
loadtime:0.35145998001099 / seconds
Query Executed:select id FROM `vt` where city='Highgate Center' && SIC_code='6531'DB:business_master_new
loadtime:0.36024308204651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highgate Springs' limit 1
loadtime:0.36031317710876 / seconds
Query Executed:select id FROM `vt` where city='Highgate Springs' && SIC_code='6531'DB:business_master_new
loadtime:0.36093401908875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinesburg' limit 1
loadtime:0.36099004745483 / seconds
Query Executed:select id FROM `vt` where city='Hinesburg' && SIC_code='6531'DB:business_master_new
loadtime:0.36441898345947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington' limit 1
loadtime:0.36448907852173 / seconds
Query Executed:select id FROM `vt` where city='Huntington' && SIC_code='6531'DB:business_master_new
loadtime:0.37326312065125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyde Park' limit 1
loadtime:0.37332320213318 / seconds
Query Executed:select id FROM `vt` where city='Hyde Park' && SIC_code='6531'DB:business_master_new
loadtime:0.37579202651978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hydeville' limit 1
loadtime:0.37586617469788 / seconds
Query Executed:select id FROM `vt` where city='Hydeville' && SIC_code='6531'DB:business_master_new
loadtime:0.37646818161011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irasburg' limit 1
loadtime:0.37653303146362 / seconds
Query Executed:select id FROM `vt` where city='Irasburg' && SIC_code='6531'DB:business_master_new
loadtime:0.38534212112427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Island Pond' limit 1
loadtime:0.38540816307068 / seconds
Query Executed:select id FROM `vt` where city='Island Pond' && SIC_code='6531'DB:business_master_new
loadtime:0.39433598518372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isle La Motte' limit 1
loadtime:0.3944091796875 / seconds
Query Executed:select id FROM `vt` where city='Isle La Motte' && SIC_code='6531'DB:business_master_new
loadtime:0.39506602287292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jacksonville' limit 1
loadtime:0.39512014389038 / seconds
Query Executed:select id FROM `vt` where city='Jacksonville' && SIC_code='6531'DB:business_master_new
loadtime:0.40372800827026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica' limit 1
loadtime:0.40380311012268 / seconds
Query Executed:select id FROM `vt` where city='Jamaica' && SIC_code='6531'DB:business_master_new
loadtime:0.40474414825439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jay' limit 1
loadtime:0.40481114387512 / seconds
Query Executed:select id FROM `vt` where city='Jay' && SIC_code='6531'DB:business_master_new
loadtime:0.40521311759949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jeffersonville' limit 1
loadtime:0.40527105331421 / seconds
Query Executed:select id FROM `vt` where city='Jeffersonville' && SIC_code='6531'DB:business_master_new
loadtime:0.40776920318604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jericho' limit 1
loadtime:0.40784502029419 / seconds
Query Executed:select id FROM `vt` where city='Jericho' && SIC_code='6531'DB:business_master_new
loadtime:0.41110801696777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jericho Center' limit 1
loadtime:0.41117906570435 / seconds
Query Executed:select id FROM `vt` where city='Jericho Center' && SIC_code='6531'DB:business_master_new
loadtime:0.41156005859375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnson' limit 1
loadtime:0.41161799430847 / seconds
Query Executed:select id FROM `vt` where city='Johnson' && SIC_code='6531'DB:business_master_new
loadtime:0.41442918777466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:0.41449618339539 / seconds
Query Executed:select id FROM `vt` where city='Jonesville' && SIC_code='6531'DB:business_master_new
loadtime:0.41498899459839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Killington' limit 1
loadtime:0.41504216194153 / seconds
Query Executed:select id FROM `vt` where city='Killington' && SIC_code='6531'DB:business_master_new
loadtime:0.41889619827271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Elmore' limit 1
loadtime:0.41899108886719 / seconds
Query Executed:select id FROM `vt` where city='Lake Elmore' && SIC_code='6531'DB:business_master_new
loadtime:0.41957306861877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemington' limit 1
loadtime:0.41962814331055 / seconds
Query Executed:select id FROM `vt` where city='Lemington' && SIC_code='6531'DB:business_master_new
loadtime:0.42006301879883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.42011713981628 / seconds
Query Executed:select id FROM `vt` where city='Lincoln' && SIC_code='6531'DB:business_master_new
loadtime:0.42052102088928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Londonderry' limit 1
loadtime:0.42057704925537 / seconds
Query Executed:select id FROM `vt` where city='Londonderry' && SIC_code='6531'DB:business_master_new
loadtime:0.42948198318481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:0.42955017089844 / seconds
Query Executed:select id FROM `vt` where city='Lowell' && SIC_code='6531'DB:business_master_new
loadtime:0.43027520179749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lower Waterford' limit 1
loadtime:0.43032908439636 / seconds
Query Executed:select id FROM `vt` where city='Lower Waterford' && SIC_code='6531'DB:business_master_new
loadtime:0.4308819770813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:0.43093800544739 / seconds
Query Executed:select id FROM `vt` where city='Ludlow' && SIC_code='6531'DB:business_master_new
loadtime:0.43563103675842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:0.43575119972229 / seconds
Query Executed:select id FROM `vt` where city='Lunenburg' && SIC_code='6531'DB:business_master_new
loadtime:0.43652105331421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndon' limit 1
loadtime:0.43657803535461 / seconds
Query Executed:select id FROM `vt` where city='Lyndon' && SIC_code='6531'DB:business_master_new
loadtime:0.43741917610168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndon Center' limit 1
loadtime:0.43747520446777 / seconds
Query Executed:select id FROM `vt` where city='Lyndon Center' && SIC_code='6531'DB:business_master_new
loadtime:0.43808698654175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndonville' limit 1
loadtime:0.43813920021057 / seconds
Query Executed:select id FROM `vt` where city='Lyndonville' && SIC_code='6531'DB:business_master_new
loadtime:0.44248819351196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.44256711006165 / seconds
Query Executed:select id FROM `vt` where city='Manchester' && SIC_code='6531'DB:business_master_new
loadtime:0.44566202163696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester Center' limit 1
loadtime:0.44573402404785 / seconds
Query Executed:select id FROM `vt` where city='Manchester Center' && SIC_code='6531'DB:business_master_new
loadtime:0.45318913459778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester Ctr' limit 1
loadtime:0.45328307151794 / seconds
Query Executed:select id FROM `vt` where city='Manchester Ctr' && SIC_code='6531'DB:business_master_new
loadtime:0.45369100570679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlboro' limit 1
loadtime:0.45375919342041 / seconds
Query Executed:select id FROM `vt` where city='Marlboro' && SIC_code='6531'DB:business_master_new
loadtime:0.45452117919922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield' limit 1
loadtime:0.45457410812378 / seconds
Query Executed:select id FROM `vt` where city='Marshfield' && SIC_code='6531'DB:business_master_new
loadtime:0.46347212791443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Indoe Falls' limit 1
loadtime:0.46353697776794 / seconds
Query Executed:select id FROM `vt` where city='Mc Indoe Falls' && SIC_code='6531'DB:business_master_new
loadtime:0.46405220031738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebury' limit 1
loadtime:0.46410512924194 / seconds
Query Executed:select id FROM `vt` where city='Middlebury' && SIC_code='6531'DB:business_master_new
loadtime:0.47340607643127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown Spgs' limit 1
loadtime:0.47349405288696 / seconds
Query Executed:select id FROM `vt` where city='Middletown Spgs' && SIC_code='6531'DB:business_master_new
loadtime:0.47392511367798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown Springs' limit 1
loadtime:0.47398614883423 / seconds
Query Executed:select id FROM `vt` where city='Middletown Springs' && SIC_code='6531'DB:business_master_new
loadtime:0.47486710548401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:0.47493720054626 / seconds
Query Executed:select id FROM `vt` where city='Milton' && SIC_code='6531'DB:business_master_new
loadtime:0.4806489944458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monkton' limit 1
loadtime:0.4807460308075 / seconds
Query Executed:select id FROM `vt` where city='Monkton' && SIC_code='6531'DB:business_master_new
loadtime:0.48152709007263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery' limit 1
loadtime:0.48167109489441 / seconds
Query Executed:select id FROM `vt` where city='Montgomery' && SIC_code='6531'DB:business_master_new
loadtime:0.4822690486908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery Center' limit 1
loadtime:0.48233199119568 / seconds
Query Executed:select id FROM `vt` where city='Montgomery Center' && SIC_code='6531'DB:business_master_new
loadtime:0.48317003250122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery Ctr' limit 1
loadtime:0.48326110839844 / seconds
Query Executed:select id FROM `vt` where city='Montgomery Ctr' && SIC_code='6531'DB:business_master_new
loadtime:0.48372101783752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:0.48379302024841 / seconds
Query Executed:select id FROM `vt` where city='Montpelier' && SIC_code='6531'DB:business_master_new
loadtime:0.4990861415863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moretown' limit 1
loadtime:0.49920511245728 / seconds
Query Executed:select id FROM `vt` where city='Moretown' && SIC_code='6531'DB:business_master_new
loadtime:0.50820207595825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morgan' limit 1
loadtime:0.50830411911011 / seconds
Query Executed:select id FROM `vt` where city='Morgan' && SIC_code='6531'DB:business_master_new
loadtime:0.50892400741577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisville' limit 1
loadtime:0.5089910030365 / seconds
Query Executed:select id FROM `vt` where city='Morrisville' && SIC_code='6531'DB:business_master_new
loadtime:0.51510119438171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moscow' limit 1
loadtime:0.51519417762756 / seconds
Query Executed:select id FROM `vt` where city='Moscow' && SIC_code='6531'DB:business_master_new
loadtime:0.51573204994202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Holly' limit 1
loadtime:0.51580715179443 / seconds
Query Executed:select id FROM `vt` where city='Mount Holly' && SIC_code='6531'DB:business_master_new
loadtime:0.51654815673828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Holly' limit 1
loadtime:0.51662516593933 / seconds
Query Executed:select id FROM `vt` where city='Mt Holly' && SIC_code='6531'DB:business_master_new
loadtime:0.51707005500793 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Springfield' limit 1
loadtime:0.51713800430298 / seconds
Query Executed:select id FROM `vt` where city='N Springfield' && SIC_code='6531'DB:business_master_new
loadtime:0.51765704154968 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Haven' limit 1
loadtime:0.51771807670593 / seconds
Query Executed:select id FROM `vt` where city='New Haven' && SIC_code='6531'DB:business_master_new
loadtime:0.52007102966309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbury' limit 1
loadtime:0.52013421058655 / seconds
Query Executed:select id FROM `vt` where city='Newbury' && SIC_code='6531'DB:business_master_new
loadtime:0.52089214324951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newfane' limit 1
loadtime:0.52096319198608 / seconds
Query Executed:select id FROM `vt` where city='Newfane' && SIC_code='6531'DB:business_master_new
loadtime:0.5231990814209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:0.52328014373779 / seconds
Query Executed:select id FROM `vt` where city='Newport' && SIC_code='6531'DB:business_master_new
loadtime:0.53045105934143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport Center' limit 1
loadtime:0.53054118156433 / seconds
Query Executed:select id FROM `vt` where city='Newport Center' && SIC_code='6531'DB:business_master_new
loadtime:0.53140616416931 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Bennington' limit 1
loadtime:0.53146910667419 / seconds
Query Executed:select id FROM `vt` where city='North Bennington' && SIC_code='6531'DB:business_master_new
loadtime:0.53382301330566 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chittenden' limit 1
loadtime:0.53389501571655 / seconds
Query Executed:select id FROM `vt` where city='North Chittenden' && SIC_code='6531'DB:business_master_new
loadtime:0.53427004814148 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Clarendon' limit 1
loadtime:0.53433108329773 / seconds
Query Executed:select id FROM `vt` where city='North Clarendon' && SIC_code='6531'DB:business_master_new
loadtime:0.53669810295105 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Concord' limit 1
loadtime:0.53678607940674 / seconds
Query Executed:select id FROM `vt` where city='North Concord' && SIC_code='6531'DB:business_master_new
loadtime:0.5373170375824 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Ferrisburg' limit 1
loadtime:0.5373911857605 / seconds
Query Executed:select id FROM `vt` where city='North Ferrisburg' && SIC_code='6531'DB:business_master_new
loadtime:0.5378360748291 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hartland' limit 1
loadtime:0.53789806365967 / seconds
Query Executed:select id FROM `vt` where city='North Hartland' && SIC_code='6531'DB:business_master_new
loadtime:0.53843808174133 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hero' limit 1
loadtime:0.53851318359375 / seconds
Query Executed:select id FROM `vt` where city='North Hero' && SIC_code='6531'DB:business_master_new
loadtime:0.54737401008606 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hyde Park' limit 1
loadtime:0.54745602607727 / seconds
Query Executed:select id FROM `vt` where city='North Hyde Park' && SIC_code='6531'DB:business_master_new
loadtime:0.54799914360046 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Montpelier' limit 1
loadtime:0.54806518554688 / seconds
Query Executed:select id FROM `vt` where city='North Montpelier' && SIC_code='6531'DB:business_master_new
loadtime:0.54853010177612 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pomfret' limit 1
loadtime:0.54859614372253 / seconds
Query Executed:select id FROM `vt` where city='North Pomfret' && SIC_code='6531'DB:business_master_new
loadtime:0.54928016662598 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pownal' limit 1
loadtime:0.54935908317566 / seconds
Query Executed:select id FROM `vt` where city='North Pownal' && SIC_code='6531'DB:business_master_new
loadtime:0.54991507530212 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Springfield' limit 1
loadtime:0.54998302459717 / seconds
Query Executed:select id FROM `vt` where city='North Springfield' && SIC_code='6531'DB:business_master_new
loadtime:0.55882406234741 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Thetford' limit 1
loadtime:0.55889201164246 / seconds
Query Executed:select id FROM `vt` where city='North Thetford' && SIC_code='6531'DB:business_master_new
loadtime:0.55939912796021 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Troy' limit 1
loadtime:0.55946612358093 / seconds
Query Executed:select id FROM `vt` where city='North Troy' && SIC_code='6531'DB:business_master_new
loadtime:0.56830501556396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:0.5683901309967 / seconds
Query Executed:select id FROM `vt` where city='Northfield' && SIC_code='6531'DB:business_master_new
loadtime:0.57210803031921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield Falls' limit 1
loadtime:0.57219409942627 / seconds
Query Executed:select id FROM `vt` where city='Northfield Falls' && SIC_code='6531'DB:business_master_new
loadtime:0.57275009155273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:0.57282304763794 / seconds
Query Executed:select id FROM `vt` where city='Norton' && SIC_code='6531'DB:business_master_new
loadtime:0.57350420951843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwich' limit 1
loadtime:0.5735650062561 / seconds
Query Executed:select id FROM `vt` where city='Norwich' && SIC_code='6531'DB:business_master_new
loadtime:0.57734799385071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:0.57743906974792 / seconds
Query Executed:select id FROM `vt` where city='Orange' && SIC_code='6531'DB:business_master_new
loadtime:0.57793998718262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orleans' limit 1
loadtime:0.57800507545471 / seconds
Query Executed:select id FROM `vt` where city='Orleans' && SIC_code='6531'DB:business_master_new
loadtime:0.58038115501404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orwell' limit 1
loadtime:0.5804500579834 / seconds
Query Executed:select id FROM `vt` where city='Orwell' && SIC_code='6531'DB:business_master_new
loadtime:0.58929109573364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Passumpsic' limit 1
loadtime:0.589359998703 / seconds
Query Executed:select id FROM `vt` where city='Passumpsic' && SIC_code='6531'DB:business_master_new
loadtime:0.5897970199585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pawlet' limit 1
loadtime:0.58986210823059 / seconds
Query Executed:select id FROM `vt` where city='Pawlet' && SIC_code='6531'DB:business_master_new
loadtime:0.59873414039612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peacham' limit 1
loadtime:0.59882616996765 / seconds
Query Executed:select id FROM `vt` where city='Peacham' && SIC_code='6531'DB:business_master_new
loadtime:0.5995020866394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perkinsville' limit 1
loadtime:0.59956502914429 / seconds
Query Executed:select id FROM `vt` where city='Perkinsville' && SIC_code='6531'DB:business_master_new
loadtime:0.60840010643005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peru' limit 1
loadtime:0.60846209526062 / seconds
Query Executed:select id FROM `vt` where city='Peru' && SIC_code='6531'DB:business_master_new
loadtime:0.60913419723511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsfield' limit 1
loadtime:0.60919618606567 / seconds
Query Executed:select id FROM `vt` where city='Pittsfield' && SIC_code='6531'DB:business_master_new
loadtime:0.60993599891663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsford' limit 1
loadtime:0.61001420021057 / seconds
Query Executed:select id FROM `vt` where city='Pittsford' && SIC_code='6531'DB:business_master_new
loadtime:0.61266016960144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:0.61274719238281 / seconds
Query Executed:select id FROM `vt` where city='Plainfield' && SIC_code='6531'DB:business_master_new
loadtime:0.615079164505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.615159034729 / seconds
Query Executed:select id FROM `vt` where city='Plymouth' && SIC_code='6531'DB:business_master_new
loadtime:0.61587309837341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Post Mills' limit 1
loadtime:0.61595702171326 / seconds
Query Executed:select id FROM `vt` where city='Post Mills' && SIC_code='6531'DB:business_master_new
loadtime:0.61651921272278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poultney' limit 1
loadtime:0.61658310890198 / seconds
Query Executed:select id FROM `vt` where city='Poultney' && SIC_code='6531'DB:business_master_new
loadtime:0.61946821212769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pownal' limit 1
loadtime:0.61954998970032 / seconds
Query Executed:select id FROM `vt` where city='Pownal' && SIC_code='6531'DB:business_master_new
loadtime:0.62821006774902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Proctor' limit 1
loadtime:0.62828803062439 / seconds
Query Executed:select id FROM `vt` where city='Proctor' && SIC_code='6531'DB:business_master_new
loadtime:0.63717007637024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Proctorsville' limit 1
loadtime:0.63724708557129 / seconds
Query Executed:select id FROM `vt` where city='Proctorsville' && SIC_code='6531'DB:business_master_new
loadtime:0.63813519477844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Putney' limit 1
loadtime:0.63821220397949 / seconds
Query Executed:select id FROM `vt` where city='Putney' && SIC_code='6531'DB:business_master_new
loadtime:0.64154314994812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quechee' limit 1
loadtime:0.64161109924316 / seconds
Query Executed:select id FROM `vt` where city='Quechee' && SIC_code='6531'DB:business_master_new
loadtime:0.64411211013794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:0.64420700073242 / seconds
Query Executed:select id FROM `vt` where city='Randolph' && SIC_code='6531'DB:business_master_new
loadtime:0.64870405197144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph Center' limit 1
loadtime:0.64880609512329 / seconds
Query Executed:select id FROM `vt` where city='Randolph Center' && SIC_code='6531'DB:business_master_new
loadtime:0.64969801902771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reading' limit 1
loadtime:0.64979004859924 / seconds
Query Executed:select id FROM `vt` where city='Reading' && SIC_code='6531'DB:business_master_new
loadtime:0.65057420730591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readsboro' limit 1
loadtime:0.65064120292664 / seconds
Query Executed:select id FROM `vt` where city='Readsboro' && SIC_code='6531'DB:business_master_new
loadtime:0.65143013000488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richford' limit 1
loadtime:0.65149021148682 / seconds
Query Executed:select id FROM `vt` where city='Richford' && SIC_code='6531'DB:business_master_new
loadtime:0.65382599830627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:0.65390419960022 / seconds
Query Executed:select id FROM `vt` where city='Richmond' && SIC_code='6531'DB:business_master_new
loadtime:0.65738201141357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ripton' limit 1
loadtime:0.65746903419495 / seconds
Query Executed:select id FROM `vt` where city='Ripton' && SIC_code='6531'DB:business_master_new
loadtime:0.65801310539246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:0.65807604789734 / seconds
Query Executed:select id FROM `vt` where city='Rochester' && SIC_code='6531'DB:business_master_new
loadtime:0.66696405410767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:0.66704416275024 / seconds
Query Executed:select id FROM `vt` where city='Roxbury' && SIC_code='6531'DB:business_master_new
loadtime:0.66774201393127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rupert' limit 1
loadtime:0.66781902313232 / seconds
Query Executed:select id FROM `vt` where city='Rupert' && SIC_code='6531'DB:business_master_new
loadtime:0.66839408874512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:0.66845512390137 / seconds
Query Executed:select id FROM `vt` where city='Rutland' && SIC_code='6531'DB:business_master_new
loadtime:0.67739319801331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ryegate' limit 1
loadtime:0.67754101753235 / seconds
Query Executed:select id FROM `vt` where city='Ryegate' && SIC_code='6531'DB:business_master_new
loadtime:0.67803812026978 / seconds
Query loaded from cache:select * from geodata_geocity where city='S Londonderry' limit 1
loadtime:0.6781120300293 / seconds
Query Executed:select id FROM `vt` where city='S Londonderry' && SIC_code='6531'DB:business_master_new
loadtime:0.67867803573608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Albans' limit 1
loadtime:0.67875409126282 / seconds
Query Executed:select id FROM `vt` where city='Saint Albans' && SIC_code='6531'DB:business_master_new
loadtime:0.68949604034424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Albans Bay' limit 1
loadtime:0.68960118293762 / seconds
Query Executed:select id FROM `vt` where city='Saint Albans Bay' && SIC_code='6531'DB:business_master_new
loadtime:0.69021821022034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johnsbury' limit 1
loadtime:0.69028210639954 / seconds
Query Executed:select id FROM `vt` where city='Saint Johnsbury' && SIC_code='6531'DB:business_master_new
loadtime:0.69937300682068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johnsbury Center' limit 1
loadtime:0.69947910308838 / seconds
Query Executed:select id FROM `vt` where city='Saint Johnsbury Center' && SIC_code='6531'DB:business_master_new
loadtime:0.70013904571533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:0.70020508766174 / seconds
Query Executed:select id FROM `vt` where city='Salisbury' && SIC_code='6531'DB:business_master_new
loadtime:0.7011890411377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxtons River' limit 1
loadtime:0.70126509666443 / seconds
Query Executed:select id FROM `vt` where city='Saxtons River' && SIC_code='6531'DB:business_master_new
loadtime:0.71020102500916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaftsbury' limit 1
loadtime:0.71028208732605 / seconds
Query Executed:select id FROM `vt` where city='Shaftsbury' && SIC_code='6531'DB:business_master_new
loadtime:0.71282315254211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.7129020690918 / seconds
Query Executed:select id FROM `vt` where city='Sharon' && SIC_code='6531'DB:business_master_new
loadtime:0.721675157547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheffield' limit 1
loadtime:0.72175407409668 / seconds
Query Executed:select id FROM `vt` where city='Sheffield' && SIC_code='6531'DB:business_master_new
loadtime:0.72241115570068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelburne' limit 1
loadtime:0.72247409820557 / seconds
Query Executed:select id FROM `vt` where city='Shelburne' && SIC_code='6531'DB:business_master_new
loadtime:0.72883701324463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon' limit 1
loadtime:0.72894501686096 / seconds
Query Executed:select id FROM `vt` where city='Sheldon' && SIC_code='6531'DB:business_master_new
loadtime:0.72986602783203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon Springs' limit 1
loadtime:0.72993516921997 / seconds
Query Executed:select id FROM `vt` where city='Sheldon Springs' && SIC_code='6531'DB:business_master_new
loadtime:0.73051905632019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shoreham' limit 1
loadtime:0.73058009147644 / seconds
Query Executed:select id FROM `vt` where city='Shoreham' && SIC_code='6531'DB:business_master_new
loadtime:0.73949408531189 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Barre' limit 1
loadtime:0.73957419395447 / seconds
Query Executed:select id FROM `vt` where city='South Barre' && SIC_code='6531'DB:business_master_new
loadtime:0.74046206474304 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Burlington' limit 1
loadtime:0.74054598808289 / seconds
Query Executed:select id FROM `vt` where city='South Burlington' && SIC_code='6531'DB:business_master_new
loadtime:0.75673913955688 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hero' limit 1
loadtime:0.75691199302673 / seconds
Query Executed:select id FROM `vt` where city='South Hero' && SIC_code='6531'DB:business_master_new
loadtime:0.75944113731384 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Londonderry' limit 1
loadtime:0.75953507423401 / seconds
Query Executed:select id FROM `vt` where city='South Londonderry' && SIC_code='6531'DB:business_master_new
loadtime:0.76840806007385 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Newfane' limit 1
loadtime:0.76848697662354 / seconds
Query Executed:select id FROM `vt` where city='South Newfane' && SIC_code='6531'DB:business_master_new
loadtime:0.76902198791504 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Pomfret' limit 1
loadtime:0.76908898353577 / seconds
Query Executed:select id FROM `vt` where city='South Pomfret' && SIC_code='6531'DB:business_master_new
loadtime:0.76975512504578 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Royalton' limit 1
loadtime:0.76982498168945 / seconds
Query Executed:select id FROM `vt` where city='South Royalton' && SIC_code='6531'DB:business_master_new
loadtime:0.77248120307922 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Ryegate' limit 1
loadtime:0.77256608009338 / seconds
Query Executed:select id FROM `vt` where city='South Ryegate' && SIC_code='6531'DB:business_master_new
loadtime:0.77325510978699 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Strafford' limit 1
loadtime:0.77333211898804 / seconds
Query Executed:select id FROM `vt` where city='South Strafford' && SIC_code='6531'DB:business_master_new
loadtime:0.77402901649475 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Woodstock' limit 1
loadtime:0.774090051651 / seconds
Query Executed:select id FROM `vt` where city='South Woodstock' && SIC_code='6531'DB:business_master_new
loadtime:0.7747700214386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.77484512329102 / seconds
Query Executed:select id FROM `vt` where city='Springfield' && SIC_code='6531'DB:business_master_new
loadtime:0.78180813789368 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Albans' limit 1
loadtime:0.78190612792969 / seconds
Query Executed:select id FROM `vt` where city='St Albans' && SIC_code='6531'DB:business_master_new
loadtime:0.78247404098511 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Albans Bay' limit 1
loadtime:0.782555103302 / seconds
Query Executed:select id FROM `vt` where city='St Albans Bay' && SIC_code='6531'DB:business_master_new
loadtime:0.78308320045471 / seconds
Query loaded from cache:select * from geodata_geocity where city='St George' limit 1
loadtime:0.78314518928528 / seconds
Query Executed:select id FROM `vt` where city='St George' && SIC_code='6531'DB:business_master_new
loadtime:0.78359198570251 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johnsbury' limit 1
loadtime:0.78365421295166 / seconds
Query Executed:select id FROM `vt` where city='St Johnsbury' && SIC_code='6531'DB:business_master_new
loadtime:0.78452801704407 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johnsbury Ctr' limit 1
loadtime:0.784588098526 / seconds
Query Executed:select id FROM `vt` where city='St Johnsbury Ctr' && SIC_code='6531'DB:business_master_new
loadtime:0.78498315811157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stamford' limit 1
loadtime:0.78504300117493 / seconds
Query Executed:select id FROM `vt` where city='Stamford' && SIC_code='6531'DB:business_master_new
loadtime:0.78569006919861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Starksboro' limit 1
loadtime:0.78578114509583 / seconds
Query Executed:select id FROM `vt` where city='Starksboro' && SIC_code='6531'DB:business_master_new
loadtime:0.79445815086365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockbridge' limit 1
loadtime:0.79453420639038 / seconds
Query Executed:select id FROM `vt` where city='Stockbridge' && SIC_code='6531'DB:business_master_new
loadtime:0.79522609710693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stowe' limit 1
loadtime:0.79530620574951 / seconds
Query Executed:select id FROM `vt` where city='Stowe' && SIC_code='6531'DB:business_master_new
loadtime:0.80300307273865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strafford' limit 1
loadtime:0.80313920974731 / seconds
Query Executed:select id FROM `vt` where city='Strafford' && SIC_code='6531'DB:business_master_new
loadtime:0.80379509925842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutton' limit 1
loadtime:0.80387401580811 / seconds
Query Executed:select id FROM `vt` where city='Sutton' && SIC_code='6531'DB:business_master_new
loadtime:0.80452704429626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swanton' limit 1
loadtime:0.80459713935852 / seconds
Query Executed:select id FROM `vt` where city='Swanton' && SIC_code='6531'DB:business_master_new
loadtime:0.80930614471436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taftsville' limit 1
loadtime:0.8093900680542 / seconds
Query Executed:select id FROM `vt` where city='Taftsville' && SIC_code='6531'DB:business_master_new
loadtime:0.80995011329651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thetford' limit 1
loadtime:0.8100152015686 / seconds
Query Executed:select id FROM `vt` where city='Thetford' && SIC_code='6531'DB:business_master_new
loadtime:0.810791015625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thetford Center' limit 1
loadtime:0.81087207794189 / seconds
Query Executed:select id FROM `vt` where city='Thetford Center' && SIC_code='6531'DB:business_master_new
loadtime:0.81175398826599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topsham' limit 1
loadtime:0.81184315681458 / seconds
Query Executed:select id FROM `vt` where city='Topsham' && SIC_code='6531'DB:business_master_new
loadtime:0.81232619285583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townshend' limit 1
loadtime:0.81239414215088 / seconds
Query Executed:select id FROM `vt` where city='Townshend' && SIC_code='6531'DB:business_master_new
loadtime:0.81444716453552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:0.81452298164368 / seconds
Query Executed:select id FROM `vt` where city='Troy' && SIC_code='6531'DB:business_master_new
loadtime:0.81524705886841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tunbridge' limit 1
loadtime:0.81532406806946 / seconds
Query Executed:select id FROM `vt` where city='Tunbridge' && SIC_code='6531'DB:business_master_new
loadtime:0.81624507904053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Underhill' limit 1
loadtime:0.81631112098694 / seconds
Query Executed:select id FROM `vt` where city='Underhill' && SIC_code='6531'DB:business_master_new
loadtime:0.81852197647095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Underhill Center' limit 1
loadtime:0.81860208511353 / seconds
Query Executed:select id FROM `vt` where city='Underhill Center' && SIC_code='6531'DB:business_master_new
loadtime:0.81922507286072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vergennes' limit 1
loadtime:0.81928706169128 / seconds
Query Executed:select id FROM `vt` where city='Vergennes' && SIC_code='6531'DB:business_master_new
loadtime:0.82393312454224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:0.82404899597168 / seconds
Query Executed:select id FROM `vt` where city='Vernon' && SIC_code='6531'DB:business_master_new
loadtime:0.83305716514587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vershire' limit 1
loadtime:0.83313703536987 / seconds
Query Executed:select id FROM `vt` where city='Vershire' && SIC_code='6531'DB:business_master_new
loadtime:0.83373498916626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waitsfield' limit 1
loadtime:0.83380818367004 / seconds
Query Executed:select id FROM `vt` where city='Waitsfield' && SIC_code='6531'DB:business_master_new
loadtime:0.83926010131836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallingford' limit 1
loadtime:0.83935904502869 / seconds
Query Executed:select id FROM `vt` where city='Wallingford' && SIC_code='6531'DB:business_master_new
loadtime:0.84194612503052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wardsboro' limit 1
loadtime:0.84203004837036 / seconds
Query Executed:select id FROM `vt` where city='Wardsboro' && SIC_code='6531'DB:business_master_new
loadtime:0.84269213676453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:0.84275507926941 / seconds
Query Executed:select id FROM `vt` where city='Warren' && SIC_code='6531'DB:business_master_new
loadtime:0.84568500518799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.84578704833984 / seconds
Query Executed:select id FROM `vt` where city='Washington' && SIC_code='6531'DB:business_master_new
loadtime:0.8466420173645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury' limit 1
loadtime:0.84670615196228 / seconds
Query Executed:select id FROM `vt` where city='Waterbury' && SIC_code='6531'DB:business_master_new
loadtime:0.85221600532532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury Center' limit 1
loadtime:0.85229802131653 / seconds
Query Executed:select id FROM `vt` where city='Waterbury Center' && SIC_code='6531'DB:business_master_new
loadtime:0.85455918312073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville' limit 1
loadtime:0.85463905334473 / seconds
Query Executed:select id FROM `vt` where city='Waterville' && SIC_code='6531'DB:business_master_new
loadtime:0.85539412498474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Websterville' limit 1
loadtime:0.85545611381531 / seconds
Query Executed:select id FROM `vt` where city='Websterville' && SIC_code='6531'DB:business_master_new
loadtime:0.85604214668274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wells' limit 1
loadtime:0.85610318183899 / seconds
Query Executed:select id FROM `vt` where city='Wells' && SIC_code='6531'DB:business_master_new
loadtime:0.85692405700684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wells River' limit 1
loadtime:0.85700917243958 / seconds
Query Executed:select id FROM `vt` where city='Wells River' && SIC_code='6531'DB:business_master_new
loadtime:0.86587405204773 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Burke' limit 1
loadtime:0.86596608161926 / seconds
Query Executed:select id FROM `vt` where city='West Burke' && SIC_code='6531'DB:business_master_new
loadtime:0.87442708015442 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Charleston' limit 1
loadtime:0.87450408935547 / seconds
Query Executed:select id FROM `vt` where city='West Charleston' && SIC_code='6531'DB:business_master_new
loadtime:0.87515211105347 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Danville' limit 1
loadtime:0.87521409988403 / seconds
Query Executed:select id FROM `vt` where city='West Danville' && SIC_code='6531'DB:business_master_new
loadtime:0.87598299980164 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dover' limit 1
loadtime:0.87605810165405 / seconds
Query Executed:select id FROM `vt` where city='West Dover' && SIC_code='6531'DB:business_master_new
loadtime:0.87912917137146 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dummerston' limit 1
loadtime:0.87924003601074 / seconds
Query Executed:select id FROM `vt` where city='West Dummerston' && SIC_code='6531'DB:business_master_new
loadtime:0.87974119186401 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Fairlee' limit 1
loadtime:0.87982106208801 / seconds
Query Executed:select id FROM `vt` where city='West Fairlee' && SIC_code='6531'DB:business_master_new
loadtime:0.88045310974121 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Glover' limit 1
loadtime:0.88051414489746 / seconds
Query Executed:select id FROM `vt` where city='West Glover' && SIC_code='6531'DB:business_master_new
loadtime:0.88094902038574 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Halifax' limit 1
loadtime:0.88101315498352 / seconds
Query Executed:select id FROM `vt` where city='West Halifax' && SIC_code='6531'DB:business_master_new
loadtime:0.88158702850342 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartford' limit 1
loadtime:0.88164806365967 / seconds
Query Executed:select id FROM `vt` where city='West Hartford' && SIC_code='6531'DB:business_master_new
loadtime:0.88223004341125 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Marlboro' limit 1
loadtime:0.88229203224182 / seconds
Query Executed:select id FROM `vt` where city='West Marlboro' && SIC_code='6531'DB:business_master_new
loadtime:0.88273000717163 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newbury' limit 1
loadtime:0.88279914855957 / seconds
Query Executed:select id FROM `vt` where city='West Newbury' && SIC_code='6531'DB:business_master_new
loadtime:0.88334012031555 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Pawlet' limit 1
loadtime:0.8834011554718 / seconds
Query Executed:select id FROM `vt` where city='West Pawlet' && SIC_code='6531'DB:business_master_new
loadtime:0.88415098190308 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Rupert' limit 1
loadtime:0.8842179775238 / seconds
Query Executed:select id FROM `vt` where city='West Rupert' && SIC_code='6531'DB:business_master_new
loadtime:0.88475108146667 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Rutland' limit 1
loadtime:0.88482308387756 / seconds
Query Executed:select id FROM `vt` where city='West Rutland' && SIC_code='6531'DB:business_master_new
loadtime:0.8875470161438 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Topsham' limit 1
loadtime:0.88762617111206 / seconds
Query Executed:select id FROM `vt` where city='West Topsham' && SIC_code='6531'DB:business_master_new
loadtime:0.88822913169861 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Townshend' limit 1
loadtime:0.88829612731934 / seconds
Query Executed:select id FROM `vt` where city='West Townshend' && SIC_code='6531'DB:business_master_new
loadtime:0.88890218734741 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Wardsboro' limit 1
loadtime:0.88896799087524 / seconds
Query Executed:select id FROM `vt` where city='West Wardsboro' && SIC_code='6531'DB:business_master_new
loadtime:0.88962912559509 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Windsor' limit 1
loadtime:0.88971018791199 / seconds
Query Executed:select id FROM `vt` where city='West Windsor' && SIC_code='6531'DB:business_master_new
loadtime:0.89014601707458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:0.89021015167236 / seconds
Query Executed:select id FROM `vt` where city='Westfield' && SIC_code='6531'DB:business_master_new
loadtime:0.89091300964355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westford' limit 1
loadtime:0.89098119735718 / seconds
Query Executed:select id FROM `vt` where city='Westford' && SIC_code='6531'DB:business_master_new
loadtime:0.89968109130859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:0.89976716041565 / seconds
Query Executed:select id FROM `vt` where city='Westminster' && SIC_code='6531'DB:business_master_new
loadtime:0.90839314460754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster Sta' limit 1
loadtime:0.90846920013428 / seconds
Query Executed:select id FROM `vt` where city='Westminster Sta' && SIC_code='6531'DB:business_master_new
loadtime:0.9088990688324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster Station' limit 1
loadtime:0.90897011756897 / seconds
Query Executed:select id FROM `vt` where city='Westminster Station' && SIC_code='6531'DB:business_master_new
loadtime:0.90957903862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:0.90964102745056 / seconds
Query Executed:select id FROM `vt` where city='Weston' && SIC_code='6531'DB:business_master_new
loadtime:0.91810011863708 / seconds
Query loaded from cache:select * from geodata_geocity where city='White River Jct' limit 1
loadtime:0.9181821346283 / seconds
Query Executed:select id FROM `vt` where city='White River Jct' && SIC_code='6531'DB:business_master_new
loadtime:0.91868901252747 / seconds
Query loaded from cache:select * from geodata_geocity where city='White River Junction' limit 1
loadtime:0.91877508163452 / seconds
Query Executed:select id FROM `vt` where city='White River Junction' && SIC_code='6531'DB:business_master_new
loadtime:0.92607998847961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiting' limit 1
loadtime:0.92617201805115 / seconds
Query Executed:select id FROM `vt` where city='Whiting' && SIC_code='6531'DB:business_master_new
loadtime:0.9268970489502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitingham' limit 1
loadtime:0.92696809768677 / seconds
Query Executed:select id FROM `vt` where city='Whitingham' && SIC_code='6531'DB:business_master_new
loadtime:0.9277172088623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilder' limit 1
loadtime:0.92779517173767 / seconds
Query Executed:select id FROM `vt` where city='Wilder' && SIC_code='6531'DB:business_master_new
loadtime:0.93669700622559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamstown' limit 1
loadtime:0.93678307533264 / seconds
Query Executed:select id FROM `vt` where city='Williamstown' && SIC_code='6531'DB:business_master_new
loadtime:0.93927001953125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsville' limit 1
loadtime:0.93934917449951 / seconds
Query Executed:select id FROM `vt` where city='Williamsville' && SIC_code='6531'DB:business_master_new
loadtime:0.94005012512207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williston' limit 1
loadtime:0.9401261806488 / seconds
Query Executed:select id FROM `vt` where city='Williston' && SIC_code='6531'DB:business_master_new
loadtime:0.95166206359863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmington' limit 1
loadtime:0.95177817344666 / seconds
Query Executed:select id FROM `vt` where city='Wilmington' && SIC_code='6531'DB:business_master_new
loadtime:0.95565819740295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:0.95575499534607 / seconds
Query Executed:select id FROM `vt` where city='Windsor' && SIC_code='6531'DB:business_master_new
loadtime:0.95955014228821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winooski' limit 1
loadtime:0.95964312553406 / seconds
Query Executed:select id FROM `vt` where city='Winooski' && SIC_code='6531'DB:business_master_new
loadtime:0.96389698982239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolcott' limit 1
loadtime:0.96399402618408 / seconds
Query Executed:select id FROM `vt` where city='Wolcott' && SIC_code='6531'DB:business_master_new
loadtime:0.97291898727417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbury' limit 1
loadtime:0.97300100326538 / seconds
Query Executed:select id FROM `vt` where city='Woodbury' && SIC_code='6531'DB:business_master_new
loadtime:0.97359919548035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:0.97366118431091 / seconds
Query Executed:select id FROM `vt` where city='Woodstock' && SIC_code='6531'DB:business_master_new
loadtime:0.97941303253174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worcester' limit 1
loadtime:0.97951912879944 / seconds
Query Executed:select id FROM `vt` where city='Worcester' && SIC_code='6531'DB:business_master_new
loadtime:0.98031616210938 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.98047304153442 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.98088908195496 / seconds
Operation template executed (chunk cache operation)
loadtime:0.98106598854065 / seconds
template override:Default
loadtime:0.98110914230347 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:0.98276901245117 / seconds
Template Constructed, Array Rows:49
loadtime:0.98329901695251 / seconds
TOTAL EXECUTION TIME: 0.98286
loadtime:0.98519420623779 / 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] => real-estate-agents-and-managers [stateURLid] => vermont )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:0.98520517349243
TOTAL KEY ARRAYS: 69