Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.5830688476562E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.001823902130127 / seconds
host not found setting manual db connection
loadtime:0.0095779895782471 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0098488330841064 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010034799575806 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010098934173584 / seconds
zipcode:
loadtime:0.010125875473022 / seconds
Query Executed:select * from search_referrer where page_hash='62d98a826c1e65422de85eb99ea06733' limit 10 DB:ezrox_toadli
loadtime:0.010352849960327 / seconds
Operation header executed (non global)
loadtime:0.010380983352661 / seconds
Operation leaderboard executed (non global)
loadtime:0.010432958602905 / seconds
Operation square executed (non global)
loadtime:0.010461807250977 / seconds
Operation square_bottom executed (non global)
loadtime:0.010489940643311 / seconds
Operation smallsquare executed (non global)
loadtime:0.010514974594116 / seconds
Operation headeradright executed (non global)
loadtime:0.010540008544922 / seconds
Operation google_analytics executed (non global)
loadtime:0.010564804077148 / seconds
Operation topstories executed (non global)
loadtime:0.010589838027954 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010617017745972 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010640859603882 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010902881622314 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011163949966431 / seconds
Operation categories executed (global stored into APC)
loadtime:0.01120400428772 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011264801025391 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011313915252686 / seconds
Template key: archive_menu pushed
loadtime:0.011322975158691 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011335849761963 / seconds
Template key: get_gravatar pushed
loadtime:0.011343002319336 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011351823806763 / seconds
*10)-10)+1 | start:0
loadtime:0.011392831802368 / seconds
Query loaded from cache:select * from categories where cat_URLid='national-commercial-banks'
loadtime:0.01143479347229 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='washington'
loadtime:0.011470794677734 / seconds
DB connected to localhost business_master_new
loadtime:0.011730909347534 / seconds
Query Executed:select * from `wa_catmap` where sic='6021' order by city ascDB:business_master_new
loadtime:0.25098395347595 / seconds
Query stored in cache : _QUERY_www.toadli.com245c85cab0fdc0652a9bf8bdc72b21ff
loadtime:0.25315594673157 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='washington'
loadtime:0.2532320022583 / seconds
Query Executed:select sum(totalcount) as totalsum from `wa_catmap` where sic='6021'DB:business_master_new
loadtime:0.25638580322266 / seconds
Query stored in cache : _QUERY_www.toadli.com1aaeb6192daa72ee1c3d83ef4bf6072d
loadtime:0.25642681121826 / seconds
538 / 11
loadtime:0.25649285316467 / seconds
Query Executed:select * from geodata_geocity where city='Aberdeen' limit 1DB:business_master_new
loadtime:0.25694298744202 / seconds
Query stored in cache : _QUERY_www.toadli.com42528276ef69831a9ccb5ee7e450002e
loadtime:0.25701689720154 / seconds
Query Executed:select id FROM `wa` where city='Aberdeen' && SIC_code='6021'DB:business_master_new
loadtime:0.28361701965332 / seconds
Query Executed:select * from geodata_geocity where city='Acme' limit 1DB:business_master_new
loadtime:0.28411793708801 / seconds
Query stored in cache : _QUERY_www.toadli.com69d870c466c573b18a0f35208c91524e
loadtime:0.28419280052185 / seconds
Query Executed:select id FROM `wa` where city='Acme' && SIC_code='6021'DB:business_master_new
loadtime:0.28498983383179 / seconds
Query Executed:select * from geodata_geocity where city='Addy' limit 1DB:business_master_new
loadtime:0.28542280197144 / seconds
Query stored in cache : _QUERY_www.toadli.comfdabcd99f3a92b2b1034944b8e4c7cfd
loadtime:0.28549480438232 / seconds
Query Executed:select id FROM `wa` where city='Addy' && SIC_code='6021'DB:business_master_new
loadtime:0.28653788566589 / seconds
Query Executed:select * from geodata_geocity where city='Adna' limit 1DB:business_master_new
loadtime:0.28696799278259 / seconds
Query stored in cache : _QUERY_www.toadli.com1284c63e2363ddb737ccbd1b64d2e282
loadtime:0.28703880310059 / seconds
Query Executed:select id FROM `wa` where city='Adna' && SIC_code='6021'DB:business_master_new
loadtime:0.28755593299866 / seconds
Query Executed:select * from geodata_geocity where city='Airway Heights' limit 1DB:business_master_new
loadtime:0.28801894187927 / seconds
Query stored in cache : _QUERY_www.toadli.com8afde5fa9cf89b35f430f00df861af5a
loadtime:0.28809690475464 / seconds
Query Executed:select id FROM `wa` where city='Airway Heights' && SIC_code='6021'DB:business_master_new
loadtime:0.2907338142395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albion' limit 1
loadtime:0.29081082344055 / seconds
Query Executed:select id FROM `wa` where city='Albion' && SIC_code='6021'DB:business_master_new
loadtime:0.29136681556702 / seconds
Query Executed:select * from geodata_geocity where city='Algona' limit 1DB:business_master_new
loadtime:0.29186701774597 / seconds
Query stored in cache : _QUERY_www.toadli.com3e8b2ae59e7d95dae7cf75c03eec7643
loadtime:0.29193902015686 / seconds
Query Executed:select id FROM `wa` where city='Algona' && SIC_code='6021'DB:business_master_new
loadtime:0.29239797592163 / seconds
Query Executed:select * from geodata_geocity where city='Allyn' limit 1DB:business_master_new
loadtime:0.29283881187439 / seconds
Query stored in cache : _QUERY_www.toadli.com9df3a08c02c46eb070ffb76090667602
loadtime:0.2929208278656 / seconds
Query Executed:select id FROM `wa` where city='Allyn' && SIC_code='6021'DB:business_master_new
loadtime:0.29427194595337 / seconds
Query Executed:select * from geodata_geocity where city='Almira' limit 1DB:business_master_new
loadtime:0.29473900794983 / seconds
Query stored in cache : _QUERY_www.toadli.com9e0b5ce79ecf0ab043435c952556962b
loadtime:0.29481101036072 / seconds
Query Executed:select id FROM `wa` where city='Almira' && SIC_code='6021'DB:business_master_new
loadtime:0.29569697380066 / seconds
Query Executed:select * from geodata_geocity where city='Amanda Park' limit 1DB:business_master_new
loadtime:0.29614400863647 / seconds
Query stored in cache : _QUERY_www.toadli.com1efd48d8337262346b40e7117378daf6
loadtime:0.29621601104736 / seconds
Query Executed:select id FROM `wa` where city='Amanda Park' && SIC_code='6021'DB:business_master_new
loadtime:0.29710388183594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amboy' limit 1
loadtime:0.29716682434082 / seconds
Query Executed:select id FROM `wa` where city='Amboy' && SIC_code='6021'DB:business_master_new
loadtime:0.29908084869385 / seconds
Query Executed:select * from geodata_geocity where city='Anacortes' limit 1DB:business_master_new
loadtime:0.29953098297119 / seconds
Query stored in cache : _QUERY_www.toadli.comb169a8acdc2d39b798ad5e664afb525c
loadtime:0.29960298538208 / seconds
Query Executed:select id FROM `wa` where city='Anacortes' && SIC_code='6021'DB:business_master_new
loadtime:0.31370687484741 / seconds
Query Executed:select * from geodata_geocity where city='Anatone' limit 1DB:business_master_new
loadtime:0.31418085098267 / seconds
Query stored in cache : _QUERY_www.toadli.comad5e15777a14567d115f25f8b18fadce
loadtime:0.31424999237061 / seconds
Query Executed:select id FROM `wa` where city='Anatone' && SIC_code='6021'DB:business_master_new
loadtime:0.31486797332764 / seconds
Query Executed:select * from geodata_geocity where city='Anderson Island' limit 1DB:business_master_new
loadtime:0.3153088092804 / seconds
Query stored in cache : _QUERY_www.toadli.combfe3d870abb12d0c2d82cba48bb2b2db
loadtime:0.31537485122681 / seconds
Query Executed:select id FROM `wa` where city='Anderson Island' && SIC_code='6021'DB:business_master_new
loadtime:0.31636786460876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Appleton' limit 1
loadtime:0.31642389297485 / seconds
Query Executed:select id FROM `wa` where city='Appleton' && SIC_code='6021'DB:business_master_new
loadtime:0.31694483757019 / seconds
Query Executed:select * from geodata_geocity where city='Ardenvoir' limit 1DB:business_master_new
loadtime:0.31735396385193 / seconds
Query stored in cache : _QUERY_www.toadli.comdc2bb0bc93a6992a96bdf16ccb0747cb
loadtime:0.31741881370544 / seconds
Query Executed:select id FROM `wa` where city='Ardenvoir' && SIC_code='6021'DB:business_master_new
loadtime:0.3178768157959 / seconds
Query Executed:select * from geodata_geocity where city='Ariel' limit 1DB:business_master_new
loadtime:0.31826901435852 / seconds
Query stored in cache : _QUERY_www.toadli.com99fda265037c0284709e714297ff2cdd
loadtime:0.31833291053772 / seconds
Query Executed:select id FROM `wa` where city='Ariel' && SIC_code='6021'DB:business_master_new
loadtime:0.31923890113831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.31929397583008 / seconds
Query Executed:select id FROM `wa` where city='Arlington' && SIC_code='6021'DB:business_master_new
loadtime:0.33357000350952 / seconds
Query Executed:select * from geodata_geocity where city='Ashford' limit 1DB:business_master_new
loadtime:0.33417391777039 / seconds
Query stored in cache : _QUERY_www.toadli.com729e5afd41d804a0ceb7cb9fdbbd5061
loadtime:0.33427786827087 / seconds
Query Executed:select id FROM `wa` where city='Ashford' && SIC_code='6021'DB:business_master_new
loadtime:0.33536601066589 / seconds
Query Executed:select * from geodata_geocity where city='Asotin' limit 1DB:business_master_new
loadtime:0.33588981628418 / seconds
Query stored in cache : _QUERY_www.toadli.comc6358b8b2f57ae76d3464547ca277fd0
loadtime:0.33598685264587 / seconds
Query Executed:select id FROM `wa` where city='Asotin' && SIC_code='6021'DB:business_master_new
loadtime:0.33715200424194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.33726286888123 / seconds
Query Executed:select id FROM `wa` where city='Auburn' && SIC_code='6021'DB:business_master_new
loadtime:0.3514199256897 / seconds
Query Executed:select * from geodata_geocity where city='Bainbridge Island' limit 1DB:business_master_new
loadtime:0.35192799568176 / seconds
Query stored in cache : _QUERY_www.toadli.comd289cb0faa2864bbc47238fd45318c63
loadtime:0.35202693939209 / seconds
Query Executed:select id FROM `wa` where city='Bainbridge Island' && SIC_code='6021'DB:business_master_new
loadtime:0.36576986312866 / seconds
Query Executed:select * from geodata_geocity where city='Bainbridge Isle' limit 1DB:business_master_new
loadtime:0.36625289916992 / seconds
Query stored in cache : _QUERY_www.toadli.com5868d38a00bd156798cb848eed1baf01
loadtime:0.36635589599609 / seconds
Query Executed:select id FROM `wa` where city='Bainbridge Isle' && SIC_code='6021'DB:business_master_new
loadtime:0.367919921875 / seconds
Query Executed:select * from geodata_geocity where city='Baring' limit 1DB:business_master_new
loadtime:0.36840295791626 / seconds
Query stored in cache : _QUERY_www.toadli.com6121f3b434e6a5a636df4b1b14619916
loadtime:0.36850190162659 / seconds
Query Executed:select id FROM `wa` where city='Baring' && SIC_code='6021'DB:business_master_new
loadtime:0.36904692649841 / seconds
Query Executed:select * from geodata_geocity where city='Battle Ground' limit 1DB:business_master_new
loadtime:0.3695650100708 / seconds
Query stored in cache : _QUERY_www.toadli.comac0e114538112e64a5870f432bff9911
loadtime:0.36966180801392 / seconds
Query Executed:select id FROM `wa` where city='Battle Ground' && SIC_code='6021'DB:business_master_new
loadtime:0.38547897338867 / seconds
Query Executed:select * from geodata_geocity where city='Bay Center' limit 1DB:business_master_new
loadtime:0.38596296310425 / seconds
Query stored in cache : _QUERY_www.toadli.com91bd78c12c7924727b29ac3767970958
loadtime:0.38603496551514 / seconds
Query Executed:select id FROM `wa` where city='Bay Center' && SIC_code='6021'DB:business_master_new
loadtime:0.38659286499023 / seconds
Query Executed:select * from geodata_geocity where city='Beaux Arts' limit 1DB:business_master_new
loadtime:0.38700485229492 / seconds
Query stored in cache : _QUERY_www.toadli.com6f3f5b4975de9c797d40f26946be7bd0
loadtime:0.38706994056702 / seconds
Query Executed:select id FROM `wa` where city='Beaux Arts' && SIC_code='6021'DB:business_master_new
loadtime:0.38747787475586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaver' limit 1
loadtime:0.38753795623779 / seconds
Query Executed:select id FROM `wa` where city='Beaver' && SIC_code='6021'DB:business_master_new
loadtime:0.38831782341003 / seconds
Query Executed:select * from geodata_geocity where city='Belfair' limit 1DB:business_master_new
loadtime:0.38871693611145 / seconds
Query stored in cache : _QUERY_www.toadli.com445b80a76e5b4a0898aa0ef6c940f2b6
loadtime:0.38879895210266 / seconds
Query Executed:select id FROM `wa` where city='Belfair' && SIC_code='6021'DB:business_master_new
loadtime:0.39358997344971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellevue' limit 1
loadtime:0.39366102218628 / seconds
Query Executed:select id FROM `wa` where city='Bellevue' && SIC_code='6021'DB:business_master_new
loadtime:0.40784883499146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellingham' limit 1
loadtime:0.40799689292908 / seconds
Query Executed:select id FROM `wa` where city='Bellingham' && SIC_code='6021'DB:business_master_new
loadtime:0.42165398597717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.42176485061646 / seconds
Query Executed:select id FROM `wa` where city='Belmont' && SIC_code='6021'DB:business_master_new
loadtime:0.42218780517578 / seconds
Query Executed:select * from geodata_geocity where city='Benge' limit 1DB:business_master_new
loadtime:0.42259383201599 / seconds
Query stored in cache : _QUERY_www.toadli.coma29dcf5c18aa5bca350585267afec458
loadtime:0.4226598739624 / seconds
Query Executed:select id FROM `wa` where city='Benge' && SIC_code='6021'DB:business_master_new
loadtime:0.42312979698181 / seconds
Query Executed:select * from geodata_geocity where city='Benton City' limit 1DB:business_master_new
loadtime:0.42353892326355 / seconds
Query stored in cache : _QUERY_www.toadli.com85c91153bf52a964e5a50beeaee9aab8
loadtime:0.42360186576843 / seconds
Query Executed:select id FROM `wa` where city='Benton City' && SIC_code='6021'DB:business_master_new
loadtime:0.42764687538147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beverly' limit 1
loadtime:0.42771697044373 / seconds
Query Executed:select id FROM `wa` where city='Beverly' && SIC_code='6021'DB:business_master_new
loadtime:0.42825794219971 / seconds
Query Executed:select * from geodata_geocity where city='Bickleton' limit 1DB:business_master_new
loadtime:0.42861080169678 / seconds
Query stored in cache : _QUERY_www.toadli.comdeb47cad83878155ab8f3b4cb78fb129
loadtime:0.42867588996887 / seconds
Query Executed:select id FROM `wa` where city='Bickleton' && SIC_code='6021'DB:business_master_new
loadtime:0.42930579185486 / seconds
Query Executed:select * from geodata_geocity where city='Bingen' limit 1DB:business_master_new
loadtime:0.42972779273987 / seconds
Query stored in cache : _QUERY_www.toadli.come06962551fd783c76e6d7d3e85a80682
loadtime:0.42979383468628 / seconds
Query Executed:select id FROM `wa` where city='Bingen' && SIC_code='6021'DB:business_master_new
loadtime:0.4311158657074 / seconds
Query Executed:select * from geodata_geocity where city='Black Diamond' limit 1DB:business_master_new
loadtime:0.43146300315857 / seconds
Query stored in cache : _QUERY_www.toadli.com4d63c541e4fe336022e55d0357624599
loadtime:0.43152689933777 / seconds
Query Executed:select id FROM `wa` where city='Black Diamond' && SIC_code='6021'DB:business_master_new
loadtime:0.43387079238892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blaine' limit 1
loadtime:0.43394684791565 / seconds
Query Executed:select id FROM `wa` where city='Blaine' && SIC_code='6021'DB:business_master_new
loadtime:0.44215083122253 / seconds
Query Executed:select * from geodata_geocity where city='Blakely Island' limit 1DB:business_master_new
loadtime:0.44254684448242 / seconds
Query stored in cache : _QUERY_www.toadli.comcaf84b29bced019bed9ea53b1d37eaf8
loadtime:0.44261193275452 / seconds
Query Executed:select id FROM `wa` where city='Blakely Island' && SIC_code='6021'DB:business_master_new
loadtime:0.44314980506897 / seconds
Query Executed:select * from geodata_geocity where city='Bonney Lake' limit 1DB:business_master_new
loadtime:0.44355392456055 / seconds
Query stored in cache : _QUERY_www.toadli.comc7dd8f7bb015be6b6a8dd6e6c538ac08
loadtime:0.44361782073975 / seconds
Query Executed:select id FROM `wa` where city='Bonney Lake' && SIC_code='6021'DB:business_master_new
loadtime:0.45735287666321 / seconds
Query Executed:select * from geodata_geocity where city='Bothell' limit 1DB:business_master_new
loadtime:0.45781397819519 / seconds
Query stored in cache : _QUERY_www.toadli.comd11c8bc87bb6d6b41cb0a56bdddc6336
loadtime:0.45788192749023 / seconds
Query Executed:select id FROM `wa` where city='Bothell' && SIC_code='6021'DB:business_master_new
loadtime:0.4721999168396 / seconds
Query Executed:select * from geodata_geocity where city='Bow' limit 1DB:business_master_new
loadtime:0.47267389297485 / seconds
Query stored in cache : _QUERY_www.toadli.com343406f2627fd02493e32fd36b70b002
loadtime:0.47275280952454 / seconds
Query Executed:select id FROM `wa` where city='Bow' && SIC_code='6021'DB:business_master_new
loadtime:0.47564697265625 / seconds
Query Executed:select * from geodata_geocity where city='Boyds' limit 1DB:business_master_new
loadtime:0.47609996795654 / seconds
Query stored in cache : _QUERY_www.toadli.com3d9e6f228c7583ed9d271125781c7956
loadtime:0.47616600990295 / seconds
Query Executed:select id FROM `wa` where city='Boyds' && SIC_code='6021'DB:business_master_new
loadtime:0.47656297683716 / seconds
Query Executed:select * from geodata_geocity where city='Bremerton' limit 1DB:business_master_new
loadtime:0.47697591781616 / seconds
Query stored in cache : _QUERY_www.toadli.com1607527b5f6b901e786e33ecb30d4404
loadtime:0.47704696655273 / seconds
Query Executed:select id FROM `wa` where city='Bremerton' && SIC_code='6021'DB:business_master_new
loadtime:0.49077391624451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brewster' limit 1
loadtime:0.49085879325867 / seconds
Query Executed:select id FROM `wa` where city='Brewster' && SIC_code='6021'DB:business_master_new
loadtime:0.4951069355011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeport' limit 1
loadtime:0.49517679214478 / seconds
Query Executed:select id FROM `wa` where city='Bridgeport' && SIC_code='6021'DB:business_master_new
loadtime:0.49650883674622 / seconds
Query Executed:select * from geodata_geocity where city='Brier' limit 1DB:business_master_new
loadtime:0.49697494506836 / seconds
Query stored in cache : _QUERY_www.toadli.com480e70a46e28946ac692fe57bf01a191
loadtime:0.49704098701477 / seconds
Query Executed:select id FROM `wa` where city='Brier' && SIC_code='6021'DB:business_master_new
loadtime:0.49751901626587 / seconds
Query Executed:select * from geodata_geocity where city='Brinnon' limit 1DB:business_master_new
loadtime:0.49794983863831 / seconds
Query stored in cache : _QUERY_www.toadli.com96b28afbc8b9fd153ded1847f8fb7eaa
loadtime:0.49802088737488 / seconds
Query Executed:select id FROM `wa` where city='Brinnon' && SIC_code='6021'DB:business_master_new
loadtime:0.49942779541016 / seconds
Query Executed:select * from geodata_geocity where city='Brownstown' limit 1DB:business_master_new
loadtime:0.49986886978149 / seconds
Query stored in cache : _QUERY_www.toadli.com246c39f0913155b1cff68fb9fb33954d
loadtime:0.49994492530823 / seconds
Query Executed:select id FROM `wa` where city='Brownstown' && SIC_code='6021'DB:business_master_new
loadtime:0.50034284591675 / seconds
Query Executed:select * from geodata_geocity where city='Brush Prairie' limit 1DB:business_master_new
loadtime:0.50071501731873 / seconds
Query stored in cache : _QUERY_www.toadli.com1f7c7b38fa90cde9bbeab1fb6ba2c9af
loadtime:0.50078701972961 / seconds
Query Executed:select id FROM `wa` where city='Brush Prairie' && SIC_code='6021'DB:business_master_new
loadtime:0.50675487518311 / seconds
Query Executed:select * from geodata_geocity where city='Buckley' limit 1DB:business_master_new
loadtime:0.50719881057739 / seconds
Query stored in cache : _QUERY_www.toadli.com7bc9e5194616d143efda76a8633f17af
loadtime:0.50726890563965 / seconds
Query Executed:select id FROM `wa` where city='Buckley' && SIC_code='6021'DB:business_master_new
loadtime:0.51387882232666 / seconds
Query Executed:select * from geodata_geocity where city='Bucoda' limit 1DB:business_master_new
loadtime:0.51432585716248 / seconds
Query stored in cache : _QUERY_www.toadli.comd44efe91ebeca1f466e058d047c10dd8
loadtime:0.51439094543457 / seconds
Query Executed:select id FROM `wa` where city='Bucoda' && SIC_code='6021'DB:business_master_new
loadtime:0.51493000984192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buena' limit 1
loadtime:0.51498579978943 / seconds
Query Executed:select id FROM `wa` where city='Buena' && SIC_code='6021'DB:business_master_new
loadtime:0.51552081108093 / seconds
Query Executed:select * from geodata_geocity where city='Burbank' limit 1DB:business_master_new
loadtime:0.5159318447113 / seconds
Query stored in cache : _QUERY_www.toadli.com3dc7042084e7b0544d570a6f19a24225
loadtime:0.51599788665771 / seconds
Query Executed:select id FROM `wa` where city='Burbank' && SIC_code='6021'DB:business_master_new
loadtime:0.51768279075623 / seconds
Query Executed:select * from geodata_geocity where city='Burien' limit 1DB:business_master_new
loadtime:0.51811194419861 / seconds
Query stored in cache : _QUERY_www.toadli.com859de22b793deb264b41a3d2b52da1d4
loadtime:0.51817679405212 / seconds
Query Executed:select id FROM `wa` where city='Burien' && SIC_code='6021'DB:business_master_new
loadtime:0.51870894432068 / seconds
Query Executed:select * from geodata_geocity where city='Burley' limit 1DB:business_master_new
loadtime:0.51915502548218 / seconds
Query stored in cache : _QUERY_www.toadli.com75fdaad46941a0008eb05f65838aef0d
loadtime:0.51921892166138 / seconds
Query Executed:select id FROM `wa` where city='Burley' && SIC_code='6021'DB:business_master_new
loadtime:0.52003979682922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.52009391784668 / seconds
Query Executed:select id FROM `wa` where city='Burlington' && SIC_code='6021'DB:business_master_new
loadtime:0.53447198867798 / seconds
Query Executed:select * from geodata_geocity where city='Burton' limit 1DB:business_master_new
loadtime:0.53492879867554 / seconds
Query stored in cache : _QUERY_www.toadli.comb3655a8a7fc19beef633432d4ead554e
loadtime:0.53499484062195 / seconds
Query Executed:select id FROM `wa` where city='Burton' && SIC_code='6021'DB:business_master_new
loadtime:0.53564596176147 / seconds
Query Executed:select * from geodata_geocity where city='Camano Island' limit 1DB:business_master_new
loadtime:0.53606486320496 / seconds
Query stored in cache : _QUERY_www.toadli.com7cdda0b9214016328d2ea1cbc377592b
loadtime:0.53613090515137 / seconds
Query Executed:select id FROM `wa` where city='Camano Island' && SIC_code='6021'DB:business_master_new
loadtime:0.54233479499817 / seconds
Query Executed:select * from geodata_geocity where city='Camas' limit 1DB:business_master_new
loadtime:0.54274892807007 / seconds
Query stored in cache : _QUERY_www.toadli.com2f09f5037dc65214cf837223fb907236
loadtime:0.54281497001648 / seconds
Query Executed:select id FROM `wa` where city='Camas' && SIC_code='6021'DB:business_master_new
loadtime:0.55325293540955 / seconds
Query Executed:select * from geodata_geocity where city='Camp Murray' limit 1DB:business_master_new
loadtime:0.55372881889343 / seconds
Query stored in cache : _QUERY_www.toadli.comc999ba57876dc802a4743c6e0d10f014
loadtime:0.55379295349121 / seconds
Query Executed:select id FROM `wa` where city='Camp Murray' && SIC_code='6021'DB:business_master_new
loadtime:0.55424880981445 / seconds
Query Executed:select * from geodata_geocity where city='Carbonado' limit 1DB:business_master_new
loadtime:0.55464792251587 / seconds
Query stored in cache : _QUERY_www.toadli.come091954f2b8109244a16b0a43ad8dd17
loadtime:0.55471181869507 / seconds
Query Executed:select id FROM `wa` where city='Carbonado' && SIC_code='6021'DB:business_master_new
loadtime:0.55531692504883 / seconds
Query Executed:select * from geodata_geocity where city='Carlsborg' limit 1DB:business_master_new
loadtime:0.55573081970215 / seconds
Query stored in cache : _QUERY_www.toadli.com3a60371db6711ce142fe44ce92668b93
loadtime:0.55579495429993 / seconds
Query Executed:select id FROM `wa` where city='Carlsborg' && SIC_code='6021'DB:business_master_new
loadtime:0.55687785148621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlton' limit 1
loadtime:0.55693697929382 / seconds
Query Executed:select id FROM `wa` where city='Carlton' && SIC_code='6021'DB:business_master_new
loadtime:0.55768084526062 / seconds
Query Executed:select * from geodata_geocity where city='Carnation' limit 1DB:business_master_new
loadtime:0.55813002586365 / seconds
Query stored in cache : _QUERY_www.toadli.com85855048ffe14bd85c0ca680c08b4df7
loadtime:0.55820178985596 / seconds
Query Executed:select id FROM `wa` where city='Carnation' && SIC_code='6021'DB:business_master_new
loadtime:0.5626540184021 / seconds
Query Executed:select * from geodata_geocity where city='Carrolls' limit 1DB:business_master_new
loadtime:0.56309700012207 / seconds
Query stored in cache : _QUERY_www.toadli.com87431dc1cf63140c42d4f643e9e4dc02
loadtime:0.56315994262695 / seconds
Query Executed:select id FROM `wa` where city='Carrolls' && SIC_code='6021'DB:business_master_new
loadtime:0.56366181373596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson' limit 1
loadtime:0.56371593475342 / seconds
Query Executed:select id FROM `wa` where city='Carson' && SIC_code='6021'DB:business_master_new
loadtime:0.56533288955688 / seconds
Query Executed:select * from geodata_geocity where city='Cashmere' limit 1DB:business_master_new
loadtime:0.56581497192383 / seconds
Query stored in cache : _QUERY_www.toadli.comb656ba0ee0cffc1f7c8c65a108a76a44
loadtime:0.56588101387024 / seconds
Query Executed:select id FROM `wa` where city='Cashmere' && SIC_code='6021'DB:business_master_new
loadtime:0.57167601585388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castle Rock' limit 1
loadtime:0.57175302505493 / seconds
Query Executed:select id FROM `wa` where city='Castle Rock' && SIC_code='6021'DB:business_master_new
loadtime:0.57728981971741 / seconds
Query Executed:select * from geodata_geocity where city='Cathlamet' limit 1DB:business_master_new
loadtime:0.57772588729858 / seconds
Query stored in cache : _QUERY_www.toadli.com8fc3da6d781ad273c4afc4aafbda3f1c
loadtime:0.577791929245 / seconds
Query Executed:select id FROM `wa` where city='Cathlamet' && SIC_code='6021'DB:business_master_new
loadtime:0.58042001724243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:0.58049082756042 / seconds
Query Executed:select id FROM `wa` where city='Centerville' && SIC_code='6021'DB:business_master_new
loadtime:0.58112597465515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centralia' limit 1
loadtime:0.58117985725403 / seconds
Query Executed:select id FROM `wa` where city='Centralia' && SIC_code='6021'DB:business_master_new
loadtime:0.59543490409851 / seconds
Query Executed:select * from geodata_geocity where city='Chattaroy' limit 1DB:business_master_new
loadtime:0.5959358215332 / seconds
Query stored in cache : _QUERY_www.toadli.com7e7354d1f1da3a7a8e09ac84f9f156cb
loadtime:0.59600186347961 / seconds
Query Executed:select id FROM `wa` where city='Chattaroy' && SIC_code='6021'DB:business_master_new
loadtime:0.5993869304657 / seconds
Query Executed:select * from geodata_geocity where city='Chehalis' limit 1DB:business_master_new
loadtime:0.59979581832886 / seconds
Query stored in cache : _QUERY_www.toadli.com806da4b587ec31b9af4f8af635ae66ee
loadtime:0.59986090660095 / seconds
Query Executed:select id FROM `wa` where city='Chehalis' && SIC_code='6021'DB:business_master_new
loadtime:0.6134819984436 / seconds
Query Executed:select * from geodata_geocity where city='Chelan' limit 1DB:business_master_new
loadtime:0.61391687393188 / seconds
Query stored in cache : _QUERY_www.toadli.com5f7d0829d18d045a7a3a364182bc55b5
loadtime:0.61398887634277 / seconds
Query Executed:select id FROM `wa` where city='Chelan' && SIC_code='6021'DB:business_master_new
loadtime:0.62140679359436 / seconds
Query Executed:select * from geodata_geocity where city='Chelan Falls' limit 1DB:business_master_new
loadtime:0.62182593345642 / seconds
Query stored in cache : _QUERY_www.toadli.com10e728e5af16003d577a20e358bd8941
loadtime:0.62189388275146 / seconds
Query Executed:select id FROM `wa` where city='Chelan Falls' && SIC_code='6021'DB:business_master_new
loadtime:0.62239098548889 / seconds
Query Executed:select * from geodata_geocity where city='Cheney' limit 1DB:business_master_new
loadtime:0.62280797958374 / seconds
Query stored in cache : _QUERY_www.toadli.comb34e6c0a25eae1063820b12bbeb1a6e6
loadtime:0.62287282943726 / seconds
Query Executed:select id FROM `wa` where city='Cheney' && SIC_code='6021'DB:business_master_new
loadtime:0.62999296188354 / seconds
Query Executed:select * from geodata_geocity where city='Chewelah' limit 1DB:business_master_new
loadtime:0.63042402267456 / seconds
Query stored in cache : _QUERY_www.toadli.com3cef7c50db2e9355ee77a82e0096120f
loadtime:0.63050079345703 / seconds
Query Executed:select id FROM `wa` where city='Chewelah' && SIC_code='6021'DB:business_master_new
loadtime:0.63561797142029 / seconds
Query Executed:select * from geodata_geocity where city='Chimacum' limit 1DB:business_master_new
loadtime:0.63610482215881 / seconds
Query stored in cache : _QUERY_www.toadli.coma60cc67452161ab6c5f3b70ba1d2f7d7
loadtime:0.63617396354675 / seconds
Query Executed:select id FROM `wa` where city='Chimacum' && SIC_code='6021'DB:business_master_new
loadtime:0.63785290718079 / seconds
Query Executed:select * from geodata_geocity where city='Chinook' limit 1DB:business_master_new
loadtime:0.63831186294556 / seconds
Query stored in cache : _QUERY_www.toadli.com7f58f91d88bdbc929f7c540e5f7c7613
loadtime:0.63838291168213 / seconds
Query Executed:select id FROM `wa` where city='Chinook' && SIC_code='6021'DB:business_master_new
loadtime:0.63931393623352 / seconds
Query Executed:select * from geodata_geocity where city='Cinebar' limit 1DB:business_master_new
loadtime:0.63978600502014 / seconds
Query stored in cache : _QUERY_www.toadli.com8569ecf542d827ac78af8a3bfb52ae36
loadtime:0.63985085487366 / seconds
Query Executed:select id FROM `wa` where city='Cinebar' && SIC_code='6021'DB:business_master_new
loadtime:0.64048290252686 / seconds
Query Executed:select * from geodata_geocity where city='Clallam Bay' limit 1DB:business_master_new
loadtime:0.64089584350586 / seconds
Query stored in cache : _QUERY_www.toadli.com3ffe43a77b91fc024dea3ddcae621a39
loadtime:0.64096093177795 / seconds
Query Executed:select id FROM `wa` where city='Clallam Bay' && SIC_code='6021'DB:business_master_new
loadtime:0.64196681976318 / seconds
Query Executed:select * from geodata_geocity where city='Clarkston' limit 1DB:business_master_new
loadtime:0.64240193367004 / seconds
Query stored in cache : _QUERY_www.toadli.coma90db48bbe69b391c1484b89ffac0b23
loadtime:0.64246582984924 / seconds
Query Executed:select id FROM `wa` where city='Clarkston' && SIC_code='6021'DB:business_master_new
loadtime:0.65152382850647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clayton' limit 1
loadtime:0.6515998840332 / seconds
Query Executed:select id FROM `wa` where city='Clayton' && SIC_code='6021'DB:business_master_new
loadtime:0.65276098251343 / seconds
Query Executed:select * from geodata_geocity where city='Cle Elum' limit 1DB:business_master_new
loadtime:0.65319490432739 / seconds
Query stored in cache : _QUERY_www.toadli.com4e55f761bf94c5c41da873415290800d
loadtime:0.6532609462738 / seconds
Query Executed:select id FROM `wa` where city='Cle Elum' && SIC_code='6021'DB:business_master_new
loadtime:0.65979480743408 / seconds
Query Executed:select * from geodata_geocity where city='Clearlake' limit 1DB:business_master_new
loadtime:0.66024088859558 / seconds
Query stored in cache : _QUERY_www.toadli.comf2eaa0fb3a2c5c7bee47206f0f08a929
loadtime:0.66030693054199 / seconds
Query Executed:select id FROM `wa` where city='Clearlake' && SIC_code='6021'DB:business_master_new
loadtime:0.66107392311096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.66112899780273 / seconds
Query Executed:select id FROM `wa` where city='Clinton' && SIC_code='6021'DB:business_master_new
loadtime:0.66710186004639 / seconds
Query Executed:select * from geodata_geocity where city='Clyde Hill' limit 1DB:business_master_new
loadtime:0.66750597953796 / seconds
Query stored in cache : _QUERY_www.toadli.com1d92c54a8ab65558cf1e749aa663a96f
loadtime:0.66756987571716 / seconds
Query Executed:select id FROM `wa` where city='Clyde Hill' && SIC_code='6021'DB:business_master_new
loadtime:0.66799998283386 / seconds
Query Executed:select * from geodata_geocity where city='Colbert' limit 1DB:business_master_new
loadtime:0.66837191581726 / seconds
Query stored in cache : _QUERY_www.toadli.com77293b475b57be46058b7082ed3ef618
loadtime:0.66843700408936 / seconds
Query Executed:select id FROM `wa` where city='Colbert' && SIC_code='6021'DB:business_master_new
loadtime:0.6728630065918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colfax' limit 1
loadtime:0.67294096946716 / seconds
Query Executed:select id FROM `wa` where city='Colfax' && SIC_code='6021'DB:business_master_new
loadtime:0.67849683761597 / seconds
Query Executed:select * from geodata_geocity where city='College Place' limit 1DB:business_master_new
loadtime:0.67892694473267 / seconds
Query stored in cache : _QUERY_www.toadli.coma1949cc83ecabfbf1727d644143705d7
loadtime:0.67899298667908 / seconds
Query Executed:select id FROM `wa` where city='College Place' && SIC_code='6021'DB:business_master_new
loadtime:0.68203902244568 / seconds
Query Executed:select * from geodata_geocity where city='Colton' limit 1DB:business_master_new
loadtime:0.68251180648804 / seconds
Query stored in cache : _QUERY_www.toadli.come726d4c12c2db51fe4f448868fc90b5e
loadtime:0.68257594108582 / seconds
Query Executed:select id FROM `wa` where city='Colton' && SIC_code='6021'DB:business_master_new
loadtime:0.68366289138794 / seconds
Query Executed:select * from geodata_geocity where city='Colville' limit 1DB:business_master_new
loadtime:0.68411493301392 / seconds
Query stored in cache : _QUERY_www.toadli.com67c0f467b35cbc918485dc437a593446
loadtime:0.68418002128601 / seconds
Query Executed:select id FROM `wa` where city='Colville' && SIC_code='6021'DB:business_master_new
loadtime:0.6952497959137 / seconds
Query Executed:select * from geodata_geocity where city='Conconully' limit 1DB:business_master_new
loadtime:0.69569897651672 / seconds
Query stored in cache : _QUERY_www.toadli.comfebf96c31923c4a7d7012d45e4af8416
loadtime:0.69577193260193 / seconds
Query Executed:select id FROM `wa` where city='Conconully' && SIC_code='6021'DB:business_master_new
loadtime:0.69642901420593 / seconds
Query Executed:select * from geodata_geocity where city='Concrete' limit 1DB:business_master_new
loadtime:0.69687700271606 / seconds
Query stored in cache : _QUERY_www.toadli.comc7dc0a9c73be82ce1d8343247a5e9542
loadtime:0.69694590568542 / seconds
Query Executed:select id FROM `wa` where city='Concrete' && SIC_code='6021'DB:business_master_new
loadtime:0.69914889335632 / seconds
Query Executed:select * from geodata_geocity where city='Connell' limit 1DB:business_master_new
loadtime:0.6995530128479 / seconds
Query stored in cache : _QUERY_www.toadli.com131a3d96edc1d65b23936994f2b94e8d
loadtime:0.6996169090271 / seconds
Query Executed:select id FROM `wa` where city='Connell' && SIC_code='6021'DB:business_master_new
loadtime:0.70171093940735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.70179200172424 / seconds
Query Executed:select id FROM `wa` where city='Conway' && SIC_code='6021'DB:business_master_new
loadtime:0.70248198509216 / seconds
Query Executed:select * from geodata_geocity where city='Copalis Beach' limit 1DB:business_master_new
loadtime:0.70292901992798 / seconds
Query stored in cache : _QUERY_www.toadli.com019a28e699fc11969360b0cffeb504ae
loadtime:0.70299482345581 / seconds
Query Executed:select id FROM `wa` where city='Copalis Beach' && SIC_code='6021'DB:business_master_new
loadtime:0.7037467956543 / seconds
Query Executed:select * from geodata_geocity where city='Copalis Crossing' limit 1DB:business_master_new
loadtime:0.70417881011963 / seconds
Query stored in cache : _QUERY_www.toadli.com95948f069b2364274f366d4019e72884
loadtime:0.70424294471741 / seconds
Query Executed:select id FROM `wa` where city='Copalis Crossing' && SIC_code='6021'DB:business_master_new
loadtime:0.70479297637939 / seconds
Query Executed:select * from geodata_geocity where city='Cosmopolis' limit 1DB:business_master_new
loadtime:0.70521593093872 / seconds
Query stored in cache : _QUERY_www.toadli.com8fac39034e6604965616d5f6fce25a79
loadtime:0.70527982711792 / seconds
Query Executed:select id FROM `wa` where city='Cosmopolis' && SIC_code='6021'DB:business_master_new
loadtime:0.70675182342529 / seconds
Query Executed:select * from geodata_geocity where city='Cougar' limit 1DB:business_master_new
loadtime:0.7071738243103 / seconds
Query stored in cache : _QUERY_www.toadli.comc7c10600c64a65ea4b53fa5eba0794f2
loadtime:0.70723700523376 / seconds
Query Executed:select id FROM `wa` where city='Cougar' && SIC_code='6021'DB:business_master_new
loadtime:0.70777201652527 / seconds
Query Executed:select * from geodata_geocity where city='Coulee City' limit 1DB:business_master_new
loadtime:0.70819091796875 / seconds
Query stored in cache : _QUERY_www.toadli.come45e0a4394e0f7dd5a17dbaa2ce2cb77
loadtime:0.70825481414795 / seconds
Query Executed:select id FROM `wa` where city='Coulee City' && SIC_code='6021'DB:business_master_new
loadtime:0.70973896980286 / seconds
Query Executed:select * from geodata_geocity where city='Coulee Dam' limit 1DB:business_master_new
loadtime:0.71017694473267 / seconds
Query stored in cache : _QUERY_www.toadli.com4321e05acd00d2e459fe14526bfbaf3d
loadtime:0.71024084091187 / seconds
Query Executed:select id FROM `wa` where city='Coulee Dam' && SIC_code='6021'DB:business_master_new
loadtime:0.71153497695923 / seconds
Query Executed:select * from geodata_geocity where city='Coupeville' limit 1DB:business_master_new
loadtime:0.71199297904968 / seconds
Query stored in cache : _QUERY_www.toadli.comad5361120709863ba06be73ca2cbdec9
loadtime:0.7120578289032 / seconds
Query Executed:select id FROM `wa` where city='Coupeville' && SIC_code='6021'DB:business_master_new
loadtime:0.71841883659363 / seconds
Query Executed:select * from geodata_geocity where city='Covington' limit 1DB:business_master_new
loadtime:0.71887493133545 / seconds
Query stored in cache : _QUERY_www.toadli.com1e448960817d886b5556e9116eae553e
loadtime:0.71894502639771 / seconds
Query Executed:select id FROM `wa` where city='Covington' && SIC_code='6021'DB:business_master_new
loadtime:0.71936082839966 / seconds
Query Executed:select * from geodata_geocity where city='Cowiche' limit 1DB:business_master_new
loadtime:0.71976184844971 / seconds
Query stored in cache : _QUERY_www.toadli.com7150550419d9db5768df0bad844877eb
loadtime:0.7198269367218 / seconds
Query Executed:select id FROM `wa` where city='Cowiche' && SIC_code='6021'DB:business_master_new
loadtime:0.72106289863586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creston' limit 1
loadtime:0.72111988067627 / seconds
Query Executed:select id FROM `wa` where city='Creston' && SIC_code='6021'DB:business_master_new
loadtime:0.72190594673157 / seconds
Query Executed:select * from geodata_geocity where city='Curlew' limit 1DB:business_master_new
loadtime:0.72236394882202 / seconds
Query stored in cache : _QUERY_www.toadli.com85345fe6dce907fbacaf5a91b9bfaa0e
loadtime:0.72242879867554 / seconds
Query Executed:select id FROM `wa` where city='Curlew' && SIC_code='6021'DB:business_master_new
loadtime:0.72336983680725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Curtis' limit 1
loadtime:0.72342491149902 / seconds
Query Executed:select id FROM `wa` where city='Curtis' && SIC_code='6021'DB:business_master_new
loadtime:0.72411298751831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cusick' limit 1
loadtime:0.72416687011719 / seconds
Query Executed:select id FROM `wa` where city='Cusick' && SIC_code='6021'DB:business_master_new
loadtime:0.72500991821289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Custer' limit 1
loadtime:0.72506189346313 / seconds
Query Executed:select id FROM `wa` where city='Custer' && SIC_code='6021'DB:business_master_new
loadtime:0.72663593292236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallesport' limit 1
loadtime:0.72668886184692 / seconds
Query Executed:select id FROM `wa` where city='Dallesport' && SIC_code='6021'DB:business_master_new
loadtime:0.72744393348694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.7274968624115 / seconds
Query Executed:select id FROM `wa` where city='Danville' && SIC_code='6021'DB:business_master_new
loadtime:0.72805786132812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darrington' limit 1
loadtime:0.72811198234558 / seconds
Query Executed:select id FROM `wa` where city='Darrington' && SIC_code='6021'DB:business_master_new
loadtime:0.72943186759949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davenport' limit 1
loadtime:0.72949886322021 / seconds
Query Executed:select id FROM `wa` where city='Davenport' && SIC_code='6021'DB:business_master_new
loadtime:0.73403286933899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayton' limit 1
loadtime:0.73410081863403 / seconds
Query Executed:select id FROM `wa` where city='Dayton' && SIC_code='6021'DB:business_master_new
loadtime:0.73865389823914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deer Harbor' limit 1
loadtime:0.73873281478882 / seconds
Query Executed:select id FROM `wa` where city='Deer Harbor' && SIC_code='6021'DB:business_master_new
loadtime:0.73951697349548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deer Park' limit 1
loadtime:0.73957085609436 / seconds
Query Executed:select id FROM `wa` where city='Deer Park' && SIC_code='6021'DB:business_master_new
loadtime:0.74641489982605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deming' limit 1
loadtime:0.74648284912109 / seconds
Query Executed:select id FROM `wa` where city='Deming' && SIC_code='6021'DB:business_master_new
loadtime:0.7485020160675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Des Moines' limit 1
loadtime:0.74855899810791 / seconds
Query Executed:select id FROM `wa` where city='Des Moines' && SIC_code='6021'DB:business_master_new
loadtime:0.7492618560791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diamond' limit 1
loadtime:0.74931502342224 / seconds
Query Executed:select id FROM `wa` where city='Diamond' && SIC_code='6021'DB:business_master_new
loadtime:0.74974799156189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dixie' limit 1
loadtime:0.74980092048645 / seconds
Query Executed:select id FROM `wa` where city='Dixie' && SIC_code='6021'DB:business_master_new
loadtime:0.75033497810364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doty' limit 1
loadtime:0.7503879070282 / seconds
Query Executed:select id FROM `wa` where city='Doty' && SIC_code='6021'DB:business_master_new
loadtime:0.75087189674377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dryden' limit 1
loadtime:0.75092887878418 / seconds
Query Executed:select id FROM `wa` where city='Dryden' && SIC_code='6021'DB:business_master_new
loadtime:0.75166702270508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Du Pont' limit 1
loadtime:0.75172901153564 / seconds
Query Executed:select id FROM `wa` where city='Du Pont' && SIC_code='6021'DB:business_master_new
loadtime:0.75211882591248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dupont' limit 1
loadtime:0.75217199325562 / seconds
Query Executed:select id FROM `wa` where city='Dupont' && SIC_code='6021'DB:business_master_new
loadtime:0.75375986099243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duvall' limit 1
loadtime:0.75381183624268 / seconds
Query Executed:select id FROM `wa` where city='Duvall' && SIC_code='6021'DB:business_master_new
loadtime:0.75981497764587 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Olympia' limit 1
loadtime:0.75988292694092 / seconds
Query Executed:select id FROM `wa` where city='East Olympia' && SIC_code='6021'DB:business_master_new
loadtime:0.76063799858093 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Wenatchee' limit 1
loadtime:0.76069092750549 / seconds
Query Executed:select id FROM `wa` where city='East Wenatchee' && SIC_code='6021'DB:business_master_new
loadtime:0.77502584457397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easton' limit 1
loadtime:0.77510690689087 / seconds
Query Executed:select id FROM `wa` where city='Easton' && SIC_code='6021'DB:business_master_new
loadtime:0.77597284317017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastsound' limit 1
loadtime:0.77602887153625 / seconds
Query Executed:select id FROM `wa` where city='Eastsound' && SIC_code='6021'DB:business_master_new
loadtime:0.78304386138916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eatonville' limit 1
loadtime:0.78311395645142 / seconds
Query Executed:select id FROM `wa` where city='Eatonville' && SIC_code='6021'DB:business_master_new
loadtime:0.78898882865906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewood' limit 1
loadtime:0.789057970047 / seconds
Query Executed:select id FROM `wa` where city='Edgewood' && SIC_code='6021'DB:business_master_new
loadtime:0.78949594497681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edmonds' limit 1
loadtime:0.78954887390137 / seconds
Query Executed:select id FROM `wa` where city='Edmonds' && SIC_code='6021'DB:business_master_new
loadtime:0.80324101448059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edwall' limit 1
loadtime:0.80332779884338 / seconds
Query Executed:select id FROM `wa` where city='Edwall' && SIC_code='6021'DB:business_master_new
loadtime:0.80408787727356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elbe' limit 1
loadtime:0.80414390563965 / seconds
Query Executed:select id FROM `wa` where city='Elbe' && SIC_code='6021'DB:business_master_new
loadtime:0.804771900177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Electric City' limit 1
loadtime:0.80482482910156 / seconds
Query Executed:select id FROM `wa` where city='Electric City' && SIC_code='6021'DB:business_master_new
loadtime:0.80562686920166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk' limit 1
loadtime:0.80567979812622 / seconds
Query Executed:select id FROM `wa` where city='Elk' && SIC_code='6021'DB:business_master_new
loadtime:0.80747199058533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellensburg' limit 1
loadtime:0.80752682685852 / seconds
Query Executed:select id FROM `wa` where city='Ellensburg' && SIC_code='6021'DB:business_master_new
loadtime:0.82147097587585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elma' limit 1
loadtime:0.82154989242554 / seconds
Query Executed:select id FROM `wa` where city='Elma' && SIC_code='6021'DB:business_master_new
loadtime:0.8271918296814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmer City' limit 1
loadtime:0.82726383209229 / seconds
Query Executed:select id FROM `wa` where city='Elmer City' && SIC_code='6021'DB:business_master_new
loadtime:0.8278169631958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eltopia' limit 1
loadtime:0.82787084579468 / seconds
Query Executed:select id FROM `wa` where city='Eltopia' && SIC_code='6021'DB:business_master_new
loadtime:0.82892394065857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Endicott' limit 1
loadtime:0.82901382446289 / seconds
Query Executed:select id FROM `wa` where city='Endicott' && SIC_code='6021'DB:business_master_new
loadtime:0.83009195327759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Entiat' limit 1
loadtime:0.83017182350159 / seconds
Query Executed:select id FROM `wa` where city='Entiat' && SIC_code='6021'DB:business_master_new
loadtime:0.83165788650513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enumclaw' limit 1
loadtime:0.83171200752258 / seconds
Query Executed:select id FROM `wa` where city='Enumclaw' && SIC_code='6021'DB:business_master_new
loadtime:0.84274983406067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ephrata' limit 1
loadtime:0.84281897544861 / seconds
Query Executed:select id FROM `wa` where city='Ephrata' && SIC_code='6021'DB:business_master_new
loadtime:0.85041689872742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ethel' limit 1
loadtime:0.85048985481262 / seconds
Query Executed:select id FROM `wa` where city='Ethel' && SIC_code='6021'DB:business_master_new
loadtime:0.85123991966248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evans' limit 1
loadtime:0.85129499435425 / seconds
Query Executed:select id FROM `wa` where city='Evans' && SIC_code='6021'DB:business_master_new
loadtime:0.85199999809265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Everett' limit 1
loadtime:0.85205292701721 / seconds
Query Executed:select id FROM `wa` where city='Everett' && SIC_code='6021'DB:business_master_new
loadtime:0.86627292633057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Everson' limit 1
loadtime:0.86638689041138 / seconds
Query Executed:select id FROM `wa` where city='Everson' && SIC_code='6021'DB:business_master_new
loadtime:0.8717098236084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairchild Afb' limit 1
loadtime:0.87178802490234 / seconds
Query Executed:select id FROM `wa` where city='Fairchild Afb' && SIC_code='6021'DB:business_master_new
loadtime:0.87235879898071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairchild Air Force Base' limit 1
loadtime:0.87241291999817 / seconds
Query Executed:select id FROM `wa` where city='Fairchild Air Force Base' && SIC_code='6021'DB:business_master_new
loadtime:0.87351989746094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.87358593940735 / seconds
Query Executed:select id FROM `wa` where city='Fairfield' && SIC_code='6021'DB:business_master_new
loadtime:0.87476396560669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fall City' limit 1
loadtime:0.8748300075531 / seconds
Query Executed:select id FROM `wa` where city='Fall City' && SIC_code='6021'DB:business_master_new
loadtime:0.87905979156494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.87912487983704 / seconds
Query Executed:select id FROM `wa` where city='Farmington' && SIC_code='6021'DB:business_master_new
loadtime:0.87978196144104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Federal Way' limit 1
loadtime:0.87985301017761 / seconds
Query Executed:select id FROM `wa` where city='Federal Way' && SIC_code='6021'DB:business_master_new
loadtime:0.89352989196777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferndale' limit 1
loadtime:0.8936128616333 / seconds
Query Executed:select id FROM `wa` where city='Ferndale' && SIC_code='6021'DB:business_master_new
loadtime:0.90451383590698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fife' limit 1
loadtime:0.90458798408508 / seconds
Query Executed:select id FROM `wa` where city='Fife' && SIC_code='6021'DB:business_master_new
loadtime:0.90514492988586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fircrest' limit 1
loadtime:0.90520095825195 / seconds
Query Executed:select id FROM `wa` where city='Fircrest' && SIC_code='6021'DB:business_master_new
loadtime:0.90560984611511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ford' limit 1
loadtime:0.90566182136536 / seconds
Query Executed:select id FROM `wa` where city='Ford' && SIC_code='6021'DB:business_master_new
loadtime:0.90627694129944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forks' limit 1
loadtime:0.90633082389832 / seconds
Query Executed:select id FROM `wa` where city='Forks' && SIC_code='6021'DB:business_master_new
loadtime:0.91181302070618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Lewis' limit 1
loadtime:0.91188097000122 / seconds
Query Executed:select id FROM `wa` where city='Fort Lewis' && SIC_code='6021'DB:business_master_new
loadtime:0.91297388076782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Four Lakes' limit 1
loadtime:0.91304183006287 / seconds
Query Executed:select id FROM `wa` where city='Four Lakes' && SIC_code='6021'DB:business_master_new
loadtime:0.91355395317078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fox Island' limit 1
loadtime:0.91360688209534 / seconds
Query Executed:select id FROM `wa` where city='Fox Island' && SIC_code='6021'DB:business_master_new
loadtime:0.91537499427795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeland' limit 1
loadtime:0.91542792320251 / seconds
Query Executed:select id FROM `wa` where city='Freeland' && SIC_code='6021'DB:business_master_new
loadtime:0.92182683944702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeman' limit 1
loadtime:0.92189693450928 / seconds
Query Executed:select id FROM `wa` where city='Freeman' && SIC_code='6021'DB:business_master_new
loadtime:0.92229795455933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Friday Harbor' limit 1
loadtime:0.92235088348389 / seconds
Query Executed:select id FROM `wa` where city='Friday Harbor' && SIC_code='6021'DB:business_master_new
loadtime:0.93556380271912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitland' limit 1
loadtime:0.93564295768738 / seconds
Query Executed:select id FROM `wa` where city='Fruitland' && SIC_code='6021'DB:business_master_new
loadtime:0.93632888793945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galvin' limit 1
loadtime:0.93638300895691 / seconds
Query Executed:select id FROM `wa` where city='Galvin' && SIC_code='6021'DB:business_master_new
loadtime:0.93683481216431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garfield' limit 1
loadtime:0.93688797950745 / seconds
Query Executed:select id FROM `wa` where city='Garfield' && SIC_code='6021'DB:business_master_new
loadtime:0.93804883956909 / seconds
Query loaded from cache:select * from geodata_geocity where city='George' limit 1
loadtime:0.9381148815155 / seconds
Query Executed:select id FROM `wa` where city='George' && SIC_code='6021'DB:business_master_new
loadtime:0.93874382972717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gifford' limit 1
loadtime:0.93879890441895 / seconds
Query Executed:select id FROM `wa` where city='Gifford' && SIC_code='6021'DB:business_master_new
loadtime:0.93927001953125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gig Harbor' limit 1
loadtime:0.93932294845581 / seconds
Query Executed:select id FROM `wa` where city='Gig Harbor' && SIC_code='6021'DB:business_master_new
loadtime:0.9536509513855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glacier' limit 1
loadtime:0.95375800132751 / seconds
Query Executed:select id FROM `wa` where city='Glacier' && SIC_code='6021'DB:business_master_new
loadtime:0.9541699886322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenoma' limit 1
loadtime:0.95422697067261 / seconds
Query Executed:select id FROM `wa` where city='Glenoma' && SIC_code='6021'DB:business_master_new
loadtime:0.95489597320557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:0.95494890213013 / seconds
Query Executed:select id FROM `wa` where city='Glenwood' && SIC_code='6021'DB:business_master_new
loadtime:0.95562291145325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gold Bar' limit 1
loadtime:0.95567393302917 / seconds
Query Executed:select id FROM `wa` where city='Gold Bar' && SIC_code='6021'DB:business_master_new
loadtime:0.95721197128296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldendale' limit 1
loadtime:0.95726490020752 / seconds
Query Executed:select id FROM `wa` where city='Goldendale' && SIC_code='6021'DB:business_master_new
loadtime:0.96212100982666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goose Prairie' limit 1
loadtime:0.96218681335449 / seconds
Query Executed:select id FROM `wa` where city='Goose Prairie' && SIC_code='6021'DB:business_master_new
loadtime:0.96264982223511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gorst' limit 1
loadtime:0.96274590492249 / seconds
Query Executed:select id FROM `wa` where city='Gorst' && SIC_code='6021'DB:business_master_new
loadtime:0.96321082115173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graham' limit 1
loadtime:0.96327185630798 / seconds
Query Executed:select id FROM `wa` where city='Graham' && SIC_code='6021'DB:business_master_new
loadtime:0.9713499546051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Coulee' limit 1
loadtime:0.9714629650116 / seconds
Query Executed:select id FROM `wa` where city='Grand Coulee' && SIC_code='6021'DB:business_master_new
loadtime:0.97353792190552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grandview' limit 1
loadtime:0.97363781929016 / seconds
Query Executed:select id FROM `wa` where city='Grandview' && SIC_code='6021'DB:business_master_new
loadtime:0.980299949646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granger' limit 1
loadtime:0.98041200637817 / seconds
Query Executed:select id FROM `wa` where city='Granger' && SIC_code='6021'DB:business_master_new
loadtime:0.98222684860229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granite Falls' limit 1
loadtime:0.98233079910278 / seconds
Query Executed:select id FROM `wa` where city='Granite Falls' && SIC_code='6021'DB:business_master_new
loadtime:0.98687100410461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grapeview' limit 1
loadtime:0.9869499206543 / seconds
Query Executed:select id FROM `wa` where city='Grapeview' && SIC_code='6021'DB:business_master_new
loadtime:0.98815298080444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grayland' limit 1
loadtime:0.98820900917053 / seconds
Query Executed:select id FROM `wa` where city='Grayland' && SIC_code='6021'DB:business_master_new
loadtime:0.98974180221558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grays River' limit 1
loadtime:0.98980784416199 / seconds
Query Executed:select id FROM `wa` where city='Grays River' && SIC_code='6021'DB:business_master_new
loadtime:0.99032998085022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenacres' limit 1
loadtime:0.9903838634491 / seconds
Query Executed:select id FROM `wa` where city='Greenacres' && SIC_code='6021'DB:business_master_new
loadtime:0.99507284164429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbank' limit 1
loadtime:0.99512600898743 / seconds
Query Executed:select id FROM `wa` where city='Greenbank' && SIC_code='6021'DB:business_master_new
loadtime:0.9963858127594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:0.99645090103149 / seconds
Query Executed:select id FROM `wa` where city='Hamilton' && SIC_code='6021'DB:business_master_new
loadtime:0.99708795547485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hansville' limit 1
loadtime:0.99714088439941 / seconds
Query Executed:select id FROM `wa` where city='Hansville' && SIC_code='6021'DB:business_master_new
loadtime:0.99864983558655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrah' limit 1
loadtime:0.99870300292969 / seconds
Query Executed:select id FROM `wa` where city='Harrah' && SIC_code='6021'DB:business_master_new
loadtime:0.99962186813354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrington' limit 1
loadtime:0.999675989151 / seconds
Query Executed:select id FROM `wa` where city='Harrington' && SIC_code='6021'DB:business_master_new
loadtime:1.0006909370422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartline' limit 1
loadtime:1.0007679462433 / seconds
Query Executed:select id FROM `wa` where city='Hartline' && SIC_code='6021'DB:business_master_new
loadtime:1.0015068054199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatton' limit 1
loadtime:1.0015599727631 / seconds
Query Executed:select id FROM `wa` where city='Hatton' && SIC_code='6021'DB:business_master_new
loadtime:1.0019798278809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hay' limit 1
loadtime:1.002032995224 / seconds
Query Executed:select id FROM `wa` where city='Hay' && SIC_code='6021'DB:business_master_new
loadtime:1.002475976944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heisson' limit 1
loadtime:1.002525806427 / seconds
Query Executed:select id FROM `wa` where city='Heisson' && SIC_code='6021'DB:business_master_new
loadtime:1.0030398368835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hobart' limit 1
loadtime:1.0030999183655 / seconds
Query Executed:select id FROM `wa` where city='Hobart' && SIC_code='6021'DB:business_master_new
loadtime:1.0039308071136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Home' limit 1
loadtime:1.0039908885956 / seconds
Query Executed:select id FROM `wa` where city='Home' && SIC_code='6021'DB:business_master_new
loadtime:1.0043489933014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoodsport' limit 1
loadtime:1.0044000148773 / seconds
Query Executed:select id FROM `wa` where city='Hoodsport' && SIC_code='6021'DB:business_master_new
loadtime:1.0057129859924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hooper' limit 1
loadtime:1.0057740211487 / seconds
Query Executed:select id FROM `wa` where city='Hooper' && SIC_code='6021'DB:business_master_new
loadtime:1.0062220096588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoquiam' limit 1
loadtime:1.0062749385834 / seconds
Query Executed:select id FROM `wa` where city='Hoquiam' && SIC_code='6021'DB:business_master_new
loadtime:1.0131759643555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humptulips' limit 1
loadtime:1.013247013092 / seconds
Query Executed:select id FROM `wa` where city='Humptulips' && SIC_code='6021'DB:business_master_new
loadtime:1.0139470100403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hunters' limit 1
loadtime:1.0140018463135 / seconds
Query Executed:select id FROM `wa` where city='Hunters' && SIC_code='6021'DB:business_master_new
loadtime:1.0148558616638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hunts Point' limit 1
loadtime:1.0149137973785 / seconds
Query Executed:select id FROM `wa` where city='Hunts Point' && SIC_code='6021'DB:business_master_new
loadtime:1.0152878761292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Husum' limit 1
loadtime:1.0153408050537 / seconds
Query Executed:select id FROM `wa` where city='Husum' && SIC_code='6021'DB:business_master_new
loadtime:1.0158519744873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ilwaco' limit 1
loadtime:1.0159080028534 / seconds
Query Executed:select id FROM `wa` where city='Ilwaco' && SIC_code='6021'DB:business_master_new
loadtime:1.0180418491364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Inchelium' limit 1
loadtime:1.0181138515472 / seconds
Query Executed:select id FROM `wa` where city='Inchelium' && SIC_code='6021'DB:business_master_new
loadtime:1.0191040039062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Index' limit 1
loadtime:1.0191588401794 / seconds
Query Executed:select id FROM `wa` where city='Index' && SIC_code='6021'DB:business_master_new
loadtime:1.0198218822479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indianola' limit 1
loadtime:1.0198738574982 / seconds
Query Executed:select id FROM `wa` where city='Indianola' && SIC_code='6021'DB:business_master_new
loadtime:1.0210440158844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ione' limit 1
loadtime:1.021096944809 / seconds
Query Executed:select id FROM `wa` where city='Ione' && SIC_code='6021'DB:business_master_new
loadtime:1.0221018791199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Issaquah' limit 1
loadtime:1.0221679210663 / seconds
Query Executed:select id FROM `wa` where city='Issaquah' && SIC_code='6021'DB:business_master_new
loadtime:1.0365138053894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joyce' limit 1
loadtime:1.0365970134735 / seconds
Query Executed:select id FROM `wa` where city='Joyce' && SIC_code='6021'DB:business_master_new
loadtime:1.0371990203857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kahlotus' limit 1
loadtime:1.0372548103333 / seconds
Query Executed:select id FROM `wa` where city='Kahlotus' && SIC_code='6021'DB:business_master_new
loadtime:1.0378799438477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kalama' limit 1
loadtime:1.0379359722137 / seconds
Query Executed:select id FROM `wa` where city='Kalama' && SIC_code='6021'DB:business_master_new
loadtime:1.0419218540192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kapowsin' limit 1
loadtime:1.0419878959656 / seconds
Query Executed:select id FROM `wa` where city='Kapowsin' && SIC_code='6021'DB:business_master_new
loadtime:1.0425758361816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keller' limit 1
loadtime:1.0426290035248 / seconds
Query Executed:select id FROM `wa` where city='Keller' && SIC_code='6021'DB:business_master_new
loadtime:1.043478012085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kelso' limit 1
loadtime:1.0435309410095 / seconds
Query Executed:select id FROM `wa` where city='Kelso' && SIC_code='6021'DB:business_master_new
loadtime:1.0553297996521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenmore' limit 1
loadtime:1.05539894104 / seconds
Query Executed:select id FROM `wa` where city='Kenmore' && SIC_code='6021'DB:business_master_new
loadtime:1.0643248558044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kennewick' limit 1
loadtime:1.0643939971924 / seconds
Query Executed:select id FROM `wa` where city='Kennewick' && SIC_code='6021'DB:business_master_new
loadtime:1.0782518386841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kent' limit 1
loadtime:1.0783498287201 / seconds
Query Executed:select id FROM `wa` where city='Kent' && SIC_code='6021'DB:business_master_new
loadtime:1.0919740200043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kettle Falls' limit 1
loadtime:1.0920698642731 / seconds
Query Executed:select id FROM `wa` where city='Kettle Falls' && SIC_code='6021'DB:business_master_new
loadtime:1.0954239368439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keyport' limit 1
loadtime:1.0954918861389 / seconds
Query Executed:select id FROM `wa` where city='Keyport' && SIC_code='6021'DB:business_master_new
loadtime:1.0963668823242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:1.0964198112488 / seconds
Query Executed:select id FROM `wa` where city='Kingston' && SIC_code='6021'DB:business_master_new
loadtime:1.1035709381104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirkland' limit 1
loadtime:1.1036419868469 / seconds
Query Executed:select id FROM `wa` where city='Kirkland' && SIC_code='6021'DB:business_master_new
loadtime:1.1173620223999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kittitas' limit 1
loadtime:1.1174600124359 / seconds
Query Executed:select id FROM `wa` where city='Kittitas' && SIC_code='6021'DB:business_master_new
loadtime:1.1182489395142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Klickitat' limit 1
loadtime:1.1183049678802 / seconds
Query Executed:select id FROM `wa` where city='Klickitat' && SIC_code='6021'DB:business_master_new
loadtime:1.118852853775 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Center' limit 1
loadtime:1.1189107894897 / seconds
Query Executed:select id FROM `wa` where city='La Center' && SIC_code='6021'DB:business_master_new
loadtime:1.1225728988647 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Conner' limit 1
loadtime:1.1226389408112 / seconds
Query Executed:select id FROM `wa` where city='La Conner' && SIC_code='6021'DB:business_master_new
loadtime:1.1280148029327 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Grande' limit 1
loadtime:1.1280829906464 / seconds
Query Executed:select id FROM `wa` where city='La Grande' && SIC_code='6021'DB:business_master_new
loadtime:1.1285138130188 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Push' limit 1
loadtime:1.128565788269 / seconds
Query Executed:select id FROM `wa` where city='La Push' && SIC_code='6021'DB:business_master_new
loadtime:1.1291658878326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lacey' limit 1
loadtime:1.1292178630829 / seconds
Query Executed:select id FROM `wa` where city='Lacey' && SIC_code='6021'DB:business_master_new
loadtime:1.1429359912872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lacrosse' limit 1
loadtime:1.1430139541626 / seconds
Query Executed:select id FROM `wa` where city='Lacrosse' && SIC_code='6021'DB:business_master_new
loadtime:1.1443159580231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Forest Park' limit 1
loadtime:1.1443829536438 / seconds
Query Executed:select id FROM `wa` where city='Lake Forest Park' && SIC_code='6021'DB:business_master_new
loadtime:1.1448400020599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Stevens' limit 1
loadtime:1.1448979377747 / seconds
Query Executed:select id FROM `wa` where city='Lake Stevens' && SIC_code='6021'DB:business_master_new
loadtime:1.1551389694214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakebay' limit 1
loadtime:1.1552298069 / seconds
Query Executed:select id FROM `wa` where city='Lakebay' && SIC_code='6021'DB:business_master_new
loadtime:1.1575028896332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakewood' limit 1
loadtime:1.1575589179993 / seconds
Query Executed:select id FROM `wa` where city='Lakewood' && SIC_code='6021'DB:business_master_new
loadtime:1.1713008880615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamona' limit 1
loadtime:1.1713898181915 / seconds
Query Executed:select id FROM `wa` where city='Lamona' && SIC_code='6021'DB:business_master_new
loadtime:1.1718168258667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamont' limit 1
loadtime:1.1718719005585 / seconds
Query Executed:select id FROM `wa` where city='Lamont' && SIC_code='6021'DB:business_master_new
loadtime:1.1725308895111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langley' limit 1
loadtime:1.1725828647614 / seconds
Query Executed:select id FROM `wa` where city='Langley' && SIC_code='6021'DB:business_master_new
loadtime:1.1795690059662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Latah' limit 1
loadtime:1.179634809494 / seconds
Query Executed:select id FROM `wa` where city='Latah' && SIC_code='6021'DB:business_master_new
loadtime:1.1803019046783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurier' limit 1
loadtime:1.1803669929504 / seconds
Query Executed:select id FROM `wa` where city='Laurier' && SIC_code='6021'DB:business_master_new
loadtime:1.1808829307556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leavenworth' limit 1
loadtime:1.1809418201447 / seconds
Query Executed:select id FROM `wa` where city='Leavenworth' && SIC_code='6021'DB:business_master_new
loadtime:1.1894028186798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebam' limit 1
loadtime:1.1894738674164 / seconds
Query Executed:select id FROM `wa` where city='Lebam' && SIC_code='6021'DB:business_master_new
loadtime:1.1899309158325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty Lake' limit 1
loadtime:1.1899859905243 / seconds
Query Executed:select id FROM `wa` where city='Liberty Lake' && SIC_code='6021'DB:business_master_new
loadtime:1.1952519416809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lilliwaup' limit 1
loadtime:1.1953217983246 / seconds
Query Executed:select id FROM `wa` where city='Lilliwaup' && SIC_code='6021'DB:business_master_new
loadtime:1.1960349082947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:1.1960887908936 / seconds
Query Executed:select id FROM `wa` where city='Lincoln' && SIC_code='6021'DB:business_master_new
loadtime:1.1965048313141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lind' limit 1
loadtime:1.19655585289 / seconds
Query Executed:select id FROM `wa` where city='Lind' && SIC_code='6021'DB:business_master_new
loadtime:1.197890996933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littlerock' limit 1
loadtime:1.197958946228 / seconds
Query Executed:select id FROM `wa` where city='Littlerock' && SIC_code='6021'DB:business_master_new
loadtime:1.1985239982605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Beach' limit 1
loadtime:1.1985759735107 / seconds
Query Executed:select id FROM `wa` where city='Long Beach' && SIC_code='6021'DB:business_master_new
loadtime:1.2038497924805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longbranch' limit 1
loadtime:1.2039239406586 / seconds
Query Executed:select id FROM `wa` where city='Longbranch' && SIC_code='6021'DB:business_master_new
loadtime:1.2045118808746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longmire' limit 1
loadtime:1.2045660018921 / seconds
Query Executed:select id FROM `wa` where city='Longmire' && SIC_code='6021'DB:business_master_new
loadtime:1.2049469947815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longview' limit 1
loadtime:1.2050008773804 / seconds
Query Executed:select id FROM `wa` where city='Longview' && SIC_code='6021'DB:business_master_new
loadtime:1.2188878059387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loomis' limit 1
loadtime:1.2189729213715 / seconds
Query Executed:select id FROM `wa` where city='Loomis' && SIC_code='6021'DB:business_master_new
loadtime:1.2196068763733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loon Lake' limit 1
loadtime:1.2196619510651 / seconds
Query Executed:select id FROM `wa` where city='Loon Lake' && SIC_code='6021'DB:business_master_new
loadtime:1.2213599681854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lopez' limit 1
loadtime:1.2214138507843 / seconds
Query Executed:select id FROM `wa` where city='Lopez' && SIC_code='6021'DB:business_master_new
loadtime:1.2218279838562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lopez Island' limit 1
loadtime:1.2219078540802 / seconds
Query Executed:select id FROM `wa` where city='Lopez Island' && SIC_code='6021'DB:business_master_new
loadtime:1.2261679172516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowden' limit 1
loadtime:1.226352930069 / seconds
Query Executed:select id FROM `wa` where city='Lowden' && SIC_code='6021'DB:business_master_new
loadtime:1.2267768383026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lummi Island' limit 1
loadtime:1.2268970012665 / seconds
Query Executed:select id FROM `wa` where city='Lummi Island' && SIC_code='6021'DB:business_master_new
loadtime:1.2279188632965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyle' limit 1
loadtime:1.228001832962 / seconds
Query Executed:select id FROM `wa` where city='Lyle' && SIC_code='6021'DB:business_master_new
loadtime:1.2292349338531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyman' limit 1
loadtime:1.2293198108673 / seconds
Query Executed:select id FROM `wa` where city='Lyman' && SIC_code='6021'DB:business_master_new
loadtime:1.2298970222473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynden' limit 1
loadtime:1.2299778461456 / seconds
Query Executed:select id FROM `wa` where city='Lynden' && SIC_code='6021'DB:business_master_new
loadtime:1.2414398193359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynnwood' limit 1
loadtime:1.2415599822998 / seconds
Query Executed:select id FROM `wa` where city='Lynnwood' && SIC_code='6021'DB:business_master_new
loadtime:1.2558948993683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mabton' limit 1
loadtime:1.2560799121857 / seconds
Query Executed:select id FROM `wa` where city='Mabton' && SIC_code='6021'DB:business_master_new
loadtime:1.2576739788055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malaga' limit 1
loadtime:1.2577979564667 / seconds
Query Executed:select id FROM `wa` where city='Malaga' && SIC_code='6021'DB:business_master_new
loadtime:1.2591760158539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malden' limit 1
loadtime:1.259260892868 / seconds
Query Executed:select id FROM `wa` where city='Malden' && SIC_code='6021'DB:business_master_new
loadtime:1.2597889900208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malo' limit 1
loadtime:1.2598738670349 / seconds
Query Executed:select id FROM `wa` where city='Malo' && SIC_code='6021'DB:business_master_new
loadtime:1.2606418132782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malone' limit 1
loadtime:1.2607378959656 / seconds
Query Executed:select id FROM `wa` where city='Malone' && SIC_code='6021'DB:business_master_new
loadtime:1.2612268924713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malott' limit 1
loadtime:1.2613079547882 / seconds
Query Executed:select id FROM `wa` where city='Malott' && SIC_code='6021'DB:business_master_new
loadtime:1.2619860172272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:1.2620677947998 / seconds
Query Executed:select id FROM `wa` where city='Manchester' && SIC_code='6021'DB:business_master_new
loadtime:1.2629108428955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield' limit 1
loadtime:1.2629950046539 / seconds
Query Executed:select id FROM `wa` where city='Mansfield' && SIC_code='6021'DB:business_master_new
loadtime:1.2638669013977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manson' limit 1
loadtime:1.2639448642731 / seconds
Query Executed:select id FROM `wa` where city='Manson' && SIC_code='6021'DB:business_master_new
loadtime:1.266539812088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple Falls' limit 1
loadtime:1.266618013382 / seconds
Query Executed:select id FROM `wa` where city='Maple Falls' && SIC_code='6021'DB:business_master_new
loadtime:1.2680308818817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple Valley' limit 1
loadtime:1.2680878639221 / seconds
Query Executed:select id FROM `wa` where city='Maple Valley' && SIC_code='6021'DB:business_master_new
loadtime:1.2781438827515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marblemount' limit 1
loadtime:1.2782189846039 / seconds
Query Executed:select id FROM `wa` where city='Marblemount' && SIC_code='6021'DB:business_master_new
loadtime:1.2789390087128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marcus' limit 1
loadtime:1.2789928913116 / seconds
Query Executed:select id FROM `wa` where city='Marcus' && SIC_code='6021'DB:business_master_new
loadtime:1.2794749736786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlin' limit 1
loadtime:1.2795259952545 / seconds
Query Executed:select id FROM `wa` where city='Marlin' && SIC_code='6021'DB:business_master_new
loadtime:1.2800989151001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshall' limit 1
loadtime:1.2801518440247 / seconds
Query Executed:select id FROM `wa` where city='Marshall' && SIC_code='6021'DB:business_master_new
loadtime:1.2806339263916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marysville' limit 1
loadtime:1.2806968688965 / seconds
Query Executed:select id FROM `wa` where city='Marysville' && SIC_code='6021'DB:business_master_new
loadtime:1.2948319911957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Matlock' limit 1
loadtime:1.2949178218842 / seconds
Query Executed:select id FROM `wa` where city='Matlock' && SIC_code='6021'DB:business_master_new
loadtime:1.2953310012817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattawa' limit 1
loadtime:1.2953848838806 / seconds
Query Executed:select id FROM `wa` where city='Mattawa' && SIC_code='6021'DB:business_master_new
loadtime:1.2988278865814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mazama' limit 1
loadtime:1.2988998889923 / seconds
Query Executed:select id FROM `wa` where city='Mazama' && SIC_code='6021'DB:business_master_new
loadtime:1.2995398044586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Cleary' limit 1
loadtime:1.2995929718018 / seconds
Query Executed:select id FROM `wa` where city='Mc Cleary' && SIC_code='6021'DB:business_master_new
loadtime:1.3000018596649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Kenna' limit 1
loadtime:1.3000547885895 / seconds
Query Executed:select id FROM `wa` where city='Mc Kenna' && SIC_code='6021'DB:business_master_new
loadtime:1.3004438877106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mcchord Afb' limit 1
loadtime:1.3004949092865 / seconds
Query Executed:select id FROM `wa` where city='Mcchord Afb' && SIC_code='6021'DB:business_master_new
loadtime:1.3012719154358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mccleary' limit 1
loadtime:1.3013370037079 / seconds
Query Executed:select id FROM `wa` where city='Mccleary' && SIC_code='6021'DB:business_master_new
loadtime:1.3030979633331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mckenna' limit 1
loadtime:1.3031640052795 / seconds
Query Executed:select id FROM `wa` where city='Mckenna' && SIC_code='6021'DB:business_master_new
loadtime:1.3041398525238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mead' limit 1
loadtime:1.3041949272156 / seconds
Query Executed:select id FROM `wa` where city='Mead' && SIC_code='6021'DB:business_master_new
loadtime:1.3092880249023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medical Lake' limit 1
loadtime:1.3093419075012 / seconds
Query Executed:select id FROM `wa` where city='Medical Lake' && SIC_code='6021'DB:business_master_new
loadtime:1.3131790161133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medina' limit 1
loadtime:1.3132519721985 / seconds
Query Executed:select id FROM `wa` where city='Medina' && SIC_code='6021'DB:business_master_new
loadtime:1.3149409294128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menlo' limit 1
loadtime:1.3149948120117 / seconds
Query Executed:select id FROM `wa` where city='Menlo' && SIC_code='6021'DB:business_master_new
loadtime:1.3155348300934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mercer Island' limit 1
loadtime:1.3155858516693 / seconds
Query Executed:select id FROM `wa` where city='Mercer Island' && SIC_code='6021'DB:business_master_new
loadtime:1.3293600082397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesa' limit 1
loadtime:1.3294479846954 / seconds
Query Executed:select id FROM `wa` where city='Mesa' && SIC_code='6021'DB:business_master_new
loadtime:1.3313889503479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Metaline' limit 1
loadtime:1.3314459323883 / seconds
Query Executed:select id FROM `wa` where city='Metaline' && SIC_code='6021'DB:business_master_new
loadtime:1.3320088386536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Metaline Falls' limit 1
loadtime:1.3320620059967 / seconds
Query Executed:select id FROM `wa` where city='Metaline Falls' && SIC_code='6021'DB:business_master_new
loadtime:1.3330068588257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Methow' limit 1
loadtime:1.3330600261688 / seconds
Query Executed:select id FROM `wa` where city='Methow' && SIC_code='6021'DB:business_master_new
loadtime:1.33358502388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mica' limit 1
loadtime:1.3336358070374 / seconds
Query Executed:select id FROM `wa` where city='Mica' && SIC_code='6021'DB:business_master_new
loadtime:1.3342578411102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mill Creek' limit 1
loadtime:1.3343110084534 / seconds
Query Executed:select id FROM `wa` where city='Mill Creek' && SIC_code='6021'DB:business_master_new
loadtime:1.3374218940735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:1.3374929428101 / seconds
Query Executed:select id FROM `wa` where city='Milton' && SIC_code='6021'DB:business_master_new
loadtime:1.3430478572845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineral' limit 1
loadtime:1.3431189060211 / seconds
Query Executed:select id FROM `wa` where city='Mineral' && SIC_code='6021'DB:business_master_new
loadtime:1.3438339233398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moclips' limit 1
loadtime:1.3438940048218 / seconds
Query Executed:select id FROM `wa` where city='Moclips' && SIC_code='6021'DB:business_master_new
loadtime:1.3444418907166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mohler' limit 1
loadtime:1.3444929122925 / seconds
Query Executed:select id FROM `wa` where city='Mohler' && SIC_code='6021'DB:business_master_new
loadtime:1.3449478149414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monitor' limit 1
loadtime:1.3450019359589 / seconds
Query Executed:select id FROM `wa` where city='Monitor' && SIC_code='6021'DB:business_master_new
loadtime:1.345794916153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:1.3458487987518 / seconds
Query Executed:select id FROM `wa` where city='Monroe' && SIC_code='6021'DB:business_master_new
loadtime:1.3596038818359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montesano' limit 1
loadtime:1.3596909046173 / seconds
Query Executed:select id FROM `wa` where city='Montesano' && SIC_code='6021'DB:business_master_new
loadtime:1.3658399581909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morton' limit 1
loadtime:1.3659148216248 / seconds
Query Executed:select id FROM `wa` where city='Morton' && SIC_code='6021'DB:business_master_new
loadtime:1.3683388233185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moses Lake' limit 1
loadtime:1.3684098720551 / seconds
Query Executed:select id FROM `wa` where city='Moses Lake' && SIC_code='6021'DB:business_master_new
loadtime:1.3820807933807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mossyrock' limit 1
loadtime:1.3821609020233 / seconds
Query Executed:select id FROM `wa` where city='Mossyrock' && SIC_code='6021'DB:business_master_new
loadtime:1.3841099739075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Vernon' limit 1
loadtime:1.3841660022736 / seconds
Query Executed:select id FROM `wa` where city='Mount Vernon' && SIC_code='6021'DB:business_master_new
loadtime:1.3978009223938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountlake Ter' limit 1
loadtime:1.3978939056396 / seconds
Query Executed:select id FROM `wa` where city='Mountlake Ter' && SIC_code='6021'DB:business_master_new
loadtime:1.3985598087311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountlake Terrace' limit 1
loadtime:1.3986158370972 / seconds
Query Executed:select id FROM `wa` where city='Mountlake Terrace' && SIC_code='6021'DB:business_master_new
loadtime:1.4082548618317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moxee' limit 1
loadtime:1.4083259105682 / seconds
Query Executed:select id FROM `wa` where city='Moxee' && SIC_code='6021'DB:business_master_new
loadtime:1.410434961319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Vernon' limit 1
loadtime:1.4104897975922 / seconds
Query Executed:select id FROM `wa` where city='Mt Vernon' && SIC_code='6021'DB:business_master_new
loadtime:1.4119198322296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mukilteo' limit 1
loadtime:1.4119749069214 / seconds
Query Executed:select id FROM `wa` where city='Mukilteo' && SIC_code='6021'DB:business_master_new
loadtime:1.4243350028992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naches' limit 1
loadtime:1.424409866333 / seconds
Query Executed:select id FROM `wa` where city='Naches' && SIC_code='6021'DB:business_master_new
loadtime:1.4281578063965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nahcotta' limit 1
loadtime:1.4282288551331 / seconds
Query Executed:select id FROM `wa` where city='Nahcotta' && SIC_code='6021'DB:business_master_new
loadtime:1.4288589954376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Napavine' limit 1
loadtime:1.4289150238037 / seconds
Query Executed:select id FROM `wa` where city='Napavine' && SIC_code='6021'DB:business_master_new
loadtime:1.4299459457397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nas Whidbey' limit 1
loadtime:1.4299998283386 / seconds
Query Executed:select id FROM `wa` where city='Nas Whidbey' && SIC_code='6021'DB:business_master_new
loadtime:1.4304118156433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naselle' limit 1
loadtime:1.4304649829865 / seconds
Query Executed:select id FROM `wa` where city='Naselle' && SIC_code='6021'DB:business_master_new
loadtime:1.4318778514862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neah Bay' limit 1
loadtime:1.4319438934326 / seconds
Query Executed:select id FROM `wa` where city='Neah Bay' && SIC_code='6021'DB:business_master_new
loadtime:1.4329428672791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neilton' limit 1
loadtime:1.4329969882965 / seconds
Query Executed:select id FROM `wa` where city='Neilton' && SIC_code='6021'DB:business_master_new
loadtime:1.4334750175476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nespelem' limit 1
loadtime:1.433525800705 / seconds
Query Executed:select id FROM `wa` where city='Nespelem' && SIC_code='6021'DB:business_master_new
loadtime:1.4345688819885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newcastle' limit 1
loadtime:1.4346218109131 / seconds
Query Executed:select id FROM `wa` where city='Newcastle' && SIC_code='6021'DB:business_master_new
loadtime:1.4350569248199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newman Lake' limit 1
loadtime:1.4351108074188 / seconds
Query Executed:select id FROM `wa` where city='Newman Lake' && SIC_code='6021'DB:business_master_new
loadtime:1.4373137950897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:1.4373669624329 / seconds
Query Executed:select id FROM `wa` where city='Newport' && SIC_code='6021'DB:business_master_new
loadtime:1.4435558319092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nine Mile Falls' limit 1
loadtime:1.4436240196228 / seconds
Query Executed:select id FROM `wa` where city='Nine Mile Falls' && SIC_code='6021'DB:business_master_new
loadtime:1.4479458332062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nooksack' limit 1
loadtime:1.4480118751526 / seconds
Query Executed:select id FROM `wa` where city='Nooksack' && SIC_code='6021'DB:business_master_new
loadtime:1.448746919632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nordland' limit 1
loadtime:1.4488008022308 / seconds
Query Executed:select id FROM `wa` where city='Nordland' && SIC_code='6021'DB:business_master_new
loadtime:1.4498770236969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Normandy Park' limit 1
loadtime:1.4499299526215 / seconds
Query Executed:select id FROM `wa` where city='Normandy Park' && SIC_code='6021'DB:business_master_new
loadtime:1.4503598213196 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Bend' limit 1
loadtime:1.4504108428955 / seconds
Query Executed:select id FROM `wa` where city='North Bend' && SIC_code='6021'DB:business_master_new
loadtime:1.4587779045105 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Bonneville' limit 1
loadtime:1.4588508605957 / seconds
Query Executed:select id FROM `wa` where city='North Bonneville' && SIC_code='6021'DB:business_master_new
loadtime:1.4597599506378 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Lakewood' limit 1
loadtime:1.4598150253296 / seconds
Query Executed:select id FROM `wa` where city='North Lakewood' && SIC_code='6021'DB:business_master_new
loadtime:1.460343837738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northport' limit 1
loadtime:1.4603970050812 / seconds
Query Executed:select id FROM `wa` where city='Northport' && SIC_code='6021'DB:business_master_new
loadtime:1.4615008831024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Harbor' limit 1
loadtime:1.4615559577942 / seconds
Query Executed:select id FROM `wa` where city='Oak Harbor' && SIC_code='6021'DB:business_master_new
loadtime:1.4757769107819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakesdale' limit 1
loadtime:1.4758579730988 / seconds
Query Executed:select id FROM `wa` where city='Oakesdale' && SIC_code='6021'DB:business_master_new
loadtime:1.4768788814545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakville' limit 1
loadtime:1.4769458770752 / seconds
Query Executed:select id FROM `wa` where city='Oakville' && SIC_code='6021'DB:business_master_new
loadtime:1.4782400131226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean City' limit 1
loadtime:1.4783048629761 / seconds
Query Executed:select id FROM `wa` where city='Ocean City' && SIC_code='6021'DB:business_master_new
loadtime:1.4787578582764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Park' limit 1
loadtime:1.4788119792938 / seconds
Query Executed:select id FROM `wa` where city='Ocean Park' && SIC_code='6021'DB:business_master_new
loadtime:1.4815068244934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Shores' limit 1
loadtime:1.4815728664398 / seconds
Query Executed:select id FROM `wa` where city='Ocean Shores' && SIC_code='6021'DB:business_master_new
loadtime:1.4875569343567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Odessa' limit 1
loadtime:1.487625837326 / seconds
Query Executed:select id FROM `wa` where city='Odessa' && SIC_code='6021'DB:business_master_new
loadtime:1.4895889759064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okanogan' limit 1
loadtime:1.4896600246429 / seconds
Query Executed:select id FROM `wa` where city='Okanogan' && SIC_code='6021'DB:business_master_new
loadtime:1.4942729473114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olalla' limit 1
loadtime:1.4943428039551 / seconds
Query Executed:select id FROM `wa` where city='Olalla' && SIC_code='6021'DB:business_master_new
loadtime:1.4965069293976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olga' limit 1
loadtime:1.4965608119965 / seconds
Query Executed:select id FROM `wa` where city='Olga' && SIC_code='6021'DB:business_master_new
loadtime:1.497496843338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olympia' limit 1
loadtime:1.4975500106812 / seconds
Query Executed:select id FROM `wa` where city='Olympia' && SIC_code='6021'DB:business_master_new
loadtime:1.5113198757172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Omak' limit 1
loadtime:1.5114068984985 / seconds
Query Executed:select id FROM `wa` where city='Omak' && SIC_code='6021'DB:business_master_new
loadtime:1.5190780162811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onalaska' limit 1
loadtime:1.519152879715 / seconds
Query Executed:select id FROM `wa` where city='Onalaska' && SIC_code='6021'DB:business_master_new
loadtime:1.5215728282928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orcas' limit 1
loadtime:1.5216288566589 / seconds
Query Executed:select id FROM `wa` where city='Orcas' && SIC_code='6021'DB:business_master_new
loadtime:1.5227928161621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orchards' limit 1
loadtime:1.5228478908539 / seconds
Query Executed:select id FROM `wa` where city='Orchards' && SIC_code='6021'DB:business_master_new
loadtime:1.5233309268951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orient' limit 1
loadtime:1.5233838558197 / seconds
Query Executed:select id FROM `wa` where city='Orient' && SIC_code='6021'DB:business_master_new
loadtime:1.5239717960358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orondo' limit 1
loadtime:1.5240249633789 / seconds
Query Executed:select id FROM `wa` where city='Orondo' && SIC_code='6021'DB:business_master_new
loadtime:1.5253069400787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oroville' limit 1
loadtime:1.5253767967224 / seconds
Query Executed:select id FROM `wa` where city='Oroville' && SIC_code='6021'DB:business_master_new
loadtime:1.5290818214417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orting' limit 1
loadtime:1.5291638374329 / seconds
Query Executed:select id FROM `wa` where city='Orting' && SIC_code='6021'DB:business_master_new
loadtime:1.5330560207367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Othello' limit 1
loadtime:1.5331268310547 / seconds
Query Executed:select id FROM `wa` where city='Othello' && SIC_code='6021'DB:business_master_new
loadtime:1.5419828891754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otis Orchards' limit 1
loadtime:1.5420558452606 / seconds
Query Executed:select id FROM `wa` where city='Otis Orchards' && SIC_code='6021'DB:business_master_new
loadtime:1.5450398921967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Outlook' limit 1
loadtime:1.5450968742371 / seconds
Query Executed:select id FROM `wa` where city='Outlook' && SIC_code='6021'DB:business_master_new
loadtime:1.5462110042572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oysterville' limit 1
loadtime:1.5462639331818 / seconds
Query Executed:select id FROM `wa` where city='Oysterville' && SIC_code='6021'DB:business_master_new
loadtime:1.5468080043793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pacific' limit 1
loadtime:1.5468599796295 / seconds
Query Executed:select id FROM `wa` where city='Pacific' && SIC_code='6021'DB:business_master_new
loadtime:1.5491869449615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pacific Beach' limit 1
loadtime:1.5492429733276 / seconds
Query Executed:select id FROM `wa` where city='Pacific Beach' && SIC_code='6021'DB:business_master_new
loadtime:1.5501627922058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Packwood' limit 1
loadtime:1.5502288341522 / seconds
Query Executed:select id FROM `wa` where city='Packwood' && SIC_code='6021'DB:business_master_new
loadtime:1.551600933075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palisades' limit 1
loadtime:1.5516579151154 / seconds
Query Executed:select id FROM `wa` where city='Palisades' && SIC_code='6021'DB:business_master_new
loadtime:1.5522348880768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palouse' limit 1
loadtime:1.552286863327 / seconds
Query Executed:select id FROM `wa` where city='Palouse' && SIC_code='6021'DB:business_master_new
loadtime:1.5535769462585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parker' limit 1
loadtime:1.5536439418793 / seconds
Query Executed:select id FROM `wa` where city='Parker' && SIC_code='6021'DB:business_master_new
loadtime:1.5541648864746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parkland' limit 1
loadtime:1.5542190074921 / seconds
Query Executed:select id FROM `wa` where city='Parkland' && SIC_code='6021'DB:business_master_new
loadtime:1.5546228885651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pasco' limit 1
loadtime:1.5546729564667 / seconds
Query Executed:select id FROM `wa` where city='Pasco' && SIC_code='6021'DB:business_master_new
loadtime:1.5690369606018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pateros' limit 1
loadtime:1.5691299438477 / seconds
Query Executed:select id FROM `wa` where city='Pateros' && SIC_code='6021'DB:business_master_new
loadtime:1.5703568458557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paterson' limit 1
loadtime:1.570426940918 / seconds
Query Executed:select id FROM `wa` where city='Paterson' && SIC_code='6021'DB:business_master_new
loadtime:1.5712118148804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pe Ell' limit 1
loadtime:1.5712659358978 / seconds
Query Executed:select id FROM `wa` where city='Pe Ell' && SIC_code='6021'DB:business_master_new
loadtime:1.5720570087433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peshastin' limit 1
loadtime:1.5721218585968 / seconds
Query Executed:select id FROM `wa` where city='Peshastin' && SIC_code='6021'DB:business_master_new
loadtime:1.5735909938812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:1.5736448764801 / seconds
Query Executed:select id FROM `wa` where city='Plymouth' && SIC_code='6021'DB:business_master_new
loadtime:1.5741369724274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Point Roberts' limit 1
loadtime:1.5741899013519 / seconds
Query Executed:select id FROM `wa` where city='Point Roberts' && SIC_code='6021'DB:business_master_new
loadtime:1.5762338638306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomeroy' limit 1
loadtime:1.5762867927551 / seconds
Query Executed:select id FROM `wa` where city='Pomeroy' && SIC_code='6021'DB:business_master_new
loadtime:1.5789909362793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Angeles' limit 1
loadtime:1.579060792923 / seconds
Query Executed:select id FROM `wa` where city='Port Angeles' && SIC_code='6021'DB:business_master_new
loadtime:1.5929288864136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Gamble' limit 1
loadtime:1.5930140018463 / seconds
Query Executed:select id FROM `wa` where city='Port Gamble' && SIC_code='6021'DB:business_master_new
loadtime:1.593652009964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Hadlock' limit 1
loadtime:1.5937058925629 / seconds
Query Executed:select id FROM `wa` where city='Port Hadlock' && SIC_code='6021'DB:business_master_new
loadtime:1.5982859134674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Ludlow' limit 1
loadtime:1.5983548164368 / seconds
Query Executed:select id FROM `wa` where city='Port Ludlow' && SIC_code='6021'DB:business_master_new
loadtime:1.6009678840637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Orchard' limit 1
loadtime:1.6010370254517 / seconds
Query Executed:select id FROM `wa` where city='Port Orchard' && SIC_code='6021'DB:business_master_new
loadtime:1.6147339344025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Townsend' limit 1
loadtime:1.6148128509521 / seconds
Query Executed:select id FROM `wa` where city='Port Townsend' && SIC_code='6021'DB:business_master_new
loadtime:1.6284058094025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poulsbo' limit 1
loadtime:1.6284849643707 / seconds
Query Executed:select id FROM `wa` where city='Poulsbo' && SIC_code='6021'DB:business_master_new
loadtime:1.6420769691467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott' limit 1
loadtime:1.642157793045 / seconds
Query Executed:select id FROM `wa` where city='Prescott' && SIC_code='6021'DB:business_master_new
loadtime:1.6432149410248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Preston' limit 1
loadtime:1.6432700157166 / seconds
Query Executed:select id FROM `wa` where city='Preston' && SIC_code='6021'DB:business_master_new
loadtime:1.6442627906799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prosser' limit 1
loadtime:1.6443159580231 / seconds
Query Executed:select id FROM `wa` where city='Prosser' && SIC_code='6021'DB:business_master_new
loadtime:1.652046918869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pullman' limit 1
loadtime:1.6521170139313 / seconds
Query Executed:select id FROM `wa` where city='Pullman' && SIC_code='6021'DB:business_master_new
loadtime:1.6647458076477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Puyallup' limit 1
loadtime:1.6648178100586 / seconds
Query Executed:select id FROM `wa` where city='Puyallup' && SIC_code='6021'DB:business_master_new
loadtime:1.678689956665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quilcene' limit 1
loadtime:1.678820848465 / seconds
Query Executed:select id FROM `wa` where city='Quilcene' && SIC_code='6021'DB:business_master_new
loadtime:1.6808478832245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinault' limit 1
loadtime:1.6809248924255 / seconds
Query Executed:select id FROM `wa` where city='Quinault' && SIC_code='6021'DB:business_master_new
loadtime:1.681499004364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quincy' limit 1
loadtime:1.6815528869629 / seconds
Query Executed:select id FROM `wa` where city='Quincy' && SIC_code='6021'DB:business_master_new
loadtime:1.6883969306946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rainier' limit 1
loadtime:1.6884689331055 / seconds
Query Executed:select id FROM `wa` where city='Rainier' && SIC_code='6021'DB:business_master_new
loadtime:1.6908888816833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randle' limit 1
loadtime:1.690948009491 / seconds
Query Executed:select id FROM `wa` where city='Randle' && SIC_code='6021'DB:business_master_new
loadtime:1.6926310062408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ravensdale' limit 1
loadtime:1.6926848888397 / seconds
Query Executed:select id FROM `wa` where city='Ravensdale' && SIC_code='6021'DB:business_master_new
loadtime:1.6941998004913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:1.6942539215088 / seconds
Query Executed:select id FROM `wa` where city='Raymond' && SIC_code='6021'DB:business_master_new
loadtime:1.6992139816284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reardan' limit 1
loadtime:1.6992828845978 / seconds
Query Executed:select id FROM `wa` where city='Reardan' && SIC_code='6021'DB:business_master_new
loadtime:1.7005758285522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redmond' limit 1
loadtime:1.700642824173 / seconds
Query Executed:select id FROM `wa` where city='Redmond' && SIC_code='6021'DB:business_master_new
loadtime:1.7144408226013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redondo' limit 1
loadtime:1.7145278453827 / seconds
Query Executed:select id FROM `wa` where city='Redondo' && SIC_code='6021'DB:business_master_new
loadtime:1.7150440216064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Renton' limit 1
loadtime:1.715099811554 / seconds
Query Executed:select id FROM `wa` where city='Renton' && SIC_code='6021'DB:business_master_new
loadtime:1.7286930084229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Republic' limit 1
loadtime:1.7287919521332 / seconds
Query Executed:select id FROM `wa` where city='Republic' && SIC_code='6021'DB:business_master_new
loadtime:1.733108997345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Retsil' limit 1
loadtime:1.7331779003143 / seconds
Query Executed:select id FROM `wa` where city='Retsil' && SIC_code='6021'DB:business_master_new
loadtime:1.7336299419403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rice' limit 1
loadtime:1.7336838245392 / seconds
Query Executed:select id FROM `wa` where city='Rice' && SIC_code='6021'DB:business_master_new
loadtime:1.7344899177551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland' limit 1
loadtime:1.7345428466797 / seconds
Query Executed:select id FROM `wa` where city='Richland' && SIC_code='6021'DB:business_master_new
loadtime:1.7481999397278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgefield' limit 1
loadtime:1.7482788562775 / seconds
Query Executed:select id FROM `wa` where city='Ridgefield' && SIC_code='6021'DB:business_master_new
loadtime:1.7568318843842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ritzville' limit 1
loadtime:1.7569057941437 / seconds
Query Executed:select id FROM `wa` where city='Ritzville' && SIC_code='6021'DB:business_master_new
loadtime:1.7612400054932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:1.7613079547882 / seconds
Query Executed:select id FROM `wa` where city='Riverside' && SIC_code='6021'DB:business_master_new
loadtime:1.7622969150543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:1.7623519897461 / seconds
Query Executed:select id FROM `wa` where city='Rochester' && SIC_code='6021'DB:business_master_new
loadtime:1.7678468227386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Island' limit 1
loadtime:1.7679059505463 / seconds
Query Executed:select id FROM `wa` where city='Rock Island' && SIC_code='6021'DB:business_master_new
loadtime:1.7689578533173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockford' limit 1
loadtime:1.7690110206604 / seconds
Query Executed:select id FROM `wa` where city='Rockford' && SIC_code='6021'DB:business_master_new
loadtime:1.7702078819275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockport' limit 1
loadtime:1.7702748775482 / seconds
Query Executed:select id FROM `wa` where city='Rockport' && SIC_code='6021'DB:business_master_new
loadtime:1.7709288597107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rollingbay' limit 1
loadtime:1.7709829807281 / seconds
Query Executed:select id FROM `wa` where city='Rollingbay' && SIC_code='6021'DB:business_master_new
loadtime:1.7717578411102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ronald' limit 1
loadtime:1.7718110084534 / seconds
Query Executed:select id FROM `wa` where city='Ronald' && SIC_code='6021'DB:business_master_new
loadtime:1.772481918335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roosevelt' limit 1
loadtime:1.7725338935852 / seconds
Query Executed:select id FROM `wa` where city='Roosevelt' && SIC_code='6021'DB:business_master_new
loadtime:1.7730548381805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosalia' limit 1
loadtime:1.7731080055237 / seconds
Query Executed:select id FROM `wa` where city='Rosalia' && SIC_code='6021'DB:business_master_new
loadtime:1.7745468616486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosburg' limit 1
loadtime:1.7746160030365 / seconds
Query Executed:select id FROM `wa` where city='Rosburg' && SIC_code='6021'DB:business_master_new
loadtime:1.775319814682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roslyn' limit 1
loadtime:1.7753748893738 / seconds
Query Executed:select id FROM `wa` where city='Roslyn' && SIC_code='6021'DB:business_master_new
loadtime:1.7768700122833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roy' limit 1
loadtime:1.7769420146942 / seconds
Query Executed:select id FROM `wa` where city='Roy' && SIC_code='6021'DB:business_master_new
loadtime:1.7811098098755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Royal City' limit 1
loadtime:1.7811639308929 / seconds
Query Executed:select id FROM `wa` where city='Royal City' && SIC_code='6021'DB:business_master_new
loadtime:1.7834639549255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruston' limit 1
loadtime:1.7835328578949 / seconds
Query Executed:select id FROM `wa` where city='Ruston' && SIC_code='6021'DB:business_master_new
loadtime:1.7839159965515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ryderwood' limit 1
loadtime:1.7839698791504 / seconds
Query Executed:select id FROM `wa` where city='Ryderwood' && SIC_code='6021'DB:business_master_new
loadtime:1.7844939231873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint John' limit 1
loadtime:1.7845449447632 / seconds
Query Executed:select id FROM `wa` where city='Saint John' && SIC_code='6021'DB:business_master_new
loadtime:1.7862918376923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salkum' limit 1
loadtime:1.7863578796387 / seconds
Query Executed:select id FROM `wa` where city='Salkum' && SIC_code='6021'DB:business_master_new
loadtime:1.7872798442841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sammamish' limit 1
loadtime:1.7873339653015 / seconds
Query Executed:select id FROM `wa` where city='Sammamish' && SIC_code='6021'DB:business_master_new
loadtime:1.7996218204498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Satsop' limit 1
loadtime:1.7996988296509 / seconds
Query Executed:select id FROM `wa` where city='Satsop' && SIC_code='6021'DB:business_master_new
loadtime:1.8004059791565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seabeck' limit 1
loadtime:1.8004608154297 / seconds
Query Executed:select id FROM `wa` where city='Seabeck' && SIC_code='6021'DB:business_master_new
loadtime:1.802628993988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seahurst' limit 1
loadtime:1.8026819229126 / seconds
Query Executed:select id FROM `wa` where city='Seahurst' && SIC_code='6021'DB:business_master_new
loadtime:1.8034219741821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seatac' limit 1
loadtime:1.8034749031067 / seconds
Query Executed:select id FROM `wa` where city='Seatac' && SIC_code='6021'DB:business_master_new
loadtime:1.8042008876801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seattle' limit 1
loadtime:1.8042538166046 / seconds
Query Executed:select id FROM `wa` where city='Seattle' && SIC_code='6021'DB:business_master_new
loadtime:1.8186428546906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaview' limit 1
loadtime:1.8189988136292 / seconds
Query Executed:select id FROM `wa` where city='Seaview' && SIC_code='6021'DB:business_master_new
loadtime:1.8202660083771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedro Woolley' limit 1
loadtime:1.820338010788 / seconds
Query Executed:select id FROM `wa` where city='Sedro Woolley' && SIC_code='6021'DB:business_master_new
loadtime:1.8317608833313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sekiu' limit 1
loadtime:1.8318588733673 / seconds
Query Executed:select id FROM `wa` where city='Sekiu' && SIC_code='6021'DB:business_master_new
loadtime:1.8326199054718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selah' limit 1
loadtime:1.8326728343964 / seconds
Query Executed:select id FROM `wa` where city='Selah' && SIC_code='6021'DB:business_master_new
loadtime:1.8410789966583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sequim' limit 1
loadtime:1.8411478996277 / seconds
Query Executed:select id FROM `wa` where city='Sequim' && SIC_code='6021'DB:business_master_new
loadtime:1.8556339740753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seven Bays' limit 1
loadtime:1.8557360172272 / seconds
Query Executed:select id FROM `wa` where city='Seven Bays' && SIC_code='6021'DB:business_master_new
loadtime:1.8562169075012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaw Island' limit 1
loadtime:1.856271982193 / seconds
Query Executed:select id FROM `wa` where city='Shaw Island' && SIC_code='6021'DB:business_master_new
loadtime:1.8569300174713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelton' limit 1
loadtime:1.8569839000702 / seconds
Query Executed:select id FROM `wa` where city='Shelton' && SIC_code='6021'DB:business_master_new
loadtime:1.872496843338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shoreline' limit 1
loadtime:1.8725779056549 / seconds
Query Executed:select id FROM `wa` where city='Shoreline' && SIC_code='6021'DB:business_master_new
loadtime:1.8732988834381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silvana' limit 1
loadtime:1.8733530044556 / seconds
Query Executed:select id FROM `wa` where city='Silvana' && SIC_code='6021'DB:business_master_new
loadtime:1.8740479946136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Creek' limit 1
loadtime:1.8740999698639 / seconds
Query Executed:select id FROM `wa` where city='Silver Creek' && SIC_code='6021'DB:business_master_new
loadtime:1.8748350143433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silverdale' limit 1
loadtime:1.8748888969421 / seconds
Query Executed:select id FROM `wa` where city='Silverdale' && SIC_code='6021'DB:business_master_new
loadtime:1.8890309333801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silverlake' limit 1
loadtime:1.8891158103943 / seconds
Query Executed:select id FROM `wa` where city='Silverlake' && SIC_code='6021'DB:business_master_new
loadtime:1.8898248672485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skamokawa' limit 1
loadtime:1.889878988266 / seconds
Query Executed:select id FROM `wa` where city='Skamokawa' && SIC_code='6021'DB:business_master_new
loadtime:1.8906238079071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skokomish Nation' limit 1
loadtime:1.8906760215759 / seconds
Query Executed:select id FROM `wa` where city='Skokomish Nation' && SIC_code='6021'DB:business_master_new
loadtime:1.8910729885101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skykomish' limit 1
loadtime:1.8911259174347 / seconds
Query Executed:select id FROM `wa` where city='Skykomish' && SIC_code='6021'DB:business_master_new
loadtime:1.8917438983917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snohomish' limit 1
loadtime:1.8917968273163 / seconds
Query Executed:select id FROM `wa` where city='Snohomish' && SIC_code='6021'DB:business_master_new
loadtime:1.9054138660431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snoqualmie' limit 1
loadtime:1.9054899215698 / seconds
Query Executed:select id FROM `wa` where city='Snoqualmie' && SIC_code='6021'DB:business_master_new
loadtime:1.9099009037018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snoqualmie Pass' limit 1
loadtime:1.9099688529968 / seconds
Query Executed:select id FROM `wa` where city='Snoqualmie Pass' && SIC_code='6021'DB:business_master_new
loadtime:1.9106369018555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Soap Lake' limit 1
loadtime:1.9106888771057 / seconds
Query Executed:select id FROM `wa` where city='Soap Lake' && SIC_code='6021'DB:business_master_new
loadtime:1.9123899936676 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Bend' limit 1
loadtime:1.9124429225922 / seconds
Query Executed:select id FROM `wa` where city='South Bend' && SIC_code='6021'DB:business_master_new
loadtime:1.9151408672333 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Cle Elum' limit 1
loadtime:1.9152109622955 / seconds
Query Executed:select id FROM `wa` where city='South Cle Elum' && SIC_code='6021'DB:business_master_new
loadtime:1.9158589839935 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Colby' limit 1
loadtime:1.9159169197083 / seconds
Query Executed:select id FROM `wa` where city='South Colby' && SIC_code='6021'DB:business_master_new
loadtime:1.9166820049286 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Prairie' limit 1
loadtime:1.9167428016663 / seconds
Query Executed:select id FROM `wa` where city='South Prairie' && SIC_code='6021'DB:business_master_new
loadtime:1.9176750183105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southworth' limit 1
loadtime:1.9177379608154 / seconds
Query Executed:select id FROM `wa` where city='Southworth' && SIC_code='6021'DB:business_master_new
loadtime:1.9182949066162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spanaway' limit 1
loadtime:1.9183468818665 / seconds
Query Executed:select id FROM `wa` where city='Spanaway' && SIC_code='6021'DB:business_master_new
loadtime:1.9300899505615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spangle' limit 1
loadtime:1.9301648139954 / seconds
Query Executed:select id FROM `wa` where city='Spangle' && SIC_code='6021'DB:business_master_new
loadtime:1.9314517974854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spokane' limit 1
loadtime:1.931519985199 / seconds
Query Executed:select id FROM `wa` where city='Spokane' && SIC_code='6021'DB:business_master_new
loadtime:1.9454410076141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spokane Valley' limit 1
loadtime:1.9456448554993 / seconds
Query Executed:select id FROM `wa` where city='Spokane Valley' && SIC_code='6021'DB:business_master_new
loadtime:1.9463348388672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sprague' limit 1
loadtime:1.9463980197906 / seconds
Query Executed:select id FROM `wa` where city='Sprague' && SIC_code='6021'DB:business_master_new
loadtime:1.9474239349365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springdale' limit 1
loadtime:1.9474918842316 / seconds
Query Executed:select id FROM `wa` where city='Springdale' && SIC_code='6021'DB:business_master_new
loadtime:1.9485099315643 / seconds
Query loaded from cache:select * from geodata_geocity where city='St John' limit 1
loadtime:1.9485628604889 / seconds
Query Executed:select id FROM `wa` where city='St John' && SIC_code='6021'DB:business_master_new
loadtime:1.9490599632263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanwood' limit 1
loadtime:1.9491147994995 / seconds
Query Executed:select id FROM `wa` where city='Stanwood' && SIC_code='6021'DB:business_master_new
loadtime:1.9606139659882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Starbuck' limit 1
loadtime:1.9606900215149 / seconds
Query Executed:select id FROM `wa` where city='Starbuck' && SIC_code='6021'DB:business_master_new
loadtime:1.9613130092621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Startup' limit 1
loadtime:1.9613678455353 / seconds
Query Executed:select id FROM `wa` where city='Startup' && SIC_code='6021'DB:business_master_new
loadtime:1.9619698524475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stehekin' limit 1
loadtime:1.9620230197906 / seconds
Query Executed:select id FROM `wa` where city='Stehekin' && SIC_code='6021'DB:business_master_new
loadtime:1.9624898433685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steilacoom' limit 1
loadtime:1.9625408649445 / seconds
Query Executed:select id FROM `wa` where city='Steilacoom' && SIC_code='6021'DB:business_master_new
loadtime:1.9647929668427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steptoe' limit 1
loadtime:1.9648609161377 / seconds
Query Executed:select id FROM `wa` where city='Steptoe' && SIC_code='6021'DB:business_master_new
loadtime:1.9653828144073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevenson' limit 1
loadtime:1.9654378890991 / seconds
Query Executed:select id FROM `wa` where city='Stevenson' && SIC_code='6021'DB:business_master_new
loadtime:1.9695658683777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:1.9696350097656 / seconds
Query Executed:select id FROM `wa` where city='Stratford' && SIC_code='6021'DB:business_master_new
loadtime:1.9700899124146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sultan' limit 1
loadtime:1.9701449871063 / seconds
Query Executed:select id FROM `wa` where city='Sultan' && SIC_code='6021'DB:business_master_new
loadtime:1.9744849205017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumas' limit 1
loadtime:1.9745519161224 / seconds
Query Executed:select id FROM `wa` where city='Sumas' && SIC_code='6021'DB:business_master_new
loadtime:1.976334810257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumner' limit 1
loadtime:1.9763879776001 / seconds
Query Executed:select id FROM `wa` where city='Sumner' && SIC_code='6021'DB:business_master_new
loadtime:1.9866058826447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunnyside' limit 1
loadtime:1.98668384552 / seconds
Query Executed:select id FROM `wa` where city='Sunnyside' && SIC_code='6021'DB:business_master_new
loadtime:1.9985690116882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suquamish' limit 1
loadtime:1.9986448287964 / seconds
Query Executed:select id FROM `wa` where city='Suquamish' && SIC_code='6021'DB:business_master_new
loadtime:2.0003998279572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tacoma' limit 1
loadtime:2.0004658699036 / seconds
Query Executed:select id FROM `wa` where city='Tacoma' && SIC_code='6021'DB:business_master_new
loadtime:2.0146708488464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taholah' limit 1
loadtime:2.0148379802704 / seconds
Query Executed:select id FROM `wa` where city='Taholah' && SIC_code='6021'DB:business_master_new
loadtime:2.0154218673706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tahuya' limit 1
loadtime:2.0155057907104 / seconds
Query Executed:select id FROM `wa` where city='Tahuya' && SIC_code='6021'DB:business_master_new
loadtime:2.0163509845734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tekoa' limit 1
loadtime:2.0164058208466 / seconds
Query Executed:select id FROM `wa` where city='Tekoa' && SIC_code='6021'DB:business_master_new
loadtime:2.0175249576569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tenino' limit 1
loadtime:2.0175778865814 / seconds
Query Executed:select id FROM `wa` where city='Tenino' && SIC_code='6021'DB:business_master_new
loadtime:2.020430803299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornton' limit 1
loadtime:2.0204999446869 / seconds
Query Executed:select id FROM `wa` where city='Thornton' && SIC_code='6021'DB:business_master_new
loadtime:2.0211269855499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thorp' limit 1
loadtime:2.0211808681488 / seconds
Query Executed:select id FROM `wa` where city='Thorp' && SIC_code='6021'DB:business_master_new
loadtime:2.0220558643341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tieton' limit 1
loadtime:2.0221099853516 / seconds
Query Executed:select id FROM `wa` where city='Tieton' && SIC_code='6021'DB:business_master_new
loadtime:2.0233399868011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tokeland' limit 1
loadtime:2.0233929157257 / seconds
Query Executed:select id FROM `wa` where city='Tokeland' && SIC_code='6021'DB:business_master_new
loadtime:2.0240528583527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toledo' limit 1
loadtime:2.0241060256958 / seconds
Query Executed:select id FROM `wa` where city='Toledo' && SIC_code='6021'DB:business_master_new
loadtime:2.0267980098724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tonasket' limit 1
loadtime:2.0268638134003 / seconds
Query Executed:select id FROM `wa` where city='Tonasket' && SIC_code='6021'DB:business_master_new
loadtime:2.0316288471222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toppenish' limit 1
loadtime:2.0317478179932 / seconds
Query Executed:select id FROM `wa` where city='Toppenish' && SIC_code='6021'DB:business_master_new
loadtime:2.0372478961945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Touchet' limit 1
loadtime:2.0373158454895 / seconds
Query Executed:select id FROM `wa` where city='Touchet' && SIC_code='6021'DB:business_master_new
loadtime:2.0385370254517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toutle' limit 1
loadtime:2.0385909080505 / seconds
Query Executed:select id FROM `wa` where city='Toutle' && SIC_code='6021'DB:business_master_new
loadtime:2.0394668579102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tracyton' limit 1
loadtime:2.0395200252533 / seconds
Query Executed:select id FROM `wa` where city='Tracyton' && SIC_code='6021'DB:business_master_new
loadtime:2.0402219295502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trout Lake' limit 1
loadtime:2.0402748584747 / seconds
Query Executed:select id FROM `wa` where city='Trout Lake' && SIC_code='6021'DB:business_master_new
loadtime:2.0411248207092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tukwila' limit 1
loadtime:2.0411779880524 / seconds
Query Executed:select id FROM `wa` where city='Tukwila' && SIC_code='6021'DB:business_master_new
loadtime:2.0418848991394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tulalip' limit 1
loadtime:2.0419538021088 / seconds
Query Executed:select id FROM `wa` where city='Tulalip' && SIC_code='6021'DB:business_master_new
loadtime:2.0424418449402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tumtum' limit 1
loadtime:2.0424938201904 / seconds
Query Executed:select id FROM `wa` where city='Tumtum' && SIC_code='6021'DB:business_master_new
loadtime:2.0429918766022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tumwater' limit 1
loadtime:2.0430448055267 / seconds
Query Executed:select id FROM `wa` where city='Tumwater' && SIC_code='6021'DB:business_master_new
loadtime:2.0519618988037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twisp' limit 1
loadtime:2.052031993866 / seconds
Query Executed:select id FROM `wa` where city='Twisp' && SIC_code='6021'DB:business_master_new
loadtime:2.0553209781647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Underwood' limit 1
loadtime:2.0553858280182 / seconds
Query Executed:select id FROM `wa` where city='Underwood' && SIC_code='6021'DB:business_master_new
loadtime:2.0562708377838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:2.056324005127 / seconds
Query Executed:select id FROM `wa` where city='Union' && SIC_code='6021'DB:business_master_new
loadtime:2.0574688911438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Gap' limit 1
loadtime:2.0575230121613 / seconds
Query Executed:select id FROM `wa` where city='Union Gap' && SIC_code='6021'DB:business_master_new
loadtime:2.0581238269806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Uniontown' limit 1
loadtime:2.0581769943237 / seconds
Query Executed:select id FROM `wa` where city='Uniontown' && SIC_code='6021'DB:business_master_new
loadtime:2.0592138767242 / seconds
Query loaded from cache:select * from geodata_geocity where city='University Place' limit 1
loadtime:2.059280872345 / seconds
Query Executed:select id FROM `wa` where city='University Place' && SIC_code='6021'DB:business_master_new
loadtime:2.0672159194946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Usk' limit 1
loadtime:2.0672898292542 / seconds
Query Executed:select id FROM `wa` where city='Usk' && SIC_code='6021'DB:business_master_new
loadtime:2.0682339668274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vader' limit 1
loadtime:2.0682878494263 / seconds
Query Executed:select id FROM `wa` where city='Vader' && SIC_code='6021'DB:business_master_new
loadtime:2.0691649913788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley' limit 1
loadtime:2.0692188739777 / seconds
Query Executed:select id FROM `wa` where city='Valley' && SIC_code='6021'DB:business_master_new
loadtime:2.0706758499146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valleyford' limit 1
loadtime:2.070741891861 / seconds
Query Executed:select id FROM `wa` where city='Valleyford' && SIC_code='6021'DB:business_master_new
loadtime:2.0719339847565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vancouver' limit 1
loadtime:2.0719878673553 / seconds
Query Executed:select id FROM `wa` where city='Vancouver' && SIC_code='6021'DB:business_master_new
loadtime:2.0862159729004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vantage' limit 1
loadtime:2.0863838195801 / seconds
Query Executed:select id FROM `wa` where city='Vantage' && SIC_code='6021'DB:business_master_new
loadtime:2.0870118141174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vashon' limit 1
loadtime:2.087073802948 / seconds
Query Executed:select id FROM `wa` where city='Vashon' && SIC_code='6021'DB:business_master_new
loadtime:2.0958390235901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vaughn' limit 1
loadtime:2.095911026001 / seconds
Query Executed:select id FROM `wa` where city='Vaughn' && SIC_code='6021'DB:business_master_new
loadtime:2.0970258712769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Veradale' limit 1
loadtime:2.0970799922943 / seconds
Query Executed:select id FROM `wa` where city='Veradale' && SIC_code='6021'DB:business_master_new
loadtime:2.1051018238068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wahkiacus' limit 1
loadtime:2.1051728725433 / seconds
Query Executed:select id FROM `wa` where city='Wahkiacus' && SIC_code='6021'DB:business_master_new
loadtime:2.1056118011475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waitsburg' limit 1
loadtime:2.1056649684906 / seconds
Query Executed:select id FROM `wa` where city='Waitsburg' && SIC_code='6021'DB:business_master_new
loadtime:2.1072208881378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waldron' limit 1
loadtime:2.1072878837585 / seconds
Query Executed:select id FROM `wa` where city='Waldron' && SIC_code='6021'DB:business_master_new
loadtime:2.1077349185944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walla Walla' limit 1
loadtime:2.1077888011932 / seconds
Query Executed:select id FROM `wa` where city='Walla Walla' && SIC_code='6021'DB:business_master_new
loadtime:2.1215319633484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallula' limit 1
loadtime:2.1216149330139 / seconds
Query Executed:select id FROM `wa` where city='Wallula' && SIC_code='6021'DB:business_master_new
loadtime:2.1221749782562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wapato' limit 1
loadtime:2.1222298145294 / seconds
Query Executed:select id FROM `wa` where city='Wapato' && SIC_code='6021'DB:business_master_new
loadtime:2.1275839805603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warden' limit 1
loadtime:2.1276528835297 / seconds
Query Executed:select id FROM `wa` where city='Warden' && SIC_code='6021'DB:business_master_new
loadtime:2.1300249099731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washougal' limit 1
loadtime:2.1300919055939 / seconds
Query Executed:select id FROM `wa` where city='Washougal' && SIC_code='6021'DB:business_master_new
loadtime:2.13827085495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washtucna' limit 1
loadtime:2.1383459568024 / seconds
Query Executed:select id FROM `wa` where city='Washtucna' && SIC_code='6021'DB:business_master_new
loadtime:2.1391789913177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville' limit 1
loadtime:2.1392459869385 / seconds
Query Executed:select id FROM `wa` where city='Waterville' && SIC_code='6021'DB:business_master_new
loadtime:2.1410338878632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wauconda' limit 1
loadtime:2.1410989761353 / seconds
Query Executed:select id FROM `wa` where city='Wauconda' && SIC_code='6021'DB:business_master_new
loadtime:2.1417109966278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wauna' limit 1
loadtime:2.1417729854584 / seconds
Query Executed:select id FROM `wa` where city='Wauna' && SIC_code='6021'DB:business_master_new
loadtime:2.1426918506622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverly' limit 1
loadtime:2.1427538394928 / seconds
Query Executed:select id FROM `wa` where city='Waverly' && SIC_code='6021'DB:business_master_new
loadtime:2.1432549953461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellpinit' limit 1
loadtime:2.1433079242706 / seconds
Query Executed:select id FROM `wa` where city='Wellpinit' && SIC_code='6021'DB:business_master_new
loadtime:2.1441719532013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wenatchee' limit 1
loadtime:2.1442248821259 / seconds
Query Executed:select id FROM `wa` where city='Wenatchee' && SIC_code='6021'DB:business_master_new
loadtime:2.1584348678589 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Richland' limit 1
loadtime:2.1585328578949 / seconds
Query Executed:select id FROM `wa` where city='West Richland' && SIC_code='6021'DB:business_master_new
loadtime:2.1622128486633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:2.1622748374939 / seconds
Query Executed:select id FROM `wa` where city='Westport' && SIC_code='6021'DB:business_master_new
loadtime:2.165314912796 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Salmon' limit 1
loadtime:2.1653828620911 / seconds
Query Executed:select id FROM `wa` where city='White Salmon' && SIC_code='6021'DB:business_master_new
loadtime:2.1684927940369 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Swan' limit 1
loadtime:2.1685469150543 / seconds
Query Executed:select id FROM `wa` where city='White Swan' && SIC_code='6021'DB:business_master_new
loadtime:2.1695518493652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilbur' limit 1
loadtime:2.1696038246155 / seconds
Query Executed:select id FROM `wa` where city='Wilbur' && SIC_code='6021'DB:business_master_new
loadtime:2.171541929245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilkeson' limit 1
loadtime:2.1716108322144 / seconds
Query Executed:select id FROM `wa` where city='Wilkeson' && SIC_code='6021'DB:business_master_new
loadtime:2.1723458766937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilson Creek' limit 1
loadtime:2.1724019050598 / seconds
Query Executed:select id FROM `wa` where city='Wilson Creek' && SIC_code='6021'DB:business_master_new
loadtime:2.1730208396912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winlock' limit 1
loadtime:2.1730728149414 / seconds
Query Executed:select id FROM `wa` where city='Winlock' && SIC_code='6021'DB:business_master_new
loadtime:2.1764719486237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winthrop' limit 1
loadtime:2.1765389442444 / seconds
Query Executed:select id FROM `wa` where city='Winthrop' && SIC_code='6021'DB:business_master_new
loadtime:2.1805598735809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wishram' limit 1
loadtime:2.1806268692017 / seconds
Query Executed:select id FROM `wa` where city='Wishram' && SIC_code='6021'DB:business_master_new
loadtime:2.1812169551849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodinville' limit 1
loadtime:2.1812698841095 / seconds
Query Executed:select id FROM `wa` where city='Woodinville' && SIC_code='6021'DB:business_master_new
loadtime:2.2056260108948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland' limit 1
loadtime:2.2057068347931 / seconds
Query Executed:select id FROM `wa` where city='Woodland' && SIC_code='6021'DB:business_master_new
loadtime:2.2140758037567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodway' limit 1
loadtime:2.2141499519348 / seconds
Query Executed:select id FROM `wa` where city='Woodway' && SIC_code='6021'DB:business_master_new
loadtime:2.214653968811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yacolt' limit 1
loadtime:2.2147109508514 / seconds
Query Executed:select id FROM `wa` where city='Yacolt' && SIC_code='6021'DB:business_master_new
loadtime:2.217090845108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yakima' limit 1
loadtime:2.2171578407288 / seconds
Query Executed:select id FROM `wa` where city='Yakima' && SIC_code='6021'DB:business_master_new
loadtime:2.2315528392792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yarrow Point' limit 1
loadtime:2.2316718101501 / seconds
Query Executed:select id FROM `wa` where city='Yarrow Point' && SIC_code='6021'DB:business_master_new
loadtime:2.2321438789368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yelm' limit 1
loadtime:2.2322018146515 / seconds
Query Executed:select id FROM `wa` where city='Yelm' && SIC_code='6021'DB:business_master_new
loadtime:2.2406039237976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zillah' limit 1
loadtime:2.2406709194183 / seconds
Query Executed:select id FROM `wa` where city='Zillah' && SIC_code='6021'DB:business_master_new
loadtime:2.2443478107452 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:2.2445058822632 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:2.2449579238892 / seconds
Operation template executed (chunk cache operation)
loadtime:2.2451219558716 / seconds
template override:Default
loadtime:2.2451620101929 / 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:2.2464518547058 / seconds
Template Constructed, Array Rows:49
loadtime:2.2469868659973 / seconds
TOTAL EXECUTION TIME: 2.24654
loadtime:2.2496500015259 / 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] => national-commercial-banks [stateURLid] => washington )


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