Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:5.4836273193359E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0003819465637207 / seconds
host not found setting manual db connection
loadtime:0.00063395500183105 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00089788436889648 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0010159015655518 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0010600090026855 / seconds
zipcode:
loadtime:0.0010769367218018 / seconds
Query Executed:select * from search_referrer where page_hash='6b547a9d8e65617e0dca63983db4618d' limit 10 DB:ezrox_toadli
loadtime:0.0012519359588623 / seconds
Operation header executed (non global)
loadtime:0.0012688636779785 / seconds
Operation leaderboard executed (non global)
loadtime:0.0013089179992676 / seconds
Operation square executed (non global)
loadtime:0.0013279914855957 / seconds
Operation square_bottom executed (non global)
loadtime:0.0013399124145508 / seconds
Operation smallsquare executed (non global)
loadtime:0.0013518333435059 / seconds
Operation headeradright executed (non global)
loadtime:0.0013628005981445 / seconds
Operation google_analytics executed (non global)
loadtime:0.0013740062713623 / seconds
Operation topstories executed (non global)
loadtime:0.001384973526001 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0013959407806396 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0014069080352783 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0016248226165771 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.00177001953125 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0018079280853271 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0018608570098877 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0018999576568604 / seconds
Template key: archive_menu pushed
loadtime:0.0019059181213379 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0019118785858154 / seconds
Template key: get_gravatar pushed
loadtime:0.0019149780273438 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0019199848175049 / seconds
*10)-10)+1 | start:0
loadtime:0.0019419193267822 / seconds
Query loaded from cache:select * from categories where cat_URLid='beauty-shops'
loadtime:0.0019698143005371 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='south-carolina'
loadtime:0.0019989013671875 / seconds
DB connected to localhost business_master_new
loadtime:0.0022258758544922 / seconds
Query Executed:select * from `sc_catmap` where sic='7231' order by city ascDB:business_master_new
loadtime:0.030215978622437 / seconds
Query stored in cache : _QUERY_www.toadli.com491d7c6e2a0efecfa476bc3a9060c5a2
loadtime:0.030896902084351 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='south-carolina'
loadtime:0.03092885017395 / seconds
Query Executed:select sum(totalcount) as totalsum from `sc_catmap` where sic='7231'DB:business_master_new
loadtime:0.033350944519043 / seconds
Query stored in cache : _QUERY_www.toadli.comfb9e08687198df7f7728778a02ee6d34
loadtime:0.033387899398804 / seconds
420 / 11
loadtime:0.03342080116272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abbeville' limit 1
loadtime:0.033464908599854 / seconds
Query Executed:select id FROM `sc` where city='Abbeville' && SIC_code='7231'DB:business_master_new
loadtime:0.036468982696533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adams Run' limit 1
loadtime:0.036540031433105 / seconds
Query Executed:select id FROM `sc` where city='Adams Run' && SIC_code='7231'DB:business_master_new
loadtime:0.037108898162842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aiken' limit 1
loadtime:0.037156820297241 / seconds
Query Executed:select id FROM `sc` where city='Aiken' && SIC_code='7231'DB:business_master_new
loadtime:0.040453910827637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alcolu' limit 1
loadtime:0.04054594039917 / seconds
Query Executed:select id FROM `sc` where city='Alcolu' && SIC_code='7231'DB:business_master_new
loadtime:0.041415929794312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allendale' limit 1
loadtime:0.041473865509033 / seconds
Query Executed:select id FROM `sc` where city='Allendale' && SIC_code='7231'DB:business_master_new
loadtime:0.043102025985718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alvin' limit 1
loadtime:0.043162822723389 / seconds
Query Executed:select id FROM `sc` where city='Alvin' && SIC_code='7231'DB:business_master_new
loadtime:0.043437004089355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anderson' limit 1
loadtime:0.043476819992065 / seconds
Query Executed:select id FROM `sc` where city='Anderson' && SIC_code='7231'DB:business_master_new
loadtime:0.047417879104614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andrews' limit 1
loadtime:0.04751992225647 / seconds
Query Executed:select id FROM `sc` where city='Andrews' && SIC_code='7231'DB:business_master_new
loadtime:0.049211025238037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcadia' limit 1
loadtime:0.049273014068604 / seconds
Query Executed:select id FROM `sc` where city='Arcadia' && SIC_code='7231'DB:business_master_new
loadtime:0.049646854400635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic Beach' limit 1
loadtime:0.049700975418091 / seconds
Query Executed:select id FROM `sc` where city='Atlantic Beach' && SIC_code='7231'DB:business_master_new
loadtime:0.049957036972046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Awendaw' limit 1
loadtime:0.049983024597168 / seconds
Query Executed:select id FROM `sc` where city='Awendaw' && SIC_code='7231'DB:business_master_new
loadtime:0.051009893417358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aynor' limit 1
loadtime:0.051069021224976 / seconds
Query Executed:select id FROM `sc` where city='Aynor' && SIC_code='7231'DB:business_master_new
loadtime:0.052657842636108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ballentine' limit 1
loadtime:0.052718877792358 / seconds
Query Executed:select id FROM `sc` where city='Ballentine' && SIC_code='7231'DB:business_master_new
loadtime:0.053318023681641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bamberg' limit 1
loadtime:0.053364992141724 / seconds
Query Executed:select id FROM `sc` where city='Bamberg' && SIC_code='7231'DB:business_master_new
loadtime:0.055052995681763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnwell' limit 1
loadtime:0.055117845535278 / seconds
Query Executed:select id FROM `sc` where city='Barnwell' && SIC_code='7231'DB:business_master_new
loadtime:0.057015895843506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Batesburg' limit 1
loadtime:0.057077884674072 / seconds
Query Executed:select id FROM `sc` where city='Batesburg' && SIC_code='7231'DB:business_master_new
loadtime:0.058832883834839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.058897018432617 / seconds
Query Executed:select id FROM `sc` where city='Bath' && SIC_code='7231'DB:business_master_new
loadtime:0.059424877166748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaufort' limit 1
loadtime:0.059468030929565 / seconds
Query Executed:select id FROM `sc` where city='Beaufort' && SIC_code='7231'DB:business_master_new
loadtime:0.062314033508301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beech Island' limit 1
loadtime:0.062397003173828 / seconds
Query Executed:select id FROM `sc` where city='Beech Island' && SIC_code='7231'DB:business_master_new
loadtime:0.063977003097534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belton' limit 1
loadtime:0.064039945602417 / seconds
Query Executed:select id FROM `sc` where city='Belton' && SIC_code='7231'DB:business_master_new
loadtime:0.0659019947052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvedere' limit 1
loadtime:0.065960884094238 / seconds
Query Executed:select id FROM `sc` where city='Belvedere' && SIC_code='7231'DB:business_master_new
loadtime:0.066210985183716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennettsville' limit 1
loadtime:0.066252946853638 / seconds
Query Executed:select id FROM `sc` where city='Bennettsville' && SIC_code='7231'DB:business_master_new
loadtime:0.068181991577148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethera' limit 1
loadtime:0.068238973617554 / seconds
Query Executed:select id FROM `sc` where city='Bethera' && SIC_code='7231'DB:business_master_new
loadtime:0.068533897399902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethune' limit 1
loadtime:0.068578004837036 / seconds
Query Executed:select id FROM `sc` where city='Bethune' && SIC_code='7231'DB:business_master_new
loadtime:0.069731950759888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bishopville' limit 1
loadtime:0.069792032241821 / seconds
Query Executed:select id FROM `sc` where city='Bishopville' && SIC_code='7231'DB:business_master_new
loadtime:0.07161283493042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blacksburg' limit 1
loadtime:0.071682929992676 / seconds
Query Executed:select id FROM `sc` where city='Blacksburg' && SIC_code='7231'DB:business_master_new
loadtime:0.07335090637207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackstock' limit 1
loadtime:0.073421001434326 / seconds
Query Executed:select id FROM `sc` where city='Blackstock' && SIC_code='7231'DB:business_master_new
loadtime:0.073951005935669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackville' limit 1
loadtime:0.074000835418701 / seconds
Query Executed:select id FROM `sc` where city='Blackville' && SIC_code='7231'DB:business_master_new
loadtime:0.075605869293213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blair' limit 1
loadtime:0.075665950775146 / seconds
Query Executed:select id FROM `sc` where city='Blair' && SIC_code='7231'DB:business_master_new
loadtime:0.076143980026245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blenheim' limit 1
loadtime:0.076191902160645 / seconds
Query Executed:select id FROM `sc` where city='Blenheim' && SIC_code='7231'DB:business_master_new
loadtime:0.076709032058716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluffton' limit 1
loadtime:0.076766014099121 / seconds
Query Executed:select id FROM `sc` where city='Bluffton' && SIC_code='7231'DB:business_master_new
loadtime:0.079026937484741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blythewood' limit 1
loadtime:0.079085826873779 / seconds
Query Executed:select id FROM `sc` where city='Blythewood' && SIC_code='7231'DB:business_master_new
loadtime:0.080801963806152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boiling Springs' limit 1
loadtime:0.080869913101196 / seconds
Query Executed:select id FROM `sc` where city='Boiling Springs' && SIC_code='7231'DB:business_master_new
loadtime:0.082791805267334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonneau' limit 1
loadtime:0.082851886749268 / seconds
Query Executed:select id FROM `sc` where city='Bonneau' && SIC_code='7231'DB:business_master_new
loadtime:0.084115982055664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowling Green' limit 1
loadtime:0.084172010421753 / seconds
Query Executed:select id FROM `sc` where city='Bowling Green' && SIC_code='7231'DB:business_master_new
loadtime:0.08453893661499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowman' limit 1
loadtime:0.08458399772644 / seconds
Query Executed:select id FROM `sc` where city='Bowman' && SIC_code='7231'DB:business_master_new
loadtime:0.085837841033936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradley' limit 1
loadtime:0.085893869400024 / seconds
Query Executed:select id FROM `sc` where city='Bradley' && SIC_code='7231'DB:business_master_new
loadtime:0.086403846740723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branchville' limit 1
loadtime:0.086440801620483 / seconds
Query Executed:select id FROM `sc` where city='Branchville' && SIC_code='7231'DB:business_master_new
loadtime:0.087261915206909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brunson' limit 1
loadtime:0.087340831756592 / seconds
Query Executed:select id FROM `sc` where city='Brunson' && SIC_code='7231'DB:business_master_new
loadtime:0.087852954864502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bucksport' limit 1
loadtime:0.087903022766113 / seconds
Query Executed:select id FROM `sc` where city='Bucksport' && SIC_code='7231'DB:business_master_new
loadtime:0.088145017623901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo' limit 1
loadtime:0.08817982673645 / seconds
Query Executed:select id FROM `sc` where city='Buffalo' && SIC_code='7231'DB:business_master_new
loadtime:0.08885383605957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cades' limit 1
loadtime:0.088902950286865 / seconds
Query Executed:select id FROM `sc` where city='Cades' && SIC_code='7231'DB:business_master_new
loadtime:0.089602947235107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calhoun Falls' limit 1
loadtime:0.089660882949829 / seconds
Query Executed:select id FROM `sc` where city='Calhoun Falls' && SIC_code='7231'DB:business_master_new
loadtime:0.090646028518677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camden' limit 1
loadtime:0.090703010559082 / seconds
Query Executed:select id FROM `sc` where city='Camden' && SIC_code='7231'DB:business_master_new
loadtime:0.092926979064941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cameron' limit 1
loadtime:0.093001842498779 / seconds
Query Executed:select id FROM `sc` where city='Cameron' && SIC_code='7231'DB:business_master_new
loadtime:0.093987941741943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Campobello' limit 1
loadtime:0.094048976898193 / seconds
Query Executed:select id FROM `sc` where city='Campobello' && SIC_code='7231'DB:business_master_new
loadtime:0.095580816268921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canadys' limit 1
loadtime:0.095639944076538 / seconds
Query Executed:select id FROM `sc` where city='Canadys' && SIC_code='7231'DB:business_master_new
loadtime:0.095985889434814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlisle' limit 1
loadtime:0.096029996871948 / seconds
Query Executed:select id FROM `sc` where city='Carlisle' && SIC_code='7231'DB:business_master_new
loadtime:0.096619844436646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cassatt' limit 1
loadtime:0.096683025360107 / seconds
Query Executed:select id FROM `sc` where city='Cassatt' && SIC_code='7231'DB:business_master_new
loadtime:0.097402811050415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catawba' limit 1
loadtime:0.097461938858032 / seconds
Query Executed:select id FROM `sc` where city='Catawba' && SIC_code='7231'DB:business_master_new
loadtime:0.098253965377808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cayce' limit 1
loadtime:0.098315000534058 / seconds
Query Executed:select id FROM `sc` where city='Cayce' && SIC_code='7231'DB:business_master_new
loadtime:0.10008788108826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centenary' limit 1
loadtime:0.10014986991882 / seconds
Query Executed:select id FROM `sc` where city='Centenary' && SIC_code='7231'DB:business_master_new
loadtime:0.10045289993286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central' limit 1
loadtime:0.10049295425415 / seconds
Query Executed:select id FROM `sc` where city='Central' && SIC_code='7231'DB:business_master_new
loadtime:0.10210180282593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chapin' limit 1
loadtime:0.10216188430786 / seconds
Query Executed:select id FROM `sc` where city='Chapin' && SIC_code='7231'DB:business_master_new
loadtime:0.10395097732544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chappells' limit 1
loadtime:0.10399699211121 / seconds
Query Executed:select id FROM `sc` where city='Chappells' && SIC_code='7231'DB:business_master_new
loadtime:0.10440397262573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charleston' limit 1
loadtime:0.10445094108582 / seconds
Query Executed:select id FROM `sc` where city='Charleston' && SIC_code='7231'DB:business_master_new
loadtime:0.11080193519592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charleston Afb' limit 1
loadtime:0.11094689369202 / seconds
Query Executed:select id FROM `sc` where city='Charleston Afb' && SIC_code='7231'DB:business_master_new
loadtime:0.11152982711792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheraw' limit 1
loadtime:0.11158585548401 / seconds
Query Executed:select id FROM `sc` where city='Cheraw' && SIC_code='7231'DB:business_master_new
loadtime:0.11351299285889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Grove Bch' limit 1
loadtime:0.11357092857361 / seconds
Query Executed:select id FROM `sc` where city='Cherry Grove Bch' && SIC_code='7231'DB:business_master_new
loadtime:0.11382484436035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesnee' limit 1
loadtime:0.11386895179749 / seconds
Query Executed:select id FROM `sc` where city='Chesnee' && SIC_code='7231'DB:business_master_new
loadtime:0.11555290222168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.11561584472656 / seconds
Query Executed:select id FROM `sc` where city='Chester' && SIC_code='7231'DB:business_master_new
loadtime:0.11779189109802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:0.11786198616028 / seconds
Query Executed:select id FROM `sc` where city='Chesterfield' && SIC_code='7231'DB:business_master_new
loadtime:0.11960983276367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarks Hill' limit 1
loadtime:0.11967587471008 / seconds
Query Executed:select id FROM `sc` where city='Clarks Hill' && SIC_code='7231'DB:business_master_new
loadtime:0.12025594711304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clearwater' limit 1
loadtime:0.12031698226929 / seconds
Query Executed:select id FROM `sc` where city='Clearwater' && SIC_code='7231'DB:business_master_new
loadtime:0.12099480628967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clemson' limit 1
loadtime:0.12104797363281 / seconds
Query Executed:select id FROM `sc` where city='Clemson' && SIC_code='7231'DB:business_master_new
loadtime:0.12291288375854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.12297892570496 / seconds
Query Executed:select id FROM `sc` where city='Cleveland' && SIC_code='7231'DB:business_master_new
loadtime:0.12359094619751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:0.12363886833191 / seconds
Query Executed:select id FROM `sc` where city='Clifton' && SIC_code='7231'DB:business_master_new
loadtime:0.12397384643555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.12401700019836 / seconds
Query Executed:select id FROM `sc` where city='Clinton' && SIC_code='7231'DB:business_master_new
loadtime:0.12593984603882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clio' limit 1
loadtime:0.12600588798523 / seconds
Query Executed:select id FROM `sc` where city='Clio' && SIC_code='7231'DB:business_master_new
loadtime:0.12682485580444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clover' limit 1
loadtime:0.12689685821533 / seconds
Query Executed:select id FROM `sc` where city='Clover' && SIC_code='7231'DB:business_master_new
loadtime:0.12898802757263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.12905097007751 / seconds
Query Executed:select id FROM `sc` where city='Columbia' && SIC_code='7231'DB:business_master_new
loadtime:0.13874101638794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conestee' limit 1
loadtime:0.13898801803589 / seconds
Query Executed:select id FROM `sc` where city='Conestee' && SIC_code='7231'DB:business_master_new
loadtime:0.13935303688049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Converse' limit 1
loadtime:0.13940286636353 / seconds
Query Executed:select id FROM `sc` where city='Converse' && SIC_code='7231'DB:business_master_new
loadtime:0.1397488117218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.13979387283325 / seconds
Query Executed:select id FROM `sc` where city='Conway' && SIC_code='7231'DB:business_master_new
loadtime:0.14276385307312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coosawatchie' limit 1
loadtime:0.14284992218018 / seconds
Query Executed:select id FROM `sc` where city='Coosawatchie' && SIC_code='7231'DB:business_master_new
loadtime:0.14311981201172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cope' limit 1
loadtime:0.14316201210022 / seconds
Query Executed:select id FROM `sc` where city='Cope' && SIC_code='7231'DB:business_master_new
loadtime:0.14398598670959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cordesville' limit 1
loadtime:0.14403700828552 / seconds
Query Executed:select id FROM `sc` where city='Cordesville' && SIC_code='7231'DB:business_master_new
loadtime:0.14449286460876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cordova' limit 1
loadtime:0.14453983306885 / seconds
Query Executed:select id FROM `sc` where city='Cordova' && SIC_code='7231'DB:business_master_new
loadtime:0.14533495903015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottageville' limit 1
loadtime:0.14539289474487 / seconds
Query Executed:select id FROM `sc` where city='Cottageville' && SIC_code='7231'DB:business_master_new
loadtime:0.14651679992676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coward' limit 1
loadtime:0.1465790271759 / seconds
Query Executed:select id FROM `sc` where city='Coward' && SIC_code='7231'DB:business_master_new
loadtime:0.14767980575562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cowpens' limit 1
loadtime:0.14772796630859 / seconds
Query Executed:select id FROM `sc` where city='Cowpens' && SIC_code='7231'DB:business_master_new
loadtime:0.14932990074158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crocketville' limit 1
loadtime:0.14939093589783 / seconds
Query Executed:select id FROM `sc` where city='Crocketville' && SIC_code='7231'DB:business_master_new
loadtime:0.14965486526489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross' limit 1
loadtime:0.14968585968018 / seconds
Query Executed:select id FROM `sc` where city='Cross' && SIC_code='7231'DB:business_master_new
loadtime:0.15073800086975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross Anchor' limit 1
loadtime:0.15079593658447 / seconds
Query Executed:select id FROM `sc` where city='Cross Anchor' && SIC_code='7231'DB:business_master_new
loadtime:0.15109395980835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross Hill' limit 1
loadtime:0.15112590789795 / seconds
Query Executed:select id FROM `sc` where city='Cross Hill' && SIC_code='7231'DB:business_master_new
loadtime:0.15190887451172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dale' limit 1
loadtime:0.15196490287781 / seconds
Query Executed:select id FROM `sc` where city='Dale' && SIC_code='7231'DB:business_master_new
loadtime:0.15223097801208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dalzell' limit 1
loadtime:0.15227293968201 / seconds
Query Executed:select id FROM `sc` where city='Dalzell' && SIC_code='7231'DB:business_master_new
loadtime:0.15380382537842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daniel Island' limit 1
loadtime:0.15386295318604 / seconds
Query Executed:select id FROM `sc` where city='Daniel Island' && SIC_code='7231'DB:business_master_new
loadtime:0.15411686897278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darlington' limit 1
loadtime:0.15415692329407 / seconds
Query Executed:select id FROM `sc` where city='Darlington' && SIC_code='7231'DB:business_master_new
loadtime:0.15631699562073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daufuskie Island' limit 1
loadtime:0.15639090538025 / seconds
Query Executed:select id FROM `sc` where city='Daufuskie Island' && SIC_code='7231'DB:business_master_new
loadtime:0.1567850112915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis Station' limit 1
loadtime:0.15683603286743 / seconds
Query Executed:select id FROM `sc` where city='Davis Station' && SIC_code='7231'DB:business_master_new
loadtime:0.15719795227051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denmark' limit 1
loadtime:0.15723490715027 / seconds
Query Executed:select id FROM `sc` where city='Denmark' && SIC_code='7231'DB:business_master_new
loadtime:0.15882086753845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewees Island' limit 1
loadtime:0.15887403488159 / seconds
Query Executed:select id FROM `sc` where city='Dewees Island' && SIC_code='7231'DB:business_master_new
loadtime:0.15911197662354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dillon' limit 1
loadtime:0.1591579914093 / seconds
Query Executed:select id FROM `sc` where city='Dillon' && SIC_code='7231'DB:business_master_new
loadtime:0.16123795509338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Donalds' limit 1
loadtime:0.16132402420044 / seconds
Query Executed:select id FROM `sc` where city='Donalds' && SIC_code='7231'DB:business_master_new
loadtime:0.16213297843933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:0.1621949672699 / seconds
Query Executed:select id FROM `sc` where city='Dorchester' && SIC_code='7231'DB:business_master_new
loadtime:0.16281485557556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drayton' limit 1
loadtime:0.16287183761597 / seconds
Query Executed:select id FROM `sc` where city='Drayton' && SIC_code='7231'DB:business_master_new
loadtime:0.16340398788452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Due West' limit 1
loadtime:0.16343688964844 / seconds
Query Executed:select id FROM `sc` where city='Due West' && SIC_code='7231'DB:business_master_new
loadtime:0.16407299041748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duncan' limit 1
loadtime:0.16413283348083 / seconds
Query Executed:select id FROM `sc` where city='Duncan' && SIC_code='7231'DB:business_master_new
loadtime:0.16591596603394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Early Branch' limit 1
loadtime:0.1659848690033 / seconds
Query Executed:select id FROM `sc` where city='Early Branch' && SIC_code='7231'DB:business_master_new
loadtime:0.16642093658447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easley' limit 1
loadtime:0.16645693778992 / seconds
Query Executed:select id FROM `sc` where city='Easley' && SIC_code='7231'DB:business_master_new
loadtime:0.16912293434143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastover' limit 1
loadtime:0.16920781135559 / seconds
Query Executed:select id FROM `sc` where city='Eastover' && SIC_code='7231'DB:business_master_new
loadtime:0.17075085639954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgefield' limit 1
loadtime:0.170814037323 / seconds
Query Executed:select id FROM `sc` where city='Edgefield' && SIC_code='7231'DB:business_master_new
loadtime:0.17245602607727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgemoor' limit 1
loadtime:0.17251801490784 / seconds
Query Executed:select id FROM `sc` where city='Edgemoor' && SIC_code='7231'DB:business_master_new
loadtime:0.17350292205811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edisto Island' limit 1
loadtime:0.17355489730835 / seconds
Query Executed:select id FROM `sc` where city='Edisto Island' && SIC_code='7231'DB:business_master_new
loadtime:0.17512392997742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Effingham' limit 1
loadtime:0.17518186569214 / seconds
Query Executed:select id FROM `sc` where city='Effingham' && SIC_code='7231'DB:business_master_new
loadtime:0.17676281929016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ehrhardt' limit 1
loadtime:0.17682480812073 / seconds
Query Executed:select id FROM `sc` where city='Ehrhardt' && SIC_code='7231'DB:business_master_new
loadtime:0.17777180671692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elgin' limit 1
loadtime:0.17782688140869 / seconds
Query Executed:select id FROM `sc` where city='Elgin' && SIC_code='7231'DB:business_master_new
loadtime:0.17948794364929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elko' limit 1
loadtime:0.17954897880554 / seconds
Query Executed:select id FROM `sc` where city='Elko' && SIC_code='7231'DB:business_master_new
loadtime:0.17997193336487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elliott' limit 1
loadtime:0.18002986907959 / seconds
Query Executed:select id FROM `sc` where city='Elliott' && SIC_code='7231'DB:business_master_new
loadtime:0.18034601211548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elloree' limit 1
loadtime:0.18037986755371 / seconds
Query Executed:select id FROM `sc` where city='Elloree' && SIC_code='7231'DB:business_master_new
loadtime:0.18167090415955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enoree' limit 1
loadtime:0.18172788619995 / seconds
Query Executed:select id FROM `sc` where city='Enoree' && SIC_code='7231'DB:business_master_new
loadtime:0.18281984329224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estill' limit 1
loadtime:0.18286991119385 / seconds
Query Executed:select id FROM `sc` where city='Estill' && SIC_code='7231'DB:business_master_new
loadtime:0.18445587158203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eutawville' limit 1
loadtime:0.18451881408691 / seconds
Query Executed:select id FROM `sc` where city='Eutawville' && SIC_code='7231'DB:business_master_new
loadtime:0.18607902526855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Play' limit 1
loadtime:0.18613982200623 / seconds
Query Executed:select id FROM `sc` where city='Fair Play' && SIC_code='7231'DB:business_master_new
loadtime:0.18730902671814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.18736600875854 / seconds
Query Executed:select id FROM `sc` where city='Fairfax' && SIC_code='7231'DB:business_master_new
loadtime:0.18892693519592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairforest' limit 1
loadtime:0.18897986412048 / seconds
Query Executed:select id FROM `sc` where city='Fairforest' && SIC_code='7231'DB:business_master_new
loadtime:0.18945288658142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fingerville' limit 1
loadtime:0.18949890136719 / seconds
Query Executed:select id FROM `sc` where city='Fingerville' && SIC_code='7231'DB:business_master_new
loadtime:0.18986392021179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.18990993499756 / seconds
Query Executed:select id FROM `sc` where city='Florence' && SIC_code='7231'DB:business_master_new
loadtime:0.19395589828491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Folly Beach' limit 1
loadtime:0.19406485557556 / seconds
Query Executed:select id FROM `sc` where city='Folly Beach' && SIC_code='7231'DB:business_master_new
loadtime:0.19528102874756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fork' limit 1
loadtime:0.19534683227539 / seconds
Query Executed:select id FROM `sc` where city='Fork' && SIC_code='7231'DB:business_master_new
loadtime:0.19576287269592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Lawn' limit 1
loadtime:0.19581890106201 / seconds
Query Executed:select id FROM `sc` where city='Fort Lawn' && SIC_code='7231'DB:business_master_new
loadtime:0.19672799110413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mill' limit 1
loadtime:0.19678783416748 / seconds
Query Executed:select id FROM `sc` where city='Fort Mill' && SIC_code='7231'DB:business_master_new
loadtime:0.19912481307983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Motte' limit 1
loadtime:0.19919395446777 / seconds
Query Executed:select id FROM `sc` where city='Fort Motte' && SIC_code='7231'DB:business_master_new
loadtime:0.19949388504028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain Inn' limit 1
loadtime:0.19952297210693 / seconds
Query Executed:select id FROM `sc` where city='Fountain Inn' && SIC_code='7231'DB:business_master_new
loadtime:0.20131587982178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frogmore' limit 1
loadtime:0.20137882232666 / seconds
Query Executed:select id FROM `sc` where city='Frogmore' && SIC_code='7231'DB:business_master_new
loadtime:0.20163583755493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Furman' limit 1
loadtime:0.20167088508606 / seconds
Query Executed:select id FROM `sc` where city='Furman' && SIC_code='7231'DB:business_master_new
loadtime:0.20207095146179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gable' limit 1
loadtime:0.20212388038635 / seconds
Query Executed:select id FROM `sc` where city='Gable' && SIC_code='7231'DB:business_master_new
loadtime:0.20263481140137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gadsden' limit 1
loadtime:0.20268392562866 / seconds
Query Executed:select id FROM `sc` where city='Gadsden' && SIC_code='7231'DB:business_master_new
loadtime:0.20324397087097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaffney' limit 1
loadtime:0.20331788063049 / seconds
Query Executed:select id FROM `sc` where city='Gaffney' && SIC_code='7231'DB:business_master_new
loadtime:0.20576000213623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galivants Ferry' limit 1
loadtime:0.20582985877991 / seconds
Query Executed:select id FROM `sc` where city='Galivants Ferry' && SIC_code='7231'DB:business_master_new
loadtime:0.20710492134094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garnett' limit 1
loadtime:0.20716381072998 / seconds
Query Executed:select id FROM `sc` where city='Garnett' && SIC_code='7231'DB:business_master_new
loadtime:0.20764684677124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaston' limit 1
loadtime:0.20769500732422 / seconds
Query Executed:select id FROM `sc` where city='Gaston' && SIC_code='7231'DB:business_master_new
loadtime:0.20932984352112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:0.20938587188721 / seconds
Query Executed:select id FROM `sc` where city='Georgetown' && SIC_code='7231'DB:business_master_new
loadtime:0.2117919921875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gifford' limit 1
loadtime:0.21186590194702 / seconds
Query Executed:select id FROM `sc` where city='Gifford' && SIC_code='7231'DB:business_master_new
loadtime:0.2122049331665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbert' limit 1
loadtime:0.21224284172058 / seconds
Query Executed:select id FROM `sc` where city='Gilbert' && SIC_code='7231'DB:business_master_new
loadtime:0.21386885643005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1
loadtime:0.21392583847046 / seconds
Query Executed:select id FROM `sc` where city='Glendale' && SIC_code='7231'DB:business_master_new
loadtime:0.21425986289978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenn Springs' limit 1
loadtime:0.21430993080139 / seconds
Query Executed:select id FROM `sc` where city='Glenn Springs' && SIC_code='7231'DB:business_master_new
loadtime:0.2145369052887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloverville' limit 1
loadtime:0.2145688533783 / seconds
Query Executed:select id FROM `sc` where city='Gloverville' && SIC_code='7231'DB:business_master_new
loadtime:0.21508884429932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goose Creek' limit 1
loadtime:0.21514201164246 / seconds
Query Executed:select id FROM `sc` where city='Goose Creek' && SIC_code='7231'DB:business_master_new
loadtime:0.21730995178223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gramling' limit 1
loadtime:0.21737384796143 / seconds
Query Executed:select id FROM `sc` where city='Gramling' && SIC_code='7231'DB:business_master_new
loadtime:0.21778202056885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graniteville' limit 1
loadtime:0.21783590316772 / seconds
Query Executed:select id FROM `sc` where city='Graniteville' && SIC_code='7231'DB:business_master_new
loadtime:0.21939587593079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gray Court' limit 1
loadtime:0.21945786476135 / seconds
Query Executed:select id FROM `sc` where city='Gray Court' && SIC_code='7231'DB:business_master_new
loadtime:0.22107100486755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Falls' limit 1
loadtime:0.22112703323364 / seconds
Query Executed:select id FROM `sc` where city='Great Falls' && SIC_code='7231'DB:business_master_new
loadtime:0.22273302078247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greeleyville' limit 1
loadtime:0.22277903556824 / seconds
Query Executed:select id FROM `sc` where city='Greeleyville' && SIC_code='7231'DB:business_master_new
loadtime:0.22378587722778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Pond' limit 1
loadtime:0.22384691238403 / seconds
Query Executed:select id FROM `sc` where city='Green Pond' && SIC_code='7231'DB:business_master_new
loadtime:0.22463893890381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Sea' limit 1
loadtime:0.22469091415405 / seconds
Query Executed:select id FROM `sc` where city='Green Sea' && SIC_code='7231'DB:business_master_new
loadtime:0.22533488273621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.22538089752197 / seconds
Query Executed:select id FROM `sc` where city='Greenville' && SIC_code='7231'DB:business_master_new
loadtime:0.23346090316772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood' limit 1
loadtime:0.23364281654358 / seconds
Query Executed:select id FROM `sc` where city='Greenwood' && SIC_code='7231'DB:business_master_new
loadtime:0.23680591583252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greer' limit 1
loadtime:0.2369019985199 / seconds
Query Executed:select id FROM `sc` where city='Greer' && SIC_code='7231'DB:business_master_new
loadtime:0.23984384536743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gresham' limit 1
loadtime:0.23992085456848 / seconds
Query Executed:select id FROM `sc` where city='Gresham' && SIC_code='7231'DB:business_master_new
loadtime:0.24068784713745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grover' limit 1
loadtime:0.24076080322266 / seconds
Query Executed:select id FROM `sc` where city='Grover' && SIC_code='7231'DB:business_master_new
loadtime:0.24100685119629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamer' limit 1
loadtime:0.24104380607605 / seconds
Query Executed:select id FROM `sc` where city='Hamer' && SIC_code='7231'DB:business_master_new
loadtime:0.24172401428223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:0.24178290367126 / seconds
Query Executed:select id FROM `sc` where city='Hampton' && SIC_code='7231'DB:business_master_new
loadtime:0.24355602264404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanahan' limit 1
loadtime:0.24360680580139 / seconds
Query Executed:select id FROM `sc` where city='Hanahan' && SIC_code='7231'DB:business_master_new
loadtime:0.24528002738953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardeeville' limit 1
loadtime:0.24535584449768 / seconds
Query Executed:select id FROM `sc` where city='Hardeeville' && SIC_code='7231'DB:business_master_new
loadtime:0.24704194068909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harleyville' limit 1
loadtime:0.24709796905518 / seconds
Query Executed:select id FROM `sc` where city='Harleyville' && SIC_code='7231'DB:business_master_new
loadtime:0.24822092056274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartsville' limit 1
loadtime:0.24827694892883 / seconds
Query Executed:select id FROM `sc` where city='Hartsville' && SIC_code='7231'DB:business_master_new
loadtime:0.25076699256897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heath Springs' limit 1
loadtime:0.25084686279297 / seconds
Query Executed:select id FROM `sc` where city='Heath Springs' && SIC_code='7231'DB:business_master_new
loadtime:0.25210189819336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hemingway' limit 1
loadtime:0.25215291976929 / seconds
Query Executed:select id FROM `sc` where city='Hemingway' && SIC_code='7231'DB:business_master_new
loadtime:0.25391983985901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hickory Grove' limit 1
loadtime:0.25397992134094 / seconds
Query Executed:select id FROM `sc` where city='Hickory Grove' && SIC_code='7231'DB:business_master_new
loadtime:0.25452089309692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hilda' limit 1
loadtime:0.25456285476685 / seconds
Query Executed:select id FROM `sc` where city='Hilda' && SIC_code='7231'DB:business_master_new
loadtime:0.25489497184753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hilton Head Island' limit 1
loadtime:0.25493097305298 / seconds
Query Executed:select id FROM `sc` where city='Hilton Head Island' && SIC_code='7231'DB:business_master_new
loadtime:0.25870585441589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hilton Head Isle' limit 1
loadtime:0.25879192352295 / seconds
Query Executed:select id FROM `sc` where city='Hilton Head Isle' && SIC_code='7231'DB:business_master_new
loadtime:0.26040983200073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hodges' limit 1
loadtime:0.26045680046082 / seconds
Query Executed:select id FROM `sc` where city='Hodges' && SIC_code='7231'DB:business_master_new
loadtime:0.26178002357483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Hill' limit 1
loadtime:0.26183986663818 / seconds
Query Executed:select id FROM `sc` where city='Holly Hill' && SIC_code='7231'DB:business_master_new
loadtime:0.26347994804382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollywood' limit 1
loadtime:0.26353287696838 / seconds
Query Executed:select id FROM `sc` where city='Hollywood' && SIC_code='7231'DB:business_master_new
loadtime:0.26518487930298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honea Path' limit 1
loadtime:0.26524686813354 / seconds
Query Executed:select id FROM `sc` where city='Honea Path' && SIC_code='7231'DB:business_master_new
loadtime:0.26688098907471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkins' limit 1
loadtime:0.26693797111511 / seconds
Query Executed:select id FROM `sc` where city='Hopkins' && SIC_code='7231'DB:business_master_new
loadtime:0.26852488517761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horatio' limit 1
loadtime:0.2685878276825 / seconds
Query Executed:select id FROM `sc` where city='Horatio' && SIC_code='7231'DB:business_master_new
loadtime:0.26894593238831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huger' limit 1
loadtime:0.26899600028992 / seconds
Query Executed:select id FROM `sc` where city='Huger' && SIC_code='7231'DB:business_master_new
loadtime:0.26996183395386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Inman' limit 1
loadtime:0.27002000808716 / seconds
Query Executed:select id FROM `sc` where city='Inman' && SIC_code='7231'DB:business_master_new
loadtime:0.27199101448059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irmo' limit 1
loadtime:0.27205181121826 / seconds
Query Executed:select id FROM `sc` where city='Irmo' && SIC_code='7231'DB:business_master_new
loadtime:0.27425503730774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Islandton' limit 1
loadtime:0.27433681488037 / seconds
Query Executed:select id FROM `sc` where city='Islandton' && SIC_code='7231'DB:business_master_new
loadtime:0.27494692802429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isle Of Palms' limit 1
loadtime:0.27499389648438 / seconds
Query Executed:select id FROM `sc` where city='Isle Of Palms' && SIC_code='7231'DB:business_master_new
loadtime:0.27664279937744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iva' limit 1
loadtime:0.27670383453369 / seconds
Query Executed:select id FROM `sc` where city='Iva' && SIC_code='7231'DB:business_master_new
loadtime:0.27827191352844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:0.2783420085907 / seconds
Query Executed:select id FROM `sc` where city='Jackson' && SIC_code='7231'DB:business_master_new
loadtime:0.27934503555298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jacksonboro' limit 1
loadtime:0.27939581871033 / seconds
Query Executed:select id FROM `sc` where city='Jacksonboro' && SIC_code='7231'DB:business_master_new
loadtime:0.27984595298767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:0.27989602088928 / seconds
Query Executed:select id FROM `sc` where city='Jamestown' && SIC_code='7231'DB:business_master_new
loadtime:0.28050398826599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:0.28055191040039 / seconds
Query Executed:select id FROM `sc` where city='Jefferson' && SIC_code='7231'DB:business_master_new
loadtime:0.28215289115906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jenkinsville' limit 1
loadtime:0.28221487998962 / seconds
Query Executed:select id FROM `sc` where city='Jenkinsville' && SIC_code='7231'DB:business_master_new
loadtime:0.28273797035217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joanna' limit 1
loadtime:0.28278589248657 / seconds
Query Executed:select id FROM `sc` where city='Joanna' && SIC_code='7231'DB:business_master_new
loadtime:0.28338599205017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johns Island' limit 1
loadtime:0.28344798088074 / seconds
Query Executed:select id FROM `sc` where city='Johns Island' && SIC_code='7231'DB:business_master_new
loadtime:0.28535199165344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnsonville' limit 1
loadtime:0.28541398048401 / seconds
Query Executed:select id FROM `sc` where city='Johnsonville' && SIC_code='7231'DB:business_master_new
loadtime:0.28703880310059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnston' limit 1
loadtime:0.28709197044373 / seconds
Query Executed:select id FROM `sc` where city='Johnston' && SIC_code='7231'DB:business_master_new
loadtime:0.28877091407776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:0.28884983062744 / seconds
Query Executed:select id FROM `sc` where city='Jonesville' && SIC_code='7231'DB:business_master_new
loadtime:0.29006195068359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kershaw' limit 1
loadtime:0.29011201858521 / seconds
Query Executed:select id FROM `sc` where city='Kershaw' && SIC_code='7231'DB:business_master_new
loadtime:0.29179692268372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kiawah Island' limit 1
loadtime:0.29186081886292 / seconds
Query Executed:select id FROM `sc` where city='Kiawah Island' && SIC_code='7231'DB:business_master_new
loadtime:0.29216480255127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinards' limit 1
loadtime:0.2921929359436 / seconds
Query Executed:select id FROM `sc` where city='Kinards' && SIC_code='7231'DB:business_master_new
loadtime:0.29269099235535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kings Creek' limit 1
loadtime:0.29274082183838 / seconds
Query Executed:select id FROM `sc` where city='Kings Creek' && SIC_code='7231'DB:business_master_new
loadtime:0.29300498962402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingstree' limit 1
loadtime:0.29303288459778 / seconds
Query Executed:select id FROM `sc` where city='Kingstree' && SIC_code='7231'DB:business_master_new
loadtime:0.29502391815186 / seconds
Query loaded from cache:select * from geodata_geocity where city='La France' limit 1
loadtime:0.29509282112122 / seconds
Query Executed:select id FROM `sc` where city='La France' && SIC_code='7231'DB:business_master_new
loadtime:0.29541897773743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ladson' limit 1
loadtime:0.29545783996582 / seconds
Query Executed:select id FROM `sc` where city='Ladson' && SIC_code='7231'DB:business_master_new
loadtime:0.29720783233643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ladys Island' limit 1
loadtime:0.29726696014404 / seconds
Query Executed:select id FROM `sc` where city='Ladys Island' && SIC_code='7231'DB:business_master_new
loadtime:0.29756784439087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake City' limit 1
loadtime:0.29760599136353 / seconds
Query Executed:select id FROM `sc` where city='Lake City' && SIC_code='7231'DB:business_master_new
loadtime:0.29963088035583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake View' limit 1
loadtime:0.29970598220825 / seconds
Query Executed:select id FROM `sc` where city='Lake View' && SIC_code='7231'DB:business_master_new
loadtime:0.3008508682251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Wylie' limit 1
loadtime:0.30091381072998 / seconds
Query Executed:select id FROM `sc` where city='Lake Wylie' && SIC_code='7231'DB:business_master_new
loadtime:0.30138993263245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamar' limit 1
loadtime:0.30142784118652 / seconds
Query Executed:select id FROM `sc` where city='Lamar' && SIC_code='7231'DB:business_master_new
loadtime:0.30278897285461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:0.3028519153595 / seconds
Query Executed:select id FROM `sc` where city='Lancaster' && SIC_code='7231'DB:business_master_new
loadtime:0.30575180053711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lando' limit 1
loadtime:0.30583381652832 / seconds
Query Executed:select id FROM `sc` where city='Lando' && SIC_code='7231'DB:business_master_new
loadtime:0.30612897872925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Landrum' limit 1
loadtime:0.30617690086365 / seconds
Query Executed:select id FROM `sc` where city='Landrum' && SIC_code='7231'DB:business_master_new
loadtime:0.30787086486816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lane' limit 1
loadtime:0.30793499946594 / seconds
Query Executed:select id FROM `sc` where city='Lane' && SIC_code='7231'DB:business_master_new
loadtime:0.30841302871704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langley' limit 1
loadtime:0.3084568977356 / seconds
Query Executed:select id FROM `sc` where city='Langley' && SIC_code='7231'DB:business_master_new
loadtime:0.30900192260742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Latta' limit 1
loadtime:0.30904698371887 / seconds
Query Executed:select id FROM `sc` where city='Latta' && SIC_code='7231'DB:business_master_new
loadtime:0.31066989898682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurens' limit 1
loadtime:0.31073403358459 / seconds
Query Executed:select id FROM `sc` where city='Laurens' && SIC_code='7231'DB:business_master_new
loadtime:0.31287288665771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leesville' limit 1
loadtime:0.31294298171997 / seconds
Query Executed:select id FROM `sc` where city='Leesville' && SIC_code='7231'DB:business_master_new
loadtime:0.31468081474304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:0.31474280357361 / seconds
Query Executed:select id FROM `sc` where city='Lexington' && SIC_code='7231'DB:business_master_new
loadtime:0.31783890724182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty' limit 1
loadtime:0.31791591644287 / seconds
Query Executed:select id FROM `sc` where city='Liberty' && SIC_code='7231'DB:business_master_new
loadtime:0.31958699226379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty Hill' limit 1
loadtime:0.31964898109436 / seconds
Query Executed:select id FROM `sc` where city='Liberty Hill' && SIC_code='7231'DB:business_master_new
loadtime:0.32001280784607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincolnville' limit 1
loadtime:0.32006001472473 / seconds
Query Executed:select id FROM `sc` where city='Lincolnville' && SIC_code='7231'DB:business_master_new
loadtime:0.32031488418579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Mountain' limit 1
loadtime:0.32035303115845 / seconds
Query Executed:select id FROM `sc` where city='Little Mountain' && SIC_code='7231'DB:business_master_new
loadtime:0.32121396064758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little River' limit 1
loadtime:0.32126784324646 / seconds
Query Executed:select id FROM `sc` where city='Little River' && SIC_code='7231'DB:business_master_new
loadtime:0.32320785522461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Rock' limit 1
loadtime:0.32327485084534 / seconds
Query Executed:select id FROM `sc` where city='Little Rock' && SIC_code='7231'DB:business_master_new
loadtime:0.32368803024292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Livingston' limit 1
loadtime:0.32374382019043 / seconds
Query Executed:select id FROM `sc` where city='Livingston' && SIC_code='7231'DB:business_master_new
loadtime:0.32399988174438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lobeco' limit 1
loadtime:0.32403302192688 / seconds
Query Executed:select id FROM `sc` where city='Lobeco' && SIC_code='7231'DB:business_master_new
loadtime:0.32438898086548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lockhart' limit 1
loadtime:0.32442402839661 / seconds
Query Executed:select id FROM `sc` where city='Lockhart' && SIC_code='7231'DB:business_master_new
loadtime:0.32485890388489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lodge' limit 1
loadtime:0.32492184638977 / seconds
Query Executed:select id FROM `sc` where city='Lodge' && SIC_code='7231'DB:business_master_new
loadtime:0.32551193237305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lone Star' limit 1
loadtime:0.32554984092712 / seconds
Query Executed:select id FROM `sc` where city='Lone Star' && SIC_code='7231'DB:business_master_new
loadtime:0.32587289810181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Creek' limit 1
loadtime:0.32591485977173 / seconds
Query Executed:select id FROM `sc` where city='Long Creek' && SIC_code='7231'DB:business_master_new
loadtime:0.32633280754089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longs' limit 1
loadtime:0.32637786865234 / seconds
Query Executed:select id FROM `sc` where city='Longs' && SIC_code='7231'DB:business_master_new
loadtime:0.32814788818359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loris' limit 1
loadtime:0.32820987701416 / seconds
Query Executed:select id FROM `sc` where city='Loris' && SIC_code='7231'DB:business_master_new
loadtime:0.3302149772644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowndesville' limit 1
loadtime:0.33027601242065 / seconds
Query Executed:select id FROM `sc` where city='Lowndesville' && SIC_code='7231'DB:business_master_new
loadtime:0.33065700531006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lugoff' limit 1
loadtime:0.33071088790894 / seconds
Query Executed:select id FROM `sc` where city='Lugoff' && SIC_code='7231'DB:business_master_new
loadtime:0.33253884315491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luray' limit 1
loadtime:0.33260297775269 / seconds
Query Executed:select id FROM `sc` where city='Luray' && SIC_code='7231'DB:business_master_new
loadtime:0.33301281929016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lydia' limit 1
loadtime:0.33305788040161 / seconds
Query Executed:select id FROM `sc` where city='Lydia' && SIC_code='7231'DB:business_master_new
loadtime:0.3333568572998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyman' limit 1
loadtime:0.33340001106262 / seconds
Query Executed:select id FROM `sc` where city='Lyman' && SIC_code='7231'DB:business_master_new
loadtime:0.33503198623657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynchburg' limit 1
loadtime:0.33508992195129 / seconds
Query Executed:select id FROM `sc` where city='Lynchburg' && SIC_code='7231'DB:business_master_new
loadtime:0.33609986305237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manning' limit 1
loadtime:0.33617782592773 / seconds
Query Executed:select id FROM `sc` where city='Manning' && SIC_code='7231'DB:business_master_new
loadtime:0.33820486068726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marietta' limit 1
loadtime:0.33828902244568 / seconds
Query Executed:select id FROM `sc` where city='Marietta' && SIC_code='7231'DB:business_master_new
loadtime:0.33969688415527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.33975601196289 / seconds
Query Executed:select id FROM `sc` where city='Marion' && SIC_code='7231'DB:business_master_new
loadtime:0.34176683425903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martin' limit 1
loadtime:0.34183883666992 / seconds
Query Executed:select id FROM `sc` where city='Martin' && SIC_code='7231'DB:business_master_new
loadtime:0.3422520160675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mauldin' limit 1
loadtime:0.3422908782959 / seconds
Query Executed:select id FROM `sc` where city='Mauldin' && SIC_code='7231'DB:business_master_new
loadtime:0.34425282478333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayesville' limit 1
loadtime:0.3443238735199 / seconds
Query Executed:select id FROM `sc` where city='Mayesville' && SIC_code='7231'DB:business_master_new
loadtime:0.34515786170959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayo' limit 1
loadtime:0.34521698951721 / seconds
Query Executed:select id FROM `sc` where city='Mayo' && SIC_code='7231'DB:business_master_new
loadtime:0.34572982788086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Bee' limit 1
loadtime:0.34578895568848 / seconds
Query Executed:select id FROM `sc` where city='Mc Bee' && SIC_code='7231'DB:business_master_new
loadtime:0.34685897827148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Clellanville' limit 1
loadtime:0.34689497947693 / seconds
Query Executed:select id FROM `sc` where city='Mc Clellanville' && SIC_code='7231'DB:business_master_new
loadtime:0.34812903404236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Coll' limit 1
loadtime:0.34820795059204 / seconds
Query Executed:select id FROM `sc` where city='Mc Coll' && SIC_code='7231'DB:business_master_new
loadtime:0.34931898117065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Connells' limit 1
loadtime:0.34937286376953 / seconds
Query Executed:select id FROM `sc` where city='Mc Connells' && SIC_code='7231'DB:business_master_new
loadtime:0.34997797012329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Cormick' limit 1
loadtime:0.35003089904785 / seconds
Query Executed:select id FROM `sc` where city='Mc Cormick' && SIC_code='7231'DB:business_master_new
loadtime:0.35169291496277 / seconds
Query Executed:select * from geodata_geocity where city='Mccormick' limit 1DB:business_master_new
loadtime:0.35201597213745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meggett' limit 1
loadtime:0.35205292701721 / seconds
Query Executed:select id FROM `sc` where city='Meggett' && SIC_code='7231'DB:business_master_new
loadtime:0.35230803489685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miley' limit 1
loadtime:0.35234880447388 / seconds
Query Executed:select id FROM `sc` where city='Miley' && SIC_code='7231'DB:business_master_new
loadtime:0.35261487960815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minturn' limit 1
loadtime:0.35265183448792 / seconds
Query Executed:select id FROM `sc` where city='Minturn' && SIC_code='7231'DB:business_master_new
loadtime:0.35295701026917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modoc' limit 1
loadtime:0.3529999256134 / seconds
Query Executed:select id FROM `sc` where city='Modoc' && SIC_code='7231'DB:business_master_new
loadtime:0.35334897041321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moncks Corner' limit 1
loadtime:0.35337591171265 / seconds
Query Executed:select id FROM `sc` where city='Moncks Corner' && SIC_code='7231'DB:business_master_new
loadtime:0.35563588142395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monetta' limit 1
loadtime:0.35570597648621 / seconds
Query Executed:select id FROM `sc` where city='Monetta' && SIC_code='7231'DB:business_master_new
loadtime:0.35634303092957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:0.35639095306396 / seconds
Query Executed:select id FROM `sc` where city='Monticello' && SIC_code='7231'DB:business_master_new
loadtime:0.35670590400696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montmorenci' limit 1
loadtime:0.35674095153809 / seconds
Query Executed:select id FROM `sc` where city='Montmorenci' && SIC_code='7231'DB:business_master_new
loadtime:0.35707187652588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moore' limit 1
loadtime:0.35710787773132 / seconds
Query Executed:select id FROM `sc` where city='Moore' && SIC_code='7231'DB:business_master_new
loadtime:0.35869288444519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Carmel' limit 1
loadtime:0.35875082015991 / seconds
Query Executed:select id FROM `sc` where city='Mount Carmel' && SIC_code='7231'DB:business_master_new
loadtime:0.35909080505371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Croghan' limit 1
loadtime:0.35912990570068 / seconds
Query Executed:select id FROM `sc` where city='Mount Croghan' && SIC_code='7231'DB:business_master_new
loadtime:0.35966300964355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:0.35972499847412 / seconds
Query Executed:select id FROM `sc` where city='Mount Pleasant' && SIC_code='7231'DB:business_master_new
loadtime:0.36321091651917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain Rest' limit 1
loadtime:0.36329197883606 / seconds
Query Executed:select id FROM `sc` where city='Mountain Rest' && SIC_code='7231'DB:business_master_new
loadtime:0.36395692825317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountville' limit 1
loadtime:0.36401796340942 / seconds
Query Executed:select id FROM `sc` where city='Mountville' && SIC_code='7231'DB:business_master_new
loadtime:0.36452484130859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Carmel' limit 1
loadtime:0.36456203460693 / seconds
Query Executed:select id FROM `sc` where city='Mt Carmel' && SIC_code='7231'DB:business_master_new
loadtime:0.36483287811279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Croghan' limit 1
loadtime:0.36486482620239 / seconds
Query Executed:select id FROM `sc` where city='Mt Croghan' && SIC_code='7231'DB:business_master_new
loadtime:0.36515092849731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:0.36518287658691 / seconds
Query Executed:select id FROM `sc` where city='Mt Pleasant' && SIC_code='7231'DB:business_master_new
loadtime:0.36635494232178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mullins' limit 1
loadtime:0.36641097068787 / seconds
Query Executed:select id FROM `sc` where city='Mullins' && SIC_code='7231'DB:business_master_new
loadtime:0.3682689666748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murrells Inlet' limit 1
loadtime:0.36833882331848 / seconds
Query Executed:select id FROM `sc` where city='Murrells Inlet' && SIC_code='7231'DB:business_master_new
loadtime:0.37065291404724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Myrtle Beach' limit 1
loadtime:0.37072896957397 / seconds
Query Executed:select id FROM `sc` where city='Myrtle Beach' && SIC_code='7231'DB:business_master_new
loadtime:0.37606382369995 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Charleston' limit 1
loadtime:0.37617683410645 / seconds
Query Executed:select id FROM `sc` where city='N Charleston' && SIC_code='7231'DB:business_master_new
loadtime:0.37643885612488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neeses' limit 1
loadtime:0.37648391723633 / seconds
Query Executed:select id FROM `sc` where city='Neeses' && SIC_code='7231'DB:business_master_new
loadtime:0.37742185592651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nesmith' limit 1
loadtime:0.37748885154724 / seconds
Query Executed:select id FROM `sc` where city='Nesmith' && SIC_code='7231'DB:business_master_new
loadtime:0.37798881530762 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Ellenton' limit 1
loadtime:0.37803983688354 / seconds
Query Executed:select id FROM `sc` where city='New Ellenton' && SIC_code='7231'DB:business_master_new
loadtime:0.37917494773865 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Zion' limit 1
loadtime:0.37923884391785 / seconds
Query Executed:select id FROM `sc` where city='New Zion' && SIC_code='7231'DB:business_master_new
loadtime:0.37980580329895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newberry' limit 1
loadtime:0.37986183166504 / seconds
Query Executed:select id FROM `sc` where city='Newberry' && SIC_code='7231'DB:business_master_new
loadtime:0.38198089599609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newry' limit 1
loadtime:0.38204884529114 / seconds
Query Executed:select id FROM `sc` where city='Newry' && SIC_code='7231'DB:business_master_new
loadtime:0.38232398033142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nichols' limit 1
loadtime:0.38236689567566 / seconds
Query Executed:select id FROM `sc` where city='Nichols' && SIC_code='7231'DB:business_master_new
loadtime:0.38372087478638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ninety Six' limit 1
loadtime:0.38376998901367 / seconds
Query Executed:select id FROM `sc` where city='Ninety Six' && SIC_code='7231'DB:business_master_new
loadtime:0.38533091545105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norris' limit 1
loadtime:0.38539481163025 / seconds
Query Executed:select id FROM `sc` where city='Norris' && SIC_code='7231'DB:business_master_new
loadtime:0.3857958316803 / seconds
Query loaded from cache:select * from geodata_geocity where city='North' limit 1
loadtime:0.38584685325623 / seconds
Query Executed:select id FROM `sc` where city='North' && SIC_code='7231'DB:business_master_new
loadtime:0.38724780082703 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Augusta' limit 1
loadtime:0.38732099533081 / seconds
Query Executed:select id FROM `sc` where city='North Augusta' && SIC_code='7231'DB:business_master_new
loadtime:0.3896849155426 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Charleston' limit 1
loadtime:0.38974380493164 / seconds
Query Executed:select id FROM `sc` where city='North Charleston' && SIC_code='7231'DB:business_master_new
loadtime:0.39397192001343 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Myrtle Bch' limit 1
loadtime:0.3940749168396 / seconds
Query Executed:select id FROM `sc` where city='North Myrtle Bch' && SIC_code='7231'DB:business_master_new
loadtime:0.394770860672 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Myrtle Beach' limit 1
loadtime:0.39481592178345 / seconds
Query Executed:select id FROM `sc` where city='North Myrtle Beach' && SIC_code='7231'DB:business_master_new
loadtime:0.39724183082581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norway' limit 1
loadtime:0.39733195304871 / seconds
Query Executed:select id FROM `sc` where city='Norway' && SIC_code='7231'DB:business_master_new
loadtime:0.39808082580566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Drive' limit 1
loadtime:0.39813899993896 / seconds
Query Executed:select id FROM `sc` where city='Ocean Drive' && SIC_code='7231'DB:business_master_new
loadtime:0.39842295646667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okatie' limit 1
loadtime:0.3984649181366 / seconds
Query Executed:select id FROM `sc` where city='Okatie' && SIC_code='7231'DB:business_master_new
loadtime:0.39982891082764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olanta' limit 1
loadtime:0.39986991882324 / seconds
Query Executed:select id FROM `sc` where city='Olanta' && SIC_code='7231'DB:business_master_new
loadtime:0.40084886550903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olar' limit 1
loadtime:0.4009108543396 / seconds
Query Executed:select id FROM `sc` where city='Olar' && SIC_code='7231'DB:business_master_new
loadtime:0.40145397186279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orangeburg' limit 1
loadtime:0.40149402618408 / seconds
Query Executed:select id FROM `sc` where city='Orangeburg' && SIC_code='7231'DB:business_master_new
loadtime:0.40469789505005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pacolet' limit 1
loadtime:0.4048068523407 / seconds
Query Executed:select id FROM `sc` where city='Pacolet' && SIC_code='7231'DB:business_master_new
loadtime:0.40594601631165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pacolet Mills' limit 1
loadtime:0.40599989891052 / seconds
Query Executed:select id FROM `sc` where city='Pacolet Mills' && SIC_code='7231'DB:business_master_new
loadtime:0.406329870224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pageland' limit 1
loadtime:0.40637397766113 / seconds
Query Executed:select id FROM `sc` where city='Pageland' && SIC_code='7231'DB:business_master_new
loadtime:0.40814590454102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pamplico' limit 1
loadtime:0.4082088470459 / seconds
Query Executed:select id FROM `sc` where city='Pamplico' && SIC_code='7231'DB:business_master_new
loadtime:0.40980195999146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parksville' limit 1
loadtime:0.40985488891602 / seconds
Query Executed:select id FROM `sc` where city='Parksville' && SIC_code='7231'DB:business_master_new
loadtime:0.41014790534973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parris Island' limit 1
loadtime:0.41019082069397 / seconds
Query Executed:select id FROM `sc` where city='Parris Island' && SIC_code='7231'DB:business_master_new
loadtime:0.41057682037354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patrick' limit 1
loadtime:0.41062188148499 / seconds
Query Executed:select id FROM `sc` where city='Patrick' && SIC_code='7231'DB:business_master_new
loadtime:0.41139602661133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pauline' limit 1
loadtime:0.41145491600037 / seconds
Query Executed:select id FROM `sc` where city='Pauline' && SIC_code='7231'DB:business_master_new
loadtime:0.41228985786438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pawleys Island' limit 1
loadtime:0.41236901283264 / seconds
Query Executed:select id FROM `sc` where city='Pawleys Island' && SIC_code='7231'DB:business_master_new
loadtime:0.41432499885559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paxville' limit 1
loadtime:0.41437983512878 / seconds
Query Executed:select id FROM `sc` where city='Paxville' && SIC_code='7231'DB:business_master_new
loadtime:0.41469097137451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peak' limit 1
loadtime:0.41475200653076 / seconds
Query Executed:select id FROM `sc` where city='Peak' && SIC_code='7231'DB:business_master_new
loadtime:0.4150869846344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelion' limit 1
loadtime:0.415118932724 / seconds
Query Executed:select id FROM `sc` where city='Pelion' && SIC_code='7231'DB:business_master_new
loadtime:0.41664886474609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelzer' limit 1
loadtime:0.41670680046082 / seconds
Query Executed:select id FROM `sc` where city='Pelzer' && SIC_code='7231'DB:business_master_new
loadtime:0.41834902763367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pendleton' limit 1
loadtime:0.41840696334839 / seconds
Query Executed:select id FROM `sc` where city='Pendleton' && SIC_code='7231'DB:business_master_new
loadtime:0.42005491256714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perry' limit 1
loadtime:0.42011690139771 / seconds
Query Executed:select id FROM `sc` where city='Perry' && SIC_code='7231'DB:business_master_new
loadtime:0.42039680480957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickens' limit 1
loadtime:0.42043781280518 / seconds
Query Executed:select id FROM `sc` where city='Pickens' && SIC_code='7231'DB:business_master_new
loadtime:0.42233180999756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piedmont' limit 1
loadtime:0.42239594459534 / seconds
Query Executed:select id FROM `sc` where city='Piedmont' && SIC_code='7231'DB:business_master_new
loadtime:0.42430996894836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pineland' limit 1
loadtime:0.42437386512756 / seconds
Query Executed:select id FROM `sc` where city='Pineland' && SIC_code='7231'DB:business_master_new
loadtime:0.42482686042786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pineville' limit 1
loadtime:0.424880027771 / seconds
Query Executed:select id FROM `sc` where city='Pineville' && SIC_code='7231'DB:business_master_new
loadtime:0.42564582824707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinewood' limit 1
loadtime:0.42570185661316 / seconds
Query Executed:select id FROM `sc` where city='Pinewood' && SIC_code='7231'DB:business_master_new
loadtime:0.42683887481689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinopolis' limit 1
loadtime:0.42689180374146 / seconds
Query Executed:select id FROM `sc` where city='Pinopolis' && SIC_code='7231'DB:business_master_new
loadtime:0.42735481262207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plum Branch' limit 1
loadtime:0.42739582061768 / seconds
Query Executed:select id FROM `sc` where city='Plum Branch' && SIC_code='7231'DB:business_master_new
loadtime:0.42791390419006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomaria' limit 1
loadtime:0.42795491218567 / seconds
Query Executed:select id FROM `sc` where city='Pomaria' && SIC_code='7231'DB:business_master_new
loadtime:0.42866396903992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Royal' limit 1
loadtime:0.42870783805847 / seconds
Query Executed:select id FROM `sc` where city='Port Royal' && SIC_code='7231'DB:business_master_new
loadtime:0.4303150177002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prosperity' limit 1
loadtime:0.43037581443787 / seconds
Query Executed:select id FROM `sc` where city='Prosperity' && SIC_code='7231'DB:business_master_new
loadtime:0.43195080757141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinby' limit 1
loadtime:0.43201303482056 / seconds
Query Executed:select id FROM `sc` where city='Quinby' && SIC_code='7231'DB:business_master_new
loadtime:0.43226480484009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rains' limit 1
loadtime:0.4323148727417 / seconds
Query Executed:select id FROM `sc` where city='Rains' && SIC_code='7231'DB:business_master_new
loadtime:0.43264293670654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ravenel' limit 1
loadtime:0.43268299102783 / seconds
Query Executed:select id FROM `sc` where city='Ravenel' && SIC_code='7231'DB:business_master_new
loadtime:0.43419981002808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reevesville' limit 1
loadtime:0.43424892425537 / seconds
Query Executed:select id FROM `sc` where city='Reevesville' && SIC_code='7231'DB:business_master_new
loadtime:0.43486881256104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reidville' limit 1
loadtime:0.43491387367249 / seconds
Query Executed:select id FROM `sc` where city='Reidville' && SIC_code='7231'DB:business_master_new
loadtime:0.43532299995422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rembert' limit 1
loadtime:0.43536782264709 / seconds
Query Executed:select id FROM `sc` where city='Rembert' && SIC_code='7231'DB:business_master_new
loadtime:0.43631982803345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richburg' limit 1
loadtime:0.43637800216675 / seconds
Query Executed:select id FROM `sc` where city='Richburg' && SIC_code='7231'DB:business_master_new
loadtime:0.43790102005005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland' limit 1
loadtime:0.43795800209045 / seconds
Query Executed:select id FROM `sc` where city='Richland' && SIC_code='7231'DB:business_master_new
loadtime:0.43828296661377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridge Spring' limit 1
loadtime:0.43832397460938 / seconds
Query Executed:select id FROM `sc` where city='Ridge Spring' && SIC_code='7231'DB:business_master_new
loadtime:0.4394109249115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeland' limit 1
loadtime:0.43946981430054 / seconds
Query Executed:select id FROM `sc` where city='Ridgeland' && SIC_code='7231'DB:business_master_new
loadtime:0.44126200675964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeville' limit 1
loadtime:0.44133281707764 / seconds
Query Executed:select id FROM `sc` where city='Ridgeville' && SIC_code='7231'DB:business_master_new
loadtime:0.44286894798279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:0.44292783737183 / seconds
Query Executed:select id FROM `sc` where city='Ridgeway' && SIC_code='7231'DB:business_master_new
loadtime:0.44445180892944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rimini' limit 1
loadtime:0.44450283050537 / seconds
Query Executed:select id FROM `sc` where city='Rimini' && SIC_code='7231'DB:business_master_new
loadtime:0.44481301307678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rion' limit 1
loadtime:0.44486403465271 / seconds
Query Executed:select id FROM `sc` where city='Rion' && SIC_code='7231'DB:business_master_new
loadtime:0.44512486457825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ritter' limit 1
loadtime:0.44515681266785 / seconds
Query Executed:select id FROM `sc` where city='Ritter' && SIC_code='7231'DB:business_master_new
loadtime:0.4454128742218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Hill' limit 1
loadtime:0.44545102119446 / seconds
Query Executed:select id FROM `sc` where city='Rock Hill' && SIC_code='7231'DB:business_master_new
loadtime:0.44937586784363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roebuck' limit 1
loadtime:0.44946384429932 / seconds
Query Executed:select id FROM `sc` where city='Roebuck' && SIC_code='7231'DB:business_master_new
loadtime:0.45105981826782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Round O' limit 1
loadtime:0.45112490653992 / seconds
Query Executed:select id FROM `sc` where city='Round O' && SIC_code='7231'DB:business_master_new
loadtime:0.45187401771545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowesville' limit 1
loadtime:0.45192289352417 / seconds
Query Executed:select id FROM `sc` where city='Rowesville' && SIC_code='7231'DB:business_master_new
loadtime:0.45239496231079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruby' limit 1
loadtime:0.4524450302124 / seconds
Query Executed:select id FROM `sc` where city='Ruby' && SIC_code='7231'DB:business_master_new
loadtime:0.4531078338623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruffin' limit 1
loadtime:0.45316290855408 / seconds
Query Executed:select id FROM `sc` where city='Ruffin' && SIC_code='7231'DB:business_master_new
loadtime:0.45400190353394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Russellville' limit 1
loadtime:0.45405697822571 / seconds
Query Executed:select id FROM `sc` where city='Russellville' && SIC_code='7231'DB:business_master_new
loadtime:0.45438480377197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint George' limit 1
loadtime:0.45442795753479 / seconds
Query Executed:select id FROM `sc` where city='Saint George' && SIC_code='7231'DB:business_master_new
loadtime:0.45613503456116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Helena Island' limit 1
loadtime:0.45620203018188 / seconds
Query Executed:select id FROM `sc` where city='Saint Helena Island' && SIC_code='7231'DB:business_master_new
loadtime:0.45783185958862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Matthews' limit 1
loadtime:0.45788288116455 / seconds
Query Executed:select id FROM `sc` where city='Saint Matthews' && SIC_code='7231'DB:business_master_new
loadtime:0.45956492424011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Stephen' limit 1
loadtime:0.45962691307068 / seconds
Query Executed:select id FROM `sc` where city='Saint Stephen' && SIC_code='7231'DB:business_master_new
loadtime:0.46125888824463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.46133399009705 / seconds
Query Executed:select id FROM `sc` where city='Salem' && SIC_code='7231'DB:business_master_new
loadtime:0.46287083625793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salley' limit 1
loadtime:0.46292996406555 / seconds
Query Executed:select id FROM `sc` where city='Salley' && SIC_code='7231'DB:business_master_new
loadtime:0.46370792388916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salters' limit 1
loadtime:0.46375799179077 / seconds
Query Executed:select id FROM `sc` where city='Salters' && SIC_code='7231'DB:business_master_new
loadtime:0.46452188491821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saluda' limit 1
loadtime:0.46457386016846 / seconds
Query Executed:select id FROM `sc` where city='Saluda' && SIC_code='7231'DB:business_master_new
loadtime:0.46631002426147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Springs' limit 1
loadtime:0.46636986732483 / seconds
Query Executed:select id FROM `sc` where city='Sandy Springs' && SIC_code='7231'DB:business_master_new
loadtime:0.46688985824585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santee' limit 1
loadtime:0.46692585945129 / seconds
Query Executed:select id FROM `sc` where city='Santee' && SIC_code='7231'DB:business_master_new
loadtime:0.46859192848206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sardinia' limit 1
loadtime:0.46864986419678 / seconds
Query Executed:select id FROM `sc` where city='Sardinia' && SIC_code='7231'DB:business_master_new
loadtime:0.46896481513977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotia' limit 1
loadtime:0.46901202201843 / seconds
Query Executed:select id FROM `sc` where city='Scotia' && SIC_code='7231'DB:business_master_new
loadtime:0.46928691864014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scranton' limit 1
loadtime:0.46934199333191 / seconds
Query Executed:select id FROM `sc` where city='Scranton' && SIC_code='7231'DB:business_master_new
loadtime:0.47087287902832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seabrook' limit 1
loadtime:0.47093391418457 / seconds
Query Executed:select id FROM `sc` where city='Seabrook' && SIC_code='7231'DB:business_master_new
loadtime:0.47182989120483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sellers' limit 1
loadtime:0.47187995910645 / seconds
Query Executed:select id FROM `sc` where city='Sellers' && SIC_code='7231'DB:business_master_new
loadtime:0.47227883338928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:0.47233080863953 / seconds
Query Executed:select id FROM `sc` where city='Seneca' && SIC_code='7231'DB:business_master_new
loadtime:0.47469687461853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.4747679233551 / seconds
Query Executed:select id FROM `sc` where city='Sharon' && SIC_code='7231'DB:business_master_new
loadtime:0.47552990913391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaw A F B' limit 1
loadtime:0.47558784484863 / seconds
Query Executed:select id FROM `sc` where city='Shaw A F B' && SIC_code='7231'DB:business_master_new
loadtime:0.47582197189331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaw Afb' limit 1
loadtime:0.4758620262146 / seconds
Query Executed:select id FROM `sc` where city='Shaw Afb' && SIC_code='7231'DB:business_master_new
loadtime:0.4765989780426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon' limit 1
loadtime:0.47665691375732 / seconds
Query Executed:select id FROM `sc` where city='Sheldon' && SIC_code='7231'DB:business_master_new
loadtime:0.47711992263794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shulerville' limit 1
loadtime:0.47716403007507 / seconds
Query Executed:select id FROM `sc` where city='Shulerville' && SIC_code='7231'DB:business_master_new
loadtime:0.47744393348694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silverstreet' limit 1
loadtime:0.47748303413391 / seconds
Query Executed:select id FROM `sc` where city='Silverstreet' && SIC_code='7231'DB:business_master_new
loadtime:0.47790789604187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Simpsonville' limit 1
loadtime:0.47795081138611 / seconds
Query Executed:select id FROM `sc` where city='Simpsonville' && SIC_code='7231'DB:business_master_new
loadtime:0.48045682907104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Six Mile' limit 1
loadtime:0.48053503036499 / seconds
Query Executed:select id FROM `sc` where city='Six Mile' && SIC_code='7231'DB:business_master_new
loadtime:0.48159289360046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Slater' limit 1
loadtime:0.48165488243103 / seconds
Query Executed:select id FROM `sc` where city='Slater' && SIC_code='7231'DB:business_master_new
loadtime:0.48202586174011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smoaks' limit 1
loadtime:0.48206996917725 / seconds
Query Executed:select id FROM `sc` where city='Smoaks' && SIC_code='7231'DB:business_master_new
loadtime:0.48273992538452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smyrna' limit 1
loadtime:0.48280096054077 / seconds
Query Executed:select id FROM `sc` where city='Smyrna' && SIC_code='7231'DB:business_master_new
loadtime:0.48326086997986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Society Hill' limit 1
loadtime:0.48331093788147 / seconds
Query Executed:select id FROM `sc` where city='Society Hill' && SIC_code='7231'DB:business_master_new
loadtime:0.48410487174988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spartanburg' limit 1
loadtime:0.48415493965149 / seconds
Query Executed:select id FROM `sc` where city='Spartanburg' && SIC_code='7231'DB:business_master_new
loadtime:0.4891529083252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.48928594589233 / seconds
Query Executed:select id FROM `sc` where city='Springfield' && SIC_code='7231'DB:business_master_new
loadtime:0.49001097679138 / seconds
Query loaded from cache:select * from geodata_geocity where city='St George' limit 1
loadtime:0.49007081985474 / seconds
Query Executed:select id FROM `sc` where city='St George' && SIC_code='7231'DB:business_master_new
loadtime:0.49036598205566 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Helena Island' limit 1
loadtime:0.49040198326111 / seconds
Query Executed:select id FROM `sc` where city='St Helena Island' && SIC_code='7231'DB:business_master_new
loadtime:0.49074482917786 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Matthews' limit 1
loadtime:0.49079298973083 / seconds
Query Executed:select id FROM `sc` where city='St Matthews' && SIC_code='7231'DB:business_master_new
loadtime:0.49158191680908 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Stephen' limit 1
loadtime:0.49163579940796 / seconds
Query Executed:select id FROM `sc` where city='St Stephen' && SIC_code='7231'DB:business_master_new
loadtime:0.49188685417175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Starr' limit 1
loadtime:0.49191498756409 / seconds
Query Executed:select id FROM `sc` where city='Starr' && SIC_code='7231'DB:business_master_new
loadtime:0.49301791191101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Startex' limit 1
loadtime:0.49306702613831 / seconds
Query Executed:select id FROM `sc` where city='Startex' && SIC_code='7231'DB:business_master_new
loadtime:0.49341702461243 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Park' limit 1
loadtime:0.49344396591187 / seconds
Query Executed:select id FROM `sc` where city='State Park' && SIC_code='7231'DB:business_master_new
loadtime:0.49376797676086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sullivans Island' limit 1
loadtime:0.49382400512695 / seconds
Query Executed:select id FROM `sc` where city='Sullivans Island' && SIC_code='7231'DB:business_master_new
loadtime:0.49495100975037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summerton' limit 1
loadtime:0.49499988555908 / seconds
Query Executed:select id FROM `sc` where city='Summerton' && SIC_code='7231'DB:business_master_new
loadtime:0.49661684036255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summerville' limit 1
loadtime:0.4966778755188 / seconds
Query Executed:select id FROM `sc` where city='Summerville' && SIC_code='7231'DB:business_master_new
loadtime:0.50002288818359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumter' limit 1
loadtime:0.50011801719666 / seconds
Query Executed:select id FROM `sc` where city='Sumter' && SIC_code='7231'DB:business_master_new
loadtime:0.50372385978699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunset' limit 1
loadtime:0.50382089614868 / seconds
Query Executed:select id FROM `sc` where city='Sunset' && SIC_code='7231'DB:business_master_new
loadtime:0.50445294380188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surfside Beach' limit 1
loadtime:0.50449991226196 / seconds
Query Executed:select id FROM `sc` where city='Surfside Beach' && SIC_code='7231'DB:business_master_new
loadtime:0.50510883331299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swansea' limit 1
loadtime:0.50516295433044 / seconds
Query Executed:select id FROM `sc` where city='Swansea' && SIC_code='7231'DB:business_master_new
loadtime:0.50676989555359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sycamore' limit 1
loadtime:0.50682592391968 / seconds
Query Executed:select id FROM `sc` where city='Sycamore' && SIC_code='7231'DB:business_master_new
loadtime:0.50712084770203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tamassee' limit 1
loadtime:0.50715494155884 / seconds
Query Executed:select id FROM `sc` where city='Tamassee' && SIC_code='7231'DB:business_master_new
loadtime:0.50752902030945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tatum' limit 1
loadtime:0.50756502151489 / seconds
Query Executed:select id FROM `sc` where city='Tatum' && SIC_code='7231'DB:business_master_new
loadtime:0.50792288780212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylors' limit 1
loadtime:0.5079779624939 / seconds
Query Executed:select id FROM `sc` where city='Taylors' && SIC_code='7231'DB:business_master_new
loadtime:0.51011681556702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tigerville' limit 1
loadtime:0.51017594337463 / seconds
Query Executed:select id FROM `sc` where city='Tigerville' && SIC_code='7231'DB:business_master_new
loadtime:0.51053094863892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tillman' limit 1
loadtime:0.51057386398315 / seconds
Query Executed:select id FROM `sc` where city='Tillman' && SIC_code='7231'DB:business_master_new
loadtime:0.5109658241272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timmonsville' limit 1
loadtime:0.51100182533264 / seconds
Query Executed:select id FROM `sc` where city='Timmonsville' && SIC_code='7231'DB:business_master_new
loadtime:0.51269388198853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townville' limit 1
loadtime:0.5127739906311 / seconds
Query Executed:select id FROM `sc` where city='Townville' && SIC_code='7231'DB:business_master_new
loadtime:0.51381993293762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Travelers Rest' limit 1
loadtime:0.51388192176819 / seconds
Query Executed:select id FROM `sc` where city='Travelers Rest' && SIC_code='7231'DB:business_master_new
loadtime:0.51573300361633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trenton' limit 1
loadtime:0.51579689979553 / seconds
Query Executed:select id FROM `sc` where city='Trenton' && SIC_code='7231'DB:business_master_new
loadtime:0.51693797111511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trio' limit 1
loadtime:0.51698684692383 / seconds
Query Executed:select id FROM `sc` where city='Trio' && SIC_code='7231'DB:business_master_new
loadtime:0.51721382141113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:0.51725101470947 / seconds
Query Executed:select id FROM `sc` where city='Troy' && SIC_code='7231'DB:business_master_new
loadtime:0.5178108215332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turbeville' limit 1
loadtime:0.51786303520203 / seconds
Query Executed:select id FROM `sc` where city='Turbeville' && SIC_code='7231'DB:business_master_new
loadtime:0.51937294006348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ulmer' limit 1
loadtime:0.51943397521973 / seconds
Query Executed:select id FROM `sc` where city='Ulmer' && SIC_code='7231'DB:business_master_new
loadtime:0.51986193656921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Una' limit 1
loadtime:0.51989889144897 / seconds
Query Executed:select id FROM `sc` where city='Una' && SIC_code='7231'DB:business_master_new
loadtime:0.52024292945862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:0.52027797698975 / seconds
Query Executed:select id FROM `sc` where city='Union' && SIC_code='7231'DB:business_master_new
loadtime:0.52235794067383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Wyck' limit 1
loadtime:0.52242684364319 / seconds
Query Executed:select id FROM `sc` where city='Van Wyck' && SIC_code='7231'DB:business_master_new
loadtime:0.52279901504517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vance' limit 1
loadtime:0.52284789085388 / seconds
Query Executed:select id FROM `sc` where city='Vance' && SIC_code='7231'DB:business_master_new
loadtime:0.52342486381531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Varnville' limit 1
loadtime:0.52347898483276 / seconds
Query Executed:select id FROM `sc` where city='Varnville' && SIC_code='7231'DB:business_master_new
loadtime:0.52509784698486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vaucluse' limit 1
loadtime:0.52515292167664 / seconds
Query Executed:select id FROM `sc` where city='Vaucluse' && SIC_code='7231'DB:business_master_new
loadtime:0.52543497085571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wadmalaw Island' limit 1
loadtime:0.525475025177 / seconds
Query Executed:select id FROM `sc` where city='Wadmalaw Island' && SIC_code='7231'DB:business_master_new
loadtime:0.52632284164429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wagener' limit 1
loadtime:0.52637481689453 / seconds
Query Executed:select id FROM `sc` where city='Wagener' && SIC_code='7231'DB:business_master_new
loadtime:0.52796387672424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walhalla' limit 1
loadtime:0.52802395820618 / seconds
Query Executed:select id FROM `sc` where city='Walhalla' && SIC_code='7231'DB:business_master_new
loadtime:0.52980089187622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallace' limit 1
loadtime:0.52986001968384 / seconds
Query Executed:select id FROM `sc` where city='Wallace' && SIC_code='7231'DB:business_master_new
loadtime:0.5304548740387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walterboro' limit 1
loadtime:0.53049087524414 / seconds
Query Executed:select id FROM `sc` where city='Walterboro' && SIC_code='7231'DB:business_master_new
loadtime:0.53290581703186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wando' limit 1
loadtime:0.53298091888428 / seconds
Query Executed:select id FROM `sc` where city='Wando' && SIC_code='7231'DB:business_master_new
loadtime:0.53330683708191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ward' limit 1
loadtime:0.53334903717041 / seconds
Query Executed:select id FROM `sc` where city='Ward' && SIC_code='7231'DB:business_master_new
loadtime:0.53385400772095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ware Shoals' limit 1
loadtime:0.53389000892639 / seconds
Query Executed:select id FROM `sc` where city='Ware Shoals' && SIC_code='7231'DB:business_master_new
loadtime:0.5353729724884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrenville' limit 1
loadtime:0.53543281555176 / seconds
Query Executed:select id FROM `sc` where city='Warrenville' && SIC_code='7231'DB:business_master_new
loadtime:0.5370819568634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterloo' limit 1
loadtime:0.53714179992676 / seconds
Query Executed:select id FROM `sc` where city='Waterloo' && SIC_code='7231'DB:business_master_new
loadtime:0.53814792633057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wedgefield' limit 1
loadtime:0.53819894790649 / seconds
Query Executed:select id FROM `sc` where city='Wedgefield' && SIC_code='7231'DB:business_master_new
loadtime:0.53901886940002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellford' limit 1
loadtime:0.5390739440918 / seconds
Query Executed:select id FROM `sc` where city='Wellford' && SIC_code='7231'DB:business_master_new
loadtime:0.54063701629639 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Columbia' limit 1
loadtime:0.54069685935974 / seconds
Query Executed:select id FROM `sc` where city='West Columbia' && SIC_code='7231'DB:business_master_new
loadtime:0.54379200935364 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Union' limit 1
loadtime:0.54387283325195 / seconds
Query Executed:select id FROM `sc` where city='West Union' && SIC_code='7231'DB:business_master_new
loadtime:0.54545903205872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:0.54552102088928 / seconds
Query Executed:select id FROM `sc` where city='Westminster' && SIC_code='7231'DB:business_master_new
loadtime:0.54721689224243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westville' limit 1
loadtime:0.54727602005005 / seconds
Query Executed:select id FROM `sc` where city='Westville' && SIC_code='7231'DB:business_master_new
loadtime:0.5476598739624 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Rock' limit 1
loadtime:0.54769587516785 / seconds
Query Executed:select id FROM `sc` where city='White Rock' && SIC_code='7231'DB:business_master_new
loadtime:0.54816198348999 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Stone' limit 1
loadtime:0.54821085929871 / seconds
Query Executed:select id FROM `sc` where city='White Stone' && SIC_code='7231'DB:business_master_new
loadtime:0.54852080345154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitmire' limit 1
loadtime:0.54856300354004 / seconds
Query Executed:select id FROM `sc` where city='Whitmire' && SIC_code='7231'DB:business_master_new
loadtime:0.54971599578857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williams' limit 1
loadtime:0.54977083206177 / seconds
Query Executed:select id FROM `sc` where city='Williams' && SIC_code='7231'DB:business_master_new
loadtime:0.55010080337524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamston' limit 1
loadtime:0.55013799667358 / seconds
Query Executed:select id FROM `sc` where city='Williamston' && SIC_code='7231'DB:business_master_new
loadtime:0.55183482170105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williston' limit 1
loadtime:0.55189299583435 / seconds
Query Executed:select id FROM `sc` where city='Williston' && SIC_code='7231'DB:business_master_new
loadtime:0.55360198020935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:0.55366182327271 / seconds
Query Executed:select id FROM `sc` where city='Windsor' && SIC_code='7231'DB:business_master_new
loadtime:0.55428695678711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winnsboro' limit 1
loadtime:0.55435395240784 / seconds
Query Executed:select id FROM `sc` where city='Winnsboro' && SIC_code='7231'DB:business_master_new
loadtime:0.55621981620789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodruff' limit 1
loadtime:0.55628490447998 / seconds
Query Executed:select id FROM `sc` where city='Woodruff' && SIC_code='7231'DB:business_master_new
loadtime:0.55801296234131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yemassee' limit 1
loadtime:0.55806088447571 / seconds
Query Executed:select id FROM `sc` where city='Yemassee' && SIC_code='7231'DB:business_master_new
loadtime:0.55963802337646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yonges Island' limit 1
loadtime:0.55969882011414 / seconds
Query Executed:select id FROM `sc` where city='Yonges Island' && SIC_code='7231'DB:business_master_new
loadtime:0.5599570274353 / seconds
Query loaded from cache:select * from geodata_geocity where city='York' limit 1
loadtime:0.5599958896637 / seconds
Query Executed:select id FROM `sc` where city='York' && SIC_code='7231'DB:business_master_new
loadtime:0.59007501602173 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.59017395973206 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.59036898612976 / seconds
Operation template executed (chunk cache operation)
loadtime:0.59044981002808 / seconds
template override:Default
loadtime:0.59046792984009 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:0.59126496315002 / seconds
Template Constructed, Array Rows:49
loadtime:0.59151983261108 / seconds
TOTAL EXECUTION TIME: 0.59132
loadtime:0.59163689613342 / 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] => beauty-shops [stateURLid] => south-carolina )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:0.59164190292358
TOTAL KEY ARRAYS: 69