Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:6.0081481933594E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0017468929290771 / seconds
host not found setting manual db connection
loadtime:0.0094649791717529 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0097260475158691 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0099020004272461 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0099649429321289 / seconds
zipcode:
loadtime:0.0099930763244629 / seconds
Query Executed:select * from search_referrer where page_hash='1e613b92e943058334c7bb0ea3804d7b' limit 10 DB:ezrox_toadli
loadtime:0.010235071182251 / seconds
Operation header executed (non global)
loadtime:0.010267019271851 / seconds
Operation leaderboard executed (non global)
loadtime:0.010317087173462 / seconds
Operation square executed (non global)
loadtime:0.010345935821533 / seconds
Operation square_bottom executed (non global)
loadtime:0.010373115539551 / seconds
Operation smallsquare executed (non global)
loadtime:0.010400056838989 / seconds
Operation headeradright executed (non global)
loadtime:0.010425090789795 / seconds
Operation google_analytics executed (non global)
loadtime:0.010449886322021 / seconds
Operation topstories executed (non global)
loadtime:0.010477066040039 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010504007339478 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010529041290283 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010787010192871 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.010982036590576 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011023044586182 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.01108193397522 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011130094528198 / seconds
Template key: archive_menu pushed
loadtime:0.011138916015625 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011152982711792 / seconds
Template key: get_gravatar pushed
loadtime:0.011161088943481 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011168956756592 / seconds
*10)-10)+1 | start:0
loadtime:0.011209011077881 / seconds
Query loaded from cache:select * from categories where cat_URLid='family-clothing-stores'
loadtime:0.01124906539917 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='vermont'
loadtime:0.011284112930298 / seconds
DB connected to localhost business_master_new
loadtime:0.01151704788208 / seconds
Query Executed:select * from `vt_catmap` where sic='5651' order by city ascDB:business_master_new
loadtime:0.020612001419067 / seconds
Query stored in cache : _QUERY_www.toadli.comef70a1500088431eb3cb4afdb348554b
loadtime:0.021912097930908 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='vermont'
loadtime:0.021966934204102 / seconds
Query Executed:select sum(totalcount) as totalsum from `vt_catmap` where sic='5651'DB:business_master_new
loadtime:0.023798942565918 / seconds
Query stored in cache : _QUERY_www.toadli.comf18f2314f240933662c08d80c31f5940
loadtime:0.023838996887207 / seconds
321 / 11
loadtime:0.023907899856567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adamant' limit 1
loadtime:0.02397608757019 / seconds
Query Executed:select id FROM `vt` where city='Adamant' && SIC_code='5651'DB:business_master_new
loadtime:0.031132936477661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albany' limit 1
loadtime:0.031196117401123 / seconds
Query Executed:select id FROM `vt` where city='Albany' && SIC_code='5651'DB:business_master_new
loadtime:0.031872034072876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alburg' limit 1
loadtime:0.031934022903442 / seconds
Query Executed:select id FROM `vt` where city='Alburg' && SIC_code='5651'DB:business_master_new
loadtime:0.032392024993896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.032454013824463 / seconds
Query Executed:select id FROM `vt` where city='Arlington' && SIC_code='5651'DB:business_master_new
loadtime:0.034943103790283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ascutney' limit 1
loadtime:0.035022020339966 / seconds
Query Executed:select id FROM `vt` where city='Ascutney' && SIC_code='5651'DB:business_master_new
loadtime:0.036204099655151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athens' limit 1
loadtime:0.036267042160034 / seconds
Query Executed:select id FROM `vt` where city='Athens' && SIC_code='5651'DB:business_master_new
loadtime:0.036696910858154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Averill' limit 1
loadtime:0.036760091781616 / seconds
Query Executed:select id FROM `vt` where city='Averill' && SIC_code='5651'DB:business_master_new
loadtime:0.037225008010864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bakersfield' limit 1
loadtime:0.037286043167114 / seconds
Query Executed:select id FROM `vt` where city='Bakersfield' && SIC_code='5651'DB:business_master_new
loadtime:0.037954092025757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnard' limit 1
loadtime:0.03801703453064 / seconds
Query Executed:select id FROM `vt` where city='Barnard' && SIC_code='5651'DB:business_master_new
loadtime:0.038796901702881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnet' limit 1
loadtime:0.038870096206665 / seconds
Query Executed:select id FROM `vt` where city='Barnet' && SIC_code='5651'DB:business_master_new
loadtime:0.040097951889038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barre' limit 1
loadtime:0.040160894393921 / seconds
Query Executed:select id FROM `vt` where city='Barre' && SIC_code='5651'DB:business_master_new
loadtime:0.0417799949646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barton' limit 1
loadtime:0.041871070861816 / seconds
Query Executed:select id FROM `vt` where city='Barton' && SIC_code='5651'DB:business_master_new
loadtime:0.043889999389648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beebe Plain' limit 1
loadtime:0.043951988220215 / seconds
Query Executed:select id FROM `vt` where city='Beebe Plain' && SIC_code='5651'DB:business_master_new
loadtime:0.044435024261475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beecher Falls' limit 1
loadtime:0.044496059417725 / seconds
Query Executed:select id FROM `vt` where city='Beecher Falls' && SIC_code='5651'DB:business_master_new
loadtime:0.045051097869873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellows Falls' limit 1
loadtime:0.045111894607544 / seconds
Query Executed:select id FROM `vt` where city='Bellows Falls' && SIC_code='5651'DB:business_master_new
loadtime:0.046674013137817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.0467529296875 / seconds
Query Executed:select id FROM `vt` where city='Belmont' && SIC_code='5651'DB:business_master_new
loadtime:0.047408103942871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvidere Center' limit 1
loadtime:0.047471046447754 / seconds
Query Executed:select id FROM `vt` where city='Belvidere Center' && SIC_code='5651'DB:business_master_new
loadtime:0.047934055328369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennington' limit 1
loadtime:0.047995090484619 / seconds
Query Executed:select id FROM `vt` where city='Bennington' && SIC_code='5651'DB:business_master_new
loadtime:0.049539089202881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benson' limit 1
loadtime:0.04961895942688 / seconds
Query Executed:select id FROM `vt` where city='Benson' && SIC_code='5651'DB:business_master_new
loadtime:0.050211906433105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.050276041030884 / seconds
Query Executed:select id FROM `vt` where city='Berlin' && SIC_code='5651'DB:business_master_new
loadtime:0.05088996887207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethel' limit 1
loadtime:0.05095100402832 / seconds
Query Executed:select id FROM `vt` where city='Bethel' && SIC_code='5651'DB:business_master_new
loadtime:0.05306601524353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton Valley' limit 1
loadtime:0.05314302444458 / seconds
Query Executed:select id FROM `vt` where city='Bolton Valley' && SIC_code='5651'DB:business_master_new
loadtime:0.053611993789673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bomoseen' limit 1
loadtime:0.053673982620239 / seconds
Query Executed:select id FROM `vt` where city='Bomoseen' && SIC_code='5651'DB:business_master_new
loadtime:0.054965019226074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bondville' limit 1
loadtime:0.055027961730957 / seconds
Query Executed:select id FROM `vt` where city='Bondville' && SIC_code='5651'DB:business_master_new
loadtime:0.056304931640625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.056366920471191 / seconds
Query Executed:select id FROM `vt` where city='Bradford' && SIC_code='5651'DB:business_master_new
loadtime:0.059134006500244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.059195995330811 / seconds
Query Executed:select id FROM `vt` where city='Brandon' && SIC_code='5651'DB:business_master_new
loadtime:0.060755014419556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brattleboro' limit 1
loadtime:0.060817003250122 / seconds
Query Executed:select id FROM `vt` where city='Brattleboro' && SIC_code='5651'DB:business_master_new
loadtime:0.0623939037323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.062475919723511 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater' && SIC_code='5651'DB:business_master_new
loadtime:0.063605070114136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater Corners' limit 1
loadtime:0.063668966293335 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater Corners' && SIC_code='5651'DB:business_master_new
loadtime:0.064481019973755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater Cors' limit 1
loadtime:0.064542055130005 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater Cors' && SIC_code='5651'DB:business_master_new
loadtime:0.06496000289917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridport' limit 1
loadtime:0.06502103805542 / seconds
Query Executed:select id FROM `vt` where city='Bridport' && SIC_code='5651'DB:business_master_new
loadtime:0.066389083862305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.066451072692871 / seconds
Query Executed:select id FROM `vt` where city='Bristol' && SIC_code='5651'DB:business_master_new
loadtime:0.068026065826416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.068088054656982 / seconds
Query Executed:select id FROM `vt` where city='Brookfield' && SIC_code='5651'DB:business_master_new
loadtime:0.069155931472778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline' limit 1
loadtime:0.069216966629028 / seconds
Query Executed:select id FROM `vt` where city='Brookline' && SIC_code='5651'DB:business_master_new
loadtime:0.06964898109436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownsville' limit 1
loadtime:0.069714069366455 / seconds
Query Executed:select id FROM `vt` where city='Brownsville' && SIC_code='5651'DB:business_master_new
loadtime:0.070811033248901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.070883989334106 / seconds
Query Executed:select id FROM `vt` where city='Burlington' && SIC_code='5651'DB:business_master_new
loadtime:0.072437047958374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cabot' limit 1
loadtime:0.072534084320068 / seconds
Query Executed:select id FROM `vt` where city='Cabot' && SIC_code='5651'DB:business_master_new
loadtime:0.073645114898682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calais' limit 1
loadtime:0.073714017868042 / seconds
Query Executed:select id FROM `vt` where city='Calais' && SIC_code='5651'DB:business_master_new
loadtime:0.07433009147644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:0.074390888214111 / seconds
Query Executed:select id FROM `vt` where city='Cambridge' && SIC_code='5651'DB:business_master_new
loadtime:0.075949907302856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridgeport' limit 1
loadtime:0.076011896133423 / seconds
Query Executed:select id FROM `vt` where city='Cambridgeport' && SIC_code='5651'DB:business_master_new
loadtime:0.076529026031494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canaan' limit 1
loadtime:0.076591014862061 / seconds
Query Executed:select id FROM `vt` where city='Canaan' && SIC_code='5651'DB:business_master_new
loadtime:0.077467918395996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castleton' limit 1
loadtime:0.077529907226562 / seconds
Query Executed:select id FROM `vt` where city='Castleton' && SIC_code='5651'DB:business_master_new
loadtime:0.079642057418823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cavendish' limit 1
loadtime:0.079709053039551 / seconds
Query Executed:select id FROM `vt` where city='Cavendish' && SIC_code='5651'DB:business_master_new
loadtime:0.08084511756897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Rutland' limit 1
loadtime:0.080918073654175 / seconds
Query Executed:select id FROM `vt` where city='Center Rutland' && SIC_code='5651'DB:business_master_new
loadtime:0.082009077072144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte' limit 1
loadtime:0.082072019577026 / seconds
Query Executed:select id FROM `vt` where city='Charlotte' && SIC_code='5651'DB:business_master_new
loadtime:0.08463191986084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.084701061248779 / seconds
Query Executed:select id FROM `vt` where city='Chelsea' && SIC_code='5651'DB:business_master_new
loadtime:0.086421012878418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.086483001708984 / seconds
Query Executed:select id FROM `vt` where city='Chester' && SIC_code='5651'DB:business_master_new
loadtime:0.088066101074219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chittenden' limit 1
loadtime:0.088143110275269 / seconds
Query Executed:select id FROM `vt` where city='Chittenden' && SIC_code='5651'DB:business_master_new
loadtime:0.088943004608154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colchester' limit 1
loadtime:0.089004993438721 / seconds
Query Executed:select id FROM `vt` where city='Colchester' && SIC_code='5651'DB:business_master_new
loadtime:0.090574026107788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.090636014938354 / seconds
Query Executed:select id FROM `vt` where city='Concord' && SIC_code='5651'DB:business_master_new
loadtime:0.09180212020874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corinth' limit 1
loadtime:0.091876029968262 / seconds
Query Executed:select id FROM `vt` where city='Corinth' && SIC_code='5651'DB:business_master_new
loadtime:0.092596054077148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coventry' limit 1
loadtime:0.092655897140503 / seconds
Query Executed:select id FROM `vt` where city='Coventry' && SIC_code='5651'DB:business_master_new
loadtime:0.09322190284729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury' limit 1
loadtime:0.093283891677856 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury' && SIC_code='5651'DB:business_master_new
loadtime:0.094069957733154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury Cmn' limit 1
loadtime:0.094130992889404 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury Cmn' && SIC_code='5651'DB:business_master_new
loadtime:0.094561100006104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury Common' limit 1
loadtime:0.094624042510986 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury Common' && SIC_code='5651'DB:business_master_new
loadtime:0.095348119735718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuttingsville' limit 1
loadtime:0.095408916473389 / seconds
Query Executed:select id FROM `vt` where city='Cuttingsville' && SIC_code='5651'DB:business_master_new
loadtime:0.096681118011475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danby' limit 1
loadtime:0.096746921539307 / seconds
Query Executed:select id FROM `vt` where city='Danby' && SIC_code='5651'DB:business_master_new
loadtime:0.098189115524292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.098251104354858 / seconds
Query Executed:select id FROM `vt` where city='Danville' && SIC_code='5651'DB:business_master_new
loadtime:0.1000349521637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby' limit 1
loadtime:0.10009789466858 / seconds
Query Executed:select id FROM `vt` where city='Derby' && SIC_code='5651'DB:business_master_new
loadtime:0.10238599777222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby Line' limit 1
loadtime:0.1024489402771 / seconds
Query Executed:select id FROM `vt` where city='Derby Line' && SIC_code='5651'DB:business_master_new
loadtime:0.10382103919983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorset' limit 1
loadtime:0.10389399528503 / seconds
Query Executed:select id FROM `vt` where city='Dorset' && SIC_code='5651'DB:business_master_new
loadtime:0.10590696334839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dummerston' limit 1
loadtime:0.10596990585327 / seconds
Query Executed:select id FROM `vt` where city='Dummerston' && SIC_code='5651'DB:business_master_new
loadtime:0.10637903213501 / seconds
Query loaded from cache:select * from geodata_geocity where city='E St Johnsbury' limit 1
loadtime:0.10644102096558 / seconds
Query Executed:select id FROM `vt` where city='E St Johnsbury' && SIC_code='5651'DB:business_master_new
loadtime:0.10685896873474 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Arlington' limit 1
loadtime:0.10692000389099 / seconds
Query Executed:select id FROM `vt` where city='East Arlington' && SIC_code='5651'DB:business_master_new
loadtime:0.10758304595947 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Barre' limit 1
loadtime:0.10764408111572 / seconds
Query Executed:select id FROM `vt` where city='East Barre' && SIC_code='5651'DB:business_master_new
loadtime:0.10868191719055 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Berkshire' limit 1
loadtime:0.1087589263916 / seconds
Query Executed:select id FROM `vt` where city='East Berkshire' && SIC_code='5651'DB:business_master_new
loadtime:0.10931801795959 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Burke' limit 1
loadtime:0.10938000679016 / seconds
Query Executed:select id FROM `vt` where city='East Burke' && SIC_code='5651'DB:business_master_new
loadtime:0.1104519367218 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Calais' limit 1
loadtime:0.11051392555237 / seconds
Query Executed:select id FROM `vt` where city='East Calais' && SIC_code='5651'DB:business_master_new
loadtime:0.11116600036621 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Charleston' limit 1
loadtime:0.11122703552246 / seconds
Query Executed:select id FROM `vt` where city='East Charleston' && SIC_code='5651'DB:business_master_new
loadtime:0.11173295974731 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Corinth' limit 1
loadtime:0.11179304122925 / seconds
Query Executed:select id FROM `vt` where city='East Corinth' && SIC_code='5651'DB:business_master_new
loadtime:0.11248588562012 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dorset' limit 1
loadtime:0.11254692077637 / seconds
Query Executed:select id FROM `vt` where city='East Dorset' && SIC_code='5651'DB:business_master_new
loadtime:0.11360692977905 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dover' limit 1
loadtime:0.11368703842163 / seconds
Query Executed:select id FROM `vt` where city='East Dover' && SIC_code='5651'DB:business_master_new
loadtime:0.11439108848572 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dummerston' limit 1
loadtime:0.11445307731628 / seconds
Query Executed:select id FROM `vt` where city='East Dummerston' && SIC_code='5651'DB:business_master_new
loadtime:0.11484503746033 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Fairfield' limit 1
loadtime:0.1149160861969 / seconds
Query Executed:select id FROM `vt` where city='East Fairfield' && SIC_code='5651'DB:business_master_new
loadtime:0.11558294296265 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hardwick' limit 1
loadtime:0.11564493179321 / seconds
Query Executed:select id FROM `vt` where city='East Hardwick' && SIC_code='5651'DB:business_master_new
loadtime:0.1166250705719 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Haven' limit 1
loadtime:0.11669206619263 / seconds
Query Executed:select id FROM `vt` where city='East Haven' && SIC_code='5651'DB:business_master_new
loadtime:0.11721301078796 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Middlebury' limit 1
loadtime:0.11727499961853 / seconds
Query Executed:select id FROM `vt` where city='East Middlebury' && SIC_code='5651'DB:business_master_new
loadtime:0.11803197860718 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Montpelier' limit 1
loadtime:0.11809396743774 / seconds
Query Executed:select id FROM `vt` where city='East Montpelier' && SIC_code='5651'DB:business_master_new
loadtime:0.11985898017883 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Orange' limit 1
loadtime:0.1199209690094 / seconds
Query Executed:select id FROM `vt` where city='East Orange' && SIC_code='5651'DB:business_master_new
loadtime:0.12033605575562 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Poultney' limit 1
loadtime:0.12039804458618 / seconds
Query Executed:select id FROM `vt` where city='East Poultney' && SIC_code='5651'DB:business_master_new
loadtime:0.1208860874176 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Randolph' limit 1
loadtime:0.12094807624817 / seconds
Query Executed:select id FROM `vt` where city='East Randolph' && SIC_code='5651'DB:business_master_new
loadtime:0.12146806716919 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Ryegate' limit 1
loadtime:0.12152910232544 / seconds
Query Executed:select id FROM `vt` where city='East Ryegate' && SIC_code='5651'DB:business_master_new
loadtime:0.1221809387207 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Saint Johnsbury' limit 1
loadtime:0.12224197387695 / seconds
Query Executed:select id FROM `vt` where city='East Saint Johnsbury' && SIC_code='5651'DB:business_master_new
loadtime:0.1227490901947 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Thetford' limit 1
loadtime:0.12280988693237 / seconds
Query Executed:select id FROM `vt` where city='East Thetford' && SIC_code='5651'DB:business_master_new
loadtime:0.1239230632782 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Wallingford' limit 1
loadtime:0.12398600578308 / seconds
Query Executed:select id FROM `vt` where city='East Wallingford' && SIC_code='5651'DB:business_master_new
loadtime:0.12455701828003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.12461805343628 / seconds
Query Executed:select id FROM `vt` where city='Eden' && SIC_code='5651'DB:business_master_new
loadtime:0.12525701522827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden Mills' limit 1
loadtime:0.12531900405884 / seconds
Query Executed:select id FROM `vt` where city='Eden Mills' && SIC_code='5651'DB:business_master_new
loadtime:0.1258339881897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enosburg Falls' limit 1
loadtime:0.1259069442749 / seconds
Query Executed:select id FROM `vt` where city='Enosburg Falls' && SIC_code='5651'DB:business_master_new
loadtime:0.12748193740845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.12754392623901 / seconds
Query Executed:select id FROM `vt` where city='Essex' && SIC_code='5651'DB:business_master_new
loadtime:0.12869191169739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex Junction' limit 1
loadtime:0.12875604629517 / seconds
Query Executed:select id FROM `vt` where city='Essex Junction' && SIC_code='5651'DB:business_master_new
loadtime:0.13031601905823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Haven' limit 1
loadtime:0.13039803504944 / seconds
Query Executed:select id FROM `vt` where city='Fair Haven' && SIC_code='5651'DB:business_master_new
loadtime:0.13199090957642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.13206911087036 / seconds
Query Executed:select id FROM `vt` where city='Fairfax' && SIC_code='5651'DB:business_master_new
loadtime:0.13426089286804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.13432502746582 / seconds
Query Executed:select id FROM `vt` where city='Fairfield' && SIC_code='5651'DB:business_master_new
loadtime:0.13544893264771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairlee' limit 1
loadtime:0.13551211357117 / seconds
Query Executed:select id FROM `vt` where city='Fairlee' && SIC_code='5651'DB:business_master_new
loadtime:0.13737010955811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferrisburg' limit 1
loadtime:0.13743305206299 / seconds
Query Executed:select id FROM `vt` where city='Ferrisburg' && SIC_code='5651'DB:business_master_new
loadtime:0.1378800868988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.13794112205505 / seconds
Query Executed:select id FROM `vt` where city='Florence' && SIC_code='5651'DB:business_master_new
loadtime:0.13852906227112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest Dale' limit 1
loadtime:0.13859105110168 / seconds
Query Executed:select id FROM `vt` where city='Forest Dale' && SIC_code='5651'DB:business_master_new
loadtime:0.13907909393311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.13913989067078 / seconds
Query Executed:select id FROM `vt` where city='Franklin' && SIC_code='5651'DB:business_master_new
loadtime:0.14030289649963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaysville' limit 1
loadtime:0.1403648853302 / seconds
Query Executed:select id FROM `vt` where city='Gaysville' && SIC_code='5651'DB:business_master_new
loadtime:0.14088296890259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:0.14094400405884 / seconds
Query Executed:select id FROM `vt` where city='Gilman' && SIC_code='5651'DB:business_master_new
loadtime:0.14143896102905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glover' limit 1
loadtime:0.1414999961853 / seconds
Query Executed:select id FROM `vt` where city='Glover' && SIC_code='5651'DB:business_master_new
loadtime:0.14224290847778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.14230489730835 / seconds
Query Executed:select id FROM `vt` where city='Grafton' && SIC_code='5651'DB:business_master_new
loadtime:0.14348912239075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:0.14355111122131 / seconds
Query Executed:select id FROM `vt` where city='Granby' && SIC_code='5651'DB:business_master_new
loadtime:0.14400410652161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Isle' limit 1
loadtime:0.14406609535217 / seconds
Query Executed:select id FROM `vt` where city='Grand Isle' && SIC_code='5651'DB:business_master_new
loadtime:0.14553308486938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graniteville' limit 1
loadtime:0.14559698104858 / seconds
Query Executed:select id FROM `vt` where city='Graniteville' && SIC_code='5651'DB:business_master_new
loadtime:0.14636898040771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granville' limit 1
loadtime:0.1464319229126 / seconds
Query Executed:select id FROM `vt` where city='Granville' && SIC_code='5651'DB:business_master_new
loadtime:0.14701104164124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greensboro' limit 1
loadtime:0.14707207679749 / seconds
Query Executed:select id FROM `vt` where city='Greensboro' && SIC_code='5651'DB:business_master_new
loadtime:0.14781498908997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greensboro Bend' limit 1
loadtime:0.14788699150085 / seconds
Query Executed:select id FROM `vt` where city='Greensboro Bend' && SIC_code='5651'DB:business_master_new
loadtime:0.14846897125244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.14853000640869 / seconds
Query Executed:select id FROM `vt` where city='Groton' && SIC_code='5651'DB:business_master_new
loadtime:0.14972901344299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guildhall' limit 1
loadtime:0.14979290962219 / seconds
Query Executed:select id FROM `vt` where city='Guildhall' && SIC_code='5651'DB:business_master_new
loadtime:0.150554895401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guilford' limit 1
loadtime:0.15061712265015 / seconds
Query Executed:select id FROM `vt` where city='Guilford' && SIC_code='5651'DB:business_master_new
loadtime:0.15101599693298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:0.15107703208923 / seconds
Query Executed:select id FROM `vt` where city='Hancock' && SIC_code='5651'DB:business_master_new
loadtime:0.15176010131836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardwick' limit 1
loadtime:0.15182209014893 / seconds
Query Executed:select id FROM `vt` where city='Hardwick' && SIC_code='5651'DB:business_master_new
loadtime:0.15420508384705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.15428304672241 / seconds
Query Executed:select id FROM `vt` where city='Hartford' && SIC_code='5651'DB:business_master_new
loadtime:0.15558290481567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland' limit 1
loadtime:0.15564703941345 / seconds
Query Executed:select id FROM `vt` where city='Hartland' && SIC_code='5651'DB:business_master_new
loadtime:0.15739607810974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland 4 Cors' limit 1
loadtime:0.15745806694031 / seconds
Query Executed:select id FROM `vt` where city='Hartland 4 Cors' && SIC_code='5651'DB:business_master_new
loadtime:0.15788102149963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland Four Corners' limit 1
loadtime:0.1579430103302 / seconds
Query Executed:select id FROM `vt` where city='Hartland Four Corners' && SIC_code='5651'DB:business_master_new
loadtime:0.15842604637146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highgate Center' limit 1
loadtime:0.15848708152771 / seconds
Query Executed:select id FROM `vt` where city='Highgate Center' && SIC_code='5651'DB:business_master_new
loadtime:0.15986394882202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highgate Springs' limit 1
loadtime:0.1599280834198 / seconds
Query Executed:select id FROM `vt` where city='Highgate Springs' && SIC_code='5651'DB:business_master_new
loadtime:0.16056489944458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinesburg' limit 1
loadtime:0.16062593460083 / seconds
Query Executed:select id FROM `vt` where city='Hinesburg' && SIC_code='5651'DB:business_master_new
loadtime:0.16220092773438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington' limit 1
loadtime:0.16226410865784 / seconds
Query Executed:select id FROM `vt` where city='Huntington' && SIC_code='5651'DB:business_master_new
loadtime:0.16365909576416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyde Park' limit 1
loadtime:0.16372799873352 / seconds
Query Executed:select id FROM `vt` where city='Hyde Park' && SIC_code='5651'DB:business_master_new
loadtime:0.1656219959259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hydeville' limit 1
loadtime:0.165687084198 / seconds
Query Executed:select id FROM `vt` where city='Hydeville' && SIC_code='5651'DB:business_master_new
loadtime:0.16632008552551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irasburg' limit 1
loadtime:0.16638112068176 / seconds
Query Executed:select id FROM `vt` where city='Irasburg' && SIC_code='5651'DB:business_master_new
loadtime:0.16759705543518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Island Pond' limit 1
loadtime:0.16765904426575 / seconds
Query Executed:select id FROM `vt` where city='Island Pond' && SIC_code='5651'DB:business_master_new
loadtime:0.16927909851074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isle La Motte' limit 1
loadtime:0.16934204101562 / seconds
Query Executed:select id FROM `vt` where city='Isle La Motte' && SIC_code='5651'DB:business_master_new
loadtime:0.17002606391907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jacksonville' limit 1
loadtime:0.17008805274963 / seconds
Query Executed:select id FROM `vt` where city='Jacksonville' && SIC_code='5651'DB:business_master_new
loadtime:0.17126393318176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica' limit 1
loadtime:0.17132711410522 / seconds
Query Executed:select id FROM `vt` where city='Jamaica' && SIC_code='5651'DB:business_master_new
loadtime:0.17249894142151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jay' limit 1
loadtime:0.17256212234497 / seconds
Query Executed:select id FROM `vt` where city='Jay' && SIC_code='5651'DB:business_master_new
loadtime:0.17299890518188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jeffersonville' limit 1
loadtime:0.17305994033813 / seconds
Query Executed:select id FROM `vt` where city='Jeffersonville' && SIC_code='5651'DB:business_master_new
loadtime:0.17500710487366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jericho' limit 1
loadtime:0.17508506774902 / seconds
Query Executed:select id FROM `vt` where city='Jericho' && SIC_code='5651'DB:business_master_new
loadtime:0.17664694786072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jericho Center' limit 1
loadtime:0.17671489715576 / seconds
Query Executed:select id FROM `vt` where city='Jericho Center' && SIC_code='5651'DB:business_master_new
loadtime:0.17713809013367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnson' limit 1
loadtime:0.17719888687134 / seconds
Query Executed:select id FROM `vt` where city='Johnson' && SIC_code='5651'DB:business_master_new
loadtime:0.17942810058594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:0.17950701713562 / seconds
Query Executed:select id FROM `vt` where city='Jonesville' && SIC_code='5651'DB:business_master_new
loadtime:0.18002104759216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Killington' limit 1
loadtime:0.18008399009705 / seconds
Query Executed:select id FROM `vt` where city='Killington' && SIC_code='5651'DB:business_master_new
loadtime:0.18163895606995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Elmore' limit 1
loadtime:0.18170595169067 / seconds
Query Executed:select id FROM `vt` where city='Lake Elmore' && SIC_code='5651'DB:business_master_new
loadtime:0.18232798576355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemington' limit 1
loadtime:0.1823890209198 / seconds
Query Executed:select id FROM `vt` where city='Lemington' && SIC_code='5651'DB:business_master_new
loadtime:0.18286204338074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.18292307853699 / seconds
Query Executed:select id FROM `vt` where city='Lincoln' && SIC_code='5651'DB:business_master_new
loadtime:0.18335795402527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Londonderry' limit 1
loadtime:0.18341898918152 / seconds
Query Executed:select id FROM `vt` where city='Londonderry' && SIC_code='5651'DB:business_master_new
loadtime:0.18500804901123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:0.18508505821228 / seconds
Query Executed:select id FROM `vt` where city='Lowell' && SIC_code='5651'DB:business_master_new
loadtime:0.18584108352661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lower Waterford' limit 1
loadtime:0.18591499328613 / seconds
Query Executed:select id FROM `vt` where city='Lower Waterford' && SIC_code='5651'DB:business_master_new
loadtime:0.18649196624756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:0.18655395507812 / seconds
Query Executed:select id FROM `vt` where city='Ludlow' && SIC_code='5651'DB:business_master_new
loadtime:0.18812894821167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:0.1882050037384 / seconds
Query Executed:select id FROM `vt` where city='Lunenburg' && SIC_code='5651'DB:business_master_new
loadtime:0.18923807144165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndon' limit 1
loadtime:0.1893150806427 / seconds
Query Executed:select id FROM `vt` where city='Lyndon' && SIC_code='5651'DB:business_master_new
loadtime:0.19039797782898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndon Center' limit 1
loadtime:0.19046092033386 / seconds
Query Executed:select id FROM `vt` where city='Lyndon Center' && SIC_code='5651'DB:business_master_new
loadtime:0.19110798835754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndonville' limit 1
loadtime:0.19116997718811 / seconds
Query Executed:select id FROM `vt` where city='Lyndonville' && SIC_code='5651'DB:business_master_new
loadtime:0.19275188446045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.19282793998718 / seconds
Query Executed:select id FROM `vt` where city='Manchester' && SIC_code='5651'DB:business_master_new
loadtime:0.19537997245789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester Center' limit 1
loadtime:0.1954619884491 / seconds
Query Executed:select id FROM `vt` where city='Manchester Center' && SIC_code='5651'DB:business_master_new
loadtime:0.19705605506897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester Ctr' limit 1
loadtime:0.19714999198914 / seconds
Query Executed:select id FROM `vt` where city='Manchester Ctr' && SIC_code='5651'DB:business_master_new
loadtime:0.19758605957031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlboro' limit 1
loadtime:0.19765090942383 / seconds
Query Executed:select id FROM `vt` where city='Marlboro' && SIC_code='5651'DB:business_master_new
loadtime:0.19865298271179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield' limit 1
loadtime:0.19871997833252 / seconds
Query Executed:select id FROM `vt` where city='Marshfield' && SIC_code='5651'DB:business_master_new
loadtime:0.20006799697876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Indoe Falls' limit 1
loadtime:0.20012998580933 / seconds
Query Executed:select id FROM `vt` where city='Mc Indoe Falls' && SIC_code='5651'DB:business_master_new
loadtime:0.20065498352051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebury' limit 1
loadtime:0.20072102546692 / seconds
Query Executed:select id FROM `vt` where city='Middlebury' && SIC_code='5651'DB:business_master_new
loadtime:0.20229911804199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown Spgs' limit 1
loadtime:0.20238494873047 / seconds
Query Executed:select id FROM `vt` where city='Middletown Spgs' && SIC_code='5651'DB:business_master_new
loadtime:0.20283102989197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown Springs' limit 1
loadtime:0.20290589332581 / seconds
Query Executed:select id FROM `vt` where city='Middletown Springs' && SIC_code='5651'DB:business_master_new
loadtime:0.20403409004211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:0.20409607887268 / seconds
Query Executed:select id FROM `vt` where city='Milton' && SIC_code='5651'DB:business_master_new
loadtime:0.20566701889038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monkton' limit 1
loadtime:0.20573496818542 / seconds
Query Executed:select id FROM `vt` where city='Monkton' && SIC_code='5651'DB:business_master_new
loadtime:0.20647501945496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery' limit 1
loadtime:0.20653510093689 / seconds
Query Executed:select id FROM `vt` where city='Montgomery' && SIC_code='5651'DB:business_master_new
loadtime:0.20713806152344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery Center' limit 1
loadtime:0.207200050354 / seconds
Query Executed:select id FROM `vt` where city='Montgomery Center' && SIC_code='5651'DB:business_master_new
loadtime:0.20825409889221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery Ctr' limit 1
loadtime:0.20831704139709 / seconds
Query Executed:select id FROM `vt` where city='Montgomery Ctr' && SIC_code='5651'DB:business_master_new
loadtime:0.20879006385803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:0.2088611125946 / seconds
Query Executed:select id FROM `vt` where city='Montpelier' && SIC_code='5651'DB:business_master_new
loadtime:0.21043801307678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moretown' limit 1
loadtime:0.21051812171936 / seconds
Query Executed:select id FROM `vt` where city='Moretown' && SIC_code='5651'DB:business_master_new
loadtime:0.21209502220154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morgan' limit 1
loadtime:0.21215891838074 / seconds
Query Executed:select id FROM `vt` where city='Morgan' && SIC_code='5651'DB:business_master_new
loadtime:0.21278595924377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisville' limit 1
loadtime:0.21285796165466 / seconds
Query Executed:select id FROM `vt` where city='Morrisville' && SIC_code='5651'DB:business_master_new
loadtime:0.21443200111389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moscow' limit 1
loadtime:0.21450710296631 / seconds
Query Executed:select id FROM `vt` where city='Moscow' && SIC_code='5651'DB:business_master_new
loadtime:0.21505999565125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Holly' limit 1
loadtime:0.21512389183044 / seconds
Query Executed:select id FROM `vt` where city='Mount Holly' && SIC_code='5651'DB:business_master_new
loadtime:0.21588397026062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Holly' limit 1
loadtime:0.21594500541687 / seconds
Query Executed:select id FROM `vt` where city='Mt Holly' && SIC_code='5651'DB:business_master_new
loadtime:0.21637392044067 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Springfield' limit 1
loadtime:0.21643495559692 / seconds
Query Executed:select id FROM `vt` where city='N Springfield' && SIC_code='5651'DB:business_master_new
loadtime:0.21698403358459 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Haven' limit 1
loadtime:0.21704602241516 / seconds
Query Executed:select id FROM `vt` where city='New Haven' && SIC_code='5651'DB:business_master_new
loadtime:0.21883606910706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbury' limit 1
loadtime:0.21890902519226 / seconds
Query Executed:select id FROM `vt` where city='Newbury' && SIC_code='5651'DB:business_master_new
loadtime:0.21967792510986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newfane' limit 1
loadtime:0.21974301338196 / seconds
Query Executed:select id FROM `vt` where city='Newfane' && SIC_code='5651'DB:business_master_new
loadtime:0.22137188911438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:0.22143507003784 / seconds
Query Executed:select id FROM `vt` where city='Newport' && SIC_code='5651'DB:business_master_new
loadtime:0.22299790382385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport Center' limit 1
loadtime:0.22307705879211 / seconds
Query Executed:select id FROM `vt` where city='Newport Center' && SIC_code='5651'DB:business_master_new
loadtime:0.22415804862976 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Bennington' limit 1
loadtime:0.22422194480896 / seconds
Query Executed:select id FROM `vt` where city='North Bennington' && SIC_code='5651'DB:business_master_new
loadtime:0.22596502304077 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chittenden' limit 1
loadtime:0.22602701187134 / seconds
Query Executed:select id FROM `vt` where city='North Chittenden' && SIC_code='5651'DB:business_master_new
loadtime:0.22640204429626 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Clarendon' limit 1
loadtime:0.22646307945251 / seconds
Query Executed:select id FROM `vt` where city='North Clarendon' && SIC_code='5651'DB:business_master_new
loadtime:0.22827005386353 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Concord' limit 1
loadtime:0.22833299636841 / seconds
Query Executed:select id FROM `vt` where city='North Concord' && SIC_code='5651'DB:business_master_new
loadtime:0.22886991500854 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Ferrisburg' limit 1
loadtime:0.22893404960632 / seconds
Query Executed:select id FROM `vt` where city='North Ferrisburg' && SIC_code='5651'DB:business_master_new
loadtime:0.22937488555908 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hartland' limit 1
loadtime:0.22943592071533 / seconds
Query Executed:select id FROM `vt` where city='North Hartland' && SIC_code='5651'DB:business_master_new
loadtime:0.23000001907349 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hero' limit 1
loadtime:0.23006200790405 / seconds
Query Executed:select id FROM `vt` where city='North Hero' && SIC_code='5651'DB:business_master_new
loadtime:0.23126602172852 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hyde Park' limit 1
loadtime:0.2313289642334 / seconds
Query Executed:select id FROM `vt` where city='North Hyde Park' && SIC_code='5651'DB:business_master_new
loadtime:0.23188710212708 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Montpelier' limit 1
loadtime:0.23195004463196 / seconds
Query Executed:select id FROM `vt` where city='North Montpelier' && SIC_code='5651'DB:business_master_new
loadtime:0.23242092132568 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pomfret' limit 1
loadtime:0.23248195648193 / seconds
Query Executed:select id FROM `vt` where city='North Pomfret' && SIC_code='5651'DB:business_master_new
loadtime:0.23316788673401 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pownal' limit 1
loadtime:0.23323011398315 / seconds
Query Executed:select id FROM `vt` where city='North Pownal' && SIC_code='5651'DB:business_master_new
loadtime:0.23378992080688 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Springfield' limit 1
loadtime:0.2338650226593 / seconds
Query Executed:select id FROM `vt` where city='North Springfield' && SIC_code='5651'DB:business_master_new
loadtime:0.23520112037659 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Thetford' limit 1
loadtime:0.23526310920715 / seconds
Query Executed:select id FROM `vt` where city='North Thetford' && SIC_code='5651'DB:business_master_new
loadtime:0.23578405380249 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Troy' limit 1
loadtime:0.23585510253906 / seconds
Query Executed:select id FROM `vt` where city='North Troy' && SIC_code='5651'DB:business_master_new
loadtime:0.23723602294922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:0.23729801177979 / seconds
Query Executed:select id FROM `vt` where city='Northfield' && SIC_code='5651'DB:business_master_new
loadtime:0.23887491226196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield Falls' limit 1
loadtime:0.23893690109253 / seconds
Query Executed:select id FROM `vt` where city='Northfield Falls' && SIC_code='5651'DB:business_master_new
loadtime:0.23948907852173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:0.23954892158508 / seconds
Query Executed:select id FROM `vt` where city='Norton' && SIC_code='5651'DB:business_master_new
loadtime:0.24023699760437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwich' limit 1
loadtime:0.24029803276062 / seconds
Query Executed:select id FROM `vt` where city='Norwich' && SIC_code='5651'DB:business_master_new
loadtime:0.24188590049744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:0.24196100234985 / seconds
Query Executed:select id FROM `vt` where city='Orange' && SIC_code='5651'DB:business_master_new
loadtime:0.24245095252991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orleans' limit 1
loadtime:0.24251294136047 / seconds
Query Executed:select id FROM `vt` where city='Orleans' && SIC_code='5651'DB:business_master_new
loadtime:0.24432396888733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orwell' limit 1
loadtime:0.2443859577179 / seconds
Query Executed:select id FROM `vt` where city='Orwell' && SIC_code='5651'DB:business_master_new
loadtime:0.24584197998047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Passumpsic' limit 1
loadtime:0.24591493606567 / seconds
Query Executed:select id FROM `vt` where city='Passumpsic' && SIC_code='5651'DB:business_master_new
loadtime:0.24634504318237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pawlet' limit 1
loadtime:0.24640607833862 / seconds
Query Executed:select id FROM `vt` where city='Pawlet' && SIC_code='5651'DB:business_master_new
loadtime:0.24777603149414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peacham' limit 1
loadtime:0.24783897399902 / seconds
Query Executed:select id FROM `vt` where city='Peacham' && SIC_code='5651'DB:business_master_new
loadtime:0.24852395057678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perkinsville' limit 1
loadtime:0.24858593940735 / seconds
Query Executed:select id FROM `vt` where city='Perkinsville' && SIC_code='5651'DB:business_master_new
loadtime:0.25003290176392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peru' limit 1
loadtime:0.25009608268738 / seconds
Query Executed:select id FROM `vt` where city='Peru' && SIC_code='5651'DB:business_master_new
loadtime:0.25078010559082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsfield' limit 1
loadtime:0.25084209442139 / seconds
Query Executed:select id FROM `vt` where city='Pittsfield' && SIC_code='5651'DB:business_master_new
loadtime:0.25159597396851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsford' limit 1
loadtime:0.25165796279907 / seconds
Query Executed:select id FROM `vt` where city='Pittsford' && SIC_code='5651'DB:business_master_new
loadtime:0.25370097160339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:0.25376391410828 / seconds
Query Executed:select id FROM `vt` where city='Plainfield' && SIC_code='5651'DB:business_master_new
loadtime:0.25550889968872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.25557208061218 / seconds
Query Executed:select id FROM `vt` where city='Plymouth' && SIC_code='5651'DB:business_master_new
loadtime:0.25630497932434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Post Mills' limit 1
loadtime:0.25636601448059 / seconds
Query Executed:select id FROM `vt` where city='Post Mills' && SIC_code='5651'DB:business_master_new
loadtime:0.25695395469666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poultney' limit 1
loadtime:0.25701594352722 / seconds
Query Executed:select id FROM `vt` where city='Poultney' && SIC_code='5651'DB:business_master_new
loadtime:0.25930905342102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pownal' limit 1
loadtime:0.25937104225159 / seconds
Query Executed:select id FROM `vt` where city='Pownal' && SIC_code='5651'DB:business_master_new
loadtime:0.26095199584961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Proctor' limit 1
loadtime:0.26102900505066 / seconds
Query Executed:select id FROM `vt` where city='Proctor' && SIC_code='5651'DB:business_master_new
loadtime:0.26234698295593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Proctorsville' limit 1
loadtime:0.26241111755371 / seconds
Query Executed:select id FROM `vt` where city='Proctorsville' && SIC_code='5651'DB:business_master_new
loadtime:0.26351094245911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Putney' limit 1
loadtime:0.26357388496399 / seconds
Query Executed:select id FROM `vt` where city='Putney' && SIC_code='5651'DB:business_master_new
loadtime:0.26516389846802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quechee' limit 1
loadtime:0.26523995399475 / seconds
Query Executed:select id FROM `vt` where city='Quechee' && SIC_code='5651'DB:business_master_new
loadtime:0.26707196235657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:0.2671480178833 / seconds
Query Executed:select id FROM `vt` where city='Randolph' && SIC_code='5651'DB:business_master_new
loadtime:0.2688000202179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph Center' limit 1
loadtime:0.26887512207031 / seconds
Query Executed:select id FROM `vt` where city='Randolph Center' && SIC_code='5651'DB:business_master_new
loadtime:0.26999092102051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reading' limit 1
loadtime:0.27005410194397 / seconds
Query Executed:select id FROM `vt` where city='Reading' && SIC_code='5651'DB:business_master_new
loadtime:0.27083492279053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readsboro' limit 1
loadtime:0.27090811729431 / seconds
Query Executed:select id FROM `vt` where city='Readsboro' && SIC_code='5651'DB:business_master_new
loadtime:0.27168607711792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richford' limit 1
loadtime:0.27175307273865 / seconds
Query Executed:select id FROM `vt` where city='Richford' && SIC_code='5651'DB:business_master_new
loadtime:0.27351093292236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:0.2735869884491 / seconds
Query Executed:select id FROM `vt` where city='Richmond' && SIC_code='5651'DB:business_master_new
loadtime:0.2751579284668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ripton' limit 1
loadtime:0.27521991729736 / seconds
Query Executed:select id FROM `vt` where city='Ripton' && SIC_code='5651'DB:business_master_new
loadtime:0.27574610710144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:0.27580690383911 / seconds
Query Executed:select id FROM `vt` where city='Rochester' && SIC_code='5651'DB:business_master_new
loadtime:0.27735900878906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:0.27743697166443 / seconds
Query Executed:select id FROM `vt` where city='Roxbury' && SIC_code='5651'DB:business_master_new
loadtime:0.27816700935364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rupert' limit 1
loadtime:0.2782289981842 / seconds
Query Executed:select id FROM `vt` where city='Rupert' && SIC_code='5651'DB:business_master_new
loadtime:0.27881288528442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:0.27888607978821 / seconds
Query Executed:select id FROM `vt` where city='Rutland' && SIC_code='5651'DB:business_master_new
loadtime:0.28048896789551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ryegate' limit 1
loadtime:0.28058195114136 / seconds
Query Executed:select id FROM `vt` where city='Ryegate' && SIC_code='5651'DB:business_master_new
loadtime:0.28108310699463 / seconds
Query loaded from cache:select * from geodata_geocity where city='S Londonderry' limit 1
loadtime:0.28114700317383 / seconds
Query Executed:select id FROM `vt` where city='S Londonderry' && SIC_code='5651'DB:business_master_new
loadtime:0.2817211151123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Albans' limit 1
loadtime:0.28178310394287 / seconds
Query Executed:select id FROM `vt` where city='Saint Albans' && SIC_code='5651'DB:business_master_new
loadtime:0.28336310386658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Albans Bay' limit 1
loadtime:0.28344511985779 / seconds
Query Executed:select id FROM `vt` where city='Saint Albans Bay' && SIC_code='5651'DB:business_master_new
loadtime:0.28406190872192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johnsbury' limit 1
loadtime:0.2841260433197 / seconds
Query Executed:select id FROM `vt` where city='Saint Johnsbury' && SIC_code='5651'DB:business_master_new
loadtime:0.28574204444885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johnsbury Center' limit 1
loadtime:0.2858190536499 / seconds
Query Executed:select id FROM `vt` where city='Saint Johnsbury Center' && SIC_code='5651'DB:business_master_new
loadtime:0.28647089004517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:0.28653407096863 / seconds
Query Executed:select id FROM `vt` where city='Salisbury' && SIC_code='5651'DB:business_master_new
loadtime:0.28773808479309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxtons River' limit 1
loadtime:0.28780007362366 / seconds
Query Executed:select id FROM `vt` where city='Saxtons River' && SIC_code='5651'DB:business_master_new
loadtime:0.28898096084595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaftsbury' limit 1
loadtime:0.28904390335083 / seconds
Query Executed:select id FROM `vt` where city='Shaftsbury' && SIC_code='5651'DB:business_master_new
loadtime:0.29100704193115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.29106903076172 / seconds
Query Executed:select id FROM `vt` where city='Sharon' && SIC_code='5651'DB:business_master_new
loadtime:0.29231095314026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheffield' limit 1
loadtime:0.29237389564514 / seconds
Query Executed:select id FROM `vt` where city='Sheffield' && SIC_code='5651'DB:business_master_new
loadtime:0.29303693771362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelburne' limit 1
loadtime:0.29311203956604 / seconds
Query Executed:select id FROM `vt` where city='Shelburne' && SIC_code='5651'DB:business_master_new
loadtime:0.29468202590942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon' limit 1
loadtime:0.29476189613342 / seconds
Query Executed:select id FROM `vt` where city='Sheldon' && SIC_code='5651'DB:business_master_new
loadtime:0.29589796066284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon Springs' limit 1
loadtime:0.29595994949341 / seconds
Query Executed:select id FROM `vt` where city='Sheldon Springs' && SIC_code='5651'DB:business_master_new
loadtime:0.29654693603516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shoreham' limit 1
loadtime:0.29660892486572 / seconds
Query Executed:select id FROM `vt` where city='Shoreham' && SIC_code='5651'DB:business_master_new
loadtime:0.2980489730835 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Barre' limit 1
loadtime:0.29811191558838 / seconds
Query Executed:select id FROM `vt` where city='South Barre' && SIC_code='5651'DB:business_master_new
loadtime:0.29920697212219 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Burlington' limit 1
loadtime:0.29926896095276 / seconds
Query Executed:select id FROM `vt` where city='South Burlington' && SIC_code='5651'DB:business_master_new
loadtime:0.3008759021759 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hero' limit 1
loadtime:0.30096197128296 / seconds
Query Executed:select id FROM `vt` where city='South Hero' && SIC_code='5651'DB:business_master_new
loadtime:0.30288505554199 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Londonderry' limit 1
loadtime:0.30294895172119 / seconds
Query Executed:select id FROM `vt` where city='South Londonderry' && SIC_code='5651'DB:business_master_new
loadtime:0.30417799949646 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Newfane' limit 1
loadtime:0.30423998832703 / seconds
Query Executed:select id FROM `vt` where city='South Newfane' && SIC_code='5651'DB:business_master_new
loadtime:0.3047730922699 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Pomfret' limit 1
loadtime:0.30483293533325 / seconds
Query Executed:select id FROM `vt` where city='South Pomfret' && SIC_code='5651'DB:business_master_new
loadtime:0.30552291870117 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Royalton' limit 1
loadtime:0.30558490753174 / seconds
Query Executed:select id FROM `vt` where city='South Royalton' && SIC_code='5651'DB:business_master_new
loadtime:0.30765700340271 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Ryegate' limit 1
loadtime:0.30772495269775 / seconds
Query Executed:select id FROM `vt` where city='South Ryegate' && SIC_code='5651'DB:business_master_new
loadtime:0.30840301513672 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Strafford' limit 1
loadtime:0.30846500396729 / seconds
Query Executed:select id FROM `vt` where city='South Strafford' && SIC_code='5651'DB:business_master_new
loadtime:0.30917501449585 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Woodstock' limit 1
loadtime:0.30923509597778 / seconds
Query Executed:select id FROM `vt` where city='South Woodstock' && SIC_code='5651'DB:business_master_new
loadtime:0.30992889404297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.30998992919922 / seconds
Query Executed:select id FROM `vt` where city='Springfield' && SIC_code='5651'DB:business_master_new
loadtime:0.31154799461365 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Albans' limit 1
loadtime:0.31160998344421 / seconds
Query Executed:select id FROM `vt` where city='St Albans' && SIC_code='5651'DB:business_master_new
loadtime:0.31218695640564 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Albans Bay' limit 1
loadtime:0.31224799156189 / seconds
Query Executed:select id FROM `vt` where city='St Albans Bay' && SIC_code='5651'DB:business_master_new
loadtime:0.31277990341187 / seconds
Query loaded from cache:select * from geodata_geocity where city='St George' limit 1
loadtime:0.31284189224243 / seconds
Query Executed:select id FROM `vt` where city='St George' && SIC_code='5651'DB:business_master_new
loadtime:0.3133020401001 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johnsbury' limit 1
loadtime:0.31336402893066 / seconds
Query Executed:select id FROM `vt` where city='St Johnsbury' && SIC_code='5651'DB:business_master_new
loadtime:0.31444096565247 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johnsbury Ctr' limit 1
loadtime:0.31450295448303 / seconds
Query Executed:select id FROM `vt` where city='St Johnsbury Ctr' && SIC_code='5651'DB:business_master_new
loadtime:0.31490111351013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stamford' limit 1
loadtime:0.3149619102478 / seconds
Query Executed:select id FROM `vt` where city='Stamford' && SIC_code='5651'DB:business_master_new
loadtime:0.31562089920044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Starksboro' limit 1
loadtime:0.3156840801239 / seconds
Query Executed:select id FROM `vt` where city='Starksboro' && SIC_code='5651'DB:business_master_new
loadtime:0.31683707237244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockbridge' limit 1
loadtime:0.31691002845764 / seconds
Query Executed:select id FROM `vt` where city='Stockbridge' && SIC_code='5651'DB:business_master_new
loadtime:0.31758689880371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stowe' limit 1
loadtime:0.31764793395996 / seconds
Query Executed:select id FROM `vt` where city='Stowe' && SIC_code='5651'DB:business_master_new
loadtime:0.31921601295471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strafford' limit 1
loadtime:0.31929707527161 / seconds
Query Executed:select id FROM `vt` where city='Strafford' && SIC_code='5651'DB:business_master_new
loadtime:0.31996893882751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutton' limit 1
loadtime:0.32004499435425 / seconds
Query Executed:select id FROM `vt` where city='Sutton' && SIC_code='5651'DB:business_master_new
loadtime:0.32070398330688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swanton' limit 1
loadtime:0.3207700252533 / seconds
Query Executed:select id FROM `vt` where city='Swanton' && SIC_code='5651'DB:business_master_new
loadtime:0.32232403755188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taftsville' limit 1
loadtime:0.32239890098572 / seconds
Query Executed:select id FROM `vt` where city='Taftsville' && SIC_code='5651'DB:business_master_new
loadtime:0.3229649066925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thetford' limit 1
loadtime:0.32302808761597 / seconds
Query Executed:select id FROM `vt` where city='Thetford' && SIC_code='5651'DB:business_master_new
loadtime:0.32401394844055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thetford Center' limit 1
loadtime:0.32407689094543 / seconds
Query Executed:select id FROM `vt` where city='Thetford Center' && SIC_code='5651'DB:business_master_new
loadtime:0.32517099380493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topsham' limit 1
loadtime:0.32523393630981 / seconds
Query Executed:select id FROM `vt` where city='Topsham' && SIC_code='5651'DB:business_master_new
loadtime:0.32572102546692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townshend' limit 1
loadtime:0.32578206062317 / seconds
Query Executed:select id FROM `vt` where city='Townshend' && SIC_code='5651'DB:business_master_new
loadtime:0.32725095748901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:0.32731294631958 / seconds
Query Executed:select id FROM `vt` where city='Troy' && SIC_code='5651'DB:business_master_new
loadtime:0.32804489135742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tunbridge' limit 1
loadtime:0.32810711860657 / seconds
Query Executed:select id FROM `vt` where city='Tunbridge' && SIC_code='5651'DB:business_master_new
loadtime:0.32924604415894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Underhill' limit 1
loadtime:0.3293080329895 / seconds
Query Executed:select id FROM `vt` where city='Underhill' && SIC_code='5651'DB:business_master_new
loadtime:0.33096289634705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Underhill Center' limit 1
loadtime:0.33102607727051 / seconds
Query Executed:select id FROM `vt` where city='Underhill Center' && SIC_code='5651'DB:business_master_new
loadtime:0.33164000511169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vergennes' limit 1
loadtime:0.33170604705811 / seconds
Query Executed:select id FROM `vt` where city='Vergennes' && SIC_code='5651'DB:business_master_new
loadtime:0.33328795433044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:0.33336591720581 / seconds
Query Executed:select id FROM `vt` where city='Vernon' && SIC_code='5651'DB:business_master_new
loadtime:0.3348560333252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vershire' limit 1
loadtime:0.33492112159729 / seconds
Query Executed:select id FROM `vt` where city='Vershire' && SIC_code='5651'DB:business_master_new
loadtime:0.33552598953247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waitsfield' limit 1
loadtime:0.33558797836304 / seconds
Query Executed:select id FROM `vt` where city='Waitsfield' && SIC_code='5651'DB:business_master_new
loadtime:0.33716702461243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallingford' limit 1
loadtime:0.33724188804626 / seconds
Query Executed:select id FROM `vt` where city='Wallingford' && SIC_code='5651'DB:business_master_new
loadtime:0.33923196792603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wardsboro' limit 1
loadtime:0.3392961025238 / seconds
Query Executed:select id FROM `vt` where city='Wardsboro' && SIC_code='5651'DB:business_master_new
loadtime:0.3399829864502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:0.34004402160645 / seconds
Query Executed:select id FROM `vt` where city='Warren' && SIC_code='5651'DB:business_master_new
loadtime:0.34228610992432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.3423490524292 / seconds
Query Executed:select id FROM `vt` where city='Washington' && SIC_code='5651'DB:business_master_new
loadtime:0.34342288970947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury' limit 1
loadtime:0.34348511695862 / seconds
Query Executed:select id FROM `vt` where city='Waterbury' && SIC_code='5651'DB:business_master_new
loadtime:0.34505200386047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury Center' limit 1
loadtime:0.34511494636536 / seconds
Query Executed:select id FROM `vt` where city='Waterbury Center' && SIC_code='5651'DB:business_master_new
loadtime:0.34683895111084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville' limit 1
loadtime:0.34691095352173 / seconds
Query Executed:select id FROM `vt` where city='Waterville' && SIC_code='5651'DB:business_master_new
loadtime:0.3476550579071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Websterville' limit 1
loadtime:0.34772205352783 / seconds
Query Executed:select id FROM `vt` where city='Websterville' && SIC_code='5651'DB:business_master_new
loadtime:0.34831094741821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wells' limit 1
loadtime:0.34837198257446 / seconds
Query Executed:select id FROM `vt` where city='Wells' && SIC_code='5651'DB:business_master_new
loadtime:0.34940004348755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wells River' limit 1
loadtime:0.34946298599243 / seconds
Query Executed:select id FROM `vt` where city='Wells River' && SIC_code='5651'DB:business_master_new
loadtime:0.3506920337677 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Burke' limit 1
loadtime:0.3507559299469 / seconds
Query Executed:select id FROM `vt` where city='West Burke' && SIC_code='5651'DB:business_master_new
loadtime:0.35196805000305 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Charleston' limit 1
loadtime:0.35204792022705 / seconds
Query Executed:select id FROM `vt` where city='West Charleston' && SIC_code='5651'DB:business_master_new
loadtime:0.35268998146057 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Danville' limit 1
loadtime:0.35276794433594 / seconds
Query Executed:select id FROM `vt` where city='West Danville' && SIC_code='5651'DB:business_master_new
loadtime:0.35375308990479 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dover' limit 1
loadtime:0.3538179397583 / seconds
Query Executed:select id FROM `vt` where city='West Dover' && SIC_code='5651'DB:business_master_new
loadtime:0.35612797737122 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dummerston' limit 1
loadtime:0.35620403289795 / seconds
Query Executed:select id FROM `vt` where city='West Dummerston' && SIC_code='5651'DB:business_master_new
loadtime:0.35672402381897 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Fairlee' limit 1
loadtime:0.35678696632385 / seconds
Query Executed:select id FROM `vt` where city='West Fairlee' && SIC_code='5651'DB:business_master_new
loadtime:0.35760402679443 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Glover' limit 1
loadtime:0.35766696929932 / seconds
Query Executed:select id FROM `vt` where city='West Glover' && SIC_code='5651'DB:business_master_new
loadtime:0.35810804367065 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Halifax' limit 1
loadtime:0.35817003250122 / seconds
Query Executed:select id FROM `vt` where city='West Halifax' && SIC_code='5651'DB:business_master_new
loadtime:0.3587589263916 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartford' limit 1
loadtime:0.35882091522217 / seconds
Query Executed:select id FROM `vt` where city='West Hartford' && SIC_code='5651'DB:business_master_new
loadtime:0.35940504074097 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Marlboro' limit 1
loadtime:0.35946607589722 / seconds
Query Executed:select id FROM `vt` where city='West Marlboro' && SIC_code='5651'DB:business_master_new
loadtime:0.35992407798767 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newbury' limit 1
loadtime:0.35998511314392 / seconds
Query Executed:select id FROM `vt` where city='West Newbury' && SIC_code='5651'DB:business_master_new
loadtime:0.36051607131958 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Pawlet' limit 1
loadtime:0.36057806015015 / seconds
Query Executed:select id FROM `vt` where city='West Pawlet' && SIC_code='5651'DB:business_master_new
loadtime:0.36133098602295 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Rupert' limit 1
loadtime:0.36139297485352 / seconds
Query Executed:select id FROM `vt` where city='West Rupert' && SIC_code='5651'DB:business_master_new
loadtime:0.36195397377014 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Rutland' limit 1
loadtime:0.36201405525208 / seconds
Query Executed:select id FROM `vt` where city='West Rutland' && SIC_code='5651'DB:business_master_new
loadtime:0.36414909362793 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Topsham' limit 1
loadtime:0.36421203613281 / seconds
Query Executed:select id FROM `vt` where city='West Topsham' && SIC_code='5651'DB:business_master_new
loadtime:0.36481404304504 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Townshend' limit 1
loadtime:0.36488509178162 / seconds
Query Executed:select id FROM `vt` where city='West Townshend' && SIC_code='5651'DB:business_master_new
loadtime:0.3654899597168 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Wardsboro' limit 1
loadtime:0.36555099487305 / seconds
Query Executed:select id FROM `vt` where city='West Wardsboro' && SIC_code='5651'DB:business_master_new
loadtime:0.36623597145081 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Windsor' limit 1
loadtime:0.36629796028137 / seconds
Query Executed:select id FROM `vt` where city='West Windsor' && SIC_code='5651'DB:business_master_new
loadtime:0.36673498153687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:0.36679792404175 / seconds
Query Executed:select id FROM `vt` where city='Westfield' && SIC_code='5651'DB:business_master_new
loadtime:0.36750197410583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westford' limit 1
loadtime:0.3675639629364 / seconds
Query Executed:select id FROM `vt` where city='Westford' && SIC_code='5651'DB:business_master_new
loadtime:0.36891388893127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:0.36897706985474 / seconds
Query Executed:select id FROM `vt` where city='Westminster' && SIC_code='5651'DB:business_master_new
loadtime:0.37042498588562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster Sta' limit 1
loadtime:0.37048697471619 / seconds
Query Executed:select id FROM `vt` where city='Westminster Sta' && SIC_code='5651'DB:business_master_new
loadtime:0.370934009552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster Station' limit 1
loadtime:0.37099504470825 / seconds
Query Executed:select id FROM `vt` where city='Westminster Station' && SIC_code='5651'DB:business_master_new
loadtime:0.37160706520081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:0.37166810035706 / seconds
Query Executed:select id FROM `vt` where city='Weston' && SIC_code='5651'DB:business_master_new
loadtime:0.37290596961975 / seconds
Query loaded from cache:select * from geodata_geocity where city='White River Jct' limit 1
loadtime:0.37296891212463 / seconds
Query Executed:select id FROM `vt` where city='White River Jct' && SIC_code='5651'DB:business_master_new
loadtime:0.37348294258118 / seconds
Query loaded from cache:select * from geodata_geocity where city='White River Junction' limit 1
loadtime:0.37354397773743 / seconds
Query Executed:select id FROM `vt` where city='White River Junction' && SIC_code='5651'DB:business_master_new
loadtime:0.37514591217041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiting' limit 1
loadtime:0.37522101402283 / seconds
Query Executed:select id FROM `vt` where city='Whiting' && SIC_code='5651'DB:business_master_new
loadtime:0.37596392631531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitingham' limit 1
loadtime:0.37602591514587 / seconds
Query Executed:select id FROM `vt` where city='Whitingham' && SIC_code='5651'DB:business_master_new
loadtime:0.37679100036621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilder' limit 1
loadtime:0.3768630027771 / seconds
Query Executed:select id FROM `vt` where city='Wilder' && SIC_code='5651'DB:business_master_new
loadtime:0.37811708450317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamstown' limit 1
loadtime:0.37818002700806 / seconds
Query Executed:select id FROM `vt` where city='Williamstown' && SIC_code='5651'DB:business_master_new
loadtime:0.38006711006165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsville' limit 1
loadtime:0.38013005256653 / seconds
Query Executed:select id FROM `vt` where city='Williamsville' && SIC_code='5651'DB:business_master_new
loadtime:0.38083696365356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williston' limit 1
loadtime:0.38090896606445 / seconds
Query Executed:select id FROM `vt` where city='Williston' && SIC_code='5651'DB:business_master_new
loadtime:0.38248205184937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmington' limit 1
loadtime:0.38256096839905 / seconds
Query Executed:select id FROM `vt` where city='Wilmington' && SIC_code='5651'DB:business_master_new
loadtime:0.38414597511292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:0.3842248916626 / seconds
Query Executed:select id FROM `vt` where city='Windsor' && SIC_code='5651'DB:business_master_new
loadtime:0.38579797744751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winooski' limit 1
loadtime:0.38588690757751 / seconds
Query Executed:select id FROM `vt` where city='Winooski' && SIC_code='5651'DB:business_master_new
loadtime:0.38746309280396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolcott' limit 1
loadtime:0.38754200935364 / seconds
Query Executed:select id FROM `vt` where city='Wolcott' && SIC_code='5651'DB:business_master_new
loadtime:0.38886308670044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbury' limit 1
loadtime:0.38892698287964 / seconds
Query Executed:select id FROM `vt` where city='Woodbury' && SIC_code='5651'DB:business_master_new
loadtime:0.38952898979187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:0.38959002494812 / seconds
Query Executed:select id FROM `vt` where city='Woodstock' && SIC_code='5651'DB:business_master_new
loadtime:0.39117288589478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worcester' limit 1
loadtime:0.39125108718872 / seconds
Query Executed:select id FROM `vt` where city='Worcester' && SIC_code='5651'DB:business_master_new
loadtime:0.39201903343201 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.39217090606689 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.39256691932678 / seconds
Operation template executed (chunk cache operation)
loadtime:0.39273810386658 / seconds
template override:Default
loadtime:0.3927800655365 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:0.39402103424072 / seconds
Template Constructed, Array Rows:49
loadtime:0.39454102516174 / seconds
TOTAL EXECUTION TIME: 0.39411
loadtime:0.39580011367798 / 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] => family-clothing-stores [stateURLid] => vermont )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:0.39581108093262
TOTAL KEY ARRAYS: 69