DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:9.7036361694336E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00088405609130859 / seconds
host not found setting manual db connection
loadtime:0.0016191005706787 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0021600723266602 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0024209022521973 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0025479793548584 / seconds
zipcode:
loadtime:0.0025908946990967 / seconds
Query Executed:select * from search_referrer where page_hash='4502a2787c2de7dd9f4e13d5c5dabc00' limit 10 DB:ezrox_toadli
loadtime:0.0031111240386963 / seconds
Operation header executed (non global)
loadtime:0.0031290054321289 / seconds
Operation leaderboard executed (non global)
loadtime:0.003169059753418 / seconds
Operation square executed (non global)
loadtime:0.0031840801239014 / seconds
Operation square_bottom executed (non global)
loadtime:0.0031960010528564 / seconds
Operation smallsquare executed (non global)
loadtime:0.0032069683074951 / seconds
Operation headeradright executed (non global)
loadtime:0.0032179355621338 / seconds
Operation google_analytics executed (non global)
loadtime:0.0032289028167725 / seconds
Operation topstories executed (non global)
loadtime:0.0032401084899902 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0032520294189453 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0032620429992676 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.003803014755249 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0041379928588867 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0041780471801758 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0042400360107422 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0042760372161865 / seconds
Template key: archive_menu pushed
loadtime:0.0042810440063477 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0042870044708252 / seconds
Template key: get_gravatar pushed
loadtime:0.0042910575866699 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0042960643768311 / seconds
*10)-10)+1 | start:0
loadtime:0.0043330192565918 / seconds
Query loaded from cache:select * from categories where cat_URLid='laundry-and-garment-services-nec'
loadtime:0.004410982131958 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='colorado'
loadtime:0.0045011043548584 / seconds
DB connected to localhost business_master_new
loadtime:0.0051000118255615 / seconds
Query Executed:select * from `co_catmap` where sic='7219' order by city ascDB:business_master_new
loadtime:0.10023403167725 / seconds
Query stored in cache : _QUERY_www.toadli.com57857d00c74af99367d105cbb9747dd1
loadtime:0.10099291801453 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='colorado'
loadtime:0.10104990005493 / seconds
Query Executed:select sum(totalcount) as totalsum from `co_catmap` where sic='7219'DB:business_master_new
loadtime:0.1035590171814 / seconds
Query stored in cache : _QUERY_www.toadli.com665dfdf2fab20aad4a3945cca2f4b9be
loadtime:0.10358500480652 / seconds
438 / 11
loadtime:0.10362195968628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agate' limit 1
loadtime:0.10367488861084 / seconds
Query Executed:select id FROM `co` where city='Agate' && SIC_code='7219'DB:business_master_new
loadtime:0.11607694625854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aguilar' limit 1
loadtime:0.11613011360168 / seconds
Query Executed:select id FROM `co` where city='Aguilar' && SIC_code='7219'DB:business_master_new
loadtime:0.11669492721558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Akron' limit 1
loadtime:0.11673903465271 / seconds
Query Executed:select id FROM `co` where city='Akron' && SIC_code='7219'DB:business_master_new
loadtime:0.11727094650269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alamosa' limit 1
loadtime:0.11731004714966 / seconds
Query Executed:select id FROM `co` where city='Alamosa' && SIC_code='7219'DB:business_master_new
loadtime:0.11785507202148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allenspark' limit 1
loadtime:0.11789703369141 / seconds
Query Executed:select id FROM `co` where city='Allenspark' && SIC_code='7219'DB:business_master_new
loadtime:0.11846590042114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alma' limit 1
loadtime:0.1185131072998 / seconds
Query Executed:select id FROM `co` where city='Alma' && SIC_code='7219'DB:business_master_new
loadtime:0.11905789375305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Almont' limit 1
loadtime:0.11911106109619 / seconds
Query Executed:select id FROM `co` where city='Almont' && SIC_code='7219'DB:business_master_new
loadtime:0.12845301628113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.12858605384827 / seconds
Query Executed:select id FROM `co` where city='Amherst' && SIC_code='7219'DB:business_master_new
loadtime:0.12961006164551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anton' limit 1
loadtime:0.12965297698975 / seconds
Query Executed:select id FROM `co` where city='Anton' && SIC_code='7219'DB:business_master_new
loadtime:0.13017892837524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Antonito' limit 1
loadtime:0.13020610809326 / seconds
Query Executed:select id FROM `co` where city='Antonito' && SIC_code='7219'DB:business_master_new
loadtime:0.13074207305908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arapahoe' limit 1
loadtime:0.13079500198364 / seconds
Query Executed:select id FROM `co` where city='Arapahoe' && SIC_code='7219'DB:business_master_new
loadtime:0.13132500648499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arboles' limit 1
loadtime:0.13184189796448 / seconds
Query Executed:select id FROM `co` where city='Arboles' && SIC_code='7219'DB:business_master_new
loadtime:0.13299608230591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.13304996490479 / seconds
Query Executed:select id FROM `co` where city='Arlington' && SIC_code='7219'DB:business_master_new
loadtime:0.13424396514893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arriba' limit 1
loadtime:0.13429498672485 / seconds
Query Executed:select id FROM `co` where city='Arriba' && SIC_code='7219'DB:business_master_new
loadtime:0.13555598258972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arvada' limit 1
loadtime:0.13560509681702 / seconds
Query Executed:select id FROM `co` where city='Arvada' && SIC_code='7219'DB:business_master_new
loadtime:0.13715791702271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aspen' limit 1
loadtime:0.13728594779968 / seconds
Query Executed:select id FROM `co` where city='Aspen' && SIC_code='7219'DB:business_master_new
loadtime:0.13853311538696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atwood' limit 1
loadtime:0.13866710662842 / seconds
Query Executed:select id FROM `co` where city='Atwood' && SIC_code='7219'DB:business_master_new
loadtime:0.13957595825195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ault' limit 1
loadtime:0.13961696624756 / seconds
Query Executed:select id FROM `co` where city='Ault' && SIC_code='7219'DB:business_master_new
loadtime:0.14112091064453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.14124989509583 / seconds
Query Executed:select id FROM `co` where city='Aurora' && SIC_code='7219'DB:business_master_new
loadtime:0.1427481174469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Austin' limit 1
loadtime:0.14286398887634 / seconds
Query Executed:select id FROM `co` where city='Austin' && SIC_code='7219'DB:business_master_new
loadtime:0.14401698112488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.14420008659363 / seconds
Query Executed:select id FROM `co` where city='Avon' && SIC_code='7219'DB:business_master_new
loadtime:0.14568996429443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avondale' limit 1
loadtime:0.14583206176758 / seconds
Query Executed:select id FROM `co` where city='Avondale' && SIC_code='7219'DB:business_master_new
loadtime:0.14736199378967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bailey' limit 1
loadtime:0.14747190475464 / seconds
Query Executed:select id FROM `co` where city='Bailey' && SIC_code='7219'DB:business_master_new
loadtime:0.14874196052551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Basalt' limit 1
loadtime:0.14885807037354 / seconds
Query Executed:select id FROM `co` where city='Basalt' && SIC_code='7219'DB:business_master_new
loadtime:0.15042090415955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Battlement Mesa' limit 1
loadtime:0.1505560874939 / seconds
Query Executed:select id FROM `co` where city='Battlement Mesa' && SIC_code='7219'DB:business_master_new
loadtime:0.15769004821777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayfield' limit 1
loadtime:0.15782809257507 / seconds
Query Executed:select id FROM `co` where city='Bayfield' && SIC_code='7219'DB:business_master_new
loadtime:0.15944600105286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedrock' limit 1
loadtime:0.15948796272278 / seconds
Query Executed:select id FROM `co` where city='Bedrock' && SIC_code='7219'DB:business_master_new
loadtime:0.16155195236206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellvue' limit 1
loadtime:0.16160202026367 / seconds
Query Executed:select id FROM `co` where city='Bellvue' && SIC_code='7219'DB:business_master_new
loadtime:0.16308689117432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennett' limit 1
loadtime:0.16323900222778 / seconds
Query Executed:select id FROM `co` where city='Bennett' && SIC_code='7219'DB:business_master_new
loadtime:0.16483998298645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berthoud' limit 1
loadtime:0.16495704650879 / seconds
Query Executed:select id FROM `co` where city='Berthoud' && SIC_code='7219'DB:business_master_new
loadtime:0.16649889945984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethune' limit 1
loadtime:0.16664004325867 / seconds
Query Executed:select id FROM `co` where city='Bethune' && SIC_code='7219'DB:business_master_new
loadtime:0.17658591270447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beulah' limit 1
loadtime:0.17663908004761 / seconds
Query Executed:select id FROM `co` where city='Beulah' && SIC_code='7219'DB:business_master_new
loadtime:0.1771879196167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Hawk' limit 1
loadtime:0.17723298072815 / seconds
Query Executed:select id FROM `co` where city='Black Hawk' && SIC_code='7219'DB:business_master_new
loadtime:0.17778706550598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanca' limit 1
loadtime:0.17782998085022 / seconds
Query Executed:select id FROM `co` where city='Blanca' && SIC_code='7219'DB:business_master_new
loadtime:0.17839598655701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boncarbo' limit 1
loadtime:0.17844700813293 / seconds
Query Executed:select id FROM `co` where city='Boncarbo' && SIC_code='7219'DB:business_master_new
loadtime:0.18112301826477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bond' limit 1
loadtime:0.18117189407349 / seconds
Query Executed:select id FROM `co` where city='Bond' && SIC_code='7219'DB:business_master_new
loadtime:0.18637800216675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boone' limit 1
loadtime:0.18647408485413 / seconds
Query Executed:select id FROM `co` where city='Boone' && SIC_code='7219'DB:business_master_new
loadtime:0.18769598007202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boulder' limit 1
loadtime:0.18784403800964 / seconds
Query Executed:select id FROM `co` where city='Boulder' && SIC_code='7219'DB:business_master_new
loadtime:0.18894505500793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.18909406661987 / seconds
Query Executed:select id FROM `co` where city='Brandon' && SIC_code='7219'DB:business_master_new
loadtime:0.19025802612305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branson' limit 1
loadtime:0.19030690193176 / seconds
Query Executed:select id FROM `co` where city='Branson' && SIC_code='7219'DB:business_master_new
loadtime:0.19323205947876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Breckenridge' limit 1
loadtime:0.19327402114868 / seconds
Query Executed:select id FROM `co` where city='Breckenridge' && SIC_code='7219'DB:business_master_new
loadtime:0.19471001625061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Briggsdale' limit 1
loadtime:0.19484901428223 / seconds
Query Executed:select id FROM `co` where city='Briggsdale' && SIC_code='7219'DB:business_master_new
loadtime:0.19644093513489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:0.19657206535339 / seconds
Query Executed:select id FROM `co` where city='Brighton' && SIC_code='7219'DB:business_master_new
loadtime:0.1981189250946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.19825410842896 / seconds
Query Executed:select id FROM `co` where city='Bristol' && SIC_code='7219'DB:business_master_new
loadtime:0.20012807846069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broomfield' limit 1
loadtime:0.20017099380493 / seconds
Query Executed:select id FROM `co` where city='Broomfield' && SIC_code='7219'DB:business_master_new
loadtime:0.20158910751343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brush' limit 1
loadtime:0.20175290107727 / seconds
Query Executed:select id FROM `co` where city='Brush' && SIC_code='7219'DB:business_master_new
loadtime:0.2033360004425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buena Vista' limit 1
loadtime:0.2034809589386 / seconds
Query Executed:select id FROM `co` where city='Buena Vista' && SIC_code='7219'DB:business_master_new
loadtime:0.20511293411255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Creek' limit 1
loadtime:0.20525193214417 / seconds
Query Executed:select id FROM `co` where city='Buffalo Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.21205997467041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.21219706535339 / seconds
Query Executed:select id FROM `co` where city='Burlington' && SIC_code='7219'DB:business_master_new
loadtime:0.21378207206726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burns' limit 1
loadtime:0.21391606330872 / seconds
Query Executed:select id FROM `co` where city='Burns' && SIC_code='7219'DB:business_master_new
loadtime:0.21690392494202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byers' limit 1
loadtime:0.2170889377594 / seconds
Query Executed:select id FROM `co` where city='Byers' && SIC_code='7219'DB:business_master_new
loadtime:0.21862411499023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cahone' limit 1
loadtime:0.21873998641968 / seconds
Query Executed:select id FROM `co` where city='Cahone' && SIC_code='7219'DB:business_master_new
loadtime:0.22651100158691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calhan' limit 1
loadtime:0.22656202316284 / seconds
Query Executed:select id FROM `co` where city='Calhan' && SIC_code='7219'DB:business_master_new
loadtime:0.22749900817871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Campo' limit 1
loadtime:0.22760701179504 / seconds
Query Executed:select id FROM `co` where city='Campo' && SIC_code='7219'DB:business_master_new
loadtime:0.22859001159668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canon City' limit 1
loadtime:0.22865104675293 / seconds
Query Executed:select id FROM `co` where city='Canon City' && SIC_code='7219'DB:business_master_new
loadtime:0.22966003417969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capulin' limit 1
loadtime:0.22971200942993 / seconds
Query Executed:select id FROM `co` where city='Capulin' && SIC_code='7219'DB:business_master_new
loadtime:0.23259592056274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carbondale' limit 1
loadtime:0.23264288902283 / seconds
Query Executed:select id FROM `co` where city='Carbondale' && SIC_code='7219'DB:business_master_new
loadtime:0.23384308815002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carr' limit 1
loadtime:0.23388600349426 / seconds
Query Executed:select id FROM `co` where city='Carr' && SIC_code='7219'DB:business_master_new
loadtime:0.24092793464661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascade' limit 1
loadtime:0.24109601974487 / seconds
Query Executed:select id FROM `co` where city='Cascade' && SIC_code='7219'DB:business_master_new
loadtime:0.242271900177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castle Rock' limit 1
loadtime:0.24241399765015 / seconds
Query Executed:select id FROM `co` where city='Castle Rock' && SIC_code='7219'DB:business_master_new
loadtime:0.24346590042114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedaredge' limit 1
loadtime:0.24360299110413 / seconds
Query Executed:select id FROM `co` where city='Cedaredge' && SIC_code='7219'DB:business_master_new
loadtime:0.24483203887939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centennial' limit 1
loadtime:0.24496603012085 / seconds
Query Executed:select id FROM `co` where city='Centennial' && SIC_code='7219'DB:business_master_new
loadtime:0.24602389335632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center' limit 1
loadtime:0.24619793891907 / seconds
Query Executed:select id FROM `co` where city='Center' && SIC_code='7219'DB:business_master_new
loadtime:0.2472870349884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central City' limit 1
loadtime:0.24743890762329 / seconds
Query Executed:select id FROM `co` where city='Central City' && SIC_code='7219'DB:business_master_new
loadtime:0.24825692176819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chama' limit 1
loadtime:0.24837112426758 / seconds
Query Executed:select id FROM `co` where city='Chama' && SIC_code='7219'DB:business_master_new
loadtime:0.25019407272339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheraw' limit 1
loadtime:0.25024509429932 / seconds
Query Executed:select id FROM `co` where city='Cheraw' && SIC_code='7219'DB:business_master_new
loadtime:0.25719404220581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Hills Vlg' limit 1
loadtime:0.25733995437622 / seconds
Query Executed:select id FROM `co` where city='Cherry Hills Vlg' && SIC_code='7219'DB:business_master_new
loadtime:0.2586829662323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheyenne Wells' limit 1
loadtime:0.25872611999512 / seconds
Query Executed:select id FROM `co` where city='Cheyenne Wells' && SIC_code='7219'DB:business_master_new
loadtime:0.25957608222961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chimney Rock' limit 1
loadtime:0.25965905189514 / seconds
Query Executed:select id FROM `co` where city='Chimney Rock' && SIC_code='7219'DB:business_master_new
loadtime:0.26400899887085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chromo' limit 1
loadtime:0.26414203643799 / seconds
Query Executed:select id FROM `co` where city='Chromo' && SIC_code='7219'DB:business_master_new
loadtime:0.27062892913818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cimarron' limit 1
loadtime:0.27067804336548 / seconds
Query Executed:select id FROM `co` where city='Cimarron' && SIC_code='7219'DB:business_master_new
loadtime:0.27627611160278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clark' limit 1
loadtime:0.27633309364319 / seconds
Query Executed:select id FROM `co` where city='Clark' && SIC_code='7219'DB:business_master_new
loadtime:0.27688908576965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:0.27693200111389 / seconds
Query Executed:select id FROM `co` where city='Clifton' && SIC_code='7219'DB:business_master_new
loadtime:0.27749300003052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Climax' limit 1
loadtime:0.27753400802612 / seconds
Query Executed:select id FROM `co` where city='Climax' && SIC_code='7219'DB:business_master_new
loadtime:0.27806496620178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coal Creek' limit 1
loadtime:0.27811408042908 / seconds
Query Executed:select id FROM `co` where city='Coal Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.27958393096924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coaldale' limit 1
loadtime:0.27963495254517 / seconds
Query Executed:select id FROM `co` where city='Coaldale' && SIC_code='7219'DB:business_master_new
loadtime:0.28353095054626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coalmont' limit 1
loadtime:0.28358101844788 / seconds
Query Executed:select id FROM `co` where city='Coalmont' && SIC_code='7219'DB:business_master_new
loadtime:0.28622388839722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collbran' limit 1
loadtime:0.28626489639282 / seconds
Query Executed:select id FROM `co` where city='Collbran' && SIC_code='7219'DB:business_master_new
loadtime:0.2868070602417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colorado City' limit 1
loadtime:0.28685688972473 / seconds
Query Executed:select id FROM `co` where city='Colorado City' && SIC_code='7219'DB:business_master_new
loadtime:0.28742003440857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colorado Springs' limit 1
loadtime:0.28746199607849 / seconds
Query Executed:select id FROM `co` where city='Colorado Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.28804612159729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbine Valley' limit 1
loadtime:0.28812193870544 / seconds
Query Executed:select id FROM `co` where city='Columbine Valley' && SIC_code='7219'DB:business_master_new
loadtime:0.28868007659912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Commerce City' limit 1
loadtime:0.28872299194336 / seconds
Query Executed:select id FROM `co` where city='Commerce City' && SIC_code='7219'DB:business_master_new
loadtime:0.28925490379333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Como' limit 1
loadtime:0.2893009185791 / seconds
Query Executed:select id FROM `co` where city='Como' && SIC_code='7219'DB:business_master_new
loadtime:0.29366397857666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conejos' limit 1
loadtime:0.2937159538269 / seconds
Query Executed:select id FROM `co` where city='Conejos' && SIC_code='7219'DB:business_master_new
loadtime:0.30111908912659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conifer' limit 1
loadtime:0.30115509033203 / seconds
Query Executed:select id FROM `co` where city='Conifer' && SIC_code='7219'DB:business_master_new
loadtime:0.30258798599243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cope' limit 1
loadtime:0.30272698402405 / seconds
Query Executed:select id FROM `co` where city='Cope' && SIC_code='7219'DB:business_master_new
loadtime:0.30391502380371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copper Mountain' limit 1
loadtime:0.30399107933044 / seconds
Query Executed:select id FROM `co` where city='Copper Mountain' && SIC_code='7219'DB:business_master_new
loadtime:0.30564594268799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cortez' limit 1
loadtime:0.30568909645081 / seconds
Query Executed:select id FROM `co` where city='Cortez' && SIC_code='7219'DB:business_master_new
loadtime:0.3062469959259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cory' limit 1
loadtime:0.30628800392151 / seconds
Query Executed:select id FROM `co` where city='Cory' && SIC_code='7219'DB:business_master_new
loadtime:0.31095910072327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cotopaxi' limit 1
loadtime:0.31101202964783 / seconds
Query Executed:select id FROM `co` where city='Cotopaxi' && SIC_code='7219'DB:business_master_new
loadtime:0.31159400939941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cowdrey' limit 1
loadtime:0.31163692474365 / seconds
Query Executed:select id FROM `co` where city='Cowdrey' && SIC_code='7219'DB:business_master_new
loadtime:0.3136739730835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cpu Louis Guzzo Ent' limit 1
loadtime:0.31373405456543 / seconds
Query Executed:select id FROM `co` where city='Cpu Louis Guzzo Ent' && SIC_code='7219'DB:business_master_new
loadtime:0.31427597999573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craig' limit 1
loadtime:0.31431603431702 / seconds
Query Executed:select id FROM `co` where city='Craig' && SIC_code='7219'DB:business_master_new
loadtime:0.3156099319458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crawford' limit 1
loadtime:0.31574702262878 / seconds
Query Executed:select id FROM `co` where city='Crawford' && SIC_code='7219'DB:business_master_new
loadtime:0.31714296340942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creede' limit 1
loadtime:0.31717896461487 / seconds
Query Executed:select id FROM `co` where city='Creede' && SIC_code='7219'DB:business_master_new
loadtime:0.31812310218811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crested Butte' limit 1
loadtime:0.31817197799683 / seconds
Query Executed:select id FROM `co` where city='Crested Butte' && SIC_code='7219'DB:business_master_new
loadtime:0.31920003890991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crestone' limit 1
loadtime:0.31931591033936 / seconds
Query Executed:select id FROM `co` where city='Crestone' && SIC_code='7219'DB:business_master_new
loadtime:0.32053899765015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cripple Creek' limit 1
loadtime:0.32068109512329 / seconds
Query Executed:select id FROM `co` where city='Cripple Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.32224607467651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crook' limit 1
loadtime:0.32239007949829 / seconds
Query Executed:select id FROM `co` where city='Crook' && SIC_code='7219'DB:business_master_new
loadtime:0.3236289024353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crowley' limit 1
loadtime:0.32370710372925 / seconds
Query Executed:select id FROM `co` where city='Crowley' && SIC_code='7219'DB:business_master_new
loadtime:0.32842302322388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dacono' limit 1
loadtime:0.32847690582275 / seconds
Query Executed:select id FROM `co` where city='Dacono' && SIC_code='7219'DB:business_master_new
loadtime:0.32989406585693 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Beque' limit 1
loadtime:0.32999205589294 / seconds
Query Executed:select id FROM `co` where city='De Beque' && SIC_code='7219'DB:business_master_new
loadtime:0.33148097991943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deckers' limit 1
loadtime:0.33153295516968 / seconds
Query Executed:select id FROM `co` where city='Deckers' && SIC_code='7219'DB:business_master_new
loadtime:0.33266496658325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deer Trail' limit 1
loadtime:0.3327009677887 / seconds
Query Executed:select id FROM `co` where city='Deer Trail' && SIC_code='7219'DB:business_master_new
loadtime:0.33415007591248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Del Norte' limit 1
loadtime:0.33429193496704 / seconds
Query Executed:select id FROM `co` where city='Del Norte' && SIC_code='7219'DB:business_master_new
loadtime:0.33563494682312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delta' limit 1
loadtime:0.33574604988098 / seconds
Query Executed:select id FROM `co` where city='Delta' && SIC_code='7219'DB:business_master_new
loadtime:0.33731603622437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denver' limit 1
loadtime:0.33746004104614 / seconds
Query Executed:select id FROM `co` where city='Denver' && SIC_code='7219'DB:business_master_new
loadtime:0.33861589431763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dillon' limit 1
loadtime:0.33878993988037 / seconds
Query Executed:select id FROM `co` where city='Dillon' && SIC_code='7219'DB:business_master_new
loadtime:0.33967804908752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dinosaur' limit 1
loadtime:0.33981895446777 / seconds
Query Executed:select id FROM `co` where city='Dinosaur' && SIC_code='7219'DB:business_master_new
loadtime:0.34133505821228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Divide' limit 1
loadtime:0.34146809577942 / seconds
Query Executed:select id FROM `co` where city='Divide' && SIC_code='7219'DB:business_master_new
loadtime:0.34299111366272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolores' limit 1
loadtime:0.34316396713257 / seconds
Query Executed:select id FROM `co` where city='Dolores' && SIC_code='7219'DB:business_master_new
loadtime:0.3443078994751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dove Creek' limit 1
loadtime:0.3444230556488 / seconds
Query Executed:select id FROM `co` where city='Dove Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.3459529876709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drake' limit 1
loadtime:0.34611701965332 / seconds
Query Executed:select id FROM `co` where city='Drake' && SIC_code='7219'DB:business_master_new
loadtime:0.34764409065247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dumont' limit 1
loadtime:0.34778594970703 / seconds
Query Executed:select id FROM `co` where city='Dumont' && SIC_code='7219'DB:business_master_new
loadtime:0.34930610656738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dupont' limit 1
loadtime:0.34944605827332 / seconds
Query Executed:select id FROM `co` where city='Dupont' && SIC_code='7219'DB:business_master_new
loadtime:0.35640001296997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durango' limit 1
loadtime:0.35654401779175 / seconds
Query Executed:select id FROM `co` where city='Durango' && SIC_code='7219'DB:business_master_new
loadtime:0.35830402374268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eads' limit 1
loadtime:0.35834908485413 / seconds
Query Executed:select id FROM `co` where city='Eads' && SIC_code='7219'DB:business_master_new
loadtime:0.35962796211243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle' limit 1
loadtime:0.35968089103699 / seconds
Query Executed:select id FROM `co` where city='Eagle' && SIC_code='7219'DB:business_master_new
loadtime:0.36134099960327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastlake' limit 1
loadtime:0.36147403717041 / seconds
Query Executed:select id FROM `co` where city='Eastlake' && SIC_code='7219'DB:business_master_new
loadtime:0.36317110061646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eaton' limit 1
loadtime:0.36330509185791 / seconds
Query Executed:select id FROM `co` where city='Eaton' && SIC_code='7219'DB:business_master_new
loadtime:0.36491990089417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eckert' limit 1
loadtime:0.36509895324707 / seconds
Query Executed:select id FROM `co` where city='Eckert' && SIC_code='7219'DB:business_master_new
loadtime:0.36662006378174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eckley' limit 1
loadtime:0.36671590805054 / seconds
Query Executed:select id FROM `co` where city='Eckley' && SIC_code='7219'DB:business_master_new
loadtime:0.37624597549438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewater' limit 1
loadtime:0.37630105018616 / seconds
Query Executed:select id FROM `co` where city='Edgewater' && SIC_code='7219'DB:business_master_new
loadtime:0.37687802314758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edwards' limit 1
loadtime:0.37692093849182 / seconds
Query Executed:select id FROM `co` where city='Edwards' && SIC_code='7219'DB:business_master_new
loadtime:0.37749004364014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Egnar' limit 1
loadtime:0.37754511833191 / seconds
Query Executed:select id FROM `co` where city='Egnar' && SIC_code='7219'DB:business_master_new
loadtime:0.3797869682312 / seconds
Query loaded from cache:select * from geodata_geocity where city='El Jebel' limit 1
loadtime:0.3798360824585 / seconds
Query Executed:select id FROM `co` where city='El Jebel' && SIC_code='7219'DB:business_master_new
loadtime:0.38355588912964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elbert' limit 1
loadtime:0.38359808921814 / seconds
Query Executed:select id FROM `co` where city='Elbert' && SIC_code='7219'DB:business_master_new
loadtime:0.38473510742188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldorado Springs' limit 1
loadtime:0.38487195968628 / seconds
Query Executed:select id FROM `co` where city='Eldorado Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.39225006103516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elizabeth' limit 1
loadtime:0.39229702949524 / seconds
Query Executed:select id FROM `co` where city='Elizabeth' && SIC_code='7219'DB:business_master_new
loadtime:0.39377999305725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Empire' limit 1
loadtime:0.39392399787903 / seconds
Query Executed:select id FROM `co` where city='Empire' && SIC_code='7219'DB:business_master_new
loadtime:0.39545798301697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Englewood' limit 1
loadtime:0.3954930305481 / seconds
Query Executed:select id FROM `co` where city='Englewood' && SIC_code='7219'DB:business_master_new
loadtime:0.39679408073425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erie' limit 1
loadtime:0.3969259262085 / seconds
Query Executed:select id FROM `co` where city='Erie' && SIC_code='7219'DB:business_master_new
loadtime:0.39845705032349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estes Park' limit 1
loadtime:0.39857792854309 / seconds
Query Executed:select id FROM `co` where city='Estes Park' && SIC_code='7219'DB:business_master_new
loadtime:0.40016198158264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evans' limit 1
loadtime:0.40030312538147 / seconds
Query Executed:select id FROM `co` where city='Evans' && SIC_code='7219'DB:business_master_new
loadtime:0.4019660949707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evergreen' limit 1
loadtime:0.4021430015564 / seconds
Query Executed:select id FROM `co` where city='Evergreen' && SIC_code='7219'DB:business_master_new
loadtime:0.40374398231506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairplay' limit 1
loadtime:0.4039089679718 / seconds
Query Executed:select id FROM `co` where city='Fairplay' && SIC_code='7219'DB:business_master_new
loadtime:0.40550208091736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Federal Heights' limit 1
loadtime:0.40562009811401 / seconds
Query Executed:select id FROM `co` where city='Federal Heights' && SIC_code='7219'DB:business_master_new
loadtime:0.40805006027222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Firestone' limit 1
loadtime:0.40810298919678 / seconds
Query Executed:select id FROM `co` where city='Firestone' && SIC_code='7219'DB:business_master_new
loadtime:0.40968608856201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flagler' limit 1
loadtime:0.40978598594666 / seconds
Query Executed:select id FROM `co` where city='Flagler' && SIC_code='7219'DB:business_master_new
loadtime:0.41136789321899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fleming' limit 1
loadtime:0.41152596473694 / seconds
Query Executed:select id FROM `co` where city='Fleming' && SIC_code='7219'DB:business_master_new
loadtime:0.41317510604858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.41331005096436 / seconds
Query Executed:select id FROM `co` where city='Florence' && SIC_code='7219'DB:business_master_new
loadtime:0.41479897499084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florissant' limit 1
loadtime:0.41484904289246 / seconds
Query Executed:select id FROM `co` where city='Florissant' && SIC_code='7219'DB:business_master_new
loadtime:0.41554808616638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Carson' limit 1
loadtime:0.41560101509094 / seconds
Query Executed:select id FROM `co` where city='Fort Carson' && SIC_code='7219'DB:business_master_new
loadtime:0.41709899902344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Collins' limit 1
loadtime:0.41721200942993 / seconds
Query Executed:select id FROM `co` where city='Fort Collins' && SIC_code='7219'DB:business_master_new
loadtime:0.41826605796814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Garland' limit 1
loadtime:0.41842889785767 / seconds
Query Executed:select id FROM `co` where city='Fort Garland' && SIC_code='7219'DB:business_master_new
loadtime:0.41972398757935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Lupton' limit 1
loadtime:0.41986703872681 / seconds
Query Executed:select id FROM `co` where city='Fort Lupton' && SIC_code='7219'DB:business_master_new
loadtime:0.4214129447937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Lyon' limit 1
loadtime:0.42151093482971 / seconds
Query Executed:select id FROM `co` where city='Fort Lyon' && SIC_code='7219'DB:business_master_new
loadtime:0.42511796951294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Morgan' limit 1
loadtime:0.42516994476318 / seconds
Query Executed:select id FROM `co` where city='Fort Morgan' && SIC_code='7219'DB:business_master_new
loadtime:0.42665004730225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain' limit 1
loadtime:0.42676901817322 / seconds
Query Executed:select id FROM `co` where city='Fountain' && SIC_code='7219'DB:business_master_new
loadtime:0.4279990196228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fowler' limit 1
loadtime:0.4281690120697 / seconds
Query Executed:select id FROM `co` where city='Fowler' && SIC_code='7219'DB:business_master_new
loadtime:0.42968392372131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franktown' limit 1
loadtime:0.42981791496277 / seconds
Query Executed:select id FROM `co` where city='Franktown' && SIC_code='7219'DB:business_master_new
loadtime:0.43143105506897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fraser' limit 1
loadtime:0.43147611618042 / seconds
Query Executed:select id FROM `co` where city='Fraser' && SIC_code='7219'DB:business_master_new
loadtime:0.43256711959839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frederick' limit 1
loadtime:0.43261504173279 / seconds
Query Executed:select id FROM `co` where city='Frederick' && SIC_code='7219'DB:business_master_new
loadtime:0.43339800834656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frisco' limit 1
loadtime:0.43345403671265 / seconds
Query Executed:select id FROM `co` where city='Frisco' && SIC_code='7219'DB:business_master_new
loadtime:0.43496799468994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruita' limit 1
loadtime:0.43512105941772 / seconds
Query Executed:select id FROM `co` where city='Fruita' && SIC_code='7219'DB:business_master_new
loadtime:0.4362781047821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galeton' limit 1
loadtime:0.43641710281372 / seconds
Query Executed:select id FROM `co` where city='Galeton' && SIC_code='7219'DB:business_master_new
loadtime:0.44622111320496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garcia' limit 1
loadtime:0.44627094268799 / seconds
Query Executed:select id FROM `co` where city='Garcia' && SIC_code='7219'DB:business_master_new
loadtime:0.447909116745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gardner' limit 1
loadtime:0.44795799255371 / seconds
Query Executed:select id FROM `co` where city='Gardner' && SIC_code='7219'DB:business_master_new
loadtime:0.44947791099548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gateway' limit 1
loadtime:0.44957494735718 / seconds
Query Executed:select id FROM `co` where city='Gateway' && SIC_code='7219'DB:business_master_new
loadtime:0.4557158946991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Genoa' limit 1
loadtime:0.45576190948486 / seconds
Query Executed:select id FROM `co` where city='Genoa' && SIC_code='7219'DB:business_master_new
loadtime:0.45726203918457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:0.45739006996155 / seconds
Query Executed:select id FROM `co` where city='Georgetown' && SIC_code='7219'DB:business_master_new
loadtime:0.45891308784485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilcrest' limit 1
loadtime:0.45908904075623 / seconds
Query Executed:select id FROM `co` where city='Gilcrest' && SIC_code='7219'DB:business_master_new
loadtime:0.46064400672913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gill' limit 1
loadtime:0.46075510978699 / seconds
Query Executed:select id FROM `co` where city='Gill' && SIC_code='7219'DB:business_master_new
loadtime:0.46276593208313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glade Park' limit 1
loadtime:0.46290707588196 / seconds
Query Executed:select id FROM `co` where city='Glade Park' && SIC_code='7219'DB:business_master_new
loadtime:0.47169589996338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Haven' limit 1
loadtime:0.47175097465515 / seconds
Query Executed:select id FROM `co` where city='Glen Haven' && SIC_code='7219'DB:business_master_new
loadtime:0.47625994682312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood Springs' limit 1
loadtime:0.47629594802856 / seconds
Query Executed:select id FROM `co` where city='Glenwood Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.47771096229553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Golden' limit 1
loadtime:0.47784805297852 / seconds
Query Executed:select id FROM `co` where city='Golden' && SIC_code='7219'DB:business_master_new
loadtime:0.47943592071533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granada' limit 1
loadtime:0.47949004173279 / seconds
Query Executed:select id FROM `co` where city='Granada' && SIC_code='7219'DB:business_master_new
loadtime:0.48081994056702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:0.48095297813416 / seconds
Query Executed:select id FROM `co` where city='Granby' && SIC_code='7219'DB:business_master_new
loadtime:0.48251104354858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Junction' limit 1
loadtime:0.48262596130371 / seconds
Query Executed:select id FROM `co` where city='Grand Junction' && SIC_code='7219'DB:business_master_new
loadtime:0.48386812210083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Lake' limit 1
loadtime:0.48402094841003 / seconds
Query Executed:select id FROM `co` where city='Grand Lake' && SIC_code='7219'DB:business_master_new
loadtime:0.48558497428894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granite' limit 1
loadtime:0.48572707176208 / seconds
Query Executed:select id FROM `co` where city='Granite' && SIC_code='7219'DB:business_master_new
loadtime:0.48751592636108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grant' limit 1
loadtime:0.48755788803101 / seconds
Query Executed:select id FROM `co` where city='Grant' && SIC_code='7219'DB:business_master_new
loadtime:0.49197912216187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greeley' limit 1
loadtime:0.49204397201538 / seconds
Query Executed:select id FROM `co` where city='Greeley' && SIC_code='7219'DB:business_master_new
loadtime:0.49356508255005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Mountain Falls' limit 1
loadtime:0.49372005462646 / seconds
Query Executed:select id FROM `co` where city='Green Mountain Falls' && SIC_code='7219'DB:business_master_new
loadtime:0.49530911445618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Mtn Falls' limit 1
loadtime:0.49543404579163 / seconds
Query Executed:select id FROM `co` where city='Green Mtn Falls' && SIC_code='7219'DB:business_master_new
loadtime:0.49687004089355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood Vlg' limit 1
loadtime:0.49692010879517 / seconds
Query Executed:select id FROM `co` where city='Greenwood Vlg' && SIC_code='7219'DB:business_master_new
loadtime:0.49849009513855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grover' limit 1
loadtime:0.49863505363464 / seconds
Query Executed:select id FROM `co` where city='Grover' && SIC_code='7219'DB:business_master_new
loadtime:0.50025200843811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guffey' limit 1
loadtime:0.5003650188446 / seconds
Query Executed:select id FROM `co` where city='Guffey' && SIC_code='7219'DB:business_master_new
loadtime:0.50200796127319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gulnare' limit 1
loadtime:0.50217795372009 / seconds
Query Executed:select id FROM `co` where city='Gulnare' && SIC_code='7219'DB:business_master_new
loadtime:0.50431394577026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gunnison' limit 1
loadtime:0.50436401367188 / seconds
Query Executed:select id FROM `co` where city='Gunnison' && SIC_code='7219'DB:business_master_new
loadtime:0.50584101676941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gypsum' limit 1
loadtime:0.5059700012207 / seconds
Query Executed:select id FROM `co` where city='Gypsum' && SIC_code='7219'DB:business_master_new
loadtime:0.50689697265625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:0.50702500343323 / seconds
Query Executed:select id FROM `co` where city='Hamilton' && SIC_code='7219'DB:business_master_new
loadtime:0.51208090782166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartman' limit 1
loadtime:0.51212501525879 / seconds
Query Executed:select id FROM `co` where city='Hartman' && SIC_code='7219'DB:business_master_new
loadtime:0.51486802101135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartsel' limit 1
loadtime:0.51501107215881 / seconds
Query Executed:select id FROM `co` where city='Hartsel' && SIC_code='7219'DB:business_master_new
loadtime:0.51661896705627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hasty' limit 1
loadtime:0.51673102378845 / seconds
Query Executed:select id FROM `co` where city='Hasty' && SIC_code='7219'DB:business_master_new
loadtime:0.52251291275024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haswell' limit 1
loadtime:0.52257394790649 / seconds
Query Executed:select id FROM `co` where city='Haswell' && SIC_code='7219'DB:business_master_new
loadtime:0.52785706520081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haxtun' limit 1
loadtime:0.52799010276794 / seconds
Query Executed:select id FROM `co` where city='Haxtun' && SIC_code='7219'DB:business_master_new
loadtime:0.52913308143616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayden' limit 1
loadtime:0.52926301956177 / seconds
Query Executed:select id FROM `co` where city='Hayden' && SIC_code='7219'DB:business_master_new
loadtime:0.53083610534668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henderson' limit 1
loadtime:0.53097200393677 / seconds
Query Executed:select id FROM `co` where city='Henderson' && SIC_code='7219'DB:business_master_new
loadtime:0.53213000297546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hereford' limit 1
loadtime:0.53228306770325 / seconds
Query Executed:select id FROM `co` where city='Hereford' && SIC_code='7219'DB:business_master_new
loadtime:0.53481602668762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hesperus' limit 1
loadtime:0.53485894203186 / seconds
Query Executed:select id FROM `co` where city='Hesperus' && SIC_code='7219'DB:business_master_new
loadtime:0.53571009635925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highlands Ranch' limit 1
loadtime:0.53576302528381 / seconds
Query Executed:select id FROM `co` where city='Highlands Ranch' && SIC_code='7219'DB:business_master_new
loadtime:0.53728103637695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillrose' limit 1
loadtime:0.5373809337616 / seconds
Query Executed:select id FROM `co` where city='Hillrose' && SIC_code='7219'DB:business_master_new
loadtime:0.53859806060791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillside' limit 1
loadtime:0.53873610496521 / seconds
Query Executed:select id FROM `co` where city='Hillside' && SIC_code='7219'DB:business_master_new
loadtime:0.5420560836792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoehne' limit 1
loadtime:0.54210805892944 / seconds
Query Executed:select id FROM `co` where city='Hoehne' && SIC_code='7219'DB:business_master_new
loadtime:0.54482102394104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly' limit 1
loadtime:0.54486203193665 / seconds
Query Executed:select id FROM `co` where city='Holly' && SIC_code='7219'DB:business_master_new
loadtime:0.54636311531067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holyoke' limit 1
loadtime:0.54650712013245 / seconds
Query Executed:select id FROM `co` where city='Holyoke' && SIC_code='7219'DB:business_master_new
loadtime:0.54783701896667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Homelake' limit 1
loadtime:0.54797792434692 / seconds
Query Executed:select id FROM `co` where city='Homelake' && SIC_code='7219'DB:business_master_new
loadtime:0.54978394508362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hooper' limit 1
loadtime:0.5498309135437 / seconds
Query Executed:select id FROM `co` where city='Hooper' && SIC_code='7219'DB:business_master_new
loadtime:0.55127596855164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hot Sulphur Spgs' limit 1
loadtime:0.5513129234314 / seconds
Query Executed:select id FROM `co` where city='Hot Sulphur Spgs' && SIC_code='7219'DB:business_master_new
loadtime:0.55259609222412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hot Sulphur Springs' limit 1
loadtime:0.55264902114868 / seconds
Query Executed:select id FROM `co` where city='Hot Sulphur Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.55391502380371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hotchkiss' limit 1
loadtime:0.55402588844299 / seconds
Query Executed:select id FROM `co` where city='Hotchkiss' && SIC_code='7219'DB:business_master_new
loadtime:0.55551099777222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howard' limit 1
loadtime:0.55556011199951 / seconds
Query Executed:select id FROM `co` where city='Howard' && SIC_code='7219'DB:business_master_new
loadtime:0.55669808387756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:0.55682802200317 / seconds
Query Executed:select id FROM `co` where city='Hudson' && SIC_code='7219'DB:business_master_new
loadtime:0.55839395523071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hugo' limit 1
loadtime:0.55853390693665 / seconds
Query Executed:select id FROM `co` where city='Hugo' && SIC_code='7219'DB:business_master_new
loadtime:0.55982089042664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hygiene' limit 1
loadtime:0.55995988845825 / seconds
Query Executed:select id FROM `co` where city='Hygiene' && SIC_code='7219'DB:business_master_new
loadtime:0.5614869594574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Idaho Springs' limit 1
loadtime:0.5616021156311 / seconds
Query Executed:select id FROM `co` where city='Idaho Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.56331610679626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Idalia' limit 1
loadtime:0.56345200538635 / seconds
Query Executed:select id FROM `co` where city='Idalia' && SIC_code='7219'DB:business_master_new
loadtime:0.56479907035828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Idledale' limit 1
loadtime:0.56489610671997 / seconds
Query Executed:select id FROM `co` where city='Idledale' && SIC_code='7219'DB:business_master_new
loadtime:0.57384204864502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ignacio' limit 1
loadtime:0.57389211654663 / seconds
Query Executed:select id FROM `co` where city='Ignacio' && SIC_code='7219'DB:business_master_new
loadtime:0.57487297058105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iliff' limit 1
loadtime:0.57493591308594 / seconds
Query Executed:select id FROM `co` where city='Iliff' && SIC_code='7219'DB:business_master_new
loadtime:0.57554292678833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Hills' limit 1
loadtime:0.57558798789978 / seconds
Query Executed:select id FROM `co` where city='Indian Hills' && SIC_code='7219'DB:business_master_new
loadtime:0.57675004005432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:0.57682800292969 / seconds
Query Executed:select id FROM `co` where city='Jamestown' && SIC_code='7219'DB:business_master_new
loadtime:0.57797694206238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jaroso' limit 1
loadtime:0.57816410064697 / seconds
Query Executed:select id FROM `co` where city='Jaroso' && SIC_code='7219'DB:business_master_new
loadtime:0.58118891716003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:0.5812349319458 / seconds
Query Executed:select id FROM `co` where city='Jefferson' && SIC_code='7219'DB:business_master_new
loadtime:0.58215188980103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joes' limit 1
loadtime:0.5822639465332 / seconds
Query Executed:select id FROM `co` where city='Joes' && SIC_code='7219'DB:business_master_new
loadtime:0.58336305618286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnstown' limit 1
loadtime:0.58346796035767 / seconds
Query Executed:select id FROM `co` where city='Johnstown' && SIC_code='7219'DB:business_master_new
loadtime:0.58445000648499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Julesburg' limit 1
loadtime:0.58450198173523 / seconds
Query Executed:select id FROM `co` where city='Julesburg' && SIC_code='7219'DB:business_master_new
loadtime:0.58583211898804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Karval' limit 1
loadtime:0.58587408065796 / seconds
Query Executed:select id FROM `co` where city='Karval' && SIC_code='7219'DB:business_master_new
loadtime:0.59420895576477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keenesburg' limit 1
loadtime:0.59425806999207 / seconds
Query Executed:select id FROM `co` where city='Keenesburg' && SIC_code='7219'DB:business_master_new
loadtime:0.59528398513794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kersey' limit 1
loadtime:0.59535503387451 / seconds
Query Executed:select id FROM `co` where city='Kersey' && SIC_code='7219'DB:business_master_new
loadtime:0.59655690193176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keystone' limit 1
loadtime:0.59668612480164 / seconds
Query Executed:select id FROM `co` where city='Keystone' && SIC_code='7219'DB:business_master_new
loadtime:0.60327005386353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kim' limit 1
loadtime:0.60332489013672 / seconds
Query Executed:select id FROM `co` where city='Kim' && SIC_code='7219'DB:business_master_new
loadtime:0.61072301864624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kiowa' limit 1
loadtime:0.6107759475708 / seconds
Query Executed:select id FROM `co` where city='Kiowa' && SIC_code='7219'DB:business_master_new
loadtime:0.61193990707397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirk' limit 1
loadtime:0.61210203170776 / seconds
Query Executed:select id FROM `co` where city='Kirk' && SIC_code='7219'DB:business_master_new
loadtime:0.61324906349182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kit Carson' limit 1
loadtime:0.61338901519775 / seconds
Query Executed:select id FROM `co` where city='Kit Carson' && SIC_code='7219'DB:business_master_new
loadtime:0.61465907096863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kittredge' limit 1
loadtime:0.61477589607239 / seconds
Query Executed:select id FROM `co` where city='Kittredge' && SIC_code='7219'DB:business_master_new
loadtime:0.61598110198975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kremmling' limit 1
loadtime:0.61615300178528 / seconds
Query Executed:select id FROM `co` where city='Kremmling' && SIC_code='7219'DB:business_master_new
loadtime:0.6172399520874 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Jara' limit 1
loadtime:0.61735200881958 / seconds
Query Executed:select id FROM `co` where city='La Jara' && SIC_code='7219'DB:business_master_new
loadtime:0.61847591400146 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Junta' limit 1
loadtime:0.61861705780029 / seconds
Query Executed:select id FROM `co` where city='La Junta' && SIC_code='7219'DB:business_master_new
loadtime:0.6198251247406 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Salle' limit 1
loadtime:0.619961977005 / seconds
Query Executed:select id FROM `co` where city='La Salle' && SIC_code='7219'DB:business_master_new
loadtime:0.62084889411926 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Veta' limit 1
loadtime:0.6208930015564 / seconds
Query Executed:select id FROM `co` where city='La Veta' && SIC_code='7219'DB:business_master_new
loadtime:0.62194800376892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lafayette' limit 1
loadtime:0.62199997901917 / seconds
Query Executed:select id FROM `co` where city='Lafayette' && SIC_code='7219'DB:business_master_new
loadtime:0.62321496009827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laird' limit 1
loadtime:0.62326407432556 / seconds
Query Executed:select id FROM `co` where city='Laird' && SIC_code='7219'DB:business_master_new
loadtime:0.62384510040283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake City' limit 1
loadtime:0.6239640712738 / seconds
Query Executed:select id FROM `co` where city='Lake City' && SIC_code='7219'DB:business_master_new
loadtime:0.62510204315186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake George' limit 1
loadtime:0.6252429485321 / seconds
Query Executed:select id FROM `co` where city='Lake George' && SIC_code='7219'DB:business_master_new
loadtime:0.62636303901672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakewood' limit 1
loadtime:0.6264910697937 / seconds
Query Executed:select id FROM `co` where city='Lakewood' && SIC_code='7219'DB:business_master_new
loadtime:0.62782192230225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamar' limit 1
loadtime:0.62794899940491 / seconds
Query Executed:select id FROM `co` where city='Lamar' && SIC_code='7219'DB:business_master_new
loadtime:0.62913012504578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laporte' limit 1
loadtime:0.62925910949707 / seconds
Query Executed:select id FROM `co` where city='Laporte' && SIC_code='7219'DB:business_master_new
loadtime:0.63045907020569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Larkspur' limit 1
loadtime:0.63060307502747 / seconds
Query Executed:select id FROM `co` where city='Larkspur' && SIC_code='7219'DB:business_master_new
loadtime:0.63192009925842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Las Animas' limit 1
loadtime:0.63206601142883 / seconds
Query Executed:select id FROM `co` where city='Las Animas' && SIC_code='7219'DB:business_master_new
loadtime:0.63315200805664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lazear' limit 1
loadtime:0.6332859992981 / seconds
Query Executed:select id FROM `co` where city='Lazear' && SIC_code='7219'DB:business_master_new
loadtime:0.63552403450012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leadville' limit 1
loadtime:0.63556003570557 / seconds
Query Executed:select id FROM `co` where city='Leadville' && SIC_code='7219'DB:business_master_new
loadtime:0.63670110702515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewis' limit 1
loadtime:0.63683390617371 / seconds
Query Executed:select id FROM `co` where city='Lewis' && SIC_code='7219'DB:business_master_new
loadtime:0.63808107376099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Limon' limit 1
loadtime:0.63813710212708 / seconds
Query Executed:select id FROM `co` where city='Limon' && SIC_code='7219'DB:business_master_new
loadtime:0.6389639377594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lindon' limit 1
loadtime:0.63900709152222 / seconds
Query Executed:select id FROM `co` where city='Lindon' && SIC_code='7219'DB:business_master_new
loadtime:0.64305806159973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littleton' limit 1
loadtime:0.64310598373413 / seconds
Query Executed:select id FROM `co` where city='Littleton' && SIC_code='7219'DB:business_master_new
loadtime:0.64369606971741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Livermore' limit 1
loadtime:0.64374899864197 / seconds
Query Executed:select id FROM `co` where city='Livermore' && SIC_code='7219'DB:business_master_new
loadtime:0.64471006393433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lochbuie' limit 1
loadtime:0.64481091499329 / seconds
Query Executed:select id FROM `co` where city='Lochbuie' && SIC_code='7219'DB:business_master_new
loadtime:0.64581394195557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Log Lane Village' limit 1
loadtime:0.64586305618286 / seconds
Query Executed:select id FROM `co` where city='Log Lane Village' && SIC_code='7219'DB:business_master_new
loadtime:0.65463304519653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loma' limit 1
loadtime:0.65467405319214 / seconds
Query Executed:select id FROM `co` where city='Loma' && SIC_code='7219'DB:business_master_new
loadtime:0.65521907806396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lone Tree' limit 1
loadtime:0.65526103973389 / seconds
Query Executed:select id FROM `co` where city='Lone Tree' && SIC_code='7219'DB:business_master_new
loadtime:0.65583395957947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longmont' limit 1
loadtime:0.65588402748108 / seconds
Query Executed:select id FROM `co` where city='Longmont' && SIC_code='7219'DB:business_master_new
loadtime:0.65646195411682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louisville' limit 1
loadtime:0.65652108192444 / seconds
Query Executed:select id FROM `co` where city='Louisville' && SIC_code='7219'DB:business_master_new
loadtime:0.65705800056458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louviers' limit 1
loadtime:0.65710997581482 / seconds
Query Executed:select id FROM `co` where city='Louviers' && SIC_code='7219'DB:business_master_new
loadtime:0.66654109954834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loveland' limit 1
loadtime:0.66657710075378 / seconds
Query Executed:select id FROM `co` where city='Loveland' && SIC_code='7219'DB:business_master_new
loadtime:0.66774010658264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lucerne' limit 1
loadtime:0.66786599159241 / seconds
Query Executed:select id FROM `co` where city='Lucerne' && SIC_code='7219'DB:business_master_new
loadtime:0.66910290718079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyons' limit 1
loadtime:0.6691529750824 / seconds
Query Executed:select id FROM `co` where city='Lyons' && SIC_code='7219'DB:business_master_new
loadtime:0.67042803764343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mack' limit 1
loadtime:0.67047190666199 / seconds
Query Executed:select id FROM `co` where city='Mack' && SIC_code='7219'DB:business_master_new
loadtime:0.67165398597717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manassa' limit 1
loadtime:0.67170596122742 / seconds
Query Executed:select id FROM `co` where city='Manassa' && SIC_code='7219'DB:business_master_new
loadtime:0.67224192619324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mancos' limit 1
loadtime:0.67228507995605 / seconds
Query Executed:select id FROM `co` where city='Mancos' && SIC_code='7219'DB:business_master_new
loadtime:0.67297101020813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manitou Springs' limit 1
loadtime:0.67302107810974 / seconds
Query Executed:select id FROM `co` where city='Manitou Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.67358589172363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manzanola' limit 1
loadtime:0.6736319065094 / seconds
Query Executed:select id FROM `co` where city='Manzanola' && SIC_code='7219'DB:business_master_new
loadtime:0.67416310310364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble' limit 1
loadtime:0.67420506477356 / seconds
Query Executed:select id FROM `co` where city='Marble' && SIC_code='7219'DB:business_master_new
loadtime:0.67492508888245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marvel' limit 1
loadtime:0.67497706413269 / seconds
Query Executed:select id FROM `co` where city='Marvel' && SIC_code='7219'DB:business_master_new
loadtime:0.67555499076843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Masonville' limit 1
loadtime:0.67560601234436 / seconds
Query Executed:select id FROM `co` where city='Masonville' && SIC_code='7219'DB:business_master_new
loadtime:0.68181300163269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Matheson' limit 1
loadtime:0.68186593055725 / seconds
Query Executed:select id FROM `co` where city='Matheson' && SIC_code='7219'DB:business_master_new
loadtime:0.6828989982605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maybell' limit 1
loadtime:0.68301606178284 / seconds
Query Executed:select id FROM `co` where city='Maybell' && SIC_code='7219'DB:business_master_new
loadtime:0.68414807319641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Clave' limit 1
loadtime:0.68428802490234 / seconds
Query Executed:select id FROM `co` where city='Mc Clave' && SIC_code='7219'DB:business_master_new
loadtime:0.68554401397705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Coy' limit 1
loadtime:0.68564105033875 / seconds
Query Executed:select id FROM `co` where city='Mc Coy' && SIC_code='7219'DB:business_master_new
loadtime:0.6868269443512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mead' limit 1
loadtime:0.68695902824402 / seconds
Query Executed:select id FROM `co` where city='Mead' && SIC_code='7219'DB:business_master_new
loadtime:0.68809390068054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meeker' limit 1
loadtime:0.68814492225647 / seconds
Query Executed:select id FROM `co` where city='Meeker' && SIC_code='7219'DB:business_master_new
loadtime:0.68887090682983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meredith' limit 1
loadtime:0.6889500617981 / seconds
Query Executed:select id FROM `co` where city='Meredith' && SIC_code='7219'DB:business_master_new
loadtime:0.69105696678162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merino' limit 1
loadtime:0.69110989570618 / seconds
Query Executed:select id FROM `co` where city='Merino' && SIC_code='7219'DB:business_master_new
loadtime:0.69180107116699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesa' limit 1
loadtime:0.69192290306091 / seconds
Query Executed:select id FROM `co` where city='Mesa' && SIC_code='7219'DB:business_master_new
loadtime:0.6931209564209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesa Verde National Park' limit 1
loadtime:0.69323396682739 / seconds
Query Executed:select id FROM `co` where city='Mesa Verde National Park' && SIC_code='7219'DB:business_master_new
loadtime:0.69634699821472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesa Vrd Natl Pk' limit 1
loadtime:0.69640111923218 / seconds
Query Executed:select id FROM `co` where city='Mesa Vrd Natl Pk' && SIC_code='7219'DB:business_master_new
loadtime:0.69672203063965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milliken' limit 1
loadtime:0.69675803184509 / seconds
Query Executed:select id FROM `co` where city='Milliken' && SIC_code='7219'DB:business_master_new
loadtime:0.69732189178467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minturn' limit 1
loadtime:0.69737410545349 / seconds
Query Executed:select id FROM `co` where city='Minturn' && SIC_code='7219'DB:business_master_new
loadtime:0.69793105125427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Model' limit 1
loadtime:0.69797706604004 / seconds
Query Executed:select id FROM `co` where city='Model' && SIC_code='7219'DB:business_master_new
loadtime:0.69935894012451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moffat' limit 1
loadtime:0.69941306114197 / seconds
Query Executed:select id FROM `co` where city='Moffat' && SIC_code='7219'DB:business_master_new
loadtime:0.6999568939209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Molina' limit 1
loadtime:0.70001101493835 / seconds
Query Executed:select id FROM `co` where city='Molina' && SIC_code='7219'DB:business_master_new
loadtime:0.70228505134583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monarch' limit 1
loadtime:0.70232701301575 / seconds
Query Executed:select id FROM `co` where city='Monarch' && SIC_code='7219'DB:business_master_new
loadtime:0.70306611061096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monte Vista' limit 1
loadtime:0.70311903953552 / seconds
Query Executed:select id FROM `co` where city='Monte Vista' && SIC_code='7219'DB:business_master_new
loadtime:0.70415592193604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montrose' limit 1
loadtime:0.70420289039612 / seconds
Query Executed:select id FROM `co` where city='Montrose' && SIC_code='7219'DB:business_master_new
loadtime:0.70554804801941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monument' limit 1
loadtime:0.70559191703796 / seconds
Query Executed:select id FROM `co` where city='Monument' && SIC_code='7219'DB:business_master_new
loadtime:0.70694708824158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrison' limit 1
loadtime:0.70699691772461 / seconds
Query Executed:select id FROM `co` where city='Morrison' && SIC_code='7219'DB:business_master_new
loadtime:0.70833706855774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mosca' limit 1
loadtime:0.70838809013367 / seconds
Query Executed:select id FROM `co` where city='Mosca' && SIC_code='7219'DB:business_master_new
loadtime:0.70961689949036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain Village' limit 1
loadtime:0.70973706245422 / seconds
Query Executed:select id FROM `co` where city='Mountain Village' && SIC_code='7219'DB:business_master_new
loadtime:0.71125507354736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nathrop' limit 1
loadtime:0.71130394935608 / seconds
Query Executed:select id FROM `co` where city='Nathrop' && SIC_code='7219'DB:business_master_new
loadtime:0.71260094642639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naturita' limit 1
loadtime:0.71265196800232 / seconds
Query Executed:select id FROM `co` where city='Naturita' && SIC_code='7219'DB:business_master_new
loadtime:0.71404194831848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nederland' limit 1
loadtime:0.71407794952393 / seconds
Query Executed:select id FROM `co` where city='Nederland' && SIC_code='7219'DB:business_master_new
loadtime:0.71541094779968 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Castle' limit 1
loadtime:0.71546006202698 / seconds
Query Executed:select id FROM `co` where city='New Castle' && SIC_code='7219'DB:business_master_new
loadtime:0.71671009063721 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Raymer' limit 1
loadtime:0.71684908866882 / seconds
Query Executed:select id FROM `co` where city='New Raymer' && SIC_code='7219'DB:business_master_new
loadtime:0.71839594841003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Niwot' limit 1
loadtime:0.71849393844604 / seconds
Query Executed:select id FROM `co` where city='Niwot' && SIC_code='7219'DB:business_master_new
loadtime:0.7199239730835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northglenn' limit 1
loadtime:0.71997308731079 / seconds
Query Executed:select id FROM `co` where city='Northglenn' && SIC_code='7219'DB:business_master_new
loadtime:0.72118401527405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:0.72122001647949 / seconds
Query Executed:select id FROM `co` where city='Norwood' && SIC_code='7219'DB:business_master_new
loadtime:0.72259092330933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nucla' limit 1
loadtime:0.72269511222839 / seconds
Query Executed:select id FROM `co` where city='Nucla' && SIC_code='7219'DB:business_master_new
loadtime:0.72366905212402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nunn' limit 1
loadtime:0.72372102737427 / seconds
Query Executed:select id FROM `co` where city='Nunn' && SIC_code='7219'DB:business_master_new
loadtime:0.72495102882385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Creek' limit 1
loadtime:0.72510695457458 / seconds
Query Executed:select id FROM `co` where city='Oak Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.72623896598816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ohio City' limit 1
loadtime:0.72636890411377 / seconds
Query Executed:select id FROM `co` where city='Ohio City' && SIC_code='7219'DB:business_master_new
loadtime:0.72869801521301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olathe' limit 1
loadtime:0.72873997688293 / seconds
Query Executed:select id FROM `co` where city='Olathe' && SIC_code='7219'DB:business_master_new
loadtime:0.72981691360474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olney Springs' limit 1
loadtime:0.72995710372925 / seconds
Query Executed:select id FROM `co` where city='Olney Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.73109602928162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ophir' limit 1
loadtime:0.73121309280396 / seconds
Query Executed:select id FROM `co` where city='Ophir' && SIC_code='7219'DB:business_master_new
loadtime:0.73505091667175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orchard' limit 1
loadtime:0.73510408401489 / seconds
Query Executed:select id FROM `co` where city='Orchard' && SIC_code='7219'DB:business_master_new
loadtime:0.74079704284668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ordway' limit 1
loadtime:0.74093890190125 / seconds
Query Executed:select id FROM `co` where city='Ordway' && SIC_code='7219'DB:business_master_new
loadtime:0.74214601516724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otis' limit 1
loadtime:0.74228096008301 / seconds
Query Executed:select id FROM `co` where city='Otis' && SIC_code='7219'DB:business_master_new
loadtime:0.74326300621033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ouray' limit 1
loadtime:0.74330806732178 / seconds
Query Executed:select id FROM `co` where city='Ouray' && SIC_code='7219'DB:business_master_new
loadtime:0.74417304992676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ovid' limit 1
loadtime:0.74422693252563 / seconds
Query Executed:select id FROM `co` where city='Ovid' && SIC_code='7219'DB:business_master_new
loadtime:0.74552392959595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Padroni' limit 1
loadtime:0.74556708335876 / seconds
Query Executed:select id FROM `co` where city='Padroni' && SIC_code='7219'DB:business_master_new
loadtime:0.74773192405701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pagosa Springs' limit 1
loadtime:0.74778199195862 / seconds
Query Executed:select id FROM `co` where city='Pagosa Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.74878096580505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palisade' limit 1
loadtime:0.7488420009613 / seconds
Query Executed:select id FROM `co` where city='Palisade' && SIC_code='7219'DB:business_master_new
loadtime:0.74947690963745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmer Lake' limit 1
loadtime:0.74952912330627 / seconds
Query Executed:select id FROM `co` where city='Palmer Lake' && SIC_code='7219'DB:business_master_new
loadtime:0.75062203407288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paoli' limit 1
loadtime:0.75071406364441 / seconds
Query Executed:select id FROM `co` where city='Paoli' && SIC_code='7219'DB:business_master_new
loadtime:0.75423097610474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paonia' limit 1
loadtime:0.7543420791626 / seconds
Query Executed:select id FROM `co` where city='Paonia' && SIC_code='7219'DB:business_master_new
loadtime:0.75553703308105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parachute' limit 1
loadtime:0.75558710098267 / seconds
Query Executed:select id FROM `co` where city='Parachute' && SIC_code='7219'DB:business_master_new
loadtime:0.75670289993286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paradox' limit 1
loadtime:0.75681400299072 / seconds
Query Executed:select id FROM `co` where city='Paradox' && SIC_code='7219'DB:business_master_new
loadtime:0.76266598701477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parker' limit 1
loadtime:0.76276111602783 / seconds
Query Executed:select id FROM `co` where city='Parker' && SIC_code='7219'DB:business_master_new
loadtime:0.76412105560303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parlin' limit 1
loadtime:0.76419711112976 / seconds
Query Executed:select id FROM `co` where city='Parlin' && SIC_code='7219'DB:business_master_new
loadtime:0.76852297782898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parshall' limit 1
loadtime:0.76857399940491 / seconds
Query Executed:select id FROM `co` where city='Parshall' && SIC_code='7219'DB:business_master_new
loadtime:0.77601790428162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peetz' limit 1
loadtime:0.77606797218323 / seconds
Query Executed:select id FROM `co` where city='Peetz' && SIC_code='7219'DB:business_master_new
loadtime:0.77718305587769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penrose' limit 1
loadtime:0.77723407745361 / seconds
Query Executed:select id FROM `co` where city='Penrose' && SIC_code='7219'DB:business_master_new
loadtime:0.77858805656433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peterson Afb' limit 1
loadtime:0.77863001823425 / seconds
Query Executed:select id FROM `co` where city='Peterson Afb' && SIC_code='7219'DB:business_master_new
loadtime:0.77960991859436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peyton' limit 1
loadtime:0.77974104881287 / seconds
Query Executed:select id FROM `co` where city='Peyton' && SIC_code='7219'DB:business_master_new
loadtime:0.78090310096741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phippsburg' limit 1
loadtime:0.78109097480774 / seconds
Query Executed:select id FROM `co` where city='Phippsburg' && SIC_code='7219'DB:business_master_new
loadtime:0.78577589988708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierce' limit 1
loadtime:0.78588604927063 / seconds
Query Executed:select id FROM `co` where city='Pierce' && SIC_code='7219'DB:business_master_new
loadtime:0.78710508346558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine' limit 1
loadtime:0.78724908828735 / seconds
Query Executed:select id FROM `co` where city='Pine' && SIC_code='7219'DB:business_master_new
loadtime:0.78817701339722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Grove' limit 1
loadtime:0.78822493553162 / seconds
Query Executed:select id FROM `co` where city='Pine Grove' && SIC_code='7219'DB:business_master_new
loadtime:0.78861594200134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinecliffe' limit 1
loadtime:0.78871297836304 / seconds
Query Executed:select id FROM `co` where city='Pinecliffe' && SIC_code='7219'DB:business_master_new
loadtime:0.79256391525269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pitkin' limit 1
loadtime:0.79261589050293 / seconds
Query Executed:select id FROM `co` where city='Pitkin' && SIC_code='7219'DB:business_master_new
loadtime:0.79859709739685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Placerville' limit 1
loadtime:0.79864597320557 / seconds
Query Executed:select id FROM `co` where city='Placerville' && SIC_code='7219'DB:business_master_new
loadtime:0.79920196533203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Platteville' limit 1
loadtime:0.799241065979 / seconds
Query Executed:select id FROM `co` where city='Platteville' && SIC_code='7219'DB:business_master_new
loadtime:0.79981899261475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant View' limit 1
loadtime:0.79986095428467 / seconds
Query Executed:select id FROM `co` where city='Pleasant View' && SIC_code='7219'DB:business_master_new
loadtime:0.80043196678162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poncha Springs' limit 1
loadtime:0.80048704147339 / seconds
Query Executed:select id FROM `co` where city='Poncha Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.8010458946228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powderhorn' limit 1
loadtime:0.80109310150146 / seconds
Query Executed:select id FROM `co` where city='Powderhorn' && SIC_code='7219'DB:business_master_new
loadtime:0.80432510375977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pritchett' limit 1
loadtime:0.8043749332428 / seconds
Query Executed:select id FROM `co` where city='Pritchett' && SIC_code='7219'DB:business_master_new
loadtime:0.80959892272949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pueblo' limit 1
loadtime:0.8096399307251 / seconds
Query Executed:select id FROM `co` where city='Pueblo' && SIC_code='7219'DB:business_master_new
loadtime:0.81059694290161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pueblo West' limit 1
loadtime:0.81072592735291 / seconds
Query Executed:select id FROM `co` where city='Pueblo West' && SIC_code='7219'DB:business_master_new
loadtime:0.81175398826599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramah' limit 1
loadtime:0.81186103820801 / seconds
Query Executed:select id FROM `co` where city='Ramah' && SIC_code='7219'DB:business_master_new
loadtime:0.81323289871216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rand' limit 1
loadtime:0.81327390670776 / seconds
Query Executed:select id FROM `co` where city='Rand' && SIC_code='7219'DB:business_master_new
loadtime:0.8168671131134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rangely' limit 1
loadtime:0.81692004203796 / seconds
Query Executed:select id FROM `co` where city='Rangely' && SIC_code='7219'DB:business_master_new
loadtime:0.81747794151306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Cliff' limit 1
loadtime:0.81751489639282 / seconds
Query Executed:select id FROM `co` where city='Red Cliff' && SIC_code='7219'DB:business_master_new
loadtime:0.82356595993042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Feather Lakes' limit 1
loadtime:0.82361698150635 / seconds
Query Executed:select id FROM `co` where city='Red Feather Lakes' && SIC_code='7219'DB:business_master_new
loadtime:0.82415699958801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Feather Lks' limit 1
loadtime:0.82419109344482 / seconds
Query Executed:select id FROM `co` where city='Red Feather Lks' && SIC_code='7219'DB:business_master_new
loadtime:0.82512593269348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redstone' limit 1
loadtime:0.82517695426941 / seconds
Query Executed:select id FROM `co` where city='Redstone' && SIC_code='7219'DB:business_master_new
loadtime:0.82559490203857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redvale' limit 1
loadtime:0.82563710212708 / seconds
Query Executed:select id FROM `co` where city='Redvale' && SIC_code='7219'DB:business_master_new
loadtime:0.83207297325134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rico' limit 1
loadtime:0.83210897445679 / seconds
Query Executed:select id FROM `co` where city='Rico' && SIC_code='7219'DB:business_master_new
loadtime:0.83267092704773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgway' limit 1
loadtime:0.83272290229797 / seconds
Query Executed:select id FROM `co` where city='Ridgway' && SIC_code='7219'DB:business_master_new
loadtime:0.83325791358948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rifle' limit 1
loadtime:0.83329796791077 / seconds
Query Executed:select id FROM `co` where city='Rifle' && SIC_code='7219'DB:business_master_new
loadtime:0.8338360786438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockvale' limit 1
loadtime:0.83387899398804 / seconds
Query Executed:select id FROM `co` where city='Rockvale' && SIC_code='7219'DB:business_master_new
loadtime:0.83647203445435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Ford' limit 1
loadtime:0.83653211593628 / seconds
Query Executed:select id FROM `co` where city='Rocky Ford' && SIC_code='7219'DB:business_master_new
loadtime:0.83707404136658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roggen' limit 1
loadtime:0.83711099624634 / seconds
Query Executed:select id FROM `co` where city='Roggen' && SIC_code='7219'DB:business_master_new
loadtime:0.83766007423401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rollinsville' limit 1
loadtime:0.83771204948425 / seconds
Query Executed:select id FROM `co` where city='Rollinsville' && SIC_code='7219'DB:business_master_new
loadtime:0.83824610710144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Romeo' limit 1
loadtime:0.83827996253967 / seconds
Query Executed:select id FROM `co` where city='Romeo' && SIC_code='7219'DB:business_master_new
loadtime:0.84335708618164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rush' limit 1
loadtime:0.84341907501221 / seconds
Query Executed:select id FROM `co` where city='Rush' && SIC_code='7219'DB:business_master_new
loadtime:0.84463500976562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rye' limit 1
loadtime:0.84477090835571 / seconds
Query Executed:select id FROM `co` where city='Rye' && SIC_code='7219'DB:business_master_new
loadtime:0.8463249206543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saguache' limit 1
loadtime:0.84647607803345 / seconds
Query Executed:select id FROM `co` where city='Saguache' && SIC_code='7219'DB:business_master_new
loadtime:0.84773898124695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salida' limit 1
loadtime:0.84787511825562 / seconds
Query Executed:select id FROM `co` where city='Salida' && SIC_code='7219'DB:business_master_new
loadtime:0.84943509101868 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Luis' limit 1
loadtime:0.84953093528748 / seconds
Query Executed:select id FROM `co` where city='San Luis' && SIC_code='7219'DB:business_master_new
loadtime:0.85109806060791 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Pablo' limit 1
loadtime:0.85122799873352 / seconds
Query Executed:select id FROM `co` where city='San Pablo' && SIC_code='7219'DB:business_master_new
loadtime:0.85252594947815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanford' limit 1
loadtime:0.85257291793823 / seconds
Query Executed:select id FROM `co` where city='Sanford' && SIC_code='7219'DB:business_master_new
loadtime:0.85410308837891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sargents' limit 1
loadtime:0.85424399375916 / seconds
Query Executed:select id FROM `co` where city='Sargents' && SIC_code='7219'DB:business_master_new
loadtime:0.85844802856445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedalia' limit 1
loadtime:0.85858297348022 / seconds
Query Executed:select id FROM `co` where city='Sedalia' && SIC_code='7219'DB:business_master_new
loadtime:0.86026310920715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedgwick' limit 1
loadtime:0.86040091514587 / seconds
Query Executed:select id FROM `co` where city='Sedgwick' && SIC_code='7219'DB:business_master_new
loadtime:0.86211204528809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seibert' limit 1
loadtime:0.86221194267273 / seconds
Query Executed:select id FROM `co` where city='Seibert' && SIC_code='7219'DB:business_master_new
loadtime:0.86379194259644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Severance' limit 1
loadtime:0.8639349937439 / seconds
Query Executed:select id FROM `co` where city='Severance' && SIC_code='7219'DB:business_master_new
loadtime:0.87032103538513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shawnee' limit 1
loadtime:0.87046194076538 / seconds
Query Executed:select id FROM `co` where city='Shawnee' && SIC_code='7219'DB:business_master_new
loadtime:0.87561011314392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheridan' limit 1
loadtime:0.87565803527832 / seconds
Query Executed:select id FROM `co` where city='Sheridan' && SIC_code='7219'DB:business_master_new
loadtime:0.87836003303528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheridan Lake' limit 1
loadtime:0.87840294837952 / seconds
Query Executed:select id FROM `co` where city='Sheridan Lake' && SIC_code='7219'DB:business_master_new
loadtime:0.87896299362183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silt' limit 1
loadtime:0.87901496887207 / seconds
Query Executed:select id FROM `co` where city='Silt' && SIC_code='7219'DB:business_master_new
loadtime:0.87959790229797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Cliff' limit 1
loadtime:0.87963891029358 / seconds
Query Executed:select id FROM `co` where city='Silver Cliff' && SIC_code='7219'DB:business_master_new
loadtime:0.88333106040955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Plume' limit 1
loadtime:0.88345694541931 / seconds
Query Executed:select id FROM `co` where city='Silver Plume' && SIC_code='7219'DB:business_master_new
loadtime:0.89062094688416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silverthorne' limit 1
loadtime:0.89075994491577 / seconds
Query Executed:select id FROM `co` where city='Silverthorne' && SIC_code='7219'DB:business_master_new
loadtime:0.89211010932922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silverton' limit 1
loadtime:0.89222097396851 / seconds
Query Executed:select id FROM `co` where city='Silverton' && SIC_code='7219'DB:business_master_new
loadtime:0.89380407333374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Simla' limit 1
loadtime:0.89394593238831 / seconds
Query Executed:select id FROM `co` where city='Simla' && SIC_code='7219'DB:business_master_new
loadtime:0.89545512199402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Slater' limit 1
loadtime:0.8955409526825 / seconds
Query Executed:select id FROM `co` where city='Slater' && SIC_code='7219'DB:business_master_new
loadtime:0.89704990386963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snowmass' limit 1
loadtime:0.89709997177124 / seconds
Query Executed:select id FROM `co` where city='Snowmass' && SIC_code='7219'DB:business_master_new
loadtime:0.89771509170532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snowmass Village' limit 1
loadtime:0.89775991439819 / seconds
Query Executed:select id FROM `co` where city='Snowmass Village' && SIC_code='7219'DB:business_master_new
loadtime:0.89884090423584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snyder' limit 1
loadtime:0.89888906478882 / seconds
Query Executed:select id FROM `co` where city='Snyder' && SIC_code='7219'DB:business_master_new
loadtime:0.90572500228882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:0.9057719707489 / seconds
Query Executed:select id FROM `co` where city='Somerset' && SIC_code='7219'DB:business_master_new
loadtime:0.90641093254089 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Fork' limit 1
loadtime:0.90646195411682 / seconds
Query Executed:select id FROM `co` where city='South Fork' && SIC_code='7219'DB:business_master_new
loadtime:0.90744400024414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.90749311447144 / seconds
Query Executed:select id FROM `co` where city='Springfield' && SIC_code='7219'DB:business_master_new
loadtime:0.90851712226868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steamboat Spgs' limit 1
loadtime:0.90863108634949 / seconds
Query Executed:select id FROM `co` where city='Steamboat Spgs' && SIC_code='7219'DB:business_master_new
loadtime:0.90978789329529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steamboat Springs' limit 1
loadtime:0.90989208221436 / seconds
Query Executed:select id FROM `co` where city='Steamboat Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.91102409362793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:0.91119194030762 / seconds
Query Executed:select id FROM `co` where city='Sterling' && SIC_code='7219'DB:business_master_new
loadtime:0.91231393814087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoneham' limit 1
loadtime:0.9124550819397 / seconds
Query Executed:select id FROM `co` where city='Stoneham' && SIC_code='7219'DB:business_master_new
loadtime:0.91358995437622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strasburg' limit 1
loadtime:0.91363596916199 / seconds
Query Executed:select id FROM `co` where city='Strasburg' && SIC_code='7219'DB:business_master_new
loadtime:0.9148530960083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratton' limit 1
loadtime:0.9149808883667 / seconds
Query Executed:select id FROM `co` where city='Stratton' && SIC_code='7219'DB:business_master_new
loadtime:0.91609191894531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar City' limit 1
loadtime:0.91623210906982 / seconds
Query Executed:select id FROM `co` where city='Sugar City' && SIC_code='7219'DB:business_master_new
loadtime:0.91729092597961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Superior' limit 1
loadtime:0.91737008094788 / seconds
Query Executed:select id FROM `co` where city='Superior' && SIC_code='7219'DB:business_master_new
loadtime:0.9202721118927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swink' limit 1
loadtime:0.92032289505005 / seconds
Query Executed:select id FROM `co` where city='Swink' && SIC_code='7219'DB:business_master_new
loadtime:0.92169594764709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabernash' limit 1
loadtime:0.9217369556427 / seconds
Query Executed:select id FROM `co` where city='Tabernash' && SIC_code='7219'DB:business_master_new
loadtime:0.92279601097107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Telluride' limit 1
loadtime:0.92289400100708 / seconds
Query Executed:select id FROM `co` where city='Telluride' && SIC_code='7219'DB:business_master_new
loadtime:0.92412209510803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornton' limit 1
loadtime:0.92425489425659 / seconds
Query Executed:select id FROM `co` where city='Thornton' && SIC_code='7219'DB:business_master_new
loadtime:0.92493796348572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timnath' limit 1
loadtime:0.92507410049438 / seconds
Query Executed:select id FROM `co` where city='Timnath' && SIC_code='7219'DB:business_master_new
loadtime:0.92615008354187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toponas' limit 1
loadtime:0.92628693580627 / seconds
Query Executed:select id FROM `co` where city='Toponas' && SIC_code='7219'DB:business_master_new
loadtime:0.9293429851532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Towaoc' limit 1
loadtime:0.92938494682312 / seconds
Query Executed:select id FROM `co` where city='Towaoc' && SIC_code='7219'DB:business_master_new
loadtime:0.93070507049561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Towner' limit 1
loadtime:0.9307599067688 / seconds
Query Executed:select id FROM `co` where city='Towner' && SIC_code='7219'DB:business_master_new
loadtime:0.93226599693298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trinchera' limit 1
loadtime:0.93231606483459 / seconds
Query Executed:select id FROM `co` where city='Trinchera' && SIC_code='7219'DB:business_master_new
loadtime:0.93423295021057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trinidad' limit 1
loadtime:0.93428111076355 / seconds
Query Executed:select id FROM `co` where city='Trinidad' && SIC_code='7219'DB:business_master_new
loadtime:0.93526411056519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twin Lakes' limit 1
loadtime:0.93543410301208 / seconds
Query Executed:select id FROM `co` where city='Twin Lakes' && SIC_code='7219'DB:business_master_new
loadtime:0.94172501564026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Two Buttes' limit 1
loadtime:0.9417769908905 / seconds
Query Executed:select id FROM `co` where city='Two Buttes' && SIC_code='7219'DB:business_master_new
loadtime:0.94289302825928 / seconds
Query loaded from cache:select * from geodata_geocity where city='U S A F Academy' limit 1
loadtime:0.94299006462097 / seconds
Query Executed:select id FROM `co` where city='U S A F Academy' && SIC_code='7219'DB:business_master_new
loadtime:0.94392204284668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Usaf Academy' limit 1
loadtime:0.94397306442261 / seconds
Query Executed:select id FROM `co` where city='Usaf Academy' && SIC_code='7219'DB:business_master_new
loadtime:0.94499397277832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vail' limit 1
loadtime:0.94513010978699 / seconds
Query Executed:select id FROM `co` where city='Vail' && SIC_code='7219'DB:business_master_new
loadtime:0.94619703292847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:0.94632506370544 / seconds
Query Executed:select id FROM `co` where city='Vernon' && SIC_code='7219'DB:business_master_new
loadtime:0.95232200622559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Victor' limit 1
loadtime:0.95237112045288 / seconds
Query Executed:select id FROM `co` where city='Victor' && SIC_code='7219'DB:business_master_new
loadtime:0.95348000526428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vilas' limit 1
loadtime:0.95362091064453 / seconds
Query Executed:select id FROM `co` where city='Vilas' && SIC_code='7219'DB:business_master_new
loadtime:0.95927309989929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villa Grove' limit 1
loadtime:0.95942902565002 / seconds
Query Executed:select id FROM `co` where city='Villa Grove' && SIC_code='7219'DB:business_master_new
loadtime:0.96692109107971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vona' limit 1
loadtime:0.96696305274963 / seconds
Query Executed:select id FROM `co` where city='Vona' && SIC_code='7219'DB:business_master_new
loadtime:0.97442293167114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walden' limit 1
loadtime:0.97455596923828 / seconds
Query Executed:select id FROM `co` where city='Walden' && SIC_code='7219'DB:business_master_new
loadtime:0.97526693344116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walsenburg' limit 1
loadtime:0.97530508041382 / seconds
Query Executed:select id FROM `co` where city='Walsenburg' && SIC_code='7219'DB:business_master_new
loadtime:0.97585892677307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walsh' limit 1
loadtime:0.975909948349 / seconds
Query Executed:select id FROM `co` where city='Walsh' && SIC_code='7219'DB:business_master_new
loadtime:0.97647404670715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ward' limit 1
loadtime:0.97652697563171 / seconds
Query Executed:select id FROM `co` where city='Ward' && SIC_code='7219'DB:business_master_new
loadtime:0.97706890106201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watkins' limit 1
loadtime:0.97711801528931 / seconds
Query Executed:select id FROM `co` where city='Watkins' && SIC_code='7219'DB:business_master_new
loadtime:0.97766709327698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weldona' limit 1
loadtime:0.97771310806274 / seconds
Query Executed:select id FROM `co` where city='Weldona' && SIC_code='7219'DB:business_master_new
loadtime:0.97825288772583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellington' limit 1
loadtime:0.97829294204712 / seconds
Query Executed:select id FROM `co` where city='Wellington' && SIC_code='7219'DB:business_master_new
loadtime:0.97884011268616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westcliffe' limit 1
loadtime:0.97887492179871 / seconds
Query Executed:select id FROM `co` where city='Westcliffe' && SIC_code='7219'DB:business_master_new
loadtime:0.97944808006287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:0.97950100898743 / seconds
Query Executed:select id FROM `co` where city='Westminster' && SIC_code='7219'DB:business_master_new
loadtime:0.98006105422974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:0.98010993003845 / seconds
Query Executed:select id FROM `co` where city='Weston' && SIC_code='7219'DB:business_master_new
loadtime:0.98089289665222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wetmore' limit 1
loadtime:0.98101902008057 / seconds
Query Executed:select id FROM `co` where city='Wetmore' && SIC_code='7219'DB:business_master_new
loadtime:0.98211598396301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheat Ridge' limit 1
loadtime:0.98221302032471 / seconds
Query Executed:select id FROM `co` where city='Wheat Ridge' && SIC_code='7219'DB:business_master_new
loadtime:0.98327708244324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitewater' limit 1
loadtime:0.98343801498413 / seconds
Query Executed:select id FROM `co` where city='Whitewater' && SIC_code='7219'DB:business_master_new
loadtime:0.98460292816162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wiggins' limit 1
loadtime:0.98465704917908 / seconds
Query Executed:select id FROM `co` where city='Wiggins' && SIC_code='7219'DB:business_master_new
loadtime:0.98570394515991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wild Horse' limit 1
loadtime:0.98575806617737 / seconds
Query Executed:select id FROM `co` where city='Wild Horse' && SIC_code='7219'DB:business_master_new
loadtime:0.98906207084656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wiley' limit 1
loadtime:0.98909902572632 / seconds
Query Executed:select id FROM `co` where city='Wiley' && SIC_code='7219'DB:business_master_new
loadtime:0.99014210700989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:0.99026989936829 / seconds
Query Executed:select id FROM `co` where city='Windsor' && SIC_code='7219'DB:business_master_new
loadtime:0.99134993553162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winter Park' limit 1
loadtime:0.99146604537964 / seconds
Query Executed:select id FROM `co` where city='Winter Park' && SIC_code='7219'DB:business_master_new
loadtime:0.99246501922607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolcott' limit 1
loadtime:0.99259305000305 / seconds
Query Executed:select id FROM `co` where city='Wolcott' && SIC_code='7219'DB:business_master_new
loadtime:0.99379301071167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland Park' limit 1
loadtime:0.99387502670288 / seconds
Query Executed:select id FROM `co` where city='Woodland Park' && SIC_code='7219'DB:business_master_new
loadtime:0.99496698379517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodrow' limit 1
loadtime:0.99512505531311 / seconds
Query Executed:select id FROM `co` where city='Woodrow' && SIC_code='7219'DB:business_master_new
loadtime:0.99608492851257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woody Creek' limit 1
loadtime:0.99617099761963 / seconds
Query Executed:select id FROM `co` where city='Woody Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.9976019859314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wray' limit 1
loadtime:0.99765205383301 / seconds
Query Executed:select id FROM `co` where city='Wray' && SIC_code='7219'DB:business_master_new
loadtime:0.99868297576904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yampa' limit 1
loadtime:0.9987199306488 / seconds
Query Executed:select id FROM `co` where city='Yampa' && SIC_code='7219'DB:business_master_new
loadtime:0.99972200393677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yellow Jacket' limit 1
loadtime:0.99986100196838 / seconds
Query Executed:select id FROM `co` where city='Yellow Jacket' && SIC_code='7219'DB:business_master_new
loadtime:1.000962972641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yoder' limit 1
loadtime:1.0011229515076 / seconds
Query Executed:select id FROM `co` where city='Yoder' && SIC_code='7219'DB:business_master_new
loadtime:1.0021979808807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yuma' limit 1
loadtime:1.0022959709167 / seconds
Query Executed:select id FROM `co` where city='Yuma' && SIC_code='7219'DB:business_master_new
loadtime:1.0035750865936 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.0036630630493 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.0039260387421 / seconds
Operation template executed (chunk cache operation)
loadtime:1.0041658878326 / seconds
template override:Default
loadtime:1.0042200088501 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:1.0054659843445 / seconds
Template Constructed, Array Rows:49
loadtime:1.0056989192963 / seconds
TOTAL EXECUTION TIME: 1.00551
loadtime:1.0057880878448 / 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:1.0057940483093
TOTAL KEY ARRAYS: 69