Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.8930130004883E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00051307678222656 / seconds
host not found setting manual db connection
loadtime:0.0009000301361084 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0011529922485352 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.001352071762085 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0014069080352783 / seconds
zipcode:
loadtime:0.0014379024505615 / seconds
Query Executed:select * from search_referrer where page_hash='aa920a72fead15fa08bc5ccd32c928f8' limit 10 DB:ezrox_toadli
loadtime:0.0016579627990723 / seconds
Operation header executed (non global)
loadtime:0.0016770362854004 / seconds
Operation leaderboard executed (non global)
loadtime:0.0017180442810059 / seconds
Operation square executed (non global)
loadtime:0.0017321109771729 / seconds
Operation square_bottom executed (non global)
loadtime:0.0017459392547607 / seconds
Operation smallsquare executed (non global)
loadtime:0.0017580986022949 / seconds
Operation headeradright executed (non global)
loadtime:0.0017690658569336 / seconds
Operation google_analytics executed (non global)
loadtime:0.0017809867858887 / seconds
Operation topstories executed (non global)
loadtime:0.0017919540405273 / seconds
Operation businessnearyou executed (non global)
loadtime:0.001802921295166 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0018138885498047 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0021059513092041 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0022790431976318 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0023179054260254 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0023849010467529 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0024459362030029 / seconds
Template key: archive_menu pushed
loadtime:0.0024518966674805 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0024590492248535 / seconds
Template key: get_gravatar pushed
loadtime:0.0024619102478027 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0024659633636475 / seconds
*10)-10)+1 | start:0
loadtime:0.0024900436401367 / seconds
DB connected to localhost business_master_new
loadtime:0.0027120113372803 / seconds
Query Executed:select * from categories where cat_URLid='gasoline-service-station'DB:business_master_new
loadtime:0.0032470226287842 / seconds
Query stored in cache : _QUERY_www.toadli.comae9eaa17c7f2f271be87cf6879e91433
loadtime:0.0032830238342285 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='south-dakota'
loadtime:0.0033190250396729 / seconds
Query Executed:select * from `sd_catmap` where sic='5541' order by city ascDB:business_master_new
loadtime:0.021415948867798 / seconds
Query stored in cache : _QUERY_www.toadli.com288216deb1b3b8ea049400fbd9fe0f1f
loadtime:0.022391080856323 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='south-dakota'
loadtime:0.022447109222412 / seconds
Query Executed:select sum(totalcount) as totalsum from `sd_catmap` where sic='5541'DB:business_master_new
loadtime:0.024899005889893 / seconds
Query stored in cache : _QUERY_www.toadli.com7170c035c13e766ccda398828cae9d6e
loadtime:0.024924993515015 / seconds
410 / 11
loadtime:0.024961948394775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aberdeen' limit 1
loadtime:0.025010108947754 / seconds
Query Executed:select id FROM `sd` where city='Aberdeen' && SIC_code='5541'DB:business_master_new
loadtime:0.082603931427002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Academy' limit 1
loadtime:0.082742929458618 / seconds
Query Executed:select id FROM `sd` where city='Academy' && SIC_code='5541'DB:business_master_new
loadtime:0.083111047744751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agar' limit 1
loadtime:0.083149909973145 / seconds
Query Executed:select id FROM `sd` where city='Agar' && SIC_code='5541'DB:business_master_new
loadtime:0.083724975585938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Akaska' limit 1
loadtime:0.083784103393555 / seconds
Query Executed:select id FROM `sd` where city='Akaska' && SIC_code='5541'DB:business_master_new
loadtime:0.084146022796631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alcester' limit 1
loadtime:0.084173917770386 / seconds
Query Executed:select id FROM `sd` where city='Alcester' && SIC_code='5541'DB:business_master_new
loadtime:0.084733009338379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexandria' limit 1
loadtime:0.084791898727417 / seconds
Query Executed:select id FROM `sd` where city='Alexandria' && SIC_code='5541'DB:business_master_new
loadtime:0.085349082946777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allen' limit 1
loadtime:0.085406064987183 / seconds
Query Executed:select id FROM `sd` where city='Allen' && SIC_code='5541'DB:business_master_new
loadtime:0.085831880569458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpena' limit 1
loadtime:0.085880041122437 / seconds
Query Executed:select id FROM `sd` where city='Alpena' && SIC_code='5541'DB:business_master_new
loadtime:0.086394071578979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altamont' limit 1
loadtime:0.086456060409546 / seconds
Query Executed:select id FROM `sd` where city='Altamont' && SIC_code='5541'DB:business_master_new
loadtime:0.086704015731812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.086741924285889 / seconds
Query Executed:select id FROM `sd` where city='Amherst' && SIC_code='5541'DB:business_master_new
loadtime:0.087143898010254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.087191104888916 / seconds
Query Executed:select id FROM `sd` where city='Andover' && SIC_code='5541'DB:business_master_new
loadtime:0.087646007537842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ardmore' limit 1
loadtime:0.087687015533447 / seconds
Query Executed:select id FROM `sd` where city='Ardmore' && SIC_code='5541'DB:business_master_new
loadtime:0.087934970855713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.087970018386841 / seconds
Query Executed:select id FROM `sd` where city='Arlington' && SIC_code='5541'DB:business_master_new
loadtime:0.088521003723145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Armour' limit 1
loadtime:0.088572025299072 / seconds
Query Executed:select id FROM `sd` where city='Armour' && SIC_code='5541'DB:business_master_new
loadtime:0.089130878448486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Artesian' limit 1
loadtime:0.089179039001465 / seconds
Query Executed:select id FROM `sd` where city='Artesian' && SIC_code='5541'DB:business_master_new
loadtime:0.089711904525757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashton' limit 1
loadtime:0.089746952056885 / seconds
Query Executed:select id FROM `sd` where city='Ashton' && SIC_code='5541'DB:business_master_new
loadtime:0.090209007263184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Astoria' limit 1
loadtime:0.090262889862061 / seconds
Query Executed:select id FROM `sd` where city='Astoria' && SIC_code='5541'DB:business_master_new
loadtime:0.090753078460693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.090804100036621 / seconds
Query Executed:select id FROM `sd` where city='Aurora' && SIC_code='5541'DB:business_master_new
loadtime:0.091301918029785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.091339111328125 / seconds
Query Executed:select id FROM `sd` where city='Avon' && SIC_code='5541'DB:business_master_new
loadtime:0.091891050338745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Badger' limit 1
loadtime:0.091953039169312 / seconds
Query Executed:select id FROM `sd` where city='Badger' && SIC_code='5541'DB:business_master_new
loadtime:0.092338085174561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baltic' limit 1
loadtime:0.092375993728638 / seconds
Query Executed:select id FROM `sd` where city='Baltic' && SIC_code='5541'DB:business_master_new
loadtime:0.092922925949097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bancroft' limit 1
loadtime:0.092981100082397 / seconds
Query Executed:select id FROM `sd` where city='Bancroft' && SIC_code='5541'DB:business_master_new
loadtime:0.093245029449463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnard' limit 1
loadtime:0.093285083770752 / seconds
Query Executed:select id FROM `sd` where city='Barnard' && SIC_code='5541'DB:business_master_new
loadtime:0.093595027923584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Batesland' limit 1
loadtime:0.093637943267822 / seconds
Query Executed:select id FROM `sd` where city='Batesland' && SIC_code='5541'DB:business_master_new
loadtime:0.09406304359436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.094115018844604 / seconds
Query Executed:select id FROM `sd` where city='Bath' && SIC_code='5541'DB:business_master_new
loadtime:0.094589948654175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belle Fourche' limit 1
loadtime:0.094631910324097 / seconds
Query Executed:select id FROM `sd` where city='Belle Fourche' && SIC_code='5541'DB:business_master_new
loadtime:0.095369100570679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvidere' limit 1
loadtime:0.095437049865723 / seconds
Query Executed:select id FROM `sd` where city='Belvidere' && SIC_code='5541'DB:business_master_new
loadtime:0.096204996109009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beresford' limit 1
loadtime:0.09633994102478 / seconds
Query Executed:select id FROM `sd` where city='Beresford' && SIC_code='5541'DB:business_master_new
loadtime:0.097749948501587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Stone City' limit 1
loadtime:0.097914934158325 / seconds
Query Executed:select id FROM `sd` where city='Big Stone City' && SIC_code='5541'DB:business_master_new
loadtime:0.099210977554321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bison' limit 1
loadtime:0.09925389289856 / seconds
Query Executed:select id FROM `sd` where city='Bison' && SIC_code='5541'DB:business_master_new
loadtime:0.099809885025024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Hawk' limit 1
loadtime:0.099869012832642 / seconds
Query Executed:select id FROM `sd` where city='Black Hawk' && SIC_code='5541'DB:business_master_new
loadtime:0.1004490852356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blunt' limit 1
loadtime:0.10049700737 / seconds
Query Executed:select id FROM `sd` where city='Blunt' && SIC_code='5541'DB:business_master_new
loadtime:0.10099411010742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonesteel' limit 1
loadtime:0.10103988647461 / seconds
Query Executed:select id FROM `sd` where city='Bonesteel' && SIC_code='5541'DB:business_master_new
loadtime:0.10154294967651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowdle' limit 1
loadtime:0.10157608985901 / seconds
Query Executed:select id FROM `sd` where city='Bowdle' && SIC_code='5541'DB:business_master_new
loadtime:0.1020929813385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Box Elder' limit 1
loadtime:0.10214591026306 / seconds
Query Executed:select id FROM `sd` where city='Box Elder' && SIC_code='5541'DB:business_master_new
loadtime:0.10267901420593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradley' limit 1
loadtime:0.10271811485291 / seconds
Query Executed:select id FROM `sd` where city='Bradley' && SIC_code='5541'DB:business_master_new
loadtime:0.10320806503296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.10324192047119 / seconds
Query Executed:select id FROM `sd` where city='Brandon' && SIC_code='5541'DB:business_master_new
loadtime:0.10395407676697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandt' limit 1
loadtime:0.10400295257568 / seconds
Query Executed:select id FROM `sd` where city='Brandt' && SIC_code='5541'DB:business_master_new
loadtime:0.10446405410767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brentford' limit 1
loadtime:0.10450291633606 / seconds
Query Executed:select id FROM `sd` where city='Brentford' && SIC_code='5541'DB:business_master_new
loadtime:0.10488891601562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.10493803024292 / seconds
Query Executed:select id FROM `sd` where city='Bridgewater' && SIC_code='5541'DB:business_master_new
loadtime:0.10545897483826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.10549688339233 / seconds
Query Executed:select id FROM `sd` where city='Bristol' && SIC_code='5541'DB:business_master_new
loadtime:0.10602188110352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Britton' limit 1
loadtime:0.10607504844666 / seconds
Query Executed:select id FROM `sd` where city='Britton' && SIC_code='5541'DB:business_master_new
loadtime:0.10673809051514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookings' limit 1
loadtime:0.10680103302002 / seconds
Query Executed:select id FROM `sd` where city='Brookings' && SIC_code='5541'DB:business_master_new
loadtime:0.10790205001831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruce' limit 1
loadtime:0.10796093940735 / seconds
Query Executed:select id FROM `sd` where city='Bruce' && SIC_code='5541'DB:business_master_new
loadtime:0.10853099822998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryant' limit 1
loadtime:0.10857605934143 / seconds
Query Executed:select id FROM `sd` where city='Bryant' && SIC_code='5541'DB:business_master_new
loadtime:0.10909390449524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo' limit 1
loadtime:0.10915303230286 / seconds
Query Executed:select id FROM `sd` where city='Buffalo' && SIC_code='5541'DB:business_master_new
loadtime:0.10972499847412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Gap' limit 1
loadtime:0.10978388786316 / seconds
Query Executed:select id FROM `sd` where city='Buffalo Gap' && SIC_code='5541'DB:business_master_new
loadtime:0.11028003692627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Ridge' limit 1
loadtime:0.11032891273499 / seconds
Query Executed:select id FROM `sd` where city='Buffalo Ridge' && SIC_code='5541'DB:business_master_new
loadtime:0.11058807373047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bullhead' limit 1
loadtime:0.11062788963318 / seconds
Query Executed:select id FROM `sd` where city='Bullhead' && SIC_code='5541'DB:business_master_new
loadtime:0.11100602149963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burbank' limit 1
loadtime:0.11106491088867 / seconds
Query Executed:select id FROM `sd` where city='Burbank' && SIC_code='5541'DB:business_master_new
loadtime:0.1115300655365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burke' limit 1
loadtime:0.11155796051025 / seconds
Query Executed:select id FROM `sd` where city='Burke' && SIC_code='5541'DB:business_master_new
loadtime:0.11212301254272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bushnell' limit 1
loadtime:0.11218595504761 / seconds
Query Executed:select id FROM `sd` where city='Bushnell' && SIC_code='5541'DB:business_master_new
loadtime:0.11244487762451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butler' limit 1
loadtime:0.11248803138733 / seconds
Query Executed:select id FROM `sd` where city='Butler' && SIC_code='5541'DB:business_master_new
loadtime:0.11273407936096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Crook' limit 1
loadtime:0.11276006698608 / seconds
Query Executed:select id FROM `sd` where city='Camp Crook' && SIC_code='5541'DB:business_master_new
loadtime:0.11327910423279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canistota' limit 1
loadtime:0.11332607269287 / seconds
Query Executed:select id FROM `sd` where city='Canistota' && SIC_code='5541'DB:business_master_new
loadtime:0.11384510993958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canova' limit 1
loadtime:0.11389088630676 / seconds
Query Executed:select id FROM `sd` where city='Canova' && SIC_code='5541'DB:business_master_new
loadtime:0.11436295509338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.1144061088562 / seconds
Query Executed:select id FROM `sd` where city='Canton' && SIC_code='5541'DB:business_master_new
loadtime:0.11509490013123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caputa' limit 1
loadtime:0.11515688896179 / seconds
Query Executed:select id FROM `sd` where city='Caputa' && SIC_code='5541'DB:business_master_new
loadtime:0.1155469417572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carpenter' limit 1
loadtime:0.11557698249817 / seconds
Query Executed:select id FROM `sd` where city='Carpenter' && SIC_code='5541'DB:business_master_new
loadtime:0.1160581111908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carter' limit 1
loadtime:0.11609601974487 / seconds
Query Executed:select id FROM `sd` where city='Carter' && SIC_code='5541'DB:business_master_new
loadtime:0.11634302139282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carthage' limit 1
loadtime:0.11637401580811 / seconds
Query Executed:select id FROM `sd` where city='Carthage' && SIC_code='5541'DB:business_master_new
loadtime:0.1168520450592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castlewood' limit 1
loadtime:0.11690211296082 / seconds
Query Executed:select id FROM `sd` where city='Castlewood' && SIC_code='5541'DB:business_master_new
loadtime:0.11742997169495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cavour' limit 1
loadtime:0.11748290061951 / seconds
Query Executed:select id FROM `sd` where city='Cavour' && SIC_code='5541'DB:business_master_new
loadtime:0.11800098419189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:0.11805391311646 / seconds
Query Executed:select id FROM `sd` where city='Centerville' && SIC_code='5541'DB:business_master_new
loadtime:0.11855697631836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central City' limit 1
loadtime:0.11859703063965 / seconds
Query Executed:select id FROM `sd` where city='Central City' && SIC_code='5541'DB:business_master_new
loadtime:0.11890602111816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chamberlain' limit 1
loadtime:0.11895203590393 / seconds
Query Executed:select id FROM `sd` where city='Chamberlain' && SIC_code='5541'DB:business_master_new
loadtime:0.11964297294617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chancellor' limit 1
loadtime:0.11969399452209 / seconds
Query Executed:select id FROM `sd` where city='Chancellor' && SIC_code='5541'DB:business_master_new
loadtime:0.12019395828247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.12023496627808 / seconds
Query Executed:select id FROM `sd` where city='Chelsea' && SIC_code='5541'DB:business_master_new
loadtime:0.12050294876099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Creek' limit 1
loadtime:0.12052989006042 / seconds
Query Executed:select id FROM `sd` where city='Cherry Creek' && SIC_code='5541'DB:business_master_new
loadtime:0.12086296081543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.12091493606567 / seconds
Query Executed:select id FROM `sd` where city='Chester' && SIC_code='5541'DB:business_master_new
loadtime:0.12140703201294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claire City' limit 1
loadtime:0.12146997451782 / seconds
Query Executed:select id FROM `sd` where city='Claire City' && SIC_code='5541'DB:business_master_new
loadtime:0.12196588516235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:0.12202501296997 / seconds
Query Executed:select id FROM `sd` where city='Claremont' && SIC_code='5541'DB:business_master_new
loadtime:0.12250399589539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clark' limit 1
loadtime:0.12254405021667 / seconds
Query Executed:select id FROM `sd` where city='Clark' && SIC_code='5541'DB:business_master_new
loadtime:0.12316989898682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clear Lake' limit 1
loadtime:0.12322688102722 / seconds
Query Executed:select id FROM `sd` where city='Clear Lake' && SIC_code='5541'DB:business_master_new
loadtime:0.12382507324219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clearfield' limit 1
loadtime:0.1238739490509 / seconds
Query Executed:select id FROM `sd` where city='Clearfield' && SIC_code='5541'DB:business_master_new
loadtime:0.12414598464966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colman' limit 1
loadtime:0.12417197227478 / seconds
Query Executed:select id FROM `sd` where city='Colman' && SIC_code='5541'DB:business_master_new
loadtime:0.12474393844604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colome' limit 1
loadtime:0.12480688095093 / seconds
Query Executed:select id FROM `sd` where city='Colome' && SIC_code='5541'DB:business_master_new
loadtime:0.12543797492981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colton' limit 1
loadtime:0.12549710273743 / seconds
Query Executed:select id FROM `sd` where city='Colton' && SIC_code='5541'DB:business_master_new
loadtime:0.12603807449341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.1260941028595 / seconds
Query Executed:select id FROM `sd` where city='Columbia' && SIC_code='5541'DB:business_master_new
loadtime:0.12656092643738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conde' limit 1
loadtime:0.12659406661987 / seconds
Query Executed:select id FROM `sd` where city='Conde' && SIC_code='5541'DB:business_master_new
loadtime:0.12711691856384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corona' limit 1
loadtime:0.12717890739441 / seconds
Query Executed:select id FROM `sd` where city='Corona' && SIC_code='5541'DB:business_master_new
loadtime:0.12762689590454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corsica' limit 1
loadtime:0.12766790390015 / seconds
Query Executed:select id FROM `sd` where city='Corsica' && SIC_code='5541'DB:business_master_new
loadtime:0.12821388244629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creighton' limit 1
loadtime:0.12826800346375 / seconds
Query Executed:select id FROM `sd` where city='Creighton' && SIC_code='5541'DB:business_master_new
loadtime:0.12853503227234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cresbard' limit 1
loadtime:0.12856793403625 / seconds
Query Executed:select id FROM `sd` where city='Cresbard' && SIC_code='5541'DB:business_master_new
loadtime:0.12906002998352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crocker' limit 1
loadtime:0.12911796569824 / seconds
Query Executed:select id FROM `sd` where city='Crocker' && SIC_code='5541'DB:business_master_new
loadtime:0.12937307357788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crooks' limit 1
loadtime:0.12940096855164 / seconds
Query Executed:select id FROM `sd` where city='Crooks' && SIC_code='5541'DB:business_master_new
loadtime:0.12992405891418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Custer' limit 1
loadtime:0.12997889518738 / seconds
Query Executed:select id FROM `sd` where city='Custer' && SIC_code='5541'DB:business_master_new
loadtime:0.1306459903717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dakota Dunes' limit 1
loadtime:0.13069605827332 / seconds
Query Executed:select id FROM `sd` where city='Dakota Dunes' && SIC_code='5541'DB:business_master_new
loadtime:0.13100600242615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas' limit 1
loadtime:0.1310670375824 / seconds
Query Executed:select id FROM `sd` where city='Dallas' && SIC_code='5541'DB:business_master_new
loadtime:0.13151788711548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dante' limit 1
loadtime:0.13155102729797 / seconds
Query Executed:select id FROM `sd` where city='Dante' && SIC_code='5541'DB:business_master_new
loadtime:0.13199901580811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis' limit 1
loadtime:0.13205194473267 / seconds
Query Executed:select id FROM `sd` where city='Davis' && SIC_code='5541'DB:business_master_new
loadtime:0.1325089931488 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Smet' limit 1
loadtime:0.1325409412384 / seconds
Query Executed:select id FROM `sd` where city='De Smet' && SIC_code='5541'DB:business_master_new
loadtime:0.13310790061951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deadwood' limit 1
loadtime:0.13316702842712 / seconds
Query Executed:select id FROM `sd` where city='Deadwood' && SIC_code='5541'DB:business_master_new
loadtime:0.13379311561584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dell Rapids' limit 1
loadtime:0.13385605812073 / seconds
Query Executed:select id FROM `sd` where city='Dell Rapids' && SIC_code='5541'DB:business_master_new
loadtime:0.13449311256409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delmont' limit 1
loadtime:0.13454294204712 / seconds
Query Executed:select id FROM `sd` where city='Delmont' && SIC_code='5541'DB:business_master_new
loadtime:0.13505411148071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dimock' limit 1
loadtime:0.13510394096375 / seconds
Query Executed:select id FROM `sd` where city='Dimock' && SIC_code='5541'DB:business_master_new
loadtime:0.13555502891541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doland' limit 1
loadtime:0.135586977005 / seconds
Query Executed:select id FROM `sd` where city='Doland' && SIC_code='5541'DB:business_master_new
loadtime:0.13606190681458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolton' limit 1
loadtime:0.1361129283905 / seconds
Query Executed:select id FROM `sd` where city='Dolton' && SIC_code='5541'DB:business_master_new
loadtime:0.13650798797607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Draper' limit 1
loadtime:0.13654398918152 / seconds
Query Executed:select id FROM `sd` where city='Draper' && SIC_code='5541'DB:business_master_new
loadtime:0.13702797889709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dupree' limit 1
loadtime:0.13707995414734 / seconds
Query Executed:select id FROM `sd` where city='Dupree' && SIC_code='5541'DB:business_master_new
loadtime:0.13756489753723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Butte' limit 1
loadtime:0.13760590553284 / seconds
Query Executed:select id FROM `sd` where city='Eagle Butte' && SIC_code='5541'DB:business_master_new
loadtime:0.13823103904724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.13828706741333 / seconds
Query Executed:select id FROM `sd` where city='Eden' && SIC_code='5541'DB:business_master_new
loadtime:0.13878393173218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgemont' limit 1
loadtime:0.13883399963379 / seconds
Query Executed:select id FROM `sd` where city='Edgemont' && SIC_code='5541'DB:business_master_new
loadtime:0.13935208320618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Egan' limit 1
loadtime:0.13938808441162 / seconds
Query Executed:select id FROM `sd` where city='Egan' && SIC_code='5541'DB:business_master_new
loadtime:0.13986206054688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Point' limit 1
loadtime:0.13990902900696 / seconds
Query Executed:select id FROM `sd` where city='Elk Point' && SIC_code='5541'DB:business_master_new
loadtime:0.14052391052246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkton' limit 1
loadtime:0.14058089256287 / seconds
Query Executed:select id FROM `sd` where city='Elkton' && SIC_code='5541'DB:business_master_new
loadtime:0.14110207557678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth Afb' limit 1
loadtime:0.14115190505981 / seconds
Query Executed:select id FROM `sd` where city='Ellsworth Afb' && SIC_code='5541'DB:business_master_new
loadtime:0.14163398742676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elm Springs' limit 1
loadtime:0.14166688919067 / seconds
Query Executed:select id FROM `sd` where city='Elm Springs' && SIC_code='5541'DB:business_master_new
loadtime:0.14190888404846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emery' limit 1
loadtime:0.14195108413696 / seconds
Query Executed:select id FROM `sd` where city='Emery' && SIC_code='5541'DB:business_master_new
loadtime:0.14244699478149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enning' limit 1
loadtime:0.14248299598694 / seconds
Query Executed:select id FROM `sd` where city='Enning' && SIC_code='5541'DB:business_master_new
loadtime:0.14287900924683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erwin' limit 1
loadtime:0.14293003082275 / seconds
Query Executed:select id FROM `sd` where city='Erwin' && SIC_code='5541'DB:business_master_new
loadtime:0.14336895942688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estelline' limit 1
loadtime:0.14340496063232 / seconds
Query Executed:select id FROM `sd` where city='Estelline' && SIC_code='5541'DB:business_master_new
loadtime:0.14397406578064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ethan' limit 1
loadtime:0.14403510093689 / seconds
Query Executed:select id FROM `sd` where city='Ethan' && SIC_code='5541'DB:business_master_new
loadtime:0.1445300579071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eureka' limit 1
loadtime:0.14457201957703 / seconds
Query Executed:select id FROM `sd` where city='Eureka' && SIC_code='5541'DB:business_master_new
loadtime:0.14512991905212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairburn' limit 1
loadtime:0.14517998695374 / seconds
Query Executed:select id FROM `sd` where city='Fairburn' && SIC_code='5541'DB:business_master_new
loadtime:0.14550399780273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.14554810523987 / seconds
Query Executed:select id FROM `sd` where city='Fairfax' && SIC_code='5541'DB:business_master_new
loadtime:0.14600801467896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:0.14605498313904 / seconds
Query Executed:select id FROM `sd` where city='Fairview' && SIC_code='5541'DB:business_master_new
loadtime:0.14638996124268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faith' limit 1
loadtime:0.14644598960876 / seconds
Query Executed:select id FROM `sd` where city='Faith' && SIC_code='5541'DB:business_master_new
loadtime:0.14700794219971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faulkton' limit 1
loadtime:0.14708089828491 / seconds
Query Executed:select id FROM `sd` where city='Faulkton' && SIC_code='5541'DB:business_master_new
loadtime:0.14765501022339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fedora' limit 1
loadtime:0.14769101142883 / seconds
Query Executed:select id FROM `sd` where city='Fedora' && SIC_code='5541'DB:business_master_new
loadtime:0.14815807342529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferney' limit 1
loadtime:0.14821195602417 / seconds
Query Executed:select id FROM `sd` where city='Ferney' && SIC_code='5541'DB:business_master_new
loadtime:0.14855003356934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Firesteel' limit 1
loadtime:0.14858198165894 / seconds
Query Executed:select id FROM `sd` where city='Firesteel' && SIC_code='5541'DB:business_master_new
loadtime:0.14885306358337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flandreau' limit 1
loadtime:0.14889001846313 / seconds
Query Executed:select id FROM `sd` where city='Flandreau' && SIC_code='5541'DB:business_master_new
loadtime:0.14949488639832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.14954090118408 / seconds
Query Executed:select id FROM `sd` where city='Florence' && SIC_code='5541'DB:business_master_new
loadtime:0.15002608299255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forestburg' limit 1
loadtime:0.15007495880127 / seconds
Query Executed:select id FROM `sd` where city='Forestburg' && SIC_code='5541'DB:business_master_new
loadtime:0.1503438949585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Meade' limit 1
loadtime:0.15037608146667 / seconds
Query Executed:select id FROM `sd` where city='Fort Meade' && SIC_code='5541'DB:business_master_new
loadtime:0.15075707435608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Pierre' limit 1
loadtime:0.15079689025879 / seconds
Query Executed:select id FROM `sd` where city='Fort Pierre' && SIC_code='5541'DB:business_master_new
loadtime:0.15145492553711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Thompson' limit 1
loadtime:0.15149998664856 / seconds
Query Executed:select id FROM `sd` where city='Fort Thompson' && SIC_code='5541'DB:business_master_new
loadtime:0.1520140171051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frankfort' limit 1
loadtime:0.15206408500671 / seconds
Query Executed:select id FROM `sd` where city='Frankfort' && SIC_code='5541'DB:business_master_new
loadtime:0.15251493453979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frederick' limit 1
loadtime:0.15255403518677 / seconds
Query Executed:select id FROM `sd` where city='Frederick' && SIC_code='5541'DB:business_master_new
loadtime:0.15303993225098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeman' limit 1
loadtime:0.15308594703674 / seconds
Query Executed:select id FROM `sd` where city='Freeman' && SIC_code='5541'DB:business_master_new
loadtime:0.1536591053009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitdale' limit 1
loadtime:0.15369701385498 / seconds
Query Executed:select id FROM `sd` where city='Fruitdale' && SIC_code='5541'DB:business_master_new
loadtime:0.15392589569092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fulton' limit 1
loadtime:0.15395998954773 / seconds
Query Executed:select id FROM `sd` where city='Fulton' && SIC_code='5541'DB:business_master_new
loadtime:0.15440106391907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gann Valley' limit 1
loadtime:0.15443992614746 / seconds
Query Executed:select id FROM `sd` where city='Gann Valley' && SIC_code='5541'DB:business_master_new
loadtime:0.15491795539856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden City' limit 1
loadtime:0.15497589111328 / seconds
Query Executed:select id FROM `sd` where city='Garden City' && SIC_code='5541'DB:business_master_new
loadtime:0.15539407730103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garretson' limit 1
loadtime:0.1554479598999 / seconds
Query Executed:select id FROM `sd` where city='Garretson' && SIC_code='5541'DB:business_master_new
loadtime:0.15604209899902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gary' limit 1
loadtime:0.15610003471375 / seconds
Query Executed:select id FROM `sd` where city='Gary' && SIC_code='5541'DB:business_master_new
loadtime:0.15660905838013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gayville' limit 1
loadtime:0.1566379070282 / seconds
Query Executed:select id FROM `sd` where city='Gayville' && SIC_code='5541'DB:business_master_new
loadtime:0.15715909004211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Geddes' limit 1
loadtime:0.15721797943115 / seconds
Query Executed:select id FROM `sd` where city='Geddes' && SIC_code='5541'DB:business_master_new
loadtime:0.1577410697937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gettysburg' limit 1
loadtime:0.15778803825378 / seconds
Query Executed:select id FROM `sd` where city='Gettysburg' && SIC_code='5541'DB:business_master_new
loadtime:0.1583559513092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glad Valley' limit 1
loadtime:0.15840697288513 / seconds
Query Executed:select id FROM `sd` where city='Glad Valley' && SIC_code='5541'DB:business_master_new
loadtime:0.15867304801941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glencross' limit 1
loadtime:0.15871500968933 / seconds
Query Executed:select id FROM `sd` where city='Glencross' && SIC_code='5541'DB:business_master_new
loadtime:0.15902805328369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenham' limit 1
loadtime:0.15907406806946 / seconds
Query Executed:select id FROM `sd` where city='Glenham' && SIC_code='5541'DB:business_master_new
loadtime:0.15953588485718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodwin' limit 1
loadtime:0.15957808494568 / seconds
Query Executed:select id FROM `sd` where city='Goodwin' && SIC_code='5541'DB:business_master_new
loadtime:0.16006803512573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gregory' limit 1
loadtime:0.16011309623718 / seconds
Query Executed:select id FROM `sd` where city='Gregory' && SIC_code='5541'DB:business_master_new
loadtime:0.16071009635925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grenville' limit 1
loadtime:0.16076707839966 / seconds
Query Executed:select id FROM `sd` where city='Grenville' && SIC_code='5541'DB:business_master_new
loadtime:0.16124701499939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.16129398345947 / seconds
Query Executed:select id FROM `sd` where city='Groton' && SIC_code='5541'DB:business_master_new
loadtime:0.16193509101868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamill' limit 1
loadtime:0.1619930267334 / seconds
Query Executed:select id FROM `sd` where city='Hamill' && SIC_code='5541'DB:business_master_new
loadtime:0.16255402565002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisburg' limit 1
loadtime:0.16260695457458 / seconds
Query Executed:select id FROM `sd` where city='Harrisburg' && SIC_code='5541'DB:business_master_new
loadtime:0.16314601898193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrison' limit 1
loadtime:0.16319394111633 / seconds
Query Executed:select id FROM `sd` where city='Harrison' && SIC_code='5541'DB:business_master_new
loadtime:0.16364192962646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrold' limit 1
loadtime:0.16370797157288 / seconds
Query Executed:select id FROM `sd` where city='Harrold' && SIC_code='5541'DB:business_master_new
loadtime:0.1642370223999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.16430592536926 / seconds
Query Executed:select id FROM `sd` where city='Hartford' && SIC_code='5541'DB:business_master_new
loadtime:0.16494488716125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayes' limit 1
loadtime:0.16499090194702 / seconds
Query Executed:select id FROM `sd` where city='Hayes' && SIC_code='5541'DB:business_master_new
loadtime:0.16545104980469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayti' limit 1
loadtime:0.16550302505493 / seconds
Query Executed:select id FROM `sd` where city='Hayti' && SIC_code='5541'DB:business_master_new
loadtime:0.16603493690491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazel' limit 1
loadtime:0.16608500480652 / seconds
Query Executed:select id FROM `sd` where city='Hazel' && SIC_code='5541'DB:business_master_new
loadtime:0.16657304763794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hecla' limit 1
loadtime:0.16660499572754 / seconds
Query Executed:select id FROM `sd` where city='Hecla' && SIC_code='5541'DB:business_master_new
loadtime:0.16712594032288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henry' limit 1
loadtime:0.16718506813049 / seconds
Query Executed:select id FROM `sd` where city='Henry' && SIC_code='5541'DB:business_master_new
loadtime:0.16768193244934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hermosa' limit 1
loadtime:0.16773009300232 / seconds
Query Executed:select id FROM `sd` where city='Hermosa' && SIC_code='5541'DB:business_master_new
loadtime:0.16822099685669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herreid' limit 1
loadtime:0.16825389862061 / seconds
Query Executed:select id FROM `sd` where city='Herreid' && SIC_code='5541'DB:business_master_new
loadtime:0.16882705688477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herrick' limit 1
loadtime:0.1688768863678 / seconds
Query Executed:select id FROM `sd` where city='Herrick' && SIC_code='5541'DB:business_master_new
loadtime:0.1693229675293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hetland' limit 1
loadtime:0.16935706138611 / seconds
Query Executed:select id FROM `sd` where city='Hetland' && SIC_code='5541'DB:business_master_new
loadtime:0.16962790489197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highmore' limit 1
loadtime:0.16966795921326 / seconds
Query Executed:select id FROM `sd` where city='Highmore' && SIC_code='5541'DB:business_master_new
loadtime:0.17023706436157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hill City' limit 1
loadtime:0.17027807235718 / seconds
Query Executed:select id FROM `sd` where city='Hill City' && SIC_code='5541'DB:business_master_new
loadtime:0.17091608047485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hitchcock' limit 1
loadtime:0.17097592353821 / seconds
Query Executed:select id FROM `sd` where city='Hitchcock' && SIC_code='5541'DB:business_master_new
loadtime:0.171462059021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holabird' limit 1
loadtime:0.17150688171387 / seconds
Query Executed:select id FROM `sd` where city='Holabird' && SIC_code='5541'DB:business_master_new
loadtime:0.17191195487976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hosmer' limit 1
loadtime:0.17194795608521 / seconds
Query Executed:select id FROM `sd` where city='Hosmer' && SIC_code='5541'DB:business_master_new
loadtime:0.17243695259094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hot Springs' limit 1
loadtime:0.17247605323792 / seconds
Query Executed:select id FROM `sd` where city='Hot Springs' && SIC_code='5541'DB:business_master_new
loadtime:0.1732349395752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houghton' limit 1
loadtime:0.1732931137085 / seconds
Query Executed:select id FROM `sd` where city='Houghton' && SIC_code='5541'DB:business_master_new
loadtime:0.17381501197815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoven' limit 1
loadtime:0.17386794090271 / seconds
Query Executed:select id FROM `sd` where city='Hoven' && SIC_code='5541'DB:business_master_new
loadtime:0.17440891265869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howard' limit 1
loadtime:0.17447209358215 / seconds
Query Executed:select id FROM `sd` where city='Howard' && SIC_code='5541'DB:business_master_new
loadtime:0.17506003379822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howes' limit 1
loadtime:0.17510890960693 / seconds
Query Executed:select id FROM `sd` where city='Howes' && SIC_code='5541'DB:business_master_new
loadtime:0.1755108833313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:0.17554998397827 / seconds
Query Executed:select id FROM `sd` where city='Hudson' && SIC_code='5541'DB:business_master_new
loadtime:0.17606711387634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humboldt' limit 1
loadtime:0.17611908912659 / seconds
Query Executed:select id FROM `sd` where city='Humboldt' && SIC_code='5541'DB:business_master_new
loadtime:0.17661309242249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:0.17666411399841 / seconds
Query Executed:select id FROM `sd` where city='Hurley' && SIC_code='5541'DB:business_master_new
loadtime:0.17719197273254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huron' limit 1
loadtime:0.17724990844727 / seconds
Query Executed:select id FROM `sd` where city='Huron' && SIC_code='5541'DB:business_master_new
loadtime:0.17821002006531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ideal' limit 1
loadtime:0.17826890945435 / seconds
Query Executed:select id FROM `sd` where city='Ideal' && SIC_code='5541'DB:business_master_new
loadtime:0.1786150932312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Igloo' limit 1
loadtime:0.17864298820496 / seconds
Query Executed:select id FROM `sd` where city='Igloo' && SIC_code='5541'DB:business_master_new
loadtime:0.17888903617859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Interior' limit 1
loadtime:0.17892694473267 / seconds
Query Executed:select id FROM `sd` where city='Interior' && SIC_code='5541'DB:business_master_new
loadtime:0.17941308021545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ipswich' limit 1
loadtime:0.17946910858154 / seconds
Query Executed:select id FROM `sd` where city='Ipswich' && SIC_code='5541'DB:business_master_new
loadtime:0.18005704879761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irene' limit 1
loadtime:0.1801130771637 / seconds
Query Executed:select id FROM `sd` where city='Irene' && SIC_code='5541'DB:business_master_new
loadtime:0.18061900138855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iroquois' limit 1
loadtime:0.18066096305847 / seconds
Query Executed:select id FROM `sd` where city='Iroquois' && SIC_code='5541'DB:business_master_new
loadtime:0.18116497993469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isabel' limit 1
loadtime:0.1812150478363 / seconds
Query Executed:select id FROM `sd` where city='Isabel' && SIC_code='5541'DB:business_master_new
loadtime:0.18175601959229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Java' limit 1
loadtime:0.18180704116821 / seconds
Query Executed:select id FROM `sd` where city='Java' && SIC_code='5541'DB:business_master_new
loadtime:0.18231511116028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:0.18236994743347 / seconds
Query Executed:select id FROM `sd` where city='Jefferson' && SIC_code='5541'DB:business_master_new
loadtime:0.18295907974243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kadoka' limit 1
loadtime:0.18301796913147 / seconds
Query Executed:select id FROM `sd` where city='Kadoka' && SIC_code='5541'DB:business_master_new
loadtime:0.18361902236938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaylor' limit 1
loadtime:0.18365788459778 / seconds
Query Executed:select id FROM `sd` where city='Kaylor' && SIC_code='5541'DB:business_master_new
loadtime:0.18405294418335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keldron' limit 1
loadtime:0.18410491943359 / seconds
Query Executed:select id FROM `sd` where city='Keldron' && SIC_code='5541'DB:business_master_new
loadtime:0.18447589874268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kennebec' limit 1
loadtime:0.18450403213501 / seconds
Query Executed:select id FROM `sd` where city='Kennebec' && SIC_code='5541'DB:business_master_new
loadtime:0.1850368976593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keystone' limit 1
loadtime:0.18509387969971 / seconds
Query Executed:select id FROM `sd` where city='Keystone' && SIC_code='5541'DB:business_master_new
loadtime:0.18560791015625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kimball' limit 1
loadtime:0.18564796447754 / seconds
Query Executed:select id FROM `sd` where city='Kimball' && SIC_code='5541'DB:business_master_new
loadtime:0.18620991706848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kranzburg' limit 1
loadtime:0.1862690448761 / seconds
Query Executed:select id FROM `sd` where city='Kranzburg' && SIC_code='5541'DB:business_master_new
loadtime:0.18666100502014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kyle' limit 1
loadtime:0.18670201301575 / seconds
Query Executed:select id FROM `sd` where city='Kyle' && SIC_code='5541'DB:business_master_new
loadtime:0.18720102310181 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Plant' limit 1
loadtime:0.18725609779358 / seconds
Query Executed:select id FROM `sd` where city='La Plant' && SIC_code='5541'DB:business_master_new
loadtime:0.18757700920105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Labolt' limit 1
loadtime:0.18760991096497 / seconds
Query Executed:select id FROM `sd` where city='Labolt' && SIC_code='5541'DB:business_master_new
loadtime:0.18802905082703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Andes' limit 1
loadtime:0.18808102607727 / seconds
Query Executed:select id FROM `sd` where city='Lake Andes' && SIC_code='5541'DB:business_master_new
loadtime:0.18862891197205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake City' limit 1
loadtime:0.18867897987366 / seconds
Query Executed:select id FROM `sd` where city='Lake City' && SIC_code='5541'DB:business_master_new
loadtime:0.18910002708435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Norden' limit 1
loadtime:0.18914198875427 / seconds
Query Executed:select id FROM `sd` where city='Lake Norden' && SIC_code='5541'DB:business_master_new
loadtime:0.18965101242065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Preston' limit 1
loadtime:0.18969202041626 / seconds
Query Executed:select id FROM `sd` where city='Lake Preston' && SIC_code='5541'DB:business_master_new
loadtime:0.19021105766296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lane' limit 1
loadtime:0.1902539730072 / seconds
Query Executed:select id FROM `sd` where city='Lane' && SIC_code='5541'DB:business_master_new
loadtime:0.19055104255676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langford' limit 1
loadtime:0.19059205055237 / seconds
Query Executed:select id FROM `sd` where city='Langford' && SIC_code='5541'DB:business_master_new
loadtime:0.19106698036194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lantry' limit 1
loadtime:0.19110798835754 / seconds
Query Executed:select id FROM `sd` where city='Lantry' && SIC_code='5541'DB:business_master_new
loadtime:0.19143390655518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lead' limit 1
loadtime:0.19147396087646 / seconds
Query Executed:select id FROM `sd` where city='Lead' && SIC_code='5541'DB:business_master_new
loadtime:0.19207310676575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:0.19212889671326 / seconds
Query Executed:select id FROM `sd` where city='Lebanon' && SIC_code='5541'DB:business_master_new
loadtime:0.19261503219604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemmon' limit 1
loadtime:0.19265699386597 / seconds
Query Executed:select id FROM `sd` where city='Lemmon' && SIC_code='5541'DB:business_master_new
loadtime:0.19321608543396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lennox' limit 1
loadtime:0.1932520866394 / seconds
Query Executed:select id FROM `sd` where city='Lennox' && SIC_code='5541'DB:business_master_new
loadtime:0.19384908676147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leola' limit 1
loadtime:0.1939070224762 / seconds
Query Executed:select id FROM `sd` where city='Leola' && SIC_code='5541'DB:business_master_new
loadtime:0.19445395469666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lesterville' limit 1
loadtime:0.19449090957642 / seconds
Query Executed:select id FROM `sd` where city='Lesterville' && SIC_code='5541'DB:business_master_new
loadtime:0.19497609138489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Letcher' limit 1
loadtime:0.19502401351929 / seconds
Query Executed:select id FROM `sd` where city='Letcher' && SIC_code='5541'DB:business_master_new
loadtime:0.19554710388184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Eagle' limit 1
loadtime:0.19559407234192 / seconds
Query Executed:select id FROM `sd` where city='Little Eagle' && SIC_code='5541'DB:business_master_new
loadtime:0.19598388671875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lodgepole' limit 1
loadtime:0.19601798057556 / seconds
Query Executed:select id FROM `sd` where city='Lodgepole' && SIC_code='5541'DB:business_master_new
loadtime:0.19638705253601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Valley' limit 1
loadtime:0.19645404815674 / seconds
Query Executed:select id FROM `sd` where city='Long Valley' && SIC_code='5541'DB:business_master_new
loadtime:0.19682693481445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longlake' limit 1
loadtime:0.19687104225159 / seconds
Query Executed:select id FROM `sd` where city='Longlake' && SIC_code='5541'DB:business_master_new
loadtime:0.19711399078369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longvalley' limit 1
loadtime:0.19714307785034 / seconds
Query Executed:select id FROM `sd` where city='Longvalley' && SIC_code='5541'DB:business_master_new
loadtime:0.19741201400757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lower Brule' limit 1
loadtime:0.19746899604797 / seconds
Query Executed:select id FROM `sd` where city='Lower Brule' && SIC_code='5541'DB:business_master_new
loadtime:0.19800591468811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowry' limit 1
loadtime:0.19805002212524 / seconds
Query Executed:select id FROM `sd` where city='Lowry' && SIC_code='5541'DB:business_master_new
loadtime:0.1983060836792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:0.1983470916748 / seconds
Query Executed:select id FROM `sd` where city='Ludlow' && SIC_code='5541'DB:business_master_new
loadtime:0.19875407218933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyons' limit 1
loadtime:0.19879388809204 / seconds
Query Executed:select id FROM `sd` where city='Lyons' && SIC_code='5541'DB:business_master_new
loadtime:0.19917798042297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.19921493530273 / seconds
Query Executed:select id FROM `sd` where city='Madison' && SIC_code='5541'DB:business_master_new
loadtime:0.19998788833618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manderson' limit 1
loadtime:0.200040102005 / seconds
Query Executed:select id FROM `sd` where city='Manderson' && SIC_code='5541'DB:business_master_new
loadtime:0.20044994354248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield' limit 1
loadtime:0.2004930973053 / seconds
Query Executed:select id FROM `sd` where city='Mansfield' && SIC_code='5541'DB:business_master_new
loadtime:0.20094203948975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.20098400115967 / seconds
Query Executed:select id FROM `sd` where city='Marion' && SIC_code='5541'DB:business_master_new
loadtime:0.20156002044678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martin' limit 1
loadtime:0.20161890983582 / seconds
Query Executed:select id FROM `sd` where city='Martin' && SIC_code='5541'DB:business_master_new
loadtime:0.20215201377869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marty' limit 1
loadtime:0.2021849155426 / seconds
Query Executed:select id FROM `sd` where city='Marty' && SIC_code='5541'DB:business_master_new
loadtime:0.20264506340027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marvin' limit 1
loadtime:0.20268988609314 / seconds
Query Executed:select id FROM `sd` where city='Marvin' && SIC_code='5541'DB:business_master_new
loadtime:0.20299792289734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Intosh' limit 1
loadtime:0.20305490493774 / seconds
Query Executed:select id FROM `sd` where city='Mc Intosh' && SIC_code='5541'DB:business_master_new
loadtime:0.20364308357239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Laughlin' limit 1
loadtime:0.20368099212646 / seconds
Query Executed:select id FROM `sd` where city='Mc Laughlin' && SIC_code='5541'DB:business_master_new
loadtime:0.20449995994568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadow' limit 1
loadtime:0.20455098152161 / seconds
Query Executed:select id FROM `sd` where city='Meadow' && SIC_code='5541'DB:business_master_new
loadtime:0.20503902435303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meckling' limit 1
loadtime:0.20507788658142 / seconds
Query Executed:select id FROM `sd` where city='Meckling' && SIC_code='5541'DB:business_master_new
loadtime:0.20534610748291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mellette' limit 1
loadtime:0.2053849697113 / seconds
Query Executed:select id FROM `sd` where city='Mellette' && SIC_code='5541'DB:business_master_new
loadtime:0.20586204528809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menno' limit 1
loadtime:0.20590996742249 / seconds
Query Executed:select id FROM `sd` where city='Menno' && SIC_code='5541'DB:business_master_new
loadtime:0.20645189285278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland' limit 1
loadtime:0.20649790763855 / seconds
Query Executed:select id FROM `sd` where city='Midland' && SIC_code='5541'DB:business_master_new
loadtime:0.20698189735413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milbank' limit 1
loadtime:0.20702195167542 / seconds
Query Executed:select id FROM `sd` where city='Milbank' && SIC_code='5541'DB:business_master_new
loadtime:0.20767498016357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milesville' limit 1
loadtime:0.20770907402039 / seconds
Query Executed:select id FROM `sd` where city='Milesville' && SIC_code='5541'DB:business_master_new
loadtime:0.20813393592834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miller' limit 1
loadtime:0.20817995071411 / seconds
Query Executed:select id FROM `sd` where city='Miller' && SIC_code='5541'DB:business_master_new
loadtime:0.20880889892578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mina' limit 1
loadtime:0.20886301994324 / seconds
Query Executed:select id FROM `sd` where city='Mina' && SIC_code='5541'DB:business_master_new
loadtime:0.20914697647095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miranda' limit 1
loadtime:0.20917296409607 / seconds
Query Executed:select id FROM `sd` where city='Miranda' && SIC_code='5541'DB:business_master_new
loadtime:0.20940899848938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mission' limit 1
loadtime:0.20946002006531 / seconds
Query Executed:select id FROM `sd` where city='Mission' && SIC_code='5541'DB:business_master_new
loadtime:0.20998191833496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mission Hill' limit 1
loadtime:0.21002101898193 / seconds
Query Executed:select id FROM `sd` where city='Mission Hill' && SIC_code='5541'DB:business_master_new
loadtime:0.21050906181335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchell' limit 1
loadtime:0.21054291725159 / seconds
Query Executed:select id FROM `sd` where city='Mitchell' && SIC_code='5541'DB:business_master_new
loadtime:0.21165490150452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mobridge' limit 1
loadtime:0.21169090270996 / seconds
Query Executed:select id FROM `sd` where city='Mobridge' && SIC_code='5541'DB:business_master_new
loadtime:0.21239805221558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.2124559879303 / seconds
Query Executed:select id FROM `sd` where city='Monroe' && SIC_code='5541'DB:business_master_new
loadtime:0.21293807029724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montrose' limit 1
loadtime:0.21297287940979 / seconds
Query Executed:select id FROM `sd` where city='Montrose' && SIC_code='5541'DB:business_master_new
loadtime:0.21349501609802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morristown' limit 1
loadtime:0.2135329246521 / seconds
Query Executed:select id FROM `sd` where city='Morristown' && SIC_code='5541'DB:business_master_new
loadtime:0.21396207809448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mound City' limit 1
loadtime:0.21399593353271 / seconds
Query Executed:select id FROM `sd` where city='Mound City' && SIC_code='5541'DB:business_master_new
loadtime:0.21444606781006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Vernon' limit 1
loadtime:0.21448111534119 / seconds
Query Executed:select id FROM `sd` where city='Mount Vernon' && SIC_code='5541'DB:business_master_new
loadtime:0.21497797966003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Vernon' limit 1
loadtime:0.21501588821411 / seconds
Query Executed:select id FROM `sd` where city='Mt Vernon' && SIC_code='5541'DB:business_master_new
loadtime:0.21531391143799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mud Butte' limit 1
loadtime:0.21535491943359 / seconds
Query Executed:select id FROM `sd` where city='Mud Butte' && SIC_code='5541'DB:business_master_new
loadtime:0.21572995185852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murdo' limit 1
loadtime:0.21576905250549 / seconds
Query Executed:select id FROM `sd` where city='Murdo' && SIC_code='5541'DB:business_master_new
loadtime:0.21637296676636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nemo' limit 1
loadtime:0.2164158821106 / seconds
Query Executed:select id FROM `sd` where city='Nemo' && SIC_code='5541'DB:business_master_new
loadtime:0.21684002876282 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Effington' limit 1
loadtime:0.21689391136169 / seconds
Query Executed:select id FROM `sd` where city='New Effington' && SIC_code='5541'DB:business_master_new
loadtime:0.21738696098328 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Holland' limit 1
loadtime:0.21744108200073 / seconds
Query Executed:select id FROM `sd` where city='New Holland' && SIC_code='5541'DB:business_master_new
loadtime:0.21787095069885 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Underwood' limit 1
loadtime:0.21791505813599 / seconds
Query Executed:select id FROM `sd` where city='New Underwood' && SIC_code='5541'DB:business_master_new
loadtime:0.21843504905701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newell' limit 1
loadtime:0.21847796440125 / seconds
Query Executed:select id FROM `sd` where city='Newell' && SIC_code='5541'DB:business_master_new
loadtime:0.2190420627594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nisland' limit 1
loadtime:0.21908688545227 / seconds
Query Executed:select id FROM `sd` where city='Nisland' && SIC_code='5541'DB:business_master_new
loadtime:0.21952795982361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norris' limit 1
loadtime:0.21956896781921 / seconds
Query Executed:select id FROM `sd` where city='Norris' && SIC_code='5541'DB:business_master_new
loadtime:0.21998596191406 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Sioux City' limit 1
loadtime:0.22003197669983 / seconds
Query Executed:select id FROM `sd` where city='North Sioux City' && SIC_code='5541'DB:business_master_new
loadtime:0.22074699401855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northville' limit 1
loadtime:0.22080707550049 / seconds
Query Executed:select id FROM `sd` where city='Northville' && SIC_code='5541'DB:business_master_new
loadtime:0.2212860584259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nunda' limit 1
loadtime:0.22131896018982 / seconds
Query Executed:select id FROM `sd` where city='Nunda' && SIC_code='5541'DB:business_master_new
loadtime:0.22181797027588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oacoma' limit 1
loadtime:0.22186994552612 / seconds
Query Executed:select id FROM `sd` where city='Oacoma' && SIC_code='5541'DB:business_master_new
loadtime:0.22238492965698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oelrichs' limit 1
loadtime:0.22243690490723 / seconds
Query Executed:select id FROM `sd` where city='Oelrichs' && SIC_code='5541'DB:business_master_new
loadtime:0.22292995452881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oglala' limit 1
loadtime:0.22299003601074 / seconds
Query Executed:select id FROM `sd` where city='Oglala' && SIC_code='5541'DB:business_master_new
loadtime:0.22343897819519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okaton' limit 1
loadtime:0.22348403930664 / seconds
Query Executed:select id FROM `sd` where city='Okaton' && SIC_code='5541'DB:business_master_new
loadtime:0.22381901741028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okreek' limit 1
loadtime:0.22385501861572 / seconds
Query Executed:select id FROM `sd` where city='Okreek' && SIC_code='5541'DB:business_master_new
loadtime:0.22414898872375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oldham' limit 1
loadtime:0.22418999671936 / seconds
Query Executed:select id FROM `sd` where city='Oldham' && SIC_code='5541'DB:business_master_new
loadtime:0.22466897964478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olivet' limit 1
loadtime:0.22471404075623 / seconds
Query Executed:select id FROM `sd` where city='Olivet' && SIC_code='5541'DB:business_master_new
loadtime:0.22520089149475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onaka' limit 1
loadtime:0.2252368927002 / seconds
Query Executed:select id FROM `sd` where city='Onaka' && SIC_code='5541'DB:business_master_new
loadtime:0.2257719039917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onida' limit 1
loadtime:0.22582006454468 / seconds
Query Executed:select id FROM `sd` where city='Onida' && SIC_code='5541'DB:business_master_new
loadtime:0.22640991210938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Opal' limit 1
loadtime:0.22647094726562 / seconds
Query Executed:select id FROM `sd` where city='Opal' && SIC_code='5541'DB:business_master_new
loadtime:0.22671604156494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oral' limit 1
loadtime:0.22675895690918 / seconds
Query Executed:select id FROM `sd` where city='Oral' && SIC_code='5541'DB:business_master_new
loadtime:0.22719287872314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orient' limit 1
loadtime:0.22723889350891 / seconds
Query Executed:select id FROM `sd` where city='Orient' && SIC_code='5541'DB:business_master_new
loadtime:0.22773694992065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ortley' limit 1
loadtime:0.22778010368347 / seconds
Query Executed:select id FROM `sd` where city='Ortley' && SIC_code='5541'DB:business_master_new
loadtime:0.22815608978271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Owanka' limit 1
loadtime:0.2282030582428 / seconds
Query Executed:select id FROM `sd` where city='Owanka' && SIC_code='5541'DB:business_master_new
loadtime:0.22855997085571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parker' limit 1
loadtime:0.228600025177 / seconds
Query Executed:select id FROM `sd` where city='Parker' && SIC_code='5541'DB:business_master_new
loadtime:0.22920894622803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parkston' limit 1
loadtime:0.22925901412964 / seconds
Query Executed:select id FROM `sd` where city='Parkston' && SIC_code='5541'DB:business_master_new
loadtime:0.22983193397522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parmelee' limit 1
loadtime:0.22987008094788 / seconds
Query Executed:select id FROM `sd` where city='Parmelee' && SIC_code='5541'DB:business_master_new
loadtime:0.23028993606567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peever' limit 1
loadtime:0.23033595085144 / seconds
Query Executed:select id FROM `sd` where city='Peever' && SIC_code='5541'DB:business_master_new
loadtime:0.23084807395935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Philip' limit 1
loadtime:0.2308828830719 / seconds
Query Executed:select id FROM `sd` where city='Philip' && SIC_code='5541'DB:business_master_new
loadtime:0.23150205612183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickstown' limit 1
loadtime:0.23155999183655 / seconds
Query Executed:select id FROM `sd` where city='Pickstown' && SIC_code='5541'DB:business_master_new
loadtime:0.23208403587341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piedmont' limit 1
loadtime:0.23214292526245 / seconds
Query Executed:select id FROM `sd` where city='Piedmont' && SIC_code='5541'DB:business_master_new
loadtime:0.23271489143372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierpont' limit 1
loadtime:0.23276591300964 / seconds
Query Executed:select id FROM `sd` where city='Pierpont' && SIC_code='5541'DB:business_master_new
loadtime:0.23326206207275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierre' limit 1
loadtime:0.23330402374268 / seconds
Query Executed:select id FROM `sd` where city='Pierre' && SIC_code='5541'DB:business_master_new
loadtime:0.23446702957153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Ridge' limit 1
loadtime:0.2345290184021 / seconds
Query Executed:select id FROM `sd` where city='Pine Ridge' && SIC_code='5541'DB:business_master_new
loadtime:0.23516011238098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plankinton' limit 1
loadtime:0.23521590232849 / seconds
Query Executed:select id FROM `sd` where city='Plankinton' && SIC_code='5541'DB:business_master_new
loadtime:0.23583197593689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Platte' limit 1
loadtime:0.23589396476746 / seconds
Query Executed:select id FROM `sd` where city='Platte' && SIC_code='5541'DB:business_master_new
loadtime:0.23652601242065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pollock' limit 1
loadtime:0.23656010627747 / seconds
Query Executed:select id FROM `sd` where city='Pollock' && SIC_code='5541'DB:business_master_new
loadtime:0.23709201812744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Porcupine' limit 1
loadtime:0.23714995384216 / seconds
Query Executed:select id FROM `sd` where city='Porcupine' && SIC_code='5541'DB:business_master_new
loadtime:0.23761510848999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie City' limit 1
loadtime:0.2376549243927 / seconds
Query Executed:select id FROM `sd` where city='Prairie City' && SIC_code='5541'DB:business_master_new
loadtime:0.23811507225037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Presho' limit 1
loadtime:0.23815298080444 / seconds
Query Executed:select id FROM `sd` where city='Presho' && SIC_code='5541'DB:business_master_new
loadtime:0.23871302604675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pringle' limit 1
loadtime:0.23875594139099 / seconds
Query Executed:select id FROM `sd` where city='Pringle' && SIC_code='5541'DB:business_master_new
loadtime:0.23933601379395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pukwana' limit 1
loadtime:0.23936295509338 / seconds
Query Executed:select id FROM `sd` where city='Pukwana' && SIC_code='5541'DB:business_master_new
loadtime:0.24008893966675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinn' limit 1
loadtime:0.24014902114868 / seconds
Query Executed:select id FROM `sd` where city='Quinn' && SIC_code='5541'DB:business_master_new
loadtime:0.24059200286865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ralph' limit 1
loadtime:0.24063611030579 / seconds
Query Executed:select id FROM `sd` where city='Ralph' && SIC_code='5541'DB:business_master_new
loadtime:0.24095106124878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramona' limit 1
loadtime:0.2409770488739 / seconds
Query Executed:select id FROM `sd` where city='Ramona' && SIC_code='5541'DB:business_master_new
loadtime:0.24144601821899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rapid City' limit 1
loadtime:0.24148392677307 / seconds
Query Executed:select id FROM `sd` where city='Rapid City' && SIC_code='5541'DB:business_master_new
loadtime:0.24591994285583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ravinia' limit 1
loadtime:0.24600791931152 / seconds
Query Executed:select id FROM `sd` where city='Ravinia' && SIC_code='5541'DB:business_master_new
loadtime:0.24632596969604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:0.24636292457581 / seconds
Query Executed:select id FROM `sd` where city='Raymond' && SIC_code='5541'DB:business_master_new
loadtime:0.24691700935364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Owl' limit 1
loadtime:0.24696087837219 / seconds
Query Executed:select id FROM `sd` where city='Red Owl' && SIC_code='5541'DB:business_master_new
loadtime:0.2472128868103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redfield' limit 1
loadtime:0.24723792076111 / seconds
Query Executed:select id FROM `sd` where city='Redfield' && SIC_code='5541'DB:business_master_new
loadtime:0.24786710739136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redig' limit 1
loadtime:0.24791288375854 / seconds
Query Executed:select id FROM `sd` where city='Redig' && SIC_code='5541'DB:business_master_new
loadtime:0.24823999404907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ree Heights' limit 1
loadtime:0.24827194213867 / seconds
Query Executed:select id FROM `sd` where city='Ree Heights' && SIC_code='5541'DB:business_master_new
loadtime:0.24880695343018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reliance' limit 1
loadtime:0.24885010719299 / seconds
Query Executed:select id FROM `sd` where city='Reliance' && SIC_code='5541'DB:business_master_new
loadtime:0.2493679523468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Renner' limit 1
loadtime:0.24944305419922 / seconds
Query Executed:select id FROM `sd` where city='Renner' && SIC_code='5541'DB:business_master_new
loadtime:0.24994897842407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reva' limit 1
loadtime:0.24998497962952 / seconds
Query Executed:select id FROM `sd` where city='Reva' && SIC_code='5541'DB:business_master_new
loadtime:0.25046110153198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Revillo' limit 1
loadtime:0.25050401687622 / seconds
Query Executed:select id FROM `sd` where city='Revillo' && SIC_code='5541'DB:business_master_new
loadtime:0.25104594230652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeview' limit 1
loadtime:0.25109004974365 / seconds
Query Executed:select id FROM `sd` where city='Ridgeview' && SIC_code='5541'DB:business_master_new
loadtime:0.25145196914673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockham' limit 1
loadtime:0.25149393081665 / seconds
Query Executed:select id FROM `sd` where city='Rockham' && SIC_code='5541'DB:business_master_new
loadtime:0.2519268989563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roscoe' limit 1
loadtime:0.25197100639343 / seconds
Query Executed:select id FROM `sd` where city='Roscoe' && SIC_code='5541'DB:business_master_new
loadtime:0.25249290466309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosebud' limit 1
loadtime:0.25254011154175 / seconds
Query Executed:select id FROM `sd` where city='Rosebud' && SIC_code='5541'DB:business_master_new
loadtime:0.25305104255676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosholt' limit 1
loadtime:0.25310111045837 / seconds
Query Executed:select id FROM `sd` where city='Rosholt' && SIC_code='5541'DB:business_master_new
loadtime:0.25365710258484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roslyn' limit 1
loadtime:0.25370097160339 / seconds
Query Executed:select id FROM `sd` where city='Roslyn' && SIC_code='5541'DB:business_master_new
loadtime:0.2542040348053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowena' limit 1
loadtime:0.25426602363586 / seconds
Query Executed:select id FROM `sd` where city='Rowena' && SIC_code='5541'DB:business_master_new
loadtime:0.25458407402039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:0.25462889671326 / seconds
Query Executed:select id FROM `sd` where city='Rutland' && SIC_code='5541'DB:business_master_new
loadtime:0.25506091117859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Charles' limit 1
loadtime:0.25510907173157 / seconds
Query Executed:select id FROM `sd` where city='Saint Charles' && SIC_code='5541'DB:business_master_new
loadtime:0.25544691085815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Francis' limit 1
loadtime:0.25549006462097 / seconds
Query Executed:select id FROM `sd` where city='Saint Francis' && SIC_code='5541'DB:business_master_new
loadtime:0.2566978931427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Lawrence' limit 1
loadtime:0.25674796104431 / seconds
Query Executed:select id FROM `sd` where city='Saint Lawrence' && SIC_code='5541'DB:business_master_new
loadtime:0.25727891921997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Onge' limit 1
loadtime:0.25732207298279 / seconds
Query Executed:select id FROM `sd` where city='Saint Onge' && SIC_code='5541'DB:business_master_new
loadtime:0.2577760219574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.25781798362732 / seconds
Query Executed:select id FROM `sd` where city='Salem' && SIC_code='5541'DB:business_master_new
loadtime:0.25844502449036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scenic' limit 1
loadtime:0.25850892066956 / seconds
Query Executed:select id FROM `sd` where city='Scenic' && SIC_code='5541'DB:business_master_new
loadtime:0.25893807411194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotland' limit 1
loadtime:0.25898504257202 / seconds
Query Executed:select id FROM `sd` where city='Scotland' && SIC_code='5541'DB:business_master_new
loadtime:0.25953388214111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selby' limit 1
loadtime:0.25956702232361 / seconds
Query Executed:select id FROM `sd` where city='Selby' && SIC_code='5541'DB:business_master_new
loadtime:0.26015090942383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:0.26020908355713 / seconds
Query Executed:select id FROM `sd` where city='Seneca' && SIC_code='5541'DB:business_master_new
loadtime:0.26070308685303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shadehill' limit 1
loadtime:0.26074290275574 / seconds
Query Executed:select id FROM `sd` where city='Shadehill' && SIC_code='5541'DB:business_master_new
loadtime:0.26100397109985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherman' limit 1
loadtime:0.26104092597961 / seconds
Query Executed:select id FROM `sd` where city='Sherman' && SIC_code='5541'DB:business_master_new
loadtime:0.26127910614014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver City' limit 1
loadtime:0.26131391525269 / seconds
Query Executed:select id FROM `sd` where city='Silver City' && SIC_code='5541'DB:business_master_new
loadtime:0.26156997680664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sinai' limit 1
loadtime:0.26159596443176 / seconds
Query Executed:select id FROM `sd` where city='Sinai' && SIC_code='5541'DB:business_master_new
loadtime:0.26204991340637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sioux Falls' limit 1
loadtime:0.26209807395935 / seconds
Query Executed:select id FROM `sd` where city='Sioux Falls' && SIC_code='5541'DB:business_master_new
loadtime:0.26608490943909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sisseton' limit 1
loadtime:0.2661600112915 / seconds
Query Executed:select id FROM `sd` where city='Sisseton' && SIC_code='5541'DB:business_master_new
loadtime:0.26686501502991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sky Ranch' limit 1
loadtime:0.26691198348999 / seconds
Query Executed:select id FROM `sd` where city='Sky Ranch' && SIC_code='5541'DB:business_master_new
loadtime:0.26722598075867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithwick' limit 1
loadtime:0.26727700233459 / seconds
Query Executed:select id FROM `sd` where city='Smithwick' && SIC_code='5541'DB:business_master_new
loadtime:0.26757192611694 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Shore' limit 1
loadtime:0.26761293411255 / seconds
Query Executed:select id FROM `sd` where city='South Shore' && SIC_code='5541'DB:business_master_new
loadtime:0.26812100410461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spearfish' limit 1
loadtime:0.26816606521606 / seconds
Query Executed:select id FROM `sd` where city='Spearfish' && SIC_code='5541'DB:business_master_new
loadtime:0.26914000511169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:0.26920104026794 / seconds
Query Executed:select id FROM `sd` where city='Spencer' && SIC_code='5541'DB:business_master_new
loadtime:0.26972508430481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.26978492736816 / seconds
Query Executed:select id FROM `sd` where city='Springfield' && SIC_code='5541'DB:business_master_new
loadtime:0.27033495903015 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Charles' limit 1
loadtime:0.27039003372192 / seconds
Query Executed:select id FROM `sd` where city='St Charles' && SIC_code='5541'DB:business_master_new
loadtime:0.27064609527588 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Francis' limit 1
loadtime:0.27068710327148 / seconds
Query Executed:select id FROM `sd` where city='St Francis' && SIC_code='5541'DB:business_master_new
loadtime:0.27093505859375 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Lawrence' limit 1
loadtime:0.27097296714783 / seconds
Query Executed:select id FROM `sd` where city='St Lawrence' && SIC_code='5541'DB:business_master_new
loadtime:0.27126407623291 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Onge' limit 1
loadtime:0.27128911018372 / seconds
Query Executed:select id FROM `sd` where city='St Onge' && SIC_code='5541'DB:business_master_new
loadtime:0.27153611183167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephan' limit 1
loadtime:0.27157497406006 / seconds
Query Executed:select id FROM `sd` where city='Stephan' && SIC_code='5541'DB:business_master_new
loadtime:0.27194905281067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stickney' limit 1
loadtime:0.27199292182922 / seconds
Query Executed:select id FROM `sd` where city='Stickney' && SIC_code='5541'DB:business_master_new
loadtime:0.27250695228577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockholm' limit 1
loadtime:0.27255392074585 / seconds
Query Executed:select id FROM `sd` where city='Stockholm' && SIC_code='5541'DB:business_master_new
loadtime:0.27312088012695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strandburg' limit 1
loadtime:0.27315807342529 / seconds
Query Executed:select id FROM `sd` where city='Strandburg' && SIC_code='5541'DB:business_master_new
loadtime:0.27360606193542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:0.27364587783813 / seconds
Query Executed:select id FROM `sd` where city='Stratford' && SIC_code='5541'DB:business_master_new
loadtime:0.27416610717773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturgis' limit 1
loadtime:0.27421307563782 / seconds
Query Executed:select id FROM `sd` where city='Sturgis' && SIC_code='5541'DB:business_master_new
loadtime:0.27499008178711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summit' limit 1
loadtime:0.27505707740784 / seconds
Query Executed:select id FROM `sd` where city='Summit' && SIC_code='5541'DB:business_master_new
loadtime:0.27556705474854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabor' limit 1
loadtime:0.27561402320862 / seconds
Query Executed:select id FROM `sd` where city='Tabor' && SIC_code='5541'DB:business_master_new
loadtime:0.27615189552307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tea' limit 1
loadtime:0.27619409561157 / seconds
Query Executed:select id FROM `sd` where city='Tea' && SIC_code='5541'DB:business_master_new
loadtime:0.2768189907074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timber Lake' limit 1
loadtime:0.27686810493469 / seconds
Query Executed:select id FROM `sd` where city='Timber Lake' && SIC_code='5541'DB:business_master_new
loadtime:0.27740693092346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolstoy' limit 1
loadtime:0.27747893333435 / seconds
Query Executed:select id FROM `sd` where city='Tolstoy' && SIC_code='5541'DB:business_master_new
loadtime:0.27808594703674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toronto' limit 1
loadtime:0.27813696861267 / seconds
Query Executed:select id FROM `sd` where city='Toronto' && SIC_code='5541'DB:business_master_new
loadtime:0.27861595153809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trail City' limit 1
loadtime:0.27866291999817 / seconds
Query Executed:select id FROM `sd` where city='Trail City' && SIC_code='5541'DB:business_master_new
loadtime:0.27905988693237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trent' limit 1
loadtime:0.27910804748535 / seconds
Query Executed:select id FROM `sd` where city='Trent' && SIC_code='5541'DB:business_master_new
loadtime:0.27960896492004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tripp' limit 1
loadtime:0.27963590621948 / seconds
Query Executed:select id FROM `sd` where city='Tripp' && SIC_code='5541'DB:business_master_new
loadtime:0.28017091751099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tulare' limit 1
loadtime:0.28022503852844 / seconds
Query Executed:select id FROM `sd` where city='Tulare' && SIC_code='5541'DB:business_master_new
loadtime:0.28074097633362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turton' limit 1
loadtime:0.28079104423523 / seconds
Query Executed:select id FROM `sd` where city='Turton' && SIC_code='5541'DB:business_master_new
loadtime:0.28128790855408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuthill' limit 1
loadtime:0.28133201599121 / seconds
Query Executed:select id FROM `sd` where city='Tuthill' && SIC_code='5541'DB:business_master_new
loadtime:0.28170895576477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twin Brooks' limit 1
loadtime:0.28175091743469 / seconds
Query Executed:select id FROM `sd` where city='Twin Brooks' && SIC_code='5541'DB:business_master_new
loadtime:0.28230595588684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyndall' limit 1
loadtime:0.2823429107666 / seconds
Query Executed:select id FROM `sd` where city='Tyndall' && SIC_code='5541'DB:business_master_new
loadtime:0.28295993804932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Center' limit 1
loadtime:0.28302693367004 / seconds
Query Executed:select id FROM `sd` where city='Union Center' && SIC_code='5541'DB:business_master_new
loadtime:0.28359293937683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Utica' limit 1
loadtime:0.28363490104675 / seconds
Query Executed:select id FROM `sd` where city='Utica' && SIC_code='5541'DB:business_master_new
loadtime:0.28412795066833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vale' limit 1
loadtime:0.28417801856995 / seconds
Query Executed:select id FROM `sd` where city='Vale' && SIC_code='5541'DB:business_master_new
loadtime:0.28467988967896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Springs' limit 1
loadtime:0.28470802307129 / seconds
Query Executed:select id FROM `sd` where city='Valley Springs' && SIC_code='5541'DB:business_master_new
loadtime:0.28525805473328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Veblen' limit 1
loadtime:0.28531694412231 / seconds
Query Executed:select id FROM `sd` where city='Veblen' && SIC_code='5541'DB:business_master_new
loadtime:0.28586292266846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vermillion' limit 1
loadtime:0.28591108322144 / seconds
Query Executed:select id FROM `sd` where city='Vermillion' && SIC_code='5541'DB:business_master_new
loadtime:0.28672504425049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viborg' limit 1
loadtime:0.28676104545593 / seconds
Query Executed:select id FROM `sd` where city='Viborg' && SIC_code='5541'DB:business_master_new
loadtime:0.28736996650696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vienna' limit 1
loadtime:0.28745007514954 / seconds
Query Executed:select id FROM `sd` where city='Vienna' && SIC_code='5541'DB:business_master_new
loadtime:0.28792905807495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virgil' limit 1
loadtime:0.2879810333252 / seconds
Query Executed:select id FROM `sd` where city='Virgil' && SIC_code='5541'DB:business_master_new
loadtime:0.28831100463867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vivian' limit 1
loadtime:0.28834795951843 / seconds
Query Executed:select id FROM `sd` where city='Vivian' && SIC_code='5541'DB:business_master_new
loadtime:0.28884410858154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Volga' limit 1
loadtime:0.28888893127441 / seconds
Query Executed:select id FROM `sd` where city='Volga' && SIC_code='5541'DB:business_master_new
loadtime:0.28945803642273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Volin' limit 1
loadtime:0.28949499130249 / seconds
Query Executed:select id FROM `sd` where city='Volin' && SIC_code='5541'DB:business_master_new
loadtime:0.29002404212952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wagner' limit 1
loadtime:0.29007601737976 / seconds
Query Executed:select id FROM `sd` where city='Wagner' && SIC_code='5541'DB:business_master_new
loadtime:0.290687084198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakonda' limit 1
loadtime:0.29072403907776 / seconds
Query Executed:select id FROM `sd` where city='Wakonda' && SIC_code='5541'DB:business_master_new
loadtime:0.29126501083374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakpala' limit 1
loadtime:0.29131507873535 / seconds
Query Executed:select id FROM `sd` where city='Wakpala' && SIC_code='5541'DB:business_master_new
loadtime:0.29165887832642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wall' limit 1
loadtime:0.29169702529907 / seconds
Query Executed:select id FROM `sd` where city='Wall' && SIC_code='5541'DB:business_master_new
loadtime:0.29226589202881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallace' limit 1
loadtime:0.29233908653259 / seconds
Query Executed:select id FROM `sd` where city='Wallace' && SIC_code='5541'DB:business_master_new
loadtime:0.29279804229736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wanblee' limit 1
loadtime:0.29283404350281 / seconds
Query Executed:select id FROM `sd` where city='Wanblee' && SIC_code='5541'DB:business_master_new
loadtime:0.29329800605774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ward' limit 1
loadtime:0.29333806037903 / seconds
Query Executed:select id FROM `sd` where city='Ward' && SIC_code='5541'DB:business_master_new
loadtime:0.29362201690674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warner' limit 1
loadtime:0.29366087913513 / seconds
Query Executed:select id FROM `sd` where city='Warner' && SIC_code='5541'DB:business_master_new
loadtime:0.29416990280151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wasta' limit 1
loadtime:0.2942259311676 / seconds
Query Executed:select id FROM `sd` where city='Wasta' && SIC_code='5541'DB:business_master_new
loadtime:0.29467511177063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watauga' limit 1
loadtime:0.29471707344055 / seconds
Query Executed:select id FROM `sd` where city='Watauga' && SIC_code='5541'DB:business_master_new
loadtime:0.29506397247314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:0.29510593414307 / seconds
Query Executed:select id FROM `sd` where city='Watertown' && SIC_code='5541'DB:business_master_new
loadtime:0.29907393455505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waubay' limit 1
loadtime:0.29912400245667 / seconds
Query Executed:select id FROM `sd` where city='Waubay' && SIC_code='5541'DB:business_master_new
loadtime:0.29966306686401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverly' limit 1
loadtime:0.29970693588257 / seconds
Query Executed:select id FROM `sd` where city='Waverly' && SIC_code='5541'DB:business_master_new
loadtime:0.29994702339172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:0.29998087882996 / seconds
Query Executed:select id FROM `sd` where city='Webster' && SIC_code='5541'DB:business_master_new
loadtime:0.30062198638916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wecota' limit 1
loadtime:0.30066895484924 / seconds
Query Executed:select id FROM `sd` where city='Wecota' && SIC_code='5541'DB:business_master_new
loadtime:0.30090999603271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworth' limit 1
loadtime:0.30094599723816 / seconds
Query Executed:select id FROM `sd` where city='Wentworth' && SIC_code='5541'DB:business_master_new
loadtime:0.30143904685974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wessington' limit 1
loadtime:0.30147099494934 / seconds
Query Executed:select id FROM `sd` where city='Wessington' && SIC_code='5541'DB:business_master_new
loadtime:0.30199503898621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wessington Spgs' limit 1
loadtime:0.30204606056213 / seconds
Query Executed:select id FROM `sd` where city='Wessington Spgs' && SIC_code='5541'DB:business_master_new
loadtime:0.30231094360352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wessington Springs' limit 1
loadtime:0.30233788490295 / seconds
Query Executed:select id FROM `sd` where city='Wessington Springs' && SIC_code='5541'DB:business_master_new
loadtime:0.30294108390808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:0.30299806594849 / seconds
Query Executed:select id FROM `sd` where city='Westport' && SIC_code='5541'DB:business_master_new
loadtime:0.30347990989685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wetonka' limit 1
loadtime:0.30352306365967 / seconds
Query Executed:select id FROM `sd` where city='Wetonka' && SIC_code='5541'DB:business_master_new
loadtime:0.30382990837097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wewela' limit 1
loadtime:0.30386590957642 / seconds
Query Executed:select id FROM `sd` where city='Wewela' && SIC_code='5541'DB:business_master_new
loadtime:0.30415010452271 / seconds
Query loaded from cache:select * from geodata_geocity where city='White' limit 1
loadtime:0.3041889667511 / seconds
Query Executed:select id FROM `sd` where city='White' && SIC_code='5541'DB:business_master_new
loadtime:0.30476403236389 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Lake' limit 1
loadtime:0.30482411384583 / seconds
Query Executed:select id FROM `sd` where city='White Lake' && SIC_code='5541'DB:business_master_new
loadtime:0.30537009239197 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Owl' limit 1
loadtime:0.3054039478302 / seconds
Query Executed:select id FROM `sd` where city='White Owl' && SIC_code='5541'DB:business_master_new
loadtime:0.30574607849121 / seconds
Query loaded from cache:select * from geodata_geocity where city='White River' limit 1
loadtime:0.30579805374146 / seconds
Query Executed:select id FROM `sd` where city='White River' && SIC_code='5541'DB:business_master_new
loadtime:0.30633997917175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitehorse' limit 1
loadtime:0.30638408660889 / seconds
Query Executed:select id FROM `sd` where city='Whitehorse' && SIC_code='5541'DB:business_master_new
loadtime:0.30665707588196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitewood' limit 1
loadtime:0.3066840171814 / seconds
Query Executed:select id FROM `sd` where city='Whitewood' && SIC_code='5541'DB:business_master_new
loadtime:0.30717301368713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willow Lake' limit 1
loadtime:0.30720901489258 / seconds
Query Executed:select id FROM `sd` where city='Willow Lake' && SIC_code='5541'DB:business_master_new
loadtime:0.30773711204529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmot' limit 1
loadtime:0.30778789520264 / seconds
Query Executed:select id FROM `sd` where city='Wilmot' && SIC_code='5541'DB:business_master_new
loadtime:0.30831289291382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winfred' limit 1
loadtime:0.30835604667664 / seconds
Query Executed:select id FROM `sd` where city='Winfred' && SIC_code='5541'DB:business_master_new
loadtime:0.30886602401733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winner' limit 1
loadtime:0.30891895294189 / seconds
Query Executed:select id FROM `sd` where city='Winner' && SIC_code='5541'DB:business_master_new
loadtime:0.30963587760925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Witten' limit 1
loadtime:0.30967307090759 / seconds
Query Executed:select id FROM `sd` where city='Witten' && SIC_code='5541'DB:business_master_new
loadtime:0.310133934021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolsey' limit 1
loadtime:0.31018209457397 / seconds
Query Executed:select id FROM `sd` where city='Wolsey' && SIC_code='5541'DB:business_master_new
loadtime:0.31070995330811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wood' limit 1
loadtime:0.3107750415802 / seconds
Query Executed:select id FROM `sd` where city='Wood' && SIC_code='5541'DB:business_master_new
loadtime:0.3112781047821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woonsocket' limit 1
loadtime:0.31132006645203 / seconds
Query Executed:select id FROM `sd` where city='Woonsocket' && SIC_code='5541'DB:business_master_new
loadtime:0.31193208694458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worthing' limit 1
loadtime:0.31198906898499 / seconds
Query Executed:select id FROM `sd` where city='Worthing' && SIC_code='5541'DB:business_master_new
loadtime:0.3124680519104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wounded Knee' limit 1
loadtime:0.31250190734863 / seconds
Query Executed:select id FROM `sd` where city='Wounded Knee' && SIC_code='5541'DB:business_master_new
loadtime:0.31285500526428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yale' limit 1
loadtime:0.31290292739868 / seconds
Query Executed:select id FROM `sd` where city='Yale' && SIC_code='5541'DB:business_master_new
loadtime:0.31337308883667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yankton' limit 1
loadtime:0.31341195106506 / seconds
Query Executed:select id FROM `sd` where city='Yankton' && SIC_code='5541'DB:business_master_new
loadtime:0.31736397743225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zell' limit 1
loadtime:0.31741404533386 / seconds
Query Executed:select id FROM `sd` where city='Zell' && SIC_code='5541'DB:business_master_new
loadtime:0.31768989562988 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.31776905059814 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.31794404983521 / seconds
Operation template executed (chunk cache operation)
loadtime:0.31801700592041 / seconds
template override:Default
loadtime:0.31803607940674 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:0.31895804405212 / seconds
Template Constructed, Array Rows:49
loadtime:0.31920409202576 / seconds
TOTAL EXECUTION TIME: 0.319
loadtime:0.31929206848145 / seconds

THIS PAGE CACHED ON:
THIS PAGE COMPRESSION:
HITS TO THIS PAGE/CACHE:
PAGES STORED:
DATASIZE: Bytes
Compression:


PAGE OBJECT DATA


Key: page;
subKey: directorystate;
subKey: directorystatepages;
subKey: template;



_GET


Array ( [cat_URLid] => gasoline-service-station [stateURLid] => south-dakota )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:0.31929588317871
TOTAL KEY ARRAYS: 69