DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:7.7962875366211E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0020039081573486 / seconds
host not found setting manual db connection
loadtime:0.0099239349365234 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010175943374634 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010384798049927 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.01045298576355 / seconds
zipcode:
loadtime:0.010487794876099 / seconds
Query Executed:select * from search_referrer where page_hash='0ebfbce84e82f458f1de864e0149264c' limit 10 DB:ezrox_toadli
loadtime:0.010754823684692 / seconds
Operation header executed (non global)
loadtime:0.010796785354614 / seconds
Operation leaderboard executed (non global)
loadtime:0.01085376739502 / seconds
Operation square executed (non global)
loadtime:0.010885000228882 / seconds
Operation square_bottom executed (non global)
loadtime:0.010913848876953 / seconds
Operation smallsquare executed (non global)
loadtime:0.010939836502075 / seconds
Operation headeradright executed (non global)
loadtime:0.010965824127197 / seconds
Operation google_analytics executed (non global)
loadtime:0.010991811752319 / seconds
Operation topstories executed (non global)
loadtime:0.011017799377441 / seconds
Operation businessnearyou executed (non global)
loadtime:0.011045932769775 / seconds
Operation memberbuscount executed (non global)
loadtime:0.011070966720581 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.011351823806763 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011547803878784 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011596918106079 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011659860610962 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011709928512573 / seconds
Template key: archive_menu pushed
loadtime:0.011718988418579 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011733770370483 / seconds
Template key: get_gravatar pushed
loadtime:0.01173996925354 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011748790740967 / seconds
*10)-10)+1 | start:0
loadtime:0.011788845062256 / seconds
DB connected to localhost business_master_new
loadtime:0.012066841125488 / seconds
Query Executed:select * from categories where cat_URLid='cable-and-other-pay-television-services'DB:business_master_new
loadtime:0.013067960739136 / seconds
Query stored in cache : _QUERY_www.toadli.com80aad97ff291e204cb35a2d48307d612
loadtime:0.013128995895386 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='south-dakota'
loadtime:0.013170957565308 / seconds
Query Executed:select * from `sd_catmap` where sic='4841' order by city ascDB:business_master_new
loadtime:0.032571792602539 / seconds
Query stored in cache : _QUERY_www.toadli.com7f2f7119aa79ce10482a180ab1dbe7cc
loadtime:0.034181833267212 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='south-dakota'
loadtime:0.034238815307617 / seconds
Query Executed:select sum(totalcount) as totalsum from `sd_catmap` where sic='4841'DB:business_master_new
loadtime:0.03646183013916 / seconds
Query stored in cache : _QUERY_www.toadli.com73d6ffc383c77143338f5479ad8b9f07
loadtime:0.036498785018921 / seconds
410 / 11
loadtime:0.036560773849487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aberdeen' limit 1
loadtime:0.036627769470215 / seconds
Query Executed:select id FROM `sd` where city='Aberdeen' && SIC_code='4841'DB:business_master_new
loadtime:0.037383794784546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Academy' limit 1
loadtime:0.037438869476318 / seconds
Query Executed:select id FROM `sd` where city='Academy' && SIC_code='4841'DB:business_master_new
loadtime:0.03789496421814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agar' limit 1
loadtime:0.0379478931427 / seconds
Query Executed:select id FROM `sd` where city='Agar' && SIC_code='4841'DB:business_master_new
loadtime:0.038625955581665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Akaska' limit 1
loadtime:0.038678884506226 / seconds
Query Executed:select id FROM `sd` where city='Akaska' && SIC_code='4841'DB:business_master_new
loadtime:0.039180994033813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alcester' limit 1
loadtime:0.039233922958374 / seconds
Query Executed:select id FROM `sd` where city='Alcester' && SIC_code='4841'DB:business_master_new
loadtime:0.039883852005005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexandria' limit 1
loadtime:0.039938926696777 / seconds
Query Executed:select id FROM `sd` where city='Alexandria' && SIC_code='4841'DB:business_master_new
loadtime:0.040603876113892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allen' limit 1
loadtime:0.040672779083252 / seconds
Query Executed:select id FROM `sd` where city='Allen' && SIC_code='4841'DB:business_master_new
loadtime:0.041232824325562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpena' limit 1
loadtime:0.041285991668701 / seconds
Query Executed:select id FROM `sd` where city='Alpena' && SIC_code='4841'DB:business_master_new
loadtime:0.041957855224609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altamont' limit 1
loadtime:0.042008876800537 / seconds
Query Executed:select id FROM `sd` where city='Altamont' && SIC_code='4841'DB:business_master_new
loadtime:0.042385816574097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.042437791824341 / seconds
Query Executed:select id FROM `sd` where city='Amherst' && SIC_code='4841'DB:business_master_new
loadtime:0.042957782745361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.043008804321289 / seconds
Query Executed:select id FROM `sd` where city='Andover' && SIC_code='4841'DB:business_master_new
loadtime:0.043671846389771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ardmore' limit 1
loadtime:0.043725967407227 / seconds
Query Executed:select id FROM `sd` where city='Ardmore' && SIC_code='4841'DB:business_master_new
loadtime:0.044124841690063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.044176816940308 / seconds
Query Executed:select id FROM `sd` where city='Arlington' && SIC_code='4841'DB:business_master_new
loadtime:0.044851779937744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Armour' limit 1
loadtime:0.044904947280884 / seconds
Query Executed:select id FROM `sd` where city='Armour' && SIC_code='4841'DB:business_master_new
loadtime:0.04558277130127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Artesian' limit 1
loadtime:0.045635938644409 / seconds
Query Executed:select id FROM `sd` where city='Artesian' && SIC_code='4841'DB:business_master_new
loadtime:0.04628586769104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashton' limit 1
loadtime:0.046347856521606 / seconds
Query Executed:select id FROM `sd` where city='Ashton' && SIC_code='4841'DB:business_master_new
loadtime:0.047001838684082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Astoria' limit 1
loadtime:0.04705286026001 / seconds
Query Executed:select id FROM `sd` where city='Astoria' && SIC_code='4841'DB:business_master_new
loadtime:0.047715902328491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.047767877578735 / seconds
Query Executed:select id FROM `sd` where city='Aurora' && SIC_code='4841'DB:business_master_new
loadtime:0.048430919647217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.048482894897461 / seconds
Query Executed:select id FROM `sd` where city='Avon' && SIC_code='4841'DB:business_master_new
loadtime:0.049157857894897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Badger' limit 1
loadtime:0.049209833145142 / seconds
Query Executed:select id FROM `sd` where city='Badger' && SIC_code='4841'DB:business_master_new
loadtime:0.049761772155762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baltic' limit 1
loadtime:0.049814939498901 / seconds
Query Executed:select id FROM `sd` where city='Baltic' && SIC_code='4841'DB:business_master_new
loadtime:0.050479888916016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bancroft' limit 1
loadtime:0.050535917282104 / seconds
Query Executed:select id FROM `sd` where city='Bancroft' && SIC_code='4841'DB:business_master_new
loadtime:0.050952911376953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnard' limit 1
loadtime:0.051003932952881 / seconds
Query Executed:select id FROM `sd` where city='Barnard' && SIC_code='4841'DB:business_master_new
loadtime:0.051434993743896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Batesland' limit 1
loadtime:0.051487922668457 / seconds
Query Executed:select id FROM `sd` where city='Batesland' && SIC_code='4841'DB:business_master_new
loadtime:0.052066802978516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.05211877822876 / seconds
Query Executed:select id FROM `sd` where city='Bath' && SIC_code='4841'DB:business_master_new
loadtime:0.052795886993408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belle Fourche' limit 1
loadtime:0.052848815917969 / seconds
Query Executed:select id FROM `sd` where city='Belle Fourche' && SIC_code='4841'DB:business_master_new
loadtime:0.053536891937256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvidere' limit 1
loadtime:0.0535888671875 / seconds
Query Executed:select id FROM `sd` where city='Belvidere' && SIC_code='4841'DB:business_master_new
loadtime:0.054205894470215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beresford' limit 1
loadtime:0.054256916046143 / seconds
Query Executed:select id FROM `sd` where city='Beresford' && SIC_code='4841'DB:business_master_new
loadtime:0.054954767227173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Stone City' limit 1
loadtime:0.0550217628479 / seconds
Query Executed:select id FROM `sd` where city='Big Stone City' && SIC_code='4841'DB:business_master_new
loadtime:0.055699825286865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bison' limit 1
loadtime:0.055753946304321 / seconds
Query Executed:select id FROM `sd` where city='Bison' && SIC_code='4841'DB:business_master_new
loadtime:0.056392908096313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Hawk' limit 1
loadtime:0.056444883346558 / seconds
Query Executed:select id FROM `sd` where city='Black Hawk' && SIC_code='4841'DB:business_master_new
loadtime:0.057101964950562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blunt' limit 1
loadtime:0.057154893875122 / seconds
Query Executed:select id FROM `sd` where city='Blunt' && SIC_code='4841'DB:business_master_new
loadtime:0.057835817337036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonesteel' limit 1
loadtime:0.05788779258728 / seconds
Query Executed:select id FROM `sd` where city='Bonesteel' && SIC_code='4841'DB:business_master_new
loadtime:0.058562994003296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowdle' limit 1
loadtime:0.05861496925354 / seconds
Query Executed:select id FROM `sd` where city='Bowdle' && SIC_code='4841'DB:business_master_new
loadtime:0.059257984161377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Box Elder' limit 1
loadtime:0.059307813644409 / seconds
Query Executed:select id FROM `sd` where city='Box Elder' && SIC_code='4841'DB:business_master_new
loadtime:0.059966802597046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradley' limit 1
loadtime:0.060019969940186 / seconds
Query Executed:select id FROM `sd` where city='Bradley' && SIC_code='4841'DB:business_master_new
loadtime:0.060671806335449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.060725927352905 / seconds
Query Executed:select id FROM `sd` where city='Brandon' && SIC_code='4841'DB:business_master_new
loadtime:0.061360836029053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandt' limit 1
loadtime:0.061412811279297 / seconds
Query Executed:select id FROM `sd` where city='Brandt' && SIC_code='4841'DB:business_master_new
loadtime:0.062042951583862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brentford' limit 1
loadtime:0.062094926834106 / seconds
Query Executed:select id FROM `sd` where city='Brentford' && SIC_code='4841'DB:business_master_new
loadtime:0.062729835510254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.062782764434814 / seconds
Query Executed:select id FROM `sd` where city='Bridgewater' && SIC_code='4841'DB:business_master_new
loadtime:0.063405990600586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.06345796585083 / seconds
Query Executed:select id FROM `sd` where city='Bristol' && SIC_code='4841'DB:business_master_new
loadtime:0.064107894897461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Britton' limit 1
loadtime:0.064158916473389 / seconds
Query Executed:select id FROM `sd` where city='Britton' && SIC_code='4841'DB:business_master_new
loadtime:0.064827919006348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookings' limit 1
loadtime:0.064879894256592 / seconds
Query Executed:select id FROM `sd` where city='Brookings' && SIC_code='4841'DB:business_master_new
loadtime:0.065528869628906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruce' limit 1
loadtime:0.065598964691162 / seconds
Query Executed:select id FROM `sd` where city='Bruce' && SIC_code='4841'DB:business_master_new
loadtime:0.066223859786987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryant' limit 1
loadtime:0.066275835037231 / seconds
Query Executed:select id FROM `sd` where city='Bryant' && SIC_code='4841'DB:business_master_new
loadtime:0.066929817199707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo' limit 1
loadtime:0.066981792449951 / seconds
Query Executed:select id FROM `sd` where city='Buffalo' && SIC_code='4841'DB:business_master_new
loadtime:0.067636966705322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Gap' limit 1
loadtime:0.06768798828125 / seconds
Query Executed:select id FROM `sd` where city='Buffalo Gap' && SIC_code='4841'DB:business_master_new
loadtime:0.068327903747559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Ridge' limit 1
loadtime:0.068388938903809 / seconds
Query Executed:select id FROM `sd` where city='Buffalo Ridge' && SIC_code='4841'DB:business_master_new
loadtime:0.068793773651123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bullhead' limit 1
loadtime:0.068847894668579 / seconds
Query Executed:select id FROM `sd` where city='Bullhead' && SIC_code='4841'DB:business_master_new
loadtime:0.069350957870483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burbank' limit 1
loadtime:0.06940484046936 / seconds
Query Executed:select id FROM `sd` where city='Burbank' && SIC_code='4841'DB:business_master_new
loadtime:0.070060968399048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burke' limit 1
loadtime:0.070112943649292 / seconds
Query Executed:select id FROM `sd` where city='Burke' && SIC_code='4841'DB:business_master_new
loadtime:0.07079291343689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bushnell' limit 1
loadtime:0.070843935012817 / seconds
Query Executed:select id FROM `sd` where city='Bushnell' && SIC_code='4841'DB:business_master_new
loadtime:0.071248769760132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butler' limit 1
loadtime:0.07129979133606 / seconds
Query Executed:select id FROM `sd` where city='Butler' && SIC_code='4841'DB:business_master_new
loadtime:0.071719884872437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Crook' limit 1
loadtime:0.071773767471313 / seconds
Query Executed:select id FROM `sd` where city='Camp Crook' && SIC_code='4841'DB:business_master_new
loadtime:0.072439908981323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canistota' limit 1
loadtime:0.072491884231567 / seconds
Query Executed:select id FROM `sd` where city='Canistota' && SIC_code='4841'DB:business_master_new
loadtime:0.073169946670532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canova' limit 1
loadtime:0.07322096824646 / seconds
Query Executed:select id FROM `sd` where city='Canova' && SIC_code='4841'DB:business_master_new
loadtime:0.073897838592529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.07395076751709 / seconds
Query Executed:select id FROM `sd` where city='Canton' && SIC_code='4841'DB:business_master_new
loadtime:0.074633836746216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caputa' limit 1
loadtime:0.074684858322144 / seconds
Query Executed:select id FROM `sd` where city='Caputa' && SIC_code='4841'DB:business_master_new
loadtime:0.075220823287964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carpenter' limit 1
loadtime:0.075270891189575 / seconds
Query Executed:select id FROM `sd` where city='Carpenter' && SIC_code='4841'DB:business_master_new
loadtime:0.075928926467896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carter' limit 1
loadtime:0.075981855392456 / seconds
Query Executed:select id FROM `sd` where city='Carter' && SIC_code='4841'DB:business_master_new
loadtime:0.076365947723389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carthage' limit 1
loadtime:0.076417922973633 / seconds
Query Executed:select id FROM `sd` where city='Carthage' && SIC_code='4841'DB:business_master_new
loadtime:0.077057838439941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castlewood' limit 1
loadtime:0.077108860015869 / seconds
Query Executed:select id FROM `sd` where city='Castlewood' && SIC_code='4841'DB:business_master_new
loadtime:0.077780961990356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cavour' limit 1
loadtime:0.077833890914917 / seconds
Query Executed:select id FROM `sd` where city='Cavour' && SIC_code='4841'DB:business_master_new
loadtime:0.078494787216187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:0.078552961349487 / seconds
Query Executed:select id FROM `sd` where city='Centerville' && SIC_code='4841'DB:business_master_new
loadtime:0.079213857650757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central City' limit 1
loadtime:0.079264879226685 / seconds
Query Executed:select id FROM `sd` where city='Central City' && SIC_code='4841'DB:business_master_new
loadtime:0.079717874526978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chamberlain' limit 1
loadtime:0.079770803451538 / seconds
Query Executed:select id FROM `sd` where city='Chamberlain' && SIC_code='4841'DB:business_master_new
loadtime:0.080434799194336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chancellor' limit 1
loadtime:0.08048677444458 / seconds
Query Executed:select id FROM `sd` where city='Chancellor' && SIC_code='4841'DB:business_master_new
loadtime:0.081157922744751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.081209897994995 / seconds
Query Executed:select id FROM `sd` where city='Chelsea' && SIC_code='4841'DB:business_master_new
loadtime:0.081639766693115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Creek' limit 1
loadtime:0.081691980361938 / seconds
Query Executed:select id FROM `sd` where city='Cherry Creek' && SIC_code='4841'DB:business_master_new
loadtime:0.082167863845825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.082218885421753 / seconds
Query Executed:select id FROM `sd` where city='Chester' && SIC_code='4841'DB:business_master_new
loadtime:0.082887887954712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claire City' limit 1
loadtime:0.082940816879272 / seconds
Query Executed:select id FROM `sd` where city='Claire City' && SIC_code='4841'DB:business_master_new
loadtime:0.083592891693115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:0.083645820617676 / seconds
Query Executed:select id FROM `sd` where city='Claremont' && SIC_code='4841'DB:business_master_new
loadtime:0.084301948547363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clark' limit 1
loadtime:0.084362983703613 / seconds
Query Executed:select id FROM `sd` where city='Clark' && SIC_code='4841'DB:business_master_new
loadtime:0.085034847259521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clear Lake' limit 1
loadtime:0.085101842880249 / seconds
Query Executed:select id FROM `sd` where city='Clear Lake' && SIC_code='4841'DB:business_master_new
loadtime:0.085775852203369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clearfield' limit 1
loadtime:0.08584189414978 / seconds
Query Executed:select id FROM `sd` where city='Clearfield' && SIC_code='4841'DB:business_master_new
loadtime:0.086267948150635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colman' limit 1
loadtime:0.086319923400879 / seconds
Query Executed:select id FROM `sd` where city='Colman' && SIC_code='4841'DB:business_master_new
loadtime:0.087000846862793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colome' limit 1
loadtime:0.087052822113037 / seconds
Query Executed:select id FROM `sd` where city='Colome' && SIC_code='4841'DB:business_master_new
loadtime:0.087717771530151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colton' limit 1
loadtime:0.087769985198975 / seconds
Query Executed:select id FROM `sd` where city='Colton' && SIC_code='4841'DB:business_master_new
loadtime:0.088420867919922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.088472843170166 / seconds
Query Executed:select id FROM `sd` where city='Columbia' && SIC_code='4841'DB:business_master_new
loadtime:0.089140892028809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conde' limit 1
loadtime:0.089227914810181 / seconds
Query Executed:select id FROM `sd` where city='Conde' && SIC_code='4841'DB:business_master_new
loadtime:0.089913845062256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corona' limit 1
loadtime:0.089990854263306 / seconds
Query Executed:select id FROM `sd` where city='Corona' && SIC_code='4841'DB:business_master_new
loadtime:0.090657949447632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corsica' limit 1
loadtime:0.090733766555786 / seconds
Query Executed:select id FROM `sd` where city='Corsica' && SIC_code='4841'DB:business_master_new
loadtime:0.091395854949951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creighton' limit 1
loadtime:0.091472864151001 / seconds
Query Executed:select id FROM `sd` where city='Creighton' && SIC_code='4841'DB:business_master_new
loadtime:0.0918869972229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cresbard' limit 1
loadtime:0.091962814331055 / seconds
Query Executed:select id FROM `sd` where city='Cresbard' && SIC_code='4841'DB:business_master_new
loadtime:0.09265398979187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crocker' limit 1
loadtime:0.092729806900024 / seconds
Query Executed:select id FROM `sd` where city='Crocker' && SIC_code='4841'DB:business_master_new
loadtime:0.093150854110718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crooks' limit 1
loadtime:0.093223810195923 / seconds
Query Executed:select id FROM `sd` where city='Crooks' && SIC_code='4841'DB:business_master_new
loadtime:0.093900918960571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Custer' limit 1
loadtime:0.09397292137146 / seconds
Query Executed:select id FROM `sd` where city='Custer' && SIC_code='4841'DB:business_master_new
loadtime:0.094632863998413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dakota Dunes' limit 1
loadtime:0.094706773757935 / seconds
Query Executed:select id FROM `sd` where city='Dakota Dunes' && SIC_code='4841'DB:business_master_new
loadtime:0.095118999481201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas' limit 1
loadtime:0.095188856124878 / seconds
Query Executed:select id FROM `sd` where city='Dallas' && SIC_code='4841'DB:business_master_new
loadtime:0.095847845077515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dante' limit 1
loadtime:0.09592080116272 / seconds
Query Executed:select id FROM `sd` where city='Dante' && SIC_code='4841'DB:business_master_new
loadtime:0.096589803695679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis' limit 1
loadtime:0.096662998199463 / seconds
Query Executed:select id FROM `sd` where city='Davis' && SIC_code='4841'DB:business_master_new
loadtime:0.097328901290894 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Smet' limit 1
loadtime:0.097412824630737 / seconds
Query Executed:select id FROM `sd` where city='De Smet' && SIC_code='4841'DB:business_master_new
loadtime:0.098105907440186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deadwood' limit 1
loadtime:0.098213911056519 / seconds
Query Executed:select id FROM `sd` where city='Deadwood' && SIC_code='4841'DB:business_master_new
loadtime:0.0988929271698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dell Rapids' limit 1
loadtime:0.098947763442993 / seconds
Query Executed:select id FROM `sd` where city='Dell Rapids' && SIC_code='4841'DB:business_master_new
loadtime:0.099628925323486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delmont' limit 1
loadtime:0.099681854248047 / seconds
Query Executed:select id FROM `sd` where city='Delmont' && SIC_code='4841'DB:business_master_new
loadtime:0.10032296180725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dimock' limit 1
loadtime:0.1003749370575 / seconds
Query Executed:select id FROM `sd` where city='Dimock' && SIC_code='4841'DB:business_master_new
loadtime:0.10102081298828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doland' limit 1
loadtime:0.10107398033142 / seconds
Query Executed:select id FROM `sd` where city='Doland' && SIC_code='4841'DB:business_master_new
loadtime:0.10173082351685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolton' limit 1
loadtime:0.10178399085999 / seconds
Query Executed:select id FROM `sd` where city='Dolton' && SIC_code='4841'DB:business_master_new
loadtime:0.10232496261597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Draper' limit 1
loadtime:0.10237693786621 / seconds
Query Executed:select id FROM `sd` where city='Draper' && SIC_code='4841'DB:business_master_new
loadtime:0.10302877426147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dupree' limit 1
loadtime:0.10308194160461 / seconds
Query Executed:select id FROM `sd` where city='Dupree' && SIC_code='4841'DB:business_master_new
loadtime:0.10372877120972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Butte' limit 1
loadtime:0.10378098487854 / seconds
Query Executed:select id FROM `sd` where city='Eagle Butte' && SIC_code='4841'DB:business_master_new
loadtime:0.10442876815796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.10451292991638 / seconds
Query Executed:select id FROM `sd` where city='Eden' && SIC_code='4841'DB:business_master_new
loadtime:0.10516381263733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgemont' limit 1
loadtime:0.10521578788757 / seconds
Query Executed:select id FROM `sd` where city='Edgemont' && SIC_code='4841'DB:business_master_new
loadtime:0.10587692260742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Egan' limit 1
loadtime:0.10592889785767 / seconds
Query Executed:select id FROM `sd` where city='Egan' && SIC_code='4841'DB:business_master_new
loadtime:0.10657382011414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Point' limit 1
loadtime:0.10663080215454 / seconds
Query Executed:select id FROM `sd` where city='Elk Point' && SIC_code='4841'DB:business_master_new
loadtime:0.10729598999023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkton' limit 1
loadtime:0.10735177993774 / seconds
Query Executed:select id FROM `sd` where city='Elkton' && SIC_code='4841'DB:business_master_new
loadtime:0.10802984237671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth Afb' limit 1
loadtime:0.10808277130127 / seconds
Query Executed:select id FROM `sd` where city='Ellsworth Afb' && SIC_code='4841'DB:business_master_new
loadtime:0.10873889923096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elm Springs' limit 1
loadtime:0.10880589485168 / seconds
Query Executed:select id FROM `sd` where city='Elm Springs' && SIC_code='4841'DB:business_master_new
loadtime:0.10917282104492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emery' limit 1
loadtime:0.10922288894653 / seconds
Query Executed:select id FROM `sd` where city='Emery' && SIC_code='4841'DB:business_master_new
loadtime:0.10987091064453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enning' limit 1
loadtime:0.10992193222046 / seconds
Query Executed:select id FROM `sd` where city='Enning' && SIC_code='4841'DB:business_master_new
loadtime:0.11045980453491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erwin' limit 1
loadtime:0.11051177978516 / seconds
Query Executed:select id FROM `sd` where city='Erwin' && SIC_code='4841'DB:business_master_new
loadtime:0.11116695404053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estelline' limit 1
loadtime:0.11121797561646 / seconds
Query Executed:select id FROM `sd` where city='Estelline' && SIC_code='4841'DB:business_master_new
loadtime:0.11189079284668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ethan' limit 1
loadtime:0.11194181442261 / seconds
Query Executed:select id FROM `sd` where city='Ethan' && SIC_code='4841'DB:business_master_new
loadtime:0.11258578300476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eureka' limit 1
loadtime:0.11264085769653 / seconds
Query Executed:select id FROM `sd` where city='Eureka' && SIC_code='4841'DB:business_master_new
loadtime:0.11326885223389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairburn' limit 1
loadtime:0.1133189201355 / seconds
Query Executed:select id FROM `sd` where city='Fairburn' && SIC_code='4841'DB:business_master_new
loadtime:0.11376595497131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.11381793022156 / seconds
Query Executed:select id FROM `sd` where city='Fairfax' && SIC_code='4841'DB:business_master_new
loadtime:0.11446094512939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:0.11451196670532 / seconds
Query Executed:select id FROM `sd` where city='Fairview' && SIC_code='4841'DB:business_master_new
loadtime:0.11498093605042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faith' limit 1
loadtime:0.11503291130066 / seconds
Query Executed:select id FROM `sd` where city='Faith' && SIC_code='4841'DB:business_master_new
loadtime:0.11568784713745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faulkton' limit 1
loadtime:0.11573886871338 / seconds
Query Executed:select id FROM `sd` where city='Faulkton' && SIC_code='4841'DB:business_master_new
loadtime:0.11638593673706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fedora' limit 1
loadtime:0.11643481254578 / seconds
Query Executed:select id FROM `sd` where city='Fedora' && SIC_code='4841'DB:business_master_new
loadtime:0.11710381507874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferney' limit 1
loadtime:0.11715483665466 / seconds
Query Executed:select id FROM `sd` where city='Ferney' && SIC_code='4841'DB:business_master_new
loadtime:0.11765098571777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Firesteel' limit 1
loadtime:0.11770176887512 / seconds
Query Executed:select id FROM `sd` where city='Firesteel' && SIC_code='4841'DB:business_master_new
loadtime:0.11812281608582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flandreau' limit 1
loadtime:0.11817288398743 / seconds
Query Executed:select id FROM `sd` where city='Flandreau' && SIC_code='4841'DB:business_master_new
loadtime:0.11883878707886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.11888980865479 / seconds
Query Executed:select id FROM `sd` where city='Florence' && SIC_code='4841'DB:business_master_new
loadtime:0.11955189704895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forestburg' limit 1
loadtime:0.11960291862488 / seconds
Query Executed:select id FROM `sd` where city='Forestburg' && SIC_code='4841'DB:business_master_new
loadtime:0.12002682685852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Meade' limit 1
loadtime:0.12007880210876 / seconds
Query Executed:select id FROM `sd` where city='Fort Meade' && SIC_code='4841'DB:business_master_new
loadtime:0.12063980102539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Pierre' limit 1
loadtime:0.12069177627563 / seconds
Query Executed:select id FROM `sd` where city='Fort Pierre' && SIC_code='4841'DB:business_master_new
loadtime:0.12135577201843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Thompson' limit 1
loadtime:0.12141990661621 / seconds
Query Executed:select id FROM `sd` where city='Fort Thompson' && SIC_code='4841'DB:business_master_new
loadtime:0.12207698822021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frankfort' limit 1
loadtime:0.12213087081909 / seconds
Query Executed:select id FROM `sd` where city='Frankfort' && SIC_code='4841'DB:business_master_new
loadtime:0.12277579307556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frederick' limit 1
loadtime:0.12282776832581 / seconds
Query Executed:select id FROM `sd` where city='Frederick' && SIC_code='4841'DB:business_master_new
loadtime:0.12347888946533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeman' limit 1
loadtime:0.12352991104126 / seconds
Query Executed:select id FROM `sd` where city='Freeman' && SIC_code='4841'DB:business_master_new
loadtime:0.12417078018188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitdale' limit 1
loadtime:0.12422180175781 / seconds
Query Executed:select id FROM `sd` where city='Fruitdale' && SIC_code='4841'DB:business_master_new
loadtime:0.12457895278931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fulton' limit 1
loadtime:0.1246337890625 / seconds
Query Executed:select id FROM `sd` where city='Fulton' && SIC_code='4841'DB:business_master_new
loadtime:0.12525987625122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gann Valley' limit 1
loadtime:0.12530994415283 / seconds
Query Executed:select id FROM `sd` where city='Gann Valley' && SIC_code='4841'DB:business_master_new
loadtime:0.12596392631531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden City' limit 1
loadtime:0.1260199546814 / seconds
Query Executed:select id FROM `sd` where city='Garden City' && SIC_code='4841'DB:business_master_new
loadtime:0.12667894363403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garretson' limit 1
loadtime:0.12673091888428 / seconds
Query Executed:select id FROM `sd` where city='Garretson' && SIC_code='4841'DB:business_master_new
loadtime:0.12739086151123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gary' limit 1
loadtime:0.12744998931885 / seconds
Query Executed:select id FROM `sd` where city='Gary' && SIC_code='4841'DB:business_master_new
loadtime:0.12810778617859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gayville' limit 1
loadtime:0.12815880775452 / seconds
Query Executed:select id FROM `sd` where city='Gayville' && SIC_code='4841'DB:business_master_new
loadtime:0.12882280349731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Geddes' limit 1
loadtime:0.12887477874756 / seconds
Query Executed:select id FROM `sd` where city='Geddes' && SIC_code='4841'DB:business_master_new
loadtime:0.12952184677124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gettysburg' limit 1
loadtime:0.12957286834717 / seconds
Query Executed:select id FROM `sd` where city='Gettysburg' && SIC_code='4841'DB:business_master_new
loadtime:0.13020992279053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glad Valley' limit 1
loadtime:0.13026094436646 / seconds
Query Executed:select id FROM `sd` where city='Glad Valley' && SIC_code='4841'DB:business_master_new
loadtime:0.13065981864929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glencross' limit 1
loadtime:0.13071084022522 / seconds
Query Executed:select id FROM `sd` where city='Glencross' && SIC_code='4841'DB:business_master_new
loadtime:0.1311309337616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenham' limit 1
loadtime:0.13118076324463 / seconds
Query Executed:select id FROM `sd` where city='Glenham' && SIC_code='4841'DB:business_master_new
loadtime:0.13183879852295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodwin' limit 1
loadtime:0.13189077377319 / seconds
Query Executed:select id FROM `sd` where city='Goodwin' && SIC_code='4841'DB:business_master_new
loadtime:0.13253378868103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gregory' limit 1
loadtime:0.13258481025696 / seconds
Query Executed:select id FROM `sd` where city='Gregory' && SIC_code='4841'DB:business_master_new
loadtime:0.13321876525879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grenville' limit 1
loadtime:0.13326978683472 / seconds
Query Executed:select id FROM `sd` where city='Grenville' && SIC_code='4841'DB:business_master_new
loadtime:0.13393187522888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.13398480415344 / seconds
Query Executed:select id FROM `sd` where city='Groton' && SIC_code='4841'DB:business_master_new
loadtime:0.13465785980225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamill' limit 1
loadtime:0.13470983505249 / seconds
Query Executed:select id FROM `sd` where city='Hamill' && SIC_code='4841'DB:business_master_new
loadtime:0.13534688949585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisburg' limit 1
loadtime:0.13539695739746 / seconds
Query Executed:select id FROM `sd` where city='Harrisburg' && SIC_code='4841'DB:business_master_new
loadtime:0.13601398468018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrison' limit 1
loadtime:0.13606595993042 / seconds
Query Executed:select id FROM `sd` where city='Harrison' && SIC_code='4841'DB:business_master_new
loadtime:0.13668894767761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrold' limit 1
loadtime:0.13673996925354 / seconds
Query Executed:select id FROM `sd` where city='Harrold' && SIC_code='4841'DB:business_master_new
loadtime:0.1373507976532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.13740086555481 / seconds
Query Executed:select id FROM `sd` where city='Hartford' && SIC_code='4841'DB:business_master_new
loadtime:0.13801789283752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayes' limit 1
loadtime:0.13806891441345 / seconds
Query Executed:select id FROM `sd` where city='Hayes' && SIC_code='4841'DB:business_master_new
loadtime:0.13869976997375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayti' limit 1
loadtime:0.13875293731689 / seconds
Query Executed:select id FROM `sd` where city='Hayti' && SIC_code='4841'DB:business_master_new
loadtime:0.13938999176025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazel' limit 1
loadtime:0.13944792747498 / seconds
Query Executed:select id FROM `sd` where city='Hazel' && SIC_code='4841'DB:business_master_new
loadtime:0.14009094238281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hecla' limit 1
loadtime:0.14014291763306 / seconds
Query Executed:select id FROM `sd` where city='Hecla' && SIC_code='4841'DB:business_master_new
loadtime:0.14078783988953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henry' limit 1
loadtime:0.14083981513977 / seconds
Query Executed:select id FROM `sd` where city='Henry' && SIC_code='4841'DB:business_master_new
loadtime:0.14149594306946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hermosa' limit 1
loadtime:0.14154577255249 / seconds
Query Executed:select id FROM `sd` where city='Hermosa' && SIC_code='4841'DB:business_master_new
loadtime:0.1421959400177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herreid' limit 1
loadtime:0.14224696159363 / seconds
Query Executed:select id FROM `sd` where city='Herreid' && SIC_code='4841'DB:business_master_new
loadtime:0.14289379119873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herrick' limit 1
loadtime:0.14294576644897 / seconds
Query Executed:select id FROM `sd` where city='Herrick' && SIC_code='4841'DB:business_master_new
loadtime:0.1435809135437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hetland' limit 1
loadtime:0.14363694190979 / seconds
Query Executed:select id FROM `sd` where city='Hetland' && SIC_code='4841'DB:business_master_new
loadtime:0.14401292800903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highmore' limit 1
loadtime:0.14406394958496 / seconds
Query Executed:select id FROM `sd` where city='Highmore' && SIC_code='4841'DB:business_master_new
loadtime:0.14471983909607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hill City' limit 1
loadtime:0.14477181434631 / seconds
Query Executed:select id FROM `sd` where city='Hill City' && SIC_code='4841'DB:business_master_new
loadtime:0.14540076255798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hitchcock' limit 1
loadtime:0.14545893669128 / seconds
Query Executed:select id FROM `sd` where city='Hitchcock' && SIC_code='4841'DB:business_master_new
loadtime:0.14608383178711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holabird' limit 1
loadtime:0.14613580703735 / seconds
Query Executed:select id FROM `sd` where city='Holabird' && SIC_code='4841'DB:business_master_new
loadtime:0.14676976203918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hosmer' limit 1
loadtime:0.14682078361511 / seconds
Query Executed:select id FROM `sd` where city='Hosmer' && SIC_code='4841'DB:business_master_new
loadtime:0.14743494987488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hot Springs' limit 1
loadtime:0.14749383926392 / seconds
Query Executed:select id FROM `sd` where city='Hot Springs' && SIC_code='4841'DB:business_master_new
loadtime:0.14814186096191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houghton' limit 1
loadtime:0.14819383621216 / seconds
Query Executed:select id FROM `sd` where city='Houghton' && SIC_code='4841'DB:business_master_new
loadtime:0.14886784553528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoven' limit 1
loadtime:0.14891886711121 / seconds
Query Executed:select id FROM `sd` where city='Hoven' && SIC_code='4841'DB:business_master_new
loadtime:0.149582862854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howard' limit 1
loadtime:0.14963984489441 / seconds
Query Executed:select id FROM `sd` where city='Howard' && SIC_code='4841'DB:business_master_new
loadtime:0.1502947807312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howes' limit 1
loadtime:0.15034580230713 / seconds
Query Executed:select id FROM `sd` where city='Howes' && SIC_code='4841'DB:business_master_new
loadtime:0.15091395378113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:0.15096497535706 / seconds
Query Executed:select id FROM `sd` where city='Hudson' && SIC_code='4841'DB:business_master_new
loadtime:0.15162587165833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humboldt' limit 1
loadtime:0.15167880058289 / seconds
Query Executed:select id FROM `sd` where city='Humboldt' && SIC_code='4841'DB:business_master_new
loadtime:0.15232682228088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:0.15237593650818 / seconds
Query Executed:select id FROM `sd` where city='Hurley' && SIC_code='4841'DB:business_master_new
loadtime:0.15304589271545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huron' limit 1
loadtime:0.15309691429138 / seconds
Query Executed:select id FROM `sd` where city='Huron' && SIC_code='4841'DB:business_master_new
loadtime:0.1537618637085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ideal' limit 1
loadtime:0.15382790565491 / seconds
Query Executed:select id FROM `sd` where city='Ideal' && SIC_code='4841'DB:business_master_new
loadtime:0.1543128490448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Igloo' limit 1
loadtime:0.15436291694641 / seconds
Query Executed:select id FROM `sd` where city='Igloo' && SIC_code='4841'DB:business_master_new
loadtime:0.15478277206421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Interior' limit 1
loadtime:0.15483379364014 / seconds
Query Executed:select id FROM `sd` where city='Interior' && SIC_code='4841'DB:business_master_new
loadtime:0.15561580657959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ipswich' limit 1
loadtime:0.15566992759705 / seconds
Query Executed:select id FROM `sd` where city='Ipswich' && SIC_code='4841'DB:business_master_new
loadtime:0.15631580352783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irene' limit 1
loadtime:0.15636587142944 / seconds
Query Executed:select id FROM `sd` where city='Irene' && SIC_code='4841'DB:business_master_new
loadtime:0.1570188999176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iroquois' limit 1
loadtime:0.15707087516785 / seconds
Query Executed:select id FROM `sd` where city='Iroquois' && SIC_code='4841'DB:business_master_new
loadtime:0.15772986412048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isabel' limit 1
loadtime:0.15778183937073 / seconds
Query Executed:select id FROM `sd` where city='Isabel' && SIC_code='4841'DB:business_master_new
loadtime:0.15842199325562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Java' limit 1
loadtime:0.15848088264465 / seconds
Query Executed:select id FROM `sd` where city='Java' && SIC_code='4841'DB:business_master_new
loadtime:0.15921783447266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:0.1592698097229 / seconds
Query Executed:select id FROM `sd` where city='Jefferson' && SIC_code='4841'DB:business_master_new
loadtime:0.15993785858154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kadoka' limit 1
loadtime:0.15998983383179 / seconds
Query Executed:select id FROM `sd` where city='Kadoka' && SIC_code='4841'DB:business_master_new
loadtime:0.16064977645874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaylor' limit 1
loadtime:0.16070199012756 / seconds
Query Executed:select id FROM `sd` where city='Kaylor' && SIC_code='4841'DB:business_master_new
loadtime:0.16122579574585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keldron' limit 1
loadtime:0.16127586364746 / seconds
Query Executed:select id FROM `sd` where city='Keldron' && SIC_code='4841'DB:business_master_new
loadtime:0.16180777549744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kennebec' limit 1
loadtime:0.16185879707336 / seconds
Query Executed:select id FROM `sd` where city='Kennebec' && SIC_code='4841'DB:business_master_new
loadtime:0.16252088546753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keystone' limit 1
loadtime:0.1625919342041 / seconds
Query Executed:select id FROM `sd` where city='Keystone' && SIC_code='4841'DB:business_master_new
loadtime:0.16323590278625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kimball' limit 1
loadtime:0.16328978538513 / seconds
Query Executed:select id FROM `sd` where city='Kimball' && SIC_code='4841'DB:business_master_new
loadtime:0.16393280029297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kranzburg' limit 1
loadtime:0.16398596763611 / seconds
Query Executed:select id FROM `sd` where city='Kranzburg' && SIC_code='4841'DB:business_master_new
loadtime:0.16450476646423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kyle' limit 1
loadtime:0.16455578804016 / seconds
Query Executed:select id FROM `sd` where city='Kyle' && SIC_code='4841'DB:business_master_new
loadtime:0.16519689559937 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Plant' limit 1
loadtime:0.16524791717529 / seconds
Query Executed:select id FROM `sd` where city='La Plant' && SIC_code='4841'DB:business_master_new
loadtime:0.16571283340454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Labolt' limit 1
loadtime:0.16576480865479 / seconds
Query Executed:select id FROM `sd` where city='Labolt' && SIC_code='4841'DB:business_master_new
loadtime:0.1663179397583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Andes' limit 1
loadtime:0.16636896133423 / seconds
Query Executed:select id FROM `sd` where city='Lake Andes' && SIC_code='4841'DB:business_master_new
loadtime:0.16704797744751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake City' limit 1
loadtime:0.16709995269775 / seconds
Query Executed:select id FROM `sd` where city='Lake City' && SIC_code='4841'DB:business_master_new
loadtime:0.16768479347229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Norden' limit 1
loadtime:0.16773676872253 / seconds
Query Executed:select id FROM `sd` where city='Lake Norden' && SIC_code='4841'DB:business_master_new
loadtime:0.16839981079102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Preston' limit 1
loadtime:0.16845893859863 / seconds
Query Executed:select id FROM `sd` where city='Lake Preston' && SIC_code='4841'DB:business_master_new
loadtime:0.16910696029663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lane' limit 1
loadtime:0.16915798187256 / seconds
Query Executed:select id FROM `sd` where city='Lane' && SIC_code='4841'DB:business_master_new
loadtime:0.16957092285156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langford' limit 1
loadtime:0.16962885856628 / seconds
Query Executed:select id FROM `sd` where city='Langford' && SIC_code='4841'DB:business_master_new
loadtime:0.17026782035828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lantry' limit 1
loadtime:0.1703188419342 / seconds
Query Executed:select id FROM `sd` where city='Lantry' && SIC_code='4841'DB:business_master_new
loadtime:0.17079782485962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lead' limit 1
loadtime:0.17084980010986 / seconds
Query Executed:select id FROM `sd` where city='Lead' && SIC_code='4841'DB:business_master_new
loadtime:0.17151498794556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:0.17156577110291 / seconds
Query Executed:select id FROM `sd` where city='Lebanon' && SIC_code='4841'DB:business_master_new
loadtime:0.17222595214844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemmon' limit 1
loadtime:0.17227792739868 / seconds
Query Executed:select id FROM `sd` where city='Lemmon' && SIC_code='4841'DB:business_master_new
loadtime:0.172926902771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lennox' limit 1
loadtime:0.17297792434692 / seconds
Query Executed:select id FROM `sd` where city='Lennox' && SIC_code='4841'DB:business_master_new
loadtime:0.17365097999573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leola' limit 1
loadtime:0.17370295524597 / seconds
Query Executed:select id FROM `sd` where city='Leola' && SIC_code='4841'DB:business_master_new
loadtime:0.17436099052429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lesterville' limit 1
loadtime:0.17441082000732 / seconds
Query Executed:select id FROM `sd` where city='Lesterville' && SIC_code='4841'DB:business_master_new
loadtime:0.1750807762146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Letcher' limit 1
loadtime:0.17513298988342 / seconds
Query Executed:select id FROM `sd` where city='Letcher' && SIC_code='4841'DB:business_master_new
loadtime:0.17579889297485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Eagle' limit 1
loadtime:0.1758508682251 / seconds
Query Executed:select id FROM `sd` where city='Little Eagle' && SIC_code='4841'DB:business_master_new
loadtime:0.17630076408386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lodgepole' limit 1
loadtime:0.17635178565979 / seconds
Query Executed:select id FROM `sd` where city='Lodgepole' && SIC_code='4841'DB:business_master_new
loadtime:0.17688989639282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Valley' limit 1
loadtime:0.17694187164307 / seconds
Query Executed:select id FROM `sd` where city='Long Valley' && SIC_code='4841'DB:business_master_new
loadtime:0.17748284339905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longlake' limit 1
loadtime:0.17753386497498 / seconds
Query Executed:select id FROM `sd` where city='Longlake' && SIC_code='4841'DB:business_master_new
loadtime:0.1779317855835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longvalley' limit 1
loadtime:0.17798399925232 / seconds
Query Executed:select id FROM `sd` where city='Longvalley' && SIC_code='4841'DB:business_master_new
loadtime:0.17840385437012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lower Brule' limit 1
loadtime:0.17846393585205 / seconds
Query Executed:select id FROM `sd` where city='Lower Brule' && SIC_code='4841'DB:business_master_new
loadtime:0.179123878479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowry' limit 1
loadtime:0.17917490005493 / seconds
Query Executed:select id FROM `sd` where city='Lowry' && SIC_code='4841'DB:business_master_new
loadtime:0.17955899238586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:0.17961287498474 / seconds
Query Executed:select id FROM `sd` where city='Ludlow' && SIC_code='4841'DB:business_master_new
loadtime:0.18016481399536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyons' limit 1
loadtime:0.18021583557129 / seconds
Query Executed:select id FROM `sd` where city='Lyons' && SIC_code='4841'DB:business_master_new
loadtime:0.18076491355896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.1808168888092 / seconds
Query Executed:select id FROM `sd` where city='Madison' && SIC_code='4841'DB:business_master_new
loadtime:0.18146777153015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manderson' limit 1
loadtime:0.18151998519897 / seconds
Query Executed:select id FROM `sd` where city='Manderson' && SIC_code='4841'DB:business_master_new
loadtime:0.18206787109375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield' limit 1
loadtime:0.18211984634399 / seconds
Query Executed:select id FROM `sd` where city='Mansfield' && SIC_code='4841'DB:business_master_new
loadtime:0.18286180496216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.18291282653809 / seconds
Query Executed:select id FROM `sd` where city='Marion' && SIC_code='4841'DB:business_master_new
loadtime:0.18356990814209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martin' limit 1
loadtime:0.18362593650818 / seconds
Query Executed:select id FROM `sd` where city='Martin' && SIC_code='4841'DB:business_master_new
loadtime:0.18427491188049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marty' limit 1
loadtime:0.1843249797821 / seconds
Query Executed:select id FROM `sd` where city='Marty' && SIC_code='4841'DB:business_master_new
loadtime:0.18492794036865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marvin' limit 1
loadtime:0.1849799156189 / seconds
Query Executed:select id FROM `sd` where city='Marvin' && SIC_code='4841'DB:business_master_new
loadtime:0.18546295166016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Intosh' limit 1
loadtime:0.18551588058472 / seconds
Query Executed:select id FROM `sd` where city='Mc Intosh' && SIC_code='4841'DB:business_master_new
loadtime:0.1861629486084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Laughlin' limit 1
loadtime:0.18621492385864 / seconds
Query Executed:select id FROM `sd` where city='Mc Laughlin' && SIC_code='4841'DB:business_master_new
loadtime:0.18688678741455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadow' limit 1
loadtime:0.18693876266479 / seconds
Query Executed:select id FROM `sd` where city='Meadow' && SIC_code='4841'DB:business_master_new
loadtime:0.18775391578674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meckling' limit 1
loadtime:0.18780589103699 / seconds
Query Executed:select id FROM `sd` where city='Meckling' && SIC_code='4841'DB:business_master_new
loadtime:0.18820476531982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mellette' limit 1
loadtime:0.18825578689575 / seconds
Query Executed:select id FROM `sd` where city='Mellette' && SIC_code='4841'DB:business_master_new
loadtime:0.18891096115112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menno' limit 1
loadtime:0.18896293640137 / seconds
Query Executed:select id FROM `sd` where city='Menno' && SIC_code='4841'DB:business_master_new
loadtime:0.18962979316711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland' limit 1
loadtime:0.18968176841736 / seconds
Query Executed:select id FROM `sd` where city='Midland' && SIC_code='4841'DB:business_master_new
loadtime:0.19034194946289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milbank' limit 1
loadtime:0.19039177894592 / seconds
Query Executed:select id FROM `sd` where city='Milbank' && SIC_code='4841'DB:business_master_new
loadtime:0.19107389450073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milesville' limit 1
loadtime:0.19114184379578 / seconds
Query Executed:select id FROM `sd` where city='Milesville' && SIC_code='4841'DB:business_master_new
loadtime:0.19175982475281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miller' limit 1
loadtime:0.19181299209595 / seconds
Query Executed:select id FROM `sd` where city='Miller' && SIC_code='4841'DB:business_master_new
loadtime:0.1924889087677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mina' limit 1
loadtime:0.19253993034363 / seconds
Query Executed:select id FROM `sd` where city='Mina' && SIC_code='4841'DB:business_master_new
loadtime:0.19297695159912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miranda' limit 1
loadtime:0.19302797317505 / seconds
Query Executed:select id FROM `sd` where city='Miranda' && SIC_code='4841'DB:business_master_new
loadtime:0.19341897964478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mission' limit 1
loadtime:0.19347786903381 / seconds
Query Executed:select id FROM `sd` where city='Mission' && SIC_code='4841'DB:business_master_new
loadtime:0.19414281845093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mission Hill' limit 1
loadtime:0.19419384002686 / seconds
Query Executed:select id FROM `sd` where city='Mission Hill' && SIC_code='4841'DB:business_master_new
loadtime:0.19488382339478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchell' limit 1
loadtime:0.19493579864502 / seconds
Query Executed:select id FROM `sd` where city='Mitchell' && SIC_code='4841'DB:business_master_new
loadtime:0.19561791419983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mobridge' limit 1
loadtime:0.19568777084351 / seconds
Query Executed:select id FROM `sd` where city='Mobridge' && SIC_code='4841'DB:business_master_new
loadtime:0.19635081291199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.19640278816223 / seconds
Query Executed:select id FROM `sd` where city='Monroe' && SIC_code='4841'DB:business_master_new
loadtime:0.19707989692688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montrose' limit 1
loadtime:0.19713187217712 / seconds
Query Executed:select id FROM `sd` where city='Montrose' && SIC_code='4841'DB:business_master_new
loadtime:0.19780898094177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morristown' limit 1
loadtime:0.19786095619202 / seconds
Query Executed:select id FROM `sd` where city='Morristown' && SIC_code='4841'DB:business_master_new
loadtime:0.19847083091736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mound City' limit 1
loadtime:0.1985228061676 / seconds
Query Executed:select id FROM `sd` where city='Mound City' && SIC_code='4841'DB:business_master_new
loadtime:0.19918179512024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Vernon' limit 1
loadtime:0.19923377037048 / seconds
Query Executed:select id FROM `sd` where city='Mount Vernon' && SIC_code='4841'DB:business_master_new
loadtime:0.19990181922913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Vernon' limit 1
loadtime:0.19995284080505 / seconds
Query Executed:select id FROM `sd` where city='Mt Vernon' && SIC_code='4841'DB:business_master_new
loadtime:0.20035696029663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mud Butte' limit 1
loadtime:0.20040678977966 / seconds
Query Executed:select id FROM `sd` where city='Mud Butte' && SIC_code='4841'DB:business_master_new
loadtime:0.20091676712036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murdo' limit 1
loadtime:0.20096898078918 / seconds
Query Executed:select id FROM `sd` where city='Murdo' && SIC_code='4841'DB:business_master_new
loadtime:0.20163083076477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nemo' limit 1
loadtime:0.20168280601501 / seconds
Query Executed:select id FROM `sd` where city='Nemo' && SIC_code='4841'DB:business_master_new
loadtime:0.20222187042236 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Effington' limit 1
loadtime:0.20227289199829 / seconds
Query Executed:select id FROM `sd` where city='New Effington' && SIC_code='4841'DB:business_master_new
loadtime:0.20294785499573 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Holland' limit 1
loadtime:0.20299983024597 / seconds
Query Executed:select id FROM `sd` where city='New Holland' && SIC_code='4841'DB:business_master_new
loadtime:0.20359086990356 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Underwood' limit 1
loadtime:0.20364785194397 / seconds
Query Executed:select id FROM `sd` where city='New Underwood' && SIC_code='4841'DB:business_master_new
loadtime:0.20431184768677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newell' limit 1
loadtime:0.2043628692627 / seconds
Query Executed:select id FROM `sd` where city='Newell' && SIC_code='4841'DB:business_master_new
loadtime:0.20503878593445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nisland' limit 1
loadtime:0.20509195327759 / seconds
Query Executed:select id FROM `sd` where city='Nisland' && SIC_code='4841'DB:business_master_new
loadtime:0.20577192306519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norris' limit 1
loadtime:0.20582389831543 / seconds
Query Executed:select id FROM `sd` where city='Norris' && SIC_code='4841'DB:business_master_new
loadtime:0.20637083053589 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Sioux City' limit 1
loadtime:0.2064208984375 / seconds
Query Executed:select id FROM `sd` where city='North Sioux City' && SIC_code='4841'DB:business_master_new
loadtime:0.20708990097046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northville' limit 1
loadtime:0.2071418762207 / seconds
Query Executed:select id FROM `sd` where city='Northville' && SIC_code='4841'DB:business_master_new
loadtime:0.20794987678528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nunda' limit 1
loadtime:0.20800185203552 / seconds
Query Executed:select id FROM `sd` where city='Nunda' && SIC_code='4841'DB:business_master_new
loadtime:0.20863795280457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oacoma' limit 1
loadtime:0.20868992805481 / seconds
Query Executed:select id FROM `sd` where city='Oacoma' && SIC_code='4841'DB:business_master_new
loadtime:0.2094988822937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oelrichs' limit 1
loadtime:0.20955085754395 / seconds
Query Executed:select id FROM `sd` where city='Oelrichs' && SIC_code='4841'DB:business_master_new
loadtime:0.21021699905396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oglala' limit 1
loadtime:0.2102689743042 / seconds
Query Executed:select id FROM `sd` where city='Oglala' && SIC_code='4841'DB:business_master_new
loadtime:0.21084380149841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okaton' limit 1
loadtime:0.21089577674866 / seconds
Query Executed:select id FROM `sd` where city='Okaton' && SIC_code='4841'DB:business_master_new
loadtime:0.21133589744568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okreek' limit 1
loadtime:0.21138596534729 / seconds
Query Executed:select id FROM `sd` where city='Okreek' && SIC_code='4841'DB:business_master_new
loadtime:0.21181082725525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oldham' limit 1
loadtime:0.21186184883118 / seconds
Query Executed:select id FROM `sd` where city='Oldham' && SIC_code='4841'DB:business_master_new
loadtime:0.21251797676086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olivet' limit 1
loadtime:0.21258282661438 / seconds
Query Executed:select id FROM `sd` where city='Olivet' && SIC_code='4841'DB:business_master_new
loadtime:0.21322298049927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onaka' limit 1
loadtime:0.21327590942383 / seconds
Query Executed:select id FROM `sd` where city='Onaka' && SIC_code='4841'DB:business_master_new
loadtime:0.21391487121582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onida' limit 1
loadtime:0.21396780014038 / seconds
Query Executed:select id FROM `sd` where city='Onida' && SIC_code='4841'DB:business_master_new
loadtime:0.21460890769958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Opal' limit 1
loadtime:0.21467876434326 / seconds
Query Executed:select id FROM `sd` where city='Opal' && SIC_code='4841'DB:business_master_new
loadtime:0.21505093574524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oral' limit 1
loadtime:0.21510195732117 / seconds
Query Executed:select id FROM `sd` where city='Oral' && SIC_code='4841'DB:business_master_new
loadtime:0.21565580368042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orient' limit 1
loadtime:0.21570777893066 / seconds
Query Executed:select id FROM `sd` where city='Orient' && SIC_code='4841'DB:business_master_new
loadtime:0.21634984016418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ortley' limit 1
loadtime:0.2163999080658 / seconds
Query Executed:select id FROM `sd` where city='Ortley' && SIC_code='4841'DB:business_master_new
loadtime:0.21690988540649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Owanka' limit 1
loadtime:0.21696090698242 / seconds
Query Executed:select id FROM `sd` where city='Owanka' && SIC_code='4841'DB:business_master_new
loadtime:0.21746397018433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parker' limit 1
loadtime:0.21751499176025 / seconds
Query Executed:select id FROM `sd` where city='Parker' && SIC_code='4841'DB:business_master_new
loadtime:0.21816182136536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parkston' limit 1
loadtime:0.2182137966156 / seconds
Query Executed:select id FROM `sd` where city='Parkston' && SIC_code='4841'DB:business_master_new
loadtime:0.21888089179993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parmelee' limit 1
loadtime:0.21893191337585 / seconds
Query Executed:select id FROM `sd` where city='Parmelee' && SIC_code='4841'DB:business_master_new
loadtime:0.21953892707825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peever' limit 1
loadtime:0.21958994865417 / seconds
Query Executed:select id FROM `sd` where city='Peever' && SIC_code='4841'DB:business_master_new
loadtime:0.22031879425049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Philip' limit 1
loadtime:0.22037196159363 / seconds
Query Executed:select id FROM `sd` where city='Philip' && SIC_code='4841'DB:business_master_new
loadtime:0.22101879119873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickstown' limit 1
loadtime:0.22107076644897 / seconds
Query Executed:select id FROM `sd` where city='Pickstown' && SIC_code='4841'DB:business_master_new
loadtime:0.22186493873596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piedmont' limit 1
loadtime:0.22191786766052 / seconds
Query Executed:select id FROM `sd` where city='Piedmont' && SIC_code='4841'DB:business_master_new
loadtime:0.22258186340332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierpont' limit 1
loadtime:0.22263789176941 / seconds
Query Executed:select id FROM `sd` where city='Pierpont' && SIC_code='4841'DB:business_master_new
loadtime:0.22326278686523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierre' limit 1
loadtime:0.22331285476685 / seconds
Query Executed:select id FROM `sd` where city='Pierre' && SIC_code='4841'DB:business_master_new
loadtime:0.22400784492493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Ridge' limit 1
loadtime:0.22407293319702 / seconds
Query Executed:select id FROM `sd` where city='Pine Ridge' && SIC_code='4841'DB:business_master_new
loadtime:0.22475695610046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plankinton' limit 1
loadtime:0.22482490539551 / seconds
Query Executed:select id FROM `sd` where city='Plankinton' && SIC_code='4841'DB:business_master_new
loadtime:0.22547698020935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Platte' limit 1
loadtime:0.22552895545959 / seconds
Query Executed:select id FROM `sd` where city='Platte' && SIC_code='4841'DB:business_master_new
loadtime:0.22618079185486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pollock' limit 1
loadtime:0.2262327671051 / seconds
Query Executed:select id FROM `sd` where city='Pollock' && SIC_code='4841'DB:business_master_new
loadtime:0.22691082954407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Porcupine' limit 1
loadtime:0.22696280479431 / seconds
Query Executed:select id FROM `sd` where city='Porcupine' && SIC_code='4841'DB:business_master_new
loadtime:0.22778797149658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie City' limit 1
loadtime:0.22783994674683 / seconds
Query Executed:select id FROM `sd` where city='Prairie City' && SIC_code='4841'DB:business_master_new
loadtime:0.22855281829834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Presho' limit 1
loadtime:0.22860383987427 / seconds
Query Executed:select id FROM `sd` where city='Presho' && SIC_code='4841'DB:business_master_new
loadtime:0.22925186157227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pringle' limit 1
loadtime:0.22930288314819 / seconds
Query Executed:select id FROM `sd` where city='Pringle' && SIC_code='4841'DB:business_master_new
loadtime:0.22988677024841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pukwana' limit 1
loadtime:0.22993993759155 / seconds
Query Executed:select id FROM `sd` where city='Pukwana' && SIC_code='4841'DB:business_master_new
loadtime:0.23060488700867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinn' limit 1
loadtime:0.2306649684906 / seconds
Query Executed:select id FROM `sd` where city='Quinn' && SIC_code='4841'DB:business_master_new
loadtime:0.23122191429138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ralph' limit 1
loadtime:0.23127293586731 / seconds
Query Executed:select id FROM `sd` where city='Ralph' && SIC_code='4841'DB:business_master_new
loadtime:0.23175883293152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramona' limit 1
loadtime:0.23181080818176 / seconds
Query Executed:select id FROM `sd` where city='Ramona' && SIC_code='4841'DB:business_master_new
loadtime:0.23273992538452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rapid City' limit 1
loadtime:0.23279285430908 / seconds
Query Executed:select id FROM `sd` where city='Rapid City' && SIC_code='4841'DB:business_master_new
loadtime:0.23345398902893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ravinia' limit 1
loadtime:0.23351979255676 / seconds
Query Executed:select id FROM `sd` where city='Ravinia' && SIC_code='4841'DB:business_master_new
loadtime:0.23390889167786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:0.2339608669281 / seconds
Query Executed:select id FROM `sd` where city='Raymond' && SIC_code='4841'DB:business_master_new
loadtime:0.23461198806763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Owl' limit 1
loadtime:0.23466682434082 / seconds
Query Executed:select id FROM `sd` where city='Red Owl' && SIC_code='4841'DB:business_master_new
loadtime:0.23504781723022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redfield' limit 1
loadtime:0.23509883880615 / seconds
Query Executed:select id FROM `sd` where city='Redfield' && SIC_code='4841'DB:business_master_new
loadtime:0.23577380180359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redig' limit 1
loadtime:0.23582696914673 / seconds
Query Executed:select id FROM `sd` where city='Redig' && SIC_code='4841'DB:business_master_new
loadtime:0.23629593849182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ree Heights' limit 1
loadtime:0.23634576797485 / seconds
Query Executed:select id FROM `sd` where city='Ree Heights' && SIC_code='4841'DB:business_master_new
loadtime:0.2371039390564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reliance' limit 1
loadtime:0.23715591430664 / seconds
Query Executed:select id FROM `sd` where city='Reliance' && SIC_code='4841'DB:business_master_new
loadtime:0.23783993721008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Renner' limit 1
loadtime:0.23789286613464 / seconds
Query Executed:select id FROM `sd` where city='Renner' && SIC_code='4841'DB:business_master_new
loadtime:0.23855590820312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reva' limit 1
loadtime:0.238609790802 / seconds
Query Executed:select id FROM `sd` where city='Reva' && SIC_code='4841'DB:business_master_new
loadtime:0.2392418384552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Revillo' limit 1
loadtime:0.23929286003113 / seconds
Query Executed:select id FROM `sd` where city='Revillo' && SIC_code='4841'DB:business_master_new
loadtime:0.23996090888977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeview' limit 1
loadtime:0.2400119304657 / seconds
Query Executed:select id FROM `sd` where city='Ridgeview' && SIC_code='4841'DB:business_master_new
loadtime:0.24049496650696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockham' limit 1
loadtime:0.24054598808289 / seconds
Query Executed:select id FROM `sd` where city='Rockham' && SIC_code='4841'DB:business_master_new
loadtime:0.24109888076782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roscoe' limit 1
loadtime:0.24114990234375 / seconds
Query Executed:select id FROM `sd` where city='Roscoe' && SIC_code='4841'DB:business_master_new
loadtime:0.24182391166687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosebud' limit 1
loadtime:0.24187588691711 / seconds
Query Executed:select id FROM `sd` where city='Rosebud' && SIC_code='4841'DB:business_master_new
loadtime:0.24255585670471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosholt' limit 1
loadtime:0.24260878562927 / seconds
Query Executed:select id FROM `sd` where city='Rosholt' && SIC_code='4841'DB:business_master_new
loadtime:0.24327278137207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roslyn' limit 1
loadtime:0.243323802948 / seconds
Query Executed:select id FROM `sd` where city='Roslyn' && SIC_code='4841'DB:business_master_new
loadtime:0.24399280548096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowena' limit 1
loadtime:0.2440459728241 / seconds
Query Executed:select id FROM `sd` where city='Rowena' && SIC_code='4841'DB:business_master_new
loadtime:0.24448895454407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:0.24454092979431 / seconds
Query Executed:select id FROM `sd` where city='Rutland' && SIC_code='4841'DB:business_master_new
loadtime:0.24510383605957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Charles' limit 1
loadtime:0.24515581130981 / seconds
Query Executed:select id FROM `sd` where city='Saint Charles' && SIC_code='4841'DB:business_master_new
loadtime:0.24562692642212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Francis' limit 1
loadtime:0.24567890167236 / seconds
Query Executed:select id FROM `sd` where city='Saint Francis' && SIC_code='4841'DB:business_master_new
loadtime:0.24643683433533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Lawrence' limit 1
loadtime:0.24649691581726 / seconds
Query Executed:select id FROM `sd` where city='Saint Lawrence' && SIC_code='4841'DB:business_master_new
loadtime:0.24730396270752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Onge' limit 1
loadtime:0.24735593795776 / seconds
Query Executed:select id FROM `sd` where city='Saint Onge' && SIC_code='4841'DB:business_master_new
loadtime:0.24794793128967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.24800086021423 / seconds
Query Executed:select id FROM `sd` where city='Salem' && SIC_code='4841'DB:business_master_new
loadtime:0.24868083000183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scenic' limit 1
loadtime:0.24873280525208 / seconds
Query Executed:select id FROM `sd` where city='Scenic' && SIC_code='4841'DB:business_master_new
loadtime:0.24928498268127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotland' limit 1
loadtime:0.24933576583862 / seconds
Query Executed:select id FROM `sd` where city='Scotland' && SIC_code='4841'DB:business_master_new
loadtime:0.25003385543823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selby' limit 1
loadtime:0.25008678436279 / seconds
Query Executed:select id FROM `sd` where city='Selby' && SIC_code='4841'DB:business_master_new
loadtime:0.25077986717224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:0.25083184242249 / seconds
Query Executed:select id FROM `sd` where city='Seneca' && SIC_code='4841'DB:business_master_new
loadtime:0.25148296356201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shadehill' limit 1
loadtime:0.25153279304504 / seconds
Query Executed:select id FROM `sd` where city='Shadehill' && SIC_code='4841'DB:business_master_new
loadtime:0.2519838809967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherman' limit 1
loadtime:0.25203585624695 / seconds
Query Executed:select id FROM `sd` where city='Sherman' && SIC_code='4841'DB:business_master_new
loadtime:0.25247192382812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver City' limit 1
loadtime:0.25252485275269 / seconds
Query Executed:select id FROM `sd` where city='Silver City' && SIC_code='4841'DB:business_master_new
loadtime:0.25295495986938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sinai' limit 1
loadtime:0.25300788879395 / seconds
Query Executed:select id FROM `sd` where city='Sinai' && SIC_code='4841'DB:business_master_new
loadtime:0.2536838054657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sioux Falls' limit 1
loadtime:0.25373578071594 / seconds
Query Executed:select id FROM `sd` where city='Sioux Falls' && SIC_code='4841'DB:business_master_new
loadtime:0.25439882278442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sisseton' limit 1
loadtime:0.254478931427 / seconds
Query Executed:select id FROM `sd` where city='Sisseton' && SIC_code='4841'DB:business_master_new
loadtime:0.25513982772827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sky Ranch' limit 1
loadtime:0.25519299507141 / seconds
Query Executed:select id FROM `sd` where city='Sky Ranch' && SIC_code='4841'DB:business_master_new
loadtime:0.25559091567993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithwick' limit 1
loadtime:0.25564694404602 / seconds
Query Executed:select id FROM `sd` where city='Smithwick' && SIC_code='4841'DB:business_master_new
loadtime:0.25604486465454 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Shore' limit 1
loadtime:0.25609493255615 / seconds
Query Executed:select id FROM `sd` where city='South Shore' && SIC_code='4841'DB:business_master_new
loadtime:0.25691294670105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spearfish' limit 1
loadtime:0.25696492195129 / seconds
Query Executed:select id FROM `sd` where city='Spearfish' && SIC_code='4841'DB:business_master_new
loadtime:0.25765585899353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:0.25770783424377 / seconds
Query Executed:select id FROM `sd` where city='Spencer' && SIC_code='4841'DB:business_master_new
loadtime:0.25851583480835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.25856781005859 / seconds
Query Executed:select id FROM `sd` where city='Springfield' && SIC_code='4841'DB:business_master_new
loadtime:0.25925588607788 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Charles' limit 1
loadtime:0.25930786132812 / seconds
Query Executed:select id FROM `sd` where city='St Charles' && SIC_code='4841'DB:business_master_new
loadtime:0.25974583625793 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Francis' limit 1
loadtime:0.25979781150818 / seconds
Query Executed:select id FROM `sd` where city='St Francis' && SIC_code='4841'DB:business_master_new
loadtime:0.26023483276367 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Lawrence' limit 1
loadtime:0.2602858543396 / seconds
Query Executed:select id FROM `sd` where city='St Lawrence' && SIC_code='4841'DB:business_master_new
loadtime:0.2607569694519 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Onge' limit 1
loadtime:0.26080799102783 / seconds
Query Executed:select id FROM `sd` where city='St Onge' && SIC_code='4841'DB:business_master_new
loadtime:0.26122784614563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephan' limit 1
loadtime:0.26127886772156 / seconds
Query Executed:select id FROM `sd` where city='Stephan' && SIC_code='4841'DB:business_master_new
loadtime:0.26183080673218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stickney' limit 1
loadtime:0.26188397407532 / seconds
Query Executed:select id FROM `sd` where city='Stickney' && SIC_code='4841'DB:business_master_new
loadtime:0.2625617980957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockholm' limit 1
loadtime:0.26261782646179 / seconds
Query Executed:select id FROM `sd` where city='Stockholm' && SIC_code='4841'DB:business_master_new
loadtime:0.26332497596741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strandburg' limit 1
loadtime:0.26337599754333 / seconds
Query Executed:select id FROM `sd` where city='Strandburg' && SIC_code='4841'DB:business_master_new
loadtime:0.2639799118042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:0.26403188705444 / seconds
Query Executed:select id FROM `sd` where city='Stratford' && SIC_code='4841'DB:business_master_new
loadtime:0.26475095748901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturgis' limit 1
loadtime:0.26480293273926 / seconds
Query Executed:select id FROM `sd` where city='Sturgis' && SIC_code='4841'DB:business_master_new
loadtime:0.26547980308533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summit' limit 1
loadtime:0.26553177833557 / seconds
Query Executed:select id FROM `sd` where city='Summit' && SIC_code='4841'DB:business_master_new
loadtime:0.26619291305542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabor' limit 1
loadtime:0.26624488830566 / seconds
Query Executed:select id FROM `sd` where city='Tabor' && SIC_code='4841'DB:business_master_new
loadtime:0.26690983772278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tea' limit 1
loadtime:0.26696181297302 / seconds
Query Executed:select id FROM `sd` where city='Tea' && SIC_code='4841'DB:business_master_new
loadtime:0.26763391494751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timber Lake' limit 1
loadtime:0.26769995689392 / seconds
Query Executed:select id FROM `sd` where city='Timber Lake' && SIC_code='4841'DB:business_master_new
loadtime:0.26836895942688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolstoy' limit 1
loadtime:0.26841998100281 / seconds
Query Executed:select id FROM `sd` where city='Tolstoy' && SIC_code='4841'DB:business_master_new
loadtime:0.26917695999146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toronto' limit 1
loadtime:0.26923084259033 / seconds
Query Executed:select id FROM `sd` where city='Toronto' && SIC_code='4841'DB:business_master_new
loadtime:0.26991081237793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trail City' limit 1
loadtime:0.26996397972107 / seconds
Query Executed:select id FROM `sd` where city='Trail City' && SIC_code='4841'DB:business_master_new
loadtime:0.27046799659729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trent' limit 1
loadtime:0.27051877975464 / seconds
Query Executed:select id FROM `sd` where city='Trent' && SIC_code='4841'DB:business_master_new
loadtime:0.27115893363953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tripp' limit 1
loadtime:0.27121090888977 / seconds
Query Executed:select id FROM `sd` where city='Tripp' && SIC_code='4841'DB:business_master_new
loadtime:0.27187395095825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tulare' limit 1
loadtime:0.2719259262085 / seconds
Query Executed:select id FROM `sd` where city='Tulare' && SIC_code='4841'DB:business_master_new
loadtime:0.27257990837097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turton' limit 1
loadtime:0.27263498306274 / seconds
Query Executed:select id FROM `sd` where city='Turton' && SIC_code='4841'DB:business_master_new
loadtime:0.2732629776001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuthill' limit 1
loadtime:0.27331399917603 / seconds
Query Executed:select id FROM `sd` where city='Tuthill' && SIC_code='4841'DB:business_master_new
loadtime:0.27382493019104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twin Brooks' limit 1
loadtime:0.2738778591156 / seconds
Query Executed:select id FROM `sd` where city='Twin Brooks' && SIC_code='4841'DB:business_master_new
loadtime:0.27457594871521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyndall' limit 1
loadtime:0.2746319770813 / seconds
Query Executed:select id FROM `sd` where city='Tyndall' && SIC_code='4841'DB:business_master_new
loadtime:0.27529096603394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Center' limit 1
loadtime:0.27534198760986 / seconds
Query Executed:select id FROM `sd` where city='Union Center' && SIC_code='4841'DB:business_master_new
loadtime:0.27605080604553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Utica' limit 1
loadtime:0.27610278129578 / seconds
Query Executed:select id FROM `sd` where city='Utica' && SIC_code='4841'DB:business_master_new
loadtime:0.276859998703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vale' limit 1
loadtime:0.27691197395325 / seconds
Query Executed:select id FROM `sd` where city='Vale' && SIC_code='4841'DB:business_master_new
loadtime:0.27775287628174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Springs' limit 1
loadtime:0.27780485153198 / seconds
Query Executed:select id FROM `sd` where city='Valley Springs' && SIC_code='4841'DB:business_master_new
loadtime:0.27848386764526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Veblen' limit 1
loadtime:0.27853584289551 / seconds
Query Executed:select id FROM `sd` where city='Veblen' && SIC_code='4841'DB:business_master_new
loadtime:0.27920985221863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vermillion' limit 1
loadtime:0.27926087379456 / seconds
Query Executed:select id FROM `sd` where city='Vermillion' && SIC_code='4841'DB:business_master_new
loadtime:0.27995491027832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viborg' limit 1
loadtime:0.28002190589905 / seconds
Query Executed:select id FROM `sd` where city='Viborg' && SIC_code='4841'DB:business_master_new
loadtime:0.28069376945496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vienna' limit 1
loadtime:0.2807469367981 / seconds
Query Executed:select id FROM `sd` where city='Vienna' && SIC_code='4841'DB:business_master_new
loadtime:0.28133893013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virgil' limit 1
loadtime:0.28138899803162 / seconds
Query Executed:select id FROM `sd` where city='Virgil' && SIC_code='4841'DB:business_master_new
loadtime:0.28184986114502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vivian' limit 1
loadtime:0.28190279006958 / seconds
Query Executed:select id FROM `sd` where city='Vivian' && SIC_code='4841'DB:business_master_new
loadtime:0.28264498710632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Volga' limit 1
loadtime:0.28269696235657 / seconds
Query Executed:select id FROM `sd` where city='Volga' && SIC_code='4841'DB:business_master_new
loadtime:0.28336191177368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Volin' limit 1
loadtime:0.28341197967529 / seconds
Query Executed:select id FROM `sd` where city='Volin' && SIC_code='4841'DB:business_master_new
loadtime:0.28409576416016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wagner' limit 1
loadtime:0.28414797782898 / seconds
Query Executed:select id FROM `sd` where city='Wagner' && SIC_code='4841'DB:business_master_new
loadtime:0.284836769104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakonda' limit 1
loadtime:0.28488898277283 / seconds
Query Executed:select id FROM `sd` where city='Wakonda' && SIC_code='4841'DB:business_master_new
loadtime:0.28555393218994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakpala' limit 1
loadtime:0.28560590744019 / seconds
Query Executed:select id FROM `sd` where city='Wakpala' && SIC_code='4841'DB:business_master_new
loadtime:0.28606295585632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wall' limit 1
loadtime:0.28611397743225 / seconds
Query Executed:select id FROM `sd` where city='Wall' && SIC_code='4841'DB:business_master_new
loadtime:0.28676891326904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallace' limit 1
loadtime:0.28683376312256 / seconds
Query Executed:select id FROM `sd` where city='Wallace' && SIC_code='4841'DB:business_master_new
loadtime:0.28738379478455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wanblee' limit 1
loadtime:0.28743481636047 / seconds
Query Executed:select id FROM `sd` where city='Wanblee' && SIC_code='4841'DB:business_master_new
loadtime:0.28805589675903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ward' limit 1
loadtime:0.28810787200928 / seconds
Query Executed:select id FROM `sd` where city='Ward' && SIC_code='4841'DB:business_master_new
loadtime:0.28851699829102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warner' limit 1
loadtime:0.28856897354126 / seconds
Query Executed:select id FROM `sd` where city='Warner' && SIC_code='4841'DB:business_master_new
loadtime:0.28935694694519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wasta' limit 1
loadtime:0.28940796852112 / seconds
Query Executed:select id FROM `sd` where city='Wasta' && SIC_code='4841'DB:business_master_new
loadtime:0.28999781608582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watauga' limit 1
loadtime:0.29005098342896 / seconds
Query Executed:select id FROM `sd` where city='Watauga' && SIC_code='4841'DB:business_master_new
loadtime:0.29052877426147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:0.2905809879303 / seconds
Query Executed:select id FROM `sd` where city='Watertown' && SIC_code='4841'DB:business_master_new
loadtime:0.29125189781189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waubay' limit 1
loadtime:0.2913179397583 / seconds
Query Executed:select id FROM `sd` where city='Waubay' && SIC_code='4841'DB:business_master_new
loadtime:0.29197192192078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverly' limit 1
loadtime:0.29202485084534 / seconds
Query Executed:select id FROM `sd` where city='Waverly' && SIC_code='4841'DB:business_master_new
loadtime:0.29237484931946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:0.29242587089539 / seconds
Query Executed:select id FROM `sd` where city='Webster' && SIC_code='4841'DB:business_master_new
loadtime:0.29306697845459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wecota' limit 1
loadtime:0.29311895370483 / seconds
Query Executed:select id FROM `sd` where city='Wecota' && SIC_code='4841'DB:business_master_new
loadtime:0.29348397254944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworth' limit 1
loadtime:0.29353594779968 / seconds
Query Executed:select id FROM `sd` where city='Wentworth' && SIC_code='4841'DB:business_master_new
loadtime:0.29417896270752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wessington' limit 1
loadtime:0.29423093795776 / seconds
Query Executed:select id FROM `sd` where city='Wessington' && SIC_code='4841'DB:business_master_new
loadtime:0.29488682746887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wessington Spgs' limit 1
loadtime:0.29493880271912 / seconds
Query Executed:select id FROM `sd` where city='Wessington Spgs' && SIC_code='4841'DB:business_master_new
loadtime:0.29531192779541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wessington Springs' limit 1
loadtime:0.29536294937134 / seconds
Query Executed:select id FROM `sd` where city='Wessington Springs' && SIC_code='4841'DB:business_master_new
loadtime:0.29602193832397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:0.29607486724854 / seconds
Query Executed:select id FROM `sd` where city='Westport' && SIC_code='4841'DB:business_master_new
loadtime:0.29673886299133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wetonka' limit 1
loadtime:0.29679083824158 / seconds
Query Executed:select id FROM `sd` where city='Wetonka' && SIC_code='4841'DB:business_master_new
loadtime:0.29719686508179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wewela' limit 1
loadtime:0.2972469329834 / seconds
Query Executed:select id FROM `sd` where city='Wewela' && SIC_code='4841'DB:business_master_new
loadtime:0.29767394065857 / seconds
Query loaded from cache:select * from geodata_geocity where city='White' limit 1
loadtime:0.29772686958313 / seconds
Query Executed:select id FROM `sd` where city='White' && SIC_code='4841'DB:business_master_new
loadtime:0.2983717918396 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Lake' limit 1
loadtime:0.29842281341553 / seconds
Query Executed:select id FROM `sd` where city='White Lake' && SIC_code='4841'DB:business_master_new
loadtime:0.29906487464905 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Owl' limit 1
loadtime:0.29911589622498 / seconds
Query Executed:select id FROM `sd` where city='White Owl' && SIC_code='4841'DB:business_master_new
loadtime:0.2995388507843 / seconds
Query loaded from cache:select * from geodata_geocity where city='White River' limit 1
loadtime:0.29959177970886 / seconds
Query Executed:select id FROM `sd` where city='White River' && SIC_code='4841'DB:business_master_new
loadtime:0.30023980140686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitehorse' limit 1
loadtime:0.30029082298279 / seconds
Query Executed:select id FROM `sd` where city='Whitehorse' && SIC_code='4841'DB:business_master_new
loadtime:0.30074977874756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitewood' limit 1
loadtime:0.3008029460907 / seconds
Query Executed:select id FROM `sd` where city='Whitewood' && SIC_code='4841'DB:business_master_new
loadtime:0.30146384239197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willow Lake' limit 1
loadtime:0.3015148639679 / seconds
Query Executed:select id FROM `sd` where city='Willow Lake' && SIC_code='4841'DB:business_master_new
loadtime:0.30216979980469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmot' limit 1
loadtime:0.30222177505493 / seconds
Query Executed:select id FROM `sd` where city='Wilmot' && SIC_code='4841'DB:business_master_new
loadtime:0.30289077758789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winfred' limit 1
loadtime:0.30294394493103 / seconds
Query Executed:select id FROM `sd` where city='Winfred' && SIC_code='4841'DB:business_master_new
loadtime:0.30359983444214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winner' limit 1
loadtime:0.30365777015686 / seconds
Query Executed:select id FROM `sd` where city='Winner' && SIC_code='4841'DB:business_master_new
loadtime:0.30432295799255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Witten' limit 1
loadtime:0.30437397956848 / seconds
Query Executed:select id FROM `sd` where city='Witten' && SIC_code='4841'DB:business_master_new
loadtime:0.30503177642822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolsey' limit 1
loadtime:0.30508494377136 / seconds
Query Executed:select id FROM `sd` where city='Wolsey' && SIC_code='4841'DB:business_master_new
loadtime:0.3057279586792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wood' limit 1
loadtime:0.30578088760376 / seconds
Query Executed:select id FROM `sd` where city='Wood' && SIC_code='4841'DB:business_master_new
loadtime:0.30642580986023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woonsocket' limit 1
loadtime:0.30648589134216 / seconds
Query Executed:select id FROM `sd` where city='Woonsocket' && SIC_code='4841'DB:business_master_new
loadtime:0.30715584754944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worthing' limit 1
loadtime:0.30720686912537 / seconds
Query Executed:select id FROM `sd` where city='Worthing' && SIC_code='4841'DB:business_master_new
loadtime:0.30787181854248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wounded Knee' limit 1
loadtime:0.30792379379272 / seconds
Query Executed:select id FROM `sd` where city='Wounded Knee' && SIC_code='4841'DB:business_master_new
loadtime:0.30837082862854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yale' limit 1
loadtime:0.30842185020447 / seconds
Query Executed:select id FROM `sd` where city='Yale' && SIC_code='4841'DB:business_master_new
loadtime:0.30907487869263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yankton' limit 1
loadtime:0.30912685394287 / seconds
Query Executed:select id FROM `sd` where city='Yankton' && SIC_code='4841'DB:business_master_new
loadtime:0.3097608089447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zell' limit 1
loadtime:0.3098258972168 / seconds
Query Executed:select id FROM `sd` where city='Zell' && SIC_code='4841'DB:business_master_new
loadtime:0.31041693687439 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.31057095527649 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.31099677085876 / seconds
Operation template executed (chunk cache operation)
loadtime:0.3111629486084 / seconds
template override:Default
loadtime:0.31120491027832 / 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.31297898292542 / seconds
Template Constructed, Array Rows:49
loadtime:0.3135027885437 / seconds
TOTAL EXECUTION TIME: 0.31307
loadtime:0.31462979316711 / 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] => cable-and-other-pay-television-services [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.31463980674744
TOTAL KEY ARRAYS: 69