Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:7.8916549682617E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00041794776916504 / seconds
host not found setting manual db connection
loadtime:0.0007169246673584 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00097489356994629 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0011110305786133 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.001154899597168 / seconds
zipcode:
loadtime:0.0011839866638184 / seconds
Query Executed:select * from search_referrer where page_hash='4203a372415d6200d8d151c3006a0bbd' limit 10 DB:ezrox_toadli
loadtime:0.001370906829834 / seconds
Operation header executed (non global)
loadtime:0.0013880729675293 / seconds
Operation leaderboard executed (non global)
loadtime:0.0014169216156006 / seconds
Operation square executed (non global)
loadtime:0.001431941986084 / seconds
Operation square_bottom executed (non global)
loadtime:0.001446008682251 / seconds
Operation smallsquare executed (non global)
loadtime:0.0014579296112061 / seconds
Operation headeradright executed (non global)
loadtime:0.0014700889587402 / seconds
Operation google_analytics executed (non global)
loadtime:0.0014810562133789 / seconds
Operation topstories executed (non global)
loadtime:0.0014920234680176 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0015029907226562 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0015149116516113 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0017380714416504 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0018899440765381 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0019268989562988 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0019900798797607 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0020248889923096 / seconds
Template key: archive_menu pushed
loadtime:0.0020310878753662 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0020411014556885 / seconds
Template key: get_gravatar pushed
loadtime:0.0020461082458496 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0020499229431152 / seconds
*10)-10)+1 | start:0
loadtime:0.0020859241485596 / seconds
Query loaded from cache:select * from categories where cat_URLid='retail-bakeries'
loadtime:0.0021250247955322 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='south-carolina'
loadtime:0.0021591186523438 / seconds
DB connected to localhost business_master_new
loadtime:0.0023961067199707 / seconds
Query Executed:select * from `sc_catmap` where sic='5461' order by city ascDB:business_master_new
loadtime:0.03740406036377 / seconds
Query stored in cache : _QUERY_www.toadli.comb470ac7534b397b35453bc3f22137498
loadtime:0.038399934768677 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='south-carolina'
loadtime:0.038438081741333 / seconds
Query Executed:select sum(totalcount) as totalsum from `sc_catmap` where sic='5461'DB:business_master_new
loadtime:0.040824890136719 / seconds
Query stored in cache : _QUERY_www.toadli.comae286ce18870bef2a1e2513aecce3390
loadtime:0.04085111618042 / seconds
420 / 11
loadtime:0.040884017944336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abbeville' limit 1
loadtime:0.040937900543213 / seconds
Query Executed:select id FROM `sc` where city='Abbeville' && SIC_code='5461'DB:business_master_new
loadtime:0.059422016143799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adams Run' limit 1
loadtime:0.05948805809021 / seconds
Query Executed:select id FROM `sc` where city='Adams Run' && SIC_code='5461'DB:business_master_new
loadtime:0.06887412071228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aiken' limit 1
loadtime:0.068903923034668 / seconds
Query Executed:select id FROM `sc` where city='Aiken' && SIC_code='5461'DB:business_master_new
loadtime:0.16355991363525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alcolu' limit 1
loadtime:0.16362595558167 / seconds
Query Executed:select id FROM `sc` where city='Alcolu' && SIC_code='5461'DB:business_master_new
loadtime:0.16417288780212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allendale' limit 1
loadtime:0.16421389579773 / seconds
Query Executed:select id FROM `sc` where city='Allendale' && SIC_code='5461'DB:business_master_new
loadtime:0.16477704048157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alvin' limit 1
loadtime:0.16480302810669 / seconds
Query Executed:select id FROM `sc` where city='Alvin' && SIC_code='5461'DB:business_master_new
loadtime:0.16555404663086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anderson' limit 1
loadtime:0.16559505462646 / seconds
Query Executed:select id FROM `sc` where city='Anderson' && SIC_code='5461'DB:business_master_new
loadtime:0.16852998733521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andrews' limit 1
loadtime:0.16857600212097 / seconds
Query Executed:select id FROM `sc` where city='Andrews' && SIC_code='5461'DB:business_master_new
loadtime:0.16918897628784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcadia' limit 1
loadtime:0.16922497749329 / seconds
Query Executed:select id FROM `sc` where city='Arcadia' && SIC_code='5461'DB:business_master_new
loadtime:0.172611951828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic Beach' limit 1
loadtime:0.17264890670776 / seconds
Query Executed:select id FROM `sc` where city='Atlantic Beach' && SIC_code='5461'DB:business_master_new
loadtime:0.17293310165405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Awendaw' limit 1
loadtime:0.17296504974365 / seconds
Query Executed:select id FROM `sc` where city='Awendaw' && SIC_code='5461'DB:business_master_new
loadtime:0.17348289489746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aynor' limit 1
loadtime:0.17350912094116 / seconds
Query Executed:select id FROM `sc` where city='Aynor' && SIC_code='5461'DB:business_master_new
loadtime:0.17403793334961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ballentine' limit 1
loadtime:0.17408895492554 / seconds
Query Executed:select id FROM `sc` where city='Ballentine' && SIC_code='5461'DB:business_master_new
loadtime:0.18526911735535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bamberg' limit 1
loadtime:0.18529891967773 / seconds
Query Executed:select id FROM `sc` where city='Bamberg' && SIC_code='5461'DB:business_master_new
loadtime:0.18589305877686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnwell' limit 1
loadtime:0.1859290599823 / seconds
Query Executed:select id FROM `sc` where city='Barnwell' && SIC_code='5461'DB:business_master_new
loadtime:0.18665790557861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Batesburg' limit 1
loadtime:0.18669891357422 / seconds
Query Executed:select id FROM `sc` where city='Batesburg' && SIC_code='5461'DB:business_master_new
loadtime:0.18731999397278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.18735790252686 / seconds
Query Executed:select id FROM `sc` where city='Bath' && SIC_code='5461'DB:business_master_new
loadtime:0.20023012161255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaufort' limit 1
loadtime:0.20029091835022 / seconds
Query Executed:select id FROM `sc` where city='Beaufort' && SIC_code='5461'DB:business_master_new
loadtime:0.20308208465576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beech Island' limit 1
loadtime:0.20313405990601 / seconds
Query Executed:select id FROM `sc` where city='Beech Island' && SIC_code='5461'DB:business_master_new
loadtime:0.20367193222046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belton' limit 1
loadtime:0.20371198654175 / seconds
Query Executed:select id FROM `sc` where city='Belton' && SIC_code='5461'DB:business_master_new
loadtime:0.2043559551239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvedere' limit 1
loadtime:0.20439791679382 / seconds
Query Executed:select id FROM `sc` where city='Belvedere' && SIC_code='5461'DB:business_master_new
loadtime:0.20510697364807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennettsville' limit 1
loadtime:0.20514512062073 / seconds
Query Executed:select id FROM `sc` where city='Bennettsville' && SIC_code='5461'DB:business_master_new
loadtime:0.20587205886841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethera' limit 1
loadtime:0.2059268951416 / seconds
Query Executed:select id FROM `sc` where city='Bethera' && SIC_code='5461'DB:business_master_new
loadtime:0.206787109375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethune' limit 1
loadtime:0.20684695243835 / seconds
Query Executed:select id FROM `sc` where city='Bethune' && SIC_code='5461'DB:business_master_new
loadtime:0.20735907554626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bishopville' limit 1
loadtime:0.20739507675171 / seconds
Query Executed:select id FROM `sc` where city='Bishopville' && SIC_code='5461'DB:business_master_new
loadtime:0.20802593231201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blacksburg' limit 1
loadtime:0.20808911323547 / seconds
Query Executed:select id FROM `sc` where city='Blacksburg' && SIC_code='5461'DB:business_master_new
loadtime:0.208664894104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackstock' limit 1
loadtime:0.2087070941925 / seconds
Query Executed:select id FROM `sc` where city='Blackstock' && SIC_code='5461'DB:business_master_new
loadtime:0.21773195266724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackville' limit 1
loadtime:0.21778297424316 / seconds
Query Executed:select id FROM `sc` where city='Blackville' && SIC_code='5461'DB:business_master_new
loadtime:0.21825504302979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blair' limit 1
loadtime:0.21829390525818 / seconds
Query Executed:select id FROM `sc` where city='Blair' && SIC_code='5461'DB:business_master_new
loadtime:0.22429895401001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blenheim' limit 1
loadtime:0.22433495521545 / seconds
Query Executed:select id FROM `sc` where city='Blenheim' && SIC_code='5461'DB:business_master_new
loadtime:0.23303508758545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluffton' limit 1
loadtime:0.23309993743896 / seconds
Query Executed:select id FROM `sc` where city='Bluffton' && SIC_code='5461'DB:business_master_new
loadtime:0.23569798469543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blythewood' limit 1
loadtime:0.23575496673584 / seconds
Query Executed:select id FROM `sc` where city='Blythewood' && SIC_code='5461'DB:business_master_new
loadtime:0.23635697364807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boiling Springs' limit 1
loadtime:0.23639011383057 / seconds
Query Executed:select id FROM `sc` where city='Boiling Springs' && SIC_code='5461'DB:business_master_new
loadtime:0.23702907562256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonneau' limit 1
loadtime:0.23707699775696 / seconds
Query Executed:select id FROM `sc` where city='Bonneau' && SIC_code='5461'DB:business_master_new
loadtime:0.2375431060791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowling Green' limit 1
loadtime:0.23758101463318 / seconds
Query Executed:select id FROM `sc` where city='Bowling Green' && SIC_code='5461'DB:business_master_new
loadtime:0.24363207817078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowman' limit 1
loadtime:0.24366998672485 / seconds
Query Executed:select id FROM `sc` where city='Bowman' && SIC_code='5461'DB:business_master_new
loadtime:0.24518394470215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradley' limit 1
loadtime:0.24522089958191 / seconds
Query Executed:select id FROM `sc` where city='Bradley' && SIC_code='5461'DB:business_master_new
loadtime:0.25734305381775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branchville' limit 1
loadtime:0.25737309455872 / seconds
Query Executed:select id FROM `sc` where city='Branchville' && SIC_code='5461'DB:business_master_new
loadtime:0.25857090950012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brunson' limit 1
loadtime:0.25861406326294 / seconds
Query Executed:select id FROM `sc` where city='Brunson' && SIC_code='5461'DB:business_master_new
loadtime:0.26990008354187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bucksport' limit 1
loadtime:0.26992702484131 / seconds
Query Executed:select id FROM `sc` where city='Bucksport' && SIC_code='5461'DB:business_master_new
loadtime:0.27060508728027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo' limit 1
loadtime:0.27063989639282 / seconds
Query Executed:select id FROM `sc` where city='Buffalo' && SIC_code='5461'DB:business_master_new
loadtime:0.27177500724792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cades' limit 1
loadtime:0.271812915802 / seconds
Query Executed:select id FROM `sc` where city='Cades' && SIC_code='5461'DB:business_master_new
loadtime:0.27261209487915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calhoun Falls' limit 1
loadtime:0.27264308929443 / seconds
Query Executed:select id FROM `sc` where city='Calhoun Falls' && SIC_code='5461'DB:business_master_new
loadtime:0.27307391166687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camden' limit 1
loadtime:0.27311205863953 / seconds
Query Executed:select id FROM `sc` where city='Camden' && SIC_code='5461'DB:business_master_new
loadtime:0.27389001846313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cameron' limit 1
loadtime:0.27392911911011 / seconds
Query Executed:select id FROM `sc` where city='Cameron' && SIC_code='5461'DB:business_master_new
loadtime:0.27436399459839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Campobello' limit 1
loadtime:0.27440309524536 / seconds
Query Executed:select id FROM `sc` where city='Campobello' && SIC_code='5461'DB:business_master_new
loadtime:0.27486491203308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canadys' limit 1
loadtime:0.27489995956421 / seconds
Query Executed:select id FROM `sc` where city='Canadys' && SIC_code='5461'DB:business_master_new
loadtime:0.27748799324036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlisle' limit 1
loadtime:0.27752089500427 / seconds
Query Executed:select id FROM `sc` where city='Carlisle' && SIC_code='5461'DB:business_master_new
loadtime:0.28833103179932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cassatt' limit 1
loadtime:0.28836297988892 / seconds
Query Executed:select id FROM `sc` where city='Cassatt' && SIC_code='5461'DB:business_master_new
loadtime:0.28876805305481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catawba' limit 1
loadtime:0.28880310058594 / seconds
Query Executed:select id FROM `sc` where city='Catawba' && SIC_code='5461'DB:business_master_new
loadtime:0.28924012184143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cayce' limit 1
loadtime:0.28927612304688 / seconds
Query Executed:select id FROM `sc` where city='Cayce' && SIC_code='5461'DB:business_master_new
loadtime:0.28986001014709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centenary' limit 1
loadtime:0.28990411758423 / seconds
Query Executed:select id FROM `sc` where city='Centenary' && SIC_code='5461'DB:business_master_new
loadtime:0.29080104827881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central' limit 1
loadtime:0.29084897041321 / seconds
Query Executed:select id FROM `sc` where city='Central' && SIC_code='5461'DB:business_master_new
loadtime:0.29133605957031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chapin' limit 1
loadtime:0.29137301445007 / seconds
Query Executed:select id FROM `sc` where city='Chapin' && SIC_code='5461'DB:business_master_new
loadtime:0.29196190834045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chappells' limit 1
loadtime:0.29199194908142 / seconds
Query Executed:select id FROM `sc` where city='Chappells' && SIC_code='5461'DB:business_master_new
loadtime:0.29651498794556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charleston' limit 1
loadtime:0.29654788970947 / seconds
Query Executed:select id FROM `sc` where city='Charleston' && SIC_code='5461'DB:business_master_new
loadtime:0.29901099205017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charleston Afb' limit 1
loadtime:0.29907202720642 / seconds
Query Executed:select id FROM `sc` where city='Charleston Afb' && SIC_code='5461'DB:business_master_new
loadtime:0.30970001220703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheraw' limit 1
loadtime:0.30973601341248 / seconds
Query Executed:select id FROM `sc` where city='Cheraw' && SIC_code='5461'DB:business_master_new
loadtime:0.31043791770935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Grove Bch' limit 1
loadtime:0.31046891212463 / seconds
Query Executed:select id FROM `sc` where city='Cherry Grove Bch' && SIC_code='5461'DB:business_master_new
loadtime:0.31093597412109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesnee' limit 1
loadtime:0.31096792221069 / seconds
Query Executed:select id FROM `sc` where city='Chesnee' && SIC_code='5461'DB:business_master_new
loadtime:0.31152200698853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.31155204772949 / seconds
Query Executed:select id FROM `sc` where city='Chester' && SIC_code='5461'DB:business_master_new
loadtime:0.31225109100342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:0.31228804588318 / seconds
Query Executed:select id FROM `sc` where city='Chesterfield' && SIC_code='5461'DB:business_master_new
loadtime:0.31280493736267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarks Hill' limit 1
loadtime:0.31283807754517 / seconds
Query Executed:select id FROM `sc` where city='Clarks Hill' && SIC_code='5461'DB:business_master_new
loadtime:0.32536697387695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clearwater' limit 1
loadtime:0.32540512084961 / seconds
Query Executed:select id FROM `sc` where city='Clearwater' && SIC_code='5461'DB:business_master_new
loadtime:0.33968305587769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clemson' limit 1
loadtime:0.33971500396729 / seconds
Query Executed:select id FROM `sc` where city='Clemson' && SIC_code='5461'DB:business_master_new
loadtime:0.34033489227295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.34037399291992 / seconds
Query Executed:select id FROM `sc` where city='Cleveland' && SIC_code='5461'DB:business_master_new
loadtime:0.35194993019104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:0.35197997093201 / seconds
Query Executed:select id FROM `sc` where city='Clifton' && SIC_code='5461'DB:business_master_new
loadtime:0.35363292694092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.3536639213562 / seconds
Query Executed:select id FROM `sc` where city='Clinton' && SIC_code='5461'DB:business_master_new
loadtime:0.35427904129028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clio' limit 1
loadtime:0.35432100296021 / seconds
Query Executed:select id FROM `sc` where city='Clio' && SIC_code='5461'DB:business_master_new
loadtime:0.35473489761353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clover' limit 1
loadtime:0.35477089881897 / seconds
Query Executed:select id FROM `sc` where city='Clover' && SIC_code='5461'DB:business_master_new
loadtime:0.35545992851257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.35548996925354 / seconds
Query Executed:select id FROM `sc` where city='Columbia' && SIC_code='5461'DB:business_master_new
loadtime:0.35794901847839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conestee' limit 1
loadtime:0.35800004005432 / seconds
Query Executed:select id FROM `sc` where city='Conestee' && SIC_code='5461'DB:business_master_new
loadtime:0.36071801185608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Converse' limit 1
loadtime:0.36075401306152 / seconds
Query Executed:select id FROM `sc` where city='Converse' && SIC_code='5461'DB:business_master_new
loadtime:0.36243796348572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.36246991157532 / seconds
Query Executed:select id FROM `sc` where city='Conway' && SIC_code='5461'DB:business_master_new
loadtime:0.36488509178162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coosawatchie' limit 1
loadtime:0.36492490768433 / seconds
Query Executed:select id FROM `sc` where city='Coosawatchie' && SIC_code='5461'DB:business_master_new
loadtime:0.36520504951477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cope' limit 1
loadtime:0.36524295806885 / seconds
Query Executed:select id FROM `sc` where city='Cope' && SIC_code='5461'DB:business_master_new
loadtime:0.36568593978882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cordesville' limit 1
loadtime:0.36571097373962 / seconds
Query Executed:select id FROM `sc` where city='Cordesville' && SIC_code='5461'DB:business_master_new
loadtime:0.37377405166626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cordova' limit 1
loadtime:0.37380909919739 / seconds
Query Executed:select id FROM `sc` where city='Cordova' && SIC_code='5461'DB:business_master_new
loadtime:0.37424397468567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottageville' limit 1
loadtime:0.37427806854248 / seconds
Query Executed:select id FROM `sc` where city='Cottageville' && SIC_code='5461'DB:business_master_new
loadtime:0.37471699714661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coward' limit 1
loadtime:0.37474608421326 / seconds
Query Executed:select id FROM `sc` where city='Coward' && SIC_code='5461'DB:business_master_new
loadtime:0.37516689300537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cowpens' limit 1
loadtime:0.37520289421082 / seconds
Query Executed:select id FROM `sc` where city='Cowpens' && SIC_code='5461'DB:business_master_new
loadtime:0.37567710876465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crocketville' limit 1
loadtime:0.3757119178772 / seconds
Query Executed:select id FROM `sc` where city='Crocketville' && SIC_code='5461'DB:business_master_new
loadtime:0.37619495391846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross' limit 1
loadtime:0.37623310089111 / seconds
Query Executed:select id FROM `sc` where city='Cross' && SIC_code='5461'DB:business_master_new
loadtime:0.37665891647339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross Anchor' limit 1
loadtime:0.37669110298157 / seconds
Query Executed:select id FROM `sc` where city='Cross Anchor' && SIC_code='5461'DB:business_master_new
loadtime:0.37817096710205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross Hill' limit 1
loadtime:0.3782000541687 / seconds
Query Executed:select id FROM `sc` where city='Cross Hill' && SIC_code='5461'DB:business_master_new
loadtime:0.37861609458923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dale' limit 1
loadtime:0.37865090370178 / seconds
Query Executed:select id FROM `sc` where city='Dale' && SIC_code='5461'DB:business_master_new
loadtime:0.37969994544983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dalzell' limit 1
loadtime:0.37973093986511 / seconds
Query Executed:select id FROM `sc` where city='Dalzell' && SIC_code='5461'DB:business_master_new
loadtime:0.38018107414246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daniel Island' limit 1
loadtime:0.38020610809326 / seconds
Query Executed:select id FROM `sc` where city='Daniel Island' && SIC_code='5461'DB:business_master_new
loadtime:0.38044309616089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darlington' limit 1
loadtime:0.38047409057617 / seconds
Query Executed:select id FROM `sc` where city='Darlington' && SIC_code='5461'DB:business_master_new
loadtime:0.38119506835938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daufuskie Island' limit 1
loadtime:0.38123607635498 / seconds
Query Executed:select id FROM `sc` where city='Daufuskie Island' && SIC_code='5461'DB:business_master_new
loadtime:0.3863410949707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis Station' limit 1
loadtime:0.38637208938599 / seconds
Query Executed:select id FROM `sc` where city='Davis Station' && SIC_code='5461'DB:business_master_new
loadtime:0.39011907577515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denmark' limit 1
loadtime:0.39015197753906 / seconds
Query Executed:select id FROM `sc` where city='Denmark' && SIC_code='5461'DB:business_master_new
loadtime:0.39061594009399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewees Island' limit 1
loadtime:0.39065599441528 / seconds
Query Executed:select id FROM `sc` where city='Dewees Island' && SIC_code='5461'DB:business_master_new
loadtime:0.39088201522827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dillon' limit 1
loadtime:0.39091396331787 / seconds
Query Executed:select id FROM `sc` where city='Dillon' && SIC_code='5461'DB:business_master_new
loadtime:0.39153504371643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Donalds' limit 1
loadtime:0.3915650844574 / seconds
Query Executed:select id FROM `sc` where city='Donalds' && SIC_code='5461'DB:business_master_new
loadtime:0.3919529914856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:0.3919849395752 / seconds
Query Executed:select id FROM `sc` where city='Dorchester' && SIC_code='5461'DB:business_master_new
loadtime:0.39238095283508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drayton' limit 1
loadtime:0.39241099357605 / seconds
Query Executed:select id FROM `sc` where city='Drayton' && SIC_code='5461'DB:business_master_new
loadtime:0.40260004997253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Due West' limit 1
loadtime:0.4026460647583 / seconds
Query Executed:select id FROM `sc` where city='Due West' && SIC_code='5461'DB:business_master_new
loadtime:0.40307688713074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duncan' limit 1
loadtime:0.40311598777771 / seconds
Query Executed:select id FROM `sc` where city='Duncan' && SIC_code='5461'DB:business_master_new
loadtime:0.40366196632385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Early Branch' limit 1
loadtime:0.40368700027466 / seconds
Query Executed:select id FROM `sc` where city='Early Branch' && SIC_code='5461'DB:business_master_new
loadtime:0.41010308265686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easley' limit 1
loadtime:0.41015005111694 / seconds
Query Executed:select id FROM `sc` where city='Easley' && SIC_code='5461'DB:business_master_new
loadtime:0.41259288787842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastover' limit 1
loadtime:0.41266012191772 / seconds
Query Executed:select id FROM `sc` where city='Eastover' && SIC_code='5461'DB:business_master_new
loadtime:0.41311812400818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgefield' limit 1
loadtime:0.41317009925842 / seconds
Query Executed:select id FROM `sc` where city='Edgefield' && SIC_code='5461'DB:business_master_new
loadtime:0.41369795799255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgemoor' limit 1
loadtime:0.41374707221985 / seconds
Query Executed:select id FROM `sc` where city='Edgemoor' && SIC_code='5461'DB:business_master_new
loadtime:0.4141891002655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edisto Island' limit 1
loadtime:0.41421699523926 / seconds
Query Executed:select id FROM `sc` where city='Edisto Island' && SIC_code='5461'DB:business_master_new
loadtime:0.41469812393188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Effingham' limit 1
loadtime:0.41474390029907 / seconds
Query Executed:select id FROM `sc` where city='Effingham' && SIC_code='5461'DB:business_master_new
loadtime:0.41523408889771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ehrhardt' limit 1
loadtime:0.41527509689331 / seconds
Query Executed:select id FROM `sc` where city='Ehrhardt' && SIC_code='5461'DB:business_master_new
loadtime:0.41571402549744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elgin' limit 1
loadtime:0.41576099395752 / seconds
Query Executed:select id FROM `sc` where city='Elgin' && SIC_code='5461'DB:business_master_new
loadtime:0.41629099845886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elko' limit 1
loadtime:0.41632795333862 / seconds
Query Executed:select id FROM `sc` where city='Elko' && SIC_code='5461'DB:business_master_new
loadtime:0.42292404174805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elliott' limit 1
loadtime:0.4229679107666 / seconds
Query Executed:select id FROM `sc` where city='Elliott' && SIC_code='5461'DB:business_master_new
loadtime:0.42586708068848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elloree' limit 1
loadtime:0.42590188980103 / seconds
Query Executed:select id FROM `sc` where city='Elloree' && SIC_code='5461'DB:business_master_new
loadtime:0.42640089988708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enoree' limit 1
loadtime:0.42644810676575 / seconds
Query Executed:select id FROM `sc` where city='Enoree' && SIC_code='5461'DB:business_master_new
loadtime:0.42689490318298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estill' limit 1
loadtime:0.42693710327148 / seconds
Query Executed:select id FROM `sc` where city='Estill' && SIC_code='5461'DB:business_master_new
loadtime:0.42746090888977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eutawville' limit 1
loadtime:0.42751002311707 / seconds
Query Executed:select id FROM `sc` where city='Eutawville' && SIC_code='5461'DB:business_master_new
loadtime:0.4279990196228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Play' limit 1
loadtime:0.42807006835938 / seconds
Query Executed:select id FROM `sc` where city='Fair Play' && SIC_code='5461'DB:business_master_new
loadtime:0.42855310440063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.42860698699951 / seconds
Query Executed:select id FROM `sc` where city='Fairfax' && SIC_code='5461'DB:business_master_new
loadtime:0.42906188964844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairforest' limit 1
loadtime:0.4290919303894 / seconds
Query Executed:select id FROM `sc` where city='Fairforest' && SIC_code='5461'DB:business_master_new
loadtime:0.43556904792786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fingerville' limit 1
loadtime:0.43561911582947 / seconds
Query Executed:select id FROM `sc` where city='Fingerville' && SIC_code='5461'DB:business_master_new
loadtime:0.43721294403076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.43725895881653 / seconds
Query Executed:select id FROM `sc` where city='Florence' && SIC_code='5461'DB:business_master_new
loadtime:0.43973898887634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Folly Beach' limit 1
loadtime:0.4398250579834 / seconds
Query Executed:select id FROM `sc` where city='Folly Beach' && SIC_code='5461'DB:business_master_new
loadtime:0.4403669834137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fork' limit 1
loadtime:0.44041609764099 / seconds
Query Executed:select id FROM `sc` where city='Fork' && SIC_code='5461'DB:business_master_new
loadtime:0.44613194465637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Lawn' limit 1
loadtime:0.4461829662323 / seconds
Query Executed:select id FROM `sc` where city='Fort Lawn' && SIC_code='5461'DB:business_master_new
loadtime:0.44666910171509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mill' limit 1
loadtime:0.44673204421997 / seconds
Query Executed:select id FROM `sc` where city='Fort Mill' && SIC_code='5461'DB:business_master_new
loadtime:0.44918894767761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Motte' limit 1
loadtime:0.4492449760437 / seconds
Query Executed:select id FROM `sc` where city='Fort Motte' && SIC_code='5461'DB:business_master_new
loadtime:0.45088195800781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain Inn' limit 1
loadtime:0.45091795921326 / seconds
Query Executed:select id FROM `sc` where city='Fountain Inn' && SIC_code='5461'DB:business_master_new
loadtime:0.4515540599823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frogmore' limit 1
loadtime:0.45160007476807 / seconds
Query Executed:select id FROM `sc` where city='Frogmore' && SIC_code='5461'DB:business_master_new
loadtime:0.4518620967865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Furman' limit 1
loadtime:0.45189499855042 / seconds
Query Executed:select id FROM `sc` where city='Furman' && SIC_code='5461'DB:business_master_new
loadtime:0.45661497116089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gable' limit 1
loadtime:0.45666289329529 / seconds
Query Executed:select id FROM `sc` where city='Gable' && SIC_code='5461'DB:business_master_new
loadtime:0.46719098091125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gadsden' limit 1
loadtime:0.46722793579102 / seconds
Query Executed:select id FROM `sc` where city='Gadsden' && SIC_code='5461'DB:business_master_new
loadtime:0.47817707061768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaffney' limit 1
loadtime:0.47822904586792 / seconds
Query Executed:select id FROM `sc` where city='Gaffney' && SIC_code='5461'DB:business_master_new
loadtime:0.47911500930786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galivants Ferry' limit 1
loadtime:0.47917604446411 / seconds
Query Executed:select id FROM `sc` where city='Galivants Ferry' && SIC_code='5461'DB:business_master_new
loadtime:0.4796769618988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garnett' limit 1
loadtime:0.47973990440369 / seconds
Query Executed:select id FROM `sc` where city='Garnett' && SIC_code='5461'DB:business_master_new
loadtime:0.49742889404297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaston' limit 1
loadtime:0.49747705459595 / seconds
Query Executed:select id FROM `sc` where city='Gaston' && SIC_code='5461'DB:business_master_new
loadtime:0.49800395965576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:0.49804997444153 / seconds
Query Executed:select id FROM `sc` where city='Georgetown' && SIC_code='5461'DB:business_master_new
loadtime:0.49895095825195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gifford' limit 1
loadtime:0.49900603294373 / seconds
Query Executed:select id FROM `sc` where city='Gifford' && SIC_code='5461'DB:business_master_new
loadtime:0.50073504447937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbert' limit 1
loadtime:0.50077795982361 / seconds
Query Executed:select id FROM `sc` where city='Gilbert' && SIC_code='5461'DB:business_master_new
loadtime:0.50131511688232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1
loadtime:0.50134992599487 / seconds
Query Executed:select id FROM `sc` where city='Glendale' && SIC_code='5461'DB:business_master_new
loadtime:0.50486207008362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenn Springs' limit 1
loadtime:0.50490307807922 / seconds
Query Executed:select id FROM `sc` where city='Glenn Springs' && SIC_code='5461'DB:business_master_new
loadtime:0.50515294075012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloverville' limit 1
loadtime:0.50520300865173 / seconds
Query Executed:select id FROM `sc` where city='Gloverville' && SIC_code='5461'DB:business_master_new
loadtime:0.51375198364258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goose Creek' limit 1
loadtime:0.5137939453125 / seconds
Query Executed:select id FROM `sc` where city='Goose Creek' && SIC_code='5461'DB:business_master_new
loadtime:0.51467108726501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gramling' limit 1
loadtime:0.51472997665405 / seconds
Query Executed:select id FROM `sc` where city='Gramling' && SIC_code='5461'DB:business_master_new
loadtime:0.5199179649353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graniteville' limit 1
loadtime:0.51996302604675 / seconds
Query Executed:select id FROM `sc` where city='Graniteville' && SIC_code='5461'DB:business_master_new
loadtime:0.52049994468689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gray Court' limit 1
loadtime:0.52054905891418 / seconds
Query Executed:select id FROM `sc` where city='Gray Court' && SIC_code='5461'DB:business_master_new
loadtime:0.52107810974121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Falls' limit 1
loadtime:0.52112603187561 / seconds
Query Executed:select id FROM `sc` where city='Great Falls' && SIC_code='5461'DB:business_master_new
loadtime:0.52163910865784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greeleyville' limit 1
loadtime:0.52168297767639 / seconds
Query Executed:select id FROM `sc` where city='Greeleyville' && SIC_code='5461'DB:business_master_new
loadtime:0.52216410636902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Pond' limit 1
loadtime:0.52220296859741 / seconds
Query Executed:select id FROM `sc` where city='Green Pond' && SIC_code='5461'DB:business_master_new
loadtime:0.52267289161682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Sea' limit 1
loadtime:0.52270793914795 / seconds
Query Executed:select id FROM `sc` where city='Green Sea' && SIC_code='5461'DB:business_master_new
loadtime:0.54211807250977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.54222106933594 / seconds
Query Executed:select id FROM `sc` where city='Greenville' && SIC_code='5461'DB:business_master_new
loadtime:0.54494309425354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood' limit 1
loadtime:0.5450119972229 / seconds
Query Executed:select id FROM `sc` where city='Greenwood' && SIC_code='5461'DB:business_master_new
loadtime:0.5475161075592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greer' limit 1
loadtime:0.54757499694824 / seconds
Query Executed:select id FROM `sc` where city='Greer' && SIC_code='5461'DB:business_master_new
loadtime:0.5500500202179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gresham' limit 1
loadtime:0.55012512207031 / seconds
Query Executed:select id FROM `sc` where city='Gresham' && SIC_code='5461'DB:business_master_new
loadtime:0.55060696601868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grover' limit 1
loadtime:0.55066609382629 / seconds
Query Executed:select id FROM `sc` where city='Grover' && SIC_code='5461'DB:business_master_new
loadtime:0.55172991752625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamer' limit 1
loadtime:0.55177688598633 / seconds
Query Executed:select id FROM `sc` where city='Hamer' && SIC_code='5461'DB:business_master_new
loadtime:0.5522301197052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:0.55226397514343 / seconds
Query Executed:select id FROM `sc` where city='Hampton' && SIC_code='5461'DB:business_master_new
loadtime:0.55280804634094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanahan' limit 1
loadtime:0.55284404754639 / seconds
Query Executed:select id FROM `sc` where city='Hanahan' && SIC_code='5461'DB:business_master_new
loadtime:0.55346012115479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardeeville' limit 1
loadtime:0.55351901054382 / seconds
Query Executed:select id FROM `sc` where city='Hardeeville' && SIC_code='5461'DB:business_master_new
loadtime:0.55409693717957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harleyville' limit 1
loadtime:0.55413889884949 / seconds
Query Executed:select id FROM `sc` where city='Harleyville' && SIC_code='5461'DB:business_master_new
loadtime:0.55459094047546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartsville' limit 1
loadtime:0.55464005470276 / seconds
Query Executed:select id FROM `sc` where city='Hartsville' && SIC_code='5461'DB:business_master_new
loadtime:0.55546808242798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heath Springs' limit 1
loadtime:0.55552101135254 / seconds
Query Executed:select id FROM `sc` where city='Heath Springs' && SIC_code='5461'DB:business_master_new
loadtime:0.55598902702332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hemingway' limit 1
loadtime:0.55606889724731 / seconds
Query Executed:select id FROM `sc` where city='Hemingway' && SIC_code='5461'DB:business_master_new
loadtime:0.55664706230164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hickory Grove' limit 1
loadtime:0.55668997764587 / seconds
Query Executed:select id FROM `sc` where city='Hickory Grove' && SIC_code='5461'DB:business_master_new
loadtime:0.56846499443054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hilda' limit 1
loadtime:0.56851601600647 / seconds
Query Executed:select id FROM `sc` where city='Hilda' && SIC_code='5461'DB:business_master_new
loadtime:0.57084894180298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hilton Head Island' limit 1
loadtime:0.57090091705322 / seconds
Query Executed:select id FROM `sc` where city='Hilton Head Island' && SIC_code='5461'DB:business_master_new
loadtime:0.57340312004089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hilton Head Isle' limit 1
loadtime:0.57346606254578 / seconds
Query Executed:select id FROM `sc` where city='Hilton Head Isle' && SIC_code='5461'DB:business_master_new
loadtime:0.57402396202087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hodges' limit 1
loadtime:0.57408094406128 / seconds
Query Executed:select id FROM `sc` where city='Hodges' && SIC_code='5461'DB:business_master_new
loadtime:0.57458710670471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Hill' limit 1
loadtime:0.57463693618774 / seconds
Query Executed:select id FROM `sc` where city='Holly Hill' && SIC_code='5461'DB:business_master_new
loadtime:0.57518291473389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollywood' limit 1
loadtime:0.57522106170654 / seconds
Query Executed:select id FROM `sc` where city='Hollywood' && SIC_code='5461'DB:business_master_new
loadtime:0.57577300071716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honea Path' limit 1
loadtime:0.57581400871277 / seconds
Query Executed:select id FROM `sc` where city='Honea Path' && SIC_code='5461'DB:business_master_new
loadtime:0.576327085495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkins' limit 1
loadtime:0.57636904716492 / seconds
Query Executed:select id FROM `sc` where city='Hopkins' && SIC_code='5461'DB:business_master_new
loadtime:0.57688307762146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horatio' limit 1
loadtime:0.57692790031433 / seconds
Query Executed:select id FROM `sc` where city='Horatio' && SIC_code='5461'DB:business_master_new
loadtime:0.57975006103516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huger' limit 1
loadtime:0.57979989051819 / seconds
Query Executed:select id FROM `sc` where city='Huger' && SIC_code='5461'DB:business_master_new
loadtime:0.58029294013977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Inman' limit 1
loadtime:0.58033299446106 / seconds
Query Executed:select id FROM `sc` where city='Inman' && SIC_code='5461'DB:business_master_new
loadtime:0.5810079574585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irmo' limit 1
loadtime:0.5810809135437 / seconds
Query Executed:select id FROM `sc` where city='Irmo' && SIC_code='5461'DB:business_master_new
loadtime:0.58354997634888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Islandton' limit 1
loadtime:0.58359408378601 / seconds
Query Executed:select id FROM `sc` where city='Islandton' && SIC_code='5461'DB:business_master_new
loadtime:0.59661197662354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isle Of Palms' limit 1
loadtime:0.59666395187378 / seconds
Query Executed:select id FROM `sc` where city='Isle Of Palms' && SIC_code='5461'DB:business_master_new
loadtime:0.59729099273682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iva' limit 1
loadtime:0.59732508659363 / seconds
Query Executed:select id FROM `sc` where city='Iva' && SIC_code='5461'DB:business_master_new
loadtime:0.59778904914856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:0.59783911705017 / seconds
Query Executed:select id FROM `sc` where city='Jackson' && SIC_code='5461'DB:business_master_new
loadtime:0.5982780456543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jacksonboro' limit 1
loadtime:0.59832000732422 / seconds
Query Executed:select id FROM `sc` where city='Jacksonboro' && SIC_code='5461'DB:business_master_new
loadtime:0.60678791999817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:0.60684609413147 / seconds
Query Executed:select id FROM `sc` where city='Jamestown' && SIC_code='5461'DB:business_master_new
loadtime:0.63630604743958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:0.63635396957397 / seconds
Query Executed:select id FROM `sc` where city='Jefferson' && SIC_code='5461'DB:business_master_new
loadtime:0.63682794570923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jenkinsville' limit 1
loadtime:0.63686609268188 / seconds
Query Executed:select id FROM `sc` where city='Jenkinsville' && SIC_code='5461'DB:business_master_new
loadtime:0.64458799362183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joanna' limit 1
loadtime:0.64463901519775 / seconds
Query Executed:select id FROM `sc` where city='Joanna' && SIC_code='5461'DB:business_master_new
loadtime:0.64508605003357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johns Island' limit 1
loadtime:0.64512300491333 / seconds
Query Executed:select id FROM `sc` where city='Johns Island' && SIC_code='5461'DB:business_master_new
loadtime:0.64583802223206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnsonville' limit 1
loadtime:0.64588904380798 / seconds
Query Executed:select id FROM `sc` where city='Johnsonville' && SIC_code='5461'DB:business_master_new
loadtime:0.64644193649292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnston' limit 1
loadtime:0.64650106430054 / seconds
Query Executed:select id FROM `sc` where city='Johnston' && SIC_code='5461'DB:business_master_new
loadtime:0.64702010154724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:0.64707207679749 / seconds
Query Executed:select id FROM `sc` where city='Jonesville' && SIC_code='5461'DB:business_master_new
loadtime:0.64756798744202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kershaw' limit 1
loadtime:0.64761805534363 / seconds
Query Executed:select id FROM `sc` where city='Kershaw' && SIC_code='5461'DB:business_master_new
loadtime:0.64815998077393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kiawah Island' limit 1
loadtime:0.64820599555969 / seconds
Query Executed:select id FROM `sc` where city='Kiawah Island' && SIC_code='5461'DB:business_master_new
loadtime:0.64853096008301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinards' limit 1
loadtime:0.64858102798462 / seconds
Query Executed:select id FROM `sc` where city='Kinards' && SIC_code='5461'DB:business_master_new
loadtime:0.65700507164001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kings Creek' limit 1
loadtime:0.65707302093506 / seconds
Query Executed:select id FROM `sc` where city='Kings Creek' && SIC_code='5461'DB:business_master_new
loadtime:0.6573441028595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingstree' limit 1
loadtime:0.65737199783325 / seconds
Query Executed:select id FROM `sc` where city='Kingstree' && SIC_code='5461'DB:business_master_new
loadtime:0.65808200836182 / seconds
Query loaded from cache:select * from geodata_geocity where city='La France' limit 1
loadtime:0.65813899040222 / seconds
Query Executed:select id FROM `sc` where city='La France' && SIC_code='5461'DB:business_master_new
loadtime:0.6612811088562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ladson' limit 1
loadtime:0.66131711006165 / seconds
Query Executed:select id FROM `sc` where city='Ladson' && SIC_code='5461'DB:business_master_new
loadtime:0.6619279384613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ladys Island' limit 1
loadtime:0.66197896003723 / seconds
Query Executed:select id FROM `sc` where city='Ladys Island' && SIC_code='5461'DB:business_master_new
loadtime:0.66275310516357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake City' limit 1
loadtime:0.66280007362366 / seconds
Query Executed:select id FROM `sc` where city='Lake City' && SIC_code='5461'DB:business_master_new
loadtime:0.66355204582214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake View' limit 1
loadtime:0.66360998153687 / seconds
Query Executed:select id FROM `sc` where city='Lake View' && SIC_code='5461'DB:business_master_new
loadtime:0.6640739440918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Wylie' limit 1
loadtime:0.66410994529724 / seconds
Query Executed:select id FROM `sc` where city='Lake Wylie' && SIC_code='5461'DB:business_master_new
loadtime:0.67025899887085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamar' limit 1
loadtime:0.67031002044678 / seconds
Query Executed:select id FROM `sc` where city='Lamar' && SIC_code='5461'DB:business_master_new
loadtime:0.67078399658203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:0.6708300113678 / seconds
Query Executed:select id FROM `sc` where city='Lancaster' && SIC_code='5461'DB:business_master_new
loadtime:0.67331194877625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lando' limit 1
loadtime:0.67337393760681 / seconds
Query Executed:select id FROM `sc` where city='Lando' && SIC_code='5461'DB:business_master_new
loadtime:0.67427611351013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Landrum' limit 1
loadtime:0.67432594299316 / seconds
Query Executed:select id FROM `sc` where city='Landrum' && SIC_code='5461'DB:business_master_new
loadtime:0.67490792274475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lane' limit 1
loadtime:0.67495489120483 / seconds
Query Executed:select id FROM `sc` where city='Lane' && SIC_code='5461'DB:business_master_new
loadtime:0.68633604049683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langley' limit 1
loadtime:0.68637204170227 / seconds
Query Executed:select id FROM `sc` where city='Langley' && SIC_code='5461'DB:business_master_new
loadtime:0.69669604301453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Latta' limit 1
loadtime:0.69674611091614 / seconds
Query Executed:select id FROM `sc` where city='Latta' && SIC_code='5461'DB:business_master_new
loadtime:0.69731402397156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurens' limit 1
loadtime:0.69735407829285 / seconds
Query Executed:select id FROM `sc` where city='Laurens' && SIC_code='5461'DB:business_master_new
loadtime:0.69810199737549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leesville' limit 1
loadtime:0.69814610481262 / seconds
Query Executed:select id FROM `sc` where city='Leesville' && SIC_code='5461'DB:business_master_new
loadtime:0.69874501228333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:0.69880390167236 / seconds
Query Executed:select id FROM `sc` where city='Lexington' && SIC_code='5461'DB:business_master_new
loadtime:0.70128202438354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty' limit 1
loadtime:0.70134210586548 / seconds
Query Executed:select id FROM `sc` where city='Liberty' && SIC_code='5461'DB:business_master_new
loadtime:0.70192694664001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty Hill' limit 1
loadtime:0.7019739151001 / seconds
Query Executed:select id FROM `sc` where city='Liberty Hill' && SIC_code='5461'DB:business_master_new
loadtime:0.7050929069519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincolnville' limit 1
loadtime:0.70513510704041 / seconds
Query Executed:select id FROM `sc` where city='Lincolnville' && SIC_code='5461'DB:business_master_new
loadtime:0.70542192459106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Mountain' limit 1
loadtime:0.70546293258667 / seconds
Query Executed:select id FROM `sc` where city='Little Mountain' && SIC_code='5461'DB:business_master_new
loadtime:0.70588898658752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little River' limit 1
loadtime:0.70591497421265 / seconds
Query Executed:select id FROM `sc` where city='Little River' && SIC_code='5461'DB:business_master_new
loadtime:0.70659494400024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Rock' limit 1
loadtime:0.70665097236633 / seconds
Query Executed:select id FROM `sc` where city='Little Rock' && SIC_code='5461'DB:business_master_new
loadtime:0.71240997314453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Livingston' limit 1
loadtime:0.71245908737183 / seconds
Query Executed:select id FROM `sc` where city='Livingston' && SIC_code='5461'DB:business_master_new
loadtime:0.71337199211121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lobeco' limit 1
loadtime:0.71342611312866 / seconds
Query Executed:select id FROM `sc` where city='Lobeco' && SIC_code='5461'DB:business_master_new
loadtime:0.71707105636597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lockhart' limit 1
loadtime:0.71710801124573 / seconds
Query Executed:select id FROM `sc` where city='Lockhart' && SIC_code='5461'DB:business_master_new
loadtime:0.72368001937866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lodge' limit 1
loadtime:0.72373008728027 / seconds
Query Executed:select id FROM `sc` where city='Lodge' && SIC_code='5461'DB:business_master_new
loadtime:0.72419309616089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lone Star' limit 1
loadtime:0.72423195838928 / seconds
Query Executed:select id FROM `sc` where city='Lone Star' && SIC_code='5461'DB:business_master_new
loadtime:0.72620511054993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Creek' limit 1
loadtime:0.72625589370728 / seconds
Query Executed:select id FROM `sc` where city='Long Creek' && SIC_code='5461'DB:business_master_new
loadtime:0.73365306854248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longs' limit 1
loadtime:0.73369693756104 / seconds
Query Executed:select id FROM `sc` where city='Longs' && SIC_code='5461'DB:business_master_new
loadtime:0.73427295684814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loris' limit 1
loadtime:0.73431801795959 / seconds
Query Executed:select id FROM `sc` where city='Loris' && SIC_code='5461'DB:business_master_new
loadtime:0.73496890068054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowndesville' limit 1
loadtime:0.735023021698 / seconds
Query Executed:select id FROM `sc` where city='Lowndesville' && SIC_code='5461'DB:business_master_new
loadtime:0.73810505867004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lugoff' limit 1
loadtime:0.73814010620117 / seconds
Query Executed:select id FROM `sc` where city='Lugoff' && SIC_code='5461'DB:business_master_new
loadtime:0.73877692222595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luray' limit 1
loadtime:0.73883700370789 / seconds
Query Executed:select id FROM `sc` where city='Luray' && SIC_code='5461'DB:business_master_new
loadtime:0.74569702148438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lydia' limit 1
loadtime:0.74584293365479 / seconds
Query Executed:select id FROM `sc` where city='Lydia' && SIC_code='5461'DB:business_master_new
loadtime:0.74818205833435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyman' limit 1
loadtime:0.74832797050476 / seconds
Query Executed:select id FROM `sc` where city='Lyman' && SIC_code='5461'DB:business_master_new
loadtime:0.7489869594574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynchburg' limit 1
loadtime:0.74920797348022 / seconds
Query Executed:select id FROM `sc` where city='Lynchburg' && SIC_code='5461'DB:business_master_new
loadtime:0.74981808662415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manning' limit 1
loadtime:0.74993896484375 / seconds
Query Executed:select id FROM `sc` where city='Manning' && SIC_code='5461'DB:business_master_new
loadtime:0.75080490112305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marietta' limit 1
loadtime:0.75095701217651 / seconds
Query Executed:select id FROM `sc` where city='Marietta' && SIC_code='5461'DB:business_master_new
loadtime:0.75166201591492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.75181102752686 / seconds
Query Executed:select id FROM `sc` where city='Marion' && SIC_code='5461'DB:business_master_new
loadtime:0.7526159286499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martin' limit 1
loadtime:0.75276494026184 / seconds
Query Executed:select id FROM `sc` where city='Martin' && SIC_code='5461'DB:business_master_new
loadtime:0.75835609436035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mauldin' limit 1
loadtime:0.75847196578979 / seconds
Query Executed:select id FROM `sc` where city='Mauldin' && SIC_code='5461'DB:business_master_new
loadtime:0.75922203063965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayesville' limit 1
loadtime:0.75938200950623 / seconds
Query Executed:select id FROM `sc` where city='Mayesville' && SIC_code='5461'DB:business_master_new
loadtime:0.7599561214447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayo' limit 1
loadtime:0.76011395454407 / seconds
Query Executed:select id FROM `sc` where city='Mayo' && SIC_code='5461'DB:business_master_new
loadtime:0.77173590660095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Bee' limit 1
loadtime:0.77178597450256 / seconds
Query Executed:select id FROM `sc` where city='Mc Bee' && SIC_code='5461'DB:business_master_new
loadtime:0.77230000495911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Clellanville' limit 1
loadtime:0.77233910560608 / seconds
Query Executed:select id FROM `sc` where city='Mc Clellanville' && SIC_code='5461'DB:business_master_new
loadtime:0.7728168964386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Coll' limit 1
loadtime:0.7728590965271 / seconds
Query Executed:select id FROM `sc` where city='Mc Coll' && SIC_code='5461'DB:business_master_new
loadtime:0.77341389656067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Connells' limit 1
loadtime:0.77346301078796 / seconds
Query Executed:select id FROM `sc` where city='Mc Connells' && SIC_code='5461'DB:business_master_new
loadtime:0.78572201728821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Cormick' limit 1
loadtime:0.78575801849365 / seconds
Query Executed:select id FROM `sc` where city='Mc Cormick' && SIC_code='5461'DB:business_master_new
loadtime:0.78636789321899 / seconds
Query Executed:select * from geodata_geocity where city='Mccormick' limit 1DB:business_master_new
loadtime:0.78669595718384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meggett' limit 1
loadtime:0.78674411773682 / seconds
Query Executed:select id FROM `sc` where city='Meggett' && SIC_code='5461'DB:business_master_new
loadtime:0.78721904754639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miley' limit 1
loadtime:0.78725910186768 / seconds
Query Executed:select id FROM `sc` where city='Miley' && SIC_code='5461'DB:business_master_new
loadtime:0.78789591789246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minturn' limit 1
loadtime:0.78793811798096 / seconds
Query Executed:select id FROM `sc` where city='Minturn' && SIC_code='5461'DB:business_master_new
loadtime:0.78851509094238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modoc' limit 1
loadtime:0.78856897354126 / seconds
Query Executed:select id FROM `sc` where city='Modoc' && SIC_code='5461'DB:business_master_new
loadtime:0.79244208335876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moncks Corner' limit 1
loadtime:0.79257798194885 / seconds
Query Executed:select id FROM `sc` where city='Moncks Corner' && SIC_code='5461'DB:business_master_new
loadtime:0.79361200332642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monetta' limit 1
loadtime:0.79371190071106 / seconds
Query Executed:select id FROM `sc` where city='Monetta' && SIC_code='5461'DB:business_master_new
loadtime:0.79417395591736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:0.79428100585938 / seconds
Query Executed:select id FROM `sc` where city='Monticello' && SIC_code='5461'DB:business_master_new
loadtime:0.79499912261963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montmorenci' limit 1
loadtime:0.79503893852234 / seconds
Query Executed:select id FROM `sc` where city='Montmorenci' && SIC_code='5461'DB:business_master_new
loadtime:0.79913592338562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moore' limit 1
loadtime:0.79918694496155 / seconds
Query Executed:select id FROM `sc` where city='Moore' && SIC_code='5461'DB:business_master_new
loadtime:0.79970693588257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Carmel' limit 1
loadtime:0.79980492591858 / seconds
Query Executed:select id FROM `sc` where city='Mount Carmel' && SIC_code='5461'DB:business_master_new
loadtime:0.80320000648499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Croghan' limit 1
loadtime:0.8033390045166 / seconds
Query Executed:select id FROM `sc` where city='Mount Croghan' && SIC_code='5461'DB:business_master_new
loadtime:0.81204509735107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:0.8121120929718 / seconds
Query Executed:select id FROM `sc` where city='Mount Pleasant' && SIC_code='5461'DB:business_master_new
loadtime:0.81468796730042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain Rest' limit 1
loadtime:0.814857006073 / seconds
Query Executed:select id FROM `sc` where city='Mountain Rest' && SIC_code='5461'DB:business_master_new
loadtime:0.82921099662781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountville' limit 1
loadtime:0.8292670249939 / seconds
Query Executed:select id FROM `sc` where city='Mountville' && SIC_code='5461'DB:business_master_new
loadtime:0.83566188812256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Carmel' limit 1
loadtime:0.83572101593018 / seconds
Query Executed:select id FROM `sc` where city='Mt Carmel' && SIC_code='5461'DB:business_master_new
loadtime:0.83666396141052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Croghan' limit 1
loadtime:0.83671593666077 / seconds
Query Executed:select id FROM `sc` where city='Mt Croghan' && SIC_code='5461'DB:business_master_new
loadtime:0.8372220993042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:0.83726000785828 / seconds
Query Executed:select id FROM `sc` where city='Mt Pleasant' && SIC_code='5461'DB:business_master_new
loadtime:0.83773303031921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mullins' limit 1
loadtime:0.83778810501099 / seconds
Query Executed:select id FROM `sc` where city='Mullins' && SIC_code='5461'DB:business_master_new
loadtime:0.83843302726746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murrells Inlet' limit 1
loadtime:0.83847689628601 / seconds
Query Executed:select id FROM `sc` where city='Murrells Inlet' && SIC_code='5461'DB:business_master_new
loadtime:0.83942604064941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Myrtle Beach' limit 1
loadtime:0.83949303627014 / seconds
Query Executed:select id FROM `sc` where city='Myrtle Beach' && SIC_code='5461'DB:business_master_new
loadtime:0.84201788902283 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Charleston' limit 1
loadtime:0.84209299087524 / seconds
Query Executed:select id FROM `sc` where city='N Charleston' && SIC_code='5461'DB:business_master_new
loadtime:0.84233808517456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neeses' limit 1
loadtime:0.84238600730896 / seconds
Query Executed:select id FROM `sc` where city='Neeses' && SIC_code='5461'DB:business_master_new
loadtime:0.8428680896759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nesmith' limit 1
loadtime:0.84291100502014 / seconds
Query Executed:select id FROM `sc` where city='Nesmith' && SIC_code='5461'DB:business_master_new
loadtime:0.85237598419189 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Ellenton' limit 1
loadtime:0.85242605209351 / seconds
Query Executed:select id FROM `sc` where city='New Ellenton' && SIC_code='5461'DB:business_master_new
loadtime:0.85292196273804 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Zion' limit 1
loadtime:0.85295796394348 / seconds
Query Executed:select id FROM `sc` where city='New Zion' && SIC_code='5461'DB:business_master_new
loadtime:0.86158895492554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newberry' limit 1
loadtime:0.86164212226868 / seconds
Query Executed:select id FROM `sc` where city='Newberry' && SIC_code='5461'DB:business_master_new
loadtime:0.86246800422668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newry' limit 1
loadtime:0.86251902580261 / seconds
Query Executed:select id FROM `sc` where city='Newry' && SIC_code='5461'DB:business_master_new
loadtime:0.86304211616516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nichols' limit 1
loadtime:0.86310601234436 / seconds
Query Executed:select id FROM `sc` where city='Nichols' && SIC_code='5461'DB:business_master_new
loadtime:0.86359906196594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ninety Six' limit 1
loadtime:0.86364507675171 / seconds
Query Executed:select id FROM `sc` where city='Ninety Six' && SIC_code='5461'DB:business_master_new
loadtime:0.86413788795471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norris' limit 1
loadtime:0.86417603492737 / seconds
Query Executed:select id FROM `sc` where city='Norris' && SIC_code='5461'DB:business_master_new
loadtime:0.86975908279419 / seconds
Query loaded from cache:select * from geodata_geocity where city='North' limit 1
loadtime:0.86981010437012 / seconds
Query Executed:select id FROM `sc` where city='North' && SIC_code='5461'DB:business_master_new
loadtime:0.87031006813049 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Augusta' limit 1
loadtime:0.87034797668457 / seconds
Query Executed:select id FROM `sc` where city='North Augusta' && SIC_code='5461'DB:business_master_new
loadtime:0.87125897407532 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Charleston' limit 1
loadtime:0.87130904197693 / seconds
Query Executed:select id FROM `sc` where city='North Charleston' && SIC_code='5461'DB:business_master_new
loadtime:0.87382292747498 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Myrtle Bch' limit 1
loadtime:0.87388396263123 / seconds
Query Executed:select id FROM `sc` where city='North Myrtle Bch' && SIC_code='5461'DB:business_master_new
loadtime:0.87437295913696 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Myrtle Beach' limit 1
loadtime:0.87440896034241 / seconds
Query Executed:select id FROM `sc` where city='North Myrtle Beach' && SIC_code='5461'DB:business_master_new
loadtime:0.87549710273743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norway' limit 1
loadtime:0.87556099891663 / seconds
Query Executed:select id FROM `sc` where city='Norway' && SIC_code='5461'DB:business_master_new
loadtime:0.87606310844421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Drive' limit 1
loadtime:0.87610602378845 / seconds
Query Executed:select id FROM `sc` where city='Ocean Drive' && SIC_code='5461'DB:business_master_new
loadtime:0.87638092041016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okatie' limit 1
loadtime:0.8764181137085 / seconds
Query Executed:select id FROM `sc` where city='Okatie' && SIC_code='5461'DB:business_master_new
loadtime:0.87691307067871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olanta' limit 1
loadtime:0.87695407867432 / seconds
Query Executed:select id FROM `sc` where city='Olanta' && SIC_code='5461'DB:business_master_new
loadtime:0.87746095657349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olar' limit 1
loadtime:0.87751293182373 / seconds
Query Executed:select id FROM `sc` where city='Olar' && SIC_code='5461'DB:business_master_new
loadtime:0.88825511932373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orangeburg' limit 1
loadtime:0.88829588890076 / seconds
Query Executed:select id FROM `sc` where city='Orangeburg' && SIC_code='5461'DB:business_master_new
loadtime:0.89078998565674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pacolet' limit 1
loadtime:0.89085006713867 / seconds
Query Executed:select id FROM `sc` where city='Pacolet' && SIC_code='5461'DB:business_master_new
loadtime:0.89141297340393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pacolet Mills' limit 1
loadtime:0.89146590232849 / seconds
Query Executed:select id FROM `sc` where city='Pacolet Mills' && SIC_code='5461'DB:business_master_new
loadtime:0.89494109153748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pageland' limit 1
loadtime:0.89497590065002 / seconds
Query Executed:select id FROM `sc` where city='Pageland' && SIC_code='5461'DB:business_master_new
loadtime:0.89556288719177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pamplico' limit 1
loadtime:0.89561295509338 / seconds
Query Executed:select id FROM `sc` where city='Pamplico' && SIC_code='5461'DB:business_master_new
loadtime:0.89608907699585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parksville' limit 1
loadtime:0.8961169719696 / seconds
Query Executed:select id FROM `sc` where city='Parksville' && SIC_code='5461'DB:business_master_new
loadtime:0.89664006233215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parris Island' limit 1
loadtime:0.8966920375824 / seconds
Query Executed:select id FROM `sc` where city='Parris Island' && SIC_code='5461'DB:business_master_new
loadtime:0.90008306503296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patrick' limit 1
loadtime:0.9001190662384 / seconds
Query Executed:select id FROM `sc` where city='Patrick' && SIC_code='5461'DB:business_master_new
loadtime:0.90057396888733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pauline' limit 1
loadtime:0.90062403678894 / seconds
Query Executed:select id FROM `sc` where city='Pauline' && SIC_code='5461'DB:business_master_new
loadtime:0.90109395980835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pawleys Island' limit 1
loadtime:0.90112709999084 / seconds
Query Executed:select id FROM `sc` where city='Pawleys Island' && SIC_code='5461'DB:business_master_new
loadtime:0.90187191963196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paxville' limit 1
loadtime:0.90193104743958 / seconds
Query Executed:select id FROM `sc` where city='Paxville' && SIC_code='5461'DB:business_master_new
loadtime:0.90327310562134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peak' limit 1
loadtime:0.90332508087158 / seconds
Query Executed:select id FROM `sc` where city='Peak' && SIC_code='5461'DB:business_master_new
loadtime:0.90582203865051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelion' limit 1
loadtime:0.90586304664612 / seconds
Query Executed:select id FROM `sc` where city='Pelion' && SIC_code='5461'DB:business_master_new
loadtime:0.90636706352234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelzer' limit 1
loadtime:0.90641689300537 / seconds
Query Executed:select id FROM `sc` where city='Pelzer' && SIC_code='5461'DB:business_master_new
loadtime:0.90695691108704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pendleton' limit 1
loadtime:0.90699195861816 / seconds
Query Executed:select id FROM `sc` where city='Pendleton' && SIC_code='5461'DB:business_master_new
loadtime:0.90755891799927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perry' limit 1
loadtime:0.90761399269104 / seconds
Query Executed:select id FROM `sc` where city='Perry' && SIC_code='5461'DB:business_master_new
loadtime:0.90809011459351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickens' limit 1
loadtime:0.90813112258911 / seconds
Query Executed:select id FROM `sc` where city='Pickens' && SIC_code='5461'DB:business_master_new
loadtime:0.90876603126526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piedmont' limit 1
loadtime:0.90881204605103 / seconds
Query Executed:select id FROM `sc` where city='Piedmont' && SIC_code='5461'DB:business_master_new
loadtime:0.90957808494568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pineland' limit 1
loadtime:0.90962791442871 / seconds
Query Executed:select id FROM `sc` where city='Pineland' && SIC_code='5461'DB:business_master_new
loadtime:0.91607999801636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pineville' limit 1
loadtime:0.9161319732666 / seconds
Query Executed:select id FROM `sc` where city='Pineville' && SIC_code='5461'DB:business_master_new
loadtime:0.91663503646851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinewood' limit 1
loadtime:0.91668891906738 / seconds
Query Executed:select id FROM `sc` where city='Pinewood' && SIC_code='5461'DB:business_master_new
loadtime:0.91720199584961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinopolis' limit 1
loadtime:0.91722989082336 / seconds
Query Executed:select id FROM `sc` where city='Pinopolis' && SIC_code='5461'DB:business_master_new
loadtime:0.92462301254272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plum Branch' limit 1
loadtime:0.92467308044434 / seconds
Query Executed:select id FROM `sc` where city='Plum Branch' && SIC_code='5461'DB:business_master_new
loadtime:0.93607902526855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomaria' limit 1
loadtime:0.93612790107727 / seconds
Query Executed:select id FROM `sc` where city='Pomaria' && SIC_code='5461'DB:business_master_new
loadtime:0.93660497665405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Royal' limit 1
loadtime:0.93663811683655 / seconds
Query Executed:select id FROM `sc` where city='Port Royal' && SIC_code='5461'DB:business_master_new
loadtime:0.937166929245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prosperity' limit 1
loadtime:0.93721008300781 / seconds
Query Executed:select id FROM `sc` where city='Prosperity' && SIC_code='5461'DB:business_master_new
loadtime:0.93771195411682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinby' limit 1
loadtime:0.9377429485321 / seconds
Query Executed:select id FROM `sc` where city='Quinby' && SIC_code='5461'DB:business_master_new
loadtime:0.9380259513855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rains' limit 1
loadtime:0.93807411193848 / seconds
Query Executed:select id FROM `sc` where city='Rains' && SIC_code='5461'DB:business_master_new
loadtime:0.94183301925659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ravenel' limit 1
loadtime:0.94186806678772 / seconds
Query Executed:select id FROM `sc` where city='Ravenel' && SIC_code='5461'DB:business_master_new
loadtime:0.94235491752625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reevesville' limit 1
loadtime:0.9423930644989 / seconds
Query Executed:select id FROM `sc` where city='Reevesville' && SIC_code='5461'DB:business_master_new
loadtime:0.94281101226807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reidville' limit 1
loadtime:0.94284510612488 / seconds
Query Executed:select id FROM `sc` where city='Reidville' && SIC_code='5461'DB:business_master_new
loadtime:0.94903206825256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rembert' limit 1
loadtime:0.94908690452576 / seconds
Query Executed:select id FROM `sc` where city='Rembert' && SIC_code='5461'DB:business_master_new
loadtime:0.94958710670471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richburg' limit 1
loadtime:0.94963908195496 / seconds
Query Executed:select id FROM `sc` where city='Richburg' && SIC_code='5461'DB:business_master_new
loadtime:0.9501268863678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland' limit 1
loadtime:0.95017695426941 / seconds
Query Executed:select id FROM `sc` where city='Richland' && SIC_code='5461'DB:business_master_new
loadtime:0.9518039226532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridge Spring' limit 1
loadtime:0.95183992385864 / seconds
Query Executed:select id FROM `sc` where city='Ridge Spring' && SIC_code='5461'DB:business_master_new
loadtime:0.95235991477966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeland' limit 1
loadtime:0.95241093635559 / seconds
Query Executed:select id FROM `sc` where city='Ridgeland' && SIC_code='5461'DB:business_master_new
loadtime:0.95307207107544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeville' limit 1
loadtime:0.95313096046448 / seconds
Query Executed:select id FROM `sc` where city='Ridgeville' && SIC_code='5461'DB:business_master_new
loadtime:0.95365595817566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:0.95370197296143 / seconds
Query Executed:select id FROM `sc` where city='Ridgeway' && SIC_code='5461'DB:business_master_new
loadtime:0.95420789718628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rimini' limit 1
loadtime:0.95424890518188 / seconds
Query Executed:select id FROM `sc` where city='Rimini' && SIC_code='5461'DB:business_master_new
loadtime:0.95511794090271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rion' limit 1
loadtime:0.95515990257263 / seconds
Query Executed:select id FROM `sc` where city='Rion' && SIC_code='5461'DB:business_master_new
loadtime:0.9554181098938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ritter' limit 1
loadtime:0.95546007156372 / seconds
Query Executed:select id FROM `sc` where city='Ritter' && SIC_code='5461'DB:business_master_new
loadtime:0.95613598823547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Hill' limit 1
loadtime:0.95617198944092 / seconds
Query Executed:select id FROM `sc` where city='Rock Hill' && SIC_code='5461'DB:business_master_new
loadtime:0.95863604545593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roebuck' limit 1
loadtime:0.95869898796082 / seconds
Query Executed:select id FROM `sc` where city='Roebuck' && SIC_code='5461'DB:business_master_new
loadtime:0.95927095413208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Round O' limit 1
loadtime:0.95931196212769 / seconds
Query Executed:select id FROM `sc` where city='Round O' && SIC_code='5461'DB:business_master_new
loadtime:0.95979309082031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowesville' limit 1
loadtime:0.95983600616455 / seconds
Query Executed:select id FROM `sc` where city='Rowesville' && SIC_code='5461'DB:business_master_new
loadtime:0.96742010116577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruby' limit 1
loadtime:0.9674699306488 / seconds
Query Executed:select id FROM `sc` where city='Ruby' && SIC_code='5461'DB:business_master_new
loadtime:0.96793293952942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruffin' limit 1
loadtime:0.96796989440918 / seconds
Query Executed:select id FROM `sc` where city='Ruffin' && SIC_code='5461'DB:business_master_new
loadtime:0.96845412254333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Russellville' limit 1
loadtime:0.9685070514679 / seconds
Query Executed:select id FROM `sc` where city='Russellville' && SIC_code='5461'DB:business_master_new
loadtime:0.97201895713806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint George' limit 1
loadtime:0.97208189964294 / seconds
Query Executed:select id FROM `sc` where city='Saint George' && SIC_code='5461'DB:business_master_new
loadtime:0.97269010543823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Helena Island' limit 1
loadtime:0.97274899482727 / seconds
Query Executed:select id FROM `sc` where city='Saint Helena Island' && SIC_code='5461'DB:business_master_new
loadtime:0.97335696220398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Matthews' limit 1
loadtime:0.97339797019958 / seconds
Query Executed:select id FROM `sc` where city='Saint Matthews' && SIC_code='5461'DB:business_master_new
loadtime:0.97396206855774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Stephen' limit 1
loadtime:0.97401189804077 / seconds
Query Executed:select id FROM `sc` where city='Saint Stephen' && SIC_code='5461'DB:business_master_new
loadtime:0.97454309463501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.97459006309509 / seconds
Query Executed:select id FROM `sc` where city='Salem' && SIC_code='5461'DB:business_master_new
loadtime:0.97506189346313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salley' limit 1
loadtime:0.97510004043579 / seconds
Query Executed:select id FROM `sc` where city='Salley' && SIC_code='5461'DB:business_master_new
loadtime:0.97553992271423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salters' limit 1
loadtime:0.97559094429016 / seconds
Query Executed:select id FROM `sc` where city='Salters' && SIC_code='5461'DB:business_master_new
loadtime:0.97606801986694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saluda' limit 1
loadtime:0.97610712051392 / seconds
Query Executed:select id FROM `sc` where city='Saluda' && SIC_code='5461'DB:business_master_new
loadtime:0.97670197486877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Springs' limit 1
loadtime:0.97675704956055 / seconds
Query Executed:select id FROM `sc` where city='Sandy Springs' && SIC_code='5461'DB:business_master_new
loadtime:0.98669004440308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santee' limit 1
loadtime:0.98673295974731 / seconds
Query Executed:select id FROM `sc` where city='Santee' && SIC_code='5461'DB:business_master_new
loadtime:0.98730993270874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sardinia' limit 1
loadtime:0.98735308647156 / seconds
Query Executed:select id FROM `sc` where city='Sardinia' && SIC_code='5461'DB:business_master_new
loadtime:0.98843789100647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotia' limit 1
loadtime:0.98849201202393 / seconds
Query Executed:select id FROM `sc` where city='Scotia' && SIC_code='5461'DB:business_master_new
loadtime:0.98998498916626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scranton' limit 1
loadtime:0.99003100395203 / seconds
Query Executed:select id FROM `sc` where city='Scranton' && SIC_code='5461'DB:business_master_new
loadtime:0.99051809310913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seabrook' limit 1
loadtime:0.99056792259216 / seconds
Query Executed:select id FROM `sc` where city='Seabrook' && SIC_code='5461'DB:business_master_new
loadtime:0.99102091789246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sellers' limit 1
loadtime:0.99107789993286 / seconds
Query Executed:select id FROM `sc` where city='Sellers' && SIC_code='5461'DB:business_master_new
loadtime:0.99837899208069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:0.9984290599823 / seconds
Query Executed:select id FROM `sc` where city='Seneca' && SIC_code='5461'DB:business_master_new
loadtime:1.0008931159973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:1.0009520053864 / seconds
Query Executed:select id FROM `sc` where city='Sharon' && SIC_code='5461'DB:business_master_new
loadtime:1.0014328956604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaw A F B' limit 1
loadtime:1.0014700889587 / seconds
Query Executed:select id FROM `sc` where city='Shaw A F B' && SIC_code='5461'DB:business_master_new
loadtime:1.0017108917236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaw Afb' limit 1
loadtime:1.0017609596252 / seconds
Query Executed:select id FROM `sc` where city='Shaw Afb' && SIC_code='5461'DB:business_master_new
loadtime:1.0022230148315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon' limit 1
loadtime:1.0022580623627 / seconds
Query Executed:select id FROM `sc` where city='Sheldon' && SIC_code='5461'DB:business_master_new
loadtime:1.0086960792542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shulerville' limit 1
loadtime:1.0087459087372 / seconds
Query Executed:select id FROM `sc` where city='Shulerville' && SIC_code='5461'DB:business_master_new
loadtime:1.0090799331665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silverstreet' limit 1
loadtime:1.0091190338135 / seconds
Query Executed:select id FROM `sc` where city='Silverstreet' && SIC_code='5461'DB:business_master_new
loadtime:1.0146179199219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Simpsonville' limit 1
loadtime:1.0146689414978 / seconds
Query Executed:select id FROM `sc` where city='Simpsonville' && SIC_code='5461'DB:business_master_new
loadtime:1.0171790122986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Six Mile' limit 1
loadtime:1.0172290802002 / seconds
Query Executed:select id FROM `sc` where city='Six Mile' && SIC_code='5461'DB:business_master_new
loadtime:1.017735004425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Slater' limit 1
loadtime:1.0177841186523 / seconds
Query Executed:select id FROM `sc` where city='Slater' && SIC_code='5461'DB:business_master_new
loadtime:1.0208868980408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smoaks' limit 1
loadtime:1.0209379196167 / seconds
Query Executed:select id FROM `sc` where city='Smoaks' && SIC_code='5461'DB:business_master_new
loadtime:1.021418094635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smyrna' limit 1
loadtime:1.0214650630951 / seconds
Query Executed:select id FROM `sc` where city='Smyrna' && SIC_code='5461'DB:business_master_new
loadtime:1.0275890827179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Society Hill' limit 1
loadtime:1.0276329517365 / seconds
Query Executed:select id FROM `sc` where city='Society Hill' && SIC_code='5461'DB:business_master_new
loadtime:1.028126001358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spartanburg' limit 1
loadtime:1.0281660556793 / seconds
Query Executed:select id FROM `sc` where city='Spartanburg' && SIC_code='5461'DB:business_master_new
loadtime:1.0306301116943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:1.0306890010834 / seconds
Query Executed:select id FROM `sc` where city='Springfield' && SIC_code='5461'DB:business_master_new
loadtime:1.0311601161957 / seconds
Query loaded from cache:select * from geodata_geocity where city='St George' limit 1
loadtime:1.0312008857727 / seconds
Query Executed:select id FROM `sc` where city='St George' && SIC_code='5461'DB:business_master_new
loadtime:1.0320649147034 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Helena Island' limit 1
loadtime:1.032114982605 / seconds
Query Executed:select id FROM `sc` where city='St Helena Island' && SIC_code='5461'DB:business_master_new
loadtime:1.0349669456482 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Matthews' limit 1
loadtime:1.0350079536438 / seconds
Query Executed:select id FROM `sc` where city='St Matthews' && SIC_code='5461'DB:business_master_new
loadtime:1.0354909896851 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Stephen' limit 1
loadtime:1.0355401039124 / seconds
Query Executed:select id FROM `sc` where city='St Stephen' && SIC_code='5461'DB:business_master_new
loadtime:1.0357949733734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Starr' limit 1
loadtime:1.0358281135559 / seconds
Query Executed:select id FROM `sc` where city='Starr' && SIC_code='5461'DB:business_master_new
loadtime:1.0363409519196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Startex' limit 1
loadtime:1.0364010334015 / seconds
Query Executed:select id FROM `sc` where city='Startex' && SIC_code='5461'DB:business_master_new
loadtime:1.0385789871216 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Park' limit 1
loadtime:1.0386319160461 / seconds
Query Executed:select id FROM `sc` where city='State Park' && SIC_code='5461'DB:business_master_new
loadtime:1.0401110649109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sullivans Island' limit 1
loadtime:1.0401649475098 / seconds
Query Executed:select id FROM `sc` where city='Sullivans Island' && SIC_code='5461'DB:business_master_new
loadtime:1.040657043457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summerton' limit 1
loadtime:1.0407040119171 / seconds
Query Executed:select id FROM `sc` where city='Summerton' && SIC_code='5461'DB:business_master_new
loadtime:1.0412600040436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summerville' limit 1
loadtime:1.0413019657135 / seconds
Query Executed:select id FROM `sc` where city='Summerville' && SIC_code='5461'DB:business_master_new
loadtime:1.0437569618225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumter' limit 1
loadtime:1.0438129901886 / seconds
Query Executed:select id FROM `sc` where city='Sumter' && SIC_code='5461'DB:business_master_new
loadtime:1.0463020801544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunset' limit 1
loadtime:1.0463650226593 / seconds
Query Executed:select id FROM `sc` where city='Sunset' && SIC_code='5461'DB:business_master_new
loadtime:1.0468239784241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surfside Beach' limit 1
loadtime:1.0468690395355 / seconds
Query Executed:select id FROM `sc` where city='Surfside Beach' && SIC_code='5461'DB:business_master_new
loadtime:1.0473499298096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swansea' limit 1
loadtime:1.0474030971527 / seconds
Query Executed:select id FROM `sc` where city='Swansea' && SIC_code='5461'DB:business_master_new
loadtime:1.0479009151459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sycamore' limit 1
loadtime:1.0479490756989 / seconds
Query Executed:select id FROM `sc` where city='Sycamore' && SIC_code='5461'DB:business_master_new
loadtime:1.0499510765076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tamassee' limit 1
loadtime:1.0500030517578 / seconds
Query Executed:select id FROM `sc` where city='Tamassee' && SIC_code='5461'DB:business_master_new
loadtime:1.0580201148987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tatum' limit 1
loadtime:1.0581579208374 / seconds
Query Executed:select id FROM `sc` where city='Tatum' && SIC_code='5461'DB:business_master_new
loadtime:1.0627119541168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylors' limit 1
loadtime:1.06285405159 / seconds
Query Executed:select id FROM `sc` where city='Taylors' && SIC_code='5461'DB:business_master_new
loadtime:1.063863992691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tigerville' limit 1
loadtime:1.0640189647675 / seconds
Query Executed:select id FROM `sc` where city='Tigerville' && SIC_code='5461'DB:business_master_new
loadtime:1.0678000450134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tillman' limit 1
loadtime:1.0678989887238 / seconds
Query Executed:select id FROM `sc` where city='Tillman' && SIC_code='5461'DB:business_master_new
loadtime:1.0730090141296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timmonsville' limit 1
loadtime:1.0730819702148 / seconds
Query Executed:select id FROM `sc` where city='Timmonsville' && SIC_code='5461'DB:business_master_new
loadtime:1.0736610889435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townville' limit 1
loadtime:1.0736970901489 / seconds
Query Executed:select id FROM `sc` where city='Townville' && SIC_code='5461'DB:business_master_new
loadtime:1.0742330551147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Travelers Rest' limit 1
loadtime:1.0742750167847 / seconds
Query Executed:select id FROM `sc` where city='Travelers Rest' && SIC_code='5461'DB:business_master_new
loadtime:1.0749540328979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trenton' limit 1
loadtime:1.0750079154968 / seconds
Query Executed:select id FROM `sc` where city='Trenton' && SIC_code='5461'DB:business_master_new
loadtime:1.0755040645599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trio' limit 1
loadtime:1.0755450725555 / seconds
Query Executed:select id FROM `sc` where city='Trio' && SIC_code='5461'DB:business_master_new
loadtime:1.075786113739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:1.0758280754089 / seconds
Query Executed:select id FROM `sc` where city='Troy' && SIC_code='5461'DB:business_master_new
loadtime:1.0861799716949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turbeville' limit 1
loadtime:1.0862300395966 / seconds
Query Executed:select id FROM `sc` where city='Turbeville' && SIC_code='5461'DB:business_master_new
loadtime:1.0868899822235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ulmer' limit 1
loadtime:1.0869309902191 / seconds
Query Executed:select id FROM `sc` where city='Ulmer' && SIC_code='5461'DB:business_master_new
loadtime:1.0924210548401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Una' limit 1
loadtime:1.092472076416 / seconds
Query Executed:select id FROM `sc` where city='Una' && SIC_code='5461'DB:business_master_new
loadtime:1.0956969261169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:1.095743894577 / seconds
Query Executed:select id FROM `sc` where city='Union' && SIC_code='5461'DB:business_master_new
loadtime:1.0965781211853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Wyck' limit 1
loadtime:1.0966351032257 / seconds
Query Executed:select id FROM `sc` where city='Van Wyck' && SIC_code='5461'DB:business_master_new
loadtime:1.1009249687195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vance' limit 1
loadtime:1.1009759902954 / seconds
Query Executed:select id FROM `sc` where city='Vance' && SIC_code='5461'DB:business_master_new
loadtime:1.1014521121979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Varnville' limit 1
loadtime:1.1014890670776 / seconds
Query Executed:select id FROM `sc` where city='Varnville' && SIC_code='5461'DB:business_master_new
loadtime:1.101989030838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vaucluse' limit 1
loadtime:1.1020400524139 / seconds
Query Executed:select id FROM `sc` where city='Vaucluse' && SIC_code='5461'DB:business_master_new
loadtime:1.1027729511261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wadmalaw Island' limit 1
loadtime:1.1028089523315 / seconds
Query Executed:select id FROM `sc` where city='Wadmalaw Island' && SIC_code='5461'DB:business_master_new
loadtime:1.1032381057739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wagener' limit 1
loadtime:1.1032800674438 / seconds
Query Executed:select id FROM `sc` where city='Wagener' && SIC_code='5461'DB:business_master_new
loadtime:1.1037731170654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walhalla' limit 1
loadtime:1.1038219928741 / seconds
Query Executed:select id FROM `sc` where city='Walhalla' && SIC_code='5461'DB:business_master_new
loadtime:1.1044070720673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallace' limit 1
loadtime:1.1044631004333 / seconds
Query Executed:select id FROM `sc` where city='Wallace' && SIC_code='5461'DB:business_master_new
loadtime:1.104877948761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walterboro' limit 1
loadtime:1.1049160957336 / seconds
Query Executed:select id FROM `sc` where city='Walterboro' && SIC_code='5461'DB:business_master_new
loadtime:1.1073970794678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wando' limit 1
loadtime:1.1074550151825 / seconds
Query Executed:select id FROM `sc` where city='Wando' && SIC_code='5461'DB:business_master_new
loadtime:1.1085579395294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ward' limit 1
loadtime:1.1086070537567 / seconds
Query Executed:select id FROM `sc` where city='Ward' && SIC_code='5461'DB:business_master_new
loadtime:1.1146008968353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ware Shoals' limit 1
loadtime:1.1146500110626 / seconds
Query Executed:select id FROM `sc` where city='Ware Shoals' && SIC_code='5461'DB:business_master_new
loadtime:1.1151149272919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrenville' limit 1
loadtime:1.1151509284973 / seconds
Query Executed:select id FROM `sc` where city='Warrenville' && SIC_code='5461'DB:business_master_new
loadtime:1.1156620979309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterloo' limit 1
loadtime:1.1157119274139 / seconds
Query Executed:select id FROM `sc` where city='Waterloo' && SIC_code='5461'DB:business_master_new
loadtime:1.1161720752716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wedgefield' limit 1
loadtime:1.1162118911743 / seconds
Query Executed:select id FROM `sc` where city='Wedgefield' && SIC_code='5461'DB:business_master_new
loadtime:1.1166489124298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellford' limit 1
loadtime:1.1166849136353 / seconds
Query Executed:select id FROM `sc` where city='Wellford' && SIC_code='5461'DB:business_master_new
loadtime:1.1171679496765 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Columbia' limit 1
loadtime:1.1172111034393 / seconds
Query Executed:select id FROM `sc` where city='West Columbia' && SIC_code='5461'DB:business_master_new
loadtime:1.1196539402008 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Union' limit 1
loadtime:1.1197149753571 / seconds
Query Executed:select id FROM `sc` where city='West Union' && SIC_code='5461'DB:business_master_new
loadtime:1.1202130317688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:1.1202569007874 / seconds
Query Executed:select id FROM `sc` where city='Westminster' && SIC_code='5461'DB:business_master_new
loadtime:1.1208209991455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westville' limit 1
loadtime:1.120875120163 / seconds
Query Executed:select id FROM `sc` where city='Westville' && SIC_code='5461'DB:business_master_new
loadtime:1.1235320568085 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Rock' limit 1
loadtime:1.1235730648041 / seconds
Query Executed:select id FROM `sc` where city='White Rock' && SIC_code='5461'DB:business_master_new
loadtime:1.1307709217072 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Stone' limit 1
loadtime:1.1308228969574 / seconds
Query Executed:select id FROM `sc` where city='White Stone' && SIC_code='5461'DB:business_master_new
loadtime:1.1324338912964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitmire' limit 1
loadtime:1.132483959198 / seconds
Query Executed:select id FROM `sc` where city='Whitmire' && SIC_code='5461'DB:business_master_new
loadtime:1.1329729557037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williams' limit 1
loadtime:1.1330199241638 / seconds
Query Executed:select id FROM `sc` where city='Williams' && SIC_code='5461'DB:business_master_new
loadtime:1.1364009380341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamston' limit 1
loadtime:1.1364510059357 / seconds
Query Executed:select id FROM `sc` where city='Williamston' && SIC_code='5461'DB:business_master_new
loadtime:1.1370050907135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williston' limit 1
loadtime:1.1370480060577 / seconds
Query Executed:select id FROM `sc` where city='Williston' && SIC_code='5461'DB:business_master_new
loadtime:1.1376140117645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:1.1376729011536 / seconds
Query Executed:select id FROM `sc` where city='Windsor' && SIC_code='5461'DB:business_master_new
loadtime:1.1380860805511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winnsboro' limit 1
loadtime:1.1381139755249 / seconds
Query Executed:select id FROM `sc` where city='Winnsboro' && SIC_code='5461'DB:business_master_new
loadtime:1.1387069225311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodruff' limit 1
loadtime:1.1387550830841 / seconds
Query Executed:select id FROM `sc` where city='Woodruff' && SIC_code='5461'DB:business_master_new
loadtime:1.1392838954926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yemassee' limit 1
loadtime:1.1393239498138 / seconds
Query Executed:select id FROM `sc` where city='Yemassee' && SIC_code='5461'DB:business_master_new
loadtime:1.1398289203644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yonges Island' limit 1
loadtime:1.1398739814758 / seconds
Query Executed:select id FROM `sc` where city='Yonges Island' && SIC_code='5461'DB:business_master_new
loadtime:1.1401460170746 / seconds
Query loaded from cache:select * from geodata_geocity where city='York' limit 1
loadtime:1.1401889324188 / seconds
Query Executed:select id FROM `sc` where city='York' && SIC_code='5461'DB:business_master_new
loadtime:1.1426119804382 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.1426980495453 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.142884016037 / seconds
Operation template executed (chunk cache operation)
loadtime:1.142963886261 / seconds
template override:Default
loadtime:1.1429829597473 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:1.1439011096954 / seconds
Template Constructed, Array Rows:49
loadtime:1.1441559791565 / seconds
TOTAL EXECUTION TIME: 1.14395
loadtime:1.1442360877991 / 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] => retail-bakeries [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:1.1442410945892
TOTAL KEY ARRAYS: 69