Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:0.00019097328186035 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0014669895172119 / seconds
host not found setting manual db connection
loadtime:0.0025501251220703 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.003201961517334 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0037651062011719 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0039091110229492 / seconds
zipcode:
loadtime:0.0039551258087158 / seconds
Query Executed:select * from search_referrer where page_hash='15c97e7f98dfd6b696ec10c32efb8247' limit 10 DB:ezrox_toadli
loadtime:0.0045449733734131 / seconds
Operation header executed (non global)
loadtime:0.0045931339263916 / seconds
Operation leaderboard executed (non global)
loadtime:0.0046930313110352 / seconds
Operation square executed (non global)
loadtime:0.0047299861907959 / seconds
Operation square_bottom executed (non global)
loadtime:0.004763126373291 / seconds
Operation smallsquare executed (non global)
loadtime:0.0047931671142578 / seconds
Operation headeradright executed (non global)
loadtime:0.0048220157623291 / seconds
Operation google_analytics executed (non global)
loadtime:0.0048501491546631 / seconds
Operation topstories executed (non global)
loadtime:0.0048811435699463 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0049121379852295 / seconds
Operation memberbuscount executed (non global)
loadtime:0.004939079284668 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0056431293487549 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0059480667114258 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0059900283813477 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0061070919036865 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0062301158905029 / seconds
Template key: archive_menu pushed
loadtime:0.0062439441680908 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0062601566314697 / seconds
Template key: get_gravatar pushed
loadtime:0.006270170211792 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0063130855560303 / seconds
*10)-10)+1 | start:0
loadtime:0.0063819885253906 / seconds
DB connected to localhost business_master_new
loadtime:0.0070371627807617 / seconds
Query Executed:select * from categories where cat_URLid='retail-nurseries-lawn-and-garden-supply-stores'DB:business_master_new
loadtime:0.0085279941558838 / seconds
Query stored in cache : _QUERY_www.toadli.com1e9814ae7124e3b8054396375087dfd1
loadtime:0.0086450576782227 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='vermont'
loadtime:0.0087430477142334 / seconds
Query Executed:select * from `vt_catmap` where sic='5261' order by city ascDB:business_master_new
loadtime:0.097432136535645 / seconds
Query stored in cache : _QUERY_www.toadli.com1417c3dff15d7b55ee483a77f088073a
loadtime:0.098835945129395 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='vermont'
loadtime:0.098917961120605 / seconds
Query Executed:select sum(totalcount) as totalsum from `vt_catmap` where sic='5261'DB:business_master_new
loadtime:0.10416913032532 / seconds
Query stored in cache : _QUERY_www.toadli.com72f14ed27b85070eea302418aafa3c67
loadtime:0.10431504249573 / seconds
321 / 11
loadtime:0.10440897941589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adamant' limit 1
loadtime:0.10452795028687 / seconds
Query Executed:select id FROM `vt` where city='Adamant' && SIC_code='5261'DB:business_master_new
loadtime:0.10734009742737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albany' limit 1
loadtime:0.10746908187866 / seconds
Query Executed:select id FROM `vt` where city='Albany' && SIC_code='5261'DB:business_master_new
loadtime:0.10865306854248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alburg' limit 1
loadtime:0.10879302024841 / seconds
Query Executed:select id FROM `vt` where city='Alburg' && SIC_code='5261'DB:business_master_new
loadtime:0.10982298851013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.10996007919312 / seconds
Query Executed:select id FROM `vt` where city='Arlington' && SIC_code='5261'DB:business_master_new
loadtime:0.11132001876831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ascutney' limit 1
loadtime:0.11147499084473 / seconds
Query Executed:select id FROM `vt` where city='Ascutney' && SIC_code='5261'DB:business_master_new
loadtime:0.1125431060791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athens' limit 1
loadtime:0.11267399787903 / seconds
Query Executed:select id FROM `vt` where city='Athens' && SIC_code='5261'DB:business_master_new
loadtime:0.11338496208191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Averill' limit 1
loadtime:0.11348295211792 / seconds
Query Executed:select id FROM `vt` where city='Averill' && SIC_code='5261'DB:business_master_new
loadtime:0.11432600021362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bakersfield' limit 1
loadtime:0.11445903778076 / seconds
Query Executed:select id FROM `vt` where city='Bakersfield' && SIC_code='5261'DB:business_master_new
loadtime:0.11555910110474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnard' limit 1
loadtime:0.11572909355164 / seconds
Query Executed:select id FROM `vt` where city='Barnard' && SIC_code='5261'DB:business_master_new
loadtime:0.11677503585815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnet' limit 1
loadtime:0.11687302589417 / seconds
Query Executed:select id FROM `vt` where city='Barnet' && SIC_code='5261'DB:business_master_new
loadtime:0.11798501014709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barre' limit 1
loadtime:0.11812114715576 / seconds
Query Executed:select id FROM `vt` where city='Barre' && SIC_code='5261'DB:business_master_new
loadtime:0.15009903907776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barton' limit 1
loadtime:0.1502571105957 / seconds
Query Executed:select id FROM `vt` where city='Barton' && SIC_code='5261'DB:business_master_new
loadtime:0.15149712562561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beebe Plain' limit 1
loadtime:0.15163207054138 / seconds
Query Executed:select id FROM `vt` where city='Beebe Plain' && SIC_code='5261'DB:business_master_new
loadtime:0.15252804756165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beecher Falls' limit 1
loadtime:0.15266895294189 / seconds
Query Executed:select id FROM `vt` where city='Beecher Falls' && SIC_code='5261'DB:business_master_new
loadtime:0.15361213684082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellows Falls' limit 1
loadtime:0.15372395515442 / seconds
Query Executed:select id FROM `vt` where city='Bellows Falls' && SIC_code='5261'DB:business_master_new
loadtime:0.15520596504211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.15539503097534 / seconds
Query Executed:select id FROM `vt` where city='Belmont' && SIC_code='5261'DB:business_master_new
loadtime:0.15648317337036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvidere Center' limit 1
loadtime:0.15664911270142 / seconds
Query Executed:select id FROM `vt` where city='Belvidere Center' && SIC_code='5261'DB:business_master_new
loadtime:0.15748810768127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennington' limit 1
loadtime:0.15762400627136 / seconds
Query Executed:select id FROM `vt` where city='Bennington' && SIC_code='5261'DB:business_master_new
loadtime:0.16186213493347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benson' limit 1
loadtime:0.16192102432251 / seconds
Query Executed:select id FROM `vt` where city='Benson' && SIC_code='5261'DB:business_master_new
loadtime:0.16291499137878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.16305017471313 / seconds
Query Executed:select id FROM `vt` where city='Berlin' && SIC_code='5261'DB:business_master_new
loadtime:0.16411995887756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethel' limit 1
loadtime:0.16424894332886 / seconds
Query Executed:select id FROM `vt` where city='Bethel' && SIC_code='5261'DB:business_master_new
loadtime:0.16547703742981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton Valley' limit 1
loadtime:0.16563510894775 / seconds
Query Executed:select id FROM `vt` where city='Bolton Valley' && SIC_code='5261'DB:business_master_new
loadtime:0.1665780544281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bomoseen' limit 1
loadtime:0.16669607162476 / seconds
Query Executed:select id FROM `vt` where city='Bomoseen' && SIC_code='5261'DB:business_master_new
loadtime:0.16783809661865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bondville' limit 1
loadtime:0.16797995567322 / seconds
Query Executed:select id FROM `vt` where city='Bondville' && SIC_code='5261'DB:business_master_new
loadtime:0.16918396949768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.16937398910522 / seconds
Query Executed:select id FROM `vt` where city='Bradford' && SIC_code='5261'DB:business_master_new
loadtime:0.17066597938538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.17081594467163 / seconds
Query Executed:select id FROM `vt` where city='Brandon' && SIC_code='5261'DB:business_master_new
loadtime:0.17230916023254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brattleboro' limit 1
loadtime:0.17244601249695 / seconds
Query Executed:select id FROM `vt` where city='Brattleboro' && SIC_code='5261'DB:business_master_new
loadtime:0.1766049861908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.17677307128906 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater' && SIC_code='5261'DB:business_master_new
loadtime:0.17797493934631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater Corners' limit 1
loadtime:0.17811107635498 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater Corners' && SIC_code='5261'DB:business_master_new
loadtime:0.17930102348328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater Cors' limit 1
loadtime:0.17941808700562 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater Cors' && SIC_code='5261'DB:business_master_new
loadtime:0.18013000488281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridport' limit 1
loadtime:0.18031716346741 / seconds
Query Executed:select id FROM `vt` where city='Bridport' && SIC_code='5261'DB:business_master_new
loadtime:0.18139815330505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.18154811859131 / seconds
Query Executed:select id FROM `vt` where city='Bristol' && SIC_code='5261'DB:business_master_new
loadtime:0.18314599990845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.18334412574768 / seconds
Query Executed:select id FROM `vt` where city='Brookfield' && SIC_code='5261'DB:business_master_new
loadtime:0.18445801734924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline' limit 1
loadtime:0.18463397026062 / seconds
Query Executed:select id FROM `vt` where city='Brookline' && SIC_code='5261'DB:business_master_new
loadtime:0.18546605110168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownsville' limit 1
loadtime:0.18559694290161 / seconds
Query Executed:select id FROM `vt` where city='Brownsville' && SIC_code='5261'DB:business_master_new
loadtime:0.1868040561676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.18693709373474 / seconds
Query Executed:select id FROM `vt` where city='Burlington' && SIC_code='5261'DB:business_master_new
loadtime:0.19113898277283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cabot' limit 1
loadtime:0.19130897521973 / seconds
Query Executed:select id FROM `vt` where city='Cabot' && SIC_code='5261'DB:business_master_new
loadtime:0.19248008728027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calais' limit 1
loadtime:0.19263815879822 / seconds
Query Executed:select id FROM `vt` where city='Calais' && SIC_code='5261'DB:business_master_new
loadtime:0.19381403923035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:0.19395112991333 / seconds
Query Executed:select id FROM `vt` where city='Cambridge' && SIC_code='5261'DB:business_master_new
loadtime:0.19510412216187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridgeport' limit 1
loadtime:0.195237159729 / seconds
Query Executed:select id FROM `vt` where city='Cambridgeport' && SIC_code='5261'DB:business_master_new
loadtime:0.19618916511536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canaan' limit 1
loadtime:0.19636917114258 / seconds
Query Executed:select id FROM `vt` where city='Canaan' && SIC_code='5261'DB:business_master_new
loadtime:0.19744515419006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castleton' limit 1
loadtime:0.19754314422607 / seconds
Query Executed:select id FROM `vt` where city='Castleton' && SIC_code='5261'DB:business_master_new
loadtime:0.19816708564758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cavendish' limit 1
loadtime:0.19822716712952 / seconds
Query Executed:select id FROM `vt` where city='Cavendish' && SIC_code='5261'DB:business_master_new
loadtime:0.19865798950195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Rutland' limit 1
loadtime:0.19869494438171 / seconds
Query Executed:select id FROM `vt` where city='Center Rutland' && SIC_code='5261'DB:business_master_new
loadtime:0.19907712936401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte' limit 1
loadtime:0.19912505149841 / seconds
Query Executed:select id FROM `vt` where city='Charlotte' && SIC_code='5261'DB:business_master_new
loadtime:0.19962000846863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.19967603683472 / seconds
Query Executed:select id FROM `vt` where city='Chelsea' && SIC_code='5261'DB:business_master_new
loadtime:0.20011496543884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.2001690864563 / seconds
Query Executed:select id FROM `vt` where city='Chester' && SIC_code='5261'DB:business_master_new
loadtime:0.2007110118866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chittenden' limit 1
loadtime:0.200767993927 / seconds
Query Executed:select id FROM `vt` where city='Chittenden' && SIC_code='5261'DB:business_master_new
loadtime:0.20117115974426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colchester' limit 1
loadtime:0.20121002197266 / seconds
Query Executed:select id FROM `vt` where city='Colchester' && SIC_code='5261'DB:business_master_new
loadtime:0.20271897315979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.20277905464172 / seconds
Query Executed:select id FROM `vt` where city='Concord' && SIC_code='5261'DB:business_master_new
loadtime:0.20319795608521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corinth' limit 1
loadtime:0.20323610305786 / seconds
Query Executed:select id FROM `vt` where city='Corinth' && SIC_code='5261'DB:business_master_new
loadtime:0.20362710952759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coventry' limit 1
loadtime:0.20367693901062 / seconds
Query Executed:select id FROM `vt` where city='Coventry' && SIC_code='5261'DB:business_master_new
loadtime:0.20406007766724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury' limit 1
loadtime:0.20411109924316 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury' && SIC_code='5261'DB:business_master_new
loadtime:0.20447897911072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury Cmn' limit 1
loadtime:0.20452499389648 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury Cmn' && SIC_code='5261'DB:business_master_new
loadtime:0.20475816726685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury Common' limit 1
loadtime:0.20479416847229 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury Common' && SIC_code='5261'DB:business_master_new
loadtime:0.20516896247864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuttingsville' limit 1
loadtime:0.20519495010376 / seconds
Query Executed:select id FROM `vt` where city='Cuttingsville' && SIC_code='5261'DB:business_master_new
loadtime:0.2056200504303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danby' limit 1
loadtime:0.20567417144775 / seconds
Query Executed:select id FROM `vt` where city='Danby' && SIC_code='5261'DB:business_master_new
loadtime:0.2061071395874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.20615410804749 / seconds
Query Executed:select id FROM `vt` where city='Danville' && SIC_code='5261'DB:business_master_new
loadtime:0.20660305023193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby' limit 1
loadtime:0.20665407180786 / seconds
Query Executed:select id FROM `vt` where city='Derby' && SIC_code='5261'DB:business_master_new
loadtime:0.20710110664368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby Line' limit 1
loadtime:0.2071430683136 / seconds
Query Executed:select id FROM `vt` where city='Derby Line' && SIC_code='5261'DB:business_master_new
loadtime:0.20756006240845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorset' limit 1
loadtime:0.20761299133301 / seconds
Query Executed:select id FROM `vt` where city='Dorset' && SIC_code='5261'DB:business_master_new
loadtime:0.20805311203003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dummerston' limit 1
loadtime:0.20810008049011 / seconds
Query Executed:select id FROM `vt` where city='Dummerston' && SIC_code='5261'DB:business_master_new
loadtime:0.20834994316101 / seconds
Query loaded from cache:select * from geodata_geocity where city='E St Johnsbury' limit 1
loadtime:0.20838308334351 / seconds
Query Executed:select id FROM `vt` where city='E St Johnsbury' && SIC_code='5261'DB:business_master_new
loadtime:0.20859909057617 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Arlington' limit 1
loadtime:0.20863795280457 / seconds
Query Executed:select id FROM `vt` where city='East Arlington' && SIC_code='5261'DB:business_master_new
loadtime:0.20899415016174 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Barre' limit 1
loadtime:0.20902299880981 / seconds
Query Executed:select id FROM `vt` where city='East Barre' && SIC_code='5261'DB:business_master_new
loadtime:0.20939207077026 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Berkshire' limit 1
loadtime:0.20942807197571 / seconds
Query Executed:select id FROM `vt` where city='East Berkshire' && SIC_code='5261'DB:business_master_new
loadtime:0.20977997779846 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Burke' limit 1
loadtime:0.20982694625854 / seconds
Query Executed:select id FROM `vt` where city='East Burke' && SIC_code='5261'DB:business_master_new
loadtime:0.2101891040802 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Calais' limit 1
loadtime:0.21021604537964 / seconds
Query Executed:select id FROM `vt` where city='East Calais' && SIC_code='5261'DB:business_master_new
loadtime:0.21059203147888 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Charleston' limit 1
loadtime:0.21064305305481 / seconds
Query Executed:select id FROM `vt` where city='East Charleston' && SIC_code='5261'DB:business_master_new
loadtime:0.2109751701355 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Corinth' limit 1
loadtime:0.21100306510925 / seconds
Query Executed:select id FROM `vt` where city='East Corinth' && SIC_code='5261'DB:business_master_new
loadtime:0.21136212348938 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dorset' limit 1
loadtime:0.21140003204346 / seconds
Query Executed:select id FROM `vt` where city='East Dorset' && SIC_code='5261'DB:business_master_new
loadtime:0.21179509162903 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dover' limit 1
loadtime:0.21183800697327 / seconds
Query Executed:select id FROM `vt` where city='East Dover' && SIC_code='5261'DB:business_master_new
loadtime:0.21218705177307 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dummerston' limit 1
loadtime:0.21222710609436 / seconds
Query Executed:select id FROM `vt` where city='East Dummerston' && SIC_code='5261'DB:business_master_new
loadtime:0.21245503425598 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Fairfield' limit 1
loadtime:0.21248602867126 / seconds
Query Executed:select id FROM `vt` where city='East Fairfield' && SIC_code='5261'DB:business_master_new
loadtime:0.21285796165466 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hardwick' limit 1
loadtime:0.21291708946228 / seconds
Query Executed:select id FROM `vt` where city='East Hardwick' && SIC_code='5261'DB:business_master_new
loadtime:0.21330308914185 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Haven' limit 1
loadtime:0.21335196495056 / seconds
Query Executed:select id FROM `vt` where city='East Haven' && SIC_code='5261'DB:business_master_new
loadtime:0.21369910240173 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Middlebury' limit 1
loadtime:0.21376705169678 / seconds
Query Executed:select id FROM `vt` where city='East Middlebury' && SIC_code='5261'DB:business_master_new
loadtime:0.21414113044739 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Montpelier' limit 1
loadtime:0.21416902542114 / seconds
Query Executed:select id FROM `vt` where city='East Montpelier' && SIC_code='5261'DB:business_master_new
loadtime:0.21462297439575 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Orange' limit 1
loadtime:0.21468496322632 / seconds
Query Executed:select id FROM `vt` where city='East Orange' && SIC_code='5261'DB:business_master_new
loadtime:0.21491408348083 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Poultney' limit 1
loadtime:0.21495294570923 / seconds
Query Executed:select id FROM `vt` where city='East Poultney' && SIC_code='5261'DB:business_master_new
loadtime:0.21523404121399 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Randolph' limit 1
loadtime:0.21526503562927 / seconds
Query Executed:select id FROM `vt` where city='East Randolph' && SIC_code='5261'DB:business_master_new
loadtime:0.21561908721924 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Ryegate' limit 1
loadtime:0.21567010879517 / seconds
Query Executed:select id FROM `vt` where city='East Ryegate' && SIC_code='5261'DB:business_master_new
loadtime:0.21603894233704 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Saint Johnsbury' limit 1
loadtime:0.21607398986816 / seconds
Query Executed:select id FROM `vt` where city='East Saint Johnsbury' && SIC_code='5261'DB:business_master_new
loadtime:0.21637010574341 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Thetford' limit 1
loadtime:0.2164101600647 / seconds
Query Executed:select id FROM `vt` where city='East Thetford' && SIC_code='5261'DB:business_master_new
loadtime:0.21681094169617 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Wallingford' limit 1
loadtime:0.21685314178467 / seconds
Query Executed:select id FROM `vt` where city='East Wallingford' && SIC_code='5261'DB:business_master_new
loadtime:0.21720194816589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.21723699569702 / seconds
Query Executed:select id FROM `vt` where city='Eden' && SIC_code='5261'DB:business_master_new
loadtime:0.21761608123779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden Mills' limit 1
loadtime:0.2176661491394 / seconds
Query Executed:select id FROM `vt` where city='Eden Mills' && SIC_code='5261'DB:business_master_new
loadtime:0.21801900863647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enosburg Falls' limit 1
loadtime:0.21805810928345 / seconds
Query Executed:select id FROM `vt` where city='Enosburg Falls' && SIC_code='5261'DB:business_master_new
loadtime:0.21855115890503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.21860313415527 / seconds
Query Executed:select id FROM `vt` where city='Essex' && SIC_code='5261'DB:business_master_new
loadtime:0.21900010108948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex Junction' limit 1
loadtime:0.21903300285339 / seconds
Query Executed:select id FROM `vt` where city='Essex Junction' && SIC_code='5261'DB:business_master_new
loadtime:0.22048807144165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Haven' limit 1
loadtime:0.22053503990173 / seconds
Query Executed:select id FROM `vt` where city='Fair Haven' && SIC_code='5261'DB:business_master_new
loadtime:0.22100496292114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.22105407714844 / seconds
Query Executed:select id FROM `vt` where city='Fairfax' && SIC_code='5261'DB:business_master_new
loadtime:0.22151803970337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.22156500816345 / seconds
Query Executed:select id FROM `vt` where city='Fairfield' && SIC_code='5261'DB:business_master_new
loadtime:0.22197294235229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairlee' limit 1
loadtime:0.22201800346375 / seconds
Query Executed:select id FROM `vt` where city='Fairlee' && SIC_code='5261'DB:business_master_new
loadtime:0.22246599197388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferrisburg' limit 1
loadtime:0.22250509262085 / seconds
Query Executed:select id FROM `vt` where city='Ferrisburg' && SIC_code='5261'DB:business_master_new
loadtime:0.22274303436279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.2227840423584 / seconds
Query Executed:select id FROM `vt` where city='Florence' && SIC_code='5261'DB:business_master_new
loadtime:0.22313094139099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest Dale' limit 1
loadtime:0.22316408157349 / seconds
Query Executed:select id FROM `vt` where city='Forest Dale' && SIC_code='5261'DB:business_master_new
loadtime:0.22347497940063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.22350907325745 / seconds
Query Executed:select id FROM `vt` where city='Franklin' && SIC_code='5261'DB:business_master_new
loadtime:0.22389101982117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaysville' limit 1
loadtime:0.22392797470093 / seconds
Query Executed:select id FROM `vt` where city='Gaysville' && SIC_code='5261'DB:business_master_new
loadtime:0.22423505783081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:0.22428417205811 / seconds
Query Executed:select id FROM `vt` where city='Gilman' && SIC_code='5261'DB:business_master_new
loadtime:0.22461605072021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glover' limit 1
loadtime:0.22466897964478 / seconds
Query Executed:select id FROM `vt` where city='Glover' && SIC_code='5261'DB:business_master_new
loadtime:0.22505497932434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.22509908676147 / seconds
Query Executed:select id FROM `vt` where city='Grafton' && SIC_code='5261'DB:business_master_new
loadtime:0.22548913955688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:0.22553396224976 / seconds
Query Executed:select id FROM `vt` where city='Granby' && SIC_code='5261'DB:business_master_new
loadtime:0.22583913803101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Isle' limit 1
loadtime:0.22588801383972 / seconds
Query Executed:select id FROM `vt` where city='Grand Isle' && SIC_code='5261'DB:business_master_new
loadtime:0.22627806663513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graniteville' limit 1
loadtime:0.22632002830505 / seconds
Query Executed:select id FROM `vt` where city='Graniteville' && SIC_code='5261'DB:business_master_new
loadtime:0.22671914100647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granville' limit 1
loadtime:0.22677206993103 / seconds
Query Executed:select id FROM `vt` where city='Granville' && SIC_code='5261'DB:business_master_new
loadtime:0.22711896896362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greensboro' limit 1
loadtime:0.22715711593628 / seconds
Query Executed:select id FROM `vt` where city='Greensboro' && SIC_code='5261'DB:business_master_new
loadtime:0.2275550365448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greensboro Bend' limit 1
loadtime:0.22759795188904 / seconds
Query Executed:select id FROM `vt` where city='Greensboro Bend' && SIC_code='5261'DB:business_master_new
loadtime:0.22798109054565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.22803211212158 / seconds
Query Executed:select id FROM `vt` where city='Groton' && SIC_code='5261'DB:business_master_new
loadtime:0.22840094566345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guildhall' limit 1
loadtime:0.22844195365906 / seconds
Query Executed:select id FROM `vt` where city='Guildhall' && SIC_code='5261'DB:business_master_new
loadtime:0.22883296012878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guilford' limit 1
loadtime:0.22886800765991 / seconds
Query Executed:select id FROM `vt` where city='Guilford' && SIC_code='5261'DB:business_master_new
loadtime:0.22908997535706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:0.22912812232971 / seconds
Query Executed:select id FROM `vt` where city='Hancock' && SIC_code='5261'DB:business_master_new
loadtime:0.22949004173279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardwick' limit 1
loadtime:0.22953295707703 / seconds
Query Executed:select id FROM `vt` where city='Hardwick' && SIC_code='5261'DB:business_master_new
loadtime:0.229984998703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.23003911972046 / seconds
Query Executed:select id FROM `vt` where city='Hartford' && SIC_code='5261'DB:business_master_new
loadtime:0.2304151058197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland' limit 1
loadtime:0.23044300079346 / seconds
Query Executed:select id FROM `vt` where city='Hartland' && SIC_code='5261'DB:business_master_new
loadtime:0.23085904121399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland 4 Cors' limit 1
loadtime:0.23089504241943 / seconds
Query Executed:select id FROM `vt` where city='Hartland 4 Cors' && SIC_code='5261'DB:business_master_new
loadtime:0.23113107681274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland Four Corners' limit 1
loadtime:0.23117113113403 / seconds
Query Executed:select id FROM `vt` where city='Hartland Four Corners' && SIC_code='5261'DB:business_master_new
loadtime:0.23147916793823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highgate Center' limit 1
loadtime:0.23150610923767 / seconds
Query Executed:select id FROM `vt` where city='Highgate Center' && SIC_code='5261'DB:business_master_new
loadtime:0.2318971157074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highgate Springs' limit 1
loadtime:0.2319450378418 / seconds
Query Executed:select id FROM `vt` where city='Highgate Springs' && SIC_code='5261'DB:business_master_new
loadtime:0.23232102394104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinesburg' limit 1
loadtime:0.2323591709137 / seconds
Query Executed:select id FROM `vt` where city='Hinesburg' && SIC_code='5261'DB:business_master_new
loadtime:0.23283410072327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington' limit 1
loadtime:0.23288202285767 / seconds
Query Executed:select id FROM `vt` where city='Huntington' && SIC_code='5261'DB:business_master_new
loadtime:0.23326301574707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyde Park' limit 1
loadtime:0.23330402374268 / seconds
Query Executed:select id FROM `vt` where city='Hyde Park' && SIC_code='5261'DB:business_master_new
loadtime:0.23374009132385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hydeville' limit 1
loadtime:0.23379015922546 / seconds
Query Executed:select id FROM `vt` where city='Hydeville' && SIC_code='5261'DB:business_master_new
loadtime:0.23415398597717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irasburg' limit 1
loadtime:0.23418307304382 / seconds
Query Executed:select id FROM `vt` where city='Irasburg' && SIC_code='5261'DB:business_master_new
loadtime:0.23458504676819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Island Pond' limit 1
loadtime:0.23463416099548 / seconds
Query Executed:select id FROM `vt` where city='Island Pond' && SIC_code='5261'DB:business_master_new
loadtime:0.23504304885864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isle La Motte' limit 1
loadtime:0.2350709438324 / seconds
Query Executed:select id FROM `vt` where city='Isle La Motte' && SIC_code='5261'DB:business_master_new
loadtime:0.23542904853821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jacksonville' limit 1
loadtime:0.23546504974365 / seconds
Query Executed:select id FROM `vt` where city='Jacksonville' && SIC_code='5261'DB:business_master_new
loadtime:0.23587012290955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica' limit 1
loadtime:0.23592209815979 / seconds
Query Executed:select id FROM `vt` where city='Jamaica' && SIC_code='5261'DB:business_master_new
loadtime:0.23631405830383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jay' limit 1
loadtime:0.23634314537048 / seconds
Query Executed:select id FROM `vt` where city='Jay' && SIC_code='5261'DB:business_master_new
loadtime:0.23658394813538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jeffersonville' limit 1
loadtime:0.23661994934082 / seconds
Query Executed:select id FROM `vt` where city='Jeffersonville' && SIC_code='5261'DB:business_master_new
loadtime:0.23704195022583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jericho' limit 1
loadtime:0.23708200454712 / seconds
Query Executed:select id FROM `vt` where city='Jericho' && SIC_code='5261'DB:business_master_new
loadtime:0.23756098747253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jericho Center' limit 1
loadtime:0.23761916160583 / seconds
Query Executed:select id FROM `vt` where city='Jericho Center' && SIC_code='5261'DB:business_master_new
loadtime:0.23787713050842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnson' limit 1
loadtime:0.23791313171387 / seconds
Query Executed:select id FROM `vt` where city='Johnson' && SIC_code='5261'DB:business_master_new
loadtime:0.23832416534424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:0.23836016654968 / seconds
Query Executed:select id FROM `vt` where city='Jonesville' && SIC_code='5261'DB:business_master_new
loadtime:0.23870515823364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Killington' limit 1
loadtime:0.23874115943909 / seconds
Query Executed:select id FROM `vt` where city='Killington' && SIC_code='5261'DB:business_master_new
loadtime:0.23919105529785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Elmore' limit 1
loadtime:0.2392270565033 / seconds
Query Executed:select id FROM `vt` where city='Lake Elmore' && SIC_code='5261'DB:business_master_new
loadtime:0.23963308334351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemington' limit 1
loadtime:0.23967695236206 / seconds
Query Executed:select id FROM `vt` where city='Lemington' && SIC_code='5261'DB:business_master_new
loadtime:0.23992514610291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.23996615409851 / seconds
Query Executed:select id FROM `vt` where city='Lincoln' && SIC_code='5261'DB:business_master_new
loadtime:0.24019908905029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Londonderry' limit 1
loadtime:0.24023413658142 / seconds
Query Executed:select id FROM `vt` where city='Londonderry' && SIC_code='5261'DB:business_master_new
loadtime:0.24064517021179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:0.24070000648499 / seconds
Query Executed:select id FROM `vt` where city='Lowell' && SIC_code='5261'DB:business_master_new
loadtime:0.2410671710968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lower Waterford' limit 1
loadtime:0.24110412597656 / seconds
Query Executed:select id FROM `vt` where city='Lower Waterford' && SIC_code='5261'DB:business_master_new
loadtime:0.24146199226379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:0.24149894714355 / seconds
Query Executed:select id FROM `vt` where city='Ludlow' && SIC_code='5261'DB:business_master_new
loadtime:0.24202394485474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:0.2420699596405 / seconds
Query Executed:select id FROM `vt` where city='Lunenburg' && SIC_code='5261'DB:business_master_new
loadtime:0.24243998527527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndon' limit 1
loadtime:0.24248099327087 / seconds
Query Executed:select id FROM `vt` where city='Lyndon' && SIC_code='5261'DB:business_master_new
loadtime:0.24289011955261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndon Center' limit 1
loadtime:0.24294304847717 / seconds
Query Executed:select id FROM `vt` where city='Lyndon Center' && SIC_code='5261'DB:business_master_new
loadtime:0.24332213401794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndonville' limit 1
loadtime:0.24335098266602 / seconds
Query Executed:select id FROM `vt` where city='Lyndonville' && SIC_code='5261'DB:business_master_new
loadtime:0.24383902549744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.24389505386353 / seconds
Query Executed:select id FROM `vt` where city='Manchester' && SIC_code='5261'DB:business_master_new
loadtime:0.24436712265015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester Center' limit 1
loadtime:0.24441313743591 / seconds
Query Executed:select id FROM `vt` where city='Manchester Center' && SIC_code='5261'DB:business_master_new
loadtime:0.2459180355072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester Ctr' limit 1
loadtime:0.24597597122192 / seconds
Query Executed:select id FROM `vt` where city='Manchester Ctr' && SIC_code='5261'DB:business_master_new
loadtime:0.2462329864502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlboro' limit 1
loadtime:0.24628400802612 / seconds
Query Executed:select id FROM `vt` where city='Marlboro' && SIC_code='5261'DB:business_master_new
loadtime:0.24667906761169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield' limit 1
loadtime:0.24672317504883 / seconds
Query Executed:select id FROM `vt` where city='Marshfield' && SIC_code='5261'DB:business_master_new
loadtime:0.24714112281799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Indoe Falls' limit 1
loadtime:0.24718713760376 / seconds
Query Executed:select id FROM `vt` where city='Mc Indoe Falls' && SIC_code='5261'DB:business_master_new
loadtime:0.2475061416626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebury' limit 1
loadtime:0.24754309654236 / seconds
Query Executed:select id FROM `vt` where city='Middlebury' && SIC_code='5261'DB:business_master_new
loadtime:0.24902009963989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown Spgs' limit 1
loadtime:0.24906396865845 / seconds
Query Executed:select id FROM `vt` where city='Middletown Spgs' && SIC_code='5261'DB:business_master_new
loadtime:0.24933004379272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown Springs' limit 1
loadtime:0.24937009811401 / seconds
Query Executed:select id FROM `vt` where city='Middletown Springs' && SIC_code='5261'DB:business_master_new
loadtime:0.24976110458374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:0.24980711936951 / seconds
Query Executed:select id FROM `vt` where city='Milton' && SIC_code='5261'DB:business_master_new
loadtime:0.25036096572876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monkton' limit 1
loadtime:0.2503981590271 / seconds
Query Executed:select id FROM `vt` where city='Monkton' && SIC_code='5261'DB:business_master_new
loadtime:0.25080609321594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery' limit 1
loadtime:0.25085711479187 / seconds
Query Executed:select id FROM `vt` where city='Montgomery' && SIC_code='5261'DB:business_master_new
loadtime:0.25121903419495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery Center' limit 1
loadtime:0.25125312805176 / seconds
Query Executed:select id FROM `vt` where city='Montgomery Center' && SIC_code='5261'DB:business_master_new
loadtime:0.25167012214661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery Ctr' limit 1
loadtime:0.25171494483948 / seconds
Query Executed:select id FROM `vt` where city='Montgomery Ctr' && SIC_code='5261'DB:business_master_new
loadtime:0.25197410583496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:0.25201511383057 / seconds
Query Executed:select id FROM `vt` where city='Montpelier' && SIC_code='5261'DB:business_master_new
loadtime:0.25350308418274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moretown' limit 1
loadtime:0.25356197357178 / seconds
Query Executed:select id FROM `vt` where city='Moretown' && SIC_code='5261'DB:business_master_new
loadtime:0.25399994850159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morgan' limit 1
loadtime:0.25404500961304 / seconds
Query Executed:select id FROM `vt` where city='Morgan' && SIC_code='5261'DB:business_master_new
loadtime:0.25439715385437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisville' limit 1
loadtime:0.25443506240845 / seconds
Query Executed:select id FROM `vt` where city='Morrisville' && SIC_code='5261'DB:business_master_new
loadtime:0.25504899024963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moscow' limit 1
loadtime:0.25510597229004 / seconds
Query Executed:select id FROM `vt` where city='Moscow' && SIC_code='5261'DB:business_master_new
loadtime:0.25545501708984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Holly' limit 1
loadtime:0.25549411773682 / seconds
Query Executed:select id FROM `vt` where city='Mount Holly' && SIC_code='5261'DB:business_master_new
loadtime:0.25588512420654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Holly' limit 1
loadtime:0.2559289932251 / seconds
Query Executed:select id FROM `vt` where city='Mt Holly' && SIC_code='5261'DB:business_master_new
loadtime:0.25619411468506 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Springfield' limit 1
loadtime:0.25622200965881 / seconds
Query Executed:select id FROM `vt` where city='N Springfield' && SIC_code='5261'DB:business_master_new
loadtime:0.25659704208374 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Haven' limit 1
loadtime:0.25664615631104 / seconds
Query Executed:select id FROM `vt` where city='New Haven' && SIC_code='5261'DB:business_master_new
loadtime:0.25710201263428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbury' limit 1
loadtime:0.25715494155884 / seconds
Query Executed:select id FROM `vt` where city='Newbury' && SIC_code='5261'DB:business_master_new
loadtime:0.25752115249634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newfane' limit 1
loadtime:0.25756216049194 / seconds
Query Executed:select id FROM `vt` where city='Newfane' && SIC_code='5261'DB:business_master_new
loadtime:0.25798106193542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:0.25803303718567 / seconds
Query Executed:select id FROM `vt` where city='Newport' && SIC_code='5261'DB:business_master_new
loadtime:0.25865197181702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport Center' limit 1
loadtime:0.25869703292847 / seconds
Query Executed:select id FROM `vt` where city='Newport Center' && SIC_code='5261'DB:business_master_new
loadtime:0.25908493995667 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Bennington' limit 1
loadtime:0.25914406776428 / seconds
Query Executed:select id FROM `vt` where city='North Bennington' && SIC_code='5261'DB:business_master_new
loadtime:0.25960206985474 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chittenden' limit 1
loadtime:0.25964713096619 / seconds
Query Executed:select id FROM `vt` where city='North Chittenden' && SIC_code='5261'DB:business_master_new
loadtime:0.25985813140869 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Clarendon' limit 1
loadtime:0.2598991394043 / seconds
Query Executed:select id FROM `vt` where city='North Clarendon' && SIC_code='5261'DB:business_master_new
loadtime:0.26029205322266 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Concord' limit 1
loadtime:0.2603280544281 / seconds
Query Executed:select id FROM `vt` where city='North Concord' && SIC_code='5261'DB:business_master_new
loadtime:0.26066493988037 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Ferrisburg' limit 1
loadtime:0.26070213317871 / seconds
Query Executed:select id FROM `vt` where city='North Ferrisburg' && SIC_code='5261'DB:business_master_new
loadtime:0.26093912124634 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hartland' limit 1
loadtime:0.26097702980042 / seconds
Query Executed:select id FROM `vt` where city='North Hartland' && SIC_code='5261'DB:business_master_new
loadtime:0.26131916046143 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hero' limit 1
loadtime:0.26134514808655 / seconds
Query Executed:select id FROM `vt` where city='North Hero' && SIC_code='5261'DB:business_master_new
loadtime:0.26173615455627 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hyde Park' limit 1
loadtime:0.26178503036499 / seconds
Query Executed:select id FROM `vt` where city='North Hyde Park' && SIC_code='5261'DB:business_master_new
loadtime:0.26215004920959 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Montpelier' limit 1
loadtime:0.26217913627625 / seconds
Query Executed:select id FROM `vt` where city='North Montpelier' && SIC_code='5261'DB:business_master_new
loadtime:0.26247000694275 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pomfret' limit 1
loadtime:0.26250696182251 / seconds
Query Executed:select id FROM `vt` where city='North Pomfret' && SIC_code='5261'DB:business_master_new
loadtime:0.2628870010376 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pownal' limit 1
loadtime:0.26292395591736 / seconds
Query Executed:select id FROM `vt` where city='North Pownal' && SIC_code='5261'DB:business_master_new
loadtime:0.26326394081116 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Springfield' limit 1
loadtime:0.2633171081543 / seconds
Query Executed:select id FROM `vt` where city='North Springfield' && SIC_code='5261'DB:business_master_new
loadtime:0.26375412940979 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Thetford' limit 1
loadtime:0.26380705833435 / seconds
Query Executed:select id FROM `vt` where city='North Thetford' && SIC_code='5261'DB:business_master_new
loadtime:0.2641429901123 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Troy' limit 1
loadtime:0.26417016983032 / seconds
Query Executed:select id FROM `vt` where city='North Troy' && SIC_code='5261'DB:business_master_new
loadtime:0.26458406448364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:0.26463198661804 / seconds
Query Executed:select id FROM `vt` where city='Northfield' && SIC_code='5261'DB:business_master_new
loadtime:0.26511001586914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield Falls' limit 1
loadtime:0.26514601707458 / seconds
Query Executed:select id FROM `vt` where city='Northfield Falls' && SIC_code='5261'DB:business_master_new
loadtime:0.26549911499023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:0.26553702354431 / seconds
Query Executed:select id FROM `vt` where city='Norton' && SIC_code='5261'DB:business_master_new
loadtime:0.26592111587524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwich' limit 1
loadtime:0.26596808433533 / seconds
Query Executed:select id FROM `vt` where city='Norwich' && SIC_code='5261'DB:business_master_new
loadtime:0.26642894744873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:0.26647400856018 / seconds
Query Executed:select id FROM `vt` where city='Orange' && SIC_code='5261'DB:business_master_new
loadtime:0.26672005653381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orleans' limit 1
loadtime:0.26675295829773 / seconds
Query Executed:select id FROM `vt` where city='Orleans' && SIC_code='5261'DB:business_master_new
loadtime:0.26714205741882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orwell' limit 1
loadtime:0.26718211174011 / seconds
Query Executed:select id FROM `vt` where city='Orwell' && SIC_code='5261'DB:business_master_new
loadtime:0.26761698722839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Passumpsic' limit 1
loadtime:0.26766204833984 / seconds
Query Executed:select id FROM `vt` where city='Passumpsic' && SIC_code='5261'DB:business_master_new
loadtime:0.26792311668396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pawlet' limit 1
loadtime:0.26796317100525 / seconds
Query Executed:select id FROM `vt` where city='Pawlet' && SIC_code='5261'DB:business_master_new
loadtime:0.26833009719849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peacham' limit 1
loadtime:0.26835799217224 / seconds
Query Executed:select id FROM `vt` where city='Peacham' && SIC_code='5261'DB:business_master_new
loadtime:0.26872801780701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perkinsville' limit 1
loadtime:0.26877593994141 / seconds
Query Executed:select id FROM `vt` where city='Perkinsville' && SIC_code='5261'DB:business_master_new
loadtime:0.26917600631714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peru' limit 1
loadtime:0.26921415328979 / seconds
Query Executed:select id FROM `vt` where city='Peru' && SIC_code='5261'DB:business_master_new
loadtime:0.26959896087646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsfield' limit 1
loadtime:0.26964807510376 / seconds
Query Executed:select id FROM `vt` where city='Pittsfield' && SIC_code='5261'DB:business_master_new
loadtime:0.27004098892212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsford' limit 1
loadtime:0.27008605003357 / seconds
Query Executed:select id FROM `vt` where city='Pittsford' && SIC_code='5261'DB:business_master_new
loadtime:0.27055215835571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:0.27060794830322 / seconds
Query Executed:select id FROM `vt` where city='Plainfield' && SIC_code='5261'DB:business_master_new
loadtime:0.27103400230408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.27107906341553 / seconds
Query Executed:select id FROM `vt` where city='Plymouth' && SIC_code='5261'DB:business_master_new
loadtime:0.27143216133118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Post Mills' limit 1
loadtime:0.27146100997925 / seconds
Query Executed:select id FROM `vt` where city='Post Mills' && SIC_code='5261'DB:business_master_new
loadtime:0.27182006835938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poultney' limit 1
loadtime:0.27187204360962 / seconds
Query Executed:select id FROM `vt` where city='Poultney' && SIC_code='5261'DB:business_master_new
loadtime:0.27229595184326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pownal' limit 1
loadtime:0.2723331451416 / seconds
Query Executed:select id FROM `vt` where city='Pownal' && SIC_code='5261'DB:business_master_new
loadtime:0.27273607254028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Proctor' limit 1
loadtime:0.27278208732605 / seconds
Query Executed:select id FROM `vt` where city='Proctor' && SIC_code='5261'DB:business_master_new
loadtime:0.27318000793457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Proctorsville' limit 1
loadtime:0.2732081413269 / seconds
Query Executed:select id FROM `vt` where city='Proctorsville' && SIC_code='5261'DB:business_master_new
loadtime:0.2736120223999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Putney' limit 1
loadtime:0.27366614341736 / seconds
Query Executed:select id FROM `vt` where city='Putney' && SIC_code='5261'DB:business_master_new
loadtime:0.27413201332092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quechee' limit 1
loadtime:0.27417802810669 / seconds
Query Executed:select id FROM `vt` where city='Quechee' && SIC_code='5261'DB:business_master_new
loadtime:0.2746319770813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:0.27468109130859 / seconds
Query Executed:select id FROM `vt` where city='Randolph' && SIC_code='5261'DB:business_master_new
loadtime:0.27518105506897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph Center' limit 1
loadtime:0.27521705627441 / seconds
Query Executed:select id FROM `vt` where city='Randolph Center' && SIC_code='5261'DB:business_master_new
loadtime:0.27562212944031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reading' limit 1
loadtime:0.27566909790039 / seconds
Query Executed:select id FROM `vt` where city='Reading' && SIC_code='5261'DB:business_master_new
loadtime:0.2760751247406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readsboro' limit 1
loadtime:0.27612614631653 / seconds
Query Executed:select id FROM `vt` where city='Readsboro' && SIC_code='5261'DB:business_master_new
loadtime:0.2765519618988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richford' limit 1
loadtime:0.27658915519714 / seconds
Query Executed:select id FROM `vt` where city='Richford' && SIC_code='5261'DB:business_master_new
loadtime:0.27699112892151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:0.27703905105591 / seconds
Query Executed:select id FROM `vt` where city='Richmond' && SIC_code='5261'DB:business_master_new
loadtime:0.27749514579773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ripton' limit 1
loadtime:0.27753305435181 / seconds
Query Executed:select id FROM `vt` where city='Ripton' && SIC_code='5261'DB:business_master_new
loadtime:0.27789497375488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:0.27794194221497 / seconds
Query Executed:select id FROM `vt` where city='Rochester' && SIC_code='5261'DB:business_master_new
loadtime:0.27832007408142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:0.2783579826355 / seconds
Query Executed:select id FROM `vt` where city='Roxbury' && SIC_code='5261'DB:business_master_new
loadtime:0.27873706817627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rupert' limit 1
loadtime:0.27878212928772 / seconds
Query Executed:select id FROM `vt` where city='Rupert' && SIC_code='5261'DB:business_master_new
loadtime:0.27915096282959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:0.2791850566864 / seconds
Query Executed:select id FROM `vt` where city='Rutland' && SIC_code='5261'DB:business_master_new
loadtime:0.28068399429321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ryegate' limit 1
loadtime:0.28074502944946 / seconds
Query Executed:select id FROM `vt` where city='Ryegate' && SIC_code='5261'DB:business_master_new
loadtime:0.2810480594635 / seconds
Query loaded from cache:select * from geodata_geocity where city='S Londonderry' limit 1
loadtime:0.28107810020447 / seconds
Query Executed:select id FROM `vt` where city='S Londonderry' && SIC_code='5261'DB:business_master_new
loadtime:0.28144502639771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Albans' limit 1
loadtime:0.28148508071899 / seconds
Query Executed:select id FROM `vt` where city='Saint Albans' && SIC_code='5261'DB:business_master_new
loadtime:0.2829761505127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Albans Bay' limit 1
loadtime:0.2830331325531 / seconds
Query Executed:select id FROM `vt` where city='Saint Albans Bay' && SIC_code='5261'DB:business_master_new
loadtime:0.28341197967529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johnsbury' limit 1
loadtime:0.28345203399658 / seconds
Query Executed:select id FROM `vt` where city='Saint Johnsbury' && SIC_code='5261'DB:business_master_new
loadtime:0.28494715690613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johnsbury Center' limit 1
loadtime:0.284991979599 / seconds
Query Executed:select id FROM `vt` where city='Saint Johnsbury Center' && SIC_code='5261'DB:business_master_new
loadtime:0.28539109230042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:0.28543901443481 / seconds
Query Executed:select id FROM `vt` where city='Salisbury' && SIC_code='5261'DB:business_master_new
loadtime:0.28587913513184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxtons River' limit 1
loadtime:0.2859320640564 / seconds
Query Executed:select id FROM `vt` where city='Saxtons River' && SIC_code='5261'DB:business_master_new
loadtime:0.28629803657532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaftsbury' limit 1
loadtime:0.28632497787476 / seconds
Query Executed:select id FROM `vt` where city='Shaftsbury' && SIC_code='5261'DB:business_master_new
loadtime:0.28676915168762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.28682398796082 / seconds
Query Executed:select id FROM `vt` where city='Sharon' && SIC_code='5261'DB:business_master_new
loadtime:0.28720307350159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheffield' limit 1
loadtime:0.28723907470703 / seconds
Query Executed:select id FROM `vt` where city='Sheffield' && SIC_code='5261'DB:business_master_new
loadtime:0.28762602806091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelburne' limit 1
loadtime:0.28767609596252 / seconds
Query Executed:select id FROM `vt` where city='Shelburne' && SIC_code='5261'DB:business_master_new
loadtime:0.28830194473267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon' limit 1
loadtime:0.2883620262146 / seconds
Query Executed:select id FROM `vt` where city='Sheldon' && SIC_code='5261'DB:business_master_new
loadtime:0.28876996040344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon Springs' limit 1
loadtime:0.28882217407227 / seconds
Query Executed:select id FROM `vt` where city='Sheldon Springs' && SIC_code='5261'DB:business_master_new
loadtime:0.28920316696167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shoreham' limit 1
loadtime:0.28923106193542 / seconds
Query Executed:select id FROM `vt` where city='Shoreham' && SIC_code='5261'DB:business_master_new
loadtime:0.28967094421387 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Barre' limit 1
loadtime:0.28971409797668 / seconds
Query Executed:select id FROM `vt` where city='South Barre' && SIC_code='5261'DB:business_master_new
loadtime:0.29009914398193 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Burlington' limit 1
loadtime:0.29013204574585 / seconds
Query Executed:select id FROM `vt` where city='South Burlington' && SIC_code='5261'DB:business_master_new
loadtime:0.29160809516907 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hero' limit 1
loadtime:0.29163312911987 / seconds
Query Executed:select id FROM `vt` where city='South Hero' && SIC_code='5261'DB:business_master_new
loadtime:0.29211115837097 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Londonderry' limit 1
loadtime:0.29216814041138 / seconds
Query Executed:select id FROM `vt` where city='South Londonderry' && SIC_code='5261'DB:business_master_new
loadtime:0.29259204864502 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Newfane' limit 1
loadtime:0.29262900352478 / seconds
Query Executed:select id FROM `vt` where city='South Newfane' && SIC_code='5261'DB:business_master_new
loadtime:0.29297614097595 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Pomfret' limit 1
loadtime:0.29302501678467 / seconds
Query Executed:select id FROM `vt` where city='South Pomfret' && SIC_code='5261'DB:business_master_new
loadtime:0.2934091091156 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Royalton' limit 1
loadtime:0.29343795776367 / seconds
Query Executed:select id FROM `vt` where city='South Royalton' && SIC_code='5261'DB:business_master_new
loadtime:0.29386711120605 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Ryegate' limit 1
loadtime:0.29392313957214 / seconds
Query Executed:select id FROM `vt` where city='South Ryegate' && SIC_code='5261'DB:business_master_new
loadtime:0.29428815841675 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Strafford' limit 1
loadtime:0.29431700706482 / seconds
Query Executed:select id FROM `vt` where city='South Strafford' && SIC_code='5261'DB:business_master_new
loadtime:0.29468107223511 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Woodstock' limit 1
loadtime:0.29472804069519 / seconds
Query Executed:select id FROM `vt` where city='South Woodstock' && SIC_code='5261'DB:business_master_new
loadtime:0.29509115219116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.29512810707092 / seconds
Query Executed:select id FROM `vt` where city='Springfield' && SIC_code='5261'DB:business_master_new
loadtime:0.2966320514679 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Albans' limit 1
loadtime:0.2966890335083 / seconds
Query Executed:select id FROM `vt` where city='St Albans' && SIC_code='5261'DB:business_master_new
loadtime:0.29708409309387 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Albans Bay' limit 1
loadtime:0.29712915420532 / seconds
Query Executed:select id FROM `vt` where city='St Albans Bay' && SIC_code='5261'DB:business_master_new
loadtime:0.2974591255188 / seconds
Query loaded from cache:select * from geodata_geocity where city='St George' limit 1
loadtime:0.29749894142151 / seconds
Query Executed:select id FROM `vt` where city='St George' && SIC_code='5261'DB:business_master_new
loadtime:0.29774713516235 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johnsbury' limit 1
loadtime:0.29777312278748 / seconds
Query Executed:select id FROM `vt` where city='St Johnsbury' && SIC_code='5261'DB:business_master_new
loadtime:0.29816508293152 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johnsbury Ctr' limit 1
loadtime:0.2981960773468 / seconds
Query Executed:select id FROM `vt` where city='St Johnsbury Ctr' && SIC_code='5261'DB:business_master_new
loadtime:0.29842305183411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stamford' limit 1
loadtime:0.29846000671387 / seconds
Query Executed:select id FROM `vt` where city='Stamford' && SIC_code='5261'DB:business_master_new
loadtime:0.29882502555847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Starksboro' limit 1
loadtime:0.29886102676392 / seconds
Query Executed:select id FROM `vt` where city='Starksboro' && SIC_code='5261'DB:business_master_new
loadtime:0.29923105239868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockbridge' limit 1
loadtime:0.29926705360413 / seconds
Query Executed:select id FROM `vt` where city='Stockbridge' && SIC_code='5261'DB:business_master_new
loadtime:0.2996621131897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stowe' limit 1
loadtime:0.29971098899841 / seconds
Query Executed:select id FROM `vt` where city='Stowe' && SIC_code='5261'DB:business_master_new
loadtime:0.30118894577026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strafford' limit 1
loadtime:0.30123710632324 / seconds
Query Executed:select id FROM `vt` where city='Strafford' && SIC_code='5261'DB:business_master_new
loadtime:0.30162715911865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutton' limit 1
loadtime:0.301677942276 / seconds
Query Executed:select id FROM `vt` where city='Sutton' && SIC_code='5261'DB:business_master_new
loadtime:0.30206799507141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swanton' limit 1
loadtime:0.30211400985718 / seconds
Query Executed:select id FROM `vt` where city='Swanton' && SIC_code='5261'DB:business_master_new
loadtime:0.30264115333557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taftsville' limit 1
loadtime:0.30268597602844 / seconds
Query Executed:select id FROM `vt` where city='Taftsville' && SIC_code='5261'DB:business_master_new
loadtime:0.30304598808289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thetford' limit 1
loadtime:0.30308604240417 / seconds
Query Executed:select id FROM `vt` where city='Thetford' && SIC_code='5261'DB:business_master_new
loadtime:0.30345106124878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thetford Center' limit 1
loadtime:0.30347800254822 / seconds
Query Executed:select id FROM `vt` where city='Thetford Center' && SIC_code='5261'DB:business_master_new
loadtime:0.30389404296875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topsham' limit 1
loadtime:0.30395102500916 / seconds
Query Executed:select id FROM `vt` where city='Topsham' && SIC_code='5261'DB:business_master_new
loadtime:0.3042631149292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townshend' limit 1
loadtime:0.30431294441223 / seconds
Query Executed:select id FROM `vt` where city='Townshend' && SIC_code='5261'DB:business_master_new
loadtime:0.30471515655518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:0.30476903915405 / seconds
Query Executed:select id FROM `vt` where city='Troy' && SIC_code='5261'DB:business_master_new
loadtime:0.30514311790466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tunbridge' limit 1
loadtime:0.30517101287842 / seconds
Query Executed:select id FROM `vt` where city='Tunbridge' && SIC_code='5261'DB:business_master_new
loadtime:0.30558395385742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Underhill' limit 1
loadtime:0.3056321144104 / seconds
Query Executed:select id FROM `vt` where city='Underhill' && SIC_code='5261'DB:business_master_new
loadtime:0.30605506896973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Underhill Center' limit 1
loadtime:0.30610108375549 / seconds
Query Executed:select id FROM `vt` where city='Underhill Center' && SIC_code='5261'DB:business_master_new
loadtime:0.3064661026001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vergennes' limit 1
loadtime:0.30650615692139 / seconds
Query Executed:select id FROM `vt` where city='Vergennes' && SIC_code='5261'DB:business_master_new
loadtime:0.30701613426208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:0.30706095695496 / seconds
Query Executed:select id FROM `vt` where city='Vernon' && SIC_code='5261'DB:business_master_new
loadtime:0.30746698379517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vershire' limit 1
loadtime:0.3074951171875 / seconds
Query Executed:select id FROM `vt` where city='Vershire' && SIC_code='5261'DB:business_master_new
loadtime:0.30786108970642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waitsfield' limit 1
loadtime:0.30790901184082 / seconds
Query Executed:select id FROM `vt` where city='Waitsfield' && SIC_code='5261'DB:business_master_new
loadtime:0.30843997001648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallingford' limit 1
loadtime:0.30848598480225 / seconds
Query Executed:select id FROM `vt` where city='Wallingford' && SIC_code='5261'DB:business_master_new
loadtime:0.30893802642822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wardsboro' limit 1
loadtime:0.30898308753967 / seconds
Query Executed:select id FROM `vt` where city='Wardsboro' && SIC_code='5261'DB:business_master_new
loadtime:0.30933904647827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:0.30937910079956 / seconds
Query Executed:select id FROM `vt` where city='Warren' && SIC_code='5261'DB:business_master_new
loadtime:0.30982804298401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.30987215042114 / seconds
Query Executed:select id FROM `vt` where city='Washington' && SIC_code='5261'DB:business_master_new
loadtime:0.31028008460999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury' limit 1
loadtime:0.31032800674438 / seconds
Query Executed:select id FROM `vt` where city='Waterbury' && SIC_code='5261'DB:business_master_new
loadtime:0.3108971118927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury Center' limit 1
loadtime:0.31095099449158 / seconds
Query Executed:select id FROM `vt` where city='Waterbury Center' && SIC_code='5261'DB:business_master_new
loadtime:0.31137299537659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville' limit 1
loadtime:0.31142711639404 / seconds
Query Executed:select id FROM `vt` where city='Waterville' && SIC_code='5261'DB:business_master_new
loadtime:0.31182312965393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Websterville' limit 1
loadtime:0.3118679523468 / seconds
Query Executed:select id FROM `vt` where city='Websterville' && SIC_code='5261'DB:business_master_new
loadtime:0.31225800514221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wells' limit 1
loadtime:0.31230998039246 / seconds
Query Executed:select id FROM `vt` where city='Wells' && SIC_code='5261'DB:business_master_new
loadtime:0.31268095970154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wells River' limit 1
loadtime:0.31271696090698 / seconds
Query Executed:select id FROM `vt` where city='Wells River' && SIC_code='5261'DB:business_master_new
loadtime:0.31309509277344 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Burke' limit 1
loadtime:0.3131320476532 / seconds
Query Executed:select id FROM `vt` where city='West Burke' && SIC_code='5261'DB:business_master_new
loadtime:0.31355500221252 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Charleston' limit 1
loadtime:0.31359100341797 / seconds
Query Executed:select id FROM `vt` where city='West Charleston' && SIC_code='5261'DB:business_master_new
loadtime:0.31398296356201 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Danville' limit 1
loadtime:0.31403994560242 / seconds
Query Executed:select id FROM `vt` where city='West Danville' && SIC_code='5261'DB:business_master_new
loadtime:0.31440496444702 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dover' limit 1
loadtime:0.31443309783936 / seconds
Query Executed:select id FROM `vt` where city='West Dover' && SIC_code='5261'DB:business_master_new
loadtime:0.31487107276917 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dummerston' limit 1
loadtime:0.31491899490356 / seconds
Query Executed:select id FROM `vt` where city='West Dummerston' && SIC_code='5261'DB:business_master_new
loadtime:0.31525111198425 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Fairlee' limit 1
loadtime:0.31529998779297 / seconds
Query Executed:select id FROM `vt` where city='West Fairlee' && SIC_code='5261'DB:business_master_new
loadtime:0.31570506095886 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Glover' limit 1
loadtime:0.315749168396 / seconds
Query Executed:select id FROM `vt` where city='West Glover' && SIC_code='5261'DB:business_master_new
loadtime:0.31598114967346 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Halifax' limit 1
loadtime:0.31602096557617 / seconds
Query Executed:select id FROM `vt` where city='West Halifax' && SIC_code='5261'DB:business_master_new
loadtime:0.31638216972351 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartford' limit 1
loadtime:0.31642007827759 / seconds
Query Executed:select id FROM `vt` where city='West Hartford' && SIC_code='5261'DB:business_master_new
loadtime:0.3167941570282 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Marlboro' limit 1
loadtime:0.31683111190796 / seconds
Query Executed:select id FROM `vt` where city='West Marlboro' && SIC_code='5261'DB:business_master_new
loadtime:0.3170690536499 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newbury' limit 1
loadtime:0.31710410118103 / seconds
Query Executed:select id FROM `vt` where city='West Newbury' && SIC_code='5261'DB:business_master_new
loadtime:0.31742906570435 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Pawlet' limit 1
loadtime:0.31745600700378 / seconds
Query Executed:select id FROM `vt` where city='West Pawlet' && SIC_code='5261'DB:business_master_new
loadtime:0.31786608695984 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Rupert' limit 1
loadtime:0.31791496276855 / seconds
Query Executed:select id FROM `vt` where city='West Rupert' && SIC_code='5261'DB:business_master_new
loadtime:0.31826615333557 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Rutland' limit 1
loadtime:0.31831002235413 / seconds
Query Executed:select id FROM `vt` where city='West Rutland' && SIC_code='5261'DB:business_master_new
loadtime:0.31873202323914 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Topsham' limit 1
loadtime:0.31878113746643 / seconds
Query Executed:select id FROM `vt` where city='West Topsham' && SIC_code='5261'DB:business_master_new
loadtime:0.31913208961487 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Townshend' limit 1
loadtime:0.319167137146 / seconds
Query Executed:select id FROM `vt` where city='West Townshend' && SIC_code='5261'DB:business_master_new
loadtime:0.31956601142883 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Wardsboro' limit 1
loadtime:0.31960916519165 / seconds
Query Executed:select id FROM `vt` where city='West Wardsboro' && SIC_code='5261'DB:business_master_new
loadtime:0.31998205184937 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Windsor' limit 1
loadtime:0.32003116607666 / seconds
Query Executed:select id FROM `vt` where city='West Windsor' && SIC_code='5261'DB:business_master_new
loadtime:0.32028102874756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:0.32032108306885 / seconds
Query Executed:select id FROM `vt` where city='Westfield' && SIC_code='5261'DB:business_master_new
loadtime:0.32070112228394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westford' limit 1
loadtime:0.32074594497681 / seconds
Query Executed:select id FROM `vt` where city='Westford' && SIC_code='5261'DB:business_master_new
loadtime:0.32114505767822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:0.3211829662323 / seconds
Query Executed:select id FROM `vt` where city='Westminster' && SIC_code='5261'DB:business_master_new
loadtime:0.32158613204956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster Sta' limit 1
loadtime:0.32162308692932 / seconds
Query Executed:select id FROM `vt` where city='Westminster Sta' && SIC_code='5261'DB:business_master_new
loadtime:0.32186508178711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster Station' limit 1
loadtime:0.3219051361084 / seconds
Query Executed:select id FROM `vt` where city='Westminster Station' && SIC_code='5261'DB:business_master_new
loadtime:0.32225298881531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:0.32230114936829 / seconds
Query Executed:select id FROM `vt` where city='Weston' && SIC_code='5261'DB:business_master_new
loadtime:0.32271814346313 / seconds
Query loaded from cache:select * from geodata_geocity where city='White River Jct' limit 1
loadtime:0.3227641582489 / seconds
Query Executed:select id FROM `vt` where city='White River Jct' && SIC_code='5261'DB:business_master_new
loadtime:0.32310700416565 / seconds
Query loaded from cache:select * from geodata_geocity where city='White River Junction' limit 1
loadtime:0.32314300537109 / seconds
Query Executed:select id FROM `vt` where city='White River Junction' && SIC_code='5261'DB:business_master_new
loadtime:0.32463502883911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiting' limit 1
loadtime:0.32469511032104 / seconds
Query Executed:select id FROM `vt` where city='Whiting' && SIC_code='5261'DB:business_master_new
loadtime:0.32507514953613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitingham' limit 1
loadtime:0.32510304450989 / seconds
Query Executed:select id FROM `vt` where city='Whitingham' && SIC_code='5261'DB:business_master_new
loadtime:0.32548308372498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilder' limit 1
loadtime:0.3255181312561 / seconds
Query Executed:select id FROM `vt` where city='Wilder' && SIC_code='5261'DB:business_master_new
loadtime:0.32594513893127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamstown' limit 1
loadtime:0.32598900794983 / seconds
Query Executed:select id FROM `vt` where city='Williamstown' && SIC_code='5261'DB:business_master_new
loadtime:0.32639002799988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsville' limit 1
loadtime:0.32642912864685 / seconds
Query Executed:select id FROM `vt` where city='Williamsville' && SIC_code='5261'DB:business_master_new
loadtime:0.32682204246521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williston' limit 1
loadtime:0.32686614990234 / seconds
Query Executed:select id FROM `vt` where city='Williston' && SIC_code='5261'DB:business_master_new
loadtime:0.32836294174194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmington' limit 1
loadtime:0.32842397689819 / seconds
Query Executed:select id FROM `vt` where city='Wilmington' && SIC_code='5261'DB:business_master_new
loadtime:0.3289110660553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:0.32895708084106 / seconds
Query Executed:select id FROM `vt` where city='Windsor' && SIC_code='5261'DB:business_master_new
loadtime:0.32945013046265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winooski' limit 1
loadtime:0.32949709892273 / seconds
Query Executed:select id FROM `vt` where city='Winooski' && SIC_code='5261'DB:business_master_new
loadtime:0.32998514175415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolcott' limit 1
loadtime:0.33002901077271 / seconds
Query Executed:select id FROM `vt` where city='Wolcott' && SIC_code='5261'DB:business_master_new
loadtime:0.33045411109924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbury' limit 1
loadtime:0.33050107955933 / seconds
Query Executed:select id FROM `vt` where city='Woodbury' && SIC_code='5261'DB:business_master_new
loadtime:0.33087801933289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:0.33092308044434 / seconds
Query Executed:select id FROM `vt` where city='Woodstock' && SIC_code='5261'DB:business_master_new
loadtime:0.33147001266479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worcester' limit 1
loadtime:0.33150601387024 / seconds
Query Executed:select id FROM `vt` where city='Worcester' && SIC_code='5261'DB:business_master_new
loadtime:0.33191299438477 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.33199715614319 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.33215403556824 / seconds
Operation template executed (chunk cache operation)
loadtime:0.33221817016602 / seconds
template override:Default
loadtime:0.33223509788513 / 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.33304810523987 / seconds
Template Constructed, Array Rows:49
loadtime:0.33329701423645 / seconds
TOTAL EXECUTION TIME: 0.33309
loadtime:0.33338713645935 / 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-nurseries-lawn-and-garden-supply-stores [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.33339095115662
TOTAL KEY ARRAYS: 69