DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:5.6028366088867E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0017309188842773 / seconds
host not found setting manual db connection
loadtime:0.0097239017486572 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0099489688873291 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010076999664307 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010133028030396 / seconds
zipcode:
loadtime:0.010162830352783 / seconds
Query Executed:select * from search_referrer where page_hash='4502a2787c2de7dd9f4e13d5c5dabc00' limit 10 DB:ezrox_toadli
loadtime:0.010380029678345 / seconds
Operation header executed (non global)
loadtime:0.010409832000732 / seconds
Operation leaderboard executed (non global)
loadtime:0.010468006134033 / seconds
Operation square executed (non global)
loadtime:0.010499000549316 / seconds
Operation square_bottom executed (non global)
loadtime:0.010525941848755 / seconds
Operation smallsquare executed (non global)
loadtime:0.010551929473877 / seconds
Operation headeradright executed (non global)
loadtime:0.010576963424683 / seconds
Operation google_analytics executed (non global)
loadtime:0.010601997375488 / seconds
Operation topstories executed (non global)
loadtime:0.01062798500061 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010653972625732 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010679006576538 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010896921157837 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011052846908569 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011088848114014 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011147022247314 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011194944381714 / seconds
Template key: archive_menu pushed
loadtime:0.01120400428772 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011217832565308 / seconds
Template key: get_gravatar pushed
loadtime:0.011224031448364 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011234045028687 / seconds
*10)-10)+1 | start:0
loadtime:0.011287927627563 / seconds
Query loaded from cache:select * from categories where cat_URLid='laundry-and-garment-services-nec'
loadtime:0.011329889297485 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='colorado'
loadtime:0.01136589050293 / seconds
DB connected to localhost business_master_new
loadtime:0.011622905731201 / seconds
Query Executed:select * from `co_catmap` where sic='7219' order by city ascDB:business_master_new
loadtime:0.023537874221802 / seconds
Query stored in cache : _QUERY_www.toadli.com57857d00c74af99367d105cbb9747dd1
loadtime:0.02527904510498 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='colorado'
loadtime:0.02533483505249 / seconds
Query Executed:select sum(totalcount) as totalsum from `co_catmap` where sic='7219'DB:business_master_new
loadtime:0.027712821960449 / seconds
Query stored in cache : _QUERY_www.toadli.com665dfdf2fab20aad4a3945cca2f4b9be
loadtime:0.027748823165894 / seconds
438 / 11
loadtime:0.027803897857666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agate' limit 1
loadtime:0.027868986129761 / seconds
Query Executed:select id FROM `co` where city='Agate' && SIC_code='7219'DB:business_master_new
loadtime:0.028769969940186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aguilar' limit 1
loadtime:0.02885103225708 / seconds
Query Executed:select id FROM `co` where city='Aguilar' && SIC_code='7219'DB:business_master_new
loadtime:0.029654979705811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Akron' limit 1
loadtime:0.029711961746216 / seconds
Query Executed:select id FROM `co` where city='Akron' && SIC_code='7219'DB:business_master_new
loadtime:0.030496835708618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alamosa' limit 1
loadtime:0.030550003051758 / seconds
Query Executed:select id FROM `co` where city='Alamosa' && SIC_code='7219'DB:business_master_new
loadtime:0.03131890296936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allenspark' limit 1
loadtime:0.031378030776978 / seconds
Query Executed:select id FROM `co` where city='Allenspark' && SIC_code='7219'DB:business_master_new
loadtime:0.032124996185303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alma' limit 1
loadtime:0.032186985015869 / seconds
Query Executed:select id FROM `co` where city='Alma' && SIC_code='7219'DB:business_master_new
loadtime:0.032938003540039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Almont' limit 1
loadtime:0.0329909324646 / seconds
Query Executed:select id FROM `co` where city='Almont' && SIC_code='7219'DB:business_master_new
loadtime:0.033759832382202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.033812046051025 / seconds
Query Executed:select id FROM `co` where city='Amherst' && SIC_code='7219'DB:business_master_new
loadtime:0.034579038619995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anton' limit 1
loadtime:0.034631967544556 / seconds
Query Executed:select id FROM `co` where city='Anton' && SIC_code='7219'DB:business_master_new
loadtime:0.035405874252319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Antonito' limit 1
loadtime:0.035459041595459 / seconds
Query Executed:select id FROM `co` where city='Antonito' && SIC_code='7219'DB:business_master_new
loadtime:0.036223888397217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arapahoe' limit 1
loadtime:0.036275863647461 / seconds
Query Executed:select id FROM `co` where city='Arapahoe' && SIC_code='7219'DB:business_master_new
loadtime:0.037030935287476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arboles' limit 1
loadtime:0.037086009979248 / seconds
Query Executed:select id FROM `co` where city='Arboles' && SIC_code='7219'DB:business_master_new
loadtime:0.037865877151489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.037919044494629 / seconds
Query Executed:select id FROM `co` where city='Arlington' && SIC_code='7219'DB:business_master_new
loadtime:0.038419008255005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arriba' limit 1
loadtime:0.038470983505249 / seconds
Query Executed:select id FROM `co` where city='Arriba' && SIC_code='7219'DB:business_master_new
loadtime:0.039255857467651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arvada' limit 1
loadtime:0.039306879043579 / seconds
Query Executed:select id FROM `co` where city='Arvada' && SIC_code='7219'DB:business_master_new
loadtime:0.040093898773193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aspen' limit 1
loadtime:0.040180921554565 / seconds
Query Executed:select id FROM `co` where city='Aspen' && SIC_code='7219'DB:business_master_new
loadtime:0.040956974029541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atwood' limit 1
loadtime:0.041010856628418 / seconds
Query Executed:select id FROM `co` where city='Atwood' && SIC_code='7219'DB:business_master_new
loadtime:0.041769981384277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ault' limit 1
loadtime:0.041822910308838 / seconds
Query Executed:select id FROM `co` where city='Ault' && SIC_code='7219'DB:business_master_new
loadtime:0.042579889297485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.042639017105103 / seconds
Query Executed:select id FROM `co` where city='Aurora' && SIC_code='7219'DB:business_master_new
loadtime:0.043432950973511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Austin' limit 1
loadtime:0.043498992919922 / seconds
Query Executed:select id FROM `co` where city='Austin' && SIC_code='7219'DB:business_master_new
loadtime:0.044277906417847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.044348001480103 / seconds
Query Executed:select id FROM `co` where city='Avon' && SIC_code='7219'DB:business_master_new
loadtime:0.045095920562744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avondale' limit 1
loadtime:0.045147895812988 / seconds
Query Executed:select id FROM `co` where city='Avondale' && SIC_code='7219'DB:business_master_new
loadtime:0.045905828475952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bailey' limit 1
loadtime:0.045958995819092 / seconds
Query Executed:select id FROM `co` where city='Bailey' && SIC_code='7219'DB:business_master_new
loadtime:0.0467209815979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Basalt' limit 1
loadtime:0.046772956848145 / seconds
Query Executed:select id FROM `co` where city='Basalt' && SIC_code='7219'DB:business_master_new
loadtime:0.047549962997437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Battlement Mesa' limit 1
loadtime:0.047607898712158 / seconds
Query Executed:select id FROM `co` where city='Battlement Mesa' && SIC_code='7219'DB:business_master_new
loadtime:0.048372030258179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayfield' limit 1
loadtime:0.048425912857056 / seconds
Query Executed:select id FROM `co` where city='Bayfield' && SIC_code='7219'DB:business_master_new
loadtime:0.049208879470825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedrock' limit 1
loadtime:0.04927396774292 / seconds
Query Executed:select id FROM `co` where city='Bedrock' && SIC_code='7219'DB:business_master_new
loadtime:0.04987096786499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellvue' limit 1
loadtime:0.049923896789551 / seconds
Query Executed:select id FROM `co` where city='Bellvue' && SIC_code='7219'DB:business_master_new
loadtime:0.050709009170532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennett' limit 1
loadtime:0.050760984420776 / seconds
Query Executed:select id FROM `co` where city='Bennett' && SIC_code='7219'DB:business_master_new
loadtime:0.051548957824707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berthoud' limit 1
loadtime:0.051601886749268 / seconds
Query Executed:select id FROM `co` where city='Berthoud' && SIC_code='7219'DB:business_master_new
loadtime:0.052364826202393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethune' limit 1
loadtime:0.052417039871216 / seconds
Query Executed:select id FROM `co` where city='Bethune' && SIC_code='7219'DB:business_master_new
loadtime:0.05315899848938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beulah' limit 1
loadtime:0.053216934204102 / seconds
Query Executed:select id FROM `co` where city='Beulah' && SIC_code='7219'DB:business_master_new
loadtime:0.053975820541382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Hawk' limit 1
loadtime:0.054028034210205 / seconds
Query Executed:select id FROM `co` where city='Black Hawk' && SIC_code='7219'DB:business_master_new
loadtime:0.054811954498291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanca' limit 1
loadtime:0.054863929748535 / seconds
Query Executed:select id FROM `co` where city='Blanca' && SIC_code='7219'DB:business_master_new
loadtime:0.055639028549194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boncarbo' limit 1
loadtime:0.055691003799438 / seconds
Query Executed:select id FROM `co` where city='Boncarbo' && SIC_code='7219'DB:business_master_new
loadtime:0.056185007095337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bond' limit 1
loadtime:0.056236982345581 / seconds
Query Executed:select id FROM `co` where city='Bond' && SIC_code='7219'DB:business_master_new
loadtime:0.056972980499268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boone' limit 1
loadtime:0.057024002075195 / seconds
Query Executed:select id FROM `co` where city='Boone' && SIC_code='7219'DB:business_master_new
loadtime:0.057785034179688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boulder' limit 1
loadtime:0.057838916778564 / seconds
Query Executed:select id FROM `co` where city='Boulder' && SIC_code='7219'DB:business_master_new
loadtime:0.058629989624023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.058681011199951 / seconds
Query Executed:select id FROM `co` where city='Brandon' && SIC_code='7219'DB:business_master_new
loadtime:0.05919885635376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branson' limit 1
loadtime:0.059249877929688 / seconds
Query Executed:select id FROM `co` where city='Branson' && SIC_code='7219'DB:business_master_new
loadtime:0.059818029403687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Breckenridge' limit 1
loadtime:0.059871912002563 / seconds
Query Executed:select id FROM `co` where city='Breckenridge' && SIC_code='7219'DB:business_master_new
loadtime:0.0606689453125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Briggsdale' limit 1
loadtime:0.060720920562744 / seconds
Query Executed:select id FROM `co` where city='Briggsdale' && SIC_code='7219'DB:business_master_new
loadtime:0.061493873596191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:0.061544895172119 / seconds
Query Executed:select id FROM `co` where city='Brighton' && SIC_code='7219'DB:business_master_new
loadtime:0.062317848205566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.062373876571655 / seconds
Query Executed:select id FROM `co` where city='Bristol' && SIC_code='7219'DB:business_master_new
loadtime:0.062849998474121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broomfield' limit 1
loadtime:0.062901020050049 / seconds
Query Executed:select id FROM `co` where city='Broomfield' && SIC_code='7219'DB:business_master_new
loadtime:0.06367301940918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brush' limit 1
loadtime:0.063740968704224 / seconds
Query Executed:select id FROM `co` where city='Brush' && SIC_code='7219'DB:business_master_new
loadtime:0.064514875411987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buena Vista' limit 1
loadtime:0.064568042755127 / seconds
Query Executed:select id FROM `co` where city='Buena Vista' && SIC_code='7219'DB:business_master_new
loadtime:0.065321922302246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Creek' limit 1
loadtime:0.065378904342651 / seconds
Query Executed:select id FROM `co` where city='Buffalo Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.066119909286499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.066179990768433 / seconds
Query Executed:select id FROM `co` where city='Burlington' && SIC_code='7219'DB:business_master_new
loadtime:0.066925048828125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burns' limit 1
loadtime:0.066975831985474 / seconds
Query Executed:select id FROM `co` where city='Burns' && SIC_code='7219'DB:business_master_new
loadtime:0.067447900772095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byers' limit 1
loadtime:0.067499876022339 / seconds
Query Executed:select id FROM `co` where city='Byers' && SIC_code='7219'DB:business_master_new
loadtime:0.068249940872192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cahone' limit 1
loadtime:0.068301916122437 / seconds
Query Executed:select id FROM `co` where city='Cahone' && SIC_code='7219'DB:business_master_new
loadtime:0.069053888320923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calhan' limit 1
loadtime:0.069105863571167 / seconds
Query Executed:select id FROM `co` where city='Calhan' && SIC_code='7219'DB:business_master_new
loadtime:0.069881916046143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Campo' limit 1
loadtime:0.069933891296387 / seconds
Query Executed:select id FROM `co` where city='Campo' && SIC_code='7219'DB:business_master_new
loadtime:0.07073187828064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canon City' limit 1
loadtime:0.070785045623779 / seconds
Query Executed:select id FROM `co` where city='Canon City' && SIC_code='7219'DB:business_master_new
loadtime:0.071568012237549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capulin' limit 1
loadtime:0.071619987487793 / seconds
Query Executed:select id FROM `co` where city='Capulin' && SIC_code='7219'DB:business_master_new
loadtime:0.072135925292969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carbondale' limit 1
loadtime:0.072196006774902 / seconds
Query Executed:select id FROM `co` where city='Carbondale' && SIC_code='7219'DB:business_master_new
loadtime:0.07296085357666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carr' limit 1
loadtime:0.073012828826904 / seconds
Query Executed:select id FROM `co` where city='Carr' && SIC_code='7219'DB:business_master_new
loadtime:0.07378101348877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascade' limit 1
loadtime:0.073834896087646 / seconds
Query Executed:select id FROM `co` where city='Cascade' && SIC_code='7219'DB:business_master_new
loadtime:0.074599027633667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castle Rock' limit 1
loadtime:0.074651956558228 / seconds
Query Executed:select id FROM `co` where city='Castle Rock' && SIC_code='7219'DB:business_master_new
loadtime:0.075422048568726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedaredge' limit 1
loadtime:0.07547402381897 / seconds
Query Executed:select id FROM `co` where city='Cedaredge' && SIC_code='7219'DB:business_master_new
loadtime:0.076239824295044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centennial' limit 1
loadtime:0.076292037963867 / seconds
Query Executed:select id FROM `co` where city='Centennial' && SIC_code='7219'DB:business_master_new
loadtime:0.077073812484741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center' limit 1
loadtime:0.077126026153564 / seconds
Query Executed:select id FROM `co` where city='Center' && SIC_code='7219'DB:business_master_new
loadtime:0.077929019927979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central City' limit 1
loadtime:0.077982902526855 / seconds
Query Executed:select id FROM `co` where city='Central City' && SIC_code='7219'DB:business_master_new
loadtime:0.078759908676147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chama' limit 1
loadtime:0.078812837600708 / seconds
Query Executed:select id FROM `co` where city='Chama' && SIC_code='7219'DB:business_master_new
loadtime:0.079267024993896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheraw' limit 1
loadtime:0.079319953918457 / seconds
Query Executed:select id FROM `co` where city='Cheraw' && SIC_code='7219'DB:business_master_new
loadtime:0.080065011978149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Hills Vlg' limit 1
loadtime:0.080116987228394 / seconds
Query Executed:select id FROM `co` where city='Cherry Hills Vlg' && SIC_code='7219'DB:business_master_new
loadtime:0.080651044845581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheyenne Wells' limit 1
loadtime:0.080703020095825 / seconds
Query Executed:select id FROM `co` where city='Cheyenne Wells' && SIC_code='7219'DB:business_master_new
loadtime:0.081472873687744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chimney Rock' limit 1
loadtime:0.081524848937988 / seconds
Query Executed:select id FROM `co` where city='Chimney Rock' && SIC_code='7219'DB:business_master_new
loadtime:0.082022905349731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chromo' limit 1
loadtime:0.082072973251343 / seconds
Query Executed:select id FROM `co` where city='Chromo' && SIC_code='7219'DB:business_master_new
loadtime:0.082828998565674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cimarron' limit 1
loadtime:0.082880020141602 / seconds
Query Executed:select id FROM `co` where city='Cimarron' && SIC_code='7219'DB:business_master_new
loadtime:0.083631038665771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clark' limit 1
loadtime:0.083684921264648 / seconds
Query Executed:select id FROM `co` where city='Clark' && SIC_code='7219'DB:business_master_new
loadtime:0.084444999694824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:0.084496021270752 / seconds
Query Executed:select id FROM `co` where city='Clifton' && SIC_code='7219'DB:business_master_new
loadtime:0.085247039794922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Climax' limit 1
loadtime:0.085299015045166 / seconds
Query Executed:select id FROM `co` where city='Climax' && SIC_code='7219'DB:business_master_new
loadtime:0.085722923278809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coal Creek' limit 1
loadtime:0.085774898529053 / seconds
Query Executed:select id FROM `co` where city='Coal Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.086243867874146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coaldale' limit 1
loadtime:0.086297035217285 / seconds
Query Executed:select id FROM `co` where city='Coaldale' && SIC_code='7219'DB:business_master_new
loadtime:0.087038993835449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coalmont' limit 1
loadtime:0.087090969085693 / seconds
Query Executed:select id FROM `co` where city='Coalmont' && SIC_code='7219'DB:business_master_new
loadtime:0.087607860565186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collbran' limit 1
loadtime:0.087661981582642 / seconds
Query Executed:select id FROM `co` where city='Collbran' && SIC_code='7219'DB:business_master_new
loadtime:0.088425874710083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colorado City' limit 1
loadtime:0.088479042053223 / seconds
Query Executed:select id FROM `co` where city='Colorado City' && SIC_code='7219'DB:business_master_new
loadtime:0.089249849319458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colorado Springs' limit 1
loadtime:0.089301824569702 / seconds
Query Executed:select id FROM `co` where city='Colorado Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.090087890625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbine Valley' limit 1
loadtime:0.090173959732056 / seconds
Query Executed:select id FROM `co` where city='Columbine Valley' && SIC_code='7219'DB:business_master_new
loadtime:0.090967893600464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Commerce City' limit 1
loadtime:0.091020822525024 / seconds
Query Executed:select id FROM `co` where city='Commerce City' && SIC_code='7219'DB:business_master_new
loadtime:0.091814994812012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Como' limit 1
loadtime:0.091866970062256 / seconds
Query Executed:select id FROM `co` where city='Como' && SIC_code='7219'DB:business_master_new
loadtime:0.092460870742798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conejos' limit 1
loadtime:0.092512845993042 / seconds
Query Executed:select id FROM `co` where city='Conejos' && SIC_code='7219'DB:business_master_new
loadtime:0.093291044235229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conifer' limit 1
loadtime:0.093349933624268 / seconds
Query Executed:select id FROM `co` where city='Conifer' && SIC_code='7219'DB:business_master_new
loadtime:0.094115018844604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cope' limit 1
loadtime:0.094182968139648 / seconds
Query Executed:select id FROM `co` where city='Cope' && SIC_code='7219'DB:business_master_new
loadtime:0.094945907592773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copper Mountain' limit 1
loadtime:0.095011949539185 / seconds
Query Executed:select id FROM `co` where city='Copper Mountain' && SIC_code='7219'DB:business_master_new
loadtime:0.095512866973877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cortez' limit 1
loadtime:0.095566034317017 / seconds
Query Executed:select id FROM `co` where city='Cortez' && SIC_code='7219'DB:business_master_new
loadtime:0.096338033676147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cory' limit 1
loadtime:0.096391916275024 / seconds
Query Executed:select id FROM `co` where city='Cory' && SIC_code='7219'DB:business_master_new
loadtime:0.097148895263672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cotopaxi' limit 1
loadtime:0.097208976745605 / seconds
Query Executed:select id FROM `co` where city='Cotopaxi' && SIC_code='7219'DB:business_master_new
loadtime:0.097980976104736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cowdrey' limit 1
loadtime:0.098033905029297 / seconds
Query Executed:select id FROM `co` where city='Cowdrey' && SIC_code='7219'DB:business_master_new
loadtime:0.098592042922974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cpu Louis Guzzo Ent' limit 1
loadtime:0.098642826080322 / seconds
Query Executed:select id FROM `co` where city='Cpu Louis Guzzo Ent' && SIC_code='7219'DB:business_master_new
loadtime:0.099108934402466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craig' limit 1
loadtime:0.099159002304077 / seconds
Query Executed:select id FROM `co` where city='Craig' && SIC_code='7219'DB:business_master_new
loadtime:0.099946022033691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crawford' limit 1
loadtime:0.099998950958252 / seconds
Query Executed:select id FROM `co` where city='Crawford' && SIC_code='7219'DB:business_master_new
loadtime:0.10076904296875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creede' limit 1
loadtime:0.10082101821899 / seconds
Query Executed:select id FROM `co` where city='Creede' && SIC_code='7219'DB:business_master_new
loadtime:0.10159802436829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crested Butte' limit 1
loadtime:0.10164999961853 / seconds
Query Executed:select id FROM `co` where city='Crested Butte' && SIC_code='7219'DB:business_master_new
loadtime:0.10241603851318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crestone' limit 1
loadtime:0.10246896743774 / seconds
Query Executed:select id FROM `co` where city='Crestone' && SIC_code='7219'DB:business_master_new
loadtime:0.10322594642639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cripple Creek' limit 1
loadtime:0.10327792167664 / seconds
Query Executed:select id FROM `co` where city='Cripple Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.10405683517456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crook' limit 1
loadtime:0.10410904884338 / seconds
Query Executed:select id FROM `co` where city='Crook' && SIC_code='7219'DB:business_master_new
loadtime:0.10491490364075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crowley' limit 1
loadtime:0.10496783256531 / seconds
Query Executed:select id FROM `co` where city='Crowley' && SIC_code='7219'DB:business_master_new
loadtime:0.10563492774963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dacono' limit 1
loadtime:0.10568785667419 / seconds
Query Executed:select id FROM `co` where city='Dacono' && SIC_code='7219'DB:business_master_new
loadtime:0.10646796226501 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Beque' limit 1
loadtime:0.10651993751526 / seconds
Query Executed:select id FROM `co` where city='De Beque' && SIC_code='7219'DB:business_master_new
loadtime:0.10731482505798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deckers' limit 1
loadtime:0.10737299919128 / seconds
Query Executed:select id FROM `co` where city='Deckers' && SIC_code='7219'DB:business_master_new
loadtime:0.10794901847839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deer Trail' limit 1
loadtime:0.10800004005432 / seconds
Query Executed:select id FROM `co` where city='Deer Trail' && SIC_code='7219'DB:business_master_new
loadtime:0.10877895355225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Del Norte' limit 1
loadtime:0.10883188247681 / seconds
Query Executed:select id FROM `co` where city='Del Norte' && SIC_code='7219'DB:business_master_new
loadtime:0.10960698127747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delta' limit 1
loadtime:0.10965895652771 / seconds
Query Executed:select id FROM `co` where city='Delta' && SIC_code='7219'DB:business_master_new
loadtime:0.11042094230652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denver' limit 1
loadtime:0.11047196388245 / seconds
Query Executed:select id FROM `co` where city='Denver' && SIC_code='7219'DB:business_master_new
loadtime:0.11124801635742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dillon' limit 1
loadtime:0.11132097244263 / seconds
Query Executed:select id FROM `co` where city='Dillon' && SIC_code='7219'DB:business_master_new
loadtime:0.11209797859192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dinosaur' limit 1
loadtime:0.11215090751648 / seconds
Query Executed:select id FROM `co` where city='Dinosaur' && SIC_code='7219'DB:business_master_new
loadtime:0.11292695999146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Divide' limit 1
loadtime:0.11297988891602 / seconds
Query Executed:select id FROM `co` where city='Divide' && SIC_code='7219'DB:business_master_new
loadtime:0.11376786231995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolores' limit 1
loadtime:0.11381983757019 / seconds
Query Executed:select id FROM `co` where city='Dolores' && SIC_code='7219'DB:business_master_new
loadtime:0.11462092399597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dove Creek' limit 1
loadtime:0.11467385292053 / seconds
Query Executed:select id FROM `co` where city='Dove Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.11548590660095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drake' limit 1
loadtime:0.1155378818512 / seconds
Query Executed:select id FROM `co` where city='Drake' && SIC_code='7219'DB:business_master_new
loadtime:0.11635589599609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dumont' limit 1
loadtime:0.11640787124634 / seconds
Query Executed:select id FROM `co` where city='Dumont' && SIC_code='7219'DB:business_master_new
loadtime:0.11718082427979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dupont' limit 1
loadtime:0.11723399162292 / seconds
Query Executed:select id FROM `co` where city='Dupont' && SIC_code='7219'DB:business_master_new
loadtime:0.11785197257996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durango' limit 1
loadtime:0.11790490150452 / seconds
Query Executed:select id FROM `co` where city='Durango' && SIC_code='7219'DB:business_master_new
loadtime:0.11868381500244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eads' limit 1
loadtime:0.11873602867126 / seconds
Query Executed:select id FROM `co` where city='Eads' && SIC_code='7219'DB:business_master_new
loadtime:0.11951398849487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle' limit 1
loadtime:0.11956596374512 / seconds
Query Executed:select id FROM `co` where city='Eagle' && SIC_code='7219'DB:business_master_new
loadtime:0.12034487724304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastlake' limit 1
loadtime:0.12039685249329 / seconds
Query Executed:select id FROM `co` where city='Eastlake' && SIC_code='7219'DB:business_master_new
loadtime:0.12116003036499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eaton' limit 1
loadtime:0.12121891975403 / seconds
Query Executed:select id FROM `co` where city='Eaton' && SIC_code='7219'DB:business_master_new
loadtime:0.12198090553284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eckert' limit 1
loadtime:0.12203288078308 / seconds
Query Executed:select id FROM `co` where city='Eckert' && SIC_code='7219'DB:business_master_new
loadtime:0.12279796600342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eckley' limit 1
loadtime:0.12284898757935 / seconds
Query Executed:select id FROM `co` where city='Eckley' && SIC_code='7219'DB:business_master_new
loadtime:0.12362098693848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewater' limit 1
loadtime:0.12367391586304 / seconds
Query Executed:select id FROM `co` where city='Edgewater' && SIC_code='7219'DB:business_master_new
loadtime:0.12445092201233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edwards' limit 1
loadtime:0.12450289726257 / seconds
Query Executed:select id FROM `co` where city='Edwards' && SIC_code='7219'DB:business_master_new
loadtime:0.12526988983154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Egnar' limit 1
loadtime:0.12532591819763 / seconds
Query Executed:select id FROM `co` where city='Egnar' && SIC_code='7219'DB:business_master_new
loadtime:0.12585282325745 / seconds
Query loaded from cache:select * from geodata_geocity where city='El Jebel' limit 1
loadtime:0.12590503692627 / seconds
Query Executed:select id FROM `co` where city='El Jebel' && SIC_code='7219'DB:business_master_new
loadtime:0.12643384933472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elbert' limit 1
loadtime:0.12648701667786 / seconds
Query Executed:select id FROM `co` where city='Elbert' && SIC_code='7219'DB:business_master_new
loadtime:0.12730598449707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldorado Springs' limit 1
loadtime:0.12736201286316 / seconds
Query Executed:select id FROM `co` where city='Eldorado Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.12799787521362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elizabeth' limit 1
loadtime:0.12804985046387 / seconds
Query Executed:select id FROM `co` where city='Elizabeth' && SIC_code='7219'DB:business_master_new
loadtime:0.12883400917053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Empire' limit 1
loadtime:0.12888598442078 / seconds
Query Executed:select id FROM `co` where city='Empire' && SIC_code='7219'DB:business_master_new
loadtime:0.12965488433838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Englewood' limit 1
loadtime:0.12970781326294 / seconds
Query Executed:select id FROM `co` where city='Englewood' && SIC_code='7219'DB:business_master_new
loadtime:0.13049793243408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erie' limit 1
loadtime:0.13054990768433 / seconds
Query Executed:select id FROM `co` where city='Erie' && SIC_code='7219'DB:business_master_new
loadtime:0.13132786750793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estes Park' limit 1
loadtime:0.13138389587402 / seconds
Query Executed:select id FROM `co` where city='Estes Park' && SIC_code='7219'DB:business_master_new
loadtime:0.13213086128235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evans' limit 1
loadtime:0.13218998908997 / seconds
Query Executed:select id FROM `co` where city='Evans' && SIC_code='7219'DB:business_master_new
loadtime:0.13294196128845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evergreen' limit 1
loadtime:0.1329939365387 / seconds
Query Executed:select id FROM `co` where city='Evergreen' && SIC_code='7219'DB:business_master_new
loadtime:0.13376498222351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairplay' limit 1
loadtime:0.13383197784424 / seconds
Query Executed:select id FROM `co` where city='Fairplay' && SIC_code='7219'DB:business_master_new
loadtime:0.13460898399353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Federal Heights' limit 1
loadtime:0.13466286659241 / seconds
Query Executed:select id FROM `co` where city='Federal Heights' && SIC_code='7219'DB:business_master_new
loadtime:0.13544082641602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Firestone' limit 1
loadtime:0.13549399375916 / seconds
Query Executed:select id FROM `co` where city='Firestone' && SIC_code='7219'DB:business_master_new
loadtime:0.13626384735107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flagler' limit 1
loadtime:0.13631582260132 / seconds
Query Executed:select id FROM `co` where city='Flagler' && SIC_code='7219'DB:business_master_new
loadtime:0.13708400726318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fleming' limit 1
loadtime:0.13713598251343 / seconds
Query Executed:select id FROM `co` where city='Fleming' && SIC_code='7219'DB:business_master_new
loadtime:0.13793087005615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.13798403739929 / seconds
Query Executed:select id FROM `co` where city='Florence' && SIC_code='7219'DB:business_master_new
loadtime:0.1387779712677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florissant' limit 1
loadtime:0.13882994651794 / seconds
Query Executed:select id FROM `co` where city='Florissant' && SIC_code='7219'DB:business_master_new
loadtime:0.1396119594574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Carson' limit 1
loadtime:0.13966584205627 / seconds
Query Executed:select id FROM `co` where city='Fort Carson' && SIC_code='7219'DB:business_master_new
loadtime:0.1404390335083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Collins' limit 1
loadtime:0.14049291610718 / seconds
Query Executed:select id FROM `co` where city='Fort Collins' && SIC_code='7219'DB:business_master_new
loadtime:0.14129090309143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Garland' limit 1
loadtime:0.14136385917664 / seconds
Query Executed:select id FROM `co` where city='Fort Garland' && SIC_code='7219'DB:business_master_new
loadtime:0.14214992523193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Lupton' limit 1
loadtime:0.1422119140625 / seconds
Query Executed:select id FROM `co` where city='Fort Lupton' && SIC_code='7219'DB:business_master_new
loadtime:0.14298701286316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Lyon' limit 1
loadtime:0.1430389881134 / seconds
Query Executed:select id FROM `co` where city='Fort Lyon' && SIC_code='7219'DB:business_master_new
loadtime:0.14358687400818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Morgan' limit 1
loadtime:0.14363884925842 / seconds
Query Executed:select id FROM `co` where city='Fort Morgan' && SIC_code='7219'DB:business_master_new
loadtime:0.1444079875946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain' limit 1
loadtime:0.14446091651917 / seconds
Query Executed:select id FROM `co` where city='Fountain' && SIC_code='7219'DB:business_master_new
loadtime:0.14522790908813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fowler' limit 1
loadtime:0.14527988433838 / seconds
Query Executed:select id FROM `co` where city='Fowler' && SIC_code='7219'DB:business_master_new
loadtime:0.14604187011719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franktown' limit 1
loadtime:0.14609503746033 / seconds
Query Executed:select id FROM `co` where city='Franktown' && SIC_code='7219'DB:business_master_new
loadtime:0.14686894416809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fraser' limit 1
loadtime:0.14692187309265 / seconds
Query Executed:select id FROM `co` where city='Fraser' && SIC_code='7219'DB:business_master_new
loadtime:0.14770102500916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frederick' limit 1
loadtime:0.14775395393372 / seconds
Query Executed:select id FROM `co` where city='Frederick' && SIC_code='7219'DB:business_master_new
loadtime:0.14854288101196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frisco' limit 1
loadtime:0.1485960483551 / seconds
Query Executed:select id FROM `co` where city='Frisco' && SIC_code='7219'DB:business_master_new
loadtime:0.14937591552734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruita' limit 1
loadtime:0.1494288444519 / seconds
Query Executed:select id FROM `co` where city='Fruita' && SIC_code='7219'DB:business_master_new
loadtime:0.15019488334656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galeton' limit 1
loadtime:0.15024781227112 / seconds
Query Executed:select id FROM `co` where city='Galeton' && SIC_code='7219'DB:business_master_new
loadtime:0.15090584754944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garcia' limit 1
loadtime:0.15095782279968 / seconds
Query Executed:select id FROM `co` where city='Garcia' && SIC_code='7219'DB:business_master_new
loadtime:0.15144991874695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gardner' limit 1
loadtime:0.15150189399719 / seconds
Query Executed:select id FROM `co` where city='Gardner' && SIC_code='7219'DB:business_master_new
loadtime:0.15227603912354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gateway' limit 1
loadtime:0.1523289680481 / seconds
Query Executed:select id FROM `co` where city='Gateway' && SIC_code='7219'DB:business_master_new
loadtime:0.15295386314392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Genoa' limit 1
loadtime:0.15300488471985 / seconds
Query Executed:select id FROM `co` where city='Genoa' && SIC_code='7219'DB:business_master_new
loadtime:0.15380001068115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:0.1538519859314 / seconds
Query Executed:select id FROM `co` where city='Georgetown' && SIC_code='7219'DB:business_master_new
loadtime:0.15463399887085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilcrest' limit 1
loadtime:0.15468788146973 / seconds
Query Executed:select id FROM `co` where city='Gilcrest' && SIC_code='7219'DB:business_master_new
loadtime:0.15545582771301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gill' limit 1
loadtime:0.15550804138184 / seconds
Query Executed:select id FROM `co` where city='Gill' && SIC_code='7219'DB:business_master_new
loadtime:0.15626788139343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glade Park' limit 1
loadtime:0.15631985664368 / seconds
Query Executed:select id FROM `co` where city='Glade Park' && SIC_code='7219'DB:business_master_new
loadtime:0.15707087516785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Haven' limit 1
loadtime:0.15712285041809 / seconds
Query Executed:select id FROM `co` where city='Glen Haven' && SIC_code='7219'DB:business_master_new
loadtime:0.15788292884827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood Springs' limit 1
loadtime:0.15793681144714 / seconds
Query Executed:select id FROM `co` where city='Glenwood Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.1587119102478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Golden' limit 1
loadtime:0.15876483917236 / seconds
Query Executed:select id FROM `co` where city='Golden' && SIC_code='7219'DB:business_master_new
loadtime:0.15955781936646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granada' limit 1
loadtime:0.15961194038391 / seconds
Query Executed:select id FROM `co` where city='Granada' && SIC_code='7219'DB:business_master_new
loadtime:0.16039490699768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:0.16044688224792 / seconds
Query Executed:select id FROM `co` where city='Granby' && SIC_code='7219'DB:business_master_new
loadtime:0.16120386123657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Junction' limit 1
loadtime:0.1612548828125 / seconds
Query Executed:select id FROM `co` where city='Grand Junction' && SIC_code='7219'DB:business_master_new
loadtime:0.16202187538147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Lake' limit 1
loadtime:0.1620888710022 / seconds
Query Executed:select id FROM `co` where city='Grand Lake' && SIC_code='7219'DB:business_master_new
loadtime:0.16286182403564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granite' limit 1
loadtime:0.1629159450531 / seconds
Query Executed:select id FROM `co` where city='Granite' && SIC_code='7219'DB:business_master_new
loadtime:0.16341400146484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grant' limit 1
loadtime:0.16346597671509 / seconds
Query Executed:select id FROM `co` where city='Grant' && SIC_code='7219'DB:business_master_new
loadtime:0.16399502754211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greeley' limit 1
loadtime:0.16404604911804 / seconds
Query Executed:select id FROM `co` where city='Greeley' && SIC_code='7219'DB:business_master_new
loadtime:0.16482901573181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Mountain Falls' limit 1
loadtime:0.16489386558533 / seconds
Query Executed:select id FROM `co` where city='Green Mountain Falls' && SIC_code='7219'DB:business_master_new
loadtime:0.16567993164062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Mtn Falls' limit 1
loadtime:0.1657338142395 / seconds
Query Executed:select id FROM `co` where city='Green Mtn Falls' && SIC_code='7219'DB:business_master_new
loadtime:0.16620898246765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood Vlg' limit 1
loadtime:0.1662609577179 / seconds
Query Executed:select id FROM `co` where city='Greenwood Vlg' && SIC_code='7219'DB:business_master_new
loadtime:0.16701984405518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grover' limit 1
loadtime:0.16707181930542 / seconds
Query Executed:select id FROM `co` where city='Grover' && SIC_code='7219'DB:business_master_new
loadtime:0.16784000396729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guffey' limit 1
loadtime:0.16789388656616 / seconds
Query Executed:select id FROM `co` where city='Guffey' && SIC_code='7219'DB:business_master_new
loadtime:0.16865682601929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gulnare' limit 1
loadtime:0.16870999336243 / seconds
Query Executed:select id FROM `co` where city='Gulnare' && SIC_code='7219'DB:business_master_new
loadtime:0.1691780090332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gunnison' limit 1
loadtime:0.16923093795776 / seconds
Query Executed:select id FROM `co` where city='Gunnison' && SIC_code='7219'DB:business_master_new
loadtime:0.16998696327209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gypsum' limit 1
loadtime:0.17003893852234 / seconds
Query Executed:select id FROM `co` where city='Gypsum' && SIC_code='7219'DB:business_master_new
loadtime:0.17081189155579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:0.17086386680603 / seconds
Query Executed:select id FROM `co` where city='Hamilton' && SIC_code='7219'DB:business_master_new
loadtime:0.17144393920898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartman' limit 1
loadtime:0.17149591445923 / seconds
Query Executed:select id FROM `co` where city='Hartman' && SIC_code='7219'DB:business_master_new
loadtime:0.17200183868408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartsel' limit 1
loadtime:0.17205286026001 / seconds
Query Executed:select id FROM `co` where city='Hartsel' && SIC_code='7219'DB:business_master_new
loadtime:0.17283487319946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hasty' limit 1
loadtime:0.1728880405426 / seconds
Query Executed:select id FROM `co` where city='Hasty' && SIC_code='7219'DB:business_master_new
loadtime:0.17347383499146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haswell' limit 1
loadtime:0.17352795600891 / seconds
Query Executed:select id FROM `co` where city='Haswell' && SIC_code='7219'DB:business_master_new
loadtime:0.17415285110474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haxtun' limit 1
loadtime:0.17421293258667 / seconds
Query Executed:select id FROM `co` where city='Haxtun' && SIC_code='7219'DB:business_master_new
loadtime:0.17500400543213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayden' limit 1
loadtime:0.17505502700806 / seconds
Query Executed:select id FROM `co` where city='Hayden' && SIC_code='7219'DB:business_master_new
loadtime:0.17584490776062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henderson' limit 1
loadtime:0.17589783668518 / seconds
Query Executed:select id FROM `co` where city='Henderson' && SIC_code='7219'DB:business_master_new
loadtime:0.17667388916016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hereford' limit 1
loadtime:0.17672681808472 / seconds
Query Executed:select id FROM `co` where city='Hereford' && SIC_code='7219'DB:business_master_new
loadtime:0.17721199989319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hesperus' limit 1
loadtime:0.17726397514343 / seconds
Query Executed:select id FROM `co` where city='Hesperus' && SIC_code='7219'DB:business_master_new
loadtime:0.1780309677124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highlands Ranch' limit 1
loadtime:0.17808294296265 / seconds
Query Executed:select id FROM `co` where city='Highlands Ranch' && SIC_code='7219'DB:business_master_new
loadtime:0.17886090278625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillrose' limit 1
loadtime:0.17891502380371 / seconds
Query Executed:select id FROM `co` where city='Hillrose' && SIC_code='7219'DB:business_master_new
loadtime:0.17968797683716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillside' limit 1
loadtime:0.1797399520874 / seconds
Query Executed:select id FROM `co` where city='Hillside' && SIC_code='7219'DB:business_master_new
loadtime:0.18026685714722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoehne' limit 1
loadtime:0.18031883239746 / seconds
Query Executed:select id FROM `co` where city='Hoehne' && SIC_code='7219'DB:business_master_new
loadtime:0.18083691596985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly' limit 1
loadtime:0.18088889122009 / seconds
Query Executed:select id FROM `co` where city='Holly' && SIC_code='7219'DB:business_master_new
loadtime:0.18168497085571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holyoke' limit 1
loadtime:0.18173789978027 / seconds
Query Executed:select id FROM `co` where city='Holyoke' && SIC_code='7219'DB:business_master_new
loadtime:0.18253588676453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Homelake' limit 1
loadtime:0.18258881568909 / seconds
Query Executed:select id FROM `co` where city='Homelake' && SIC_code='7219'DB:business_master_new
loadtime:0.18306803703308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hooper' limit 1
loadtime:0.18311786651611 / seconds
Query Executed:select id FROM `co` where city='Hooper' && SIC_code='7219'DB:business_master_new
loadtime:0.18388700485229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hot Sulphur Spgs' limit 1
loadtime:0.18393993377686 / seconds
Query Executed:select id FROM `co` where city='Hot Sulphur Spgs' && SIC_code='7219'DB:business_master_new
loadtime:0.18440794944763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hot Sulphur Springs' limit 1
loadtime:0.18445992469788 / seconds
Query Executed:select id FROM `co` where city='Hot Sulphur Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.18522691726685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hotchkiss' limit 1
loadtime:0.18527889251709 / seconds
Query Executed:select id FROM `co` where city='Hotchkiss' && SIC_code='7219'DB:business_master_new
loadtime:0.18606495857239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howard' limit 1
loadtime:0.18611693382263 / seconds
Query Executed:select id FROM `co` where city='Howard' && SIC_code='7219'DB:business_master_new
loadtime:0.18690299987793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:0.18695402145386 / seconds
Query Executed:select id FROM `co` where city='Hudson' && SIC_code='7219'DB:business_master_new
loadtime:0.18772387504578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hugo' limit 1
loadtime:0.18777704238892 / seconds
Query Executed:select id FROM `co` where city='Hugo' && SIC_code='7219'DB:business_master_new
loadtime:0.188560962677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hygiene' limit 1
loadtime:0.18861293792725 / seconds
Query Executed:select id FROM `co` where city='Hygiene' && SIC_code='7219'DB:business_master_new
loadtime:0.18941402435303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Idaho Springs' limit 1
loadtime:0.18946695327759 / seconds
Query Executed:select id FROM `co` where city='Idaho Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.19025182723999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Idalia' limit 1
loadtime:0.19030284881592 / seconds
Query Executed:select id FROM `co` where city='Idalia' && SIC_code='7219'DB:business_master_new
loadtime:0.19105291366577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Idledale' limit 1
loadtime:0.19110488891602 / seconds
Query Executed:select id FROM `co` where city='Idledale' && SIC_code='7219'DB:business_master_new
loadtime:0.19186091423035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ignacio' limit 1
loadtime:0.19191288948059 / seconds
Query Executed:select id FROM `co` where city='Ignacio' && SIC_code='7219'DB:business_master_new
loadtime:0.19266891479492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iliff' limit 1
loadtime:0.19272184371948 / seconds
Query Executed:select id FROM `co` where city='Iliff' && SIC_code='7219'DB:business_master_new
loadtime:0.19348382949829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Hills' limit 1
loadtime:0.19353699684143 / seconds
Query Executed:select id FROM `co` where city='Indian Hills' && SIC_code='7219'DB:business_master_new
loadtime:0.19430184364319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:0.19435691833496 / seconds
Query Executed:select id FROM `co` where city='Jamestown' && SIC_code='7219'DB:business_master_new
loadtime:0.19511890411377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jaroso' limit 1
loadtime:0.1951789855957 / seconds
Query Executed:select id FROM `co` where city='Jaroso' && SIC_code='7219'DB:business_master_new
loadtime:0.19571781158447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:0.1957700252533 / seconds
Query Executed:select id FROM `co` where city='Jefferson' && SIC_code='7219'DB:business_master_new
loadtime:0.19654583930969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joes' limit 1
loadtime:0.19659900665283 / seconds
Query Executed:select id FROM `co` where city='Joes' && SIC_code='7219'DB:business_master_new
loadtime:0.19738292694092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnstown' limit 1
loadtime:0.19743490219116 / seconds
Query Executed:select id FROM `co` where city='Johnstown' && SIC_code='7219'DB:business_master_new
loadtime:0.19821381568909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Julesburg' limit 1
loadtime:0.19826602935791 / seconds
Query Executed:select id FROM `co` where city='Julesburg' && SIC_code='7219'DB:business_master_new
loadtime:0.19902992248535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Karval' limit 1
loadtime:0.1990818977356 / seconds
Query Executed:select id FROM `co` where city='Karval' && SIC_code='7219'DB:business_master_new
loadtime:0.19984698295593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keenesburg' limit 1
loadtime:0.19989895820618 / seconds
Query Executed:select id FROM `co` where city='Keenesburg' && SIC_code='7219'DB:business_master_new
loadtime:0.20067691802979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kersey' limit 1
loadtime:0.20072984695435 / seconds
Query Executed:select id FROM `co` where city='Kersey' && SIC_code='7219'DB:business_master_new
loadtime:0.20151591300964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keystone' limit 1
loadtime:0.20156788825989 / seconds
Query Executed:select id FROM `co` where city='Keystone' && SIC_code='7219'DB:business_master_new
loadtime:0.2021849155426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kim' limit 1
loadtime:0.20223784446716 / seconds
Query Executed:select id FROM `co` where city='Kim' && SIC_code='7219'DB:business_master_new
loadtime:0.20300698280334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kiowa' limit 1
loadtime:0.20305895805359 / seconds
Query Executed:select id FROM `co` where city='Kiowa' && SIC_code='7219'DB:business_master_new
loadtime:0.20385098457336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirk' limit 1
loadtime:0.20390295982361 / seconds
Query Executed:select id FROM `co` where city='Kirk' && SIC_code='7219'DB:business_master_new
loadtime:0.2046959400177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kit Carson' limit 1
loadtime:0.20474696159363 / seconds
Query Executed:select id FROM `co` where city='Kit Carson' && SIC_code='7219'DB:business_master_new
loadtime:0.2055459022522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kittredge' limit 1
loadtime:0.20559883117676 / seconds
Query Executed:select id FROM `co` where city='Kittredge' && SIC_code='7219'DB:business_master_new
loadtime:0.20636701583862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kremmling' limit 1
loadtime:0.20641899108887 / seconds
Query Executed:select id FROM `co` where city='Kremmling' && SIC_code='7219'DB:business_master_new
loadtime:0.20720100402832 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Jara' limit 1
loadtime:0.20725297927856 / seconds
Query Executed:select id FROM `co` where city='La Jara' && SIC_code='7219'DB:business_master_new
loadtime:0.20803499221802 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Junta' limit 1
loadtime:0.20808792114258 / seconds
Query Executed:select id FROM `co` where city='La Junta' && SIC_code='7219'DB:business_master_new
loadtime:0.20886898040771 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Salle' limit 1
loadtime:0.20892286300659 / seconds
Query Executed:select id FROM `co` where city='La Salle' && SIC_code='7219'DB:business_master_new
loadtime:0.20969700813293 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Veta' limit 1
loadtime:0.20974898338318 / seconds
Query Executed:select id FROM `co` where city='La Veta' && SIC_code='7219'DB:business_master_new
loadtime:0.21052289009094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lafayette' limit 1
loadtime:0.21057486534119 / seconds
Query Executed:select id FROM `co` where city='Lafayette' && SIC_code='7219'DB:business_master_new
loadtime:0.21134400367737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laird' limit 1
loadtime:0.21139597892761 / seconds
Query Executed:select id FROM `co` where city='Laird' && SIC_code='7219'DB:business_master_new
loadtime:0.21182990074158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake City' limit 1
loadtime:0.21188187599182 / seconds
Query Executed:select id FROM `co` where city='Lake City' && SIC_code='7219'DB:business_master_new
loadtime:0.21266102790833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake George' limit 1
loadtime:0.2127149105072 / seconds
Query Executed:select id FROM `co` where city='Lake George' && SIC_code='7219'DB:business_master_new
loadtime:0.21349191665649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakewood' limit 1
loadtime:0.21354484558105 / seconds
Query Executed:select id FROM `co` where city='Lakewood' && SIC_code='7219'DB:business_master_new
loadtime:0.21431303024292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamar' limit 1
loadtime:0.21437001228333 / seconds
Query Executed:select id FROM `co` where city='Lamar' && SIC_code='7219'DB:business_master_new
loadtime:0.21515893936157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laporte' limit 1
loadtime:0.21521782875061 / seconds
Query Executed:select id FROM `co` where city='Laporte' && SIC_code='7219'DB:business_master_new
loadtime:0.21602082252502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Larkspur' limit 1
loadtime:0.21607398986816 / seconds
Query Executed:select id FROM `co` where city='Larkspur' && SIC_code='7219'DB:business_master_new
loadtime:0.21684193611145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Las Animas' limit 1
loadtime:0.21689391136169 / seconds
Query Executed:select id FROM `co` where city='Las Animas' && SIC_code='7219'DB:business_master_new
loadtime:0.21767091751099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lazear' limit 1
loadtime:0.21772193908691 / seconds
Query Executed:select id FROM `co` where city='Lazear' && SIC_code='7219'DB:business_master_new
loadtime:0.21824383735657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leadville' limit 1
loadtime:0.21829581260681 / seconds
Query Executed:select id FROM `co` where city='Leadville' && SIC_code='7219'DB:business_master_new
loadtime:0.21909093856812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewis' limit 1
loadtime:0.21914386749268 / seconds
Query Executed:select id FROM `co` where city='Lewis' && SIC_code='7219'DB:business_master_new
loadtime:0.21994304656982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Limon' limit 1
loadtime:0.21999502182007 / seconds
Query Executed:select id FROM `co` where city='Limon' && SIC_code='7219'DB:business_master_new
loadtime:0.22078490257263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lindon' limit 1
loadtime:0.22083783149719 / seconds
Query Executed:select id FROM `co` where city='Lindon' && SIC_code='7219'DB:business_master_new
loadtime:0.2214469909668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littleton' limit 1
loadtime:0.22149991989136 / seconds
Query Executed:select id FROM `co` where city='Littleton' && SIC_code='7219'DB:business_master_new
loadtime:0.22232604026794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Livermore' limit 1
loadtime:0.22239899635315 / seconds
Query Executed:select id FROM `co` where city='Livermore' && SIC_code='7219'DB:business_master_new
loadtime:0.22319483757019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lochbuie' limit 1
loadtime:0.22324681282043 / seconds
Query Executed:select id FROM `co` where city='Lochbuie' && SIC_code='7219'DB:business_master_new
loadtime:0.22371482849121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Log Lane Village' limit 1
loadtime:0.22376704216003 / seconds
Query Executed:select id FROM `co` where city='Log Lane Village' && SIC_code='7219'DB:business_master_new
loadtime:0.224534034729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loma' limit 1
loadtime:0.22458696365356 / seconds
Query Executed:select id FROM `co` where city='Loma' && SIC_code='7219'DB:business_master_new
loadtime:0.22535681724548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lone Tree' limit 1
loadtime:0.22540998458862 / seconds
Query Executed:select id FROM `co` where city='Lone Tree' && SIC_code='7219'DB:business_master_new
loadtime:0.22618389129639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longmont' limit 1
loadtime:0.22623682022095 / seconds
Query Executed:select id FROM `co` where city='Longmont' && SIC_code='7219'DB:business_master_new
loadtime:0.22706604003906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louisville' limit 1
loadtime:0.22713398933411 / seconds
Query Executed:select id FROM `co` where city='Louisville' && SIC_code='7219'DB:business_master_new
loadtime:0.22796702384949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louviers' limit 1
loadtime:0.22802090644836 / seconds
Query Executed:select id FROM `co` where city='Louviers' && SIC_code='7219'DB:business_master_new
loadtime:0.22880887985229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loveland' limit 1
loadtime:0.22886204719543 / seconds
Query Executed:select id FROM `co` where city='Loveland' && SIC_code='7219'DB:business_master_new
loadtime:0.22964787483215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lucerne' limit 1
loadtime:0.22971391677856 / seconds
Query Executed:select id FROM `co` where city='Lucerne' && SIC_code='7219'DB:business_master_new
loadtime:0.2304949760437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyons' limit 1
loadtime:0.23054790496826 / seconds
Query Executed:select id FROM `co` where city='Lyons' && SIC_code='7219'DB:business_master_new
loadtime:0.23131895065308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mack' limit 1
loadtime:0.2313768863678 / seconds
Query Executed:select id FROM `co` where city='Mack' && SIC_code='7219'DB:business_master_new
loadtime:0.23213481903076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manassa' limit 1
loadtime:0.23219394683838 / seconds
Query Executed:select id FROM `co` where city='Manassa' && SIC_code='7219'DB:business_master_new
loadtime:0.2329728603363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mancos' limit 1
loadtime:0.23302483558655 / seconds
Query Executed:select id FROM `co` where city='Mancos' && SIC_code='7219'DB:business_master_new
loadtime:0.23383092880249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manitou Springs' limit 1
loadtime:0.23388290405273 / seconds
Query Executed:select id FROM `co` where city='Manitou Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.23467588424683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manzanola' limit 1
loadtime:0.23472785949707 / seconds
Query Executed:select id FROM `co` where city='Manzanola' && SIC_code='7219'DB:business_master_new
loadtime:0.23550486564636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble' limit 1
loadtime:0.23555684089661 / seconds
Query Executed:select id FROM `co` where city='Marble' && SIC_code='7219'DB:business_master_new
loadtime:0.23603701591492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marvel' limit 1
loadtime:0.23608803749084 / seconds
Query Executed:select id FROM `co` where city='Marvel' && SIC_code='7219'DB:business_master_new
loadtime:0.23685693740845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Masonville' limit 1
loadtime:0.23690891265869 / seconds
Query Executed:select id FROM `co` where city='Masonville' && SIC_code='7219'DB:business_master_new
loadtime:0.23766994476318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Matheson' limit 1
loadtime:0.23772287368774 / seconds
Query Executed:select id FROM `co` where city='Matheson' && SIC_code='7219'DB:business_master_new
loadtime:0.23848795890808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maybell' limit 1
loadtime:0.23854088783264 / seconds
Query Executed:select id FROM `co` where city='Maybell' && SIC_code='7219'DB:business_master_new
loadtime:0.23930382728577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Clave' limit 1
loadtime:0.23935985565186 / seconds
Query Executed:select id FROM `co` where city='Mc Clave' && SIC_code='7219'DB:business_master_new
loadtime:0.24011993408203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Coy' limit 1
loadtime:0.24018001556396 / seconds
Query Executed:select id FROM `co` where city='Mc Coy' && SIC_code='7219'DB:business_master_new
loadtime:0.24083304405212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mead' limit 1
loadtime:0.24088501930237 / seconds
Query Executed:select id FROM `co` where city='Mead' && SIC_code='7219'DB:business_master_new
loadtime:0.24166083335876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meeker' limit 1
loadtime:0.24171304702759 / seconds
Query Executed:select id FROM `co` where city='Meeker' && SIC_code='7219'DB:business_master_new
loadtime:0.24247598648071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meredith' limit 1
loadtime:0.24252891540527 / seconds
Query Executed:select id FROM `co` where city='Meredith' && SIC_code='7219'DB:business_master_new
loadtime:0.24300384521484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merino' limit 1
loadtime:0.24305486679077 / seconds
Query Executed:select id FROM `co` where city='Merino' && SIC_code='7219'DB:business_master_new
loadtime:0.24381804466248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesa' limit 1
loadtime:0.24387097358704 / seconds
Query Executed:select id FROM `co` where city='Mesa' && SIC_code='7219'DB:business_master_new
loadtime:0.24463987350464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesa Verde National Park' limit 1
loadtime:0.24469304084778 / seconds
Query Executed:select id FROM `co` where city='Mesa Verde National Park' && SIC_code='7219'DB:business_master_new
loadtime:0.2452118396759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesa Vrd Natl Pk' limit 1
loadtime:0.24526286125183 / seconds
Query Executed:select id FROM `co` where city='Mesa Vrd Natl Pk' && SIC_code='7219'DB:business_master_new
loadtime:0.24571084976196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milliken' limit 1
loadtime:0.24576282501221 / seconds
Query Executed:select id FROM `co` where city='Milliken' && SIC_code='7219'DB:business_master_new
loadtime:0.24653887748718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minturn' limit 1
loadtime:0.24659085273743 / seconds
Query Executed:select id FROM `co` where city='Minturn' && SIC_code='7219'DB:business_master_new
loadtime:0.24737000465393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Model' limit 1
loadtime:0.24742197990417 / seconds
Query Executed:select id FROM `co` where city='Model' && SIC_code='7219'DB:business_master_new
loadtime:0.24792885780334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moffat' limit 1
loadtime:0.24797987937927 / seconds
Query Executed:select id FROM `co` where city='Moffat' && SIC_code='7219'DB:business_master_new
loadtime:0.24874782562256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Molina' limit 1
loadtime:0.24880003929138 / seconds
Query Executed:select id FROM `co` where city='Molina' && SIC_code='7219'DB:business_master_new
loadtime:0.24930381774902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monarch' limit 1
loadtime:0.24935984611511 / seconds
Query Executed:select id FROM `co` where city='Monarch' && SIC_code='7219'DB:business_master_new
loadtime:0.24981188774109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monte Vista' limit 1
loadtime:0.24986386299133 / seconds
Query Executed:select id FROM `co` where city='Monte Vista' && SIC_code='7219'DB:business_master_new
loadtime:0.2506320476532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montrose' limit 1
loadtime:0.25068402290344 / seconds
Query Executed:select id FROM `co` where city='Montrose' && SIC_code='7219'DB:business_master_new
loadtime:0.25147986412048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monument' limit 1
loadtime:0.25154590606689 / seconds
Query Executed:select id FROM `co` where city='Monument' && SIC_code='7219'DB:business_master_new
loadtime:0.25233888626099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrison' limit 1
loadtime:0.25239300727844 / seconds
Query Executed:select id FROM `co` where city='Morrison' && SIC_code='7219'DB:business_master_new
loadtime:0.25314998626709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mosca' limit 1
loadtime:0.25320982933044 / seconds
Query Executed:select id FROM `co` where city='Mosca' && SIC_code='7219'DB:business_master_new
loadtime:0.25397086143494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain Village' limit 1
loadtime:0.25402283668518 / seconds
Query Executed:select id FROM `co` where city='Mountain Village' && SIC_code='7219'DB:business_master_new
loadtime:0.25449395179749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nathrop' limit 1
loadtime:0.25454688072205 / seconds
Query Executed:select id FROM `co` where city='Nathrop' && SIC_code='7219'DB:business_master_new
loadtime:0.2552969455719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naturita' limit 1
loadtime:0.2553539276123 / seconds
Query Executed:select id FROM `co` where city='Naturita' && SIC_code='7219'DB:business_master_new
loadtime:0.25610399246216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nederland' limit 1
loadtime:0.25615501403809 / seconds
Query Executed:select id FROM `co` where city='Nederland' && SIC_code='7219'DB:business_master_new
loadtime:0.25694704055786 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Castle' limit 1
loadtime:0.25699901580811 / seconds
Query Executed:select id FROM `co` where city='New Castle' && SIC_code='7219'DB:business_master_new
loadtime:0.25779485702515 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Raymer' limit 1
loadtime:0.25784802436829 / seconds
Query Executed:select id FROM `co` where city='New Raymer' && SIC_code='7219'DB:business_master_new
loadtime:0.2586350440979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Niwot' limit 1
loadtime:0.25868582725525 / seconds
Query Executed:select id FROM `co` where city='Niwot' && SIC_code='7219'DB:business_master_new
loadtime:0.25946283340454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northglenn' limit 1
loadtime:0.25951504707336 / seconds
Query Executed:select id FROM `co` where city='Northglenn' && SIC_code='7219'DB:business_master_new
loadtime:0.26028394699097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:0.26033782958984 / seconds
Query Executed:select id FROM `co` where city='Norwood' && SIC_code='7219'DB:business_master_new
loadtime:0.26111483573914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nucla' limit 1
loadtime:0.26117396354675 / seconds
Query Executed:select id FROM `co` where city='Nucla' && SIC_code='7219'DB:business_master_new
loadtime:0.261962890625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nunn' limit 1
loadtime:0.26201486587524 / seconds
Query Executed:select id FROM `co` where city='Nunn' && SIC_code='7219'DB:business_master_new
loadtime:0.26280903816223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Creek' limit 1
loadtime:0.26286101341248 / seconds
Query Executed:select id FROM `co` where city='Oak Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.26367592811584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ohio City' limit 1
loadtime:0.26372790336609 / seconds
Query Executed:select id FROM `co` where city='Ohio City' && SIC_code='7219'DB:business_master_new
loadtime:0.26427292823792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olathe' limit 1
loadtime:0.26432585716248 / seconds
Query Executed:select id FROM `co` where city='Olathe' && SIC_code='7219'DB:business_master_new
loadtime:0.2651150226593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olney Springs' limit 1
loadtime:0.26517486572266 / seconds
Query Executed:select id FROM `co` where city='Olney Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.26595497131348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ophir' limit 1
loadtime:0.26600790023804 / seconds
Query Executed:select id FROM `co` where city='Ophir' && SIC_code='7219'DB:business_master_new
loadtime:0.26657891273499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orchard' limit 1
loadtime:0.26663088798523 / seconds
Query Executed:select id FROM `co` where city='Orchard' && SIC_code='7219'DB:business_master_new
loadtime:0.26725482940674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ordway' limit 1
loadtime:0.26730704307556 / seconds
Query Executed:select id FROM `co` where city='Ordway' && SIC_code='7219'DB:business_master_new
loadtime:0.2680869102478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otis' limit 1
loadtime:0.26813888549805 / seconds
Query Executed:select id FROM `co` where city='Otis' && SIC_code='7219'DB:business_master_new
loadtime:0.26892685890198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ouray' limit 1
loadtime:0.26898002624512 / seconds
Query Executed:select id FROM `co` where city='Ouray' && SIC_code='7219'DB:business_master_new
loadtime:0.26977300643921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ovid' limit 1
loadtime:0.26982498168945 / seconds
Query Executed:select id FROM `co` where city='Ovid' && SIC_code='7219'DB:business_master_new
loadtime:0.27060985565186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Padroni' limit 1
loadtime:0.270663022995 / seconds
Query Executed:select id FROM `co` where city='Padroni' && SIC_code='7219'DB:business_master_new
loadtime:0.2711968421936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pagosa Springs' limit 1
loadtime:0.27124786376953 / seconds
Query Executed:select id FROM `co` where city='Pagosa Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.27202701568604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palisade' limit 1
loadtime:0.27208185195923 / seconds
Query Executed:select id FROM `co` where city='Palisade' && SIC_code='7219'DB:business_master_new
loadtime:0.2728579044342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmer Lake' limit 1
loadtime:0.27290987968445 / seconds
Query Executed:select id FROM `co` where city='Palmer Lake' && SIC_code='7219'DB:business_master_new
loadtime:0.27368688583374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paoli' limit 1
loadtime:0.27373886108398 / seconds
Query Executed:select id FROM `co` where city='Paoli' && SIC_code='7219'DB:business_master_new
loadtime:0.27430391311646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paonia' limit 1
loadtime:0.27435994148254 / seconds
Query Executed:select id FROM `co` where city='Paonia' && SIC_code='7219'DB:business_master_new
loadtime:0.27513885498047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parachute' limit 1
loadtime:0.2751989364624 / seconds
Query Executed:select id FROM `co` where city='Parachute' && SIC_code='7219'DB:business_master_new
loadtime:0.27598881721497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paradox' limit 1
loadtime:0.27604198455811 / seconds
Query Executed:select id FROM `co` where city='Paradox' && SIC_code='7219'DB:business_master_new
loadtime:0.27668690681458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parker' limit 1
loadtime:0.27674102783203 / seconds
Query Executed:select id FROM `co` where city='Parker' && SIC_code='7219'DB:business_master_new
loadtime:0.27752304077148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parlin' limit 1
loadtime:0.27758884429932 / seconds
Query Executed:select id FROM `co` where city='Parlin' && SIC_code='7219'DB:business_master_new
loadtime:0.27815985679626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parshall' limit 1
loadtime:0.2782199382782 / seconds
Query Executed:select id FROM `co` where city='Parshall' && SIC_code='7219'DB:business_master_new
loadtime:0.2788610458374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peetz' limit 1
loadtime:0.27891397476196 / seconds
Query Executed:select id FROM `co` where city='Peetz' && SIC_code='7219'DB:business_master_new
loadtime:0.27968287467957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penrose' limit 1
loadtime:0.27973484992981 / seconds
Query Executed:select id FROM `co` where city='Penrose' && SIC_code='7219'DB:business_master_new
loadtime:0.28050398826599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peterson Afb' limit 1
loadtime:0.28055596351624 / seconds
Query Executed:select id FROM `co` where city='Peterson Afb' && SIC_code='7219'DB:business_master_new
loadtime:0.2813138961792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peyton' limit 1
loadtime:0.28137183189392 / seconds
Query Executed:select id FROM `co` where city='Peyton' && SIC_code='7219'DB:business_master_new
loadtime:0.28212285041809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phippsburg' limit 1
loadtime:0.28219604492188 / seconds
Query Executed:select id FROM `co` where city='Phippsburg' && SIC_code='7219'DB:business_master_new
loadtime:0.28275799751282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierce' limit 1
loadtime:0.28280997276306 / seconds
Query Executed:select id FROM `co` where city='Pierce' && SIC_code='7219'DB:business_master_new
loadtime:0.28356790542603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine' limit 1
loadtime:0.28361988067627 / seconds
Query Executed:select id FROM `co` where city='Pine' && SIC_code='7219'DB:business_master_new
loadtime:0.28438091278076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Grove' limit 1
loadtime:0.28443288803101 / seconds
Query Executed:select id FROM `co` where city='Pine Grove' && SIC_code='7219'DB:business_master_new
loadtime:0.28489089012146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinecliffe' limit 1
loadtime:0.28494095802307 / seconds
Query Executed:select id FROM `co` where city='Pinecliffe' && SIC_code='7219'DB:business_master_new
loadtime:0.28552103042603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pitkin' limit 1
loadtime:0.28557395935059 / seconds
Query Executed:select id FROM `co` where city='Pitkin' && SIC_code='7219'DB:business_master_new
loadtime:0.28633594512939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Placerville' limit 1
loadtime:0.28638887405396 / seconds
Query Executed:select id FROM `co` where city='Placerville' && SIC_code='7219'DB:business_master_new
loadtime:0.28713488578796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Platteville' limit 1
loadtime:0.28719401359558 / seconds
Query Executed:select id FROM `co` where city='Platteville' && SIC_code='7219'DB:business_master_new
loadtime:0.28798794746399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant View' limit 1
loadtime:0.28804087638855 / seconds
Query Executed:select id FROM `co` where city='Pleasant View' && SIC_code='7219'DB:business_master_new
loadtime:0.28883600234985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poncha Springs' limit 1
loadtime:0.2888879776001 / seconds
Query Executed:select id FROM `co` where city='Poncha Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.28966999053955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powderhorn' limit 1
loadtime:0.28972196578979 / seconds
Query Executed:select id FROM `co` where city='Powderhorn' && SIC_code='7219'DB:business_master_new
loadtime:0.29025197029114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pritchett' limit 1
loadtime:0.29030299186707 / seconds
Query Executed:select id FROM `co` where city='Pritchett' && SIC_code='7219'DB:business_master_new
loadtime:0.29105591773987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pueblo' limit 1
loadtime:0.29110789299011 / seconds
Query Executed:select id FROM `co` where city='Pueblo' && SIC_code='7219'DB:business_master_new
loadtime:0.29187202453613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pueblo West' limit 1
loadtime:0.29192495346069 / seconds
Query Executed:select id FROM `co` where city='Pueblo West' && SIC_code='7219'DB:business_master_new
loadtime:0.29269003868103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramah' limit 1
loadtime:0.29274082183838 / seconds
Query Executed:select id FROM `co` where city='Ramah' && SIC_code='7219'DB:business_master_new
loadtime:0.29351496696472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rand' limit 1
loadtime:0.29356694221497 / seconds
Query Executed:select id FROM `co` where city='Rand' && SIC_code='7219'DB:business_master_new
loadtime:0.29413199424744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rangely' limit 1
loadtime:0.29419088363647 / seconds
Query Executed:select id FROM `co` where city='Rangely' && SIC_code='7219'DB:business_master_new
loadtime:0.29495191574097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Cliff' limit 1
loadtime:0.29500293731689 / seconds
Query Executed:select id FROM `co` where city='Red Cliff' && SIC_code='7219'DB:business_master_new
loadtime:0.29577398300171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Feather Lakes' limit 1
loadtime:0.29582691192627 / seconds
Query Executed:select id FROM `co` where city='Red Feather Lakes' && SIC_code='7219'DB:business_master_new
loadtime:0.29660391807556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Feather Lks' limit 1
loadtime:0.29665589332581 / seconds
Query Executed:select id FROM `co` where city='Red Feather Lks' && SIC_code='7219'DB:business_master_new
loadtime:0.29714488983154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redstone' limit 1
loadtime:0.29720401763916 / seconds
Query Executed:select id FROM `co` where city='Redstone' && SIC_code='7219'DB:business_master_new
loadtime:0.29767990112305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redvale' limit 1
loadtime:0.29773187637329 / seconds
Query Executed:select id FROM `co` where city='Redvale' && SIC_code='7219'DB:business_master_new
loadtime:0.29849791526794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rico' limit 1
loadtime:0.29854989051819 / seconds
Query Executed:select id FROM `co` where city='Rico' && SIC_code='7219'DB:business_master_new
loadtime:0.29931092262268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgway' limit 1
loadtime:0.2993688583374 / seconds
Query Executed:select id FROM `co` where city='Ridgway' && SIC_code='7219'DB:business_master_new
loadtime:0.30012989044189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rifle' limit 1
loadtime:0.30019187927246 / seconds
Query Executed:select id FROM `co` where city='Rifle' && SIC_code='7219'DB:business_master_new
loadtime:0.30095791816711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockvale' limit 1
loadtime:0.30100989341736 / seconds
Query Executed:select id FROM `co` where city='Rockvale' && SIC_code='7219'DB:business_master_new
loadtime:0.30155682563782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Ford' limit 1
loadtime:0.30160903930664 / seconds
Query Executed:select id FROM `co` where city='Rocky Ford' && SIC_code='7219'DB:business_master_new
loadtime:0.30240488052368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roggen' limit 1
loadtime:0.30245685577393 / seconds
Query Executed:select id FROM `co` where city='Roggen' && SIC_code='7219'DB:business_master_new
loadtime:0.30324101448059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rollinsville' limit 1
loadtime:0.30329298973083 / seconds
Query Executed:select id FROM `co` where city='Rollinsville' && SIC_code='7219'DB:business_master_new
loadtime:0.30405783653259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Romeo' limit 1
loadtime:0.30410981178284 / seconds
Query Executed:select id FROM `co` where city='Romeo' && SIC_code='7219'DB:business_master_new
loadtime:0.30471801757812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rush' limit 1
loadtime:0.304771900177 / seconds
Query Executed:select id FROM `co` where city='Rush' && SIC_code='7219'DB:business_master_new
loadtime:0.30556297302246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rye' limit 1
loadtime:0.30561494827271 / seconds
Query Executed:select id FROM `co` where city='Rye' && SIC_code='7219'DB:business_master_new
loadtime:0.30639982223511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saguache' limit 1
loadtime:0.30645298957825 / seconds
Query Executed:select id FROM `co` where city='Saguache' && SIC_code='7219'DB:business_master_new
loadtime:0.30722999572754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salida' limit 1
loadtime:0.30728197097778 / seconds
Query Executed:select id FROM `co` where city='Salida' && SIC_code='7219'DB:business_master_new
loadtime:0.30806684494019 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Luis' limit 1
loadtime:0.30811882019043 / seconds
Query Executed:select id FROM `co` where city='San Luis' && SIC_code='7219'DB:business_master_new
loadtime:0.30889797210693 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Pablo' limit 1
loadtime:0.30894899368286 / seconds
Query Executed:select id FROM `co` where city='San Pablo' && SIC_code='7219'DB:business_master_new
loadtime:0.30943703651428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanford' limit 1
loadtime:0.30948901176453 / seconds
Query Executed:select id FROM `co` where city='Sanford' && SIC_code='7219'DB:business_master_new
loadtime:0.31028604507446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sargents' limit 1
loadtime:0.31034183502197 / seconds
Query Executed:select id FROM `co` where city='Sargents' && SIC_code='7219'DB:business_master_new
loadtime:0.3108959197998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedalia' limit 1
loadtime:0.31094694137573 / seconds
Query Executed:select id FROM `co` where city='Sedalia' && SIC_code='7219'DB:business_master_new
loadtime:0.31172704696655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedgwick' limit 1
loadtime:0.3117790222168 / seconds
Query Executed:select id FROM `co` where city='Sedgwick' && SIC_code='7219'DB:business_master_new
loadtime:0.31255197525024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seibert' limit 1
loadtime:0.31260395050049 / seconds
Query Executed:select id FROM `co` where city='Seibert' && SIC_code='7219'DB:business_master_new
loadtime:0.31337690353394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Severance' limit 1
loadtime:0.31342887878418 / seconds
Query Executed:select id FROM `co` where city='Severance' && SIC_code='7219'DB:business_master_new
loadtime:0.31418991088867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shawnee' limit 1
loadtime:0.3142409324646 / seconds
Query Executed:select id FROM `co` where city='Shawnee' && SIC_code='7219'DB:business_master_new
loadtime:0.31499886512756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheridan' limit 1
loadtime:0.31505084037781 / seconds
Query Executed:select id FROM `co` where city='Sheridan' && SIC_code='7219'DB:business_master_new
loadtime:0.31582903862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheridan Lake' limit 1
loadtime:0.31588387489319 / seconds
Query Executed:select id FROM `co` where city='Sheridan Lake' && SIC_code='7219'DB:business_master_new
loadtime:0.3166618347168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silt' limit 1
loadtime:0.31671404838562 / seconds
Query Executed:select id FROM `co` where city='Silt' && SIC_code='7219'DB:business_master_new
loadtime:0.31750202178955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Cliff' limit 1
loadtime:0.31755495071411 / seconds
Query Executed:select id FROM `co` where city='Silver Cliff' && SIC_code='7219'DB:business_master_new
loadtime:0.31810593605042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Plume' limit 1
loadtime:0.31815791130066 / seconds
Query Executed:select id FROM `co` where city='Silver Plume' && SIC_code='7219'DB:business_master_new
loadtime:0.31891298294067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silverthorne' limit 1
loadtime:0.31896495819092 / seconds
Query Executed:select id FROM `co` where city='Silverthorne' && SIC_code='7219'DB:business_master_new
loadtime:0.31974482536316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silverton' limit 1
loadtime:0.31979703903198 / seconds
Query Executed:select id FROM `co` where city='Silverton' && SIC_code='7219'DB:business_master_new
loadtime:0.32058382034302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Simla' limit 1
loadtime:0.32063698768616 / seconds
Query Executed:select id FROM `co` where city='Simla' && SIC_code='7219'DB:business_master_new
loadtime:0.32140684127808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Slater' limit 1
loadtime:0.32145881652832 / seconds
Query Executed:select id FROM `co` where city='Slater' && SIC_code='7219'DB:business_master_new
loadtime:0.32221794128418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snowmass' limit 1
loadtime:0.32226896286011 / seconds
Query Executed:select id FROM `co` where city='Snowmass' && SIC_code='7219'DB:business_master_new
loadtime:0.32303881645203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snowmass Village' limit 1
loadtime:0.32309103012085 / seconds
Query Executed:select id FROM `co` where city='Snowmass Village' && SIC_code='7219'DB:business_master_new
loadtime:0.32388186454773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snyder' limit 1
loadtime:0.32393383979797 / seconds
Query Executed:select id FROM `co` where city='Snyder' && SIC_code='7219'DB:business_master_new
loadtime:0.32470488548279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:0.32475686073303 / seconds
Query Executed:select id FROM `co` where city='Somerset' && SIC_code='7219'DB:business_master_new
loadtime:0.3255250453949 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Fork' limit 1
loadtime:0.32557797431946 / seconds
Query Executed:select id FROM `co` where city='South Fork' && SIC_code='7219'DB:business_master_new
loadtime:0.32632994651794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.32638597488403 / seconds
Query Executed:select id FROM `co` where city='Springfield' && SIC_code='7219'DB:business_master_new
loadtime:0.32724285125732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steamboat Spgs' limit 1
loadtime:0.32729601860046 / seconds
Query Executed:select id FROM `co` where city='Steamboat Spgs' && SIC_code='7219'DB:business_master_new
loadtime:0.32807302474976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steamboat Springs' limit 1
loadtime:0.328125 / seconds
Query Executed:select id FROM `co` where city='Steamboat Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.32888984680176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:0.32894086837769 / seconds
Query Executed:select id FROM `co` where city='Sterling' && SIC_code='7219'DB:business_master_new
loadtime:0.32971382141113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoneham' limit 1
loadtime:0.32976698875427 / seconds
Query Executed:select id FROM `co` where city='Stoneham' && SIC_code='7219'DB:business_master_new
loadtime:0.33054399490356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strasburg' limit 1
loadtime:0.33059501647949 / seconds
Query Executed:select id FROM `co` where city='Strasburg' && SIC_code='7219'DB:business_master_new
loadtime:0.33139586448669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratton' limit 1
loadtime:0.33144783973694 / seconds
Query Executed:select id FROM `co` where city='Stratton' && SIC_code='7219'DB:business_master_new
loadtime:0.33222198486328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar City' limit 1
loadtime:0.33227300643921 / seconds
Query Executed:select id FROM `co` where city='Sugar City' && SIC_code='7219'DB:business_master_new
loadtime:0.33301687240601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Superior' limit 1
loadtime:0.33306884765625 / seconds
Query Executed:select id FROM `co` where city='Superior' && SIC_code='7219'DB:business_master_new
loadtime:0.3336009979248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swink' limit 1
loadtime:0.33365297317505 / seconds
Query Executed:select id FROM `co` where city='Swink' && SIC_code='7219'DB:business_master_new
loadtime:0.33440804481506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabernash' limit 1
loadtime:0.33446002006531 / seconds
Query Executed:select id FROM `co` where city='Tabernash' && SIC_code='7219'DB:business_master_new
loadtime:0.33521389961243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Telluride' limit 1
loadtime:0.33526492118835 / seconds
Query Executed:select id FROM `co` where city='Telluride' && SIC_code='7219'DB:business_master_new
loadtime:0.33601498603821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornton' limit 1
loadtime:0.33606696128845 / seconds
Query Executed:select id FROM `co` where city='Thornton' && SIC_code='7219'DB:business_master_new
loadtime:0.33683300018311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timnath' limit 1
loadtime:0.33688497543335 / seconds
Query Executed:select id FROM `co` where city='Timnath' && SIC_code='7219'DB:business_master_new
loadtime:0.33766198158264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toponas' limit 1
loadtime:0.33771395683289 / seconds
Query Executed:select id FROM `co` where city='Toponas' && SIC_code='7219'DB:business_master_new
loadtime:0.3382568359375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Towaoc' limit 1
loadtime:0.33830785751343 / seconds
Query Executed:select id FROM `co` where city='Towaoc' && SIC_code='7219'DB:business_master_new
loadtime:0.3390748500824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Towner' limit 1
loadtime:0.33912801742554 / seconds
Query Executed:select id FROM `co` where city='Towner' && SIC_code='7219'DB:business_master_new
loadtime:0.33958792686462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trinchera' limit 1
loadtime:0.33963894844055 / seconds
Query Executed:select id FROM `co` where city='Trinchera' && SIC_code='7219'DB:business_master_new
loadtime:0.34010601043701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trinidad' limit 1
loadtime:0.34015703201294 / seconds
Query Executed:select id FROM `co` where city='Trinidad' && SIC_code='7219'DB:business_master_new
loadtime:0.3409309387207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twin Lakes' limit 1
loadtime:0.34098386764526 / seconds
Query Executed:select id FROM `co` where city='Twin Lakes' && SIC_code='7219'DB:business_master_new
loadtime:0.34175896644592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Two Buttes' limit 1
loadtime:0.34181094169617 / seconds
Query Executed:select id FROM `co` where city='Two Buttes' && SIC_code='7219'DB:business_master_new
loadtime:0.34257984161377 / seconds
Query loaded from cache:select * from geodata_geocity where city='U S A F Academy' limit 1
loadtime:0.34263181686401 / seconds
Query Executed:select id FROM `co` where city='U S A F Academy' && SIC_code='7219'DB:business_master_new
loadtime:0.3430700302124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Usaf Academy' limit 1
loadtime:0.34312081336975 / seconds
Query Executed:select id FROM `co` where city='Usaf Academy' && SIC_code='7219'DB:business_master_new
loadtime:0.34386897087097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vail' limit 1
loadtime:0.34392094612122 / seconds
Query Executed:select id FROM `co` where city='Vail' && SIC_code='7219'DB:business_master_new
loadtime:0.3446798324585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:0.34473204612732 / seconds
Query Executed:select id FROM `co` where city='Vernon' && SIC_code='7219'DB:business_master_new
loadtime:0.34550094604492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Victor' limit 1
loadtime:0.34555292129517 / seconds
Query Executed:select id FROM `co` where city='Victor' && SIC_code='7219'DB:business_master_new
loadtime:0.34631586074829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vilas' limit 1
loadtime:0.34637188911438 / seconds
Query Executed:select id FROM `co` where city='Vilas' && SIC_code='7219'DB:business_master_new
loadtime:0.34694194793701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villa Grove' limit 1
loadtime:0.34699296951294 / seconds
Query Executed:select id FROM `co` where city='Villa Grove' && SIC_code='7219'DB:business_master_new
loadtime:0.34763288497925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vona' limit 1
loadtime:0.34768486022949 / seconds
Query Executed:select id FROM `co` where city='Vona' && SIC_code='7219'DB:business_master_new
loadtime:0.3483419418335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walden' limit 1
loadtime:0.34839391708374 / seconds
Query Executed:select id FROM `co` where city='Walden' && SIC_code='7219'DB:business_master_new
loadtime:0.34915900230408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walsenburg' limit 1
loadtime:0.34921884536743 / seconds
Query Executed:select id FROM `co` where city='Walsenburg' && SIC_code='7219'DB:business_master_new
loadtime:0.34998202323914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walsh' limit 1
loadtime:0.3500349521637 / seconds
Query Executed:select id FROM `co` where city='Walsh' && SIC_code='7219'DB:business_master_new
loadtime:0.35080599784851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ward' limit 1
loadtime:0.35085797309875 / seconds
Query Executed:select id FROM `co` where city='Ward' && SIC_code='7219'DB:business_master_new
loadtime:0.35163187980652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watkins' limit 1
loadtime:0.35168504714966 / seconds
Query Executed:select id FROM `co` where city='Watkins' && SIC_code='7219'DB:business_master_new
loadtime:0.35246992111206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weldona' limit 1
loadtime:0.3525218963623 / seconds
Query Executed:select id FROM `co` where city='Weldona' && SIC_code='7219'DB:business_master_new
loadtime:0.35329699516296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellington' limit 1
loadtime:0.35335397720337 / seconds
Query Executed:select id FROM `co` where city='Wellington' && SIC_code='7219'DB:business_master_new
loadtime:0.35412383079529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westcliffe' limit 1
loadtime:0.35418295860291 / seconds
Query Executed:select id FROM `co` where city='Westcliffe' && SIC_code='7219'DB:business_master_new
loadtime:0.35497999191284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:0.35503196716309 / seconds
Query Executed:select id FROM `co` where city='Westminster' && SIC_code='7219'DB:business_master_new
loadtime:0.35582900047302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:0.35588192939758 / seconds
Query Executed:select id FROM `co` where city='Weston' && SIC_code='7219'DB:business_master_new
loadtime:0.3566689491272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wetmore' limit 1
loadtime:0.35672092437744 / seconds
Query Executed:select id FROM `co` where city='Wetmore' && SIC_code='7219'DB:business_master_new
loadtime:0.35749888420105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheat Ridge' limit 1
loadtime:0.35755181312561 / seconds
Query Executed:select id FROM `co` where city='Wheat Ridge' && SIC_code='7219'DB:business_master_new
loadtime:0.35833787918091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitewater' limit 1
loadtime:0.35839104652405 / seconds
Query Executed:select id FROM `co` where city='Whitewater' && SIC_code='7219'DB:business_master_new
loadtime:0.35918688774109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wiggins' limit 1
loadtime:0.35923790931702 / seconds
Query Executed:select id FROM `co` where city='Wiggins' && SIC_code='7219'DB:business_master_new
loadtime:0.3600058555603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wild Horse' limit 1
loadtime:0.36005783081055 / seconds
Query Executed:select id FROM `co` where city='Wild Horse' && SIC_code='7219'DB:business_master_new
loadtime:0.36057686805725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wiley' limit 1
loadtime:0.36063003540039 / seconds
Query Executed:select id FROM `co` where city='Wiley' && SIC_code='7219'DB:business_master_new
loadtime:0.36141991615295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:0.3614718914032 / seconds
Query Executed:select id FROM `co` where city='Windsor' && SIC_code='7219'DB:business_master_new
loadtime:0.36225295066833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winter Park' limit 1
loadtime:0.3623058795929 / seconds
Query Executed:select id FROM `co` where city='Winter Park' && SIC_code='7219'DB:business_master_new
loadtime:0.36307287216187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolcott' limit 1
loadtime:0.363126039505 / seconds
Query Executed:select id FROM `co` where city='Wolcott' && SIC_code='7219'DB:business_master_new
loadtime:0.36388683319092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland Park' limit 1
loadtime:0.36393904685974 / seconds
Query Executed:select id FROM `co` where city='Woodland Park' && SIC_code='7219'DB:business_master_new
loadtime:0.3647038936615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodrow' limit 1
loadtime:0.36475586891174 / seconds
Query Executed:select id FROM `co` where city='Woodrow' && SIC_code='7219'DB:business_master_new
loadtime:0.36552095413208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woody Creek' limit 1
loadtime:0.36557292938232 / seconds
Query Executed:select id FROM `co` where city='Woody Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.36632990837097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wray' limit 1
loadtime:0.36638498306274 / seconds
Query Executed:select id FROM `co` where city='Wray' && SIC_code='7219'DB:business_master_new
loadtime:0.36714386940002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yampa' limit 1
loadtime:0.36720395088196 / seconds
Query Executed:select id FROM `co` where city='Yampa' && SIC_code='7219'DB:business_master_new
loadtime:0.36797094345093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yellow Jacket' limit 1
loadtime:0.36802291870117 / seconds
Query Executed:select id FROM `co` where city='Yellow Jacket' && SIC_code='7219'DB:business_master_new
loadtime:0.36878681182861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yoder' limit 1
loadtime:0.36883687973022 / seconds
Query Executed:select id FROM `co` where city='Yoder' && SIC_code='7219'DB:business_master_new
loadtime:0.36960887908936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yuma' limit 1
loadtime:0.3696608543396 / seconds
Query Executed:select id FROM `co` where city='Yuma' && SIC_code='7219'DB:business_master_new
loadtime:0.3704469203949 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.37058997154236 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.37099385261536 / seconds
Operation template executed (chunk cache operation)
loadtime:0.37114882469177 / seconds
template override:Default
loadtime:0.3712010383606 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:0.37251091003418 / seconds
Template Constructed, Array Rows:49
loadtime:0.37302303314209 / seconds
TOTAL EXECUTION TIME: 0.3726
loadtime:0.37413787841797 / 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] => laundry-and-garment-services-nec [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:0.37414789199829
TOTAL KEY ARRAYS: 69