Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:9.0837478637695E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0010669231414795 / seconds
host not found setting manual db connection
loadtime:0.0022118091583252 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0026788711547852 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0028820037841797 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0029439926147461 / seconds
zipcode:
loadtime:0.0029628276824951 / seconds
Query Executed:select * from search_referrer where page_hash='bbe2aabd1ee24765f45af880ad13d59d' limit 10 DB:ezrox_toadli
loadtime:0.0031869411468506 / seconds
Operation header executed (non global)
loadtime:0.0032060146331787 / seconds
Operation leaderboard executed (non global)
loadtime:0.0032520294189453 / seconds
Operation square executed (non global)
loadtime:0.0032658576965332 / seconds
Operation square_bottom executed (non global)
loadtime:0.0032789707183838 / seconds
Operation smallsquare executed (non global)
loadtime:0.0032908916473389 / seconds
Operation headeradright executed (non global)
loadtime:0.0033028125762939 / seconds
Operation google_analytics executed (non global)
loadtime:0.0033128261566162 / seconds
Operation topstories executed (non global)
loadtime:0.0033249855041504 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0033369064331055 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0033478736877441 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0040287971496582 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0046629905700684 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0048038959503174 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0049858093261719 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0050938129425049 / seconds
Template key: archive_menu pushed
loadtime:0.0051479339599609 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0051898956298828 / seconds
Template key: get_gravatar pushed
loadtime:0.0052030086517334 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0052449703216553 / seconds
*10)-10)+1 | start:0
loadtime:0.0053110122680664 / seconds
DB connected to localhost business_master_new
loadtime:0.0057129859924316 / seconds
Query Executed:select * from categories where cat_URLid='cable-and-other-pay-television-services'DB:business_master_new
loadtime:0.0062549114227295 / seconds
Query stored in cache : _QUERY_www.toadli.com80aad97ff291e204cb35a2d48307d612
loadtime:0.0063018798828125 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='south-carolina'
loadtime:0.0063459873199463 / seconds
Query Executed:select * from `sc_catmap` where sic='4841' order by city ascDB:business_master_new
loadtime:0.11838889122009 / seconds
Query stored in cache : _QUERY_www.toadli.com27fffac7cd4dc35700b5742598a7814d
loadtime:0.11940979957581 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='south-carolina'
loadtime:0.1194429397583 / seconds
Query Executed:select sum(totalcount) as totalsum from `sc_catmap` where sic='4841'DB:business_master_new
loadtime:0.12180089950562 / seconds
Query stored in cache : _QUERY_www.toadli.com44e05fc4e0c75bdbbc39e20c1e2b59ee
loadtime:0.12182593345642 / seconds
420 / 11
loadtime:0.12185883522034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abbeville' limit 1
loadtime:0.12191081047058 / seconds
Query Executed:select id FROM `sc` where city='Abbeville' && SIC_code='4841'DB:business_master_new
loadtime:0.12460899353027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adams Run' limit 1
loadtime:0.12467098236084 / seconds
Query Executed:select id FROM `sc` where city='Adams Run' && SIC_code='4841'DB:business_master_new
loadtime:0.12521982192993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aiken' limit 1
loadtime:0.12525296211243 / seconds
Query Executed:select id FROM `sc` where city='Aiken' && SIC_code='4841'DB:business_master_new
loadtime:0.17169094085693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alcolu' limit 1
loadtime:0.17175388336182 / seconds
Query Executed:select id FROM `sc` where city='Alcolu' && SIC_code='4841'DB:business_master_new
loadtime:0.17223882675171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allendale' limit 1
loadtime:0.17226696014404 / seconds
Query Executed:select id FROM `sc` where city='Allendale' && SIC_code='4841'DB:business_master_new
loadtime:0.17271780967712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alvin' limit 1
loadtime:0.1727659702301 / seconds
Query Executed:select id FROM `sc` where city='Alvin' && SIC_code='4841'DB:business_master_new
loadtime:0.17302083969116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anderson' limit 1
loadtime:0.17305493354797 / seconds
Query Executed:select id FROM `sc` where city='Anderson' && SIC_code='4841'DB:business_master_new
loadtime:0.1745388507843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andrews' limit 1
loadtime:0.17458295822144 / seconds
Query Executed:select id FROM `sc` where city='Andrews' && SIC_code='4841'DB:business_master_new
loadtime:0.17506289482117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcadia' limit 1
loadtime:0.17512798309326 / seconds
Query Executed:select id FROM `sc` where city='Arcadia' && SIC_code='4841'DB:business_master_new
loadtime:0.17549586296082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic Beach' limit 1
loadtime:0.17555689811707 / seconds
Query Executed:select id FROM `sc` where city='Atlantic Beach' && SIC_code='4841'DB:business_master_new
loadtime:0.17582893371582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Awendaw' limit 1
loadtime:0.1758668422699 / seconds
Query Executed:select id FROM `sc` where city='Awendaw' && SIC_code='4841'DB:business_master_new
loadtime:0.17629384994507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aynor' limit 1
loadtime:0.17634582519531 / seconds
Query Executed:select id FROM `sc` where city='Aynor' && SIC_code='4841'DB:business_master_new
loadtime:0.17677283287048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ballentine' limit 1
loadtime:0.1768159866333 / seconds
Query Executed:select id FROM `sc` where city='Ballentine' && SIC_code='4841'DB:business_master_new
loadtime:0.17738699913025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bamberg' limit 1
loadtime:0.17743492126465 / seconds
Query Executed:select id FROM `sc` where city='Bamberg' && SIC_code='4841'DB:business_master_new
loadtime:0.17812991142273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnwell' limit 1
loadtime:0.1781599521637 / seconds
Query Executed:select id FROM `sc` where city='Barnwell' && SIC_code='4841'DB:business_master_new
loadtime:0.17876696586609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Batesburg' limit 1
loadtime:0.17881679534912 / seconds
Query Executed:select id FROM `sc` where city='Batesburg' && SIC_code='4841'DB:business_master_new
loadtime:0.17932391166687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.17936396598816 / seconds
Query Executed:select id FROM `sc` where city='Bath' && SIC_code='4841'DB:business_master_new
loadtime:0.1799259185791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaufort' limit 1
loadtime:0.17996382713318 / seconds
Query Executed:select id FROM `sc` where city='Beaufort' && SIC_code='4841'DB:business_master_new
loadtime:0.18140482902527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beech Island' limit 1
loadtime:0.18146300315857 / seconds
Query Executed:select id FROM `sc` where city='Beech Island' && SIC_code='4841'DB:business_master_new
loadtime:0.18194389343262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belton' limit 1
loadtime:0.18197584152222 / seconds
Query Executed:select id FROM `sc` where city='Belton' && SIC_code='4841'DB:business_master_new
loadtime:0.1825737953186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvedere' limit 1
loadtime:0.18262195587158 / seconds
Query Executed:select id FROM `sc` where city='Belvedere' && SIC_code='4841'DB:business_master_new
loadtime:0.18287682533264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennettsville' limit 1
loadtime:0.18290281295776 / seconds
Query Executed:select id FROM `sc` where city='Bennettsville' && SIC_code='4841'DB:business_master_new
loadtime:0.18428492546082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethera' limit 1
loadtime:0.1843409538269 / seconds
Query Executed:select id FROM `sc` where city='Bethera' && SIC_code='4841'DB:business_master_new
loadtime:0.1846559047699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethune' limit 1
loadtime:0.18469285964966 / seconds
Query Executed:select id FROM `sc` where city='Bethune' && SIC_code='4841'DB:business_master_new
loadtime:0.18511295318604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bishopville' limit 1
loadtime:0.18515586853027 / seconds
Query Executed:select id FROM `sc` where city='Bishopville' && SIC_code='4841'DB:business_master_new
loadtime:0.18571996688843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blacksburg' limit 1
loadtime:0.18577098846436 / seconds
Query Executed:select id FROM `sc` where city='Blacksburg' && SIC_code='4841'DB:business_master_new
loadtime:0.18625497817993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackstock' limit 1
loadtime:0.18629693984985 / seconds
Query Executed:select id FROM `sc` where city='Blackstock' && SIC_code='4841'DB:business_master_new
loadtime:0.18681502342224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackville' limit 1
loadtime:0.18685984611511 / seconds
Query Executed:select id FROM `sc` where city='Blackville' && SIC_code='4841'DB:business_master_new
loadtime:0.18727087974548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blair' limit 1
loadtime:0.18729782104492 / seconds
Query Executed:select id FROM `sc` where city='Blair' && SIC_code='4841'DB:business_master_new
loadtime:0.18776988983154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blenheim' limit 1
loadtime:0.18781995773315 / seconds
Query Executed:select id FROM `sc` where city='Blenheim' && SIC_code='4841'DB:business_master_new
loadtime:0.18830180168152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluffton' limit 1
loadtime:0.18835401535034 / seconds
Query Executed:select id FROM `sc` where city='Bluffton' && SIC_code='4841'DB:business_master_new
loadtime:0.18972301483154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blythewood' limit 1
loadtime:0.1897668838501 / seconds
Query Executed:select id FROM `sc` where city='Blythewood' && SIC_code='4841'DB:business_master_new
loadtime:0.19027185440063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boiling Springs' limit 1
loadtime:0.19031500816345 / seconds
Query Executed:select id FROM `sc` where city='Boiling Springs' && SIC_code='4841'DB:business_master_new
loadtime:0.19089388847351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonneau' limit 1
loadtime:0.1909339427948 / seconds
Query Executed:select id FROM `sc` where city='Bonneau' && SIC_code='4841'DB:business_master_new
loadtime:0.19138884544373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowling Green' limit 1
loadtime:0.19143891334534 / seconds
Query Executed:select id FROM `sc` where city='Bowling Green' && SIC_code='4841'DB:business_master_new
loadtime:0.19181680679321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowman' limit 1
loadtime:0.19186186790466 / seconds
Query Executed:select id FROM `sc` where city='Bowman' && SIC_code='4841'DB:business_master_new
loadtime:0.19225382804871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradley' limit 1
loadtime:0.19228386878967 / seconds
Query Executed:select id FROM `sc` where city='Bradley' && SIC_code='4841'DB:business_master_new
loadtime:0.19283080101013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branchville' limit 1
loadtime:0.19288301467896 / seconds
Query Executed:select id FROM `sc` where city='Branchville' && SIC_code='4841'DB:business_master_new
loadtime:0.19326186180115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brunson' limit 1
loadtime:0.19330096244812 / seconds
Query Executed:select id FROM `sc` where city='Brunson' && SIC_code='4841'DB:business_master_new
loadtime:0.1938328742981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bucksport' limit 1
loadtime:0.19386792182922 / seconds
Query Executed:select id FROM `sc` where city='Bucksport' && SIC_code='4841'DB:business_master_new
loadtime:0.19411396980286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo' limit 1
loadtime:0.19415783882141 / seconds
Query Executed:select id FROM `sc` where city='Buffalo' && SIC_code='4841'DB:business_master_new
loadtime:0.19454383850098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cades' limit 1
loadtime:0.19459080696106 / seconds
Query Executed:select id FROM `sc` where city='Cades' && SIC_code='4841'DB:business_master_new
loadtime:0.19497394561768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calhoun Falls' limit 1
loadtime:0.1949999332428 / seconds
Query Executed:select id FROM `sc` where city='Calhoun Falls' && SIC_code='4841'DB:business_master_new
loadtime:0.195396900177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camden' limit 1
loadtime:0.19544291496277 / seconds
Query Executed:select id FROM `sc` where city='Camden' && SIC_code='4841'DB:business_master_new
loadtime:0.19679498672485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cameron' limit 1
loadtime:0.19685387611389 / seconds
Query Executed:select id FROM `sc` where city='Cameron' && SIC_code='4841'DB:business_master_new
loadtime:0.19724988937378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Campobello' limit 1
loadtime:0.19728589057922 / seconds
Query Executed:select id FROM `sc` where city='Campobello' && SIC_code='4841'DB:business_master_new
loadtime:0.19772887229919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canadys' limit 1
loadtime:0.19776487350464 / seconds
Query Executed:select id FROM `sc` where city='Canadys' && SIC_code='4841'DB:business_master_new
loadtime:0.19811081886292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlisle' limit 1
loadtime:0.19815182685852 / seconds
Query Executed:select id FROM `sc` where city='Carlisle' && SIC_code='4841'DB:business_master_new
loadtime:0.19871997833252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cassatt' limit 1
loadtime:0.19876885414124 / seconds
Query Executed:select id FROM `sc` where city='Cassatt' && SIC_code='4841'DB:business_master_new
loadtime:0.19913291931152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catawba' limit 1
loadtime:0.19915986061096 / seconds
Query Executed:select id FROM `sc` where city='Catawba' && SIC_code='4841'DB:business_master_new
loadtime:0.19956302642822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cayce' limit 1
loadtime:0.19961380958557 / seconds
Query Executed:select id FROM `sc` where city='Cayce' && SIC_code='4841'DB:business_master_new
loadtime:0.2001519203186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centenary' limit 1
loadtime:0.20019292831421 / seconds
Query Executed:select id FROM `sc` where city='Centenary' && SIC_code='4841'DB:business_master_new
loadtime:0.20049691200256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central' limit 1
loadtime:0.20054984092712 / seconds
Query Executed:select id FROM `sc` where city='Central' && SIC_code='4841'DB:business_master_new
loadtime:0.20101690292358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chapin' limit 1
loadtime:0.20106101036072 / seconds
Query Executed:select id FROM `sc` where city='Chapin' && SIC_code='4841'DB:business_master_new
loadtime:0.20163702964783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chappells' limit 1
loadtime:0.20167183876038 / seconds
Query Executed:select id FROM `sc` where city='Chappells' && SIC_code='4841'DB:business_master_new
loadtime:0.20207381248474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charleston' limit 1
loadtime:0.20212697982788 / seconds
Query Executed:select id FROM `sc` where city='Charleston' && SIC_code='4841'DB:business_master_new
loadtime:0.20352387428284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charleston Afb' limit 1
loadtime:0.20356798171997 / seconds
Query Executed:select id FROM `sc` where city='Charleston Afb' && SIC_code='4841'DB:business_master_new
loadtime:0.20414590835571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheraw' limit 1
loadtime:0.20418882369995 / seconds
Query Executed:select id FROM `sc` where city='Cheraw' && SIC_code='4841'DB:business_master_new
loadtime:0.20480298995972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Grove Bch' limit 1
loadtime:0.20484781265259 / seconds
Query Executed:select id FROM `sc` where city='Cherry Grove Bch' && SIC_code='4841'DB:business_master_new
loadtime:0.20509386062622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesnee' limit 1
loadtime:0.20513296127319 / seconds
Query Executed:select id FROM `sc` where city='Chesnee' && SIC_code='4841'DB:business_master_new
loadtime:0.20564889907837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.20569586753845 / seconds
Query Executed:select id FROM `sc` where city='Chester' && SIC_code='4841'DB:business_master_new
loadtime:0.20706796646118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:0.20711994171143 / seconds
Query Executed:select id FROM `sc` where city='Chesterfield' && SIC_code='4841'DB:business_master_new
loadtime:0.20761179924011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarks Hill' limit 1
loadtime:0.20764684677124 / seconds
Query Executed:select id FROM `sc` where city='Clarks Hill' && SIC_code='4841'DB:business_master_new
loadtime:0.20823884010315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clearwater' limit 1
loadtime:0.20827984809875 / seconds
Query Executed:select id FROM `sc` where city='Clearwater' && SIC_code='4841'DB:business_master_new
loadtime:0.20866584777832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clemson' limit 1
loadtime:0.20871090888977 / seconds
Query Executed:select id FROM `sc` where city='Clemson' && SIC_code='4841'DB:business_master_new
loadtime:0.2092719078064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.209312915802 / seconds
Query Executed:select id FROM `sc` where city='Cleveland' && SIC_code='4841'DB:business_master_new
loadtime:0.20992183685303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:0.20995593070984 / seconds
Query Executed:select id FROM `sc` where city='Clifton' && SIC_code='4841'DB:business_master_new
loadtime:0.21027183532715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.2103099822998 / seconds
Query Executed:select id FROM `sc` where city='Clinton' && SIC_code='4841'DB:business_master_new
loadtime:0.21087002754211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clio' limit 1
loadtime:0.21091485023499 / seconds
Query Executed:select id FROM `sc` where city='Clio' && SIC_code='4841'DB:business_master_new
loadtime:0.21129083633423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clover' limit 1
loadtime:0.21133089065552 / seconds
Query Executed:select id FROM `sc` where city='Clover' && SIC_code='4841'DB:business_master_new
loadtime:0.21270394325256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.21275281906128 / seconds
Query Executed:select id FROM `sc` where city='Columbia' && SIC_code='4841'DB:business_master_new
loadtime:0.21414089202881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conestee' limit 1
loadtime:0.2141900062561 / seconds
Query Executed:select id FROM `sc` where city='Conestee' && SIC_code='4841'DB:business_master_new
loadtime:0.21454095840454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Converse' limit 1
loadtime:0.21459102630615 / seconds
Query Executed:select id FROM `sc` where city='Converse' && SIC_code='4841'DB:business_master_new
loadtime:0.21495795249939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.21500301361084 / seconds
Query Executed:select id FROM `sc` where city='Conway' && SIC_code='4841'DB:business_master_new
loadtime:0.21639394760132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coosawatchie' limit 1
loadtime:0.21642994880676 / seconds
Query Executed:select id FROM `sc` where city='Coosawatchie' && SIC_code='4841'DB:business_master_new
loadtime:0.21668195724487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cope' limit 1
loadtime:0.21672081947327 / seconds
Query Executed:select id FROM `sc` where city='Cope' && SIC_code='4841'DB:business_master_new
loadtime:0.217120885849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cordesville' limit 1
loadtime:0.21714687347412 / seconds
Query Executed:select id FROM `sc` where city='Cordesville' && SIC_code='4841'DB:business_master_new
loadtime:0.21762990951538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cordova' limit 1
loadtime:0.21768188476562 / seconds
Query Executed:select id FROM `sc` where city='Cordova' && SIC_code='4841'DB:business_master_new
loadtime:0.21807980537415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottageville' limit 1
loadtime:0.21812891960144 / seconds
Query Executed:select id FROM `sc` where city='Cottageville' && SIC_code='4841'DB:business_master_new
loadtime:0.21855282783508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coward' limit 1
loadtime:0.21859288215637 / seconds
Query Executed:select id FROM `sc` where city='Coward' && SIC_code='4841'DB:business_master_new
loadtime:0.21896982192993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cowpens' limit 1
loadtime:0.21900582313538 / seconds
Query Executed:select id FROM `sc` where city='Cowpens' && SIC_code='4841'DB:business_master_new
loadtime:0.21948981285095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crocketville' limit 1
loadtime:0.21952986717224 / seconds
Query Executed:select id FROM `sc` where city='Crocketville' && SIC_code='4841'DB:business_master_new
loadtime:0.2197790145874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross' limit 1
loadtime:0.21981596946716 / seconds
Query Executed:select id FROM `sc` where city='Cross' && SIC_code='4841'DB:business_master_new
loadtime:0.22020387649536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross Anchor' limit 1
loadtime:0.22024202346802 / seconds
Query Executed:select id FROM `sc` where city='Cross Anchor' && SIC_code='4841'DB:business_master_new
loadtime:0.22054600715637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross Hill' limit 1
loadtime:0.22058200836182 / seconds
Query Executed:select id FROM `sc` where city='Cross Hill' && SIC_code='4841'DB:business_master_new
loadtime:0.22095799446106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dale' limit 1
loadtime:0.22099184989929 / seconds
Query Executed:select id FROM `sc` where city='Dale' && SIC_code='4841'DB:business_master_new
loadtime:0.2212769985199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dalzell' limit 1
loadtime:0.2213020324707 / seconds
Query Executed:select id FROM `sc` where city='Dalzell' && SIC_code='4841'DB:business_master_new
loadtime:0.22171497344971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daniel Island' limit 1
loadtime:0.22176694869995 / seconds
Query Executed:select id FROM `sc` where city='Daniel Island' && SIC_code='4841'DB:business_master_new
loadtime:0.22200489044189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darlington' limit 1
loadtime:0.22203087806702 / seconds
Query Executed:select id FROM `sc` where city='Darlington' && SIC_code='4841'DB:business_master_new
loadtime:0.22338199615479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daufuskie Island' limit 1
loadtime:0.22342085838318 / seconds
Query Executed:select id FROM `sc` where city='Daufuskie Island' && SIC_code='4841'DB:business_master_new
loadtime:0.22381901741028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis Station' limit 1
loadtime:0.22386503219604 / seconds
Query Executed:select id FROM `sc` where city='Davis Station' && SIC_code='4841'DB:business_master_new
loadtime:0.22422385215759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denmark' limit 1
loadtime:0.22424983978271 / seconds
Query Executed:select id FROM `sc` where city='Denmark' && SIC_code='4841'DB:business_master_new
loadtime:0.2246778011322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewees Island' limit 1
loadtime:0.2247269153595 / seconds
Query Executed:select id FROM `sc` where city='Dewees Island' && SIC_code='4841'DB:business_master_new
loadtime:0.22497797012329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dillon' limit 1
loadtime:0.22501397132874 / seconds
Query Executed:select id FROM `sc` where city='Dillon' && SIC_code='4841'DB:business_master_new
loadtime:0.22640681266785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Donalds' limit 1
loadtime:0.22644090652466 / seconds
Query Executed:select id FROM `sc` where city='Donalds' && SIC_code='4841'DB:business_master_new
loadtime:0.22682285308838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:0.22687196731567 / seconds
Query Executed:select id FROM `sc` where city='Dorchester' && SIC_code='4841'DB:business_master_new
loadtime:0.22723603248596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drayton' limit 1
loadtime:0.2272629737854 / seconds
Query Executed:select id FROM `sc` where city='Drayton' && SIC_code='4841'DB:business_master_new
loadtime:0.22763681411743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Due West' limit 1
loadtime:0.22768497467041 / seconds
Query Executed:select id FROM `sc` where city='Due West' && SIC_code='4841'DB:business_master_new
loadtime:0.22808289527893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duncan' limit 1
loadtime:0.22812390327454 / seconds
Query Executed:select id FROM `sc` where city='Duncan' && SIC_code='4841'DB:business_master_new
loadtime:0.22865200042725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Early Branch' limit 1
loadtime:0.22870898246765 / seconds
Query Executed:select id FROM `sc` where city='Early Branch' && SIC_code='4841'DB:business_master_new
loadtime:0.2291419506073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easley' limit 1
loadtime:0.22918200492859 / seconds
Query Executed:select id FROM `sc` where city='Easley' && SIC_code='4841'DB:business_master_new
loadtime:0.23054385185242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastover' limit 1
loadtime:0.23057889938354 / seconds
Query Executed:select id FROM `sc` where city='Eastover' && SIC_code='4841'DB:business_master_new
loadtime:0.23098182678223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgefield' limit 1
loadtime:0.23102283477783 / seconds
Query Executed:select id FROM `sc` where city='Edgefield' && SIC_code='4841'DB:business_master_new
loadtime:0.23152494430542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgemoor' limit 1
loadtime:0.23156595230103 / seconds
Query Executed:select id FROM `sc` where city='Edgemoor' && SIC_code='4841'DB:business_master_new
loadtime:0.23194980621338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edisto Island' limit 1
loadtime:0.23199081420898 / seconds
Query Executed:select id FROM `sc` where city='Edisto Island' && SIC_code='4841'DB:business_master_new
loadtime:0.23247885704041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Effingham' limit 1
loadtime:0.23251390457153 / seconds
Query Executed:select id FROM `sc` where city='Effingham' && SIC_code='4841'DB:business_master_new
loadtime:0.23295998573303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ehrhardt' limit 1
loadtime:0.23300886154175 / seconds
Query Executed:select id FROM `sc` where city='Ehrhardt' && SIC_code='4841'DB:business_master_new
loadtime:0.23343300819397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elgin' limit 1
loadtime:0.23347091674805 / seconds
Query Executed:select id FROM `sc` where city='Elgin' && SIC_code='4841'DB:business_master_new
loadtime:0.23395586013794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elko' limit 1
loadtime:0.23400402069092 / seconds
Query Executed:select id FROM `sc` where city='Elko' && SIC_code='4841'DB:business_master_new
loadtime:0.23442697525024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elliott' limit 1
loadtime:0.23446202278137 / seconds
Query Executed:select id FROM `sc` where city='Elliott' && SIC_code='4841'DB:business_master_new
loadtime:0.23478293418884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elloree' limit 1
loadtime:0.23483180999756 / seconds
Query Executed:select id FROM `sc` where city='Elloree' && SIC_code='4841'DB:business_master_new
loadtime:0.23524594306946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enoree' limit 1
loadtime:0.23529100418091 / seconds
Query Executed:select id FROM `sc` where city='Enoree' && SIC_code='4841'DB:business_master_new
loadtime:0.23567700386047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estill' limit 1
loadtime:0.23571586608887 / seconds
Query Executed:select id FROM `sc` where city='Estill' && SIC_code='4841'DB:business_master_new
loadtime:0.23614096641541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eutawville' limit 1
loadtime:0.23618197441101 / seconds
Query Executed:select id FROM `sc` where city='Eutawville' && SIC_code='4841'DB:business_master_new
loadtime:0.23661494255066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Play' limit 1
loadtime:0.23664879798889 / seconds
Query Executed:select id FROM `sc` where city='Fair Play' && SIC_code='4841'DB:business_master_new
loadtime:0.23704481124878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.23708200454712 / seconds
Query Executed:select id FROM `sc` where city='Fairfax' && SIC_code='4841'DB:business_master_new
loadtime:0.23752880096436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairforest' limit 1
loadtime:0.23757386207581 / seconds
Query Executed:select id FROM `sc` where city='Fairforest' && SIC_code='4841'DB:business_master_new
loadtime:0.23804402351379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fingerville' limit 1
loadtime:0.23807096481323 / seconds
Query Executed:select id FROM `sc` where city='Fingerville' && SIC_code='4841'DB:business_master_new
loadtime:0.23836588859558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.23840594291687 / seconds
Query Executed:select id FROM `sc` where city='Florence' && SIC_code='4841'DB:business_master_new
loadtime:0.23977780342102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Folly Beach' limit 1
loadtime:0.23983693122864 / seconds
Query Executed:select id FROM `sc` where city='Folly Beach' && SIC_code='4841'DB:business_master_new
loadtime:0.24025583267212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fork' limit 1
loadtime:0.2402868270874 / seconds
Query Executed:select id FROM `sc` where city='Fork' && SIC_code='4841'DB:business_master_new
loadtime:0.24071002006531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Lawn' limit 1
loadtime:0.2407557964325 / seconds
Query Executed:select id FROM `sc` where city='Fort Lawn' && SIC_code='4841'DB:business_master_new
loadtime:0.24113893508911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mill' limit 1
loadtime:0.2411777973175 / seconds
Query Executed:select id FROM `sc` where city='Fort Mill' && SIC_code='4841'DB:business_master_new
loadtime:0.24254989624023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Motte' limit 1
loadtime:0.24259901046753 / seconds
Query Executed:select id FROM `sc` where city='Fort Motte' && SIC_code='4841'DB:business_master_new
loadtime:0.24289083480835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain Inn' limit 1
loadtime:0.24293184280396 / seconds
Query Executed:select id FROM `sc` where city='Fountain Inn' && SIC_code='4841'DB:business_master_new
loadtime:0.24349188804626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frogmore' limit 1
loadtime:0.24352693557739 / seconds
Query Executed:select id FROM `sc` where city='Frogmore' && SIC_code='4841'DB:business_master_new
loadtime:0.24377202987671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Furman' limit 1
loadtime:0.24381589889526 / seconds
Query Executed:select id FROM `sc` where city='Furman' && SIC_code='4841'DB:business_master_new
loadtime:0.24419283866882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gable' limit 1
loadtime:0.24423098564148 / seconds
Query Executed:select id FROM `sc` where city='Gable' && SIC_code='4841'DB:business_master_new
loadtime:0.24473285675049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gadsden' limit 1
loadtime:0.24477601051331 / seconds
Query Executed:select id FROM `sc` where city='Gadsden' && SIC_code='4841'DB:business_master_new
loadtime:0.24533486366272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaffney' limit 1
loadtime:0.24536085128784 / seconds
Query Executed:select id FROM `sc` where city='Gaffney' && SIC_code='4841'DB:business_master_new
loadtime:0.24671292304993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galivants Ferry' limit 1
loadtime:0.24676895141602 / seconds
Query Executed:select id FROM `sc` where city='Galivants Ferry' && SIC_code='4841'DB:business_master_new
loadtime:0.24718379974365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garnett' limit 1
loadtime:0.24722385406494 / seconds
Query Executed:select id FROM `sc` where city='Garnett' && SIC_code='4841'DB:business_master_new
loadtime:0.24769496917725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaston' limit 1
loadtime:0.24773597717285 / seconds
Query Executed:select id FROM `sc` where city='Gaston' && SIC_code='4841'DB:business_master_new
loadtime:0.24820590019226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:0.24825286865234 / seconds
Query Executed:select id FROM `sc` where city='Georgetown' && SIC_code='4841'DB:business_master_new
loadtime:0.24962496757507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gifford' limit 1
loadtime:0.24968385696411 / seconds
Query Executed:select id FROM `sc` where city='Gifford' && SIC_code='4841'DB:business_master_new
loadtime:0.25001692771912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbert' limit 1
loadtime:0.25005292892456 / seconds
Query Executed:select id FROM `sc` where city='Gilbert' && SIC_code='4841'DB:business_master_new
loadtime:0.25056099891663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1
loadtime:0.25061798095703 / seconds
Query Executed:select id FROM `sc` where city='Glendale' && SIC_code='4841'DB:business_master_new
loadtime:0.25094985961914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenn Springs' limit 1
loadtime:0.25098180770874 / seconds
Query Executed:select id FROM `sc` where city='Glenn Springs' && SIC_code='4841'DB:business_master_new
loadtime:0.25121998786926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloverville' limit 1
loadtime:0.25125598907471 / seconds
Query Executed:select id FROM `sc` where city='Gloverville' && SIC_code='4841'DB:business_master_new
loadtime:0.25176382064819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goose Creek' limit 1
loadtime:0.251797914505 / seconds
Query Executed:select id FROM `sc` where city='Goose Creek' && SIC_code='4841'DB:business_master_new
loadtime:0.25315999984741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gramling' limit 1
loadtime:0.25322580337524 / seconds
Query Executed:select id FROM `sc` where city='Gramling' && SIC_code='4841'DB:business_master_new
loadtime:0.25363397598267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graniteville' limit 1
loadtime:0.25367593765259 / seconds
Query Executed:select id FROM `sc` where city='Graniteville' && SIC_code='4841'DB:business_master_new
loadtime:0.25412082672119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gray Court' limit 1
loadtime:0.2541708946228 / seconds
Query Executed:select id FROM `sc` where city='Gray Court' && SIC_code='4841'DB:business_master_new
loadtime:0.25461483001709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Falls' limit 1
loadtime:0.25466084480286 / seconds
Query Executed:select id FROM `sc` where city='Great Falls' && SIC_code='4841'DB:business_master_new
loadtime:0.25508093833923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greeleyville' limit 1
loadtime:0.25513291358948 / seconds
Query Executed:select id FROM `sc` where city='Greeleyville' && SIC_code='4841'DB:business_master_new
loadtime:0.25553297996521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Pond' limit 1
loadtime:0.25557994842529 / seconds
Query Executed:select id FROM `sc` where city='Green Pond' && SIC_code='4841'DB:business_master_new
loadtime:0.25597596168518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Sea' limit 1
loadtime:0.2560019493103 / seconds
Query Executed:select id FROM `sc` where city='Green Sea' && SIC_code='4841'DB:business_master_new
loadtime:0.25665998458862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.25671195983887 / seconds
Query Executed:select id FROM `sc` where city='Greenville' && SIC_code='4841'DB:business_master_new
loadtime:0.25809502601624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood' limit 1
loadtime:0.25816488265991 / seconds
Query Executed:select id FROM `sc` where city='Greenwood' && SIC_code='4841'DB:business_master_new
loadtime:0.25954389572144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greer' limit 1
loadtime:0.25958800315857 / seconds
Query Executed:select id FROM `sc` where city='Greer' && SIC_code='4841'DB:business_master_new
loadtime:0.26094794273376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gresham' limit 1
loadtime:0.26100587844849 / seconds
Query Executed:select id FROM `sc` where city='Gresham' && SIC_code='4841'DB:business_master_new
loadtime:0.26144981384277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grover' limit 1
loadtime:0.2614848613739 / seconds
Query Executed:select id FROM `sc` where city='Grover' && SIC_code='4841'DB:business_master_new
loadtime:0.26172399520874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamer' limit 1
loadtime:0.26176595687866 / seconds
Query Executed:select id FROM `sc` where city='Hamer' && SIC_code='4841'DB:business_master_new
loadtime:0.26212286949158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:0.26215982437134 / seconds
Query Executed:select id FROM `sc` where city='Hampton' && SIC_code='4841'DB:business_master_new
loadtime:0.26264691352844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanahan' limit 1
loadtime:0.26268696784973 / seconds
Query Executed:select id FROM `sc` where city='Hanahan' && SIC_code='4841'DB:business_master_new
loadtime:0.26312780380249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardeeville' limit 1
loadtime:0.26316690444946 / seconds
Query Executed:select id FROM `sc` where city='Hardeeville' && SIC_code='4841'DB:business_master_new
loadtime:0.26367497444153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harleyville' limit 1
loadtime:0.26372098922729 / seconds
Query Executed:select id FROM `sc` where city='Harleyville' && SIC_code='4841'DB:business_master_new
loadtime:0.26412296295166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartsville' limit 1
loadtime:0.26414895057678 / seconds
Query Executed:select id FROM `sc` where city='Hartsville' && SIC_code='4841'DB:business_master_new
loadtime:0.26561093330383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heath Springs' limit 1
loadtime:0.26566791534424 / seconds
Query Executed:select id FROM `sc` where city='Heath Springs' && SIC_code='4841'DB:business_master_new
loadtime:0.2660608291626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hemingway' limit 1
loadtime:0.26608991622925 / seconds
Query Executed:select id FROM `sc` where city='Hemingway' && SIC_code='4841'DB:business_master_new
loadtime:0.26677298545837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hickory Grove' limit 1
loadtime:0.26681089401245 / seconds
Query Executed:select id FROM `sc` where city='Hickory Grove' && SIC_code='4841'DB:business_master_new
loadtime:0.26734781265259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hilda' limit 1
loadtime:0.26737880706787 / seconds
Query Executed:select id FROM `sc` where city='Hilda' && SIC_code='4841'DB:business_master_new
loadtime:0.26768088340759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hilton Head Island' limit 1
loadtime:0.26771688461304 / seconds
Query Executed:select id FROM `sc` where city='Hilton Head Island' && SIC_code='4841'DB:business_master_new
loadtime:0.27013397216797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hilton Head Isle' limit 1
loadtime:0.27017593383789 / seconds
Query Executed:select id FROM `sc` where city='Hilton Head Isle' && SIC_code='4841'DB:business_master_new
loadtime:0.27102184295654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hodges' limit 1
loadtime:0.27106499671936 / seconds
Query Executed:select id FROM `sc` where city='Hodges' && SIC_code='4841'DB:business_master_new
loadtime:0.27176380157471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Hill' limit 1
loadtime:0.27179884910583 / seconds
Query Executed:select id FROM `sc` where city='Holly Hill' && SIC_code='4841'DB:business_master_new
loadtime:0.27231192588806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollywood' limit 1
loadtime:0.27235698699951 / seconds
Query Executed:select id FROM `sc` where city='Hollywood' && SIC_code='4841'DB:business_master_new
loadtime:0.27316784858704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honea Path' limit 1
loadtime:0.27322697639465 / seconds
Query Executed:select id FROM `sc` where city='Honea Path' && SIC_code='4841'DB:business_master_new
loadtime:0.27399086952209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkins' limit 1
loadtime:0.27403783798218 / seconds
Query Executed:select id FROM `sc` where city='Hopkins' && SIC_code='4841'DB:business_master_new
loadtime:0.27484202384949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horatio' limit 1
loadtime:0.27488398551941 / seconds
Query Executed:select id FROM `sc` where city='Horatio' && SIC_code='4841'DB:business_master_new
loadtime:0.2753438949585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huger' limit 1
loadtime:0.27538299560547 / seconds
Query Executed:select id FROM `sc` where city='Huger' && SIC_code='4841'DB:business_master_new
loadtime:0.27603888511658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Inman' limit 1
loadtime:0.27607393264771 / seconds
Query Executed:select id FROM `sc` where city='Inman' && SIC_code='4841'DB:business_master_new
loadtime:0.27882695198059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irmo' limit 1
loadtime:0.27888298034668 / seconds
Query Executed:select id FROM `sc` where city='Irmo' && SIC_code='4841'DB:business_master_new
loadtime:0.28169298171997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Islandton' limit 1
loadtime:0.28174090385437 / seconds
Query Executed:select id FROM `sc` where city='Islandton' && SIC_code='4841'DB:business_master_new
loadtime:0.28264594078064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isle Of Palms' limit 1
loadtime:0.28269600868225 / seconds
Query Executed:select id FROM `sc` where city='Isle Of Palms' && SIC_code='4841'DB:business_master_new
loadtime:0.28331685066223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iva' limit 1
loadtime:0.28336000442505 / seconds
Query Executed:select id FROM `sc` where city='Iva' && SIC_code='4841'DB:business_master_new
loadtime:0.28402185440063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:0.28406500816345 / seconds
Query Executed:select id FROM `sc` where city='Jackson' && SIC_code='4841'DB:business_master_new
loadtime:0.28466200828552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jacksonboro' limit 1
loadtime:0.28469681739807 / seconds
Query Executed:select id FROM `sc` where city='Jacksonboro' && SIC_code='4841'DB:business_master_new
loadtime:0.28527998924255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:0.28532290458679 / seconds
Query Executed:select id FROM `sc` where city='Jamestown' && SIC_code='4841'DB:business_master_new
loadtime:0.28589987754822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:0.28594493865967 / seconds
Query Executed:select id FROM `sc` where city='Jefferson' && SIC_code='4841'DB:business_master_new
loadtime:0.28634595870972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jenkinsville' limit 1
loadtime:0.28637790679932 / seconds
Query Executed:select id FROM `sc` where city='Jenkinsville' && SIC_code='4841'DB:business_master_new
loadtime:0.28720879554749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joanna' limit 1
loadtime:0.2872588634491 / seconds
Query Executed:select id FROM `sc` where city='Joanna' && SIC_code='4841'DB:business_master_new
loadtime:0.28778481483459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johns Island' limit 1
loadtime:0.2878258228302 / seconds
Query Executed:select id FROM `sc` where city='Johns Island' && SIC_code='4841'DB:business_master_new
loadtime:0.29020500183105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnsonville' limit 1
loadtime:0.29025292396545 / seconds
Query Executed:select id FROM `sc` where city='Johnsonville' && SIC_code='4841'DB:business_master_new
loadtime:0.29102087020874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnston' limit 1
loadtime:0.29105687141418 / seconds
Query Executed:select id FROM `sc` where city='Johnston' && SIC_code='4841'DB:business_master_new
loadtime:0.2918119430542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:0.29186391830444 / seconds
Query Executed:select id FROM `sc` where city='Jonesville' && SIC_code='4841'DB:business_master_new
loadtime:0.29257988929749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kershaw' limit 1
loadtime:0.2926299571991 / seconds
Query Executed:select id FROM `sc` where city='Kershaw' && SIC_code='4841'DB:business_master_new
loadtime:0.29325795173645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kiawah Island' limit 1
loadtime:0.29330992698669 / seconds
Query Executed:select id FROM `sc` where city='Kiawah Island' && SIC_code='4841'DB:business_master_new
loadtime:0.29366683959961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinards' limit 1
loadtime:0.29371690750122 / seconds
Query Executed:select id FROM `sc` where city='Kinards' && SIC_code='4841'DB:business_master_new
loadtime:0.29431200027466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kings Creek' limit 1
loadtime:0.29434490203857 / seconds
Query Executed:select id FROM `sc` where city='Kings Creek' && SIC_code='4841'DB:business_master_new
loadtime:0.2945818901062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingstree' limit 1
loadtime:0.29461789131165 / seconds
Query Executed:select id FROM `sc` where city='Kingstree' && SIC_code='4841'DB:business_master_new
loadtime:0.29737091064453 / seconds
Query loaded from cache:select * from geodata_geocity where city='La France' limit 1
loadtime:0.29740786552429 / seconds
Query Executed:select id FROM `sc` where city='La France' && SIC_code='4841'DB:business_master_new
loadtime:0.2978208065033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ladson' limit 1
loadtime:0.29786896705627 / seconds
Query Executed:select id FROM `sc` where city='Ladson' && SIC_code='4841'DB:business_master_new
loadtime:0.29882192611694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ladys Island' limit 1
loadtime:0.29885601997375 / seconds
Query Executed:select id FROM `sc` where city='Ladys Island' && SIC_code='4841'DB:business_master_new
loadtime:0.29930281639099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake City' limit 1
loadtime:0.29934191703796 / seconds
Query Executed:select id FROM `sc` where city='Lake City' && SIC_code='4841'DB:business_master_new
loadtime:0.30194187164307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake View' limit 1
loadtime:0.30199885368347 / seconds
Query Executed:select id FROM `sc` where city='Lake View' && SIC_code='4841'DB:business_master_new
loadtime:0.30256390571594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Wylie' limit 1
loadtime:0.30261397361755 / seconds
Query Executed:select id FROM `sc` where city='Lake Wylie' && SIC_code='4841'DB:business_master_new
loadtime:0.30321288108826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamar' limit 1
loadtime:0.3032398223877 / seconds
Query Executed:select id FROM `sc` where city='Lamar' && SIC_code='4841'DB:business_master_new
loadtime:0.30387187004089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:0.30391788482666 / seconds
Query Executed:select id FROM `sc` where city='Lancaster' && SIC_code='4841'DB:business_master_new
loadtime:0.30687284469604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lando' limit 1
loadtime:0.30693197250366 / seconds
Query Executed:select id FROM `sc` where city='Lando' && SIC_code='4841'DB:business_master_new
loadtime:0.3073308467865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Landrum' limit 1
loadtime:0.30736184120178 / seconds
Query Executed:select id FROM `sc` where city='Landrum' && SIC_code='4841'DB:business_master_new
loadtime:0.30820202827454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lane' limit 1
loadtime:0.30824995040894 / seconds
Query Executed:select id FROM `sc` where city='Lane' && SIC_code='4841'DB:business_master_new
loadtime:0.30914497375488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langley' limit 1
loadtime:0.30917882919312 / seconds
Query Executed:select id FROM `sc` where city='Langley' && SIC_code='4841'DB:business_master_new
loadtime:0.3101749420166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Latta' limit 1
loadtime:0.310222864151 / seconds
Query Executed:select id FROM `sc` where city='Latta' && SIC_code='4841'DB:business_master_new
loadtime:0.31099081039429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurens' limit 1
loadtime:0.31103181838989 / seconds
Query Executed:select id FROM `sc` where city='Laurens' && SIC_code='4841'DB:business_master_new
loadtime:0.31401991844177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leesville' limit 1
loadtime:0.31407499313354 / seconds
Query Executed:select id FROM `sc` where city='Leesville' && SIC_code='4841'DB:business_master_new
loadtime:0.31501388549805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:0.31506395339966 / seconds
Query Executed:select id FROM `sc` where city='Lexington' && SIC_code='4841'DB:business_master_new
loadtime:0.31763482093811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty' limit 1
loadtime:0.31769180297852 / seconds
Query Executed:select id FROM `sc` where city='Liberty' && SIC_code='4841'DB:business_master_new
loadtime:0.31833791732788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty Hill' limit 1
loadtime:0.31837582588196 / seconds
Query Executed:select id FROM `sc` where city='Liberty Hill' && SIC_code='4841'DB:business_master_new
loadtime:0.31884694099426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincolnville' limit 1
loadtime:0.31889700889587 / seconds
Query Executed:select id FROM `sc` where city='Lincolnville' && SIC_code='4841'DB:business_master_new
loadtime:0.31928300857544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Mountain' limit 1
loadtime:0.31930994987488 / seconds
Query Executed:select id FROM `sc` where city='Little Mountain' && SIC_code='4841'DB:business_master_new
loadtime:0.31994080543518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little River' limit 1
loadtime:0.31998991966248 / seconds
Query Executed:select id FROM `sc` where city='Little River' && SIC_code='4841'DB:business_master_new
loadtime:0.32280492782593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Rock' limit 1
loadtime:0.32286190986633 / seconds
Query Executed:select id FROM `sc` where city='Little Rock' && SIC_code='4841'DB:business_master_new
loadtime:0.32355785369873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Livingston' limit 1
loadtime:0.32360792160034 / seconds
Query Executed:select id FROM `sc` where city='Livingston' && SIC_code='4841'DB:business_master_new
loadtime:0.32385182380676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lobeco' limit 1
loadtime:0.32388186454773 / seconds
Query Executed:select id FROM `sc` where city='Lobeco' && SIC_code='4841'DB:business_master_new
loadtime:0.3244788646698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lockhart' limit 1
loadtime:0.32452797889709 / seconds
Query Executed:select id FROM `sc` where city='Lockhart' && SIC_code='4841'DB:business_master_new
loadtime:0.32517099380493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lodge' limit 1
loadtime:0.32523393630981 / seconds
Query Executed:select id FROM `sc` where city='Lodge' && SIC_code='4841'DB:business_master_new
loadtime:0.32580089569092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lone Star' limit 1
loadtime:0.32584691047668 / seconds
Query Executed:select id FROM `sc` where city='Lone Star' && SIC_code='4841'DB:business_master_new
loadtime:0.32631397247314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Creek' limit 1
loadtime:0.32634496688843 / seconds
Query Executed:select id FROM `sc` where city='Long Creek' && SIC_code='4841'DB:business_master_new
loadtime:0.32700085639954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longs' limit 1
loadtime:0.32704901695251 / seconds
Query Executed:select id FROM `sc` where city='Longs' && SIC_code='4841'DB:business_master_new
loadtime:0.32786393165588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loris' limit 1
loadtime:0.32789993286133 / seconds
Query Executed:select id FROM `sc` where city='Loris' && SIC_code='4841'DB:business_master_new
loadtime:0.33093190193176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowndesville' limit 1
loadtime:0.33098196983337 / seconds
Query Executed:select id FROM `sc` where city='Lowndesville' && SIC_code='4841'DB:business_master_new
loadtime:0.33133888244629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lugoff' limit 1
loadtime:0.33136582374573 / seconds
Query Executed:select id FROM `sc` where city='Lugoff' && SIC_code='4841'DB:business_master_new
loadtime:0.33222794532776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luray' limit 1
loadtime:0.33227586746216 / seconds
Query Executed:select id FROM `sc` where city='Luray' && SIC_code='4841'DB:business_master_new
loadtime:0.33285093307495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lydia' limit 1
loadtime:0.33289194107056 / seconds
Query Executed:select id FROM `sc` where city='Lydia' && SIC_code='4841'DB:business_master_new
loadtime:0.33332800865173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyman' limit 1
loadtime:0.33336782455444 / seconds
Query Executed:select id FROM `sc` where city='Lyman' && SIC_code='4841'DB:business_master_new
loadtime:0.33415579795837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynchburg' limit 1
loadtime:0.33420491218567 / seconds
Query Executed:select id FROM `sc` where city='Lynchburg' && SIC_code='4841'DB:business_master_new
loadtime:0.33485293388367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manning' limit 1
loadtime:0.33489799499512 / seconds
Query Executed:select id FROM `sc` where city='Manning' && SIC_code='4841'DB:business_master_new
loadtime:0.33785486221313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marietta' limit 1
loadtime:0.33790683746338 / seconds
Query Executed:select id FROM `sc` where city='Marietta' && SIC_code='4841'DB:business_master_new
loadtime:0.33863282203674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.33867883682251 / seconds
Query Executed:select id FROM `sc` where city='Marion' && SIC_code='4841'DB:business_master_new
loadtime:0.34151291847229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martin' limit 1
loadtime:0.34155297279358 / seconds
Query Executed:select id FROM `sc` where city='Martin' && SIC_code='4841'DB:business_master_new
loadtime:0.3421778678894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mauldin' limit 1
loadtime:0.34222602844238 / seconds
Query Executed:select id FROM `sc` where city='Mauldin' && SIC_code='4841'DB:business_master_new
loadtime:0.3446888923645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayesville' limit 1
loadtime:0.34472393989563 / seconds
Query Executed:select id FROM `sc` where city='Mayesville' && SIC_code='4841'DB:business_master_new
loadtime:0.34522581100464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayo' limit 1
loadtime:0.34526681900024 / seconds
Query Executed:select id FROM `sc` where city='Mayo' && SIC_code='4841'DB:business_master_new
loadtime:0.34616684913635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Bee' limit 1
loadtime:0.34620094299316 / seconds
Query Executed:select id FROM `sc` where city='Mc Bee' && SIC_code='4841'DB:business_master_new
loadtime:0.3468599319458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Clellanville' limit 1
loadtime:0.34690999984741 / seconds
Query Executed:select id FROM `sc` where city='Mc Clellanville' && SIC_code='4841'DB:business_master_new
loadtime:0.34759497642517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Coll' limit 1
loadtime:0.34763383865356 / seconds
Query Executed:select id FROM `sc` where city='Mc Coll' && SIC_code='4841'DB:business_master_new
loadtime:0.34821200370789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Connells' limit 1
loadtime:0.34825992584229 / seconds
Query Executed:select id FROM `sc` where city='Mc Connells' && SIC_code='4841'DB:business_master_new
loadtime:0.34881997108459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Cormick' limit 1
loadtime:0.34886789321899 / seconds
Query Executed:select id FROM `sc` where city='Mc Cormick' && SIC_code='4841'DB:business_master_new
loadtime:0.34976601600647 / seconds
Query Executed:select * from geodata_geocity where city='Mccormick' limit 1DB:business_master_new
loadtime:0.35006880760193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meggett' limit 1
loadtime:0.35011601448059 / seconds
Query Executed:select id FROM `sc` where city='Meggett' && SIC_code='4841'DB:business_master_new
loadtime:0.35035181045532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miley' limit 1
loadtime:0.35039091110229 / seconds
Query Executed:select id FROM `sc` where city='Miley' && SIC_code='4841'DB:business_master_new
loadtime:0.35064601898193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minturn' limit 1
loadtime:0.35067486763 / seconds
Query Executed:select id FROM `sc` where city='Minturn' && SIC_code='4841'DB:business_master_new
loadtime:0.35091686248779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modoc' limit 1
loadtime:0.35095000267029 / seconds
Query Executed:select id FROM `sc` where city='Modoc' && SIC_code='4841'DB:business_master_new
loadtime:0.35130286216736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moncks Corner' limit 1
loadtime:0.35132694244385 / seconds
Query Executed:select id FROM `sc` where city='Moncks Corner' && SIC_code='4841'DB:business_master_new
loadtime:0.35412383079529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monetta' limit 1
loadtime:0.35416698455811 / seconds
Query Executed:select id FROM `sc` where city='Monetta' && SIC_code='4841'DB:business_master_new
loadtime:0.35505080223083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:0.35508298873901 / seconds
Query Executed:select id FROM `sc` where city='Monticello' && SIC_code='4841'DB:business_master_new
loadtime:0.35533094406128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montmorenci' limit 1
loadtime:0.35535788536072 / seconds
Query Executed:select id FROM `sc` where city='Montmorenci' && SIC_code='4841'DB:business_master_new
loadtime:0.35582780838013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moore' limit 1
loadtime:0.35587382316589 / seconds
Query Executed:select id FROM `sc` where city='Moore' && SIC_code='4841'DB:business_master_new
loadtime:0.35661482810974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Carmel' limit 1
loadtime:0.35666394233704 / seconds
Query Executed:select id FROM `sc` where city='Mount Carmel' && SIC_code='4841'DB:business_master_new
loadtime:0.35708498954773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Croghan' limit 1
loadtime:0.35714101791382 / seconds
Query Executed:select id FROM `sc` where city='Mount Croghan' && SIC_code='4841'DB:business_master_new
loadtime:0.358078956604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:0.35814189910889 / seconds
Query Executed:select id FROM `sc` where city='Mount Pleasant' && SIC_code='4841'DB:business_master_new
loadtime:0.36105179786682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain Rest' limit 1
loadtime:0.36111402511597 / seconds
Query Executed:select id FROM `sc` where city='Mountain Rest' && SIC_code='4841'DB:business_master_new
loadtime:0.3622260093689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountville' limit 1
loadtime:0.36226081848145 / seconds
Query Executed:select id FROM `sc` where city='Mountville' && SIC_code='4841'DB:business_master_new
loadtime:0.36317181587219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Carmel' limit 1
loadtime:0.36321783065796 / seconds
Query Executed:select id FROM `sc` where city='Mt Carmel' && SIC_code='4841'DB:business_master_new
loadtime:0.36347198486328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Croghan' limit 1
loadtime:0.36350584030151 / seconds
Query Executed:select id FROM `sc` where city='Mt Croghan' && SIC_code='4841'DB:business_master_new
loadtime:0.36374282836914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:0.36376786231995 / seconds
Query Executed:select id FROM `sc` where city='Mt Pleasant' && SIC_code='4841'DB:business_master_new
loadtime:0.36424088478088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mullins' limit 1
loadtime:0.36426496505737 / seconds
Query Executed:select id FROM `sc` where city='Mullins' && SIC_code='4841'DB:business_master_new
loadtime:0.36521482467651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murrells Inlet' limit 1
loadtime:0.36526393890381 / seconds
Query Executed:select id FROM `sc` where city='Murrells Inlet' && SIC_code='4841'DB:business_master_new
loadtime:0.36817693710327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Myrtle Beach' limit 1
loadtime:0.36821889877319 / seconds
Query Executed:select id FROM `sc` where city='Myrtle Beach' && SIC_code='4841'DB:business_master_new
loadtime:0.37115502357483 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Charleston' limit 1
loadtime:0.3712158203125 / seconds
Query Executed:select id FROM `sc` where city='N Charleston' && SIC_code='4841'DB:business_master_new
loadtime:0.37145090103149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neeses' limit 1
loadtime:0.37148499488831 / seconds
Query Executed:select id FROM `sc` where city='Neeses' && SIC_code='4841'DB:business_master_new
loadtime:0.37208390235901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nesmith' limit 1
loadtime:0.3721330165863 / seconds
Query Executed:select id FROM `sc` where city='Nesmith' && SIC_code='4841'DB:business_master_new
loadtime:0.37301898002625 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Ellenton' limit 1
loadtime:0.37307000160217 / seconds
Query Executed:select id FROM `sc` where city='New Ellenton' && SIC_code='4841'DB:business_master_new
loadtime:0.37361884117126 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Zion' limit 1
loadtime:0.37365889549255 / seconds
Query Executed:select id FROM `sc` where city='New Zion' && SIC_code='4841'DB:business_master_new
loadtime:0.37433886528015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newberry' limit 1
loadtime:0.37437891960144 / seconds
Query Executed:select id FROM `sc` where city='Newberry' && SIC_code='4841'DB:business_master_new
loadtime:0.37729597091675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newry' limit 1
loadtime:0.37734389305115 / seconds
Query Executed:select id FROM `sc` where city='Newry' && SIC_code='4841'DB:business_master_new
loadtime:0.3776068687439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nichols' limit 1
loadtime:0.37764692306519 / seconds
Query Executed:select id FROM `sc` where city='Nichols' && SIC_code='4841'DB:business_master_new
loadtime:0.37821197509766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ninety Six' limit 1
loadtime:0.37823700904846 / seconds
Query Executed:select id FROM `sc` where city='Ninety Six' && SIC_code='4841'DB:business_master_new
loadtime:0.37893891334534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norris' limit 1
loadtime:0.37899589538574 / seconds
Query Executed:select id FROM `sc` where city='Norris' && SIC_code='4841'DB:business_master_new
loadtime:0.37951302528381 / seconds
Query loaded from cache:select * from geodata_geocity where city='North' limit 1
loadtime:0.37956285476685 / seconds
Query Executed:select id FROM `sc` where city='North' && SIC_code='4841'DB:business_master_new
loadtime:0.3801748752594 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Augusta' limit 1
loadtime:0.3802227973938 / seconds
Query Executed:select id FROM `sc` where city='North Augusta' && SIC_code='4841'DB:business_master_new
loadtime:0.3830509185791 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Charleston' limit 1
loadtime:0.38309383392334 / seconds
Query Executed:select id FROM `sc` where city='North Charleston' && SIC_code='4841'DB:business_master_new
loadtime:0.38575482368469 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Myrtle Bch' limit 1
loadtime:0.3858118057251 / seconds
Query Executed:select id FROM `sc` where city='North Myrtle Bch' && SIC_code='4841'DB:business_master_new
loadtime:0.38626980781555 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Myrtle Beach' limit 1
loadtime:0.38629794120789 / seconds
Query Executed:select id FROM `sc` where city='North Myrtle Beach' && SIC_code='4841'DB:business_master_new
loadtime:0.38929486274719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norway' limit 1
loadtime:0.38935279846191 / seconds
Query Executed:select id FROM `sc` where city='Norway' && SIC_code='4841'DB:business_master_new
loadtime:0.39000797271729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Drive' limit 1
loadtime:0.39004397392273 / seconds
Query Executed:select id FROM `sc` where city='Ocean Drive' && SIC_code='4841'DB:business_master_new
loadtime:0.39032697677612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okatie' limit 1
loadtime:0.39036893844604 / seconds
Query Executed:select id FROM `sc` where city='Okatie' && SIC_code='4841'DB:business_master_new
loadtime:0.39113783836365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olanta' limit 1
loadtime:0.39118099212646 / seconds
Query Executed:select id FROM `sc` where city='Olanta' && SIC_code='4841'DB:business_master_new
loadtime:0.3918628692627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olar' limit 1
loadtime:0.3919198513031 / seconds
Query Executed:select id FROM `sc` where city='Olar' && SIC_code='4841'DB:business_master_new
loadtime:0.39284896850586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orangeburg' limit 1
loadtime:0.39289784431458 / seconds
Query Executed:select id FROM `sc` where city='Orangeburg' && SIC_code='4841'DB:business_master_new
loadtime:0.39546489715576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pacolet' limit 1
loadtime:0.3955078125 / seconds
Query Executed:select id FROM `sc` where city='Pacolet' && SIC_code='4841'DB:business_master_new
loadtime:0.39618587493896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pacolet Mills' limit 1
loadtime:0.39624285697937 / seconds
Query Executed:select id FROM `sc` where city='Pacolet Mills' && SIC_code='4841'DB:business_master_new
loadtime:0.39671492576599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pageland' limit 1
loadtime:0.3967559337616 / seconds
Query Executed:select id FROM `sc` where city='Pageland' && SIC_code='4841'DB:business_master_new
loadtime:0.39736294746399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pamplico' limit 1
loadtime:0.39741182327271 / seconds
Query Executed:select id FROM `sc` where city='Pamplico' && SIC_code='4841'DB:business_master_new
loadtime:0.39812183380127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parksville' limit 1
loadtime:0.39815783500671 / seconds
Query Executed:select id FROM `sc` where city='Parksville' && SIC_code='4841'DB:business_master_new
loadtime:0.39842987060547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parris Island' limit 1
loadtime:0.39846992492676 / seconds
Query Executed:select id FROM `sc` where city='Parris Island' && SIC_code='4841'DB:business_master_new
loadtime:0.39897489547729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patrick' limit 1
loadtime:0.39901494979858 / seconds
Query Executed:select id FROM `sc` where city='Patrick' && SIC_code='4841'DB:business_master_new
loadtime:0.39953780174255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pauline' limit 1
loadtime:0.39958596229553 / seconds
Query Executed:select id FROM `sc` where city='Pauline' && SIC_code='4841'DB:business_master_new
loadtime:0.40016388893127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pawleys Island' limit 1
loadtime:0.40020179748535 / seconds
Query Executed:select id FROM `sc` where city='Pawleys Island' && SIC_code='4841'DB:business_master_new
loadtime:0.40299081802368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paxville' limit 1
loadtime:0.40305590629578 / seconds
Query Executed:select id FROM `sc` where city='Paxville' && SIC_code='4841'DB:business_master_new
loadtime:0.40334701538086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peak' limit 1
loadtime:0.40338802337646 / seconds
Query Executed:select id FROM `sc` where city='Peak' && SIC_code='4841'DB:business_master_new
loadtime:0.40384101867676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelion' limit 1
loadtime:0.40388894081116 / seconds
Query Executed:select id FROM `sc` where city='Pelion' && SIC_code='4841'DB:business_master_new
loadtime:0.40458488464355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelzer' limit 1
loadtime:0.40463399887085 / seconds
Query Executed:select id FROM `sc` where city='Pelzer' && SIC_code='4841'DB:business_master_new
loadtime:0.40527892112732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pendleton' limit 1
loadtime:0.40531301498413 / seconds
Query Executed:select id FROM `sc` where city='Pendleton' && SIC_code='4841'DB:business_master_new
loadtime:0.40609979629517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perry' limit 1
loadtime:0.40616393089294 / seconds
Query Executed:select id FROM `sc` where city='Perry' && SIC_code='4841'DB:business_master_new
loadtime:0.40641593933105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickens' limit 1
loadtime:0.40644693374634 / seconds
Query Executed:select id FROM `sc` where city='Pickens' && SIC_code='4841'DB:business_master_new
loadtime:0.40936589241028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piedmont' limit 1
loadtime:0.40942192077637 / seconds
Query Executed:select id FROM `sc` where city='Piedmont' && SIC_code='4841'DB:business_master_new
loadtime:0.41234588623047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pineland' limit 1
loadtime:0.41239380836487 / seconds
Query Executed:select id FROM `sc` where city='Pineland' && SIC_code='4841'DB:business_master_new
loadtime:0.41310787200928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pineville' limit 1
loadtime:0.41316795349121 / seconds
Query Executed:select id FROM `sc` where city='Pineville' && SIC_code='4841'DB:business_master_new
loadtime:0.41376900672913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinewood' limit 1
loadtime:0.41380381584167 / seconds
Query Executed:select id FROM `sc` where city='Pinewood' && SIC_code='4841'DB:business_master_new
loadtime:0.4142689704895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinopolis' limit 1
loadtime:0.41430997848511 / seconds
Query Executed:select id FROM `sc` where city='Pinopolis' && SIC_code='4841'DB:business_master_new
loadtime:0.4150378704071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plum Branch' limit 1
loadtime:0.41507291793823 / seconds
Query Executed:select id FROM `sc` where city='Plum Branch' && SIC_code='4841'DB:business_master_new
loadtime:0.41562700271606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomaria' limit 1
loadtime:0.41567587852478 / seconds
Query Executed:select id FROM `sc` where city='Pomaria' && SIC_code='4841'DB:business_master_new
loadtime:0.41620302200317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Royal' limit 1
loadtime:0.41622996330261 / seconds
Query Executed:select id FROM `sc` where city='Port Royal' && SIC_code='4841'DB:business_master_new
loadtime:0.41692590713501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prosperity' limit 1
loadtime:0.41698288917542 / seconds
Query Executed:select id FROM `sc` where city='Prosperity' && SIC_code='4841'DB:business_master_new
loadtime:0.41763186454773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinby' limit 1
loadtime:0.41768002510071 / seconds
Query Executed:select id FROM `sc` where city='Quinby' && SIC_code='4841'DB:business_master_new
loadtime:0.41791987419128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rains' limit 1
loadtime:0.41794681549072 / seconds
Query Executed:select id FROM `sc` where city='Rains' && SIC_code='4841'DB:business_master_new
loadtime:0.41825389862061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ravenel' limit 1
loadtime:0.41828989982605 / seconds
Query Executed:select id FROM `sc` where city='Ravenel' && SIC_code='4841'DB:business_master_new
loadtime:0.41896390914917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reevesville' limit 1
loadtime:0.4189989566803 / seconds
Query Executed:select id FROM `sc` where city='Reevesville' && SIC_code='4841'DB:business_master_new
loadtime:0.41943788528442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reidville' limit 1
loadtime:0.41948580741882 / seconds
Query Executed:select id FROM `sc` where city='Reidville' && SIC_code='4841'DB:business_master_new
loadtime:0.42015981674194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rembert' limit 1
loadtime:0.42018699645996 / seconds
Query Executed:select id FROM `sc` where city='Rembert' && SIC_code='4841'DB:business_master_new
loadtime:0.42080783843994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richburg' limit 1
loadtime:0.42085599899292 / seconds
Query Executed:select id FROM `sc` where city='Richburg' && SIC_code='4841'DB:business_master_new
loadtime:0.42151379585266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland' limit 1
loadtime:0.42156481742859 / seconds
Query Executed:select id FROM `sc` where city='Richland' && SIC_code='4841'DB:business_master_new
loadtime:0.42194294929504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridge Spring' limit 1
loadtime:0.42197394371033 / seconds
Query Executed:select id FROM `sc` where city='Ridge Spring' && SIC_code='4841'DB:business_master_new
loadtime:0.42249298095703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeland' limit 1
loadtime:0.42254090309143 / seconds
Query Executed:select id FROM `sc` where city='Ridgeland' && SIC_code='4841'DB:business_master_new
loadtime:0.4252758026123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeville' limit 1
loadtime:0.42533493041992 / seconds
Query Executed:select id FROM `sc` where city='Ridgeville' && SIC_code='4841'DB:business_master_new
loadtime:0.42606902122498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:0.42612099647522 / seconds
Query Executed:select id FROM `sc` where city='Ridgeway' && SIC_code='4841'DB:business_master_new
loadtime:0.42682695388794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rimini' limit 1
loadtime:0.42687797546387 / seconds
Query Executed:select id FROM `sc` where city='Rimini' && SIC_code='4841'DB:business_master_new
loadtime:0.42729783058167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rion' limit 1
loadtime:0.42733001708984 / seconds
Query Executed:select id FROM `sc` where city='Rion' && SIC_code='4841'DB:business_master_new
loadtime:0.42757797241211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ritter' limit 1
loadtime:0.4276168346405 / seconds
Query Executed:select id FROM `sc` where city='Ritter' && SIC_code='4841'DB:business_master_new
loadtime:0.42784690856934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Hill' limit 1
loadtime:0.42787480354309 / seconds
Query Executed:select id FROM `sc` where city='Rock Hill' && SIC_code='4841'DB:business_master_new
loadtime:0.43077683448792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roebuck' limit 1
loadtime:0.43083500862122 / seconds
Query Executed:select id FROM `sc` where city='Roebuck' && SIC_code='4841'DB:business_master_new
loadtime:0.43166995048523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Round O' limit 1
loadtime:0.43171095848083 / seconds
Query Executed:select id FROM `sc` where city='Round O' && SIC_code='4841'DB:business_master_new
loadtime:0.43223786354065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowesville' limit 1
loadtime:0.43227982521057 / seconds
Query Executed:select id FROM `sc` where city='Rowesville' && SIC_code='4841'DB:business_master_new
loadtime:0.43312001228333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruby' limit 1
loadtime:0.4331579208374 / seconds
Query Executed:select id FROM `sc` where city='Ruby' && SIC_code='4841'DB:business_master_new
loadtime:0.43373799324036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruffin' limit 1
loadtime:0.43378591537476 / seconds
Query Executed:select id FROM `sc` where city='Ruffin' && SIC_code='4841'DB:business_master_new
loadtime:0.43423891067505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Russellville' limit 1
loadtime:0.43428087234497 / seconds
Query Executed:select id FROM `sc` where city='Russellville' && SIC_code='4841'DB:business_master_new
loadtime:0.43473291397095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint George' limit 1
loadtime:0.43477582931519 / seconds
Query Executed:select id FROM `sc` where city='Saint George' && SIC_code='4841'DB:business_master_new
loadtime:0.43567180633545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Helena Island' limit 1
loadtime:0.43572402000427 / seconds
Query Executed:select id FROM `sc` where city='Saint Helena Island' && SIC_code='4841'DB:business_master_new
loadtime:0.43629384040833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Matthews' limit 1
loadtime:0.43632292747498 / seconds
Query Executed:select id FROM `sc` where city='Saint Matthews' && SIC_code='4841'DB:business_master_new
loadtime:0.43718290328979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Stephen' limit 1
loadtime:0.43725299835205 / seconds
Query Executed:select id FROM `sc` where city='Saint Stephen' && SIC_code='4841'DB:business_master_new
loadtime:0.43802881240845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.43808197975159 / seconds
Query Executed:select id FROM `sc` where city='Salem' && SIC_code='4841'DB:business_master_new
loadtime:0.4387469291687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salley' limit 1
loadtime:0.43880200386047 / seconds
Query Executed:select id FROM `sc` where city='Salley' && SIC_code='4841'DB:business_master_new
loadtime:0.43934893608093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salters' limit 1
loadtime:0.43937587738037 / seconds
Query Executed:select id FROM `sc` where city='Salters' && SIC_code='4841'DB:business_master_new
loadtime:0.43994784355164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saluda' limit 1
loadtime:0.43999695777893 / seconds
Query Executed:select id FROM `sc` where city='Saluda' && SIC_code='4841'DB:business_master_new
loadtime:0.44077682495117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Springs' limit 1
loadtime:0.4408118724823 / seconds
Query Executed:select id FROM `sc` where city='Sandy Springs' && SIC_code='4841'DB:business_master_new
loadtime:0.44179582595825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santee' limit 1
loadtime:0.44184398651123 / seconds
Query Executed:select id FROM `sc` where city='Santee' && SIC_code='4841'DB:business_master_new
loadtime:0.44271492958069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sardinia' limit 1
loadtime:0.44276189804077 / seconds
Query Executed:select id FROM `sc` where city='Sardinia' && SIC_code='4841'DB:business_master_new
loadtime:0.44302296638489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotia' limit 1
loadtime:0.44305992126465 / seconds
Query Executed:select id FROM `sc` where city='Scotia' && SIC_code='4841'DB:business_master_new
loadtime:0.4433388710022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scranton' limit 1
loadtime:0.44337701797485 / seconds
Query Executed:select id FROM `sc` where city='Scranton' && SIC_code='4841'DB:business_master_new
loadtime:0.44405794143677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seabrook' limit 1
loadtime:0.44410586357117 / seconds
Query Executed:select id FROM `sc` where city='Seabrook' && SIC_code='4841'DB:business_master_new
loadtime:0.44468188285828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sellers' limit 1
loadtime:0.44473099708557 / seconds
Query Executed:select id FROM `sc` where city='Sellers' && SIC_code='4841'DB:business_master_new
loadtime:0.44524884223938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:0.4452760219574 / seconds
Query Executed:select id FROM `sc` where city='Seneca' && SIC_code='4841'DB:business_master_new
loadtime:0.44775199890137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.44780683517456 / seconds
Query Executed:select id FROM `sc` where city='Sharon' && SIC_code='4841'DB:business_master_new
loadtime:0.44835591316223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaw A F B' limit 1
loadtime:0.44839596748352 / seconds
Query Executed:select id FROM `sc` where city='Shaw A F B' && SIC_code='4841'DB:business_master_new
loadtime:0.44861793518066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaw Afb' limit 1
loadtime:0.44864392280579 / seconds
Query Executed:select id FROM `sc` where city='Shaw Afb' && SIC_code='4841'DB:business_master_new
loadtime:0.44917297363281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon' limit 1
loadtime:0.44921898841858 / seconds
Query Executed:select id FROM `sc` where city='Sheldon' && SIC_code='4841'DB:business_master_new
loadtime:0.44995284080505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shulerville' limit 1
loadtime:0.44999289512634 / seconds
Query Executed:select id FROM `sc` where city='Shulerville' && SIC_code='4841'DB:business_master_new
loadtime:0.4502649307251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silverstreet' limit 1
loadtime:0.45030403137207 / seconds
Query Executed:select id FROM `sc` where city='Silverstreet' && SIC_code='4841'DB:business_master_new
loadtime:0.45097780227661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Simpsonville' limit 1
loadtime:0.45102500915527 / seconds
Query Executed:select id FROM `sc` where city='Simpsonville' && SIC_code='4841'DB:business_master_new
loadtime:0.45337390899658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Six Mile' limit 1
loadtime:0.45341682434082 / seconds
Query Executed:select id FROM `sc` where city='Six Mile' && SIC_code='4841'DB:business_master_new
loadtime:0.45406198501587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Slater' limit 1
loadtime:0.45412397384644 / seconds
Query Executed:select id FROM `sc` where city='Slater' && SIC_code='4841'DB:business_master_new
loadtime:0.45463490486145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smoaks' limit 1
loadtime:0.45466899871826 / seconds
Query Executed:select id FROM `sc` where city='Smoaks' && SIC_code='4841'DB:business_master_new
loadtime:0.4551739692688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smyrna' limit 1
loadtime:0.45521402359009 / seconds
Query Executed:select id FROM `sc` where city='Smyrna' && SIC_code='4841'DB:business_master_new
loadtime:0.45602989196777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Society Hill' limit 1
loadtime:0.45606899261475 / seconds
Query Executed:select id FROM `sc` where city='Society Hill' && SIC_code='4841'DB:business_master_new
loadtime:0.45671582221985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spartanburg' limit 1
loadtime:0.45676589012146 / seconds
Query Executed:select id FROM `sc` where city='Spartanburg' && SIC_code='4841'DB:business_master_new
loadtime:0.45919799804688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.45925998687744 / seconds
Query Executed:select id FROM `sc` where city='Springfield' && SIC_code='4841'DB:business_master_new
loadtime:0.45984292030334 / seconds
Query loaded from cache:select * from geodata_geocity where city='St George' limit 1
loadtime:0.45988893508911 / seconds
Query Executed:select id FROM `sc` where city='St George' && SIC_code='4841'DB:business_master_new
loadtime:0.4603099822998 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Helena Island' limit 1
loadtime:0.46035385131836 / seconds
Query Executed:select id FROM `sc` where city='St Helena Island' && SIC_code='4841'DB:business_master_new
loadtime:0.46081399917603 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Matthews' limit 1
loadtime:0.46084880828857 / seconds
Query Executed:select id FROM `sc` where city='St Matthews' && SIC_code='4841'DB:business_master_new
loadtime:0.46150398254395 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Stephen' limit 1
loadtime:0.46155285835266 / seconds
Query Executed:select id FROM `sc` where city='St Stephen' && SIC_code='4841'DB:business_master_new
loadtime:0.46179699897766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Starr' limit 1
loadtime:0.46183085441589 / seconds
Query Executed:select id FROM `sc` where city='Starr' && SIC_code='4841'DB:business_master_new
loadtime:0.46238398551941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Startex' limit 1
loadtime:0.46240901947021 / seconds
Query Executed:select id FROM `sc` where city='Startex' && SIC_code='4841'DB:business_master_new
loadtime:0.46290493011475 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Park' limit 1
loadtime:0.46295499801636 / seconds
Query Executed:select id FROM `sc` where city='State Park' && SIC_code='4841'DB:business_master_new
loadtime:0.46335291862488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sullivans Island' limit 1
loadtime:0.46337985992432 / seconds
Query Executed:select id FROM `sc` where city='Sullivans Island' && SIC_code='4841'DB:business_master_new
loadtime:0.46405386924744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summerton' limit 1
loadtime:0.46410584449768 / seconds
Query Executed:select id FROM `sc` where city='Summerton' && SIC_code='4841'DB:business_master_new
loadtime:0.46487188339233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summerville' limit 1
loadtime:0.46490693092346 / seconds
Query Executed:select id FROM `sc` where city='Summerville' && SIC_code='4841'DB:business_master_new
loadtime:0.46787786483765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumter' limit 1
loadtime:0.46793389320374 / seconds
Query Executed:select id FROM `sc` where city='Sumter' && SIC_code='4841'DB:business_master_new
loadtime:0.47064185142517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunset' limit 1
loadtime:0.47070002555847 / seconds
Query Executed:select id FROM `sc` where city='Sunset' && SIC_code='4841'DB:business_master_new
loadtime:0.47120785713196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surfside Beach' limit 1
loadtime:0.47123599052429 / seconds
Query Executed:select id FROM `sc` where city='Surfside Beach' && SIC_code='4841'DB:business_master_new
loadtime:0.47166299819946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swansea' limit 1
loadtime:0.47171902656555 / seconds
Query Executed:select id FROM `sc` where city='Swansea' && SIC_code='4841'DB:business_master_new
loadtime:0.47226786613464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sycamore' limit 1
loadtime:0.47230982780457 / seconds
Query Executed:select id FROM `sc` where city='Sycamore' && SIC_code='4841'DB:business_master_new
loadtime:0.47257995605469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tamassee' limit 1
loadtime:0.47260880470276 / seconds
Query Executed:select id FROM `sc` where city='Tamassee' && SIC_code='4841'DB:business_master_new
loadtime:0.47317385673523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tatum' limit 1
loadtime:0.47321796417236 / seconds
Query Executed:select id FROM `sc` where city='Tatum' && SIC_code='4841'DB:business_master_new
loadtime:0.47366690635681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylors' limit 1
loadtime:0.47370791435242 / seconds
Query Executed:select id FROM `sc` where city='Taylors' && SIC_code='4841'DB:business_master_new
loadtime:0.47630000114441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tigerville' limit 1
loadtime:0.47634887695312 / seconds
Query Executed:select id FROM `sc` where city='Tigerville' && SIC_code='4841'DB:business_master_new
loadtime:0.47681403160095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tillman' limit 1
loadtime:0.4768488407135 / seconds
Query Executed:select id FROM `sc` where city='Tillman' && SIC_code='4841'DB:business_master_new
loadtime:0.47744393348694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timmonsville' limit 1
loadtime:0.47749185562134 / seconds
Query Executed:select id FROM `sc` where city='Timmonsville' && SIC_code='4841'DB:business_master_new
loadtime:0.47821402549744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townville' limit 1
loadtime:0.47825288772583 / seconds
Query Executed:select id FROM `sc` where city='Townville' && SIC_code='4841'DB:business_master_new
loadtime:0.47890496253967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Travelers Rest' limit 1
loadtime:0.47894501686096 / seconds
Query Executed:select id FROM `sc` where city='Travelers Rest' && SIC_code='4841'DB:business_master_new
loadtime:0.48146080970764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trenton' limit 1
loadtime:0.48151183128357 / seconds
Query Executed:select id FROM `sc` where city='Trenton' && SIC_code='4841'DB:business_master_new
loadtime:0.48217582702637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trio' limit 1
loadtime:0.48222494125366 / seconds
Query Executed:select id FROM `sc` where city='Trio' && SIC_code='4841'DB:business_master_new
loadtime:0.48244285583496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:0.48247599601746 / seconds
Query Executed:select id FROM `sc` where city='Troy' && SIC_code='4841'DB:business_master_new
loadtime:0.48298001289368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turbeville' limit 1
loadtime:0.48301601409912 / seconds
Query Executed:select id FROM `sc` where city='Turbeville' && SIC_code='4841'DB:business_master_new
loadtime:0.48361587524414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ulmer' limit 1
loadtime:0.48366498947144 / seconds
Query Executed:select id FROM `sc` where city='Ulmer' && SIC_code='4841'DB:business_master_new
loadtime:0.48423385620117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Una' limit 1
loadtime:0.48426198959351 / seconds
Query Executed:select id FROM `sc` where city='Una' && SIC_code='4841'DB:business_master_new
loadtime:0.48475384712219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:0.48480200767517 / seconds
Query Executed:select id FROM `sc` where city='Union' && SIC_code='4841'DB:business_master_new
loadtime:0.48763990402222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Wyck' limit 1
loadtime:0.48768496513367 / seconds
Query Executed:select id FROM `sc` where city='Van Wyck' && SIC_code='4841'DB:business_master_new
loadtime:0.4881739616394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vance' limit 1
loadtime:0.48821902275085 / seconds
Query Executed:select id FROM `sc` where city='Vance' && SIC_code='4841'DB:business_master_new
loadtime:0.48875379562378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Varnville' limit 1
loadtime:0.48879981040955 / seconds
Query Executed:select id FROM `sc` where city='Varnville' && SIC_code='4841'DB:business_master_new
loadtime:0.48928785324097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vaucluse' limit 1
loadtime:0.48932695388794 / seconds
Query Executed:select id FROM `sc` where city='Vaucluse' && SIC_code='4841'DB:business_master_new
loadtime:0.48957896232605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wadmalaw Island' limit 1
loadtime:0.48960399627686 / seconds
Query Executed:select id FROM `sc` where city='Wadmalaw Island' && SIC_code='4841'DB:business_master_new
loadtime:0.49014902114868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wagener' limit 1
loadtime:0.49018383026123 / seconds
Query Executed:select id FROM `sc` where city='Wagener' && SIC_code='4841'DB:business_master_new
loadtime:0.49087285995483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walhalla' limit 1
loadtime:0.49090790748596 / seconds
Query Executed:select id FROM `sc` where city='Walhalla' && SIC_code='4841'DB:business_master_new
loadtime:0.49178600311279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallace' limit 1
loadtime:0.49183297157288 / seconds
Query Executed:select id FROM `sc` where city='Wallace' && SIC_code='4841'DB:business_master_new
loadtime:0.49236702919006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walterboro' limit 1
loadtime:0.49239993095398 / seconds
Query Executed:select id FROM `sc` where city='Walterboro' && SIC_code='4841'DB:business_master_new
loadtime:0.49483299255371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wando' limit 1
loadtime:0.4948890209198 / seconds
Query Executed:select id FROM `sc` where city='Wando' && SIC_code='4841'DB:business_master_new
loadtime:0.4953339099884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ward' limit 1
loadtime:0.49537181854248 / seconds
Query Executed:select id FROM `sc` where city='Ward' && SIC_code='4841'DB:business_master_new
loadtime:0.49621200561523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ware Shoals' limit 1
loadtime:0.49626088142395 / seconds
Query Executed:select id FROM `sc` where city='Ware Shoals' && SIC_code='4841'DB:business_master_new
loadtime:0.49689602851868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrenville' limit 1
loadtime:0.49692988395691 / seconds
Query Executed:select id FROM `sc` where city='Warrenville' && SIC_code='4841'DB:business_master_new
loadtime:0.49760293960571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterloo' limit 1
loadtime:0.49765086174011 / seconds
Query Executed:select id FROM `sc` where city='Waterloo' && SIC_code='4841'DB:business_master_new
loadtime:0.49822282791138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wedgefield' limit 1
loadtime:0.49826097488403 / seconds
Query Executed:select id FROM `sc` where city='Wedgefield' && SIC_code='4841'DB:business_master_new
loadtime:0.49882698059082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellford' limit 1
loadtime:0.49886798858643 / seconds
Query Executed:select id FROM `sc` where city='Wellford' && SIC_code='4841'DB:business_master_new
loadtime:0.49960684776306 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Columbia' limit 1
loadtime:0.49965500831604 / seconds
Query Executed:select id FROM `sc` where city='West Columbia' && SIC_code='4841'DB:business_master_new
loadtime:0.50216197967529 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Union' limit 1
loadtime:0.50222182273865 / seconds
Query Executed:select id FROM `sc` where city='West Union' && SIC_code='4841'DB:business_master_new
loadtime:0.50295782089233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:0.50299286842346 / seconds
Query Executed:select id FROM `sc` where city='Westminster' && SIC_code='4841'DB:business_master_new
loadtime:0.50384283065796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westville' limit 1
loadtime:0.50389885902405 / seconds
Query Executed:select id FROM `sc` where city='Westville' && SIC_code='4841'DB:business_master_new
loadtime:0.50435495376587 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Rock' limit 1
loadtime:0.50438189506531 / seconds
Query Executed:select id FROM `sc` where city='White Rock' && SIC_code='4841'DB:business_master_new
loadtime:0.50518298149109 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Stone' limit 1
loadtime:0.50524282455444 / seconds
Query Executed:select id FROM `sc` where city='White Stone' && SIC_code='4841'DB:business_master_new
loadtime:0.50562691688538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitmire' limit 1
loadtime:0.50567197799683 / seconds
Query Executed:select id FROM `sc` where city='Whitmire' && SIC_code='4841'DB:business_master_new
loadtime:0.50622200965881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williams' limit 1
loadtime:0.50625991821289 / seconds
Query Executed:select id FROM `sc` where city='Williams' && SIC_code='4841'DB:business_master_new
loadtime:0.50669193267822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamston' limit 1
loadtime:0.50672698020935 / seconds
Query Executed:select id FROM `sc` where city='Williamston' && SIC_code='4841'DB:business_master_new
loadtime:0.50729203224182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williston' limit 1
loadtime:0.50733280181885 / seconds
Query Executed:select id FROM `sc` where city='Williston' && SIC_code='4841'DB:business_master_new
loadtime:0.50815892219543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:0.50820779800415 / seconds
Query Executed:select id FROM `sc` where city='Windsor' && SIC_code='4841'DB:business_master_new
loadtime:0.50874900817871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winnsboro' limit 1
loadtime:0.50879001617432 / seconds
Query Executed:select id FROM `sc` where city='Winnsboro' && SIC_code='4841'DB:business_master_new
loadtime:0.50979995727539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodruff' limit 1
loadtime:0.50985598564148 / seconds
Query Executed:select id FROM `sc` where city='Woodruff' && SIC_code='4841'DB:business_master_new
loadtime:0.51068782806396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yemassee' limit 1
loadtime:0.51073789596558 / seconds
Query Executed:select id FROM `sc` where city='Yemassee' && SIC_code='4841'DB:business_master_new
loadtime:0.51127886772156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yonges Island' limit 1
loadtime:0.51130986213684 / seconds
Query Executed:select id FROM `sc` where city='Yonges Island' && SIC_code='4841'DB:business_master_new
loadtime:0.51155090332031 / seconds
Query loaded from cache:select * from geodata_geocity where city='York' limit 1
loadtime:0.51158881187439 / seconds
Query Executed:select id FROM `sc` where city='York' && SIC_code='4841'DB:business_master_new
loadtime:0.51403188705444 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.51413798332214 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.51430702209473 / seconds
Operation template executed (chunk cache operation)
loadtime:0.51438498497009 / seconds
template override:Default
loadtime:0.51440286636353 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:0.51556587219238 / seconds
Template Constructed, Array Rows:49
loadtime:0.51579999923706 / seconds
TOTAL EXECUTION TIME: 0.51561
loadtime:0.51588797569275 / seconds

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


PAGE OBJECT DATA


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



_GET


Array ( [cat_URLid] => cable-and-other-pay-television-services [stateURLid] => south-carolina )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:0.51589202880859
TOTAL KEY ARRAYS: 69