Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.6069107055664E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00189208984375 / seconds
host not found setting manual db connection
loadtime:0.0097179412841797 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.009972095489502 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010210990905762 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010281085968018 / seconds
zipcode:
loadtime:0.010315895080566 / seconds
Query Executed:select * from search_referrer where page_hash='adf28d447a89e17d1e32c9edd688a473' limit 10 DB:ezrox_toadli
loadtime:0.010601043701172 / seconds
Operation header executed (non global)
loadtime:0.010632991790771 / seconds
Operation leaderboard executed (non global)
loadtime:0.010687112808228 / seconds
Operation square executed (non global)
loadtime:0.010716915130615 / seconds
Operation square_bottom executed (non global)
loadtime:0.010745048522949 / seconds
Operation smallsquare executed (non global)
loadtime:0.010771036148071 / seconds
Operation headeradright executed (non global)
loadtime:0.010796070098877 / seconds
Operation google_analytics executed (non global)
loadtime:0.010821104049683 / seconds
Operation topstories executed (non global)
loadtime:0.010845899581909 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010873079299927 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010896921157837 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.011168003082275 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011367082595825 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011408090591431 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011470079421997 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011518955230713 / seconds
Template key: archive_menu pushed
loadtime:0.011528015136719 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011541128158569 / seconds
Template key: get_gravatar pushed
loadtime:0.011548042297363 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011557102203369 / seconds
*10)-10)+1 | start:0
loadtime:0.011598110198975 / seconds
DB connected to localhost business_master_new
loadtime:0.011838912963867 / seconds
Query Executed:select * from categories where cat_URLid='religious-organizations'DB:business_master_new
loadtime:0.012809038162231 / seconds
Query stored in cache : _QUERY_www.toadli.com626ed171a2bc51d93e031e76f350a479
loadtime:0.012870073318481 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='oregon'
loadtime:0.012912034988403 / seconds
Query Executed:select * from `or_catmap` where sic='8661' order by city ascDB:business_master_new
loadtime:0.029654026031494 / seconds
Query stored in cache : _QUERY_www.toadli.comad0984e669795a3c0f07783ac79c4cb0
loadtime:0.031322956085205 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='oregon'
loadtime:0.031378984451294 / seconds
Query Executed:select sum(totalcount) as totalsum from `or_catmap` where sic='8661'DB:business_master_new
loadtime:0.033657073974609 / seconds
Query stored in cache : _QUERY_www.toadli.com9ba98ed6a402da91edb2a2ffe946b1ba
loadtime:0.033697128295898 / seconds
417 / 11
loadtime:0.03375506401062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adair Village' limit 1
loadtime:0.033822059631348 / seconds
Query Executed:select id FROM `or` where city='Adair Village' && SIC_code='8661'DB:business_master_new
loadtime:0.056212902069092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adams' limit 1
loadtime:0.05627703666687 / seconds
Query Executed:select id FROM `or` where city='Adams' && SIC_code='8661'DB:business_master_new
loadtime:0.057015895843506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adel' limit 1
loadtime:0.057094097137451 / seconds
Query Executed:select id FROM `or` where city='Adel' && SIC_code='8661'DB:business_master_new
loadtime:0.057673931121826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adrian' limit 1
loadtime:0.057734966278076 / seconds
Query Executed:select id FROM `or` where city='Adrian' && SIC_code='8661'DB:business_master_new
loadtime:0.058789968490601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agness' limit 1
loadtime:0.058871030807495 / seconds
Query Executed:select id FROM `or` where city='Agness' && SIC_code='8661'DB:business_master_new
loadtime:0.059520959854126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albany' limit 1
loadtime:0.059582948684692 / seconds
Query Executed:select id FROM `or` where city='Albany' && SIC_code='8661'DB:business_master_new
loadtime:0.095824956893921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allegany' limit 1
loadtime:0.096035003662109 / seconds
Query Executed:select id FROM `or` where city='Allegany' && SIC_code='8661'DB:business_master_new
loadtime:0.096614122390747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aloha' limit 1
loadtime:0.096697092056274 / seconds
Query Executed:select id FROM `or` where city='Aloha' && SIC_code='8661'DB:business_master_new
loadtime:0.097665071487427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alsea' limit 1
loadtime:0.097727060317993 / seconds
Query Executed:select id FROM `or` where city='Alsea' && SIC_code='8661'DB:business_master_new
loadtime:0.098845958709717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alvadore' limit 1
loadtime:0.09893012046814 / seconds
Query Executed:select id FROM `or` where city='Alvadore' && SIC_code='8661'DB:business_master_new
loadtime:0.099568128585815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amity' limit 1
loadtime:0.099649906158447 / seconds
Query Executed:select id FROM `or` where city='Amity' && SIC_code='8661'DB:business_master_new
loadtime:0.10196900367737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Antelope' limit 1
loadtime:0.10205602645874 / seconds
Query Executed:select id FROM `or` where city='Antelope' && SIC_code='8661'DB:business_master_new
loadtime:0.10264897346497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Applegate' limit 1
loadtime:0.10271191596985 / seconds
Query Executed:select id FROM `or` where city='Applegate' && SIC_code='8661'DB:business_master_new
loadtime:0.10318803787231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arch Cape' limit 1
loadtime:0.10324811935425 / seconds
Query Executed:select id FROM `or` where city='Arch Cape' && SIC_code='8661'DB:business_master_new
loadtime:0.10384511947632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.10392689704895 / seconds
Query Executed:select id FROM `or` where city='Arlington' && SIC_code='8661'DB:business_master_new
loadtime:0.10510206222534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arock' limit 1
loadtime:0.10519003868103 / seconds
Query Executed:select id FROM `or` where city='Arock' && SIC_code='8661'DB:business_master_new
loadtime:0.10567402839661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.10574293136597 / seconds
Query Executed:select id FROM `or` where city='Ashland' && SIC_code='8661'DB:business_master_new
loadtime:0.13166213035583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashwood' limit 1
loadtime:0.13182806968689 / seconds
Query Executed:select id FROM `or` where city='Ashwood' && SIC_code='8661'DB:business_master_new
loadtime:0.13232207298279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Astoria' limit 1
loadtime:0.13239908218384 / seconds
Query Executed:select id FROM `or` where city='Astoria' && SIC_code='8661'DB:business_master_new
loadtime:0.14826107025146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athena' limit 1
loadtime:0.1484010219574 / seconds
Query Executed:select id FROM `or` where city='Athena' && SIC_code='8661'DB:business_master_new
loadtime:0.14960908889771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aumsville' limit 1
loadtime:0.14969205856323 / seconds
Query Executed:select id FROM `or` where city='Aumsville' && SIC_code='8661'DB:business_master_new
loadtime:0.1524920463562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.15258193016052 / seconds
Query Executed:select id FROM `or` where city='Aurora' && SIC_code='8661'DB:business_master_new
loadtime:0.20208311080933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Azalea' limit 1
loadtime:0.20223808288574 / seconds
Query Executed:select id FROM `or` where city='Azalea' && SIC_code='8661'DB:business_master_new
loadtime:0.20311594009399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baker City' limit 1
loadtime:0.20320105552673 / seconds
Query Executed:select id FROM `or` where city='Baker City' && SIC_code='8661'DB:business_master_new
loadtime:0.21708798408508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bandon' limit 1
loadtime:0.21721696853638 / seconds
Query Executed:select id FROM `or` where city='Bandon' && SIC_code='8661'DB:business_master_new
loadtime:0.26660394668579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Banks' limit 1
loadtime:0.26675200462341 / seconds
Query Executed:select id FROM `or` where city='Banks' && SIC_code='8661'DB:business_master_new
loadtime:0.26962900161743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bates' limit 1
loadtime:0.26971292495728 / seconds
Query Executed:select id FROM `or` where city='Bates' && SIC_code='8661'DB:business_master_new
loadtime:0.27021098136902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay City' limit 1
loadtime:0.2702739238739 / seconds
Query Executed:select id FROM `or` where city='Bay City' && SIC_code='8661'DB:business_master_new
loadtime:0.2714250087738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beatty' limit 1
loadtime:0.27151012420654 / seconds
Query Executed:select id FROM `or` where city='Beatty' && SIC_code='8661'DB:business_master_new
loadtime:0.27209496498108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaver' limit 1
loadtime:0.27217602729797 / seconds
Query Executed:select id FROM `or` where city='Beaver' && SIC_code='8661'DB:business_master_new
loadtime:0.27286505699158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beavercreek' limit 1
loadtime:0.27292704582214 / seconds
Query Executed:select id FROM `or` where city='Beavercreek' && SIC_code='8661'DB:business_master_new
loadtime:0.27612209320068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaverton' limit 1
loadtime:0.276211977005 / seconds
Query Executed:select id FROM `or` where city='Beaverton' && SIC_code='8661'DB:business_master_new
loadtime:0.35422801971436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bend' limit 1
loadtime:0.35459303855896 / seconds
Query Executed:select id FROM `or` where city='Bend' && SIC_code='8661'DB:business_master_new
loadtime:0.43917107582092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birkenfeld' limit 1
loadtime:0.43951892852783 / seconds
Query Executed:select id FROM `or` where city='Birkenfeld' && SIC_code='8661'DB:business_master_new
loadtime:0.44009494781494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blachly' limit 1
loadtime:0.44017291069031 / seconds
Query Executed:select id FROM `or` where city='Blachly' && SIC_code='8661'DB:business_master_new
loadtime:0.44095706939697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blodgett' limit 1
loadtime:0.44103407859802 / seconds
Query Executed:select id FROM `or` where city='Blodgett' && SIC_code='8661'DB:business_master_new
loadtime:0.44191908836365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue River' limit 1
loadtime:0.44200205802917 / seconds
Query Executed:select id FROM `or` where city='Blue River' && SIC_code='8661'DB:business_master_new
loadtime:0.44332194328308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bly' limit 1
loadtime:0.44340300559998 / seconds
Query Executed:select id FROM `or` where city='Bly' && SIC_code='8661'DB:business_master_new
loadtime:0.44422507286072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boardman' limit 1
loadtime:0.44431591033936 / seconds
Query Executed:select id FROM `or` where city='Boardman' && SIC_code='8661'DB:business_master_new
loadtime:0.4466769695282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonanza' limit 1
loadtime:0.44676208496094 / seconds
Query Executed:select id FROM `or` where city='Bonanza' && SIC_code='8661'DB:business_master_new
loadtime:0.4485878944397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boring' limit 1
loadtime:0.4486780166626 / seconds
Query Executed:select id FROM `or` where city='Boring' && SIC_code='8661'DB:business_master_new
loadtime:0.49863195419312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridal Veil' limit 1
loadtime:0.49878907203674 / seconds
Query Executed:select id FROM `or` where city='Bridal Veil' && SIC_code='8661'DB:business_master_new
loadtime:0.49939203262329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeport' limit 1
loadtime:0.49947690963745 / seconds
Query Executed:select id FROM `or` where city='Bridgeport' && SIC_code='8661'DB:business_master_new
loadtime:0.49994707107544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brightwood' limit 1
loadtime:0.50000905990601 / seconds
Query Executed:select id FROM `or` where city='Brightwood' && SIC_code='8661'DB:business_master_new
loadtime:0.5008909702301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadbent' limit 1
loadtime:0.50096797943115 / seconds
Query Executed:select id FROM `or` where city='Broadbent' && SIC_code='8661'DB:business_master_new
loadtime:0.50158905982971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brogan' limit 1
loadtime:0.50166511535645 / seconds
Query Executed:select id FROM `or` where city='Brogan' && SIC_code='8661'DB:business_master_new
loadtime:0.50222492218018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookings' limit 1
loadtime:0.50228595733643 / seconds
Query Executed:select id FROM `or` where city='Brookings' && SIC_code='8661'DB:business_master_new
loadtime:0.51813197135925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooks' limit 1
loadtime:0.5182569026947 / seconds
Query Executed:select id FROM `or` where city='Brooks' && SIC_code='8661'DB:business_master_new
loadtime:0.51868391036987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brothers' limit 1
loadtime:0.51874995231628 / seconds
Query Executed:select id FROM `or` where city='Brothers' && SIC_code='8661'DB:business_master_new
loadtime:0.51923894882202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownsville' limit 1
loadtime:0.51932001113892 / seconds
Query Executed:select id FROM `or` where city='Brownsville' && SIC_code='8661'DB:business_master_new
loadtime:0.52140307426453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burns' limit 1
loadtime:0.5214900970459 / seconds
Query Executed:select id FROM `or` where city='Burns' && SIC_code='8661'DB:business_master_new
loadtime:0.57063603401184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butte Falls' limit 1
loadtime:0.57076811790466 / seconds
Query Executed:select id FROM `or` where city='Butte Falls' && SIC_code='8661'DB:business_master_new
loadtime:0.57172513008118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buxton' limit 1
loadtime:0.57181191444397 / seconds
Query Executed:select id FROM `or` where city='Buxton' && SIC_code='8661'DB:business_master_new
loadtime:0.57251000404358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camas Valley' limit 1
loadtime:0.57259297370911 / seconds
Query Executed:select id FROM `or` where city='Camas Valley' && SIC_code='8661'DB:business_master_new
loadtime:0.57339310646057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Sherman' limit 1
loadtime:0.57346796989441 / seconds
Query Executed:select id FROM `or` where city='Camp Sherman' && SIC_code='8661'DB:business_master_new
loadtime:0.57419991493225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canby' limit 1
loadtime:0.57426190376282 / seconds
Query Executed:select id FROM `or` where city='Canby' && SIC_code='8661'DB:business_master_new
loadtime:0.59179401397705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cannon Beach' limit 1
loadtime:0.59193897247314 / seconds
Query Executed:select id FROM `or` where city='Cannon Beach' && SIC_code='8661'DB:business_master_new
loadtime:0.59501791000366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canyon City' limit 1
loadtime:0.59510612487793 / seconds
Query Executed:select id FROM `or` where city='Canyon City' && SIC_code='8661'DB:business_master_new
loadtime:0.59660291671753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canyonville' limit 1
loadtime:0.5966911315918 / seconds
Query Executed:select id FROM `or` where city='Canyonville' && SIC_code='8661'DB:business_master_new
loadtime:0.59874200820923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlton' limit 1
loadtime:0.59883999824524 / seconds
Query Executed:select id FROM `or` where city='Carlton' && SIC_code='8661'DB:business_master_new
loadtime:0.60088992118835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascade Locks' limit 1
loadtime:0.60097599029541 / seconds
Query Executed:select id FROM `or` where city='Cascade Locks' && SIC_code='8661'DB:business_master_new
loadtime:0.60214400291443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascadia' limit 1
loadtime:0.60222697257996 / seconds
Query Executed:select id FROM `or` where city='Cascadia' && SIC_code='8661'DB:business_master_new
loadtime:0.60272192955017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cave Junction' limit 1
loadtime:0.60278797149658 / seconds
Query Executed:select id FROM `or` where city='Cave Junction' && SIC_code='8661'DB:business_master_new
loadtime:0.65241003036499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central Point' limit 1
loadtime:0.65255689620972 / seconds
Query Executed:select id FROM `or` where city='Central Point' && SIC_code='8661'DB:business_master_new
loadtime:0.67126703262329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charleston' limit 1
loadtime:0.6714289188385 / seconds
Query Executed:select id FROM `or` where city='Charleston' && SIC_code='8661'DB:business_master_new
loadtime:0.67209506034851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chemult' limit 1
loadtime:0.67216610908508 / seconds
Query Executed:select id FROM `or` where city='Chemult' && SIC_code='8661'DB:business_master_new
loadtime:0.6729199886322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheshire' limit 1
loadtime:0.67299389839172 / seconds
Query Executed:select id FROM `or` where city='Cheshire' && SIC_code='8661'DB:business_master_new
loadtime:0.67414808273315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chiloquin' limit 1
loadtime:0.674232006073 / seconds
Query Executed:select id FROM `or` where city='Chiloquin' && SIC_code='8661'DB:business_master_new
loadtime:0.67692494392395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Christmas Valley' limit 1
loadtime:0.67701411247253 / seconds
Query Executed:select id FROM `or` where city='Christmas Valley' && SIC_code='8661'DB:business_master_new
loadtime:0.67833399772644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clackamas' limit 1
loadtime:0.67841792106628 / seconds
Query Executed:select id FROM `or` where city='Clackamas' && SIC_code='8661'DB:business_master_new
loadtime:0.70354008674622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clatskanie' limit 1
loadtime:0.70367002487183 / seconds
Query Executed:select id FROM `or` where city='Clatskanie' && SIC_code='8661'DB:business_master_new
loadtime:0.75319409370422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cloverdale' limit 1
loadtime:0.75334596633911 / seconds
Query Executed:select id FROM `or` where city='Cloverdale' && SIC_code='8661'DB:business_master_new
loadtime:0.75546193122864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coburg' limit 1
loadtime:0.75556492805481 / seconds
Query Executed:select id FROM `or` where city='Coburg' && SIC_code='8661'DB:business_master_new
loadtime:0.75603699684143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colton' limit 1
loadtime:0.75610113143921 / seconds
Query Executed:select id FROM `or` where city='Colton' && SIC_code='8661'DB:business_master_new
loadtime:0.75808000564575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia City' limit 1
loadtime:0.75817108154297 / seconds
Query Executed:select id FROM `or` where city='Columbia City' && SIC_code='8661'DB:business_master_new
loadtime:0.75918698310852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Condon' limit 1
loadtime:0.7592670917511 / seconds
Query Executed:select id FROM `or` where city='Condon' && SIC_code='8661'DB:business_master_new
loadtime:0.76137900352478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coos Bay' limit 1
loadtime:0.76146101951599 / seconds
Query Executed:select id FROM `or` where city='Coos Bay' && SIC_code='8661'DB:business_master_new
loadtime:0.78155994415283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coquille' limit 1
loadtime:0.78169989585876 / seconds
Query Executed:select id FROM `or` where city='Coquille' && SIC_code='8661'DB:business_master_new
loadtime:0.83101511001587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corbett' limit 1
loadtime:0.83118510246277 / seconds
Query Executed:select id FROM `or` where city='Corbett' && SIC_code='8661'DB:business_master_new
loadtime:0.83339405059814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornelius' limit 1
loadtime:0.83348703384399 / seconds
Query Executed:select id FROM `or` where city='Cornelius' && SIC_code='8661'DB:business_master_new
loadtime:0.8823869228363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corvallis' limit 1
loadtime:0.88252806663513 / seconds
Query Executed:select id FROM `or` where city='Corvallis' && SIC_code='8661'DB:business_master_new
loadtime:0.92064690589905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottage Grove' limit 1
loadtime:0.92088603973389 / seconds
Query Executed:select id FROM `or` where city='Cottage Grove' && SIC_code='8661'DB:business_master_new
loadtime:0.9347550868988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cove' limit 1
loadtime:0.9349000453949 / seconds
Query Executed:select id FROM `or` where city='Cove' && SIC_code='8661'DB:business_master_new
loadtime:0.93623399734497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crabtree' limit 1
loadtime:0.93633794784546 / seconds
Query Executed:select id FROM `or` where city='Crabtree' && SIC_code='8661'DB:business_master_new
loadtime:0.9369421005249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crane' limit 1
loadtime:0.93701696395874 / seconds
Query Executed:select id FROM `or` where city='Crane' && SIC_code='8661'DB:business_master_new
loadtime:0.9377019405365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crater Lake' limit 1
loadtime:0.93777704238892 / seconds
Query Executed:select id FROM `or` where city='Crater Lake' && SIC_code='8661'DB:business_master_new
loadtime:0.9382209777832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crawfordsville' limit 1
loadtime:0.93828392028809 / seconds
Query Executed:select id FROM `or` where city='Crawfordsville' && SIC_code='8661'DB:business_master_new
loadtime:0.93878102302551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crescent' limit 1
loadtime:0.93885803222656 / seconds
Query Executed:select id FROM `or` where city='Crescent' && SIC_code='8661'DB:business_master_new
loadtime:0.93970608711243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crescent Lake' limit 1
loadtime:0.93978190422058 / seconds
Query Executed:select id FROM `or` where city='Crescent Lake' && SIC_code='8661'DB:business_master_new
loadtime:0.9403190612793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creswell' limit 1
loadtime:0.94038200378418 / seconds
Query Executed:select id FROM `or` where city='Creswell' && SIC_code='8661'DB:business_master_new
loadtime:0.99018311500549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crooked River' limit 1
loadtime:0.99032306671143 / seconds
Query Executed:select id FROM `or` where city='Crooked River' && SIC_code='8661'DB:business_master_new
loadtime:0.99083995819092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Culp Creek' limit 1
loadtime:0.9909040927887 / seconds
Query Executed:select id FROM `or` where city='Culp Creek' && SIC_code='8661'DB:business_master_new
loadtime:0.99133205413818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Culver' limit 1
loadtime:0.99139189720154 / seconds
Query Executed:select id FROM `or` where city='Culver' && SIC_code='8661'DB:business_master_new
loadtime:0.99295997619629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Curtin' limit 1
loadtime:0.99303793907166 / seconds
Query Executed:select id FROM `or` where city='Curtin' && SIC_code='8661'DB:business_master_new
loadtime:0.99353504180908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dairy' limit 1
loadtime:0.99359703063965 / seconds
Query Executed:select id FROM `or` where city='Dairy' && SIC_code='8661'DB:business_master_new
loadtime:0.99425411224365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dale' limit 1
loadtime:0.99432611465454 / seconds
Query Executed:select id FROM `or` where city='Dale' && SIC_code='8661'DB:business_master_new
loadtime:0.99472808837891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas' limit 1
loadtime:0.99478912353516 / seconds
Query Executed:select id FROM `or` where city='Dallas' && SIC_code='8661'DB:business_master_new
loadtime:1.0079760551453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Damascus' limit 1
loadtime:1.0081100463867 / seconds
Query Executed:select id FROM `or` where city='Damascus' && SIC_code='8661'DB:business_master_new
loadtime:1.0106639862061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Days Creek' limit 1
loadtime:1.0107519626617 / seconds
Query Executed:select id FROM `or` where city='Days Creek' && SIC_code='8661'DB:business_master_new
loadtime:1.0117080211639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayton' limit 1
loadtime:1.0117990970612 / seconds
Query Executed:select id FROM `or` where city='Dayton' && SIC_code='8661'DB:business_master_new
loadtime:1.0145530700684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayville' limit 1
loadtime:1.0146479606628 / seconds
Query Executed:select id FROM `or` where city='Dayville' && SIC_code='8661'DB:business_master_new
loadtime:1.015310049057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deadwood' limit 1
loadtime:1.0153930187225 / seconds
Query Executed:select id FROM `or` where city='Deadwood' && SIC_code='8661'DB:business_master_new
loadtime:1.0160341262817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deer Island' limit 1
loadtime:1.0160949230194 / seconds
Query Executed:select id FROM `or` where city='Deer Island' && SIC_code='8661'DB:business_master_new
loadtime:1.0170481204987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Depoe Bay' limit 1
loadtime:1.0171089172363 / seconds
Query Executed:select id FROM `or` where city='Depoe Bay' && SIC_code='8661'DB:business_master_new
loadtime:1.0197150707245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Detroit' limit 1
loadtime:1.0197999477386 / seconds
Query Executed:select id FROM `or` where city='Detroit' && SIC_code='8661'DB:business_master_new
loadtime:1.0205769538879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dexter' limit 1
loadtime:1.020653963089 / seconds
Query Executed:select id FROM `or` where city='Dexter' && SIC_code='8661'DB:business_master_new
loadtime:1.0220229625702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diamond' limit 1
loadtime:1.0221059322357 / seconds
Query Executed:select id FROM `or` where city='Diamond' && SIC_code='8661'DB:business_master_new
loadtime:1.0226950645447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diamond Lake' limit 1
loadtime:1.0227570533752 / seconds
Query Executed:select id FROM `or` where city='Diamond Lake' && SIC_code='8661'DB:business_master_new
loadtime:1.0231781005859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dillard' limit 1
loadtime:1.0232388973236 / seconds
Query Executed:select id FROM `or` where city='Dillard' && SIC_code='8661'DB:business_master_new
loadtime:1.0239961147308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Donald' limit 1
loadtime:1.024071931839 / seconds
Query Executed:select id FROM `or` where city='Donald' && SIC_code='8661'DB:business_master_new
loadtime:1.0248689651489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorena' limit 1
loadtime:1.0249309539795 / seconds
Query Executed:select id FROM `or` where city='Dorena' && SIC_code='8661'DB:business_master_new
loadtime:1.0255889892578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drain' limit 1
loadtime:1.0256640911102 / seconds
Query Executed:select id FROM `or` where city='Drain' && SIC_code='8661'DB:business_master_new
loadtime:1.027664899826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drewsey' limit 1
loadtime:1.0277619361877 / seconds
Query Executed:select id FROM `or` where city='Drewsey' && SIC_code='8661'DB:business_master_new
loadtime:1.0284581184387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dufur' limit 1
loadtime:1.0285210609436 / seconds
Query Executed:select id FROM `or` where city='Dufur' && SIC_code='8661'DB:business_master_new
loadtime:1.0297091007233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dundee' limit 1
loadtime:1.0297939777374 / seconds
Query Executed:select id FROM `or` where city='Dundee' && SIC_code='8661'DB:business_master_new
loadtime:1.0322780609131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durkee' limit 1
loadtime:1.0323660373688 / seconds
Query Executed:select id FROM `or` where city='Durkee' && SIC_code='8661'DB:business_master_new
loadtime:1.0329570770264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Creek' limit 1
loadtime:1.0330181121826 / seconds
Query Executed:select id FROM `or` where city='Eagle Creek' && SIC_code='8661'DB:business_master_new
loadtime:1.0350649356842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Point' limit 1
loadtime:1.0351490974426 / seconds
Query Executed:select id FROM `or` where city='Eagle Point' && SIC_code='8661'DB:business_master_new
loadtime:1.0846381187439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastside' limit 1
loadtime:1.0847749710083 / seconds
Query Executed:select id FROM `or` where city='Eastside' && SIC_code='8661'DB:business_master_new
loadtime:1.0852930545807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Echo' limit 1
loadtime:1.0853700637817 / seconds
Query Executed:select id FROM `or` where city='Echo' && SIC_code='8661'DB:business_master_new
loadtime:1.0863499641418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eddyville' limit 1
loadtime:1.0864341259003 / seconds
Query Executed:select id FROM `or` where city='Eddyville' && SIC_code='8661'DB:business_master_new
loadtime:1.0870621204376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elgin' limit 1
loadtime:1.0871500968933 / seconds
Query Executed:select id FROM `or` where city='Elgin' && SIC_code='8661'DB:business_master_new
loadtime:1.0891180038452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkton' limit 1
loadtime:1.0892150402069 / seconds
Query Executed:select id FROM `or` where city='Elkton' && SIC_code='8661'DB:business_master_new
loadtime:1.0903220176697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmira' limit 1
loadtime:1.0904021263123 / seconds
Query Executed:select id FROM `or` where city='Elmira' && SIC_code='8661'DB:business_master_new
loadtime:1.0919189453125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enterprise' limit 1
loadtime:1.0920031070709 / seconds
Query Executed:select id FROM `or` where city='Enterprise' && SIC_code='8661'DB:business_master_new
loadtime:1.1405251026154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estacada' limit 1
loadtime:1.1406569480896 / seconds
Query Executed:select id FROM `or` where city='Estacada' && SIC_code='8661'DB:business_master_new
loadtime:1.1896250247955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eugene' limit 1
loadtime:1.1897699832916 / seconds
Query Executed:select id FROM `or` where city='Eugene' && SIC_code='8661'DB:business_master_new
loadtime:1.2414560317993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:1.241956949234 / seconds
Query Executed:select id FROM `or` where city='Fairview' && SIC_code='8661'DB:business_master_new
loadtime:1.2453079223633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fall Creek' limit 1
loadtime:1.2454171180725 / seconds
Query Executed:select id FROM `or` where city='Fall Creek' && SIC_code='8661'DB:business_master_new
loadtime:1.2463910579681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falls City' limit 1
loadtime:1.2464709281921 / seconds
Query Executed:select id FROM `or` where city='Falls City' && SIC_code='8661'DB:business_master_new
loadtime:1.2472620010376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fields' limit 1
loadtime:1.2473549842834 / seconds
Query Executed:select id FROM `or` where city='Fields' && SIC_code='8661'DB:business_master_new
loadtime:1.2479131221771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:1.2479820251465 / seconds
Query Executed:select id FROM `or` where city='Florence' && SIC_code='8661'DB:business_master_new
loadtime:1.2624680995941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest Grove' limit 1
loadtime:1.262589931488 / seconds
Query Executed:select id FROM `or` where city='Forest Grove' && SIC_code='8661'DB:business_master_new
loadtime:1.2765691280365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Klamath' limit 1
loadtime:1.2766880989075 / seconds
Query Executed:select id FROM `or` where city='Fort Klamath' && SIC_code='8661'DB:business_master_new
loadtime:1.2773330211639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Rock' limit 1
loadtime:1.277398109436 / seconds
Query Executed:select id FROM `or` where city='Fort Rock' && SIC_code='8661'DB:business_master_new
loadtime:1.2779788970947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fossil' limit 1
loadtime:1.2780549526215 / seconds
Query Executed:select id FROM `or` where city='Fossil' && SIC_code='8661'DB:business_master_new
loadtime:1.2793951034546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foster' limit 1
loadtime:1.2794780731201 / seconds
Query Executed:select id FROM `or` where city='Foster' && SIC_code='8661'DB:business_master_new
loadtime:1.2803099155426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frenchglen' limit 1
loadtime:1.2803869247437 / seconds
Query Executed:select id FROM `or` where city='Frenchglen' && SIC_code='8661'DB:business_master_new
loadtime:1.280905008316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gales Creek' limit 1
loadtime:1.2809660434723 / seconds
Query Executed:select id FROM `or` where city='Gales Creek' && SIC_code='8661'DB:business_master_new
loadtime:1.2817521095276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gardiner' limit 1
loadtime:1.2818350791931 / seconds
Query Executed:select id FROM `or` where city='Gardiner' && SIC_code='8661'DB:business_master_new
loadtime:1.2824831008911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garibaldi' limit 1
loadtime:1.2825589179993 / seconds
Query Executed:select id FROM `or` where city='Garibaldi' && SIC_code='8661'DB:business_master_new
loadtime:1.2840740680695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaston' limit 1
loadtime:1.2841579914093 / seconds
Query Executed:select id FROM `or` where city='Gaston' && SIC_code='8661'DB:business_master_new
loadtime:1.2867290973663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gates' limit 1
loadtime:1.2868149280548 / seconds
Query Executed:select id FROM `or` where city='Gates' && SIC_code='8661'DB:business_master_new
loadtime:1.2877519130707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gearhart' limit 1
loadtime:1.2878320217133 / seconds
Query Executed:select id FROM `or` where city='Gearhart' && SIC_code='8661'DB:business_master_new
loadtime:1.2884540557861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gervais' limit 1
loadtime:1.2885160446167 / seconds
Query Executed:select id FROM `or` where city='Gervais' && SIC_code='8661'DB:business_master_new
loadtime:1.2902579307556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilchrist' limit 1
loadtime:1.290344953537 / seconds
Query Executed:select id FROM `or` where city='Gilchrist' && SIC_code='8661'DB:business_master_new
loadtime:1.2911739349365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladstone' limit 1
loadtime:1.2912530899048 / seconds
Query Executed:select id FROM `or` where city='Gladstone' && SIC_code='8661'DB:business_master_new
loadtime:1.3408010005951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1
loadtime:1.3409481048584 / seconds
Query Executed:select id FROM `or` where city='Glendale' && SIC_code='8661'DB:business_master_new
loadtime:1.3425838947296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gleneden Beach' limit 1
loadtime:1.342677116394 / seconds
Query Executed:select id FROM `or` where city='Gleneden Beach' && SIC_code='8661'DB:business_master_new
loadtime:1.3440799713135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glide' limit 1
loadtime:1.3441638946533 / seconds
Query Executed:select id FROM `or` where city='Glide' && SIC_code='8661'DB:business_master_new
loadtime:1.3456721305847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gold Beach' limit 1
loadtime:1.3457579612732 / seconds
Query Executed:select id FROM `or` where city='Gold Beach' && SIC_code='8661'DB:business_master_new
loadtime:1.3947660923004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gold Hill' limit 1
loadtime:1.394905090332 / seconds
Query Executed:select id FROM `or` where city='Gold Hill' && SIC_code='8661'DB:business_master_new
loadtime:1.3979349136353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Government Camp' limit 1
loadtime:1.3980259895325 / seconds
Query Executed:select id FROM `or` where city='Government Camp' && SIC_code='8661'DB:business_master_new
loadtime:1.3989870548248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Ronde' limit 1
loadtime:1.399050951004 / seconds
Query Executed:select id FROM `or` where city='Grand Ronde' && SIC_code='8661'DB:business_master_new
loadtime:1.4002199172974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grants Pass' limit 1
loadtime:1.4003159999847 / seconds
Query Executed:select id FROM `or` where city='Grants Pass' && SIC_code='8661'DB:business_master_new
loadtime:1.4477939605713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grass Valley' limit 1
loadtime:1.4480459690094 / seconds
Query Executed:select id FROM `or` where city='Grass Valley' && SIC_code='8661'DB:business_master_new
loadtime:1.4489109516144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gresham' limit 1
loadtime:1.4490070343018 / seconds
Query Executed:select id FROM `or` where city='Gresham' && SIC_code='8661'DB:business_master_new
loadtime:1.4842901229858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haines' limit 1
loadtime:1.484493970871 / seconds
Query Executed:select id FROM `or` where city='Haines' && SIC_code='8661'DB:business_master_new
loadtime:1.4856350421906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halfway' limit 1
loadtime:1.4857230186462 / seconds
Query Executed:select id FROM `or` where city='Halfway' && SIC_code='8661'DB:business_master_new
loadtime:1.4873061180115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halsey' limit 1
loadtime:1.4873850345612 / seconds
Query Executed:select id FROM `or` where city='Halsey' && SIC_code='8661'DB:business_master_new
loadtime:1.4889159202576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hammond' limit 1
loadtime:1.4890038967133 / seconds
Query Executed:select id FROM `or` where city='Hammond' && SIC_code='8661'DB:business_master_new
loadtime:1.4899981021881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Happy Valley' limit 1
loadtime:1.4900760650635 / seconds
Query Executed:select id FROM `or` where city='Happy Valley' && SIC_code='8661'DB:business_master_new
loadtime:1.5032019615173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harbor' limit 1
loadtime:1.5033090114594 / seconds
Query Executed:select id FROM `or` where city='Harbor' && SIC_code='8661'DB:business_master_new
loadtime:1.503849029541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harper' limit 1
loadtime:1.5039141178131 / seconds
Query Executed:select id FROM `or` where city='Harper' && SIC_code='8661'DB:business_master_new
loadtime:1.5046119689941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisburg' limit 1
loadtime:1.5046870708466 / seconds
Query Executed:select id FROM `or` where city='Harrisburg' && SIC_code='8661'DB:business_master_new
loadtime:1.5073931217194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hebo' limit 1
loadtime:1.507483959198 / seconds
Query Executed:select id FROM `or` where city='Hebo' && SIC_code='8661'DB:business_master_new
loadtime:1.5082280635834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Helix' limit 1
loadtime:1.5083179473877 / seconds
Query Executed:select id FROM `or` where city='Helix' && SIC_code='8661'DB:business_master_new
loadtime:1.5091619491577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heppner' limit 1
loadtime:1.5092439651489 / seconds
Query Executed:select id FROM `or` where city='Heppner' && SIC_code='8661'DB:business_master_new
loadtime:1.5117809772491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hereford' limit 1
loadtime:1.511873960495 / seconds
Query Executed:select id FROM `or` where city='Hereford' && SIC_code='8661'DB:business_master_new
loadtime:1.5123980045319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hermiston' limit 1
loadtime:1.5124609470367 / seconds
Query Executed:select id FROM `or` where city='Hermiston' && SIC_code='8661'DB:business_master_new
loadtime:1.5297019481659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:1.5298390388489 / seconds
Query Executed:select id FROM `or` where city='Hillsboro' && SIC_code='8661'DB:business_master_new
loadtime:1.5737628936768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hines' limit 1
loadtime:1.5740160942078 / seconds
Query Executed:select id FROM `or` where city='Hines' && SIC_code='8661'DB:business_master_new
loadtime:1.575483083725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hood River' limit 1
loadtime:1.5755739212036 / seconds
Query Executed:select id FROM `or` where city='Hood River' && SIC_code='8661'DB:business_master_new
loadtime:1.59534907341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbard' limit 1
loadtime:1.5954821109772 / seconds
Query Executed:select id FROM `or` where city='Hubbard' && SIC_code='8661'DB:business_master_new
loadtime:1.598464012146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington' limit 1
loadtime:1.5985500812531 / seconds
Query Executed:select id FROM `or` where city='Huntington' && SIC_code='8661'DB:business_master_new
loadtime:1.5993320941925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Idanha' limit 1
loadtime:1.5994091033936 / seconds
Query Executed:select id FROM `or` where city='Idanha' && SIC_code='8661'DB:business_master_new
loadtime:1.5999701023102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Idleyld Park' limit 1
loadtime:1.6000308990479 / seconds
Query Executed:select id FROM `or` where city='Idleyld Park' && SIC_code='8661'DB:business_master_new
loadtime:1.6008689403534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Imbler' limit 1
loadtime:1.6009359359741 / seconds
Query Executed:select id FROM `or` where city='Imbler' && SIC_code='8661'DB:business_master_new
loadtime:1.601823091507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Imnaha' limit 1
loadtime:1.601900100708 / seconds
Query Executed:select id FROM `or` where city='Imnaha' && SIC_code='8661'DB:business_master_new
loadtime:1.6025359630585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Independence' limit 1
loadtime:1.6026129722595 / seconds
Query Executed:select id FROM `or` where city='Independence' && SIC_code='8661'DB:business_master_new
loadtime:1.6522510051727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ione' limit 1
loadtime:1.6523909568787 / seconds
Query Executed:select id FROM `or` where city='Ione' && SIC_code='8661'DB:business_master_new
loadtime:1.653538942337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ironside' limit 1
loadtime:1.6536159515381 / seconds
Query Executed:select id FROM `or` where city='Ironside' && SIC_code='8661'DB:business_master_new
loadtime:1.6541709899902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irrigon' limit 1
loadtime:1.6542329788208 / seconds
Query Executed:select id FROM `or` where city='Irrigon' && SIC_code='8661'DB:business_master_new
loadtime:1.6555709838867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jacksonville' limit 1
loadtime:1.6556520462036 / seconds
Query Executed:select id FROM `or` where city='Jacksonville' && SIC_code='8661'DB:business_master_new
loadtime:1.7053251266479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamieson' limit 1
loadtime:1.7054691314697 / seconds
Query Executed:select id FROM `or` where city='Jamieson' && SIC_code='8661'DB:business_master_new
loadtime:1.7060379981995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jasper' limit 1
loadtime:1.7061030864716 / seconds
Query Executed:select id FROM `or` where city='Jasper' && SIC_code='8661'DB:business_master_new
loadtime:1.7065370082855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:1.7065989971161 / seconds
Query Executed:select id FROM `or` where city='Jefferson' && SIC_code='8661'DB:business_master_new
loadtime:1.7090690135956 / seconds
Query loaded from cache:select * from geodata_geocity where city='John Day' limit 1
loadtime:1.7091610431671 / seconds
Query Executed:select id FROM `or` where city='John Day' && SIC_code='8661'DB:business_master_new
loadtime:1.758064031601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jordan Valley' limit 1
loadtime:1.7582130432129 / seconds
Query Executed:select id FROM `or` where city='Jordan Valley' && SIC_code='8661'DB:business_master_new
loadtime:1.7594521045685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joseph' limit 1
loadtime:1.7595319747925 / seconds
Query Executed:select id FROM `or` where city='Joseph' && SIC_code='8661'DB:business_master_new
loadtime:1.7624759674072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Junction City' limit 1
loadtime:1.7625570297241 / seconds
Query Executed:select id FROM `or` where city='Junction City' && SIC_code='8661'DB:business_master_new
loadtime:1.7738521099091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Juntura' limit 1
loadtime:1.7739639282227 / seconds
Query Executed:select id FROM `or` where city='Juntura' && SIC_code='8661'DB:business_master_new
loadtime:1.7745769023895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keizer' limit 1
loadtime:1.7746560573578 / seconds
Query Executed:select id FROM `or` where city='Keizer' && SIC_code='8661'DB:business_master_new
loadtime:1.791491985321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keno' limit 1
loadtime:1.791631937027 / seconds
Query Executed:select id FROM `or` where city='Keno' && SIC_code='8661'DB:business_master_new
loadtime:1.792496919632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kent' limit 1
loadtime:1.7925810813904 / seconds
Query Executed:select id FROM `or` where city='Kent' && SIC_code='8661'DB:business_master_new
loadtime:1.793142080307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kerby' limit 1
loadtime:1.7932178974152 / seconds
Query Executed:select id FROM `or` where city='Kerby' && SIC_code='8661'DB:business_master_new
loadtime:1.7940189838409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kimberly' limit 1
loadtime:1.7940940856934 / seconds
Query Executed:select id FROM `or` where city='Kimberly' && SIC_code='8661'DB:business_master_new
loadtime:1.7947111129761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Klamath Falls' limit 1
loadtime:1.7947731018066 / seconds
Query Executed:select id FROM `or` where city='Klamath Falls' && SIC_code='8661'DB:business_master_new
loadtime:1.8303740024567 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Grande' limit 1
loadtime:1.8305969238281 / seconds
Query Executed:select id FROM `or` where city='La Grande' && SIC_code='8661'DB:business_master_new
loadtime:1.8479859828949 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Pine' limit 1
loadtime:1.8481559753418 / seconds
Query Executed:select id FROM `or` where city='La Pine' && SIC_code='8661'DB:business_master_new
loadtime:1.8981029987335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lafayette' limit 1
loadtime:1.8982620239258 / seconds
Query Executed:select id FROM `or` where city='Lafayette' && SIC_code='8661'DB:business_master_new
loadtime:1.8997840881348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Oswego' limit 1
loadtime:1.8998749256134 / seconds
Query Executed:select id FROM `or` where city='Lake Oswego' && SIC_code='8661'DB:business_master_new
loadtime:1.9404649734497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeside' limit 1
loadtime:1.9406359195709 / seconds
Query Executed:select id FROM `or` where city='Lakeside' && SIC_code='8661'DB:business_master_new
loadtime:1.9419989585876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeview' limit 1
loadtime:1.9420940876007 / seconds
Query Executed:select id FROM `or` where city='Lakeview' && SIC_code='8661'DB:business_master_new
loadtime:1.9916291236877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langlois' limit 1
loadtime:1.9917769432068 / seconds
Query Executed:select id FROM `or` where city='Langlois' && SIC_code='8661'DB:business_master_new
loadtime:1.9928710460663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawen' limit 1
loadtime:1.992959022522 / seconds
Query Executed:select id FROM `or` where city='Lawen' && SIC_code='8661'DB:business_master_new
loadtime:1.9934151172638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leaburg' limit 1
loadtime:1.9934771060944 / seconds
Query Executed:select id FROM `or` where city='Leaburg' && SIC_code='8661'DB:business_master_new
loadtime:1.9939529895782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:1.9940140247345 / seconds
Query Executed:select id FROM `or` where city='Lebanon' && SIC_code='8661'DB:business_master_new
loadtime:2.0111300945282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:2.0112900733948 / seconds
Query Executed:select id FROM `or` where city='Lexington' && SIC_code='8661'DB:business_master_new
loadtime:2.0121021270752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln City' limit 1
loadtime:2.0121910572052 / seconds
Query Executed:select id FROM `or` where city='Lincoln City' && SIC_code='8661'DB:business_master_new
loadtime:2.0271511077881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Logsden' limit 1
loadtime:2.0272779464722 / seconds
Query Executed:select id FROM `or` where city='Logsden' && SIC_code='8661'DB:business_master_new
loadtime:2.0279440879822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Creek' limit 1
loadtime:2.0280320644379 / seconds
Query Executed:select id FROM `or` where city='Long Creek' && SIC_code='8661'DB:business_master_new
loadtime:2.0289769172668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lorane' limit 1
loadtime:2.0290579795837 / seconds
Query Executed:select id FROM `or` where city='Lorane' && SIC_code='8661'DB:business_master_new
loadtime:2.0297920703888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lostine' limit 1
loadtime:2.0298681259155 / seconds
Query Executed:select id FROM `or` where city='Lostine' && SIC_code='8661'DB:business_master_new
loadtime:2.0307021141052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:2.0307779312134 / seconds
Query Executed:select id FROM `or` where city='Lowell' && SIC_code='8661'DB:business_master_new
loadtime:2.0319061279297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyons' limit 1
loadtime:2.031986951828 / seconds
Query Executed:select id FROM `or` where city='Lyons' && SIC_code='8661'DB:business_master_new
loadtime:2.0337600708008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madras' limit 1
loadtime:2.0338509082794 / seconds
Query Executed:select id FROM `or` where city='Madras' && SIC_code='8661'DB:business_master_new
loadtime:2.0447070598602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malin' limit 1
loadtime:2.0448369979858 / seconds
Query Executed:select id FROM `or` where city='Malin' && SIC_code='8661'DB:business_master_new
loadtime:2.0461890697479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manning' limit 1
loadtime:2.0462698936462 / seconds
Query Executed:select id FROM `or` where city='Manning' && SIC_code='8661'DB:business_master_new
loadtime:2.0469210147858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manzanita' limit 1
loadtime:2.0469839572906 / seconds
Query Executed:select id FROM `or` where city='Manzanita' && SIC_code='8661'DB:business_master_new
loadtime:2.0488801002502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mapleton' limit 1
loadtime:2.0489690303802 / seconds
Query Executed:select id FROM `or` where city='Mapleton' && SIC_code='8661'DB:business_master_new
loadtime:2.0501720905304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marcola' limit 1
loadtime:2.0502510070801 / seconds
Query Executed:select id FROM `or` where city='Marcola' && SIC_code='8661'DB:business_master_new
loadtime:2.0513219833374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:2.0514070987701 / seconds
Query Executed:select id FROM `or` where city='Marion' && SIC_code='8661'DB:business_master_new
loadtime:2.0518500804901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marylhurst' limit 1
loadtime:2.0519111156464 / seconds
Query Executed:select id FROM `or` where city='Marylhurst' && SIC_code='8661'DB:business_master_new
loadtime:2.052738904953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maupin' limit 1
loadtime:2.0528221130371 / seconds
Query Executed:select id FROM `or` where city='Maupin' && SIC_code='8661'DB:business_master_new
loadtime:2.0542731285095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Kenzie Bridge' limit 1
loadtime:2.0543630123138 / seconds
Query Executed:select id FROM `or` where city='Mc Kenzie Bridge' && SIC_code='8661'DB:business_master_new
loadtime:2.0548050403595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mcminnville' limit 1
loadtime:2.0548710823059 / seconds
Query Executed:select id FROM `or` where city='Mcminnville' && SIC_code='8661'DB:business_master_new
loadtime:2.0776901245117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meacham' limit 1
loadtime:2.0778450965881 / seconds
Query Executed:select id FROM `or` where city='Meacham' && SIC_code='8661'DB:business_master_new
loadtime:2.0784139633179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medford' limit 1
loadtime:2.0784850120544 / seconds
Query Executed:select id FROM `or` where city='Medford' && SIC_code='8661'DB:business_master_new
loadtime:2.1440100669861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mehama' limit 1
loadtime:2.1442940235138 / seconds
Query Executed:select id FROM `or` where city='Mehama' && SIC_code='8661'DB:business_master_new
loadtime:2.1450750827789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merlin' limit 1
loadtime:2.1451680660248 / seconds
Query Executed:select id FROM `or` where city='Merlin' && SIC_code='8661'DB:business_master_new
loadtime:2.1476609706879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrill' limit 1
loadtime:2.1477470397949 / seconds
Query Executed:select id FROM `or` where city='Merrill' && SIC_code='8661'DB:business_master_new
loadtime:2.1495621204376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Metolius' limit 1
loadtime:2.1496450901031 / seconds
Query Executed:select id FROM `or` where city='Metolius' && SIC_code='8661'DB:business_master_new
loadtime:2.1501131057739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland' limit 1
loadtime:2.150181055069 / seconds
Query Executed:select id FROM `or` where city='Midland' && SIC_code='8661'DB:business_master_new
loadtime:2.150810956955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mikkalo' limit 1
loadtime:2.1508719921112 / seconds
Query Executed:select id FROM `or` where city='Mikkalo' && SIC_code='8661'DB:business_master_new
loadtime:2.1513469219208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mill City' limit 1
loadtime:2.151407957077 / seconds
Query Executed:select id FROM `or` where city='Mill City' && SIC_code='8661'DB:business_master_new
loadtime:2.1528730392456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton Freewater' limit 1
loadtime:2.1529550552368 / seconds
Query Executed:select id FROM `or` where city='Milton Freewater' && SIC_code='8661'DB:business_master_new
loadtime:2.2029850482941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milwaukie' limit 1
loadtime:2.2031519412994 / seconds
Query Executed:select id FROM `or` where city='Milwaukie' && SIC_code='8661'DB:business_master_new
loadtime:2.2042078971863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchell' limit 1
loadtime:2.2042751312256 / seconds
Query Executed:select id FROM `or` where city='Mitchell' && SIC_code='8661'DB:business_master_new
loadtime:2.205235004425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Molalla' limit 1
loadtime:2.2053320407867 / seconds
Query Executed:select id FROM `or` where city='Molalla' && SIC_code='8661'DB:business_master_new
loadtime:2.2183039188385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monmouth' limit 1
loadtime:2.2184278964996 / seconds
Query Executed:select id FROM `or` where city='Monmouth' && SIC_code='8661'DB:business_master_new
loadtime:2.2673079967499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:2.267452955246 / seconds
Query Executed:select id FROM `or` where city='Monroe' && SIC_code='8661'DB:business_master_new
loadtime:2.2695159912109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monument' limit 1
loadtime:2.2696070671082 / seconds
Query Executed:select id FROM `or` where city='Monument' && SIC_code='8661'DB:business_master_new
loadtime:2.2702829837799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moro' limit 1
loadtime:2.2703700065613 / seconds
Query Executed:select id FROM `or` where city='Moro' && SIC_code='8661'DB:business_master_new
loadtime:2.2714159488678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mosier' limit 1
loadtime:2.2714920043945 / seconds
Query Executed:select id FROM `or` where city='Mosier' && SIC_code='8661'DB:business_master_new
loadtime:2.2725961208344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Angel' limit 1
loadtime:2.272675037384 / seconds
Query Executed:select id FROM `or` where city='Mount Angel' && SIC_code='8661'DB:business_master_new
loadtime:2.2756769657135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Hood Parkdale' limit 1
loadtime:2.2757649421692 / seconds
Query Executed:select id FROM `or` where city='Mount Hood Parkdale' && SIC_code='8661'DB:business_master_new
loadtime:2.2780690193176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Vernon' limit 1
loadtime:2.2781589031219 / seconds
Query Executed:select id FROM `or` where city='Mount Vernon' && SIC_code='8661'DB:business_master_new
loadtime:2.2794599533081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Angel' limit 1
loadtime:2.2795400619507 / seconds
Query Executed:select id FROM `or` where city='Mt Angel' && SIC_code='8661'DB:business_master_new
loadtime:2.2799780368805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Hood Parkdale' limit 1
loadtime:2.2800400257111 / seconds
Query Executed:select id FROM `or` where city='Mt Hood Parkdale' && SIC_code='8661'DB:business_master_new
loadtime:2.2805390357971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Vernon' limit 1
loadtime:2.2806010246277 / seconds
Query Executed:select id FROM `or` where city='Mt Vernon' && SIC_code='8661'DB:business_master_new
loadtime:2.2810389995575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mulino' limit 1
loadtime:2.2811000347137 / seconds
Query Executed:select id FROM `or` where city='Mulino' && SIC_code='8661'DB:business_master_new
loadtime:2.2833731174469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murphy' limit 1
loadtime:2.2834661006927 / seconds
Query Executed:select id FROM `or` where city='Murphy' && SIC_code='8661'DB:business_master_new
loadtime:2.2842919826508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Myrtle Creek' limit 1
loadtime:2.2843799591064 / seconds
Query Executed:select id FROM `or` where city='Myrtle Creek' && SIC_code='8661'DB:business_master_new
loadtime:2.3339309692383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Myrtle Point' limit 1
loadtime:2.3340809345245 / seconds
Query Executed:select id FROM `or` where city='Myrtle Point' && SIC_code='8661'DB:business_master_new
loadtime:2.3370718955994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nehalem' limit 1
loadtime:2.3371880054474 / seconds
Query Executed:select id FROM `or` where city='Nehalem' && SIC_code='8661'DB:business_master_new
loadtime:2.3395640850067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neotsu' limit 1
loadtime:2.3396480083466 / seconds
Query Executed:select id FROM `or` where city='Neotsu' && SIC_code='8661'DB:business_master_new
loadtime:2.3404269218445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neskowin' limit 1
loadtime:2.3404901027679 / seconds
Query Executed:select id FROM `or` where city='Neskowin' && SIC_code='8661'DB:business_master_new
loadtime:2.3414850234985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Netarts' limit 1
loadtime:2.3415670394897 / seconds
Query Executed:select id FROM `or` where city='Netarts' && SIC_code='8661'DB:business_master_new
loadtime:2.3422210216522 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Pine Creek' limit 1
loadtime:2.3423099517822 / seconds
Query Executed:select id FROM `or` where city='New Pine Creek' && SIC_code='8661'DB:business_master_new
loadtime:2.3429429531097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newberg' limit 1
loadtime:2.343003988266 / seconds
Query Executed:select id FROM `or` where city='Newberg' && SIC_code='8661'DB:business_master_new
loadtime:2.3609659671783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:2.3611149787903 / seconds
Query Executed:select id FROM `or` where city='Newport' && SIC_code='8661'DB:business_master_new
loadtime:2.3785140514374 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Bend' limit 1
loadtime:2.3786549568176 / seconds
Query Executed:select id FROM `or` where city='North Bend' && SIC_code='8661'DB:business_master_new
loadtime:2.3914730548859 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Plains' limit 1
loadtime:2.3916029930115 / seconds
Query Executed:select id FROM `or` where city='North Plains' && SIC_code='8661'DB:business_master_new
loadtime:2.3944470882416 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Powder' limit 1
loadtime:2.3945410251617 / seconds
Query Executed:select id FROM `or` where city='North Powder' && SIC_code='8661'DB:business_master_new
loadtime:2.3955399990082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norway' limit 1
loadtime:2.3956220149994 / seconds
Query Executed:select id FROM `or` where city='Norway' && SIC_code='8661'DB:business_master_new
loadtime:2.3960399627686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Noti' limit 1
loadtime:2.3961009979248 / seconds
Query Executed:select id FROM `or` where city='Noti' && SIC_code='8661'DB:business_master_new
loadtime:2.3969080448151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nyssa' limit 1
loadtime:2.3969860076904 / seconds
Query Executed:select id FROM `or` where city='Nyssa' && SIC_code='8661'DB:business_master_new
loadtime:2.4002289772034 / seconds
Query loaded from cache:select * from geodata_geocity where city='O Brien' limit 1
loadtime:2.4003500938416 / seconds
Query Executed:select id FROM `or` where city='O Brien' && SIC_code='8661'DB:business_master_new
loadtime:2.4011890888214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Grove' limit 1
loadtime:2.4012579917908 / seconds
Query Executed:select id FROM `or` where city='Oak Grove' && SIC_code='8661'DB:business_master_new
loadtime:2.4017128944397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakland' limit 1
loadtime:2.4017751216888 / seconds
Query Executed:select id FROM `or` where city='Oakland' && SIC_code='8661'DB:business_master_new
loadtime:2.4041891098022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakridge' limit 1
loadtime:2.4042711257935 / seconds
Query Executed:select id FROM `or` where city='Oakridge' && SIC_code='8661'DB:business_master_new
loadtime:2.4067370891571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oceanside' limit 1
loadtime:2.4068350791931 / seconds
Query Executed:select id FROM `or` where city='Oceanside' && SIC_code='8661'DB:business_master_new
loadtime:2.4074440002441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Odell' limit 1
loadtime:2.4075090885162 / seconds
Query Executed:select id FROM `or` where city='Odell' && SIC_code='8661'DB:business_master_new
loadtime:2.4083499908447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ontario' limit 1
loadtime:2.4084270000458 / seconds
Query Executed:select id FROM `or` where city='Ontario' && SIC_code='8661'DB:business_master_new
loadtime:2.4249219894409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ophir' limit 1
loadtime:2.4250679016113 / seconds
Query Executed:select id FROM `or` where city='Ophir' && SIC_code='8661'DB:business_master_new
loadtime:2.4256930351257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oregon City' limit 1
loadtime:2.425763130188 / seconds
Query Executed:select id FROM `or` where city='Oregon City' && SIC_code='8661'DB:business_master_new
loadtime:2.456670999527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otis' limit 1
loadtime:2.456864118576 / seconds
Query Executed:select id FROM `or` where city='Otis' && SIC_code='8661'DB:business_master_new
loadtime:2.4585769176483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otter Rock' limit 1
loadtime:2.4586620330811 / seconds
Query Executed:select id FROM `or` where city='Otter Rock' && SIC_code='8661'DB:business_master_new
loadtime:2.4593050479889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxbow' limit 1
loadtime:2.4593679904938 / seconds
Query Executed:select id FROM `or` where city='Oxbow' && SIC_code='8661'DB:business_master_new
loadtime:2.4599521160126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pacific City' limit 1
loadtime:2.4600119590759 / seconds
Query Executed:select id FROM `or` where city='Pacific City' && SIC_code='8661'DB:business_master_new
loadtime:2.4615581035614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paisley' limit 1
loadtime:2.4616329669952 / seconds
Query Executed:select id FROM `or` where city='Paisley' && SIC_code='8661'DB:business_master_new
loadtime:2.4625160694122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paulina' limit 1
loadtime:2.4625930786133 / seconds
Query Executed:select id FROM `or` where city='Paulina' && SIC_code='8661'DB:business_master_new
loadtime:2.4631290435791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pendleton' limit 1
loadtime:2.4631938934326 / seconds
Query Executed:select id FROM `or` where city='Pendleton' && SIC_code='8661'DB:business_master_new
loadtime:2.482048034668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Philomath' limit 1
loadtime:2.4822070598602 / seconds
Query Executed:select id FROM `or` where city='Philomath' && SIC_code='8661'DB:business_master_new
loadtime:2.5318329334259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phoenix' limit 1
loadtime:2.5319840908051 / seconds
Query Executed:select id FROM `or` where city='Phoenix' && SIC_code='8661'DB:business_master_new
loadtime:2.5804629325867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilot Rock' limit 1
loadtime:2.5805859565735 / seconds
Query Executed:select id FROM `or` where city='Pilot Rock' && SIC_code='8661'DB:business_master_new
loadtime:2.5820710659027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pistol River' limit 1
loadtime:2.5821619033813 / seconds
Query Executed:select id FROM `or` where city='Pistol River' && SIC_code='8661'DB:business_master_new
loadtime:2.5826389789581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Hill' limit 1
loadtime:2.5827031135559 / seconds
Query Executed:select id FROM `or` where city='Pleasant Hill' && SIC_code='8661'DB:business_master_new
loadtime:2.5847918987274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plush' limit 1
loadtime:2.5848739147186 / seconds
Query Executed:select id FROM `or` where city='Plush' && SIC_code='8661'DB:business_master_new
loadtime:2.5854070186615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Orford' limit 1
loadtime:2.5854699611664 / seconds
Query Executed:select id FROM `or` where city='Port Orford' && SIC_code='8661'DB:business_master_new
loadtime:2.5879149436951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portland' limit 1
loadtime:2.5880000591278 / seconds
Query Executed:select id FROM `or` where city='Portland' && SIC_code='8661'DB:business_master_new
loadtime:2.63933801651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Post' limit 1
loadtime:2.640967130661 / seconds
Query Executed:select id FROM `or` where city='Post' && SIC_code='8661'DB:business_master_new
loadtime:2.6415660381317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powell Butte' limit 1
loadtime:2.6417210102081 / seconds
Query Executed:select id FROM `or` where city='Powell Butte' && SIC_code='8661'DB:business_master_new
loadtime:2.6434009075165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powers' limit 1
loadtime:2.6434769630432 / seconds
Query Executed:select id FROM `or` where city='Powers' && SIC_code='8661'DB:business_master_new
loadtime:2.6444470882416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie City' limit 1
loadtime:2.6445260047913 / seconds
Query Executed:select id FROM `or` where city='Prairie City' && SIC_code='8661'DB:business_master_new
loadtime:2.6459400653839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:2.6460320949554 / seconds
Query Executed:select id FROM `or` where city='Princeton' && SIC_code='8661'DB:business_master_new
loadtime:2.6467089653015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prineville' limit 1
loadtime:2.6467790603638 / seconds
Query Executed:select id FROM `or` where city='Prineville' && SIC_code='8661'DB:business_master_new
loadtime:2.6613249778748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prospect' limit 1
loadtime:2.6614530086517 / seconds
Query Executed:select id FROM `or` where city='Prospect' && SIC_code='8661'DB:business_master_new
loadtime:2.6624300479889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rainier' limit 1
loadtime:2.6625139713287 / seconds
Query Executed:select id FROM `or` where city='Rainier' && SIC_code='8661'DB:business_master_new
loadtime:2.6660339832306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redmond' limit 1
loadtime:2.6661310195923 / seconds
Query Executed:select id FROM `or` where city='Redmond' && SIC_code='8661'DB:business_master_new
loadtime:2.6903529167175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reedsport' limit 1
loadtime:2.690505027771 / seconds
Query Executed:select id FROM `or` where city='Reedsport' && SIC_code='8661'DB:business_master_new
loadtime:2.7402050495148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhododendron' limit 1
loadtime:2.7403650283813 / seconds
Query Executed:select id FROM `or` where city='Rhododendron' && SIC_code='8661'DB:business_master_new
loadtime:2.7414031028748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland' limit 1
loadtime:2.7414751052856 / seconds
Query Executed:select id FROM `or` where city='Richland' && SIC_code='8661'DB:business_master_new
loadtime:2.7425661087036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rickreall' limit 1
loadtime:2.7426509857178 / seconds
Query Executed:select id FROM `or` where city='Rickreall' && SIC_code='8661'DB:business_master_new
loadtime:2.7440071105957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riddle' limit 1
loadtime:2.7441000938416 / seconds
Query Executed:select id FROM `or` where city='Riddle' && SIC_code='8661'DB:business_master_new
loadtime:2.745532989502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riley' limit 1
loadtime:2.745619058609 / seconds
Query Executed:select id FROM `or` where city='Riley' && SIC_code='8661'DB:business_master_new
loadtime:2.7462348937988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ritter' limit 1
loadtime:2.7463130950928 / seconds
Query Executed:select id FROM `or` where city='Ritter' && SIC_code='8661'DB:business_master_new
loadtime:2.7467269897461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:2.7467920780182 / seconds
Query Executed:select id FROM `or` where city='Riverside' && SIC_code='8661'DB:business_master_new
loadtime:2.747241973877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockaway' limit 1
loadtime:2.7473211288452 / seconds
Query Executed:select id FROM `or` where city='Rockaway' && SIC_code='8661'DB:business_master_new
loadtime:2.7477569580078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockaway Beach' limit 1
loadtime:2.7478260993958 / seconds
Query Executed:select id FROM `or` where city='Rockaway Beach' && SIC_code='8661'DB:business_master_new
loadtime:2.749773979187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rogue River' limit 1
loadtime:2.7498619556427 / seconds
Query Executed:select id FROM `or` where city='Rogue River' && SIC_code='8661'DB:business_master_new
loadtime:2.7987790107727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose Lodge' limit 1
loadtime:2.7989239692688 / seconds
Query Executed:select id FROM `or` where city='Rose Lodge' && SIC_code='8661'DB:business_master_new
loadtime:2.799488067627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roseburg' limit 1
loadtime:2.7995569705963 / seconds
Query Executed:select id FROM `or` where city='Roseburg' && SIC_code='8661'DB:business_master_new
loadtime:2.8362860679626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rufus' limit 1
loadtime:2.8365099430084 / seconds
Query Executed:select id FROM `or` where city='Rufus' && SIC_code='8661'DB:business_master_new
loadtime:2.8372509479523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saginaw' limit 1
loadtime:2.8373548984528 / seconds
Query Executed:select id FROM `or` where city='Saginaw' && SIC_code='8661'DB:business_master_new
loadtime:2.8378419876099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Benedict' limit 1
loadtime:2.8379030227661 / seconds
Query Executed:select id FROM `or` where city='Saint Benedict' && SIC_code='8661'DB:business_master_new
loadtime:2.8384261131287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Helens' limit 1
loadtime:2.8385019302368 / seconds
Query Executed:select id FROM `or` where city='Saint Helens' && SIC_code='8661'DB:business_master_new
loadtime:2.8511939048767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Paul' limit 1
loadtime:2.8513340950012 / seconds
Query Executed:select id FROM `or` where city='Saint Paul' && SIC_code='8661'DB:business_master_new
loadtime:2.853287935257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:2.8533840179443 / seconds
Query Executed:select id FROM `or` where city='Salem' && SIC_code='8661'DB:business_master_new
loadtime:2.9628109931946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy' limit 1
loadtime:2.9633710384369 / seconds
Query Executed:select id FROM `or` where city='Sandy' && SIC_code='8661'DB:business_master_new
loadtime:2.9768159389496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scappoose' limit 1
loadtime:2.9769530296326 / seconds
Query Executed:select id FROM `or` where city='Scappoose' && SIC_code='8661'DB:business_master_new
loadtime:3.026792049408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scio' limit 1
loadtime:3.026948928833 / seconds
Query Executed:select id FROM `or` where city='Scio' && SIC_code='8661'DB:business_master_new
loadtime:3.030308008194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotts Mills' limit 1
loadtime:3.0304019451141 / seconds
Query Executed:select id FROM `or` where city='Scotts Mills' && SIC_code='8661'DB:business_master_new
loadtime:3.0315139293671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottsburg' limit 1
loadtime:3.031592130661 / seconds
Query Executed:select id FROM `or` where city='Scottsburg' && SIC_code='8661'DB:business_master_new
loadtime:3.0321359634399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seal Rock' limit 1
loadtime:3.0322299003601 / seconds
Query Executed:select id FROM `or` where city='Seal Rock' && SIC_code='8661'DB:business_master_new
loadtime:3.0336310863495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaside' limit 1
loadtime:3.0337059497833 / seconds
Query Executed:select id FROM `or` where city='Seaside' && SIC_code='8661'DB:business_master_new
loadtime:3.0465779304504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selma' limit 1
loadtime:3.0466740131378 / seconds
Query Executed:select id FROM `or` where city='Selma' && SIC_code='8661'DB:business_master_new
loadtime:3.0481150150299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:3.048201084137 / seconds
Query Executed:select id FROM `or` where city='Seneca' && SIC_code='8661'DB:business_master_new
loadtime:3.0488209724426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shady Cove' limit 1
loadtime:3.0488910675049 / seconds
Query Executed:select id FROM `or` where city='Shady Cove' && SIC_code='8661'DB:business_master_new
loadtime:3.0514380931854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaniko' limit 1
loadtime:3.0515289306641 / seconds
Query Executed:select id FROM `or` where city='Shaniko' && SIC_code='8661'DB:business_master_new
loadtime:3.052031993866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shedd' limit 1
loadtime:3.0520949363708 / seconds
Query Executed:select id FROM `or` where city='Shedd' && SIC_code='8661'DB:business_master_new
loadtime:3.0533261299133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheridan' limit 1
loadtime:3.053407907486 / seconds
Query Executed:select id FROM `or` where city='Sheridan' && SIC_code='8661'DB:business_master_new
loadtime:3.0568480491638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherwood' limit 1
loadtime:3.0569450855255 / seconds
Query Executed:select id FROM `or` where city='Sherwood' && SIC_code='8661'DB:business_master_new
loadtime:3.0711350440979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Siletz' limit 1
loadtime:3.0712490081787 / seconds
Query Executed:select id FROM `or` where city='Siletz' && SIC_code='8661'DB:business_master_new
loadtime:3.0725450515747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Lake' limit 1
loadtime:3.0726361274719 / seconds
Query Executed:select id FROM `or` where city='Silver Lake' && SIC_code='8661'DB:business_master_new
loadtime:3.0734589099884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silverton' limit 1
loadtime:3.0735340118408 / seconds
Query Executed:select id FROM `or` where city='Silverton' && SIC_code='8661'DB:business_master_new
loadtime:3.0863530635834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sisters' limit 1
loadtime:3.08647108078 / seconds
Query Executed:select id FROM `or` where city='Sisters' && SIC_code='8661'DB:business_master_new
loadtime:3.1360170841217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sixes' limit 1
loadtime:3.1361629962921 / seconds
Query Executed:select id FROM `or` where city='Sixes' && SIC_code='8661'DB:business_master_new
loadtime:3.1369669437408 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Beach' limit 1
loadtime:3.1370379924774 / seconds
Query Executed:select id FROM `or` where city='South Beach' && SIC_code='8661'DB:business_master_new
loadtime:3.1388931274414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sprague River' limit 1
loadtime:3.1389710903168 / seconds
Query Executed:select id FROM `or` where city='Sprague River' && SIC_code='8661'DB:business_master_new
loadtime:3.1396629810333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spray' limit 1
loadtime:3.1397390365601 / seconds
Query Executed:select id FROM `or` where city='Spray' && SIC_code='8661'DB:business_master_new
loadtime:3.1405560970306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:3.1406400203705 / seconds
Query Executed:select id FROM `or` where city='Springfield' && SIC_code='8661'DB:business_master_new
loadtime:3.1752090454102 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Benedict' limit 1
loadtime:3.1754279136658 / seconds
Query Executed:select id FROM `or` where city='St Benedict' && SIC_code='8661'DB:business_master_new
loadtime:3.1758959293365 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Helens' limit 1
loadtime:3.1759679317474 / seconds
Query Executed:select id FROM `or` where city='St Helens' && SIC_code='8661'DB:business_master_new
loadtime:3.1766149997711 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Paul' limit 1
loadtime:3.1766760349274 / seconds
Query Executed:select id FROM `or` where city='St Paul' && SIC_code='8661'DB:business_master_new
loadtime:3.1771190166473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanfield' limit 1
loadtime:3.1771910190582 / seconds
Query Executed:select id FROM `or` where city='Stanfield' && SIC_code='8661'DB:business_master_new
loadtime:3.1785860061646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stayton' limit 1
loadtime:3.1786699295044 / seconds
Query Executed:select id FROM `or` where city='Stayton' && SIC_code='8661'DB:business_master_new
loadtime:3.1888310909271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sublimity' limit 1
loadtime:3.1889410018921 / seconds
Query Executed:select id FROM `or` where city='Sublimity' && SIC_code='8661'DB:business_master_new
loadtime:3.1909680366516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summer Lake' limit 1
loadtime:3.1910529136658 / seconds
Query Executed:select id FROM `or` where city='Summer Lake' && SIC_code='8661'DB:business_master_new
loadtime:3.1916680335999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summerville' limit 1
loadtime:3.1917309761047 / seconds
Query Executed:select id FROM `or` where city='Summerville' && SIC_code='8661'DB:business_master_new
loadtime:3.1926610469818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumpter' limit 1
loadtime:3.1927349567413 / seconds
Query Executed:select id FROM `or` where city='Sumpter' && SIC_code='8661'DB:business_master_new
loadtime:3.1936860084534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunriver' limit 1
loadtime:3.1937479972839 / seconds
Query Executed:select id FROM `or` where city='Sunriver' && SIC_code='8661'DB:business_master_new
loadtime:3.1948750019073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutherlin' limit 1
loadtime:3.1949520111084 / seconds
Query Executed:select id FROM `or` where city='Sutherlin' && SIC_code='8661'DB:business_master_new
loadtime:3.2446141242981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sweet Home' limit 1
loadtime:3.2447819709778 / seconds
Query Executed:select id FROM `or` where city='Sweet Home' && SIC_code='8661'DB:business_master_new
loadtime:3.2941241264343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swisshome' limit 1
loadtime:3.2943170070648 / seconds
Query Executed:select id FROM `or` where city='Swisshome' && SIC_code='8661'DB:business_master_new
loadtime:3.2949910163879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Talent' limit 1
loadtime:3.2950720787048 / seconds
Query Executed:select id FROM `or` where city='Talent' && SIC_code='8661'DB:business_master_new
loadtime:3.3438138961792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tangent' limit 1
loadtime:3.3439319133759 / seconds
Query Executed:select id FROM `or` where city='Tangent' && SIC_code='8661'DB:business_master_new
loadtime:3.3461101055145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tenmile' limit 1
loadtime:3.3461971282959 / seconds
Query Executed:select id FROM `or` where city='Tenmile' && SIC_code='8661'DB:business_master_new
loadtime:3.3469150066376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terrebonne' limit 1
loadtime:3.3469939231873 / seconds
Query Executed:select id FROM `or` where city='Terrebonne' && SIC_code='8661'DB:business_master_new
loadtime:3.3956980705261 / seconds
Query loaded from cache:select * from geodata_geocity where city='The Dalles' limit 1
loadtime:3.3958320617676 / seconds
Query Executed:select id FROM `or` where city='The Dalles' && SIC_code='8661'DB:business_master_new
loadtime:3.4135529994965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thurston' limit 1
loadtime:3.4137060642242 / seconds
Query Executed:select id FROM `or` where city='Thurston' && SIC_code='8661'DB:business_master_new
loadtime:3.4142129421234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tidewater' limit 1
loadtime:3.414293050766 / seconds
Query Executed:select id FROM `or` where city='Tidewater' && SIC_code='8661'DB:business_master_new
loadtime:3.4150159358978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tigard' limit 1
loadtime:3.4150779247284 / seconds
Query Executed:select id FROM `or` where city='Tigard' && SIC_code='8661'DB:business_master_new
loadtime:3.4167439937592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tillamook' limit 1
loadtime:3.4168119430542 / seconds
Query Executed:select id FROM `or` where city='Tillamook' && SIC_code='8661'DB:business_master_new
loadtime:3.4318001270294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tiller' limit 1
loadtime:3.4319179058075 / seconds
Query Executed:select id FROM `or` where city='Tiller' && SIC_code='8661'DB:business_master_new
loadtime:3.4325449466705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timber' limit 1
loadtime:3.4326250553131 / seconds
Query Executed:select id FROM `or` where city='Timber' && SIC_code='8661'DB:business_master_new
loadtime:3.4331450462341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toledo' limit 1
loadtime:3.4332129955292 / seconds
Query Executed:select id FROM `or` where city='Toledo' && SIC_code='8661'DB:business_master_new
loadtime:3.4819350242615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolovana Park' limit 1
loadtime:3.4820640087128 / seconds
Query Executed:select id FROM `or` where city='Tolovana Park' && SIC_code='8661'DB:business_master_new
loadtime:3.4827470779419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trail' limit 1
loadtime:3.4828181266785 / seconds
Query Executed:select id FROM `or` where city='Trail' && SIC_code='8661'DB:business_master_new
loadtime:3.4839661121368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troutdale' limit 1
loadtime:3.4840450286865 / seconds
Query Executed:select id FROM `or` where city='Troutdale' && SIC_code='8661'DB:business_master_new
loadtime:3.4964299201965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tualatin' limit 1
loadtime:3.496542930603 / seconds
Query Executed:select id FROM `or` where city='Tualatin' && SIC_code='8661'DB:business_master_new
loadtime:3.518059015274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turner' limit 1
loadtime:3.5181970596313 / seconds
Query Executed:select id FROM `or` where city='Turner' && SIC_code='8661'DB:business_master_new
loadtime:3.5207250118256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tygh Valley' limit 1
loadtime:3.5208230018616 / seconds
Query Executed:select id FROM `or` where city='Tygh Valley' && SIC_code='8661'DB:business_master_new
loadtime:3.5221769809723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ukiah' limit 1
loadtime:3.522255897522 / seconds
Query Executed:select id FROM `or` where city='Ukiah' && SIC_code='8661'DB:business_master_new
loadtime:3.5229871273041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Umatilla' limit 1
loadtime:3.5230669975281 / seconds
Query Executed:select id FROM `or` where city='Umatilla' && SIC_code='8661'DB:business_master_new
loadtime:3.5255479812622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Umpqua' limit 1
loadtime:3.5256319046021 / seconds
Query Executed:select id FROM `or` where city='Umpqua' && SIC_code='8661'DB:business_master_new
loadtime:3.5266010761261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:3.5266819000244 / seconds
Query Executed:select id FROM `or` where city='Union' && SIC_code='8661'DB:business_master_new
loadtime:3.5283451080322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unity' limit 1
loadtime:3.5284290313721 / seconds
Query Executed:select id FROM `or` where city='Unity' && SIC_code='8661'DB:business_master_new
loadtime:3.529235124588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vale' limit 1
loadtime:3.5293250083923 / seconds
Query Executed:select id FROM `or` where city='Vale' && SIC_code='8661'DB:business_master_new
loadtime:3.5784430503845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Veneta' limit 1
loadtime:3.5785729885101 / seconds
Query Executed:select id FROM `or` where city='Veneta' && SIC_code='8661'DB:business_master_new
loadtime:3.6269578933716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernonia' limit 1
loadtime:3.6270940303802 / seconds
Query Executed:select id FROM `or` where city='Vernonia' && SIC_code='8661'DB:business_master_new
loadtime:3.6753349304199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vida' limit 1
loadtime:3.6754760742188 / seconds
Query Executed:select id FROM `or` where city='Vida' && SIC_code='8661'DB:business_master_new
loadtime:3.6766350269318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waldport' limit 1
loadtime:3.6767129898071 / seconds
Query Executed:select id FROM `or` where city='Waldport' && SIC_code='8661'DB:business_master_new
loadtime:3.7256600856781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallowa' limit 1
loadtime:3.7257919311523 / seconds
Query Executed:select id FROM `or` where city='Wallowa' && SIC_code='8661'DB:business_master_new
loadtime:3.7275381088257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walterville' limit 1
loadtime:3.7276251316071 / seconds
Query Executed:select id FROM `or` where city='Walterville' && SIC_code='8661'DB:business_master_new
loadtime:3.7289860248566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walton' limit 1
loadtime:3.7290670871735 / seconds
Query Executed:select id FROM `or` where city='Walton' && SIC_code='8661'DB:business_master_new
loadtime:3.7296080589294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wamic' limit 1
loadtime:3.7296710014343 / seconds
Query Executed:select id FROM `or` where city='Wamic' && SIC_code='8661'DB:business_master_new
loadtime:3.7301769256592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warm Springs' limit 1
loadtime:3.7302510738373 / seconds
Query Executed:select id FROM `or` where city='Warm Springs' && SIC_code='8661'DB:business_master_new
loadtime:3.7315609455109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:3.7316439151764 / seconds
Query Executed:select id FROM `or` where city='Warren' && SIC_code='8661'DB:business_master_new
loadtime:3.7332870960236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrenton' limit 1
loadtime:3.7333800792694 / seconds
Query Executed:select id FROM `or` where city='Warrenton' && SIC_code='8661'DB:business_master_new
loadtime:3.7819640636444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wasco' limit 1
loadtime:3.7820909023285 / seconds
Query Executed:select id FROM `or` where city='Wasco' && SIC_code='8661'DB:business_master_new
loadtime:3.7833330631256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wedderburn' limit 1
loadtime:3.7834141254425 / seconds
Query Executed:select id FROM `or` where city='Wedderburn' && SIC_code='8661'DB:business_master_new
loadtime:3.7839920520782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Welches' limit 1
loadtime:3.7840549945831 / seconds
Query Executed:select id FROM `or` where city='Welches' && SIC_code='8661'DB:business_master_new
loadtime:3.8322229385376 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Linn' limit 1
loadtime:3.8323481082916 / seconds
Query Executed:select id FROM `or` where city='West Linn' && SIC_code='8661'DB:business_master_new
loadtime:3.8495049476624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfall' limit 1
loadtime:3.8496220111847 / seconds
Query Executed:select id FROM `or` where city='Westfall' && SIC_code='8661'DB:business_master_new
loadtime:3.8501451015472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfir' limit 1
loadtime:3.8502099514008 / seconds
Query Executed:select id FROM `or` where city='Westfir' && SIC_code='8661'DB:business_master_new
loadtime:3.8508589267731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westlake' limit 1
loadtime:3.8509209156036 / seconds
Query Executed:select id FROM `or` where city='Westlake' && SIC_code='8661'DB:business_master_new
loadtime:3.8517169952393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:3.8517980575562 / seconds
Query Executed:select id FROM `or` where city='Weston' && SIC_code='8661'DB:business_master_new
loadtime:3.8527600765228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:3.8528399467468 / seconds
Query Executed:select id FROM `or` where city='Westport' && SIC_code='8661'DB:business_master_new
loadtime:3.8533530235291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheeler' limit 1
loadtime:3.8534219264984 / seconds
Query Executed:select id FROM `or` where city='Wheeler' && SIC_code='8661'DB:business_master_new
loadtime:3.8543949127197 / seconds
Query loaded from cache:select * from geodata_geocity where city='White City' limit 1
loadtime:3.8544549942017 / seconds
Query Executed:select id FROM `or` where city='White City' && SIC_code='8661'DB:business_master_new
loadtime:3.863373041153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilbur' limit 1
loadtime:3.8634719848633 / seconds
Query Executed:select id FROM `or` where city='Wilbur' && SIC_code='8661'DB:business_master_new
loadtime:3.8640050888062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilderville' limit 1
loadtime:3.8640840053558 / seconds
Query Executed:select id FROM `or` where city='Wilderville' && SIC_code='8661'DB:business_master_new
loadtime:3.8650140762329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willamina' limit 1
loadtime:3.8650920391083 / seconds
Query Executed:select id FROM `or` where city='Willamina' && SIC_code='8661'DB:business_master_new
loadtime:3.8670489788055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williams' limit 1
loadtime:3.8671379089355 / seconds
Query Executed:select id FROM `or` where city='Williams' && SIC_code='8661'DB:business_master_new
loadtime:3.8688631057739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilsonville' limit 1
loadtime:3.8689479827881 / seconds
Query Executed:select id FROM `or` where city='Wilsonville' && SIC_code='8661'DB:business_master_new
loadtime:3.8866510391235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:3.8867659568787 / seconds
Query Executed:select id FROM `or` where city='Winchester' && SIC_code='8661'DB:business_master_new
loadtime:3.8878190517426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester Bay' limit 1
loadtime:3.8878970146179 / seconds
Query Executed:select id FROM `or` where city='Winchester Bay' && SIC_code='8661'DB:business_master_new
loadtime:3.8886389732361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winston' limit 1
loadtime:3.8887140750885 / seconds
Query Executed:select id FROM `or` where city='Winston' && SIC_code='8661'DB:business_master_new
loadtime:3.9378271102905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolf Creek' limit 1
loadtime:3.9379689693451 / seconds
Query Executed:select id FROM `or` where city='Wolf Creek' && SIC_code='8661'DB:business_master_new
loadtime:3.9392490386963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wood Village' limit 1
loadtime:3.9393439292908 / seconds
Query Executed:select id FROM `or` where city='Wood Village' && SIC_code='8661'DB:business_master_new
loadtime:3.9398031234741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodburn' limit 1
loadtime:3.9398670196533 / seconds
Query Executed:select id FROM `or` where city='Woodburn' && SIC_code='8661'DB:business_master_new
loadtime:3.9559829235077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yachats' limit 1
loadtime:3.956120967865 / seconds
Query Executed:select id FROM `or` where city='Yachats' && SIC_code='8661'DB:business_master_new
loadtime:4.0049109458923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yamhill' limit 1
loadtime:4.0050320625305 / seconds
Query Executed:select id FROM `or` where city='Yamhill' && SIC_code='8661'DB:business_master_new
loadtime:4.0073380470276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yoncalla' limit 1
loadtime:4.0074300765991 / seconds
Query Executed:select id FROM `or` where city='Yoncalla' && SIC_code='8661'DB:business_master_new
loadtime:4.0547630786896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zigzag' limit 1
loadtime:4.0548760890961 / seconds
Query Executed:select id FROM `or` where city='Zigzag' && SIC_code='8661'DB:business_master_new
loadtime:4.055340051651 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:4.0554959774017 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:4.0559110641479 / seconds
Operation template executed (chunk cache operation)
loadtime:4.0560760498047 / seconds
template override:Default
loadtime:4.056116104126 / 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:4.0574729442596 / seconds
Template Constructed, Array Rows:49
loadtime:4.0580050945282 / seconds
TOTAL EXECUTION TIME: 4.05757
loadtime:4.0608999729156 / 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] => religious-organizations [stateURLid] => oregon )


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