DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:0.00017714500427246 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0012340545654297 / seconds
host not found setting manual db connection
loadtime:0.0022289752960205 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0027220249176025 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0029280185699463 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0029821395874023 / seconds
zipcode:
loadtime:0.003000020980835 / seconds
Query Executed:select * from search_referrer where page_hash='335a23404fa57a4b3f7aebe7f346f256' limit 10 DB:ezrox_toadli
loadtime:0.0032150745391846 / seconds
Operation header executed (non global)
loadtime:0.0032320022583008 / seconds
Operation leaderboard executed (non global)
loadtime:0.0032730102539062 / seconds
Operation square executed (non global)
loadtime:0.0032880306243896 / seconds
Operation square_bottom executed (non global)
loadtime:0.0033011436462402 / seconds
Operation smallsquare executed (non global)
loadtime:0.0033121109008789 / seconds
Operation headeradright executed (non global)
loadtime:0.0033230781555176 / seconds
Operation google_analytics executed (non global)
loadtime:0.0033340454101562 / seconds
Operation topstories executed (non global)
loadtime:0.0033462047576904 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0033571720123291 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0033671855926514 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0036730766296387 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0039889812469482 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0040881633758545 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0042381286621094 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0043330192565918 / seconds
Template key: archive_menu pushed
loadtime:0.0043461322784424 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0043621063232422 / seconds
Template key: get_gravatar pushed
loadtime:0.004371166229248 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0043840408325195 / seconds
*10)-10)+1 | start:0
loadtime:0.004439115524292 / seconds
Query loaded from cache:select * from categories where cat_URLid='cable-and-other-pay-television-services'
loadtime:0.0045680999755859 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-mexico'
loadtime:0.0046510696411133 / seconds
DB connected to localhost business_master_new
loadtime:0.0052921772003174 / seconds
Query Executed:select * from `nm_catmap` where sic='4841' order by city ascDB:business_master_new
loadtime:0.097815990447998 / seconds
Query stored in cache : _QUERY_www.toadli.com73207db9d4b462566a793675702b5daa
loadtime:0.099349021911621 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-mexico'
loadtime:0.099433183670044 / seconds
Query Executed:select sum(totalcount) as totalsum from `nm_catmap` where sic='4841'DB:business_master_new
loadtime:0.10481309890747 / seconds
Query stored in cache : _QUERY_www.toadli.com19747d347b6f7f21ae52b74fe89c7d31
loadtime:0.10489320755005 / seconds
369 / 11
loadtime:0.10497617721558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abiquiu' limit 1
loadtime:0.10508608818054 / seconds
Query Executed:select id FROM `nm` where city='Abiquiu' && SIC_code='4841'DB:business_master_new
loadtime:0.17243909835815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alameda' limit 1
loadtime:0.17256903648376 / seconds
Query Executed:select id FROM `nm` where city='Alameda' && SIC_code='4841'DB:business_master_new
loadtime:0.17486000061035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alamogordo' limit 1
loadtime:0.1749050617218 / seconds
Query Executed:select id FROM `nm` where city='Alamogordo' && SIC_code='4841'DB:business_master_new
loadtime:0.30337619781494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albuquerque' limit 1
loadtime:0.30355906486511 / seconds
Query Executed:select id FROM `nm` where city='Albuquerque' && SIC_code='4841'DB:business_master_new
loadtime:0.30563497543335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alcalde' limit 1
loadtime:0.30574011802673 / seconds
Query Executed:select id FROM `nm` where city='Alcalde' && SIC_code='4841'DB:business_master_new
loadtime:0.30677199363708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Algodones' limit 1
loadtime:0.30687499046326 / seconds
Query Executed:select id FROM `nm` where city='Algodones' && SIC_code='4841'DB:business_master_new
loadtime:0.30756807327271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alto' limit 1
loadtime:0.3076651096344 / seconds
Query Executed:select id FROM `nm` where city='Alto' && SIC_code='4841'DB:business_master_new
loadtime:0.30839204788208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amalia' limit 1
loadtime:0.30844402313232 / seconds
Query Executed:select id FROM `nm` where city='Amalia' && SIC_code='4841'DB:business_master_new
loadtime:0.31205797195435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amistad' limit 1
loadtime:0.31209301948547 / seconds
Query Executed:select id FROM `nm` where city='Amistad' && SIC_code='4841'DB:business_master_new
loadtime:0.31784105300903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Angel Fire' limit 1
loadtime:0.31789016723633 / seconds
Query Executed:select id FROM `nm` where city='Angel Fire' && SIC_code='4841'DB:business_master_new
loadtime:0.31865406036377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Animas' limit 1
loadtime:0.31873917579651 / seconds
Query Executed:select id FROM `nm` where city='Animas' && SIC_code='4841'DB:business_master_new
loadtime:0.31981706619263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anthony' limit 1
loadtime:0.31995010375977 / seconds
Query Executed:select id FROM `nm` where city='Anthony' && SIC_code='4841'DB:business_master_new
loadtime:0.32159304618835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anton Chico' limit 1
loadtime:0.32172608375549 / seconds
Query Executed:select id FROM `nm` where city='Anton Chico' && SIC_code='4841'DB:business_master_new
loadtime:0.32234406471252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aragon' limit 1
loadtime:0.32243800163269 / seconds
Query Executed:select id FROM `nm` where city='Aragon' && SIC_code='4841'DB:business_master_new
loadtime:0.32657909393311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arenas Valley' limit 1
loadtime:0.3266282081604 / seconds
Query Executed:select id FROM `nm` where city='Arenas Valley' && SIC_code='4841'DB:business_master_new
loadtime:0.32703113555908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arrey' limit 1
loadtime:0.32706618309021 / seconds
Query Executed:select id FROM `nm` where city='Arrey' && SIC_code='4841'DB:business_master_new
loadtime:0.32744407653809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arroyo Hondo' limit 1
loadtime:0.3274781703949 / seconds
Query Executed:select id FROM `nm` where city='Arroyo Hondo' && SIC_code='4841'DB:business_master_new
loadtime:0.32784700393677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arroyo Seco' limit 1
loadtime:0.3278820514679 / seconds
Query Executed:select id FROM `nm` where city='Arroyo Seco' && SIC_code='4841'DB:business_master_new
loadtime:0.32827305793762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Artesia' limit 1
loadtime:0.32832002639771 / seconds
Query Executed:select id FROM `nm` where city='Artesia' && SIC_code='4841'DB:business_master_new
loadtime:0.32904601097107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aztec' limit 1
loadtime:0.32908797264099 / seconds
Query Executed:select id FROM `nm` where city='Aztec' && SIC_code='4841'DB:business_master_new
loadtime:0.32981610298157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bard' limit 1
loadtime:0.3298671245575 / seconds
Query Executed:select id FROM `nm` where city='Bard' && SIC_code='4841'DB:business_master_new
loadtime:0.33205509185791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayard' limit 1
loadtime:0.33210420608521 / seconds
Query Executed:select id FROM `nm` where city='Bayard' && SIC_code='4841'DB:business_master_new
loadtime:0.33248400688171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belen' limit 1
loadtime:0.33252310752869 / seconds
Query Executed:select id FROM `nm` where city='Belen' && SIC_code='4841'DB:business_master_new
loadtime:0.33323407173157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bell Ranch' limit 1
loadtime:0.33328104019165 / seconds
Query Executed:select id FROM `nm` where city='Bell Ranch' && SIC_code='4841'DB:business_master_new
loadtime:0.33355498313904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bent' limit 1
loadtime:0.33358716964722 / seconds
Query Executed:select id FROM `nm` where city='Bent' && SIC_code='4841'DB:business_master_new
loadtime:0.33639311790466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berino' limit 1
loadtime:0.33643913269043 / seconds
Query Executed:select id FROM `nm` where city='Berino' && SIC_code='4841'DB:business_master_new
loadtime:0.3400411605835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bernalillo' limit 1
loadtime:0.34008097648621 / seconds
Query Executed:select id FROM `nm` where city='Bernalillo' && SIC_code='4841'DB:business_master_new
loadtime:0.34081101417542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bingham' limit 1
loadtime:0.3408579826355 / seconds
Query Executed:select id FROM `nm` where city='Bingham' && SIC_code='4841'DB:business_master_new
loadtime:0.34210515022278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanco' limit 1
loadtime:0.34214019775391 / seconds
Query Executed:select id FROM `nm` where city='Blanco' && SIC_code='4841'DB:business_master_new
loadtime:0.34250807762146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield' limit 1
loadtime:0.34257507324219 / seconds
Query Executed:select id FROM `nm` where city='Bloomfield' && SIC_code='4841'DB:business_master_new
loadtime:0.34409403800964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluewater' limit 1
loadtime:0.34422397613525 / seconds
Query Executed:select id FROM `nm` where city='Bluewater' && SIC_code='4841'DB:business_master_new
loadtime:0.34517908096313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bosque' limit 1
loadtime:0.34527611732483 / seconds
Query Executed:select id FROM `nm` where city='Bosque' && SIC_code='4841'DB:business_master_new
loadtime:0.34583020210266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bosque Farms' limit 1
loadtime:0.34593915939331 / seconds
Query Executed:select id FROM `nm` where city='Bosque Farms' && SIC_code='4841'DB:business_master_new
loadtime:0.34708714485168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brimhall' limit 1
loadtime:0.34712219238281 / seconds
Query Executed:select id FROM `nm` where city='Brimhall' && SIC_code='4841'DB:business_master_new
loadtime:0.34914517402649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadview' limit 1
loadtime:0.34919214248657 / seconds
Query Executed:select id FROM `nm` where city='Broadview' && SIC_code='4841'DB:business_master_new
loadtime:0.34953808784485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckhorn' limit 1
loadtime:0.34956502914429 / seconds
Query Executed:select id FROM `nm` where city='Buckhorn' && SIC_code='4841'DB:business_master_new
loadtime:0.35425305366516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buena Vista' limit 1
loadtime:0.35429906845093 / seconds
Query Executed:select id FROM `nm` where city='Buena Vista' && SIC_code='4841'DB:business_master_new
loadtime:0.35803508758545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caballo' limit 1
loadtime:0.35808205604553 / seconds
Query Executed:select id FROM `nm` where city='Caballo' && SIC_code='4841'DB:business_master_new
loadtime:0.35866713523865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canjilon' limit 1
loadtime:0.3587532043457 / seconds
Query Executed:select id FROM `nm` where city='Canjilon' && SIC_code='4841'DB:business_master_new
loadtime:0.36633920669556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cannon Afb' limit 1
loadtime:0.36638617515564 / seconds
Query Executed:select id FROM `nm` where city='Cannon Afb' && SIC_code='4841'DB:business_master_new
loadtime:0.36678099632263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canoncito' limit 1
loadtime:0.36682105064392 / seconds
Query Executed:select id FROM `nm` where city='Canoncito' && SIC_code='4841'DB:business_master_new
loadtime:0.36885714530945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canones' limit 1
loadtime:0.36890411376953 / seconds
Query Executed:select id FROM `nm` where city='Canones' && SIC_code='4841'DB:business_master_new
loadtime:0.37150907516479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capitan' limit 1
loadtime:0.37154507637024 / seconds
Query Executed:select id FROM `nm` where city='Capitan' && SIC_code='4841'DB:business_master_new
loadtime:0.3730251789093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caprock' limit 1
loadtime:0.37315201759338 / seconds
Query Executed:select id FROM `nm` where city='Caprock' && SIC_code='4841'DB:business_master_new
loadtime:0.37532210350037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capulin' limit 1
loadtime:0.37535715103149 / seconds
Query Executed:select id FROM `nm` where city='Capulin' && SIC_code='4841'DB:business_master_new
loadtime:0.37947106361389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlsbad' limit 1
loadtime:0.37953019142151 / seconds
Query Executed:select id FROM `nm` where city='Carlsbad' && SIC_code='4841'DB:business_master_new
loadtime:0.38047218322754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrizozo' limit 1
loadtime:0.38065910339355 / seconds
Query Executed:select id FROM `nm` where city='Carrizozo' && SIC_code='4841'DB:business_master_new
loadtime:0.38227319717407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson' limit 1
loadtime:0.38238906860352 / seconds
Query Executed:select id FROM `nm` where city='Carson' && SIC_code='4841'DB:business_master_new
loadtime:0.38753700256348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casa Blanca' limit 1
loadtime:0.38758397102356 / seconds
Query Executed:select id FROM `nm` where city='Casa Blanca' && SIC_code='4841'DB:business_master_new
loadtime:0.38797616958618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Causey' limit 1
loadtime:0.38801097869873 / seconds
Query Executed:select id FROM `nm` where city='Causey' && SIC_code='4841'DB:business_master_new
loadtime:0.39222002029419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cebolla' limit 1
loadtime:0.39226818084717 / seconds
Query Executed:select id FROM `nm` where city='Cebolla' && SIC_code='4841'DB:business_master_new
loadtime:0.39483618736267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Crest' limit 1
loadtime:0.39487099647522 / seconds
Query Executed:select id FROM `nm` where city='Cedar Crest' && SIC_code='4841'DB:business_master_new
loadtime:0.39556312561035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central' limit 1
loadtime:0.39561200141907 / seconds
Query Executed:select id FROM `nm` where city='Central' && SIC_code='4841'DB:business_master_new
loadtime:0.40005803108215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cerrillos' limit 1
loadtime:0.40009307861328 / seconds
Query Executed:select id FROM `nm` where city='Cerrillos' && SIC_code='4841'DB:business_master_new
loadtime:0.40047597885132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cerro' limit 1
loadtime:0.40052700042725 / seconds
Query Executed:select id FROM `nm` where city='Cerro' && SIC_code='4841'DB:business_master_new
loadtime:0.40578103065491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chacon' limit 1
loadtime:0.40582704544067 / seconds
Query Executed:select id FROM `nm` where city='Chacon' && SIC_code='4841'DB:business_master_new
loadtime:0.40962219238281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chama' limit 1
loadtime:0.40968203544617 / seconds
Query Executed:select id FROM `nm` where city='Chama' && SIC_code='4841'DB:business_master_new
loadtime:0.41099119186401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chamberino' limit 1
loadtime:0.41104507446289 / seconds
Query Executed:select id FROM `nm` where city='Chamberino' && SIC_code='4841'DB:business_master_new
loadtime:0.4160840511322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chamisal' limit 1
loadtime:0.41611909866333 / seconds
Query Executed:select id FROM `nm` where city='Chamisal' && SIC_code='4841'DB:business_master_new
loadtime:0.41650700569153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chaparral' limit 1
loadtime:0.41654515266418 / seconds
Query Executed:select id FROM `nm` where city='Chaparral' && SIC_code='4841'DB:business_master_new
loadtime:0.41694808006287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chimayo' limit 1
loadtime:0.41699004173279 / seconds
Query Executed:select id FROM `nm` where city='Chimayo' && SIC_code='4841'DB:business_master_new
loadtime:0.41738700866699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Church Rock' limit 1
loadtime:0.41743016242981 / seconds
Query Executed:select id FROM `nm` where city='Church Rock' && SIC_code='4841'DB:business_master_new
loadtime:0.41780400276184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cimarron' limit 1
loadtime:0.41783905029297 / seconds
Query Executed:select id FROM `nm` where city='Cimarron' && SIC_code='4841'DB:business_master_new
loadtime:0.41822910308838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claunch' limit 1
loadtime:0.41827702522278 / seconds
Query Executed:select id FROM `nm` where city='Claunch' && SIC_code='4841'DB:business_master_new
loadtime:0.42005109786987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clayton' limit 1
loadtime:0.42009997367859 / seconds
Query Executed:select id FROM `nm` where city='Clayton' && SIC_code='4841'DB:business_master_new
loadtime:0.42081999778748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.42087411880493 / seconds
Query Executed:select id FROM `nm` where city='Cleveland' && SIC_code='4841'DB:business_master_new
loadtime:0.42122197151184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cliff' limit 1
loadtime:0.42125701904297 / seconds
Query Executed:select id FROM `nm` where city='Cliff' && SIC_code='4841'DB:business_master_new
loadtime:0.42159700393677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clines Corners' limit 1
loadtime:0.42163705825806 / seconds
Query Executed:select id FROM `nm` where city='Clines Corners' && SIC_code='4841'DB:business_master_new
loadtime:0.4248731136322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cloudcroft' limit 1
loadtime:0.42490816116333 / seconds
Query Executed:select id FROM `nm` where city='Cloudcroft' && SIC_code='4841'DB:business_master_new
loadtime:0.42561197280884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clovis' limit 1
loadtime:0.42566704750061 / seconds
Query Executed:select id FROM `nm` where city='Clovis' && SIC_code='4841'DB:business_master_new
loadtime:0.42636704444885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cochiti Lake' limit 1
loadtime:0.42641019821167 / seconds
Query Executed:select id FROM `nm` where city='Cochiti Lake' && SIC_code='4841'DB:business_master_new
loadtime:0.43149709701538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cochiti Pueblo' limit 1
loadtime:0.43154501914978 / seconds
Query Executed:select id FROM `nm` where city='Cochiti Pueblo' && SIC_code='4841'DB:business_master_new
loadtime:0.4358081817627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:0.43584418296814 / seconds
Query Executed:select id FROM `nm` where city='Columbus' && SIC_code='4841'DB:business_master_new
loadtime:0.43623805046082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conchas Dam' limit 1
loadtime:0.4362850189209 / seconds
Query Executed:select id FROM `nm` where city='Conchas Dam' && SIC_code='4841'DB:business_master_new
loadtime:0.43661904335022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Continental Div' limit 1
loadtime:0.43665504455566 / seconds
Query Executed:select id FROM `nm` where city='Continental Div' && SIC_code='4841'DB:business_master_new
loadtime:0.43689608573914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Continental Divide' limit 1
loadtime:0.43692111968994 / seconds
Query Executed:select id FROM `nm` where city='Continental Divide' && SIC_code='4841'DB:business_master_new
loadtime:0.44231700897217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cordova' limit 1
loadtime:0.44236397743225 / seconds
Query Executed:select id FROM `nm` where city='Cordova' && SIC_code='4841'DB:business_master_new
loadtime:0.44272518157959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corona' limit 1
loadtime:0.44275212287903 / seconds
Query Executed:select id FROM `nm` where city='Corona' && SIC_code='4841'DB:business_master_new
loadtime:0.44312119483948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corrales' limit 1
loadtime:0.44316816329956 / seconds
Query Executed:select id FROM `nm` where city='Corrales' && SIC_code='4841'DB:business_master_new
loadtime:0.44389915466309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Costilla' limit 1
loadtime:0.44393420219421 / seconds
Query Executed:select id FROM `nm` where city='Costilla' && SIC_code='4841'DB:business_master_new
loadtime:0.4443039894104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Counselor' limit 1
loadtime:0.4443531036377 / seconds
Query Executed:select id FROM `nm` where city='Counselor' && SIC_code='4841'DB:business_master_new
loadtime:0.44818902015686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coyote' limit 1
loadtime:0.44823813438416 / seconds
Query Executed:select id FROM `nm` where city='Coyote' && SIC_code='4841'DB:business_master_new
loadtime:0.44861006736755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crossroads' limit 1
loadtime:0.44863820075989 / seconds
Query Executed:select id FROM `nm` where city='Crossroads' && SIC_code='4841'DB:business_master_new
loadtime:0.45118999481201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crownpoint' limit 1
loadtime:0.45123720169067 / seconds
Query Executed:select id FROM `nm` where city='Crownpoint' && SIC_code='4841'DB:business_master_new
loadtime:0.45160698890686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuba' limit 1
loadtime:0.45163416862488 / seconds
Query Executed:select id FROM `nm` where city='Cuba' && SIC_code='4841'DB:business_master_new
loadtime:0.45233201980591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cubero' limit 1
loadtime:0.4523811340332 / seconds
Query Executed:select id FROM `nm` where city='Cubero' && SIC_code='4841'DB:business_master_new
loadtime:0.45272207260132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuchillo' limit 1
loadtime:0.45274901390076 / seconds
Query Executed:select id FROM `nm` where city='Cuchillo' && SIC_code='4841'DB:business_master_new
loadtime:0.45390915870667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuervo' limit 1
loadtime:0.45395803451538 / seconds
Query Executed:select id FROM `nm` where city='Cuervo' && SIC_code='4841'DB:business_master_new
loadtime:0.45636320114136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Datil' limit 1
loadtime:0.45639801025391 / seconds
Query Executed:select id FROM `nm` where city='Datil' && SIC_code='4841'DB:business_master_new
loadtime:0.45679306983948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deming' limit 1
loadtime:0.45684099197388 / seconds
Query Executed:select id FROM `nm` where city='Deming' && SIC_code='4841'DB:business_master_new
loadtime:0.45837306976318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derry' limit 1
loadtime:0.45858097076416 / seconds
Query Executed:select id FROM `nm` where city='Derry' && SIC_code='4841'DB:business_master_new
loadtime:0.46048498153687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Des Moines' limit 1
loadtime:0.46053218841553 / seconds
Query Executed:select id FROM `nm` where city='Des Moines' && SIC_code='4841'DB:business_master_new
loadtime:0.46091413497925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dexter' limit 1
loadtime:0.46096014976501 / seconds
Query Executed:select id FROM `nm` where city='Dexter' && SIC_code='4841'DB:business_master_new
loadtime:0.46164512634277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dixon' limit 1
loadtime:0.46169209480286 / seconds
Query Executed:select id FROM `nm` where city='Dixon' && SIC_code='4841'DB:business_master_new
loadtime:0.46204900741577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dona Ana' limit 1
loadtime:0.4620840549469 / seconds
Query Executed:select id FROM `nm` where city='Dona Ana' && SIC_code='4841'DB:business_master_new
loadtime:0.46242809295654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dora' limit 1
loadtime:0.46246218681335 / seconds
Query Executed:select id FROM `nm` where city='Dora' && SIC_code='4841'DB:business_master_new
loadtime:0.46284103393555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dulce' limit 1
loadtime:0.46287608146667 / seconds
Query Executed:select id FROM `nm` where city='Dulce' && SIC_code='4841'DB:business_master_new
loadtime:0.46326303482056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duran' limit 1
loadtime:0.46330118179321 / seconds
Query Executed:select id FROM `nm` where city='Duran' && SIC_code='4841'DB:business_master_new
loadtime:0.46490216255188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Nest' limit 1
loadtime:0.46493697166443 / seconds
Query Executed:select id FROM `nm` where city='Eagle Nest' && SIC_code='4841'DB:business_master_new
loadtime:0.46532297134399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewood' limit 1
loadtime:0.46536207199097 / seconds
Query Executed:select id FROM `nm` where city='Edgewood' && SIC_code='4841'DB:business_master_new
loadtime:0.46608400344849 / seconds
Query loaded from cache:select * from geodata_geocity where city='El Prado' limit 1
loadtime:0.46613001823425 / seconds
Query Executed:select id FROM `nm` where city='El Prado' && SIC_code='4841'DB:business_master_new
loadtime:0.46687006950378 / seconds
Query loaded from cache:select * from geodata_geocity where city='El Rito' limit 1
loadtime:0.46690511703491 / seconds
Query Executed:select id FROM `nm` where city='El Rito' && SIC_code='4841'DB:business_master_new
loadtime:0.46727919578552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elephant Butte' limit 1
loadtime:0.46731901168823 / seconds
Query Executed:select id FROM `nm` where city='Elephant Butte' && SIC_code='4841'DB:business_master_new
loadtime:0.4677140712738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elida' limit 1
loadtime:0.46774911880493 / seconds
Query Executed:select id FROM `nm` where city='Elida' && SIC_code='4841'DB:business_master_new
loadtime:0.46813607215881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Embudo' limit 1
loadtime:0.46818208694458 / seconds
Query Executed:select id FROM `nm` where city='Embudo' && SIC_code='4841'DB:business_master_new
loadtime:0.46850609779358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Encino' limit 1
loadtime:0.4685320854187 / seconds
Query Executed:select id FROM `nm` where city='Encino' && SIC_code='4841'DB:business_master_new
loadtime:0.46887707710266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Espanola' limit 1
loadtime:0.46892499923706 / seconds
Query Executed:select id FROM `nm` where city='Espanola' && SIC_code='4841'DB:business_master_new
loadtime:0.46961808204651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estancia' limit 1
loadtime:0.46965718269348 / seconds
Query Executed:select id FROM `nm` where city='Estancia' && SIC_code='4841'DB:business_master_new
loadtime:0.47006297111511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eunice' limit 1
loadtime:0.47011208534241 / seconds
Query Executed:select id FROM `nm` where city='Eunice' && SIC_code='4841'DB:business_master_new
loadtime:0.47083616256714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairacres' limit 1
loadtime:0.47088503837585 / seconds
Query Executed:select id FROM `nm` where city='Fairacres' && SIC_code='4841'DB:business_master_new
loadtime:0.47125911712646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:0.47128701210022 / seconds
Query Executed:select id FROM `nm` where city='Fairview' && SIC_code='4841'DB:business_master_new
loadtime:0.47251415252686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.47256112098694 / seconds
Query Executed:select id FROM `nm` where city='Farmington' && SIC_code='4841'DB:business_master_new
loadtime:0.47333598136902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faywood' limit 1
loadtime:0.47339105606079 / seconds
Query Executed:select id FROM `nm` where city='Faywood' && SIC_code='4841'DB:business_master_new
loadtime:0.47811818122864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fence Lake' limit 1
loadtime:0.47815299034119 / seconds
Query Executed:select id FROM `nm` where city='Fence Lake' && SIC_code='4841'DB:business_master_new
loadtime:0.48229598999023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flora Vista' limit 1
loadtime:0.48234510421753 / seconds
Query Executed:select id FROM `nm` where city='Flora Vista' && SIC_code='4841'DB:business_master_new
loadtime:0.48279500007629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Floyd' limit 1
loadtime:0.48282909393311 / seconds
Query Executed:select id FROM `nm` where city='Floyd' && SIC_code='4841'DB:business_master_new
loadtime:0.48319101333618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flying H' limit 1
loadtime:0.48323702812195 / seconds
Query Executed:select id FROM `nm` where city='Flying H' && SIC_code='4841'DB:business_master_new
loadtime:0.48374700546265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Folsom' limit 1
loadtime:0.4837920665741 / seconds
Query Executed:select id FROM `nm` where city='Folsom' && SIC_code='4841'DB:business_master_new
loadtime:0.48418116569519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Bayard' limit 1
loadtime:0.48421716690063 / seconds
Query Executed:select id FROM `nm` where city='Fort Bayard' && SIC_code='4841'DB:business_master_new
loadtime:0.48745107650757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Stanton' limit 1
loadtime:0.48751020431519 / seconds
Query Executed:select id FROM `nm` where city='Fort Stanton' && SIC_code='4841'DB:business_master_new
loadtime:0.49138116836548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Sumner' limit 1
loadtime:0.49141597747803 / seconds
Query Executed:select id FROM `nm` where city='Fort Sumner' && SIC_code='4841'DB:business_master_new
loadtime:0.49213910102844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Wingate' limit 1
loadtime:0.49218606948853 / seconds
Query Executed:select id FROM `nm` where city='Fort Wingate' && SIC_code='4841'DB:business_master_new
loadtime:0.49254107475281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitland' limit 1
loadtime:0.49256706237793 / seconds
Query Executed:select id FROM `nm` where city='Fruitland' && SIC_code='4841'DB:business_master_new
loadtime:0.49293112754822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gallina' limit 1
loadtime:0.49298000335693 / seconds
Query Executed:select id FROM `nm` where city='Gallina' && SIC_code='4841'DB:business_master_new
loadtime:0.49332499504089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gallup' limit 1
loadtime:0.49335098266602 / seconds
Query Executed:select id FROM `nm` where city='Gallup' && SIC_code='4841'DB:business_master_new
loadtime:0.49408006668091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gamerco' limit 1
loadtime:0.49413514137268 / seconds
Query Executed:select id FROM `nm` where city='Gamerco' && SIC_code='4841'DB:business_master_new
loadtime:0.49450397491455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garfield' limit 1
loadtime:0.49454998970032 / seconds
Query Executed:select id FROM `nm` where city='Garfield' && SIC_code='4841'DB:business_master_new
loadtime:0.50238800048828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garita' limit 1
loadtime:0.50243520736694 / seconds
Query Executed:select id FROM `nm` where city='Garita' && SIC_code='4841'DB:business_master_new
loadtime:0.5030620098114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gila' limit 1
loadtime:0.50309705734253 / seconds
Query Executed:select id FROM `nm` where city='Gila' && SIC_code='4841'DB:business_master_new
loadtime:0.50343203544617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladstone' limit 1
loadtime:0.50347018241882 / seconds
Query Executed:select id FROM `nm` where city='Gladstone' && SIC_code='4841'DB:business_master_new
loadtime:0.50507998466492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glencoe' limit 1
loadtime:0.50512909889221 / seconds
Query Executed:select id FROM `nm` where city='Glencoe' && SIC_code='4841'DB:business_master_new
loadtime:0.50843620300293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:0.50848317146301 / seconds
Query Executed:select id FROM `nm` where city='Glenwood' && SIC_code='4841'DB:business_master_new
loadtime:0.50937104225159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glorieta' limit 1
loadtime:0.50946712493896 / seconds
Query Executed:select id FROM `nm` where city='Glorieta' && SIC_code='4841'DB:business_master_new
loadtime:0.51047897338867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grady' limit 1
loadtime:0.51061797142029 / seconds
Query Executed:select id FROM `nm` where city='Grady' && SIC_code='4841'DB:business_master_new
loadtime:0.51164197921753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grants' limit 1
loadtime:0.51173710823059 / seconds
Query Executed:select id FROM `nm` where city='Grants' && SIC_code='4841'DB:business_master_new
loadtime:0.5136981010437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grenville' limit 1
loadtime:0.51384520530701 / seconds
Query Executed:select id FROM `nm` where city='Grenville' && SIC_code='4841'DB:business_master_new
loadtime:0.5181131362915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guadalupita' limit 1
loadtime:0.51814818382263 / seconds
Query Executed:select id FROM `nm` where city='Guadalupita' && SIC_code='4841'DB:business_master_new
loadtime:0.52346301078796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hachita' limit 1
loadtime:0.52352118492126 / seconds
Query Executed:select id FROM `nm` where city='Hachita' && SIC_code='4841'DB:business_master_new
loadtime:0.52682018280029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hagerman' limit 1
loadtime:0.52686715126038 / seconds
Query Executed:select id FROM `nm` where city='Hagerman' && SIC_code='4841'DB:business_master_new
loadtime:0.52727508544922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.52731800079346 / seconds
Query Executed:select id FROM `nm` where city='Hanover' && SIC_code='4841'DB:business_master_new
loadtime:0.52766609191895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatch' limit 1
loadtime:0.52769303321838 / seconds
Query Executed:select id FROM `nm` where city='Hatch' && SIC_code='4841'DB:business_master_new
loadtime:0.52839303016663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hernandez' limit 1
loadtime:0.52843999862671 / seconds
Query Executed:select id FROM `nm` where city='Hernandez' && SIC_code='4841'DB:business_master_new
loadtime:0.5288200378418 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Rls Mtn Pk' limit 1
loadtime:0.52885508537292 / seconds
Query Executed:select id FROM `nm` where city='High Rls Mtn Pk' && SIC_code='4841'DB:business_master_new
loadtime:0.53006720542908 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Rolls Mountain Park' limit 1
loadtime:0.53011608123779 / seconds
Query Executed:select id FROM `nm` where city='High Rolls Mountain Park' && SIC_code='4841'DB:business_master_new
loadtime:0.53050398826599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:0.53054118156433 / seconds
Query Executed:select id FROM `nm` where city='Hillsboro' && SIC_code='4841'DB:business_master_new
loadtime:0.53089618682861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hobbs' limit 1
loadtime:0.53094220161438 / seconds
Query Executed:select id FROM `nm` where city='Hobbs' && SIC_code='4841'DB:business_master_new
loadtime:0.53164005279541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holloman Afb' limit 1
loadtime:0.53168416023254 / seconds
Query Executed:select id FROM `nm` where city='Holloman Afb' && SIC_code='4841'DB:business_master_new
loadtime:0.53206014633179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holloman Air Force Base' limit 1
loadtime:0.5321090221405 / seconds
Query Executed:select id FROM `nm` where city='Holloman Air Force Base' && SIC_code='4841'DB:business_master_new
loadtime:0.53250813484192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holman' limit 1
loadtime:0.532546043396 / seconds
Query Executed:select id FROM `nm` where city='Holman' && SIC_code='4841'DB:business_master_new
loadtime:0.5388011932373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hondo' limit 1
loadtime:0.53883719444275 / seconds
Query Executed:select id FROM `nm` where city='Hondo' && SIC_code='4841'DB:business_master_new
loadtime:0.53921914100647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hope' limit 1
loadtime:0.53926610946655 / seconds
Query Executed:select id FROM `nm` where city='Hope' && SIC_code='4841'DB:business_master_new
loadtime:0.53963303565979 / seconds
Query loaded from cache:select * from geodata_geocity where city='House' limit 1
loadtime:0.53966999053955 / seconds
Query Executed:select id FROM `nm` where city='House' && SIC_code='4841'DB:business_master_new
loadtime:0.54001307487488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:0.54004812240601 / seconds
Query Executed:select id FROM `nm` where city='Hurley' && SIC_code='4841'DB:business_master_new
loadtime:0.54038500785828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isleta' limit 1
loadtime:0.5404200553894 / seconds
Query Executed:select id FROM `nm` where city='Isleta' && SIC_code='4841'DB:business_master_new
loadtime:0.54078698158264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jal' limit 1
loadtime:0.54082298278809 / seconds
Query Executed:select id FROM `nm` where city='Jal' && SIC_code='4841'DB:business_master_new
loadtime:0.54152011871338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:0.54156708717346 / seconds
Query Executed:select id FROM `nm` where city='Jamestown' && SIC_code='4841'DB:business_master_new
loadtime:0.54735207557678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jarales' limit 1
loadtime:0.54739999771118 / seconds
Query Executed:select id FROM `nm` where city='Jarales' && SIC_code='4841'DB:business_master_new
loadtime:0.54780006408691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jemez Pueblo' limit 1
loadtime:0.54783415794373 / seconds
Query Executed:select id FROM `nm` where city='Jemez Pueblo' && SIC_code='4841'DB:business_master_new
loadtime:0.54823517799377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jemez Springs' limit 1
loadtime:0.54828405380249 / seconds
Query Executed:select id FROM `nm` where city='Jemez Springs' && SIC_code='4841'DB:business_master_new
loadtime:0.54866719245911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenna' limit 1
loadtime:0.54869413375854 / seconds
Query Executed:select id FROM `nm` where city='Kenna' && SIC_code='4841'DB:business_master_new
loadtime:0.54983401298523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirtland' limit 1
loadtime:0.54988098144531 / seconds
Query Executed:select id FROM `nm` where city='Kirtland' && SIC_code='4841'DB:business_master_new
loadtime:0.55059099197388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirtland Afb' limit 1
loadtime:0.550626039505 / seconds
Query Executed:select id FROM `nm` where city='Kirtland Afb' && SIC_code='4841'DB:business_master_new
loadtime:0.55100512504578 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Jara' limit 1
loadtime:0.55105209350586 / seconds
Query Executed:select id FROM `nm` where city='La Jara' && SIC_code='4841'DB:business_master_new
loadtime:0.5531861782074 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Joya' limit 1
loadtime:0.55322098731995 / seconds
Query Executed:select id FROM `nm` where city='La Joya' && SIC_code='4841'DB:business_master_new
loadtime:0.55525207519531 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Loma' limit 1
loadtime:0.5552990436554 / seconds
Query Executed:select id FROM `nm` where city='La Loma' && SIC_code='4841'DB:business_master_new
loadtime:0.55629205703735 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Luz' limit 1
loadtime:0.55633902549744 / seconds
Query Executed:select id FROM `nm` where city='La Luz' && SIC_code='4841'DB:business_master_new
loadtime:0.55673313140869 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Madera' limit 1
loadtime:0.55676007270813 / seconds
Query Executed:select id FROM `nm` where city='La Madera' && SIC_code='4841'DB:business_master_new
loadtime:0.55939602851868 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Mesa' limit 1
loadtime:0.55944299697876 / seconds
Query Executed:select id FROM `nm` where city='La Mesa' && SIC_code='4841'DB:business_master_new
loadtime:0.55983901023865 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Plata' limit 1
loadtime:0.55987405776978 / seconds
Query Executed:select id FROM `nm` where city='La Plata' && SIC_code='4841'DB:business_master_new
loadtime:0.56026315689087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laguna' limit 1
loadtime:0.56031012535095 / seconds
Query Executed:select id FROM `nm` where city='Laguna' && SIC_code='4841'DB:business_master_new
loadtime:0.56065917015076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lajoya' limit 1
loadtime:0.56068515777588 / seconds
Query Executed:select id FROM `nm` where city='Lajoya' && SIC_code='4841'DB:business_master_new
loadtime:0.56092309951782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Arthur' limit 1
loadtime:0.56095814704895 / seconds
Query Executed:select id FROM `nm` where city='Lake Arthur' && SIC_code='4841'DB:business_master_new
loadtime:0.56130504608154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakewood' limit 1
loadtime:0.56132912635803 / seconds
Query Executed:select id FROM `nm` where city='Lakewood' && SIC_code='4841'DB:business_master_new
loadtime:0.56167197227478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamy' limit 1
loadtime:0.56170701980591 / seconds
Query Executed:select id FROM `nm` where city='Lamy' && SIC_code='4841'DB:business_master_new
loadtime:0.56209111213684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Las Cruces' limit 1
loadtime:0.56213402748108 / seconds
Query Executed:select id FROM `nm` where city='Las Cruces' && SIC_code='4841'DB:business_master_new
loadtime:0.56286597251892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Las Vegas' limit 1
loadtime:0.56290912628174 / seconds
Query Executed:select id FROM `nm` where city='Las Vegas' && SIC_code='4841'DB:business_master_new
loadtime:0.56359505653381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemitar' limit 1
loadtime:0.56364917755127 / seconds
Query Executed:select id FROM `nm` where city='Lemitar' && SIC_code='4841'DB:business_master_new
loadtime:0.56399703025818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.56403207778931 / seconds
Query Executed:select id FROM `nm` where city='Lincoln' && SIC_code='4841'DB:business_master_new
loadtime:0.56436610221863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lindrith' limit 1
loadtime:0.56440114974976 / seconds
Query Executed:select id FROM `nm` where city='Lindrith' && SIC_code='4841'DB:business_master_new
loadtime:0.56473708152771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Llano' limit 1
loadtime:0.56476211547852 / seconds
Query Executed:select id FROM `nm` where city='Llano' && SIC_code='4841'DB:business_master_new
loadtime:0.56623697280884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loco Hills' limit 1
loadtime:0.5662829875946 / seconds
Query Executed:select id FROM `nm` where city='Loco Hills' && SIC_code='4841'DB:business_master_new
loadtime:0.56683301925659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Logan' limit 1
loadtime:0.56686902046204 / seconds
Query Executed:select id FROM `nm` where city='Logan' && SIC_code='4841'DB:business_master_new
loadtime:0.56728005409241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lordsburg' limit 1
loadtime:0.5673291683197 / seconds
Query Executed:select id FROM `nm` where city='Lordsburg' && SIC_code='4841'DB:business_master_new
loadtime:0.56806802749634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Los Alamos' limit 1
loadtime:0.56812405586243 / seconds
Query Executed:select id FROM `nm` where city='Los Alamos' && SIC_code='4841'DB:business_master_new
loadtime:0.568843126297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Los Lunas' limit 1
loadtime:0.56888508796692 / seconds
Query Executed:select id FROM `nm` where city='Los Lunas' && SIC_code='4841'DB:business_master_new
loadtime:0.56957602500916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Los Ojos' limit 1
loadtime:0.56963109970093 / seconds
Query Executed:select id FROM `nm` where city='Los Ojos' && SIC_code='4841'DB:business_master_new
loadtime:0.57000398635864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loving' limit 1
loadtime:0.57003903388977 / seconds
Query Executed:select id FROM `nm` where city='Loving' && SIC_code='4841'DB:business_master_new
loadtime:0.5704140663147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovington' limit 1
loadtime:0.57044816017151 / seconds
Query Executed:select id FROM `nm` where city='Lovington' && SIC_code='4841'DB:business_master_new
loadtime:0.57117605209351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lumberton' limit 1
loadtime:0.57121801376343 / seconds
Query Executed:select id FROM `nm` where city='Lumberton' && SIC_code='4841'DB:business_master_new
loadtime:0.57196402549744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luna' limit 1
loadtime:0.57201099395752 / seconds
Query Executed:select id FROM `nm` where city='Luna' && SIC_code='4841'DB:business_master_new
loadtime:0.5723831653595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magdalena' limit 1
loadtime:0.57240915298462 / seconds
Query Executed:select id FROM `nm` where city='Magdalena' && SIC_code='4841'DB:business_master_new
loadtime:0.57280397415161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malaga' limit 1
loadtime:0.57284998893738 / seconds
Query Executed:select id FROM `nm` where city='Malaga' && SIC_code='4841'DB:business_master_new
loadtime:0.57558703422546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maljamar' limit 1
loadtime:0.57563400268555 / seconds
Query Executed:select id FROM `nm` where city='Maljamar' && SIC_code='4841'DB:business_master_new
loadtime:0.5760190486908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxwell' limit 1
loadtime:0.57605314254761 / seconds
Query Executed:select id FROM `nm` where city='Maxwell' && SIC_code='4841'DB:business_master_new
loadtime:0.57638907432556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayhill' limit 1
loadtime:0.57642602920532 / seconds
Query Executed:select id FROM `nm` where city='Mayhill' && SIC_code='4841'DB:business_master_new
loadtime:0.57680416107178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Alister' limit 1
loadtime:0.57683801651001 / seconds
Query Executed:select id FROM `nm` where city='Mc Alister' && SIC_code='4841'DB:business_master_new
loadtime:0.57708501815796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Donald' limit 1
loadtime:0.57712602615356 / seconds
Query Executed:select id FROM `nm` where city='Mc Donald' && SIC_code='4841'DB:business_master_new
loadtime:0.57840299606323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Intosh' limit 1
loadtime:0.57844305038452 / seconds
Query Executed:select id FROM `nm` where city='Mc Intosh' && SIC_code='4841'DB:business_master_new
loadtime:0.57880711555481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medanales' limit 1
loadtime:0.57885313034058 / seconds
Query Executed:select id FROM `nm` where city='Medanales' && SIC_code='4841'DB:business_master_new
loadtime:0.58031320571899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melrose' limit 1
loadtime:0.58036303520203 / seconds
Query Executed:select id FROM `nm` where city='Melrose' && SIC_code='4841'DB:business_master_new
loadtime:0.58078002929688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mentmore' limit 1
loadtime:0.58083510398865 / seconds
Query Executed:select id FROM `nm` where city='Mentmore' && SIC_code='4841'DB:business_master_new
loadtime:0.58627104759216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mescalero' limit 1
loadtime:0.58630609512329 / seconds
Query Executed:select id FROM `nm` where city='Mescalero' && SIC_code='4841'DB:business_master_new
loadtime:0.58730101585388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesilla' limit 1
loadtime:0.58742809295654 / seconds
Query Executed:select id FROM `nm` where city='Mesilla' && SIC_code='4841'DB:business_master_new
loadtime:0.58856511116028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesilla Park' limit 1
loadtime:0.58865904808044 / seconds
Query Executed:select id FROM `nm` where city='Mesilla Park' && SIC_code='4841'DB:business_master_new
loadtime:0.58972406387329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesquite' limit 1
loadtime:0.58985114097595 / seconds
Query Executed:select id FROM `nm` where city='Mesquite' && SIC_code='4841'DB:business_master_new
loadtime:0.59071111679077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mexican Springs' limit 1
loadtime:0.5907461643219 / seconds
Query Executed:select id FROM `nm` where city='Mexican Springs' && SIC_code='4841'DB:business_master_new
loadtime:0.59099507331848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miami' limit 1
loadtime:0.59103298187256 / seconds
Query Executed:select id FROM `nm` where city='Miami' && SIC_code='4841'DB:business_master_new
loadtime:0.59431505203247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milan' limit 1
loadtime:0.5943660736084 / seconds
Query Executed:select id FROM `nm` where city='Milan' && SIC_code='4841'DB:business_master_new
loadtime:0.59511303901672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mills' limit 1
loadtime:0.59514904022217 / seconds
Query Executed:select id FROM `nm` where city='Mills' && SIC_code='4841'DB:business_master_new
loadtime:0.59728097915649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milnesand' limit 1
loadtime:0.59733104705811 / seconds
Query Executed:select id FROM `nm` where city='Milnesand' && SIC_code='4841'DB:business_master_new
loadtime:0.60267901420593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mimbres' limit 1
loadtime:0.60272598266602 / seconds
Query Executed:select id FROM `nm` where city='Mimbres' && SIC_code='4841'DB:business_master_new
loadtime:0.60312509536743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mogollon' limit 1
loadtime:0.60316014289856 / seconds
Query Executed:select id FROM `nm` where city='Mogollon' && SIC_code='4841'DB:business_master_new
loadtime:0.60339903831482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montezuma' limit 1
loadtime:0.60343408584595 / seconds
Query Executed:select id FROM `nm` where city='Montezuma' && SIC_code='4841'DB:business_master_new
loadtime:0.60832810401917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:0.60837817192078 / seconds
Query Executed:select id FROM `nm` where city='Monticello' && SIC_code='4841'DB:business_master_new
loadtime:0.61107206344604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monument' limit 1
loadtime:0.61110806465149 / seconds
Query Executed:select id FROM `nm` where city='Monument' && SIC_code='4841'DB:business_master_new
loadtime:0.61145520210266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mora' limit 1
loadtime:0.61151218414307 / seconds
Query Executed:select id FROM `nm` where city='Mora' && SIC_code='4841'DB:business_master_new
loadtime:0.61191606521606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moriarty' limit 1
loadtime:0.61196303367615 / seconds
Query Executed:select id FROM `nm` where city='Moriarty' && SIC_code='4841'DB:business_master_new
loadtime:0.61266303062439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mosquero' limit 1
loadtime:0.61270403862 / seconds
Query Executed:select id FROM `nm` where city='Mosquero' && SIC_code='4841'DB:business_master_new
loadtime:0.61309909820557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountainair' limit 1
loadtime:0.61314606666565 / seconds
Query Executed:select id FROM `nm` where city='Mountainair' && SIC_code='4841'DB:business_master_new
loadtime:0.61351919174194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mule Creek' limit 1
loadtime:0.61354613304138 / seconds
Query Executed:select id FROM `nm` where city='Mule Creek' && SIC_code='4841'DB:business_master_new
loadtime:0.61643719673157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nageezi' limit 1
loadtime:0.61648416519165 / seconds
Query Executed:select id FROM `nm` where city='Nageezi' && SIC_code='4841'DB:business_master_new
loadtime:0.62286400794983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nara Visa' limit 1
loadtime:0.62291097640991 / seconds
Query Executed:select id FROM `nm` where city='Nara Visa' && SIC_code='4841'DB:business_master_new
loadtime:0.62374997138977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Navajo' limit 1
loadtime:0.6238431930542 / seconds
Query Executed:select id FROM `nm` where city='Navajo' && SIC_code='4841'DB:business_master_new
loadtime:0.62446999549866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Navajo Dam' limit 1
loadtime:0.62463212013245 / seconds
Query Executed:select id FROM `nm` where city='Navajo Dam' && SIC_code='4841'DB:business_master_new
loadtime:0.62559199333191 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Laguna' limit 1
loadtime:0.62562704086304 / seconds
Query Executed:select id FROM `nm` where city='New Laguna' && SIC_code='4841'DB:business_master_new
loadtime:0.6286940574646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newcomb' limit 1
loadtime:0.62874007225037 / seconds
Query Executed:select id FROM `nm` where city='Newcomb' && SIC_code='4841'DB:business_master_new
loadtime:0.62912011146545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newkirk' limit 1
loadtime:0.62915515899658 / seconds
Query Executed:select id FROM `nm` where city='Newkirk' && SIC_code='4841'DB:business_master_new
loadtime:0.6315221786499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nogal' limit 1
loadtime:0.63156819343567 / seconds
Query Executed:select id FROM `nm` where city='Nogal' && SIC_code='4841'DB:business_master_new
loadtime:0.63236713409424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocate' limit 1
loadtime:0.63246512413025 / seconds
Query Executed:select id FROM `nm` where city='Ocate' && SIC_code='4841'DB:business_master_new
loadtime:0.63674402236938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ojo Caliente' limit 1
loadtime:0.63679099082947 / seconds
Query Executed:select id FROM `nm` where city='Ojo Caliente' && SIC_code='4841'DB:business_master_new
loadtime:0.63761305809021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ojo Feliz' limit 1
loadtime:0.63774704933167 / seconds
Query Executed:select id FROM `nm` where city='Ojo Feliz' && SIC_code='4841'DB:business_master_new
loadtime:0.63846516609192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ojo Sarco' limit 1
loadtime:0.63851404190063 / seconds
Query Executed:select id FROM `nm` where city='Ojo Sarco' && SIC_code='4841'DB:business_master_new
loadtime:0.63982105255127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Organ' limit 1
loadtime:0.63986802101135 / seconds
Query Executed:select id FROM `nm` where city='Organ' && SIC_code='4841'DB:business_master_new
loadtime:0.6402530670166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orogrande' limit 1
loadtime:0.64028811454773 / seconds
Query Executed:select id FROM `nm` where city='Orogrande' && SIC_code='4841'DB:business_master_new
loadtime:0.64307904243469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paguate' limit 1
loadtime:0.64312505722046 / seconds
Query Executed:select id FROM `nm` where city='Paguate' && SIC_code='4841'DB:business_master_new
loadtime:0.64475703239441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pecos' limit 1
loadtime:0.64479207992554 / seconds
Query Executed:select id FROM `nm` where city='Pecos' && SIC_code='4841'DB:business_master_new
loadtime:0.64575719833374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pena Blanca' limit 1
loadtime:0.64585399627686 / seconds
Query Executed:select id FROM `nm` where city='Pena Blanca' && SIC_code='4841'DB:business_master_new
loadtime:0.64640402793884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penasco' limit 1
loadtime:0.64657115936279 / seconds
Query Executed:select id FROM `nm` where city='Penasco' && SIC_code='4841'DB:business_master_new
loadtime:0.64748907089233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pep' limit 1
loadtime:0.64762115478516 / seconds
Query Executed:select id FROM `nm` where city='Pep' && SIC_code='4841'DB:business_master_new
loadtime:0.64984107017517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peralta' limit 1
loadtime:0.64988803863525 / seconds
Query Executed:select id FROM `nm` where city='Peralta' && SIC_code='4841'DB:business_master_new
loadtime:0.65031003952026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petaca' limit 1
loadtime:0.65034508705139 / seconds
Query Executed:select id FROM `nm` where city='Petaca' && SIC_code='4841'DB:business_master_new
loadtime:0.65123105049133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Picacho' limit 1
loadtime:0.6512770652771 / seconds
Query Executed:select id FROM `nm` where city='Picacho' && SIC_code='4841'DB:business_master_new
loadtime:0.65454411506653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pie Town' limit 1
loadtime:0.65458011627197 / seconds
Query Executed:select id FROM `nm` where city='Pie Town' && SIC_code='4841'DB:business_master_new
loadtime:0.65494203567505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinehill' limit 1
loadtime:0.65498900413513 / seconds
Query Executed:select id FROM `nm` where city='Pinehill' && SIC_code='4841'DB:business_master_new
loadtime:0.65536117553711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinon' limit 1
loadtime:0.65539503097534 / seconds
Query Executed:select id FROM `nm` where city='Pinon' && SIC_code='4841'DB:business_master_new
loadtime:0.65991997718811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinos Altos' limit 1
loadtime:0.65996718406677 / seconds
Query Executed:select id FROM `nm` where city='Pinos Altos' && SIC_code='4841'DB:business_master_new
loadtime:0.66683316230774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Placitas' limit 1
loadtime:0.66688013076782 / seconds
Query Executed:select id FROM `nm` where city='Placitas' && SIC_code='4841'DB:business_master_new
loadtime:0.66758799552917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Playas' limit 1
loadtime:0.66763210296631 / seconds
Query Executed:select id FROM `nm` where city='Playas' && SIC_code='4841'DB:business_master_new
loadtime:0.67045617103577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pojoaque Valley' limit 1
loadtime:0.67051815986633 / seconds
Query Executed:select id FROM `nm` where city='Pojoaque Valley' && SIC_code='4841'DB:business_master_new
loadtime:0.67256307601929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polvadera' limit 1
loadtime:0.67259812355042 / seconds
Query Executed:select id FROM `nm` where city='Polvadera' && SIC_code='4841'DB:business_master_new
loadtime:0.67759203910828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ponderosa' limit 1
loadtime:0.67763900756836 / seconds
Query Executed:select id FROM `nm` where city='Ponderosa' && SIC_code='4841'DB:business_master_new
loadtime:0.68239307403564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portales' limit 1
loadtime:0.68243312835693 / seconds
Query Executed:select id FROM `nm` where city='Portales' && SIC_code='4841'DB:business_master_new
loadtime:0.68393111228943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prewitt' limit 1
loadtime:0.68399405479431 / seconds
Query Executed:select id FROM `nm` where city='Prewitt' && SIC_code='4841'DB:business_master_new
loadtime:0.68436002731323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pueblo Of Acoma' limit 1
loadtime:0.68439602851868 / seconds
Query Executed:select id FROM `nm` where city='Pueblo Of Acoma' && SIC_code='4841'DB:business_master_new
loadtime:0.68478798866272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quay' limit 1
loadtime:0.68483519554138 / seconds
Query Executed:select id FROM `nm` where city='Quay' && SIC_code='4841'DB:business_master_new
loadtime:0.68625402450562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quemado' limit 1
loadtime:0.68630218505859 / seconds
Query Executed:select id FROM `nm` where city='Quemado' && SIC_code='4841'DB:business_master_new
loadtime:0.6866819858551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Questa' limit 1
loadtime:0.68670916557312 / seconds
Query Executed:select id FROM `nm` where city='Questa' && SIC_code='4841'DB:business_master_new
loadtime:0.68710803985596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radium Springs' limit 1
loadtime:0.68715405464172 / seconds
Query Executed:select id FROM `nm` where city='Radium Springs' && SIC_code='4841'DB:business_master_new
loadtime:0.6933970451355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rainsville' limit 1
loadtime:0.69343209266663 / seconds
Query Executed:select id FROM `nm` where city='Rainsville' && SIC_code='4841'DB:business_master_new
loadtime:0.6941831111908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramah' limit 1
loadtime:0.69422912597656 / seconds
Query Executed:select id FROM `nm` where city='Ramah' && SIC_code='4841'DB:business_master_new
loadtime:0.6946280002594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ranchos De Taos' limit 1
loadtime:0.69466114044189 / seconds
Query Executed:select id FROM `nm` where city='Ranchos De Taos' && SIC_code='4841'DB:business_master_new
loadtime:0.69536018371582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raton' limit 1
loadtime:0.6954071521759 / seconds
Query Executed:select id FROM `nm` where city='Raton' && SIC_code='4841'DB:business_master_new
loadtime:0.69612216949463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red River' limit 1
loadtime:0.69616413116455 / seconds
Query Executed:select id FROM `nm` where city='Red River' && SIC_code='4841'DB:business_master_new
loadtime:0.6968731880188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redrock' limit 1
loadtime:0.69691920280457 / seconds
Query Executed:select id FROM `nm` where city='Redrock' && SIC_code='4841'DB:business_master_new
loadtime:0.69931602478027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Regina' limit 1
loadtime:0.69936299324036 / seconds
Query Executed:select id FROM `nm` where city='Regina' && SIC_code='4841'DB:business_master_new
loadtime:0.70239210128784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rehoboth' limit 1
loadtime:0.70242810249329 / seconds
Query Executed:select id FROM `nm` where city='Rehoboth' && SIC_code='4841'DB:business_master_new
loadtime:0.70583009719849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reserve' limit 1
loadtime:0.70587611198425 / seconds
Query Executed:select id FROM `nm` where city='Reserve' && SIC_code='4841'DB:business_master_new
loadtime:0.70628499984741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ribera' limit 1
loadtime:0.70632004737854 / seconds
Query Executed:select id FROM `nm` where city='Ribera' && SIC_code='4841'DB:business_master_new
loadtime:0.70667815208435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rincon' limit 1
loadtime:0.70672011375427 / seconds
Query Executed:select id FROM `nm` where city='Rincon' && SIC_code='4841'DB:business_master_new
loadtime:0.71175003051758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio Rancho' limit 1
loadtime:0.71178507804871 / seconds
Query Executed:select id FROM `nm` where city='Rio Rancho' && SIC_code='4841'DB:business_master_new
loadtime:0.7125129699707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rociada' limit 1
loadtime:0.71257019042969 / seconds
Query Executed:select id FROM `nm` where city='Rociada' && SIC_code='4841'DB:business_master_new
loadtime:0.71665406227112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rodeo' limit 1
loadtime:0.7167010307312 / seconds
Query Executed:select id FROM `nm` where city='Rodeo' && SIC_code='4841'DB:business_master_new
loadtime:0.72643613815308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rogers' limit 1
loadtime:0.72648501396179 / seconds
Query Executed:select id FROM `nm` where city='Rogers' && SIC_code='4841'DB:business_master_new
loadtime:0.73056817054749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roswell' limit 1
loadtime:0.73060417175293 / seconds
Query Executed:select id FROM `nm` where city='Roswell' && SIC_code='4841'DB:business_master_new
loadtime:0.73198318481445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowe' limit 1
loadtime:0.73203802108765 / seconds
Query Executed:select id FROM `nm` where city='Rowe' && SIC_code='4841'DB:business_master_new
loadtime:0.73250198364258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roy' limit 1
loadtime:0.73253798484802 / seconds
Query Executed:select id FROM `nm` where city='Roy' && SIC_code='4841'DB:business_master_new
loadtime:0.73290920257568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruidoso' limit 1
loadtime:0.7329580783844 / seconds
Query Executed:select id FROM `nm` where city='Ruidoso' && SIC_code='4841'DB:business_master_new
loadtime:0.7336630821228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruidoso Downs' limit 1
loadtime:0.73370718955994 / seconds
Query Executed:select id FROM `nm` where city='Ruidoso Downs' && SIC_code='4841'DB:business_master_new
loadtime:0.73442912101746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutheron' limit 1
loadtime:0.73447704315186 / seconds
Query Executed:select id FROM `nm` where city='Rutheron' && SIC_code='4841'DB:business_master_new
loadtime:0.73601007461548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sacramento' limit 1
loadtime:0.73604512214661 / seconds
Query Executed:select id FROM `nm` where city='Sacramento' && SIC_code='4841'DB:business_master_new
loadtime:0.74156403541565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Vrain' limit 1
loadtime:0.74165010452271 / seconds
Query Executed:select id FROM `nm` where city='Saint Vrain' && SIC_code='4841'DB:business_master_new
loadtime:0.74231505393982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.74235916137695 / seconds
Query Executed:select id FROM `nm` where city='Salem' && SIC_code='4841'DB:business_master_new
loadtime:0.74272799491882 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Acacia' limit 1
loadtime:0.74276208877563 / seconds
Query Executed:select id FROM `nm` where city='San Acacia' && SIC_code='4841'DB:business_master_new
loadtime:0.74766802787781 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Antonio' limit 1
loadtime:0.747798204422 / seconds
Query Executed:select id FROM `nm` where city='San Antonio' && SIC_code='4841'DB:business_master_new
loadtime:0.74850702285767 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Cristobal' limit 1
loadtime:0.74858808517456 / seconds
Query Executed:select id FROM `nm` where city='San Cristobal' && SIC_code='4841'DB:business_master_new
loadtime:0.75600600242615 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Fidel' limit 1
loadtime:0.75605297088623 / seconds
Query Executed:select id FROM `nm` where city='San Fidel' && SIC_code='4841'DB:business_master_new
loadtime:0.75645112991333 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Jon' limit 1
loadtime:0.75648617744446 / seconds
Query Executed:select id FROM `nm` where city='San Jon' && SIC_code='4841'DB:business_master_new
loadtime:0.75687098503113 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Jose' limit 1
loadtime:0.75691914558411 / seconds
Query Executed:select id FROM `nm` where city='San Jose' && SIC_code='4841'DB:business_master_new
loadtime:0.76041698455811 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Juan Pueblo' limit 1
loadtime:0.76045203208923 / seconds
Query Executed:select id FROM `nm` where city='San Juan Pueblo' && SIC_code='4841'DB:business_master_new
loadtime:0.76085615158081 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Lorenzo' limit 1
loadtime:0.76090312004089 / seconds
Query Executed:select id FROM `nm` where city='San Lorenzo' && SIC_code='4841'DB:business_master_new
loadtime:0.76189398765564 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Miguel' limit 1
loadtime:0.7619411945343 / seconds
Query Executed:select id FROM `nm` where city='San Miguel' && SIC_code='4841'DB:business_master_new
loadtime:0.76231408119202 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Patricio' limit 1
loadtime:0.76234912872314 / seconds
Query Executed:select id FROM `nm` where city='San Patricio' && SIC_code='4841'DB:business_master_new
loadtime:0.76272797584534 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Rafael' limit 1
loadtime:0.76276898384094 / seconds
Query Executed:select id FROM `nm` where city='San Rafael' && SIC_code='4841'DB:business_master_new
loadtime:0.76567411422729 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Ysidro' limit 1
loadtime:0.7657151222229 / seconds
Query Executed:select id FROM `nm` where city='San Ysidro' && SIC_code='4841'DB:business_master_new
loadtime:0.76634407043457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandia Park' limit 1
loadtime:0.76639199256897 / seconds
Query Executed:select id FROM `nm` where city='Sandia Park' && SIC_code='4841'DB:business_master_new
loadtime:0.76729202270508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanostee' limit 1
loadtime:0.76738715171814 / seconds
Query Executed:select id FROM `nm` where city='Sanostee' && SIC_code='4841'DB:business_master_new
loadtime:0.77209115028381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Clara' limit 1
loadtime:0.77214002609253 / seconds
Query Executed:select id FROM `nm` where city='Santa Clara' && SIC_code='4841'DB:business_master_new
loadtime:0.77250909805298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Cruz' limit 1
loadtime:0.77253603935242 / seconds
Query Executed:select id FROM `nm` where city='Santa Cruz' && SIC_code='4841'DB:business_master_new
loadtime:0.77292799949646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Fe' limit 1
loadtime:0.77297616004944 / seconds
Query Executed:select id FROM `nm` where city='Santa Fe' && SIC_code='4841'DB:business_master_new
loadtime:0.77366900444031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Rosa' limit 1
loadtime:0.77371501922607 / seconds
Query Executed:select id FROM `nm` where city='Santa Rosa' && SIC_code='4841'DB:business_master_new
loadtime:0.77440309524536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Teresa' limit 1
loadtime:0.77443909645081 / seconds
Query Executed:select id FROM `nm` where city='Santa Teresa' && SIC_code='4841'DB:business_master_new
loadtime:0.77515912055969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santo Domingo Pb' limit 1
loadtime:0.77520704269409 / seconds
Query Executed:select id FROM `nm` where city='Santo Domingo Pb' && SIC_code='4841'DB:business_master_new
loadtime:0.77545714378357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santo Domingo Pueblo' limit 1
loadtime:0.77548408508301 / seconds
Query Executed:select id FROM `nm` where city='Santo Domingo Pueblo' && SIC_code='4841'DB:business_master_new
loadtime:0.78315019607544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sapello' limit 1
loadtime:0.78319907188416 / seconds
Query Executed:select id FROM `nm` where city='Sapello' && SIC_code='4841'DB:business_master_new
loadtime:0.78383803367615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seboyeta' limit 1
loadtime:0.78386616706848 / seconds
Query Executed:select id FROM `nm` where city='Seboyeta' && SIC_code='4841'DB:business_master_new
loadtime:0.78488707542419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedan' limit 1
loadtime:0.78493309020996 / seconds
Query Executed:select id FROM `nm` where city='Sedan' && SIC_code='4841'DB:business_master_new
loadtime:0.79075717926025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:0.79080319404602 / seconds
Query Executed:select id FROM `nm` where city='Seneca' && SIC_code='4841'DB:business_master_new
loadtime:0.79138112068176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Serafina' limit 1
loadtime:0.79142713546753 / seconds
Query Executed:select id FROM `nm` where city='Serafina' && SIC_code='4841'DB:business_master_new
loadtime:0.79354810714722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheep Springs' limit 1
loadtime:0.79359412193298 / seconds
Query Executed:select id FROM `nm` where city='Sheep Springs' && SIC_code='4841'DB:business_master_new
loadtime:0.79592704772949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shiprock' limit 1
loadtime:0.79596209526062 / seconds
Query Executed:select id FROM `nm` where city='Shiprock' && SIC_code='4841'DB:business_master_new
loadtime:0.79666805267334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver City' limit 1
loadtime:0.79671502113342 / seconds
Query Executed:select id FROM `nm` where city='Silver City' && SIC_code='4841'DB:business_master_new
loadtime:0.7974271774292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smith Lake' limit 1
loadtime:0.79746913909912 / seconds
Query Executed:select id FROM `nm` where city='Smith Lake' && SIC_code='4841'DB:business_master_new
loadtime:0.79869318008423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Socorro' limit 1
loadtime:0.79874014854431 / seconds
Query Executed:select id FROM `nm` where city='Socorro' && SIC_code='4841'DB:business_master_new
loadtime:0.79945206642151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Solano' limit 1
loadtime:0.79951000213623 / seconds
Query Executed:select id FROM `nm` where city='Solano' && SIC_code='4841'DB:business_master_new
loadtime:0.80137610435486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springer' limit 1
loadtime:0.80142498016357 / seconds
Query Executed:select id FROM `nm` where city='Springer' && SIC_code='4841'DB:business_master_new
loadtime:0.80185413360596 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Vrain' limit 1
loadtime:0.80190014839172 / seconds
Query Executed:select id FROM `nm` where city='St Vrain' && SIC_code='4841'DB:business_master_new
loadtime:0.80214309692383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:0.80216908454895 / seconds
Query Executed:select id FROM `nm` where city='Stanley' && SIC_code='4841'DB:business_master_new
loadtime:0.80251097679138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunland Park' limit 1
loadtime:0.80255508422852 / seconds
Query Executed:select id FROM `nm` where city='Sunland Park' && SIC_code='4841'DB:business_master_new
loadtime:0.8029670715332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunspot' limit 1
loadtime:0.80300712585449 / seconds
Query Executed:select id FROM `nm` where city='Sunspot' && SIC_code='4841'DB:business_master_new
loadtime:0.80696105957031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taiban' limit 1
loadtime:0.80701208114624 / seconds
Query Executed:select id FROM `nm` where city='Taiban' && SIC_code='4841'DB:business_master_new
loadtime:0.80835819244385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tajique' limit 1
loadtime:0.8083930015564 / seconds
Query Executed:select id FROM `nm` where city='Tajique' && SIC_code='4841'DB:business_master_new
loadtime:0.80957007408142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taos' limit 1
loadtime:0.80962109565735 / seconds
Query Executed:select id FROM `nm` where city='Taos' && SIC_code='4841'DB:business_master_new
loadtime:0.81142807006836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taos Ski Valley' limit 1
loadtime:0.8116340637207 / seconds
Query Executed:select id FROM `nm` where city='Taos Ski Valley' && SIC_code='4841'DB:business_master_new
loadtime:0.81271815299988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tatum' limit 1
loadtime:0.81281518936157 / seconds
Query Executed:select id FROM `nm` where city='Tatum' && SIC_code='4841'DB:business_master_new
loadtime:0.81370615959167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tererro' limit 1
loadtime:0.81375598907471 / seconds
Query Executed:select id FROM `nm` where city='Tererro' && SIC_code='4841'DB:business_master_new
loadtime:0.8163800239563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tesuque' limit 1
loadtime:0.81641507148743 / seconds
Query Executed:select id FROM `nm` where city='Tesuque' && SIC_code='4841'DB:business_master_new
loadtime:0.81682419776917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Texico' limit 1
loadtime:0.8168740272522 / seconds
Query Executed:select id FROM `nm` where city='Texico' && SIC_code='4841'DB:business_master_new
loadtime:0.81726217269897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thoreau' limit 1
loadtime:0.81729698181152 / seconds
Query Executed:select id FROM `nm` where city='Thoreau' && SIC_code='4841'DB:business_master_new
loadtime:0.81768703460693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tierra Amarilla' limit 1
loadtime:0.81772613525391 / seconds
Query Executed:select id FROM `nm` where city='Tierra Amarilla' && SIC_code='4841'DB:business_master_new
loadtime:0.81811809539795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tijeras' limit 1
loadtime:0.81815314292908 / seconds
Query Executed:select id FROM `nm` where city='Tijeras' && SIC_code='4841'DB:business_master_new
loadtime:0.81888604164124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timberon' limit 1
loadtime:0.81893610954285 / seconds
Query Executed:select id FROM `nm` where city='Timberon' && SIC_code='4841'DB:business_master_new
loadtime:0.81930613517761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tinnie' limit 1
loadtime:0.81934905052185 / seconds
Query Executed:select id FROM `nm` where city='Tinnie' && SIC_code='4841'DB:business_master_new
loadtime:0.82334399223328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tohatchi' limit 1
loadtime:0.8233790397644 / seconds
Query Executed:select id FROM `nm` where city='Tohatchi' && SIC_code='4841'DB:business_master_new
loadtime:0.82379198074341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tome' limit 1
loadtime:0.82383918762207 / seconds
Query Executed:select id FROM `nm` where city='Tome' && SIC_code='4841'DB:business_master_new
loadtime:0.82419419288635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Torreon' limit 1
loadtime:0.8242290019989 / seconds
Query Executed:select id FROM `nm` where city='Torreon' && SIC_code='4841'DB:business_master_new
loadtime:0.82456707954407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trampas' limit 1
loadtime:0.82460808753967 / seconds
Query Executed:select id FROM `nm` where city='Trampas' && SIC_code='4841'DB:business_master_new
loadtime:0.82513999938965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trementina' limit 1
loadtime:0.82517504692078 / seconds
Query Executed:select id FROM `nm` where city='Trementina' && SIC_code='4841'DB:business_master_new
loadtime:0.82765197753906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tres Piedras' limit 1
loadtime:0.82769918441772 / seconds
Query Executed:select id FROM `nm` where city='Tres Piedras' && SIC_code='4841'DB:business_master_new
loadtime:0.82855606079102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truchas' limit 1
loadtime:0.82867097854614 / seconds
Query Executed:select id FROM `nm` where city='Truchas' && SIC_code='4841'DB:business_master_new
loadtime:0.82964015007019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truth Or Cnsqncs' limit 1
loadtime:0.82976603507996 / seconds
Query Executed:select id FROM `nm` where city='Truth Or Cnsqncs' && SIC_code='4841'DB:business_master_new
loadtime:0.83350801467896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truth Or Consequences' limit 1
loadtime:0.83355617523193 / seconds
Query Executed:select id FROM `nm` where city='Truth Or Consequences' && SIC_code='4841'DB:business_master_new
loadtime:0.83426809310913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tucumcari' limit 1
loadtime:0.83431220054626 / seconds
Query Executed:select id FROM `nm` where city='Tucumcari' && SIC_code='4841'DB:business_master_new
loadtime:0.83504819869995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tularosa' limit 1
loadtime:0.83510303497314 / seconds
Query Executed:select id FROM `nm` where city='Tularosa' && SIC_code='4841'DB:business_master_new
loadtime:0.83581900596619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyrone' limit 1
loadtime:0.83585500717163 / seconds
Query Executed:select id FROM `nm` where city='Tyrone' && SIC_code='4841'DB:business_master_new
loadtime:0.83652806282043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ute Park' limit 1
loadtime:0.83657503128052 / seconds
Query Executed:select id FROM `nm` where city='Ute Park' && SIC_code='4841'DB:business_master_new
loadtime:0.83691906929016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vadito' limit 1
loadtime:0.83695411682129 / seconds
Query Executed:select id FROM `nm` where city='Vadito' && SIC_code='4841'DB:business_master_new
loadtime:0.83727097511292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vado' limit 1
loadtime:0.83730912208557 / seconds
Query Executed:select id FROM `nm` where city='Vado' && SIC_code='4841'DB:business_master_new
loadtime:0.83801817893982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valdez' limit 1
loadtime:0.83805298805237 / seconds
Query Executed:select id FROM `nm` where city='Valdez' && SIC_code='4841'DB:business_master_new
loadtime:0.83839011192322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vallecitos' limit 1
loadtime:0.83842897415161 / seconds
Query Executed:select id FROM `nm` where city='Vallecitos' && SIC_code='4841'DB:business_master_new
loadtime:0.83880805969238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valmora' limit 1
loadtime:0.83885717391968 / seconds
Query Executed:select id FROM `nm` where city='Valmora' && SIC_code='4841'DB:business_master_new
loadtime:0.83982014656067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vanderwagen' limit 1
loadtime:0.8398551940918 / seconds
Query Executed:select id FROM `nm` where city='Vanderwagen' && SIC_code='4841'DB:business_master_new
loadtime:0.84053111076355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vaughn' limit 1
loadtime:0.84057807922363 / seconds
Query Executed:select id FROM `nm` where city='Vaughn' && SIC_code='4841'DB:business_master_new
loadtime:0.84126615524292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Veguita' limit 1
loadtime:0.84130120277405 / seconds
Query Executed:select id FROM `nm` where city='Veguita' && SIC_code='4841'DB:business_master_new
loadtime:0.84163904190063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Velarde' limit 1
loadtime:0.84167814254761 / seconds
Query Executed:select id FROM `nm` where city='Velarde' && SIC_code='4841'DB:business_master_new
loadtime:0.84236812591553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villanueva' limit 1
loadtime:0.84240317344666 / seconds
Query Executed:select id FROM `nm` where city='Villanueva' && SIC_code='4841'DB:business_master_new
loadtime:0.8427791595459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wagon Mound' limit 1
loadtime:0.8428270816803 / seconds
Query Executed:select id FROM `nm` where city='Wagon Mound' && SIC_code='4841'DB:business_master_new
loadtime:0.84352016448975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterflow' limit 1
loadtime:0.84356117248535 / seconds
Query Executed:select id FROM `nm` where city='Waterflow' && SIC_code='4841'DB:business_master_new
loadtime:0.84425115585327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watrous' limit 1
loadtime:0.84429717063904 / seconds
Query Executed:select id FROM `nm` where city='Watrous' && SIC_code='4841'DB:business_master_new
loadtime:0.84463715553284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weed' limit 1
loadtime:0.8446741104126 / seconds
Query Executed:select id FROM `nm` where city='Weed' && SIC_code='4841'DB:business_master_new
loadtime:0.8450391292572 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Sands' limit 1
loadtime:0.84507298469543 / seconds
Query Executed:select id FROM `nm` where city='White Sands' && SIC_code='4841'DB:business_master_new
loadtime:0.84538698196411 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Sands Missile Range' limit 1
loadtime:0.84542298316956 / seconds
Query Executed:select id FROM `nm` where city='White Sands Missile Range' && SIC_code='4841'DB:business_master_new
loadtime:0.84577417373657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whites City' limit 1
loadtime:0.84580898284912 / seconds
Query Executed:select id FROM `nm` where city='Whites City' && SIC_code='4841'DB:business_master_new
loadtime:0.84613919258118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willard' limit 1
loadtime:0.84618616104126 / seconds
Query Executed:select id FROM `nm` where city='Willard' && SIC_code='4841'DB:business_master_new
loadtime:0.84649920463562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:0.84652709960938 / seconds
Query Executed:select id FROM `nm` where city='Williamsburg' && SIC_code='4841'DB:business_master_new
loadtime:0.84722518920898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winston' limit 1
loadtime:0.84727215766907 / seconds
Query Executed:select id FROM `nm` where city='Winston' && SIC_code='4841'DB:business_master_new
loadtime:0.84760808944702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yatahey' limit 1
loadtime:0.84764719009399 / seconds
Query Executed:select id FROM `nm` where city='Yatahey' && SIC_code='4841'DB:business_master_new
loadtime:0.84799909591675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yeso' limit 1
loadtime:0.84803414344788 / seconds
Query Executed:select id FROM `nm` where city='Yeso' && SIC_code='4841'DB:business_master_new
loadtime:0.84836912155151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Youngsville' limit 1
loadtime:0.84840607643127 / seconds
Query Executed:select id FROM `nm` where city='Youngsville' && SIC_code='4841'DB:business_master_new
loadtime:0.84871006011963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zuni' limit 1
loadtime:0.84873604774475 / seconds
Query Executed:select id FROM `nm` where city='Zuni' && SIC_code='4841'DB:business_master_new
loadtime:0.84941005706787 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.84952020645142 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.84969997406006 / seconds
Operation template executed (chunk cache operation)
loadtime:0.84987902641296 / seconds
template override:Default
loadtime:0.84992504119873 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:0.85116910934448 / seconds
Template Constructed, Array Rows:49
loadtime:0.85140419006348 / seconds
TOTAL EXECUTION TIME: 0.85122
loadtime:0.85149216651917 / 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] => cable-and-other-pay-television-services [stateURLid] => new-mexico )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:0.85149812698364
TOTAL KEY ARRAYS: 69