DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.7976455688477E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0024240016937256 / seconds
host not found setting manual db connection
loadtime:0.010268926620483 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010514974594116 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.01068902015686 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010756969451904 / seconds
zipcode:
loadtime:0.010784864425659 / seconds
Query Executed:select * from search_referrer where page_hash='a6ced506798b799bc412933bac8b39dd' limit 10 DB:ezrox_toadli
loadtime:0.011047840118408 / seconds
Operation header executed (non global)
loadtime:0.011079788208008 / seconds
Operation leaderboard executed (non global)
loadtime:0.011132001876831 / seconds
Operation square executed (non global)
loadtime:0.011171817779541 / seconds
Operation square_bottom executed (non global)
loadtime:0.011201858520508 / seconds
Operation smallsquare executed (non global)
loadtime:0.01122784614563 / seconds
Operation headeradright executed (non global)
loadtime:0.011253833770752 / seconds
Operation google_analytics executed (non global)
loadtime:0.011278867721558 / seconds
Operation topstories executed (non global)
loadtime:0.01130485534668 / seconds
Operation businessnearyou executed (non global)
loadtime:0.011331796646118 / seconds
Operation memberbuscount executed (non global)
loadtime:0.011356830596924 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.01160192489624 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011806011199951 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011842012405396 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011904001235962 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011950969696045 / seconds
Template key: archive_menu pushed
loadtime:0.011959791183472 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011973857879639 / seconds
Template key: get_gravatar pushed
loadtime:0.011981010437012 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011990785598755 / seconds
*10)-10)+1 | start:0
loadtime:0.012038946151733 / seconds
Query loaded from cache:select * from categories where cat_URLid='family-clothing-stores'
loadtime:0.012091875076294 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-mexico'
loadtime:0.012131929397583 / seconds
DB connected to localhost business_master_new
loadtime:0.012408971786499 / seconds
Query Executed:select * from `nm_catmap` where sic='5651' order by city ascDB:business_master_new
loadtime:0.015085935592651 / seconds
Query stored in cache : _QUERY_www.toadli.com081da90bd9548e43d4dc7f27123a01bd
loadtime:0.016585826873779 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-mexico'
loadtime:0.016639947891235 / seconds
Query Executed:select sum(totalcount) as totalsum from `nm_catmap` where sic='5651'DB:business_master_new
loadtime:0.018630981445312 / seconds
Query stored in cache : _QUERY_www.toadli.com2db92eb75e5d4923ad6f953178235de3
loadtime:0.018673896789551 / seconds
369 / 11
loadtime:0.018728971481323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abiquiu' limit 1
loadtime:0.018795013427734 / seconds
Query Executed:select id FROM `nm` where city='Abiquiu' && SIC_code='5651'DB:business_master_new
loadtime:0.020731925964355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alameda' limit 1
loadtime:0.020788908004761 / seconds
Query Executed:select id FROM `nm` where city='Alameda' && SIC_code='5651'DB:business_master_new
loadtime:0.02118182182312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alamogordo' limit 1
loadtime:0.021235942840576 / seconds
Query Executed:select id FROM `nm` where city='Alamogordo' && SIC_code='5651'DB:business_master_new
loadtime:0.022990942001343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albuquerque' limit 1
loadtime:0.023066997528076 / seconds
Query Executed:select id FROM `nm` where city='Albuquerque' && SIC_code='5651'DB:business_master_new
loadtime:0.024885892868042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alcalde' limit 1
loadtime:0.025039911270142 / seconds
Query Executed:select id FROM `nm` where city='Alcalde' && SIC_code='5651'DB:business_master_new
loadtime:0.025876998901367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Algodones' limit 1
loadtime:0.025936841964722 / seconds
Query Executed:select id FROM `nm` where city='Algodones' && SIC_code='5651'DB:business_master_new
loadtime:0.027691841125488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alto' limit 1
loadtime:0.027745962142944 / seconds
Query Executed:select id FROM `nm` where city='Alto' && SIC_code='5651'DB:business_master_new
loadtime:0.029496908187866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amalia' limit 1
loadtime:0.029549837112427 / seconds
Query Executed:select id FROM `nm` where city='Amalia' && SIC_code='5651'DB:business_master_new
loadtime:0.02997088432312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amistad' limit 1
loadtime:0.030028820037842 / seconds
Query Executed:select id FROM `nm` where city='Amistad' && SIC_code='5651'DB:business_master_new
loadtime:0.030531883239746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Angel Fire' limit 1
loadtime:0.03058385848999 / seconds
Query Executed:select id FROM `nm` where city='Angel Fire' && SIC_code='5651'DB:business_master_new
loadtime:0.032334804534912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Animas' limit 1
loadtime:0.032400846481323 / seconds
Query Executed:select id FROM `nm` where city='Animas' && SIC_code='5651'DB:business_master_new
loadtime:0.034161806106567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anthony' limit 1
loadtime:0.034221887588501 / seconds
Query Executed:select id FROM `nm` where city='Anthony' && SIC_code='5651'DB:business_master_new
loadtime:0.035972833633423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anton Chico' limit 1
loadtime:0.03603196144104 / seconds
Query Executed:select id FROM `nm` where city='Anton Chico' && SIC_code='5651'DB:business_master_new
loadtime:0.036733865737915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aragon' limit 1
loadtime:0.036800861358643 / seconds
Query Executed:select id FROM `nm` where city='Aragon' && SIC_code='5651'DB:business_master_new
loadtime:0.037233829498291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arenas Valley' limit 1
loadtime:0.037286996841431 / seconds
Query Executed:select id FROM `nm` where city='Arenas Valley' && SIC_code='5651'DB:business_master_new
loadtime:0.039036989212036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arrey' limit 1
loadtime:0.03908896446228 / seconds
Query Executed:select id FROM `nm` where city='Arrey' && SIC_code='5651'DB:business_master_new
loadtime:0.039719820022583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arroyo Hondo' limit 1
loadtime:0.039771795272827 / seconds
Query Executed:select id FROM `nm` where city='Arroyo Hondo' && SIC_code='5651'DB:business_master_new
loadtime:0.040524959564209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arroyo Seco' limit 1
loadtime:0.04057788848877 / seconds
Query Executed:select id FROM `nm` where city='Arroyo Seco' && SIC_code='5651'DB:business_master_new
loadtime:0.041800975799561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Artesia' limit 1
loadtime:0.041852951049805 / seconds
Query Executed:select id FROM `nm` where city='Artesia' && SIC_code='5651'DB:business_master_new
loadtime:0.04365086555481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aztec' limit 1
loadtime:0.043722867965698 / seconds
Query Executed:select id FROM `nm` where city='Aztec' && SIC_code='5651'DB:business_master_new
loadtime:0.045529842376709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bard' limit 1
loadtime:0.045583963394165 / seconds
Query Executed:select id FROM `nm` where city='Bard' && SIC_code='5651'DB:business_master_new
loadtime:0.046037912368774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayard' limit 1
loadtime:0.046089887619019 / seconds
Query Executed:select id FROM `nm` where city='Bayard' && SIC_code='5651'DB:business_master_new
loadtime:0.047858953475952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belen' limit 1
loadtime:0.047910928726196 / seconds
Query Executed:select id FROM `nm` where city='Belen' && SIC_code='5651'DB:business_master_new
loadtime:0.049674987792969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bell Ranch' limit 1
loadtime:0.049726963043213 / seconds
Query Executed:select id FROM `nm` where city='Bell Ranch' && SIC_code='5651'DB:business_master_new
loadtime:0.05012583732605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bent' limit 1
loadtime:0.050185918807983 / seconds
Query Executed:select id FROM `nm` where city='Bent' && SIC_code='5651'DB:business_master_new
loadtime:0.050633907318115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berino' limit 1
loadtime:0.050683975219727 / seconds
Query Executed:select id FROM `nm` where city='Berino' && SIC_code='5651'DB:business_master_new
loadtime:0.051175832748413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bernalillo' limit 1
loadtime:0.051229953765869 / seconds
Query Executed:select id FROM `nm` where city='Bernalillo' && SIC_code='5651'DB:business_master_new
loadtime:0.052999019622803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bingham' limit 1
loadtime:0.053070783615112 / seconds
Query Executed:select id FROM `nm` where city='Bingham' && SIC_code='5651'DB:business_master_new
loadtime:0.053469896316528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanco' limit 1
loadtime:0.053521871566772 / seconds
Query Executed:select id FROM `nm` where city='Blanco' && SIC_code='5651'DB:business_master_new
loadtime:0.054193019866943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield' limit 1
loadtime:0.054250955581665 / seconds
Query Executed:select id FROM `nm` where city='Bloomfield' && SIC_code='5651'DB:business_master_new
loadtime:0.056015968322754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluewater' limit 1
loadtime:0.056087017059326 / seconds
Query Executed:select id FROM `nm` where city='Bluewater' && SIC_code='5651'DB:business_master_new
loadtime:0.056665897369385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bosque' limit 1
loadtime:0.056718826293945 / seconds
Query Executed:select id FROM `nm` where city='Bosque' && SIC_code='5651'DB:business_master_new
loadtime:0.057355880737305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bosque Farms' limit 1
loadtime:0.057407855987549 / seconds
Query Executed:select id FROM `nm` where city='Bosque Farms' && SIC_code='5651'DB:business_master_new
loadtime:0.059189796447754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brimhall' limit 1
loadtime:0.059256792068481 / seconds
Query Executed:select id FROM `nm` where city='Brimhall' && SIC_code='5651'DB:business_master_new
loadtime:0.059674978256226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadview' limit 1
loadtime:0.059725999832153 / seconds
Query Executed:select id FROM `nm` where city='Broadview' && SIC_code='5651'DB:business_master_new
loadtime:0.06027889251709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckhorn' limit 1
loadtime:0.06033182144165 / seconds
Query Executed:select id FROM `nm` where city='Buckhorn' && SIC_code='5651'DB:business_master_new
loadtime:0.060825824737549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buena Vista' limit 1
loadtime:0.06087589263916 / seconds
Query Executed:select id FROM `nm` where city='Buena Vista' && SIC_code='5651'DB:business_master_new
loadtime:0.061364889144897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caballo' limit 1
loadtime:0.061417818069458 / seconds
Query Executed:select id FROM `nm` where city='Caballo' && SIC_code='5651'DB:business_master_new
loadtime:0.062068939208984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canjilon' limit 1
loadtime:0.062120914459229 / seconds
Query Executed:select id FROM `nm` where city='Canjilon' && SIC_code='5651'DB:business_master_new
loadtime:0.062678813934326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cannon Afb' limit 1
loadtime:0.062735795974731 / seconds
Query Executed:select id FROM `nm` where city='Cannon Afb' && SIC_code='5651'DB:business_master_new
loadtime:0.06450891494751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canoncito' limit 1
loadtime:0.06456184387207 / seconds
Query Executed:select id FROM `nm` where city='Canoncito' && SIC_code='5651'DB:business_master_new
loadtime:0.064955949783325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canones' limit 1
loadtime:0.065009832382202 / seconds
Query Executed:select id FROM `nm` where city='Canones' && SIC_code='5651'DB:business_master_new
loadtime:0.065445899963379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capitan' limit 1
loadtime:0.065497875213623 / seconds
Query Executed:select id FROM `nm` where city='Capitan' && SIC_code='5651'DB:business_master_new
loadtime:0.067268848419189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caprock' limit 1
loadtime:0.067334890365601 / seconds
Query Executed:select id FROM `nm` where city='Caprock' && SIC_code='5651'DB:business_master_new
loadtime:0.067770004272461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capulin' limit 1
loadtime:0.067821979522705 / seconds
Query Executed:select id FROM `nm` where city='Capulin' && SIC_code='5651'DB:business_master_new
loadtime:0.068336009979248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlsbad' limit 1
loadtime:0.068388938903809 / seconds
Query Executed:select id FROM `nm` where city='Carlsbad' && SIC_code='5651'DB:business_master_new
loadtime:0.070175886154175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrizozo' limit 1
loadtime:0.070245981216431 / seconds
Query Executed:select id FROM `nm` where city='Carrizozo' && SIC_code='5651'DB:business_master_new
loadtime:0.072014808654785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson' limit 1
loadtime:0.072068929672241 / seconds
Query Executed:select id FROM `nm` where city='Carson' && SIC_code='5651'DB:business_master_new
loadtime:0.072559833526611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casa Blanca' limit 1
loadtime:0.072611808776855 / seconds
Query Executed:select id FROM `nm` where city='Casa Blanca' && SIC_code='5651'DB:business_master_new
loadtime:0.073251008987427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Causey' limit 1
loadtime:0.073306798934937 / seconds
Query Executed:select id FROM `nm` where city='Causey' && SIC_code='5651'DB:business_master_new
loadtime:0.073826789855957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cebolla' limit 1
loadtime:0.073877811431885 / seconds
Query Executed:select id FROM `nm` where city='Cebolla' && SIC_code='5651'DB:business_master_new
loadtime:0.074354887008667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Crest' limit 1
loadtime:0.074406862258911 / seconds
Query Executed:select id FROM `nm` where city='Cedar Crest' && SIC_code='5651'DB:business_master_new
loadtime:0.076172828674316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central' limit 1
loadtime:0.076225996017456 / seconds
Query Executed:select id FROM `nm` where city='Central' && SIC_code='5651'DB:business_master_new
loadtime:0.076658010482788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cerrillos' limit 1
loadtime:0.076708793640137 / seconds
Query Executed:select id FROM `nm` where city='Cerrillos' && SIC_code='5651'DB:business_master_new
loadtime:0.07845401763916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cerro' limit 1
loadtime:0.078521013259888 / seconds
Query Executed:select id FROM `nm` where city='Cerro' && SIC_code='5651'DB:business_master_new
loadtime:0.078984975814819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chacon' limit 1
loadtime:0.079041957855225 / seconds
Query Executed:select id FROM `nm` where city='Chacon' && SIC_code='5651'DB:business_master_new
loadtime:0.079485893249512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chama' limit 1
loadtime:0.079536914825439 / seconds
Query Executed:select id FROM `nm` where city='Chama' && SIC_code='5651'DB:business_master_new
loadtime:0.081292867660522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chamberino' limit 1
loadtime:0.081360816955566 / seconds
Query Executed:select id FROM `nm` where city='Chamberino' && SIC_code='5651'DB:business_master_new
loadtime:0.081847906112671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chamisal' limit 1
loadtime:0.081904888153076 / seconds
Query Executed:select id FROM `nm` where city='Chamisal' && SIC_code='5651'DB:business_master_new
loadtime:0.083652973175049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chaparral' limit 1
loadtime:0.083705902099609 / seconds
Query Executed:select id FROM `nm` where city='Chaparral' && SIC_code='5651'DB:business_master_new
loadtime:0.085471868515015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chimayo' limit 1
loadtime:0.085523843765259 / seconds
Query Executed:select id FROM `nm` where city='Chimayo' && SIC_code='5651'DB:business_master_new
loadtime:0.087291955947876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Church Rock' limit 1
loadtime:0.087358951568604 / seconds
Query Executed:select id FROM `nm` where city='Church Rock' && SIC_code='5651'DB:business_master_new
loadtime:0.087918996810913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cimarron' limit 1
loadtime:0.087970972061157 / seconds
Query Executed:select id FROM `nm` where city='Cimarron' && SIC_code='5651'DB:business_master_new
loadtime:0.089748859405518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claunch' limit 1
loadtime:0.089800834655762 / seconds
Query Executed:select id FROM `nm` where city='Claunch' && SIC_code='5651'DB:business_master_new
loadtime:0.090279817581177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clayton' limit 1
loadtime:0.090335845947266 / seconds
Query Executed:select id FROM `nm` where city='Clayton' && SIC_code='5651'DB:business_master_new
loadtime:0.092113018035889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.092189788818359 / seconds
Query Executed:select id FROM `nm` where city='Cleveland' && SIC_code='5651'DB:business_master_new
loadtime:0.092741012573242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cliff' limit 1
loadtime:0.092797994613647 / seconds
Query Executed:select id FROM `nm` where city='Cliff' && SIC_code='5651'DB:business_master_new
loadtime:0.093585968017578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clines Corners' limit 1
loadtime:0.093638896942139 / seconds
Query Executed:select id FROM `nm` where city='Clines Corners' && SIC_code='5651'DB:business_master_new
loadtime:0.094092845916748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cloudcroft' limit 1
loadtime:0.094144821166992 / seconds
Query Executed:select id FROM `nm` where city='Cloudcroft' && SIC_code='5651'DB:business_master_new
loadtime:0.095930814743042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clovis' limit 1
loadtime:0.096004009246826 / seconds
Query Executed:select id FROM `nm` where city='Clovis' && SIC_code='5651'DB:business_master_new
loadtime:0.097820997238159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cochiti Lake' limit 1
loadtime:0.097895860671997 / seconds
Query Executed:select id FROM `nm` where city='Cochiti Lake' && SIC_code='5651'DB:business_master_new
loadtime:0.098477840423584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cochiti Pueblo' limit 1
loadtime:0.098536968231201 / seconds
Query Executed:select id FROM `nm` where city='Cochiti Pueblo' && SIC_code='5651'DB:business_master_new
loadtime:0.099002838134766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:0.099061012268066 / seconds
Query Executed:select id FROM `nm` where city='Columbus' && SIC_code='5651'DB:business_master_new
loadtime:0.10012483596802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conchas Dam' limit 1
loadtime:0.10018587112427 / seconds
Query Executed:select id FROM `nm` where city='Conchas Dam' && SIC_code='5651'DB:business_master_new
loadtime:0.10088586807251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Continental Div' limit 1
loadtime:0.10093688964844 / seconds
Query Executed:select id FROM `nm` where city='Continental Div' && SIC_code='5651'DB:business_master_new
loadtime:0.10134983062744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Continental Divide' limit 1
loadtime:0.10140180587769 / seconds
Query Executed:select id FROM `nm` where city='Continental Divide' && SIC_code='5651'DB:business_master_new
loadtime:0.1019549369812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cordova' limit 1
loadtime:0.10201787948608 / seconds
Query Executed:select id FROM `nm` where city='Cordova' && SIC_code='5651'DB:business_master_new
loadtime:0.10262298583984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corona' limit 1
loadtime:0.10267901420593 / seconds
Query Executed:select id FROM `nm` where city='Corona' && SIC_code='5651'DB:business_master_new
loadtime:0.10367679595947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corrales' limit 1
loadtime:0.1037290096283 / seconds
Query Executed:select id FROM `nm` where city='Corrales' && SIC_code='5651'DB:business_master_new
loadtime:0.10548901557922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Costilla' limit 1
loadtime:0.10555601119995 / seconds
Query Executed:select id FROM `nm` where city='Costilla' && SIC_code='5651'DB:business_master_new
loadtime:0.10611486434937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Counselor' limit 1
loadtime:0.10617685317993 / seconds
Query Executed:select id FROM `nm` where city='Counselor' && SIC_code='5651'DB:business_master_new
loadtime:0.1066689491272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coyote' limit 1
loadtime:0.10671997070312 / seconds
Query Executed:select id FROM `nm` where city='Coyote' && SIC_code='5651'DB:business_master_new
loadtime:0.10729885101318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crossroads' limit 1
loadtime:0.10735201835632 / seconds
Query Executed:select id FROM `nm` where city='Crossroads' && SIC_code='5651'DB:business_master_new
loadtime:0.10774493217468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crownpoint' limit 1
loadtime:0.10780000686646 / seconds
Query Executed:select id FROM `nm` where city='Crownpoint' && SIC_code='5651'DB:business_master_new
loadtime:0.10955882072449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuba' limit 1
loadtime:0.10961079597473 / seconds
Query Executed:select id FROM `nm` where city='Cuba' && SIC_code='5651'DB:business_master_new
loadtime:0.11137294769287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cubero' limit 1
loadtime:0.11142492294312 / seconds
Query Executed:select id FROM `nm` where city='Cubero' && SIC_code='5651'DB:business_master_new
loadtime:0.11196184158325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuchillo' limit 1
loadtime:0.11201786994934 / seconds
Query Executed:select id FROM `nm` where city='Cuchillo' && SIC_code='5651'DB:business_master_new
loadtime:0.11242580413818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuervo' limit 1
loadtime:0.11247801780701 / seconds
Query Executed:select id FROM `nm` where city='Cuervo' && SIC_code='5651'DB:business_master_new
loadtime:0.11290788650513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Datil' limit 1
loadtime:0.11295890808105 / seconds
Query Executed:select id FROM `nm` where city='Datil' && SIC_code='5651'DB:business_master_new
loadtime:0.11390399932861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deming' limit 1
loadtime:0.11395502090454 / seconds
Query Executed:select id FROM `nm` where city='Deming' && SIC_code='5651'DB:business_master_new
loadtime:0.11572289466858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derry' limit 1
loadtime:0.11577582359314 / seconds
Query Executed:select id FROM `nm` where city='Derry' && SIC_code='5651'DB:business_master_new
loadtime:0.11619901657104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Des Moines' limit 1
loadtime:0.11625385284424 / seconds
Query Executed:select id FROM `nm` where city='Des Moines' && SIC_code='5651'DB:business_master_new
loadtime:0.11702799797058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dexter' limit 1
loadtime:0.11707997322083 / seconds
Query Executed:select id FROM `nm` where city='Dexter' && SIC_code='5651'DB:business_master_new
loadtime:0.11883592605591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dixon' limit 1
loadtime:0.11888885498047 / seconds
Query Executed:select id FROM `nm` where city='Dixon' && SIC_code='5651'DB:business_master_new
loadtime:0.12063598632812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dona Ana' limit 1
loadtime:0.12069392204285 / seconds
Query Executed:select id FROM `nm` where city='Dona Ana' && SIC_code='5651'DB:business_master_new
loadtime:0.12147188186646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dora' limit 1
loadtime:0.12152600288391 / seconds
Query Executed:select id FROM `nm` where city='Dora' && SIC_code='5651'DB:business_master_new
loadtime:0.12212586402893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dulce' limit 1
loadtime:0.12219095230103 / seconds
Query Executed:select id FROM `nm` where city='Dulce' && SIC_code='5651'DB:business_master_new
loadtime:0.1239378452301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duran' limit 1
loadtime:0.12399291992188 / seconds
Query Executed:select id FROM `nm` where city='Duran' && SIC_code='5651'DB:business_master_new
loadtime:0.12440800666809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Nest' limit 1
loadtime:0.12446093559265 / seconds
Query Executed:select id FROM `nm` where city='Eagle Nest' && SIC_code='5651'DB:business_master_new
loadtime:0.1262309551239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewood' limit 1
loadtime:0.12628483772278 / seconds
Query Executed:select id FROM `nm` where city='Edgewood' && SIC_code='5651'DB:business_master_new
loadtime:0.12805080413818 / seconds
Query loaded from cache:select * from geodata_geocity where city='El Prado' limit 1
loadtime:0.12810301780701 / seconds
Query Executed:select id FROM `nm` where city='El Prado' && SIC_code='5651'DB:business_master_new
loadtime:0.12985992431641 / seconds
Query loaded from cache:select * from geodata_geocity where city='El Rito' limit 1
loadtime:0.12991285324097 / seconds
Query Executed:select id FROM `nm` where city='El Rito' && SIC_code='5651'DB:business_master_new
loadtime:0.1307168006897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elephant Butte' limit 1
loadtime:0.13077092170715 / seconds
Query Executed:select id FROM `nm` where city='Elephant Butte' && SIC_code='5651'DB:business_master_new
loadtime:0.13254594802856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elida' limit 1
loadtime:0.13259792327881 / seconds
Query Executed:select id FROM `nm` where city='Elida' && SIC_code='5651'DB:business_master_new
loadtime:0.13352298736572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Embudo' limit 1
loadtime:0.13357496261597 / seconds
Query Executed:select id FROM `nm` where city='Embudo' && SIC_code='5651'DB:business_master_new
loadtime:0.13431191444397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Encino' limit 1
loadtime:0.13436388969421 / seconds
Query Executed:select id FROM `nm` where city='Encino' && SIC_code='5651'DB:business_master_new
loadtime:0.13500189781189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Espanola' limit 1
loadtime:0.13505387306213 / seconds
Query Executed:select id FROM `nm` where city='Espanola' && SIC_code='5651'DB:business_master_new
loadtime:0.13681888580322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estancia' limit 1
loadtime:0.13688993453979 / seconds
Query Executed:select id FROM `nm` where city='Estancia' && SIC_code='5651'DB:business_master_new
loadtime:0.13864493370056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eunice' limit 1
loadtime:0.13870286941528 / seconds
Query Executed:select id FROM `nm` where city='Eunice' && SIC_code='5651'DB:business_master_new
loadtime:0.14047193527222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairacres' limit 1
loadtime:0.14052486419678 / seconds
Query Executed:select id FROM `nm` where city='Fairacres' && SIC_code='5651'DB:business_master_new
loadtime:0.1422758102417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:0.14232897758484 / seconds
Query Executed:select id FROM `nm` where city='Fairview' && SIC_code='5651'DB:business_master_new
loadtime:0.14270496368408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.14275693893433 / seconds
Query Executed:select id FROM `nm` where city='Farmington' && SIC_code='5651'DB:business_master_new
loadtime:0.14452385902405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faywood' limit 1
loadtime:0.14459896087646 / seconds
Query Executed:select id FROM `nm` where city='Faywood' && SIC_code='5651'DB:business_master_new
loadtime:0.14505100250244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fence Lake' limit 1
loadtime:0.14510989189148 / seconds
Query Executed:select id FROM `nm` where city='Fence Lake' && SIC_code='5651'DB:business_master_new
loadtime:0.14560389518738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flora Vista' limit 1
loadtime:0.14565992355347 / seconds
Query Executed:select id FROM `nm` where city='Flora Vista' && SIC_code='5651'DB:business_master_new
loadtime:0.1474277973175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Floyd' limit 1
loadtime:0.14748191833496 / seconds
Query Executed:select id FROM `nm` where city='Floyd' && SIC_code='5651'DB:business_master_new
loadtime:0.14812779426575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flying H' limit 1
loadtime:0.148188829422 / seconds
Query Executed:select id FROM `nm` where city='Flying H' && SIC_code='5651'DB:business_master_new
loadtime:0.1485698223114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Folsom' limit 1
loadtime:0.14862084388733 / seconds
Query Executed:select id FROM `nm` where city='Folsom' && SIC_code='5651'DB:business_master_new
loadtime:0.14931893348694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Bayard' limit 1
loadtime:0.14937090873718 / seconds
Query Executed:select id FROM `nm` where city='Fort Bayard' && SIC_code='5651'DB:business_master_new
loadtime:0.14981293678284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Stanton' limit 1
loadtime:0.14986395835876 / seconds
Query Executed:select id FROM `nm` where city='Fort Stanton' && SIC_code='5651'DB:business_master_new
loadtime:0.15033888816833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Sumner' limit 1
loadtime:0.15039300918579 / seconds
Query Executed:select id FROM `nm` where city='Fort Sumner' && SIC_code='5651'DB:business_master_new
loadtime:0.15217185020447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Wingate' limit 1
loadtime:0.15222501754761 / seconds
Query Executed:select id FROM `nm` where city='Fort Wingate' && SIC_code='5651'DB:business_master_new
loadtime:0.15297889709473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitland' limit 1
loadtime:0.1530339717865 / seconds
Query Executed:select id FROM `nm` where city='Fruitland' && SIC_code='5651'DB:business_master_new
loadtime:0.15400981903076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gallina' limit 1
loadtime:0.1540629863739 / seconds
Query Executed:select id FROM `nm` where city='Gallina' && SIC_code='5651'DB:business_master_new
loadtime:0.15462279319763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gallup' limit 1
loadtime:0.15467381477356 / seconds
Query Executed:select id FROM `nm` where city='Gallup' && SIC_code='5651'DB:business_master_new
loadtime:0.15645694732666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gamerco' limit 1
loadtime:0.15652990341187 / seconds
Query Executed:select id FROM `nm` where city='Gamerco' && SIC_code='5651'DB:business_master_new
loadtime:0.15722990036011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garfield' limit 1
loadtime:0.15728402137756 / seconds
Query Executed:select id FROM `nm` where city='Garfield' && SIC_code='5651'DB:business_master_new
loadtime:0.15782785415649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garita' limit 1
loadtime:0.15787887573242 / seconds
Query Executed:select id FROM `nm` where city='Garita' && SIC_code='5651'DB:business_master_new
loadtime:0.15826392173767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gila' limit 1
loadtime:0.15831685066223 / seconds
Query Executed:select id FROM `nm` where city='Gila' && SIC_code='5651'DB:business_master_new
loadtime:0.15892481803894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladstone' limit 1
loadtime:0.15897488594055 / seconds
Query Executed:select id FROM `nm` where city='Gladstone' && SIC_code='5651'DB:business_master_new
loadtime:0.15941286087036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glencoe' limit 1
loadtime:0.15947079658508 / seconds
Query Executed:select id FROM `nm` where city='Glencoe' && SIC_code='5651'DB:business_master_new
loadtime:0.1599588394165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:0.16001582145691 / seconds
Query Executed:select id FROM `nm` where city='Glenwood' && SIC_code='5651'DB:business_master_new
loadtime:0.16176986694336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glorieta' limit 1
loadtime:0.1618218421936 / seconds
Query Executed:select id FROM `nm` where city='Glorieta' && SIC_code='5651'DB:business_master_new
loadtime:0.16357779502869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grady' limit 1
loadtime:0.16363096237183 / seconds
Query Executed:select id FROM `nm` where city='Grady' && SIC_code='5651'DB:business_master_new
loadtime:0.16422200202942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grants' limit 1
loadtime:0.16427493095398 / seconds
Query Executed:select id FROM `nm` where city='Grants' && SIC_code='5651'DB:business_master_new
loadtime:0.16603684425354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grenville' limit 1
loadtime:0.16610383987427 / seconds
Query Executed:select id FROM `nm` where city='Grenville' && SIC_code='5651'DB:business_master_new
loadtime:0.16660690307617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guadalupita' limit 1
loadtime:0.16666078567505 / seconds
Query Executed:select id FROM `nm` where city='Guadalupita' && SIC_code='5651'DB:business_master_new
loadtime:0.16720795631409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hachita' limit 1
loadtime:0.16726493835449 / seconds
Query Executed:select id FROM `nm` where city='Hachita' && SIC_code='5651'DB:business_master_new
loadtime:0.16778182983398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hagerman' limit 1
loadtime:0.16783690452576 / seconds
Query Executed:select id FROM `nm` where city='Hagerman' && SIC_code='5651'DB:business_master_new
loadtime:0.16960287094116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.16965484619141 / seconds
Query Executed:select id FROM `nm` where city='Hanover' && SIC_code='5651'DB:business_master_new
loadtime:0.1702938079834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatch' limit 1
loadtime:0.17034697532654 / seconds
Query Executed:select id FROM `nm` where city='Hatch' && SIC_code='5651'DB:business_master_new
loadtime:0.17211389541626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hernandez' limit 1
loadtime:0.17218899726868 / seconds
Query Executed:select id FROM `nm` where city='Hernandez' && SIC_code='5651'DB:business_master_new
loadtime:0.17282700538635 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Rls Mtn Pk' limit 1
loadtime:0.17287993431091 / seconds
Query Executed:select id FROM `nm` where city='High Rls Mtn Pk' && SIC_code='5651'DB:business_master_new
loadtime:0.17327284812927 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Rolls Mountain Park' limit 1
loadtime:0.17332696914673 / seconds
Query Executed:select id FROM `nm` where city='High Rolls Mountain Park' && SIC_code='5651'DB:business_master_new
loadtime:0.174232006073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:0.17428994178772 / seconds
Query Executed:select id FROM `nm` where city='Hillsboro' && SIC_code='5651'DB:business_master_new
loadtime:0.17501401901245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hobbs' limit 1
loadtime:0.1750659942627 / seconds
Query Executed:select id FROM `nm` where city='Hobbs' && SIC_code='5651'DB:business_master_new
loadtime:0.17687082290649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holloman Afb' limit 1
loadtime:0.17694997787476 / seconds
Query Executed:select id FROM `nm` where city='Holloman Afb' && SIC_code='5651'DB:business_master_new
loadtime:0.17772793769836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holloman Air Force Base' limit 1
loadtime:0.17778301239014 / seconds
Query Executed:select id FROM `nm` where city='Holloman Air Force Base' && SIC_code='5651'DB:business_master_new
loadtime:0.17954301834106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holman' limit 1
loadtime:0.17959690093994 / seconds
Query Executed:select id FROM `nm` where city='Holman' && SIC_code='5651'DB:business_master_new
loadtime:0.18005800247192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hondo' limit 1
loadtime:0.18011093139648 / seconds
Query Executed:select id FROM `nm` where city='Hondo' && SIC_code='5651'DB:business_master_new
loadtime:0.1818540096283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hope' limit 1
loadtime:0.18190693855286 / seconds
Query Executed:select id FROM `nm` where city='Hope' && SIC_code='5651'DB:business_master_new
loadtime:0.1824939250946 / seconds
Query loaded from cache:select * from geodata_geocity where city='House' limit 1
loadtime:0.18254780769348 / seconds
Query Executed:select id FROM `nm` where city='House' && SIC_code='5651'DB:business_master_new
loadtime:0.18317699432373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:0.18322992324829 / seconds
Query Executed:select id FROM `nm` where city='Hurley' && SIC_code='5651'DB:business_master_new
loadtime:0.18399691581726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isleta' limit 1
loadtime:0.18405079841614 / seconds
Query Executed:select id FROM `nm` where city='Isleta' && SIC_code='5651'DB:business_master_new
loadtime:0.18579292297363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jal' limit 1
loadtime:0.18584585189819 / seconds
Query Executed:select id FROM `nm` where city='Jal' && SIC_code='5651'DB:business_master_new
loadtime:0.18762588500977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:0.18768286705017 / seconds
Query Executed:select id FROM `nm` where city='Jamestown' && SIC_code='5651'DB:business_master_new
loadtime:0.1882438659668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jarales' limit 1
loadtime:0.18829679489136 / seconds
Query Executed:select id FROM `nm` where city='Jarales' && SIC_code='5651'DB:business_master_new
loadtime:0.18892979621887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jemez Pueblo' limit 1
loadtime:0.1889820098877 / seconds
Query Executed:select id FROM `nm` where city='Jemez Pueblo' && SIC_code='5651'DB:business_master_new
loadtime:0.19012498855591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jemez Springs' limit 1
loadtime:0.19018578529358 / seconds
Query Executed:select id FROM `nm` where city='Jemez Springs' && SIC_code='5651'DB:business_master_new
loadtime:0.19195580482483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenna' limit 1
loadtime:0.19201278686523 / seconds
Query Executed:select id FROM `nm` where city='Kenna' && SIC_code='5651'DB:business_master_new
loadtime:0.19243097305298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirtland' limit 1
loadtime:0.19248390197754 / seconds
Query Executed:select id FROM `nm` where city='Kirtland' && SIC_code='5651'DB:business_master_new
loadtime:0.19423985481262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirtland Afb' limit 1
loadtime:0.19429278373718 / seconds
Query Executed:select id FROM `nm` where city='Kirtland Afb' && SIC_code='5651'DB:business_master_new
loadtime:0.19604182243347 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Jara' limit 1
loadtime:0.19609498977661 / seconds
Query Executed:select id FROM `nm` where city='La Jara' && SIC_code='5651'DB:business_master_new
loadtime:0.19652986526489 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Joya' limit 1
loadtime:0.19658184051514 / seconds
Query Executed:select id FROM `nm` where city='La Joya' && SIC_code='5651'DB:business_master_new
loadtime:0.19700789451599 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Loma' limit 1
loadtime:0.19706892967224 / seconds
Query Executed:select id FROM `nm` where city='La Loma' && SIC_code='5651'DB:business_master_new
loadtime:0.19747090339661 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Luz' limit 1
loadtime:0.19752883911133 / seconds
Query Executed:select id FROM `nm` where city='La Luz' && SIC_code='5651'DB:business_master_new
loadtime:0.19930481910706 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Madera' limit 1
loadtime:0.19936180114746 / seconds
Query Executed:select id FROM `nm` where city='La Madera' && SIC_code='5651'DB:business_master_new
loadtime:0.19980883598328 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Mesa' limit 1
loadtime:0.19986081123352 / seconds
Query Executed:select id FROM `nm` where city='La Mesa' && SIC_code='5651'DB:business_master_new
loadtime:0.20161485671997 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Plata' limit 1
loadtime:0.20167183876038 / seconds
Query Executed:select id FROM `nm` where city='La Plata' && SIC_code='5651'DB:business_master_new
loadtime:0.20244479179382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laguna' limit 1
loadtime:0.20250296592712 / seconds
Query Executed:select id FROM `nm` where city='Laguna' && SIC_code='5651'DB:business_master_new
loadtime:0.2042818069458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lajoya' limit 1
loadtime:0.20433497428894 / seconds
Query Executed:select id FROM `nm` where city='Lajoya' && SIC_code='5651'DB:business_master_new
loadtime:0.20473194122314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Arthur' limit 1
loadtime:0.20478391647339 / seconds
Query Executed:select id FROM `nm` where city='Lake Arthur' && SIC_code='5651'DB:business_master_new
loadtime:0.20562887191772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakewood' limit 1
loadtime:0.20568180084229 / seconds
Query Executed:select id FROM `nm` where city='Lakewood' && SIC_code='5651'DB:business_master_new
loadtime:0.20631289482117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamy' limit 1
loadtime:0.20636582374573 / seconds
Query Executed:select id FROM `nm` where city='Lamy' && SIC_code='5651'DB:business_master_new
loadtime:0.20735001564026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Las Cruces' limit 1
loadtime:0.20740294456482 / seconds
Query Executed:select id FROM `nm` where city='Las Cruces' && SIC_code='5651'DB:business_master_new
loadtime:0.20918393135071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Las Vegas' limit 1
loadtime:0.20926594734192 / seconds
Query Executed:select id FROM `nm` where city='Las Vegas' && SIC_code='5651'DB:business_master_new
loadtime:0.211012840271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemitar' limit 1
loadtime:0.21106886863708 / seconds
Query Executed:select id FROM `nm` where city='Lemitar' && SIC_code='5651'DB:business_master_new
loadtime:0.21174383163452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.21180200576782 / seconds
Query Executed:select id FROM `nm` where city='Lincoln' && SIC_code='5651'DB:business_master_new
loadtime:0.21239900588989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lindrith' limit 1
loadtime:0.2124559879303 / seconds
Query Executed:select id FROM `nm` where city='Lindrith' && SIC_code='5651'DB:business_master_new
loadtime:0.21312093734741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Llano' limit 1
loadtime:0.21318197250366 / seconds
Query Executed:select id FROM `nm` where city='Llano' && SIC_code='5651'DB:business_master_new
loadtime:0.21356296539307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loco Hills' limit 1
loadtime:0.21361494064331 / seconds
Query Executed:select id FROM `nm` where city='Loco Hills' && SIC_code='5651'DB:business_master_new
loadtime:0.21537280082703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Logan' limit 1
loadtime:0.21543002128601 / seconds
Query Executed:select id FROM `nm` where city='Logan' && SIC_code='5651'DB:business_master_new
loadtime:0.21721291542053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lordsburg' limit 1
loadtime:0.21726584434509 / seconds
Query Executed:select id FROM `nm` where city='Lordsburg' && SIC_code='5651'DB:business_master_new
loadtime:0.21904182434082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Los Alamos' limit 1
loadtime:0.21911001205444 / seconds
Query Executed:select id FROM `nm` where city='Los Alamos' && SIC_code='5651'DB:business_master_new
loadtime:0.2208788394928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Los Lunas' limit 1
loadtime:0.22093296051025 / seconds
Query Executed:select id FROM `nm` where city='Los Lunas' && SIC_code='5651'DB:business_master_new
loadtime:0.22270393371582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Los Ojos' limit 1
loadtime:0.22276997566223 / seconds
Query Executed:select id FROM `nm` where city='Los Ojos' && SIC_code='5651'DB:business_master_new
loadtime:0.22340893745422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loving' limit 1
loadtime:0.223464012146 / seconds
Query Executed:select id FROM `nm` where city='Loving' && SIC_code='5651'DB:business_master_new
loadtime:0.22521591186523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovington' limit 1
loadtime:0.22526884078979 / seconds
Query Executed:select id FROM `nm` where city='Lovington' && SIC_code='5651'DB:business_master_new
loadtime:0.2270519733429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lumberton' limit 1
loadtime:0.2271249294281 / seconds
Query Executed:select id FROM `nm` where city='Lumberton' && SIC_code='5651'DB:business_master_new
loadtime:0.22768998146057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luna' limit 1
loadtime:0.22775292396545 / seconds
Query Executed:select id FROM `nm` where city='Luna' && SIC_code='5651'DB:business_master_new
loadtime:0.22840285301208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magdalena' limit 1
loadtime:0.22846579551697 / seconds
Query Executed:select id FROM `nm` where city='Magdalena' && SIC_code='5651'DB:business_master_new
loadtime:0.23032379150391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malaga' limit 1
loadtime:0.2304048538208 / seconds
Query Executed:select id FROM `nm` where city='Malaga' && SIC_code='5651'DB:business_master_new
loadtime:0.23084092140198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maljamar' limit 1
loadtime:0.23090291023254 / seconds
Query Executed:select id FROM `nm` where city='Maljamar' && SIC_code='5651'DB:business_master_new
loadtime:0.23154401779175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxwell' limit 1
loadtime:0.23160481452942 / seconds
Query Executed:select id FROM `nm` where city='Maxwell' && SIC_code='5651'DB:business_master_new
loadtime:0.23232889175415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayhill' limit 1
loadtime:0.2323899269104 / seconds
Query Executed:select id FROM `nm` where city='Mayhill' && SIC_code='5651'DB:business_master_new
loadtime:0.23345899581909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Alister' limit 1
loadtime:0.23351883888245 / seconds
Query Executed:select id FROM `nm` where city='Mc Alister' && SIC_code='5651'DB:business_master_new
loadtime:0.2339289188385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Donald' limit 1
loadtime:0.23398995399475 / seconds
Query Executed:select id FROM `nm` where city='Mc Donald' && SIC_code='5651'DB:business_master_new
loadtime:0.23443698883057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Intosh' limit 1
loadtime:0.23449897766113 / seconds
Query Executed:select id FROM `nm` where city='Mc Intosh' && SIC_code='5651'DB:business_master_new
loadtime:0.23490881919861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medanales' limit 1
loadtime:0.23497295379639 / seconds
Query Executed:select id FROM `nm` where city='Medanales' && SIC_code='5651'DB:business_master_new
loadtime:0.23545384407043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melrose' limit 1
loadtime:0.23552179336548 / seconds
Query Executed:select id FROM `nm` where city='Melrose' && SIC_code='5651'DB:business_master_new
loadtime:0.23734283447266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mentmore' limit 1
loadtime:0.23740482330322 / seconds
Query Executed:select id FROM `nm` where city='Mentmore' && SIC_code='5651'DB:business_master_new
loadtime:0.23792386054993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mescalero' limit 1
loadtime:0.23798489570618 / seconds
Query Executed:select id FROM `nm` where city='Mescalero' && SIC_code='5651'DB:business_master_new
loadtime:0.23978400230408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesilla' limit 1
loadtime:0.23984599113464 / seconds
Query Executed:select id FROM `nm` where city='Mesilla' && SIC_code='5651'DB:business_master_new
loadtime:0.24162101745605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesilla Park' limit 1
loadtime:0.24168300628662 / seconds
Query Executed:select id FROM `nm` where city='Mesilla Park' && SIC_code='5651'DB:business_master_new
loadtime:0.24346089363098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesquite' limit 1
loadtime:0.24352192878723 / seconds
Query Executed:select id FROM `nm` where city='Mesquite' && SIC_code='5651'DB:business_master_new
loadtime:0.24530696868896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mexican Springs' limit 1
loadtime:0.24536895751953 / seconds
Query Executed:select id FROM `nm` where city='Mexican Springs' && SIC_code='5651'DB:business_master_new
loadtime:0.2457640171051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miami' limit 1
loadtime:0.24582290649414 / seconds
Query Executed:select id FROM `nm` where city='Miami' && SIC_code='5651'DB:business_master_new
loadtime:0.24631595611572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milan' limit 1
loadtime:0.24637579917908 / seconds
Query Executed:select id FROM `nm` where city='Milan' && SIC_code='5651'DB:business_master_new
loadtime:0.24814295768738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mills' limit 1
loadtime:0.24821186065674 / seconds
Query Executed:select id FROM `nm` where city='Mills' && SIC_code='5651'DB:business_master_new
loadtime:0.2486310005188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milnesand' limit 1
loadtime:0.24869179725647 / seconds
Query Executed:select id FROM `nm` where city='Milnesand' && SIC_code='5651'DB:business_master_new
loadtime:0.24921298027039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mimbres' limit 1
loadtime:0.24927401542664 / seconds
Query Executed:select id FROM `nm` where city='Mimbres' && SIC_code='5651'DB:business_master_new
loadtime:0.25105285644531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mogollon' limit 1
loadtime:0.25111889839172 / seconds
Query Executed:select id FROM `nm` where city='Mogollon' && SIC_code='5651'DB:business_master_new
loadtime:0.25151300430298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montezuma' limit 1
loadtime:0.25157785415649 / seconds
Query Executed:select id FROM `nm` where city='Montezuma' && SIC_code='5651'DB:business_master_new
loadtime:0.25216794013977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:0.2522349357605 / seconds
Query Executed:select id FROM `nm` where city='Monticello' && SIC_code='5651'DB:business_master_new
loadtime:0.2526638507843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monument' limit 1
loadtime:0.25272488594055 / seconds
Query Executed:select id FROM `nm` where city='Monument' && SIC_code='5651'DB:business_master_new
loadtime:0.2533278465271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mora' limit 1
loadtime:0.25338888168335 / seconds
Query Executed:select id FROM `nm` where city='Mora' && SIC_code='5651'DB:business_master_new
loadtime:0.25517201423645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moriarty' limit 1
loadtime:0.25523400306702 / seconds
Query Executed:select id FROM `nm` where city='Moriarty' && SIC_code='5651'DB:business_master_new
loadtime:0.25699687004089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mosquero' limit 1
loadtime:0.25706100463867 / seconds
Query Executed:select id FROM `nm` where city='Mosquero' && SIC_code='5651'DB:business_master_new
loadtime:0.2588357925415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountainair' limit 1
loadtime:0.25890183448792 / seconds
Query Executed:select id FROM `nm` where city='Mountainair' && SIC_code='5651'DB:business_master_new
loadtime:0.26072382926941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mule Creek' limit 1
loadtime:0.26078486442566 / seconds
Query Executed:select id FROM `nm` where city='Mule Creek' && SIC_code='5651'DB:business_master_new
loadtime:0.26131200790405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nageezi' limit 1
loadtime:0.26137280464172 / seconds
Query Executed:select id FROM `nm` where city='Nageezi' && SIC_code='5651'DB:business_master_new
loadtime:0.26193594932556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nara Visa' limit 1
loadtime:0.26200079917908 / seconds
Query Executed:select id FROM `nm` where city='Nara Visa' && SIC_code='5651'DB:business_master_new
loadtime:0.26276087760925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Navajo' limit 1
loadtime:0.2628219127655 / seconds
Query Executed:select id FROM `nm` where city='Navajo' && SIC_code='5651'DB:business_master_new
loadtime:0.26360893249512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Navajo Dam' limit 1
loadtime:0.26366996765137 / seconds
Query Executed:select id FROM `nm` where city='Navajo Dam' && SIC_code='5651'DB:business_master_new
loadtime:0.26442980766296 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Laguna' limit 1
loadtime:0.2644898891449 / seconds
Query Executed:select id FROM `nm` where city='New Laguna' && SIC_code='5651'DB:business_master_new
loadtime:0.2649998664856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newcomb' limit 1
loadtime:0.26506185531616 / seconds
Query Executed:select id FROM `nm` where city='Newcomb' && SIC_code='5651'DB:business_master_new
loadtime:0.2657458782196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newkirk' limit 1
loadtime:0.26580691337585 / seconds
Query Executed:select id FROM `nm` where city='Newkirk' && SIC_code='5651'DB:business_master_new
loadtime:0.26630091667175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nogal' limit 1
loadtime:0.26636099815369 / seconds
Query Executed:select id FROM `nm` where city='Nogal' && SIC_code='5651'DB:business_master_new
loadtime:0.2671058177948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocate' limit 1
loadtime:0.26717686653137 / seconds
Query Executed:select id FROM `nm` where city='Ocate' && SIC_code='5651'DB:business_master_new
loadtime:0.26771283149719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ojo Caliente' limit 1
loadtime:0.26777291297913 / seconds
Query Executed:select id FROM `nm` where city='Ojo Caliente' && SIC_code='5651'DB:business_master_new
loadtime:0.26871085166931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ojo Feliz' limit 1
loadtime:0.26877188682556 / seconds
Query Executed:select id FROM `nm` where city='Ojo Feliz' && SIC_code='5651'DB:business_master_new
loadtime:0.26922988891602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ojo Sarco' limit 1
loadtime:0.26928997039795 / seconds
Query Executed:select id FROM `nm` where city='Ojo Sarco' && SIC_code='5651'DB:business_master_new
loadtime:0.26974701881409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Organ' limit 1
loadtime:0.26980686187744 / seconds
Query Executed:select id FROM `nm` where city='Organ' && SIC_code='5651'DB:business_master_new
loadtime:0.27050495147705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orogrande' limit 1
loadtime:0.2705659866333 / seconds
Query Executed:select id FROM `nm` where city='Orogrande' && SIC_code='5651'DB:business_master_new
loadtime:0.27108597755432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paguate' limit 1
loadtime:0.27114582061768 / seconds
Query Executed:select id FROM `nm` where city='Paguate' && SIC_code='5651'DB:business_master_new
loadtime:0.27164387702942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pecos' limit 1
loadtime:0.27170491218567 / seconds
Query Executed:select id FROM `nm` where city='Pecos' && SIC_code='5651'DB:business_master_new
loadtime:0.27349901199341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pena Blanca' limit 1
loadtime:0.27355885505676 / seconds
Query Executed:select id FROM `nm` where city='Pena Blanca' && SIC_code='5651'DB:business_master_new
loadtime:0.27427387237549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penasco' limit 1
loadtime:0.2743399143219 / seconds
Query Executed:select id FROM `nm` where city='Penasco' && SIC_code='5651'DB:business_master_new
loadtime:0.27614188194275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pep' limit 1
loadtime:0.27621078491211 / seconds
Query Executed:select id FROM `nm` where city='Pep' && SIC_code='5651'DB:business_master_new
loadtime:0.27666687965393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peralta' limit 1
loadtime:0.27672696113586 / seconds
Query Executed:select id FROM `nm` where city='Peralta' && SIC_code='5651'DB:business_master_new
loadtime:0.27854299545288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petaca' limit 1
loadtime:0.27860379219055 / seconds
Query Executed:select id FROM `nm` where city='Petaca' && SIC_code='5651'DB:business_master_new
loadtime:0.27903699874878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Picacho' limit 1
loadtime:0.27909898757935 / seconds
Query Executed:select id FROM `nm` where city='Picacho' && SIC_code='5651'DB:business_master_new
loadtime:0.27976989746094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pie Town' limit 1
loadtime:0.27983093261719 / seconds
Query Executed:select id FROM `nm` where city='Pie Town' && SIC_code='5651'DB:business_master_new
loadtime:0.28056883811951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinehill' limit 1
loadtime:0.28062891960144 / seconds
Query Executed:select id FROM `nm` where city='Pinehill' && SIC_code='5651'DB:business_master_new
loadtime:0.28134679794312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinon' limit 1
loadtime:0.28140878677368 / seconds
Query Executed:select id FROM `nm` where city='Pinon' && SIC_code='5651'DB:business_master_new
loadtime:0.28197884559631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinos Altos' limit 1
loadtime:0.28204488754272 / seconds
Query Executed:select id FROM `nm` where city='Pinos Altos' && SIC_code='5651'DB:business_master_new
loadtime:0.28259491920471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Placitas' limit 1
loadtime:0.28266096115112 / seconds
Query Executed:select id FROM `nm` where city='Placitas' && SIC_code='5651'DB:business_master_new
loadtime:0.28451895713806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Playas' limit 1
loadtime:0.28458380699158 / seconds
Query Executed:select id FROM `nm` where city='Playas' && SIC_code='5651'DB:business_master_new
loadtime:0.2850399017334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pojoaque Valley' limit 1
loadtime:0.28509497642517 / seconds
Query Executed:select id FROM `nm` where city='Pojoaque Valley' && SIC_code='5651'DB:business_master_new
loadtime:0.28554797172546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polvadera' limit 1
loadtime:0.28560090065002 / seconds
Query Executed:select id FROM `nm` where city='Polvadera' && SIC_code='5651'DB:business_master_new
loadtime:0.28611397743225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ponderosa' limit 1
loadtime:0.28617596626282 / seconds
Query Executed:select id FROM `nm` where city='Ponderosa' && SIC_code='5651'DB:business_master_new
loadtime:0.28667593002319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portales' limit 1
loadtime:0.28672695159912 / seconds
Query Executed:select id FROM `nm` where city='Portales' && SIC_code='5651'DB:business_master_new
loadtime:0.28850984573364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prewitt' limit 1
loadtime:0.28856301307678 / seconds
Query Executed:select id FROM `nm` where city='Prewitt' && SIC_code='5651'DB:business_master_new
loadtime:0.28918480873108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pueblo Of Acoma' limit 1
loadtime:0.28923892974854 / seconds
Query Executed:select id FROM `nm` where city='Pueblo Of Acoma' && SIC_code='5651'DB:business_master_new
loadtime:0.28997778892517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quay' limit 1
loadtime:0.29003596305847 / seconds
Query Executed:select id FROM `nm` where city='Quay' && SIC_code='5651'DB:business_master_new
loadtime:0.29045081138611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quemado' limit 1
loadtime:0.29050493240356 / seconds
Query Executed:select id FROM `nm` where city='Quemado' && SIC_code='5651'DB:business_master_new
loadtime:0.29150080680847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Questa' limit 1
loadtime:0.29155302047729 / seconds
Query Executed:select id FROM `nm` where city='Questa' && SIC_code='5651'DB:business_master_new
loadtime:0.29332184791565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radium Springs' limit 1
loadtime:0.29338383674622 / seconds
Query Executed:select id FROM `nm` where city='Radium Springs' && SIC_code='5651'DB:business_master_new
loadtime:0.29390501976013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rainsville' limit 1
loadtime:0.29396080970764 / seconds
Query Executed:select id FROM `nm` where city='Rainsville' && SIC_code='5651'DB:business_master_new
loadtime:0.29433798789978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramah' limit 1
loadtime:0.29439496994019 / seconds
Query Executed:select id FROM `nm` where city='Ramah' && SIC_code='5651'DB:business_master_new
loadtime:0.2961368560791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ranchos De Taos' limit 1
loadtime:0.29619979858398 / seconds
Query Executed:select id FROM `nm` where city='Ranchos De Taos' && SIC_code='5651'DB:business_master_new
loadtime:0.29795479774475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raton' limit 1
loadtime:0.29801297187805 / seconds
Query Executed:select id FROM `nm` where city='Raton' && SIC_code='5651'DB:business_master_new
loadtime:0.29980087280273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red River' limit 1
loadtime:0.29987287521362 / seconds
Query Executed:select id FROM `nm` where city='Red River' && SIC_code='5651'DB:business_master_new
loadtime:0.30164980888367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redrock' limit 1
loadtime:0.30170392990112 / seconds
Query Executed:select id FROM `nm` where city='Redrock' && SIC_code='5651'DB:business_master_new
loadtime:0.30213379859924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Regina' limit 1
loadtime:0.30219984054565 / seconds
Query Executed:select id FROM `nm` where city='Regina' && SIC_code='5651'DB:business_master_new
loadtime:0.30265283584595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rehoboth' limit 1
loadtime:0.30270481109619 / seconds
Query Executed:select id FROM `nm` where city='Rehoboth' && SIC_code='5651'DB:business_master_new
loadtime:0.30322098731995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reserve' limit 1
loadtime:0.30327582359314 / seconds
Query Executed:select id FROM `nm` where city='Reserve' && SIC_code='5651'DB:business_master_new
loadtime:0.30502080917358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ribera' limit 1
loadtime:0.30507779121399 / seconds
Query Executed:select id FROM `nm` where city='Ribera' && SIC_code='5651'DB:business_master_new
loadtime:0.30579400062561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rincon' limit 1
loadtime:0.30584692955017 / seconds
Query Executed:select id FROM `nm` where city='Rincon' && SIC_code='5651'DB:business_master_new
loadtime:0.3064169883728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio Rancho' limit 1
loadtime:0.30647087097168 / seconds
Query Executed:select id FROM `nm` where city='Rio Rancho' && SIC_code='5651'DB:business_master_new
loadtime:0.30823993682861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rociada' limit 1
loadtime:0.30831098556519 / seconds
Query Executed:select id FROM `nm` where city='Rociada' && SIC_code='5651'DB:business_master_new
loadtime:0.30879092216492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rodeo' limit 1
loadtime:0.30884385108948 / seconds
Query Executed:select id FROM `nm` where city='Rodeo' && SIC_code='5651'DB:business_master_new
loadtime:0.30943489074707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rogers' limit 1
loadtime:0.30948686599731 / seconds
Query Executed:select id FROM `nm` where city='Rogers' && SIC_code='5651'DB:business_master_new
loadtime:0.30995678901672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roswell' limit 1
loadtime:0.31001687049866 / seconds
Query Executed:select id FROM `nm` where city='Roswell' && SIC_code='5651'DB:business_master_new
loadtime:0.31178379058838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowe' limit 1
loadtime:0.3118588924408 / seconds
Query Executed:select id FROM `nm` where city='Rowe' && SIC_code='5651'DB:business_master_new
loadtime:0.31244087219238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roy' limit 1
loadtime:0.31249594688416 / seconds
Query Executed:select id FROM `nm` where city='Roy' && SIC_code='5651'DB:business_master_new
loadtime:0.313551902771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruidoso' limit 1
loadtime:0.3136088848114 / seconds
Query Executed:select id FROM `nm` where city='Ruidoso' && SIC_code='5651'DB:business_master_new
loadtime:0.31538701057434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruidoso Downs' limit 1
loadtime:0.31546401977539 / seconds
Query Executed:select id FROM `nm` where city='Ruidoso Downs' && SIC_code='5651'DB:business_master_new
loadtime:0.31723380088806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutheron' limit 1
loadtime:0.31728887557983 / seconds
Query Executed:select id FROM `nm` where city='Rutheron' && SIC_code='5651'DB:business_master_new
loadtime:0.31768393516541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sacramento' limit 1
loadtime:0.31774401664734 / seconds
Query Executed:select id FROM `nm` where city='Sacramento' && SIC_code='5651'DB:business_master_new
loadtime:0.31822180747986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Vrain' limit 1
loadtime:0.318274974823 / seconds
Query Executed:select id FROM `nm` where city='Saint Vrain' && SIC_code='5651'DB:business_master_new
loadtime:0.3186559677124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.31870698928833 / seconds
Query Executed:select id FROM `nm` where city='Salem' && SIC_code='5651'DB:business_master_new
loadtime:0.31930685043335 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Acacia' limit 1
loadtime:0.31936287879944 / seconds
Query Executed:select id FROM `nm` where city='San Acacia' && SIC_code='5651'DB:business_master_new
loadtime:0.31980681419373 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Antonio' limit 1
loadtime:0.31985783576965 / seconds
Query Executed:select id FROM `nm` where city='San Antonio' && SIC_code='5651'DB:business_master_new
loadtime:0.32055592536926 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Cristobal' limit 1
loadtime:0.32061195373535 / seconds
Query Executed:select id FROM `nm` where city='San Cristobal' && SIC_code='5651'DB:business_master_new
loadtime:0.32117891311646 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Fidel' limit 1
loadtime:0.32123398780823 / seconds
Query Executed:select id FROM `nm` where city='San Fidel' && SIC_code='5651'DB:business_master_new
loadtime:0.32188081741333 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Jon' limit 1
loadtime:0.32193684577942 / seconds
Query Executed:select id FROM `nm` where city='San Jon' && SIC_code='5651'DB:business_master_new
loadtime:0.32290101051331 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Jose' limit 1
loadtime:0.32295799255371 / seconds
Query Executed:select id FROM `nm` where city='San Jose' && SIC_code='5651'DB:business_master_new
loadtime:0.32350182533264 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Juan Pueblo' limit 1
loadtime:0.32355380058289 / seconds
Query Executed:select id FROM `nm` where city='San Juan Pueblo' && SIC_code='5651'DB:business_master_new
loadtime:0.32419395446777 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Lorenzo' limit 1
loadtime:0.32424688339233 / seconds
Query Executed:select id FROM `nm` where city='San Lorenzo' && SIC_code='5651'DB:business_master_new
loadtime:0.32461786270142 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Miguel' limit 1
loadtime:0.32466888427734 / seconds
Query Executed:select id FROM `nm` where city='San Miguel' && SIC_code='5651'DB:business_master_new
loadtime:0.32525491714478 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Patricio' limit 1
loadtime:0.32530689239502 / seconds
Query Executed:select id FROM `nm` where city='San Patricio' && SIC_code='5651'DB:business_master_new
loadtime:0.3258798122406 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Rafael' limit 1
loadtime:0.32593083381653 / seconds
Query Executed:select id FROM `nm` where city='San Rafael' && SIC_code='5651'DB:business_master_new
loadtime:0.32635593414307 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Ysidro' limit 1
loadtime:0.3264148235321 / seconds
Query Executed:select id FROM `nm` where city='San Ysidro' && SIC_code='5651'DB:business_master_new
loadtime:0.32817101478577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandia Park' limit 1
loadtime:0.32822895050049 / seconds
Query Executed:select id FROM `nm` where city='Sandia Park' && SIC_code='5651'DB:business_master_new
loadtime:0.33000779151917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanostee' limit 1
loadtime:0.33006286621094 / seconds
Query Executed:select id FROM `nm` where city='Sanostee' && SIC_code='5651'DB:business_master_new
loadtime:0.33058500289917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Clara' limit 1
loadtime:0.33064198493958 / seconds
Query Executed:select id FROM `nm` where city='Santa Clara' && SIC_code='5651'DB:business_master_new
loadtime:0.33146095275879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Cruz' limit 1
loadtime:0.33151483535767 / seconds
Query Executed:select id FROM `nm` where city='Santa Cruz' && SIC_code='5651'DB:business_master_new
loadtime:0.33326482772827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Fe' limit 1
loadtime:0.33332180976868 / seconds
Query Executed:select id FROM `nm` where city='Santa Fe' && SIC_code='5651'DB:business_master_new
loadtime:0.33508896827698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Rosa' limit 1
loadtime:0.33519101142883 / seconds
Query Executed:select id FROM `nm` where city='Santa Rosa' && SIC_code='5651'DB:business_master_new
loadtime:0.33695983886719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Teresa' limit 1
loadtime:0.33703994750977 / seconds
Query Executed:select id FROM `nm` where city='Santa Teresa' && SIC_code='5651'DB:business_master_new
loadtime:0.33881592750549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santo Domingo Pb' limit 1
loadtime:0.33886981010437 / seconds
Query Executed:select id FROM `nm` where city='Santo Domingo Pb' && SIC_code='5651'DB:business_master_new
loadtime:0.33925199508667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santo Domingo Pueblo' limit 1
loadtime:0.33930897712708 / seconds
Query Executed:select id FROM `nm` where city='Santo Domingo Pueblo' && SIC_code='5651'DB:business_master_new
loadtime:0.33985495567322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sapello' limit 1
loadtime:0.33990693092346 / seconds
Query Executed:select id FROM `nm` where city='Sapello' && SIC_code='5651'DB:business_master_new
loadtime:0.34050989151001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seboyeta' limit 1
loadtime:0.34056282043457 / seconds
Query Executed:select id FROM `nm` where city='Seboyeta' && SIC_code='5651'DB:business_master_new
loadtime:0.34094190597534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedan' limit 1
loadtime:0.34099388122559 / seconds
Query Executed:select id FROM `nm` where city='Sedan' && SIC_code='5651'DB:business_master_new
loadtime:0.34146785736084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:0.34152698516846 / seconds
Query Executed:select id FROM `nm` where city='Seneca' && SIC_code='5651'DB:business_master_new
loadtime:0.34189391136169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Serafina' limit 1
loadtime:0.34194493293762 / seconds
Query Executed:select id FROM `nm` where city='Serafina' && SIC_code='5651'DB:business_master_new
loadtime:0.34237194061279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheep Springs' limit 1
loadtime:0.3424289226532 / seconds
Query Executed:select id FROM `nm` where city='Sheep Springs' && SIC_code='5651'DB:business_master_new
loadtime:0.34283685684204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shiprock' limit 1
loadtime:0.34288692474365 / seconds
Query Executed:select id FROM `nm` where city='Shiprock' && SIC_code='5651'DB:business_master_new
loadtime:0.34466600418091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver City' limit 1
loadtime:0.34471893310547 / seconds
Query Executed:select id FROM `nm` where city='Silver City' && SIC_code='5651'DB:business_master_new
loadtime:0.34650492668152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smith Lake' limit 1
loadtime:0.34657597541809 / seconds
Query Executed:select id FROM `nm` where city='Smith Lake' && SIC_code='5651'DB:business_master_new
loadtime:0.34697794914246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Socorro' limit 1
loadtime:0.34703493118286 / seconds
Query Executed:select id FROM `nm` where city='Socorro' && SIC_code='5651'DB:business_master_new
loadtime:0.34879088401794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Solano' limit 1
loadtime:0.34885787963867 / seconds
Query Executed:select id FROM `nm` where city='Solano' && SIC_code='5651'DB:business_master_new
loadtime:0.34925079345703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springer' limit 1
loadtime:0.34931182861328 / seconds
Query Executed:select id FROM `nm` where city='Springer' && SIC_code='5651'DB:business_master_new
loadtime:0.35106587409973 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Vrain' limit 1
loadtime:0.35111880302429 / seconds
Query Executed:select id FROM `nm` where city='St Vrain' && SIC_code='5651'DB:business_master_new
loadtime:0.3515088558197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:0.35156679153442 / seconds
Query Executed:select id FROM `nm` where city='Stanley' && SIC_code='5651'DB:business_master_new
loadtime:0.35223889350891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunland Park' limit 1
loadtime:0.35229301452637 / seconds
Query Executed:select id FROM `nm` where city='Sunland Park' && SIC_code='5651'DB:business_master_new
loadtime:0.35405683517456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunspot' limit 1
loadtime:0.35413098335266 / seconds
Query Executed:select id FROM `nm` where city='Sunspot' && SIC_code='5651'DB:business_master_new
loadtime:0.35458993911743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taiban' limit 1
loadtime:0.35464286804199 / seconds
Query Executed:select id FROM `nm` where city='Taiban' && SIC_code='5651'DB:business_master_new
loadtime:0.3550238609314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tajique' limit 1
loadtime:0.35507988929749 / seconds
Query Executed:select id FROM `nm` where city='Tajique' && SIC_code='5651'DB:business_master_new
loadtime:0.35547494888306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taos' limit 1
loadtime:0.3555269241333 / seconds
Query Executed:select id FROM `nm` where city='Taos' && SIC_code='5651'DB:business_master_new
loadtime:0.35729098320007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taos Ski Valley' limit 1
loadtime:0.35734796524048 / seconds
Query Executed:select id FROM `nm` where city='Taos Ski Valley' && SIC_code='5651'DB:business_master_new
loadtime:0.35847187042236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tatum' limit 1
loadtime:0.35852885246277 / seconds
Query Executed:select id FROM `nm` where city='Tatum' && SIC_code='5651'DB:business_master_new
loadtime:0.3602979183197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tererro' limit 1
loadtime:0.36035585403442 / seconds
Query Executed:select id FROM `nm` where city='Tererro' && SIC_code='5651'DB:business_master_new
loadtime:0.36077785491943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tesuque' limit 1
loadtime:0.36082983016968 / seconds
Query Executed:select id FROM `nm` where city='Tesuque' && SIC_code='5651'DB:business_master_new
loadtime:0.36185598373413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Texico' limit 1
loadtime:0.36191391944885 / seconds
Query Executed:select id FROM `nm` where city='Texico' && SIC_code='5651'DB:business_master_new
loadtime:0.36368489265442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thoreau' limit 1
loadtime:0.36373782157898 / seconds
Query Executed:select id FROM `nm` where city='Thoreau' && SIC_code='5651'DB:business_master_new
loadtime:0.36552000045776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tierra Amarilla' limit 1
loadtime:0.36557793617249 / seconds
Query Executed:select id FROM `nm` where city='Tierra Amarilla' && SIC_code='5651'DB:business_master_new
loadtime:0.36737394332886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tijeras' limit 1
loadtime:0.36742687225342 / seconds
Query Executed:select id FROM `nm` where city='Tijeras' && SIC_code='5651'DB:business_master_new
loadtime:0.36921691894531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timberon' limit 1
loadtime:0.36927795410156 / seconds
Query Executed:select id FROM `nm` where city='Timberon' && SIC_code='5651'DB:business_master_new
loadtime:0.37015390396118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tinnie' limit 1
loadtime:0.37021780014038 / seconds
Query Executed:select id FROM `nm` where city='Tinnie' && SIC_code='5651'DB:business_master_new
loadtime:0.37067294120789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tohatchi' limit 1
loadtime:0.37072491645813 / seconds
Query Executed:select id FROM `nm` where city='Tohatchi' && SIC_code='5651'DB:business_master_new
loadtime:0.3724799156189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tome' limit 1
loadtime:0.3725368976593 / seconds
Query Executed:select id FROM `nm` where city='Tome' && SIC_code='5651'DB:business_master_new
loadtime:0.37322282791138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Torreon' limit 1
loadtime:0.37327599525452 / seconds
Query Executed:select id FROM `nm` where city='Torreon' && SIC_code='5651'DB:business_master_new
loadtime:0.3738009929657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trampas' limit 1
loadtime:0.37385702133179 / seconds
Query Executed:select id FROM `nm` where city='Trampas' && SIC_code='5651'DB:business_master_new
loadtime:0.3742299079895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trementina' limit 1
loadtime:0.37428283691406 / seconds
Query Executed:select id FROM `nm` where city='Trementina' && SIC_code='5651'DB:business_master_new
loadtime:0.37469983100891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tres Piedras' limit 1
loadtime:0.37475681304932 / seconds
Query Executed:select id FROM `nm` where city='Tres Piedras' && SIC_code='5651'DB:business_master_new
loadtime:0.37536191940308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truchas' limit 1
loadtime:0.37541484832764 / seconds
Query Executed:select id FROM `nm` where city='Truchas' && SIC_code='5651'DB:business_master_new
loadtime:0.37604689598083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truth Or Cnsqncs' limit 1
loadtime:0.37610483169556 / seconds
Query Executed:select id FROM `nm` where city='Truth Or Cnsqncs' && SIC_code='5651'DB:business_master_new
loadtime:0.37654781341553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truth Or Consequences' limit 1
loadtime:0.3766028881073 / seconds
Query Executed:select id FROM `nm` where city='Truth Or Consequences' && SIC_code='5651'DB:business_master_new
loadtime:0.37837100028992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tucumcari' limit 1
loadtime:0.37844181060791 / seconds
Query Executed:select id FROM `nm` where city='Tucumcari' && SIC_code='5651'DB:business_master_new
loadtime:0.38020896911621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tularosa' limit 1
loadtime:0.38027095794678 / seconds
Query Executed:select id FROM `nm` where city='Tularosa' && SIC_code='5651'DB:business_master_new
loadtime:0.38202095031738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyrone' limit 1
loadtime:0.38207483291626 / seconds
Query Executed:select id FROM `nm` where city='Tyrone' && SIC_code='5651'DB:business_master_new
loadtime:0.38275980949402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ute Park' limit 1
loadtime:0.38281679153442 / seconds
Query Executed:select id FROM `nm` where city='Ute Park' && SIC_code='5651'DB:business_master_new
loadtime:0.38328099250793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vadito' limit 1
loadtime:0.38333487510681 / seconds
Query Executed:select id FROM `nm` where city='Vadito' && SIC_code='5651'DB:business_master_new
loadtime:0.38392090797424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vado' limit 1
loadtime:0.38397598266602 / seconds
Query Executed:select id FROM `nm` where city='Vado' && SIC_code='5651'DB:business_master_new
loadtime:0.38465881347656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valdez' limit 1
loadtime:0.38471078872681 / seconds
Query Executed:select id FROM `nm` where city='Valdez' && SIC_code='5651'DB:business_master_new
loadtime:0.38516783714294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vallecitos' limit 1
loadtime:0.38522696495056 / seconds
Query Executed:select id FROM `nm` where city='Vallecitos' && SIC_code='5651'DB:business_master_new
loadtime:0.3856828212738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valmora' limit 1
loadtime:0.38573789596558 / seconds
Query Executed:select id FROM `nm` where city='Valmora' && SIC_code='5651'DB:business_master_new
loadtime:0.38614988327026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vanderwagen' limit 1
loadtime:0.38621091842651 / seconds
Query Executed:select id FROM `nm` where city='Vanderwagen' && SIC_code='5651'DB:business_master_new
loadtime:0.38690400123596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vaughn' limit 1
loadtime:0.38695597648621 / seconds
Query Executed:select id FROM `nm` where city='Vaughn' && SIC_code='5651'DB:business_master_new
loadtime:0.38873696327209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Veguita' limit 1
loadtime:0.38879179954529 / seconds
Query Executed:select id FROM `nm` where city='Veguita' && SIC_code='5651'DB:business_master_new
loadtime:0.38947582244873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Velarde' limit 1
loadtime:0.38952898979187 / seconds
Query Executed:select id FROM `nm` where city='Velarde' && SIC_code='5651'DB:business_master_new
loadtime:0.39131093025208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villanueva' limit 1
loadtime:0.39136481285095 / seconds
Query Executed:select id FROM `nm` where city='Villanueva' && SIC_code='5651'DB:business_master_new
loadtime:0.39180183410645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wagon Mound' limit 1
loadtime:0.39186000823975 / seconds
Query Executed:select id FROM `nm` where city='Wagon Mound' && SIC_code='5651'DB:business_master_new
loadtime:0.39362597465515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterflow' limit 1
loadtime:0.39367890357971 / seconds
Query Executed:select id FROM `nm` where city='Waterflow' && SIC_code='5651'DB:business_master_new
loadtime:0.39546298980713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watrous' limit 1
loadtime:0.39552187919617 / seconds
Query Executed:select id FROM `nm` where city='Watrous' && SIC_code='5651'DB:business_master_new
loadtime:0.39731884002686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weed' limit 1
loadtime:0.39737582206726 / seconds
Query Executed:select id FROM `nm` where city='Weed' && SIC_code='5651'DB:business_master_new
loadtime:0.39913702011108 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Sands' limit 1
loadtime:0.39920496940613 / seconds
Query Executed:select id FROM `nm` where city='White Sands' && SIC_code='5651'DB:business_master_new
loadtime:0.40093278884888 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Sands Missile Range' limit 1
loadtime:0.40099191665649 / seconds
Query Executed:select id FROM `nm` where city='White Sands Missile Range' && SIC_code='5651'DB:business_master_new
loadtime:0.40274381637573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whites City' limit 1
loadtime:0.40280199050903 / seconds
Query Executed:select id FROM `nm` where city='Whites City' && SIC_code='5651'DB:business_master_new
loadtime:0.40455293655396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willard' limit 1
loadtime:0.40461182594299 / seconds
Query Executed:select id FROM `nm` where city='Willard' && SIC_code='5651'DB:business_master_new
loadtime:0.40636682510376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:0.4064199924469 / seconds
Query Executed:select id FROM `nm` where city='Williamsburg' && SIC_code='5651'DB:business_master_new
loadtime:0.40817379951477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winston' limit 1
loadtime:0.40823793411255 / seconds
Query Executed:select id FROM `nm` where city='Winston' && SIC_code='5651'DB:business_master_new
loadtime:0.40997290611267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yatahey' limit 1
loadtime:0.41003584861755 / seconds
Query Executed:select id FROM `nm` where city='Yatahey' && SIC_code='5651'DB:business_master_new
loadtime:0.411780834198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yeso' limit 1
loadtime:0.41183400154114 / seconds
Query Executed:select id FROM `nm` where city='Yeso' && SIC_code='5651'DB:business_master_new
loadtime:0.41229200363159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Youngsville' limit 1
loadtime:0.4123477935791 / seconds
Query Executed:select id FROM `nm` where city='Youngsville' && SIC_code='5651'DB:business_master_new
loadtime:0.41272592544556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zuni' limit 1
loadtime:0.4127779006958 / seconds
Query Executed:select id FROM `nm` where city='Zuni' && SIC_code='5651'DB:business_master_new
loadtime:0.41451501846313 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.41467499732971 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.41510081291199 / seconds
Operation template executed (chunk cache operation)
loadtime:0.41527390480042 / seconds
template override:Default
loadtime:0.41531896591187 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:0.41668581962585 / seconds
Template Constructed, Array Rows:49
loadtime:0.41722893714905 / seconds
TOTAL EXECUTION TIME: 0.41678
loadtime:0.41840386390686 / 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] => family-clothing-stores [stateURLid] => new-mexico )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:0.41841387748718
TOTAL KEY ARRAYS: 69