DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:0.00022196769714355 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0011258125305176 / seconds
host not found setting manual db connection
loadtime:0.0017478466033936 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0021059513092041 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0023930072784424 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0026187896728516 / seconds
zipcode:
loadtime:0.0026710033416748 / seconds
Query Executed:select * from search_referrer where page_hash='25849048a3ece514b9b29afb21e7ca19' limit 10 DB:ezrox_toadli
loadtime:0.0031769275665283 / seconds
Operation header executed (non global)
loadtime:0.0032320022583008 / seconds
Operation leaderboard executed (non global)
loadtime:0.0033748149871826 / seconds
Operation square executed (non global)
loadtime:0.0034158229827881 / seconds
Operation square_bottom executed (non global)
loadtime:0.0034530162811279 / seconds
Operation smallsquare executed (non global)
loadtime:0.0034868717193604 / seconds
Operation headeradright executed (non global)
loadtime:0.0035288333892822 / seconds
Operation google_analytics executed (non global)
loadtime:0.003558874130249 / seconds
Operation topstories executed (non global)
loadtime:0.0035908222198486 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0036787986755371 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0037198066711426 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0041627883911133 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0044758319854736 / seconds
Operation categories executed (global stored into APC)
loadtime:0.004586935043335 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0048129558563232 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0049209594726562 / seconds
Template key: archive_menu pushed
loadtime:0.0049319267272949 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0049519538879395 / seconds
Template key: get_gravatar pushed
loadtime:0.0049588680267334 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0049638748168945 / seconds
*10)-10)+1 | start:0
loadtime:0.0049920082092285 / seconds
Query loaded from cache:select * from categories where cat_URLid='laundry-and-garment-services-nec'
loadtime:0.0050408840179443 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='south-carolina'
loadtime:0.0050849914550781 / seconds
DB connected to localhost business_master_new
loadtime:0.0055458545684814 / seconds
Query Executed:select * from `sc_catmap` where sic='7219' order by city ascDB:business_master_new
loadtime:0.055593967437744 / seconds
Query stored in cache : _QUERY_www.toadli.com2b197815cb6fd7bd16020f62354decac
loadtime:0.05672287940979 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='south-carolina'
loadtime:0.056759834289551 / seconds
Query Executed:select sum(totalcount) as totalsum from `sc_catmap` where sic='7219'DB:business_master_new
loadtime:0.059326887130737 / seconds
Query stored in cache : _QUERY_www.toadli.comc6128b65a8db6094f917b704271bdb76
loadtime:0.059480905532837 / seconds
420 / 11
loadtime:0.059576988220215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abbeville' limit 1
loadtime:0.059757947921753 / seconds
Query Executed:select id FROM `sc` where city='Abbeville' && SIC_code='7219'DB:business_master_new
loadtime:0.095723867416382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adams Run' limit 1
loadtime:0.095991849899292 / seconds
Query Executed:select id FROM `sc` where city='Adams Run' && SIC_code='7219'DB:business_master_new
loadtime:0.096669912338257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aiken' limit 1
loadtime:0.096765995025635 / seconds
Query Executed:select id FROM `sc` where city='Aiken' && SIC_code='7219'DB:business_master_new
loadtime:0.097348928451538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alcolu' limit 1
loadtime:0.097447872161865 / seconds
Query Executed:select id FROM `sc` where city='Alcolu' && SIC_code='7219'DB:business_master_new
loadtime:0.097991943359375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allendale' limit 1
loadtime:0.098065853118896 / seconds
Query Executed:select id FROM `sc` where city='Allendale' && SIC_code='7219'DB:business_master_new
loadtime:0.098562002182007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alvin' limit 1
loadtime:0.09867787361145 / seconds
Query Executed:select id FROM `sc` where city='Alvin' && SIC_code='7219'DB:business_master_new
loadtime:0.098999977111816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anderson' limit 1
loadtime:0.099059820175171 / seconds
Query Executed:select id FROM `sc` where city='Anderson' && SIC_code='7219'DB:business_master_new
loadtime:0.1000509262085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andrews' limit 1
loadtime:0.10009479522705 / seconds
Query Executed:select id FROM `sc` where city='Andrews' && SIC_code='7219'DB:business_master_new
loadtime:0.10161185264587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcadia' limit 1
loadtime:0.10166192054749 / seconds
Query Executed:select id FROM `sc` where city='Arcadia' && SIC_code='7219'DB:business_master_new
loadtime:0.1024808883667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic Beach' limit 1
loadtime:0.10252690315247 / seconds
Query Executed:select id FROM `sc` where city='Atlantic Beach' && SIC_code='7219'DB:business_master_new
loadtime:0.10322690010071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Awendaw' limit 1
loadtime:0.10326290130615 / seconds
Query Executed:select id FROM `sc` where city='Awendaw' && SIC_code='7219'DB:business_master_new
loadtime:0.10411691665649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aynor' limit 1
loadtime:0.10416483879089 / seconds
Query Executed:select id FROM `sc` where city='Aynor' && SIC_code='7219'DB:business_master_new
loadtime:0.104984998703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ballentine' limit 1
loadtime:0.10502791404724 / seconds
Query Executed:select id FROM `sc` where city='Ballentine' && SIC_code='7219'DB:business_master_new
loadtime:0.10550093650818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bamberg' limit 1
loadtime:0.10554480552673 / seconds
Query Executed:select id FROM `sc` where city='Bamberg' && SIC_code='7219'DB:business_master_new
loadtime:0.10603785514832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnwell' limit 1
loadtime:0.1060688495636 / seconds
Query Executed:select id FROM `sc` where city='Barnwell' && SIC_code='7219'DB:business_master_new
loadtime:0.10653495788574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Batesburg' limit 1
loadtime:0.1065788269043 / seconds
Query Executed:select id FROM `sc` where city='Batesburg' && SIC_code='7219'DB:business_master_new
loadtime:0.10703992843628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.10707879066467 / seconds
Query Executed:select id FROM `sc` where city='Bath' && SIC_code='7219'DB:business_master_new
loadtime:0.10754084587097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaufort' limit 1
loadtime:0.10758185386658 / seconds
Query Executed:select id FROM `sc` where city='Beaufort' && SIC_code='7219'DB:business_master_new
loadtime:0.10806798934937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beech Island' limit 1
loadtime:0.10811686515808 / seconds
Query Executed:select id FROM `sc` where city='Beech Island' && SIC_code='7219'DB:business_master_new
loadtime:0.10859799385071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belton' limit 1
loadtime:0.1086368560791 / seconds
Query Executed:select id FROM `sc` where city='Belton' && SIC_code='7219'DB:business_master_new
loadtime:0.10939693450928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvedere' limit 1
loadtime:0.10945701599121 / seconds
Query Executed:select id FROM `sc` where city='Belvedere' && SIC_code='7219'DB:business_master_new
loadtime:0.10988688468933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennettsville' limit 1
loadtime:0.10996794700623 / seconds
Query Executed:select id FROM `sc` where city='Bennettsville' && SIC_code='7219'DB:business_master_new
loadtime:0.11080193519592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethera' limit 1
loadtime:0.11090588569641 / seconds
Query Executed:select id FROM `sc` where city='Bethera' && SIC_code='7219'DB:business_master_new
loadtime:0.11131882667542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethune' limit 1
loadtime:0.11134886741638 / seconds
Query Executed:select id FROM `sc` where city='Bethune' && SIC_code='7219'DB:business_master_new
loadtime:0.11206698417664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bishopville' limit 1
loadtime:0.11211180686951 / seconds
Query Executed:select id FROM `sc` where city='Bishopville' && SIC_code='7219'DB:business_master_new
loadtime:0.11258482933044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blacksburg' limit 1
loadtime:0.11262083053589 / seconds
Query Executed:select id FROM `sc` where city='Blacksburg' && SIC_code='7219'DB:business_master_new
loadtime:0.1131157875061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackstock' limit 1
loadtime:0.11319994926453 / seconds
Query Executed:select id FROM `sc` where city='Blackstock' && SIC_code='7219'DB:business_master_new
loadtime:0.11406493186951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackville' limit 1
loadtime:0.11415791511536 / seconds
Query Executed:select id FROM `sc` where city='Blackville' && SIC_code='7219'DB:business_master_new
loadtime:0.11483192443848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blair' limit 1
loadtime:0.11486196517944 / seconds
Query Executed:select id FROM `sc` where city='Blair' && SIC_code='7219'DB:business_master_new
loadtime:0.11539578437805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blenheim' limit 1
loadtime:0.11547088623047 / seconds
Query Executed:select id FROM `sc` where city='Blenheim' && SIC_code='7219'DB:business_master_new
loadtime:0.11602401733398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluffton' limit 1
loadtime:0.11606788635254 / seconds
Query Executed:select id FROM `sc` where city='Bluffton' && SIC_code='7219'DB:business_master_new
loadtime:0.11652994155884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blythewood' limit 1
loadtime:0.11655879020691 / seconds
Query Executed:select id FROM `sc` where city='Blythewood' && SIC_code='7219'DB:business_master_new
loadtime:0.11701989173889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boiling Springs' limit 1
loadtime:0.11706185340881 / seconds
Query Executed:select id FROM `sc` where city='Boiling Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.11758685112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonneau' limit 1
loadtime:0.11761689186096 / seconds
Query Executed:select id FROM `sc` where city='Bonneau' && SIC_code='7219'DB:business_master_new
loadtime:0.11835384368896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowling Green' limit 1
loadtime:0.11839699745178 / seconds
Query Executed:select id FROM `sc` where city='Bowling Green' && SIC_code='7219'DB:business_master_new
loadtime:0.11900091171265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowman' limit 1
loadtime:0.11907482147217 / seconds
Query Executed:select id FROM `sc` where city='Bowman' && SIC_code='7219'DB:business_master_new
loadtime:0.11982679367065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradley' limit 1
loadtime:0.11991095542908 / seconds
Query Executed:select id FROM `sc` where city='Bradley' && SIC_code='7219'DB:business_master_new
loadtime:0.12039184570312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branchville' limit 1
loadtime:0.12043881416321 / seconds
Query Executed:select id FROM `sc` where city='Branchville' && SIC_code='7219'DB:business_master_new
loadtime:0.12092781066895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brunson' limit 1
loadtime:0.12097191810608 / seconds
Query Executed:select id FROM `sc` where city='Brunson' && SIC_code='7219'DB:business_master_new
loadtime:0.12146997451782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bucksport' limit 1
loadtime:0.1215238571167 / seconds
Query Executed:select id FROM `sc` where city='Bucksport' && SIC_code='7219'DB:business_master_new
loadtime:0.12188982963562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo' limit 1
loadtime:0.12193489074707 / seconds
Query Executed:select id FROM `sc` where city='Buffalo' && SIC_code='7219'DB:business_master_new
loadtime:0.12251400947571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cades' limit 1
loadtime:0.12259292602539 / seconds
Query Executed:select id FROM `sc` where city='Cades' && SIC_code='7219'DB:business_master_new
loadtime:0.12310385704041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calhoun Falls' limit 1
loadtime:0.12313485145569 / seconds
Query Executed:select id FROM `sc` where city='Calhoun Falls' && SIC_code='7219'DB:business_master_new
loadtime:0.12361192703247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camden' limit 1
loadtime:0.12365484237671 / seconds
Query Executed:select id FROM `sc` where city='Camden' && SIC_code='7219'DB:business_master_new
loadtime:0.12417888641357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cameron' limit 1
loadtime:0.12423896789551 / seconds
Query Executed:select id FROM `sc` where city='Cameron' && SIC_code='7219'DB:business_master_new
loadtime:0.12501692771912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Campobello' limit 1
loadtime:0.12509083747864 / seconds
Query Executed:select id FROM `sc` where city='Campobello' && SIC_code='7219'DB:business_master_new
loadtime:0.12577080726624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canadys' limit 1
loadtime:0.12582492828369 / seconds
Query Executed:select id FROM `sc` where city='Canadys' && SIC_code='7219'DB:business_master_new
loadtime:0.12637686729431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlisle' limit 1
loadtime:0.12645578384399 / seconds
Query Executed:select id FROM `sc` where city='Carlisle' && SIC_code='7219'DB:business_master_new
loadtime:0.12715983390808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cassatt' limit 1
loadtime:0.12721085548401 / seconds
Query Executed:select id FROM `sc` where city='Cassatt' && SIC_code='7219'DB:business_master_new
loadtime:0.12772297859192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catawba' limit 1
loadtime:0.12776684761047 / seconds
Query Executed:select id FROM `sc` where city='Catawba' && SIC_code='7219'DB:business_master_new
loadtime:0.12828183174133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cayce' limit 1
loadtime:0.12833690643311 / seconds
Query Executed:select id FROM `sc` where city='Cayce' && SIC_code='7219'DB:business_master_new
loadtime:0.12879395484924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centenary' limit 1
loadtime:0.12882900238037 / seconds
Query Executed:select id FROM `sc` where city='Centenary' && SIC_code='7219'DB:business_master_new
loadtime:0.12912487983704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central' limit 1
loadtime:0.1291708946228 / seconds
Query Executed:select id FROM `sc` where city='Central' && SIC_code='7219'DB:business_master_new
loadtime:0.12998294830322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chapin' limit 1
loadtime:0.13007879257202 / seconds
Query Executed:select id FROM `sc` where city='Chapin' && SIC_code='7219'DB:business_master_new
loadtime:0.13090395927429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chappells' limit 1
loadtime:0.13097381591797 / seconds
Query Executed:select id FROM `sc` where city='Chappells' && SIC_code='7219'DB:business_master_new
loadtime:0.13153290748596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charleston' limit 1
loadtime:0.1315758228302 / seconds
Query Executed:select id FROM `sc` where city='Charleston' && SIC_code='7219'DB:business_master_new
loadtime:0.13212585449219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charleston Afb' limit 1
loadtime:0.13216400146484 / seconds
Query Executed:select id FROM `sc` where city='Charleston Afb' && SIC_code='7219'DB:business_master_new
loadtime:0.13266181945801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheraw' limit 1
loadtime:0.13270497322083 / seconds
Query Executed:select id FROM `sc` where city='Cheraw' && SIC_code='7219'DB:business_master_new
loadtime:0.13322496414185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Grove Bch' limit 1
loadtime:0.13327288627625 / seconds
Query Executed:select id FROM `sc` where city='Cherry Grove Bch' && SIC_code='7219'DB:business_master_new
loadtime:0.1335608959198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesnee' limit 1
loadtime:0.13363790512085 / seconds
Query Executed:select id FROM `sc` where city='Chesnee' && SIC_code='7219'DB:business_master_new
loadtime:0.13431286811829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.13441181182861 / seconds
Query Executed:select id FROM `sc` where city='Chester' && SIC_code='7219'DB:business_master_new
loadtime:0.13511896133423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:0.13516092300415 / seconds
Query Executed:select id FROM `sc` where city='Chesterfield' && SIC_code='7219'DB:business_master_new
loadtime:0.13577079772949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarks Hill' limit 1
loadtime:0.13580083847046 / seconds
Query Executed:select id FROM `sc` where city='Clarks Hill' && SIC_code='7219'DB:business_master_new
loadtime:0.13629579544067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clearwater' limit 1
loadtime:0.13633394241333 / seconds
Query Executed:select id FROM `sc` where city='Clearwater' && SIC_code='7219'DB:business_master_new
loadtime:0.13681387901306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clemson' limit 1
loadtime:0.13684988021851 / seconds
Query Executed:select id FROM `sc` where city='Clemson' && SIC_code='7219'DB:business_master_new
loadtime:0.13735795021057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.13740396499634 / seconds
Query Executed:select id FROM `sc` where city='Cleveland' && SIC_code='7219'DB:business_master_new
loadtime:0.13819289207458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:0.13824987411499 / seconds
Query Executed:select id FROM `sc` where city='Clifton' && SIC_code='7219'DB:business_master_new
loadtime:0.13870596885681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.13877391815186 / seconds
Query Executed:select id FROM `sc` where city='Clinton' && SIC_code='7219'DB:business_master_new
loadtime:0.13937592506409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clio' limit 1
loadtime:0.13942790031433 / seconds
Query Executed:select id FROM `sc` where city='Clio' && SIC_code='7219'DB:business_master_new
loadtime:0.13990378379822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clover' limit 1
loadtime:0.13995885848999 / seconds
Query Executed:select id FROM `sc` where city='Clover' && SIC_code='7219'DB:business_master_new
loadtime:0.14041495323181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.14046192169189 / seconds
Query Executed:select id FROM `sc` where city='Columbia' && SIC_code='7219'DB:business_master_new
loadtime:0.14094090461731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conestee' limit 1
loadtime:0.14098882675171 / seconds
Query Executed:select id FROM `sc` where city='Conestee' && SIC_code='7219'DB:business_master_new
loadtime:0.14131999015808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Converse' limit 1
loadtime:0.14137482643127 / seconds
Query Executed:select id FROM `sc` where city='Converse' && SIC_code='7219'DB:business_master_new
loadtime:0.14172196388245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.14177584648132 / seconds
Query Executed:select id FROM `sc` where city='Conway' && SIC_code='7219'DB:business_master_new
loadtime:0.14226484298706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coosawatchie' limit 1
loadtime:0.14231085777283 / seconds
Query Executed:select id FROM `sc` where city='Coosawatchie' && SIC_code='7219'DB:business_master_new
loadtime:0.14274501800537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cope' limit 1
loadtime:0.14280986785889 / seconds
Query Executed:select id FROM `sc` where city='Cope' && SIC_code='7219'DB:business_master_new
loadtime:0.14346480369568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cordesville' limit 1
loadtime:0.14349389076233 / seconds
Query Executed:select id FROM `sc` where city='Cordesville' && SIC_code='7219'DB:business_master_new
loadtime:0.14410281181335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cordova' limit 1
loadtime:0.1441478729248 / seconds
Query Executed:select id FROM `sc` where city='Cordova' && SIC_code='7219'DB:business_master_new
loadtime:0.14467883110046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottageville' limit 1
loadtime:0.14471578598022 / seconds
Query Executed:select id FROM `sc` where city='Cottageville' && SIC_code='7219'DB:business_master_new
loadtime:0.14519786834717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coward' limit 1
loadtime:0.14523196220398 / seconds
Query Executed:select id FROM `sc` where city='Coward' && SIC_code='7219'DB:business_master_new
loadtime:0.14566588401794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cowpens' limit 1
loadtime:0.14570689201355 / seconds
Query Executed:select id FROM `sc` where city='Cowpens' && SIC_code='7219'DB:business_master_new
loadtime:0.14616680145264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crocketville' limit 1
loadtime:0.14620089530945 / seconds
Query Executed:select id FROM `sc` where city='Crocketville' && SIC_code='7219'DB:business_master_new
loadtime:0.14645290374756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross' limit 1
loadtime:0.14649200439453 / seconds
Query Executed:select id FROM `sc` where city='Cross' && SIC_code='7219'DB:business_master_new
loadtime:0.14694380760193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross Anchor' limit 1
loadtime:0.14698481559753 / seconds
Query Executed:select id FROM `sc` where city='Cross Anchor' && SIC_code='7219'DB:business_master_new
loadtime:0.14726090431213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross Hill' limit 1
loadtime:0.14728999137878 / seconds
Query Executed:select id FROM `sc` where city='Cross Hill' && SIC_code='7219'DB:business_master_new
loadtime:0.14773178100586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dale' limit 1
loadtime:0.1477689743042 / seconds
Query Executed:select id FROM `sc` where city='Dale' && SIC_code='7219'DB:business_master_new
loadtime:0.14804887771606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dalzell' limit 1
loadtime:0.1480770111084 / seconds
Query Executed:select id FROM `sc` where city='Dalzell' && SIC_code='7219'DB:business_master_new
loadtime:0.14851880073547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daniel Island' limit 1
loadtime:0.14856100082397 / seconds
Query Executed:select id FROM `sc` where city='Daniel Island' && SIC_code='7219'DB:business_master_new
loadtime:0.1488139629364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darlington' limit 1
loadtime:0.14885497093201 / seconds
Query Executed:select id FROM `sc` where city='Darlington' && SIC_code='7219'DB:business_master_new
loadtime:0.14935684204102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daufuskie Island' limit 1
loadtime:0.14940690994263 / seconds
Query Executed:select id FROM `sc` where city='Daufuskie Island' && SIC_code='7219'DB:business_master_new
loadtime:0.14980292320251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis Station' limit 1
loadtime:0.14984083175659 / seconds
Query Executed:select id FROM `sc` where city='Davis Station' && SIC_code='7219'DB:business_master_new
loadtime:0.15020298957825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denmark' limit 1
loadtime:0.15023493766785 / seconds
Query Executed:select id FROM `sc` where city='Denmark' && SIC_code='7219'DB:business_master_new
loadtime:0.15068888664246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewees Island' limit 1
loadtime:0.15073180198669 / seconds
Query Executed:select id FROM `sc` where city='Dewees Island' && SIC_code='7219'DB:business_master_new
loadtime:0.15100979804993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dillon' limit 1
loadtime:0.15105080604553 / seconds
Query Executed:select id FROM `sc` where city='Dillon' && SIC_code='7219'DB:business_master_new
loadtime:0.15151286125183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Donalds' limit 1
loadtime:0.1515429019928 / seconds
Query Executed:select id FROM `sc` where city='Donalds' && SIC_code='7219'DB:business_master_new
loadtime:0.15201282501221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:0.15205693244934 / seconds
Query Executed:select id FROM `sc` where city='Dorchester' && SIC_code='7219'DB:business_master_new
loadtime:0.15250587463379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drayton' limit 1
loadtime:0.15253591537476 / seconds
Query Executed:select id FROM `sc` where city='Drayton' && SIC_code='7219'DB:business_master_new
loadtime:0.15299487113953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Due West' limit 1
loadtime:0.15303683280945 / seconds
Query Executed:select id FROM `sc` where city='Due West' && SIC_code='7219'DB:business_master_new
loadtime:0.15348887443542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duncan' limit 1
loadtime:0.15351891517639 / seconds
Query Executed:select id FROM `sc` where city='Duncan' && SIC_code='7219'DB:business_master_new
loadtime:0.15398001670837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Early Branch' limit 1
loadtime:0.15403699874878 / seconds
Query Executed:select id FROM `sc` where city='Early Branch' && SIC_code='7219'DB:business_master_new
loadtime:0.1545078754425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easley' limit 1
loadtime:0.15454697608948 / seconds
Query Executed:select id FROM `sc` where city='Easley' && SIC_code='7219'DB:business_master_new
loadtime:0.15515184402466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastover' limit 1
loadtime:0.1552038192749 / seconds
Query Executed:select id FROM `sc` where city='Eastover' && SIC_code='7219'DB:business_master_new
loadtime:0.15575098991394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgefield' limit 1
loadtime:0.15580892562866 / seconds
Query Executed:select id FROM `sc` where city='Edgefield' && SIC_code='7219'DB:business_master_new
loadtime:0.15631794929504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgemoor' limit 1
loadtime:0.1563618183136 / seconds
Query Executed:select id FROM `sc` where city='Edgemoor' && SIC_code='7219'DB:business_master_new
loadtime:0.15684199333191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edisto Island' limit 1
loadtime:0.15690183639526 / seconds
Query Executed:select id FROM `sc` where city='Edisto Island' && SIC_code='7219'DB:business_master_new
loadtime:0.15738487243652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Effingham' limit 1
loadtime:0.15741491317749 / seconds
Query Executed:select id FROM `sc` where city='Effingham' && SIC_code='7219'DB:business_master_new
loadtime:0.15791988372803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ehrhardt' limit 1
loadtime:0.15796279907227 / seconds
Query Executed:select id FROM `sc` where city='Ehrhardt' && SIC_code='7219'DB:business_master_new
loadtime:0.15845680236816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elgin' limit 1
loadtime:0.1584939956665 / seconds
Query Executed:select id FROM `sc` where city='Elgin' && SIC_code='7219'DB:business_master_new
loadtime:0.15912580490112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elko' limit 1
loadtime:0.15921092033386 / seconds
Query Executed:select id FROM `sc` where city='Elko' && SIC_code='7219'DB:business_master_new
loadtime:0.15978693962097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elliott' limit 1
loadtime:0.15982294082642 / seconds
Query Executed:select id FROM `sc` where city='Elliott' && SIC_code='7219'DB:business_master_new
loadtime:0.16018199920654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elloree' limit 1
loadtime:0.16024088859558 / seconds
Query Executed:select id FROM `sc` where city='Elloree' && SIC_code='7219'DB:business_master_new
loadtime:0.16079783439636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enoree' limit 1
loadtime:0.16086578369141 / seconds
Query Executed:select id FROM `sc` where city='Enoree' && SIC_code='7219'DB:business_master_new
loadtime:0.16158199310303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estill' limit 1
loadtime:0.16163682937622 / seconds
Query Executed:select id FROM `sc` where city='Estill' && SIC_code='7219'DB:business_master_new
loadtime:0.16215896606445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eutawville' limit 1
loadtime:0.16220092773438 / seconds
Query Executed:select id FROM `sc` where city='Eutawville' && SIC_code='7219'DB:business_master_new
loadtime:0.16269779205322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Play' limit 1
loadtime:0.16272783279419 / seconds
Query Executed:select id FROM `sc` where city='Fair Play' && SIC_code='7219'DB:business_master_new
loadtime:0.16321301460266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.16325378417969 / seconds
Query Executed:select id FROM `sc` where city='Fairfax' && SIC_code='7219'DB:business_master_new
loadtime:0.16374778747559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairforest' limit 1
loadtime:0.16378784179688 / seconds
Query Executed:select id FROM `sc` where city='Fairforest' && SIC_code='7219'DB:business_master_new
loadtime:0.1643168926239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fingerville' limit 1
loadtime:0.16434693336487 / seconds
Query Executed:select id FROM `sc` where city='Fingerville' && SIC_code='7219'DB:business_master_new
loadtime:0.1646249294281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.16466784477234 / seconds
Query Executed:select id FROM `sc` where city='Florence' && SIC_code='7219'DB:business_master_new
loadtime:0.16522479057312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Folly Beach' limit 1
loadtime:0.16526484489441 / seconds
Query Executed:select id FROM `sc` where city='Folly Beach' && SIC_code='7219'DB:business_master_new
loadtime:0.1657509803772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fork' limit 1
loadtime:0.16578388214111 / seconds
Query Executed:select id FROM `sc` where city='Fork' && SIC_code='7219'DB:business_master_new
loadtime:0.16618394851685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Lawn' limit 1
loadtime:0.16622591018677 / seconds
Query Executed:select id FROM `sc` where city='Fort Lawn' && SIC_code='7219'DB:business_master_new
loadtime:0.16669297218323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mill' limit 1
loadtime:0.16674494743347 / seconds
Query Executed:select id FROM `sc` where city='Fort Mill' && SIC_code='7219'DB:business_master_new
loadtime:0.1672568321228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Motte' limit 1
loadtime:0.16728782653809 / seconds
Query Executed:select id FROM `sc` where city='Fort Motte' && SIC_code='7219'DB:business_master_new
loadtime:0.16757988929749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain Inn' limit 1
loadtime:0.16762089729309 / seconds
Query Executed:select id FROM `sc` where city='Fountain Inn' && SIC_code='7219'DB:business_master_new
loadtime:0.16832184791565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frogmore' limit 1
loadtime:0.16837096214294 / seconds
Query Executed:select id FROM `sc` where city='Frogmore' && SIC_code='7219'DB:business_master_new
loadtime:0.16871285438538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Furman' limit 1
loadtime:0.16875195503235 / seconds
Query Executed:select id FROM `sc` where city='Furman' && SIC_code='7219'DB:business_master_new
loadtime:0.16944885253906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gable' limit 1
loadtime:0.16952800750732 / seconds
Query Executed:select id FROM `sc` where city='Gable' && SIC_code='7219'DB:business_master_new
loadtime:0.17031383514404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gadsden' limit 1
loadtime:0.17037892341614 / seconds
Query Executed:select id FROM `sc` where city='Gadsden' && SIC_code='7219'DB:business_master_new
loadtime:0.17110180854797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaffney' limit 1
loadtime:0.17117595672607 / seconds
Query Executed:select id FROM `sc` where city='Gaffney' && SIC_code='7219'DB:business_master_new
loadtime:0.17165780067444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galivants Ferry' limit 1
loadtime:0.17170000076294 / seconds
Query Executed:select id FROM `sc` where city='Galivants Ferry' && SIC_code='7219'DB:business_master_new
loadtime:0.1723268032074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garnett' limit 1
loadtime:0.17237091064453 / seconds
Query Executed:select id FROM `sc` where city='Garnett' && SIC_code='7219'DB:business_master_new
loadtime:0.17299580574036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaston' limit 1
loadtime:0.17303991317749 / seconds
Query Executed:select id FROM `sc` where city='Gaston' && SIC_code='7219'DB:business_master_new
loadtime:0.17353200912476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:0.173583984375 / seconds
Query Executed:select id FROM `sc` where city='Georgetown' && SIC_code='7219'DB:business_master_new
loadtime:0.17405796051025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gifford' limit 1
loadtime:0.17410087585449 / seconds
Query Executed:select id FROM `sc` where city='Gifford' && SIC_code='7219'DB:business_master_new
loadtime:0.17442798614502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbert' limit 1
loadtime:0.17446899414062 / seconds
Query Executed:select id FROM `sc` where city='Gilbert' && SIC_code='7219'DB:business_master_new
loadtime:0.17502379417419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1
loadtime:0.17507100105286 / seconds
Query Executed:select id FROM `sc` where city='Glendale' && SIC_code='7219'DB:business_master_new
loadtime:0.17541193962097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenn Springs' limit 1
loadtime:0.17546892166138 / seconds
Query Executed:select id FROM `sc` where city='Glenn Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.1758508682251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloverville' limit 1
loadtime:0.17591381072998 / seconds
Query Executed:select id FROM `sc` where city='Gloverville' && SIC_code='7219'DB:business_master_new
loadtime:0.17664694786072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goose Creek' limit 1
loadtime:0.17667388916016 / seconds
Query Executed:select id FROM `sc` where city='Goose Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.17748689651489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gramling' limit 1
loadtime:0.1775758266449 / seconds
Query Executed:select id FROM `sc` where city='Gramling' && SIC_code='7219'DB:business_master_new
loadtime:0.17812490463257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graniteville' limit 1
loadtime:0.17818093299866 / seconds
Query Executed:select id FROM `sc` where city='Graniteville' && SIC_code='7219'DB:business_master_new
loadtime:0.17873191833496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gray Court' limit 1
loadtime:0.17877578735352 / seconds
Query Executed:select id FROM `sc` where city='Gray Court' && SIC_code='7219'DB:business_master_new
loadtime:0.17945885658264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Falls' limit 1
loadtime:0.17951083183289 / seconds
Query Executed:select id FROM `sc` where city='Great Falls' && SIC_code='7219'DB:business_master_new
loadtime:0.18007683753967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greeleyville' limit 1
loadtime:0.18012094497681 / seconds
Query Executed:select id FROM `sc` where city='Greeleyville' && SIC_code='7219'DB:business_master_new
loadtime:0.18058085441589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Pond' limit 1
loadtime:0.18061995506287 / seconds
Query Executed:select id FROM `sc` where city='Green Pond' && SIC_code='7219'DB:business_master_new
loadtime:0.18129801750183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Sea' limit 1
loadtime:0.18134498596191 / seconds
Query Executed:select id FROM `sc` where city='Green Sea' && SIC_code='7219'DB:business_master_new
loadtime:0.18196201324463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.18201994895935 / seconds
Query Executed:select id FROM `sc` where city='Greenville' && SIC_code='7219'DB:business_master_new
loadtime:0.18269801139832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood' limit 1
loadtime:0.18278479576111 / seconds
Query Executed:select id FROM `sc` where city='Greenwood' && SIC_code='7219'DB:business_master_new
loadtime:0.18339395523071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greer' limit 1
loadtime:0.18343901634216 / seconds
Query Executed:select id FROM `sc` where city='Greer' && SIC_code='7219'DB:business_master_new
loadtime:0.1841127872467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gresham' limit 1
loadtime:0.18415880203247 / seconds
Query Executed:select id FROM `sc` where city='Gresham' && SIC_code='7219'DB:business_master_new
loadtime:0.18482184410095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grover' limit 1
loadtime:0.18484878540039 / seconds
Query Executed:select id FROM `sc` where city='Grover' && SIC_code='7219'DB:business_master_new
loadtime:0.18520593643188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamer' limit 1
loadtime:0.18527793884277 / seconds
Query Executed:select id FROM `sc` where city='Hamer' && SIC_code='7219'DB:business_master_new
loadtime:0.18578100204468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:0.18584585189819 / seconds
Query Executed:select id FROM `sc` where city='Hampton' && SIC_code='7219'DB:business_master_new
loadtime:0.18651795387268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanahan' limit 1
loadtime:0.18655586242676 / seconds
Query Executed:select id FROM `sc` where city='Hanahan' && SIC_code='7219'DB:business_master_new
loadtime:0.1870288848877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardeeville' limit 1
loadtime:0.1870858669281 / seconds
Query Executed:select id FROM `sc` where city='Hardeeville' && SIC_code='7219'DB:business_master_new
loadtime:0.187579870224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harleyville' limit 1
loadtime:0.18765997886658 / seconds
Query Executed:select id FROM `sc` where city='Harleyville' && SIC_code='7219'DB:business_master_new
loadtime:0.18828797340393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartsville' limit 1
loadtime:0.188316822052 / seconds
Query Executed:select id FROM `sc` where city='Hartsville' && SIC_code='7219'DB:business_master_new
loadtime:0.18918299674988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heath Springs' limit 1
loadtime:0.18929696083069 / seconds
Query Executed:select id FROM `sc` where city='Heath Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.18998980522156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hemingway' limit 1
loadtime:0.19008088111877 / seconds
Query Executed:select id FROM `sc` where city='Hemingway' && SIC_code='7219'DB:business_master_new
loadtime:0.19088697433472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hickory Grove' limit 1
loadtime:0.19093084335327 / seconds
Query Executed:select id FROM `sc` where city='Hickory Grove' && SIC_code='7219'DB:business_master_new
loadtime:0.19145488739014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hilda' limit 1
loadtime:0.19150185585022 / seconds
Query Executed:select id FROM `sc` where city='Hilda' && SIC_code='7219'DB:business_master_new
loadtime:0.19182991981506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hilton Head Island' limit 1
loadtime:0.19188189506531 / seconds
Query Executed:select id FROM `sc` where city='Hilton Head Island' && SIC_code='7219'DB:business_master_new
loadtime:0.1923828125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hilton Head Isle' limit 1
loadtime:0.19243288040161 / seconds
Query Executed:select id FROM `sc` where city='Hilton Head Isle' && SIC_code='7219'DB:business_master_new
loadtime:0.19293785095215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hodges' limit 1
loadtime:0.1929829120636 / seconds
Query Executed:select id FROM `sc` where city='Hodges' && SIC_code='7219'DB:business_master_new
loadtime:0.19371700286865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Hill' limit 1
loadtime:0.19376993179321 / seconds
Query Executed:select id FROM `sc` where city='Holly Hill' && SIC_code='7219'DB:business_master_new
loadtime:0.19459891319275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollywood' limit 1
loadtime:0.19464087486267 / seconds
Query Executed:select id FROM `sc` where city='Hollywood' && SIC_code='7219'DB:business_master_new
loadtime:0.19517183303833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honea Path' limit 1
loadtime:0.1952109336853 / seconds
Query Executed:select id FROM `sc` where city='Honea Path' && SIC_code='7219'DB:business_master_new
loadtime:0.19567489624023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkins' limit 1
loadtime:0.19571185112 / seconds
Query Executed:select id FROM `sc` where city='Hopkins' && SIC_code='7219'DB:business_master_new
loadtime:0.19620990753174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horatio' limit 1
loadtime:0.1962559223175 / seconds
Query Executed:select id FROM `sc` where city='Horatio' && SIC_code='7219'DB:business_master_new
loadtime:0.19658088684082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huger' limit 1
loadtime:0.19662284851074 / seconds
Query Executed:select id FROM `sc` where city='Huger' && SIC_code='7219'DB:business_master_new
loadtime:0.19731283187866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Inman' limit 1
loadtime:0.19735097885132 / seconds
Query Executed:select id FROM `sc` where city='Inman' && SIC_code='7219'DB:business_master_new
loadtime:0.19783186912537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irmo' limit 1
loadtime:0.19792795181274 / seconds
Query Executed:select id FROM `sc` where city='Irmo' && SIC_code='7219'DB:business_master_new
loadtime:0.1985068321228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Islandton' limit 1
loadtime:0.19853687286377 / seconds
Query Executed:select id FROM `sc` where city='Islandton' && SIC_code='7219'DB:business_master_new
loadtime:0.19902396202087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isle Of Palms' limit 1
loadtime:0.19906687736511 / seconds
Query Executed:select id FROM `sc` where city='Isle Of Palms' && SIC_code='7219'DB:business_master_new
loadtime:0.19953799247742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iva' limit 1
loadtime:0.19959282875061 / seconds
Query Executed:select id FROM `sc` where city='Iva' && SIC_code='7219'DB:business_master_new
loadtime:0.20020079612732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:0.20024180412292 / seconds
Query Executed:select id FROM `sc` where city='Jackson' && SIC_code='7219'DB:business_master_new
loadtime:0.20071983337402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jacksonboro' limit 1
loadtime:0.200767993927 / seconds
Query Executed:select id FROM `sc` where city='Jacksonboro' && SIC_code='7219'DB:business_master_new
loadtime:0.20122599601746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:0.20128083229065 / seconds
Query Executed:select id FROM `sc` where city='Jamestown' && SIC_code='7219'DB:business_master_new
loadtime:0.20175385475159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:0.20182681083679 / seconds
Query Executed:select id FROM `sc` where city='Jefferson' && SIC_code='7219'DB:business_master_new
loadtime:0.20261788368225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jenkinsville' limit 1
loadtime:0.2026698589325 / seconds
Query Executed:select id FROM `sc` where city='Jenkinsville' && SIC_code='7219'DB:business_master_new
loadtime:0.2031888961792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joanna' limit 1
loadtime:0.20324087142944 / seconds
Query Executed:select id FROM `sc` where city='Joanna' && SIC_code='7219'DB:business_master_new
loadtime:0.20367479324341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johns Island' limit 1
loadtime:0.20370984077454 / seconds
Query Executed:select id FROM `sc` where city='Johns Island' && SIC_code='7219'DB:business_master_new
loadtime:0.20419478416443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnsonville' limit 1
loadtime:0.20423483848572 / seconds
Query Executed:select id FROM `sc` where city='Johnsonville' && SIC_code='7219'DB:business_master_new
loadtime:0.20470190048218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnston' limit 1
loadtime:0.20473289489746 / seconds
Query Executed:select id FROM `sc` where city='Johnston' && SIC_code='7219'DB:business_master_new
loadtime:0.2052059173584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:0.20525193214417 / seconds
Query Executed:select id FROM `sc` where city='Jonesville' && SIC_code='7219'DB:business_master_new
loadtime:0.20569682121277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kershaw' limit 1
loadtime:0.20573592185974 / seconds
Query Executed:select id FROM `sc` where city='Kershaw' && SIC_code='7219'DB:business_master_new
loadtime:0.20621395111084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kiawah Island' limit 1
loadtime:0.20624780654907 / seconds
Query Executed:select id FROM `sc` where city='Kiawah Island' && SIC_code='7219'DB:business_master_new
loadtime:0.20666885375977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinards' limit 1
loadtime:0.20674085617065 / seconds
Query Executed:select id FROM `sc` where city='Kinards' && SIC_code='7219'DB:business_master_new
loadtime:0.20753979682922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kings Creek' limit 1
loadtime:0.20759081840515 / seconds
Query Executed:select id FROM `sc` where city='Kings Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.20791697502136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingstree' limit 1
loadtime:0.20796799659729 / seconds
Query Executed:select id FROM `sc` where city='Kingstree' && SIC_code='7219'DB:business_master_new
loadtime:0.20859789848328 / seconds
Query loaded from cache:select * from geodata_geocity where city='La France' limit 1
loadtime:0.20865178108215 / seconds
Query Executed:select id FROM `sc` where city='La France' && SIC_code='7219'DB:business_master_new
loadtime:0.20906281471252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ladson' limit 1
loadtime:0.20910382270813 / seconds
Query Executed:select id FROM `sc` where city='Ladson' && SIC_code='7219'DB:business_master_new
loadtime:0.20965194702148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ladys Island' limit 1
loadtime:0.20968294143677 / seconds
Query Executed:select id FROM `sc` where city='Ladys Island' && SIC_code='7219'DB:business_master_new
loadtime:0.20997881889343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake City' limit 1
loadtime:0.21001887321472 / seconds
Query Executed:select id FROM `sc` where city='Lake City' && SIC_code='7219'DB:business_master_new
loadtime:0.21051096916199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake View' limit 1
loadtime:0.21054983139038 / seconds
Query Executed:select id FROM `sc` where city='Lake View' && SIC_code='7219'DB:business_master_new
loadtime:0.21102380752563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Wylie' limit 1
loadtime:0.21107292175293 / seconds
Query Executed:select id FROM `sc` where city='Lake Wylie' && SIC_code='7219'DB:business_master_new
loadtime:0.2115478515625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamar' limit 1
loadtime:0.21158599853516 / seconds
Query Executed:select id FROM `sc` where city='Lamar' && SIC_code='7219'DB:business_master_new
loadtime:0.21204900741577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:0.21209096908569 / seconds
Query Executed:select id FROM `sc` where city='Lancaster' && SIC_code='7219'DB:business_master_new
loadtime:0.21270084381104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lando' limit 1
loadtime:0.21273994445801 / seconds
Query Executed:select id FROM `sc` where city='Lando' && SIC_code='7219'DB:business_master_new
loadtime:0.21315884590149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Landrum' limit 1
loadtime:0.21320390701294 / seconds
Query Executed:select id FROM `sc` where city='Landrum' && SIC_code='7219'DB:business_master_new
loadtime:0.21378684043884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lane' limit 1
loadtime:0.21382689476013 / seconds
Query Executed:select id FROM `sc` where city='Lane' && SIC_code='7219'DB:business_master_new
loadtime:0.21442079544067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langley' limit 1
loadtime:0.21447992324829 / seconds
Query Executed:select id FROM `sc` where city='Langley' && SIC_code='7219'DB:business_master_new
loadtime:0.21496796607971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Latta' limit 1
loadtime:0.21500992774963 / seconds
Query Executed:select id FROM `sc` where city='Latta' && SIC_code='7219'DB:business_master_new
loadtime:0.21548581123352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurens' limit 1
loadtime:0.21551895141602 / seconds
Query Executed:select id FROM `sc` where city='Laurens' && SIC_code='7219'DB:business_master_new
loadtime:0.2160120010376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leesville' limit 1
loadtime:0.21605181694031 / seconds
Query Executed:select id FROM `sc` where city='Leesville' && SIC_code='7219'DB:business_master_new
loadtime:0.21650099754333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:0.21653890609741 / seconds
Query Executed:select id FROM `sc` where city='Lexington' && SIC_code='7219'DB:business_master_new
loadtime:0.21700882911682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty' limit 1
loadtime:0.21705794334412 / seconds
Query Executed:select id FROM `sc` where city='Liberty' && SIC_code='7219'DB:business_master_new
loadtime:0.21750783920288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty Hill' limit 1
loadtime:0.21754288673401 / seconds
Query Executed:select id FROM `sc` where city='Liberty Hill' && SIC_code='7219'DB:business_master_new
loadtime:0.21787691116333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincolnville' limit 1
loadtime:0.21793293952942 / seconds
Query Executed:select id FROM `sc` where city='Lincolnville' && SIC_code='7219'DB:business_master_new
loadtime:0.21818494796753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Mountain' limit 1
loadtime:0.21822500228882 / seconds
Query Executed:select id FROM `sc` where city='Little Mountain' && SIC_code='7219'DB:business_master_new
loadtime:0.21867895126343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little River' limit 1
loadtime:0.21871495246887 / seconds
Query Executed:select id FROM `sc` where city='Little River' && SIC_code='7219'DB:business_master_new
loadtime:0.21917295455933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Rock' limit 1
loadtime:0.21922087669373 / seconds
Query Executed:select id FROM `sc` where city='Little Rock' && SIC_code='7219'DB:business_master_new
loadtime:0.2196159362793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Livingston' limit 1
loadtime:0.21965289115906 / seconds
Query Executed:select id FROM `sc` where city='Livingston' && SIC_code='7219'DB:business_master_new
loadtime:0.21995997428894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lobeco' limit 1
loadtime:0.21999597549438 / seconds
Query Executed:select id FROM `sc` where city='Lobeco' && SIC_code='7219'DB:business_master_new
loadtime:0.22038197517395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lockhart' limit 1
loadtime:0.22042298316956 / seconds
Query Executed:select id FROM `sc` where city='Lockhart' && SIC_code='7219'DB:business_master_new
loadtime:0.22088885307312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lodge' limit 1
loadtime:0.22096085548401 / seconds
Query Executed:select id FROM `sc` where city='Lodge' && SIC_code='7219'DB:business_master_new
loadtime:0.22164487838745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lone Star' limit 1
loadtime:0.22167992591858 / seconds
Query Executed:select id FROM `sc` where city='Lone Star' && SIC_code='7219'DB:business_master_new
loadtime:0.22202491760254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Creek' limit 1
loadtime:0.22205281257629 / seconds
Query Executed:select id FROM `sc` where city='Long Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.2224748134613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longs' limit 1
loadtime:0.22251296043396 / seconds
Query Executed:select id FROM `sc` where city='Longs' && SIC_code='7219'DB:business_master_new
loadtime:0.22312688827515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loris' limit 1
loadtime:0.2231547832489 / seconds
Query Executed:select id FROM `sc` where city='Loris' && SIC_code='7219'DB:business_master_new
loadtime:0.22380495071411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowndesville' limit 1
loadtime:0.22387790679932 / seconds
Query Executed:select id FROM `sc` where city='Lowndesville' && SIC_code='7219'DB:business_master_new
loadtime:0.22439193725586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lugoff' limit 1
loadtime:0.22443294525146 / seconds
Query Executed:select id FROM `sc` where city='Lugoff' && SIC_code='7219'DB:business_master_new
loadtime:0.22492098808289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luray' limit 1
loadtime:0.22499585151672 / seconds
Query Executed:select id FROM `sc` where city='Luray' && SIC_code='7219'DB:business_master_new
loadtime:0.22543787956238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lydia' limit 1
loadtime:0.22549295425415 / seconds
Query Executed:select id FROM `sc` where city='Lydia' && SIC_code='7219'DB:business_master_new
loadtime:0.22598600387573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyman' limit 1
loadtime:0.22605800628662 / seconds
Query Executed:select id FROM `sc` where city='Lyman' && SIC_code='7219'DB:business_master_new
loadtime:0.2265419960022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynchburg' limit 1
loadtime:0.22661900520325 / seconds
Query Executed:select id FROM `sc` where city='Lynchburg' && SIC_code='7219'DB:business_master_new
loadtime:0.22728300094604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manning' limit 1
loadtime:0.22733783721924 / seconds
Query Executed:select id FROM `sc` where city='Manning' && SIC_code='7219'DB:business_master_new
loadtime:0.22779679298401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marietta' limit 1
loadtime:0.22783899307251 / seconds
Query Executed:select id FROM `sc` where city='Marietta' && SIC_code='7219'DB:business_master_new
loadtime:0.22832679748535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.22838187217712 / seconds
Query Executed:select id FROM `sc` where city='Marion' && SIC_code='7219'DB:business_master_new
loadtime:0.22892880439758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martin' limit 1
loadtime:0.22896480560303 / seconds
Query Executed:select id FROM `sc` where city='Martin' && SIC_code='7219'DB:business_master_new
loadtime:0.22940587997437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mauldin' limit 1
loadtime:0.2294499874115 / seconds
Query Executed:select id FROM `sc` where city='Mauldin' && SIC_code='7219'DB:business_master_new
loadtime:0.2299280166626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayesville' limit 1
loadtime:0.22995781898499 / seconds
Query Executed:select id FROM `sc` where city='Mayesville' && SIC_code='7219'DB:business_master_new
loadtime:0.23039889335632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayo' limit 1
loadtime:0.23043990135193 / seconds
Query Executed:select id FROM `sc` where city='Mayo' && SIC_code='7219'DB:business_master_new
loadtime:0.23089790344238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Bee' limit 1
loadtime:0.23092699050903 / seconds
Query Executed:select id FROM `sc` where city='Mc Bee' && SIC_code='7219'DB:business_master_new
loadtime:0.23138689994812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Clellanville' limit 1
loadtime:0.23143196105957 / seconds
Query Executed:select id FROM `sc` where city='Mc Clellanville' && SIC_code='7219'DB:business_master_new
loadtime:0.23194885253906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Coll' limit 1
loadtime:0.23198390007019 / seconds
Query Executed:select id FROM `sc` where city='Mc Coll' && SIC_code='7219'DB:business_master_new
loadtime:0.23249697685242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Connells' limit 1
loadtime:0.23254990577698 / seconds
Query Executed:select id FROM `sc` where city='Mc Connells' && SIC_code='7219'DB:business_master_new
loadtime:0.23306488990784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Cormick' limit 1
loadtime:0.23310494422913 / seconds
Query Executed:select id FROM `sc` where city='Mc Cormick' && SIC_code='7219'DB:business_master_new
loadtime:0.2338559627533 / seconds
Query Executed:select * from geodata_geocity where city='Mccormick' limit 1DB:business_master_new
loadtime:0.23440194129944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meggett' limit 1
loadtime:0.23446297645569 / seconds
Query Executed:select id FROM `sc` where city='Meggett' && SIC_code='7219'DB:business_master_new
loadtime:0.23482894897461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miley' limit 1
loadtime:0.23489499092102 / seconds
Query Executed:select id FROM `sc` where city='Miley' && SIC_code='7219'DB:business_master_new
loadtime:0.23517894744873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minturn' limit 1
loadtime:0.2352089881897 / seconds
Query Executed:select id FROM `sc` where city='Minturn' && SIC_code='7219'DB:business_master_new
loadtime:0.23547601699829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modoc' limit 1
loadtime:0.23551988601685 / seconds
Query Executed:select id FROM `sc` where city='Modoc' && SIC_code='7219'DB:business_master_new
loadtime:0.23586392402649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moncks Corner' limit 1
loadtime:0.23590397834778 / seconds
Query Executed:select id FROM `sc` where city='Moncks Corner' && SIC_code='7219'DB:business_master_new
loadtime:0.23643398284912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monetta' limit 1
loadtime:0.23647284507751 / seconds
Query Executed:select id FROM `sc` where city='Monetta' && SIC_code='7219'DB:business_master_new
loadtime:0.23706579208374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:0.23713898658752 / seconds
Query Executed:select id FROM `sc` where city='Monticello' && SIC_code='7219'DB:business_master_new
loadtime:0.23755192756653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montmorenci' limit 1
loadtime:0.23757982254028 / seconds
Query Executed:select id FROM `sc` where city='Montmorenci' && SIC_code='7219'DB:business_master_new
loadtime:0.23792695999146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moore' limit 1
loadtime:0.23796987533569 / seconds
Query Executed:select id FROM `sc` where city='Moore' && SIC_code='7219'DB:business_master_new
loadtime:0.23852491378784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Carmel' limit 1
loadtime:0.2385778427124 / seconds
Query Executed:select id FROM `sc` where city='Mount Carmel' && SIC_code='7219'DB:business_master_new
loadtime:0.23889684677124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Croghan' limit 1
loadtime:0.23896598815918 / seconds
Query Executed:select id FROM `sc` where city='Mount Croghan' && SIC_code='7219'DB:business_master_new
loadtime:0.23949790000916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:0.23953294754028 / seconds
Query Executed:select id FROM `sc` where city='Mount Pleasant' && SIC_code='7219'DB:business_master_new
loadtime:0.2400529384613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain Rest' limit 1
loadtime:0.24009895324707 / seconds
Query Executed:select id FROM `sc` where city='Mountain Rest' && SIC_code='7219'DB:business_master_new
loadtime:0.24060583114624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountville' limit 1
loadtime:0.24063801765442 / seconds
Query Executed:select id FROM `sc` where city='Mountville' && SIC_code='7219'DB:business_master_new
loadtime:0.24110698699951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Carmel' limit 1
loadtime:0.24114489555359 / seconds
Query Executed:select id FROM `sc` where city='Mt Carmel' && SIC_code='7219'DB:business_master_new
loadtime:0.24142384529114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Croghan' limit 1
loadtime:0.24146389961243 / seconds
Query Executed:select id FROM `sc` where city='Mt Croghan' && SIC_code='7219'DB:business_master_new
loadtime:0.24175500869751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:0.24178385734558 / seconds
Query Executed:select id FROM `sc` where city='Mt Pleasant' && SIC_code='7219'DB:business_master_new
loadtime:0.24232196807861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mullins' limit 1
loadtime:0.24235987663269 / seconds
Query Executed:select id FROM `sc` where city='Mullins' && SIC_code='7219'DB:business_master_new
loadtime:0.2431309223175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murrells Inlet' limit 1
loadtime:0.24317383766174 / seconds
Query Executed:select id FROM `sc` where city='Murrells Inlet' && SIC_code='7219'DB:business_master_new
loadtime:0.24362301826477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Myrtle Beach' limit 1
loadtime:0.24365782737732 / seconds
Query Executed:select id FROM `sc` where city='Myrtle Beach' && SIC_code='7219'DB:business_master_new
loadtime:0.24413299560547 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Charleston' limit 1
loadtime:0.24418878555298 / seconds
Query Executed:select id FROM `sc` where city='N Charleston' && SIC_code='7219'DB:business_master_new
loadtime:0.24443578720093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neeses' limit 1
loadtime:0.2444748878479 / seconds
Query Executed:select id FROM `sc` where city='Neeses' && SIC_code='7219'DB:business_master_new
loadtime:0.24498796463013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nesmith' limit 1
loadtime:0.24501895904541 / seconds
Query Executed:select id FROM `sc` where city='Nesmith' && SIC_code='7219'DB:business_master_new
loadtime:0.24550294876099 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Ellenton' limit 1
loadtime:0.24554491043091 / seconds
Query Executed:select id FROM `sc` where city='New Ellenton' && SIC_code='7219'DB:business_master_new
loadtime:0.24604988098145 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Zion' limit 1
loadtime:0.24608182907104 / seconds
Query Executed:select id FROM `sc` where city='New Zion' && SIC_code='7219'DB:business_master_new
loadtime:0.24675893783569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newberry' limit 1
loadtime:0.24683785438538 / seconds
Query Executed:select id FROM `sc` where city='Newberry' && SIC_code='7219'DB:business_master_new
loadtime:0.24737286567688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newry' limit 1
loadtime:0.24740290641785 / seconds
Query Executed:select id FROM `sc` where city='Newry' && SIC_code='7219'DB:business_master_new
loadtime:0.24771881103516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nichols' limit 1
loadtime:0.24776291847229 / seconds
Query Executed:select id FROM `sc` where city='Nichols' && SIC_code='7219'DB:business_master_new
loadtime:0.24832797050476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ninety Six' limit 1
loadtime:0.24835801124573 / seconds
Query Executed:select id FROM `sc` where city='Ninety Six' && SIC_code='7219'DB:business_master_new
loadtime:0.24886083602905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norris' limit 1
loadtime:0.24896597862244 / seconds
Query Executed:select id FROM `sc` where city='Norris' && SIC_code='7219'DB:business_master_new
loadtime:0.24946093559265 / seconds
Query loaded from cache:select * from geodata_geocity where city='North' limit 1
loadtime:0.2495129108429 / seconds
Query Executed:select id FROM `sc` where city='North' && SIC_code='7219'DB:business_master_new
loadtime:0.25000095367432 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Augusta' limit 1
loadtime:0.25004601478577 / seconds
Query Executed:select id FROM `sc` where city='North Augusta' && SIC_code='7219'DB:business_master_new
loadtime:0.25052690505981 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Charleston' limit 1
loadtime:0.25057291984558 / seconds
Query Executed:select id FROM `sc` where city='North Charleston' && SIC_code='7219'DB:business_master_new
loadtime:0.25105500221252 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Myrtle Bch' limit 1
loadtime:0.25109696388245 / seconds
Query Executed:select id FROM `sc` where city='North Myrtle Bch' && SIC_code='7219'DB:business_master_new
loadtime:0.25155401229858 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Myrtle Beach' limit 1
loadtime:0.25159597396851 / seconds
Query Executed:select id FROM `sc` where city='North Myrtle Beach' && SIC_code='7219'DB:business_master_new
loadtime:0.25207901000977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norway' limit 1
loadtime:0.25212383270264 / seconds
Query Executed:select id FROM `sc` where city='Norway' && SIC_code='7219'DB:business_master_new
loadtime:0.25266098976135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Drive' limit 1
loadtime:0.25270295143127 / seconds
Query Executed:select id FROM `sc` where city='Ocean Drive' && SIC_code='7219'DB:business_master_new
loadtime:0.25300097465515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okatie' limit 1
loadtime:0.25305891036987 / seconds
Query Executed:select id FROM `sc` where city='Okatie' && SIC_code='7219'DB:business_master_new
loadtime:0.25375485420227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olanta' limit 1
loadtime:0.25378584861755 / seconds
Query Executed:select id FROM `sc` where city='Olanta' && SIC_code='7219'DB:business_master_new
loadtime:0.25425887107849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olar' limit 1
loadtime:0.25431799888611 / seconds
Query Executed:select id FROM `sc` where city='Olar' && SIC_code='7219'DB:business_master_new
loadtime:0.25479388237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orangeburg' limit 1
loadtime:0.25484895706177 / seconds
Query Executed:select id FROM `sc` where city='Orangeburg' && SIC_code='7219'DB:business_master_new
loadtime:0.2553288936615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pacolet' limit 1
loadtime:0.25535988807678 / seconds
Query Executed:select id FROM `sc` where city='Pacolet' && SIC_code='7219'DB:business_master_new
loadtime:0.25589299201965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pacolet Mills' limit 1
loadtime:0.25594401359558 / seconds
Query Executed:select id FROM `sc` where city='Pacolet Mills' && SIC_code='7219'DB:business_master_new
loadtime:0.25631999969482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pageland' limit 1
loadtime:0.25635695457458 / seconds
Query Executed:select id FROM `sc` where city='Pageland' && SIC_code='7219'DB:business_master_new
loadtime:0.25694179534912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pamplico' limit 1
loadtime:0.25698280334473 / seconds
Query Executed:select id FROM `sc` where city='Pamplico' && SIC_code='7219'DB:business_master_new
loadtime:0.2576630115509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parksville' limit 1
loadtime:0.25768899917603 / seconds
Query Executed:select id FROM `sc` where city='Parksville' && SIC_code='7219'DB:business_master_new
loadtime:0.25807881355286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parris Island' limit 1
loadtime:0.2581160068512 / seconds
Query Executed:select id FROM `sc` where city='Parris Island' && SIC_code='7219'DB:business_master_new
loadtime:0.25863790512085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patrick' limit 1
loadtime:0.25866889953613 / seconds
Query Executed:select id FROM `sc` where city='Patrick' && SIC_code='7219'DB:business_master_new
loadtime:0.25916886329651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pauline' limit 1
loadtime:0.25920701026917 / seconds
Query Executed:select id FROM `sc` where city='Pauline' && SIC_code='7219'DB:business_master_new
loadtime:0.25968480110168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pawleys Island' limit 1
loadtime:0.2597188949585 / seconds
Query Executed:select id FROM `sc` where city='Pawleys Island' && SIC_code='7219'DB:business_master_new
loadtime:0.26022291183472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paxville' limit 1
loadtime:0.26025199890137 / seconds
Query Executed:select id FROM `sc` where city='Paxville' && SIC_code='7219'DB:business_master_new
loadtime:0.26063585281372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peak' limit 1
loadtime:0.2606840133667 / seconds
Query Executed:select id FROM `sc` where city='Peak' && SIC_code='7219'DB:business_master_new
loadtime:0.26103091239929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelion' limit 1
loadtime:0.26113200187683 / seconds
Query Executed:select id FROM `sc` where city='Pelion' && SIC_code='7219'DB:business_master_new
loadtime:0.26165390014648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelzer' limit 1
loadtime:0.26169490814209 / seconds
Query Executed:select id FROM `sc` where city='Pelzer' && SIC_code='7219'DB:business_master_new
loadtime:0.26230788230896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pendleton' limit 1
loadtime:0.26235580444336 / seconds
Query Executed:select id FROM `sc` where city='Pendleton' && SIC_code='7219'DB:business_master_new
loadtime:0.26292586326599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perry' limit 1
loadtime:0.26299381256104 / seconds
Query Executed:select id FROM `sc` where city='Perry' && SIC_code='7219'DB:business_master_new
loadtime:0.263338804245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickens' limit 1
loadtime:0.2633798122406 / seconds
Query Executed:select id FROM `sc` where city='Pickens' && SIC_code='7219'DB:business_master_new
loadtime:0.26383399963379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piedmont' limit 1
loadtime:0.26389288902283 / seconds
Query Executed:select id FROM `sc` where city='Piedmont' && SIC_code='7219'DB:business_master_new
loadtime:0.26449394226074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pineland' limit 1
loadtime:0.26455283164978 / seconds
Query Executed:select id FROM `sc` where city='Pineland' && SIC_code='7219'DB:business_master_new
loadtime:0.26530289649963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pineville' limit 1
loadtime:0.26539397239685 / seconds
Query Executed:select id FROM `sc` where city='Pineville' && SIC_code='7219'DB:business_master_new
loadtime:0.26608395576477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinewood' limit 1
loadtime:0.26611280441284 / seconds
Query Executed:select id FROM `sc` where city='Pinewood' && SIC_code='7219'DB:business_master_new
loadtime:0.26661491394043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinopolis' limit 1
loadtime:0.26665997505188 / seconds
Query Executed:select id FROM `sc` where city='Pinopolis' && SIC_code='7219'DB:business_master_new
loadtime:0.26735901832581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plum Branch' limit 1
loadtime:0.26738882064819 / seconds
Query Executed:select id FROM `sc` where city='Plum Branch' && SIC_code='7219'DB:business_master_new
loadtime:0.26790595054626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomaria' limit 1
loadtime:0.2679648399353 / seconds
Query Executed:select id FROM `sc` where city='Pomaria' && SIC_code='7219'DB:business_master_new
loadtime:0.26873588562012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Royal' limit 1
loadtime:0.26876997947693 / seconds
Query Executed:select id FROM `sc` where city='Port Royal' && SIC_code='7219'DB:business_master_new
loadtime:0.26943778991699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prosperity' limit 1
loadtime:0.26950478553772 / seconds
Query Executed:select id FROM `sc` where city='Prosperity' && SIC_code='7219'DB:business_master_new
loadtime:0.27014684677124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinby' limit 1
loadtime:0.27018785476685 / seconds
Query Executed:select id FROM `sc` where city='Quinby' && SIC_code='7219'DB:business_master_new
loadtime:0.27063488960266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rains' limit 1
loadtime:0.27069187164307 / seconds
Query Executed:select id FROM `sc` where city='Rains' && SIC_code='7219'DB:business_master_new
loadtime:0.27125000953674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ravenel' limit 1
loadtime:0.27134990692139 / seconds
Query Executed:select id FROM `sc` where city='Ravenel' && SIC_code='7219'DB:business_master_new
loadtime:0.27196192741394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reevesville' limit 1
loadtime:0.27202892303467 / seconds
Query Executed:select id FROM `sc` where city='Reevesville' && SIC_code='7219'DB:business_master_new
loadtime:0.27284288406372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reidville' limit 1
loadtime:0.27291679382324 / seconds
Query Executed:select id FROM `sc` where city='Reidville' && SIC_code='7219'DB:business_master_new
loadtime:0.27356600761414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rembert' limit 1
loadtime:0.2736189365387 / seconds
Query Executed:select id FROM `sc` where city='Rembert' && SIC_code='7219'DB:business_master_new
loadtime:0.27431797981262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richburg' limit 1
loadtime:0.27437591552734 / seconds
Query Executed:select id FROM `sc` where city='Richburg' && SIC_code='7219'DB:business_master_new
loadtime:0.27501392364502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland' limit 1
loadtime:0.27508997917175 / seconds
Query Executed:select id FROM `sc` where city='Richland' && SIC_code='7219'DB:business_master_new
loadtime:0.27548480033875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridge Spring' limit 1
loadtime:0.27553200721741 / seconds
Query Executed:select id FROM `sc` where city='Ridge Spring' && SIC_code='7219'DB:business_master_new
loadtime:0.27601599693298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeland' limit 1
loadtime:0.27605891227722 / seconds
Query Executed:select id FROM `sc` where city='Ridgeland' && SIC_code='7219'DB:business_master_new
loadtime:0.27664279937744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeville' limit 1
loadtime:0.2766809463501 / seconds
Query Executed:select id FROM `sc` where city='Ridgeville' && SIC_code='7219'DB:business_master_new
loadtime:0.27719187736511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:0.27722883224487 / seconds
Query Executed:select id FROM `sc` where city='Ridgeway' && SIC_code='7219'DB:business_master_new
loadtime:0.27799582481384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rimini' limit 1
loadtime:0.27803993225098 / seconds
Query Executed:select id FROM `sc` where city='Rimini' && SIC_code='7219'DB:business_master_new
loadtime:0.27845788002014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rion' limit 1
loadtime:0.27848982810974 / seconds
Query Executed:select id FROM `sc` where city='Rion' && SIC_code='7219'DB:business_master_new
loadtime:0.27901792526245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ritter' limit 1
loadtime:0.27909088134766 / seconds
Query Executed:select id FROM `sc` where city='Ritter' && SIC_code='7219'DB:business_master_new
loadtime:0.27951383590698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Hill' limit 1
loadtime:0.27956485748291 / seconds
Query Executed:select id FROM `sc` where city='Rock Hill' && SIC_code='7219'DB:business_master_new
loadtime:0.28020882606506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roebuck' limit 1
loadtime:0.28031086921692 / seconds
Query Executed:select id FROM `sc` where city='Roebuck' && SIC_code='7219'DB:business_master_new
loadtime:0.28111886978149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Round O' limit 1
loadtime:0.28117084503174 / seconds
Query Executed:select id FROM `sc` where city='Round O' && SIC_code='7219'DB:business_master_new
loadtime:0.2818329334259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowesville' limit 1
loadtime:0.28194499015808 / seconds
Query Executed:select id FROM `sc` where city='Rowesville' && SIC_code='7219'DB:business_master_new
loadtime:0.2825288772583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruby' limit 1
loadtime:0.28256297111511 / seconds
Query Executed:select id FROM `sc` where city='Ruby' && SIC_code='7219'DB:business_master_new
loadtime:0.28319978713989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruffin' limit 1
loadtime:0.28325200080872 / seconds
Query Executed:select id FROM `sc` where city='Ruffin' && SIC_code='7219'DB:business_master_new
loadtime:0.2841420173645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Russellville' limit 1
loadtime:0.28421092033386 / seconds
Query Executed:select id FROM `sc` where city='Russellville' && SIC_code='7219'DB:business_master_new
loadtime:0.28473901748657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint George' limit 1
loadtime:0.28478097915649 / seconds
Query Executed:select id FROM `sc` where city='Saint George' && SIC_code='7219'DB:business_master_new
loadtime:0.28551983833313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Helena Island' limit 1
loadtime:0.28556180000305 / seconds
Query Executed:select id FROM `sc` where city='Saint Helena Island' && SIC_code='7219'DB:business_master_new
loadtime:0.28639984130859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Matthews' limit 1
loadtime:0.28645181655884 / seconds
Query Executed:select id FROM `sc` where city='Saint Matthews' && SIC_code='7219'DB:business_master_new
loadtime:0.28711199760437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Stephen' limit 1
loadtime:0.28722500801086 / seconds
Query Executed:select id FROM `sc` where city='Saint Stephen' && SIC_code='7219'DB:business_master_new
loadtime:0.28804397583008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.28812098503113 / seconds
Query Executed:select id FROM `sc` where city='Salem' && SIC_code='7219'DB:business_master_new
loadtime:0.28871393203735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salley' limit 1
loadtime:0.28878998756409 / seconds
Query Executed:select id FROM `sc` where city='Salley' && SIC_code='7219'DB:business_master_new
loadtime:0.28963279724121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salters' limit 1
loadtime:0.28966689109802 / seconds
Query Executed:select id FROM `sc` where city='Salters' && SIC_code='7219'DB:business_master_new
loadtime:0.29039478302002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saluda' limit 1
loadtime:0.29046392440796 / seconds
Query Executed:select id FROM `sc` where city='Saluda' && SIC_code='7219'DB:business_master_new
loadtime:0.29118895530701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Springs' limit 1
loadtime:0.29124283790588 / seconds
Query Executed:select id FROM `sc` where city='Sandy Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.29186201095581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santee' limit 1
loadtime:0.29198598861694 / seconds
Query Executed:select id FROM `sc` where city='Santee' && SIC_code='7219'DB:business_master_new
loadtime:0.29272198677063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sardinia' limit 1
loadtime:0.29277181625366 / seconds
Query Executed:select id FROM `sc` where city='Sardinia' && SIC_code='7219'DB:business_master_new
loadtime:0.29321098327637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotia' limit 1
loadtime:0.29327583312988 / seconds
Query Executed:select id FROM `sc` where city='Scotia' && SIC_code='7219'DB:business_master_new
loadtime:0.29363489151001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scranton' limit 1
loadtime:0.29405093193054 / seconds
Query Executed:select id FROM `sc` where city='Scranton' && SIC_code='7219'DB:business_master_new
loadtime:0.29466485977173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seabrook' limit 1
loadtime:0.29472494125366 / seconds
Query Executed:select id FROM `sc` where city='Seabrook' && SIC_code='7219'DB:business_master_new
loadtime:0.29544997215271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sellers' limit 1
loadtime:0.29550886154175 / seconds
Query Executed:select id FROM `sc` where city='Sellers' && SIC_code='7219'DB:business_master_new
loadtime:0.29596781730652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:0.29600501060486 / seconds
Query Executed:select id FROM `sc` where city='Seneca' && SIC_code='7219'DB:business_master_new
loadtime:0.29658389091492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.29667091369629 / seconds
Query Executed:select id FROM `sc` where city='Sharon' && SIC_code='7219'DB:business_master_new
loadtime:0.29730987548828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaw A F B' limit 1
loadtime:0.29735589027405 / seconds
Query Executed:select id FROM `sc` where city='Shaw A F B' && SIC_code='7219'DB:business_master_new
loadtime:0.29769086837769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaw Afb' limit 1
loadtime:0.29771995544434 / seconds
Query Executed:select id FROM `sc` where city='Shaw Afb' && SIC_code='7219'DB:business_master_new
loadtime:0.29825496673584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon' limit 1
loadtime:0.29831790924072 / seconds
Query Executed:select id FROM `sc` where city='Sheldon' && SIC_code='7219'DB:business_master_new
loadtime:0.29892778396606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shulerville' limit 1
loadtime:0.29898691177368 / seconds
Query Executed:select id FROM `sc` where city='Shulerville' && SIC_code='7219'DB:business_master_new
loadtime:0.29945087432861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silverstreet' limit 1
loadtime:0.29953789710999 / seconds
Query Executed:select id FROM `sc` where city='Silverstreet' && SIC_code='7219'DB:business_master_new
loadtime:0.29999399185181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Simpsonville' limit 1
loadtime:0.30003786087036 / seconds
Query Executed:select id FROM `sc` where city='Simpsonville' && SIC_code='7219'DB:business_master_new
loadtime:0.30049681663513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Six Mile' limit 1
loadtime:0.30054998397827 / seconds
Query Executed:select id FROM `sc` where city='Six Mile' && SIC_code='7219'DB:business_master_new
loadtime:0.30116581916809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Slater' limit 1
loadtime:0.3012068271637 / seconds
Query Executed:select id FROM `sc` where city='Slater' && SIC_code='7219'DB:business_master_new
loadtime:0.30155301094055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smoaks' limit 1
loadtime:0.3015878200531 / seconds
Query Executed:select id FROM `sc` where city='Smoaks' && SIC_code='7219'DB:business_master_new
loadtime:0.30206894874573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smyrna' limit 1
loadtime:0.3021228313446 / seconds
Query Executed:select id FROM `sc` where city='Smyrna' && SIC_code='7219'DB:business_master_new
loadtime:0.3025918006897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Society Hill' limit 1
loadtime:0.30262684822083 / seconds
Query Executed:select id FROM `sc` where city='Society Hill' && SIC_code='7219'DB:business_master_new
loadtime:0.30313992500305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spartanburg' limit 1
loadtime:0.30318284034729 / seconds
Query Executed:select id FROM `sc` where city='Spartanburg' && SIC_code='7219'DB:business_master_new
loadtime:0.30370092391968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.3037428855896 / seconds
Query Executed:select id FROM `sc` where city='Springfield' && SIC_code='7219'DB:business_master_new
loadtime:0.30430197715759 / seconds
Query loaded from cache:select * from geodata_geocity where city='St George' limit 1
loadtime:0.30434083938599 / seconds
Query Executed:select id FROM `sc` where city='St George' && SIC_code='7219'DB:business_master_new
loadtime:0.30478596687317 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Helena Island' limit 1
loadtime:0.30486083030701 / seconds
Query Executed:select id FROM `sc` where city='St Helena Island' && SIC_code='7219'DB:business_master_new
loadtime:0.30540180206299 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Matthews' limit 1
loadtime:0.30543184280396 / seconds
Query Executed:select id FROM `sc` where city='St Matthews' && SIC_code='7219'DB:business_master_new
loadtime:0.30593085289001 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Stephen' limit 1
loadtime:0.30597591400146 / seconds
Query Executed:select id FROM `sc` where city='St Stephen' && SIC_code='7219'DB:business_master_new
loadtime:0.30625200271606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Starr' limit 1
loadtime:0.30629181861877 / seconds
Query Executed:select id FROM `sc` where city='Starr' && SIC_code='7219'DB:business_master_new
loadtime:0.30682682991028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Startex' limit 1
loadtime:0.30690383911133 / seconds
Query Executed:select id FROM `sc` where city='Startex' && SIC_code='7219'DB:business_master_new
loadtime:0.30739879608154 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Park' limit 1
loadtime:0.30747485160828 / seconds
Query Executed:select id FROM `sc` where city='State Park' && SIC_code='7219'DB:business_master_new
loadtime:0.30802583694458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sullivans Island' limit 1
loadtime:0.30805683135986 / seconds
Query Executed:select id FROM `sc` where city='Sullivans Island' && SIC_code='7219'DB:business_master_new
loadtime:0.30852079391479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summerton' limit 1
loadtime:0.30857801437378 / seconds
Query Executed:select id FROM `sc` where city='Summerton' && SIC_code='7219'DB:business_master_new
loadtime:0.30905890464783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summerville' limit 1
loadtime:0.30908894538879 / seconds
Query Executed:select id FROM `sc` where city='Summerville' && SIC_code='7219'DB:business_master_new
loadtime:0.30954790115356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumter' limit 1
loadtime:0.30962991714478 / seconds
Query Executed:select id FROM `sc` where city='Sumter' && SIC_code='7219'DB:business_master_new
loadtime:0.31033778190613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunset' limit 1
loadtime:0.31038784980774 / seconds
Query Executed:select id FROM `sc` where city='Sunset' && SIC_code='7219'DB:business_master_new
loadtime:0.31115388870239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surfside Beach' limit 1
loadtime:0.31118488311768 / seconds
Query Executed:select id FROM `sc` where city='Surfside Beach' && SIC_code='7219'DB:business_master_new
loadtime:0.31185483932495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swansea' limit 1
loadtime:0.31197786331177 / seconds
Query Executed:select id FROM `sc` where city='Swansea' && SIC_code='7219'DB:business_master_new
loadtime:0.31242084503174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sycamore' limit 1
loadtime:0.31246089935303 / seconds
Query Executed:select id FROM `sc` where city='Sycamore' && SIC_code='7219'DB:business_master_new
loadtime:0.3127269744873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tamassee' limit 1
loadtime:0.31276082992554 / seconds
Query Executed:select id FROM `sc` where city='Tamassee' && SIC_code='7219'DB:business_master_new
loadtime:0.31313800811768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tatum' limit 1
loadtime:0.31317901611328 / seconds
Query Executed:select id FROM `sc` where city='Tatum' && SIC_code='7219'DB:business_master_new
loadtime:0.31348896026611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylors' limit 1
loadtime:0.3135199546814 / seconds
Query Executed:select id FROM `sc` where city='Taylors' && SIC_code='7219'DB:business_master_new
loadtime:0.31398797035217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tigerville' limit 1
loadtime:0.3140389919281 / seconds
Query Executed:select id FROM `sc` where city='Tigerville' && SIC_code='7219'DB:business_master_new
loadtime:0.31438684463501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tillman' limit 1
loadtime:0.31441593170166 / seconds
Query Executed:select id FROM `sc` where city='Tillman' && SIC_code='7219'DB:business_master_new
loadtime:0.31498599052429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timmonsville' limit 1
loadtime:0.31505799293518 / seconds
Query Executed:select id FROM `sc` where city='Timmonsville' && SIC_code='7219'DB:business_master_new
loadtime:0.31557178497314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townville' limit 1
loadtime:0.31561088562012 / seconds
Query Executed:select id FROM `sc` where city='Townville' && SIC_code='7219'DB:business_master_new
loadtime:0.31610584259033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Travelers Rest' limit 1
loadtime:0.31614279747009 / seconds
Query Executed:select id FROM `sc` where city='Travelers Rest' && SIC_code='7219'DB:business_master_new
loadtime:0.31658601760864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trenton' limit 1
loadtime:0.31662893295288 / seconds
Query Executed:select id FROM `sc` where city='Trenton' && SIC_code='7219'DB:business_master_new
loadtime:0.31708192825317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trio' limit 1
loadtime:0.31712293624878 / seconds
Query Executed:select id FROM `sc` where city='Trio' && SIC_code='7219'DB:business_master_new
loadtime:0.31734681129456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:0.3173828125 / seconds
Query Executed:select id FROM `sc` where city='Troy' && SIC_code='7219'DB:business_master_new
loadtime:0.31782078742981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turbeville' limit 1
loadtime:0.31784892082214 / seconds
Query Executed:select id FROM `sc` where city='Turbeville' && SIC_code='7219'DB:business_master_new
loadtime:0.31830382347107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ulmer' limit 1
loadtime:0.31834387779236 / seconds
Query Executed:select id FROM `sc` where city='Ulmer' && SIC_code='7219'DB:business_master_new
loadtime:0.31873178482056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Una' limit 1
loadtime:0.31876087188721 / seconds
Query Executed:select id FROM `sc` where city='Una' && SIC_code='7219'DB:business_master_new
loadtime:0.31911993026733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:0.31917881965637 / seconds
Query Executed:select id FROM `sc` where city='Union' && SIC_code='7219'DB:business_master_new
loadtime:0.31964182853699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Wyck' limit 1
loadtime:0.31967186927795 / seconds
Query Executed:select id FROM `sc` where city='Van Wyck' && SIC_code='7219'DB:business_master_new
loadtime:0.32004690170288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vance' limit 1
loadtime:0.32009100914001 / seconds
Query Executed:select id FROM `sc` where city='Vance' && SIC_code='7219'DB:business_master_new
loadtime:0.32056093215942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Varnville' limit 1
loadtime:0.3206148147583 / seconds
Query Executed:select id FROM `sc` where city='Varnville' && SIC_code='7219'DB:business_master_new
loadtime:0.32107996940613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vaucluse' limit 1
loadtime:0.32112383842468 / seconds
Query Executed:select id FROM `sc` where city='Vaucluse' && SIC_code='7219'DB:business_master_new
loadtime:0.32138586044312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wadmalaw Island' limit 1
loadtime:0.32141590118408 / seconds
Query Executed:select id FROM `sc` where city='Wadmalaw Island' && SIC_code='7219'DB:business_master_new
loadtime:0.32187700271606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wagener' limit 1
loadtime:0.32192182540894 / seconds
Query Executed:select id FROM `sc` where city='Wagener' && SIC_code='7219'DB:business_master_new
loadtime:0.32237195968628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walhalla' limit 1
loadtime:0.32240200042725 / seconds
Query Executed:select id FROM `sc` where city='Walhalla' && SIC_code='7219'DB:business_master_new
loadtime:0.32283878326416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallace' limit 1
loadtime:0.32288789749146 / seconds
Query Executed:select id FROM `sc` where city='Wallace' && SIC_code='7219'DB:business_master_new
loadtime:0.32333183288574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walterboro' limit 1
loadtime:0.32336187362671 / seconds
Query Executed:select id FROM `sc` where city='Walterboro' && SIC_code='7219'DB:business_master_new
loadtime:0.32381200790405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wando' limit 1
loadtime:0.32385182380676 / seconds
Query Executed:select id FROM `sc` where city='Wando' && SIC_code='7219'DB:business_master_new
loadtime:0.3241548538208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ward' limit 1
loadtime:0.32419395446777 / seconds
Query Executed:select id FROM `sc` where city='Ward' && SIC_code='7219'DB:business_master_new
loadtime:0.32464694976807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ware Shoals' limit 1
loadtime:0.32468390464783 / seconds
Query Executed:select id FROM `sc` where city='Ware Shoals' && SIC_code='7219'DB:business_master_new
loadtime:0.32521295547485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrenville' limit 1
loadtime:0.32524490356445 / seconds
Query Executed:select id FROM `sc` where city='Warrenville' && SIC_code='7219'DB:business_master_new
loadtime:0.32569789886475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterloo' limit 1
loadtime:0.32573890686035 / seconds
Query Executed:select id FROM `sc` where city='Waterloo' && SIC_code='7219'DB:business_master_new
loadtime:0.32620978355408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wedgefield' limit 1
loadtime:0.32625198364258 / seconds
Query Executed:select id FROM `sc` where city='Wedgefield' && SIC_code='7219'DB:business_master_new
loadtime:0.32673192024231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellford' limit 1
loadtime:0.32676482200623 / seconds
Query Executed:select id FROM `sc` where city='Wellford' && SIC_code='7219'DB:business_master_new
loadtime:0.32722997665405 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Columbia' limit 1
loadtime:0.32727289199829 / seconds
Query Executed:select id FROM `sc` where city='West Columbia' && SIC_code='7219'DB:business_master_new
loadtime:0.32771682739258 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Union' limit 1
loadtime:0.32775783538818 / seconds
Query Executed:select id FROM `sc` where city='West Union' && SIC_code='7219'DB:business_master_new
loadtime:0.32823300361633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:0.32826280593872 / seconds
Query Executed:select id FROM `sc` where city='Westminster' && SIC_code='7219'DB:business_master_new
loadtime:0.32873678207397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westville' limit 1
loadtime:0.32877779006958 / seconds
Query Executed:select id FROM `sc` where city='Westville' && SIC_code='7219'DB:business_master_new
loadtime:0.32919788360596 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Rock' limit 1
loadtime:0.3292248249054 / seconds
Query Executed:select id FROM `sc` where city='White Rock' && SIC_code='7219'DB:business_master_new
loadtime:0.32969093322754 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Stone' limit 1
loadtime:0.32973599433899 / seconds
Query Executed:select id FROM `sc` where city='White Stone' && SIC_code='7219'DB:business_master_new
loadtime:0.33004879951477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitmire' limit 1
loadtime:0.33009195327759 / seconds
Query Executed:select id FROM `sc` where city='Whitmire' && SIC_code='7219'DB:business_master_new
loadtime:0.33054399490356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williams' limit 1
loadtime:0.3305778503418 / seconds
Query Executed:select id FROM `sc` where city='Williams' && SIC_code='7219'DB:business_master_new
loadtime:0.33091187477112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamston' limit 1
loadtime:0.3309428691864 / seconds
Query Executed:select id FROM `sc` where city='Williamston' && SIC_code='7219'DB:business_master_new
loadtime:0.33140301704407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williston' limit 1
loadtime:0.33144497871399 / seconds
Query Executed:select id FROM `sc` where city='Williston' && SIC_code='7219'DB:business_master_new
loadtime:0.3319399356842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:0.33199691772461 / seconds
Query Executed:select id FROM `sc` where city='Windsor' && SIC_code='7219'DB:business_master_new
loadtime:0.33243894577026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winnsboro' limit 1
loadtime:0.33246898651123 / seconds
Query Executed:select id FROM `sc` where city='Winnsboro' && SIC_code='7219'DB:business_master_new
loadtime:0.33295488357544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodruff' limit 1
loadtime:0.33299398422241 / seconds
Query Executed:select id FROM `sc` where city='Woodruff' && SIC_code='7219'DB:business_master_new
loadtime:0.33345580101013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yemassee' limit 1
loadtime:0.3334949016571 / seconds
Query Executed:select id FROM `sc` where city='Yemassee' && SIC_code='7219'DB:business_master_new
loadtime:0.33396100997925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yonges Island' limit 1
loadtime:0.3339958190918 / seconds
Query Executed:select id FROM `sc` where city='Yonges Island' && SIC_code='7219'DB:business_master_new
loadtime:0.33425283432007 / seconds
Query loaded from cache:select * from geodata_geocity where city='York' limit 1
loadtime:0.33429193496704 / seconds
Query Executed:select id FROM `sc` where city='York' && SIC_code='7219'DB:business_master_new
loadtime:0.33477997779846 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.33485794067383 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.33505582809448 / seconds
Operation template executed (chunk cache operation)
loadtime:0.33513593673706 / seconds
template override:Default
loadtime:0.33515596389771 / 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.33707284927368 / seconds
Template Constructed, Array Rows:49
loadtime:0.33777594566345 / seconds
TOTAL EXECUTION TIME: 0.33722
loadtime:0.33804488182068 / 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] => laundry-and-garment-services-nec [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.33805894851685
TOTAL KEY ARRAYS: 69