Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:5.4121017456055E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00038599967956543 / seconds
host not found setting manual db connection
loadtime:0.00072717666625977 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0014190673828125 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0017361640930176 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0019299983978271 / seconds
zipcode:
loadtime:0.0019791126251221 / seconds
Query Executed:select * from search_referrer where page_hash='951675f90ccb8bbf2ed6124f26a2f789' limit 10 DB:ezrox_toadli
loadtime:0.0025331974029541 / seconds
Operation header executed (non global)
loadtime:0.0025920867919922 / seconds
Operation leaderboard executed (non global)
loadtime:0.002669095993042 / seconds
Operation square executed (non global)
loadtime:0.0027060508728027 / seconds
Operation square_bottom executed (non global)
loadtime:0.0027391910552979 / seconds
Operation smallsquare executed (non global)
loadtime:0.0027711391448975 / seconds
Operation headeradright executed (non global)
loadtime:0.0028030872344971 / seconds
Operation google_analytics executed (non global)
loadtime:0.002830982208252 / seconds
Operation topstories executed (non global)
loadtime:0.0029141902923584 / seconds
Operation businessnearyou executed (non global)
loadtime:0.002953052520752 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0029811859130859 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0036361217498779 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0040781497955322 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0041961669921875 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0043561458587646 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0044519901275635 / seconds
Template key: archive_menu pushed
loadtime:0.0044660568237305 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0044820308685303 / seconds
Template key: get_gravatar pushed
loadtime:0.0044929981231689 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0045030117034912 / seconds
*10)-10)+1 | start:0
loadtime:0.0045640468597412 / seconds
Query loaded from cache:select * from categories where cat_URLid='hotels-and-motels'
loadtime:0.004641056060791 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-mexico'
loadtime:0.0047261714935303 / seconds
DB connected to localhost business_master_new
loadtime:0.0051259994506836 / seconds
Query Executed:select * from `nm_catmap` where sic='7011' order by city ascDB:business_master_new
loadtime:0.033787965774536 / seconds
Query stored in cache : _QUERY_www.toadli.com2a8033bc32b6641675de8245b51c8f8f
loadtime:0.034394979476929 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-mexico'
loadtime:0.034442186355591 / seconds
Query Executed:select sum(totalcount) as totalsum from `nm_catmap` where sic='7011'DB:business_master_new
loadtime:0.036638975143433 / seconds
Query stored in cache : _QUERY_www.toadli.com9ea1fd4a1df371ce3497f455be0a074b
loadtime:0.036669015884399 / seconds
369 / 11
loadtime:0.036708116531372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abiquiu' limit 1
loadtime:0.036754131317139 / seconds
Query Executed:select id FROM `nm` where city='Abiquiu' && SIC_code='7011'DB:business_master_new
loadtime:0.06726598739624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alameda' limit 1
loadtime:0.067327976226807 / seconds
Query Executed:select id FROM `nm` where city='Alameda' && SIC_code='7011'DB:business_master_new
loadtime:0.068247079849243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alamogordo' limit 1
loadtime:0.068283081054688 / seconds
Query Executed:select id FROM `nm` where city='Alamogordo' && SIC_code='7011'DB:business_master_new
loadtime:0.077745199203491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albuquerque' limit 1
loadtime:0.077811002731323 / seconds
Query Executed:select id FROM `nm` where city='Albuquerque' && SIC_code='7011'DB:business_master_new
loadtime:0.53982520103455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alcalde' limit 1
loadtime:0.54012012481689 / seconds
Query Executed:select id FROM `nm` where city='Alcalde' && SIC_code='7011'DB:business_master_new
loadtime:0.55413603782654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Algodones' limit 1
loadtime:0.55418014526367 / seconds
Query Executed:select id FROM `nm` where city='Algodones' && SIC_code='7011'DB:business_master_new
loadtime:0.57287812232971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alto' limit 1
loadtime:0.57294297218323 / seconds
Query Executed:select id FROM `nm` where city='Alto' && SIC_code='7011'DB:business_master_new
loadtime:0.57400012016296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amalia' limit 1
loadtime:0.57406711578369 / seconds
Query Executed:select id FROM `nm` where city='Amalia' && SIC_code='7011'DB:business_master_new
loadtime:0.57551407814026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amistad' limit 1
loadtime:0.5755569934845 / seconds
Query Executed:select id FROM `nm` where city='Amistad' && SIC_code='7011'DB:business_master_new
loadtime:0.57867217063904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Angel Fire' limit 1
loadtime:0.57871913909912 / seconds
Query Executed:select id FROM `nm` where city='Angel Fire' && SIC_code='7011'DB:business_master_new
loadtime:0.57983613014221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Animas' limit 1
loadtime:0.57990002632141 / seconds
Query Executed:select id FROM `nm` where city='Animas' && SIC_code='7011'DB:business_master_new
loadtime:0.59704613685608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anthony' limit 1
loadtime:0.59710097312927 / seconds
Query Executed:select id FROM `nm` where city='Anthony' && SIC_code='7011'DB:business_master_new
loadtime:0.5979700088501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anton Chico' limit 1
loadtime:0.59801816940308 / seconds
Query Executed:select id FROM `nm` where city='Anton Chico' && SIC_code='7011'DB:business_master_new
loadtime:0.60901403427124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aragon' limit 1
loadtime:0.60906410217285 / seconds
Query Executed:select id FROM `nm` where city='Aragon' && SIC_code='7011'DB:business_master_new
loadtime:0.61071801185608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arenas Valley' limit 1
loadtime:0.61075806617737 / seconds
Query Executed:select id FROM `nm` where city='Arenas Valley' && SIC_code='7011'DB:business_master_new
loadtime:0.62087607383728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arrey' limit 1
loadtime:0.6210241317749 / seconds
Query Executed:select id FROM `nm` where city='Arrey' && SIC_code='7011'DB:business_master_new
loadtime:0.6261260509491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arroyo Hondo' limit 1
loadtime:0.62617611885071 / seconds
Query Executed:select id FROM `nm` where city='Arroyo Hondo' && SIC_code='7011'DB:business_master_new
loadtime:0.63470506668091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arroyo Seco' limit 1
loadtime:0.63475608825684 / seconds
Query Executed:select id FROM `nm` where city='Arroyo Seco' && SIC_code='7011'DB:business_master_new
loadtime:0.63566708564758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Artesia' limit 1
loadtime:0.63572907447815 / seconds
Query Executed:select id FROM `nm` where city='Artesia' && SIC_code='7011'DB:business_master_new
loadtime:0.63696908950806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aztec' limit 1
loadtime:0.63703203201294 / seconds
Query Executed:select id FROM `nm` where city='Aztec' && SIC_code='7011'DB:business_master_new
loadtime:0.63822412490845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bard' limit 1
loadtime:0.63827919960022 / seconds
Query Executed:select id FROM `nm` where city='Bard' && SIC_code='7011'DB:business_master_new
loadtime:0.6391921043396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayard' limit 1
loadtime:0.63923907279968 / seconds
Query Executed:select id FROM `nm` where city='Bayard' && SIC_code='7011'DB:business_master_new
loadtime:0.64002919197083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belen' limit 1
loadtime:0.64007902145386 / seconds
Query Executed:select id FROM `nm` where city='Belen' && SIC_code='7011'DB:business_master_new
loadtime:0.6414041519165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bell Ranch' limit 1
loadtime:0.64157319068909 / seconds
Query Executed:select id FROM `nm` where city='Bell Ranch' && SIC_code='7011'DB:business_master_new
loadtime:0.64192008972168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bent' limit 1
loadtime:0.64194798469543 / seconds
Query Executed:select id FROM `nm` where city='Bent' && SIC_code='7011'DB:business_master_new
loadtime:0.64579010009766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berino' limit 1
loadtime:0.64584016799927 / seconds
Query Executed:select id FROM `nm` where city='Berino' && SIC_code='7011'DB:business_master_new
loadtime:0.64827799797058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bernalillo' limit 1
loadtime:0.64831900596619 / seconds
Query Executed:select id FROM `nm` where city='Bernalillo' && SIC_code='7011'DB:business_master_new
loadtime:0.64949417114258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bingham' limit 1
loadtime:0.64965510368347 / seconds
Query Executed:select id FROM `nm` where city='Bingham' && SIC_code='7011'DB:business_master_new
loadtime:0.65055704116821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanco' limit 1
loadtime:0.65060520172119 / seconds
Query Executed:select id FROM `nm` where city='Blanco' && SIC_code='7011'DB:business_master_new
loadtime:0.65601801872253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield' limit 1
loadtime:0.65606498718262 / seconds
Query Executed:select id FROM `nm` where city='Bloomfield' && SIC_code='7011'DB:business_master_new
loadtime:0.65716505050659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluewater' limit 1
loadtime:0.65722513198853 / seconds
Query Executed:select id FROM `nm` where city='Bluewater' && SIC_code='7011'DB:business_master_new
loadtime:0.66179203987122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bosque' limit 1
loadtime:0.66183400154114 / seconds
Query Executed:select id FROM `nm` where city='Bosque' && SIC_code='7011'DB:business_master_new
loadtime:0.66638207435608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bosque Farms' limit 1
loadtime:0.66643118858337 / seconds
Query Executed:select id FROM `nm` where city='Bosque Farms' && SIC_code='7011'DB:business_master_new
loadtime:0.66730308532715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brimhall' limit 1
loadtime:0.66733813285828 / seconds
Query Executed:select id FROM `nm` where city='Brimhall' && SIC_code='7011'DB:business_master_new
loadtime:0.66855096817017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadview' limit 1
loadtime:0.66860318183899 / seconds
Query Executed:select id FROM `nm` where city='Broadview' && SIC_code='7011'DB:business_master_new
loadtime:0.67187714576721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckhorn' limit 1
loadtime:0.67192816734314 / seconds
Query Executed:select id FROM `nm` where city='Buckhorn' && SIC_code='7011'DB:business_master_new
loadtime:0.67479610443115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buena Vista' limit 1
loadtime:0.67485904693604 / seconds
Query Executed:select id FROM `nm` where city='Buena Vista' && SIC_code='7011'DB:business_master_new
loadtime:0.67719697952271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caballo' limit 1
loadtime:0.67723798751831 / seconds
Query Executed:select id FROM `nm` where city='Caballo' && SIC_code='7011'DB:business_master_new
loadtime:0.68396496772766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canjilon' limit 1
loadtime:0.68401408195496 / seconds
Query Executed:select id FROM `nm` where city='Canjilon' && SIC_code='7011'DB:business_master_new
loadtime:0.68883419036865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cannon Afb' limit 1
loadtime:0.68890118598938 / seconds
Query Executed:select id FROM `nm` where city='Cannon Afb' && SIC_code='7011'DB:business_master_new
loadtime:0.68966913223267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canoncito' limit 1
loadtime:0.6897120475769 / seconds
Query Executed:select id FROM `nm` where city='Canoncito' && SIC_code='7011'DB:business_master_new
loadtime:0.69088411331177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canones' limit 1
loadtime:0.69093298912048 / seconds
Query Executed:select id FROM `nm` where city='Canones' && SIC_code='7011'DB:business_master_new
loadtime:0.69268798828125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capitan' limit 1
loadtime:0.69272899627686 / seconds
Query Executed:select id FROM `nm` where city='Capitan' && SIC_code='7011'DB:business_master_new
loadtime:0.69360899925232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caprock' limit 1
loadtime:0.69366717338562 / seconds
Query Executed:select id FROM `nm` where city='Caprock' && SIC_code='7011'DB:business_master_new
loadtime:0.69477701187134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capulin' limit 1
loadtime:0.69481801986694 / seconds
Query Executed:select id FROM `nm` where city='Capulin' && SIC_code='7011'DB:business_master_new
loadtime:0.69828319549561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlsbad' limit 1
loadtime:0.69833302497864 / seconds
Query Executed:select id FROM `nm` where city='Carlsbad' && SIC_code='7011'DB:business_master_new
loadtime:0.69994616508484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrizozo' limit 1
loadtime:0.69999814033508 / seconds
Query Executed:select id FROM `nm` where city='Carrizozo' && SIC_code='7011'DB:business_master_new
loadtime:0.70090413093567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson' limit 1
loadtime:0.70096611976624 / seconds
Query Executed:select id FROM `nm` where city='Carson' && SIC_code='7011'DB:business_master_new
loadtime:0.70416808128357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casa Blanca' limit 1
loadtime:0.70421814918518 / seconds
Query Executed:select id FROM `nm` where city='Casa Blanca' && SIC_code='7011'DB:business_master_new
loadtime:0.7087230682373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Causey' limit 1
loadtime:0.70878505706787 / seconds
Query Executed:select id FROM `nm` where city='Causey' && SIC_code='7011'DB:business_master_new
loadtime:0.71126413345337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cebolla' limit 1
loadtime:0.7112991809845 / seconds
Query Executed:select id FROM `nm` where city='Cebolla' && SIC_code='7011'DB:business_master_new
loadtime:0.71287703514099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Crest' limit 1
loadtime:0.71292805671692 / seconds
Query Executed:select id FROM `nm` where city='Cedar Crest' && SIC_code='7011'DB:business_master_new
loadtime:0.71380996704102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central' limit 1
loadtime:0.71386504173279 / seconds
Query Executed:select id FROM `nm` where city='Central' && SIC_code='7011'DB:business_master_new
loadtime:0.71839308738708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cerrillos' limit 1
loadtime:0.71844601631165 / seconds
Query Executed:select id FROM `nm` where city='Cerrillos' && SIC_code='7011'DB:business_master_new
loadtime:0.71931314468384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cerro' limit 1
loadtime:0.71935701370239 / seconds
Query Executed:select id FROM `nm` where city='Cerro' && SIC_code='7011'DB:business_master_new
loadtime:0.72160220146179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chacon' limit 1
loadtime:0.72165298461914 / seconds
Query Executed:select id FROM `nm` where city='Chacon' && SIC_code='7011'DB:business_master_new
loadtime:0.72539520263672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chama' limit 1
loadtime:0.72543096542358 / seconds
Query Executed:select id FROM `nm` where city='Chama' && SIC_code='7011'DB:business_master_new
loadtime:0.72658514976501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chamberino' limit 1
loadtime:0.72665810585022 / seconds
Query Executed:select id FROM `nm` where city='Chamberino' && SIC_code='7011'DB:business_master_new
loadtime:0.72993111610413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chamisal' limit 1
loadtime:0.729984998703 / seconds
Query Executed:select id FROM `nm` where city='Chamisal' && SIC_code='7011'DB:business_master_new
loadtime:0.73883199691772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chaparral' limit 1
loadtime:0.73888206481934 / seconds
Query Executed:select id FROM `nm` where city='Chaparral' && SIC_code='7011'DB:business_master_new
loadtime:0.73970603942871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chimayo' limit 1
loadtime:0.73975014686584 / seconds
Query Executed:select id FROM `nm` where city='Chimayo' && SIC_code='7011'DB:business_master_new
loadtime:0.74064517021179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Church Rock' limit 1
loadtime:0.74068903923035 / seconds
Query Executed:select id FROM `nm` where city='Church Rock' && SIC_code='7011'DB:business_master_new
loadtime:0.74326014518738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cimarron' limit 1
loadtime:0.74330806732178 / seconds
Query Executed:select id FROM `nm` where city='Cimarron' && SIC_code='7011'DB:business_master_new
loadtime:0.74424409866333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claunch' limit 1
loadtime:0.74428701400757 / seconds
Query Executed:select id FROM `nm` where city='Claunch' && SIC_code='7011'DB:business_master_new
loadtime:0.74534606933594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clayton' limit 1
loadtime:0.74538707733154 / seconds
Query Executed:select id FROM `nm` where city='Clayton' && SIC_code='7011'DB:business_master_new
loadtime:0.74636816978455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.74642014503479 / seconds
Query Executed:select id FROM `nm` where city='Cleveland' && SIC_code='7011'DB:business_master_new
loadtime:0.74976897239685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cliff' limit 1
loadtime:0.74981904029846 / seconds
Query Executed:select id FROM `nm` where city='Cliff' && SIC_code='7011'DB:business_master_new
loadtime:0.75717115402222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clines Corners' limit 1
loadtime:0.75720906257629 / seconds
Query Executed:select id FROM `nm` where city='Clines Corners' && SIC_code='7011'DB:business_master_new
loadtime:0.75933218002319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cloudcroft' limit 1
loadtime:0.75938415527344 / seconds
Query Executed:select id FROM `nm` where city='Cloudcroft' && SIC_code='7011'DB:business_master_new
loadtime:0.76055598258972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clovis' limit 1
loadtime:0.76062107086182 / seconds
Query Executed:select id FROM `nm` where city='Clovis' && SIC_code='7011'DB:business_master_new
loadtime:0.76247000694275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cochiti Lake' limit 1
loadtime:0.76251316070557 / seconds
Query Executed:select id FROM `nm` where city='Cochiti Lake' && SIC_code='7011'DB:business_master_new
loadtime:0.76960301399231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cochiti Pueblo' limit 1
loadtime:0.76965403556824 / seconds
Query Executed:select id FROM `nm` where city='Cochiti Pueblo' && SIC_code='7011'DB:business_master_new
loadtime:0.7725841999054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:0.77262496948242 / seconds
Query Executed:select id FROM `nm` where city='Columbus' && SIC_code='7011'DB:business_master_new
loadtime:0.77345609664917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conchas Dam' limit 1
loadtime:0.77349710464478 / seconds
Query Executed:select id FROM `nm` where city='Conchas Dam' && SIC_code='7011'DB:business_master_new
loadtime:0.78300213813782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Continental Div' limit 1
loadtime:0.78323602676392 / seconds
Query Executed:select id FROM `nm` where city='Continental Div' && SIC_code='7011'DB:business_master_new
loadtime:0.78359198570251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Continental Divide' limit 1
loadtime:0.78362202644348 / seconds
Query Executed:select id FROM `nm` where city='Continental Divide' && SIC_code='7011'DB:business_master_new
loadtime:0.78721904754639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cordova' limit 1
loadtime:0.78735303878784 / seconds
Query Executed:select id FROM `nm` where city='Cordova' && SIC_code='7011'DB:business_master_new
loadtime:0.78962206840515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corona' limit 1
loadtime:0.78967308998108 / seconds
Query Executed:select id FROM `nm` where city='Corona' && SIC_code='7011'DB:business_master_new
loadtime:0.79050207138062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corrales' limit 1
loadtime:0.79056406021118 / seconds
Query Executed:select id FROM `nm` where city='Corrales' && SIC_code='7011'DB:business_master_new
loadtime:0.79171514511108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Costilla' limit 1
loadtime:0.79176712036133 / seconds
Query Executed:select id FROM `nm` where city='Costilla' && SIC_code='7011'DB:business_master_new
loadtime:0.79398798942566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Counselor' limit 1
loadtime:0.79405212402344 / seconds
Query Executed:select id FROM `nm` where city='Counselor' && SIC_code='7011'DB:business_master_new
loadtime:0.79546713829041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coyote' limit 1
loadtime:0.79550409317017 / seconds
Query Executed:select id FROM `nm` where city='Coyote' && SIC_code='7011'DB:business_master_new
loadtime:0.79907202720642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crossroads' limit 1
loadtime:0.79920601844788 / seconds
Query Executed:select id FROM `nm` where city='Crossroads' && SIC_code='7011'DB:business_master_new
loadtime:0.80134916305542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crownpoint' limit 1
loadtime:0.80144619941711 / seconds
Query Executed:select id FROM `nm` where city='Crownpoint' && SIC_code='7011'DB:business_master_new
loadtime:0.80241513252258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuba' limit 1
loadtime:0.80255007743835 / seconds
Query Executed:select id FROM `nm` where city='Cuba' && SIC_code='7011'DB:business_master_new
loadtime:0.80358219146729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cubero' limit 1
loadtime:0.8036470413208 / seconds
Query Executed:select id FROM `nm` where city='Cubero' && SIC_code='7011'DB:business_master_new
loadtime:0.80595302581787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuchillo' limit 1
loadtime:0.80607509613037 / seconds
Query Executed:select id FROM `nm` where city='Cuchillo' && SIC_code='7011'DB:business_master_new
loadtime:0.80708312988281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuervo' limit 1
loadtime:0.80721616744995 / seconds
Query Executed:select id FROM `nm` where city='Cuervo' && SIC_code='7011'DB:business_master_new
loadtime:0.81278204917908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Datil' limit 1
loadtime:0.81294703483582 / seconds
Query Executed:select id FROM `nm` where city='Datil' && SIC_code='7011'DB:business_master_new
loadtime:0.81390810012817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deming' limit 1
loadtime:0.81402802467346 / seconds
Query Executed:select id FROM `nm` where city='Deming' && SIC_code='7011'DB:business_master_new
loadtime:0.81551098823547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derry' limit 1
loadtime:0.81558012962341 / seconds
Query Executed:select id FROM `nm` where city='Derry' && SIC_code='7011'DB:business_master_new
loadtime:0.81770801544189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Des Moines' limit 1
loadtime:0.81781196594238 / seconds
Query Executed:select id FROM `nm` where city='Des Moines' && SIC_code='7011'DB:business_master_new
loadtime:0.82448816299438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dexter' limit 1
loadtime:0.82462596893311 / seconds
Query Executed:select id FROM `nm` where city='Dexter' && SIC_code='7011'DB:business_master_new
loadtime:0.82561111450195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dixon' limit 1
loadtime:0.82573819160461 / seconds
Query Executed:select id FROM `nm` where city='Dixon' && SIC_code='7011'DB:business_master_new
loadtime:0.83296704292297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dona Ana' limit 1
loadtime:0.8330991268158 / seconds
Query Executed:select id FROM `nm` where city='Dona Ana' && SIC_code='7011'DB:business_master_new
loadtime:0.84224414825439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dora' limit 1
loadtime:0.84237504005432 / seconds
Query Executed:select id FROM `nm` where city='Dora' && SIC_code='7011'DB:business_master_new
loadtime:0.85182213783264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dulce' limit 1
loadtime:0.85196805000305 / seconds
Query Executed:select id FROM `nm` where city='Dulce' && SIC_code='7011'DB:business_master_new
loadtime:0.85299301147461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duran' limit 1
loadtime:0.85316205024719 / seconds
Query Executed:select id FROM `nm` where city='Duran' && SIC_code='7011'DB:business_master_new
loadtime:0.85357904434204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Nest' limit 1
loadtime:0.85366916656494 / seconds
Query Executed:select id FROM `nm` where city='Eagle Nest' && SIC_code='7011'DB:business_master_new
loadtime:0.85471606254578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewood' limit 1
loadtime:0.85493302345276 / seconds
Query Executed:select id FROM `nm` where city='Edgewood' && SIC_code='7011'DB:business_master_new
loadtime:0.85682415962219 / seconds
Query loaded from cache:select * from geodata_geocity where city='El Prado' limit 1
loadtime:0.85702300071716 / seconds
Query Executed:select id FROM `nm` where city='El Prado' && SIC_code='7011'DB:business_master_new
loadtime:0.8597149848938 / seconds
Query loaded from cache:select * from geodata_geocity where city='El Rito' limit 1
loadtime:0.85979604721069 / seconds
Query Executed:select id FROM `nm` where city='El Rito' && SIC_code='7011'DB:business_master_new
loadtime:0.87018299102783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elephant Butte' limit 1
loadtime:0.87022519111633 / seconds
Query Executed:select id FROM `nm` where city='Elephant Butte' && SIC_code='7011'DB:business_master_new
loadtime:0.87257313728333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elida' limit 1
loadtime:0.87263202667236 / seconds
Query Executed:select id FROM `nm` where city='Elida' && SIC_code='7011'DB:business_master_new
loadtime:0.88709616661072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Embudo' limit 1
loadtime:0.88713216781616 / seconds
Query Executed:select id FROM `nm` where city='Embudo' && SIC_code='7011'DB:business_master_new
loadtime:0.89509606361389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Encino' limit 1
loadtime:0.89515614509583 / seconds
Query Executed:select id FROM `nm` where city='Encino' && SIC_code='7011'DB:business_master_new
loadtime:0.90096497535706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Espanola' limit 1
loadtime:0.90099406242371 / seconds
Query Executed:select id FROM `nm` where city='Espanola' && SIC_code='7011'DB:business_master_new
loadtime:0.90491414070129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estancia' limit 1
loadtime:0.90498399734497 / seconds
Query Executed:select id FROM `nm` where city='Estancia' && SIC_code='7011'DB:business_master_new
loadtime:0.90712118148804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eunice' limit 1
loadtime:0.90716505050659 / seconds
Query Executed:select id FROM `nm` where city='Eunice' && SIC_code='7011'DB:business_master_new
loadtime:0.90972208976746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairacres' limit 1
loadtime:0.90989518165588 / seconds
Query Executed:select id FROM `nm` where city='Fairacres' && SIC_code='7011'DB:business_master_new
loadtime:0.92080307006836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:0.92097115516663 / seconds
Query Executed:select id FROM `nm` where city='Fairview' && SIC_code='7011'DB:business_master_new
loadtime:0.92167210578918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.92179703712463 / seconds
Query Executed:select id FROM `nm` where city='Farmington' && SIC_code='7011'DB:business_master_new
loadtime:0.92483401298523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faywood' limit 1
loadtime:0.92505598068237 / seconds
Query Executed:select id FROM `nm` where city='Faywood' && SIC_code='7011'DB:business_master_new
loadtime:0.92847609519958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fence Lake' limit 1
loadtime:0.92854714393616 / seconds
Query Executed:select id FROM `nm` where city='Fence Lake' && SIC_code='7011'DB:business_master_new
loadtime:0.93003511428833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flora Vista' limit 1
loadtime:0.93013596534729 / seconds
Query Executed:select id FROM `nm` where city='Flora Vista' && SIC_code='7011'DB:business_master_new
loadtime:0.9311351776123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Floyd' limit 1
loadtime:0.93125820159912 / seconds
Query Executed:select id FROM `nm` where city='Floyd' && SIC_code='7011'DB:business_master_new
loadtime:0.93579316139221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flying H' limit 1
loadtime:0.9359450340271 / seconds
Query Executed:select id FROM `nm` where city='Flying H' && SIC_code='7011'DB:business_master_new
loadtime:0.93629717826843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Folsom' limit 1
loadtime:0.93640899658203 / seconds
Query Executed:select id FROM `nm` where city='Folsom' && SIC_code='7011'DB:business_master_new
loadtime:0.93991804122925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Bayard' limit 1
loadtime:0.94004607200623 / seconds
Query Executed:select id FROM `nm` where city='Fort Bayard' && SIC_code='7011'DB:business_master_new
loadtime:0.94357013702393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Stanton' limit 1
loadtime:0.94361114501953 / seconds
Query Executed:select id FROM `nm` where city='Fort Stanton' && SIC_code='7011'DB:business_master_new
loadtime:0.94710111618042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Sumner' limit 1
loadtime:0.94715714454651 / seconds
Query Executed:select id FROM `nm` where city='Fort Sumner' && SIC_code='7011'DB:business_master_new
loadtime:0.94825005531311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Wingate' limit 1
loadtime:0.94841599464417 / seconds
Query Executed:select id FROM `nm` where city='Fort Wingate' && SIC_code='7011'DB:business_master_new
loadtime:0.95665717124939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitland' limit 1
loadtime:0.95676517486572 / seconds
Query Executed:select id FROM `nm` where city='Fruitland' && SIC_code='7011'DB:business_master_new
loadtime:0.96882200241089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gallina' limit 1
loadtime:0.96899008750916 / seconds
Query Executed:select id FROM `nm` where city='Gallina' && SIC_code='7011'DB:business_master_new
loadtime:0.97248196601868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gallup' limit 1
loadtime:0.97259211540222 / seconds
Query Executed:select id FROM `nm` where city='Gallup' && SIC_code='7011'DB:business_master_new
loadtime:0.97831606864929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gamerco' limit 1
loadtime:0.9784300327301 / seconds
Query Executed:select id FROM `nm` where city='Gamerco' && SIC_code='7011'DB:business_master_new
loadtime:0.9836540222168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garfield' limit 1
loadtime:0.98370003700256 / seconds
Query Executed:select id FROM `nm` where city='Garfield' && SIC_code='7011'DB:business_master_new
loadtime:0.9908401966095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garita' limit 1
loadtime:0.99088716506958 / seconds
Query Executed:select id FROM `nm` where city='Garita' && SIC_code='7011'DB:business_master_new
loadtime:0.99178099632263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gila' limit 1
loadtime:0.99181914329529 / seconds
Query Executed:select id FROM `nm` where city='Gila' && SIC_code='7011'DB:business_master_new
loadtime:0.99656200408936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladstone' limit 1
loadtime:0.99661111831665 / seconds
Query Executed:select id FROM `nm` where city='Gladstone' && SIC_code='7011'DB:business_master_new
loadtime:0.99800515174866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glencoe' limit 1
loadtime:0.99804401397705 / seconds
Query Executed:select id FROM `nm` where city='Glencoe' && SIC_code='7011'DB:business_master_new
loadtime:1.0021460056305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:1.0021820068359 / seconds
Query Executed:select id FROM `nm` where city='Glenwood' && SIC_code='7011'DB:business_master_new
loadtime:1.0036470890045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glorieta' limit 1
loadtime:1.0036931037903 / seconds
Query Executed:select id FROM `nm` where city='Glorieta' && SIC_code='7011'DB:business_master_new
loadtime:1.0138370990753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grady' limit 1
loadtime:1.0140299797058 / seconds
Query Executed:select id FROM `nm` where city='Grady' && SIC_code='7011'DB:business_master_new
loadtime:1.0185151100159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grants' limit 1
loadtime:1.0185701847076 / seconds
Query Executed:select id FROM `nm` where city='Grants' && SIC_code='7011'DB:business_master_new
loadtime:1.0218341350555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grenville' limit 1
loadtime:1.0219180583954 / seconds
Query Executed:select id FROM `nm` where city='Grenville' && SIC_code='7011'DB:business_master_new
loadtime:1.0235691070557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guadalupita' limit 1
loadtime:1.0236041545868 / seconds
Query Executed:select id FROM `nm` where city='Guadalupita' && SIC_code='7011'DB:business_master_new
loadtime:1.0247921943665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hachita' limit 1
loadtime:1.0248341560364 / seconds
Query Executed:select id FROM `nm` where city='Hachita' && SIC_code='7011'DB:business_master_new
loadtime:1.0266029834747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hagerman' limit 1
loadtime:1.0266990661621 / seconds
Query Executed:select id FROM `nm` where city='Hagerman' && SIC_code='7011'DB:business_master_new
loadtime:1.0277891159058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:1.0279071331024 / seconds
Query Executed:select id FROM `nm` where city='Hanover' && SIC_code='7011'DB:business_master_new
loadtime:1.0342421531677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatch' limit 1
loadtime:1.0342950820923 / seconds
Query Executed:select id FROM `nm` where city='Hatch' && SIC_code='7011'DB:business_master_new
loadtime:1.0354850292206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hernandez' limit 1
loadtime:1.0355250835419 / seconds
Query Executed:select id FROM `nm` where city='Hernandez' && SIC_code='7011'DB:business_master_new
loadtime:1.0419521331787 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Rls Mtn Pk' limit 1
loadtime:1.0420069694519 / seconds
Query Executed:select id FROM `nm` where city='High Rls Mtn Pk' && SIC_code='7011'DB:business_master_new
loadtime:1.0424649715424 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Rolls Mountain Park' limit 1
loadtime:1.0424959659576 / seconds
Query Executed:select id FROM `nm` where city='High Rolls Mountain Park' && SIC_code='7011'DB:business_master_new
loadtime:1.0498900413513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:1.0500571727753 / seconds
Query Executed:select id FROM `nm` where city='Hillsboro' && SIC_code='7011'DB:business_master_new
loadtime:1.0527141094208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hobbs' limit 1
loadtime:1.0529041290283 / seconds
Query Executed:select id FROM `nm` where city='Hobbs' && SIC_code='7011'DB:business_master_new
loadtime:1.0556640625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holloman Afb' limit 1
loadtime:1.0558180809021 / seconds
Query Executed:select id FROM `nm` where city='Holloman Afb' && SIC_code='7011'DB:business_master_new
loadtime:1.0589621067047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holloman Air Force Base' limit 1
loadtime:1.0590569972992 / seconds
Query Executed:select id FROM `nm` where city='Holloman Air Force Base' && SIC_code='7011'DB:business_master_new
loadtime:1.0613641738892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holman' limit 1
loadtime:1.0614531040192 / seconds
Query Executed:select id FROM `nm` where city='Holman' && SIC_code='7011'DB:business_master_new
loadtime:1.0657761096954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hondo' limit 1
loadtime:1.0659329891205 / seconds
Query Executed:select id FROM `nm` where city='Hondo' && SIC_code='7011'DB:business_master_new
loadtime:1.0668849945068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hope' limit 1
loadtime:1.0670201778412 / seconds
Query Executed:select id FROM `nm` where city='Hope' && SIC_code='7011'DB:business_master_new
loadtime:1.0745670795441 / seconds
Query loaded from cache:select * from geodata_geocity where city='House' limit 1
loadtime:1.07461810112 / seconds
Query Executed:select id FROM `nm` where city='House' && SIC_code='7011'DB:business_master_new
loadtime:1.0845391750336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:1.0846061706543 / seconds
Query Executed:select id FROM `nm` where city='Hurley' && SIC_code='7011'DB:business_master_new
loadtime:1.0885970592499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isleta' limit 1
loadtime:1.0886490345001 / seconds
Query Executed:select id FROM `nm` where city='Isleta' && SIC_code='7011'DB:business_master_new
loadtime:1.0933589935303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jal' limit 1
loadtime:1.0934100151062 / seconds
Query Executed:select id FROM `nm` where city='Jal' && SIC_code='7011'DB:business_master_new
loadtime:1.0956110954285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:1.0956921577454 / seconds
Query Executed:select id FROM `nm` where city='Jamestown' && SIC_code='7011'DB:business_master_new
loadtime:1.097766160965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jarales' limit 1
loadtime:1.0978050231934 / seconds
Query Executed:select id FROM `nm` where city='Jarales' && SIC_code='7011'DB:business_master_new
loadtime:1.099650144577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jemez Pueblo' limit 1
loadtime:1.0998439788818 / seconds
Query Executed:select id FROM `nm` where city='Jemez Pueblo' && SIC_code='7011'DB:business_master_new
loadtime:1.1020159721375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jemez Springs' limit 1
loadtime:1.1020741462708 / seconds
Query Executed:select id FROM `nm` where city='Jemez Springs' && SIC_code='7011'DB:business_master_new
loadtime:1.1042470932007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenna' limit 1
loadtime:1.1043071746826 / seconds
Query Executed:select id FROM `nm` where city='Kenna' && SIC_code='7011'DB:business_master_new
loadtime:1.1050319671631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirtland' limit 1
loadtime:1.1050691604614 / seconds
Query Executed:select id FROM `nm` where city='Kirtland' && SIC_code='7011'DB:business_master_new
loadtime:1.1072721481323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirtland Afb' limit 1
loadtime:1.1073291301727 / seconds
Query Executed:select id FROM `nm` where city='Kirtland Afb' && SIC_code='7011'DB:business_master_new
loadtime:1.1208980083466 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Jara' limit 1
loadtime:1.1209511756897 / seconds
Query Executed:select id FROM `nm` where city='La Jara' && SIC_code='7011'DB:business_master_new
loadtime:1.1215090751648 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Joya' limit 1
loadtime:1.1215710639954 / seconds
Query Executed:select id FROM `nm` where city='La Joya' && SIC_code='7011'DB:business_master_new
loadtime:1.1222071647644 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Loma' limit 1
loadtime:1.1222369670868 / seconds
Query Executed:select id FROM `nm` where city='La Loma' && SIC_code='7011'DB:business_master_new
loadtime:1.1228351593018 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Luz' limit 1
loadtime:1.1228940486908 / seconds
Query Executed:select id FROM `nm` where city='La Luz' && SIC_code='7011'DB:business_master_new
loadtime:1.123820066452 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Madera' limit 1
loadtime:1.1238760948181 / seconds
Query Executed:select id FROM `nm` where city='La Madera' && SIC_code='7011'DB:business_master_new
loadtime:1.1249971389771 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Mesa' limit 1
loadtime:1.1250371932983 / seconds
Query Executed:select id FROM `nm` where city='La Mesa' && SIC_code='7011'DB:business_master_new
loadtime:1.1257719993591 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Plata' limit 1
loadtime:1.1258239746094 / seconds
Query Executed:select id FROM `nm` where city='La Plata' && SIC_code='7011'DB:business_master_new
loadtime:1.1313490867615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laguna' limit 1
loadtime:1.1314291954041 / seconds
Query Executed:select id FROM `nm` where city='Laguna' && SIC_code='7011'DB:business_master_new
loadtime:1.1322510242462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lajoya' limit 1
loadtime:1.1323139667511 / seconds
Query Executed:select id FROM `nm` where city='Lajoya' && SIC_code='7011'DB:business_master_new
loadtime:1.1326291561127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Arthur' limit 1
loadtime:1.1326901912689 / seconds
Query Executed:select id FROM `nm` where city='Lake Arthur' && SIC_code='7011'DB:business_master_new
loadtime:1.1411571502686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakewood' limit 1
loadtime:1.1412010192871 / seconds
Query Executed:select id FROM `nm` where city='Lakewood' && SIC_code='7011'DB:business_master_new
loadtime:1.1424779891968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamy' limit 1
loadtime:1.1425189971924 / seconds
Query Executed:select id FROM `nm` where city='Lamy' && SIC_code='7011'DB:business_master_new
loadtime:1.1463530063629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Las Cruces' limit 1
loadtime:1.1464099884033 / seconds
Query Executed:select id FROM `nm` where city='Las Cruces' && SIC_code='7011'DB:business_master_new
loadtime:1.1497800350189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Las Vegas' limit 1
loadtime:1.1498770713806 / seconds
Query Executed:select id FROM `nm` where city='Las Vegas' && SIC_code='7011'DB:business_master_new
loadtime:1.1512560844421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemitar' limit 1
loadtime:1.1513121128082 / seconds
Query Executed:select id FROM `nm` where city='Lemitar' && SIC_code='7011'DB:business_master_new
loadtime:1.1542720794678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:1.1543130874634 / seconds
Query Executed:select id FROM `nm` where city='Lincoln' && SIC_code='7011'DB:business_master_new
loadtime:1.1552419662476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lindrith' limit 1
loadtime:1.155308008194 / seconds
Query Executed:select id FROM `nm` where city='Lindrith' && SIC_code='7011'DB:business_master_new
loadtime:1.1586229801178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Llano' limit 1
loadtime:1.1586601734161 / seconds
Query Executed:select id FROM `nm` where city='Llano' && SIC_code='7011'DB:business_master_new
loadtime:1.1591730117798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loco Hills' limit 1
loadtime:1.1592199802399 / seconds
Query Executed:select id FROM `nm` where city='Loco Hills' && SIC_code='7011'DB:business_master_new
loadtime:1.1625239849091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Logan' limit 1
loadtime:1.162572145462 / seconds
Query Executed:select id FROM `nm` where city='Logan' && SIC_code='7011'DB:business_master_new
loadtime:1.1635360717773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lordsburg' limit 1
loadtime:1.1635930538177 / seconds
Query Executed:select id FROM `nm` where city='Lordsburg' && SIC_code='7011'DB:business_master_new
loadtime:1.1645641326904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Los Alamos' limit 1
loadtime:1.1646220684052 / seconds
Query Executed:select id FROM `nm` where city='Los Alamos' && SIC_code='7011'DB:business_master_new
loadtime:1.1659801006317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Los Lunas' limit 1
loadtime:1.166032075882 / seconds
Query Executed:select id FROM `nm` where city='Los Lunas' && SIC_code='7011'DB:business_master_new
loadtime:1.1673691272736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Los Ojos' limit 1
loadtime:1.1674389839172 / seconds
Query Executed:select id FROM `nm` where city='Los Ojos' && SIC_code='7011'DB:business_master_new
loadtime:1.1685960292816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loving' limit 1
loadtime:1.1686460971832 / seconds
Query Executed:select id FROM `nm` where city='Loving' && SIC_code='7011'DB:business_master_new
loadtime:1.1694521903992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovington' limit 1
loadtime:1.1695020198822 / seconds
Query Executed:select id FROM `nm` where city='Lovington' && SIC_code='7011'DB:business_master_new
loadtime:1.1706521511078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lumberton' limit 1
loadtime:1.1707119941711 / seconds
Query Executed:select id FROM `nm` where city='Lumberton' && SIC_code='7011'DB:business_master_new
loadtime:1.1710040569305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luna' limit 1
loadtime:1.1710450649261 / seconds
Query Executed:select id FROM `nm` where city='Luna' && SIC_code='7011'DB:business_master_new
loadtime:1.1718859672546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magdalena' limit 1
loadtime:1.1719219684601 / seconds
Query Executed:select id FROM `nm` where city='Magdalena' && SIC_code='7011'DB:business_master_new
loadtime:1.1727521419525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malaga' limit 1
loadtime:1.1728100776672 / seconds
Query Executed:select id FROM `nm` where city='Malaga' && SIC_code='7011'DB:business_master_new
loadtime:1.1733481884003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maljamar' limit 1
loadtime:1.1733989715576 / seconds
Query Executed:select id FROM `nm` where city='Maljamar' && SIC_code='7011'DB:business_master_new
loadtime:1.1751430034637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxwell' limit 1
loadtime:1.1751930713654 / seconds
Query Executed:select id FROM `nm` where city='Maxwell' && SIC_code='7011'DB:business_master_new
loadtime:1.1768691539764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayhill' limit 1
loadtime:1.1769120693207 / seconds
Query Executed:select id FROM `nm` where city='Mayhill' && SIC_code='7011'DB:business_master_new
loadtime:1.1777141094208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Alister' limit 1
loadtime:1.1777729988098 / seconds
Query Executed:select id FROM `nm` where city='Mc Alister' && SIC_code='7011'DB:business_master_new
loadtime:1.1780481338501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Donald' limit 1
loadtime:1.1780831813812 / seconds
Query Executed:select id FROM `nm` where city='Mc Donald' && SIC_code='7011'DB:business_master_new
loadtime:1.1787800788879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Intosh' limit 1
loadtime:1.1788291931152 / seconds
Query Executed:select id FROM `nm` where city='Mc Intosh' && SIC_code='7011'DB:business_master_new
loadtime:1.179083108902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medanales' limit 1
loadtime:1.1791241168976 / seconds
Query Executed:select id FROM `nm` where city='Medanales' && SIC_code='7011'DB:business_master_new
loadtime:1.1793751716614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melrose' limit 1
loadtime:1.1794111728668 / seconds
Query Executed:select id FROM `nm` where city='Melrose' && SIC_code='7011'DB:business_master_new
loadtime:1.1801860332489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mentmore' limit 1
loadtime:1.1802351474762 / seconds
Query Executed:select id FROM `nm` where city='Mentmore' && SIC_code='7011'DB:business_master_new
loadtime:1.1809830665588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mescalero' limit 1
loadtime:1.1810190677643 / seconds
Query Executed:select id FROM `nm` where city='Mescalero' && SIC_code='7011'DB:business_master_new
loadtime:1.181871175766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesilla' limit 1
loadtime:1.1819171905518 / seconds
Query Executed:select id FROM `nm` where city='Mesilla' && SIC_code='7011'DB:business_master_new
loadtime:1.1827700138092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesilla Park' limit 1
loadtime:1.1828281879425 / seconds
Query Executed:select id FROM `nm` where city='Mesilla Park' && SIC_code='7011'DB:business_master_new
loadtime:1.1836731433868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesquite' limit 1
loadtime:1.1837100982666 / seconds
Query Executed:select id FROM `nm` where city='Mesquite' && SIC_code='7011'DB:business_master_new
loadtime:1.184494972229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mexican Springs' limit 1
loadtime:1.1845440864563 / seconds
Query Executed:select id FROM `nm` where city='Mexican Springs' && SIC_code='7011'DB:business_master_new
loadtime:1.1847920417786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miami' limit 1
loadtime:1.184828042984 / seconds
Query Executed:select id FROM `nm` where city='Miami' && SIC_code='7011'DB:business_master_new
loadtime:1.1853890419006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milan' limit 1
loadtime:1.1854372024536 / seconds
Query Executed:select id FROM `nm` where city='Milan' && SIC_code='7011'DB:business_master_new
loadtime:1.1863150596619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mills' limit 1
loadtime:1.1863741874695 / seconds
Query Executed:select id FROM `nm` where city='Mills' && SIC_code='7011'DB:business_master_new
loadtime:1.1871621608734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milnesand' limit 1
loadtime:1.1871981620789 / seconds
Query Executed:select id FROM `nm` where city='Milnesand' && SIC_code='7011'DB:business_master_new
loadtime:1.187667131424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mimbres' limit 1
loadtime:1.1877160072327 / seconds
Query Executed:select id FROM `nm` where city='Mimbres' && SIC_code='7011'DB:business_master_new
loadtime:1.1891620159149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mogollon' limit 1
loadtime:1.1892111301422 / seconds
Query Executed:select id FROM `nm` where city='Mogollon' && SIC_code='7011'DB:business_master_new
loadtime:1.1894471645355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montezuma' limit 1
loadtime:1.1894891262054 / seconds
Query Executed:select id FROM `nm` where city='Montezuma' && SIC_code='7011'DB:business_master_new
loadtime:1.1900501251221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:1.1900930404663 / seconds
Query Executed:select id FROM `nm` where city='Monticello' && SIC_code='7011'DB:business_master_new
loadtime:1.1906020641327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monument' limit 1
loadtime:1.1906480789185 / seconds
Query Executed:select id FROM `nm` where city='Monument' && SIC_code='7011'DB:business_master_new
loadtime:1.1924941539764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mora' limit 1
loadtime:1.1925420761108 / seconds
Query Executed:select id FROM `nm` where city='Mora' && SIC_code='7011'DB:business_master_new
loadtime:1.1934111118317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moriarty' limit 1
loadtime:1.1934690475464 / seconds
Query Executed:select id FROM `nm` where city='Moriarty' && SIC_code='7011'DB:business_master_new
loadtime:1.1946229934692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mosquero' limit 1
loadtime:1.1946821212769 / seconds
Query Executed:select id FROM `nm` where city='Mosquero' && SIC_code='7011'DB:business_master_new
loadtime:1.2017621994019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountainair' limit 1
loadtime:1.2018120288849 / seconds
Query Executed:select id FROM `nm` where city='Mountainair' && SIC_code='7011'DB:business_master_new
loadtime:1.2027080059052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mule Creek' limit 1
loadtime:1.2027549743652 / seconds
Query Executed:select id FROM `nm` where city='Mule Creek' && SIC_code='7011'DB:business_master_new
loadtime:1.2031261920929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nageezi' limit 1
loadtime:1.2031719684601 / seconds
Query Executed:select id FROM `nm` where city='Nageezi' && SIC_code='7011'DB:business_master_new
loadtime:1.2035551071167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nara Visa' limit 1
loadtime:1.2036039829254 / seconds
Query Executed:select id FROM `nm` where city='Nara Visa' && SIC_code='7011'DB:business_master_new
loadtime:1.2078800201416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Navajo' limit 1
loadtime:1.2079391479492 / seconds
Query Executed:select id FROM `nm` where city='Navajo' && SIC_code='7011'DB:business_master_new
loadtime:1.2183439731598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Navajo Dam' limit 1
loadtime:1.2184281349182 / seconds
Query Executed:select id FROM `nm` where city='Navajo Dam' && SIC_code='7011'DB:business_master_new
loadtime:1.2198820114136 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Laguna' limit 1
loadtime:1.2199501991272 / seconds
Query Executed:select id FROM `nm` where city='New Laguna' && SIC_code='7011'DB:business_master_new
loadtime:1.2206959724426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newcomb' limit 1
loadtime:1.2207481861115 / seconds
Query Executed:select id FROM `nm` where city='Newcomb' && SIC_code='7011'DB:business_master_new
loadtime:1.2227261066437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newkirk' limit 1
loadtime:1.2227680683136 / seconds
Query Executed:select id FROM `nm` where city='Newkirk' && SIC_code='7011'DB:business_master_new
loadtime:1.2231850624084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nogal' limit 1
loadtime:1.2232370376587 / seconds
Query Executed:select id FROM `nm` where city='Nogal' && SIC_code='7011'DB:business_master_new
loadtime:1.2267560958862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocate' limit 1
loadtime:1.2268080711365 / seconds
Query Executed:select id FROM `nm` where city='Ocate' && SIC_code='7011'DB:business_master_new
loadtime:1.2271790504456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ojo Caliente' limit 1
loadtime:1.227215051651 / seconds
Query Executed:select id FROM `nm` where city='Ojo Caliente' && SIC_code='7011'DB:business_master_new
loadtime:1.2281501293182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ojo Feliz' limit 1
loadtime:1.2282021045685 / seconds
Query Executed:select id FROM `nm` where city='Ojo Feliz' && SIC_code='7011'DB:business_master_new
loadtime:1.2284741401672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ojo Sarco' limit 1
loadtime:1.228520154953 / seconds
Query Executed:select id FROM `nm` where city='Ojo Sarco' && SIC_code='7011'DB:business_master_new
loadtime:1.2290179729462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Organ' limit 1
loadtime:1.2290570735931 / seconds
Query Executed:select id FROM `nm` where city='Organ' && SIC_code='7011'DB:business_master_new
loadtime:1.229907989502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orogrande' limit 1
loadtime:1.2299401760101 / seconds
Query Executed:select id FROM `nm` where city='Orogrande' && SIC_code='7011'DB:business_master_new
loadtime:1.2303102016449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paguate' limit 1
loadtime:1.2303621768951 / seconds
Query Executed:select id FROM `nm` where city='Paguate' && SIC_code='7011'DB:business_master_new
loadtime:1.2306530475616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pecos' limit 1
loadtime:1.2306900024414 / seconds
Query Executed:select id FROM `nm` where city='Pecos' && SIC_code='7011'DB:business_master_new
loadtime:1.2315990924835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pena Blanca' limit 1
loadtime:1.2316751480103 / seconds
Query Executed:select id FROM `nm` where city='Pena Blanca' && SIC_code='7011'DB:business_master_new
loadtime:1.2323660850525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penasco' limit 1
loadtime:1.2324199676514 / seconds
Query Executed:select id FROM `nm` where city='Penasco' && SIC_code='7011'DB:business_master_new
loadtime:1.233204126358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pep' limit 1
loadtime:1.2332441806793 / seconds
Query Executed:select id FROM `nm` where city='Pep' && SIC_code='7011'DB:business_master_new
loadtime:1.2355921268463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peralta' limit 1
loadtime:1.2356281280518 / seconds
Query Executed:select id FROM `nm` where city='Peralta' && SIC_code='7011'DB:business_master_new
loadtime:1.2365341186523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petaca' limit 1
loadtime:1.2365829944611 / seconds
Query Executed:select id FROM `nm` where city='Petaca' && SIC_code='7011'DB:business_master_new
loadtime:1.2368941307068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Picacho' limit 1
loadtime:1.236937046051 / seconds
Query Executed:select id FROM `nm` where city='Picacho' && SIC_code='7011'DB:business_master_new
loadtime:1.2383460998535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pie Town' limit 1
loadtime:1.2383830547333 / seconds
Query Executed:select id FROM `nm` where city='Pie Town' && SIC_code='7011'DB:business_master_new
loadtime:1.2397229671478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinehill' limit 1
loadtime:1.2397780418396 / seconds
Query Executed:select id FROM `nm` where city='Pinehill' && SIC_code='7011'DB:business_master_new
loadtime:1.2419559955597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinon' limit 1
loadtime:1.2419981956482 / seconds
Query Executed:select id FROM `nm` where city='Pinon' && SIC_code='7011'DB:business_master_new
loadtime:1.2427849769592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinos Altos' limit 1
loadtime:1.2428321838379 / seconds
Query Executed:select id FROM `nm` where city='Pinos Altos' && SIC_code='7011'DB:business_master_new
loadtime:1.2449421882629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Placitas' limit 1
loadtime:1.2449929714203 / seconds
Query Executed:select id FROM `nm` where city='Placitas' && SIC_code='7011'DB:business_master_new
loadtime:1.2458801269531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Playas' limit 1
loadtime:1.2459311485291 / seconds
Query Executed:select id FROM `nm` where city='Playas' && SIC_code='7011'DB:business_master_new
loadtime:1.2462751865387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pojoaque Valley' limit 1
loadtime:1.2463221549988 / seconds
Query Executed:select id FROM `nm` where city='Pojoaque Valley' && SIC_code='7011'DB:business_master_new
loadtime:1.2466690540314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polvadera' limit 1
loadtime:1.246707201004 / seconds
Query Executed:select id FROM `nm` where city='Polvadera' && SIC_code='7011'DB:business_master_new
loadtime:1.2470750808716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ponderosa' limit 1
loadtime:1.2471151351929 / seconds
Query Executed:select id FROM `nm` where city='Ponderosa' && SIC_code='7011'DB:business_master_new
loadtime:1.2478070259094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portales' limit 1
loadtime:1.2478401660919 / seconds
Query Executed:select id FROM `nm` where city='Portales' && SIC_code='7011'DB:business_master_new
loadtime:1.2490940093994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prewitt' limit 1
loadtime:1.24915599823 / seconds
Query Executed:select id FROM `nm` where city='Prewitt' && SIC_code='7011'DB:business_master_new
loadtime:1.2499670982361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pueblo Of Acoma' limit 1
loadtime:1.2499980926514 / seconds
Query Executed:select id FROM `nm` where city='Pueblo Of Acoma' && SIC_code='7011'DB:business_master_new
loadtime:1.2513301372528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quay' limit 1
loadtime:1.2513899803162 / seconds
Query Executed:select id FROM `nm` where city='Quay' && SIC_code='7011'DB:business_master_new
loadtime:1.25230717659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quemado' limit 1
loadtime:1.2523500919342 / seconds
Query Executed:select id FROM `nm` where city='Quemado' && SIC_code='7011'DB:business_master_new
loadtime:1.2542991638184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Questa' limit 1
loadtime:1.2543530464172 / seconds
Query Executed:select id FROM `nm` where city='Questa' && SIC_code='7011'DB:business_master_new
loadtime:1.2552790641785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radium Springs' limit 1
loadtime:1.2553231716156 / seconds
Query Executed:select id FROM `nm` where city='Radium Springs' && SIC_code='7011'DB:business_master_new
loadtime:1.2562000751495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rainsville' limit 1
loadtime:1.2562401294708 / seconds
Query Executed:select id FROM `nm` where city='Rainsville' && SIC_code='7011'DB:business_master_new
loadtime:1.2565150260925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramah' limit 1
loadtime:1.2565591335297 / seconds
Query Executed:select id FROM `nm` where city='Ramah' && SIC_code='7011'DB:business_master_new
loadtime:1.2573511600494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ranchos De Taos' limit 1
loadtime:1.2574050426483 / seconds
Query Executed:select id FROM `nm` where city='Ranchos De Taos' && SIC_code='7011'DB:business_master_new
loadtime:1.2583920955658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raton' limit 1
loadtime:1.2584362030029 / seconds
Query Executed:select id FROM `nm` where city='Raton' && SIC_code='7011'DB:business_master_new
loadtime:1.2597100734711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red River' limit 1
loadtime:1.2597851753235 / seconds
Query Executed:select id FROM `nm` where city='Red River' && SIC_code='7011'DB:business_master_new
loadtime:1.2612509727478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redrock' limit 1
loadtime:1.2613620758057 / seconds
Query Executed:select id FROM `nm` where city='Redrock' && SIC_code='7011'DB:business_master_new
loadtime:1.2617449760437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Regina' limit 1
loadtime:1.2618000507355 / seconds
Query Executed:select id FROM `nm` where city='Regina' && SIC_code='7011'DB:business_master_new
loadtime:1.2621631622314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rehoboth' limit 1
loadtime:1.2622301578522 / seconds
Query Executed:select id FROM `nm` where city='Rehoboth' && SIC_code='7011'DB:business_master_new
loadtime:1.2626609802246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reserve' limit 1
loadtime:1.2627081871033 / seconds
Query Executed:select id FROM `nm` where city='Reserve' && SIC_code='7011'DB:business_master_new
loadtime:1.2635581493378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ribera' limit 1
loadtime:1.263612985611 / seconds
Query Executed:select id FROM `nm` where city='Ribera' && SIC_code='7011'DB:business_master_new
loadtime:1.2645070552826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rincon' limit 1
loadtime:1.264564037323 / seconds
Query Executed:select id FROM `nm` where city='Rincon' && SIC_code='7011'DB:business_master_new
loadtime:1.2652461528778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio Rancho' limit 1
loadtime:1.2652950286865 / seconds
Query Executed:select id FROM `nm` where city='Rio Rancho' && SIC_code='7011'DB:business_master_new
loadtime:1.267040014267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rociada' limit 1
loadtime:1.2670850753784 / seconds
Query Executed:select id FROM `nm` where city='Rociada' && SIC_code='7011'DB:business_master_new
loadtime:1.2674810886383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rodeo' limit 1
loadtime:1.2675302028656 / seconds
Query Executed:select id FROM `nm` where city='Rodeo' && SIC_code='7011'DB:business_master_new
loadtime:1.2681469917297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rogers' limit 1
loadtime:1.2681941986084 / seconds
Query Executed:select id FROM `nm` where city='Rogers' && SIC_code='7011'DB:business_master_new
loadtime:1.2690410614014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roswell' limit 1
loadtime:1.2690870761871 / seconds
Query Executed:select id FROM `nm` where city='Roswell' && SIC_code='7011'DB:business_master_new
loadtime:1.2713551521301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowe' limit 1
loadtime:1.2714459896088 / seconds
Query Executed:select id FROM `nm` where city='Rowe' && SIC_code='7011'DB:business_master_new
loadtime:1.272274017334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roy' limit 1
loadtime:1.2723300457001 / seconds
Query Executed:select id FROM `nm` where city='Roy' && SIC_code='7011'DB:business_master_new
loadtime:1.2731120586395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruidoso' limit 1
loadtime:1.2731530666351 / seconds
Query Executed:select id FROM `nm` where city='Ruidoso' && SIC_code='7011'DB:business_master_new
loadtime:1.2752451896667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruidoso Downs' limit 1
loadtime:1.2753551006317 / seconds
Query Executed:select id FROM `nm` where city='Ruidoso Downs' && SIC_code='7011'DB:business_master_new
loadtime:1.2763950824738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutheron' limit 1
loadtime:1.2764701843262 / seconds
Query Executed:select id FROM `nm` where city='Rutheron' && SIC_code='7011'DB:business_master_new
loadtime:1.2768151760101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sacramento' limit 1
loadtime:1.2768759727478 / seconds
Query Executed:select id FROM `nm` where city='Sacramento' && SIC_code='7011'DB:business_master_new
loadtime:1.2774381637573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Vrain' limit 1
loadtime:1.2774991989136 / seconds
Query Executed:select id FROM `nm` where city='Saint Vrain' && SIC_code='7011'DB:business_master_new
loadtime:1.2778041362762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:1.2778491973877 / seconds
Query Executed:select id FROM `nm` where city='Salem' && SIC_code='7011'DB:business_master_new
loadtime:1.2786571979523 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Acacia' limit 1
loadtime:1.2787079811096 / seconds
Query Executed:select id FROM `nm` where city='San Acacia' && SIC_code='7011'DB:business_master_new
loadtime:1.2790911197662 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Antonio' limit 1
loadtime:1.2791380882263 / seconds
Query Executed:select id FROM `nm` where city='San Antonio' && SIC_code='7011'DB:business_master_new
loadtime:1.2798690795898 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Cristobal' limit 1
loadtime:1.2799210548401 / seconds
Query Executed:select id FROM `nm` where city='San Cristobal' && SIC_code='7011'DB:business_master_new
loadtime:1.2817280292511 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Fidel' limit 1
loadtime:1.2817931175232 / seconds
Query Executed:select id FROM `nm` where city='San Fidel' && SIC_code='7011'DB:business_master_new
loadtime:1.2826261520386 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Jon' limit 1
loadtime:1.2826550006866 / seconds
Query Executed:select id FROM `nm` where city='San Jon' && SIC_code='7011'DB:business_master_new
loadtime:1.2835330963135 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Jose' limit 1
loadtime:1.2836031913757 / seconds
Query Executed:select id FROM `nm` where city='San Jose' && SIC_code='7011'DB:business_master_new
loadtime:1.2841789722443 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Juan Pueblo' limit 1
loadtime:1.2842190265656 / seconds
Query Executed:select id FROM `nm` where city='San Juan Pueblo' && SIC_code='7011'DB:business_master_new
loadtime:1.2849671840668 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Lorenzo' limit 1
loadtime:1.2850000858307 / seconds
Query Executed:select id FROM `nm` where city='San Lorenzo' && SIC_code='7011'DB:business_master_new
loadtime:1.2852690219879 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Miguel' limit 1
loadtime:1.2853190898895 / seconds
Query Executed:select id FROM `nm` where city='San Miguel' && SIC_code='7011'DB:business_master_new
loadtime:1.2857789993286 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Patricio' limit 1
loadtime:1.2858130931854 / seconds
Query Executed:select id FROM `nm` where city='San Patricio' && SIC_code='7011'DB:business_master_new
loadtime:1.2863121032715 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Rafael' limit 1
loadtime:1.2863571643829 / seconds
Query Executed:select id FROM `nm` where city='San Rafael' && SIC_code='7011'DB:business_master_new
loadtime:1.2866630554199 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Ysidro' limit 1
loadtime:1.2867109775543 / seconds
Query Executed:select id FROM `nm` where city='San Ysidro' && SIC_code='7011'DB:business_master_new
loadtime:1.2885291576385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandia Park' limit 1
loadtime:1.2885661125183 / seconds
Query Executed:select id FROM `nm` where city='Sandia Park' && SIC_code='7011'DB:business_master_new
loadtime:1.2894539833069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanostee' limit 1
loadtime:1.2895081043243 / seconds
Query Executed:select id FROM `nm` where city='Sanostee' && SIC_code='7011'DB:business_master_new
loadtime:1.2898750305176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Clara' limit 1
loadtime:1.2899050712585 / seconds
Query Executed:select id FROM `nm` where city='Santa Clara' && SIC_code='7011'DB:business_master_new
loadtime:1.2907681465149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Cruz' limit 1
loadtime:1.2908260822296 / seconds
Query Executed:select id FROM `nm` where city='Santa Cruz' && SIC_code='7011'DB:business_master_new
loadtime:1.2916970252991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Fe' limit 1
loadtime:1.2917530536652 / seconds
Query Executed:select id FROM `nm` where city='Santa Fe' && SIC_code='7011'DB:business_master_new
loadtime:1.3051099777222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Rosa' limit 1
loadtime:1.3052680492401 / seconds
Query Executed:select id FROM `nm` where city='Santa Rosa' && SIC_code='7011'DB:business_master_new
loadtime:1.3064930438995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Teresa' limit 1
loadtime:1.3065810203552 / seconds
Query Executed:select id FROM `nm` where city='Santa Teresa' && SIC_code='7011'DB:business_master_new
loadtime:1.3074781894684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santo Domingo Pb' limit 1
loadtime:1.3075389862061 / seconds
Query Executed:select id FROM `nm` where city='Santo Domingo Pb' && SIC_code='7011'DB:business_master_new
loadtime:1.3078169822693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santo Domingo Pueblo' limit 1
loadtime:1.3078591823578 / seconds
Query Executed:select id FROM `nm` where city='Santo Domingo Pueblo' && SIC_code='7011'DB:business_master_new
loadtime:1.3090491294861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sapello' limit 1
loadtime:1.309091091156 / seconds
Query Executed:select id FROM `nm` where city='Sapello' && SIC_code='7011'DB:business_master_new
loadtime:1.3098759651184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seboyeta' limit 1
loadtime:1.3099119663239 / seconds
Query Executed:select id FROM `nm` where city='Seboyeta' && SIC_code='7011'DB:business_master_new
loadtime:1.3102030754089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedan' limit 1
loadtime:1.3102431297302 / seconds
Query Executed:select id FROM `nm` where city='Sedan' && SIC_code='7011'DB:business_master_new
loadtime:1.310595035553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:1.3106319904327 / seconds
Query Executed:select id FROM `nm` where city='Seneca' && SIC_code='7011'DB:business_master_new
loadtime:1.310898065567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Serafina' limit 1
loadtime:1.310937166214 / seconds
Query Executed:select id FROM `nm` where city='Serafina' && SIC_code='7011'DB:business_master_new
loadtime:1.3112461566925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheep Springs' limit 1
loadtime:1.3112981319427 / seconds
Query Executed:select id FROM `nm` where city='Sheep Springs' && SIC_code='7011'DB:business_master_new
loadtime:1.3119521141052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shiprock' limit 1
loadtime:1.311989068985 / seconds
Query Executed:select id FROM `nm` where city='Shiprock' && SIC_code='7011'DB:business_master_new
loadtime:1.3128380775452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver City' limit 1
loadtime:1.3128881454468 / seconds
Query Executed:select id FROM `nm` where city='Silver City' && SIC_code='7011'DB:business_master_new
loadtime:1.3144381046295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smith Lake' limit 1
loadtime:1.3144919872284 / seconds
Query Executed:select id FROM `nm` where city='Smith Lake' && SIC_code='7011'DB:business_master_new
loadtime:1.3148131370544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Socorro' limit 1
loadtime:1.3148679733276 / seconds
Query Executed:select id FROM `nm` where city='Socorro' && SIC_code='7011'DB:business_master_new
loadtime:1.3160300254822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Solano' limit 1
loadtime:1.3160710334778 / seconds
Query Executed:select id FROM `nm` where city='Solano' && SIC_code='7011'DB:business_master_new
loadtime:1.3163850307465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springer' limit 1
loadtime:1.3164541721344 / seconds
Query Executed:select id FROM `nm` where city='Springer' && SIC_code='7011'DB:business_master_new
loadtime:1.3173401355743 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Vrain' limit 1
loadtime:1.3173830509186 / seconds
Query Executed:select id FROM `nm` where city='St Vrain' && SIC_code='7011'DB:business_master_new
loadtime:1.3176720142365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:1.3177101612091 / seconds
Query Executed:select id FROM `nm` where city='Stanley' && SIC_code='7011'DB:business_master_new
loadtime:1.3185060024261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunland Park' limit 1
loadtime:1.3185451030731 / seconds
Query Executed:select id FROM `nm` where city='Sunland Park' && SIC_code='7011'DB:business_master_new
loadtime:1.3193881511688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunspot' limit 1
loadtime:1.3194451332092 / seconds
Query Executed:select id FROM `nm` where city='Sunspot' && SIC_code='7011'DB:business_master_new
loadtime:1.3198211193085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taiban' limit 1
loadtime:1.3198871612549 / seconds
Query Executed:select id FROM `nm` where city='Taiban' && SIC_code='7011'DB:business_master_new
loadtime:1.3202459812164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tajique' limit 1
loadtime:1.320296049118 / seconds
Query Executed:select id FROM `nm` where city='Tajique' && SIC_code='7011'DB:business_master_new
loadtime:1.32097697258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taos' limit 1
loadtime:1.3210141658783 / seconds
Query Executed:select id FROM `nm` where city='Taos' && SIC_code='7011'DB:business_master_new
loadtime:1.3234260082245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taos Ski Valley' limit 1
loadtime:1.3235521316528 / seconds
Query Executed:select id FROM `nm` where city='Taos Ski Valley' && SIC_code='7011'DB:business_master_new
loadtime:1.324627161026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tatum' limit 1
loadtime:1.3246819972992 / seconds
Query Executed:select id FROM `nm` where city='Tatum' && SIC_code='7011'DB:business_master_new
loadtime:1.325492143631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tererro' limit 1
loadtime:1.3255541324615 / seconds
Query Executed:select id FROM `nm` where city='Tererro' && SIC_code='7011'DB:business_master_new
loadtime:1.3258850574493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tesuque' limit 1
loadtime:1.3259320259094 / seconds
Query Executed:select id FROM `nm` where city='Tesuque' && SIC_code='7011'DB:business_master_new
loadtime:1.3266940116882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Texico' limit 1
loadtime:1.3267500400543 / seconds
Query Executed:select id FROM `nm` where city='Texico' && SIC_code='7011'DB:business_master_new
loadtime:1.3276159763336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thoreau' limit 1
loadtime:1.3276720046997 / seconds
Query Executed:select id FROM `nm` where city='Thoreau' && SIC_code='7011'DB:business_master_new
loadtime:1.328586101532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tierra Amarilla' limit 1
loadtime:1.3286311626434 / seconds
Query Executed:select id FROM `nm` where city='Tierra Amarilla' && SIC_code='7011'DB:business_master_new
loadtime:1.3295221328735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tijeras' limit 1
loadtime:1.3295731544495 / seconds
Query Executed:select id FROM `nm` where city='Tijeras' && SIC_code='7011'DB:business_master_new
loadtime:1.3305530548096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timberon' limit 1
loadtime:1.3306021690369 / seconds
Query Executed:select id FROM `nm` where city='Timberon' && SIC_code='7011'DB:business_master_new
loadtime:1.3323690891266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tinnie' limit 1
loadtime:1.3324580192566 / seconds
Query Executed:select id FROM `nm` where city='Tinnie' && SIC_code='7011'DB:business_master_new
loadtime:1.3328430652618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tohatchi' limit 1
loadtime:1.3329060077667 / seconds
Query Executed:select id FROM `nm` where city='Tohatchi' && SIC_code='7011'DB:business_master_new
loadtime:1.3336541652679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tome' limit 1
loadtime:1.3337111473083 / seconds
Query Executed:select id FROM `nm` where city='Tome' && SIC_code='7011'DB:business_master_new
loadtime:1.3342940807343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Torreon' limit 1
loadtime:1.3343260288239 / seconds
Query Executed:select id FROM `nm` where city='Torreon' && SIC_code='7011'DB:business_master_new
loadtime:1.3347251415253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trampas' limit 1
loadtime:1.3347780704498 / seconds
Query Executed:select id FROM `nm` where city='Trampas' && SIC_code='7011'DB:business_master_new
loadtime:1.3350729942322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trementina' limit 1
loadtime:1.3351211547852 / seconds
Query Executed:select id FROM `nm` where city='Trementina' && SIC_code='7011'DB:business_master_new
loadtime:1.3354420661926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tres Piedras' limit 1
loadtime:1.3354890346527 / seconds
Query Executed:select id FROM `nm` where city='Tres Piedras' && SIC_code='7011'DB:business_master_new
loadtime:1.3364961147308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truchas' limit 1
loadtime:1.3365511894226 / seconds
Query Executed:select id FROM `nm` where city='Truchas' && SIC_code='7011'DB:business_master_new
loadtime:1.337681055069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truth Or Cnsqncs' limit 1
loadtime:1.3377320766449 / seconds
Query Executed:select id FROM `nm` where city='Truth Or Cnsqncs' && SIC_code='7011'DB:business_master_new
loadtime:1.338445186615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truth Or Consequences' limit 1
loadtime:1.3384912014008 / seconds
Query Executed:select id FROM `nm` where city='Truth Or Consequences' && SIC_code='7011'DB:business_master_new
loadtime:1.3397791385651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tucumcari' limit 1
loadtime:1.3398561477661 / seconds
Query Executed:select id FROM `nm` where city='Tucumcari' && SIC_code='7011'DB:business_master_new
loadtime:1.3413441181183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tularosa' limit 1
loadtime:1.3414402008057 / seconds
Query Executed:select id FROM `nm` where city='Tularosa' && SIC_code='7011'DB:business_master_new
loadtime:1.3423910140991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyrone' limit 1
loadtime:1.3424551486969 / seconds
Query Executed:select id FROM `nm` where city='Tyrone' && SIC_code='7011'DB:business_master_new
loadtime:1.3431901931763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ute Park' limit 1
loadtime:1.3432261943817 / seconds
Query Executed:select id FROM `nm` where city='Ute Park' && SIC_code='7011'DB:business_master_new
loadtime:1.3435671329498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vadito' limit 1
loadtime:1.3436241149902 / seconds
Query Executed:select id FROM `nm` where city='Vadito' && SIC_code='7011'DB:business_master_new
loadtime:1.3444499969482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vado' limit 1
loadtime:1.3445110321045 / seconds
Query Executed:select id FROM `nm` where city='Vado' && SIC_code='7011'DB:business_master_new
loadtime:1.345290184021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valdez' limit 1
loadtime:1.3453211784363 / seconds
Query Executed:select id FROM `nm` where city='Valdez' && SIC_code='7011'DB:business_master_new
loadtime:1.3462209701538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vallecitos' limit 1
loadtime:1.3462691307068 / seconds
Query Executed:select id FROM `nm` where city='Vallecitos' && SIC_code='7011'DB:business_master_new
loadtime:1.3465709686279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valmora' limit 1
loadtime:1.3466022014618 / seconds
Query Executed:select id FROM `nm` where city='Valmora' && SIC_code='7011'DB:business_master_new
loadtime:1.3469021320343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vanderwagen' limit 1
loadtime:1.3473801612854 / seconds
Query Executed:select id FROM `nm` where city='Vanderwagen' && SIC_code='7011'DB:business_master_new
loadtime:1.3481640815735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vaughn' limit 1
loadtime:1.3482010364532 / seconds
Query Executed:select id FROM `nm` where city='Vaughn' && SIC_code='7011'DB:business_master_new
loadtime:1.3490760326385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Veguita' limit 1
loadtime:1.3491489887238 / seconds
Query Executed:select id FROM `nm` where city='Veguita' && SIC_code='7011'DB:business_master_new
loadtime:1.3498430252075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Velarde' limit 1
loadtime:1.3499000072479 / seconds
Query Executed:select id FROM `nm` where city='Velarde' && SIC_code='7011'DB:business_master_new
loadtime:1.3506770133972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villanueva' limit 1
loadtime:1.3507170677185 / seconds
Query Executed:select id FROM `nm` where city='Villanueva' && SIC_code='7011'DB:business_master_new
loadtime:1.3510360717773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wagon Mound' limit 1
loadtime:1.3510751724243 / seconds
Query Executed:select id FROM `nm` where city='Wagon Mound' && SIC_code='7011'DB:business_master_new
loadtime:1.351811170578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterflow' limit 1
loadtime:1.3518691062927 / seconds
Query Executed:select id FROM `nm` where city='Waterflow' && SIC_code='7011'DB:business_master_new
loadtime:1.3526110649109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watrous' limit 1
loadtime:1.3526539802551 / seconds
Query Executed:select id FROM `nm` where city='Watrous' && SIC_code='7011'DB:business_master_new
loadtime:1.3533849716187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weed' limit 1
loadtime:1.353422164917 / seconds
Query Executed:select id FROM `nm` where city='Weed' && SIC_code='7011'DB:business_master_new
loadtime:1.3542191982269 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Sands' limit 1
loadtime:1.3542830944061 / seconds
Query Executed:select id FROM `nm` where city='White Sands' && SIC_code='7011'DB:business_master_new
loadtime:1.3550159931183 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Sands Missile Range' limit 1
loadtime:1.3550531864166 / seconds
Query Executed:select id FROM `nm` where city='White Sands Missile Range' && SIC_code='7011'DB:business_master_new
loadtime:1.3558399677277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whites City' limit 1
loadtime:1.355907201767 / seconds
Query Executed:select id FROM `nm` where city='Whites City' && SIC_code='7011'DB:business_master_new
loadtime:1.3566710948944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willard' limit 1
loadtime:1.3567152023315 / seconds
Query Executed:select id FROM `nm` where city='Willard' && SIC_code='7011'DB:business_master_new
loadtime:1.3573951721191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:1.3574559688568 / seconds
Query Executed:select id FROM `nm` where city='Williamsburg' && SIC_code='7011'DB:business_master_new
loadtime:1.3582451343536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winston' limit 1
loadtime:1.358304977417 / seconds
Query Executed:select id FROM `nm` where city='Winston' && SIC_code='7011'DB:business_master_new
loadtime:1.3590421676636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yatahey' limit 1
loadtime:1.3590910434723 / seconds
Query Executed:select id FROM `nm` where city='Yatahey' && SIC_code='7011'DB:business_master_new
loadtime:1.3598589897156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yeso' limit 1
loadtime:1.3598880767822 / seconds
Query Executed:select id FROM `nm` where city='Yeso' && SIC_code='7011'DB:business_master_new
loadtime:1.3602201938629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Youngsville' limit 1
loadtime:1.3602571487427 / seconds
Query Executed:select id FROM `nm` where city='Youngsville' && SIC_code='7011'DB:business_master_new
loadtime:1.3605341911316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zuni' limit 1
loadtime:1.3605661392212 / seconds
Query Executed:select id FROM `nm` where city='Zuni' && SIC_code='7011'DB:business_master_new
loadtime:1.3613991737366 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.3614950180054 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.3616971969604 / seconds
Operation template executed (chunk cache operation)
loadtime:1.3617901802063 / seconds
template override:Default
loadtime:1.3618111610413 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:1.3626010417938 / seconds
Template Constructed, Array Rows:49
loadtime:1.3628690242767 / seconds
TOTAL EXECUTION TIME: 1.36266
loadtime:1.3629679679871 / 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] => hotels-and-motels [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:1.3629729747772
TOTAL KEY ARRAYS: 69