Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:7.0095062255859E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00046110153198242 / seconds
host not found setting manual db connection
loadtime:0.00085210800170898 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0010750293731689 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0012850761413574 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0013411045074463 / seconds
zipcode:
loadtime:0.0013589859008789 / seconds
Query Executed:select * from search_referrer where page_hash='888a6a2ad7aa4153ea04f78da4ca52c4' limit 10 DB:ezrox_toadli
loadtime:0.0015571117401123 / seconds
Operation header executed (non global)
loadtime:0.0015759468078613 / seconds
Operation leaderboard executed (non global)
loadtime:0.0016160011291504 / seconds
Operation square executed (non global)
loadtime:0.0016300678253174 / seconds
Operation square_bottom executed (non global)
loadtime:0.0016429424285889 / seconds
Operation smallsquare executed (non global)
loadtime:0.001655101776123 / seconds
Operation headeradright executed (non global)
loadtime:0.0016660690307617 / seconds
Operation google_analytics executed (non global)
loadtime:0.0016770362854004 / seconds
Operation topstories executed (non global)
loadtime:0.0016870498657227 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0016980171203613 / seconds
Operation memberbuscount executed (non global)
loadtime:0.001708984375 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0019171237945557 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0020670890808105 / seconds
Operation categories executed (global stored into APC)
loadtime:0.002108097076416 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0021569728851318 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0021829605102539 / seconds
Template key: archive_menu pushed
loadtime:0.0021870136260986 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0021929740905762 / seconds
Template key: get_gravatar pushed
loadtime:0.0021970272064209 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0022010803222656 / seconds
*10)-10)+1 | start:0
loadtime:0.0022220611572266 / seconds
Query loaded from cache:select * from categories where cat_URLid='eating-places'
loadtime:0.0022590160369873 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-mexico'
loadtime:0.0022830963134766 / seconds
DB connected to localhost business_master_new
loadtime:0.0025081634521484 / seconds
Query Executed:select * from `nm_catmap` where sic='5812' order by city ascDB:business_master_new
loadtime:0.084386110305786 / seconds
Query stored in cache : _QUERY_www.toadli.com33e7472c1ac63b2b1d9cec0531629d4b
loadtime:0.0854811668396 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-mexico'
loadtime:0.085538148880005 / seconds
Query Executed:select sum(totalcount) as totalsum from `nm_catmap` where sic='5812'DB:business_master_new
loadtime:0.088364124298096 / seconds
Query stored in cache : _QUERY_www.toadli.comd21cb6ecaa4b1d0fcf877686d212e30a
loadtime:0.088392019271851 / seconds
369 / 11
loadtime:0.088452100753784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abiquiu' limit 1
loadtime:0.088526010513306 / seconds
Query Executed:select id FROM `nm` where city='Abiquiu' && SIC_code='5812'DB:business_master_new
loadtime:0.11537909507751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alameda' limit 1
loadtime:0.11545205116272 / seconds
Query Executed:select id FROM `nm` where city='Alameda' && SIC_code='5812'DB:business_master_new
loadtime:0.11646008491516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alamogordo' limit 1
loadtime:0.11651110649109 / seconds
Query Executed:select id FROM `nm` where city='Alamogordo' && SIC_code='5812'DB:business_master_new
loadtime:0.14852404594421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albuquerque' limit 1
loadtime:0.14866995811462 / seconds
Query Executed:select id FROM `nm` where city='Albuquerque' && SIC_code='5812'DB:business_master_new
loadtime:0.87857508659363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alcalde' limit 1
loadtime:0.8796010017395 / seconds
Query Executed:select id FROM `nm` where city='Alcalde' && SIC_code='5812'DB:business_master_new
loadtime:0.88221716880798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Algodones' limit 1
loadtime:0.88229393959045 / seconds
Query Executed:select id FROM `nm` where city='Algodones' && SIC_code='5812'DB:business_master_new
loadtime:0.88666701316833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alto' limit 1
loadtime:0.8867290019989 / seconds
Query Executed:select id FROM `nm` where city='Alto' && SIC_code='5812'DB:business_master_new
loadtime:0.88858795166016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amalia' limit 1
loadtime:0.8886411190033 / seconds
Query Executed:select id FROM `nm` where city='Amalia' && SIC_code='5812'DB:business_master_new
loadtime:0.88897705078125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amistad' limit 1
loadtime:0.88900804519653 / seconds
Query Executed:select id FROM `nm` where city='Amistad' && SIC_code='5812'DB:business_master_new
loadtime:0.8893711566925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Angel Fire' limit 1
loadtime:0.88941216468811 / seconds
Query Executed:select id FROM `nm` where city='Angel Fire' && SIC_code='5812'DB:business_master_new
loadtime:0.89141011238098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Animas' limit 1
loadtime:0.89145708084106 / seconds
Query Executed:select id FROM `nm` where city='Animas' && SIC_code='5812'DB:business_master_new
loadtime:0.89225196838379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anthony' limit 1
loadtime:0.89230298995972 / seconds
Query Executed:select id FROM `nm` where city='Anthony' && SIC_code='5812'DB:business_master_new
loadtime:0.89412117004395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anton Chico' limit 1
loadtime:0.89418601989746 / seconds
Query Executed:select id FROM `nm` where city='Anton Chico' && SIC_code='5812'DB:business_master_new
loadtime:0.89476299285889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aragon' limit 1
loadtime:0.89481616020203 / seconds
Query Executed:select id FROM `nm` where city='Aragon' && SIC_code='5812'DB:business_master_new
loadtime:0.89517402648926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arenas Valley' limit 1
loadtime:0.8952100276947 / seconds
Query Executed:select id FROM `nm` where city='Arenas Valley' && SIC_code='5812'DB:business_master_new
loadtime:0.89605808258057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arrey' limit 1
loadtime:0.89610695838928 / seconds
Query Executed:select id FROM `nm` where city='Arrey' && SIC_code='5812'DB:business_master_new
loadtime:0.89687204360962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arroyo Hondo' limit 1
loadtime:0.89692807197571 / seconds
Query Executed:select id FROM `nm` where city='Arroyo Hondo' && SIC_code='5812'DB:business_master_new
loadtime:0.89774394035339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arroyo Seco' limit 1
loadtime:0.89779710769653 / seconds
Query Executed:select id FROM `nm` where city='Arroyo Seco' && SIC_code='5812'DB:business_master_new
loadtime:0.89943599700928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Artesia' limit 1
loadtime:0.89950203895569 / seconds
Query Executed:select id FROM `nm` where city='Artesia' && SIC_code='5812'DB:business_master_new
loadtime:0.90194201469421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aztec' limit 1
loadtime:0.90200304985046 / seconds
Query Executed:select id FROM `nm` where city='Aztec' && SIC_code='5812'DB:business_master_new
loadtime:0.9042820930481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bard' limit 1
loadtime:0.90434908866882 / seconds
Query Executed:select id FROM `nm` where city='Bard' && SIC_code='5812'DB:business_master_new
loadtime:0.90462303161621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayard' limit 1
loadtime:0.90465307235718 / seconds
Query Executed:select id FROM `nm` where city='Bayard' && SIC_code='5812'DB:business_master_new
loadtime:0.90702414512634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belen' limit 1
loadtime:0.90708303451538 / seconds
Query Executed:select id FROM `nm` where city='Belen' && SIC_code='5812'DB:business_master_new
loadtime:0.90982913970947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bell Ranch' limit 1
loadtime:0.90990710258484 / seconds
Query Executed:select id FROM `nm` where city='Bell Ranch' && SIC_code='5812'DB:business_master_new
loadtime:0.91017508506775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bent' limit 1
loadtime:0.91022300720215 / seconds
Query Executed:select id FROM `nm` where city='Bent' && SIC_code='5812'DB:business_master_new
loadtime:0.91058301925659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berino' limit 1
loadtime:0.91061997413635 / seconds
Query Executed:select id FROM `nm` where city='Berino' && SIC_code='5812'DB:business_master_new
loadtime:0.910973072052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bernalillo' limit 1
loadtime:0.91100215911865 / seconds
Query Executed:select id FROM `nm` where city='Bernalillo' && SIC_code='5812'DB:business_master_new
loadtime:0.91321516036987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bingham' limit 1
loadtime:0.91328406333923 / seconds
Query Executed:select id FROM `nm` where city='Bingham' && SIC_code='5812'DB:business_master_new
loadtime:0.91358709335327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanco' limit 1
loadtime:0.91361594200134 / seconds
Query Executed:select id FROM `nm` where city='Blanco' && SIC_code='5812'DB:business_master_new
loadtime:0.91495203971863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield' limit 1
loadtime:0.91500616073608 / seconds
Query Executed:select id FROM `nm` where city='Bloomfield' && SIC_code='5812'DB:business_master_new
loadtime:0.91722106933594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluewater' limit 1
loadtime:0.91727614402771 / seconds
Query Executed:select id FROM `nm` where city='Bluewater' && SIC_code='5812'DB:business_master_new
loadtime:0.91778802871704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bosque' limit 1
loadtime:0.91785311698914 / seconds
Query Executed:select id FROM `nm` where city='Bosque' && SIC_code='5812'DB:business_master_new
loadtime:0.91834712028503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bosque Farms' limit 1
loadtime:0.91841697692871 / seconds
Query Executed:select id FROM `nm` where city='Bosque Farms' && SIC_code='5812'DB:business_master_new
loadtime:0.9203360080719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brimhall' limit 1
loadtime:0.92037796974182 / seconds
Query Executed:select id FROM `nm` where city='Brimhall' && SIC_code='5812'DB:business_master_new
loadtime:0.92069506645203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadview' limit 1
loadtime:0.92076206207275 / seconds
Query Executed:select id FROM `nm` where city='Broadview' && SIC_code='5812'DB:business_master_new
loadtime:0.92136716842651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckhorn' limit 1
loadtime:0.92140007019043 / seconds
Query Executed:select id FROM `nm` where city='Buckhorn' && SIC_code='5812'DB:business_master_new
loadtime:0.9217541217804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buena Vista' limit 1
loadtime:0.92180299758911 / seconds
Query Executed:select id FROM `nm` where city='Buena Vista' && SIC_code='5812'DB:business_master_new
loadtime:0.92272400856018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caballo' limit 1
loadtime:0.92276501655579 / seconds
Query Executed:select id FROM `nm` where city='Caballo' && SIC_code='5812'DB:business_master_new
loadtime:0.92325401306152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canjilon' limit 1
loadtime:0.92329907417297 / seconds
Query Executed:select id FROM `nm` where city='Canjilon' && SIC_code='5812'DB:business_master_new
loadtime:0.92369914054871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cannon Afb' limit 1
loadtime:0.92372393608093 / seconds
Query Executed:select id FROM `nm` where city='Cannon Afb' && SIC_code='5812'DB:business_master_new
loadtime:0.92460203170776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canoncito' limit 1
loadtime:0.92465710639954 / seconds
Query Executed:select id FROM `nm` where city='Canoncito' && SIC_code='5812'DB:business_master_new
loadtime:0.92499113082886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canones' limit 1
loadtime:0.92503094673157 / seconds
Query Executed:select id FROM `nm` where city='Canones' && SIC_code='5812'DB:business_master_new
loadtime:0.92535305023193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capitan' limit 1
loadtime:0.92537808418274 / seconds
Query Executed:select id FROM `nm` where city='Capitan' && SIC_code='5812'DB:business_master_new
loadtime:0.92722010612488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caprock' limit 1
loadtime:0.92727112770081 / seconds
Query Executed:select id FROM `nm` where city='Caprock' && SIC_code='5812'DB:business_master_new
loadtime:0.92788195610046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capulin' limit 1
loadtime:0.92790913581848 / seconds
Query Executed:select id FROM `nm` where city='Capulin' && SIC_code='5812'DB:business_master_new
loadtime:0.92826509475708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlsbad' limit 1
loadtime:0.92830204963684 / seconds
Query Executed:select id FROM `nm` where city='Carlsbad' && SIC_code='5812'DB:business_master_new
loadtime:0.93153405189514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrizozo' limit 1
loadtime:0.93161916732788 / seconds
Query Executed:select id FROM `nm` where city='Carrizozo' && SIC_code='5812'DB:business_master_new
loadtime:0.9334659576416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson' limit 1
loadtime:0.93352913856506 / seconds
Query Executed:select id FROM `nm` where city='Carson' && SIC_code='5812'DB:business_master_new
loadtime:0.93391108512878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casa Blanca' limit 1
loadtime:0.93395900726318 / seconds
Query Executed:select id FROM `nm` where city='Casa Blanca' && SIC_code='5812'DB:business_master_new
loadtime:0.93449211120605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Causey' limit 1
loadtime:0.93454813957214 / seconds
Query Executed:select id FROM `nm` where city='Causey' && SIC_code='5812'DB:business_master_new
loadtime:0.93490195274353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cebolla' limit 1
loadtime:0.93494009971619 / seconds
Query Executed:select id FROM `nm` where city='Cebolla' && SIC_code='5812'DB:business_master_new
loadtime:0.93524813652039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Crest' limit 1
loadtime:0.93529105186462 / seconds
Query Executed:select id FROM `nm` where city='Cedar Crest' && SIC_code='5812'DB:business_master_new
loadtime:0.93717193603516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central' limit 1
loadtime:0.93722105026245 / seconds
Query Executed:select id FROM `nm` where city='Central' && SIC_code='5812'DB:business_master_new
loadtime:0.93756794929504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cerrillos' limit 1
loadtime:0.93760895729065 / seconds
Query Executed:select id FROM `nm` where city='Cerrillos' && SIC_code='5812'DB:business_master_new
loadtime:0.94002294540405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cerro' limit 1
loadtime:0.94008898735046 / seconds
Query Executed:select id FROM `nm` where city='Cerro' && SIC_code='5812'DB:business_master_new
loadtime:0.94050407409668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chacon' limit 1
loadtime:0.94054293632507 / seconds
Query Executed:select id FROM `nm` where city='Chacon' && SIC_code='5812'DB:business_master_new
loadtime:0.94087696075439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chama' limit 1
loadtime:0.94093608856201 / seconds
Query Executed:select id FROM `nm` where city='Chama' && SIC_code='5812'DB:business_master_new
loadtime:0.94288802146912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chamberino' limit 1
loadtime:0.94294309616089 / seconds
Query Executed:select id FROM `nm` where city='Chamberino' && SIC_code='5812'DB:business_master_new
loadtime:0.94330906867981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chamisal' limit 1
loadtime:0.94333696365356 / seconds
Query Executed:select id FROM `nm` where city='Chamisal' && SIC_code='5812'DB:business_master_new
loadtime:0.94422197341919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chaparral' limit 1
loadtime:0.94425916671753 / seconds
Query Executed:select id FROM `nm` where city='Chaparral' && SIC_code='5812'DB:business_master_new
loadtime:0.94600701332092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chimayo' limit 1
loadtime:0.94605398178101 / seconds
Query Executed:select id FROM `nm` where city='Chimayo' && SIC_code='5812'DB:business_master_new
loadtime:0.94775795936584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Church Rock' limit 1
loadtime:0.94782304763794 / seconds
Query Executed:select id FROM `nm` where city='Church Rock' && SIC_code='5812'DB:business_master_new
loadtime:0.94828414916992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cimarron' limit 1
loadtime:0.94834804534912 / seconds
Query Executed:select id FROM `nm` where city='Cimarron' && SIC_code='5812'DB:business_master_new
loadtime:0.95013308525085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claunch' limit 1
loadtime:0.95017409324646 / seconds
Query Executed:select id FROM `nm` where city='Claunch' && SIC_code='5812'DB:business_master_new
loadtime:0.9504930973053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clayton' limit 1
loadtime:0.95054411888123 / seconds
Query Executed:select id FROM `nm` where city='Clayton' && SIC_code='5812'DB:business_master_new
loadtime:0.95248293876648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.95254302024841 / seconds
Query Executed:select id FROM `nm` where city='Cleveland' && SIC_code='5812'DB:business_master_new
loadtime:0.95298314094543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cliff' limit 1
loadtime:0.95304298400879 / seconds
Query Executed:select id FROM `nm` where city='Cliff' && SIC_code='5812'DB:business_master_new
loadtime:0.95365715026855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clines Corners' limit 1
loadtime:0.95371413230896 / seconds
Query Executed:select id FROM `nm` where city='Clines Corners' && SIC_code='5812'DB:business_master_new
loadtime:0.95406293869019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cloudcroft' limit 1
loadtime:0.95410203933716 / seconds
Query Executed:select id FROM `nm` where city='Cloudcroft' && SIC_code='5812'DB:business_master_new
loadtime:0.95603013038635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clovis' limit 1
loadtime:0.95607995986938 / seconds
Query Executed:select id FROM `nm` where city='Clovis' && SIC_code='5812'DB:business_master_new
loadtime:0.95971894264221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cochiti Lake' limit 1
loadtime:0.9598400592804 / seconds
Query Executed:select id FROM `nm` where city='Cochiti Lake' && SIC_code='5812'DB:business_master_new
loadtime:0.96024012565613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cochiti Pueblo' limit 1
loadtime:0.96027898788452 / seconds
Query Executed:select id FROM `nm` where city='Cochiti Pueblo' && SIC_code='5812'DB:business_master_new
loadtime:0.96064496040344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:0.96068000793457 / seconds
Query Executed:select id FROM `nm` where city='Columbus' && SIC_code='5812'DB:business_master_new
loadtime:0.96167016029358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conchas Dam' limit 1
loadtime:0.96171402931213 / seconds
Query Executed:select id FROM `nm` where city='Conchas Dam' && SIC_code='5812'DB:business_master_new
loadtime:0.96267795562744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Continental Div' limit 1
loadtime:0.96272611618042 / seconds
Query Executed:select id FROM `nm` where city='Continental Div' && SIC_code='5812'DB:business_master_new
loadtime:0.96297597885132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Continental Divide' limit 1
loadtime:0.96300196647644 / seconds
Query Executed:select id FROM `nm` where city='Continental Divide' && SIC_code='5812'DB:business_master_new
loadtime:0.96338510513306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cordova' limit 1
loadtime:0.96342301368713 / seconds
Query Executed:select id FROM `nm` where city='Cordova' && SIC_code='5812'DB:business_master_new
loadtime:0.96383309364319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corona' limit 1
loadtime:0.96386814117432 / seconds
Query Executed:select id FROM `nm` where city='Corona' && SIC_code='5812'DB:business_master_new
loadtime:0.96502494812012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corrales' limit 1
loadtime:0.9650890827179 / seconds
Query Executed:select id FROM `nm` where city='Corrales' && SIC_code='5812'DB:business_master_new
loadtime:0.96712398529053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Costilla' limit 1
loadtime:0.9671790599823 / seconds
Query Executed:select id FROM `nm` where city='Costilla' && SIC_code='5812'DB:business_master_new
loadtime:0.96765208244324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Counselor' limit 1
loadtime:0.96768498420715 / seconds
Query Executed:select id FROM `nm` where city='Counselor' && SIC_code='5812'DB:business_master_new
loadtime:0.9680700302124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coyote' limit 1
loadtime:0.96810698509216 / seconds
Query Executed:select id FROM `nm` where city='Coyote' && SIC_code='5812'DB:business_master_new
loadtime:0.96905112266541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crossroads' limit 1
loadtime:0.96908617019653 / seconds
Query Executed:select id FROM `nm` where city='Crossroads' && SIC_code='5812'DB:business_master_new
loadtime:0.96937012672424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crownpoint' limit 1
loadtime:0.96940898895264 / seconds
Query Executed:select id FROM `nm` where city='Crownpoint' && SIC_code='5812'DB:business_master_new
loadtime:0.97110915184021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuba' limit 1
loadtime:0.97114109992981 / seconds
Query Executed:select id FROM `nm` where city='Cuba' && SIC_code='5812'DB:business_master_new
loadtime:0.97308301925659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cubero' limit 1
loadtime:0.97313404083252 / seconds
Query Executed:select id FROM `nm` where city='Cubero' && SIC_code='5812'DB:business_master_new
loadtime:0.97355508804321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuchillo' limit 1
loadtime:0.97359204292297 / seconds
Query Executed:select id FROM `nm` where city='Cuchillo' && SIC_code='5812'DB:business_master_new
loadtime:0.97388005256653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuervo' limit 1
loadtime:0.97390508651733 / seconds
Query Executed:select id FROM `nm` where city='Cuervo' && SIC_code='5812'DB:business_master_new
loadtime:0.97422814369202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Datil' limit 1
loadtime:0.97426509857178 / seconds
Query Executed:select id FROM `nm` where city='Datil' && SIC_code='5812'DB:business_master_new
loadtime:0.9764621257782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deming' limit 1
loadtime:0.97652912139893 / seconds
Query Executed:select id FROM `nm` where city='Deming' && SIC_code='5812'DB:business_master_new
loadtime:0.97906112670898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derry' limit 1
loadtime:0.97912001609802 / seconds
Query Executed:select id FROM `nm` where city='Derry' && SIC_code='5812'DB:business_master_new
loadtime:0.97943806648254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Des Moines' limit 1
loadtime:0.97947597503662 / seconds
Query Executed:select id FROM `nm` where city='Des Moines' && SIC_code='5812'DB:business_master_new
loadtime:0.98014307022095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dexter' limit 1
loadtime:0.98018407821655 / seconds
Query Executed:select id FROM `nm` where city='Dexter' && SIC_code='5812'DB:business_master_new
loadtime:0.98194193840027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dixon' limit 1
loadtime:0.98197507858276 / seconds
Query Executed:select id FROM `nm` where city='Dixon' && SIC_code='5812'DB:business_master_new
loadtime:0.98262715339661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dona Ana' limit 1
loadtime:0.98266410827637 / seconds
Query Executed:select id FROM `nm` where city='Dona Ana' && SIC_code='5812'DB:business_master_new
loadtime:0.98365712165833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dora' limit 1
loadtime:0.98368406295776 / seconds
Query Executed:select id FROM `nm` where city='Dora' && SIC_code='5812'DB:business_master_new
loadtime:0.98457312583923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dulce' limit 1
loadtime:0.98461198806763 / seconds
Query Executed:select id FROM `nm` where city='Dulce' && SIC_code='5812'DB:business_master_new
loadtime:0.98637509346008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duran' limit 1
loadtime:0.98641896247864 / seconds
Query Executed:select id FROM `nm` where city='Duran' && SIC_code='5812'DB:business_master_new
loadtime:0.98679208755493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Nest' limit 1
loadtime:0.98681712150574 / seconds
Query Executed:select id FROM `nm` where city='Eagle Nest' && SIC_code='5812'DB:business_master_new
loadtime:0.98819613456726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewood' limit 1
loadtime:0.98825812339783 / seconds
Query Executed:select id FROM `nm` where city='Edgewood' && SIC_code='5812'DB:business_master_new
loadtime:0.9902491569519 / seconds
Query loaded from cache:select * from geodata_geocity where city='El Prado' limit 1
loadtime:0.99031114578247 / seconds
Query Executed:select id FROM `nm` where city='El Prado' && SIC_code='5812'DB:business_master_new
loadtime:0.99216604232788 / seconds
Query loaded from cache:select * from geodata_geocity where city='El Rito' limit 1
loadtime:0.99221515655518 / seconds
Query Executed:select id FROM `nm` where city='El Rito' && SIC_code='5812'DB:business_master_new
loadtime:0.99291014671326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elephant Butte' limit 1
loadtime:0.99295711517334 / seconds
Query Executed:select id FROM `nm` where city='Elephant Butte' && SIC_code='5812'DB:business_master_new
loadtime:0.99470114707947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elida' limit 1
loadtime:0.99474716186523 / seconds
Query Executed:select id FROM `nm` where city='Elida' && SIC_code='5812'DB:business_master_new
loadtime:0.99550199508667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Embudo' limit 1
loadtime:0.99555897712708 / seconds
Query Executed:select id FROM `nm` where city='Embudo' && SIC_code='5812'DB:business_master_new
loadtime:0.99612903594971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Encino' limit 1
loadtime:0.99617505073547 / seconds
Query Executed:select id FROM `nm` where city='Encino' && SIC_code='5812'DB:business_master_new
loadtime:0.99660801887512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Espanola' limit 1
loadtime:0.99663496017456 / seconds
Query Executed:select id FROM `nm` where city='Espanola' && SIC_code='5812'DB:business_master_new
loadtime:0.99939608573914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estancia' limit 1
loadtime:0.9994740486145 / seconds
Query Executed:select id FROM `nm` where city='Estancia' && SIC_code='5812'DB:business_master_new
loadtime:1.0015420913696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eunice' limit 1
loadtime:1.0015950202942 / seconds
Query Executed:select id FROM `nm` where city='Eunice' && SIC_code='5812'DB:business_master_new
loadtime:1.0034930706024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairacres' limit 1
loadtime:1.0035469532013 / seconds
Query Executed:select id FROM `nm` where city='Fairacres' && SIC_code='5812'DB:business_master_new
loadtime:1.0043909549713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:1.0044240951538 / seconds
Query Executed:select id FROM `nm` where city='Fairview' && SIC_code='5812'DB:business_master_new
loadtime:1.0047149658203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:1.0047540664673 / seconds
Query Executed:select id FROM `nm` where city='Farmington' && SIC_code='5812'DB:business_master_new
loadtime:1.0096399784088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faywood' limit 1
loadtime:1.0097930431366 / seconds
Query Executed:select id FROM `nm` where city='Faywood' && SIC_code='5812'DB:business_master_new
loadtime:1.0101590156555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fence Lake' limit 1
loadtime:1.0102000236511 / seconds
Query Executed:select id FROM `nm` where city='Fence Lake' && SIC_code='5812'DB:business_master_new
loadtime:1.0109069347382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flora Vista' limit 1
loadtime:1.0109550952911 / seconds
Query Executed:select id FROM `nm` where city='Flora Vista' && SIC_code='5812'DB:business_master_new
loadtime:1.0128481388092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Floyd' limit 1
loadtime:1.0129060745239 / seconds
Query Executed:select id FROM `nm` where city='Floyd' && SIC_code='5812'DB:business_master_new
loadtime:1.0135469436646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flying H' limit 1
loadtime:1.0135819911957 / seconds
Query Executed:select id FROM `nm` where city='Flying H' && SIC_code='5812'DB:business_master_new
loadtime:1.0138630867004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Folsom' limit 1
loadtime:1.013904094696 / seconds
Query Executed:select id FROM `nm` where city='Folsom' && SIC_code='5812'DB:business_master_new
loadtime:1.0144400596619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Bayard' limit 1
loadtime:1.0144829750061 / seconds
Query Executed:select id FROM `nm` where city='Fort Bayard' && SIC_code='5812'DB:business_master_new
loadtime:1.0148401260376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Stanton' limit 1
loadtime:1.014878988266 / seconds
Query Executed:select id FROM `nm` where city='Fort Stanton' && SIC_code='5812'DB:business_master_new
loadtime:1.0153110027313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Sumner' limit 1
loadtime:1.0153460502625 / seconds
Query Executed:select id FROM `nm` where city='Fort Sumner' && SIC_code='5812'DB:business_master_new
loadtime:1.0173411369324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Wingate' limit 1
loadtime:1.0174000263214 / seconds
Query Executed:select id FROM `nm` where city='Fort Wingate' && SIC_code='5812'DB:business_master_new
loadtime:1.0180220603943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitland' limit 1
loadtime:1.0180649757385 / seconds
Query Executed:select id FROM `nm` where city='Fruitland' && SIC_code='5812'DB:business_master_new
loadtime:1.0189030170441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gallina' limit 1
loadtime:1.0189430713654 / seconds
Query Executed:select id FROM `nm` where city='Gallina' && SIC_code='5812'DB:business_master_new
loadtime:1.0194001197815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gallup' limit 1
loadtime:1.0194571018219 / seconds
Query Executed:select id FROM `nm` where city='Gallup' && SIC_code='5812'DB:business_master_new
loadtime:1.0233409404755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gamerco' limit 1
loadtime:1.0234701633453 / seconds
Query Executed:select id FROM `nm` where city='Gamerco' && SIC_code='5812'DB:business_master_new
loadtime:1.0240581035614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garfield' limit 1
loadtime:1.0241191387177 / seconds
Query Executed:select id FROM `nm` where city='Garfield' && SIC_code='5812'DB:business_master_new
loadtime:1.024600982666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garita' limit 1
loadtime:1.0246360301971 / seconds
Query Executed:select id FROM `nm` where city='Garita' && SIC_code='5812'DB:business_master_new
loadtime:1.0248939990997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gila' limit 1
loadtime:1.0249321460724 / seconds
Query Executed:select id FROM `nm` where city='Gila' && SIC_code='5812'DB:business_master_new
loadtime:1.0259039402008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladstone' limit 1
loadtime:1.0259461402893 / seconds
Query Executed:select id FROM `nm` where city='Gladstone' && SIC_code='5812'DB:business_master_new
loadtime:1.0262529850006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glencoe' limit 1
loadtime:1.0262989997864 / seconds
Query Executed:select id FROM `nm` where city='Glencoe' && SIC_code='5812'DB:business_master_new
loadtime:1.0266489982605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:1.0266849994659 / seconds
Query Executed:select id FROM `nm` where city='Glenwood' && SIC_code='5812'DB:business_master_new
loadtime:1.0274610519409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glorieta' limit 1
loadtime:1.0275161266327 / seconds
Query Executed:select id FROM `nm` where city='Glorieta' && SIC_code='5812'DB:business_master_new
loadtime:1.0281929969788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grady' limit 1
loadtime:1.0282509326935 / seconds
Query Executed:select id FROM `nm` where city='Grady' && SIC_code='5812'DB:business_master_new
loadtime:1.0287899971008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grants' limit 1
loadtime:1.028825044632 / seconds
Query Executed:select id FROM `nm` where city='Grants' && SIC_code='5812'DB:business_master_new
loadtime:1.0312640666962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grenville' limit 1
loadtime:1.0313370227814 / seconds
Query Executed:select id FROM `nm` where city='Grenville' && SIC_code='5812'DB:business_master_new
loadtime:1.0317180156708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guadalupita' limit 1
loadtime:1.0317561626434 / seconds
Query Executed:select id FROM `nm` where city='Guadalupita' && SIC_code='5812'DB:business_master_new
loadtime:1.0321900844574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hachita' limit 1
loadtime:1.0322251319885 / seconds
Query Executed:select id FROM `nm` where city='Hachita' && SIC_code='5812'DB:business_master_new
loadtime:1.0326330661774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hagerman' limit 1
loadtime:1.0326800346375 / seconds
Query Executed:select id FROM `nm` where city='Hagerman' && SIC_code='5812'DB:business_master_new
loadtime:1.034038066864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:1.0340931415558 / seconds
Query Executed:select id FROM `nm` where city='Hanover' && SIC_code='5812'DB:business_master_new
loadtime:1.0346050262451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatch' limit 1
loadtime:1.0346620082855 / seconds
Query Executed:select id FROM `nm` where city='Hatch' && SIC_code='5812'DB:business_master_new
loadtime:1.0367701053619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hernandez' limit 1
loadtime:1.0368330478668 / seconds
Query Executed:select id FROM `nm` where city='Hernandez' && SIC_code='5812'DB:business_master_new
loadtime:1.037425994873 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Rls Mtn Pk' limit 1
loadtime:1.0374829769135 / seconds
Query Executed:select id FROM `nm` where city='High Rls Mtn Pk' && SIC_code='5812'DB:business_master_new
loadtime:1.0377621650696 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Rolls Mountain Park' limit 1
loadtime:1.0378119945526 / seconds
Query Executed:select id FROM `nm` where city='High Rolls Mountain Park' && SIC_code='5812'DB:business_master_new
loadtime:1.0388751029968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:1.0389201641083 / seconds
Query Executed:select id FROM `nm` where city='Hillsboro' && SIC_code='5812'DB:business_master_new
loadtime:1.0395030975342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hobbs' limit 1
loadtime:1.0395591259003 / seconds
Query Executed:select id FROM `nm` where city='Hobbs' && SIC_code='5812'DB:business_master_new
loadtime:1.0432751178741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holloman Afb' limit 1
loadtime:1.0433740615845 / seconds
Query Executed:select id FROM `nm` where city='Holloman Afb' && SIC_code='5812'DB:business_master_new
loadtime:1.043986082077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holloman Air Force Base' limit 1
loadtime:1.0440390110016 / seconds
Query Executed:select id FROM `nm` where city='Holloman Air Force Base' && SIC_code='5812'DB:business_master_new
loadtime:1.0451121330261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holman' limit 1
loadtime:1.045156955719 / seconds
Query Executed:select id FROM `nm` where city='Holman' && SIC_code='5812'DB:business_master_new
loadtime:1.0455591678619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hondo' limit 1
loadtime:1.0456140041351 / seconds
Query Executed:select id FROM `nm` where city='Hondo' && SIC_code='5812'DB:business_master_new
loadtime:1.0463969707489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hope' limit 1
loadtime:1.0464429855347 / seconds
Query Executed:select id FROM `nm` where city='Hope' && SIC_code='5812'DB:business_master_new
loadtime:1.0469210147858 / seconds
Query loaded from cache:select * from geodata_geocity where city='House' limit 1
loadtime:1.0469620227814 / seconds
Query Executed:select id FROM `nm` where city='House' && SIC_code='5812'DB:business_master_new
loadtime:1.0474579334259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:1.0475120544434 / seconds
Query Executed:select id FROM `nm` where city='Hurley' && SIC_code='5812'DB:business_master_new
loadtime:1.0482561588287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isleta' limit 1
loadtime:1.0483040809631 / seconds
Query Executed:select id FROM `nm` where city='Isleta' && SIC_code='5812'DB:business_master_new
loadtime:1.0492119789124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jal' limit 1
loadtime:1.0492689609528 / seconds
Query Executed:select id FROM `nm` where city='Jal' && SIC_code='5812'DB:business_master_new
loadtime:1.0511960983276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:1.0512411594391 / seconds
Query Executed:select id FROM `nm` where city='Jamestown' && SIC_code='5812'DB:business_master_new
loadtime:1.0516741275787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jarales' limit 1
loadtime:1.0517289638519 / seconds
Query Executed:select id FROM `nm` where city='Jarales' && SIC_code='5812'DB:business_master_new
loadtime:1.0526211261749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jemez Pueblo' limit 1
loadtime:1.0526571273804 / seconds
Query Executed:select id FROM `nm` where city='Jemez Pueblo' && SIC_code='5812'DB:business_master_new
loadtime:1.0536949634552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jemez Springs' limit 1
loadtime:1.053750038147 / seconds
Query Executed:select id FROM `nm` where city='Jemez Springs' && SIC_code='5812'DB:business_master_new
loadtime:1.0552339553833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenna' limit 1
loadtime:1.0552780628204 / seconds
Query Executed:select id FROM `nm` where city='Kenna' && SIC_code='5812'DB:business_master_new
loadtime:1.0556061267853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirtland' limit 1
loadtime:1.0556609630585 / seconds
Query Executed:select id FROM `nm` where city='Kirtland' && SIC_code='5812'DB:business_master_new
loadtime:1.0576250553131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirtland Afb' limit 1
loadtime:1.0576889514923 / seconds
Query Executed:select id FROM `nm` where city='Kirtland Afb' && SIC_code='5812'DB:business_master_new
loadtime:1.0584890842438 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Jara' limit 1
loadtime:1.058531999588 / seconds
Query Executed:select id FROM `nm` where city='La Jara' && SIC_code='5812'DB:business_master_new
loadtime:1.0589010715485 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Joya' limit 1
loadtime:1.0589420795441 / seconds
Query Executed:select id FROM `nm` where city='La Joya' && SIC_code='5812'DB:business_master_new
loadtime:1.0592801570892 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Loma' limit 1
loadtime:1.0593149662018 / seconds
Query Executed:select id FROM `nm` where city='La Loma' && SIC_code='5812'DB:business_master_new
loadtime:1.0596339702606 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Luz' limit 1
loadtime:1.059671163559 / seconds
Query Executed:select id FROM `nm` where city='La Luz' && SIC_code='5812'DB:business_master_new
loadtime:1.0608570575714 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Madera' limit 1
loadtime:1.0608990192413 / seconds
Query Executed:select id FROM `nm` where city='La Madera' && SIC_code='5812'DB:business_master_new
loadtime:1.0612471103668 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Mesa' limit 1
loadtime:1.0612959861755 / seconds
Query Executed:select id FROM `nm` where city='La Mesa' && SIC_code='5812'DB:business_master_new
loadtime:1.0621831417084 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Plata' limit 1
loadtime:1.0622279644012 / seconds
Query Executed:select id FROM `nm` where city='La Plata' && SIC_code='5812'DB:business_master_new
loadtime:1.0628719329834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laguna' limit 1
loadtime:1.0629210472107 / seconds
Query Executed:select id FROM `nm` where city='Laguna' && SIC_code='5812'DB:business_master_new
loadtime:1.0639200210571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lajoya' limit 1
loadtime:1.0639741420746 / seconds
Query Executed:select id FROM `nm` where city='Lajoya' && SIC_code='5812'DB:business_master_new
loadtime:1.0642290115356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Arthur' limit 1
loadtime:1.0642559528351 / seconds
Query Executed:select id FROM `nm` where city='Lake Arthur' && SIC_code='5812'DB:business_master_new
loadtime:1.0649819374084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakewood' limit 1
loadtime:1.0650300979614 / seconds
Query Executed:select id FROM `nm` where city='Lakewood' && SIC_code='5812'DB:business_master_new
loadtime:1.06547498703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamy' limit 1
loadtime:1.0655190944672 / seconds
Query Executed:select id FROM `nm` where city='Lamy' && SIC_code='5812'DB:business_master_new
loadtime:1.0664000511169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Las Cruces' limit 1
loadtime:1.0664350986481 / seconds
Query Executed:select id FROM `nm` where city='Las Cruces' && SIC_code='5812'DB:business_master_new
loadtime:1.0735740661621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Las Vegas' limit 1
loadtime:1.0738241672516 / seconds
Query Executed:select id FROM `nm` where city='Las Vegas' && SIC_code='5812'DB:business_master_new
loadtime:1.0767040252686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemitar' limit 1
loadtime:1.0768091678619 / seconds
Query Executed:select id FROM `nm` where city='Lemitar' && SIC_code='5812'DB:business_master_new
loadtime:1.077388048172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:1.0774481296539 / seconds
Query Executed:select id FROM `nm` where city='Lincoln' && SIC_code='5812'DB:business_master_new
loadtime:1.0779120922089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lindrith' limit 1
loadtime:1.0779509544373 / seconds
Query Executed:select id FROM `nm` where city='Lindrith' && SIC_code='5812'DB:business_master_new
loadtime:1.0784890651703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Llano' limit 1
loadtime:1.0785300731659 / seconds
Query Executed:select id FROM `nm` where city='Llano' && SIC_code='5812'DB:business_master_new
loadtime:1.078889131546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loco Hills' limit 1
loadtime:1.0789279937744 / seconds
Query Executed:select id FROM `nm` where city='Loco Hills' && SIC_code='5812'DB:business_master_new
loadtime:1.0796670913696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Logan' limit 1
loadtime:1.0797209739685 / seconds
Query Executed:select id FROM `nm` where city='Logan' && SIC_code='5812'DB:business_master_new
loadtime:1.0816299915314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lordsburg' limit 1
loadtime:1.0816769599915 / seconds
Query Executed:select id FROM `nm` where city='Lordsburg' && SIC_code='5812'DB:business_master_new
loadtime:1.0838129520416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Los Alamos' limit 1
loadtime:1.083878993988 / seconds
Query Executed:select id FROM `nm` where city='Los Alamos' && SIC_code='5812'DB:business_master_new
loadtime:1.0865840911865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Los Lunas' limit 1
loadtime:1.0866510868073 / seconds
Query Executed:select id FROM `nm` where city='Los Lunas' && SIC_code='5812'DB:business_master_new
loadtime:1.0898380279541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Los Ojos' limit 1
loadtime:1.0899350643158 / seconds
Query Executed:select id FROM `nm` where city='Los Ojos' && SIC_code='5812'DB:business_master_new
loadtime:1.0905261039734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loving' limit 1
loadtime:1.0905721187592 / seconds
Query Executed:select id FROM `nm` where city='Loving' && SIC_code='5812'DB:business_master_new
loadtime:1.0914740562439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovington' limit 1
loadtime:1.0915329456329 / seconds
Query Executed:select id FROM `nm` where city='Lovington' && SIC_code='5812'DB:business_master_new
loadtime:1.0939240455627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lumberton' limit 1
loadtime:1.0939910411835 / seconds
Query Executed:select id FROM `nm` where city='Lumberton' && SIC_code='5812'DB:business_master_new
loadtime:1.0943100452423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luna' limit 1
loadtime:1.0943529605865 / seconds
Query Executed:select id FROM `nm` where city='Luna' && SIC_code='5812'DB:business_master_new
loadtime:1.0948121547699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magdalena' limit 1
loadtime:1.0948510169983 / seconds
Query Executed:select id FROM `nm` where city='Magdalena' && SIC_code='5812'DB:business_master_new
loadtime:1.096675157547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malaga' limit 1
loadtime:1.0967359542847 / seconds
Query Executed:select id FROM `nm` where city='Malaga' && SIC_code='5812'DB:business_master_new
loadtime:1.0970931053162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maljamar' limit 1
loadtime:1.0971291065216 / seconds
Query Executed:select id FROM `nm` where city='Maljamar' && SIC_code='5812'DB:business_master_new
loadtime:1.0976481437683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxwell' limit 1
loadtime:1.0977029800415 / seconds
Query Executed:select id FROM `nm` where city='Maxwell' && SIC_code='5812'DB:business_master_new
loadtime:1.0982429981232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayhill' limit 1
loadtime:1.0982789993286 / seconds
Query Executed:select id FROM `nm` where city='Mayhill' && SIC_code='5812'DB:business_master_new
loadtime:1.0991921424866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Alister' limit 1
loadtime:1.0992481708527 / seconds
Query Executed:select id FROM `nm` where city='Mc Alister' && SIC_code='5812'DB:business_master_new
loadtime:1.0995969772339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Donald' limit 1
loadtime:1.0996329784393 / seconds
Query Executed:select id FROM `nm` where city='Mc Donald' && SIC_code='5812'DB:business_master_new
loadtime:1.0999269485474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Intosh' limit 1
loadtime:1.09996509552 / seconds
Query Executed:select id FROM `nm` where city='Mc Intosh' && SIC_code='5812'DB:business_master_new
loadtime:1.1002111434937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medanales' limit 1
loadtime:1.1002440452576 / seconds
Query Executed:select id FROM `nm` where city='Medanales' && SIC_code='5812'DB:business_master_new
loadtime:1.1005370616913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melrose' limit 1
loadtime:1.1005620956421 / seconds
Query Executed:select id FROM `nm` where city='Melrose' && SIC_code='5812'DB:business_master_new
loadtime:1.1016011238098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mentmore' limit 1
loadtime:1.1016550064087 / seconds
Query Executed:select id FROM `nm` where city='Mentmore' && SIC_code='5812'DB:business_master_new
loadtime:1.1021070480347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mescalero' limit 1
loadtime:1.1021430492401 / seconds
Query Executed:select id FROM `nm` where city='Mescalero' && SIC_code='5812'DB:business_master_new
loadtime:1.103306055069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesilla' limit 1
loadtime:1.1033530235291 / seconds
Query Executed:select id FROM `nm` where city='Mesilla' && SIC_code='5812'DB:business_master_new
loadtime:1.1052391529083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesilla Park' limit 1
loadtime:1.1052870750427 / seconds
Query Executed:select id FROM `nm` where city='Mesilla Park' && SIC_code='5812'DB:business_master_new
loadtime:1.1070830821991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesquite' limit 1
loadtime:1.1071441173553 / seconds
Query Executed:select id FROM `nm` where city='Mesquite' && SIC_code='5812'DB:business_master_new
loadtime:1.1081249713898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mexican Springs' limit 1
loadtime:1.1081609725952 / seconds
Query Executed:select id FROM `nm` where city='Mexican Springs' && SIC_code='5812'DB:business_master_new
loadtime:1.1084151268005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miami' limit 1
loadtime:1.1084530353546 / seconds
Query Executed:select id FROM `nm` where city='Miami' && SIC_code='5812'DB:business_master_new
loadtime:1.1087920665741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milan' limit 1
loadtime:1.1088290214539 / seconds
Query Executed:select id FROM `nm` where city='Milan' && SIC_code='5812'DB:business_master_new
loadtime:1.1106841564178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mills' limit 1
loadtime:1.1107320785522 / seconds
Query Executed:select id FROM `nm` where city='Mills' && SIC_code='5812'DB:business_master_new
loadtime:1.1110811233521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milnesand' limit 1
loadtime:1.1111290454865 / seconds
Query Executed:select id FROM `nm` where city='Milnesand' && SIC_code='5812'DB:business_master_new
loadtime:1.1115751266479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mimbres' limit 1
loadtime:1.1116111278534 / seconds
Query Executed:select id FROM `nm` where city='Mimbres' && SIC_code='5812'DB:business_master_new
loadtime:1.1124060153961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mogollon' limit 1
loadtime:1.1124610900879 / seconds
Query Executed:select id FROM `nm` where city='Mogollon' && SIC_code='5812'DB:business_master_new
loadtime:1.1127030849457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montezuma' limit 1
loadtime:1.1127309799194 / seconds
Query Executed:select id FROM `nm` where city='Montezuma' && SIC_code='5812'DB:business_master_new
loadtime:1.1131520271301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:1.1132061481476 / seconds
Query Executed:select id FROM `nm` where city='Monticello' && SIC_code='5812'DB:business_master_new
loadtime:1.1135561466217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monument' limit 1
loadtime:1.1135909557343 / seconds
Query Executed:select id FROM `nm` where city='Monument' && SIC_code='5812'DB:business_master_new
loadtime:1.114058971405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mora' limit 1
loadtime:1.1141149997711 / seconds
Query Executed:select id FROM `nm` where city='Mora' && SIC_code='5812'DB:business_master_new
loadtime:1.116014957428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moriarty' limit 1
loadtime:1.1160740852356 / seconds
Query Executed:select id FROM `nm` where city='Moriarty' && SIC_code='5812'DB:business_master_new
loadtime:1.1182341575623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mosquero' limit 1
loadtime:1.1182930469513 / seconds
Query Executed:select id FROM `nm` where city='Mosquero' && SIC_code='5812'DB:business_master_new
loadtime:1.1191229820251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountainair' limit 1
loadtime:1.1191730499268 / seconds
Query Executed:select id FROM `nm` where city='Mountainair' && SIC_code='5812'DB:business_master_new
loadtime:1.1210830211639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mule Creek' limit 1
loadtime:1.1211290359497 / seconds
Query Executed:select id FROM `nm` where city='Mule Creek' && SIC_code='5812'DB:business_master_new
loadtime:1.1215059757233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nageezi' limit 1
loadtime:1.1215529441833 / seconds
Query Executed:select id FROM `nm` where city='Nageezi' && SIC_code='5812'DB:business_master_new
loadtime:1.1219141483307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nara Visa' limit 1
loadtime:1.1219460964203 / seconds
Query Executed:select id FROM `nm` where city='Nara Visa' && SIC_code='5812'DB:business_master_new
loadtime:1.1225011348724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Navajo' limit 1
loadtime:1.1225590705872 / seconds
Query Executed:select id FROM `nm` where city='Navajo' && SIC_code='5812'DB:business_master_new
loadtime:1.1233520507812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Navajo Dam' limit 1
loadtime:1.1233961582184 / seconds
Query Executed:select id FROM `nm` where city='Navajo Dam' && SIC_code='5812'DB:business_master_new
loadtime:1.124006986618 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Laguna' limit 1
loadtime:1.1240570545197 / seconds
Query Executed:select id FROM `nm` where city='New Laguna' && SIC_code='5812'DB:business_master_new
loadtime:1.1244270801544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newcomb' limit 1
loadtime:1.124470949173 / seconds
Query Executed:select id FROM `nm` where city='Newcomb' && SIC_code='5812'DB:business_master_new
loadtime:1.1249971389771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newkirk' limit 1
loadtime:1.1250319480896 / seconds
Query Executed:select id FROM `nm` where city='Newkirk' && SIC_code='5812'DB:business_master_new
loadtime:1.1253731250763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nogal' limit 1
loadtime:1.125422000885 / seconds
Query Executed:select id FROM `nm` where city='Nogal' && SIC_code='5812'DB:business_master_new
loadtime:1.1259109973907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocate' limit 1
loadtime:1.1259469985962 / seconds
Query Executed:select id FROM `nm` where city='Ocate' && SIC_code='5812'DB:business_master_new
loadtime:1.1262991428375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ojo Caliente' limit 1
loadtime:1.1263470649719 / seconds
Query Executed:select id FROM `nm` where city='Ojo Caliente' && SIC_code='5812'DB:business_master_new
loadtime:1.1271200180054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ojo Feliz' limit 1
loadtime:1.1271660327911 / seconds
Query Executed:select id FROM `nm` where city='Ojo Feliz' && SIC_code='5812'DB:business_master_new
loadtime:1.1274411678314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ojo Sarco' limit 1
loadtime:1.1274890899658 / seconds
Query Executed:select id FROM `nm` where city='Ojo Sarco' && SIC_code='5812'DB:business_master_new
loadtime:1.127769947052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Organ' limit 1
loadtime:1.1278159618378 / seconds
Query Executed:select id FROM `nm` where city='Organ' && SIC_code='5812'DB:business_master_new
loadtime:1.1283760070801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orogrande' limit 1
loadtime:1.1284110546112 / seconds
Query Executed:select id FROM `nm` where city='Orogrande' && SIC_code='5812'DB:business_master_new
loadtime:1.1287169456482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paguate' limit 1
loadtime:1.1287519931793 / seconds
Query Executed:select id FROM `nm` where city='Paguate' && SIC_code='5812'DB:business_master_new
loadtime:1.1290669441223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pecos' limit 1
loadtime:1.1291019916534 / seconds
Query Executed:select id FROM `nm` where city='Pecos' && SIC_code='5812'DB:business_master_new
loadtime:1.1308889389038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pena Blanca' limit 1
loadtime:1.1309480667114 / seconds
Query Executed:select id FROM `nm` where city='Pena Blanca' && SIC_code='5812'DB:business_master_new
loadtime:1.131500005722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penasco' limit 1
loadtime:1.1315441131592 / seconds
Query Executed:select id FROM `nm` where city='Penasco' && SIC_code='5812'DB:business_master_new
loadtime:1.1326069831848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pep' limit 1
loadtime:1.1326670646667 / seconds
Query Executed:select id FROM `nm` where city='Pep' && SIC_code='5812'DB:business_master_new
loadtime:1.1331210136414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peralta' limit 1
loadtime:1.1331560611725 / seconds
Query Executed:select id FROM `nm` where city='Peralta' && SIC_code='5812'DB:business_master_new
loadtime:1.1349251270294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petaca' limit 1
loadtime:1.1349799633026 / seconds
Query Executed:select id FROM `nm` where city='Petaca' && SIC_code='5812'DB:business_master_new
loadtime:1.1352469921112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Picacho' limit 1
loadtime:1.135281085968 / seconds
Query Executed:select id FROM `nm` where city='Picacho' && SIC_code='5812'DB:business_master_new
loadtime:1.1356599330902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pie Town' limit 1
loadtime:1.135684967041 / seconds
Query Executed:select id FROM `nm` where city='Pie Town' && SIC_code='5812'DB:business_master_new
loadtime:1.1363091468811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinehill' limit 1
loadtime:1.1363639831543 / seconds
Query Executed:select id FROM `nm` where city='Pinehill' && SIC_code='5812'DB:business_master_new
loadtime:1.1369230747223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinon' limit 1
loadtime:1.1369500160217 / seconds
Query Executed:select id FROM `nm` where city='Pinon' && SIC_code='5812'DB:business_master_new
loadtime:1.1372990608215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinos Altos' limit 1
loadtime:1.1373450756073 / seconds
Query Executed:select id FROM `nm` where city='Pinos Altos' && SIC_code='5812'DB:business_master_new
loadtime:1.1377990245819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Placitas' limit 1
loadtime:1.1378350257874 / seconds
Query Executed:select id FROM `nm` where city='Placitas' && SIC_code='5812'DB:business_master_new
loadtime:1.1396420001984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Playas' limit 1
loadtime:1.1396980285645 / seconds
Query Executed:select id FROM `nm` where city='Playas' && SIC_code='5812'DB:business_master_new
loadtime:1.1400570869446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pojoaque Valley' limit 1
loadtime:1.14009308815 / seconds
Query Executed:select id FROM `nm` where city='Pojoaque Valley' && SIC_code='5812'DB:business_master_new
loadtime:1.1404271125793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polvadera' limit 1
loadtime:1.1404809951782 / seconds
Query Executed:select id FROM `nm` where city='Polvadera' && SIC_code='5812'DB:business_master_new
loadtime:1.1408669948578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ponderosa' limit 1
loadtime:1.1409029960632 / seconds
Query Executed:select id FROM `nm` where city='Ponderosa' && SIC_code='5812'DB:business_master_new
loadtime:1.1412661075592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portales' limit 1
loadtime:1.1413011550903 / seconds
Query Executed:select id FROM `nm` where city='Portales' && SIC_code='5812'DB:business_master_new
loadtime:1.143972158432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prewitt' limit 1
loadtime:1.1440451145172 / seconds
Query Executed:select id FROM `nm` where city='Prewitt' && SIC_code='5812'DB:business_master_new
loadtime:1.1445951461792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pueblo Of Acoma' limit 1
loadtime:1.1446330547333 / seconds
Query Executed:select id FROM `nm` where city='Pueblo Of Acoma' && SIC_code='5812'DB:business_master_new
loadtime:1.1452550888062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quay' limit 1
loadtime:1.1453011035919 / seconds
Query Executed:select id FROM `nm` where city='Quay' && SIC_code='5812'DB:business_master_new
loadtime:1.1456010341644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quemado' limit 1
loadtime:1.1456279754639 / seconds
Query Executed:select id FROM `nm` where city='Quemado' && SIC_code='5812'DB:business_master_new
loadtime:1.1464650630951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Questa' limit 1
loadtime:1.146525144577 / seconds
Query Executed:select id FROM `nm` where city='Questa' && SIC_code='5812'DB:business_master_new
loadtime:1.1484270095825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radium Springs' limit 1
loadtime:1.1484751701355 / seconds
Query Executed:select id FROM `nm` where city='Radium Springs' && SIC_code='5812'DB:business_master_new
loadtime:1.1488959789276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rainsville' limit 1
loadtime:1.1489410400391 / seconds
Query Executed:select id FROM `nm` where city='Rainsville' && SIC_code='5812'DB:business_master_new
loadtime:1.1491990089417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramah' limit 1
loadtime:1.1492321491241 / seconds
Query Executed:select id FROM `nm` where city='Ramah' && SIC_code='5812'DB:business_master_new
loadtime:1.1504650115967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ranchos De Taos' limit 1
loadtime:1.1505110263824 / seconds
Query Executed:select id FROM `nm` where city='Ranchos De Taos' && SIC_code='5812'DB:business_master_new
loadtime:1.1524691581726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raton' limit 1
loadtime:1.1525311470032 / seconds
Query Executed:select id FROM `nm` where city='Raton' && SIC_code='5812'DB:business_master_new
loadtime:1.1548211574554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red River' limit 1
loadtime:1.1548819541931 / seconds
Query Executed:select id FROM `nm` where city='Red River' && SIC_code='5812'DB:business_master_new
loadtime:1.1569781303406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redrock' limit 1
loadtime:1.1570489406586 / seconds
Query Executed:select id FROM `nm` where city='Redrock' && SIC_code='5812'DB:business_master_new
loadtime:1.1573989391327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Regina' limit 1
loadtime:1.157436132431 / seconds
Query Executed:select id FROM `nm` where city='Regina' && SIC_code='5812'DB:business_master_new
loadtime:1.1578061580658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rehoboth' limit 1
loadtime:1.157851934433 / seconds
Query Executed:select id FROM `nm` where city='Rehoboth' && SIC_code='5812'DB:business_master_new
loadtime:1.1582591533661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reserve' limit 1
loadtime:1.1583051681519 / seconds
Query Executed:select id FROM `nm` where city='Reserve' && SIC_code='5812'DB:business_master_new
loadtime:1.1597490310669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ribera' limit 1
loadtime:1.1598119735718 / seconds
Query Executed:select id FROM `nm` where city='Ribera' && SIC_code='5812'DB:business_master_new
loadtime:1.1604261398315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rincon' limit 1
loadtime:1.1604821681976 / seconds
Query Executed:select id FROM `nm` where city='Rincon' && SIC_code='5812'DB:business_master_new
loadtime:1.1609239578247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio Rancho' limit 1
loadtime:1.1609580516815 / seconds
Query Executed:select id FROM `nm` where city='Rio Rancho' && SIC_code='5812'DB:business_master_new
loadtime:1.1644549369812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rociada' limit 1
loadtime:1.1645531654358 / seconds
Query Executed:select id FROM `nm` where city='Rociada' && SIC_code='5812'DB:business_master_new
loadtime:1.1649439334869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rodeo' limit 1
loadtime:1.1649751663208 / seconds
Query Executed:select id FROM `nm` where city='Rodeo' && SIC_code='5812'DB:business_master_new
loadtime:1.1654970645905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rogers' limit 1
loadtime:1.1655440330505 / seconds
Query Executed:select id FROM `nm` where city='Rogers' && SIC_code='5812'DB:business_master_new
loadtime:1.1658940315247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roswell' limit 1
loadtime:1.1659300327301 / seconds
Query Executed:select id FROM `nm` where city='Roswell' && SIC_code='5812'DB:business_master_new
loadtime:1.1706190109253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowe' limit 1
loadtime:1.170755147934 / seconds
Query Executed:select id FROM `nm` where city='Rowe' && SIC_code='5812'DB:business_master_new
loadtime:1.1712260246277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roy' limit 1
loadtime:1.1712810993195 / seconds
Query Executed:select id FROM `nm` where city='Roy' && SIC_code='5812'DB:business_master_new
loadtime:1.1722581386566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruidoso' limit 1
loadtime:1.1723160743713 / seconds
Query Executed:select id FROM `nm` where city='Ruidoso' && SIC_code='5812'DB:business_master_new
loadtime:1.1753180027008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruidoso Downs' limit 1
loadtime:1.1753959655762 / seconds
Query Executed:select id FROM `nm` where city='Ruidoso Downs' && SIC_code='5812'DB:business_master_new
loadtime:1.1773791313171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutheron' limit 1
loadtime:1.1774411201477 / seconds
Query Executed:select id FROM `nm` where city='Rutheron' && SIC_code='5812'DB:business_master_new
loadtime:1.1777420043945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sacramento' limit 1
loadtime:1.1777701377869 / seconds
Query Executed:select id FROM `nm` where city='Sacramento' && SIC_code='5812'DB:business_master_new
loadtime:1.1781711578369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Vrain' limit 1
loadtime:1.1782169342041 / seconds
Query Executed:select id FROM `nm` where city='Saint Vrain' && SIC_code='5812'DB:business_master_new
loadtime:1.1784930229187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:1.178521156311 / seconds
Query Executed:select id FROM `nm` where city='Salem' && SIC_code='5812'DB:business_master_new
loadtime:1.1789910793304 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Acacia' limit 1
loadtime:1.1790280342102 / seconds
Query Executed:select id FROM `nm` where city='San Acacia' && SIC_code='5812'DB:business_master_new
loadtime:1.1793849468231 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Antonio' limit 1
loadtime:1.1794199943542 / seconds
Query Executed:select id FROM `nm` where city='San Antonio' && SIC_code='5812'DB:business_master_new
loadtime:1.1800990104675 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Cristobal' limit 1
loadtime:1.1801569461823 / seconds
Query Executed:select id FROM `nm` where city='San Cristobal' && SIC_code='5812'DB:business_master_new
loadtime:1.1806421279907 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Fidel' limit 1
loadtime:1.1806950569153 / seconds
Query Executed:select id FROM `nm` where city='San Fidel' && SIC_code='5812'DB:business_master_new
loadtime:1.1812701225281 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Jon' limit 1
loadtime:1.1813061237335 / seconds
Query Executed:select id FROM `nm` where city='San Jon' && SIC_code='5812'DB:business_master_new
loadtime:1.1821830272675 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Jose' limit 1
loadtime:1.1822381019592 / seconds
Query Executed:select id FROM `nm` where city='San Jose' && SIC_code='5812'DB:business_master_new
loadtime:1.1826241016388 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Juan Pueblo' limit 1
loadtime:1.1826510429382 / seconds
Query Executed:select id FROM `nm` where city='San Juan Pueblo' && SIC_code='5812'DB:business_master_new
loadtime:1.1832201480865 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Lorenzo' limit 1
loadtime:1.1832690238953 / seconds
Query Executed:select id FROM `nm` where city='San Lorenzo' && SIC_code='5812'DB:business_master_new
loadtime:1.1835789680481 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Miguel' limit 1
loadtime:1.1836061477661 / seconds
Query Executed:select id FROM `nm` where city='San Miguel' && SIC_code='5812'DB:business_master_new
loadtime:1.1841061115265 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Patricio' limit 1
loadtime:1.1841540336609 / seconds
Query Executed:select id FROM `nm` where city='San Patricio' && SIC_code='5812'DB:business_master_new
loadtime:1.1846301555634 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Rafael' limit 1
loadtime:1.1846740245819 / seconds
Query Executed:select id FROM `nm` where city='San Rafael' && SIC_code='5812'DB:business_master_new
loadtime:1.1849870681763 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Ysidro' limit 1
loadtime:1.1850290298462 / seconds
Query Executed:select id FROM `nm` where city='San Ysidro' && SIC_code='5812'DB:business_master_new
loadtime:1.1857900619507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandia Park' limit 1
loadtime:1.1858439445496 / seconds
Query Executed:select id FROM `nm` where city='Sandia Park' && SIC_code='5812'DB:business_master_new
loadtime:1.187637090683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanostee' limit 1
loadtime:1.1876821517944 / seconds
Query Executed:select id FROM `nm` where city='Sanostee' && SIC_code='5812'DB:business_master_new
loadtime:1.1880929470062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Clara' limit 1
loadtime:1.1881401538849 / seconds
Query Executed:select id FROM `nm` where city='Santa Clara' && SIC_code='5812'DB:business_master_new
loadtime:1.1887509822845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Cruz' limit 1
loadtime:1.1888091564178 / seconds
Query Executed:select id FROM `nm` where city='Santa Cruz' && SIC_code='5812'DB:business_master_new
loadtime:1.1898081302643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Fe' limit 1
loadtime:1.1898629665375 / seconds
Query Executed:select id FROM `nm` where city='Santa Fe' && SIC_code='5812'DB:business_master_new
loadtime:1.2035920619965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Rosa' limit 1
loadtime:1.2039639949799 / seconds
Query Executed:select id FROM `nm` where city='Santa Rosa' && SIC_code='5812'DB:business_master_new
loadtime:1.2061109542847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Teresa' limit 1
loadtime:1.2061991691589 / seconds
Query Executed:select id FROM `nm` where city='Santa Teresa' && SIC_code='5812'DB:business_master_new
loadtime:1.2080609798431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santo Domingo Pb' limit 1
loadtime:1.2081151008606 / seconds
Query Executed:select id FROM `nm` where city='Santo Domingo Pb' && SIC_code='5812'DB:business_master_new
loadtime:1.2083711624146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santo Domingo Pueblo' limit 1
loadtime:1.2084100246429 / seconds
Query Executed:select id FROM `nm` where city='Santo Domingo Pueblo' && SIC_code='5812'DB:business_master_new
loadtime:1.2088220119476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sapello' limit 1
loadtime:1.2088580131531 / seconds
Query Executed:select id FROM `nm` where city='Sapello' && SIC_code='5812'DB:business_master_new
loadtime:1.2093019485474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seboyeta' limit 1
loadtime:1.2093369960785 / seconds
Query Executed:select id FROM `nm` where city='Seboyeta' && SIC_code='5812'DB:business_master_new
loadtime:1.2096400260925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedan' limit 1
loadtime:1.2096750736237 / seconds
Query Executed:select id FROM `nm` where city='Sedan' && SIC_code='5812'DB:business_master_new
loadtime:1.2100610733032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:1.2100961208344 / seconds
Query Executed:select id FROM `nm` where city='Seneca' && SIC_code='5812'DB:business_master_new
loadtime:1.2103750705719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Serafina' limit 1
loadtime:1.2104139328003 / seconds
Query Executed:select id FROM `nm` where city='Serafina' && SIC_code='5812'DB:business_master_new
loadtime:1.2107400894165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheep Springs' limit 1
loadtime:1.2107679843903 / seconds
Query Executed:select id FROM `nm` where city='Sheep Springs' && SIC_code='5812'DB:business_master_new
loadtime:1.2111010551453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shiprock' limit 1
loadtime:1.2111401557922 / seconds
Query Executed:select id FROM `nm` where city='Shiprock' && SIC_code='5812'DB:business_master_new
loadtime:1.2131459712982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver City' limit 1
loadtime:1.2132091522217 / seconds
Query Executed:select id FROM `nm` where city='Silver City' && SIC_code='5812'DB:business_master_new
loadtime:1.216334104538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smith Lake' limit 1
loadtime:1.216423034668 / seconds
Query Executed:select id FROM `nm` where city='Smith Lake' && SIC_code='5812'DB:business_master_new
loadtime:1.2167630195618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Socorro' limit 1
loadtime:1.2168180942535 / seconds
Query Executed:select id FROM `nm` where city='Socorro' && SIC_code='5812'DB:business_master_new
loadtime:1.2195510864258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Solano' limit 1
loadtime:1.2196159362793 / seconds
Query Executed:select id FROM `nm` where city='Solano' && SIC_code='5812'DB:business_master_new
loadtime:1.2199461460114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springer' limit 1
loadtime:1.2199921607971 / seconds
Query Executed:select id FROM `nm` where city='Springer' && SIC_code='5812'DB:business_master_new
loadtime:1.2220711708069 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Vrain' limit 1
loadtime:1.2221119403839 / seconds
Query Executed:select id FROM `nm` where city='St Vrain' && SIC_code='5812'DB:business_master_new
loadtime:1.2223851680756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:1.222424030304 / seconds
Query Executed:select id FROM `nm` where city='Stanley' && SIC_code='5812'DB:business_master_new
loadtime:1.2230160236359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunland Park' limit 1
loadtime:1.2230501174927 / seconds
Query Executed:select id FROM `nm` where city='Sunland Park' && SIC_code='5812'DB:business_master_new
loadtime:1.224916934967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunspot' limit 1
loadtime:1.2249660491943 / seconds
Query Executed:select id FROM `nm` where city='Sunspot' && SIC_code='5812'DB:business_master_new
loadtime:1.2253241539001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taiban' limit 1
loadtime:1.2253589630127 / seconds
Query Executed:select id FROM `nm` where city='Taiban' && SIC_code='5812'DB:business_master_new
loadtime:1.225643157959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tajique' limit 1
loadtime:1.2256720066071 / seconds
Query Executed:select id FROM `nm` where city='Tajique' && SIC_code='5812'DB:business_master_new
loadtime:1.2259819507599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taos' limit 1
loadtime:1.2260229587555 / seconds
Query Executed:select id FROM `nm` where city='Taos' && SIC_code='5812'DB:business_master_new
loadtime:1.2297041416168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taos Ski Valley' limit 1
loadtime:1.2298300266266 / seconds
Query Executed:select id FROM `nm` where city='Taos Ski Valley' && SIC_code='5812'DB:business_master_new
loadtime:1.2308020591736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tatum' limit 1
loadtime:1.2308650016785 / seconds
Query Executed:select id FROM `nm` where city='Tatum' && SIC_code='5812'DB:business_master_new
loadtime:1.2321820259094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tererro' limit 1
loadtime:1.2322249412537 / seconds
Query Executed:select id FROM `nm` where city='Tererro' && SIC_code='5812'DB:business_master_new
loadtime:1.232586145401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tesuque' limit 1
loadtime:1.2326331138611 / seconds
Query Executed:select id FROM `nm` where city='Tesuque' && SIC_code='5812'DB:business_master_new
loadtime:1.2335641384125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Texico' limit 1
loadtime:1.2336130142212 / seconds
Query Executed:select id FROM `nm` where city='Texico' && SIC_code='5812'DB:business_master_new
loadtime:1.235020160675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thoreau' limit 1
loadtime:1.2350780963898 / seconds
Query Executed:select id FROM `nm` where city='Thoreau' && SIC_code='5812'DB:business_master_new
loadtime:1.236438035965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tierra Amarilla' limit 1
loadtime:1.2364971637726 / seconds
Query Executed:select id FROM `nm` where city='Tierra Amarilla' && SIC_code='5812'DB:business_master_new
loadtime:1.2376320362091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tijeras' limit 1
loadtime:1.2376770973206 / seconds
Query Executed:select id FROM `nm` where city='Tijeras' && SIC_code='5812'DB:business_master_new
loadtime:1.2396941184998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timberon' limit 1
loadtime:1.2397520542145 / seconds
Query Executed:select id FROM `nm` where city='Timberon' && SIC_code='5812'DB:business_master_new
loadtime:1.2405049800873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tinnie' limit 1
loadtime:1.2405490875244 / seconds
Query Executed:select id FROM `nm` where city='Tinnie' && SIC_code='5812'DB:business_master_new
loadtime:1.2409319877625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tohatchi' limit 1
loadtime:1.2409801483154 / seconds
Query Executed:select id FROM `nm` where city='Tohatchi' && SIC_code='5812'DB:business_master_new
loadtime:1.241641998291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tome' limit 1
loadtime:1.2416770458221 / seconds
Query Executed:select id FROM `nm` where city='Tome' && SIC_code='5812'DB:business_master_new
loadtime:1.2422339916229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Torreon' limit 1
loadtime:1.242280960083 / seconds
Query Executed:select id FROM `nm` where city='Torreon' && SIC_code='5812'DB:business_master_new
loadtime:1.2426900863647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trampas' limit 1
loadtime:1.2427260875702 / seconds
Query Executed:select id FROM `nm` where city='Trampas' && SIC_code='5812'DB:business_master_new
loadtime:1.2430100440979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trementina' limit 1
loadtime:1.243047952652 / seconds
Query Executed:select id FROM `nm` where city='Trementina' && SIC_code='5812'DB:business_master_new
loadtime:1.243381023407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tres Piedras' limit 1
loadtime:1.2434289455414 / seconds
Query Executed:select id FROM `nm` where city='Tres Piedras' && SIC_code='5812'DB:business_master_new
loadtime:1.2439019680023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truchas' limit 1
loadtime:1.2439301013947 / seconds
Query Executed:select id FROM `nm` where city='Truchas' && SIC_code='5812'DB:business_master_new
loadtime:1.2444479465485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truth Or Cnsqncs' limit 1
loadtime:1.2444951534271 / seconds
Query Executed:select id FROM `nm` where city='Truth Or Cnsqncs' && SIC_code='5812'DB:business_master_new
loadtime:1.2449040412903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truth Or Consequences' limit 1
loadtime:1.2449469566345 / seconds
Query Executed:select id FROM `nm` where city='Truth Or Consequences' && SIC_code='5812'DB:business_master_new
loadtime:1.2473161220551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tucumcari' limit 1
loadtime:1.2473900318146 / seconds
Query Executed:select id FROM `nm` where city='Tucumcari' && SIC_code='5812'DB:business_master_new
loadtime:1.2497000694275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tularosa' limit 1
loadtime:1.2497589588165 / seconds
Query Executed:select id FROM `nm` where city='Tularosa' && SIC_code='5812'DB:business_master_new
loadtime:1.2517690658569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyrone' limit 1
loadtime:1.2518479824066 / seconds
Query Executed:select id FROM `nm` where city='Tyrone' && SIC_code='5812'DB:business_master_new
loadtime:1.2534811496735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ute Park' limit 1
loadtime:1.2535290718079 / seconds
Query Executed:select id FROM `nm` where city='Ute Park' && SIC_code='5812'DB:business_master_new
loadtime:1.2538521289825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vadito' limit 1
loadtime:1.2538800239563 / seconds
Query Executed:select id FROM `nm` where city='Vadito' && SIC_code='5812'DB:business_master_new
loadtime:1.2554981708527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vado' limit 1
loadtime:1.2555439472198 / seconds
Query Executed:select id FROM `nm` where city='Vado' && SIC_code='5812'DB:business_master_new
loadtime:1.2573320865631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valdez' limit 1
loadtime:1.257383108139 / seconds
Query Executed:select id FROM `nm` where city='Valdez' && SIC_code='5812'DB:business_master_new
loadtime:1.257719039917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vallecitos' limit 1
loadtime:1.257758140564 / seconds
Query Executed:select id FROM `nm` where city='Vallecitos' && SIC_code='5812'DB:business_master_new
loadtime:1.2580950260162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valmora' limit 1
loadtime:1.2581310272217 / seconds
Query Executed:select id FROM `nm` where city='Valmora' && SIC_code='5812'DB:business_master_new
loadtime:1.2583980560303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vanderwagen' limit 1
loadtime:1.2584359645844 / seconds
Query Executed:select id FROM `nm` where city='Vanderwagen' && SIC_code='5812'DB:business_master_new
loadtime:1.2602241039276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vaughn' limit 1
loadtime:1.2602739334106 / seconds
Query Executed:select id FROM `nm` where city='Vaughn' && SIC_code='5812'DB:business_master_new
loadtime:1.2620260715485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Veguita' limit 1
loadtime:1.2620711326599 / seconds
Query Executed:select id FROM `nm` where city='Veguita' && SIC_code='5812'DB:business_master_new
loadtime:1.2636160850525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Velarde' limit 1
loadtime:1.2636711597443 / seconds
Query Executed:select id FROM `nm` where city='Velarde' && SIC_code='5812'DB:business_master_new
loadtime:1.265328168869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villanueva' limit 1
loadtime:1.2653830051422 / seconds
Query Executed:select id FROM `nm` where city='Villanueva' && SIC_code='5812'DB:business_master_new
loadtime:1.2657060623169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wagon Mound' limit 1
loadtime:1.2657330036163 / seconds
Query Executed:select id FROM `nm` where city='Wagon Mound' && SIC_code='5812'DB:business_master_new
loadtime:1.2674551010132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterflow' limit 1
loadtime:1.2675220966339 / seconds
Query Executed:select id FROM `nm` where city='Waterflow' && SIC_code='5812'DB:business_master_new
loadtime:1.269268989563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watrous' limit 1
loadtime:1.2693040370941 / seconds
Query Executed:select id FROM `nm` where city='Watrous' && SIC_code='5812'DB:business_master_new
loadtime:1.2697269916534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weed' limit 1
loadtime:1.2697870731354 / seconds
Query Executed:select id FROM `nm` where city='Weed' && SIC_code='5812'DB:business_master_new
loadtime:1.2702031135559 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Sands' limit 1
loadtime:1.2702460289001 / seconds
Query Executed:select id FROM `nm` where city='White Sands' && SIC_code='5812'DB:business_master_new
loadtime:1.270674943924 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Sands Missile Range' limit 1
loadtime:1.2707300186157 / seconds
Query Executed:select id FROM `nm` where city='White Sands Missile Range' && SIC_code='5812'DB:business_master_new
loadtime:1.2724921703339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whites City' limit 1
loadtime:1.2725350856781 / seconds
Query Executed:select id FROM `nm` where city='Whites City' && SIC_code='5812'DB:business_master_new
loadtime:1.272910118103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willard' limit 1
loadtime:1.2729489803314 / seconds
Query Executed:select id FROM `nm` where city='Willard' && SIC_code='5812'DB:business_master_new
loadtime:1.2733020782471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:1.2733540534973 / seconds
Query Executed:select id FROM `nm` where city='Williamsburg' && SIC_code='5812'DB:business_master_new
loadtime:1.2750220298767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winston' limit 1
loadtime:1.2750649452209 / seconds
Query Executed:select id FROM `nm` where city='Winston' && SIC_code='5812'DB:business_master_new
loadtime:1.2766630649567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yatahey' limit 1
loadtime:1.2767100334167 / seconds
Query Executed:select id FROM `nm` where city='Yatahey' && SIC_code='5812'DB:business_master_new
loadtime:1.277153968811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yeso' limit 1
loadtime:1.2771940231323 / seconds
Query Executed:select id FROM `nm` where city='Yeso' && SIC_code='5812'DB:business_master_new
loadtime:1.2775590419769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Youngsville' limit 1
loadtime:1.277606010437 / seconds
Query Executed:select id FROM `nm` where city='Youngsville' && SIC_code='5812'DB:business_master_new
loadtime:1.2778820991516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zuni' limit 1
loadtime:1.277909040451 / seconds
Query Executed:select id FROM `nm` where city='Zuni' && SIC_code='5812'DB:business_master_new
loadtime:1.2797451019287 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.2798581123352 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.2800371646881 / seconds
Operation template executed (chunk cache operation)
loadtime:1.2801139354706 / seconds
template override:Default
loadtime:1.2801320552826 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:1.2809009552002 / seconds
Template Constructed, Array Rows:49
loadtime:1.281152009964 / seconds
TOTAL EXECUTION TIME: 1.28095
loadtime:1.2812571525574 / 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] => eating-places [stateURLid] => new-mexico )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:1.2812621593475
TOTAL KEY ARRAYS: 69