Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:4.9114227294922E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00046205520629883 / seconds
host not found setting manual db connection
loadtime:0.0009150505065918 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0011451244354248 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0012691020965576 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0013141632080078 / seconds
zipcode:
loadtime:0.001331090927124 / seconds
Query Executed:select * from search_referrer where page_hash='4a7f46bbb3634a353a1b42838523f542' limit 10 DB:ezrox_toadli
loadtime:0.0015091896057129 / seconds
Operation header executed (non global)
loadtime:0.0015261173248291 / seconds
Operation leaderboard executed (non global)
loadtime:0.0015561580657959 / seconds
Operation square executed (non global)
loadtime:0.0015711784362793 / seconds
Operation square_bottom executed (non global)
loadtime:0.0015840530395508 / seconds
Operation smallsquare executed (non global)
loadtime:0.0015950202941895 / seconds
Operation headeradright executed (non global)
loadtime:0.0016071796417236 / seconds
Operation google_analytics executed (non global)
loadtime:0.0016181468963623 / seconds
Operation topstories executed (non global)
loadtime:0.001629114151001 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0016410350799561 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0016510486602783 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018930435180664 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0020391941070557 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0020720958709717 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.002129077911377 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.002161979675293 / seconds
Template key: archive_menu pushed
loadtime:0.0021669864654541 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0021731853485107 / seconds
Template key: get_gravatar pushed
loadtime:0.0021770000457764 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0021800994873047 / seconds
*10)-10)+1 | start:0
loadtime:0.002202033996582 / seconds
Query loaded from cache:select * from categories where cat_URLid='veterinary-services-for-animal-specialties'
loadtime:0.0022361278533936 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-mexico'
loadtime:0.0022602081298828 / seconds
DB connected to localhost business_master_new
loadtime:0.0025219917297363 / seconds
Query Executed:select * from `nm_catmap` where sic='0742' order by city ascDB:business_master_new
loadtime:0.11776208877563 / seconds
Query stored in cache : _QUERY_www.toadli.com44a0fe9d1c7f66c4e20f721559765ab9
loadtime:0.11837720870972 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-mexico'
loadtime:0.118408203125 / seconds
Query Executed:select sum(totalcount) as totalsum from `nm_catmap` where sic='0742'DB:business_master_new
loadtime:0.12205910682678 / seconds
Query stored in cache : _QUERY_www.toadli.com2cd813790bf230f75cc9028e0f96581c
loadtime:0.12215614318848 / seconds
369 / 11
loadtime:0.12224221229553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abiquiu' limit 1
loadtime:0.12235116958618 / seconds
Query Executed:select id FROM `nm` where city='Abiquiu' && SIC_code='0742'DB:business_master_new
loadtime:0.12491011619568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alameda' limit 1
loadtime:0.12504100799561 / seconds
Query Executed:select id FROM `nm` where city='Alameda' && SIC_code='0742'DB:business_master_new
loadtime:0.12710213661194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alamogordo' limit 1
loadtime:0.12716102600098 / seconds
Query Executed:select id FROM `nm` where city='Alamogordo' && SIC_code='0742'DB:business_master_new
loadtime:0.29157018661499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albuquerque' limit 1
loadtime:0.29163503646851 / seconds
Query Executed:select id FROM `nm` where city='Albuquerque' && SIC_code='0742'DB:business_master_new
loadtime:0.29439616203308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alcalde' limit 1
loadtime:0.2944860458374 / seconds
Query Executed:select id FROM `nm` where city='Alcalde' && SIC_code='0742'DB:business_master_new
loadtime:0.29493498802185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Algodones' limit 1
loadtime:0.29497718811035 / seconds
Query Executed:select id FROM `nm` where city='Algodones' && SIC_code='0742'DB:business_master_new
loadtime:0.29548311233521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alto' limit 1
loadtime:0.29552698135376 / seconds
Query Executed:select id FROM `nm` where city='Alto' && SIC_code='0742'DB:business_master_new
loadtime:0.29605197906494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amalia' limit 1
loadtime:0.29610013961792 / seconds
Query Executed:select id FROM `nm` where city='Amalia' && SIC_code='0742'DB:business_master_new
loadtime:0.29859614372253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amistad' limit 1
loadtime:0.29862999916077 / seconds
Query Executed:select id FROM `nm` where city='Amistad' && SIC_code='0742'DB:business_master_new
loadtime:0.30284214019775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Angel Fire' limit 1
loadtime:0.30288815498352 / seconds
Query Executed:select id FROM `nm` where city='Angel Fire' && SIC_code='0742'DB:business_master_new
loadtime:0.30352306365967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Animas' limit 1
loadtime:0.3035740852356 / seconds
Query Executed:select id FROM `nm` where city='Animas' && SIC_code='0742'DB:business_master_new
loadtime:0.30403518676758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anthony' limit 1
loadtime:0.30406403541565 / seconds
Query Executed:select id FROM `nm` where city='Anthony' && SIC_code='0742'DB:business_master_new
loadtime:0.30457615852356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anton Chico' limit 1
loadtime:0.30462503433228 / seconds
Query Executed:select id FROM `nm` where city='Anton Chico' && SIC_code='0742'DB:business_master_new
loadtime:0.31757020950317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aragon' limit 1
loadtime:0.31760501861572 / seconds
Query Executed:select id FROM `nm` where city='Aragon' && SIC_code='0742'DB:business_master_new
loadtime:0.32075715065002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arenas Valley' limit 1
loadtime:0.32084107398987 / seconds
Query Executed:select id FROM `nm` where city='Arenas Valley' && SIC_code='0742'DB:business_master_new
loadtime:0.32204008102417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arrey' limit 1
loadtime:0.32208299636841 / seconds
Query Executed:select id FROM `nm` where city='Arrey' && SIC_code='0742'DB:business_master_new
loadtime:0.33000802993774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arroyo Hondo' limit 1
loadtime:0.33005619049072 / seconds
Query Executed:select id FROM `nm` where city='Arroyo Hondo' && SIC_code='0742'DB:business_master_new
loadtime:0.33050203323364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arroyo Seco' limit 1
loadtime:0.33054113388062 / seconds
Query Executed:select id FROM `nm` where city='Arroyo Seco' && SIC_code='0742'DB:business_master_new
loadtime:0.33104109764099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Artesia' limit 1
loadtime:0.33108806610107 / seconds
Query Executed:select id FROM `nm` where city='Artesia' && SIC_code='0742'DB:business_master_new
loadtime:0.33185219764709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aztec' limit 1
loadtime:0.33191013336182 / seconds
Query Executed:select id FROM `nm` where city='Aztec' && SIC_code='0742'DB:business_master_new
loadtime:0.33265900611877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bard' limit 1
loadtime:0.33270215988159 / seconds
Query Executed:select id FROM `nm` where city='Bard' && SIC_code='0742'DB:business_master_new
loadtime:0.33465909957886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayard' limit 1
loadtime:0.33470821380615 / seconds
Query Executed:select id FROM `nm` where city='Bayard' && SIC_code='0742'DB:business_master_new
loadtime:0.33551406860352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belen' limit 1
loadtime:0.33555817604065 / seconds
Query Executed:select id FROM `nm` where city='Belen' && SIC_code='0742'DB:business_master_new
loadtime:0.33668804168701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bell Ranch' limit 1
loadtime:0.3367600440979 / seconds
Query Executed:select id FROM `nm` where city='Bell Ranch' && SIC_code='0742'DB:business_master_new
loadtime:0.33701205253601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bent' limit 1
loadtime:0.33703899383545 / seconds
Query Executed:select id FROM `nm` where city='Bent' && SIC_code='0742'DB:business_master_new
loadtime:0.33946919441223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berino' limit 1
loadtime:0.339515209198 / seconds
Query Executed:select id FROM `nm` where city='Berino' && SIC_code='0742'DB:business_master_new
loadtime:0.34396505355835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bernalillo' limit 1
loadtime:0.34401512145996 / seconds
Query Executed:select id FROM `nm` where city='Bernalillo' && SIC_code='0742'DB:business_master_new
loadtime:0.34471607208252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bingham' limit 1
loadtime:0.34476017951965 / seconds
Query Executed:select id FROM `nm` where city='Bingham' && SIC_code='0742'DB:business_master_new
loadtime:0.34547114372253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanco' limit 1
loadtime:0.34552001953125 / seconds
Query Executed:select id FROM `nm` where city='Blanco' && SIC_code='0742'DB:business_master_new
loadtime:0.35401201248169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield' limit 1
loadtime:0.35404706001282 / seconds
Query Executed:select id FROM `nm` where city='Bloomfield' && SIC_code='0742'DB:business_master_new
loadtime:0.35473012924194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluewater' limit 1
loadtime:0.35478711128235 / seconds
Query Executed:select id FROM `nm` where city='Bluewater' && SIC_code='0742'DB:business_master_new
loadtime:0.36305499076843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bosque' limit 1
loadtime:0.36309719085693 / seconds
Query Executed:select id FROM `nm` where city='Bosque' && SIC_code='0742'DB:business_master_new
loadtime:0.37063598632812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bosque Farms' limit 1
loadtime:0.37068510055542 / seconds
Query Executed:select id FROM `nm` where city='Bosque Farms' && SIC_code='0742'DB:business_master_new
loadtime:0.37125706672668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brimhall' limit 1
loadtime:0.37130212783813 / seconds
Query Executed:select id FROM `nm` where city='Brimhall' && SIC_code='0742'DB:business_master_new
loadtime:0.37398409843445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadview' limit 1
loadtime:0.37403321266174 / seconds
Query Executed:select id FROM `nm` where city='Broadview' && SIC_code='0742'DB:business_master_new
loadtime:0.38318800926208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckhorn' limit 1
loadtime:0.38330221176147 / seconds
Query Executed:select id FROM `nm` where city='Buckhorn' && SIC_code='0742'DB:business_master_new
loadtime:0.38877701759338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buena Vista' limit 1
loadtime:0.3888111114502 / seconds
Query Executed:select id FROM `nm` where city='Buena Vista' && SIC_code='0742'DB:business_master_new
loadtime:0.39294815063477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caballo' limit 1
loadtime:0.39299607276917 / seconds
Query Executed:select id FROM `nm` where city='Caballo' && SIC_code='0742'DB:business_master_new
loadtime:0.39386510848999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canjilon' limit 1
loadtime:0.39390015602112 / seconds
Query Executed:select id FROM `nm` where city='Canjilon' && SIC_code='0742'DB:business_master_new
loadtime:0.40058708190918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cannon Afb' limit 1
loadtime:0.40063500404358 / seconds
Query Executed:select id FROM `nm` where city='Cannon Afb' && SIC_code='0742'DB:business_master_new
loadtime:0.40137004852295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canoncito' limit 1
loadtime:0.40146398544312 / seconds
Query Executed:select id FROM `nm` where city='Canoncito' && SIC_code='0742'DB:business_master_new
loadtime:0.40363001823425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canones' limit 1
loadtime:0.40367603302002 / seconds
Query Executed:select id FROM `nm` where city='Canones' && SIC_code='0742'DB:business_master_new
loadtime:0.40865206718445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capitan' limit 1
loadtime:0.40876412391663 / seconds
Query Executed:select id FROM `nm` where city='Capitan' && SIC_code='0742'DB:business_master_new
loadtime:0.41025114059448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caprock' limit 1
loadtime:0.41039800643921 / seconds
Query Executed:select id FROM `nm` where city='Caprock' && SIC_code='0742'DB:business_master_new
loadtime:0.41303420066833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capulin' limit 1
loadtime:0.41308403015137 / seconds
Query Executed:select id FROM `nm` where city='Capulin' && SIC_code='0742'DB:business_master_new
loadtime:0.41786503791809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlsbad' limit 1
loadtime:0.41790008544922 / seconds
Query Executed:select id FROM `nm` where city='Carlsbad' && SIC_code='0742'DB:business_master_new
loadtime:0.42048621177673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrizozo' limit 1
loadtime:0.42054319381714 / seconds
Query Executed:select id FROM `nm` where city='Carrizozo' && SIC_code='0742'DB:business_master_new
loadtime:0.42110514640808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson' limit 1
loadtime:0.421147108078 / seconds
Query Executed:select id FROM `nm` where city='Carson' && SIC_code='0742'DB:business_master_new
loadtime:0.42637014389038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casa Blanca' limit 1
loadtime:0.42642021179199 / seconds
Query Executed:select id FROM `nm` where city='Casa Blanca' && SIC_code='0742'DB:business_master_new
loadtime:0.42687320709229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Causey' limit 1
loadtime:0.42690420150757 / seconds
Query Executed:select id FROM `nm` where city='Causey' && SIC_code='0742'DB:business_master_new
loadtime:0.4315869808197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cebolla' limit 1
loadtime:0.43168807029724 / seconds
Query Executed:select id FROM `nm` where city='Cebolla' && SIC_code='0742'DB:business_master_new
loadtime:0.43403315544128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Crest' limit 1
loadtime:0.43408107757568 / seconds
Query Executed:select id FROM `nm` where city='Cedar Crest' && SIC_code='0742'DB:business_master_new
loadtime:0.43460512161255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central' limit 1
loadtime:0.43465900421143 / seconds
Query Executed:select id FROM `nm` where city='Central' && SIC_code='0742'DB:business_master_new
loadtime:0.43887114524841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cerrillos' limit 1
loadtime:0.4389181137085 / seconds
Query Executed:select id FROM `nm` where city='Cerrillos' && SIC_code='0742'DB:business_master_new
loadtime:0.43940711021423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cerro' limit 1
loadtime:0.43945002555847 / seconds
Query Executed:select id FROM `nm` where city='Cerro' && SIC_code='0742'DB:business_master_new
loadtime:0.44363713264465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chacon' limit 1
loadtime:0.44368410110474 / seconds
Query Executed:select id FROM `nm` where city='Chacon' && SIC_code='0742'DB:business_master_new
loadtime:0.44673109054565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chama' limit 1
loadtime:0.44676613807678 / seconds
Query Executed:select id FROM `nm` where city='Chama' && SIC_code='0742'DB:business_master_new
loadtime:0.44732999801636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chamberino' limit 1
loadtime:0.44738698005676 / seconds
Query Executed:select id FROM `nm` where city='Chamberino' && SIC_code='0742'DB:business_master_new
loadtime:0.45189714431763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chamisal' limit 1
loadtime:0.45193314552307 / seconds
Query Executed:select id FROM `nm` where city='Chamisal' && SIC_code='0742'DB:business_master_new
loadtime:0.4523811340332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chaparral' limit 1
loadtime:0.45243000984192 / seconds
Query Executed:select id FROM `nm` where city='Chaparral' && SIC_code='0742'DB:business_master_new
loadtime:0.45290398597717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chimayo' limit 1
loadtime:0.45295214653015 / seconds
Query Executed:select id FROM `nm` where city='Chimayo' && SIC_code='0742'DB:business_master_new
loadtime:0.45342302322388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Church Rock' limit 1
loadtime:0.453458070755 / seconds
Query Executed:select id FROM `nm` where city='Church Rock' && SIC_code='0742'DB:business_master_new
loadtime:0.46065998077393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cimarron' limit 1
loadtime:0.4608211517334 / seconds
Query Executed:select id FROM `nm` where city='Cimarron' && SIC_code='0742'DB:business_master_new
loadtime:0.46145915985107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claunch' limit 1
loadtime:0.46155309677124 / seconds
Query Executed:select id FROM `nm` where city='Claunch' && SIC_code='0742'DB:business_master_new
loadtime:0.46383118629456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clayton' limit 1
loadtime:0.46388006210327 / seconds
Query Executed:select id FROM `nm` where city='Clayton' && SIC_code='0742'DB:business_master_new
loadtime:0.46497011184692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.46508717536926 / seconds
Query Executed:select id FROM `nm` where city='Cleveland' && SIC_code='0742'DB:business_master_new
loadtime:0.47272920608521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cliff' limit 1
loadtime:0.47283506393433 / seconds
Query Executed:select id FROM `nm` where city='Cliff' && SIC_code='0742'DB:business_master_new
loadtime:0.47362112998962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clines Corners' limit 1
loadtime:0.47365498542786 / seconds
Query Executed:select id FROM `nm` where city='Clines Corners' && SIC_code='0742'DB:business_master_new
loadtime:0.47728705406189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cloudcroft' limit 1
loadtime:0.47733402252197 / seconds
Query Executed:select id FROM `nm` where city='Cloudcroft' && SIC_code='0742'DB:business_master_new
loadtime:0.47788906097412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clovis' limit 1
loadtime:0.4779360294342 / seconds
Query Executed:select id FROM `nm` where city='Clovis' && SIC_code='0742'DB:business_master_new
loadtime:0.48050117492676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cochiti Lake' limit 1
loadtime:0.48054718971252 / seconds
Query Executed:select id FROM `nm` where city='Cochiti Lake' && SIC_code='0742'DB:business_master_new
loadtime:0.48514699935913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cochiti Pueblo' limit 1
loadtime:0.48519611358643 / seconds
Query Executed:select id FROM `nm` where city='Cochiti Pueblo' && SIC_code='0742'DB:business_master_new
loadtime:0.48996710777283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:0.49002718925476 / seconds
Query Executed:select id FROM `nm` where city='Columbus' && SIC_code='0742'DB:business_master_new
loadtime:0.49109816551208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conchas Dam' limit 1
loadtime:0.49117517471313 / seconds
Query Executed:select id FROM `nm` where city='Conchas Dam' && SIC_code='0742'DB:business_master_new
loadtime:0.49239015579224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Continental Div' limit 1
loadtime:0.49248504638672 / seconds
Query Executed:select id FROM `nm` where city='Continental Div' && SIC_code='0742'DB:business_master_new
loadtime:0.49284315109253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Continental Divide' limit 1
loadtime:0.49292612075806 / seconds
Query Executed:select id FROM `nm` where city='Continental Divide' && SIC_code='0742'DB:business_master_new
loadtime:0.49952912330627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cordova' limit 1
loadtime:0.4995641708374 / seconds
Query Executed:select id FROM `nm` where city='Cordova' && SIC_code='0742'DB:business_master_new
loadtime:0.50380802154541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corona' limit 1
loadtime:0.50393414497375 / seconds
Query Executed:select id FROM `nm` where city='Corona' && SIC_code='0742'DB:business_master_new
loadtime:0.50481915473938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corrales' limit 1
loadtime:0.50493001937866 / seconds
Query Executed:select id FROM `nm` where city='Corrales' && SIC_code='0742'DB:business_master_new
loadtime:0.5065450668335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Costilla' limit 1
loadtime:0.50666999816895 / seconds
Query Executed:select id FROM `nm` where city='Costilla' && SIC_code='0742'DB:business_master_new
loadtime:0.51730418205261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Counselor' limit 1
loadtime:0.5173511505127 / seconds
Query Executed:select id FROM `nm` where city='Counselor' && SIC_code='0742'DB:business_master_new
loadtime:0.52119207382202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coyote' limit 1
loadtime:0.52122020721436 / seconds
Query Executed:select id FROM `nm` where city='Coyote' && SIC_code='0742'DB:business_master_new
loadtime:0.5275092124939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crossroads' limit 1
loadtime:0.52754712104797 / seconds
Query Executed:select id FROM `nm` where city='Crossroads' && SIC_code='0742'DB:business_master_new
loadtime:0.53004002571106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crownpoint' limit 1
loadtime:0.53006505966187 / seconds
Query Executed:select id FROM `nm` where city='Crownpoint' && SIC_code='0742'DB:business_master_new
loadtime:0.53051614761353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuba' limit 1
loadtime:0.53055214881897 / seconds
Query Executed:select id FROM `nm` where city='Cuba' && SIC_code='0742'DB:business_master_new
loadtime:0.53108215332031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cubero' limit 1
loadtime:0.53110599517822 / seconds
Query Executed:select id FROM `nm` where city='Cubero' && SIC_code='0742'DB:business_master_new
loadtime:0.53667712211609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuchillo' limit 1
loadtime:0.53673505783081 / seconds
Query Executed:select id FROM `nm` where city='Cuchillo' && SIC_code='0742'DB:business_master_new
loadtime:0.53725600242615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuervo' limit 1
loadtime:0.53729915618896 / seconds
Query Executed:select id FROM `nm` where city='Cuervo' && SIC_code='0742'DB:business_master_new
loadtime:0.53934717178345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Datil' limit 1
loadtime:0.539381980896 / seconds
Query Executed:select id FROM `nm` where city='Datil' && SIC_code='0742'DB:business_master_new
loadtime:0.53984308242798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deming' limit 1
loadtime:0.5398850440979 / seconds
Query Executed:select id FROM `nm` where city='Deming' && SIC_code='0742'DB:business_master_new
loadtime:0.54087209701538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derry' limit 1
loadtime:0.54091620445251 / seconds
Query Executed:select id FROM `nm` where city='Derry' && SIC_code='0742'DB:business_master_new
loadtime:0.5424861907959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Des Moines' limit 1
loadtime:0.54253506660461 / seconds
Query Executed:select id FROM `nm` where city='Des Moines' && SIC_code='0742'DB:business_master_new
loadtime:0.54301309585571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dexter' limit 1
loadtime:0.54304718971252 / seconds
Query Executed:select id FROM `nm` where city='Dexter' && SIC_code='0742'DB:business_master_new
loadtime:0.54356408119202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dixon' limit 1
loadtime:0.54362106323242 / seconds
Query Executed:select id FROM `nm` where city='Dixon' && SIC_code='0742'DB:business_master_new
loadtime:0.54406404495239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dona Ana' limit 1
loadtime:0.54409909248352 / seconds
Query Executed:select id FROM `nm` where city='Dona Ana' && SIC_code='0742'DB:business_master_new
loadtime:0.54452800750732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dora' limit 1
loadtime:0.5445761680603 / seconds
Query Executed:select id FROM `nm` where city='Dora' && SIC_code='0742'DB:business_master_new
loadtime:0.5450291633606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dulce' limit 1
loadtime:0.54507803916931 / seconds
Query Executed:select id FROM `nm` where city='Dulce' && SIC_code='0742'DB:business_master_new
loadtime:0.54556107521057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duran' limit 1
loadtime:0.54559803009033 / seconds
Query Executed:select id FROM `nm` where city='Duran' && SIC_code='0742'DB:business_master_new
loadtime:0.54743218421936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Nest' limit 1
loadtime:0.54748010635376 / seconds
Query Executed:select id FROM `nm` where city='Eagle Nest' && SIC_code='0742'DB:business_master_new
loadtime:0.54799699783325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewood' limit 1
loadtime:0.54803204536438 / seconds
Query Executed:select id FROM `nm` where city='Edgewood' && SIC_code='0742'DB:business_master_new
loadtime:0.54869604110718 / seconds
Query loaded from cache:select * from geodata_geocity where city='El Prado' limit 1
loadtime:0.54877018928528 / seconds
Query Executed:select id FROM `nm` where city='El Prado' && SIC_code='0742'DB:business_master_new
loadtime:0.54930114746094 / seconds
Query loaded from cache:select * from geodata_geocity where city='El Rito' limit 1
loadtime:0.54934406280518 / seconds
Query Executed:select id FROM `nm` where city='El Rito' && SIC_code='0742'DB:business_master_new
loadtime:0.54978108406067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elephant Butte' limit 1
loadtime:0.54982304573059 / seconds
Query Executed:select id FROM `nm` where city='Elephant Butte' && SIC_code='0742'DB:business_master_new
loadtime:0.55028820037842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elida' limit 1
loadtime:0.55033206939697 / seconds
Query Executed:select id FROM `nm` where city='Elida' && SIC_code='0742'DB:business_master_new
loadtime:0.55077505111694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Embudo' limit 1
loadtime:0.55080318450928 / seconds
Query Executed:select id FROM `nm` where city='Embudo' && SIC_code='0742'DB:business_master_new
loadtime:0.55121898651123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Encino' limit 1
loadtime:0.55126810073853 / seconds
Query Executed:select id FROM `nm` where city='Encino' && SIC_code='0742'DB:business_master_new
loadtime:0.56229519844055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Espanola' limit 1
loadtime:0.5623300075531 / seconds
Query Executed:select id FROM `nm` where city='Espanola' && SIC_code='0742'DB:business_master_new
loadtime:0.56491112709045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estancia' limit 1
loadtime:0.56497001647949 / seconds
Query Executed:select id FROM `nm` where city='Estancia' && SIC_code='0742'DB:business_master_new
loadtime:0.56547808647156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eunice' limit 1
loadtime:0.56551504135132 / seconds
Query Executed:select id FROM `nm` where city='Eunice' && SIC_code='0742'DB:business_master_new
loadtime:0.56606006622314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairacres' limit 1
loadtime:0.56611609458923 / seconds
Query Executed:select id FROM `nm` where city='Fairacres' && SIC_code='0742'DB:business_master_new
loadtime:0.56657719612122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:0.56661319732666 / seconds
Query Executed:select id FROM `nm` where city='Fairview' && SIC_code='0742'DB:business_master_new
loadtime:0.56773400306702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.56778311729431 / seconds
Query Executed:select id FROM `nm` where city='Farmington' && SIC_code='0742'DB:business_master_new
loadtime:0.57188606262207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faywood' limit 1
loadtime:0.57194709777832 / seconds
Query Executed:select id FROM `nm` where city='Faywood' && SIC_code='0742'DB:business_master_new
loadtime:0.57595920562744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fence Lake' limit 1
loadtime:0.57599520683289 / seconds
Query Executed:select id FROM `nm` where city='Fence Lake' && SIC_code='0742'DB:business_master_new
loadtime:0.58043813705444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flora Vista' limit 1
loadtime:0.58048701286316 / seconds
Query Executed:select id FROM `nm` where city='Flora Vista' && SIC_code='0742'DB:business_master_new
loadtime:0.58132600784302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Floyd' limit 1
loadtime:0.58138704299927 / seconds
Query Executed:select id FROM `nm` where city='Floyd' && SIC_code='0742'DB:business_master_new
loadtime:0.58187317848206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flying H' limit 1
loadtime:0.58191418647766 / seconds
Query Executed:select id FROM `nm` where city='Flying H' && SIC_code='0742'DB:business_master_new
loadtime:0.58258414268494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Folsom' limit 1
loadtime:0.58266305923462 / seconds
Query Executed:select id FROM `nm` where city='Folsom' && SIC_code='0742'DB:business_master_new
loadtime:0.58338117599487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Bayard' limit 1
loadtime:0.58350610733032 / seconds
Query Executed:select id FROM `nm` where city='Fort Bayard' && SIC_code='0742'DB:business_master_new
loadtime:0.58748602867126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Stanton' limit 1
loadtime:0.58752202987671 / seconds
Query Executed:select id FROM `nm` where city='Fort Stanton' && SIC_code='0742'DB:business_master_new
loadtime:0.59189319610596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Sumner' limit 1
loadtime:0.59194207191467 / seconds
Query Executed:select id FROM `nm` where city='Fort Sumner' && SIC_code='0742'DB:business_master_new
loadtime:0.59283018112183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Wingate' limit 1
loadtime:0.59296107292175 / seconds
Query Executed:select id FROM `nm` where city='Fort Wingate' && SIC_code='0742'DB:business_master_new
loadtime:0.59396600723267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitland' limit 1
loadtime:0.59400010108948 / seconds
Query Executed:select id FROM `nm` where city='Fruitland' && SIC_code='0742'DB:business_master_new
loadtime:0.59501814842224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gallina' limit 1
loadtime:0.59515118598938 / seconds
Query Executed:select id FROM `nm` where city='Gallina' && SIC_code='0742'DB:business_master_new
loadtime:0.60421109199524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gallup' limit 1
loadtime:0.60428810119629 / seconds
Query Executed:select id FROM `nm` where city='Gallup' && SIC_code='0742'DB:business_master_new
loadtime:0.6099259853363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gamerco' limit 1
loadtime:0.61008214950562 / seconds
Query Executed:select id FROM `nm` where city='Gamerco' && SIC_code='0742'DB:business_master_new
loadtime:0.61101198196411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garfield' limit 1
loadtime:0.61110901832581 / seconds
Query Executed:select id FROM `nm` where city='Garfield' && SIC_code='0742'DB:business_master_new
loadtime:0.62043118476868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garita' limit 1
loadtime:0.6205141544342 / seconds
Query Executed:select id FROM `nm` where city='Garita' && SIC_code='0742'DB:business_master_new
loadtime:0.62152910232544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gila' limit 1
loadtime:0.6215991973877 / seconds
Query Executed:select id FROM `nm` where city='Gila' && SIC_code='0742'DB:business_master_new
loadtime:0.62263607978821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladstone' limit 1
loadtime:0.62268209457397 / seconds
Query Executed:select id FROM `nm` where city='Gladstone' && SIC_code='0742'DB:business_master_new
loadtime:0.62408208847046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glencoe' limit 1
loadtime:0.62413001060486 / seconds
Query Executed:select id FROM `nm` where city='Glencoe' && SIC_code='0742'DB:business_master_new
loadtime:0.63103914260864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:0.63107419013977 / seconds
Query Executed:select id FROM `nm` where city='Glenwood' && SIC_code='0742'DB:business_master_new
loadtime:0.63151502609253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glorieta' limit 1
loadtime:0.63156414031982 / seconds
Query Executed:select id FROM `nm` where city='Glorieta' && SIC_code='0742'DB:business_master_new
loadtime:0.63203501701355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grady' limit 1
loadtime:0.63207006454468 / seconds
Query Executed:select id FROM `nm` where city='Grady' && SIC_code='0742'DB:business_master_new
loadtime:0.64247798919678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grants' limit 1
loadtime:0.64252710342407 / seconds
Query Executed:select id FROM `nm` where city='Grants' && SIC_code='0742'DB:business_master_new
loadtime:0.64322805404663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grenville' limit 1
loadtime:0.64327216148376 / seconds
Query Executed:select id FROM `nm` where city='Grenville' && SIC_code='0742'DB:business_master_new
loadtime:0.64693808555603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guadalupita' limit 1
loadtime:0.64698910713196 / seconds
Query Executed:select id FROM `nm` where city='Guadalupita' && SIC_code='0742'DB:business_master_new
loadtime:0.6508150100708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hachita' limit 1
loadtime:0.65086197853088 / seconds
Query Executed:select id FROM `nm` where city='Hachita' && SIC_code='0742'DB:business_master_new
loadtime:0.65326499938965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hagerman' limit 1
loadtime:0.65330004692078 / seconds
Query Executed:select id FROM `nm` where city='Hagerman' && SIC_code='0742'DB:business_master_new
loadtime:0.65376019477844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.65380120277405 / seconds
Query Executed:select id FROM `nm` where city='Hanover' && SIC_code='0742'DB:business_master_new
loadtime:0.66122603416443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatch' limit 1
loadtime:0.66126108169556 / seconds
Query Executed:select id FROM `nm` where city='Hatch' && SIC_code='0742'DB:business_master_new
loadtime:0.66173601150513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hernandez' limit 1
loadtime:0.66177701950073 / seconds
Query Executed:select id FROM `nm` where city='Hernandez' && SIC_code='0742'DB:business_master_new
loadtime:0.66220903396606 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Rls Mtn Pk' limit 1
loadtime:0.66224408149719 / seconds
Query Executed:select id FROM `nm` where city='High Rls Mtn Pk' && SIC_code='0742'DB:business_master_new
loadtime:0.66327309608459 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Rolls Mountain Park' limit 1
loadtime:0.66332101821899 / seconds
Query Executed:select id FROM `nm` where city='High Rolls Mountain Park' && SIC_code='0742'DB:business_master_new
loadtime:0.66449618339539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:0.66461300849915 / seconds
Query Executed:select id FROM `nm` where city='Hillsboro' && SIC_code='0742'DB:business_master_new
loadtime:0.66541314125061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hobbs' limit 1
loadtime:0.66554498672485 / seconds
Query Executed:select id FROM `nm` where city='Hobbs' && SIC_code='0742'DB:business_master_new
loadtime:0.67034506797791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holloman Afb' limit 1
loadtime:0.67050409317017 / seconds
Query Executed:select id FROM `nm` where city='Holloman Afb' && SIC_code='0742'DB:business_master_new
loadtime:0.67142105102539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holloman Air Force Base' limit 1
loadtime:0.67145705223083 / seconds
Query Executed:select id FROM `nm` where city='Holloman Air Force Base' && SIC_code='0742'DB:business_master_new
loadtime:0.67228507995605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holman' limit 1
loadtime:0.67233419418335 / seconds
Query Executed:select id FROM `nm` where city='Holman' && SIC_code='0742'DB:business_master_new
loadtime:0.67953109741211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hondo' limit 1
loadtime:0.67956709861755 / seconds
Query Executed:select id FROM `nm` where city='Hondo' && SIC_code='0742'DB:business_master_new
loadtime:0.68003416061401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hope' limit 1
loadtime:0.68008303642273 / seconds
Query Executed:select id FROM `nm` where city='Hope' && SIC_code='0742'DB:business_master_new
loadtime:0.69140219688416 / seconds
Query loaded from cache:select * from geodata_geocity where city='House' limit 1
loadtime:0.6914381980896 / seconds
Query Executed:select id FROM `nm` where city='House' && SIC_code='0742'DB:business_master_new
loadtime:0.6918420791626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:0.6918830871582 / seconds
Query Executed:select id FROM `nm` where city='Hurley' && SIC_code='0742'DB:business_master_new
loadtime:0.69230914115906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isleta' limit 1
loadtime:0.69234418869019 / seconds
Query Executed:select id FROM `nm` where city='Isleta' && SIC_code='0742'DB:business_master_new
loadtime:0.69276213645935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jal' limit 1
loadtime:0.69280409812927 / seconds
Query Executed:select id FROM `nm` where city='Jal' && SIC_code='0742'DB:business_master_new
loadtime:0.69329619407654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:0.69334006309509 / seconds
Query Executed:select id FROM `nm` where city='Jamestown' && SIC_code='0742'DB:business_master_new
loadtime:0.6975200176239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jarales' limit 1
loadtime:0.69755506515503 / seconds
Query Executed:select id FROM `nm` where city='Jarales' && SIC_code='0742'DB:business_master_new
loadtime:0.70313715934753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jemez Pueblo' limit 1
loadtime:0.70318412780762 / seconds
Query Executed:select id FROM `nm` where city='Jemez Pueblo' && SIC_code='0742'DB:business_master_new
loadtime:0.70367002487183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jemez Springs' limit 1
loadtime:0.70372104644775 / seconds
Query Executed:select id FROM `nm` where city='Jemez Springs' && SIC_code='0742'DB:business_master_new
loadtime:0.70420098304749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenna' limit 1
loadtime:0.7042510509491 / seconds
Query Executed:select id FROM `nm` where city='Kenna' && SIC_code='0742'DB:business_master_new
loadtime:0.70538210868835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirtland' limit 1
loadtime:0.7054181098938 / seconds
Query Executed:select id FROM `nm` where city='Kirtland' && SIC_code='0742'DB:business_master_new
loadtime:0.7068030834198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirtland Afb' limit 1
loadtime:0.70685815811157 / seconds
Query Executed:select id FROM `nm` where city='Kirtland Afb' && SIC_code='0742'DB:business_master_new
loadtime:0.7079131603241 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Jara' limit 1
loadtime:0.70801019668579 / seconds
Query Executed:select id FROM `nm` where city='La Jara' && SIC_code='0742'DB:business_master_new
loadtime:0.70987820625305 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Joya' limit 1
loadtime:0.70992517471313 / seconds
Query Executed:select id FROM `nm` where city='La Joya' && SIC_code='0742'DB:business_master_new
loadtime:0.71206617355347 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Loma' limit 1
loadtime:0.71211504936218 / seconds
Query Executed:select id FROM `nm` where city='La Loma' && SIC_code='0742'DB:business_master_new
loadtime:0.71283221244812 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Luz' limit 1
loadtime:0.71286010742188 / seconds
Query Executed:select id FROM `nm` where city='La Luz' && SIC_code='0742'DB:business_master_new
loadtime:0.71334314346313 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Madera' limit 1
loadtime:0.71339511871338 / seconds
Query Executed:select id FROM `nm` where city='La Madera' && SIC_code='0742'DB:business_master_new
loadtime:0.71622705459595 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Mesa' limit 1
loadtime:0.71626210212708 / seconds
Query Executed:select id FROM `nm` where city='La Mesa' && SIC_code='0742'DB:business_master_new
loadtime:0.71689820289612 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Plata' limit 1
loadtime:0.71701002120972 / seconds
Query Executed:select id FROM `nm` where city='La Plata' && SIC_code='0742'DB:business_master_new
loadtime:0.71782302856445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laguna' limit 1
loadtime:0.71791815757751 / seconds
Query Executed:select id FROM `nm` where city='Laguna' && SIC_code='0742'DB:business_master_new
loadtime:0.71881604194641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lajoya' limit 1
loadtime:0.71885704994202 / seconds
Query Executed:select id FROM `nm` where city='Lajoya' && SIC_code='0742'DB:business_master_new
loadtime:0.71946811676025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Arthur' limit 1
loadtime:0.7195131778717 / seconds
Query Executed:select id FROM `nm` where city='Lake Arthur' && SIC_code='0742'DB:business_master_new
loadtime:0.72018718719482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakewood' limit 1
loadtime:0.72022199630737 / seconds
Query Executed:select id FROM `nm` where city='Lakewood' && SIC_code='0742'DB:business_master_new
loadtime:0.72627806663513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamy' limit 1
loadtime:0.72632503509521 / seconds
Query Executed:select id FROM `nm` where city='Lamy' && SIC_code='0742'DB:business_master_new
loadtime:0.72678399085999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Las Cruces' limit 1
loadtime:0.726811170578 / seconds
Query Executed:select id FROM `nm` where city='Las Cruces' && SIC_code='0742'DB:business_master_new
loadtime:0.73174715042114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Las Vegas' limit 1
loadtime:0.73181414604187 / seconds
Query Executed:select id FROM `nm` where city='Las Vegas' && SIC_code='0742'DB:business_master_new
loadtime:0.73352909088135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemitar' limit 1
loadtime:0.73365306854248 / seconds
Query Executed:select id FROM `nm` where city='Lemitar' && SIC_code='0742'DB:business_master_new
loadtime:0.734375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.73450899124146 / seconds
Query Executed:select id FROM `nm` where city='Lincoln' && SIC_code='0742'DB:business_master_new
loadtime:0.74353909492493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lindrith' limit 1
loadtime:0.74363112449646 / seconds
Query Executed:select id FROM `nm` where city='Lindrith' && SIC_code='0742'DB:business_master_new
loadtime:0.74480509757996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Llano' limit 1
loadtime:0.74493718147278 / seconds
Query Executed:select id FROM `nm` where city='Llano' && SIC_code='0742'DB:business_master_new
loadtime:0.74642419815063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loco Hills' limit 1
loadtime:0.74647402763367 / seconds
Query Executed:select id FROM `nm` where city='Loco Hills' && SIC_code='0742'DB:business_master_new
loadtime:0.7476270198822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Logan' limit 1
loadtime:0.74776101112366 / seconds
Query Executed:select id FROM `nm` where city='Logan' && SIC_code='0742'DB:business_master_new
loadtime:0.74914813041687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lordsburg' limit 1
loadtime:0.74928116798401 / seconds
Query Executed:select id FROM `nm` where city='Lordsburg' && SIC_code='0742'DB:business_master_new
loadtime:0.75080513954163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Los Alamos' limit 1
loadtime:0.75090003013611 / seconds
Query Executed:select id FROM `nm` where city='Los Alamos' && SIC_code='0742'DB:business_master_new
loadtime:0.75374603271484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Los Lunas' limit 1
loadtime:0.75380301475525 / seconds
Query Executed:select id FROM `nm` where city='Los Lunas' && SIC_code='0742'DB:business_master_new
loadtime:0.75718021392822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Los Ojos' limit 1
loadtime:0.75731110572815 / seconds
Query Executed:select id FROM `nm` where city='Los Ojos' && SIC_code='0742'DB:business_master_new
loadtime:0.75856614112854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loving' limit 1
loadtime:0.75869607925415 / seconds
Query Executed:select id FROM `nm` where city='Loving' && SIC_code='0742'DB:business_master_new
loadtime:0.75970602035522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovington' limit 1
loadtime:0.75986099243164 / seconds
Query Executed:select id FROM `nm` where city='Lovington' && SIC_code='0742'DB:business_master_new
loadtime:0.76178908348083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lumberton' limit 1
loadtime:0.76194214820862 / seconds
Query Executed:select id FROM `nm` where city='Lumberton' && SIC_code='0742'DB:business_master_new
loadtime:0.76277804374695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luna' limit 1
loadtime:0.76290512084961 / seconds
Query Executed:select id FROM `nm` where city='Luna' && SIC_code='0742'DB:business_master_new
loadtime:0.76990103721619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magdalena' limit 1
loadtime:0.76993703842163 / seconds
Query Executed:select id FROM `nm` where city='Magdalena' && SIC_code='0742'DB:business_master_new
loadtime:0.77040314674377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malaga' limit 1
loadtime:0.77045106887817 / seconds
Query Executed:select id FROM `nm` where city='Malaga' && SIC_code='0742'DB:business_master_new
loadtime:0.77292418479919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maljamar' limit 1
loadtime:0.77301907539368 / seconds
Query Executed:select id FROM `nm` where city='Maljamar' && SIC_code='0742'DB:business_master_new
loadtime:0.77426218986511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxwell' limit 1
loadtime:0.77439498901367 / seconds
Query Executed:select id FROM `nm` where city='Maxwell' && SIC_code='0742'DB:business_master_new
loadtime:0.77561712265015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayhill' limit 1
loadtime:0.77575206756592 / seconds
Query Executed:select id FROM `nm` where city='Mayhill' && SIC_code='0742'DB:business_master_new
loadtime:0.77680921554565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Alister' limit 1
loadtime:0.77685618400574 / seconds
Query Executed:select id FROM `nm` where city='Mc Alister' && SIC_code='0742'DB:business_master_new
loadtime:0.77739500999451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Donald' limit 1
loadtime:0.77749109268188 / seconds
Query Executed:select id FROM `nm` where city='Mc Donald' && SIC_code='0742'DB:business_master_new
loadtime:0.77891707420349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Intosh' limit 1
loadtime:0.77896499633789 / seconds
Query Executed:select id FROM `nm` where city='Mc Intosh' && SIC_code='0742'DB:business_master_new
loadtime:0.77955913543701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medanales' limit 1
loadtime:0.77967500686646 / seconds
Query Executed:select id FROM `nm` where city='Medanales' && SIC_code='0742'DB:business_master_new
loadtime:0.78162598609924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melrose' limit 1
loadtime:0.78166103363037 / seconds
Query Executed:select id FROM `nm` where city='Melrose' && SIC_code='0742'DB:business_master_new
loadtime:0.78281903266907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mentmore' limit 1
loadtime:0.78295207023621 / seconds
Query Executed:select id FROM `nm` where city='Mentmore' && SIC_code='0742'DB:business_master_new
loadtime:0.78772115707397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mescalero' limit 1
loadtime:0.78781318664551 / seconds
Query Executed:select id FROM `nm` where city='Mescalero' && SIC_code='0742'DB:business_master_new
loadtime:0.78914618492126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesilla' limit 1
loadtime:0.7892541885376 / seconds
Query Executed:select id FROM `nm` where city='Mesilla' && SIC_code='0742'DB:business_master_new
loadtime:0.79054808616638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesilla Park' limit 1
loadtime:0.79062008857727 / seconds
Query Executed:select id FROM `nm` where city='Mesilla Park' && SIC_code='0742'DB:business_master_new
loadtime:0.79199814796448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesquite' limit 1
loadtime:0.79212307929993 / seconds
Query Executed:select id FROM `nm` where city='Mesquite' && SIC_code='0742'DB:business_master_new
loadtime:0.7933189868927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mexican Springs' limit 1
loadtime:0.79340100288391 / seconds
Query Executed:select id FROM `nm` where city='Mexican Springs' && SIC_code='0742'DB:business_master_new
loadtime:0.79411101341248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miami' limit 1
loadtime:0.79420399665833 / seconds
Query Executed:select id FROM `nm` where city='Miami' && SIC_code='0742'DB:business_master_new
loadtime:0.79861617088318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milan' limit 1
loadtime:0.79870200157166 / seconds
Query Executed:select id FROM `nm` where city='Milan' && SIC_code='0742'DB:business_master_new
loadtime:0.80023503303528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mills' limit 1
loadtime:0.80033612251282 / seconds
Query Executed:select id FROM `nm` where city='Mills' && SIC_code='0742'DB:business_master_new
loadtime:0.8026762008667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milnesand' limit 1
loadtime:0.80273818969727 / seconds
Query Executed:select id FROM `nm` where city='Milnesand' && SIC_code='0742'DB:business_master_new
loadtime:0.80786514282227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mimbres' limit 1
loadtime:0.80790019035339 / seconds
Query Executed:select id FROM `nm` where city='Mimbres' && SIC_code='0742'DB:business_master_new
loadtime:0.80838298797607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mogollon' limit 1
loadtime:0.80843210220337 / seconds
Query Executed:select id FROM `nm` where city='Mogollon' && SIC_code='0742'DB:business_master_new
loadtime:0.808669090271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montezuma' limit 1
loadtime:0.80869603157043 / seconds
Query Executed:select id FROM `nm` where city='Montezuma' && SIC_code='0742'DB:business_master_new
loadtime:0.81402707099915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:0.81407618522644 / seconds
Query Executed:select id FROM `nm` where city='Monticello' && SIC_code='0742'DB:business_master_new
loadtime:0.8160982131958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monument' limit 1
loadtime:0.8161461353302 / seconds
Query Executed:select id FROM `nm` where city='Monument' && SIC_code='0742'DB:business_master_new
loadtime:0.82407999038696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mora' limit 1
loadtime:0.82411408424377 / seconds
Query Executed:select id FROM `nm` where city='Mora' && SIC_code='0742'DB:business_master_new
loadtime:0.82547402381897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moriarty' limit 1
loadtime:0.82560610771179 / seconds
Query Executed:select id FROM `nm` where city='Moriarty' && SIC_code='0742'DB:business_master_new
loadtime:0.82728099822998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mosquero' limit 1
loadtime:0.82737708091736 / seconds
Query Executed:select id FROM `nm` where city='Mosquero' && SIC_code='0742'DB:business_master_new
loadtime:0.82842111587524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountainair' limit 1
loadtime:0.82855415344238 / seconds
Query Executed:select id FROM `nm` where city='Mountainair' && SIC_code='0742'DB:business_master_new
loadtime:0.82982921600342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mule Creek' limit 1
loadtime:0.8299241065979 / seconds
Query Executed:select id FROM `nm` where city='Mule Creek' && SIC_code='0742'DB:business_master_new
loadtime:0.83284997940063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nageezi' limit 1
loadtime:0.83290004730225 / seconds
Query Executed:select id FROM `nm` where city='Nageezi' && SIC_code='0742'DB:business_master_new
loadtime:0.8393440246582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nara Visa' limit 1
loadtime:0.83942103385925 / seconds
Query Executed:select id FROM `nm` where city='Nara Visa' && SIC_code='0742'DB:business_master_new
loadtime:0.84034705162048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Navajo' limit 1
loadtime:0.84047913551331 / seconds
Query Executed:select id FROM `nm` where city='Navajo' && SIC_code='0742'DB:business_master_new
loadtime:0.8417592048645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Navajo Dam' limit 1
loadtime:0.84189200401306 / seconds
Query Executed:select id FROM `nm` where city='Navajo Dam' && SIC_code='0742'DB:business_master_new
loadtime:0.84307217597961 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Laguna' limit 1
loadtime:0.84316802024841 / seconds
Query Executed:select id FROM `nm` where city='New Laguna' && SIC_code='0742'DB:business_master_new
loadtime:0.8473801612854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newcomb' limit 1
loadtime:0.84743905067444 / seconds
Query Executed:select id FROM `nm` where city='Newcomb' && SIC_code='0742'DB:business_master_new
loadtime:0.84789109230042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newkirk' limit 1
loadtime:0.84791803359985 / seconds
Query Executed:select id FROM `nm` where city='Newkirk' && SIC_code='0742'DB:business_master_new
loadtime:0.8522641658783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nogal' limit 1
loadtime:0.85231518745422 / seconds
Query Executed:select id FROM `nm` where city='Nogal' && SIC_code='0742'DB:business_master_new
loadtime:0.85274410247803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocate' limit 1
loadtime:0.85277104377747 / seconds
Query Executed:select id FROM `nm` where city='Ocate' && SIC_code='0742'DB:business_master_new
loadtime:0.85564517974854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ojo Caliente' limit 1
loadtime:0.85569405555725 / seconds
Query Executed:select id FROM `nm` where city='Ojo Caliente' && SIC_code='0742'DB:business_master_new
loadtime:0.85616111755371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ojo Feliz' limit 1
loadtime:0.85619616508484 / seconds
Query Executed:select id FROM `nm` where city='Ojo Feliz' && SIC_code='0742'DB:business_master_new
loadtime:0.85668921470642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ojo Sarco' limit 1
loadtime:0.85675621032715 / seconds
Query Executed:select id FROM `nm` where city='Ojo Sarco' && SIC_code='0742'DB:business_master_new
loadtime:0.85751914978027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Organ' limit 1
loadtime:0.85756301879883 / seconds
Query Executed:select id FROM `nm` where city='Organ' && SIC_code='0742'DB:business_master_new
loadtime:0.85803318023682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orogrande' limit 1
loadtime:0.85806798934937 / seconds
Query Executed:select id FROM `nm` where city='Orogrande' && SIC_code='0742'DB:business_master_new
loadtime:0.86018800735474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paguate' limit 1
loadtime:0.86023712158203 / seconds
Query Executed:select id FROM `nm` where city='Paguate' && SIC_code='0742'DB:business_master_new
loadtime:0.86159920692444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pecos' limit 1
loadtime:0.86163401603699 / seconds
Query Executed:select id FROM `nm` where city='Pecos' && SIC_code='0742'DB:business_master_new
loadtime:0.86216115951538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pena Blanca' limit 1
loadtime:0.8622190952301 / seconds
Query Executed:select id FROM `nm` where city='Pena Blanca' && SIC_code='0742'DB:business_master_new
loadtime:0.86264610290527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penasco' limit 1
loadtime:0.8626811504364 / seconds
Query Executed:select id FROM `nm` where city='Penasco' && SIC_code='0742'DB:business_master_new
loadtime:0.86315703392029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pep' limit 1
loadtime:0.86320614814758 / seconds
Query Executed:select id FROM `nm` where city='Pep' && SIC_code='0742'DB:business_master_new
loadtime:0.8649001121521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peralta' limit 1
loadtime:0.86494898796082 / seconds
Query Executed:select id FROM `nm` where city='Peralta' && SIC_code='0742'DB:business_master_new
loadtime:0.86624217033386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petaca' limit 1
loadtime:0.86633706092834 / seconds
Query Executed:select id FROM `nm` where city='Petaca' && SIC_code='0742'DB:business_master_new
loadtime:0.86714220046997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Picacho' limit 1
loadtime:0.86726999282837 / seconds
Query Executed:select id FROM `nm` where city='Picacho' && SIC_code='0742'DB:business_master_new
loadtime:0.87127304077148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pie Town' limit 1
loadtime:0.87130808830261 / seconds
Query Executed:select id FROM `nm` where city='Pie Town' && SIC_code='0742'DB:business_master_new
loadtime:0.87175512313843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinehill' limit 1
loadtime:0.87179398536682 / seconds
Query Executed:select id FROM `nm` where city='Pinehill' && SIC_code='0742'DB:business_master_new
loadtime:0.87224316596985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinon' limit 1
loadtime:0.87227821350098 / seconds
Query Executed:select id FROM `nm` where city='Pinon' && SIC_code='0742'DB:business_master_new
loadtime:0.87686014175415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinos Altos' limit 1
loadtime:0.87690711021423 / seconds
Query Executed:select id FROM `nm` where city='Pinos Altos' && SIC_code='0742'DB:business_master_new
loadtime:0.88185906410217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Placitas' limit 1
loadtime:0.88189506530762 / seconds
Query Executed:select id FROM `nm` where city='Placitas' && SIC_code='0742'DB:business_master_new
loadtime:0.88301920890808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Playas' limit 1
loadtime:0.88312411308289 / seconds
Query Executed:select id FROM `nm` where city='Playas' && SIC_code='0742'DB:business_master_new
loadtime:0.88583397865295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pojoaque Valley' limit 1
loadtime:0.88588309288025 / seconds
Query Executed:select id FROM `nm` where city='Pojoaque Valley' && SIC_code='0742'DB:business_master_new
loadtime:0.8880500793457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polvadera' limit 1
loadtime:0.88807916641235 / seconds
Query Executed:select id FROM `nm` where city='Polvadera' && SIC_code='0742'DB:business_master_new
loadtime:0.89333009719849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ponderosa' limit 1
loadtime:0.89336919784546 / seconds
Query Executed:select id FROM `nm` where city='Ponderosa' && SIC_code='0742'DB:business_master_new
loadtime:0.89960098266602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portales' limit 1
loadtime:0.89962816238403 / seconds
Query Executed:select id FROM `nm` where city='Portales' && SIC_code='0742'DB:business_master_new
loadtime:0.90061616897583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prewitt' limit 1
loadtime:0.9006621837616 / seconds
Query Executed:select id FROM `nm` where city='Prewitt' && SIC_code='0742'DB:business_master_new
loadtime:0.90687012672424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pueblo Of Acoma' limit 1
loadtime:0.90690612792969 / seconds
Query Executed:select id FROM `nm` where city='Pueblo Of Acoma' && SIC_code='0742'DB:business_master_new
loadtime:0.90733003616333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quay' limit 1
loadtime:0.90737104415894 / seconds
Query Executed:select id FROM `nm` where city='Quay' && SIC_code='0742'DB:business_master_new
loadtime:0.90852212905884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quemado' limit 1
loadtime:0.90854907035828 / seconds
Query Executed:select id FROM `nm` where city='Quemado' && SIC_code='0742'DB:business_master_new
loadtime:0.90900421142578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Questa' limit 1
loadtime:0.90904116630554 / seconds
Query Executed:select id FROM `nm` where city='Questa' && SIC_code='0742'DB:business_master_new
loadtime:0.90951013565063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radium Springs' limit 1
loadtime:0.90954303741455 / seconds
Query Executed:select id FROM `nm` where city='Radium Springs' && SIC_code='0742'DB:business_master_new
loadtime:0.91505408287048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rainsville' limit 1
loadtime:0.91508913040161 / seconds
Query Executed:select id FROM `nm` where city='Rainsville' && SIC_code='0742'DB:business_master_new
loadtime:0.91571402549744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramah' limit 1
loadtime:0.91575598716736 / seconds
Query Executed:select id FROM `nm` where city='Ramah' && SIC_code='0742'DB:business_master_new
loadtime:0.91618514060974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ranchos De Taos' limit 1
loadtime:0.91621112823486 / seconds
Query Executed:select id FROM `nm` where city='Ranchos De Taos' && SIC_code='0742'DB:business_master_new
loadtime:0.91672015190125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raton' limit 1
loadtime:0.91677117347717 / seconds
Query Executed:select id FROM `nm` where city='Raton' && SIC_code='0742'DB:business_master_new
loadtime:0.9174439907074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red River' limit 1
loadtime:0.91747617721558 / seconds
Query Executed:select id FROM `nm` where city='Red River' && SIC_code='0742'DB:business_master_new
loadtime:0.91798305511475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redrock' limit 1
loadtime:0.91801905632019 / seconds
Query Executed:select id FROM `nm` where city='Redrock' && SIC_code='0742'DB:business_master_new
loadtime:0.9197781085968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Regina' limit 1
loadtime:0.91980314254761 / seconds
Query Executed:select id FROM `nm` where city='Regina' && SIC_code='0742'DB:business_master_new
loadtime:0.92207813262939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rehoboth' limit 1
loadtime:0.92212605476379 / seconds
Query Executed:select id FROM `nm` where city='Rehoboth' && SIC_code='0742'DB:business_master_new
loadtime:0.92467999458313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reserve' limit 1
loadtime:0.92473721504211 / seconds
Query Executed:select id FROM `nm` where city='Reserve' && SIC_code='0742'DB:business_master_new
loadtime:0.92520809173584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ribera' limit 1
loadtime:0.92523407936096 / seconds
Query Executed:select id FROM `nm` where city='Ribera' && SIC_code='0742'DB:business_master_new
loadtime:0.92564606666565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rincon' limit 1
loadtime:0.92568016052246 / seconds
Query Executed:select id FROM `nm` where city='Rincon' && SIC_code='0742'DB:business_master_new
loadtime:0.92906808853149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio Rancho' limit 1
loadtime:0.92909407615662 / seconds
Query Executed:select id FROM `nm` where city='Rio Rancho' && SIC_code='0742'DB:business_master_new
loadtime:0.93168616294861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rociada' limit 1
loadtime:0.93174600601196 / seconds
Query Executed:select id FROM `nm` where city='Rociada' && SIC_code='0742'DB:business_master_new
loadtime:0.93565607070923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rodeo' limit 1
loadtime:0.93569111824036 / seconds
Query Executed:select id FROM `nm` where city='Rodeo' && SIC_code='0742'DB:business_master_new
loadtime:0.94345498085022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rogers' limit 1
loadtime:0.94349503517151 / seconds
Query Executed:select id FROM `nm` where city='Rogers' && SIC_code='0742'DB:business_master_new
loadtime:0.94772410392761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roswell' limit 1
loadtime:0.94776320457458 / seconds
Query Executed:select id FROM `nm` where city='Roswell' && SIC_code='0742'DB:business_master_new
loadtime:0.95029401779175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowe' limit 1
loadtime:0.95033812522888 / seconds
Query Executed:select id FROM `nm` where city='Rowe' && SIC_code='0742'DB:business_master_new
loadtime:0.96288704872131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roy' limit 1
loadtime:0.96293520927429 / seconds
Query Executed:select id FROM `nm` where city='Roy' && SIC_code='0742'DB:business_master_new
loadtime:0.96369314193726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruidoso' limit 1
loadtime:0.96382713317871 / seconds
Query Executed:select id FROM `nm` where city='Ruidoso' && SIC_code='0742'DB:business_master_new
loadtime:0.97043418884277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruidoso Downs' limit 1
loadtime:0.97055220603943 / seconds
Query Executed:select id FROM `nm` where city='Ruidoso Downs' && SIC_code='0742'DB:business_master_new
loadtime:0.97187805175781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutheron' limit 1
loadtime:0.97203612327576 / seconds
Query Executed:select id FROM `nm` where city='Rutheron' && SIC_code='0742'DB:business_master_new
loadtime:0.97357106208801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sacramento' limit 1
loadtime:0.97360706329346 / seconds
Query Executed:select id FROM `nm` where city='Sacramento' && SIC_code='0742'DB:business_master_new
loadtime:0.97989010810852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Vrain' limit 1
loadtime:0.97994017601013 / seconds
Query Executed:select id FROM `nm` where city='Saint Vrain' && SIC_code='0742'DB:business_master_new
loadtime:0.98076701164246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.98081302642822 / seconds
Query Executed:select id FROM `nm` where city='Salem' && SIC_code='0742'DB:business_master_new
loadtime:0.98731803894043 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Acacia' limit 1
loadtime:0.98735308647156 / seconds
Query Executed:select id FROM `nm` where city='San Acacia' && SIC_code='0742'DB:business_master_new
loadtime:0.98994302749634 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Antonio' limit 1
loadtime:0.98999214172363 / seconds
Query Executed:select id FROM `nm` where city='San Antonio' && SIC_code='0742'DB:business_master_new
loadtime:0.99072313308716 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Cristobal' limit 1
loadtime:0.99077701568604 / seconds
Query Executed:select id FROM `nm` where city='San Cristobal' && SIC_code='0742'DB:business_master_new
loadtime:0.99675703048706 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Fidel' limit 1
loadtime:0.99680304527283 / seconds
Query Executed:select id FROM `nm` where city='San Fidel' && SIC_code='0742'DB:business_master_new
loadtime:0.99741101264954 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Jon' limit 1
loadtime:0.99745607376099 / seconds
Query Executed:select id FROM `nm` where city='San Jon' && SIC_code='0742'DB:business_master_new
loadtime:0.997878074646 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Jose' limit 1
loadtime:0.99790501594543 / seconds
Query Executed:select id FROM `nm` where city='San Jose' && SIC_code='0742'DB:business_master_new
loadtime:1.000550031662 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Juan Pueblo' limit 1
loadtime:1.0005991458893 / seconds
Query Executed:select id FROM `nm` where city='San Juan Pueblo' && SIC_code='0742'DB:business_master_new
loadtime:1.0012102127075 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Lorenzo' limit 1
loadtime:1.0012450218201 / seconds
Query Executed:select id FROM `nm` where city='San Lorenzo' && SIC_code='0742'DB:business_master_new
loadtime:1.0022270679474 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Miguel' limit 1
loadtime:1.0022749900818 / seconds
Query Executed:select id FROM `nm` where city='San Miguel' && SIC_code='0742'DB:business_master_new
loadtime:1.0098550319672 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Patricio' limit 1
loadtime:1.0098900794983 / seconds
Query Executed:select id FROM `nm` where city='San Patricio' && SIC_code='0742'DB:business_master_new
loadtime:1.0180690288544 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Rafael' limit 1
loadtime:1.0181181430817 / seconds
Query Executed:select id FROM `nm` where city='San Rafael' && SIC_code='0742'DB:business_master_new
loadtime:1.0204980373383 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Ysidro' limit 1
loadtime:1.0205461978912 / seconds
Query Executed:select id FROM `nm` where city='San Ysidro' && SIC_code='0742'DB:business_master_new
loadtime:1.0212111473083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandia Park' limit 1
loadtime:1.0212550163269 / seconds
Query Executed:select id FROM `nm` where city='Sandia Park' && SIC_code='0742'DB:business_master_new
loadtime:1.0218691825867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanostee' limit 1
loadtime:1.0219230651855 / seconds
Query Executed:select id FROM `nm` where city='Sanostee' && SIC_code='0742'DB:business_master_new
loadtime:1.0249722003937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Clara' limit 1
loadtime:1.0250082015991 / seconds
Query Executed:select id FROM `nm` where city='Santa Clara' && SIC_code='0742'DB:business_master_new
loadtime:1.0254340171814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Cruz' limit 1
loadtime:1.0254731178284 / seconds
Query Executed:select id FROM `nm` where city='Santa Cruz' && SIC_code='0742'DB:business_master_new
loadtime:1.0259311199188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Fe' limit 1
loadtime:1.0259571075439 / seconds
Query Executed:select id FROM `nm` where city='Santa Fe' && SIC_code='0742'DB:business_master_new
loadtime:1.0306541919708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Rosa' limit 1
loadtime:1.0307490825653 / seconds
Query Executed:select id FROM `nm` where city='Santa Rosa' && SIC_code='0742'DB:business_master_new
loadtime:1.0316061973572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Teresa' limit 1
loadtime:1.0316441059113 / seconds
Query Executed:select id FROM `nm` where city='Santa Teresa' && SIC_code='0742'DB:business_master_new
loadtime:1.0325829982758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santo Domingo Pb' limit 1
loadtime:1.0326390266418 / seconds
Query Executed:select id FROM `nm` where city='Santo Domingo Pb' && SIC_code='0742'DB:business_master_new
loadtime:1.0328991413116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santo Domingo Pueblo' limit 1
loadtime:1.03293800354 / seconds
Query Executed:select id FROM `nm` where city='Santo Domingo Pueblo' && SIC_code='0742'DB:business_master_new
loadtime:1.0389041900635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sapello' limit 1
loadtime:1.0389649868011 / seconds
Query Executed:select id FROM `nm` where city='Sapello' && SIC_code='0742'DB:business_master_new
loadtime:1.0449612140656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seboyeta' limit 1
loadtime:1.0450100898743 / seconds
Query Executed:select id FROM `nm` where city='Seboyeta' && SIC_code='0742'DB:business_master_new
loadtime:1.0460381507874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedan' limit 1
loadtime:1.0460731983185 / seconds
Query Executed:select id FROM `nm` where city='Sedan' && SIC_code='0742'DB:business_master_new
loadtime:1.0504770278931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:1.0505220890045 / seconds
Query Executed:select id FROM `nm` where city='Seneca' && SIC_code='0742'DB:business_master_new
loadtime:1.0508160591125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Serafina' limit 1
loadtime:1.0508561134338 / seconds
Query Executed:select id FROM `nm` where city='Serafina' && SIC_code='0742'DB:business_master_new
loadtime:1.0518670082092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheep Springs' limit 1
loadtime:1.0518951416016 / seconds
Query Executed:select id FROM `nm` where city='Sheep Springs' && SIC_code='0742'DB:business_master_new
loadtime:1.0550031661987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shiprock' limit 1
loadtime:1.0550520420074 / seconds
Query Executed:select id FROM `nm` where city='Shiprock' && SIC_code='0742'DB:business_master_new
loadtime:1.0556380748749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver City' limit 1
loadtime:1.0556750297546 / seconds
Query Executed:select id FROM `nm` where city='Silver City' && SIC_code='0742'DB:business_master_new
loadtime:1.0587651729584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smith Lake' limit 1
loadtime:1.0588231086731 / seconds
Query Executed:select id FROM `nm` where city='Smith Lake' && SIC_code='0742'DB:business_master_new
loadtime:1.0597372055054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Socorro' limit 1
loadtime:1.0597870349884 / seconds
Query Executed:select id FROM `nm` where city='Socorro' && SIC_code='0742'DB:business_master_new
loadtime:1.0605220794678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Solano' limit 1
loadtime:1.0605680942535 / seconds
Query Executed:select id FROM `nm` where city='Solano' && SIC_code='0742'DB:business_master_new
loadtime:1.0619251728058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springer' limit 1
loadtime:1.0619740486145 / seconds
Query Executed:select id FROM `nm` where city='Springer' && SIC_code='0742'DB:business_master_new
loadtime:1.0624740123749 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Vrain' limit 1
loadtime:1.062509059906 / seconds
Query Executed:select id FROM `nm` where city='St Vrain' && SIC_code='0742'DB:business_master_new
loadtime:1.0627582073212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:1.0627992153168 / seconds
Query Executed:select id FROM `nm` where city='Stanley' && SIC_code='0742'DB:business_master_new
loadtime:1.0632300376892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunland Park' limit 1
loadtime:1.0632650852203 / seconds
Query Executed:select id FROM `nm` where city='Sunland Park' && SIC_code='0742'DB:business_master_new
loadtime:1.06378698349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunspot' limit 1
loadtime:1.0638370513916 / seconds
Query Executed:select id FROM `nm` where city='Sunspot' && SIC_code='0742'DB:business_master_new
loadtime:1.0662941932678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taiban' limit 1
loadtime:1.0663430690765 / seconds
Query Executed:select id FROM `nm` where city='Taiban' && SIC_code='0742'DB:business_master_new
loadtime:1.066831111908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tajique' limit 1
loadtime:1.0668580532074 / seconds
Query Executed:select id FROM `nm` where city='Tajique' && SIC_code='0742'DB:business_master_new
loadtime:1.0679621696472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taos' limit 1
loadtime:1.0680110454559 / seconds
Query Executed:select id FROM `nm` where city='Taos' && SIC_code='0742'DB:business_master_new
loadtime:1.0706059932709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taos Ski Valley' limit 1
loadtime:1.0706510543823 / seconds
Query Executed:select id FROM `nm` where city='Taos Ski Valley' && SIC_code='0742'DB:business_master_new
loadtime:1.0711481571198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tatum' limit 1
loadtime:1.0711979866028 / seconds
Query Executed:select id FROM `nm` where city='Tatum' && SIC_code='0742'DB:business_master_new
loadtime:1.0716559886932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tererro' limit 1
loadtime:1.0716831684113 / seconds
Query Executed:select id FROM `nm` where city='Tererro' && SIC_code='0742'DB:business_master_new
loadtime:1.0735011100769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tesuque' limit 1
loadtime:1.0735499858856 / seconds
Query Executed:select id FROM `nm` where city='Tesuque' && SIC_code='0742'DB:business_master_new
loadtime:1.074038028717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Texico' limit 1
loadtime:1.0740749835968 / seconds
Query Executed:select id FROM `nm` where city='Texico' && SIC_code='0742'DB:business_master_new
loadtime:1.0745429992676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thoreau' limit 1
loadtime:1.0745911598206 / seconds
Query Executed:select id FROM `nm` where city='Thoreau' && SIC_code='0742'DB:business_master_new
loadtime:1.0751070976257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tierra Amarilla' limit 1
loadtime:1.0751550197601 / seconds
Query Executed:select id FROM `nm` where city='Tierra Amarilla' && SIC_code='0742'DB:business_master_new
loadtime:1.0756220817566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tijeras' limit 1
loadtime:1.0756480693817 / seconds
Query Executed:select id FROM `nm` where city='Tijeras' && SIC_code='0742'DB:business_master_new
loadtime:1.0762732028961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timberon' limit 1
loadtime:1.0763311386108 / seconds
Query Executed:select id FROM `nm` where city='Timberon' && SIC_code='0742'DB:business_master_new
loadtime:1.0767741203308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tinnie' limit 1
loadtime:1.0768091678619 / seconds
Query Executed:select id FROM `nm` where city='Tinnie' && SIC_code='0742'DB:business_master_new
loadtime:1.0803329944611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tohatchi' limit 1
loadtime:1.0803821086884 / seconds
Query Executed:select id FROM `nm` where city='Tohatchi' && SIC_code='0742'DB:business_master_new
loadtime:1.0808441638947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tome' limit 1
loadtime:1.0808711051941 / seconds
Query Executed:select id FROM `nm` where city='Tome' && SIC_code='0742'DB:business_master_new
loadtime:1.0812911987305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Torreon' limit 1
loadtime:1.0813381671906 / seconds
Query Executed:select id FROM `nm` where city='Torreon' && SIC_code='0742'DB:business_master_new
loadtime:1.0869760513306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trampas' limit 1
loadtime:1.0870110988617 / seconds
Query Executed:select id FROM `nm` where city='Trampas' && SIC_code='0742'DB:business_master_new
loadtime:1.0875442028046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trementina' limit 1
loadtime:1.0875930786133 / seconds
Query Executed:select id FROM `nm` where city='Trementina' && SIC_code='0742'DB:business_master_new
loadtime:1.0907270908356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tres Piedras' limit 1
loadtime:1.0907762050629 / seconds
Query Executed:select id FROM `nm` where city='Tres Piedras' && SIC_code='0742'DB:business_master_new
loadtime:1.1007220745087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truchas' limit 1
loadtime:1.1007571220398 / seconds
Query Executed:select id FROM `nm` where city='Truchas' && SIC_code='0742'DB:business_master_new
loadtime:1.1012091636658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truth Or Cnsqncs' limit 1
loadtime:1.1012580394745 / seconds
Query Executed:select id FROM `nm` where city='Truth Or Cnsqncs' && SIC_code='0742'DB:business_master_new
loadtime:1.1032161712646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truth Or Consequences' limit 1
loadtime:1.1032521724701 / seconds
Query Executed:select id FROM `nm` where city='Truth Or Consequences' && SIC_code='0742'DB:business_master_new
loadtime:1.1044762134552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tucumcari' limit 1
loadtime:1.1045751571655 / seconds
Query Executed:select id FROM `nm` where city='Tucumcari' && SIC_code='0742'DB:business_master_new
loadtime:1.1088161468506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tularosa' limit 1
loadtime:1.108861207962 / seconds
Query Executed:select id FROM `nm` where city='Tularosa' && SIC_code='0742'DB:business_master_new
loadtime:1.1113810539246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyrone' limit 1
loadtime:1.1114451885223 / seconds
Query Executed:select id FROM `nm` where city='Tyrone' && SIC_code='0742'DB:business_master_new
loadtime:1.1118540763855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ute Park' limit 1
loadtime:1.1118810176849 / seconds
Query Executed:select id FROM `nm` where city='Ute Park' && SIC_code='0742'DB:business_master_new
loadtime:1.1122870445251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vadito' limit 1
loadtime:1.1123371124268 / seconds
Query Executed:select id FROM `nm` where city='Vadito' && SIC_code='0742'DB:business_master_new
loadtime:1.1127331256866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vado' limit 1
loadtime:1.1127710342407 / seconds
Query Executed:select id FROM `nm` where city='Vado' && SIC_code='0742'DB:business_master_new
loadtime:1.1131939888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valdez' limit 1
loadtime:1.1132299900055 / seconds
Query Executed:select id FROM `nm` where city='Valdez' && SIC_code='0742'DB:business_master_new
loadtime:1.1136310100555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vallecitos' limit 1
loadtime:1.1136682033539 / seconds
Query Executed:select id FROM `nm` where city='Vallecitos' && SIC_code='0742'DB:business_master_new
loadtime:1.1140880584717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valmora' limit 1
loadtime:1.1141231060028 / seconds
Query Executed:select id FROM `nm` where city='Valmora' && SIC_code='0742'DB:business_master_new
loadtime:1.1147840023041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vanderwagen' limit 1
loadtime:1.1148331165314 / seconds
Query Executed:select id FROM `nm` where city='Vanderwagen' && SIC_code='0742'DB:business_master_new
loadtime:1.1152710914612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vaughn' limit 1
loadtime:1.1153070926666 / seconds
Query Executed:select id FROM `nm` where city='Vaughn' && SIC_code='0742'DB:business_master_new
loadtime:1.1157281398773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Veguita' limit 1
loadtime:1.1157701015472 / seconds
Query Executed:select id FROM `nm` where city='Veguita' && SIC_code='0742'DB:business_master_new
loadtime:1.1161861419678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Velarde' limit 1
loadtime:1.1162321567535 / seconds
Query Executed:select id FROM `nm` where city='Velarde' && SIC_code='0742'DB:business_master_new
loadtime:1.116669178009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villanueva' limit 1
loadtime:1.1167211532593 / seconds
Query Executed:select id FROM `nm` where city='Villanueva' && SIC_code='0742'DB:business_master_new
loadtime:1.1171190738678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wagon Mound' limit 1
loadtime:1.1171669960022 / seconds
Query Executed:select id FROM `nm` where city='Wagon Mound' && SIC_code='0742'DB:business_master_new
loadtime:1.1175711154938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterflow' limit 1
loadtime:1.1175990104675 / seconds
Query Executed:select id FROM `nm` where city='Waterflow' && SIC_code='0742'DB:business_master_new
loadtime:1.118036031723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watrous' limit 1
loadtime:1.1180851459503 / seconds
Query Executed:select id FROM `nm` where city='Watrous' && SIC_code='0742'DB:business_master_new
loadtime:1.1184930801392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weed' limit 1
loadtime:1.1185200214386 / seconds
Query Executed:select id FROM `nm` where city='Weed' && SIC_code='0742'DB:business_master_new
loadtime:1.1189320087433 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Sands' limit 1
loadtime:1.1189701557159 / seconds
Query Executed:select id FROM `nm` where city='White Sands' && SIC_code='0742'DB:business_master_new
loadtime:1.1193630695343 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Sands Missile Range' limit 1
loadtime:1.1194081306458 / seconds
Query Executed:select id FROM `nm` where city='White Sands Missile Range' && SIC_code='0742'DB:business_master_new
loadtime:1.1197941303253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whites City' limit 1
loadtime:1.1198351383209 / seconds
Query Executed:select id FROM `nm` where city='Whites City' && SIC_code='0742'DB:business_master_new
loadtime:1.1202340126038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willard' limit 1
loadtime:1.1202790737152 / seconds
Query Executed:select id FROM `nm` where city='Willard' && SIC_code='0742'DB:business_master_new
loadtime:1.1206660270691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:1.1206970214844 / seconds
Query Executed:select id FROM `nm` where city='Williamsburg' && SIC_code='0742'DB:business_master_new
loadtime:1.1211340427399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winston' limit 1
loadtime:1.1211800575256 / seconds
Query Executed:select id FROM `nm` where city='Winston' && SIC_code='0742'DB:business_master_new
loadtime:1.1215810775757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yatahey' limit 1
loadtime:1.1216070652008 / seconds
Query Executed:select id FROM `nm` where city='Yatahey' && SIC_code='0742'DB:business_master_new
loadtime:1.1220400333405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yeso' limit 1
loadtime:1.1220870018005 / seconds
Query Executed:select id FROM `nm` where city='Yeso' && SIC_code='0742'DB:business_master_new
loadtime:1.1224911212921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Youngsville' limit 1
loadtime:1.1225180625916 / seconds
Query Executed:select id FROM `nm` where city='Youngsville' && SIC_code='0742'DB:business_master_new
loadtime:1.1238131523132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zuni' limit 1
loadtime:1.1238601207733 / seconds
Query Executed:select id FROM `nm` where city='Zuni' && SIC_code='0742'DB:business_master_new
loadtime:1.1263580322266 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.1264431476593 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.1266231536865 / seconds
Operation template executed (chunk cache operation)
loadtime:1.1267001628876 / seconds
template override:Default
loadtime:1.126736164093 / 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.1275341510773 / seconds
Template Constructed, Array Rows:49
loadtime:1.1277821063995 / seconds
TOTAL EXECUTION TIME: 1.12758
loadtime:1.1278731822968 / 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] => veterinary-services-for-animal-specialties [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.1278781890869
TOTAL KEY ARRAYS: 69