Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:5.5074691772461E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00049805641174316 / seconds
host not found setting manual db connection
loadtime:0.00089597702026367 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0011470317840576 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0012831687927246 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0013291835784912 / seconds
zipcode:
loadtime:0.001345157623291 / seconds
Query Executed:select * from search_referrer where page_hash='ce86a9c472d184597a9dc53351f07b7a' limit 10 DB:ezrox_toadli
loadtime:0.0015189647674561 / seconds
Operation header executed (non global)
loadtime:0.0015361309051514 / seconds
Operation leaderboard executed (non global)
loadtime:0.0015640258789062 / seconds
Operation square executed (non global)
loadtime:0.0015780925750732 / seconds
Operation square_bottom executed (non global)
loadtime:0.0015909671783447 / seconds
Operation smallsquare executed (non global)
loadtime:0.0016021728515625 / seconds
Operation headeradright executed (non global)
loadtime:0.0016131401062012 / seconds
Operation google_analytics executed (non global)
loadtime:0.0016250610351562 / seconds
Operation topstories executed (non global)
loadtime:0.0016360282897949 / seconds
Operation businessnearyou executed (non global)
loadtime:0.00164794921875 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0016579627990723 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018770694732666 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0020251274108887 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0020589828491211 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0021181106567383 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0021531581878662 / seconds
Template key: archive_menu pushed
loadtime:0.0021581649780273 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0021650791168213 / seconds
Template key: get_gravatar pushed
loadtime:0.0021681785583496 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0021719932556152 / seconds
*10)-10)+1 | start:0
loadtime:0.0021929740905762 / seconds
Query loaded from cache:select * from categories where cat_URLid='real-estate-agents-and-managers'
loadtime:0.0022261142730713 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='colorado'
loadtime:0.0022671222686768 / seconds
DB connected to localhost business_master_new
loadtime:0.0026180744171143 / seconds
Query Executed:select * from `co_catmap` where sic='6531' order by city ascDB:business_master_new
loadtime:0.070054054260254 / seconds
Query stored in cache : _QUERY_www.toadli.com57bf868af51086b5fb5f2bb6f3c074f0
loadtime:0.07079815864563 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='colorado'
loadtime:0.07083797454834 / seconds
Query Executed:select sum(totalcount) as totalsum from `co_catmap` where sic='6531'DB:business_master_new
loadtime:0.075754165649414 / seconds
Query stored in cache : _QUERY_www.toadli.coma76fc5478d1458f9052689442234fd5a
loadtime:0.075780153274536 / seconds
438 / 11
loadtime:0.07581615447998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agate' limit 1
loadtime:0.07590913772583 / seconds
Query Executed:select id FROM `co` where city='Agate' && SIC_code='6531'DB:business_master_new
loadtime:0.11798596382141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aguilar' limit 1
loadtime:0.11802697181702 / seconds
Query Executed:select id FROM `co` where city='Aguilar' && SIC_code='6531'DB:business_master_new
loadtime:0.13198399543762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Akron' limit 1
loadtime:0.13204312324524 / seconds
Query Executed:select id FROM `co` where city='Akron' && SIC_code='6531'DB:business_master_new
loadtime:0.21168303489685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alamosa' limit 1
loadtime:0.21174597740173 / seconds
Query Executed:select id FROM `co` where city='Alamosa' && SIC_code='6531'DB:business_master_new
loadtime:0.2224760055542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allenspark' limit 1
loadtime:0.22253608703613 / seconds
Query Executed:select id FROM `co` where city='Allenspark' && SIC_code='6531'DB:business_master_new
loadtime:0.23915815353394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alma' limit 1
loadtime:0.23920011520386 / seconds
Query Executed:select id FROM `co` where city='Alma' && SIC_code='6531'DB:business_master_new
loadtime:0.2541401386261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Almont' limit 1
loadtime:0.25418615341187 / seconds
Query Executed:select id FROM `co` where city='Almont' && SIC_code='6531'DB:business_master_new
loadtime:0.26195096969604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.26199817657471 / seconds
Query Executed:select id FROM `co` where city='Amherst' && SIC_code='6531'DB:business_master_new
loadtime:0.26993918418884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anton' limit 1
loadtime:0.2699670791626 / seconds
Query Executed:select id FROM `co` where city='Anton' && SIC_code='6531'DB:business_master_new
loadtime:0.27952313423157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Antonito' limit 1
loadtime:0.27957201004028 / seconds
Query Executed:select id FROM `co` where city='Antonito' && SIC_code='6531'DB:business_master_new
loadtime:0.31464910507202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arapahoe' limit 1
loadtime:0.31470608711243 / seconds
Query Executed:select id FROM `co` where city='Arapahoe' && SIC_code='6531'DB:business_master_new
loadtime:0.32112216949463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arboles' limit 1
loadtime:0.32118201255798 / seconds
Query Executed:select id FROM `co` where city='Arboles' && SIC_code='6531'DB:business_master_new
loadtime:0.33332109451294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.33337903022766 / seconds
Query Executed:select id FROM `co` where city='Arlington' && SIC_code='6531'DB:business_master_new
loadtime:0.33430600166321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arriba' limit 1
loadtime:0.33434915542603 / seconds
Query Executed:select id FROM `co` where city='Arriba' && SIC_code='6531'DB:business_master_new
loadtime:0.34788417816162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arvada' limit 1
loadtime:0.34794211387634 / seconds
Query Executed:select id FROM `co` where city='Arvada' && SIC_code='6531'DB:business_master_new
loadtime:0.39614009857178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aspen' limit 1
loadtime:0.39651012420654 / seconds
Query Executed:select id FROM `co` where city='Aspen' && SIC_code='6531'DB:business_master_new
loadtime:0.45310711860657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atwood' limit 1
loadtime:0.45328402519226 / seconds
Query Executed:select id FROM `co` where city='Atwood' && SIC_code='6531'DB:business_master_new
loadtime:0.46573400497437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ault' limit 1
loadtime:0.4657781124115 / seconds
Query Executed:select id FROM `co` where city='Ault' && SIC_code='6531'DB:business_master_new
loadtime:0.50929498672485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.50935316085815 / seconds
Query Executed:select id FROM `co` where city='Aurora' && SIC_code='6531'DB:business_master_new
loadtime:0.62173509597778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Austin' limit 1
loadtime:0.62204003334045 / seconds
Query Executed:select id FROM `co` where city='Austin' && SIC_code='6531'DB:business_master_new
loadtime:0.64398217201233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.64405107498169 / seconds
Query Executed:select id FROM `co` where city='Avon' && SIC_code='6531'DB:business_master_new
loadtime:0.66623210906982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avondale' limit 1
loadtime:0.66637396812439 / seconds
Query Executed:select id FROM `co` where city='Avondale' && SIC_code='6531'DB:business_master_new
loadtime:0.69290018081665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bailey' limit 1
loadtime:0.69295597076416 / seconds
Query Executed:select id FROM `co` where city='Bailey' && SIC_code='6531'DB:business_master_new
loadtime:0.70193600654602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Basalt' limit 1
loadtime:0.70199108123779 / seconds
Query Executed:select id FROM `co` where city='Basalt' && SIC_code='6531'DB:business_master_new
loadtime:0.71676898002625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Battlement Mesa' limit 1
loadtime:0.71684098243713 / seconds
Query Executed:select id FROM `co` where city='Battlement Mesa' && SIC_code='6531'DB:business_master_new
loadtime:0.72363209724426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayfield' limit 1
loadtime:0.72368907928467 / seconds
Query Executed:select id FROM `co` where city='Bayfield' && SIC_code='6531'DB:business_master_new
loadtime:0.73509907722473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedrock' limit 1
loadtime:0.73515009880066 / seconds
Query Executed:select id FROM `co` where city='Bedrock' && SIC_code='6531'DB:business_master_new
loadtime:0.7377781867981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellvue' limit 1
loadtime:0.73791313171387 / seconds
Query Executed:select id FROM `co` where city='Bellvue' && SIC_code='6531'DB:business_master_new
loadtime:0.77997398376465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennett' limit 1
loadtime:0.78003096580505 / seconds
Query Executed:select id FROM `co` where city='Bennett' && SIC_code='6531'DB:business_master_new
loadtime:0.8850359916687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berthoud' limit 1
loadtime:0.88509297370911 / seconds
Query Executed:select id FROM `co` where city='Berthoud' && SIC_code='6531'DB:business_master_new
loadtime:0.89640116691589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethune' limit 1
loadtime:0.89658403396606 / seconds
Query Executed:select id FROM `co` where city='Bethune' && SIC_code='6531'DB:business_master_new
loadtime:0.90811705589294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beulah' limit 1
loadtime:0.90830707550049 / seconds
Query Executed:select id FROM `co` where city='Beulah' && SIC_code='6531'DB:business_master_new
loadtime:0.93278908729553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Hawk' limit 1
loadtime:0.9328351020813 / seconds
Query Executed:select id FROM `co` where city='Black Hawk' && SIC_code='6531'DB:business_master_new
loadtime:0.96658897399902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanca' limit 1
loadtime:0.96675515174866 / seconds
Query Executed:select id FROM `co` where city='Blanca' && SIC_code='6531'DB:business_master_new
loadtime:0.99015402793884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boncarbo' limit 1
loadtime:0.9902970790863 / seconds
Query Executed:select id FROM `co` where city='Boncarbo' && SIC_code='6531'DB:business_master_new
loadtime:0.99426698684692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bond' limit 1
loadtime:0.99430203437805 / seconds
Query Executed:select id FROM `co` where city='Bond' && SIC_code='6531'DB:business_master_new
loadtime:1.0014729499817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boone' limit 1
loadtime:1.0015270709991 / seconds
Query Executed:select id FROM `co` where city='Boone' && SIC_code='6531'DB:business_master_new
loadtime:1.0180389881134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boulder' limit 1
loadtime:1.018089056015 / seconds
Query Executed:select id FROM `co` where city='Boulder' && SIC_code='6531'DB:business_master_new
loadtime:1.1467411518097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:1.1470911502838 / seconds
Query Executed:select id FROM `co` where city='Brandon' && SIC_code='6531'DB:business_master_new
loadtime:1.1479320526123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branson' limit 1
loadtime:1.1479861736298 / seconds
Query Executed:select id FROM `co` where city='Branson' && SIC_code='6531'DB:business_master_new
loadtime:1.1504020690918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Breckenridge' limit 1
loadtime:1.1504511833191 / seconds
Query Executed:select id FROM `co` where city='Breckenridge' && SIC_code='6531'DB:business_master_new
loadtime:1.1875720024109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Briggsdale' limit 1
loadtime:1.1876940727234 / seconds
Query Executed:select id FROM `co` where city='Briggsdale' && SIC_code='6531'DB:business_master_new
loadtime:1.2031760215759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:1.203232049942 / seconds
Query Executed:select id FROM `co` where city='Brighton' && SIC_code='6531'DB:business_master_new
loadtime:1.2238700389862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:1.2239460945129 / seconds
Query Executed:select id FROM `co` where city='Bristol' && SIC_code='6531'DB:business_master_new
loadtime:1.2249209880829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broomfield' limit 1
loadtime:1.2249729633331 / seconds
Query Executed:select id FROM `co` where city='Broomfield' && SIC_code='6531'DB:business_master_new
loadtime:1.2760369777679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brush' limit 1
loadtime:1.2761490345001 / seconds
Query Executed:select id FROM `co` where city='Brush' && SIC_code='6531'DB:business_master_new
loadtime:1.2844331264496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buena Vista' limit 1
loadtime:1.2845010757446 / seconds
Query Executed:select id FROM `co` where city='Buena Vista' && SIC_code='6531'DB:business_master_new
loadtime:1.2951290607452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Creek' limit 1
loadtime:1.295184135437 / seconds
Query Executed:select id FROM `co` where city='Buffalo Creek' && SIC_code='6531'DB:business_master_new
loadtime:1.2992930412292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:1.2993791103363 / seconds
Query Executed:select id FROM `co` where city='Burlington' && SIC_code='6531'DB:business_master_new
loadtime:1.3067569732666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burns' limit 1
loadtime:1.3069140911102 / seconds
Query Executed:select id FROM `co` where city='Burns' && SIC_code='6531'DB:business_master_new
loadtime:1.309396982193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byers' limit 1
loadtime:1.3094460964203 / seconds
Query Executed:select id FROM `co` where city='Byers' && SIC_code='6531'DB:business_master_new
loadtime:1.3743669986725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cahone' limit 1
loadtime:1.3744471073151 / seconds
Query Executed:select id FROM `co` where city='Cahone' && SIC_code='6531'DB:business_master_new
loadtime:1.3824610710144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calhan' limit 1
loadtime:1.3825771808624 / seconds
Query Executed:select id FROM `co` where city='Calhan' && SIC_code='6531'DB:business_master_new
loadtime:1.3875660896301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Campo' limit 1
loadtime:1.3877060413361 / seconds
Query Executed:select id FROM `co` where city='Campo' && SIC_code='6531'DB:business_master_new
loadtime:1.3992581367493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canon City' limit 1
loadtime:1.3993010520935 / seconds
Query Executed:select id FROM `co` where city='Canon City' && SIC_code='6531'DB:business_master_new
loadtime:1.4229400157928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capulin' limit 1
loadtime:1.4230260848999 / seconds
Query Executed:select id FROM `co` where city='Capulin' && SIC_code='6531'DB:business_master_new
loadtime:1.4256160259247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carbondale' limit 1
loadtime:1.4256529808044 / seconds
Query Executed:select id FROM `co` where city='Carbondale' && SIC_code='6531'DB:business_master_new
loadtime:1.4395871162415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carr' limit 1
loadtime:1.439679145813 / seconds
Query Executed:select id FROM `co` where city='Carr' && SIC_code='6531'DB:business_master_new
loadtime:1.4457311630249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascade' limit 1
loadtime:1.4457821846008 / seconds
Query Executed:select id FROM `co` where city='Cascade' && SIC_code='6531'DB:business_master_new
loadtime:1.4752111434937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castle Rock' limit 1
loadtime:1.4752731323242 / seconds
Query Executed:select id FROM `co` where city='Castle Rock' && SIC_code='6531'DB:business_master_new
loadtime:1.5141260623932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedaredge' limit 1
loadtime:1.5143570899963 / seconds
Query Executed:select id FROM `co` where city='Cedaredge' && SIC_code='6531'DB:business_master_new
loadtime:1.5210430622101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centennial' limit 1
loadtime:1.521115064621 / seconds
Query Executed:select id FROM `co` where city='Centennial' && SIC_code='6531'DB:business_master_new
loadtime:1.5383529663086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center' limit 1
loadtime:1.5384030342102 / seconds
Query Executed:select id FROM `co` where city='Center' && SIC_code='6531'DB:business_master_new
loadtime:1.607381105423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central City' limit 1
loadtime:1.6074471473694 / seconds
Query Executed:select id FROM `co` where city='Central City' && SIC_code='6531'DB:business_master_new
loadtime:1.6263461112976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chama' limit 1
loadtime:1.6264021396637 / seconds
Query Executed:select id FROM `co` where city='Chama' && SIC_code='6531'DB:business_master_new
loadtime:1.6276590824127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheraw' limit 1
loadtime:1.6277101039886 / seconds
Query Executed:select id FROM `co` where city='Cheraw' && SIC_code='6531'DB:business_master_new
loadtime:1.6317381858826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Hills Vlg' limit 1
loadtime:1.6317789554596 / seconds
Query Executed:select id FROM `co` where city='Cherry Hills Vlg' && SIC_code='6531'DB:business_master_new
loadtime:1.6326801776886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheyenne Wells' limit 1
loadtime:1.6327230930328 / seconds
Query Executed:select id FROM `co` where city='Cheyenne Wells' && SIC_code='6531'DB:business_master_new
loadtime:1.6813480854034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chimney Rock' limit 1
loadtime:1.6813960075378 / seconds
Query Executed:select id FROM `co` where city='Chimney Rock' && SIC_code='6531'DB:business_master_new
loadtime:1.6832311153412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chromo' limit 1
loadtime:1.6833050251007 / seconds
Query Executed:select id FROM `co` where city='Chromo' && SIC_code='6531'DB:business_master_new
loadtime:1.6880421638489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cimarron' limit 1
loadtime:1.6880979537964 / seconds
Query Executed:select id FROM `co` where city='Cimarron' && SIC_code='6531'DB:business_master_new
loadtime:1.6929161548615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clark' limit 1
loadtime:1.6929790973663 / seconds
Query Executed:select id FROM `co` where city='Clark' && SIC_code='6531'DB:business_master_new
loadtime:1.7009360790253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:1.7009949684143 / seconds
Query Executed:select id FROM `co` where city='Clifton' && SIC_code='6531'DB:business_master_new
loadtime:1.7061460018158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Climax' limit 1
loadtime:1.7062151432037 / seconds
Query Executed:select id FROM `co` where city='Climax' && SIC_code='6531'DB:business_master_new
loadtime:1.7065670490265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coal Creek' limit 1
loadtime:1.7066040039062 / seconds
Query Executed:select id FROM `co` where city='Coal Creek' && SIC_code='6531'DB:business_master_new
loadtime:1.7078120708466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coaldale' limit 1
loadtime:1.7078611850739 / seconds
Query Executed:select id FROM `co` where city='Coaldale' && SIC_code='6531'DB:business_master_new
loadtime:1.7117481231689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coalmont' limit 1
loadtime:1.7118079662323 / seconds
Query Executed:select id FROM `co` where city='Coalmont' && SIC_code='6531'DB:business_master_new
loadtime:1.7141351699829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collbran' limit 1
loadtime:1.7141761779785 / seconds
Query Executed:select id FROM `co` where city='Collbran' && SIC_code='6531'DB:business_master_new
loadtime:1.736114025116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colorado City' limit 1
loadtime:1.7361760139465 / seconds
Query Executed:select id FROM `co` where city='Colorado City' && SIC_code='6531'DB:business_master_new
loadtime:1.7624440193176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colorado Springs' limit 1
loadtime:1.7624971866608 / seconds
Query Executed:select id FROM `co` where city='Colorado Springs' && SIC_code='6531'DB:business_master_new
loadtime:2.5886790752411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbine Valley' limit 1
loadtime:2.589329957962 / seconds
Query Executed:select id FROM `co` where city='Columbine Valley' && SIC_code='6531'DB:business_master_new
loadtime:2.591737985611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Commerce City' limit 1
loadtime:2.5917999744415 / seconds
Query Executed:select id FROM `co` where city='Commerce City' && SIC_code='6531'DB:business_master_new
loadtime:2.5956189632416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Como' limit 1
loadtime:2.5956830978394 / seconds
Query Executed:select id FROM `co` where city='Como' && SIC_code='6531'DB:business_master_new
loadtime:2.5960941314697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conejos' limit 1
loadtime:2.5961329936981 / seconds
Query Executed:select id FROM `co` where city='Conejos' && SIC_code='6531'DB:business_master_new
loadtime:2.5966551303864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conifer' limit 1
loadtime:2.5966880321503 / seconds
Query Executed:select id FROM `co` where city='Conifer' && SIC_code='6531'DB:business_master_new
loadtime:2.6001169681549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cope' limit 1
loadtime:2.6001880168915 / seconds
Query Executed:select id FROM `co` where city='Cope' && SIC_code='6531'DB:business_master_new
loadtime:2.601487159729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copper Mountain' limit 1
loadtime:2.6015241146088 / seconds
Query Executed:select id FROM `co` where city='Copper Mountain' && SIC_code='6531'DB:business_master_new
loadtime:2.6018900871277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cortez' limit 1
loadtime:2.6019389629364 / seconds
Query Executed:select id FROM `co` where city='Cortez' && SIC_code='6531'DB:business_master_new
loadtime:2.6056611537933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cory' limit 1
loadtime:2.605731010437 / seconds
Query Executed:select id FROM `co` where city='Cory' && SIC_code='6531'DB:business_master_new
loadtime:2.6070721149445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cotopaxi' limit 1
loadtime:2.6071140766144 / seconds
Query Executed:select id FROM `co` where city='Cotopaxi' && SIC_code='6531'DB:business_master_new
loadtime:2.6128189563751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cowdrey' limit 1
loadtime:2.6128780841827 / seconds
Query Executed:select id FROM `co` where city='Cowdrey' && SIC_code='6531'DB:business_master_new
loadtime:2.6133000850677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cpu Louis Guzzo Ent' limit 1
loadtime:2.6133301258087 / seconds
Query Executed:select id FROM `co` where city='Cpu Louis Guzzo Ent' && SIC_code='6531'DB:business_master_new
loadtime:2.6136481761932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craig' limit 1
loadtime:2.6136901378632 / seconds
Query Executed:select id FROM `co` where city='Craig' && SIC_code='6531'DB:business_master_new
loadtime:2.617192029953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crawford' limit 1
loadtime:2.6172680854797 / seconds
Query Executed:select id FROM `co` where city='Crawford' && SIC_code='6531'DB:business_master_new
loadtime:2.6219301223755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creede' limit 1
loadtime:2.6219899654388 / seconds
Query Executed:select id FROM `co` where city='Creede' && SIC_code='6531'DB:business_master_new
loadtime:2.6251001358032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crested Butte' limit 1
loadtime:2.6251621246338 / seconds
Query Executed:select id FROM `co` where city='Crested Butte' && SIC_code='6531'DB:business_master_new
loadtime:2.6292340755463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crestone' limit 1
loadtime:2.6293179988861 / seconds
Query Executed:select id FROM `co` where city='Crestone' && SIC_code='6531'DB:business_master_new
loadtime:2.6317911148071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cripple Creek' limit 1
loadtime:2.631854057312 / seconds
Query Executed:select id FROM `co` where city='Cripple Creek' && SIC_code='6531'DB:business_master_new
loadtime:2.6348960399628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crook' limit 1
loadtime:2.6349430084229 / seconds
Query Executed:select id FROM `co` where city='Crook' && SIC_code='6531'DB:business_master_new
loadtime:2.6358561515808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crowley' limit 1
loadtime:2.6359050273895 / seconds
Query Executed:select id FROM `co` where city='Crowley' && SIC_code='6531'DB:business_master_new
loadtime:2.6363489627838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dacono' limit 1
loadtime:2.6363861560822 / seconds
Query Executed:select id FROM `co` where city='Dacono' && SIC_code='6531'DB:business_master_new
loadtime:2.6397480964661 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Beque' limit 1
loadtime:2.6397969722748 / seconds
Query Executed:select id FROM `co` where city='De Beque' && SIC_code='6531'DB:business_master_new
loadtime:2.6407420635223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deckers' limit 1
loadtime:2.6407949924469 / seconds
Query Executed:select id FROM `co` where city='Deckers' && SIC_code='6531'DB:business_master_new
loadtime:2.641175031662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deer Trail' limit 1
loadtime:2.6415240764618 / seconds
Query Executed:select id FROM `co` where city='Deer Trail' && SIC_code='6531'DB:business_master_new
loadtime:2.6432790756226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Del Norte' limit 1
loadtime:2.6433219909668 / seconds
Query Executed:select id FROM `co` where city='Del Norte' && SIC_code='6531'DB:business_master_new
loadtime:2.6495590209961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delta' limit 1
loadtime:2.6496241092682 / seconds
Query Executed:select id FROM `co` where city='Delta' && SIC_code='6531'DB:business_master_new
loadtime:2.6534600257874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denver' limit 1
loadtime:2.6535310745239 / seconds
Query Executed:select id FROM `co` where city='Denver' && SIC_code='6531'DB:business_master_new
loadtime:2.7293560504913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dillon' limit 1
loadtime:2.7314901351929 / seconds
Query Executed:select id FROM `co` where city='Dillon' && SIC_code='6531'DB:business_master_new
loadtime:2.7357110977173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dinosaur' limit 1
loadtime:2.7359170913696 / seconds
Query Executed:select id FROM `co` where city='Dinosaur' && SIC_code='6531'DB:business_master_new
loadtime:2.7382180690765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Divide' limit 1
loadtime:2.7382819652557 / seconds
Query Executed:select id FROM `co` where city='Divide' && SIC_code='6531'DB:business_master_new
loadtime:2.7435760498047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolores' limit 1
loadtime:2.7436590194702 / seconds
Query Executed:select id FROM `co` where city='Dolores' && SIC_code='6531'DB:business_master_new
loadtime:2.7483460903168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dove Creek' limit 1
loadtime:2.748437166214 / seconds
Query Executed:select id FROM `co` where city='Dove Creek' && SIC_code='6531'DB:business_master_new
loadtime:2.7505331039429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drake' limit 1
loadtime:2.7505760192871 / seconds
Query Executed:select id FROM `co` where city='Drake' && SIC_code='6531'DB:business_master_new
loadtime:2.7514531612396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dumont' limit 1
loadtime:2.7515280246735 / seconds
Query Executed:select id FROM `co` where city='Dumont' && SIC_code='6531'DB:business_master_new
loadtime:2.7523350715637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dupont' limit 1
loadtime:2.75239610672 / seconds
Query Executed:select id FROM `co` where city='Dupont' && SIC_code='6531'DB:business_master_new
loadtime:2.7528491020203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durango' limit 1
loadtime:2.7528901100159 / seconds
Query Executed:select id FROM `co` where city='Durango' && SIC_code='6531'DB:business_master_new
loadtime:2.7591481208801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eads' limit 1
loadtime:2.7592940330505 / seconds
Query Executed:select id FROM `co` where city='Eads' && SIC_code='6531'DB:business_master_new
loadtime:2.7637360095978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle' limit 1
loadtime:2.7638170719147 / seconds
Query Executed:select id FROM `co` where city='Eagle' && SIC_code='6531'DB:business_master_new
loadtime:2.7677040100098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastlake' limit 1
loadtime:2.7677719593048 / seconds
Query Executed:select id FROM `co` where city='Eastlake' && SIC_code='6531'DB:business_master_new
loadtime:2.7687790393829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eaton' limit 1
loadtime:2.7688319683075 / seconds
Query Executed:select id FROM `co` where city='Eaton' && SIC_code='6531'DB:business_master_new
loadtime:2.7719831466675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eckert' limit 1
loadtime:2.772066116333 / seconds
Query Executed:select id FROM `co` where city='Eckert' && SIC_code='6531'DB:business_master_new
loadtime:2.774080991745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eckley' limit 1
loadtime:2.774129152298 / seconds
Query Executed:select id FROM `co` where city='Eckley' && SIC_code='6531'DB:business_master_new
loadtime:2.7746360301971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewater' limit 1
loadtime:2.7746810913086 / seconds
Query Executed:select id FROM `co` where city='Edgewater' && SIC_code='6531'DB:business_master_new
loadtime:2.775269985199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edwards' limit 1
loadtime:2.775318145752 / seconds
Query Executed:select id FROM `co` where city='Edwards' && SIC_code='6531'DB:business_master_new
loadtime:2.7819480895996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Egnar' limit 1
loadtime:2.782035112381 / seconds
Query Executed:select id FROM `co` where city='Egnar' && SIC_code='6531'DB:business_master_new
loadtime:2.7827541828156 / seconds
Query loaded from cache:select * from geodata_geocity where city='El Jebel' limit 1
loadtime:2.7827999591827 / seconds
Query Executed:select id FROM `co` where city='El Jebel' && SIC_code='6531'DB:business_master_new
loadtime:2.7837159633636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elbert' limit 1
loadtime:2.7837619781494 / seconds
Query Executed:select id FROM `co` where city='Elbert' && SIC_code='6531'DB:business_master_new
loadtime:2.7878620624542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldorado Springs' limit 1
loadtime:2.7879230976105 / seconds
Query Executed:select id FROM `co` where city='Eldorado Springs' && SIC_code='6531'DB:business_master_new
loadtime:2.7884061336517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elizabeth' limit 1
loadtime:2.7884471416473 / seconds
Query Executed:select id FROM `co` where city='Elizabeth' && SIC_code='6531'DB:business_master_new
loadtime:2.7932200431824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Empire' limit 1
loadtime:2.7933161258698 / seconds
Query Executed:select id FROM `co` where city='Empire' && SIC_code='6531'DB:business_master_new
loadtime:2.794340133667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Englewood' limit 1
loadtime:2.7943921089172 / seconds
Query Executed:select id FROM `co` where city='Englewood' && SIC_code='6531'DB:business_master_new
loadtime:2.8104660511017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erie' limit 1
loadtime:2.8111271858215 / seconds
Query Executed:select id FROM `co` where city='Erie' && SIC_code='6531'DB:business_master_new
loadtime:2.8144981861115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estes Park' limit 1
loadtime:2.8145961761475 / seconds
Query Executed:select id FROM `co` where city='Estes Park' && SIC_code='6531'DB:business_master_new
loadtime:2.8185031414032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evans' limit 1
loadtime:2.8186030387878 / seconds
Query Executed:select id FROM `co` where city='Evans' && SIC_code='6531'DB:business_master_new
loadtime:2.8217630386353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evergreen' limit 1
loadtime:2.8218109607697 / seconds
Query Executed:select id FROM `co` where city='Evergreen' && SIC_code='6531'DB:business_master_new
loadtime:2.826434135437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairplay' limit 1
loadtime:2.8265290260315 / seconds
Query Executed:select id FROM `co` where city='Fairplay' && SIC_code='6531'DB:business_master_new
loadtime:2.8308990001678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Federal Heights' limit 1
loadtime:2.8309571743011 / seconds
Query Executed:select id FROM `co` where city='Federal Heights' && SIC_code='6531'DB:business_master_new
loadtime:2.8314311504364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Firestone' limit 1
loadtime:2.831472158432 / seconds
Query Executed:select id FROM `co` where city='Firestone' && SIC_code='6531'DB:business_master_new
loadtime:2.8324301242828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flagler' limit 1
loadtime:2.8324830532074 / seconds
Query Executed:select id FROM `co` where city='Flagler' && SIC_code='6531'DB:business_master_new
loadtime:2.833899974823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fleming' limit 1
loadtime:2.8339581489563 / seconds
Query Executed:select id FROM `co` where city='Fleming' && SIC_code='6531'DB:business_master_new
loadtime:2.8352150917053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:2.8352811336517 / seconds
Query Executed:select id FROM `co` where city='Florence' && SIC_code='6531'DB:business_master_new
loadtime:2.8384840488434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florissant' limit 1
loadtime:2.838546037674 / seconds
Query Executed:select id FROM `co` where city='Florissant' && SIC_code='6531'DB:business_master_new
loadtime:2.842679977417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Carson' limit 1
loadtime:2.8427350521088 / seconds
Query Executed:select id FROM `co` where city='Fort Carson' && SIC_code='6531'DB:business_master_new
loadtime:2.8439700603485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Collins' limit 1
loadtime:2.8440201282501 / seconds
Query Executed:select id FROM `co` where city='Fort Collins' && SIC_code='6531'DB:business_master_new
loadtime:2.8540050983429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Garland' limit 1
loadtime:2.8542239665985 / seconds
Query Executed:select id FROM `co` where city='Fort Garland' && SIC_code='6531'DB:business_master_new
loadtime:2.8551070690155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Lupton' limit 1
loadtime:2.8551750183105 / seconds
Query Executed:select id FROM `co` where city='Fort Lupton' && SIC_code='6531'DB:business_master_new
loadtime:2.8589611053467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Lyon' limit 1
loadtime:2.8590221405029 / seconds
Query Executed:select id FROM `co` where city='Fort Lyon' && SIC_code='6531'DB:business_master_new
loadtime:2.859375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Morgan' limit 1
loadtime:2.8594040870667 / seconds
Query Executed:select id FROM `co` where city='Fort Morgan' && SIC_code='6531'DB:business_master_new
loadtime:2.8630411624908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain' limit 1
loadtime:2.8631150722504 / seconds
Query Executed:select id FROM `co` where city='Fountain' && SIC_code='6531'DB:business_master_new
loadtime:2.8663551807404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fowler' limit 1
loadtime:2.8664040565491 / seconds
Query Executed:select id FROM `co` where city='Fowler' && SIC_code='6531'DB:business_master_new
loadtime:2.868870973587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franktown' limit 1
loadtime:2.8689291477203 / seconds
Query Executed:select id FROM `co` where city='Franktown' && SIC_code='6531'DB:business_master_new
loadtime:2.8721239566803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fraser' limit 1
loadtime:2.8721830844879 / seconds
Query Executed:select id FROM `co` where city='Fraser' && SIC_code='6531'DB:business_master_new
loadtime:2.8755030632019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frederick' limit 1
loadtime:2.875568151474 / seconds
Query Executed:select id FROM `co` where city='Frederick' && SIC_code='6531'DB:business_master_new
loadtime:2.8792731761932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frisco' limit 1
loadtime:2.8793289661407 / seconds
Query Executed:select id FROM `co` where city='Frisco' && SIC_code='6531'DB:business_master_new
loadtime:2.8830301761627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruita' limit 1
loadtime:2.8831090927124 / seconds
Query Executed:select id FROM `co` where city='Fruita' && SIC_code='6531'DB:business_master_new
loadtime:2.886360168457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galeton' limit 1
loadtime:2.8864099979401 / seconds
Query Executed:select id FROM `co` where city='Galeton' && SIC_code='6531'DB:business_master_new
loadtime:2.8873560428619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garcia' limit 1
loadtime:2.8874080181122 / seconds
Query Executed:select id FROM `co` where city='Garcia' && SIC_code='6531'DB:business_master_new
loadtime:2.8878030776978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gardner' limit 1
loadtime:2.8878500461578 / seconds
Query Executed:select id FROM `co` where city='Gardner' && SIC_code='6531'DB:business_master_new
loadtime:2.8884110450745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gateway' limit 1
loadtime:2.8884420394897 / seconds
Query Executed:select id FROM `co` where city='Gateway' && SIC_code='6531'DB:business_master_new
loadtime:2.8888690471649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Genoa' limit 1
loadtime:2.8889150619507 / seconds
Query Executed:select id FROM `co` where city='Genoa' && SIC_code='6531'DB:business_master_new
loadtime:2.8895411491394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:2.8895931243896 / seconds
Query Executed:select id FROM `co` where city='Georgetown' && SIC_code='6531'DB:business_master_new
loadtime:2.8912801742554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilcrest' limit 1
loadtime:2.8913381099701 / seconds
Query Executed:select id FROM `co` where city='Gilcrest' && SIC_code='6531'DB:business_master_new
loadtime:2.8924541473389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gill' limit 1
loadtime:2.8924911022186 / seconds
Query Executed:select id FROM `co` where city='Gill' && SIC_code='6531'DB:business_master_new
loadtime:2.8934421539307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glade Park' limit 1
loadtime:2.8934919834137 / seconds
Query Executed:select id FROM `co` where city='Glade Park' && SIC_code='6531'DB:business_master_new
loadtime:2.8940010070801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Haven' limit 1
loadtime:2.89404296875 / seconds
Query Executed:select id FROM `co` where city='Glen Haven' && SIC_code='6531'DB:business_master_new
loadtime:2.8945500850677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood Springs' limit 1
loadtime:2.8946089744568 / seconds
Query Executed:select id FROM `co` where city='Glenwood Springs' && SIC_code='6531'DB:business_master_new
loadtime:2.8988201618195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Golden' limit 1
loadtime:2.8989021778107 / seconds
Query Executed:select id FROM `co` where city='Golden' && SIC_code='6531'DB:business_master_new
loadtime:2.9046189785004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granada' limit 1
loadtime:2.9047341346741 / seconds
Query Executed:select id FROM `co` where city='Granada' && SIC_code='6531'DB:business_master_new
loadtime:2.9054961204529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:2.9055500030518 / seconds
Query Executed:select id FROM `co` where city='Granby' && SIC_code='6531'DB:business_master_new
loadtime:2.9093101024628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Junction' limit 1
loadtime:2.9093790054321 / seconds
Query Executed:select id FROM `co` where city='Grand Junction' && SIC_code='6531'DB:business_master_new
loadtime:2.9170451164246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Lake' limit 1
loadtime:2.9172019958496 / seconds
Query Executed:select id FROM `co` where city='Grand Lake' && SIC_code='6531'DB:business_master_new
loadtime:2.9205350875854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granite' limit 1
loadtime:2.9206140041351 / seconds
Query Executed:select id FROM `co` where city='Granite' && SIC_code='6531'DB:business_master_new
loadtime:2.9209661483765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grant' limit 1
loadtime:2.9210181236267 / seconds
Query Executed:select id FROM `co` where city='Grant' && SIC_code='6531'DB:business_master_new
loadtime:2.9214060306549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greeley' limit 1
loadtime:2.9214470386505 / seconds
Query Executed:select id FROM `co` where city='Greeley' && SIC_code='6531'DB:business_master_new
loadtime:2.9277830123901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Mountain Falls' limit 1
loadtime:2.9279201030731 / seconds
Query Executed:select id FROM `co` where city='Green Mountain Falls' && SIC_code='6531'DB:business_master_new
loadtime:2.929703950882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Mtn Falls' limit 1
loadtime:2.9297590255737 / seconds
Query Executed:select id FROM `co` where city='Green Mtn Falls' && SIC_code='6531'DB:business_master_new
loadtime:2.9301290512085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood Vlg' limit 1
loadtime:2.9301791191101 / seconds
Query Executed:select id FROM `co` where city='Greenwood Vlg' && SIC_code='6531'DB:business_master_new
loadtime:2.9308559894562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grover' limit 1
loadtime:2.9309170246124 / seconds
Query Executed:select id FROM `co` where city='Grover' && SIC_code='6531'DB:business_master_new
loadtime:2.9316811561584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guffey' limit 1
loadtime:2.9317240715027 / seconds
Query Executed:select id FROM `co` where city='Guffey' && SIC_code='6531'DB:business_master_new
loadtime:2.9326300621033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gulnare' limit 1
loadtime:2.932687997818 / seconds
Query Executed:select id FROM `co` where city='Gulnare' && SIC_code='6531'DB:business_master_new
loadtime:2.9332120418549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gunnison' limit 1
loadtime:2.9332621097565 / seconds
Query Executed:select id FROM `co` where city='Gunnison' && SIC_code='6531'DB:business_master_new
loadtime:2.9373281002045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gypsum' limit 1
loadtime:2.937402009964 / seconds
Query Executed:select id FROM `co` where city='Gypsum' && SIC_code='6531'DB:business_master_new
loadtime:2.9406540393829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:2.9407160282135 / seconds
Query Executed:select id FROM `co` where city='Hamilton' && SIC_code='6531'DB:business_master_new
loadtime:2.941174030304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartman' limit 1
loadtime:2.9412100315094 / seconds
Query Executed:select id FROM `co` where city='Hartman' && SIC_code='6531'DB:business_master_new
loadtime:2.9416041374207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartsel' limit 1
loadtime:2.9420931339264 / seconds
Query Executed:select id FROM `co` where city='Hartsel' && SIC_code='6531'DB:business_master_new
loadtime:2.9432580471039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hasty' limit 1
loadtime:2.9433171749115 / seconds
Query Executed:select id FROM `co` where city='Hasty' && SIC_code='6531'DB:business_master_new
loadtime:2.9437561035156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haswell' limit 1
loadtime:2.9437980651855 / seconds
Query Executed:select id FROM `co` where city='Haswell' && SIC_code='6531'DB:business_master_new
loadtime:2.9442629814148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haxtun' limit 1
loadtime:2.9443020820618 / seconds
Query Executed:select id FROM `co` where city='Haxtun' && SIC_code='6531'DB:business_master_new
loadtime:2.9466891288757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayden' limit 1
loadtime:2.9467480182648 / seconds
Query Executed:select id FROM `co` where city='Hayden' && SIC_code='6531'DB:business_master_new
loadtime:2.9495050907135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henderson' limit 1
loadtime:2.9495620727539 / seconds
Query Executed:select id FROM `co` where city='Henderson' && SIC_code='6531'DB:business_master_new
loadtime:2.9529840946198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hereford' limit 1
loadtime:2.9530460834503 / seconds
Query Executed:select id FROM `co` where city='Hereford' && SIC_code='6531'DB:business_master_new
loadtime:2.9534151554108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hesperus' limit 1
loadtime:2.9534440040588 / seconds
Query Executed:select id FROM `co` where city='Hesperus' && SIC_code='6531'DB:business_master_new
loadtime:2.9554011821747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highlands Ranch' limit 1
loadtime:2.9554600715637 / seconds
Query Executed:select id FROM `co` where city='Highlands Ranch' && SIC_code='6531'DB:business_master_new
loadtime:2.9565939903259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillrose' limit 1
loadtime:2.9566390514374 / seconds
Query Executed:select id FROM `co` where city='Hillrose' && SIC_code='6531'DB:business_master_new
loadtime:2.9571721553802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillside' limit 1
loadtime:2.9572200775146 / seconds
Query Executed:select id FROM `co` where city='Hillside' && SIC_code='6531'DB:business_master_new
loadtime:2.9576451778412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoehne' limit 1
loadtime:2.9576861858368 / seconds
Query Executed:select id FROM `co` where city='Hoehne' && SIC_code='6531'DB:business_master_new
loadtime:2.9580600261688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly' limit 1
loadtime:2.9581060409546 / seconds
Query Executed:select id FROM `co` where city='Holly' && SIC_code='6531'DB:business_master_new
loadtime:2.960193157196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holyoke' limit 1
loadtime:2.9602630138397 / seconds
Query Executed:select id FROM `co` where city='Holyoke' && SIC_code='6531'DB:business_master_new
loadtime:2.9633159637451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Homelake' limit 1
loadtime:2.9633731842041 / seconds
Query Executed:select id FROM `co` where city='Homelake' && SIC_code='6531'DB:business_master_new
loadtime:2.9637491703033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hooper' limit 1
loadtime:2.963790178299 / seconds
Query Executed:select id FROM `co` where city='Hooper' && SIC_code='6531'DB:business_master_new
loadtime:2.9643511772156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hot Sulphur Spgs' limit 1
loadtime:2.9643931388855 / seconds
Query Executed:select id FROM `co` where city='Hot Sulphur Spgs' && SIC_code='6531'DB:business_master_new
loadtime:2.9647181034088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hot Sulphur Springs' limit 1
loadtime:2.9647541046143 / seconds
Query Executed:select id FROM `co` where city='Hot Sulphur Springs' && SIC_code='6531'DB:business_master_new
loadtime:2.9657680988312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hotchkiss' limit 1
loadtime:2.9658169746399 / seconds
Query Executed:select id FROM `co` where city='Hotchkiss' && SIC_code='6531'DB:business_master_new
loadtime:2.9689600467682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howard' limit 1
loadtime:2.9690070152283 / seconds
Query Executed:select id FROM `co` where city='Howard' && SIC_code='6531'DB:business_master_new
loadtime:2.970584154129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:2.9706411361694 / seconds
Query Executed:select id FROM `co` where city='Hudson' && SIC_code='6531'DB:business_master_new
loadtime:2.9724900722504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hugo' limit 1
loadtime:2.9725501537323 / seconds
Query Executed:select id FROM `co` where city='Hugo' && SIC_code='6531'DB:business_master_new
loadtime:2.9738280773163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hygiene' limit 1
loadtime:2.9738819599152 / seconds
Query Executed:select id FROM `co` where city='Hygiene' && SIC_code='6531'DB:business_master_new
loadtime:2.9745659828186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Idaho Springs' limit 1
loadtime:2.9746100902557 / seconds
Query Executed:select id FROM `co` where city='Idaho Springs' && SIC_code='6531'DB:business_master_new
loadtime:2.9777569770813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Idalia' limit 1
loadtime:2.9778151512146 / seconds
Query Executed:select id FROM `co` where city='Idalia' && SIC_code='6531'DB:business_master_new
loadtime:2.9786050319672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Idledale' limit 1
loadtime:2.9786610603333 / seconds
Query Executed:select id FROM `co` where city='Idledale' && SIC_code='6531'DB:business_master_new
loadtime:2.9792110919952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ignacio' limit 1
loadtime:2.9792671203613 / seconds
Query Executed:select id FROM `co` where city='Ignacio' && SIC_code='6531'DB:business_master_new
loadtime:2.9823851585388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iliff' limit 1
loadtime:2.9824421405792 / seconds
Query Executed:select id FROM `co` where city='Iliff' && SIC_code='6531'DB:business_master_new
loadtime:2.9831631183624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Hills' limit 1
loadtime:2.983204126358 / seconds
Query Executed:select id FROM `co` where city='Indian Hills' && SIC_code='6531'DB:business_master_new
loadtime:2.9842751026154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:2.9843339920044 / seconds
Query Executed:select id FROM `co` where city='Jamestown' && SIC_code='6531'DB:business_master_new
loadtime:2.9848871231079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jaroso' limit 1
loadtime:2.9849441051483 / seconds
Query Executed:select id FROM `co` where city='Jaroso' && SIC_code='6531'DB:business_master_new
loadtime:2.9852969646454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:2.9853360652924 / seconds
Query Executed:select id FROM `co` where city='Jefferson' && SIC_code='6531'DB:business_master_new
loadtime:2.9859900474548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joes' limit 1
loadtime:2.986034154892 / seconds
Query Executed:select id FROM `co` where city='Joes' && SIC_code='6531'DB:business_master_new
loadtime:2.9867460727692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnstown' limit 1
loadtime:2.9868030548096 / seconds
Query Executed:select id FROM `co` where city='Johnstown' && SIC_code='6531'DB:business_master_new
loadtime:2.9899091720581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Julesburg' limit 1
loadtime:2.9899690151215 / seconds
Query Executed:select id FROM `co` where city='Julesburg' && SIC_code='6531'DB:business_master_new
loadtime:2.9927010536194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Karval' limit 1
loadtime:2.9927461147308 / seconds
Query Executed:select id FROM `co` where city='Karval' && SIC_code='6531'DB:business_master_new
loadtime:2.9935681819916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keenesburg' limit 1
loadtime:2.9936189651489 / seconds
Query Executed:select id FROM `co` where city='Keenesburg' && SIC_code='6531'DB:business_master_new
loadtime:2.9980540275574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kersey' limit 1
loadtime:2.9980990886688 / seconds
Query Executed:select id FROM `co` where city='Kersey' && SIC_code='6531'DB:business_master_new
loadtime:3.001561164856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keystone' limit 1
loadtime:3.001620054245 / seconds
Query Executed:select id FROM `co` where city='Keystone' && SIC_code='6531'DB:business_master_new
loadtime:3.0021359920502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kim' limit 1
loadtime:3.0021841526031 / seconds
Query Executed:select id FROM `co` where city='Kim' && SIC_code='6531'DB:business_master_new
loadtime:3.0027430057526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kiowa' limit 1
loadtime:3.0027940273285 / seconds
Query Executed:select id FROM `co` where city='Kiowa' && SIC_code='6531'DB:business_master_new
loadtime:3.0047891139984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirk' limit 1
loadtime:3.0048351287842 / seconds
Query Executed:select id FROM `co` where city='Kirk' && SIC_code='6531'DB:business_master_new
loadtime:3.0056631565094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kit Carson' limit 1
loadtime:3.0057201385498 / seconds
Query Executed:select id FROM `co` where city='Kit Carson' && SIC_code='6531'DB:business_master_new
loadtime:3.0065841674805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kittredge' limit 1
loadtime:3.0066270828247 / seconds
Query Executed:select id FROM `co` where city='Kittredge' && SIC_code='6531'DB:business_master_new
loadtime:3.0074570178986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kremmling' limit 1
loadtime:3.0075149536133 / seconds
Query Executed:select id FROM `co` where city='Kremmling' && SIC_code='6531'DB:business_master_new
loadtime:3.0102009773254 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Jara' limit 1
loadtime:3.0102741718292 / seconds
Query Executed:select id FROM `co` where city='La Jara' && SIC_code='6531'DB:business_master_new
loadtime:3.011775970459 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Junta' limit 1
loadtime:3.0118250846863 / seconds
Query Executed:select id FROM `co` where city='La Junta' && SIC_code='6531'DB:business_master_new
loadtime:3.0152070522308 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Salle' limit 1
loadtime:3.0152809619904 / seconds
Query Executed:select id FROM `co` where city='La Salle' && SIC_code='6531'DB:business_master_new
loadtime:3.0175731182098 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Veta' limit 1
loadtime:3.0176341533661 / seconds
Query Executed:select id FROM `co` where city='La Veta' && SIC_code='6531'DB:business_master_new
loadtime:3.0198199748993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lafayette' limit 1
loadtime:3.0198850631714 / seconds
Query Executed:select id FROM `co` where city='Lafayette' && SIC_code='6531'DB:business_master_new
loadtime:3.0236749649048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laird' limit 1
loadtime:3.0237419605255 / seconds
Query Executed:select id FROM `co` where city='Laird' && SIC_code='6531'DB:business_master_new
loadtime:3.0240631103516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake City' limit 1
loadtime:3.0241141319275 / seconds
Query Executed:select id FROM `co` where city='Lake City' && SIC_code='6531'DB:business_master_new
loadtime:3.0258550643921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake George' limit 1
loadtime:3.0259001255035 / seconds
Query Executed:select id FROM `co` where city='Lake George' && SIC_code='6531'DB:business_master_new
loadtime:3.0268921852112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakewood' limit 1
loadtime:3.0269470214844 / seconds
Query Executed:select id FROM `co` where city='Lakewood' && SIC_code='6531'DB:business_master_new
loadtime:3.0298600196838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamar' limit 1
loadtime:3.0299179553986 / seconds
Query Executed:select id FROM `co` where city='Lamar' && SIC_code='6531'DB:business_master_new
loadtime:3.0333211421967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laporte' limit 1
loadtime:3.033390045166 / seconds
Query Executed:select id FROM `co` where city='Laporte' && SIC_code='6531'DB:business_master_new
loadtime:3.0359179973602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Larkspur' limit 1
loadtime:3.0359621047974 / seconds
Query Executed:select id FROM `co` where city='Larkspur' && SIC_code='6531'DB:business_master_new
loadtime:3.038467168808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Las Animas' limit 1
loadtime:3.0385291576385 / seconds
Query Executed:select id FROM `co` where city='Las Animas' && SIC_code='6531'DB:business_master_new
loadtime:3.0406141281128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lazear' limit 1
loadtime:3.0406601428986 / seconds
Query Executed:select id FROM `co` where city='Lazear' && SIC_code='6531'DB:business_master_new
loadtime:3.041032075882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leadville' limit 1
loadtime:3.0410830974579 / seconds
Query Executed:select id FROM `co` where city='Leadville' && SIC_code='6531'DB:business_master_new
loadtime:3.04430103302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewis' limit 1
loadtime:3.0443730354309 / seconds
Query Executed:select id FROM `co` where city='Lewis' && SIC_code='6531'DB:business_master_new
loadtime:3.0449600219727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Limon' limit 1
loadtime:3.0450060367584 / seconds
Query Executed:select id FROM `co` where city='Limon' && SIC_code='6531'DB:business_master_new
loadtime:3.0480780601501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lindon' limit 1
loadtime:3.0481221675873 / seconds
Query Executed:select id FROM `co` where city='Lindon' && SIC_code='6531'DB:business_master_new
loadtime:3.0485961437225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littleton' limit 1
loadtime:3.0486440658569 / seconds
Query Executed:select id FROM `co` where city='Littleton' && SIC_code='6531'DB:business_master_new
loadtime:3.0602991580963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Livermore' limit 1
loadtime:3.0606181621552 / seconds
Query Executed:select id FROM `co` where city='Livermore' && SIC_code='6531'DB:business_master_new
loadtime:3.0618591308594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lochbuie' limit 1
loadtime:3.0619330406189 / seconds
Query Executed:select id FROM `co` where city='Lochbuie' && SIC_code='6531'DB:business_master_new
loadtime:3.0622851848602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Log Lane Village' limit 1
loadtime:3.062313079834 / seconds
Query Executed:select id FROM `co` where city='Log Lane Village' && SIC_code='6531'DB:business_master_new
loadtime:3.062842130661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loma' limit 1
loadtime:3.06290102005 / seconds
Query Executed:select id FROM `co` where city='Loma' && SIC_code='6531'DB:business_master_new
loadtime:3.0641219615936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lone Tree' limit 1
loadtime:3.0641839504242 / seconds
Query Executed:select id FROM `co` where city='Lone Tree' && SIC_code='6531'DB:business_master_new
loadtime:3.067831993103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longmont' limit 1
loadtime:3.0678961277008 / seconds
Query Executed:select id FROM `co` where city='Longmont' && SIC_code='6531'DB:business_master_new
loadtime:3.0748040676117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louisville' limit 1
loadtime:3.0750710964203 / seconds
Query Executed:select id FROM `co` where city='Louisville' && SIC_code='6531'DB:business_master_new
loadtime:3.0794610977173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louviers' limit 1
loadtime:3.0795331001282 / seconds
Query Executed:select id FROM `co` where city='Louviers' && SIC_code='6531'DB:business_master_new
loadtime:3.0800960063934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loveland' limit 1
loadtime:3.080157995224 / seconds
Query Executed:select id FROM `co` where city='Loveland' && SIC_code='6531'DB:business_master_new
loadtime:3.0861511230469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lucerne' limit 1
loadtime:3.0862879753113 / seconds
Query Executed:select id FROM `co` where city='Lucerne' && SIC_code='6531'DB:business_master_new
loadtime:3.086855173111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyons' limit 1
loadtime:3.0869040489197 / seconds
Query Executed:select id FROM `co` where city='Lyons' && SIC_code='6531'DB:business_master_new
loadtime:3.0897920131683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mack' limit 1
loadtime:3.0898549556732 / seconds
Query Executed:select id FROM `co` where city='Mack' && SIC_code='6531'DB:business_master_new
loadtime:3.0905029773712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manassa' limit 1
loadtime:3.0905430316925 / seconds
Query Executed:select id FROM `co` where city='Manassa' && SIC_code='6531'DB:business_master_new
loadtime:3.091325044632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mancos' limit 1
loadtime:3.0913610458374 / seconds
Query Executed:select id FROM `co` where city='Mancos' && SIC_code='6531'DB:business_master_new
loadtime:3.0940310955048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manitou Springs' limit 1
loadtime:3.0940940380096 / seconds
Query Executed:select id FROM `co` where city='Manitou Springs' && SIC_code='6531'DB:business_master_new
loadtime:3.0973200798035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manzanola' limit 1
loadtime:3.0973701477051 / seconds
Query Executed:select id FROM `co` where city='Manzanola' && SIC_code='6531'DB:business_master_new
loadtime:3.0981950759888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble' limit 1
loadtime:3.098265171051 / seconds
Query Executed:select id FROM `co` where city='Marble' && SIC_code='6531'DB:business_master_new
loadtime:3.0986180305481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marvel' limit 1
loadtime:3.0986530780792 / seconds
Query Executed:select id FROM `co` where city='Marvel' && SIC_code='6531'DB:business_master_new
loadtime:3.0991351604462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Masonville' limit 1
loadtime:3.0991840362549 / seconds
Query Executed:select id FROM `co` where city='Masonville' && SIC_code='6531'DB:business_master_new
loadtime:3.0997200012207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Matheson' limit 1
loadtime:3.0997669696808 / seconds
Query Executed:select id FROM `co` where city='Matheson' && SIC_code='6531'DB:business_master_new
loadtime:3.1002411842346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maybell' limit 1
loadtime:3.100289106369 / seconds
Query Executed:select id FROM `co` where city='Maybell' && SIC_code='6531'DB:business_master_new
loadtime:3.1008541584015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Clave' limit 1
loadtime:3.100888967514 / seconds
Query Executed:select id FROM `co` where city='Mc Clave' && SIC_code='6531'DB:business_master_new
loadtime:3.101478099823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Coy' limit 1
loadtime:3.1015219688416 / seconds
Query Executed:select id FROM `co` where city='Mc Coy' && SIC_code='6531'DB:business_master_new
loadtime:3.102028131485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mead' limit 1
loadtime:3.1020770072937 / seconds
Query Executed:select id FROM `co` where city='Mead' && SIC_code='6531'DB:business_master_new
loadtime:3.1035211086273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meeker' limit 1
loadtime:3.103579044342 / seconds
Query Executed:select id FROM `co` where city='Meeker' && SIC_code='6531'DB:business_master_new
loadtime:3.1067271232605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meredith' limit 1
loadtime:3.1067900657654 / seconds
Query Executed:select id FROM `co` where city='Meredith' && SIC_code='6531'DB:business_master_new
loadtime:3.1071469783783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merino' limit 1
loadtime:3.1071791648865 / seconds
Query Executed:select id FROM `co` where city='Merino' && SIC_code='6531'DB:business_master_new
loadtime:3.1080851554871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesa' limit 1
loadtime:3.1081349849701 / seconds
Query Executed:select id FROM `co` where city='Mesa' && SIC_code='6531'DB:business_master_new
loadtime:3.1089551448822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesa Verde National Park' limit 1
loadtime:3.1090061664581 / seconds
Query Executed:select id FROM `co` where city='Mesa Verde National Park' && SIC_code='6531'DB:business_master_new
loadtime:3.1093640327454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesa Vrd Natl Pk' limit 1
loadtime:3.1094040870667 / seconds
Query Executed:select id FROM `co` where city='Mesa Vrd Natl Pk' && SIC_code='6531'DB:business_master_new
loadtime:3.1097259521484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milliken' limit 1
loadtime:3.109766960144 / seconds
Query Executed:select id FROM `co` where city='Milliken' && SIC_code='6531'DB:business_master_new
loadtime:3.111260175705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minturn' limit 1
loadtime:3.1113159656525 / seconds
Query Executed:select id FROM `co` where city='Minturn' && SIC_code='6531'DB:business_master_new
loadtime:3.1130931377411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Model' limit 1
loadtime:3.1131510734558 / seconds
Query Executed:select id FROM `co` where city='Model' && SIC_code='6531'DB:business_master_new
loadtime:3.1135561466217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moffat' limit 1
loadtime:3.1135921478271 / seconds
Query Executed:select id FROM `co` where city='Moffat' && SIC_code='6531'DB:business_master_new
loadtime:3.114354133606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Molina' limit 1
loadtime:3.114401102066 / seconds
Query Executed:select id FROM `co` where city='Molina' && SIC_code='6531'DB:business_master_new
loadtime:3.1147651672363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monarch' limit 1
loadtime:3.1148011684418 / seconds
Query Executed:select id FROM `co` where city='Monarch' && SIC_code='6531'DB:business_master_new
loadtime:3.1151030063629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monte Vista' limit 1
loadtime:3.1151421070099 / seconds
Query Executed:select id FROM `co` where city='Monte Vista' && SIC_code='6531'DB:business_master_new
loadtime:3.1184370517731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montrose' limit 1
loadtime:3.1185021400452 / seconds
Query Executed:select id FROM `co` where city='Montrose' && SIC_code='6531'DB:business_master_new
loadtime:3.1229641437531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monument' limit 1
loadtime:3.1230590343475 / seconds
Query Executed:select id FROM `co` where city='Monument' && SIC_code='6531'DB:business_master_new
loadtime:3.1268241405487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrison' limit 1
loadtime:3.1269021034241 / seconds
Query Executed:select id FROM `co` where city='Morrison' && SIC_code='6531'DB:business_master_new
loadtime:3.1302599906921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mosca' limit 1
loadtime:3.1303141117096 / seconds
Query Executed:select id FROM `co` where city='Mosca' && SIC_code='6531'DB:business_master_new
loadtime:3.1311280727386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain Village' limit 1
loadtime:3.1311881542206 / seconds
Query Executed:select id FROM `co` where city='Mountain Village' && SIC_code='6531'DB:business_master_new
loadtime:3.1315431594849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nathrop' limit 1
loadtime:3.1315920352936 / seconds
Query Executed:select id FROM `co` where city='Nathrop' && SIC_code='6531'DB:business_master_new
loadtime:3.1324601173401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naturita' limit 1
loadtime:3.1325101852417 / seconds
Query Executed:select id FROM `co` where city='Naturita' && SIC_code='6531'DB:business_master_new
loadtime:3.1334099769592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nederland' limit 1
loadtime:3.1334681510925 / seconds
Query Executed:select id FROM `co` where city='Nederland' && SIC_code='6531'DB:business_master_new
loadtime:3.1366240978241 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Castle' limit 1
loadtime:3.1366851329803 / seconds
Query Executed:select id FROM `co` where city='New Castle' && SIC_code='6531'DB:business_master_new
loadtime:3.139760017395 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Raymer' limit 1
loadtime:3.1398220062256 / seconds
Query Executed:select id FROM `co` where city='New Raymer' && SIC_code='6531'DB:business_master_new
loadtime:3.1404139995575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Niwot' limit 1
loadtime:3.1404421329498 / seconds
Query Executed:select id FROM `co` where city='Niwot' && SIC_code='6531'DB:business_master_new
loadtime:3.1417071819305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northglenn' limit 1
loadtime:3.1417651176453 / seconds
Query Executed:select id FROM `co` where city='Northglenn' && SIC_code='6531'DB:business_master_new
loadtime:3.1436519622803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:3.143707036972 / seconds
Query Executed:select id FROM `co` where city='Norwood' && SIC_code='6531'DB:business_master_new
loadtime:3.1456060409546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nucla' limit 1
loadtime:3.1461019515991 / seconds
Query Executed:select id FROM `co` where city='Nucla' && SIC_code='6531'DB:business_master_new
loadtime:3.1472370624542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nunn' limit 1
loadtime:3.147304058075 / seconds
Query Executed:select id FROM `co` where city='Nunn' && SIC_code='6531'DB:business_master_new
loadtime:3.1481759548187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Creek' limit 1
loadtime:3.148225069046 / seconds
Query Executed:select id FROM `co` where city='Oak Creek' && SIC_code='6531'DB:business_master_new
loadtime:3.1496260166168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ohio City' limit 1
loadtime:3.1496870517731 / seconds
Query Executed:select id FROM `co` where city='Ohio City' && SIC_code='6531'DB:business_master_new
loadtime:3.1500511169434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olathe' limit 1
loadtime:3.1500930786133 / seconds
Query Executed:select id FROM `co` where city='Olathe' && SIC_code='6531'DB:business_master_new
loadtime:3.1531810760498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olney Springs' limit 1
loadtime:3.1532549858093 / seconds
Query Executed:select id FROM `co` where city='Olney Springs' && SIC_code='6531'DB:business_master_new
loadtime:3.1537971496582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ophir' limit 1
loadtime:3.1538500785828 / seconds
Query Executed:select id FROM `co` where city='Ophir' && SIC_code='6531'DB:business_master_new
loadtime:3.1542291641235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orchard' limit 1
loadtime:3.1542820930481 / seconds
Query Executed:select id FROM `co` where city='Orchard' && SIC_code='6531'DB:business_master_new
loadtime:3.1547160148621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ordway' limit 1
loadtime:3.1547629833221 / seconds
Query Executed:select id FROM `co` where city='Ordway' && SIC_code='6531'DB:business_master_new
loadtime:3.1561989784241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otis' limit 1
loadtime:3.156268119812 / seconds
Query Executed:select id FROM `co` where city='Otis' && SIC_code='6531'DB:business_master_new
loadtime:3.1571819782257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ouray' limit 1
loadtime:3.1572179794312 / seconds
Query Executed:select id FROM `co` where city='Ouray' && SIC_code='6531'DB:business_master_new
loadtime:3.1600661277771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ovid' limit 1
loadtime:3.1601231098175 / seconds
Query Executed:select id FROM `co` where city='Ovid' && SIC_code='6531'DB:business_master_new
loadtime:3.1609230041504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Padroni' limit 1
loadtime:3.1609699726105 / seconds
Query Executed:select id FROM `co` where city='Padroni' && SIC_code='6531'DB:business_master_new
loadtime:3.1613211631775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pagosa Springs' limit 1
loadtime:3.1613531112671 / seconds
Query Executed:select id FROM `co` where city='Pagosa Springs' && SIC_code='6531'DB:business_master_new
loadtime:3.1657531261444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palisade' limit 1
loadtime:3.1658561229706 / seconds
Query Executed:select id FROM `co` where city='Palisade' && SIC_code='6531'DB:business_master_new
loadtime:3.1689651012421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmer Lake' limit 1
loadtime:3.1690151691437 / seconds
Query Executed:select id FROM `co` where city='Palmer Lake' && SIC_code='6531'DB:business_master_new
loadtime:3.1708550453186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paoli' limit 1
loadtime:3.1709170341492 / seconds
Query Executed:select id FROM `co` where city='Paoli' && SIC_code='6531'DB:business_master_new
loadtime:3.1713020801544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paonia' limit 1
loadtime:3.1713421344757 / seconds
Query Executed:select id FROM `co` where city='Paonia' && SIC_code='6531'DB:business_master_new
loadtime:3.1744661331177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parachute' limit 1
loadtime:3.1745371818542 / seconds
Query Executed:select id FROM `co` where city='Parachute' && SIC_code='6531'DB:business_master_new
loadtime:3.1769421100616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paradox' limit 1
loadtime:3.1770000457764 / seconds
Query Executed:select id FROM `co` where city='Paradox' && SIC_code='6531'DB:business_master_new
loadtime:3.1774940490723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parker' limit 1
loadtime:3.1775350570679 / seconds
Query Executed:select id FROM `co` where city='Parker' && SIC_code='6531'DB:business_master_new
loadtime:3.1827230453491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parlin' limit 1
loadtime:3.1828260421753 / seconds
Query Executed:select id FROM `co` where city='Parlin' && SIC_code='6531'DB:business_master_new
loadtime:3.1832330226898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parshall' limit 1
loadtime:3.1832900047302 / seconds
Query Executed:select id FROM `co` where city='Parshall' && SIC_code='6531'DB:business_master_new
loadtime:3.1838390827179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peetz' limit 1
loadtime:3.1838829517365 / seconds
Query Executed:select id FROM `co` where city='Peetz' && SIC_code='6531'DB:business_master_new
loadtime:3.1844701766968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penrose' limit 1
loadtime:3.1845180988312 / seconds
Query Executed:select id FROM `co` where city='Penrose' && SIC_code='6531'DB:business_master_new
loadtime:3.1875720024109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peterson Afb' limit 1
loadtime:3.1876339912415 / seconds
Query Executed:select id FROM `co` where city='Peterson Afb' && SIC_code='6531'DB:business_master_new
loadtime:3.1881520748138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peyton' limit 1
loadtime:3.1882050037384 / seconds
Query Executed:select id FROM `co` where city='Peyton' && SIC_code='6531'DB:business_master_new
loadtime:3.1914429664612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phippsburg' limit 1
loadtime:3.1914989948273 / seconds
Query Executed:select id FROM `co` where city='Phippsburg' && SIC_code='6531'DB:business_master_new
loadtime:3.1919441223145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierce' limit 1
loadtime:3.1920051574707 / seconds
Query Executed:select id FROM `co` where city='Pierce' && SIC_code='6531'DB:business_master_new
loadtime:3.1929061412811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine' limit 1
loadtime:3.1929559707642 / seconds
Query Executed:select id FROM `co` where city='Pine' && SIC_code='6531'DB:business_master_new
loadtime:3.196033000946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Grove' limit 1
loadtime:3.1960971355438 / seconds
Query Executed:select id FROM `co` where city='Pine Grove' && SIC_code='6531'DB:business_master_new
loadtime:3.1964111328125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinecliffe' limit 1
loadtime:3.1964390277863 / seconds
Query Executed:select id FROM `co` where city='Pinecliffe' && SIC_code='6531'DB:business_master_new
loadtime:3.1968569755554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pitkin' limit 1
loadtime:3.1969041824341 / seconds
Query Executed:select id FROM `co` where city='Pitkin' && SIC_code='6531'DB:business_master_new
loadtime:3.1973559856415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Placerville' limit 1
loadtime:3.1973931789398 / seconds
Query Executed:select id FROM `co` where city='Placerville' && SIC_code='6531'DB:business_master_new
loadtime:3.1979901790619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Platteville' limit 1
loadtime:3.1980261802673 / seconds
Query Executed:select id FROM `co` where city='Platteville' && SIC_code='6531'DB:business_master_new
loadtime:3.2002701759338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant View' limit 1
loadtime:3.200325012207 / seconds
Query Executed:select id FROM `co` where city='Pleasant View' && SIC_code='6531'DB:business_master_new
loadtime:3.2009830474854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poncha Springs' limit 1
loadtime:3.2010200023651 / seconds
Query Executed:select id FROM `co` where city='Poncha Springs' && SIC_code='6531'DB:business_master_new
loadtime:3.2018990516663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powderhorn' limit 1
loadtime:3.2019610404968 / seconds
Query Executed:select id FROM `co` where city='Powderhorn' && SIC_code='6531'DB:business_master_new
loadtime:3.2023711204529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pritchett' limit 1
loadtime:3.2024111747742 / seconds
Query Executed:select id FROM `co` where city='Pritchett' && SIC_code='6531'DB:business_master_new
loadtime:3.2028851509094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pueblo' limit 1
loadtime:3.2029211521149 / seconds
Query Executed:select id FROM `co` where city='Pueblo' && SIC_code='6531'DB:business_master_new
loadtime:3.2104830741882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pueblo West' limit 1
loadtime:3.2107520103455 / seconds
Query Executed:select id FROM `co` where city='Pueblo West' && SIC_code='6531'DB:business_master_new
loadtime:3.211991071701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramah' limit 1
loadtime:3.2120571136475 / seconds
Query Executed:select id FROM `co` where city='Ramah' && SIC_code='6531'DB:business_master_new
loadtime:3.2127270698547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rand' limit 1
loadtime:3.2127749919891 / seconds
Query Executed:select id FROM `co` where city='Rand' && SIC_code='6531'DB:business_master_new
loadtime:3.2131700515747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rangely' limit 1
loadtime:3.2132179737091 / seconds
Query Executed:select id FROM `co` where city='Rangely' && SIC_code='6531'DB:business_master_new
loadtime:3.2162699699402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Cliff' limit 1
loadtime:3.216313123703 / seconds
Query Executed:select id FROM `co` where city='Red Cliff' && SIC_code='6531'DB:business_master_new
loadtime:3.2168040275574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Feather Lakes' limit 1
loadtime:3.2168591022491 / seconds
Query Executed:select id FROM `co` where city='Red Feather Lakes' && SIC_code='6531'DB:business_master_new
loadtime:3.2177531719208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Feather Lks' limit 1
loadtime:3.2177991867065 / seconds
Query Executed:select id FROM `co` where city='Red Feather Lks' && SIC_code='6531'DB:business_master_new
loadtime:3.2181560993195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redstone' limit 1
loadtime:3.2181949615479 / seconds
Query Executed:select id FROM `co` where city='Redstone' && SIC_code='6531'DB:business_master_new
loadtime:3.2185680866241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redvale' limit 1
loadtime:3.2186200618744 / seconds
Query Executed:select id FROM `co` where city='Redvale' && SIC_code='6531'DB:business_master_new
loadtime:3.2191090583801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rico' limit 1
loadtime:3.21915102005 / seconds
Query Executed:select id FROM `co` where city='Rico' && SIC_code='6531'DB:business_master_new
loadtime:3.2198469638824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgway' limit 1
loadtime:3.2199051380157 / seconds
Query Executed:select id FROM `co` where city='Ridgway' && SIC_code='6531'DB:business_master_new
loadtime:3.2230830192566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rifle' limit 1
loadtime:3.2231409549713 / seconds
Query Executed:select id FROM `co` where city='Rifle' && SIC_code='6531'DB:business_master_new
loadtime:3.2265701293945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockvale' limit 1
loadtime:3.2266390323639 / seconds
Query Executed:select id FROM `co` where city='Rockvale' && SIC_code='6531'DB:business_master_new
loadtime:3.2270419597626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Ford' limit 1
loadtime:3.2270841598511 / seconds
Query Executed:select id FROM `co` where city='Rocky Ford' && SIC_code='6531'DB:business_master_new
loadtime:3.2302169799805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roggen' limit 1
loadtime:3.2302920818329 / seconds
Query Executed:select id FROM `co` where city='Roggen' && SIC_code='6531'DB:business_master_new
loadtime:3.2311539649963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rollinsville' limit 1
loadtime:3.2311911582947 / seconds
Query Executed:select id FROM `co` where city='Rollinsville' && SIC_code='6531'DB:business_master_new
loadtime:3.2317721843719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Romeo' limit 1
loadtime:3.2318201065063 / seconds
Query Executed:select id FROM `co` where city='Romeo' && SIC_code='6531'DB:business_master_new
loadtime:3.2322750091553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rush' limit 1
loadtime:3.232311964035 / seconds
Query Executed:select id FROM `co` where city='Rush' && SIC_code='6531'DB:business_master_new
loadtime:3.2329270839691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rye' limit 1
loadtime:3.2329699993134 / seconds
Query Executed:select id FROM `co` where city='Rye' && SIC_code='6531'DB:business_master_new
loadtime:3.2341001033783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saguache' limit 1
loadtime:3.234158039093 / seconds
Query Executed:select id FROM `co` where city='Saguache' && SIC_code='6531'DB:business_master_new
loadtime:3.2352080345154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salida' limit 1
loadtime:3.235267162323 / seconds
Query Executed:select id FROM `co` where city='Salida' && SIC_code='6531'DB:business_master_new
loadtime:3.2389261722565 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Luis' limit 1
loadtime:3.2389969825745 / seconds
Query Executed:select id FROM `co` where city='San Luis' && SIC_code='6531'DB:business_master_new
loadtime:3.2402930259705 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Pablo' limit 1
loadtime:3.2403440475464 / seconds
Query Executed:select id FROM `co` where city='San Pablo' && SIC_code='6531'DB:business_master_new
loadtime:3.2408339977264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanford' limit 1
loadtime:3.240895986557 / seconds
Query Executed:select id FROM `co` where city='Sanford' && SIC_code='6531'DB:business_master_new
loadtime:3.2426149845123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sargents' limit 1
loadtime:3.2426619529724 / seconds
Query Executed:select id FROM `co` where city='Sargents' && SIC_code='6531'DB:business_master_new
loadtime:3.2437901496887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedalia' limit 1
loadtime:3.2439291477203 / seconds
Query Executed:select id FROM `co` where city='Sedalia' && SIC_code='6531'DB:business_master_new
loadtime:3.250321149826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedgwick' limit 1
loadtime:3.2503750324249 / seconds
Query Executed:select id FROM `co` where city='Sedgwick' && SIC_code='6531'DB:business_master_new
loadtime:3.2517809867859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seibert' limit 1
loadtime:3.2518291473389 / seconds
Query Executed:select id FROM `co` where city='Seibert' && SIC_code='6531'DB:business_master_new
loadtime:3.2532751560211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Severance' limit 1
loadtime:3.2533700466156 / seconds
Query Executed:select id FROM `co` where city='Severance' && SIC_code='6531'DB:business_master_new
loadtime:3.2543680667877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shawnee' limit 1
loadtime:3.2545011043549 / seconds
Query Executed:select id FROM `co` where city='Shawnee' && SIC_code='6531'DB:business_master_new
loadtime:3.2553679943085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheridan' limit 1
loadtime:3.2554941177368 / seconds
Query Executed:select id FROM `co` where city='Sheridan' && SIC_code='6531'DB:business_master_new
loadtime:3.2563581466675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheridan Lake' limit 1
loadtime:3.2564761638641 / seconds
Query Executed:select id FROM `co` where city='Sheridan Lake' && SIC_code='6531'DB:business_master_new
loadtime:3.2581381797791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silt' limit 1
loadtime:3.2581880092621 / seconds
Query Executed:select id FROM `co` where city='Silt' && SIC_code='6531'DB:business_master_new
loadtime:3.2650649547577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Cliff' limit 1
loadtime:3.2651960849762 / seconds
Query Executed:select id FROM `co` where city='Silver Cliff' && SIC_code='6531'DB:business_master_new
loadtime:3.2661011219025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Plume' limit 1
loadtime:3.2661509513855 / seconds
Query Executed:select id FROM `co` where city='Silver Plume' && SIC_code='6531'DB:business_master_new
loadtime:3.2666711807251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silverthorne' limit 1
loadtime:3.2667071819305 / seconds
Query Executed:select id FROM `co` where city='Silverthorne' && SIC_code='6531'DB:business_master_new
loadtime:3.2702281475067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silverton' limit 1
loadtime:3.2703120708466 / seconds
Query Executed:select id FROM `co` where city='Silverton' && SIC_code='6531'DB:business_master_new
loadtime:3.272145986557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Simla' limit 1
loadtime:3.2722141742706 / seconds
Query Executed:select id FROM `co` where city='Simla' && SIC_code='6531'DB:business_master_new
loadtime:3.2732679843903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Slater' limit 1
loadtime:3.2733249664307 / seconds
Query Executed:select id FROM `co` where city='Slater' && SIC_code='6531'DB:business_master_new
loadtime:3.2738580703735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snowmass' limit 1
loadtime:3.273894071579 / seconds
Query Executed:select id FROM `co` where city='Snowmass' && SIC_code='6531'DB:business_master_new
loadtime:3.2751650810242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snowmass Village' limit 1
loadtime:3.2752239704132 / seconds
Query Executed:select id FROM `co` where city='Snowmass Village' && SIC_code='6531'DB:business_master_new
loadtime:3.2786891460419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snyder' limit 1
loadtime:3.2787671089172 / seconds
Query Executed:select id FROM `co` where city='Snyder' && SIC_code='6531'DB:business_master_new
loadtime:3.2792680263519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:3.2793200016022 / seconds
Query Executed:select id FROM `co` where city='Somerset' && SIC_code='6531'DB:business_master_new
loadtime:3.2799320220947 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Fork' limit 1
loadtime:3.2799751758575 / seconds
Query Executed:select id FROM `co` where city='South Fork' && SIC_code='6531'DB:business_master_new
loadtime:3.2816021442413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:3.2816691398621 / seconds
Query Executed:select id FROM `co` where city='Springfield' && SIC_code='6531'DB:business_master_new
loadtime:3.2838749885559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steamboat Spgs' limit 1
loadtime:3.2839319705963 / seconds
Query Executed:select id FROM `co` where city='Steamboat Spgs' && SIC_code='6531'DB:business_master_new
loadtime:3.2846779823303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steamboat Springs' limit 1
loadtime:3.2847230434418 / seconds
Query Executed:select id FROM `co` where city='Steamboat Springs' && SIC_code='6531'DB:business_master_new
loadtime:3.2899210453033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:3.2900459766388 / seconds
Query Executed:select id FROM `co` where city='Sterling' && SIC_code='6531'DB:business_master_new
loadtime:3.2938029766083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoneham' limit 1
loadtime:3.2938799858093 / seconds
Query Executed:select id FROM `co` where city='Stoneham' && SIC_code='6531'DB:business_master_new
loadtime:3.2944021224976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strasburg' limit 1
loadtime:3.294440984726 / seconds
Query Executed:select id FROM `co` where city='Strasburg' && SIC_code='6531'DB:business_master_new
loadtime:3.2975521087646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratton' limit 1
loadtime:3.2975990772247 / seconds
Query Executed:select id FROM `co` where city='Stratton' && SIC_code='6531'DB:business_master_new
loadtime:3.299124956131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar City' limit 1
loadtime:3.2991850376129 / seconds
Query Executed:select id FROM `co` where city='Sugar City' && SIC_code='6531'DB:business_master_new
loadtime:3.299681186676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Superior' limit 1
loadtime:3.2997300624847 / seconds
Query Executed:select id FROM `co` where city='Superior' && SIC_code='6531'DB:business_master_new
loadtime:3.3001611232758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swink' limit 1
loadtime:3.3002071380615 / seconds
Query Executed:select id FROM `co` where city='Swink' && SIC_code='6531'DB:business_master_new
loadtime:3.3008890151978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabernash' limit 1
loadtime:3.3009331226349 / seconds
Query Executed:select id FROM `co` where city='Tabernash' && SIC_code='6531'DB:business_master_new
loadtime:3.3019280433655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Telluride' limit 1
loadtime:3.3019871711731 / seconds
Query Executed:select id FROM `co` where city='Telluride' && SIC_code='6531'DB:business_master_new
loadtime:3.3061101436615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornton' limit 1
loadtime:3.3062071800232 / seconds
Query Executed:select id FROM `co` where city='Thornton' && SIC_code='6531'DB:business_master_new
loadtime:3.3104331493378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timnath' limit 1
loadtime:3.3105020523071 / seconds
Query Executed:select id FROM `co` where city='Timnath' && SIC_code='6531'DB:business_master_new
loadtime:3.3110411167145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toponas' limit 1
loadtime:3.3110911846161 / seconds
Query Executed:select id FROM `co` where city='Toponas' && SIC_code='6531'DB:business_master_new
loadtime:3.3114659786224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Towaoc' limit 1
loadtime:3.3115019798279 / seconds
Query Executed:select id FROM `co` where city='Towaoc' && SIC_code='6531'DB:business_master_new
loadtime:3.3121039867401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Towner' limit 1
loadtime:3.3121399879456 / seconds
Query Executed:select id FROM `co` where city='Towner' && SIC_code='6531'DB:business_master_new
loadtime:3.3124711513519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trinchera' limit 1
loadtime:3.3125109672546 / seconds
Query Executed:select id FROM `co` where city='Trinchera' && SIC_code='6531'DB:business_master_new
loadtime:3.312863111496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trinidad' limit 1
loadtime:3.3129050731659 / seconds
Query Executed:select id FROM `co` where city='Trinidad' && SIC_code='6531'DB:business_master_new
loadtime:3.3164839744568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twin Lakes' limit 1
loadtime:3.3170590400696 / seconds
Query Executed:select id FROM `co` where city='Twin Lakes' && SIC_code='6531'DB:business_master_new
loadtime:3.3177790641785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Two Buttes' limit 1
loadtime:3.3178811073303 / seconds
Query Executed:select id FROM `co` where city='Two Buttes' && SIC_code='6531'DB:business_master_new
loadtime:3.3189849853516 / seconds
Query loaded from cache:select * from geodata_geocity where city='U S A F Academy' limit 1
loadtime:3.3191120624542 / seconds
Query Executed:select id FROM `co` where city='U S A F Academy' && SIC_code='6531'DB:business_master_new
loadtime:3.3198211193085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Usaf Academy' limit 1
loadtime:3.3198580741882 / seconds
Query Executed:select id FROM `co` where city='Usaf Academy' && SIC_code='6531'DB:business_master_new
loadtime:3.3220629692078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vail' limit 1
loadtime:3.3221960067749 / seconds
Query Executed:select id FROM `co` where city='Vail' && SIC_code='6531'DB:business_master_new
loadtime:3.3321850299835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:3.3325099945068 / seconds
Query Executed:select id FROM `co` where city='Vernon' && SIC_code='6531'DB:business_master_new
loadtime:3.3338911533356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Victor' limit 1
loadtime:3.3340451717377 / seconds
Query Executed:select id FROM `co` where city='Victor' && SIC_code='6531'DB:business_master_new
loadtime:3.3358111381531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vilas' limit 1
loadtime:3.3359379768372 / seconds
Query Executed:select id FROM `co` where city='Vilas' && SIC_code='6531'DB:business_master_new
loadtime:3.3372039794922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villa Grove' limit 1
loadtime:3.3374381065369 / seconds
Query Executed:select id FROM `co` where city='Villa Grove' && SIC_code='6531'DB:business_master_new
loadtime:3.3382680416107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vona' limit 1
loadtime:3.3383090496063 / seconds
Query Executed:select id FROM `co` where city='Vona' && SIC_code='6531'DB:business_master_new
loadtime:3.3387889862061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walden' limit 1
loadtime:3.338840007782 / seconds
Query Executed:select id FROM `co` where city='Walden' && SIC_code='6531'DB:business_master_new
loadtime:3.3407430648804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walsenburg' limit 1
loadtime:3.3407859802246 / seconds
Query Executed:select id FROM `co` where city='Walsenburg' && SIC_code='6531'DB:business_master_new
loadtime:3.3439531326294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walsh' limit 1
loadtime:3.34401512146 / seconds
Query Executed:select id FROM `co` where city='Walsh' && SIC_code='6531'DB:business_master_new
loadtime:3.34539103508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ward' limit 1
loadtime:3.3454370498657 / seconds
Query Executed:select id FROM `co` where city='Ward' && SIC_code='6531'DB:business_master_new
loadtime:3.3459901809692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watkins' limit 1
loadtime:3.3460500240326 / seconds
Query Executed:select id FROM `co` where city='Watkins' && SIC_code='6531'DB:business_master_new
loadtime:3.347470998764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weldona' limit 1
loadtime:3.3475270271301 / seconds
Query Executed:select id FROM `co` where city='Weldona' && SIC_code='6531'DB:business_master_new
loadtime:3.34827709198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellington' limit 1
loadtime:3.3483271598816 / seconds
Query Executed:select id FROM `co` where city='Wellington' && SIC_code='6531'DB:business_master_new
loadtime:3.351457118988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westcliffe' limit 1
loadtime:3.3515150547028 / seconds
Query Executed:select id FROM `co` where city='Westcliffe' && SIC_code='6531'DB:business_master_new
loadtime:3.3548910617828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:3.3549489974976 / seconds
Query Executed:select id FROM `co` where city='Westminster' && SIC_code='6531'DB:business_master_new
loadtime:3.359227180481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:3.3593180179596 / seconds
Query Executed:select id FROM `co` where city='Weston' && SIC_code='6531'DB:business_master_new
loadtime:3.3600831031799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wetmore' limit 1
loadtime:3.3601381778717 / seconds
Query Executed:select id FROM `co` where city='Wetmore' && SIC_code='6531'DB:business_master_new
loadtime:3.3607130050659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheat Ridge' limit 1
loadtime:3.360769033432 / seconds
Query Executed:select id FROM `co` where city='Wheat Ridge' && SIC_code='6531'DB:business_master_new
loadtime:3.3652579784393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitewater' limit 1
loadtime:3.3653430938721 / seconds
Query Executed:select id FROM `co` where city='Whitewater' && SIC_code='6531'DB:business_master_new
loadtime:3.3663420677185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wiggins' limit 1
loadtime:3.3663971424103 / seconds
Query Executed:select id FROM `co` where city='Wiggins' && SIC_code='6531'DB:business_master_new
loadtime:3.3693590164185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wild Horse' limit 1
loadtime:3.3694169521332 / seconds
Query Executed:select id FROM `co` where city='Wild Horse' && SIC_code='6531'DB:business_master_new
loadtime:3.3697891235352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wiley' limit 1
loadtime:3.3698251247406 / seconds
Query Executed:select id FROM `co` where city='Wiley' && SIC_code='6531'DB:business_master_new
loadtime:3.3707091808319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:3.3707740306854 / seconds
Query Executed:select id FROM `co` where city='Windsor' && SIC_code='6531'DB:business_master_new
loadtime:3.3743669986725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winter Park' limit 1
loadtime:3.3744411468506 / seconds
Query Executed:select id FROM `co` where city='Winter Park' && SIC_code='6531'DB:business_master_new
loadtime:3.3778731822968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolcott' limit 1
loadtime:3.3779489994049 / seconds
Query Executed:select id FROM `co` where city='Wolcott' && SIC_code='6531'DB:business_master_new
loadtime:3.3786370754242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland Park' limit 1
loadtime:3.3786900043488 / seconds
Query Executed:select id FROM `co` where city='Woodland Park' && SIC_code='6531'DB:business_master_new
loadtime:3.3824510574341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodrow' limit 1
loadtime:3.3825311660767 / seconds
Query Executed:select id FROM `co` where city='Woodrow' && SIC_code='6531'DB:business_master_new
loadtime:3.3830759525299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woody Creek' limit 1
loadtime:3.3831231594086 / seconds
Query Executed:select id FROM `co` where city='Woody Creek' && SIC_code='6531'DB:business_master_new
loadtime:3.3839399814606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wray' limit 1
loadtime:3.3839919567108 / seconds
Query Executed:select id FROM `co` where city='Wray' && SIC_code='6531'DB:business_master_new
loadtime:3.38711810112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yampa' limit 1
loadtime:3.3871800899506 / seconds
Query Executed:select id FROM `co` where city='Yampa' && SIC_code='6531'DB:business_master_new
loadtime:3.3879570960999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yellow Jacket' limit 1
loadtime:3.3880009651184 / seconds
Query Executed:select id FROM `co` where city='Yellow Jacket' && SIC_code='6531'DB:business_master_new
loadtime:3.3885519504547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yoder' limit 1
loadtime:3.3886060714722 / seconds
Query Executed:select id FROM `co` where city='Yoder' && SIC_code='6531'DB:business_master_new
loadtime:3.3892781734467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yuma' limit 1
loadtime:3.3893330097198 / seconds
Query Executed:select id FROM `co` where city='Yuma' && SIC_code='6531'DB:business_master_new
loadtime:3.3925750255585 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:3.3926739692688 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:3.3930201530457 / seconds
Operation template executed (chunk cache operation)
loadtime:3.393238067627 / seconds
template override:Default
loadtime:3.3933441638947 / 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:3.3952159881592 / seconds
Template Constructed, Array Rows:49
loadtime:3.3958110809326 / seconds
TOTAL EXECUTION TIME: 3.39527
loadtime:3.3960471153259 / seconds

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


PAGE OBJECT DATA


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



_GET


Array ( [cat_URLid] => real-estate-agents-and-managers [stateURLid] => colorado )


_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:3.3960521221161
TOTAL KEY ARRAYS: 69