Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:5.793571472168E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0017449855804443 / seconds
host not found setting manual db connection
loadtime:0.0094339847564697 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0096879005432129 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.009835958480835 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0098960399627686 / seconds
zipcode:
loadtime:0.0099248886108398 / seconds
Query Executed:select * from search_referrer where page_hash='8ee27898addeed47396338512047049c' limit 10 DB:ezrox_toadli
loadtime:0.01016092300415 / seconds
Operation header executed (non global)
loadtime:0.010189056396484 / seconds
Operation leaderboard executed (non global)
loadtime:0.010240077972412 / seconds
Operation square executed (non global)
loadtime:0.0102698802948 / seconds
Operation square_bottom executed (non global)
loadtime:0.010297060012817 / seconds
Operation smallsquare executed (non global)
loadtime:0.010323047637939 / seconds
Operation headeradright executed (non global)
loadtime:0.010348081588745 / seconds
Operation google_analytics executed (non global)
loadtime:0.010372877120972 / seconds
Operation topstories executed (non global)
loadtime:0.010397911071777 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010423898696899 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010448932647705 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010696887969971 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.010869979858398 / seconds
Operation categories executed (global stored into APC)
loadtime:0.01091194152832 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.01098108291626 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.01103401184082 / seconds
Template key: archive_menu pushed
loadtime:0.011043071746826 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011056900024414 / seconds
Template key: get_gravatar pushed
loadtime:0.011063098907471 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011072874069214 / seconds
*10)-10)+1 | start:0
loadtime:0.011112928390503 / seconds
Query loaded from cache:select * from categories where cat_URLid='retail-bakeries'
loadtime:0.011152029037476 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='vermont'
loadtime:0.01118803024292 / seconds
DB connected to localhost business_master_new
loadtime:0.011422872543335 / seconds
Query Executed:select * from `vt_catmap` where sic='5461' order by city ascDB:business_master_new
loadtime:0.1570360660553 / seconds
Query stored in cache : _QUERY_www.toadli.com39a64f56d6a0fc11d66b84694861b10e
loadtime:0.15832591056824 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='vermont'
loadtime:0.15838003158569 / seconds
Query Executed:select sum(totalcount) as totalsum from `vt_catmap` where sic='5461'DB:business_master_new
loadtime:0.16032600402832 / seconds
Query stored in cache : _QUERY_www.toadli.coma3fba03b13645b78792ff84c9cfdd114
loadtime:0.16036605834961 / seconds
321 / 11
loadtime:0.16042304039001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adamant' limit 1
loadtime:0.16049098968506 / seconds
Query Executed:select id FROM `vt` where city='Adamant' && SIC_code='5461'DB:business_master_new
loadtime:0.16845393180847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albany' limit 1
loadtime:0.16851687431335 / seconds
Query Executed:select id FROM `vt` where city='Albany' && SIC_code='5461'DB:business_master_new
loadtime:0.16917991638184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alburg' limit 1
loadtime:0.16924095153809 / seconds
Query Executed:select id FROM `vt` where city='Alburg' && SIC_code='5461'DB:business_master_new
loadtime:0.16968894004822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.16975498199463 / seconds
Query Executed:select id FROM `vt` where city='Arlington' && SIC_code='5461'DB:business_master_new
loadtime:0.17216396331787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ascutney' limit 1
loadtime:0.17224192619324 / seconds
Query Executed:select id FROM `vt` where city='Ascutney' && SIC_code='5461'DB:business_master_new
loadtime:0.17337107658386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athens' limit 1
loadtime:0.17343306541443 / seconds
Query Executed:select id FROM `vt` where city='Athens' && SIC_code='5461'DB:business_master_new
loadtime:0.17386102676392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Averill' limit 1
loadtime:0.17392086982727 / seconds
Query Executed:select id FROM `vt` where city='Averill' && SIC_code='5461'DB:business_master_new
loadtime:0.17438006401062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bakersfield' limit 1
loadtime:0.17444610595703 / seconds
Query Executed:select id FROM `vt` where city='Bakersfield' && SIC_code='5461'DB:business_master_new
loadtime:0.17510294914246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnard' limit 1
loadtime:0.17516493797302 / seconds
Query Executed:select id FROM `vt` where city='Barnard' && SIC_code='5461'DB:business_master_new
loadtime:0.17592906951904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnet' limit 1
loadtime:0.17601490020752 / seconds
Query Executed:select id FROM `vt` where city='Barnet' && SIC_code='5461'DB:business_master_new
loadtime:0.1771879196167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barre' limit 1
loadtime:0.17725610733032 / seconds
Query Executed:select id FROM `vt` where city='Barre' && SIC_code='5461'DB:business_master_new
loadtime:0.17919087409973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barton' limit 1
loadtime:0.17927098274231 / seconds
Query Executed:select id FROM `vt` where city='Barton' && SIC_code='5461'DB:business_master_new
loadtime:0.18123507499695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beebe Plain' limit 1
loadtime:0.18129801750183 / seconds
Query Executed:select id FROM `vt` where city='Beebe Plain' && SIC_code='5461'DB:business_master_new
loadtime:0.18177103996277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beecher Falls' limit 1
loadtime:0.18183994293213 / seconds
Query Executed:select id FROM `vt` where city='Beecher Falls' && SIC_code='5461'DB:business_master_new
loadtime:0.18237400054932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellows Falls' limit 1
loadtime:0.18243408203125 / seconds
Query Executed:select id FROM `vt` where city='Bellows Falls' && SIC_code='5461'DB:business_master_new
loadtime:0.18429493904114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.18437004089355 / seconds
Query Executed:select id FROM `vt` where city='Belmont' && SIC_code='5461'DB:business_master_new
loadtime:0.18502902984619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvidere Center' limit 1
loadtime:0.18509101867676 / seconds
Query Executed:select id FROM `vt` where city='Belvidere Center' && SIC_code='5461'DB:business_master_new
loadtime:0.18552589416504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennington' limit 1
loadtime:0.18558788299561 / seconds
Query Executed:select id FROM `vt` where city='Bennington' && SIC_code='5461'DB:business_master_new
loadtime:0.18742704391479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benson' limit 1
loadtime:0.18750905990601 / seconds
Query Executed:select id FROM `vt` where city='Benson' && SIC_code='5461'DB:business_master_new
loadtime:0.18809008598328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.18815207481384 / seconds
Query Executed:select id FROM `vt` where city='Berlin' && SIC_code='5461'DB:business_master_new
loadtime:0.18874192237854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethel' limit 1
loadtime:0.18882203102112 / seconds
Query Executed:select id FROM `vt` where city='Bethel' && SIC_code='5461'DB:business_master_new
loadtime:0.19086289405823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton Valley' limit 1
loadtime:0.19092607498169 / seconds
Query Executed:select id FROM `vt` where city='Bolton Valley' && SIC_code='5461'DB:business_master_new
loadtime:0.1913959980011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bomoseen' limit 1
loadtime:0.19145703315735 / seconds
Query Executed:select id FROM `vt` where city='Bomoseen' && SIC_code='5461'DB:business_master_new
loadtime:0.19269609451294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bondville' limit 1
loadtime:0.19275903701782 / seconds
Query Executed:select id FROM `vt` where city='Bondville' && SIC_code='5461'DB:business_master_new
loadtime:0.19398403167725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.19404602050781 / seconds
Query Executed:select id FROM `vt` where city='Bradford' && SIC_code='5461'DB:business_master_new
loadtime:0.19673705101013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.19681596755981 / seconds
Query Executed:select id FROM `vt` where city='Brandon' && SIC_code='5461'DB:business_master_new
loadtime:0.19866394996643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brattleboro' limit 1
loadtime:0.19874000549316 / seconds
Query Executed:select id FROM `vt` where city='Brattleboro' && SIC_code='5461'DB:business_master_new
loadtime:0.20067501068115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.20076107978821 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater' && SIC_code='5461'DB:business_master_new
loadtime:0.20187306404114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater Corners' limit 1
loadtime:0.20196509361267 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater Corners' && SIC_code='5461'DB:business_master_new
loadtime:0.20275187492371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater Cors' limit 1
loadtime:0.20281791687012 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater Cors' && SIC_code='5461'DB:business_master_new
loadtime:0.20322299003601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridport' limit 1
loadtime:0.20328593254089 / seconds
Query Executed:select id FROM `vt` where city='Bridport' && SIC_code='5461'DB:business_master_new
loadtime:0.20454907417297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.20461106300354 / seconds
Query Executed:select id FROM `vt` where city='Bristol' && SIC_code='5461'DB:business_master_new
loadtime:0.20645499229431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.20653200149536 / seconds
Query Executed:select id FROM `vt` where city='Brookfield' && SIC_code='5461'DB:business_master_new
loadtime:0.20755791664124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline' limit 1
loadtime:0.2076210975647 / seconds
Query Executed:select id FROM `vt` where city='Brookline' && SIC_code='5461'DB:business_master_new
loadtime:0.20806288719177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownsville' limit 1
loadtime:0.20812296867371 / seconds
Query Executed:select id FROM `vt` where city='Brownsville' && SIC_code='5461'DB:business_master_new
loadtime:0.20900106430054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.20906209945679 / seconds
Query Executed:select id FROM `vt` where city='Burlington' && SIC_code='5461'DB:business_master_new
loadtime:0.21089887619019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cabot' limit 1
loadtime:0.2110059261322 / seconds
Query Executed:select id FROM `vt` where city='Cabot' && SIC_code='5461'DB:business_master_new
loadtime:0.21207094192505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calais' limit 1
loadtime:0.21214008331299 / seconds
Query Executed:select id FROM `vt` where city='Calais' && SIC_code='5461'DB:business_master_new
loadtime:0.21273303031921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:0.21280002593994 / seconds
Query Executed:select id FROM `vt` where city='Cambridge' && SIC_code='5461'DB:business_master_new
loadtime:0.21429204940796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridgeport' limit 1
loadtime:0.21435499191284 / seconds
Query Executed:select id FROM `vt` where city='Cambridgeport' && SIC_code='5461'DB:business_master_new
loadtime:0.21487188339233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canaan' limit 1
loadtime:0.21493291854858 / seconds
Query Executed:select id FROM `vt` where city='Canaan' && SIC_code='5461'DB:business_master_new
loadtime:0.21578288078308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castleton' limit 1
loadtime:0.21585893630981 / seconds
Query Executed:select id FROM `vt` where city='Castleton' && SIC_code='5461'DB:business_master_new
loadtime:0.21791505813599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cavendish' limit 1
loadtime:0.21798896789551 / seconds
Query Executed:select id FROM `vt` where city='Cavendish' && SIC_code='5461'DB:business_master_new
loadtime:0.21908807754517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Rutland' limit 1
loadtime:0.21916389465332 / seconds
Query Executed:select id FROM `vt` where city='Center Rutland' && SIC_code='5461'DB:business_master_new
loadtime:0.22020602226257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte' limit 1
loadtime:0.22026896476746 / seconds
Query Executed:select id FROM `vt` where city='Charlotte' && SIC_code='5461'DB:business_master_new
loadtime:0.22277593612671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.22284293174744 / seconds
Query Executed:select id FROM `vt` where city='Chelsea' && SIC_code='5461'DB:business_master_new
loadtime:0.22450590133667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.2245819568634 / seconds
Query Executed:select id FROM `vt` where city='Chester' && SIC_code='5461'DB:business_master_new
loadtime:0.22644710540771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chittenden' limit 1
loadtime:0.22652792930603 / seconds
Query Executed:select id FROM `vt` where city='Chittenden' && SIC_code='5461'DB:business_master_new
loadtime:0.22731590270996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colchester' limit 1
loadtime:0.22737789154053 / seconds
Query Executed:select id FROM `vt` where city='Colchester' && SIC_code='5461'DB:business_master_new
loadtime:0.22927093505859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.2293529510498 / seconds
Query Executed:select id FROM `vt` where city='Concord' && SIC_code='5461'DB:business_master_new
loadtime:0.23029589653015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corinth' limit 1
loadtime:0.23035788536072 / seconds
Query Executed:select id FROM `vt` where city='Corinth' && SIC_code='5461'DB:business_master_new
loadtime:0.23107290267944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coventry' limit 1
loadtime:0.23113393783569 / seconds
Query Executed:select id FROM `vt` where city='Coventry' && SIC_code='5461'DB:business_master_new
loadtime:0.23167490959167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury' limit 1
loadtime:0.2317430973053 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury' && SIC_code='5461'DB:business_master_new
loadtime:0.23250603675842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury Cmn' limit 1
loadtime:0.23256587982178 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury Cmn' && SIC_code='5461'DB:business_master_new
loadtime:0.23299908638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury Common' limit 1
loadtime:0.2330629825592 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury Common' && SIC_code='5461'DB:business_master_new
loadtime:0.23375487327576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuttingsville' limit 1
loadtime:0.23381996154785 / seconds
Query Executed:select id FROM `vt` where city='Cuttingsville' && SIC_code='5461'DB:business_master_new
loadtime:0.23504400253296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danby' limit 1
loadtime:0.23510599136353 / seconds
Query Executed:select id FROM `vt` where city='Danby' && SIC_code='5461'DB:business_master_new
loadtime:0.23649001121521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.23655200004578 / seconds
Query Executed:select id FROM `vt` where city='Danville' && SIC_code='5461'DB:business_master_new
loadtime:0.23827791213989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby' limit 1
loadtime:0.23833990097046 / seconds
Query Executed:select id FROM `vt` where city='Derby' && SIC_code='5461'DB:business_master_new
loadtime:0.24058198928833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby Line' limit 1
loadtime:0.24064493179321 / seconds
Query Executed:select id FROM `vt` where city='Derby Line' && SIC_code='5461'DB:business_master_new
loadtime:0.24197793006897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorset' limit 1
loadtime:0.24203991889954 / seconds
Query Executed:select id FROM `vt` where city='Dorset' && SIC_code='5461'DB:business_master_new
loadtime:0.24399495124817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dummerston' limit 1
loadtime:0.24407196044922 / seconds
Query Executed:select id FROM `vt` where city='Dummerston' && SIC_code='5461'DB:business_master_new
loadtime:0.24447298049927 / seconds
Query loaded from cache:select * from geodata_geocity where city='E St Johnsbury' limit 1
loadtime:0.24453401565552 / seconds
Query Executed:select id FROM `vt` where city='E St Johnsbury' && SIC_code='5461'DB:business_master_new
loadtime:0.24493193626404 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Arlington' limit 1
loadtime:0.24500393867493 / seconds
Query Executed:select id FROM `vt` where city='East Arlington' && SIC_code='5461'DB:business_master_new
loadtime:0.24565505981445 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Barre' limit 1
loadtime:0.24571704864502 / seconds
Query Executed:select id FROM `vt` where city='East Barre' && SIC_code='5461'DB:business_master_new
loadtime:0.24671602249146 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Berkshire' limit 1
loadtime:0.24680399894714 / seconds
Query Executed:select id FROM `vt` where city='East Berkshire' && SIC_code='5461'DB:business_master_new
loadtime:0.24734997749329 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Burke' limit 1
loadtime:0.24741196632385 / seconds
Query Executed:select id FROM `vt` where city='East Burke' && SIC_code='5461'DB:business_master_new
loadtime:0.24844098091125 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Calais' limit 1
loadtime:0.24851703643799 / seconds
Query Executed:select id FROM `vt` where city='East Calais' && SIC_code='5461'DB:business_master_new
loadtime:0.2491569519043 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Charleston' limit 1
loadtime:0.24921989440918 / seconds
Query Executed:select id FROM `vt` where city='East Charleston' && SIC_code='5461'DB:business_master_new
loadtime:0.24970507621765 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Corinth' limit 1
loadtime:0.24977993965149 / seconds
Query Executed:select id FROM `vt` where city='East Corinth' && SIC_code='5461'DB:business_master_new
loadtime:0.25047397613525 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dorset' limit 1
loadtime:0.25053596496582 / seconds
Query Executed:select id FROM `vt` where city='East Dorset' && SIC_code='5461'DB:business_master_new
loadtime:0.25153303146362 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dover' limit 1
loadtime:0.25159502029419 / seconds
Query Executed:select id FROM `vt` where city='East Dover' && SIC_code='5461'DB:business_master_new
loadtime:0.25230598449707 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dummerston' limit 1
loadtime:0.25236797332764 / seconds
Query Executed:select id FROM `vt` where city='East Dummerston' && SIC_code='5461'DB:business_master_new
loadtime:0.2527379989624 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Fairfield' limit 1
loadtime:0.25280404090881 / seconds
Query Executed:select id FROM `vt` where city='East Fairfield' && SIC_code='5461'DB:business_master_new
loadtime:0.25346803665161 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hardwick' limit 1
loadtime:0.25353002548218 / seconds
Query Executed:select id FROM `vt` where city='East Hardwick' && SIC_code='5461'DB:business_master_new
loadtime:0.25446796417236 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Haven' limit 1
loadtime:0.25453090667725 / seconds
Query Executed:select id FROM `vt` where city='East Haven' && SIC_code='5461'DB:business_master_new
loadtime:0.25504994392395 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Middlebury' limit 1
loadtime:0.2551109790802 / seconds
Query Executed:select id FROM `vt` where city='East Middlebury' && SIC_code='5461'DB:business_master_new
loadtime:0.25585103034973 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Montpelier' limit 1
loadtime:0.25591087341309 / seconds
Query Executed:select id FROM `vt` where city='East Montpelier' && SIC_code='5461'DB:business_master_new
loadtime:0.25759291648865 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Orange' limit 1
loadtime:0.25765490531921 / seconds
Query Executed:select id FROM `vt` where city='East Orange' && SIC_code='5461'DB:business_master_new
loadtime:0.25808000564575 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Poultney' limit 1
loadtime:0.25814008712769 / seconds
Query Executed:select id FROM `vt` where city='East Poultney' && SIC_code='5461'DB:business_master_new
loadtime:0.25860595703125 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Randolph' limit 1
loadtime:0.2586669921875 / seconds
Query Executed:select id FROM `vt` where city='East Randolph' && SIC_code='5461'DB:business_master_new
loadtime:0.25919389724731 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Ryegate' limit 1
loadtime:0.25925493240356 / seconds
Query Executed:select id FROM `vt` where city='East Ryegate' && SIC_code='5461'DB:business_master_new
loadtime:0.25989389419556 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Saint Johnsbury' limit 1
loadtime:0.25996398925781 / seconds
Query Executed:select id FROM `vt` where city='East Saint Johnsbury' && SIC_code='5461'DB:business_master_new
loadtime:0.26045203208923 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Thetford' limit 1
loadtime:0.26051306724548 / seconds
Query Executed:select id FROM `vt` where city='East Thetford' && SIC_code='5461'DB:business_master_new
loadtime:0.26158690452576 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Wallingford' limit 1
loadtime:0.26165008544922 / seconds
Query Executed:select id FROM `vt` where city='East Wallingford' && SIC_code='5461'DB:business_master_new
loadtime:0.26222896575928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.26229000091553 / seconds
Query Executed:select id FROM `vt` where city='Eden' && SIC_code='5461'DB:business_master_new
loadtime:0.26291108131409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden Mills' limit 1
loadtime:0.26298308372498 / seconds
Query Executed:select id FROM `vt` where city='Eden Mills' && SIC_code='5461'DB:business_master_new
loadtime:0.26347899436951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enosburg Falls' limit 1
loadtime:0.26354098320007 / seconds
Query Executed:select id FROM `vt` where city='Enosburg Falls' && SIC_code='5461'DB:business_master_new
loadtime:0.26541495323181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.26547598838806 / seconds
Query Executed:select id FROM `vt` where city='Essex' && SIC_code='5461'DB:business_master_new
loadtime:0.2665810585022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex Junction' limit 1
loadtime:0.26664304733276 / seconds
Query Executed:select id FROM `vt` where city='Essex Junction' && SIC_code='5461'DB:business_master_new
loadtime:0.2685010433197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Haven' limit 1
loadtime:0.26858401298523 / seconds
Query Executed:select id FROM `vt` where city='Fair Haven' && SIC_code='5461'DB:business_master_new
loadtime:0.27125692367554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.271320104599 / seconds
Query Executed:select id FROM `vt` where city='Fairfax' && SIC_code='5461'DB:business_master_new
loadtime:0.27346110343933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.27354001998901 / seconds
Query Executed:select id FROM `vt` where city='Fairfield' && SIC_code='5461'DB:business_master_new
loadtime:0.2746160030365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairlee' limit 1
loadtime:0.27467799186707 / seconds
Query Executed:select id FROM `vt` where city='Fairlee' && SIC_code='5461'DB:business_master_new
loadtime:0.27646088600159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferrisburg' limit 1
loadtime:0.27652287483215 / seconds
Query Executed:select id FROM `vt` where city='Ferrisburg' && SIC_code='5461'DB:business_master_new
loadtime:0.27696394920349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.27702498435974 / seconds
Query Executed:select id FROM `vt` where city='Florence' && SIC_code='5461'DB:business_master_new
loadtime:0.27760195732117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest Dale' limit 1
loadtime:0.27766299247742 / seconds
Query Executed:select id FROM `vt` where city='Forest Dale' && SIC_code='5461'DB:business_master_new
loadtime:0.27814388275146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.27820587158203 / seconds
Query Executed:select id FROM `vt` where city='Franklin' && SIC_code='5461'DB:business_master_new
loadtime:0.27934098243713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaysville' limit 1
loadtime:0.2794029712677 / seconds
Query Executed:select id FROM `vt` where city='Gaysville' && SIC_code='5461'DB:business_master_new
loadtime:0.27990388870239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:0.27997589111328 / seconds
Query Executed:select id FROM `vt` where city='Gilman' && SIC_code='5461'DB:business_master_new
loadtime:0.28046298027039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glover' limit 1
loadtime:0.28052306175232 / seconds
Query Executed:select id FROM `vt` where city='Glover' && SIC_code='5461'DB:business_master_new
loadtime:0.28125405311584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.28131699562073 / seconds
Query Executed:select id FROM `vt` where city='Grafton' && SIC_code='5461'DB:business_master_new
loadtime:0.28245091438293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:0.2825129032135 / seconds
Query Executed:select id FROM `vt` where city='Granby' && SIC_code='5461'DB:business_master_new
loadtime:0.28296208381653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Isle' limit 1
loadtime:0.2830228805542 / seconds
Query Executed:select id FROM `vt` where city='Grand Isle' && SIC_code='5461'DB:business_master_new
loadtime:0.28444600105286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graniteville' limit 1
loadtime:0.28452205657959 / seconds
Query Executed:select id FROM `vt` where city='Graniteville' && SIC_code='5461'DB:business_master_new
loadtime:0.28528809547424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granville' limit 1
loadtime:0.28534889221191 / seconds
Query Executed:select id FROM `vt` where city='Granville' && SIC_code='5461'DB:business_master_new
loadtime:0.28591108322144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greensboro' limit 1
loadtime:0.28598308563232 / seconds
Query Executed:select id FROM `vt` where city='Greensboro' && SIC_code='5461'DB:business_master_new
loadtime:0.28669905662537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greensboro Bend' limit 1
loadtime:0.28675889968872 / seconds
Query Executed:select id FROM `vt` where city='Greensboro Bend' && SIC_code='5461'DB:business_master_new
loadtime:0.28733897209167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.28740191459656 / seconds
Query Executed:select id FROM `vt` where city='Groton' && SIC_code='5461'DB:business_master_new
loadtime:0.28857207298279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guildhall' limit 1
loadtime:0.28864789009094 / seconds
Query Executed:select id FROM `vt` where city='Guildhall' && SIC_code='5461'DB:business_master_new
loadtime:0.28940296173096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guilford' limit 1
loadtime:0.28946399688721 / seconds
Query Executed:select id FROM `vt` where city='Guilford' && SIC_code='5461'DB:business_master_new
loadtime:0.28984689712524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:0.28990602493286 / seconds
Query Executed:select id FROM `vt` where city='Hancock' && SIC_code='5461'DB:business_master_new
loadtime:0.29056692123413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardwick' limit 1
loadtime:0.29062700271606 / seconds
Query Executed:select id FROM `vt` where city='Hardwick' && SIC_code='5461'DB:business_master_new
loadtime:0.29297399520874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.29305005073547 / seconds
Query Executed:select id FROM `vt` where city='Hartford' && SIC_code='5461'DB:business_master_new
loadtime:0.29429602622986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland' limit 1
loadtime:0.29435801506042 / seconds
Query Executed:select id FROM `vt` where city='Hartland' && SIC_code='5461'DB:business_master_new
loadtime:0.29605388641357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland 4 Cors' limit 1
loadtime:0.29611587524414 / seconds
Query Executed:select id FROM `vt` where city='Hartland 4 Cors' && SIC_code='5461'DB:business_master_new
loadtime:0.29651808738708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland Four Corners' limit 1
loadtime:0.29658102989197 / seconds
Query Executed:select id FROM `vt` where city='Hartland Four Corners' && SIC_code='5461'DB:business_master_new
loadtime:0.29707098007202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highgate Center' limit 1
loadtime:0.29713201522827 / seconds
Query Executed:select id FROM `vt` where city='Highgate Center' && SIC_code='5461'DB:business_master_new
loadtime:0.29845190048218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highgate Springs' limit 1
loadtime:0.29852795600891 / seconds
Query Executed:select id FROM `vt` where city='Highgate Springs' && SIC_code='5461'DB:business_master_new
loadtime:0.29917192459106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinesburg' limit 1
loadtime:0.29923391342163 / seconds
Query Executed:select id FROM `vt` where city='Hinesburg' && SIC_code='5461'DB:business_master_new
loadtime:0.30213403701782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington' limit 1
loadtime:0.30221104621887 / seconds
Query Executed:select id FROM `vt` where city='Huntington' && SIC_code='5461'DB:business_master_new
loadtime:0.30356407165527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyde Park' limit 1
loadtime:0.30362701416016 / seconds
Query Executed:select id FROM `vt` where city='Hyde Park' && SIC_code='5461'DB:business_master_new
loadtime:0.30551505088806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hydeville' limit 1
loadtime:0.3055899143219 / seconds
Query Executed:select id FROM `vt` where city='Hydeville' && SIC_code='5461'DB:business_master_new
loadtime:0.30621790885925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irasburg' limit 1
loadtime:0.30627989768982 / seconds
Query Executed:select id FROM `vt` where city='Irasburg' && SIC_code='5461'DB:business_master_new
loadtime:0.30744600296021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Island Pond' limit 1
loadtime:0.3075098991394 / seconds
Query Executed:select id FROM `vt` where city='Island Pond' && SIC_code='5461'DB:business_master_new
loadtime:0.30900597572327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isle La Motte' limit 1
loadtime:0.30906796455383 / seconds
Query Executed:select id FROM `vt` where city='Isle La Motte' && SIC_code='5461'DB:business_master_new
loadtime:0.30972194671631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jacksonville' limit 1
loadtime:0.30978393554688 / seconds
Query Executed:select id FROM `vt` where city='Jacksonville' && SIC_code='5461'DB:business_master_new
loadtime:0.31091594696045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica' limit 1
loadtime:0.31098890304565 / seconds
Query Executed:select id FROM `vt` where city='Jamaica' && SIC_code='5461'DB:business_master_new
loadtime:0.3121120929718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jay' limit 1
loadtime:0.31217288970947 / seconds
Query Executed:select id FROM `vt` where city='Jay' && SIC_code='5461'DB:business_master_new
loadtime:0.31258392333984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jeffersonville' limit 1
loadtime:0.31264400482178 / seconds
Query Executed:select id FROM `vt` where city='Jeffersonville' && SIC_code='5461'DB:business_master_new
loadtime:0.314532995224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jericho' limit 1
loadtime:0.31460905075073 / seconds
Query Executed:select id FROM `vt` where city='Jericho' && SIC_code='5461'DB:business_master_new
loadtime:0.31721806526184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jericho Center' limit 1
loadtime:0.31728100776672 / seconds
Query Executed:select id FROM `vt` where city='Jericho Center' && SIC_code='5461'DB:business_master_new
loadtime:0.31768488883972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnson' limit 1
loadtime:0.31774592399597 / seconds
Query Executed:select id FROM `vt` where city='Johnson' && SIC_code='5461'DB:business_master_new
loadtime:0.31992101669312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:0.32000994682312 / seconds
Query Executed:select id FROM `vt` where city='Jonesville' && SIC_code='5461'DB:business_master_new
loadtime:0.32050108909607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Killington' limit 1
loadtime:0.32056307792664 / seconds
Query Executed:select id FROM `vt` where city='Killington' && SIC_code='5461'DB:business_master_new
loadtime:0.3224458694458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Elmore' limit 1
loadtime:0.32252287864685 / seconds
Query Executed:select id FROM `vt` where city='Lake Elmore' && SIC_code='5461'DB:business_master_new
loadtime:0.32314896583557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemington' limit 1
loadtime:0.32321095466614 / seconds
Query Executed:select id FROM `vt` where city='Lemington' && SIC_code='5461'DB:business_master_new
loadtime:0.32365202903748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.32371187210083 / seconds
Query Executed:select id FROM `vt` where city='Lincoln' && SIC_code='5461'DB:business_master_new
loadtime:0.32415509223938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Londonderry' limit 1
loadtime:0.32421588897705 / seconds
Query Executed:select id FROM `vt` where city='Londonderry' && SIC_code='5461'DB:business_master_new
loadtime:0.32574391365051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:0.32582688331604 / seconds
Query Executed:select id FROM `vt` where city='Lowell' && SIC_code='5461'DB:business_master_new
loadtime:0.32656407356262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lower Waterford' limit 1
loadtime:0.32662606239319 / seconds
Query Executed:select id FROM `vt` where city='Lower Waterford' && SIC_code='5461'DB:business_master_new
loadtime:0.32720708847046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:0.32726788520813 / seconds
Query Executed:select id FROM `vt` where city='Ludlow' && SIC_code='5461'DB:business_master_new
loadtime:0.32932209968567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:0.32939887046814 / seconds
Query Executed:select id FROM `vt` where city='Lunenburg' && SIC_code='5461'DB:business_master_new
loadtime:0.33037495613098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndon' limit 1
loadtime:0.33043694496155 / seconds
Query Executed:select id FROM `vt` where city='Lyndon' && SIC_code='5461'DB:business_master_new
loadtime:0.33147287368774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndon Center' limit 1
loadtime:0.33153510093689 / seconds
Query Executed:select id FROM `vt` where city='Lyndon Center' && SIC_code='5461'DB:business_master_new
loadtime:0.33217096328735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndonville' limit 1
loadtime:0.3322319984436 / seconds
Query Executed:select id FROM `vt` where city='Lyndonville' && SIC_code='5461'DB:business_master_new
loadtime:0.3340950012207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.33416891098022 / seconds
Query Executed:select id FROM `vt` where city='Manchester' && SIC_code='5461'DB:business_master_new
loadtime:0.33663988113403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester Center' limit 1
loadtime:0.33671903610229 / seconds
Query Executed:select id FROM `vt` where city='Manchester Center' && SIC_code='5461'DB:business_master_new
loadtime:0.33860301971436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester Ctr' limit 1
loadtime:0.33868503570557 / seconds
Query Executed:select id FROM `vt` where city='Manchester Ctr' && SIC_code='5461'DB:business_master_new
loadtime:0.33912801742554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlboro' limit 1
loadtime:0.33919095993042 / seconds
Query Executed:select id FROM `vt` where city='Marlboro' && SIC_code='5461'DB:business_master_new
loadtime:0.34015393257141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield' limit 1
loadtime:0.34021592140198 / seconds
Query Executed:select id FROM `vt` where city='Marshfield' && SIC_code='5461'DB:business_master_new
loadtime:0.34152603149414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Indoe Falls' limit 1
loadtime:0.34160494804382 / seconds
Query Executed:select id FROM `vt` where city='Mc Indoe Falls' && SIC_code='5461'DB:business_master_new
loadtime:0.34213995933533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebury' limit 1
loadtime:0.34220099449158 / seconds
Query Executed:select id FROM `vt` where city='Middlebury' && SIC_code='5461'DB:business_master_new
loadtime:0.34407210350037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown Spgs' limit 1
loadtime:0.34414887428284 / seconds
Query Executed:select id FROM `vt` where city='Middletown Spgs' && SIC_code='5461'DB:business_master_new
loadtime:0.34457206726074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown Springs' limit 1
loadtime:0.34463405609131 / seconds
Query Executed:select id FROM `vt` where city='Middletown Springs' && SIC_code='5461'DB:business_master_new
loadtime:0.34570693969727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:0.34576797485352 / seconds
Query Executed:select id FROM `vt` where city='Milton' && SIC_code='5461'DB:business_master_new
loadtime:0.34764099121094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monkton' limit 1
loadtime:0.34771800041199 / seconds
Query Executed:select id FROM `vt` where city='Monkton' && SIC_code='5461'DB:business_master_new
loadtime:0.34845495223999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery' limit 1
loadtime:0.34851694107056 / seconds
Query Executed:select id FROM `vt` where city='Montgomery' && SIC_code='5461'DB:business_master_new
loadtime:0.34911203384399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery Center' limit 1
loadtime:0.34917187690735 / seconds
Query Executed:select id FROM `vt` where city='Montgomery Center' && SIC_code='5461'DB:business_master_new
loadtime:0.35017895698547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery Ctr' limit 1
loadtime:0.35024094581604 / seconds
Query Executed:select id FROM `vt` where city='Montgomery Ctr' && SIC_code='5461'DB:business_master_new
loadtime:0.35069394111633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:0.35075402259827 / seconds
Query Executed:select id FROM `vt` where city='Montpelier' && SIC_code='5461'DB:business_master_new
loadtime:0.35261392593384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moretown' limit 1
loadtime:0.3526930809021 / seconds
Query Executed:select id FROM `vt` where city='Moretown' && SIC_code='5461'DB:business_master_new
loadtime:0.3542160987854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morgan' limit 1
loadtime:0.3542799949646 / seconds
Query Executed:select id FROM `vt` where city='Morgan' && SIC_code='5461'DB:business_master_new
loadtime:0.35489201545715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisville' limit 1
loadtime:0.35496401786804 / seconds
Query Executed:select id FROM `vt` where city='Morrisville' && SIC_code='5461'DB:business_master_new
loadtime:0.35682797431946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moscow' limit 1
loadtime:0.35690689086914 / seconds
Query Executed:select id FROM `vt` where city='Moscow' && SIC_code='5461'DB:business_master_new
loadtime:0.35743188858032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Holly' limit 1
loadtime:0.35749506950378 / seconds
Query Executed:select id FROM `vt` where city='Mount Holly' && SIC_code='5461'DB:business_master_new
loadtime:0.3582329750061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Holly' limit 1
loadtime:0.35829997062683 / seconds
Query Executed:select id FROM `vt` where city='Mt Holly' && SIC_code='5461'DB:business_master_new
loadtime:0.358717918396 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Springfield' limit 1
loadtime:0.35877895355225 / seconds
Query Executed:select id FROM `vt` where city='N Springfield' && SIC_code='5461'DB:business_master_new
loadtime:0.35930895805359 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Haven' limit 1
loadtime:0.35936999320984 / seconds
Query Executed:select id FROM `vt` where city='New Haven' && SIC_code='5461'DB:business_master_new
loadtime:0.36111807823181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbury' limit 1
loadtime:0.36118507385254 / seconds
Query Executed:select id FROM `vt` where city='Newbury' && SIC_code='5461'DB:business_master_new
loadtime:0.36195707321167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newfane' limit 1
loadtime:0.36201786994934 / seconds
Query Executed:select id FROM `vt` where city='Newfane' && SIC_code='5461'DB:business_master_new
loadtime:0.36358404159546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:0.36364507675171 / seconds
Query Executed:select id FROM `vt` where city='Newport' && SIC_code='5461'DB:business_master_new
loadtime:0.36549210548401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport Center' limit 1
loadtime:0.36557102203369 / seconds
Query Executed:select id FROM `vt` where city='Newport Center' && SIC_code='5461'DB:business_master_new
loadtime:0.36659407615662 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Bennington' limit 1
loadtime:0.3666570186615 / seconds
Query Executed:select id FROM `vt` where city='North Bennington' && SIC_code='5461'DB:business_master_new
loadtime:0.36834001541138 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chittenden' limit 1
loadtime:0.3684070110321 / seconds
Query Executed:select id FROM `vt` where city='North Chittenden' && SIC_code='5461'DB:business_master_new
loadtime:0.36877298355103 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Clarendon' limit 1
loadtime:0.36883807182312 / seconds
Query Executed:select id FROM `vt` where city='North Clarendon' && SIC_code='5461'DB:business_master_new
loadtime:0.37057590484619 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Concord' limit 1
loadtime:0.37063789367676 / seconds
Query Executed:select id FROM `vt` where city='North Concord' && SIC_code='5461'DB:business_master_new
loadtime:0.37116599082947 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Ferrisburg' limit 1
loadtime:0.37122702598572 / seconds
Query Executed:select id FROM `vt` where city='North Ferrisburg' && SIC_code='5461'DB:business_master_new
loadtime:0.37165999412537 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hartland' limit 1
loadtime:0.37172102928162 / seconds
Query Executed:select id FROM `vt` where city='North Hartland' && SIC_code='5461'DB:business_master_new
loadtime:0.37227201461792 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hero' limit 1
loadtime:0.37233304977417 / seconds
Query Executed:select id FROM `vt` where city='North Hero' && SIC_code='5461'DB:business_master_new
loadtime:0.37348794937134 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hyde Park' limit 1
loadtime:0.37355208396912 / seconds
Query Executed:select id FROM `vt` where city='North Hyde Park' && SIC_code='5461'DB:business_master_new
loadtime:0.37409806251526 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Montpelier' limit 1
loadtime:0.37415909767151 / seconds
Query Executed:select id FROM `vt` where city='North Montpelier' && SIC_code='5461'DB:business_master_new
loadtime:0.3746190071106 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pomfret' limit 1
loadtime:0.37468004226685 / seconds
Query Executed:select id FROM `vt` where city='North Pomfret' && SIC_code='5461'DB:business_master_new
loadtime:0.37535405158997 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pownal' limit 1
loadtime:0.37541508674622 / seconds
Query Executed:select id FROM `vt` where city='North Pownal' && SIC_code='5461'DB:business_master_new
loadtime:0.375972032547 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Springfield' limit 1
loadtime:0.37603187561035 / seconds
Query Executed:select id FROM `vt` where city='North Springfield' && SIC_code='5461'DB:business_master_new
loadtime:0.37731599807739 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Thetford' limit 1
loadtime:0.37737894058228 / seconds
Query Executed:select id FROM `vt` where city='North Thetford' && SIC_code='5461'DB:business_master_new
loadtime:0.37788796424866 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Troy' limit 1
loadtime:0.37795996665955 / seconds
Query Executed:select id FROM `vt` where city='North Troy' && SIC_code='5461'DB:business_master_new
loadtime:0.37931394577026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:0.37937593460083 / seconds
Query Executed:select id FROM `vt` where city='Northfield' && SIC_code='5461'DB:business_master_new
loadtime:0.38245105743408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield Falls' limit 1
loadtime:0.38252997398376 / seconds
Query Executed:select id FROM `vt` where city='Northfield Falls' && SIC_code='5461'DB:business_master_new
loadtime:0.38309502601624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:0.38315606117249 / seconds
Query Executed:select id FROM `vt` where city='Norton' && SIC_code='5461'DB:business_master_new
loadtime:0.38381099700928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwich' limit 1
loadtime:0.38387393951416 / seconds
Query Executed:select id FROM `vt` where city='Norwich' && SIC_code='5461'DB:business_master_new
loadtime:0.38693904876709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:0.38702487945557 / seconds
Query Executed:select id FROM `vt` where city='Orange' && SIC_code='5461'DB:business_master_new
loadtime:0.38750696182251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orleans' limit 1
loadtime:0.38756895065308 / seconds
Query Executed:select id FROM `vt` where city='Orleans' && SIC_code='5461'DB:business_master_new
loadtime:0.38934993743896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orwell' limit 1
loadtime:0.38941407203674 / seconds
Query Executed:select id FROM `vt` where city='Orwell' && SIC_code='5461'DB:business_master_new
loadtime:0.39080810546875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Passumpsic' limit 1
loadtime:0.39087009429932 / seconds
Query Executed:select id FROM `vt` where city='Passumpsic' && SIC_code='5461'DB:business_master_new
loadtime:0.39129304885864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pawlet' limit 1
loadtime:0.39135408401489 / seconds
Query Executed:select id FROM `vt` where city='Pawlet' && SIC_code='5461'DB:business_master_new
loadtime:0.39267587661743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peacham' limit 1
loadtime:0.39275288581848 / seconds
Query Executed:select id FROM `vt` where city='Peacham' && SIC_code='5461'DB:business_master_new
loadtime:0.39342093467712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perkinsville' limit 1
loadtime:0.39348292350769 / seconds
Query Executed:select id FROM `vt` where city='Perkinsville' && SIC_code='5461'DB:business_master_new
loadtime:0.39487600326538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peru' limit 1
loadtime:0.39493703842163 / seconds
Query Executed:select id FROM `vt` where city='Peru' && SIC_code='5461'DB:business_master_new
loadtime:0.39560508728027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsfield' limit 1
loadtime:0.39566493034363 / seconds
Query Executed:select id FROM `vt` where city='Pittsfield' && SIC_code='5461'DB:business_master_new
loadtime:0.39641189575195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsford' limit 1
loadtime:0.39649105072021 / seconds
Query Executed:select id FROM `vt` where city='Pittsford' && SIC_code='5461'DB:business_master_new
loadtime:0.39850497245789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:0.39858102798462 / seconds
Query Executed:select id FROM `vt` where city='Plainfield' && SIC_code='5461'DB:business_master_new
loadtime:0.40035104751587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.40041399002075 / seconds
Query Executed:select id FROM `vt` where city='Plymouth' && SIC_code='5461'DB:business_master_new
loadtime:0.40112996101379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Post Mills' limit 1
loadtime:0.40119004249573 / seconds
Query Executed:select id FROM `vt` where city='Post Mills' && SIC_code='5461'DB:business_master_new
loadtime:0.40175008773804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poultney' limit 1
loadtime:0.40181589126587 / seconds
Query Executed:select id FROM `vt` where city='Poultney' && SIC_code='5461'DB:business_master_new
loadtime:0.40406107902527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pownal' limit 1
loadtime:0.40413689613342 / seconds
Query Executed:select id FROM `vt` where city='Pownal' && SIC_code='5461'DB:business_master_new
loadtime:0.40562987327576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Proctor' limit 1
loadtime:0.4056921005249 / seconds
Query Executed:select id FROM `vt` where city='Proctor' && SIC_code='5461'DB:business_master_new
loadtime:0.40697002410889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Proctorsville' limit 1
loadtime:0.40703201293945 / seconds
Query Executed:select id FROM `vt` where city='Proctorsville' && SIC_code='5461'DB:business_master_new
loadtime:0.40810894966125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Putney' limit 1
loadtime:0.40818810462952 / seconds
Query Executed:select id FROM `vt` where city='Putney' && SIC_code='5461'DB:business_master_new
loadtime:0.41092205047607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quechee' limit 1
loadtime:0.41099691390991 / seconds
Query Executed:select id FROM `vt` where city='Quechee' && SIC_code='5461'DB:business_master_new
loadtime:0.41276693344116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:0.41284799575806 / seconds
Query Executed:select id FROM `vt` where city='Randolph' && SIC_code='5461'DB:business_master_new
loadtime:0.41471099853516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph Center' limit 1
loadtime:0.41478800773621 / seconds
Query Executed:select id FROM `vt` where city='Randolph Center' && SIC_code='5461'DB:business_master_new
loadtime:0.41585302352905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reading' limit 1
loadtime:0.41591501235962 / seconds
Query Executed:select id FROM `vt` where city='Reading' && SIC_code='5461'DB:business_master_new
loadtime:0.41668009757996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readsboro' limit 1
loadtime:0.41674089431763 / seconds
Query Executed:select id FROM `vt` where city='Readsboro' && SIC_code='5461'DB:business_master_new
loadtime:0.41751599311829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richford' limit 1
loadtime:0.41757798194885 / seconds
Query Executed:select id FROM `vt` where city='Richford' && SIC_code='5461'DB:business_master_new
loadtime:0.41928601264954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:0.4193480014801 / seconds
Query Executed:select id FROM `vt` where city='Richmond' && SIC_code='5461'DB:business_master_new
loadtime:0.42215895652771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ripton' limit 1
loadtime:0.42222189903259 / seconds
Query Executed:select id FROM `vt` where city='Ripton' && SIC_code='5461'DB:business_master_new
loadtime:0.42272806167603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:0.42279291152954 / seconds
Query Executed:select id FROM `vt` where city='Rochester' && SIC_code='5461'DB:business_master_new
loadtime:0.4242799282074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:0.42434191703796 / seconds
Query Executed:select id FROM `vt` where city='Roxbury' && SIC_code='5461'DB:business_master_new
loadtime:0.42505407333374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rupert' limit 1
loadtime:0.42511487007141 / seconds
Query Executed:select id FROM `vt` where city='Rupert' && SIC_code='5461'DB:business_master_new
loadtime:0.42567300796509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:0.42573404312134 / seconds
Query Executed:select id FROM `vt` where city='Rutland' && SIC_code='5461'DB:business_master_new
loadtime:0.42760992050171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ryegate' limit 1
loadtime:0.42770409584045 / seconds
Query Executed:select id FROM `vt` where city='Ryegate' && SIC_code='5461'DB:business_master_new
loadtime:0.42819094657898 / seconds
Query loaded from cache:select * from geodata_geocity where city='S Londonderry' limit 1
loadtime:0.42825508117676 / seconds
Query Executed:select id FROM `vt` where city='S Londonderry' && SIC_code='5461'DB:business_master_new
loadtime:0.42880892753601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Albans' limit 1
loadtime:0.42887091636658 / seconds
Query Executed:select id FROM `vt` where city='Saint Albans' && SIC_code='5461'DB:business_master_new
loadtime:0.4307279586792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Albans Bay' limit 1
loadtime:0.43081402778625 / seconds
Query Executed:select id FROM `vt` where city='Saint Albans Bay' && SIC_code='5461'DB:business_master_new
loadtime:0.43141603469849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johnsbury' limit 1
loadtime:0.43147897720337 / seconds
Query Executed:select id FROM `vt` where city='Saint Johnsbury' && SIC_code='5461'DB:business_master_new
loadtime:0.43336391448975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johnsbury Center' limit 1
loadtime:0.43344402313232 / seconds
Query Executed:select id FROM `vt` where city='Saint Johnsbury Center' && SIC_code='5461'DB:business_master_new
loadtime:0.43409109115601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:0.43415403366089 / seconds
Query Executed:select id FROM `vt` where city='Salisbury' && SIC_code='5461'DB:business_master_new
loadtime:0.43530106544495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxtons River' limit 1
loadtime:0.43536305427551 / seconds
Query Executed:select id FROM `vt` where city='Saxtons River' && SIC_code='5461'DB:business_master_new
loadtime:0.43651390075684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaftsbury' limit 1
loadtime:0.43658995628357 / seconds
Query Executed:select id FROM `vt` where city='Shaftsbury' && SIC_code='5461'DB:business_master_new
loadtime:0.43850493431091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.43858098983765 / seconds
Query Executed:select id FROM `vt` where city='Sharon' && SIC_code='5461'DB:business_master_new
loadtime:0.43977499008179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheffield' limit 1
loadtime:0.43984198570251 / seconds
Query Executed:select id FROM `vt` where city='Sheffield' && SIC_code='5461'DB:business_master_new
loadtime:0.44047689437866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelburne' limit 1
loadtime:0.44053792953491 / seconds
Query Executed:select id FROM `vt` where city='Shelburne' && SIC_code='5461'DB:business_master_new
loadtime:0.44240593910217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon' limit 1
loadtime:0.44248509407043 / seconds
Query Executed:select id FROM `vt` where city='Sheldon' && SIC_code='5461'DB:business_master_new
loadtime:0.44358491897583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon Springs' limit 1
loadtime:0.44364809989929 / seconds
Query Executed:select id FROM `vt` where city='Sheldon Springs' && SIC_code='5461'DB:business_master_new
loadtime:0.4442400932312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shoreham' limit 1
loadtime:0.44430208206177 / seconds
Query Executed:select id FROM `vt` where city='Shoreham' && SIC_code='5461'DB:business_master_new
loadtime:0.44567894935608 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Barre' limit 1
loadtime:0.44574093818665 / seconds
Query Executed:select id FROM `vt` where city='South Barre' && SIC_code='5461'DB:business_master_new
loadtime:0.44678092002869 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Burlington' limit 1
loadtime:0.44684600830078 / seconds
Query Executed:select id FROM `vt` where city='South Burlington' && SIC_code='5461'DB:business_master_new
loadtime:0.44871807098389 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hero' limit 1
loadtime:0.44880890846252 / seconds
Query Executed:select id FROM `vt` where city='South Hero' && SIC_code='5461'DB:business_master_new
loadtime:0.45066404342651 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Londonderry' limit 1
loadtime:0.45072889328003 / seconds
Query Executed:select id FROM `vt` where city='South Londonderry' && SIC_code='5461'DB:business_master_new
loadtime:0.45190691947937 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Newfane' limit 1
loadtime:0.45197987556458 / seconds
Query Executed:select id FROM `vt` where city='South Newfane' && SIC_code='5461'DB:business_master_new
loadtime:0.45249605178833 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Pomfret' limit 1
loadtime:0.45255708694458 / seconds
Query Executed:select id FROM `vt` where city='South Pomfret' && SIC_code='5461'DB:business_master_new
loadtime:0.45324087142944 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Royalton' limit 1
loadtime:0.45330309867859 / seconds
Query Executed:select id FROM `vt` where city='South Royalton' && SIC_code='5461'DB:business_master_new
loadtime:0.45533490180969 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Ryegate' limit 1
loadtime:0.45541095733643 / seconds
Query Executed:select id FROM `vt` where city='South Ryegate' && SIC_code='5461'DB:business_master_new
loadtime:0.45608901977539 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Strafford' limit 1
loadtime:0.45615100860596 / seconds
Query Executed:select id FROM `vt` where city='South Strafford' && SIC_code='5461'DB:business_master_new
loadtime:0.45683693885803 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Woodstock' limit 1
loadtime:0.45689797401428 / seconds
Query Executed:select id FROM `vt` where city='South Woodstock' && SIC_code='5461'DB:business_master_new
loadtime:0.45756196975708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.45762205123901 / seconds
Query Executed:select id FROM `vt` where city='Springfield' && SIC_code='5461'DB:business_master_new
loadtime:0.45950603485107 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Albans' limit 1
loadtime:0.45958399772644 / seconds
Query Executed:select id FROM `vt` where city='St Albans' && SIC_code='5461'DB:business_master_new
loadtime:0.46015095710754 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Albans Bay' limit 1
loadtime:0.46021294593811 / seconds
Query Executed:select id FROM `vt` where city='St Albans Bay' && SIC_code='5461'DB:business_master_new
loadtime:0.46072697639465 / seconds
Query loaded from cache:select * from geodata_geocity where city='St George' limit 1
loadtime:0.46079301834106 / seconds
Query Executed:select id FROM `vt` where city='St George' && SIC_code='5461'DB:business_master_new
loadtime:0.46124505996704 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johnsbury' limit 1
loadtime:0.46130609512329 / seconds
Query Executed:select id FROM `vt` where city='St Johnsbury' && SIC_code='5461'DB:business_master_new
loadtime:0.46234202384949 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johnsbury Ctr' limit 1
loadtime:0.46241807937622 / seconds
Query Executed:select id FROM `vt` where city='St Johnsbury Ctr' && SIC_code='5461'DB:business_master_new
loadtime:0.46279406547546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stamford' limit 1
loadtime:0.46286106109619 / seconds
Query Executed:select id FROM `vt` where city='Stamford' && SIC_code='5461'DB:business_master_new
loadtime:0.46351289749146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Starksboro' limit 1
loadtime:0.46357607841492 / seconds
Query Executed:select id FROM `vt` where city='Starksboro' && SIC_code='5461'DB:business_master_new
loadtime:0.4646680355072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockbridge' limit 1
loadtime:0.46473097801208 / seconds
Query Executed:select id FROM `vt` where city='Stockbridge' && SIC_code='5461'DB:business_master_new
loadtime:0.465411901474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stowe' limit 1
loadtime:0.46547389030457 / seconds
Query Executed:select id FROM `vt` where city='Stowe' && SIC_code='5461'DB:business_master_new
loadtime:0.46731901168823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strafford' limit 1
loadtime:0.46739506721497 / seconds
Query Executed:select id FROM `vt` where city='Strafford' && SIC_code='5461'DB:business_master_new
loadtime:0.46805095672607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutton' limit 1
loadtime:0.46811890602112 / seconds
Query Executed:select id FROM `vt` where city='Sutton' && SIC_code='5461'DB:business_master_new
loadtime:0.46876192092896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swanton' limit 1
loadtime:0.46884393692017 / seconds
Query Executed:select id FROM `vt` where city='Swanton' && SIC_code='5461'DB:business_master_new
loadtime:0.4706768989563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taftsville' limit 1
loadtime:0.47075200080872 / seconds
Query Executed:select id FROM `vt` where city='Taftsville' && SIC_code='5461'DB:business_master_new
loadtime:0.47129988670349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thetford' limit 1
loadtime:0.47136187553406 / seconds
Query Executed:select id FROM `vt` where city='Thetford' && SIC_code='5461'DB:business_master_new
loadtime:0.47230100631714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thetford Center' limit 1
loadtime:0.47236299514771 / seconds
Query Executed:select id FROM `vt` where city='Thetford Center' && SIC_code='5461'DB:business_master_new
loadtime:0.47341108322144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topsham' limit 1
loadtime:0.473473072052 / seconds
Query Executed:select id FROM `vt` where city='Topsham' && SIC_code='5461'DB:business_master_new
loadtime:0.47395992279053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townshend' limit 1
loadtime:0.47402191162109 / seconds
Query Executed:select id FROM `vt` where city='Townshend' && SIC_code='5461'DB:business_master_new
loadtime:0.4754319190979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:0.47549390792847 / seconds
Query Executed:select id FROM `vt` where city='Troy' && SIC_code='5461'DB:business_master_new
loadtime:0.47621488571167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tunbridge' limit 1
loadtime:0.4762749671936 / seconds
Query Executed:select id FROM `vt` where city='Tunbridge' && SIC_code='5461'DB:business_master_new
loadtime:0.47736501693726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Underhill' limit 1
loadtime:0.47742605209351 / seconds
Query Executed:select id FROM `vt` where city='Underhill' && SIC_code='5461'DB:business_master_new
loadtime:0.47903895378113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Underhill Center' limit 1
loadtime:0.47911596298218 / seconds
Query Executed:select id FROM `vt` where city='Underhill Center' && SIC_code='5461'DB:business_master_new
loadtime:0.47971987724304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vergennes' limit 1
loadtime:0.47978496551514 / seconds
Query Executed:select id FROM `vt` where city='Vergennes' && SIC_code='5461'DB:business_master_new
loadtime:0.48167109489441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:0.48173189163208 / seconds
Query Executed:select id FROM `vt` where city='Vernon' && SIC_code='5461'DB:business_master_new
loadtime:0.48314189910889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vershire' limit 1
loadtime:0.48320508003235 / seconds
Query Executed:select id FROM `vt` where city='Vershire' && SIC_code='5461'DB:business_master_new
loadtime:0.48379898071289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waitsfield' limit 1
loadtime:0.48387694358826 / seconds
Query Executed:select id FROM `vt` where city='Waitsfield' && SIC_code='5461'DB:business_master_new
loadtime:0.4857439994812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallingford' limit 1
loadtime:0.48583292961121 / seconds
Query Executed:select id FROM `vt` where city='Wallingford' && SIC_code='5461'DB:business_master_new
loadtime:0.48775506019592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wardsboro' limit 1
loadtime:0.4878249168396 / seconds
Query Executed:select id FROM `vt` where city='Wardsboro' && SIC_code='5461'DB:business_master_new
loadtime:0.48848700523376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:0.48854994773865 / seconds
Query Executed:select id FROM `vt` where city='Warren' && SIC_code='5461'DB:business_master_new
loadtime:0.49073100090027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.49079990386963 / seconds
Query Executed:select id FROM `vt` where city='Washington' && SIC_code='5461'DB:business_master_new
loadtime:0.49181294441223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury' limit 1
loadtime:0.4918749332428 / seconds
Query Executed:select id FROM `vt` where city='Waterbury' && SIC_code='5461'DB:business_master_new
loadtime:0.49371695518494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury Center' limit 1
loadtime:0.49380087852478 / seconds
Query Executed:select id FROM `vt` where city='Waterbury Center' && SIC_code='5461'DB:business_master_new
loadtime:0.49547910690308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville' limit 1
loadtime:0.49555492401123 / seconds
Query Executed:select id FROM `vt` where city='Waterville' && SIC_code='5461'DB:business_master_new
loadtime:0.49630403518677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Websterville' limit 1
loadtime:0.49636602401733 / seconds
Query Executed:select id FROM `vt` where city='Websterville' && SIC_code='5461'DB:business_master_new
loadtime:0.49695587158203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wells' limit 1
loadtime:0.49701809883118 / seconds
Query Executed:select id FROM `vt` where city='Wells' && SIC_code='5461'DB:business_master_new
loadtime:0.49799489974976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wells River' limit 1
loadtime:0.49805688858032 / seconds
Query Executed:select id FROM `vt` where city='Wells River' && SIC_code='5461'DB:business_master_new
loadtime:0.49923896789551 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Burke' limit 1
loadtime:0.49930787086487 / seconds
Query Executed:select id FROM `vt` where city='West Burke' && SIC_code='5461'DB:business_master_new
loadtime:0.50045394897461 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Charleston' limit 1
loadtime:0.50051593780518 / seconds
Query Executed:select id FROM `vt` where city='West Charleston' && SIC_code='5461'DB:business_master_new
loadtime:0.50115895271301 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Danville' limit 1
loadtime:0.50121998786926 / seconds
Query Executed:select id FROM `vt` where city='West Danville' && SIC_code='5461'DB:business_master_new
loadtime:0.50215601921082 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dover' limit 1
loadtime:0.50221800804138 / seconds
Query Executed:select id FROM `vt` where city='West Dover' && SIC_code='5461'DB:business_master_new
loadtime:0.50452709197998 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dummerston' limit 1
loadtime:0.50459003448486 / seconds
Query Executed:select id FROM `vt` where city='West Dummerston' && SIC_code='5461'DB:business_master_new
loadtime:0.50510287284851 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Fairlee' limit 1
loadtime:0.50516390800476 / seconds
Query Executed:select id FROM `vt` where city='West Fairlee' && SIC_code='5461'DB:business_master_new
loadtime:0.50577807426453 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Glover' limit 1
loadtime:0.50584292411804 / seconds
Query Executed:select id FROM `vt` where city='West Glover' && SIC_code='5461'DB:business_master_new
loadtime:0.50626587867737 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Halifax' limit 1
loadtime:0.50632691383362 / seconds
Query Executed:select id FROM `vt` where city='West Halifax' && SIC_code='5461'DB:business_master_new
loadtime:0.50690507888794 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartford' limit 1
loadtime:0.50697803497314 / seconds
Query Executed:select id FROM `vt` where city='West Hartford' && SIC_code='5461'DB:business_master_new
loadtime:0.50754308700562 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Marlboro' limit 1
loadtime:0.50760507583618 / seconds
Query Executed:select id FROM `vt` where city='West Marlboro' && SIC_code='5461'DB:business_master_new
loadtime:0.50805497169495 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newbury' limit 1
loadtime:0.50811505317688 / seconds
Query Executed:select id FROM `vt` where city='West Newbury' && SIC_code='5461'DB:business_master_new
loadtime:0.5086350440979 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Pawlet' limit 1
loadtime:0.50869607925415 / seconds
Query Executed:select id FROM `vt` where city='West Pawlet' && SIC_code='5461'DB:business_master_new
loadtime:0.5094358921051 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Rupert' limit 1
loadtime:0.50949692726135 / seconds
Query Executed:select id FROM `vt` where city='West Rupert' && SIC_code='5461'DB:business_master_new
loadtime:0.51004600524902 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Rutland' limit 1
loadtime:0.51010704040527 / seconds
Query Executed:select id FROM `vt` where city='West Rutland' && SIC_code='5461'DB:business_master_new
loadtime:0.51219606399536 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Topsham' limit 1
loadtime:0.51227188110352 / seconds
Query Executed:select id FROM `vt` where city='West Topsham' && SIC_code='5461'DB:business_master_new
loadtime:0.51286292076111 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Townshend' limit 1
loadtime:0.51292490959167 / seconds
Query Executed:select id FROM `vt` where city='West Townshend' && SIC_code='5461'DB:business_master_new
loadtime:0.51354694366455 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Wardsboro' limit 1
loadtime:0.51360893249512 / seconds
Query Executed:select id FROM `vt` where city='West Wardsboro' && SIC_code='5461'DB:business_master_new
loadtime:0.51427793502808 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Windsor' limit 1
loadtime:0.51433897018433 / seconds
Query Executed:select id FROM `vt` where city='West Windsor' && SIC_code='5461'DB:business_master_new
loadtime:0.51475596427917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:0.5148229598999 / seconds
Query Executed:select id FROM `vt` where city='Westfield' && SIC_code='5461'DB:business_master_new
loadtime:0.51552104949951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westford' limit 1
loadtime:0.51558208465576 / seconds
Query Executed:select id FROM `vt` where city='Westford' && SIC_code='5461'DB:business_master_new
loadtime:0.51684188842773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:0.5169038772583 / seconds
Query Executed:select id FROM `vt` where city='Westminster' && SIC_code='5461'DB:business_master_new
loadtime:0.51829195022583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster Sta' limit 1
loadtime:0.51835298538208 / seconds
Query Executed:select id FROM `vt` where city='Westminster Sta' && SIC_code='5461'DB:business_master_new
loadtime:0.51877498626709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster Station' limit 1
loadtime:0.51884007453918 / seconds
Query Executed:select id FROM `vt` where city='Westminster Station' && SIC_code='5461'DB:business_master_new
loadtime:0.51944398880005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:0.51950597763062 / seconds
Query Executed:select id FROM `vt` where city='Weston' && SIC_code='5461'DB:business_master_new
loadtime:0.52066588401794 / seconds
Query loaded from cache:select * from geodata_geocity where city='White River Jct' limit 1
loadtime:0.52072906494141 / seconds
Query Executed:select id FROM `vt` where city='White River Jct' && SIC_code='5461'DB:business_master_new
loadtime:0.52124404907227 / seconds
Query loaded from cache:select * from geodata_geocity where city='White River Junction' limit 1
loadtime:0.52130603790283 / seconds
Query Executed:select id FROM `vt` where city='White River Junction' && SIC_code='5461'DB:business_master_new
loadtime:0.52316308021545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiting' limit 1
loadtime:0.5232400894165 / seconds
Query Executed:select id FROM `vt` where city='Whiting' && SIC_code='5461'DB:business_master_new
loadtime:0.52396893501282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitingham' limit 1
loadtime:0.52403092384338 / seconds
Query Executed:select id FROM `vt` where city='Whitingham' && SIC_code='5461'DB:business_master_new
loadtime:0.52476787567139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilder' limit 1
loadtime:0.5248339176178 / seconds
Query Executed:select id FROM `vt` where city='Wilder' && SIC_code='5461'DB:business_master_new
loadtime:0.52603793144226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamstown' limit 1
loadtime:0.52609992027283 / seconds
Query Executed:select id FROM `vt` where city='Williamstown' && SIC_code='5461'DB:business_master_new
loadtime:0.52794003486633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsville' limit 1
loadtime:0.52802610397339 / seconds
Query Executed:select id FROM `vt` where city='Williamsville' && SIC_code='5461'DB:business_master_new
loadtime:0.52871203422546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williston' limit 1
loadtime:0.52877402305603 / seconds
Query Executed:select id FROM `vt` where city='Williston' && SIC_code='5461'DB:business_master_new
loadtime:0.53064489364624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmington' limit 1
loadtime:0.53072690963745 / seconds
Query Executed:select id FROM `vt` where city='Wilmington' && SIC_code='5461'DB:business_master_new
loadtime:0.53259110450745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:0.53265404701233 / seconds
Query Executed:select id FROM `vt` where city='Windsor' && SIC_code='5461'DB:business_master_new
loadtime:0.53450989723206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winooski' limit 1
loadtime:0.53458499908447 / seconds
Query Executed:select id FROM `vt` where city='Winooski' && SIC_code='5461'DB:business_master_new
loadtime:0.53644394874573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolcott' limit 1
loadtime:0.53650593757629 / seconds
Query Executed:select id FROM `vt` where city='Wolcott' && SIC_code='5461'DB:business_master_new
loadtime:0.53777194023132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbury' limit 1
loadtime:0.5378520488739 / seconds
Query Executed:select id FROM `vt` where city='Woodbury' && SIC_code='5461'DB:business_master_new
loadtime:0.53844809532166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:0.53851103782654 / seconds
Query Executed:select id FROM `vt` where city='Woodstock' && SIC_code='5461'DB:business_master_new
loadtime:0.54037690162659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worcester' limit 1
loadtime:0.540452003479 / seconds
Query Executed:select id FROM `vt` where city='Worcester' && SIC_code='5461'DB:business_master_new
loadtime:0.54120588302612 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.54135608673096 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.54175806045532 / seconds
Operation template executed (chunk cache operation)
loadtime:0.54192805290222 / seconds
template override:Default
loadtime:0.5419819355011 / 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.54327893257141 / seconds
Template Constructed, Array Rows:49
loadtime:0.54380202293396 / seconds
TOTAL EXECUTION TIME: 0.54337
loadtime:0.5451500415802 / 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] => retail-bakeries [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.54516005516052
TOTAL KEY ARRAYS: 69