Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:6.3896179199219E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0017449855804443 / seconds
host not found setting manual db connection
loadtime:0.0095279216766357 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0097320079803467 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0099098682403564 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0099728107452393 / seconds
zipcode:
loadtime:0.010000944137573 / seconds
Query Executed:select * from search_referrer where page_hash='b4f60ccd6113e5bfc80b55485d05b7df' limit 10 DB:ezrox_toadli
loadtime:0.010240793228149 / seconds
Operation header executed (non global)
loadtime:0.0102698802948 / seconds
Operation leaderboard executed (non global)
loadtime:0.010320901870728 / seconds
Operation square executed (non global)
loadtime:0.010349988937378 / seconds
Operation square_bottom executed (non global)
loadtime:0.010384798049927 / seconds
Operation smallsquare executed (non global)
loadtime:0.010414838790894 / seconds
Operation headeradright executed (non global)
loadtime:0.010440826416016 / seconds
Operation google_analytics executed (non global)
loadtime:0.010465860366821 / seconds
Operation topstories executed (non global)
loadtime:0.010490894317627 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010518789291382 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010542869567871 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010814905166626 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011025905609131 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011060953140259 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011119842529297 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011168003082275 / seconds
Template key: archive_menu pushed
loadtime:0.011176824569702 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011190891265869 / seconds
Template key: get_gravatar pushed
loadtime:0.011197805404663 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011217832565308 / seconds
*10)-10)+1 | start:0
loadtime:0.011259794235229 / seconds
Query loaded from cache:select * from categories where cat_URLid='grocery-stores'
loadtime:0.011302947998047 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-mexico'
loadtime:0.011337995529175 / seconds
DB connected to localhost business_master_new
loadtime:0.011595964431763 / seconds
Query Executed:select * from `nm_catmap` where sic='5411' order by city ascDB:business_master_new
loadtime:0.028843879699707 / seconds
Query stored in cache : _QUERY_www.toadli.com993fd7fc592882449be6cb89f7bc125c
loadtime:0.030321836471558 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-mexico'
loadtime:0.030382871627808 / seconds
Query Executed:select sum(totalcount) as totalsum from `nm_catmap` where sic='5411'DB:business_master_new
loadtime:0.032344818115234 / seconds
Query stored in cache : _QUERY_www.toadli.comf50a14524b7cdaf0249b9795c9d459cd
loadtime:0.03238582611084 / seconds
369 / 11
loadtime:0.032441854476929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abiquiu' limit 1
loadtime:0.032508850097656 / seconds
Query Executed:select id FROM `nm` where city='Abiquiu' && SIC_code='5411'DB:business_master_new
loadtime:0.051774978637695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alameda' limit 1
loadtime:0.051849842071533 / seconds
Query Executed:select id FROM `nm` where city='Alameda' && SIC_code='5411'DB:business_master_new
loadtime:0.052254915237427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alamogordo' limit 1
loadtime:0.052309989929199 / seconds
Query Executed:select id FROM `nm` where city='Alamogordo' && SIC_code='5411'DB:business_master_new
loadtime:0.073227882385254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albuquerque' limit 1
loadtime:0.073407888412476 / seconds
Query Executed:select id FROM `nm` where city='Albuquerque' && SIC_code='5411'DB:business_master_new
loadtime:0.086555957794189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alcalde' limit 1
loadtime:0.086943864822388 / seconds
Query Executed:select id FROM `nm` where city='Alcalde' && SIC_code='5411'DB:business_master_new
loadtime:0.087788820266724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Algodones' limit 1
loadtime:0.087876796722412 / seconds
Query Executed:select id FROM `nm` where city='Algodones' && SIC_code='5411'DB:business_master_new
loadtime:0.098859786987305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alto' limit 1
loadtime:0.098928928375244 / seconds
Query Executed:select id FROM `nm` where city='Alto' && SIC_code='5411'DB:business_master_new
loadtime:0.10216879844666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amalia' limit 1
loadtime:0.10223698616028 / seconds
Query Executed:select id FROM `nm` where city='Amalia' && SIC_code='5411'DB:business_master_new
loadtime:0.10266399383545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amistad' limit 1
loadtime:0.10271787643433 / seconds
Query Executed:select id FROM `nm` where city='Amistad' && SIC_code='5411'DB:business_master_new
loadtime:0.10319185256958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Angel Fire' limit 1
loadtime:0.10324287414551 / seconds
Query Executed:select id FROM `nm` where city='Angel Fire' && SIC_code='5411'DB:business_master_new
loadtime:0.10847592353821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Animas' limit 1
loadtime:0.1085479259491 / seconds
Query Executed:select id FROM `nm` where city='Animas' && SIC_code='5411'DB:business_master_new
loadtime:0.10945582389832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anthony' limit 1
loadtime:0.10953283309937 / seconds
Query Executed:select id FROM `nm` where city='Anthony' && SIC_code='5411'DB:business_master_new
loadtime:0.11350989341736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anton Chico' limit 1
loadtime:0.11358594894409 / seconds
Query Executed:select id FROM `nm` where city='Anton Chico' && SIC_code='5411'DB:business_master_new
loadtime:0.11426997184753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aragon' limit 1
loadtime:0.11434388160706 / seconds
Query Executed:select id FROM `nm` where city='Aragon' && SIC_code='5411'DB:business_master_new
loadtime:0.1147608757019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arenas Valley' limit 1
loadtime:0.11482882499695 / seconds
Query Executed:select id FROM `nm` where city='Arenas Valley' && SIC_code='5411'DB:business_master_new
loadtime:0.11563301086426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arrey' limit 1
loadtime:0.11568689346313 / seconds
Query Executed:select id FROM `nm` where city='Arrey' && SIC_code='5411'DB:business_master_new
loadtime:0.11629986763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arroyo Hondo' limit 1
loadtime:0.11636781692505 / seconds
Query Executed:select id FROM `nm` where city='Arroyo Hondo' && SIC_code='5411'DB:business_master_new
loadtime:0.11709380149841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arroyo Seco' limit 1
loadtime:0.11715984344482 / seconds
Query Executed:select id FROM `nm` where city='Arroyo Seco' && SIC_code='5411'DB:business_master_new
loadtime:0.11837196350098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Artesia' limit 1
loadtime:0.11842489242554 / seconds
Query Executed:select id FROM `nm` where city='Artesia' && SIC_code='5411'DB:business_master_new
loadtime:0.12867593765259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aztec' limit 1
loadtime:0.12877082824707 / seconds
Query Executed:select id FROM `nm` where city='Aztec' && SIC_code='5411'DB:business_master_new
loadtime:0.1377158164978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bard' limit 1
loadtime:0.13779783248901 / seconds
Query Executed:select id FROM `nm` where city='Bard' && SIC_code='5411'DB:business_master_new
loadtime:0.13823294639587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayard' limit 1
loadtime:0.13829588890076 / seconds
Query Executed:select id FROM `nm` where city='Bayard' && SIC_code='5411'DB:business_master_new
loadtime:0.14088487625122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belen' limit 1
loadtime:0.14095687866211 / seconds
Query Executed:select id FROM `nm` where city='Belen' && SIC_code='5411'DB:business_master_new
loadtime:0.15133285522461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bell Ranch' limit 1
loadtime:0.15141987800598 / seconds
Query Executed:select id FROM `nm` where city='Bell Ranch' && SIC_code='5411'DB:business_master_new
loadtime:0.15180087089539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bent' limit 1
loadtime:0.15185594558716 / seconds
Query Executed:select id FROM `nm` where city='Bent' && SIC_code='5411'DB:business_master_new
loadtime:0.15228080749512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berino' limit 1
loadtime:0.15234184265137 / seconds
Query Executed:select id FROM `nm` where city='Berino' && SIC_code='5411'DB:business_master_new
loadtime:0.1528148651123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bernalillo' limit 1
loadtime:0.15286588668823 / seconds
Query Executed:select id FROM `nm` where city='Bernalillo' && SIC_code='5411'DB:business_master_new
loadtime:0.15920686721802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bingham' limit 1
loadtime:0.15929794311523 / seconds
Query Executed:select id FROM `nm` where city='Bingham' && SIC_code='5411'DB:business_master_new
loadtime:0.15968179702759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanco' limit 1
loadtime:0.15973591804504 / seconds
Query Executed:select id FROM `nm` where city='Blanco' && SIC_code='5411'DB:business_master_new
loadtime:0.16038584709167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield' limit 1
loadtime:0.16045784950256 / seconds
Query Executed:select id FROM `nm` where city='Bloomfield' && SIC_code='5411'DB:business_master_new
loadtime:0.16740489006042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluewater' limit 1
loadtime:0.16749382019043 / seconds
Query Executed:select id FROM `nm` where city='Bluewater' && SIC_code='5411'DB:business_master_new
loadtime:0.16805386543274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bosque' limit 1
loadtime:0.1681079864502 / seconds
Query Executed:select id FROM `nm` where city='Bosque' && SIC_code='5411'DB:business_master_new
loadtime:0.1687228679657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bosque Farms' limit 1
loadtime:0.16878795623779 / seconds
Query Executed:select id FROM `nm` where city='Bosque Farms' && SIC_code='5411'DB:business_master_new
loadtime:0.17248892784119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brimhall' limit 1
loadtime:0.17255592346191 / seconds
Query Executed:select id FROM `nm` where city='Brimhall' && SIC_code='5411'DB:business_master_new
loadtime:0.17295789718628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadview' limit 1
loadtime:0.17300891876221 / seconds
Query Executed:select id FROM `nm` where city='Broadview' && SIC_code='5411'DB:business_master_new
loadtime:0.17354893684387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckhorn' limit 1
loadtime:0.17361497879028 / seconds
Query Executed:select id FROM `nm` where city='Buckhorn' && SIC_code='5411'DB:business_master_new
loadtime:0.17408990859985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buena Vista' limit 1
loadtime:0.1741418838501 / seconds
Query Executed:select id FROM `nm` where city='Buena Vista' && SIC_code='5411'DB:business_master_new
loadtime:0.17461180686951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caballo' limit 1
loadtime:0.17466497421265 / seconds
Query Executed:select id FROM `nm` where city='Caballo' && SIC_code='5411'DB:business_master_new
loadtime:0.17530488967896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canjilon' limit 1
loadtime:0.17537093162537 / seconds
Query Executed:select id FROM `nm` where city='Canjilon' && SIC_code='5411'DB:business_master_new
loadtime:0.17591691017151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cannon Afb' limit 1
loadtime:0.17596888542175 / seconds
Query Executed:select id FROM `nm` where city='Cannon Afb' && SIC_code='5411'DB:business_master_new
loadtime:0.1877429485321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canoncito' limit 1
loadtime:0.18781185150146 / seconds
Query Executed:select id FROM `nm` where city='Canoncito' && SIC_code='5411'DB:business_master_new
loadtime:0.18819499015808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canones' limit 1
loadtime:0.18824696540833 / seconds
Query Executed:select id FROM `nm` where city='Canones' && SIC_code='5411'DB:business_master_new
loadtime:0.18866491317749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capitan' limit 1
loadtime:0.18871688842773 / seconds
Query Executed:select id FROM `nm` where city='Capitan' && SIC_code='5411'DB:business_master_new
loadtime:0.1920108795166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caprock' limit 1
loadtime:0.19208288192749 / seconds
Query Executed:select id FROM `nm` where city='Caprock' && SIC_code='5411'DB:business_master_new
loadtime:0.19251990318298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capulin' limit 1
loadtime:0.19257378578186 / seconds
Query Executed:select id FROM `nm` where city='Capulin' && SIC_code='5411'DB:business_master_new
loadtime:0.19305396080017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlsbad' limit 1
loadtime:0.19311881065369 / seconds
Query Executed:select id FROM `nm` where city='Carlsbad' && SIC_code='5411'DB:business_master_new
loadtime:0.21144080162048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrizozo' limit 1
loadtime:0.21156191825867 / seconds
Query Executed:select id FROM `nm` where city='Carrizozo' && SIC_code='5411'DB:business_master_new
loadtime:0.21463894844055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson' limit 1
loadtime:0.21471285820007 / seconds
Query Executed:select id FROM `nm` where city='Carson' && SIC_code='5411'DB:business_master_new
loadtime:0.21518397331238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casa Blanca' limit 1
loadtime:0.21524882316589 / seconds
Query Executed:select id FROM `nm` where city='Casa Blanca' && SIC_code='5411'DB:business_master_new
loadtime:0.21587181091309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Causey' limit 1
loadtime:0.21593880653381 / seconds
Query Executed:select id FROM `nm` where city='Causey' && SIC_code='5411'DB:business_master_new
loadtime:0.21645498275757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cebolla' limit 1
loadtime:0.21651101112366 / seconds
Query Executed:select id FROM `nm` where city='Cebolla' && SIC_code='5411'DB:business_master_new
loadtime:0.21695590019226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Crest' limit 1
loadtime:0.21700692176819 / seconds
Query Executed:select id FROM `nm` where city='Cedar Crest' && SIC_code='5411'DB:business_master_new
loadtime:0.22035789489746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central' limit 1
loadtime:0.22042679786682 / seconds
Query Executed:select id FROM `nm` where city='Central' && SIC_code='5411'DB:business_master_new
loadtime:0.22085285186768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cerrillos' limit 1
loadtime:0.22090578079224 / seconds
Query Executed:select id FROM `nm` where city='Cerrillos' && SIC_code='5411'DB:business_master_new
loadtime:0.22307395935059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cerro' limit 1
loadtime:0.2231388092041 / seconds
Query Executed:select id FROM `nm` where city='Cerro' && SIC_code='5411'DB:business_master_new
loadtime:0.22360682487488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chacon' limit 1
loadtime:0.22367191314697 / seconds
Query Executed:select id FROM `nm` where city='Chacon' && SIC_code='5411'DB:business_master_new
loadtime:0.22408890724182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chama' limit 1
loadtime:0.22413992881775 / seconds
Query Executed:select id FROM `nm` where city='Chama' && SIC_code='5411'DB:business_master_new
loadtime:0.22804999351501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chamberino' limit 1
loadtime:0.22812294960022 / seconds
Query Executed:select id FROM `nm` where city='Chamberino' && SIC_code='5411'DB:business_master_new
loadtime:0.22861480712891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chamisal' limit 1
loadtime:0.22866892814636 / seconds
Query Executed:select id FROM `nm` where city='Chamisal' && SIC_code='5411'DB:business_master_new
loadtime:0.22942185401917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chaparral' limit 1
loadtime:0.22948098182678 / seconds
Query Executed:select id FROM `nm` where city='Chaparral' && SIC_code='5411'DB:business_master_new
loadtime:0.2322199344635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chimayo' limit 1
loadtime:0.23230886459351 / seconds
Query Executed:select id FROM `nm` where city='Chimayo' && SIC_code='5411'DB:business_master_new
loadtime:0.23360395431519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Church Rock' limit 1
loadtime:0.23365879058838 / seconds
Query Executed:select id FROM `nm` where city='Church Rock' && SIC_code='5411'DB:business_master_new
loadtime:0.23420190811157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cimarron' limit 1
loadtime:0.23426985740662 / seconds
Query Executed:select id FROM `nm` where city='Cimarron' && SIC_code='5411'DB:business_master_new
loadtime:0.24586391448975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claunch' limit 1
loadtime:0.24593496322632 / seconds
Query Executed:select id FROM `nm` where city='Claunch' && SIC_code='5411'DB:business_master_new
loadtime:0.24639201164246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clayton' limit 1
loadtime:0.24644589424133 / seconds
Query Executed:select id FROM `nm` where city='Clayton' && SIC_code='5411'DB:business_master_new
loadtime:0.25116896629333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.25124382972717 / seconds
Query Executed:select id FROM `nm` where city='Cleveland' && SIC_code='5411'DB:business_master_new
loadtime:0.25179696083069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cliff' limit 1
loadtime:0.2518630027771 / seconds
Query Executed:select id FROM `nm` where city='Cliff' && SIC_code='5411'DB:business_master_new
loadtime:0.25263690948486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clines Corners' limit 1
loadtime:0.25269079208374 / seconds
Query Executed:select id FROM `nm` where city='Clines Corners' && SIC_code='5411'DB:business_master_new
loadtime:0.25311684608459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cloudcroft' limit 1
loadtime:0.25318098068237 / seconds
Query Executed:select id FROM `nm` where city='Cloudcroft' && SIC_code='5411'DB:business_master_new
loadtime:0.25691294670105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clovis' limit 1
loadtime:0.25698280334473 / seconds
Query Executed:select id FROM `nm` where city='Clovis' && SIC_code='5411'DB:business_master_new
loadtime:0.26925897598267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cochiti Lake' limit 1
loadtime:0.26940488815308 / seconds
Query Executed:select id FROM `nm` where city='Cochiti Lake' && SIC_code='5411'DB:business_master_new
loadtime:0.26996493339539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cochiti Pueblo' limit 1
loadtime:0.27003479003906 / seconds
Query Executed:select id FROM `nm` where city='Cochiti Pueblo' && SIC_code='5411'DB:business_master_new
loadtime:0.27049088478088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:0.27054500579834 / seconds
Query Executed:select id FROM `nm` where city='Columbus' && SIC_code='5411'DB:business_master_new
loadtime:0.2715950012207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conchas Dam' limit 1
loadtime:0.27166295051575 / seconds
Query Executed:select id FROM `nm` where city='Conchas Dam' && SIC_code='5411'DB:business_master_new
loadtime:0.27234387397766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Continental Div' limit 1
loadtime:0.27241182327271 / seconds
Query Executed:select id FROM `nm` where city='Continental Div' && SIC_code='5411'DB:business_master_new
loadtime:0.27280378341675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Continental Divide' limit 1
loadtime:0.27285885810852 / seconds
Query Executed:select id FROM `nm` where city='Continental Divide' && SIC_code='5411'DB:business_master_new
loadtime:0.27340793609619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cordova' limit 1
loadtime:0.27347779273987 / seconds
Query Executed:select id FROM `nm` where city='Cordova' && SIC_code='5411'DB:business_master_new
loadtime:0.27405381202698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corona' limit 1
loadtime:0.27410578727722 / seconds
Query Executed:select id FROM `nm` where city='Corona' && SIC_code='5411'DB:business_master_new
loadtime:0.2750928401947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corrales' limit 1
loadtime:0.27516198158264 / seconds
Query Executed:select id FROM `nm` where city='Corrales' && SIC_code='5411'DB:business_master_new
loadtime:0.28167581558228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Costilla' limit 1
loadtime:0.28174185752869 / seconds
Query Executed:select id FROM `nm` where city='Costilla' && SIC_code='5411'DB:business_master_new
loadtime:0.28229880332947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Counselor' limit 1
loadtime:0.2823657989502 / seconds
Query Executed:select id FROM `nm` where city='Counselor' && SIC_code='5411'DB:business_master_new
loadtime:0.28284382820129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coyote' limit 1
loadtime:0.28289794921875 / seconds
Query Executed:select id FROM `nm` where city='Coyote' && SIC_code='5411'DB:business_master_new
loadtime:0.28344988822937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crossroads' limit 1
loadtime:0.28351998329163 / seconds
Query Executed:select id FROM `nm` where city='Crossroads' && SIC_code='5411'DB:business_master_new
loadtime:0.2838978767395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crownpoint' limit 1
loadtime:0.28394985198975 / seconds
Query Executed:select id FROM `nm` where city='Crownpoint' && SIC_code='5411'DB:business_master_new
loadtime:0.28647089004517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuba' limit 1
loadtime:0.28653693199158 / seconds
Query Executed:select id FROM `nm` where city='Cuba' && SIC_code='5411'DB:business_master_new
loadtime:0.29020500183105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cubero' limit 1
loadtime:0.29029488563538 / seconds
Query Executed:select id FROM `nm` where city='Cubero' && SIC_code='5411'DB:business_master_new
loadtime:0.29083299636841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuchillo' limit 1
loadtime:0.2908878326416 / seconds
Query Executed:select id FROM `nm` where city='Cuchillo' && SIC_code='5411'DB:business_master_new
loadtime:0.29126191139221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuervo' limit 1
loadtime:0.29132294654846 / seconds
Query Executed:select id FROM `nm` where city='Cuervo' && SIC_code='5411'DB:business_master_new
loadtime:0.29174494743347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Datil' limit 1
loadtime:0.29179692268372 / seconds
Query Executed:select id FROM `nm` where city='Datil' && SIC_code='5411'DB:business_master_new
loadtime:0.29272794723511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deming' limit 1
loadtime:0.29277992248535 / seconds
Query Executed:select id FROM `nm` where city='Deming' && SIC_code='5411'DB:business_master_new
loadtime:0.30314898490906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derry' limit 1
loadtime:0.30322885513306 / seconds
Query Executed:select id FROM `nm` where city='Derry' && SIC_code='5411'DB:business_master_new
loadtime:0.30364179611206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Des Moines' limit 1
loadtime:0.30369687080383 / seconds
Query Executed:select id FROM `nm` where city='Des Moines' && SIC_code='5411'DB:business_master_new
loadtime:0.30446887016296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dexter' limit 1
loadtime:0.30452084541321 / seconds
Query Executed:select id FROM `nm` where city='Dexter' && SIC_code='5411'DB:business_master_new
loadtime:0.30759596824646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dixon' limit 1
loadtime:0.30766892433167 / seconds
Query Executed:select id FROM `nm` where city='Dixon' && SIC_code='5411'DB:business_master_new
loadtime:0.30848598480225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dona Ana' limit 1
loadtime:0.30855393409729 / seconds
Query Executed:select id FROM `nm` where city='Dona Ana' && SIC_code='5411'DB:business_master_new
loadtime:0.30930495262146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dora' limit 1
loadtime:0.30937099456787 / seconds
Query Executed:select id FROM `nm` where city='Dora' && SIC_code='5411'DB:business_master_new
loadtime:0.30995082855225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dulce' limit 1
loadtime:0.31001782417297 / seconds
Query Executed:select id FROM `nm` where city='Dulce' && SIC_code='5411'DB:business_master_new
loadtime:0.32148694992065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duran' limit 1
loadtime:0.32155799865723 / seconds
Query Executed:select id FROM `nm` where city='Duran' && SIC_code='5411'DB:business_master_new
loadtime:0.32193899154663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Nest' limit 1
loadtime:0.32199096679688 / seconds
Query Executed:select id FROM `nm` where city='Eagle Nest' && SIC_code='5411'DB:business_master_new
loadtime:0.32343888282776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewood' limit 1
loadtime:0.32351183891296 / seconds
Query Executed:select id FROM `nm` where city='Edgewood' && SIC_code='5411'DB:business_master_new
loadtime:0.32892680168152 / seconds
Query loaded from cache:select * from geodata_geocity where city='El Prado' limit 1
loadtime:0.32899785041809 / seconds
Query Executed:select id FROM `nm` where city='El Prado' && SIC_code='5411'DB:business_master_new
loadtime:0.33236479759216 / seconds
Query loaded from cache:select * from geodata_geocity where city='El Rito' limit 1
loadtime:0.3324339389801 / seconds
Query Executed:select id FROM `nm` where city='El Rito' && SIC_code='5411'DB:business_master_new
loadtime:0.3332188129425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elephant Butte' limit 1
loadtime:0.33329701423645 / seconds
Query Executed:select id FROM `nm` where city='Elephant Butte' && SIC_code='5411'DB:business_master_new
loadtime:0.33602380752563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elida' limit 1
loadtime:0.33609390258789 / seconds
Query Executed:select id FROM `nm` where city='Elida' && SIC_code='5411'DB:business_master_new
loadtime:0.33700895309448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Embudo' limit 1
loadtime:0.33708095550537 / seconds
Query Executed:select id FROM `nm` where city='Embudo' && SIC_code='5411'DB:business_master_new
loadtime:0.33780097961426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Encino' limit 1
loadtime:0.33785486221313 / seconds
Query Executed:select id FROM `nm` where city='Encino' && SIC_code='5411'DB:business_master_new
loadtime:0.33848881721497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Espanola' limit 1
loadtime:0.33854198455811 / seconds
Query Executed:select id FROM `nm` where city='Espanola' && SIC_code='5411'DB:business_master_new
loadtime:0.35122084617615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estancia' limit 1
loadtime:0.35133194923401 / seconds
Query Executed:select id FROM `nm` where city='Estancia' && SIC_code='5411'DB:business_master_new
loadtime:0.3542149066925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eunice' limit 1
loadtime:0.35430693626404 / seconds
Query Executed:select id FROM `nm` where city='Eunice' && SIC_code='5411'DB:business_master_new
loadtime:0.3579478263855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairacres' limit 1
loadtime:0.35801982879639 / seconds
Query Executed:select id FROM `nm` where city='Fairacres' && SIC_code='5411'DB:business_master_new
loadtime:0.35898995399475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:0.35904479026794 / seconds
Query Executed:select id FROM `nm` where city='Fairview' && SIC_code='5411'DB:business_master_new
loadtime:0.35941481590271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.35947299003601 / seconds
Query Executed:select id FROM `nm` where city='Farmington' && SIC_code='5411'DB:business_master_new
loadtime:0.37195181846619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faywood' limit 1
loadtime:0.37208199501038 / seconds
Query Executed:select id FROM `nm` where city='Faywood' && SIC_code='5411'DB:business_master_new
loadtime:0.37253594398499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fence Lake' limit 1
loadtime:0.37259483337402 / seconds
Query Executed:select id FROM `nm` where city='Fence Lake' && SIC_code='5411'DB:business_master_new
loadtime:0.37306499481201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flora Vista' limit 1
loadtime:0.37313079833984 / seconds
Query Executed:select id FROM `nm` where city='Flora Vista' && SIC_code='5411'DB:business_master_new
loadtime:0.37582588195801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Floyd' limit 1
loadtime:0.37589192390442 / seconds
Query Executed:select id FROM `nm` where city='Floyd' && SIC_code='5411'DB:business_master_new
loadtime:0.37653279304504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flying H' limit 1
loadtime:0.3765869140625 / seconds
Query Executed:select id FROM `nm` where city='Flying H' && SIC_code='5411'DB:business_master_new
loadtime:0.37694597244263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Folsom' limit 1
loadtime:0.37699699401855 / seconds
Query Executed:select id FROM `nm` where city='Folsom' && SIC_code='5411'DB:business_master_new
loadtime:0.37767791748047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Bayard' limit 1
loadtime:0.37773084640503 / seconds
Query Executed:select id FROM `nm` where city='Fort Bayard' && SIC_code='5411'DB:business_master_new
loadtime:0.37815284729004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Stanton' limit 1
loadtime:0.37820386886597 / seconds
Query Executed:select id FROM `nm` where city='Fort Stanton' && SIC_code='5411'DB:business_master_new
loadtime:0.37866401672363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Sumner' limit 1
loadtime:0.37871599197388 / seconds
Query Executed:select id FROM `nm` where city='Fort Sumner' && SIC_code='5411'DB:business_master_new
loadtime:0.38211488723755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Wingate' limit 1
loadtime:0.38218998908997 / seconds
Query Executed:select id FROM `nm` where city='Fort Wingate' && SIC_code='5411'DB:business_master_new
loadtime:0.38295483589172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitland' limit 1
loadtime:0.38302278518677 / seconds
Query Executed:select id FROM `nm` where city='Fruitland' && SIC_code='5411'DB:business_master_new
loadtime:0.3839910030365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gallina' limit 1
loadtime:0.38406181335449 / seconds
Query Executed:select id FROM `nm` where city='Gallina' && SIC_code='5411'DB:business_master_new
loadtime:0.38461780548096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gallup' limit 1
loadtime:0.38468384742737 / seconds
Query Executed:select id FROM `nm` where city='Gallup' && SIC_code='5411'DB:business_master_new
loadtime:0.40525579452515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gamerco' limit 1
loadtime:0.40540599822998 / seconds
Query Executed:select id FROM `nm` where city='Gamerco' && SIC_code='5411'DB:business_master_new
loadtime:0.4060959815979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garfield' limit 1
loadtime:0.40615701675415 / seconds
Query Executed:select id FROM `nm` where city='Garfield' && SIC_code='5411'DB:business_master_new
loadtime:0.40669584274292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garita' limit 1
loadtime:0.40674781799316 / seconds
Query Executed:select id FROM `nm` where city='Garita' && SIC_code='5411'DB:business_master_new
loadtime:0.40709781646729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gila' limit 1
loadtime:0.40715098381042 / seconds
Query Executed:select id FROM `nm` where city='Gila' && SIC_code='5411'DB:business_master_new
loadtime:0.40775680541992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladstone' limit 1
loadtime:0.40782499313354 / seconds
Query Executed:select id FROM `nm` where city='Gladstone' && SIC_code='5411'DB:business_master_new
loadtime:0.4082248210907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glencoe' limit 1
loadtime:0.40829992294312 / seconds
Query Executed:select id FROM `nm` where city='Glencoe' && SIC_code='5411'DB:business_master_new
loadtime:0.40877985954285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:0.40883278846741 / seconds
Query Executed:select id FROM `nm` where city='Glenwood' && SIC_code='5411'DB:business_master_new
loadtime:0.40972685813904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glorieta' limit 1
loadtime:0.40977883338928 / seconds
Query Executed:select id FROM `nm` where city='Glorieta' && SIC_code='5411'DB:business_master_new
loadtime:0.41060781478882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grady' limit 1
loadtime:0.41065979003906 / seconds
Query Executed:select id FROM `nm` where city='Grady' && SIC_code='5411'DB:business_master_new
loadtime:0.41122198104858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grants' limit 1
loadtime:0.41127181053162 / seconds
Query Executed:select id FROM `nm` where city='Grants' && SIC_code='5411'DB:business_master_new
loadtime:0.41895699501038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grenville' limit 1
loadtime:0.41903591156006 / seconds
Query Executed:select id FROM `nm` where city='Grenville' && SIC_code='5411'DB:business_master_new
loadtime:0.41953492164612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guadalupita' limit 1
loadtime:0.41959095001221 / seconds
Query Executed:select id FROM `nm` where city='Guadalupita' && SIC_code='5411'DB:business_master_new
loadtime:0.4201078414917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hachita' limit 1
loadtime:0.42015981674194 / seconds
Query Executed:select id FROM `nm` where city='Hachita' && SIC_code='5411'DB:business_master_new
loadtime:0.42067289352417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hagerman' limit 1
loadtime:0.42073798179626 / seconds
Query Executed:select id FROM `nm` where city='Hagerman' && SIC_code='5411'DB:business_master_new
loadtime:0.42192387580872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.42199397087097 / seconds
Query Executed:select id FROM `nm` where city='Hanover' && SIC_code='5411'DB:business_master_new
loadtime:0.422611951828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatch' limit 1
loadtime:0.42267680168152 / seconds
Query Executed:select id FROM `nm` where city='Hatch' && SIC_code='5411'DB:business_master_new
loadtime:0.42582488059998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hernandez' limit 1
loadtime:0.42590188980103 / seconds
Query Executed:select id FROM `nm` where city='Hernandez' && SIC_code='5411'DB:business_master_new
loadtime:0.42654800415039 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Rls Mtn Pk' limit 1
loadtime:0.42661380767822 / seconds
Query Executed:select id FROM `nm` where city='High Rls Mtn Pk' && SIC_code='5411'DB:business_master_new
loadtime:0.42697381973267 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Rolls Mountain Park' limit 1
loadtime:0.42702698707581 / seconds
Query Executed:select id FROM `nm` where city='High Rolls Mountain Park' && SIC_code='5411'DB:business_master_new
loadtime:0.42791986465454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:0.42798590660095 / seconds
Query Executed:select id FROM `nm` where city='Hillsboro' && SIC_code='5411'DB:business_master_new
loadtime:0.42870998382568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hobbs' limit 1
loadtime:0.42877793312073 / seconds
Query Executed:select id FROM `nm` where city='Hobbs' && SIC_code='5411'DB:business_master_new
loadtime:0.44134998321533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holloman Afb' limit 1
loadtime:0.44147992134094 / seconds
Query Executed:select id FROM `nm` where city='Holloman Afb' && SIC_code='5411'DB:business_master_new
loadtime:0.44223093986511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holloman Air Force Base' limit 1
loadtime:0.44229793548584 / seconds
Query Executed:select id FROM `nm` where city='Holloman Air Force Base' && SIC_code='5411'DB:business_master_new
loadtime:0.44431686401367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holman' limit 1
loadtime:0.44438195228577 / seconds
Query Executed:select id FROM `nm` where city='Holman' && SIC_code='5411'DB:business_master_new
loadtime:0.44483494758606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hondo' limit 1
loadtime:0.44488883018494 / seconds
Query Executed:select id FROM `nm` where city='Hondo' && SIC_code='5411'DB:business_master_new
loadtime:0.44579792022705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hope' limit 1
loadtime:0.44586491584778 / seconds
Query Executed:select id FROM `nm` where city='Hope' && SIC_code='5411'DB:business_master_new
loadtime:0.44642996788025 / seconds
Query loaded from cache:select * from geodata_geocity where city='House' limit 1
loadtime:0.44650197029114 / seconds
Query Executed:select id FROM `nm` where city='House' && SIC_code='5411'DB:business_master_new
loadtime:0.44710087776184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:0.44715285301208 / seconds
Query Executed:select id FROM `nm` where city='Hurley' && SIC_code='5411'DB:business_master_new
loadtime:0.44791698455811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isleta' limit 1
loadtime:0.44796895980835 / seconds
Query Executed:select id FROM `nm` where city='Isleta' && SIC_code='5411'DB:business_master_new
loadtime:0.44878101348877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jal' limit 1
loadtime:0.44883298873901 / seconds
Query Executed:select id FROM `nm` where city='Jal' && SIC_code='5411'DB:business_master_new
loadtime:0.45182800292969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:0.45190095901489 / seconds
Query Executed:select id FROM `nm` where city='Jamestown' && SIC_code='5411'DB:business_master_new
loadtime:0.45244479179382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jarales' limit 1
loadtime:0.45250296592712 / seconds
Query Executed:select id FROM `nm` where city='Jarales' && SIC_code='5411'DB:business_master_new
loadtime:0.45312190055847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jemez Pueblo' limit 1
loadtime:0.4531729221344 / seconds
Query Executed:select id FROM `nm` where city='Jemez Pueblo' && SIC_code='5411'DB:business_master_new
loadtime:0.45429086685181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jemez Springs' limit 1
loadtime:0.45436000823975 / seconds
Query Executed:select id FROM `nm` where city='Jemez Springs' && SIC_code='5411'DB:business_master_new
loadtime:0.45587301254272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenna' limit 1
loadtime:0.4559268951416 / seconds
Query Executed:select id FROM `nm` where city='Kenna' && SIC_code='5411'DB:business_master_new
loadtime:0.45630788803101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirtland' limit 1
loadtime:0.4563729763031 / seconds
Query Executed:select id FROM `nm` where city='Kirtland' && SIC_code='5411'DB:business_master_new
loadtime:0.46003079414368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirtland Afb' limit 1
loadtime:0.46010780334473 / seconds
Query Executed:select id FROM `nm` where city='Kirtland Afb' && SIC_code='5411'DB:business_master_new
loadtime:0.46092295646667 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Jara' limit 1
loadtime:0.46099281311035 / seconds
Query Executed:select id FROM `nm` where city='La Jara' && SIC_code='5411'DB:business_master_new
loadtime:0.46141195297241 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Joya' limit 1
loadtime:0.46147084236145 / seconds
Query Executed:select id FROM `nm` where city='La Joya' && SIC_code='5411'DB:business_master_new
loadtime:0.46187901496887 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Loma' limit 1
loadtime:0.46192979812622 / seconds
Query Executed:select id FROM `nm` where city='La Loma' && SIC_code='5411'DB:business_master_new
loadtime:0.46230483055115 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Luz' limit 1
loadtime:0.46235680580139 / seconds
Query Executed:select id FROM `nm` where city='La Luz' && SIC_code='5411'DB:business_master_new
loadtime:0.46451282501221 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Madera' limit 1
loadtime:0.4645779132843 / seconds
Query Executed:select id FROM `nm` where city='La Madera' && SIC_code='5411'DB:business_master_new
loadtime:0.46501088142395 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Mesa' limit 1
loadtime:0.46506285667419 / seconds
Query Executed:select id FROM `nm` where city='La Mesa' && SIC_code='5411'DB:business_master_new
loadtime:0.47620391845703 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Plata' limit 1
loadtime:0.47627186775208 / seconds
Query Executed:select id FROM `nm` where city='La Plata' && SIC_code='5411'DB:business_master_new
loadtime:0.47703289985657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laguna' limit 1
loadtime:0.47709894180298 / seconds
Query Executed:select id FROM `nm` where city='Laguna' && SIC_code='5411'DB:business_master_new
loadtime:0.47825598716736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lajoya' limit 1
loadtime:0.4783308506012 / seconds
Query Executed:select id FROM `nm` where city='Lajoya' && SIC_code='5411'DB:business_master_new
loadtime:0.47871780395508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Arthur' limit 1
loadtime:0.47877192497253 / seconds
Query Executed:select id FROM `nm` where city='Lake Arthur' && SIC_code='5411'DB:business_master_new
loadtime:0.47960495948792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakewood' limit 1
loadtime:0.47967600822449 / seconds
Query Executed:select id FROM `nm` where city='Lakewood' && SIC_code='5411'DB:business_master_new
loadtime:0.48027181625366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamy' limit 1
loadtime:0.48033380508423 / seconds
Query Executed:select id FROM `nm` where city='Lamy' && SIC_code='5411'DB:business_master_new
loadtime:0.48130178451538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Las Cruces' limit 1
loadtime:0.48135495185852 / seconds
Query Executed:select id FROM `nm` where city='Las Cruces' && SIC_code='5411'DB:business_master_new
loadtime:0.49349498748779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Las Vegas' limit 1
loadtime:0.49364495277405 / seconds
Query Executed:select id FROM `nm` where city='Las Vegas' && SIC_code='5411'DB:business_master_new
loadtime:0.50582385063171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemitar' limit 1
loadtime:0.50592494010925 / seconds
Query Executed:select id FROM `nm` where city='Lemitar' && SIC_code='5411'DB:business_master_new
loadtime:0.5065929889679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.5066499710083 / seconds
Query Executed:select id FROM `nm` where city='Lincoln' && SIC_code='5411'DB:business_master_new
loadtime:0.50721383094788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lindrith' limit 1
loadtime:0.5072648525238 / seconds
Query Executed:select id FROM `nm` where city='Lindrith' && SIC_code='5411'DB:business_master_new
loadtime:0.50792288780212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Llano' limit 1
loadtime:0.50797700881958 / seconds
Query Executed:select id FROM `nm` where city='Llano' && SIC_code='5411'DB:business_master_new
loadtime:0.50834488868713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loco Hills' limit 1
loadtime:0.50839781761169 / seconds
Query Executed:select id FROM `nm` where city='Loco Hills' && SIC_code='5411'DB:business_master_new
loadtime:0.50918984413147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Logan' limit 1
loadtime:0.5092568397522 / seconds
Query Executed:select id FROM `nm` where city='Logan' && SIC_code='5411'DB:business_master_new
loadtime:0.51222586631775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lordsburg' limit 1
loadtime:0.51230788230896 / seconds
Query Executed:select id FROM `nm` where city='Lordsburg' && SIC_code='5411'DB:business_master_new
loadtime:0.51627683639526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Los Alamos' limit 1
loadtime:0.51636385917664 / seconds
Query Executed:select id FROM `nm` where city='Los Alamos' && SIC_code='5411'DB:business_master_new
loadtime:0.52795100212097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Los Lunas' limit 1
loadtime:0.52802991867065 / seconds
Query Executed:select id FROM `nm` where city='Los Lunas' && SIC_code='5411'DB:business_master_new
loadtime:0.54193496704102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Los Ojos' limit 1
loadtime:0.54202389717102 / seconds
Query Executed:select id FROM `nm` where city='Los Ojos' && SIC_code='5411'DB:business_master_new
loadtime:0.54265189170837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loving' limit 1
loadtime:0.54270887374878 / seconds
Query Executed:select id FROM `nm` where city='Loving' && SIC_code='5411'DB:business_master_new
loadtime:0.5436999797821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovington' limit 1
loadtime:0.5437707901001 / seconds
Query Executed:select id FROM `nm` where city='Lovington' && SIC_code='5411'DB:business_master_new
loadtime:0.55179786682129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lumberton' limit 1
loadtime:0.55187892913818 / seconds
Query Executed:select id FROM `nm` where city='Lumberton' && SIC_code='5411'DB:business_master_new
loadtime:0.55229783058167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luna' limit 1
loadtime:0.55235481262207 / seconds
Query Executed:select id FROM `nm` where city='Luna' && SIC_code='5411'DB:business_master_new
loadtime:0.55294799804688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magdalena' limit 1
loadtime:0.55300188064575 / seconds
Query Executed:select id FROM `nm` where city='Magdalena' && SIC_code='5411'DB:business_master_new
loadtime:0.55554795265198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malaga' limit 1
loadtime:0.55561685562134 / seconds
Query Executed:select id FROM `nm` where city='Malaga' && SIC_code='5411'DB:business_master_new
loadtime:0.55600690841675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maljamar' limit 1
loadtime:0.55605983734131 / seconds
Query Executed:select id FROM `nm` where city='Maljamar' && SIC_code='5411'DB:business_master_new
loadtime:0.55666184425354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxwell' limit 1
loadtime:0.55672788619995 / seconds
Query Executed:select id FROM `nm` where city='Maxwell' && SIC_code='5411'DB:business_master_new
loadtime:0.55740094184875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayhill' limit 1
loadtime:0.55745983123779 / seconds
Query Executed:select id FROM `nm` where city='Mayhill' && SIC_code='5411'DB:business_master_new
loadtime:0.5584979057312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Alister' limit 1
loadtime:0.5585629940033 / seconds
Query Executed:select id FROM `nm` where city='Mc Alister' && SIC_code='5411'DB:business_master_new
loadtime:0.5589280128479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Donald' limit 1
loadtime:0.55897879600525 / seconds
Query Executed:select id FROM `nm` where city='Mc Donald' && SIC_code='5411'DB:business_master_new
loadtime:0.55937600135803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Intosh' limit 1
loadtime:0.55942797660828 / seconds
Query Executed:select id FROM `nm` where city='Mc Intosh' && SIC_code='5411'DB:business_master_new
loadtime:0.55981278419495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medanales' limit 1
loadtime:0.55988097190857 / seconds
Query Executed:select id FROM `nm` where city='Medanales' && SIC_code='5411'DB:business_master_new
loadtime:0.56030797958374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melrose' limit 1
loadtime:0.56037187576294 / seconds
Query Executed:select id FROM `nm` where city='Melrose' && SIC_code='5411'DB:business_master_new
loadtime:0.56165194511414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mentmore' limit 1
loadtime:0.56172394752502 / seconds
Query Executed:select id FROM `nm` where city='Mentmore' && SIC_code='5411'DB:business_master_new
loadtime:0.56219983100891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mescalero' limit 1
loadtime:0.56225395202637 / seconds
Query Executed:select id FROM `nm` where city='Mescalero' && SIC_code='5411'DB:business_master_new
loadtime:0.56360793113708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesilla' limit 1
loadtime:0.56366300582886 / seconds
Query Executed:select id FROM `nm` where city='Mesilla' && SIC_code='5411'DB:business_master_new
loadtime:0.56637978553772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesilla Park' limit 1
loadtime:0.56643295288086 / seconds
Query Executed:select id FROM `nm` where city='Mesilla Park' && SIC_code='5411'DB:business_master_new
loadtime:0.56943583488464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesquite' limit 1
loadtime:0.56950998306274 / seconds
Query Executed:select id FROM `nm` where city='Mesquite' && SIC_code='5411'DB:business_master_new
loadtime:0.5715069770813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mexican Springs' limit 1
loadtime:0.57157397270203 / seconds
Query Executed:select id FROM `nm` where city='Mexican Springs' && SIC_code='5411'DB:business_master_new
loadtime:0.57192587852478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miami' limit 1
loadtime:0.57197785377502 / seconds
Query Executed:select id FROM `nm` where city='Miami' && SIC_code='5411'DB:business_master_new
loadtime:0.57241678237915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milan' limit 1
loadtime:0.57246899604797 / seconds
Query Executed:select id FROM `nm` where city='Milan' && SIC_code='5411'DB:business_master_new
loadtime:0.5754828453064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mills' limit 1
loadtime:0.57556295394897 / seconds
Query Executed:select id FROM `nm` where city='Mills' && SIC_code='5411'DB:business_master_new
loadtime:0.57594180107117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milnesand' limit 1
loadtime:0.57599592208862 / seconds
Query Executed:select id FROM `nm` where city='Milnesand' && SIC_code='5411'DB:business_master_new
loadtime:0.57646679878235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mimbres' limit 1
loadtime:0.57652282714844 / seconds
Query Executed:select id FROM `nm` where city='Mimbres' && SIC_code='5411'DB:business_master_new
loadtime:0.57738900184631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mogollon' limit 1
loadtime:0.57745599746704 / seconds
Query Executed:select id FROM `nm` where city='Mogollon' && SIC_code='5411'DB:business_master_new
loadtime:0.57780694961548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montezuma' limit 1
loadtime:0.57785987854004 / seconds
Query Executed:select id FROM `nm` where city='Montezuma' && SIC_code='5411'DB:business_master_new
loadtime:0.57839584350586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:0.5784478187561 / seconds
Query Executed:select id FROM `nm` where city='Monticello' && SIC_code='5411'DB:business_master_new
loadtime:0.57883191108704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monument' limit 1
loadtime:0.57888388633728 / seconds
Query Executed:select id FROM `nm` where city='Monument' && SIC_code='5411'DB:business_master_new
loadtime:0.57943987846375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mora' limit 1
loadtime:0.57951283454895 / seconds
Query Executed:select id FROM `nm` where city='Mora' && SIC_code='5411'DB:business_master_new
loadtime:0.58223485946655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moriarty' limit 1
loadtime:0.58230686187744 / seconds
Query Executed:select id FROM `nm` where city='Moriarty' && SIC_code='5411'DB:business_master_new
loadtime:0.58786082267761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mosquero' limit 1
loadtime:0.58793687820435 / seconds
Query Executed:select id FROM `nm` where city='Mosquero' && SIC_code='5411'DB:business_master_new
loadtime:0.58883380889893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountainair' limit 1
loadtime:0.58890295028687 / seconds
Query Executed:select id FROM `nm` where city='Mountainair' && SIC_code='5411'DB:business_master_new
loadtime:0.59163880348206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mule Creek' limit 1
loadtime:0.59170794487 / seconds
Query Executed:select id FROM `nm` where city='Mule Creek' && SIC_code='5411'DB:business_master_new
loadtime:0.59218001365662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nageezi' limit 1
loadtime:0.59223294258118 / seconds
Query Executed:select id FROM `nm` where city='Nageezi' && SIC_code='5411'DB:business_master_new
loadtime:0.59276795387268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nara Visa' limit 1
loadtime:0.59282088279724 / seconds
Query Executed:select id FROM `nm` where city='Nara Visa' && SIC_code='5411'DB:business_master_new
loadtime:0.59354782104492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Navajo' limit 1
loadtime:0.59361386299133 / seconds
Query Executed:select id FROM `nm` where city='Navajo' && SIC_code='5411'DB:business_master_new
loadtime:0.59436392784119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Navajo Dam' limit 1
loadtime:0.59443092346191 / seconds
Query Executed:select id FROM `nm` where city='Navajo Dam' && SIC_code='5411'DB:business_master_new
loadtime:0.59513998031616 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Laguna' limit 1
loadtime:0.59519386291504 / seconds
Query Executed:select id FROM `nm` where city='New Laguna' && SIC_code='5411'DB:business_master_new
loadtime:0.59567284584045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newcomb' limit 1
loadtime:0.59572601318359 / seconds
Query Executed:select id FROM `nm` where city='Newcomb' && SIC_code='5411'DB:business_master_new
loadtime:0.59637689590454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newkirk' limit 1
loadtime:0.59644293785095 / seconds
Query Executed:select id FROM `nm` where city='Newkirk' && SIC_code='5411'DB:business_master_new
loadtime:0.59688282012939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nogal' limit 1
loadtime:0.59694790840149 / seconds
Query Executed:select id FROM `nm` where city='Nogal' && SIC_code='5411'DB:business_master_new
loadtime:0.59765696525574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocate' limit 1
loadtime:0.5977098941803 / seconds
Query Executed:select id FROM `nm` where city='Ocate' && SIC_code='5411'DB:business_master_new
loadtime:0.59820079803467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ojo Caliente' limit 1
loadtime:0.5982518196106 / seconds
Query Executed:select id FROM `nm` where city='Ojo Caliente' && SIC_code='5411'DB:business_master_new
loadtime:0.59915590286255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ojo Feliz' limit 1
loadtime:0.59922099113464 / seconds
Query Executed:select id FROM `nm` where city='Ojo Feliz' && SIC_code='5411'DB:business_master_new
loadtime:0.59963393211365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ojo Sarco' limit 1
loadtime:0.59968781471252 / seconds
Query Executed:select id FROM `nm` where city='Ojo Sarco' && SIC_code='5411'DB:business_master_new
loadtime:0.60009789466858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Organ' limit 1
loadtime:0.60014796257019 / seconds
Query Executed:select id FROM `nm` where city='Organ' && SIC_code='5411'DB:business_master_new
loadtime:0.6008038520813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orogrande' limit 1
loadtime:0.60085582733154 / seconds
Query Executed:select id FROM `nm` where city='Orogrande' && SIC_code='5411'DB:business_master_new
loadtime:0.60131978988647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paguate' limit 1
loadtime:0.60138201713562 / seconds
Query Executed:select id FROM `nm` where city='Paguate' && SIC_code='5411'DB:business_master_new
loadtime:0.60182881355286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pecos' limit 1
loadtime:0.60187983512878 / seconds
Query Executed:select id FROM `nm` where city='Pecos' && SIC_code='5411'DB:business_master_new
loadtime:0.60470294952393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pena Blanca' limit 1
loadtime:0.60477495193481 / seconds
Query Executed:select id FROM `nm` where city='Pena Blanca' && SIC_code='5411'DB:business_master_new
loadtime:0.60545086860657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penasco' limit 1
loadtime:0.60552096366882 / seconds
Query Executed:select id FROM `nm` where city='Penasco' && SIC_code='5411'DB:business_master_new
loadtime:0.60666680335999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pep' limit 1
loadtime:0.60673880577087 / seconds
Query Executed:select id FROM `nm` where city='Pep' && SIC_code='5411'DB:business_master_new
loadtime:0.6071469783783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peralta' limit 1
loadtime:0.6072108745575 / seconds
Query Executed:select id FROM `nm` where city='Peralta' && SIC_code='5411'DB:business_master_new
loadtime:0.60996294021606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petaca' limit 1
loadtime:0.61001682281494 / seconds
Query Executed:select id FROM `nm` where city='Petaca' && SIC_code='5411'DB:business_master_new
loadtime:0.6104109287262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Picacho' limit 1
loadtime:0.61046385765076 / seconds
Query Executed:select id FROM `nm` where city='Picacho' && SIC_code='5411'DB:business_master_new
loadtime:0.61095094680786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pie Town' limit 1
loadtime:0.61100292205811 / seconds
Query Executed:select id FROM `nm` where city='Pie Town' && SIC_code='5411'DB:business_master_new
loadtime:0.61170387268066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinehill' limit 1
loadtime:0.61175489425659 / seconds
Query Executed:select id FROM `nm` where city='Pinehill' && SIC_code='5411'DB:business_master_new
loadtime:0.61242890357971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinon' limit 1
loadtime:0.61249685287476 / seconds
Query Executed:select id FROM `nm` where city='Pinon' && SIC_code='5411'DB:business_master_new
loadtime:0.61302900314331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinos Altos' limit 1
loadtime:0.61309289932251 / seconds
Query Executed:select id FROM `nm` where city='Pinos Altos' && SIC_code='5411'DB:business_master_new
loadtime:0.61361384391785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Placitas' limit 1
loadtime:0.61366701126099 / seconds
Query Executed:select id FROM `nm` where city='Placitas' && SIC_code='5411'DB:business_master_new
loadtime:0.61698293685913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Playas' limit 1
loadtime:0.61705183982849 / seconds
Query Executed:select id FROM `nm` where city='Playas' && SIC_code='5411'DB:business_master_new
loadtime:0.61749291419983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pojoaque Valley' limit 1
loadtime:0.61754989624023 / seconds
Query Executed:select id FROM `nm` where city='Pojoaque Valley' && SIC_code='5411'DB:business_master_new
loadtime:0.61797595024109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polvadera' limit 1
loadtime:0.61802697181702 / seconds
Query Executed:select id FROM `nm` where city='Polvadera' && SIC_code='5411'DB:business_master_new
loadtime:0.61852979660034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ponderosa' limit 1
loadtime:0.61858201026917 / seconds
Query Executed:select id FROM `nm` where city='Ponderosa' && SIC_code='5411'DB:business_master_new
loadtime:0.6190619468689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portales' limit 1
loadtime:0.61911296844482 / seconds
Query Executed:select id FROM `nm` where city='Portales' && SIC_code='5411'DB:business_master_new
loadtime:0.62898397445679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prewitt' limit 1
loadtime:0.62906789779663 / seconds
Query Executed:select id FROM `nm` where city='Prewitt' && SIC_code='5411'DB:business_master_new
loadtime:0.62981295585632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pueblo Of Acoma' limit 1
loadtime:0.62986779212952 / seconds
Query Executed:select id FROM `nm` where city='Pueblo Of Acoma' && SIC_code='5411'DB:business_master_new
loadtime:0.63062882423401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quay' limit 1
loadtime:0.63069701194763 / seconds
Query Executed:select id FROM `nm` where city='Quay' && SIC_code='5411'DB:business_master_new
loadtime:0.63109993934631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quemado' limit 1
loadtime:0.63115286827087 / seconds
Query Executed:select id FROM `nm` where city='Quemado' && SIC_code='5411'DB:business_master_new
loadtime:0.63214898109436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Questa' limit 1
loadtime:0.63221597671509 / seconds
Query Executed:select id FROM `nm` where city='Questa' && SIC_code='5411'DB:business_master_new
loadtime:0.63551783561707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radium Springs' limit 1
loadtime:0.63558888435364 / seconds
Query Executed:select id FROM `nm` where city='Radium Springs' && SIC_code='5411'DB:business_master_new
loadtime:0.63611078262329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rainsville' limit 1
loadtime:0.63617587089539 / seconds
Query Executed:select id FROM `nm` where city='Rainsville' && SIC_code='5411'DB:business_master_new
loadtime:0.63653779029846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramah' limit 1
loadtime:0.6365909576416 / seconds
Query Executed:select id FROM `nm` where city='Ramah' && SIC_code='5411'DB:business_master_new
loadtime:0.63886594772339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ranchos De Taos' limit 1
loadtime:0.63891887664795 / seconds
Query Executed:select id FROM `nm` where city='Ranchos De Taos' && SIC_code='5411'DB:business_master_new
loadtime:0.64288592338562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raton' limit 1
loadtime:0.64295101165771 / seconds
Query Executed:select id FROM `nm` where city='Raton' && SIC_code='5411'DB:business_master_new
loadtime:0.65064382553101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red River' limit 1
loadtime:0.65071797370911 / seconds
Query Executed:select id FROM `nm` where city='Red River' && SIC_code='5411'DB:business_master_new
loadtime:0.65449094772339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redrock' limit 1
loadtime:0.65456700325012 / seconds
Query Executed:select id FROM `nm` where city='Redrock' && SIC_code='5411'DB:business_master_new
loadtime:0.65498781204224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Regina' limit 1
loadtime:0.65505194664001 / seconds
Query Executed:select id FROM `nm` where city='Regina' && SIC_code='5411'DB:business_master_new
loadtime:0.65552282333374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rehoboth' limit 1
loadtime:0.65559387207031 / seconds
Query Executed:select id FROM `nm` where city='Rehoboth' && SIC_code='5411'DB:business_master_new
loadtime:0.65609693527222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reserve' limit 1
loadtime:0.65615081787109 / seconds
Query Executed:select id FROM `nm` where city='Reserve' && SIC_code='5411'DB:business_master_new
loadtime:0.65868401527405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ribera' limit 1
loadtime:0.65875697135925 / seconds
Query Executed:select id FROM `nm` where city='Ribera' && SIC_code='5411'DB:business_master_new
loadtime:0.65948390960693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rincon' limit 1
loadtime:0.65954279899597 / seconds
Query Executed:select id FROM `nm` where city='Rincon' && SIC_code='5411'DB:business_master_new
loadtime:0.66009092330933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio Rancho' limit 1
loadtime:0.66014194488525 / seconds
Query Executed:select id FROM `nm` where city='Rio Rancho' && SIC_code='5411'DB:business_master_new
loadtime:0.68208789825439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rociada' limit 1
loadtime:0.68216800689697 / seconds
Query Executed:select id FROM `nm` where city='Rociada' && SIC_code='5411'DB:business_master_new
loadtime:0.68268895149231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rodeo' limit 1
loadtime:0.68275594711304 / seconds
Query Executed:select id FROM `nm` where city='Rodeo' && SIC_code='5411'DB:business_master_new
loadtime:0.68334293365479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rogers' limit 1
loadtime:0.68339800834656 / seconds
Query Executed:select id FROM `nm` where city='Rogers' && SIC_code='5411'DB:business_master_new
loadtime:0.68393492698669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roswell' limit 1
loadtime:0.68398690223694 / seconds
Query Executed:select id FROM `nm` where city='Roswell' && SIC_code='5411'DB:business_master_new
loadtime:0.69679284095764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowe' limit 1
loadtime:0.69692397117615 / seconds
Query Executed:select id FROM `nm` where city='Rowe' && SIC_code='5411'DB:business_master_new
loadtime:0.69751381874084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roy' limit 1
loadtime:0.69757485389709 / seconds
Query Executed:select id FROM `nm` where city='Roy' && SIC_code='5411'DB:business_master_new
loadtime:0.6986198425293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruidoso' limit 1
loadtime:0.69868779182434 / seconds
Query Executed:select id FROM `nm` where city='Ruidoso' && SIC_code='5411'DB:business_master_new
loadtime:0.7133150100708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruidoso Downs' limit 1
loadtime:0.71340584754944 / seconds
Query Executed:select id FROM `nm` where city='Ruidoso Downs' && SIC_code='5411'DB:business_master_new
loadtime:0.71721291542053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutheron' limit 1
loadtime:0.7172839641571 / seconds
Query Executed:select id FROM `nm` where city='Rutheron' && SIC_code='5411'DB:business_master_new
loadtime:0.71767997741699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sacramento' limit 1
loadtime:0.71773386001587 / seconds
Query Executed:select id FROM `nm` where city='Sacramento' && SIC_code='5411'DB:business_master_new
loadtime:0.71819400787354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Vrain' limit 1
loadtime:0.71824598312378 / seconds
Query Executed:select id FROM `nm` where city='Saint Vrain' && SIC_code='5411'DB:business_master_new
loadtime:0.71863079071045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.71868395805359 / seconds
Query Executed:select id FROM `nm` where city='Salem' && SIC_code='5411'DB:business_master_new
loadtime:0.71927094459534 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Acacia' limit 1
loadtime:0.71934390068054 / seconds
Query Executed:select id FROM `nm` where city='San Acacia' && SIC_code='5411'DB:business_master_new
loadtime:0.71978378295898 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Antonio' limit 1
loadtime:0.71983599662781 / seconds
Query Executed:select id FROM `nm` where city='San Antonio' && SIC_code='5411'DB:business_master_new
loadtime:0.72053384780884 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Cristobal' limit 1
loadtime:0.72059988975525 / seconds
Query Executed:select id FROM `nm` where city='San Cristobal' && SIC_code='5411'DB:business_master_new
loadtime:0.72113990783691 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Fidel' limit 1
loadtime:0.72119092941284 / seconds
Query Executed:select id FROM `nm` where city='San Fidel' && SIC_code='5411'DB:business_master_new
loadtime:0.72184586524963 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Jon' limit 1
loadtime:0.72189879417419 / seconds
Query Executed:select id FROM `nm` where city='San Jon' && SIC_code='5411'DB:business_master_new
loadtime:0.72285890579224 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Jose' limit 1
loadtime:0.72292280197144 / seconds
Query Executed:select id FROM `nm` where city='San Jose' && SIC_code='5411'DB:business_master_new
loadtime:0.72346496582031 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Juan Pueblo' limit 1
loadtime:0.72353482246399 / seconds
Query Executed:select id FROM `nm` where city='San Juan Pueblo' && SIC_code='5411'DB:business_master_new
loadtime:0.72416400909424 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Lorenzo' limit 1
loadtime:0.72422695159912 / seconds
Query Executed:select id FROM `nm` where city='San Lorenzo' && SIC_code='5411'DB:business_master_new
loadtime:0.72460389137268 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Miguel' limit 1
loadtime:0.72465682029724 / seconds
Query Executed:select id FROM `nm` where city='San Miguel' && SIC_code='5411'DB:business_master_new
loadtime:0.7252368927002 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Patricio' limit 1
loadtime:0.72530293464661 / seconds
Query Executed:select id FROM `nm` where city='San Patricio' && SIC_code='5411'DB:business_master_new
loadtime:0.72588682174683 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Rafael' limit 1
loadtime:0.72594094276428 / seconds
Query Executed:select id FROM `nm` where city='San Rafael' && SIC_code='5411'DB:business_master_new
loadtime:0.72635698318481 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Ysidro' limit 1
loadtime:0.72640895843506 / seconds
Query Executed:select id FROM `nm` where city='San Ysidro' && SIC_code='5411'DB:business_master_new
loadtime:0.72725987434387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandia Park' limit 1
loadtime:0.72734189033508 / seconds
Query Executed:select id FROM `nm` where city='Sandia Park' && SIC_code='5411'DB:business_master_new
loadtime:0.73875284194946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanostee' limit 1
loadtime:0.73882079124451 / seconds
Query Executed:select id FROM `nm` where city='Sanostee' && SIC_code='5411'DB:business_master_new
loadtime:0.73934888839722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Clara' limit 1
loadtime:0.73940181732178 / seconds
Query Executed:select id FROM `nm` where city='Santa Clara' && SIC_code='5411'DB:business_master_new
loadtime:0.74019980430603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Cruz' limit 1
loadtime:0.74025177955627 / seconds
Query Executed:select id FROM `nm` where city='Santa Cruz' && SIC_code='5411'DB:business_master_new
loadtime:0.75149989128113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Fe' limit 1
loadtime:0.75156784057617 / seconds
Query Executed:select id FROM `nm` where city='Santa Fe' && SIC_code='5411'DB:business_master_new
loadtime:0.76381182670593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Rosa' limit 1
loadtime:0.76397895812988 / seconds
Query Executed:select id FROM `nm` where city='Santa Rosa' && SIC_code='5411'DB:business_master_new
loadtime:0.76854801177979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Teresa' limit 1
loadtime:0.76863288879395 / seconds
Query Executed:select id FROM `nm` where city='Santa Teresa' && SIC_code='5411'DB:business_master_new
loadtime:0.77221179008484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santo Domingo Pb' limit 1
loadtime:0.77227783203125 / seconds
Query Executed:select id FROM `nm` where city='Santo Domingo Pb' && SIC_code='5411'DB:business_master_new
loadtime:0.77265000343323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santo Domingo Pueblo' limit 1
loadtime:0.77270293235779 / seconds
Query Executed:select id FROM `nm` where city='Santo Domingo Pueblo' && SIC_code='5411'DB:business_master_new
loadtime:0.77325892448425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sapello' limit 1
loadtime:0.77332401275635 / seconds
Query Executed:select id FROM `nm` where city='Sapello' && SIC_code='5411'DB:business_master_new
loadtime:0.77392387390137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seboyeta' limit 1
loadtime:0.77398991584778 / seconds
Query Executed:select id FROM `nm` where city='Seboyeta' && SIC_code='5411'DB:business_master_new
loadtime:0.77437496185303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedan' limit 1
loadtime:0.77442789077759 / seconds
Query Executed:select id FROM `nm` where city='Sedan' && SIC_code='5411'DB:business_master_new
loadtime:0.77487778663635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:0.77493000030518 / seconds
Query Executed:select id FROM `nm` where city='Seneca' && SIC_code='5411'DB:business_master_new
loadtime:0.77530193328857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Serafina' limit 1
loadtime:0.77536082267761 / seconds
Query Executed:select id FROM `nm` where city='Serafina' && SIC_code='5411'DB:business_master_new
loadtime:0.77576684951782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheep Springs' limit 1
loadtime:0.77581787109375 / seconds
Query Executed:select id FROM `nm` where city='Sheep Springs' && SIC_code='5411'DB:business_master_new
loadtime:0.77621698379517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shiprock' limit 1
loadtime:0.7762668132782 / seconds
Query Executed:select id FROM `nm` where city='Shiprock' && SIC_code='5411'DB:business_master_new
loadtime:0.78007698059082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver City' limit 1
loadtime:0.78016090393066 / seconds
Query Executed:select id FROM `nm` where city='Silver City' && SIC_code='5411'DB:business_master_new
loadtime:0.79351782798767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smith Lake' limit 1
loadtime:0.79360580444336 / seconds
Query Executed:select id FROM `nm` where city='Smith Lake' && SIC_code='5411'DB:business_master_new
loadtime:0.79401278495789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Socorro' limit 1
loadtime:0.79406595230103 / seconds
Query Executed:select id FROM `nm` where city='Socorro' && SIC_code='5411'DB:business_master_new
loadtime:0.80160093307495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Solano' limit 1
loadtime:0.80167484283447 / seconds
Query Executed:select id FROM `nm` where city='Solano' && SIC_code='5411'DB:business_master_new
loadtime:0.80205178260803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springer' limit 1
loadtime:0.80210494995117 / seconds
Query Executed:select id FROM `nm` where city='Springer' && SIC_code='5411'DB:business_master_new
loadtime:0.80480790138245 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Vrain' limit 1
loadtime:0.80487489700317 / seconds
Query Executed:select id FROM `nm` where city='St Vrain' && SIC_code='5411'DB:business_master_new
loadtime:0.80526781082153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:0.80532097816467 / seconds
Query Executed:select id FROM `nm` where city='Stanley' && SIC_code='5411'DB:business_master_new
loadtime:0.80599284172058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunland Park' limit 1
loadtime:0.80604600906372 / seconds
Query Executed:select id FROM `nm` where city='Sunland Park' && SIC_code='5411'DB:business_master_new
loadtime:0.80902290344238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunspot' limit 1
loadtime:0.80909585952759 / seconds
Query Executed:select id FROM `nm` where city='Sunspot' && SIC_code='5411'DB:business_master_new
loadtime:0.80955791473389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taiban' limit 1
loadtime:0.80961084365845 / seconds
Query Executed:select id FROM `nm` where city='Taiban' && SIC_code='5411'DB:business_master_new
loadtime:0.80998301506042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tajique' limit 1
loadtime:0.81003499031067 / seconds
Query Executed:select id FROM `nm` where city='Tajique' && SIC_code='5411'DB:business_master_new
loadtime:0.81043291091919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taos' limit 1
loadtime:0.81048488616943 / seconds
Query Executed:select id FROM `nm` where city='Taos' && SIC_code='5411'DB:business_master_new
loadtime:0.83345794677734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taos Ski Valley' limit 1
loadtime:0.83360695838928 / seconds
Query Executed:select id FROM `nm` where city='Taos Ski Valley' && SIC_code='5411'DB:business_master_new
loadtime:0.83479380607605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tatum' limit 1
loadtime:0.83486700057983 / seconds
Query Executed:select id FROM `nm` where city='Tatum' && SIC_code='5411'DB:business_master_new
loadtime:0.83640289306641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tererro' limit 1
loadtime:0.83647799491882 / seconds
Query Executed:select id FROM `nm` where city='Tererro' && SIC_code='5411'DB:business_master_new
loadtime:0.83689188957214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tesuque' limit 1
loadtime:0.83695697784424 / seconds
Query Executed:select id FROM `nm` where city='Tesuque' && SIC_code='5411'DB:business_master_new
loadtime:0.83797478675842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Texico' limit 1
loadtime:0.83804082870483 / seconds
Query Executed:select id FROM `nm` where city='Texico' && SIC_code='5411'DB:business_master_new
loadtime:0.84969186782837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thoreau' limit 1
loadtime:0.84976601600647 / seconds
Query Executed:select id FROM `nm` where city='Thoreau' && SIC_code='5411'DB:business_master_new
loadtime:0.85127878189087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tierra Amarilla' limit 1
loadtime:0.85135293006897 / seconds
Query Executed:select id FROM `nm` where city='Tierra Amarilla' && SIC_code='5411'DB:business_master_new
loadtime:0.85270380973816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tijeras' limit 1
loadtime:0.85275983810425 / seconds
Query Executed:select id FROM `nm` where city='Tijeras' && SIC_code='5411'DB:business_master_new
loadtime:0.85816884040833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timberon' limit 1
loadtime:0.85824799537659 / seconds
Query Executed:select id FROM `nm` where city='Timberon' && SIC_code='5411'DB:business_master_new
loadtime:0.85912084579468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tinnie' limit 1
loadtime:0.85919284820557 / seconds
Query Executed:select id FROM `nm` where city='Tinnie' && SIC_code='5411'DB:business_master_new
loadtime:0.85964894294739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tohatchi' limit 1
loadtime:0.85970282554626 / seconds
Query Executed:select id FROM `nm` where city='Tohatchi' && SIC_code='5411'DB:business_master_new
loadtime:0.86047792434692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tome' limit 1
loadtime:0.86054587364197 / seconds
Query Executed:select id FROM `nm` where city='Tome' && SIC_code='5411'DB:business_master_new
loadtime:0.86119890213013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Torreon' limit 1
loadtime:0.86127281188965 / seconds
Query Executed:select id FROM `nm` where city='Torreon' && SIC_code='5411'DB:business_master_new
loadtime:0.86178588867188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trampas' limit 1
loadtime:0.86183881759644 / seconds
Query Executed:select id FROM `nm` where city='Trampas' && SIC_code='5411'DB:business_master_new
loadtime:0.86218595504761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trementina' limit 1
loadtime:0.86224699020386 / seconds
Query Executed:select id FROM `nm` where city='Trementina' && SIC_code='5411'DB:business_master_new
loadtime:0.86265683174133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tres Piedras' limit 1
loadtime:0.86270999908447 / seconds
Query Executed:select id FROM `nm` where city='Tres Piedras' && SIC_code='5411'DB:business_master_new
loadtime:0.86329889297485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truchas' limit 1
loadtime:0.86335897445679 / seconds
Query Executed:select id FROM `nm` where city='Truchas' && SIC_code='5411'DB:business_master_new
loadtime:0.86399388313293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truth Or Cnsqncs' limit 1
loadtime:0.86405992507935 / seconds
Query Executed:select id FROM `nm` where city='Truth Or Cnsqncs' && SIC_code='5411'DB:business_master_new
loadtime:0.86450481414795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truth Or Consequences' limit 1
loadtime:0.86455988883972 / seconds
Query Executed:select id FROM `nm` where city='Truth Or Consequences' && SIC_code='5411'DB:business_master_new
loadtime:0.87189388275146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tucumcari' limit 1
loadtime:0.87198400497437 / seconds
Query Executed:select id FROM `nm` where city='Tucumcari' && SIC_code='5411'DB:business_master_new
loadtime:0.87974882125854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tularosa' limit 1
loadtime:0.87983894348145 / seconds
Query Executed:select id FROM `nm` where city='Tularosa' && SIC_code='5411'DB:business_master_new
loadtime:0.8833270072937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyrone' limit 1
loadtime:0.88340401649475 / seconds
Query Executed:select id FROM `nm` where city='Tyrone' && SIC_code='5411'DB:business_master_new
loadtime:0.88407588005066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ute Park' limit 1
loadtime:0.88413000106812 / seconds
Query Executed:select id FROM `nm` where city='Ute Park' && SIC_code='5411'DB:business_master_new
loadtime:0.88458490371704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vadito' limit 1
loadtime:0.88463878631592 / seconds
Query Executed:select id FROM `nm` where city='Vadito' && SIC_code='5411'DB:business_master_new
loadtime:0.88523387908936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vado' limit 1
loadtime:0.88529682159424 / seconds
Query Executed:select id FROM `nm` where city='Vado' && SIC_code='5411'DB:business_master_new
loadtime:0.88594388961792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valdez' limit 1
loadtime:0.88599586486816 / seconds
Query Executed:select id FROM `nm` where city='Valdez' && SIC_code='5411'DB:business_master_new
loadtime:0.88644194602966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vallecitos' limit 1
loadtime:0.88649487495422 / seconds
Query Executed:select id FROM `nm` where city='Vallecitos' && SIC_code='5411'DB:business_master_new
loadtime:0.88693499565125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valmora' limit 1
loadtime:0.88698792457581 / seconds
Query Executed:select id FROM `nm` where city='Valmora' && SIC_code='5411'DB:business_master_new
loadtime:0.88738298416138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vanderwagen' limit 1
loadtime:0.88743901252747 / seconds
Query Executed:select id FROM `nm` where city='Vanderwagen' && SIC_code='5411'DB:business_master_new
loadtime:0.88813185691833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vaughn' limit 1
loadtime:0.88820195198059 / seconds
Query Executed:select id FROM `nm` where city='Vaughn' && SIC_code='5411'DB:business_master_new
loadtime:0.88940191268921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Veguita' limit 1
loadtime:0.88947796821594 / seconds
Query Executed:select id FROM `nm` where city='Veguita' && SIC_code='5411'DB:business_master_new
loadtime:0.89013195037842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Velarde' limit 1
loadtime:0.89018392562866 / seconds
Query Executed:select id FROM `nm` where city='Velarde' && SIC_code='5411'DB:business_master_new
loadtime:0.89200282096863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villanueva' limit 1
loadtime:0.89206981658936 / seconds
Query Executed:select id FROM `nm` where city='Villanueva' && SIC_code='5411'DB:business_master_new
loadtime:0.89251279830933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wagon Mound' limit 1
loadtime:0.89257884025574 / seconds
Query Executed:select id FROM `nm` where city='Wagon Mound' && SIC_code='5411'DB:business_master_new
loadtime:0.89428496360779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterflow' limit 1
loadtime:0.8943510055542 / seconds
Query Executed:select id FROM `nm` where city='Waterflow' && SIC_code='5411'DB:business_master_new
loadtime:0.89606690406799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watrous' limit 1
loadtime:0.89613795280457 / seconds
Query Executed:select id FROM `nm` where city='Watrous' && SIC_code='5411'DB:business_master_new
loadtime:0.89666795730591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weed' limit 1
loadtime:0.89672183990479 / seconds
Query Executed:select id FROM `nm` where city='Weed' && SIC_code='5411'DB:business_master_new
loadtime:0.89814591407776 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Sands' limit 1
loadtime:0.8982138633728 / seconds
Query Executed:select id FROM `nm` where city='White Sands' && SIC_code='5411'DB:business_master_new
loadtime:0.8995509147644 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Sands Missile Range' limit 1
loadtime:0.89960598945618 / seconds
Query Executed:select id FROM `nm` where city='White Sands Missile Range' && SIC_code='5411'DB:business_master_new
loadtime:0.90102386474609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whites City' limit 1
loadtime:0.90107583999634 / seconds
Query Executed:select id FROM `nm` where city='Whites City' && SIC_code='5411'DB:business_master_new
loadtime:0.90239691734314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willard' limit 1
loadtime:0.90245485305786 / seconds
Query Executed:select id FROM `nm` where city='Willard' && SIC_code='5411'DB:business_master_new
loadtime:0.90369296073914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:0.90375900268555 / seconds
Query Executed:select id FROM `nm` where city='Williamsburg' && SIC_code='5411'DB:business_master_new
loadtime:0.90542697906494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winston' limit 1
loadtime:0.90549397468567 / seconds
Query Executed:select id FROM `nm` where city='Winston' && SIC_code='5411'DB:business_master_new
loadtime:0.90681886672974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yatahey' limit 1
loadtime:0.90688586235046 / seconds
Query Executed:select id FROM `nm` where city='Yatahey' && SIC_code='5411'DB:business_master_new
loadtime:0.90826296806335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yeso' limit 1
loadtime:0.90832996368408 / seconds
Query Executed:select id FROM `nm` where city='Yeso' && SIC_code='5411'DB:business_master_new
loadtime:0.90876483917236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Youngsville' limit 1
loadtime:0.9088180065155 / seconds
Query Executed:select id FROM `nm` where city='Youngsville' && SIC_code='5411'DB:business_master_new
loadtime:0.90917778015137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zuni' limit 1
loadtime:0.90922880172729 / seconds
Query Executed:select id FROM `nm` where city='Zuni' && SIC_code='5411'DB:business_master_new
loadtime:0.92183589935303 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.92202496528625 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.92248892784119 / seconds
Operation template executed (chunk cache operation)
loadtime:0.9226508140564 / seconds
template override:Default
loadtime:0.9226930141449 / 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.92403793334961 / seconds
Template Constructed, Array Rows:49
loadtime:0.92458295822144 / seconds
TOTAL EXECUTION TIME: 0.92413
loadtime:0.92652678489685 / 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] => grocery-stores [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.92653799057007
TOTAL KEY ARRAYS: 69