Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:6.2942504882812E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.001755952835083 / seconds
host not found setting manual db connection
loadtime:0.0095398426055908 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0097658634185791 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0099208354949951 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0099749565124512 / seconds
zipcode:
loadtime:0.01000189781189 / seconds
Query Executed:select * from search_referrer where page_hash='281601f22f077f83d959c6570fc6d040' limit 10 DB:ezrox_toadli
loadtime:0.010205030441284 / seconds
Operation header executed (non global)
loadtime:0.010233879089355 / seconds
Operation leaderboard executed (non global)
loadtime:0.010284900665283 / seconds
Operation square executed (non global)
loadtime:0.010313987731934 / seconds
Operation square_bottom executed (non global)
loadtime:0.010341882705688 / seconds
Operation smallsquare executed (non global)
loadtime:0.010366916656494 / seconds
Operation headeradright executed (non global)
loadtime:0.0103919506073 / seconds
Operation google_analytics executed (non global)
loadtime:0.010416984558105 / seconds
Operation topstories executed (non global)
loadtime:0.010442018508911 / seconds
Operation businessnearyou executed (non global)
loadtime:0.01046895980835 / seconds
Operation memberbuscount executed (non global)
loadtime:0.01049280166626 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010783910751343 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011014938354492 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011085987091064 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011176824569702 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011229991912842 / seconds
Template key: archive_menu pushed
loadtime:0.011238813400269 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011253833770752 / seconds
Template key: get_gravatar pushed
loadtime:0.011260986328125 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011271953582764 / seconds
*10)-10)+1 | start:0
loadtime:0.011319875717163 / seconds
Query loaded from cache:select * from categories where cat_URLid='general-contractors-single-family-houses'
loadtime:0.011375904083252 / seconds
DB connected to localhost business_master_new
loadtime:0.011656999588013 / seconds
Query Executed:select * from geodata_usstates where url_id='vermont'DB:business_master_new
loadtime:0.011853933334351 / seconds
Query stored in cache : _QUERY_www.toadli.com05331c972658c0d67adcac8f7c40ed02
loadtime:0.011909961700439 / seconds
Query Executed:select * from `vt_catmap` where sic='1521' order by city ascDB:business_master_new
loadtime:0.026115894317627 / seconds
Query stored in cache : _QUERY_www.toadli.com3a4fab5e32676c89f7a8d72f9e214269
loadtime:0.02742600440979 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='vermont'
loadtime:0.027486801147461 / seconds
Query Executed:select sum(totalcount) as totalsum from `vt_catmap` where sic='1521'DB:business_master_new
loadtime:0.029304027557373 / seconds
Query stored in cache : _QUERY_www.toadli.com5783d79e1812a70d1f14f30787174b1b
loadtime:0.029340028762817 / seconds
321 / 11
loadtime:0.029398918151855 / seconds
Query Executed:select * from geodata_geocity where city='Adamant' limit 1DB:business_master_new
loadtime:0.029827833175659 / seconds
Query stored in cache : _QUERY_www.toadli.com6659fa8891f0a98c80a8e682cbdcf576
loadtime:0.029898881912231 / seconds
Query Executed:select id FROM `vt` where city='Adamant' && SIC_code='1521'DB:business_master_new
loadtime:0.030412912368774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albany' limit 1
loadtime:0.030481815338135 / seconds
Query Executed:select id FROM `vt` where city='Albany' && SIC_code='1521'DB:business_master_new
loadtime:0.031129837036133 / seconds
Query Executed:select * from geodata_geocity where city='Alburg' limit 1DB:business_master_new
loadtime:0.031561851501465 / seconds
Query stored in cache : _QUERY_www.toadli.com9f771e77a3591e9bc2e08fcc0262a3eb
loadtime:0.031637907028198 / seconds
Query Executed:select id FROM `vt` where city='Alburg' && SIC_code='1521'DB:business_master_new
loadtime:0.032080888748169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.032135963439941 / seconds
Query Executed:select id FROM `vt` where city='Arlington' && SIC_code='1521'DB:business_master_new
loadtime:0.035132884979248 / seconds
Query Executed:select * from geodata_geocity where city='Ascutney' limit 1DB:business_master_new
loadtime:0.035562992095947 / seconds
Query stored in cache : _QUERY_www.toadli.comaf509efb8a365884a052eaf0651bc6a7
loadtime:0.035636901855469 / seconds
Query Executed:select id FROM `vt` where city='Ascutney' && SIC_code='1521'DB:business_master_new
loadtime:0.036576986312866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athens' limit 1
loadtime:0.036659955978394 / seconds
Query Executed:select id FROM `vt` where city='Athens' && SIC_code='1521'DB:business_master_new
loadtime:0.037086963653564 / seconds
Query Executed:select * from geodata_geocity where city='Averill' limit 1DB:business_master_new
loadtime:0.037575960159302 / seconds
Query stored in cache : _QUERY_www.toadli.com5c6ff822d2ad6f746b39e323ac9409cd
loadtime:0.037648916244507 / seconds
Query Executed:select id FROM `vt` where city='Averill' && SIC_code='1521'DB:business_master_new
loadtime:0.038096904754639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bakersfield' limit 1
loadtime:0.038151025772095 / seconds
Query Executed:select id FROM `vt` where city='Bakersfield' && SIC_code='1521'DB:business_master_new
loadtime:0.038780927658081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnard' limit 1
loadtime:0.038851022720337 / seconds
Query Executed:select id FROM `vt` where city='Barnard' && SIC_code='1521'DB:business_master_new
loadtime:0.039589881896973 / seconds
Query Executed:select * from geodata_geocity where city='Barnet' limit 1DB:business_master_new
loadtime:0.040066003799438 / seconds
Query stored in cache : _QUERY_www.toadli.comfcdf9621c9e140587f6b939e0e51cb54
loadtime:0.040132999420166 / seconds
Query Executed:select id FROM `vt` where city='Barnet' && SIC_code='1521'DB:business_master_new
loadtime:0.041123867034912 / seconds
Query Executed:select * from geodata_geocity where city='Barre' limit 1DB:business_master_new
loadtime:0.041510820388794 / seconds
Query stored in cache : _QUERY_www.toadli.com3aa0b0fdaee5beb9beeffdfce50f28d7
loadtime:0.041574001312256 / seconds
Query Executed:select id FROM `vt` where city='Barre' && SIC_code='1521'DB:business_master_new
loadtime:0.053501844406128 / seconds
Query Executed:select * from geodata_geocity where city='Barton' limit 1DB:business_master_new
loadtime:0.053959846496582 / seconds
Query stored in cache : _QUERY_www.toadli.com02008e502ef32ff5030ccd7d9b733974
loadtime:0.054025888442993 / seconds
Query Executed:select id FROM `vt` where city='Barton' && SIC_code='1521'DB:business_master_new
loadtime:0.056494951248169 / seconds
Query Executed:select * from geodata_geocity where city='Beebe Plain' limit 1DB:business_master_new
loadtime:0.056955814361572 / seconds
Query stored in cache : _QUERY_www.toadli.com898b1a72aba74af305cb1e9802132e95
loadtime:0.057020902633667 / seconds
Query Executed:select id FROM `vt` where city='Beebe Plain' && SIC_code='1521'DB:business_master_new
loadtime:0.057474851608276 / seconds
Query Executed:select * from geodata_geocity where city='Beecher Falls' limit 1DB:business_master_new
loadtime:0.057889938354492 / seconds
Query stored in cache : _QUERY_www.toadli.com3b4097c43c3483bff68100e40f5470b3
loadtime:0.057955026626587 / seconds
Query Executed:select id FROM `vt` where city='Beecher Falls' && SIC_code='1521'DB:business_master_new
loadtime:0.058462858200073 / seconds
Query Executed:select * from geodata_geocity where city='Bellows Falls' limit 1DB:business_master_new
loadtime:0.058915853500366 / seconds
Query stored in cache : _QUERY_www.toadli.come6ae449f8bf3eec7780f1362b344d22d
loadtime:0.058979988098145 / seconds
Query Executed:select id FROM `vt` where city='Bellows Falls' && SIC_code='1521'DB:business_master_new
loadtime:0.063421010971069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.063503980636597 / seconds
Query Executed:select id FROM `vt` where city='Belmont' && SIC_code='1521'DB:business_master_new
loadtime:0.06414794921875 / seconds
Query Executed:select * from geodata_geocity where city='Belvidere Center' limit 1DB:business_master_new
loadtime:0.06455397605896 / seconds
Query stored in cache : _QUERY_www.toadli.com10a3208f9e09dcbb7e6e973817ec8546
loadtime:0.064627885818481 / seconds
Query Executed:select id FROM `vt` where city='Belvidere Center' && SIC_code='1521'DB:business_master_new
loadtime:0.065054893493652 / seconds
Query Executed:select * from geodata_geocity where city='Bennington' limit 1DB:business_master_new
loadtime:0.065452814102173 / seconds
Query stored in cache : _QUERY_www.toadli.come9e2f0b7cc08ce7530539e911afef039
loadtime:0.065524816513062 / seconds
Query Executed:select id FROM `vt` where city='Bennington' && SIC_code='1521'DB:business_master_new
loadtime:0.076831817626953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benson' limit 1
loadtime:0.076932907104492 / seconds
Query Executed:select id FROM `vt` where city='Benson' && SIC_code='1521'DB:business_master_new
loadtime:0.077485799789429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.077540874481201 / seconds
Query Executed:select id FROM `vt` where city='Berlin' && SIC_code='1521'DB:business_master_new
loadtime:0.078130006790161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethel' limit 1
loadtime:0.078182935714722 / seconds
Query Executed:select id FROM `vt` where city='Bethel' && SIC_code='1521'DB:business_master_new
loadtime:0.080744981765747 / seconds
Query Executed:select * from geodata_geocity where city='Bolton Valley' limit 1DB:business_master_new
loadtime:0.081167936325073 / seconds
Query stored in cache : _QUERY_www.toadli.come0d8254a9664ebe0838c0cc2841166e3
loadtime:0.081234931945801 / seconds
Query Executed:select id FROM `vt` where city='Bolton Valley' && SIC_code='1521'DB:business_master_new
loadtime:0.081687927246094 / seconds
Query Executed:select * from geodata_geocity where city='Bomoseen' limit 1DB:business_master_new
loadtime:0.082098960876465 / seconds
Query stored in cache : _QUERY_www.toadli.com183a9c46eef88cd1bf46f5634db5502a
loadtime:0.082168817520142 / seconds
Query Executed:select id FROM `vt` where city='Bomoseen' && SIC_code='1521'DB:business_master_new
loadtime:0.091092824935913 / seconds
Query Executed:select * from geodata_geocity where city='Bondville' limit 1DB:business_master_new
loadtime:0.09152889251709 / seconds
Query stored in cache : _QUERY_www.toadli.com7a1c2ba62d2b64221dcd952d88c944be
loadtime:0.091598987579346 / seconds
Query Executed:select id FROM `vt` where city='Bondville' && SIC_code='1521'DB:business_master_new
loadtime:0.092652797698975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.092724800109863 / seconds
Query Executed:select id FROM `vt` where city='Bradford' && SIC_code='1521'DB:business_master_new
loadtime:0.095934867858887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.096004962921143 / seconds
Query Executed:select id FROM `vt` where city='Brandon' && SIC_code='1521'DB:business_master_new
loadtime:0.10031390190125 / seconds
Query Executed:select * from geodata_geocity where city='Brattleboro' limit 1DB:business_master_new
loadtime:0.10079598426819 / seconds
Query stored in cache : _QUERY_www.toadli.com2884ece7970de76e3d33c6e2b0dcdf56
loadtime:0.10087084770203 / seconds
Query Executed:select id FROM `vt` where city='Brattleboro' && SIC_code='1521'DB:business_master_new
loadtime:0.11677193641663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.11687898635864 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater' && SIC_code='1521'DB:business_master_new
loadtime:0.11778688430786 / seconds
Query Executed:select * from geodata_geocity where city='Bridgewater Corners' limit 1DB:business_master_new
loadtime:0.11824679374695 / seconds
Query stored in cache : _QUERY_www.toadli.comed365472cbaed14ee3b788e73d716b5c
loadtime:0.11831784248352 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater Corners' && SIC_code='1521'DB:business_master_new
loadtime:0.1191029548645 / seconds
Query Executed:select * from geodata_geocity where city='Bridgewater Cors' limit 1DB:business_master_new
loadtime:0.11955189704895 / seconds
Query stored in cache : _QUERY_www.toadli.com2a47b26324370042113357fd6082d906
loadtime:0.11962890625 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater Cors' && SIC_code='1521'DB:business_master_new
loadtime:0.1200168132782 / seconds
Query Executed:select * from geodata_geocity where city='Bridport' limit 1DB:business_master_new
loadtime:0.12045192718506 / seconds
Query stored in cache : _QUERY_www.toadli.comee65b39a826a97024fd794b6ffdb309e
loadtime:0.12051486968994 / seconds
Query Executed:select id FROM `vt` where city='Bridport' && SIC_code='1521'DB:business_master_new
loadtime:0.12913393974304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.1292028427124 / seconds
Query Executed:select id FROM `vt` where city='Bristol' && SIC_code='1521'DB:business_master_new
loadtime:0.13385581970215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.13394498825073 / seconds
Query Executed:select id FROM `vt` where city='Brookfield' && SIC_code='1521'DB:business_master_new
loadtime:0.13477492332458 / seconds
Query Executed:select * from geodata_geocity where city='Brookline' limit 1DB:business_master_new
loadtime:0.13520193099976 / seconds
Query stored in cache : _QUERY_www.toadli.com32cb85027ec1eaed0a235b38ddfae001
loadtime:0.13526701927185 / seconds
Query Executed:select id FROM `vt` where city='Brookline' && SIC_code='1521'DB:business_master_new
loadtime:0.1356828212738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownsville' limit 1
loadtime:0.13573884963989 / seconds
Query Executed:select id FROM `vt` where city='Brownsville' && SIC_code='1521'DB:business_master_new
loadtime:0.13658499717712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.13665986061096 / seconds
Query Executed:select id FROM `vt` where city='Burlington' && SIC_code='1521'DB:business_master_new
loadtime:0.14540982246399 / seconds
Query Executed:select * from geodata_geocity where city='Cabot' limit 1DB:business_master_new
loadtime:0.14588499069214 / seconds
Query stored in cache : _QUERY_www.toadli.comcddfcd4f01b320536a48ef841e2840e3
loadtime:0.1459538936615 / seconds
Query Executed:select id FROM `vt` where city='Cabot' && SIC_code='1521'DB:business_master_new
loadtime:0.15453600883484 / seconds
Query Executed:select * from geodata_geocity where city='Calais' limit 1DB:business_master_new
loadtime:0.15497994422913 / seconds
Query stored in cache : _QUERY_www.toadli.com0fadba3e274db5181bc7595c791b9cab
loadtime:0.15504479408264 / seconds
Query Executed:select id FROM `vt` where city='Calais' && SIC_code='1521'DB:business_master_new
loadtime:0.15563797950745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:0.15569400787354 / seconds
Query Executed:select id FROM `vt` where city='Cambridge' && SIC_code='1521'DB:business_master_new
loadtime:0.16438889503479 / seconds
Query Executed:select * from geodata_geocity where city='Cambridgeport' limit 1DB:business_master_new
loadtime:0.16483688354492 / seconds
Query stored in cache : _QUERY_www.toadli.com35fd85357c5f73690cfd728c18226353
loadtime:0.16490292549133 / seconds
Query Executed:select id FROM `vt` where city='Cambridgeport' && SIC_code='1521'DB:business_master_new
loadtime:0.1653938293457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canaan' limit 1
loadtime:0.16545987129211 / seconds
Query Executed:select id FROM `vt` where city='Canaan' && SIC_code='1521'DB:business_master_new
loadtime:0.16630482673645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castleton' limit 1
loadtime:0.16637301445007 / seconds
Query Executed:select id FROM `vt` where city='Castleton' && SIC_code='1521'DB:business_master_new
loadtime:0.16899394989014 / seconds
Query Executed:select * from geodata_geocity where city='Cavendish' limit 1DB:business_master_new
loadtime:0.16943001747131 / seconds
Query stored in cache : _QUERY_www.toadli.com5be8c889f5df083bb53f494048762343
loadtime:0.16949486732483 / seconds
Query Executed:select id FROM `vt` where city='Cavendish' && SIC_code='1521'DB:business_master_new
loadtime:0.17039895057678 / seconds
Query Executed:select * from geodata_geocity where city='Center Rutland' limit 1DB:business_master_new
loadtime:0.17086601257324 / seconds
Query stored in cache : _QUERY_www.toadli.come5fbf98cdf7616c2d53574e392db2716
loadtime:0.17093086242676 / seconds
Query Executed:select id FROM `vt` where city='Center Rutland' && SIC_code='1521'DB:business_master_new
loadtime:0.17178082466125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte' limit 1
loadtime:0.17184495925903 / seconds
Query Executed:select id FROM `vt` where city='Charlotte' && SIC_code='1521'DB:business_master_new
loadtime:0.17495679855347 / seconds
Query Executed:select * from geodata_geocity where city='Chelsea' limit 1DB:business_master_new
loadtime:0.17540192604065 / seconds
Query stored in cache : _QUERY_www.toadli.com84f4ab4b5631dc75b3b6d7380c04c81b
loadtime:0.17546796798706 / seconds
Query Executed:select id FROM `vt` where city='Chelsea' && SIC_code='1521'DB:business_master_new
loadtime:0.18408799171448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.18415784835815 / seconds
Query Executed:select id FROM `vt` where city='Chester' && SIC_code='1521'DB:business_master_new
loadtime:0.1885039806366 / seconds
Query Executed:select * from geodata_geocity where city='Chittenden' limit 1DB:business_master_new
loadtime:0.18894791603088 / seconds
Query stored in cache : _QUERY_www.toadli.com42acd08c98f9922b5a3efb27d9c48f03
loadtime:0.18901395797729 / seconds
Query Executed:select id FROM `vt` where city='Chittenden' && SIC_code='1521'DB:business_master_new
loadtime:0.18977880477905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colchester' limit 1
loadtime:0.18985795974731 / seconds
Query Executed:select id FROM `vt` where city='Colchester' && SIC_code='1521'DB:business_master_new
loadtime:0.19996690750122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.2000880241394 / seconds
Query Executed:select id FROM `vt` where city='Concord' && SIC_code='1521'DB:business_master_new
loadtime:0.20102190971375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corinth' limit 1
loadtime:0.20109391212463 / seconds
Query Executed:select id FROM `vt` where city='Corinth' && SIC_code='1521'DB:business_master_new
loadtime:0.20178198814392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coventry' limit 1
loadtime:0.20183992385864 / seconds
Query Executed:select id FROM `vt` where city='Coventry' && SIC_code='1521'DB:business_master_new
loadtime:0.20236301422119 / seconds
Query Executed:select * from geodata_geocity where city='Craftsbury' limit 1DB:business_master_new
loadtime:0.20279383659363 / seconds
Query stored in cache : _QUERY_www.toadli.comb8eef825ff6b23334421afdb22f2ea03
loadtime:0.20286583900452 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury' && SIC_code='1521'DB:business_master_new
loadtime:0.20360493659973 / seconds
Query Executed:select * from geodata_geocity where city='Craftsbury Cmn' limit 1DB:business_master_new
loadtime:0.20403599739075 / seconds
Query stored in cache : _QUERY_www.toadli.com2cbbcdefe01808e0ed7128818459bfc8
loadtime:0.20409989356995 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury Cmn' && SIC_code='1521'DB:business_master_new
loadtime:0.20450401306152 / seconds
Query Executed:select * from geodata_geocity where city='Craftsbury Common' limit 1DB:business_master_new
loadtime:0.20493483543396 / seconds
Query stored in cache : _QUERY_www.toadli.comed23954f83087d3f9eb10c7053629004
loadtime:0.2050039768219 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury Common' && SIC_code='1521'DB:business_master_new
loadtime:0.20569181442261 / seconds
Query Executed:select * from geodata_geocity where city='Cuttingsville' limit 1DB:business_master_new
loadtime:0.20613479614258 / seconds
Query stored in cache : _QUERY_www.toadli.com3c8eaff0c5d14d2608b28399d17b8937
loadtime:0.20619988441467 / seconds
Query Executed:select id FROM `vt` where city='Cuttingsville' && SIC_code='1521'DB:business_master_new
loadtime:0.20723581314087 / seconds
Query Executed:select * from geodata_geocity where city='Danby' limit 1DB:business_master_new
loadtime:0.20765495300293 / seconds
Query stored in cache : _QUERY_www.toadli.come15c6862b1de3afa8e42927e0ed5be21
loadtime:0.20772480964661 / seconds
Query Executed:select id FROM `vt` where city='Danby' && SIC_code='1521'DB:business_master_new
loadtime:0.21636700630188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.21643900871277 / seconds
Query Executed:select id FROM `vt` where city='Danville' && SIC_code='1521'DB:business_master_new
loadtime:0.22510480880737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby' limit 1
loadtime:0.22517800331116 / seconds
Query Executed:select id FROM `vt` where city='Derby' && SIC_code='1521'DB:business_master_new
loadtime:0.22795391082764 / seconds
Query Executed:select * from geodata_geocity where city='Derby Line' limit 1DB:business_master_new
loadtime:0.22840595245361 / seconds
Query stored in cache : _QUERY_www.toadli.com57538d8a524178f06eec6ff27032c7ff
loadtime:0.22847080230713 / seconds
Query Executed:select id FROM `vt` where city='Derby Line' && SIC_code='1521'DB:business_master_new
loadtime:0.23710179328918 / seconds
Query Executed:select * from geodata_geocity where city='Dorset' limit 1DB:business_master_new
loadtime:0.23753786087036 / seconds
Query stored in cache : _QUERY_www.toadli.com65c1f66faa826bb8247ec5f6fc75dcc7
loadtime:0.2376070022583 / seconds
Query Executed:select id FROM `vt` where city='Dorset' && SIC_code='1521'DB:business_master_new
loadtime:0.24012589454651 / seconds
Query Executed:select * from geodata_geocity where city='Dummerston' limit 1DB:business_master_new
loadtime:0.24054193496704 / seconds
Query stored in cache : _QUERY_www.toadli.coma6d1e063738d74e969bcf75e86129a77
loadtime:0.24060702323914 / seconds
Query Executed:select id FROM `vt` where city='Dummerston' && SIC_code='1521'DB:business_master_new
loadtime:0.2410089969635 / seconds
Query Executed:select * from geodata_geocity where city='E St Johnsbury' limit 1DB:business_master_new
loadtime:0.24137783050537 / seconds
Query stored in cache : _QUERY_www.toadli.com961942982fb3d7e0a2683e6f7ec758ae
loadtime:0.24144196510315 / seconds
Query Executed:select id FROM `vt` where city='E St Johnsbury' && SIC_code='1521'DB:business_master_new
loadtime:0.24183082580566 / seconds
Query Executed:select * from geodata_geocity where city='East Arlington' limit 1DB:business_master_new
loadtime:0.24220490455627 / seconds
Query stored in cache : _QUERY_www.toadli.com0e3e7bcc8252e7f2e44b226103ede722
loadtime:0.24227285385132 / seconds
Query Executed:select id FROM `vt` where city='East Arlington' && SIC_code='1521'DB:business_master_new
loadtime:0.24292182922363 / seconds
Query Executed:select * from geodata_geocity where city='East Barre' limit 1DB:business_master_new
loadtime:0.24329781532288 / seconds
Query stored in cache : _QUERY_www.toadli.com5c7cb939941e2bf34c18231a3cc516b0
loadtime:0.2433648109436 / seconds
Query Executed:select id FROM `vt` where city='East Barre' && SIC_code='1521'DB:business_master_new
loadtime:0.24417185783386 / seconds
Query Executed:select * from geodata_geocity where city='East Berkshire' limit 1DB:business_master_new
loadtime:0.24456787109375 / seconds
Query stored in cache : _QUERY_www.toadli.com7c1472abab2d1595b2ab70a42312e1a8
loadtime:0.24464297294617 / seconds
Query Executed:select id FROM `vt` where city='East Berkshire' && SIC_code='1521'DB:business_master_new
loadtime:0.24518990516663 / seconds
Query Executed:select * from geodata_geocity where city='East Burke' limit 1DB:business_master_new
loadtime:0.2455689907074 / seconds
Query stored in cache : _QUERY_www.toadli.coma556a492b30727dff5b708e79deb8cf5
loadtime:0.24564099311829 / seconds
Query Executed:select id FROM `vt` where city='East Burke' && SIC_code='1521'DB:business_master_new
loadtime:0.24647092819214 / seconds
Query Executed:select * from geodata_geocity where city='East Calais' limit 1DB:business_master_new
loadtime:0.24687480926514 / seconds
Query stored in cache : _QUERY_www.toadli.com75152aa5d71b6c540bc6bba0cb0dd4e6
loadtime:0.24693989753723 / seconds
Query Executed:select id FROM `vt` where city='East Calais' && SIC_code='1521'DB:business_master_new
loadtime:0.24754500389099 / seconds
Query Executed:select * from geodata_geocity where city='East Charleston' limit 1DB:business_master_new
loadtime:0.24796199798584 / seconds
Query stored in cache : _QUERY_www.toadli.come7456f7fb085a6054313649e860eb04b
loadtime:0.24802589416504 / seconds
Query Executed:select id FROM `vt` where city='East Charleston' && SIC_code='1521'DB:business_master_new
loadtime:0.24849486351013 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Corinth' limit 1
loadtime:0.24855279922485 / seconds
Query Executed:select id FROM `vt` where city='East Corinth' && SIC_code='1521'DB:business_master_new
loadtime:0.24922895431519 / seconds
Query Executed:select * from geodata_geocity where city='East Dorset' limit 1DB:business_master_new
loadtime:0.24959683418274 / seconds
Query stored in cache : _QUERY_www.toadli.combac4004df62f9d63a760eef688b1bfbc
loadtime:0.24967479705811 / seconds
Query Executed:select id FROM `vt` where city='East Dorset' && SIC_code='1521'DB:business_master_new
loadtime:0.25048685073853 / seconds
Query Executed:select * from geodata_geocity where city='East Dover' limit 1DB:business_master_new
loadtime:0.25087594985962 / seconds
Query stored in cache : _QUERY_www.toadli.com985fe99f2eff32288dd3ca77cd35a445
loadtime:0.25094485282898 / seconds
Query Executed:select id FROM `vt` where city='East Dover' && SIC_code='1521'DB:business_master_new
loadtime:0.25161099433899 / seconds
Query Executed:select * from geodata_geocity where city='East Dummerston' limit 1DB:business_master_new
loadtime:0.25202298164368 / seconds
Query stored in cache : _QUERY_www.toadli.comadc5d6475de26276d3c092fabe7f40f7
loadtime:0.25208687782288 / seconds
Query Executed:select id FROM `vt` where city='East Dummerston' && SIC_code='1521'DB:business_master_new
loadtime:0.25243902206421 / seconds
Query Executed:select * from geodata_geocity where city='East Fairfield' limit 1DB:business_master_new
loadtime:0.25283479690552 / seconds
Query stored in cache : _QUERY_www.toadli.comad0e0f8e53b722696d3060f282a17e60
loadtime:0.25289988517761 / seconds
Query Executed:select id FROM `vt` where city='East Fairfield' && SIC_code='1521'DB:business_master_new
loadtime:0.25353980064392 / seconds
Query Executed:select * from geodata_geocity where city='East Hardwick' limit 1DB:business_master_new
loadtime:0.25394582748413 / seconds
Query stored in cache : _QUERY_www.toadli.coma9160808cc05a6bf28a698ddc4e50322
loadtime:0.25401091575623 / seconds
Query Executed:select id FROM `vt` where city='East Hardwick' && SIC_code='1521'DB:business_master_new
loadtime:0.25475287437439 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Haven' limit 1
loadtime:0.25482583045959 / seconds
Query Executed:select id FROM `vt` where city='East Haven' && SIC_code='1521'DB:business_master_new
loadtime:0.25530982017517 / seconds
Query Executed:select * from geodata_geocity where city='East Middlebury' limit 1DB:business_master_new
loadtime:0.25572395324707 / seconds
Query stored in cache : _QUERY_www.toadli.com36a1b9e5c0884b73527d4a40149040c7
loadtime:0.25579285621643 / seconds
Query Executed:select id FROM `vt` where city='East Middlebury' && SIC_code='1521'DB:business_master_new
loadtime:0.25650787353516 / seconds
Query Executed:select * from geodata_geocity where city='East Montpelier' limit 1DB:business_master_new
loadtime:0.25691699981689 / seconds
Query stored in cache : _QUERY_www.toadli.com21f27e09de43338a19177a432b96c523
loadtime:0.25698089599609 / seconds
Query Executed:select id FROM `vt` where city='East Montpelier' && SIC_code='1521'DB:business_master_new
loadtime:0.25918483734131 / seconds
Query Executed:select * from geodata_geocity where city='East Orange' limit 1DB:business_master_new
loadtime:0.25959801673889 / seconds
Query stored in cache : _QUERY_www.toadli.com301409004c1156e6706d9acc11f0ed71
loadtime:0.25967001914978 / seconds
Query Executed:select id FROM `vt` where city='East Orange' && SIC_code='1521'DB:business_master_new
loadtime:0.26006698608398 / seconds
Query Executed:select * from geodata_geocity where city='East Poultney' limit 1DB:business_master_new
loadtime:0.26045083999634 / seconds
Query stored in cache : _QUERY_www.toadli.com0233f2f96661e400d6e5564f275067ff
loadtime:0.26051902770996 / seconds
Query Executed:select id FROM `vt` where city='East Poultney' && SIC_code='1521'DB:business_master_new
loadtime:0.26098394393921 / seconds
Query Executed:select * from geodata_geocity where city='East Randolph' limit 1DB:business_master_new
loadtime:0.2613639831543 / seconds
Query stored in cache : _QUERY_www.toadli.comd882b49f102ed8c258f24839d6a6e759
loadtime:0.2614278793335 / seconds
Query Executed:select id FROM `vt` where city='East Randolph' && SIC_code='1521'DB:business_master_new
loadtime:0.26193881034851 / seconds
Query Executed:select * from geodata_geocity where city='East Ryegate' limit 1DB:business_master_new
loadtime:0.26233983039856 / seconds
Query stored in cache : _QUERY_www.toadli.comb2bc163c7cdf3b42d373858254f69d1c
loadtime:0.2624089717865 / seconds
Query Executed:select id FROM `vt` where city='East Ryegate' && SIC_code='1521'DB:business_master_new
loadtime:0.26303291320801 / seconds
Query Executed:select * from geodata_geocity where city='East Saint Johnsbury' limit 1DB:business_master_new
loadtime:0.26342487335205 / seconds
Query stored in cache : _QUERY_www.toadli.comc7e31baf10038b876833703ab301ce49
loadtime:0.26348781585693 / seconds
Query Executed:select id FROM `vt` where city='East Saint Johnsbury' && SIC_code='1521'DB:business_master_new
loadtime:0.26397895812988 / seconds
Query Executed:select * from geodata_geocity where city='East Thetford' limit 1DB:business_master_new
loadtime:0.26437091827393 / seconds
Query stored in cache : _QUERY_www.toadli.com3cd26f2d9ca930c7bf3ecb0a5a458a2d
loadtime:0.26443886756897 / seconds
Query Executed:select id FROM `vt` where city='East Thetford' && SIC_code='1521'DB:business_master_new
loadtime:0.26532602310181 / seconds
Query Executed:select * from geodata_geocity where city='East Wallingford' limit 1DB:business_master_new
loadtime:0.26574897766113 / seconds
Query stored in cache : _QUERY_www.toadli.com3a67e9913ce947875bb0924b092ddfaf
loadtime:0.26581883430481 / seconds
Query Executed:select id FROM `vt` where city='East Wallingford' && SIC_code='1521'DB:business_master_new
loadtime:0.26636290550232 / seconds
Query Executed:select * from geodata_geocity where city='Eden' limit 1DB:business_master_new
loadtime:0.26679396629333 / seconds
Query stored in cache : _QUERY_www.toadli.com731bd1f4792584896e66edc3a6d62f88
loadtime:0.26686596870422 / seconds
Query Executed:select id FROM `vt` where city='Eden' && SIC_code='1521'DB:business_master_new
loadtime:0.26746702194214 / seconds
Query Executed:select * from geodata_geocity where city='Eden Mills' limit 1DB:business_master_new
loadtime:0.26792001724243 / seconds
Query stored in cache : _QUERY_www.toadli.come917afd7e3dd653988bd565ca79e412c
loadtime:0.26798391342163 / seconds
Query Executed:select id FROM `vt` where city='Eden Mills' && SIC_code='1521'DB:business_master_new
loadtime:0.26846194267273 / seconds
Query Executed:select * from geodata_geocity where city='Enosburg Falls' limit 1DB:business_master_new
loadtime:0.2689049243927 / seconds
Query stored in cache : _QUERY_www.toadli.com11b3c02a97ef2f5245d94ac5f83e17b7
loadtime:0.26897001266479 / seconds
Query Executed:select id FROM `vt` where city='Enosburg Falls' && SIC_code='1521'DB:business_master_new
loadtime:0.27266883850098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.27274179458618 / seconds
Query Executed:select id FROM `vt` where city='Essex' && SIC_code='1521'DB:business_master_new
loadtime:0.2736599445343 / seconds
Query Executed:select * from geodata_geocity where city='Essex Junction' limit 1DB:business_master_new
loadtime:0.27415180206299 / seconds
Query stored in cache : _QUERY_www.toadli.comc30924da8e042cf637ae18767ab6e34f
loadtime:0.2742178440094 / seconds
Query Executed:select id FROM `vt` where city='Essex Junction' && SIC_code='1521'DB:business_master_new
loadtime:0.28590798377991 / seconds
Query Executed:select * from geodata_geocity where city='Fair Haven' limit 1DB:business_master_new
loadtime:0.28638601303101 / seconds
Query stored in cache : _QUERY_www.toadli.com4c18b57c72e15c96eae7f85a08cfc028
loadtime:0.28645181655884 / seconds
Query Executed:select id FROM `vt` where city='Fair Haven' && SIC_code='1521'DB:business_master_new
loadtime:0.28965282440186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.28972887992859 / seconds
Query Executed:select id FROM `vt` where city='Fairfax' && SIC_code='1521'DB:business_master_new
loadtime:0.29241490364075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.29249382019043 / seconds
Query Executed:select id FROM `vt` where city='Fairfield' && SIC_code='1521'DB:business_master_new
loadtime:0.29338979721069 / seconds
Query Executed:select * from geodata_geocity where city='Fairlee' limit 1DB:business_master_new
loadtime:0.29386901855469 / seconds
Query stored in cache : _QUERY_www.toadli.com3464f4305dd9843b545ae4754294aaa2
loadtime:0.29393482208252 / seconds
Query Executed:select id FROM `vt` where city='Fairlee' && SIC_code='1521'DB:business_master_new
loadtime:0.29624199867249 / seconds
Query Executed:select * from geodata_geocity where city='Ferrisburg' limit 1DB:business_master_new
loadtime:0.29667592048645 / seconds
Query stored in cache : _QUERY_www.toadli.come7943d05bfe5a19c1da7430b0a5e6fba
loadtime:0.29674196243286 / seconds
Query Executed:select id FROM `vt` where city='Ferrisburg' && SIC_code='1521'DB:business_master_new
loadtime:0.29714798927307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.29720282554626 / seconds
Query Executed:select id FROM `vt` where city='Florence' && SIC_code='1521'DB:business_master_new
loadtime:0.29776883125305 / seconds
Query Executed:select * from geodata_geocity where city='Forest Dale' limit 1DB:business_master_new
loadtime:0.29816389083862 / seconds
Query stored in cache : _QUERY_www.toadli.com70a7e05860c722523e1b9b2f40744567
loadtime:0.29822993278503 / seconds
Query Executed:select id FROM `vt` where city='Forest Dale' && SIC_code='1521'DB:business_master_new
loadtime:0.29868292808533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.2987368106842 / seconds
Query Executed:select id FROM `vt` where city='Franklin' && SIC_code='1521'DB:business_master_new
loadtime:0.3074209690094 / seconds
Query Executed:select * from geodata_geocity where city='Gaysville' limit 1DB:business_master_new
loadtime:0.30786490440369 / seconds
Query stored in cache : _QUERY_www.toadli.comb6f092eb8297571125ad41e01000b0d2
loadtime:0.30793190002441 / seconds
Query Executed:select id FROM `vt` where city='Gaysville' && SIC_code='1521'DB:business_master_new
loadtime:0.30840587615967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:0.30845999717712 / seconds
Query Executed:select id FROM `vt` where city='Gilman' && SIC_code='1521'DB:business_master_new
loadtime:0.30894184112549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glover' limit 1
loadtime:0.30900382995605 / seconds
Query Executed:select id FROM `vt` where city='Glover' && SIC_code='1521'DB:business_master_new
loadtime:0.30971384048462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.30977988243103 / seconds
Query Executed:select id FROM `vt` where city='Grafton' && SIC_code='1521'DB:business_master_new
loadtime:0.31072402000427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:0.31077790260315 / seconds
Query Executed:select id FROM `vt` where city='Granby' && SIC_code='1521'DB:business_master_new
loadtime:0.31119084358215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Isle' limit 1
loadtime:0.31124687194824 / seconds
Query Executed:select id FROM `vt` where city='Grand Isle' && SIC_code='1521'DB:business_master_new
loadtime:0.31985187530518 / seconds
Query Executed:select * from geodata_geocity where city='Graniteville' limit 1DB:business_master_new
loadtime:0.32027196884155 / seconds
Query stored in cache : _QUERY_www.toadli.comb0eee3791a0c43e662e54c0025812848
loadtime:0.32034301757812 / seconds
Query Executed:select id FROM `vt` where city='Graniteville' && SIC_code='1521'DB:business_master_new
loadtime:0.32109189033508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granville' limit 1
loadtime:0.32114791870117 / seconds
Query Executed:select id FROM `vt` where city='Granville' && SIC_code='1521'DB:business_master_new
loadtime:0.32168793678284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greensboro' limit 1
loadtime:0.32175993919373 / seconds
Query Executed:select id FROM `vt` where city='Greensboro' && SIC_code='1521'DB:business_master_new
loadtime:0.32246494293213 / seconds
Query Executed:select * from geodata_geocity where city='Greensboro Bend' limit 1DB:business_master_new
loadtime:0.32292795181274 / seconds
Query stored in cache : _QUERY_www.toadli.com74c1ad3f3ea7d3bff345b7458b90e445
loadtime:0.32299280166626 / seconds
Query Executed:select id FROM `vt` where city='Greensboro Bend' && SIC_code='1521'DB:business_master_new
loadtime:0.32354879379272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.32362389564514 / seconds
Query Executed:select id FROM `vt` where city='Groton' && SIC_code='1521'DB:business_master_new
loadtime:0.33219885826111 / seconds
Query Executed:select * from geodata_geocity where city='Guildhall' limit 1DB:business_master_new
loadtime:0.33265686035156 / seconds
Query stored in cache : _QUERY_www.toadli.com0e9417d59dc3613ce28247ebbd048973
loadtime:0.33272981643677 / seconds
Query Executed:select id FROM `vt` where city='Guildhall' && SIC_code='1521'DB:business_master_new
loadtime:0.33345293998718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guilford' limit 1
loadtime:0.33350896835327 / seconds
Query Executed:select id FROM `vt` where city='Guilford' && SIC_code='1521'DB:business_master_new
loadtime:0.33387684822083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:0.33393287658691 / seconds
Query Executed:select id FROM `vt` where city='Hancock' && SIC_code='1521'DB:business_master_new
loadtime:0.33457183837891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardwick' limit 1
loadtime:0.33463501930237 / seconds
Query Executed:select id FROM `vt` where city='Hardwick' && SIC_code='1521'DB:business_master_new
loadtime:0.33752489089966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.3375928401947 / seconds
Query Executed:select id FROM `vt` where city='Hartford' && SIC_code='1521'DB:business_master_new
loadtime:0.34618782997131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland' limit 1
loadtime:0.34625697135925 / seconds
Query Executed:select id FROM `vt` where city='Hartland' && SIC_code='1521'DB:business_master_new
loadtime:0.34849786758423 / seconds
Query Executed:select * from geodata_geocity where city='Hartland 4 Cors' limit 1DB:business_master_new
loadtime:0.34899282455444 / seconds
Query stored in cache : _QUERY_www.toadli.comcff75f39ca1259c7adfd8b8a63d410ae
loadtime:0.34906387329102 / seconds
Query Executed:select id FROM `vt` where city='Hartland 4 Cors' && SIC_code='1521'DB:business_master_new
loadtime:0.34944891929626 / seconds
Query Executed:select * from geodata_geocity where city='Hartland Four Corners' limit 1DB:business_master_new
loadtime:0.34991693496704 / seconds
Query stored in cache : _QUERY_www.toadli.comc84b982327dfd48286ea5dd28ebfb5b7
loadtime:0.34998297691345 / seconds
Query Executed:select id FROM `vt` where city='Hartland Four Corners' && SIC_code='1521'DB:business_master_new
loadtime:0.35044002532959 / seconds
Query Executed:select * from geodata_geocity where city='Highgate Center' limit 1DB:business_master_new
loadtime:0.35083889961243 / seconds
Query stored in cache : _QUERY_www.toadli.com63541eb1ba022e7c056e546b8fb1d132
loadtime:0.35090398788452 / seconds
Query Executed:select id FROM `vt` where city='Highgate Center' && SIC_code='1521'DB:business_master_new
loadtime:0.3595290184021 / seconds
Query Executed:select * from geodata_geocity where city='Highgate Springs' limit 1DB:business_master_new
loadtime:0.35994482040405 / seconds
Query stored in cache : _QUERY_www.toadli.com49956130b6c97f59ec15db96619782be
loadtime:0.36001086235046 / seconds
Query Executed:select id FROM `vt` where city='Highgate Springs' && SIC_code='1521'DB:business_master_new
loadtime:0.36063480377197 / seconds
Query Executed:select * from geodata_geocity where city='Hinesburg' limit 1DB:business_master_new
loadtime:0.36108684539795 / seconds
Query stored in cache : _QUERY_www.toadli.com74acc7b5d7a3afcb8c3e41bd4959a4ee
loadtime:0.36115193367004 / seconds
Query Executed:select id FROM `vt` where city='Hinesburg' && SIC_code='1521'DB:business_master_new
loadtime:0.36455297470093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington' limit 1
loadtime:0.36464881896973 / seconds
Query Executed:select id FROM `vt` where city='Huntington' && SIC_code='1521'DB:business_master_new
loadtime:0.37323093414307 / seconds
Query Executed:select * from geodata_geocity where city='Hyde Park' limit 1DB:business_master_new
loadtime:0.37367486953735 / seconds
Query stored in cache : _QUERY_www.toadli.comd17278401b43e5f6d652461a0f096a5a
loadtime:0.37373995780945 / seconds
Query Executed:select id FROM `vt` where city='Hyde Park' && SIC_code='1521'DB:business_master_new
loadtime:0.37611699104309 / seconds
Query Executed:select * from geodata_geocity where city='Hydeville' limit 1DB:business_master_new
loadtime:0.37655091285706 / seconds
Query stored in cache : _QUERY_www.toadli.com454b86ee09ec3d552c1e2a4f09f06607
loadtime:0.37662482261658 / seconds
Query Executed:select id FROM `vt` where city='Hydeville' && SIC_code='1521'DB:business_master_new
loadtime:0.37722682952881 / seconds
Query Executed:select * from geodata_geocity where city='Irasburg' limit 1DB:business_master_new
loadtime:0.37765789031982 / seconds
Query stored in cache : _QUERY_www.toadli.com19442e854e4cb2c472a700dd9e10a3d9
loadtime:0.3777220249176 / seconds
Query Executed:select id FROM `vt` where city='Irasburg' && SIC_code='1521'DB:business_master_new
loadtime:0.38632392883301 / seconds
Query Executed:select * from geodata_geocity where city='Island Pond' limit 1DB:business_master_new
loadtime:0.38679790496826 / seconds
Query stored in cache : _QUERY_www.toadli.com10e8ec7b41a05b722d92c554c4d4b853
loadtime:0.38686299324036 / seconds
Query Executed:select id FROM `vt` where city='Island Pond' && SIC_code='1521'DB:business_master_new
loadtime:0.3955078125 / seconds
Query Executed:select * from geodata_geocity where city='Isle La Motte' limit 1DB:business_master_new
loadtime:0.3959858417511 / seconds
Query stored in cache : _QUERY_www.toadli.com58af4f3fa9f7d7a1b17a7892e84b51f4
loadtime:0.39605593681335 / seconds
Query Executed:select id FROM `vt` where city='Isle La Motte' && SIC_code='1521'DB:business_master_new
loadtime:0.39670300483704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jacksonville' limit 1
loadtime:0.39677596092224 / seconds
Query Executed:select id FROM `vt` where city='Jacksonville' && SIC_code='1521'DB:business_master_new
loadtime:0.39771389961243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica' limit 1
loadtime:0.3977689743042 / seconds
Query Executed:select id FROM `vt` where city='Jamaica' && SIC_code='1521'DB:business_master_new
loadtime:0.3987078666687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jay' limit 1
loadtime:0.39876198768616 / seconds
Query Executed:select id FROM `vt` where city='Jay' && SIC_code='1521'DB:business_master_new
loadtime:0.39915299415588 / seconds
Query Executed:select * from geodata_geocity where city='Jeffersonville' limit 1DB:business_master_new
loadtime:0.39958000183105 / seconds
Query stored in cache : _QUERY_www.toadli.comee9cc10108e0257903c38fa5b5f570c0
loadtime:0.3996570110321 / seconds
Query Executed:select id FROM `vt` where city='Jeffersonville' && SIC_code='1521'DB:business_master_new
loadtime:0.40208292007446 / seconds
Query Executed:select * from geodata_geocity where city='Jericho' limit 1DB:business_master_new
loadtime:0.40251588821411 / seconds
Query stored in cache : _QUERY_www.toadli.com76bf281ae5a74ed60352abe8796a2517
loadtime:0.40258002281189 / seconds
Query Executed:select id FROM `vt` where city='Jericho' && SIC_code='1521'DB:business_master_new
loadtime:0.40579986572266 / seconds
Query Executed:select * from geodata_geocity where city='Jericho Center' limit 1DB:business_master_new
loadtime:0.40622782707214 / seconds
Query stored in cache : _QUERY_www.toadli.comf7279e89d55f08569de4cabbe5204c45
loadtime:0.40629196166992 / seconds
Query Executed:select id FROM `vt` where city='Jericho Center' && SIC_code='1521'DB:business_master_new
loadtime:0.40668892860413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnson' limit 1
loadtime:0.40674996376038 / seconds
Query Executed:select id FROM `vt` where city='Johnson' && SIC_code='1521'DB:business_master_new
loadtime:0.40940999984741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:0.40947794914246 / seconds
Query Executed:select id FROM `vt` where city='Jonesville' && SIC_code='1521'DB:business_master_new
loadtime:0.40996599197388 / seconds
Query Executed:select * from geodata_geocity where city='Killington' limit 1DB:business_master_new
loadtime:0.41037702560425 / seconds
Query stored in cache : _QUERY_www.toadli.combae779baa2a32b6c46f76d46083f93bd
loadtime:0.41044187545776 / seconds
Query Executed:select id FROM `vt` where city='Killington' && SIC_code='1521'DB:business_master_new
loadtime:0.41410183906555 / seconds
Query Executed:select * from geodata_geocity where city='Lake Elmore' limit 1DB:business_master_new
loadtime:0.41454601287842 / seconds
Query stored in cache : _QUERY_www.toadli.comb950d56ec5077929875fd263877190c4
loadtime:0.41460990905762 / seconds
Query Executed:select id FROM `vt` where city='Lake Elmore' && SIC_code='1521'DB:business_master_new
loadtime:0.41521286964417 / seconds
Query Executed:select * from geodata_geocity where city='Lemington' limit 1DB:business_master_new
loadtime:0.4156699180603 / seconds
Query stored in cache : _QUERY_www.toadli.comc09c5c0f065b41990ccd7f10b48ba8b3
loadtime:0.4157338142395 / seconds
Query Executed:select id FROM `vt` where city='Lemington' && SIC_code='1521'DB:business_master_new
loadtime:0.41615986824036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.41621494293213 / seconds
Query Executed:select id FROM `vt` where city='Lincoln' && SIC_code='1521'DB:business_master_new
loadtime:0.41663599014282 / seconds
Query Executed:select * from geodata_geocity where city='Londonderry' limit 1DB:business_master_new
loadtime:0.41704988479614 / seconds
Query stored in cache : _QUERY_www.toadli.com42ac58b626b161de5fce11785eac9d02
loadtime:0.41711497306824 / seconds
Query Executed:select id FROM `vt` where city='Londonderry' && SIC_code='1521'DB:business_master_new
loadtime:0.42586183547974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:0.42593383789062 / seconds
Query Executed:select id FROM `vt` where city='Lowell' && SIC_code='1521'DB:business_master_new
loadtime:0.42665886878967 / seconds
Query Executed:select * from geodata_geocity where city='Lower Waterford' limit 1DB:business_master_new
loadtime:0.4271388053894 / seconds
Query stored in cache : _QUERY_www.toadli.coma06d66672fad56eaabdfd3fcd4967f8b
loadtime:0.4272038936615 / seconds
Query Executed:select id FROM `vt` where city='Lower Waterford' && SIC_code='1521'DB:business_master_new
loadtime:0.42775988578796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:0.42781901359558 / seconds
Query Executed:select id FROM `vt` where city='Ludlow' && SIC_code='1521'DB:business_master_new
loadtime:0.43219184875488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:0.43227386474609 / seconds
Query Executed:select id FROM `vt` where city='Lunenburg' && SIC_code='1521'DB:business_master_new
loadtime:0.43305993080139 / seconds
Query Executed:select * from geodata_geocity where city='Lyndon' limit 1DB:business_master_new
loadtime:0.43350195884705 / seconds
Query stored in cache : _QUERY_www.toadli.com24d19a236c67d3564c27b98d626f93e4
loadtime:0.43357181549072 / seconds
Query Executed:select id FROM `vt` where city='Lyndon' && SIC_code='1521'DB:business_master_new
loadtime:0.43441200256348 / seconds
Query Executed:select * from geodata_geocity where city='Lyndon Center' limit 1DB:business_master_new
loadtime:0.43485879898071 / seconds
Query stored in cache : _QUERY_www.toadli.com7135c947a49926a38f19825301e80495
loadtime:0.43492388725281 / seconds
Query Executed:select id FROM `vt` where city='Lyndon Center' && SIC_code='1521'DB:business_master_new
loadtime:0.43552279472351 / seconds
Query Executed:select * from geodata_geocity where city='Lyndonville' limit 1DB:business_master_new
loadtime:0.43597292900085 / seconds
Query stored in cache : _QUERY_www.toadli.comb05f221db0bef4b6905ef22c22969eba
loadtime:0.43603801727295 / seconds
Query Executed:select id FROM `vt` where city='Lyndonville' && SIC_code='1521'DB:business_master_new
loadtime:0.44031691551208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.4403920173645 / seconds
Query Executed:select id FROM `vt` where city='Manchester' && SIC_code='1521'DB:business_master_new
loadtime:0.443363904953 / seconds
Query Executed:select * from geodata_geocity where city='Manchester Center' limit 1DB:business_master_new
loadtime:0.44382882118225 / seconds
Query stored in cache : _QUERY_www.toadli.com20b17633c9beb19d30986d0443ee7713
loadtime:0.44389796257019 / seconds
Query Executed:select id FROM `vt` where city='Manchester Center' && SIC_code='1521'DB:business_master_new
loadtime:0.45117282867432 / seconds
Query Executed:select * from geodata_geocity where city='Manchester Ctr' limit 1DB:business_master_new
loadtime:0.45164895057678 / seconds
Query stored in cache : _QUERY_www.toadli.comb2d97aa3780453d46ef614a286ad1685
loadtime:0.4517138004303 / seconds
Query Executed:select id FROM `vt` where city='Manchester Ctr' && SIC_code='1521'DB:business_master_new
loadtime:0.45212602615356 / seconds
Query Executed:select * from geodata_geocity where city='Marlboro' limit 1DB:business_master_new
loadtime:0.45257091522217 / seconds
Query stored in cache : _QUERY_www.toadli.com4516e3342b5a36982a6cb63761e5f3c6
loadtime:0.45264482498169 / seconds
Query Executed:select id FROM `vt` where city='Marlboro' && SIC_code='1521'DB:business_master_new
loadtime:0.45341181755066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield' limit 1
loadtime:0.45348000526428 / seconds
Query Executed:select id FROM `vt` where city='Marshfield' && SIC_code='1521'DB:business_master_new
loadtime:0.46209502220154 / seconds
Query Executed:select * from geodata_geocity where city='Mc Indoe Falls' limit 1DB:business_master_new
loadtime:0.46247386932373 / seconds
Query stored in cache : _QUERY_www.toadli.com7ff7364a25bd6f8fe8c21db314ef26a9
loadtime:0.46253800392151 / seconds
Query Executed:select id FROM `vt` where city='Mc Indoe Falls' && SIC_code='1521'DB:business_master_new
loadtime:0.46305084228516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebury' limit 1
loadtime:0.46310591697693 / seconds
Query Executed:select id FROM `vt` where city='Middlebury' && SIC_code='1521'DB:business_master_new
loadtime:0.47224402427673 / seconds
Query Executed:select * from geodata_geocity where city='Middletown Spgs' limit 1DB:business_master_new
loadtime:0.4727349281311 / seconds
Query stored in cache : _QUERY_www.toadli.com535a23108930c988b3318c6c2754810d
loadtime:0.47280693054199 / seconds
Query Executed:select id FROM `vt` where city='Middletown Spgs' && SIC_code='1521'DB:business_master_new
loadtime:0.47321581840515 / seconds
Query Executed:select * from geodata_geocity where city='Middletown Springs' limit 1DB:business_master_new
loadtime:0.47365689277649 / seconds
Query stored in cache : _QUERY_www.toadli.com3f0f68bf093495602c0e46ef7e719c93
loadtime:0.4737229347229 / seconds
Query Executed:select id FROM `vt` where city='Middletown Springs' && SIC_code='1521'DB:business_master_new
loadtime:0.4745979309082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:0.4746618270874 / seconds
Query Executed:select id FROM `vt` where city='Milton' && SIC_code='1521'DB:business_master_new
loadtime:0.48034501075745 / seconds
Query Executed:select * from geodata_geocity where city='Monkton' limit 1DB:business_master_new
loadtime:0.48082900047302 / seconds
Query stored in cache : _QUERY_www.toadli.com119a2cdd17c112f4127f0d89f000bf56
loadtime:0.48089480400085 / seconds
Query Executed:select id FROM `vt` where city='Monkton' && SIC_code='1521'DB:business_master_new
loadtime:0.48160099983215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery' limit 1
loadtime:0.481684923172 / seconds
Query Executed:select id FROM `vt` where city='Montgomery' && SIC_code='1521'DB:business_master_new
loadtime:0.48225092887878 / seconds
Query Executed:select * from geodata_geocity where city='Montgomery Center' limit 1DB:business_master_new
loadtime:0.48272490501404 / seconds
Query stored in cache : _QUERY_www.toadli.combd8baa47e9971a3e2bf4e84576e2b25a
loadtime:0.48279595375061 / seconds
Query Executed:select id FROM `vt` where city='Montgomery Center' && SIC_code='1521'DB:business_master_new
loadtime:0.4835958480835 / seconds
Query Executed:select * from geodata_geocity where city='Montgomery Ctr' limit 1DB:business_master_new
loadtime:0.48407602310181 / seconds
Query stored in cache : _QUERY_www.toadli.com954b236d581ac3d105ee08f47ea8dd6e
loadtime:0.48414087295532 / seconds
Query Executed:select id FROM `vt` where city='Montgomery Ctr' && SIC_code='1521'DB:business_master_new
loadtime:0.48457384109497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:0.48463702201843 / seconds
Query Executed:select id FROM `vt` where city='Montpelier' && SIC_code='1521'DB:business_master_new
loadtime:0.49963402748108 / seconds
Query Executed:select * from geodata_geocity where city='Moretown' limit 1DB:business_master_new
loadtime:0.50011992454529 / seconds
Query stored in cache : _QUERY_www.toadli.com8e0fffbc40618de69f37586e10be6952
loadtime:0.50018692016602 / seconds
Query Executed:select id FROM `vt` where city='Moretown' && SIC_code='1521'DB:business_master_new
loadtime:0.50893402099609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morgan' limit 1
loadtime:0.50901484489441 / seconds
Query Executed:select id FROM `vt` where city='Morgan' && SIC_code='1521'DB:business_master_new
loadtime:0.509605884552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisville' limit 1
loadtime:0.50968289375305 / seconds
Query Executed:select id FROM `vt` where city='Morrisville' && SIC_code='1521'DB:business_master_new
loadtime:0.51569485664368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moscow' limit 1
loadtime:0.51578402519226 / seconds
Query Executed:select id FROM `vt` where city='Moscow' && SIC_code='1521'DB:business_master_new
loadtime:0.51630401611328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Holly' limit 1
loadtime:0.51637196540833 / seconds
Query Executed:select id FROM `vt` where city='Mount Holly' && SIC_code='1521'DB:business_master_new
loadtime:0.51709389686584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Holly' limit 1
loadtime:0.51716589927673 / seconds
Query Executed:select id FROM `vt` where city='Mt Holly' && SIC_code='1521'DB:business_master_new
loadtime:0.51756596565247 / seconds
Query Executed:select * from geodata_geocity where city='N Springfield' limit 1DB:business_master_new
loadtime:0.51801800727844 / seconds
Query stored in cache : _QUERY_www.toadli.com0108448f6cef262b8db07ea6a66d5893
loadtime:0.51808381080627 / seconds
Query Executed:select id FROM `vt` where city='N Springfield' && SIC_code='1521'DB:business_master_new
loadtime:0.51858687400818 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Haven' limit 1
loadtime:0.51866292953491 / seconds
Query Executed:select id FROM `vt` where city='New Haven' && SIC_code='1521'DB:business_master_new
loadtime:0.52096199989319 / seconds
Query Executed:select * from geodata_geocity where city='Newbury' limit 1DB:business_master_new
loadtime:0.52141094207764 / seconds
Query stored in cache : _QUERY_www.toadli.come1f5838111c416bb61301754b961890c
loadtime:0.52147698402405 / seconds
Query Executed:select id FROM `vt` where city='Newbury' && SIC_code='1521'DB:business_master_new
loadtime:0.52222895622253 / seconds
Query Executed:select * from geodata_geocity where city='Newfane' limit 1DB:business_master_new
loadtime:0.52265882492065 / seconds
Query stored in cache : _QUERY_www.toadli.com1cc5fe0a9ead52bfb93447e947c3a149
loadtime:0.52272391319275 / seconds
Query Executed:select id FROM `vt` where city='Newfane' && SIC_code='1521'DB:business_master_new
loadtime:0.53130984306335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:0.53137898445129 / seconds
Query Executed:select id FROM `vt` where city='Newport' && SIC_code='1521'DB:business_master_new
loadtime:0.53841686248779 / seconds
Query Executed:select * from geodata_geocity where city='Newport Center' limit 1DB:business_master_new
loadtime:0.5388708114624 / seconds
Query stored in cache : _QUERY_www.toadli.com5469665da01a5f0385c2a7f61384a05e
loadtime:0.5389358997345 / seconds
Query Executed:select id FROM `vt` where city='Newport Center' && SIC_code='1521'DB:business_master_new
loadtime:0.53982996940613 / seconds
Query Executed:select * from geodata_geocity where city='North Bennington' limit 1DB:business_master_new
loadtime:0.54028987884521 / seconds
Query stored in cache : _QUERY_www.toadli.com48f7975f5bfe90b8badcf9545a2ffb5c
loadtime:0.54035687446594 / seconds
Query Executed:select id FROM `vt` where city='North Bennington' && SIC_code='1521'DB:business_master_new
loadtime:0.54255390167236 / seconds
Query Executed:select * from geodata_geocity where city='North Chittenden' limit 1DB:business_master_new
loadtime:0.54297399520874 / seconds
Query stored in cache : _QUERY_www.toadli.comdd5ef7ab1fa3754974b68c4635ccd155
loadtime:0.54303789138794 / seconds
Query Executed:select id FROM `vt` where city='North Chittenden' && SIC_code='1521'DB:business_master_new
loadtime:0.54338383674622 / seconds
Query Executed:select * from geodata_geocity where city='North Clarendon' limit 1DB:business_master_new
loadtime:0.54377794265747 / seconds
Query stored in cache : _QUERY_www.toadli.com997488f4c13c27195be45772152d1c87
loadtime:0.54384779930115 / seconds
Query Executed:select id FROM `vt` where city='North Clarendon' && SIC_code='1521'DB:business_master_new
loadtime:0.54608583450317 / seconds
Query Executed:select * from geodata_geocity where city='North Concord' limit 1DB:business_master_new
loadtime:0.54650092124939 / seconds
Query stored in cache : _QUERY_www.toadli.com9fe379b5562b337bb1f30a13f2b23577
loadtime:0.54656481742859 / seconds
Query Executed:select id FROM `vt` where city='North Concord' && SIC_code='1521'DB:business_master_new
loadtime:0.54706692695618 / seconds
Query Executed:select * from geodata_geocity where city='North Ferrisburg' limit 1DB:business_master_new
loadtime:0.5474579334259 / seconds
Query stored in cache : _QUERY_www.toadli.comec642eb8ef801efa4f2f8cc9e6506264
loadtime:0.54752087593079 / seconds
Query Executed:select id FROM `vt` where city='North Ferrisburg' && SIC_code='1521'DB:business_master_new
loadtime:0.5479519367218 / seconds
Query Executed:select * from geodata_geocity where city='North Hartland' limit 1DB:business_master_new
loadtime:0.54836297035217 / seconds
Query stored in cache : _QUERY_www.toadli.comc5a6f1d1994c3c823785cea5a2038c4c
loadtime:0.54842591285706 / seconds
Query Executed:select id FROM `vt` where city='North Hartland' && SIC_code='1521'DB:business_master_new
loadtime:0.54895997047424 / seconds
Query Executed:select * from geodata_geocity where city='North Hero' limit 1DB:business_master_new
loadtime:0.54936599731445 / seconds
Query stored in cache : _QUERY_www.toadli.comb96e52766465cf9bf36bd0055fcffe2e
loadtime:0.54942893981934 / seconds
Query Executed:select id FROM `vt` where city='North Hero' && SIC_code='1521'DB:business_master_new
loadtime:0.55805087089539 / seconds
Query Executed:select * from geodata_geocity where city='North Hyde Park' limit 1DB:business_master_new
loadtime:0.55846881866455 / seconds
Query stored in cache : _QUERY_www.toadli.com9c899242cb1c8f6cf4b6a424ac3290a4
loadtime:0.55853295326233 / seconds
Query Executed:select id FROM `vt` where city='North Hyde Park' && SIC_code='1521'DB:business_master_new
loadtime:0.5590558052063 / seconds
Query Executed:select * from geodata_geocity where city='North Montpelier' limit 1DB:business_master_new
loadtime:0.55944800376892 / seconds
Query stored in cache : _QUERY_www.toadli.com95e45a12bf866a51c33ccf4badf4d0e5
loadtime:0.55951189994812 / seconds
Query Executed:select id FROM `vt` where city='North Montpelier' && SIC_code='1521'DB:business_master_new
loadtime:0.55997180938721 / seconds
Query Executed:select * from geodata_geocity where city='North Pomfret' limit 1DB:business_master_new
loadtime:0.5603609085083 / seconds
Query stored in cache : _QUERY_www.toadli.com977055a5db903a117ecf58e81d0de80d
loadtime:0.5604248046875 / seconds
Query Executed:select id FROM `vt` where city='North Pomfret' && SIC_code='1521'DB:business_master_new
loadtime:0.56108498573303 / seconds
Query Executed:select * from geodata_geocity where city='North Pownal' limit 1DB:business_master_new
loadtime:0.56149101257324 / seconds
Query stored in cache : _QUERY_www.toadli.com42e639e85740524f0f83c90ffceeddb0
loadtime:0.56155395507812 / seconds
Query Executed:select id FROM `vt` where city='North Pownal' && SIC_code='1521'DB:business_master_new
loadtime:0.56209182739258 / seconds
Query Executed:select * from geodata_geocity where city='North Springfield' limit 1DB:business_master_new
loadtime:0.56251502037048 / seconds
Query stored in cache : _QUERY_www.toadli.com16ce010ece9ee9cebcc62547868ccdb1
loadtime:0.56257796287537 / seconds
Query Executed:select id FROM `vt` where city='North Springfield' && SIC_code='1521'DB:business_master_new
loadtime:0.57117700576782 / seconds
Query Executed:select * from geodata_geocity where city='North Thetford' limit 1DB:business_master_new
loadtime:0.5716028213501 / seconds
Query stored in cache : _QUERY_www.toadli.com700bee12a701322a014e485f0db68d3a
loadtime:0.57167601585388 / seconds
Query Executed:select id FROM `vt` where city='North Thetford' && SIC_code='1521'DB:business_master_new
loadtime:0.57216382026672 / seconds
Query Executed:select * from geodata_geocity where city='North Troy' limit 1DB:business_master_new
loadtime:0.57258486747742 / seconds
Query stored in cache : _QUERY_www.toadli.combf752a31ec33118f63c53b248c1592fc
loadtime:0.57265901565552 / seconds
Query Executed:select id FROM `vt` where city='North Troy' && SIC_code='1521'DB:business_master_new
loadtime:0.58125782012939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:0.58131790161133 / seconds
Query Executed:select id FROM `vt` where city='Northfield' && SIC_code='1521'DB:business_master_new
loadtime:0.58497595787048 / seconds
Query Executed:select * from geodata_geocity where city='Northfield Falls' limit 1DB:business_master_new
loadtime:0.58541202545166 / seconds
Query stored in cache : _QUERY_www.toadli.com3aa302948955879f7a48ac6c431aa8ec
loadtime:0.58547592163086 / seconds
Query Executed:select id FROM `vt` where city='Northfield Falls' && SIC_code='1521'DB:business_master_new
loadtime:0.58601999282837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:0.58608198165894 / seconds
Query Executed:select id FROM `vt` where city='Norton' && SIC_code='1521'DB:business_master_new
loadtime:0.58673095703125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwich' limit 1
loadtime:0.5867908000946 / seconds
Query Executed:select id FROM `vt` where city='Norwich' && SIC_code='1521'DB:business_master_new
loadtime:0.59040498733521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:0.59048199653625 / seconds
Query Executed:select id FROM `vt` where city='Orange' && SIC_code='1521'DB:business_master_new
loadtime:0.59096479415894 / seconds
Query Executed:select * from geodata_geocity where city='Orleans' limit 1DB:business_master_new
loadtime:0.59145784378052 / seconds
Query stored in cache : _QUERY_www.toadli.com8022f3c93cb509a28a4d51a7fc113b88
loadtime:0.59152293205261 / seconds
Query Executed:select id FROM `vt` where city='Orleans' && SIC_code='1521'DB:business_master_new
loadtime:0.59380483627319 / seconds
Query Executed:select * from geodata_geocity where city='Orwell' limit 1DB:business_master_new
loadtime:0.59422397613525 / seconds
Query stored in cache : _QUERY_www.toadli.com8bcc317d176d30ba02c895f896d73801
loadtime:0.59429287910461 / seconds
Query Executed:select id FROM `vt` where city='Orwell' && SIC_code='1521'DB:business_master_new
loadtime:0.6029098033905 / seconds
Query Executed:select * from geodata_geocity where city='Passumpsic' limit 1DB:business_master_new
loadtime:0.60336780548096 / seconds
Query stored in cache : _QUERY_www.toadli.comd0217cdccdc9535c01a54d4696bf577c
loadtime:0.60343194007874 / seconds
Query Executed:select id FROM `vt` where city='Passumpsic' && SIC_code='1521'DB:business_master_new
loadtime:0.6038498878479 / seconds
Query Executed:select * from geodata_geocity where city='Pawlet' limit 1DB:business_master_new
loadtime:0.60428881645203 / seconds
Query stored in cache : _QUERY_www.toadli.com9232ab7eaa2824c1cbe4e6f84ac703c6
loadtime:0.60435199737549 / seconds
Query Executed:select id FROM `vt` where city='Pawlet' && SIC_code='1521'DB:business_master_new
loadtime:0.61295795440674 / seconds
Query Executed:select * from geodata_geocity where city='Peacham' limit 1DB:business_master_new
loadtime:0.61339783668518 / seconds
Query stored in cache : _QUERY_www.toadli.comdfcf43b5beab37f6d94f8b6c96e16135
loadtime:0.61346292495728 / seconds
Query Executed:select id FROM `vt` where city='Peacham' && SIC_code='1521'DB:business_master_new
loadtime:0.61412191390991 / seconds
Query Executed:select * from geodata_geocity where city='Perkinsville' limit 1DB:business_master_new
loadtime:0.61457490921021 / seconds
Query stored in cache : _QUERY_www.toadli.com93ec4c54b4c6d08bb366ba623356c21a
loadtime:0.61465096473694 / seconds
Query Executed:select id FROM `vt` where city='Perkinsville' && SIC_code='1521'DB:business_master_new
loadtime:0.62332081794739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peru' limit 1
loadtime:0.62339186668396 / seconds
Query Executed:select id FROM `vt` where city='Peru' && SIC_code='1521'DB:business_master_new
loadtime:0.62405300140381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsfield' limit 1
loadtime:0.62411999702454 / seconds
Query Executed:select id FROM `vt` where city='Pittsfield' && SIC_code='1521'DB:business_master_new
loadtime:0.62484288215637 / seconds
Query Executed:select * from geodata_geocity where city='Pittsford' limit 1DB:business_master_new
loadtime:0.62531995773315 / seconds
Query stored in cache : _QUERY_www.toadli.com6dd6e565218482de17055f0e5f703065
loadtime:0.62538981437683 / seconds
Query Executed:select id FROM `vt` where city='Pittsford' && SIC_code='1521'DB:business_master_new
loadtime:0.62793588638306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:0.62800693511963 / seconds
Query Executed:select id FROM `vt` where city='Plainfield' && SIC_code='1521'DB:business_master_new
loadtime:0.63671779632568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.63679385185242 / seconds
Query Executed:select id FROM `vt` where city='Plymouth' && SIC_code='1521'DB:business_master_new
loadtime:0.63748502731323 / seconds
Query Executed:select * from geodata_geocity where city='Post Mills' limit 1DB:business_master_new
loadtime:0.63796091079712 / seconds
Query stored in cache : _QUERY_www.toadli.com94507467afedf92943d682a31858865b
loadtime:0.63802480697632 / seconds
Query Executed:select id FROM `vt` where city='Post Mills' && SIC_code='1521'DB:business_master_new
loadtime:0.63856792449951 / seconds
Query Executed:select * from geodata_geocity where city='Poultney' limit 1DB:business_master_new
loadtime:0.63900279998779 / seconds
Query stored in cache : _QUERY_www.toadli.com25ab7caea30b642b1cd92e4e98976e38
loadtime:0.6390688419342 / seconds
Query Executed:select id FROM `vt` where city='Poultney' && SIC_code='1521'DB:business_master_new
loadtime:0.64189696311951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pownal' limit 1
loadtime:0.64196801185608 / seconds
Query Executed:select id FROM `vt` where city='Pownal' && SIC_code='1521'DB:business_master_new
loadtime:0.65043187141418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Proctor' limit 1
loadtime:0.65050101280212 / seconds
Query Executed:select id FROM `vt` where city='Proctor' && SIC_code='1521'DB:business_master_new
loadtime:0.65919589996338 / seconds
Query Executed:select * from geodata_geocity where city='Proctorsville' limit 1DB:business_master_new
loadtime:0.65966987609863 / seconds
Query stored in cache : _QUERY_www.toadli.combda4deb29fcff58f46b1690ef87e406e
loadtime:0.65973496437073 / seconds
Query Executed:select id FROM `vt` where city='Proctorsville' && SIC_code='1521'DB:business_master_new
loadtime:0.66058993339539 / seconds
Query Executed:select * from geodata_geocity where city='Putney' limit 1DB:business_master_new
loadtime:0.66102981567383 / seconds
Query stored in cache : _QUERY_www.toadli.com24bacba7961b395bde3170f0933d8a3b
loadtime:0.66109490394592 / seconds
Query Executed:select id FROM `vt` where city='Putney' && SIC_code='1521'DB:business_master_new
loadtime:0.6643660068512 / seconds
Query Executed:select * from geodata_geocity where city='Quechee' limit 1DB:business_master_new
loadtime:0.66484093666077 / seconds
Query stored in cache : _QUERY_www.toadli.com4eabecffe6a2fe379b6bf565d5021a09
loadtime:0.66490602493286 / seconds
Query Executed:select id FROM `vt` where city='Quechee' && SIC_code='1521'DB:business_master_new
loadtime:0.66719794273376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:0.66727495193481 / seconds
Query Executed:select id FROM `vt` where city='Randolph' && SIC_code='1521'DB:business_master_new
loadtime:0.67159700393677 / seconds
Query Executed:select * from geodata_geocity where city='Randolph Center' limit 1DB:business_master_new
loadtime:0.67204880714417 / seconds
Query stored in cache : _QUERY_www.toadli.comc339977b027d449d94a08d73623b6937
loadtime:0.67211580276489 / seconds
Query Executed:select id FROM `vt` where city='Randolph Center' && SIC_code='1521'DB:business_master_new
loadtime:0.6729907989502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reading' limit 1
loadtime:0.67306089401245 / seconds
Query Executed:select id FROM `vt` where city='Reading' && SIC_code='1521'DB:business_master_new
loadtime:0.67383098602295 / seconds
Query Executed:select * from geodata_geocity where city='Readsboro' limit 1DB:business_master_new
loadtime:0.6742639541626 / seconds
Query stored in cache : _QUERY_www.toadli.com797b085974345a72807cc16e75bf88bd
loadtime:0.67432880401611 / seconds
Query Executed:select id FROM `vt` where city='Readsboro' && SIC_code='1521'DB:business_master_new
loadtime:0.6750910282135 / seconds
Query Executed:select * from geodata_geocity where city='Richford' limit 1DB:business_master_new
loadtime:0.67550897598267 / seconds
Query stored in cache : _QUERY_www.toadli.com9c0938cf48b916637c33ef3e7d10c379
loadtime:0.67557287216187 / seconds
Query Executed:select id FROM `vt` where city='Richford' && SIC_code='1521'DB:business_master_new
loadtime:0.67775702476501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:0.67781686782837 / seconds
Query Executed:select id FROM `vt` where city='Richmond' && SIC_code='1521'DB:business_master_new
loadtime:0.6812219619751 / seconds
Query Executed:select * from geodata_geocity where city='Ripton' limit 1DB:business_master_new
loadtime:0.68169188499451 / seconds
Query stored in cache : _QUERY_www.toadli.com73118ad62f688e344cb131223699adb4
loadtime:0.68176198005676 / seconds
Query Executed:select id FROM `vt` where city='Ripton' && SIC_code='1521'DB:business_master_new
loadtime:0.68225693702698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:0.68232989311218 / seconds
Query Executed:select id FROM `vt` where city='Rochester' && SIC_code='1521'DB:business_master_new
loadtime:0.69096183776855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:0.69103002548218 / seconds
Query Executed:select id FROM `vt` where city='Roxbury' && SIC_code='1521'DB:business_master_new
loadtime:0.6917200088501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rupert' limit 1
loadtime:0.69177794456482 / seconds
Query Executed:select id FROM `vt` where city='Rupert' && SIC_code='1521'DB:business_master_new
loadtime:0.69232702255249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:0.69238495826721 / seconds
Query Executed:select id FROM `vt` where city='Rutland' && SIC_code='1521'DB:business_master_new
loadtime:0.70108389854431 / seconds
Query Executed:select * from geodata_geocity where city='Ryegate' limit 1DB:business_master_new
loadtime:0.70157098770142 / seconds
Query stored in cache : _QUERY_www.toadli.com915ae18efd51659bcf6b313648035d8e
loadtime:0.70164680480957 / seconds
Query Executed:select id FROM `vt` where city='Ryegate' && SIC_code='1521'DB:business_master_new
loadtime:0.70210599899292 / seconds
Query Executed:select * from geodata_geocity where city='S Londonderry' limit 1DB:business_master_new
loadtime:0.70252895355225 / seconds
Query stored in cache : _QUERY_www.toadli.com4df86f954abfb2d25c353736714bdbb3
loadtime:0.70259284973145 / seconds
Query Executed:select id FROM `vt` where city='S Londonderry' && SIC_code='1521'DB:business_master_new
loadtime:0.70314693450928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Albans' limit 1
loadtime:0.703204870224 / seconds
Query Executed:select id FROM `vt` where city='Saint Albans' && SIC_code='1521'DB:business_master_new
loadtime:0.71382880210876 / seconds
Query Executed:select * from geodata_geocity where city='Saint Albans Bay' limit 1DB:business_master_new
loadtime:0.71429181098938 / seconds
Query stored in cache : _QUERY_www.toadli.comb831859a2bdf9788a9a2a844bf1960da
loadtime:0.71435880661011 / seconds
Query Executed:select id FROM `vt` where city='Saint Albans Bay' && SIC_code='1521'DB:business_master_new
loadtime:0.71496796607971 / seconds
Query Executed:select * from geodata_geocity where city='Saint Johnsbury' limit 1DB:business_master_new
loadtime:0.71538782119751 / seconds
Query stored in cache : _QUERY_www.toadli.com1f51c8ede5d3e4b6029176dc775a954c
loadtime:0.71545195579529 / seconds
Query Executed:select id FROM `vt` where city='Saint Johnsbury' && SIC_code='1521'DB:business_master_new
loadtime:0.72431182861328 / seconds
Query Executed:select * from geodata_geocity where city='Saint Johnsbury Center' limit 1DB:business_master_new
loadtime:0.72475790977478 / seconds
Query stored in cache : _QUERY_www.toadli.comc3e559c2c894a25977fb66aa02c85925
loadtime:0.72482895851135 / seconds
Query Executed:select id FROM `vt` where city='Saint Johnsbury Center' && SIC_code='1521'DB:business_master_new
loadtime:0.72544884681702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:0.72551679611206 / seconds
Query Executed:select id FROM `vt` where city='Salisbury' && SIC_code='1521'DB:business_master_new
loadtime:0.72648191452026 / seconds
Query Executed:select * from geodata_geocity where city='Saxtons River' limit 1DB:business_master_new
loadtime:0.72694396972656 / seconds
Query stored in cache : _QUERY_www.toadli.comb04518ece31f8d2941147d5f0eb108aa
loadtime:0.72701001167297 / seconds
Query Executed:select id FROM `vt` where city='Saxtons River' && SIC_code='1521'DB:business_master_new
loadtime:0.73562002182007 / seconds
Query Executed:select * from geodata_geocity where city='Shaftsbury' limit 1DB:business_master_new
loadtime:0.73607802391052 / seconds
Query stored in cache : _QUERY_www.toadli.comc3d36e19f759ceb5bbba6c37bf289c29
loadtime:0.73614382743835 / seconds
Query Executed:select id FROM `vt` where city='Shaftsbury' && SIC_code='1521'DB:business_master_new
loadtime:0.7385938167572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.73867702484131 / seconds
Query Executed:select id FROM `vt` where city='Sharon' && SIC_code='1521'DB:business_master_new
loadtime:0.74725580215454 / seconds
Query Executed:select * from geodata_geocity where city='Sheffield' limit 1DB:business_master_new
loadtime:0.74771285057068 / seconds
Query stored in cache : _QUERY_www.toadli.come2220104c798d501f4669ca8607847fb
loadtime:0.74777793884277 / seconds
Query Executed:select id FROM `vt` where city='Sheffield' && SIC_code='1521'DB:business_master_new
loadtime:0.74840092658997 / seconds
Query Executed:select * from geodata_geocity where city='Shelburne' limit 1DB:business_master_new
loadtime:0.74886202812195 / seconds
Query stored in cache : _QUERY_www.toadli.com60cc4a906ac2dcca01273fd98efeab75
loadtime:0.74892687797546 / seconds
Query Executed:select id FROM `vt` where city='Shelburne' && SIC_code='1521'DB:business_master_new
loadtime:0.75513792037964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon' limit 1
loadtime:0.75522685050964 / seconds
Query Executed:select id FROM `vt` where city='Sheldon' && SIC_code='1521'DB:business_master_new
loadtime:0.7561399936676 / seconds
Query Executed:select * from geodata_geocity where city='Sheldon Springs' limit 1DB:business_master_new
loadtime:0.756591796875 / seconds
Query stored in cache : _QUERY_www.toadli.come94ad936436bbfd0348642ed3ffcb311
loadtime:0.75666785240173 / seconds
Query Executed:select id FROM `vt` where city='Sheldon Springs' && SIC_code='1521'DB:business_master_new
loadtime:0.75723195075989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shoreham' limit 1
loadtime:0.75728797912598 / seconds
Query Executed:select id FROM `vt` where city='Shoreham' && SIC_code='1521'DB:business_master_new
loadtime:0.76597690582275 / seconds
Query Executed:select * from geodata_geocity where city='South Barre' limit 1DB:business_master_new
loadtime:0.76644802093506 / seconds
Query stored in cache : _QUERY_www.toadli.coma720a63937a460a586a0c160c5465340
loadtime:0.76651287078857 / seconds
Query Executed:select id FROM `vt` where city='South Barre' && SIC_code='1521'DB:business_master_new
loadtime:0.76737189292908 / seconds
Query Executed:select * from geodata_geocity where city='South Burlington' limit 1DB:business_master_new
loadtime:0.76777791976929 / seconds
Query stored in cache : _QUERY_www.toadli.com37d8e973d1305f7f636dd82edfb18545
loadtime:0.76784682273865 / seconds
Query Executed:select id FROM `vt` where city='South Burlington' && SIC_code='1521'DB:business_master_new
loadtime:0.78369688987732 / seconds
Query Executed:select * from geodata_geocity where city='South Hero' limit 1DB:business_master_new
loadtime:0.78412699699402 / seconds
Query stored in cache : _QUERY_www.toadli.comdc5ffe9ae2e82005a1b557403a93e784
loadtime:0.78420186042786 / seconds
Query Executed:select id FROM `vt` where city='South Hero' && SIC_code='1521'DB:business_master_new
loadtime:0.78660702705383 / seconds
Query Executed:select * from geodata_geocity where city='South Londonderry' limit 1DB:business_master_new
loadtime:0.78703284263611 / seconds
Query stored in cache : _QUERY_www.toadli.com3e9bee75de121d42173ef3349c294571
loadtime:0.7870979309082 / seconds
Query Executed:select id FROM `vt` where city='South Londonderry' && SIC_code='1521'DB:business_master_new
loadtime:0.79588198661804 / seconds
Query Executed:select * from geodata_geocity where city='South Newfane' limit 1DB:business_master_new
loadtime:0.79629492759705 / seconds
Query stored in cache : _QUERY_www.toadli.comaf9d73d02fcb356b131754c4673e2cd4
loadtime:0.79636096954346 / seconds
Query Executed:select id FROM `vt` where city='South Newfane' && SIC_code='1521'DB:business_master_new
loadtime:0.796875 / seconds
Query Executed:select * from geodata_geocity where city='South Pomfret' limit 1DB:business_master_new
loadtime:0.79726099967957 / seconds
Query stored in cache : _QUERY_www.toadli.comb223750e26c7983efd4f05cb74ed0de4
loadtime:0.7973268032074 / seconds
Query Executed:select id FROM `vt` where city='South Pomfret' && SIC_code='1521'DB:business_master_new
loadtime:0.79799294471741 / seconds
Query Executed:select * from geodata_geocity where city='South Royalton' limit 1DB:business_master_new
loadtime:0.79837083816528 / seconds
Query stored in cache : _QUERY_www.toadli.comd770ede2a91e62bf70d08298b76b695e
loadtime:0.79843497276306 / seconds
Query Executed:select id FROM `vt` where city='South Royalton' && SIC_code='1521'DB:business_master_new
loadtime:0.80101680755615 / seconds
Query Executed:select * from geodata_geocity where city='South Ryegate' limit 1DB:business_master_new
loadtime:0.80141282081604 / seconds
Query stored in cache : _QUERY_www.toadli.comca1e5e86facfba288207d4766d5fcc56
loadtime:0.80147790908813 / seconds
Query Executed:select id FROM `vt` where city='South Ryegate' && SIC_code='1521'DB:business_master_new
loadtime:0.80213594436646 / seconds
Query Executed:select * from geodata_geocity where city='South Strafford' limit 1DB:business_master_new
loadtime:0.8025209903717 / seconds
Query stored in cache : _QUERY_www.toadli.com67211c6eb9728dcc7b600f51732df508
loadtime:0.8025918006897 / seconds
Query Executed:select id FROM `vt` where city='South Strafford' && SIC_code='1521'DB:business_master_new
loadtime:0.80326986312866 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Woodstock' limit 1
loadtime:0.80334496498108 / seconds
Query Executed:select id FROM `vt` where city='South Woodstock' && SIC_code='1521'DB:business_master_new
loadtime:0.80400800704956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.80407691001892 / seconds
Query Executed:select id FROM `vt` where city='Springfield' && SIC_code='1521'DB:business_master_new
loadtime:0.81097888946533 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Albans' limit 1
loadtime:0.81107091903687 / seconds
Query Executed:select id FROM `vt` where city='St Albans' && SIC_code='1521'DB:business_master_new
loadtime:0.8116090297699 / seconds
Query Executed:select * from geodata_geocity where city='St Albans Bay' limit 1DB:business_master_new
loadtime:0.81206393241882 / seconds
Query stored in cache : _QUERY_www.toadli.comaaf49c4e2f2d78db8107b0f2266d4a22
loadtime:0.81212902069092 / seconds
Query Executed:select id FROM `vt` where city='St Albans Bay' && SIC_code='1521'DB:business_master_new
loadtime:0.81264281272888 / seconds
Query loaded from cache:select * from geodata_geocity where city='St George' limit 1
loadtime:0.81269693374634 / seconds
Query Executed:select id FROM `vt` where city='St George' && SIC_code='1521'DB:business_master_new
loadtime:0.8131217956543 / seconds
Query Executed:select * from geodata_geocity where city='St Johnsbury' limit 1DB:business_master_new
loadtime:0.81357383728027 / seconds
Query stored in cache : _QUERY_www.toadli.com2c3073748b03799f18fcd48251aca7c8
loadtime:0.81365299224854 / seconds
Query Executed:select id FROM `vt` where city='St Johnsbury' && SIC_code='1521'DB:business_master_new
loadtime:0.8144907951355 / seconds
Query Executed:select * from geodata_geocity where city='St Johnsbury Ctr' limit 1DB:business_master_new
loadtime:0.81497597694397 / seconds
Query stored in cache : _QUERY_www.toadli.coma75101d10f447f97cee9a484e0f223b6
loadtime:0.81504082679749 / seconds
Query Executed:select id FROM `vt` where city='St Johnsbury Ctr' && SIC_code='1521'DB:business_master_new
loadtime:0.81539583206177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stamford' limit 1
loadtime:0.81544899940491 / seconds
Query Executed:select id FROM `vt` where city='Stamford' && SIC_code='1521'DB:business_master_new
loadtime:0.81609487533569 / seconds
Query Executed:select * from geodata_geocity where city='Starksboro' limit 1DB:business_master_new
loadtime:0.81655287742615 / seconds
Query stored in cache : _QUERY_www.toadli.com27274e11724c9488aa27124f26a98c6d
loadtime:0.81663179397583 / seconds
Query Executed:select id FROM `vt` where city='Starksboro' && SIC_code='1521'DB:business_master_new
loadtime:0.82515597343445 / seconds
Query Executed:select * from geodata_geocity where city='Stockbridge' limit 1DB:business_master_new
loadtime:0.82562589645386 / seconds
Query stored in cache : _QUERY_www.toadli.comae22e8d93e914e37faccde30db1c99c2
loadtime:0.82569098472595 / seconds
Query Executed:select id FROM `vt` where city='Stockbridge' && SIC_code='1521'DB:business_master_new
loadtime:0.82634687423706 / seconds
Query Executed:select * from geodata_geocity where city='Stowe' limit 1DB:business_master_new
loadtime:0.8267719745636 / seconds
Query stored in cache : _QUERY_www.toadli.com493a5606e7912e1e476d686a122f98a7
loadtime:0.82684683799744 / seconds
Query Executed:select id FROM `vt` where city='Stowe' && SIC_code='1521'DB:business_master_new
loadtime:0.83418583869934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strafford' limit 1
loadtime:0.8342719078064 / seconds
Query Executed:select id FROM `vt` where city='Strafford' && SIC_code='1521'DB:business_master_new
loadtime:0.83491587638855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutton' limit 1
loadtime:0.83498382568359 / seconds
Query Executed:select id FROM `vt` where city='Sutton' && SIC_code='1521'DB:business_master_new
loadtime:0.83561086654663 / seconds
Query Executed:select * from geodata_geocity where city='Swanton' limit 1DB:business_master_new
loadtime:0.83607387542725 / seconds
Query stored in cache : _QUERY_www.toadli.com8d78729ebc3200482e1d52c15d9b432a
loadtime:0.83613896369934 / seconds
Query Executed:select id FROM `vt` where city='Swanton' && SIC_code='1521'DB:business_master_new
loadtime:0.84082698822021 / seconds
Query Executed:select * from geodata_geocity where city='Taftsville' limit 1DB:business_master_new
loadtime:0.84131097793579 / seconds
Query stored in cache : _QUERY_www.toadli.com4fceec0c8a761f379878c1b843a3da66
loadtime:0.84138083457947 / seconds
Query Executed:select id FROM `vt` where city='Taftsville' && SIC_code='1521'DB:business_master_new
loadtime:0.84191799163818 / seconds
Query Executed:select * from geodata_geocity where city='Thetford' limit 1DB:business_master_new
loadtime:0.84234881401062 / seconds
Query stored in cache : _QUERY_www.toadli.com4815a8c5be2b073dedc9cc0ba985d404
loadtime:0.8424129486084 / seconds
Query Executed:select id FROM `vt` where city='Thetford' && SIC_code='1521'DB:business_master_new
loadtime:0.8431658744812 / seconds
Query Executed:select * from geodata_geocity where city='Thetford Center' limit 1DB:business_master_new
loadtime:0.84359097480774 / seconds
Query stored in cache : _QUERY_www.toadli.com0f5332921f723f06dcec4475d925c426
loadtime:0.84366297721863 / seconds
Query Executed:select id FROM `vt` where city='Thetford Center' && SIC_code='1521'DB:business_master_new
loadtime:0.84451198577881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topsham' limit 1
loadtime:0.84457802772522 / seconds
Query Executed:select id FROM `vt` where city='Topsham' && SIC_code='1521'DB:business_master_new
loadtime:0.84503197669983 / seconds
Query Executed:select * from geodata_geocity where city='Townshend' limit 1DB:business_master_new
loadtime:0.84542679786682 / seconds
Query stored in cache : _QUERY_www.toadli.com01544fb93bd0cb980878079fc7f11c08
loadtime:0.8454909324646 / seconds
Query Executed:select id FROM `vt` where city='Townshend' && SIC_code='1521'DB:business_master_new
loadtime:0.85411095619202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:0.85416483879089 / seconds
Query Executed:select id FROM `vt` where city='Troy' && SIC_code='1521'DB:business_master_new
loadtime:0.85487079620361 / seconds
Query Executed:select * from geodata_geocity where city='Tunbridge' limit 1DB:business_master_new
loadtime:0.85532593727112 / seconds
Query stored in cache : _QUERY_www.toadli.com2c502c40104689c236b68406a88c61ef
loadtime:0.85539102554321 / seconds
Query Executed:select id FROM `vt` where city='Tunbridge' && SIC_code='1521'DB:business_master_new
loadtime:0.85629487037659 / seconds
Query Executed:select * from geodata_geocity where city='Underhill' limit 1DB:business_master_new
loadtime:0.85675501823425 / seconds
Query stored in cache : _QUERY_www.toadli.com6f8a5057c03ccb28f494900393278e62
loadtime:0.85682487487793 / seconds
Query Executed:select id FROM `vt` where city='Underhill' && SIC_code='1521'DB:business_master_new
loadtime:0.85896492004395 / seconds
Query Executed:select * from geodata_geocity where city='Underhill Center' limit 1DB:business_master_new
loadtime:0.85942387580872 / seconds
Query stored in cache : _QUERY_www.toadli.com95d46200c880992e617fcf442f7fb14b
loadtime:0.8594868183136 / seconds
Query Executed:select id FROM `vt` where city='Underhill Center' && SIC_code='1521'DB:business_master_new
loadtime:0.86009192466736 / seconds
Query Executed:select * from geodata_geocity where city='Vergennes' limit 1DB:business_master_new
loadtime:0.86056089401245 / seconds
Query stored in cache : _QUERY_www.toadli.com9a169116661bd0e8f73f7c52c335f706
loadtime:0.86063885688782 / seconds
Query Executed:select id FROM `vt` where city='Vergennes' && SIC_code='1521'DB:business_master_new
loadtime:0.8651819229126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:0.86526393890381 / seconds
Query Executed:select id FROM `vt` where city='Vernon' && SIC_code='1521'DB:business_master_new
loadtime:0.8739697933197 / seconds
Query Executed:select * from geodata_geocity where city='Vershire' limit 1DB:business_master_new
loadtime:0.87439393997192 / seconds
Query stored in cache : _QUERY_www.toadli.comd1d923372af67e36b09ae5b83acdaeef
loadtime:0.87445902824402 / seconds
Query Executed:select id FROM `vt` where city='Vershire' && SIC_code='1521'DB:business_master_new
loadtime:0.87504887580872 / seconds
Query Executed:select * from geodata_geocity where city='Waitsfield' limit 1DB:business_master_new
loadtime:0.87544298171997 / seconds
Query stored in cache : _QUERY_www.toadli.com4f5a625c21776d0beb0f314dd1136eab
loadtime:0.87551188468933 / seconds
Query Executed:select id FROM `vt` where city='Waitsfield' && SIC_code='1521'DB:business_master_new
loadtime:0.88081002235413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallingford' limit 1
loadtime:0.88089680671692 / seconds
Query Executed:select id FROM `vt` where city='Wallingford' && SIC_code='1521'DB:business_master_new
loadtime:0.88334083557129 / seconds
Query Executed:select * from geodata_geocity where city='Wardsboro' limit 1DB:business_master_new
loadtime:0.88380980491638 / seconds
Query stored in cache : _QUERY_www.toadli.comd1917d6f7d62d608ba5e882c4edac611
loadtime:0.88387584686279 / seconds
Query Executed:select id FROM `vt` where city='Wardsboro' && SIC_code='1521'DB:business_master_new
loadtime:0.88451385498047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:0.88457489013672 / seconds
Query Executed:select id FROM `vt` where city='Warren' && SIC_code='1521'DB:business_master_new
loadtime:0.88728880882263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.8873598575592 / seconds
Query Executed:select id FROM `vt` where city='Washington' && SIC_code='1521'DB:business_master_new
loadtime:0.88820695877075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury' limit 1
loadtime:0.88826084136963 / seconds
Query Executed:select id FROM `vt` where city='Waterbury' && SIC_code='1521'DB:business_master_new
loadtime:0.893718957901 / seconds
Query Executed:select * from geodata_geocity where city='Waterbury Center' limit 1DB:business_master_new
loadtime:0.89418983459473 / seconds
Query stored in cache : _QUERY_www.toadli.com74dddac91e9c23d94db1cd4f382bc1ae
loadtime:0.89425492286682 / seconds
Query Executed:select id FROM `vt` where city='Waterbury Center' && SIC_code='1521'DB:business_master_new
loadtime:0.89644002914429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville' limit 1
loadtime:0.89651083946228 / seconds
Query Executed:select id FROM `vt` where city='Waterville' && SIC_code='1521'DB:business_master_new
loadtime:0.8972430229187 / seconds
Query Executed:select * from geodata_geocity where city='Websterville' limit 1DB:business_master_new
loadtime:0.89772200584412 / seconds
Query stored in cache : _QUERY_www.toadli.com1fb9a7c573207f474ed39cd0da9e1c41
loadtime:0.89779186248779 / seconds
Query Executed:select id FROM `vt` where city='Websterville' && SIC_code='1521'DB:business_master_new
loadtime:0.89834594726562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wells' limit 1
loadtime:0.89840197563171 / seconds
Query Executed:select id FROM `vt` where city='Wells' && SIC_code='1521'DB:business_master_new
loadtime:0.89920401573181 / seconds
Query Executed:select * from geodata_geocity where city='Wells River' limit 1DB:business_master_new
loadtime:0.89967489242554 / seconds
Query stored in cache : _QUERY_www.toadli.comcf3e39177fa272b6ba293a8143c3a828
loadtime:0.89973998069763 / seconds
Query Executed:select id FROM `vt` where city='Wells River' && SIC_code='1521'DB:business_master_new
loadtime:0.90836787223816 / seconds
Query Executed:select * from geodata_geocity where city='West Burke' limit 1DB:business_master_new
loadtime:0.90879082679749 / seconds
Query stored in cache : _QUERY_www.toadli.com0565e7793d12224303c4dcdda0213d2b
loadtime:0.90885901451111 / seconds
Query Executed:select id FROM `vt` where city='West Burke' && SIC_code='1521'DB:business_master_new
loadtime:0.91718983650208 / seconds
Query Executed:select * from geodata_geocity where city='West Charleston' limit 1DB:business_master_new
loadtime:0.91759991645813 / seconds
Query stored in cache : _QUERY_www.toadli.com1155644ef2ebcdd4c86ab671c9542a0a
loadtime:0.91767501831055 / seconds
Query Executed:select id FROM `vt` where city='West Charleston' && SIC_code='1521'DB:business_master_new
loadtime:0.91829085350037 / seconds
Query Executed:select * from geodata_geocity where city='West Danville' limit 1DB:business_master_new
loadtime:0.91874194145203 / seconds
Query stored in cache : _QUERY_www.toadli.comebc6e36f686d0393aabcbd02caf7097b
loadtime:0.91881084442139 / seconds
Query Executed:select id FROM `vt` where city='West Danville' && SIC_code='1521'DB:business_master_new
loadtime:0.91954588890076 / seconds
Query Executed:select * from geodata_geocity where city='West Dover' limit 1DB:business_master_new
loadtime:0.91997790336609 / seconds
Query stored in cache : _QUERY_www.toadli.com761f0a4e269dcbf34c0b433199eb99b1
loadtime:0.92004299163818 / seconds
Query Executed:select id FROM `vt` where city='West Dover' && SIC_code='1521'DB:business_master_new
loadtime:0.92285299301147 / seconds
Query Executed:select * from geodata_geocity where city='West Dummerston' limit 1DB:business_master_new
loadtime:0.92329096794128 / seconds
Query stored in cache : _QUERY_www.toadli.com4a017a7eafba7d358e6453422e689981
loadtime:0.9233558177948 / seconds
Query Executed:select id FROM `vt` where city='West Dummerston' && SIC_code='1521'DB:business_master_new
loadtime:0.92385196685791 / seconds
Query Executed:select * from geodata_geocity where city='West Fairlee' limit 1DB:business_master_new
loadtime:0.92427396774292 / seconds
Query stored in cache : _QUERY_www.toadli.com40d313e4983a0b9ba0ad6e1748d4d7b5
loadtime:0.92433786392212 / seconds
Query Executed:select id FROM `vt` where city='West Fairlee' && SIC_code='1521'DB:business_master_new
loadtime:0.92495489120483 / seconds
Query Executed:select * from geodata_geocity where city='West Glover' limit 1DB:business_master_new
loadtime:0.92538285255432 / seconds
Query stored in cache : _QUERY_www.toadli.com81a1a18a88578b31288c5f952cfbac5b
loadtime:0.9254457950592 / seconds
Query Executed:select id FROM `vt` where city='West Glover' && SIC_code='1521'DB:business_master_new
loadtime:0.9258668422699 / seconds
Query Executed:select * from geodata_geocity where city='West Halifax' limit 1DB:business_master_new
loadtime:0.92627882957458 / seconds
Query stored in cache : _QUERY_www.toadli.comb3868183f7bd6aaccdd537e11bcd91b8
loadtime:0.92634296417236 / seconds
Query Executed:select id FROM `vt` where city='West Halifax' && SIC_code='1521'DB:business_master_new
loadtime:0.92690992355347 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartford' limit 1
loadtime:0.92696499824524 / seconds
Query Executed:select id FROM `vt` where city='West Hartford' && SIC_code='1521'DB:business_master_new
loadtime:0.92750883102417 / seconds
Query Executed:select * from geodata_geocity where city='West Marlboro' limit 1DB:business_master_new
loadtime:0.92793297767639 / seconds
Query stored in cache : _QUERY_www.toadli.com78598299913a48971391e71c99c87940
loadtime:0.92799592018127 / seconds
Query Executed:select id FROM `vt` where city='West Marlboro' && SIC_code='1521'DB:business_master_new
loadtime:0.92841196060181 / seconds
Query Executed:select * from geodata_geocity where city='West Newbury' limit 1DB:business_master_new
loadtime:0.92883801460266 / seconds
Query stored in cache : _QUERY_www.toadli.come8541e0156a40bb07e4b6a2d8bad8ba2
loadtime:0.92890191078186 / seconds
Query Executed:select id FROM `vt` where city='West Newbury' && SIC_code='1521'DB:business_master_new
loadtime:0.9294068813324 / seconds
Query Executed:select * from geodata_geocity where city='West Pawlet' limit 1DB:business_master_new
loadtime:0.92987990379333 / seconds
Query stored in cache : _QUERY_www.toadli.comb26083096857bdb90ceb0106d89c1719
loadtime:0.92994594573975 / seconds
Query Executed:select id FROM `vt` where city='West Pawlet' && SIC_code='1521'DB:business_master_new
loadtime:0.93066692352295 / seconds
Query Executed:select * from geodata_geocity where city='West Rupert' limit 1DB:business_master_new
loadtime:0.93107295036316 / seconds
Query stored in cache : _QUERY_www.toadli.com24a23c42ba1ca1fdb9bf86db7a520995
loadtime:0.93113780021667 / seconds
Query Executed:select id FROM `vt` where city='West Rupert' && SIC_code='1521'DB:business_master_new
loadtime:0.93166184425354 / seconds
Query Executed:select * from geodata_geocity where city='West Rutland' limit 1DB:business_master_new
loadtime:0.93205380439758 / seconds
Query stored in cache : _QUERY_www.toadli.com336d872798ad02111b63d6614a042317
loadtime:0.93211793899536 / seconds
Query Executed:select id FROM `vt` where city='West Rutland' && SIC_code='1521'DB:business_master_new
loadtime:0.9347608089447 / seconds
Query Executed:select * from geodata_geocity where city='West Topsham' limit 1DB:business_master_new
loadtime:0.93518686294556 / seconds
Query stored in cache : _QUERY_www.toadli.com270649ecadb7095c9490e0ee34596748
loadtime:0.93525195121765 / seconds
Query Executed:select id FROM `vt` where city='West Topsham' && SIC_code='1521'DB:business_master_new
loadtime:0.93582987785339 / seconds
Query Executed:select * from geodata_geocity where city='West Townshend' limit 1DB:business_master_new
loadtime:0.93622493743896 / seconds
Query stored in cache : _QUERY_www.toadli.comce0c60b6162c127f1143d0a41bcf0f30
loadtime:0.93629002571106 / seconds
Query Executed:select id FROM `vt` where city='West Townshend' && SIC_code='1521'DB:business_master_new
loadtime:0.93687891960144 / seconds
Query Executed:select * from geodata_geocity where city='West Wardsboro' limit 1DB:business_master_new
loadtime:0.93726491928101 / seconds
Query stored in cache : _QUERY_www.toadli.com9f0fe71df88480674eade58713947b16
loadtime:0.93732690811157 / seconds
Query Executed:select id FROM `vt` where city='West Wardsboro' && SIC_code='1521'DB:business_master_new
loadtime:0.93798685073853 / seconds
Query Executed:select * from geodata_geocity where city='West Windsor' limit 1DB:business_master_new
loadtime:0.93837785720825 / seconds
Query stored in cache : _QUERY_www.toadli.come34a0dcfc5ab647a0508df054006efa2
loadtime:0.93844079971313 / seconds
Query Executed:select id FROM `vt` where city='West Windsor' && SIC_code='1521'DB:business_master_new
loadtime:0.93885684013367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:0.93891191482544 / seconds
Query Executed:select id FROM `vt` where city='Westfield' && SIC_code='1521'DB:business_master_new
loadtime:0.93958687782288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westford' limit 1
loadtime:0.93966293334961 / seconds
Query Executed:select id FROM `vt` where city='Westford' && SIC_code='1521'DB:business_master_new
loadtime:0.94831895828247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:0.94839191436768 / seconds
Query Executed:select id FROM `vt` where city='Westminster' && SIC_code='1521'DB:business_master_new
loadtime:0.95693182945251 / seconds
Query Executed:select * from geodata_geocity where city='Westminster Sta' limit 1DB:business_master_new
loadtime:0.95739698410034 / seconds
Query stored in cache : _QUERY_www.toadli.com3179ece4677c9b25e69fdc06fa547b54
loadtime:0.95746088027954 / seconds
Query Executed:select id FROM `vt` where city='Westminster Sta' && SIC_code='1521'DB:business_master_new
loadtime:0.95788383483887 / seconds
Query Executed:select * from geodata_geocity where city='Westminster Station' limit 1DB:business_master_new
loadtime:0.95831799507141 / seconds
Query stored in cache : _QUERY_www.toadli.comde50ec7462dba175fad5f55d94bd4add
loadtime:0.95838284492493 / seconds
Query Executed:select id FROM `vt` where city='Westminster Station' && SIC_code='1521'DB:business_master_new
loadtime:0.958979845047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:0.95903491973877 / seconds
Query Executed:select id FROM `vt` where city='Weston' && SIC_code='1521'DB:business_master_new
loadtime:0.96735692024231 / seconds
Query Executed:select * from geodata_geocity where city='White River Jct' limit 1DB:business_master_new
loadtime:0.96780800819397 / seconds
Query stored in cache : _QUERY_www.toadli.comef1656659d211eb4e8c3f13e5115f297
loadtime:0.9678738117218 / seconds
Query Executed:select id FROM `vt` where city='White River Jct' && SIC_code='1521'DB:business_master_new
loadtime:0.96835684776306 / seconds
Query Executed:select * from geodata_geocity where city='White River Junction' limit 1DB:business_master_new
loadtime:0.96877980232239 / seconds
Query stored in cache : _QUERY_www.toadli.com7ca687e35baa9f25aac1aecf42cd669e
loadtime:0.96884894371033 / seconds
Query Executed:select id FROM `vt` where city='White River Junction' && SIC_code='1521'DB:business_master_new
loadtime:0.97594690322876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiting' limit 1
loadtime:0.97602486610413 / seconds
Query Executed:select id FROM `vt` where city='Whiting' && SIC_code='1521'DB:business_master_new
loadtime:0.97673201560974 / seconds
Query Executed:select * from geodata_geocity where city='Whitingham' limit 1DB:business_master_new
loadtime:0.97714591026306 / seconds
Query stored in cache : _QUERY_www.toadli.comd93f77b829be3c73c85313c310519759
loadtime:0.97721195220947 / seconds
Query Executed:select id FROM `vt` where city='Whitingham' && SIC_code='1521'DB:business_master_new
loadtime:0.97794795036316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilder' limit 1
loadtime:0.9780158996582 / seconds
Query Executed:select id FROM `vt` where city='Wilder' && SIC_code='1521'DB:business_master_new
loadtime:0.9866669178009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamstown' limit 1
loadtime:0.98673486709595 / seconds
Query Executed:select id FROM `vt` where city='Williamstown' && SIC_code='1521'DB:business_master_new
loadtime:0.98908591270447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsville' limit 1
loadtime:0.98915696144104 / seconds
Query Executed:select id FROM `vt` where city='Williamsville' && SIC_code='1521'DB:business_master_new
loadtime:0.98984098434448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williston' limit 1
loadtime:0.98989582061768 / seconds
Query Executed:select id FROM `vt` where city='Williston' && SIC_code='1521'DB:business_master_new
loadtime:1.0014619827271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmington' limit 1
loadtime:1.001571893692 / seconds
Query Executed:select id FROM `vt` where city='Wilmington' && SIC_code='1521'DB:business_master_new
loadtime:1.0052759647369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:1.0053558349609 / seconds
Query Executed:select id FROM `vt` where city='Windsor' && SIC_code='1521'DB:business_master_new
loadtime:1.0090248584747 / seconds
Query Executed:select * from geodata_geocity where city='Winooski' limit 1DB:business_master_new
loadtime:1.0094799995422 / seconds
Query stored in cache : _QUERY_www.toadli.coma43766e2f6d971c1be77c4c5ccd63f17
loadtime:1.009546995163 / seconds
Query Executed:select id FROM `vt` where city='Winooski' && SIC_code='1521'DB:business_master_new
loadtime:1.0136389732361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolcott' limit 1
loadtime:1.013710975647 / seconds
Query Executed:select id FROM `vt` where city='Wolcott' && SIC_code='1521'DB:business_master_new
loadtime:1.0223848819733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbury' limit 1
loadtime:1.0224590301514 / seconds
Query Executed:select id FROM `vt` where city='Woodbury' && SIC_code='1521'DB:business_master_new
loadtime:1.0230510234833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:1.0231218338013 / seconds
Query Executed:select id FROM `vt` where city='Woodstock' && SIC_code='1521'DB:business_master_new
loadtime:1.0286529064178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worcester' limit 1
loadtime:1.0287358760834 / seconds
Query Executed:select id FROM `vt` where city='Worcester' && SIC_code='1521'DB:business_master_new
loadtime:1.0294568538666 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.0296289920807 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.0300559997559 / seconds
Operation template executed (chunk cache operation)
loadtime:1.0302159786224 / seconds
template override:Default
loadtime:1.0302579402924 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:1.0315968990326 / seconds
Template Constructed, Array Rows:49
loadtime:1.0321438312531 / seconds
TOTAL EXECUTION TIME: 1.03169
loadtime:1.0347139835358 / seconds

THIS PAGE CACHED ON:
THIS PAGE COMPRESSION:
HITS TO THIS PAGE/CACHE:
PAGES STORED:
DATASIZE: Bytes
Compression:


PAGE OBJECT DATA


Key: page;
subKey: directorystate;
subKey: directorystatepages;
subKey: template;



_GET


Array ( [cat_URLid] => general-contractors-single-family-houses [stateURLid] => 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:1.0347249507904
TOTAL KEY ARRAYS: 69