Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:7.3909759521484E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00050497055053711 / seconds
host not found setting manual db connection
loadtime:0.0008537769317627 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0010848045349121 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0012428760528564 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0012907981872559 / seconds
zipcode:
loadtime:0.0013079643249512 / seconds
Query Executed:select * from search_referrer where page_hash='eb58dae59ca3627c45815b83f0d52e40' limit 10 DB:ezrox_toadli
loadtime:0.0015108585357666 / seconds
Operation header executed (non global)
loadtime:0.0015289783477783 / seconds
Operation leaderboard executed (non global)
loadtime:0.0015649795532227 / seconds
Operation square executed (non global)
loadtime:0.0015788078308105 / seconds
Operation square_bottom executed (non global)
loadtime:0.0015909671783447 / seconds
Operation smallsquare executed (non global)
loadtime:0.0016019344329834 / seconds
Operation headeradright executed (non global)
loadtime:0.0016129016876221 / seconds
Operation google_analytics executed (non global)
loadtime:0.0016238689422607 / seconds
Operation topstories executed (non global)
loadtime:0.001633882522583 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0016458034515381 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0016558170318604 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00193190574646 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0020849704742432 / seconds
Operation categories executed (global stored into APC)
loadtime:0.002126932144165 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0021939277648926 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0022289752960205 / seconds
Template key: archive_menu pushed
loadtime:0.0022339820861816 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0022449493408203 / seconds
Template key: get_gravatar pushed
loadtime:0.002249002456665 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0022528171539307 / seconds
*10)-10)+1 | start:0
loadtime:0.0022749900817871 / seconds
Query loaded from cache:select * from categories where cat_URLid='gasoline-service-station'
loadtime:0.0023097991943359 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='arizona'
loadtime:0.002335786819458 / seconds
DB connected to localhost business_master_new
loadtime:0.002633810043335 / seconds
Query Executed:select * from `az_catmap` where sic='5541' order by city ascDB:business_master_new
loadtime:0.15813088417053 / seconds
Query stored in cache : _QUERY_www.toadli.com85e88489d0a133ac533a6521fc3d5dc2
loadtime:0.15862584114075 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='arizona'
loadtime:0.15865588188171 / seconds
Query Executed:select sum(totalcount) as totalsum from `az_catmap` where sic='5541'DB:business_master_new
loadtime:0.16026997566223 / seconds
Query stored in cache : _QUERY_www.toadli.comd2745f7846f4a422ad41b13cc26a5cb6
loadtime:0.16028881072998 / seconds
287 / 11
loadtime:0.16031789779663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aguila' limit 1
loadtime:0.16036581993103 / seconds
Query Executed:select id FROM `az` where city='Aguila' && SIC_code='5541'DB:business_master_new
loadtime:0.17203497886658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ajo' limit 1
loadtime:0.17208790779114 / seconds
Query Executed:select id FROM `az` where city='Ajo' && SIC_code='5541'DB:business_master_new
loadtime:0.17629384994507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpine' limit 1
loadtime:0.17634582519531 / seconds
Query Executed:select id FROM `az` where city='Alpine' && SIC_code='5541'DB:business_master_new
loadtime:0.19152092933655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amado' limit 1
loadtime:0.19156098365784 / seconds
Query Executed:select id FROM `az` where city='Amado' && SIC_code='5541'DB:business_master_new
loadtime:0.20447278022766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anthem' limit 1
loadtime:0.20451378822327 / seconds
Query Executed:select id FROM `az` where city='Anthem' && SIC_code='5541'DB:business_master_new
loadtime:0.2089159488678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Apache Junction' limit 1
loadtime:0.20894598960876 / seconds
Query Executed:select id FROM `az` where city='Apache Junction' && SIC_code='5541'DB:business_master_new
loadtime:0.21242594718933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arivaca' limit 1
loadtime:0.21246790885925 / seconds
Query Executed:select id FROM `az` where city='Arivaca' && SIC_code='5541'DB:business_master_new
loadtime:0.22184896469116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arizona City' limit 1
loadtime:0.22188186645508 / seconds
Query Executed:select id FROM `az` where city='Arizona City' && SIC_code='5541'DB:business_master_new
loadtime:0.23754286766052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.23758697509766 / seconds
Query Executed:select id FROM `az` where city='Arlington' && SIC_code='5541'DB:business_master_new
loadtime:0.24424290657043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ash Fork' limit 1
loadtime:0.24428296089172 / seconds
Query Executed:select id FROM `az` where city='Ash Fork' && SIC_code='5541'DB:business_master_new
loadtime:0.26226091384888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avondale' limit 1
loadtime:0.26232886314392 / seconds
Query Executed:select id FROM `az` where city='Avondale' && SIC_code='5541'DB:business_master_new
loadtime:0.26612496376038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bagdad' limit 1
loadtime:0.26622080802917 / seconds
Query Executed:select id FROM `az` where city='Bagdad' && SIC_code='5541'DB:business_master_new
loadtime:0.27737593650818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bapchule' limit 1
loadtime:0.27741384506226 / seconds
Query Executed:select id FROM `az` where city='Bapchule' && SIC_code='5541'DB:business_master_new
loadtime:0.27792692184448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellemont' limit 1
loadtime:0.27797389030457 / seconds
Query Executed:select id FROM `az` where city='Bellemont' && SIC_code='5541'DB:business_master_new
loadtime:0.28485894203186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benson' limit 1
loadtime:0.28491592407227 / seconds
Query Executed:select id FROM `az` where city='Benson' && SIC_code='5541'DB:business_master_new
loadtime:0.28757286071777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bisbee' limit 1
loadtime:0.28771090507507 / seconds
Query Executed:select id FROM `az` where city='Bisbee' && SIC_code='5541'DB:business_master_new
loadtime:0.29995584487915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Canyon City' limit 1
loadtime:0.30006098747253 / seconds
Query Executed:select id FROM `az` where city='Black Canyon City' && SIC_code='5541'DB:business_master_new
loadtime:0.30206894874573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Cyn City' limit 1
loadtime:0.30215382575989 / seconds
Query Executed:select id FROM `az` where city='Black Cyn City' && SIC_code='5541'DB:business_master_new
loadtime:0.3039858341217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue' limit 1
loadtime:0.30403590202332 / seconds
Query Executed:select id FROM `az` where city='Blue' && SIC_code='5541'DB:business_master_new
loadtime:0.30668687820435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Gap' limit 1
loadtime:0.30673480033875 / seconds
Query Executed:select id FROM `az` where city='Blue Gap' && SIC_code='5541'DB:business_master_new
loadtime:0.30856800079346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bouse' limit 1
loadtime:0.30861282348633 / seconds
Query Executed:select id FROM `az` where city='Bouse' && SIC_code='5541'DB:business_master_new
loadtime:0.31661677360535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowie' limit 1
loadtime:0.31666088104248 / seconds
Query Executed:select id FROM `az` where city='Bowie' && SIC_code='5541'DB:business_master_new
loadtime:0.33291077613831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckeye' limit 1
loadtime:0.33299994468689 / seconds
Query Executed:select id FROM `az` where city='Buckeye' && SIC_code='5541'DB:business_master_new
loadtime:0.33728289604187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bullhead City' limit 1
loadtime:0.33733987808228 / seconds
Query Executed:select id FROM `az` where city='Bullhead City' && SIC_code='5541'DB:business_master_new
loadtime:0.3432559967041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bylas' limit 1
loadtime:0.34337186813354 / seconds
Query Executed:select id FROM `az` where city='Bylas' && SIC_code='5541'DB:business_master_new
loadtime:0.34676194190979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cameron' limit 1
loadtime:0.34682679176331 / seconds
Query Executed:select id FROM `az` where city='Cameron' && SIC_code='5541'DB:business_master_new
loadtime:0.3532338142395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Verde' limit 1
loadtime:0.35326886177063 / seconds
Query Executed:select id FROM `az` where city='Camp Verde' && SIC_code='5541'DB:business_master_new
loadtime:0.3560779094696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carefree' limit 1
loadtime:0.35613894462585 / seconds
Query Executed:select id FROM `az` where city='Carefree' && SIC_code='5541'DB:business_master_new
loadtime:0.35812592506409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casa Grande' limit 1
loadtime:0.35816788673401 / seconds
Query Executed:select id FROM `az` where city='Casa Grande' && SIC_code='5541'DB:business_master_new
loadtime:0.36217498779297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cashion' limit 1
loadtime:0.36223077774048 / seconds
Query Executed:select id FROM `az` where city='Cashion' && SIC_code='5541'DB:business_master_new
loadtime:0.37018990516663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catalina' limit 1
loadtime:0.37024283409119 / seconds
Query Executed:select id FROM `az` where city='Catalina' && SIC_code='5541'DB:business_master_new
loadtime:0.38112497329712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cave Creek' limit 1
loadtime:0.38116478919983 / seconds
Query Executed:select id FROM `az` where city='Cave Creek' && SIC_code='5541'DB:business_master_new
loadtime:0.38338589668274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central' limit 1
loadtime:0.38343191146851 / seconds
Query Executed:select id FROM `az` where city='Central' && SIC_code='5541'DB:business_master_new
loadtime:0.3874340057373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chambers' limit 1
loadtime:0.38747477531433 / seconds
Query Executed:select id FROM `az` where city='Chambers' && SIC_code='5541'DB:business_master_new
loadtime:0.3995578289032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chandler' limit 1
loadtime:0.39961791038513 / seconds
Query Executed:select id FROM `az` where city='Chandler' && SIC_code='5541'DB:business_master_new
loadtime:0.78937292098999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chandler Heights' limit 1
loadtime:0.78952980041504 / seconds
Query Executed:select id FROM `az` where city='Chandler Heights' && SIC_code='5541'DB:business_master_new
loadtime:0.79426193237305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chinle' limit 1
loadtime:0.79429388046265 / seconds
Query Executed:select id FROM `az` where city='Chinle' && SIC_code='5541'DB:business_master_new
loadtime:0.79517078399658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chino Valley' limit 1
loadtime:0.79521989822388 / seconds
Query Executed:select id FROM `az` where city='Chino Valley' && SIC_code='5541'DB:business_master_new
loadtime:0.79622983932495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chloride' limit 1
loadtime:0.79626893997192 / seconds
Query Executed:select id FROM `az` where city='Chloride' && SIC_code='5541'DB:business_master_new
loadtime:0.80027198791504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cibecue' limit 1
loadtime:0.80031299591064 / seconds
Query Executed:select id FROM `az` where city='Cibecue' && SIC_code='5541'DB:business_master_new
loadtime:0.80243897438049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cibola' limit 1
loadtime:0.80246877670288 / seconds
Query Executed:select id FROM `az` where city='Cibola' && SIC_code='5541'DB:business_master_new
loadtime:0.80566883087158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarkdale' limit 1
loadtime:0.80570793151855 / seconds
Query Executed:select id FROM `az` where city='Clarkdale' && SIC_code='5541'DB:business_master_new
loadtime:0.80643796920776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clay Springs' limit 1
loadtime:0.80647277832031 / seconds
Query Executed:select id FROM `az` where city='Clay Springs' && SIC_code='5541'DB:business_master_new
loadtime:0.81233477592468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claypool' limit 1
loadtime:0.81237196922302 / seconds
Query Executed:select id FROM `az` where city='Claypool' && SIC_code='5541'DB:business_master_new
loadtime:0.81311082839966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:0.81315398216248 / seconds
Query Executed:select id FROM `az` where city='Clifton' && SIC_code='5541'DB:business_master_new
loadtime:0.81387400627136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cochise' limit 1
loadtime:0.81390881538391 / seconds
Query Executed:select id FROM `az` where city='Cochise' && SIC_code='5541'DB:business_master_new
loadtime:0.82584285736084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colorado City' limit 1
loadtime:0.82587289810181 / seconds
Query Executed:select id FROM `az` where city='Colorado City' && SIC_code='5541'DB:business_master_new
loadtime:0.82660698890686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concho' limit 1
loadtime:0.82664680480957 / seconds
Query Executed:select id FROM `az` where city='Concho' && SIC_code='5541'DB:business_master_new
loadtime:0.83503389358521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Congress' limit 1
loadtime:0.83507084846497 / seconds
Query Executed:select id FROM `az` where city='Congress' && SIC_code='5541'DB:business_master_new
loadtime:0.84980893135071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coolidge' limit 1
loadtime:0.84985899925232 / seconds
Query Executed:select id FROM `az` where city='Coolidge' && SIC_code='5541'DB:business_master_new
loadtime:0.85065889358521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornville' limit 1
loadtime:0.85070300102234 / seconds
Query Executed:select id FROM `az` where city='Cornville' && SIC_code='5541'DB:business_master_new
loadtime:0.85149478912354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cortaro' limit 1
loadtime:0.85154294967651 / seconds
Query Executed:select id FROM `az` where city='Cortaro' && SIC_code='5541'DB:business_master_new
loadtime:0.86682987213135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottonwood' limit 1
loadtime:0.86687588691711 / seconds
Query Executed:select id FROM `az` where city='Cottonwood' && SIC_code='5541'DB:business_master_new
loadtime:0.86818981170654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crown King' limit 1
loadtime:0.86823987960815 / seconds
Query Executed:select id FROM `az` where city='Crown King' && SIC_code='5541'DB:business_master_new
loadtime:0.87081480026245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dateland' limit 1
loadtime:0.8708508014679 / seconds
Query Executed:select id FROM `az` where city='Dateland' && SIC_code='5541'DB:business_master_new
loadtime:0.87388586997986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis Monthan' limit 1
loadtime:0.87392282485962 / seconds
Query Executed:select id FROM `az` where city='Davis Monthan' && SIC_code='5541'DB:business_master_new
loadtime:0.87458777427673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennehotso' limit 1
loadtime:0.87461185455322 / seconds
Query Executed:select id FROM `az` where city='Dennehotso' && SIC_code='5541'DB:business_master_new
loadtime:0.87758088111877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewey' limit 1
loadtime:0.87762188911438 / seconds
Query Executed:select id FROM `az` where city='Dewey' && SIC_code='5541'DB:business_master_new
loadtime:0.87842798233032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolan Springs' limit 1
loadtime:0.87847280502319 / seconds
Query Executed:select id FROM `az` where city='Dolan Springs' && SIC_code='5541'DB:business_master_new
loadtime:0.89160084724426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douglas' limit 1
loadtime:0.89163589477539 / seconds
Query Executed:select id FROM `az` where city='Douglas' && SIC_code='5541'DB:business_master_new
loadtime:0.89269185066223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dragoon' limit 1
loadtime:0.89273595809937 / seconds
Query Executed:select id FROM `az` where city='Dragoon' && SIC_code='5541'DB:business_master_new
loadtime:0.89849781990051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duncan' limit 1
loadtime:0.89853596687317 / seconds
Query Executed:select id FROM `az` where city='Duncan' && SIC_code='5541'DB:business_master_new
loadtime:0.89928579330444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagar' limit 1
loadtime:0.89933085441589 / seconds
Query Executed:select id FROM `az` where city='Eagar' && SIC_code='5541'DB:business_master_new
loadtime:0.90009093284607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.90013194084167 / seconds
Query Executed:select id FROM `az` where city='Eden' && SIC_code='5541'DB:business_master_new
loadtime:0.90090394020081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ehrenberg' limit 1
loadtime:0.90093898773193 / seconds
Query Executed:select id FROM `az` where city='Ehrenberg' && SIC_code='5541'DB:business_master_new
loadtime:0.90170693397522 / seconds
Query loaded from cache:select * from geodata_geocity where city='El Mirage' limit 1
loadtime:0.90174698829651 / seconds
Query Executed:select id FROM `az` where city='El Mirage' && SIC_code='5541'DB:business_master_new
loadtime:0.90257883071899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elfrida' limit 1
loadtime:0.90261387825012 / seconds
Query Executed:select id FROM `az` where city='Elfrida' && SIC_code='5541'DB:business_master_new
loadtime:0.90333795547485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elgin' limit 1
loadtime:0.90337777137756 / seconds
Query Executed:select id FROM `az` where city='Elgin' && SIC_code='5541'DB:business_master_new
loadtime:0.90854096412659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eloy' limit 1
loadtime:0.90856981277466 / seconds
Query Executed:select id FROM `az` where city='Eloy' && SIC_code='5541'DB:business_master_new
loadtime:0.90929198265076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flagstaff' limit 1
loadtime:0.90933680534363 / seconds
Query Executed:select id FROM `az` where city='Flagstaff' && SIC_code='5541'DB:business_master_new
loadtime:0.91936683654785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.91943693161011 / seconds
Query Executed:select id FROM `az` where city='Florence' && SIC_code='5541'DB:business_master_new
loadtime:0.92015695571899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest Lakes' limit 1
loadtime:0.9201979637146 / seconds
Query Executed:select id FROM `az` where city='Forest Lakes' && SIC_code='5541'DB:business_master_new
loadtime:0.92814993858337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Apache' limit 1
loadtime:0.92818093299866 / seconds
Query Executed:select id FROM `az` where city='Fort Apache' && SIC_code='5541'DB:business_master_new
loadtime:0.92920780181885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Defiance' limit 1
loadtime:0.92924690246582 / seconds
Query Executed:select id FROM `az` where city='Fort Defiance' && SIC_code='5541'DB:business_master_new
loadtime:0.92999291419983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Huachuca' limit 1
loadtime:0.9300229549408 / seconds
Query Executed:select id FROM `az` where city='Fort Huachuca' && SIC_code='5541'DB:business_master_new
loadtime:0.93071389198303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mcdowell' limit 1
loadtime:0.9307599067688 / seconds
Query Executed:select id FROM `az` where city='Fort Mcdowell' && SIC_code='5541'DB:business_master_new
loadtime:0.93708491325378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mohave' limit 1
loadtime:0.93714284896851 / seconds
Query Executed:select id FROM `az` where city='Fort Mohave' && SIC_code='5541'DB:business_master_new
loadtime:0.93806600570679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Thomas' limit 1
loadtime:0.93810987472534 / seconds
Query Executed:select id FROM `az` where city='Fort Thomas' && SIC_code='5541'DB:business_master_new
loadtime:0.94369888305664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain Hills' limit 1
loadtime:0.94375085830688 / seconds
Query Executed:select id FROM `az` where city='Fountain Hills' && SIC_code='5541'DB:business_master_new
loadtime:0.94507384300232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredonia' limit 1
loadtime:0.94513487815857 / seconds
Query Executed:select id FROM `az` where city='Fredonia' && SIC_code='5541'DB:business_master_new
loadtime:0.94590282440186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gadsden' limit 1
loadtime:0.94596195220947 / seconds
Query Executed:select id FROM `az` where city='Gadsden' && SIC_code='5541'DB:business_master_new
loadtime:0.94795179367065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ganado' limit 1
loadtime:0.9479877948761 / seconds
Query Executed:select id FROM `az` where city='Ganado' && SIC_code='5541'DB:business_master_new
loadtime:0.94870686531067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gila Bend' limit 1
loadtime:0.94876480102539 / seconds
Query Executed:select id FROM `az` where city='Gila Bend' && SIC_code='5541'DB:business_master_new
loadtime:0.94961595535278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbert' limit 1
loadtime:0.94967699050903 / seconds
Query Executed:select id FROM `az` where city='Gilbert' && SIC_code='5541'DB:business_master_new
loadtime:0.95947480201721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1
loadtime:0.95968079566956 / seconds
Query Executed:select id FROM `az` where city='Glendale' && SIC_code='5541'DB:business_master_new
loadtime:0.96903586387634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Globe' limit 1
loadtime:0.96911597251892 / seconds
Query Executed:select id FROM `az` where city='Globe' && SIC_code='5541'DB:business_master_new
loadtime:0.97019290924072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Golden Valley' limit 1
loadtime:0.97025799751282 / seconds
Query Executed:select id FROM `az` where city='Golden Valley' && SIC_code='5541'DB:business_master_new
loadtime:0.97107291221619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodyear' limit 1
loadtime:0.97113990783691 / seconds
Query Executed:select id FROM `az` where city='Goodyear' && SIC_code='5541'DB:business_master_new
loadtime:0.9722638130188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Canyon' limit 1
loadtime:0.97232294082642 / seconds
Query Executed:select id FROM `az` where city='Grand Canyon' && SIC_code='5541'DB:business_master_new
loadtime:0.97308683395386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gray Mountain' limit 1
loadtime:0.97313094139099 / seconds
Query Executed:select id FROM `az` where city='Gray Mountain' && SIC_code='5541'DB:business_master_new
loadtime:0.97448778152466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Valley' limit 1
loadtime:0.97453689575195 / seconds
Query Executed:select id FROM `az` where city='Green Valley' && SIC_code='5541'DB:business_master_new
loadtime:0.97556400299072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenehaven' limit 1
loadtime:0.97562384605408 / seconds
Query Executed:select id FROM `az` where city='Greenehaven' && SIC_code='5541'DB:business_master_new
loadtime:0.97657489776611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greer' limit 1
loadtime:0.97662997245789 / seconds
Query Executed:select id FROM `az` where city='Greer' && SIC_code='5541'DB:business_master_new
loadtime:0.97739291191101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guadalupe' limit 1
loadtime:0.97752785682678 / seconds
Query Executed:select id FROM `az` where city='Guadalupe' && SIC_code='5541'DB:business_master_new
loadtime:0.98232388496399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hackberry' limit 1
loadtime:0.98237991333008 / seconds
Query Executed:select id FROM `az` where city='Hackberry' && SIC_code='5541'DB:business_master_new
loadtime:0.98332595825195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Happy Jack' limit 1
loadtime:0.98336982727051 / seconds
Query Executed:select id FROM `az` where city='Happy Jack' && SIC_code='5541'DB:business_master_new
loadtime:0.99082779884338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayden' limit 1
loadtime:0.99087285995483 / seconds
Query Executed:select id FROM `az` where city='Hayden' && SIC_code='5541'DB:business_master_new
loadtime:1.0002617835999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heber' limit 1
loadtime:1.000305891037 / seconds
Query Executed:select id FROM `az` where city='Heber' && SIC_code='5541'DB:business_master_new
loadtime:1.0110008716583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hereford' limit 1
loadtime:1.0110559463501 / seconds
Query Executed:select id FROM `az` where city='Hereford' && SIC_code='5541'DB:business_master_new
loadtime:1.0118417739868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Higley' limit 1
loadtime:1.0118777751923 / seconds
Query Executed:select id FROM `az` where city='Higley' && SIC_code='5541'DB:business_master_new
loadtime:1.0126738548279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holbrook' limit 1
loadtime:1.012717962265 / seconds
Query Executed:select id FROM `az` where city='Holbrook' && SIC_code='5541'DB:business_master_new
loadtime:1.0136058330536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hotevilla' limit 1
loadtime:1.0136549472809 / seconds
Query Executed:select id FROM `az` where city='Hotevilla' && SIC_code='5541'DB:business_master_new
loadtime:1.0160808563232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houck' limit 1
loadtime:1.0161228179932 / seconds
Query Executed:select id FROM `az` where city='Houck' && SIC_code='5541'DB:business_master_new
loadtime:1.020026922226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huachuca City' limit 1
loadtime:1.0200548171997 / seconds
Query Executed:select id FROM `az` where city='Huachuca City' && SIC_code='5541'DB:business_master_new
loadtime:1.020828962326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hualapai' limit 1
loadtime:1.0208759307861 / seconds
Query Executed:select id FROM `az` where city='Hualapai' && SIC_code='5541'DB:business_master_new
loadtime:1.0224359035492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humboldt' limit 1
loadtime:1.0224778652191 / seconds
Query Executed:select id FROM `az` where city='Humboldt' && SIC_code='5541'DB:business_master_new
loadtime:1.0232079029083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Wells' limit 1
loadtime:1.0232448577881 / seconds
Query Executed:select id FROM `az` where city='Indian Wells' && SIC_code='5541'DB:business_master_new
loadtime:1.0249128341675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Springs' limit 1
loadtime:1.0249538421631 / seconds
Query Executed:select id FROM `az` where city='Iron Springs' && SIC_code='5541'DB:business_master_new
loadtime:1.0258378982544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jerome' limit 1
loadtime:1.0258779525757 / seconds
Query Executed:select id FROM `az` where city='Jerome' && SIC_code='5541'DB:business_master_new
loadtime:1.026556968689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joseph City' limit 1
loadtime:1.0265829563141 / seconds
Query Executed:select id FROM `az` where city='Joseph City' && SIC_code='5541'DB:business_master_new
loadtime:1.0358128547668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaibeto' limit 1
loadtime:1.0358669757843 / seconds
Query Executed:select id FROM `az` where city='Kaibeto' && SIC_code='5541'DB:business_master_new
loadtime:1.0376899242401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaibito' limit 1
loadtime:1.0377187728882 / seconds
Query Executed:select id FROM `az` where city='Kaibito' && SIC_code='5541'DB:business_master_new
loadtime:1.0379819869995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kayenta' limit 1
loadtime:1.0380229949951 / seconds
Query Executed:select id FROM `az` where city='Kayenta' && SIC_code='5541'DB:business_master_new
loadtime:1.0387308597565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keams Canyon' limit 1
loadtime:1.0387859344482 / seconds
Query Executed:select id FROM `az` where city='Keams Canyon' && SIC_code='5541'DB:business_master_new
loadtime:1.0723478794098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kearny' limit 1
loadtime:1.0723919868469 / seconds
Query Executed:select id FROM `az` where city='Kearny' && SIC_code='5541'DB:business_master_new
loadtime:1.0806219577789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingman' limit 1
loadtime:1.0806698799133 / seconds
Query Executed:select id FROM `az` where city='Kingman' && SIC_code='5541'DB:business_master_new
loadtime:1.0823509693146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirkland' limit 1
loadtime:1.0824158191681 / seconds
Query Executed:select id FROM `az` where city='Kirkland' && SIC_code='5541'DB:business_master_new
loadtime:1.0927000045776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kykotsmovi Village' limit 1
loadtime:1.0927448272705 / seconds
Query Executed:select id FROM `az` where city='Kykotsmovi Village' && SIC_code='5541'DB:business_master_new
loadtime:1.1018707752228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kykotsmovi Vlg' limit 1
loadtime:1.1019217967987 / seconds
Query Executed:select id FROM `az` where city='Kykotsmovi Vlg' && SIC_code='5541'DB:business_master_new
loadtime:1.1022667884827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Havasu City' limit 1
loadtime:1.1023018360138 / seconds
Query Executed:select id FROM `az` where city='Lake Havasu City' && SIC_code='5541'DB:business_master_new
loadtime:1.1042649745941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Montezuma' limit 1
loadtime:1.1043238639832 / seconds
Query Executed:select id FROM `az` where city='Lake Montezuma' && SIC_code='5541'DB:business_master_new
loadtime:1.1095287799835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeside' limit 1
loadtime:1.1095697879791 / seconds
Query Executed:select id FROM `az` where city='Lakeside' && SIC_code='5541'DB:business_master_new
loadtime:1.1104338169098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laveen' limit 1
loadtime:1.1104688644409 / seconds
Query Executed:select id FROM `az` where city='Laveen' && SIC_code='5541'DB:business_master_new
loadtime:1.1112949848175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leupp' limit 1
loadtime:1.1113348007202 / seconds
Query Executed:select id FROM `az` where city='Leupp' && SIC_code='5541'DB:business_master_new
loadtime:1.1152558326721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield Park' limit 1
loadtime:1.1153028011322 / seconds
Query Executed:select id FROM `az` where city='Litchfield Park' && SIC_code='5541'DB:business_master_new
loadtime:1.1162669658661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littlefield' limit 1
loadtime:1.1163008213043 / seconds
Query Executed:select id FROM `az` where city='Littlefield' && SIC_code='5541'DB:business_master_new
loadtime:1.1277430057526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lukachukai' limit 1
loadtime:1.1278038024902 / seconds
Query Executed:select id FROM `az` where city='Lukachukai' && SIC_code='5541'DB:business_master_new
loadtime:1.1296119689941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luke Afb' limit 1
loadtime:1.1296467781067 / seconds
Query Executed:select id FROM `az` where city='Luke Afb' && SIC_code='5541'DB:business_master_new
loadtime:1.1402277946472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lukeville' limit 1
loadtime:1.1402750015259 / seconds
Query Executed:select id FROM `az` where city='Lukeville' && SIC_code='5541'DB:business_master_new
loadtime:1.1436448097229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lupton' limit 1
loadtime:1.1436948776245 / seconds
Query Executed:select id FROM `az` where city='Lupton' && SIC_code='5541'DB:business_master_new
loadtime:1.150593996048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madera Canyon' limit 1
loadtime:1.1506547927856 / seconds
Query Executed:select id FROM `az` where city='Madera Canyon' && SIC_code='5541'DB:business_master_new
loadtime:1.1509568691254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mammoth' limit 1
loadtime:1.150985956192 / seconds
Query Executed:select id FROM `az` where city='Mammoth' && SIC_code='5541'DB:business_master_new
loadtime:1.1553809642792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Many Farms' limit 1
loadtime:1.155425786972 / seconds
Query Executed:select id FROM `az` where city='Many Farms' && SIC_code='5541'DB:business_master_new
loadtime:1.1599278450012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marana' limit 1
loadtime:1.1599760055542 / seconds
Query Executed:select id FROM `az` where city='Marana' && SIC_code='5541'DB:business_master_new
loadtime:1.1608870029449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble Canyon' limit 1
loadtime:1.160927772522 / seconds
Query Executed:select id FROM `az` where city='Marble Canyon' && SIC_code='5541'DB:business_master_new
loadtime:1.1651408672333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maricopa' limit 1
loadtime:1.1651899814606 / seconds
Query Executed:select id FROM `az` where city='Maricopa' && SIC_code='5541'DB:business_master_new
loadtime:1.1659529209137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayer' limit 1
loadtime:1.1659979820251 / seconds
Query Executed:select id FROM `az` where city='Mayer' && SIC_code='5541'DB:business_master_new
loadtime:1.1667947769165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Nary' limit 1
loadtime:1.1668469905853 / seconds
Query Executed:select id FROM `az` where city='Mc Nary' && SIC_code='5541'DB:business_master_new
loadtime:1.167172908783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Neal' limit 1
loadtime:1.1672248840332 / seconds
Query Executed:select id FROM `az` where city='Mc Neal' && SIC_code='5541'DB:business_master_new
loadtime:1.1741278171539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mcnary' limit 1
loadtime:1.1741628646851 / seconds
Query Executed:select id FROM `az` where city='Mcnary' && SIC_code='5541'DB:business_master_new
loadtime:1.1773278713226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadview' limit 1
loadtime:1.177414894104 / seconds
Query Executed:select id FROM `az` where city='Meadview' && SIC_code='5541'DB:business_master_new
loadtime:1.1874778270721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesa' limit 1
loadtime:1.1875247955322 / seconds
Query Executed:select id FROM `az` where city='Mesa' && SIC_code='5541'DB:business_master_new
loadtime:1.1975748538971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miami' limit 1
loadtime:1.1976947784424 / seconds
Query Executed:select id FROM `az` where city='Miami' && SIC_code='5541'DB:business_master_new
loadtime:1.1985039710999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mohave Valley' limit 1
loadtime:1.1985678672791 / seconds
Query Executed:select id FROM `az` where city='Mohave Valley' && SIC_code='5541'DB:business_master_new
loadtime:1.1994819641113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morenci' limit 1
loadtime:1.1995849609375 / seconds
Query Executed:select id FROM `az` where city='Morenci' && SIC_code='5541'DB:business_master_new
loadtime:1.2130589485168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mormon Lake' limit 1
loadtime:1.2131018638611 / seconds
Query Executed:select id FROM `az` where city='Mormon Lake' && SIC_code='5541'DB:business_master_new
loadtime:1.2172789573669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morristown' limit 1
loadtime:1.21732878685 / seconds
Query Executed:select id FROM `az` where city='Morristown' && SIC_code='5541'DB:business_master_new
loadtime:1.2273418903351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Lemmon' limit 1
loadtime:1.227395772934 / seconds
Query Executed:select id FROM `az` where city='Mount Lemmon' && SIC_code='5541'DB:business_master_new
loadtime:1.2324719429016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Lemmon' limit 1
loadtime:1.2325139045715 / seconds
Query Executed:select id FROM `az` where city='Mt Lemmon' && SIC_code='5541'DB:business_master_new
loadtime:1.233057975769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munds Park' limit 1
loadtime:1.2331068515778 / seconds
Query Executed:select id FROM `az` where city='Munds Park' && SIC_code='5541'DB:business_master_new
loadtime:1.2439458370209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naco' limit 1
loadtime:1.2439978122711 / seconds
Query Executed:select id FROM `az` where city='Naco' && SIC_code='5541'DB:business_master_new
loadtime:1.256865978241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nazlini' limit 1
loadtime:1.2569289207458 / seconds
Query Executed:select id FROM `az` where city='Nazlini' && SIC_code='5541'DB:business_master_new
loadtime:1.2582669258118 / seconds
Query loaded from cache:select * from geodata_geocity where city='New River' limit 1
loadtime:1.2583138942719 / seconds
Query Executed:select id FROM `az` where city='New River' && SIC_code='5541'DB:business_master_new
loadtime:1.2591187953949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nogales' limit 1
loadtime:1.2591648101807 / seconds
Query Executed:select id FROM `az` where city='Nogales' && SIC_code='5541'DB:business_master_new
loadtime:1.2605619430542 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Rim' limit 1
loadtime:1.2606248855591 / seconds
Query Executed:select id FROM `az` where city='North Rim' && SIC_code='5541'DB:business_master_new
loadtime:1.2613987922668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nutrioso' limit 1
loadtime:1.2614288330078 / seconds
Query Executed:select id FROM `az` where city='Nutrioso' && SIC_code='5541'DB:business_master_new
loadtime:1.2653148174286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oatman' limit 1
loadtime:1.2653579711914 / seconds
Query Executed:select id FROM `az` where city='Oatman' && SIC_code='5541'DB:business_master_new
loadtime:1.2767457962036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oracle' limit 1
loadtime:1.2767899036407 / seconds
Query Executed:select id FROM `az` where city='Oracle' && SIC_code='5541'DB:business_master_new
loadtime:1.2852149009705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oro Valley' limit 1
loadtime:1.2852628231049 / seconds
Query Executed:select id FROM `az` where city='Oro Valley' && SIC_code='5541'DB:business_master_new
loadtime:1.2862858772278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Overgaard' limit 1
loadtime:1.2863309383392 / seconds
Query Executed:select id FROM `az` where city='Overgaard' && SIC_code='5541'DB:business_master_new
loadtime:1.2874629497528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Page' limit 1
loadtime:1.2874989509583 / seconds
Query Executed:select id FROM `az` where city='Page' && SIC_code='5541'DB:business_master_new
loadtime:1.2890529632568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palo Verde' limit 1
loadtime:1.289137840271 / seconds
Query Executed:select id FROM `az` where city='Palo Verde' && SIC_code='5541'DB:business_master_new
loadtime:1.2923679351807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paradise Valley' limit 1
loadtime:1.2924048900604 / seconds
Query Executed:select id FROM `az` where city='Paradise Valley' && SIC_code='5541'DB:business_master_new
loadtime:1.2936019897461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parker' limit 1
loadtime:1.293646812439 / seconds
Query Executed:select id FROM `az` where city='Parker' && SIC_code='5541'DB:business_master_new
loadtime:1.2946979999542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parks' limit 1
loadtime:1.2947418689728 / seconds
Query Executed:select id FROM `az` where city='Parks' && SIC_code='5541'DB:business_master_new
loadtime:1.302524805069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parks Community Post Office' limit 1
loadtime:1.3025579452515 / seconds
Query Executed:select id FROM `az` where city='Parks Community Post Office' && SIC_code='5541'DB:business_master_new
loadtime:1.302848815918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patagonia' limit 1
loadtime:1.3028857707977 / seconds
Query Executed:select id FROM `az` where city='Patagonia' && SIC_code='5541'DB:business_master_new
loadtime:1.3036139011383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paulden' limit 1
loadtime:1.3036508560181 / seconds
Query Executed:select id FROM `az` where city='Paulden' && SIC_code='5541'DB:business_master_new
loadtime:1.3043458461761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Payson' limit 1
loadtime:1.3043818473816 / seconds
Query Executed:select id FROM `az` where city='Payson' && SIC_code='5541'DB:business_master_new
loadtime:1.3057329654694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peach Springs' limit 1
loadtime:1.3057878017426 / seconds
Query Executed:select id FROM `az` where city='Peach Springs' && SIC_code='5541'DB:business_master_new
loadtime:1.3148319721222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearce' limit 1
loadtime:1.3148629665375 / seconds
Query Executed:select id FROM `az` where city='Pearce' && SIC_code='5541'DB:business_master_new
loadtime:1.3155889511108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peeples Valley' limit 1
loadtime:1.3156249523163 / seconds
Query Executed:select id FROM `az` where city='Peeples Valley' && SIC_code='5541'DB:business_master_new
loadtime:1.3158988952637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peoria' limit 1
loadtime:1.3159348964691 / seconds
Query Executed:select id FROM `az` where city='Peoria' && SIC_code='5541'DB:business_master_new
loadtime:1.3179578781128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peridot' limit 1
loadtime:1.3179929256439 / seconds
Query Executed:select id FROM `az` where city='Peridot' && SIC_code='5541'DB:business_master_new
loadtime:1.3237869739532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pet Frst Natl Pk' limit 1
loadtime:1.3238308429718 / seconds
Query Executed:select id FROM `az` where city='Pet Frst Natl Pk' && SIC_code='5541'DB:business_master_new
loadtime:1.3240919113159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petrified Forest Natl Pk' limit 1
loadtime:1.3241260051727 / seconds
Query Executed:select id FROM `az` where city='Petrified Forest Natl Pk' && SIC_code='5541'DB:business_master_new
loadtime:1.3257389068604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phoenix' limit 1
loadtime:1.3257818222046 / seconds
Query Executed:select id FROM `az` where city='Phoenix' && SIC_code='5541'DB:business_master_new
loadtime:1.3359079360962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Picacho' limit 1
loadtime:1.3360838890076 / seconds
Query Executed:select id FROM `az` where city='Picacho' && SIC_code='5541'DB:business_master_new
loadtime:1.3387868404388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pima' limit 1
loadtime:1.3388350009918 / seconds
Query Executed:select id FROM `az` where city='Pima' && SIC_code='5541'DB:business_master_new
loadtime:1.3395788669586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine' limit 1
loadtime:1.3396029472351 / seconds
Query Executed:select id FROM `az` where city='Pine' && SIC_code='5541'DB:business_master_new
loadtime:1.3403840065002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinedale' limit 1
loadtime:1.3404338359833 / seconds
Query Executed:select id FROM `az` where city='Pinedale' && SIC_code='5541'DB:business_master_new
loadtime:1.3425269126892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinetop' limit 1
loadtime:1.3425848484039 / seconds
Query Executed:select id FROM `az` where city='Pinetop' && SIC_code='5541'DB:business_master_new
loadtime:1.3434638977051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinon' limit 1
loadtime:1.3435227870941 / seconds
Query Executed:select id FROM `az` where city='Pinon' && SIC_code='5541'DB:business_master_new
loadtime:1.3458938598633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pirtleville' limit 1
loadtime:1.3459348678589 / seconds
Query Executed:select id FROM `az` where city='Pirtleville' && SIC_code='5541'DB:business_master_new
loadtime:1.3506088256836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polacca' limit 1
loadtime:1.3506579399109 / seconds
Query Executed:select id FROM `az` where city='Polacca' && SIC_code='5541'DB:business_master_new
loadtime:1.3544688224792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomerene' limit 1
loadtime:1.3545188903809 / seconds
Query Executed:select id FROM `az` where city='Pomerene' && SIC_code='5541'DB:business_master_new
loadtime:1.3553049564362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portal' limit 1
loadtime:1.3553388118744 / seconds
Query Executed:select id FROM `az` where city='Portal' && SIC_code='5541'DB:business_master_new
loadtime:1.3588809967041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poston' limit 1
loadtime:1.3589317798615 / seconds
Query Executed:select id FROM `az` where city='Poston' && SIC_code='5541'DB:business_master_new
loadtime:1.3629558086395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott' limit 1
loadtime:1.3630058765411 / seconds
Query Executed:select id FROM `az` where city='Prescott' && SIC_code='5541'DB:business_master_new
loadtime:1.3651218414307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott Valley' limit 1
loadtime:1.3651638031006 / seconds
Query Executed:select id FROM `az` where city='Prescott Valley' && SIC_code='5541'DB:business_master_new
loadtime:1.3664829730988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quartzsite' limit 1
loadtime:1.3665418624878 / seconds
Query Executed:select id FROM `az` where city='Quartzsite' && SIC_code='5541'DB:business_master_new
loadtime:1.3674998283386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Queen Creek' limit 1
loadtime:1.3675518035889 / seconds
Query Executed:select id FROM `az` where city='Queen Creek' && SIC_code='5541'DB:business_master_new
loadtime:1.3685839176178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Rock' limit 1
loadtime:1.368644952774 / seconds
Query Executed:select id FROM `az` where city='Red Rock' && SIC_code='5541'DB:business_master_new
loadtime:1.3703968524933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Valley' limit 1
loadtime:1.3704409599304 / seconds
Query Executed:select id FROM `az` where city='Red Valley' && SIC_code='5541'DB:business_master_new
loadtime:1.3721017837524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rillito' limit 1
loadtime:1.3721349239349 / seconds
Query Executed:select id FROM `az` where city='Rillito' && SIC_code='5541'DB:business_master_new
loadtime:1.3756737709045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rimrock' limit 1
loadtime:1.3757228851318 / seconds
Query Executed:select id FROM `az` where city='Rimrock' && SIC_code='5541'DB:business_master_new
loadtime:1.3764748573303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio Rico' limit 1
loadtime:1.3765227794647 / seconds
Query Executed:select id FROM `az` where city='Rio Rico' && SIC_code='5541'DB:business_master_new
loadtime:1.3773519992828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio Verde' limit 1
loadtime:1.3774118423462 / seconds
Query Executed:select id FROM `az` where city='Rio Verde' && SIC_code='5541'DB:business_master_new
loadtime:1.3855378627777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Point' limit 1
loadtime:1.3855738639832 / seconds
Query Executed:select id FROM `az` where city='Rock Point' && SIC_code='5541'DB:business_master_new
loadtime:1.3873558044434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roll' limit 1
loadtime:1.3874077796936 / seconds
Query Executed:select id FROM `az` where city='Roll' && SIC_code='5541'DB:business_master_new
loadtime:1.3925459384918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roosevelt' limit 1
loadtime:1.392678976059 / seconds
Query Executed:select id FROM `az` where city='Roosevelt' && SIC_code='5541'DB:business_master_new
loadtime:1.4065418243408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Round Rock' limit 1
loadtime:1.4065828323364 / seconds
Query Executed:select id FROM `az` where city='Round Rock' && SIC_code='5541'DB:business_master_new
loadtime:1.407655954361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sacaton' limit 1
loadtime:1.4076998233795 / seconds
Query Executed:select id FROM `az` where city='Sacaton' && SIC_code='5541'DB:business_master_new
loadtime:1.4160449504852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Safford' limit 1
loadtime:1.4161069393158 / seconds
Query Executed:select id FROM `az` where city='Safford' && SIC_code='5541'DB:business_master_new
loadtime:1.4172489643097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sahuarita' limit 1
loadtime:1.4172899723053 / seconds
Query Executed:select id FROM `az` where city='Sahuarita' && SIC_code='5541'DB:business_master_new
loadtime:1.4180929660797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint David' limit 1
loadtime:1.4181578159332 / seconds
Query Executed:select id FROM `az` where city='Saint David' && SIC_code='5541'DB:business_master_new
loadtime:1.4188668727875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johns' limit 1
loadtime:1.4189209938049 / seconds
Query Executed:select id FROM `az` where city='Saint Johns' && SIC_code='5541'DB:business_master_new
loadtime:1.4197897911072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Michaels' limit 1
loadtime:1.4198389053345 / seconds
Query Executed:select id FROM `az` where city='Saint Michaels' && SIC_code='5541'DB:business_master_new
loadtime:1.4242639541626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salome' limit 1
loadtime:1.4243137836456 / seconds
Query Executed:select id FROM `az` where city='Salome' && SIC_code='5541'DB:business_master_new
loadtime:1.4251208305359 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Carlos' limit 1
loadtime:1.4251708984375 / seconds
Query Executed:select id FROM `az` where city='San Carlos' && SIC_code='5541'DB:business_master_new
loadtime:1.4258878231049 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Luis' limit 1
loadtime:1.4259359836578 / seconds
Query Executed:select id FROM `az` where city='San Luis' && SIC_code='5541'DB:business_master_new
loadtime:1.426698923111 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Manuel' limit 1
loadtime:1.4267427921295 / seconds
Query Executed:select id FROM `az` where city='San Manuel' && SIC_code='5541'DB:business_master_new
loadtime:1.4383189678192 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Simon' limit 1
loadtime:1.4383769035339 / seconds
Query Executed:select id FROM `az` where city='San Simon' && SIC_code='5541'DB:business_master_new
loadtime:1.450865983963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanders' limit 1
loadtime:1.4509258270264 / seconds
Query Executed:select id FROM `az` where city='Sanders' && SIC_code='5541'DB:business_master_new
loadtime:1.4517359733582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sasabe' limit 1
loadtime:1.4517979621887 / seconds
Query Executed:select id FROM `az` where city='Sasabe' && SIC_code='5541'DB:business_master_new
loadtime:1.4549698829651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottsdale' limit 1
loadtime:1.4550189971924 / seconds
Query Executed:select id FROM `az` where city='Scottsdale' && SIC_code='5541'DB:business_master_new
loadtime:1.4650559425354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Second Mesa' limit 1
loadtime:1.4651417732239 / seconds
Query Executed:select id FROM `az` where city='Second Mesa' && SIC_code='5541'DB:business_master_new
loadtime:1.4718549251556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedona' limit 1
loadtime:1.4719059467316 / seconds
Query Executed:select id FROM `az` where city='Sedona' && SIC_code='5541'DB:business_master_new
loadtime:1.4752328395844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seligman' limit 1
loadtime:1.4752798080444 / seconds
Query Executed:select id FROM `az` where city='Seligman' && SIC_code='5541'DB:business_master_new
loadtime:1.4761128425598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sells' limit 1
loadtime:1.4761729240417 / seconds
Query Executed:select id FROM `az` where city='Sells' && SIC_code='5541'DB:business_master_new
loadtime:1.476931810379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shonto' limit 1
loadtime:1.4769859313965 / seconds
Query Executed:select id FROM `az` where city='Shonto' && SIC_code='5541'DB:business_master_new
loadtime:1.4804608821869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shonto Community Post Office' limit 1
loadtime:1.4805088043213 / seconds
Query Executed:select id FROM `az` where city='Shonto Community Post Office' && SIC_code='5541'DB:business_master_new
loadtime:1.480789899826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Show Low' limit 1
loadtime:1.480831861496 / seconds
Query Executed:select id FROM `az` where city='Show Low' && SIC_code='5541'DB:business_master_new
loadtime:1.4819099903107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sierra Vista' limit 1
loadtime:1.4819619655609 / seconds
Query Executed:select id FROM `az` where city='Sierra Vista' && SIC_code='5541'DB:business_master_new
loadtime:1.4835398197174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skull Valley' limit 1
loadtime:1.4835939407349 / seconds
Query Executed:select id FROM `az` where city='Skull Valley' && SIC_code='5541'DB:business_master_new
loadtime:1.4914019107819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snowflake' limit 1
loadtime:1.4914519786835 / seconds
Query Executed:select id FROM `az` where city='Snowflake' && SIC_code='5541'DB:business_master_new
loadtime:1.4923098087311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Solomon' limit 1
loadtime:1.4923708438873 / seconds
Query Executed:select id FROM `az` where city='Solomon' && SIC_code='5541'DB:business_master_new
loadtime:1.4963557720184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerton' limit 1
loadtime:1.4963989257812 / seconds
Query Executed:select id FROM `az` where city='Somerton' && SIC_code='5541'DB:business_master_new
loadtime:1.4971768856049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sonoita' limit 1
loadtime:1.4972319602966 / seconds
Query Executed:select id FROM `az` where city='Sonoita' && SIC_code='5541'DB:business_master_new
loadtime:1.4979619979858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springerville' limit 1
loadtime:1.4980177879333 / seconds
Query Executed:select id FROM `az` where city='Springerville' && SIC_code='5541'DB:business_master_new
loadtime:1.4988558292389 / seconds
Query loaded from cache:select * from geodata_geocity where city='St David' limit 1
loadtime:1.4989149570465 / seconds
Query Executed:select id FROM `az` where city='St David' && SIC_code='5541'DB:business_master_new
loadtime:1.4992477893829 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johns' limit 1
loadtime:1.4992887973785 / seconds
Query Executed:select id FROM `az` where city='St Johns' && SIC_code='5541'DB:business_master_new
loadtime:1.5004258155823 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Michaels' limit 1
loadtime:1.5004758834839 / seconds
Query Executed:select id FROM `az` where city='St Michaels' && SIC_code='5541'DB:business_master_new
loadtime:1.5049200057983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanfield' limit 1
loadtime:1.5049769878387 / seconds
Query Executed:select id FROM `az` where city='Stanfield' && SIC_code='5541'DB:business_master_new
loadtime:1.5098609924316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strawberry' limit 1
loadtime:1.509917974472 / seconds
Query Executed:select id FROM `az` where city='Strawberry' && SIC_code='5541'DB:business_master_new
loadtime:1.5132648944855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun City' limit 1
loadtime:1.5133137702942 / seconds
Query Executed:select id FROM `az` where city='Sun City' && SIC_code='5541'DB:business_master_new
loadtime:1.5147860050201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun City West' limit 1
loadtime:1.5148348808289 / seconds
Query Executed:select id FROM `az` where city='Sun City West' && SIC_code='5541'DB:business_master_new
loadtime:1.5157959461212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun Lakes' limit 1
loadtime:1.5158557891846 / seconds
Query Executed:select id FROM `az` where city='Sun Lakes' && SIC_code='5541'DB:business_master_new
loadtime:1.5184798240662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun Valley' limit 1
loadtime:1.5185208320618 / seconds
Query Executed:select id FROM `az` where city='Sun Valley' && SIC_code='5541'DB:business_master_new
loadtime:1.519987821579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Supai' limit 1
loadtime:1.520035982132 / seconds
Query Executed:select id FROM `az` where city='Supai' && SIC_code='5541'DB:business_master_new
loadtime:1.5222787857056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Superior' limit 1
loadtime:1.5223259925842 / seconds
Query Executed:select id FROM `az` where city='Superior' && SIC_code='5541'DB:business_master_new
loadtime:1.5283088684082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surprise' limit 1
loadtime:1.528354883194 / seconds
Query Executed:select id FROM `az` where city='Surprise' && SIC_code='5541'DB:business_master_new
loadtime:1.529599905014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tacna' limit 1
loadtime:1.5296518802643 / seconds
Query Executed:select id FROM `az` where city='Tacna' && SIC_code='5541'DB:business_master_new
loadtime:1.5319538116455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylor' limit 1
loadtime:1.5320019721985 / seconds
Query Executed:select id FROM `az` where city='Taylor' && SIC_code='5541'DB:business_master_new
loadtime:1.5327088832855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teec Nos Pos' limit 1
loadtime:1.5327408313751 / seconds
Query Executed:select id FROM `az` where city='Teec Nos Pos' && SIC_code='5541'DB:business_master_new
loadtime:1.5396068096161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tempe' limit 1
loadtime:1.5396478176117 / seconds
Query Executed:select id FROM `az` where city='Tempe' && SIC_code='5541'DB:business_master_new
loadtime:1.5492379665375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temple Bar Marina' limit 1
loadtime:1.5493178367615 / seconds
Query Executed:select id FROM `az` where city='Temple Bar Marina' && SIC_code='5541'DB:business_master_new
loadtime:1.5502197742462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thatcher' limit 1
loadtime:1.5502707958221 / seconds
Query Executed:select id FROM `az` where city='Thatcher' && SIC_code='5541'DB:business_master_new
loadtime:1.5513808727264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolleson' limit 1
loadtime:1.5514259338379 / seconds
Query Executed:select id FROM `az` where city='Tolleson' && SIC_code='5541'DB:business_master_new
loadtime:1.5523099899292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tombstone' limit 1
loadtime:1.5523698329926 / seconds
Query Executed:select id FROM `az` where city='Tombstone' && SIC_code='5541'DB:business_master_new
loadtime:1.5532269477844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tonalea' limit 1
loadtime:1.5532698631287 / seconds
Query Executed:select id FROM `az` where city='Tonalea' && SIC_code='5541'DB:business_master_new
loadtime:1.559072971344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tonopah' limit 1
loadtime:1.5591359138489 / seconds
Query Executed:select id FROM `az` where city='Tonopah' && SIC_code='5541'DB:business_master_new
loadtime:1.5598769187927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tonto Basin' limit 1
loadtime:1.5599339008331 / seconds
Query Executed:select id FROM `az` where city='Tonto Basin' && SIC_code='5541'DB:business_master_new
loadtime:1.5606307983398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topawa' limit 1
loadtime:1.5606889724731 / seconds
Query Executed:select id FROM `az` where city='Topawa' && SIC_code='5541'DB:business_master_new
loadtime:1.5609939098358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topock' limit 1
loadtime:1.5610349178314 / seconds
Query Executed:select id FROM `az` where city='Topock' && SIC_code='5541'DB:business_master_new
loadtime:1.5740687847137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tortilla Flat' limit 1
loadtime:1.5741109848022 / seconds
Query Executed:select id FROM `az` where city='Tortilla Flat' && SIC_code='5541'DB:business_master_new
loadtime:1.5757339000702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tsaile' limit 1
loadtime:1.5757868289948 / seconds
Query Executed:select id FROM `az` where city='Tsaile' && SIC_code='5541'DB:business_master_new
loadtime:1.5788259506226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuba City' limit 1
loadtime:1.5788569450378 / seconds
Query Executed:select id FROM `az` where city='Tuba City' && SIC_code='5541'DB:business_master_new
loadtime:1.5796148777008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tubac' limit 1
loadtime:1.5796568393707 / seconds
Query Executed:select id FROM `az` where city='Tubac' && SIC_code='5541'DB:business_master_new
loadtime:1.5803639888763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tucson' limit 1
loadtime:1.5803968906403 / seconds
Query Executed:select id FROM `az` where city='Tucson' && SIC_code='5541'DB:business_master_new
loadtime:1.5898587703705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tumacacori' limit 1
loadtime:1.589998960495 / seconds
Query Executed:select id FROM `az` where city='Tumacacori' && SIC_code='5541'DB:business_master_new
loadtime:1.590714931488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vail' limit 1
loadtime:1.5907609462738 / seconds
Query Executed:select id FROM `az` where city='Vail' && SIC_code='5541'DB:business_master_new
loadtime:1.5915398597717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valentine' limit 1
loadtime:1.5915739536285 / seconds
Query Executed:select id FROM `az` where city='Valentine' && SIC_code='5541'DB:business_master_new
loadtime:1.5925137996674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Farms' limit 1
loadtime:1.59255194664 / seconds
Query Executed:select id FROM `az` where city='Valley Farms' && SIC_code='5541'DB:business_master_new
loadtime:1.5939989089966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:1.5940368175507 / seconds
Query Executed:select id FROM `az` where city='Vernon' && SIC_code='5541'DB:business_master_new
loadtime:1.5946748256683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waddell' limit 1
loadtime:1.5947058200836 / seconds
Query Executed:select id FROM `az` where city='Waddell' && SIC_code='5541'DB:business_master_new
loadtime:1.595431804657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellton' limit 1
loadtime:1.5954668521881 / seconds
Query Executed:select id FROM `az` where city='Wellton' && SIC_code='5541'DB:business_master_new
loadtime:1.5961267948151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wenden' limit 1
loadtime:1.5961508750916 / seconds
Query Executed:select id FROM `az` where city='Wenden' && SIC_code='5541'DB:business_master_new
loadtime:1.6006059646606 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Mountain Lake' limit 1
loadtime:1.6006438732147 / seconds
Query Executed:select id FROM `az` where city='White Mountain Lake' && SIC_code='5541'DB:business_master_new
loadtime:1.6057169437408 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Mtn Lake' limit 1
loadtime:1.6057507991791 / seconds
Query Executed:select id FROM `az` where city='White Mtn Lake' && SIC_code='5541'DB:business_master_new
loadtime:1.6060509681702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiteriver' limit 1
loadtime:1.6060998439789 / seconds
Query Executed:select id FROM `az` where city='Whiteriver' && SIC_code='5541'DB:business_master_new
loadtime:1.6068148612976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Why' limit 1
loadtime:1.6068480014801 / seconds
Query Executed:select id FROM `az` where city='Why' && SIC_code='5541'DB:business_master_new
loadtime:1.6074109077454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wickenburg' limit 1
loadtime:1.6074578762054 / seconds
Query Executed:select id FROM `az` where city='Wickenburg' && SIC_code='5541'DB:business_master_new
loadtime:1.6084389686584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wikieup' limit 1
loadtime:1.6084878444672 / seconds
Query Executed:select id FROM `az` where city='Wikieup' && SIC_code='5541'DB:business_master_new
loadtime:1.6116728782654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willcox' limit 1
loadtime:1.6117107868195 / seconds
Query Executed:select id FROM `az` where city='Willcox' && SIC_code='5541'DB:business_master_new
loadtime:1.6126887798309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williams' limit 1
loadtime:1.6127347946167 / seconds
Query Executed:select id FROM `az` where city='Williams' && SIC_code='5541'DB:business_master_new
loadtime:1.6136717796326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willow Beach' limit 1
loadtime:1.6137278079987 / seconds
Query Executed:select id FROM `az` where city='Willow Beach' && SIC_code='5541'DB:business_master_new
loadtime:1.6143498420715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Window Rock' limit 1
loadtime:1.614376783371 / seconds
Query Executed:select id FROM `az` where city='Window Rock' && SIC_code='5541'DB:business_master_new
loadtime:1.6152489185333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winkelman' limit 1
loadtime:1.6152958869934 / seconds
Query Executed:select id FROM `az` where city='Winkelman' && SIC_code='5541'DB:business_master_new
loadtime:1.6160268783569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winslow' limit 1
loadtime:1.6160628795624 / seconds
Query Executed:select id FROM `az` where city='Winslow' && SIC_code='5541'DB:business_master_new
loadtime:1.6170208454132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wittmann' limit 1
loadtime:1.61705493927 / seconds
Query Executed:select id FROM `az` where city='Wittmann' && SIC_code='5541'DB:business_master_new
loadtime:1.6177868843079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodruff' limit 1
loadtime:1.6178278923035 / seconds
Query Executed:select id FROM `az` where city='Woodruff' && SIC_code='5541'DB:business_master_new
loadtime:1.6197218894958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yarnell' limit 1
loadtime:1.619756937027 / seconds
Query Executed:select id FROM `az` where city='Yarnell' && SIC_code='5541'DB:business_master_new
loadtime:1.6204400062561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Young' limit 1
loadtime:1.6204748153687 / seconds
Query Executed:select id FROM `az` where city='Young' && SIC_code='5541'DB:business_master_new
loadtime:1.621132850647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Youngtown' limit 1
loadtime:1.6211588382721 / seconds
Query Executed:select id FROM `az` where city='Youngtown' && SIC_code='5541'DB:business_master_new
loadtime:1.6219048500061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yucca' limit 1
loadtime:1.6219480037689 / seconds
Query Executed:select id FROM `az` where city='Yucca' && SIC_code='5541'DB:business_master_new
loadtime:1.625100851059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yuma' limit 1
loadtime:1.6251349449158 / seconds
Query Executed:select id FROM `az` where city='Yuma' && SIC_code='5541'DB:business_master_new
loadtime:1.6344819068909 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.6345739364624 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.6347479820251 / seconds
Operation template executed (chunk cache operation)
loadtime:1.6348469257355 / seconds
template override:Default
loadtime:1.6348669528961 / 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.6356449127197 / seconds
Template Constructed, Array Rows:49
loadtime:1.635883808136 / seconds
TOTAL EXECUTION TIME: 1.63568
loadtime:1.635981798172 / 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] => gasoline-service-station [stateURLid] => arizona )


_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.6359868049622
TOTAL KEY ARRAYS: 69