Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:7.8201293945312E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018341541290283 / seconds
host not found setting manual db connection
loadtime:0.009641170501709 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.009876012802124 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010075092315674 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010138988494873 / seconds
zipcode:
loadtime:0.010167121887207 / seconds
Query Executed:select * from search_referrer where page_hash='3cf590df4e06586358b3716d9bca6f25' limit 10 DB:ezrox_toadli
loadtime:0.010401010513306 / seconds
Operation header executed (non global)
loadtime:0.01042914390564 / seconds
Operation leaderboard executed (non global)
loadtime:0.010480165481567 / seconds
Operation square executed (non global)
loadtime:0.010509014129639 / seconds
Operation square_bottom executed (non global)
loadtime:0.010536193847656 / seconds
Operation smallsquare executed (non global)
loadtime:0.010562181472778 / seconds
Operation headeradright executed (non global)
loadtime:0.010586977005005 / seconds
Operation google_analytics executed (non global)
loadtime:0.010612010955811 / seconds
Operation topstories executed (non global)
loadtime:0.010637044906616 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010663032531738 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010694026947021 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010961055755615 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.01115608215332 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011197090148926 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011260032653809 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011309146881104 / seconds
Template key: archive_menu pushed
loadtime:0.011319160461426 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011332988739014 / seconds
Template key: get_gravatar pushed
loadtime:0.011340141296387 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011349201202393 / seconds
*10)-10)+1 | start:0
loadtime:0.011389017105103 / seconds
Query loaded from cache:select * from categories where cat_URLid='hotels-and-motels'
loadtime:0.011430025100708 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='south-dakota'
loadtime:0.011465072631836 / seconds
DB connected to localhost business_master_new
loadtime:0.01172399520874 / seconds
Query Executed:select * from `sd_catmap` where sic='7011' order by city ascDB:business_master_new
loadtime:0.072525024414062 / seconds
Query stored in cache : _QUERY_www.toadli.com9146ae9400065a441c354596fbda00a7
loadtime:0.07417106628418 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='south-dakota'
loadtime:0.074231147766113 / seconds
Query Executed:select sum(totalcount) as totalsum from `sd_catmap` where sic='7011'DB:business_master_new
loadtime:0.076543092727661 / seconds
Query stored in cache : _QUERY_www.toadli.comdf53101c73ec3efffc20f39080002579
loadtime:0.07658314704895 / seconds
410 / 11
loadtime:0.076642990112305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aberdeen' limit 1
loadtime:0.076714992523193 / seconds
Query Executed:select id FROM `sd` where city='Aberdeen' && SIC_code='7011'DB:business_master_new
loadtime:0.10445404052734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Academy' limit 1
loadtime:0.10459613800049 / seconds
Query Executed:select id FROM `sd` where city='Academy' && SIC_code='7011'DB:business_master_new
loadtime:0.10511112213135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agar' limit 1
loadtime:0.10517716407776 / seconds
Query Executed:select id FROM `sd` where city='Agar' && SIC_code='7011'DB:business_master_new
loadtime:0.10595297813416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Akaska' limit 1
loadtime:0.10602712631226 / seconds
Query Executed:select id FROM `sd` where city='Akaska' && SIC_code='7011'DB:business_master_new
loadtime:0.10655498504639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alcester' limit 1
loadtime:0.1066300868988 / seconds
Query Executed:select id FROM `sd` where city='Alcester' && SIC_code='7011'DB:business_master_new
loadtime:0.1093590259552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexandria' limit 1
loadtime:0.10943508148193 / seconds
Query Executed:select id FROM `sd` where city='Alexandria' && SIC_code='7011'DB:business_master_new
loadtime:0.11193704605103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allen' limit 1
loadtime:0.11199998855591 / seconds
Query Executed:select id FROM `sd` where city='Allen' && SIC_code='7011'DB:business_master_new
loadtime:0.11258411407471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpena' limit 1
loadtime:0.11264300346375 / seconds
Query Executed:select id FROM `sd` where city='Alpena' && SIC_code='7011'DB:business_master_new
loadtime:0.12213516235352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altamont' limit 1
loadtime:0.12219715118408 / seconds
Query Executed:select id FROM `sd` where city='Altamont' && SIC_code='7011'DB:business_master_new
loadtime:0.12260603904724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.12266707420349 / seconds
Query Executed:select id FROM `sd` where city='Amherst' && SIC_code='7011'DB:business_master_new
loadtime:0.12321615219116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.12327599525452 / seconds
Query Executed:select id FROM `sd` where city='Andover' && SIC_code='7011'DB:business_master_new
loadtime:0.1240119934082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ardmore' limit 1
loadtime:0.12408900260925 / seconds
Query Executed:select id FROM `sd` where city='Ardmore' && SIC_code='7011'DB:business_master_new
loadtime:0.12451601028442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.12457609176636 / seconds
Query Executed:select id FROM `sd` where city='Arlington' && SIC_code='7011'DB:business_master_new
loadtime:0.12761116027832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Armour' limit 1
loadtime:0.12770009040833 / seconds
Query Executed:select id FROM `sd` where city='Armour' && SIC_code='7011'DB:business_master_new
loadtime:0.13118314743042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Artesian' limit 1
loadtime:0.13128018379211 / seconds
Query Executed:select id FROM `sd` where city='Artesian' && SIC_code='7011'DB:business_master_new
loadtime:0.1413881778717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashton' limit 1
loadtime:0.14147710800171 / seconds
Query Executed:select id FROM `sd` where city='Ashton' && SIC_code='7011'DB:business_master_new
loadtime:0.14220213890076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Astoria' limit 1
loadtime:0.14228200912476 / seconds
Query Executed:select id FROM `sd` where city='Astoria' && SIC_code='7011'DB:business_master_new
loadtime:0.14311718940735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.14319610595703 / seconds
Query Executed:select id FROM `sd` where city='Aurora' && SIC_code='7011'DB:business_master_new
loadtime:0.14419102668762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.14426898956299 / seconds
Query Executed:select id FROM `sd` where city='Avon' && SIC_code='7011'DB:business_master_new
loadtime:0.14680504798889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Badger' limit 1
loadtime:0.14692401885986 / seconds
Query Executed:select id FROM `sd` where city='Badger' && SIC_code='7011'DB:business_master_new
loadtime:0.14749717712402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baltic' limit 1
loadtime:0.14757609367371 / seconds
Query Executed:select id FROM `sd` where city='Baltic' && SIC_code='7011'DB:business_master_new
loadtime:0.14993500709534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bancroft' limit 1
loadtime:0.15002012252808 / seconds
Query Executed:select id FROM `sd` where city='Bancroft' && SIC_code='7011'DB:business_master_new
loadtime:0.15047121047974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnard' limit 1
loadtime:0.15055418014526 / seconds
Query Executed:select id FROM `sd` where city='Barnard' && SIC_code='7011'DB:business_master_new
loadtime:0.15103507041931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Batesland' limit 1
loadtime:0.15111613273621 / seconds
Query Executed:select id FROM `sd` where city='Batesland' && SIC_code='7011'DB:business_master_new
loadtime:0.15171909332275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.15182304382324 / seconds
Query Executed:select id FROM `sd` where city='Bath' && SIC_code='7011'DB:business_master_new
loadtime:0.15268206596375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belle Fourche' limit 1
loadtime:0.15276908874512 / seconds
Query Executed:select id FROM `sd` where city='Belle Fourche' && SIC_code='7011'DB:business_master_new
loadtime:0.15935301780701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvidere' limit 1
loadtime:0.15949010848999 / seconds
Query Executed:select id FROM `sd` where city='Belvidere' && SIC_code='7011'DB:business_master_new
loadtime:0.16017198562622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beresford' limit 1
loadtime:0.16027617454529 / seconds
Query Executed:select id FROM `sd` where city='Beresford' && SIC_code='7011'DB:business_master_new
loadtime:0.16490507125854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Stone City' limit 1
loadtime:0.16501903533936 / seconds
Query Executed:select id FROM `sd` where city='Big Stone City' && SIC_code='7011'DB:business_master_new
loadtime:0.16724300384521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bison' limit 1
loadtime:0.16735315322876 / seconds
Query Executed:select id FROM `sd` where city='Bison' && SIC_code='7011'DB:business_master_new
loadtime:0.17000603675842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Hawk' limit 1
loadtime:0.17011904716492 / seconds
Query Executed:select id FROM `sd` where city='Black Hawk' && SIC_code='7011'DB:business_master_new
loadtime:0.17410516738892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blunt' limit 1
loadtime:0.17427706718445 / seconds
Query Executed:select id FROM `sd` where city='Blunt' && SIC_code='7011'DB:business_master_new
loadtime:0.18379998207092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonesteel' limit 1
loadtime:0.18387007713318 / seconds
Query Executed:select id FROM `sd` where city='Bonesteel' && SIC_code='7011'DB:business_master_new
loadtime:0.19328498840332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowdle' limit 1
loadtime:0.19337701797485 / seconds
Query Executed:select id FROM `sd` where city='Bowdle' && SIC_code='7011'DB:business_master_new
loadtime:0.19583415985107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Box Elder' limit 1
loadtime:0.19591999053955 / seconds
Query Executed:select id FROM `sd` where city='Box Elder' && SIC_code='7011'DB:business_master_new
loadtime:0.19887614250183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradley' limit 1
loadtime:0.19896101951599 / seconds
Query Executed:select id FROM `sd` where city='Bradley' && SIC_code='7011'DB:business_master_new
loadtime:0.19959402084351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.19966006278992 / seconds
Query Executed:select id FROM `sd` where city='Brandon' && SIC_code='7011'DB:business_master_new
loadtime:0.20605206489563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandt' limit 1
loadtime:0.20614004135132 / seconds
Query Executed:select id FROM `sd` where city='Brandt' && SIC_code='7011'DB:business_master_new
loadtime:0.21543121337891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brentford' limit 1
loadtime:0.21549916267395 / seconds
Query Executed:select id FROM `sd` where city='Brentford' && SIC_code='7011'DB:business_master_new
loadtime:0.21602702140808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.21609306335449 / seconds
Query Executed:select id FROM `sd` where city='Bridgewater' && SIC_code='7011'DB:business_master_new
loadtime:0.21841502189636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.21850109100342 / seconds
Query Executed:select id FROM `sd` where city='Bristol' && SIC_code='7011'DB:business_master_new
loadtime:0.22776699066162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Britton' limit 1
loadtime:0.22784304618835 / seconds
Query Executed:select id FROM `sd` where city='Britton' && SIC_code='7011'DB:business_master_new
loadtime:0.23211908340454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookings' limit 1
loadtime:0.23219108581543 / seconds
Query Executed:select id FROM `sd` where city='Brookings' && SIC_code='7011'DB:business_master_new
loadtime:0.24244809150696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruce' limit 1
loadtime:0.24252915382385 / seconds
Query Executed:select id FROM `sd` where city='Bruce' && SIC_code='7011'DB:business_master_new
loadtime:0.24436116218567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryant' limit 1
loadtime:0.24441719055176 / seconds
Query Executed:select id FROM `sd` where city='Bryant' && SIC_code='7011'DB:business_master_new
loadtime:0.25383305549622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo' limit 1
loadtime:0.25388813018799 / seconds
Query Executed:select id FROM `sd` where city='Buffalo' && SIC_code='7011'DB:business_master_new
loadtime:0.25648498535156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Gap' limit 1
loadtime:0.25655317306519 / seconds
Query Executed:select id FROM `sd` where city='Buffalo Gap' && SIC_code='7011'DB:business_master_new
loadtime:0.25722002983093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Ridge' limit 1
loadtime:0.25727319717407 / seconds
Query Executed:select id FROM `sd` where city='Buffalo Ridge' && SIC_code='7011'DB:business_master_new
loadtime:0.25764417648315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bullhead' limit 1
loadtime:0.2576961517334 / seconds
Query Executed:select id FROM `sd` where city='Bullhead' && SIC_code='7011'DB:business_master_new
loadtime:0.25819897651672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burbank' limit 1
loadtime:0.25825119018555 / seconds
Query Executed:select id FROM `sd` where city='Burbank' && SIC_code='7011'DB:business_master_new
loadtime:0.25891709327698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burke' limit 1
loadtime:0.25897598266602 / seconds
Query Executed:select id FROM `sd` where city='Burke' && SIC_code='7011'DB:business_master_new
loadtime:0.26227211952209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bushnell' limit 1
loadtime:0.26234316825867 / seconds
Query Executed:select id FROM `sd` where city='Bushnell' && SIC_code='7011'DB:business_master_new
loadtime:0.26274609565735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butler' limit 1
loadtime:0.26280903816223 / seconds
Query Executed:select id FROM `sd` where city='Butler' && SIC_code='7011'DB:business_master_new
loadtime:0.26321411132812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Crook' limit 1
loadtime:0.26327013969421 / seconds
Query Executed:select id FROM `sd` where city='Camp Crook' && SIC_code='7011'DB:business_master_new
loadtime:0.26397514343262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canistota' limit 1
loadtime:0.26402807235718 / seconds
Query Executed:select id FROM `sd` where city='Canistota' && SIC_code='7011'DB:business_master_new
loadtime:0.26639819145203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canova' limit 1
loadtime:0.26648211479187 / seconds
Query Executed:select id FROM `sd` where city='Canova' && SIC_code='7011'DB:business_master_new
loadtime:0.26736807823181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.2674241065979 / seconds
Query Executed:select id FROM `sd` where city='Canton' && SIC_code='7011'DB:business_master_new
loadtime:0.27187514305115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caputa' limit 1
loadtime:0.27194118499756 / seconds
Query Executed:select id FROM `sd` where city='Caputa' && SIC_code='7011'DB:business_master_new
loadtime:0.27247905731201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carpenter' limit 1
loadtime:0.27253317832947 / seconds
Query Executed:select id FROM `sd` where city='Carpenter' && SIC_code='7011'DB:business_master_new
loadtime:0.27331209182739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carter' limit 1
loadtime:0.27336311340332 / seconds
Query Executed:select id FROM `sd` where city='Carter' && SIC_code='7011'DB:business_master_new
loadtime:0.27372312545776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carthage' limit 1
loadtime:0.27377414703369 / seconds
Query Executed:select id FROM `sd` where city='Carthage' && SIC_code='7011'DB:business_master_new
loadtime:0.27446413040161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castlewood' limit 1
loadtime:0.27451705932617 / seconds
Query Executed:select id FROM `sd` where city='Castlewood' && SIC_code='7011'DB:business_master_new
loadtime:0.27669906616211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cavour' limit 1
loadtime:0.27675199508667 / seconds
Query Executed:select id FROM `sd` where city='Cavour' && SIC_code='7011'DB:business_master_new
loadtime:0.27759408950806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:0.27764701843262 / seconds
Query Executed:select id FROM `sd` where city='Centerville' && SIC_code='7011'DB:business_master_new
loadtime:0.280198097229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central City' limit 1
loadtime:0.28025102615356 / seconds
Query Executed:select id FROM `sd` where city='Central City' && SIC_code='7011'DB:business_master_new
loadtime:0.2806830406189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chamberlain' limit 1
loadtime:0.28073501586914 / seconds
Query Executed:select id FROM `sd` where city='Chamberlain' && SIC_code='7011'DB:business_master_new
loadtime:0.28635120391846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chancellor' limit 1
loadtime:0.28643703460693 / seconds
Query Executed:select id FROM `sd` where city='Chancellor' && SIC_code='7011'DB:business_master_new
loadtime:0.2960410118103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.29609704017639 / seconds
Query Executed:select id FROM `sd` where city='Chelsea' && SIC_code='7011'DB:business_master_new
loadtime:0.29650616645813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Creek' limit 1
loadtime:0.29655718803406 / seconds
Query Executed:select id FROM `sd` where city='Cherry Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.29703807830811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.29709005355835 / seconds
Query Executed:select id FROM `sd` where city='Chester' && SIC_code='7011'DB:business_master_new
loadtime:0.29803705215454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claire City' limit 1
loadtime:0.29808902740479 / seconds
Query Executed:select id FROM `sd` where city='Claire City' && SIC_code='7011'DB:business_master_new
loadtime:0.29882717132568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:0.29887914657593 / seconds
Query Executed:select id FROM `sd` where city='Claremont' && SIC_code='7011'DB:business_master_new
loadtime:0.30804109573364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clark' limit 1
loadtime:0.3080940246582 / seconds
Query Executed:select id FROM `sd` where city='Clark' && SIC_code='7011'DB:business_master_new
loadtime:0.31180119514465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clear Lake' limit 1
loadtime:0.31186819076538 / seconds
Query Executed:select id FROM `sd` where city='Clear Lake' && SIC_code='7011'DB:business_master_new
loadtime:0.31580519676208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clearfield' limit 1
loadtime:0.31587505340576 / seconds
Query Executed:select id FROM `sd` where city='Clearfield' && SIC_code='7011'DB:business_master_new
loadtime:0.31630301475525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colman' limit 1
loadtime:0.31635618209839 / seconds
Query Executed:select id FROM `sd` where city='Colman' && SIC_code='7011'DB:business_master_new
loadtime:0.32588410377502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colome' limit 1
loadtime:0.3259391784668 / seconds
Query Executed:select id FROM `sd` where city='Colome' && SIC_code='7011'DB:business_master_new
loadtime:0.33530902862549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colton' limit 1
loadtime:0.33536219596863 / seconds
Query Executed:select id FROM `sd` where city='Colton' && SIC_code='7011'DB:business_master_new
loadtime:0.33762407302856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.33767700195312 / seconds
Query Executed:select id FROM `sd` where city='Columbia' && SIC_code='7011'DB:business_master_new
loadtime:0.34691619873047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conde' limit 1
loadtime:0.34699010848999 / seconds
Query Executed:select id FROM `sd` where city='Conde' && SIC_code='7011'DB:business_master_new
loadtime:0.35639905929565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corona' limit 1
loadtime:0.35645198822021 / seconds
Query Executed:select id FROM `sd` where city='Corona' && SIC_code='7011'DB:business_master_new
loadtime:0.3572301864624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corsica' limit 1
loadtime:0.35729813575745 / seconds
Query Executed:select id FROM `sd` where city='Corsica' && SIC_code='7011'DB:business_master_new
loadtime:0.36037421226501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creighton' limit 1
loadtime:0.36044311523438 / seconds
Query Executed:select id FROM `sd` where city='Creighton' && SIC_code='7011'DB:business_master_new
loadtime:0.36083316802979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cresbard' limit 1
loadtime:0.36088919639587 / seconds
Query Executed:select id FROM `sd` where city='Cresbard' && SIC_code='7011'DB:business_master_new
loadtime:0.36167407035828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crocker' limit 1
loadtime:0.36174011230469 / seconds
Query Executed:select id FROM `sd` where city='Crocker' && SIC_code='7011'DB:business_master_new
loadtime:0.36214208602905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crooks' limit 1
loadtime:0.36219620704651 / seconds
Query Executed:select id FROM `sd` where city='Crooks' && SIC_code='7011'DB:business_master_new
loadtime:0.37152814865112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Custer' limit 1
loadtime:0.37158107757568 / seconds
Query Executed:select id FROM `sd` where city='Custer' && SIC_code='7011'DB:business_master_new
loadtime:0.37832498550415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dakota Dunes' limit 1
loadtime:0.37844610214233 / seconds
Query Executed:select id FROM `sd` where city='Dakota Dunes' && SIC_code='7011'DB:business_master_new
loadtime:0.37884712219238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas' limit 1
loadtime:0.37890410423279 / seconds
Query Executed:select id FROM `sd` where city='Dallas' && SIC_code='7011'DB:business_master_new
loadtime:0.38821506500244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dante' limit 1
loadtime:0.388267993927 / seconds
Query Executed:select id FROM `sd` where city='Dante' && SIC_code='7011'DB:business_master_new
loadtime:0.38887310028076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis' limit 1
loadtime:0.38892602920532 / seconds
Query Executed:select id FROM `sd` where city='Davis' && SIC_code='7011'DB:business_master_new
loadtime:0.38965916633606 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Smet' limit 1
loadtime:0.3897111415863 / seconds
Query Executed:select id FROM `sd` where city='De Smet' && SIC_code='7011'DB:business_master_new
loadtime:0.3933961391449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deadwood' limit 1
loadtime:0.39347219467163 / seconds
Query Executed:select id FROM `sd` where city='Deadwood' && SIC_code='7011'DB:business_master_new
loadtime:0.39792799949646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dell Rapids' limit 1
loadtime:0.39805698394775 / seconds
Query Executed:select id FROM `sd` where city='Dell Rapids' && SIC_code='7011'DB:business_master_new
loadtime:0.4026050567627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delmont' limit 1
loadtime:0.4026792049408 / seconds
Query Executed:select id FROM `sd` where city='Delmont' && SIC_code='7011'DB:business_master_new
loadtime:0.41217398643494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dimock' limit 1
loadtime:0.41222810745239 / seconds
Query Executed:select id FROM `sd` where city='Dimock' && SIC_code='7011'DB:business_master_new
loadtime:0.42182111740112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doland' limit 1
loadtime:0.42188310623169 / seconds
Query Executed:select id FROM `sd` where city='Doland' && SIC_code='7011'DB:business_master_new
loadtime:0.43106198310852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolton' limit 1
loadtime:0.43113112449646 / seconds
Query Executed:select id FROM `sd` where city='Dolton' && SIC_code='7011'DB:business_master_new
loadtime:0.43167901039124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Draper' limit 1
loadtime:0.43174314498901 / seconds
Query Executed:select id FROM `sd` where city='Draper' && SIC_code='7011'DB:business_master_new
loadtime:0.43251204490662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dupree' limit 1
loadtime:0.43256521224976 / seconds
Query Executed:select id FROM `sd` where city='Dupree' && SIC_code='7011'DB:business_master_new
loadtime:0.43466210365295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Butte' limit 1
loadtime:0.434730052948 / seconds
Query Executed:select id FROM `sd` where city='Eagle Butte' && SIC_code='7011'DB:business_master_new
loadtime:0.4392101764679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.43928217887878 / seconds
Query Executed:select id FROM `sd` where city='Eden' && SIC_code='7011'DB:business_master_new
loadtime:0.44003820419312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgemont' limit 1
loadtime:0.44010806083679 / seconds
Query Executed:select id FROM `sd` where city='Edgemont' && SIC_code='7011'DB:business_master_new
loadtime:0.4424421787262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Egan' limit 1
loadtime:0.44251108169556 / seconds
Query Executed:select id FROM `sd` where city='Egan' && SIC_code='7011'DB:business_master_new
loadtime:0.44324016571045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Point' limit 1
loadtime:0.44329404830933 / seconds
Query Executed:select id FROM `sd` where city='Elk Point' && SIC_code='7011'DB:business_master_new
loadtime:0.44684505462646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkton' limit 1
loadtime:0.44691205024719 / seconds
Query Executed:select id FROM `sd` where city='Elkton' && SIC_code='7011'DB:business_master_new
loadtime:0.44965219497681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth Afb' limit 1
loadtime:0.44970703125 / seconds
Query Executed:select id FROM `sd` where city='Ellsworth Afb' && SIC_code='7011'DB:business_master_new
loadtime:0.45062708854675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elm Springs' limit 1
loadtime:0.45068001747131 / seconds
Query Executed:select id FROM `sd` where city='Elm Springs' && SIC_code='7011'DB:business_master_new
loadtime:0.45106315612793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emery' limit 1
loadtime:0.45111608505249 / seconds
Query Executed:select id FROM `sd` where city='Emery' && SIC_code='7011'DB:business_master_new
loadtime:0.45319819450378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enning' limit 1
loadtime:0.45326399803162 / seconds
Query Executed:select id FROM `sd` where city='Enning' && SIC_code='7011'DB:business_master_new
loadtime:0.45380306243896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erwin' limit 1
loadtime:0.45385813713074 / seconds
Query Executed:select id FROM `sd` where city='Erwin' && SIC_code='7011'DB:business_master_new
loadtime:0.45443105697632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estelline' limit 1
loadtime:0.45448303222656 / seconds
Query Executed:select id FROM `sd` where city='Estelline' && SIC_code='7011'DB:business_master_new
loadtime:0.45704007148743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ethan' limit 1
loadtime:0.45710802078247 / seconds
Query Executed:select id FROM `sd` where city='Ethan' && SIC_code='7011'DB:business_master_new
loadtime:0.45914006233215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eureka' limit 1
loadtime:0.45921802520752 / seconds
Query Executed:select id FROM `sd` where city='Eureka' && SIC_code='7011'DB:business_master_new
loadtime:0.46233701705933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairburn' limit 1
loadtime:0.46240615844727 / seconds
Query Executed:select id FROM `sd` where city='Fairburn' && SIC_code='7011'DB:business_master_new
loadtime:0.46285009384155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.46290397644043 / seconds
Query Executed:select id FROM `sd` where city='Fairfax' && SIC_code='7011'DB:business_master_new
loadtime:0.46359610557556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:0.46364903450012 / seconds
Query Executed:select id FROM `sd` where city='Fairview' && SIC_code='7011'DB:business_master_new
loadtime:0.46412801742554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faith' limit 1
loadtime:0.46418118476868 / seconds
Query Executed:select id FROM `sd` where city='Faith' && SIC_code='7011'DB:business_master_new
loadtime:0.46684002876282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faulkton' limit 1
loadtime:0.46691203117371 / seconds
Query Executed:select id FROM `sd` where city='Faulkton' && SIC_code='7011'DB:business_master_new
loadtime:0.47027611732483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fedora' limit 1
loadtime:0.47034907341003 / seconds
Query Executed:select id FROM `sd` where city='Fedora' && SIC_code='7011'DB:business_master_new
loadtime:0.47100901603699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferney' limit 1
loadtime:0.47106409072876 / seconds
Query Executed:select id FROM `sd` where city='Ferney' && SIC_code='7011'DB:business_master_new
loadtime:0.47154712677002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Firesteel' limit 1
loadtime:0.47159719467163 / seconds
Query Executed:select id FROM `sd` where city='Firesteel' && SIC_code='7011'DB:business_master_new
loadtime:0.47203516960144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flandreau' limit 1
loadtime:0.47208714485168 / seconds
Query Executed:select id FROM `sd` where city='Flandreau' && SIC_code='7011'DB:business_master_new
loadtime:0.47614121437073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.47621297836304 / seconds
Query Executed:select id FROM `sd` where city='Florence' && SIC_code='7011'DB:business_master_new
loadtime:0.48580718040466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forestburg' limit 1
loadtime:0.48586201667786 / seconds
Query Executed:select id FROM `sd` where city='Forestburg' && SIC_code='7011'DB:business_master_new
loadtime:0.48629117012024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Meade' limit 1
loadtime:0.4863440990448 / seconds
Query Executed:select id FROM `sd` where city='Fort Meade' && SIC_code='7011'DB:business_master_new
loadtime:0.48689913749695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Pierre' limit 1
loadtime:0.48695421218872 / seconds
Query Executed:select id FROM `sd` where city='Fort Pierre' && SIC_code='7011'DB:business_master_new
loadtime:0.49139308929443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Thompson' limit 1
loadtime:0.49146914482117 / seconds
Query Executed:select id FROM `sd` where city='Fort Thompson' && SIC_code='7011'DB:business_master_new
loadtime:0.49362206459045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frankfort' limit 1
loadtime:0.49369120597839 / seconds
Query Executed:select id FROM `sd` where city='Frankfort' && SIC_code='7011'DB:business_master_new
loadtime:0.49440598487854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frederick' limit 1
loadtime:0.494460105896 / seconds
Query Executed:select id FROM `sd` where city='Frederick' && SIC_code='7011'DB:business_master_new
loadtime:0.50384712219238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeman' limit 1
loadtime:0.50390005111694 / seconds
Query Executed:select id FROM `sd` where city='Freeman' && SIC_code='7011'DB:business_master_new
loadtime:0.50765800476074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitdale' limit 1
loadtime:0.50772619247437 / seconds
Query Executed:select id FROM `sd` where city='Fruitdale' && SIC_code='7011'DB:business_master_new
loadtime:0.50809216499329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fulton' limit 1
loadtime:0.50814604759216 / seconds
Query Executed:select id FROM `sd` where city='Fulton' && SIC_code='7011'DB:business_master_new
loadtime:0.50874900817871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gann Valley' limit 1
loadtime:0.50881099700928 / seconds
Query Executed:select id FROM `sd` where city='Gann Valley' && SIC_code='7011'DB:business_master_new
loadtime:0.50945711135864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden City' limit 1
loadtime:0.5095100402832 / seconds
Query Executed:select id FROM `sd` where city='Garden City' && SIC_code='7011'DB:business_master_new
loadtime:0.51008701324463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garretson' limit 1
loadtime:0.51013898849487 / seconds
Query Executed:select id FROM `sd` where city='Garretson' && SIC_code='7011'DB:business_master_new
loadtime:0.51361417770386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gary' limit 1
loadtime:0.5136821269989 / seconds
Query Executed:select id FROM `sd` where city='Gary' && SIC_code='7011'DB:business_master_new
loadtime:0.51574301719666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gayville' limit 1
loadtime:0.51582312583923 / seconds
Query Executed:select id FROM `sd` where city='Gayville' && SIC_code='7011'DB:business_master_new
loadtime:0.51666808128357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Geddes' limit 1
loadtime:0.51672220230103 / seconds
Query Executed:select id FROM `sd` where city='Geddes' && SIC_code='7011'DB:business_master_new
loadtime:0.52607297897339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gettysburg' limit 1
loadtime:0.52612709999084 / seconds
Query Executed:select id FROM `sd` where city='Gettysburg' && SIC_code='7011'DB:business_master_new
loadtime:0.52963209152222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glad Valley' limit 1
loadtime:0.52970719337463 / seconds
Query Executed:select id FROM `sd` where city='Glad Valley' && SIC_code='7011'DB:business_master_new
loadtime:0.530109167099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glencross' limit 1
loadtime:0.53016304969788 / seconds
Query Executed:select id FROM `sd` where city='Glencross' && SIC_code='7011'DB:business_master_new
loadtime:0.53058099746704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenham' limit 1
loadtime:0.53063321113586 / seconds
Query Executed:select id FROM `sd` where city='Glenham' && SIC_code='7011'DB:business_master_new
loadtime:0.53140616416931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodwin' limit 1
loadtime:0.53147315979004 / seconds
Query Executed:select id FROM `sd` where city='Goodwin' && SIC_code='7011'DB:business_master_new
loadtime:0.53232502937317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gregory' limit 1
loadtime:0.53237915039062 / seconds
Query Executed:select id FROM `sd` where city='Gregory' && SIC_code='7011'DB:business_master_new
loadtime:0.53635501861572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grenville' limit 1
loadtime:0.53642916679382 / seconds
Query Executed:select id FROM `sd` where city='Grenville' && SIC_code='7011'DB:business_master_new
loadtime:0.53708600997925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.53715205192566 / seconds
Query Executed:select id FROM `sd` where city='Groton' && SIC_code='7011'DB:business_master_new
loadtime:0.54034399986267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamill' limit 1
loadtime:0.54039716720581 / seconds
Query Executed:select id FROM `sd` where city='Hamill' && SIC_code='7011'DB:business_master_new
loadtime:0.54105401039124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisburg' limit 1
loadtime:0.54110813140869 / seconds
Query Executed:select id FROM `sd` where city='Harrisburg' && SIC_code='7011'DB:business_master_new
loadtime:0.54399704933167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrison' limit 1
loadtime:0.54405117034912 / seconds
Query Executed:select id FROM `sd` where city='Harrison' && SIC_code='7011'DB:business_master_new
loadtime:0.54460000991821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrold' limit 1
loadtime:0.54465007781982 / seconds
Query Executed:select id FROM `sd` where city='Harrold' && SIC_code='7011'DB:business_master_new
loadtime:0.54649901390076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.54656505584717 / seconds
Query Executed:select id FROM `sd` where city='Hartford' && SIC_code='7011'DB:business_master_new
loadtime:0.5501971244812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayes' limit 1
loadtime:0.55025100708008 / seconds
Query Executed:select id FROM `sd` where city='Hayes' && SIC_code='7011'DB:business_master_new
loadtime:0.55082511901855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayti' limit 1
loadtime:0.55088019371033 / seconds
Query Executed:select id FROM `sd` where city='Hayti' && SIC_code='7011'DB:business_master_new
loadtime:0.55319213867188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazel' limit 1
loadtime:0.55324506759644 / seconds
Query Executed:select id FROM `sd` where city='Hazel' && SIC_code='7011'DB:business_master_new
loadtime:0.55406808853149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hecla' limit 1
loadtime:0.55412101745605 / seconds
Query Executed:select id FROM `sd` where city='Hecla' && SIC_code='7011'DB:business_master_new
loadtime:0.5561101436615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henry' limit 1
loadtime:0.55617809295654 / seconds
Query Executed:select id FROM `sd` where city='Henry' && SIC_code='7011'DB:business_master_new
loadtime:0.55702209472656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hermosa' limit 1
loadtime:0.55707502365112 / seconds
Query Executed:select id FROM `sd` where city='Hermosa' && SIC_code='7011'DB:business_master_new
loadtime:0.55927920341492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herreid' limit 1
loadtime:0.55934810638428 / seconds
Query Executed:select id FROM `sd` where city='Herreid' && SIC_code='7011'DB:business_master_new
loadtime:0.56175804138184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herrick' limit 1
loadtime:0.56184315681458 / seconds
Query Executed:select id FROM `sd` where city='Herrick' && SIC_code='7011'DB:business_master_new
loadtime:0.56251811981201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hetland' limit 1
loadtime:0.56257319450378 / seconds
Query Executed:select id FROM `sd` where city='Hetland' && SIC_code='7011'DB:business_master_new
loadtime:0.56296706199646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highmore' limit 1
loadtime:0.56301999092102 / seconds
Query Executed:select id FROM `sd` where city='Highmore' && SIC_code='7011'DB:business_master_new
loadtime:0.56636810302734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hill City' limit 1
loadtime:0.56643605232239 / seconds
Query Executed:select id FROM `sd` where city='Hill City' && SIC_code='7011'DB:business_master_new
loadtime:0.57051420211792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hitchcock' limit 1
loadtime:0.57063817977905 / seconds
Query Executed:select id FROM `sd` where city='Hitchcock' && SIC_code='7011'DB:business_master_new
loadtime:0.57249903678894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holabird' limit 1
loadtime:0.5725691318512 / seconds
Query Executed:select id FROM `sd` where city='Holabird' && SIC_code='7011'DB:business_master_new
loadtime:0.57311701774597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hosmer' limit 1
loadtime:0.57317113876343 / seconds
Query Executed:select id FROM `sd` where city='Hosmer' && SIC_code='7011'DB:business_master_new
loadtime:0.57480216026306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hot Springs' limit 1
loadtime:0.57485604286194 / seconds
Query Executed:select id FROM `sd` where city='Hot Springs' && SIC_code='7011'DB:business_master_new
loadtime:0.58120703697205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houghton' limit 1
loadtime:0.58130216598511 / seconds
Query Executed:select id FROM `sd` where city='Houghton' && SIC_code='7011'DB:business_master_new
loadtime:0.58197212219238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoven' limit 1
loadtime:0.58202910423279 / seconds
Query Executed:select id FROM `sd` where city='Hoven' && SIC_code='7011'DB:business_master_new
loadtime:0.58442711830139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howard' limit 1
loadtime:0.58449506759644 / seconds
Query Executed:select id FROM `sd` where city='Howard' && SIC_code='7011'DB:business_master_new
loadtime:0.58808517456055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howes' limit 1
loadtime:0.58815407752991 / seconds
Query Executed:select id FROM `sd` where city='Howes' && SIC_code='7011'DB:business_master_new
loadtime:0.58870911598206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:0.5887610912323 / seconds
Query Executed:select id FROM `sd` where city='Hudson' && SIC_code='7011'DB:business_master_new
loadtime:0.58984708786011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humboldt' limit 1
loadtime:0.58990001678467 / seconds
Query Executed:select id FROM `sd` where city='Humboldt' && SIC_code='7011'DB:business_master_new
loadtime:0.5996081829071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:0.59966111183167 / seconds
Query Executed:select id FROM `sd` where city='Hurley' && SIC_code='7011'DB:business_master_new
loadtime:0.60106801986694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huron' limit 1
loadtime:0.60112118721008 / seconds
Query Executed:select id FROM `sd` where city='Huron' && SIC_code='7011'DB:business_master_new
loadtime:0.61406016349792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ideal' limit 1
loadtime:0.61415505409241 / seconds
Query Executed:select id FROM `sd` where city='Ideal' && SIC_code='7011'DB:business_master_new
loadtime:0.61464619636536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Igloo' limit 1
loadtime:0.61470007896423 / seconds
Query Executed:select id FROM `sd` where city='Igloo' && SIC_code='7011'DB:business_master_new
loadtime:0.6151180267334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Interior' limit 1
loadtime:0.61517214775085 / seconds
Query Executed:select id FROM `sd` where city='Interior' && SIC_code='7011'DB:business_master_new
loadtime:0.61593914031982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ipswich' limit 1
loadtime:0.61601400375366 / seconds
Query Executed:select id FROM `sd` where city='Ipswich' && SIC_code='7011'DB:business_master_new
loadtime:0.61935210227966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irene' limit 1
loadtime:0.61941909790039 / seconds
Query Executed:select id FROM `sd` where city='Irene' && SIC_code='7011'DB:business_master_new
loadtime:0.62877011299133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iroquois' limit 1
loadtime:0.62883305549622 / seconds
Query Executed:select id FROM `sd` where city='Iroquois' && SIC_code='7011'DB:business_master_new
loadtime:0.62999606132507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isabel' limit 1
loadtime:0.63004899024963 / seconds
Query Executed:select id FROM `sd` where city='Isabel' && SIC_code='7011'DB:business_master_new
loadtime:0.63120007514954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Java' limit 1
loadtime:0.63126707077026 / seconds
Query Executed:select id FROM `sd` where city='Java' && SIC_code='7011'DB:business_master_new
loadtime:0.63200211524963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:0.63205504417419 / seconds
Query Executed:select id FROM `sd` where city='Jefferson' && SIC_code='7011'DB:business_master_new
loadtime:0.63342499732971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kadoka' limit 1
loadtime:0.63347721099854 / seconds
Query Executed:select id FROM `sd` where city='Kadoka' && SIC_code='7011'DB:business_master_new
loadtime:0.63672018051147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaylor' limit 1
loadtime:0.63681817054749 / seconds
Query Executed:select id FROM `sd` where city='Kaylor' && SIC_code='7011'DB:business_master_new
loadtime:0.63735818862915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keldron' limit 1
loadtime:0.63741302490234 / seconds
Query Executed:select id FROM `sd` where city='Keldron' && SIC_code='7011'DB:business_master_new
loadtime:0.63793301582336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kennebec' limit 1
loadtime:0.63799118995667 / seconds
Query Executed:select id FROM `sd` where city='Kennebec' && SIC_code='7011'DB:business_master_new
loadtime:0.63940620422363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keystone' limit 1
loadtime:0.63947820663452 / seconds
Query Executed:select id FROM `sd` where city='Keystone' && SIC_code='7011'DB:business_master_new
loadtime:0.6492030620575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kimball' limit 1
loadtime:0.64932203292847 / seconds
Query Executed:select id FROM `sd` where city='Kimball' && SIC_code='7011'DB:business_master_new
loadtime:0.65889716148376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kranzburg' limit 1
loadtime:0.6589879989624 / seconds
Query Executed:select id FROM `sd` where city='Kranzburg' && SIC_code='7011'DB:business_master_new
loadtime:0.65950417518616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kyle' limit 1
loadtime:0.65955805778503 / seconds
Query Executed:select id FROM `sd` where city='Kyle' && SIC_code='7011'DB:business_master_new
loadtime:0.66056609153748 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Plant' limit 1
loadtime:0.66063213348389 / seconds
Query Executed:select id FROM `sd` where city='La Plant' && SIC_code='7011'DB:business_master_new
loadtime:0.66109609603882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Labolt' limit 1
loadtime:0.6611499786377 / seconds
Query Executed:select id FROM `sd` where city='Labolt' && SIC_code='7011'DB:business_master_new
loadtime:0.66169810295105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Andes' limit 1
loadtime:0.66175103187561 / seconds
Query Executed:select id FROM `sd` where city='Lake Andes' && SIC_code='7011'DB:business_master_new
loadtime:0.66467905044556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake City' limit 1
loadtime:0.66475009918213 / seconds
Query Executed:select id FROM `sd` where city='Lake City' && SIC_code='7011'DB:business_master_new
loadtime:0.66533899307251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Norden' limit 1
loadtime:0.66540813446045 / seconds
Query Executed:select id FROM `sd` where city='Lake Norden' && SIC_code='7011'DB:business_master_new
loadtime:0.66681909561157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Preston' limit 1
loadtime:0.66688704490662 / seconds
Query Executed:select id FROM `sd` where city='Lake Preston' && SIC_code='7011'DB:business_master_new
loadtime:0.67627716064453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lane' limit 1
loadtime:0.67634415626526 / seconds
Query Executed:select id FROM `sd` where city='Lane' && SIC_code='7011'DB:business_master_new
loadtime:0.67675399780273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langford' limit 1
loadtime:0.6768159866333 / seconds
Query Executed:select id FROM `sd` where city='Langford' && SIC_code='7011'DB:business_master_new
loadtime:0.67779898643494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lantry' limit 1
loadtime:0.67785215377808 / seconds
Query Executed:select id FROM `sd` where city='Lantry' && SIC_code='7011'DB:business_master_new
loadtime:0.67831707000732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lead' limit 1
loadtime:0.67836809158325 / seconds
Query Executed:select id FROM `sd` where city='Lead' && SIC_code='7011'DB:business_master_new
loadtime:0.6819531917572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:0.68204307556152 / seconds
Query Executed:select id FROM `sd` where city='Lebanon' && SIC_code='7011'DB:business_master_new
loadtime:0.68270516395569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemmon' limit 1
loadtime:0.68275904655457 / seconds
Query Executed:select id FROM `sd` where city='Lemmon' && SIC_code='7011'DB:business_master_new
loadtime:0.68651509284973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lennox' limit 1
loadtime:0.68658709526062 / seconds
Query Executed:select id FROM `sd` where city='Lennox' && SIC_code='7011'DB:business_master_new
loadtime:0.69022297859192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leola' limit 1
loadtime:0.69029116630554 / seconds
Query Executed:select id FROM `sd` where city='Leola' && SIC_code='7011'DB:business_master_new
loadtime:0.69975018501282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lesterville' limit 1
loadtime:0.69982719421387 / seconds
Query Executed:select id FROM `sd` where city='Lesterville' && SIC_code='7011'DB:business_master_new
loadtime:0.70065498352051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Letcher' limit 1
loadtime:0.70070910453796 / seconds
Query Executed:select id FROM `sd` where city='Letcher' && SIC_code='7011'DB:business_master_new
loadtime:0.70192503929138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Eagle' limit 1
loadtime:0.70199608802795 / seconds
Query Executed:select id FROM `sd` where city='Little Eagle' && SIC_code='7011'DB:business_master_new
loadtime:0.70244598388672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lodgepole' limit 1
loadtime:0.70249819755554 / seconds
Query Executed:select id FROM `sd` where city='Lodgepole' && SIC_code='7011'DB:business_master_new
loadtime:0.70303320884705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Valley' limit 1
loadtime:0.70308518409729 / seconds
Query Executed:select id FROM `sd` where city='Long Valley' && SIC_code='7011'DB:business_master_new
loadtime:0.7036120891571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longlake' limit 1
loadtime:0.70366311073303 / seconds
Query Executed:select id FROM `sd` where city='Longlake' && SIC_code='7011'DB:business_master_new
loadtime:0.7040741443634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longvalley' limit 1
loadtime:0.70412611961365 / seconds
Query Executed:select id FROM `sd` where city='Longvalley' && SIC_code='7011'DB:business_master_new
loadtime:0.7045431137085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lower Brule' limit 1
loadtime:0.70459508895874 / seconds
Query Executed:select id FROM `sd` where city='Lower Brule' && SIC_code='7011'DB:business_master_new
loadtime:0.71410417556763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowry' limit 1
loadtime:0.71417212486267 / seconds
Query Executed:select id FROM `sd` where city='Lowry' && SIC_code='7011'DB:business_master_new
loadtime:0.71455121040344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:0.714604139328 / seconds
Query Executed:select id FROM `sd` where city='Ludlow' && SIC_code='7011'DB:business_master_new
loadtime:0.71516108512878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyons' limit 1
loadtime:0.71521306037903 / seconds
Query Executed:select id FROM `sd` where city='Lyons' && SIC_code='7011'DB:business_master_new
loadtime:0.71574115753174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.71580100059509 / seconds
Query Executed:select id FROM `sd` where city='Madison' && SIC_code='7011'DB:business_master_new
loadtime:0.7236909866333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manderson' limit 1
loadtime:0.72376418113708 / seconds
Query Executed:select id FROM `sd` where city='Manderson' && SIC_code='7011'DB:business_master_new
loadtime:0.72433018684387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield' limit 1
loadtime:0.72438406944275 / seconds
Query Executed:select id FROM `sd` where city='Mansfield' && SIC_code='7011'DB:business_master_new
loadtime:0.72511720657349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.72516918182373 / seconds
Query Executed:select id FROM `sd` where city='Marion' && SIC_code='7011'DB:business_master_new
loadtime:0.73463106155396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martin' limit 1
loadtime:0.73470020294189 / seconds
Query Executed:select id FROM `sd` where city='Martin' && SIC_code='7011'DB:business_master_new
loadtime:0.73784017562866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marty' limit 1
loadtime:0.73791313171387 / seconds
Query Executed:select id FROM `sd` where city='Marty' && SIC_code='7011'DB:business_master_new
loadtime:0.73850202560425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marvin' limit 1
loadtime:0.7385561466217 / seconds
Query Executed:select id FROM `sd` where city='Marvin' && SIC_code='7011'DB:business_master_new
loadtime:0.73904204368591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Intosh' limit 1
loadtime:0.73909521102905 / seconds
Query Executed:select id FROM `sd` where city='Mc Intosh' && SIC_code='7011'DB:business_master_new
loadtime:0.74013519287109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Laughlin' limit 1
loadtime:0.74018812179565 / seconds
Query Executed:select id FROM `sd` where city='Mc Laughlin' && SIC_code='7011'DB:business_master_new
loadtime:0.74965405464172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadow' limit 1
loadtime:0.74972200393677 / seconds
Query Executed:select id FROM `sd` where city='Meadow' && SIC_code='7011'DB:business_master_new
loadtime:0.75053000450134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meckling' limit 1
loadtime:0.7505841255188 / seconds
Query Executed:select id FROM `sd` where city='Meckling' && SIC_code='7011'DB:business_master_new
loadtime:0.75100016593933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mellette' limit 1
loadtime:0.75105404853821 / seconds
Query Executed:select id FROM `sd` where city='Mellette' && SIC_code='7011'DB:business_master_new
loadtime:0.75192618370056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menno' limit 1
loadtime:0.75198316574097 / seconds
Query Executed:select id FROM `sd` where city='Menno' && SIC_code='7011'DB:business_master_new
loadtime:0.75483918190002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland' limit 1
loadtime:0.75489115715027 / seconds
Query Executed:select id FROM `sd` where city='Midland' && SIC_code='7011'DB:business_master_new
loadtime:0.7560920715332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milbank' limit 1
loadtime:0.75616121292114 / seconds
Query Executed:select id FROM `sd` where city='Milbank' && SIC_code='7011'DB:business_master_new
loadtime:0.76245212554932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milesville' limit 1
loadtime:0.76252317428589 / seconds
Query Executed:select id FROM `sd` where city='Milesville' && SIC_code='7011'DB:business_master_new
loadtime:0.76314401626587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miller' limit 1
loadtime:0.76319909095764 / seconds
Query Executed:select id FROM `sd` where city='Miller' && SIC_code='7011'DB:business_master_new
loadtime:0.76742911338806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mina' limit 1
loadtime:0.76750111579895 / seconds
Query Executed:select id FROM `sd` where city='Mina' && SIC_code='7011'DB:business_master_new
loadtime:0.76794910430908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miranda' limit 1
loadtime:0.76800608634949 / seconds
Query Executed:select id FROM `sd` where city='Miranda' && SIC_code='7011'DB:business_master_new
loadtime:0.7683961391449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mission' limit 1
loadtime:0.76844716072083 / seconds
Query Executed:select id FROM `sd` where city='Mission' && SIC_code='7011'DB:business_master_new
loadtime:0.77169609069824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mission Hill' limit 1
loadtime:0.77176809310913 / seconds
Query Executed:select id FROM `sd` where city='Mission Hill' && SIC_code='7011'DB:business_master_new
loadtime:0.77262806892395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchell' limit 1
loadtime:0.77268218994141 / seconds
Query Executed:select id FROM `sd` where city='Mitchell' && SIC_code='7011'DB:business_master_new
loadtime:0.78852605819702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mobridge' limit 1
loadtime:0.78864407539368 / seconds
Query Executed:select id FROM `sd` where city='Mobridge' && SIC_code='7011'DB:business_master_new
loadtime:0.7942590713501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.79434013366699 / seconds
Query Executed:select id FROM `sd` where city='Monroe' && SIC_code='7011'DB:business_master_new
loadtime:0.79502606391907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montrose' limit 1
loadtime:0.79508113861084 / seconds
Query Executed:select id FROM `sd` where city='Montrose' && SIC_code='7011'DB:business_master_new
loadtime:0.7962851524353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morristown' limit 1
loadtime:0.79633808135986 / seconds
Query Executed:select id FROM `sd` where city='Morristown' && SIC_code='7011'DB:business_master_new
loadtime:0.79694008827209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mound City' limit 1
loadtime:0.79699802398682 / seconds
Query Executed:select id FROM `sd` where city='Mound City' && SIC_code='7011'DB:business_master_new
loadtime:0.79774308204651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Vernon' limit 1
loadtime:0.79780316352844 / seconds
Query Executed:select id FROM `sd` where city='Mount Vernon' && SIC_code='7011'DB:business_master_new
loadtime:0.79911208152771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Vernon' limit 1
loadtime:0.7991771697998 / seconds
Query Executed:select id FROM `sd` where city='Mt Vernon' && SIC_code='7011'DB:business_master_new
loadtime:0.79958200454712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mud Butte' limit 1
loadtime:0.79963397979736 / seconds
Query Executed:select id FROM `sd` where city='Mud Butte' && SIC_code='7011'DB:business_master_new
loadtime:0.80015110969543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murdo' limit 1
loadtime:0.80021715164185 / seconds
Query Executed:select id FROM `sd` where city='Murdo' && SIC_code='7011'DB:business_master_new
loadtime:0.81015110015869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nemo' limit 1
loadtime:0.81024217605591 / seconds
Query Executed:select id FROM `sd` where city='Nemo' && SIC_code='7011'DB:business_master_new
loadtime:0.81080102920532 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Effington' limit 1
loadtime:0.81087112426758 / seconds
Query Executed:select id FROM `sd` where city='New Effington' && SIC_code='7011'DB:business_master_new
loadtime:0.81193017959595 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Holland' limit 1
loadtime:0.81198906898499 / seconds
Query Executed:select id FROM `sd` where city='New Holland' && SIC_code='7011'DB:business_master_new
loadtime:0.81257200241089 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Underwood' limit 1
loadtime:0.81262302398682 / seconds
Query Executed:select id FROM `sd` where city='New Underwood' && SIC_code='7011'DB:business_master_new
loadtime:0.81381320953369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newell' limit 1
loadtime:0.81388211250305 / seconds
Query Executed:select id FROM `sd` where city='Newell' && SIC_code='7011'DB:business_master_new
loadtime:0.82325410842896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nisland' limit 1
loadtime:0.82332420349121 / seconds
Query Executed:select id FROM `sd` where city='Nisland' && SIC_code='7011'DB:business_master_new
loadtime:0.82400703430176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norris' limit 1
loadtime:0.82406115531921 / seconds
Query Executed:select id FROM `sd` where city='Norris' && SIC_code='7011'DB:business_master_new
loadtime:0.82460117340088 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Sioux City' limit 1
loadtime:0.82465314865112 / seconds
Query Executed:select id FROM `sd` where city='North Sioux City' && SIC_code='7011'DB:business_master_new
loadtime:0.83002614974976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northville' limit 1
loadtime:0.83011102676392 / seconds
Query Executed:select id FROM `sd` where city='Northville' && SIC_code='7011'DB:business_master_new
loadtime:0.83091402053833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nunda' limit 1
loadtime:0.83097410202026 / seconds
Query Executed:select id FROM `sd` where city='Nunda' && SIC_code='7011'DB:business_master_new
loadtime:0.83159208297729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oacoma' limit 1
loadtime:0.83164501190186 / seconds
Query Executed:select id FROM `sd` where city='Oacoma' && SIC_code='7011'DB:business_master_new
loadtime:0.83245301246643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oelrichs' limit 1
loadtime:0.83253002166748 / seconds
Query Executed:select id FROM `sd` where city='Oelrichs' && SIC_code='7011'DB:business_master_new
loadtime:0.83320808410645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oglala' limit 1
loadtime:0.83328008651733 / seconds
Query Executed:select id FROM `sd` where city='Oglala' && SIC_code='7011'DB:business_master_new
loadtime:0.83384609222412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okaton' limit 1
loadtime:0.83390021324158 / seconds
Query Executed:select id FROM `sd` where city='Okaton' && SIC_code='7011'DB:business_master_new
loadtime:0.83434104919434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okreek' limit 1
loadtime:0.83439302444458 / seconds
Query Executed:select id FROM `sd` where city='Okreek' && SIC_code='7011'DB:business_master_new
loadtime:0.83481407165527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oldham' limit 1
loadtime:0.8348650932312 / seconds
Query Executed:select id FROM `sd` where city='Oldham' && SIC_code='7011'DB:business_master_new
loadtime:0.83573818206787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olivet' limit 1
loadtime:0.83580017089844 / seconds
Query Executed:select id FROM `sd` where city='Olivet' && SIC_code='7011'DB:business_master_new
loadtime:0.83669018745422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onaka' limit 1
loadtime:0.83674216270447 / seconds
Query Executed:select id FROM `sd` where city='Onaka' && SIC_code='7011'DB:business_master_new
loadtime:0.83737206459045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onida' limit 1
loadtime:0.83742499351501 / seconds
Query Executed:select id FROM `sd` where city='Onida' && SIC_code='7011'DB:business_master_new
loadtime:0.84694409370422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Opal' limit 1
loadtime:0.84701609611511 / seconds
Query Executed:select id FROM `sd` where city='Opal' && SIC_code='7011'DB:business_master_new
loadtime:0.84739112854004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oral' limit 1
loadtime:0.84744620323181 / seconds
Query Executed:select id FROM `sd` where city='Oral' && SIC_code='7011'DB:business_master_new
loadtime:0.84800100326538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orient' limit 1
loadtime:0.84805417060852 / seconds
Query Executed:select id FROM `sd` where city='Orient' && SIC_code='7011'DB:business_master_new
loadtime:0.84891200065613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ortley' limit 1
loadtime:0.8489830493927 / seconds
Query Executed:select id FROM `sd` where city='Ortley' && SIC_code='7011'DB:business_master_new
loadtime:0.84948420524597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Owanka' limit 1
loadtime:0.84953618049622 / seconds
Query Executed:select id FROM `sd` where city='Owanka' && SIC_code='7011'DB:business_master_new
loadtime:0.85004305839539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parker' limit 1
loadtime:0.85009598731995 / seconds
Query Executed:select id FROM `sd` where city='Parker' && SIC_code='7011'DB:business_master_new
loadtime:0.85384702682495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parkston' limit 1
loadtime:0.85390019416809 / seconds
Query Executed:select id FROM `sd` where city='Parkston' && SIC_code='7011'DB:business_master_new
loadtime:0.85769414901733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parmelee' limit 1
loadtime:0.85774612426758 / seconds
Query Executed:select id FROM `sd` where city='Parmelee' && SIC_code='7011'DB:business_master_new
loadtime:0.85834908485413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peever' limit 1
loadtime:0.85840106010437 / seconds
Query Executed:select id FROM `sd` where city='Peever' && SIC_code='7011'DB:business_master_new
loadtime:0.85913610458374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Philip' limit 1
loadtime:0.8591890335083 / seconds
Query Executed:select id FROM `sd` where city='Philip' && SIC_code='7011'DB:business_master_new
loadtime:0.86256313323975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickstown' limit 1
loadtime:0.86263418197632 / seconds
Query Executed:select id FROM `sd` where city='Pickstown' && SIC_code='7011'DB:business_master_new
loadtime:0.86343312263489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piedmont' limit 1
loadtime:0.86350607872009 / seconds
Query Executed:select id FROM `sd` where city='Piedmont' && SIC_code='7011'DB:business_master_new
loadtime:0.87308216094971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierpont' limit 1
loadtime:0.87315511703491 / seconds
Query Executed:select id FROM `sd` where city='Pierpont' && SIC_code='7011'DB:business_master_new
loadtime:0.87379312515259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierre' limit 1
loadtime:0.87384819984436 / seconds
Query Executed:select id FROM `sd` where city='Pierre' && SIC_code='7011'DB:business_master_new
loadtime:0.89152216911316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Ridge' limit 1
loadtime:0.89164304733276 / seconds
Query Executed:select id FROM `sd` where city='Pine Ridge' && SIC_code='7011'DB:business_master_new
loadtime:0.89509606361389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plankinton' limit 1
loadtime:0.89516711235046 / seconds
Query Executed:select id FROM `sd` where city='Plankinton' && SIC_code='7011'DB:business_master_new
loadtime:0.90482020378113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Platte' limit 1
loadtime:0.90489315986633 / seconds
Query Executed:select id FROM `sd` where city='Platte' && SIC_code='7011'DB:business_master_new
loadtime:0.91032409667969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pollock' limit 1
loadtime:0.91040205955505 / seconds
Query Executed:select id FROM `sd` where city='Pollock' && SIC_code='7011'DB:business_master_new
loadtime:0.91147208213806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Porcupine' limit 1
loadtime:0.91154503822327 / seconds
Query Executed:select id FROM `sd` where city='Porcupine' && SIC_code='7011'DB:business_master_new
loadtime:0.91236805915833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie City' limit 1
loadtime:0.91243600845337 / seconds
Query Executed:select id FROM `sd` where city='Prairie City' && SIC_code='7011'DB:business_master_new
loadtime:0.91315007209778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Presho' limit 1
loadtime:0.91320514678955 / seconds
Query Executed:select id FROM `sd` where city='Presho' && SIC_code='7011'DB:business_master_new
loadtime:0.92271208763123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pringle' limit 1
loadtime:0.92279314994812 / seconds
Query Executed:select id FROM `sd` where city='Pringle' && SIC_code='7011'DB:business_master_new
loadtime:0.92337703704834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pukwana' limit 1
loadtime:0.92343211174011 / seconds
Query Executed:select id FROM `sd` where city='Pukwana' && SIC_code='7011'DB:business_master_new
loadtime:0.92455315589905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinn' limit 1
loadtime:0.92460513114929 / seconds
Query Executed:select id FROM `sd` where city='Quinn' && SIC_code='7011'DB:business_master_new
loadtime:0.92517399787903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ralph' limit 1
loadtime:0.92522621154785 / seconds
Query Executed:select id FROM `sd` where city='Ralph' && SIC_code='7011'DB:business_master_new
loadtime:0.92569303512573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramona' limit 1
loadtime:0.92574310302734 / seconds
Query Executed:select id FROM `sd` where city='Ramona' && SIC_code='7011'DB:business_master_new
loadtime:0.92665100097656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rapid City' limit 1
loadtime:0.92670512199402 / seconds
Query Executed:select id FROM `sd` where city='Rapid City' && SIC_code='7011'DB:business_master_new
loadtime:0.93704104423523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ravinia' limit 1
loadtime:0.93727707862854 / seconds
Query Executed:select id FROM `sd` where city='Ravinia' && SIC_code='7011'DB:business_master_new
loadtime:0.93766403198242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:0.93772721290588 / seconds
Query Executed:select id FROM `sd` where city='Raymond' && SIC_code='7011'DB:business_master_new
loadtime:0.9383590221405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Owl' limit 1
loadtime:0.93841099739075 / seconds
Query Executed:select id FROM `sd` where city='Red Owl' && SIC_code='7011'DB:business_master_new
loadtime:0.93880009651184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redfield' limit 1
loadtime:0.93885111808777 / seconds
Query Executed:select id FROM `sd` where city='Redfield' && SIC_code='7011'DB:business_master_new
loadtime:0.94340705871582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redig' limit 1
loadtime:0.94347810745239 / seconds
Query Executed:select id FROM `sd` where city='Redig' && SIC_code='7011'DB:business_master_new
loadtime:0.94397306442261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ree Heights' limit 1
loadtime:0.94402813911438 / seconds
Query Executed:select id FROM `sd` where city='Ree Heights' && SIC_code='7011'DB:business_master_new
loadtime:0.94476318359375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reliance' limit 1
loadtime:0.9448390007019 / seconds
Query Executed:select id FROM `sd` where city='Reliance' && SIC_code='7011'DB:business_master_new
loadtime:0.94587898254395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Renner' limit 1
loadtime:0.94593405723572 / seconds
Query Executed:select id FROM `sd` where city='Renner' && SIC_code='7011'DB:business_master_new
loadtime:0.94681000709534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reva' limit 1
loadtime:0.94686317443848 / seconds
Query Executed:select id FROM `sd` where city='Reva' && SIC_code='7011'DB:business_master_new
loadtime:0.94749116897583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Revillo' limit 1
loadtime:0.94754314422607 / seconds
Query Executed:select id FROM `sd` where city='Revillo' && SIC_code='7011'DB:business_master_new
loadtime:0.94854211807251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeview' limit 1
loadtime:0.94859409332275 / seconds
Query Executed:select id FROM `sd` where city='Ridgeview' && SIC_code='7011'DB:business_master_new
loadtime:0.94908213615417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockham' limit 1
loadtime:0.94913506507874 / seconds
Query Executed:select id FROM `sd` where city='Rockham' && SIC_code='7011'DB:business_master_new
loadtime:0.94968008995056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roscoe' limit 1
loadtime:0.94973111152649 / seconds
Query Executed:select id FROM `sd` where city='Roscoe' && SIC_code='7011'DB:business_master_new
loadtime:0.95110321044922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosebud' limit 1
loadtime:0.95115613937378 / seconds
Query Executed:select id FROM `sd` where city='Rosebud' && SIC_code='7011'DB:business_master_new
loadtime:0.95294213294983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosholt' limit 1
loadtime:0.9529972076416 / seconds
Query Executed:select id FROM `sd` where city='Rosholt' && SIC_code='7011'DB:business_master_new
loadtime:0.95456099510193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roslyn' limit 1
loadtime:0.95462608337402 / seconds
Query Executed:select id FROM `sd` where city='Roslyn' && SIC_code='7011'DB:business_master_new
loadtime:0.95547604560852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowena' limit 1
loadtime:0.95554518699646 / seconds
Query Executed:select id FROM `sd` where city='Rowena' && SIC_code='7011'DB:business_master_new
loadtime:0.95599317550659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:0.95604705810547 / seconds
Query Executed:select id FROM `sd` where city='Rutland' && SIC_code='7011'DB:business_master_new
loadtime:0.95660209655762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Charles' limit 1
loadtime:0.95665216445923 / seconds
Query Executed:select id FROM `sd` where city='Saint Charles' && SIC_code='7011'DB:business_master_new
loadtime:0.95712304115295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Francis' limit 1
loadtime:0.9571750164032 / seconds
Query Executed:select id FROM `sd` where city='Saint Francis' && SIC_code='7011'DB:business_master_new
loadtime:0.95793604850769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Lawrence' limit 1
loadtime:0.95799112319946 / seconds
Query Executed:select id FROM `sd` where city='Saint Lawrence' && SIC_code='7011'DB:business_master_new
loadtime:0.95880603790283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Onge' limit 1
loadtime:0.95885801315308 / seconds
Query Executed:select id FROM `sd` where city='Saint Onge' && SIC_code='7011'DB:business_master_new
loadtime:0.9594349861145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.95948719978333 / seconds
Query Executed:select id FROM `sd` where city='Salem' && SIC_code='7011'DB:business_master_new
loadtime:0.96339201927185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scenic' limit 1
loadtime:0.96345806121826 / seconds
Query Executed:select id FROM `sd` where city='Scenic' && SIC_code='7011'DB:business_master_new
loadtime:0.96403312683105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotland' limit 1
loadtime:0.96410703659058 / seconds
Query Executed:select id FROM `sd` where city='Scotland' && SIC_code='7011'DB:business_master_new
loadtime:0.97364616394043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selby' limit 1
loadtime:0.97370219230652 / seconds
Query Executed:select id FROM `sd` where city='Selby' && SIC_code='7011'DB:business_master_new
loadtime:0.98328518867493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:0.98335599899292 / seconds
Query Executed:select id FROM `sd` where city='Seneca' && SIC_code='7011'DB:business_master_new
loadtime:0.98401808738708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shadehill' limit 1
loadtime:0.98408508300781 / seconds
Query Executed:select id FROM `sd` where city='Shadehill' && SIC_code='7011'DB:business_master_new
loadtime:0.98453211784363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherman' limit 1
loadtime:0.98458409309387 / seconds
Query Executed:select id FROM `sd` where city='Sherman' && SIC_code='7011'DB:business_master_new
loadtime:0.98502516746521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver City' limit 1
loadtime:0.98507714271545 / seconds
Query Executed:select id FROM `sd` where city='Silver City' && SIC_code='7011'DB:business_master_new
loadtime:0.98550009727478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sinai' limit 1
loadtime:0.98555016517639 / seconds
Query Executed:select id FROM `sd` where city='Sinai' && SIC_code='7011'DB:business_master_new
loadtime:0.98622608184814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sioux Falls' limit 1
loadtime:0.98627901077271 / seconds
Query Executed:select id FROM `sd` where city='Sioux Falls' && SIC_code='7011'DB:business_master_new
loadtime:0.99657702445984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sisseton' limit 1
loadtime:0.99678802490234 / seconds
Query Executed:select id FROM `sd` where city='Sisseton' && SIC_code='7011'DB:business_master_new
loadtime:1.0024971961975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sky Ranch' limit 1
loadtime:1.002583026886 / seconds
Query Executed:select id FROM `sd` where city='Sky Ranch' && SIC_code='7011'DB:business_master_new
loadtime:1.0029940605164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithwick' limit 1
loadtime:1.0030491352081 / seconds
Query Executed:select id FROM `sd` where city='Smithwick' && SIC_code='7011'DB:business_master_new
loadtime:1.0034420490265 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Shore' limit 1
loadtime:1.0034930706024 / seconds
Query Executed:select id FROM `sd` where city='South Shore' && SIC_code='7011'DB:business_master_new
loadtime:1.0043091773987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spearfish' limit 1
loadtime:1.0043621063232 / seconds
Query Executed:select id FROM `sd` where city='Spearfish' && SIC_code='7011'DB:business_master_new
loadtime:1.0158040523529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:1.0159151554108 / seconds
Query Executed:select id FROM `sd` where city='Spencer' && SIC_code='7011'DB:business_master_new
loadtime:1.0167191028595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:1.0167770385742 / seconds
Query Executed:select id FROM `sd` where city='Springfield' && SIC_code='7011'DB:business_master_new
loadtime:1.0186040401459 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Charles' limit 1
loadtime:1.0186719894409 / seconds
Query Executed:select id FROM `sd` where city='St Charles' && SIC_code='7011'DB:business_master_new
loadtime:1.0191090106964 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Francis' limit 1
loadtime:1.0191631317139 / seconds
Query Executed:select id FROM `sd` where city='St Francis' && SIC_code='7011'DB:business_master_new
loadtime:1.0195960998535 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Lawrence' limit 1
loadtime:1.0196461677551 / seconds
Query Executed:select id FROM `sd` where city='St Lawrence' && SIC_code='7011'DB:business_master_new
loadtime:1.0201151371002 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Onge' limit 1
loadtime:1.0201680660248 / seconds
Query Executed:select id FROM `sd` where city='St Onge' && SIC_code='7011'DB:business_master_new
loadtime:1.0205850601196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephan' limit 1
loadtime:1.0206360816956 / seconds
Query Executed:select id FROM `sd` where city='Stephan' && SIC_code='7011'DB:business_master_new
loadtime:1.0211842060089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stickney' limit 1
loadtime:1.0212361812592 / seconds
Query Executed:select id FROM `sd` where city='Stickney' && SIC_code='7011'DB:business_master_new
loadtime:1.0227110385895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockholm' limit 1
loadtime:1.0227780342102 / seconds
Query Executed:select id FROM `sd` where city='Stockholm' && SIC_code='7011'DB:business_master_new
loadtime:1.0234951972961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strandburg' limit 1
loadtime:1.0235481262207 / seconds
Query Executed:select id FROM `sd` where city='Strandburg' && SIC_code='7011'DB:business_master_new
loadtime:1.0241470336914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:1.0241990089417 / seconds
Query Executed:select id FROM `sd` where city='Stratford' && SIC_code='7011'DB:business_master_new
loadtime:1.0249121189117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturgis' limit 1
loadtime:1.0249691009521 / seconds
Query Executed:select id FROM `sd` where city='Sturgis' && SIC_code='7011'DB:business_master_new
loadtime:1.0325441360474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summit' limit 1
loadtime:1.0326302051544 / seconds
Query Executed:select id FROM `sd` where city='Summit' && SIC_code='7011'DB:business_master_new
loadtime:1.0335700511932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabor' limit 1
loadtime:1.0336260795593 / seconds
Query Executed:select id FROM `sd` where city='Tabor' && SIC_code='7011'DB:business_master_new
loadtime:1.0349700450897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tea' limit 1
loadtime:1.0350241661072 / seconds
Query Executed:select id FROM `sd` where city='Tea' && SIC_code='7011'DB:business_master_new
loadtime:1.0390870571136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timber Lake' limit 1
loadtime:1.0391530990601 / seconds
Query Executed:select id FROM `sd` where city='Timber Lake' && SIC_code='7011'DB:business_master_new
loadtime:1.0408160686493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolstoy' limit 1
loadtime:1.04088306427 / seconds
Query Executed:select id FROM `sd` where city='Tolstoy' && SIC_code='7011'DB:business_master_new
loadtime:1.0416221618652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toronto' limit 1
loadtime:1.0416750907898 / seconds
Query Executed:select id FROM `sd` where city='Toronto' && SIC_code='7011'DB:business_master_new
loadtime:1.0428321361542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trail City' limit 1
loadtime:1.0428860187531 / seconds
Query Executed:select id FROM `sd` where city='Trail City' && SIC_code='7011'DB:business_master_new
loadtime:1.0433831214905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trent' limit 1
loadtime:1.043436050415 / seconds
Query Executed:select id FROM `sd` where city='Trent' && SIC_code='7011'DB:business_master_new
loadtime:1.0440821647644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tripp' limit 1
loadtime:1.0441341400146 / seconds
Query Executed:select id FROM `sd` where city='Tripp' && SIC_code='7011'DB:business_master_new
loadtime:1.0457611083984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tulare' limit 1
loadtime:1.0458221435547 / seconds
Query Executed:select id FROM `sd` where city='Tulare' && SIC_code='7011'DB:business_master_new
loadtime:1.0467150211334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turton' limit 1
loadtime:1.0467879772186 / seconds
Query Executed:select id FROM `sd` where city='Turton' && SIC_code='7011'DB:business_master_new
loadtime:1.0474181175232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuthill' limit 1
loadtime:1.0474710464478 / seconds
Query Executed:select id FROM `sd` where city='Tuthill' && SIC_code='7011'DB:business_master_new
loadtime:1.0479819774628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twin Brooks' limit 1
loadtime:1.0480341911316 / seconds
Query Executed:select id FROM `sd` where city='Twin Brooks' && SIC_code='7011'DB:business_master_new
loadtime:1.0487170219421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyndall' limit 1
loadtime:1.0487670898438 / seconds
Query Executed:select id FROM `sd` where city='Tyndall' && SIC_code='7011'DB:business_master_new
loadtime:1.0523760318756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Center' limit 1
loadtime:1.0524439811707 / seconds
Query Executed:select id FROM `sd` where city='Union Center' && SIC_code='7011'DB:business_master_new
loadtime:1.0531580448151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Utica' limit 1
loadtime:1.0532121658325 / seconds
Query Executed:select id FROM `sd` where city='Utica' && SIC_code='7011'DB:business_master_new
loadtime:1.0539631843567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vale' limit 1
loadtime:1.0540151596069 / seconds
Query Executed:select id FROM `sd` where city='Vale' && SIC_code='7011'DB:business_master_new
loadtime:1.0548450946808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Springs' limit 1
loadtime:1.054897069931 / seconds
Query Executed:select id FROM `sd` where city='Valley Springs' && SIC_code='7011'DB:business_master_new
loadtime:1.0563399791718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Veblen' limit 1
loadtime:1.0563921928406 / seconds
Query Executed:select id FROM `sd` where city='Veblen' && SIC_code='7011'DB:business_master_new
loadtime:1.0574851036072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vermillion' limit 1
loadtime:1.0575389862061 / seconds
Query Executed:select id FROM `sd` where city='Vermillion' && SIC_code='7011'DB:business_master_new
loadtime:1.0652630329132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viborg' limit 1
loadtime:1.0653400421143 / seconds
Query Executed:select id FROM `sd` where city='Viborg' && SIC_code='7011'DB:business_master_new
loadtime:1.0672180652618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vienna' limit 1
loadtime:1.0672771930695 / seconds
Query Executed:select id FROM `sd` where city='Vienna' && SIC_code='7011'DB:business_master_new
loadtime:1.067883014679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virgil' limit 1
loadtime:1.0679340362549 / seconds
Query Executed:select id FROM `sd` where city='Virgil' && SIC_code='7011'DB:business_master_new
loadtime:1.0683870315552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vivian' limit 1
loadtime:1.0684401988983 / seconds
Query Executed:select id FROM `sd` where city='Vivian' && SIC_code='7011'DB:business_master_new
loadtime:1.069176197052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Volga' limit 1
loadtime:1.0692291259766 / seconds
Query Executed:select id FROM `sd` where city='Volga' && SIC_code='7011'DB:business_master_new
loadtime:1.0791971683502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Volin' limit 1
loadtime:1.0792500972748 / seconds
Query Executed:select id FROM `sd` where city='Volin' && SIC_code='7011'DB:business_master_new
loadtime:1.080176115036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wagner' limit 1
loadtime:1.0802290439606 / seconds
Query Executed:select id FROM `sd` where city='Wagner' && SIC_code='7011'DB:business_master_new
loadtime:1.0844850540161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakonda' limit 1
loadtime:1.084557056427 / seconds
Query Executed:select id FROM `sd` where city='Wakonda' && SIC_code='7011'DB:business_master_new
loadtime:1.0858180522919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakpala' limit 1
loadtime:1.0858860015869 / seconds
Query Executed:select id FROM `sd` where city='Wakpala' && SIC_code='7011'DB:business_master_new
loadtime:1.0863401889801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wall' limit 1
loadtime:1.086394071579 / seconds
Query Executed:select id FROM `sd` where city='Wall' && SIC_code='7011'DB:business_master_new
loadtime:1.0960490703583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallace' limit 1
loadtime:1.0961542129517 / seconds
Query Executed:select id FROM `sd` where city='Wallace' && SIC_code='7011'DB:business_master_new
loadtime:1.0967111587524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wanblee' limit 1
loadtime:1.0967671871185 / seconds
Query Executed:select id FROM `sd` where city='Wanblee' && SIC_code='7011'DB:business_master_new
loadtime:1.0973851680756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ward' limit 1
loadtime:1.0974390506744 / seconds
Query Executed:select id FROM `sd` where city='Ward' && SIC_code='7011'DB:business_master_new
loadtime:1.0978469848633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warner' limit 1
loadtime:1.0978991985321 / seconds
Query Executed:select id FROM `sd` where city='Warner' && SIC_code='7011'DB:business_master_new
loadtime:1.0986790657043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wasta' limit 1
loadtime:1.0987300872803 / seconds
Query Executed:select id FROM `sd` where city='Wasta' && SIC_code='7011'DB:business_master_new
loadtime:1.0993239879608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watauga' limit 1
loadtime:1.0993900299072 / seconds
Query Executed:select id FROM `sd` where city='Watauga' && SIC_code='7011'DB:business_master_new
loadtime:1.0998702049255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:1.0999360084534 / seconds
Query Executed:select id FROM `sd` where city='Watertown' && SIC_code='7011'DB:business_master_new
loadtime:1.1207749843597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waubay' limit 1
loadtime:1.1208791732788 / seconds
Query Executed:select id FROM `sd` where city='Waubay' && SIC_code='7011'DB:business_master_new
loadtime:1.1233232021332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverly' limit 1
loadtime:1.1234011650085 / seconds
Query Executed:select id FROM `sd` where city='Waverly' && SIC_code='7011'DB:business_master_new
loadtime:1.1237549781799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:1.1238181591034 / seconds
Query Executed:select id FROM `sd` where city='Webster' && SIC_code='7011'DB:business_master_new
loadtime:1.1288161277771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wecota' limit 1
loadtime:1.1289110183716 / seconds
Query Executed:select id FROM `sd` where city='Wecota' && SIC_code='7011'DB:business_master_new
loadtime:1.1292850971222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworth' limit 1
loadtime:1.1293439865112 / seconds
Query Executed:select id FROM `sd` where city='Wentworth' && SIC_code='7011'DB:business_master_new
loadtime:1.1391561031342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wessington' limit 1
loadtime:1.1392261981964 / seconds
Query Executed:select id FROM `sd` where city='Wessington' && SIC_code='7011'DB:business_master_new
loadtime:1.1413240432739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wessington Spgs' limit 1
loadtime:1.1413900852203 / seconds
Query Executed:select id FROM `sd` where city='Wessington Spgs' && SIC_code='7011'DB:business_master_new
loadtime:1.1417691707611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wessington Springs' limit 1
loadtime:1.141832113266 / seconds
Query Executed:select id FROM `sd` where city='Wessington Springs' && SIC_code='7011'DB:business_master_new
loadtime:1.1452221870422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:1.1452920436859 / seconds
Query Executed:select id FROM `sd` where city='Westport' && SIC_code='7011'DB:business_master_new
loadtime:1.1460101604462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wetonka' limit 1
loadtime:1.146064043045 / seconds
Query Executed:select id FROM `sd` where city='Wetonka' && SIC_code='7011'DB:business_master_new
loadtime:1.1464681625366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wewela' limit 1
loadtime:1.1465210914612 / seconds
Query Executed:select id FROM `sd` where city='Wewela' && SIC_code='7011'DB:business_master_new
loadtime:1.1469411849976 / seconds
Query loaded from cache:select * from geodata_geocity where city='White' limit 1
loadtime:1.1469991207123 / seconds
Query Executed:select id FROM `sd` where city='White' && SIC_code='7011'DB:business_master_new
loadtime:1.1494121551514 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Lake' limit 1
loadtime:1.1494660377502 / seconds
Query Executed:select id FROM `sd` where city='White Lake' && SIC_code='7011'DB:business_master_new
loadtime:1.1516680717468 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Owl' limit 1
loadtime:1.1517372131348 / seconds
Query Executed:select id FROM `sd` where city='White Owl' && SIC_code='7011'DB:business_master_new
loadtime:1.1521651744843 / seconds
Query loaded from cache:select * from geodata_geocity where city='White River' limit 1
loadtime:1.1522190570831 / seconds
Query Executed:select id FROM `sd` where city='White River' && SIC_code='7011'DB:business_master_new
loadtime:1.1545960903168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitehorse' limit 1
loadtime:1.1546630859375 / seconds
Query Executed:select id FROM `sd` where city='Whitehorse' && SIC_code='7011'DB:business_master_new
loadtime:1.1551280021667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitewood' limit 1
loadtime:1.1551849842072 / seconds
Query Executed:select id FROM `sd` where city='Whitewood' && SIC_code='7011'DB:business_master_new
loadtime:1.1573991775513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willow Lake' limit 1
loadtime:1.1574680805206 / seconds
Query Executed:select id FROM `sd` where city='Willow Lake' && SIC_code='7011'DB:business_master_new
loadtime:1.1594190597534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmot' limit 1
loadtime:1.1594851016998 / seconds
Query Executed:select id FROM `sd` where city='Wilmot' && SIC_code='7011'DB:business_master_new
loadtime:1.1618211269379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winfred' limit 1
loadtime:1.1618740558624 / seconds
Query Executed:select id FROM `sd` where city='Winfred' && SIC_code='7011'DB:business_master_new
loadtime:1.1626989841461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winner' limit 1
loadtime:1.162750005722 / seconds
Query Executed:select id FROM `sd` where city='Winner' && SIC_code='7011'DB:business_master_new
loadtime:1.1698021888733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Witten' limit 1
loadtime:1.1698801517487 / seconds
Query Executed:select id FROM `sd` where city='Witten' && SIC_code='7011'DB:business_master_new
loadtime:1.1705181598663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolsey' limit 1
loadtime:1.1705729961395 / seconds
Query Executed:select id FROM `sd` where city='Wolsey' && SIC_code='7011'DB:business_master_new
loadtime:1.1724820137024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wood' limit 1
loadtime:1.1725370883942 / seconds
Query Executed:select id FROM `sd` where city='Wood' && SIC_code='7011'DB:business_master_new
loadtime:1.1732161045074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woonsocket' limit 1
loadtime:1.1732811927795 / seconds
Query Executed:select id FROM `sd` where city='Woonsocket' && SIC_code='7011'DB:business_master_new
loadtime:1.1764781475067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worthing' limit 1
loadtime:1.1765480041504 / seconds
Query Executed:select id FROM `sd` where city='Worthing' && SIC_code='7011'DB:business_master_new
loadtime:1.1785371303558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wounded Knee' limit 1
loadtime:1.1785900592804 / seconds
Query Executed:select id FROM `sd` where city='Wounded Knee' && SIC_code='7011'DB:business_master_new
loadtime:1.1790552139282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yale' limit 1
loadtime:1.1791081428528 / seconds
Query Executed:select id FROM `sd` where city='Yale' && SIC_code='7011'DB:business_master_new
loadtime:1.1796951293945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yankton' limit 1
loadtime:1.1797451972961 / seconds
Query Executed:select id FROM `sd` where city='Yankton' && SIC_code='7011'DB:business_master_new
loadtime:1.1900730133057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zell' limit 1
loadtime:1.1901609897614 / seconds
Query Executed:select id FROM `sd` where city='Zell' && SIC_code='7011'DB:business_master_new
loadtime:1.1904971599579 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.1906540393829 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.1911079883575 / seconds
Operation template executed (chunk cache operation)
loadtime:1.1912732124329 / seconds
template override:Default
loadtime:1.1913151741028 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:1.1926820278168 / seconds
Template Constructed, Array Rows:49
loadtime:1.1932229995728 / seconds
TOTAL EXECUTION TIME: 1.19277
loadtime:1.1950170993805 / 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] => hotels-and-motels [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:1.1950271129608
TOTAL KEY ARRAYS: 69